spacesaction.java

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

						spacevo.setIsnew(true);
					} else {
						spacevo.setIsnew(false);
					}
					list.add(spacevo);
				}
			}
			boolean flag = false;
			for (int i = 0; i < disleft.size(); i++) {
				if (disleft.get(i).toString().equals("myreplies")) {
					flag = true;
				}
			}
			if (flag) {
				leftdisMap.put("myreplies", list);
			} else {
				rightMap.put("myreplies", list);
			}
		}
		String myfavforums = spacemap.get("limitmyfavforums").toString();
		if (!myfavforums.equals("0")) {
			List<Map<String,String>> myfavform = dataBaseService.executeQuery("select f.fid,f.name from jrun_favorites as v left join jrun_forums as f on f.fid=v.fid where v.uid="+uid+" and v.fid<>0 limit "+myfavforums);
			leftdisMap.put("myfavforums", myfavform);
		}
		String myfavthreads = spacemap.get("limitmyfavthreads").toString();
		if (!myfavthreads.equals("0")) {
			List<Map<String,String>> myfavform = dataBaseService.executeQuery("select t.tid,t.subject,t.special,t.price,t.attachment,t.lastpost,t.replies from jrun_favorites as v left join jrun_threads as t on t.tid=v.tid where v.uid="+uid+" and v.tid<>0 limit "+myfavthreads);
			leftdisMap.put("myfavthreads", myfavform);
		}
		String myfriends = spacemap.get("limitmyfriends").toString();
		if (!myfriends.equals("0")) {
			List<Map<String,String>> mybuddys = dataBaseService.executeQuery("select m.uid,m.username from jrun_buddys as b left join jrun_members as m on b.buddyid=m.uid where b.uid="+uid+" limit "+myfriends);
			leftdisMap.put("myfriends", mybuddys);
		}
		String myrewards = spacemap.get("limitmyrewards").toString();
		if (!myrewards.equals("0")) {
			String extcredit = settings.get("extcredits");
			String unit = "";
			String creditstrans = settings.get("creditstrans");
			Map extcredits = dataParse.characterParse(extcredit,false);
			if(!creditstrans.equals("0")){
				Map extcredi = (Map)extcredits.get(Common.toDigit(creditstrans));
				unit  = (String)(extcredi==null || extcredi.get("unit")==null?"":extcredi.get("unit"));
			}
			List list = new ArrayList();
			String bloghql = "select t.*,f.name,p.message,p.pid from jrun_threads as t left join jrun_forums as f on t.fid=f.fid left join jrun_posts as p on t.tid=p.tid where t.authorid = " + uid + " and t.special = 3 and t.displayorder>=0 and p.first=1 order by t.lastpost desc limit "+myrewards;
			List<Map<String,String>> threads = dataBaseService.executeQuery(bloghql);
			if (threads != null && threads.size()>0) {
				for (Map<String,String> thread : threads) {
					SpaceVO spacevo = new SpaceVO();
					spacevo.setFid(Common.toDigit(thread.get("fid")));
					spacevo.setForums(thread.get("name"));
					String message = Common.strip_tags(thread.get("message"));
					spacevo.setPid(Common.toDigit(thread.get("pid")));
					if (message.length() > messagelength) {
						message = message.substring(0, messagelength) + "...";
					}
					spacevo.setMessage(message);
					spacevo.setSubject(thread.get("subject"));
					spacevo.setTid(Common.toDigit(thread.get("tid")));
					if (Common.toDigit(thread.get("lastpost"))> members.getLastvisit()) {
						spacevo.setIsnew(true);
					} else {
						spacevo.setIsnew(false);
					}
					spacevo.setViewnum(Common.toDigit(thread.get("views")));
					spacevo.setReplicenum(Common.toDigit(thread.get("replies")));
					spacevo.setRewards("悬赏: " + thread.get("price") + unit);
					if (thread.get("attachment").equals("1")) {
						spacevo.setIsattc(true);
					} else {
						spacevo.setIsattc(false);
					}
					list.add(spacevo);
				}
			}
			boolean flag = false;
			for (int i = 0; i < disleft.size(); i++) {
				if (disleft.get(i).toString().equals("myrewards")) {
					flag = true;
				}
			}
			if (flag) {
				leftdisMap.put("myrewards", list);
			} else {
				rightMap.put("myrewards", list);
			}
		}
		String mytrades = spacemap.get("limitmytrades").toString();
		if (!mytrades.equals("0")) {
			Map<String,String> ftpmap = 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+ " and t.displayorder > 0 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");
				}
			}
			boolean flag = false;
			for (int i = 0; i < disleft.size(); i++) {
				if (disleft.get(i).toString().equals("mytrades")) {
					flag = true;
				}
			}
			if (flag) {
				leftdisMap.put("mytrades", trades);
			} else {
				rightMap.put("mytrades", trades);
			}
		}
		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);
		request.setAttribute("disleft", disleft);
		request.setAttribute("disright", disright);
		request.setAttribute("rightMap", rightMap);
		request.setAttribute("leftMap", leftdisMap);
		String style = request.getParameter("style");
		if(style!=null && !style.equals("")){
			memberspace.setStyle(style);
		}
		request.setAttribute("memberspace", memberspace);
		request.setAttribute("userinfo", userinfo);
		request.setAttribute("member", members);
		request.setAttribute("memberfild", membrfileds);
		return mapping.findForward("tospace");
	}

	@SuppressWarnings("unused")
	private static int convertInt(String s) {
		int count = 0;
		try {
			count = Integer.valueOf(s);
		} catch (Exception e) {
		}
		return count;
	}

	@SuppressWarnings("unchecked")
	public ActionForward toSpacemodule(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response) {
		HttpSession session = request.getSession();
		int uid = (Integer) session.getAttribute("jsprun_uid");
		Map<String,String> settings=(Map<String,String>)request.getAttribute("settings");
		Map spacemap = ((DataParse) BeanFactory.getBean("dataParse")).characterParse(settings.get("spacedata"),false);
		Memberspaces memberspace = spaceServer.findMemberspace(uid);
		if (memberspace == null) {
			memberspace = new Memberspaces();
			memberspace.setUid(uid);
			memberspace.setDescription("");
			memberspace.setLayout("[userinfo][calendar][myreplies][myfavforums]	[myblogs][mythreads]	");
			memberspace.setSide(Byte.valueOf("1"));
			memberspace.setStyle("default");
			spaceServer.addMemberSpace(memberspace);
		}
		List disleft1 = new ArrayList();
		List disleft2 = new ArrayList();
		List disright = new ArrayList();
		String layout = memberspace.getLayout().trim();
		String[] layouts = layout.split("\\s");
		String leftlayout = "";
		String rightlayout = "";
		if (memberspace.getSide() == 1) {
			leftlayout = layouts[0];
			if (layouts.length > 1) {
				rightlayout = layouts[1];
			}
		} else {
			rightlayout = layouts[0];
			if (layouts.length > 1) {
				leftlayout = layouts[1];
			}
		}
		if (!leftlayout.equals("")) {
			leftlayout = leftlayout.replaceFirst("\\[", "");
			leftlayout = leftlayout.substring(0, leftlayout.length() - 1);
			String lefts[] = leftlayout.split("\\]\\[");
			if (lefts != null) {
				for (String s : lefts) {
					if (memberspace.getSide() == 1) {
						disleft1.add(s);
					} else {
						disleft2.add(s);
					}
				}
			}
		}
		if (!rightlayout.equals("")) {
			rightlayout = rightlayout.replaceFirst("\\[", "");
			rightlayout = rightlayout.substring(0, rightlayout.length() - 1);
			String rights[] = rightlayout.split("\\]\\[");
			if (rights != null) {
				for (String s : rights) {
					disright.add(s);
				}
			}
		}
		String layoutdis[] = memberspace.getLayout().trim().split("\t");
		Members member = memberServer.findMemberById(uid);
		Memberfields memberfild = memberServer.findMemberfieldsById(uid);
		request.setAttribute("member", member);
		Map spacelaguage = new HashMap();
		spacelaguage.put("userinfo", "个人信息");
		spacelaguage.put("calendar", "日历");
		spacelaguage.put("myblogs", "文集");
		spacelaguage.put("mythreads", "主题");
		spacelaguage.put("myreplies", "回复");
		spacelaguage.put("myrewards", "悬赏");
		spacelaguage.put("mytrades", "店铺");
		spacelaguage.put("myvideos", "视频");
		spacelaguage.put("myfriends", "好友");
		spacelaguage.put("myfavforums", "收藏的版块");
		spacelaguage.put("myfavthreads", "收藏的帖子");
		request.setAttribute("spacelaguage", spacelaguage);
		request.setAttribute("memberfild", memberfild);
		if (memberspace.getSide() == 1) {
			request.setAttribute("leftdis1", layoutdis[0]);
			request.setAttribute("rightdis", layoutdis[1]);
		} else {
			request.setAttribute("leftdis2", layoutdis[1]);
			request.setAttribute("rightdis", layoutdis[0]);
		}
		request.setAttribute("spacemap", spacemap);
		request.setAttribute("memberspace", memberspace);
		request.setAttribute("disleft1", disleft1);
		request.setAttribute("disleft2", disleft2);
		request.setAttribute("disright", disright);
		return mapping.findForward("tospacemodule");
	}
	@SuppressWarnings("unchecked")
	public ActionForward editSpacemodule(ActionMapping mapping,
			ActionForm form, HttpServletRequest request,
			HttpServletResponse response) {
		HttpSession session = request.getSession();
		int uid = (Integer) session.getAttribute("jsprun_uid");
		String spacelayout1 = request.getParameter("spacelayout[1]");
		String spacelayout2 = request.getParameter("spacelayout[2]");
		String spacelayout0 = request.getParameter("spacelayout[0]");
		String spacename = request.getParameter("spacename"); 
		String spacedescription = request.getParameter("spacedescription");  
		String spacestyle = request.getParameter("spacestyle")==null?"default":request.getParameter("spacestyle");  
		String spaceside = request.getParameter("spaceside");  
		Memberspaces memberspace = spaceServer.findMemberspace(uid);
		String layout = "";
		if(spacelayout2.equals("")){
			spacelayout2 = spacelayout0;
		}
		if (spaceside.equals("1")) {
			if(spacelayout1.indexOf("userinfo")!=-1){
				layout = spacelayout1 + "\t" + spacelayout2 + "\t";
			}else{
				layout = spacelayout2+ "\t" + spacelayout1 + "\t";
			}
		} else if(spaceside.equals("2")){
			if(spacelayout1.indexOf("userinfo")!=-1){
				layout = spacelayout2+ "\t" + spacelayout1 + "\t";
			}else{
				layout = spacelayout1+ "\t" + spacelayout2 + "\t";
			}
		}else{
			layout = spacelayout2+ "\t" + spacelayout1 + "\t";
			if(spacelayout1.indexOf("userinfo")!=-1){
				layout = spacelayout2+ "\t" + spacelayout1 + "\t";
			}else{
				layout = spacelayout1+ "\t" + spacelayout2 + "\t";
			}
		}
		memberspace.setLayout(layout);
		memberspace.setSide(Byte.valueOf(spaceside));
		memberspace.setStyle(spacestyle);
		if (spacedescription != null) {
			memberspace.setDescription(spacedescription);
		}
		if (spacename != null) {
			Memberfields memberfiled = memberServer.findMemberfieldsById(uid);