@Override
public String getaaa() {
// TODO Auto-generated method stub
Map<String, Object> params = new HashMap<String, Object>();
params.put("lastSynTime", "das");
return clientmapper.getaaa(params);
}
// 这里修改客户
@Override
public int modClient(
Long userId,
Long clientId,
Integer stateId,
Integer rankId,
String time,
String clientUrl,
String clientName,
String clientMark,
String clientAddress,
String coordinate) {
// TODO Auto-generated method stub
Map<String, Object> params = new HashMap<String, Object>();
params.put("userId", userId);
params.put("clientId", clientId);
params.put("stateId", stateId);
params.put("rankId", rankId);
params.put("time", time);
params.put("clientUrl", clientUrl);
params.put("clientName", clientName);
params.put("clientMark", clientMark);
params.put("clientAddress", clientAddress);
params.put("coordinate", coordinate);
int result = clientmapper.modClient(params);
return result;
}
/**
* 【三】
*
* @author Rexsen 对终端信息进行备份 【机会】 【t_sale_chance】 【chance_id】
*/
@Override
public int addChance(ChanceView cv) {
// TODO Auto-generated method stub
Map<String, Object> params = new HashMap<String, Object>();
params.put("majorId", cv.getChanceId());
params.put("majorKey", "chance_id");
params.put("tab", "t_sale_chance");
params.put("userId", cv.getUserId());
int insOrupResult = clientmapper.selCenter(params);
int result = 0;
if (insOrupResult > 0) {
result = clientmapper.upChance(cv);
} else {
result = clientmapper.addChance(cv);
}
return result;
}
// 获取BacklogView备份数据
public List<BacklogView> getBackupsListBacklog(Date synTime, Long userId) {
// TODO Auto-generated method stub
Map<String, Object> params = new HashMap<String, Object>();
params.put("lastSynTime", synTime);
params.put("userId", userId);
List<BacklogView> backupsListBacklog = clientmapper.getBackupsListBacklog(params);
return backupsListBacklog;
}
// 获取ContactsView备份数据
private List<ContactsView> getBackupsListContacts(Date synTime, long userId) {
Map<String, Object> params = new HashMap<String, Object>();
params.put("lastSynTime", synTime);
params.put("userId", userId);
List<ContactsView> backupsListContacts = clientmapper.getBackupsListContacts(params);
return backupsListContacts;
}
// 获取PlanInfoView备份数据
private List<PlanInfoView> getBackupsListPlanInfo(Date synTime, long userId) {
Map<String, Object> params = new HashMap<String, Object>();
params.put("lastSynTime", synTime);
params.put("userId", userId);
List<PlanInfoView> backupsListPlanInfo = clientmapper.getBackupsListPlanInfo(params);
return backupsListPlanInfo;
}
/**
* 【九】
*
* @author Rexsen 对终端信息进行备份 【对客户和联系人关系进行备份】 【t_contacts_chance_relation】 【id】
*/
@Override
public int addContactsChanceRelation(ContactsChanceRelationView ccrv) {
// TODO Auto-generated method stub
Map<String, Object> params = new HashMap<String, Object>();
params.put("majorId", ccrv.getId());
params.put("majorKey", "id");
params.put("tab", "t_contacts_chance_relation");
params.put("userId", ccrv.getUserId());
int insOrupResult = clientmapper.selCenter(params);
int result = 0;
if (insOrupResult > 0) {
result = clientmapper.upContactsChanceRelation(ccrv);
} else {
result = clientmapper.addContactsChanceRelation(ccrv);
}
return result;
}
/**
* 【七】
*
* @author Rexsen 对终端信息进行备份 【销售计划详细信息】 【t_sale_planinfo】 【planinfo_id】
*/
@Override
public int addPlanInfo(PlanInfoView pv) {
// TODO Auto-generated method stub
Map<String, Object> params = new HashMap<String, Object>();
params.put("majorId", pv.getPlanInfoId());
params.put("majorKey", "planinfo_id");
params.put("tab", "t_sale_planinfo");
params.put("userId", pv.getUserId());
int insOrupResult = clientmapper.selCenter(params);
int result = 0;
if (insOrupResult > 0) {
result = clientmapper.upPlanInfo(pv);
} else {
result = clientmapper.addPlanInfo(pv);
}
return result;
}
// 获取ChanceView备份数据
private List<ChanceView> getBackupsListChance(Date synTime, long userId) {
// TODO Auto-generated method stub
Map<String, Object> params = new HashMap<String, Object>();
params.put("lastSynTime", synTime);
params.put("userId", userId);
List<ChanceView> backupsListChance = clientmapper.getBackupsListChance(params);
return backupsListChance;
}
// 机会收款查询接口
@Override
public List<SelChanceMoneyView> selChanceMoney(PageView pageView, Long chanceId) {
// TODO Auto-generated method stub
Map<String, Object> params = new HashMap<String, Object>();
params.put("paging", pageView);
params.put("chanceId", chanceId);
List<SelChanceMoneyView> selChanceMoneyList = clientmapper.selChanceMoney(params);
return selChanceMoneyList;
}
// 统一查询字典表的入口
@Override
public List<DictionaryView> selDictionary(int majorId, String string) {
// TODO Auto-generated method stub
Map<String, Object> params = new HashMap<String, Object>();
params.put("did", majorId);
params.put("dtable", string);
List<DictionaryView> returnList = clientmapper.selDictionary(params);
return returnList;
}
// 统一查询中心
@Override
public int selCenter(Long majorId, String majorKey, String tab) {
Map<String, Object> params = new HashMap<String, Object>();
params.put("majorId", majorId);
params.put("majorKey", majorKey);
params.put("tab", tab);
int result = clientmapper.selCenter(params);
return result;
}
// 这里是一个查询客户的接口，根据客户名（或者不跟）
@Override
public List<SelClientView> selClient(PageView pageView, String clientName, Long userId) {
// TODO Auto-generated method stub
Map<String, Object> params = new HashMap<String, Object>();
params.put("clientName", clientName);
params.put("paging", pageView);
params.put("userId", userId);
List<SelClientView> selClientList = clientmapper.selClient(params);
return selClientList;
}
// 查询联系人
@Override
public List<SelContactsView> selContacts(
PageView pageView, String szm, Integer collect, Long userId) {
// TODO Auto-generated method stub
Map<String, Object> params = new HashMap<String, Object>();
params.put("paging", pageView);
params.put("szm", szm);
params.put("collect", collect);
params.put("userId", userId);
List<SelContactsView> selContactsList = clientmapper.selContacts(params);
return selContactsList;
}
// 修改联系人
@Override
public int modContacts(
String address,
int collect,
String company,
String contactsName,
String email,
String mark,
String mobile,
String mobile2,
String position,
String tel,
String time,
String birthday,
Long contactsId,
String szm,
String pinyin,
Long clientId,
Long userId) {
// TODO Auto-generated method stub
Map<String, Object> params = new HashMap<String, Object>();
params.put("address", address);
params.put("collect", collect);
params.put("company", company);
params.put("contactsName", contactsName);
params.put("email", email);
params.put("mark", mark);
params.put("mobile", mobile);
params.put("mobile2", mobile2);
params.put("position", position);
params.put("tel", tel);
params.put("time", time);
params.put("birthday", birthday);
params.put("contactsId", contactsId);
params.put("szm", szm);
params.put("pinyin", pinyin);
params.put("clientId", clientId);
params.put("userId", userId);
int result = clientmapper.modContacts(params);
return result;
}