public function search($params) { $query = Diagnosa::find(); $dataProvider = new ActiveDataProvider(['query' => $query, 'sort' => ['defaultOrder' => ['penyakit_id' => 'DESC', 'gejala_id' => 'DESC']], 'pagination' => ['defaultPageSize' => 10]]); $this->load($params); if (!$this->validate()) { $query->where('1=0'); return $dataProvider; } $dataProvider->query->joinWith(['penyakit' => function ($q) { $q->from('penyakit p'); // join with tabel alias }]); $dataProvider->query->joinWith(['gejala' => function ($q) { $q->from('penyakit_gejala pg'); // join with tabel alias }]); $query->orFilterWhere(['like', 'p.nama_penyakit', $this->srch_all])->orFilterWhere(['like', 'pg.nama_gejala', $this->srch_all])->orFilterWhere(['like', 'mb', $this->srch_all])->orFilterWhere(['like', 'md', $this->srch_all]); // SELESAI EDIT DISINI return $dataProvider; }
<?php Panel::end(); if (!empty($_POST['Diagnosa']['proses'])) { // print_r($_POST['Diagnosa']['proses']); $aa = $_POST['Diagnosa']['proses']; $data = array(); foreach ($aa as $values) { $data = [$values]; } // print_r($data); function cf($mb, $md) { $aa = $mb + $md * (1 - $mb); return $aa; } $diagnosa = \common\models\Diagnosa::find()->where(['gejala_id' => $aa])->orderBy('penyakit_id')->all(); $cfa = array(); foreach ($diagnosa as $key => $value) { $cfa[] = [$value->mb, $value->md]; } $dd = \common\models\Diagnosa::diagnosaData(); $mb = array(); for ($i = 0; $i < count($dd); $i++) { $mb[] = explode(',', $dd[$i]['mb']); $md[] = explode(',', $dd[$i]['md']); // $dd->mbHtg($dd[$i]['mb']); } $cc = \common\models\Diagnosa::mbHtg($mb[0]); $mbbb = 0; //$dd->mbHtg($mb); echo "<pre>";