智云MES-UI前端
parent: e2285842 | 补丁 | 提交 | ignore whitespace
yusijie
2025-12-04 e61559db7c59266c1f467f606e00d4d1d4226fb2 
提料计划调整打开默认查询方法为get_FastQuery()；要料计划信息列表添加日期间隔过滤
2个文件已修改
86 ■■■■■ 已修改文件
WebTM/views/生产管理/日计划基础资料/Cg_PODemandPlanConfigBillList.html 3 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
WebTM/views/生产管理/日计划基础资料/JIT_NeedMaterPlanConfigBillList.html 83 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 
 WebTM/views/Éú²ú¹ÜÀí/Èռƻ®»ù´¡×ÊÁÏ/Cg_PODemandPlanConfigBillList.html


@@ -328,7 +328,8 @@


            //初始化表格


            set_InitGrid();


            //查询


            get_Display(sWhere);


            get_FastQuery();


            //get_Display(sWhere);






            ColFilter();




 WebTM/views/Éú²ú¹ÜÀí/Èռƻ®»ù´¡×ÊÁÏ/JIT_NeedMaterPlanConfigBillList.html


@@ -11,6 +11,7 @@


    <script src="../../../layuiadmin/Scripts/webConfig.js"></script>


    <script src="../../../layuiadmin/PubCustom.js"></script>


    <script src="../../../layuiadmin/soulTable.slim.js"></script>


    <script src="../../../layuiadmin/zgqCustom/zgqCustom.js"></script>


</head>


<body>


    <div class="layui-fluid">


@@ -23,6 +24,25 @@


                                <div class="layui-colla-title layui-inline">


                                    <div class="layui-inline">


                                        <span>更多</span>


                                    </div>


                                </div>


                                <div class="layui-inline">


                                    <label class="layui-form-label">日期间隔</label>


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


                                        <select name="HInitTimeCycle" id="HInitTimeCycle" class="ForFilteringSchemes" lay-filter="HInitTimeCycle" style="width:190px;">


                                        </select>


                                    </div>


                                </div>


                                <div class="layui-inline">


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


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


                                        <input type="date" class="layui-input ForFilteringSchemes" id="HBeginDate" style="width:190px;">


                                    </div>


                                </div>


                                <div class="layui-inline">


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


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


                                        <input type="date" class="layui-input ForFilteringSchemes" id="HEndDate" style="width:190px;">


                                    </div>


                                </div>


                                <div class="layui-inline">


@@ -259,7 +279,28 @@


                }


            });


        })


            //#endregion


        //#endregion




        //#region


        //日期间隔下拉列表监听


        form.on('select(HInitTimeCycle)', function (data) {


            var HInitTimeCycle = $("#HInitTimeCycle").val() * 1;


            //若日期间隔不为 ä»»æ„é—´éš”，则禁用开始日期与结束日期的选择


            if (HInitTimeCycle != -1) {


                $('#HBeginDate').prop('disabled', true);


                $('#HEndDate').prop('disabled', true);




                $("#HBeginDate").val(Format(new Date(new Date() - 1000 * 60 * 60 * 24 * HInitTimeCycle), "yyyy-MM-dd"));


                $("#HEndDate").val(Format(new Date(), "yyyy-MM-dd"));




                //执行查询方法


                get_FastQuery();


            } else {


                $('#HBeginDate').prop('disabled', false);


                $('#HEndDate').prop('disabled', false);


            }


        });


        //#endregion




        //#region è½¦é—´


        form.on('submit(btnHHWorkShopID)', function (data) {


@@ -291,6 +332,22 @@




        //#region åˆå§‹åŒ–界面


        function set_ClearBill() {


            //初始化日期间隔、开始日期、结束日期


            setSelect_HInitTimeCycle();


            //若日期间隔不为 ä»»æ„é—´éš”，则禁用开始日期与结束日期的选择


            var HInitTimeCycle = $("#HInitTimeCycle").val() * 1;


            if (HInitTimeCycle != -1) {


                $('#HBeginDate').prop('disabled', true);


                $('#HEndDate').prop('disabled', true);


            } else {


                $('#HBeginDate').prop('disabled', false);


                $('#HEndDate').prop('disabled', false);


            }




            //根据日期间隔设置开始时间与结束时间


            $("#HBeginDate").val(Format(new Date(new Date() - 1000 * 60 * 60 * 24 * HInitTimeCycle), "yyyy-MM-dd"));


            $("#HEndDate").val(Format(new Date(), "yyyy-MM-dd"));




            //初始化表格


            set_InitGrid();


            //查询


@@ -437,7 +494,23 @@


            });


        }




        //#region åˆå§‹æ—¥æœŸé—´éš” ä¸‹æ‹‰åˆ—表


        function setSelect_HInitTimeCycle() {


            var valueList = [0, 1, 2, 3, 4, 5, 6, 29];


            var titleList = ["今天", "近两天", "近三天", "近四天", "近五天", "近六天", "近七天", "近30天"];




            var HInitTimeCycle_ArrayList = '<option  value="-1" selected="selected" >任意间隔</option>';


            for (var i = 0; i < valueList.length; i++) {


                HInitTimeCycle_ArrayList += '<option  style="color:blue;" value="' + valueList[i] + '">' + titleList[i] + '</option>';


            }




            $("#HInitTimeCycle").empty();


            $("#HInitTimeCycle").append(HInitTimeCycle_ArrayList);


            form.render('select');




            $("#HInitTimeCycle").val("29");


        }


        //#endregion




        //隐藏列设置


        function get_HideColumn() {


@@ -567,6 +640,8 @@




        //#region å¿«é€Ÿè¿‡æ»¤


        function get_FastQuery() {


            var HDate = $("#HBeginDate").val();//开始日期


            var HDate1 = $("#HEndDate").val();//结束日期


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


            var HWorkShopIDName = $("#HWorkShopIDName").val();//车间


            var HMaterName = $("#HMaterName").val();//物料名称


@@ -646,6 +721,12 @@


                }


                sWhere += " and " + ColName2 + " " + com2;


            }


            if (HDate) {


                sWhere += " and CONVERT(varchar(100),日期, 23) >= '" + HDate + "'";


            }


            if (HDate1) {


                sWhere += " and CONVERT(varchar(100),日期, 23) <= '" + HDate1 + "'";


            }


            if (HBillNo) {


                sWhere += " and å•æ®å· like '%" + HBillNo + "%' ";


            }