duhe
2025-01-13 277aeae717d8413bbf83e34a2783129e3687ef34
宝工排产:去掉这个条件,显示所有已排产生产订单未关闭的
2个文件已修改
276 ■■■■ 已修改文件
WebTM/Properties/PublishProfiles/JFTM.pubxml.user 2 ●●● 补丁 | 查看 | 原始文档 | blame | 历史
WebTM/views/生产管理/宝工排产/JIT_DayPlanPlatForm.html 274 ●●●● 补丁 | 查看 | 原始文档 | blame | 历史
WebTM/Properties/PublishProfiles/JFTM.pubxml.user
@@ -4897,7 +4897,7 @@
      <publishTime>09/11/2024 21:05:00</publishTime>
    </File>
    <File Include="views/生产管理/宝工排产/JIT_DayPlanPlatForm.html">
      <publishTime>01/13/2025 10:24:27</publishTime>
      <publishTime>01/13/2025 10:50:50</publishTime>
    </File>
    <File Include="views/生产管理/工单/Sc_CurrentTicket.html">
      <publishTime>06/07/2024 15:42:08</publishTime>
WebTM/views/Éú²ú¹ÜÀí/±¦¹¤ÅŲú/JIT_DayPlanPlatForm.html
@@ -41,23 +41,6 @@
                                    </div>
                                </div>
                                <div class="layui-inline">
                                    <label class="layui-form-label" style="width: 85px;">开工起始日期</label>
                                    <div class="layui-input-block" style="margin-left: 120px;">
                                        <input type="date" class="layui-input" lay-verify="HPlanBeginDate" name="HPlanBeginDate" id="HPlanBeginDate" style="padding-left: 75px;">
                                    </div>
                                </div>
                                <div class="layui-inline">
                                    <label class="layui-form-label" style="width: 85px;">提料类型</label>
                                    <div class="layui-input-block" style="margin-left: 120px; width: 185px;">
                                        <select name="HTLType" id="HTLType" lay-verify="HTLType">
                                            <option value="缺料" selected="selected">缺料</option>
                                            <option value="生产用料清单">生产用料清单</option>
                                            <!--<option value="采购订单">采购订单</option> æš‚时没有-->
                                        </select>
                                    </div>
                                </div>
                                <div class="layui-inline">
                                    <label class="layui-form-label" style="width: 85px;padding: 9px 18px;">生产车间</label>
                                    <div class="layui-input-block" style="margin-left: 77px;">
                                        <input type="hidden" class="layui-input" lay-verify="HWorkShopID" name="HWorkShopID" id="HWorkShopID" value="0" style="background-color:#efefef4d;width: 60%;display: inline-block;" readonly>
@@ -67,44 +50,38 @@
                                        </button>
                                    </div>
                                </div>
                                <div class="layui-inline">
                                    <label class="layui-form-label" style="width: 85px;">生产订单组织</label>
                                    <div class="layui-input-block" style="margin-left: 120px; width: 185px;">
                                        <select name="HProdORGID" id="HProdORGID" lay-verify="HProdORGID">
                                            <!--动态渲染组织-->
                                        </select>
                                    </div>
                                </div>
                                <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnSearch" id="btnSearch">查询</button>
                                <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnReSearch" id="btnReSearch">重置</button>
                                <div class="layui-colla-content" style="padding: 0px; margin-left: 6%;">
                                    <div class="layui-row" style="margin-top:10px;">
                                        <div class="layui-inline">
                                            <label class="layui-form-label" style="width: 85px;">开工截止日期</label>
                                            <div class="layui-input-block" style="margin-left: 120px;">
                                                <input type="date" class="layui-input" lay-verify="HPlanEndDate" name="HPlanEndDate" id="HPlanEndDate" style="padding-left: 75px;">
                                            </div>
                                        </div>
                                        <div class="layui-inline">
                                            <label class="layui-form-label" style="width: 85px;padding: 9px 18px;">物料编码</label>
                                            <div class="layui-input-block" style="margin-left: 77px;">
                                                <input type="hidden" class="layui-input" lay-verify="HMaterID" name="HMaterID" id="HMaterID" value="0" style="background-color:#efefef4d;width: 60%;display: inline-block;" readonly>
                                                <input type="text" class="layui-input" lay-verify="HMaterNumber" name="HMaterNumber" id="HMaterNumber" value="" style="width: 60%;display: inline-block;">
                                                <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnHMaterID" id="btnHMaterID" style="padding: 0 10px;float: right;margin-right: 3px;">
                                                    <i class="layui-icon layui-icon-search layuiadmin-button-btn"></i>
                                                </button>
                                            </div>
                                        </div>
                                        <div class="layui-inline">
                                            <label class="layui-form-label" style="width: 85px;">预留数量</label>
                                            <div class="layui-input-block" style="margin-left: 120px;">
                                                <input type="text" class="layui-input" name="HBillNo" id="HBillNo">
                                            </div>
                                        </div>
                                    </div>
                                    <div class="layui-row" style="margin-top:10px;">
                                        <div class="layui-inline">
                                            <label class="layui-form-label" style="width: 85px;">生产订单号</label>
                                            <label class="layui-form-label" style="width: 85px;">锁定天数</label>
                                            <div class="layui-input-block" style="margin-left: 120px;">
                                                <input type="text" class="layui-input" name="HICMOBillNo" id="HICMOBillNo">
                                                <input type="text" class="layui-input" name="HLockedDay" id="HLockedDay" value="3">
                                            </div>
                                        </div>
                                        <div class="layui-inline">
                                            <label class="layui-form-label" style="width: 85px;">物料名称</label>
                                            <div class="layui-input-block" style="margin-left: 120px;">
                                                <input type="text" class="layui-input" name="HMaterName" id="HMaterName">
                                            <label class="layui-form-label" style="width: 85px;">提料类型</label>
                                            <div class="layui-input-block" style="margin-left: 120px; width: 185px;">
                                                <select name="HTLType" id="HTLType" lay-verify="HTLType">
                                                    <option value="缺料" selected="selected">缺料</option>
                                                    <option value="生产用料清单">生产用料清单</option>
                                                    <!--<option value="采购订单">采购订单</option> æš‚时没有-->
                                                </select>
                                            </div>
                                        </div>
                                        <div class="layui-inline">
