yusijie
2024-04-12 7f7179d00825d06ec064f8bbbccdf406424a4609
WebTM/views/³µ¼ä¹ÜÀí/±¨±í·ÖÎö/Kf_MaterOutEntryReport_Cloth.html
@@ -149,6 +149,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>
                            </div>
@@ -181,6 +182,8 @@
            var option = [];
            var HModName = "MaterOutEntryReport_Cloth";
            var ins;                        //用于导出excel
            var detailBar = 0;       //用于汇总报表查看明细报表,当为0时显示明细汇总报表对应明细报表。
            //#endregion
@@ -195,6 +198,10 @@
            //头工具栏事件
            table.on('toolbar(mainTable)', function (obj) {
                switch (obj.event) {
                    //导出excel
                    case 'get_export':
                        get_Export();
                        break;
                    //退出
                    case 'btn-exit': Pub_Close(2);
                        break;
@@ -238,8 +245,8 @@
            //初始化界面
            function set_ClearBill() {
                //初始化时间
                var HBeginDate = Format(new Date(new Date() - 1000 * 60 * 60 * 24 * 1).setHours(8, 0, 0, 0), "yyyy-MM-dd hh");
                var HEndDate = Format(new Date(new Date()).setHours(8, 0, 0, 0), "yyyy-MM-dd hh");
                var HBeginDate = Format(new Date(new Date() - 1000 * 60 * 60 * 24 * 1).setHours(7, 0, 0, 0), "yyyy-MM-dd hh");
                var HEndDate = Format(new Date(new Date()).setHours(7, 0, 0, 0), "yyyy-MM-dd hh");
                laydate.render({
                    elem: '#HBeginDate',
                    type: 'datetime',
@@ -269,8 +276,8 @@
            //初始化表格
            function set_InitGrid() {
                var HBeginDate = Format(new Date(new Date() - 1000 * 60 * 60 * 24 * 1).setHours(8, 0, 0, 0), "yyyy-MM-dd hh") + ":00:00";//下达日期 å¼€å§‹æ—¥æœŸ
                var HEndDate = Format(new Date(new Date()).setHours(8, 0, 0, 0), "yyyy-MM-dd hh") + ":00:00";//结束日期
                var HBeginDate = Format(new Date(new Date() - 1000 * 60 * 60 * 24 * 1).setHours(7, 0, 0, 0), "yyyy-MM-dd hh") + ":00:00";//下达日期 å¼€å§‹æ—¥æœŸ
                var HEndDate = Format(new Date(new Date()).setHours(7, 0, 0, 0), "yyyy-MM-dd hh") + ":00:00";//结束日期
                //var HBeginDate = $("#HBeginDate").val() + ":00:00" ;//下达日期 å¼€å§‹æ—¥æœŸ
                //var HEndDate = $("#HEndDate").val()+":00:00";//结束日期
@@ -324,12 +331,12 @@
                    url: GetWEBURL() + "/MaterOutEntryReport/MaterOutEntryReport_Cloth",
                    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 = [];
                            //给空的数组赋值
@@ -348,6 +355,9 @@
                            for (var i = 0; i < data.length; i++) {
                                if ($.inArray(data[i].name, "") > -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 });
@@ -373,7 +383,7 @@
                                , cols: [col]
                                , data: data1.data
                            };
                            table.render(option);
                            ins = table.render(option);
                        } else {
                            option = {
                                elem: '#mainTable'
@@ -390,7 +400,7 @@
                                    , { field: '产品名称', title: '产品名称', width: 160 }
                                    , { field: '规格型号', title: '规格型号', width: 160 }
                                    , { field: '当前工序', title: '当前工序', width: 160 }
                                    , { field: '任务数量', title: '任务数量', width: 160 }
                                    , { field: '任务数量', title: '任务数量', totalRow: true,width: 160 }
                                    , { field: '制单人', title: '制单人', width: 200 }
                                    , { field: '流转卡数量', title: '流转卡数量', width: 160, totalRow: true }
                                ]]
@@ -414,7 +424,7 @@
                                    //});
                                }
                            };
                            table.render(option);
                            ins = table.render(option);
                        }
                    },
                    error: function (err) {
@@ -448,7 +458,7 @@
                $.ajax({
                    url: GetWEBURL() + '/MaterOutEntryReport/MaterOutEntryReport_Cloth',
                    type: "GET",
                    data: { "sWhere": sWhere },
                    data: { "sWhere": sWhere, "user": sessionStorage["HUserName"] },
                    success: function (data1) {
                        if (data1.count == 1) {
                            //调整日期格式:显示 å¹´æœˆæ—¥ å’Œ æ—¶ åˆ†
@@ -472,7 +482,7 @@
                            //        }
                            //    }
                            //}
                            table.render(option);
                            ins = table.render(option);
                            //计算合计公斤数
                            var sumHMaterOutQty = 0;
@@ -501,12 +511,12 @@
                var HEndDate = $("#HEndDate").val();//结束日期
                if (HBeginDate == '') {
                    HBeginDate = Format(new Date(new Date() - 1000 * 60 * 60 * 24 * 1).setHours(8, 0, 0, 0), "yyyy-MM-dd hh") + ":00:00";//下达日期 å¼€å§‹æ—¥æœŸ
                    HBeginDate = Format(new Date(new Date() - 1000 * 60 * 60 * 24 * 1).setHours(7, 0, 0, 0), "yyyy-MM-dd hh") + ":00:00";//下达日期 å¼€å§‹æ—¥æœŸ
                } else {
                    HBeginDate = $("#HBeginDate").val() + ":00:00";//下达日期 å¼€å§‹æ—¥æœŸ
                }
                if (HEndDate == '') {
                    HEndDate = Format(new Date(new Date()).setHours(8, 0, 0, 0), "yyyy-MM-dd hh") + ":00:00";//结束日期
                    HEndDate = Format(new Date(new Date()).setHours(7, 0, 0, 0), "yyyy-MM-dd hh") + ":00:00";//结束日期
                } else {
                    HEndDate = $("#HEndDate").val() + ":00:00";//结束日期
                }
@@ -581,8 +591,8 @@
            //重置过滤条件
            function set_ClearQuery() {
                //初始化时间
                var HBeginDate = Format(new Date(new Date() - 1000 * 60 * 60 * 24 * 1).setHours(8, 0, 0, 0), "yyyy-MM-dd hh");
                var HEndDate = Format(new Date(new Date()).setHours(8, 0, 0, 0), "yyyy-MM-dd hh");
                var HBeginDate = Format(new Date(new Date() - 1000 * 60 * 60 * 24 * 1).setHours(7, 0, 0, 0), "yyyy-MM-dd hh");
                var HEndDate = Format(new Date(new Date()).setHours(7, 0, 0, 0), "yyyy-MM-dd hh");
                laydate.render({
                    elem: '#HBeginDate',
                    type: 'datetime',
@@ -613,6 +623,28 @@
            }
            //#region å¯¼å‡ºExecel
            function get_Export() {
                var ModRightNameCheck = "Kf_MaterOutEntryReport_Cloth_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 = "";