Add condition if field exists

Question

Add condition if field exists

marek1989 Jun '14

Created Jun '14	Last Reply May '16	Replies 1	Views 1032	Votes 0

marek1989 6.2k

Jun '14

I am trying to do translations. And what I want to do is to have e.g. models like this:

Country
CountryTranslation
Product
ProductTranslation

In Translation models I got field "locale". Is there a way that if model contains field "locale", then add extra condition "AND locale='en'", so it would work dynamically, instead of for every "find" writing condition with "locale"?

I know that there in Doctrine 2 there is something what can be used to do this and it is called filter.

Phalcon · Answer 1 · 2014-06-29T11:22:05-07:00

You can try something like this:

<?php

class MyModel extends Phalcon\Mvc\Model
{
    public static function find($parameters=null)
    {
        if (isset($parameters[0]) {
            $parameters[0] = $parameters[0] . ' AND locale = "en"';
        } else {
            if (isset($parameters["conditions"]) {
                $parameters["conditions"] = $parameters["conditions"] . ' AND locale = "en"';
            }
        }
        return parent::find($parameters);
    }
}