| | |
| | | <script src="../../../layuiadmin/zgqCustom/zgqCustom.js"></script> |
| | | <script src="../../../layuiadmin/Scripts/webConfig.js"></script> |
| | | <script src="../../../layuiadmin/PubCustom.js"></script> |
| | | <script src="../../../layuiadmin/soulTable.slim.js"></script> |
| | | </head> |
| | | <body> |
| | | <div class="layui-fluid"> |
| | |
| | | <option value="2">已忥</option> |
| | | <option value="3">æªåæ¥</option> |
| | | </select> |
| | | </div> |
| | | </div> |
| | | <div class="layui-row" style=" margin-top: 10px; margin-left: 80px;"> |
| | | <div class="layui-inline"> |
| | | <label class="layui-form-label">è¿æ»¤</label> |
| | | <div class="layui-input-block"> |
| | | <select name="ColName" id="ColName" lay-filter="ColName" style="width:190px;"> |
| | | </select> |
| | | </div> |
| | | </div> |
| | | <div class="layui-inline"> |
| | | <select name="Comparator" id="Comparator" lay-filter="Comparator" style="width:190px;"> |
| | | <option value="0" selected="selected"></option> |
| | | <option value="=">=</option> |
| | | <option value=">=">>=</option> |
| | | <option value=">">></option> |
| | | <option value="<="><=</option> |
| | | <option value="<"><</option> |
| | | <option value="<>"><></option> |
| | | <option value="7">å
å«</option> |
| | | <option value="8">å·¦å
å«</option> |
| | | <option value="9">å³å
å«</option> |
| | | <option value="10">ä¸å
å«</option> |
| | | </select> |
| | | </div> |
| | | <div class="layui-inline"> |
| | | <input type="text" class="layui-input" value="" name="ColContent" id="ColContent"> |
| | | </div> |
| | | </div> |
| | | <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnSearch" id="btnSearch"> |
| | |
| | | <script type="text/html" id="toolbarDemo"> |
| | | <div class="layui-btn-container"> |
| | | <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-InStorage" id="btn-InStorage"><i class="layui-icon layui-icon-ok-circle"></i>å
¥åº</button> |
| | | <button type="button" class="layui-btn layui-btn-sm" lay-event="btn_InStorage_Batch" id="btn_InStorage_Batch"><i class="layui-icon layui-icon-ok-circle"></i>æ¹éå
¥åº</button> |
| | | <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-Exit" id="btn-Exit">éåº</button> |
| | | </div> |
| | | </script> |
| | |
| | | base: '../../../layuiadmin/' //éæèµæºæå¨è·¯å¾ |
| | | }).extend({ |
| | | index: 'lib/index', //主å
¥å£æ¨¡å |
| | | }).use(['index', 'form', 'table', 'element', 'laypage', 'laydate'], function () { |
| | | }).use(['index', 'form', 'table', 'element', 'laypage', 'laydate', 'soulTable'], function () { |
| | | var $ = layui.$ |
| | | , admin = layui.admin |
| | | , layer = layui.layer |
| | |
| | | , laypage = layui.laypage |
| | | , laydate = layui.laydate |
| | | , util = layui.util |
| | | , soulTable = layui.soulTable |
| | | //å
¬ç¨åé |
| | | var sWhere = ""; |
| | | var option = []; |
| | |
| | | , cellMinWidth: 90 |
| | | , limit: 50 |
| | | , limits: [50, 500, 5000, 20000] |
| | | , done: function (res, curr, count) { |
| | | soulTable.render(this); |
| | | } |
| | | , cols: [[ |
| | | { type: 'checkbox', fixed: 'left' } |
| | | , { field: 'hmainid', title: 'hmainid', sort: true, hide: true } |
| | | , { field: 'ä»»å¡å', title: 'ä»»å¡å', width: 125 } |
| | | , { field: 'åæ®å·', title: 'åæ®å·', width: 190 } |
| | | , { field: 'å·¥åºæµè½¬å¡å·', title: 'å·¥åºæµè½¬å¡å·', width: 125 } |
| | | , { field: 'åæ¥ç¶æ', title: 'åæ¥ç¶æ' } |
| | | , { field: 'HProcID', title: 'HProcID', hide: true } |
| | | , { field: 'å½åå·¥åºä»£ç ', title: 'å½åå·¥åºä»£ç ', width: 125 } |
| | | , { field: 'å½åå·¥åº', title: 'å½åå·¥åº' } |
| | | , { field: 'HMaterID', title: 'HMaterID', hide: true } |
| | | , { field: '产å代ç ', title: '产å代ç ' } |
| | | , { field: '产ååç§°', title: '产ååç§°', width: 125 } |
| | | , { field: 'è§æ ¼åå·', title: 'è§æ ¼åå·' } |
| | | , { field: 'ä»»å¡å', title: 'ä»»å¡å', width: 125, sort: true } |
| | | , { field: 'åæ®å·', title: 'åæ®å·', width: 190, sort: true } |
| | | , { field: 'å·¥åºæµè½¬å¡å·', title: 'å·¥åºæµè½¬å¡å·', width: 125, sort: true } |
| | | , { field: 'åæ¥ç¶æ', title: 'åæ¥ç¶æ', sort: true } |
| | | , { field: 'HProcID', title: 'HProcID', hide: true, sort: true } |
| | | , { field: 'å½åå·¥åºä»£ç ', title: 'å½åå·¥åºä»£ç ', width: 125, sort: true } |
| | | , { field: 'å½åå·¥åº', title: 'å½åå·¥åº', sort: true } |
| | | , { field: 'HMaterID', title: 'HMaterID', hide: true, sort: true } |
| | | , { field: '产å代ç ', title: '产å代ç ', sort: true } |
| | | , { field: '产ååç§°', title: '产ååç§°', width: 125, sort: true } |
| | | , { field: 'è§æ ¼åå·', title: 'è§æ ¼åå·', sort: true } |
| | | , { |
| | | field: 'åºç«æ¶é´', title: 'åºç«æ¶é´', width: 160, templet: function (d) { |
| | | field: 'åºç«æ¶é´', title: 'åºç«æ¶é´', width: 160, sort: true, templet: function (d) { |
| | | if (d.åºç«æ¶é´ == null) { |
| | | return ""; |
| | | } |
| | | return util.toDateString(d.åºç«æ¶é´, "yyyy-MM-dd HH:mm:ss"); |
| | | } |
| | | } |
| | | , { field: 'HEmpID', title: 'HEmpID', hide: true } |
| | | , { field: 'æä½å代ç ', title: 'æä½å代ç ', width: 190 } |
| | | , { field: 'æä½å', title: 'æä½å' } |
| | | , { field: 'HSourceID', title: 'HSourceID', hide: true } |
| | | , { field: 'çäº§èµæºä»£ç ', title: 'çäº§èµæºä»£ç ', width: 125 } |
| | | , { field: 'çäº§èµæº', title: 'çäº§èµæº' } |
| | | , { field: 'HGroupID', title: 'HGroupID', hide: true } |
| | | , { field: 'ç产çç»ä»£ç ', title: 'ç产çç»ä»£ç ', width: 125 } |
| | | , { field: 'ç产çç»', title: 'ç产çç»' } |
| | | , { field: 'LOTæ°é', title: 'LOTæ°é' } |
| | | , { field: 'æ¥æ¶æ°é', title: 'åºç«æ°é' } |
| | | , { field: 'HEmpID', title: 'HEmpID', hide: true, sort: true } |
| | | , { field: 'æä½å代ç ', title: 'æä½å代ç ', width: 190, sort: true } |
| | | , { field: 'æä½å', title: 'æä½å', sort: true } |
| | | , { field: 'HSourceID', title: 'HSourceID', hide: true, sort: true } |
| | | , { field: 'çäº§èµæºä»£ç ', title: 'çäº§èµæºä»£ç ', width: 125, sort: true } |
| | | , { field: 'çäº§èµæº', title: 'çäº§èµæº', sort: true } |
| | | , { field: 'HGroupID', title: 'HGroupID', hide: true, sort: true } |
| | | , { field: 'ç产çç»ä»£ç ', title: 'ç产çç»ä»£ç ', width: 125, sort: true } |
| | | , { field: 'ç产çç»', title: 'ç产çç»', sort: true } |
| | | , { field: 'LOTæ°é', title: 'LOTæ°é', sort: true } |
| | | , { field: 'æ¥æ¶æ°é', title: 'åºç«æ°é', sort: true } |
| | | ]] |
| | | , text: { |
| | | none: 'æ æ°æ®ï¼' |
| | |
| | | get_FastQuery(); |
| | | } |
| | | |
| | | |
| | | |
| | | |
| | | //头工å
·æ äºä»¶ |
| | | table.on('toolbar(mainTable)', function (obj) { |
| | | switch (obj.event) { |
| | | //å
¥åº |
| | | case 'btn-InStorage': get_InStorage(); |
| | | break; |
| | | //æ¹éå
¥åº |
| | | case 'btn_InStorage_Batch': get_InStorage_Batch(); |
| | | break; |
| | | //éåº |
| | | case 'btn-Exit': get_Exit(); |
| | |
| | | $("#HBillNo").val(""); |
| | | $("#HDate").val(Format(new Date(new Date() - 1000 * 60 * 60 * 24 * 30), "yyyy-MM-dd")); |
| | | $("#HProcExchBillNo").val(""); |
| | | $("#HRelationQty").val("1") |
| | | $("#HRelationQty").val("1"); |
| | | $("#ColContent").val(""); |
| | | $("#ColName").val("0"); |
| | | $("#Comparator").val("0"); |
| | | form.render("select"); |
| | | } |
| | | |
| | |
| | | var HBillNo = $("#HBillNo").val(); |
| | | var HProcExchBillNo = $("#HProcExchBillNo").val(); |
| | | var HRelationQty = $("#HRelationQty").val(); |
| | | var ColName = $("#ColName").val();//å¤éæ¡ |
| | | var Comparator = $("#Comparator").val() |
| | | var ColContent = $("#ColContent").val(); |
| | | switch (HRelationQty) { |
| | | case "1": |
| | | sWhere += ""; |
| | |
| | | case "3": |
| | | sWhere += " and åæ¥ç¶æ = ''"; |
| | | break; |
| | | } |
| | | if (ColName != 0 && Comparator != 0) { |
| | | var com = ""; |
| | | switch (Comparator) { |
| | | case "7": |
| | | com = "like'%" + ColContent + "%'"; |
| | | break; |
| | | case "8": |
| | | com = "like'%" + ColContent + "'"; |
| | | break; |
| | | case "9": |
| | | com = "like'" + ColContent + "%'"; |
| | | break; |
| | | case "10": |
| | | com = "not like'%" + ColContent + "%'"; |
| | | break; |
| | | default: |
| | | com = "" + Comparator + "'" + ColContent + "'"; |
| | | break; |
| | | } |
| | | sWhere += " and " + ColName + " " + com; |
| | | } |
| | | if (HDate) { |
| | | sWhere += " and CONVERT(varchar(100),åºç«æ¶é´, 23) = '" + HDate + "'"; |
| | |
| | | } |
| | | table.render(option); |
| | | layer.close(wait); |
| | | if ($("#Comparator").val() == 0 && $("#ColContent").val() == "") { |
| | | ColFilter(); |
| | | } |
| | | }, error: function () { |
| | | layer.close(wait); |
| | | layer.alert("æ¥å£è¯·æ±å¤±è´¥!", { icon: 5 }); |
| | |
| | | }); |
| | | } |
| | | |
| | | //æ¹éå
¥åº |
| | | function get_InStorage_Batch() { |
| | | var checkStatus = table.checkStatus('mainTable') |
| | | , data = checkStatus.data; |
| | | if (checkStatus.data.length > 0) { |
| | | var InterID = []; |
| | | var BillNo = []; |
| | | for (var i = 0; i < data.length; i++) { |
| | | InterID.push(data[i].hmainid.toString()); |
| | | BillNo.push(data[i].åæ®å·.toString()); |
| | | } |
| | | |
| | | var msg = InterID + ';' + sessionStorage["HUserName"] + ';' + BillNo + ";" + sessionStorage["OrganizationID"]; |
| | | $.ajax({ |
| | | type: "POST", |
| | | url: GetWEBURL() + "/Sc_ProcessMangement/SaveICMOReportBill_Batch", //æ¹æ³æå¨é¡µé¢åæ¹æ³å |
| | | async: true, |
| | | data: { "msg": msg }, |
| | | dataType: "json", |
| | | success: function (data) { |
| | | if (data.count == 1) { // 说æéªè¯æåäºï¼ |
| | | layer.alert(data.Message, { icon: 1 }); |
| | | } |
| | | else { |
| | | layer.alert(data.Message, { icon: 5 }); |
| | | } |
| | | }, |
| | | error: function (err) { |
| | | layer.alert(err.responseText, { icon: 5 }); |
| | | } |
| | | }); |
| | | } |
| | | else { |
| | | layer.msg('è¯·éæ©è³å°ä¸è¡æ°æ®ï¼'); |
| | | } |
| | | } |
| | | //å
¥åº |
| | | function get_InStorage() { |
| | | var checkStatus = table.checkStatus('mainTable') |
| | |
| | | type: "GET", |
| | | url: GetWEBURL() + "/Sc_ProcessMangement/SaveICMOReportBill", //æ¹æ³æå¨é¡µé¢åæ¹æ³å |
| | | async: true, |
| | | data: { "InterID": InterID, "user": sessionStorage["HUserName"], "BillNo": BillNo, "OrganizationID": sessionStorage["OrganizationID"]}, |
| | | data: { "InterID": InterID, "user": sessionStorage["HUserName"], "BillNo": BillNo, "OrganizationID": sessionStorage["OrganizationID"] }, |
| | | dataType: "json", |
| | | success: function (data) { |
| | | if (data.count == 1) { // 说æéªè¯æåäºï¼ |
| | |
| | | layer.msg('è¯·éæ©ä¸è¡æ°æ®å
¥åºï¼'); |
| | | } |
| | | } |
| | | |
| | | //åææ¾ç¤ºä¸ææ¡ |
| | | function ColFilter() { |
| | | var Organization = '<option value="0" selected="selected" ></option>'; |
| | | for (var i = 1; i < option.cols[0].length; i++) { |
| | | if (option.cols[0][i].hide != true) { |
| | | Organization += '<option style="color:blue;" value="' + option.cols[0][i].field + '">' + option.cols[0][i].field + '</option>'; |
| | | } |
| | | } |
| | | $("#ColName").empty(); |
| | | $("#ColName").append(Organization); |
| | | form.render('select'); |
| | | } |
| | | //éåº |
| | | function get_Exit() { |
| | | Pub_Close(2); |