public function search($params)
{
$query = \app\models\Union::query(['in', 'moderation_status', [0, 1]])->orderBy(['date_insert' => SORT_DESC]);
$dataProvider = new ActiveDataProvider(['query' => $query, 'pagination' => ['pageSize' => 20]]);
// load the search form data and validate
if (!($this->load($params) && $this->validate())) {
return $dataProvider;
}
// adjust the query by adding the filters
$query->andFilterWhere(['like', 'name', $this->name]);
return $dataProvider;
}
public function actionObjects()
{
$items = \app\models\Union::query(['user_id' => \Yii::$app->user->getId()])->andWhere(['in', 'moderation_status', [0, 1]])->orderBy(['date_insert' => SORT_DESC])->all();
return $this->render(['items' => $items]);
}
/**
* @return array gs_unions.*
*/
public function getUnions()
{
return Union::query(['tree_node_id' => $this->getId(), 'moderation_status' => 1])->orderBy(['sort_index' => SORT_ASC])->orderBy(['if(sort_index is NULL, 1, 0)' => SORT_ASC, 'sort_index' => SORT_ASC])->all();
}
public function actionIndex()
{
return $this->render(['items' => Union::query(['moderation_status' => null])->all()]);
}
