public function search($params)
 {
     $query = DiagnosaUncertantyTerm::find();
     $dataProvider = new ActiveDataProvider(['query' => $query, 'sort' => ['defaultOrder' => ['id' => 'DESC']], 'pagination' => ['defaultPageSize' => 20]]);
     $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([
                 'id' => $this->id,
                 'cf' => $this->cf,
             ]);
     */
     $query->orFilterWhere(['like', 'uncertanty_term', $this->srch_all])->orFilterWhere(['like', 'cf', $this->srch_all]);
     return $dataProvider;
 }
Exemplo n.º 2
0
 protected function findModel($id)
 {
     if (($model = DiagnosaUncertantyTerm::findOne($id)) !== null) {
         return $model;
     } else {
         throw new NotFoundHttpException('The requested page does not exist.');
     }
 }