chenhaozhe
2025-09-09 087f55cf5fb4fdde0a117daa32e364b8271bba2d
WebTM/views/Éú²ú¹ÜÀí/Ìí¿µÈýÖÜÅŲú/JIT_MaterialLevelShorAnalysisReport_TK.html
@@ -75,6 +75,12 @@
                                    <div class="layui-inline">
                                        <label class="layui-form-label" style="width: 85px;padding: 9px 18px;">产品编码</label>
                                        <div class="layui-input-block" style="margin-left: 77px;">
                                            <input type="text" class="layui-input" lay-verify="HMaterNumber" name="HMaterNumber" id="HMaterNumber" value="" style="width: 60%;display: inline-block;">
                                        </div>
                                    </div>
                                    <div class="layui-inline">
                                        <label class="layui-form-label" style="width: 85px;padding: 9px 18px;">产品名称</label>
                                        <div class="layui-input-block" style="margin-left: 77px;">
                                            <input type="hidden" class="layui-input" lay-verify="HMATERIALID" name="HMATERIALID" id="HMATERIALID" value="0" style="background-color:#efefef4d;width: 60%;display: inline-block;" readonly>
                                            <input type="text" class="layui-input" lay-verify="HMATERIALNAME" name="HMATERIALNAME" id="HMATERIALNAME" value="" style="background-color:#efefef4d;width: 60%;display: inline-block;">
                                            <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnHMATERIALID" id="btnHMATERIALID" style="padding: 0 10px;float: right;margin-right: 3px;">
@@ -91,6 +97,18 @@
                                                <option value="2">自制</option>
                                                <option value="3">委外</option>
                                            </select>
                                        </div>
                                    </div>
                                    <div class="layui-inline">
                                        <label class="layui-form-label" style="width: 85px;padding: 9px 18px;">生产订单</label>
                                        <div class="layui-input-block" style="margin-left: 77px;">
                                            <input type="text" class="layui-input" lay-verify="HICMOBillNo" name="HICMOBillNo" id="HICMOBillNo" value="" style="width: 60%;display: inline-block;">
                                        </div>
                                    </div>
                                    <div class="layui-inline">
                                        <label class="layui-form-label" style="width: 85px;padding: 9px 18px;">销售订单</label>
                                        <div class="layui-input-block" style="margin-left: 77px;">
                                            <input type="text" class="layui-input" lay-verify="HSeOrderBillNo" name="HSeOrderBillNo" id="HSeOrderBillNo" value="" style="width: 60%;display: inline-block;">
                                        </div>
                                    </div>
                                    <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnSearch" id="btnSearch">查询</button>
@@ -599,6 +617,9 @@
            var HWorkShopID = $("#HWorkShopID").val();//物料/产品
            var HWorkShopID2 = $("#HWorkShopID2").val();//物料/产品需求车间
            var HMaterClsID = $("#HMaterClsID").val();//物料属性
            var HSeOrderBillNo = $("#HSeOrderBillNo").val();//销售订单
            var HMaterNumber = $("#HMaterNumber").val();//产品编码
            var HICMOBillNo = $("#HICMOBillNo").val();//生产订单
            if (HBEGINDATE > HENDDATE) {
                return layer.msg("开始日期不能小于结束日期!");
            }
@@ -622,8 +643,17 @@
                sWhere += " and T1.HMaterID= " + HMATERIALID + " ";
            } else {
                if (HMATERIALNAME != "") {
                    sWhere += " and (T2.HName like ''%" + HMATERIALNAME + "%'' or T2.HNumber like ''%" + HMATERIALNAME + "%'') ";
                    sWhere += " and T2.HName like ''%" + HMATERIALNAME + "%''";
                }
            }
            if (HSeOrderBillNo != "") {
                sWhere += " and T1.HSeOrderBillNo like''%" + HSeOrderBillNo + "%''";
            }
            if (HMaterNumber != "") {
                sWhere += " and T2.HNumber like''%" + HMaterNumber + "%''";
            }
            if (HICMOBillNo != "") {
                sWhere += " and T1.HICMOBillNo like''%" + HICMOBillNo + "%''";
            }
            get_Display(sWhere);
            sWhere = "";//调用接口后清空sWhere缓存
@@ -640,6 +670,9 @@
            $("#HWorkShopID").val("0");
            $("#HWorkShopID2").val("0");
            $("#HMaterClsID").val("0");
            $("#HSeOrderBillNo").val("");//销售订单
            $("#HMaterNumber").val("");//产品编码
            $("#HICMOBillNo").val("");//生产订单
            form.render('select');
            sWhere = "";
        }