From 4497aa333e65e55548cbdbca204d843fee79d387 Mon Sep 17 00:00:00 2001 From: zzr99 <1940172413@qq.com> Date: 星期五, 19 十一月 2021 17:52:19 +0800 Subject: [PATCH] Merge branch 'master' of http://101.37.171.70:10101/r/MESWMS-LayUI --- WebTM/views/验收入库/产品入库/Kf_ProductInBillList.html | 438 +++++++++----- WebTM/views/销售管理/发货通知单/Xs_SeOutStockBillList.html | 5 WebTM/views/销售管理/退货通知单/Xs_SeOutStockBackBillList.html | 428 +++++++++---- WebTM/views/验收入库/其他入库/Kf_OtherInBillList.html | 457 +++++++++------ WebTM/views/领料发货/销售出库/Kf_SellOutBillList.html | 443 +++++++++----- 5 files changed, 1,118 insertions(+), 653 deletions(-) diff --git "a/WebTM/views/\351\224\200\345\224\256\347\256\241\347\220\206/\345\217\221\350\264\247\351\200\232\347\237\245\345\215\225/Xs_SeOutStockBillList.html" "b/WebTM/views/\351\224\200\345\224\256\347\256\241\347\220\206/\345\217\221\350\264\247\351\200\232\347\237\245\345\215\225/Xs_SeOutStockBillList.html" index 335732a..b786446 100644 --- "a/WebTM/views/\351\224\200\345\224\256\347\256\241\347\220\206/\345\217\221\350\264\247\351\200\232\347\237\245\345\215\225/Xs_SeOutStockBillList.html" +++ "b/WebTM/views/\351\224\200\345\224\256\347\256\241\347\220\206/\345\217\221\350\264\247\351\200\232\347\237\245\345\215\225/Xs_SeOutStockBillList.html" @@ -100,10 +100,7 @@ </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/webConfig.js"></script>--> + <script> layui.config({ base: '../../../layuiadmin/' //闈欐�佽祫婧愭墍鍦ㄨ矾寰� diff --git "a/WebTM/views/\351\224\200\345\224\256\347\256\241\347\220\206/\351\200\200\350\264\247\351\200\232\347\237\245\345\215\225/Xs_SeOutStockBackBillList.html" "b/WebTM/views/\351\224\200\345\224\256\347\256\241\347\220\206/\351\200\200\350\264\247\351\200\232\347\237\245\345\215\225/Xs_SeOutStockBackBillList.html" index f0aa495..0997f8a 100644 --- "a/WebTM/views/\351\224\200\345\224\256\347\256\241\347\220\206/\351\200\200\350\264\247\351\200\232\347\237\245\345\215\225/Xs_SeOutStockBackBillList.html" +++ "b/WebTM/views/\351\224\200\345\224\256\347\256\241\347\220\206/\351\200\200\350\264\247\351\200\232\347\237\245\345\215\225/Xs_SeOutStockBackBillList.html" @@ -1,15 +1,27 @@ 锘�<!DOCTYPE html> <html xmlns="http://www.w3.org/1999/xhtml"> <head> -<meta http-equiv="Content-Type" content="text/html; charset=utf-8"/> + <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/layui/layui.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/PubCustom.js"></script> + <script src="../../../layuiadmin/zgqCustom/zgqCustom.js"></script> + + <style type="text/css"> + input.layui-input.layui-unselect { + padding-right: 0; + } + </style> </head> <body> <div class="layui-fluid"> @@ -27,26 +39,25 @@ <div class="layui-inline"> <label class="layui-form-label">寮�濮嬫棩鏈�</label> <div class="layui-input-block"> - <input type="date" class="layui-input" id="HDate"> + <input type="date" class="layui-input" id="HBeginDate" style="width:190px;"> </div> </div> <div class="layui-inline"> <label class="layui-form-label">缁撴潫鏃ユ湡</label> <div class="layui-input-block"> - <input type="date" class="layui-input" id="HDate1"> + <input type="date" class="layui-input" id="HEndDate" style="width:190px;"> </div> </div> - <!--<div class="layui-inline"> - <label class="layui-form-label">璁㈠崟璺熻釜鍙�</label> + <div class="layui-inline"> + <label class="layui-form-label">鍗曟嵁鍙�</label> <div class="layui-input-block"> - <input type="text" class="layui-input" name="HOrderProcNO" id="HOrderProcNO"> + <input type="text" class="layui-input" name="HBillNo" id="HBillNo" style="width:190px;"> </div> - </div>--> + </div> <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnSearch" id="btnSearch"> <i class="layui-icon layui-icon-search layuiadmin-button-btn"></i> </button> <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnReSearch" id="btnReSearch" style="padding:0 5px">閲嶇疆</button> - <div class="layui-colla-content"> <div class="layui-inline"> <div class="layui-inline"> @@ -54,9 +65,21 @@ </div> </div> <div class="layui-inline"> - <label class="layui-form-label">鍗曟嵁鍙�</label> + <label class="layui-form-label">瀹㈡埛</label> <div class="layui-input-block"> - <input type="text" class="layui-input" name="WorkCenter" id="WorkCenter"> + <input type="text" class="layui-input" name="HCusID" id="HCusID" style="width:190px;"> + </div> + </div> + <div class="layui-inline"> + <label class="layui-form-label">閮ㄩ棬</label> + <div class="layui-input-block"> + <input type="text" class="layui-input" name="HDeptID" id="HDeptID" style="width:190px;"> + </div> + </div> + <div class="layui-inline"> + <label class="layui-form-label">涓荤</label> + <div class="layui-input-block"> + <input type="text" class="layui-input" name="HMangerID" id="HMangerID" style="width:190px;"> </div> </div> </div> @@ -65,14 +88,11 @@ <table class="" id="mainTable" lay-filter="mainTable"></table> <script type="text/html" id="toolbarDemo"> <div class="layui-btn-container"> - <!--<button type="button" class="layui-btn layui-btn-sm" lay-event="btn-getCheckData"><i class="layui-icon layui-icon-tips"></i>棰勮</button>--> - <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-reload"><i class="layui-icon layui-icon-refresh"></i>鍒锋柊</button> - <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-confirm" id="btn_confirm"><i class="layui-icon layui-icon-ok-circle"></i>纭</button> - <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-back" id="btn_back"><i class="layui-icon layui-icon-close-fill"></i>椹冲洖</button> - <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-details"><i class="layui-icon layui-icon-form"></i>璇︽儏</button> - <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-generate"><i class="layui-icon layui-icon-file"></i>鐢熸垚閫佽揣鍗�</button> - <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-exit"><i class="layui-icon layui-icon-return"></i>閫�鍑�</button> - + <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-Add"><i class="layui-icon layui-icon-file-b"></i>鏂板</button> + <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-Edit"><i class="layui-icon layui-icon-form"></i>缂栬緫</button> + <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-Delete"><i class="layui-icon layui-icon-delete"></i>鍒犻櫎</button> + <button type="button" class="layui-btn layui-btn-sm" lay-event="get_Refresh"><i class="layui-icon layui-icon-refresh-3"></i>鍒锋柊</button> + <button type="button" class="layui-btn layui-btn-sm" lay-event="get_Exit"><i class="layui-icon layui-icon-logout"></i>閫�鍑�</button> </div> </script> </form> @@ -80,124 +100,127 @@ </div> </div> </div> - <script src="../../../layuiadmin/layui/layui.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/Scripts/webConfig.js"></script>--> <script> layui.config({ base: '../../../layuiadmin/' //闈欐�佽祫婧愭墍鍦ㄨ矾寰� }).extend({ index: 'lib/index', //涓诲叆鍙fā鍧� - }).use(['index', 'form', 'table', 'element', 'laypage','laydate'], function () { + }).use(['index', 'form', 'table', 'element', 'laypage', 'laydate'], function () { var $ = layui.$ - , admin = layui.admin - , layer = layui.layer - , table = layui.table - , form = layui.form - , element = layui.element - , laypage = layui.laypage - , laydate = layui.laydate - //var sWhere = " 浜у搧浠g爜 = 'BX0002'"; + , admin = layui.admin + , layer = layui.layer + , table = layui.table + , form = layui.form + , element = layui.element + , laypage = layui.laypage + , laydate = layui.laydate + , util = layui.util + //鏌ヨ鏉′欢 var sWhere = ""; + var option = []; - var option = { - elem: '#mainTable' - //, toolbar: '#toolbarDemo' - ,height: 'full-50' - , page: true - ,cellMinWidth: 90 - , cols: [[ - { field: 'hmainid', title: 'hmainid', sort: true, hide: true } - , { field: '鏃ユ湡', title: '鏃ユ湡' } - , { field: '鍗曟嵁鍙�', title: '鍗曟嵁鍙�' } - , { field: 'HBillType', title: 'HBillType', hide: true } - , { field: 'HCusID', title: 'HCusID', hide: true } - , { field: '瀹㈡埛浠g爜', title: '瀹㈡埛浠g爜' } - , { field: '瀹㈡埛', title: '瀹㈡埛' } - , { field: 'HDeptID', title: 'HDeptID', hide: true } - , { field: '閮ㄩ棬浠g爜', title: '閮ㄩ棬浠g爜' } - , { field: '閮ㄩ棬', title: '閮ㄩ棬' } - , { field: '鎽樿', title: '鎽樿' } - , { field: '琛ㄥご澶囨敞', title: '琛ㄥご澶囨敞' } - , { field: 'hsubid', title: 'hsubid', hide: true } - , { field: 'HMaterID', title: 'HMaterID', hide: true } - , { field: '鐗╂枡浠g爜', title: '鐗╂枡浠g爜' } - , { field: '鐗╂枡鍚嶇О', title: '鐗╂枡鍚嶇О' } - , { field: '瑙勬牸鍨嬪彿', title: '瑙勬牸鍨嬪彿' } - , { field: '鎵瑰彿', title: '鎵瑰彿' } - , { field: 'HUnitID', title: 'HUnitID', hide: true } - , { field: '璁¢噺鍗曚綅浠g爜', title: '璁¢噺鍗曚綅浠g爜' } - , { field: '璁¢噺鍗曚綅', title: '璁¢噺鍗曚綅' } - , { field: '鏁伴噺', title: '鏁伴噺' } - , { field: '鍗曚环', title: '鍗曚环' } - , { field: '閲戦', title: '閲戦' } - , { field: 'HWHID', title: 'HWHID', hide: true } - , { field: '浠撳簱浠g爜', title: '浠撳簱浠g爜' } - , { field: '鍙戣揣浠撳簱', title: '鍙戣揣浠撳簱' } - , { field: '婧愬崟鍗曞彿', title: '婧愬崟鍗曞彿' } - , { field: '閿�鍞鍗曞彿', title: '閿�鍞鍗曞彿' } - , { field: '璁″垝璺熻釜鍙�', title: '璁″垝璺熻釜鍙�' } - , { field: '琛ㄤ綋澶囨敞', title: '琛ㄤ綋澶囨敞' } - , { field: '鍒跺崟浜�', title: '鍒跺崟浜�' } - , { field: '鍒跺崟鏃ユ湡', title: '鍒跺崟鏃ユ湡' } - , { field: '瀹℃牳浜�', title: '瀹℃牳浜�' } - , { field: '瀹℃牳鏃ユ湡', title: '瀹℃牳鏃ユ湡' } - , { field: '淇敼浜�', title: '淇敼浜�' } - , { field: '淇敼鏃ユ湡', title: '淇敼鏃ユ湡' } - , { field: '鍏抽棴浜�', title: '鍏抽棴浜�' } - , { field: '鍏抽棴鏃ユ湡', title: '鍏抽棴鏃ユ湡' } - , { field: '浣滃簾浜�', title: '浣滃簾浜�' } - , { field: '浣滃簾鏃ユ湡', title: '浣滃簾鏃ユ湡' } - ]] - }; + //鍒濆鍖栫晫闈� + set_ClearBill(); - //杩涘叆椤甸潰鏄剧ず鐨勭紦瀛樺垪琛� - var index0 = layer.load(0, { shade: false }); - $.ajax({ - //url: "http://61.130.49.162:9090/WMSAPI///Web/GetMAXNum", - url: GetWEBURL() + '/Xs_SeOutStockBackBill/list', - type: "GET", - data: { "sWhere": sWhere }, - success: function (data1) { - if (data1.count == 1) { - option.data = data1.data; - table.render(option); - layer.close(index0); - } else { - layer.close(index0); - layer.alert(data1.code + data1.Message, { icon: 5 }); - } - }, error: function () { - layer.close(index0); - layer.alert("鎺ュ彛璇锋眰澶辫触!", { icon: 5 }); - } - }); + //#endregion - //閲嶇疆鎸夐挳 + //#region 閲嶇疆鎸夐挳 form.on('submit(btnReSearch)', function (data) { - $("#HDate").val("");//寮�濮嬫棩鏈� - $("#HDate1").val("");//缁撴潫鏃ユ湡 - $("#WorkCenter").val("");//鍗曟嵁鍙� - $("#btnSearch").click(); + //娓呯┖杩囨护鏉′欢 + set_ClearQuery(); }); + //#endregion - //鏌ヨ鎸夐挳 - form.on('submit(btnSearch)', function (data) {//閫夋嫨浠撲綅 - var HDate = $("#HDate").val();//寮�濮嬫棩鏈� - var HDate1 = $("#HDate1").val();//缁撴潫鏃ユ湡 - var HOrderProcNO = $("#HOrderProcNO").val();//璁㈠崟璺熻釜鍙� - var WorkCenter = $("#WorkCenter").val();//鍗曟嵁鍙� - if (HDate) { - sWhere += " and 鏃ユ湡 >= '" + HDate + "'"; - } - if (HDate1) { - sWhere += " and 鏃ユ湡 <= '" + HDate1 + "'"; - } - if (WorkCenter) { - sWhere += " and 鍗曟嵁鍙� like '%" + WorkCenter + "%'"; - } - var index = layer.load(0, { shade: false }); + //#region 鏌ヨ鎸夐挳 + form.on('submit(btnSearch)', function (data) { + get_FastQuery(table, option); + }); + //#endregion + + //#region 鍒濆鍖栫晫闈� + function set_ClearBill() { + //鍒濆鍖栬〃鏍� + set_InitGrid(); + //鏌ヨ + get_Display(sWhere); + } + //#endregion + //#region 鍒濆鍖栬〃鏍兼柟娉� + $("#HBeginDate").val(Format(new Date(new Date() - 1000 * 60 * 60 * 24 * 30), "yyyy-MM-dd")); + $("#HEndDate").val(Format(new Date(), "yyyy-MM-dd")); + function set_InitGrid() { + option = { + elem: '#mainTable' + , toolbar: '#toolbarDemo' + , height: 'full-50' + , page: true + , cellMinWidth: 90 + , cols: [[ + { type: 'checkbox', fixed: 'left' } + ,{ field: 'hmainid', title: 'hmainid', sort: true, hide: true } + , { field: '鏃ユ湡', title: '鏃ユ湡', width: 150 } + , { field: '鍗曟嵁鍙�', title: '鍗曟嵁鍙�' } + , { field: 'HBillType', title: 'HBillType', hide: true } + , { field: 'HCusID', title: 'HCusID', width: 120, hide: true } + , { field: '瀹㈡埛浠g爜', title: '瀹㈡埛浠g爜', width: 150 } + , { field: '瀹㈡埛', title: '瀹㈡埛', width: 120 } + , { field: 'HDeptID', title: 'HDeptID', width: 120, hide: true } + , { field: '閮ㄩ棬浠g爜', title: '閮ㄩ棬浠g爜', width: 150 } + , { field: '閮ㄩ棬', title: '閮ㄩ棬' } + + , { field: 'HCurID', title: 'HCurID', width: 120, hide: true } + , { field: '甯佸埆浠g爜', title: '甯佸埆浠g爜' } + , { field: '甯佸埆', title: '甯佸埆' } + , { field: '鎽樿', title: '鎽樿' } + + , { field: 'HManagerID', title: 'HManagerID', width: 120, hide: true } + , { field: '涓荤浠g爜', title: '涓荤浠g爜' } + , { field: '涓荤', title: '涓荤' } + , { field: 'HEmpID', title: 'HEmpID', width: 120, hide: true } + , { field: '涓氬姟鍛樹唬鐮�', title: '涓氬姟鍛樹唬鐮�', width: 120 } + , { field: '涓氬姟鍛�', title: '涓氬姟鍛�' } + , { field: '琛ㄥご澶囨敞', title: '琛ㄥご澶囨敞' } + , { field: 'hsubid', title: 'hsubid', hide: true } + , { field: 'HMaterID', title: 'HMaterID', hide: true } + , { field: '鐗╂枡浠g爜', title: '鐗╂枡浠g爜', width: 150 } + , { field: '鐗╂枡鍚嶇О', title: '鐗╂枡鍚嶇О', width: 150 } + , { field: '瑙勬牸鍨嬪彿', title: '瑙勬牸鍨嬪彿' } + , { field: '鎵瑰彿', title: '鎵瑰彿' } + , { field: 'HUnitID', title: 'HUnitID', hide: true } + , { field: '璁¢噺鍗曚綅浠g爜', title: '璁¢噺鍗曚綅浠g爜', width: 150 } + , { field: '璁¢噺鍗曚綅', title: '璁¢噺鍗曚綅', width: 150 } + , { field: '鏁伴噺', title: '鏁伴噺' } + , { field: '鍗曚环', title: '鍗曚环' } + , { field: '閲戦', title: '閲戦' } + , { field: '鍗曚环', title: '鍗曚环' } + , { field: 'HWHID', title: 'HWHID', hide: true } + , { field: '浠撳簱浠g爜', title: '浠撳簱浠g爜', width: 150 } + , { field: '鍙戣揣浠撳簱', title: '鍙戣揣浠撳簱' } + , { field: '婧愬崟鍗曞彿', title: '婧愬崟鍗曞彿', width: 125 } + , { field: '閿�鍞鍗曞彿', title: '閿�鍞鍗曞彿', width: 125 } + , { field: '璁″垝璺熻釜鍙�', title: '璁″垝璺熻釜鍙�', width: 125 } + , { field: '琛ㄤ綋澶囨敞', title: '琛ㄤ綋澶囨敞', width: 125 } + , { field: '鍒跺崟浜�', title: '鍒跺崟浜�', width: 125 } + , { field: '鍒跺崟鏃ユ湡', title: '鍒跺崟鏃ユ湡', width: 200, templet: "<div>{{d.鍒跺崟鏃ユ湡 ==null ?'':layui.util.toDateString(d.鍒跺崟鏃ユ湡, 'yyyy-MM-dd HH:mm:ss')}}</div>" } + , { field: '瀹℃牳浜�', title: '瀹℃牳浜�', width: 125 } + , { field: '瀹℃牳鏃ユ湡', title: '瀹℃牳鏃ユ湡', width: 200, templet: "<div>{{d.瀹℃牳鏃ユ湡 ==null ? '':layui.util.toDateString(d.瀹℃牳鏃ユ湡, 'yyyy-MM-dd HH:mm:ss')}}</div>" } + , { field: '淇敼浜�', title: '淇敼浜�', width: 125 } + , { field: '淇敼鏃ユ湡', title: '淇敼鏃ユ湡', width: 200, templet: "<div>{{d.淇敼鏃ユ湡 ==null ?'':layui.util.toDateString(d.淇敼鏃ユ湡, 'yyyy-MM-dd HH:mm:ss')}}</div>" } + , { field: '鍏抽棴浜�', title: '鍏抽棴浜�', width: 125 } + , { field: '鍏抽棴鏃ユ湡', title: '鍏抽棴鏃ユ湡', width: 200, templet: "<div>{{d.鍏抽棴鏃ユ湡 ==null ?'':layui.util.toDateString(d.鍏抽棴鏃ユ湡, 'yyyy-MM-dd HH:mm:ss')}}</div>" } + , { field: '浣滃簾浜�', title: '浣滃簾浜�', width: 125 } + , { field: '浣滃簾鏃ユ湡', title: '浣滃簾鏃ユ湡', width: 200, templet: "<div>{{d.浣滃簾鏃ユ湡 ==null ?'':layui.util.toDateString(d.浣滃簾鏃ユ湡, 'yyyy-MM-dd HH:mm:ss')}}</div>" } + + ]] + }; + } + //杩涘叆椤甸潰鏄剧ず鐨勭紦瀛樺垪琛� + function get_Display(sWhere) { + var ajaxLoad = layer.load(); $.ajax({ url: GetWEBURL() + '/Xs_SeOutStockBackBill/list', type: "GET", @@ -206,33 +229,170 @@ if (data1.count == 1) { option.data = data1.data; table.render(option); - layer.close(index); - layer.alert("鏌ヨ鎴愬姛", { icon: 1 }); + layer.close(ajaxLoad); } else { - layer.close(index); + layer.close(ajaxLoad); layer.alert(data1.code + data1.Message, { icon: 5 }); } }, error: function () { - layer.close(index); + layer.close(ajaxLoad); layer.alert("鎺ュ彛璇锋眰澶辫触!", { icon: 5 }); } }); - sWhere = "";//璋冪敤鎺ュ彛鍚庢竻绌簊Where缂撳瓨 + } + //澶村伐鍏锋爮浜嬩欢 + table.on('toolbar(mainTable)', function (obj) { + var checkStatus = table.checkStatus(obj.config.id); + switch (obj.event) { + case 'btn-Add': + //椤甸潰灞�-鑷畾涔� + layer.open({ + type: 2, + skin: 'layui-layer-rim', //鍔犱笂杈规 + title: '鏂板閫�璐ч�氱煡鍗�', + closeBtn: 1, + shift: 2, + area: ['100%', '100%'], + maxmin: true, + content: '../../閲囪喘绠$悊/鏀舵枡閫氱煡鍗�/Add_Edit_Cg_POInStockBillList.html?OperationType=1&linterid=0&HSouceBillType=0&closeType=1', + end: function () { + //鍒锋柊椤甸潰, + location.reload(); + }, + success: function (layero, index) { + + } + }); + break; + case 'btn-Edit': + var checkStatus = table.checkStatus('mainTable') + , data = checkStatus.data; + if (checkStatus.data.length === 1) { + var hID = data[0].hmainid.toString(); + //if (AllowLoadData(sSubStr) != false) {//闈炵┖楠岃瘉 + layer.open({ + type: 2 + , area: ['100%', '100%'] + , title: '缂栬緫閫�璐ч�氱煡鍗�' + , closeBtn: 1 + , shade: 0.6 //閬僵閫忔槑搴� + , maxmin: true //鍏佽鍏ㄥ睆鏈�灏忓寲 + , anim: 0 //0-6鐨勫姩鐢诲舰寮忥紝-1涓嶅紑鍚� + , content: '../../閲囪喘绠$悊/鏀舵枡閫氱煡鍗�/Add_Edit_Cg_POInStockBillList.html?OperationType=3&linterid=' + hID + '&HSouceBillType=0&closeType=1' + , resize: false, + end: function () { + //鍒锋柊椤甸潰, + location.reload(); + } + , cancel: function () { + //$(".layui-btn").removeClass("layui-btn-disabled"); + } + }) + + } else { + layer.msg('璇烽�夋嫨涓�琛屾暟鎹紪杈戯紒'); + } + + break; + case 'btn-Delete': + var checkStatus = table.checkStatus('mainTable') + , data = checkStatus.data; + if (checkStatus.data.length === 1) { + var InterID = data[0].hmainid.toString(); + //閫昏緫鍒犻櫎鏂规硶 + layer.confirm("纭瑕佸垹闄ゅ悧锛屽垹闄ゅ悗涓嶈兘鎭㈠", { title: "鍒犻櫎纭" }, function (index) { + $.ajax({ + type: "GET", + url: GetWEBURL() + "Xs_SeOutStockBackBill/DeltetSeOutStockBackBill", //鏂规硶鎵�鍦ㄩ〉闈㈠拰鏂规硶鍚� + data: { "HInterID": InterID }, + success: function (result) { + if (result.count == 1) { + layer.msg(result.Message, { time: 1 * 1000, icon: 1 }, function () { + // 寰楀埌frame绱㈠紩 + var index = layer.getFrameIndex(window.name); + //鍏抽棴褰撳墠frame + layer.close(index); + //淇敼涓哄姛鍚庡埛鏂扮晫闈� + window.location.reload(); + }); + + } else { + layer.alert(result.code + result.Message, { icon: 5 }); + } + }, error: function () { + layer.alert("鎺ュ彛璇锋眰澶辫触!", { icon: 5 }); + } + }); + }) + } + else { + layer.msg('璇烽�夋嫨涓�琛屾暟鎹垹闄わ紒'); + } + break; + //鍒锋柊 + case 'get_Refresh': get_Refresh(); + break; + //閫�鍑烘寜閽� + case 'get_Exit': Pub_Close(2); + break; + }; }); - //laydate.render({ - // elem: '#HDate' - // , type: 'datetime' - // , trigger: 'click' - // , format:'yyyy-MM-dd HH:mm' - //}); + //#region 蹇�熻繃婊� + function get_FastQuery(table, option) { + var HDate = $("#HBeginDate").val();//寮�濮嬫棩鏈� + var HDate1 = $("#HEndDate").val();//缁撴潫鏃ユ湡 + var HBillNo = $("#HBillNo").val();//鍗曟嵁鍙� + var HCusID = $("#HCusID").val(); + var HDeptID = $("#HDeptID").val(); + var HMangerID = $("#HMangerID").val(); + if (HDate) { + sWhere += " and CONVERT(varchar(100),鏃ユ湡, 23) >= '" + HDate + "'"; + } + if (HDate1) { + sWhere += " and CONVERT(varchar(100),鏃ユ湡, 23) <= '" + HDate1 + "'"; + } + if (HBillNo) { + sWhere += " and 鍗曟嵁鍙� like '%" + HBillNo + "%'"; + } + if (HCusID) { + sWhere += " and 瀹㈡埛 like '%" + HCusID + "%'"; + } + if (HDeptID) { + sWhere += " and 閮ㄩ棬 like '%" + HDeptID + "%'"; + } + if (HMangerID) { + sWhere += " and 涓荤 like '%" + HMangerID + "%'"; + } + get_Display(sWhere); + sWhere = "";//璋冪敤鎺ュ彛鍚庢竻绌簊Where缂撳瓨 + } + //#endregion + //#region 閲嶇疆杩囨护鏉′欢 + function set_ClearQuery() { + $("#HDate").val("");//寮�濮嬫棩鏈� + $("#HDate1").val("");//缁撴潫鏃ユ湡 + $("#HBillNo").val("");// + $("#HCusID").val(""); + $("#HDeptID").val(""); + $("#HMangerID").val(""); + sWhere = ""; + } + //#endregion + + //#region 鍒锋柊 + function get_Refresh() { + set_ClearQuery(); + get_Display(sWhere); + } + //#endregion //浠ヤ笂鏄痩ayui妯″潡 }); - + </script> diff --git "a/WebTM/views/\351\242\206\346\226\231\345\217\221\350\264\247/\351\224\200\345\224\256\345\207\272\345\272\223/Kf_SellOutBillList.html" "b/WebTM/views/\351\242\206\346\226\231\345\217\221\350\264\247/\351\224\200\345\224\256\345\207\272\345\272\223/Kf_SellOutBillList.html" index 5a9d424..6b446d3 100644 --- "a/WebTM/views/\351\242\206\346\226\231\345\217\221\350\264\247/\351\224\200\345\224\256\345\207\272\345\272\223/Kf_SellOutBillList.html" +++ "b/WebTM/views/\351\242\206\346\226\231\345\217\221\350\264\247/\351\224\200\345\224\256\345\207\272\345\272\223/Kf_SellOutBillList.html" @@ -1,14 +1,22 @@ 锘�<!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/layui/layui.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/PubCustom.js"></script> + <script src="../../../layuiadmin/zgqCustom/zgqCustom.js"></script> + <style type="text/css"> input.layui-input.layui-unselect { padding-right: 0; @@ -28,64 +36,63 @@ <span>鏇村</span> </div> </div> - <!--<div class="layui-inline"> - <label class="layui-form-label">鍗曟嵁绫诲瀷</label> + <div class="layui-inline"> + <label class="layui-form-label">寮�濮嬫棩鏈�</label> <div class="layui-input-block"> - <select name="HBillType" id="HBillType"> - <option value="">鎵�鏈�</option> - <option value="ZHXJ">涓嬫灦鎵捐揣鍗�</option> - <option value="ZHSJ">涓婃灦褰掕繕鍗�</option> - </select> + <input type="date" class="layui-input" id="HBeginDate" style="width:190px;"> + </div> + </div> + <div class="layui-inline"> + <label class="layui-form-label">缁撴潫鏃ユ湡</label> + <div class="layui-input-block"> + <input type="date" class="layui-input" id="HEndDate" style="width:190px;"> </div> </div> <div class="layui-inline"> <label class="layui-form-label">鍗曟嵁鍙�</label> <div class="layui-input-block"> - <input type="text" class="layui-input" name="HBillNo" id="HBillNo"> + <input type="text" class="layui-input" name="HBillNo" id="HBillNo" style="width:190px;"> </div> </div> - <div class="layui-inline"> - <label class="layui-form-label">鍒跺崟浜�</label> - <div class="layui-input-block"> - <input type="text" class="layui-input" name="HCreateBy" id="HCreateBy"> - </div> - </div>--> <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnSearch" id="btnSearch"> <i class="layui-icon layui-icon-search layuiadmin-button-btn"></i> </button> - <!--<button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnReSearch" id="btnReSearch" style="padding:0 5px">閲嶇疆</button>--> - <!--<div class="layui-colla-content"> + <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnReSearch" id="btnReSearch" style="padding:0 5px">閲嶇疆</button> + <div class="layui-colla-content"> <div class="layui-inline"> <div class="layui-inline"> <span>鍏朵粬鏉′欢></span> </div> </div> <div class="layui-inline"> - <label class="layui-form-label">寮�濮嬫椂闂�</label> + <label class="layui-form-label">瀹㈡埛</label> <div class="layui-input-block"> - <input type="date" class="layui-input" name="BenginHCreateDate" id="BenginHCreateDate"> + <input type="text" class="layui-input" name="HCusID" id="HCusID" style="width:190px;"> </div> </div> <div class="layui-inline"> - <label class="layui-form-label">缁撴潫鏃堕棿</label> + <label class="layui-form-label">閮ㄩ棬</label> <div class="layui-input-block"> - <input type="date" class="layui-input" name="EndHCreateDate" id="EndHCreateDate"> + <input type="text" class="layui-input" name="HDeptID" id="HDeptID" style="width:190px;"> </div> </div> - </div>--> + <div class="layui-inline"> + <label class="layui-form-label">涓荤</label> + <div class="layui-input-block"> + <input type="text" class="layui-input" name="HMangerID" id="HMangerID" style="width:190px;"> + </div> + </div> + </div> </div> </div> <table class="" id="mainTable" lay-filter="mainTable"></table> <script type="text/html" id="toolbarDemo"> <div class="layui-btn-container"> - <!--<button type="button" class="layui-btn layui-btn-sm" lay-event="btn-getCheckData"><i class="layui-icon layui-icon-tips"></i>棰勮</button>--> - <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-reload"><i class="layui-icon layui-icon-refresh"></i>鍒锋柊</button> - <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-confirm" id="btn_confirm"><i class="layui-icon layui-icon-ok-circle"></i>纭</button> - <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-back" id="btn_back"><i class="layui-icon layui-icon-close-fill"></i>椹冲洖</button> - <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-details"><i class="layui-icon layui-icon-form"></i>璇︽儏</button> - <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-generate"><i class="layui-icon layui-icon-file"></i>鐢熸垚閫佽揣鍗�</button> - <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-exit"><i class="layui-icon layui-icon-return"></i>閫�鍑�</button> - + <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-Add"><i class="layui-icon layui-icon-file-b"></i>鏂板</button> + <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-Edit"><i class="layui-icon layui-icon-form"></i>缂栬緫</button> + <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-Delete"><i class="layui-icon layui-icon-delete"></i>鍒犻櫎</button> + <button type="button" class="layui-btn layui-btn-sm" lay-event="get_Refresh"><i class="layui-icon layui-icon-refresh-3"></i>鍒锋柊</button> + <button type="button" class="layui-btn layui-btn-sm" lay-event="get_Exit"><i class="layui-icon layui-icon-logout"></i>閫�鍑�</button> </div> </script> </form> @@ -93,10 +100,10 @@ </div> </div> </div> - <script src="../../../layuiadmin/layui/layui.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/Scripts/webConfig.js"></script>--> <script> layui.config({ base: '../../../layuiadmin/' //闈欐�佽祫婧愭墍鍦ㄨ矾寰� @@ -114,162 +121,258 @@ , util = layui.util //鏌ヨ鏉′欢 var sWhere = ""; + var option = []; - var option = { - elem: '#mainTable' - //, toolbar: '#toolbarDemo' - , height: 'full-50' - , page: true - , cellMinWidth: 90 - , cols: [[ - { field: 'hmainid', title: '鍗曟嵁ID', hide: true } - , { field: '鏃ユ湡', title: '鏃ユ湡', width: 160 } - , { field: '鍗曟嵁鍙�', title: '鍗曟嵁鍙�', width: 160 } - , { field: '绾㈣摑鍗曟爣璁�', title: '绾㈣摑鍗曟爣璁�', width: 160 } - , { field: 'hsupid', title: 'hsupid', width: 200, hide: true } - , { field: '瀹㈡埛', title: '瀹㈡埛', width: 200 } - , { field: 'HEmpID', title: 'HEmpID', width: 200, hide: true } - , { field: '涓氬姟鍛�', title: '涓氬姟鍛�', width: 200 } - , { field: 'hmanagerid', title: 'hmanagerid', width: 200, hide: true } - , { field: '涓荤', title: '涓荤', width: 200 } - , { field: 'hsecmanagerid', title: 'hsecmanagerid', width: 160, hide: true } - , { field: '鍙戣揣浜�', title: '鍙戣揣浜�', width: 160} - , { field: 'hkeeperid', title: 'hkeeperid', width: 160, hide: true } - , { field: '淇濈鍛�', title: '淇濈鍛�', width: 200 } - , { field: 'HDeptID', title: 'HDeptID', width: 200, hide: true } - , { field: '閮ㄩ棬', title: '閮ㄩ棬', width: 200 } - , { field: '閿�鍞柟寮�', title: '閿�鍞柟寮�', width: 200 } - , { field: 'hsubid', title: 'hsubid', width: 200, hide: true } - , { field: 'hmaterid', title: 'hmaterid', width: 200, hide: true } - , { field: '鐗╂枡浠g爜', title: '鐗╂枡浠g爜', width: 200 } - , { field: '鐗╂枡鍚嶇О', title: '鐗╂枡鍚嶇О', width: 115 } - , { field: '瑙勬牸鍨嬪彿', title: '瑙勬牸鍨嬪彿', width: 115 } - , { field: 'hunitid', title: 'hunitid', width: 200, hide: true } - , { field: '璁¢噺鍗曚綅浠g爜', title: '璁¢噺鍗曚綅浠g爜', width: 200 } - , { field: '璁¢噺鍗曚綅', title: '璁¢噺鍗曚綅', width: 115 } - , { field: '鏁伴噺', title: '鏁伴噺', width: 200 } - , { field: '鍗曚环', title: '鍗曚环', width: 200 } - , { field: '閲戦', title: '閲戦', width: 200 } - , { field: 'hwhid', title: 'hwhid', width: 200, hide: true } - , { field: '鍙戣揣浠撳簱浠g爜', title: '鍙戣揣浠撳簱浠g爜', width: 115 } - , { field: '鍙戣揣浠撳簱', title: '鍙戣揣浠撳簱', width: 200 } - , { field: '鏍搁攢閲戦', title: '鏍搁攢閲戦', width: 200 } - , { field: '鏍搁攢鏈綅甯侀噾棰�', title: '鏍搁攢鏈綅甯侀噾棰�', width: 200 } - , { field: '鏍搁攢鍓╀綑閲戦', title: '鏍搁攢鍓╀綑閲戦', width: 115 } - , { field: '鏍搁攢鐘舵��', title: '鏍搁攢鐘舵��', width: 200 } - , { field: '琛ㄤ綋澶囨敞', title: '琛ㄤ綋澶囨敞', width: 200 } - , { field: '婧愬崟鍗曞彿', title: '婧愬崟鍗曞彿', width: 200 } - , { field: '閲囪喘璁㈠崟鍙�', title: '閲囪喘璁㈠崟鍙�', width: 200 } - , { field: '閿�鍞鍗曞彿', title: '閿�鍞鍗曞彿', width: 200 } - , { field: '鍒跺崟浜�', title: '鍒跺崟浜�', width: 200 } - , { field: '鍒跺崟鏃ユ湡', title: '鍒跺崟鏃ユ湡', width: 115 } - , { field: '瀹℃牳浜�', title: '瀹℃牳浜�', width: 200 } - , { field: '瀹℃牳鏃ユ湡', title: '瀹℃牳鏃ユ湡', width: 200 } - , { field: '淇敼浜�', title: '淇敼浜�', width: 200 } - , { field: '淇敼鏃ユ湡', title: '淇敼鏃ユ湡', width: 115 } - , { field: '鍏抽棴浜�', title: '鍏抽棴浜�', width: 115 } - , { field: '鍏抽棴鏃ユ湡', title: '鍏抽棴鏃ユ湡', width: 200 } - , { field: '浣滃簾浜�', title: '浣滃簾浜�', width: 200 } - , { field: '浣滃簾鏃ユ湡', title: '浣滃簾鏃ユ湡', width: 200 } - , { field: '璁″垝璺熻釜鍙�', title: '璁″垝璺熻釜鍙�', width: 115 } - ]] - }; + //鍒濆鍖栫晫闈� + set_ClearBill(); - var index = layer.load(0); - //杩涘叆椤甸潰鏄剧ず鐨勭紦瀛樺垪琛� - $.ajax({ - //url: "http://61.130.49.162:9090/WMSAPI///Web/GetMAXNum", - url: GetWEBURL() + '/Kf_SellOutBill/GetSellOutBillList', - type: "GET", - data: { "sWhere": sWhere}, - success: function (data1) { - if (data1.count == 1) { - option.data = data1.data; - table.render(option); - layer.close(index); - } else { - layer.close(index); - layer.alert(data1.code + data1.Message, { icon: 5 }); - } - }, error: function () { - layer.close(index); - layer.alert("鎺ュ彛璇锋眰澶辫触!", { icon: 5 }); - } + //#endregion + + //#region 閲嶇疆鎸夐挳 + form.on('submit(btnReSearch)', function (data) { + //娓呯┖杩囨护鏉′欢 + set_ClearQuery(); }); + //#endregion - //閲嶇疆鎸夐挳 - //form.on('submit(btnReSearch)', function (data) { - // $("#HBillType").val("");//鍗曟嵁绫诲瀷 - // $("#HBillNo").val("");//鍗曟嵁鍙� - // $("#HSourceBillNo").val("");//婧愬崟鍙� - // $("#HCreateBy").val("");//鍒跺崟浜� - // $("#BenginHCreateDate").val("");//寮�濮嬪埗鍗曟椂闂� - // $("#EndHCreateDate").val("");//缁撴潫鍒跺崟鏃堕棿 - // $("#btnSearch").click(); - //}); + //#region 鏌ヨ鎸夐挳 + form.on('submit(btnSearch)', function (data) { + get_FastQuery(table, option); + }); + //#endregion - //鏌ヨ鎸夐挳 - form.on('submit(btnSearch)', function (data) {//閫夋嫨浠撲綅 - //var HBillType = $("#HBillType").val();//鍗曟嵁绫诲瀷 - //var HBillNo = $("#HBillNo").val();//鍗曟嵁鍙� - //var HCreateBy = $("#HCreateBy").val();//鍒跺崟浜� - //var BenginHCreateDate = $("#BenginHCreateDate").val();//寮�濮嬪埗鍗曟椂闂� - //var EndHCreateDate = $("#EndHCreateDate").val();//缁撴潫鍒跺崟鏃堕棿 - //if (HBillNo) { - // sWhere += " and HBillNo like '%" + HBillNo + "%'"; - //} - //if (HCreateBy) { - // sWhere += " and HCreateBy like '%" + HCreateBy + "%'"; - //} - //if (BenginHCreateDate) { - // sWhere += " and CONVERT(varchar(100),HCreateDate, 23) >= '" + BenginHCreateDate + "'"; - //} - //if (EndHCreateDate) { - // sWhere += " and CONVERT(varchar(100),HCreateDate, 23) <= '" + EndHCreateDate + "'"; - //} - var index = layer.load(0); + //#region 鍒濆鍖栫晫闈� + function set_ClearBill() { + //鍒濆鍖栬〃鏍� + set_InitGrid(); + //鏌ヨ + get_Display(sWhere); + } + //#endregion + //#region 鍒濆鍖栬〃鏍兼柟娉� + $("#HBeginDate").val(Format(new Date(new Date() - 1000 * 60 * 60 * 24 * 30), "yyyy-MM-dd")); + $("#HEndDate").val(Format(new Date(), "yyyy-MM-dd")); + function set_InitGrid() { + option = { + elem: '#mainTable' + , toolbar: '#toolbarDemo' + , height: 'full-50' + , page: true + , cellMinWidth: 90 + , cols: [[ + { type: 'checkbox', fixed: 'left' } + ,{ field: 'hmainid', title: 'hmainid', sort: true, hide: true } + ,{ field: '鍗曟嵁鍙�', title: '鍗曟嵁鍙�', hide: true } + , { field: '鏃ユ湡', title: '鏃ユ湡', width: 160 } + , { field: '鍗曟嵁鍙�', title: '鍗曟嵁鍙�', width: 160 } + , { field: '绾㈣摑鍗曟爣璁�', title: '绾㈣摑鍗曟爣璁�', width: 160 } + , { field: 'hsupid', title: 'hsupid', width: 200, hide: true } + , { field: '瀹㈡埛', title: '瀹㈡埛', width: 200 } + , { field: 'HEmpID', title: 'HEmpID', width: 200, hide: true } + , { field: '涓氬姟鍛�', title: '涓氬姟鍛�', width: 200 } + , { field: 'hmanagerid', title: 'hmanagerid', width: 200, hide: true } + , { field: '涓荤', title: '涓荤', width: 200 } + , { field: 'hsecmanagerid', title: 'hsecmanagerid', width: 160, hide: true } + , { field: '鍙戣揣浜�', title: '鍙戣揣浜�', width: 160 } + , { field: 'hkeeperid', title: 'hkeeperid', width: 160, hide: true } + , { field: '淇濈鍛�', title: '淇濈鍛�', width: 200 } + , { field: 'HDeptID', title: 'HDeptID', width: 200, hide: true } + , { field: '閮ㄩ棬', title: '閮ㄩ棬', width: 200 } + , { field: '閿�鍞柟寮�', title: '閿�鍞柟寮�', width: 200 } + , { field: 'hsubid', title: 'hsubid', width: 200, hide: true } + , { field: 'hmaterid', title: 'hmaterid', width: 200, hide: true } + , { field: '鐗╂枡浠g爜', title: '鐗╂枡浠g爜', width: 200 } + , { field: '鐗╂枡鍚嶇О', title: '鐗╂枡鍚嶇О', width: 115 } + , { field: '瑙勬牸鍨嬪彿', title: '瑙勬牸鍨嬪彿', width: 115 } + , { field: 'hunitid', title: 'hunitid', width: 200, hide: true } + , { field: '璁¢噺鍗曚綅浠g爜', title: '璁¢噺鍗曚綅浠g爜', width: 200 } + , { field: '璁¢噺鍗曚綅', title: '璁¢噺鍗曚綅', width: 115 } + , { field: '鏁伴噺', title: '鏁伴噺', width: 200 } + , { field: '鍗曚环', title: '鍗曚环', width: 200 } + , { field: '閲戦', title: '閲戦', width: 200 } + , { field: '鍒跺崟浜�', title: '鍒跺崟浜�', width: 125 } + , { field: '鍒跺崟鏃ユ湡', title: '鍒跺崟鏃ユ湡', width: 200, templet: "<div>{{d.鍒跺崟鏃ユ湡 ==null ?'':layui.util.toDateString(d.鍒跺崟鏃ユ湡, 'yyyy-MM-dd HH:mm:ss')}}</div>" } + , { field: '瀹℃牳浜�', title: '瀹℃牳浜�', width: 125 } + , { field: '瀹℃牳鏃ユ湡', title: '瀹℃牳鏃ユ湡', width: 200, templet: "<div>{{d.瀹℃牳鏃ユ湡 ==null ? '':layui.util.toDateString(d.瀹℃牳鏃ユ湡, 'yyyy-MM-dd HH:mm:ss')}}</div>" } + , { field: '淇敼浜�', title: '淇敼浜�', width: 125 } + , { field: '淇敼鏃ユ湡', title: '淇敼鏃ユ湡', width: 200, templet: "<div>{{d.淇敼鏃ユ湡 ==null ?'':layui.util.toDateString(d.淇敼鏃ユ湡, 'yyyy-MM-dd HH:mm:ss')}}</div>" } + , { field: '鍏抽棴浜�', title: '鍏抽棴浜�', width: 125 } + , { field: '鍏抽棴鏃ユ湡', title: '鍏抽棴鏃ユ湡', width: 200, templet: "<div>{{d.鍏抽棴鏃ユ湡 ==null ?'':layui.util.toDateString(d.鍏抽棴鏃ユ湡, 'yyyy-MM-dd HH:mm:ss')}}</div>" } + , { field: '浣滃簾浜�', title: '浣滃簾浜�', width: 125 } + , { field: '浣滃簾鏃ユ湡', title: '浣滃簾鏃ユ湡', width: 200, templet: "<div>{{d.浣滃簾鏃ユ湡 ==null ?'':layui.util.toDateString(d.浣滃簾鏃ユ湡, 'yyyy-MM-dd HH:mm:ss')}}</div>" } + + ]] + }; + } + //杩涘叆椤甸潰鏄剧ず鐨勭紦瀛樺垪琛� + function get_Display(sWhere) { + var ajaxLoad = layer.load(); $.ajax({ - //url: "http://61.130.49.162:9090/WMSAPI///Web/GetMAXNum", - url: GetWEBURL1() + '/Kf_SellOutBill/GetSellOutBillList', + url: GetWEBURL() + '/Kf_SellOutBill/GetSellOutBillList', type: "GET", - data: { "sWhere": sWhere}, + data: { "sWhere": sWhere }, success: function (data1) { if (data1.count == 1) { option.data = data1.data; table.render(option); - layer.close(index); - layer.alert("鏌ヨ鎴愬姛", { icon: 1 }); + layer.close(ajaxLoad); } else { - layer.close(index); + layer.close(ajaxLoad); layer.alert(data1.code + data1.Message, { icon: 5 }); } }, error: function () { - layer.close(index); - layer.alert("鎺ュ彛澶辨晥!", { icon: 5 }); + layer.close(ajaxLoad); + layer.alert("鎺ュ彛璇锋眰澶辫触!", { icon: 5 }); } }); - //璋冪敤鎺ュ彛鍚庢竻绌簊Where缂撳瓨 + } + //澶村伐鍏锋爮浜嬩欢 + table.on('toolbar(mainTable)', function (obj) { + var checkStatus = table.checkStatus(obj.config.id); + switch (obj.event) { + case 'btn-Add': + //椤甸潰灞�-鑷畾涔� + layer.open({ + type: 2, + skin: 'layui-layer-rim', //鍔犱笂杈规 + title: '鏂板閫�璐ч�氱煡鍗�', + closeBtn: 1, + shift: 2, + area: ['100%', '100%'], + maxmin: true, + content: '../../閲囪喘绠$悊/鏀舵枡閫氱煡鍗�/Add_Edit_Cg_POInStockBillList.html?OperationType=1&linterid=0&HSouceBillType=0&closeType=1', + end: function () { + //鍒锋柊椤甸潰, + location.reload(); + }, + success: function (layero, index) { + + } + }); + break; + case 'btn-Edit': + var checkStatus = table.checkStatus('mainTable') + , data = checkStatus.data; + if (checkStatus.data.length === 1) { + var hID = data[0].hmainid.toString(); + //if (AllowLoadData(sSubStr) != false) {//闈炵┖楠岃瘉 + layer.open({ + type: 2 + , area: ['100%', '100%'] + , title: '缂栬緫閫�璐ч�氱煡鍗�' + , closeBtn: 1 + , shade: 0.6 //閬僵閫忔槑搴� + , maxmin: true //鍏佽鍏ㄥ睆鏈�灏忓寲 + , anim: 0 //0-6鐨勫姩鐢诲舰寮忥紝-1涓嶅紑鍚� + , content: '../../閲囪喘绠$悊/鏀舵枡閫氱煡鍗�/Add_Edit_Cg_POInStockBillList.html?OperationType=3&linterid=' + hID + '&HSouceBillType=0&closeType=1' + , resize: false, + end: function () { + //鍒锋柊椤甸潰, + location.reload(); + } + , cancel: function () { + //$(".layui-btn").removeClass("layui-btn-disabled"); + } + }) + + } else { + layer.msg('璇烽�夋嫨涓�琛屾暟鎹紪杈戯紒'); + } + + break; + case 'btn-Delete': + var checkStatus = table.checkStatus('mainTable') + , data = checkStatus.data; + if (checkStatus.data.length === 1) { + var InterID = data[0].hmainid.toString(); + //閫昏緫鍒犻櫎鏂规硶 + layer.confirm("纭瑕佸垹闄ゅ悧锛屽垹闄ゅ悗涓嶈兘鎭㈠", { title: "鍒犻櫎纭" }, function (index) { + $.ajax({ + type: "GET", + url: GetWEBURL() + "Kf_SellOutBill/DeltetSellOutBill", //鏂规硶鎵�鍦ㄩ〉闈㈠拰鏂规硶鍚� + data: { "HInterID": InterID }, + success: function (result) { + if (result.count == 1) { + layer.msg(result.Message, { time: 1 * 1000, icon: 1 }, function () { + // 寰楀埌frame绱㈠紩 + var index = layer.getFrameIndex(window.name); + //鍏抽棴褰撳墠frame + layer.close(index); + //淇敼涓哄姛鍚庡埛鏂扮晫闈� + window.location.reload(); + }); + + } else { + layer.alert(result.code + result.Message, { icon: 5 }); + } + }, error: function () { + layer.alert("鎺ュ彛璇锋眰澶辫触!", { icon: 5 }); + } + }); + }) + } + else { + layer.msg('璇烽�夋嫨涓�琛屾暟鎹垹闄わ紒'); + } + break; + //鍒锋柊 + case 'get_Refresh': get_Refresh(); + break; + //閫�鍑烘寜閽� + case 'get_Exit': Pub_Close(2); + break; + }; + }); + + + //#region 蹇�熻繃婊� + function get_FastQuery(table, option) { + var HDate = $("#HBeginDate").val();//寮�濮嬫棩鏈� + var HDate1 = $("#HEndDate").val();//缁撴潫鏃ユ湡 + var HBillNo = $("#HBillNo").val();//鍗曟嵁鍙� + var HCusID = $("#HCusID").val(); + var HDeptID = $("#HDeptID").val(); + var HMangerID = $("#HMangerID").val(); + if (HDate) { + sWhere += " and CONVERT(varchar(100),鏃ユ湡, 23) >= '" + HDate + "'"; + } + if (HDate1) { + sWhere += " and CONVERT(varchar(100),鏃ユ湡, 23) <= '" + HDate1 + "'"; + } + if (HBillNo) { + sWhere += " and 鍗曟嵁鍙� like '%" + HBillNo + "%'"; + } + if (HCusID) { + sWhere += " and 瀹㈡埛 like '%" + HCusID + "%'"; + } + if (HDeptID) { + sWhere += " and 閮ㄩ棬 like '%" + HDeptID + "%'"; + } + if (HMangerID) { + sWhere += " and 涓荤 like '%" + HMangerID + "%'"; + } + get_Display(sWhere); + sWhere = "";//璋冪敤鎺ュ彛鍚庢竻绌簊Where缂撳瓨 + } + //#endregion + //#region 閲嶇疆杩囨护鏉′欢 + function set_ClearQuery() { + $("#HDate").val("");//寮�濮嬫棩鏈� + $("#HDate1").val("");//缁撴潫鏃ユ湡 + $("#HBillNo").val("");// + $("#HCusID").val(""); + $("#HDeptID").val(""); + $("#HMangerID").val(""); sWhere = ""; - //$("#HBillType").val("");//鍗曟嵁绫诲瀷 - //$("#HBillNo").val("");//鍗曟嵁鍙� - //$("#HSourceBillNo").val("");//婧愬崟鍙� - //$("#HCreateBy").val("");//鍒跺崟浜� - //$("#BenginHCreateDate").val("");//寮�濮嬪埗鍗曟椂闂� - //$("#EndHCreateDate").val("");//缁撴潫鍒跺崟鏃堕棿 - }); + } + //#endregion - //鐩戝惉琛屽弻鍑讳簨浠� - table.on('rowDouble(mainTable)', function (obj) { - layer.alert("鍙屽嚮浜嬩欢", { icon: 1 }); - }); - - - //laydate.render({ - // elem: '#HDate' - // , type: 'datetime' - // , trigger: 'click' - // , format:'yyyy-MM-dd HH:mm' - //}); + //#region 鍒锋柊 + function get_Refresh() { + set_ClearQuery(); + get_Display(sWhere); + } + //#endregion //浠ヤ笂鏄痩ayui妯″潡 diff --git "a/WebTM/views/\351\252\214\346\224\266\345\205\245\345\272\223/\344\272\247\345\223\201\345\205\245\345\272\223/Kf_ProductInBillList.html" "b/WebTM/views/\351\252\214\346\224\266\345\205\245\345\272\223/\344\272\247\345\223\201\345\205\245\345\272\223/Kf_ProductInBillList.html" index ad14f1d..ab4401e 100644 --- "a/WebTM/views/\351\252\214\346\224\266\345\205\245\345\272\223/\344\272\247\345\223\201\345\205\245\345\272\223/Kf_ProductInBillList.html" +++ "b/WebTM/views/\351\252\214\346\224\266\345\205\245\345\272\223/\344\272\247\345\223\201\345\205\245\345\272\223/Kf_ProductInBillList.html" @@ -1,14 +1,22 @@ 锘�<!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/layui/layui.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/PubCustom.js"></script> + <script src="../../../layuiadmin/zgqCustom/zgqCustom.js"></script> + <style type="text/css"> input.layui-input.layui-unselect { padding-right: 0; @@ -28,64 +36,63 @@ <span>鏇村</span> </div> </div> - <!--<div class="layui-inline"> - <label class="layui-form-label">鍗曟嵁绫诲瀷</label> + <div class="layui-inline"> + <label class="layui-form-label">寮�濮嬫棩鏈�</label> <div class="layui-input-block"> - <select name="HBillType" id="HBillType"> - <option value="">鎵�鏈�</option> - <option value="ZHXJ">涓嬫灦鎵捐揣鍗�</option> - <option value="ZHSJ">涓婃灦褰掕繕鍗�</option> - </select> + <input type="date" class="layui-input" id="HBeginDate" style="width:190px;"> + </div> + </div> + <div class="layui-inline"> + <label class="layui-form-label">缁撴潫鏃ユ湡</label> + <div class="layui-input-block"> + <input type="date" class="layui-input" id="HEndDate" style="width:190px;"> </div> </div> <div class="layui-inline"> <label class="layui-form-label">鍗曟嵁鍙�</label> <div class="layui-input-block"> - <input type="text" class="layui-input" name="HBillNo" id="HBillNo"> + <input type="text" class="layui-input" name="HBillNo" id="HBillNo" style="width:190px;"> </div> </div> - <div class="layui-inline"> - <label class="layui-form-label">鍒跺崟浜�</label> - <div class="layui-input-block"> - <input type="text" class="layui-input" name="HCreateBy" id="HCreateBy"> - </div> - </div>--> <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnSearch" id="btnSearch"> <i class="layui-icon layui-icon-search layuiadmin-button-btn"></i> </button> - <!--<button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnReSearch" id="btnReSearch" style="padding:0 5px">閲嶇疆</button>--> - <!--<div class="layui-colla-content"> + <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnReSearch" id="btnReSearch" style="padding:0 5px">閲嶇疆</button> + <div class="layui-colla-content"> <div class="layui-inline"> <div class="layui-inline"> <span>鍏朵粬鏉′欢></span> </div> </div> <div class="layui-inline"> - <label class="layui-form-label">寮�濮嬫椂闂�</label> + <label class="layui-form-label">瀹㈡埛</label> <div class="layui-input-block"> - <input type="date" class="layui-input" name="BenginHCreateDate" id="BenginHCreateDate"> + <input type="text" class="layui-input" name="HCusID" id="HCusID" style="width:190px;"> </div> </div> <div class="layui-inline"> - <label class="layui-form-label">缁撴潫鏃堕棿</label> + <label class="layui-form-label">閮ㄩ棬</label> <div class="layui-input-block"> - <input type="date" class="layui-input" name="EndHCreateDate" id="EndHCreateDate"> + <input type="text" class="layui-input" name="HDeptID" id="HDeptID" style="width:190px;"> </div> </div> - </div>--> + <div class="layui-inline"> + <label class="layui-form-label">涓荤</label> + <div class="layui-input-block"> + <input type="text" class="layui-input" name="HMangerID" id="HMangerID" style="width:190px;"> + </div> + </div> + </div> </div> </div> <table class="" id="mainTable" lay-filter="mainTable"></table> <script type="text/html" id="toolbarDemo"> <div class="layui-btn-container"> - <!--<button type="button" class="layui-btn layui-btn-sm" lay-event="btn-getCheckData"><i class="layui-icon layui-icon-tips"></i>棰勮</button>--> - <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-reload"><i class="layui-icon layui-icon-refresh"></i>鍒锋柊</button> - <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-confirm" id="btn_confirm"><i class="layui-icon layui-icon-ok-circle"></i>纭</button> - <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-back" id="btn_back"><i class="layui-icon layui-icon-close-fill"></i>椹冲洖</button> - <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-details"><i class="layui-icon layui-icon-form"></i>璇︽儏</button> - <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-generate"><i class="layui-icon layui-icon-file"></i>鐢熸垚閫佽揣鍗�</button> - <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-exit"><i class="layui-icon layui-icon-return"></i>閫�鍑�</button> - + <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-Add"><i class="layui-icon layui-icon-file-b"></i>鏂板</button> + <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-Edit"><i class="layui-icon layui-icon-form"></i>缂栬緫</button> + <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-Delete"><i class="layui-icon layui-icon-delete"></i>鍒犻櫎</button> + <button type="button" class="layui-btn layui-btn-sm" lay-event="get_Refresh"><i class="layui-icon layui-icon-refresh-3"></i>鍒锋柊</button> + <button type="button" class="layui-btn layui-btn-sm" lay-event="get_Exit"><i class="layui-icon layui-icon-logout"></i>閫�鍑�</button> </div> </script> </form> @@ -93,10 +100,10 @@ </div> </div> </div> - <script src="../../../layuiadmin/layui/layui.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/Scripts/webConfig.js"></script>--> <script> layui.config({ base: '../../../layuiadmin/' //闈欐�佽祫婧愭墍鍦ㄨ矾寰� @@ -114,155 +121,260 @@ , util = layui.util //鏌ヨ鏉′欢 var sWhere = ""; + var option = []; - var option = { - elem: '#mainTable' - //, toolbar: '#toolbarDemo' - , height: 'full-50' - , page: true - , cellMinWidth: 90 - , cols: [[ - { field: 'hmainid', title: '鍗曟嵁ID', hide: true } - , { field: '鏃ユ湡', title: '鏃ユ湡', width: 160 } - , { field: '鍗曟嵁鍙�', title: '鍗曟嵁鍙�', width: 160 } - , { field: '绾㈣摑鍗曟爣璁�', title: '绾㈣摑鍗曟爣璁�', width: 160 } - , { field: 'HCusID', title: 'HCusID', width: 160, hide: true } - , { field: '瀹㈡埛', title: '瀹㈡埛', width: 200 } - , { field: 'hsecmanagerid', title: 'hsecmanagerid', width: 200, hide: true } - , { field: '楠屾敹鍛�', title: '楠屾敹鍛�', width: 200 } - , { field: 'hkeeperid', title: 'hkeeperid', width: 200, hide: true } - , { field: '淇濈鍛�', title: '淇濈鍛�', width: 200 } - , { field: 'HDeptID', title: 'HDeptID', width: 200, hide: true } - , { field: '閮ㄩ棬', title: '閮ㄩ棬', width: 160 } - , { field: '浠撳簱', title: '浠撳簱', width: 160} - , { field: 'hsubid', title: 'hsubid', width: 160, hide: true } - , { field: 'hmaterid', title: 'hmaterid', width: 200, hide: true } - , { field: '鐗╂枡浠g爜', title: '鐗╂枡浠g爜', width: 200 } - , { field: '鐗╂枡鍚嶇О', title: '鐗╂枡鍚嶇О', width: 200 } - , { field: '瑙勬牸鍨嬪彿', title: '瑙勬牸鍨嬪彿', width: 200 } - , { field: '鎵规', title: '鎵规', width: 200 } - , { field: 'hunitid', title: 'hunitid', width: 200, hide: true } - , { field: '璁¢噺鍗曚綅', title: '璁¢噺鍗曚綅', width: 200 } - , { field: '搴旀敹鏁伴噺', title: '搴旀敹鏁伴噺', width: 115 } - , { field: '瀹炴敹鏁伴噺', title: '瀹炴敹鏁伴噺', width: 115 } - , { field: '鍑哄簱鏁伴噺', title: '鍑哄簱鏁伴噺', width: 200 } - , { field: '鍗曚环', title: '鍗曚环', width: 200 } - , { field: '閲戦', title: '閲戦', width: 115 } - , { field: 'hwhid', title: 'hwhid', width: 200, hide: true } - , { field: '鏀舵枡浠撳簱浠g爜', title: '鏀舵枡浠撳簱浠g爜', width: 200 } - , { field: '鏀舵枡浠撳簱', title: '鏀舵枡浠撳簱', width: 200 } - , { field: '琛ㄤ綋澶囨敞', title: '琛ㄤ綋澶囨敞', width: 200 } - , { field: '婧愬崟鍗曞彿', title: '婧愬崟鍗曞彿', width: 115 } - , { field: '閲囪喘璁㈠崟鍙�', title: '閲囪喘璁㈠崟鍙�', width: 200 } - , { field: '閿�鍞鍗曞彿', title: '閿�鍞鍗曞彿', width: 200 } - , { field: '鍒跺崟浜�', title: '鍒跺崟浜�', width: 200 } - , { field: '鍒跺崟鏃ユ湡', title: '鍒跺崟鏃ユ湡', width: 200 } - , { field: '瀹℃牳浜�', title: '瀹℃牳浜�', width: 200 } - , { field: '瀹℃牳鏃ユ湡', title: '瀹℃牳鏃ユ湡', width: 115 } - , { field: '淇敼浜�', title: '淇敼浜�', width: 200 } - , { field: '淇敼鏃ユ湡', title: '淇敼鏃ユ湡', width: 200 } - , { field: '鍏抽棴浜�', title: '鍏抽棴浜�', width: 200 } - , { field: '鍏抽棴鏃ユ湡', title: '鍏抽棴鏃ユ湡', width: 200 } - , { field: '浣滃簾浜�', title: '浣滃簾浜�', width: 200 } - , { field: '浣滃簾鏃ユ湡', title: '浣滃簾鏃ユ湡', width: 200 } - ]] - }; + //鍒濆鍖栫晫闈� + set_ClearBill(); - var index = layer.load(0); - //杩涘叆椤甸潰鏄剧ず鐨勭紦瀛樺垪琛� - $.ajax({ - //url: "http://61.130.49.162:9090/WMSAPI///Web/GetMAXNum", - url: GetWEBURL() + '/Kf_ProductInBill/GetProductInBill', - type: "GET", - data: { "sWhere": sWhere}, - success: function (data1) { - if (data1.count == 1) { - option.data = data1.data; - table.render(option); - layer.close(index); - } else { - layer.close(index); - layer.alert(data1.code + data1.Message, { icon: 5 }); - } - }, error: function () { - layer.close(index); - layer.alert("鎺ュ彛璇锋眰澶辫触!", { icon: 5 }); - } + //#endregion + + //#region 閲嶇疆鎸夐挳 + form.on('submit(btnReSearch)', function (data) { + //娓呯┖杩囨护鏉′欢 + set_ClearQuery(); }); + //#endregion - //閲嶇疆鎸夐挳 - //form.on('submit(btnReSearch)', function (data) { - // $("#HBillType").val("");//鍗曟嵁绫诲瀷 - // $("#HBillNo").val("");//鍗曟嵁鍙� - // $("#HSourceBillNo").val("");//婧愬崟鍙� - // $("#HCreateBy").val("");//鍒跺崟浜� - // $("#BenginHCreateDate").val("");//寮�濮嬪埗鍗曟椂闂� - // $("#EndHCreateDate").val("");//缁撴潫鍒跺崟鏃堕棿 - // $("#btnSearch").click(); - //}); + //#region 鏌ヨ鎸夐挳 + form.on('submit(btnSearch)', function (data) { + get_FastQuery(table, option); + }); + //#endregion - //鏌ヨ鎸夐挳 - form.on('submit(btnSearch)', function (data) {//閫夋嫨浠撲綅 - //var HBillType = $("#HBillType").val();//鍗曟嵁绫诲瀷 - //var HBillNo = $("#HBillNo").val();//鍗曟嵁鍙� - //var HCreateBy = $("#HCreateBy").val();//鍒跺崟浜� - //var BenginHCreateDate = $("#BenginHCreateDate").val();//寮�濮嬪埗鍗曟椂闂� - //var EndHCreateDate = $("#EndHCreateDate").val();//缁撴潫鍒跺崟鏃堕棿 - //if (HBillNo) { - // sWhere += " and HBillNo like '%" + HBillNo + "%'"; - //} - //if (HCreateBy) { - // sWhere += " and HCreateBy like '%" + HCreateBy + "%'"; - //} - //if (BenginHCreateDate) { - // sWhere += " and CONVERT(varchar(100),HCreateDate, 23) >= '" + BenginHCreateDate + "'"; - //} - //if (EndHCreateDate) { - // sWhere += " and CONVERT(varchar(100),HCreateDate, 23) <= '" + EndHCreateDate + "'"; - //} - var index = layer.load(0); + //#region 鍒濆鍖栫晫闈� + function set_ClearBill() { + //鍒濆鍖栬〃鏍� + set_InitGrid(); + //鏌ヨ + get_Display(sWhere); + } + //#endregion + //#region 鍒濆鍖栬〃鏍兼柟娉� + $("#HBeginDate").val(Format(new Date(new Date() - 1000 * 60 * 60 * 24 * 30), "yyyy-MM-dd")); + $("#HEndDate").val(Format(new Date(), "yyyy-MM-dd")); + function set_InitGrid() { + option = { + elem: '#mainTable' + , toolbar: '#toolbarDemo' + , height: 'full-50' + , page: true + , cellMinWidth: 90 + , cols: [[ + { type: 'checkbox', fixed: 'left' } + ,{ field: 'hmainid', title: 'hmainid', sort: true, hide: true } + ,{ field: '鍗曟嵁鍙�', title: '鍗曟嵁鍙�', hide: true } + , { field: '鏃ユ湡', title: '鏃ユ湡', width: 160 } + , { field: '鍗曟嵁鍙�', title: '鍗曟嵁鍙�', width: 160 } + , { field: '绾㈣摑鍗曟爣璁�', title: '绾㈣摑鍗曟爣璁�', width: 160 } + , { field: 'HCusID', title: 'HCusID', width: 160, hide: true } + , { field: '瀹㈡埛', title: '瀹㈡埛', width: 200 } + , { field: 'hsecmanagerid', title: 'hsecmanagerid', width: 200, hide: true } + , { field: '楠屾敹鍛�', title: '楠屾敹鍛�', width: 200 } + , { field: 'hkeeperid', title: 'hkeeperid', width: 200, hide: true } + , { field: '淇濈鍛�', title: '淇濈鍛�', width: 200 } + , { field: 'HDeptID', title: 'HDeptID', width: 200, hide: true } + , { field: '閮ㄩ棬', title: '閮ㄩ棬', width: 160 } + , { field: '浠撳簱', title: '浠撳簱', width: 160 } + , { field: 'hsubid', title: 'hsubid', width: 160, hide: true } + , { field: 'hmaterid', title: 'hmaterid', width: 200, hide: true } + , { field: '鐗╂枡浠g爜', title: '鐗╂枡浠g爜', width: 200 } + , { field: '鐗╂枡鍚嶇О', title: '鐗╂枡鍚嶇О', width: 200 } + , { field: '瑙勬牸鍨嬪彿', title: '瑙勬牸鍨嬪彿', width: 200 } + , { field: '鎵规', title: '鎵规', width: 200 } + , { field: 'hunitid', title: 'hunitid', width: 200, hide: true } + , { field: '璁¢噺鍗曚綅', title: '璁¢噺鍗曚綅', width: 200 } + , { field: '搴旀敹鏁伴噺', title: '搴旀敹鏁伴噺', width: 115 } + , { field: '瀹炴敹鏁伴噺', title: '瀹炴敹鏁伴噺', width: 115 } + , { field: '鍑哄簱鏁伴噺', title: '鍑哄簱鏁伴噺', width: 200 } + , { field: '鍗曚环', title: '鍗曚环', width: 200 } + , { field: '閲戦', title: '閲戦', width: 115 } + , { field: 'hwhid', title: 'hwhid', width: 200, hide: true } + , { field: '鏀舵枡浠撳簱浠g爜', title: '鏀舵枡浠撳簱浠g爜', width: 200 } + , { field: '鏀舵枡浠撳簱', title: '鏀舵枡浠撳簱', width: 200 } + , { field: '琛ㄤ綋澶囨敞', title: '琛ㄤ綋澶囨敞', width: 200 } + , { field: '鍒跺崟浜�', title: '鍒跺崟浜�', width: 125 } + , { field: '鍒跺崟鏃ユ湡', title: '鍒跺崟鏃ユ湡', width: 200, templet: "<div>{{d.鍒跺崟鏃ユ湡 ==null ?'':layui.util.toDateString(d.鍒跺崟鏃ユ湡, 'yyyy-MM-dd HH:mm:ss')}}</div>" } + , { field: '瀹℃牳浜�', title: '瀹℃牳浜�', width: 125 } + , { field: '瀹℃牳鏃ユ湡', title: '瀹℃牳鏃ユ湡', width: 200, templet: "<div>{{d.瀹℃牳鏃ユ湡 ==null ? '':layui.util.toDateString(d.瀹℃牳鏃ユ湡, 'yyyy-MM-dd HH:mm:ss')}}</div>" } + , { field: '淇敼浜�', title: '淇敼浜�', width: 125 } + , { field: '淇敼鏃ユ湡', title: '淇敼鏃ユ湡', width: 200, templet: "<div>{{d.淇敼鏃ユ湡 ==null ?'':layui.util.toDateString(d.淇敼鏃ユ湡, 'yyyy-MM-dd HH:mm:ss')}}</div>" } + , { field: '鍏抽棴浜�', title: '鍏抽棴浜�', width: 125 } + , { field: '鍏抽棴鏃ユ湡', title: '鍏抽棴鏃ユ湡', width: 200, templet: "<div>{{d.鍏抽棴鏃ユ湡 ==null ?'':layui.util.toDateString(d.鍏抽棴鏃ユ湡, 'yyyy-MM-dd HH:mm:ss')}}</div>" } + , { field: '浣滃簾浜�', title: '浣滃簾浜�', width: 125 } + , { field: '浣滃簾鏃ユ湡', title: '浣滃簾鏃ユ湡', width: 200, templet: "<div>{{d.浣滃簾鏃ユ湡 ==null ?'':layui.util.toDateString(d.浣滃簾鏃ユ湡, 'yyyy-MM-dd HH:mm:ss')}}</div>" } + + ]] + }; + } + //杩涘叆椤甸潰鏄剧ず鐨勭紦瀛樺垪琛� + function get_Display(sWhere) { + var ajaxLoad = layer.load(); $.ajax({ - //url: "http://61.130.49.162:9090/WMSAPI///Web/GetMAXNum", - url: GetWEBURL1() + '/Kf_ProductInBill/GetProductInBill', + url: GetWEBURL() + '/Kf_ProductInBill/GetProductInBill', type: "GET", - data: { "sWhere": sWhere}, + data: { "sWhere": sWhere }, success: function (data1) { if (data1.count == 1) { option.data = data1.data; table.render(option); - layer.close(index); - layer.alert("鏌ヨ鎴愬姛", { icon: 1 }); + layer.close(ajaxLoad); } else { - layer.close(index); + layer.close(ajaxLoad); layer.alert(data1.code + data1.Message, { icon: 5 }); } }, error: function () { - layer.close(index); - layer.alert("鎺ュ彛澶辨晥!", { icon: 5 }); + layer.close(ajaxLoad); + layer.alert("鎺ュ彛璇锋眰澶辫触!", { icon: 5 }); } }); - //璋冪敤鎺ュ彛鍚庢竻绌簊Where缂撳瓨 + } + //澶村伐鍏锋爮浜嬩欢 + table.on('toolbar(mainTable)', function (obj) { + var checkStatus = table.checkStatus(obj.config.id); + switch (obj.event) { + case 'btn-Add': + //椤甸潰灞�-鑷畾涔� + layer.open({ + type: 2, + skin: 'layui-layer-rim', //鍔犱笂杈规 + title: '鏂板閫�璐ч�氱煡鍗�', + closeBtn: 1, + shift: 2, + area: ['100%', '100%'], + maxmin: true, + content: '../../閲囪喘绠$悊/鏀舵枡閫氱煡鍗�/Add_Edit_Cg_POInStockBillList.html?OperationType=1&linterid=0&HSouceBillType=0&closeType=1', + end: function () { + //鍒锋柊椤甸潰, + location.reload(); + }, + success: function (layero, index) { + + } + }); + break; + case 'btn-Edit': + var checkStatus = table.checkStatus('mainTable') + , data = checkStatus.data; + if (checkStatus.data.length === 1) { + var hID = data[0].hmainid.toString(); + //if (AllowLoadData(sSubStr) != false) {//闈炵┖楠岃瘉 + layer.open({ + type: 2 + , area: ['100%', '100%'] + , title: '缂栬緫閫�璐ч�氱煡鍗�' + , closeBtn: 1 + , shade: 0.6 //閬僵閫忔槑搴� + , maxmin: true //鍏佽鍏ㄥ睆鏈�灏忓寲 + , anim: 0 //0-6鐨勫姩鐢诲舰寮忥紝-1涓嶅紑鍚� + , content: '../../閲囪喘绠$悊/鏀舵枡閫氱煡鍗�/Add_Edit_Cg_POInStockBillList.html?OperationType=3&linterid=' + hID + '&HSouceBillType=0&closeType=1' + , resize: false, + end: function () { + //鍒锋柊椤甸潰, + location.reload(); + } + , cancel: function () { + //$(".layui-btn").removeClass("layui-btn-disabled"); + } + }) + + } else { + layer.msg('璇烽�夋嫨涓�琛屾暟鎹紪杈戯紒'); + } + + break; + case 'btn-Delete': + var checkStatus = table.checkStatus('mainTable') + , data = checkStatus.data; + if (checkStatus.data.length === 1) { + var InterID = data[0].hmainid.toString(); + //閫昏緫鍒犻櫎鏂规硶 + layer.confirm("纭瑕佸垹闄ゅ悧锛屽垹闄ゅ悗涓嶈兘鎭㈠", { title: "鍒犻櫎纭" }, function (index) { + $.ajax({ + type: "GET", + url: GetWEBURL() + "Kf_SellOutBill/DeltetSellOutBill", //鏂规硶鎵�鍦ㄩ〉闈㈠拰鏂规硶鍚� + data: { "HInterID": InterID }, + success: function (result) { + if (result.count == 1) { + layer.msg(result.Message, { time: 1 * 1000, icon: 1 }, function () { + // 寰楀埌frame绱㈠紩 + var index = layer.getFrameIndex(window.name); + //鍏抽棴褰撳墠frame + layer.close(index); + //淇敼涓哄姛鍚庡埛鏂扮晫闈� + window.location.reload(); + }); + + } else { + layer.alert(result.code + result.Message, { icon: 5 }); + } + }, error: function () { + layer.alert("鎺ュ彛璇锋眰澶辫触!", { icon: 5 }); + } + }); + }) + } + else { + layer.msg('璇烽�夋嫨涓�琛屾暟鎹垹闄わ紒'); + } + break; + //鍒锋柊 + case 'get_Refresh': get_Refresh(); + break; + //閫�鍑烘寜閽� + case 'get_Exit': Pub_Close(2); + break; + }; + }); + + + //#region 蹇�熻繃婊� + function get_FastQuery(table, option) { + var HDate = $("#HBeginDate").val();//寮�濮嬫棩鏈� + var HDate1 = $("#HEndDate").val();//缁撴潫鏃ユ湡 + var HBillNo = $("#HBillNo").val();//鍗曟嵁鍙� + var HCusID = $("#HCusID").val(); + var HDeptID = $("#HDeptID").val(); + var HMangerID = $("#HMangerID").val(); + if (HDate) { + sWhere += " and CONVERT(varchar(100),鏃ユ湡, 23) >= '" + HDate + "'"; + } + if (HDate1) { + sWhere += " and CONVERT(varchar(100),鏃ユ湡, 23) <= '" + HDate1 + "'"; + } + if (HBillNo) { + sWhere += " and 鍗曟嵁鍙� like '%" + HBillNo + "%'"; + } + if (HCusID) { + sWhere += " and 瀹㈡埛 like '%" + HCusID + "%'"; + } + if (HDeptID) { + sWhere += " and 閮ㄩ棬 like '%" + HDeptID + "%'"; + } + if (HMangerID) { + sWhere += " and 涓荤 like '%" + HMangerID + "%'"; + } + get_Display(sWhere); + sWhere = "";//璋冪敤鎺ュ彛鍚庢竻绌簊Where缂撳瓨 + } + //#endregion + //#region 閲嶇疆杩囨护鏉′欢 + function set_ClearQuery() { + $("#HDate").val("");//寮�濮嬫棩鏈� + $("#HDate1").val("");//缁撴潫鏃ユ湡 + $("#HBillNo").val("");// + $("#HCusID").val(""); + $("#HDeptID").val(""); + $("#HMangerID").val(""); sWhere = ""; - //$("#HBillType").val("");//鍗曟嵁绫诲瀷 - //$("#HBillNo").val("");//鍗曟嵁鍙� - //$("#HSourceBillNo").val("");//婧愬崟鍙� - //$("#HCreateBy").val("");//鍒跺崟浜� - //$("#BenginHCreateDate").val("");//寮�濮嬪埗鍗曟椂闂� - //$("#EndHCreateDate").val("");//缁撴潫鍒跺崟鏃堕棿 - }); + } + //#endregion - //鐩戝惉琛屽弻鍑讳簨浠� - table.on('rowDouble(mainTable)', function (obj) { - layer.alert("鍙屽嚮浜嬩欢", { icon: 1 }); - }); - - - //laydate.render({ - // elem: '#HDate' - // , type: 'datetime' - // , trigger: 'click' - // , format:'yyyy-MM-dd HH:mm' - //}); + //#region 鍒锋柊 + function get_Refresh() { + set_ClearQuery(); + get_Display(sWhere); + } + //#endregion //浠ヤ笂鏄痩ayui妯″潡 diff --git "a/WebTM/views/\351\252\214\346\224\266\345\205\245\345\272\223/\345\205\266\344\273\226\345\205\245\345\272\223/Kf_OtherInBillList.html" "b/WebTM/views/\351\252\214\346\224\266\345\205\245\345\272\223/\345\205\266\344\273\226\345\205\245\345\272\223/Kf_OtherInBillList.html" index 50e1784..ad50ea4 100644 --- "a/WebTM/views/\351\252\214\346\224\266\345\205\245\345\272\223/\345\205\266\344\273\226\345\205\245\345\272\223/Kf_OtherInBillList.html" +++ "b/WebTM/views/\351\252\214\346\224\266\345\205\245\345\272\223/\345\205\266\344\273\226\345\205\245\345\272\223/Kf_OtherInBillList.html" @@ -1,14 +1,22 @@ 锘�<!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/layui/layui.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/PubCustom.js"></script> + <script src="../../../layuiadmin/zgqCustom/zgqCustom.js"></script> + <style type="text/css"> input.layui-input.layui-unselect { padding-right: 0; @@ -28,64 +36,63 @@ <span>鏇村</span> </div> </div> - <!--<div class="layui-inline"> - <label class="layui-form-label">鍗曟嵁绫诲瀷</label> + <div class="layui-inline"> + <label class="layui-form-label">寮�濮嬫棩鏈�</label> <div class="layui-input-block"> - <select name="HBillType" id="HBillType"> - <option value="">鎵�鏈�</option> - <option value="ZHXJ">涓嬫灦鎵捐揣鍗�</option> - <option value="ZHSJ">涓婃灦褰掕繕鍗�</option> - </select> + <input type="date" class="layui-input" id="HBeginDate" style="width:190px;"> + </div> + </div> + <div class="layui-inline"> + <label class="layui-form-label">缁撴潫鏃ユ湡</label> + <div class="layui-input-block"> + <input type="date" class="layui-input" id="HEndDate" style="width:190px;"> </div> </div> <div class="layui-inline"> <label class="layui-form-label">鍗曟嵁鍙�</label> <div class="layui-input-block"> - <input type="text" class="layui-input" name="HBillNo" id="HBillNo"> + <input type="text" class="layui-input" name="HBillNo" id="HBillNo" style="width:190px;"> </div> </div> - <div class="layui-inline"> - <label class="layui-form-label">鍒跺崟浜�</label> - <div class="layui-input-block"> - <input type="text" class="layui-input" name="HCreateBy" id="HCreateBy"> - </div> - </div>--> <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnSearch" id="btnSearch"> <i class="layui-icon layui-icon-search layuiadmin-button-btn"></i> </button> - <!--<button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnReSearch" id="btnReSearch" style="padding:0 5px">閲嶇疆</button>--> - <!--<div class="layui-colla-content"> + <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnReSearch" id="btnReSearch" style="padding:0 5px">閲嶇疆</button> + <div class="layui-colla-content"> <div class="layui-inline"> <div class="layui-inline"> <span>鍏朵粬鏉′欢></span> </div> </div> <div class="layui-inline"> - <label class="layui-form-label">寮�濮嬫椂闂�</label> + <label class="layui-form-label">瀹㈡埛</label> <div class="layui-input-block"> - <input type="date" class="layui-input" name="BenginHCreateDate" id="BenginHCreateDate"> + <input type="text" class="layui-input" name="HCusID" id="HCusID" style="width:190px;"> </div> </div> <div class="layui-inline"> - <label class="layui-form-label">缁撴潫鏃堕棿</label> + <label class="layui-form-label">閮ㄩ棬</label> <div class="layui-input-block"> - <input type="date" class="layui-input" name="EndHCreateDate" id="EndHCreateDate"> + <input type="text" class="layui-input" name="HDeptID" id="HDeptID" style="width:190px;"> </div> </div> - </div>--> + <div class="layui-inline"> + <label class="layui-form-label">涓荤</label> + <div class="layui-input-block"> + <input type="text" class="layui-input" name="HMangerID" id="HMangerID" style="width:190px;"> + </div> + </div> + </div> </div> </div> <table class="" id="mainTable" lay-filter="mainTable"></table> <script type="text/html" id="toolbarDemo"> <div class="layui-btn-container"> - <!--<button type="button" class="layui-btn layui-btn-sm" lay-event="btn-getCheckData"><i class="layui-icon layui-icon-tips"></i>棰勮</button>--> - <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-reload"><i class="layui-icon layui-icon-refresh"></i>鍒锋柊</button> - <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-confirm" id="btn_confirm"><i class="layui-icon layui-icon-ok-circle"></i>纭</button> - <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-back" id="btn_back"><i class="layui-icon layui-icon-close-fill"></i>椹冲洖</button> - <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-details"><i class="layui-icon layui-icon-form"></i>璇︽儏</button> - <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-generate"><i class="layui-icon layui-icon-file"></i>鐢熸垚閫佽揣鍗�</button> - <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-exit"><i class="layui-icon layui-icon-return"></i>閫�鍑�</button> - + <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-Add"><i class="layui-icon layui-icon-file-b"></i>鏂板</button> + <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-Edit"><i class="layui-icon layui-icon-form"></i>缂栬緫</button> + <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-Delete"><i class="layui-icon layui-icon-delete"></i>鍒犻櫎</button> + <button type="button" class="layui-btn layui-btn-sm" lay-event="get_Refresh"><i class="layui-icon layui-icon-refresh-3"></i>鍒锋柊</button> + <button type="button" class="layui-btn layui-btn-sm" lay-event="get_Exit"><i class="layui-icon layui-icon-logout"></i>閫�鍑�</button> </div> </script> </form> @@ -93,10 +100,10 @@ </div> </div> </div> - <script src="../../../layuiadmin/layui/layui.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/Scripts/webConfig.js"></script>--> <script> layui.config({ base: '../../../layuiadmin/' //闈欐�佽祫婧愭墍鍦ㄨ矾寰� @@ -114,174 +121,260 @@ , util = layui.util //鏌ヨ鏉′欢 var sWhere = ""; + var option = []; - var option = { - elem: '#mainTable' - //, toolbar: '#toolbarDemo' - , height: 'full-50' - , page: true - , cellMinWidth: 90 - , cols: [[ - { field: 'hmainid', title: '鍗曟嵁ID', hide: true } - , { field: '鏃ユ湡', title: '鏃ユ湡', width: 160 } - , { field: '鍗曟嵁鍙�', title: '鍗曟嵁鍙�', width: 160 } - , { field: 'hmanagerid', title: 'hmanagerid', width: 160, hide: true } - , { field: '涓荤浠g爜', title: '涓荤浠g爜', width: 200 } - , { field: '涓荤', title: '涓荤', width: 200 } - , { field: 'hsecmanagerid', title: 'hsecmanagerid', width: 200, hide: true } - , { field: '楠屾敹鍛樹唬鐮�', title: '楠屾敹鍛樹唬鐮�', width: 200 } - , { field: '楠屾敹鍛�', title: '楠屾敹鍛�', width: 200 } - , { field: 'hkeeperid', title: 'hkeeperid', width: 200, hide: true } - , { field: '淇濈鍛樹唬鐮�', title: '淇濈鍛樹唬鐮�', width: 160 } - , { field: '淇濈鍛�', title: '淇濈鍛�', width: 160} - , { field: 'HDeptID', title: 'HDeptID', width: 160, hide: true } - , { field: '閮ㄩ棬浠g爜', title: '閮ㄩ棬浠g爜', width: 200 } - , { field: '閮ㄩ棬', title: '閮ㄩ棬', width: 200 } - , { field: '浠撳簱', title: '浠撳簱', width: 200 } - , { field: '鎽樿', title: '鎽樿', width: 200 } - , { field: '琛ㄥご澶囨敞', title: '琛ㄥご澶囨敞', width: 200 } - , { field: '鍐呴儴鍗曟嵁鍙�', title: '鍐呴儴鍗曟嵁鍙�', width: 200 } - , { field: '绾㈣摑鍗曟爣璁�', title: '绾㈣摑鍗曟爣璁�', width: 200 } - , { field: '鍒跺崟浜�', title: '鍒跺崟浜�', width: 115 } - , { field: '鍒跺崟鏃ユ湡', title: '鍒跺崟鏃ユ湡', width: 115 } - , { field: '瀹℃牳浜�', title: '瀹℃牳浜�', width: 200 } - , { field: '瀹℃牳鏃ユ湡', title: '瀹℃牳鏃ユ湡', width: 200 } - , { field: '淇敼浜�', title: '淇敼浜�', width: 115 } - , { field: '淇敼鏃ユ湡', title: '淇敼鏃ユ湡', width: 200 } - , { field: '鍏抽棴浜�', title: '鍏抽棴浜�', width: 200 } - , { field: '鍏抽棴鏃ユ湡', title: '鍏抽棴鏃ユ湡', width: 200 } - , { field: '浣滃簾浜�', title: '浣滃簾浜�', width: 200 } - , { field: '浣滃簾鏃ユ湡', title: '浣滃簾鏃ユ湡', width: 115 } - , { field: 'hsubid', title: 'hsubid', width: 200, hide: true } - , { field: 'hmaterid', title: 'hmaterid', width: 200, hide: true } - , { field: '鐗╂枡浠g爜', title: '鐗╂枡浠g爜', width: 200 } - , { field: '鐗╂枡鍚嶇О', title: '鐗╂枡鍚嶇О', width: 115 } - , { field: '瑙勬牸鍨嬪彿', title: '瑙勬牸鍨嬪彿', width: 200 } - , { field: '闄勫姞灞炴��', title: '闄勫姞灞炴��', width: 200 } - , { field: '棰滆壊', title: '棰滆壊', width: 200 } - , { field: 'hunitid', title: 'hunitid', width: 200, hide: true } - , { field: '璁¢噺鍗曚綅浠g爜', title: '璁¢噺鍗曚綅浠g爜', width: 200 } - , { field: '璁¢噺鍗曚綅', title: '璁¢噺鍗曚綅', width: 200 } - , { field: '搴旀敹鏁伴噺', title: '搴旀敹鏁伴噺', width: 200 } - , { field: '瀹炴敹鏁伴噺', title: '瀹炴敹鏁伴噺', width: 200 } - , { field: '鍗曚环', title: '鍗曚环', width: 200 } - , { field: '閲戦', title: '閲戦', width: 200 } - , { field: 'hwhid', title: 'hwhid', width: 200, hide: true } - , { field: '鏀舵枡浠撳簱浠g爜', title: '鏀舵枡浠撳簱浠g爜', width: 200 } - , { field: '鏀舵枡浠撳簱', title: '鏀舵枡浠撳簱', width: 200 } - , { field: '琛屽叧闂汉', title: '琛屽叧闂汉', width: 200 } - , { field: '鍏抽棴绫诲瀷', title: '鍏抽棴绫诲瀷', width: 200 } - , { field: '琛ㄤ綋澶囨敞', title: '琛ㄤ綋澶囨敞', width: 200 } - , { field: '婧愬崟涓诲唴鐮�', title: '婧愬崟涓诲唴鐮�', width: 200, hide: true } - , { field: '婧愬崟瀛愬唴鐮�', title: '婧愬崟瀛愬唴鐮�', width: 200 } - , { field: '婧愬崟鍗曞彿', title: '婧愬崟鍗曞彿', width: 200 } - , { field: '婧愬崟绫诲瀷', title: '婧愬崟绫诲瀷', width: 200 } - , { field: '閲囪喘璁㈠崟涓籌D', title: '閲囪喘璁㈠崟涓籌D', width: 200, hide: true } - , { field: '閲囪喘璁㈠崟瀛怚D', title: '閲囪喘璁㈠崟瀛怚D', width: 200, hide: true } - , { field: '閲囪喘璁㈠崟鍙�', title: '閲囪喘璁㈠崟鍙�', width: 200 } - , { field: '閿�鍞鍗曚富ID', title: '閿�鍞鍗曚富ID', width: 200, hide: true } - , { field: '閿�鍞鍗曞瓙ID', title: '閿�鍞鍗曞瓙ID', width: 200, hide: true } - , { field: '閿�鍞鍗曞彿', title: '閿�鍞鍗曞彿', width: 200 } - , { field: '鍏宠仈鏁伴噺', title: '鍏宠仈鏁伴噺', width: 200 } - , { field: 'HBillType', title: 'HBillType', width: 200, hide: true } - ]] - }; + //鍒濆鍖栫晫闈� + set_ClearBill(); - var index = layer.load(0); - //杩涘叆椤甸潰鏄剧ず鐨勭紦瀛樺垪琛� - $.ajax({ - //url: "http://61.130.49.162:9090/WMSAPI///Web/GetMAXNum", - url: GetWEBURL() + '/Kf_OtherInBill/GetOtherInBill', - type: "GET", - data: { "sWhere": sWhere}, - success: function (data1) { - if (data1.count == 1) { - option.data = data1.data; - table.render(option); - layer.close(index); - } else { - layer.close(index); - layer.alert(data1.code + data1.Message, { icon: 5 }); - } - }, error: function () { - layer.close(index); - layer.alert("鎺ュ彛璇锋眰澶辫触!", { icon: 5 }); - } + //#endregion + + //#region 閲嶇疆鎸夐挳 + form.on('submit(btnReSearch)', function (data) { + //娓呯┖杩囨护鏉′欢 + set_ClearQuery(); }); + //#endregion - //閲嶇疆鎸夐挳 - //form.on('submit(btnReSearch)', function (data) { - // $("#HBillType").val("");//鍗曟嵁绫诲瀷 - // $("#HBillNo").val("");//鍗曟嵁鍙� - // $("#HSourceBillNo").val("");//婧愬崟鍙� - // $("#HCreateBy").val("");//鍒跺崟浜� - // $("#BenginHCreateDate").val("");//寮�濮嬪埗鍗曟椂闂� - // $("#EndHCreateDate").val("");//缁撴潫鍒跺崟鏃堕棿 - // $("#btnSearch").click(); - //}); + //#region 鏌ヨ鎸夐挳 + form.on('submit(btnSearch)', function (data) { + get_FastQuery(table, option); + }); + //#endregion - //鏌ヨ鎸夐挳 - form.on('submit(btnSearch)', function (data) {//閫夋嫨浠撲綅 - //var HBillType = $("#HBillType").val();//鍗曟嵁绫诲瀷 - //var HBillNo = $("#HBillNo").val();//鍗曟嵁鍙� - //var HCreateBy = $("#HCreateBy").val();//鍒跺崟浜� - //var BenginHCreateDate = $("#BenginHCreateDate").val();//寮�濮嬪埗鍗曟椂闂� - //var EndHCreateDate = $("#EndHCreateDate").val();//缁撴潫鍒跺崟鏃堕棿 - //if (HBillNo) { - // sWhere += " and HBillNo like '%" + HBillNo + "%'"; - //} - //if (HCreateBy) { - // sWhere += " and HCreateBy like '%" + HCreateBy + "%'"; - //} - //if (BenginHCreateDate) { - // sWhere += " and CONVERT(varchar(100),HCreateDate, 23) >= '" + BenginHCreateDate + "'"; - //} - //if (EndHCreateDate) { - // sWhere += " and CONVERT(varchar(100),HCreateDate, 23) <= '" + EndHCreateDate + "'"; - //} - var index = layer.load(0); + //#region 鍒濆鍖栫晫闈� + function set_ClearBill() { + //鍒濆鍖栬〃鏍� + set_InitGrid(); + //鏌ヨ + get_Display(sWhere); + } + //#endregion + //#region 鍒濆鍖栬〃鏍兼柟娉� + $("#HBeginDate").val(Format(new Date(new Date() - 1000 * 60 * 60 * 24 * 30), "yyyy-MM-dd")); + $("#HEndDate").val(Format(new Date(), "yyyy-MM-dd")); + function set_InitGrid() { + option = { + elem: '#mainTable' + , toolbar: '#toolbarDemo' + , height: 'full-50' + , page: true + , cellMinWidth: 90 + , cols: [[ + { type: 'checkbox', fixed: 'left' } + ,{ field: 'hmainid', title: 'hmainid', sort: true, hide: true } + ,{ field: '鍗曟嵁鍙�', title: '鍗曟嵁鍙�', hide: true } + , { field: '鏃ユ湡', title: '鏃ユ湡', width: 160 } + , { field: '鍗曟嵁鍙�', title: '鍗曟嵁鍙�', width: 160 } + , { field: '绾㈣摑鍗曟爣璁�', title: '绾㈣摑鍗曟爣璁�', width: 160 } + , { field: 'HCusID', title: 'HCusID', width: 160, hide: true } + , { field: '瀹㈡埛', title: '瀹㈡埛', width: 200 } + , { field: 'hsecmanagerid', title: 'hsecmanagerid', width: 200, hide: true } + , { field: '楠屾敹鍛�', title: '楠屾敹鍛�', width: 200 } + , { field: 'hkeeperid', title: 'hkeeperid', width: 200, hide: true } + , { field: '淇濈鍛�', title: '淇濈鍛�', width: 200 } + , { field: 'HDeptID', title: 'HDeptID', width: 200, hide: true } + , { field: '閮ㄩ棬', title: '閮ㄩ棬', width: 160 } + , { field: '浠撳簱', title: '浠撳簱', width: 160 } + , { field: 'hsubid', title: 'hsubid', width: 160, hide: true } + , { field: 'hmaterid', title: 'hmaterid', width: 200, hide: true } + , { field: '鐗╂枡浠g爜', title: '鐗╂枡浠g爜', width: 200 } + , { field: '鐗╂枡鍚嶇О', title: '鐗╂枡鍚嶇О', width: 200 } + , { field: '瑙勬牸鍨嬪彿', title: '瑙勬牸鍨嬪彿', width: 200 } + , { field: '鎵规', title: '鎵规', width: 200 } + , { field: 'hunitid', title: 'hunitid', width: 200, hide: true } + , { field: '璁¢噺鍗曚綅', title: '璁¢噺鍗曚綅', width: 200 } + , { field: '搴旀敹鏁伴噺', title: '搴旀敹鏁伴噺', width: 115 } + , { field: '瀹炴敹鏁伴噺', title: '瀹炴敹鏁伴噺', width: 115 } + , { field: '鍑哄簱鏁伴噺', title: '鍑哄簱鏁伴噺', width: 200 } + , { field: '鍗曚环', title: '鍗曚环', width: 200 } + , { field: '閲戦', title: '閲戦', width: 115 } + , { field: 'hwhid', title: 'hwhid', width: 200, hide: true } + , { field: '鏀舵枡浠撳簱浠g爜', title: '鏀舵枡浠撳簱浠g爜', width: 200 } + , { field: '鏀舵枡浠撳簱', title: '鏀舵枡浠撳簱', width: 200 } + , { field: '琛ㄤ綋澶囨敞', title: '琛ㄤ綋澶囨敞', width: 200 } + , { field: '鍒跺崟浜�', title: '鍒跺崟浜�', width: 125 } + , { field: '鍒跺崟鏃ユ湡', title: '鍒跺崟鏃ユ湡', width: 200, templet: "<div>{{d.鍒跺崟鏃ユ湡 ==null ?'':layui.util.toDateString(d.鍒跺崟鏃ユ湡, 'yyyy-MM-dd HH:mm:ss')}}</div>" } + , { field: '瀹℃牳浜�', title: '瀹℃牳浜�', width: 125 } + , { field: '瀹℃牳鏃ユ湡', title: '瀹℃牳鏃ユ湡', width: 200, templet: "<div>{{d.瀹℃牳鏃ユ湡 ==null ? '':layui.util.toDateString(d.瀹℃牳鏃ユ湡, 'yyyy-MM-dd HH:mm:ss')}}</div>" } + , { field: '淇敼浜�', title: '淇敼浜�', width: 125 } + , { field: '淇敼鏃ユ湡', title: '淇敼鏃ユ湡', width: 200, templet: "<div>{{d.淇敼鏃ユ湡 ==null ?'':layui.util.toDateString(d.淇敼鏃ユ湡, 'yyyy-MM-dd HH:mm:ss')}}</div>" } + , { field: '鍏抽棴浜�', title: '鍏抽棴浜�', width: 125 } + , { field: '鍏抽棴鏃ユ湡', title: '鍏抽棴鏃ユ湡', width: 200, templet: "<div>{{d.鍏抽棴鏃ユ湡 ==null ?'':layui.util.toDateString(d.鍏抽棴鏃ユ湡, 'yyyy-MM-dd HH:mm:ss')}}</div>" } + , { field: '浣滃簾浜�', title: '浣滃簾浜�', width: 125 } + , { field: '浣滃簾鏃ユ湡', title: '浣滃簾鏃ユ湡', width: 200, templet: "<div>{{d.浣滃簾鏃ユ湡 ==null ?'':layui.util.toDateString(d.浣滃簾鏃ユ湡, 'yyyy-MM-dd HH:mm:ss')}}</div>" } + + ]] + }; + } + //杩涘叆椤甸潰鏄剧ず鐨勭紦瀛樺垪琛� + function get_Display(sWhere) { + var ajaxLoad = layer.load(); $.ajax({ - //url: "http://61.130.49.162:9090/WMSAPI///Web/GetMAXNum", - url: GetWEBURL1() + '/Kf_OtherInBill/GetOtherInBill', + url: GetWEBURL() + '/Kf_OtherInBill/GetOtherInBill', type: "GET", - data: { "sWhere": sWhere}, + data: { "sWhere": sWhere }, success: function (data1) { if (data1.count == 1) { option.data = data1.data; table.render(option); - layer.close(index); - layer.alert("鏌ヨ鎴愬姛", { icon: 1 }); + layer.close(ajaxLoad); } else { - layer.close(index); + layer.close(ajaxLoad); layer.alert(data1.code + data1.Message, { icon: 5 }); } }, error: function () { - layer.close(index); - layer.alert("鎺ュ彛澶辨晥!", { icon: 5 }); + layer.close(ajaxLoad); + layer.alert("鎺ュ彛璇锋眰澶辫触!", { icon: 5 }); } }); - //璋冪敤鎺ュ彛鍚庢竻绌簊Where缂撳瓨 + } + //澶村伐鍏锋爮浜嬩欢 + table.on('toolbar(mainTable)', function (obj) { + var checkStatus = table.checkStatus(obj.config.id); + switch (obj.event) { + case 'btn-Add': + //椤甸潰灞�-鑷畾涔� + layer.open({ + type: 2, + skin: 'layui-layer-rim', //鍔犱笂杈规 + title: '鏂板閫�璐ч�氱煡鍗�', + closeBtn: 1, + shift: 2, + area: ['100%', '100%'], + maxmin: true, + content: '../../閲囪喘绠$悊/鏀舵枡閫氱煡鍗�/Add_Edit_Cg_POInStockBillList.html?OperationType=1&linterid=0&HSouceBillType=0&closeType=1', + end: function () { + //鍒锋柊椤甸潰, + location.reload(); + }, + success: function (layero, index) { + + } + }); + break; + case 'btn-Edit': + var checkStatus = table.checkStatus('mainTable') + , data = checkStatus.data; + if (checkStatus.data.length === 1) { + var hID = data[0].hmainid.toString(); + //if (AllowLoadData(sSubStr) != false) {//闈炵┖楠岃瘉 + layer.open({ + type: 2 + , area: ['100%', '100%'] + , title: '缂栬緫閫�璐ч�氱煡鍗�' + , closeBtn: 1 + , shade: 0.6 //閬僵閫忔槑搴� + , maxmin: true //鍏佽鍏ㄥ睆鏈�灏忓寲 + , anim: 0 //0-6鐨勫姩鐢诲舰寮忥紝-1涓嶅紑鍚� + , content: '../../閲囪喘绠$悊/鏀舵枡閫氱煡鍗�/Add_Edit_Cg_POInStockBillList.html?OperationType=3&linterid=' + hID + '&HSouceBillType=0&closeType=1' + , resize: false, + end: function () { + //鍒锋柊椤甸潰, + location.reload(); + } + , cancel: function () { + //$(".layui-btn").removeClass("layui-btn-disabled"); + } + }) + + } else { + layer.msg('璇烽�夋嫨涓�琛屾暟鎹紪杈戯紒'); + } + + break; + case 'btn-Delete': + var checkStatus = table.checkStatus('mainTable') + , data = checkStatus.data; + if (checkStatus.data.length === 1) { + var InterID = data[0].hmainid.toString(); + //閫昏緫鍒犻櫎鏂规硶 + layer.confirm("纭瑕佸垹闄ゅ悧锛屽垹闄ゅ悗涓嶈兘鎭㈠", { title: "鍒犻櫎纭" }, function (index) { + $.ajax({ + type: "GET", + url: GetWEBURL() + "Kf_SellOutBill/DeltetSellOutBill", //鏂规硶鎵�鍦ㄩ〉闈㈠拰鏂规硶鍚� + data: { "HInterID": InterID }, + success: function (result) { + if (result.count == 1) { + layer.msg(result.Message, { time: 1 * 1000, icon: 1 }, function () { + // 寰楀埌frame绱㈠紩 + var index = layer.getFrameIndex(window.name); + //鍏抽棴褰撳墠frame + layer.close(index); + //淇敼涓哄姛鍚庡埛鏂扮晫闈� + window.location.reload(); + }); + + } else { + layer.alert(result.code + result.Message, { icon: 5 }); + } + }, error: function () { + layer.alert("鎺ュ彛璇锋眰澶辫触!", { icon: 5 }); + } + }); + }) + } + else { + layer.msg('璇烽�夋嫨涓�琛屾暟鎹垹闄わ紒'); + } + break; + //鍒锋柊 + case 'get_Refresh': get_Refresh(); + break; + //閫�鍑烘寜閽� + case 'get_Exit': Pub_Close(2); + break; + }; + }); + + + //#region 蹇�熻繃婊� + function get_FastQuery(table, option) { + var HDate = $("#HBeginDate").val();//寮�濮嬫棩鏈� + var HDate1 = $("#HEndDate").val();//缁撴潫鏃ユ湡 + var HBillNo = $("#HBillNo").val();//鍗曟嵁鍙� + var HCusID = $("#HCusID").val(); + var HDeptID = $("#HDeptID").val(); + var HMangerID = $("#HMangerID").val(); + if (HDate) { + sWhere += " and CONVERT(varchar(100),鏃ユ湡, 23) >= '" + HDate + "'"; + } + if (HDate1) { + sWhere += " and CONVERT(varchar(100),鏃ユ湡, 23) <= '" + HDate1 + "'"; + } + if (HBillNo) { + sWhere += " and 鍗曟嵁鍙� like '%" + HBillNo + "%'"; + } + if (HCusID) { + sWhere += " and 瀹㈡埛 like '%" + HCusID + "%'"; + } + if (HDeptID) { + sWhere += " and 閮ㄩ棬 like '%" + HDeptID + "%'"; + } + if (HMangerID) { + sWhere += " and 涓荤 like '%" + HMangerID + "%'"; + } + get_Display(sWhere); + sWhere = "";//璋冪敤鎺ュ彛鍚庢竻绌簊Where缂撳瓨 + } + //#endregion + //#region 閲嶇疆杩囨护鏉′欢 + function set_ClearQuery() { + $("#HDate").val("");//寮�濮嬫棩鏈� + $("#HDate1").val("");//缁撴潫鏃ユ湡 + $("#HBillNo").val("");// + $("#HCusID").val(""); + $("#HDeptID").val(""); + $("#HMangerID").val(""); sWhere = ""; - //$("#HBillType").val("");//鍗曟嵁绫诲瀷 - //$("#HBillNo").val("");//鍗曟嵁鍙� - //$("#HSourceBillNo").val("");//婧愬崟鍙� - //$("#HCreateBy").val("");//鍒跺崟浜� - //$("#BenginHCreateDate").val("");//寮�濮嬪埗鍗曟椂闂� - //$("#EndHCreateDate").val("");//缁撴潫鍒跺崟鏃堕棿 - }); + } + //#endregion - //鐩戝惉琛屽弻鍑讳簨浠� - table.on('rowDouble(mainTable)', function (obj) { - layer.alert("鍙屽嚮浜嬩欢", { icon: 1 }); - }); - - - //laydate.render({ - // elem: '#HDate' - // , type: 'datetime' - // , trigger: 'click' - // , format:'yyyy-MM-dd HH:mm' - //}); + //#region 鍒锋柊 + function get_Refresh() { + set_ClearQuery(); + get_Display(sWhere); + } + //#endregion //浠ヤ笂鏄痩ayui妯″潡 -- Gitblit v1.9.1