wtt
2024-09-06 fe8ead087719a7f3bbe4e495b67c2865da937957
WebTM/views/Éú²ú¹ÜÀí/Éú²ú±¨±í/Sc_QualityReportBillMonth.html
@@ -42,7 +42,7 @@
                                        </select>
                                    </div>
                                </div>
                                <div class="layui-inline "style="display:none">
                                <div class="layui-inline " style="display:none">
                                    <label class="layui-form-label" style="width: 85px;">工作中心</label>
                                    <div class="layui-input-block" style="margin-left: 120px; width: 120px;">
                                        <select name="HWorkCenter" id="HWorkCenter" lay-verify="HWorkCenter">
@@ -57,6 +57,18 @@
                                        <input type="text" class="layui-input" id="HName" 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" 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" id="HEndDate" style="width:190px;">
                                    </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>
@@ -69,12 +81,13 @@
                            <div id="histogram" style="width:99.5%;height:calc(68vh);margin-top:10px;">
                            </div>
                            <div style="width:99%;height:calc(30vh);">
                            <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="get_export" id="get_export"><i class="layui-icon layui-icon-export"></i>导出</button>
                                <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>
@@ -107,6 +120,7 @@
            var option = [];
            var HModName = "Sc_QualityReportBillMonth";
            var HDeptID = 0;
            var ins;
            //#endregion
            //#region è¿›å…¥é¡µé¢æ—¢åŠ è½½
