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">
@@ -34,15 +34,15 @@
                                    </div>
                                </div>
                                <!--<div class="layui-inline">
                                    <label class="layui-form-label">状态</label>
                                    <div class="layui-input-block" style="margin-left: 120px;width: 184px;">
                                        <select name="HState" lay-verify="HState" id="HState">
                                            <option value="0" selected="selected">全部</option>
                                            <option value="1">未开工</option>
                                            <option value="3">已入库</option>
                                        </select>
                                    </div>
                                </div>-->
        <label class="layui-form-label">状态</label>
        <div class="layui-input-block" style="margin-left: 120px;width: 184px;">
            <select name="HState" lay-verify="HState" id="HState">
                <option value="0" selected="selected">全部</option>
                <option value="1">未开工</option>
                <option value="3">已入库</option>
            </select>
        </div>
    </div>-->
                                <div class="layui-inline">
                                    <label class="layui-form-label">日期</label>
                                    <div class="layui-input-block">
@@ -59,17 +59,29 @@
                                    <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">
                                    <label class="layui-form-label">合计公斤数</label>
                                <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 style="padding-left: 10px;">
                                        <input type="checkbox" name="checkWRuku" id="checkWRuku" lay-skin="primary" lay-filter="checkWRuku" title="未下推及已入库">
                                <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>
                                <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">
                                    </div>
                                </div>
                                <!--<div class="layui-inline">
        <div style="padding-left: 10px;">
            <input type="checkbox" name="checkWRuku" id="checkWRuku" lay-skin="primary" lay-filter="checkWRuku" title="未下推及已入库">
        </div>
    </div>-->
                                <div class="layui-colla-content" style="padding: 0px; margin-left: 6%;">
                                    <div class="layui-row" style="margin-top:10px;">
                                        <!--其他条件-->
@@ -131,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>
@@ -162,7 +175,11 @@
            //查询条件
            var sWhere = "";
            var option = [];
            var HModName = "MaterOutSumReport_Cloth";
            var HModName = "ProdProcessSumReport_DyeColor";
            var titleData = ["HCusID"];//不需要显示的字段 å¯æ‰©å±•
            var ins;                        //用于导出excel
            //#endregion
            //#region è¿›å…¥é¡µé¢æ—¢åŠ è½½
@@ -176,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;
@@ -183,8 +204,10 @@
                    case 'HideColumn':
                        get_HideColumn();
                        break;
                    //明细报表
                    case 'btn-detail':
                        get_EntryReport();
                        break;
                };
            });
            //重置按钮
@@ -195,7 +218,61 @@
            form.on('submit(btnSearch)', function (data) {
                get_FastQuery();
            });
            //行监听事件
            table.on('row(mainTable)', function (obj) {
                var flag = !obj.tr.find(':checkbox:first').prop('checked');
                obj.tr.find(':checkbox').prop('checked', flag);
                if (flag) {
                    obj.tr.find('.layui-form-checkbox').addClass('layui-form-checked');  //设置复选框选中样式
                    $(obj.tr.selector).attr({ "style": "background:#ceedfa;color:black" });//改变当前tr背景颜色和字体颜色
                } else {
                    obj.tr.find('.layui-form-checkbox').removeClass('layui-form-checked');//取消复选框选中样式
                    $(obj.tr.selector).attr({ "style": "background:" });//取消当前tr颜色
                }
                //mainTable ä¸ºè¡¨æ ¼ID   æ³¨æ„æ­¤å¤„如果ID不正确将导致你在监听复选框时获取不到你选择的数据,前面的只是添加或删除选中未选中样式以及设置背景色,字体颜色
                layui.each(table.cache.mainTable, function (i, l) {
                    if (obj.tr.index() == l.LAY_TABLE_INDEX) {
                        l.LAY_CHECKED = flag;
                    }
                });
            });
            //行监听事件-双击
            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
@@ -251,6 +328,10 @@
                    com = " and (" + ColName + " " + com + ")";
                }
                //根据用户过滤用户关联客户的记录
                var OtherSearch = getSWhereByHUser();
                sWhere = {
                    HBeginDate: HBeginDate
                    , HEndDate: HEndDate
@@ -259,6 +340,7 @@
                    , HProductName: HProductName
                    , HProductModel: HProductModel
                    , RandomSearch: com
                    , OtherSearch: (OtherSearch == null || OtherSearch == "undefine") ? " and 1=1 " : OtherSearch
                }
                sWhere = JSON.stringify(sWhere);
