xyzshop/admin/templates/default/refill.order.index.php

<style>
    th label { display: inline-block;width: 60px; }
    .lineLi {
        min-width: 150px;
        font-size: 12px;
        color:#000;
    }
    #prompt ul .noLineLi {
        background:none; 
    }
    #prompt div {
        display:inline-block;
        background:none
    }
    #prompt ul .lineLi {
        color:#000;
    }
</style>

<?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="JavaScript:void(0);" class="current"><span>管理</span></a></li>
            </ul>
        </div>
    </div>
    <div class="fixed-empty"></div>
    <form method="get" action="index.php" name="formSearch" id="formSearch">
        <input type="hidden" name="act" value="merchant"/>
        <input type="hidden" name="op" value="refill_order"/>
        <input type="hidden" name="export" value=""/>
        <input type="hidden" name="fShowStat" value=""/>
        <table class="tb-type1 noborder search" style="min-width:1400px">
            <tbody>
            <tr>
                <th><label>我方订单号</label></th>
                <td><input class="txt2" type="text" name="order_sn" value="<?php echo $_GET['order_sn']; ?>"/></td>
                <th><label>客户订单号</label></th>
                <td><input class="txt2" type="text" name="mch_order" value="<?php echo $_GET['mch_order']; ?>"/></td>
                <th><label>供方订单号</label></th>
                <td><input class="txt2" type="text" name="ch_trade_no" value="<?php echo $_GET['ch_trade_no']; ?>"/></td>

            </tr>
            <tr>
                <th><label>客户名称</label></th>
                <td>
                    <select name="mchid" class="querySelect">
                        <option value=""><?php echo $lang['nc_please_choose']; ?></option>
                        <?php foreach($output['merchant_list'] as $merchant){?>
                            <option value="<?php echo $merchant['mchid']?>"
                                    <?php if ($_GET['mchid'] == $merchant['mchid']){ ?>selected<?php } ?>><?php echo $merchant['company_name'] == '' ? $merchant['name'] : $merchant['company_name'];?>
                            </option>
                        <?php }?>
                    </select>
                </td>
                <th><label>供方名称</label></th>
                <td>
                    <select name="store_id" class="querySelect">
                        <option value=""><?php echo $lang['nc_please_choose']; ?></option>
                        <?php foreach($output['provider_list'] as $provider){?>
                            <option value="<?php echo $provider['store_id']?>"
                                    <?php if ($_GET['store_id'] == $provider['store_id']){ ?>selected<?php } ?> data-color="<?php echo $provider['opened']?>" class="textColor">
                                        <?php echo $provider['store_name']?>
                                
                            </option>
                        <?php }?>
                    </select>
                </td>
            </tr>
            <tr>
                <th><label>充值卡卡号</label></th>
                <td><input class="txt2" type="text" name="card_no" value="<?php echo $_GET['card_no']; ?>"/></td>
            </tr>
            <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>
                <th><label>订单状态</label></th>
                <td>
                    <select name="order_state" class="querySelect">
                        <option value=""><?php echo $lang['nc_please_choose']; ?></option>
                        <option value="10"
                                <?php if ($_GET['order_state'] == '10'){ ?>selected<?php } ?>><?php echo $lang['order_state_new']; ?></option>
                        <option value="20"
                                <?php if ($_GET['order_state'] == '20'){ ?>selected<?php } ?>><?php echo $lang['order_state_pay']; ?></option>
                        <option value="30"
                                <?php if ($_GET['order_state'] == '30'){ ?>selected<?php } ?>><?php echo $lang['order_state_send']; ?></option>
                        <option value="40"
                                <?php if ($_GET['order_state'] == '40'){ ?>selected<?php } ?>><?php echo $lang['order_state_success']; ?></option>
                        <option value="0"
                                <?php if ($_GET['order_state'] == '0'){ ?>selected<?php } ?>><?php echo $lang['order_state_cancel']; ?></option>
                    </select>
                    <label>充值类型</label>
                    <select name="card_type" class="querySelect">
                        <option value=""><?php echo $lang['nc_please_choose']; ?></option>
                        <option value="1"
                                <?php if ($_GET['card_type'] == '1'){ ?>selected<?php } ?>>中石油</option>
                        <option value="2"
                                <?php if ($_GET['card_type'] == '2'){ ?>selected<?php } ?>>中石化</option>
                        <option value="4"
                                <?php if ($_GET['card_type'] == '4'){ ?>selected<?php } ?>>中国移动</option>
                        <option value="5"
                                <?php if ($_GET['card_type'] == '5'){ ?>selected<?php } ?>>中国联通</option>
                        <option value="6"
                                <?php if ($_GET['card_type'] == '6'){ ?>selected<?php } ?>>中国电信</option>
                        <option value="oil"
                                <?php if ($_GET['card_type'] == 'oil'){ ?>selected<?php } ?>>油费</option>
                        <option value="phone"
                                <?php if ($_GET['card_type'] == 'phone'){ ?>selected<?php } ?>>手机费</option>
                    </select>
                </td>
                <th><label>交易面额</label></th>
                <td>
                    <select name="refill_amount" class="querySelect">
                        <option value=""><?php echo $lang['nc_please_choose']; ?></option>
                        <option value="10"
                                <?php if ($_GET['refill_amount'] == '10'){ ?>selected<?php } ?>>10</option>
                        <option value="20"
                                <?php if ($_GET['refill_amount'] == '20'){ ?>selected<?php } ?>>20</option>
                        <option value="30"
                                <?php if ($_GET['refill_amount'] == '30'){ ?>selected<?php } ?>>30</option>
                        <option value="50"
                                <?php if ($_GET['refill_amount'] == '50'){ ?>selected<?php } ?>>50</option>
                        <option value="100"
                                <?php if ($_GET['refill_amount'] == '100'){ ?>selected<?php } ?>>100</option>
                        <option value="200"
                                <?php if ($_GET['refill_amount'] == '200'){ ?>selected<?php } ?>>200</option>
                        <option value="300"
                                <?php if ($_GET['refill_amount'] == '300'){ ?>selected<?php } ?>>300</option>
                        <option value="500"
                                <?php if ($_GET['refill_amount'] == '500'){ ?>selected<?php } ?>>500</option>
                        <option value="1000"
                                <?php if ($_GET['refill_amount'] == '1000'){ ?>selected<?php } ?>>1000</option>
                        <option value="2000"
                                <?php if ($_GET['refill_amount'] == '2000'){ ?>selected<?php } ?>>2000</option>
                    </select>
                <label>充值耗时</label>
                    <select name="time" class="querySelect">
                        <option value=""><?php echo $lang['nc_please_choose']; ?></option>
                        <option value="1"
                                <?php if ($_GET['time'] == '1'){ ?>selected<?php } ?>>耗时半小时</option>
                        <option value="2"
                                <?php if ($_GET['time'] == '2'){ ?>selected<?php } ?>>耗时一小时</option>
                    </select>
                </td>
                <th><label>通道质量</label></th>
                <td>
                    <select name="quality" class="querySelect">
                        <option value=""><?php echo $lang['nc_please_choose']; ?></option>
                        <option value="1"
                                <?php if ($_GET['quality'] == '1'){ ?>selected<?php } ?>>普充</option>
                        <option value="2"
                                <?php if ($_GET['quality'] == '2'){ ?>selected<?php } ?>>快充</option>
                        <option value="3"
                                <?php if ($_GET['quality'] == '3'){ ?>selected<?php } ?>>卡密</option>
                        <option value="4"
                                <?php if ($_GET['quality'] == '4'){ ?>selected<?php } ?>>三方</option>
                        <option value="5"
                                <?php if ($_GET['quality'] == '5'){ ?>selected<?php } ?>>慢充二十四小时</option>
                        <option value="6"
                                <?php if ($_GET['quality'] == '6'){ ?>selected<?php } ?>>慢充六小时</option>
                        <option value="7"
                                <?php if ($_GET['quality'] == '7'){ ?>selected<?php } ?>>慢充两小时</option>
                    </select>
                </td>
                <td>
                    <a href="javascript:void(0);" id="ncsubmit" class="btn-search "
                       title="<?php echo $lang['nc_query']; ?>">&nbsp;
                    </a>
                </td>
            </tr>
            <tr>
                <td></td>
                <td>
                    <a href="#" class="btns" onclick="hCopyChannel(event)">
                        <span><i class="icon-edit"></i>拷贝渠道单号</span>
                    </a>
                    <a href="#" class="btns" onclick="hCopyCardNo(event)">
                        <span><i class="icon-edit"></i>拷贝充值卡号</span>
                    </a>
                    <a href="index.php?act=merchant&op=OrderQuery" class="btns" >
                        <span><i class="icon-edit"></i>更新待收货订单状态</span>
                    </a>
                </td>
                <td></td>
                <td>
                    <a href="index.php?act=merchant&op=mch_notify" class="btns" >
                        <span><i class="icon-edit"></i>向客户回调</span>
                    </a>
                    <a href="#" class="btns" id="10_rder">
                        <span><i class="icon-edit"></i>10分钟订单</span>
                    </a>
                    <a href="#" class="btns" id="30_rder">
                        <span><i class="icon-edit"></i>半小时订单</span>
                    </a>
                </td>
                <td>
                    <a href="javascript:void(0);" id="ncexport" class="btns" >
                        <span><i class="icon-edit"></i>导出</span>
                    </a>
                    <a href="javascript:void(0);" id="ncstat" class="btns">
                        <span>搜索+统计</span>
                    </a>
                </td>
            </tr>
            </tbody>
        </table>
    </form>
    <?php if($_GET['fShowStat'] == 1){?>
      <table class="table tb-type2" id="prompt" style="min-width:1400px">
        <tbody>
          <tr class="space odd">
            <th colspan="12"><div class="title"><h5>
    金额统计<?php echo $output['ftoday'] == true ? "(今日)" : "" ?></h5><span class="arrow"></span></div></th>
          </tr>
          <tr>
            <td>
                <ul>
                    <div>
                        <li class="lineLi">总计订单数量：<?php echo $output['stat']['all']['order_count'] ?? 0?></li>
                        <li class="lineLi">总计充值金额：<?php echo $output['stat']['all']['refill_amounts'] ?? 0?></li>
                        <li class="lineLi">总计客户扣款金额：<?php echo $output['stat']['all']['mch_amounts'] ?? 0?></li>
                        <li class="lineLi noLineLi">&nbsp;</li>
                        <li class="lineLi">总计供方扣款金额：<?php echo $output['stat']['all']['channel_amounts'] ?? 0?></li>
                        <li class="lineLi">总计利润：<?php echo ncPriceFormat($output['stat']['all']['mch_amounts'] - $output['stat']['all']['channel_amounts'])?></li>
                    </div>
                    <div>
                        <li class="lineLi">总计充值中订单数量：<?php echo $output['stat']['sending']['order_count'] ?? 0?></li>
                        <li class="lineLi">总计充值中订单金额：<?php echo $output['stat']['sending']['refill_amounts'] ?? 0?></li>
                        <li class="lineLi">总计充值中客户扣款金额：<?php echo $output['stat']['sending']['mch_amounts'] ?? 0?></li>
                        <li class="lineLi noLineLi">&nbsp;</li>
                        <li class="lineLi">总计充值中供方扣款金额：<?php echo $output['stat']['sending']['channel_amounts'] ?? 0?></li>
                        <li class="lineLi">总计充值中利润：<?php echo ncPriceFormat($output['stat']['sending']['mch_amounts'] - $output['stat']['sending']['channel_amounts'])?></li>
                    </div>
                    <div>
                        <li class="lineLi">总计充值成功订单数量：<?php echo $output['stat']['success']['order_count'] ?? 0?></li>
                        <li class="lineLi">总计充值成功订单金额：<?php echo $output['stat']['success']['refill_amounts'] ?? 0?></li>
                        <li class="lineLi">总计充值成功客户扣款金额：<?php echo $output['stat']['success']['mch_amounts'] ?? 0?></li>
                        <li class="lineLi noLineLi">&nbsp;</li>
                        <li class="lineLi">总计充值成功供方扣款金额：<?php echo $output['stat']['success']['channel_amounts'] ?? 0?></li>
                        <li class="lineLi">总计充值成功利润：<?php echo ncPriceFormat($output['stat']['success']['mch_amounts'] - $output['stat']['success']['channel_amounts'])?></li>
                    </div>
                    <div>
                        <li class="lineLi">总计充值失败订单数量：<?php echo $output['stat']['cancel']['order_count'] ?? 0?></li>
                        <li class="lineLi">总计充值失败订单金额：<?php echo $output['stat']['cancel']['refill_amounts'] ?? 0?></li>
                        <li class="lineLi">总计充值失败客户扣款金额：<?php echo $output['stat']['cancel']['mch_amounts'] ?? 0?></li>
                        <li class="lineLi noLineLi">&nbsp;</li>
                        <li class="lineLi">总计充值失败供方扣款金额：<?php echo $output['stat']['cancel']['channel_amounts'] ?? 0?></li>
                        <li class="lineLi">总计充值失败利润：<?php echo ncPriceFormat($output['stat']['cancel']['mch_amounts'] - $output['stat']['cancel']['channel_amounts'])?></li>
                    </div>
                    <div>
                        <li class="lineLi">成功率：
                            <?php
                                $count = $output['stat']['success']['order_count'] + $output['stat']['cancel']['order_count'];
                                if($count == 0) {
                                    echo '0%';
                                } else {
                                  $ratio = sprintf("%.2f",$output['stat']['success']['order_count'] / $count);
                                  $ratio = $ratio * 100;
                                    echo "{$ratio}%";
                                }
                            ?></li>
                    </div>
                </ul>
            </td>
          </tr>
        </tbody>
      </table>
    <?php }?>
    <table class="table tb-type2 nobdb" style="min-width:1400px">
        <thead>
        <tr class="thead">
            <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-right">下单日期</th>
            <th class="align-right">耗时</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"><?php echo $lang['nc_handle']; ?></th>
        </tr>
        </thead>
        <tbody id="tbody">
        <?php if (count($output['order_list']) > 0) { ?>
            <?php
            foreach ($output['order_list'] as $key => $order) { ?>
                <tr class="hover trFlex">
                    <td class="align-center"><?php echo $key+1;?></td>
                    <td class="align-left"><?php echo $order['order_sn']; ?></td>
                    <td class="align-center"><?php echo $order['mchid']; ?></td>
                    <td class="align-center"><?php echo $order['mch_name']; ?></td>
                    <td class="align-left"><?php echo $order['card_no']; ?></td>
                    <td class="align-center"><?php echo $order['card_type_text']; ?></td>
                    <td class="align-center"><?php echo $order['refill_amount']; ?></td>
                    <td class="align-right"><?php echo date('Y-m-d H:i:s', $order['order_time']); ?></td>
                    <td class="align-right">
                        <?php if(empty($order['notify_time'])) {
                            if($order['diff_time'] >= 1800 && $order['diff_time'] <= 3600) {
                        ?>
                                <span style="color: #fd9d0e"><?php echo $order['diff_time_text']?></span>
                            <?php }elseif($order['diff_time'] > 3600) {?>
                                <span style="color: #f30707"><?php echo $order['diff_time_text']?></span>
                            <?php }else{?>
                                <?php echo $order['diff_time_text']?>
                            <?php }?>
                        <?php }else{?>
                         <?php echo $order['diff_time_text']?>
                        <?php }?>
                    </td>
                    <td class="align-center"><?php echo orderState($order); ?></td>
                    <td class="align-left"><?php echo $order['official_sn']; ?></td>
                    <td class="align-left"><?php echo $order['err_msg']; ?></td>
                    <td class="align-left"><?php echo $order['mch_order']; ?></td>
                    <td class="align-left" class="ch_trade_no"><?php echo $order['ch_trade_no']; ?></td>
                    <td class="align-center"><?php echo $order['channel_name']; ?></td>
                    <td class="align-center"><?php echo $order['commit_times']; ?></td>
                    <td class="align-center"><?php echo $order['quality_text']; ?></td>
                    <td class="align-center"><?php echo $order['org_quality_text']; ?></td>
<!--                    <td class="align-center">--><?php //echo $order['mch_amount']; ?><!--</td>-->
                    <td class="w144 align-center">
                        <a href="index.php?act=merchant&op=notify_merchant&order_id=<?php echo $order['order_id']; ?>">
                                回调</a>
                        |
                        <a href="index.php?act=merchant&op=notify_manual_merchant&type=cancel&order_id=<?php echo $order['order_id']; ?>">
                            手动失败</a>
                        |
                        <a href="index.php?act=merchant&op=notify_manual_merchant&type=success&order_id=<?php echo $order['order_id']; ?>">
                            手动成功</a>
                    </td>

                </tr>
            <?php } ?>
        <?php } else { ?>
            <tr class="no_data">
                <td colspan="19"><?php echo $lang['nc_no_record']; ?></td>
            </tr>
        <?php } ?>
        </tbody>
        <tfoot>
        <tr class="tfoot">
            <td colspan="19" id="dataFuncs">
                <div class="pagination"> <?php echo $output['show_page']; ?> </div>
            </td>
        </tr>
        </tfoot>
    </table>
