/** * Creates data provider instance with search query applied * * @param array $params * * @return ActiveDataProvider */ public function search($params) { $query = OrdersTransport::find(); $dataProvider = new ActiveDataProvider(['query' => $query, 'sort' => ['attributes' => ['order_id']]]); $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, 'employer' => $this->employer, 'order_date_start' => $this->order_date_start, 'order_date_end' => $this->order_date_end, 'truck1' => $this->truck1, 'truck2' => $this->truck2, 'driver1' => $this->driver1, 'driver2' => $this->driver2, 'create_date' => $this->create_date]); $query->andFilterWhere(['like', 'order_id', $this->order_id]); $query->andWhere(['delete_flag' => 0]); return $dataProvider; }
public function actionReportall($id = null) { $order_id = OrdersTransport::find()->where(['id' => $id])->one()->order_id; $assign_model = new \app\models\Assign(); $assign = $assign_model->find()->where(['order_id' => $order_id])->all(); $content = $this->renderPartial('_reportViewAll', ['model' => $this->findModel($id), 'assigns' => $assign]); $mpdf = new \mPDF('th', 'A4-P', '0', 'THSaraban'); $mpdf->WriteHTML($content); $mpdf->SetDisplayMode('fullpage'); $mpdf->Output($order_id . ".pdf", "I"); }