| | |
| | | <!DOCTYPE html> |
| | | <html xmlns="http://www.w3.org/1999/xhtml"> |
| | | <head> |
| | | <meta http-equiv="Content-Type" content="text/html; charset=utf-8"/> |
| | | <title>客è¯è¿½æº¯æµç¨æ¥è¡¨</title> |
| | | <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> |
| | | <title>客è¯è¿½æº¯æµç¨æ¥è¡¨</title> |
| | | <meta name="renderer" content="webkit"> |
| | | <meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1"> |
| | | <meta name="viewport" content="width=device-width, initial-scale=1, maximum-scale=1"> |
| | | <link rel="stylesheet" href="../../../layuiadmin/layui/css/layui.css" media="all"> |
| | | <link rel="stylesheet" href="../../../layuiadmin/style/admin.css" media="all"> |
| | | <script src="../../../layuiadmin/layui/layui.js"></script> |
| | | |
| | | <script src="../../../layuiadmin/zgqCustom/zgqCustom.js"></script> |
| | | <script src="../../../layuiadmin/layui/layui.js"></script> |
| | | <script src="../../../layuiadmin/Scripts/json2.js"></script> |
| | | <script src="../../../layuiadmin/Scripts/jquery-1.4.1.js"></script> |
| | | <script src="../../../layuiadmin/Scripts/webConfig.js"></script> |
| | | <script src="../../../layuiadmin/MESLanguage.js"></script> |
| | | |
| | | </head> |
| | | <body> |
| | | <div class="layui-fluid"> |
| | |
| | | <div class="layui-inline"> |
| | | <label class="layui-form-label">å¼å§æ¶é´</label> |
| | | <div class="layui-input-block"> |
| | | <input type="date" class="layui-input" name="å¼å§æ¶é´" id="å¼å§æ¶é´"> |
| | | <input type="date" class="layui-input" name="HBeginDate" id="HBeginDate"> |
| | | </div> |
| | | </div> |
| | | <div class="layui-inline"> |
| | | <label class="layui-form-label">ç»ææ¶é´</label> |
| | | <div class="layui-input-block"> |
| | | <input type="date" class="layui-input" name="ç»ææ¶é´" id="ç»ææ¶é´"> |
| | | <input type="date" class="layui-input" name="HEndDate" id="HEndDate"> |
| | | </div> |
| | | </div> |
| | | <div class="layui-inline"> |
| | |
| | | </div> |
| | | </div> |
| | | </div> |
| | | <script src="../../../layuiadmin/layui/layui.js"></script> |
| | | <script src="../../../layuiadmin/Scripts/json2.js"></script> |
| | | <script src="../../../layuiadmin/Scripts/jquery-1.4.1.js"></script> |
| | | <script src="../../../layuiadmin/Scripts/webConfig2.js"></script> |
| | | |
| | | <script> |
| | | layui.config({ |
| | | base: '../../../layuiadmin/' //éæèµæºæå¨è·¯å¾ |
| | |
| | | , element = layui.element |
| | | , laypage = layui.laypage |
| | | , laydate = layui.laydate |
| | | , util = layui.util; |
| | | //var sWhere = " 产å代ç = 'BX0002'"; |
| | | , util = layui.util; |
| | | var sWhere = ""; |
| | | |
| | | var option = { |
| | | elem: '#mainTable' |
| | | , toolbar: '#toolbarDemo' |
| | | //, height: 'full-10' |
| | | , page: true |
| | | , limit: 50 |
| | | , limits: [50, 500, 5000, 20000] |
| | | , cols: [[ |
| | | { |
| | | field: 'ç»æåæ¥æ', title: 'ç»æåæ¥æ', sort: true,width:115, templet: function (d) { |
| | | if (d.ç»æåæ¥æ == null) { |
| | | return ""; |
| | | |
| | | |
| | | //#region åå§åçé¢ |
| | | set_ClearBill(); |
| | | //#endregion |
| | | |
| | | // åå§åçé¢ |
| | | function set_ClearBill() { |
| | | //åå§åè¡¨æ ¼ |
| | | set_InitGrid(); |
| | | //åå§åæ¥æ |
| | | $("#HBeginDate").val(Format(new Date(new Date() - 1000 * 60 * 60 * 24 * 2), "yyyy-MM-dd")); |
| | | $("#HEndDate").val(Format(new Date(), "yyyy-MM-dd")); |
| | | get_FastQuery(); |
| | | } |
| | | //è¡¨æ ¼æ°æ® |
| | | function set_InitGrid() { |
| | | var option = { |
| | | elem: '#mainTable' |
| | | , toolbar: '#toolbarDemo' |
| | | , page: true |
| | | , limit: 50 |
| | | , limits: [50, 500, 5000, 20000] |
| | | , cols: [[ |
| | | { |
| | | field: 'ç»æåæ¥æ', title: 'ç»æåæ¥æ', sort: true, width: 115, templet: function (d) { |
| | | if (d.ç»æåæ¥æ == null) { |
| | | return ""; |
| | | } |
| | | return util.toDateString(d.ç»æåæ¥æ, "yyyy-MM-dd"); |
| | | } |
| | | return util.toDateString(d.ç»æåæ¥æ, "yyyy-MM-dd"); |
| | | } |
| | | , { field: 'ä»»å¡å', title: 'ä»»å¡å', width: 140 } |
| | | , { field: 'ç©æç¼ç ', title: 'ç©æç¼ç ', width: 140 } |
| | | , { field: 'ç©æåç§°', title: 'ç©æåç§°', width: 120 } |
| | | , { field: 'è§æ ¼åå·', title: 'è§æ ¼åå·', width: 120 } |
| | | , { field: 'ç产æµè½¬å¡å·', title: 'ç产æµè½¬å¡å·', width: 130 } |
| | | , { field: 'æçå·', title: 'æçå·', width: 160 } |
| | | , { field: '黿 å·', title: '黿 å·', width: 80 } |
| | | , { field: 'ç½æ å·', title: 'ç½æ å·', width: 100 } |
| | | , { field: 'å
è£
åå·', title: 'å
è£
åå·', width: 130 } |
| | | , { field: 'å
è£
åæ¡ç ', title: 'å
è£
åæ¡ç ', width: 170 } |
| | | , { field: 'ééç å
è£
åä»¶æ¡ç ', title: 'ééç å
è£
åä»¶æ¡ç ', width: 160 } |
| | | ]] |
| | | , text: { |
| | | none: 'ææ ç¸å
³æ°æ®ï¼' |
| | | } |
| | | , { field: 'ä»»å¡å', title: 'ä»»å¡å', width: 140 } |
| | | , { field: 'ç©æç¼ç ', title: 'ç©æç¼ç ', width: 140 } |
| | | , { field: 'ç©æåç§°', title: 'ç©æåç§°', width: 120 } |
| | | , { field: 'è§æ ¼åå·', title: 'è§æ ¼åå·', width: 120 } |
| | | , { field: 'ç产æµè½¬å¡å·', title: 'ç产æµè½¬å¡å·', width: 130 } |
| | | , { field: 'æçå·', title: 'æçå·', width: 160 } |
| | | , { field: '黿 å·', title: '黿 å·', width: 80 } |
| | | , { field: 'ç½æ å·', title: 'ç½æ å·', width: 100 } |
| | | , { field: 'å
è£
åå·', title: 'å
è£
åå·', width: 130 } |
| | | , { field: 'å
è£
åæ¡ç ', title: 'å
è£
åæ¡ç ', width: 170 } |
| | | , { field: 'ééç å
è£
åä»¶æ¡ç ', title: 'ééç å
è£
åä»¶æ¡ç ', width: 160 } |
| | | ]] |
| | | , text: { |
| | | none: 'ææ ç¸å
³æ°æ®ï¼' |
| | | } |
| | | }; |
| | | }; |
| | | |
| | | option.data = []; |
| | | table.render(option); |
| | | option.data = []; |
| | | table.render(option); |
| | | } |
| | | |
| | | |
| | | |
| | | //è¿å
¥é¡µé¢æ¾ç¤ºçå表 |
| | | layer.load(3); |
| | | $.ajax({ |
| | | //url: "http://61.130.49.162:9090/WMSAPI///Web/GetMAXNum", |
| | | url: GetWEBURL() + '/Report/RetrospectionCustomerReport', |
| | | type: "GET", |
| | | data: { "sWhere": sWhere }, |
| | | success: function (data1) { |
| | | if (data1.count == 1) { |
| | | option.data = data1.data; |
| | | table.render(option); |
| | | layer.closeAll("loading"); |
| | | } else { |
| | | layer.closeAll("loading"); |
| | | layer.alert(data1.code + data1.Message, { icon: 5 }); |
| | | } |
| | | }, error: function () { |
| | | layer.alert("æ¥å£å¤±æ!", { icon: 5 }); |
| | | } |
| | | }); |
| | | |
| | | //éç½®æé® |
| | | form.on('submit(btnReSearch)', function (data) { |
| | | $("#å¼å§æ¶é´").val(""); |
| | | $("#ç»ææ¶é´").val(""); |
| | | $("#黿 å·").val(""); |
| | | $("#æçå·").val(""); |
| | | $("#å
è£
åå·").val(""); |
| | | $("#ç½æ å·").val(""); |
| | | $("#ééç ").val(""); |
| | | $("#btnSearch").click(); |
| | | }); |
| | | |
| | | //æ¥è¯¢æé® |
| | | form.on('submit(btnSearch)', function (data) { |
| | | var å¼å§æ¶é´ = $("#å¼å§æ¶é´").val(); |
| | | var ç»ææ¶é´ = $("#ç»ææ¶é´").val(); |
| | | // å¿«éè¿æ»¤ |
| | | function get_FastQuery() { |
| | | var HDate = $("#HBeginDate").val();//å¼å§æ¥æ |
| | | var HDate1 = $("#HEndDate").val();//ç»ææ¥æ |
| | | var 黿 å· = $("#黿 å·").val(); |
| | | var æçå· = $("#æçå·").val(); |
| | | var å
è£
åå· = $("#å
è£
åå·").val(); |
| | | var ç½æ å· = $("#ç½æ å·").val(); |
| | | var ééç = $("#ééç ").val(); |
| | | if (å¼å§æ¶é´) { |
| | | sWhere += " and ç»æåæ¥æ > '" + å¼å§æ¶é´ + "'"; |
| | | if (HDate) { |
| | | sWhere += " and ç»æåæ¥æ >= '" + HDate + "'"; |
| | | } |
| | | if (ç»ææ¶é´) { |
| | | sWhere += " and ç»æåæ¥æ < '" + ç»ææ¶é´ + "'"; |
| | | if (HDate1) { |
| | | sWhere += " and ç»æåæ¥æ <='" + HDate1 + "'"; |
| | | } |
| | | if (黿 å·) { |
| | | sWhere += " and 黿 å· like '%" + 黿 å· + "%'"; |
| | |
| | | if (ééç ) { |
| | | sWhere += " and ééç å
è£
åä»¶æ¡ç like '%" + ééç + "%'"; |
| | | } |
| | | get_Display(sWhere); |
| | | sWhere = "";//è°ç¨æ¥å£åæ¸
空sWhereç¼å |
| | | } |
| | | |
| | | // éç½®è¿æ»¤æ¡ä»¶ |
| | | function set_ClearQuery() { |
| | | $("#HBeginDate").val(Format(new Date(new Date() - 1000 * 60 * 60 * 24 * 2), "yyyy-MM-dd")); |
| | | $("#HEndDate").val(Format(new Date(), "yyyy-MM-dd")); |
| | | $("#黿 å·").val(""); |
| | | $("#æçå·").val(""); |
| | | $("#å
è£
åå·").val(""); |
| | | $("#ç½æ å·").val(""); |
| | | $("#ééç ").val(""); |
| | | get_FastQuery(); |
| | | sWhere = ""; |
| | | } |
| | | |
| | | //è¿å
¥é¡µé¢æ¾ç¤ºçç¼åå表 |
| | | function get_Display(sWhere) { |
| | | layer.load(3); |
| | | $.ajax({ |
| | | //url: "http://61.130.49.162:9090/WMSAPI///Web/GetMAXNum", |
| | | url: GetWEBURL() + '/Report/RetrospectionCustomerReport', |
| | |
| | | if (data1.count == 1) { |
| | | option.data = data1.data; |
| | | table.render(option); |
| | | //layer.alert("æ¥è¯¢æå", { icon: 1 }); |
| | | layer.closeAll("loading"); |
| | | } else { |
| | | layer.closeAll("loading"); |
| | | layer.alert(data1.code + data1.Message, { icon: 5 }); |
| | | } |
| | | }, error: function () { |
| | | layer.alert("æ¥å£å¤±æ!", { icon: 5 }); |
| | | } |
| | | }); |
| | | sWhere = "";//è°ç¨æ¥å£åæ¸
空sWhereç¼å |
| | | } |
| | | |
| | | //éç½®æé® |
| | | form.on('submit(btnReSearch)', function (data) { |
| | | set_ClearQuery(); |
| | | }); |
| | | |
| | | //æ¥è¯¢æé® |
| | | form.on('submit(btnSearch)', function (data) { |
| | | get_FastQuery(); |
| | | }); |
| | | |
| | | |