@@ -161,7 +175,7 @@
                    // å¡«å……数据
                    for (let i = 0; i < H_X.length; i++) {
                        let month = i + 1; // 1到12的月份
                        let year = $("#Hyear").val(); // å½“前年份
                        let year = $("#HYear").val(); // å½“前年份
                        // å°† monthlyTotals ä¸­çš„æ•°é‡å¡«å……到 HProcSumNum ä¸­
                        if (monthlyTotals[year] && monthlyTotals[year][month]) {
@@ -257,10 +271,7 @@
                    yAxis: [
                        {
                            type: 'value',
                            name: '生产数量',
                            //min: 0,
                            //max: 200000,
                            //interval: 10000,
                            name: '生产数量',
                            axisLabel: {
                                formatter: '{value}'
                            }
@@ -279,24 +290,44 @@
                    series: [
                        {
                            name: '注塑数量',
                            type: 'bar',
                            type: 'bar',
                            tooltip: {
                                valueFormatter: function (value) {
                                    return value;
                                }
                            },
                            itemStyle: {
                                normal: {
                                    label: {
                                        show: true,      //开启显示
                                        textStyle: {       //数值样式
                                            color: 'black',
                                            fontSize: 16
                                        }
                                    }
                                },
                                color: '#0000FF' // è®¾ç½®æŸ±çŠ¶å›¾é»‘è‰²
                            },
                            data: HProcSumNum
                        },
                        {
                            name: '注塑良率',
                            type: 'line',
                            yAxisIndex: 1,
                            yAxisIndex: 1,
                            label: {
                                show: true,
                                formatter: '{c}%'
                            },
                            data: HQualifiedNum
                        },
                        {
                            name: '全检良率',
                            type: 'line',
                            yAxisIndex: 1,
                            yAxisIndex: 1,
                            label: {
                                show: true,
                                formatter: '{c}%'
                            },
                            data: HFirstPassRate
                        }
                    ]
@@ -313,6 +344,10 @@
                    //退出
                    case 'btn-exit': Pub_Close(2);
                        break;
                    //导出excel
                    case 'get_export':
                        get_Export();
                        break;
                    //隐藏列设置
                    case 'HideColumn':
                        get_HideColumn();
@@ -326,7 +361,7 @@
            //查询按钮
            form.on('submit(btnSearch)', function (data) {
                get_FastQuery();
                get_FastQuery(2);
            });
            //退出按钮
@@ -345,11 +380,12 @@
            //初始化界面
            function set_ClearBill() {
                Year();               
                $("#HBeginDate").val(Format(new Date(new Date().setMonth(new Date().getMonth() - 6)), "yyyy-MM-dd"));
                $("#HEndDate").val(Format(new Date(), "yyyy-MM-dd"));
                //初始化表格
                set_InitGrid();
                //加载数据到网格
                get_FastQuery();
                get_FastQuery(1);
                //加载柱状图
                set_Graphics();
@@ -372,13 +408,12 @@
                option = {
                    elem: '#mainTable'
                    , toolbar: '#toolbarDemo'
                    , height: '200px'
                    , height: '600px'
                    , totalRow: true
                    , page: true
                    , cellMinWidth: 90
                    , limit: 50
                    , limits: [50, 500, 5000, 20000]
                }
            }
@@ -390,10 +425,10 @@
                    type: "GET",
                    async: false,
                    data: { "sWhere": sWhere ,"user": sessionStorage["HUserName"] },
                    success: function (data1) {
                        var col = [];
                    success: function (data1) {
                        if (data1.count == 1) {
                            var data = [];
                            var col = [];
                            //给空的数组赋值
                            for (var key in data1.list) {
                                data.push({ "name": data1.list[key].ColmCols, "Type": data1.list[key].ColmType });
@@ -410,28 +445,33 @@
                                        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, width: 120, totalRow: true });
                                            break;
                                        default:
                                            col.push({ field: data[i].name, title: data[i].name, align: 'center', sort: true, totalRow: true, width: 120 });
                                    }
                                }
                            }
                            //if (data1.data.length>0) {
                            //    for (let i = 1; i <= 12; i++) {
                            //        if (data1.data[0][i + "月"] != 0) {
                            //            data1.data[3][i + "月"] = (data1.data[3][i + "月"]).toFixed(2) + '%'
                            //        }
                            //        else {
                            //            data1.data[3][i + "月"] = (0.00).toFixed(2) + '%'
                            //        }
                            //    }
                            //    data1.data[3].合计 = (data1.data[3].合计).toFixed(2) + '%'
                            //}
                            option.cols = [col];
                            option.data = data1.data;
                            //动态显示列名
                            option = {
                                elem: '#mainTable'
                                , toolbar: '#toolbarDemo'
                                , cols: [col]
                                , data: data1.data
                                , height: 'full-80'
                                , totalRow: true
                                , page: true
                                , limits: [50, 500, 5000, 50000]
                                , limit: 50
                                , cellMinWidth: 90
                            }
                            table.render(option);
                            ins = table.render(option);
                            layer.close(wait);
                        } else {
                            layer.close(wait);
@@ -445,17 +485,21 @@
            }
            //快速过滤
            function get_FastQuery() {
            function get_FastQuery(number) {
                var HYear = $("#HYear").val(); //年份
                var HWorkCenter = $("#HWorkCenter").val() != null ? '': $("#HWorkCenter").val(); //工作中心
                var HName = $("#HName").val();//物料名称
                var HBeginDate = $("#HBeginDate").val(); //开始日期
                var HEndDate = $("#HEndDate").val(); //结束日期
                sWhere = {
                    HYear: HYear
                    , HWorkCenter: HWorkCenter
                    , HName: HName
                    , HBeginDate: HBeginDate
                    , HEndDate: HEndDate
                }
                get_Display(JSON.stringify(sWhere));
                //调用接口后清空sWhere缓存
                sWhere = "";
                //加载柱状图
@@ -468,6 +512,28 @@
                get_Display(JSON.stringify(sWhere));
            }
            //#region å¯¼å‡ºExecel
            function get_Export() {
                var ModRightNameCheck = "Gy_ProjectMoney_ExportExcel";
                //逻辑审核方法
                $.ajax({
                    type: "GET",
                    url: GetWEBURL() + "/LMES/getReportByModRightNameCheck", //方法所在页面和方法名
                    data: { "ModRightNameCheck": ModRightNameCheck, "user": sessionStorage["HUserName"] },
                    success: function (result) {
                        if (result.count == 1) {
                            table.exportFile(ins.config.id, option.data, "xls");
                        } else {
                            layer.alert("当前模块没有导出权限!", { icon: 5 });
                        }
                    }, error: function () {
                        layer.alert("接口请求失败!", { icon: 5 });
                    }
                });
            }
            //#endregion
            //隐藏列设置
            function get_HideColumn() {
                var colName = "";