| | |
| | | <button class="layui-btn layui-btn-normal" style="margin-left: 0px" type="button" lay-submit="" lay-filter="btnUnlock" id="btnUnlock">è§£é</button> |
| | | <button class="layui-btn layui-btn-normal" style="margin-left: 0px" type="button" lay-submit="" lay-filter="btnCompleteSetAnalysis" id="btnCompleteSetAnalysis">é½å¥åæ</button> |
| | | <button class="layui-btn layui-btn-normal" style="margin-left: 0px" type="button" lay-submit="" lay-filter="btnTLYS" id="btnTLYS">ææè¿ç®</button> |
| | | <button class="layui-btn layui-btn-normal" style="margin-left: 0px" type="button" lay-submit="" lay-filter="btnYLYS" id="btnYLYS">è¦æè¿ç®</button> |
| | | <button class="layui-btn layui-btn-normal" style="margin-left: 0px" type="button" lay-submit="" lay-filter="btnICMOBill" id="btnICMOBill">ç产订åéå</button> |
| | | <button class="layui-btn layui-btn-normal" style="margin-left: 0px" type="button" lay-submit="" lay-filter="btnReady" id="btnReady">åå¤</button> |
| | | <button class="layui-btn layui-btn-normal" style="margin-left: 0px" type="button" lay-submit="" lay-filter="btnProPC" id="btnProPC">æäº§</button> |
| | | <button class="layui-btn layui-btn-normal" style="margin-left: 0px" type="button" lay-submit="" lay-filter="btnRoutEdit" id="btnRoutEdit">å·¥èºè·¯çº¿</button> |
| | | <button class="layui-btn layui-btn-normal" style="margin-left: 0px" type="button" lay-submit="" lay-filter="btnLockOrder" id="btnLockOrder">éå®å·¥å</button> |
| | | <button class="layui-btn layui-btn-normal" style="margin-left: 0px" type="button" lay-submit="" lay-filter="btnUnlockOrder" id="btnUnlockOrder">è§£éå·¥å</button> |
| | | </div> |
| | | <div class="layui-collapse resizable-container"> |
| | | <div class="layui-colla-item"> |
| | |
| | | get_btnTLYS(); |
| | | }) |
| | | |
| | | //è¦æè¿ç® |
| | | form.on('submit(btnYLYS)', function (data) { |
| | | get_btnYLYS(); |
| | | }) |
| | | |
| | | //ç产订åéå |
| | | form.on('submit(btnICMOBill)', function (data) { |
| | | get_btnICMOBill(); |
| | |
| | | } |
| | | }) |
| | | |
| | | //éå®å·¥å |
| | | form.on('submit(btnLockOrder)', function (data) { |
| | | get_btnLockOrder(); |
| | | }) |
| | | |
| | | //è§£éå·¥å |
| | | form.on('submit(btnUnlockOrder)', function (data) { |
| | | get_btnUnlockOrder(); |
| | | }) |
| | | |
| | | //#endregion |
| | | |
| | | //#region æ¬é¡µé¢è¢«è°ç¨çæææ¹æ³ |
| | |
| | | //åå§åè¡¨æ ¼ |
| | | set_InitGrid(); |
| | | get_FastQuery(1); |
| | | get_FastQuery_ICMO();//æ¥è¯¢å¸¦æäº§è®¢å |
| | | //éèå¾éåæ®µ |
| | | DisPlay_HideColumn(); |
| | | get_Display2(sWhere_ICMO); |
| | | |
| | | } |
| | | //#endregion |
| | | |
| | |
| | | var oneday = 1000 * 60 * 60 * 24; |
| | | |
| | | columns.push({ type: 'checkbox', fixed: 'left', sort: true }); |
| | | columns.push({ type: 'numbers', title: 'åºå·', sort: true }); |
| | | columns.push({ type: 'numbers', field: 'åºå·', title: 'åºå·', sort: true }); |
| | | 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: 'æ¨æ¥æ°é' }); |
| | | 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: '使ç¨å·¥è£
', title: '使ç¨å·¥è£
', width: 150 }); |
| | | 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() + 0 * oneday, 'yyyy/MM/dd')], d[Format(myDate.getTime() + 0 * oneday, 'yyyy-MM-dd')], d, Format(myDate.getTime() + 0 * oneday, 'yyyy-MM-dd')); |
| | |
| | | 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({ field: 'éå®å·¥å', title: 'éå®å·¥å', width: 150, sort: true, filter: true });//0 |
| | | columns.push({ field: 'HMouldID', title: 'HMouldID', width: 150, hide: true }); |
| | | columns.push({ field: 'æä½å·¥', title: 'æä½å·¥', width: 150, edit: 'text', event: "HEmpID" }); |
| | | columns.push({ fixed: 'right', title: 'æä½', toolbar: '#barDemo' }); |
| | | option_columns = columns; |
| | | option = { |
| | | elem: '#mainTable' |
| | | , toolbar: '#toolbarDemo' |
| | | , height: 'full-120' |
| | | , height: 600 |
| | | , page: false |
| | | , cellMinWidth: 90 |
| | | , cols: [columns] |
| | |
| | | soulTable.render(this); |
| | | $('.layui-table thead').on('click', 'th', function () { |
| | | // è·åç¹å»ç表头ç field å¼ |
| | | var field = $(this).data('field'); |
| | | set_InitGrid1(field); |
| | | sWhere = { |
| | | HORGID: sessionStorage["OrganizationID"] |
| | | , HBEGINDATE: field |
| | | , HENDDATE: field |
| | | } |
| | | get_Display_3(JSON.stringify(sWhere)); |
| | | var field = $(this).data('field'); |
| | | if (isDateField(field)) { |
| | | set_InitGrid1(field); |
| | | sWhere = { |
| | | HORGID: sessionStorage["OrganizationID"], |
| | | HBEGINDATE: field, |
| | | HENDDATE: field |
| | | }; |
| | | get_Display_3(JSON.stringify(sWhere)); |
| | | } |
| | | }); |
| | | //res.data.forEach(function (item, index) { |
| | | // if (data1.data.DataColor != undefined) { |
| | |
| | | , area: ['90%', '90%']//å¤§å° |
| | | , title: 'ç产车é´å表'//æ é¢ |
| | | , shift: 2//å¼¹åºå¨ç» |
| | | , content: ['../../åºç¡èµæ/å
¬ç¨åºç¡èµæ/Gy_DepartmentList.html', 'yes'] |
| | | , content: ['../../åºç¡èµæ/å
¬ç¨åºç¡èµæ/Gy_DepartmentList.html?openType=2&HOrgName=' + sessionStorage["Organization"], 'yes'] |
| | | , btn: ['ç¡®å®', 'åæ¶'] |
| | | , btn1: function (index, layero) {//æé®ãæé®ä¸ãçåè° |
| | | var iframeWindow = window['layui-layer-iframe' + index] //è·åå¼¹æ¡é¡µé¢ |
| | |
| | | } |
| | | if (HICMOBillNo_ICMO) { |
| | | sWhere_ICMO += " and åæ®å· like '%" + HICMOBillNo_ICMO + "%'"; |
| | | } |
| | | } |
| | | sWhere_ICMO += " and ç产ç»ç» = '" + sessionStorage["Organization"] +"'"; |
| | | |
| | | sWhere_ICMO += " Order By æ¥æ desc"; |
| | | |
| | | get_Display2(sWhere_ICMO); |
| | | sWhere_ICMO = ""//è°ç¨æ¥å£åæ¸
空sWhereç¼å |
| | |
| | | }); |
| | | } |
| | | |
| | | //è¦æè¿ç® |
| | | function get_btnYLYS() { |
| | | sWhere = { |
| | | HProdORGID: $("#HProdORGID").val() |
| | | , HWorkShopID: $("#HWorkShopID").val() |
| | | } |
| | | sWhere = JSON.stringify(sWhere); |
| | | var ajaxLoad = layer.load(); |
| | | $.ajax({ |
| | | url: GetWEBURL() + '/JIT_DayPlanPlatFormBill/JIT_YLYS', |
| | | type: "GET", |
| | | data: { "sWhere": sWhere, "user": sessionStorage["HUserName"] }, |
| | | success: function (data1) { |
| | | if (data1.count == 1) { |
| | | get_FastQuery(2); |
| | | layer.msg(data1.Message); |
| | | layer.close(ajaxLoad); |
| | | } else { |
| | | layer.close(ajaxLoad); |
| | | layer.alert(data1.Message, { icon: 5 }); |
| | | } |
| | | }, error: function () { |
| | | layer.close(ajaxLoad); |
| | | layer.alert("æ¥å£è¯·æ±å¤±è´¥!", { icon: 5 }); |
| | | } |
| | | }); |
| | | } |
| | | |
| | | //ç产订åéå |
| | | function get_btnICMOBill() { |
| | | var HDeptID = $("#HWorkShopID").val() == "" ? 0 : $("#HWorkShopID").val(); |
| | |
| | | , area: ['90%', '90%']//å¤§å° |
| | | , title: 'ç产订åå表'//æ é¢ |
| | | , shift: 2//å¼¹åºå¨ç» |
| | | , content: ['../../ç产管ç/ç产任å¡å/Sc_ICMOBillList.html?HDeptID=' + HDeptID, 'yes'] |
| | | , content: ['../../ç产管ç/ç产任å¡å/Sc_ICMOBillList.html?openType =4&HDeptID=' + HDeptID, 'yes'] |
| | | , btn: ['ç¡®å®', 'åæ¶'] |
| | | , btn1: function (index, layero) {//æé®ãæé®ä¸ãçåè° |
| | | var iframeWindow = window['layui-layer-iframe' + index] //è·åå¼¹æ¡é¡µé¢ |
| | |
| | | } |
| | | }); |
| | | } else { |
| | | layer.close(ajaxLoad); // å
³éæå®loading |
| | | return layer.msg("è¯·éæ©ä¸æ¡æ°æ®è¿è¡å·¥èºè·¯çº¿ç¼è¾"); |
| | | } |
| | | } |
| | |
| | | } |
| | | HinterID_S.push(option.data[i]["hmainid"]); |
| | | } |
| | | //è·å计åéå®çå¤©æ° |
| | | $.ajax({ |
| | | url: GetWEBURL() + '/JIT_DayPlanPlatFormBill/JIT_DayPlanPlatFormBillHinterIDList', |
| | | type: "GET", |
| | |
| | | }); |
| | | |
| | | //æ ¹æ®è½¦é´å 餿²¡æéå®çæ°æ® |
| | | var sql = "delete from Sc_WorkBillSortBillSub where HMasterDate>=convert(varchar(10) ,DATEADD(DAY," + HPlanDay + ",GETDATE()),20) and HInterID in(select HInterID from Sc_WorkBillSortBillMain where HWorkShopID=" + HWorkShopID + ")"; |
| | | var sql = "delete from Sc_WorkBillSortBillSub where HLockedSub != 1 and HInterID in (select HInterID from Sc_WorkBillSortBillMain where HWorkShopID=" + HWorkShopID + " and HLockOrder != 1 )"; |
| | | $.ajax({ |
| | | url: GetWEBURL() + '/Gy_SOPBillList/UpDelSQL', |
| | | type: "GET", |
| | |
| | | layer.alert("æ¥å£è¯·æ±å¤±è´¥!", { icon: 5 }); |
| | | } |
| | | }); |
| | | |
| | | //å°è¡¨æ ¼æ°æ®å è½½å°TableDataéé¢ |
| | | get_HFData(0, 0); |
| | | |
| | | //åå§åè¡¨æ ¼æ°æ® |
| | | //æ¸
空é宿¥æä»¥å¤çæ°æ® |
| | | for (var i = 0; i < option.data.length; i++) { |
| | | for (var j = (22 + HPlanDay); j < 53; j++) { |
| | | if (option.data[i][option.cols[0][j].field] != null) { |
| | |
| | | sWorkQty = option.data[i]["å°æ¶äº§è½"]; |
| | | sYX = option.data[i]["ä¼å
级"]; |
| | | HReportQty = option.data[i]["æåæ±æ¥æ°é"]; |
| | | |
| | | //æåæ°éå廿±æ¥æ°éé宿°é |
| | | if (SDSum > 0) { |
| | | sPlanQty = sPlanQty - SDSum - HReportQty; |
| | | sPlanQty = sPlanQty - SDSum; |
| | | } |
| | | //å©ä½éæ±å·¥æ¶ |
| | | iLeftQty = sPlanQty - HReportQty; |
| | |
| | | success: function (data1) { |
| | | if (data1.count == 1) { |
| | | ds = data1.data |
| | | option.data[i]["HMouldID"] = data1.data[0].HMouldID == undefined ? 0 : data1.data[0].HMouldID; |
| | | option.data[i]["使ç¨å·¥è£
"] = data1.data[0].使ç¨å·¥è£
; |
| | | } else { |
| | | layer.alert(data1.code + data1.Message, { icon: 5 }); |
| | | } |
| | |
| | | success: function (data1) { |
| | | if (data1.count == 1) { |
| | | ds = data1.data |
| | | option.data[i]["HMouldID"] = data1.data[0].HMouldID == undefined ? 0 : data1.data[0].HMouldID; |
| | | option.data[i]["使ç¨å·¥è£
"] = data1.data[0].使ç¨å·¥è£
; |
| | | } else { |
| | | layer.alert(data1.code + data1.Message, { icon: 5 }); |
| | | } |
| | |
| | | |
| | | //åé¤ä¸æ¹æäº§å表ä¸å·²ç»å å
¥çç产订å |
| | | var tables = []; |
| | | for (var i = 0; i < option2.data.length; i++) { |
| | | var temp = option2.data[i]["hmainid"] + "|" + option2.data[i]["HEntryID"]; |
| | | if ($.inArray(temp, compareList) == -1) { |
| | | tables.push(option2.data[i]); |
| | | if (option2.data != undefined) { |
| | | for (var i = 0; i < option2.data.length; i++) { |
| | | var temp = option2.data[i]["hmainid"] + "|" + option2.data[i]["HEntryID"]; |
| | | if ($.inArray(temp, compareList) == -1) { |
| | | tables.push(option2.data[i]); |
| | | } |
| | | } |
| | | } |
| | | option2.data = tables; |
| | | option2.data = tables; |
| | | |
| | | //éæ°æ¸²æå表2 |
| | | table.render(option2); |
| | | |
| | | //éæ°æ¸²æå表2 |
| | | table.render(option2); |
| | | } |
| | | layer.close(ajaxLoad); |
| | | } else { |
| | | layer.close(ajaxLoad); |
| | |
| | | } |
| | | } |
| | | |
| | | //éå®å·¥å |
| | | function get_btnLockOrder() { |
| | | var checkStatus = table.checkStatus('mainTable') |
| | | , data = checkStatus.data; |
| | | |
| | | if (data.length > 0) { |
| | | var HInterIDArr = []; |
| | | |
| | | for (var i = 0; i < data.length; i++) { |
| | | HInterIDArr.push(data[i].hmainid); |
| | | } |
| | | |
| | | var ajaxLoad = layer.load(); |
| | | $.ajax({ |
| | | url: GetWEBURL() + '/JIT_DayPlanPlatFormBill/JIT_DayPlanPlatFormBillHLockedOrder', |
| | | type: "GET", |
| | | data: { "HInterIDs": HInterIDArr.toString() }, |
| | | success: function (data1) { |
| | | if (data1.count == 1) { |
| | | layer.msg("å·¥åå·²éå®"); |
| | | get_FastQuery(2); |
| | | layer.close(ajaxLoad); |
| | | } else { |
| | | layer.close(ajaxLoad); |
| | | layer.alert(data1.code + data1.Message, { icon: 5 }); |
| | | } |
| | | }, error: function () { |
| | | layer.close(ajaxLoad); |
| | | layer.alert("æ¥å£è¯·æ±å¤±è´¥!", { icon: 5 }); |
| | | } |
| | | }); |
| | | |
| | | } else { |
| | | layer.msg('è¯·éæ©ä½ è¦éå®çå·¥åï¼'); |
| | | } |
| | | } |
| | | |
| | | //è§£éå·¥å |
| | | function get_btnUnlockOrder() { |
| | | var checkStatus = table.checkStatus('mainTable') |
| | | , data = checkStatus.data; |
| | | |
| | | if (data.length > 0) { |
| | | var HInterIDArr = []; |
| | | |
| | | for (var i = 0; i < data.length; i++) { |
| | | HInterIDArr.push(data[i].hmainid); |
| | | } |
| | | |
| | | var ajaxLoad = layer.load(); |
| | | $.ajax({ |
| | | url: GetWEBURL() + '/JIT_DayPlanPlatFormBill/JIT_DayPlanPlatFormBillHUnlockOrder', |
| | | type: "GET", |
| | | data: { "HInterIDs": HInterIDArr.toString() }, |
| | | success: function (data1) { |
| | | if (data1.count == 1) { |
| | | layer.msg("å·¥å已解é"); |
| | | get_FastQuery(2); |
| | | layer.close(ajaxLoad); |
| | | } else { |
| | | layer.close(ajaxLoad); |
| | | layer.alert(data1.code + data1.Message, { icon: 5 }); |
| | | } |
| | | }, error: function () { |
| | | layer.close(ajaxLoad); |
| | | layer.alert("æ¥å£è¯·æ±å¤±è´¥!", { icon: 5 }); |
| | | } |
| | | }); |
| | | |
| | | } else { |
| | | layer.msg('è¯·éæ©ä½ è¦è§£éçå·¥åï¼'); |
| | | } |
| | | } |
| | | |
| | | //æ¥è¯¢æªæäº§çç产订å |
| | | function get_Display2(sWhere_ICMO) { |
| | | var ajaxLoad = layer.load(); |
| | |
| | | var ajaxLoad = layer.load(); |
| | | if (checkStatus.data.length != 1) { |
| | | layer.alert("è¯·éæ©ä¸æ¡æ°æ®!"); |
| | | layer.close(ajaxLoad); |
| | | } else { |
| | | var TabData = checkStatus.data; |
| | | var HMaterID = TabData[0].HMaterID; |
| | |
| | | function get_HideColumn() { |
| | | var colName = ""; |
| | | var contentUrl = ""; |
| | | for (var i = 1; i < option.cols[0].length - 1; i++) { |
| | | colName += option.cols[0][i]["title"] + ","; |
| | | for (var i = 1; i < option.cols[0].length; i++) { |
| | | colName += option.cols[0][i]["field"] + ","; |
| | | } |
| | | var urlStr = window.document.location.pathname;//è·åæä»¶è·¯å¾ |
| | | var urlLen = urlStr.split('/'); |
| | |
| | | } |
| | | colName = encodeURI(colName.substring(0, colName.length - 1));//对 URI è¿è¡ç¼ç |
| | | |
| | | contentUrl += 'åºç¡èµæ/éèå设置/Gy_GridView_Hide.html?HModName=' + HModName + '&colName=' + colName; |
| | | contentUrl += 'åºç¡èµæ/éèå设置/Gy_GridView_Hide_New.html?HModName=' + HModName + '&colName=' + colName; |
| | | |
| | | layer.open({ |
| | | type: 2 |
| | |
| | | data: { "HModName": HModName, "user": sessionStorage["HUserName"] }, |
| | | success: function (data1) { |
| | | if (data1.data.length != 0) { |
| | | |
| | | |
| | | titleData = []; |
| | | var dataCol = [];//æ°æ®åºæ¥è¯¢åºçåæ°æ® |
| | | var titleData = ["åæ®å·", "HProdORGID", "HMaterID", "HUnitID", "HWorkShopID", "HSourceID"];//ä¸éè¦æ¾ç¤ºçåæ®µ 坿©å± |
| | | |
| | | var newCols = [[]];//å¯¹åºæ°æ®åºå顺åºcol |
| | | newCols[0].push(option.cols[0][0]);//æ¾å
¥ç¬¬ä¸ä¸ªcheckbox |
| | | dataCol = data1.data[0].HGridString.split(','); |
| | | |
| | | for (var i = 0; i < option.cols[0].length - 2; i++) { |
| | | if (dataCol[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; |
| | | //åè®¾ç½®åæ°ä¸é¡µé¢åæ°æ¯å¦ä¸è´ |
| | | if (dataCol.length == option.cols[0].length - 1) { |
| | | //éå寻æ¾å设置对åºåæé¡ºåºæå
¥ |
| | | for (var j = 0; j < option.cols[0].length - 1; j++) { |
| | | for (var i = 0; i < option.cols[0].length - 1; i++) { |
| | | var dataCols = dataCol[j].split('|'); |
| | | //éæ©ä¸datacolsç¸åºåè¿è¡ä¿®æ¹ |
| | | if (option.cols[0][i + 1]["field"] == dataCols[5]) { |
| | | //éèå |
| | | 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 (dataCols[1] == 0 && $.inArray(option.cols[0][i + 1]["title"], titleData) == -1) { |
| | | option.cols[0][i + 1]["hide"] = false; |
| | | } |
| | | //ç»è®¡å |
| | | if (dataCols[6] == 1) { |
| | | option.cols[0][i + 1]["totalRow"] = true; |
| | | } |
| | | //å使å¨ä½ç½®(å·¦ å±
ä¸ å³) |
| | | 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; |
| | | } |
| | | //è®¾ç½®è¡¨æ ¼title屿§æ¾ç¤ºå«å |
| | | if (dataCols[4] != null && dataCols[4] != "") { |
| | | option.cols[0][i + 1]["title"] = dataCols[4]; |
| | | } |
| | | newCols[0].push(option.cols[0][i + 1]); |
| | | } |
| | | } |
| | | option.cols[0][i + 1]["fixed"] = "left"; |
| | | } |
| | | //éå循ç¯å夿坹åºåæ°æ¯å¦ä¸è´ |
| | | if (dataCol.length == newCols[0].length - 1) { |
| | | option.cols = newCols; |
| | | //åæ¶å»ç»å |
| | | 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); |
| | |
| | | }) |
| | | } |
| | | |
| | | // å¤æè¡¨å¤´æ 颿¯å¦ä¸ºæ¥ææ ¼å¼ |
| | | function isDateField(field) { |
| | | // æ£æ¥æ¥ææ ¼å¼ |
| | | var datePatterns = [ |
| | | /^\d{4}-\d{2}-\d{2}$/, // YYYY-MM-DD |
| | | /^\d{4}\/\d{2}\/\d{2}$/, // YYYY/MM/DD |
| | | /^\d{2}-\d{2}-\d{4}$/, // DD-MM-YYYY |
| | | /^\d{2}\/\d{2}\/\d{4}$/, // DD/MM/YYYY |
| | | /^\d{4}-\d{2}-\d{2} \d{2}:\d{2}:\d{2}$/, // YYYY-MM-DD HH:mm:ss |
| | | /^\d{4}å¹´\d{2}æ\d{2}æ¥$/ // ä¸ææ¥æ |
| | | ]; |
| | | |
| | | return datePatterns.some(pattern => pattern.test(field)); |
| | | } |
| | | //é¡µé¢æåº |
| | | table.on('sort(mainTable)', function (obj) { //注ï¼sort æ¯å·¥å
·æ¡äºä»¶åï¼test æ¯ table åå§å®¹å¨ç屿§ lay-filter="对åºçå¼" |
| | | table.reload('mainTable', { |
| | | initSort: obj //è®°å½åå§æåºï¼å¦æä¸è®¾çè¯ï¼å°æ æ³æ 记表头çæåºç¶æã layui 2.1.1 æ°å¢åæ° |
| | | , where: { //请æ±åæ°ï¼æ³¨æï¼è¿éé¢çåæ°å¯ä»»æå®ä¹ï¼å¹¶éä¸é¢åºå®çæ ¼å¼ï¼ |
| | | field: obj.field //æåºå段 卿¥å£ä½ä¸ºåæ°å段 field order |
| | | , order: obj.type //æåºæ¹å¼ 卿¥å£ä½ä¸ºåæ°å段 field order |
| | | } |
| | | }); |
| | | option.data = layui.table.cache["mainTable"]; |
| | | table.render(option); |
| | | }); |
| | | |
| | | table.on('sort(mainTable_ICMO)', function (obj) { //注ï¼sort æ¯å·¥å
·æ¡äºä»¶åï¼test æ¯ table åå§å®¹å¨ç屿§ lay-filter="对åºçå¼" |
| | | table.reload('mainTable_ICMO', { |
| | | initSort: obj //è®°å½åå§æåºï¼å¦æä¸è®¾çè¯ï¼å°æ æ³æ 记表头çæåºç¶æã layui 2.1.1 æ°å¢åæ° |
| | | , where: { //请æ±åæ°ï¼æ³¨æï¼è¿éé¢çåæ°å¯ä»»æå®ä¹ï¼å¹¶éä¸é¢åºå®çæ ¼å¼ï¼ |
| | | field: obj.field //æåºå段 卿¥å£ä½ä¸ºåæ°å段 field order |
| | | , order: obj.type //æåºæ¹å¼ 卿¥å£ä½ä¸ºåæ°å段 field order |
| | | } |
| | | }); |
| | | option2.data = layui.table.cache["mainTable_ICMO"]; |
| | | table.render(option); |
| | | }); |
| | | |
| | | //åææ¾ç¤ºä¸ææ¡ |
| | | function ColFilter() { |
| | | var Organization = '<option value="0" selected="selected" ></option>'; |