wtt
2025-05-30 39ccb62553e7dea3f3960ce887bef62cf54079b2
WebTM/views/PublicPage/HSourceReportHtml.html
@@ -95,7 +95,7 @@
                                                </select>
                                            </div>
                                        </div>
                                        <div class="layui-inline">
                                        <div class="layui-inline" id="ICMOFilter_SPickMtrlStatus">
                                            <label class="layui-form-label">领料状态</label>
                                            <div class="layui-input-block">
                                                <select name="HPickMtrlStatus" id="HSPickMtrlStatus" lay-verify="" lay-search class="layui-input ForFilteringSchemes">
@@ -107,33 +107,47 @@
                                                </select>
                                            </div>
                                        </div>
                                        <div class="layui-inline">
                                            <label class="layui-form-label">过滤</label>
                                            <div class="layui-input-block">
                                                <select name="ColName" id="ColName" lay-filter="ColName" class="ForFilteringSchemes" style="width:190px;">
                                                </select>
                                        <div class="layui-row" style="margin-top:5px;margin-left:40px;">
                                            <div class="layui-inline" id="ICMOFilter_IsScheduling">
                                                <label class="layui-form-label">是否排产</label>
                                                <div class="layui-input-block">
                                                    <select name="HIsScheduling" id="HIsScheduling" lay-verify="" lay-search class="layui-input ForFilteringSchemes">
                                                        <option value="">请选择</option>
                                                        <option value="已排产" selected>已排产</option>
                                                        <option value="未排产">未排产</option>
                                                    </select>
                                                </div>
                                            </div>
                                        </div>
                                        <div class="layui-inline">
                                            <select name="Comparator" id="Comparator" lay-filter="Comparator" class="ForFilteringSchemes" style="width:190px;">
                                                <option value="0" selected="selected"></option>
                                                <option value="=">=</option>
                                                <option value=">=">>=</option>
                                                <option value=">">></option>
                                                <option value="<="><=</option>
                                                <option value="<"><</option>
                                                <option value="<>"><></option>
                                                <option value="7">包含</option>
                                                <option value="8">左包含</option>
                                                <option value="9">右包含</option>
                                                <option value="10">不包含</option>
                                            </select>
                                        </div>
                                        <div class="layui-inline">
                                            <input type="text" class="layui-input ForFilteringSchemes" value="" name="ColContent" id="ColContent">
                                        <div class="layui-row" style="margin-top:5px;margin-left:40px;">
                                            <div class="layui-inline">
                                                <label class="layui-form-label">过滤</label>
                                                <div class="layui-input-block">
                                                    <select name="ColName" id="ColName" lay-filter="ColName" class="ForFilteringSchemes" style="width:190px;">
                                                    </select>
                                                </div>
                                            </div>
                                            <div class="layui-inline">
                                                <select name="Comparator" id="Comparator" lay-filter="Comparator" class="ForFilteringSchemes" style="width:190px;">
                                                    <option value="0" selected="selected"></option>
                                                    <option value="=">=</option>
                                                    <option value=">=">>=</option>
                                                    <option value=">">></option>
                                                    <option value="<="><=</option>
                                                    <option value="<"><</option>
                                                    <option value="<>"><></option>
                                                    <option value="7">包含</option>
                                                    <option value="8">左包含</option>
                                                    <option value="9">右包含</option>
                                                    <option value="10">不包含</option>
                                                </select>
                                            </div>
                                            <div class="layui-inline">
                                                <input type="text" class="layui-input ForFilteringSchemes" value="" name="ColContent" id="ColContent">
                                            </div>
                                        </div>
                                    </div>
                                </div>
                                    </div>
                            </div>
                        </div>
                        <table class="" id="layTable" lay-filter="layTable"></table>
@@ -214,6 +228,14 @@
            //#endregion
            //隐藏过滤字段
            if (HSouceBillType != "生产订单") {
                document.getElementById("ICMOFilter_SPickMtrlStatus").style.display = "none";
                document.getElementById("ICMOFilter_IsScheduling").style.display = "none";
                document.getElementById("ICMOFilter_SPickMtrlStatus").style.visibility = 'hidden';
                document.getElementById("ICMOFilter_IsScheduling").style.visibility = 'hidden';
            }
            //#region 进入页面即加载
            //初始化表单插件
            //set_InitFrom();
