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]);
}
<style type="text/css">
body{color: #666666; font-size: 12px;}
table tr td{ border-left: #000000 solid 1px; border-bottom: #000000 solid 1px; padding: 5px;}
table tr th{ border-left: #000000 solid 1px; border-bottom: #000000 solid 1px; border-top: #000000 solid 1px; padding: 5px; text-align: left; font-weight: normal;}
table{ border-right: #000000 solid 1px;}
table tr th p{ margin-bottom: 10px;}
</style>
<?php
use yii\helpers\Url;
$truck_model = new \app\models\Truck();
$config = new \app\models\Config_system();
$driver = new app\models\Driver();
$customer_model = new \app\models\Customer();
$changwat_model = new app\models\Changwat();
$producttype_model = new app\models\ProductType();
?>
<!--
#ข้อมูลใบปฏิบัติงาน
Comment By Kimniyom
-->
<div style=" width: 100%; position: relative;">
<div style="width: 80px; float: left;">
<img src="<?php
echo Url::to('@web/web/images/logo.jpg');
?>
"/>
</div>
<div style="float: left; padding-top: 5px;">
</div>
</div>
/* @var $this \yii\web\View */
/* @var $content string */
use yii\helpers\Html;
use yii\widgets\Breadcrumbs;
use app\assets\AdminLteAsset;
use app\assets\JsAsset;
use yii\helpers\Url;
use yii\web\Session;
if (Yii::$app->session['themes'] == "") {
Yii::$app->session['themes'] = "content-bg-gray";
}
AdminLteAsset::register($this);
JsAsset::register($this);
$this->title = "ตงตงทรานสปอร์ต";
$driver_model = new \app\models\Driver();
$truck_act = new \app\models\TruckAct();
$annuities = new app\models\Annuities();
$this->beginPage();
?>
<!DOCTYPE html>
<html lang="<?php
echo Yii::$app->language;
?>
">
<head>
<meta charset="<?php
echo Yii::$app->charset;
?>
">
<meta name="viewport" content="width=device-width, initial-scale=1">
.input-group-addon{font-size: 12px; color: #0000ff;}
</style>
<?php
use yii\helpers\Html;
//use yii\widgets\DetailView;
use kartik\date\DatePicker;
use yii\helpers\ArrayHelper;
use yii\helpers\Url;
/* @var $this yii\web\View */
/* @var $model app\models\OrdersTransport */
$this->title = $model->assign_id;
$this->params['breadcrumbs'][] = ['label' => 'ใบสั่งงาน', 'url' => ['index']];
$this->params['breadcrumbs'][] = $this->title;
$truck_model = new \app\models\Truck();
$config = new \app\models\Config_system();
$driver = new app\models\Driver();
$customer_model = new \app\models\Customer();
$changwat_model = new app\models\Changwat();
$order_model = new \app\models\OrdersTransport();
$car_model = new \app\models\MapTruck();
$car_view = $car_model->findOne(['car_id' => $model->car_id]);
?>
<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>
/* @var $this \yii\web\View */
/* @var $content string */
use yii\helpers\Html;
use yii\widgets\Breadcrumbs;
use app\assets\DesktopAsset;
use app\assets\JsAsset;
use yii\helpers\Url;
use yii\web\Session;
if (Yii::$app->session['themes'] == "") {
Yii::$app->session['themes'] = "content-bg-gray";
}
DesktopAsset::register($this);
JsAsset::register($this);
$this->title = "ตงตงทรานสปอร์ต";
$driver_model = new \app\models\Driver();
$truck_act = new \app\models\TruckAct();
$annuities = new app\models\Annuities();
$engin_model = new app\models\EngineOil();
$company_model = new \app\models\Company();
$company = $company_model->find()->one();
$this->beginPage();
?>
<!DOCTYPE html>
<html lang="<?php
echo Yii::$app->language;
?>
">
<head>
<meta charset="<?php
echo Yii::$app->charset;
}, 'filterType' => GridView::FILTER_SELECT2, 'filter' => ArrayHelper::map(\app\models\Customer::find()->asArray()->all(), 'cus_id', 'company'), 'filterWidgetOptions' => ['pluginOptions' => ['allowClear' => true]], 'filterInputOptions' => ['placeholder' => 'ผู้ว่าจ้าง']], ['class' => '\\kartik\\grid\\DataColumn', 'attribute' => 'order_date_start', 'label' => 'วันที่ไป', 'hAlign' => 'center', 'width' => '10%', 'format' => 'raw', 'mergeHeader' => true, 'value' => function ($model) {
$config = new \app\models\Config_system();
return $config->thaidate($model->order_date_start);
}], ['class' => '\\kartik\\grid\\DataColumn', 'attribute' => 'order_date_end', 'label' => 'วันที่กลับ', 'hAlign' => 'center', 'width' => '10%', 'format' => 'raw', 'mergeHeader' => true, 'value' => function ($model) {
$config = new \app\models\Config_system();
return $config->thaidate($model->order_date_end);
}], ['class' => '\\kartik\\grid\\DataColumn', 'attribute' => 'car_id', 'label' => 'รถคันที่', 'mergeHeader' => true, 'value' => function ($model) {
$truck = new app\models\MapTruck();
$tr = $truck->find()->where(['car_id' => $model->car_id])->one();
return $model->car_id . " (" . $tr['truck_1'] . ') - (' . $tr['truck_2'] . ")";
}], ['class' => '\\kartik\\grid\\DataColumn', 'attribute' => 'driver1', 'label' => 'คนขับ1', 'mergeHeader' => true, 'format' => 'raw', 'value' => function ($model) {
$driver = new app\models\Driver();
$dr = $driver->find()->where(['driver_id' => $model->driver1])->one();
return $dr['name'] . ' ' . $dr['lname'];
}], ['class' => '\\kartik\\grid\\DataColumn', 'attribute' => 'driver2', 'label' => 'คนขับ2', 'mergeHeader' => true, 'format' => 'raw', 'value' => function ($model) {
$driver2 = new app\models\Driver();
$dr2 = $driver2->find()->where(['driver_id' => $model->driver2])->one();
return $dr2['name'] . ' ' . $dr2['lname'];
}], ['class' => '\\kartik\\grid\\DataColumn', 'attribute' => 'imcome', 'label' => 'รายได้', 'mergeHeader' => true, 'hAlign' => 'right', 'format' => 'raw', 'value' => function ($model) {
return "<font style='color:blue;'>" . number_format($model->income, 2) . "</font>";
}], ['class' => '\\kartik\\grid\\DataColumn', 'attribute' => 'flag', 'label' => 'สถานะ', 'mergeHeader' => true, 'format' => 'raw', 'value' => function ($model) {
if ($model->flag == 1) {
$status = "<font style='color:green;'><i class='fa fa-check'></i> ชำระเงินแล้ว</font>";
} else {
$status = "<font style='color:red;'><i class='fa fa-warning'></i> ค้างชำระเงิน</font>";
}
return $status;
}], ['class' => 'kartik\\grid\\ActionColumn', 'header' => 'ตัวเลือก', 'viewOptions' => ['title' => 'ดูข้อมูล', 'data-toggle' => 'tooltip'], 'updateOptions' => ['title' => 'แก้ไข', 'data-toggle' => 'tooltip'], 'deleteOptions' => ['title' => 'ลบ', 'data-toggle' => 'tooltip'], 'headerOptions' => ['class' => 'kartik-sheet-style']]];
echo GridView::widget(['dataProvider' => $dataProvider, 'filterModel' => $searchModel, 'columns' => $columns, 'containerOptions' => ['style' => 'overflow: auto'], 'headerRowOptions' => ['class' => 'kartik-sheet-style'], 'filterRowOptions' => ['class' => 'kartik-sheet-style'], 'responsive' => true, 'pjax' => true, 'panel' => ['type' => GridView::TYPE_PRIMARY, 'heading' => "<i class='fa fa-book'></i> " . $this->title]]);
?>
<td style="text-align: center;"><?php
echo $rs['car_id'];
?>
</td>
<td><?php
echo $rs['truck_1'];
?>
</td>
<td><?php
echo $rs['truck_2'];
?>
</td>
<td>
<?php
if (!empty($rs['driver'])) {
$driver_mode = new \app\models\Driver();
$driver_id = $driver_mode->find()->where(['driver_id' => $rs['driver']])->one()['id'];
?>
<a href="<?php
echo Url::to(['driver/view', 'id' => $driver_id]);
?>
" target="_bank"><?php
echo $rs['name'] . ' ' . $rs['lname'];
?>
</a>
<button type="button" class="btn btn-warning btn-xs pull-right"
onclick="dialog_driver('<?php
echo $rs['car_id'];
?>
')"><i class="fa fa-exchange"></i></button>
<?php
<style type="text/css">
body{color: #666666; font-size: 12px;}
table tr td{ border-left: #000000 solid 1px; border-bottom: #000000 solid 1px; padding: 5px;}
table tr th{ border-left: #000000 solid 1px; border-bottom: #000000 solid 1px; border-top: #000000 solid 1px; padding: 5px; text-align: left; font-weight: bold;}
table{ border-right: #000000 solid 1px;}
table tr th p{ margin-bottom: 10px;}
#line{ color: #FFF; font-size: 5px;}
</style>
<?php
use yii\helpers\Url;
$truck_model = new \app\models\Truck();
$config = new \app\models\Config_system();
$driver = new app\models\Driver();
$customer_model = new \app\models\Customer();
$changwat_model = new app\models\Changwat();
$producttype_model = new app\models\ProductType();
$car_model = new \app\models\MapTruck();
$car = $car_model->find()->where(['car_id' => $model->car_id])->one();
?>
<h3>
สรุปรายรับ - รายจ่าย รหัสสั่งงาน <?php
echo $model->assign_id;
?>
</h3>
<?php
$employer = $customer_model->find()->where(['cus_id' => $model->employer])->one();
?>
<b>ผู้ว่าจ้าง :</b> <?php
echo $employer['company'];
?>
<br/>
public function actionList_driver()
{
$car_id = Yii::$app->request->post('car_id');
$driver_model = new \app\models\Driver();
$driver = $driver_model->get_driver_not_car();
return $this->renderPartial('list_driver', ['driver' => $driver, 'car_id' => $car_id]);
}
