/** * Creates data provider instance with search query applied * * @param array $params * * @return ActiveDataProvider */ public function search($params) { $query = Bnpk::find(); $dataProvider = new ActiveDataProvider(['query' => $query]); $this->load($params); if (!$this->validate()) { // uncomment the following line if you do not want to return any records when validation fails // $query->where('0=1'); return $dataProvider; } $query->andFilterWhere(['id' => $this->id, 'maBA' => $this->maBA, 'maPK' => $this->maPK, 'ngayKham' => $this->ngayKham]); $query->andFilterWhere(['like', 'ketQua', $this->ketQua]); return $dataProvider; }
public function actionStatistics($bieudo) { if ($bieudo == 'tonghop') { $tonghop = array(); $tonghop['Số lượng hồ sơ bệnh nhân lưu trong hệ thống'] = count(Benhnhan::find()->all()); $tonghop['Số lượng bệnh nhân nội trú'] = count(Noitru::find()->all()); $tonghop['Số lượng nhân viên'] = count(Nhanvien::find()->all()); $tonghop['Số lượng phòng khám'] = count(Phongkham::find()->all()); $tonghop['Số lượng khoa'] = count(Khoa::find()->all()); return $this->render('statistics', ['tonghop' => $tonghop]); } if ($bieudo == 'benhnhan') { $count = array(); $count['0'] = 0; $count['1'] = 0; $count['2'] = 0; $count['3'] = 0; $array = $this->actionThang(); $benhan = Benhan::find()->all(); foreach ($benhan as $ba) { if (date('m', $ba->created_at) == $array['0']) { $count['0'] = $count[0] + 1; } if (date('m', $ba->created_at) == $array['1']) { $count['1']++; } if (date('m', $ba->created_at) == $array['2']) { $count['2']++; } if (date('m', $ba->created_at) == $array['3']) { $count['3']++; } } return $this->render('statisticsBN', ['thang' => $array, 'value' => $count]); } $khoa = Khoa::find()->all(); $dskhoa = array(); $dsmakhoa = array(); $count = array(); $j = 0; foreach ($khoa as $k) { $dskhoa["{$j}"] = $k->tenKhoa; $dsmakhoa["{$j}"] = $k->id; $count["{$j}"] = 0; $j++; } $thang = 0; $now = getdate(); if ($now['mon'] == 1) { $thang = 12; } else { $thang = $now['mon']; } $benhan = Benhan::find()->all(); foreach (Bnpk::find()->all() as $lk) { if (date('m', $lk->ngayKham == $thang)) { for ($i = 0; $i < count($khoa); $i++) { if (Phongkham::findOne(['id' => $lk->maPK])->maKhoa == $dsmakhoa["{$i}"]) { $count["{$i}"]++; } } } } return $this->render('statisticsLK', ['thang' => $thang, 'dskhoa' => $dskhoa, 'value' => $count, 'count' => $j]); }
<?php use yii\helpers\Html; use yii\widgets\DetailView; /* @var $this yii\web\View */ /* @var $model app\models\Bnpk */ $this->title = $model->id; $this->params['breadcrumbs'][] = ['label' => 'Bnpks', 'url' => ['index']]; $this->params['breadcrumbs'][] = $this->title; ?> <a href='javascript:history.go(-1)' class="btn btn-warning">Quay lại trang trước</a> <a href="<?php echo Yii::$app->request->baseUrl; ?> /bnpk?benhan=<?php echo \app\models\Bnpk::findOne(['id' => $_GET['id']])->maBA; ?> " class="btn btn-success">Danh sách các lượt khám</a> <div class="bnpk-view"> <h1><?php echo Html::encode($this->title); ?> </h1> <p> <?php echo Html::a('Update', ['update', 'id' => $model->id], ['class' => 'btn btn-primary']); ?> <?php
/** * Finds the Bnpk model based on its primary key value. * If the model is not found, a 404 HTTP exception will be thrown. * @param integer $id * @return Bnpk the loaded model * @throws NotFoundHttpException if the model cannot be found */ protected function findModel($id) { if (($model = Bnpk::findOne($id)) !== null) { return $model; } else { throw new NotFoundHttpException('The requested page does not exist.'); } }