public function search($params) { $query = DiagnosaUser::find(); $dataProvider = new ActiveDataProvider(['query' => $query]); $this->load($params); if (!$this->validate()) { // uncomment the following line if you do not want to any records when validation fails // $query->where('0=1'); return $dataProvider; } /*$dataProvider->query->joinWith([ 'gejala'=> function ($q){ $q->from('penyakit_gejala pg'); // join with tabel alias } ]); $query->andFilterWhere(['like', 'pg.nama_gejala', $this->gejala_id]); */ // SELESAI EDIT DISINI $query->andFilterWhere(['id' => $this->id, 'user_id' => $this->user_id, 'diagnosa_ke' => $this->diagnosa_ke, 'diagnosa_date' => $this->diagnosa_date]); return $dataProvider; }
/** * @return \yii\db\ActiveQuery */ public function getDiagnosaUser() { return $this->hasOne(DiagnosaUser::className(), ['id' => 'diagnosa_user_id']); }