| New file |
| | |
| | | <!DOCTYPE html> |
| | | <html> |
| | | <head> |
| | | <meta charset="utf-8" /> |
| | | <title>缺æåææ¥è¡¨</title> |
| | | <link rel="stylesheet" href="../../../layuiadmin/layui/css/layui.css" media="all"> |
| | | <link rel="stylesheet" href="../../../layuiadmin/style/admin.css" media="all"> |
| | | <script src="../../../layuiadmin/zgqCustom/zgqCustom.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> |
| | | |
| | | </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" style="width: 85px;">ç»ç»</label> |
| | | <div class="layui-input-block" style="margin-left: 120px; width: 185px;"> |
| | | <select name="HORGID" id="HORGID" lay-verify="HORGID"> |
| | | <!--å¨ææ¸²æç»ç»--> |
| | | </select> |
| | | </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="date" class="layui-input" lay-verify="HBEGINDATE" name="HBEGINDATE" id="HBEGINDATE" style="padding-left: 78px;"> |
| | | </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="date" class="layui-input" lay-verify="HENDDATE" name="HENDDATE" id="HENDDATE" style="padding-left: 78px;"> |
| | | </div> |
| | | </div> |
| | | <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnSearch" id="btnSearch">æ¥è¯¢</button> |
| | | <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnReSearch" id="btnReSearch">éç½®</button> |
| | | <div class="layui-colla-content" style="padding: 0px; margin-left: 6%;"> |
| | | <div class="layui-row" style="margin-top:10px;"> |
| | | |
| | | </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="HideColumn"><i class="layui-icon layui-icon-form"></i>éèå设置</button> |
| | | </div> |
| | | </script> |
| | | </form> |
| | | </div> |
| | | </div> |
| | | </div> |
| | | </div> |
| | | </body> |
| | | </html> |
| | | <script> |
| | | var treeCkData = { id: 0 }; |
| | | var TagId = ""; |
| | | var TagParentId = ""; |
| | | layui.config({ |
| | | base: '../../../layuiadmin/' //éæèµæºæå¨è·¯å¾ |
| | | }).extend({ |
| | | index: 'lib/index', //主å
¥å£æ¨¡å |
| | | }).use(['tree', 'index', 'form', 'table', 'element', 'laypage', 'laydate', 'util'], 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 |
| | | , util = layui.util |
| | | , tree = layui.tree |
| | | , util = layui.util |
| | | var sWhere = ""; |
| | | var option = []; |
| | | var HModName = "MaterialShorAnalysisReport"; |
| | | //#endregion |
| | | |
| | | //#region è¿å
¥é¡µé¢å³å è½½ |
| | | |
| | | //åå§åçé¢ |
| | | set_ClearBill(); |
| | | |
| | | //#endregion |
| | | |
| | | //#region 触åäºä»¶ï¼å
æ¬form.on(){}æ ¼å¼çææç¹å»äºä»¶ãéæ©äºä»¶ç |
| | | |
| | | //头工å
·æ äºä»¶ |
| | | table.on('toolbar(mainTable)', function (obj) { |
| | | switch (obj.event) { |
| | | //éèå设置 |
| | | case 'HideColumn': |
| | | get_HideColumn(); |
| | | break; |
| | | }; |
| | | }); |
| | | |
| | | |
| | | //#region éç½®æé® |
| | | form.on('submit(btnReSearch)', function (data) { |
| | | set_ClearQuery(); |
| | | }); |
| | | //#endregion |
| | | |
| | | //#region æ¥è¯¢æé® |
| | | form.on('submit(btnSearch)', function (data) { |
| | | get_FastQuery(2); |
| | | }); |
| | | //#endregion |
| | | |
| | | //#endregion |
| | | |
| | | //#region æ¬é¡µé¢è¢«è°ç¨çæææ¹æ³ |
| | | |
| | | //#region åå§åçé¢ |
| | | function set_ClearBill() { |
| | | //åå§åæ¥æ |
| | | $("#HBEGINDATE").val(Format(new Date(), "yyyy-MM-dd")); |
| | | $("#HENDDATE").val(Format(new Date($("#HBEGINDATE").val()).setDate(new Date($("#HBEGINDATE").val()).getDate() + 30), 'yyyy-MM-dd')); |
| | | //ç产ç»ç»å è½½ |
| | | Organ(); |
| | | ////åå§åè¡¨æ ¼ |
| | | //set_InitGrid(); |
| | | //å¿«éè¿æ»¤ |
| | | get_FastQuery(1); |
| | | DisPlay_HideColumn(); |
| | | } |
| | | //#endregion |
| | | |
| | | //#region åå§åè¡¨æ ¼æ¹æ³ |
| | | function set_InitGrid() { |
| | | var columns = []; |
| | | |
| | | columns.push({ type: 'checkbox', fixed: 'left' }); |
| | | columns.push({ field: 'HOrgName', title: 'éè´ç»ç»' }); |
| | | columns.push({ field: 'FNUMBER', title: 'ç©æç¼ç ' }); |
| | | columns.push({ field: 'HMaterName', title: 'ç©æåç§°' }); |
| | | columns.push({ field: 'HMaterModel', title: 'ç©æè§æ ¼' }); |
| | | columns.push({ field: 'CountHQty', title: 'å计' }); |
| | | columns.push({ field: 'FBASEQTY', title: '峿¶åºåæ°é' }); |
| | | //è·å两个ææä¹é´çç¸å·® |
| | | var time1 = Date.parse(new Date($("#HBEGINDATE").val()));//å¼å§æ¶é´ |
| | | var time2 = Date.parse(new Date($("#HENDDATE").val()));//ç»ææ¶é´ |
| | | var Days = Math.abs(parseInt((time2 - time1) / 1000 / 3600 / 24)); |
| | | //è·åå¹´ |
| | | var yyyy = new Date($("#HBEGINDATE").val()).getFullYear(); |
| | | //è·åæä»½ |
| | | var MM = new Date($("#HBEGINDATE").val()).getMonth() + 1; |
| | | //è·åå¼å§æä»½çæå¤§å¤©æ° |
| | | var SumMonth = new Date(yyyy, MM, 0).getDate(); |
| | | //è·åå¼å§æ¥æçå¤©æ° |
| | | var HBEGINDATE = new Date(new Date($("#HBEGINDATE").val())).getDate(); //è·åå¼å§æ¥æå¤©æ° |
| | | |
| | | var k = 0;//æ¶éå¾ªç¯æ¬¡æ° |
| | | for (var j = 0; j <= (Days - k); j++) { |
| | | columns.push({ field: Format(yyyy + '/' + MM + '/' + (HBEGINDATE + j), 'yyyy-MM-dd'), title: Format(yyyy + '/' + MM + '/' + (HBEGINDATE + j), 'MM.dd'), width: 70 }) |
| | | //跨年çè¯ ä¼ä»ä¸æä¸å·å¼å§ |
| | | if (MM == 12 && (HBEGINDATE + j) == 31) { |
| | | yyyy += 1; |
| | | MM = 1; |
| | | SumMonth = new Date(yyyy, MM, 0).getDate(); |
| | | HBEGINDATE = 0; |
| | | k += j; |
| | | j = 0; |
| | | } else if ((HBEGINDATE + j) == SumMonth) { //è·¨æ ææ°å ä¸ å¤©æ°ä»ä¸å¼å§ |
| | | HBEGINDATE = 0; |
| | | MM += 1; |
| | | SumMonth = new Date(yyyy, MM, 0).getDate(); |
| | | k += j; |
| | | j = 0; |
| | | } |
| | | } |
| | | option = { |
| | | elem: '#mainTable' |
| | | , toolbar: '#toolbarDemo' |
| | | , height: 'full-50' |
| | | , page: true |
| | | , cellMinWidth: 90 |
| | | , limit: 50 |
| | | , limits: [50, 500, 5000, 20000] |
| | | , loading: false |
| | | , cols: [columns] |
| | | , done: function (res, page, count) { |
| | | var that = this.elem.next(); |
| | | res.data.forEach(function (item, index) { |
| | | var NumCount = item.FBASEQTY;//è·åæ»åºåæ°é |
| | | for (var i = 0; i < Days; i++) { |
| | | var dateNowTime = Format(new Date($("#HBEGINDATE").val()).setDate(new Date($("#HBEGINDATE").val()).getDate() + i), 'yyyy-MM-dd'); |
| | | if (item[dateNowTime] != null) { |
| | | if (NumCount > parseFloat(item[dateNowTime])) { |
| | | NumCount -= parseFloat(item[dateNowTime]); |
| | | } else { |
| | | var num = 6;//峿¶åºå䏿¥ææ¨ç ä»å³æ¶åºåå¼å§ç® |
| | | tr = that.find(".layui-table-box tbody tr[data-index='" + index + "']"); |
| | | rq = tr.children()[num + 1 + i]; |
| | | rq.style.color = '#f66161';//ç¶ååè² |
| | | rq = tr.children()[num]; |
| | | rq.style.color = '#f66161';//ç¶ååè² |
| | | } |
| | | } |
| | | } |
| | | }); |
| | | $('.layui-table-cell').css({ 'height': 'auto' }); |
| | | } |
| | | }; |
| | | } |
| | | //#endregion |
| | | |
| | | |
| | | //è·åç»ç» |
| | | function Organ() { |
| | | //è·åç»å½é¡µç»ç»å |
| | | var Organization = ''; |
| | | $.ajax({ |
| | | type: "get", |
| | | url: GetWEBURL() + "/Web/GetOrganizations", |
| | | success: function (result) { |
| | | if (result.count == 1) { // 说æéªè¯æåäºï¼ |
| | | var data = result.data; |
| | | for (var i = 0; i < data.length; i++) { |
| | | Organization += '<option style="color:blue;" value="' + data[i].ID + '">' + data[i].Name + '</option>'; |
| | | } |
| | | $("#HORGID").append(Organization); |
| | | $("#HORGID").val(sessionStorage["OrganizationID"]) |
| | | form.render('select'); |
| | | } |
| | | layer.closeAll("loading"); |
| | | } |
| | | }) |
| | | } |
| | | |
| | | //#region æ¥è¯¢ |
| | | function get_Display(sWhere) { |
| | | var ajaxLoad = layer.load(); |
| | | $.ajax({ |
| | | url: GetWEBURL() + '/JIT_DayPlanPlatFormBill/MaterialShorAnalysisReport', |
| | | type: "GET", |
| | | data: { "sWhere": sWhere }, |
| | | success: function (result) { |
| | | if (result.count == 1) { |
| | | option.data = result.data; |
| | | table.render(option); |
| | | layer.close(ajaxLoad); |
| | | //layer.alert("æ¥è¯¢æå", { icon: 1 }); |
| | | } else { |
| | | layer.close(ajaxLoad); |
| | | layer.alert(result.code + result.Message, { icon: 5 }); |
| | | } |
| | | }, error: function () { |
| | | layer.close(ajaxLoad); |
| | | layer.alert("æ¥å£è¯·æ±å¤±è´¥!", { icon: 5 }); |
| | | } |
| | | }); |
| | | } |
| | | |
| | | //#endregion |
| | | |
| | | //#region å¿«éè¿æ»¤ |
| | | function get_FastQuery(number) { |
| | | var HORGID = ""; |
| | | if (number == 1) { |
| | | HORGID = sessionStorage["OrganizationID"]; |
| | | } |
| | | else { |
| | | HORGID = $("#HORGID").val();//ç»ç» |
| | | } |
| | | var HBEGINDATE = $("#HBEGINDATE").val();//æææ¥æ |
| | | var HENDDATE = $("#HENDDATE").val();//è³ |
| | | //var HMATERIALID = $("#HMATERIALID").val();//ç©æ/产å |
| | | //var HSUPPLIERID = $("#HSUPPLIERID").val();//ä¾åºå |
| | | //var HXQD = $("#HXQD").val();//éæ±åå· |
| | | //var HPURORDERNO = $("#HPURORDERNO").val();//éè´è®¢åå· |
| | | |
| | | if (HBEGINDATE > HENDDATE) { |
| | | return layer.msg("å¼å§æ¥æä¸è½å°äºç»ææ¥æ!"); |
| | | } |
| | | |
| | | sWhere = { |
| | | HORGID: HORGID |
| | | , HBEGINDATE: HBEGINDATE |
| | | , HENDDATE: HENDDATE |
| | | //, HMATERIALID: HMATERIALID |
| | | //, HSUPPLIERID: HSUPPLIERID |
| | | //, HXQD: HXQD |
| | | //, HPURORDERNO: HPURORDERNO |
| | | } |
| | | //åå§åè¡¨æ ¼ |
| | | set_InitGrid(); |
| | | get_Display(JSON.stringify(sWhere)); |
| | | sWhere = "";//è°ç¨æ¥å£åæ¸
空sWhereç¼å |
| | | } |
| | | //#endregion |
| | | |
| | | //#region éç½®è¿æ»¤æ¡ä»¶æ¹æ³ |
| | | function set_ClearQuery() { |
| | | $("#HORGID").val(sessionStorage["OrganizationID"]);//ç»ç» |
| | | $("#HENDDATE").val(Format(new Date($("#HBEGINDATE").val()).setDate(new Date($("#HBEGINDATE").val()).getDate() + 30), 'yyyy-MM-dd')); |
| | | $("#HENDDATE").val(Format(new Date(), "yyyy-MM-dd"));//è³ |
| | | //$("#HMATERIALID").val("");//ç©æ/产å |
| | | //$("#HMATERIALNAME").val(""); |
| | | //$("#HSUPPLIERID").val("");//ä¾åºå |
| | | //$("#HSUPPLIERNAME").val(""); |
| | | //$("#HXQD").val("");//éæ±åå· |
| | | //$("#HPURORDERNO").val("");//éè´è®¢åå· |
| | | form.render('select'); |
| | | sWhere = ""; |
| | | } |
| | | //#endregion |
| | | |
| | | //ç©æå表 |
| | | function btnHMATERIALID() { |
| | | layer.open({ |
| | | type: 2 //ç±»å |
| | | , skin: 'layui-layer-rim'//å ä¸è¾¹æ¡ |
| | | , area: ['90%', '90%']//å¤§å° |
| | | , title: 'ç©æå表'//æ é¢ |
| | | , shift: 2//å¼¹åºå¨ç» |
| | | , content: ['../../Baseset/åºç¡èµæ/Gy_MaterialList.html', 'yes'] |
| | | , btn: ['ç¡®å®', 'åæ¶'] |
| | | , btn1: function (index, layero) {//æé®ãæé®ä¸ãçåè° |
| | | var iframeWindow = window['layui-layer-iframe' + index] //è·åå¼¹æ¡é¡µé¢ |
| | | var checkStatus = iframeWindow.layui.table.checkStatus('mainTable');//è·åtableçelem:"#test" |
| | | if (checkStatus.data.length === 0) { |
| | | return layer.msg('è¯·éæ©æ°æ®'); |
| | | } |
| | | //è·åæ°æ® |
| | | $("#HMATERIALID").val(checkStatus.data[0].HItemID); |
| | | $("#HMATERIALNAME").val(checkStatus.data[0].HName); |
| | | layer.close(index); //å®è·åçå§ç»æ¯ææ°å¼¹åºçæä¸ªå±ï¼å¼æ¯ç±layerå
é¨å¨æéå¢è®¡ç®ç |
| | | } |
| | | , btn2: function (index, layero) { } |
| | | }) |
| | | } |
| | | |
| | | //ä¾åºå |
| | | function btnHSUPPLIERID() { |
| | | layer.open({ |
| | | type: 2 //ç±»å |
| | | , skin: 'layui-layer-rim'//å ä¸è¾¹æ¡ |
| | | , area: ['90%', '90%']//å¤§å° |
| | | , title: 'ä¾åºåå表'//æ é¢ |
| | | , shift: 2//å¼¹åºå¨ç» |
| | | , content: ['../../åºç¡èµæ/éè´åºç¡èµæ/Gy_Supplier.html', 'yes'] |
| | | , btn: ['ç¡®å®', 'åæ¶'] |
| | | , btn1: function (index, layero) {//æé®ãæé®ä¸ãçåè° |
| | | var iframeWindow = window['layui-layer-iframe' + index] //è·åå¼¹æ¡é¡µé¢ |
| | | var checkStatus = iframeWindow.layui.table.checkStatus('mainTable');//è·åtableçelem:"#test" |
| | | if (checkStatus.data.length === 0) { |
| | | return layer.msg('è¯·éæ©æ°æ®'); |
| | | } |
| | | //è·åæ°æ® |
| | | $("#HSUPPLIERID").val(checkStatus.data[0].HItemID); |
| | | $("#HSUPPLIERNAME").val(checkStatus.data[0].ä¾åºååç§°); |
| | | layer.close(index); //å®è·åçå§ç»æ¯ææ°å¼¹åºçæä¸ªå±ï¼å¼æ¯ç±layerå
é¨å¨æéå¢è®¡ç®ç |
| | | } |
| | | , btn2: function (index, layero) { } |
| | | }) |
| | | } |
| | | |
| | | //éèå设置 |
| | | function get_HideColumn() { |
| | | var colName = ""; |
| | | for (var i = 1; i < option.cols[0].length; i++) { |
| | | colName += option.cols[0][i]["title"] + ","; |
| | | } |
| | | |
| | | colName = encodeURI(colName.substring(0, colName.length - 1));//对 URI è¿è¡ç¼ç |
| | | layer.open({ |
| | | type: 2 |
| | | , skin: "layui-layer-rim" //å ä¸è¾¹æ¡ |
| | | , title: "éèå设置" //æ é¢ |
| | | , closeBtn: 1 //çªä½å³ä¸è§å
³é ç æ ·å¼ |
| | | , shift: 2 //å¼¹åºå¨ç» |
| | | , area: ["50%", "90%"] //çªä½å¤§å° |
| | | , maxmin: true //设置æå¤§æå°æé®æ¯å¦æ¾ç¤º |
| | | , content: ['../../åºç¡èµæ/éèå设置/Gy_GridView_Hide.html?HModName=' + HModName + '&colName=' + colName, "yes"] |
| | | , btn: ["ç¡®å®", "åæ¶"] |
| | | , btn1: function (index, laero) { |
| | | //å·æ°è¡¨æ ¼æ°æ® |
| | | DisPlay_HideColumn(); |
| | | //æ´æ°è¡¨æ ¼ç¼åçæ°æ® |
| | | layer.close(index);//å
³éå¼¹çª |
| | | } |
| | | }) |
| | | } |
| | | |
| | | //æ¾ç¤ºåæ°æ® |
| | | function DisPlay_HideColumn() { |
| | | $.ajax({ |
| | | url: GetWEBURL() + '/Xt_grdAlignment_WMES/grdAlignmentWMESList', |
| | | type: "GET", |
| | | data: { "HModName": HModName, "user": sessionStorage["HUserName"] }, |
| | | success: function (data1) { |
| | | if (data1.data.length != 0) { |
| | | |
| | | var dataCol = [];//æ°æ®åºæ¥è¯¢åºçåæ°æ® |
| | | var titleData = [];//ä¸éè¦æ¾ç¤ºçåæ®µ 坿©å± |
| | | |
| | | dataCol = data1.data[0].HGridString.split(','); |
| | | |
| | | for (var i = 0; i < option.cols[0].length - 1; i++) { |
| | | if (dataCol[i]) { |
| | | var dataCols = dataCol[i].split('|'); |
| | | } |
| | | //éèå |
| | | if (dataCols[1] == 1) { |
| | | option.cols[0][i + 1]["hide"] = true; |
| | | } |
| | | //设置å
容åä½å¤§å° |
| | | 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[3] > 0) { |
| | | option.cols[0][i + 1]["width"] = dataCols[3]; |
| | | } |
| | | //æ¾ç¤ºå |
| | | 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 |
| | | //以䏿¯layui模å |
| | | }); |
| | | </script> |