@@ -117,17 +94,23 @@
                                            </div>
                                        </div>
                                    </div>
                                    <div class="layui-row" style="margin-top:10px;margin-bottom:10px;">
                                    <!--<div class="layui-row" style="margin-top:10px;">
                                        <div class="layui-inline">
                                            <label class="layui-form-label" style="width: 85px;">锁定天数</label>
                                            <label class="layui-form-label" style="width: 85px;">开工起始日期</label>
                                            <div class="layui-input-block" style="margin-left: 120px;">
                                                <input type="text" class="layui-input" name="HLockedDay" id="HLockedDay" value="3">
                                                <input type="date" class="layui-input" lay-verify="HPlanBeginDate" name="HPlanBeginDate" id="HPlanBeginDate" style="padding-left: 75px;">
                                            </div>
                                        </div>
                                        <div class="layui-inline">
                                            <label class="layui-form-label" style="width: 85px;">规格型号</label>
                                            <label class="layui-form-label" style="width: 85px;">开工截止日期</label>
                                            <div class="layui-input-block" style="margin-left: 120px;">
                                                <input type="text" class="layui-input" name="HMaterModel" id="HMaterModel">
                                                <input type="date" class="layui-input" lay-verify="HPlanEndDate" name="HPlanEndDate" id="HPlanEndDate" style="padding-left: 75px;">
                                            </div>
                                        </div>
                                        <div class="layui-inline">
                                            <label class="layui-form-label" style="width: 85px;">排产日期</label>
                                            <div class="layui-input-block" style="margin-left: 120px;">
                                                <input type="date" class="layui-input" lay-verify="HMastersDate" name="HMastersDate" id="HMastersDate" style="padding-left: 75px;">
                                            </div>
                                        </div>
                                        <div class="layui-inline">
