public function search($params) { $query = Agama::find(); $dataProvider = new ActiveDataProvider(['query' => $query, 'sort' => ['defaultOrder' => ['id' => 'DESC']], 'pagination' => ['defaultPageSize' => 10]]); $this->load($params); if (!$this->validate()) { $query->where('1=0'); return $dataProvider; } /* $dataProvider->query->joinWith([ 'parentGroup'=> function ($q){ $q->from('tb_group tb_group2'); // join with tabel alias } ]); $query->andFilterWhere(['like', 'tb_group.name', $this->name]); $query->andFilterWhere(['like', 'tb_group2.name', $this->parent_id]); // SELESAI EDIT DISINI */ $query->andFilterWhere(['status' => $this->status]); $query->andFilterWhere(['like', 'name', $this->srch_all]); return $dataProvider; }
protected function findModel($id) { if (($model = Agama::findOne($id)) !== null) { return $model; } else { throw new NotFoundHttpException('The requested page does not exist.'); } }
public function listAgama() { $data = ArrayHelper::map(\backend\models\Agama::find()->where(['status' => 1])->all(), 'id', 'name'); return $data; }