/** * Creates data provider instance with search query applied * * @param array $params * * @return ActiveDataProvider */ public function search($params) { $query = OrdersTransportAffiliated::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 actionLoad_history() { $id = Yii::$app->request->post('id'); $model = $this->findModel($id); $hisyory = OrdersTransportAffiliated::find()->where(['company_id' => $model->company_id])->all(); return $this->renderPartial('load_history', ["history" => $hisyory, "model" => $model]); }
public function actionGet_bill_customer($cus_id = null) { //$searchModel = new AssignSearch(); $query = Assign::find()->where(['employer' => $cus_id, 'flag' => '0']); $provider = new ActiveDataProvider(['query' => $query, 'pagination' => ['pageSize' => 10]]); $employer = \app\models\OrdersTransportAffiliated::find()->select('orders_transport_affiliated.*')->join('INNER JOIN', 'assign_affiliated', 'assign_affiliated.order_id = orders_transport_affiliated.order_id')->where(['orders_transport_affiliated.employer' => $cus_id, 'flag' => '0']); $provider2 = new ActiveDataProvider(['query' => $employer, 'pagination' => ['pageSize' => 10]]); return $this->render('get_bill_customer', ['dataProvider' => $provider, 'dataProvider2' => $provider2, 'cus_id' => $cus_id]); }
public function actionReceipt($id = null) { $order_id = OrdersTransportAffiliated::find()->where(['id' => $id])->one()['order_id']; $assign_model = new \app\models\AssignAffiliated(); //$outgoings_model = new \app\models\Outgoings(); //$expenses_model = new \app\models\ExpensesTruck(); //$outgoings = $outgoings_model->find()->where(['order_id' => $order_id])->all(); //$expenses = $expenses_model->find()->where(['order_id' => $order_id])->all(); $assign = $assign_model->find()->where(['order_id' => $order_id])->all(); $model = $this->findModel($id); $page = $this->renderPartial('_receipt', ['model' => $model, 'assigns' => $assign]); $mpdf = new \mPDF('th', 'A4-P', '0', 'THSaraban'); $mpdf->WriteHTML($page); $mpdf->SetDisplayMode('fullpage'); $mpdf->Output($order_id . ".pdf", "I"); }