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

<style>
    th label {
        display: inline-block;
        width: 60px;
        margin-left: 10px;
    }
    .db-right {
        padding-right: 134px!important;
    border-bottom: 1px solid #ccc;

    }
    .db-center {
        padding: 9px 0;
    border-bottom: 1px solid #ccc;
    }
    .db-top {
        padding: 0 30px;
    }
    .page .fixed-bar .item-title h3 {
        margin-top:18px !important;
        margin-bottom:10px !important;
        font-weight:700 !important;
    }
    .tab-base li span {
        font-size:12px !important;
    }
    .query_ors {
        width: 140px;
    }
</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="order_search"/>
        <input type="hidden" name="op" value="index"/>
        <table class="tb-type1 noborder search">
            <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 class="query_ors">充值卡号（多行查询）</label></th>
                <td><textarea name="card_nos" id="card_nos" cols="30" rows="10"><?php echo $_GET['card_nos'];?></textarea></td>
                <th><label class="query_ors">商家单号（多行查询）</label></th>
                <td><textarea name="mch_orders" id="mch_orders" cols="30" rows="10"><?php echo $_GET['mch_orders'];?></textarea></td>
                <td>
                    <a href="javascript:void(0);" id="ncsubmit" class="btn-search "
                       title="<?php echo $lang['nc_query']; ?>">&nbsp;
                    </a>
                </td>
            </tr>
            <tr>
                <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>
                </td>
            </tr>
            <tr>
                <td></td>
                <td>
                    <a href="#" class="btns" onclick="hCopyCardNo(event)">
                        <span><i class="icon-edit"></i>拷贝充值卡号+渠道商</span>
                    </a>
                    <a href="#" class="btns" onclick="hCopyOrder(event)">
                        <span><i class="icon-edit"></i>拷贝订单号</span>
                    </a>
                </td>
            </tr>
        </table>
    </form>

    <table class="table tb-type2 nobdb">
        <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>
        </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">
                        <span class="doubleclick"  data-order="<?php echo $order['order_sn'];?>">
                            <?php echo date('Y-m-d H:i:s', $order['order_time']); ?>
                        </span>
                    </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['quality_text']; ?></td>
                    <td class="align-left"><?php echo $order['err_msg']; ?></td>
                    <td class="align-left"><?php echo $order['mch_order']; ?></td>
                    <td class="align-center"><?php echo $order['mch_amount']; ?></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>
                </tr>
            <?php } ?>
        <?php } else { ?>
            <tr class="no_data">
                <td colspan="18"><?php echo $lang['nc_no_record']; ?></td>
            </tr>
        <?php } ?>
        </tbody>
        <tfoot>
        <tr class="tfoot">
            <td colspan="18" id="dataFuncs">
                <div class="pagination"> <?php echo $output['show_page']; ?> </div>
            </td>
        </tr>
        </tfoot>
    </table>
    <!-- 预警提示 -->
    <audio id="auto" src="<?php echo RESOURCE_SITE_URL; ?>/warning.mp3"></audio>
</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" src="<?php echo ADMIN_TEMPLATES_URL;?>/layui/layui.js"></script>
<link rel="stylesheet" type="text/css" href="<?php echo ADMIN_TEMPLATES_URL; ?>/layui/css/layui.css"/>
<script type="text/javascript">
    $(function () {
        $('#ncsubmit').click(function () {
            $('#formSearch').submit();
        });
        $('#query_start_time').datepicker({dateFormat: 'yy-mm-dd'});
        $('#query_end_time').datepicker({dateFormat: 'yy-mm-dd'});
        // 日期选择器
        laydate.render({
            elem: '#startTime',
            type: 'datetime'
        });
        laydate.render({
            elem: '#endTime',
            type: 'datetime'
        });
        let isWring = '<?php echo $output['count'][1];?>';
        // console.log('isWring', Number(isWring));
        let setTimer
        let num
        if (Number(isWring) > 0) {
            window.clearTimeout(setTimer)
            setTimer = setTimeout(function () {
                $("#auto")[0].play();
                // $("#auto").attr("src", '<?php echo RESOURCE_SITE_URL; ?>/warning.mp3');
            }, 1000);
            window.clearTimeout(num)
            num = setTimeout(function () {
                window.location.reload();
            }, 60000);
        }
                //双击
                $('.doubleclick').dblclick(function() {
            let db_click = $(this).attr('data-order')
            $.get('index.php?act=refill_order&op=showOrders', {
                order_sn:db_click
            }, function(data) {
                data = JSON.parse(data)
                if (data.state == 1) {
                    
                var dbclick = data.data
                let ConentArr = [];
                let html = ''; 
                for (let i = 0; i < dbclick.length; i++) {
                    var item = dbclick[i];
                    html += `
                    <tr>
                         <td class="db-center">${item.order_sn}</td>
                         <td class="db-center">${item.commit_time_text}</td>
                         <td class="db-center">${item.notify_time_text}</td>
                         <td class="db-center">${item.diff_time_text}</td>
                         <td class="db-center">${item.order_state_text}</td>
                         <td class="db-center">${item.channel_name}</td>
                         <td class="db-center">${item.err_msg}</td>
                    <tr>
                    `
                }
                layer.open({
                   title: `<span>共${data.count}单</span> <span class="db-top">回调状态：${data.mch_notify_state}</span> <span>回调次数：${data.mch_notify_times}</span>` ,
                   content: `<table>
                   <thead>
                             <tr>
                                 <th class="db-right">订单号</th>
                                 <th class="db-right">下单日期</th>
                                 <th class="db-right">回调日期</th>
                                 <th class="db-right">耗时</th>
                                 <th class="db-right">订单状态</th>
                                 <th class="db-right">供方名称</th>
                                 <th class="db-right">错误原因</th>
                             </tr>
                    </thead>
                             <tbody>
                             ${html}
                             </tbody>
                            </table>`,
                            

                        });
                } else {
                    alert("没有此订单");

                }
                
            })

        })
        //过滤
        $("#card_nos").blur(function () {
                var test_mch =  $("#card_nos").val();
           var result = test_mch.replace(/[\  \r\n\,]+/g, ",");
                $(this).val(result)
            })
            $("#mch_orders").blur(function () {
                var test_mch =  $("#mch_orders").val();
           var result = test_mch.replace(/[\  \r\n\,]+/g, ",");
                $(this).val(result)
            })
        // 表格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')
            }
        })
    });

    function hCopyCardNo(e) {
        let str = ''
        $('#tbody tr').each(function () {
            let card_no = $(this).find('td').eq(4).text()
            let channel_name = $(this).find('td').eq(15).text()
            str += card_no + '+' + channel_name + '\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 hCopyOrder(e) {
        let str = ''
        $('#tbody tr').each(function () {
            let order = $(this).find('td').eq(1).text()
            str += order + '\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>