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/layui/layui1.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/zgqCustom/zgqCustom.js"></script> |
| | | <style> |
| | | /*æ ç¶å¾ç¹å»é«äº®åè²*/ |
| | | .layui-tree-set-active > .layui-tree-entry .layui-tree-main { |
| | | background: #aef0f7; |
| | | } |
| | | </style> |
| | | </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-inline"> |
| | | <label class="layui-form-label">年份ï¼</label> |
| | | <div class="layui-input-block" style="width:100px;"> |
| | | <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"> |
| | | <input type="text" class="layui-input" lay-verify="HEquipType" name="HEquipType" id="HEquipType" value="" style="background-color:#efefef4d;width: 60%;display: inline-block;"> |
| | | <input type="hidden" name="HEquipTypeID" id="HEquipTypeID" class="layui-input" value="0" style="float:left;width:150px;"> |
| | | <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnHEquipType" id="btnHEquipType" style=""> |
| | | <i class="layui-icon layui-icon-search layuiadmin-button-btn"></i> |
| | | </button> |
| | | </div> |
| | | </div> |
| | | <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnSearch" id="btnSearch" style="margin-left:40px;"> |
| | | æ¥è¯¢ |
| | | </button> |
| | | <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnReSearch" id="btnReSearch" style="padding:0 5px">éç½®</button> |
| | | <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnExit" id="btnExit" style="padding:0 5px">éåº</button> |
| | | </div> |
| | | </div> |
| | | <table class="" id="mainTable" lay-filter="mainTable" style="margin-top:10px;"></table> |
| | | </form> |
| | | </div> |
| | | </div> |
| | | </div> |
| | | </div> |
| | | <script> |
| | | //#region æå 注é |
| | | //#endregion |
| | | layui.config({ |
| | | base: '../../../layuiadmin/' //éæèµæºæå¨è·¯å¾ |
| | | }).extend({ |
| | | index: 'lib/index', //主å
¥å£æ¨¡å |
| | | }).use(['index', 'form', 'table', 'element', 'laypage', 'laydate', 'soulTable', 'tree'], 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 |
| | | , tree = layui.tree |
| | | var sWhere = ""; |
| | | var option = []; |
| | | var HModName = "Sb_EquipMaintainWarningReport"; |
| | | //ä¸éè¦æ¾ç¤ºçåæ®µ 坿©å± |
| | | var titleData = ["HItemID", "Hprocid", "HUSEORGID","设å¤ç±»å"]; |
| | | //#endregion |
| | | |
| | | //#region è¿å
¥é¡µé¢å³å è½½ |
| | | |
| | | //åå§åçé¢ |
| | | set_ClearBill(); |
| | | //#endregion |
| | | |
| | | //#region 触åäºä»¶ï¼å
æ¬form.on(){}æ ¼å¼çææç¹å»äºä»¶ãéæ©äºä»¶ç |
| | | //æ¥è¯¢æé® |
| | | form.on('submit(btnSearch)', function (data) { |
| | | get_FastQuery(); |
| | | }); |
| | | |
| | | //éç½®æé® |
| | | form.on('submit(btnReSearch)', function (data) { |
| | | set_ClearQuery(); |
| | | }); |
| | | |
| | | //éåºæé® |
| | | form.on('submit(btnExit)', function (data) { |
| | | Pub_Close(2); |
| | | }); |
| | | |
| | | //设å¤åç±» |
| | | form.on('submit(btnHEquipType)', function (data) {//éæ©è®¾å¤åç±» |
| | | layer.open({ |
| | | type: 2 |
| | | , area: ['80%', '80%'] |
| | | , title: '设å¤åç±»' |
| | | , shade: 0.6 //é®ç½©éæåº¦ |
| | | //, maxmin: true //å
许å
¨å±æå°å |
| | | , anim: 0 //0-6çå¨ç»å½¢å¼ï¼-1ä¸å¼å¯ |
| | | , content: ['../../åºç¡èµæ/å
¬ç¨åºç¡èµæ/Gy_EquipType.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('è¯·éæ©æ°æ®'); |
| | | } |
| | | $("#HEquipTypeID").val(checkStatus.data[0].HItemID); |
| | | $("#HEquipType").val(checkStatus.data[0].HName); |
| | | layer.close(layer.index); //å®è·åçå§ç»æ¯ææ°å¼¹åºçæä¸ªå±ï¼å¼æ¯ç±layerå
é¨å¨æéå¢è®¡ç®ç |
| | | } |
| | | }) |
| | | }); |
| | | //#endregion |
| | | |
| | | |
| | | //#region æ¬é¡µé¢ææè¢«è°ç¨çæ¹æ³ |
| | | |
| | | //#region åå§åçé¢ |
| | | function set_ClearBill() { |
| | | //åå§åè¡¨æ ¼ |
| | | set_InitGrid(); |
| | | //å¹´ |
| | | Year(); |
| | | //æ¥è¯¢ |
| | | get_FastQuery(); |
| | | } |
| | | //#endregion |
| | | |
| | | //å¹´ |
| | | 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) |
| | | form.render('select'); |
| | | } |
| | | |
| | | //#region æ¥è¯¢ |
| | | function get_Display(sWhere) { |
| | | var ajaxLoad = layer.load(); |
| | | var HYear = $("#HYear").val(); |
| | | var HEquipTypeID = $("#HEquipTypeID").val(); |
| | | //è¿å
¥é¡µé¢æ¾ç¤ºçç¼åå表 |
| | | $.ajax({ |
| | | url: GetWEBURL() + '/Sb_EquipMaintainWarning/Report', |
| | | type: "GET", |
| | | data: { "HYear": HYear,"HEquipTypeID": HEquipTypeID,"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 }); |
| | | //è·åä¸éè¦æ¾ç¤ºçåï¼Hå¼å¤´çå䏿¾ç¤ºï¼ |
| | | var patrn = new RegExp(/^h/i); |
| | | if (patrn.test(data1.list[key].ColmCols)) { |
| | | titleData[key] = data1.list[key].ColmCols; |
| | | } |
| | | } |
| | | //å¨å表左边添å å¾éæ¡ |
| | | //col.push({ type: 'checkbox', fixed: 'left' }); |
| | | 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')}}</div>", width: 200 }); |
| | | 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: 200 }); |
| | | } |
| | | } |
| | | } |
| | | //卿æ¾ç¤ºåå |
| | | option = { |
| | | elem: '#mainTable' |
| | | , cols: [col] |
| | | , data: data1.data |
| | | , height: 'full-80' |
| | | , page: true |
| | | , limits: [50, 500, 5000, 50000] |
| | | , limit: 50 |
| | | , cellMinWidth: 90 |
| | | , totalRow: true |
| | | , done: function (res, curr, count) { |
| | | //ä¿®æ¹åå
æ ¼é¢è² |
| | | //å·²ç¹æ£ Y |
| | | //æªç¹æ£ E |
| | | //é¢è¦ P |
| | | var that = this.elem.next(); |
| | | res.data.forEach(function (item, index) { |
| | | var tr = that.find("[data-index=" + index + "]").children(); |
| | | tr.each(function () { |
| | | var tableText = $(this).text(); //åå
æ ¼ä¸çå
容 |
| | | if (tableText == "Y") { |
| | | $(this).css("background-color", "#D6F7D1");//åå
æ ¼èæ¯é¢è² |
| | | //$(this).css("color", "#ff241c");//åå
æ ¼åä½é¢è² |
| | | } |
| | | else if (tableText == "E") { |
| | | $(this).css("background-color", "#F5C6C6");//åå
æ ¼èæ¯é¢è² |
| | | //$(this).css("color", "#45ff2a");//åå
æ ¼åä½é¢è² |
| | | } else if (tableText == "P") { |
| | | $(this).css("background-color", "#F5F5C1");//åå
æ ¼èæ¯é¢è² |
| | | //$(this).css("color", "#45ff2a");//åå
æ ¼åä½é¢è² |
| | | } else { |
| | | //$(this).css("background-color", "#fffefd");//åå
æ ¼èæ¯é¢è² |
| | | //$(this).css("color", "#45ff2a");//åå
æ ¼åä½é¢è² |
| | | } |
| | | }) |
| | | }) |
| | | |
| | | //var dayInMonth = new Date(new Date().getFullYear(), new Date().getMonth() + 1, 0).getDate() |
| | | //for (var i = 0; i < data1.data.length; i++) { |
| | | // for (var j = 0; j < dayInMonth; j++) { |
| | | // if (data1.data[i][j] == "å·²ç¹æ£") { |
| | | // //option.cols[0][j + 1]["style"] = "background-color: #c3fec8"; |
| | | // $("tr[data-index='" + i + "']").attr({ "style": "background:#99ff99" }); //å°å½åè¡åæç»¿è² |
| | | // } |
| | | // } |
| | | //} |
| | | |
| | | soulTable.render(this); |
| | | } |
| | | } |
| | | |
| | | ins = table.render(option); |
| | | |
| | | layer.close(ajaxLoad); |
| | | if ($("#Comparator").val() == 0 && $("#ColContent").val() == "") { |
| | | ColFilter(); |
| | | } |
| | | } else { |
| | | option.data = data1.data |
| | | ins = table.render(option); |
| | | layer.close(ajaxLoad); |
| | | //layer.alert(data1.code + data1.Message, { icon: 5 }); |
| | | } |
| | | }, error: function () { |
| | | layer.close(ajaxLoad); |
| | | layer.alert("æ¥å£è¯·æ±å¤±è´¥!", { icon: 5 }); |
| | | } |
| | | |
| | | }); |
| | | } |
| | | //#endregion |
| | | |
| | | //#region å¿«éè¿æ»¤ |
| | | function get_FastQuery(sql) { |
| | | var HYear = $("#HYear").val(); |
| | | var HEquipType = $("#HEquipType").val(); |
| | | |
| | | //if (HDate) { |
| | | // sWhere += " and CONVERT(varchar(100),æå±æ¥æ, 23) >= '" + HDate + "'"; |
| | | //} |
| | | //if (HDate1) { |
| | | // sWhere += " and CONVERT(varchar(100),æå±æ¥æ, 23) <= '" + HDate1 + "'"; |
| | | //} |
| | | //if (HEquipFileNo) { |
| | | // sWhere += " and 设å¤ç¼ç like '%" + HEquipFileNo + "%'"; |
| | | //} |
| | | //if (HName) { |
| | | // sWhere += " and 设å¤åç§° like '%" + HName + "%'"; |
| | | //} |
| | | get_Display(sWhere); |
| | | sWhere = "";//è°ç¨æ¥å£åæ¸
空sWhereç¼å |
| | | } |
| | | //#endregion |
| | | |
| | | //#region éç½®è¿æ»¤æ¡ä»¶æ¹æ³ |
| | | function set_ClearQuery() { |
| | | $("#HYear").val(new Date().getFullYear()); |
| | | $("#HEquipType").val(""); |
| | | $("#HEquipTypeID").val("0"); |
| | | form.render('select'); |
| | | sWhere = ""; |
| | | } |
| | | //#endregion |
| | | |
| | | //åå§åè¡¨æ ¼ |
| | | function set_InitGrid() { |
| | | option = { |
| | | elem: '#mainTable' |
| | | , height: 'full-50' |
| | | , page: true |
| | | , totalRow: true |
| | | , limits: [50, 500, 5000, 20000] |
| | | , limit: 50 //æ¯é¡µé»è®¤æ¾ç¤ºçæ°é |
| | | , cellMinWidth: 200 |
| | | , done: function (res, curr, count) { |
| | | soulTable.render(this); |
| | | } |
| | | }; |
| | | } |
| | | |
| | | //#endregion |
| | | |
| | | //以䏿¯layui模å |
| | | }); |
| | | </script> |
| | | </body> |
| | | </html> |