WebTM/views/¼Æ»®¹ÜÀí/¹¤ÒÕ·Ïß/Gy_RoutingBillList.html
@@ -61,7 +61,7 @@
                                        <label class="layui-form-label" style="width: 85px;padding: 9px 18px;">物料代码</label>
                                        <div class="layui-input-block">
                                            <input type="hidden" class="layui-input " lay-verify="HMaterID" name="HMaterID" id="HMaterID" value="0" style="background-color:#efefef4d;width: 60%;display: inline-block;" readonly>
                                            <input type="text" class="layui-input ForFilteringSchemes" lay-verify="HMaterNumber" name="HMaterNumber" id="HMaterNumber" value="" style="background-color:#efefef4d;width: 60%;display: inline-block;">
                                            <input type="text" class="layui-input ForFilteringSchemes" lay-verify="HMaterNumber" name="HMaterNumber" id="HMaterNumber" value="" style="background-color:#efefef4d;width: 75%;display: inline-block;">
                                            <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnHMaterID" id="btnHMaterID" style="padding: 0 10px;float: right;margin-right: 3px;">
                                                <i class="layui-icon layui-icon-search layuiadmin-button-btn"></i>
                                            </button>
@@ -78,6 +78,12 @@
                                        <label class="layui-form-label" style="width: 85px;">规格型号</label>
                                        <div class="layui-input-block" style="margin-left: 120px;">
                                            <input type="text" class="layui-input ForFilteringSchemes" name="HModel" id="HModel">
                                        </div>
                                    </div>
                                    <div class="layui-inline">
                                        <label class="layui-form-label" style="width: 85px;">基准值</label>
                                        <div class="layui-input-block" style="margin-left: 120px;">
                                            <input type="text" class="layui-input ForFilteringSchemes" name="HBenchmarkValue" id="HBenchmarkValue">
                                        </div>
                                    </div>
                                </div>
@@ -98,10 +104,10 @@
                                            </select>
                                        </div>
                                    </div>
                                    <button class="layui-btn layuiadmin-btn-order" style="display:none;" type="button" lay-submit="" lay-filter="btnSearch" id="btnSearch">
                                    <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>
                                    <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnReSearch" id="btnReSearch" style="padding: 0 5px; display: none;">重置</button>
                                    <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnReSearch" id="btnReSearch" style="padding: 0 5px;">重置</button>
                                </div>
                                <!--显示当前过滤方案-->
                                <div class="layui-inline" style="margin-left:5px;">
@@ -136,7 +142,7 @@
                                            <input type="text" class="layui-input ForFilteringSchemes" value="" name="ColContent" id="ColContent">
                                        </div>
                                    </div>
                                    <div class="layui-row" style=" margin-top: 10px; margin-left: 70px;">
                                    <div class="layui-row" style=" margin-top: 10px; ">
                                        <div class="layui-inline">
                                            <label class="layui-form-label">过滤</label>
                                            <div class="layui-input-block">
@@ -164,7 +170,7 @@
                                        </div>
                                    </div>
                                    <div class="layui-row" style=" margin-top: 10px; margin-left: 70px;">
                                    <div class="layui-row" style=" margin-top: 10px;">
                                        <div class="layui-inline">
                                            <label class="layui-form-label">过滤</label>
                                            <div class="layui-input-block">
@@ -199,6 +205,7 @@
                        <script type="text/html" id="toolbarDemo">
                            <div class="layui-btn-container" id="toolbarDemo_ButtonSet">
                                <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="set_Excel"><i class="layui-icon layui-icon-delete"></i>Excel导入</button>
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="set_Copy" id="set_Copy"><i class="layui-icon layui-icon-form"></i>复制</button>
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="set_AddNew" id="set_AddNew"><i class="layui-icon layui-icon-file-b"></i>新增</button>
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="set_AddNewSub" id="set_AddNewSub"><i class="layui-icon layui-icon-file-b"></i>新增子路线</button>
@@ -216,6 +223,7 @@
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="set_WithdrawCheck_Flow" id="WithdrawCheck_Flow"><i class="layui-icon layui-icon-form"></i>撤回</button>
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="set_CloseBill" id="set_CloseBill"><i class="layui-icon layui-icon-form"></i>关闭</button>
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="set_CancelCloseBill" id="set_CancelCloseBill"><i class="layui-icon layui-icon-form"></i>反关闭</button>
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="set_CancelCloseBillSetDate" id="set_CancelCloseBillSetDate"><i class="layui-icon layui-icon-form"></i>反关闭(设置时间)</button>
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-Drop" id="btn-Drop"><i class="layui-icon layui-icon-radio"></i>作废</button>
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-DeDrop" id="btn-DeDrop"><i class="layui-icon layui-icon-radio"></i>反作废</button>
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-ProcPriceRequestBills" id="btn-ProcPriceRequestBills"><i class="layui-icon layui-icon-delete"></i>多行下推(定额申请单)</button>
@@ -371,6 +379,9 @@
                    //反关闭
                    case 'set_CancelCloseBill': set_CloseBill(2);
                        break;
                    //反关闭设置时间
                    case 'set_CancelCloseBillSetDate': set_CloseBillSetDate(2);
                        break;
                    //作废按钮        ï¼ˆ1:作废、2:反作废)
                    case 'btn-Drop':set_DropBill(1);
                        break;
