public Map<String, Object> getRoomVoById(String roomid) { if (jdbcTemplate == null) { jdbcTemplate = (JdbcTemplate) SpringManage.getInstance().getObject("jdbcTemplate"); } Map<String, Object> result = new HashMap<String, Object>(); List<RoomVo> roomVos = new ArrayList<RoomVo>(); StringBuilder sql = new StringBuilder(); StringBuilder count = new StringBuilder(); sql.append("select * from ").append(RoomVo.VIEWNAME).append(" where id =" + roomid); System.out.println("根据房源ID 获取房源明细 :" + sql.toString()); List list = jdbcTemplate.queryForList(sql.toString()); if (list != null && list.size() > 0) { Map<String, Object> map = (Map<String, Object>) list.get(0); RoomVo roomVo = new RoomVo(); LTBeanUtils.getInstance().Map2Bean(map, roomVo); if (StringUtils.isNotBlank(roomVo.getPicture())) { String[] filenames = roomVo.getPicture().split(","); List<String> urls = new ArrayList<String>(); for (int k = 0; k < filenames.length; k++) { String url = FileUtils.downloadUrl2(filenames[k]); System.out.println(" url :" + url); urls.add(url); } roomVo.setPicture(StringUtils.join(urls.toArray(new String[] {}), ",")); } roomVos.add(roomVo); } result.put("data", roomVos); result.put("code", "0"); result.put("msg", "查询成功"); return result; }
public RoomVo getRoomDetailByRoomSeq(String roomSeq) { Map<String, Object> result = new HashMap<String, Object>(); RoomVo roomVo = new RoomVo(); StringBuilder sql = new StringBuilder(); sql.append("select * from ") .append(RoomVo.VIEWNAME) .append(" where roomSeq = '" + roomSeq + "'"); List list = jdbcTemplate.queryForList(sql.toString()); if (list != null && list.size() > 0) { Map<String, Object> map = (Map<String, Object>) list.get(0); LTBeanUtils.getInstance().Map2Bean(map, roomVo); if (StringUtils.isNotBlank(roomVo.getPicture())) { String[] filenames = roomVo.getPicture().split(","); List<String> urls = new ArrayList<String>(); for (int k = 0; k < filenames.length; k++) { String url = FileUtils.downloadUrl2(filenames[k]); System.out.println(" url :" + url); urls.add(url); } roomVo.setPicture(StringUtils.join(urls.toArray(new String[] {}), ",")); } } return roomVo; }
public Map<String, Object> getRoomDetailById(String roomid) { if (jdbcTemplate == null) { jdbcTemplate = (JdbcTemplate) SpringManage.getInstance().getObject("jdbcTemplate"); } Map<String, Object> result = new HashMap<String, Object>(); List<RoomVo> roomVos = new ArrayList<RoomVo>(); StringBuilder sql = new StringBuilder(); StringBuilder count = new StringBuilder(); // String[] fields = new String[]{"id", "price", "comm_name", "kind", // "address", "picture", "recommend", "recommendTarget"}; // String condition = " where concat(comm_name, comm_pinyin) like '%" + // comm_name + "%' and cityid like '%" + cityid + "%' and status = '0'"; // Integer total = jdbcTemplate.queryForInt( "select count(id) from " + // RoomVo.VIEWNAME + condition ); // sql.append( "select " + StringUtils.join(fields, ",") + " from " + // RoomVo.VIEWNAME + condition) // .append(" limit " + curPage * 5 + ", 5"); // String[] fields = new String[]{"id", "price", "comm_name", "kind", // "address", "picture", "recommend", "recommendTarget"}; System.out.println("根据房源ID 获取房源明细 :" + sql.toString()); sql.append("select * from ") .append(RoomVo.VIEWNAME) .append(" where id =" + roomid + " and picture like '%.thumb.%'"); // sql.append("select * from ").append(RoomVo.VIEWNAME) // .append(" where id =" + roomid); List list = jdbcTemplate.queryForList(sql.toString()); if (list != null && list.size() > 0) { Map<String, Object> map = (Map<String, Object>) list.get(0); RoomVo roomVo = new RoomVo(); LTBeanUtils.getInstance().Map2Bean(map, roomVo); if (StringUtils.isNotBlank(roomVo.getPicture())) { String[] filenames = roomVo.getPicture().split(","); List<String> urls = new ArrayList<String>(); for (int k = 0; k < filenames.length; k++) { if (filenames[k].contains(".thumb.")) { String url = FileUtils.downloadUrl2(filenames[k]); System.out.println(" url :" + url); urls.add(url); } } roomVo.setPicture(StringUtils.join(urls.toArray(new String[] {}), ",")); } roomVos.add(roomVo); } result.put("data", roomVos); result.put("code", "0"); result.put("msg", "查询成功"); return result; }
public Map<String, Object> getRoomList( AppRoomPage page, String lonAndLat, String comm_name, String cityid) { if (jdbcTemplate == null) { jdbcTemplate = (JdbcTemplate) SpringManage.getInstance().getObject("jdbcTemplate"); } Map<String, Object> result = new HashMap<String, Object>(); List<RoomVo> roomVos = new ArrayList<RoomVo>(); StringBuilder sql = new StringBuilder(); StringBuilder count = new StringBuilder(); String[] fields = new String[] { "id", "price", "comm_name", "kind", "address", "picture", "recommend", "recommendTarget", "size", "rent_type", "hm_number", "busiCircle", "longitude", "latitude", "roomSeq", "smartlock", "isRecommend" }; String condition = " where concat(comm_name, comm_pinyin) like '%" + comm_name + "%' and cityid like '%" + cityid + "%' " + getRoomListFilter(); // and status = '0' Integer total = jdbcTemplate.queryForInt("select count(id) from " + RoomVo.VIEWNAME + condition); sql.append("select " + StringUtils.join(fields, ",") + " from " + RoomVo.VIEWNAME + condition) .append(AppRoomPageUtil.getInstance().getPageSql(page, lonAndLat, true)); // .append(" limit " + curPage * 5 + ", 5"); System.out.println( "总数:" + "select count(id) from " + RoomVo.VIEWNAME + condition + AppRoomPageUtil.getInstance().getPageSql(page, lonAndLat, false)); System.out.println("接口根据小区名进行查找房源:" + sql.toString()); List list = jdbcTemplate.queryForList(sql.toString()); for (int i = 0; list != null && i < list.size(); i++) { Map<String, Object> map = (Map<String, Object>) list.get(i); RoomVo roomVo = new RoomVo(); LTBeanUtils.getInstance().Map2Bean(map, roomVo); if (StringUtils.isNotBlank(roomVo.getPicture())) { String[] filenames = roomVo.getPicture().split(","); List<String> urls = new ArrayList<String>(); for (int k = 0; k < filenames.length; k++) { String url = FileUtils.downloadUrl2(filenames[k]); System.out.println(" url :" + url); urls.add(url); } roomVo.setPicture(StringUtils.join(urls.toArray(new String[] {}), ",")); } roomVos.add(roomVo); } if ((page.getCurPage() + 1) * page.getRows() <= total) { result.put("curPage", page.getCurPage() + 1); } else { result.put("curPage", page.getCurPage()); } result.put("data", roomVos); result.put("code", "0"); result.put("msg", "查询成功"); result.put("total", total); return result; }
/** ******************************** app 专用接口 **************************************** */ public Map<String, Object> getFeaturedList(String cityid) { Map<String, Object> result = new HashMap<String, Object>(); List<RoomVo> roomVos = new ArrayList<RoomVo>(); if (jdbcTemplate == null) { jdbcTemplate = (JdbcTemplate) SpringManage.getInstance().getObject("jdbcTemplate"); } StringBuilder sql = new StringBuilder(); String[] fields = new String[] { "id", "price", "comm_name", "kind", "address", "picture", "recommend", "recommendTarget", "size", "rent_type", "hm_number", "busiCircle", "longitude", "latitude", "roomSeq", "smartlock", "isRecommend" }; String condition = " where cityid like '%" + cityid + "%' " + " AND ( isRecommend = 1 )"; // 是否是推荐房源的字段";//getRoomListFilter() ;//and status = '0' sql.append("select " + StringUtils.join(fields, ",") + " from " + RoomVo.VIEWNAME + condition); List list = jdbcTemplate.queryForList(sql.toString()); for (int i = 0; list != null && i < list.size(); i++) { Map<String, Object> map = (Map<String, Object>) list.get(i); RoomVo roomVo = new RoomVo(); LTBeanUtils.getInstance().Map2Bean(map, roomVo); if (StringUtils.isNotBlank(roomVo.getPicture())) { String[] filenames = roomVo.getPicture().split(","); List<String> urls = new ArrayList<String>(); for (int k = 0; k < filenames.length; k++) { String url = FileUtils.downloadUrl2(filenames[k]); System.out.println(" url :" + url); urls.add(url); } roomVo.setPicture(StringUtils.join(urls.toArray(new String[] {}), ",")); } /* * if( map.get("URL") != null ){ String url = (String) * map.get("URL"); if( StringUtils.isNotBlank( url.trim() ) ){ url = * FileUtils.downloadUrl(url); roomVo.setPicture(url); } } if( * roomVos.contains( roomVo ) ){//已经包含了 int pos = roomVos.indexOf( * roomVo ); String picture = roomVos.get( pos ).getPicture(); if( * picture == null ){ picture = roomVo.getPicture(); } else { * picture += "," + roomVo.getPicture(); } roomVos.get( pos * ).setPicture(picture); } else { roomVos.add( roomVo ); } */ roomVos.add(roomVo); } result.put("data", roomVos); result.put("code", "0"); result.put("msg", "查询成功"); return result; }