guoyao-jiankang/application/admin/view/daily_statistics/daily.html

{extend name="common/common2" /}
{block name="main"}
<div class="ibox-content">
<div class="ibox">

    <div class="alert">
        <form action="daily" 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" data-date-format="yyyy-mm-dd" value="{$start}" placeholder="" readonly/>
            </div>
            <div class="input-group" style="width: 200px">
                <span class="input-group-addon">结束时间</span>
                <input class="form-control dialog-datetime" id="endTime" name="end" type="text" data-date-format="yyyy-mm-dd" value="{$end}" placeholder="" readonly/>
            </div>
            <div class="input-group">
            <span class="input-group-btn">
                <button class="btn-sm btn-primary" 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>&nbsp;
                <span class="input-group-btn">
                    <button title="导出" class="btn-sm btn-primary"  onclick="exportTableToExcel(this)" type="button" ><i class="fa fa-cloud-download"></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>
            <div class="panel-body" id="printer">
                <table class="table table-bordered" id="table">
                    <thead>
                    <tr>
                        <th>序号</th>
                        <th>任务地点名称</th>
                        <th>工作记录(数量)</th>
                    </tr>
                    </thead>
                    <tbody>
                    {foreach $list as $k=>$v}
                    <tr>
                        <td>{$k+1}</td>
                        <td>{$v['title']}</td>
                        <td>{$v['count']}</td>
                    </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 src="/static/xlsx.full.min.js"></script>
<script>
    $(function () {
        laydate.render({
            elem: '#startTime',
            trigger: 'click',
            theme: '#284a94'
        });
        laydate.render({
            elem: '#endTime',
            trigger: 'click',
            theme: '#284a94'
        });
    });
    function empty_search(){
        window.location.href = 'daily';
    }
    function printer(){
        $('#printer').jqprint();
    }

    function exportTableToExcel() {
        // 获取表格元素
        const table = document.getElementById('table');
        // 将表格转换为工作表
        const ws = XLSX.utils.table_to_sheet(table);
        const filename = '日常工作统计'+'.xlsx';

        // 设置单元格宽度
        // 示例：设置每列的宽度
        ws['!cols'] = [
            { wch: 5 },
            { wch: 10 },
            { wch: 10 },
            // 根据需要继续添加更多列的宽度设置
        ];
        // 设置订单编号列的格式为文本
        // 假设订单编号在第1列（A列）
        const range = XLSX.utils.decode_range(ws['!ref']);
        for (let row = range.s.r; row <= range.e.r; row++) {
            const cellAddress = { c: 1, r: row }; // 第1列（A列）
            const cellRef = XLSX.utils.encode_cell(cellAddress);
            if (ws[cellRef]) {
                ws[cellRef].t = 's'; // 设置单元格类型为字符串
            }
        }
        // 创建工作簿并添加工作表
        const wb = XLSX.utils.book_new();
        XLSX.utils.book_append_sheet(wb, ws, "Sheet1");

        // 导出为 Excel 文件
        XLSX.writeFile(wb, filename || 'tableExport.xlsx');
    }

</script>
{/block}