UserMapper.java 8.4 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260
  1. package com.goafanti.common.dao;
  2. import com.goafanti.admin.bo.AdminCustomerBo;
  3. import com.goafanti.app.bo.UserBasicInfo;
  4. import com.goafanti.common.bo.OutUser;
  5. import com.goafanti.common.bo.userDaysBo;
  6. import com.goafanti.common.model.Admin;
  7. import com.goafanti.common.model.AdminUserCount;
  8. import com.goafanti.common.model.OrganizationContactBook;
  9. import com.goafanti.common.model.User;
  10. import com.goafanti.customer.bo.*;
  11. import com.goafanti.report.bo.CountMarketingStatisticsBo;
  12. import com.goafanti.report.bo.marketingESBo;
  13. import com.goafanti.report.bo.userDataListBo;
  14. import com.goafanti.user.bo.*;
  15. import org.apache.ibatis.annotations.Param;
  16. import java.util.Date;
  17. import java.util.List;
  18. import java.util.Map;
  19. public interface UserMapper {
  20. int deleteByPrimaryKey(String id);
  21. int insert(User record);
  22. int insertSelective(User record);
  23. User selectByPrimaryKey(String id);
  24. int updateByPrimaryKeySelective(User record);
  25. int updateByPrimaryKey(User record);
  26. UserPageHomeBo selectUserPageHomeBoByUserId(String uid);
  27. UserDownLoadBo selectUserDownLoadBoByUserId(String id);
  28. //List<OrgListBo> selectUserByAid(String aid);
  29. String findUserByNameAndMobile(@Param("name") String name, @Param("mobile") String mobile);
  30. String findOrgByNameAndMobile(@Param("name") String name, @Param("mobile") String mobile);
  31. UserPartnerDetailBo findUserPartnerDetail(String uid);
  32. OrgPartnerDetailBo findOrgPartnerDetail(String uid);
  33. Long selectNumberByPrimaryKey(String userId);
  34. List<UserPartnerDetailBo> findUserPartner();
  35. User selectByMobieAndType(String mobile, Integer type);
  36. /**
  37. * 根据客户模糊搜索
  38. * @return
  39. */
  40. List<CustomerSimpleBo> findCustomerByName(@Param("identifyName")String identifyName);
  41. /**
  42. * 判断客户是否存在
  43. * @return
  44. */
  45. int judgeCustomerByName(@Param("identifyName")String identifyName);
  46. /**
  47. * 查询单位客户详情
  48. * @param uid 用户ID
  49. * @return
  50. */
  51. CustomerPersonalDetailBo findPersonalCustomerDetail(@Param("uid")String uid);
  52. /**
  53. * 查询单位客户详情
  54. * @param uid 用户ID
  55. * @return
  56. */
  57. CustomerOrganizationDetailBo findOrganizationCustomerDetail(@Param("uid")String uid);
  58. /**
  59. * 查看客户账户信息
  60. * @param uid
  61. * @return
  62. */
  63. User findUserAccountDetail(@Param("uid")String uid);
  64. /**
  65. * 查看客户联系人列表
  66. * @param uid
  67. * @return
  68. */
  69. List<OrganizationContactBook> findCustomerContacts(@Param("uid")String uid,@Param("aid")String aid);
  70. /**
  71. * 查询拜访详情
  72. * @param followId
  73. * @return
  74. */
  75. FollowBusinessBo findFollowById(String followId);
  76. /**
  77. * 查询单次拜访推进的客户业
  78. * @param followId
  79. * @return
  80. */
  81. List<BusinessListBo> findBusinessByFollowId(String followId);
  82. /**
  83. * 查询客户已有联系人
  84. * @param uid
  85. * @return
  86. */
  87. List<OrganizationContactBook> findAllContacts(String uid);
  88. /**
  89. * 查询用户
  90. * @param id
  91. * @param identifyName 认证用户
  92. * @param mobile 手机号码
  93. * @param type 用户类型 0-个人 1-单位
  94. * @param source 来源 0-注册 1-录入
  95. * @return
  96. * @param nickname 昵称
  97. */
  98. List<User> checkUser(@Param("id")String id,@Param("identifyName")String identifyName, @Param("mobile")String mobile,
  99. @Param("type")Integer type,@Param("source") Integer source,@Param("nickname") String nickname);
  100. List<UserInterestBo> userInterest(String uid);
  101. /**
  102. * 查询用户基本信息
  103. * @param id
  104. * @return
  105. */
  106. UserBasicInfo selectBaseInfo(@Param("id")String id);
  107. /**
  108. * 根据用户编号
  109. * @param easemobName
  110. * @return
  111. */
  112. User selectByNumber(@Param("easemobName")String easemobName);
  113. List<Admin> findAdminName(String aid);
  114. int updateEnteringAudit(@Param("id")String id,@Param("auditStatus")Integer auditStatus,@Param("auditOpinion")String auditOpinion);
  115. int updateRefusedCustomer(@Param("id")String id, @Param("nickname")String nickname, @Param("mobile")String mobile, @Param("societyTag")String societyTag);
  116. /**
  117. * 查看客户锁定的业务
  118. * @param uid 客户ID
  119. * @param aid 管理员ID
  120. * @param businessProjectId 业务项目的ID
  121. * @param type 锁定类型 0-客户 1-业务
  122. * @param status 锁定状态 0-锁定 1-待释放 2-已释放
  123. * @return
  124. */
  125. List<LockingReleaseBo> selectLockedProject(@Param("uid")String uid,@Param("aid")String aid,@Param("businessProjectId")String businessProjectId, @Param("type")Integer type,@Param("status")Integer status);
  126. List<CustomerSimpleBo> selectPrivateCustomerByName(@Param("name")String name,@Param("aid")String aid);
  127. List<CustomerSimpleBo> selectSignedCustomerByName(@Param("name")String name,@Param("aid")String aid,@Param("type")Integer type);
  128. List<User> selectUserByRoleName(@Param("roleName1")String roleName1,@Param("roleName2")String roleName2);
  129. void updateReleaseLock(String time);
  130. marketingESBo marketingStatistics(@Param("id")String id, @Param("dailyStart")String dailyStart, @Param("dailyEnd")String dailyEnd);
  131. marketingESBo marketingDepStatistics(@Param("depId")String depId, @Param("dailyStart")String dailyStart, @Param("dailyEnd")String dailyEnd);
  132. CountMarketingStatisticsBo countmarketingDepStatistics(@Param("depId")String depId, @Param("dailyStart")String dailyStart, @Param("dailyEnd")String dailyEnd);
  133. int checkCustomerInformation(String uid);
  134. void updateDimissionTransfer(@Param("aid")String aid, @Param("transferId")String transferId);
  135. List<userDataListBo> userDataStatistics(@Param("deps")List<String> deps);
  136. userDataListBo userDataStatisticsCount(@Param("deps")List<String> deps);
  137. int UserReceiveCount( @Param("aid")String aid);
  138. int getAidAndUser(@Param("uid")String uid,@Param("aid") String aid);
  139. List<CustomerListOut> privateUnitCustomerList(@Param("params")Map<String, Object> params);
  140. int pushUserGuidance(@Param("id")String id, @Param("guidance")Integer guidance);
  141. /**
  142. *
  143. * @param aid 归属人
  144. * @param level 等级
  145. * @param source 来源
  146. * @param transferTime 转换时间
  147. * @param shareType 私有标示
  148. * @param list 用户id列表
  149. */
  150. void updateList(@Param("aid")String aid,@Param("level")Integer level, @Param("source")Integer source,
  151. @Param("transferTime")Date transferTime,@Param("shareType")Integer shareType,@Param("list")List<String> list,
  152. @Param("data")Integer data);
  153. int checkUserMax(String aid);
  154. int checkLock(@Param("uid")String uid);
  155. void updateShareType(@Param("uid")String uid,@Param("aid")String aid);
  156. String checkRoleMax(String aid);
  157. void insertBatch(List<InputUserChannel> list);
  158. User selectByName(String userName);
  159. int updatechannelCustomerDeliver(@Param("list")List<String> list, @Param("aid")String aid);
  160. void updateReleaseUserChannel(@Param("list")List<userDaysBo> newCList, @Param("type")Integer type);
  161. String checkBeforeChannel(String uid);
  162. List<CustomerSimpleBo> getUserByName(String name);
  163. List<OutUser> getAllUser();
  164. List<CustomerListOut> selectPrivateOrganizationCustomerList(Map<String,Object> map);
  165. List<OutChannelListBo> channelUserList(Map<String, Object> params);
  166. List<AdminCustomerBo> selectNoChannelByaids(@Param("admins")List<AdminCustomerBo> admins,@Param("startTime") String startTime,@Param("endTime") String endTime);
  167. List<AdminCustomerBo> selectChannelByaids(@Param("admins")List<AdminCustomerBo> admins,@Param("startTime") String startTime,@Param("endTime") String endTime);
  168. List<String> selectBelongByaid(String aid);
  169. AdminUserCount selectByaidAndDate(@Param("aid") String aid, @Param("startTime") String startTime,
  170. @Param("endTime")String endTime);
  171. List<AdminUserCount>selectListByaidAndDate(String aid);
  172. List<CustomerSimpleBo> getRestrictCustomerByName(@Param("name") String name, @Param("aid") String aid);
  173. int getCountRestrictProject(@Param("uid") String uid, @Param("aid") String aid);
  174. UserArchivesDetails selectUser(String id);
  175. List<PublicReleaseListBo> getPublicReleaseList(String uid);
  176. void updateUserShareType(List<LockingReleaseBo> newList);
  177. List<LockingReleaseBo > selectSignReleaseUser(String id);
  178. }