三升排产发货计划平台，要料报表日计划生成

wtt

2025-06-12 7e57544235ff368d30802f3cfe2ee7d7103ea688

三升排产发货计划平台，要料报表日计划生成

 WebTM/views/»ù´¡×ÊÁÏ/¹«Óûù´¡×ÊÁÏ/Gy_DepartmentList.html

@@ -1229,7 +1229,7 @@

                let addSWhere = "";

                if (openType != "undefined") {
                if (typeof(openType) != "undefined") {
                    if (openType == 1 && HOrgName != "undefined") {
                        /*addSWhere = " and ç¦ç”¨æ ‡è®° = '' å®¡æ ¸äºº !='' and è½¦é—´æ ‡è®° = 'Y' " ;*/
                        addSWhere = " and ç¦ç”¨æ ‡è®° = ' ' and è½¦é—´æ ‡è®° = 'Y' ";

 WebTM/views/Éú²ú¹ÜÀí/ÈýÉýÅŲú/JIT_DayPlanPlatForm.html

@@ -1107,9 +1107,10 @@

            $("#HArrangeProductDayQty").empty();
            $("#HArrangeProductDayQty").append(HArrangeProductDayQty_ArrayList);
            form.render('select');
            

            $("#HArrangeProductDayQty").val("40");
            form.render('select');
        }
        //#endregion

@@ -1842,6 +1843,8 @@
                    //})
                }
            }

            table.render(option);
        }

        //缺料分析表格数据
@@ -3805,7 +3808,7 @@
                    if (parseFloat(table.cache["mainTable"][i]["拆单数量"]) == 0) {
                        return layer.msg("第" + (i + 1) + "行,拆产数量有误,请重新输入!");
                    }
                    if (parseFloat(table.cache["mainTable"][i]["拆单数量"]) - parseFloat(table.cache["mainTable"][i]["拆单汇报数量"]) < parseFloat(table.cache["mainTable"][i]["日计划数量总量"])) { // - å·²æ±‡æŠ¥æ•°é‡
                    if (parseFloat(table.cache["mainTable"][i]["拆单数量"]) - parseFloat(table.cache["mainTable"][i]["拆单汇报数量"]) > parseFloat(table.cache["mainTable"][i]["计划数量"])) { // - å·²æ±‡æŠ¥æ•°é‡
                        return layer.msg("第" + (i + 1) + "行,排产数量超出订单数量!");
                    }
                    table.cache["mainTable"][i].LAY_TABLE_INDEX = i;

 WebTM/views/Éú²ú¹ÜÀí/·¢»õ¼Æ»®Æ½Ì¨£¨ÈýÉý£©/Xs_SendGoodsPlanForm.html

@@ -505,7 +505,7 @@

        //快速过滤
        function get_FastQuery() {
            sWhere = "select * from h_v_Xs_SendGoodsPlanBillList where 1=1 and (采购订单关闭状态='A' or é‡‡è´­è®¢å•å…³é—­çŠ¶æ€ is null) and é”€å”®è®¢å•å…³é—­çŠ¶æ€='A'"
            sWhere = "select * from h_v_Xs_SendGoodsPlanBillList where 1=1 and  é”€å”®è®¢å•å…³é—­çŠ¶æ€='A'"
            get_Display(sWhere);
            sWhere = ""//调用接口后清空sWhere缓存
        }
@@ -528,7 +528,7 @@
                success: function (data1) {
                    if (data1.count == 1) {
                        get_FastQuery(2);
                        layer.msg(data1.data[0]["Column1"]);
                        layer.msg(data1.data[0]["HRemark"]);
                        layer.close(ajaxLoad);
                    } else {
                        layer.alert(data1.code + data1.Message, { icon: 5 });

 WebTM/views/Éú²ú¹ÜÀí/Èռƻ®±¨±í/ReportWorkDemandPlanBillList.html

@@ -49,6 +49,7 @@
                                </div>
                                <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnSearch" id="btnSearch">查询</button>
                                <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnReSearch" id="btnReSearch">重置</button>
                                <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnGetWorkBill" id="btnGetWorkBill">生成排产计划</button>
                                <div class="layui-colla-content" style="padding: 0px; margin-left: 6%;">
                                    <div class="layui-row" style="margin: 10px 0 10px;">
                                        <div class="layui-inline">
@@ -235,6 +236,13 @@
            btnHDeptID();
        });
        //#endregion

        //#region ç”Ÿäº§è½¦é—´
        form.on('submit(btnGetWorkBill)', function (data) {
            btnGetWorkBill();
        });
        //#endregion


        //#region é‡ç½®æŒ‰é’®
        form.on('submit(btnReSearch)', function (data) {
@@ -529,6 +537,33 @@
        }
        //#endregion

        //#region è¦æ–™è®¡åˆ’生成排产计划
        function btnGetWorkBill() {
            var ajaxLoad = layer.load();
            var sql = "exec h_p_JIT_WorkBillSortBill_WorkDemandPlan_sansheng " + $("#HDeptID").val()+",'" +sessionStorage["HUserName"] + "','" + sessionStorage["OrganizationID"] + "'";
            $.ajax({
                url: GetWEBURL() + '/CommonModel/searchMethod',
                type: "GET",
                async: false,
                data: { "sql": sql, "user": sessionStorage["HUserName"], "ModRightNameCheck": "" },
                success: function (data1) {
                    if (data1.count == 1) {
                        get_FastQuery(2);
                        layer.msg(data1.data[0]["Column1"]);
                        layer.close(ajaxLoad);
                    } else {
                        layer.alert(data1.code + data1.Message, { icon: 5 });
                        layer.close(ajaxLoad);
                    }
                }, error: function () {
                    layer.alert("接口请求失败!", { icon: 5 });
                    layer.close(ajaxLoad);
                }
            });
        }
        //#endregion


        //物料列表
        function btnHMATERIALID() {
            layer.open({