CustomerServiceImpl.java 65 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394959697989910010110210310410510610710810911011111211311411511611711811912012112212312412512612712812913013113213313413513613713813914014114214314414514614714814915015115215315415515615715815916016116216316416516616716816917017117217317417517617717817918018118218318418518618718818919019119219319419519619719819920020120220320420520620720820921021121221321421521621721821922022122222322422522622722822923023123223323423523623723823924024124224324424524624724824925025125225325425525625725825926026126226326426526626726826927027127227327427527627727827928028128228328428528628728828929029129229329429529629729829930030130230330430530630730830931031131231331431531631731831932032132232332432532632732832933033133233333433533633733833934034134234334434534634734834935035135235335435535635735835936036136236336436536636736836937037137237337437537637737837938038138238338438538638738838939039139239339439539639739839940040140240340440540640740840941041141241341441541641741841942042142242342442542642742842943043143243343443543643743843944044144244344444544644744844945045145245345445545645745845946046146246346446546646746846947047147247347447547647747847948048148248348448548648748848949049149249349449549649749849950050150250350450550650750850951051151251351451551651751851952052152252352452552652752852953053153253353453553653753853954054154254354454554654754854955055155255355455555655755855956056156256356456556656756856957057157257357457557657757857958058158258358458558658758858959059159259359459559659759859960060160260360460560660760860961061161261361461561661761861962062162262362462562662762862963063163263363463563663763863964064164264364464564664764864965065165265365465565665765865966066166266366466566666766866967067167267367467567667767867968068168268368468568668768868969069169269369469569669769869970070170270370470570670770870971071171271371471571671771871972072172272372472572672772872973073173273373473573673773873974074174274374474574674774874975075175275375475575675775875976076176276376476576676776876977077177277377477577677777877978078178278378478578678778878979079179279379479579679779879980080180280380480580680780880981081181281381481581681781881982082182282382482582682782882983083183283383483583683783883984084184284384484584684784884985085185285385485585685785885986086186286386486586686786886987087187287387487587687787887988088188288388488588688788888989089189289389489589689789889990090190290390490590690790890991091191291391491591691791891992092192292392492592692792892993093193293393493593693793893994094194294394494594694794894995095195295395495595695795895996096196296396496596696796896997097197297397497597697797897998098198298398498598698798898999099199299399499599699799899910001001100210031004100510061007100810091010101110121013101410151016101710181019102010211022102310241025102610271028102910301031103210331034103510361037103810391040104110421043104410451046104710481049105010511052105310541055105610571058105910601061106210631064106510661067106810691070107110721073107410751076107710781079108010811082108310841085108610871088108910901091109210931094109510961097109810991100110111021103110411051106110711081109111011111112111311141115111611171118111911201121112211231124112511261127112811291130113111321133113411351136113711381139114011411142114311441145114611471148114911501151115211531154115511561157115811591160116111621163116411651166116711681169117011711172117311741175117611771178117911801181118211831184118511861187118811891190119111921193119411951196119711981199120012011202120312041205120612071208120912101211121212131214121512161217121812191220122112221223122412251226122712281229123012311232123312341235123612371238123912401241124212431244124512461247124812491250125112521253125412551256125712581259126012611262126312641265126612671268126912701271127212731274127512761277127812791280128112821283128412851286128712881289129012911292129312941295129612971298129913001301130213031304130513061307130813091310131113121313131413151316131713181319132013211322132313241325132613271328132913301331133213331334133513361337133813391340134113421343134413451346134713481349135013511352135313541355135613571358135913601361136213631364136513661367136813691370137113721373137413751376137713781379138013811382138313841385138613871388138913901391139213931394139513961397139813991400140114021403140414051406140714081409141014111412141314141415141614171418141914201421142214231424142514261427142814291430143114321433143414351436143714381439144014411442144314441445144614471448144914501451145214531454145514561457145814591460146114621463146414651466146714681469147014711472147314741475147614771478147914801481148214831484148514861487148814891490149114921493149414951496149714981499150015011502150315041505150615071508150915101511151215131514151515161517151815191520152115221523152415251526152715281529153015311532153315341535153615371538153915401541154215431544154515461547154815491550155115521553155415551556155715581559156015611562156315641565156615671568156915701571157215731574157515761577157815791580158115821583
  1. package com.goafanti.customer.service.impl;
  2. import java.lang.reflect.InvocationTargetException;
  3. import java.text.ParseException;
  4. import java.text.SimpleDateFormat;
  5. import java.util.Date;
  6. import java.util.HashMap;
  7. import java.util.HashSet;
  8. import java.util.List;
  9. import java.util.Map;
  10. import java.util.Set;
  11. import java.util.UUID;
  12. import javax.annotation.Resource;
  13. import org.apache.commons.beanutils.BeanUtils;
  14. import org.apache.commons.beanutils.PropertyUtils;
  15. import org.apache.ibatis.builder.BuilderException;
  16. import org.apache.poi.xssf.usermodel.XSSFWorkbook;
  17. import org.springframework.beans.factory.annotation.Autowired;
  18. import org.springframework.beans.factory.annotation.Value;
  19. import org.springframework.stereotype.Service;
  20. import org.springframework.transaction.annotation.Transactional;
  21. import com.goafanti.common.bo.Error;
  22. import com.goafanti.common.constant.AFTConstants;
  23. import com.goafanti.common.constant.ErrorConstants;
  24. import com.goafanti.common.dao.AdminMapper;
  25. import com.goafanti.common.dao.BusinessGlossoryMapper;
  26. import com.goafanti.common.dao.BusinessProjectMapper;
  27. import com.goafanti.common.dao.OrganizationAnnualReportMapper;
  28. import com.goafanti.common.dao.OrganizationApplicationInfoMapper;
  29. import com.goafanti.common.dao.OrganizationContactBookMapper;
  30. import com.goafanti.common.dao.OrganizationIdentityMapper;
  31. import com.goafanti.common.dao.OrganizationYearProjectMapper;
  32. import com.goafanti.common.dao.UserBusinessMapper;
  33. import com.goafanti.common.dao.UserFollowBusinessMapper;
  34. import com.goafanti.common.dao.UserFollowMapper;
  35. import com.goafanti.common.dao.UserIdentityMapper;
  36. import com.goafanti.common.dao.UserLockReleaseMapper;
  37. import com.goafanti.common.dao.UserMapper;
  38. import com.goafanti.common.dao.UserTransferLogMapper;
  39. import com.goafanti.common.enums.CustomerStatusFiled;
  40. import com.goafanti.common.enums.DeleteStatus;
  41. import com.goafanti.common.enums.IdentityProcess;
  42. import com.goafanti.common.enums.UserLevel;
  43. import com.goafanti.common.enums.UserLockReleaseStatus;
  44. import com.goafanti.common.enums.UserType;
  45. import com.goafanti.common.error.BusinessException;
  46. import com.goafanti.common.model.Admin;
  47. import com.goafanti.common.model.OrganizationApplicationInfo;
  48. import com.goafanti.common.model.OrganizationContactBook;
  49. import com.goafanti.common.model.OrganizationIdentity;
  50. import com.goafanti.common.model.User;
  51. import com.goafanti.common.model.UserBusiness;
  52. import com.goafanti.common.model.UserFollow;
  53. import com.goafanti.common.model.UserFollowBusiness;
  54. import com.goafanti.common.model.UserIdentity;
  55. import com.goafanti.common.model.UserLockRelease;
  56. import com.goafanti.common.model.UserTransferLog;
  57. import com.goafanti.common.utils.BeanUtilsExt;
  58. import com.goafanti.common.utils.DateUtils;
  59. import com.goafanti.common.utils.ExportExcelUtil;
  60. import com.goafanti.common.utils.PasswordUtil;
  61. import com.goafanti.common.utils.StringUtils;
  62. import com.goafanti.core.mybatis.BaseMybatisDao;
  63. import com.goafanti.core.mybatis.page.Pagination;
  64. import com.goafanti.core.shiro.token.TokenManager;
  65. import com.goafanti.customer.bo.BusinessListBo;
  66. import com.goafanti.customer.bo.BussinessFollowBo;
  67. import com.goafanti.customer.bo.CustomerExcelBo;
  68. import com.goafanti.customer.bo.CustomerListIn;
  69. import com.goafanti.customer.bo.CustomerListOut;
  70. import com.goafanti.customer.bo.CustomerOrganizationDetailBo;
  71. import com.goafanti.customer.bo.CustomerPersonalDetailBo;
  72. import com.goafanti.customer.bo.CustomerSimpleBo;
  73. import com.goafanti.customer.bo.FollowBusinessBo;
  74. import com.goafanti.customer.bo.FollowListBo;
  75. import com.goafanti.customer.bo.LockingReleaseBo;
  76. import com.goafanti.customer.bo.StatisticBo;
  77. import com.goafanti.customer.bo.transferListBo;
  78. import com.goafanti.customer.service.CustomerService;
  79. @Service
  80. public class CustomerServiceImpl extends BaseMybatisDao<UserMapper> implements CustomerService {
  81. @Autowired
  82. private UserMapper userMapper;
  83. @Autowired
  84. private UserIdentityMapper userIdentityMapper;
  85. @Autowired
  86. private OrganizationIdentityMapper organizationIdentityMapper;
  87. @Autowired
  88. private OrganizationContactBookMapper organizationContactBookMapper;
  89. @Resource(name = "passwordUtil")
  90. private PasswordUtil passwordUtil;
  91. @Resource
  92. private UserFollowMapper userFollowMapper;
  93. @Resource
  94. private UserBusinessMapper userBusinessMapper;
  95. @Resource
  96. private UserFollowBusinessMapper userFollowBusinessMapper;
  97. @Resource
  98. private BusinessGlossoryMapper businessGlossoryMapper;
  99. @Resource
  100. private BusinessProjectMapper businessProjectMapper;
  101. @Resource
  102. private UserLockReleaseMapper userLockReleaseMapper;
  103. @Resource
  104. private AdminMapper adminMapper;
  105. @Resource
  106. private OrganizationApplicationInfoMapper organizationApplicationInfoMapper;
  107. @Resource
  108. private OrganizationAnnualReportMapper organizationAnnualReportMapper;
  109. @Resource
  110. private OrganizationYearProjectMapper organizationYearProjectMapper;
  111. @Resource
  112. private UserTransferLogMapper userTransferLogMapper;
  113. @Value(value = "${upload.path}")
  114. private String uploadPath = null;
  115. @SuppressWarnings("unchecked")
  116. @Override
  117. public Pagination<CustomerListOut> listPrivatePersonalCustomer(CustomerListIn cli, Integer pageNo,Integer pageSize) {
  118. cli.setType(AFTConstants.USER_TYPE_PERSONAL);
  119. cli.setAid(TokenManager.getAdminId());
  120. Map<String,Object> params = disposeParams(cli);
  121. Pagination<CustomerListOut> list = (Pagination<CustomerListOut>) findPage("selectPrivatePersonalCustomerList","selectPrivatePersonalCustomerCount",params,pageNo,pageSize);
  122. List<CustomerListOut> tmpList = (List<CustomerListOut>)list.getList();
  123. setCustomerList(tmpList,0);
  124. list.setList(tmpList);
  125. return list;
  126. }
  127. @SuppressWarnings("unchecked")
  128. @Override
  129. public Pagination<CustomerListOut> listPublicPersonalCustomer(CustomerListIn cli, Integer pageNo,Integer pageSize) {
  130. cli.setType(AFTConstants.USER_TYPE_PERSONAL);
  131. Map<String,Object> params = disposeParams(cli);
  132. Pagination<CustomerListOut> list = (Pagination<CustomerListOut>) findPage("selectPublicPersonalCustomerList","selectPublicPersonalCustomerCount",params,pageNo,pageSize);
  133. return list;
  134. }
  135. @SuppressWarnings("unchecked")
  136. @Override
  137. public Pagination<CustomerListOut> listAllPersonalCustomer(CustomerListIn cli, Integer pageNo, Integer pageSize) {
  138. cli.setType(AFTConstants.USER_TYPE_PERSONAL);
  139. Map<String,Object> params = disposeParams(cli);
  140. Pagination<CustomerListOut> list = (Pagination<CustomerListOut>) findPage("selectPersonalCustomerList","selectPersonalCustomerCount",params,pageNo,pageSize);
  141. return list;
  142. }
  143. @SuppressWarnings("unchecked")
  144. @Override
  145. public Pagination<CustomerListOut> listAllManagePersonalCustomer(CustomerListIn cli, Integer pageNo, Integer pageSize) {
  146. cli.setType(AFTConstants.USER_TYPE_PERSONAL);
  147. cli.setShareType(String.valueOf(AFTConstants.USER_SHARE_PRIVATE));
  148. Map<String,Object> params = disposeParams(cli);
  149. Pagination<CustomerListOut> list = (Pagination<CustomerListOut>) findPage("selectManagePersonalCustomerList","selectManagePersonalCustomerCount",params,pageNo,pageSize);
  150. return list;
  151. }
  152. @SuppressWarnings("unchecked")
  153. @Override
  154. public Pagination<CustomerListOut> listPrivateOrganizationCustomer(CustomerListIn cli,Integer sort,Integer sortType, Integer pageNo,Integer pageSize) {
  155. cli.setType(AFTConstants.USER_TYPE_ORGANIZATION);
  156. cli.setAid(TokenManager.getAdminId());
  157. // cli.setAid("1");
  158. cli.setShareType(String.valueOf(AFTConstants.USER_SHARE_PRIVATE));
  159. Map<String,Object> params = disposeParams(cli);
  160. params.put("sort", sort);
  161. params.put("sortType",sortType);
  162. Pagination<CustomerListOut> list = (Pagination<CustomerListOut>) findPage("selectPrivateOrganizationCustomerList","selectPrivateOrganizationCustomerCount",params,pageNo,pageSize);
  163. List<CustomerListOut> tmpList = (List<CustomerListOut>)list.getList();
  164. setCustomerList(tmpList,0);
  165. list.setList(tmpList);
  166. return list;
  167. }
  168. @SuppressWarnings("unchecked")
  169. @Override
  170. public Pagination<CustomerListOut> listPublicOrganizationCustomer(CustomerListIn cli, Integer pageNo,Integer pageSize) {
  171. cli.setType(AFTConstants.USER_TYPE_ORGANIZATION);
  172. cli.setShareType(String.valueOf(AFTConstants.USER_SHARE_PUBLIC));
  173. Map<String,Object> params = disposeParams(cli);
  174. Pagination<CustomerListOut> list = (Pagination<CustomerListOut>) findPage("selectPublicOrganizationCustomerList","selectPublicOrganizationCustomerCount",params,pageNo,pageSize);
  175. return list;
  176. }
  177. @SuppressWarnings("unchecked")
  178. @Override
  179. public Pagination<CustomerListOut> listAllOrganizationCustomer(CustomerListIn cli, Integer pageNo,Integer pageSize) {
  180. cli.setType(AFTConstants.USER_TYPE_ORGANIZATION);
  181. Map<String,Object> params = disposeParams(cli);
  182. Pagination<CustomerListOut> p=(Pagination<CustomerListOut>) findPage("selectOrganizationCustomerList","selectOrganizationCustomerCount",params,pageNo,pageSize);
  183. List<CustomerListOut> l=(List<CustomerListOut>) p.getList();
  184. for (CustomerListOut c : l) {
  185. if (null!=c) {
  186. if(null!=c.getAid())c.setAdminName(adminMapper.selectNameByid(c.getAid()));
  187. if (null!=c.getShareType()&&c.getShareType().equals("1"))c.setAdminName("暂无");
  188. if(null!=c.getMid())c.setInformationMaintainer(adminMapper.selectNameByid(c.getMid()));
  189. }
  190. }
  191. return p;
  192. }
  193. @Override
  194. public Pagination<CustomerListOut> listAllManageOrganizationCustomer(CustomerListIn cli, Integer pageNo,Integer pageSize) {
  195. cli.setType(AFTConstants.USER_TYPE_ORGANIZATION);
  196. cli.setShareType(String.valueOf(AFTConstants.USER_SHARE_PRIVATE));
  197. cli.setAid(TokenManager.getAdminId());
  198. Map<String,Object> params = disposeParams(cli);
  199. @SuppressWarnings("unchecked")
  200. Pagination<CustomerListOut> list = (Pagination<CustomerListOut>) findPage("selectManageOrganizationCustomerList","selectManageOrganizationCustomerCount",params,pageNo,pageSize);
  201. return list;
  202. }
  203. private Map<String,Object> disposeParams(CustomerListIn cli){
  204. Map<String,Object> params = new HashMap<String, Object>();
  205. if(StringUtils.isNotBlank(cli.getType())) params.put("type", Integer.parseInt(cli.getType()));
  206. if(StringUtils.isNotBlank(cli.getShareType())) params.put("shareType", Integer.parseInt(cli.getShareType()));
  207. if(StringUtils.isNotBlank(cli.getName())) params.put("name", cli.getName());
  208. if(StringUtils.isNotBlank(cli.getProvince())) params.put("province", Integer.parseInt(cli.getProvince()));
  209. if(StringUtils.isNotBlank(cli.getCity())) params.put("city", Integer.parseInt(cli.getCity()));
  210. if(StringUtils.isNotBlank(cli.getArea())) params.put("area", Integer.parseInt(cli.getArea()));
  211. if(StringUtils.isNotBlank(cli.getStartDate())) params.put("startDate", cli.getStartDate());
  212. if(StringUtils.isNotBlank(cli.getEndDate())) params.put("endDate", cli.getEndDate());
  213. if(StringUtils.isNotBlank(cli.getIndustry())) params.put("industry", Integer.parseInt(cli.getIndustry()));
  214. if(StringUtils.isNotBlank(cli.getAid())) params.put("aid", cli.getAid());
  215. if(StringUtils.isNotBlank(cli.getDepartmentId())) params.put("departmentId", cli.getDepartmentId());
  216. if(StringUtils.isNotBlank(cli.getStatus())) params.put("status", Integer.parseInt(cli.getStatus()));
  217. if(StringUtils.isNotBlank(cli.getSocietyTag())) params.put("societyTag", cli.getSocietyTag());
  218. if(StringUtils.isNotBlank(cli.getFollow())) params.put("follow", cli.getFollow());
  219. if(StringUtils.isNotBlank(cli.getStartDate())) params.put("startDate", cli.getStartDate()+" 00:00:00");
  220. if(StringUtils.isNotBlank(cli.getEndDate())) params.put("endDate", cli.getEndDate()+" 23:59:59");
  221. if(null!=cli.getDataGrade()) params.put("dataGrade", cli.getDataGrade());
  222. if(null!=cli.getLevel())params.put("level", cli.getLevel());
  223. if(null!=cli.getSort())params.put("sort", cli.getSort());
  224. return params;
  225. }
  226. @Override
  227. public List<CustomerSimpleBo> findCustomerByName(String name) {
  228. return userMapper.findCustomerByName(name);
  229. }
  230. @Override
  231. public int judgeCustomerByName(String name) {
  232. return userMapper.judgeCustomerByName(name);
  233. }
  234. @Override
  235. @Transactional
  236. public int addCustomer(String name, String contacts, String contactMobile, Integer type, Integer source,String societyTag,
  237. Integer province ,Integer city, Integer area) throws BusinessException{
  238. User user = new User();
  239. Date now = new Date();
  240. String uid = UUID.randomUUID().toString();
  241. String identifyId = UUID.randomUUID().toString();
  242. user.setId(uid);
  243. user.setIdentifyName(name);
  244. user.setSource(1);//客户来源为录入
  245. user.setNickname(name);
  246. user.setStatus(AFTConstants.USER_STATUS_NORMAL);
  247. user.setShareType(AFTConstants.NO);
  248. user.setAid(TokenManager.getAdminId());
  249. // user.setAid("1");
  250. user.setType(type);
  251. user.setLvl(UserLevel.CERTIFIED.getCode());
  252. user.setSocietyTag(societyTag);
  253. user.setCreateTime(now);
  254. user.setTransferTime(now);
  255. user.setUpdateTime(now);
  256. user.setMobile(contactMobile);
  257. user.setPassword(AFTConstants.INITIALPASSWORD);
  258. user.setInformationMaintainer(TokenManager.getAdminId());
  259. float f=0;
  260. user.setIntegrity(f);
  261. // user.setInformationMaintainer("1");
  262. passwordUtil.encryptPassword(user);
  263. if(type == UserType.PERSONAL.getCode()){
  264. if(userMapper.checkUser("", "", contactMobile, type,null,null).size()>0) throw new BusinessException(new Error(ErrorConstants.CUSTOMER_ALREADY_EXIST, name,""));
  265. UserIdentity ui = new UserIdentity();
  266. ui.setId(identifyId);
  267. ui.setUid(uid);
  268. ui.setContacts(contacts);
  269. ui.setContactMobile(contactMobile);
  270. ui.setUsername(name);
  271. ui.setProvince(province);
  272. ui.setCity(city);
  273. ui.setArea(area);
  274. ui.setExpert(AFTConstants.NO);
  275. ui.setCelebrity(AFTConstants.NO);
  276. ui.setInternational(AFTConstants.NO);
  277. ui.setAuditStatus(IdentityProcess.SUCCESS.getCode());//认证个人
  278. userIdentityMapper.insert(ui);
  279. }else if(type == UserType.ORGANIZATION.getCode()){
  280. if(userMapper.checkUser("",name,"",type,null,null).size()>0) throw new BusinessException(new Error(ErrorConstants.CUSTOMER_ALREADY_EXIST, name,""));
  281. // 创建企业认证信息
  282. OrganizationIdentity oi = new OrganizationIdentity();
  283. oi.setUnitName(name);
  284. oi.setId(identifyId);
  285. oi.setUid(uid);
  286. oi.setContacts(contacts);
  287. oi.setContactMobile(contactMobile);
  288. oi.setLocationProvince(province);
  289. oi.setLocationCity(city);
  290. oi.setLocationArea(area);
  291. oi.setHighTechZone(AFTConstants.NO);
  292. oi.setInternational(AFTConstants.NO);
  293. oi.setListed(AFTConstants.NO);
  294. oi.setAuditStatus(IdentityProcess.SUCCESS.getCode()); //实名企业
  295. organizationIdentityMapper.insert(oi);
  296. }
  297. userMapper.insert(user);
  298. //新增企业联系人
  299. OrganizationContactBook cob = new OrganizationContactBook();
  300. cob.setAid(TokenManager.getAdminId());
  301. // cob.setAid("1");
  302. cob.setId(UUID.randomUUID().toString());
  303. cob.setUid(uid);
  304. cob.setName(contacts);
  305. cob.setMobile(contactMobile);
  306. cob.setMajor(AFTConstants.YES);
  307. organizationContactBookMapper.insert(cob);
  308. //新增锁定数据
  309. addUserLock(uid, TokenManager.getAdminId(),0,null, now);
  310. return 1;
  311. }
  312. @Override
  313. public CustomerPersonalDetailBo findPersonalCustomerDetail(String uid) {
  314. return userMapper.findPersonalCustomerDetail(uid);
  315. }
  316. @Override
  317. public CustomerOrganizationDetailBo findOrganizationCustomerDetail(String uid) {
  318. return userMapper.findOrganizationCustomerDetail(uid);
  319. }
  320. @Override
  321. @Transactional
  322. public int updateOrganizationCustomer(CustomerOrganizationDetailBo bo) {
  323. OrganizationIdentity oi = new OrganizationIdentity();
  324. User user = new User();
  325. Date date =new Date();
  326. OrganizationApplicationInfo oa=new OrganizationApplicationInfo();
  327. try {
  328. BeanUtilsExt.copyProperties(oi, bo);
  329. user.setId(bo.getUid());
  330. user.setSocietyTag(bo.getSocietyTag());
  331. user.setCompanyLogoUrl(bo.getCompanyLogoUrl());
  332. user.setIntroduction(bo.getIntroduction());
  333. user.setUpdateTime(date);
  334. user.setInformationMaintainer(bo.getInformationMaintainer());
  335. user.setCoreTechnology(bo.getCoreTechnology());
  336. user.setAccomplishSituation(bo.getAccomplishSituation());
  337. user.setIntellectualProperty(bo.getIntellectualProperty());
  338. user.setCreditRating(bo.getCreditRating());
  339. user.setIntegrity(countIntegrity(bo));
  340. if (StringUtils.isNotBlank(bo.getPojectApplicationUrl())) {
  341. List<OrganizationApplicationInfo> l=organizationApplicationInfoMapper.selectByUid(bo.getUid());
  342. if(l.size()>0){
  343. oa=l.get(0);
  344. oa.setPojectApplicationUrl(bo.getPojectApplicationUrl());
  345. organizationApplicationInfoMapper.updateByPrimaryKey(oa);
  346. }else {
  347. oa.setId(UUID.randomUUID().toString());
  348. oa.setCreateTime(date);
  349. oa.setUid(bo.getUid());
  350. oa.setPojectApplicationUrl(bo.getPojectApplicationUrl());
  351. organizationApplicationInfoMapper.insert(oa);
  352. }
  353. }
  354. } catch (IllegalAccessException |InvocationTargetException e) {
  355. e.printStackTrace();
  356. }
  357. organizationIdentityMapper.updateByPrimaryKey(oi);
  358. userMapper.updateByPrimaryKeySelective(user);
  359. return 1;
  360. }
  361. public Float countIntegrity(CustomerOrganizationDetailBo bo) {
  362. //完整资料总数
  363. int max=10;
  364. int number=0;
  365. if(null!=bo.getIndustry())number+=1;
  366. if(bo.getLocationProvince()!=null)number+=1;
  367. if(StringUtils.isNotBlank(bo.getBusinessScope()))number+=1;
  368. if(bo.getRegisteredCapital()!=null)number+=1;
  369. if(StringUtils.isNotBlank(bo.getCooperationSituation()))number+=1;
  370. if(StringUtils.isNotBlank(bo.getQualification()))number+=1;
  371. // if(bo.getAssets()!=null)number+=1;
  372. // if(bo.getLastYearResearchAmount()!=null)number+=1;
  373. // if(bo.getYearSalesAmount()!=null)number+=1;
  374. // if(StringUtils.isNotBlank(bo.getAccomplishSituation()))number+=1;
  375. if (organizationAnnualReportMapper.selectOrgAnnualCount(bo.getUid())>0)number+=1;
  376. if (organizationAnnualReportMapper.selectOrgYearProjectCount(bo.getUid())>0)number+=1;
  377. if(StringUtils.isNotBlank(bo.getCoreTechnology()))number+=1;
  378. if(bo.getCreditRating()!=null)number+=1;
  379. float f= (float)number/max;
  380. return f;
  381. }
  382. @Override
  383. public int updatePersonalCustomer(CustomerPersonalDetailBo bo) {
  384. UserIdentity ui = new UserIdentity();
  385. User user = new User();
  386. try {
  387. try {
  388. PropertyUtils.copyProperties(ui,bo);
  389. } catch (NoSuchMethodException e) {
  390. e.printStackTrace();
  391. }
  392. //BeanUtilsExt.copyProperties(ui, bo);
  393. user.setId(bo.getUid());
  394. user.setSocietyTag(bo.getSocietyTag());
  395. user.setHeadPortraitUrl(bo.getHeadPortraitUrl());
  396. user.setIntroduction(bo.getIntroduction());
  397. user.setUpdateTime(new Date());
  398. if(null==bo.getExpertAudit()&&bo.getExpert()==1)ui.setExpertAudit(2);
  399. } catch (InvocationTargetException | IllegalAccessException e) {
  400. e.printStackTrace();
  401. }
  402. userIdentityMapper.updateByPrimaryKeySelective(ui);
  403. userMapper.updateByPrimaryKeySelective(user);
  404. return 1;
  405. }
  406. @SuppressWarnings("unchecked")
  407. @Override
  408. public Pagination<FollowListBo> listFollowHistory(Integer pageNo, Integer pageSize,String uid,String businessProjectId) {
  409. Map<String, Object> params = new HashMap<String, Object>();
  410. if(StringUtils.isNotBlank(uid))params.put("uid", uid);
  411. if(StringUtils.isNotBlank(businessProjectId)) params.put("businessProjectId", businessProjectId);
  412. Pagination<FollowListBo> page = (Pagination<FollowListBo>)findPage("selectFollowHistoryList","selectFollowHistoryCount",params, pageNo, pageSize);
  413. List<FollowListBo> list = (List<FollowListBo>)page.getList();
  414. for(FollowListBo bo : list){
  415. if(bo.getAid().equals(TokenManager.getAdminId())){
  416. bo.setReadOnly(AFTConstants.NO);
  417. }else{
  418. bo.setReadOnly(AFTConstants.YES);
  419. }
  420. }
  421. page.setList(list);
  422. return page;
  423. }
  424. @Override
  425. public User findUserAccountDetail(String uid) {
  426. return userMapper.findUserAccountDetail(uid);
  427. }
  428. @Override
  429. public int updateUserAccount(User user) {
  430. return userMapper.updateByPrimaryKeySelective(user);
  431. }
  432. @Override
  433. public List<OrganizationContactBook> findCustomerContacts(String uid) {
  434. return userMapper.findCustomerContacts(uid,TokenManager.getAdminId());
  435. }
  436. @Override
  437. @Transactional
  438. public int addFollow(FollowBusinessBo fbb) throws BusinessException{
  439. //if(fbb.getUserBusinessList().size()<1) throw new BusinessException(new Error(ErrorConstants.AT_LEAST_A_BUSINESS,"",""));
  440. //更新跟进记录表
  441. SimpleDateFormat format = new SimpleDateFormat(AFTConstants.YYYYMMDDHHMMSS);
  442. UserFollow userFollow = new UserFollow();
  443. String followId = UUID.randomUUID().toString();
  444. userFollow.setId(followId);
  445. userFollow.setAid(TokenManager.getAdminId());
  446. userFollow.setContactType(Integer.parseInt(fbb.getContactType()));
  447. userFollow.setEffective(DeleteStatus.UNDELETE.getCode());
  448. try {
  449. userFollow.setCreateTime(format.parse(fbb.getFollowTime()));
  450. } catch (ParseException e) {
  451. e.printStackTrace();
  452. }
  453. userFollow.setOcbId(fbb.getOcbId());
  454. userFollow.setResult(fbb.getResult());
  455. userFollow.setUid(fbb.getUid());
  456. int followCount = userBusinessMapper.selectFollowCountByUAid(fbb.getUid(), TokenManager.getAdminId()) + 1;
  457. userFollow.setFollowCount(followCount);
  458. userFollowMapper.insert(userFollow);
  459. //检查客户锁定情况
  460. if(fbb.getUserBusinessList().size()>0){
  461. boolean isUserOwner = false;
  462. List<LockingReleaseBo> userLockedList = userMapper.selectLockedProject(fbb.getUid(), TokenManager.getAdminId(),null, 0, UserLockReleaseStatus.LOCKED.getCode());
  463. if(userLockedList.size() > 0){
  464. isUserOwner = true;
  465. }
  466. boolean isBusinessOwner = false;
  467. List<LockingReleaseBo> businessLockedList = null;
  468. String businessName= "";
  469. String ufbId = "";
  470. UserBusiness userBusiness = null;
  471. UserFollowBusiness userFollowBusiness = null;
  472. for(BusinessListBo ub: fbb.getUserBusinessList()){
  473. userBusiness = new UserBusiness();
  474. userFollowBusiness = new UserFollowBusiness();
  475. ufbId = UUID.randomUUID().toString();
  476. businessName = businessProjectMapper.selectByPrimaryKey(ub.getBusinessProjectId()).getBname();
  477. UserBusiness us=userBusinessMapper.selectByPrimaryKey(ub.getBusinessId());
  478. //sas
  479. if(StringUtils.isNotBlank(ub.getBusinessId())){
  480. //更新业务表
  481. userBusiness.setId(ub.getBusinessId());
  482. if (us.getFollowSituation()==5) {//如果已签合同,则不允许变更
  483. if (ub.getCustomerStatus()!=us.getCustomerStatus()&& ub.getFollowSituation()!=5) {
  484. throw new BusinessException(new Error(ErrorConstants.BUSINESS_ALREADY_LOCKED,""));
  485. }
  486. }
  487. //检查业务锁定情况
  488. businessLockedList = userMapper.selectLockedProject(fbb.getUid(), null, ub.getBusinessProjectId(), 1, UserLockReleaseStatus.LOCKED.getCode());
  489. if(businessLockedList.size() > 0){
  490. for(LockingReleaseBo bo : businessLockedList){
  491. if(bo.getAid().equals(TokenManager.getAdminId())) isBusinessOwner = true;
  492. }
  493. if(!isBusinessOwner) throw new BusinessException(new Error(ErrorConstants.BUSINESS_ALREADY_LOCKED,businessName,""));
  494. }else{
  495. if(!isUserOwner) throw new BusinessException(new Error(ErrorConstants.CUSTOMER_ALREADY_LOCKED,businessName,""));
  496. }
  497. //releaseProject(businessLockedList);
  498. if (us.getFollowSituation()!=5&&ub.getFollowSituation()==5) {//如果改成已签合同,则锁定业务
  499. if (StringUtils.isNotBlank(fbb.getUid())) ub.setUid(fbb.getUid());
  500. lockProject(ub);//锁定客户业务
  501. }
  502. userBusiness.setBusinessProjectId(ub.getBusinessProjectId());
  503. userBusiness.setCustomerStatus(ub.getCustomerStatus());
  504. userBusiness.setFollowSituation(ub.getFollowSituation());
  505. userBusiness.setRemarks(ub.getRemarks());
  506. userBusiness.setUid(fbb.getUid());
  507. try {
  508. userBusiness.setUpdateTime(format.parse(fbb.getFollowTime()));
  509. } catch (ParseException e) {
  510. e.printStackTrace();
  511. }
  512. userBusiness.setAid(TokenManager.getAdminId());
  513. userBusinessMapper.updateByPrimaryKeySelective(userBusiness);
  514. //更新业务中间表
  515. userFollowBusiness.setBusinessId(ub.getBusinessProjectId());
  516. userFollowBusiness.setCustomerStatus(ub.getCustomerStatus());
  517. userFollowBusiness.setFollowSituation(ub.getFollowSituation());
  518. userFollowBusiness.setId(ufbId);
  519. userFollowBusiness.setFollowId(followId);
  520. userFollowBusiness.setRemarks(ub.getRemarks());
  521. userFollowBusiness.setBusinessProjectId(ub.getBusinessProjectId());
  522. userFollowBusinessMapper.insert(userFollowBusiness);
  523. }else{
  524. //检查业务锁定情况
  525. businessLockedList = userMapper.selectLockedProject(fbb.getUid(), null, ub.getBusinessProjectId(), 1, UserLockReleaseStatus.LOCKED.getCode());
  526. if(businessLockedList.size() > 0){
  527. for(LockingReleaseBo bo : businessLockedList){
  528. if(bo.getAid().equals(TokenManager.getAdminId())) isBusinessOwner = true;
  529. }
  530. if(!isBusinessOwner) throw new BusinessException(new Error(ErrorConstants.BUSINESS_ALREADY_LOCKED,businessName,""));
  531. }else{
  532. if(!isUserOwner) throw new BusinessException(new Error(ErrorConstants.CUSTOMER_ALREADY_LOCKED,businessName,""));
  533. }
  534. if(userBusinessMapper.judgeBusiness(fbb.getUid(), ub.getBusinessProjectId(), "")>0){
  535. throw new BusinessException(new Error(ErrorConstants.BUSINESS_ALREADY_EXIST,businessName,""));
  536. }
  537. if (ub.getFollowSituation()==5) {//如果改成已签合同,则锁定业务
  538. if (StringUtils.isNotBlank(fbb.getUid())) ub.setUid(fbb.getUid());
  539. lockProject(ub);//锁定客户业务
  540. }
  541. String ubId = UUID.randomUUID().toString();
  542. //更新业务表
  543. userBusiness.setId(ubId);
  544. userBusiness.setBusinessProjectId(ub.getBusinessProjectId());
  545. try {
  546. userBusiness.setCreateTime(format.parse(fbb.getFollowTime()));
  547. userBusiness.setUpdateTime(format.parse(fbb.getFollowTime()));
  548. } catch (ParseException e) {
  549. e.printStackTrace();
  550. }
  551. userBusiness.setCustomerStatus(ub.getCustomerStatus());
  552. userBusiness.setFollowSituation(ub.getFollowSituation());
  553. userBusiness.setUid(fbb.getUid());
  554. userBusiness.setAid(TokenManager.getAdminId());
  555. userBusiness.setRemarks(ub.getRemarks());
  556. userBusinessMapper.insert(userBusiness);
  557. //更新业务中间表
  558. userFollowBusiness.setBusinessId(ubId);
  559. userFollowBusiness.setCustomerStatus(ub.getCustomerStatus());
  560. userFollowBusiness.setFollowSituation(ub.getFollowSituation());
  561. userFollowBusiness.setId(ufbId);
  562. userFollowBusiness.setFollowId(followId);
  563. userFollowBusiness.setRemarks(ub.getRemarks());
  564. userFollowBusiness.setBusinessProjectId(ub.getBusinessProjectId());
  565. userFollowBusinessMapper.insert(userFollowBusiness);
  566. }
  567. }
  568. }
  569. return 1;
  570. }
  571. private void lockProject(BusinessListBo ub) {
  572. UserLockRelease ulr= new UserLockRelease();
  573. ulr.setId(UUID.randomUUID().toString());
  574. ulr.setType(1);
  575. ulr.setAid(TokenManager.getAdminId());
  576. ulr.setBusinessProjectId(ub.getBusinessProjectId());
  577. SimpleDateFormat sdf = new SimpleDateFormat( " yyyy-MM-dd HH:mm:ss " );
  578. try {
  579. if (null==ub.getCreateTime()) {
  580. ulr.setLockTime(new Date());
  581. }else {
  582. ulr.setLockTime(sdf.parse(ub.getCreateTime()));
  583. }
  584. } catch (ParseException e) {
  585. e.printStackTrace();
  586. }
  587. ulr.setStatus(UserLockReleaseStatus.LOCKED.getCode());
  588. ulr.setUid(ub.getUid());
  589. userLockReleaseMapper.insert(ulr);
  590. }
  591. @SuppressWarnings("unused")
  592. private void releaseProject(List<LockingReleaseBo> businessLockedList) {
  593. if(businessLockedList != null && businessLockedList.size()>0){
  594. UserLockRelease ulr = null;
  595. for(LockingReleaseBo bo : businessLockedList){
  596. ulr = new UserLockRelease();
  597. ulr.setId(bo.getId());
  598. ulr.setStatus(UserLockReleaseStatus.RELEASE.getCode());
  599. userLockReleaseMapper.updateByPrimaryKeySelective(ulr);
  600. }
  601. }
  602. }
  603. @Override
  604. public FollowBusinessBo findFollowById(String followId) {
  605. return userMapper.findFollowById(followId);
  606. }
  607. @Override
  608. public List<BusinessListBo> findBusinessByFollowId(String followId) {
  609. return userMapper.findBusinessByFollowId(followId);
  610. }
  611. @Override
  612. @Transactional
  613. public int updateFollow(FollowBusinessBo fbb) throws BusinessException{
  614. UserFollow userFollow = new UserFollow();
  615. SimpleDateFormat format = new SimpleDateFormat(AFTConstants.YYYYMMDDHHMMSS);
  616. userFollow.setId(fbb.getFollowId());
  617. if(StringUtils.isNotBlank(fbb.getOcbId())) userFollow.setOcbId(fbb.getOcbId());
  618. userFollow.setResult(fbb.getResult());
  619. userFollow.setContactType(Integer.parseInt(fbb.getContactType()));
  620. userFollowMapper.updateByPrimaryKeySelective(userFollow); //修改拜访记录表
  621. if(fbb.getUserBusinessList().size()>0){
  622. //检查客户锁定情况
  623. boolean isUserOwner = false;
  624. List<LockingReleaseBo> userLockedList = userMapper.selectLockedProject(fbb.getUid(), TokenManager.getAdminId(),null, 0, UserLockReleaseStatus.LOCKED.getCode());
  625. if(userLockedList.size() > 0){
  626. isUserOwner = true;
  627. }
  628. boolean isBusinessOwner = false;
  629. List<LockingReleaseBo> businessLockedList = null;
  630. String businessName= "";
  631. UserFollowBusiness userFollowBusiness = null;
  632. for(BusinessListBo ub: fbb.getUserBusinessList()){
  633. userFollowBusiness = new UserFollowBusiness();
  634. businessName = businessProjectMapper.selectByPrimaryKey(ub.getBusinessProjectId()).getBname();
  635. if(StringUtils.isNotBlank(ub.getUfbId())){
  636. userFollowBusiness.setId(ub.getUfbId());
  637. userFollowBusiness.setFollowSituation(ub.getFollowSituation());
  638. userFollowBusiness.setCustomerStatus(ub.getCustomerStatus());
  639. userFollowBusiness.setRemarks(ub.getRemarks());
  640. userFollowBusinessMapper.updateByPrimaryKeySelective(userFollowBusiness); //修改拜访记录中间表
  641. }else{
  642. //检查业务锁定情况
  643. businessLockedList = userMapper.selectLockedProject(fbb.getUid(), null,ub.getBusinessProjectId(), 1, UserLockReleaseStatus.LOCKED.getCode());
  644. if(businessLockedList.size() > 0){
  645. for(LockingReleaseBo bo : businessLockedList){
  646. if(bo.getAid().equals(TokenManager.getAdminId())) isBusinessOwner = true;
  647. }
  648. if(!isBusinessOwner) throw new BusinessException(new Error(ErrorConstants.BUSINESS_ALREADY_LOCKED,businessName,""));
  649. }else{
  650. if(!isUserOwner) throw new BusinessException(new Error(ErrorConstants.CUSTOMER_ALREADY_LOCKED,businessName,""));
  651. }
  652. if(userBusinessMapper.judgeBusiness(fbb.getUid(), ub.getBusinessProjectId(), "")>0){
  653. throw new BusinessException(new Error(ErrorConstants.BUSINESS_ALREADY_EXIST,businessName,""));
  654. }
  655. String ubId = UUID.randomUUID().toString();
  656. UserBusiness userBusiness = new UserBusiness();
  657. //更新业务表
  658. userBusiness.setId(ubId);
  659. userBusiness.setBusinessProjectId(ub.getBusinessProjectId());
  660. try {
  661. userBusiness.setCreateTime(format.parse(fbb.getFollowTime()));
  662. userBusiness.setUpdateTime(format.parse(fbb.getFollowTime()));
  663. } catch (ParseException e) {
  664. e.printStackTrace();
  665. }
  666. userBusiness.setCustomerStatus(ub.getCustomerStatus());
  667. userBusiness.setFollowSituation(ub.getFollowSituation());
  668. userBusiness.setUid(fbb.getUid());
  669. userBusiness.setAid(TokenManager.getAdminId());
  670. userBusinessMapper.insert(userBusiness);
  671. //更新业务中间表
  672. String ufbId = UUID.randomUUID().toString();
  673. userFollowBusiness.setId(ufbId);
  674. userFollowBusiness.setFollowId(fbb.getFollowId());
  675. userFollowBusiness.setBusinessId(ubId);
  676. userFollowBusiness.setCustomerStatus(ub.getCustomerStatus());
  677. userFollowBusiness.setFollowSituation(ub.getFollowSituation());
  678. userFollowBusiness.setRemarks(ub.getRemarks());
  679. userFollowBusiness.setBusinessProjectId(ub.getBusinessProjectId());
  680. userFollowBusinessMapper.insert(userFollowBusiness);
  681. }
  682. }
  683. }
  684. return 1;
  685. }
  686. @Override
  687. public Set<OrganizationContactBook> findAllContacts(String uid) {
  688. Set<OrganizationContactBook> result = new HashSet<OrganizationContactBook>();
  689. result.addAll(userMapper.findAllContacts(uid));
  690. return result;
  691. }
  692. @Override
  693. public int updateCustomerContacts(List<OrganizationContactBook> ocbList,String uid) {
  694. if(ocbList.size()>0){
  695. OrganizationContactBook ocb = null;
  696. for(OrganizationContactBook item: ocbList){
  697. if(item!=null&&item.getMajor()!=null&&item.getMajor()==1) {
  698. //改变用户原本的联系人
  699. OrganizationIdentity oi=new OrganizationIdentity();
  700. oi.setContacts(item.getName());
  701. oi.setContactMobile(item.getMobile());
  702. oi.setUid(uid);
  703. organizationIdentityMapper.updateServiceByUid(oi);
  704. }
  705. ocb = new OrganizationContactBook();
  706. try {
  707. BeanUtils.copyProperties(ocb, item);
  708. if(StringUtils.isBlank(ocb.getId())){
  709. ocb.setId(UUID.randomUUID().toString());
  710. ocb.setUid(uid);
  711. ocb.setAid(TokenManager.getAdminId());
  712. organizationContactBookMapper.insert(ocb);
  713. }else{
  714. organizationContactBookMapper.updateByPrimaryKeySelective(ocb);
  715. }
  716. } catch (IllegalAccessException | InvocationTargetException e) {
  717. e.printStackTrace();
  718. }
  719. }
  720. }
  721. return 1;
  722. }
  723. @Override
  724. public int deleteFollow(String followId) {
  725. UserFollow uf = new UserFollow();
  726. List<BusinessListBo> list= userMapper.findBusinessByFollowId(followId);
  727. for (BusinessListBo b : list) {
  728. if(b.getFollowSituation()==5)throw new BusinessException(new Error(ErrorConstants.BUSINESS_ALREADY_LOCKED,""));;
  729. }
  730. uf.setId(followId);
  731. uf.setEffective(DeleteStatus.DELETED.getCode());
  732. return userFollowMapper.updateByPrimaryKeySelective(uf);
  733. }
  734. @Override
  735. public void checkCustomer(Set<CustomerExcelBo> boSet, Set<Integer> existRows, Set<Integer> filterRows) {
  736. List<User> list = null;
  737. CustomerExcelBo[] bos = (CustomerExcelBo[])boSet.toArray(new CustomerExcelBo[] {});
  738. for (int i=0;i<bos.length;i++) {
  739. CustomerExcelBo bo = bos[i];
  740. CustomerExcelBo ceb = null;
  741. for(int j=0;j<i;j++){
  742. ceb = bos[j];
  743. if(bo.getCustomerType().equals(AFTConstants.USER_TYPE_PERSONAL)){ //个人
  744. if(ceb.getMobile().equals(bo.getMobile()) && ceb.getCustomerType().equals(bo.getCustomerType())){
  745. bo.setUid(ceb.getUid());
  746. bo.setNewData(false);
  747. filterRows.add(bo.getRowNumber());
  748. break;
  749. }
  750. }else if(bo.getCustomerType().equals(AFTConstants.USER_TYPE_ORGANIZATION)){ //单位
  751. if(ceb.getIdentifyName().equals(bo.getIdentifyName()) && ceb.getCustomerType().equals(bo.getCustomerType())){
  752. bo.setUid(ceb.getUid());
  753. bo.setNewData(false);
  754. filterRows.add(bo.getRowNumber());
  755. break;
  756. }
  757. }
  758. }
  759. if(StringUtils.isBlank(bo.getUid())){ //是否已经存在
  760. if(bo.getCustomerType().equals(AFTConstants.USER_TYPE_PERSONAL)){
  761. list = userMapper.checkUser("", "", bo.getMobile(), Integer.parseInt(bo.getCustomerType()),null,null);
  762. }else if(bo.getCustomerType().equals(AFTConstants.USER_TYPE_ORGANIZATION)){
  763. list = userMapper.checkUser("", bo.getIdentifyName(), "", Integer.parseInt(bo.getCustomerType()),null,null);
  764. }
  765. if (list.size() > 0) {
  766. bo.setUid(list.get(0).getId());
  767. bo.setNewData(false);
  768. List<LockingReleaseBo> businessLockedList = userMapper.selectLockedProject(bo.getUid(), null,bo.getBusinessProjectId(), 1, UserLockReleaseStatus.LOCKED.getCode());
  769. if(businessLockedList.size() > 0){
  770. existRows.add(bo.getRowNumber());
  771. }
  772. }else{
  773. bo.setUid(UUID.randomUUID().toString());
  774. bo.setNewData(true);
  775. }
  776. }else{
  777. List<LockingReleaseBo> businessLockedList = userMapper.selectLockedProject(bo.getUid(), null,bo.getBusinessProjectId(), 1, UserLockReleaseStatus.LOCKED.getCode());
  778. if(businessLockedList.size() > 0){
  779. existRows.add(bo.getRowNumber());
  780. }
  781. }
  782. }
  783. }
  784. @Override
  785. @Transactional
  786. public int saveUploadData(Set<CustomerExcelBo> boSet) {
  787. Date now = new Date();
  788. String uid = "";
  789. for(CustomerExcelBo bo : boSet){
  790. uid = bo.getUid();
  791. if(bo.isNewData()){ //新建客户
  792. createUser(bo, uid, now);
  793. createIdentity(bo, bo.getCustomerType(), uid);
  794. createBusiness(bo, uid, now);
  795. createContacts(bo, uid);
  796. }else{ //新建业务
  797. createBusiness(bo, uid, now);
  798. if(organizationContactBookMapper.checkContacts(uid, bo.getMobile(), TokenManager.getAdminId())<=0){
  799. createContacts(bo, uid);
  800. }
  801. }
  802. }
  803. return 1;
  804. }
  805. private void createUser(CustomerExcelBo bo,String uid,Date now){
  806. User user = new User();
  807. user.setId(uid);
  808. user.setIdentifyName(bo.getIdentifyName());
  809. user.setSource(AFTConstants.USER_SOURCE_CREATE);
  810. user.setNickname(bo.getIdentifyName());
  811. user.setStatus(AFTConstants.USER_STATUS_NORMAL);
  812. user.setShareType(AFTConstants.USER_SHARE_PRIVATE);
  813. user.setAid(TokenManager.getAdminId());
  814. user.setType(Integer.parseInt(bo.getCustomerType()));
  815. user.setLvl(UserLevel.CERTIFIED.getCode());
  816. user.setCreateTime(now);
  817. user.setUpdateTime(now);
  818. user.setMobile(bo.getMobile());
  819. user.setPassword(AFTConstants.INITIALPASSWORD);
  820. passwordUtil.encryptPassword(user);
  821. userMapper.insert(user);
  822. }
  823. private void createIdentity(CustomerExcelBo bo,String type,String uid){
  824. String identifyId = UUID.randomUUID().toString();
  825. if(type.equals(AFTConstants.USER_TYPE_PERSONAL)){
  826. //新增个人认证信息
  827. UserIdentity ui = new UserIdentity();
  828. ui.setId(identifyId);
  829. ui.setUid(uid);
  830. ui.setContacts(bo.getContacts());
  831. ui.setContactMobile(bo.getMobile());
  832. ui.setUsername(bo.getIdentifyName());
  833. ui.setExpert(AFTConstants.NO);
  834. ui.setCelebrity(AFTConstants.NO);
  835. ui.setInternational(AFTConstants.NO);
  836. ui.setAuditStatus(5);
  837. userIdentityMapper.insert(ui);
  838. }else if(type.equals(AFTConstants.USER_TYPE_ORGANIZATION)){
  839. // 创建企业认证信息
  840. OrganizationIdentity oi = new OrganizationIdentity();
  841. oi.setId(identifyId);
  842. oi.setUnitName(bo.getIdentifyName());
  843. oi.setUid(uid);
  844. oi.setContacts(bo.getContacts());
  845. oi.setContactMobile(bo.getMobile());
  846. oi.setHighTechZone(AFTConstants.NO);
  847. oi.setInternational(AFTConstants.NO);
  848. oi.setListed(AFTConstants.NO);
  849. oi.setAuditStatus(5); //实名企业
  850. organizationIdentityMapper.insert(oi);
  851. }
  852. }
  853. private void createContacts(CustomerExcelBo bo,String uid){
  854. //新增企业联系人
  855. OrganizationContactBook cob = new OrganizationContactBook();
  856. cob.setAid(TokenManager.getAdminId());
  857. cob.setId(UUID.randomUUID().toString());
  858. cob.setUid(uid);
  859. cob.setName(bo.getContacts());
  860. cob.setMobile(bo.getMobile());
  861. cob.setMajor(AFTConstants.NO);
  862. organizationContactBookMapper.insert(cob);
  863. }
  864. private void createBusiness(CustomerExcelBo bo,String uid,Date now){
  865. //新增业务
  866. UserBusiness ub = new UserBusiness();
  867. ub.setId(UUID.randomUUID().toString());
  868. ub.setAid(TokenManager.getAdminId());
  869. ub.setBusinessProjectId(bo.getBusinessProjectId());
  870. ub.setUid(uid);
  871. ub.setCreateTime(now);
  872. ub.setUpdateTime(now);
  873. ub.setCustomerStatus(Integer.parseInt(bo.getCustomerStatus()));
  874. ub.setFollowSituation(Integer.parseInt(bo.getFollowSituation()));
  875. userBusinessMapper.insert(ub);
  876. }
  877. @Override
  878. public int updateByOperatorType(String uid,String oldAid, String operatorType,Object... params) {
  879. User user = new User();
  880. Date now = new Date();
  881. user.setId(uid);
  882. int flag = 0;
  883. if(operatorType.equals(AFTConstants.USER_RECEIVE)){
  884. user.setAid(TokenManager.getAdminId());
  885. user.setShareType(AFTConstants.USER_SHARE_PRIVATE);
  886. user.setInformationMaintainer(TokenManager.getAdminId());
  887. user.setSource(2);//客户来源设置为领取
  888. // 转换不重置时间
  889. // user.setTransferTime(now);
  890. flag = addUserLock(uid,TokenManager.getAdminId(),0,null,now); //指定用户锁定客户
  891. if(flag <= 0) throw new BusinessException(new Error(ErrorConstants.CUSTOMER_ALREADY_RECEIVE,""));
  892. if(userMapper.UserReceiveCount(TokenManager.getAdminId())>AFTConstants.USER_RCEIVE_MAX)
  893. throw new BusinessException(new Error(ErrorConstants.CUSTOM_EREXCESS,""+(AFTConstants.USER_RCEIVE_MAX+1),""));
  894. organizationContactBookMapper.updateAdmin(uid,TokenManager.getAdminId());
  895. }else if(operatorType.equals(AFTConstants.USER_TRANSFER_TO_OTHER)){
  896. user.setAid(String.valueOf(params[0]));
  897. user.setSource(3);//客户来源设置为转交
  898. // 转换不重置时间
  899. // user.setTransferTime(now);
  900. //查询这个客户是否是登陆人的客户
  901. if(userMapper.getAidAndUser(uid,TokenManager.getAdminId())<=0)throw new BusinessException(new Error("请勿非法操作!","请勿非法操作!"));
  902. flag = updateUserLock(uid,oldAid,UserLockReleaseStatus.LOCKED.getCode(),UserLockReleaseStatus.RELEASE.getCode()); //原用户释放客户
  903. if(flag > 0 ) flag = addUserLock(uid,String.valueOf(params[0]),0,null,now); //指定用户锁定客户
  904. if(flag <= 0) throw new BusinessException(new Error(ErrorConstants.CUSTOMER_TRANSFER_FAIL,""));
  905. addtransferLog(uid,null,TokenManager.getAdminId(),String.valueOf(params[0]),0);
  906. }
  907. return userMapper.updateByPrimaryKeySelective(user);
  908. }
  909. @SuppressWarnings("unchecked")
  910. @Override
  911. public Pagination<StatisticBo> customerStatistics(Date sDate, Date eDate, String depNo, String businessGlossoryId, Integer pageNo, Integer pageSize) {
  912. Map<String,Object> params = new HashMap<String,Object>();
  913. if(null != sDate) params.put("sDate", sDate);
  914. if(null != eDate) params.put("eDate", eDate);
  915. if(StringUtils.isNotBlank(depNo)) params.put("depNo", depNo);
  916. if(StringUtils.isNotBlank(businessGlossoryId)) params.put("businessGlossoryId", businessGlossoryId);
  917. Pagination<StatisticBo> page = (Pagination<StatisticBo>)findPage("customerStatisticsList", "customerStatisticsCount", params, pageNo, pageSize);
  918. return page;
  919. }
  920. @SuppressWarnings("unchecked")
  921. @Override
  922. public Pagination<StatisticBo> businessStatistic(Date sDate, Date eDate,String depNo, String businessGlossoryId,Integer pageNo, Integer pageSize) {
  923. Map<String,Object> params = new HashMap<String,Object>();
  924. if(null != sDate) params.put("sDate", sDate);
  925. if(null != eDate) params.put("eDate", eDate);
  926. if(StringUtils.isNotBlank(depNo)) params.put("depNo", depNo);
  927. if(StringUtils.isNotBlank(businessGlossoryId)) params.put("businessGlossoryId", businessGlossoryId);
  928. Pagination<StatisticBo> page = (Pagination<StatisticBo>)findPage("businessStatisticList", "businessStatisticCount", params, pageNo, pageSize);
  929. return page;
  930. }
  931. @SuppressWarnings("unchecked")
  932. @Override
  933. public Pagination<StatisticBo> followStatistic(Date sDate, Date eDate, String depNo, Integer pageNo, Integer pageSize) {
  934. Map<String,Object> params = new HashMap<String,Object>();
  935. if(null != sDate) params.put("sDate", sDate);
  936. if(null != eDate) params.put("eDate", eDate);
  937. if(StringUtils.isNotBlank(depNo)) params.put("depNo", depNo);
  938. Pagination<StatisticBo> page = (Pagination<StatisticBo>)findPage("followStatisticList", "followStatisticCount", params, pageNo, pageSize);
  939. return page;
  940. }
  941. @SuppressWarnings("unchecked")
  942. @Override
  943. public Pagination<BusinessListBo> listBusiness(BusinessListBo blo,Integer pageNo,Integer pageSize) {
  944. blo.setAid(TokenManager.getAdminId());
  945. return (Pagination<BusinessListBo>) findPage("selectBusinessList", "selectBusinessCount", disposeParams(blo), pageNo, pageSize);
  946. }
  947. @SuppressWarnings("unchecked")
  948. @Override
  949. public Pagination<BusinessListBo> listAllBusiness(BusinessListBo blo, Integer pageNo, Integer pageSize) {
  950. return (Pagination<BusinessListBo>) findPage("selectBusinessList", "selectBusinessCount", disposeParams(blo), pageNo, pageSize);
  951. }
  952. @SuppressWarnings("unchecked")
  953. @Override
  954. public Pagination<BusinessListBo> listManageBusiness(BusinessListBo blo,Integer pageNo,Integer pageSize) {
  955. blo.setAid(TokenManager.getAdminId());
  956. return (Pagination<BusinessListBo>) findPage("selectBusinessManageList", "selectBusinessManageCount", disposeParams(blo), pageNo, pageSize);
  957. }
  958. private Map<String,Object> disposeParams(BusinessListBo blo){
  959. Map<String, Object> params = new HashMap<String, Object>();
  960. if(StringUtils.isNotBlank(blo.getUid())) params.put("uid", blo.getUid());
  961. if(StringUtils.isNotBlank(blo.getAid())) params.put("aid", blo.getAid());
  962. if(StringUtils.isNotBlank(blo.getAdminName())) params.put("adminName", blo.getAdminName());
  963. if(StringUtils.isNotBlank(blo.getStartDate())) params.put("startDate", blo.getStartDate()+" 00:00:00");
  964. if(StringUtils.isNotBlank(blo.getEndDate())) params.put("endDate", blo.getEndDate()+ " 23:59:59");
  965. if(StringUtils.isNotBlank(blo.getIdentifyName())) params.put("identifyName", blo.getIdentifyName());
  966. if(blo.getFollowSituation() != null) params.put("followSituation", blo.getFollowSituation());
  967. if(blo.getCustomerStatus() != null) params.put("customerStatus", blo.getCustomerStatus());
  968. return params;
  969. }
  970. @Override
  971. public List<BusinessListBo> findBusinessGlossory() {
  972. return userBusinessMapper.selectBusinessGlossory();
  973. }
  974. @Override
  975. public int judgeBusiness(String uid, String businessProjectId) {
  976. return userMapper.selectLockedProject(uid, null,businessProjectId, 1, UserLockReleaseStatus.LOCKED.getCode()).size();
  977. }
  978. @Override
  979. @Transactional
  980. public void addBusinessAndFollow(BussinessFollowBo bfb) throws ParseException {
  981. UserBusiness ub = new UserBusiness();
  982. String ubId = UUID.randomUUID().toString();
  983. SimpleDateFormat format = new SimpleDateFormat(AFTConstants.YYYYMMDDHHMMSS);
  984. ub.setCustomerStatus(Integer.parseInt(bfb.getCustomerStatus()));
  985. ub.setFollowSituation(Integer.parseInt(bfb.getFollowSituation()));
  986. ub.setId(ubId);
  987. ub.setUid(bfb.getUid());
  988. ub.setAid(TokenManager.getAdminId());
  989. ub.setRemarks(bfb.getRemarks());
  990. ub.setBusinessProjectId(bfb.getBusinessProjectId());
  991. ub.setUpdateTime(format.parse(bfb.getCreateTime()));
  992. ub.setCreateTime(format.parse(bfb.getCreateTime()));
  993. userBusinessMapper.insert(ub);
  994. if (StringUtils.isNotBlank(bfb.getOcbId())) { // 跟进联系人不为空则添加跟进记录
  995. UserFollow uf = new UserFollow();
  996. String ufId = UUID.randomUUID().toString();
  997. uf.setId(ufId);
  998. uf.setUid(bfb.getUid());
  999. uf.setCreateTime(format.parse(bfb.getFollowTime()));
  1000. uf.setOcbId(bfb.getOcbId());
  1001. uf.setResult(bfb.getResult());
  1002. uf.setContactType(Integer.parseInt(bfb.getContactType()));
  1003. uf.setAid(TokenManager.getAdminId());
  1004. uf.setEffective(0);
  1005. int followCount = userBusinessMapper.selectFollowCountByUAid(bfb.getUid(), TokenManager.getAdminId()) + 1;
  1006. uf.setFollowCount(followCount);
  1007. userFollowMapper.insert(uf);
  1008. UserFollowBusiness ufb = new UserFollowBusiness();
  1009. ufb.setId(UUID.randomUUID().toString());
  1010. ufb.setBusinessId(ubId);
  1011. ufb.setFollowId(ufId);
  1012. ufb.setCustomerStatus(ub.getCustomerStatus());
  1013. ufb.setFollowSituation(ub.getFollowSituation());
  1014. ufb.setBusinessProjectId(bfb.getBusinessProjectId());
  1015. userFollowBusinessMapper.insert(ufb);
  1016. }
  1017. }
  1018. @Override
  1019. public List<BusinessListBo> findBusinessByUAid(String uid, String aid) {
  1020. return userBusinessMapper.selectBusinessByUAid(uid,aid);
  1021. }
  1022. @Override
  1023. public List<BusinessListBo> findLockedBusinessByUAid(String uid, String aid) {
  1024. return userBusinessMapper.selectLockedBusinessByUAid(uid,aid);
  1025. }
  1026. @Override
  1027. public BussinessFollowBo findBusinessDetail(String businessId) {
  1028. return userBusinessMapper.findBusinessDetail(businessId);
  1029. }
  1030. @Override
  1031. public int updateBusiness(BussinessFollowBo bfb) {
  1032. UserBusiness userBusiness = new UserBusiness();
  1033. userBusiness.setId(bfb.getBusinessId());
  1034. userBusiness.setCustomerStatus(Integer.parseInt(bfb.getCustomerStatus()));
  1035. userBusiness.setFollowSituation(Integer.parseInt(bfb.getFollowSituation()));
  1036. userBusiness.setRemarks(bfb.getRemarks());
  1037. userBusiness.setUpdateTime(new Date());
  1038. return userBusinessMapper.updateByPrimaryKeySelective(userBusiness);
  1039. }
  1040. @Override
  1041. @Transactional
  1042. public int addFollowOneBusiness(BussinessFollowBo bfb) throws ParseException {
  1043. Date updateTime = new Date();
  1044. SimpleDateFormat format = new SimpleDateFormat(AFTConstants.YYYYMMDDHHMMSS);
  1045. UserBusiness userBusiness = new UserBusiness();
  1046. userBusiness.setId(bfb.getBusinessId());
  1047. userBusiness.setUpdateTime(updateTime);
  1048. userBusiness.setCustomerStatus(Integer.parseInt(bfb.getCustomerStatus()));
  1049. userBusiness.setFollowSituation(Integer.parseInt(bfb.getFollowSituation()));
  1050. userBusinessMapper.updateByPrimaryKeySelective(userBusiness);
  1051. UserFollow userFollow = new UserFollow();
  1052. String followId = UUID.randomUUID().toString();
  1053. int followCount = userBusinessMapper.selectFollowCountByUAid(bfb.getUid(), TokenManager.getAdminId()) + 1;
  1054. userFollow.setId(followId);
  1055. userFollow.setResult(bfb.getResult());
  1056. userFollow.setCreateTime(format.parse(bfb.getFollowTime()));
  1057. userFollow.setEffective(0);
  1058. userFollow.setOcbId(bfb.getOcbId());
  1059. userFollow.setFollowCount(followCount);
  1060. userFollow.setContactType(Integer.parseInt(bfb.getContactType()));
  1061. userFollow.setAid(TokenManager.getAdminId());
  1062. userFollow.setUid(bfb.getUid());
  1063. userFollowMapper.insert(userFollow);
  1064. UserFollowBusiness userFollowBusiness = new UserFollowBusiness();
  1065. String ufbId = UUID.randomUUID().toString();
  1066. userFollowBusiness.setId(ufbId);
  1067. userFollowBusiness.setFollowId(followId);
  1068. userFollowBusiness.setBusinessProjectId(bfb.getBusinessProjectId());
  1069. userFollowBusiness.setBusinessId(bfb.getBusinessId());
  1070. userFollowBusiness.setCustomerStatus(Integer.parseInt(bfb.getCustomerStatus()));
  1071. userFollowBusiness.setFollowSituation(Integer.parseInt(bfb.getFollowSituation()));
  1072. userFollowBusiness.setRemarks(bfb.getRemarks());
  1073. userFollowBusinessMapper.insert(userFollowBusiness);
  1074. return 1;
  1075. }
  1076. @Override
  1077. public BussinessFollowBo findFollowOneBusiness(String ufbId) {
  1078. return userBusinessMapper.findFollowOneBusiness(ufbId);
  1079. }
  1080. @Override
  1081. public int updateFollowOneBusiness(BussinessFollowBo bfb) {
  1082. //修改业务跟进中间表
  1083. UserFollowBusiness userFollowBusiness = new UserFollowBusiness();
  1084. userFollowBusiness.setId(bfb.getUfbId());
  1085. userFollowBusiness.setRemarks(bfb.getRemarks());
  1086. userFollowBusiness.setCustomerStatus(Integer.parseInt(bfb.getCustomerStatus()));
  1087. userFollowBusiness.setFollowSituation(Integer.parseInt(bfb.getFollowSituation()));
  1088. userFollowBusinessMapper.updateByPrimaryKeySelective(userFollowBusiness);
  1089. //修改跟进记录表
  1090. UserFollow userFollow = new UserFollow();
  1091. userFollow.setId(bfb.getFollowId());
  1092. userFollow.setContactType(Integer.parseInt(bfb.getContactType()));
  1093. userFollow.setResult(bfb.getResult());
  1094. if(StringUtils.isNotBlank(bfb.getOcbId())) userFollow.setOcbId(bfb.getOcbId());
  1095. userFollowMapper.updateByPrimaryKeySelective(userFollow);
  1096. return 1;
  1097. }
  1098. @Override
  1099. public int addOneContact(OrganizationContactBook ocb) {
  1100. ocb.setAid(TokenManager.getAdminId());
  1101. ocb.setId(UUID.randomUUID().toString());
  1102. ocb.setMajor(AFTConstants.NO);
  1103. return organizationContactBookMapper.insert(ocb);
  1104. }
  1105. @Override
  1106. public int deleteBusiness(String businessId) {
  1107. return userBusinessMapper.deleteByPrimaryKey(businessId);
  1108. }
  1109. @Override
  1110. public int updateBusinessToStop(String businessId) {
  1111. UserBusiness ub = new UserBusiness();
  1112. ub.setId(businessId);
  1113. ub.setCustomerStatus(CustomerStatusFiled.STATUS_STOP.getCode());
  1114. return userBusinessMapper.updateByPrimaryKeySelective(ub);
  1115. }
  1116. @Override
  1117. public int deleteFollowOneBusiness(String ufbId) {
  1118. UserFollowBusiness ufb=userFollowBusinessMapper.selectByPrimaryKey(ufbId);
  1119. if (ufb.getFollowSituation()==5) {//如果业务是已签合同则不允许删除
  1120. throw new BusinessException(new Error(ErrorConstants.BUSINESS_ALREADY_LOCKED,""));
  1121. }
  1122. return userFollowBusinessMapper.deleteByPrimaryKey(ufbId);
  1123. }
  1124. @Override
  1125. public int deleteOneContact(String ocbId) {
  1126. return organizationContactBookMapper.deleteByPrimaryKey(ocbId);
  1127. }
  1128. @Override
  1129. public List<Admin> findAdminName() {
  1130. String aid=TokenManager.getAdminId();
  1131. return userMapper.findAdminName(aid);
  1132. }
  1133. @Override
  1134. public int updatePersonalCustomerz(CustomerPersonalDetailBo bo) {
  1135. UserIdentity ui = new UserIdentity();
  1136. User user = new User();
  1137. try {
  1138. BeanUtilsExt.copyProperties(ui, bo);
  1139. user.setId(bo.getUid());
  1140. user.setSocietyTag(bo.getSocietyTag());
  1141. user.setHeadPortraitUrl(bo.getHeadPortraitUrl());
  1142. user.setIntroduction(bo.getIntroduction());
  1143. user.setUpdateTime(new Date());
  1144. if(!StringUtils.isBlank(bo.getAid())){
  1145. user.setAid(bo.getAid());
  1146. user.setShareType(0);
  1147. }
  1148. } catch (InvocationTargetException | IllegalAccessException e) {
  1149. e.printStackTrace();
  1150. }
  1151. userMapper.updateByPrimaryKeySelective(user);
  1152. return 1;
  1153. }
  1154. @Override
  1155. public Pagination<CustomerListOut> findEnteringAudit(CustomerListOut clo, Integer pageNo, Integer pageSize) {
  1156. Map<String,Object> params = disposeParams(clo);
  1157. if(!StringUtils.isBlank(clo.getAdminName()))params.put("adminName", clo.getAdminName());
  1158. @SuppressWarnings("unchecked")
  1159. Pagination<CustomerListOut> list = (Pagination<CustomerListOut>) findPage("findEnteringAuditList","findEnteringAuditCount",params,pageNo,pageSize);
  1160. return list;
  1161. }
  1162. @Override
  1163. public Pagination<CustomerListOut> findEnteringAuditIsNo(CustomerListOut clo, Integer pageNo, Integer pageSize) {
  1164. clo.setAid(TokenManager.getAdminId());
  1165. Map<String,Object> params = disposeParams(clo);
  1166. if(!StringUtils.isBlank(clo.getAdminName()))params.put("adminName", clo.getAdminName());
  1167. @SuppressWarnings("unchecked")
  1168. Pagination<CustomerListOut> list = (Pagination<CustomerListOut>) findPage("findEnteringAuditIsNoList","findEnteringAuditIsNoCount",params,pageNo,pageSize);
  1169. return list;
  1170. }
  1171. @Override
  1172. public int updateEnteringAudit(User bo) {
  1173. String[] ary=bo.getId().split(",");
  1174. for (String s : ary) {
  1175. String id=s;
  1176. Integer auditStatus=bo.getAuditStatus();
  1177. String auditOpinion=bo.getAuditOpinion();
  1178. userMapper.updateEnteringAudit(id,auditStatus,auditOpinion);
  1179. }
  1180. return 1;
  1181. }
  1182. @Override
  1183. public int updateMainContact(String ocbId,String uid) {
  1184. organizationContactBookMapper.updateSubContact(uid);
  1185. organizationContactBookMapper.updateMainContact(ocbId);
  1186. return 1;
  1187. }
  1188. @Override
  1189. public int updateRefusedCustomer(String id,String nickname, String mobile, String societyTag) {
  1190. User u=userMapper.selectByPrimaryKey(id);
  1191. u.setNickname(nickname);
  1192. u.setMobile(mobile);
  1193. u.setSocietyTag(societyTag);
  1194. return userMapper.updateRefusedCustomer(id, nickname, mobile, societyTag);
  1195. }
  1196. private void setCustomerList(List<CustomerListOut> tmpList,int i){
  1197. Date now = new Date();
  1198. String s1,s2;
  1199. Long l1,l2;
  1200. int diff1=0,diff2=0;
  1201. for(CustomerListOut clo: tmpList){
  1202. try {
  1203. //如果最近跟进为空直接取转换时间
  1204. if (StringUtils.isNotBlank(clo.getLastFollowTime())){
  1205. //如果最近跟进小于转换取转换时间
  1206. if(DateUtils.parseDate(clo.getLastFollowTime(), AFTConstants.YYYYMMDDHHMMSS).getTime()>DateUtils.parseDate(clo.getTransferTime(), AFTConstants.YYYYMMDDHHMMSS).getTime()) {
  1207. s1=clo.getLastFollowTime();
  1208. }else {
  1209. s1=clo.getTransferTime();
  1210. }
  1211. }else {
  1212. s1=clo.getTransferTime();
  1213. }
  1214. //另外一个时间取转换时间
  1215. s2 = clo.getTransferTime();
  1216. l1 = DateUtils.parseDate(s1, AFTConstants.YYYYMMDDHHMMSS).getTime();
  1217. l2 = DateUtils.parseDate(s2, AFTConstants.YYYYMMDDHHMMSS).getTime();
  1218. if(i==0) {
  1219. diff1 = (int)((l1 + AFTConstants.USER_FOLLOW_LIMIT_MS - now.getTime())/(24*3600*1000));
  1220. diff2 = (int)((l2 + AFTConstants.USER_SIGN_LIMIT_MS - now.getTime())/(24*3600*1000));
  1221. }else if (i==1) {
  1222. diff1 = (int)((l1 + AFTConstants.PROJECT_FOLLOW_LIMIT_MS - now.getTime())/(24*3600*1000));
  1223. diff2 = (int)((l2 + AFTConstants.PROJECT_SIGN_LIMIT_MS - now.getTime())/(24*3600*1000));
  1224. }
  1225. clo.setSurplusFollowTime(diff1 + "");
  1226. clo.setSurplusSignTime(diff2 + "");
  1227. } catch (ParseException e) {
  1228. e.printStackTrace();
  1229. }
  1230. }
  1231. }
  1232. @SuppressWarnings("unchecked")
  1233. @Override
  1234. public Pagination<CustomerListOut> listSignOrganizationCustomer(CustomerListIn cli, Integer pageNo,
  1235. Integer pageSize) {
  1236. cli.setAid(TokenManager.getAdminId());
  1237. // cli.setAid("1");
  1238. Map<String,Object> params = disposeParams(cli);
  1239. Pagination<CustomerListOut> list = (Pagination<CustomerListOut>) findPage("selectSignOrganizationCustomerList","selectSignOrganizationCustomerCount",params,pageNo,pageSize);
  1240. List<CustomerListOut> tmpList = (List<CustomerListOut>)list.getList();
  1241. setCustomerList(tmpList,1);
  1242. list.setList(tmpList);
  1243. return list;
  1244. }
  1245. @SuppressWarnings("unchecked")
  1246. @Override
  1247. public Pagination<CustomerListOut> listSignPersonalCustomer(CustomerListIn cli, Integer pageNo,
  1248. Integer pageSize) {
  1249. cli.setAid(TokenManager.getAdminId());
  1250. Map<String,Object> params = disposeParams(cli);
  1251. Pagination<CustomerListOut> list = (Pagination<CustomerListOut>) findPage("selectSignPersonalCustomerList","selectSignPersonalCustomerCount",params,pageNo,pageSize);
  1252. List<CustomerListOut> tmpList = (List<CustomerListOut>)list.getList();
  1253. setCustomerList(tmpList,0);
  1254. list.setList(tmpList);
  1255. return list;
  1256. }
  1257. @Override
  1258. public List<LockingReleaseBo> selectLockedProject(String uid) {
  1259. return userMapper.selectLockedProject(uid,null,null,1,null);
  1260. }
  1261. @Override
  1262. public List<CustomerSimpleBo> getPrivateCustomerByName(String name) {
  1263. return userMapper.selectPrivateCustomerByName(name,TokenManager.getAdminId());
  1264. }
  1265. @Override
  1266. public List<CustomerSimpleBo> getSignedCustomerByName(String name) {
  1267. return userMapper.selectSignedCustomerByName(name,TokenManager.getAdminId());
  1268. }
  1269. private int updateUserLock(String uid,String aid,Integer oldStatus,Integer newStatus){
  1270. return userLockReleaseMapper.updateUserLock(uid,aid,oldStatus,newStatus);
  1271. }
  1272. private int addUserLock(String uid,String aid,Integer type,String pid,Date lockTime){
  1273. UserLockRelease ulr = new UserLockRelease();
  1274. ulr.setId(UUID.randomUUID().toString());
  1275. if (type==0) {
  1276. ulr.setType(0);
  1277. }else {
  1278. ulr.setType(1);
  1279. ulr.setBusinessProjectId(pid);
  1280. }
  1281. ulr.setAid(aid);
  1282. ulr.setLockTime(lockTime);
  1283. ulr.setStatus(UserLockReleaseStatus.LOCKED.getCode());
  1284. ulr.setUid(uid);
  1285. return userLockReleaseMapper.insert(ulr);
  1286. }
  1287. /**
  1288. * 查询需要释放客户
  1289. * @param uid
  1290. * @return
  1291. */
  1292. @Override
  1293. public List<LockingReleaseBo> selectWaitReleaseCustomer(String uid){
  1294. return userLockReleaseMapper.selectWaitReleaseCustomer(uid);
  1295. }
  1296. /**
  1297. * 查询需要释放的业务
  1298. * @param uid
  1299. * @return
  1300. */
  1301. @Override
  1302. public List<LockingReleaseBo> selectWaitReleaseBusiness(String uid){
  1303. return userLockReleaseMapper.selectWaitReleaseBusiness(uid);
  1304. }
  1305. /**
  1306. * 处理需要释放
  1307. * @param list
  1308. */
  1309. @Override
  1310. public void updateReleaseLock(Date releaseTime){
  1311. SimpleDateFormat formatter=new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
  1312. String time=formatter.format(releaseTime);
  1313. userMapper.updateReleaseLock(time);
  1314. userLockReleaseMapper.updateReleaseLock(time);
  1315. }
  1316. @Override
  1317. public int updateAgainProjectTask(String uid, String projectId,String aid) {
  1318. List<LockingReleaseBo> businessLockedList = userMapper.selectLockedProject(uid, TokenManager.getAdminId(), projectId, 1, UserLockReleaseStatus.LOCKED.getCode());
  1319. // List<LockingReleaseBo> businessLockedList = userMapper.selectLockedProject(uid, aid, projectId, 1, UserLockReleaseStatus.LOCKED.getCode());
  1320. UserLockRelease u= new UserLockRelease();
  1321. if (businessLockedList.size()==1) {
  1322. for (LockingReleaseBo l : businessLockedList) {
  1323. u.setId(l.getId());
  1324. u.setLockTime(new Date());
  1325. }
  1326. return userLockReleaseMapper.updateByPrimaryKeySelective(u);
  1327. }
  1328. return 0;
  1329. }
  1330. @Override
  1331. public int updateInformationMaintainerr(String id, String aid) {
  1332. User u=new User();
  1333. u.setId(id);
  1334. u.setInformationMaintainer(aid);
  1335. return userMapper.updateByPrimaryKeySelective(u);
  1336. }
  1337. @SuppressWarnings("unchecked")
  1338. @Override
  1339. public Pagination<CustomerListIn> listCustomerInformation(CustomerListIn cli, Integer pageNo, Integer pageSize) {
  1340. cli.setType(AFTConstants.USER_TYPE_ORGANIZATION);
  1341. cli.setAid(TokenManager.getAdminId());
  1342. // cli.setAid("1");
  1343. cli.setShareType(String.valueOf(AFTConstants.USER_SHARE_PRIVATE));
  1344. Map<String,Object> params = disposeParams(cli);
  1345. return (Pagination<CustomerListIn>) findPage("selectCustomerInformationList","selectCustomerInformationCount",params,pageNo,pageSize);
  1346. }
  1347. @SuppressWarnings("unchecked")
  1348. @Override
  1349. public Pagination<CustomerListIn> listDepCustomerInformation(CustomerListIn cli, Integer pageNo, Integer pageSize) {
  1350. cli.setType(AFTConstants.USER_TYPE_ORGANIZATION);
  1351. cli.setAid(TokenManager.getAdminId());
  1352. // cli.setAid("1");
  1353. cli.setShareType(String.valueOf(AFTConstants.USER_SHARE_PRIVATE));
  1354. Map<String,Object> params = disposeParams(cli);
  1355. return (Pagination<CustomerListIn>) findPage("selectDepCustomerInformationList","selectDepCustomerInformationCount",params,pageNo,pageSize);
  1356. }
  1357. public boolean checkCustomerInformation(String uid) {
  1358. int i=userMapper.checkCustomerInformation(uid);
  1359. if (i<1) {
  1360. return true;
  1361. }
  1362. return false;
  1363. }
  1364. @Override
  1365. public void updatePendingReleaseLock(List<LockingReleaseBo> newList) {
  1366. String lockIds = "";
  1367. for(LockingReleaseBo bo:newList){
  1368. lockIds += bo.getId() + ",";
  1369. }
  1370. if(lockIds.length()>0) {
  1371. lockIds = "'" + lockIds.substring(0,lockIds.length()-1).replace(",", "','") + "'";
  1372. userLockReleaseMapper.updatePendingReleaseLock(lockIds);
  1373. }
  1374. }
  1375. @Override
  1376. public List<LockingReleaseBo> selectPendinglockUserList() {
  1377. return userLockReleaseMapper.selectPendinglockUserList();
  1378. }
  1379. @Override
  1380. public int updateUserLevel(User u) {
  1381. return userMapper.updateByPrimaryKeySelective(u);
  1382. }
  1383. @Override
  1384. public XSSFWorkbook privateUnitCustomerOutXls(CustomerListIn cli, Integer sort, Integer sortType, Integer pageNo,
  1385. Integer pageSize) {
  1386. cli.setType(AFTConstants.USER_TYPE_ORGANIZATION);
  1387. cli.setAid(TokenManager.getAdminId());
  1388. // cli.setAid("1");
  1389. cli.setShareType(String.valueOf(AFTConstants.USER_SHARE_PRIVATE));
  1390. Map<String,Object> params = disposeParams(cli);
  1391. params.put("sort", sort);
  1392. params.put("sortType",sortType);
  1393. List<CustomerListOut> list= userMapper.privateUnitCustomerList(params);
  1394. setCustomerList(list,0);
  1395. if (list==null || list.size()==0) return null;
  1396. String[] comment = {"客户名称","地区","联系人","联系电话","社会性质","客户初始时间","剩余私有天数","最新跟进时间","客户等级"};
  1397. String filePath = uploadPath + "/privateUnitCustomer";
  1398. XSSFWorkbook wb = ExportExcelUtil.exportSelectPrivateOrganizationCustomer(list, comment, filePath);
  1399. return wb;
  1400. }
  1401. @Override
  1402. public int customerHandOver(String userIds, String receiveId) {
  1403. /* String [] str=userIds.split(",");
  1404. String aid=TokenManager.getAdminId();
  1405. List<String> uids=Arrays.asList(str);
  1406. userLockReleaseMapper.updateBatchReleaseProject(uids,receiveId,aid);
  1407. userLockReleaseMapper.updateBatchlockProject(uids,receiveId,aid);*/
  1408. return 0;
  1409. }
  1410. @Override
  1411. public int updatePrivateBusinessTransfer(String inputId, String uid, String pid) {
  1412. Date now = new Date();
  1413. List<LockingReleaseBo> list=userLockReleaseMapper.checkUserProject(uid, pid,TokenManager.getAdminId());
  1414. if (list.isEmpty()) {
  1415. throw new BusinessException(new Error("客户归属错误","客户归属错误"));
  1416. }else if(list.size()>1) {
  1417. throw new BusinessException(new Error("业务数量错误","业务数量错误"));
  1418. }
  1419. LockingReleaseBo l=list.get(0);
  1420. UserLockRelease ul=new UserLockRelease();
  1421. ul.setId(l.getId());
  1422. ul.setStatus(2);
  1423. ul.setReleaseTime(now);
  1424. userLockReleaseMapper.updateByPrimaryKeySelective(ul);
  1425. addtransferLog(uid,pid,TokenManager.getAdminId(),inputId,1);
  1426. addUserLock(uid,inputId,1,pid,now); //指定用户锁定客户
  1427. List<BusinessListBo> bl=userBusinessMapper.selectBusinessProjectByUAPid(uid, TokenManager.getAdminId(), pid);
  1428. if (bl.size()==1) {
  1429. UserBusiness ub=new UserBusiness();
  1430. ub.setId(bl.get(0).getBusinessId());
  1431. ub.setAid(inputId);
  1432. ub.setRemarks("转交客户业务触发");
  1433. userBusinessMapper.updateByPrimaryKeySelective(ub);
  1434. }
  1435. return 1;
  1436. }
  1437. private void addtransferLog(String uid, String pid, String aid, String takeAid,Integer type) {
  1438. UserTransferLog utl=new UserTransferLog();
  1439. utl.setAid(aid);
  1440. utl.setCreateTime(new Date());
  1441. utl.setPid(pid);
  1442. utl.setTakeAid(takeAid);
  1443. utl.setType(type);
  1444. utl.setUid(uid);
  1445. userTransferLogMapper.insertSelective(utl);
  1446. }
  1447. @Override
  1448. public List<transferListBo> transferList(String uid) {
  1449. return userTransferLogMapper.selectByUidGetList(uid);
  1450. }
  1451. @Override
  1452. public int pushReleaseUser(String id) {
  1453. Date date =new Date();
  1454. User u=userMapper.selectByPrimaryKey(id);
  1455. System.out.println(u.getAid());
  1456. System.out.println(TokenManager.getAdminId());
  1457. if (!u.getAid().equals(TokenManager.getAdminId())) {
  1458. throw new BuilderException("客户归属错误!");
  1459. }
  1460. u.setTransferTime(date);
  1461. u.setShareType(1);
  1462. userMapper.updateByPrimaryKeySelective(u);
  1463. userLockReleaseMapper.updateUserTypeLock(u.getId(), TokenManager.getAdminId(), 0, 2,date);
  1464. return 1;
  1465. }
  1466. }