$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>