Example #1
0
<?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;">
        <i class="fa fa-windows"></i>
        <div class="pull-right">
            <a href="<?php 
Example #2
0
?>

    <?php 
$columns = [['class' => 'yii\\grid\\SerialColumn'], 'assign_id', ['class' => '\\kartik\\grid\\DataColumn', 'attribute' => 'employer', 'label' => 'ผู้ว่าจ้าง', 'format' => 'raw', 'value' => function ($model) {
    $customer = new \app\models\Customer();
    $cus = $customer->find()->where(['cus_id' => $model->employer])->one();
    return $cus['company'];
}, '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 {
Example #3
0
 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]);
 }
Example #4
0
    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/>
        <b>ที่อยู่ : </b> <?php 
echo $employer['address'];