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; }
#income{ background: #006633; color: yellow; font-weight: bold;} #outcome{ background: #cc0033; color: #ffffff; font-weight: bold;} #total{ background: #0000cc; font-weight: bold;} </style> <?php use yii\helpers\Html; use yii\helpers\Url; use kartik\date\DatePicker; //use miloschuman\highcharts\Highcharts; /* @var $this yii\web\View */ /* @var $model app\models\Truck */ $config = new app\models\Config_system(); $product_type = new \app\models\ProductType(); $map_driv = new \app\models\MapDriver(); $assign = new \app\models\Assign(); $outgoing = new \app\models\Outgoings(); ?> <div class="table table-responsive"> <table class="table table-striped table-hover table-bordered" id="report_year"> <thead> <tr> <th rowspan="2" valign="middle"><i class="fa fa-calendar"></i><br/>รหัสสั่งงาน</th> <th rowspan="2" valign="middle"><i class="fa fa-truck"></i><br/>เที่ยววันที่</th> <th rowspan="2" valign="middle"><i class="fa fa-users"></i><br/>คนขับ</th> <th rowspan="2" valign="middle"><i class="fa fa-list"></i><br/>รายการ</th> <th rowspan="2" valign="middle"></i>น้ำหนัก<br/>(ตัน)</th> <th rowspan="2" valign="middle">ระยะทาง<br/>(ก.ม)</th>
background: #FFF; } </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;">
<?php use yii\helpers\Html; //use yii\grid\GridView; use kartik\grid\GridView; use app\models\Config_system; use yii\helpers\Url; /* @var $this yii\web\View */ /* @var $searchModel app\models\DriverSearch */ /* @var $dataProvider yii\data\ActiveDataProvider */ $this->title = 'พนักงานขับรถ'; $this->params['breadcrumbs'][] = $this->title; $car_model = new app\models\MapDriver(); ?> <!-- <div class="driver-index"> <?php // echo $this->render('_search', ['model' => $searchModel]); ?> <?php /* $heading = '<i class="fa fa-users"></i> ' . $this->title; echo GridView::widget([ 'dataProvider' => $dataProvider, 'filterModel' => $searchModel, 'columns' => [ ['class' => 'yii\grid\SerialColumn'],
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]); }