| | |
| | | </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="text" class="layui-input" name="HGroupName" lay-verify="HGroupName" id="HGroupName" style="width: 60%;display: inline-block;"> |
| | | <input type="hidden" class="layui-input" name="HGroupID" lay-verify="HGroupID" id="HGroupID" value="0"> |
| | | </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;"> |
| | | <!--å
¶ä»æ¡ä»¶--> |
| | | <div class="layui-row" style=" margin-top: 10px; margin-left: 70px;"> |
| | | <div class="layui-inline"> |
| | | <label class="layui-form-label">è¿æ»¤</label> |
| | | <div class="layui-input-block"> |
| | | <select name="ColName" id="ColName" class="ForFilteringSchemes" lay-filter="ColName" style="width:190px;"> |
| | | </select> |
| | | </div> |
| | | </div> |
| | | <div class="layui-inline"> |
| | | <select name="Comparator" id="Comparator" class="ForFilteringSchemes" 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 ForFilteringSchemes" value="" name="ColContent" id="ColContent"> |
| | | </div> |
| | | </div> |
| | | |
| | | <div class="layui-row" style=" margin-top: 10px; margin-left: 70px;"> |
| | | <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; margin-left: 70px;"> |
| | | <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> |
| | | |
| | | <script> |
| | | //#region ææ¬æ¡è¾å
¥æç´¢ç¸å
³æ°æ®-åé |
| | | var childPage = null; //è·ååçªå£å¯¹è±¡ï¼ç¨äºæä½åçªå£çåéåæ¹æ³ |
| | | var currRowIndex = 0; //ç¨äºå®ä½åçªå£å½åéä¸çè¡ |
| | | var childData = null; //ç¨äºè·ååçªå£è¿åçæ°æ® |
| | | //#endregion |
| | | |
| | | layui.config({ |
| | | base: '../../../layuiadmin/' //éæèµæºæå¨è·¯å¾ |
| | |
| | | //åå§åçé¢ |
| | | set_ClearBill(); |
| | | //#endregion |
| | | |
| | | ColFilter(); |
| | | //#region ãå¾å½¢ã |
| | | function set_Graphics() { |
| | | //#region ãæ±ç¶å¾ã |
| | |
| | | |
| | | option_BT = { |
| | | title: { |
| | | text: $("#HYear").val() + 'å¹´' + (Number(new Date().getMonth()) + Number(1)) + 'æä»½ä¸è¯åå åå¸å¾', |
| | | text: $("#HYear").val() + 'å¹´' + (Number(new Date().getMonth()) + Number(1)) + 'ä¸è¯åå å¾', |
| | | left: 'center' |
| | | }, |
| | | tooltip: { |
| | |
| | | //å è½½ç½æ ¼ |
| | | function get_Display(sWhere) { |
| | | sWhere = $("#HYear").val(); |
| | | var HGroupID = $("#HGroupID").val(); |
| | | var wait = layer.load();//é®ç½© |
| | | $.ajax({ |
| | | url: GetWEBURL() + '/Sc_BadReasonReport/list', |
| | | type: "GET", |
| | | async: false, |
| | | data: { "sWhere": sWhere, "user": sessionStorage["HUserName"] }, |
| | | data: { "sWhere": sWhere, "user": sessionStorage["HUserName"], "HGroupID": HGroupID }, |
| | | success: function (data1) { |
| | | var col = []; |
| | | if (data1.count == 1) { |
| | |
| | | function get_FastQuery() { |
| | | var HBeginDate = $("#HBeginDate").val(); |
| | | var HEndDate = $("#HEndDate").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 = "" + Comparator + "'" + ColContent + "'"; |
| | | break; |
| | | } |
| | | sWhere += " and " + ColName2 + " " + com2; |
| | | } |
| | | sWhere = "'" + HBeginDate + "','" + HEndDate + "'"; |
| | | |
| | | get_Display(sWhere); |
| | |
| | | function set_ClearQuery() { |
| | | $("#HBeginDate").val(Format(new Date(new Date() - 1000 * 60 * 60 * 24 * 30), "yyyy-MM-dd")); |
| | | $("#HEndDate").val(Format(new Date(), "yyyy-MM-dd")); |
| | | $("#ColContent").val(""); |
| | | $("#ColName").val("0"); |
| | | $("#Comparator").val("0"); |
| | | $("#ColContent1").val(""); |
| | | $("#ColName1").val("0"); |
| | | $("#Comparator1").val("0"); |
| | | $("#ColContent2").val(""); |
| | | $("#ColName2").val("0"); |
| | | $("#Comparator2").val("0"); |
| | | $("#HGroupID").val("0"); |
| | | $("#HGroupName").val(""); |
| | | form.render('select'); |
| | | |
| | | sWhere = " "; |
| | | get_FastQuery(); |
| | | } |
| | | |
| | | //åææ¾ç¤ºä¸ææ¡ |
| | | 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'); |
| | | } |
| | | |
| | | |
| | | //éèå设置 |
| | | function get_HideColumn() { |
| | |
| | | }) |
| | | } |
| | | |
| | | //#region ææ¬æ¡çå¬ |
| | | $(document).ready(function () { |
| | | //#region æ ¹æ®çç»ä»£ç è·åçç»åºç¡èµæçéå¼¹çª |
| | | //æ ¹æ®å
ç´ ID对å
ç´ è¿è¡çå¬============================================================================= |
| | | $("#HGroupName").on('keydown', function (data) { |
| | | //================================================================================================ |
| | | var errKeys = ["ArrowUp", "ArrowDown", "ArrowLeft", "ArrowRight", "Enter"]; |
| | | if ($.inArray(event.key, errKeys) == -1) { //妿æä¸çé®ä½ä¸æ¯ æ¹åé®ï¼åå·æ°å¼¹çªä¸çæ°æ® |
| | | if (childPage == null) { //夿å½ååçªå£æ¯å¦å·²ç»æå¼ï¼è¥æªæå¡ï¼åæå¼é¡µé¢ï¼å¹¶è·ååçªå£ç对象 |
| | | var offset = $(this).offset(); //è·å触åäºä»¶çå
ç´ çä½ç½®ï¼ç¨äºå®ä½åçªå£æå¼çä½ç½® |
| | | var innerHeight = window.innerHeight; |
| | | var top = offset.top + 0.05 * innerHeight; |
| | | var left = offset.left; |
| | | if (top + 0.05 * innerHeight + 0.3 * innerHeight > innerHeight) { |
| | | top = top - 0.3 * innerHeight - 0.05 * innerHeight; |
| | | } |
| | | layer.open({ |
| | | type: 2 //å¼¹çªç±»å |
| | | , skin: 'layui-layer-rim' //å ä¸è¾¹æ¡ |
| | | , area: ['35%', '50%'] //å¤§å° |
| | | , shadeClose: true //ç¹å»é®ç½©æ¶å
³éå¼¹çª |
| | | , offset: [top, left] |
| | | , title: false //䏿¾ç¤ºæ 颿 |
| | | //, title: '项ç®è´¹ç¨å表' //æ é¢ |
| | | , shift: 2 //å¼¹åºå¨ç» |
| | | , closeBtn: 0 //ç¦ç¨å
³éæé® |
| | | , content: ["../../åºç¡èµæ/éç¨åºç¡èµæ/Gy_CommonBaseData.html?OperationType=2", "yes"] |
| | | , success: function (layero, index) { |
| | | setTimeout(function () { |
| | | //ä¿®æ¹ï¼æ ¹æ®ææ¬æ¡æ°æ®ï¼ç¼åæ¥è¯¢è¯å¥================================================================================================ |
| | | var value = $("#HGroupName").val().replace(/'/g, ""); //è·åææ¬æ¡ææ°å¼ |
| | | currRowIndex = 0; |
| | | var tableView = "h_v_Gy_GroupList"; |
| | | var childSWhere = "select top(10) HItemID,çç»ä»£ç ,çç»åç§° from " + tableView + " where 1=1 and (çç»åç§° like '%" + value + "%') order by çç»ä»£ç desc"; |
| | | childPage.getData(childSWhere, tableView); |
| | | //=================================================================================================================================== |
| | | }, 200); |
| | | } |
| | | , end: function () { |
| | | childPage = null; |
| | | currRowIndex = 0; |
| | | if (childData != null) { |
| | | //æ ¹æ®å¼¹çªè¿åæ°æ®è®¾ç½®ææ¬æ¡æ°æ®================================================================================================= |
| | | //è·åæ°æ® |
| | | $("#HGroupID").val(childData.HItemID);//çç»id |
| | | $("#HGroupName").val(childData.çç»åç§°);//çç»åç§° |
| | | //=============================================================================================================================== |
| | | |
| | | childData = null; |
| | | } |
| | | } |
| | | }); |
| | | } else { |
| | | setTimeout(function () { |
| | | //ä¿®æ¹ï¼æ ¹æ®ææ¬æ¡æ°æ®ï¼ç¼åæ¥è¯¢è¯å¥================================================================================================ |
| | | var value = $("#HGroupName").val().replace(/'/g, ""); //è·åææ¬æ¡ææ°å¼ |
| | | currRowIndex = 0; |
| | | var tableView = "h_v_Gy_GroupList"; |
| | | var childSWhere = "select top(10) HItemID,çç»ä»£ç ,çç»åç§° from " + tableView + " where 1=1 and (çç»åç§° like '%" + value + "%') order by çç»ä»£ç desc"; |
| | | childPage.getData(childSWhere, tableView); |
| | | //================================================================================================================================= |
| | | }, 200); |
| | | } |
| | | } else { //妿æä¸çé®ä½æ¯ æ¹åé®ï¼åè°æ´çªå£ä¸ éä¸è¡ çä½ç½® |
| | | if (event.key == "ArrowUp") { |
| | | currRowIndex--; |
| | | childPage.setSelectedRow(currRowIndex); |
| | | } else if (event.key == "ArrowDown") { |
| | | currRowIndex++; |
| | | childPage.setSelectedRow(currRowIndex); |
| | | } else if (event.key == "Enter") { |
| | | //æå¨å¤±ç¦ |
| | | var element = document.getElementById("HGroupName"); |
| | | element.blur(); |
| | | |
| | | childPage.getSelectedData(currRowIndex); |
| | | |
| | | if (childData != null) { |
| | | //æ ¹æ®å¼¹çªè¿åæ°æ®è®¾ç½®ææ¬æ¡æ°æ®================================================================================================= |
| | | //è·åæ°æ® |
| | | $("#HGroupID").val(childData.HItemID);//çç»id |
| | | $("#HGroupName").val(childData.çç»åç§°);//çç»åç§° |
| | | //=============================================================================================================================== |
| | | |
| | | childData = null; |
| | | } |
| | | |
| | | |
| | | childPage = null; |
| | | currRowIndex = 0; |
| | | childData = null; |
| | | } |
| | | } |
| | | }); |
| | | //#endregion |
| | | }); |
| | | //#endregion |
| | | |
| | | //#endregion |
| | | }); |
| | | </script> |