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


@@ -8,6 +8,11 @@


    <meta name="viewport" content="width=device-width, initial-scale=1.0, minimum-scale=1.0, maximum-scale=1.0, user-scalable=0">


    <link rel="stylesheet" href="../../layuiadmin/layui/css/layui.css" media="all">


    <link rel="stylesheet" href="../../layuiadmin/style/admin.css" media="all">


    <style type="text/css">


        .layui-input-block {


            width: 200px;


        }


    </style>


</head>


<body>




@@ -45,31 +50,31 @@


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


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


                                    </div>


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


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


@@ -78,19 +83,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">


@@ -107,7 +112,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="">


@@ -115,8 +120,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="">


@@ -125,7 +130,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>


@@ -548,32 +553,32 @@


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


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


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


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


                //    sqlWhere += " and 物料编码 like ^^%" + $("#HShortNumber").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();