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>";
