| | |
| | | <script src="../../../layuiadmin/Scripts/jquery-1.4.1.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"> |
| | |
| | | base: '../../../layuiadmin/' //éæèµæºæå¨è·¯å¾ |
| | | }).extend({ |
| | | index: 'lib/index', //主å
¥å£æ¨¡å |
| | | }).use(['tree', 'index', 'form', 'table', 'element', 'laypage', 'laydate', 'util'], function () { |
| | | }).use(['tree', 'index', 'form', 'table', 'element', 'laypage', 'laydate', 'util','soulTable'], function () { |
| | | //#region å
¬ç¨åé |
| | | var $ = layui.$ |
| | | , admin = layui.admin |
| | |
| | | , util = layui.util |
| | | , tree = layui.tree |
| | | , util = layui.util |
| | | , soulTable = layui.soulTable |
| | | var sWhere = ""; |
| | | var option = []; |
| | | //#endregion |
| | |
| | | //#region åå§åçé¢ |
| | | function set_ClearBill() { |
| | | //åå§åæ¥æ |
| | | $("#HBEGINDATE").val(Format(new Date(new Date() - 1000 * 60 * 60 * 24 * 30), "yyyy-MM-dd")); |
| | | $("#HENDDATE").val(Format(new Date(), "yyyy-MM-dd")); |
| | | $("#HBEGINDATE").val(Format(new Date(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); |
| | | } |
| | |
| | | //#region åå§åè¡¨æ ¼æ¹æ³ |
| | | function set_InitGrid() { |
| | | var columns = []; |
| | | var myDate = new Date(); |
| | | var yyyy = myDate.getFullYear(); |
| | | var MM = myDate.getMonth() + 1; |
| | | var dd = myDate.getDate(); |
| | | var SumMonth = 31; //卿䏤æä¹å·® new Date(yyyy, MM, 0).getDate() |
| | | var MonthCount = new Date(yyyy, MM-1, 0).getDate(); |
| | | |
| | | columns.push({ type: 'checkbox', fixed: 'left' }); |
| | | columns.push({ field: 'ç»ç»', title: 'ç产ç»ç»' }); |
| | | columns.push({ field: 'é¨é¨', title: 'ç产车é´' }); |
| | | columns.push({ field: 'FSUMQTY', title: 'å计' }); |
| | | columns.push({ field: 'ç©æåç§°', title: 'ç©æåç§°' }); |
| | | columns.push({ field: 'è§æ ¼åå·', title: 'ç©æè§æ ¼' }); |
| | | columns.push({ field: 'HICMOBillNo', title: 'ç产订åå·' }); |
| | | columns.push({ field: 'HSeOrderBillNo', title: 'éæ±åå·' }); |
| | | columns.push({ field: 'ç©æä»£ç ', title: 'ç©æç¼ç ' }); |
| | | columns.push({ field: '计éåä½åç§°', title: '计éåä½' }); |
| | | columns.push({ field: 'TQSUM', title: 'è¦ææææ°é' }); |
| | | for (var i = 1; i <= (MonthCount - dd); i++) { |
| | | columns.push({ field: Format(yyyy + '/' + (MM - 1) + '/' + (dd + i), 'yyyy-MM-dd'), title: Format(yyyy + '/' + (MM - 1) + '/' + (dd + i), 'MM.dd'), width: 70 })//0 |
| | | } |
| | | for (var i = 1; i <= (SumMonth - MonthCount + dd); i++) { |
| | | columns.push({ field: Format(yyyy + '/' + MM + '/' + i, 'yyyy-MM-dd'), title: Format(yyyy + '/' + MM + '/' + i, 'MM.dd'), width: 70 })//0 |
| | | columns.push({ type: 'checkbox', fixed: 'left', sort: true}); |
| | | columns.push({ field: 'ç»ç»', title: 'ç产ç»ç»', sort: true}); |
| | | columns.push({ field: 'é¨é¨', title: 'ç产车é´', sort: true}); |
| | | columns.push({ field: 'FSUMQTY', title: 'å计', sort: true}); |
| | | columns.push({ field: 'ç©æåç§°', title: 'ç©æåç§°', sort: true}); |
| | | columns.push({ field: 'è§æ ¼åå·', title: 'ç©æè§æ ¼', sort: true}); |
| | | columns.push({ field: 'HICMOBillNo', title: 'ç产订åå·', sort: true}); |
| | | columns.push({ field: 'HSeOrderBillNo', title: 'éæ±åå·', sort: true}); |
| | | columns.push({ field: 'ç©æä»£ç ', title: 'ç©æç¼ç ', sort: true}); |
| | | columns.push({ field: '计éåä½åç§°', title: '计éåä½', sort: true}); |
| | | columns.push({ field: 'TQSUM', title: 'è¦ææææ°é', sort: true, totalRow: true}); |
| | | //è·å两个ææä¹é´çç¸å·® |
| | | 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, totalRow: true}) |
| | | //跨年çè¯ ä¼ä»ä¸æä¸å·å¼å§ |
| | | 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; |
| | | } |
| | | } |
| | | columns.push({ field: '', title: '计åæç»_å计' }); |
| | | |
| | |
| | | , page: true |
| | | , cellMinWidth: 90 |
| | | , limit: 50 |
| | | , totalRow: true |
| | | , limits: [50, 500, 5000, 20000] |
| | | , loading: false |
| | | , cols: [columns] |
| | | , done: function (res, curr, count) { |
| | | soulTable.render(this); |
| | | } |
| | | }; |
| | | } |
| | | //#endregion |
| | |
| | | var HENDDATE = $("#HENDDATE").val();//è³ |
| | | var HMATERIALID = $("#HMATERIALID").val();//ç©æ/产å |
| | | var HDeptID = $("#HDeptID").val();//çäº§è½¦é´ |
| | | if (HBEGINDATE > HENDDATE) { |
| | | return layer.msg("å¼å§æ¥æä¸è½å°äºç»ææ¥æ!"); |
| | | } |
| | | |
| | | sWhere = { |
| | | HORGID: HORGID |
| | |
| | | , HMATERIALID: HMATERIALID |
| | | , HDeptID: HDeptID |
| | | } |
| | | //åå§åè¡¨æ ¼ |
| | | set_InitGrid(); |
| | | get_Display(JSON.stringify(sWhere)); |
| | | sWhere = "";//è°ç¨æ¥å£åæ¸
空sWhereç¼å |
| | | } |
| | |
| | | //#region éç½®è¿æ»¤æ¡ä»¶æ¹æ³ |
| | | function set_ClearQuery() { |
| | | $("#HORGID").val(sessionStorage["OrganizationID"]);//ç»ç» |
| | | $("#HBEGINDATE").val(Format(new Date(new Date() - 1000 * 60 * 60 * 24 * 30), "yyyy-MM-dd"));//æææ¥æ |
| | | $("#HENDDATE").val(Format(new Date(), "yyyy-MM-dd"));//è³ |
| | | $("#HBEGINDATE").val(Format(new Date(new Date()), "yyyy-MM-dd"));//æææ¥æ |
| | | $("#HENDDATE").val(Format(new Date($("#HBEGINDATE").val()).setDate(new Date($("#HBEGINDATE").val()).getDate() + 30), "yyyy-MM-dd"));//è³ |
| | | $("#HMATERIALID").val("");//ç©æ/产å |
| | | $("#HMATERIALNAME").val(""); |
| | | $("#HDeptID").val("");//çäº§è½¦é´ |
| | |
| | | , area: ['90%', '90%']//å¤§å° |
| | | , title: 'ç©æå表'//æ é¢ |
| | | , shift: 2//å¼¹åºå¨ç» |
| | | , content: ['../../Baseset/åºç¡èµæ/Gy_MaterialList.html', 'yes'] |
| | | , content: ['../../åºç¡èµæ/å
¬ç¨åºç¡èµæ/Gy_Material.html', 'yes'] |
| | | , btn: ['ç¡®å®', 'åæ¶'] |
| | | , btn1: function (index, layero) {//æé®ãæé®ä¸ãçåè° |
| | | var iframeWindow = window['layui-layer-iframe' + index] //è·åå¼¹æ¡é¡µé¢ |
| | |
| | | } |
| | | //è·åæ°æ® |
| | | $("#HMATERIALID").val(checkStatus.data[0].HItemID); |
| | | $("#HMATERIALNAME").val(checkStatus.data[0].HName); |
| | | $("#HMATERIALNAME").val(checkStatus.data[0].ç©æåç§°); |
| | | layer.close(index); //å®è·åçå§ç»æ¯ææ°å¼¹åºçæä¸ªå±ï¼å¼æ¯ç±layerå
é¨å¨æéå¢è®¡ç®ç |
| | | } |
| | | , btn2: function (index, layero) { } |
| | |
| | | , area: ['90%', '90%']//å¤§å° |
| | | , title: 'é¨é¨å表'//æ é¢ |
| | | , shift: 2//å¼¹åºå¨ç» |
| | | , content: ['../../Baseset/åºç¡èµæ/Gy_DepartmentList.html', 'yes'] |
| | | , content: ['../../åºç¡èµæ/å
¬ç¨åºç¡èµæ/Gy_DepartmentList.html', 'yes'] |
| | | , btn: ['ç¡®å®', 'åæ¶'] |
| | | , btn1: function (index, layero) {//æé®ãæé®ä¸ãçåè° |
| | | var iframeWindow = window['layui-layer-iframe' + index] //è·åå¼¹æ¡é¡µé¢ |
| | |
| | | } |
| | | //è·åæ°æ® |
| | | $("#HDeptID").val(checkStatus.data[0].HItemID); |
| | | $("#DeptNAME").val(checkStatus.data[0].HName); |
| | | $("#DeptNAME").val(checkStatus.data[0].é¨é¨åç§°); |
| | | layer.close(index); //å®è·åçå§ç»æ¯ææ°å¼¹åºçæä¸ªå±ï¼å¼æ¯ç±layerå
é¨å¨æéå¢è®¡ç®ç |
| | | } |
| | | , btn2: function (index, layero) { } |