/** * 根据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()); } }