排产生产订单过滤

wtt

2025-02-11 1307fd059f3b5195896bec957c6e96016ee57bd4

排产生产订单过滤

 WebTM/views/Éú²ú¹ÜÀí/±¦¹¤ÅŲú/JIT_DayPlanPlatForm.html

@@ -264,12 +264,12 @@
                                            <input type="date" class="layui-input" id="HEndDate" style="width:120px;">
                                        </div>
                                    </div>
                                    <div class="layui-inline">
                                    <!--<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" name="HDeptName_ICMO" id="HDeptName_ICMO">
                                        </div>
                                    </div>
                                    </div>-->
                                    <div class="layui-inline">
                                        <label class="layui-form-label" style="width: 85px;">物料名称</label>
                                        <div class="layui-input-block" style="margin-left: 120px;">
@@ -874,7 +874,7 @@
            get_FastQuery(1);
            //隐藏勾选字段
            DisPlay_HideColumn();
            get_Display2(sWhere_ICMO);
            get_FastQuery_ICMO();
        }
        //#region åˆå§‹åŒ–下拉列表 æŽ’产时间
        function setSelect_HArrangeProductDayQty() {
@@ -1693,7 +1693,7 @@
        function get_FastQuery_ICMO(number) {
            var HDate = $("#HBeginDate").val();//开始日期
            var HDate1 = $("#HEndDate").val();//结束日期
            var HDeptName_ICMO = $("#HDeptName_ICMO").val();//生产车间
            var HDeptName_ICMO = $("#HWorkShopIDName").val();//生产车间
            var HMaterName_ICMO = $("#HMaterName_ICMO").val();//物料名称
            var HICMOBillNo_ICMO = $("#HICMOBillNo_ICMO").val(); //生产订单

@@ -1704,7 +1704,7 @@
                sWhere_ICMO += " and CONVERT(varchar(100),日期, 23) <= '" + HDate1 + "'";
            }
            if (HDeptName_ICMO) {
                sWhere_ICMO += " and ç”Ÿäº§è½¦é—´ like '%" + HDeptName_ICMO + "%'";
                sWhere_ICMO += " and ç”Ÿäº§è½¦é—´ = '" + HDeptName_ICMO + "'";
            }
            if (HMaterName_ICMO) {
                sWhere_ICMO += " and concat(产品代码,产品名称,规格型号) like '%" + HMaterName_ICMO + "%'";
@@ -1771,7 +1771,7 @@
            //$("#HPlanBeginDate").val(Format(new Date(new Date() - 1000 * 60 * 60 * 24 * 30), "yyyy-MM-dd"));//开工起始日期
            //$("#HPlanEndDate").val(Format(new Date(), "yyyy-MM-dd"));//开工截止日期

            $("#HDeptName_ICMO").val("");//生产车间
            //$("#HDeptName_ICMO").val("");//生产车间
            $("#HMaterName_ICMO").val("");//物料名称
            $("#HICMOBillNo_ICMO").val(""); //生产订单

@@ -1851,7 +1851,7 @@
                , area: ['90%', '90%']//大小
                , title: '生产订单列表'//标题
                , shift: 2//弹出动画
                , content: ['../../生产管理/生产任务单/Sc_ICMOBillList.html?HDeptID=' + HDeptID, 'yes']
                , content: ['../../生产管理/生产任务单/Sc_ICMOBillList.html?Type=2&HDeptID=' + HDeptID, 'yes']
                , btn: ['确定', '取消']
                , btn1: function (index, layero) {//按钮【按钮一】的回调
                    var iframeWindow = window['layui-layer-iframe' + index]  //获取弹框页面

 WebTM/views/Éú²ú¹ÜÀí/Éú²úÈÎÎñµ¥/Sc_ICMOBillList.html

@@ -2770,12 +2770,15 @@
                //获取参数
                var params = getUrlVars();
                var openType = params[params[0]]; //从参数中获取 æ‰“开方式  1直接打开 2其它页面通过选择按钮打开
                var HOrgID = params[params[1]];

                var HSecondID = decodeURI(params[params[1]]);//自定义传入参数
                
                var addSWhere = "";

                //排产用HDept过滤部门
                if (params[1] == "HDeptID") {
                    addSWhere += " and HDeptID = " + HSecondID + " and æ˜¯å¦æŽ’产 = ''";
                }
                if (openType == 2) {
                    addSWhere = " and çŠ¶æ€ = '已审核' and è¡ŒçŠ¶æ€ = '' and HOrgID = " + HOrgID;
                    addSWhere += " and å•æ®çŠ¶æ€ = '已审核' and è¡ŒçŠ¶æ€ = '' ";
                }
                return addSWhere;
            }