定时任务-增加同步气柜数据

zhanghl

2025-04-25 c9cda73c43f5914cbf57aa2d7c557d22a6cef40a

定时任务-增加同步气柜数据

 aps-modules/aps-core/src/main/java/com/aps/core/service/impl/ApsPlateProcessShopStatServiceImpl.java

@@ -319,7 +319,6 @@
            List<ApsPlateProcessShopPlanStat>  table= (List<ApsPlateProcessShopPlanStat>)stat.get("data");
            SXSSFSheet sheet = wb.getSheetAt(0);
            /*填写日期列 和 工时列*/

            SXSSFRow rowTitle = sheet.createRow(0);
            SXSSFCell mainPartNumberTitle = rowTitle.createCell(0);
            mainPartNumberTitle.setCellValue("主件料号");
@@ -341,41 +340,61 @@
            documentStatusTitle.setCellValue("单据状态");
            documentStatusTitle.setCellStyle(title);

            SXSSFCell workCenterTitle = rowTitle.createCell(5);
            SXSSFCell approveDateTitle = rowTitle.createCell(5);
            approveDateTitle.setCellValue("审核时间");
            approveDateTitle.setCellStyle(title);

            SXSSFCell workCenterTitle = rowTitle.createCell(6);
            workCenterTitle.setCellValue("当前工序");
            workCenterTitle.setCellStyle(title);

            SXSSFCell departmentTitle = rowTitle.createCell(6);
            SXSSFCell departmentTitle = rowTitle.createCell(7);
            departmentTitle.setCellValue("当前工序负责人");
            departmentTitle.setCellStyle(title);

            SXSSFCell nextProcessDeparmentTitle = rowTitle.createCell(7);
            SXSSFCell nextProcessTitle = rowTitle.createCell(8);
            nextProcessTitle.setCellValue("下一工序");
            nextProcessTitle.setCellStyle(title);


            SXSSFCell nextProcessDeparmentTitle = rowTitle.createCell(9);
            nextProcessDeparmentTitle.setCellValue("下一工序负责人");
            nextProcessDeparmentTitle.setCellStyle(title);

            SXSSFCell itemNumberTitle = rowTitle.createCell(8);
            SXSSFCell itemNumberTitle = rowTitle.createCell(10);
            itemNumberTitle.setCellValue("料号");
            itemNumberTitle.setCellStyle(title);

            SXSSFCell drawingNoTitle = rowTitle.createCell(9);
            SXSSFCell drawingNoTitle = rowTitle.createCell(11);
            drawingNoTitle.setCellValue("图号");
            drawingNoTitle.setCellStyle(title);

            SXSSFCell versionNumberTitle = rowTitle.createCell(10);
            SXSSFCell versionNumberTitle = rowTitle.createCell(12);
            versionNumberTitle.setCellValue("版本号");
            versionNumberTitle.setCellStyle(title);

            SXSSFCell productionQuantityTitle = rowTitle.createCell(11);
            SXSSFCell lowNumTitle = rowTitle.createCell(13);
            lowNumTitle.setCellValue("低阶码");
            lowNumTitle.setCellStyle(title);


            SXSSFCell productionQuantityTitle = rowTitle.createCell(14);
            productionQuantityTitle.setCellValue("生产数量");
            productionQuantityTitle.setCellStyle(title);

            SXSSFCell planEndDayTitle = rowTitle.createCell(12);
            planEndDayTitle.setCellValue("计划完工日");
            SXSSFCell planSendDateTitle = rowTitle.createCell(15);
            planSendDateTitle.setCellValue("工单计划下发时间");
            planSendDateTitle.setCellStyle(title);



            SXSSFCell planEndDayTitle = rowTitle.createCell(16);
            planEndDayTitle.setCellValue("系统完工时间");
            planEndDayTitle.setCellStyle(title);



            int i1 = 13;
            int i1 = 17;
            for (int i = 0; i < shopNames.size(); i++) {
                String shopName = shopNames.get(i);
                SXSSFCell beginDateCell = rowTitle.createCell(i * 2 + i1);
@@ -390,58 +409,74 @@
                ApsPlateProcessShopPlanStat plan = table.get(i);

                SXSSFRow dataRow  = sheet.createRow(i+1);

                //主件料号
                SXSSFCell mainPartNumberCell = dataRow.createCell(0);
                mainPartNumberCell.setCellValue(plan.getMainPartNumber());

                //mainPartNumberCell.setCellStyle(title);

                //业务类型;
                SXSSFCell businessTypeCell= dataRow.createCell(1);
                businessTypeCell.setCellValue(plan.getBusinessType());
                //businessTypeCell.setCellStyle(title);

                //单据号;
                SXSSFCell documentNumberCell = dataRow.createCell(2);
                documentNumberCell.setCellValue(plan.getDocumentNumber());
               // documentNumberCell.setCellStyle(title);

                //需求分类;
                SXSSFCell requirementTypeCell = dataRow.createCell(3);
                requirementTypeCell.setCellValue(plan.getRequirementType());
               // requirementTypeCell.setCellStyle(title);

                // 单据状态
                SXSSFCell documentStatusCell = dataRow.createCell(4);
                documentStatusCell.setCellValue(plan.getDocumentStatus());
               // documentStatusCell.setCellStyle(title);

                SXSSFCell workCenterCell = dataRow.createCell(5);

                // 审核时间
                SXSSFCell approveDateCell = dataRow.createCell(5);
                approveDateCell.setCellValue("");

                //当前工序
                SXSSFCell workCenterCell = dataRow.createCell(6);
                workCenterCell.setCellValue(plan.getWorkCenter());
               // workCenterCell.setCellStyle(title);

                SXSSFCell departmentCell = dataRow.createCell(6);
                //当前工序负责人;
                SXSSFCell departmentCell = dataRow.createCell(7);
                departmentCell.setCellValue(plan.getDepartment());

                SXSSFCell nextProcessDeparmentCell = dataRow.createCell(7);
                //下一工序
                SXSSFCell nextProcessCell = dataRow.createCell(8);
                nextProcessCell.setCellValue("");

                //下一工序工序负责人
                SXSSFCell nextProcessDeparmentCell = dataRow.createCell(9);
                nextProcessDeparmentCell.setCellValue(plan.getNextProcessDeparment());


                SXSSFCell itemNumberCell = dataRow.createCell(8);
                //料号
                SXSSFCell itemNumberCell = dataRow.createCell(10);
                itemNumberCell.setCellValue(plan.getItemNumber());
               // itemNumberCell.setCellStyle(title);

                SXSSFCell drawingNoCell = dataRow.createCell(9);
                // 图号
                SXSSFCell drawingNoCell = dataRow.createCell(11);
                drawingNoCell.setCellValue(plan.getDrawingNo());
               // drawingNoCell.setCellStyle(title);

                SXSSFCell versionNumberCell = dataRow.createCell(10);
               //版本号
                SXSSFCell versionNumberCell = dataRow.createCell(12);
                versionNumberCell.setCellValue(plan.getVersionNumber());
              //  versionNumberCell.setCellStyle(title);

                SXSSFCell productionQuantityCell = dataRow.createCell(11);
                //低阶码
                SXSSFCell lowNumCell = dataRow.createCell(13);
                lowNumCell.setCellValue("");

                //生产数量
                SXSSFCell productionQuantityCell = dataRow.createCell(14);
                productionQuantityCell.setCellValue(plan.getProductionQuantity().toString());
              //  productionQuantityCell.setCellStyle(title);

                SXSSFCell planEndDayCell = dataRow.createCell(12);
                //工单计划下发时间
                SXSSFCell planSendDateCell = dataRow.createCell(15);
                planSendDateCell.setCellValue("");

                //系统完工时间
                SXSSFCell planEndDayCell = dataRow.createCell(16);
                planEndDayCell.setCellValue(dateFormat.format(plan.getPlanEndDay()));
              //  planEndDayCell.setCellStyle(title);

                for (int j = 0; j< shopNames.size(); j++) {
                    String shopName = shopNames.get(j);
@@ -456,7 +491,7 @@

            }

            for (int i = 0; i < 24; i++) {
            for (int i = 0; i <  rowTitle.getLastCellNum(); i++) {

                sheet.setColumnWidth(i, 20 * 256);
            }