careinfo.java

java阿里巴巴代码

package com.saas.biz.careMgr;

import java.util.ArrayList;
import java.util.HashMap;

import com.saas.biz.commen.commMethodMgr;
import com.saas.biz.dao.careDAO.CareDAO;
import com.saas.biz.dao.careDAO.CareExt;
import com.saas.sys.buffer.Buffers;
import com.saas.sys.dbm.Dbtable;
import com.saas.sys.exp.SaasApplicationException;
import com.saas.sys.log.Logger;

/**
 * @author:LiuYang
 * @desc:客户关怀信息[tf_f_care]
 * @obj_type:0:用户，1：客户, 2：联系人群组，3：客户群组
 * @2008-3-6
 */

public class CareInfo {
	
	
	Dbtable tradeQuery;
	
	
	commMethodMgr comm;
	
	
	Logger log;
	
	
	Buffers inBuffer;
	
	
	Buffers outBuffer;
	
	
	ArrayList queryResult = new ArrayList();
	
	
	
	public CareInfo() {

		log = new Logger(this);
		tradeQuery = new Dbtable();
		comm = new commMethodMgr();
	}
	
	
	public void setTradeQuery(Dbtable tradeQuery) {

		this.tradeQuery = tradeQuery;
	}
	
	
	public Dbtable getTradeQuery() {

		return this.tradeQuery;
	}
	
	
	public void setOutBuffer(Buffers outBuffer) {

		this.outBuffer = outBuffer;
	}
	
	
	public Buffers getOutBuffer() {

		return this.outBuffer;
	}
	
	
	public ArrayList getQueryResult() {

		return this.queryResult;
	}
	
	
	public void setQueryResult(ArrayList queryResult) {

		this.queryResult = queryResult;
	}
	
	
	
	// 增加客户关怀
	public void addCareInfo(Buffers inbuffer) {

		log.LOG_INFO("进入addCareInfo方法...");
		this.outBuffer = inbuffer;
		this.inBuffer = inbuffer;
		int iResult = -1;
		String trade_id = inbuffer.getString("TRADE_ID");
		String cust_id = inbuffer.getString("CUST_ID");
		String oper_user_id = inbuffer.getString("SESSION_USER_ID");
		String entity_type = inbuffer.getString("ENTITY_TYPE");
		String obj_type = inbuffer.getString("OBJ_TYPE");
		String obj_id = inbuffer.getString("OBJ_ID");
		String title = inbuffer.getString("TITLE");
		String content = inbuffer.getString("CONTENT");
		String start_date = inbuffer.getString("START_DATE");
		String end_date = inbuffer.getString("END_DATE");
		String do_tag = inbuffer.getString("DO_TAG");
		String care_result = inbuffer.getString("CARE_RESULT");
		String user_id = inbuffer.getString("USER_ID");
		String act_care_type = inbuffer.getString("ACT_CARE_TYPE");
		String do_date = inbuffer.getString("DO_DATE");
		String end_tag = inbuffer.getString("END_TAG");
		String round_num = inbuffer.getString("ROUND_NUM");
		String remark = inbuffer.getString("REMARK");
		try {
			CareDAO careDao = new CareDAO();
			careDao.setTrade_id(trade_id);
			careDao.setCust_id(cust_id);
			careDao.setEnd_date(end_date);
			careDao.setEntity_type(entity_type);
			careDao.setObj_id(obj_id);
			careDao.setObj_type(obj_type);
			careDao.setOper_user_id(oper_user_id);
			careDao.setAct_care_type(act_care_type);
			careDao.setTitle(title);
			careDao.setContent(content);
			careDao.setStart_date(start_date);
			careDao.setDo_date(do_date);
			careDao.setCare_result(care_result);
			careDao.setUser_id(user_id);
			careDao.setDo_tag(do_tag);
			careDao.setEnd_tag(end_tag);
			careDao.setRound_num(round_num);
			careDao.setRemark(remark);
			iResult = addCareInfo(careDao);
		}
		catch (Exception e) {
			log.LOG_INFO(e.getMessage());
		}
		if (iResult != 0) {
			this.outBuffer.setInt("RESULT_CODE", -1);
			this.outBuffer.setString("RESULT_INFO", "业务处理失败！");
		}
		else {
			this.outBuffer.setInt("RESULT_CODE", 0);
			this.outBuffer.setString("RESULT_INFO", "业务处理成功！");
		}
		log.LOG_INFO("退出addCareInfo方法...");
	}
	
	
	public int addCareInfo(CareDAO careDao) throws SaasApplicationException {

		CareExt careExt = new CareExt();
		careExt.setParam(":VTRADE_ID", careDao.getTrade_id());
		careExt.setParam(":VCUST_ID", careDao.getCust_id());
		careExt.setParam(":VEND_DATE", careDao.getEnd_date());
		careExt.setParam(":VENTITY_TYPE", careDao.getEntity_type());
		careExt.setParam(":VOBJ_ID", careDao.getObj_id());
		careExt.setParam(":VOBJ_TYPE", careDao.getObj_type());
		careExt.setParam(":VOPER_USER_ID", careDao.getOper_user_id());
		careExt.setParam(":VACT_CARE_TYPE", careDao.getAct_care_type());
		careExt.setParam(":VTITLE", careDao.getTitle());
		careExt.setParam(":VCONTENT", careDao.getContent());
		careExt.setParam(":VSTART_DATE", careDao.getStart_date());
		careExt.setParam(":VDO_DATE", careDao.getDo_date());
		careExt.setParam(":VCARE_RESULT", careDao.getCare_result());
		careExt.setParam(":VUSER_ID", careDao.getUser_id());
		careExt.setParam(":VDO_TAG", careDao.getDo_tag());
		careExt.setParam(":VEND_TAG", careDao.getEnd_tag());
		careExt.setParam(":VROUND_NUM", careDao.getRound_num());
		careExt.setParam(":VREMARK", careDao.getRemark());
		tradeQuery.executeBy(careExt.insBy("INS_BY_ALL"));
		return 0;
	}
	
	
	