@@ -383,6 +394,9 @@
                    //导出excel
                    case 'get_export':
                        get_Export();
                        break;
                    //导入
                    case 'set_Excel': set_Excel();
                        break;
                    //列设置
                    case 'set_HideColumn': get_HideColumnNoPage(HModName, sessionStorage["HUserName"], option, get_FastQuery);
@@ -439,6 +453,7 @@
                //获取登录页组织列
                $.ajax({
                    type: "get",
                    async: false,
                    url: GetWEBURL() + "/Web/GetOrganizations",
                    success: function (result) {
                        var Organization = "";
@@ -496,13 +511,18 @@
                $("#HEndDate").val(Format(new Date(), "yyyy-MM-dd"));
                //初始化表格
                set_InitGrid();
                Organ();
                //查询
                //get_FastQuery(1);
                //获取项目号
                Get_HProject();
                //查询
                get_FastQuery(1);
                //查询当前登录用户有没有在当前模块设置默认过滤方案
                get_DefaultModule();
                $("#HBenchmarkValue").val(localStorage["HBenchmarkValue"])
            }
            //#endregion
@@ -511,6 +531,7 @@
                    elem: '#mainTable'
                    , toolbar: '#toolbarDemo'
                    , height: 'full-150'
                    , title: '工艺路线'
                    , page: false
                    , limit: 50
                    , done: function (res, curr, count) {
@@ -824,7 +845,7 @@
                                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].name == '单据号') {
                                    col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: true, width: 200, event: '单据号' });
                                    col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: true, width: 200, event: '单据号'});
                                } else {
                                    switch (data[i].Type) {
                                        //int
@@ -879,7 +900,7 @@
                            option.data = result;
                            //刷新表格数据
                            DisPlay_HideColumn(HModName, sessionStorage["HUserName"], option, titleData)
                           table.render(option);
                            table.render(option);
                            //刷新按钮显示
                            Display_HideButton(set_HideButton_ID, HBillType, HModName, sessionStorage["HUserName"]);
@@ -1006,12 +1027,12 @@
                if (HProID != 0 && HProID != "undefined" && HProID != null) {
                    sWhere += " and HMainProcID = " + HProID;
                }
                if (number == 1) {
                    HOrgID = sessionStorage["OrganizationID"];
                }
                else {
                    HOrgID = $("#HOrgID").val();//组织
                }
                //if (number == 1) {
                //    HOrgID = sessionStorage["OrganizationID"];
                //}
                //else {
                //    HOrgID = $("#HOrgID").val();//组织
                //}
                if (HOrderProcNO) {
                    sWhere += " and å•据类型 like ''%" + HOrderProcNO + "%''";
@@ -1029,9 +1050,9 @@
                if (WorkCenter) {
                    sWhere += " and å•据号 like ''%" + WorkCenter + "%''";
                }
                if (HOrgID) {
                    sWhere += " and HOrgID = ''" + HOrgID + "''";
                }
                //if (HOrgID) {
                //    sWhere += " and HOrgID = ''" + HOrgID + "''";
                //}
                if (number == 2) {
                    if (HProject != '0') {
                        sWhere += " and é¡¹ç›®å· like ''%" + HProject + "%''";
@@ -1039,6 +1060,9 @@
                }
                sWhere += " and å·¥åºä»£ç  != ''9999'' and HBillSubType<>''SUB''"
                sWhere += getOrgIDByUser();//用户关联组织查询过滤
                //判断权限
                if (PermissionJudge() == true) {
                    get_DisplayPage(sWhere);
@@ -1054,6 +1078,7 @@
                $.ajax({
                    url: GetWEBURL() + '/Gy_RoutingBill/page',
                    type: "GET",
                    async: false,
                    data: { "sWhere": sWhere, "user": sessionStorage["HUserName"], "page": page, "size": size },
                    success: function (data1) {
                        option.limit = size;//改变表格页大小
@@ -1072,7 +1097,7 @@
                                if ($.inArray(data[i].name, titleData) > -1) {//检查data【i】.name是否在数组中  //计算列
                                    col.push({ field: data[i].id, title: data[i].name, align: 'center', hide: true }); //隐藏id列
                                } else if (data[i].name == '单据号') {
                                    col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: true, width: 200, event: '单据号' });
                                    col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: true, width: 200, event: '单据号', style:"color:blue; cursor: pointer;" });
                                } else {
                                    switch (data[i].Type) {
                                        //int
@@ -1110,21 +1135,21 @@
                                }
                            }
                            option.data = result;
                            debugger
                            //刷新表格数据
                            DisPlay_HideColumn(HModName, sessionStorage["HUserName"], option, titleData)
                            laypage.render(optionPage);
                            table.render(option);
                            debugger
                            ins = table.render(option);
                            //刷新按钮显示
                            Display_HideButton(set_HideButton_ID, HBillType, HModName, sessionStorage["HUserName"]);
                            layer.close(ajaxLoad);
                            layer.close(ajaxLoad);
                            if ($("#ColName option").length < 1) {
                                ColFilter();
                            }
                            layer.close(ajaxLoad);
                           
                        } else {
                            //option.data = [[]]
@@ -1267,6 +1292,31 @@
                        layer.closeAll("loading");
                    }
                })
            }
            //#endregion
            //#region æ ¹æ®ç”¨æˆ·èŽ·å–ç”¨æˆ·å…³è”ç»„ç»‡çš„è¿‡æ»¤æ¡ä»¶
            function getOrgIDByUser() {
                var res = "";
                $.ajax({
                    type: "GET",
                    async: false,
                    url: GetWEBURL() + "/Xt_User/getOrgIDListByUser", //方法所在页面和方法名       ä¼ å‚ ç»„织必须是列表头部查询的组织  ä¸èƒ½ä½¿ç”¨ç”¨æˆ·é»˜è®¤
                    data: { "UserID": sessionStorage["Czybm"], "UserName": sessionStorage["HUserName"], HOrgID: $("#HOrgID").val() },
                    success: function (result) {
                        if (result.count == 1) {
                            if (result.data[0].sWhere == "1") {
                                res = " and HOrgID = ''" + $("#HOrgID").val() + "''";
                            } else {
                                res = result.data[0].sWhere;
                            }
                        }
                    }, error: function (err) {
                        res = " and 1 = 0";
                        layer.alert("接口请求失败!", { icon: 5 });
                    }
                });
                return res;
            }
            //#endregion
