guoyao-jiankang/application/admin/view/energy_statistics/month_electricity.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="monthElectricity" 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 hidden><td colspan="5"><h1  style="text-align: center">医院每日总电表数据统计</h1></td></tr>
                    <tr hidden><td colspan="5"><h3 style="float: right">{$date}</h3></td></tr>
                        <tr>
                            <th >月份</th>
                            <th >表号</th>
                            <th >倍率</th>
                            <th >使用量</th>
                            <th >合计使用量</th>
                        </tr>
                    </thead>
                    {if $totalData == 0}
                    <tbody>
                        <tr>
                            <td colspan="5">暂无数据</td>
                        </tr>
                    </tbody>
                    {else/}
                    <tbody>
                        <!-- 下面注释不能删除！！！ -->
<!--                        {$rowNumber = 1}-->
                        {foreach $data as $k=>$v}
                        {for start="0" end="$count"}
                        {if $rowNumber % $count == 1 || $count == 1 }
                        <tr>
                            <td rowspan="{$count}">{$k+1}</td>
                            <td>{$v[$i]['sn']|default=''}</td>
                            <td>{$v[$i]['rate']|default=''}</td>
                            <td>{$v[$i]['real_degree']|default=''}</td>
                            <td rowspan="{$count}">
                                {$v.total}
                            </td>
                            {else /}
                        <tr>
                            <td>{$v[$i]['sn']|default=''}</td>
                            <td>{$v[$i]['rate']|default=''}</td>
                            <td>{$v[$i]['real_degree']|default=''}</td>
                            {/if}
                            <!-- 下面注释不能删除！！！ -->
<!--                            {$rowNumber = $rowNumber + 1}-->
                        </tr>
                        {if $rowNumber % $count == 0}
                        <!-- 重置总使用量 -->
                        {/if}
                        {/for}
                        {/foreach}
                            <tr>
                                <td>共计:</td>
                                <td colspan="4">{$totalData}</td>
                            </tr>
                    </tbody>
                    {/if}
                </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 = 'monthElectricity';
    }
    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}