Esempio n. 1
0
 /**
  * (non-PHPdoc)
  * @see \Koldy\Db\Select::getQuery()
  */
 protected function getQuery()
 {
     if ($this->searchTerm !== null) {
         // there is search term set, so we'll need to include this to where statements
         // but, there might be already some where statements in the query, so we'll create
         // new Where instance and we'll add that Where block with AND operator
         $where = Where::init();
         if ($this->searchFields !== null) {
             foreach ($this->searchFields as $field) {
                 $where->orWhereLike($field, "%{$this->searchTerm}%");
             }
         } else {
             foreach ($this->getFields() as $field) {
                 $where->orWhereLike($field['name'], "%{$this->searchTerm}%");
             }
         }
         $this->where($where);
     }
     return parent::getQuery();
 }