@@ -267,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 = [];
                            //给空的数组赋值
@@ -281,10 +363,13 @@
                            }
                            //在列表左边添加勾选框
                            col.push({ type: 'radio', fixed: 'left' });
                            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 });
@@ -310,7 +395,7 @@
                                , cols: [col]
                                , data: data1.data
                            };
                            table.render(option);
                            ins = table.render(option);
                        } else {
                            option = {
                                elem: '#mainTable'
@@ -328,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) {
@@ -349,10 +434,10 @@
                })
            }
            //列明显示下拉框
            //列名显示下拉框
            function ColFilter() {
                var Organization = '<option  value="0" selected="selected" ></option>';
                for (var i = 0; i < option.cols[0].length; i++) {
                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>';
                    }
@@ -369,13 +454,14 @@
                $.ajax({
                    url: GetWEBURL() + '/ProdProcessSumReport/ProdProcessSumReport_DyeColor',
                    type: "GET",
                    data: { "sWhere": sWhere },
                    data: { "sWhere": sWhere, "user": sessionStorage["HUserName"]  },
                    success: function (data1) {
                        if (data1.count == 1) {
                            //调整日期格式:显示 å¹´æœˆæ—¥ å’Œ æ—¶
                            for (var i = 0; i < data1.data.length; i++) {
                                data1.data[i].生产订单日期 = data1.data[i]["生产订单日期"].split(":")[0] + ':' + data1.data[i]["生产订单日期"].split(":")[1];
                                data1.data[i].生产订单日期 = data1.data[i]["生产订单日期"].replace("T", " ");
                                if (data1.data[i].生产订单日期!=null) {
                                    data1.data[i].生产订单日期 = data1.data[i]["生产订单日期"].split("T")[0];
                                }
                            }
                            option.data = data1.data;
@@ -391,14 +477,26 @@
                            //        }
                            //    }
                            //}
                            table.render(option);
                            ins = table.render(option);
                            //计算合计公斤数
                            //计算白坯发布合计公斤数
                            var sumHMaterOutQty = 0;
                            for (var i = 0; i < data1.data.length; i++) {
                                sumHMaterOutQty += data1.data[i]["白坯发布"];
                            }
                            $("#SumHMaterOutQty").val(sumHMaterOutQty);
                            //计算染厂出站合计公斤数
                            var sumDyeColorOut = 0;
                            for (var i = 0; i < data1.data.length; i++) {
                                sumDyeColorOut += data1.data[i]["染厂出站"];
                            }
                            $("#SumDyeColorOut").val(sumDyeColorOut);
                            //计算差额
                            var sumCompare = sumHMaterOutQty - sumDyeColorOut;
                            $("#SumCompare").val(sumCompare);
                            layer.close(wait);
                        } else {
@@ -451,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));
@@ -482,11 +585,32 @@
                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() {
                var colName = "";
                for (var i = 1; i < option.cols[0].length - 1; i++) {
                for (var i = 1; i < option.cols[0].length; i++) {
                    colName += option.cols[0][i]["title"] + ",";
                }
@@ -521,11 +645,11 @@
                        if (data1.data.length != 0) {
                            var dataCol = [];//数据库查询出的列数据
                            var titleData = [];//不需要显示的字段 å¯æ‰©å±•
                            /*var titleData = [];//不需要显示的字段 å¯æ‰©å±•*/
                            dataCol = data1.data[0].HGridString.split(',');
                            for (var i = 0; i < option.cols[0].length - 2; i++) {
                            for (var i = 0; i < option.cols[0].length - 1; i++) {
                                if (dataCol[i]) {
                                    var dataCols = dataCol[i].split('|');
                                }
@@ -589,6 +713,7 @@
                })
            }
            //明细报表
            function get_EntryReport() {
                var checkStatus = table.checkStatus('mainTable')
                    , data = checkStatus.data;
@@ -618,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>