hebei-chengben-car/modules/car/views/default/table.php

<?php
use app\assets\CoreAsset;
use app\assets\PluginsAsset;
$asset = CoreAsset::register($this);
$assetsUrl = $asset->baseUrl;
$pluginsAsset = PluginsAsset::register($this);
$pluginsUrl = $pluginsAsset->baseUrl;
use yii\widgets\ActiveForm;
function formatNumber($v,$d=2){
    return is_null($v) ? '-' : (isset($v) ? number_format($v,$d):'');
}

?>
<script src="<?php echo $pluginsUrl;?>/exportdoc/FileSaver.js"></script>
<script src="<?php echo $pluginsUrl;?>/exportdoc/jquery.wordexport.js"></script>
<style>
    .table-striped>tbody>tr:nth-of-type(odd)>*{--bs-table-accent-bg:none !important;}
    .table-big-tit{writing-mode: vertical-rl !important;background:#FFFAFA !important;color:#5A5C66 !important;font-size:16px;font-weight: bold;width:80px;}
    .table-sec-tit{background:#F0F5FF !important;font-weight:bold;}
    .table-third-tit{background: #F7FAFF !important;}
</style>
<div class="row ">
    <div class="col-12">
        <div class="card">
            <div class="card-body shortcardbody" >
                <!-- 搜索表单 -->
                <div class="searchbox shortsearchbox" >
                    <?php $form = ActiveForm::begin(['options' => ['id'=>'searchform','class' => 'row gy-2 gx-3 align-items-center'],'method'=>'get', 'enableClientValidation' => false]); ?>
                    <div class="col-sm-auto"><label class="col-form-label">账期</label></div>
                    <div class="col-sm-auto">
                        <input class="form-control" type="text" width="100" data-toggle="datepicker" name="statistical_month"  value="<?php echo $_GET['statistical_month'];?>">
                    </div>
                    <div class="col-sm-auto">
                        <?php $this->beginContent('@app/modules/admin/views/layouts/_city.php'); ?><?php $this->endContent(); ?>
                    </div>
                    <div class="col-sm-auto">
                        <input class="form-control" id="searchcar"  name="card_num" placeholder="请输入车牌号" value="<?php echo $_GET['card_num'];?>">
                    </div>
                    <div class="col-sm-auto" style="margin-left: auto;">
                        <button type="submit" class="btn btn-light carbtn" onclick="layer.msg('请求中，请稍候...', { icon: 16 ,shade: 0.2,time:100000 });">查询</button>
                        <button type="button" class="btn btn-light carbtn" onclick="doExport()">导出</button>
                        <button type="button" class="btn btn-light carbtn" data-bs-toggle="modal" data-bs-target="#koujing" onclick="doKoujing()">口径描述</button>
                    </div>
                    <?php ActiveForm::end(); ?>
                </div>
            </div>
        </div>
    </div>
</div>

<div id="reportcontent_box">
    <div class="row">

        <?php if(empty($car)){ ?>
        <div class="col-md-12">
            <div class="card">
                <div class="card-body">
                    <p class="card-title-desc" style="text-align: center;min-height:100px;padding-top:50px;">请输入车牌号进行查询</p>
                </div>
            </div>
        </div>
        <?php }else{ ?>
        <div class="col-sm-12 col-lg-12">
            <div class="card">
                <div class="card-body">
                    <fieldset>
                        <legend  class="bglegend">一车一表</legend>
                        <div style="height:300px;overflow-y:auto;" id="onetablebox">
                        <table class="table table-striped table-bordered  cartable">
                            <tbody>
                            <tr>
                                <td rowspan="4" align="center" valign="middle" style="vertical-align: middle;" class="table-big-tit">基&nbsp;础&nbsp;信&nbsp;息</td>
                                <td class="table-third-tit">车牌号</td>
                                <td colspan="2"><div align="center"><?php echo $car['card_num'];?></div></td>
                                <td class="table-third-tit">单位</td>
                                <td colspan="2"><div align="center"><?php echo $car['city'];?></div></td>
                                <td class="table-third-tit">二级单位</td>
                                <td colspan="2"><div align="center"><?php echo $car['dpt_sec'];?></div></td>
                                <td class="table-third-tit">生产厂家</td>
                                <td colspan="3"><div align="center"><?php echo $car['factory'];?></div></td>
                            </tr>
                            <tr>
                                <td class="table-third-tit">目前里程</td>
                                <td colspan="2"><div align="center"><?php echo $car->cartable['current_mileage'];?></div></td>
                                <td class="table-third-tit">载客人数</td>
                                <td colspan="2"><div align="center"><?php echo $car['passengers'];?></div></td>
                                <td class="table-third-tit">型号</td>
                                <td colspan="2"><div align="center"><?php echo $car['model'];?></div></td>
                                <td class="table-third-tit">排量(升)</td>
                                <td colspan="3"><div align="center"><?php echo $car['emissions'];?></div></td>
                            </tr>
                            <tr>
                                <td class="table-third-tit">车辆类型</td>
                                <td colspan="2"><div align="center"><?php echo $car['car_type'];?></div></td>
                                <td class="table-third-tit">启用日期</td>
                                <td colspan="2"><div align="center"><?php echo $car['enabled_date'];?></div></td>
                                <td class="table-third-tit">车辆状态</td>
                                <td colspan="2"><div align="center"><?php echo $car->cartable['car_status'];?></div></td>
                                <td class="table-third-tit">用途分类</td>
                                <td colspan="3"><div align="center"><?php echo $car['using_tag'];?></div></td>
                            </tr>
                            <tr>
                                <td class="table-third-tit">责任部门</td>
                                <td colspan="2"><div align="center"><?php echo $car['rps_dpt'];?></div></td>
                                <td class="table-third-tit">责任人</td>
                                <td colspan="2"><div align="center"><?php echo $car['rps_man'];?></div></td>
                                <td class="table-third-tit">责任人电话</td>
                                <td colspan="2"><div align="center"><?php echo $car['cell_num'];?></div></td>
                                <td class="table-third-tit">车辆调配</td>
                                <td colspan="3"><div align="center"><?php echo $car['allocation_remark'];?></div></td>
                            </tr>
                            <tr>
                                <td rowspan="12" align="center" valign="middle"  class="table-big-tit" style="vertical-align: middle;">费&nbsp;用&nbsp;信&nbsp;息</td>
                                <td rowspan="2" align="center" valign="middle" style="vertical-align: middle;" class="table-sec-tit">累计数据</td>
                                <td colspan="2" class="table-third-tit">
                                    <div align="center" >车辆使用费</div></td>
                                <td class="table-third-tit" align="center">排名</td>
                                <td colspan="2" class="table-third-tit">
                                    <div align="center">1.油料费</div></td>
                                <td colspan="2" class="table-third-tit">
                                    <div align="center">2.修理费</div></td>
                                <td class="table-third-tit">
                                    <div align="center">3.路桥费</div></td>
                                <td class="table-third-tit">
                                    <div align="center">4.租赁费</div></td>
                                <td class="table-third-tit">
                                    <div align="center">5.保险费</div></td>
                                <td class="table-third-tit">
                                    <div align="center">6.年检费</div></td>
                                <td class="table-third-tit">
                                    <div align="center">7.其他</div></td>
                            </tr>
                            <tr>
                                <td colspan="2">
                                    <div align="center"><?php echo formatNumber($sum_data['sum_costs'],2);?></div></td>
                                <td align="center"><?php echo $rank;?></td>
                                <td colspan="2">
                                    <div align="center"><?php echo formatNumber($sum_data['sum_oil'],2);?></div></td>
                                <td colspan="2">
                                    <div align="center"><?php echo formatNumber($sum_data['sum_repair'],2);?></div></td>
                                <td>
                                    <div align="center"><?php echo formatNumber($sum_data['sum_road_bridge'],2);?></div></td>
                                <td>
                                    <div align="center"><?php echo formatNumber($sum_data['sum_rent'],2);?></div></td>
                                <td>
                                    <div align="center"><?php echo formatNumber($sum_data['sum_insurance'],2);?></div></td>
                                <td>
                                    <div align="center"><?php echo formatNumber($sum_data['sum_year_check'],2);?></div></td>
                                <td>
                                    <div align="center"><?php echo formatNumber($sum_data['sum_other'],2);?></div></td>
                            </tr>
                            <tr>
                                <td rowspan="2" align="center" valign="middle" style="vertical-align: middle;" class="table-sec-tit">分月数据</td>
                                <td colspan="12" class="table-sec-tit">
                                    <div align="center">本年分月累计数据</div></td>
                            </tr>
                            <tr>
                                <td class="table-third-tit">
                                    <div align="center">1月累计</div></td>
                                <td class="table-third-tit">
                                    <div align="center">2月累计</div></td>
                                <td class="table-third-tit">
                                    <div align="center">3月累计</div></td>
                                <td class="table-third-tit">
                                    <div align="center">4月累计</div></td>
                                <td class="table-third-tit">
                                    <div align="center">5月累计</div></td>
                                <td class="table-third-tit">
                                    <div align="center">6月累计</div></td>
                                <td class="table-third-tit">
                                    <div align="center">7月累计</div></td>
                                <td class="table-third-tit">
                                    <div align="center">8月累计</div></td>
                                <td class="table-third-tit">
                                    <div align="center">9月累计</div></td>
                                <td class="table-third-tit">
                                    <div align="center">10月累计</div></td>
                                <td class="table-third-tit">
                                    <div align="center">11月累计</div></td>
                                <td class="table-third-tit">
                                    <div align="center">12月累计</div></td>
                            </tr>
                            <tr>
                                <td class="table-third-tit">车辆使用费</td>
                                <?php for($i=1;$i<=12;$i++){ ?>
                                    <td>
                                        <div align="center">
                                            <?php echo $monthData[$i]===null ? '' : formatNumber($monthData[$i]['sum_costs'],2);?></div>
                                    </td>
                                <?php }?>
                            </tr>
                            <tr>
                                <td class="table-third-tit">1.油料费</td>
                                <?php for($i=1;$i<=12;$i++){ ?>
                                    <td>
                                        <div align="center"><?php echo $monthData[$i]===null ? '' : formatNumber($monthData[$i]['sum_oil'],2);?></div>
                                    </td>
                                <?php }?>
                            </tr>
                            <tr>
                                <td class="table-third-tit">2.修理费</td>
                                <?php for($i=1;$i<=12;$i++){ ?>
                                    <td>
                                        <div align="center"><?php echo $monthData[$i]===null ? '' : formatNumber($monthData[$i]['sum_repair'],2);?></div>
                                    </td>
                                <?php }?>
                            </tr>
                            <tr>
                                <td class="table-third-tit">3.路桥费</td>
                                <?php for($i=1;$i<=12;$i++){ ?>
                                    <td>
                                        <div align="center"><?php echo $monthData[$i]===null ? '' : formatNumber($monthData[$i]['sum_road_bridge'],2);?></div>
                                    </td>
                                <?php }?>
                            </tr>
                            <tr>
                                <td class="table-third-tit">4.租赁费</td>
                                <?php for($i=1;$i<=12;$i++){ ?>
                                    <td>
                                        <div align="center"><?php echo $monthData[$i]===null ? '' : formatNumber($monthData[$i]['sum_rent'],2);?></div>
                                    </td>
                                <?php }?>
                            </tr>
                            <tr>
                                <td class="table-third-tit">5.保险费</td>
                                <?php for($i=1;$i<=12;$i++){ ?>
                                    <td>
                                        <div align="center"><?php echo $monthData[$i]===null ? '' : formatNumber($monthData[$i]['sum_insurance'],2);?></div>
                                    </td>
                                <?php }?>
                            </tr>
                            <tr>
                                <td class="table-third-tit">6.年检费</td>
                                <?php for($i=1;$i<=12;$i++){ ?>
                                    <td>
                                        <div align="center"><?php echo $monthData[$i]===null ? '' : formatNumber($monthData[$i]['sum_year_check'],2);?></div>
                                    </td>
                                <?php }?>
                            </tr>
                            <tr>
                                <td class="table-third-tit">7.其他</td>
                                <?php for($i=1;$i<=12;$i++){ ?>
                                    <td>
                                        <div align="center"><?php echo $monthData[$i]===null ? '' : formatNumber($monthData[$i]['sum_other'],2);?></div>
                                    </td>
                                <?php }?>
                            </tr>
                            <tr>
                                <td rowspan="9" align="center" valign="middle" class="table-big-tit" style="vertical-align: middle;">评&nbsp;价&nbsp;信&nbsp;息</td>
                                <td rowspan="2" align="center" valign="middle"  class="table-sec-tit" style="vertical-align: middle;">累计数据</td>
                                <td colspan="12" class="table-sec-tit">
                                    <div align="center" >本年分月累计数据</div></td>
                            </tr>
                            <tr>
                                <td class="table-third-tit">
                                    <div align="center">1月累计</div></td>
                                <td class="table-third-tit">
                                    <div align="center">2月累计</div></td>
                                <td class="table-third-tit">
                                    <div align="center">3月累计</div></td>
                                <td class="table-third-tit">
                                    <div align="center">4月累计</div></td>
                                <td class="table-third-tit">
                                    <div align="center">5月累计</div></td>
                                <td class="table-third-tit">
                                    <div align="center">6月累计</div></td>
                                <td class="table-third-tit">
                                    <div align="center">7月累计</div></td>
                                <td class="table-third-tit">
                                    <div align="center">8月累计</div></td>
                                <td class="table-third-tit">
                                    <div align="center">9月累计</div></td>
                                <td class="table-third-tit">
                                    <div align="center">10月累计</div></td>
                                <td class="table-third-tit">
                                    <div align="center">11月累计</div></td>
                                <td class="table-third-tit">
                                    <div align="center">12月累计</div></td>
                            </tr>
                            <tr>
                                <td class="table-third-tit">行驶里程</td>
                                <?php for($i=1;$i<=12;$i++){ ?>
                                    <td>
                                        <div align="center"><?php echo $monthData[$i]===null ? '' : formatNumber($monthData[$i]['sum_mileage'],2);?></div>
                                    </td>
                                <?php }?>
                            </tr>
                            <tr>
                                <td class="table-third-tit">出勤率</td>
                                <?php for($i=1;$i<=12;$i++){ ?>
                                    <td>
                                        <div align="center" title="<?php echo $monthData[$i]===null ? '' : $monthData[$i]['attend_days'].'/'.$monthData[$i]['work_days'];?>"><?php echo $monthData[$i]===null ? '' : (is_null($monthData[$i]['attendance']) && isset($monthData[$i]['attendance']) ? '-' : (isset($monthData[$i]['attendance']) ? number_format($monthData[$i]['attendance']*100,2).'%':''));?></div>
                                    </td>
                                <?php }?>
                            </tr>
                            <tr>
                                <td class="table-third-tit">百公里油费</td>
                                <?php for($i=1;$i<=12;$i++){ ?>
                                    <td>
                                        <div align="center"><?php echo $monthData[$i]===null ? '' : formatNumber($monthData[$i]['oil_per_km'],2);?></div>
                                    </td>
                                <?php }?>
                            </tr>
                            <tr>
                                <td class="table-third-tit">百公里修理</td>
                                <?php for($i=1;$i<=12;$i++){ ?>
                                    <td>
                                        <div align="center"><?php echo $monthData[$i]===null ? '' : formatNumber($monthData[$i]['repair_per_km'],2);?></div>
                                    </td>
                                <?php }?>
                            </tr>
                            <tr>
                                <td class="table-third-tit">百公里费用</td>
                                <?php for($i=1;$i<=12;$i++){ ?>
                                    <td>
                                        <div align="center"><?php echo $monthData[$i]===null ? '' : formatNumber($monthData[$i]['sum_costs_per_km'],2);?></div>
                                    </td>
                                <?php }?>
                            </tr>
                            <tr>
                                <td class="table-third-tit">违规用车次数</td>
                                <?php for($i=1;$i<=12;$i++){ ?>
                                    <td>
                                        <div align="center"><?php echo $monthData[$i]===null ? '' : formatNumber($monthData[$i]['violations_times'],0);?></div>
                                    </td>
                                <?php }?>
                            </tr>
                            </tbody>
                        </table>
                        </div>
                    </fieldset>
                </div>
            </div>
        </div>
        <?php }?>
    </div>
</div>


<style>
    .reportcontent{
        overflow-x:hidden;
        overflow-y:auto;
        padding:0 20px;
        max-height: 800px;
        background: none;
        position: relative;
    }
    .reportcontent img{margin-bottom: 10px;}
</style>
<div class="reportcontent">
    <div id="reportcontent_box_1" style="display:none;text-align: center;"></div>
</div>
<script>
function doExport()
{
    var content = $("#reportcontent_box").html();
    var newStr = content.replace(/px/g,"pt");
    $("#reportcontent_box_1").html(newStr);
    $("#reportcontent_box_1 table").css({'border-collapse':'collapse','border':'border:1px solid #333;margin:0 auto;','margin':'0 auto'})
    $("#reportcontent_box_1").wordExport('一车一表');

}
function doKoujing()
{
    $('#koujing_content').html('<?php echo $koujing;?>');
}

function resizeHeight()
{
    var height = $(window).height()-10;
    if($('.searchbox ').length>0)
    {
        height = height-$('.searchbox').height();
    }

    //height  = height-150;

    $('#onetablebox').css({'height':height});
    $("body").css("overflow-y","hidden");
}
resizeHeight();
</script>