PHP pahanini\refiner\common Match Examples

Example #1

File: Match.php Project: pahanini/yii2-refiner

 /**
  * @param \yii\db\QueryInterface $query
  * @param array $params
  * @return \yii\db\QueryInterface
  */
 public function refine($query, $params)
 {
     $where = ['or'];
     $bind = [];
     foreach ($params as $key => $val) {
         $name = ":{$this->name}_{$key}";
         $where[] = "{$this->columnName} LIKE {$name}";
         $bind[$name] = $val . '%';
     }
     $query->andWhere($where, $bind);
     return parent::refine($query, $params);
 }

Example #2

File: Match.php Project: pahanini/yii2-refiner

 public function refine($query, $params)
 {
     $query->match($params);
     return parent::refine($query, $params);
 }