public function actionView($id) { $diag = new ActiveDataProvider(['query' => Ovstdiag::find()->where(['vn' => $id])->orderBy('diagtype'), 'pagination' => ['pageSize' => 20]]); $drug = new ActiveDataProvider(['query' => Opitemrece::find()->join('LEFT OUTER JOIN', 's_drugitems', 'opitemrece.icode =s_drugitems.icode')->where(['vn' => $id]), 'pagination' => ['pageSize' => 20]]); $lab = new ActiveDataProvider(['query' => Laborder::find()->join('LEFT OUTER JOIN', 'lab_head', 'lab_order.lab_order_number =lab_head.lab_order_number')->join('LEFT OUTER JOIN', 'lab_items', 'lab_order.lab_items_code =lab_items.lab_items_code')->where(['vn' => $id]), 'pagination' => ['pageSize' => 20]]); return $this->render('view', ['model' => $this->findModel($id), 'dataProvider' => $drug, 'dataProviderLab' => $lab, 'dataProviderDiag' => $diag]); }
/** * Creates data provider instance with search query applied * * @param array $params * * @return ActiveDataProvider */ public function search($params) { $query = Opitemrece::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(['qty' => $this->qty, 'iperday' => $this->iperday, 'iperdose' => $this->iperdose, 'recetime' => $this->recetime, 'unitprice' => $this->unitprice, 'vstdate' => $this->vstdate, 'vsttime' => $this->vsttime, 'rxdate' => $this->rxdate, 'rxtime' => $this->rxtime, 'discount' => $this->discount, 'order_no' => $this->order_no, 'item_no' => $this->item_no, 'last_modified' => $this->last_modified, 'sum_price' => $this->sum_price, 'cost' => $this->cost, 'stock_department_id' => $this->stock_department_id]); $query->andFilterWhere(['like', 'hos_guid', $this->hos_guid])->andFilterWhere(['like', 'vn', $this->vn])->andFilterWhere(['like', 'hn', $this->hn])->andFilterWhere(['like', 'an', $this->an])->andFilterWhere(['like', 'icode', $this->icode])->andFilterWhere(['like', 'drugusage', $this->drugusage])->andFilterWhere(['like', 'idr', $this->idr])->andFilterWhere(['like', 'doctor', $this->doctor])->andFilterWhere(['like', 'sp_use', $this->sp_use])->andFilterWhere(['like', 'hcode', $this->hcode])->andFilterWhere(['like', 'print', $this->print])->andFilterWhere(['like', 'dep_code', $this->dep_code])->andFilterWhere(['like', 'finance_number', $this->finance_number])->andFilterWhere(['like', 'use_right', $this->use_right])->andFilterWhere(['like', 'node_id', $this->node_id])->andFilterWhere(['like', 'sub_type', $this->sub_type])->andFilterWhere(['like', 'pttype', $this->pttype])->andFilterWhere(['like', 'income', $this->income])->andFilterWhere(['like', 'remain', $this->remain])->andFilterWhere(['like', 'item_type', $this->item_type])->andFilterWhere(['like', 'staff', $this->staff])->andFilterWhere(['like', 'doctor_lock', $this->doctor_lock])->andFilterWhere(['like', 'paidst', $this->paidst])->andFilterWhere(['like', 'command_doctor', $this->command_doctor]); return $dataProvider; }