WebTM/views/³µ¼ä¹ÜÀí/±¨±í·ÖÎö/sc_ICOMReport.html
@@ -38,7 +38,7 @@
                                    <div class="layui-form-item  layui-inline">
                                        <div class="layui-inline">
                                            <div class="layui-input-inline">
                                                <input type="date" class="layui-input" id="HBeginDate" style="width:190px;">
                                                <input type="date" class="layui-input ForFilteringSchemes" id="HBeginDate" style="width:190px;">
                                            </div>
                                        </div>
                                    </div>
@@ -46,7 +46,7 @@
                                        <div class="layui-inline">
                                            <label class="layui-form-label">-</label>
                                            <div class="layui-input-inline">
                                                <input type="date" class="layui-input" id="HEndDate" style="width:190px;">
                                                <input type="date" class="layui-input ForFilteringSchemes" id="HEndDate" style="width:190px;">
                                            </div>
                                        </div>
                                    </div>
@@ -55,39 +55,35 @@
                                    <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">重置</button>
                                <!--显示当前过滤方案-->
                                <div class="layui-inline" style="margin-left:5px;">
                                    <div style="text-align:center;font-size:15px;font-weight:bold;color:#fc9393" id="HFilterScheme_Now"></div>
                                </div>
                                <div class="layui-colla-content" style="padding: 0px; margin-left: 6%;">
                                    <div class="layui-row" style="margin-top:10px;">
                                        <!--其他条件-->
                                        <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="HMaterNumber" id="HMaterNumber">
                                                <input type="text" class="layui-input ForFilteringSchemes" name="HMaterNumber" id="HMaterNumber">
                                            </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="HBillNo" id="HBillNo">
                                                <input type="text" class="layui-input ForFilteringSchemes" name="HBillNo" id="HBillNo">
                                            </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="HProductName" id="HProductName">
                                                <input type="text" class="layui-input ForFilteringSchemes" name="HProductName" id="HProductName">
                                            </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="HProductModel" id="HProductModel">
                                                <input type="text" class="layui-input ForFilteringSchemes" name="HProductModel" id="HProductModel">
                                            </div>
                                        </div>
                                    </div>
@@ -115,7 +111,64 @@
                                            </select>
                                        </div>
                                        <div class="layui-inline">
                                            <input type="text" class="layui-input  ForFilteringSchemes" value="" name="ColContent" id="ColContent">
                                            <input type="text" class="layui-input ForFilteringSchemes" value="" name="ColContent" id="ColContent">
                                        </div>
                                    </div>
                                    <div class="layui-row" style="margin-top: 10px; margin-bottom: 10px ">
                                        <div class="layui-inline">
                                            <label class="layui-form-label">过滤</label>
                                            <div class="layui-input-block">
                                                <select name="ColName1" id="ColName1" class="ForFilteringSchemes" lay-filter="ColName1" style="width:190px;">
                                                </select>
                                            </div>
                                        </div>
                                        <div class="layui-inline">
                                            <select name="Comparator1" id="Comparator1" class="ForFilteringSchemes" lay-filter="Comparator1" 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="ColContent1" id="ColContent1">
                                        </div>
                                    </div>
                                    <div class="layui-row" style=" margin-top: 10px; margin-left: 70px;">
                                        <div class="layui-inline">
                                            <label class="layui-form-label">过滤</label>
                                            <div class="layui-input-block">
                                                <select name="ColName2" id="ColName2" class="ForFilteringSchemes" lay-filter="ColName2" style="width:190px;">
                                                </select>
                                            </div>
                                        </div>
                                        <div class="layui-inline">
                                            <select name="Comparator2" id="Comparator2" class="ForFilteringSchemes" lay-filter="Comparator2" 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="ColContent2" id="ColContent2">
                                        </div>
                                    </div>
                                </div>
@@ -156,16 +209,6 @@
                , laypage = layui.laypage
                , laydate = layui.laydate
                , util = layui.util
            //查询条件
            var sWhere = "";
            var option = [];
            var HModName = "sc_ICOMReport";
            var titleData = ["HCusID"];//不需要显示的字段 å¯æ‰©å±•
            var detailBar = 0;       //用于汇总报表查看明细报表,当为0时显示明细汇总报表对应明细报表。
            var ins;                        //用于导出excel
            //#region ã€è¿‡æ»¤æ–¹æ¡ˆã€‘
@@ -181,7 +224,16 @@
            //#endregion
            //查询条件
            var sWhere = "";
            var option = [];
            var HModName = "sc_ICOMReport";
            var titleData = ["HCusID"];//不需要显示的字段 å¯æ‰©å±•
            var detailBar = 0;       //用于汇总报表查看明细报表,当为0时显示明细汇总报表对应明细报表。
            var ins;                        //用于导出excel
            //#endregion
            //#region è¿›å…¥é¡µé¢æ—¢åŠ è½½
