/**
* 房屋发布业务处理方法
*
* @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 house
* @return
*/
public House housePubForm(House house) {
house = houseAndRoomMapper.selectHouseByCode(house.getSysHouseId());
return house;
}