Use Criteria to get bind param with many models

Question

Use Criteria to get bind param with many models

minus2005 Sep '14

Created Sep '14	Last Reply Sep '14	Replies 2	Views 784	Votes 0

minus2005 1.5k

Sep '14

Using Criteria in only one model worked, but the next step i had some problems.

My models: People , Client ,Phone


    class People extends \Phalcon\Mvc\Model {
        protected $name;
        public function initialize()
      {
          $this->hasOne("id", "Client", "id_people");
      }


    class Client extends \Phalcon\Mvc\Model {
        protected $records;

        public function initialize()
      {
          $this->hasOne("id_people", "People", "id");
      }

My search form have both field : name, records,phone,email ...

I try

    $query = Criteria::fromInput($this->di, "Client", $_POST);

If a user search for field name my $query->getParams(); is empty. I tried extends my model Client but doesn`t work.

How I can use Criteria to execute one search with phone and/or name?

I want avoid traditional bind params and use fromInput.

RompePC · Answer 1 · 2014-09-21T12:31:38-07:00

$models = Model1::query()
                ->join('Model2', 'Model1.id = Model2.fk_id')
                ->where('blablabla')
                ...
                ->execute();

Replace Model1 and Model2 with your models in the order you want, and set the where() clause with the fields you want to use for the search.

BTW, I don't recommend you avoid bound parameters.

minus2005 · Answer 2 · 2014-09-21T13:45:24-07:00

I understand your point, but I want use Criteria::fromInput with getParams() to create the bind parameters on where() clause avoiding do it manually

RompePC · Answer 3 · 2014-09-21T13:57:15-07:00

Then try to replace Model::query() with Criteria::fromInput(), cause both methods return a Criteria. Other way I don't know how.