/** * 房间优先展示 * * @param roomCode * @return */ public String priorityRoom(Integer roomCode) { Room room = houseAndRoomMapper.selectRoomByCode(roomCode); String isPromotions = room.getIsPromotions(); if (isPromotions.equals("N")) { // 验证房屋中存在优先展示的房间数量 int promotionsNum = houseAndRoomMapper.countPromotionsRoomNum(room.getSysHouseId()); if (promotionsNum != 0) { return "一个房屋只能有一个优先展示房间!"; } // 验证管家已经优先展示房间数量 User user = (User) SessionManager.getAttr(SessionManager.USER_KEY); if (user.getSetidJobcode() != null && (user.getSetidJobcode().equals("主管") || user.getSetidJobcode().equals("总监") || user.getSetidJobcode().equals("副总经理"))) { // 所属管家已经优先展示房源 int num = houseAndRoomMapper.countPromotions(user.getStaffid()); if (num >= 3) { return "对多只能优先展示3个房间!"; } room.setIsPromotions("Y"); } } else { room.setIsPromotions("N"); } // 更新房间推荐状态 houseAndRoomMapper.updateRoom(room); return "success"; }
/** * 房间推荐 * * @param roomCode * @return */ public String recommendRoom(Integer roomCode) { Room room = houseAndRoomMapper.selectRoomByCode(roomCode); String isTop = room.getIsTop(); if (isTop.equals("N")) { // 验证房屋中存在推荐的房间数量 int topNum = houseAndRoomMapper.countTopRoomNum(room.getSysHouseId()); if (topNum != 0) { return "一个房屋只能推荐一个房源!"; } // 验证已经推荐的房源数量 User user = (User) SessionManager.getAttr(SessionManager.USER_KEY); if (user.getSetidJobcode() != null && (user.getSetidJobcode().equals("主管") || user.getSetidJobcode().equals("总监") || user.getSetidJobcode().equals("副总经理"))) { int num = houseAndRoomMapper.countTop(user.getStaffid()); if (num >= 3) { return "对多只能推荐3个房间!"; } room.setIsTop("Y"); } } else { room.setIsTop("N"); } // 更新房间推荐状态 houseAndRoomMapper.updateRoom(room); return "success"; }
/** * 房屋发布业务处理方法 * * @param houseCode */ public void pubHouse(House house) { House h = houseAndRoomMapper.selectHouseByCode(house.getSysHouseId()); if (h != null) { Room r = new Room(); r.setSysHouseId(h.getSysHouseId()); // 根据房屋状态设置房屋发布情况 if (h.getIsShow().equals("N")) { h.setIsShow("Y"); h.setCkd("1"); h.setCheckInTime(house.getCheckInTime()); // 房屋设置"发布"状态,房间中除了已出租的房间外都更新为发布状态。 r.setIsShow("Y"); r.setCkd("1"); r.setCheckInTime(house.getCheckInTime()); } else if (h.getIsShow().equals("Y")) { h.setIsShow("N"); h.setCkd("1"); h.setCheckInTime(null); // 如果房屋"取消发布"状态,房间状态全部更改为"不发布"。 r.setIsShow("N"); r.setIsPromotions("N"); r.setIsTop("N"); r.setCkd("1"); r.setCheckInTime(null); } houseAndRoomMapper.updateRoomByHouseCode(r); houseAndRoomMapper.updateHouse(h); } }
/** * 生成房源包 * * @param house * @return * @throws IOException * @throws SQLException * @throws JRException */ @SuppressWarnings({"rawtypes", "unchecked"}) public Map<String, String> createHousePackage(Room room) throws IOException, JRException, SQLException { Map<String, String> housePackage = new HashMap<String, String>(); // 临时存储文件路径 System.out.println("读取房源包路径"); URL s = HouseService.class.getClassLoader().getResource(""); String tempDir = s.getPath().substring(0, s.getPath().lastIndexOf("WEB-INF")) + "//housePackage/"; // String tempDir = ResourceManager.getString("zip.file.path"); // 根据房间编号获得房间图片信息,小区图片信息,公共区域信息等 Room r = houseAndRoomMapper.selectByRoomId(room.getRoomId()); House h = houseAndRoomMapper.selectHouseByCode(r.getSysHouseId()); // 房源包名称 String fileName = h.getHouseCode() + r.getRoomName() + ".zip"; String file = tempDir + "//" + fileName; housePackage.put("fileName", fileName); housePackage.put("downFilePath", file); // 文件加锁 FileOutputStream fos = new FileOutputStream(file); ZipOutputStream zos = new ZipOutputStream(new BufferedOutputStream(fos)); zos.setEncoding("GBK"); // 图片服务器路径 String imageUrl = ResourceManager.getString("image.url"); // 室内图片 List<RoomPictures> rps = houseAndRoomMapper.selectRoomPicturesByRoomId(r.getSysRoomId()); int i = 0; long start = System.currentTimeMillis(); for (RoomPictures rp : rps) { String path = rp.getImagepath(); if (path != null && !path.equals("")) { int _a = path.lastIndexOf("/"); path = path.substring(0, _a) + "//v480x360_" + path.substring(_a + 1); URL url = new URL(imageUrl + "//" + path); InputStream is = url.openStream(); String _fileName = "室内图片/" + (i++) + ".jpg"; CompressionUtil.compressFile(zos, is, _fileName); is.close(); } } // 公共区域图片 List<RoomPictures> hps = houseAndRoomMapper.selectRoomPicturesByHouseId(r.getSysHouseId()); i = 0; for (RoomPictures rp : hps) { String path = rp.getImagepath(); if (path != null && !path.equals("")) { int _a = path.lastIndexOf("/"); path = path.substring(0, _a) + "//v480x360_" + path.substring(_a + 1); URL url = new URL(imageUrl + "//" + path); InputStream is = url.openStream(); String _fileName = "公共区域图片/" + (i++) + ".jpg"; CompressionUtil.compressFile(zos, is, _fileName); is.close(); } } long end = System.currentTimeMillis(); System.out.println("图片打包时间:" + (end - start) / 1000); // 物品配置家具 Map map = new HashMap(); map.put("sysRoomId", r.getSysRoomId()); map.put("itemType", "jj4"); map.put("sysHouseId", r.getSysHouseId()); List<String> _c1 = houseAndRoomMapper.selectItemByRoom(map); List<String> _c2 = houseAndRoomMapper.selectItemByPub(map); // 家电 map.put("itemType", "jd"); List<String> _c3 = houseAndRoomMapper.selectItemByRoom(map); List<String> _c4 = houseAndRoomMapper.selectItemByPub(map); // 家居 map.put("itemType", "jj1"); List<String> _c5 = houseAndRoomMapper.selectItemByRoom(map); List<String> _c6 = houseAndRoomMapper.selectItemByPub(map); System.out.println("读取jasper文件"); // 其它房屋租住状态 StringBuilder sb = new StringBuilder(); List<Map> rooms = houseAndRoomMapper.selectOtherRoom(map); int count = 0; for (int j = 0; j < rooms.size(); j++) { Map rm = rooms.get(j); String rentstatus = rm.get("rentstatus") != null ? rm.get("rentstatus").toString() : ""; String position = rm.get("roomposition") != null ? rm.get("roomposition").toString() : ""; if (rentstatus.equals("ycz")) { String sex = rm.get("sex") != null ? rm.get("sex").toString() : ""; String professional = rm.get("professional") != null ? rm.get("professional").toString() : ""; String code = rm.get("code") != null ? rm.get("code").toString() : ""; ; sb.append(!position.equals("") ? (position + "卧" + code + "住着一位") : ""); sb.append(!sex.equals("") ? sex + "性" : ""); sb.append(!professional.equals("") ? professional : ""); sb.append(";"); } else { sb.append(!position.equals("") ? (position + "卧待租 ;") : "卧室待租; "); count++; } } // 房间待租数量 if (count == rooms.size()) { sb = new StringBuilder(); } // 房源word文档 URL u = this.getClass().getClassLoader().getResource("cn/ziroom/house/service/package.jasper"); System.out.println("文件路径:" + u.getPath()); String reportFile = u.getFile(); Map parameter = new HashMap(); parameter.put("roomId", room.getRoomId()); parameter.put("c1", StringUtils.split(_c1, ",")); parameter.put("c2", StringUtils.split(_c2, ",")); parameter.put("c3", StringUtils.split(_c3, ",")); parameter.put("c4", StringUtils.split(_c4, ",")); parameter.put("c5", StringUtils.split(_c5, ",")); parameter.put("c6", StringUtils.split(_c6, ",")); parameter.put("c7", sb.toString()); start = System.currentTimeMillis(); System.out.println("填充报表"); // docx String filePath = JasperreportsUtils.docx(reportFile, parameter, dataSource.getConnection()); File _file = new File(filePath); FileInputStream fis = new FileInputStream(_file); CompressionUtil.compressFile(zos, fis, h.getHouseCode() + r.getRoomName() + ".docx"); fis.close(); _file.delete(); // doc String docFilePath = JasperreportsUtils.doc(reportFile, parameter, dataSource.getConnection()); File _docfile = new File(docFilePath); FileInputStream docfis = new FileInputStream(_docfile); CompressionUtil.compressFile(zos, docfis, h.getHouseCode() + r.getRoomName() + ".doc"); fis.close(); _docfile.delete(); byte[] html = JasperreportsUtils.html(reportFile, parameter, dataSource.getConnection()); InputStream is = new ByteArrayInputStream(html); CompressionUtil.compressFile(zos, is, h.getHouseCode() + r.getRoomName() + ".html"); end = System.currentTimeMillis(); System.out.println("报表生成时间:" + (end - start) / 1000); is.close(); zos.close(); fos.close(); return housePackage; }
/** * 房间发布功能 * * @param roomCode */ public void pubRoom(Room r) { // 房间编号查询房间 Room room = houseAndRoomMapper.selectRoomByCode(r.getSysRoomId()); // 房间发布状态变更 if (room != null) { if (room.getIsShow().equals("Y")) { room.setIsShow("N"); room.setIsPromotions("N"); room.setIsTop("N"); room.setCkd("1"); room.setCheckInTime(null); } else if (room.getIsShow().equals("N")) { room.setIsShow("Y"); room.setCkd("1"); if (r.getCheckInTime() != null) { room.setCheckInTime(r.getCheckInTime()); } } } houseAndRoomMapper.updateRoom(room); // 获得房屋房间数量及发布房间数量 int countRoom = houseAndRoomMapper.countRoom(room.getSysHouseId()); int countPubRoom = houseAndRoomMapper.countPubRoom(room); if (countRoom == countPubRoom) { House h = new House(); h.setSysHouseId(room.getSysHouseId()); h.setIsShow(room.getIsShow()); houseAndRoomMapper.updateHouse(h); } }
/** * 房间发布页面请求处理方法 * * @param house * @return */ public Room roomPubForm(Room room) { room = houseAndRoomMapper.selectRoomByCode(room.getSysRoomId()); return room; }