@@ -200,7 +252,7 @@
                        get_Export();
                        break;
                    //退出
                    case 'btn-exit': Pub_Close(2);
                    case 'btn-exit': Pub_Close(2);
                        break;
                    //关闭订单
                    case 'btn-Close': btn_Close(obj);
@@ -221,6 +273,7 @@
                        break;
                };
            });
            //重置按钮
            form.on('submit(btnReSearch)', function (data) {
                set_ClearQuery();
@@ -263,13 +316,11 @@
                $("#HBeginDate").val(Format(new Date(new Date() - 1000 * 60 * 60 * 24 * 1), "yyyy-MM-dd"));
                $("#HEndDate").val(Format(new Date(new Date()), "yyyy-MM-dd"));
                //加载数据到网格
                get_FastQuery();
                DisPlay_HideColumn();
                //查询当前登录用户有没有在当前模块设置默认过滤方案
                get_DefaultModule();
                //加载数据到网格
                //get_FastQuery();
                DisPlay_HideColumn();
            }
            //列明显示下拉框
@@ -283,6 +334,14 @@
                $("#ColName").empty();
                $("#ColName").append(Organization);
                form.render('select');
                $("#ColName1").empty();
                $("#ColName1").append(Organization);
                $("#ColName2").empty();
                $("#ColName2").append(Organization);
                form.render('select');
            }
@@ -355,32 +414,34 @@
                    }
                })
            }
            //快速过滤
            function get_FastQuery() {
                var HBeginDate = $("#HBeginDate").val();//下达日期 å¼€å§‹æ—¥æœŸ
                var HEndDate = $("#HEndDate").val();//结束日期
                var HMaterNumber = $("#HMaterNumber").val();//物料代码
                var HMaterNumber = $("#HMaterNumber").val();//产品代码
                var HBillNo = $("#HBillNo").val();          //单据号
                var HProductName = $("#HProductName").val();//产品名称
                var HProductModel = $("#HProductModel").val();//产品规格
                var HProductModel = $("#HProductModel").val();//规格型号
                sWhere = " and æ—¥æœŸ between ''" + HBeginDate + "'' and ''" + HEndDate + "'' ";
                if (HMaterNumber != "") {
                    sWhere += " and ç‰©æ–™ä»£ç =''" + HMaterNumber + "'' ";
                    sWhere += " and ç‰©æ–™ä»£ç  like ''%" + HMaterNumber + "%'' ";
                }
                if (HBillNo != "") {
                    sWhere += " and ç”Ÿäº§è®¢å•号=''" + HBillNo + "'' ";
                    sWhere += " and å•据号 like ''%" + HBillNo + "%'' ";
                }
                if (HProductName != "") {
                    sWhere += " and ç‰©æ–™åç§°=''" + HProductName + "'' ";
                    sWhere += " and ç‰©æ–™åç§° like ''%" + HProductName + "%'' ";
                }
                if (HProductModel != "") {
                    sWhere += " and è§„格型号=''" + HProductModel + "'' ";
                    sWhere += " and è§„格型号 like ''%" + HProductModel + "%'' ";
                }
                //任意字段条件过滤 æ¡ä»¶æå–
@@ -388,6 +449,13 @@
                var Comparator = $("#Comparator").val()
                var ColContent = $("#ColContent").val();
                var ColName1 = $("#ColName1").val();//复选框
                var Comparator1 = $("#Comparator1").val()
                var ColContent1 = $("#ColContent1").val(); var ColName2 = $("#ColName2").val();//复选框
                var Comparator2 = $("#Comparator2").val()
                var ColContent2 = $("#ColContent2").val();
                //拼接任一字段过滤查询条件
                var com = "";
                if (ColName != 0 && Comparator != 0) {
@@ -408,10 +476,52 @@
                            com = "" + Comparator + " ''" + ColContent + "''";
                            break;
                    }
                    com = " and (" + ColName + " " + com + ")";
                    sWhere += " and " + ColName + " " + com;
                }
                sWhere += com;
                if (ColName1 != 0 && Comparator1 != 0) {
                    var com1 = "";
                    switch (Comparator1) {
                        case "7":
                            com1 = "like''%" + ColContent1 + "%''";
                            break;
                        case "8":
                            com1 = "like''%" + ColContent1 + "''";
                            break;
                        case "9":
                            com1 = "like''" + ColContent1 + "%''";
                            break;
                        case "10":
                            com1 = "not like''%" + ColContent1 + "%''";
                            break;
                        default:
                            com1 = "" + Comparator1 + "''" + ColContent1 + "''";
                            break;
                    }
                    sWhere += " and " + ColName1 + " " + com1;
                }
                if (ColName2 != 0 && Comparator2 != 0) {
                    var com2 = "";
                    switch (Comparator2) {
                        case "7":
                            com2 = "like''%" + ColContent2 + "%''";
                            break;
                        case "8":
                            com2 = "like''%" + ColContent2 + "''";
                            break;
                        case "9":
                            com2 = "like''" + ColContent2 + "%''";
                            break;
                        case "10":
                            com2 = "not like''%" + ColContent2 + "%''";
                            break;
                        default:
                            com2 = "" + Comparator2 + "''" + ColContent2 + "''";
                            break;
                    }
                    sWhere += " and " + ColName2 + " " + com2;
                }
                //根据用户过滤用户关联客户的记录
                sWhere += getSWhereByHUser();
