zrg
2024-07-01 43c633b50bc7dca4d78855e57546fe16e2e44562
WebTM/views/³µ¼ä¹ÜÀí/±¨±í·ÖÎö/Kf_ProdProcessSumReport_DyeColor.html
@@ -2,7 +2,7 @@
<html>
<head>
    <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
    <title>白坯发布明细报表</title>
    <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">
@@ -143,6 +143,7 @@
                        <table class="" id="mainTable" lay-filter="mainTable"></table>
                        <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>
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-detail"><i class="layui-icon layui-icon-return"></i>明细报表</button>
@@ -177,6 +178,8 @@
            var HModName = "ProdProcessSumReport_DyeColor";
            var titleData = ["HCusID"];//不需要显示的字段 å¯æ‰©å±•
            var ins;                        //用于导出excel
            //#endregion
            //#region è¿›å…¥é¡µé¢æ—¢åŠ è½½
@@ -190,6 +193,10 @@
            //头工具栏事件
            table.on('toolbar(mainTable)', function (obj) {
                switch (obj.event) {
                    //导出excel
                    case 'get_export':
                        get_Export();
                        break;
                    //退出
                    case 'btn-exit': Pub_Close(2);
                        break;
@@ -342,12 +349,12 @@
                    url: GetWEBURL() + "/ProdProcessSumReport/ProdProcessSumReport_DyeColor",
                    type: "GET",
                    async: false,
                    data: { "sWhere": sWhere },
                    data: { "sWhere": sWhere, "user": sessionStorage["HUserName"]  },
                    //async: false,
                    success: function (data1) {
                        if (data1.count == 1) {
                            var totalArray = ["生产任务单数量", "白坯发布"];
                            var data = [];
                            var col = [];
                            //给空的数组赋值
@@ -360,6 +367,9 @@
                            for (var i = 0; i < data.length; i++) {
                                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].ColName == '白坯发布') {
                                    col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: true, totalRow: true });
@@ -385,7 +395,7 @@
                                , cols: [col]
                                , data: data1.data
                            };
                            table.render(option);
                            ins = table.render(option);
                        } else {
                            option = {
                                elem: '#mainTable'
@@ -403,14 +413,14 @@
                                    , { field: '规格型号', title: '规格型号', width: 160 }
                                    , { field: '业务员', title: '业务员', width: 160 }
                                    , { field: '客户', title: '客户', width: 160 }
                                    , { field: '生产任务单数量', title: '生产任务单数量', width: 200 }
                                    , { field: '生产任务单数量', title: '生产任务单数量', totalRow: true, width: 200 }
                                    , { field: '白坯发布', title: '白坯发布', width: 160, totalRow: true }
                                    , { field: '是否下推生成流转卡', title: '是否下推生成流转卡', width: 160 }
                                ]]
                                , done: function (res) {
                                }
                            };
                            table.render(option);
                            ins = table.render(option);
                        }
                    },
                    error: function (err) {
@@ -444,7 +454,7 @@
                $.ajax({
                    url: GetWEBURL() + '/ProdProcessSumReport/ProdProcessSumReport_DyeColor',
                    type: "GET",
                    data: { "sWhere": sWhere },
                    data: { "sWhere": sWhere, "user": sessionStorage["HUserName"]  },
                    success: function (data1) {
                        if (data1.count == 1) {
                            //调整日期格式:显示 å¹´æœˆæ—¥ å’Œ æ—¶
@@ -467,7 +477,7 @@
                            //        }
                            //    }
                            //}
                            table.render(option);
                            ins = table.render(option);
                            //计算白坯发布合计公斤数
                            var sumHMaterOutQty = 0;
@@ -575,6 +585,27 @@
                sWhere = "";
            }
            //#region å¯¼å‡ºExecel
            function get_Export() {
                var ModRightNameCheck = "Kf_ProdProcessSumReport_DyeColor_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() {
@@ -734,6 +765,7 @@
                        layer.alert("接口请求失败!", { icon: 5 });
                    }
                });
                res = res.replaceAll("'", "''");
                return res;
            }
            //#endregion