@@ -136,20 +119,34 @@
                                                <input type="text" class="layui-input" name="HSeOrderBillNo" id="HSeOrderBillNo">
                                            </div>
                                        </div>
                                        <div class="layui-inline">
                                            <label class="layui-form-label" style="width: 85px;">生产订单号</label>
                                            <div class="layui-input-block" style="margin-left: 120px;">
                                                <input type="text" class="layui-input" name="HICMOBillNo" id="HICMOBillNo">
                                            </div>
                                        </div>
                                    </div>
                                    <div class="layui-row" style="margin-top:10px;">
                                        <div class="layui-inline">
                                            <label class="layui-form-label" style="width: 85px;">生产订单组织</label>
                                            <div class="layui-input-block" style="margin-left: 120px; width: 185px;">
                                                <select name="HProdORGID" id="HProdORGID" lay-verify="HProdORGID">
                                                    <!--动态渲染组织-->
                                                </select>
                                            <label class="layui-form-label" style="width: 85px;padding: 9px 18px;">物料编码</label>
                                            <div class="layui-input-block" style="margin-left: 77px;">
                                                <input type="hidden" class="layui-input" lay-verify="hmaterid" name="hmaterid" id="hmaterid" value="0" style="background-color:#efefef4d;width: 60%;display: inline-block;" readonly>
                                                <input type="text" class="layui-input" lay-verify="hmaternumber" name="hmaternumber" id="hmaternumber" value="" style="width: 60%;display: inline-block;">
                                                <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnhmaterid" id="btnhmaterid" style="padding: 0 10px;float: right;margin-right: 3px;">
                                                    <i class="layui-icon layui-icon-search layuiadmin-button-btn"></i>
                                                </button>
                                            </div>
                                        </div>
                                        <div class="layui-inline">
                                            <label class="layui-form-label" style="width: 85px;">排产日期</label>
                                            <label class="layui-form-label" style="width: 85px;">物料名称</label>
                                            <div class="layui-input-block" style="margin-left: 120px;">
                                                <input type="date" class="layui-input" lay-verify="HMastersDate" name="HMastersDate" id="HMastersDate" style="padding-left: 75px;">
                                                <input type="text" class="layui-input" name="HMaterName" id="HMaterName">
                                            </div>
                                        </div>
                                        <div class="layui-inline">
                                            <label class="layui-form-label" style="width: 85px;">规格型号</label>
                                            <div class="layui-input-block" style="margin-left: 120px;">
                                                <input type="text" class="layui-input" name="HMaterModel" id="HMaterModel">
                                            </div>
                                        </div>
                                    </div>
@@ -207,7 +204,6 @@
                                            <input type="text" class="layui-input ForFilteringSchemes" value="" name="ColContent1" id="ColContent1">
                                        </div>
                                    </div>
                                    <div class="layui-row" style=" margin-top: 10px; margin-left: 70px;">
                                        <div class="layui-inline">
                                            <label class="layui-form-label">过滤</label>
@@ -234,7 +230,7 @@
                                        <div class="layui-inline">
                                            <input type="text" class="layui-input ForFilteringSchemes" value="" name="ColContent2" id="ColContent2">
                                        </div>
                                    </div>
                                    </div>-->
                                </div>
                            </div>
                        </div>
