public function search($params)
{
$query = Penyakit::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(['penyakitJenis' => function ($q) {
$q->from('penyakit_jenis pj');
// join with tabel alias
}]);
$query->andFilterWhere(['penyakit.status' => $this->status]);
$query->orFilterWhere(['like', 'nama_penyakit', $this->srch_all])->orFilterWhere(['like', 'ket', $this->srch_all])->orFilterWhere(['like', 'pj.nama_jenis', $this->srch_all]);
return $dataProvider;
}
public function listPenyakit()
{
$data = ArrayHelper::map(\app\models\Penyakit::find()->where(['status' => 1])->all(), 'id', 'nama_penyakit');
return $data;
}
