$rs2 = $truck_model->find()->where(['id' => $model->truck2])->one();
if (!empty($rs2)) {
echo '<label class="label label-success">' . $rs2['license_plate'] . '</label>';
} else {
echo " -";
}
?>
</div>
</div>
<div class="row">
<div class="col-sm-6 col-md-2 col-lg-3">
<label>คนขับ 1</label>
<label class="label label-success">
<?php
$d1 = $driver->find()->where(['id' => $model->driver1])->one();
echo $d1['name'] . ' ' . $d1['lname'];
?>
</label>
</div>
<div class="col-sm-6 col-md-2 col-lg-3">
<label>คนขับ 2</label>
<label class="label label-success">
<?php
$d2 = $driver->find()->where(['id' => $model->driver2])->one();
if (!empty($d2)) {
echo $d2['name'] . ' ' . $d2['lname'];
} else {
echo "-";
}
?>
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]);
}
?>
><?php
echo "คันที่ " . $cars['car_id'] . " (" . $cars['truck_1'] . ') - (' . $cars['truck_2'] . ")";
?>
</option>
<?php
}
?>
</select>
</div>
</div>
</div>
<div class="col-xs-12 col-sm-12 col-md-3 col-lg-3">
<?php
$drivers = $driver->find()->all();
?>
<div class="form-group">
<div class="input-group">
<div class="input-group-addon"><i class="fa fa-user"></i> คนขับ 1</div>
<select id="driver1" class="form-control" onchange="select_driver1(this.value)" disabled="disabled">
<option value="">== เลือกคนขับ1 ==</option>
<?php
foreach ($drivers as $driv1) {
?>
<option value="<?php
echo $driv1['driver_id'];
?>
" <?php
if ($model->driver1 == $driv1['driver_id']) {
echo "selected";
$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]]);
?>
</div>
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
} else {
</tr>
</thead>
<tbody>
<tr>
<td style="text-align: center; font-weight: bold;">
ทะเบียนรถ <?php
echo $car['truck_1'];
?>
<br/>
ทะเบียนรถ-พ่วง <?php
echo $car['truck_2'];
?>
</td>
<td style="text-align: center; font-weight: bold;">
<?php
$d1 = $driver->find()->where(['driver_id' => $model->driver1])->one();
$d2 = $driver->find()->where(['driver_id' => $model->driver2])->one();
?>
คนขับ 1 <?php
echo $d1['name'] . ' ' . $d1['lname'];
?>
<br/>
คนขับ 2 <?php
echo $d2['name'] . ' ' . $d2['lname'];
?>
</td>
</tr>
</tbody>
</table>
<b>รายรับ</b>