@@ -1556,6 +1606,103 @@
                }
            }
            //关闭  [1 å…³é—­ã€2 åå…³é—­]
            function set_CloseBillSetDate(num) {
                var checkStatus = table.checkStatus('mainTable')
                    , data = checkStatus.data;
                var HInterID = data[0].hmainid;
                if (data.length == 1) {
                    // å¼¹å‡ºå±‚
                    layer.open({
                        type: 1,
                        title: '设置时间范围',
                        area: ['500px', '300px'],
                        content: `
                        <div class="layui-form" style="padding: 20px;">
                            <div class="layui-form-item">
                            <label class="layui-form-label">开始时间</label>
                            <div class="layui-input-block">
                                <input type="date" class="layui-input" id="startTime" placeholder="请选择开始时间">
                            </div>
                            </div>
                            <div class="layui-form-item">
                            <label class="layui-form-label">结束时间</label>
                            <div class="layui-input-block">
                                <input type="date" class="layui-input" id="endTime" placeholder="请选择结束时间">
                            </div>
                            </div>
                            <div class="layui-form-item">
                            <div class="layui-input-block" style="margin-left: 0; text-align: center;">
                                <button class="layui-btn" id="confirmTime">确定</button>
                                <button class="layui-btn layui-btn-primary" id="cancelTime">取消</button>
                            </div>
                            </div>
                        </div> `,
                        success: function (layero, index) {
                            $("#startTime").val(Format(new Date(), "yyyy-MM-dd"));
                            // èŽ·å–å½“å‰æ—¥æœŸ
                            const currentDate = new Date();
                            // åˆ›å»ºæ–°æ—¥æœŸå¯¹è±¡ï¼ˆé¿å…ä¿®æ”¹åŽŸæ—¥æœŸï¼‰
                            const after30Days = new Date(currentDate);
                            // è®¾ç½®æ—¥æœŸä¸ºå½“前日期 + 30天
                            after30Days.setDate(currentDate.getDate() + 30);
                            $("#endTime").val(Format(after30Days, "yyyy-MM-dd"));
                            // ç¡®å®šæŒ‰é’®ç‚¹å‡»äº‹ä»¶
                            $('#confirmTime').on('click', function () {
                                var startTime = $('#startTime').val();
                                var endTime = $('#endTime').val();
                                if (!startTime) {
                                    layer.msg('请选择开始时间', { icon: 2 });
                                    return;
                                }
                                if (!endTime) {
                                    layer.msg('请选择结束时间', { icon: 2 });
                                    return;
                                }
                                if (new Date(endTime) < new Date(startTime)) {
                                    layer.msg('结束时间不能早于开始时间', { icon: 2 });
                                    return;
                                }
                                $.ajax({
                                    url: GetWEBURL() + '/Gy_RoutingBill/CloseSetDate',
                                    type: "GET",
                                    data: { "HInterID": HInterID, "Type": num, "user": sessionStorage["HUserName"], "HBillSubType": "", "HBeginDate": startTime, "HEndDate": endTime},
                                    success: function (result) {
                                        if (result.count == 1) {
                                            // è¿™é‡Œå¯ä»¥å¤„理获取到的时间范围
                                            layer.msg('时间范围已设置:' + startTime + ' è‡³ ' + endTime, { icon: 1 });
                                            // å…³é—­å¼¹å±‚
                                            layer.close(index);
                                            $("#btnSearch").trigger('click');
                                        } else {
                                            layer.alert(result.code + result.Message, { icon: 5 });
                                            // å…³é—­å¼¹å±‚
                                            layer.close(index);
                                        }
                                    }, error: function () {
                                        layer.alert("接口请求失败!", { icon: 5 });
                                        // å…³é—­å¼¹å±‚
                                        layer.close(index);
                                    }
                                });
                            });
                            // å–消按钮点击事件
                            $('#cancelTime').on('click', function () {
                                layer.close(index);
                            });
                        },
                    })
                }
                else {
                    layer.msg("请选择一条数据!");
                }
            }
            //#region åä½œåºŸ/作废数据 [1 ä½œåºŸã€2 åä½œåºŸ]
            function set_DropBill(num) {
                var checkStatus = table.checkStatus('mainTable')
@@ -1612,11 +1759,21 @@
                                }
                                if (item[itemobj].length > 0) {  // å‡è®¾å­—段名为field
                                    item[itemobj] = item[itemobj].toString().replace(/[\r\n]+/g, '');  // å°†æ¢è¡Œç¬¦æ›¿æ¢ä¸ºç©ºå­—符串
                                    item[itemobj] = item[itemobj].toString().replace(/,/g, '');  // å°†æ¢è¡Œç¬¦æ›¿æ¢ä¸ºç©ºå­—符串
                                }
                                if (itemobj === '物料代码') {
                                    item[itemobj] = item[itemobj].replace(/,/g, ',');  // æ›¿æ¢è‹±æ–‡é€—号为中文逗号
                                }
                                if (itemobj === '物料名称') {
                                    item[itemobj] = item[itemobj].replace(/,/g, ',');  // æ›¿æ¢è‹±æ–‡é€—号为中文逗号
                                }
                                if (itemobj === '规格型号') {
                                    item[itemobj] = item[itemobj].replace(/,/g, ',');  // æ›¿æ¢è‹±æ–‡é€—号为中文逗号
                                }
                            }
                        });
                        if (result.count == 1) {
                            table.exportFile(ins.config.id, data, "xls");
                            table.exportFile('mainTable', data, "xls");
                            layer.close(wait);
                        } else {
                            layer.alert("当前模块没有导出权限!", { icon: 5 });
@@ -1629,6 +1786,22 @@
                });
            }
            //#endregion
            //导入
            function set_Excel() {
                layer.open({
                    type: 2
                    , skin: 'layui-layer-rim' //加上边框
                    , area: ['100%', '100%']
                    , title: '工艺路线列表-导入'
                    , shift: 0//弹出动画
                    , content: '../工艺路线/Gy_RoutingBillimport.html'
                    , end: function () {
                        //刷新页面,
                        get_FastQuery();
                    }
                })
            }
            //#region èŽ·å–å¯¼å‡ºæ•°æ®
            function getExportData() {
@@ -2033,6 +2206,10 @@
            }
            //#endregion
            $("#HBenchmarkValue").on("input", function (e) {
                localStorage["HBenchmarkValue"] = e.delegateTarget.value;//基准值,用于添康计算约当系数:基准值/小时产能
            });
            //#endregion
            ////隐藏列设置
            //function get_HideColumn() {
@@ -2339,7 +2516,7 @@
                            //隐藏显示过滤方案的标签信息
                            document.getElementById("HFilterScheme_Now").style.display = "none";
                            //执行查询方法
                            get_FastQuery()
                            //get_FastQuery()
                            form.render("select");
                        }
                    }, error: function () {