采购委外 状态查询

王 垚

2022-04-13 157293d1295f286231dc8e1f26d2b77bd98500be

采购委外 状态查询

 WebTM/views/²É¹º¹ÜÀí/ίÍⶩµ¥/WW_EntrustOrderBillList.html

@@ -31,13 +31,22 @@
                                    </div>
                                </div>
                                <div class="layui-inline">
                                    <label class="layui-form-label">业务状态</label>
                                    <label class="layui-form-label">分配状态</label>
                                    <div class="layui-input-block">
                                        <select name="HStatus" lay-filter="HStatus" style="width:190px;">
                                            <option value="-1" selected>全部</option>
                                            <option value="1">未分配</option>
                                            <option value="2">已分配</option>
                                            <option value="3">已发布</option>
                                            <option value="" selected="selected">全部</option>
                                            <option value="未分配">未分配</option>
                                            <option value="已分配">已分配</option>
                                        </select>
                                    </div>
                                </div>
                                <div class="layui-inline">
                                    <label class="layui-form-label">发布状态</label>
                                    <div class="layui-input-block">
                                        <select name="HStatus2" lay-filter="HStatus2" style="width:190px;">
                                            <option value="" selected="selected">全部</option>
                                            <option value="未发布">未发布</option>
                                            <option value="已发布">已发布</option>
                                        </select>
                                    </div>
                                </div>
@@ -59,10 +68,10 @@
                                <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnReSearch" id="btnReSearch" style="padding:0 5px">重置</button>
                                <div class="layui-colla-content">
                                    <!--<div class="layui-inline">
        <div class="layui-inline">
            <span>其他条件></span>
        </div>
    </div>-->
            <div class="layui-inline">
                <span>其他条件></span>
            </div>
        </div>-->
                                    <div class="layui-inline">
                                        <label class="layui-form-label">单据号</label>
                                        <div class="layui-input-block">
@@ -87,11 +96,11 @@
                                        </div>
                                    </div>
                                    <!--<div class="layui-inline">
                                        <label class="layui-form-label">反馈状态</label>
                                        <div class="layui-input-block">
                                            <input type="text" class="layui-input" name="HXTFKStatus" id="HXTFKStatus" style="width:190px;">
                                        </div>
                                    </div>-->
            <label class="layui-form-label">反馈状态</label>
            <div class="layui-input-block">
                <input type="text" class="layui-input" name="HXTFKStatus" id="HXTFKStatus" style="width:190px;">
            </div>
        </div>-->
                                    <div class="layui-inline">
                                        <label class="layui-form-label">物料编码</label>
                                        <div class="layui-input-block">
@@ -291,7 +300,9 @@
                    , { field: '业务员', title: '业务员', width: 100 }
                    , { field: 'HBillType', title: 'HBillType', hide: true }
                    , { field: 'HSupID', title: 'HSupID', hide: true }
                    , { field: '业务状态', title: '业务状态', width: 100 }
                    , { field: '业务状态', title: '业务状态', width: 100 , hide: true }
                    , { field: '分配状态', title: '分配状态', width: 100  }
                    , { field: '发布状态', title: '发布状态', width: 100 }
                    , { field: '供应商协同状态', title: '供应商协同状态', width: 135 }/*物料代码，物料名称，规格型号，批号，数量，单位，源单单号*/
                    , { field: '反馈状态', title: '供应商反馈状态', width: 135 }
                    , { field: '物料编码', title: '物料编码', width: 130 }
