1
wtt
2024-05-24 1d46d1f94851c843813961c0fc0ac61d60596e9c
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">
@@ -59,19 +59,19 @@
                                    <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-inline">
                                <div class="layui-inline" style="display:none;">
                                    <label class="layui-form-label">白坯发布合计公斤数</label>
                                    <div class="layui-input-block" style="margin-left: 120px;">
                                        <input type="text" class="layui-input" name="SumHMaterOutQty" id="SumHMaterOutQty" disabled="disabled">
                                    </div>
                                </div>
                                <div class="layui-inline">
                                <div class="layui-inline" style="display:none;">
                                    <label class="layui-form-label">染厂出站合计公斤数</label>
                                    <div class="layui-input-block" style="margin-left: 120px;">
                                        <input type="text" class="layui-input" name="SumDyeColorOut" id="SumDyeColorOut" disabled="disabled">
                                    </div>
                                </div>
                                <div class="layui-inline">
                                <div class="layui-inline" style="display:none;">
                                    <label class="layui-form-label">差额</label>
                                    <div class="layui-input-block" style="margin-left: 120px;">
                                        <input type="text" class="layui-input" name="SumCompare" id="SumCompare" disabled="disabled">
@@ -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>
@@ -175,6 +176,10 @@
            var sWhere = "";
            var option = [];
            var HModName = "ProdProcessSumReport_DyeColor";
            var titleData = ["HCusID"];//不需要显示的字段 å¯æ‰©å±•
            var ins;                        //用于导出excel
            //#endregion
            //#region è¿›å…¥é¡µé¢æ—¢åŠ è½½
@@ -188,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;
@@ -228,6 +237,42 @@
                });
            });
            //行监听事件-双击
            table.on('rowDouble(mainTable)', function (obj) {
                //选中高亮 åŒå‡»è¡Œ
                obj.tr.find(':checkbox').prop('checked', true);
                obj.tr.find('.layui-form-checkbox').addClass('layui-form-checked');  //设置复选框选中样式
                $(obj.tr.selector).attr({ "style": "background:#ceedfa;color:black" });//改变当前tr背景颜色和字体颜色
                //mainTable ä¸ºè¡¨æ ¼ID   æ³¨æ„æ­¤å¤„如果ID不正确将导致你在监听复选框时获取不到你选择的数据,前面的只是添加或删除选中未选中样式以及设置背景色,字体颜色
                layui.each(table.cache.mainTable, function (i, l) {
                    if (obj.tr.index() == l.LAY_TABLE_INDEX) {
                        l.LAY_CHECKED = true;
                    }
                });
                //下推
                var sBillNo = obj.data["生产订单号"];
                layer.open({
                    type: 2
                    , area: ['90%', '90%']
                    , title: '染厂明细报表'
                    , closeBtn: 1
                    , shade: 0.6 //遮罩透明度
                    , maxmin: true //允许全屏最小化
                    , anim: 0 //0-6的动画形式,-1不开启
                    , content: 'Kf_ProdProcessEntryReport_DyeColor.html?sBillNo=' + sBillNo
                    , resize: false
                    , btn: ["确定", "取消"]
                    , end: function () {
                        //刷新页面,
                        //location.reload();
                    }
                    , cancel: function () {
                        //$(".layui-btn").removeClass("layui-btn-disabled");
                    }
                })
            });
            //#endregion
@@ -283,6 +328,10 @@
                    com = " and (" + ColName + " " + com + ")";
                }
                //根据用户过滤用户关联客户的记录
                var OtherSearch = getSWhereByHUser();
                sWhere = {
                    HBeginDate: HBeginDate
                    , HEndDate: HEndDate
@@ -291,6 +340,7 @@
                    , HProductName: HProductName
                    , HProductModel: HProductModel
                    , RandomSearch: com
                    , OtherSearch: (OtherSearch == null || OtherSearch == "undefine") ? " and 1=1 " : OtherSearch
                }
                sWhere = JSON.stringify(sWhere);
@@ -299,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 = [];
                            //给空的数组赋值
@@ -315,8 +365,11 @@
                            //在列表左边添加勾选框
                            col.push({ type: 'checkbox', fixed: 'left' });
                            for (var i = 0; i < data.length; i++) {
                                if ($.inArray(data[i].name, "") > -1) {
                                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 });
@@ -342,7 +395,7 @@
                                , cols: [col]
                                , data: data1.data
                            };
                            table.render(option);
                            ins = table.render(option);
                        } else {
                            option = {
                                elem: '#mainTable'
@@ -360,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) {
@@ -401,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) {
                            //调整日期格式:显示 å¹´æœˆæ—¥ å’Œ æ—¶
@@ -424,7 +477,7 @@
                            //        }
                            //    }
                            //}
                            table.render(option);
                            ins = table.render(option);
                            //计算白坯发布合计公斤数
                            var sumHMaterOutQty = 0;
@@ -496,14 +549,19 @@
                    com = " and (" + ColName + " " + com + ")";
                }
                //根据用户过滤用户关联客户的记录
                var OtherSearch = getSWhereByHUser();
                sWhere = {
                    HBeginDate: HBeginDate
                    , HEndDate: HEndDate
                    ,HMaterNumber: HMaterNumber
                    , HMaterNumber: HMaterNumber
                    , HBillNo: HBillNo
                    , HProductName: HProductName
                    , HProductModel: HProductModel
                    , RandomSearch:com
                    , RandomSearch: com
                    , OtherSearch: (OtherSearch == null || OtherSearch == "undefine") ? " and 1=1 " : OtherSearch
                }
                //set_InitGrid(JSON.stringify(sWhere));
                get_Display(JSON.stringify(sWhere));
@@ -527,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() {
@@ -566,7 +645,7 @@
                        if (data1.data.length != 0) {
                            var dataCol = [];//数据库查询出的列数据
                            var titleData = [];//不需要显示的字段 å¯æ‰©å±•
                            /*var titleData = [];//不需要显示的字段 å¯æ‰©å±•*/
                            dataCol = data1.data[0].HGridString.split(',');
@@ -664,6 +743,32 @@
                    layer.msg('请选择一行数据编辑!');
                }
            }
            //#region æ ¹æ®ç”¨æˆ·èŽ·å–ç”¨æˆ·å…³è”å®¢æˆ·çš„è¿‡æ»¤æ¡ä»¶
            function getSWhereByHUser() {
                var res = "";
                $.ajax({
                    type: "GET",
                    async: false,
                    url: GetWEBURL() + "/Xs_SeOrderBill/getCusIDListByUser", //方法所在页面和方法名
                    data: { "CurUserID": sessionStorage["Czybm"], "CurUserName": sessionStorage["HUserName"] },
                    success: function (result) {
                        if (result.count == 1) {
                            res = result.data;
                        } else {
                            res = result.data;
                            layer.alert(result.code + result.Message, { icon: 5 });
                        }
                    }, error: function (err) {
                        res = " and 1 = 0";
                        layer.alert("接口请求失败!", { icon: 5 });
                    }
                });
                res = res.replaceAll("'", "''");
                return res;
            }
            //#endregion
            //#endregion
        });
    </script>