| | |
| | | </select> |
| | | </div> |
| | | </div>--> |
| | | <div class="layui-inline"> |
| | | <div class="layui-form layui-inline" style="position:relative;top:10px;"> |
| | | <label class="layui-form-label">æ¥æ</label> |
| | | <div class="layui-form-item layui-inline"> |
| | | <div class="layui-inline"> |
| | | <div class="layui-input-inline"> |
| | | <input type="text" class="layui-input" id="HBeginDate" placeholder="yyyy-MM-dd HH:mm:ss"> |
| | | </div> |
| | | </div> |
| | | </div> |
| | | <div class="layui-form-item layui-inline"> |
| | | <div class="layui-inline"> |
| | | <label class="layui-form-label">-</label> |
| | | <div class="layui-input-inline"> |
| | | <input type="text" class="layui-input" id="HEndDate" placeholder="yyyy-MM-dd HH:mm:ss"> |
| | | </div> |
| | | </div> |
| | | </div> |
| | | </div> |
| | | <!--<div class="layui-inline"> |
| | | <label class="layui-form-label">æ¥æ</label> |
| | | <div class="layui-input-block"> |
| | | <input type="date" class="layui-input" id="HBeginDate" style="width:190px;"> |
| | |
| | | <div class="layui-input-block"> |
| | | <input type="date" class="layui-input" id="HEndDate" style="width:190px;"> |
| | | </div> |
| | | </div> |
| | | </div>--> |
| | | <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnSearch" id="btnSearch"> |
| | | <i class="layui-icon layui-icon-search layuiadmin-button-btn"></i> |
| | | </button> |
| | |
| | | <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="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="btn-exit"><i class="layui-icon layui-icon-return"></i>éåº</button> |
| | | <button type="button" class="layui-btn layui-btn-sm" lay-event="HideColumn"><i class="layui-icon layui-icon-form"></i>éèå设置</button> |
| | | </div> |
| | |
| | | var sWhere = ""; |
| | | var option = []; |
| | | var HModName = "MaterOutEntryReport_Cloth"; |
| | | |
| | | var ins; //ç¨äºå¯¼åºexcel |
| | | |
| | | var detailBar = 0; //ç¨äºæ±æ»æ¥è¡¨æ¥çæç»æ¥è¡¨ï¼å½ä¸º0æ¶æ¾ç¤ºæç»æ±æ»æ¥è¡¨å¯¹åºæç»æ¥è¡¨ã |
| | | //#endregion |
| | | |
| | | //#region è¿å
¥é¡µé¢æ¢å è½½ |
| | |
| | | //头工å
·æ äºä»¶ |
| | | table.on('toolbar(mainTable)', function (obj) { |
| | | switch (obj.event) { |
| | | //导åºexcel |
| | | case 'get_export': |
| | | get_Export(); |
| | | break; |
| | | //éåº |
| | | case 'btn-exit': Pub_Close(2); |
| | | break; |
| | |
| | | get_FastQuery(); |
| | | }); |
| | | |
| | | //è¡çå¬äºä»¶-åå» |
| | | 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 ä¸ºè¡¨æ ¼ID æ³¨ææ¤å¤å¦æ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() { |
| | | //åå§åæ¶é´ |
| | | $("#HBeginDate").val(Format(new Date(new Date() - 1000 * 60 * 60 * 24 * 10), "yyyy-MM-dd"));//å¼å§æ¥æ |
| | | $("#HEndDate").val(Format(new Date(), "yyyy-MM-dd"));//ç»ææ¥æ |
| | | var HBeginDate = Format(new Date(new Date() - 1000 * 60 * 60 * 24 * 1).setHours(7, 0, 0, 0), "yyyy-MM-dd hh"); |
| | | var HEndDate = Format(new Date(new Date()).setHours(7, 0, 0, 0), "yyyy-MM-dd hh"); |
| | | laydate.render({ |
| | | elem: '#HBeginDate', |
| | | type: 'datetime', |
| | | fullPanel: true |
| | | , format: 'yyyy-MM-dd HH' |
| | | , value: HBeginDate |
| | | }); |
| | | laydate.render({ |
| | | elem: '#HEndDate', |
| | | type: 'datetime', |
| | | fullPanel: true |
| | | , format: 'yyyy-MM-dd HH' |
| | | , value: HEndDate |
| | | }); |
| | | |
| | | |
| | | ////åå§åæ¶é´ |
| | | //$("#HBeginDate").val(Format(new Date(new Date() - 1000 * 60 * 60 * 24 * 10), "yyyy-MM-dd"));//å¼å§æ¥æ |
| | | //$("#HEndDate").val(Format(new Date(), "yyyy-MM-dd"));//ç»ææ¥æ |
| | | //åå§åè¡¨æ ¼ |
| | | //set_InitGrid(); |
| | | set_InitGrid(); |
| | | //å è½½æ°æ®å°ç½æ ¼ |
| | | get_FastQuery(); |
| | | DisPlay_HideColumn(); |
| | |
| | | } |
| | | |
| | | //åå§åè¡¨æ ¼ |
| | | function set_InitGrid(sWhere) { |
| | | //卿å-ç¼åå表 |
| | | $.ajax({ |
| | | url: GetWEBURL() + "/MaterOutEntryReport/MaterOutEntryReport_Cloth", |
| | | type: "GET", |
| | | async: false, |
| | | data: { "sWhere": sWhere }, |
| | | //async: false, |
| | | success: function (data1) { |
| | | function set_InitGrid() { |
| | | var HBeginDate = Format(new Date(new Date() - 1000 * 60 * 60 * 24 * 1).setHours(7, 0, 0, 0), "yyyy-MM-dd hh") + ":00:00";//ä¸è¾¾æ¥æ å¼å§æ¥æ |
| | | var HEndDate = Format(new Date(new Date()).setHours(7, 0, 0, 0), "yyyy-MM-dd hh") + ":00:00";//ç»ææ¥æ |
| | | |
| | | if (data1.count == 1) { |
| | | |
| | | var data = []; |
| | | var col = []; |
| | | //ç»ç©ºçæ°ç»èµå¼ |
| | | for (var key in data1.list) { |
| | | var width = data1.list[key].width * 23; |
| | | if (width < 150) { |
| | | width = 150; |
| | | } else if (width > 300) { |
| | | width = 300; |
| | | } |
| | | data.push({ "id": data1.list[key].ColmCols, "name": data1.list[key].ColmCols, "Type": data1.list[key].ColmType, "width": width }); |
| | | } |
| | | |
| | | for (var i = 0; i < data.length; i++) { |
| | | if ($.inArray(data[i].name, "") > -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 HH:mm:ss')}}</div>", width: data[i].width }); |
| | | break; |
| | | default: |
| | | col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: true, width: data[i].width }); |
| | | } |
| | | } |
| | | } |
| | | option = { |
| | | elem: '#mainTable' |
| | | , toolbar: '#toolbarDemo' |
| | | , cellMinWidth: 120 |
| | | , limit: Number.MAX_VALUE // æ°æ®è¡¨æ ¼é»è®¤å
¨é¨æ¾ç¤º |
| | | , totalRow: true |
| | | , height: 'full-70' |
| | | , cols: [col] |
| | | , data: data1.data |
| | | }; |
| | | table.render(option); |
| | | } else { |
| | | option = { |
| | | elem: '#mainTable' |
| | | , toolbar: '#toolbarDemo' |
| | | , cellMinWidth: 120 |
| | | , limit: Number.MAX_VALUE // æ°æ®è¡¨æ ¼é»è®¤å
¨é¨æ¾ç¤º |
| | | , totalRow: true |
| | | , height: 'full-70' |
| | | , cols: [[ |
| | | { type: 'checkbox', fixed: 'left', totalRowText: 'å计' } |
| | | , { field: 'æ¥æ', title: 'æ¥æ', width: 160 } |
| | | , { field: 'ä»»å¡å', title: 'ä»»å¡å', width: 160 } |
| | | , { field: 'å·¥åºæµè½¬å¡å·', title: 'å·¥åºæµè½¬å¡å·', width: 160 } |
| | | , { field: '产ååç§°', title: '产ååç§°', width: 160 } |
| | | , { field: 'è§æ ¼åå·', title: 'è§æ ¼åå·', width: 160 } |
| | | , { field: 'å½åå·¥åº', title: 'å½åå·¥åº', width: 160 } |
| | | , { field: '任塿°é', title: '任塿°é', width: 160 } |
| | | , { field: 'å¶å人', title: 'å¶å人', width: 200 } |
| | | , { field: 'æµè½¬å¡æ°é', title: 'æµè½¬å¡æ°é', width: 160, totalRow: true } |
| | | ]] |
| | | , done: function (res) { |
| | | //var count = 0; |
| | | //var OnlyID = -1; |
| | | //for (var i = 0; i < res.data.length; i++) { |
| | | // if (res.data[i]["å¯ä¸ID"] != OnlyID) { |
| | | // count += res.data[i]["æ´æ¹"]; |
| | | // OnlyID = res.data[i]["å¯ä¸ID"]; |
| | | // } |
| | | //} |
| | | //var divArr = $(".layui-table-total div.layui-table-cell"); |
| | | //$.each(divArr, function (index, item) { |
| | | // var _div = $(item); |
| | | // var content = _div.html(); |
| | | // if (index == 9) { |
| | | // content = count; |
| | | // } |
| | | // _div.html(content); |
| | | //}); |
| | | } |
| | | }; |
| | | table.render(option); |
| | | } |
| | | }, |
| | | error: function (err) { |
| | | layer.msg('é误' + err, { |
| | | icon: 5, |
| | | time: 20000 |
| | | }, function () { |
| | | //do something |
| | | }); |
| | | } |
| | | }) |
| | | } |
| | | |
| | | //åææ¾ç¤ºä¸ææ¡ |
| | | 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); |
| | | form.render('select'); |
| | | } |
| | | |
| | | |
| | | //å è½½ç½æ ¼ |
| | | function get_Display(sWhere) { |
| | | var wait = layer.load();//é®ç½© |
| | | $.ajax({ |
| | | url: GetWEBURL() + '/MaterOutEntryReport/MaterOutEntryReport_Cloth', |
| | | type: "GET", |
| | | data: { "sWhere": sWhere }, |
| | | success: function (data1) { |
| | | if (data1.count == 1) { |
| | | option.data = data1.data; |
| | | //var num = 0; |
| | | //for (let i = 0; i < data1.data.length; i++) { |
| | | // for (let j = i + 1; j < data1.data.length; j++) { |
| | | // if (data1.data[i].æµè½¬å¡å· === data1.data[j].æµè½¬å¡å·) { |
| | | // //num += data1.data[i].æ´æ¹; |
| | | // //data1.data[i].filter(() => { |
| | | // // return |
| | | // //}) |
| | | // data1.data[j].æ´æ¹ = ''; |
| | | // } |
| | | // } |
| | | //} |
| | | table.render(option); |
| | | |
| | | //计ç®å计å
¬æ¤æ° |
| | | var sumHMaterOutQty = 0; |
| | | for (var i = 0; i < data1.data.length; i++) { |
| | | sumHMaterOutQty += data1.data[i]["ç½å¯åå¸"]; |
| | | } |
| | | $("#SumHMaterOutQty").val(sumHMaterOutQty); |
| | | |
| | | layer.close(wait); |
| | | } else { |
| | | $("#SumHMaterOutQty").val(""); |
| | | layer.close(wait); |
| | | layer.alert(data1.Message, { icon: 5 }); |
| | | } |
| | | }, error: function () { |
| | | $("#SumHMaterOutQty").val(""); |
| | | layer.close(wait); |
| | | layer.alert("æ¥å£è¯·æ±å¤±è´¥!", { icon: 5 }); |
| | | } |
| | | }); |
| | | } |
| | | |
| | | //å¿«éè¿æ»¤ |
| | | function get_FastQuery() { |
| | | var HBeginDate = $("#HBeginDate").val();//ä¸è¾¾æ¥æ å¼å§æ¥æ |
| | | var HEndDate = $("#HEndDate").val();//ç»ææ¥æ |
| | | //var HBeginDate = $("#HBeginDate").val() + ":00:00" ;//ä¸è¾¾æ¥æ å¼å§æ¥æ |
| | | //var HEndDate = $("#HEndDate").val()+":00:00";//ç»ææ¥æ |
| | | var HMaterNumber = $("#HMaterNumber").val();//ç©æä»£ç |
| | | var HBillNo = $("#HBillNo").val(); //åæ®å· |
| | | var HProductName = $("#HProductName").val();//产ååç§° |
| | |
| | | , HProductModel: HProductModel |
| | | , RandomSearch: com |
| | | } |
| | | sWhere = JSON.stringify(sWhere); |
| | | |
| | | set_InitGrid(JSON.stringify(sWhere)); |
| | | |
| | | //卿å-ç¼åå表 |
| | | $.ajax({ |
| | | url: GetWEBURL() + "/MaterOutEntryReport/MaterOutEntryReport_Cloth", |
| | | type: "GET", |
| | | async: false, |
| | | data: { "sWhere": sWhere, "user": sessionStorage["HUserName"] }, |
| | | //async: false, |
| | | success: function (data1) { |
| | | |
| | | if (data1.count == 1) { |
| | | var totalArray = ["任塿°é","ç½å¯åå¸", "æµè½¬å¡æ°é"]; |
| | | var data = []; |
| | | var col = []; |
| | | //ç»ç©ºçæ°ç»èµå¼ |
| | | for (var key in data1.list) { |
| | | var width = data1.list[key].width * 23; |
| | | if (width < 150) { |
| | | width = 150; |
| | | } else if (width > 300) { |
| | | width = 300; |
| | | } |
| | | 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, "") > -1) { |
| | | col.push({ field: data[i].id, title: data[i].name, align: 'center', hide: true }); //éèidå |
| | | } |
| | | else if ($.inArray(data[i].name, totalArray) > -1) { |
| | | col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: true, totalRow: true, width: 120 }); |
| | | } |
| | | else if (data[i].ColName == 'ç½å¯åå¸') { |
| | | col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: true, totalRow:true }); |
| | | } |
| | | else { |
| | | switch (data[i].Type) { |
| | | //int |
| | | case 'DateTime': |
| | | col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: true }); |
| | | break; |
| | | default: |
| | | col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: true }); |
| | | } |
| | | } |
| | | } |
| | | option = { |
| | | elem: '#mainTable' |
| | | , toolbar: '#toolbarDemo' |
| | | , cellMinWidth: 120 |
| | | , limit: Number.MAX_VALUE // æ°æ®è¡¨æ ¼é»è®¤å
¨é¨æ¾ç¤º |
| | | , totalRow: true |
| | | , height: 'full-70' |
| | | , cols: [col] |
| | | , data: data1.data |
| | | }; |
| | | ins = table.render(option); |
| | | } else { |
| | | option = { |
| | | elem: '#mainTable' |
| | | , toolbar: '#toolbarDemo' |
| | | , cellMinWidth: 120 |
| | | , limit: Number.MAX_VALUE // æ°æ®è¡¨æ ¼é»è®¤å
¨é¨æ¾ç¤º |
| | | , totalRow: true |
| | | , height: 'full-70' |
| | | , cols: [[ |
| | | { type: 'checkbox', fixed: 'left', totalRowText: 'å计' } |
| | | , { field: 'æ¥æ', title: 'æ¥æ', width: 160 } |
| | | , { field: 'ä»»å¡å', title: 'ä»»å¡å', width: 160 } |
| | | , { field: 'å·¥åºæµè½¬å¡å·', title: 'å·¥åºæµè½¬å¡å·', width: 160 } |
| | | , { field: '产ååç§°', title: '产ååç§°', width: 160 } |
| | | , { field: 'è§æ ¼åå·', title: 'è§æ ¼åå·', width: 160 } |
| | | , { field: 'å½åå·¥åº', title: 'å½åå·¥åº', width: 160 } |
| | | , { field: '任塿°é', title: '任塿°é', totalRow: true,width: 160 } |
| | | , { field: 'å¶å人', title: 'å¶å人', width: 200 } |
| | | , { field: 'æµè½¬å¡æ°é', title: 'æµè½¬å¡æ°é', width: 160, totalRow: true } |
| | | ]] |
| | | , done: function (res) { |
| | | //var count = 0; |
| | | //var OnlyID = -1; |
| | | //for (var i = 0; i < res.data.length; i++) { |
| | | // if (res.data[i]["å¯ä¸ID"] != OnlyID) { |
| | | // count += res.data[i]["æ´æ¹"]; |
| | | // OnlyID = res.data[i]["å¯ä¸ID"]; |
| | | // } |
| | | //} |
| | | //var divArr = $(".layui-table-total div.layui-table-cell"); |
| | | //$.each(divArr, function (index, item) { |
| | | // var _div = $(item); |
| | | // var content = _div.html(); |
| | | // if (index == 9) { |
| | | // content = count; |
| | | // } |
| | | // _div.html(content); |
| | | //}); |
| | | } |
| | | }; |
| | | ins = table.render(option); |
| | | } |
| | | }, |
| | | error: function (err) { |
| | | layer.msg('é误' + err, { |
| | | icon: 5, |
| | | time: 20000 |
| | | }, function () { |
| | | //do something |
| | | }); |
| | | } |
| | | }) |
| | | } |
| | | |
| | | //åææ¾ç¤ºä¸ææ¡ |
| | | 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); |
| | | form.render('select'); |
| | | } |
| | | |
| | | |
| | | //å è½½ç½æ ¼ |
| | | function get_Display(sWhere) { |
| | | var wait = layer.load();//é®ç½© |
| | | $.ajax({ |
| | | url: GetWEBURL() + '/MaterOutEntryReport/MaterOutEntryReport_Cloth', |
| | | type: "GET", |
| | | data: { "sWhere": sWhere, "user": sessionStorage["HUserName"] }, |
| | | success: function (data1) { |
| | | if (data1.count == 1) { |
| | | //è°æ´æ¥ææ ¼å¼ï¼æ¾ç¤º å¹´ææ¥ å æ¶ å |
| | | for (var i = 0; i < data1.data.length; i++) { |
| | | if (data1.data[i].æ¥æ != null) { |
| | | data1.data[i].æ¥æ = data1.data[i]["æ¥æ"].split(":")[0] + ":" + data1.data[i]["æ¥æ"].split(":")[1]; |
| | | data1.data[i].æ¥æ = data1.data[i]["æ¥æ"].replace("T", " "); |
| | | } |
| | | } |
| | | |
| | | option.data = data1.data; |
| | | //var num = 0; |
| | | //for (let i = 0; i < data1.data.length; i++) { |
| | | // for (let j = i + 1; j < data1.data.length; j++) { |
| | | // if (data1.data[i].æµè½¬å¡å· === data1.data[j].æµè½¬å¡å·) { |
| | | // //num += data1.data[i].æ´æ¹; |
| | | // //data1.data[i].filter(() => { |
| | | // // return |
| | | // //}) |
| | | // data1.data[j].æ´æ¹ = ''; |
| | | // } |
| | | // } |
| | | //} |
| | | ins = table.render(option); |
| | | |
| | | //计ç®å计å
¬æ¤æ° |
| | | var sumHMaterOutQty = 0; |
| | | for (var i = 0; i < data1.data.length; i++) { |
| | | sumHMaterOutQty += data1.data[i]["ç½å¯åå¸"]; |
| | | } |
| | | $("#SumHMaterOutQty").val(sumHMaterOutQty); |
| | | |
| | | layer.close(wait); |
| | | } else { |
| | | $("#SumHMaterOutQty").val(""); |
| | | layer.close(wait); |
| | | layer.alert(data1.Message, { icon: 5 }); |
| | | } |
| | | }, error: function () { |
| | | $("#SumHMaterOutQty").val(""); |
| | | layer.close(wait); |
| | | layer.alert("æ¥å£è¯·æ±å¤±è´¥!", { icon: 5 }); |
| | | } |
| | | }); |
| | | } |
| | | |
| | | //å¿«éè¿æ»¤ |
| | | function get_FastQuery() { |
| | | var HBeginDate = $("#HBeginDate").val();//ä¸è¾¾æ¥æ å¼å§æ¥æ |
| | | var HEndDate = $("#HEndDate").val();//ç»ææ¥æ |
| | | |
| | | if (HBeginDate == '') { |
| | | HBeginDate = Format(new Date(new Date() - 1000 * 60 * 60 * 24 * 1).setHours(7, 0, 0, 0), "yyyy-MM-dd hh") + ":00:00";//ä¸è¾¾æ¥æ å¼å§æ¥æ |
| | | } else { |
| | | HBeginDate = $("#HBeginDate").val() + ":00:00";//ä¸è¾¾æ¥æ å¼å§æ¥æ |
| | | } |
| | | if (HEndDate == '') { |
| | | HEndDate = Format(new Date(new Date()).setHours(7, 0, 0, 0), "yyyy-MM-dd hh") + ":00:00";//ç»ææ¥æ |
| | | } else { |
| | | HEndDate = $("#HEndDate").val() + ":00:00";//ç»ææ¥æ |
| | | } |
| | | |
| | | //var HBeginDate = $("#HBeginDate").val()+":00:00";//ä¸è¾¾æ¥æ å¼å§æ¥æ |
| | | //var HEndDate = $("#HEndDate").val()+":00:00";//ç»ææ¥æ |
| | | var HMaterNumber = $("#HMaterNumber").val();//ç©æä»£ç |
| | | var HBillNo = $("#HBillNo").val(); //åæ®å· |
| | | var HProductName = $("#HProductName").val();//产ååç§° |
| | | var HProductModel = $("#HProductModel").val();//产åè§æ ¼ |
| | | |
| | | //ä»»æå段æ¡ä»¶è¿æ»¤ æ¡ä»¶æå |
| | | var ColName = $("#ColName").val();//å¤éæ¡ |
| | | var Comparator = $("#Comparator").val() |
| | | var ColContent = $("#ColContent").val(); |
| | | |
| | | //æ¼æ¥ä»»ä¸åæ®µè¿æ»¤æ¥è¯¢æ¡ä»¶ |
| | | var com = ""; |
| | | if (ColName != 0 && Comparator != 0) { |
| | | 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; |
| | | } |
| | | com = " and (" + ColName + " " + com + ")"; |
| | | } |
| | | |
| | | var params = get_UrlVars(); |
| | | if (params[params[0]] != null && detailBar == 0) { |
| | | //æ±æ»æ¥è¡¨çç产订åå· |
| | | HBillNo = params[params[0]]; |
| | | //设置ç产订åå·æ ç¾ |
| | | $("#HBillNo").val(HBillNo); |
| | | |
| | | //设置æ¶é´ä¸ºä¸ä¸ªå¾å¤§çå¼ï¼é»è®¤æç´¢æææ¶é´çæç» |
| | | HBeginDate = "1900-01-01 00:00:00"; |
| | | HEndDate = "2200-01-01 00:00:00"; |
| | | |
| | | detailBar = 1; |
| | | } else { |
| | | HBillNo = $("#HBillNo").val(); //åæ®å· |
| | | } |
| | | |
| | | sWhere = { |
| | | HBeginDate: HBeginDate |
| | | , HEndDate: HEndDate |
| | | , HMaterNumber: HMaterNumber |
| | | , HBillNo: HBillNo |
| | | , HProductName: HProductName |
| | | , HProductModel: HProductModel |
| | | , RandomSearch: com |
| | | } |
| | | |
| | | //set_InitGrid(JSON.stringify(sWhere)); |
| | | get_Display(JSON.stringify(sWhere)); |
| | | //è°ç¨æ¥å£åæ¸
空sWhereç¼å |
| | | sWhere = ""; |
| | |
| | | |
| | | //éç½®è¿æ»¤æ¡ä»¶ |
| | | function set_ClearQuery() { |
| | | $("#HBeginDate").val(Format(new Date(new Date() - 1000 * 60 * 60 * 24 * 30), "yyyy-MM-dd"));//å¼å§æ¥æ |
| | | $("#HEndDate").val(Format(new Date(), "yyyy-MM-dd"));//ç»ææ¥æ |
| | | //åå§åæ¶é´ |
| | | var HBeginDate = Format(new Date(new Date() - 1000 * 60 * 60 * 24 * 1).setHours(7, 0, 0, 0), "yyyy-MM-dd hh"); |
| | | var HEndDate = Format(new Date(new Date()).setHours(7, 0, 0, 0), "yyyy-MM-dd hh"); |
| | | laydate.render({ |
| | | elem: '#HBeginDate', |
| | | type: 'datetime', |
| | | fullPanel: true |
| | | , format: 'yyyy-MM-dd HH' |
| | | , value: HBeginDate |
| | | }); |
| | | laydate.render({ |
| | | elem: '#HEndDate', |
| | | type: 'datetime', |
| | | fullPanel: true |
| | | , format: 'yyyy-MM-dd HH' |
| | | , value: HEndDate |
| | | }); |
| | | |
| | | //$("#HBeginDate").val(Format(new Date(new Date() - 1000 * 60 * 60 * 24 * 30), "yyyy-MM-dd"));//å¼å§æ¥æ |
| | | //$("#HEndDate").val(Format(new Date(), "yyyy-MM-dd"));//ç»ææ¥æ |
| | | $("#HMaterNumber").val(""); |
| | | $("#HBillNo").val(""); |
| | | $("#HProductName").val(""); |
| | |
| | | } |
| | | |
| | | |
| | | //#region 导åºExecel |
| | | function get_Export() { |
| | | var ModRightNameCheck = "Kf_MaterOutEntryReport_Cloth_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 |
| | | |
| | | //éèå设置 |
| | | function get_HideColumn() { |
| | | var colName = ""; |
| | | for (var i = 1; i < option.cols[0].length - 1; i++) { |
| | | for (var i = 1; i < option.cols[0].length; i++) { |
| | | colName += option.cols[0][i]["title"] + ","; |
| | | } |
| | | |
| | |
| | | |
| | | dataCol = data1.data[0].HGridString.split(','); |
| | | |
| | | for (var i = 0; i < option.cols[0].length - 2; i++) { |
| | | for (var i = 0; i < option.cols[0].length - 1; i++) { |
| | | if (dataCol[i]) { |
| | | var dataCols = dataCol[i].split('|'); |
| | | } |