Exemple #1
0
 /**
  * Creates data provider instance with search query applied
  *
  * @param array $params
  *
  * @return ActiveDataProvider
  */
 public function search($params)
 {
     $query = Assign::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, 'order_date_start' => $this->order_date_start, 'order_date_end' => $this->order_date_end, 'car_id' => $this->car_id, 'driver1' => $this->driver1, 'driver2' => $this->driver2, 'oil_set' => $this->oil_set, 'oil' => $this->oil, 'oil_unit' => $this->oil_unit, 'oil_price' => $this->oil_price, 'gas' => $this->gas, 'gas_unit' => $this->gas_unit, 'gas_price' => $this->gas_price, 'product_up' => $this->product_up, 'product_down' => $this->product_down, 'transport_date' => $this->transport_date, 'changwat_start' => $this->changwat_start, 'changwat_end' => $this->changwat_end, 'product_type' => $this->product_type, 'weigh' => $this->weigh, 'type_calculus' => $this->type_calculus, 'unit_price' => $this->unit_price, 'per_times' => $this->per_times, 'income' => $this->income, 'create_date' => $this->create_date]);
     $query->andFilterWhere(['like', 'order_id', $this->order_id])->andFilterWhere(['like', 'assign_id', $this->assign_id])->andFilterWhere(['like', 'employer', $this->employer])->andFilterWhere(['like', 'old_mile', $this->old_mile])->andFilterWhere(['like', 'now_mile', $this->now_mile])->andFilterWhere(['like', 'distance', $this->distance])->andFilterWhere(['like', 'distance_collect', $this->distance_collect])->andFilterWhere(['like', 'avg_oil', $this->avg_oil])->andFilterWhere(['like', 'compensate', $this->compensate])->andFilterWhere(['like', 'cus_start', $this->cus_start])->andFilterWhere(['like', 'cus_end', $this->cus_end])->andFilterWhere(['like', 'allowance_driver1', $this->allowance_driver1])->andFilterWhere(['like', 'allowance_driver2', $this->allowance_driver2])->andFilterWhere(['like', 'message', $this->message]);
     return $dataProvider;
 }
 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 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");
 }
 /**
  * Finds the Assign model based on its primary key value.
  * If the model is not found, a 404 HTTP exception will be thrown.
  * @param integer $id
  * @return Assign the loaded model
  * @throws NotFoundHttpException if the model cannot be found
  */
 protected function findModel($id)
 {
     if (($model = Assign::findOne($id)) !== null) {
         return $model;
     } else {
         throw new NotFoundHttpException('The requested page does not exist.');
     }
 }