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;
}
