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()]); }