| | |
| | | </ItemGroup> |
| | | <ItemGroup> |
| | | <Content Include="HtmlPage1.html" /> |
| | | <Content Include="img\AIè¯ç.png" /> |
| | | <Content Include="img\icè¯ç.png" /> |
| | | <Content Include="img\åè¿ç´æ¹å¾èæ¯.jpeg" /> |
| | | <Content Include="img\æºè½è¯ç.png" /> |
| | | <Content Include="img\æºè½è¯çï¼.png" /> |
| | | <Content Include="img\çµåææ¯.png" /> |
| | | <Content Include="img\çµè主æ¿.png" /> |
| | | <Content Include="img\è¯ç.png" /> |
| | | <Content Include="layuiadmin\ax\ax-response.css" /> |
| | | <Content Include="layuiadmin\ax\ax.css" /> |
| | | <Content Include="layuiadmin\ax\ax.min.js" /> |
| | |
| | | <Content Include="views\åºæ¶ç®¡ç\æ¥è¡¨åæ\Xs_SeOrderBarCodeInAndOutStockDetailReport.html" /> |
| | | <Content Include="views\åºæ¶ç®¡ç\æ¥è¡¨åæ\YS_CusShouldIncomeMaterEntryReport.html" /> |
| | | <Content Include="views\æ¡ç æç»\Kf_MateOutBillList_CodeDetail.html" /> |
| | | <Content Include="views\æ¡ä¾ä»£ç \åè¿\HY_HistogramReport_ForPCSCheckNote.html" /> |
| | | <Content Include="views\æ¡ä¾ä»£ç \åè¿\HY_HistogramReport.html" /> |
| | | <Content Include="views\æ¡ä¾ä»£ç \åè¿\HY_InterfaceTest.html" /> |
| | | <Content Include="views\模治å
·ç®¡ç\å¨å
·æ¥è¡¨\Sc_MouldLifeUsePicReport.html" /> |
| | | <Content Include="views\模治å
·ç®¡ç\å¨å
·æ¥è¡¨\Sc_MouldDotCheckTaskReport.html" /> |
| | | <Content Include="views\模治å
·ç®¡ç\å¨å
·æ¥è¡¨\Sc_MouldMaintainTaskReport.html" /> |
| | |
| | | <Content Include="views\ç产管ç\å®å·¥æäº§\JIT_LockRequestBill.html" /> |
| | | <Content Include="views\ç产管ç\å®å·¥æäº§\JIT_DayPlanPlatForm.html" /> |
| | | <Content Include="views\ç产管ç\å®å·¥æäº§\JIT_LockRequestBillList.html" /> |
| | | <Content Include="views\ç产管ç\å®å·¥æäº§\ReportPODemandPlanBillList.html" /> |
| | | <Content Include="views\ç产管ç\å®å·¥æäº§\ReportPODemandPlanBillList_S.html" /> |
| | | <Content Include="views\ç产管ç\å®¢æ·æ ç¾\Sc_CustomerTagInfoExcel.html" /> |
| | | <Content Include="views\ç产管ç\å®¢æ·æ ç¾\Sc_CustomerTagInfoEdit.html" /> |
| | | <Content Include="views\ç产管ç\å®¢æ·æ ç¾\Sc_CustomerTagInfoList.html" /> |
| | |
| | | <Content Include="views\ç产管ç\æ¥è®¡ååºç¡èµæ\JIT_NeedMaterPlanConfigBill_Excel.html" /> |
| | | <Content Include="views\ç产管ç\æ¥è®¡åæ¥è¡¨\JIT_DayPlanPlatFormHistoryNoteReport.html" /> |
| | | <Content Include="views\ç产管ç\æ¥è®¡åæ¥è¡¨\JIT_FuHeFenXiReportDetail.html" /> |
| | | <<<<<<< HEAD |
| | | <Content Include="views\ç产管ç\æ¥è®¡åæ¥è¡¨\ReportMOMaterReadysBillTotalList.html" /> |
| | | ======= |
| | | <Content Include="views\ç产管ç\æ¬ æè¿ç®\JIT_MaterialLevelShorAnalysisReport_His.html" /> |
| | | >>>>>>> 0adef152d8494601c9665fd2d690774c662a02fd |
| | | <Content Include="views\ç产管ç\æ¬ æè¿ç®\JIT_MaterialLevelShorAnalysis.html" /> |
| | | <Content Include="views\ç产管ç\æ¬ æè¿ç®\JIT_MaterialLevelShorAnalysisDetailReport.html" /> |
| | | <Content Include="views\ç产管ç\æ¬ æè¿ç®\JIT_MaterialLevelShorAnalysisReport.html" /> |
| | |
| | | <?xml version="1.0" encoding="utf-8"?> |
| | | <Project ToolsVersion="12.0" xmlns="http://schemas.microsoft.com/developer/msbuild/2003"> |
| | | <PropertyGroup> |
| | | <<<<<<< HEAD |
| | | <NameOfLastUsedPublishProfile>D:\æºäºè¿æ\MES\MES-WEB-LayUI\WebTM\Properties\PublishProfiles\FolderProfile.pubxml</NameOfLastUsedPublishProfile> |
| | | <NameOfLastUsedPublishProfile>D:\WorkBench\MES-WEB-LayUI\WebTM\Properties\PublishProfiles\FolderProfile.pubxml</NameOfLastUsedPublishProfile> |
| | | ======= |
| | | <NameOfLastUsedPublishProfile>D:\å·¥ä½ä»£ç \æºäºè¿æ\MES\MES-WEB-LayUI\WebTM\Properties\PublishProfiles\LAYUI.pubxml</NameOfLastUsedPublishProfile> |
| | | >>>>>>> 0adef152d8494601c9665fd2d690774c662a02fd |
| | | <ProjectView>ProjectFiles</ProjectView> |
| | | <LastActiveSolutionConfig>Debug|Any CPU</LastActiveSolutionConfig> |
| | | <UseIISExpress>true</UseIISExpress> |
| | |
| | | //var WEBURL = "http://61.164.86.218:8099/ABAPI/"; |
| | | /*var WEBURL = "http://localhost/API/"; //颿忬å°é
ç½®*/ |
| | | //var WEBURL = "http://localhost:8082/LuBaoAPI/"; //æ¨ä¹æ¬å°é
ç½® |
| | | //var WEBURL = "http://localhost:8082/API/"; //æè´ºæ¬å°é
ç½® |
| | | var WEBURL = "http://localhost:8082/API/"; //å¼ ç广æ¬å°é
ç½® |
| | | var WEBURL = "http://localhost:8082/API/"; //æè´ºæ¬å°é
ç½® |
| | | //var WEBURL = "http://localhost:8082/API/"; //å¼ ç广æ¬å°é
ç½® |
| | | //var WEBURL = "http://localhost:81/API/" //ç¿æ¶æ¶æ¬å°é
ç½® |
| | | //var WEBURL = "http://localhost:8082/LuBaoAPI/"; //æ¨ä¹æ¬å°é
ç½® |
| | | //var WEBURL = "http://localhost:8082/API/"; //æè´ºæ¬å°é
ç½® |
| | | //var WEBURL = "http://localhost:8082/API/"; //å¼ ç广æ¬å°é
ç½® |
| | | var WEBURL = "http://localhost:81/API/" //ç¿æ¶æ¶æ¬å°é
ç½® |
| | | //var WEBURL = "http://localhost:81/API/" //ç¿æ¶æ¶æ¬å°é
ç½® |
| | | //var WEBURL = "http://47.96.97.237/API/"; //æºäºæå¡å¨ |
| | | var WEBURL = "http://localhost:8082/LuBaoAPI/"; //ä½ææ°æ¬å°é
ç½® |
| | | /* var WEBURL = "http://localhost:8082/LuBaoAPI/"; //ä½ææ°æ¬å°é
ç½®*/ |
| | | //var WEBURL = "http://localhost:8088/ARAPI/"; //ä½ææ°æ¬å°é
ç½®(å®ç) |
| | | //var WEBURL = "http://61.164.86.218:8099/ABAPI/"; //å¥¥é¦ |
| | | //var WEBURL = "http://10.1.4.155/API/"; //æ±ä¸°å®¢æ·NEW |
| | |
| | | //var WEBURL = "http://192.168.60.12/API"; //䏿§ |
| | | //var WEBURL = "http://192.168.6.5:8082/API/"; //èæ |
| | | /*var WEBURL = "http://121.36.199.126:8181/API/"; //ä¸å*/ |
| | | var WEBURL = "http://localhost:81/API"; |
| | | //var WEBURL = "http://localhost:81/API"; |
| | | return WEBURL |
| | | } |
| | | |
| | |
| | | //æ¥è¯¢æ¡ä»¶ |
| | | var sWhere = ""; |
| | | |
| | | $("#HDate").val(Format(new Date(new Date() - 1000 * 60 * 60 * 24 * 30), "yyyy-MM-dd")); |
| | | $("#HDate1").val(Format(new Date(), "yyyy-MM-dd")); |
| | | sWhere += " and CONVERT(varchar(100),æ¥æ, 23) >= '" + $("#HDate").val() + "'"; |
| | | sWhere += " and CONVERT(varchar(100),æ¥æ, 23) <= '" + $("#HDate1").val() + "'"; |
| | | |
| | | var index = layer.load(0); |
| | | table.render({ |
| | | elem: '#mainTable' |
| | | , url: GetWEBURL() + '/Sc_ProductionOrder/GetProductionOrderBill' |
| | | , where: { sWhere: "" } //æ©å±åæ°,å¯ä»¥ä¼ æ°æ®å°åå° |
| | | , where: { sWhere: sWhere } //æ©å±åæ°,å¯ä»¥ä¼ æ°æ®å°åå° |
| | | , page: true //å¼å¯å页 |
| | | , limit: 20 //ä¸é¡µè½å¤æ¾ç¤ºçæå¤§æ°ç® |
| | | ,limits: [20, 40,60,80,100] //æ§å¶å¤å°è¡ä¸é¡µï¼é»è®¤äºæ¡ä¸é¡µï¼ |
| | |
| | | function set_AddFNew() { |
| | | $("#HItemID").val("0"); |
| | | $("#HNumber").val(""); |
| | | $("#HMakeEmp").val(sessionStorage["HUserName"]);; //æ ¹æ®ç»å½ç¨æ·å¸¦åºå建人 |
| | | $("#HMakeTime").val(Format(new Date(), "yyyy-MM-dd")); |
| | | } |
| | | //ç¼è¾ |
| | | function set_EditFromGrid() { |
| | |
| | | if (checkStatus.data.length != 1) { |
| | | return layer.msg('è¯·éæ©ä¸æ¡æ°æ®'); |
| | | } |
| | | $("#HMaterClsName").val(checkStatus.data[0].ç©æåç±»åç§°); |
| | | $("#HMaterClsName").val(checkStatus.data[0].åç§°); |
| | | $("#HMaterTypeID").val(checkStatus.data[0].HItemID); |
| | | layer.close(index); //å®è·åçå§ç»æ¯ææ°å¼¹åºçæä¸ªå±ï¼å¼æ¯ç±layerå
é¨å¨æéå¢è®¡ç®ç |
| | | } |
| | |
| | | } |
| | | //è¿åç©æåç±» |
| | | function GetMaterTypeValue(obj) { |
| | | $("#HMaterClsName").val(obj[0].ç©æåç±»åç§°); |
| | | $("#HMaterClsName").val(obj[0].åç§°); |
| | | $("#HMaterTypeID").val(obj[0].HItemID); |
| | | } |
| | | //è¿å计éåä½ |
| | |
| | | function set_AddFNew() { |
| | | $("#HItemID").val("0"); |
| | | $("#HNumber").val(""); |
| | | $("#HMakeEmp").val(sessionStorage["HUserName"]);; //æ ¹æ®ç»å½ç¨æ·å¸¦åºå建人 |
| | | $("#HMakeTime").val(Format(new Date(), "yyyy-MM-dd")); |
| | | } |
| | | //ç¼è¾ |
| | | function set_EditFromGrid() { |
| | |
| | | addSWhere = " and ç¦ç¨æ è®° = ' ' and è½¦é´æ è®° = 'Y' "; |
| | | Organization = HOrgName.toString(); |
| | | } else { |
| | | addSWhere = " and ç¦ç¨æ è®° = '' and ç¦ç¨æ¶é´ is null and ISNULL(å®¡æ ¸äºº,'') <> '' "; |
| | | addSWhere = " and ç¦ç¨æ è®° = '' and ISNULL(å®¡æ ¸äºº,'') <> '' "; |
| | | Organization = HOrgName.toString(); |
| | | } |
| | | } |
| | |
| | | |
| | | //OledbXMLReportData.GenOneRecordset(this, "select * from Customers order by CustomerID"); |
| | | //SqlXMLReportData.GenOneRecordset(this, "select * from h_v_Kf_POStockInBillList_K3 where hmainid=1781"); |
| | | SqlXMLReportData.GenOneRecordset(this, "select * from h_v_Gy_MouldFileList where hmainid=" + Request.Params["linterid"]); |
| | | SqlXMLReportData.GenEntireData(this, "select * from h_v_Gy_MouldFileList where hmainid=" + Request.Params["linterid"], "select 1"); |
| | | } |
| | | </script> |
| | | </head> |
| | |
| | | var openType = params[params[0]]; //ä»åæ°ä¸è·å æå¼æ¹å¼ 1ç´æ¥æå¼ 2å
¶å®é¡µé¢éè¿éæ©æé®æå¼ |
| | | var addSWhere = ""; |
| | | if (typeof (openType) != "undefined") { |
| | | addSWhere = " and ç¦ç¨äºº = '' and å®¡æ ¸äºº != ''"; |
| | | addSWhere = " and ISNULL(ç¦ç¨äºº,'') = '' and isnull(å®¡æ ¸äºº,'') != ''"; |
| | | } |
| | | return addSWhere; |
| | | } |
| New file |
| | |
| | | <!DOCTYPE html> |
| | | <html xmlns="http://www.w3.org/1999/xhtml"> |
| | | <head> |
| | | <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> |
| | | <title>ç´æ¹å¾</title> |
| | | <meta name="renderer" content="webkit"> |
| | | <meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1"> |
| | | <meta name="viewport" content="width=device-width, initial-scale=1, maximum-scale=1"> |
| | | <link rel="stylesheet" href="../../../layuiadmin/layui/css/layui.css" media="all"> |
| | | <link rel="stylesheet" href="../../../layuiadmin/style/admin.css" media="all"> |
| | | <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> |
| | | <script src="../../../layuiadmin/zgqCustom/zgqCustom.js"></script> |
| | | <script src="../../../layuiadmin/HideButton.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;">PNLæ¡ç ç¼å·</label> |
| | | <div class="layui-input-block" style="margin-left: 120px;"> |
| | | <input type="text" class="layui-input" name="HBarCode_PNL" id="HBarCode_PNL"> |
| | | </div> |
| | | </div> |
| | | <div class="layui-inline"> |
| | | <label class="layui-form-label" style="width: 85px;">setæ¡ç ç¼å·</label> |
| | | <div class="layui-input-block" style="margin-left: 120px;"> |
| | | <input type="text" class="layui-input" name="HBarCode_Set" id="HBarCode_Set"> |
| | | </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> |
| | | <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnReSearch" id="btnReSearch" style="padding:0 5px">éç½®</button> |
| | | </div> |
| | | </div> |
| | | <div id="HistogramReport" style = "background-color: black; height: 2000px; width: 100%; display: flex; justify-content: center; "> |
| | | |
| | | </div> |
| | | </form> |
| | | </div> |
| | | </div> |
| | | </div> |
| | | </div> |
| | | <script> |
| | | layui.config({ |
| | | base: '../../../layuiadmin/' //éæèµæºæå¨è·¯å¾ |
| | | }).extend({ |
| | | index: 'lib/index', //主å
¥å£æ¨¡å |
| | | }).use(['index', 'form', 'table', 'element', 'laypage', 'laydate'], 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 |
| | | var HModName = "HY_HistogramReport"; |
| | | |
| | | var HBarCode_PNL_Note = ""; //è®°å½æ¥è¯¢åçPNLæ¡ç ç¼å· |
| | | var HLayOut_PNL = []; //PNLå¸å±ä¿¡æ¯æ°æ® |
| | | //#endregion |
| | | |
| | | //#region è¿å
¥é¡µé¢å³å è½½ |
| | | //#region åå§åçé¢ |
| | | set_ClearBill(); |
| | | //#endregion |
| | | //#endregion |
| | | |
| | | //#region 触åäºä»¶ï¼å
æ¬form.on(){}æ ¼å¼çææç¹å»äºä»¶ãéæ©äºä»¶ç |
| | | //#region éç½®æé® |
| | | form.on('submit(btnReSearch)', function (data) { |
| | | set_ClearQuery(); |
| | | }); |
| | | //#endregion |
| | | |
| | | //#region æ¥è¯¢æé® |
| | | form.on('submit(btnSearch)', function (data) { |
| | | get_FastQuery(2); |
| | | }); |
| | | //#endregion |
| | | |
| | | //#region æ¬é¡µé¢ææè¢«è°ç¨çæ¹æ³ |
| | | |
| | | //#region åå§åçé¢ |
| | | function set_ClearBill() { |
| | | //æ¥è¯¢ |
| | | get_FastQuery(1); |
| | | //Organ(); |
| | | } |
| | | //#endregion |
| | | //#endregion |
| | | |
| | | //#region æ¥è¯¢ |
| | | function get_Display(sql) { |
| | | var ModRightNameCheck = ""; |
| | | $.ajax({ |
| | | url: GetWEBURL() + '/CommonModel/searchMethod', |
| | | async: false, |
| | | type: "GET", |
| | | data: { "sql": sql, "user": sessionStorage["HUserName"], "ModRightNameCheck": ModRightNameCheck}, |
| | | success: function (data1) { |
| | | if (data1.count == 1) { |
| | | for (var i = 0; i < data1.data.length; i++) { |
| | | HLayOut_PNL.push(data1.data[i]); |
| | | } |
| | | } else { |
| | | layer.alert(data1.code + data1.Message, { icon: 5 }); |
| | | } |
| | | }, error: function (e) { |
| | | layer.alert("æ¥å£è¯·æ±å¤±è´¥!" + e, { icon: 5 }); |
| | | } |
| | | }); |
| | | |
| | | } |
| | | //#endregion |
| | | |
| | | //#region å¿«éè¿æ»¤ |
| | | function get_FastQuery(number) { |
| | | var HBarCode_PNL = $("#HBarCode_PNL").val(); //PNLæ¡ç ç¼å· |
| | | var HBarCode_Set = $("#HBarCode_Set").val(); //setæ¡ç ç¼å· |
| | | |
| | | if (HBarCode_PNL != "" && HBarCode_Set != "") { |
| | | layer.alert("PNLæ¡ç ç¼å·ä¸Setæ¡ç ç¼å·åªå¯éæ©ä¸ä¸ªè¿è¡æ¥è¯¢ï¼ï¼", { icon: 5 }); |
| | | //å è½½PNLå¸å±ç´æ¹å¾ |
| | | draw_Histogram([]); |
| | | return; |
| | | } |
| | | |
| | | //æå¼å è½½é®ç½© |
| | | var ajaxLoad = layer.load(); |
| | | |
| | | //è·åPNLå¸å±çå·¦ä¾§å¤ææ°æ® |
| | | var sql = "exec h_p_HY_HistogramReport '" + HBarCode_PNL + "','" + HBarCode_Set + "','left'"; |
| | | get_Display(sql); |
| | | //è·åPNLå¸å±çä¸é´æ°æ® |
| | | var sql = "exec h_p_HY_HistogramReport '" + HBarCode_PNL + "','" + HBarCode_Set + "','center'"; |
| | | get_Display(sql); |
| | | //è·åPNLå¸å±çå³ä¾§å¤ææ°æ® |
| | | var sql = "exec h_p_HY_HistogramReport '" + HBarCode_PNL + "','" + HBarCode_Set + "','right'"; |
| | | get_Display(sql); |
| | | |
| | | //æ´æ° å
¨å±PNLæ¡ç ç¼å· |
| | | if (HLayOut_PNL.length > 0) { |
| | | HBarCode_PNL_Note = HLayOut_PNL[0]["HBarCode_PNL"]; |
| | | } else { |
| | | HBarCode_PNL_Note = ""; |
| | | } |
| | | |
| | | //å è½½PNLå¸å±ç´æ¹å¾ |
| | | draw_Histogram(HLayOut_PNL); |
| | | |
| | | //å è½½PNLå¸å±ä¸PCSççå¬äºä»¶ |
| | | set_buttonClickListener(HLayOut_PNL); |
| | | |
| | | //æ¸
空PNLå¸å±æ°æ® |
| | | HLayOut_PNL = []; |
| | | |
| | | //å
³éå è½½é®ç½© |
| | | layer.close(ajaxLoad); |
| | | |
| | | } |
| | | //#endregion |
| | | |
| | | //#region éç½®è¿æ»¤æ¡ä»¶æ¹æ³ |
| | | function set_ClearQuery() { |
| | | $("#HBarCode_PNL").val(""); |
| | | $("#HBarCode_Set").val(""); |
| | | sWhere = ""; |
| | | } |
| | | //#endregion |
| | | |
| | | //#region å·æ° |
| | | function get_Refresh() { |
| | | $("#btnSearch").trigger('click'); |
| | | } |
| | | //#endregion |
| | | |
| | | //#region æéå¤å® |
| | | function set_ModCheck(ModRightNameCheck) { |
| | | var Permission = false; |
| | | $.ajax({ |
| | | type: "GET", |
| | | url: GetWEBURL() + "/LMES/getReportByModRightNameCheck", //æ¹æ³æå¨é¡µé¢åæ¹æ³å |
| | | async: false, |
| | | data: { "ModRightNameCheck": ModRightNameCheck, "user": sessionStorage["HUserName"] }, |
| | | success: function (result) { |
| | | if (result.count == 1) { |
| | | Permission = true; |
| | | } else { |
| | | layer.alert("å½åæ¨¡åæ²¡ææ¥è¯¢æé!", { icon: 5 }); |
| | | } |
| | | }, error: function () { |
| | | layer.alert("æ¥å£è¯·æ±å¤±è´¥!", { icon: 5 }); |
| | | } |
| | | }); |
| | | return Permission; |
| | | } |
| | | //#endregion |
| | | |
| | | //#region æ ¹æ®æ°æ®ç»å¶ç´æ¹å¾ |
| | | function draw_Histogram(data) { |
| | | var HSetNo = ""; //è®°å½ä¸ä¸ä¸ªPCSæå±çsetå· |
| | | var HPosition_x = 0; //è®°å½ä¸ä¸ä¸ªPCSçè¡ç´¢å¼ |
| | | var HIconUrl = ""; //è®°å½PCS徿 èµæºçä½ç½® |
| | | |
| | | var HContainerElementID = "HistogramReport"; //ç´æ¹å¾å®¹å¨id |
| | | var HCurrentElementID_Set = ""; //å½åset容å¨id |
| | | |
| | | if (data.length > 0) { |
| | | HIconUrl = data[0]["HIcon"]; |
| | | } |
| | | |
| | | //è·åç´æ¹å¾å®¹å¨å¯¹è±¡ |
| | | var HContainerElement_0 = document.getElementById(HContainerElementID); |
| | | |
| | | // éåç´æ¹å¾å®¹å¨å¯¹è±¡ä¸çææåå
ç´ å¹¶ä»DOMä¸ç§»é¤ |
| | | while (HContainerElement_0.firstChild) { |
| | | HContainerElement_0.removeChild(HContainerElement_0.firstChild); |
| | | } |
| | | |
| | | //éåçæç´æ¹å¾ |
| | | for (var i = 0; i < data.length; i++) { |
| | | //妿å½åPCSæå±çsetå· ä¸è®°å½ç ä¸ä¸ä¸ªPCSæå±çsetå· ä¸ä¸è´ï¼åéè¦å建æ°çsetå®¹å¨ |
| | | if (data[i]["HSetNo"] != HSetNo) { |
| | | //è·åç´æ¹å¾å®¹å¨å¯¹è±¡ |
| | | var HContainerElement = document.getElementById(HContainerElementID); |
| | | |
| | | //setå®¹å¨ |
| | | var HContainerElement_Set = document.createElement('div'); //setå®¹å¨ |
| | | HContainerElement_Set.id = data[i]["HSetNo"]; //set容å¨çid为setå· |
| | | HContainerElement_Set.className = "layui-inline"; |
| | | HContainerElement_Set.style = "margin-left:20px;"; |
| | | |
| | | //å°set容卿·»å å°ç´æ¹å¾å®¹å¨å¯¹è±¡ä¸ |
| | | HContainerElement.appendChild(HContainerElement_Set); |
| | | |
| | | //è®°å½ å½åset容å¨id |
| | | HCurrentElementID_Set = data[i]["HSetNo"]; |
| | | } |
| | | |
| | | //æ ¹æ® å½åset容å¨id è·å å½åset容å¨å¯¹è±¡ |
| | | var HCurrentElement_Set = document.getElementById(HCurrentElementID_Set); |
| | | |
| | | //PCSå®¹å¨ |
| | | var HContainerElement_PCS = document.createElement('div'); //PCSå®¹å¨ |
| | | HContainerElement_PCS.id = data[i]["HPCSNo"]; //PCS容å¨çid为PCSå· |
| | | HContainerElement_PCS.style = "border: 2px solid black;"; //设置PCSç徿 |
| | | HContainerElement_PCS.className = "layui-inline"; |
| | | if (data[i]["HSetNo"] == HSetNo && data[i]["HPosition_x"] != HPosition_x) { //ç¸åset容å¨ä¸ï¼å½åPCSçè¡ç´¢å¼ä¸ä¸ä¸ä¸ªPCSçè¡ç´¢å¼ä¸ä¸è´ï¼åæ¢è¡ |
| | | var HBrElement_PCS = document.createElement('br'); |
| | | HCurrentElement_Set.appendChild(HBrElement_PCS); |
| | | } |
| | | |
| | | //PCSæ°æ®ç»´æ¤æé® |
| | | var HButtonElement_PCS = document.createElement('button'); //PCS容å¨ä¸çæé® |
| | | HButtonElement_PCS.id = data[i]["HPCSNo"] + "_Button"; |
| | | HButtonElement_PCS.setAttribute('lay-filter', data[i]["HPCSNo"] + "_Button"); |
| | | HButtonElement_PCS.type = "button"; |
| | | HButtonElement_PCS.className = "layui-btn layuiadmin-btn-order"; |
| | | if (data[i]["HIsBadFlag"] == "1" && data[i]["HCheckProc"] == "ç¬æ£®VRSå
å±") { |
| | | HButtonElement_PCS.style = "background-image: url('" + HIconUrl + "'); background-size: cover; background-position: center; background-repeat: no-repeat;background-color:red;"; |
| | | } |
| | | else if (data[i]["HIsBadFlag"] == "1" && data[i]["HCheckProc"] == "ç¬æ£®VRSå¤å±") { |
| | | HButtonElement_PCS.style = "background-image: url('" + HIconUrl + "'); background-size: cover; background-position: center; background-repeat: no-repeat;background-color:orange;"; |
| | | } |
| | | else if (data[i]["HIsBadFlag"] == "1" && data[i]["HCheckProc"] == "AVI") { |
| | | HButtonElement_PCS.style = "background-image: url('" + HIconUrl + "'); background-size: cover; background-position: center; background-repeat: no-repeat;background-color:yellow;"; |
| | | } |
| | | else if (data[i]["HIsBadFlag"] == "1" && data[i]["HCheckProc"] == "çµæµ") { |
| | | HButtonElement_PCS.style = "background-image: url('" + HIconUrl + "'); background-size: cover; background-position: center; background-repeat: no-repeat;background-color:green;"; |
| | | } |
| | | else { |
| | | HButtonElement_PCS.style = "background-image: url('" + HIconUrl + "'); background-size: cover; background-position: center; background-repeat: no-repeat;background-color:black;"; |
| | | } |
| | | |
| | | ////å°PCSæ°æ®ç»´æ¤æé®æ·»å å°PCS容å¨å¯¹è±¡ä¸ |
| | | HContainerElement_PCS.appendChild(HButtonElement_PCS); |
| | | |
| | | //å°PCS容卿·»å å°set容å¨å¯¹è±¡ä¸ |
| | | HCurrentElement_Set.appendChild(HContainerElement_PCS); |
| | | |
| | | HSetNo = data[i]["HSetNo"]; |
| | | HPosition_x = data[i]["HPosition_x"]; |
| | | }; |
| | | } |
| | | //#endregion |
| | | |
| | | //#region 设置PCSççå¬äºä»¶ |
| | | function set_buttonClickListener(data) { |
| | | for (var i = 0; i < data.length; i++) { |
| | | var elementID = data[i]["HPCSNo"] + "_Button"; |
| | | var element = document.getElementById(elementID); |
| | | |
| | | if (element == null) { |
| | | continue; |
| | | } else { |
| | | element.addEventListener('click', function (event) { |
| | | var PCSNo_Button = event.currentTarget.id; //è·å触åäºä»¶çå
ç´ çID |
| | | var PCSElement_Button = document.getElementById(PCSNo_Button); //è·åPCSæé®å
ç´ |
| | | var PCSElement_Div = PCSElement_Button.parentElement; //è·åPCSæé®å
ç´ æå¨çPCS容å¨å
ç´ |
| | | var SetElement_Div = PCSElement_Div.parentElement; //è·åPCS容å¨å
ç´ æå¨çset容å¨å
ç´ |
| | | var PCSNo = PCSElement_Div.id; //PCSå· |
| | | var SetNo = SetElement_Div.id; //setå· |
| | | |
| | | var title = "PNLæ¡ç ç¼å·ï¼" + HBarCode_PNL_Note + "ï¼setå·ï¼" + SetNo + "ï¼PCSå·ï¼" + PCSNo; |
| | | layer.open({ |
| | | type: 2 |
| | | , skin: "layui-layer-rim" //å ä¸è¾¹æ¡ |
| | | , title: "PCSæ£éªä¿¡æ¯ç»´æ¤ï¼" + title + "ï¼" //æ é¢ |
| | | , closeBtn: 1 //çªä½å³ä¸è§å
³é ç æ ·å¼ |
| | | , shift: 2 //å¼¹åºå¨ç» |
| | | , area: ["50%", "80%"] //çªä½å¤§å° |
| | | , maxmin: true //设置æå¤§æå°æé®æ¯å¦æ¾ç¤º |
| | | , content: ['./HY_HistogramReport_ForPCSCheckNote.html?HBarCode_PNL=' + HBarCode_PNL_Note + "&HSetNo=" + SetNo + "&PCSNo=" + PCSNo, "yes"] |
| | | }) |
| | | }); |
| | | } |
| | | } |
| | | } |
| | | //#endregion |
| | | }); |
| | | |
| | | //#endregion |
| | | </script> |
| | | |
| | | </body> |
| | | </html> |
| 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> |
| | | <style> |
| | | /* 鲿¢ä¸ææ¡ç䏿å表被éè---å¿
须设置--- */ |
| | | .layui-table-cell { |
| | | overflow: visible !important; |
| | | } |
| | | /* 使å¾ä¸ææ¡ä¸åå
æ ¼å好åé */ |
| | | td .layui-form-select { |
| | | margin-top: -10px; |
| | | margin-left: -15px; |
| | | margin-right: -15px; |
| | | } |
| | | </style> |
| | | </head> |
| | | <body> |
| | | <div class="layui-fluid" style="padding: 0;"> |
| | | <div class="layui-card" style="padding: 2px;background-color: #efefef;"> |
| | | <div class="layui-card-body" style="padding: 1px;"> |
| | | <form class="layui-form" action="" lay-filter="formData" style="background-color:white;"> |
| | | <div style="padding: 10px;"> |
| | | <button class="layui-btn layui-btn-normal" type="button" lay-submit="" lay-filter="add" id="add">æ°å¢</button> |
| | | <button class="layui-btn layui-btn-normal" type="button" lay-submit="" lay-filter="edit" id="edit">ä¿®æ¹</button> |
| | | <button class="layui-btn layui-btn-normal" type="button" lay-submit="" lay-filter="delete" id="delete">å é¤</button> |
| | | <button class="layui-btn layui-btn-normal" type="button" lay-submit="" lay-filter="exit" id="exit">éåº</button> |
| | | </div> |
| | | </form> |
| | | </div> |
| | | </div> |
| | | </div> |
| | | </body> |
| | | </html> |
| | | <script> |
| | | layui.config({ |
| | | base: '../../../layuiadmin/' //éæèµæºæå¨è·¯å¾ |
| | | }).extend({ |
| | | index: 'lib/index' //主å
¥å£æ¨¡å |
| | | }).use(['index', 'form', 'laydate', 'table', 'element'], function () { |
| | | //#region å
Œ
±åé |
| | | var $ = layui.$ |
| | | , admin = layui.admin |
| | | , layer = layui.layer |
| | | , table = layui.table |
| | | , form = layui.form |
| | | , element = layui.element; |
| | | //#endregion |
| | | |
| | | //#region è·ååæ°ä¿¡æ¯ |
| | | //è·å页é¢è·³è½¬åæ° |
| | | var params = get_UrlVars(); |
| | | var HBarCode_PNL = params[params[0]]; //PNLæ¡ç ç¼å· |
| | | var HSetNo = params[params[1]]; //setå· |
| | | var HPCSNo = params[params[2]]; //PCSå· |
| | | //#endregion |
| | | |
| | | //#region 触åäºä»¶ï¼å
æ¬form.on(){}æ ¼å¼çææç¹å»äºä»¶ãéæ©äºä»¶ç |
| | | //#regionæé®çå¬ æ°å¢ |
| | | form.on('submit(add)', function (data) { |
| | | alert("1"); |
| | | }); |
| | | //#endregion |
| | | |
| | | //#regionæé®çå¬ ä¿®æ¹ |
| | | form.on('submit(edit)', function (data) { |
| | | alert("2"); |
| | | }); |
| | | //#endregion |
| | | |
| | | //#regionæé®çå¬ å é¤ |
| | | form.on('submit(delete)', function (data) { |
| | | alert("3"); |
| | | }); |
| | | //#endregion |
| | | |
| | | //#regionéåº |
| | | form.on('submit(exit)', function () { |
| | | Pub_Close(1); |
| | | }) |
| | | //#endregion |
| | | //#endregion |
| | | }); |
| | | </script> |
| New file |
| | |
| | | <!DOCTYPE html> |
| | | <html> |
| | | <head> |
| | | <meta charset="utf-8" /> |
| | | <title>éå®è®¢åç¼è¾</title> |
| | | <meta name="renderer" content="webkit"> |
| | | <meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1"> |
| | | <meta name="viewport" content="width=device-width, initial-scale=1.0, minimum-scale=1.0, maximum-scale=1.0, user-scalable=0"> |
| | | <link rel="stylesheet" href="../../../layuiadmin/layui/css/layui.css" media="all"> |
| | | <link rel="stylesheet" href="../../../layuiadmin/style/admin.css" media="all"> |
| | | <script src="../../../layuiadmin/layui/layui.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> |
| | | <script src="../../../layuiadmin/zgqCustom/zgqCustom.js"></script> |
| | | <script src="../../../layuiadmin/PageTitle.js"></script> |
| | | <style> |
| | | /*.main-btn {*/ /*头é¨ä¸»æé®*/ |
| | | /*padding: 0 2px;*/ /*è°æ´æé®å·¦å³ç©ºé大å°*/ |
| | | /*height: 30px; |
| | | line-height: 30px; |
| | | }*/ |
| | | |
| | | .btn-title { |
| | | font-size: 16px; |
| | | } |
| | | /* 鲿¢ä¸ææ¡ç䏿å表被éè---å¿
须设置--- */ |
| | | .layui-table-cell { |
| | | overflow: visible !important; |
| | | } |
| | | /* 使å¾ä¸ææ¡ä¸åå
æ ¼å好åé */ |
| | | td .layui-form-select { |
| | | margin-top: -10px; |
| | | margin-left: -15px; |
| | | margin-right: -15px; |
| | | } |
| | | |
| | | /* .layui-form-item .layui-inline { |
| | | margin-top: 0px; |
| | | margin-bottom: 5px; |
| | | margin-right: 0px; |
| | | } |
| | | |
| | | .layui-form-label { |
| | | width: 25%; |
| | | }*/ |
| | | </style> |
| | | </head> |
| | | <body> |
| | | |
| | | <div class="layui-fluid" style="padding: 0;"> |
| | | <div class="layui-card" style="padding: 15px;"> |
| | | <div class="layui-card-body" style="padding: 1px;"> |
| | | <form class="layui-form" lay-filter="component-form-group" action=""> |
| | | <div class="layui-card-header"> |
| | | <div class="layui-btn-group"> |
| | | <button type="button" id="add-btn" class="layui-btn layui-btn-normal layui-btn-radius" lay-submit="" lay-filter="set_SaveBill">ç¬æ£®VRSå
屿£éªç»æä¸ä¼ æ¥å£</button> |
| | | <button type="button" id="add-btn1" class="layui-btn layui-btn-normal layui-btn-radius" lay-submit="" lay-filter="set_SaveBill1">ç¬æ£®VRSå¤å±è·ådatamappingæ°æ®æ¥å£</button> |
| | | <button type="button" id="add-btn2" class="layui-btn layui-btn-normal layui-btn-radius" lay-submit="" lay-filter="set_SaveBill2">ç¬æ£®VRSå¤å±æ£éªç»æä¸ä¼ æ¥å£</button> |
| | | <button type="button" id="add-btn3" class="layui-btn layui-btn-normal layui-btn-radius" lay-submit="" lay-filter="set_SaveBill3">AVIè·ådatamappingæ°æ®æ¥å£</button> |
| | | <button type="button" id="add-btn4" class="layui-btn layui-btn-normal layui-btn-radius" lay-submit="" lay-filter="set_SaveBill4">AVIæ£éªç»æä¸ä¼ æ¥å£</button> |
| | | <button type="button" id="add-btn5" class="layui-btn layui-btn-normal layui-btn-radius" lay-submit="" lay-filter="set_SaveBill5">çµæµè·ådatamappingæ°æ®æ¥å£</button> |
| | | <button type="button" id="add-btn6" class="layui-btn layui-btn-normal layui-btn-radius" lay-submit="" lay-filter="set_SaveBill6">çµæµæ£éªç»æä¸ä¼ æ¥å£</button> |
| | | <button type="button" id="add-btn7" class="layui-btn layui-btn-normal layui-btn-radius" lay-submit="" lay-filter="set_SaveBill7">æ¿å
å²è·ådatamappingæ°æ®æ¥å£</button> |
| | | </div> |
| | | </div> |
| | | </form> |
| | | </div> |
| | | </div> |
| | | </div> |
| | | <script> |
| | | //#region æå 注é |
| | | var HDataEmp = {}; |
| | | //#endregion |
| | | layui.config({ |
| | | base: '../../../layuiadmin/' //éæèµæºæå¨è·¯å¾ |
| | | }).extend({ |
| | | index: 'lib/index' //主å
¥å£æ¨¡å |
| | | }).use(['index', 'form', 'laydate', 'table', 'element', 'tableSelect'], function () { |
| | | |
| | | //#region å
¬ç¨åé |
| | | var $ = layui.$ |
| | | , admin = layui.admin |
| | | , layer = layui.layer |
| | | , table = layui.table |
| | | , form = layui.form |
| | | , laydate = layui.laydate |
| | | , element = layui.element |
| | | , tableSelect = layui.tableSelect; |
| | | |
| | | |
| | | //#region 表头æé®è§¦åäºä»¶ |
| | | //#region æé®çå¬ ç¬æ£®VRSå
屿£éªç»æä¸ä¼ æ¥å£ |
| | | form.on('submit(set_SaveBill)', function (data) { |
| | | VRSInner_saveCheckNote(data); |
| | | }); |
| | | //#endregion |
| | | |
| | | //#region æé®çå¬ ç¬æ£®VRSå¤å±è·ådatamappingæ°æ®æ¥å£ |
| | | form.on('submit(set_SaveBill1)', function (data) { |
| | | getDataMapping_VRSOuter(); |
| | | }); |
| | | //#endregion |
| | | |
| | | //#region æé®çå¬ ç¬æ£®VRSå¤å±æ£éªç»æä¸ä¼ æ¥å£ |
| | | form.on('submit(set_SaveBill2)', function (data) { |
| | | VRSOuter_saveCheckNote(data); |
| | | }); |
| | | //#endregion |
| | | |
| | | //#region æé®çå¬ AVIè·ådatamappingæ°æ®æ¥å£ |
| | | form.on('submit(set_SaveBill3)', function (data) { |
| | | getDataMapping_AVI(); |
| | | }); |
| | | //#endregion |
| | | |
| | | //#region æé®çå¬ AVIæ£éªç»æä¸ä¼ æ¥å£ |
| | | form.on('submit(set_SaveBill4)', function (data) { |
| | | AVI_saveCheckNote(data); |
| | | }); |
| | | //#endregion |
| | | |
| | | //#region æé®çå¬ çµæµè·ådatamappingæ°æ®æ¥å£ |
| | | form.on('submit(set_SaveBill5)', function (data) { |
| | | getDataMapping_DC(); |
| | | }); |
| | | //#endregion |
| | | |
| | | //#region æé®çå¬ çµæµæ£éªç»æä¸ä¼ æ¥å£ |
| | | form.on('submit(set_SaveBill6)', function (data) { |
| | | DC_saveCheckNote(data); |
| | | }); |
| | | //#endregion |
| | | |
| | | //#region æé®çå¬ æ¿å
å²è·ådatamappingæ°æ®æ¥å£ |
| | | form.on('submit(set_SaveBill7)', function (data) { |
| | | getDataMapping_JGG(); |
| | | }); |
| | | //#endregion |
| | | |
| | | //#region ç¬æ£®VRSå
屿£éªç»æä¸ä¼ æ¥å£ |
| | | function VRSInner_saveCheckNote(data) { |
| | | var param = []; |
| | | param.push({ |
| | | HBarCode: "112" |
| | | , HPCSNo: "0101" |
| | | , HPosition_x: 1 |
| | | , HPosition_y: 1 |
| | | , HPageIndex: 0 |
| | | , HBadReason: "æµè¯" |
| | | }); |
| | | param.push({ |
| | | HBarCode: "112" |
| | | , HPCSNo: "0102" |
| | | , HPosition_x: 1 |
| | | , HPosition_y: 2 |
| | | , HPageIndex: 1 |
| | | , HBadReason: "æµè¯" |
| | | }); |
| | | |
| | | var params = {}; |
| | | params.HMaker = sessionStorage["HUserName"]; |
| | | params.param = param; |
| | | |
| | | var sMainStr = JSON.stringify(params); |
| | | |
| | | $.ajax({ |
| | | type: "POST", |
| | | url: GetWEBURL() + "/VRSInner/VRSInner_saveCheckNote", //æ¹æ³æå¨é¡µé¢åæ¹æ³å |
| | | async: true, |
| | | data: { "sMainSub": sMainStr }, |
| | | dataType: "json", |
| | | success: function (data) { |
| | | if (data.count == 1) { // 说æéªè¯æåäºï¼ |
| | | layer.msg(data.msg, { icon: 5 }); |
| | | } |
| | | else { |
| | | layer.alert(data.msg, { icon: 5 }); |
| | | } |
| | | }, |
| | | error: function (err) { |
| | | layer.alert("é误:" + err, { icon: 5 }); |
| | | } |
| | | }); |
| | | } |
| | | //#endregion |
| | | |
| | | //#region ç¬æ£®VRSå¤å±è·ådatamappingæ°æ®æ¥å£ |
| | | function getDataMapping_VRSOuter() { |
| | | var HBarCode = "111"; |
| | | $.ajax({ |
| | | url: GetWEBURL() + '/VRSOuter/VRSOuter_getDataMapping' |
| | | ,async: false |
| | | ,type: "GET" |
| | | ,data: { "HBarCode": HBarCode } |
| | | ,success: function (data1) { |
| | | if (data1.code == "1") { |
| | | var resultData = JSON.stringify(data1.data); |
| | | layer.alert(data1.code + resultData, { icon: 5 }); |
| | | } else { |
| | | layer.alert(data1.code + data1.msg, { icon: 5 }); |
| | | } |
| | | } |
| | | , error: function (e) { |
| | | layer.alert("æ¥å£è¯·æ±å¤±è´¥!" + e, { icon: 5 }); |
| | | } |
| | | }); |
| | | } |
| | | //#endregion |
| | | |
| | | //#region ç¬æ£®VRSå¤å±æ£éªç»æä¸ä¼ æ¥å£ |
| | | function VRSOuter_saveCheckNote(data) { |
| | | var param = []; |
| | | param.push({ |
| | | HBarCode: "112" |
| | | , HPCSNo: "1110101" |
| | | , HPosition_x: 1 |
| | | , HPosition_y: 1 |
| | | , HPageIndex: 0 |
| | | , HBadReason: "æµè¯" |
| | | }); |
| | | param.push({ |
| | | HBarCode: "112" |
| | | , HPCSNo: "1110102" |
| | | , HPosition_x: 1 |
| | | , HPosition_y: 2 |
| | | , HPageIndex: 0 |
| | | , HBadReason: "æµè¯" |
| | | }); |
| | | |
| | | var params = {}; |
| | | params.HMaker = sessionStorage["HUserName"]; |
| | | params.param = param; |
| | | |
| | | var sMainStr = JSON.stringify(params); |
| | | |
| | | $.ajax({ |
| | | type: "POST", |
| | | url: GetWEBURL() + "/VRSOuter/VRSOuter_saveCheckNote", //æ¹æ³æå¨é¡µé¢åæ¹æ³å |
| | | async: true, |
| | | data: { "sMainSub": sMainStr }, |
| | | dataType: "json", |
| | | success: function (data) { |
| | | if (data.count == 1) { // 说æéªè¯æåäºï¼ |
| | | layer.msg(data.msg, { icon: 5 }); |
| | | } |
| | | else { |
| | | layer.alert(data.msg, { icon: 5 }); |
| | | } |
| | | }, |
| | | error: function (err) { |
| | | layer.alert("é误:" + err, { icon: 5 }); |
| | | } |
| | | }); |
| | | } |
| | | //#endregion |
| | | |
| | | //#region AVIè·ådatamappingæ°æ®æ¥å£ |
| | | function getDataMapping_AVI() { |
| | | var HBarCode = "112"; |
| | | $.ajax({ |
| | | url: GetWEBURL() + '/AVI/AVI_getDataMapping' |
| | | , async: false |
| | | , type: "GET" |
| | | , data: { "HBarCode": HBarCode } |
| | | , success: function (data1) { |
| | | if (data1.code == "1") { |
| | | var resultData = JSON.stringify(data1.data); |
| | | layer.alert(data1.code + resultData, { icon: 5 }); |
| | | } else { |
| | | layer.alert(data1.code + data1.msg, { icon: 5 }); |
| | | } |
| | | } |
| | | , error: function (e) { |
| | | layer.alert("æ¥å£è¯·æ±å¤±è´¥!" + e, { icon: 5 }); |
| | | } |
| | | }); |
| | | } |
| | | //#endregion |
| | | |
| | | //#region AVIæ£éªç»æä¸ä¼ æ¥å£ |
| | | function AVI_saveCheckNote(data) { |
| | | var param = []; |
| | | param.push({ |
| | | HBarCode: "112" |
| | | , HPCSNo: "1110101" |
| | | , HPosition_x: 1 |
| | | , HPosition_y: 1 |
| | | , HPageIndex: 0 |
| | | , HBadReason: "æµè¯" |
| | | }); |
| | | param.push({ |
| | | HBarCode: "112" |
| | | , HPCSNo: "1110102" |
| | | , HPosition_x: 1 |
| | | , HPosition_y: 2 |
| | | , HPageIndex: 0 |
| | | , HBadReason: "æµè¯" |
| | | }); |
| | | |
| | | var params = {}; |
| | | params.HMaker = sessionStorage["HUserName"]; |
| | | params.param = param; |
| | | |
| | | var sMainStr = JSON.stringify(params); |
| | | |
| | | $.ajax({ |
| | | type: "POST", |
| | | url: GetWEBURL() + "/AVI/AVI_saveCheckNote", //æ¹æ³æå¨é¡µé¢åæ¹æ³å |
| | | async: true, |
| | | data: { "sMainSub": sMainStr }, |
| | | dataType: "json", |
| | | success: function (data) { |
| | | if (data.count == 1) { // 说æéªè¯æåäºï¼ |
| | | layer.msg(data.msg, { icon: 5 }); |
| | | } |
| | | else { |
| | | layer.alert(data.msg, { icon: 5 }); |
| | | } |
| | | }, |
| | | error: function (err) { |
| | | layer.alert("é误:" + err, { icon: 5 }); |
| | | } |
| | | }); |
| | | } |
| | | //#endregion |
| | | |
| | | //#region çµæµè·ådatamappingæ°æ®æ¥å£ |
| | | function getDataMapping_DC() { |
| | | var HBarCode = "11201"; |
| | | $.ajax({ |
| | | url: GetWEBURL() + '/DC/DC_getDataMapping' |
| | | , async: false |
| | | , type: "GET" |
| | | , data: { "HBarCode": HBarCode } |
| | | , success: function (data1) { |
| | | if (data1.code == "1") { |
| | | var resultData = JSON.stringify(data1.data); |
| | | layer.alert(data1.code + resultData, { icon: 5 }); |
| | | } else { |
| | | layer.alert(data1.code + data1.msg, { icon: 5 }); |
| | | } |
| | | } |
| | | , error: function (e) { |
| | | layer.alert("æ¥å£è¯·æ±å¤±è´¥!" + e, { icon: 5 }); |
| | | } |
| | | }); |
| | | } |
| | | //#endregion |
| | | |
| | | //#region çµæµæ£éªç»æä¸ä¼ æ¥å£ |
| | | function DC_saveCheckNote(data) { |
| | | var param = []; |
| | | param.push({ |
| | | HBarCode: "11201" |
| | | , HPCSNo: "0101" |
| | | , HPosition_x: 1 |
| | | , HPosition_y: 1 |
| | | , HPageIndex: 0 |
| | | , HBadReason: "æµè¯" |
| | | }); |
| | | param.push({ |
| | | HBarCode: "11201" |
| | | , HPCSNo: "0102" |
| | | , HPosition_x: 1 |
| | | , HPosition_y: 2 |
| | | , HPageIndex: 0 |
| | | , HBadReason: "æµè¯" |
| | | }); |
| | | |
| | | var params = {}; |
| | | params.HMaker = sessionStorage["HUserName"]; |
| | | params.param = param; |
| | | |
| | | var sMainStr = JSON.stringify(params); |
| | | |
| | | $.ajax({ |
| | | type: "POST", |
| | | url: GetWEBURL() + "/DC/DC_saveCheckNote", //æ¹æ³æå¨é¡µé¢åæ¹æ³å |
| | | async: true, |
| | | data: { "sMainSub": sMainStr }, |
| | | dataType: "json", |
| | | success: function (data) { |
| | | if (data.count == 1) { // 说æéªè¯æåäºï¼ |
| | | layer.msg(data.msg, { icon: 5 }); |
| | | } |
| | | else { |
| | | layer.alert(data.msg, { icon: 5 }); |
| | | } |
| | | }, |
| | | error: function (err) { |
| | | layer.alert("é误:" + err, { icon: 5 }); |
| | | } |
| | | }); |
| | | } |
| | | //#endregion |
| | | |
| | | //#region æ¿å
å²è·ådatamappingæ°æ®æ¥å£ |
| | | function getDataMapping_JGG() { |
| | | var HBarCode = "11201"; |
| | | $.ajax({ |
| | | url: GetWEBURL() + '/JGG/JGG_getDataMapping' |
| | | , async: false |
| | | , type: "GET" |
| | | , data: { "HBarCode": HBarCode } |
| | | , success: function (data1) { |
| | | if (data1.code == "1") { |
| | | var resultData = JSON.stringify(data1.data); |
| | | layer.alert(data1.code + resultData, { icon: 5 }); |
| | | } else { |
| | | layer.alert(data1.code + data1.msg, { icon: 5 }); |
| | | } |
| | | } |
| | | , error: function (e) { |
| | | layer.alert("æ¥å£è¯·æ±å¤±è´¥!" + e, { icon: 5 }); |
| | | } |
| | | }); |
| | | } |
| | | //#endregion |
| | | }); |
| | | |
| | | </script> |
| | | </body> |
| | | </html> |
| | |
| | | shift: 2, |
| | | area: ['80%', '80%'], |
| | | maxmin: true |
| | | , content: ['../../../views/åºç¡èµæ/å
¬ç¨åºç¡èµæ/Gy_Unit.html?Type=HUnitList&openType=2', 'yes'], |
| | | , content: ['../../../views/åºç¡èµæ/å
¬ç¨åºç¡èµæ/Gy_Unit.html?Type=HUnitList&openType=' + sessionStorage["Organization"], 'yes'], |
| | | btn: ['ç¡®å®', 'åæ¶'] |
| | | , btn1: function (index, layero) { |
| | | |
| | |
| | | shift: 2, |
| | | area: ['80%', '80%'], |
| | | maxmin: true |
| | | , content: ['../../../views/åºç¡èµæ/å
¬ç¨åºç¡èµæ/Gy_Unit.html?Type=HUnitList&openType=2', 'yes'], |
| | | , content: ['../../../views/åºç¡èµæ/å
¬ç¨åºç¡èµæ/Gy_Unit.html?Type=HUnitList&openType=' + sessionStorage["Organization"], 'yes'], |
| | | btn: ['ç¡®å®', 'åæ¶'] |
| | | , btn1: function (index, layero) { |
| | | |
| | |
| | | , shade: 0.6 //é®ç½©éæåº¦ |
| | | , maxmin: false //å
许å
¨å±æå°å |
| | | , anim: 0 //0-6çå¨ç»å½¢å¼ï¼-1ä¸å¼å¯ |
| | | , content: ['../../BaseSet/SRM_OpenTmpList.html?linterid=' + data[0].hmainid.toString() + '&MyMsg=' + data[0].hmainid.toString() + '&Type=HEquipFileMainBill', 'yes'] |
| | | , content: ['../../BaseSet/SRM_OpenTmpList.html?linterid=' + data[0].hmainid.toString() + '&MyMsg=' + data[0].hmainid.toString() + '&Type=HMouldFileMainBill', 'yes'] |
| | | , resize: false |
| | | }) |
| | | } |
| | |
| | | function get_PrintReport() { |
| | | var checkStatus = table.checkStatus('mainTable') |
| | | , data = checkStatus.data; |
| | | if (checkStatus.data.length === 1) { |
| | | if (checkStatus.data.length >= 1) { |
| | | var rows = []; |
| | | for (var i = 0; i < data.length; i++) { |
| | | rows.push(data[i].hmainid.toString()); |
| | | } |
| | | |
| | | layer.open({ |
| | | type: 2 |
| | | , area: ['50%', '50%'] |
| | |
| | | , shade: 0.6 //é®ç½©éæåº¦ |
| | | , maxmin: false //å
许å
¨å±æå°å |
| | | , anim: 0 //0-6çå¨ç»å½¢å¼ï¼-1ä¸å¼å¯ |
| | | , content: ['../../BaseSet/SRM_OpenTmpList.html?linterid=' + data[0].hmainid.toString() + '&MyMsg=' + data[0].hmainid.toString() + '&Type=HEquipFileMainBill', 'yes'] |
| | | , content: ['../../BaseSet/SRM_OpenTmpList.html?linterid=' + rows.toString() + '&MyMsg=' + rows.toString() + '&Type=HMouldFileMainBill', 'yes'] |
| | | , resize: false |
| | | }) |
| | | } |
| | |
| | | <button class="layui-btn layui-btn-normal" style="margin-left: 0px" type="button" lay-submit="" lay-filter="btnUnlockRequest" id="btnUnlock">è§£éç³è¯·</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>--> |
| | | <!--<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="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="btn_Calculate" id="btn_Calculate">æ¬ æè¿ç®</button>--> |
| | | <!--<button class="layui-btn layui-btn-normal" style="margin-left: 0px" type="button" lay-submit="" lay-filter="btnRoutEdit" id="btnRoutEdit">å·¥èºè·¯çº¿</button>--> |
| | |
| | | var lastDay = new Date(year, month, 0).getDate(); //彿æåä¸å¤© |
| | | var thisDay = new Date().getDay(); //å½å¤©æ¯æ¬æç¬¬å 天 |
| | | |
| | | var valueList = [7, lastDay - thisDay+1,31,40]; |
| | | var titleList = ["7天", "æ¬æ","31天","40天"]; |
| | | var valueList = [7, lastDay - thisDay+1,31,40,50]; |
| | | var titleList = ["7天", "æ¬æ","31天","40天","50天"]; |
| | | |
| | | var HArrangeProductDayQty_ArrayList = ''; |
| | | for (var i = 0; i < valueList.length; i++) { |
| | |
| | | columns.push({ field: 'ç©æåç§°', title: 'ç©æåç§°', width: 150}); |
| | | columns.push({ field: 'è§æ ¼åå·', title: 'è§æ ¼åå·', width: 150 }); |
| | | columns.push({ field: 'å°æ¶äº§è½', title: 'å°æ¶äº§è½', width: 150, edit: 'text' }); |
| | | columns.push({ field: '产线æ»äº§è½', title: '产线æ»äº§è½', width: 150, edit: 'text' }); |
| | | columns.push({ field: 'éå®è®¢åæ°é', title: 'éå®è®¢åæ°é', width: 150 });//0 |
| | | columns.push({ field: 'è®¡åæ°é', title: 'çäº§è®¢åæ°é', width: 150 });//0 |
| | | columns.push({ field: 'æ¥è®¡åæ°éæ»é', title: 'æ¥è®¡åæ°éæ»é', width: 150 });//0 |
| 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> |
| | | <script src="../../../layuiadmin/soulTable.slim.js"></script> |
| | | <script src="../../../layuiadmin/SetColumn.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 class="layui-inline"> |
| | | <label class="layui-form-label" style="width: 85px;padding: 9px 18px;">产åç¼ç </label> |
| | | <div class="layui-input-block" style="margin-left: 77px;"> |
| | | <input type="hidden" class="layui-input" lay-verify="HMATERIALID" name="HMATERIALID" id="HMATERIALID" value="0" style="background-color:#efefef4d;width: 60%;display: inline-block;" readonly> |
| | | <input type="text" class="layui-input" lay-verify="HMATERIALNAME" name="HMATERIALNAME" id="HMATERIALNAME" value="" style="background-color:#efefef4d;width: 60%;display: inline-block;" readonly> |
| | | <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnHMATERIALID" id="btnHMATERIALID" style="padding: 0 10px;float: right;margin-right: 3px;"> |
| | | <i class="layui-icon layui-icon-search layuiadmin-button-btn"></i> |
| | | </button> |
| | | </div> |
| | | </div> |
| | | <div class="layui-inline"> |
| | | <label class="layui-form-label" style="width: 85px;padding: 9px 18px;">ä¾åºå</label> |
| | | <div class="layui-input-block" style="margin-left: 77px;"> |
| | | <input type="hidden" class="layui-input" lay-verify="HSUPPLIERID" name="HSUPPLIERID" id="HSUPPLIERID" value="0" style="background-color:#efefef4d;width: 60%;display: inline-block;" readonly> |
| | | <input type="text" class="layui-input" lay-verify="HSUPPLIERNAME" name="HSUPPLIERNAME" id="HSUPPLIERNAME" value="" style="background-color:#efefef4d;width: 60%;display: inline-block;" readonly> |
| | | <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnHSUPPLIERID" id="btnHSUPPLIERID" style="padding: 0 10px;float: right;margin-right: 3px;"> |
| | | <i class="layui-icon layui-icon-search layuiadmin-button-btn"></i> |
| | | </button> |
| | | </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="text" class="layui-input" name="HXQD" id="HXQD"> |
| | | </div> |
| | | </div> |
| | | </div> |
| | | <div class="layui-row" style="margin: 10px 0 10px;"> |
| | | <div class="layui-inline"> |
| | | <label class="layui-form-label" style="width: 85px;">éè´è®¢åå·</label> |
| | | <div class="layui-input-block" style="margin-left: 120px;"> |
| | | <input type="text" class="layui-input" name="HPURORDERNO" id="HPURORDERNO"> |
| | | </div> |
| | | </div> |
| | | </div> |
| | | |
| | | <hr /> |
| | | </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> |
| | | <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> |
| | | </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','soulTable'], 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 |
| | | , soulTable = layui.soulTable |
| | | var sWhere = ""; |
| | | var option = []; |
| | | var HModName = "ReportPODemandPlanBillList"; |
| | | var ins = []; |
| | | //#endregion |
| | | |
| | | //#region è¿å
¥é¡µé¢å³å è½½ |
| | | |
| | | //åå§åçé¢ |
| | | set_ClearBill(); |
| | | |
| | | //#endregion |
| | | |
| | | //#region 触åäºä»¶ï¼å
æ¬form.on(){}æ ¼å¼çææç¹å»äºä»¶ãéæ©äºä»¶ç |
| | | |
| | | //头工å
·æ äºä»¶ |
| | | table.on('toolbar(mainTable)', function (obj) { |
| | | switch (obj.event) { |
| | | //éèå设置 |
| | | case 'HideColumn': |
| | | get_HideColumnNoPageForPlan(HModName, option, get_FastQuery); |
| | | break; |
| | | //导åºexcel |
| | | case 'get_export': |
| | | get_Export(); |
| | | break; |
| | | }; |
| | | }); |
| | | |
| | | //#region 产åç¼ç |
| | | form.on('submit(btnHMATERIALID)', function (data) { |
| | | btnHMATERIALID(); |
| | | }); |
| | | //#endregion |
| | | |
| | | //#region ä¾åºå |
| | | form.on('submit(btnHSUPPLIERID)', function (data) { |
| | | btnHSUPPLIERID(); |
| | | }); |
| | | //#endregion |
| | | |
| | | //#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(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); |
| | | |
| | | ColFilter(); |
| | | } |
| | | //#endregion |
| | | |
| | | //#region åå§åè¡¨æ ¼æ¹æ³ |
| | | function set_InitGrid() { |
| | | var columns = []; |
| | | |
| | | columns.push({ type: 'checkbox', fixed: 'left', sort: true}); |
| | | columns.push({ field: 'ç»ç»', title: 'éè´ç»ç»', sort: true}); |
| | | columns.push({ field: 'ç©æåç§°', title: 'ç©æåç§°', sort: true}); |
| | | columns.push({ field: 'è§æ ¼åå·', title: 'ç©æè§æ ¼', sort: true}); |
| | | columns.push({ field: 'ä¾åºå', title: 'ä¾åºå', sort: true}); |
| | | columns.push({ field: 'FSUMQTY', title: 'å计', sort: true}); |
| | | columns.push({ field: 'HPOOrderBillNo', title: 'éè´è®¢åå·', sort: true}); |
| | | columns.push({ field: 'HSeOrderBillNo', title: 'éå®è®¢åå·', sort: true}); |
| | | columns.push({ field: 'HPOOrderBillRemark', title: 'æè¦', sort: true }); |
| | | columns.push({ field: 'HPOOrderBillNote', title: '夿³¨', sort: true}); |
| | | columns.push({ field: 'éè´å', 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++) { |
| | | var time_temp = Format(yyyy + '/' + MM + '/' + (HBEGINDATE + j), 'yyyy-MM-dd'); |
| | | if (isValidDate(time_temp)) { |
| | | columns.push({ |
| | | field: Format(yyyy + '/' + MM + '/' + (HBEGINDATE + j), 'yyyy-MM-dd'), title: Format(yyyy + '/' + MM + '/' + (HBEGINDATE + j), 'MM.dd'), width: 70, totalRow: true, templet: function (d) { |
| | | //è·åå½åä»å¤©æå¤©å天ä¸å¤©çæ¥æå符串 |
| | | const dates = []; |
| | | const today = new Date(); |
| | | for (let i = 0; i < 3; i++) { |
| | | const date = new Date(today); |
| | | date.setDate(today.getDate() + i); |
| | | const dateStr = date.toISOString().slice(0, 10); |
| | | dates.push(`${dateStr}`); |
| | | } |
| | | // å¦æè¡æ¥æå¨å½åæ¥æä¸å¤©åï¼åå
容æ 红 |
| | | if ((this.field == dates[0] || this.field == dates[1]) && d[this.field] != null) { |
| | | return '<span style="color:Orange">' + (d[this.field] == null ? 0 : d[this.field]) + '</span>'; |
| | | } |
| | | else if ((this.field == dates[2]) && d[this.field] != null) { |
| | | return '<span style="color:red">' + (d[this.field] == null ? 0 : d[this.field]) + '</span>'; |
| | | } |
| | | else { |
| | | return d[this.field] == null ? 0 : d[this.field] |
| | | } |
| | | } |
| | | }) |
| | | } else { |
| | | 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: 'ææè®¡åå计' }); |
| | | |
| | | option = { |
| | | elem: '#mainTable' |
| | | , toolbar: '#toolbarDemo' |
| | | , height: 'full-50' |
| | | , page: false |
| | | , cellMinWidth: 90 |
| | | , totalRow: true |
| | | , limit: 20000 |
| | | , limits: [50, 500, 5000, 20000] |
| | | , loading: false |
| | | , cols: [columns] |
| | | , done: function (res, curr, count) { |
| | | soulTable.render(this); |
| | | } |
| | | }; |
| | | } |
| | | //#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_Cg_PODemandPlanBill/ReportPODemandPlanBillList', |
| | | type: "GET", |
| | | data: { "sWhere": sWhere, "user": sessionStorage["HUserName"] }, |
| | | success: function (result) { |
| | | if (result.count == 1) { |
| | | option.data = result.data; |
| | | //å设置 |
| | | DisPlay_HideColumnForPlan(HModName, sessionStorage["HUserName"], option); |
| | | ins = 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"]);//ç»ç» |
| | | $("#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("0");//ç©æ/产å |
| | | $("#HMATERIALNAME").val(""); |
| | | $("#HSUPPLIERID").val("0");//ä¾åºå |
| | | $("#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: ['../../åºç¡èµæ/å
¬ç¨åºç¡èµæ/Gy_Material.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].ç©æåç§°); |
| | | 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?Type=HSup', '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_Export() { |
| | | var data = option.data; |
| | | data.forEach((item) => { |
| | | for (let itemobj in item) { |
| | | if (item[itemobj] == null) { |
| | | item[itemobj] = ""; |
| | | } |
| | | if (item[itemobj].length > 0) { // åè®¾åæ®µå为field |
| | | item[itemobj] = item[itemobj].toString().replace(/[\r\n]+/g, ''); // å°æ¢è¡ç¬¦æ¿æ¢ä¸ºç©ºå符串 |
| | | } |
| | | } |
| | | }); |
| | | table.exportFile(ins.config.id, data, "xls"); |
| | | } |
| | | |
| | | // çé彿°ï¼æ£æ¥å符串æ¯å¦ç¬¦åæ ¼å¼ç鿥æ |
| | | function isValidDate(dateStr) { |
| | | // æ£å表达å¼éªè¯æ ¼å¼ |
| | | const formatRegex = /^\d{4}-(0[1-9]|1[0-2])-(0[1-9]|[12][0-9]|3[01])$/; |
| | | if (!formatRegex.test(dateStr)) return false; |
| | | |
| | | // åå²å¹´ææ¥å¹¶è½¬æ¢ä¸ºæ°å¼ |
| | | const [year, month, day] = dateStr.split('-').map(Number); |
| | | |
| | | // å建Dateå¯¹è±¡ï¼æä»½ä»0å¼å§ï¼ |
| | | const date = new Date(year, month - 1, day); |
| | | |
| | | // æ£æ¥æ¥ææ¯å¦ææï¼ä¸è¾å
¥çå¹´ææ¥ä¸è´ï¼ |
| | | return ( |
| | | date.getFullYear() === year && |
| | | date.getMonth() === month - 1 && |
| | | date.getDate() === day |
| | | ); |
| | | } |
| | | |
| | | //åææ¾ç¤ºä¸ææ¡ |
| | | 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); |
| | | $("#ColName1").empty(); |
| | | $("#ColName1").append(Organization); |
| | | $("#ColName2").empty(); |
| | | $("#ColName2").append(Organization); |
| | | |
| | | form.render('select'); |
| | | } |
| | | //#endregion |
| | | //以䏿¯layui模å |
| | | }); |
| | | function GetHSupNameValue(obj) { |
| | | $("#HSUPPLIERID").val(obj[0].HItemID); |
| | | $("#HSUPPLIERNAME").val(obj[0].ä¾åºååç§°); |
| | | } |
| | | function GetGyMaterial(obj) { |
| | | $("#HMATERIALID").val(obj.HItemID); |
| | | $("#HMATERIALNAME").val(obj.ç©æåç§°); |
| | | } |
| | | </script> |
| 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"> |
| | | <link rel="stylesheet" href="../../../layuiadmin/ext/soulTable.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> |
| | | <script src="../../../layuiadmin/SetColumn.js"></script> |
| | | <!--<script src="../../../layuiadmin/soulTable.slim.js"></script>--><!--æ é¢çéä¸è½å¼ç¨æ¤jsæä»¶--> |
| | | </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> |
| | | <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnExport" id="btnExport">导åº</button> |
| | | <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="bthHideColumn" id="bthHideColumn">å设置</button> |
| | | <div class="layui-colla-content" style="padding: 0px; margin-left: 6%;"> |
| | | <div class="layui-row" style="margin-top:10px;"> |
| | | <div class="layui-inline"> |
| | | <label class="layui-form-label" style="width: 85px;padding: 9px 18px;">产åç¼ç </label> |
| | | <div class="layui-input-block" style="margin-left: 77px;"> |
| | | <input type="hidden" class="layui-input" lay-verify="HMATERIALID" name="HMATERIALID" id="HMATERIALID" value="0" style="background-color:#efefef4d;width: 60%;display: inline-block;" readonly> |
| | | <input type="text" class="layui-input" lay-verify="HMATERIALNAME" name="HMATERIALNAME" id="HMATERIALNAME" value="" style="background-color:#efefef4d;width: 60%;display: inline-block;" readonly> |
| | | <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnHMATERIALID" id="btnHMATERIALID" style="padding: 0 10px;float: right;margin-right: 3px;"> |
| | | <i class="layui-icon layui-icon-search layuiadmin-button-btn"></i> |
| | | </button> |
| | | </div> |
| | | </div> |
| | | <div class="layui-inline"> |
| | | <label class="layui-form-label" style="width: 85px;padding: 9px 18px;">ä¾åºå</label> |
| | | <div class="layui-input-block" style="margin-left: 77px;"> |
| | | <input type="hidden" class="layui-input" lay-verify="HSUPPLIERID" name="HSUPPLIERID" id="HSUPPLIERID" value="0" style="background-color:#efefef4d;width: 60%;display: inline-block;" readonly> |
| | | <input type="text" class="layui-input" lay-verify="HSUPPLIERNAME" name="HSUPPLIERNAME" id="HSUPPLIERNAME" value="" style="background-color:#efefef4d;width: 60%;display: inline-block;" readonly> |
| | | <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnHSUPPLIERID" id="btnHSUPPLIERID" style="padding: 0 10px;float: right;margin-right: 3px;"> |
| | | <i class="layui-icon layui-icon-search layuiadmin-button-btn"></i> |
| | | </button> |
| | | </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="text" class="layui-input" name="HXQD" id="HXQD"> |
| | | </div> |
| | | </div> |
| | | </div> |
| | | <div class="layui-row" style="margin: 10px 0 10px;"> |
| | | <div class="layui-inline"> |
| | | <label class="layui-form-label" style="width: 85px;">éè´è®¢åå·</label> |
| | | <div class="layui-input-block" style="margin-left: 120px;"> |
| | | <input type="text" class="layui-input" name="HPURORDERNO" id="HPURORDERNO"> |
| | | </div> |
| | | </div> |
| | | </div> |
| | | </div> |
| | | </div> |
| | | </div> |
| | | <table class="" id="mainTable" lay-filter="mainTable"></table> |
| | | </form> |
| | | </div> |
| | | </div> |
| | | </div> |
| | | </div> |
| | | </body> |
| | | </html> |
| | | <script> |
| | | var treeCkData = { id: 0 }; |
| | | var TagId = ""; |
| | | var TagParentId = ""; |
| | | layui.config({ |
| | | base: '../../../layuiadmin/' //éæèµæºæå¨è·¯å¾ |
| | | }).extend({ |
| | | index: 'lib/index', //主å
¥å£æ¨¡å |
| | | soulTable: '../ext/soulTable', |
| | | }).use(['tree', 'index', 'form', 'table', 'element', 'laypage', 'laydate', 'util','soulTable','flow'], 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 |
| | | , soulTable = layui.soulTable |
| | | , flow = layui.flow |
| | | var sWhere = " where 1=1 "; |
| | | var option = []; |
| | | var ins; //ç¨äºå¯¼åºexcel |
| | | var HModName = "ReportPODemandPlanBillList_S"; |
| | | //#endregion |
| | | |
| | | //#region è¿å
¥é¡µé¢å³å è½½ |
| | | |
| | | //åå§åçé¢ |
| | | set_ClearBill(); |
| | | |
| | | //#endregion |
| | | |
| | | //#region 触åäºä»¶ï¼å
æ¬form.on(){}æ ¼å¼çææç¹å»äºä»¶ãéæ©äºä»¶ç |
| | | |
| | | //#region 产åç¼ç |
| | | form.on('submit(btnHMATERIALID)', function (data) { |
| | | btnHMATERIALID(); |
| | | }); |
| | | //#endregion |
| | | |
| | | //#region ä¾åºå |
| | | form.on('submit(btnHSUPPLIERID)', function (data) { |
| | | btnHSUPPLIERID(); |
| | | }); |
| | | //#endregion |
| | | |
| | | //#region éç½®æé® |
| | | form.on('submit(btnReSearch)', function (data) { |
| | | set_ClearQuery(); |
| | | }); |
| | | //#endregion |
| | | |
| | | //#region æ¥è¯¢æé® |
| | | form.on('submit(btnSearch)', function (data) { |
| | | get_FastQuery(2); |
| | | }); |
| | | //#endregion |
| | | |
| | | //#region å¯¼åºæé® |
| | | form.on('submit(btnExport)', function (data) { |
| | | getExportData(); |
| | | }); |
| | | //#endregion |
| | | |
| | | //#region å设置æé® |
| | | form.on('submit(bthHideColumn)', function (data) { |
| | | get_HideColumnNoPageForPlan(HModName, option, get_FastQuery); |
| | | }); |
| | | //#endregion |
| | | |
| | | //#endregion |
| | | |
| | | //#region æ¬é¡µé¢è¢«è°ç¨çæææ¹æ³ |
| | | |
| | | //#region åå§åçé¢ |
| | | function set_ClearBill() { |
| | | //åå§åæ¥æ |
| | | $("#HBEGINDATE").val(Format(new Date(new Date() - 1000 * 60 * 60 * 24 * 25), "yyyy-MM-dd"));//æææ¥æ |
| | | var HEndDate = Format(new Date().setDate(new Date().getDate() + 25), "yyyy-MM-dd"); |
| | | $("#HENDDATE").val(HEndDate);//è³ |
| | | //ç产ç»ç»å è½½ |
| | | Organ(); |
| | | |
| | | //å¿«éè¿æ»¤ |
| | | get_FastQuery(1); |
| | | |
| | | ColFilter(); |
| | | } |
| | | //#endregion |
| | | |
| | | //#region åå§åè¡¨æ ¼æ¹æ³ |
| | | function set_InitGrid() { |
| | | var columns = []; |
| | | |
| | | columns.push({ type: 'checkbox', fixed: 'left', sort: true}); |
| | | columns.push({ field: 'ç»ç»', title: 'éè´ç»ç»', sort: true, filter: true }); |
| | | columns.push({ field: 'FMATERIALNAME', title: 'ç©æåç§°', sort: true, filter: true }); |
| | | columns.push({ field: 'FSPECIFICATION', title: 'ç©æè§æ ¼', sort: true, filter: true }); |
| | | columns.push({ field: 'FNAME', title: 'ä¾åºå', sort: true, filter: true }); |
| | | columns.push({ field: 'FSUMQTY', title: 'å计', sort: true, hide: true, filter: true }); |
| | | columns.push({ field: 'HPOOrderBillNo', title: 'éè´è®¢åå·', sort: true, hide: true, filter: true }); |
| | | columns.push({ field: 'HSeOrderBillNo', title: 'éæ±åå·', sort: true, hide: true, filter: true }); |
| | | //columns.push({ field: 'HPOOrderBillRemark', title: 'æè¦' }); |
| | | //columns.push({ field: 'HPOOrderBillNote', title: '夿³¨' }); |
| | | //columns.push({ field: 'éè´å', title: 'éè´å' }); |
| | | columns.push({ field: 'FNUMBER', title: 'ç©æç¼ç ', sort: true, filter: true }); |
| | | columns.push({ field: '计éåä½åç§°', title: '计éåä½', sort: true, filter: true }); |
| | | columns.push({ field: 'TQSUM', title: 'æææææ°é', sort: true, totalRow: true, filter: true }); |
| | | columns.push({ field: 'TQSUM', title: 'æææææ°é', sort: true, totalRow: true, filter: true }); |
| | | columns.push({ field: 'é¾ææææ»å', title: 'é¾ææææ»å', sort: true, totalRow: true, filter: true }); |
| | | columns.push({ field: 'æææ»å', title: 'æææ»å', sort: true, totalRow: true, filter: true }); |
| | | //è·å两个ææä¹é´çç¸å·® |
| | | var time1 = Date.parse(new Date());//å¼å§æ¶é´ |
| | | var time2 = Date.parse(new Date($("#HENDDATE").val()));//ç»ææ¶é´ |
| | | var Days = Math.abs(parseInt((time2 - time1) / 1000 / 3600 / 24)); |
| | | //è·åå¹´ |
| | | var yyyy = new Date().getFullYear(); |
| | | //è·åæä»½ |
| | | var MM = new Date().getMonth() + 1; |
| | | //è·åå¼å§æä»½çæå¤§å¤©æ° |
| | | var SumMonth = new Date(yyyy, MM, 0).getDate(); //卿䏤æä¹å·® |
| | | //è·åå¼å§æ¥æçå¤©æ° |
| | | var HBEGINDATE = new Date(new Date()).getDate(); //è·åå¼å§æ¥æå¤©æ° |
| | | |
| | | var k = 0;//æ¶éå¾ªç¯æ¬¡æ° |
| | | for (var j = 0; j <= (Days - k); j++) { |
| | | var time_temp = Format(yyyy + '/' + MM + '/' + (HBEGINDATE + j), 'yyyy-MM-dd'); |
| | | if (isValidDate(time_temp)) { |
| | | columns.push({ |
| | | field: Format(yyyy + '/' + MM + '/' + (HBEGINDATE + j), 'yyyy-MM-dd'), title: Format(yyyy + '/' + MM + '/' + (HBEGINDATE + j), 'MM.dd'), width: 70, totalRow: true, filter: true, templet: function (d) { |
| | | //è·åå½åä»å¤©æå¤©å天ä¸å¤©çæ¥æå符串 |
| | | const dates = []; |
| | | const today = new Date(); |
| | | for (let i = 0; i < 3; i++) { |
| | | const date = new Date(today); |
| | | date.setDate(today.getDate() + i); |
| | | const dateStr = date.toISOString().slice(0, 10); |
| | | dates.push(`${dateStr}`); |
| | | } |
| | | // å¦æè¡æ¥æå¨å½åæ¥æä¸å¤©åï¼åå
容æ 红 |
| | | if ((this.field == dates[0] || this.field == dates[1]) && d[this.field] != null) { |
| | | return '<span style="color:Orange">' + (d[this.field] == null ? 0 : d[this.field]) + '</span>'; |
| | | } |
| | | else if ((this.field == dates[2]) && d[this.field] != null) { |
| | | return '<span style="color:red">' + (d[this.field] == null ? 0 : d[this.field]) + '</span>'; |
| | | } |
| | | else { |
| | | return d[this.field] == null ? 0 : d[this.field] |
| | | } |
| | | } }) |
| | | } else { |
| | | columns.push({ field: Format(yyyy + '/' + MM + '/' + (HBEGINDATE + j), 'yyyy-MM-dd'), title: Format(yyyy + '/' + MM + '/' + (HBEGINDATE + j), 'MM.dd'), width: 70, totalRow: true, filter: 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: 'ææè®¡åå计', filter: true }); |
| | | |
| | | option = { |
| | | elem: '#mainTable' |
| | | //, toolbar: '#toolbarDemo' |
| | | , height: 'full-50' |
| | | , page: true |
| | | , cellMinWidth: 90 |
| | | , limit: 1000 |
| | | , limits: [50, 500,1000, 5000, 20000] |
| | | , totalRow: true |
| | | , loading: false |
| | | , cols: [columns] |
| | | , done: function (res, curr, count) { |
| | | soulTable.render(this); |
| | | } |
| | | }; |
| | | } |
| | | //#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_Cg_PODemandPlanBill/ReportPODemandPlanBillList_S', |
| | | type: "GET", |
| | | data: { "sWhere": sWhere, "user": sessionStorage["HUserName"], HBEGINDATE: $("#HBEGINDATE").val(), HENDDATE: $("#HENDDATE").val() }, |
| | | success: function (result) { |
| | | if (result.count == 1) { |
| | | |
| | | option.data = result.data; |
| | | //å设置 |
| | | DisPlay_HideColumnForPlan(HModName, sessionStorage["HUserName"], option); |
| | | ins = 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 getExportData() { |
| | | data = option.data; |
| | | data.forEach((item) => { |
| | | for (let itemobj in item) { |
| | | if (item[itemobj] == null) { |
| | | item[itemobj] = ""; |
| | | } |
| | | if (item[itemobj].length > 0) { // åè®¾åæ®µå为field |
| | | item[itemobj] = item[itemobj].toString().replace(/[\r\n]+/g, ''); // å°æ¢è¡ç¬¦æ¿æ¢ä¸ºç©ºå符串 |
| | | } |
| | | } |
| | | }); |
| | | table.exportFile(ins.config.id, data, "xls"); |
| | | } |
| | | //#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("å¼å§æ¥æä¸è½å°äºç»ææ¥æ!"); |
| | | } |
| | | |
| | | if (HORGID != "") { |
| | | sWhere += " and a.HPURCHASEORGID= " + HORGID+" "; |
| | | } |
| | | |
| | | if (HBEGINDATE != null && HENDDATE != null) { |
| | | sWhere += " and HDate between ''" + HBEGINDATE + "'' and ''" + HENDDATE + "'' "; |
| | | } |
| | | if (HMATERIALID!=0) { |
| | | sWhere += " and B.HMaterID= " + HMATERIALID+" "; |
| | | } |
| | | if (HSUPPLIERID!=0) { |
| | | sWhere += " and A.HSupplierID= " + HSUPPLIERID + " "; |
| | | } |
| | | if (HXQD) { |
| | | sWhere += " and HSeOrderBillNo like''% " + HXQD + "%'' "; |
| | | } |
| | | if (HPURORDERNO) { |
| | | sWhere += " and HPOOrderBillNo like''%" + HPURORDERNO + "%'' "; |
| | | } |
| | | //åå§åè¡¨æ ¼ |
| | | set_InitGrid(); |
| | | get_Display(sWhere); |
| | | sWhere = " where 1=1 ";//è°ç¨æ¥å£åæ¸
空sWhereç¼å |
| | | } |
| | | //#endregion |
| | | |
| | | //#region éç½®è¿æ»¤æ¡ä»¶æ¹æ³ |
| | | function set_ClearQuery() { |
| | | $("#HORGID").val(sessionStorage["OrganizationID"]);//ç»ç» |
| | | $("#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(""); |
| | | $("#HSUPPLIERID").val("");//ä¾åºå |
| | | $("#HSUPPLIERNAME").val(""); |
| | | $("#HXQD").val("");//éæ±åå· |
| | | $("#HPURORDERNO").val("");//éè´è®¢åå· |
| | | form.render('select'); |
| | | sWhere = " where 1=1 "; |
| | | } |
| | | //#endregion |
| | | |
| | | //ç©æå表 |
| | | function btnHMATERIALID() { |
| | | layer.open({ |
| | | type: 2 //ç±»å |
| | | , skin: 'layui-layer-rim'//å ä¸è¾¹æ¡ |
| | | , area: ['90%', '90%']//å¤§å° |
| | | , title: 'ç©æå表'//æ é¢ |
| | | , shift: 2//å¼¹åºå¨ç» |
| | | , content: ['../../åºç¡èµæ/å
¬ç¨åºç¡èµæ/Gy_Material.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].ç©æåç§°); |
| | | 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?Type=HSup', '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 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); |
| | | $("#ColName1").empty(); |
| | | $("#ColName1").append(Organization); |
| | | $("#ColName2").empty(); |
| | | $("#ColName2").append(Organization); |
| | | |
| | | form.render('select'); |
| | | } |
| | | |
| | | //#endregion |
| | | //以䏿¯layui模å |
| | | }); |
| | | function GetHSupNameValue(obj) { |
| | | $("#HSUPPLIERID").val(obj[0].HItemID); |
| | | $("#HSUPPLIERNAME").val(obj[0].ä¾åºååç§°); |
| | | } |
| | | function GetGyMaterial(obj) { |
| | | $("#HMATERIALID").val(obj.HItemID); |
| | | $("#HMATERIALNAME").val(obj.ç©æåç§°); |
| | | } |
| | | </script> |
| | |
| | | , "HStopBeginWorkTime": data.å¼å§åå·¥æ¶é´ |
| | | , "HStopEndWorkTime": data.ç»æåå·¥æ¶é´ |
| | | , "HSourceID": data.HSourceID //èµæºID |
| | | , "HSourceName": data.èµæºåç§° //èµæºåç§° |
| | | , "HSourceName": data.çäº§èµæº //èµæºåç§° |
| | | , "HEmpID": data.HEmpID //æä½åID |
| | | , "HEmpName": data.ç³è¯·å¼å·¥äººå //æä½å |
| | | , "HEmpName": data.ç³è¯·å工人å //æä½å |
| | | , "HMainSourceInterID": data.HMainSourceInterID //æºåID |
| | | , "HMainSourceEntryID": data.HMainSourceEntryID //æºååID(è¡å·) |
| | | , "HMainSourceBillNo": data.HMainSourceBillNo //æºååå· |
| | | , "HMainSourceBillType": data.HMainSourceBillType //æºåç±»å |
| | | , "HGroupID": data.HGroupID //çç»ID |
| | | , "HGroupName": data.çç»åç§° //çç»åç§° |
| | | , "HGroupName": data.ç产çç» //çç»åç§° |
| | | , "HDeptID": data.HDeptID //é¨é¨ID |
| | | , "HDeptName": data.é¨é¨åç§° //é¨é¨åç§° |
| | | , "HDeptName": data.çäº§è½¦é´ //é¨é¨åç§° |
| | | , "HICMOInterID": data.HICMOInterID //ç产订å主ID |
| | | , "HICMOEntryID": data.HICMOEntryID //ç产订ååID |
| | | , "HICMOBillNo": data.HICMOBillNo |
| | |
| | | continue; // è·³è¿é对象项ï¼å¦ç©ºæ°ç»ï¼ |
| | | } |
| | | |
| | | if (option.data[i]["HRelationBillNo"] == "") { |
| | | layer.msg("第" + i + "è¡ï¼å¯äº§è®¡ååæªéæ©ï¼"); |
| | | return false; |
| | | } |
| | | //if (option.data[i]["HRelationBillNo"] == "") { |
| | | // layer.msg("第" + i + "è¡ï¼å¯äº§è®¡ååæªéæ©ï¼"); |
| | | // return false; |
| | | //} |
| | | |
| | | if (option.data[i]["HProcID"] == "0") { |
| | | layer.msg("第" + i + "è¡ï¼å·¥åºæªéæ©ï¼"); |
| | | return false; |
| | | } |
| | | //if (option.data[i]["HProcID"] == "0") { |
| | | // layer.msg("第" + i + "è¡ï¼å·¥åºæªéæ©ï¼"); |
| | | // return false; |
| | | //} |
| | | |
| | | |
| | | } |
| | |
| | | , 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] //è·åå¼¹æ¡é¡µé¢ |
| 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"> |
| | | <link rel="stylesheet" href="../../../layuiadmin/ext/soulTable.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> |
| | | <script src="../../../layuiadmin/SetColumn.js"></script> |
| | | <!--<script src="../../../layuiadmin/soulTable.slim.js"></script>--><!--æ é¢çéä¸è½å¼ç¨æ¤jsæä»¶--> |
| | | </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" style="display:none"> |
| | | <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">è¿ç®æ è¯</label> |
| | | <div class="layui-input-block"> |
| | | <select name="HIDentificat" id="HIDentificat" class="ForFilteringSchemes" lay-filter="HIDentificat" style="width:190px;"> |
| | | </select> |
| | | </div> |
| | | </div> |
| | | <div class="layui-inline"> |
| | | <label class="layui-form-label">ç产车é´</label> |
| | | <div class="layui-input-block"> |
| | | <select name="HWorkShopID" id="HWorkShopID" lay-verify="required" lay-search class="layui-input ForFilteringSchemes"> |
| | | <!--å¨ææ¸²æè½¦é´--> |
| | | </select> |
| | | </div> |
| | | </div> |
| | | <div class="layui-inline"> |
| | | <label class="layui-form-label">éæ±è½¦é´</label> |
| | | <div class="layui-input-block"> |
| | | <select name="HWorkShopID2" id="HWorkShopID2" lay-verify="required" lay-search class="layui-input ForFilteringSchemes"> |
| | | <!--å¨ææ¸²æè½¦é´--> |
| | | </select> |
| | | </div> |
| | | </div> |
| | | <div class="layui-inline"> |
| | | <label class="layui-form-label">æ¥æé´é</label> |
| | | <div class="layui-input-block"> |
| | | <select name="HInitTimeCycle" id="HInitTimeCycle" class="ForFilteringSchemes" lay-filter="HInitTimeCycle" style="width:190px;"> |
| | | </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> |
| | | <div class="layui-row"> |
| | | <div class="layui-inline"> |
| | | <label class="layui-form-label" style="width: 85px;padding: 9px 18px;">产åç¼ç </label> |
| | | <div class="layui-input-block" style="margin-left: 77px;"> |
| | | <input type="hidden" class="layui-input" lay-verify="HMATERIALID" name="HMATERIALID" id="HMATERIALID" value="0" style="background-color:#efefef4d;width: 60%;display: inline-block;" readonly> |
| | | <input type="text" class="layui-input" lay-verify="HMATERIALNAME" name="HMATERIALNAME" id="HMATERIALNAME" value="" style="background-color:#efefef4d;width: 60%;display: inline-block;"> |
| | | <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnHMATERIALID" id="btnHMATERIALID" style="padding: 0 10px;float: right;margin-right: 3px;"> |
| | | <i class="layui-icon layui-icon-search layuiadmin-button-btn"></i> |
| | | </button> |
| | | </div> |
| | | </div> |
| | | <div class="layui-inline"> |
| | | <label class="layui-form-label">ç©æå±æ§</label> |
| | | <div class="layui-input-block"> |
| | | <select name="HMaterClsID" id="HMaterClsID" lay-verify="HMaterClsID"> |
| | | <option value="0" selected>å
¨é¨</option> |
| | | <option value="1">å¤è´</option> |
| | | <option value="2">èªå¶</option> |
| | | <option value="3">å§å¤</option> |
| | | </select> |
| | | </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> |
| | | <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnExport" id="btnExport">导åº</button> |
| | | <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="bthHideColumn" id="bthHideColumn">å设置</button> |
| | | </div> |
| | | |
| | | <!--<div class="layui-colla-content" style="padding: 0px; margin-left: 6%;"> |
| | | <div class="layui-row" style="margin-top:10px;"> |
| | | <div class="layui-inline"> |
| | | <label class="layui-form-label" style="width: 85px;padding: 9px 18px;">产åç¼ç </label> |
| | | <div class="layui-input-block" style="margin-left: 77px;"> |
| | | <input type="hidden" class="layui-input" lay-verify="HMATERIALID" name="HMATERIALID" id="HMATERIALID" value="0" style="background-color:#efefef4d;width: 60%;display: inline-block;" readonly> |
| | | <input type="text" class="layui-input" lay-verify="HMATERIALNAME" name="HMATERIALNAME" id="HMATERIALNAME" value="" style="background-color:#efefef4d;width: 60%;display: inline-block;" readonly> |
| | | <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnHMATERIALID" id="btnHMATERIALID" style="padding: 0 10px;float: right;margin-right: 3px;"> |
| | | <i class="layui-icon layui-icon-search layuiadmin-button-btn"></i> |
| | | </button> |
| | | </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="text" class="layui-input" name="HMOBILLNO" id="HMOBILLNO"> |
| | | </div> |
| | | </div> |
| | | </div> |
| | | </div>--> |
| | | </div> |
| | | </div> |
| | | <table class="" id="mainTable" lay-filter="mainTable"></table> |
| | | </form> |
| | | </div> |
| | | </div> |
| | | </div> |
| | | </div> |
| | | </body> |
| | | </html> |
| | | <script> |
| | | var treeCkData = { id: 0 }; |
| | | var TagId = ""; |
| | | var TagParentId = ""; |
| | | layui.config({ |
| | | base: '../../../layuiadmin/' //éæèµæºæå¨è·¯å¾ |
| | | }).extend({ |
| | | index: 'lib/index', //主å
¥å£æ¨¡å |
| | | soulTable: '../ext/soulTable', |
| | | }).use(['tree', 'index', 'form', 'table', 'element', 'laypage', 'laydate', 'util', 'soulTable', 'flow','tableSelect'], 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 |
| | | , soulTable = layui.soulTable |
| | | , flow = layui.flow |
| | | , tableSelect = layui.tableSelect; |
| | | var sWhere = ""; |
| | | var option = []; |
| | | var ins; //ç¨äºå¯¼åºexcel |
| | | var HModName = "JIT_MaterialLevelShorAnalysisReport"; |
| | | |
| | | var HIDentificat_ValueList = []; |
| | | var HIDentificat_TitleList = []; |
| | | //#endregion |
| | | |
| | | //#region è¿å
¥é¡µé¢å³å è½½ |
| | | |
| | | //åå§åçé¢ |
| | | set_ClearBill(); |
| | | |
| | | //#endregion |
| | | |
| | | //#region 触åäºä»¶ï¼å
æ¬form.on(){}æ ¼å¼çææç¹å»äºä»¶ãéæ©äºä»¶ç |
| | | |
| | | //#endregion è¾å
¥æ¡å车çå¬ |
| | | //$('input[type="text"]').on('keydown', function (event) { |
| | | // if (event.keyCode == 13) { |
| | | // $("#btnSearch").click(); |
| | | // } |
| | | //}); |
| | | //#endregion |
| | | |
| | | //#region è¿ç®æ è¯ä¸æå表çå¬ |
| | | form.on('select(HIDentificat)', function (data) { |
| | | var value = data.value; |
| | | if ($.inArray(value, HIDentificat_ValueList)>-1) { |
| | | var HIDentificat_Title = HIDentificat_TitleList[$.inArray(value, HIDentificat_ValueList)]; |
| | | var HBeginDate = Format(Date.parse(HIDentificat_Title), "yyyy-MM-dd"); |
| | | var HEndDate = Format(new Date(Date.parse(HIDentificat_Title) + 1000 * 60 * 60 * 24 * 50), "yyyy-MM-dd"); |
| | | |
| | | $("#HBEGINDATE").val(HBeginDate); |
| | | $("#HENDDATE").val(HEndDate); |
| | | |
| | | get_FastQuery(); |
| | | } |
| | | }); |
| | | //#endregion |
| | | |
| | | //#region 产åç¼ç |
| | | form.on('submit(btnHMATERIALID)', function (data) { |
| | | btnHMATERIALID(); |
| | | }); |
| | | //#endregion |
| | | |
| | | //#region éç½®æé® |
| | | form.on('submit(btnReSearch)', function (data) { |
| | | set_ClearQuery(); |
| | | }); |
| | | //#endregion |
| | | |
| | | //#region æ¥è¯¢æé® |
| | | form.on('submit(btnSearch)', function (data) { |
| | | get_FastQuery(); |
| | | }); |
| | | //#endregion |
| | | |
| | | //#region å¯¼åºæé® |
| | | form.on('submit(btnExport)', function (data) { |
| | | getExportData(); |
| | | }); |
| | | //#endregion |
| | | |
| | | //#region å设置æé® |
| | | form.on('submit(bthHideColumn)', function (data) { |
| | | get_HideColumnNoPageForPlan(HModName, option, get_FastQuery); |
| | | }); |
| | | |
| | | //#region åå»è¡å¼¹åºå¼¹æ¡ |
| | | table.on('rowDouble(mainTable)', function (obj) { |
| | | var HOrgID = $("#HORGID").val(); |
| | | var HMaterID = obj.data.ç©æID; |
| | | var HWorkShopID = obj.data.éæ±è½¦é´ID; |
| | | var HBEGINDATE = $("#HBEGINDATE").val();//æ¬ ææ¥æ |
| | | var HENDDATE = $("#HENDDATE").val();//è³ |
| | | window.open('../../ç产管ç/æ¬ æè¿ç®/JIT_MaterialLevelShorAnalysisDetailReport.html?type=2&HOrgID=' + HOrgID + "&HMaterID=" + HMaterID + "&HWorkShopID=" + HWorkShopID + "&HBEGINDATE=" + HBEGINDATE + "&HENDDATE=" + HENDDATE); |
| | | //layer.open({ |
| | | // type: 2 |
| | | // , skin: 'layui-layer-rim'//å ä¸è¾¹æ¡ |
| | | // , area: ['90%', '90%'] |
| | | // , title: 'ä¸å±ç¼ºææ
åµ' |
| | | // , shift: 2//å¼¹åºå¨ç» |
| | | // , shade: 0.6 //é®ç½©éæåº¦ |
| | | // //, maxmin: true //å
许å
¨å±æå°å |
| | | // , anim: 0 //0-6çå¨ç»å½¢å¼ï¼-1ä¸å¼å¯ |
| | | // , content: ['../../ç产管ç/æ¬ æè¿ç®/JIT_MaterialLevelShorAnalysisDetailReport.html?type=2&HOrgID=' + HOrgID + "&HMaterID=" + HMaterID + "&HWorkShopID=" + HWorkShopID + "&HBEGINDATE=" + HBEGINDATE + "&HENDDATE=" + HENDDATE, 'yes'] |
| | | //}) |
| | | }) |
| | | //#endregion |
| | | |
| | | //#endregion |
| | | |
| | | //æ¥æé´é䏿å表çå¬ |
| | | form.on('select(HInitTimeCycle)', function (data) { |
| | | var HInitTimeCycle = $("#HInitTimeCycle").val() * 1; |
| | | //è¥æ¥æé´éä¸ä¸º ä»»æé´éï¼åç¦ç¨å¼å§æ¥æä¸ç»ææ¥æçéæ© |
| | | if (HInitTimeCycle !=0) { |
| | | //$('#HBeginDate').prop('disabled', true); |
| | | //$('#HEndDate').prop('disabled', true); |
| | | |
| | | $("#HBEGINDATE").val(Format(new Date().setDate(new Date().getDate()), "yyyy-MM-dd"));//æ¬ ææ¥æ |
| | | $("#HENDDATE").val(Format(new Date().setDate(new Date().getDate() + HInitTimeCycle), "yyyy-MM-dd"));//è³ |
| | | |
| | | //æ§è¡æ¥è¯¢æ¹æ³ |
| | | get_FastQuery(); |
| | | } |
| | | else { |
| | | $('#HBeginDate').prop('disabled', false); |
| | | $('#HEndDate').prop('disabled', false); |
| | | } |
| | | }); |
| | | |
| | | //#endregion |
| | | |
| | | //#region æ¬é¡µé¢è¢«è°ç¨çæææ¹æ³ |
| | | |
| | | //#region åå§åçé¢ |
| | | function set_ClearBill() { |
| | | //è¿ç®æ è¯åå§å |
| | | getHIDentificat_init(); |
| | | |
| | | //ç©æè¡¨æ ¼ä¸ææç´¢æ¡ |
| | | tableSelect.render({ |
| | | elem: '#HMATERIALNAME', |
| | | checkedKey: 'HItemID', |
| | | searchKey: 'ç©æä»£ç ,ç©æåç§°', |
| | | sWhere: '',//tableæç´¢sWhereæ¡ä»¶ |
| | | table: { |
| | | url: GetWEBURL() + 'Gy_Material/page', |
| | | where: { user: sessionStorage["HMaker"], "Organization": sessionStorage["Organization"] } , |
| | | cols: [[ |
| | | { type: 'checkbox',fixed:'left' }, |
| | | { field: 'HItemID', title: 'HItemID' }, |
| | | { field: 'ç©æä»£ç ', title: 'ç©æä»£ç ' }, |
| | | { field: 'ç©æåç§°', title: 'ç©æåç§°' }, |
| | | ]], |
| | | page: true, |
| | | limit: 5, |
| | | limits: [5] |
| | | }, |
| | | done: function (elem, data) { |
| | | if (data != []) { |
| | | //è·åæ°æ® |
| | | /*$("#HMATERIALNAME").blur();//åå
æ ¼å¤±å»ç¦ç¹*/ |
| | | $("#HMATERIALID").val(data.data[0].HItemID); |
| | | $("#HMATERIALNAME").val(data.data[0].ç©æåç§°); |
| | | get_FastQuery() |
| | | } |
| | | |
| | | } |
| | | }) |
| | | //åå§åæ¥æé´éãå¼å§æ¥æãç»ææ¥æ |
| | | setSelect_HInitTimeCycle(); |
| | | //è¥æ¥æé´éä¸ä¸º ä»»æé´éï¼åç¦ç¨å¼å§æ¥æä¸ç»ææ¥æçéæ© |
| | | var HInitTimeCycle = $("#HInitTimeCycle").val() * 1; |
| | | if (HInitTimeCycle !=0) { |
| | | $("#HBEGINDATE").val(Format(new Date().setDate(new Date().getDate()), "yyyy-MM-dd"));//æ¬ ææ¥æ |
| | | $("#HENDDATE").val(Format(new Date().setDate(new Date().getDate() + HInitTimeCycle), "yyyy-MM-dd"));//è³ |
| | | } |
| | | //ç产ç»ç»å è½½ |
| | | Organ(); |
| | | //è½¦é´ |
| | | get_Dept(); |
| | | //åå§åè¡¨æ ¼ |
| | | set_InitGrid(); |
| | | //设置页ç |
| | | DisPlay_HideColumn_GetPageSize(HModName, sessionStorage["HUserName"], option) |
| | | //å¿«éè¿æ»¤ |
| | | get_FastQuery(); |
| | | } |
| | | //#endregion |
| | | |
| | | //#region åå§åè¡¨æ ¼æ¹æ³ |
| | | function set_InitGrid() { |
| | | var columns = []; |
| | | |
| | | //columns.push({ type: 'checkbox', fixed: 'left', sort: true }); |
| | | //columns.push({ field: 'éæ±è½¦é´ID', title: 'éæ±è½¦é´ID', sort: true, filter: true }); |
| | | //columns.push({ field: 'éæ±è½¦é´ç¼ç ', title: 'éæ±è½¦é´ç¼ç ', sort: true, filter: true }); |
| | | //columns.push({ field: 'éæ±è½¦é´åç§°', title: 'éæ±è½¦é´åç§°', sort: true, filter: true }); |
| | | //columns.push({ field: 'ç©æID', title: 'ç©æID', sort: true, filter: true }); |
| | | //columns.push({ field: 'ç©æç¼ç ', title: 'ç©æç¼ç ', sort: true, filter: true }); |
| | | //columns.push({ field: 'ç©æåç§°', title: 'ç©æåç§°', sort: true, filter: true }); |
| | | //columns.push({ field: 'ç©æå±æ§', title: 'ç©æå±æ§', sort: true, filter: true }); |
| | | //columns.push({ field: 'ä¾è´§è½¦é´ID', title: 'ä¾è´§è½¦é´ID', sort: true, filter: true }); |
| | | //columns.push({ field: 'ä¾è´§è½¦é´ç¼ç ', title: 'ä¾è´§è½¦é´ç¼ç ', sort: true, filter: true }); |
| | | //columns.push({ field: 'ä¾è´§è½¦é´åç§°', title: 'ä¾è´§è½¦é´åç§°', sort: true, filter: true }); |
| | | //columns.push({ field: 'æ¯å¦å¹é
å°è®¢å', title: 'æ¯å¦å¹é
å°è®¢å', sort: true, filter: true, templet: function (d) { return d.æ¯å¦å¹é
å°è®¢å ? 'å¦' : 'æ¯'; } }); |
| | | ////columns.push({ field: 'HPOOrderBillRemark', title: 'æè¦' }); |
| | | ////columns.push({ field: 'HPOOrderBillNote', title: '夿³¨' }); |
| | | ////columns.push({ field: 'éè´å', title: 'éè´å' }); |
| | | //columns.push({ field: 'æ¯å¦å¹é
å°è¦æè®¡åä¿¡æ¯', title: 'æ¯å¦å¹é
å°è¦æè®¡åä¿¡æ¯', sort: true, filter: true, templet: function (d) { return d.æ¯å¦å¹é
å°è¦æè®¡åä¿¡æ¯ ? 'å¦' : 'æ¯'; } }); |
| | | // columns.push({ field: 'æ¥è®¡åéæ±æ°é', title: 'æ¥è®¡åéæ±æ°é', sort: true, filter: true }); |
| | | //columns.push({ field: '峿¶åºåæ»æ°é', title: '峿¶åºåæ»æ°é', sort: true, filter: true }); |
| | | //columns.push({ field: '颿æ°é', title: '颿æ°é', sort: true, filter: true }); |
| | | //columns.push({ field: 'å¯ç¨æ»æ°é', title: 'å¯ç¨æ»æ°é', sort: true, filter: true }); |
| | | //columns.push({ field: 'åºåå·²å ç¨æ»æ°é', title: 'åºåå·²å ç¨æ»æ°é', sort: true, filter: true }); |
| | | //columns.push({ field: 'åºåå©ä½å¯ç¨æ°é', title: 'åºåå©ä½å¯ç¨æ°é', sort: true, filter: true }); |
| | | //columns.push({ field: 'ä¾è´§æåæ', title: 'ä¾è´§æåæ', sort: true, filter: true }); |
| | | //columns.push({ field: 'å°è´§åç½®æ', title: 'å°è´§åç½®æ', sort: true, filter: true }); |
| | | ///*columns.push({ field: 'å±çº§', title: 'å±çº§', sort: true, filter: true });*/ |
| | | ////columns.push({ field: '计éåä½åç§°', title: '计éåä½', sort: true, filter: true }); |
| | | ////columns.push({ field: 'TQSUM', title: 'æ¬ ææææ°é', sort: true, totalRow: true, filter: 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, filter: 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: 'Total', title: 'æ¬ æè®¡åå计', filter: true }); |
| | | |
| | | option = { |
| | | elem: '#mainTable' |
| | | //, toolbar: '#toolbarDemo' |
| | | , height: 'full-50' |
| | | , page: true |
| | | , cellMinWidth: 90 |
| | | , limit: 1000 |
| | | , limits: [50, 500,1000, 2000] |
| | | , totalRow: true |
| | | , loading: false |
| | | , cols: [columns] |
| | | , done: function (res, curr, count) { |
| | | soulTable.render(this); |
| | | for (var i in res.data) { |
| | | var item = res.data[i]; |
| | | |
| | | if (item["æªå¹é
è®¢åæ°é"] > 0) { |
| | | $("tr[data-index='" + i + "']").attr({ "style": "background:red;color:black;" }); |
| | | } |
| | | |
| | | } |
| | | } |
| | | }; |
| | | } |
| | | //#endregion |
| | | |
| | | //è·åç»ç» |
| | | function Organ() { |
| | | //è·åç»å½é¡µç»ç»å |
| | | var Organization = ''; |
| | | $.ajax({ |
| | | type: "get", |
| | | url: GetWEBURL() + "/Web/GetOrganizations", |
| | | async: false, |
| | | 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"); |
| | | } |
| | | }) |
| | | } |
| | | |
| | | //çäº§è½¦é´ |
| | | function get_Dept() { |
| | | //è·å车é´å |
| | | var HDeptID = '<option value="0" style="color:red;" selected>å
¨é¨è½¦é´</option>'; |
| | | var sql = "exec h_p_Gy_GetHDeptListISWorkShop " + sessionStorage["OrganizationID"] |
| | | $.ajax({ |
| | | type: "get", |
| | | url: GetWEBURL() + "/Gy_SOPBillList/WindowPrintList", |
| | | async: false, |
| | | data: { "sWhere": sql}, |
| | | success: function (result) { |
| | | if (result.count == 1) { // 说æéªè¯æåäºï¼ |
| | | var data = result.data; |
| | | for (var i = 0; i < data.length; i++) { |
| | | HDeptID += '<option style="color:blue;" value="' + data[i].HItemID + '" >' + data[i].HName + '</option>'; |
| | | } |
| | | $("#HWorkShopID").append(HDeptID); |
| | | $("#HWorkShopID2").append(HDeptID); |
| | | if (sessionStorage["HDeptID"] != "0") { |
| | | $("#HWorkShopID").val(sessionStorage["HDeptID"]); |
| | | //ç¨æ·ç»å®ç车é´ä¸åå¨ï¼åé»è®¤æ¾ç¤ºå
¨é¨è½¦é´ |
| | | if ($("#HWorkShopID").val() == null || $("#HWorkShopID").val() == undefined) { |
| | | $("#HWorkShopID").val(0); |
| | | } |
| | | } |
| | | |
| | | //$("#HDeptName").val("0"); |
| | | |
| | | form.render('select'); |
| | | |
| | | } |
| | | layer.closeAll("loading"); |
| | | } |
| | | }) |
| | | } |
| | | |
| | | //#region æ¥è¯¢ |
| | | function get_Display(sql) { |
| | | var ajaxLoad = layer.load(); |
| | | var ModRightNameCheck = ""; |
| | | $.ajax({ |
| | | url: GetWEBURL() + '/CommonModel/searchMethod', |
| | | type: "GET", |
| | | async: false, |
| | | data: { "sql": sql, "user": sessionStorage["HUserName"], "ModRightNameCheck": ModRightNameCheck }, |
| | | success: function (data1) { |
| | | if (data1.count == 1) { |
| | | var data = [];//ååæ®µæ°æ® |
| | | var col = []; |
| | | var totalArray = []; |
| | | var titleData = []; |
| | | //ç»ç©ºçæ°ç»èµå¼ |
| | | for (var key in data1.list) {//循åºéåæ°ç» |
| | | data.push({ "id": data1.list[key].ColmCols, "name": data1.list[key].ColmCols, "Type": data1.list[key].ColmType });//仿¯ä¸ªå¯¹è±¡ä¸æåæ°æ® |
| | | } |
| | | //å¨å表左边添å å¾éæ¡ |
| | | col.push({ type: 'checkbox', fixed: 'left', totalRowText: 'å计' }); |
| | | for (var i = 0; i < data.length; i++) {//éådataæ°ç»éçæ°æ® |
| | | // if (data[i].name == 'HInterID' || data[i].name == 'HBillType' || data[i].name == 'hmainid') { |
| | | if ($.inArray(data[i].name, titleData) > -1) {//æ£æ¥dataãiã.nameæ¯å¦å¨æ°ç»ä¸ //计ç®å |
| | | 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, filter: true }); |
| | | } else if (data[i].name == 'æªå¹é
è®¢åæ°é') { |
| | | col.push({ |
| | | field: 'æªå¹é
è®¢åæ°é', title: 'æªå¹é
è®¢åæ°é', sort: true, filter: true, templet: function (d) { |
| | | return d.æªå¹é
è®¢åæ°é > 0 ? '<span style="color: black;">' + d.æªå¹é
è®¢åæ°é + '</span>' : d.æªå¹é
è®¢åæ°é; |
| | | } }); |
| | | } |
| | | else if (data[i].name == 'æªå¹é
è¦æè®¡åä¿¡æ¯æ°é') { |
| | | col.push({ |
| | | field: 'æªå¹é
è¦æè®¡åä¿¡æ¯æ°é', title: 'æªå¹é
è¦æè®¡åä¿¡æ¯æ°é', sort: true, filter: true, templet: function (d) { |
| | | return d.æªå¹é
è¦æè®¡åä¿¡æ¯æ°é > 0 ? '<span style="color: black;">' + d.æªå¹é
è¦æè®¡åä¿¡æ¯æ°é + '</span>' : d.æªå¹é
è¦æè®¡åä¿¡æ¯æ°é; |
| | | } |
| | | }); |
| | | } else if (isValidDate(data[i].name)) { |
| | | col.push({ |
| | | field: data[i].name, title: Format(data[i].name, 'MM.dd'), width: 70, totalRow: true, filter: true, templet: function (d) { |
| | | //è·åå½åä»å¤©æå¤©å天ä¸å¤©çæ¥æå符串 |
| | | const dates = []; |
| | | const today = new Date(); |
| | | for (let i = 0; i < 3; i++) { |
| | | const date = new Date(today); |
| | | date.setDate(today.getDate() + i); |
| | | const dateStr = date.toISOString().slice(0, 10); |
| | | dates.push(`${dateStr}`); |
| | | } |
| | | // å¦æè¡æ¥æå¨å½åæ¥æä¸å¤©åï¼åå
容æ 红 |
| | | if ((this.field == dates[0] || this.field == dates[1] || this.field == dates[2]) && d[this.field] != null) { |
| | | return '<span style="color:Orange">' + (d[this.field] == null ? 0 : d[this.field]) + '</span>'; |
| | | } else { |
| | | return d[this.field] == null ? 0 : d[this.field] |
| | | } |
| | | } |
| | | }) |
| | | } |
| | | 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 == "è¡å
³éæ¥æ" ? "è¡å
³é人" : data[i].name) + " ==''?'':layui.util.toDateString(d." + data[i].name + ", 'yyyy-MM-dd HH:mm:ss')}}</div>", width: 200 }); |
| | | break; |
| | | default: |
| | | col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: true, filter: true, width: 200 }); |
| | | } |
| | | } |
| | | } |
| | | option.cols = [col]; |
| | | option.data = data1.data; |
| | | //å设置 |
| | | DisPlay_HideColumnForPlan(HModName, sessionStorage["HUserName"], option); |
| | | ins = table.render(option); |
| | | layer.close(ajaxLoad); |
| | | } else { |
| | | layer.alert(data1.code + data1.Message, { icon: 5 }); |
| | | layer.close(ajaxLoad); |
| | | } |
| | | }, error: function () { |
| | | layer.alert("æ¥å£è¯·æ±å¤±è´¥!", { icon: 5 }); |
| | | layer.close(ajaxLoad); |
| | | } |
| | | }); |
| | | } |
| | | |
| | | //#endregion |
| | | |
| | | // çé彿°ï¼æ£æ¥å符串æ¯å¦ç¬¦åæ ¼å¼ç鿥æ |
| | | function isValidDate(dateStr) { |
| | | // æ£å表达å¼éªè¯æ ¼å¼ |
| | | const formatRegex = /^\d{4}-(0[1-9]|1[0-2])-(0[1-9]|[12][0-9]|3[01])$/; |
| | | if (!formatRegex.test(dateStr)) return false; |
| | | |
| | | // åå²å¹´ææ¥å¹¶è½¬æ¢ä¸ºæ°å¼ |
| | | const [year, month, day] = dateStr.split('-').map(Number); |
| | | |
| | | // å建Dateå¯¹è±¡ï¼æä»½ä»0å¼å§ï¼ |
| | | const date = new Date(year, month - 1, day); |
| | | |
| | | // æ£æ¥æ¥ææ¯å¦ææï¼ä¸è¾å
¥çå¹´ææ¥ä¸è´ï¼ |
| | | return ( |
| | | date.getFullYear() === year && |
| | | date.getMonth() === month - 1 && |
| | | date.getDate() === day |
| | | ); |
| | | } |
| | | |
| | | |
| | | //#region è·åå¯¼åºæ°æ® |
| | | function getExportData() { |
| | | var data = option.data; |
| | | data.forEach((item) => { |
| | | for (let itemobj in item) { |
| | | if (item[itemobj] == null) { |
| | | item[itemobj] = ""; |
| | | } |
| | | if (item[itemobj].length > 0) { // åè®¾åæ®µå为field |
| | | item[itemobj] = item[itemobj].toString().replace(/[\r\n]+/g, ''); // å°æ¢è¡ç¬¦æ¿æ¢ä¸ºç©ºå符串 |
| | | } |
| | | } |
| | | }); |
| | | |
| | | table.exportFile(ins.config.id, data, "xls"); |
| | | } |
| | | //#endregion |
| | | |
| | | //#region å¿«éè¿æ»¤ |
| | | function get_FastQuery() { |
| | | HORGID = $("#HORGID").val();//ç»ç» |
| | | var HBEGINDATE = $("#HBEGINDATE").val();//æ¬ ææ¥æ |
| | | var HENDDATE = $("#HENDDATE").val();//è³ |
| | | var HMATERIALID = $("#HMATERIALID").val();//ç©æ/产å |
| | | var HMATERIALNAME = $("#HMATERIALNAME").val();//ç©æåç§° |
| | | var HWorkShopID = $("#HWorkShopID").val();//ç©æ/产å |
| | | var HWorkShopID2 = $("#HWorkShopID2").val();//ç©æ/产åéæ±è½¦é´ |
| | | var HMaterClsID = $("#HMaterClsID").val();//ç©æå±æ§ |
| | | var HIDentificat = $("#HIDentificat").val();//è¿ç®æ è¯ |
| | | |
| | | if (HBEGINDATE > HENDDATE) { |
| | | return layer.msg("å¼å§æ¥æä¸è½å°äºç»ææ¥æ!"); |
| | | } |
| | | |
| | | if (HORGID != "") { |
| | | sWhere += " and T1.HStockORGID= " + HORGID+" "; |
| | | } |
| | | if (HWorkShopID != 0) { |
| | | sWhere += " and T1.HSupplyWorkShopID= " + HWorkShopID + " "; |
| | | } |
| | | if (HWorkShopID2 != 0) { |
| | | sWhere += " and T1.HWorkShopID= " + HWorkShopID2 + " "; |
| | | } |
| | | if (HMaterClsID != 0) { |
| | | sWhere += " and T1.HMaterClsID=" + HMaterClsID + " "; |
| | | } |
| | | //if (HBEGINDATE != null && HENDDATE != null) { |
| | | // sWhere += " and HDate between ''" + HBEGINDATE + "'' and ''" + HENDDATE + "'' "; |
| | | //} |
| | | if (HMATERIALID != 0) { |
| | | sWhere += " and T1.HMaterID= " + HMATERIALID + " "; |
| | | } else { |
| | | if (HMATERIALNAME != "") { |
| | | sWhere += " and (T2.HName like ''%" + HMATERIALNAME + "%'' or T2.HNumber like ''%" + HMATERIALNAME + "%'') "; |
| | | } |
| | | } |
| | | |
| | | var sql = "exec h_p_JIT_MaterialLevelShorReportList_His '" + sWhere + "','" + HBEGINDATE + "','" + HENDDATE + "','" + HIDentificat + "'"; |
| | | get_Display(sql); |
| | | |
| | | sWhere = "";//è°ç¨æ¥å£åæ¸
空sWhereç¼å |
| | | } |
| | | //#endregion |
| | | |
| | | //#region éç½®è¿æ»¤æ¡ä»¶æ¹æ³ |
| | | function set_ClearQuery() { |
| | | $("#HORGID").val(sessionStorage["OrganizationID"]);//ç»ç» |
| | | $("#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(""); |
| | | $("#HWorkShopID").val("0"); |
| | | $("#HWorkShopID2").val("0"); |
| | | $("#HMaterClsID").val("0"); |
| | | form.render('select'); |
| | | sWhere = ""; |
| | | } |
| | | //#endregion |
| | | |
| | | //ç©æå表 |
| | | function btnHMATERIALID() { |
| | | layer.open({ |
| | | type: 2 //ç±»å |
| | | , skin: 'layui-layer-rim'//å ä¸è¾¹æ¡ |
| | | , area: ['90%', '90%']//å¤§å° |
| | | , title: 'ç©æå表'//æ é¢ |
| | | , shift: 2//å¼¹åºå¨ç» |
| | | , content: ['../../åºç¡èµæ/å
¬ç¨åºç¡èµæ/Gy_Material.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].ç©æåç§°); |
| | | layer.close(index); //å®è·åçå§ç»æ¯ææ°å¼¹åºçæä¸ªå±ï¼å¼æ¯ç±layerå
é¨å¨æéå¢è®¡ç®ç |
| | | } |
| | | , btn2: function (index, layero) { } |
| | | }) |
| | | } |
| | | |
| | | //#region åå§æ¥æé´é 䏿å表 |
| | | function setSelect_HInitTimeCycle() { |
| | | var valueList = [30, 45, 60]; |
| | | var titleList = ["è¿ä¸æ", "è¿45天", "è¿60天"]; |
| | | |
| | | var HInitTimeCycle_ArrayList = '<option value="-1" selected="selected" >ä»»æé´é</option>'; |
| | | for (var i = 0; i < valueList.length; i++) { |
| | | HInitTimeCycle_ArrayList += '<option style="color:blue;" value="' + valueList[i] + '">' + titleList[i] + '</option>'; |
| | | } |
| | | |
| | | $("#HInitTimeCycle").empty(); |
| | | $("#HInitTimeCycle").append(HInitTimeCycle_ArrayList); |
| | | form.render('select'); |
| | | |
| | | $("#HInitTimeCycle").val("60"); |
| | | } |
| | | //#endregion |
| | | |
| | | //#region è¿ç®æ è¯ |
| | | function getHIDentificat_init() { |
| | | var sql = "select HIDentificat, min(convert(varchar(100),HMakeDate,20)) HMakeDate from JIT_MOMaterLackBill where ISNULL(HIDentificat, '') <> '' group by HIDentificat order by min(convert(varchar(100),HMakeDate,20)) desc"; |
| | | var ModRightNameCheck = ""; |
| | | $.ajax({ |
| | | url: GetWEBURL() + '/CommonModel/searchMethod', |
| | | async: false, |
| | | type: "GET", |
| | | data: { "sql": sql, "user": sessionStorage["HUserName"], "ModRightNameCheck": ModRightNameCheck }, |
| | | success: function (data1) { |
| | | if (data1.count == 1) { |
| | | var Organization = ""; |
| | | if (data1.count == 1) { |
| | | var data = data1.data; |
| | | for (var i = 0; i < data.length; i++) { |
| | | Organization += '<option style="color:blue;" value="' + data[i].HIDentificat + '">' + data[i].HMakeDate + '</option>'; |
| | | |
| | | HIDentificat_ValueList.push(data[i].HIDentificat); |
| | | HIDentificat_TitleList.push(data[i].HMakeDate); |
| | | } |
| | | $("#HIDentificat").append(Organization); |
| | | if (data.length > 0) { |
| | | $("#HIDentificat").val(data[0].HIDentificat); |
| | | } |
| | | form.render('select'); |
| | | } |
| | | } else { |
| | | layer.alert(data1.code + data1.Message, { icon: 5 }); |
| | | } |
| | | }, error: function (e) { |
| | | layer.alert(e + "æ¥å£è¯·æ±å¤±è´¥!", { icon: 5 }); |
| | | } |
| | | }); |
| | | } |
| | | //#endregion |
| | | |
| | | |
| | | //#endregion |
| | | //以䏿¯layui模å |
| | | }); |
| | | function GetGyMaterial(obj) { |
| | | $("#HMATERIALID").val(obj.HItemID); |
| | | $("#HMATERIALNAME").val(obj.ç©æåç§°); |
| | | } |
| | | function GetHDeptNameValue(obj) //è¿åéè´é¨é¨ |
| | | { |
| | | $("#HWorkShopID").val(obj[0].HItemID);//车é´id |
| | | $("#HWorkShopIDName").val(obj[0].é¨é¨åç§°);//车é´åç§° |
| | | } |
| | | </script> |
| | |
| | | <div class="layui-btn-group"> |
| | | <button type="button" id="Saver" class="layui-btn layui-btn-normal layui-btn-radius" lay-submit="" lay-filter="Saver">ä¿å</button> |
| | | <button type="button" id="VerIfySaver" class="layui-btn layui-btn-normal layui-btn-radius" lay-submit="" lay-filter="VerIfySaver">å®¡æ ¸</button> |
| | | <button type="button" class="layui-btn layui-btn-normal layui-btn-radius" lay-submit="" lay-filter="Exit">éåº</button> |
| | | <button type="button" id="Exit" class="layui-btn layui-btn-normal layui-btn-radius" lay-submit="" lay-filter="Exit">éåº</button> |
| | | </div> |
| | | |
| | | </div> |
| | |
| | | , 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] //è·åå¼¹æ¡é¡µé¢ |
| | |
| | | <button type="button" class="layui-btn layui-btn-sm" lay-event="set_Copy" id="set_Copy"><i class="layui-icon layui-icon-form"></i>å¤å¶</button> |
| | | <button type="button" class="layui-btn layui-btn-sm" style="display: none;" lay-event="btn-Edit" id="btn-Edit"><i class="layui-icon layui-icon-form"></i>ç¼è¾</button> |
| | | <button type="button" class="layui-btn layui-btn-sm" style="display: none;" lay-event="btn-Delete" id="btn-Delete"><i class="layui-icon layui-icon-delete"></i>å é¤</button> |
| | | <button type="button" class="layui-btn layui-btn-sm" style="display:none;" lay-event="btn-PushProductInBill" id="btn-PushProductInBill"><i class="layui-icon layui-icon-delete"></i>䏿¨(ç产å
¥åºå)</button> |
| | | <button type="button" class="layui-btn layui-btn-sm" style="display:none;" lay-event="btn-PushProductionReturnBill" id="btn-PushProductionReturnBill"><i class="layui-icon layui-icon-delete"></i>䏿¨(ç产éåºå)</button> |
| | | <!--<button type="button" class="layui-btn layui-btn-sm" style="display:none;" lay-event="btn-PushProductInBill" id="btn-PushProductInBill"><i class="layui-icon layui-icon-delete"></i>䏿¨(ç产å
¥åºå)</button> |
| | | <button type="button" class="layui-btn layui-btn-sm" style="display:none;" lay-event="btn-PushProductionReturnBill" id="btn-PushProductionReturnBill"><i class="layui-icon layui-icon-delete"></i>䏿¨(ç产éåºå)</button>--> |
| | | <button type="button" class="layui-btn layui-btn-sm" style="display: none;" lay-event="btn-Audit" id="btn-Audit"><i class="layui-icon layui-icon-radio"></i>å®¡æ ¸</button> |
| | | <button type="button" class="layui-btn layui-btn-sm" style="display: none;" lay-event="btn-DeAudit" id="btn-DeAudit"><i class="layui-icon layui-icon-circle"></i>åå®¡æ ¸</button> |
| | | <button type="button" class="layui-btn layui-btn-sm" style="display: none;" lay-event="set_CloseBill" id="set_CloseBill"><i class="layui-icon layui-icon-form"></i>å
³é</button> |
| | | <button type="button" class="layui-btn layui-btn-sm" style="display: none;" lay-event="set_CancelCloseBill" id="set_CancelCloseBill"><i class="layui-icon layui-icon-form"></i>åå
³é</button> |
| | | <button type="button" class="layui-btn layui-btn-sm" style="display: none;" lay-event="btn-Print" id="btn-Print"><i class="layui-icon layui-icon-print"></i>é¢è§</button> |
| | | <button type="button" class="layui-btn layui-btn-sm" style="display: none;" lay-event="btn_print1" id="btn-Print1"><i class="layui-icon layui-icon-print"></i>æå°</button> |
| | | <button type="button" class="layui-btn layui-btn-sm" style="display: none;" lay-event="btn-Cell" id="btn-Cell"><i class="layui-icon layui-icon-slider"></i>ä¿åå宽</button> |
| | | <button type="button" class="layui-btn layui-btn-sm" style="display: none;" lay-event="btn-RefreshCell" id="btn-RefreshCell"><i class="layui-icon layui-icon-cols"></i>é»è®¤å宽</button> |
| | | <!--<button type="button" class="layui-btn layui-btn-sm" style="display: none;" lay-event="btn-Cell" id="btn-Cell"><i class="layui-icon layui-icon-slider"></i>ä¿åå宽</button> |
| | | <button type="button" class="layui-btn layui-btn-sm" style="display: none;" lay-event="btn-RefreshCell" id="btn-RefreshCell"><i class="layui-icon layui-icon-cols"></i>é»è®¤å宽</button>--> |
| | | <button type="button" class="layui-btn layui-btn-sm" style="display:none;" lay-event="set_HideColumn" id="HideColumn"><i class="layui-icon layui-icon-form"></i>å设置</button> |
| | | <button type="button" class="layui-btn layui-btn-sm" style="display:none;" lay-event="set_HideButton" id="HideButton"><i class="layui-icon layui-icon-form"></i>æé®è®¾ç½®</button> |
| | | <button type="button" class="layui-btn layui-btn-sm" style="display:none;" lay-event="set_SaveScheme" id="set_SaveScheme"><i class="layui-icon layui-icon-template"></i>ä¿åæ¹æ¡</button> |
| | |
| | | , 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] //è·åå¼¹æ¡é¡µé¢ |
| | |
| | | done: function (data1) { |
| | | layer.closeAll('loading'); |
| | | if (data1.count == 1) { |
| | | var HVersion_Import_Temp = Format(new Date(), "yyyy-MM-dd hh:mm:ss"); |
| | | for (var i = 0; i < data1.data.length; i++) { |
| | | data1.data[i].HVersion_Import = HVersion_Import_Temp; |
| | | } |
| | | |
| | | option.data = data1.data; |
| | | table.render(option); |
| | | } else { |
| | |
| | | <button class="layui-btn layui-btn-normal" style="margin-left: 0px" type="button" lay-submit="" lay-filter="btnUnlockOrder" id="btnUnlockOrder">è§£éå·¥å</button> |
| | | <button class="layui-btn layui-btn-normal" style="margin-left: 0px" type="button" lay-submit="" lay-filter="btnGetCompletionDate" id="btnGetCompletionDate">è·åå®å·¥æ¥æ</button> |
| | | <button class="layui-btn layui-btn-normal" style="margin-left: 0px" type="button" lay-submit="" lay-filter="btnGetEarlyDate" id="btnGetEarlyDate">è·åææ©å¼å·¥æ¥æ</button> |
| | | <button class="layui-btn layui-btn-normal" style="margin-left: 0px" type="button" lay-submit="" lay-filter="btnPublishDate" id="btnPublishDate">交æåå¸</button> |
| | | </div> |
| | | <div class="layui-collapse resizable-container"> |
| | | <div class="layui-colla-item"> |
| | |
| | | form.on('submit(btnGetEarlyDate)', function (data) { |
| | | get_btnGetEarlyDate(); |
| | | }) |
| | | |
| | | //交æåå¸ |
| | | form.on('submit(btnPublishDate)', function (data) { |
| | | get_btnPublishDate(); |
| | | }) |
| | | //#endregion |
| | | |
| | | //#endregion |
| | |
| | | }); |
| | | |
| | | //æ ¹æ®è½¦é´å 餿²¡æéå®çæ°æ® |
| | | 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 + " and HLockOrder != 1 )"; |
| | | 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", |
| | |
| | | } |
| | | //#endregion |
| | | |
| | | //交æåå¸ |
| | | //#region |
| | | function get_btnPublishDate() { |
| | | var HDeptID = $("#HWorkShopID").val() == "" ? 0 : $("#HWorkShopID").val(); |
| | | |
| | | $.ajax({ |
| | | url: GetWEBURL() + '/JIT_DayPlanPlatFormBill/PublishDate', |
| | | type: "GET", |
| | | data: { "HDeptID": HDeptID }, |
| | | success: function (data1) { |
| | | if (data1.count == 1) { |
| | | layer.alert("æ¨éæå", { icon: 5 }); |
| | | } else { |
| | | layer.alert(data1.Message, { icon: 5 }); |
| | | } |
| | | }, error: function () { |
| | | layer.alert("æ¥å£è¯·æ±å¤±è´¥!", { icon: 5 }); |
| | | } |
| | | }); |
| | | } |
| | | //#endregion |
| | | |
| | | //#region æ¥çå·¥èºè·¯çº¿ï¼è®¾ç½®å·¥åæ¥åï¼å¯¼åºï¼åè®¾ç½®æ¹æ³ |
| | | |
| | | //æ¥çå·¥èºè·¯çº¿ |
| | |
| | | , 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] //è·åå¼¹æ¡é¡µé¢ |
| | |
| | | shift: 2, |
| | | area: ['90%', '90%'], |
| | | maxmin: true, |
| | | content: ['../../åºç¡èµæ/å
¬ç¨åºç¡èµæ/Gy_DepartmentList.html', 'yes'], |
| | | content: ['../../åºç¡èµæ/å
¬ç¨åºç¡èµæ/Gy_DepartmentList.html?openType=2&HOrgName=' + sessionStorage["Organization"], 'yes'], |
| | | btn: ['ç¡®å®', 'åæ¶'] |
| | | , btn1: function (index, layero) { |
| | | //æé®ãæé®ä¸ãçåè° |
| | |
| | | if (HBillNo) { |
| | | sWhere += " and åæ®å· like '%" + HBillNo + "%'"; |
| | | } |
| | | if (HDeptID) { |
| | | sWhere += " and ç»´ä¿®é¨é¨ like '%" + HDeptID + "%'"; |
| | | } |
| | | //get_Display(sWhere); |
| | | //æ°æ®åºå页 |
| | | get_DisplayPage(sWhere) |
| | |
| | | , 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] //è·åå¼¹æ¡é¡µé¢ |
| | |
| | | , 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] //è·åå¼¹æ¡é¡µé¢ |
| | |
| | | } |
| | | |
| | | function GetMaterTypeValue(obj) { //ç©æåç±» |
| | | $("#HMaterTypeName").val(obj[0].ç©æåç±»åç§°); |
| | | $("#HMaterTypeName").val(obj[0].åç§°); |
| | | $("#HMaterTypeID").val(obj[0].HItemID); |
| | | } |
| | | |