@@ -247,14 +269,14 @@
            }
            else if (OperationType == 3) {//有源单
                //get_FastQuery(HSouceBillType);
                set_ClearBill(sWhere, HSouceBillType);
                //查询当前登录用户有没有在当前模块设置默认过滤方案
                get_DefaultModule();
                set_ClearBill(sWhere, HSouceBillType);
            }
            else {
                layer.alert("未知操作类型!", { icon: 5 });
            }
            //#endregion
            //#region 触发事件:包括form.on(){}格式的所有点击事件、选择事件等
@@ -370,6 +392,12 @@
                    case '工序流转卡':
                        HModName = "ProcessExchangeBill_3772";
                        break;
                    case '销售出库单':
                        HModName = "SellOutBill_1205";
                        break;
                    case '领料出库单':
                        HModName = "MateOutBill_1204";
                        break;
                }
                //初始查询
                get_Display(sWhere, HSouceBillType);
@@ -440,8 +468,8 @@
                    , page: true   //开启分页
                    , totalRow: false //开启合计
                    , cellMinWidth: 120
                    , height: 520
                    , limit: 50     //一页能够显示的最大数目
                    , height: 'full-50'
                    , limit: 500     //一页能够显示的最大数目
                    , limits: [50, 500, 5000, 20000]
                    , method: 'get'  //提交方式
                    , layout: ['count', 'prev', 'page', 'next', 'limit', 'skip']
@@ -507,9 +535,16 @@
                        if ($("#HBillStatus").val() != "") {
                            sWhere += " and 状态 = '" + $("#HBillStatus").val() + "'";
                        }
                        if ($("#HSPickMtrlStatus").val() != "") {
                            sWhere += " and 领料状态 = '" + $("#HSPickMtrlStatus").val() + "'";
                        //判断客户
                        if (sessionStorage["Organization"] == "九菱电机") {
                            if ($("#HSPickMtrlStatus").val() != "") {
                                sWhere += " and 领料状态 = '" + $("#HSPickMtrlStatus").val() + "'";
                            }
                            if ($("#HIsScheduling").val() != "") {
                                sWhere += $("#HIsScheduling").val() == "未排产" ? "and 是否排产 = ''" : " and 是否排产 = '" + $("#HIsScheduling").val() + "'";
                            }
                        }
                        return sWhere;
                        break;
                    case '生产汇报单':
@@ -585,7 +620,7 @@
                        if (HDeptName && HDeptName != 0) {
                            sWhere += " and HDeptID = '" + HDeptName + "'";
                        }
                        if (HProcExchBillNo!="") {
                        if (HProcExchBillNo != "") {
                            sWhere += " and 流转卡号 like '" + HProcExchBillNo + "%'";
                        }
                        return sWhere;
@@ -608,6 +643,36 @@
                    case '组装拆卸单':
                        return sWhere;
                    case '工序流转卡':
                        if (HBillNo) {
                            sWhere += " and 单据号 like '%" + HBillNo + "%'";
                        }
                        if (PartNumber) {
                            sWhere += " and 物料代码 like '%" + PartNumber + "%'";
                        }
                        if (PartName) {
                            sWhere += " and 物料名称 like '%" + PartName + "%'";
                        }
                        if (HDeptName && HDeptName != 0) {
                            sWhere += " and HDeptID = '" + HDeptName + "'";
                        }
                        return sWhere;
                        break;
                    case "销售出库单":
                        if (HBillNo) {
                            sWhere += " and 单据号 like '%" + HBillNo + "%'";
                        }
                        if (PartNumber) {
                            sWhere += " and 物料代码 like '%" + PartNumber + "%'";
                        }
                        if (PartName) {
                            sWhere += " and 物料名称 like '%" + PartName + "%'";
                        }
                        if (HDeptName && HDeptName != 0) {
                            sWhere += " and HDeptID = '" + HDeptName + "'";
                        }
                        return sWhere;
                        break;
                    case "领料出库单":
                        if (HBillNo) {
                            sWhere += " and 单据号 like '%" + HBillNo + "%'";
                        }
@@ -840,7 +905,8 @@
                            //执行查询方法
                            get_FastQuery(HSouceBillType);
                            //get_FastQuery(HSouceBillType);
                            set_ClearBill(sWhere, HSouceBillType);
                            form.render("select");
                        } else {
                            //当前用户没有设置默认的过滤方案
@@ -848,6 +914,7 @@
                            document.getElementById("HFilterScheme_Now").style.display = "none";
                            //执行查询方法
                            get_FastQuery(HSouceBillType);
                            set_ClearBill(sWhere, HSouceBillType);
                            form.render("select");
                        }
                    }, error: function () {
@@ -1059,7 +1126,7 @@
                }
            });
        }
        //#endregion
                        //#endregion
    </script>