guoyao-jiankang/application/admin/view/energy_statistics/month_dep_water2.html

{extend name="common/common2" /}
{block name="main"}
<style>
    .table th{
        text-align: center;
        background: #ffffff;
    }
    /*.table tr{*/
    /*    background: #ffffff;*/
    /*}*/
    .table td{
        text-align: center;
    }
</style>
<div class="ibox-content">
    <div class="ibox">

        <div class="alert">
            <form action="monthDepWater" method="GET" id='search_form' class="form-inline">
                <div class="input-group" style="width: 200px">
                    <span class="input-group-addon">选择日期</span>
                    <input class="form-control dialog-datetime" id="startTime" name="start" type="text"  value="{$start}" placeholder="" readonly/>
                </div>

                <div class="input-group">
            <span class="input-group-btn">
                <button class="btn-sm btn-danger" type="submit"  ><i class="fa fa-search"></i></button>
			</span>&nbsp;
                    <span class="input-group-btn">
                     <button class="btn-sm btn-warning" type="reset" onclick="empty_search()"><i class="fa fa-undo"></i></button>
            </span>
                </div>
            </form>
        </div>

        <div class="panel-group">
            <div class="panel panel-default">
                <div class="panel-heading clearfix">
                    <div class="btn-group pull-left">
                        科室月冷热水量统计
                    </div>
                    <div class="btn-group pull-right">
                        <a href="javascript:;" onclick="printer()" class="btn btn-sm btn btn-primary"><i class="glyphicon glyphicon-print"></i>打印</a>
                        <a href="javascript:;" onclick="excel_download(this)" class="btn btn-other btn-sm"><i class="glyphicon glyphicon-download"></i>导出</a>
                    </div>
                </div>
                <div class="panel-body" id="printer">
                    <table class="table table-bordered">
                        <thead>
                        <tr>
                            <th rowspan="2">序号</th>
                            <th rowspan="2">楼号</th>
                            <th rowspan="2">楼层</th>
                            <th rowspan="2">科室</th>
                            <th rowspan="2">性质</th>
                            <th rowspan="2">表号</th>
                            {foreach $monthList as $k=>$v}
                            <th colspan="2">{$v}</th>
                            {/foreach}
                        </tr>
                        <tr>
                            {foreach $monthList as $k=>$v}
                            <th>使用量</th>
                            <th>合计</th>
                            {/foreach}
                        </tr>
                        </thead>
                        <tbody>
                        {if empty($data)}
                        <tr>
                            <td colspan="30">
                                暂无数据
                            </td>
                        </tr>
                        {/if}
                        {foreach $data as $k => $v}
                        {if count($v['sn']) >1}
                        <tr>
                            <td rowspan="4">{$k + 1}</td>
                            <td rowspan="4">{$v[0]['info']['floor1']|default=''}</td>
                            <td rowspan="4">{$v[0]['info']['floor2']|default=''}</td>
                            <td rowspan="4">{$v[0]['info']['dep']|default=''}</td>
                        </tr>
                        {else/}
                        <tr>
                            <td rowspan="3">{$k + 1}</td>
                            <td rowspan="3">{$v[0]['info']['floor1']|default=''}</td>
                            <td rowspan="3">{$v[0]['info']['floor2']|default=''}</td>
                            <td rowspan="3">{$v[0]['info']['dep']|default=''}</td>
                        </tr>
                        {/if}
                        {foreach $v['sn'] as $k2 => $v2}
                        <tr>
                            {if count($v['sn']) >1 && $k2 == 0}
                            <td rowspan="2">冷水</td>
                            {/if}
                            <td>{$v2|default=''}</td>
                            {foreach $v['cold'][$k2] as $k3 => $v3}
                            <td>{$v3['cold_degree']|default=0}</td>
                            {if $k2 == 0}
                            <td rowspan="3">{$v3['cold_degree']+$v['hotIn'][$k3]-$v['hotReturn'][$k3] }</td>
                            {/if}
                            {/foreach}
                        </tr>
                        {/foreach}
                        <tr>
                            <td colspan="2">实际热水用量</td>
                            {foreach $monthList as $k4 => $v4}
                            <td>{$v['hotIn'][$k4]-$v['hotReturn'][$k4]}</td>
                            {/foreach}
                        </tr>
                        {/foreach}
                        </tbody>
                    </table>
                </div>
            </div>
        </div>
    </div>
</div>
{/block}
{block name="script"}
<script src="/static/layDate-v5.0.9/laydate.js"></script>
<script src="/static/browser.js"></script>
<script src="/static/jquery.jqprint-0.3.js"></script>
<script>
    $(function () {
        laydate.render({
            elem: '#startTime',
            trigger: 'click',
            theme: '#0F3A87',
            type:'year'
        });
    });
    function empty_search(){
        window.location.href = 'monthDepWater';
    }
    function printer(){
        $('#printer').jqprint();
    }

    function excel_download(_self){
        $("#printer").table2excel({
            //      table2excel插件的可用配置参数有：
            exclude: ".noExl",//   exclude：不被导出的表格行的CSS class类。
            name: "科室月冷热水量统计",//   name：导出的Excel文档的名称
            filename: "科室月冷热水量统计",//   filename：Excel文件的名称。
            exclude_img: true,//   exclude_img：是否导出图片。
            exclude_links: true,//   exclude_links：是否导出超链接
            exclude_inputs: true//    exclude_inputs：是否导出输入框中的内容


        });
    }

</script>
{/block}