| <?php
|
| include("../includes/common.php");
|
| if($islogin2==1){}else exit("<script language='javascript'>window.location.href='./login.php';</script>");
|
| $title='订单记录';
|
| include './head.php';
|
| ?>
|
| <?php
|
|
|
| $type_select = '<option value="0">所有支付方式</option>';
|
| $rs = $DB->getAll("SELECT * FROM pre_type WHERE status=1 ORDER BY id ASC");
|
| foreach($rs as $row){
|
| $type_select .= '<option value="'.$row['id'].'">'.$row['showname'].'</option>';
|
| }
|
| unset($rs);
|
|
|
| ?>
|
| <style>
|
|
|
|
|
| .dates{max-width: 120px;}
|
| .fixed-table-toolbar,.fixed-table-pagination{padding: 15px;}
|
| </style>
|
| <link href="../assets/css/datepicker.css" rel="stylesheet">
|
| <div id="content" class="app-content" role="main">
|
| <div class="app-content-body ">
|
|
|
| <div class="bg-light lter b-b wrapper-md hidden-print">
|
| <h1 class="m-n font-thin h3">订单记录</h1>
|
| </div>
|
| <div class="wrapper-md control">
|
| <?php if(isset($msg)){?>
|
| <div class="alert alert-info">
|
| <?php echo $msg?>
|
| </div>
|
| <?php }?>
|
| <div class="panel panel-default">
|
| <div class="panel-heading font-bold">
|
| <h3 class="panel-title">订单记录</h3>
|
| </div>
|
|
|
| <form onsubmit="return searchSubmit()" method="GET" class="form-inline" id="searchToolbar">
|
| <div class="form-group">
|
| <select class="form-control" name="type">
|
| <option value="1">系统订单号</option>
|
| <option value="2">商户订单号</option>
|
| <option value="3">商品名称</option>
|
| <option value="4">商品金额</option>
|
| <option value="5">实付金额</option>
|
| <option value="6">网站域名</option>
|
| </select>
|
| </div>
|
| <div class="form-group" id="searchword">
|
| <input type="text" class="form-control" name="kw" placeholder="搜索内容" style="min-width: 300px;">
|
| </div>
|
| <div class="input-group input-daterange">
|
| <input type="text" id="starttime" name="starttime" class="form-control dates" placeholder="开始日期" autocomplete="off" title="留空则不限时间范围">
|
| <span class="input-group-addon" onclick="$('#starttime').val('');$('#endtime').val('');" title="清除"><i class="fa fa-chevron-right"></i></span>
|
| <input type="text" id="endtime" name="endtime" class="form-control dates" placeholder="结束日期" autocomplete="off" title="留空则不限时间范围">
|
| </div>
|
| <div class="form-group">
|
| <select name="paytype" class="form-control"><?php echo $type_select?></select>
|
| </div>
|
| <div class="form-group">
|
| <select name="dstatus" class="form-control"><option value="-1">全部状态</option><option value="0">状态未支付</option><option value="1">状态已支付</option><option value="2">状态已退款</option><option value="3">状态已冻结</option></select>
|
| </div>
|
| <button class="btn btn-primary" type="submit"><i class="fa fa-search"></i> 搜索</button>
|
| <a href="javascript:searchClear()" class="btn btn-default"><i class="fa fa-refresh"></i> 重置</a>
|
| </form>
|
| <table id="listTable">
|
| </table>
|
| </div>
|
| </div>
|
| </div>
|
| </div>
|
| <a style="display: none;" href="" id="vurl" rel="noreferrer" target="_blank"></a>
|
| <?php include 'foot.php';?>
|
| <script src="<?php echo $cdnpublic?>layer/3.1.1/layer.min.js"></script>
|
| <script src="<?php echo $cdnpublic?>bootstrap-datepicker/1.9.0/js/bootstrap-datepicker.min.js"></script>
|
| <script src="<?php echo $cdnpublic?>bootstrap-datepicker/1.9.0/locales/bootstrap-datepicker.zh-CN.min.js"></script>
|
| <script src="<?php echo $cdnpublic?>bootstrap-table/1.20.2/bootstrap-table.min.js"></script>
|
| <script src="<?php echo $cdnpublic?>bootstrap-table/1.20.2/extensions/page-jump-to/bootstrap-table-page-jump-to.min.js"></script>
|
| <script src="../assets/js/custom.js"></script>
|
| <script>
|
| var is_user_refund = '<?php echo $conf['user_refund']?>';
|
| $(document).ready(function(){
|
| updateToolbar();
|
| const defaultPageSize = 20;
|
| const pageNumber = typeof window.$_GET['pageNumber'] != 'undefined' ? parseInt(window.$_GET['pageNumber']) : 1;
|
| const pageSize = typeof window.$_GET['pageSize'] != 'undefined' ? parseInt(window.$_GET['pageSize']) : defaultPageSize;
|
|
|
| $("#listTable").bootstrapTable({
|
| url: 'ajax2.php?act=orderList',
|
| pageNumber: pageNumber,
|
| pageSize: pageSize,
|
| classes: 'table table-striped table-hover table-bordered',
|
| columns: [
|
| {
|
| field: 'trade_no',
|
| title: '系统订单号/商户订单号',
|
| formatter: function(value, row, index) {
|
| return '<a href="javascript:showOrder(\''+value+'\')" title="点击查看详情">'+value+'</a></b><br/>'+row.out_trade_no;
|
| }
|
| },
|
| {
|
| field: 'name',
|
| title: '商品名称'
|
| },
|
| {
|
| field: 'money',
|
| title: '商品金额',
|
| formatter: function(value, row, index) {
|
| return '￥<b>'+value+'</b>';
|
| }
|
| },
|
| {
|
| field: 'typename',
|
| title: '支付方式',
|
| formatter: function(value, row, index) {
|
| return value ? '<b><img src="/assets/icon/'+value+'.ico" width="16" onerror="this.style.display=\'none\'">'+row.typeshowname+'</b>' : '';
|
| }
|
| },
|
| {
|
| field: 'addtime',
|
| title: '创建时间/完成时间',
|
| formatter: function(value, row, index) {
|
| return value+'<br/>'+(row.endtime??' ');
|
| }
|
| },
|
| {
|
| field: 'status',
|
| title: '支付状态',
|
| formatter: function(value, row, index) {
|
| if(value == '1'){
|
| return '<font color=green>已支付</font>';
|
| }else if(value == '2'){
|
| return '<font color=red>已退款</font>';
|
| }else if(value == '3'){
|
| return '<font color=red>已冻结</font>';
|
| }else if(value == '4'){
|
| return '<font color=orange>预授权</font>';
|
| }else{
|
| return '<font color=blue>未支付</font>';
|
| }
|
| }
|
| },
|
| {
|
| field: '',
|
| title: '操作',
|
| formatter: function(value, row, index) {
|
| var html = '<a href="./record.php?type=3&kw='+row.trade_no+'" class="btn btn-info btn-xs">明细</a> <a href="javascript:callnotify(\''+row.trade_no+'\')" class="btn btn-success btn-xs">补单</a>';
|
| if(is_user_refund=='1' && row.status=='1'){
|
| html += ' <a href="javascript:refund(\''+row.trade_no+'\')" class="btn btn-danger btn-xs">退款</a>';
|
| }
|
| return html;
|
| }
|
| },
|
| ],
|
| });
|
|
|
| $('.input-datepicker, .input-daterange').datepicker({
|
| format: 'yyyy-mm-dd',
|
| autoclose: true,
|
| clearBtn: true,
|
| language: 'zh-CN'
|
| });
|
| })
|
|
|
| function callnotify(trade_no){
|
| var ii = layer.load(2, {shade:[0.1,'#fff']});
|
| $.ajax({
|
| type : 'POST',
|
| url : 'ajax2.php?act=notify',
|
| data : {trade_no:trade_no},
|
| dataType : 'json',
|
| success : function(data) {
|
| layer.close(ii);
|
| if(data.code == 0){
|
| $("#vurl").attr("href",data.url);
|
| document.getElementById("vurl").click();
|
| listTable();
|
| }else{
|
| layer.alert(data.msg);
|
| }
|
| },
|
| error:function(data){
|
| layer.msg('服务器错误');
|
| }
|
| });
|
| return false;
|
| }
|
| function callreturn(trade_no){
|
| var ii = layer.load(2, {shade:[0.1,'#fff']});
|
| $.ajax({
|
| type : 'POST',
|
| url : 'ajax2.php?act=notify',
|
| data : {trade_no:trade_no,isreturn:1},
|
| dataType : 'json',
|
| success : function(data) {
|
| layer.close(ii);
|
| if(data.code == 0){
|
| $("#vurl").attr("href",data.url);
|
| document.getElementById("vurl").click();
|
| listTable();
|
| }else{
|
| layer.alert(data.msg);
|
| }
|
| },
|
| error:function(data){
|
| layer.msg('服务器错误');
|
| }
|
| });
|
| return false;
|
| }
|
| function refund(trade_no) {
|
| var ii = layer.load(2, {shade:[0.1,'#fff']});
|
| $.ajax({
|
| type : 'POST',
|
| url : 'ajax2.php?act=refund_query',
|
| data : {trade_no:trade_no},
|
| dataType : 'json',
|
| success : function(data) {
|
| layer.close(ii);
|
| if(data.code == 0){
|
| layer.open({
|
| area: ['360px'],
|
| title: '退款确认',
|
| content: '<p>此操作将直接原路退款该订单，每个订单只能操作一次退款，退款金额不能大于订单金额。</p><div class="form-group"><div class="input-group"><div class="input-group-addon">退款金额</div><input type="text" class="form-control" name="refund2" value="'+data.money+'" placeholder="请输入退款金额" autocomplete="off"/></div></div><div class="form-group"><div class="input-group"><div class="input-group-addon">登录密码</div><input type="text" class="form-control" name="paypwd" value="" placeholder="请输入用户登录密码" autocomplete="off"/></div></div>',
|
| yes: function(){
|
| var money = $("input[name='refund2']").val();
|
| var paypwd = $("input[name='paypwd']").val();
|
| if(money == '' || paypwd == ''){
|
| layer.alert('金额或密码不能为空');return;
|
| }
|
| var ii = layer.load(2, {shade:[0.1,'#fff']});
|
| $.ajax({
|
| type : 'POST',
|
| url : 'ajax2.php?act=refund_submit',
|
| data : {trade_no:trade_no, money:money, pwd:paypwd},
|
| dataType : 'json',
|
| success : function(data) {
|
| layer.close(ii);
|
| if(data.code == 0){
|
| layer.alert(data.msg, {icon:1}, function(){ layer.closeAll();searchSubmit(); });
|
| }else{
|
| layer.alert(data.msg, {icon:7});
|
| }
|
| },
|
| error:function(data){
|
| layer.close(ii);
|
| layer.msg('服务器错误');
|
| }
|
| });
|
| }
|
| });
|
| }else{
|
| layer.alert(data.msg, {icon:7});
|
| }
|
| },
|
| error:function(data){
|
| layer.close(ii);
|
| layer.msg('服务器错误');
|
| }
|
| });
|
| }
|
| function showOrder(trade_no) {
|
| var ii = layer.load(2, {shade:[0.1,'#fff']});
|
| var status = ['<span class="label label-primary">未支付</span>','<span class="label label-success">已支付</span>','<span class="label label-red">已退款</span>'];
|
| $.ajax({
|
| type : 'GET',
|
| url : 'ajax2.php?act=order&trade_no='+trade_no,
|
| dataType : 'json',
|
| success : function(data) {
|
| layer.close(ii);
|
| if(data.code == 0){
|
| var data = data.data;
|
| var item = '<table class="table table-condensed table-hover" id="orderItem">';
|
| item += '<tr><td colspan="6" style="text-align:center" class="orderTitle"><b>订单信息</b></td></tr>';
|
| item += '<tr class="orderTitle"><td class="info" class="orderTitle">系统订单号</td><td colspan="5" class="orderContent">'+data.trade_no+'</td></tr>';
|
| item += '<tr><td class="info" class="orderTitle">商户订单号</td><td colspan="5" class="orderContent">'+data.out_trade_no+'</td></tr>';
|
| item += '<tr><td class="info" class="orderTitle">接口订单号</td><td colspan="5" class="orderContent">'+data.api_trade_no+'</td></tr>';
|
| item += '</tr><tr><td class="info" class="orderTitle">支付方式</td><td colspan="5" class="orderContent">'+data.typename+'</td></tr>';
|
| item += '</tr><tr><td class="info" class="orderTitle">商品名称</td><td colspan="5" class="orderContent">'+data.name+'</td></tr>';
|
| item += '</tr><tr><td class="info" class="orderTitle">订单金额</td><td colspan="5" class="orderContent">'+data.money+'</td></tr>';
|
| item += '</tr><tr><td class="info" class="orderTitle">实际支付金额</td><td colspan="5" class="orderContent">'+data.realmoney+'</td></tr>';
|
| item += '</tr><tr><td class="info" class="orderTitle">商户分成金额</td><td colspan="5" class="orderContent">'+data.getmoney+'</td></tr>';
|
| item += '</tr><tr><td class="info" class="orderTitle">创建时间</td><td colspan="5" class="orderContent">'+data.addtime+'</td></tr>';
|
| item += '</tr><tr><td class="info" class="orderTitle">完成时间</td><td colspan="5" class="orderContent">'+data.endtime+'</td></tr>';
|
| item += '</tr><tr><td class="info" class="orderTitle" title="只有在官方通道支付完成后才能显示">支付账号</td><td colspan="5" class="orderContent">'+data.buyer+'</td></tr>';
|
| item += '</tr><tr><td class="info" class="orderTitle">网站域名</td><td colspan="5" class="orderContent"><a href="http://'+data.domain+'" target="_blank" rel="noreferrer">'+data.domain+'</a></td></tr>';
|
| item += '</tr><tr><td class="info" class="orderTitle">支付IP</td><td colspan="5" class="orderContent"><a href="https://m.ip138.com/iplookup.asp?ip='+data.ip+'" target="_blank" rel="noreferrer">'+data.ip+'</a></td></tr>';
|
| item += '<tr><td class="info" class="orderTitle">扩展参数</td><td colspan="5" class="orderContent">'+data.param+'</td></tr>';
|
| item += '<tr><td class="info" class="orderTitle">订单状态</td><td colspan="5" class="orderContent">'+status[data.status]+'</td></tr>';
|
| if(data.status>0){
|
| item += '<tr><td class="info" class="orderTitle">通知状态</td><td colspan="5" class="orderContent">'+(data.notify==0?'<span class="label label-success">通知成功</span>':'<span class="label label-danger">通知失败</span>（已通知'+data.notify+'次）')+'</td></tr>';
|
| }
|
| item += '<tr><td colspan="6" style="text-align:center" class="orderTitle"><b>订单操作</b></td></tr>';
|
| item += '<tr><td colspan="6"><a href="javascript:callnotify(\''+data.trade_no+'\')" class="btn btn-xs btn-default">重新通知(异步)</a> <a href="javascript:callreturn(\''+data.trade_no+'\')" class="btn btn-xs btn-default">重新通知(同步)</a></td></tr>';
|
| item += '</table>';
|
| var area = [$(window).width() > 480 ? '480px' : '100%'];
|
| layer.open({
|
| type: 1,
|
| area: area,
|
| title: '订单详细信息',
|
| skin: 'layui-layer-rim',
|
| content: item
|
| });
|
| }else{
|
| layer.alert(data.msg);
|
| }
|
| },
|
| error:function(data){
|
| layer.msg('服务器错误');
|
| return false;
|
| }
|
| });
|
| }
|
| </script> |
