xyzshop/admin/templates/default/system.order.stats.php

<?php defined('InShopNC') or exit('Access Invalid!'); ?>

<div class="page">
    <div class="fixed-bar">
        <div class="item-title">
            <h3>对账管理</h3>
            <ul class="tab-base">
                <li><a href="index.php?act=merchant&op=provider_evidence"><span>上游充值申请记录</span></a></li>
                <li><a href="index.php?act=merchant&op=provider_evidence_add"><span>新增上游充值申请</span></a></li>
                <li><a href="JavaScript:void(0);" class="current"><span>平台对账记录</span></a></li>
                <li><a href="index.php?act=OrderStats&op=index&type=provider"><span>上游对账记录</span></a></li>
                <li><a href="index.php?act=OrderStats&op=index&type=merchant"><span>下游对账记录</span></a></li>
            </ul>
        </div>
    </div>
    <div class="fixed-empty"></div>
    <form method="get" name="formSearch" id="formSearch">
        <input type="hidden" value="OrderStats" name="act">
        <input type="hidden" value="index" name="op">
        <table class="tb-type1 noborder search">
            <tbody>
            <tr>
                <th><label for="query_start_time">统计时间</label></th>
                <td>
                    <input class="txt date" type="text" value="<?php echo $_GET['query_start_time']; ?>"
                           id="startTime" name="query_start_time" autocomplete="off" style="width:120px" />
                    <label for="query_start_time">~</label>
                    <input class="txt date" type="text" value="<?php echo $_GET['query_end_time']; ?>"
                           id="endTime" name="query_end_time" autocomplete="off" style="width:120px" /></td>
                <td><a href="javascript:void(0);" id="ncsubmit" class="btn-search "
                       title="<?php echo $lang['nc_query']; ?>">&nbsp;</a>
                    <?php if ($output['mch_name'] != '') { ?>
                        <a href="index.php?act=OrderStats&op=index" class="btns "
                           title="<?php echo $lang['nc_cancel_search']; ?>"><span><?php echo $lang['nc_cancel_search']; ?></span></a>
                    <?php } ?></td>
                <td>
                    <a href="javascript:void(0);" id="ncexport" class="btn">
                        <span>导出</span>
                    </a>
                </td>
            </tr>
            </tbody>
        </table>
    </form>
       <table class="table tb-type2" id="prompt">
        <tbody>
          <tr class="space odd">
            <th colspan="12"><div class="title">
                <h5>总量统计</h5>
                <span class="arrow"></span></div></th>
          </tr>
          <tr>
            <td>
                <ul>
                    <li class="lineLi" style="color:#000;">总计成功订单量： <?php echo $output['total_stats']['success_count_total'] ?? 0?></li>
                    <li class="lineLi" style="color:#000;">总计成功订单金额：<?php echo $output['total_stats']['success_refill_amounts_total'] ?? 0?></li>
                    <li class="lineLi" style="color:#000;">总计下游扣款金额：<?php echo $output['total_stats']['success_mch_amounts_toatl'] ?? 0?></li>
                    <li class="lineLi" style="color:#000;">总计上游扣款金额：<?php echo $output['total_stats']['success_channel_amounts_total'] ?? 0?></li>
                </ul>
            </td>
          </tr>
        </tbody>
      </table>
    <form method="post" id="merchant_name_form">
        <input type="hidden" name="form_submit" value="ok"/>
        <table class="table tb-type2">
            <thead>
            <tr class="thead">
                <th>统计日期</th>
                <th>主体名称</th>
                <th>主体ID</th>
                <th class="align-center">成功订单数</th>
                <th class="align-center">成功金额</th>
                <th class="align-center">商户金额</th>
                <th class="align-center">通道金额</th>
                <th class="align-center">利润</th>
                <th class="align-center">服务费</th>
                <th class="align-center">订单总量</th>
                <th class="align-center">失败订单数量</th>
                <th class="align-center">成功占比</th>
