出门确认单报表：根据维度进行查询

duhe

2024-10-21 cb341351c4934e7fea909d9854f6c608110c5676

出门确认单报表：根据维度进行查询

 WebTM/views/Ó¦ÊÕ¹ÜÀí/±¨±í·ÖÎö/Xs_OutDoorBillReport.html

@@ -52,9 +52,24 @@
                                    </div>
                                </div>
                                <div class="layui-inline">
                                    <label class="layui-form-label" style="width: 85px;">单据号</label>
                                    <label class="layui-form-label" style="width: 85px;">维度</label>
                                    <div class="layui-input-block" style="margin-left: 120px;">
                                        <select name="HOperationType" id="HOperationType" lay-filter="HOperationType" style="width: 180px; ">
                                            <option style="color:blue;" selected="selected" value="1">销售出库单审核时间</option>
                                            <option style="color:blue;" value="2">出门确认时间</option>
                                        </select>
                                    </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">
                                    </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="HBillNo1" id="HBillNo1">
                                    </div>
                                </div>
                                <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnSearch" id="btnSearch">
@@ -145,32 +160,32 @@
                                    </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="ColName2" id="ColName2" class="ForFilteringSchemes" lay-filter="ColName2" style="width:190px;">
                                                </select>
                                            </div>
                                        </div>
                                        <div class="layui-inline">
                                            <select name="Comparator2" id="Comparator2" lay-filter="Comparator2" 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="ColContent2" id="ColContent2">
                                        </div>
                                    </div>-->
            <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" lay-filter="Comparator2" 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="ColContent2" id="ColContent2">
            </div>
        </div>-->
                                </div>
                            </div>
                        </div>
@@ -331,6 +346,7 @@

                //加载数据到网格
                get_FastQuery();
                ColFilter();
                DisPlay_HideColumn();
                //查询当前登录用户有没有在当前模块设置默认过滤方案
                get_DefaultModule();
@@ -374,6 +390,7 @@

                var HBeginDate = $("#HBeginDate").val();//下达日期 å¼€å§‹æ—¥æœŸ
                var HEndDate = $("#HEndDate").val();//结束日期
                var HOperationType = $("#HOperationType").val();            //数据维度

                //动态列-缓存列表
                $.ajax({
@@ -381,7 +398,7 @@
                    async: false,
                    type: "GET",
                    async: false,
                    data: { "HBeginDate": HBeginDate, "HEndDate": HEndDate, "sWhere": sWhere, "user": sessionStorage["HUserName"] },
                    data: { "HBeginDate": HBeginDate, "HEndDate": HEndDate, "sWhere": sWhere, "user": sessionStorage["HUserName"], "HOperationType": HOperationType },
                    success: function (data1) {

                        if (data1.count == 1) {
@@ -418,12 +435,12 @@
                            }

                            option.data = data1.data[0];
                            if (option.cols[0].length == 0) {
                                option.cols = [col];
                            }
                            option.cols = [col];
                            ins = table.render(option);
                            //DisPlay_HideColumn();

                            DisPlay_HideColumn();
                            if ($("#Comparator").val() == 0 && $("#ColContent").val() == "" && $("#Comparator1").val() == 0 && $("#ColContent1").val() == "") {
                                ColFilter();
                            }
                        } else {
                            layer.alert(data1.count + data1.Message, { icon: 5 })
                        }
@@ -444,7 +461,8 @@
                var HBeginDate = $("#HBeginDate").val();//下达日期 å¼€å§‹æ—¥æœŸ
                var HEndDate = $("#HEndDate").val();//结束日期
                var HMaterNumber = $("#HMaterNumber").val();//物料代码
                var HBillNo = $("#HBillNo").val();          //单据号
                var HBillNo = $("#HBillNo").val();          //销售出库单号
                var HBillNo1 = $("#HBillNo1").val();          //出门确认单号
                var HProductName = $("#HProductName").val();//产品名称
                var HProductModel = $("#HProductModel").val();//产品规格

@@ -460,15 +478,19 @@
                //    HEndDate = HEndDate_u;
                //}

                if (HBeginDate) {
                    sWhere += " and CONVERT(varchar(100),出门确认日期, 20) >= ''" + HBeginDate + "''";
                }
                if (HEndDate) {
                    sWhere += " and CONVERT(varchar(100),出门确认日期, 20) <= ''" + HEndDate + "''";
                }
                //if (HBeginDate) {
                //    sWhere += " and CONVERT(varchar(100),出门确认日期, 20) >= ''" + HBeginDate + "''";
                //}
                //if (HEndDate) {
                //    sWhere += " and CONVERT(varchar(100),出门确认日期, 20) <= ''" + HEndDate + "''";
                //}

                if (HBillNo != "") {
                    sWhere += " and å•æ®å·=''" + HBillNo + "'' ";
                    sWhere += " and é”€å”®å‡ºåº“单号=''" + HBillNo + "'' ";
                }

                if (HBillNo1 != "") {
                    sWhere += " and å‡ºé—¨ç¡®è®¤å•å·=''" + HBillNo1 + "'' ";
                }

                if (HMaterNumber != "") {
@@ -658,7 +680,6 @@

            //显示列数据
            function DisPlay_HideColumn() {
                ColFilter();
                $.ajax({
                    url: GetWEBURL() + '/Xt_grdAlignment_WMES/grdAlignmentWMESList',
                    type: "GET",