From d86534d4f9b0c8da4f1c00d277a8ad5904892004 Mon Sep 17 00:00:00 2001 From: zrg <z18737863051@163.com> Date: 星期三, 21 八月 2024 16:18:43 +0800 Subject: [PATCH] 报工台跳转异常反馈单 增加生产资源回线,增加 生产日模具需求报表,报工台获取单据状态方法优化 --- WebTM/views/车间管理/报表分析/Sc_MouldRequirementDay.html | 831 +++++++++++++++++++++++++++++++++++++++++++++++++++ WebTM/views/设备管理/Sb_EquipDotCheckBillList.html | 24 + WebTM/views/IpadIndex.html | 54 ++- WebTM/views/生产管理/异常反馈单/Sc_Add_MESExecptFeedBackBillList.html | 3 WebTM/WebTM.csproj | 1 5 files changed, 889 insertions(+), 24 deletions(-) diff --git a/WebTM/WebTM.csproj b/WebTM/WebTM.csproj index a275595..7307871 100644 --- a/WebTM/WebTM.csproj +++ b/WebTM/WebTM.csproj @@ -517,6 +517,7 @@ <Content Include="views\杞﹂棿绠$悊\鎶ヨ〃鍒嗘瀽\Kf_PressurizedWaterNoOutReport.html" /> <Content Include="views\杞﹂棿绠$悊\鍚姩鐐规鍗昞Gy_WorkBeginDotCheckListBill.html" /> <Content Include="views\杞﹂棿绠$悊\鍚姩鐐规鍗昞Gy_WorkBeginDotCheckListBillList.html" /> + <Content Include="views\杞﹂棿绠$悊\鎶ヨ〃鍒嗘瀽\Sc_MouldRequirementDay.html" /> <Content Include="views\杞﹂棿绠$悊\鎶ヨ〃鍒嗘瀽\Sc_CompareOrderToSelloutReport.html" /> <Content Include="views\杞﹂棿绠$悊\鎶ヨ〃鍒嗘瀽\Sc_HICMMaterStatisticsList.html" /> <Content Include="views\杞﹂棿绠$悊\鎶ヨ〃鍒嗘瀽\Sc_ProductedRateReport.html" /> diff --git a/WebTM/views/IpadIndex.html b/WebTM/views/IpadIndex.html index f4f5488..7fdb583 100644 --- a/WebTM/views/IpadIndex.html +++ b/WebTM/views/IpadIndex.html @@ -995,6 +995,10 @@ layer.alert("璇烽�夋嫨宸ュ崟鍒楄〃", { icon: 5 }); return false; } + if (WorkStaus(HSourceID1, workcode, HSourceInterID, "涓嶈壇閲囬泦")) { + layer.alert("鍗曟嵁鐘舵�佷笉婊¤冻涓嶈壇閲囬泦鏉′欢!", { icon: 5 }); + return false; + } layer.open({ type: 2 , area: ['100%', '100%'] @@ -1065,6 +1069,10 @@ function CodingReport(event, obj) { if (wktag == 0) { layer.alert("璇烽�夋嫨宸ュ崟鍒楄〃", { icon: 5 }); + return false; + } + if (WorkStaus(HSourceID1, workcode, HSourceInterID, "姹囨姤")) { + layer.alert("鍗曟嵁鐘舵�佷笉婊¤冻姹囨姤鏉′欢!", { icon: 5 }); return false; } layer.open({ @@ -1244,6 +1252,10 @@ layer.alert("璇烽�夋嫨宸ュ崟鍒楄〃", { icon: 5 }); return false; } + if (WorkStaus(HSourceID1, workcode, HSourceInterID, "宸ヨ壓鍙傛暟鐐规")) { + layer.alert("鍗曟嵁鐘舵�佷笉婊¤冻宸ヨ壓鍙傛暟鐐规鏉′欢!", { icon: 5 }); + return false; + } layer.open({ type: 2, skin: 'layui-layer-rim', //鍔犱笂杈规 @@ -1284,29 +1296,35 @@ function WorkStaus(HSourceID1, workcode, HSourceInterID, btn) { var flag = false; var sWhere = ""; - switch (btn) { - case "寮�宸�": - sWhere = " where HSourceID='" + HSourceID1 + "' and HICMOBillNo='" + workcode + "' and HInterID='" + HSourceInterID + "' and hicmostatus not in('0','2')"; //鏄惁鏈変笉涓哄紑宸ュ紑宸ョ姸鎬併�佸仠宸ョ姸鎬� - break; - case "瀹屽伐": - sWhere = " where HSourceID='" + HSourceID1 + "' and HICMOBillNo='" + workcode + "' and HInterID='" + HSourceInterID + "' and hicmostatus not in('1','2')"; //鏄惁鏈変笉涓哄紑宸ャ�佸畬宸ョ姸鎬� - break; - case "鍋滃伐": - sWhere = " where HSourceID='" + HSourceID1 + "' and HICMOBillNo='" + workcode + "' and HInterID='" + HSourceInterID + "' and hicmostatus not in('1')"; //鏄惁鏈変笉涓哄仠宸ユ寕璧风姸鎬� - break; - case "姹囨姤": - sWhere = " where HSourceID='" + HSourceID1 + "' and HICMOBillNo='" + workcode + "' and HInterID='" + HSourceInterID + "' and hicmostatus not in('1','2')"; //鏄惁鏈変笉涓哄紑宸ャ�佸仠宸ユ寕璧风姸鎬� - break; - case "鎶ユ鐢宠": - - break; - default: + sWhere = { + HSourceID: HSourceID1 + , HICMOBillNo: workcode + , HInterID: HSourceInterID + , type: btn } + //switch (btn) { + // case "寮�宸�": + // sWhere = " where HSourceID='" + HSourceID1 + "' and HICMOBillNo='" + workcode + "' and HInterID='" + HSourceInterID + "' and hicmostatus not in('0','2')"; //鏄惁鏈変笉涓哄紑宸ュ紑宸ョ姸鎬併�佸仠宸ョ姸鎬� + // break; + // case "瀹屽伐": + // sWhere = " where HSourceID='" + HSourceID1 + "' and HICMOBillNo='" + workcode + "' and HInterID='" + HSourceInterID + "' and hicmostatus not in('1','2')"; //鏄惁鏈変笉涓哄紑宸ャ�佸畬宸ョ姸鎬� + // break; + // case "鍋滃伐": + // sWhere = " where HSourceID='" + HSourceID1 + "' and HICMOBillNo='" + workcode + "' and HInterID='" + HSourceInterID + "' and hicmostatus not in('1')"; //鏄惁鏈変笉涓哄仠宸ユ寕璧风姸鎬� + // break; + // case "姹囨姤": + // sWhere = " where HSourceID='" + HSourceID1 + "' and HICMOBillNo='" + workcode + "' and HInterID='" + HSourceInterID + "' and hicmostatus not in('1','2')"; //鏄惁鏈変笉涓哄紑宸ャ�佸仠宸ユ寕璧风姸鎬� + // break; + // case "鎶ユ鐢宠": + + // break; + // default: + //} $.ajax({ url: GetWEBURL() + "/Sc_MESBeginWorkBill/GetMESBeginWorkBillStaus", type: "GET", - data: { "sWhere": sWhere }, + data: { "sWhere": JSON.stringify(sWhere) }, dataType: "json",//鏁版嵁绫诲瀷鍙互涓� text xml json script jsonp async: false, success: function (data) { diff --git "a/WebTM/views/\347\224\237\344\272\247\347\256\241\347\220\206/\345\274\202\345\270\270\345\217\215\351\246\210\345\215\225/Sc_Add_MESExecptFeedBackBillList.html" "b/WebTM/views/\347\224\237\344\272\247\347\256\241\347\220\206/\345\274\202\345\270\270\345\217\215\351\246\210\345\215\225/Sc_Add_MESExecptFeedBackBillList.html" index 85d9a71..ce83246 100644 --- "a/WebTM/views/\347\224\237\344\272\247\347\256\241\347\220\206/\345\274\202\345\270\270\345\217\215\351\246\210\345\215\225/Sc_Add_MESExecptFeedBackBillList.html" +++ "b/WebTM/views/\347\224\237\344\272\247\347\256\241\347\220\206/\345\274\202\345\270\270\345\217\215\351\246\210\345\215\225/Sc_Add_MESExecptFeedBackBillList.html" @@ -621,6 +621,7 @@ success: function (data) { if (data.count == 1)// 璇存槑楠岃瘉鎴愬姛浜嗭紝 { + var LoadData = data.data; $("#HMaterNumber").val(LoadData[0].鐗╂枡浠g爜); //浜у搧鍚嶇О $("#HMaterName").val(LoadData[0].鐗╂枡鍚嶇О); //浜у搧鍚嶇О @@ -630,6 +631,8 @@ $("#HMainSourceEntryID").val(LoadData[0].娴佽浆鍗″瓙鍐呯爜); //婧愬崟瀛愬唴鐮� $("#HMainSourceBillType").val(3772); //婧愬崟绫诲瀷 $("#HQty").val(LoadData[0].璁″垝鏁伴噺); //璁″垝鏁伴噺 + $("#HSourceID").val(LoadData[0].HSourceID); //鐢熶骇璧勬簮id + $("#HSourceName").val(LoadData[0].鐢熶骇璧勬簮); //鐢熶骇璧勬簮 } else { layer.alert(data.Message, { icon: 5 }); diff --git "a/WebTM/views/\350\256\276\345\244\207\347\256\241\347\220\206/Sb_EquipDotCheckBillList.html" "b/WebTM/views/\350\256\276\345\244\207\347\256\241\347\220\206/Sb_EquipDotCheckBillList.html" index 6d9dbe5..5751daf 100644 --- "a/WebTM/views/\350\256\276\345\244\207\347\256\241\347\220\206/Sb_EquipDotCheckBillList.html" +++ "b/WebTM/views/\350\256\276\345\244\207\347\256\241\347\220\206/Sb_EquipDotCheckBillList.html" @@ -174,11 +174,11 @@ <button type="button" class="layui-btn layui-btn-sm" lay-event="set_DeleteBill" id="DeleteBill"><i class="layui-icon layui-icon-delete"></i>鍒犻櫎</button> <!--<button type="button" class="layui-btn layui-btn-sm" lay-event="btn-getCheckData" id="getCheckData"><i class="layui-icon layui-icon-tips"></i>棰勮</button>--> <!--<button type="button" class="layui-btn layui-btn-sm" lay-event="btn-reload" id="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" id="details"><i class="layui-icon layui-icon-form"></i>璇︽儏</button> - <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-generate" id="generate"><i class="layui-icon layui-icon-file"></i>鐢熸垚閫佽揣鍗�</button>--> - <button type="button" class="layui-btn layui-btn-sm" lay-event="set_CheckBill" id="CheckBill"><i class="layui-icon layui-icon-form"></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" id="details"><i class="layui-icon layui-icon-form"></i>璇︽儏</button> + <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-generate" id="generate"><i class="layui-icon layui-icon-file"></i>鐢熸垚閫佽揣鍗�</button>--> + <button type="button" class="layui-btn layui-btn-sm" lay-event="set_CheckBill" id="CheckBill"><i class="layui-icon layui-icon-form"></i>瀹℃牳</button> <button type="button" class="layui-btn layui-btn-sm" lay-event="set_AbandonCheck" id="AbandonCheck"><i class="layui-icon layui-icon-form"></i>鍙嶅鏍�</button> <button type="button" class="layui-btn layui-btn-sm" lay-event="set_CloseBill" id="set_CloseBill"><i class="layui-icon layui-icon-form"></i>鍏抽棴</button> <button type="button" class="layui-btn layui-btn-sm" lay-event="set_CancelCloseBill" id="set_CancelCloseBill"><i class="layui-icon layui-icon-form"></i>鍙嶅叧闂�</button> @@ -187,6 +187,7 @@ <button type="button" class="layui-btn layui-btn-sm" lay-event="set_SaveScheme" id="set_SaveScheme"><i class="layui-icon layui-icon-template"></i>淇濆瓨鏂规</button> <button type="button" class="layui-btn layui-btn-sm" lay-event="set_ReadScheme" id="set_ReadScheme"><i class="layui-icon layui-icon-set"></i>璇诲彇鏂规</button> <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-exit" id="exit"><i class="layui-icon layui-icon-return"></i>閫�鍑�</button> + <button type="button" class="layui-btn layui-btn-sm" lay-event="btn_LookDown" id="btn_LookDown"><i class="layui-icon layui-icon-export"></i>瀵煎嚭</button> </div> </script> </form> @@ -221,6 +222,7 @@ //鏌ヨ鏉′欢 var sWhere = ""; var option = []; + var ins; var HModName = "Sb_EquipDotCheckBillList"; @@ -275,6 +277,8 @@ break; //閫�鍑烘寜閽� case 'btn-exit': Pub_Close(2); + break; + case 'btn_LookDown': get_Export(); break; //鍒楄缃� case 'set_HideColumn': get_HideColumn(); @@ -461,7 +465,7 @@ } } table.render(option); - + ins = table.render(option); //鍒锋柊琛ㄦ牸鏁版嵁 DisPlay_HideColumn(); @@ -764,6 +768,14 @@ get_Display(sWhere); } + //#region 瀵煎嚭Execel + function get_Export() { + var data = option.data + + table.exportFile(ins.config.id, data, "xls"); + } + //#endregion + //闅愯棌鍒楄缃� function get_HideColumn() { var colName = ""; diff --git "a/WebTM/views/\350\275\246\351\227\264\347\256\241\347\220\206/\346\212\245\350\241\250\345\210\206\346\236\220/Sc_MouldRequirementDay.html" "b/WebTM/views/\350\275\246\351\227\264\347\256\241\347\220\206/\346\212\245\350\241\250\345\210\206\346\236\220/Sc_MouldRequirementDay.html" new file mode 100644 index 0000000..150e972 --- /dev/null +++ "b/WebTM/views/\350\275\246\351\227\264\347\256\241\347\220\206/\346\212\245\350\241\250\345\210\206\346\236\220/Sc_MouldRequirementDay.html" @@ -0,0 +1,831 @@ +锘�<!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 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/HideButton.js"></script> + <script src="../../../layuiadmin/PubCustom.js"></script> + <script src="../../../layuiadmin/zgqCustom/zgqCustom.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/lib/extend/echarts.min.js'></script> + +</head> +<body> + <div class="layui-fluid"> + <div class="layui-col-md12"> + <div class="layui-card" style="padding: 1px"> + <div class="layui-card-body" style="padding: 1px;"> + <form class="layui-form" action="" lay-filter="component-form-group"> + <div class="layui-collapse"> + <div class="layui-colla-item"> + <div class="layui-colla-title layui-inline"> + <div class="layui-inline"> + <span>鏇村</span> + </div> + </div> + <div class="layui-inline"> + <label class="layui-form-label">閮ㄩ棬</label> + <div class="layui-input-block" style="width: 190px;"> + <select name="HDeptName" id="HDeptName" lay-verify="HDeptName"> + <!--鍔ㄦ�佹覆鏌撻儴闂�--> + </select> + </div> + </div> + <div class="layui-inline"> + <label class="layui-form-label" style="width: 85px;padding: 9px 18px;">鐢熶骇璁㈠崟</label> + <div class="layui-input-block"> + <input type="text" class="layui-input" lay-verify="HICMOBillNo" name="HICMOBillNo" id="HICMOBillNo" value="" style="background-color:#efefef4d;width: 75%;display: inline-block;" readonly> + <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnHICMOBillNo" id="btnHICMOBillNo" style="padding: 0 10px;float: right;margin-right: 3px;"> + <i class="layui-icon layui-icon-search layuiadmin-button-btn"></i> + </button> + </div> + </div> + <div class="layui-inline"> + <label class="layui-form-label" style="width: 85px;">鐗╂枡浠g爜</label> + <div class="layui-input-block" style="margin-left: 120px;"> + <input type="text" class="layui-input" name="HMaterNumber" id="HMaterNumber" value="" > + </div> + </div> + <div class="layui-inline"> + <label class="layui-form-label" style="width: 85px;">鐗╂枡鍚嶇О</label> + <div class="layui-input-block" style="margin-left: 120px;"> + <input type="text" class="layui-input" name="HMaterName" id="HMaterName" value=""> + </div> + </div> + + <div class="layui-row" style="margin-top:5px;margin-left:82px;margin-bottom:5px;"> + <div class="layui-inline"> + <label class="layui-form-label" style="width: 85px;">鐢熶骇璧勬簮</label> + <div class="layui-input-block" style="margin-left: 120px;"> + <input type="text" class="layui-input" name="HSoureName" id="HSoureName" value=""> + </div> + </div> + <div class="layui-inline"> + <label class="layui-form-label" style="width: 85px;">妯″叿缂栫爜</label> + <div class="layui-input-block" style="margin-left: 120px;"> + <input type="text" class="layui-input" name="HMouldNumber" id="HMouldNumber" value=""> + </div> + </div> + <div class="layui-inline"> + <label class="layui-form-label" style="width: 85px;">妯″叿</label> + <div class="layui-input-block" style="margin-left: 120px;"> + <input type="text" class="layui-input" name="HMouldName" id="HMouldName" value=""> + </div> + </div> + <div class="layui-inline"> + <label class="layui-form-label">鏃ユ湡</label> + <div class="layui-input-block"> + <input type="date" class="layui-input ForFilteringSchemes" id="HDate" style="width:190px;"> + </div> + </div> + <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnSearch" id="btnSearch" style="padding: 0 10px;margin-left: 20px;"> + <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> + + + <div class="layui-colla-content" style="padding: 0px; margin-left: 6%;"> + <div class="layui-row" style="margin-top:5px"> + <div class="layui-inline"> + <label class="layui-form-label">杩囨护</label> + <div class="layui-input-block"> + <select name="ColName" id="ColName" class="ForFilteringSchemes" lay-filter="ColName" style="width:190px;"> + </select> + </div> + </div> + <div class="layui-inline"> + <select name="Comparator" id="Comparator" class="ForFilteringSchemes" 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 ForFilteringSchemes" value="" name="ColContent" id="ColContent"> + </div> + </div> + <div class="layui-row" style="margin-top:5px"> + <div class="layui-inline"> + <label class="layui-form-label">杩囨护</label> + <div class="layui-input-block"> + <select name="ColName1" id="ColName1" lay-filter="ColName1" style="width:190px;"> + </select> + </div> + </div> + <div class="layui-inline"> + <select name="Comparator1" id="Comparator1" lay-filter="Comparator1" 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="ColContent1" id="ColContent1"> + </div> + </div> + <div class="layui-row" style="margin-top:5px"> + <div class="layui-inline"> + <label class="layui-form-label">杩囨护</label> + <div class="layui-input-block"> + <select name="ColName2" id="ColName2" lay-filter="ColName2" style="width:190px;"> + </select> + </div> + </div> + <div class="layui-inline"> + <select name="Comparator2" id="Comparator2" lay-filter="Comparator2" 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="ColContent2" id="ColContent2"> + </div> + </div> + </div> + </div> + </div> + <div> + <div style="width:99%;height:calc(100vh);"> + <table class="" id="mainTable" lay-filter="mainTable"></table> + </div> + <div id="histogram" style="width:99.5%;height:calc(68vh);margin-top:10px;"> + </div> + </div> + <script type="text/html" id="toolbarDemo"> + <div class="layui-btn-container"> + <button type="button" class="layui-btn layui-btn-sm" lay-event="get_Refresh" id="RefreshButton"><i class="layui-icon layui-icon-refresh-3"></i>鍒锋柊</button> + <button type="button" class="layui-btn layui-btn-sm" lay-event="get_export" id="get_export"><i class="layui-icon layui-icon-export"></i>瀵煎嚭</button> + <button type="button" class="layui-btn layui-btn-sm" lay-event="set_HideColumn" id="HideButton"><i class="layui-icon layui-icon-form"></i>鍒楄缃�</button> + <button type="button" class="layui-btn layui-btn-sm" lay-event="get_Exit" id="ExitButton"><i class="layui-icon layui-icon-logout"></i>閫�鍑�</button> + </div> + </script> + + </form> + </div> + </div> + </div> + </div> + + <script> + layui.config({ + base: '../../../layuiadmin/' //闈欐�佽祫婧愭墍鍦ㄨ矾寰� + }).extend({ + index: 'lib/index', //涓诲叆鍙fā鍧� + }).use(['index', 'form', 'table', 'element', 'laypage', 'laydate'], function () { + //#region 鍏叡鍙橀噺 + 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 = ""; + var option = []; + var HModName = "SB_TechnologyParameterList"; + //涓嶉渶瑕佹樉绀虹殑瀛楁 鍙墿灞� + var titleData = ["骞�", "鏈�", "宸ュ簭"]; + + + var ins; //鐢ㄤ簬瀵煎嚭excel + //#endregion + + //#region 杩涘叆椤甸潰鏃㈠姞杞� + //鍒濆鍖栫晫闈� + set_ClearBill(); + //#endregion + + //#region 瑙﹀彂浜嬩欢锛氬寘鎷琭orm.on(){}鏍煎紡鐨勬墍鏈夌偣鍑讳簨浠躲�侀�夋嫨浜嬩欢绛� + //澶村伐鍏锋爮浜嬩欢 + table.on('toolbar(mainTable)', function (obj) { + var checkStatus = table.checkStatus(obj.config.id); + switch (obj.event) { + //鍒锋柊 + case 'get_Refresh': get_Refresh(); + break; + //閫�鍑烘寜閽� + case 'get_Exit': Pub_Close(2); + break; + //瀵煎嚭excel + case 'get_export': + get_Export(); + break; + //鍒楄缃� + case 'set_HideColumn': get_HideColumn(); + break; + }; + }); + //鏌ヨ鎸夐挳 + form.on('submit(btnSearch)', function (data) { + get_FastQuery(); + }); + // 閲嶇疆鎸夐挳 + form.on('submit(btnReSearch)', function (data) { + set_ClearQuery(); + }); + //#endregion + + //#region 鐐瑰嚮琛岄�変腑楂樹寒 + table.on('row(mainTable)', function (obj) { + //閫変腑琛屾敼鍙橀鑹� + var flag = !obj.tr.find(':checkbox:first').prop('checked'); + obj.tr.find(':checkbox').prop('checked', flag); + if (flag) { + obj.tr.find('.layui-form-checkbox').addClass('layui-form-checked'); //璁剧疆澶嶉�夋閫変腑鏍峰紡 + $(obj.tr.selector).attr({ "style": "background:#ceedfa;color:black" });//鏀瑰彉褰撳墠tr鑳屾櫙棰滆壊鍜屽瓧浣撻鑹� + } else { + obj.tr.find('.layui-form-checkbox').removeClass('layui-form-checked');//鍙栨秷澶嶉�夋閫変腑鏍峰紡 + $(obj.tr.selector).attr({ "style": "background:" });//鍙栨秷褰撳墠tr棰滆壊 + } + //mainTable 涓鸿〃鏍糏D 娉ㄦ剰姝ゅ濡傛灉ID涓嶆纭皢瀵艰嚧浣犲湪鐩戝惉澶嶉�夋鏃惰幏鍙栦笉鍒颁綘閫夋嫨鐨勬暟鎹紝鍓嶉潰鐨勫彧鏄坊鍔犳垨鍒犻櫎閫変腑鏈�変腑鏍峰紡浠ュ強璁剧疆鑳屾櫙鑹诧紝瀛椾綋棰滆壊 + layui.each(table.cache.mainTable, function (i, l) { + if (obj.tr.index() == l.LAY_TABLE_INDEX) { + l.LAY_CHECKED = flag; + } + }); + }) + //#endregion + + //#region 姝ら〉闈㈡墍鏈夋柟娉� + // 鍒濆鍖栫晫闈� + function set_ClearBill() { + $("#HDate").val(Format(new Date, "yyyy-MM-dd")); + set_InitGrid(); //鍒濆鍖栬〃鏍� + DeptName();//鍒濆鍖栭儴闂� + get_FastQuery(); + + } + //鍒濆鍖栬〃鏍� + function set_InitGrid() { + option = { + elem: '#mainTable' + , toolbar: '#toolbarDemo' + , totalRow: true + , height: 'full-50' + , page: true + , cellMinWidth: 90 + , limit: 50 + , data: [] + , limits: [50, 500, 5000, 20000] + , cols: [] + }; + table.render(option) + } + + //鏌ヨ + function get_Display(sWhere) { + var index = layer.load(0, { shade: false }); + var ajaxLoad = layer.load(); + //杩涘叆椤甸潰鏄剧ず鐨勭紦瀛樺垪琛� + $.ajax({ + url: GetWEBURL() + '/Mes_OrderProcFlowAllReport/getSc_MouldRequirementDay', + type: "GET", + async:false, + data: { "sWhere": sWhere, "user": sessionStorage["HUserName"] }, + success: function (data1) { + if (data1.count == 1) { + var data = []; + var col = []; + //缁欑┖鐨勬暟缁勮祴鍊� + for (var key in data1.list) { + data.push({ "id": data1.list[key].ColmCols, "name": data1.list[key].ColmCols, "Type": data1.list[key].ColmType }); + } + //鍦ㄥ垪琛ㄥ乏杈规坊鍔犲嬀閫夋 + col.push({ type: 'checkbox', fixed: 'left' }); + for (var i = 0; i < data.length; i++) { + if ($.inArray(data[i].name, titleData) > -1) { + col.push({ field: data[i].id, title: data[i].name, align: 'center', hide: true }); //闅愯棌id鍒� + } + else { + switch (data[i].Type) { + //int + case 'DateTime': + col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: true, templet: "<div>{{d." + data[i].name + " ==null ?'':layui.util.toDateString(d." + data[i].name + ", 'yyyy-MM-dd')}}</div>", width: 200 }); + break; + default: + col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: true, width: 200 }); + } + } + } + + //鍔ㄦ�佹樉绀哄垪鍚� + option = { + elem: '#mainTable' + , toolbar: '#toolbarDemo' + , cols: [col] + , data: data1.data + , height: 'full-80' + , page: true + , limits: [50, 500, 5000, 50000] + , limit: 50 + , cellMinWidth: 90 + } + ins = table.render(option); + + //鍒锋柊琛ㄦ牸鏁版嵁 + DisPlay_HideColumn(); + + layer.close(ajaxLoad); + if ($("#Comparator").val() == 0 && $("#ColContent").val() == "") { + ColFilter(); + } + + } else { + layer.close(ajaxLoad); + layer.alert(data1.code + data1.Message, { icon: 5 }); + } + }, error: function () { + layer.close(ajaxLoad); + layer.alert("鎺ュ彛璇锋眰澶辫触!", { icon: 5 }); + } + }); + layer.close(index); + } + //蹇�熸煡璇� + function get_FastQuery() { + var HDeptName = $("#HDeptName").val();//閮ㄩ棬 + var HICMOBillNo = $("#HICMOBillNo").val();//鐢熶骇璁㈠崟 + var HMaterNumber = $("#HMaterNumber").val();//鐗╂枡浠g爜 + var HMaterName = $("#HMaterName").val();//鐗╂枡鍚嶇О + var HSoureName = $("#HSoureName").val();//鐢熶骇璧勬簮 + var HMouldNumber = $("#HMouldNumber").val();//妯″叿缂栫爜 + var HMouldName = $("#HMouldName").val();//妯″叿 + var HDate = $("#HDate").val(); + + var ColName = $("#ColName").val();//澶嶉�夋 + var Comparator = $("#Comparator").val() + var ColContent = $("#ColContent").val(); + + var ColName1 = $("#ColName1").val();//澶嶉�夋 + var Comparator1 = $("#Comparator1").val() + var ColContent1 = $("#ColContent1").val(); + var ColName2 = $("#ColName2").val();//澶嶉�夋 + var Comparator2 = $("#Comparator2").val() + var ColContent2 = $("#ColContent2").val(); + + 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 (ColName1 != 0 && Comparator1 != 0) { + var com1 = ""; + switch (Comparator1) { + case "7": + com1 = "like'%" + ColContent1 + "%'"; + break; + case "8": + com1 = "like'%" + ColContent1 + "'"; + break; + case "9": + com1 = "like'" + ColContent1 + "%'"; + break; + case "10": + com1 = "not like'%" + ColContent1 + "%'"; + break; + default: + com1 = "" + Comparator1 + "'" + ColContent1 + "'"; + break; + } + sWhere += " and " + ColName1 + " " + com1; + } + if (ColName2 != 0 && Comparator2 != 0) { + var com2 = ""; + switch (Comparator2) { + case "7": + com2 = "like'%" + ColContent2 + "%'"; + break; + case "8": + com2 = "like'%" + ColContent2 + "'"; + break; + case "9": + com2 = "like'" + ColContent2 + "%'"; + break; + case "10": + com2 = "not like'%" + ColContent2 + "%'"; + break; + default: + com2 = "" + Comparator + "'" + ColContent + "'"; + break; + } + sWhere += " and " + ColName2 + " " + com2; + } + + if (HDeptName!="0") { + if (HDeptName) { + sWhere += " and 閮ㄩ棬 like '%" + HDeptName + "%'"; + } + } + if (HICMOBillNo) { + sWhere += " and 鐢熶骇璁㈠崟 like '%" + HICMOBillNo + "%'"; + } + if (HMaterNumber) { + sWhere += " and 鐗╂枡浠g爜 like '%" + HMaterNumber + "%'"; + } + if (HMaterName) { + sWhere += " and 鐗╂枡鍚嶇О like '%" + HMaterName + "%'"; + } + if (HSoureName) { + sWhere += " and 鐢熶骇璧勬簮 like '%" + HSoureName + "%'"; + } + if (HMouldNumber) { + sWhere += " and 妯″叿缂栫爜 like '%" + HMouldNumber + "%'"; + } + if (HMouldName) { + sWhere += " and 妯″叿鍚嶇О like '%" + HMouldName + "%'"; + } + if (HDate) { + sWhere += " and 鏃ユ湡 = '" + HDate + "'"; + } + get_Display(sWhere); + sWhere = "";//璋冪敤鎺ュ彛鍚庢竻绌簊Where缂撳瓨 + + } + //閲嶇疆蹇�熸煡璇� + function set_ClearQuery() { + $("#HDeptName").val();//閮ㄩ棬 + $("#HICMOBillNo").val();//鐢熶骇璁㈠崟 + $("#HMaterNumber").val();//鐗╂枡浠g爜 + $("#HMaterName").val();//鐗╂枡鍚嶇О + $("#HSoureName").val();//鐢熶骇璧勬簮 + $("#HMouldNumber").val();//妯″叿缂栫爜 + $("#HMouldName").val();//妯″叿 + $("#HDate").val(Format(new Date, "yyyy-MM-dd")); + + $("#btnSearch").click(); + $("#ColContent").val(""); + $("#ColName").val("0"); + $("#Comparator").val("0"); + $("#ColContent2").val(""); + $("#ColName2").val("0"); + $("#Comparator2").val("0"); + $("#ColContent1").val(""); + $("#ColName1").val("0"); + $("#Comparator1").val("0"); + form.render('select'); + + sWhere = ""; + } + //鍒锋柊 + function get_Refresh() { + $("#btnSearch").trigger('click'); + } + + //鐢熶骇杞﹂棿 + function DeptName() { + //鑾峰彇杞﹂棿鍒� + var HDeptName = '<option value="" style="color:red;" selected>鍏ㄩ儴閮ㄩ棬</option>'; + $.ajax({ + type: "get", + url: GetWEBURL() + "/Sc_ICMOBill/GetHDeptList", + async: false, + data: { "HOrgID": sessionStorage["OrganizationID"] }, + success: function (result) { + if (result.count == 1) { // 璇存槑楠岃瘉鎴愬姛浜嗭紝 + var data = result.data; + for (var i = 0; i < data.length; i++) { + if (i == 0) + HDeptName += '<option style="color:blue;" value="' + data[i].HItemID + '" >' + data[i].HName + '</option>'; + else + HDeptName += '<option style="color:blue;" value="' + data[i].HItemID + '">' + data[i].HName + '</option>'; + + } + $("#HDeptName").append(HDeptName); + form.render('select'); + } + layer.closeAll("loading"); + } + }) + } + + //#region 瀵煎嚭Execel + function get_Export() { + var ModRightNameCheck = "Gy_ProjectMoney_ExportExcel"; + + //閫昏緫瀹℃牳鏂规硶 + $.ajax({ + type: "GET", + url: GetWEBURL() + "/LMES/getReportByModRightNameCheck", //鏂规硶鎵�鍦ㄩ〉闈㈠拰鏂规硶鍚� + data: { "ModRightNameCheck": ModRightNameCheck, "user": sessionStorage["HUserName"] }, + success: function (result) { + if (result.count == 1) { + table.exportFile(ins.config.id, option.data, "xls"); + } else { + layer.alert("褰撳墠妯″潡娌℃湁瀵煎嚭鏉冮檺!", { icon: 5 }); + } + }, error: function () { + layer.alert("鎺ュ彛璇锋眰澶辫触!", { icon: 5 }); + } + }); + } + //#endregion + + //鐢熶骇璁㈠崟寮圭獥 + form.on('submit(btnHICMOBillNo)', function () { + //椤甸潰灞�-鑷畾涔� + layer.open({ + type: 2, + skin: 'layui-layer-rim', //鍔犱笂杈规 + title: '鐢熶骇璁㈠崟鍒楄〃', + closeBtn: 1, + shift: 2, + area: ['90%', '90%'], + maxmin: true, + content: ['../../../views/鐢熶骇绠$悊/鐢熶骇浠诲姟鍗�/Sc_ICMOBillList.html', 'yes'], + btn: ['纭畾', '鍙栨秷'] + , btn1: function (index, layero) { + + //鎸夐挳銆愭寜閽竴銆戠殑鍥炶皟 + var iframeWindow = window['layui-layer-iframe' + index] //鑾峰彇寮规椤甸潰 + var checkStatus = iframeWindow.layui.table.checkStatus('mainTable');//鑾峰彇table鐨別lem:"#test" + if (checkStatus.data.length === 0) { + return layer.msg('璇烽�夋嫨鏁版嵁'); + } + $("#HICMOBillNo").val(checkStatus.data[0].鍗曟嵁鍙�); + layer.close(layer.index); //瀹冭幏鍙栫殑濮嬬粓鏄渶鏂板脊鍑虹殑鏌愪釜灞傦紝鍊兼槸鐢眑ayer鍐呴儴鍔ㄦ�侀�掑璁$畻鐨� + get_EquipList(); + } + , btn2: function (index, layero) { + //鎸夐挳銆愭寜閽簩銆戠殑鍥炶皟 + //return false 寮�鍚浠g爜鍙姝㈢偣鍑昏鎸夐挳鍏抽棴 + }, + end: function () { + + }, + success: function (layero, index) { + + } + }); + }); + + //宸ュ簭 + form.on('submit(btnHProc)', function () { + //椤甸潰灞�-鑷畾涔� + layer.open({ + type: 2, + skin: 'layui-layer-rim', //鍔犱笂杈规 + title: '宸ュ簭鍒楄〃', + closeBtn: 1, + shift: 2, + area: ['90%', '90%'], + maxmin: true, + content: ['../../鍩虹璧勬枡/鐢熶骇鍩虹璧勬枡/Gy_Process.html', 'yes'], + btn: ['纭畾', '鍙栨秷'] + , btn1: function (index, layero) { + + //鎸夐挳銆愭寜閽竴銆戠殑鍥炶皟 + var iframeWindow = window['layui-layer-iframe' + index] //鑾峰彇寮规椤甸潰 + var checkStatus = iframeWindow.layui.table.checkStatus('mainTable');//鑾峰彇table鐨別lem:"#test" + if (checkStatus.data.length === 0) { + return layer.msg('璇烽�夋嫨鏁版嵁'); + } + $("#HProcName").val(checkStatus.data[0].宸ュ簭鍚嶇О); + layer.close(layer.index); //瀹冭幏鍙栫殑濮嬬粓鏄渶鏂板脊鍑虹殑鏌愪釜灞傦紝鍊兼槸鐢眑ayer鍐呴儴鍔ㄦ�侀�掑璁$畻鐨� + } + , btn2: function (index, layero) { + //鎸夐挳銆愭寜閽簩銆戠殑鍥炶皟 + //return false 寮�鍚浠g爜鍙姝㈢偣鍑昏鎸夐挳鍏抽棴 + }, + end: function () { + + }, + success: function (layero, index) { + + } + }); + }); + + //宸ヨ壓鍙傛暟 + form.on('submit(btnHTechParam)', function () { + //椤甸潰灞�-鑷畾涔� + layer.open({ + type: 2, + skin: 'layui-layer-rim', //鍔犱笂杈规 + title: '宸ュ簭鍒楄〃', + closeBtn: 1, + shift: 2, + area: ['90%', '90%'], + maxmin: true, + content: ['../../../views/鍩虹璧勬枡/鍏敤鍩虹璧勬枡/Gy_TechnologyParameterList.html', 'yes'], + btn: ['纭畾', '鍙栨秷'] + , btn1: function (index, layero) { + + //鎸夐挳銆愭寜閽竴銆戠殑鍥炶皟 + var iframeWindow = window['layui-layer-iframe' + index] //鑾峰彇寮规椤甸潰 + var checkStatus = iframeWindow.layui.table.checkStatus('mainTable');//鑾峰彇table鐨別lem:"#test" + if (checkStatus.data.length === 0) { + return layer.msg('璇烽�夋嫨鏁版嵁'); + } + $("#HTechParamName").val(checkStatus.data[0].宸ヨ壓鍙傛暟鍚嶇О); + layer.close(layer.index); //瀹冭幏鍙栫殑濮嬬粓鏄渶鏂板脊鍑虹殑鏌愪釜灞傦紝鍊兼槸鐢眑ayer鍐呴儴鍔ㄦ�侀�掑璁$畻鐨� + } + , btn2: function (index, layero) { + //鎸夐挳銆愭寜閽簩銆戠殑鍥炶皟 + //return false 寮�鍚浠g爜鍙姝㈢偣鍑昏鎸夐挳鍏抽棴 + }, + end: function () { + + }, + success: function (layero, index) { + + } + }); + }); + + //#region 闅愯棌鍒楄缃� + function get_HideColumn() { + var colName = ""; + var contentUrl = ""; + for (var i = 1; i < option.cols[0].length; i++) { + colName += option.cols[0][i]["title"] + ","; + } + var urlStr = window.document.location.pathname;//鑾峰彇鏂囦欢璺緞 + var urlLen = urlStr.split('/'); + for (var i = 0; i < urlLen.length - 4; i++) { + contentUrl += "../"; + } + colName = encodeURI(colName.substring(0, colName.length - 1));//瀵� URI 杩涜缂栫爜 + + contentUrl += '鍩虹璧勬枡/闅愯棌鍒楄缃�/Gy_GridView_Hide.html?HModName=' + HModName + '&colName=' + colName; + + layer.open({ + type: 2 + , skin: "layui-layer-rim" //鍔犱笂杈规 + , title: "闅愯棌鍒楄缃�" //鏍囬 + , closeBtn: 1 //绐椾綋鍙充笂瑙掑叧闂� 鐨� 鏍峰紡 + , shift: 2 //寮瑰嚭鍔ㄧ敾 + , area: ["50%", "90%"] //绐椾綋澶у皬 + , maxmin: true //璁剧疆鏈�澶ф渶灏忔寜閽槸鍚︽樉绀� + , content: [contentUrl, "yes"] + , btn: ["纭畾", "鍙栨秷"] + , btn1: function (index, laero) { + //鍒锋柊琛ㄦ牸鏁版嵁 + DisPlay_HideColumn(); + //鏇存柊琛ㄦ牸缂撳瓨鐨勬暟鎹� + layer.close(index);//鍏抽棴寮圭獥 + } + }) + } + //#endregion + + //#region 鏄剧ず鍒楁暟鎹� + function DisPlay_HideColumn() { + $.ajax({ + url: GetWEBURL() + '/Xt_grdAlignment_WMES/grdAlignmentWMESList', + type: "GET", + async: false, + data: { "HModName": HModName, "user": sessionStorage["HUserName"] }, + success: function (data1) { + if (data1.data.length != 0) { + + var dataCol = [];//鏁版嵁搴撴煡璇㈠嚭鐨勫垪鏁版嵁 + //var titleData = ["鍗曟嵁ID", "HMouldID", "hsubid", "HManagerID", "婧愬崟涓诲唴鐮�", "婧愬崟瀛愬唴鐮�"];//涓嶉渶瑕佹樉绀虹殑瀛楁 鍙墿灞� + + dataCol = data1.data[0].HGridString.split(','); + + for (var i = 0; i < option.cols[0].length - 1; i++) { + var dataCols = dataCol[i].split('|'); + //闅愯棌鍒� + if (dataCols[1] == 1) { + option.cols[0][i + 1]["hide"] = true; + } + //璁剧疆鍒楀 + if (dataCols[3] > 0) { + option.cols[0][i + 1]["width"] = dataCols[3]; + } + //璁剧疆鍐呭瀛椾綋澶у皬 + if (data1.data[0].HFontSize != 0) { + option.cols[0][i + 1]["style"] = "font-size:" + data1.data[0].HFontSize + "px;"; + } else { + option.cols[0][i + 1]["style"] = "font-size:100%"; + } + //璁剧疆鍒楀 + //if (data1.data[0].HColumnWidth != 0) { + // option.cols[0][i + 1]["width"] = data1.data[0].HColumnWidth + "px;"; + //} else { + // option.cols[0][i + 1]["width"] = ""; + //} + //鏄剧ず鍒� + if (dataCols[1] == 0 && $.inArray(option.cols[0][i + 1]["title"], titleData) == -1) { + option.cols[0][i + 1]["hide"] = false; + } + //瀛椾綋鎵�鍦ㄤ綅缃�(宸� 灞呬腑 鍙�) + switch (dataCols[2]) { + case "L": + option.cols[0][i + 1]["align"] = "left"; + break; + case "M": + option.cols[0][i + 1]["align"] = "center"; + break; + case "R": + option.cols[0][i + 1]["align"] = "right"; + break; + } + } + + //鍙栨秷鍐荤粨鍒� + for (var i = 1; i < option.cols[0].length - 1; i++) { + if (option.cols[0][i]["fixed"] != null) { + option.cols[0][i]["fixed"] = null; + } + else { + break; + } + } + //鍐荤粨鍒� + if (data1.data[0].HFixCols != 0) { + for (var i = 0; i < data1.data[0].HFixCols; i++) { + if ($.inArray(option.cols[0][i + 1]["title"], titleData) != -1) { + data1.data[0].HFixCols += 1; + } + option.cols[0][i + 1]["fixed"] = "left"; + } + } + table.render(option); + } else { + table.render(option); + } + }, error: function () { + layer.alert("鎺ュ彛璇锋眰澶辫触!", { icon: 5 }); + } + }) + } + //#endregion + + //#region 鍒楁槑鏄剧ず涓嬫媺妗� + 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); + $("#ColName1").empty(); + $("#ColName1").append(Organization); + $("#ColName2").empty(); + $("#ColName2").append(Organization); + form.render('select'); + } + //#endregion + + //浠ヤ笂鏄痩ayui妯″潡 + }); + </script> + +</body> +</html> \ No newline at end of file -- Gitblit v1.9.1