public function search($params = []) { $query = parent::find()->distinct(); // ->where('cat_code=:cat_code',[':cat_code'=>$params['cat_code']]) // ->andWhere("value<>''"); return $query; }
public function search($params = []) { $frame = substr($params['vin'], 0, 5); $serial = substr($params['vin'], 6, 7); $query = parent::find(); $query->where('frame_code=:frame_code and serial_number=:serial_number', [':frame_code' => $frame, ':serial_number' => $serial])->limit(1); return $query; }
public function search($params = []) { $query = parent::find()->where('cat_code=:cat_code', [':cat_code' => $params['cat_code']]); return $query; }
public function search($params = []) { $query = parent::find(); return $query; }
public static function Frame($params) { $query = new ActiveRecord(); $frame = substr($params['vin'], 0, 5); $serial = substr($params['vin'], 6, 7); $query->find()->select('*')->from('v_frame')->where('frame_code=:frame_code and serial_number=:serial_number', [':frame_code' => $frame, ':serial_number' => $serial])->limit(1); $provider = new ActiveDataProvider(['query' => $query, 'pagination' => false]); return $provider; }
public function search($params = []) { $query = parent::find()->where('family=:family', [':family' => $params['family']]); return $query; }