CallCenterAction.java

package com.sp2p.action.front;

import java.sql.SQLException;
import java.util.List;
import java.util.Map;

import org.apache.commons.lang.StringUtils;
import org.apache.commons.logging.Log;
import org.apache.commons.logging.LogFactory;

import com.shove.Convert;
import com.shove.data.DataException;
import com.shove.util.SqlInfusion;
import com.shove.vo.PageBean;
import com.sp2p.constants.IConstants;
import com.sp2p.service.HelpAndServicerService;

public class CallCenterAction extends BaseFrontAction {
	
	public static Log log = LogFactory.getLog(FrontMyFinanceAction.class);
	private static final long serialVersionUID = 1L;	
	private HelpAndServicerService callCenterService;
	
	private Map<String,String> helpAnswer;
	private String question;

	public HelpAndServicerService getCallCenterService() {
		return callCenterService;
	}

	public void setCallCenterService(HelpAndServicerService callCenterService) {
		this.callCenterService = callCenterService;
	}

	public String getQuestion() {
		return question;
	}

	public void setQuestion(String question) {
		this.question = question;
	}

	public void setHelpAnswer(Map<String, String> helpAnswer) {
		this.helpAnswer = helpAnswer;
	}

	public String callCenterInit() throws SQLException, DataException{
		String pageNum = SqlInfusion.FilteSqlInfusion(request().getParameter("curPage"));
		String cid = SqlInfusion.FilteSqlInfusion(request().getParameter("cid") == null?"1":request().getParameter("cid"));
		request().setAttribute("cid", cid);
		
		long typeId = Long.parseLong(cid);
		try{	
			//查询左边菜单
			pageBean = new PageBean();
			callCenterService.queryHelpTypes(pageBean);
			List<Map<String, Object>> types = pageBean.getPage();
			
			Map<String,String> values = null;
			String curDes = null;
			if(SqlInfusion.FilteSqlInfusion(request().getParameter("type"))!= null){
				values = callCenterService.getDescribeById(typeId);
				curDes = values.get("helpDescribe");//获得帮助类型描述
			}
			
			//右边问题
			
			pageBean = new PageBean();
//			pageBean.setPageSize(40);
			if(StringUtils.isNotBlank(pageNum)){
				pageBean.setPageNum(pageNum);
			}
			
			callCenterService.queryHelpQuestions(pageBean,typeId);
			List<Map<String, Object>> questions = pageBean.getPage();
			
			List<Map<String, Object>> lists;//客服列表
			lists = callCenterService.queryKefuLimit4();
			request().setAttribute("types", types);
			request().setAttribute("curDes", curDes);
			request().setAttribute("typeId", typeId);
			request().setAttribute("lists", lists);
			
			/**
			 * 2013-04-16 顶部客服链接  链接到客服列表页面
			 */
			String showkf = Convert.strToStr(request("showkf"),null);
			if(showkf != null){
				request().setAttribute("showkf", showkf);
			}
		}catch(DataException e){
			log.error(e);
			e.printStackTrace();
			throw e;
		}catch(SQLException e){
			log.error(e);
			e.printStackTrace();
			throw e;
		}
		
		return SUCCESS;
	}
	
	/**
	 * 显示客服列表
	 * @return
	 * @throws DataException 
	 * @throws SQLException 
	 */
	public String callKfsInit() throws SQLException, DataException{
		try{
			List<Map<String,Object>> lists;
			lists = callCenterService.queryKefuList();
			request().setAttribute("lists", lists);
		}catch(DataException e){
			log.error(e);
			e.printStackTrace();
			throw e;
		}catch(SQLException e){
			log.error(e);
			e.printStackTrace();
			throw e;
		}
		return SUCCESS;
	}
	
	public String queryCallCenterInit() throws SQLException, DataException{
		String pageNum = SqlInfusion.FilteSqlInfusion(request().getParameter("curPage"));
		long typeId = Long.parseLong(request().getParameter("cid"));
		//前台显示列表类型
		if(StringUtils.isNotBlank(pageNum)){
			pageBean.setPageNum(pageNum);
		}
		
		pageBean.setPageSize(4);
		try{
			callCenterService.queryAllAnswerLists(IConstants.SORT_TYPE_DESC, pageBean,typeId);
			request().setAttribute("cid", typeId);
		}catch(DataException e){
			log.error(e);
			e.printStackTrace();
			throw e;
		}catch(SQLException e){
			log.error(e);
			e.printStackTrace();
			throw e;
		}
		return SUCCESS;
	}
	
	public String queryCallCenterAnswer() throws Exception{
		String id = Convert.strToStr(request("id"), "");;
		
		//添加浏览量
		try{
			helpAnswer = callCenterService.queryAnswer(Convert.strToLong(id, -1));
			callCenterService.updateQuestionBrowse(Convert.strToLong(id, -1));
		}catch(SQLException e){
			log.error(e);
			e.printStackTrace();
			throw e;
		}
		getOut().print(helpAnswer.get("anwer"));//获得对应问题的回答值
		return null;
	}
}