| WebTM/WebTM.csproj | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 | |
| WebTM/views/index.html | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 | |
| WebTM/views/生产管理/生产报表/Sc_NutInspectionCCDPassRate.html | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 | |
| WebTM/views/质量管理/质量报表/QC_QualityStatisticsDailyReport.html | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 |
WebTM/WebTM.csproj
@@ -399,6 +399,7 @@ <Content Include="views\ç产管ç\å¼å¸¸åé¦å\Sc_MESExecptFeedBackBillType.html" /> <Content Include="views\ç产管ç\æ¥å·¥å°å·¥åº\å¼å·¥\Sc_SwipeCardStart.html" /> <Content Include="views\ç产管ç\ç产任å¡å\Sc_ICMOBillOrProcessExchangeResumeList.html" /> <Content Include="views\ç产管ç\ç产æ¥è¡¨\Sc_NutInspectionCCDPassRate.html" /> <Content Include="views\ç产管ç\ç产æ¥è¡¨\Sc_QualityReportBillMonth.html" /> <Content Include="views\ç产管ç\ç产æ¥è¡¨\Sc_QualityReportBillDay.html" /> <Content Include="views\ç产管ç\ç产计åå¹³å°\JIT_DayPlanPlatForm_BCP.html" /> @@ -430,6 +431,7 @@ <Content Include="views\è´¨é管ç\æ£éªåæ ·è¿æ ·å\QC_TakeSampleCheckBillMainList.html" /> <Content Include="views\è´¨é管ç\æ£éªåæ ·è¿æ ·å\QC_Add_TakeSampleCheckBill.html" /> <Content Include="views\è´¨é管ç\è´¨éæ¥è¡¨\QC_InspectionFormReport.html" /> <Content Include="views\è´¨é管ç\è´¨éæ¥è¡¨\QC_QualityStatisticsDailyReport.html" /> <Content Include="views\è´¨é管ç\车é´èªæ£å\QC_Add_Edit_WorkSelfCheckBill.html" /> <Content Include="views\è´¨é管ç\车é´èªæ£å\QC_WorkSelfCheckBillList.html" /> <Content Include="views\车é´ç®¡ç\产线\222.jpg" /> WebTM/views/index.html
@@ -483,6 +483,7 @@ <a>ç产æ¥è¡¨</a> <dl class="layui-nav-child"> <dd><a lay-href="ç产管ç/ç产æ¥è¡¨/ProductionAnalysisReport.html">ç产åææ¥è¡¨</a></dd> <dd><a lay-href="ç产管ç/ç产æ¥è¡¨/Sc_NutInspectionCCDPassRate.html">èºæ¯æ£éªCCDåæ ¼ç</a></dd> </dl> </dd> </dl> @@ -709,6 +710,7 @@ <a>è´¨éæ¥è¡¨</a> <dl class="layui-nav-child"> <dd><a lay-href="è´¨é管ç/è´¨éæ¥è¡¨/QC_InspectionFormReport.html">SPCæ£éªååæ</a></dd> <dd><a lay-href="è´¨é管ç/è´¨éæ¥è¡¨/QC_QualityStatisticsDailyReport.html">ç产质éç»è®¡æ¥æ¥</a></dd> </dl> </dd> </dl> WebTM/views/Éú²ú¹ÜÀí/Éú²ú±¨±í/Sc_NutInspectionCCDPassRate.html
New file @@ -0,0 +1,611 @@ <!DOCTYPE html> <html> <head> <meta charset="utf-8" /> <title>èºæ¯æ£éªCCDåæ ¼ç</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/HideButton.js"></script> <script src="../../../layuiadmin/soulTable.slim.js"></script> <script src="../../../layuiadmin/PageTitle.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">ç产订åå·</label> <div class="layui-input-block"> <input type="text" class="layui-input" name="HICMOBillNo" id="HICMOBillNo" value=""> </div> </div> <div class="layui-inline"> <label class="layui-form-label" style="width: 76px;">产åæ¡ç </label> <div class="layui-input-block"> <input type="text" class="layui-input" name="HBardCode" id="HBardCode" value=""> </div> </div> <div class="layui-inline"> <label class="layui-form-label">æµè½¬å¡å·</label> <div class="layui-input-block"> <input type="text" class="layui-input" name="HProcExchBillNo" id="HProcExchBillNo"> </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 class="layui-colla-content" style="padding: 0px; margin-left: 6%;"> <div class="layui-row" style="margin-top:10px;margin-left:5%;"> </div> <div class="layui-row" style="margin-top: 10px; margin-bottom: 10px "> <div class="layui-inline"> <label class="layui-form-label">è¿æ»¤</label> <div class="layui-input-block"> <select name="ColName" id="ColName" lay-filter="ColName" style="width:190px;"> </select> </div> </div> <div class="layui-inline"> <select name="Comparator" id="Comparator" lay-filter="Comparator" style="width:190px;"> <option value="0" selected="selected"></option> <option value="=">=</option> <option value=">=">>=</option> <option value=">">></option> <option value="<="><=</option> <option value="<"><</option> <option value="<>"><></option> <option value="7">å å«</option> <option value="8">å·¦å å«</option> <option value="9">å³å å«</option> <option value="10">ä¸å å«</option> </select> </div> <div class="layui-inline"> <input type="text" class="layui-input" value="" name="ColContent" id="ColContent"> </div> </div> <div class="layui-row" style=" margin-top: 10px;"> <div class="layui-inline"> <label class="layui-form-label">è¿æ»¤</label> <div class="layui-input-block"> <select name="ColName1" id="ColName1" class="ForFilteringSchemes" lay-filter="ColName1" style="width:190px;"> </select> </div> </div> <div class="layui-inline"> <select name="Comparator1" id="Comparator1" class="ForFilteringSchemes" lay-filter="Comparator1" style="width:190px;"> <option value="0" selected="selected"></option> <option value="=">=</option> <option value=">=">>=</option> <option value=">">></option> <option value="<="><=</option> <option value="<"><</option> <option value="<>"><></option> <option value="7">å å«</option> <option value="8">å·¦å å«</option> <option value="9">å³å å«</option> <option value="10">ä¸å å«</option> </select> </div> <div class="layui-inline"> <input type="text" class="layui-input ForFilteringSchemes" value="" name="ColContent1" id="ColContent1"> </div> </div> <div class="layui-row" style=" margin-top: 10px;"> <div class="layui-inline"> <label class="layui-form-label">è¿æ»¤</label> <div class="layui-input-block"> <select name="ColName2" id="ColName2" class="ForFilteringSchemes" lay-filter="ColName2" style="width:190px;"> </select> </div> </div> <div class="layui-inline"> <select name="Comparator2" id="Comparator2" class="ForFilteringSchemes" lay-filter="Comparator2" style="width:190px;"> <option value="0" selected="selected"></option> <option value="=">=</option> <option value=">=">>=</option> <option value=">">></option> <option value="<="><=</option> <option value="<"><</option> <option value="<>"><></option> <option value="7">å å«</option> <option value="8">å·¦å å«</option> <option value="9">å³å å«</option> <option value="10">ä¸å å«</option> </select> </div> <div class="layui-inline"> <input type="text" class="layui-input ForFilteringSchemes" value="" name="ColContent2" id="ColContent2"> </div> </div> </div> </div> </div> <div class="layui-tab layui-tab-card"> <div class="layui-tab-content"> <div class="layui-tab-item layui-show"> <!--è¿åºç«è®°å½--> <table class="layui-hide" id="mainTable" lay-filter="mainTable"></table> </div> </div> </div> <script type="text/html" id="toolbarDemo1"> <div class="layui-btn-container"> <button type="button" class="layui-btn layui-btn-sm" lay-event="set_HideColumn"><i class="layui-icon layui-icon-form"></i>å设置</button> </div> </script> </form> </div> </div> </div> </div> </body> </html> <script> layui.config({ base: '../../../layuiadmin/' //éæèµæºæå¨è·¯å¾ }).extend({ index: 'lib/index', //ä¸»å ¥å£æ¨¡å }).use(['index', 'form', 'table', 'element', 'laypage', 'laydate','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 , soulTable = layui.soulTable var sWhere = ""; var option = []; var HModName = "Sc_NutInspectionCCDPassRate"; var titleData = ["HInterID", "HEntryID", "HBadReasonID", "HSourceInterID", "HSourceEntryID"];//å表ä¸éè¦æ¾ç¤ºçå段 å¯æ©å± //#endregion //#region è¿å ¥é¡µé¢å³å è½½ //åå§åè¡¨æ ¼ DisPlay_HideColumn(); //åå§åçé¢ set_ClearBill(); //#endregion //#region 触åäºä»¶ï¼å æ¬form.on(){}æ ¼å¼çææç¹å»äºä»¶ãéæ©äºä»¶ç // å¤´å·¥å ·æ äºä»¶ table.on('toolbar(mainTable)', function (obj) { switch (obj.event) { //å设置 case 'set_HideColumn': get_HideColumn(); break; }; }); //æ¥è¯¢æé® form.on('submit(btnSearch)', function (data) {//éæ©ä»ä½ get_FastQuery(); }); //éç½® form.on('submit(btnReSearch)', function (data) { set_ClearQuery(); }); //#endregion //#region æ¤é¡µé¢ææçæ¹æ³ // åå§åçé¢ function set_ClearBill() { set_InitGrid(); //æ¥è¯¢ //get_FastQuery(); } function set_InitGrid() { option = { elem: '#mainTable' , toolbar: '#toolbarDemo1' , height: 'full-50' , page: true , cellMinWidth: 'auto' , totalRow: true , limit: 50 , data:[] , limits: [50, 500, 5000, 20000] , done: function (res, curr, count) { soulTable.render(this); } , cols: [[ { type: 'checkbox', fixed: 'left', totalRowText: 'å计' } , { field: 'æ¥æ', title: 'æ¥æ', sort: true, } , { field: 'ç©æç¼ç ', title: 'ç©æç¼ç ', sort: true, } , { field: 'èºæ¯æ¹å·', title: 'èºæ¯æ¹å·', sort: true } , { field: 'æ»æ°', title: 'æ»æ°', sort: true, totalRow: true } , { field: 'è¯æ°', title: 'è¯æ°', sort: true, totalRow: true} , { field: 'ä¸è¯æ°', title: 'ä¸è¯æ°', sort: true, totalRow: true } , { field: 'å¯çæ°', title: 'å¯çæ°', sort: true, totalRow: true } , { field: 'è¯ç', title: 'è¯ç', sort: true, totalRow: true } , { field: 'ä¸è¯ç', title: 'ä¸è¯ç', sort: true, totalRow: true} , { field: 'æä½è ', title: 'æä½è ', sort: true } , { field: 'å¤æ³¨', title: 'å¤æ³¨', sort: true } ]] }; table.render(option); } // æ¥è¯¢ function get_Display(sWhere) { var ajaxLoad = layer.load(); $.ajax({ url: GetWEBURL() + '/Cj_SingleStation/EntryAndExitRecords', type: "GET", async: false, data: { "HBardCode": $("#HBardCode").val(), "HProcExchBillNo": $("#HProcExchBillNo").val(), "HICMOBillNo": $("#HICMOBillNo").val(), "sWhere": sWhere, "user": sessionStorage["HUserName"] }, success: function (data1) { if (data1.count == 1) { var data = []; var col = []; //ç»ç©ºçæ°ç»èµå¼ 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' }); col.push({ type: 'numbers', title: 'åºå·' }); for (var i = 0; i < data.length; i++) { // if (data[i].name == 'HInterID' || data[i].name == 'HBillType' || data[i].name == 'hmainid') { if ($.inArray(data[i].name, titleData) > -1) { col.push({ field: data[i].id, title: data[i].name, align: 'center', hide: true }); //éèidå } else { switch (data[i].Type) { //int case 'DateTime': col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: true, templet: "<div>{{d." + data[i].name + " ==null ?'':layui.util.toDateString(d." + data[i].name + ", 'yyyy-MM-dd HH:mm:ss')}}</div>", width: 180 }); break; case 'long': case 'Int32': case 'Int64': case 'double': case 'Decimal': col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: true, width: 120, totalRow: true }); break; default: col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: true, width: 150 }); } } } //å¨ææ¾ç¤ºåå option = { elem: '#mainTable' , toolbar: '#toolbarDemo1' , cols: [col] , data: data1.data , height: 800 , page: true , totalRow: true , cellMinWidth: 90 , limit: 50 , limits: [50, 500, 5000, 20000] , done: function (res, curr, count) { soulTable.render(this); } } table.render(option); //å·æ°è¡¨æ ¼æ°æ® DisPlay_HideColumn(); if ($("#Comparator").val() == 0 && $("#ColContent").val() == "") { ColFilter(); } layer.close(ajaxLoad); } else { layer.close(ajaxLoad); layer.alert(data1.code + data1.Message, { icon: 5 }); } }, error: function () { layer.close(ajaxLoad); layer.alert("æ¥å£è¯·æ±å¤±è´¥!", { icon: 5 }); } }); } // å¿«éè¿æ»¤ function get_FastQuery() { var HBardCode = $("#HBardCode").val(); var ColName = $("#ColName").val();//å¤éæ¡ var Comparator = $("#Comparator").val() var ColContent = $("#ColContent").val(); var ColName1 = $("#ColName1").val();//å¤éæ¡ var Comparator1 = $("#Comparator1").val() var ColContent1 = $("#ColContent1").val(); var ColName2 = $("#ColName2").val();//å¤éæ¡ var Comparator2 = $("#Comparator2").val() var ColContent2 = $("#ColContent2").val(); if (ColName != 0 && Comparator != 0) { var com = ""; switch (Comparator) { case "7": com = "like'%" + ColContent + "%'"; break; case "8": com = "like'%" + ColContent + "'"; break; case "9": com = "like'" + ColContent + "%'"; break; case "10": com = "not like'%" + ColContent + "%'"; break; default: com = "" + Comparator + "'" + ColContent + "'"; break; } sWhere += " and " + ColName + " " + com; } if (ColName1 != 0 && Comparator1 != 0) { var com1 = ""; switch (Comparator1) { case "7": com1 = "like'%" + ColContent1 + "%'"; break; case "8": com1 = "like'%" + ColContent1 + "'"; break; case "9": com1 = "like'" + ColContent1 + "%'"; break; case "10": com1 = "not like'%" + ColContent1 + "%'"; break; default: com1 = "" + Comparator1 + "'" + ColContent1 + "'"; break; } sWhere += " and " + ColName1 + " " + com1; } if (ColName2 != 0 && Comparator2 != 0) { var com2 = ""; switch (Comparator2) { case "7": com2 = "like'%" + ColContent2 + "%'"; break; case "8": com2 = "like'%" + ColContent2 + "'"; break; case "9": com2 = "like'" + ColContent2 + "%'"; break; case "10": com2 = "not like'%" + ColContent2 + "%'"; break; default: com2 = "" + Comparator2 + "'" + ColContent2 + "'"; break; } sWhere += " and " + ColName2 + " " + com2; } //var com = ""; //if (ColName != 0 && Comparator != 0) { // switch (Comparator) { // case "7": // com = "like ''%" + ColContent + "%''"; // break; // case "8": // com = "like ''%" + ColContent + "''"; // break; // case "9": // com = "like ''" + ColContent + "%''"; // break; // case "10": // com = "not like ''%" + ColContent + "%''"; // break; // default: // com = "" + Comparator + " ''" + ColContent + "''"; // break; // } // com = " and (" + ColName + " " + com + ")"; //} //sWhere += com; if (HBardCode!="") { sWhere += " order by åºç«æ¶é´"; } get_Display(sWhere); sWhere = "";//è°ç¨æ¥å£åæ¸ ç©ºsWhereç¼å } function set_ClearQuery() { $("#HICMOBillNo").val(""); $("#HBardCode").val(""); $("#HProcExchBillNo").val(""); $("#ColContent1").val(""); $("#ColName1").val("0"); $("#Comparator1").val("0"); $("#ColContent2").val(""); $("#ColName2").val("0"); $("#Comparator2").val("0"); $("#ColContent").val(""); $("#ColName").val("0"); $("#Comparator").val("0"); form.render('select'); sWhere = ""; } //éèå设置 function get_HideColumn() { var colName = ""; var contentUrl = ""; for (var i = 1; i < option.cols[0].length - 1; i++) { colName += option.cols[0][i]["title"] + ","; } var urlStr = window.document.location.pathname;//è·åæä»¶è·¯å¾ var urlLen = urlStr.split('/'); for (var i = 0; i < urlLen.length - 4; i++) { contentUrl += "../"; } colName = encodeURI(colName.substring(0, colName.length - 1));//对 URI è¿è¡ç¼ç contentUrl += 'åºç¡èµæ/éèå设置/Gy_GridView_Hide.html?HModName=' + HModName + '&colName=' + colName; layer.open({ type: 2 , skin: "layui-layer-rim" //å ä¸è¾¹æ¡ , title: "éèå设置" //æ é¢ , closeBtn: 1 //çªä½å³ä¸è§å ³é ç æ ·å¼ , shift: 2 //å¼¹åºå¨ç» , area: ["50%", "90%"] //çªä½å¤§å° , maxmin: true //设置æ大æå°æé®æ¯å¦æ¾ç¤º , content: [contentUrl, "yes"] , btn: ["ç¡®å®", "åæ¶"] , btn1: function (index, laero) { //å·æ°è¡¨æ ¼æ°æ® DisPlay_HideColumn(); //æ´æ°è¡¨æ ¼ç¼åçæ°æ® layer.close(index);//å ³éå¼¹çª } }) } //æ¾ç¤ºåæ°æ® function DisPlay_HideColumn() { $.ajax({ url: GetWEBURL() + '/Xt_grdAlignment_WMES/grdAlignmentWMESList', type: "GET", data: { "HModName": HModName, "user": sessionStorage["HUserName"] }, success: function (data1) { if (data1.data.length != 0) { var dataCol = [];//æ°æ®åºæ¥è¯¢åºçåæ°æ® dataCol = data1.data[0].HGridString.split(','); for (var i = 0; i < option.cols[0].length - 2; i++) { var dataCols = dataCol[i].split('|'); //éèå if (dataCols[1] == 1) { option.cols[0][i + 1]["hide"] = true; } //设置å宽 if (dataCols[3] > 0) { option.cols[0][i + 1]["width"] = dataCols[3]; } //设置å 容åä½å¤§å° if (data1.data[0].HFontSize != 0) { option.cols[0][i + 1]["style"] = "font-size:" + data1.data[0].HFontSize + "px;"; } else { option.cols[0][i + 1]["style"] = "font-size:100%"; } //设置å宽 //if (data1.data[0].HColumnWidth != 0) { // option.cols[0][i + 1]["width"] = data1.data[0].HColumnWidth + "px;"; //} else { // option.cols[0][i + 1]["width"] = ""; //} //æ¾ç¤ºå if (dataCols[1] == 0 && $.inArray(option.cols[0][i + 1]["title"], titleData) == -1) { option.cols[0][i + 1]["hide"] = false; } //åä½æå¨ä½ç½®(å·¦ å± ä¸ å³) switch (dataCols[2]) { case "L": option.cols[0][i + 1]["align"] = "left"; break; case "M": option.cols[0][i + 1]["align"] = "center"; break; case "R": option.cols[0][i + 1]["align"] = "right"; break; } } //åæ¶å»ç»å for (var i = 1; i < option.cols[0].length - 1; i++) { if (option.cols[0][i]["fixed"] != null) { option.cols[0][i]["fixed"] = null; } else { break; } } //å»ç»å if (data1.data[0].HFixCols != 0) { for (var i = 0; i < data1.data[0].HFixCols; i++) { if ($.inArray(option.cols[0][i + 1]["title"], titleData) != -1) { data1.data[0].HFixCols += 1; } option.cols[0][i + 1]["fixed"] = "left"; } } table.render(option); } else { table.render(option); } }, error: function () { layer.alert("æ¥å£è¯·æ±å¤±è´¥!", { icon: 5 }); } }) } // åææ¾ç¤ºä¸ææ¡ 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模å }); </script> WebTM/views/ÖÊÁ¿¹ÜÀí/ÖÊÁ¿±¨±í/QC_QualityStatisticsDailyReport.html
New file @@ -0,0 +1,645 @@ <!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, 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/HideButton.js"></script> <script src="../../../layuiadmin/soulTable.slim.js"></script> <script src="../../../layuiadmin/PageTitle.js"></script> <script src="../../../layuiadmin/zgqCustom/zgqCustom.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: 85px;"> <select name="HYear" id="HYear" lay-verify="HYear"> <!--å¨æ渲æ年份--> </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; width: 85px;"> <select name="HMonth" id="HMonth" lay-verify="HMonth"> <option value="1">1</option> <option value="2">2</option> <option value="3">3</option> <option value="4">4</option> <option value="5">5</option> <option value="6">6</option> <option value="7">7</option> <option value="8">8</option> <option value="9">9</option> <option value="10">10</option> <option value="11">11</option> <option value="12">12</option> </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; width: 125px;"> <select name="HDeptName" id="HDeptName" lay-verify="HDeptName"> <!--å¨æ渲æ年份--> </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; width: 125px;"> <select name="HOrgID" id="HOrgID" lay-verify="HOrgID"> <!--å¨æ渲æ年份--> </select> </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 class="layui-colla-content" style="padding: 0px; margin-left: 6%;"> <div class="layui-row" style="margin-top:10px;margin-left:5%;"> </div> <div class="layui-row" style="margin-top: 10px; margin-bottom: 10px "> <div class="layui-inline"> <label class="layui-form-label">è¿æ»¤</label> <div class="layui-input-block"> <select name="ColName" id="ColName" lay-filter="ColName" style="width:190px;"> </select> </div> </div> <div class="layui-inline"> <select name="Comparator" id="Comparator" lay-filter="Comparator" style="width:190px;"> <option value="0" selected="selected"></option> <option value="=">=</option> <option value=">=">>=</option> <option value=">">></option> <option value="<="><=</option> <option value="<"><</option> <option value="<>"><></option> <option value="7">å å«</option> <option value="8">å·¦å å«</option> <option value="9">å³å å«</option> <option value="10">ä¸å å«</option> </select> </div> <div class="layui-inline"> <input type="text" class="layui-input" value="" name="ColContent" id="ColContent"> </div> </div> <div class="layui-row" style=" margin-top: 10px;"> <div class="layui-inline"> <label class="layui-form-label">è¿æ»¤</label> <div class="layui-input-block"> <select name="ColName1" id="ColName1" class="ForFilteringSchemes" lay-filter="ColName1" style="width:190px;"> </select> </div> </div> <div class="layui-inline"> <select name="Comparator1" id="Comparator1" class="ForFilteringSchemes" lay-filter="Comparator1" style="width:190px;"> <option value="0" selected="selected"></option> <option value="=">=</option> <option value=">=">>=</option> <option value=">">></option> <option value="<="><=</option> <option value="<"><</option> <option value="<>"><></option> <option value="7">å å«</option> <option value="8">å·¦å å«</option> <option value="9">å³å å«</option> <option value="10">ä¸å å«</option> </select> </div> <div class="layui-inline"> <input type="text" class="layui-input ForFilteringSchemes" value="" name="ColContent1" id="ColContent1"> </div> </div> <div class="layui-row" style=" margin-top: 10px;"> <div class="layui-inline"> <label class="layui-form-label">è¿æ»¤</label> <div class="layui-input-block"> <select name="ColName2" id="ColName2" class="ForFilteringSchemes" lay-filter="ColName2" style="width:190px;"> </select> </div> </div> <div class="layui-inline"> <select name="Comparator2" id="Comparator2" class="ForFilteringSchemes" lay-filter="Comparator2" style="width:190px;"> <option value="0" selected="selected"></option> <option value="=">=</option> <option value=">=">>=</option> <option value=">">></option> <option value="<="><=</option> <option value="<"><</option> <option value="<>"><></option> <option value="7">å å«</option> <option value="8">å·¦å å«</option> <option value="9">å³å å«</option> <option value="10">ä¸å å«</option> </select> </div> <div class="layui-inline"> <input type="text" class="layui-input ForFilteringSchemes" value="" name="ColContent2" id="ColContent2"> </div> </div> </div> </div> </div> <div class="layui-tab layui-tab-card"> <div class="layui-tab-content"> <div class="layui-tab-item layui-show"> <!--è¿åºç«è®°å½--> <table class="layui-hide" id="mainTable" lay-filter="mainTable"></table> </div> </div> </div> <script type="text/html" id="toolbarDemo1"> <div class="layui-btn-container"> <button type="button" class="layui-btn layui-btn-sm" lay-event="set_HideColumn"><i class="layui-icon layui-icon-form"></i>å设置</button> </div> </script> </form> </div> </div> </div> </div> </body> </html> <script> layui.config({ base: '../../../layuiadmin/' //éæèµæºæå¨è·¯å¾ }).extend({ index: 'lib/index', //ä¸»å ¥å£æ¨¡å }).use(['index', 'form', 'table', 'element', 'laypage', 'laydate','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 , soulTable = layui.soulTable var sWhere = ""; var option = []; var HModName = "QC_QualityStatisticsDailyReport"; var titleData = ["HInterID", "HEntryID", "HBadReasonID", "HSourceInterID", "HSourceEntryID"];//å表ä¸éè¦æ¾ç¤ºçå段 å¯æ©å± //#endregion //#region è¿å ¥é¡µé¢å³å è½½ //åå§åè¡¨æ ¼ DisPlay_HideColumn(); //åå§åçé¢ set_ClearBill(); //#endregion //#region 触åäºä»¶ï¼å æ¬form.on(){}æ ¼å¼çææç¹å»äºä»¶ãéæ©äºä»¶ç // å¤´å·¥å ·æ äºä»¶ table.on('toolbar(mainTable)', function (obj) { switch (obj.event) { //å设置 case 'set_HideColumn': get_HideColumn(); break; }; }); //æ¥è¯¢æé® form.on('submit(btnSearch)', function (data) {//éæ©ä»ä½ get_FastQuery(); }); //éç½® form.on('submit(btnReSearch)', function (data) { set_ClearQuery(); }); //#endregion //#region æ¤é¡µé¢ææçæ¹æ³ // åå§åçé¢ function set_ClearBill() { Year(); DeptName(); Organ(); //set_InitGrid(); //æ¥è¯¢ get_FastQuery(); } //å¹´ function Year() { var yyyy = new Date().getFullYear(); var YearOption = ""; for (var i = 0; i <= 10; i++) { YearOption += '<option style="color:blue;" value="' + (yyyy - 5 + i) + '">' + (yyyy - 5 + i) + '</option>'; } $("#HYear").append(YearOption); $("#HYear").val(yyyy); $("#HMonth").val(new Date().getMonth()+1); form.render('select'); } //çäº§è½¦é´ function DeptName() { //è·å车é´å var HDeptName = '<option value="0" style="color:red;" selected>å ¨é¨è½¦é´</option>'; $.ajax({ type: "get", url: GetWEBURL() + "/Sc_ICMOBill/GetHDeptList", async: false, data: { "HOrgID": sessionStorage["OrganizationID"] }, success: function (result) { if (result.count == 1) { // 说æéªè¯æåäºï¼ var data = result.data; for (var i = 0; i < data.length; i++) { if (i == 0) HDeptName += '<option style="color:blue;" value="' + data[i].HItemID + '" >' + data[i].HName + '</option>'; else HDeptName += '<option style="color:blue;" value="' + data[i].HItemID + '">' + data[i].HName + '</option>'; } $("#HDeptName").append(HDeptName); form.render('select'); } layer.closeAll("loading"); } }) } //è·åç»ç» function Organ() { //è·åç»å½é¡µç»ç»å $.ajax({ type: "get", url: GetWEBURL() + "/Web/GetOrganizations", async: false, success: function (result) { var Organization = ""; 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 set_InitGrid() { var columns = []; columns.push({ type: 'checkbox', fixed: 'left', totalRowText: 'å计' }); columns.push({ field: 'å·¥åº', title: 'å·¥åº', sort: true, width: 90}); columns.push({ field: 'å¤å®ç»æ', title: 'å¤å®ç»æ', sort: true, width: 110 }); columns.push({ field: 'ä¸è¯åå ', title: 'ä¸è¯åå ', sort: true, width: 110 }); columns.push({ field: 'æ»è®¡', title: 'æ»è®¡', sort: true, totalRow: true, width: 90}); //è·åå¹´ var yyyy = $("#HYear").val(); //è·åæ份 var MM = $("#HMonth").val(); //è·åå¼å§æ份çæå¤§å¤©æ° var SumMonth = new Date(yyyy, MM, 0).getDate(); //å¨æ两æä¹å·® for (var i = 0; i < SumMonth; i++) { columns.push({ field: Format(yyyy + '/' + MM + '/' + (i + 1), 'yyyy-MM-dd'), title: Format(yyyy + '/' + MM + '/' + (i + 1), 'MM.dd'), width: 80 }) } option = { elem: '#mainTable' , toolbar: '#toolbarDemo1' , height: 'full-50' , page: true //, cellMinWidth: 'auto' , totalRow: true , limit: 500 , data:[] , limits: [50, 500, 5000, 20000] //, done: function (res, curr, count) { // soulTable.render(this); //} , cols: [columns] }; table.render(option); } // æ¥è¯¢ function get_Display(sWhere) { var ajaxLoad = layer.load(); $.ajax({ url: GetWEBURL() + '/QC_CustomerAppealReport/QC_QualityStatisticsDailyReport', type: "GET", async: false, data: { "sWhere": sWhere, "user": sessionStorage["HUserName"] }, success: function (data1) { if (data1.count == 1) { option.data=data1.data table.render(option); //å·æ°è¡¨æ ¼æ°æ® DisPlay_HideColumn(); if ($("#Comparator").val() == 0 && $("#ColContent").val() == "") { ColFilter(); } layer.close(ajaxLoad); } else { layer.close(ajaxLoad); layer.alert(data1.code + data1.Message, { icon: 5 }); } }, error: function () { layer.close(ajaxLoad); layer.alert("æ¥å£è¯·æ±å¤±è´¥!", { icon: 5 }); } }); } // å¿«éè¿æ»¤ function get_FastQuery() { var HYear = $("#HYear").val(); var HMonth = $("#HMonth").val(); var HDeptName = $("#HDeptName").val(); var HOrgID = $("#HOrgID").val(); var ColName = $("#ColName").val();//å¤éæ¡ var Comparator = $("#Comparator").val() var ColContent = $("#ColContent").val(); var ColName1 = $("#ColName1").val();//å¤éæ¡ var Comparator1 = $("#Comparator1").val() var ColContent1 = $("#ColContent1").val(); var ColName2 = $("#ColName2").val();//å¤éæ¡ var Comparator2 = $("#Comparator2").val() var ColContent2 = $("#ColContent2").val(); if (ColName != 0 && Comparator != 0) { var com = ""; switch (Comparator) { case "7": com = "like'%" + ColContent + "%'"; break; case "8": com = "like'%" + ColContent + "'"; break; case "9": com = "like'" + ColContent + "%'"; break; case "10": com = "not like'%" + ColContent + "%'"; break; default: com = "" + Comparator + "'" + ColContent + "'"; break; } sWhere += " and " + ColName + " " + com; } if (ColName1 != 0 && Comparator1 != 0) { var com1 = ""; switch (Comparator1) { case "7": com1 = "like'%" + ColContent1 + "%'"; break; case "8": com1 = "like'%" + ColContent1 + "'"; break; case "9": com1 = "like'" + ColContent1 + "%'"; break; case "10": com1 = "not like'%" + ColContent1 + "%'"; break; default: com1 = "" + Comparator1 + "'" + ColContent1 + "'"; break; } sWhere += " and " + ColName1 + " " + com1; } if (ColName2 != 0 && Comparator2 != 0) { var com2 = ""; switch (Comparator2) { case "7": com2 = "like'%" + ColContent2 + "%'"; break; case "8": com2 = "like'%" + ColContent2 + "'"; break; case "9": com2 = "like'" + ColContent2 + "%'"; break; case "10": com2 = "not like'%" + ColContent2 + "%'"; break; default: com2 = "" + Comparator2 + "'" + ColContent2 + "'"; break; } sWhere += " and " + ColName2 + " " + com2; } sWhere = { HYear: HYear , HMonth: HMonth , HDeptName: HDeptName , HOrgID: HOrgID } set_InitGrid(); get_Display(JSON.stringify(sWhere)); sWhere = "";//è°ç¨æ¥å£åæ¸ ç©ºsWhereç¼å } function set_ClearQuery() { $("#HICMOBillNo").val(""); $("#HBardCode").val(""); $("#HProcExchBillNo").val(""); $("#ColContent1").val(""); $("#ColName1").val("0"); $("#Comparator1").val("0"); $("#ColContent2").val(""); $("#ColName2").val("0"); $("#Comparator2").val("0"); $("#ColContent").val(""); $("#ColName").val("0"); $("#Comparator").val("0"); form.render('select'); sWhere = ""; } //éèå设置 function get_HideColumn() { var colName = ""; var contentUrl = ""; for (var i = 1; i < option.cols[0].length - 1; i++) { colName += option.cols[0][i]["title"] + ","; } var urlStr = window.document.location.pathname;//è·åæä»¶è·¯å¾ var urlLen = urlStr.split('/'); for (var i = 0; i < urlLen.length - 4; i++) { contentUrl += "../"; } colName = encodeURI(colName.substring(0, colName.length - 1));//对 URI è¿è¡ç¼ç contentUrl += 'åºç¡èµæ/éèå设置/Gy_GridView_Hide.html?HModName=' + HModName + '&colName=' + colName; layer.open({ type: 2 , skin: "layui-layer-rim" //å ä¸è¾¹æ¡ , title: "éèå设置" //æ é¢ , closeBtn: 1 //çªä½å³ä¸è§å ³é ç æ ·å¼ , shift: 2 //å¼¹åºå¨ç» , area: ["50%", "90%"] //çªä½å¤§å° , maxmin: true //设置æ大æå°æé®æ¯å¦æ¾ç¤º , content: [contentUrl, "yes"] , btn: ["ç¡®å®", "åæ¶"] , btn1: function (index, laero) { //å·æ°è¡¨æ ¼æ°æ® DisPlay_HideColumn(); //æ´æ°è¡¨æ ¼ç¼åçæ°æ® layer.close(index);//å ³éå¼¹çª } }) } //æ¾ç¤ºåæ°æ® function DisPlay_HideColumn() { $.ajax({ url: GetWEBURL() + '/Xt_grdAlignment_WMES/grdAlignmentWMESList', type: "GET", data: { "HModName": HModName, "user": sessionStorage["HUserName"] }, success: function (data1) { if (data1.data.length != 0) { var dataCol = [];//æ°æ®åºæ¥è¯¢åºçåæ°æ® dataCol = data1.data[0].HGridString.split(','); for (var i = 0; i < option.cols[0].length - 2; i++) { var dataCols = dataCol[i].split('|'); //éèå if (dataCols[1] == 1) { option.cols[0][i + 1]["hide"] = true; } //设置å宽 if (dataCols[3] > 0) { option.cols[0][i + 1]["width"] = dataCols[3]; } //设置å 容åä½å¤§å° if (data1.data[0].HFontSize != 0) { option.cols[0][i + 1]["style"] = "font-size:" + data1.data[0].HFontSize + "px;"; } else { option.cols[0][i + 1]["style"] = "font-size:100%"; } //设置å宽 //if (data1.data[0].HColumnWidth != 0) { // option.cols[0][i + 1]["width"] = data1.data[0].HColumnWidth + "px;"; //} else { // option.cols[0][i + 1]["width"] = ""; //} //æ¾ç¤ºå if (dataCols[1] == 0 && $.inArray(option.cols[0][i + 1]["title"], titleData) == -1) { option.cols[0][i + 1]["hide"] = false; } //åä½æå¨ä½ç½®(å·¦ å± ä¸ å³) switch (dataCols[2]) { case "L": option.cols[0][i + 1]["align"] = "left"; break; case "M": option.cols[0][i + 1]["align"] = "center"; break; case "R": option.cols[0][i + 1]["align"] = "right"; break; } } //åæ¶å»ç»å for (var i = 1; i < option.cols[0].length - 1; i++) { if (option.cols[0][i]["fixed"] != null) { option.cols[0][i]["fixed"] = null; } else { break; } } //å»ç»å if (data1.data[0].HFixCols != 0) { for (var i = 0; i < data1.data[0].HFixCols; i++) { if ($.inArray(option.cols[0][i + 1]["title"], titleData) != -1) { data1.data[0].HFixCols += 1; } option.cols[0][i + 1]["fixed"] = "left"; } } table.render(option); } else { table.render(option); } }, error: function () { layer.alert("æ¥å£è¯·æ±å¤±è´¥!", { icon: 5 }); } }) } // åææ¾ç¤ºä¸ææ¡ 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模å }); </script>
