b8c34de8c8
- 添加 endsWithDoubleZero 函数，用于处理数值字符串末尾的两个零 - 修改 Core.php 中的 queue 方法，增加对卡库提单的特殊处理逻辑 -调整 Feedov.php 中的订单查询和充值逻辑，提高系统稳定性 - 优化数据库配置，连接测试数据库以确保数据安全
318 lines
14 KiB
HTML
318 lines
14 KiB
HTML
<fieldset>
|
|
<legend>条件搜索</legend>
|
|
<form class="layui-form layui-form-pane form-search" action="{:sysuri()}" onsubmit="return false" method="get" autocomplete="off">
|
|
<div class="layui-form-item layui-inline">
|
|
<label class="layui-form-label">渠道</label>
|
|
<label class="layui-input-inline">
|
|
<select class="layui-select" name="cid" lay-search>
|
|
<option value="">-- 全部渠道 --</option>
|
|
{foreach $clist as $v}
|
|
{if input('cid','') eq $v.id}
|
|
<option selected value="{$v.id}">{$v.name|default=''}</option>
|
|
{else}
|
|
<option value="{$v.id}">{$v.name|default=''}</option>
|
|
{/if}
|
|
{/foreach}
|
|
</select>
|
|
</label>
|
|
</div>
|
|
<div class="layui-form-item layui-inline">
|
|
<label class="layui-form-label">商户</label>
|
|
<label class="layui-input-inline">
|
|
<select class="layui-select" name="mid" lay-search>
|
|
<option value="">-- 全部商户 --</option>
|
|
{foreach $mlist as $v}
|
|
{if input('mid','') eq $v.id}
|
|
<option selected value="{$v.id}">{$v.name|default=''}</option>
|
|
{else}
|
|
<option value="{$v.id}">{$v.name|default=''}</option>
|
|
{/if}
|
|
{/foreach}
|
|
</select>
|
|
</label>
|
|
</div>
|
|
<div class="layui-form-item layui-inline">
|
|
<label class="layui-form-label">产品</label>
|
|
<label class="layui-input-inline">
|
|
<select class="layui-select" name="product_key" lay-search>
|
|
<option value="">-- 全部产品 --</option>
|
|
{foreach $pkeylist as $v}
|
|
{if input('product_key','') eq $v.key}
|
|
<option selected value="{$v.key}">{$v.name|default=''}</option>
|
|
{else}
|
|
<option value="{$v.key}">{$v.name|default=''}</option>
|
|
{/if}
|
|
{/foreach}
|
|
</select>
|
|
</label>
|
|
</div>
|
|
<div class="layui-form-item layui-inline">
|
|
<label class="layui-form-label">系统订单号</label>
|
|
<label class="layui-input-inline">
|
|
<input name="order_id" value="{:input('get.order_id')}" placeholder="请输入订单号" class="layui-input">
|
|
</label>
|
|
</div>
|
|
|
|
<div class="layui-form-item layui-inline">
|
|
<label class="layui-form-label">渠道订单号</label>
|
|
<label class="layui-input-inline">
|
|
<input name="channel_order_id" value="{:input('get.channel_order_id')}" placeholder="请输入订单号" class="layui-input">
|
|
</label>
|
|
</div>
|
|
|
|
<div class="layui-form-item layui-inline">
|
|
<label class="layui-form-label">上游订单号</label>
|
|
<label class="layui-input-inline">
|
|
<input name="parent_order_id" value="{:input('get.parent_order_id')}" placeholder="请输入上游订单号" class="layui-input">
|
|
</label>
|
|
</div>
|
|
|
|
<div class="layui-form-item layui-inline">
|
|
<label class="layui-form-label">商户订单号</label>
|
|
<label class="layui-input-inline">
|
|
<input name="merchant_order_id" value="{:input('get.merchant_order_id')}" placeholder="商户订单号" class="layui-input">
|
|
</label>
|
|
</div>
|
|
|
|
<div class="layui-form-item layui-inline">
|
|
<label class="layui-form-label">账号</label>
|
|
<label class="layui-input-inline">
|
|
<input name="account" value="{:input('get.account')}" placeholder="账号" class="layui-input">
|
|
</label>
|
|
</div>
|
|
|
|
<div class="layui-form-item layui-inline">
|
|
<label class="layui-form-label">话费运营商</label>
|
|
<label class="layui-input-inline">
|
|
<select class="layui-select" name="isp" lay-search>
|
|
<option value="">-- 全部运营商 --</option>
|
|
{foreach $isp as $k => $v}
|
|
{if input('isp','') eq $k}
|
|
<option selected value="{$k}">{$v|default=''}</option>
|
|
{else}
|
|
<option value="{$k}">{$v|default=''}</option>
|
|
{/if}
|
|
{/foreach}
|
|
</select>
|
|
</label>
|
|
</div>
|
|
|
|
<div class="layui-form-item layui-inline">
|
|
<label class="layui-form-label">是否申请退单</label>
|
|
<div class="layui-input-inline">
|
|
<select class="layui-select" name="apply_refund">
|
|
{foreach $search['apply_refund'] as $k=>$v}
|
|
{if $k.'' eq input('apply_refund')}
|
|
<option selected value="{$k}">{$v}</option>
|
|
{else}
|
|
<option value="{$k}">{$v}</option>
|
|
{/if}{/foreach}
|
|
</select>
|
|
</div>
|
|
</div>
|
|
|
|
<div class="layui-form-item layui-inline">
|
|
<label class="layui-form-label">状态</label>
|
|
<div class="layui-input-inline">
|
|
<select class="layui-select" name="status">
|
|
{foreach $search['status'] as $k=>$v}
|
|
{if $k.'' eq input('status')}
|
|
<option selected value="{$k}">{$v}</option>
|
|
{else}
|
|
<option value="{$k}">{$v}</option>
|
|
{/if}{/foreach}
|
|
</select>
|
|
</div>
|
|
</div>
|
|
|
|
<div class="layui-form-item layui-inline">
|
|
<label class="layui-form-label">面额</label>
|
|
<div class="layui-input-inline">
|
|
<select class="layui-select" name="cash">
|
|
<option value="">-- 全部面额 --</option>
|
|
{foreach $search['cash'] as $k=>$v}
|
|
{if $v.'' eq input('cash')}
|
|
<option selected value="{$v}">{$v}</option>
|
|
{else}
|
|
<option value="{$v}">{$v}</option>
|
|
{/if}{/foreach}
|
|
</select>
|
|
</div>
|
|
</div>
|
|
|
|
<div class="layui-form-item layui-inline">
|
|
<label class="layui-form-label">充值耗时</label>
|
|
<div class="layui-input-inline">
|
|
<select class="layui-select" name="time">
|
|
<option value="">-- 请选择 --</option>
|
|
{foreach $search['time'] as $k=>$v}
|
|
{if $k.'' eq input('time')}
|
|
<option selected value="{$k}">{$v}</option>
|
|
{else}
|
|
<option value="{$k}">{$v}</option>
|
|
{/if}{/foreach}
|
|
</select>
|
|
</div>
|
|
</div>
|
|
|
|
<div class="layui-form-item layui-inline">
|
|
<label class="layui-form-label">数据筛选</label>
|
|
<div class="layui-input-inline">
|
|
<select class="layui-select" name="data_type">
|
|
{foreach $search['data_type'] as $k=>$v}
|
|
{if $k.'' eq input('data_type')}
|
|
<option selected value="{$k}">{$v}</option>
|
|
{else}
|
|
<option value="{$k}">{$v}</option>
|
|
{/if}{/foreach}
|
|
</select>
|
|
</div>
|
|
</div>
|
|
|
|
<div class="layui-form-item layui-inline">
|
|
<label class="layui-form-label">是否有流水号</label>
|
|
<div class="layui-input-inline">
|
|
<select class="layui-select" name="is_number">
|
|
{foreach $search['is_number'] as $k=>$v}
|
|
{if $k.'' eq input('is_number')}
|
|
<option selected value="{$k}">{$v}</option>
|
|
{else}
|
|
<option value="{$k}">{$v}</option>
|
|
{/if}{/foreach}
|
|
</select>
|
|
</div>
|
|
</div>
|
|
|
|
<div class="layui-form-item layui-inline">
|
|
<label class="layui-form-label">是否返销</label>
|
|
<div class="layui-input-inline">
|
|
<select class="layui-select" name="buy_back">
|
|
{foreach $search['buy_back'] as $k=>$v}
|
|
{if $k.'' eq input('buy_back')}
|
|
<option selected value="{$k}">{$v}</option>
|
|
{else}
|
|
<option value="{$k}">{$v}</option>
|
|
{/if}{/foreach}
|
|
</select>
|
|
</div>
|
|
</div>
|
|
|
|
<div class="layui-form-item layui-inline">
|
|
<label class="layui-form-label">是否二销卡密订单</label>
|
|
<div class="layui-input-inline">
|
|
<select class="layui-select" name="kami_hinged">
|
|
{foreach $search['kami_hinged'] as $k=>$v}
|
|
{if $k.'' eq input('kami_hinged')}
|
|
<option selected value="{$k}">{$v}</option>
|
|
{else}
|
|
<option value="{$k}">{$v}</option>
|
|
{/if}{/foreach}
|
|
</select>
|
|
</div>
|
|
</div>
|
|
|
|
<div class="layui-form-item layui-inline">
|
|
<label class="layui-form-label">请求时间</label>
|
|
<div class="layui-input-inline">
|
|
<input name="create_at" value="{:input('get.create_at')}" type="text" class="layui-input" id="ID-laydate-range-datetime" placeholder="请选择请求时间">
|
|
<!-- <input data-date-range name="create_at" value="{:input('get.create_at')}" placeholder="请选择请求时间" class="layui-input">-->
|
|
</div>
|
|
</div>
|
|
|
|
<div class="layui-form-item layui-inline">
|
|
<label class="layui-form-label">回调时间</label>
|
|
<div class="layui-input-inline">
|
|
<label for="ID-channel_callback_at"></label><input name="channel_callback_at" value="{:input('get.channel_callback_at')}" type="text" class="layui-input" id="ID-channel_callback_at" placeholder="请选择回调时间">
|
|
<!-- <input data-date-range name="channel_callback_at" value="{:input('get.channel_callback_at')}" placeholder="请选择回调时间" class="layui-input">-->
|
|
</div>
|
|
</div>
|
|
|
|
<div class="layui-form-item layui-inline">
|
|
<button type="submit" class="layui-btn layui-btn-primary"><i class="layui-icon"></i> 搜 索</button>
|
|
<button type="button" class="layui-btn layui-btn-primary" onclick="location.reload()"><i class="layui-icon"></i> 刷 新</button>
|
|
{if input('set_callback') != 1}
|
|
<button type="button" class="layui-btn layui-btn-primary" onclick="location.href=location.href+'&set_callback=1'"><i class="layui-icon"></i>手动回调</button>
|
|
<!-- <button type="button" class="layui-btn layui-btn-primary" onclick="location.href=location.href+'&set_callback=1'"><i class="layui-icon"></i>手动回调</button>-->
|
|
{/if}
|
|
|
|
<button type="button" class="layui-btn layui-btn-primary" data-title="手动充值" data-modal="{:url('pay')}"><i class="layui-icon"></i>手动充值</button>
|
|
|
|
<!-- <button type="button" class="layui-btn layui-btn-primary" onclick="location.href='/admin.html#/order/order/index.html?spm=m-69-72-75'"><i class="layui-icon"></i> 重 置</button>-->
|
|
<!-- <button type="reset" class="layui-btn layui-btn-primary">Clear</button>-->
|
|
<button type="reset" class="layui-btn layui-btn-primary" ><i class="layui-icon"></i> 重 置</button>
|
|
<button type="button" data-form-export="{:url('index')}?type={$type|default='a'}" class="layui-btn layui-btn-primary">
|
|
<i class="layui-icon layui-icon-export"></i> 导 出
|
|
</button>
|
|
</div>
|
|
|
|
</form>
|
|
</fieldset>
|
|
<script>
|
|
layui.use(function(){
|
|
|
|
laydate.render({
|
|
elem: '#ID-laydate-range-datetime',
|
|
type: 'datetime',
|
|
range: true
|
|
});
|
|
laydate.render({
|
|
elem: '#ID-channel_callback_at',
|
|
type: 'datetime',
|
|
range: true
|
|
});
|
|
|
|
});
|
|
</script>
|
|
|
|
<script>
|
|
window.form.render();
|
|
require(['excel'], function (excel) {
|
|
excel.bind(function (data) {
|
|
data.forEach(function (item, index) {
|
|
if (item.status == 1) {
|
|
item.status = '下单';
|
|
}
|
|
if (item.status == 2) {
|
|
item.status = '成功';
|
|
}
|
|
if (item.status == 3) {
|
|
item.status = '失败';
|
|
}
|
|
if (item.status == 5) {
|
|
item.status = '存疑';
|
|
}
|
|
if (item.status == 4 || item.status == 6) {
|
|
item.status = '处理中';
|
|
}
|
|
if (item.status == -1) {
|
|
item.status = '队列中';
|
|
}
|
|
if (item.status == 7) {
|
|
item.status = '提卡成功待处理';
|
|
}
|
|
data[index] = [
|
|
item.index || '',
|
|
item.cinfo.name || '',
|
|
item.pinfo.name || '',
|
|
item.minfo.name || '',
|
|
item.order_id || '',
|
|
item.merchant_order_id || '',
|
|
item.parent_order_id || '',
|
|
item.channel_order_id || '',
|
|
item.account || '',
|
|
item.cash || '',
|
|
item.actual_cash || '',
|
|
item.s_nubmer || '',
|
|
item.status || '',
|
|
item.create_at || '',
|
|
item.time || '',
|
|
item.merchant_callback_msg || '',
|
|
item.msg || '',
|
|
];
|
|
});
|
|
data.unshift(['序号','渠道', '商品', '商户', '系统订单号', '商户订单号','平台侧订单号', '渠道订单号', '充值账号', '充值金额', '实际金额', '官方流水号','订单状态', '下单时间', '耗时', '同步结果', '充值结果']);
|
|
return data;
|
|
}, '会员订单记录');
|
|
});
|
|
</script>
|