@@ -1474,96 +1470,98 @@
            if (number == 1) {
                HProdORGID = sessionStorage["OrganizationID"];//生产订单组织
            }
            var HPlanBeginDate = $("#HPlanBeginDate").val();//开工起始日期
            var HPlanEndDate = $("#HPlanEndDate").val();//开工截止日期
            var HMastersDate = $("#HMastersDate").val();//排产日期
            var HSeOrderBillNo = $("#HSeOrderBillNo").val();//销售订单号
            var HMaterID = $("#HMaterID").val();//物料编码id
            var HICMOBillNo = $("#HICMOBillNo").val();//生产订单号
            var ColName = $("#ColName").val();//复选框
            var Comparator = $("#Comparator").val()
            var ColContent = $("#ColContent").val();
            var ColName1 = $("#ColName1").val();//复选框
            var Comparator1 = $("#Comparator1").val()
            var ColContent1 = $("#ColContent1").val();
            var ColName2 = $("#ColName2").val();//复选框
            var Comparator2 = $("#Comparator2").val()
            var ColContent2 = $("#ColContent2").val();
            //var HPlanBeginDate = $("#HPlanBeginDate").val();//开工起始日期
            //var HPlanEndDate = $("#HPlanEndDate").val();//开工截止日期
            //var HMastersDate = $("#HMastersDate").val();//排产日期
            //var HSeOrderBillNo = $("#HSeOrderBillNo").val();//销售订单号
            //var HMaterID = $("#HMaterID").val();//物料编码id
            //var HICMOBillNo = $("#HICMOBillNo").val();//生产订单号
            //var ColName = $("#ColName").val();//复选框
            //var Comparator = $("#Comparator").val()
            //var ColContent = $("#ColContent").val();
            //var ColName1 = $("#ColName1").val();//复选框
            //var Comparator1 = $("#Comparator1").val()
            //var ColContent1 = $("#ColContent1").val();
            //var ColName2 = $("#ColName2").val();//复选框
            //var Comparator2 = $("#Comparator2").val()
            //var ColContent2 = $("#ColContent2").val();
            var sWheres = "";
            if (ColName != 0 && Comparator != 0) {
                var com = "";
                switch (Comparator) {
                    case "7":
                        com = "like''%" + ColContent + "%''";
                        break;
                    case "8":
                        com = "like''%" + ColContent + "''";
                        break;
                    case "9":
                        com = "like''" + ColContent + "%''";
                        break;
                    case "10":
                        com = "not like''%" + ColContent + "%''";
                        break;
                    default:
                        com = "" + Comparator + "''" + ColContent + "''";
                        break;
                }
                sWheres += " and [" + ColName + "] " + com;
            }
            //if (ColName != 0 && Comparator != 0) {
            //    var com = "";
            //    switch (Comparator) {
            //        case "7":
            //            com = "like''%" + ColContent + "%''";
            //            break;
            //        case "8":
            //            com = "like''%" + ColContent + "''";
            //            break;
            //        case "9":
            //            com = "like''" + ColContent + "%''";
            //            break;
            //        case "10":
            //            com = "not like''%" + ColContent + "%''";
            //            break;
            //        default:
            //            com = "" + Comparator + "''" + ColContent + "''";
            //            break;
            //    }
            //    sWheres += " and [" + ColName + "] " + com;
            //}
            if (ColName1 != 0 && Comparator1 != 0) {
                var com1 = "";
                switch (Comparator1) {
                    case "7":
                        com1 = "like'%" + ColContent1 + "%'";
                        break;
                    case "8":
                        com1 = "like'%" + ColContent1 + "'";
                        break;
                    case "9":
                        com1 = "like'" + ColContent1 + "%'";
                        break;
                    case "10":
                        com1 = "not like'%" + ColContent1 + "%'";
                        break;
                    default:
                        com1 = "" + Comparator1 + "'" + ColContent1 + "'";
                        break;
                }
                sWhere += " and " + ColName1 + " " + com1;
            }
            if (ColName2 != 0 && Comparator2 != 0) {
                var com2 = "";
                switch (Comparator2) {
                    case "7":
                        com2 = "like'%" + ColContent2 + "%'";
                        break;
                    case "8":
                        com2 = "like'%" + ColContent2 + "'";
                        break;
                    case "9":
                        com2 = "like'" + ColContent2 + "%'";
                        break;
                    case "10":
                        com2 = "not like'%" + ColContent2 + "%'";
                        break;
                    default:
                        com2 = "" + Comparator + "'" + ColContent + "'";
                        break;
                }
                sWhere += " and " + ColName2 + " " + com2;
            }
            //if (ColName1 != 0 && Comparator1 != 0) {
            //    var com1 = "";
            //    switch (Comparator1) {
            //        case "7":
            //            com1 = "like'%" + ColContent1 + "%'";
            //            break;
            //        case "8":
            //            com1 = "like'%" + ColContent1 + "'";
            //            break;
            //        case "9":
            //            com1 = "like'" + ColContent1 + "%'";
            //            break;
            //        case "10":
            //            com1 = "not like'%" + ColContent1 + "%'";
            //            break;
            //        default:
            //            com1 = "" + Comparator1 + "'" + ColContent1 + "'";
            //            break;
            //    }
            //    sWhere += " and " + ColName1 + " " + com1;
            //}
            //if (ColName2 != 0 && Comparator2 != 0) {
            //    var com2 = "";
            //    switch (Comparator2) {
            //        case "7":
            //            com2 = "like'%" + ColContent2 + "%'";
            //            break;
            //        case "8":
            //            com2 = "like'%" + ColContent2 + "'";
            //            break;
            //        case "9":
            //            com2 = "like'" + ColContent2 + "%'";
            //            break;
            //        case "10":
            //            com2 = "not like'%" + ColContent2 + "%'";
            //            break;
            //        default:
            //            com2 = "" + Comparator + "'" + ColContent + "'";
            //            break;
            //    }
            //    sWhere += " and " + ColName2 + " " + com2;
            //}
            sWhere = {
                HPlanBeginDate: HPlanBeginDate
                HPlanBeginDate: '1900-01-01'                //HPlanBeginDate
                , HProdORGID: HProdORGID
                , HSeOrderBillNo: HSeOrderBillNo
                , HPlanEndDate: HPlanEndDate
                , HMaterID: HMaterID
                , HICMOBillNo: HICMOBillNo
                , HSeOrderBillNo: ''                        //HSeOrderBillNo
                , HPlanEndDate: '2500-01-01'                //HPlanEndDate
                , HMaterID: 0                               //HMaterID
                , HICMOBillNo: ''                           //HICMOBillNo
                , HWorkShopID: HWorkShopID
                , HMastersDate: HMastersDate
                , HMastersDate: ''                          //HMastersDate
                , sWheres: sWheres
            }
            get_Display(JSON.stringify(sWhere));