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]);
}
