/**
* 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");
}
