nop

王 垚

2022-10-26 1f8ae24347a7aba2e8bf4b4fa5099a2a7aa46b40

nop

 WebSRM/layuiAdmin.std-v1.2.1/src/views/SRM/SRM_POInStockBillList.html

@@ -66,12 +66,6 @@
                                        <input type="text" class="layui-input" name="HInnerBillNo" id="HInnerBillNo">

                                    </div>

                                </div>

                                <!--<div class="layui-inline">

                                    <label class="layui-form-label">物料编码</label>

                                    <div class="layui-input-block">

                                        <input type="text" class="layui-input" name="HShortNumber" id="HShortNumber">

                                    </div>

                                </div>-->

                                <div class="layui-inline">

                                    <label class="layui-form-label">物料代码</label>

                                    <div class="layui-input-block">

@@ -102,55 +96,43 @@
                                        </select>

                                    </div>

                                </div>



                                <!--<div class="layui-inline">

                                <div class="layui-inline">
                                    <label class="layui-form-label">开始日期</label>

                                    <div class="layui-input-block">

                                        <input type="text" class="layui-input" name="HDate1" id="HDate1">

                                    </div>

                                </div>-->

                                <!--<div class="layui-inline">

                                </div>
                                <div class="layui-inline">
                                    <label class="layui-form-label">结束日期</label>

                                    <div class="layui-input-block">

                                        <input type="text" class="layui-input" name="HDate2" id="HDate2">

                                    </div>

                                </div>-->

                                <!--<div class="layui-inline">

        <label class="layui-form-label">状态</label>

                                </div>
                                <div class="layui-inline">
                                    <label class="layui-form-label">订货数量</label>
        <div class="layui-input-block">

            <select name="HStatus" id="HStatus" lay-filter="">

                                        <input type="text" class="layui-input" name="HQty" id="HQty">
                                    </div>
                                </div>
                                <div class="layui-inline">
                                    <label class="layui-form-label">变更状态</label>
                                    <div class="layui-input-block">
                                        <select name="HBGStatus" id="HBGStatus" lay-filter="">
                <option value="">全部</option>

                <option value="未打印" selected="">未打印</option>

                <option value="已打印">已打印</option>

                                            <option value="未变更" selected="">未变更</option>
                                            <option value="已变更">已变更</option>
            </select>

        </div>

    </div>-->



                                <!--<div class="layui-inline">

                                    <label class="layui-form-label">采购组织</label>

                                    <div class="layui-input-block">

                                        <select id="HPURCHASEORGID" name="HPURCHASEORGID" lay-filter="">

                                            <option value="">组织1</option>

                                            <option value="">组织2</option>

                                        </select>

                                    </div>

                                </div>-->

                                <div class="layui-inline">

                                    <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="f_Query">

                                        <i class="layui-icon layui-icon-search layuiadmin-button-btn"></i>

                                    </button>

                                </div>

                            </div>











                        </form>

                        <!--</div>-->

                    </div>





                    <table class="layui-hide" id="mainTable" lay-filter="mainTable"></table>

                    <script type="text/html" id="toolbarDemo">

                        <div class="layui-btn-container">

@@ -270,7 +252,8 @@
                    , { field: '单据状态', title: '单据状态', sort: true/*, fixed: true*/ }

                    , { field: '单据号', title: '单据号', width: 150, sort: true/*, fixed: true*/ }

                    , { field: '送货单号', title: '送货单号', width: 150, sort: true/*, fixed: true*/ }

                    , { field: 'F_xbkf_Combo', title: '自定义标识', width: 120 }
                    , { field: '源单单号', title: '源单单号', width: 180 }

                    , { field: 'F_xbkf_Combo', title: '自定义标识', width: 120 }
                    , { field: '源单单号', title: '源单单号', width: 180 }
                    , { field: '包装标识', title: '包装标识', width: 180 }

                    //, { field: '物流单号', title: '物流单号', width: 150, sort: true/*, fixed: true*/ }

                    //, { field: '物料编码', title: '物料编码', width: 120, sort: true }

@@ -544,7 +527,9 @@
                    else {

                        sqlWhere += " and 状态 like ^^%" + $("#HStatus").val() + "%^^";

                    }



                if ($("#HBGStatus").val() != "") {
                    sqlWhere += " and 变更状态 like ^^%" + $("#HBGStatus").val() + "%^^";
                }
                if ($("#HBillNo").val() != "")

                    sqlWhere += " and 单据号 like ^^%" + $("#HBillNo").val() + "%^^";

                if ($("#HBillNoFrom").val() != "")

@@ -563,12 +548,15 @@
                    sqlWhere += " and 单据状态 like ^^%" + $("#HClStatus").val() + "%^^";

                //if ($("#HPURCHASEORGID").val() != "")

                //    sqlWhere += " and 采购组织 like ^^%" + $("#HPURCHASEORGID").val() + "%^^";

                //if ($("#HDate1").val() != "") {

                //    sqlWhere += " and 日期 >= ^^" + $("#HDate1").val() + "^^";

                //}

                //if ($("#HDate2").val() != "") {

                //     sqlWhere += " and 日期 <= ^^" + $("#HDate2").val() + "^^";

                //}

                if ($("#HDate1").val() != "") {
                    sqlWhere += " and 日期 >= ^^" + $("#HDate1").val() + "^^";
                }
                if ($("#HDate2").val() != "") {
                    sqlWhere += " and 日期 <= ^^" + $("#HDate2").val() + "^^";
                }
                if ($("#HQty").val() != "") {
                    sqlWhere += " and 数量 = ^^" + $("#HQty").val() + "^^";
                }


                sql = sqlWhere;

                //从第一页开始