@@ -973,7 +984,8 @@

            //快速过滤
            function get_FastQuery(table, option) {
                var HStatus = $("select[name='HStatus']").val();//状态
                var HStatus = $("select[name='HStatus']").val();// 
                var HStatus2 = $("select[name='HStatus2']").val();// 
                var HBeginDate = $("#HBeginDate").val();//开始日期
                var HEndDate = $("#HEndDate").val();//结束日期
                var HBillNo = $("#HBillNo").val(); //单据号
@@ -985,23 +997,11 @@
                var HMaterShortNumber = $("#HMaterShortNumber").val();
                var HSupName = $("#HSupName").val();//供应商
                var HFeedback = $("select[name='HFeedback']").val(); //供应商反馈状态

                if (HStatus) {
                    switch (HStatus) {
                        case '-1':   //全部
                            sWhere += "";
                            break;
                        case '1':    //未分配
                            sWhere += " and ä¸šåŠ¡çŠ¶æ€='未分配'";
                            break;
                        case '2':    //已审核
                            sWhere += " and ä¸šåŠ¡çŠ¶æ€='已分配'";
                            break;
                        case '3':    //已关闭
                            sWhere += " and ä¸šåŠ¡çŠ¶æ€='已发布'";
                        default:

                    }
                    sWhere += " and åˆ†é…çŠ¶æ€ like '%" + HStatus + "%'";
                }
                if (HStatus2) {
                    sWhere += " and å‘布状态 like '%" + HStatus2 + "%'";
                }
                if (HBeginDate) {
                    sWhere += " and CONVERT(varchar(100),日期, 23) >= '" + HBeginDate + "'";

 WebTM/views/²É¹º¹ÜÀí/²É¹º¶©µ¥/Cg_POOrderBillList.html

@@ -30,13 +30,22 @@
                                    </div>
                                </div>
                                <div class="layui-inline">
                                    <label class="layui-form-label">业务状态</label>
                                    <label class="layui-form-label">分配状态</label>
                                    <div class="layui-input-block">
                                        <select name="HStatus" lay-filter="HStatus" style="width:190px;">
                                            <option value="-1" selected="selected">全部</option>
                                            <option value="1">未分配</option>
                                            <option value="2">已分配</option>
                                            <option value="3">已发布</option>
                                            <option value="" selected="selected">全部</option>
                                            <option value="未分配">未分配</option>
                                            <option value="已分配">已分配</option>
                                        </select>
                                    </div>
                                </div>
                                <div class="layui-inline">
                                    <label class="layui-form-label">发布状态</label>
                                    <div class="layui-input-block">
                                        <select name="HStatus2" lay-filter="HStatus2" style="width:190px;">
                                            <option value="" selected="selected">全部</option>
                                            <option value="未发布">未发布</option>
                                            <option value="已发布">已发布</option>
                                        </select>
                                    </div>
                                </div>
@@ -58,13 +67,15 @@
                                </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">


                                <!--<div class="layui-inline">
                                    <label class="layui-form-label">单据号</label>
                                    <div class="layui-input-block">
                                        <input type="text" class="layui-input" name="HBillno2" id="HBillno2" style="width:190px;">
                                    </div>
                                </div>
                                <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnResCnz" id="btnReSearch" style="padding:0 5px">重新同步</button>
                                <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnResCnz" id="btnReSearch" style="padding:0 5px">重新同步</button>-->


                                <div class="layui-colla-content">
@@ -78,7 +89,6 @@
                                        <label class="layui-form-label">业务员</label>
                                        <div class="layui-input-block" style="width:190px;">
                                            <select name="HEmpName" lay-filter="HEmpName" id="HEmpName">
                                               
                                            </select>
                                        </div>
                                    </div>
@@ -93,11 +103,11 @@
                                        </div>
                                    </div>
                                    <!--<div class="layui-inline">
        <label class="layui-form-label">反馈状态</label>
        <div class="layui-input-block">
            <input type="text" class="layui-input" name="HXTFKStatus" id="HXTFKStatus" style="width:190px;">
        </div>
    </div>-->
                                        <label class="layui-form-label">反馈状态</label>
                                        <div class="layui-input-block">
                                            <input type="text" class="layui-input" name="HXTFKStatus" id="HXTFKStatus" style="width:190px;">
                                        </div>
                                    </div>-->
                                    <div class="layui-inline">
                                        <label class="layui-form-label">物料编码</label>
                                        <div class="layui-input-block">
@@ -301,7 +311,9 @@
                    , { field: '业务员', title: '业务员', width: 100 }
                    , { field: 'HBillType', title: 'HBillType', hide: true }
                    , { field: 'HSupID', title: 'HSupID', hide: true }
                    , { field: '业务状态', title: '业务状态', width: 100 }
                    , { field: '业务状态', title: '业务状态', width: 100, hide: true }
                    , { field: '分配状态', title: '分配状态', width: 100 }
                    , { field: '发布状态', title: '发布状态', width: 100 }
                    , { field: '供应商协同状态', title: '供应商协同状态', width: 135 }/*物料代码，物料名称，规格型号，批号，数量，单位，源单单号*/
                    , { field: '反馈状态', title: '供应商反馈状态', width: 135 }
                    , { field: '物料编码', title: '物料编码', width: 120 }
@@ -982,7 +994,8 @@

            //快速过滤
            function get_FastQuery(table, option) {
                var HStatus = $("select[name='HStatus']").val();//状态
                var HStatus = $("select[name='HStatus']").val();// 
                var HStatus2 = $("select[name='HStatus2']").val();// 
                var HBeginDate = $("#HBeginDate").val();//开始日期
                var HEndDate = $("#HEndDate").val();//结束日期
                var HBillNo = $("#HBillNo").val(); //单据号
@@ -994,23 +1007,12 @@
                //var HXTFKStatus = $("#HXTFKStatus").val();
                var HSupName = $("#HSupName").val();//供应商
                var HFeedback = $("select[name='HFeedback']").val(); //供应商反馈状态
                
                if (HStatus) {
                    switch (HStatus) {
                        case '-1':   //全部
                            sWhere += "";
                            break;
                        case '1':    //未分配
                            sWhere += " and ä¸šåŠ¡çŠ¶æ€='未分配'";
                            break;
                        case '2':    //已审核
                            sWhere += " and ä¸šåŠ¡çŠ¶æ€='已分配'";
                            break;
                        case '3':    //已关闭
                            sWhere += " and ä¸šåŠ¡çŠ¶æ€='已发布'";
                        default:

                    }
                if (HStatus) {
                    sWhere += " and åˆ†é…çŠ¶æ€ like '%" + HStatus + "%'";
                }
                if (HStatus2) {
                    sWhere += " and å‘布状态 like '%" + HStatus2 + "%'";
                }
                if (HBeginDate) {
                    sWhere += " and CONVERT(varchar(100),日期, 23) >= '" + HBeginDate + "'";