<!--                <th class="align-center">操作</th>-->
            </tr>
            </thead>
            <tbody>
            <?php if (!empty($output['stats_list']) && is_array($output['stats_list'])) { ?>
                <?php foreach ($output['stats_list'] as $k => $v) { ?>
                    <tr class="trFlex">
                        <td><?php echo $v['time_text']; ?></td>
                        <td><?php echo $v['cname']; ?></td>
                        <td><?php echo $v['cid']; ?></td>
                        <td class="align-center"><?php echo $v['success_count']; ?></td>
                        <td class="align-center"><?php echo $v['success_refill_amounts']; ?></td>
                        <td class="align-center"><?php echo $v['success_mch_amounts']; ?></td>
                        <td class="align-center"><?php echo $v['success_channel_amounts']; ?></td>
                        <td class="align-center"><?php echo $v['profit_amounts']; ?></td>
                        <td class="align-center"><?php echo $v['service_amounts']; ?></td>
                        <td class="align-center"><?php echo $v['order_count']; ?></td>
                        <td class="align-center"><?php echo $v['cancel_count']; ?></td>
                        <td class="align-center"><?php echo $v['success_ratio']; ?></td>
<!--                        <td class="align-center w200">-->
<!--                            <a href="index.php?act=merchant&op=OrderStatsReload&stat_id=--><?php //echo $v['stat_id'];?><!--">重新统计</a>-->
<!--                        </td>-->
                    </tr>
                <?php } ?>
            <?php } else { ?>
                <tr class="no_data">
                    <td colspan="15"><?php echo $lang['nc_no_record']; ?></td>
                </tr>
            <?php } ?>
            </tbody>
            <tfoot>
            <tr class="tfoot">
                <td></td>
                <td colspan="16">
                    <div class="pagination"><?php echo $output['page']; ?></div>
                </td>
            </tr>
            </tfoot>
        </table>
    </form>
