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> |
| | | <script src="https://unpkg.com/mathjs/lib/browser/math.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">å¼å§æ¥æ</label> |
| | | <div class="layui-input-block"> |
| | | <input type="date" class="layui-input" id="HBeginDate" style="width:160px;"> |
| | | </div> |
| | | </div> |
| | | <div class="layui-inline"> |
| | | <label class="layui-form-label">ç»ææ¥æ</label> |
| | | <div class="layui-input-block"> |
| | | <input type="date" class="layui-input" id="HEndDate" style="width:160px;"> |
| | | </div> |
| | | </div> |
| | | <div class="layui-inline"> |
| | | <label class="layui-form-label">é¨é¨</label> |
| | | <div class="layui-input-block"> |
| | | <select name="HDeptName" id="HDeptName" lay-verify="required" lay-search class="layui-input"> |
| | | <!--å¨ææ¸²æè½¦é´--> |
| | | </select> |
| | | </div> |
| | | </div> |
| | | <div class="layui-inline"> |
| | | <label class="layui-form-label">å·¥åº</label> |
| | | <div class="layui-input-block" style="margin-left: 120px;"> |
| | | <input type="text" class="layui-input" name="HProcName" id="HProcName"> |
| | | </div> |
| | | </div> |
| | | <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnSearch" id="btnSearch"> |
| | | <i class="layui-icon layui-icon-search layuiadmin-button-btn"></i> |
| | | </button> |
| | | <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnReSearch" id="btnReSearch" style="padding:0 5px">éç½®</button> |
| | | |
| | | <div class="layui-colla-content" style="padding: 0px; margin-left: 6%;"> |
| | | <div class="layui-row" style="margin-top:10px;"> |
| | | <!--å
¶ä»æ¡ä»¶--> |
| | | <div class="layui-inline"> |
| | | <label class="layui-form-label" style="width: 85px;">ç©æä»£ç </label> |
| | | <div class="layui-input-block" style="margin-left: 120px;"> |
| | | <input type="text" class="layui-input" name="HMaterNumber" id="HMaterNumber"> |
| | | </div> |
| | | </div> |
| | | <div class="layui-inline"> |
| | | <label class="layui-form-label" style="width: 85px;">ç©æåç§°</label> |
| | | <div class="layui-input-block" style="margin-left: 120px;"> |
| | | <input type="text" class="layui-input" name="HMaterName" id="HMaterName"> |
| | | </div> |
| | | </div> |
| | | <div class="layui-inline"> |
| | | <label class="layui-form-label" style="width: 85px;">è§æ ¼åå·</label> |
| | | <div class="layui-input-block" style="margin-left: 120px;"> |
| | | <input type="text" class="layui-input" name="HMaterModel" id="HMaterModel"> |
| | | </div> |
| | | </div> |
| | | <div class="layui-inline"> |
| | | <label class="layui-form-label" style="width: 85px;">ä¸é</label> |
| | | <div class="layui-input-block" style="margin-left: 120px;"> |
| | | <input type="text" class="layui-input" name="HUpLoad" id="HUpLoad"> |
| | | </div> |
| | | </div> |
| | | </div> |
| | | <div class="layui-row" style="margin-top:5px;"> |
| | | <div class="layui-inline"> |
| | | <label class="layui-form-label" style="width: 85px;">æ£éªé¡¹ç®</label> |
| | | <div class="layui-input-block" style="margin-left: 120px;"> |
| | | <input type="text" class="layui-input" name="HCheckItem" id="HCheckItem"> |
| | | </div> |
| | | </div> |
| | | <div class="layui-inline"> |
| | | <label class="layui-form-label" style="width: 85px;">æµéåä½</label> |
| | | <div class="layui-input-block" style="margin-left: 120px;"> |
| | | <input type="text" class="layui-input" id="HUnitName"> |
| | | </div> |
| | | </div> |
| | | <div class="layui-inline"> |
| | | <label class="layui-form-label" style="width: 85px;">æ åå¼</label> |
| | | <div class="layui-input-block" style="margin-left: 120px;"> |
| | | <input type="text" class="layui-input" id="HStandard"> |
| | | </div> |
| | | </div> |
| | | <div class="layui-inline"> |
| | | <label class="layui-form-label" style="width: 85px;">ä¸é</label> |
| | | <div class="layui-input-block" style="margin-left: 120px;"> |
| | | <input type="text" class="layui-input" id="HDownLoad"> |
| | | </div> |
| | | </div> |
| | | </div> |
| | | <div class="layui-row" style="margin: 10px 0 10px;display:none;"> |
| | | <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> |
| | | </div> |
| | | </div> |
| | | <div> |
| | | <div style="width:99.5%;height:calc(26vh);"> |
| | | <table class="" id="mainTable" lay-filter="mainTable"></table> |
| | | </div> |
| | | <div id="histogram_Avg" style="width:99.5%;height:calc(50vh);margin-top:5%;"> |
| | | |
| | | </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_FirstPieceCheckReport_ZTFB"; |
| | | //#endregion |
| | | |
| | | //#region è¿å
¥é¡µé¢æ¢å è½½ |
| | | |
| | | //åå§åçé¢ |
| | | set_ClearBill(); |
| | | |
| | | //#endregion |
| | | |
| | | //#regionãæ±ç¶å¾ã |
| | | var chartDom = document.getElementById('histogram_Avg'); |
| | | var myChart = echarts.init(chartDom); |
| | | var option_ZXT_Avg; |
| | | |
| | | var app = {}; |
| | | |
| | | //æ£æåå¸è®¡ç® |
| | | function func(x, u, a) { |
| | | return ( |
| | | (1 / Math.sqrt(2 * Math.PI)) * |
| | | a * |
| | | Math.exp((-1 * ((x - u) * (x - u))) / (2 * a * a)) |
| | | ); |
| | | } |
| | | |
| | | var data = []; |
| | | //for (let j = 1; j <= 25; j++) { |
| | | // var avg = 0; |
| | | // for (let i = 0; i < option.data.length; i++) { |
| | | // avg += Number(option.data[i][j]); |
| | | // } |
| | | // //avg = avg / option.data.length; |
| | | // data.push(avg.toFixed(2)); |
| | | //} |
| | | |
| | | for (let i = 0; i < option.data.length;i++) { |
| | | for (let j = 1; j <= 25; j++) { |
| | | data.push(option.data[i][j]) |
| | | } |
| | | } |
| | | |
| | | //console.log("Min:" + Math.min(...data)); |
| | | //console.log("Max:" + Math.max(...data)); |
| | | var xMin = Math.trunc(Math.min(...data)); //LowLimit |
| | | var xMax = Math.max(...data) + 1; //UpLimit |
| | | var mean = math.mean(data); //å¹³åå¼ è®¡ç®æ¹æ³æ¥èªmath.js |
| | | var stdev = math.std(data); //æ¹å·® |
| | | var threeSigLow = mean - 3 * stdev; |
| | | var threeSigUp = mean + 3 * stdev; |
| | | |
| | | //æ°æ®ååºæåº |
| | | const dataSec = data.sort((a, b) => { |
| | | return a - b; |
| | | }); |
| | | //计ç®é¢æ° |
| | | var resNum = {}; |
| | | for (var m = 0; m < dataSec.length; m++) { |
| | | var key = parseFloat(dataSec[m]); |
| | | if (parseFloat(key) === 0) continue; |
| | | if (resNum[key]) resNum[key] += 1; |
| | | else resNum[key] = 1; |
| | | } |
| | | var xArr = []; //æ¨ªåæ å¼ |
| | | var fArr = []; //颿° |
| | | var yArr = []; //æ£æå¼ |
| | | |
| | | for (var k in resNum) { |
| | | xArr.push(parseFloat(k)); |
| | | } |
| | | xArr = xArr.sort((a, b) => { |
| | | return a - b; |
| | | }); |
| | | //console.log(xArr); |
| | | |
| | | //计ç®xå¼å¯¹åºç颿° |
| | | for (var i = 0; i < xArr.length; i++) { |
| | | var xNy = [xArr[i], resNum[xArr[i]]]; |
| | | fArr.push(xNy); |
| | | } |
| | | |
| | | //计ç®xå¼å¯¹åºçæ£æåå¸å¼ |
| | | var distance = xMax - xMin; //ä¸ºäºæ´å¥½çï¼è®¾ç½®æ£ææ²çº¿èµ·æ¢ä½ç½® |
| | | for (var j = xMin ; j < xMax ; j += 0.01) { |
| | | var xy = [j, func(j, mean, stdev)]; |
| | | yArr.push(xy); |
| | | } |
| | | |
| | | option_ZXT_Avg = { |
| | | //backgroundColor: "#12141e", |
| | | tooltip: { |
| | | trigger: "axis", |
| | | axisPointer: { |
| | | type: "shadow" |
| | | } |
| | | }, |
| | | legend: { |
| | | orient: "vertical", |
| | | x: "right", |
| | | y: "top", |
| | | top: "5px", |
| | | data: ["颿°", "æ£æåå¸"], |
| | | //textStyle: { |
| | | // color: "rgba(255,255,255,1)", |
| | | // fontSize: "12" |
| | | //} |
| | | }, |
| | | grid: { |
| | | left: "2%", |
| | | top: "18px", |
| | | right: "2%", |
| | | bottom: "2%", |
| | | containLabel: true |
| | | }, |
| | | xAxis: [ |
| | | { |
| | | type: "value", |
| | | min: xMin, |
| | | max: xMax, |
| | | //axisLabel: { |
| | | // textStyle: { |
| | | // color: "rgba(255,255,255,1)", |
| | | // fontSize: 10 |
| | | // } |
| | | //}, |
| | | //axisLine: { |
| | | // show: true, |
| | | // lineStyle: { |
| | | // color: "rgba(255,255,255,1)" |
| | | // } |
| | | //}, |
| | | splitLine: { |
| | | show: false |
| | | } |
| | | } |
| | | ], |
| | | yAxis: [ |
| | | { |
| | | type: "value", //æ°å¼è½´ |
| | | name: "æ£ææ²çº¿", |
| | | position: "right", |
| | | axisTick: { show: true }, |
| | | //axisLine: { |
| | | // show: false, |
| | | // lineStyle: { |
| | | // color: "rgba(255,255,255,1)" |
| | | // } |
| | | //}, |
| | | //axisLabel: { |
| | | // show: true, |
| | | // textStyle: { |
| | | // color: "rgba(255,255,255,1)", |
| | | // fontSize: 10 |
| | | // } |
| | | //}, |
| | | splitLine: { |
| | | show: false |
| | | } |
| | | }, |
| | | { |
| | | type: "value", |
| | | name: "颿°", |
| | | position: "left", |
| | | //axisLabel: { |
| | | // //formatter: '{value} %' |
| | | // show: true, |
| | | // textStyle: { |
| | | // color: "rgba(255,255,255,1)", |
| | | // fontSize: "12" |
| | | // } |
| | | //}, |
| | | axisTick: { |
| | | show: true |
| | | }, |
| | | //axisLine: { |
| | | // show: true, |
| | | // lineStyle: { |
| | | // color: "rgba(0,0,0,.1)", |
| | | // width: 1, |
| | | // type: "solid" |
| | | // } |
| | | //}, |
| | | splitLine: { |
| | | lineStyle: { |
| | | color: "rgba(255,255,255,.3)" |
| | | } |
| | | } |
| | | } |
| | | ], |
| | | series: [ |
| | | //æ²çº¿ |
| | | { |
| | | name: "æ£æåå¸", |
| | | type: "line", |
| | | smooth: true, |
| | | yAxisIndex: 0, |
| | | symbol: "circle", |
| | | symbolSize: 5, |
| | | showSymbol: false, |
| | | lineStyle: { |
| | | normal: { |
| | | color: "red", |
| | | width: 2 |
| | | } |
| | | }, |
| | | |
| | | itemStyle: { |
| | | normal: { |
| | | color: "#ceb664", |
| | | borderColor: "rgba(221, 220, 107, .1)", |
| | | borderWidth: 10 |
| | | } |
| | | }, |
| | | data: yArr, |
| | | markLine: { |
| | | symbol: ["none"], |
| | | lineStyle: { |
| | | type: "dotted", |
| | | color: "red" |
| | | }, |
| | | itemStyle: { |
| | | normal: { |
| | | show: true, |
| | | color: "black" |
| | | } |
| | | }, |
| | | label: { |
| | | show: true, |
| | | position: "end" |
| | | }, |
| | | data: [ |
| | | { |
| | | name: "Lower Spec", |
| | | xAxis: threeSigLow.toFixed(2), |
| | | label: { |
| | | show: true, |
| | | formatter: "Lower Spec" |
| | | }, |
| | | lineStyle: { |
| | | opacity: (xMin > threeSigLow) ? 0 : 1 |
| | | } |
| | | }, |
| | | { |
| | | name: "Upper Spec", |
| | | xAxis: threeSigUp.toFixed(2), |
| | | label: { |
| | | show: true, |
| | | formatter: "Upper Spec" |
| | | }, |
| | | lineStyle: { |
| | | opacity: (xMax < threeSigUp) ? 0 : 1 |
| | | } |
| | | } |
| | | ] |
| | | } |
| | | }, |
| | | //æ±ç¶å¾ |
| | | { |
| | | name: "颿°", |
| | | type: "bar", |
| | | yAxisIndex: 1, |
| | | xAxisIndex: 0, |
| | | barWidth: 10, |
| | | barGap: 1, |
| | | symbol: "solid", |
| | | symbolSize: 5, |
| | | showSymbol: true, |
| | | itemStyle: { |
| | | normal: { |
| | | color: "#0184d5", |
| | | opacity: 1, |
| | | barBorderRadius: 3 |
| | | } |
| | | }, |
| | | data: fArr, |
| | | markLine: { |
| | | symbol: ["none"], |
| | | lineStyle: { |
| | | type: "dotted", |
| | | color: "red" |
| | | }, |
| | | itemStyle: { |
| | | normal: { |
| | | show: true, |
| | | color: "black" |
| | | } |
| | | }, |
| | | label: { |
| | | show: true, |
| | | position: "middle" |
| | | }, |
| | | data: [ |
| | | { |
| | | name: "LowLimit", |
| | | xAxis: xMin.toFixed(2), |
| | | label: { |
| | | show: true, |
| | | formatter: "Low" |
| | | } |
| | | }, |
| | | { |
| | | name: "High", |
| | | xAxis: xMax.toFixed(2), |
| | | label: { |
| | | show: true, |
| | | formatter: "High" |
| | | } |
| | | } |
| | | ] |
| | | } |
| | | } |
| | | ] |
| | | }; |
| | | |
| | | option_ZXT_Avg && myChart.setOption(option_ZXT_Avg); |
| | | //#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(); |
| | | }); |
| | | |
| | | //车é´å¼¹çª |
| | | form.on('submit(HWorkShopList)', function () { |
| | | //页é¢å±-èªå®ä¹ |
| | | layer.open({ |
| | | type: 2, |
| | | skin: 'layui-layer-rim', //å ä¸è¾¹æ¡ |
| | | title: '车é´å表', |
| | | closeBtn: 1, |
| | | shift: 2, |
| | | area: ['80%', '80%'], |
| | | maxmin: true, |
| | | content: ['../../åºç¡èµæ/å
¬ç¨åºç¡èµæ/Gy_DepartmentList.html', 'yes'], |
| | | btn: ['ç¡®å®', 'åæ¶'] |
| | | , btn1: function (index, layero) { |
| | | |
| | | //æé®ãæé®ä¸ãçåè° |
| | | var iframeWindow = window['layui-layer-iframe' + index] //è·åå¼¹æ¡é¡µé¢ |
| | | var checkStatus = iframeWindow.layui.table.checkStatus('mainTable');//è·åtableçelem:"#test" |
| | | if (checkStatus.data.length === 0) { |
| | | return layer.msg('è¯·éæ©æ°æ®'); |
| | | } |
| | | $("#HWorkShopName").val(checkStatus.data[0].é¨é¨åç§°); |
| | | $("#HWorkShopID").val(checkStatus.data[0].HItemID); |
| | | layer.close(layer.index); //å®è·åçå§ç»æ¯ææ°å¼¹åºçæä¸ªå±ï¼å¼æ¯ç±layerå
é¨å¨æéå¢è®¡ç®ç |
| | | } |
| | | , btn2: function (index, layero) { |
| | | //æé®ãæé®äºãçåè° |
| | | //return false å¼å¯è¯¥ä»£ç å¯ç¦æ¢ç¹å»è¯¥æé®å
³é |
| | | }, |
| | | end: function () { |
| | | |
| | | }, |
| | | success: function (layero, index) { |
| | | |
| | | } |
| | | }); |
| | | }); |
| | | |
| | | ////ç©æ |
| | | //form.on('submit(btnHMaterID)', function (data) { |
| | | // get_btnHMaterID(); |
| | | //}); |
| | | |
| | | //#endregion |
| | | |
| | | //#region æ¤é¡µé¢ææçæ¹æ³ |
| | | |
| | | //åå§åçé¢ |
| | | function set_ClearBill() { |
| | | get_Dept(); |
| | | //åå§åæ¶é´ |
| | | $("#HBeginDate").val(Format(new Date(new Date() - 1000 * 60 * 60 * 24 * 10), "yyyy-MM-dd"));//å¼å§æ¥æ |
| | | $("#HEndDate").val(Format(new Date(), "yyyy-MM-dd"));//ç»ææ¥æ |
| | | //åå§åè¡¨æ ¼ |
| | | set_InitGrid(); |
| | | //å è½½æ°æ®å°ç½æ ¼ |
| | | //get_FastQuery(); |
| | | DisPlay_HideColumn(); |
| | | } |
| | | |
| | | //åå§åè¡¨æ ¼ |
| | | function set_InitGrid() { |
| | | option = { |
| | | elem: '#mainTable' |
| | | , toolbar: '#toolbarDemo' |
| | | , height: 'full-520' |
| | | //, page: true |
| | | , totalRow: true |
| | | , cellMinWidth: 70 |
| | | , limit: 50 |
| | | , limits: [50, 500, 5000, 20000] |
| | | , cols: [[ |
| | | { type: 'checkbox', fixed: 'left', totalRowText: 'âX' } |
| | | ,{ field: 'xh', title: 'åºå·' } |
| | | , { field: '1', title: '1' , totalRow: true} |
| | | , { field: '2', title: '2' , totalRow: true} |
| | | , { field: '3', title: '3' , totalRow: true} |
| | | , { field: '4', title: '4' , totalRow: true} |
| | | , { field: '5', title: '5' , totalRow: true} |
| | | , { field: '6', title: '6' , totalRow: true} |
| | | , { field: '7', title: '7' , totalRow: true} |
| | | , { field: '8', title: '8' , totalRow: true} |
| | | , { field: '9', title: '9', totalRow: true} |
| | | , { field: '10', title: '10' , totalRow: true} |
| | | , { field: '11', title: '11' , totalRow: true} |
| | | , { field: '12', title: '12' , totalRow: true} |
| | | , { field: '13', title: '13' , totalRow: true} |
| | | , { field: '14', title: '14' , totalRow: true} |
| | | , { field: '15', title: '15' , totalRow: true} |
| | | , { field: '16', title: '16' , totalRow: true} |
| | | , { field: '17', title: '17' , totalRow: true} |
| | | , { field: '18', title: '18' , totalRow: true} |
| | | , { field: '19', title: '19' , totalRow: true} |
| | | , { field: '20', title: '20' , totalRow: true} |
| | | , { field: '21', title: '21' , totalRow: true} |
| | | , { field: '22', title: '22' , totalRow: true} |
| | | , { field: '23', title: '23' , totalRow: true} |
| | | , { field: '24', title: '24' , totalRow: true} |
| | | , { field: '25', title: '25', totalRow: true} |
| | | ]] |
| | | , data: [] |
| | | } |
| | | var sj = []; |
| | | for (let i = 0; i < 5; i++) { |
| | | var obj = { |
| | | xh: i + 1, |
| | | 1:fullClose(5.25, 6.39).toFixed(2), |
| | | 2:fullClose(5.25, 6.39).toFixed(2), |
| | | 3:fullClose(5.25, 6.39).toFixed(2), |
| | | 4:fullClose(5.25, 6.39).toFixed(2), |
| | | 5:fullClose(5.25, 6.39).toFixed(2), |
| | | 6:fullClose(5.25, 6.39).toFixed(2), |
| | | 7:fullClose(5.25, 6.39).toFixed(2), |
| | | 8:fullClose(5.25, 6.39).toFixed(2), |
| | | 9:fullClose(5.25, 6.39).toFixed(2), |
| | | 10:fullClose(5.25, 6.39).toFixed(2), |
| | | 11:fullClose(5.25, 6.39).toFixed(2), |
| | | 12:fullClose(5.25, 6.39).toFixed(2), |
| | | 13:fullClose(5.25, 6.39).toFixed(2), |
| | | 14:fullClose(5.25, 6.39).toFixed(2), |
| | | 15:fullClose(5.25, 6.39).toFixed(2), |
| | | 16:fullClose(5.25, 6.39).toFixed(2), |
| | | 17:fullClose(5.25, 6.39).toFixed(2), |
| | | 18:fullClose(5.25, 6.39).toFixed(2), |
| | | 19:fullClose(5.25, 6.39).toFixed(2), |
| | | 20:fullClose(5.25, 6.39).toFixed(2), |
| | | 21:fullClose(5.25, 6.39).toFixed(2), |
| | | 22:fullClose(5.25, 6.39).toFixed(2), |
| | | 23:fullClose(5.25, 6.39).toFixed(2), |
| | | 24:fullClose(5.25, 6.39).toFixed(2), |
| | | 25:fullClose(5.25, 6.39).toFixed(2) |
| | | }; |
| | | sj.push(obj); |
| | | } |
| | | //var FH = ['âX','X','R'] |
| | | //for (let i = 0; i < 3;i++) { |
| | | // var obj = { |
| | | // xh: FH[i], |
| | | // 1: (Math.random() * (15 - 13)).toFixed(2), |
| | | // 2: (Math.random() * (15 - 13)).toFixed(2), |
| | | // 3: (Math.random() * (15 - 13)).toFixed(2), |
| | | // 4: (Math.random() * (15 - 13)).toFixed(2), |
| | | // 5: (Math.random() * (15 - 13)).toFixed(2), |
| | | // 6: (Math.random() * (15 - 13)).toFixed(2), |
| | | // 7: (Math.random() * (15 - 13)).toFixed(2), |
| | | // 8: (Math.random() * (15 - 13)).toFixed(2), |
| | | // 9: (Math.random() * (15 - 13)).toFixed(2), |
| | | // 10: (Math.random() * (15 - 13)).toFixed(2), |
| | | // 11: (Math.random() * (15 - 13)).toFixed(2), |
| | | // 12: (Math.random() * (15 - 13)).toFixed(2), |
| | | // 13: (Math.random() * (15 - 13)).toFixed(2), |
| | | // 14: (Math.random() * (15 - 13)).toFixed(2), |
| | | // 15: (Math.random() * (15 - 13)).toFixed(2), |
| | | // 16: (Math.random() * (15 - 13)).toFixed(2), |
| | | // 17: (Math.random() * (15 - 13)).toFixed(2), |
| | | // 18: (Math.random() * (15 - 13)).toFixed(2), |
| | | // 19: (Math.random() * (15 - 13)).toFixed(2), |
| | | // 20: (Math.random() * (15 - 13)).toFixed(2), |
| | | // 21: (Math.random() * (15 - 13)).toFixed(2), |
| | | // 22: (Math.random() * (15 - 13)).toFixed(2), |
| | | // 23: (Math.random() * (15 - 13)).toFixed(2), |
| | | // 24: (Math.random() * (15 - 13)).toFixed(2), |
| | | // 25: (Math.random() * (15 - 13)).toFixed(2) |
| | | // }; |
| | | // sj.push(obj); |
| | | //} |
| | | option.data = sj; |
| | | |
| | | |
| | | table.render(option); |
| | | } |
| | | |
| | | //åå¾[n,m]èå´éæºæ° |
| | | function fullClose(n, m) { |
| | | var result = Math.random() * (m + 1 - n) + n; |
| | | while (result > m) { |
| | | result = Math.random() * (m + 1 - n) + n; |
| | | } |
| | | return result; |
| | | } |
| | | |
| | | //å è½½ç½æ ¼ |
| | | function get_Display(sWhere) { |
| | | sWhere = $("#HYear").val(); |
| | | var wait = layer.load();//é®ç½© |
| | | $.ajax({ |
| | | url: GetWEBURL() + '/QC_CustomerAppealReport/ProblemType', |
| | | type: "GET", |
| | | async: false, |
| | | data: { "sWhere": sWhere, "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; |
| | | default: |
| | | col.push({ field: data[i].name, title: data[i].name, align: 'center', sort: true, totalRow: true }); |
| | | } |
| | | } |
| | | } |
| | | |
| | | 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_Dept() { |
| | | //è·å车é´å |
| | | 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; |
| | | if (sessionStorage["OrganizationID"] == 100014) { |
| | | HDeptName += '<option style="color:blue;" value="2679633" >æ°´ç®±ä¸æ¡æµ</option>'; |
| | | HDeptName += '<option style="color:blue;" value="1592361" >é¨ä»¶æ²¹å·å¨å·´</option>'; |
| | | HDeptName += '<option style="color:blue;" value="1592371" >å°è½¦è£
è¯å·´</option>'; |
| | | HDeptName += '<option style="color:blue;" value="1592374" >å°è½¦æ»æå·´</option>'; |
| | | HDeptName += '<option style="color:blue;" value="1743766" >å¡è½¦è£
è¯å·´</option>'; |
| | | HDeptName += '<option style="color:blue;" value="1743767" >å¡è½¦æ»æå·´</option>'; |
| | | HDeptName += '<option style="color:blue;" value="2679647" >å¡è½¦æ°´ç®±ä¸æ¡æµ</option>'; |
| | | } else { |
| | | for (var i = 0; i < data.length; i++) { |
| | | HDeptName += '<option style="color:blue;" value="' + data[i].HItemID + '" >' + data[i].HName + '</option>'; |
| | | } |
| | | } |
| | | |
| | | $("#HDeptName").append(HDeptName); |
| | | form.render('select'); |
| | | } |
| | | layer.closeAll("loading"); |
| | | } |
| | | }) |
| | | } |
| | | |
| | | //å¿«éè¿æ»¤ |
| | | function get_FastQuery() { |
| | | var HBeginDate = $("#HBeginDate").val();//ä¸è¾¾æ¥æ å¼å§æ¥æ |
| | | var HEndDate = $("#HEndDate").val();//ç»ææ¥æ |
| | | var HBillNo = $("#HBillNo").val();//æµè½¬å¡å· |
| | | var HICMOBillNo = $("#HICMOBillNo").val(); //æ¹å· |
| | | var HWorkShopID = $("#HDeptName").val();//è½¦é´ |
| | | var F_BSV_WYID = $("#F_BSV_WYID").val();//å¯ä¸ID |
| | | var HMaterNumber = $("#HMaterNumber").val();//ç©æä»£ç |
| | | var HState = $("#HState").val();//ç¶æ |
| | | var HSTATUS = $("#HSTATUS").val();//ç产订åç¶æ |
| | | var HOrgID = sessionStorage["OrganizationID"]; |
| | | var checkWRuku = $("input[name='checkWRuku']").prop("checked");//å¤éæ¡ |
| | | var ColName = $("#ColName").val();//å¤éæ¡ |
| | | var Comparator = $("#Comparator").val() |
| | | var ColContent = $("#ColContent").val(); |
| | | var sWhere1 = ""; |
| | | 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; |
| | | } |
| | | sWhere1 += " and " + ColName + " " + com; |
| | | } |
| | | |
| | | if (checkWRuku) { |
| | | checkWRuku = 1; |
| | | } else { |
| | | checkWRuku = 0; |
| | | } |
| | | |
| | | sWhere = { |
| | | HBeginDate: HBeginDate |
| | | , HEndDate: HEndDate |
| | | , HICMOBillNo: HICMOBillNo |
| | | , HWorkShopID: HWorkShopID |
| | | , F_BSV_WYID: F_BSV_WYID |
| | | , HMaterNumber: HMaterNumber |
| | | , HOrgID: HOrgID |
| | | , HBillNo: HBillNo |
| | | , IsTrue: checkWRuku |
| | | , HState: HState |
| | | , HSTATUS: HSTATUS |
| | | , sWhere1: sWhere1 |
| | | } |
| | | |
| | | //get_Display(JSON.stringify(sWhere)); |
| | | //è°ç¨æ¥å£åæ¸
空sWhereç¼å |
| | | sWhere = ""; |
| | | } |
| | | //éç½®è¿æ»¤æ¡ä»¶ |
| | | function set_ClearQuery() { |
| | | $("#HBeginDate").val(Format(new Date(new Date() - 1000 * 60 * 60 * 24 * 10), "yyyy-MM-dd"));//å¼å§æ¥æ |
| | | $("#HEndDate").val(Format(new Date(), "yyyy-MM-dd"));//ç»ææ¥æ |
| | | $("#HICMOBillNo").val(""); |
| | | $("#HProcExchBillNo").val(""); |
| | | $("#HName").val(""); |
| | | $("#HBillNo").val(""); |
| | | $("#HMaterNumber").val(""); |
| | | $("#F_BSV_WYID").val(""); |
| | | $("#HState").val("0") |
| | | $("#ColContent").val(""); |
| | | $("#ColName").val("0"); |
| | | $("#Comparator").val("0"); |
| | | $("input[name='checkWRuku']").prop("checked", false); |
| | | form.render() |
| | | sWhere = ""; |
| | | } |
| | | |
| | | //ç©æ |
| | | function get_btnHMaterID() { |
| | | layer.open({ |
| | | type: 2 |
| | | , area: ['80%', '80%'] |
| | | , title: 'ç©æ' |
| | | , shade: 0.6 //é®ç½©éæåº¦ |
| | | //, maxmin: true //å
许å
¨å±æå°å |
| | | , anim: 0 //0-6çå¨ç»å½¢å¼ï¼-1ä¸å¼å¯ |
| | | , content: ['../../Baseset/åºç¡èµæ/Gy_MaterialList.html', 'yes'] |
| | | , btn: ['ç¡®å®', 'åæ¶'] |
| | | , btn1: function (index, layero) { |
| | | |
| | | //æé®ãæé®ä¸ãçåè° |
| | | var iframeWindow = window['layui-layer-iframe' + index] //è·åå¼¹æ¡é¡µé¢ |
| | | var checkStatus = iframeWindow.layui.table.checkStatus('mainTable');//è·åtableçelem:"#test" |
| | | if (checkStatus.data.length === 0) { |
| | | return layer.msg('è¯·éæ©æ°æ®'); |
| | | } |
| | | $("#HMaterID").val(checkStatus.data[0].HItemID); |
| | | $("#HMaterNumber").val(checkStatus.data[0].HNumber); |
| | | layer.close(layer.index); //å®è·åçå§ç»æ¯ææ°å¼¹åºçæä¸ªå±ï¼å¼æ¯ç±layerå
é¨å¨æéå¢è®¡ç®ç |
| | | } |
| | | }) |
| | | } |
| | | |
| | | //éèå设置 |
| | | 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++) { |
| | | if (dataCol[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 }); |
| | | } |
| | | }) |
| | | } |
| | | |
| | | //åææ¾ç¤ºä¸ææ¡ |
| | | 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); |
| | | form.render('select'); |
| | | } |
| | | |
| | | |
| | | //#endregion |
| | | }); |
| | | </script> |
| | | </body> |
| | | </html> |