	// 修改执行状态
	public void updateDo_TagByMsg(Buffers inbuffer) {

		log.LOG_INFO("进入updateDo_TagByMsg方法...");
		this.outBuffer = inbuffer;
		this.inBuffer = inbuffer;
		int iResult = -1;
		String trade_id = inbuffer.getString("TRADE_ID");
		String do_tag = inbuffer.getString("DO_TAG");
		String oper_user_id = inbuffer.getString("SESSION_USER_ID");
		try {
			iResult = updateDo_TagByMsg(trade_id, do_tag,oper_user_id);
		}
		catch (Exception e) {
			log.LOG_INFO(e.getMessage());
		}
		if (iResult != 0) {
			this.outBuffer.setInt("RESULT_CODE", -1);
			this.outBuffer.setString("RESULT_INFO", "业务处理失败！");
		}
		else {
			this.outBuffer.setInt("RESULT_CODE", 0);
			this.outBuffer.setString("RESULT_INFO", "业务处理成功！");
		}
		log.LOG_INFO("退出updateDo_TagByMsg方法...");
	}
	
	
	public int updateDo_TagByMsg(String trade_id, String do_tag,String oper_user_id) throws SaasApplicationException {
		CareExt careExt = new CareExt();
		careExt.setParam(":VTRADE_ID", trade_id);
		careExt.setParam(":VDO_TAG", do_tag);
		careExt.setParam(":VOPER_USER_ID", oper_user_id);
		tradeQuery.executeBy(careExt.insBy("UPDATE_DO_TAG"));
		return 0;
	}
	
	
	
	// 查找关怀信息
	public ArrayList getCareByDate(int iStart, String cust_id, String start_date, String end_date, String obj_type) throws SaasApplicationException {

		if (iStart == 0) {
			iStart = 0;
		}
		else {
			iStart = (iStart - 1) * 20;
		}
		ArrayList list = new ArrayList();
		CareExt careExt = new CareExt();
		careExt.setParam(":VCUST_ID", cust_id);
		if (obj_type != null && !obj_type.equals("")) {
			careExt.setParam(":VOBJ_TYPE", obj_type);
			list = careExt.selByList("SEL_BY_TYPE", iStart, 20);
		}
		else {
			careExt.setParam(":VSTART_DATE", start_date);
			careExt.setParam(":VEND_DATE", end_date);
			list = careExt.selByList("SEL_BY_DATE", iStart, 20);
		}
		
		return list;
	}
	
	
	
	// 关怀信息统计
	public int getCareInfoByDate(String cust_id, String start_date, String end_date) throws SaasApplicationException {

		int size = 0;
		ArrayList list = new ArrayList();
		CareExt careExt = new CareExt();
		careExt.setParam(":VCUST_ID", cust_id);
		careExt.setParam(":VSTART_DATE", start_date);
		careExt.setParam(":VEND_DATE", end_date);
		list = careExt.selByList("SEL_BY_DATE_CT");
		if (list != null && list.size() > 0) {
			HashMap map = (HashMap) list.get(0);
			size = Integer.parseInt(map.get("ct").toString());
		}
		return size;
	}
	
	
	public int getCareInfoByType(String cust_id, String obj_type) throws SaasApplicationException {

		int size = 0;
		ArrayList list = new ArrayList();
		CareExt careExt = new CareExt();
		careExt.setParam(":VCUST_ID", cust_id);
		careExt.setParam(":VOBJ_TYPE", obj_type);
		list = careExt.selByList("SEL_BY_TYPE_CT");
		if (list != null && list.size() > 0) {
			HashMap map = (HashMap) list.get(0);
			size = Integer.parseInt(map.get("ct").toString());
		}
		return size;
	}
	
	
	public int getCareInfoByCust(String cust_id) throws SaasApplicationException {

		int size = 0;
		ArrayList list = new ArrayList();
		CareExt careExt = new CareExt();
		careExt.setParam(":VCUST_ID", cust_id);
		list = careExt.selByList("SEL_BY_CUST_CT");
		if (list != null && list.size() > 0) {
			HashMap map = (HashMap) list.get(0);
			size = Integer.parseInt(map.get("ct").toString());
		}
		return size;
	}
	
	
	
	// 查询出所有未执行的关怀信息
	public ArrayList getCareByCust(int iStart, String cust_id) throws SaasApplicationException {

		if (iStart == 0) {
			iStart = 0;
		}
		else {
			iStart = (iStart - 1) * 20;
		}
		ArrayList list = new ArrayList();
		CareExt careExt = new CareExt();
		careExt.setParam(":VCUST_ID", cust_id);
		list = careExt.selByList("SEL_BY_CUST", iStart, 20);
		return list;
	}
}