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

<?php defined('InShopNC') or exit('Access Invalid!'); ?>
<style>
    .row_q ul li {
        height: 30px;
        line-height: 30px;
    }
    .row_w {
        float: left;
        margin-right: 40px;
    }
</style>
<div class="page">
    <div class="fixed-bar">
        <div class="item-title">
            <h3>对账管理</h3>
            <ul class="tab-base">
                <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>
<!--                <li><a href="index.php?act=OrderStats&op=refill_task"><span>任务列表</span></a></li>-->
<!--                <li><a href="index.php?act=OrderStats&op=task_add"><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>
                    <label for="startTime"></label>
                    <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>
                    <label for="endTime"></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>
                <th><label>统计日期类型</label></th>
                <td>
                    <select name="order_time_type" id="order_time_type">
                        <option value="">请选择...</option>
                        <?php foreach ($output['order_time_type_text'] as $key => $value) { ?>
                            <option value="<?php echo $key; ?>" <?php if($_GET['order_time_type'] == $value){ echo 'selected';}?>><?php echo $value; ?></option>
                        <?php } ?>
                    </select>
                </td>
                </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 class="row_q">
                <ul class="row_w">
                    <li>回调日期统计</li>
                    <li class="lineLi" style="color:#000;">总计成功订单量： <?php echo $output['total_stats']['notify_time']['success_count_total'] ?? 0?></li>
                    <li class="lineLi" style="color:#000;">总计成功订单金额：<?php echo $output['total_stats']['notify_time']['success_refill_amounts_total'] ?? 0?></li>
                    <li class="lineLi" style="color:#000;">总计下游扣款金额：<?php echo $output['total_stats']['notify_time']['success_mch_amounts_toatl'] ?? 0?></li>
                    <li class="lineLi" style="color:#000;">总计上游扣款金额：<?php echo $output['total_stats']['notify_time']['success_channel_amounts_total'] ?? 0?></li>
                </ul>
                <ul>
                    <li>下单日期统计</li>
                    <li class="lineLi" style="color:#000;">总计成功订单量： <?php echo $output['total_stats']['order_time']['success_count_total'] ?? 0?></li>
                    <li class="lineLi" style="color:#000;">总计成功订单金额：<?php echo $output['total_stats']['order_time']['success_refill_amounts_total'] ?? 0?></li>
                    <li class="lineLi" style="color:#000;">总计下游扣款金额：<?php echo $output['total_stats']['order_time']['success_mch_amounts_toatl'] ?? 0?></li>
                    <li class="lineLi" style="color:#000;">总计上游扣款金额：<?php echo $output['total_stats']['order_time']['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>
<!--                <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"><?php echo $output['order_time_type_text'][$v['order_time_type']]; ?></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="13"><?php echo $lang['nc_no_record']; ?></td>
                </tr>
            <?php } ?>
            </tbody>
            <tfoot>
            <tr class="tfoot">
                <td></td>
                <td colspan="13">
                    <div class="pagination"><?php echo $output['show_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 
            let arrData = typeof JSONData != 'object' ? JSON.parse(JSONData) : JSONData; 
            let 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>";
            }
            //设置表头 
            let 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 tr = "<tr>";
                let code = i+1
                tr += "<td>" +code+ "</td>"
                tr += '<td style=font-size:14px;'+ 'mso-number-format:"\@"'+ '>' + arrData[i].time_text + '</td>';
                tr += '<td style=font-size:14px;'+ 'mso-number-format:"\@"'+ '>' + arrData[i].cname + '</td>';
                tr += '<td style=font-size:14px;'+ 'mso-number-format:"\@"'+ '>' + arrData[i].cid + '</td>';
                tr += '<td style=font-size:14px;'+ 'mso-number-format:"\@"'+ '>' + arrData[i].success_count + '</td>';
                tr += '<td style=font-size:14px;'+ 'mso-number-format:"\@"'+ '>' + arrData[i].success_refill_amounts + '</td>';
                tr += '<td style=font-size:14px;'+ 'mso-number-format:"\@"'+ '>' + arrData[i].success_mch_amounts + '</td>';
                tr += '<td style=font-size:14px;'+ 'mso-number-format:"\@"'+ '>' + arrData[i].success_channel_amounts + '</td>';
                tr += '<td style=font-size:14px;'+ 'mso-number-format:"\@"'+ '>' + arrData[i].profit_amounts + '</td>';
                tr += '<td style=font-size:14px;'+ 'mso-number-format:"\@"'+ '>' + arrData[i].service_amounts + '</td>';
                tr += '<td style=font-size:14px;'+ 'mso-number-format:"\@"'+ '>' + arrData[i].order_count + '</td>';
                tr += '<td style=font-size:14px;'+ 'mso-number-format:"\@"'+ '>' + arrData[i].cancel_count + '</td>';
                tr += '<td style=font-size:14px;'+ 'mso-number-format:"\@"'+ '>' + arrData[i].success_ratio + '</td>';
                excel += tr + "</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;
            let order_time_type = $('#order_time_type').val();
            $.get('index.php?act=orderstats&op=ExportData', {
                query_start_time: starTime,
                query_end_time: endTime,
                order_time_type:order_time_type
            }, 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('总计成功订单数量:' + parseInt(data.total_stats.success_count_total))
                    head.push('总计成功订单金额:' + parseFloat(data.total_stats.success_refill_amounts_total))
                    head.push('总计下游扣款金额:' + parseFloat(data.total_stats.success_mch_amounts_toatl))
                    head.push('总计上游扣款金额:' + parseFloat(data.total_stats.success_channel_amounts_total))
                    head.push('总计利润金额:' + parseFloat(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)
                }
            })
        })
    });
</script>