/**
* 根据actId，objId得到相关记录
*
* @param targetType
* @param actId
* @param objId
* @return
*/
private List queryList(String targetType, String actId, String objId) {
StringBuffer sb1 = new StringBuffer();
if (TargetTypeConstantValue.TARGETTYPE_CONTACTPERSON_TYPE.equals(targetType)) { // 联系人
sb1.append(
"select * from crm_activity_contactperson "
+ " where activateid = "
+ actId
+ " and userid ="
+ objId);
} else if (TargetTypeConstantValue.TARGETTYPE_CUSTOMER_TYPE.equals(targetType)) { // 客户
sb1.append(
"select * from crm_activity_cust "
+ " where activateid = "
+ actId
+ " and custid ="
+ objId);
} else if (TargetTypeConstantValue.TARGETTYPE_CHANNEL_TYPE.equals(targetType)) { // 渠道
sb1.append(
"select * from crm_activity_channel "
+ " where activateid = "
+ actId
+ " and channelid ="
+ objId);
} else if (TargetTypeConstantValue.TARGETTYPE_FELLOWSHIP_TYPE.equals(targetType)) { // 合作伙伴
sb1.append(
"select * from crm_activity_fellow "
+ " where activateid = "
+ actId
+ " and fellowid ="
+ objId);
}
return jdbcManager.queryForList(sb1.toString());
}
/**
* 根据对象类型及活动的ID得到该活动的相关对象的ID记录
*
* @param targetType
* @param userId
* @return
*/
public String getObjIdByAct(String targetType, String act) {
String actIds = "";
List list = new ArrayList();
List lists = new ArrayList();
StringBuffer hql = new StringBuffer();
if (TargetTypeConstantValue.TARGETTYPE_CUSTOMER_TYPE.equals(targetType)) {
hql.append("select actc.custid as ACIID from");
hql.append(" crm_activity_cust actc ");
hql.append(" where actc.activateid = ?");
list.add(act);
lists = jdbcManager.queryForList(hql.toString(), list.toArray());
} else if (TargetTypeConstantValue.TARGETTYPE_CHANNEL_TYPE.equals(targetType)) {
hql.append("select actc.channelid as ACIID from");
hql.append(" crm_activity_channel actc ");
hql.append(" where actc.activateid = ?");
list.add(act);
lists = jdbcManager.queryForList(hql.toString(), list.toArray());
} else if (TargetTypeConstantValue.TARGETTYPE_CONTACTPERSON_TYPE.equals(targetType)) {
hql.append("select actc.userid as ACIID from");
hql.append(" crm_activity_contactperson actc ");
hql.append(" where actc.activateid = ?");
list.add(act);
lists = jdbcManager.queryForList(hql.toString(), list.toArray());
} else if (TargetTypeConstantValue.TARGETTYPE_FELLOWSHIP_TYPE.equals(targetType)) {
hql.append("select actc.fellowid as ACIID from");
hql.append(" crm_activity_fellow actc ");
hql.append(" where actc.activateid = ?");
list.add(act);
lists = jdbcManager.queryForList(hql.toString(), list.toArray());
} else if ("123456".equals(targetType)) {
hql.append("select actc.itemid as ACIID ");
hql.append(" from crm_activity actc ");
hql.append(" where actc.id = ?");
list.add(act);
lists = jdbcManager.queryForList(hql.toString(), list.toArray());
} else {
lists = null;
}
if (lists != null) {
Iterator it = lists.iterator();
while (it.hasNext()) {
Map param = (Map) it.next();
String actId = param.get("ACIID").toString();
actIds = actId + "," + actIds;
}
}
if (!StringUtil.isStrEmpty(actIds)) {
return actIds.substring(0, actIds.length() - 1);
} else {
return actIds;
}
}
/**
* 根据类型得到查询语句
*
* @param targetType
* @param actId
* @param objId
* @return
*/
private void inserSqlByTaregtType(String targetType, String actId, String objId) {
StringBuffer sb = new StringBuffer();
if (TargetTypeConstantValue.TARGETTYPE_CONTACTPERSON_TYPE.equals(targetType)) { // 联系人
sb.append(
"insert into crm_activity_contactperson (activateid,userid)"
+ " values ("
+ actId
+ ","
+ objId
+ ")");
} else if (TargetTypeConstantValue.TARGETTYPE_CUSTOMER_TYPE.equals(targetType)) { // 客户
sb.append(
"insert into crm_activity_cust (activateid, custid)"
+ " values ("
+ actId
+ ","
+ objId
+ ")");
} else if (TargetTypeConstantValue.TARGETTYPE_CHANNEL_TYPE.equals(targetType)) { // 渠道
sb.append(
"insert into crm_activity_channel (activateid, channelid)"
+ " values ("
+ actId
+ ","
+ objId
+ ")");
} else if (TargetTypeConstantValue.TARGETTYPE_FELLOWSHIP_TYPE.equals(targetType)) { // 合作伙伴
sb.append(
"insert into crm_activity_fellow (activateid, fellowid)"
+ " values ("
+ actId
+ ","
+ objId
+ ")");
}
if (!StringUtil.isStrEmpty(sb.toString())) {
this.jdbcManager.excute(sb.toString());
}
}
