Status::tableName() . '.name AS statusName ')
->joinWith([ 'types', 'moving', 'status', 'locations', 'regions', 'models', ])
->where([ 'in', Moving::tableName() . '.id', $query ])
- ->andWhere([ 'checked' => false ]);
+ ->andWhere([ 'checked' => 0 ]);
$dataProvider = new ActiveDataProvider([
'query' => $query,
$dataProvider = new ActiveDataProvider([
'query' => $query,
+ 'pagination' => [
+ 'pageSize' => \Yii::$app->session['pageSize'] ?? 20,
+ ],
]);
$dataProvider->setSort([
'id' => $this->id,
])->andFilterWhere([
'ilike', Status::tableName() . '.name', $this->statusName
- ])->andFilterWhere([
+ ])->andFilterWhere([ 'OR', [
'ilike', Models::tableName() . '.name', $this->modelName
- ])->andFilterWhere([
+ ], [
+ 'ilike', Items::tableName() . '.name', $this->modelName
+ ]])->andFilterWhere([
'ilike', Types::tableName() . '.name', $this->typeName
])->andFilterWhere([ 'OR', [
'ilike', Locations::tableName() . '.name', $this->regionName