智云SRM-LAYUI(夏宝服务器版本)
blame | 历史 | 补丁 | 提交 | 提交对比 | ignore whitespace
YL
2022-02-22 ba5b9f28eb0ba21641c606507d74ef0937cce4e9 
 WebSRM/layuiAdmin.std-v1.2.1/src/views/SRM/SRM_EntrustOrderBillList.html


@@ -45,25 +45,31 @@


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


                                    </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">


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


                                    </div>


                                </div>


                                <div class="layui-inline">


                                    <label class="layui-form-label">产品名称</label>


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


                                    <label class="layui-form-label">物料名称</label>


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


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


                                    </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="HModel" id="HModel">


                                    </div>


                                </div>


                                <div class="layui-inline">


                                </div>-->


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


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


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


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


@@ -72,19 +78,19 @@


                                            <option value="已关闭">已关闭</option>


                                        </select>


                                    </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="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>-->


                                <div class="layui-inline">


                                    <label class="layui-form-label">交货时间</label>


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


@@ -101,7 +107,7 @@


                                        </select>


                                    </div>


                                </div>


                                <div class="layui-inline">


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


                                    <label class="layui-form-label">委外组织</label>


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


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


@@ -109,8 +115,8 @@


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


                                        </select>


                                    </div>


                                </div>


                                <div class="layui-inline">


                                </div>-->


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


                                    <label class="layui-form-label">是否已下推送货单</label>


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


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


@@ -119,7 +125,7 @@


                                            <option value="否">否</option>


                                        </select>


                                    </div>


                                </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>


@@ -138,17 +144,12 @@


                            <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-back" id="btn_back"><i class="layui-icon layui-icon-close-fill"></i>驳回</button>


                            <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-report" id="btn_report"><i class="layui-icon layui-icon-close-fill"></i>汇报</button>


                            <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-details"><i class="layui-icon layui-icon-form"></i>详情</button>


                            <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-generate"><i class="layui-icon layui-icon-file"></i>生成送货单</button>


                            <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-barcode"><i class="layui-icon layui-icon-file"></i>生成条码</button>


                            <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-generate"><i class="layui-icon layui-icon-file"></i>生成送货单</button>


                            <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-exit"><i class="layui-icon layui-icon-return"></i>退出</button>




                        </div>


                    </script>




                </div>








            </div>


        </div>


    </div>


@@ -235,21 +236,22 @@


                , cellMinWidth: 100


                , cols: [[


                    //{ checkbox: true, fixed: true }


                    { type: 'checkbox', fixed: 'left' }


                    { type: 'checkbox'/*, fixed: 'left'*/ }


                    //{ type: 'radio', fixed: true }


                    , { field: 'sorderid', title: '序号', width: 80, fixed: true }


                    , { field: 'hmainid', title: 'hmainid', sort: true, fixed: true, hide: true }


                    , { field: 'hsubid', title: 'hsubid', sort: true, fixed: true, hide: true }


                    , { field: '状态', title: '状态', sort: true, fixed: true }


                    , { field: '反馈状态', title: '反馈状态', width: 100, fixed: true }


                    , { field: '优先级', title: '优先级', width: 100, fixed: true }


                    , { field: '单据号', title: '单据号', width: 180, sort: true, fixed: 'left' }


                    , { field: '日期', title: '日期', width: 180, sort: true, fixed: 'left' }


                    , { field: '供应商', title: '供应商', width: 180, sort: true, fixed: 'left' }


                    , { field: 'sorderid', title: '序号', width: 80/*, fixed: true*/ }


                    , { field: 'hmainid', title: 'hmainid', sort: true  /*, fixed: true*/, hide: true }


                    , { field: 'hsubid', title: 'hsubid', sort: true  /*, fixed: true*/, hide: true }


                    , { field: '状态', title: '状态', sort: true  /*, fixed: true*/ }


                    , { field: '反馈状态', title: '反馈状态', width: 100  /*, fixed: true*/ }


                    , { field: '优先级', title: '优先级', width: 100  /*, fixed: true*/ }


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


                    , { field: '日期', title: '日期', width: 180, sort: true/*, fixed: 'left' */ }


                    , { field: '供应商', title: '供应商', width: 180, sort: true/*, fixed: 'left' */ }


                    , { field: '计划跟踪单号', title: '计划跟踪单号', sort: true, hide: true }


                    , { field: '物料代码', title: '物料代码', width: 180, sort: true }


                    , { field: '物料名称', title: '物料名称', width: 180, sort: true }


                    , { field: '规格型号', title: '规格型号', width: 180, sort: true }


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


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


                    , { field: '物料名称', title: '物料名称', width: 120, sort: true }


                    , { field: '规格型号', title: '规格型号', width: 120, sort: true }


                    , { field: '计量单位', title: '计量单位', width: 80, sort: true }


                    , { field: '数量', title: '订货数量', sort: true }


                    , { field: '交货地点', title: '交货地点', sort: true }


@@ -546,30 +548,32 @@


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


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


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


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


                //    sqlWhere += " and 物料编码 like ^^%" + $("#HShortNumber").val() + "%^^";


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


                    sqlWhere += " and 物料代码 like ^^%" + $("#HNumber").val() + "%^^";


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


                    sqlWhere += " and 物料名称 like ^^%" + $("#HName").val() + "%^^";


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


                    sqlWhere += " and 规格型号 like ^^%" + $("#HModel").val() + "%^^";


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


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


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


                    sqlWhere += " and 委外组织 like ^^%" + $("#HSUBORGID").val() + "%^^";


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


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


                }


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


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


                }


                if ($("#HISGenerate").val() != "") {


                    if ($("#HISGenerate").val() == "是") {


                        sqlWhere += " and 未关联数量 <= 0";


                    }


                    else if ($("#HISGenerate").val() == "否") {


                        sqlWhere += " and 未关联数量 > 0";


                    }


                }


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


                //    sqlWhere += " and 物料名称 like ^^%" + $("#HName").val() + "%^^";


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


                //    sqlWhere += " and 规格型号 like ^^%" + $("#HModel").val() + "%^^";


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


                //    sqlWhere += " and 关闭状态 like ^^%" + $("#HClStatus").val() + "%^^";


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


                //    sqlWhere += " and 委外组织 like ^^%" + $("#HSUBORGID").val() + "%^^";


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


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


                //}


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


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


                //}


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


                //    if ($("#HISGenerate").val() == "是") {


                //        sqlWhere += " and 未关联数量 <= 0";


                //    }


                //    else if ($("#HISGenerate").val() == "否") {


                //        sqlWhere += " and 未关联数量 > 0";


                //    }


                //}


                var Time = $("#Time").val();


                if (Time > 0) {


                    var dd = new Date();