function get_driver($car_id = null) { $mapdriver = new \app\models\MapDriver(); $rs = $mapdriver->find()->where(['car_id' => $car_id, 'active' => '1'])->one(); $driver_id = $rs['driver']; $result = $mapdriver->get_driver($driver_id); return $result; }
</style> <?php use yii\helpers\Html; //use yii\widgets\DetailView; use kartik\detail\DetailView; use yii\helpers\Url; /* @var $this yii\web\View */ /* @var $model app\models\Driver */ $this->title = $model->name; $this->params['breadcrumbs'][] = ['label' => 'พนักงานขับรถ', 'url' => ['index']]; $this->params['breadcrumbs'][] = $this->title; $config = new app\models\Config_system(); $SalaryMasterModel = new \app\models\SalaryMaster(); $MapDrive = new \app\models\MapDriver(); $MapTruck = new app\models\MapTruck(); $car = $MapDrive->find()->where(['driver' => $model->driver_id, 'active' => '1'])->one(); $car_map = $MapTruck->find()->where(['car_id' => $car['car_id']])->one(); ?> <script type="text/javascript"> function chkNumber(ele) { var vchar = String.fromCharCode(event.keyCode); if ((vchar < '0' || vchar > '9') && (vchar != '.')) return false; //ele.onKeyPress = vchar; } </script> <div class="panel panel-primary"> <div class="panel-heading" style=" padding-bottom:20px;"> <i class="fa fa-windows"></i> <div class="pull-right">
public function actionLoad_report_month_select_car_round() { $year = \Yii::$app->request->post('year'); $month = \Yii::$app->request->post('month'); $car_id = \Yii::$app->request->post('car_id'); $Assign = new \app\models\Assign(); $result = $Assign->find()->where(['car_id' => $car_id, 'LEFT(order_date_start,4)' => $year, 'SUBSTR(order_date_start,6,2)' => $month])->orderBy('id')->all(); $report = new \app\models\MapTruck(); //$result = $report->get_price($car_id, $year, $month); $MapDriver = new \app\models\MapDriver(); $DriverModel = new \app\models\Driver(); $car = $report->find()->where(['car_id' => $car_id])->one(); //ข้อมูลรถ(มีทะเบียนไรบ้าง) $driv = $MapDriver->find()->where(['car_id' => $car_id])->one(); //คันนี้ใครขับ $driver = $DriverModel->find()->where(['driver_id' => $driv['driver']])->one(); //ดึงชื่อคนขับ return $this->renderPartial('load_report_month_select_car_round', ['result' => $result, 'car' => $car, 'driver' => $driver, 'year' => $year, 'month' => $month]); }