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: 125px;
    }

    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;
    }

    #selest_nc {
        width: 220px
    }

    tbody {
        font-size: 12px;
    }

    .layui-form-select .layui-input {
        padding: 13px 5px;
    }

    .layui-form-selected dl {
        display: flex !important;
        flex-wrap: wrap !important;
    }

    .layui-form-select dl {

        top: 29px !important;
        min-width: 883% !important;
        max-height: 280px !important;
        padding: 14px 0 !important;
        left: -599px !important;
    }

    .layui-form-select {
        width: 45%;
    }

    .layui-select-title {
        width: 104%;
    }

    .layui-form-select .layui-input {

        padding-left: 11px;
    }

    .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;
    }

    .layui-form-select .layui-input {
        height: 26px;
    }

    input::placeholder {
        color: #333;
    }

    .xm-tips {
        color: #333 !important;
        font-size: 12px;
    }

    .layui-form-select dl dd.layui-this {
        display: none;
    }

    .layui-form-select dl dd {
        cursor: pointer;
        width: 130px;
    }

    .tb-type1 td select {
        width: 201px;
    }

    .tb-type1 td input[type="text"],
    .tb-type1 td select {
        margin-right: 4px;
        margin-left: 0;
        width: 195px;
    }

    .layui-form-select .layui-edge {
        right: -91px !important;
    }
</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 style="width: 327px">
                    <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>
                </td>
                <th><label class="query_ors">供方名称</label></th>
                <td>
                    <select name="store_id" class="">
                        <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>
                <th><label class="">客户名称</label></th>
                <td class="layui-form td_time" style="width: 110px;">
                    <select name="mchid" class="querySelect" lay-verify="" lay-search>
                        <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>

            </tr>
            <tr>

                <th><label class="query_ors">订单号（多行查询）</label></th>
                <td><textarea style="width: 324px;" name="order_sns" id="order_sns" cols="30"
                              rows="10"><?php echo $_GET['order_sns']; ?></textarea></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>
                <th><label>充值类型</label></th>
                <td>
                    <select name="card_type" class="querySelect" style="height: 29px;">
                        <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="7"
                                <?php if ($_GET['card_type'] == '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="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>
                <td>
                    <a href="#" class="btns" onclick="hCopyMchOrder(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>
            <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['official_sn']; ?></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'
        });
        //双击
        $('.doubleclick').dblclick(function () {
            let order_sn = $(this).attr('data-order')
            $.get('index.php?act=refill_order&op=showOrders', {
                order_sn: order_sn
            }, function (data) {
                data = JSON.parse(data)
                if (data.state === 1) {
                    let order_item = data.data
                    let html = '';
                    for (let i = 0; i < order_item.length; i++) {
                        var item = order_item[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>
                                 <td class="db-center">${item.close_reason}</td>
                            <tr>`
                    }
                    let 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>
                                        <th class="db-right">错误原因(订单)</th>
                                    </tr>
                                </thead>
                                <tbody>${html}</tbody>
                            </table>`
                    layer.open({
                        title: `<span>共${data.count}单</span> <span class="db-top">回调状态：${data.mch_notify_state}</span> <span>回调次数：${data.mch_notify_times}</span>`,
                        content: content
                    });
                } else {
                    alert("没有此订单");
                }
            })
        })
        //过滤
        $("#card_nos").blur(function () {
            let test_mch = $("#card_nos").val();
            let result = test_mch.replace(/[\  \r\n\,]+/g, ",");
            $(this).val(result)
        })
        $("#mch_orders").blur(function () {
            let test_mch = $("#mch_orders").val();
            let result = test_mch.replace(/[\  \r\n\,]+/g, ",");
            $(this).val(result)
        })
        $("#order_sns").blur(function () {
            let test_mch = $("#order_sns").val();
            let 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()
            str += card_no + '\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)
    }

    function hCopyMchOrder(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)
    }
</script>