/**
* Creates data provider instance with search query applied
*
* @param array $params
*
* @return ActiveDataProvider
*/
public function search($params)
{
$this->load($params);
$sql_s = "select ";
$select = " o.*, sum(op.sum_price) as amount, p.birthday,p.cid, concat(p.pname,' ',p.fname,' ', p.lname ) as fullname,v.paid_money,v.rcpt_money,v.remain_money ,(v.paid_money - v.rcpt_money) as total ";
$from = " from ovst o ";
$join = "inner join opitemrece op on op.vn = o.vn ";
$join .= "inner join patient p on p.hn = o.hn ";
$join .= " inner join vn_stat v on v.vn = o.vn ";
$where = " where op.an is null ";
$groupby = " group by o.vn";
if (!is_null($this->vstdate) && strpos($this->vstdate, ' - ') !== false) {
list($start_date, $end_date) = explode(' - ', $this->vstdate);
//$query->andFilterWhere(['between', 'vstdate', $start_date, $end_date]);
//echo "asdfasfasdf";
$this->vstdate = null;
//print_r($query);
$where .= " and o.vstdate between '" . $start_date . "' and '" . $end_date . "'";
} else {
$where .= " and o.vstdate = CURDATE() ";
}
if ($this->pttype != '') {
$where .= " and o.pttype = '" . $this->pttype . "' ";
}
if ($this->hn != '') {
$where .= " and o.hn= '" . $this->hn . "' ";
}
if ($this->cid != '') {
$where .= " and o.hn= '" . $this->cid . "' ";
}
$sql = $sql_s . $select . $from . $join . $where . $groupby;
$count = Yii::$app->db2->createCommand($sql)->execute();
$dataProvider = new \yii\data\SqlDataProvider(['db' => 'db2', 'sql' => $sql, 'pagination' => ['pageSize' => 80], 'totalCount' => $count, 'sort' => ['attributes' => ['vstdate' => ['asc' => ['vstdate' => SORT_ASC], 'desc' => ['vstdate' => SORT_DESC], 'default' => SORT_DESC, 'label' => 'Vist Date'], 'vn' => ['asc' => ['vn' => SORT_ASC], 'desc' => ['vn' => SORT_DESC], 'default' => SORT_DESC, 'label' => 'VN'], 'hn' => ['asc' => ['hn' => SORT_ASC], 'desc' => ['hn' => SORT_DESC], 'default' => SORT_DESC, 'label' => 'HN'], 'cid' => ['asc' => ['cid' => SORT_ASC], 'desc' => ['cid' => SORT_DESC], 'default' => SORT_DESC, 'label' => 'หมายเลขบัตรประชาชน'], 'fullname' => ['asc' => ['fullname' => SORT_ASC], 'desc' => ['fullname' => SORT_DESC], 'default' => SORT_DESC, 'label' => 'ชื่อ - สกุล'], 'birthday' => ['asc' => ['birthday' => SORT_ASC], 'desc' => ['birthday' => SORT_DESC], 'default' => SORT_DESC, 'label' => 'วันเดือนปีเกิด'], 'pttype' => ['asc' => ['pttype' => SORT_ASC], 'desc' => ['pttype' => SORT_DESC], 'default' => SORT_DESC, 'label' => 'สิทธิการรักษา'], 'amount' => ['asc' => ['amount' => SORT_ASC], 'desc' => ['amount' => SORT_DESC], 'default' => SORT_DESC, 'label' => 'เรียกเก็บ'], 'paid_money' => ['asc' => ['paid_money' => SORT_ASC], 'desc' => ['paid_money' => SORT_DESC], 'default' => SORT_DESC], 'rcpt_money' => ['asc' => ['rcpt_money' => SORT_ASC], 'desc' => ['rcpt_money' => SORT_DESC], 'default' => SORT_DESC], 'remain_money' => ['asc' => ['remain_money' => SORT_ASC], 'desc' => ['remain_money' => SORT_DESC], 'default' => SORT_DESC], 'total' => ['asc' => ['total' => SORT_ASC], 'desc' => ['total' => SORT_DESC], 'default' => SORT_DESC]]]]);
$query = VnStat::find();
// $dataProvider = new ActiveDataProvider([
// 'query' => $query,
// 'pagination' => ['pagesize'=>80],
// ]);
//print_r($dataProvider);
//print_r($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;
}
//print_r($query);
if (!is_null($this->vstdate) && strpos($this->vstdate, ' - ') !== false) {
list($start_date, $end_date) = explode(' - ', $this->vstdate);
$query->andFilterWhere(['between', 'vstdate', $start_date, $end_date]);
//echo "asdfasfasdf";
$this->vstdate = null;
//print_r($query);
}
$query->andFilterWhere(['gr504' => $this->gr504, 'lastvisit' => $this->lastvisit, 'age_y' => $this->age_y, 'age_m' => $this->age_m, 'age_d' => $this->age_d, 'count_in_month' => $this->count_in_month, 'count_in_year' => $this->count_in_year, 'income' => $this->income, 'paid_money' => $this->paid_money, 'remain_money' => $this->remain_money, 'uc_money' => $this->uc_money, 'item_money' => $this->item_money, 'dba' => $this->dba, 'vstdate' => $this->vstdate, 'print_count' => $this->print_count, 'inc01' => $this->inc01, 'inc02' => $this->inc02, 'inc03' => $this->inc03, 'inc04' => $this->inc04, 'inc05' => $this->inc05, 'inc06' => $this->inc06, 'inc07' => $this->inc07, 'inc08' => $this->inc08, 'inc09' => $this->inc09, 'inc10' => $this->inc10, 'inc11' => $this->inc11, 'inc12' => $this->inc12, 'inc13' => $this->inc13, 'inc14' => $this->inc14, 'inc15' => $this->inc15, 'inc16' => $this->inc16, 'pttype_expire' => $this->pttype_expire, 'inc17' => $this->inc17, 'inc_drug' => $this->inc_drug, 'inc_nondrug' => $this->inc_nondrug, 'pt_subtype' => $this->pt_subtype, 'count_in_day' => $this->count_in_day, 'pttype_begin' => $this->pttype_begin, 'lastvisit_hour' => $this->lastvisit_hour, 'rcpt_money' => $this->rcpt_money, 'discount_money' => $this->discount_money]);
$query->andFilterWhere(['like', 'vn', $this->vn])->andFilterWhere(['like', 'hn', $this->hn])->andFilterWhere(['like', 'pdx', $this->pdx])->andFilterWhere(['like', 'accident_code', $this->accident_code])->andFilterWhere(['like', 'dx_doctor', $this->dx_doctor])->andFilterWhere(['like', 'dx0', $this->dx0])->andFilterWhere(['like', 'dx1', $this->dx1])->andFilterWhere(['like', 'dx2', $this->dx2])->andFilterWhere(['like', 'dx3', $this->dx3])->andFilterWhere(['like', 'dx4', $this->dx4])->andFilterWhere(['like', 'dx5', $this->dx5])->andFilterWhere(['like', 'sex', $this->sex])->andFilterWhere(['like', 'aid', $this->aid])->andFilterWhere(['like', 'moopart', $this->moopart])->andFilterWhere(['like', 'pttype', $this->pttype])->andFilterWhere(['like', 'spclty', $this->spclty])->andFilterWhere(['like', 'op0', $this->op0])->andFilterWhere(['like', 'op1', $this->op1])->andFilterWhere(['like', 'op2', $this->op2])->andFilterWhere(['like', 'op3', $this->op3])->andFilterWhere(['like', 'op4', $this->op4])->andFilterWhere(['like', 'op5', $this->op5])->andFilterWhere(['like', 'rcp_no', $this->rcp_no])->andFilterWhere(['like', 'print_done', $this->print_done])->andFilterWhere(['like', 'pttype_in_region', $this->pttype_in_region])->andFilterWhere(['like', 'pttype_in_chwpart', $this->pttype_in_chwpart])->andFilterWhere(['like', 'pcode', $this->pcode])->andFilterWhere(['like', 'hcode', $this->hcode])->andFilterWhere(['like', 'hospmain', $this->hospmain])->andFilterWhere(['like', 'hospsub', $this->hospsub])->andFilterWhere(['like', 'pttypeno', $this->pttypeno])->andFilterWhere(['like', 'cid', $this->cid])->andFilterWhere(['like', 'main_pdx', $this->main_pdx])->andFilterWhere(['like', 'rcpno_list', $this->rcpno_list])->andFilterWhere(['like', 'ym', $this->ym])->andFilterWhere(['like', 'node_id', $this->node_id])->andFilterWhere(['like', 'ill_visit', $this->ill_visit])->andFilterWhere(['like', 'old_diagnosis', $this->old_diagnosis])->andFilterWhere(['like', 'debt_id_list', $this->debt_id_list])->andFilterWhere(['like', 'vn_guid', $this->vn_guid])->andFilterWhere(['like', 'lastvisit_vn', $this->lastvisit_vn])->andFilterWhere(['like', 'hos_guid', $this->hos_guid]);
// print_r($query);
return $dataProvider;
}
/**
* Finds the VnStat model based on its primary key value.
* If the model is not found, a 404 HTTP exception will be thrown.
* @param string $id
* @return VnStat the loaded model
* @throws NotFoundHttpException if the model cannot be found
*/
protected function findModel($id)
{
if (($model = VnStat::findOne($id)) !== null) {
return $model;
} else {
throw new NotFoundHttpException('The requested page does not exist.');
}
}