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(){}格式的所有点击事件、选择事件等
@@ -440,8 +462,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 +529,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 +614,7 @@
                        if (HDeptName && HDeptName != 0) {
                            sWhere += " and HDeptID = '" + HDeptName + "'";
                        }
                        if (HProcExchBillNo!="") {
                        if (HProcExchBillNo != "") {
                            sWhere += " and 流转卡号 like '" + HProcExchBillNo + "%'";
                        }
                        return sWhere;
@@ -840,7 +869,8 @@
                            //执行查询方法
                            get_FastQuery(HSouceBillType);
                            //get_FastQuery(HSouceBillType);
                            set_ClearBill(sWhere, HSouceBillType);
                            form.render("select");
                        } else {
                            //当前用户没有设置默认的过滤方案
@@ -848,6 +878,7 @@
                            document.getElementById("HFilterScheme_Now").style.display = "none";
                            //执行查询方法
                            get_FastQuery(HSouceBillType);
                            set_ClearBill(sWhere, HSouceBillType);
                            form.render("select");
                        }
                    }, error: function () {
@@ -1059,7 +1090,7 @@
                }
            });
        }
        //#endregion
                        //#endregion
    </script>