</div>
<script type="text/javascript" src="<?php echo RESOURCE_SITE_URL; ?>/js/jquery.edit.js" charset="utf-8"></script>
<script type="text/javascript" src="<?php echo RESOURCE_SITE_URL; ?>/laydate/laydate.js"></script>
<script>
    $(function () {
        $('#ncsubmit').click(function () {
            $('input[name="op"]').val('index');
            $('#formSearch').submit();
        });
        // 日期选择器
        laydate.render({
            elem: '#startTime',
            type: 'datetime'
        });
        laydate.render({
            elem: '#endTime',
            type: 'datetime'
        });
        // 表格hover时背景
        $('.trFlex').each(function () {
            $(this).hover(function () {
                $(this)[0].style.backgroundColor = '#cbe9f3'
            },function() {
                $(this)[0].style.backgroundColor = '#fff'
            })
        })
        function JSONToExcelConvertor(JSONData, FileName, ShowLabel, headData) { 
            //先转化json 
            var arrData = typeof JSONData != 'object' ? JSON.parse(JSONData) : JSONData; 
                
            var excel = '<table>';   
                
            // 标题
            for (const key in headData) {
                var head = "<tr>";
                var td = "<td colspan='13' style='font-size:16px;'>"+ headData[key] + '</td>';
                excel += td + "</tr>";
            }

            //设置表头 
            var row = "<tr>"; 
            for (var i = 0, l = ShowLabel.length; i < l; i++) { 
                row += "<th style='font-size:14px;'>" + ShowLabel[i].value + '</th>'; 
            } 
                
                
            //换行 
            excel += row + "</tr>"; 
                
            //设置数据 
            for (var i = 0; i < arrData.length; i++) { 
                var row = "<tr>"; 
                let code = i+1
                row += "<td>" +code+ "</td>"
                row += '<td style=font-size:14px;'+ 'mso-number-format:"\@"'+ '>' + arrData[i].time_text + '</td>';
                row += '<td style=font-size:14px;'+ 'mso-number-format:"\@"'+ '>' + arrData[i].cname + '</td>';
                row += '<td style=font-size:14px;'+ 'mso-number-format:"\@"'+ '>' + arrData[i].cid + '</td>';
                row += '<td style=font-size:14px;'+ 'mso-number-format:"\@"'+ '>' + arrData[i].success_count + '</td>';
                row += '<td style=font-size:14px;'+ 'mso-number-format:"\@"'+ '>' + arrData[i].success_refill_amounts + '</td>';
                row += '<td style=font-size:14px;'+ 'mso-number-format:"\@"'+ '>' + arrData[i].success_mch_amounts + '</td>';
                row += '<td style=font-size:14px;'+ 'mso-number-format:"\@"'+ '>' + arrData[i].success_channel_amounts + '</td>';
                row += '<td style=font-size:14px;'+ 'mso-number-format:"\@"'+ '>' + arrData[i].profit_amounts + '</td>';
                row += '<td style=font-size:14px;'+ 'mso-number-format:"\@"'+ '>' + arrData[i].service_amounts + '</td>';
                row += '<td style=font-size:14px;'+ 'mso-number-format:"\@"'+ '>' + arrData[i].order_count + '</td>';
                row += '<td style=font-size:14px;'+ 'mso-number-format:"\@"'+ '>' + arrData[i].cancel_count + '</td>';
                row += '<td style=font-size:14px;'+ 'mso-number-format:"\@"'+ '>' + arrData[i].success_ratio + '</td>';
                excel += row + "</tr>"; 
            } 
            excel += "</table>"; 
            var excelFile = "<html xmlns:o='urn:schemas-microsoft-com:office:office' xmlns:x='urn:schemas-microsoft-com:office:excel' xmlns='http://www.w3.org/TR/REC-html40'>"; 
            excelFile += '<meta http-equiv="content-type" content="application/vnd.ms-excel; charset=UTF-8">'; 
            excelFile += '<meta http-equiv="content-type" content="application/vnd.ms-excel'; 
            excelFile += '; charset=UTF-8">'; 
            excelFile += "<head>"; 
            excelFile += "<!--[if gte mso 9]>"; 
            excelFile += "<xml>"; 
            excelFile += "<x:ExcelWorkbook>"; 
            excelFile += "<x:ExcelWorksheets>"; 
            excelFile += "<x:ExcelWorksheet>"; 
            excelFile += "<x:Name>"; 
            excelFile += "{worksheet}"; 
            excelFile += "</x:Name>"; 
            excelFile += "<x:WorksheetOptions>"; 
            excelFile += "<x:DisplayGridlines/>"; 
            excelFile += "</x:WorksheetOptions>"; 
            excelFile += "</x:ExcelWorksheet>"; 
            excelFile += "</x:ExcelWorksheets>"; 
            excelFile += "</x:ExcelWorkbook>"; 
            excelFile += "</xml>"; 
            excelFile += "<![endif]-->"; 
            excelFile += "</head>"; 
            excelFile += "<body>"; 
            excelFile += excel; 
            excelFile += "</body>"; 
            excelFile += "</html>"; 

                
            var uri = 'data:application/vnd.ms-excel;charset=utf-8,' + encodeURIComponent(excelFile); 
                
            var link = document.createElement("a");   
            link.href = uri; 
                
            link.style = "visibility:hidden"; 
            link.download = FileName + ".xls"; 
                
            document.body.appendChild(link); 
            link.click(); 
            document.body.removeChild(link); 
        }
        $('#ncexport').click(function () {
            let starTime = new Date($('input[name="query_start_time"]').val()).getTime()/1000;
            let endTime = new Date($('input[name="query_end_time"]').val()).getTime()/1000;
            $.get('index.php?act=orderstats&op=ExportData', {
                query_start_time: starTime,
                query_end_time: endTime
            }, function (data) {
                data = JSON.parse(data)
                if (data && data.data) {
                    let head = ['北京椰子电子商务有限责任公司']
                    let time = ''
                    if (starTime && endTime) {
                        time = '统计时间：'+$('input[name="query_start_time"]').val()+' - '+$('input[name="query_end_time"]').val()
                        head.push(time)
                    } else if (starTime) {
                        time = '统计时间：'+$('input[name="query_start_time"]').val()
                        head.push(time)
                    }
                    head.push('总计成功订单量:' + data.total_stats.success_count_total)
                    head.push('总计成功订单金额:' + data.total_stats.success_refill_amounts_total)
                    head.push('总计下游扣款金额:' + data.total_stats.success_mch_amounts_toatl)
                    head.push('总计上游扣款金额:' + data.total_stats.success_channel_amounts_total)
                    head.push('总计利润金额:' + data.total_stats.profit_amounts_total)
                    let title = [{value: "序号"},{value: "统计日期"},{value: "主体名称"},{value: "主体ID"},{value: "成功订单数"},{value: "成功金额"},{value: "下游金额"},{value: "上游金额"},{value: "利润"},{value: "服务费"},{value: "订单总量"}, {value: "失败订单数量"},{value: "成功占比"}]
                    JSONToExcelConvertor(data.data, '平台对账记录', title, head)
                }
                // console.log('data', data);
            })
        })
    });
</script>