spacesaction.java

论坛软件系统亦称电子公告板(BBS)系统

				list.add(mythread);
			}
		}
		request.setAttribute("myreplay", list);
		Memberspaces memberspace = spaceServer.findMemberspace(uid);
		if(memberspace==null){
			request.setAttribute("errorInfo", "该用户空间没有开启,请到个人空间首页开启。");
			return mapping.findForward("showMessage");
		}
		String layout = memberspace.getLayout();
		Map menuMap = new HashMap();
		if (layout.indexOf("[myblogs]") != -1) {
			menuMap.put("myblogs", "ok");
		}
		if (layout.indexOf("[mythreads]") != -1) {
			menuMap.put("mythreads", "ok");
		}
		if (layout.indexOf("[myreplies]") != -1) {
			menuMap.put("myreplies", "ok");
		}
		if (layout.indexOf("[myrewards]") != -1) {
			menuMap.put("myrewards", "ok");
		}
		if (layout.indexOf("[mytrades]") != -1) {
			menuMap.put("mytrades", "ok");
		}
		if (layout.indexOf("[myfavforums]") != -1) {
			menuMap.put("myfavforums", "ok");
		}
		if (layout.indexOf("[myfavthreads]") != -1) {
			menuMap.put("myfavthreads", "ok");
		}
		request.setAttribute("menuMap", menuMap);
		UserInfoVO userinfo = new UserInfoVO();
		userinfo.setUsername(member.getUsername());
		userinfo.setAvoras(memberfild.getAvatar());
		String bio = memberfild.getBio();
		String[] bios = bio.split("\t");
		if(bios!=null && bios.length>0){
			userinfo.setBios(bios[0]);
		}else{
			userinfo.setBios("");
		}
		userinfo.setWidth(memberfild.getAvatarwidth());
		userinfo.setHeight(memberfild.getAvatarheight());
		userinfo.setIsonline(spaceServer.findSessionByUid(uid));
		request.setAttribute("userinfo", userinfo);
		request.setAttribute("member", member);
		request.setAttribute("memberspace", memberspace);
		return mapping.findForward("tomyreplay");
	}
	@SuppressWarnings("unchecked")
	public ActionForward toMyrewards(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response) {
		String suid = request.getParameter("uid");  
		int uid = convertInt(suid);
		Members member = memberServer.findMemberById(uid);
		if(member==null){
			request.setAttribute("errorInfo", "该用户不存在或已被删除，请返回上一页");
			return mapping.findForward("showMessage");
		}
		Map<String,String> settings=(Map<String,String>)request.getAttribute("settings");
		int creditstrans = Integer.valueOf(settings.get("creditstrans"));
		Map extcredits = ((DataParse) BeanFactory.getBean("dataParse")).characterParse(settings.get("extcredits"),false);
		String unit = "";
		if(creditstrans>0){
			unit = (String) ((Map) extcredits.get(creditstrans)).get("unit");
		}
		String blogcount = "select count(*) from Threads as t where t.authorid = " + uid + " and t.special = 3 and t.displayorder>=0";
		int size = threadService.findThreadCountByHql(blogcount);
		String currpage = request.getParameter("page");
		int pages = 1;
		if (currpage != null) {
			pages = Integer.valueOf(currpage);
		}
		int pagesize = 10;
		LogPage logpage = new LogPage(size, pagesize, pages);
		int beginsize = (pages - 1) * pagesize;
		if (beginsize > size) {
			beginsize = size;
		}
		request.setAttribute("logpage", logpage);
		Memberfields memberfild = memberServer.findMemberfieldsById(uid);
		request.setAttribute("bember", member);
		request.setAttribute("memberfild", memberfild);
		List list = new ArrayList();
		String rephql = "select t.*,f.name from jrun_threads as t left join jrun_forums as f on t.fid=f.fid  where t.authorid = " + uid + " and t.special = 3 and t.displayorder>=0 order by t.lastpost desc limit "+beginsize+","+pagesize;
		List<Map<String,String>> rewardthread = dataBaseService.executeQuery(rephql);
		if (rewardthread != null && rewardthread.size()>0) {
			for (Map<String,String> t : rewardthread) {
				MythreadsVO mythread = new MythreadsVO();
				mythread.setFid(t.get("fid"));
				mythread.setForums(t.get("name"));
				mythread.setTid(t.get("tid"));
				mythread.setSubjcet(t.get("subject"));
				mythread.setRewards(t.get("price")+ unit);
				mythread.setSpecial(t.get("special"));
				mythread.setPrice(t.get("price"));
				list.add(mythread);
			}
		}
		request.setAttribute("myreward", list);
		Memberspaces memberspace = spaceServer.findMemberspace(uid);
		if(memberspace==null){
			request.setAttribute("errorInfo", "该用户空间没有开启,请到个人空间首页开启。");
			return mapping.findForward("showMessage");
		}
		String layout = memberspace.getLayout();
		Map menuMap = new HashMap();
		if (layout.indexOf("[myblogs]") != -1) {
			menuMap.put("myblogs", "ok");
		}
		if (layout.indexOf("[mythreads]") != -1) {
			menuMap.put("mythreads", "ok");
		}
		if (layout.indexOf("[myreplies]") != -1) {
			menuMap.put("myreplies", "ok");
		}
		if (layout.indexOf("[myrewards]") != -1) {
			menuMap.put("myrewards", "ok");
		}
		if (layout.indexOf("[mytrades]") != -1) {
			menuMap.put("mytrades", "ok");
		}
		if (layout.indexOf("[myfavforums]") != -1) {
			menuMap.put("myfavforums", "ok");
		}
		if (layout.indexOf("[myfavthreads]") != -1) {
			menuMap.put("myfavthreads", "ok");
		}
		request.setAttribute("menuMap", menuMap);
		UserInfoVO userinfo = new UserInfoVO();
		userinfo.setUsername(member.getUsername());
		userinfo.setAvoras(memberfild.getAvatar());
		String bio = memberfild.getBio();
		String[] bios = bio.split("\t");
		if(bios!=null && bios.length>0){
			userinfo.setBios(bios[0]);
		}else{
			userinfo.setBios("");
		}
		userinfo.setWidth(memberfild.getAvatarwidth());
		userinfo.setHeight(memberfild.getAvatarheight());
		userinfo.setIsonline(spaceServer.findSessionByUid(uid));
		request.setAttribute("userinfo", userinfo);
		request.setAttribute("member", member);
		request.setAttribute("memberspace", memberspace);
		return mapping.findForward("tomyreward");
	}

	@SuppressWarnings("unchecked")
	public ActionForward toMytrades(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response) {
		String suid = request.getParameter("uid");  
		int uid = convertInt(suid);
		Members member = memberServer.findMemberById(uid);
		if(member==null){
			request.setAttribute("errorInfo", "该用户不存在或已被删除，请返回上一页");
			return mapping.findForward("showMessage");
		}
		Memberfields memberfild = memberServer.findMemberfieldsById(uid);
		Memberspaces memberspace = spaceServer.findMemberspace(uid);
		request.setAttribute("bember", member);
		request.setAttribute("memberfild", memberfild);
		if(memberspace==null){
			request.setAttribute("errorInfo", "该用户空间没有开启,请到个人空间首页开启。");
			return mapping.findForward("showMessage");
		}
		int timestamp = (Integer)(request.getAttribute("timestamp"));
		Map<String,String> settings=(Map<String,String>)request.getAttribute("settings");
		String layout = memberspace.getLayout();
		Map menuMap = new HashMap();
		if (layout.indexOf("[myblogs]") != -1) {
			menuMap.put("myblogs", "ok");
		}
		if (layout.indexOf("[mythreads]") != -1) {
			menuMap.put("mythreads", "ok");
		}
		if (layout.indexOf("[myreplies]") != -1) {
			menuMap.put("myreplies", "ok");
		}
		if (layout.indexOf("[myrewards]") != -1) {
			menuMap.put("myrewards", "ok");
		}
		if (layout.indexOf("[mytrades]") != -1) {
			menuMap.put("mytrades", "ok");
		}
		if (layout.indexOf("[myfavforums]") != -1) {
			menuMap.put("myfavforums", "ok");
		}
		if (layout.indexOf("[myfavthreads]") != -1) {
			menuMap.put("myfavthreads", "ok");
		}
		request.setAttribute("menuMap", menuMap);
		String bio = memberfild.getBio();
		String[] bios = bio.split("\t");
		if (bios!=null && bios.length > 1) {
			request.setAttribute("tradeinfo", bios[1]);
		}
		UserInfoVO userinfo = new UserInfoVO();
		userinfo.setUsername(member.getUsername());
		userinfo.setAvoras(memberfild.getAvatar());
		if(bios!=null && bios.length>0){
		userinfo.setBios(bios[0]);
		}else{
			userinfo.setBios("");
		}
		userinfo.setWidth(memberfild.getAvatarwidth());
		userinfo.setHeight(memberfild.getAvatarheight());
		userinfo.setIsonline(spaceServer.findSessionByUid(uid));
		request.setAttribute("userinfo", userinfo);
		request.setAttribute("member", member);
		request.setAttribute("memberspace", memberspace);
		String tradetypeid = request.getParameter("tradetypeid");
		String sqladd = "";
		if(tradetypeid ==null || tradetypeid.equals("stick")){
			sqladd = " and t.displayorder > 0 ";
		}else if(tradetypeid.equals("0")){
			sqladd = " and t.typeid = 0 ";
		}
		Map<String,String> ftpmap = ((DataParse) BeanFactory.getBean("dataParse")).characterParse(settings.get("ftp"), false);
		String ftpurl = ftpmap.get("attachurl");
		ftpmap = null;
		String sql = "select t.*,a.isimage,a.attachment,a.thumb,a.remote from jrun_trades t LEFT JOIN jrun_attachments as a ON t.aid=a.aid where t.sellerid = " + uid+ " "+sqladd+" order by t.dateline DESC";
		List<Map<String,String>> trades = dataBaseService.executeQuery(sql);
		for(Map<String,String> trade:trades){
			if(!trade.get("expiration").equals("0")){
				float expiration = (Common.toDigit(trade.get("expiration"),100000000000L,0L).floatValue()-timestamp)/86400;
				if(expiration>0){
					trade.put("expiration", (int)Math.floor(expiration)+"");
				}else{
					trade.put("expiration", "-1");
				}
			}
			if(trade.get("isimage")!=null&&trade.get("isimage").equals("1")){
				String url = trade.get("remote").equals("1")?ftpurl:settings.get("attachurl");
				url = url+"/"+trade.get("attachment");
				url = trade.get("thumb").equals("1")?url+".thumb.jpg":url;
				trade.put("attachment", url);
			}else{
				trade.put("attachment", "images/default/trade_nophoto.gif");
			}
		}
		request.setAttribute("trades", trades);
		if(tradetypeid==null){
			String blogcount = "select count(*) from Threads as t where t.authorid = " + uid + " and t.special = 2 and t.displayorder>=0";
			int size = threadService.findThreadCountByHql(blogcount);
			String currpage = request.getParameter("page");
			int pages = 1;
			if (currpage != null) {
				pages = Integer.valueOf(currpage);
			}
			int pagesize = 10;
			LogPage logpage = new LogPage(size, pagesize, pages);
			int beginsize = (pages - 1) * pagesize;
			if (beginsize > size) {
				beginsize = size;
			}
			request.setAttribute("logpage", logpage);
			List list = new ArrayList();
			String rephql = "from Threads as t where t.authorid = " + uid + " and t.special = 2  and t.displayorder>=0 order by t.lastpost desc";
			List<Threads> threads = threadService.findThreadsByHql(rephql, beginsize, pagesize);
			if (trades != null) {
				for (Threads t : threads) {
					MythreadsVO mythread = new MythreadsVO();
					Forums foum = forumService.findById(t.getFid());
					mythread.setFid(t.getFid() + "");
					if (foum != null) {
						mythread.setForums(foum.getName());
					}
					mythread.setTid(t.getTid() + "");
					mythread.setSubjcet(t.getSubject());
					mythread.setViewnum(t.getViews());
					mythread.setReplaynum(t.getReplies());
					list.add(mythread);
				}
			}
			request.setAttribute("mytrades", list);
		}
		return mapping.findForward("totrades");
	}
	@SuppressWarnings("unchecked")
	public ActionForward toMyfavforums(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response) {
		String suid = request.getParameter("uid");  
		int uid = convertInt(suid);
		Members member = memberServer.findMemberById(uid);
		if(member==null){
			request.setAttribute("errorInfo", "该用户不存在或已被删除，请返回上一页");
			return mapping.findForward("showMessage");
		}
		String blogcount = "select count(*) from Favorites as f where f.id.uid = " + uid + " and f.id.fid <> 0";
		int size = spaceServer.findFavoritesCountByHql(blogcount);
		String currpage = request.getParameter("page");
		int pages = 1;
		if (currpage != null) {
			pages = Integer.valueOf(currpage);
		}
		int pagesize = 10;
		LogPage logpage = new LogPage(size, pagesize, pages);
		int beginsize = (pages - 1) * pagesize;
		if (beginsize > size) {
			beginsize = size;
		}
		request.setAttribute("logpage", logpage);
		Memberfields memberfild = memberServer.findMemberfieldsById(uid);
		request.setAttribute("bember", member);
		request.setAttribute("memberfild", memberfild);
		List<Map<String,String>> myfavform = dataBaseService.executeQuery("select f.fid,f.name,f.threads,f.posts,f.todayposts from jrun_favorites as v left join jrun_forums a