</div>
<script type="text/javascript" src="<?php echo RESOURCE_SITE_URL; ?>/laydate/laydate.js"></script>
<script type="text/javascript" src="<?php echo RESOURCE_SITE_URL; ?>/js/jquery-ui/jquery.ui.js"></script>
<script type="text/javascript" src="<?php echo RESOURCE_SITE_URL; ?>/js/jquery-ui/i18n/zh-CN.js"
        charset="utf-8"></script>
<link rel="stylesheet" type="text/css"
      href="<?php echo RESOURCE_SITE_URL; ?>/js/jquery-ui/themes/ui-lightness/jquery.ui.css"/>
<script type="text/javascript">
    $(function () {
        $('#query_start_time').datepicker({dateFormat: 'yy-mm-dd'});
        $('#query_end_time').datepicker({dateFormat: 'yy-mm-dd'});
        $('#ncsubmit').click(function () {
            $('input[name="op"]').val('refill_order');
            $('#formSearch').submit();
        });
        // 导出
        $('#ncexport').click(function () {
            $('input[name="export"]').val('1');
            $('input[name="op"]').val('refill_order');
            $('#formSearch').submit();
            $('input[name="export"]').val('');
        })
        //搜索+统计 
        $('#ncstat').click(function () {
            $('input[name="fShowStat"]').val('1');
            $('input[name="op"]').val('refill_order');
            $('#formSearch').submit();
            $('input[name="fShowStat"]').val('');
        })
        // 日期选择器
        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'
            })
        })
        // 供方名称颜色
        $('.textColor').each(function () {
            let color = $(this).attr('data-color')
            if (color == '1') {
                $(this).css('color', 'green')
            } else {
                $(this).css('color', 'red')
            }
        })
        // 十分钟订单
        $('#10_rder').click(function () {
            let date=new Date();
            let min=date.getMinutes();
            date.setMinutes(min-10);
            let y = date.getFullYear();
            let m = (date.getMonth() + 1) < 10 ? ("0" + (date.getMonth() + 1)) : (date.getMonth() + 1);
            let d = date.getDate() < 10 ? ("0" + date.getDate()) : date.getDate();
            let h = date.getHours() < 10 ? ('0' + date.getHours()) : date.getHours()
            let f = date.getMinutes() < 10 ? ('0' + date.getMinutes()) : date.getMinutes()
            let s = date.getSeconds() < 10 ? ('0' + date.getseconds()) : date.getSeconds()
            let formatdate = y+'-'+m+'-'+d + " " + h + ":" + f + ":" + s;
            // console.log(formatdate) 
            $('#startTime').val(formatdate)
        })
        // 30分钟订单
        $('#30_rder').click(function () {
            let date=new Date(); 
            let min=date.getMinutes();
            date.setMinutes(min-30);
            let y = date.getFullYear();
            let m = (date.getMonth() + 1) < 10 ? ("0" + (date.getMonth() + 1)) : (date.getMonth() + 1);
            let d = date.getDate() < 10 ? ("0" + date.getDate()) : date.getDate();
            let h = date.getHours() < 10 ? ('0' + date.getHours()) : date.getHours()
            let f = date.getMinutes() < 10 ? ('0' + date.getMinutes()) : date.getMinutes()
            let s = date.getSeconds() < 10 ? ('0' + date.getseconds()) : date.getSeconds()
            let formatdate = y+'-'+m+'-'+d + " " + h + ":" + f + ":" + s;
            // console.log(formatdate) 
            $('#startTime').val(formatdate)
        })
    });
    function hCopyChannel(e) {
        let str = ''
        $('#tbody tr').each(function () {
            let res = $(this).find('td').eq(13).text()
            str += res + '\n'
        })
        let oInput = document.createElement("textarea");
        oInput.style.border = "0 none";
        oInput.style.color = "transparent";
        oInput.value = str;
        document.body.appendChild(oInput);
        oInput.select(); // 选择对象
        document.execCommand("Copy"); // 执行浏览器复制命令
        oInput.parentNode.removeChild(oInput)
    }
    function hCopyCardNo(e) {
        let str = ''
        $('#tbody tr').each(function () {
            let res = $(this).find('td').eq(4).text()
            str += res + '\n'
        })
        let oInput = document.createElement("textarea");
        oInput.style.border = "0 none";
        oInput.style.color = "transparent";
        oInput.value = str;
        document.body.appendChild(oInput);
        oInput.select(); // 选择对象
        document.execCommand("Copy"); // 执行浏览器复制命令
        oInput.parentNode.removeChild(oInput)
    }
</script>