| | |
| | | <Content Include="views\ç产管ç\å¼å¸¸åé¦å\Sc_MESExecptFeedBackBillType.html" /> |
| | | <Content Include="views\ç产管ç\æ¥å·¥å°å·¥åº\å¼å·¥\Sc_SwipeCardStart.html" /> |
| | | <Content Include="views\ç产管ç\ç产任å¡å\Sc_ICMOBillOrProcessExchangeResumeList.html" /> |
| | | <Content Include="views\ç产管ç\ç产æ¥è¡¨\Sc_ProductionInProgressReport.html" /> |
| | | <Content Include="views\ç产管ç\ç产æ¥è¡¨\Sc_NutInspectionCCDPassRate.html" /> |
| | | <Content Include="views\ç产管ç\ç产æ¥è¡¨\Sc_QualityReportBillMonth.html" /> |
| | | <Content Include="views\ç产管ç\ç产æ¥è¡¨\Sc_QualityReportBillDay.html" /> |
| | |
| | | <Content Include="views\è´¨é管ç\æ£éªåæ ·è¿æ ·å\QC_BackSampleCheckBillMainList.html" /> |
| | | <Content Include="views\è´¨é管ç\æ£éªåæ ·è¿æ ·å\QC_TakeSampleCheckBillMainList.html" /> |
| | | <Content Include="views\è´¨é管ç\æ£éªåæ ·è¿æ ·å\QC_Add_TakeSampleCheckBill.html" /> |
| | | <Content Include="views\è´¨é管ç\è´¨éæ¥è¡¨\QC_ErrManagerLedgerReport_EquipTop3Issue.html" /> |
| | | <Content Include="views\è´¨é管ç\è´¨éæ¥è¡¨\QC_ErrManagerLedgerReport_Issue.html" /> |
| | | <Content Include="views\è´¨é管ç\è´¨éæ¥è¡¨\QC_ErrManagerLedgerReport_SourceOfTheProblem.html" /> |
| | | <Content Include="views\è´¨é管ç\è´¨éæ¥è¡¨\QC_ErrManagerLedgerReport_Source.html" /> |
| | | <Content Include="views\è´¨é管ç\è´¨éæ¥è¡¨\QC_ErrMsgBackBillList.html" /> |
| | | <Content Include="views\è´¨é管ç\è´¨éæ¥è¡¨\QC_BadProductsReport.html" /> |
| | | <Content Include="views\è´¨é管ç\è´¨éæ¥è¡¨\QC_InspectionFormReport.html" /> |
| 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, 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">æ¥æé´é</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">å¼å§æ¥æ</label> |
| | | <div class="layui-input-block"> |
| | | <input type="date" class="layui-input ForFilteringSchemes" id="HBeginDate" style="width:190px;"> |
| | | </div> |
| | | </div> |
| | | <div class="layui-inline"> |
| | | <label class="layui-form-label">ç»ææ¥æ</label> |
| | | <div class="layui-input-block"> |
| | | <input type="date" class="layui-input ForFilteringSchemes" id="HEndDate" style="width:190px;"> |
| | | </div> |
| | | </div> |
| | | <div class="layui-inline"> |
| | | <label class="layui-form-label">é¨é¨</label> |
| | | <div class="layui-input-block" style="width: 190px;"> |
| | | <select name="HDeptName" id="HDeptName" lay-verify="HDeptName"> |
| | | <!--å¨ææ¸²æé¨é¨--> |
| | | </select> |
| | | </div> |
| | | </div> |
| | | <div class="layui-row" style="margin-top:5px;margin-left:82px;margin-bottom:5px;"> |
| | | <div class="layui-inline"> |
| | | <label class="layui-form-label">è§æ ¼åå·</label> |
| | | <div class="layui-input-block"> |
| | | <input type="text" class="layui-input ForFilteringSchemes" name="HMaterModel" id="HMaterModel" style="width:215px;"> |
| | | </div> |
| | | </div> |
| | | <div class="layui-inline"> |
| | | <label class="layui-form-label">çäº§èµæº</label> |
| | | <div class="layui-input-block"> |
| | | <input type="text" class="layui-input ForFilteringSchemes" name="HSourceName" id="HSourceName" style="width:190px;"> |
| | | </div> |
| | | </div> |
| | | <div class="layui-inline"> |
| | | <label class="layui-form-label">é®é¢æ¥æº</label> |
| | | <div class="layui-input-block"> |
| | | <input type="text" class="layui-input ForFilteringSchemes" name="HProSource" id="HProSource" style="width:190px;"> |
| | | </div> |
| | | </div> |
| | | <div class="layui-inline"> |
| | | <label class="layui-form-label">çæ¬¡</label> |
| | | <div class="layui-input-block"> |
| | | <input type="text" class="layui-input ForFilteringSchemes" name="HShiftsName" id="HShiftsName" style="width:128px;"> |
| | | </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 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="toolbarDemo"> |
| | | <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_ProductionInProgressReport"; |
| | | 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(); |
| | | }); |
| | | |
| | | //æ¥æé´é䏿å表çå¬ |
| | | form.on('select(HInitTimeCycle)', function (data) { |
| | | var HInitTimeCycle = $("#HInitTimeCycle").val() * 1; |
| | | //è¥æ¥æé´éä¸ä¸º ä»»æé´éï¼åç¦ç¨å¼å§æ¥æä¸ç»ææ¥æçéæ© |
| | | if (HInitTimeCycle != -1) { |
| | | $('#HBeginDate').prop('disabled', true); |
| | | $('#HEndDate').prop('disabled', true); |
| | | |
| | | $("#HBeginDate").val(Format(new Date(new Date() - 1000 * 60 * 60 * 24 * HInitTimeCycle), "yyyy-MM-dd")); |
| | | $("#HEndDate").val(Format(new Date(), "yyyy-MM-dd")); |
| | | |
| | | //æ§è¡æ¥è¯¢æ¹æ³ |
| | | get_FastQuery(); |
| | | } else { |
| | | $('#HBeginDate').prop('disabled', false); |
| | | $('#HEndDate').prop('disabled', false); |
| | | } |
| | | }); |
| | | |
| | | //#endregion |
| | | |
| | | //#region æ¤é¡µé¢ææçæ¹æ³ |
| | | |
| | | // åå§åçé¢ |
| | | function set_ClearBill() { |
| | | //åå§åæ¥æé´éãå¼å§æ¥æãç»ææ¥æ |
| | | setSelect_HInitTimeCycle(); |
| | | //è¥æ¥æé´éä¸ä¸º ä»»æé´éï¼åç¦ç¨å¼å§æ¥æä¸ç»ææ¥æçéæ© |
| | | var HInitTimeCycle = $("#HInitTimeCycle").val() * 1; |
| | | if (HInitTimeCycle != -1) { |
| | | $('#HBeginDate').prop('disabled', true); |
| | | $('#HEndDate').prop('disabled', true); |
| | | } else { |
| | | $('#HBeginDate').prop('disabled', false); |
| | | $('#HEndDate').prop('disabled', false); |
| | | } |
| | | |
| | | //æ ¹æ®æ¥æé´é设置å¼å§æ¶é´ä¸ç»ææ¶é´ |
| | | $("#HBeginDate").val(Format(new Date(new Date() - 1000 * 60 * 60 * 24 * HInitTimeCycle), "yyyy-MM-dd")); |
| | | $("#HEndDate").val(Format(new Date(), "yyyy-MM-dd")); |
| | | DeptName(); |
| | | //æ¥è¯¢ |
| | | get_FastQuery(); |
| | | } |
| | | |
| | | //çäº§è½¦é´ |
| | | 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 set_InitGrid() { |
| | | option = { |
| | | elem: '#mainTable' |
| | | , toolbar: '#toolbarDemo' |
| | | , height: 'full-50' |
| | | , page: true |
| | | , totalRow: true |
| | | , limit: 500 |
| | | , data:[] |
| | | , limits: [50, 500, 5000, 20000] |
| | | , cols: [] |
| | | }; |
| | | table.render(option); |
| | | } |
| | | |
| | | // æ¥è¯¢ |
| | | function get_Display(sWhere) { |
| | | |
| | | var ajaxLoad = layer.load(); |
| | | $.ajax({ |
| | | url: GetWEBURL() + '/QC_CustomerAppealReport/QC_ErrManagerLedgerReport', |
| | | type: "GET", |
| | | async: false, |
| | | data: { "sWhere": sWhere, "user": sessionStorage["HUserName"] }, |
| | | success: function (data1) { |
| | | if (data1.count == 1) { |
| | | var data = [];//ååæ®µæ°æ® |
| | | var col = []; |
| | | var totalArray = ["æ°é", "å
³èæ°é", "æªå
³èæ°é", "æå°æ¡ç æ°é", "æªæå°æ¡ç æ°é", "宿¶æ°é", "éé¢"]; |
| | | //ç»ç©ºçæ°ç»èµå¼ |
| | | 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++) { |
| | | // 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 if ($.inArray(data[i].name, totalArray) > -1) { //计ç®å |
| | | col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: true, totalRow: true, width: 120 }); |
| | | } else if (data[i].name == 'åæ®å·') {//æ·»å è¶
龿¥ |
| | | col.push({ |
| | | field: data[i].id, title: data[i].name, align: 'center', sort: true, width: 200, event: 'åæ®å·', templet: function (d) { |
| | | return '<span style="color: blue;">' + d.åæ®å· + '</span>' |
| | | }, style: 'cursor: pointer;' |
| | | }); |
| | | } 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, width: 200 }); |
| | | } |
| | | } |
| | | } |
| | | |
| | | //卿æ¾ç¤ºåå |
| | | option = { |
| | | elem: '#mainTable' |
| | | , toolbar: '#toolbarDemo' |
| | | , cols: [col] |
| | | , data: data1.data |
| | | , height: 'full-50' |
| | | , 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); |
| | | //layer.alert("æ¥è¯¢æå", { icon: 1 }); |
| | | } 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 HBeginDate = $("#HBeginDate").val(); |
| | | var HEndDate = $("#HEndDate").val(); |
| | | var HDeptID = $("#HDeptName").val(); |
| | | var HMaterModel = $("#HMaterModel").val(); |
| | | var HSourceName = $("#HSourceName").val(); |
| | | var HProSource = $("#HProSource").val(); |
| | | var HShiftsName = $("#HShiftsName").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 = { |
| | | HBeginDate: HBeginDate |
| | | , HEndDate: HEndDate |
| | | , HDeptID: HDeptID |
| | | , HMaterModel: HMaterModel |
| | | , HSourceName: HSourceName |
| | | , HProSource: HProSource |
| | | , HShiftsName: HShiftsName |
| | | , HCustomize: sWhere |
| | | } |
| | | set_InitGrid(); |
| | | get_Display(JSON.stringify(sWhere)); |
| | | sWhere = "";//è°ç¨æ¥å£åæ¸
空sWhereç¼å |
| | | } |
| | | |
| | | function set_ClearQuery() { |
| | | var HInitTimeCycle = $("#HInitTimeCycle").val() * 1; |
| | | $("#HBeginDate").val(Format(new Date(new Date() - 1000 * 60 * 60 * 24 * HInitTimeCycle), "yyyy-MM-dd")); //å¼å§æ¥æ |
| | | $("#HEndDate").val(Format(new Date(), "yyyy-MM-dd")); //ç»ææ¥æ |
| | | $("#HDeptName").val("0"); |
| | | $("#HMaterModel").val(""); |
| | | $("#HSourceName").val(""); |
| | | $("#HProSource").val(""); |
| | | $("#HShiftsName").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'); |
| | | } |
| | | |
| | | //#region åå§æ¥æé´é 䏿å表 |
| | | function setSelect_HInitTimeCycle() { |
| | | var valueList = [0, 1, 2, 3, 4, 5, 6, 29]; |
| | | var titleList = ["ä»å¤©", "è¿ä¸¤å¤©", "è¿ä¸å¤©", "è¿å天", "è¿äºå¤©", "è¿å
天", "è¿ä¸å¤©", "è¿30天"]; |
| | | |
| | | 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("29"); |
| | | } |
| | | //#endregion |
| | | |
| | | //#endregion |
| | | |
| | | //以䏿¯layui模å |
| | | }); |
| | | |
| | | |
| | | |
| | | |
| | | </script> |
| New file |
| | |
| | | <!DOCTYPE html> |
| | | <html> |
| | | <head> |
| | | <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> |
| | | <title>设å¤TOP3é®é¢</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/lib/extend/echarts.min.js'></script> |
| | | <style type="text/css"> |
| | | input.layui-input.layui-unselect { |
| | | padding-right: 0; |
| | | } |
| | | </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-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"> |
| | | <!--å¨ææ¸²ææä»½--> |
| | | </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;"> |
| | | <!--å
¶ä»æ¡ä»¶--> |
| | | </div> |
| | | </div> |
| | | </div> |
| | | </div> |
| | | <div> |
| | | <div style="width:99.5%;height:calc(60vh);margin-top:10px;"> |
| | | <div id="histogram" style="width:60%;height:calc(60vh);float:left"> |
| | | |
| | | </div> |
| | | <div id="PieChart" style="width:39%;height:calc(60vh);float:left;margin-left:5px;"> |
| | | |
| | | </div> |
| | | </div> |
| | | <div style="width:99%;height:calc(50vh);"> |
| | | <table class="" id="mainTable" lay-filter="mainTable"></table> |
| | | </div> |
| | | </div> |
| | | <script type="text/html" id="toolbarDemo"> |
| | | <div class="layui-btn-container"> |
| | | <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-exit"><i class="layui-icon layui-icon-return"></i>éåº</button> |
| | | <button type="button" class="layui-btn layui-btn-sm" lay-event="HideColumn"><i class="layui-icon layui-icon-form"></i>éèå设置</button> |
| | | </div> |
| | | </script> |
| | | </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 |
| | | , util = layui.util |
| | | //æ¥è¯¢æ¡ä»¶ |
| | | var sWhere = ""; |
| | | var option = []; |
| | | var HModName = "QC_ErrManagerLedgerReport_EquipTop3Issue"; |
| | | var HEquipIssue = []; //设å¤é®é¢ |
| | | //#endregion |
| | | |
| | | //#region è¿å
¥é¡µé¢æ¢å è½½ |
| | | |
| | | //åå§åçé¢ |
| | | set_ClearBill(); |
| | | //#endregion |
| | | |
| | | //#region ãå¾å½¢ã |
| | | function set_Graphics() { |
| | | //#region ãæ±ç¶å¾ã |
| | | var app = {}; |
| | | var chartDom = document.getElementById('histogram'); |
| | | var myChart = echarts.init(chartDom); |
| | | var option_ZZT; |
| | | //#region [æ±ç¶å¾å¸å±æ ·å¼] |
| | | const posList = [ |
| | | 'left', |
| | | 'right', |
| | | 'top', |
| | | 'bottom', |
| | | 'inside', |
| | | 'insideTop', |
| | | 'insideLeft', |
| | | 'insideRight', |
| | | 'insideBottom', |
| | | 'insideTopLeft', |
| | | 'insideTopRight', |
| | | 'insideBottomLeft', |
| | | 'insideBottomRight' |
| | | ]; |
| | | app.configParameters = { |
| | | rotate: { |
| | | min: -90, |
| | | max: 90 |
| | | }, |
| | | align: { |
| | | options: { |
| | | left: 'left', |
| | | center: 'center', |
| | | right: 'right' |
| | | } |
| | | }, |
| | | verticalAlign: { |
| | | options: { |
| | | top: 'top', |
| | | middle: 'middle', |
| | | bottom: 'bottom' |
| | | } |
| | | }, |
| | | position: { |
| | | options: posList.reduce(function (map, pos) { |
| | | map[pos] = pos; |
| | | return map; |
| | | }, {}) |
| | | }, |
| | | distance: { |
| | | min: 0, |
| | | max: 100 |
| | | } |
| | | }; |
| | | app.config = { |
| | | rotate: 90, |
| | | align: 'left', |
| | | verticalAlign: 'middle', |
| | | position: 'insideBottom', |
| | | distance: 15, |
| | | onChange: function () { |
| | | const labelOption = { |
| | | rotate: app.config.rotate, |
| | | align: app.config.align, |
| | | verticalAlign: app.config.verticalAlign, |
| | | position: app.config.position, |
| | | distance: app.config.distance |
| | | }; |
| | | myChart.setOption({ |
| | | series: [ |
| | | { |
| | | label: labelOption |
| | | }, |
| | | { |
| | | label: labelOption |
| | | }, |
| | | { |
| | | label: labelOption |
| | | }, |
| | | { |
| | | label: labelOption |
| | | } |
| | | ] |
| | | }); |
| | | } |
| | | }; |
| | | const labelOption = { |
| | | show: true, |
| | | position: 'top' |
| | | }; |
| | | //#endregion |
| | | |
| | | //æ±ç¶å¾ç»å®æ°æ® |
| | | var HXTitle = [];//Xè½´æ é¢åç§° |
| | | var HSourceIssueCount = []; |
| | | var ZZTColor = []; |
| | | var ZZTColor2 = ['#00FFFF', '#FC2C83', '#FCED2C', '#93FC2C', '#FC2CF0', '#FC892C', '#2C81FC', '#2CC9FC', '#2CFCA7', '#DED3F2', '#F2D8D3', '#F2D3E0', '#D8E052', '#7EE052', '#52E0D8', '#5F52E0', '#E06F52', '#52E09B', '#E052DE', '#E05F52', '#52B2E0', '#E0C452', '#52CEE0', '#648690', '#E5D1D6', '#D8E5D1', '#E5D1E5', '#D8E5D1', '#7C6262', '#76627C', '#81A583', '#81A595']; |
| | | for (let i = 0; i < option.data.length; i++) { |
| | | HXTitle.push(option.data[i].TOP3é®é¢); |
| | | HSourceIssueCount.push(option.data[i].åçæ¬¡æ°); |
| | | ZZTColor.push({ |
| | | x: 1, |
| | | y: 0, |
| | | x2: 0, |
| | | y2: 0, |
| | | type: "linear", |
| | | colorStops: [ |
| | | { offset: 0, color: "red" }, |
| | | { offset: 1, color: "blue" } |
| | | ] |
| | | }); |
| | | } |
| | | option_ZZT = { |
| | | title: { |
| | | text: 'TOP3é®é¢æ°', |
| | | left: 'left', |
| | | textStyle: { |
| | | color: 'black', |
| | | fontSize: 18, |
| | | fontWeight: 'normal' |
| | | }, |
| | | padding: [5,0,0,65] |
| | | }, |
| | | tooltip: { |
| | | trigger: 'axis', |
| | | axisPointer: { |
| | | type: 'shadow' |
| | | } |
| | | }, |
| | | legend: { |
| | | data: HEquipIssue |
| | | }, |
| | | toolbox: { |
| | | show: true, |
| | | orient: 'vertical', |
| | | left: 'right', |
| | | top: 'center', |
| | | feature: { |
| | | mark: { show: true }, |
| | | dataView: { show: true, readOnly: false }, |
| | | magicType: { show: true, type: ['line', 'bar', 'stack'] }, |
| | | restore: { show: true }, |
| | | saveAsImage: { show: true } |
| | | } |
| | | }, |
| | | xAxis: [ |
| | | { |
| | | type: 'category', |
| | | axisTick: { show: true }, |
| | | data: HXTitle |
| | | } |
| | | ], |
| | | yAxis: [ |
| | | { |
| | | type: 'value' |
| | | } |
| | | ], |
| | | series: [ |
| | | { |
| | | name: 'TOP3é®é¢æ°', |
| | | type: 'bar', |
| | | barGap: 0, |
| | | label: labelOption, |
| | | emphasis: { |
| | | focus: 'series' |
| | | }, |
| | | data: HSourceIssueCount, |
| | | itemStyle: { |
| | | color: function (params) { |
| | | // å¨æçææ¸åè²æè
æ ¹æ®æ¡ä»¶è¿åé¢è®¾çæ¸åè² |
| | | const gradientColors = ZZTColor2; |
| | | |
| | | return gradientColors[params.dataIndex]; |
| | | } |
| | | } |
| | | } |
| | | ] |
| | | }; |
| | | option_ZZT && myChart.setOption(option_ZZT); |
| | | //#endregion |
| | | |
| | | //#region ã饼å¾ã |
| | | var chartDom = document.getElementById('PieChart'); |
| | | var myChart = echarts.init(chartDom); |
| | | var option_BT; |
| | | var HYear = $("#HYear").val() == "" ? "X" : $("#HYear").val(); |
| | | var HMonth = $("#HMonth").val() == "" ? "X" : $("#HMonth").val(); |
| | | |
| | | var option_BT_XData = []; |
| | | for (let i = 0; i < option.data.length; i++) { |
| | | option_BT_XData.push({ value: option.data[i].å æ¯.replace('%', ''), name: option.data[i].TOP3é®é¢ }); |
| | | } |
| | | |
| | | option_BT = { |
| | | title: { |
| | | text: HYear + 'å¹´' + HMonth + 'æä»½è®¾å¤TOP3é®é¢å æ¯', |
| | | left: 'center' |
| | | }, |
| | | tooltip: { |
| | | trigger: 'item' |
| | | }, |
| | | legend: { |
| | | top: 'bottom' |
| | | }, |
| | | series: [ |
| | | { |
| | | name: '设å¤TOP3é®é¢å æ¯', |
| | | type: 'pie', |
| | | radius: '50%', |
| | | data: option_BT_XData, |
| | | emphasis: { |
| | | itemStyle: { |
| | | shadowBlur: 10, |
| | | shadowOffsetX: 0, |
| | | shadowColor: 'rgba(0, 0, 0, 0.5)' |
| | | } |
| | | }, |
| | | itemStyle: { |
| | | color: function (params) { |
| | | // å¨æçææ¸åè²æè
æ ¹æ®æ¡ä»¶è¿åé¢è®¾çæ¸åè² |
| | | const gradientColors = ZZTColor2; |
| | | |
| | | return gradientColors[params.dataIndex]; |
| | | } |
| | | } |
| | | } |
| | | ] |
| | | }; |
| | | |
| | | option_BT && myChart.setOption(option_BT); |
| | | //#endregion |
| | | } |
| | | |
| | | //#region ç¹å»äºä»¶å
æ¬on formäºä»¶ç |
| | | //头工å
·æ äºä»¶ |
| | | table.on('toolbar(mainTable)', function (obj) { |
| | | switch (obj.event) { |
| | | //éåº |
| | | case 'btn-exit': Pub_Close(2); |
| | | break; |
| | | //éèå设置 |
| | | case 'HideColumn': |
| | | get_HideColumn(); |
| | | break; |
| | | }; |
| | | }); |
| | | //éç½®æé® |
| | | form.on('submit(btnReSearch)', function (data) { |
| | | set_ClearQuery(); |
| | | }); |
| | | |
| | | //æ¥è¯¢æé® |
| | | form.on('submit(btnSearch)', function (data) { |
| | | get_FastQuery(); |
| | | }); |
| | | //#endregion |
| | | |
| | | //#region æ¤é¡µé¢ææçæ¹æ³ |
| | | |
| | | //åå§åçé¢ |
| | | function set_ClearBill() { |
| | | Year(); |
| | | Month(); |
| | | //åå§åè¡¨æ ¼ |
| | | set_InitGrid(); |
| | | //å è½½æ°æ®å°ç½æ ¼ |
| | | get_FastQuery(); |
| | | //DisPlay_HideColumn(); |
| | | set_Graphics(); |
| | | } |
| | | |
| | | //åå§åè¡¨æ ¼ |
| | | function set_InitGrid() { |
| | | option = { |
| | | elem: '#mainTable' |
| | | , toolbar: '#toolbarDemo' |
| | | , height: 'full-320' |
| | | , page: true |
| | | , totalRow: true |
| | | , cellMinWidth: 90 |
| | | , limit: 200 |
| | | , limits: [50, 500, 5000, 20000] |
| | | } |
| | | } |
| | | |
| | | //å¹´ |
| | | function Year() { |
| | | var yyyy = new Date().getFullYear(); |
| | | var YearOption = ""; |
| | | YearOption += '<option style="color:blue;" value="">' + "è¯·éæ©" + '</option>'; |
| | | 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'); |
| | | } |
| | | |
| | | //æ |
| | | function Month() { |
| | | var mm = new Date().getMonth() + 1; |
| | | var MonthOption = ""; |
| | | MonthOption += '<option style="color:blue;" value="">' + "è¯·éæ©" + '</option>'; |
| | | for (var i = 1; i <= 12; i++) { |
| | | MonthOption += '<option style="color:blue;" value="' + (i) + '">' + (i) + '</option>'; |
| | | } |
| | | $("#HMonth").append(MonthOption); |
| | | $("#HMonth").val(mm) |
| | | form.render('select'); |
| | | } |
| | | |
| | | //å è½½ç½æ ¼ |
| | | function get_Display(DateYear) { |
| | | var HYear = $("#HYear").val(); |
| | | var HMonth = $("#HMonth").val(); |
| | | var wait = layer.load();//é®ç½© |
| | | $.ajax({ |
| | | url: GetWEBURL() + '/QC_CustomerAppealReport/QC_ErrManagerLedgerReport_EquipTop3Issue', |
| | | type: "GET", |
| | | async: false, |
| | | data: { "HYear": HYear, "HMonth": HMonth, "user": sessionStorage["HUserName"] }, |
| | | success: function (data1) { |
| | | var col = []; |
| | | if (data1.count == 1) { |
| | | var data = []; |
| | | //ç»ç©ºçæ°ç»èµå¼ |
| | | for (var key in data1.list) { |
| | | data.push({ "name": data1.list[key].ColmCols, "Type": data1.list[key].ColmType }); |
| | | } |
| | | col.push({ type: 'checkbox', fixed: 'left', totalRowText: 'æ±æ»' }); |
| | | //夿æ¯å¦æ¯çº¯è±æ |
| | | var patrn = new RegExp("[\u4E00-\u9FA5]+"); |
| | | for (var i = 0; i < data.length; i++) { |
| | | if (!patrn.test(data[i].name)) { |
| | | col.push({ field: data[i].name, title: data[i].name, hide: true }); //éèå |
| | | } |
| | | else { |
| | | switch (data[i].Type) { |
| | | case 'DateTime': |
| | | col.push({ field: data[i].name, 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: 120 }); |
| | | break; |
| | | case 'long': |
| | | case 'Int32': |
| | | case 'Int64': |
| | | case 'double': |
| | | case 'Decimal': |
| | | col.push({ field: data[i].name, title: data[i].name, align: 'center', sort: true, totalRow: true }); |
| | | break; |
| | | default: |
| | | col.push({ field: data[i].name, title: data[i].name, align: 'center', sort: true }); |
| | | } |
| | | } |
| | | } |
| | | |
| | | for (var i = 0; i < data1.length; i++) { |
| | | HEquipIssue.push(data1.data[i].TOP3é®é¢); |
| | | } |
| | | |
| | | option.cols = [col]; |
| | | option.data = data1.data; |
| | | |
| | | table.render(option); |
| | | layer.close(wait); |
| | | } else { |
| | | layer.close(wait); |
| | | layer.alert(data1.Message, { icon: 5 }); |
| | | } |
| | | }, error: function () { |
| | | layer.close(wait); |
| | | layer.alert("æ¥å£è¯·æ±å¤±è´¥!", { icon: 5 }); |
| | | } |
| | | }); |
| | | } |
| | | |
| | | //å¿«éè¿æ»¤ |
| | | function get_FastQuery() { |
| | | get_Display(sWhere); |
| | | //è°ç¨æ¥å£åæ¸
空sWhereç¼å |
| | | sWhere = ""; |
| | | set_Graphics(); |
| | | } |
| | | |
| | | //éç½®è¿æ»¤æ¡ä»¶ |
| | | function set_ClearQuery() { |
| | | var yyyy = new Date().getFullYear(); |
| | | $("#HYear").val(yyyy); |
| | | var mm = new Date().getMonth() + 1; |
| | | $("#HMonth").val(mm) |
| | | form.render('select'); |
| | | |
| | | sWhere = ""; |
| | | get_FastQuery(); |
| | | } |
| | | |
| | | //éèå设置 |
| | | function get_HideColumn() { |
| | | var colName = ""; |
| | | for (var i = 1; i < option.cols[0].length - 1; i++) { |
| | | colName += option.cols[0][i]["title"] + ","; |
| | | } |
| | | |
| | | colName = encodeURI(colName.substring(0, colName.length - 1));//对 URI è¿è¡ç¼ç |
| | | layer.open({ |
| | | type: 2 |
| | | , skin: "layui-layer-rim" //å ä¸è¾¹æ¡ |
| | | , title: "éèå设置" //æ é¢ |
| | | , closeBtn: 1 //çªä½å³ä¸è§å
³é ç æ ·å¼ |
| | | , shift: 2 //å¼¹åºå¨ç» |
| | | , area: ["50%", "90%"] //çªä½å¤§å° |
| | | , maxmin: true //设置æå¤§æå°æé®æ¯å¦æ¾ç¤º |
| | | , content: ['../../åºç¡èµæ/éèå设置/Gy_GridView_Hide.html?HModName=' + HModName + '&colName=' + colName, "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 = [];//æ°æ®åºæ¥è¯¢åºçåæ°æ® |
| | | var titleData = [];//ä¸éè¦æ¾ç¤ºçåæ®µ 坿©å± |
| | | |
| | | 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 (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 (dataCols[3] > 0) { |
| | | option.cols[0][i + 1]["width"] = dataCols[3]; |
| | | } |
| | | //æ¾ç¤ºå |
| | | 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 }); |
| | | } |
| | | }) |
| | | } |
| | | |
| | | //#endregion |
| | | }); |
| | | </script> |
| | | </body> |
| | | </html> |
| New file |
| | |
| | | <!DOCTYPE html> |
| | | <html> |
| | | <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/lib/extend/echarts.min.js'></script> |
| | | <style type="text/css"> |
| | | input.layui-input.layui-unselect { |
| | | padding-right: 0; |
| | | } |
| | | </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-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"> |
| | | <!--å¨ææ¸²ææä»½--> |
| | | </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;"> |
| | | <!--å
¶ä»æ¡ä»¶--> |
| | | </div> |
| | | </div> |
| | | </div> |
| | | </div> |
| | | <div> |
| | | <div style="width:99.5%;height:calc(60vh);margin-top:10px;"> |
| | | <div id="histogram" style="width:60%;height:calc(60vh);float:left"> |
| | | |
| | | </div> |
| | | <div id="PieChart" style="width:39%;height:calc(60vh);float:left;margin-left:5px;"> |
| | | |
| | | </div> |
| | | </div> |
| | | <div style="width:99%;height:calc(50vh);"> |
| | | <table class="" id="mainTable" lay-filter="mainTable"></table> |
| | | </div> |
| | | </div> |
| | | <script type="text/html" id="toolbarDemo"> |
| | | <div class="layui-btn-container"> |
| | | <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-exit"><i class="layui-icon layui-icon-return"></i>éåº</button> |
| | | <button type="button" class="layui-btn layui-btn-sm" lay-event="HideColumn"><i class="layui-icon layui-icon-form"></i>éèå设置</button> |
| | | </div> |
| | | </script> |
| | | </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 |
| | | , util = layui.util |
| | | //æ¥è¯¢æ¡ä»¶ |
| | | var sWhere = ""; |
| | | var option = []; |
| | | var HModName = "QC_ErrManagerLedgerReport_Issue"; |
| | | var HIssueType = []; //é®é¢ç±»å |
| | | //#endregion |
| | | |
| | | //#region è¿å
¥é¡µé¢æ¢å è½½ |
| | | |
| | | //åå§åçé¢ |
| | | set_ClearBill(); |
| | | //#endregion |
| | | |
| | | //#region ãå¾å½¢ã |
| | | function set_Graphics() { |
| | | //#region ãæ±ç¶å¾ã |
| | | var app = {}; |
| | | var chartDom = document.getElementById('histogram'); |
| | | var myChart = echarts.init(chartDom); |
| | | var option_ZZT; |
| | | //#region [æ±ç¶å¾å¸å±æ ·å¼] |
| | | const posList = [ |
| | | 'left', |
| | | 'right', |
| | | 'top', |
| | | 'bottom', |
| | | 'inside', |
| | | 'insideTop', |
| | | 'insideLeft', |
| | | 'insideRight', |
| | | 'insideBottom', |
| | | 'insideTopLeft', |
| | | 'insideTopRight', |
| | | 'insideBottomLeft', |
| | | 'insideBottomRight' |
| | | ]; |
| | | app.configParameters = { |
| | | rotate: { |
| | | min: -90, |
| | | max: 90 |
| | | }, |
| | | align: { |
| | | options: { |
| | | left: 'left', |
| | | center: 'center', |
| | | right: 'right' |
| | | } |
| | | }, |
| | | verticalAlign: { |
| | | options: { |
| | | top: 'top', |
| | | middle: 'middle', |
| | | bottom: 'bottom' |
| | | } |
| | | }, |
| | | position: { |
| | | options: posList.reduce(function (map, pos) { |
| | | map[pos] = pos; |
| | | return map; |
| | | }, {}) |
| | | }, |
| | | distance: { |
| | | min: 0, |
| | | max: 100 |
| | | } |
| | | }; |
| | | app.config = { |
| | | rotate: 90, |
| | | align: 'left', |
| | | verticalAlign: 'middle', |
| | | position: 'insideBottom', |
| | | distance: 15, |
| | | onChange: function () { |
| | | const labelOption = { |
| | | rotate: app.config.rotate, |
| | | align: app.config.align, |
| | | verticalAlign: app.config.verticalAlign, |
| | | position: app.config.position, |
| | | distance: app.config.distance |
| | | }; |
| | | myChart.setOption({ |
| | | series: [ |
| | | { |
| | | label: labelOption |
| | | }, |
| | | { |
| | | label: labelOption |
| | | }, |
| | | { |
| | | label: labelOption |
| | | }, |
| | | { |
| | | label: labelOption |
| | | } |
| | | ] |
| | | }); |
| | | } |
| | | }; |
| | | const labelOption = { |
| | | show: true, |
| | | position: 'top' |
| | | }; |
| | | //#endregion |
| | | |
| | | //æ±ç¶å¾ç»å®æ°æ® |
| | | var HXTitle = [];//Xè½´æ é¢åç§° |
| | | var HSourceIssueCount = []; |
| | | var ZZTColor = []; |
| | | var ZZTColor2 = ['#00FFFF', '#FC2C83', '#FCED2C', '#93FC2C', '#FC2CF0', '#FC892C', '#2C81FC', '#2CC9FC', '#2CFCA7', '#DED3F2', '#F2D8D3', '#F2D3E0', '#D8E052', '#7EE052', '#52E0D8', '#5F52E0', '#E06F52', '#52E09B', '#E052DE', '#E05F52', '#52B2E0', '#E0C452', '#52CEE0', '#648690', '#E5D1D6', '#D8E5D1', '#E5D1E5', '#D8E5D1', '#7C6262', '#76627C', '#81A583', '#81A595']; |
| | | for (let i = 0; i < option.data.length; i++) { |
| | | HXTitle.push(option.data[i].é®é¢); |
| | | HSourceIssueCount.push(option.data[i].é®é¢åçæ¬¡æ°); |
| | | ZZTColor.push({ |
| | | x: 1, |
| | | y: 0, |
| | | x2: 0, |
| | | y2: 0, |
| | | type: "linear", |
| | | colorStops: [ |
| | | { offset: 0, color: "red" }, |
| | | { offset: 1, color: "blue" } |
| | | ] |
| | | }); |
| | | } |
| | | option_ZZT = { |
| | | title: { |
| | | text: 'å¼å¸¸ç±»ååçæ¬¡æ°', |
| | | left: 'left', |
| | | textStyle: { |
| | | color: 'black', |
| | | fontSize: 18, |
| | | fontWeight: 'normal' |
| | | }, |
| | | padding: [5,0,0,65] |
| | | }, |
| | | tooltip: { |
| | | trigger: 'axis', |
| | | axisPointer: { |
| | | type: 'shadow' |
| | | } |
| | | }, |
| | | legend: { |
| | | data: HIssueType |
| | | }, |
| | | toolbox: { |
| | | show: true, |
| | | orient: 'vertical', |
| | | left: 'right', |
| | | top: 'center', |
| | | feature: { |
| | | mark: { show: true }, |
| | | dataView: { show: true, readOnly: false }, |
| | | magicType: { show: true, type: ['line', 'bar', 'stack'] }, |
| | | restore: { show: true }, |
| | | saveAsImage: { show: true } |
| | | } |
| | | }, |
| | | xAxis: [ |
| | | { |
| | | type: 'category', |
| | | axisTick: { show: true }, |
| | | data: HXTitle |
| | | } |
| | | ], |
| | | yAxis: [ |
| | | { |
| | | type: 'value' |
| | | } |
| | | ], |
| | | series: [ |
| | | { |
| | | name: 'å¼å¸¸åçæ¬¡æ°', |
| | | type: 'bar', |
| | | barGap: 0, |
| | | label: labelOption, |
| | | emphasis: { |
| | | focus: 'series' |
| | | }, |
| | | data: HSourceIssueCount, |
| | | itemStyle: { |
| | | color: function (params) { |
| | | // å¨æçææ¸åè²æè
æ ¹æ®æ¡ä»¶è¿åé¢è®¾çæ¸åè² |
| | | const gradientColors = ZZTColor2; |
| | | |
| | | return gradientColors[params.dataIndex]; |
| | | } |
| | | } |
| | | } |
| | | ] |
| | | }; |
| | | option_ZZT && myChart.setOption(option_ZZT); |
| | | //#endregion |
| | | |
| | | //#region ã饼å¾ã |
| | | var chartDom = document.getElementById('PieChart'); |
| | | var myChart = echarts.init(chartDom); |
| | | var option_BT; |
| | | var HYear = $("#HYear").val() == "" ? "X" : $("#HYear").val(); |
| | | var HMonth = $("#HMonth").val() == "" ? "X" : $("#HMonth").val(); |
| | | |
| | | var option_BT_XData = []; |
| | | for (let i = 0; i < option.data.length; i++) { |
| | | option_BT_XData.push({ value: option.data[i].å æ¯.replace('%', ''), name: option.data[i].é®é¢ }); |
| | | } |
| | | |
| | | option_BT = { |
| | | title: { |
| | | text: HYear + 'å¹´' + HMonth + 'æä»½å¼å¸¸ç±»åæ¯ä¾', |
| | | left: 'center' |
| | | }, |
| | | tooltip: { |
| | | trigger: 'item' |
| | | }, |
| | | legend: { |
| | | top: 'bottom' |
| | | }, |
| | | series: [ |
| | | { |
| | | name: 'å¼å¸¸é®é¢åçæ¬¡æ°æ¯ä¾', |
| | | type: 'pie', |
| | | radius: '50%', |
| | | data: option_BT_XData, |
| | | emphasis: { |
| | | itemStyle: { |
| | | shadowBlur: 10, |
| | | shadowOffsetX: 0, |
| | | shadowColor: 'rgba(0, 0, 0, 0.5)' |
| | | } |
| | | }, |
| | | itemStyle: { |
| | | color: function (params) { |
| | | // å¨æçææ¸åè²æè
æ ¹æ®æ¡ä»¶è¿åé¢è®¾çæ¸åè² |
| | | const gradientColors = ZZTColor2; |
| | | |
| | | return gradientColors[params.dataIndex]; |
| | | } |
| | | } |
| | | } |
| | | ] |
| | | }; |
| | | |
| | | option_BT && myChart.setOption(option_BT); |
| | | //#endregion |
| | | } |
| | | |
| | | //#region ç¹å»äºä»¶å
æ¬on formäºä»¶ç |
| | | //头工å
·æ äºä»¶ |
| | | table.on('toolbar(mainTable)', function (obj) { |
| | | switch (obj.event) { |
| | | //éåº |
| | | case 'btn-exit': Pub_Close(2); |
| | | break; |
| | | //éèå设置 |
| | | case 'HideColumn': |
| | | get_HideColumn(); |
| | | break; |
| | | }; |
| | | }); |
| | | //éç½®æé® |
| | | form.on('submit(btnReSearch)', function (data) { |
| | | set_ClearQuery(); |
| | | }); |
| | | |
| | | //æ¥è¯¢æé® |
| | | form.on('submit(btnSearch)', function (data) { |
| | | get_FastQuery(); |
| | | }); |
| | | //#endregion |
| | | |
| | | //#region æ¤é¡µé¢ææçæ¹æ³ |
| | | |
| | | //åå§åçé¢ |
| | | function set_ClearBill() { |
| | | Year(); |
| | | Month(); |
| | | //åå§åè¡¨æ ¼ |
| | | set_InitGrid(); |
| | | //å è½½æ°æ®å°ç½æ ¼ |
| | | get_FastQuery(); |
| | | //DisPlay_HideColumn(); |
| | | set_Graphics(); |
| | | } |
| | | |
| | | //åå§åè¡¨æ ¼ |
| | | function set_InitGrid() { |
| | | option = { |
| | | elem: '#mainTable' |
| | | , toolbar: '#toolbarDemo' |
| | | , height: 'full-320' |
| | | , page: true |
| | | , totalRow: true |
| | | , cellMinWidth: 90 |
| | | , limit: 200 |
| | | , limits: [50, 500, 5000, 20000] |
| | | } |
| | | } |
| | | |
| | | //å¹´ |
| | | function Year() { |
| | | var yyyy = new Date().getFullYear(); |
| | | var YearOption = ""; |
| | | YearOption += '<option style="color:blue;" value="">' + "è¯·éæ©" + '</option>'; |
| | | 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'); |
| | | } |
| | | |
| | | //æ |
| | | function Month() { |
| | | var mm = new Date().getMonth() + 1; |
| | | var MonthOption = ""; |
| | | MonthOption += '<option style="color:blue;" value="">' + "è¯·éæ©" + '</option>'; |
| | | for (var i = 1; i <= 12; i++) { |
| | | MonthOption += '<option style="color:blue;" value="' + (i) + '">' + (i) + '</option>'; |
| | | } |
| | | $("#HMonth").append(MonthOption); |
| | | $("#HMonth").val(mm) |
| | | form.render('select'); |
| | | } |
| | | |
| | | //å è½½ç½æ ¼ |
| | | function get_Display(DateYear) { |
| | | var HYear = $("#HYear").val(); |
| | | var HMonth = $("#HMonth").val(); |
| | | var wait = layer.load();//é®ç½© |
| | | $.ajax({ |
| | | url: GetWEBURL() + '/QC_CustomerAppealReport/QC_ErrManagerLedgerReport_Issue', |
| | | type: "GET", |
| | | async: false, |
| | | data: { "HYear": HYear, "HMonth": HMonth, "user": sessionStorage["HUserName"] }, |
| | | success: function (data1) { |
| | | var col = []; |
| | | if (data1.count == 1) { |
| | | var data = []; |
| | | //ç»ç©ºçæ°ç»èµå¼ |
| | | for (var key in data1.list) { |
| | | data.push({ "name": data1.list[key].ColmCols, "Type": data1.list[key].ColmType }); |
| | | } |
| | | col.push({ type: 'checkbox', fixed: 'left', totalRowText: 'æ±æ»' }); |
| | | //夿æ¯å¦æ¯çº¯è±æ |
| | | var patrn = new RegExp("[\u4E00-\u9FA5]+"); |
| | | for (var i = 0; i < data.length; i++) { |
| | | if (!patrn.test(data[i].name)) { |
| | | col.push({ field: data[i].name, title: data[i].name, hide: true }); //éèå |
| | | } |
| | | else { |
| | | switch (data[i].Type) { |
| | | case 'DateTime': |
| | | col.push({ field: data[i].name, 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: 120 }); |
| | | break; |
| | | case 'long': |
| | | case 'Int32': |
| | | case 'Int64': |
| | | case 'double': |
| | | case 'Decimal': |
| | | col.push({ field: data[i].name, title: data[i].name, align: 'center', sort: true, totalRow: true }); |
| | | break; |
| | | default: |
| | | col.push({ field: data[i].name, title: data[i].name, align: 'center', sort: true }); |
| | | } |
| | | } |
| | | } |
| | | |
| | | for (var i = 0; i < data1.length; i++) { |
| | | HIssueType.push(data1.data[i].é®é¢); |
| | | } |
| | | |
| | | option.cols = [col]; |
| | | option.data = data1.data; |
| | | |
| | | table.render(option); |
| | | layer.close(wait); |
| | | } else { |
| | | layer.close(wait); |
| | | layer.alert(data1.Message, { icon: 5 }); |
| | | } |
| | | }, error: function () { |
| | | layer.close(wait); |
| | | layer.alert("æ¥å£è¯·æ±å¤±è´¥!", { icon: 5 }); |
| | | } |
| | | }); |
| | | } |
| | | |
| | | //å¿«éè¿æ»¤ |
| | | function get_FastQuery() { |
| | | get_Display(sWhere); |
| | | //è°ç¨æ¥å£åæ¸
空sWhereç¼å |
| | | sWhere = ""; |
| | | set_Graphics(); |
| | | } |
| | | |
| | | //éç½®è¿æ»¤æ¡ä»¶ |
| | | function set_ClearQuery() { |
| | | var yyyy = new Date().getFullYear(); |
| | | $("#HYear").val(yyyy); |
| | | var mm = new Date().getMonth() + 1; |
| | | $("#HMonth").val(mm) |
| | | form.render('select'); |
| | | |
| | | sWhere = ""; |
| | | get_FastQuery(); |
| | | } |
| | | |
| | | //éèå设置 |
| | | function get_HideColumn() { |
| | | var colName = ""; |
| | | for (var i = 1; i < option.cols[0].length - 1; i++) { |
| | | colName += option.cols[0][i]["title"] + ","; |
| | | } |
| | | |
| | | colName = encodeURI(colName.substring(0, colName.length - 1));//对 URI è¿è¡ç¼ç |
| | | layer.open({ |
| | | type: 2 |
| | | , skin: "layui-layer-rim" //å ä¸è¾¹æ¡ |
| | | , title: "éèå设置" //æ é¢ |
| | | , closeBtn: 1 //çªä½å³ä¸è§å
³é ç æ ·å¼ |
| | | , shift: 2 //å¼¹åºå¨ç» |
| | | , area: ["50%", "90%"] //çªä½å¤§å° |
| | | , maxmin: true //设置æå¤§æå°æé®æ¯å¦æ¾ç¤º |
| | | , content: ['../../åºç¡èµæ/éèå设置/Gy_GridView_Hide.html?HModName=' + HModName + '&colName=' + colName, "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 = [];//æ°æ®åºæ¥è¯¢åºçåæ°æ® |
| | | var titleData = [];//ä¸éè¦æ¾ç¤ºçåæ®µ 坿©å± |
| | | |
| | | 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 (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 (dataCols[3] > 0) { |
| | | option.cols[0][i + 1]["width"] = dataCols[3]; |
| | | } |
| | | //æ¾ç¤ºå |
| | | 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 }); |
| | | } |
| | | }) |
| | | } |
| | | |
| | | //#endregion |
| | | }); |
| | | </script> |
| | | </body> |
| | | </html> |
| New file |
| | |
| | | <!DOCTYPE html> |
| | | <html> |
| | | <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/lib/extend/echarts.min.js'></script> |
| | | <style type="text/css"> |
| | | input.layui-input.layui-unselect { |
| | | padding-right: 0; |
| | | } |
| | | </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-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"> |
| | | <!--å¨ææ¸²ææä»½--> |
| | | </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;"> |
| | | <!--å
¶ä»æ¡ä»¶--> |
| | | </div> |
| | | </div> |
| | | </div> |
| | | </div> |
| | | <div> |
| | | <div style="width:99.5%;height:calc(60vh);margin-top:10px;"> |
| | | <div id="histogram" style="width:60%;height:calc(60vh);float:left"> |
| | | |
| | | </div> |
| | | <div id="PieChart" style="width:39%;height:calc(60vh);float:left;margin-left:5px;"> |
| | | |
| | | </div> |
| | | </div> |
| | | <div style="width:99%;height:calc(50vh);"> |
| | | <table class="" id="mainTable" lay-filter="mainTable"></table> |
| | | </div> |
| | | </div> |
| | | <script type="text/html" id="toolbarDemo"> |
| | | <div class="layui-btn-container"> |
| | | <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-exit"><i class="layui-icon layui-icon-return"></i>éåº</button> |
| | | <button type="button" class="layui-btn layui-btn-sm" lay-event="HideColumn"><i class="layui-icon layui-icon-form"></i>éèå设置</button> |
| | | </div> |
| | | </script> |
| | | </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 |
| | | , util = layui.util |
| | | //æ¥è¯¢æ¡ä»¶ |
| | | var sWhere = ""; |
| | | var option = []; |
| | | var HModName = "QC_ErrManagerLedgerReport_Source"; |
| | | var HSourceName = []; //çäº§èµæºåç§° |
| | | //#endregion |
| | | |
| | | //#region è¿å
¥é¡µé¢æ¢å è½½ |
| | | |
| | | //åå§åçé¢ |
| | | set_ClearBill(); |
| | | //#endregion |
| | | |
| | | //#region ãå¾å½¢ã |
| | | function set_Graphics() { |
| | | //#region ãæ±ç¶å¾ã |
| | | var app = {}; |
| | | var chartDom = document.getElementById('histogram'); |
| | | var myChart = echarts.init(chartDom); |
| | | var option_ZZT; |
| | | //#region [æ±ç¶å¾å¸å±æ ·å¼] |
| | | const posList = [ |
| | | 'left', |
| | | 'right', |
| | | 'top', |
| | | 'bottom', |
| | | 'inside', |
| | | 'insideTop', |
| | | 'insideLeft', |
| | | 'insideRight', |
| | | 'insideBottom', |
| | | 'insideTopLeft', |
| | | 'insideTopRight', |
| | | 'insideBottomLeft', |
| | | 'insideBottomRight' |
| | | ]; |
| | | app.configParameters = { |
| | | rotate: { |
| | | min: -90, |
| | | max: 90 |
| | | }, |
| | | align: { |
| | | options: { |
| | | left: 'left', |
| | | center: 'center', |
| | | right: 'right' |
| | | } |
| | | }, |
| | | verticalAlign: { |
| | | options: { |
| | | top: 'top', |
| | | middle: 'middle', |
| | | bottom: 'bottom' |
| | | } |
| | | }, |
| | | position: { |
| | | options: posList.reduce(function (map, pos) { |
| | | map[pos] = pos; |
| | | return map; |
| | | }, {}) |
| | | }, |
| | | distance: { |
| | | min: 0, |
| | | max: 100 |
| | | } |
| | | }; |
| | | app.config = { |
| | | rotate: 90, |
| | | align: 'left', |
| | | verticalAlign: 'middle', |
| | | position: 'insideBottom', |
| | | distance: 15, |
| | | onChange: function () { |
| | | const labelOption = { |
| | | rotate: app.config.rotate, |
| | | align: app.config.align, |
| | | verticalAlign: app.config.verticalAlign, |
| | | position: app.config.position, |
| | | distance: app.config.distance |
| | | }; |
| | | myChart.setOption({ |
| | | series: [ |
| | | { |
| | | label: labelOption |
| | | }, |
| | | { |
| | | label: labelOption |
| | | }, |
| | | { |
| | | label: labelOption |
| | | }, |
| | | { |
| | | label: labelOption |
| | | } |
| | | ] |
| | | }); |
| | | } |
| | | }; |
| | | const labelOption = { |
| | | show: true, |
| | | position: 'top' |
| | | }; |
| | | //#endregion |
| | | |
| | | //æ±ç¶å¾ç»å®æ°æ® |
| | | var HXTitle = [];//Xè½´æ é¢åç§° |
| | | var HSourceIssueCount = []; |
| | | var ZZTColor = []; |
| | | var ZZTColor2 = ['#00FFFF', '#FC2C83', '#FCED2C', '#93FC2C', '#FC2CF0', '#FC892C', '#2C81FC', '#2CC9FC', '#2CFCA7', '#DED3F2', '#F2D8D3', '#F2D3E0', '#D8E052', '#7EE052', '#52E0D8', '#5F52E0', '#E06F52', '#52E09B', '#E052DE', '#E05F52', '#52B2E0', '#E0C452', '#52CEE0', '#648690', '#E5D1D6', '#D8E5D1', '#E5D1E5', '#D8E5D1', '#7C6262', '#76627C', '#81A583', '#81A595']; |
| | | for (let i = 0; i < option.data.length; i++) { |
| | | HXTitle.push(option.data[i].线å); |
| | | HSourceIssueCount.push(option.data[i].线å«é®é¢æ¬¡æ°); |
| | | ZZTColor.push({ |
| | | x: 1, |
| | | y: 0, |
| | | x2: 0, |
| | | y2: 0, |
| | | type: "linear", |
| | | colorStops: [ |
| | | { offset: 0, color: "red" }, |
| | | { offset: 1, color: "blue" } |
| | | ] |
| | | }); |
| | | } |
| | | option_ZZT = { |
| | | title: { |
| | | text: '线å«é®é¢æ¬¡æ°', |
| | | left: 'left', |
| | | textStyle: { |
| | | color: 'black', |
| | | fontSize: 18, |
| | | fontWeight: 'normal' |
| | | }, |
| | | padding: [5,0,0,65] |
| | | }, |
| | | tooltip: { |
| | | trigger: 'axis', |
| | | axisPointer: { |
| | | type: 'shadow' |
| | | } |
| | | }, |
| | | legend: { |
| | | data: HSourceName |
| | | }, |
| | | toolbox: { |
| | | show: true, |
| | | orient: 'vertical', |
| | | left: 'right', |
| | | top: 'center', |
| | | feature: { |
| | | mark: { show: true }, |
| | | dataView: { show: true, readOnly: false }, |
| | | magicType: { show: true, type: ['line', 'bar', 'stack'] }, |
| | | restore: { show: true }, |
| | | saveAsImage: { show: true } |
| | | } |
| | | }, |
| | | xAxis: [ |
| | | { |
| | | type: 'category', |
| | | axisTick: { show: true }, |
| | | data: HXTitle |
| | | } |
| | | ], |
| | | yAxis: [ |
| | | { |
| | | type: 'value' |
| | | } |
| | | ], |
| | | series: [ |
| | | { |
| | | name: '线å«é®é¢æ¬¡æ°', |
| | | type: 'bar', |
| | | barGap: 0, |
| | | label: labelOption, |
| | | emphasis: { |
| | | focus: 'series' |
| | | }, |
| | | data: HSourceIssueCount, |
| | | itemStyle: { |
| | | color: function (params) { |
| | | // å¨æçææ¸åè²æè
æ ¹æ®æ¡ä»¶è¿åé¢è®¾çæ¸åè² |
| | | const gradientColors = ZZTColor2; |
| | | |
| | | return gradientColors[params.dataIndex]; |
| | | } |
| | | } |
| | | } |
| | | ] |
| | | }; |
| | | option_ZZT && myChart.setOption(option_ZZT); |
| | | //#endregion |
| | | |
| | | //#region ã饼å¾ã |
| | | var chartDom = document.getElementById('PieChart'); |
| | | var myChart = echarts.init(chartDom); |
| | | var option_BT; |
| | | var HYear = $("#HYear").val() == "" ? "X" : $("#HYear").val(); |
| | | var HMonth = $("#HMonth").val() == "" ? "X" : $("#HMonth").val(); |
| | | |
| | | var option_BT_XData = []; |
| | | for (let i = 0; i < option.data.length; i++) { |
| | | option_BT_XData.push({ value: option.data[i].å æ¯.replace('%',''), name: option.data[i].线å }); |
| | | } |
| | | |
| | | option_BT = { |
| | | title: { |
| | | text: HYear + 'å¹´' + HMonth + 'æä»½çº¿å«é®é¢æ¯ä¾', |
| | | left: 'center' |
| | | }, |
| | | tooltip: { |
| | | trigger: 'item' |
| | | }, |
| | | legend: { |
| | | top: 'bottom' |
| | | }, |
| | | series: [ |
| | | { |
| | | name: '线å«é®é¢æ¬¡æ°æ¯ä¾', |
| | | type: 'pie', |
| | | radius: '50%', |
| | | data: option_BT_XData, |
| | | emphasis: { |
| | | itemStyle: { |
| | | shadowBlur: 10, |
| | | shadowOffsetX: 0, |
| | | shadowColor: 'rgba(0, 0, 0, 0.5)' |
| | | } |
| | | }, |
| | | itemStyle: { |
| | | color: function (params) { |
| | | // å¨æçææ¸åè²æè
æ ¹æ®æ¡ä»¶è¿åé¢è®¾çæ¸åè² |
| | | const gradientColors = ZZTColor2; |
| | | |
| | | return gradientColors[params.dataIndex]; |
| | | } |
| | | } |
| | | } |
| | | ] |
| | | }; |
| | | |
| | | option_BT && myChart.setOption(option_BT); |
| | | //#endregion |
| | | } |
| | | |
| | | //#region ç¹å»äºä»¶å
æ¬on formäºä»¶ç |
| | | //头工å
·æ äºä»¶ |
| | | table.on('toolbar(mainTable)', function (obj) { |
| | | switch (obj.event) { |
| | | //éåº |
| | | case 'btn-exit': Pub_Close(2); |
| | | break; |
| | | //éèå设置 |
| | | case 'HideColumn': |
| | | get_HideColumn(); |
| | | break; |
| | | }; |
| | | }); |
| | | //éç½®æé® |
| | | form.on('submit(btnReSearch)', function (data) { |
| | | set_ClearQuery(); |
| | | }); |
| | | |
| | | //æ¥è¯¢æé® |
| | | form.on('submit(btnSearch)', function (data) { |
| | | get_FastQuery(); |
| | | }); |
| | | //#endregion |
| | | |
| | | //#region æ¤é¡µé¢ææçæ¹æ³ |
| | | |
| | | //åå§åçé¢ |
| | | function set_ClearBill() { |
| | | Year(); |
| | | Month(); |
| | | //åå§åè¡¨æ ¼ |
| | | set_InitGrid(); |
| | | //å è½½æ°æ®å°ç½æ ¼ |
| | | get_FastQuery(); |
| | | //DisPlay_HideColumn(); |
| | | set_Graphics(); |
| | | } |
| | | |
| | | //åå§åè¡¨æ ¼ |
| | | function set_InitGrid() { |
| | | option = { |
| | | elem: '#mainTable' |
| | | , toolbar: '#toolbarDemo' |
| | | , height: 'full-320' |
| | | , page: true |
| | | , totalRow: true |
| | | , cellMinWidth: 90 |
| | | , limit: 200 |
| | | , limits: [50, 500, 5000, 20000] |
| | | } |
| | | } |
| | | |
| | | //å¹´ |
| | | function Year() { |
| | | var yyyy = new Date().getFullYear(); |
| | | var YearOption = ""; |
| | | YearOption += '<option style="color:blue;" value="">' + "è¯·éæ©" + '</option>'; |
| | | 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'); |
| | | } |
| | | |
| | | //æ |
| | | function Month() { |
| | | var mm = new Date().getMonth() + 1; |
| | | var MonthOption = ""; |
| | | MonthOption += '<option style="color:blue;" value="">' + "è¯·éæ©" + '</option>'; |
| | | for (var i = 1; i <= 12; i++) { |
| | | MonthOption += '<option style="color:blue;" value="' + (i) + '">' + (i) + '</option>'; |
| | | } |
| | | $("#HMonth").append(MonthOption); |
| | | $("#HMonth").val(mm) |
| | | form.render('select'); |
| | | } |
| | | |
| | | //å è½½ç½æ ¼ |
| | | function get_Display(DateYear) { |
| | | var HYear = $("#HYear").val(); |
| | | var HMonth = $("#HMonth").val(); |
| | | var wait = layer.load();//é®ç½© |
| | | $.ajax({ |
| | | url: GetWEBURL() + '/QC_CustomerAppealReport/QC_ErrManagerLedgerReport_Source', |
| | | type: "GET", |
| | | async: false, |
| | | data: { "HYear": HYear, "HMonth": HMonth, "user": sessionStorage["HUserName"] }, |
| | | success: function (data1) { |
| | | var col = []; |
| | | if (data1.count == 1) { |
| | | var data = []; |
| | | //ç»ç©ºçæ°ç»èµå¼ |
| | | for (var key in data1.list) { |
| | | data.push({ "name": data1.list[key].ColmCols, "Type": data1.list[key].ColmType }); |
| | | } |
| | | col.push({ type: 'checkbox', fixed: 'left', totalRowText: 'æ±æ»' }); |
| | | //夿æ¯å¦æ¯çº¯è±æ |
| | | var patrn = new RegExp("[\u4E00-\u9FA5]+"); |
| | | for (var i = 0; i < data.length; i++) { |
| | | if (!patrn.test(data[i].name)) { |
| | | col.push({ field: data[i].name, title: data[i].name, hide: true }); //éèå |
| | | } |
| | | else { |
| | | switch (data[i].Type) { |
| | | case 'DateTime': |
| | | col.push({ field: data[i].name, 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: 120 }); |
| | | break; |
| | | case 'long': |
| | | case 'Int32': |
| | | case 'Int64': |
| | | case 'double': |
| | | case 'Decimal': |
| | | col.push({ field: data[i].name, title: data[i].name, align: 'center', sort: true, totalRow: true }); |
| | | break; |
| | | default: |
| | | col.push({ field: data[i].name, title: data[i].name, align: 'center', sort: true }); |
| | | } |
| | | } |
| | | } |
| | | |
| | | for (var i = 0; i < data1.length; i++) { |
| | | HSourceName.push(data1.data[i].线å); |
| | | } |
| | | |
| | | option.cols = [col]; |
| | | option.data = data1.data; |
| | | |
| | | table.render(option); |
| | | layer.close(wait); |
| | | } else { |
| | | layer.close(wait); |
| | | layer.alert(data1.Message, { icon: 5 }); |
| | | } |
| | | }, error: function () { |
| | | layer.close(wait); |
| | | layer.alert("æ¥å£è¯·æ±å¤±è´¥!", { icon: 5 }); |
| | | } |
| | | }); |
| | | } |
| | | |
| | | //å¿«éè¿æ»¤ |
| | | function get_FastQuery() { |
| | | get_Display(sWhere); |
| | | //è°ç¨æ¥å£åæ¸
空sWhereç¼å |
| | | sWhere = ""; |
| | | set_Graphics(); |
| | | } |
| | | |
| | | //éç½®è¿æ»¤æ¡ä»¶ |
| | | function set_ClearQuery() { |
| | | var yyyy = new Date().getFullYear(); |
| | | $("#HYear").val(yyyy); |
| | | var mm = new Date().getMonth() + 1; |
| | | $("#HMonth").val(mm) |
| | | form.render('select'); |
| | | |
| | | sWhere = ""; |
| | | get_FastQuery(); |
| | | } |
| | | |
| | | //éèå设置 |
| | | function get_HideColumn() { |
| | | var colName = ""; |
| | | for (var i = 1; i < option.cols[0].length - 1; i++) { |
| | | colName += option.cols[0][i]["title"] + ","; |
| | | } |
| | | |
| | | colName = encodeURI(colName.substring(0, colName.length - 1));//对 URI è¿è¡ç¼ç |
| | | layer.open({ |
| | | type: 2 |
| | | , skin: "layui-layer-rim" //å ä¸è¾¹æ¡ |
| | | , title: "éèå设置" //æ é¢ |
| | | , closeBtn: 1 //çªä½å³ä¸è§å
³é ç æ ·å¼ |
| | | , shift: 2 //å¼¹åºå¨ç» |
| | | , area: ["50%", "90%"] //çªä½å¤§å° |
| | | , maxmin: true //设置æå¤§æå°æé®æ¯å¦æ¾ç¤º |
| | | , content: ['../../åºç¡èµæ/éèå设置/Gy_GridView_Hide.html?HModName=' + HModName + '&colName=' + colName, "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 = [];//æ°æ®åºæ¥è¯¢åºçåæ°æ® |
| | | var titleData = [];//ä¸éè¦æ¾ç¤ºçåæ®µ 坿©å± |
| | | |
| | | 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 (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 (dataCols[3] > 0) { |
| | | option.cols[0][i + 1]["width"] = dataCols[3]; |
| | | } |
| | | //æ¾ç¤ºå |
| | | 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 }); |
| | | } |
| | | }) |
| | | } |
| | | |
| | | //#endregion |
| | | }); |
| | | </script> |
| | | </body> |
| | | </html> |
| New file |
| | |
| | | <!DOCTYPE html> |
| | | <html> |
| | | <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/lib/extend/echarts.min.js'></script> |
| | | <style type="text/css"> |
| | | input.layui-input.layui-unselect { |
| | | padding-right: 0; |
| | | } |
| | | </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-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"> |
| | | <!--å¨ææ¸²ææä»½--> |
| | | </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;"> |
| | | <!--å
¶ä»æ¡ä»¶--> |
| | | </div> |
| | | </div> |
| | | </div> |
| | | </div> |
| | | <div> |
| | | <div style="width:99.5%;height:calc(60vh);margin-top:10px;"> |
| | | <div id="histogram" style="width:60%;height:calc(60vh);float:left"> |
| | | |
| | | </div> |
| | | <div id="PieChart" style="width:39%;height:calc(60vh);float:left;margin-left:5px;"> |
| | | |
| | | </div> |
| | | </div> |
| | | <div style="width:99%;height:calc(50vh);"> |
| | | <table class="" id="mainTable" lay-filter="mainTable"></table> |
| | | </div> |
| | | </div> |
| | | <script type="text/html" id="toolbarDemo"> |
| | | <div class="layui-btn-container"> |
| | | <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-exit"><i class="layui-icon layui-icon-return"></i>éåº</button> |
| | | <button type="button" class="layui-btn layui-btn-sm" lay-event="HideColumn"><i class="layui-icon layui-icon-form"></i>éèå设置</button> |
| | | </div> |
| | | </script> |
| | | </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 |
| | | , util = layui.util |
| | | //æ¥è¯¢æ¡ä»¶ |
| | | var sWhere = ""; |
| | | var option = []; |
| | | var HModName = "QC_ErrManagerLedgerReport_SourceOfTheProblem"; |
| | | var HSourceOfTheProblem = []; //å¼å¸¸é®é¢æ¥æº |
| | | //#endregion |
| | | |
| | | //#region è¿å
¥é¡µé¢æ¢å è½½ |
| | | |
| | | //åå§åçé¢ |
| | | set_ClearBill(); |
| | | //#endregion |
| | | |
| | | //#region ãå¾å½¢ã |
| | | function set_Graphics() { |
| | | //#region ãæ±ç¶å¾ã |
| | | var app = {}; |
| | | var chartDom = document.getElementById('histogram'); |
| | | var myChart = echarts.init(chartDom); |
| | | var option_ZZT; |
| | | //#region [æ±ç¶å¾å¸å±æ ·å¼] |
| | | const posList = [ |
| | | 'left', |
| | | 'right', |
| | | 'top', |
| | | 'bottom', |
| | | 'inside', |
| | | 'insideTop', |
| | | 'insideLeft', |
| | | 'insideRight', |
| | | 'insideBottom', |
| | | 'insideTopLeft', |
| | | 'insideTopRight', |
| | | 'insideBottomLeft', |
| | | 'insideBottomRight' |
| | | ]; |
| | | app.configParameters = { |
| | | rotate: { |
| | | min: -90, |
| | | max: 90 |
| | | }, |
| | | align: { |
| | | options: { |
| | | left: 'left', |
| | | center: 'center', |
| | | right: 'right' |
| | | } |
| | | }, |
| | | verticalAlign: { |
| | | options: { |
| | | top: 'top', |
| | | middle: 'middle', |
| | | bottom: 'bottom' |
| | | } |
| | | }, |
| | | position: { |
| | | options: posList.reduce(function (map, pos) { |
| | | map[pos] = pos; |
| | | return map; |
| | | }, {}) |
| | | }, |
| | | distance: { |
| | | min: 0, |
| | | max: 100 |
| | | } |
| | | }; |
| | | app.config = { |
| | | rotate: 90, |
| | | align: 'left', |
| | | verticalAlign: 'middle', |
| | | position: 'insideBottom', |
| | | distance: 15, |
| | | onChange: function () { |
| | | const labelOption = { |
| | | rotate: app.config.rotate, |
| | | align: app.config.align, |
| | | verticalAlign: app.config.verticalAlign, |
| | | position: app.config.position, |
| | | distance: app.config.distance |
| | | }; |
| | | myChart.setOption({ |
| | | series: [ |
| | | { |
| | | label: labelOption |
| | | }, |
| | | { |
| | | label: labelOption |
| | | }, |
| | | { |
| | | label: labelOption |
| | | }, |
| | | { |
| | | label: labelOption |
| | | } |
| | | ] |
| | | }); |
| | | } |
| | | }; |
| | | const labelOption = { |
| | | show: true, |
| | | position: 'top' |
| | | }; |
| | | //#endregion |
| | | |
| | | //æ±ç¶å¾ç»å®æ°æ® |
| | | var HXTitle = [];//Xè½´æ é¢åç§° |
| | | var HSourceIssueCount = []; |
| | | var ZZTColor = []; |
| | | var ZZTColor2 = ['#00FFFF', '#FC2C83', '#FCED2C', '#93FC2C', '#FC2CF0', '#FC892C', '#2C81FC', '#2CC9FC', '#2CFCA7', '#DED3F2', '#F2D8D3', '#F2D3E0', '#D8E052', '#7EE052', '#52E0D8', '#5F52E0', '#E06F52', '#52E09B', '#E052DE', '#E05F52', '#52B2E0', '#E0C452', '#52CEE0', '#648690', '#E5D1D6', '#D8E5D1', '#E5D1E5', '#D8E5D1', '#7C6262', '#76627C', '#81A583', '#81A595']; |
| | | for (let i = 0; i < option.data.length; i++) { |
| | | HXTitle.push(option.data[i].é®é¢æ¥æº); |
| | | HSourceIssueCount.push(option.data[i].å¼å¸¸æ¬¡æ°); |
| | | ZZTColor.push({ |
| | | x: 1, |
| | | y: 0, |
| | | x2: 0, |
| | | y2: 0, |
| | | type: "linear", |
| | | colorStops: [ |
| | | { offset: 0, color: "red" }, |
| | | { offset: 1, color: "blue" } |
| | | ] |
| | | }); |
| | | } |
| | | option_ZZT = { |
| | | title: { |
| | | text: 'é®é¢æ°', |
| | | left: 'left', |
| | | textStyle: { |
| | | color: 'black', |
| | | fontSize: 18, |
| | | fontWeight: 'normal' |
| | | }, |
| | | padding: [5,0,0,65] |
| | | }, |
| | | tooltip: { |
| | | trigger: 'axis', |
| | | axisPointer: { |
| | | type: 'shadow' |
| | | } |
| | | }, |
| | | legend: { |
| | | data: HSourceOfTheProblem |
| | | }, |
| | | toolbox: { |
| | | show: true, |
| | | orient: 'vertical', |
| | | left: 'right', |
| | | top: 'center', |
| | | feature: { |
| | | mark: { show: true }, |
| | | dataView: { show: true, readOnly: false }, |
| | | magicType: { show: true, type: ['line', 'bar', 'stack'] }, |
| | | restore: { show: true }, |
| | | saveAsImage: { show: true } |
| | | } |
| | | }, |
| | | xAxis: [ |
| | | { |
| | | type: 'category', |
| | | axisTick: { show: true }, |
| | | data: HXTitle |
| | | } |
| | | ], |
| | | yAxis: [ |
| | | { |
| | | type: 'value' |
| | | } |
| | | ], |
| | | series: [ |
| | | { |
| | | name: 'é®é¢æ°', |
| | | type: 'bar', |
| | | barGap: 0, |
| | | label: labelOption, |
| | | emphasis: { |
| | | focus: 'series' |
| | | }, |
| | | data: HSourceIssueCount, |
| | | itemStyle: { |
| | | color: function (params) { |
| | | // å¨æçææ¸åè²æè
æ ¹æ®æ¡ä»¶è¿åé¢è®¾çæ¸åè² |
| | | const gradientColors = ZZTColor2; |
| | | |
| | | return gradientColors[params.dataIndex]; |
| | | } |
| | | } |
| | | } |
| | | ] |
| | | }; |
| | | option_ZZT && myChart.setOption(option_ZZT); |
| | | //#endregion |
| | | |
| | | //#region ã饼å¾ã |
| | | var chartDom = document.getElementById('PieChart'); |
| | | var myChart = echarts.init(chartDom); |
| | | var option_BT; |
| | | var HYear = $("#HYear").val() == "" ? "X" : $("#HYear").val(); |
| | | var HMonth = $("#HMonth").val() == "" ? "X" : $("#HMonth").val(); |
| | | |
| | | var option_BT_XData = []; |
| | | for (let i = 0; i < option.data.length; i++) { |
| | | option_BT_XData.push({ value: option.data[i].å æ¯.replace('%', ''), name: option.data[i].é®é¢æ¥æº }); |
| | | } |
| | | |
| | | option_BT = { |
| | | title: { |
| | | text: HYear + 'å¹´' + HMonth + 'æä»½å¼å¸¸é®é¢æ¥æºæ¯ä¾', |
| | | left: 'center' |
| | | }, |
| | | tooltip: { |
| | | trigger: 'item' |
| | | }, |
| | | legend: { |
| | | top: 'bottom' |
| | | }, |
| | | series: [ |
| | | { |
| | | name: 'å¼å¸¸é®é¢æ¥æºæ¯ä¾', |
| | | type: 'pie', |
| | | radius: '50%', |
| | | data: option_BT_XData, |
| | | emphasis: { |
| | | itemStyle: { |
| | | shadowBlur: 10, |
| | | shadowOffsetX: 0, |
| | | shadowColor: 'rgba(0, 0, 0, 0.5)' |
| | | } |
| | | }, |
| | | itemStyle: { |
| | | color: function (params) { |
| | | // å¨æçææ¸åè²æè
æ ¹æ®æ¡ä»¶è¿åé¢è®¾çæ¸åè² |
| | | const gradientColors = ZZTColor2; |
| | | |
| | | return gradientColors[params.dataIndex]; |
| | | } |
| | | } |
| | | } |
| | | ] |
| | | }; |
| | | |
| | | option_BT && myChart.setOption(option_BT); |
| | | //#endregion |
| | | } |
| | | |
| | | //#region ç¹å»äºä»¶å
æ¬on formäºä»¶ç |
| | | //头工å
·æ äºä»¶ |
| | | table.on('toolbar(mainTable)', function (obj) { |
| | | switch (obj.event) { |
| | | //éåº |
| | | case 'btn-exit': Pub_Close(2); |
| | | break; |
| | | //éèå设置 |
| | | case 'HideColumn': |
| | | get_HideColumn(); |
| | | break; |
| | | }; |
| | | }); |
| | | //éç½®æé® |
| | | form.on('submit(btnReSearch)', function (data) { |
| | | set_ClearQuery(); |
| | | }); |
| | | |
| | | //æ¥è¯¢æé® |
| | | form.on('submit(btnSearch)', function (data) { |
| | | get_FastQuery(); |
| | | }); |
| | | //#endregion |
| | | |
| | | //#region æ¤é¡µé¢ææçæ¹æ³ |
| | | |
| | | //åå§åçé¢ |
| | | function set_ClearBill() { |
| | | Year(); |
| | | Month(); |
| | | //åå§åè¡¨æ ¼ |
| | | set_InitGrid(); |
| | | //å è½½æ°æ®å°ç½æ ¼ |
| | | get_FastQuery(); |
| | | //DisPlay_HideColumn(); |
| | | set_Graphics(); |
| | | } |
| | | |
| | | //åå§åè¡¨æ ¼ |
| | | function set_InitGrid() { |
| | | option = { |
| | | elem: '#mainTable' |
| | | , toolbar: '#toolbarDemo' |
| | | , height: 'full-320' |
| | | , page: true |
| | | , totalRow: true |
| | | , cellMinWidth: 90 |
| | | , limit: 200 |
| | | , limits: [50, 500, 5000, 20000] |
| | | } |
| | | } |
| | | |
| | | //å¹´ |
| | | function Year() { |
| | | var yyyy = new Date().getFullYear(); |
| | | var YearOption = ""; |
| | | YearOption += '<option style="color:blue;" value="">' + "è¯·éæ©" + '</option>'; |
| | | 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'); |
| | | } |
| | | |
| | | //æ |
| | | function Month() { |
| | | var mm = new Date().getMonth() + 1; |
| | | var MonthOption = ""; |
| | | MonthOption += '<option style="color:blue;" value="">' + "è¯·éæ©" + '</option>'; |
| | | for (var i = 1; i <= 12; i++) { |
| | | MonthOption += '<option style="color:blue;" value="' + (i) + '">' + (i) + '</option>'; |
| | | } |
| | | $("#HMonth").append(MonthOption); |
| | | $("#HMonth").val(mm) |
| | | form.render('select'); |
| | | } |
| | | |
| | | //å è½½ç½æ ¼ |
| | | function get_Display(DateYear) { |
| | | var HYear = $("#HYear").val(); |
| | | var HMonth = $("#HMonth").val(); |
| | | var wait = layer.load();//é®ç½© |
| | | $.ajax({ |
| | | url: GetWEBURL() + '/QC_CustomerAppealReport/QC_ErrManagerLedgerReport_SourceOfTheProblem', |
| | | type: "GET", |
| | | async: false, |
| | | data: { "HYear": HYear, "HMonth": HMonth, "user": sessionStorage["HUserName"] }, |
| | | success: function (data1) { |
| | | var col = []; |
| | | if (data1.count == 1) { |
| | | var data = []; |
| | | //ç»ç©ºçæ°ç»èµå¼ |
| | | for (var key in data1.list) { |
| | | data.push({ "name": data1.list[key].ColmCols, "Type": data1.list[key].ColmType }); |
| | | } |
| | | col.push({ type: 'checkbox', fixed: 'left', totalRowText: 'æ±æ»' }); |
| | | //夿æ¯å¦æ¯çº¯è±æ |
| | | var patrn = new RegExp("[\u4E00-\u9FA5]+"); |
| | | for (var i = 0; i < data.length; i++) { |
| | | if (!patrn.test(data[i].name)) { |
| | | col.push({ field: data[i].name, title: data[i].name, hide: true }); //éèå |
| | | } |
| | | else { |
| | | switch (data[i].Type) { |
| | | case 'DateTime': |
| | | col.push({ field: data[i].name, 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: 120 }); |
| | | break; |
| | | case 'long': |
| | | case 'Int32': |
| | | case 'Int64': |
| | | case 'double': |
| | | case 'Decimal': |
| | | col.push({ field: data[i].name, title: data[i].name, align: 'center', sort: true, totalRow: true }); |
| | | break; |
| | | default: |
| | | col.push({ field: data[i].name, title: data[i].name, align: 'center', sort: true }); |
| | | } |
| | | } |
| | | } |
| | | |
| | | for (var i = 0; i < data1.length; i++) { |
| | | HSourceOfTheProblem.push(data1.data[i].é®é¢æ¥æº); |
| | | } |
| | | |
| | | option.cols = [col]; |
| | | option.data = data1.data; |
| | | |
| | | table.render(option); |
| | | layer.close(wait); |
| | | } else { |
| | | layer.close(wait); |
| | | layer.alert(data1.Message, { icon: 5 }); |
| | | } |
| | | }, error: function () { |
| | | layer.close(wait); |
| | | layer.alert("æ¥å£è¯·æ±å¤±è´¥!", { icon: 5 }); |
| | | } |
| | | }); |
| | | } |
| | | |
| | | //å¿«éè¿æ»¤ |
| | | function get_FastQuery() { |
| | | get_Display(sWhere); |
| | | //è°ç¨æ¥å£åæ¸
空sWhereç¼å |
| | | sWhere = ""; |
| | | set_Graphics(); |
| | | } |
| | | |
| | | //éç½®è¿æ»¤æ¡ä»¶ |
| | | function set_ClearQuery() { |
| | | var yyyy = new Date().getFullYear(); |
| | | $("#HYear").val(yyyy); |
| | | var mm = new Date().getMonth() + 1; |
| | | $("#HMonth").val(mm) |
| | | form.render('select'); |
| | | |
| | | sWhere = ""; |
| | | get_FastQuery(); |
| | | } |
| | | |
| | | //éèå设置 |
| | | function get_HideColumn() { |
| | | var colName = ""; |
| | | for (var i = 1; i < option.cols[0].length - 1; i++) { |
| | | colName += option.cols[0][i]["title"] + ","; |
| | | } |
| | | |
| | | colName = encodeURI(colName.substring(0, colName.length - 1));//对 URI è¿è¡ç¼ç |
| | | layer.open({ |
| | | type: 2 |
| | | , skin: "layui-layer-rim" //å ä¸è¾¹æ¡ |
| | | , title: "éèå设置" //æ é¢ |
| | | , closeBtn: 1 //çªä½å³ä¸è§å
³é ç æ ·å¼ |
| | | , shift: 2 //å¼¹åºå¨ç» |
| | | , area: ["50%", "90%"] //çªä½å¤§å° |
| | | , maxmin: true //设置æå¤§æå°æé®æ¯å¦æ¾ç¤º |
| | | , content: ['../../åºç¡èµæ/éèå设置/Gy_GridView_Hide.html?HModName=' + HModName + '&colName=' + colName, "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 = [];//æ°æ®åºæ¥è¯¢åºçåæ°æ® |
| | | var titleData = [];//ä¸éè¦æ¾ç¤ºçåæ®µ 坿©å± |
| | | |
| | | 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 (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 (dataCols[3] > 0) { |
| | | option.cols[0][i + 1]["width"] = dataCols[3]; |
| | | } |
| | | //æ¾ç¤ºå |
| | | 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 }); |
| | | } |
| | | }) |
| | | } |
| | | |
| | | //#endregion |
| | | }); |
| | | </script> |
| | | </body> |
| | | </html> |