提料计划报表 工艺路线和工序流转卡维护

yangle

2022-06-16 a5314811a903106011cece47a91da20c8bb0ce41

提料计划报表
工艺路线和工序流转卡维护

 WebTM/views/Éú²ú¹ÜÀí/Èռƻ®±¨±í/ReportPODemandPlanBillList.html

@@ -168,7 +168,7 @@
            //初始化表格
            set_InitGrid();
            //快速过滤
            //get_FastQuery(1);
            get_FastQuery(1);
        }
        //#endregion

@@ -180,29 +180,29 @@
            var MM = myDate.getMonth() + 1;
            var dd = myDate.getDate();
            var SumMonth = 31; //动态两月之差 new Date(yyyy, MM, 0).getDate()

            var MonthCount = new Date(yyyy, MM-1, 0).getDate();
        
            columns.push({ type: 'checkbox', fixed: 'left' });
            columns.push({ field: '单据号', title: '采购组织' });
            columns.push({ field: '销售订单号', title: '物料名称' });
            columns.push({ field: '销售订单号', title: '物料规格' });
            columns.push({ field: '销售订单号', title: '供应商' });
            columns.push({ field: '销售订单号', title: '合计' });
            columns.push({ field: '销售订单号', title: '采购订单号' });
            columns.push({ field: '销售订单号', title: '需求单号' });
            columns.push({ field: '销售订单号', title: '摘要' });
            columns.push({ field: '销售订单号', title: '备注' });
            columns.push({ field: '销售订单号', title: '采购员' });
            columns.push({ field: '销售订单号', title: '物料编码' });
            columns.push({ field: '销售订单号', title: '计量单位' });
            columns.push({ field: '销售订单号', title: '提料拖期数量' });
            for (var i = 0; i <= (SumMonth - dd); i++) {
            columns.push({ field: '组织', title: '采购组织' });
            columns.push({ field: '物料名称', title: '物料名称' });
            columns.push({ field: '规格型号', title: '物料规格' });
            columns.push({ field: '供应商', title: '供应商' });
            columns.push({ field: 'FSUMQTY', title: '合计' });
            columns.push({ field: 'HPOOrderBillNo', title: '采购订单号' });
            columns.push({ field: 'HSeOrderBillNo', title: '需求单号' });
            columns.push({ field: 'HPOOrderBillRemark', title: '摘要' });
            columns.push({ field: 'HPOOrderBillNote', title: '备注' });
            columns.push({ field: '采购员', title: '采购员' });
            columns.push({ field: '物料代码', title: '物料编码' });
            columns.push({ field: '计量单位名称', title: '计量单位' });
            columns.push({ field: 'TQSUM', title: '提料拖期数量' });
            for (var i = 1; i <= (MonthCount - dd); i++) {
                columns.push({ field: Format(yyyy + '/' + (MM - 1) + '/' + (dd + i), 'yyyy-MM-dd'), title: Format(yyyy + '/' + (MM - 1) + '/' + (dd + i), 'MM.dd'), edit: 'text', width: 70 })//0
            }
            for (var i = 1; i < dd; i++) {
            for (var i = 1; i <= (SumMonth - MonthCount + dd); i++) {
                columns.push({ field: Format(yyyy + '/' + MM + '/' + i, 'yyyy-MM-dd'), title: Format(yyyy + '/' + MM + '/' + i, 'MM.dd'), edit: 'text', width: 70 })//0
            }
            columns.push({ field: 'hmainid', title: '提料计划合计' });
            columns.push({ field: '', title: '提料计划合计' });

            option = {
                elem: '#mainTable'
@@ -215,7 +215,6 @@
                , loading: false
                , cols: [columns]
            };
            table.render(option);
        }
        //#endregion


 WebTM/views/Éú²ú¹ÜÀí/Éú²úÈռƻ®¹¤µ¥/JIT_DayPlanBillList.html

@@ -5,6 +5,7 @@
    <title>日计划工单列表</title>
    <link rel="stylesheet" href="../../../layuiadmin/layui/css/layui.css" media="all">
    <link rel="stylesheet" href="../../../layuiadmin/style/admin.css" media="all">
    <script src="../../../layuiadmin/zgqCustom/zgqCustom.js"></script>
    <script src="../../../layuiadmin/layui/layui.js"></script>
    <script src="../../../layuiadmin/Scripts/json2.js"></script>
    <script src="../../../layuiadmin/Scripts/jquery-1.4.1.js"></script>
@@ -50,11 +51,46 @@
                                </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">
                                    <!--其他条件-->
                                <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="HBTimes" name="HBTimes" id="HBTimes" style="padding-left: 78px;">
                                            </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="HETimes" name="HETimes" id="HETimes" style="padding-left: 78px;">
                                            </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">
                                            </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;">
                                                <input type="text" class="layui-input" name="HMaterNumber" id="HMaterNumber">
                                            </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="HSeOrderBillNo" id="HSeOrderBillNo">
                                            </div>
                                        </div>
                                    </div>
                                </div>
                            </div>
                        </div>

                        <table class="" id="mainTable" lay-filter="mainTable"></table>
                        <script type="text/html" id="toolbarDemo">
                            <div class="layui-btn-container">
@@ -152,6 +188,9 @@

        //#region åˆå§‹åŒ–界面
        function set_ClearBill() {
            //初始化日期
            $("#HBTimes").val(Format(new Date(new Date() - 1000 * 60 * 60 * 24 * 30), "yyyy-MM-dd"));//日期
            $("#HETimes").val(Format(new Date(), "yyyy-MM-dd"));//至
            //生产组织加载
            Organ();
            //初始化表格
@@ -269,6 +308,11 @@
            var HBillNo = $("#HBillNo").val();
            var Organization = $("#Organization").val();//采购组织
            var HWorkShopIDName = $("#HWorkShopIDName").val();//生产车间
            var HBTimes = $("#HBTimes").val();//日期
            var HETimes = $("#HETimes").val();//至
            var HMaterName = $("#HMaterName").val();//物料名称
            var HMaterNumber = $("#HMaterNumber").val();//物料编码
            var HSeOrderBillNo = $("#HSeOrderBillNo").val();//销售订单号

            if (HBillNo) {
                sWhere += " and å•æ®å· like '%" + HBillNo + "%'";
@@ -278,6 +322,18 @@
            }
            if (HWorkShopIDName) {
                sWhere += " and ç”Ÿäº§è½¦é—´ = '" + HWorkShopIDName + "'";
            }
            if (HBTimes != "" && HETimes!="") {
                sWhere += " and æ—¥æœŸ between '" + HBTimes + "' and '" + HETimes+"'  ";
            }
            if (HMaterName) {
                sWhere += " and ç‰©æ–™åç§° like'%" + HMaterName + "%'";
            }
            if (HMaterNumber) {
                sWhere += " and ç‰©æ–™ä»£ç  like'%" + HMaterNumber + "%'";
            }
            if (HSeOrderBillNo) {
                sWhere += " and é”€å”®è®¢å•å· like'%" + HSeOrderBillNo + "%'";
            }
            get_Display(sWhere);
            sWhere = "";//调用接口后清空sWhere缓存
@@ -290,6 +346,11 @@
            $("#Organization").val("");//采购组织
            $("#HWorkShopIDName").val("");//生产车间
            $("#HWorkShopID").val("");//生产车间
            $("#HBTimes").val(Format(new Date(new Date() - 1000 * 60 * 60 * 24 * 30), "yyyy-MM-dd"));//日期
            $("#HETimes").val(Format(new Date(), "yyyy-MM-dd"));//至
            $("#HMaterName").val("");//物料名称
            $("#HMaterNumber").val("");//物料编码
            $("#HSeOrderBillNo").val("");//销售订单号
            sWhere = "";
        }
        //#endregion

 WebTM/views/¼Æ»®¹ÜÀí/¹¤ÒÕ·Ïß/Gy_RoutingBill.html

@@ -451,7 +451,7 @@
                , "HPack": "", "HPutArea": "", "HMyWorkDays": 0, "HMyFixWorkDays": 0, "工序": ""
                , "HProcID": 0, "工作中心代码": "", "HCenterID": 0, "工作中心": "", "HSupID": 0
                , "供应商代码": "", "供应商": "", "HSupFlag": false, "HTimeUnit": "", "HUnitTime": 0
                , "HWorkQty": 0, "HPassRate": 0, "HOverRate": 0, "HReadyTime": 0, "HQueueTime": 0
                , "HWorkQty": 1, "HPassRate": 0, "HOverRate": 0, "HReadyTime": 0, "HQueueTime": 0
                , "HMoveTime": 0, "HNextProcFlag": false, "HFlowProc": false, "HSubStdEmpQty": 0, "HSubCanUseSourceQty": 0
                , "HFixPrice": 0, "HProcPrice": 0, "HBadPrice": 0, "HWasterPrice": 0, "HStdFlag": false
                , "HBeginDayQty": 0, "HBeginFixQty": 0, "HFixWorkDays": 0, "HTrunWorkDays": 0, "HReadyTimes": 0
@@ -715,7 +715,7 @@
                    , "HPack": "", "HPutArea": "", "HMyWorkDays": 0, "HMyFixWorkDays": 0, "工序": ""
                    , "HProcID": 0, "工作中心代码": "", "HCenterID": 0, "工作中心": "", "HSupID": 0
                    , "供应商代码": "", "供应商": "", "HSupFlag": false, "HTimeUnit": "", "HUnitTime": 0
                    , "HWorkQty": 0, "HPassRate": 0, "HOverRate": 0, "HReadyTime": 0, "HQueueTime": 0
                    , "HWorkQty": 1, "HPassRate": 0, "HOverRate": 0, "HReadyTime": 0, "HQueueTime": 0
                    , "HMoveTime": 0, "HNextProcFlag": false, "HFlowProc": false, "HSubStdEmpQty": 0, "HSubCanUseSourceQty": 0
                    , "HFixPrice": 0, "HProcPrice": 0, "HBadPrice": 0, "HWasterPrice": 0, "HStdFlag": false
                    , "HBeginDayQty": 0, "HBeginFixQty": 0, "HFixWorkDays": 0, "HTrunWorkDays": 0, "HReadyTimes": 0
@@ -1476,14 +1476,14 @@
                    layer.msg("产品代码没有选择");
                    return false;
                }
                if ($("#HUnitName").val() == "") {
                    layer.msg("计量单位没有选择");
                    return false;
                }
                if ($("#HMainProcIDName").val() == "") {
                    layer.msg("工序没有选择");
                    return false;
                }
                //if ($("#HUnitName").val() == "") {
                //    layer.msg("计量单位没有选择");
                //    return false;
                //}
                //if ($("#HMainProcIDName").val() == "") {
                //    layer.msg("工序没有选择");
                //    return false;
                //}
                if ($("#HMainCenterIDName").val() == "") {
                    layer.msg("工作中心没有选择");
                    return false;

 WebTM/views/³µ¼ä¹ÜÀí/¹¤ÐòÁ÷ת¿¨/Sc_ProcessExchangeBill.html

@@ -197,15 +197,21 @@
                                            </div>
                                        </div>
                                        <div class="layui-col-xs3 layui-inline">
                                            <label class="layui-form-label">项目编号</label>
                                            <label class="layui-form-label">选单号</label>
                                            <div class="layui-input-inline">
                                                <input type="text" class="layui-input" name="HProjectNum" id="HProjectNum" style="background-color:#efefef4d;" readonly>
                                                <input type="text" class="layui-input" name="textBox2" id="textBox2" style="float: left; width: 150px; background-color: #efefef4d; display: inline-block;" readonly>
                                                <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnSearchICMOBill" id="btnSearchICMOBill" style="width: 40px;">
                                                    <i class="layui-icon layui-icon-search layuiadmin-button-btn" style="margin-left:-9px;"></i>
                                                </button>
                                            </div>
                                        </div>
                                        <div class="layui-col-xs3 layui-inline">
                                            <label class="layui-form-label">版本</label>
                                            <label class="layui-form-label">工艺路线</label>
                                            <div class="layui-input-inline">
                                                <input type="text" class="layui-input" name="HVerNum" id="HVerNum" style="background-color:#efefef4d;" readonly>
                                                <input type="text" class="layui-input" name="RoutingBill" id="RoutingBill" style="float: left; width: 150px; background-color: #efefef4d; display: inline-block;" readonly>
                                                <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnRoutingBill" id="btnRoutingBill" style="width: 40px;">
                                                    <i class="layui-icon layui-icon-search layuiadmin-button-btn" style="margin-left:-9px;"></i>
                                                </button>
                                            </div>
                                        </div>
                                    </div>
@@ -217,11 +223,15 @@
                                            </div>
                                        </div>
                                        <div class="layui-col-xs3 layui-inline">
                                            <label class="layui-form-label">原料批次</label>
                                            <label class="layui-form-label">日计划工单选单号</label>
                                            <div class="layui-input-inline">
                                                <input type="text" class="layui-input" name="HMateOutBatchNo" id="HMateOutBatchNo" style="background-color:#efefef4d;" readonly>
                                                <input type="text" class="layui-input" name="WorkBillSortNo" id="WorkBillSortNo" style="float: left; width: 150px; background-color: #efefef4d; display: inline-block;" readonly>
                                                <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnSearchWorkBillSort" id="btnSearchWorkBillSort" style="width: 40px;">
                                                    <i class="layui-icon layui-icon-search layuiadmin-button-btn" style="margin-left:-9px;"></i>
                                                </button>
                                            </div>
                                        </div>
                                        
                                    </div>
                                </div>
                            </div>
@@ -240,14 +250,12 @@
                                            </div>
                                        </div>
                                        <div class="layui-col-xs3 layui-inline">
                                            <label class="layui-form-label">选单号</label>
                                            <label class="layui-form-label">项目编号</label>
                                            <div class="layui-input-inline">
                                                <input type="text" class="layui-input" name="textBox2" id="textBox2" style="float: left; width: 150px; background-color: #efefef4d; display: inline-block;" readonly>
                                                <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnSearchICMOBill" id="btnSearchICMOBill" style="width: 40px;">
                                                    <i class="layui-icon layui-icon-search layuiadmin-button-btn" style="margin-left:-9px;"></i>
                                                </button>
                                                <input type="text" class="layui-input" name="HProjectNum" id="HProjectNum" style="background-color:#efefef4d;" readonly>
                                            </div>
                                        </div>
                                       
                                        <div class="layui-col-xs3 layui-inline">
                                            <label class="layui-form-label">委外加工单位</label>
                                            <div class="layui-input-inline">
@@ -318,35 +326,30 @@
                                            </div>
                                        </div>
                                        <div class="layui-col-xs3 layui-inline">
                                            <label class="layui-form-label">日计划工单选单号</label>
                                            <label class="layui-form-label">原料批次</label>
                                            <div class="layui-input-inline">
                                                <input type="text" class="layui-input" name="WorkBillSortNo" id="WorkBillSortNo" style="float: left; width: 150px; background-color: #efefef4d; display: inline-block;" readonly>
                                                <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnSearchWorkBillSort" id="btnSearchWorkBillSort" style="width: 40px;">
                                                    <i class="layui-icon layui-icon-search layuiadmin-button-btn" style="margin-left:-9px;"></i>
                                                </button>
                                                <input type="text" class="layui-input" name="HMateOutBatchNo" id="HMateOutBatchNo" style="background-color:#efefef4d;" readonly>
                                            </div>
                                        </div>
                                        <!--<div class="layui-col-xs3 layui-inline">
                                            <label class="layui-form-label">流转卡类型</label>
                                            <div class="layui-input-inline">
                                                <input type="text" class="layui-input" name="HWorkTypeName" id="HWorkTypeName" style="float: left; width: 150px; background-color: #efefef4d; display: inline-block;" readonly>
                                                <input type="hidden" name="HWorkTypeID" id="HWorkTypeID" value="0">
                                                <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnSearchHWorkType" id="btnSearchHWorkType" style="width: 40px;">
                                                    <i class="layui-icon layui-icon-search layuiadmin-button-btn" style="margin-left:-9px;"></i>
                                                </button>
                                            </div>
                                        </div>-->
        <label class="layui-form-label">流转卡类型</label>
        <div class="layui-input-inline">
            <input type="text" class="layui-input" name="HWorkTypeName" id="HWorkTypeName" style="float: left; width: 150px; background-color: #efefef4d; display: inline-block;" readonly>
            <input type="hidden" name="HWorkTypeID" id="HWorkTypeID" value="0">
            <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnSearchHWorkType" id="btnSearchHWorkType" style="width: 40px;">
                <i class="layui-icon layui-icon-search layuiadmin-button-btn" style="margin-left:-9px;"></i>
            </button>
        </div>
    </div>-->
                                    </div>
                                    <div class="layui-row">
                                        <div class="layui-col-xs3 layui-inline">
                                            <label class="layui-form-label">工艺路线</label>
                                            <label class="layui-form-label">版本</label>
                                            <div class="layui-input-inline">
                                                <input type="text" class="layui-input" name="RoutingBill" id="RoutingBill" style="float: left; width: 150px; background-color: #efefef4d; display: inline-block;" readonly>
                                                <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnRoutingBill" id="btnRoutingBill" style="width: 40px;">
                                                    <i class="layui-icon layui-icon-search layuiadmin-button-btn" style="margin-left:-9px;"></i>
                                                </button>
                                                <input type="text" class="layui-input" name="HVerNum" id="HVerNum" style="background-color:#efefef4d;" readonly>
                                            </div>
                                        </div>
                                      
                                    </div>
                                </div>
                            </div>
@@ -1218,7 +1221,7 @@
                    type: 2//弹窗类型
                    , skin: 'layui-layer-rim' //加上边框
                    , area: ['90%', '90%']//大小
                    , title: '生产任务单列表'//标题
                    , title: '日计划工单列表'//标题
                    , shift: 2//弹出动画
                    , content: ['../../../views/生产管理/生产日计划工单/JIT_DayPlanBillList.html', 'yes']
                    , btn: ['确定', '取消']