| | |
| | | <input type="text" class="layui-input" value="" name="ColContent" id="ColContent"> |
| | | </div> |
| | | </div> |
| | | <div class="layui-row" style=" margin-top: 10px; margin-left: 70px;"> |
| | | <div class="layui-inline"> |
| | | <label class="layui-form-label">è¿æ»¤</label> |
| | | <div class="layui-input-block"> |
| | | <select name="ColName1" id="ColName1" class="ForFilteringSchemes" lay-filter="ColName1" style="width:190px;"> |
| | | </select> |
| | | </div> |
| | | </div> |
| | | <div class="layui-inline"> |
| | | <select name="Comparator1" id="Comparator1" class="ForFilteringSchemes" 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 ForFilteringSchemes" value="" name="ColContent1" id="ColContent1"> |
| | | </div> |
| | | </div> |
| | | |
| | | <div class="layui-row" style=" margin-top: 10px; margin-left: 70px;"> |
| | | <div class="layui-inline"> |
| | | <label class="layui-form-label">è¿æ»¤</label> |
| | | <div class="layui-input-block"> |
| | | <select name="ColName2" id="ColName2" class="ForFilteringSchemes" lay-filter="ColName2" style="width:190px;"> |
| | | </select> |
| | | </div> |
| | | </div> |
| | | <div class="layui-inline"> |
| | | <select name="Comparator2" id="Comparator2" class="ForFilteringSchemes" 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 ForFilteringSchemes" value="" name="ColContent2" id="ColContent2"> |
| | | </div> |
| | | </div> |
| | | </div> |
| | | </div> |
| | | </div> |
| | |
| | | <script type="text/html" id="toolbarDemo"> |
| | | <div class="layui-btn-container"> |
| | | <!--<button type="button" class="layui-btn layui-btn-sm" lay-event="set_BatchFill"><i class="layui-icon layui-icon-file-b"></i>æ¹éå¡«å
</button> |
| | | <button type="button" class="layui-btn layui-btn-sm" lay-event="set_ShowBill"><i class="layui-icon layui-icon-form"></i>ç¼è¾</button>--> |
| | | <button type="button" class="layui-btn layui-btn-sm" lay-event="set_ShowBill"><i class="layui-icon layui-icon-form"></i>ç¼è¾</button>--> |
| | | <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-CopyLine"><i class="layui-icon layui-icon-form"></i>å¤å¶è¡</button> |
| | | <button type="button" class="layui-btn layui-btn-sm" lay-event="set_DeleteBill"><i class="layui-icon layui-icon-delete"></i>å é¤è¡</button> |
| | | <button type="button" class="layui-btn layui-btn-sm" lay-event="set_MoverUp"><i class="layui-icon layui-icon-delete"></i>ä¸ç§»</button> |
| | |
| | | <button type="button" class="layui-btn layui-btn-sm" lay-event="set_Priority"><i class="layui-icon layui-icon-delete"></i>ä¼å
级</button> |
| | | <button type="button" class="layui-btn layui-btn-sm" lay-event="set_ReadyAsc"><i class="layui-icon layui-icon-delete"></i>å夿åº</button> |
| | | <button type="button" class="layui-btn layui-btn-sm" lay-event="set_Souce"><i class="layui-icon layui-icon-delete"></i>é产线</button> |
| | | <button type="button" class="layui-btn layui-btn-sm" lay-event="set_Emp"><i class="layui-icon layui-icon-delete"></i>éæä½å·¥</button> |
| | | <button type="button" class="layui-btn layui-btn-sm" lay-event="set_HideColumn"><i class="layui-icon layui-icon-form"></i>å设置</button> |
| | | <button type="button" class="layui-btn layui-btn-sm" lay-event="set_Routing"><i class="layui-icon layui-icon-form"></i>å·¥èºè·¯çº¿</button> |
| | | <button type="button" class="layui-btn layui-btn-sm" lay-event="set_Calendar"><i class="layui-icon layui-icon-form"></i>工忥å</button> |
| | |
| | | </script> |
| | | <script> |
| | | var OptionData = []; |
| | | var OptionData_Emp = []; |
| | | layui.config({ |
| | | base: '../../../layuiadmin/' //éæèµæºæå¨è·¯å¾ |
| | | }).extend({ |
| | |
| | | case 'set_Souce': |
| | | set_Souce(data); |
| | | break; |
| | | //éæä½å·¥ |
| | | case 'set_Emp': |
| | | set_Emp(data); |
| | | break; |
| | | //æ¥çå·¥èºè·¯çº¿ |
| | | case 'set_Routing': |
| | | set_Routing(); |
| | |
| | | columns.push({ field: 'åæ®å·', title: 'åæ®å·', hide: true, sort: true }); |
| | | columns.push({ field: 'éå®è®¢åå·', title: 'éå®è®¢åå·', width: 150, sort: true }); |
| | | columns.push({ field: 'ç产订åå·', title: 'ç产订åå·', width: 150, style: 'background-color: #f9f9f9;', sort: true }); |
| | | columns.push({ field: 'ç产订åæç»è¡å·', title: 'ç产订åæç»è¡å·', width: 150, sort: true }); |
| | | columns.push({ field: 'ç产ç»ç»', title: 'ç产ç»ç»', width: 150, sort: true }); |
| | | columns.push({ field: 'ç©æä»£ç ', title: 'ç©æç¼ç ', width: 150, sort: true }); |
| | | columns.push({ field: 'ç©æåç§°', title: 'ç©æåç§°', width: 150, sort: true }); |
| | |
| | | columns.push({ field: 'æ¨æ¥æ°é', title: 'æ¨æ¥æ°é' }); |
| | | columns.push({ field: 'ä¼å
级', title: 'ä¼å
级', width: 150, edit: 'text', sort: true }); |
| | | columns.push({ field: 'çäº§èµæº', title: 'çäº§èµæº', width: 150, edit: 'text', event: "HSourceID" }); |
| | | columns.push({ field: 'æä½å·¥', title: 'æä½å·¥', width: 150, edit: 'text', event: "HEmpID" }); |
| | | |
| | | columns.push({ |
| | | field: Format(myDate.getTime() + 0 * oneday, 'yyyy-MM-dd'), title: Format(myDate.getTime() + 0 * oneday, 'MM.dd'), edit: 'text', width: 70, templet: function (d) { |
| | |
| | | return DayColor(d[Format(myDate.getTime() + 30 * oneday, 'yyyy/MM/dd')], d[Format(myDate.getTime() + 30 * oneday, 'yyyy-MM-dd')], d, Format(myDate.getTime() + 30 * oneday, 'yyyy-MM-dd')); |
| | | } |
| | | })//0 |
| | | |
| | | columns.push({ field: 'ç产订åæç»è¡å·', title: 'ç产订åæç»è¡å·', width: 150, sort: true }); |
| | | columns.push({ field: 'T31', title: 'T31', width: 70 });//0 |
| | | columns.push({ field: '订åç±»å', title: '订åç±»å', width: 150, sort: true }); |
| | | columns.push({ field: 'ç产订ååæ®ç±»å', title: 'æºå订ååæ®ç±»å', width: 150, sort: true }); |
| | |
| | | columns.push({ field: 'HWorkShopID', title: 'HWorkShopID', hide: true }); |
| | | columns.push({ field: 'HUnitID', title: 'HUnitID', hide: true }); |
| | | columns.push({ field: 'HProdORGID', title: 'HProdORGID', hide: true }); |
| | | columns.push({ field: 'HEmpID', title: 'HEmpID', hide: true }); |
| | | columns.push({ field: 'æåæ±æ¥æ°é', title: 'æåæ±æ¥æ°é', width: 150, edit: 'text', sort: true }); |
| | | columns.push({ fixed: 'right', title: 'æä½', toolbar: '#barDemo' }); |
| | | option_columns = columns; |
| | |
| | | sWhere = { |
| | | HORGID: sessionStorage["OrganizationID"] |
| | | , HBEGINDATE: field |
| | | , HENDDATE: field |
| | | , HENDDATE: field |
| | | } |
| | | get_Display_3(JSON.stringify(sWhere)); |
| | | }); |
| | |
| | | // } |
| | | // } |
| | | // } |
| | | //}) |
| | | //}) |
| | | } |
| | | } |
| | | } |
| | | |
| | | |
| | | //缺æåæè¡¨æ ¼æ°æ® |
| | | function set_InitGrid1(field) { |
| | | var columns = []; |
| | | var columns = []; |
| | | columns.push({ field: 'HOrgName', title: 'éè´ç»ç»', sort: true }); |
| | | columns.push({ field: 'FNUMBER', title: 'ç©æç¼ç ', sort: true }); |
| | | columns.push({ field: 'HMaterName', title: 'ç©æåç§°', sort: true }); |
| | |
| | | columns.push({ field: 'CountHQty', title: 'å计', sort: true }); |
| | | columns.push({ field: 'FBASEQTY', title: '峿¶åºåæ°é', sort: true, totalRow: true }); |
| | | columns.push({ field: Format(field, 'yyyy-MM-dd'), title: Format(field, 'MM.dd'), width: 70 }) |
| | | |
| | | |
| | | option_columns = columns; |
| | | option3 = { |
| | | elem: '#mainTable_Material' |
| | |
| | | , limit: Number.MAX_VALUE//é»è®¤æ¾ç¤ºå
¨é¨ |
| | | , done: function (res, page, count) { |
| | | soulTable.render(this); |
| | | |
| | | |
| | | } |
| | | }; |
| | | } |
| | |
| | | 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(); |
| | | var sWheres = ""; |
| | | |
| | | if (ColName != 0 && Comparator != 0) { |
| | |
| | | sWheres += " 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; |
| | | } |
| | | sWhere = { |
| | | HPlanBeginDate: HPlanBeginDate |
| | | , HProdORGID: HProdORGID |
| | |
| | | $("#ColContent").val(""); |
| | | $("#ColName").val("0"); |
| | | $("#Comparator").val("0"); |
| | | $("#ColContent1").val(""); |
| | | $("#ColName1").val("0"); |
| | | $("#Comparator1").val("0"); |
| | | $("#ColContent2").val(""); |
| | | $("#ColName2").val("0"); |
| | | $("#Comparator2").val("0"); |
| | | form.render('select'); |
| | | sWhere = ""; |
| | | } |
| | |
| | | } |
| | | if (isNaN(data[i]["HSourceID"])) { |
| | | return layer.msg("éæ©çäº§èµæº!!") |
| | | } |
| | | } |
| | | HICOMNum.push(data[i]["HICMOInterID"] + ";" + data[i]["HICMOEntryID"] + ";" + data[i]["HSourceID"]); |
| | | } |
| | | |
| | | |
| | | $('#HProgressBar').html(` |
| | | <div class="layui-progress" lay-filter="demo-filter-progress"> |
| | | <div class="layui-progress-bar" lay-percent="40%"></div> |
| | |
| | | return layer.alert("第" + (i + 1) + 'è¡ï¼å°æ¶äº§è½æªè®¾ç½®ï¼è¯·æ ¸å¯¹æ°æ®ã' + '</br>' + '1.ç©ææªæ·»å å·¥èºè·¯çº¿' + '</br>' + '2.å·¥èºè·¯çº¿ä¸æªè®¾ç½®å°æ¶äº§è½' + '</br>' + '3.çäº§èµæºæªè®¾ç½®åçå·¥æ¶' + '</br>' + '4.çäº§èµæºä¸ç»å®å·¥ä½ä¸å¿ä¸å·¥èºè·¯çº¿ä¸è®¾ç½®çå·¥ä½ä¸å¿ä¸ä¸è´'); |
| | | } |
| | | } |
| | | |
| | | |
| | | } else { |
| | | //layer.close(ajaxLoad); |
| | | layer.alert(data1.code + data1.Message, { icon: 5 }); |
| | |
| | | return layer.msg("è¯·éæ©æ°æ®!") |
| | | } |
| | | } |
| | | |
| | | //éæä½å·¥ |
| | | function set_Emp(data) { |
| | | if (data != 0) { |
| | | layer.open({ |
| | | type: 2 |
| | | , skin: "layui-layer-rim" //å ä¸è¾¹æ¡ |
| | | , title: "èåå表" //æ é¢ |
| | | , closeBtn: 1 //çªä½å³ä¸è§å
³é ç æ ·å¼ |
| | | , shift: 2 //å¼¹åºå¨ç» |
| | | , area: ["90%", "90%"] //çªä½å¤§å° |
| | | , maxmin: true //设置æå¤§æå°æé®æ¯å¦æ¾ç¤º |
| | | , content: ["../../åºç¡èµæ/å
¬ç¨åºç¡èµæ/Gy_EmployeeList.html?Htype=HEmp", "yes"] |
| | | , btn: ["ç¡®å®", "åæ¶"] |
| | | , btn1: function (index, laero) { |
| | | //æé®ä¸ çåè° |
| | | var iframeWindow = window["layui-layer-iframe" + index];//è·åå¼¹æ¡é¡µé¢ |
| | | var checkStatus = iframeWindow.layui.table.checkStatus("mainTable");//è·åéä¸çæ°æ® |
| | | |
| | | if (checkStatus.data.length != 1) { |
| | | return layer.msg("è¯·éæ©ä¸æ¡æ°æ®"); |
| | | } |
| | | OptionData_Emp[0] = checkStatus.data[0]; |
| | | layer.close(index);//å
³éå¼¹çª |
| | | } |
| | | , end: function () { |
| | | if (OptionData_Emp.length > 0) { |
| | | var num = 0; |
| | | for (var i = 0; i < option.data.length; i++) { |
| | | if (num >= data.length) { |
| | | break; |
| | | } |
| | | if (option.data[i]["LAY_CHECKED"] == true) { |
| | | option.data[i]["HEmpID"] = OptionData_Emp[0].HItemID; |
| | | option.data[i]["æä½å·¥"] = OptionData_Emp[0].èååç§°; |
| | | num += 1; |
| | | } |
| | | } |
| | | table.render(option); |
| | | } |
| | | } |
| | | }) |
| | | } |
| | | else { |
| | | return layer.msg("è¯·éæ©æ°æ®!") |
| | | } |
| | | } |
| | | |
| | | //ä¿å |
| | | function set_AddNew() { |
| | | |
| | | //å é¤åè¡¨æ°æ® ä¼å ç¨æ°ç»çä½ç½®,éè¦éæ°æä¸ä¸é¡ºåº |
| | | var num = []; |
| | | var num = []; |
| | | for (var i = 0; i < table.cache["mainTable"].length; i++) { |
| | | if (table.cache["mainTable"][i] != "") { |
| | | if (parseFloat(table.cache["mainTable"][i]["æåæ°é"]) == 0) { |
| | |
| | | table.cache["mainTable"][i].LAY_TABLE_INDEX = i; |
| | | num.push(table.cache["mainTable"][i]) |
| | | } |
| | | } |
| | | } |
| | | |
| | | //var sMainStr = JSON.stringify(data.field); |
| | | var sSubStr = JSON.stringify(num); |
| | |
| | | } |
| | | }) |
| | | } |
| | | |
| | | //æä½å·¥ |
| | | if (obj.event == "HEmpID") { |
| | | layer.open({ |
| | | type: 2 |
| | | , skin: "layui-layer-rim" //å ä¸è¾¹æ¡ |
| | | , title: "åå·¥å表" //æ é¢ |
| | | , closeBtn: 1 //çªä½å³ä¸è§å
³é ç æ ·å¼ |
| | | , shift: 2 //å¼¹åºå¨ç» |
| | | , area: ["90%", "90%"] //çªä½å¤§å° |
| | | , maxmin: true //设置æå¤§æå°æé®æ¯å¦æ¾ç¤º |
| | | , content: ["../../åºç¡èµæ/å
¬ç¨åºç¡èµæ/Gy_EmployeeList.html?Htype=HEmp", "yes"] |
| | | , btn: ["ç¡®å®", "åæ¶"] |
| | | , btn1: function (index, laero) { |
| | | //æé®ä¸ çåè° |
| | | var iframeWindow = window["layui-layer-iframe" + index];//è·åå¼¹æ¡é¡µé¢ |
| | | var checkStatus = iframeWindow.layui.table.checkStatus("mainTable");//è·åéä¸çæ°æ® |
| | | |
| | | if (checkStatus.data.length != 1) { |
| | | return layer.msg("è¯·éæ©ä¸æ¡æ°æ®"); |
| | | } |
| | | OptionData_Emp[0] = checkStatus.data[0]; |
| | | //æ´æ°è¡¨æ ¼ç¼åçæ°æ® |
| | | obj.update({ |
| | | "HEmpID": checkStatus.data[0].HItemID |
| | | , "æä½å·¥": checkStatus.data[0].èååç§° |
| | | }) |
| | | layer.close(index);//å
³éå¼¹çª |
| | | } |
| | | , end: function () { |
| | | if (OptionData_Emp.length > 0) { |
| | | obj.update({ |
| | | "HEmpID": OptionData_Emp[0].HItemID |
| | | , "æä½å·¥": OptionData_Emp[0].èååç§° |
| | | }) |
| | | OptionData_Emp = []; |
| | | } |
| | | } |
| | | }) |
| | | } |
| | | |
| | | obj.event = ""; |
| | | return false; |
| | | } else if (event.key == "F8") { |
| | |
| | | , data: data1.data |
| | | , height: 400 |
| | | , page: true |
| | | , limits: [200, 500, 5000, 50000] |
| | | , limits: [200, 500, 5000, 20000] |
| | | , limit: 200 |
| | | , cellMinWidth: 90 |
| | | } |
| | |
| | | item.è§æ ¼åå· = item.è§æ ¼åå·.replace(/[,]+/g, 'ï¼'); // å°æ¢åå·æ¿æ¢ä¸ºç©ºå符串 |
| | | } |
| | | }); |
| | | table.exportFile(ins.config.id, data, "xls"); |
| | | table.exportFile(ins.config.id, data, "xls"); |
| | | } |
| | | |
| | | //æäº§åè½ |
| | |
| | | dataCol = data1.data[0].HGridString.split(','); |
| | | |
| | | for (var i = 0; i < option.cols[0].length - 2; i++) { |
| | | var dataCols = dataCol[i].split('|'); |
| | | if (dataCol[i]) { |
| | | var dataCols = dataCol[i].split('|'); |
| | | } |
| | | //éèå |
| | | if (dataCols[1] == 1) { |
| | | option.cols[0][i + 1]["hide"] = true; |
| | |
| | | |
| | | |
| | | var dataCol = [];//æ°æ®åºæ¥è¯¢åºçåæ°æ® |
| | | |
| | | |
| | | dataCol = data1.data[0].HGridString.split(','); |
| | | |
| | | for (var i = 0; i < option3.cols[0].length - 1; i++) { |
| | |
| | | } else { |
| | | option3.cols[0][i + 1]["style"] = "font-size:100%"; |
| | | } |
| | | |
| | | |
| | | //å使å¨ä½ç½®(å·¦ å±
ä¸ å³) |
| | | switch (dataCols[2]) { |
| | | case "L": |
| | |
| | | else { |
| | | break; |
| | | } |
| | | } |
| | | } |
| | | table.render(option3); |
| | | } else { |
| | | table.render(option3); |
| | |
| | | } |
| | | } |
| | | $("#ColName").empty(); |
| | | $("#ColName").append(Organization); |
| | | $("#ColName").append(Organization);$("#ColName1").empty(); |
| | | $("#ColName1").append(Organization);$("#ColName2").empty(); |
| | | $("#ColName2").append(Organization); |
| | | form.render('select'); |
| | | } |
| | | //#endregion |
| | |
| | | OptionData = data |
| | | } |
| | | |
| | | //åå»è¿åæä½å·¥ |
| | | function GetHEmpValue(data) { |
| | | OptionData_Emp = data |
| | | } |
| | | |
| | | </script> |