From a80b4a7eb099390bb53c967126fa97b30568e1a3 Mon Sep 17 00:00:00 2001 From: jinlin <jinlin> Date: 星期二, 01 四月 2025 10:01:38 +0800 Subject: [PATCH] 修改 --- src/main/java/com/example/client/service/Level1AddOrUpdate.java | 8 + src/main/java/com/example/client/service/TrackRecordAddOrUpdate.java | 10 + src/main/java/com/example/client/service/ImportDismantTrackService.java | 20 ++ src/main/resources/mapper/progressTrack/ImportRecord.xml | 2 src/main/java/com/example/client/service/DismantTrackAddOrUpdate.java | 5 src/main/java/com/example/client/service/HandoverAddOrUpdate.java | 8 + src/main/java/com/example/client/service/DataImportManageService.java | 6 src/main/resources/mapper/progressTrack/DjJdgzNetworkLevel3Dao.xml | 4 src/main/java/com/example/client/service/DataExportManageService.java | 7 src/main/java/com/example/client/service/Level2AddOrUpdate.java | 9 + src/main/java/com/example/client/service/TeamGroupAddOrUpdate.java | 7 src/main/java/com/example/client/service/DismantTrackService.java | 2 src/main/java/com/example/client/service/ImportDataService.java | 4 src/main/java/com/example/client/service/SubunitService.java | 2 src/main/java/com/example/client/service/TrackRecordManageService.java | 4 src/main/java/com/example/server/progressTrack/Dto/ReportRecordDto.java | 9 + src/main/java/com/example/server/entity/FieldMetaObjectHandler.java | 7 src/main/java/com/example/server/progressTrack/Dto/StatistReportsDto.java | 1 src/main/java/com/example/client/service/ImportLevel2Service.java | 20 ++ src/main/java/com/example/client/service/ImportLevel3Service.java | 22 ++ src/main/java/com/example/client/service/Level3ManageService.java | 4 src/main/java/com/example/client/service/StatisProductService.java | 2 src/main/java/com/example/client/service/SubunitAddOrUpdate.java | 61 ++++-- src/main/java/com/example/client/service/ShipManageService.java | 8 + src/main/resources/db/csiczb1.db | 0 src/main/java/com/example/client/service/UserAddOrUpdate.java | 7 src/main/java/com/example/server/progressTrack/dao/DjJdgzTrackRecordDao.java | 3 src/main/java/com/example/client/service/ImportTrackRecordService.java | 26 ++ src/main/java/com/example/server/progressTrack/service/DjJdgzTrackRecordService.java | 9 src/main/java/com/example/client/service/Level3View2Service.java | 3 src/main/java/com/example/client/service/StatisReportsService.java | 64 +++++++- src/main/java/com/example/server/DataSync/service/DataSyncService.java | 6 src/main/java/com/example/client/service/MenuService.java | 4 src/main/resources/mapper/user/UserDao.xml | 2 src/main/java/com/example/client/service/Level3AddOrUpdate.java | 8 + src/main/resources/mapper/progressTrack/DjJdgzTrackRecordDao.xml | 53 +++++- src/main/resources/application.yml | 3 src/main/java/com/example/server/user/model/SysUser.java | 2 src/main/resources/mapper/progressTrack/ExportRecord.xml | 2 39 files changed, 350 insertions(+), 74 deletions(-) diff --git a/src/main/java/com/example/client/service/DataExportManageService.java b/src/main/java/com/example/client/service/DataExportManageService.java index 29c0efa..21fd0fd 100644 --- a/src/main/java/com/example/client/service/DataExportManageService.java +++ b/src/main/java/com/example/client/service/DataExportManageService.java @@ -6,6 +6,8 @@ import com.example.server.DataSync.service.DataSyncService; import com.example.server.progressTrack.dao.ExportRecordDao; import com.example.server.progressTrack.model.ExportRecord; +import com.example.server.user.model.SysUser; +import com.example.server.utils.CacheUtils; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Service; @@ -76,6 +78,11 @@ btnExport.addActionListener(new ActionListener() { @Override public void actionPerformed(ActionEvent e) { + SysUser user = (SysUser) CacheUtils.get("user","user"); + if (user==null){ + JOptionPane.showMessageDialog(null, "鐢ㄦ埛澶辨晥璇烽��鍑哄苟閲嶆柊鐧诲綍", "鎻愮ず", JOptionPane.WARNING_MESSAGE); + return; + } dataSyncService.export(tips); } }); diff --git a/src/main/java/com/example/client/service/DataImportManageService.java b/src/main/java/com/example/client/service/DataImportManageService.java index c990685..e5180d3 100644 --- a/src/main/java/com/example/client/service/DataImportManageService.java +++ b/src/main/java/com/example/client/service/DataImportManageService.java @@ -9,6 +9,7 @@ import com.example.server.progressTrack.dao.ImportRecordDao; import com.example.server.progressTrack.model.ExportRecord; import com.example.server.progressTrack.model.ImportRecord; +import com.example.server.user.model.SysUser; import com.example.server.utils.CacheUtils; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.beans.factory.annotation.Value; @@ -37,6 +38,11 @@ private JTable table; public JPanel createTable(Integer width, Integer height, JFrame jFrame) { + SysUser user = (SysUser) CacheUtils.get("user","user"); + if (user==null){ + JOptionPane.showMessageDialog(null, "鐢ㄦ埛澶辨晥璇烽��鍑哄苟閲嶆柊鐧诲綍", "鎻愮ず", JOptionPane.WARNING_MESSAGE); + return null; + } JPanel panel = new JPanel(new BorderLayout()); panel.setPreferredSize(new Dimension(width-10,height)); diff --git a/src/main/java/com/example/client/service/DismantTrackAddOrUpdate.java b/src/main/java/com/example/client/service/DismantTrackAddOrUpdate.java index 82459a0..f8850a7 100644 --- a/src/main/java/com/example/client/service/DismantTrackAddOrUpdate.java +++ b/src/main/java/com/example/client/service/DismantTrackAddOrUpdate.java @@ -152,9 +152,14 @@ trackTable.getCellEditor().stopCellEditing(); } SysUser user = (SysUser) CacheUtils.get("user", "user"); + if (user == null) { + JOptionPane.showMessageDialog(null, "褰撳墠鐢ㄦ埛宸插け鏁堣閲嶆柊鐧诲綍", "鎻愮ず", JOptionPane.WARNING_MESSAGE); + return; + } if (user.getTeamgroup()==null||user.getTeamgroup().equals(nowLevel3.getTeamgroupId().toString())){ CommonTable.saveTableList(list, trackTable, columnDto); djJdgzDismantTrackService.save(list); + JOptionPane.showMessageDialog(null, "淇濆瓨鎴愬姛", "鎻愮ず", JOptionPane.WARNING_MESSAGE); }else{ JOptionPane.showMessageDialog(null, "褰撳墠鐢ㄦ埛涓嶅彲鎿嶄綔鍏朵粬涓撲笟鏁版嵁", "鎻愮ず", JOptionPane.WARNING_MESSAGE); } diff --git a/src/main/java/com/example/client/service/DismantTrackService.java b/src/main/java/com/example/client/service/DismantTrackService.java index 65d23d4..b4f85dd 100644 --- a/src/main/java/com/example/client/service/DismantTrackService.java +++ b/src/main/java/com/example/client/service/DismantTrackService.java @@ -62,7 +62,7 @@ JComboBoxItem[] teamList = sysTeamGroupClassService.getTeamList(null); JComboBoxItem[] cabinList = cabinService.getList(); String[] typeList = new String[]{ - "","鏀硅", "鍔犺", "鎹㈣", "鏀硅繘鎬т慨鐞�" + "","鏀硅", "鍔犺", "鎹㈣", "淇悊","鏀硅繘鎬т慨鐞�" }; List<DjJdgzShip> shipList = djJdgzShipService.getList(); Map<String, Long> shipMap = new HashMap<>(); diff --git a/src/main/java/com/example/client/service/HandoverAddOrUpdate.java b/src/main/java/com/example/client/service/HandoverAddOrUpdate.java index 51d282c..1106bfa 100644 --- a/src/main/java/com/example/client/service/HandoverAddOrUpdate.java +++ b/src/main/java/com/example/client/service/HandoverAddOrUpdate.java @@ -11,6 +11,8 @@ import com.example.server.progressTrack.service.DjJdgzNetworkLevel1Service; import com.example.server.progressTrack.service.DjJdgzTrackRecordService; import com.example.server.sysOss.model.SysOss; +import com.example.server.user.model.SysUser; +import com.example.server.utils.CacheUtils; import org.apache.commons.lang3.StringUtils; import org.jdesktop.swingx.JXDatePicker; import org.springframework.beans.factory.annotation.Autowired; @@ -175,6 +177,11 @@ saveButton.addActionListener(new ActionListener() { @Override public void actionPerformed(ActionEvent e) { + SysUser user = (SysUser) CacheUtils.get("user","user"); + if (user==null){ + JOptionPane.showMessageDialog(null, "鐢ㄦ埛澶辨晥璇烽��鍑哄苟閲嶆柊鐧诲綍", "鎻愮ず", JOptionPane.WARNING_MESSAGE); + return; + } JComboBoxItem project = (JComboBoxItem) comboBox.getSelectedItem(); data.setLevel1NetworkId(project.getId()); @@ -191,6 +198,7 @@ handoverManageService.tableModelListener(table,jFrame,list); frame1.dispose(); jFrame.setEnabled(true);//灏嗕富鐣岄潰鍐嶈缃负鍙搷浣滅殑 + JOptionPane.showMessageDialog(null, "淇濆瓨鎴愬姛", "鎻愮ず", JOptionPane.WARNING_MESSAGE); } }); diff --git a/src/main/java/com/example/client/service/ImportDataService.java b/src/main/java/com/example/client/service/ImportDataService.java index 11cd7b8..4d16e35 100644 --- a/src/main/java/com/example/client/service/ImportDataService.java +++ b/src/main/java/com/example/client/service/ImportDataService.java @@ -114,8 +114,8 @@ model.setDataVector(data, columnIdentifiers); table.setModel(model); - table.getColumnModel().getColumn(0).setPreferredWidth(600); - table.getColumnModel().getColumn(1).setPreferredWidth(100); + table.getColumnModel().getColumn(0).setPreferredWidth(550); + table.getColumnModel().getColumn(1).setPreferredWidth(150); table.getColumnModel().getColumn(0).setCellRenderer(new TableViewRenderer()); diff --git a/src/main/java/com/example/client/service/ImportDismantTrackService.java b/src/main/java/com/example/client/service/ImportDismantTrackService.java index fbd27a6..1aebb3f 100644 --- a/src/main/java/com/example/client/service/ImportDismantTrackService.java +++ b/src/main/java/com/example/client/service/ImportDismantTrackService.java @@ -5,6 +5,8 @@ import com.example.client.utils.*; import com.example.server.progressTrack.model.DjJdgzNetworkLevel3; import com.example.server.progressTrack.service.*; +import com.example.server.user.model.SysUser; +import com.example.server.utils.CacheUtils; import com.example.server.utils.DownLoadTmpFile; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.beans.factory.annotation.Value; @@ -137,10 +139,16 @@ return; } + SysUser user = (SysUser) CacheUtils.get("user","user"); + if (user==null){ + JOptionPane.showMessageDialog(null, "鐢ㄦ埛澶辨晥璇烽��鍑哄苟閲嶆柊鐧诲綍", "鎻愮ず", JOptionPane.WARNING_MESSAGE); + return ; + } + model.setDataVector(data, columnIdentifiers); table.setModel(model); - table.getColumnModel().getColumn(0).setPreferredWidth(600); - table.getColumnModel().getColumn(1).setPreferredWidth(100); + table.getColumnModel().getColumn(0).setPreferredWidth(550); + table.getColumnModel().getColumn(1).setPreferredWidth(150); table.getColumnModel().getColumn(0).setCellRenderer(new TableViewRenderer()); @@ -241,6 +249,14 @@ JOptionPane.showMessageDialog(null, "鍙兘涓婁紶.xlsx鎴�.xls鐨勬枃浠讹紝涓斾笉瓒呰繃2G\"", "鎻愮ず", JOptionPane.WARNING_MESSAGE); return flag; } + + SysUser user = (SysUser) CacheUtils.get("user","user"); + if (user==null){ + flag = false; + JOptionPane.showMessageDialog(null, "鐢ㄦ埛澶辨晥璇烽��鍑哄苟閲嶆柊鐧诲綍", "鎻愮ず", JOptionPane.WARNING_MESSAGE); + return flag; + } + model.setDataVector(data, columnIdentifiers); table.setModel(model); table.getColumnModel().getColumn(0).setPreferredWidth(650); diff --git a/src/main/java/com/example/client/service/ImportLevel2Service.java b/src/main/java/com/example/client/service/ImportLevel2Service.java index 6cca234..64cee0f 100644 --- a/src/main/java/com/example/client/service/ImportLevel2Service.java +++ b/src/main/java/com/example/client/service/ImportLevel2Service.java @@ -6,6 +6,8 @@ import com.example.server.progressTrack.model.DjJdgzNetworkLevel1; import com.example.server.progressTrack.model.DjJdgzNetworkLevel2List; import com.example.server.progressTrack.service.DjJdgzNetworkLevel2ListService; +import com.example.server.user.model.SysUser; +import com.example.server.utils.CacheUtils; import com.mxgraph.view.mxGraph; import org.apache.commons.lang3.StringUtils; import org.apache.poi.hssf.usermodel.HSSFWorkbook; @@ -131,10 +133,16 @@ return; } + SysUser user = (SysUser) CacheUtils.get("user","user"); + if (user==null){ + JOptionPane.showMessageDialog(null, "鐢ㄦ埛澶辨晥璇烽��鍑哄苟閲嶆柊鐧诲綍", "鎻愮ず", JOptionPane.WARNING_MESSAGE); + return; + } + model.setDataVector(data, columnIdentifiers); table.setModel(model); - table.getColumnModel().getColumn(0).setPreferredWidth(600); - table.getColumnModel().getColumn(1).setPreferredWidth(100); + table.getColumnModel().getColumn(0).setPreferredWidth(550); + table.getColumnModel().getColumn(1).setPreferredWidth(150); table.getColumnModel().getColumn(0).setCellRenderer(new TableViewRenderer()); @@ -236,6 +244,14 @@ JOptionPane.showMessageDialog(null, "鍙兘涓婁紶.xlsx鎴�.xls鐨勬枃浠讹紝涓斾笉瓒呰繃2G\"", "鎻愮ず", JOptionPane.WARNING_MESSAGE); return flag; } + + SysUser user = (SysUser) CacheUtils.get("user","user"); + if (user==null){ + flag = false; + JOptionPane.showMessageDialog(null, "鐢ㄦ埛澶辨晥璇烽��鍑哄苟閲嶆柊鐧诲綍", "鎻愮ず", JOptionPane.WARNING_MESSAGE); + return flag; + } + model.setDataVector(data, columnIdentifiers); table.setModel(model); table.getColumnModel().getColumn(0).setPreferredWidth(650); diff --git a/src/main/java/com/example/client/service/ImportLevel3Service.java b/src/main/java/com/example/client/service/ImportLevel3Service.java index a685101..3f25be0 100644 --- a/src/main/java/com/example/client/service/ImportLevel3Service.java +++ b/src/main/java/com/example/client/service/ImportLevel3Service.java @@ -7,6 +7,8 @@ import com.example.server.progressTrack.model.DjJdgzNetworkLevel3; import com.example.server.progressTrack.service.*; import com.example.server.teamGroup.service.SysTeamGroupClassService; +import com.example.server.user.model.SysUser; +import com.example.server.utils.CacheUtils; import com.example.server.utils.DownLoadTmpFile; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.beans.factory.annotation.Value; @@ -239,10 +241,16 @@ return; } + SysUser user = (SysUser) CacheUtils.get("user","user"); + if (user==null){ + JOptionPane.showMessageDialog(null, "鐢ㄦ埛澶辨晥璇烽��鍑哄苟閲嶆柊鐧诲綍", "鎻愮ず", JOptionPane.WARNING_MESSAGE); + return; + } + model.setDataVector(data, columnIdentifiers); table.setModel(model); - table.getColumnModel().getColumn(0).setPreferredWidth(600); - table.getColumnModel().getColumn(1).setPreferredWidth(100); + table.getColumnModel().getColumn(0).setPreferredWidth(550); + table.getColumnModel().getColumn(1).setPreferredWidth(150); table.getColumnModel().getColumn(0).setCellRenderer(new TableViewRenderer()); @@ -295,7 +303,7 @@ JComboBoxItem[] teamList = sysTeamGroupClassService.getTeamList(null); JComboBoxItem[] cabinList = cabinService.getList(); String[] typeList = new String[]{ - "鏀硅", "鍔犺", "鎹㈣", "鏀硅繘鎬т慨鐞�","" + "","鏀硅", "鍔犺", "鎹㈣", "淇悊","鏀硅繘鎬т慨鐞�" }; List<DjJdgzNetworkLevel3> list = level3Service.getList(null, deptList[0].getId(), teamList[0].getId(), cabinList[0].getId(), typeList[0],null); CommonTable.refreshTable(list, columnDto, subTable); @@ -351,6 +359,14 @@ JOptionPane.showMessageDialog(null, "鍙兘涓婁紶.xlsx鎴�.xls鐨勬枃浠讹紝涓斾笉瓒呰繃2G\"", "鎻愮ず", JOptionPane.WARNING_MESSAGE); return flag; } + + SysUser user = (SysUser) CacheUtils.get("user","user"); + if (user==null){ + flag = false; + JOptionPane.showMessageDialog(null, "鐢ㄦ埛澶辨晥璇烽��鍑哄苟閲嶆柊鐧诲綍", "鎻愮ず", JOptionPane.WARNING_MESSAGE); + return flag; + } + model.setDataVector(data, columnIdentifiers); table.setModel(model); table.getColumnModel().getColumn(0).setPreferredWidth(650); diff --git a/src/main/java/com/example/client/service/ImportTrackRecordService.java b/src/main/java/com/example/client/service/ImportTrackRecordService.java index 2d8bb90..a84efa9 100644 --- a/src/main/java/com/example/client/service/ImportTrackRecordService.java +++ b/src/main/java/com/example/client/service/ImportTrackRecordService.java @@ -7,7 +7,10 @@ import com.example.server.progressTrack.model.DjJdgzTrackRecord; import com.example.server.progressTrack.service.*; import com.example.server.teamGroup.service.SysTeamGroupClassService; +import com.example.server.user.model.SysUser; +import com.example.server.utils.CacheUtils; import com.example.server.utils.DownLoadTmpFile; +import org.apache.commons.lang3.StringUtils; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.beans.factory.annotation.Value; import org.springframework.stereotype.Service; @@ -179,6 +182,9 @@ for (JComboBoxItem item : selectedItems) { selectedIds.append(item.getId()).append(","); } + if (StringUtils.isNotBlank(selectedIds)){ + selectedIds.deleteCharAt(selectedIds.length()-1); + } List<DjJdgzTrackRecord> list = djJdgzTrackRecordService.getListByImport(level1Id,level2Id,level2NodeId,selectedIds.toString()); DownLoadTmpFile.buildTrack(list,tmpPath + "璺熻釜璁板綍瀵煎叆妯℃澘.xlsx", frame); } @@ -263,10 +269,16 @@ return; } + SysUser user = (SysUser) CacheUtils.get("user","user"); + if (user==null){ + JOptionPane.showMessageDialog(null, "鐢ㄦ埛澶辨晥璇烽��鍑哄苟閲嶆柊鐧诲綍", "鎻愮ず", JOptionPane.WARNING_MESSAGE); + return; + } + model.setDataVector(data, columnIdentifiers); table.setModel(model); - table.getColumnModel().getColumn(0).setPreferredWidth(600); - table.getColumnModel().getColumn(1).setPreferredWidth(100); + table.getColumnModel().getColumn(0).setPreferredWidth(550); + table.getColumnModel().getColumn(1).setPreferredWidth(150); table.getColumnModel().getColumn(0).setCellRenderer(new TableViewRenderer()); @@ -319,7 +331,7 @@ JComboBoxItem[] teamList = sysTeamGroupClassService.getTeamList(null); JComboBoxItem[] cabinList = cabinService.getList(); String[] typeList = new String[]{ - "","鏀硅", "鍔犺", "鎹㈣", "鏀硅繘鎬т慨鐞�" + "","鏀硅", "鍔犺", "鎹㈣", "淇悊","鏀硅繘鎬т慨鐞�" }; List<DjJdgzTrackRecord> list = djJdgzTrackRecordService.getList(level1Id[0], deptList[0].getId(), teamList[0].getId(), cabinList[0].getId(), typeList[0], 0, null); CommonTable.refreshTable(list, columnDto, subTable); @@ -375,6 +387,14 @@ JOptionPane.showMessageDialog(null, "鍙兘涓婁紶.xlsx鎴�.xls鐨勬枃浠讹紝涓斾笉瓒呰繃2G\"", "鎻愮ず", JOptionPane.WARNING_MESSAGE); return flag; } + + SysUser user = (SysUser) CacheUtils.get("user","user"); + if (user==null){ + flag = false; + JOptionPane.showMessageDialog(null, "鐢ㄦ埛澶辨晥璇烽��鍑哄苟閲嶆柊鐧诲綍", "鎻愮ず", JOptionPane.WARNING_MESSAGE); + return flag; + } + model.setDataVector(data, columnIdentifiers); table.setModel(model); table.getColumnModel().getColumn(0).setPreferredWidth(650); diff --git a/src/main/java/com/example/client/service/Level1AddOrUpdate.java b/src/main/java/com/example/client/service/Level1AddOrUpdate.java index c6f34df..8faca10 100644 --- a/src/main/java/com/example/client/service/Level1AddOrUpdate.java +++ b/src/main/java/com/example/client/service/Level1AddOrUpdate.java @@ -7,6 +7,8 @@ import com.example.server.progressTrack.model.DjJdgzNetworkLevel1List; import com.example.server.progressTrack.service.DjJdgzNetworkLevel1ListService; import com.example.server.progressTrack.service.NetWorkDiagramService; +import com.example.server.user.model.SysUser; +import com.example.server.utils.CacheUtils; import com.mxgraph.swing.mxGraphComponent; import com.mxgraph.view.mxGraph; import org.apache.poi.ss.usermodel.HorizontalAlignment; @@ -159,11 +161,17 @@ btnSave.addActionListener(new ActionListener() { @Override public void actionPerformed(ActionEvent e) { + SysUser user = (SysUser) CacheUtils.get("user","user"); + if (user==null){ + JOptionPane.showMessageDialog(null, "鐢ㄦ埛澶辨晥璇烽��鍑哄苟閲嶆柊鐧诲綍", "鎻愮ず", JOptionPane.WARNING_MESSAGE); + return; + } if (subTable.isEditing()) { subTable.getCellEditor().stopCellEditing(); } CommonTable.saveTableList(list,subTable,columnDto); level1ListService.save(list,data.getId(),diagram, finalGraph1); + JOptionPane.showMessageDialog(null, "淇濆瓨鎴愬姛", "鎻愮ず", JOptionPane.WARNING_MESSAGE); } }); } diff --git a/src/main/java/com/example/client/service/Level2AddOrUpdate.java b/src/main/java/com/example/client/service/Level2AddOrUpdate.java index 90bc52b..5aee1a8 100644 --- a/src/main/java/com/example/client/service/Level2AddOrUpdate.java +++ b/src/main/java/com/example/client/service/Level2AddOrUpdate.java @@ -9,6 +9,8 @@ import com.example.server.progressTrack.model.DjJdgzNetworkLevel2; import com.example.server.progressTrack.model.DjJdgzNetworkLevel2List; import com.example.server.progressTrack.service.*; +import com.example.server.user.model.SysUser; +import com.example.server.utils.CacheUtils; import com.mxgraph.swing.mxGraphComponent; import com.mxgraph.view.mxGraph; import org.apache.commons.lang3.StringUtils; @@ -202,11 +204,18 @@ btnSave.addActionListener(new ActionListener() { @Override public void actionPerformed(ActionEvent e) { + SysUser user = (SysUser) CacheUtils.get("user","user"); + if (user==null){ + JOptionPane.showMessageDialog(null, "鐢ㄦ埛澶辨晥璇烽��鍑哄苟閲嶆柊鐧诲綍", "鎻愮ず", JOptionPane.WARNING_MESSAGE); + return; + } if (subTable.isEditing()) { subTable.getCellEditor().stopCellEditing(); } CommonTable.saveTableList(list,subTable,columnDto); level2ListService.save(list,data.getId(),diagram, finalGraph); + JOptionPane.showMessageDialog(null, "淇濆瓨鎴愬姛", "鎻愮ず", JOptionPane.WARNING_MESSAGE); + } }); diff --git a/src/main/java/com/example/client/service/Level3AddOrUpdate.java b/src/main/java/com/example/client/service/Level3AddOrUpdate.java index 85ebd59..3031d43 100644 --- a/src/main/java/com/example/client/service/Level3AddOrUpdate.java +++ b/src/main/java/com/example/client/service/Level3AddOrUpdate.java @@ -12,6 +12,8 @@ import com.example.server.progressTrack.service.DjJdgzNetworkLevel3ListService; import com.example.server.progressTrack.service.NetWorkDiagramService; import com.example.server.teamGroup.service.SysTeamGroupClassService; +import com.example.server.user.model.SysUser; +import com.example.server.utils.CacheUtils; import com.mxgraph.swing.mxGraphComponent; import com.mxgraph.view.mxGraph; import org.springframework.beans.factory.annotation.Autowired; @@ -161,11 +163,17 @@ btnSave.addActionListener(new ActionListener() { @Override public void actionPerformed(ActionEvent e) { + SysUser user = (SysUser) CacheUtils.get("user","user"); + if (user==null){ + JOptionPane.showMessageDialog(null, "鐢ㄦ埛澶辨晥璇烽��鍑哄苟閲嶆柊鐧诲綍", "鎻愮ず", JOptionPane.WARNING_MESSAGE); + return; + } if (subTable.isEditing()) { subTable.getCellEditor().stopCellEditing(); } CommonTable.saveTableList(finalList, subTable, columnDto); level3ListService.save(finalList, data.getId(), diagram, finalGraph1); + JOptionPane.showMessageDialog(null, "淇濆瓨鎴愬姛", "鎻愮ず", JOptionPane.WARNING_MESSAGE); } }); diff --git a/src/main/java/com/example/client/service/Level3ManageService.java b/src/main/java/com/example/client/service/Level3ManageService.java index bdbb552..4558479 100644 --- a/src/main/java/com/example/client/service/Level3ManageService.java +++ b/src/main/java/com/example/client/service/Level3ManageService.java @@ -78,7 +78,7 @@ JComboBoxItem[] cabinList = cabinService.getList(); JComboBoxItem[] deptList = sysTeamGroupClassService.getDeptList(); String[] typeList = new String[]{ - "","鏀硅", "鍔犺", "鎹㈣", "鏀硅繘鎬т慨鐞�" + "","鏀硅", "鍔犺", "鎹㈣", "淇悊","鏀硅繘鎬т慨鐞�" }; JLabel JLabel0 = new JLabel("宸ョ▼"); @@ -330,7 +330,7 @@ JComboBoxItem[] cabinList = cabinService.getList(); JComboBoxItem[] teamList = sysTeamGroupClassService.getTeamList(null); String[] typeList = new String[]{ - "","鏀硅", "鍔犺", "鎹㈣", "鏀硅繘鎬т慨鐞�" + "","鏀硅", "鍔犺", "鎹㈣", "淇悊","鏀硅繘鎬т慨鐞�" }; JLabel JLabel1 = new JLabel("宸ョ▼"); diff --git a/src/main/java/com/example/client/service/Level3View2Service.java b/src/main/java/com/example/client/service/Level3View2Service.java index dee2b1c..548b587 100644 --- a/src/main/java/com/example/client/service/Level3View2Service.java +++ b/src/main/java/com/example/client/service/Level3View2Service.java @@ -63,7 +63,7 @@ JComboBoxItem[] cabinList = cabinService.getList(); JComboBoxItem[] deptList = sysTeamGroupClassService.getDeptList(); String[] typeList = new String[]{ - "","鏀硅", "鍔犺", "鎹㈣", "鏀硅繘鎬т慨鐞�" + "","鏀硅", "鍔犺", "鎹㈣", "淇悊","鏀硅繘鎬т慨鐞�" }; JLabel JLabel0 = new JLabel("宸ョ▼"); @@ -291,6 +291,7 @@ } }); + table.setEnabled(false); JScrollPane scrollPane = new JScrollPane(table, JScrollPane.VERTICAL_SCROLLBAR_ALWAYS, JScrollPane.HORIZONTAL_SCROLLBAR_ALWAYS); scrollPane.setViewportView(table); scrollPane.getViewport().setBackground(Color.WHITE); diff --git a/src/main/java/com/example/client/service/MenuService.java b/src/main/java/com/example/client/service/MenuService.java index 7adb7ef..0716926 100644 --- a/src/main/java/com/example/client/service/MenuService.java +++ b/src/main/java/com/example/client/service/MenuService.java @@ -121,7 +121,9 @@ } } else if (nodeName.equals("鏁版嵁瀵煎叆")) { JPanel dataImport = dataImportManageService.createTable(width, height, frame); - main.showTab("鏁版嵁瀵煎叆", dataImport, tree); + if(dataImport!=null){ + main.showTab("鏁版嵁瀵煎叆", dataImport, tree); + } } else if (nodeName.equals("鏁版嵁瀵煎嚭")) { JPanel dataExport = dataExportManageService.createTable(width, height, frame); main.showTab("鏁版嵁瀵煎嚭", dataExport, tree); diff --git a/src/main/java/com/example/client/service/ShipManageService.java b/src/main/java/com/example/client/service/ShipManageService.java index 55bfd9c..eeabd81 100644 --- a/src/main/java/com/example/client/service/ShipManageService.java +++ b/src/main/java/com/example/client/service/ShipManageService.java @@ -11,6 +11,8 @@ import com.example.server.progressTrack.model.DjJdgzShip; import com.example.server.progressTrack.service.DjJdgzNetworkLevel1Service; import com.example.server.progressTrack.service.DjJdgzShipService; +import com.example.server.user.model.SysUser; +import com.example.server.utils.CacheUtils; import org.jdesktop.swingx.JXDatePicker; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Service; @@ -99,11 +101,17 @@ btnSave.addActionListener(new ActionListener() { @Override public void actionPerformed(ActionEvent e) { + SysUser user = (SysUser) CacheUtils.get("user","user"); + if (user==null){ + JOptionPane.showMessageDialog(null, "鐢ㄦ埛澶辨晥璇烽��鍑哄苟閲嶆柊鐧诲綍", "鎻愮ず", JOptionPane.WARNING_MESSAGE); + return; + } if (table.isEditing()) { table.getCellEditor().stopCellEditing(); } CommonTable.saveTableList(shipList,table,columnDto); djJdgzShipService.save(shipList); + JOptionPane.showMessageDialog(null, "淇濆瓨鎴愬姛", "鎻愮ず", JOptionPane.WARNING_MESSAGE); } }); diff --git a/src/main/java/com/example/client/service/StatisProductService.java b/src/main/java/com/example/client/service/StatisProductService.java index f991dbc..51bd380 100644 --- a/src/main/java/com/example/client/service/StatisProductService.java +++ b/src/main/java/com/example/client/service/StatisProductService.java @@ -45,7 +45,7 @@ StatistProductDto data =list.get(i); body[i][0] = data.getName(); body[i][1] = String.valueOf(data.getCxsl()); - body[i][2] = String.valueOf(data.getFcsl()); + body[i][2] = String.valueOf(data.getFjsl()); body[i][3] = String.valueOf(data.getJdsl()); body[i][4] = String.valueOf(data.getFcsl()); body[i][5] = String.valueOf(data.getHzsl()); diff --git a/src/main/java/com/example/client/service/StatisReportsService.java b/src/main/java/com/example/client/service/StatisReportsService.java index 80206a9..0a8033f 100644 --- a/src/main/java/com/example/client/service/StatisReportsService.java +++ b/src/main/java/com/example/client/service/StatisReportsService.java @@ -4,10 +4,13 @@ import com.example.client.model.TableButton; import com.example.client.utils.CommonTable; import com.example.client.utils.ComplexTable; +import com.example.client.utils.Compute; +import com.example.server.progressTrack.Dto.ReportRecordDto; import com.example.server.progressTrack.Dto.StatistReportsDto; import com.example.server.progressTrack.model.DjJdgzNetworkLevel1; import com.example.server.progressTrack.model.DjJdgzNetworkLevel1List; import com.example.server.progressTrack.model.DjJdgzShip; +import com.example.server.progressTrack.model.DjJdgzTrackRecord; import com.example.server.progressTrack.service.DjJdgzNetworkLevel1Service; import com.example.server.progressTrack.service.DjJdgzShipService; import com.example.server.progressTrack.service.DjJdgzTrackRecordService; @@ -29,9 +32,8 @@ @Autowired private DjJdgzTrackRecordService djJdgzTrackRecordService; - private JTable table; - public void createTable(JFrame jFrame,Long level1NetworkId) { + public void createTable(JFrame jFrame, Long level1NetworkId) { JFrame frame1 = new JFrame("缁熻鎶ヨ〃"); frame1.setSize(1200, 700); frame1.setResizable(false); @@ -46,7 +48,6 @@ } }); - List<ColumnDto> columnDto = new ArrayList<>(); List<StatistReportsDto> list = djJdgzTrackRecordService.getReport(level1NetworkId); //columnDto.add(new ColumnDto("ID", "id", -1, null,false)); @@ -69,16 +70,15 @@ //frame1.add(scrollTable); - Object[][] headerRows = new Object[2][7]; - headerRows[0] = new Object[]{"鐝粍涓撲笟","椤圭洰鎬绘暟","鏈畬鎴�",ComplexTable.mergeCellX,ComplexTable.mergeCellX,"宸插畬鎴�",ComplexTable.mergeCellX}; + headerRows[0] = new Object[]{"鐝粍涓撲笟", "椤圭洰鎬绘暟", "鏈畬鎴�", ComplexTable.mergeCellX, ComplexTable.mergeCellX, "宸插畬鎴�", ComplexTable.mergeCellX}; //姝ゅ2-5鏄笉浼氭樉绀哄嚭鏉ョ殑锛屽洜涓�1-4鍚戜笅鍚堝苟浜嗕竴琛� + 鍚戝彸鍚堝苟浜嗕竴鍒� 锛� 鑰�2-5琚繖涓煩褰㈣寖鍥村寘鎷簡 - headerRows[1] = new Object[]{ComplexTable.mergeCellY, ComplexTable.mergeCellY ,"杩涜涓�","涓存湡","閫炬湡","姝e父瀹屾垚","瓒呮湡瀹屾垚"}; + headerRows[1] = new Object[]{ComplexTable.mergeCellY, ComplexTable.mergeCellY, "杩涜涓�", "涓存湡", "閫炬湡", "姝e父瀹屾垚", "瓒呮湡瀹屾垚"}; String[][] body = new String[list.size()][7]; for (int i = 0; i < list.size(); i++) { - StatistReportsDto data =list.get(i); + StatistReportsDto data = list.get(i); body[i][0] = data.getTeamGroupName(); body[i][1] = String.valueOf(data.getAllNum()); body[i][2] = String.valueOf(data.getJxzNum()); @@ -87,12 +87,60 @@ body[i][5] = String.valueOf(data.getZcwcNum()); body[i][6] = String.valueOf(data.getCqwcNum()); } + ComplexTable complexTable = new ComplexTable(headerRows, body, 171); + JScrollPane scrollTable = new JScrollPane(complexTable); - JScrollPane scrollTable = new JScrollPane(new ComplexTable(headerRows , body,171)); + complexTable.addMouseListener(new MouseAdapter() { + @Override + public void mouseClicked(MouseEvent e) { + + int row = complexTable.rowAtPoint(e.getPoint()); + int column = complexTable.columnAtPoint(e.getPoint()); + + // 妫�鏌ユ槸鍚︾偣鍑讳簡鏈夋晥鍗曞厓鏍� + if (row >= 0 && column >= 1) { + Object cellValue = complexTable.getValueAt(row, column); + Integer value = Integer.parseInt(cellValue.toString()); + if (value > 0) { + Long teamgroupId = list.get(row).getTeamgroupId(); + reportRecord(column,level1NetworkId,teamgroupId); + } + } + } + }); frame1.add(scrollTable); frame1.setVisible(true); } + private void reportRecord(int column, Long level1NetworkId,Long teamgroupId) { + JFrame frame1 = new JFrame("璁板綍"); + frame1.setSize(500, 400); + frame1.setResizable(false); + frame1.setDefaultCloseOperation(WindowConstants.DISPOSE_ON_CLOSE); + frame1.setLocationRelativeTo(null); + frame1.setVisible(true); + + List<ReportRecordDto> list = djJdgzTrackRecordService.getReportRecord(level1NetworkId,column,teamgroupId); + + List<ColumnDto> columnDto = new ArrayList<>(); + //columnDto.add(new ColumnDto("ID", "id", -1, null,false)); + columnDto.add(new ColumnDto("搴忓彿", "", (500 - 10) / 3, "autoCreate", false, null, null)); + columnDto.add(new ColumnDto("璁惧鍚嶇О", "name", (500 - 10) / 3, null, false, null, null)); + columnDto.add(new ColumnDto("鑺傜偣鍚嶇О", "processName", (500 - 10) / 3, null, false, null, null)); + + JTable table = CommonTable.createCommonTable(list, columnDto); + table.setRowHeight(25); + + table.setAutoResizeMode(JTable.AUTO_RESIZE_OFF); + + JScrollPane scrollPane = new JScrollPane(table, JScrollPane.VERTICAL_SCROLLBAR_ALWAYS, JScrollPane.HORIZONTAL_SCROLLBAR_ALWAYS); + scrollPane.setViewportView(table); + scrollPane.getViewport().setBackground(Color.WHITE); + scrollPane.setPreferredSize(new Dimension(500 - 20, 400)); + + frame1.add(scrollPane); + } + } diff --git a/src/main/java/com/example/client/service/SubunitAddOrUpdate.java b/src/main/java/com/example/client/service/SubunitAddOrUpdate.java index 1d91113..9def481 100644 --- a/src/main/java/com/example/client/service/SubunitAddOrUpdate.java +++ b/src/main/java/com/example/client/service/SubunitAddOrUpdate.java @@ -44,16 +44,18 @@ private List<ColumnDto> columnDto; private JTable trackTable; private DjJdgzNetworkLevel3 nowLevel3; + private JFrame nowFrame; - public JPanel createTrack(Integer width, Integer height, DjJdgzNetworkLevel3 djJdgzNetworkLevel3,JFrame frame) { + public JPanel createTrack(Integer width, Integer height, DjJdgzNetworkLevel3 djJdgzNetworkLevel3, JFrame frame) { nowLevel3 = djJdgzNetworkLevel3; + nowFrame = frame; JPanel panel = new JPanel(new BorderLayout()); panel.setPreferredSize(new Dimension(width, height)); JPanel topJpanel = new JPanel(new FlowLayout(FlowLayout.LEFT)); topJpanel.setPreferredSize(new Dimension(width - 10, 40)); JPanel centerJpanel = new JPanel(); - centerJpanel.setPreferredSize(new Dimension(width - 20, Compute.ComputeHeight(40,frame))); + centerJpanel.setPreferredSize(new Dimension(width - 20, Compute.ComputeHeight(40, nowFrame))); panel.add(topJpanel, BorderLayout.NORTH); panel.add(centerJpanel, BorderLayout.CENTER); @@ -78,23 +80,29 @@ columnDto.add(new ColumnDto("鎿嶄綔", "", 200, "", true, buttonList, null)); trackTable = CommonTable.createCommonTable(list, columnDto); - trackTable.setPreferredSize(new Dimension(width , height)); + trackTable.setPreferredSize(new Dimension(width, height)); trackTable.setRowHeight(25); trackTable.setAutoResizeMode(JTable.AUTO_RESIZE_OFF); - tableModelListener(trackTable, frame,list,columnDto); + tableModelListener(trackTable, list, columnDto); btnInsert.addActionListener(new ActionListener() { @Override public void actionPerformed(ActionEvent e) { - frame.setEnabled(false); + nowFrame.setEnabled(false); SysUser user = (SysUser) CacheUtils.get("user", "user"); - if (user.getTeamgroup()==null||user.getTeamgroup().equals(nowLevel3.getTeamgroupId().toString())) { + if (user == null) { + nowFrame.setEnabled(true); + JOptionPane.showMessageDialog(null, "褰撳墠鐢ㄦ埛宸插け鏁堣閲嶆柊鐧诲綍", "鎻愮ず", JOptionPane.WARNING_MESSAGE); + return; + } + if (user.getTeamgroup() == null || user.getTeamgroup().equals(nowLevel3.getTeamgroupId().toString())) { DjJdgzDismantTrack djJdgzDismantTrack = new DjJdgzDismantTrack(); djJdgzDismantTrack.setLevel3NetworkId(nowLevel3.getId()); - insert(frame,djJdgzDismantTrack); - }else{ + insert(nowFrame, djJdgzDismantTrack); + } else { + nowFrame.setEnabled(true); JOptionPane.showMessageDialog(null, "褰撳墠鐢ㄦ埛涓嶅彲鎿嶄綔鍏朵粬涓撲笟鏁版嵁", "鎻愮ず", JOptionPane.WARNING_MESSAGE); } } @@ -103,13 +111,13 @@ JScrollPane scrollPane = new JScrollPane(trackTable, JScrollPane.VERTICAL_SCROLLBAR_ALWAYS, JScrollPane.HORIZONTAL_SCROLLBAR_ALWAYS); scrollPane.setViewportView(trackTable); - scrollPane.setPreferredSize(new Dimension(width - 20, Compute.ComputeHeightWithScroll(40,frame))); + scrollPane.setPreferredSize(new Dimension(width - 20, Compute.ComputeHeightWithScroll(40, nowFrame))); centerJpanel.add(scrollPane); - frame.addComponentListener(new ComponentAdapter() { + nowFrame.addComponentListener(new ComponentAdapter() { @Override public void componentResized(ComponentEvent e) { - centerJpanel.setPreferredSize(new Dimension(width - 20, Compute.ComputeHeightWithScroll(40,frame))); - scrollPane.setPreferredSize(new Dimension(width - 20, Compute.ComputeHeightWithScroll(40,frame))); + centerJpanel.setPreferredSize(new Dimension(width - 20, Compute.ComputeHeightWithScroll(40, nowFrame))); + scrollPane.setPreferredSize(new Dimension(width - 20, Compute.ComputeHeightWithScroll(40, nowFrame))); centerJpanel.revalidate(); centerJpanel.repaint(); scrollPane.revalidate(); @@ -120,7 +128,7 @@ } private void insert(JFrame jFrame, DjJdgzDismantTrack data) { - if (data.getLevel3NetworkId()==null){ + if (data.getLevel3NetworkId() == null) { JOptionPane.showMessageDialog(null, "娌℃湁閫夋嫨璁惧", "鎻愮ず", JOptionPane.WARNING_MESSAGE); return; } @@ -146,7 +154,7 @@ JComboBox<JComboBoxItem> comboBox0 = new JComboBox<>(cabinList); comboBox0.setPreferredSize(new Dimension(185, 28)); comboBox0.setSelectedIndex(-1); - if(data.getCabinId()!=null){ + if (data.getCabinId() != null) { comboBox0.setSelectedItem(BoxIteUtils.GetSelectItemById(cabinList, data.getCabinId())); } @@ -168,6 +176,11 @@ frame1.add(btnSave, new GBC(0, 2, 2, 1).setWeight(1, 0)); btnSave.addActionListener((e) -> { + SysUser user = (SysUser) CacheUtils.get("user","user"); + if (user==null){ + JOptionPane.showMessageDialog(null, "鐢ㄦ埛澶辨晥璇烽��鍑哄苟閲嶆柊鐧诲綍", "鎻愮ず", JOptionPane.WARNING_MESSAGE); + return; + } JComboBoxItem cabin = (JComboBoxItem) comboBox0.getSelectedItem(); String name = subunitName.getText(); @@ -176,23 +189,25 @@ List<DjJdgzDismantTrack> list = new ArrayList<>(); list.add(data); djJdgzDismantTrackService.save(list); - - this.refreshTable(data.getLevel3NetworkId(),null); + //tableModelListener(trackTable, jFrame,list,columnDto); + this.refreshTable(data.getLevel3NetworkId(), null); frame1.dispose(); jFrame.setEnabled(true);//灏嗕富鐣岄潰鍐嶈缃负鍙搷浣滅殑 + JOptionPane.showMessageDialog(null, "淇濆瓨鎴愬姛", "鎻愮ず", JOptionPane.WARNING_MESSAGE); }); } - public void refreshTable(Long level3Id,JFrame jFrame){ + + public void refreshTable(Long level3Id, JFrame jFrame) { nowLevel3 = level3Service.get(level3Id); List<DjJdgzDismantTrack> list = djJdgzDismantTrackService.getList(level3Id, null); CommonTable.refreshTable(list, columnDto, trackTable); trackTable.setRowHeight(25); trackTable.setAutoResizeMode(JTable.AUTO_RESIZE_OFF); - tableModelListener(trackTable, jFrame,list,columnDto); + tableModelListener(trackTable, list, columnDto); } - public void tableModelListener(JTable table,JFrame jFrame,List<DjJdgzDismantTrack> list,List<ColumnDto> columnDto){ + public void tableModelListener(JTable table, List<DjJdgzDismantTrack> list, List<ColumnDto> columnDto) { table.getModel().addTableModelListener(e -> { // 妫�鏌ヤ簨浠剁被鍨� if (e.getType() == TableModelEvent.UPDATE) { @@ -203,11 +218,11 @@ // 鑾峰彇鏂扮殑鍊� Object newValue = table.getModel().getValueAt(row, column); // 杈撳嚭鍙樺寲淇℃伅 - if (newValue.equals("edit")){ - jFrame.setEnabled(false); + if (newValue.equals("edit")) { + nowFrame.setEnabled(false); DjJdgzDismantTrack data = list.get(row); - insert(jFrame,data); - }else if(newValue.equals("del")) { + insert(nowFrame, data); + } else if (newValue.equals("del")) { int n = JOptionPane.showConfirmDialog(null, "鏄惁鍒犻櫎?", "鎻愮ず", JOptionPane.YES_NO_OPTION); if (n == 0) { DefaultTableModel model = (DefaultTableModel) table.getModel(); diff --git a/src/main/java/com/example/client/service/SubunitService.java b/src/main/java/com/example/client/service/SubunitService.java index 65f2412..51c101e 100644 --- a/src/main/java/com/example/client/service/SubunitService.java +++ b/src/main/java/com/example/client/service/SubunitService.java @@ -66,7 +66,7 @@ JComboBoxItem[] teamList = sysTeamGroupClassService.getTeamList(null); JComboBoxItem[] cabinList = cabinService.getList(); String[] typeList = new String[]{ - "鏀硅", "鍔犺", "鎹㈣", "鏀硅繘鎬т慨鐞�","" + "","鏀硅", "鍔犺", "鎹㈣", "淇悊","鏀硅繘鎬т慨鐞�" }; List<DjJdgzShip> shipList = djJdgzShipService.getList(); Map<String, Long> shipMap = new HashMap<>(); diff --git a/src/main/java/com/example/client/service/TeamGroupAddOrUpdate.java b/src/main/java/com/example/client/service/TeamGroupAddOrUpdate.java index 6783411..a6d2fe4 100644 --- a/src/main/java/com/example/client/service/TeamGroupAddOrUpdate.java +++ b/src/main/java/com/example/client/service/TeamGroupAddOrUpdate.java @@ -10,6 +10,7 @@ import com.example.server.teamGroup.service.SysTeamGroupClassService; import com.example.server.user.model.SysUser; import com.example.server.user.service.UserService; +import com.example.server.utils.CacheUtils; import org.apache.commons.lang3.StringUtils; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Service; @@ -105,6 +106,11 @@ saveButton.addActionListener(new ActionListener() { @Override public void actionPerformed(ActionEvent e) { + SysUser user = (SysUser) CacheUtils.get("user","user"); + if (user==null){ + JOptionPane.showMessageDialog(null, "鐢ㄦ埛澶辨晥璇烽��鍑哄苟閲嶆柊鐧诲綍", "鎻愮ず", JOptionPane.WARNING_MESSAGE); + return; + } String type = comboBox1.getSelectedItem().toString(); JComboBoxItem dept = (JComboBoxItem) comboBox2.getSelectedItem(); Integer sortMax = 0; @@ -129,6 +135,7 @@ teamGroupManageService.tableModelListener(table, jFrame, list); frame1.dispose(); jFrame.setEnabled(true);//灏嗕富鐣岄潰鍐嶈缃负鍙搷浣滅殑 + JOptionPane.showMessageDialog(null, "淇濆瓨鎴愬姛", "鎻愮ず", JOptionPane.WARNING_MESSAGE); } }); diff --git a/src/main/java/com/example/client/service/TrackRecordAddOrUpdate.java b/src/main/java/com/example/client/service/TrackRecordAddOrUpdate.java index f78ed46..d90ef1a 100644 --- a/src/main/java/com/example/client/service/TrackRecordAddOrUpdate.java +++ b/src/main/java/com/example/client/service/TrackRecordAddOrUpdate.java @@ -106,7 +106,7 @@ trackPersonDesc.setText(data.getTrackPerson()); } - JLabel JLabel34 = new JLabel("鍗曚綅"); + JLabel JLabel34 = new JLabel("T鏂瑰崟浣�"); JTextField trackPersonUnitDesc = new JTextField(16); if (StringUtils.isNotBlank(data.getTrackPersonUnit())) { trackPersonUnitDesc.setText(data.getTrackPersonUnit()); @@ -124,7 +124,7 @@ trackedPersonDesc.setText(data.getTrackedPerson()); } - JLabel JLabel56 = new JLabel("鍗曚綅"); + JLabel JLabel56 = new JLabel("鍘傛柟鍗曚綅"); JTextField trackedPersonUnitDesc = new JTextField(16); if (StringUtils.isNotBlank(data.getTrackedPersonUnit())) { trackedPersonUnitDesc.setText(data.getTrackedPersonUnit()); @@ -299,6 +299,10 @@ @Override public void actionPerformed(ActionEvent e) { SysUser user = (SysUser) CacheUtils.get("user", "user"); + if (user == null) { + JOptionPane.showMessageDialog(null, "褰撳墠鐢ㄦ埛宸插け鏁堣閲嶆柊鐧诲綍", "鎻愮ず", JOptionPane.WARNING_MESSAGE); + return; + } DjJdgzNetworkLevel3 level3 = djJdgzNetworkLevel3Service.get(data.getLevel3NetworkId()); if (user.getTeamgroup() != null && !user.getTeamgroup().equals(level3.getTeamgroupId().toString())) { JOptionPane.showMessageDialog(null, "褰撳墠鐢ㄦ埛涓嶅彲鎿嶄綔鍏朵粬涓撲笟鏁版嵁", "鎻愮ず", JOptionPane.WARNING_MESSAGE); @@ -344,6 +348,8 @@ trackRecordManageService.tableModelListener(table, jFrame, list); frame1.dispose(); jFrame.setEnabled(true);//灏嗕富鐣岄潰鍐嶈缃负鍙搷浣滅殑 + JOptionPane.showMessageDialog(null, "淇濆瓨鎴愬姛", "鎻愮ず", JOptionPane.WARNING_MESSAGE); + } }); diff --git a/src/main/java/com/example/client/service/TrackRecordManageService.java b/src/main/java/com/example/client/service/TrackRecordManageService.java index 705413b..d4bcada 100644 --- a/src/main/java/com/example/client/service/TrackRecordManageService.java +++ b/src/main/java/com/example/client/service/TrackRecordManageService.java @@ -79,7 +79,7 @@ JComboBoxItem[] teamList = sysTeamGroupClassService.getTeamList(null); String[] typeList = new String[]{ - "","鏀硅", "鍔犺", "鎹㈣", "鏀硅繘鎬т慨鐞�" + "","鏀硅", "鍔犺", "鎹㈣", "淇悊","鏀硅繘鎬т慨鐞�" }; JLabel JLabel0 = new JLabel("宸ョ▼"); @@ -237,7 +237,7 @@ @Override public void actionPerformed(ActionEvent e) { JComboBoxItem project = (JComboBoxItem) comboBox.getSelectedItem(); - list = djJdgzTrackRecordService.getList(project.getId(), null, null, null, null, null, sb.getText()); + list = djJdgzTrackRecordService.getList(project.getId(), null, null, null, null, 0, sb.getText()); CommonTable.refreshTable(list, columnDto, table); table.setRowHeight(25); diff --git a/src/main/java/com/example/client/service/UserAddOrUpdate.java b/src/main/java/com/example/client/service/UserAddOrUpdate.java index d9fc1bd..9890606 100644 --- a/src/main/java/com/example/client/service/UserAddOrUpdate.java +++ b/src/main/java/com/example/client/service/UserAddOrUpdate.java @@ -14,6 +14,7 @@ import com.example.server.teamGroup.service.SysTeamGroupClassService; import com.example.server.user.model.SysUser; import com.example.server.user.service.UserService; +import com.example.server.utils.CacheUtils; import org.apache.commons.lang3.StringUtils; import org.jdesktop.swingx.JXDatePicker; import org.springframework.beans.factory.annotation.Autowired; @@ -138,6 +139,11 @@ saveButton.addActionListener(new ActionListener() { @Override public void actionPerformed(ActionEvent e) { + SysUser user = (SysUser) CacheUtils.get("user","user"); + if (user==null){ + JOptionPane.showMessageDialog(null, "鐢ㄦ埛澶辨晥璇烽��鍑哄苟閲嶆柊鐧诲綍", "鎻愮ず", JOptionPane.WARNING_MESSAGE); + return; + } JComboBoxItem dept = (JComboBoxItem) comboBox1.getSelectedItem(); JComboBoxItem team = (JComboBoxItem) comboBox2.getSelectedItem(); @@ -154,6 +160,7 @@ userManageService.tableModelListener(table,jFrame,list); frame1.dispose(); jFrame.setEnabled(true);//灏嗕富鐣岄潰鍐嶈缃负鍙搷浣滅殑 + JOptionPane.showMessageDialog(null, "淇濆瓨鎴愬姛", "鎻愮ず", JOptionPane.WARNING_MESSAGE); } }); diff --git a/src/main/java/com/example/server/DataSync/service/DataSyncService.java b/src/main/java/com/example/server/DataSync/service/DataSyncService.java index df6ec49..371ebe0 100644 --- a/src/main/java/com/example/server/DataSync/service/DataSyncService.java +++ b/src/main/java/com/example/server/DataSync/service/DataSyncService.java @@ -179,7 +179,10 @@ syncTable("dj_jdgz_network_level3_list"); syncTable("dj_jdgz_track_record"); syncTable("dj_sys_oss"); + syncTable("dj_sys_teamgroup_class"); + syncTable("sys_user"); syncTable("dj_jdgz_dismant_track"); + syncTable("dj_jdgz_ship"); } else if (mySite.equals("TD")) { if (otherSite.equals("TD")) { syncTable("dj_jdgz_network_level3"); @@ -188,6 +191,9 @@ syncTable("dj_sys_oss"); syncTable("dj_jdgz_dismant_track"); syncTable("dj_jdgz_handover"); + syncTable("dj_sys_teamgroup_class"); + syncTable("sys_user"); + syncTable("dj_jdgz_ship"); } else if ("宸ヤ綔缁�".equals(otherSite)) { syncTable("dj_jdgz_handover"); syncTable("dj_jdgz_network_level1"); diff --git a/src/main/java/com/example/server/entity/FieldMetaObjectHandler.java b/src/main/java/com/example/server/entity/FieldMetaObjectHandler.java index 16b1603..573a52e 100644 --- a/src/main/java/com/example/server/entity/FieldMetaObjectHandler.java +++ b/src/main/java/com/example/server/entity/FieldMetaObjectHandler.java @@ -18,6 +18,7 @@ import org.apache.ibatis.reflection.MetaObject; import org.springframework.stereotype.Component; +import javax.swing.*; import java.time.LocalDate; import java.time.LocalDateTime; import java.time.format.DateTimeFormatter; @@ -48,13 +49,13 @@ if (object instanceof PlatformLogEntity) { PlatformLogEntity entity = (PlatformLogEntity) object; - entity.setCreator(user.getUserId());// 鍒涘缓鑰� + entity.setCreator(user.getId());// 鍒涘缓鑰� entity.setCreateDate(date);// 鍒涘缓鏃堕棿 } if (object instanceof PlatformEntity) { PlatformEntity entity = (PlatformEntity) object; entity.setDelete(false); - entity.setUpdater(user.getUserId());// 鏇存柊鑰� + entity.setUpdater(user.getId());// 鏇存柊鑰� entity.setUpdateDate(date);// 鏇存柊鏃堕棿 } if (object instanceof TenantEntity) { @@ -73,7 +74,7 @@ Object object = metaObject.getOriginalObject(); if (object instanceof PlatformEntity) { PlatformEntity entity = (PlatformEntity) object; - entity.setUpdater(user.getUserId());// 鏇存柊鑰� + entity.setUpdater(user.getId());// 鏇存柊鑰� entity.setUpdateDate(date);// 鏇存柊鏃堕棿 } diff --git a/src/main/java/com/example/server/progressTrack/Dto/ReportRecordDto.java b/src/main/java/com/example/server/progressTrack/Dto/ReportRecordDto.java new file mode 100644 index 0000000..0382d81 --- /dev/null +++ b/src/main/java/com/example/server/progressTrack/Dto/ReportRecordDto.java @@ -0,0 +1,9 @@ +package com.example.server.progressTrack.Dto; + +import lombok.Data; + +@Data +public class ReportRecordDto { + private String name; + private String processName; +} diff --git a/src/main/java/com/example/server/progressTrack/Dto/StatistReportsDto.java b/src/main/java/com/example/server/progressTrack/Dto/StatistReportsDto.java index 8f15a98..c63e6de 100644 --- a/src/main/java/com/example/server/progressTrack/Dto/StatistReportsDto.java +++ b/src/main/java/com/example/server/progressTrack/Dto/StatistReportsDto.java @@ -8,6 +8,7 @@ @Data public class StatistReportsDto { private String teamGroupName; + private Long teamgroupId; private Integer allNum; private Integer jxzNum; private Integer lqNum; diff --git a/src/main/java/com/example/server/progressTrack/dao/DjJdgzTrackRecordDao.java b/src/main/java/com/example/server/progressTrack/dao/DjJdgzTrackRecordDao.java index faa80ec..f3c0914 100644 --- a/src/main/java/com/example/server/progressTrack/dao/DjJdgzTrackRecordDao.java +++ b/src/main/java/com/example/server/progressTrack/dao/DjJdgzTrackRecordDao.java @@ -1,6 +1,7 @@ package com.example.server.progressTrack.dao; import com.example.server.dao.BaseDao; +import com.example.server.progressTrack.Dto.ReportRecordDto; import com.example.server.progressTrack.Dto.StatistReportsDto; import com.example.server.progressTrack.model.DjJdgzTrackRecord; import org.apache.ibatis.annotations.Mapper; @@ -36,4 +37,6 @@ List<DjJdgzTrackRecord> getListByImport(Long level1Id, Long level2Id, Long level2NodeId, String selectedIds); void retract(Long id); + + List<ReportRecordDto> getReportRecord(Long level1NetworkId, int column, Long teamgroupId); } diff --git a/src/main/java/com/example/server/progressTrack/service/DjJdgzTrackRecordService.java b/src/main/java/com/example/server/progressTrack/service/DjJdgzTrackRecordService.java index 2d8cbc5..f55a72a 100644 --- a/src/main/java/com/example/server/progressTrack/service/DjJdgzTrackRecordService.java +++ b/src/main/java/com/example/server/progressTrack/service/DjJdgzTrackRecordService.java @@ -4,6 +4,7 @@ import com.example.client.service.BaseService; import com.example.server.ExportExcel.dto.ExprotExcelDto; import com.example.server.ExportExcel.method.ExcelExport; +import com.example.server.progressTrack.Dto.ReportRecordDto; import com.example.server.progressTrack.Dto.StatistReportsDto; import com.example.server.progressTrack.dao.DjJdgzTrackRecordDao; import com.example.server.progressTrack.model.DjJdgzNetworkLevel1; @@ -65,7 +66,7 @@ if (isTyRole.equals(true) || isYwzRole.equals(true)) { userId = UserContext.getUser().getId(); }*/ - List<DjJdgzTrackRecord> list = baseDao.getList(level1NetworkId,deptId,teamId,cabinId,type, status, name); + List<DjJdgzTrackRecord> list = baseDao.getList(level1NetworkId, deptId, teamId, cabinId, type, status, name); /*if (list != null && list.size() > 0) { sysOssService.setListOsses(list, "ProjectProgressFileUpload"); }*/ @@ -408,7 +409,7 @@ } else { List<DjJdgzNetworkLevel3List> list = djJdgzNetworkLevel3ListService.getList(level3.getId()); for (DjJdgzNetworkLevel3List item : list) { - if(item.getProcessName().equals(progressName)){ + if (item.getProcessName().equals(progressName)) { data.setLevel3NodeId(item.getId()); data.setEstimatedCompletionTime(item.getRequiredCompletionTime()); break; @@ -531,4 +532,8 @@ public void retract(Long id) { baseDao.retract(id); } + + public List<ReportRecordDto> getReportRecord(Long level1NetworkId, int column, Long teamgroupId) { + return baseDao.getReportRecord(level1NetworkId, column, teamgroupId); + } } diff --git a/src/main/java/com/example/server/user/model/SysUser.java b/src/main/java/com/example/server/user/model/SysUser.java index 2a9d003..498453d 100644 --- a/src/main/java/com/example/server/user/model/SysUser.java +++ b/src/main/java/com/example/server/user/model/SysUser.java @@ -60,8 +60,6 @@ @ApiModelProperty(value = "T闃�") private String boatfleet; - private Long userId; - @TableField(exist = false) private Boolean exist; diff --git a/src/main/resources/application.yml b/src/main/resources/application.yml index 2a6d2f0..b6689d5 100644 --- a/src/main/resources/application.yml +++ b/src/main/resources/application.yml @@ -3,6 +3,9 @@ com.example: debug file: log/my.log +server: + port: 3030 + j2cache: config-location: classpath:/j2cache.properties diff --git a/src/main/resources/db/csiczb1.db b/src/main/resources/db/csiczb1.db index fa3b015..c0ac496 100644 --- a/src/main/resources/db/csiczb1.db +++ b/src/main/resources/db/csiczb1.db Binary files differ diff --git a/src/main/resources/mapper/progressTrack/DjJdgzNetworkLevel3Dao.xml b/src/main/resources/mapper/progressTrack/DjJdgzNetworkLevel3Dao.xml index ffa642e..f073930 100644 --- a/src/main/resources/mapper/progressTrack/DjJdgzNetworkLevel3Dao.xml +++ b/src/main/resources/mapper/progressTrack/DjJdgzNetworkLevel3Dao.xml @@ -47,7 +47,7 @@ and a.TEAMGROUP_ID = ${teamId} </if> <if test="cabinId!=null"> - and a.cabin_id LIKE '%${cabinId}%' + and a.cabin_id = ${cabinId} </if> <if test="type!=null and type!=''"> and a.type = #{type} @@ -116,7 +116,7 @@ and b.TEAMGROUP_ID = ${teamId} </if> <if test="cabinId!=null"> - and b.cabin_id LIKE '%${cabinId}%' + and b.cabin_id = ${cabinId} </if> <if test="type!=null and type!=''"> and b.type = #{type} diff --git a/src/main/resources/mapper/progressTrack/DjJdgzTrackRecordDao.xml b/src/main/resources/mapper/progressTrack/DjJdgzTrackRecordDao.xml index e9c7928..dee1b77 100644 --- a/src/main/resources/mapper/progressTrack/DjJdgzTrackRecordDao.xml +++ b/src/main/resources/mapper/progressTrack/DjJdgzTrackRecordDao.xml @@ -6,10 +6,14 @@ UPDATE dj_jdgz_track_record SET CURRENT_STATUS = 0 WHERE LEVEL3_NETWORK_ID = ( - SELECT LEVEL3_NETWORK_ID FROM dj_jdgz_track_record WHERE id = ${id} + SELECT LEVEL3_NETWORK_ID + FROM dj_jdgz_track_record + WHERE id = ${id} ) AND create_date >= ( - SELECT create_date FROM dj_jdgz_track_record WHERE id = ${id} + SELECT create_date + FROM dj_jdgz_track_record + WHERE id = ${id} ); </update> @@ -88,7 +92,7 @@ and c.TEAMGROUP_ID = ${teamId} </if> <if test="cabinId!=null"> - and c.cabin_id LIKE '%${cabinId}%' + and c.cabin_id = ${cabinId} </if> <if test="type!=null and type!=''"> and c.type = #{type} @@ -109,10 +113,10 @@ </select> <select id="getHistory" resultType="com.example.server.progressTrack.model.DjJdgzTrackRecord"> select GENERAL_REPAIR_UNIT || ',' || GENERAL_REPAIR_UNIT_DIRECTOR || ',' || - GENERAL_REPAIR_UNIT_CONTACT AS generalRepair, - REPAIR_UNIT || ',' || REPAIR_UNIT_DIRECTOR || ',' || REPAIR_UNIT_CONTACT AS `repair`, - track_person || ',' || track_person_unit || ',' || track_person_contact AS trackPerson, - tracked_person || ',' || tracked_person_unit || ',' || tracked_person_contact AS trackedPerson, + GENERAL_REPAIR_UNIT_CONTACT AS generalRepair, + REPAIR_UNIT || ',' || REPAIR_UNIT_DIRECTOR || ',' || REPAIR_UNIT_CONTACT AS `repair`, + track_person || ',' || track_person_unit || ',' || track_person_contact AS trackPerson, + tracked_person || ',' || tracked_person_unit || ',' || tracked_person_contact AS trackedPerson, track_method, track_location, CURRENT_STATUS, @@ -196,7 +200,7 @@ dj_jdgz_track_record where is_delete = 0 ) and a.is_delete = 0 <if test="userId!=null"> - AND a.TEAMGROUP_ID in (select teamgroup from sys_user where is_delete=0 and user_id=#{userId}) + AND a.TEAMGROUP_ID in (select teamgroup from sys_user where is_delete=0 and id=#{userId}) </if> AND b.IS_DELETE = 0 AND c.IS_DELETE = 0 @@ -451,5 +455,38 @@ ORDER BY a.REQUIRED_COMPLETION_TIME </select> + <select id="getReportRecord" resultType="com.example.server.progressTrack.Dto.ReportRecordDto"> + select a.NAME,b.PROCESS_NAME + from dj_jdgz_network_level3 a, + dj_jdgz_network_level3_list b, + dj_jdgz_network_level1 c + where a.IS_DELETE = 0 + and a.LEVEL1_NETWORK_ID = ${level1NetworkId} + and a.TEAMGROUP_ID = ${teamgroupId} + and a.LEVEL1_NETWORK_ID = c.id + and b.IS_DELETE = 0 + and b.NETWORK_ID = a.id + and c.IS_DELETE = 0 + <if test="column==2"> + and (b.CURRENT_STATUS = 0 or b.CURRENT_STATUS is null) + and b.REQUIRED_COMPLETION_TIME >= ( SELECT date( 'now', '-' || c.advent_day || ' days' ) ) + </if> + <if test="column==3"> + and (b.CURRENT_STATUS = 0 or b.CURRENT_STATUS is null) + and b.REQUIRED_COMPLETION_TIME < ( SELECT date( 'now', '-' || c.advent_day || ' days' ) ) + </if> + <if test="column==4"> + and (b.CURRENT_STATUS = 0 or b.CURRENT_STATUS is null) + and b.REQUIRED_COMPLETION_TIME < ( SELECT datetime( 'now' ) ) + </if> + <if test="column==5"> + and b.CURRENT_STATUS = 1 + AND b.REQUIRED_COMPLETION_TIME <= b.ACTUAL_COMPLETION + </if> + <if test="column==6"> + and b.CURRENT_STATUS = 1 + AND b.REQUIRED_COMPLETION_TIME > b.ACTUAL_COMPLETION + </if> + </select> </mapper> diff --git a/src/main/resources/mapper/progressTrack/ExportRecord.xml b/src/main/resources/mapper/progressTrack/ExportRecord.xml index 1d5e5a7..4f5507e 100644 --- a/src/main/resources/mapper/progressTrack/ExportRecord.xml +++ b/src/main/resources/mapper/progressTrack/ExportRecord.xml @@ -5,6 +5,6 @@ <select id="getList" resultType="com.example.server.progressTrack.model.ExportRecord"> select a.*, b.user_name from export_record a - left join sys_user b on b.user_id = a.creator + left join sys_user b on b.id = a.creator </select> </mapper> diff --git a/src/main/resources/mapper/progressTrack/ImportRecord.xml b/src/main/resources/mapper/progressTrack/ImportRecord.xml index ade4a27..01b0c79 100644 --- a/src/main/resources/mapper/progressTrack/ImportRecord.xml +++ b/src/main/resources/mapper/progressTrack/ImportRecord.xml @@ -5,6 +5,6 @@ <select id="getList" resultType="com.example.server.progressTrack.model.ImportRecord"> select a.*, b.user_name from import_record a - left join sys_user b on b.user_id = a.creator + left join sys_user b on b.id = a.creator </select> </mapper> diff --git a/src/main/resources/mapper/user/UserDao.xml b/src/main/resources/mapper/user/UserDao.xml index 02ad48e..bd5639a 100644 --- a/src/main/resources/mapper/user/UserDao.xml +++ b/src/main/resources/mapper/user/UserDao.xml @@ -10,7 +10,7 @@ <select id="getList" resultType="com.example.server.user.model.SysUser"> SELECT - a.user_id, + a.id, a.user_name, a.nick_name, a.password, -- Gitblit v1.9.1