/**
* Creates data provider instance with search query applied
*
* @param array $params
*
* @return ActiveDataProvider
*/
public function search($params)
{
$query = U2WarehouseModel::find();
$dataProvider = new ActiveDataProvider(['query' => $query]);
$this->load($params);
if (!$this->validate()) {
$query->where('1=0');
return $dataProvider;
}
$query->andFilterWhere(['warehouse_id' => $this->warehouse_id, 'user_id' => $this->user_id, 'created_at' => $this->created_at, 'created_by' => $this->created_by, 'updated_at' => $this->updated_at, 'updated_by' => $this->updated_by]);
return $dataProvider;
}
public function assigned()
{
$dwhse = \app\models\master\U2Warehouse::find()->select('warehouse_id')->where('user_id=:duser', [':duser' => \Yii::$app->user->id])->column();
return $this->andFilterWhere(['in', 'id', count($dwhse) > 0 ? $dwhse : [-1]]);
}