| | |
| | | import com.example.client.service.BaseService; |
| | | import com.example.server.cabin.service.CabinService; |
| | | import com.example.server.progressTrack.Dto.NetworkNodeStatusDto; |
| | | import com.example.server.progressTrack.Dto.StatistProductDto; |
| | | import com.example.server.progressTrack.Dto.TableNodeDto; |
| | | import com.example.server.progressTrack.dao.DjJdgzNetworkLevel3Dao; |
| | | import com.example.server.progressTrack.model.DjJdgzNetworkLevel3; |
| | |
| | | @Value("${zt.oss.local-path}") |
| | | private String path; |
| | | |
| | | public List<StatistProductDto> getStatist(Long level1Id) { |
| | | return baseDao.getStatist(level1Id); |
| | | } |
| | | |
| | | enum StatusEnum {zy, jxz, lq, yq, zcwc, cqwc} |
| | | |
| | | String[] fillColorArr = {"#e5e5e5", "#3498DB", "#F1C40F", "#E74C3C", "#2ECC71", "#006400"}; |
| | | String[] fontColorArr = {"#e5e5e5", "#3498DB", "#F1C40F", "#E74C3C", "#2ECC71", "#006400"}; |
| | | |
| | | public List<DjJdgzNetworkLevel3> getList(Long shipId, Long deptId, Long teamId, Long cabinId, String type, String name) { |
| | | List<DjJdgzNetworkLevel3> list = baseDao.getList(shipId, deptId, teamId, cabinId, type, name); |
| | | public List<DjJdgzNetworkLevel3> getList(Long shipId, Long deptId, Long teamId, Long cabinId, String type,Integer isealCabin, String name) { |
| | | List<DjJdgzNetworkLevel3> list = baseDao.getList(shipId, deptId, teamId, cabinId, type,isealCabin, name); |
| | | return list; |
| | | } |
| | | |
| | |
| | | Row row = sheet.getRow(j); |
| | | |
| | | String name = ImportUtil.getCellValue(row, 0, pattern); |
| | | String deptStr = ImportUtil.getCellValue(row, 1, pattern); |
| | | String teamGroupStr = ImportUtil.getCellValue(row, 2, pattern); |
| | | String cabinStr = ImportUtil.getCellValue(row, 3, pattern); |
| | | String typeStr = ImportUtil.getCellValue(row, 4, pattern); |
| | | String time1 = ImportUtil.getCellValue(row, 5, pattern); |
| | | String time2 = ImportUtil.getCellValue(row, 6, pattern); |
| | | String time3 = ImportUtil.getCellValue(row, 7, pattern); |
| | | String time4 = ImportUtil.getCellValue(row, 8, pattern); |
| | | String time5 = ImportUtil.getCellValue(row, 9, pattern); |
| | | String repairUnit = ImportUtil.getCellValue(row, 10, pattern); |
| | | String repairUnitDirector = ImportUtil.getCellValue(row, 11, pattern); |
| | | String repairUnitContact = ImportUtil.getCellValue(row, 12, pattern); |
| | | String generalRepairUnit = ImportUtil.getCellValue(row, 13, pattern); |
| | | String generalRepairUnitDirector = ImportUtil.getCellValue(row, 14, pattern); |
| | | String generalRepairUnitContact = ImportUtil.getCellValue(row, 15, pattern); |
| | | String isealCabinStr = ImportUtil.getCellValue(row, 1, pattern); |
| | | String deptStr = ImportUtil.getCellValue(row, 2, pattern); |
| | | String teamGroupStr = ImportUtil.getCellValue(row, 3, pattern); |
| | | String cabinStr = ImportUtil.getCellValue(row, 4, pattern); |
| | | String typeStr = ImportUtil.getCellValue(row, 5, pattern); |
| | | String time1 = ImportUtil.getCellValue(row, 6, pattern); |
| | | String time2 = ImportUtil.getCellValue(row, 7, pattern); |
| | | String time3 = ImportUtil.getCellValue(row, 8, pattern); |
| | | String time4 = ImportUtil.getCellValue(row, 9, pattern); |
| | | String time5 = ImportUtil.getCellValue(row, 10, pattern); |
| | | String repairUnit = ImportUtil.getCellValue(row, 11, pattern); |
| | | String repairUnitDirector = ImportUtil.getCellValue(row, 12, pattern); |
| | | String repairUnitContact = ImportUtil.getCellValue(row, 13, pattern); |
| | | String generalRepairUnit = ImportUtil.getCellValue(row, 14, pattern); |
| | | String generalRepairUnitDirector = ImportUtil.getCellValue(row, 15, pattern); |
| | | String generalRepairUnitContact = ImportUtil.getCellValue(row, 16, pattern); |
| | | |
| | | Integer isealCabin = 0; |
| | | if (isealCabinStr.equals("是")){ |
| | | isealCabin = 1; |
| | | } |
| | | |
| | | Long id = UUIDUtil.generateId(); |
| | | if (StringUtils.isEmpty(name)) { |
| | |
| | | data.setLevel1NetworkId(level1NetworkId); |
| | | data.setLevel2NetworkId(level2NetworkId); |
| | | data.setLevel2NodeId(level2NodeId); |
| | | data.setIsealCabin(isealCabin); |
| | | } |
| | | |
| | | if (StringUtils.isEmpty(deptStr)) { |
| | |
| | | Long oldId = 0L; |
| | | TableNodeDto data = null; |
| | | for (TableNodeDto node : list) { |
| | | if (oldId.equals(node.getNetworkId())){ |
| | | if (oldId.equals(node.getNetworkId())) { |
| | | |
| | | }else{ |
| | | } else { |
| | | data = new TableNodeDto(); |
| | | data.setName(node.getName()); |
| | | data.setNetworkId(node.getNetworkId()); |