@@ -422,7 +532,7 @@
            //重置过滤条件
            function set_ClearQuery() {
                //初始化时间
                //初始化时间set_InitGrid
                $("#HBeginDate").val(Format(new Date(new Date() - 1000 * 60 * 60 * 24 * 1), "yyyy-MM-dd"));
                $("#HEndDate").val(Format(new Date(new Date()), "yyyy-MM-dd"));
                $("#HMaterNumber").val("");
@@ -432,6 +542,14 @@
                $("#ColContent").val("");
                $("#ColName").val("0");
                $("#Comparator").val("0");
                $("#ColContent1").val("");
                $("#ColName1").val("0");
                $("#Comparator1").val("0");
                $("#ColContent2").val("");
                $("#ColName2").val("0");
                $("#Comparator2").val("0");
                form.render('select');
                ColFilter();
                sWhere = "";
            }
@@ -464,7 +582,7 @@
                        });
                    }
                })
            }
            function btn_AddHRemark() {
@@ -474,7 +592,7 @@
                } else {
                    layer.prompt({ title: '添加备注', formType: 2 }, function (text, index) {
                        var sMainSub = checkStatus.data[0]["生产订单号"]+ ";"+text + ";" + sessionStorage["HUserName"];
                        var sMainSub = checkStatus.data[0]["生产订单号"] + ";" + text + ";" + sessionStorage["HUserName"];
                        $.ajax({
                            url: GetWEBURL() + "/LEMS/sc_ICOMReportAddHRemark",
                            type: "POST",
@@ -496,7 +614,7 @@
                                });
                            }
                        })
                    });
                }
            }
@@ -522,6 +640,7 @@
                });
            }
            //#endregion
            //隐藏列设置
            function get_HideColumn() {
@@ -646,7 +765,7 @@
                    , area: ['90%', '90%']//大小
                    , title: '客户订单明细报表'//标题
                    , shift: 2//弹出动画
                    , content: ['../../车间管理/报表分析/Sc_ICOMProBarCodeReport.html?OperationType=1&HICMOBillNo=' + HICMOBillNo , 'yes']
                    , content: ['../../车间管理/报表分析/Sc_ICOMProBarCodeReport.html?OperationType=1&HICMOBillNo=' + HICMOBillNo, 'yes']
                })
            }
@@ -677,6 +796,8 @@
            }
            //#endregion
            //#region ã€è¿‡æ»¤æ–¹æ¡ˆã€‘
            //获取当前用户的默认过滤方案
@@ -687,11 +808,6 @@
                    data: { "user": sessionStorage["Czybm"], "HModuleName": HModuleName, "HInterID": 0, "Type": "Default" },
                    success: function (data1) {
                        if (data1.count == 1) {
                            sWhere += " and 1=0 ";
                            get_FastQuery();
                            ColFilter();
                            //当前用户设置有默认的过滤方案
                            var data = data1.data;
                            //当前选择的过滤方案
@@ -712,15 +828,18 @@
                                    $("#" + data[i].过滤字段ID).find("option[value='" + data[i].过滤值 + "']").attr("selected", true);
                                }
                            }
                            //执行查询方法
                            get_FastQuery()
                            //查询
                            get_FastQuery();
                            form.render("select");
                        } else {
                            //当前用户没有设置默认的过滤方案
                            //隐藏显示过滤方案的标签信息
                            document.getElementById("HFilterScheme_Now").style.display = "none";
                            //执行查询方法
                            get_FastQuery()
                            //查询
                            get_FastQuery();
                            form.render("select");
                        }
                    }, error: function () {
@@ -889,10 +1008,9 @@
            }
            //#endregion
            //#endregion
        });
        //#region ã€è¿‡æ»¤æ–¹æ¡ˆè¿”回数据】
        function HFilterScheme(obj)  //返回过滤方案
        {
@@ -931,7 +1049,6 @@
            });
        }
        //#endregion
    </script>
</body>
</html>