UserMapper.java 8.7 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281
  1. package com.goafanti.common.dao;
  2. import java.util.Date;
  3. import java.util.List;
  4. import java.util.Map;
  5. import org.apache.ibatis.annotations.Param;
  6. import com.goafanti.app.bo.UserBasicInfo;
  7. import com.goafanti.common.model.Admin;
  8. import com.goafanti.common.model.OrganizationContactBook;
  9. import com.goafanti.common.model.User;
  10. import com.goafanti.user.bo.OrgPartnerDetailBo;
  11. import com.goafanti.user.bo.UserDownLoadBo;
  12. import com.goafanti.user.bo.UserInterestBo;
  13. import com.goafanti.user.bo.UserPageHomeBo;
  14. import com.goafanti.user.bo.UserPartnerDetailBo;
  15. import com.goafanti.common.model.UserExample;
  16. import com.goafanti.customer.bo.BusinessListBo;
  17. import com.goafanti.customer.bo.CustomerListOut;
  18. import com.goafanti.customer.bo.CustomerOrganizationDetailBo;
  19. import com.goafanti.customer.bo.CustomerPersonalDetailBo;
  20. import com.goafanti.customer.bo.CustomerSimpleBo;
  21. import com.goafanti.customer.bo.FollowBusinessBo;
  22. import com.goafanti.customer.bo.LockingReleaseBo;
  23. import com.goafanti.report.bo.CountMarketingStatisticsBo;
  24. import com.goafanti.report.bo.marketingESBo;
  25. import com.goafanti.report.bo.userDataListBo;
  26. public interface UserMapper {
  27. /**
  28. * This method was generated by MyBatis Generator. This method corresponds to the database table user
  29. * @mbg.generated Tue Jun 26 10:23:14 CST 2018
  30. */
  31. long countByExample(UserExample example);
  32. /**
  33. * This method was generated by MyBatis Generator. This method corresponds to the database table user
  34. * @mbg.generated Tue Jun 26 10:23:14 CST 2018
  35. */
  36. int deleteByExample(UserExample example);
  37. /**
  38. * This method was generated by MyBatis Generator. This method corresponds to the database table user
  39. * @mbg.generated Tue Jun 26 10:23:14 CST 2018
  40. */
  41. int deleteByPrimaryKey(String id);
  42. /**
  43. * This method was generated by MyBatis Generator. This method corresponds to the database table user
  44. * @mbg.generated Tue Jun 26 10:23:14 CST 2018
  45. */
  46. int insert(User record);
  47. /**
  48. * This method was generated by MyBatis Generator. This method corresponds to the database table user
  49. * @mbg.generated Tue Jun 26 10:23:14 CST 2018
  50. */
  51. int insertSelective(User record);
  52. /**
  53. * This method was generated by MyBatis Generator. This method corresponds to the database table user
  54. * @mbg.generated Tue Jun 26 10:23:14 CST 2018
  55. */
  56. List<User> selectByExample(UserExample example);
  57. /**
  58. * This method was generated by MyBatis Generator. This method corresponds to the database table user
  59. * @mbg.generated Tue Jun 26 10:23:14 CST 2018
  60. */
  61. User selectByPrimaryKey(String id);
  62. /**
  63. * This method was generated by MyBatis Generator. This method corresponds to the database table user
  64. * @mbg.generated Tue Jun 26 10:23:14 CST 2018
  65. */
  66. int updateByExampleSelective(@Param("record") User record, @Param("example") UserExample example);
  67. /**
  68. * This method was generated by MyBatis Generator. This method corresponds to the database table user
  69. * @mbg.generated Tue Jun 26 10:23:14 CST 2018
  70. */
  71. int updateByExample(@Param("record") User record, @Param("example") UserExample example);
  72. /**
  73. * This method was generated by MyBatis Generator. This method corresponds to the database table user
  74. * @mbg.generated Tue Jun 26 10:23:14 CST 2018
  75. */
  76. int updateByPrimaryKeySelective(User record);
  77. /**
  78. * This method was generated by MyBatis Generator. This method corresponds to the database table user
  79. * @mbg.generated Tue Jun 26 10:23:14 CST 2018
  80. */
  81. int updateByPrimaryKey(User record);
  82. UserPageHomeBo selectUserPageHomeBoByUserId(String uid);
  83. UserDownLoadBo selectUserDownLoadBoByUserId(String id);
  84. //List<OrgListBo> selectUserByAid(String aid);
  85. String findUserByNameAndMobile(@Param("name") String name, @Param("mobile") String mobile);
  86. String findOrgByNameAndMobile(@Param("name") String name, @Param("mobile") String mobile);
  87. UserPartnerDetailBo findUserPartnerDetail(String uid);
  88. OrgPartnerDetailBo findOrgPartnerDetail(String uid);
  89. Long selectNumberByPrimaryKey(String userId);
  90. List<UserPartnerDetailBo> findUserPartner();
  91. User selectByMobieAndType(String mobile, Integer type);
  92. /**
  93. * 根据客户模糊搜索
  94. * @param name
  95. * @return
  96. */
  97. List<CustomerSimpleBo> findCustomerByName(@Param("identifyName")String identifyName);
  98. /**
  99. * 判断客户是否存在
  100. * @param name
  101. * @return
  102. */
  103. int judgeCustomerByName(@Param("identifyName")String identifyName);
  104. /**
  105. * 查询单位客户详情
  106. * @param uid 用户ID
  107. * @return
  108. */
  109. CustomerPersonalDetailBo findPersonalCustomerDetail(@Param("uid")String uid);
  110. /**
  111. * 查询单位客户详情
  112. * @param uid 用户ID
  113. * @return
  114. */
  115. CustomerOrganizationDetailBo findOrganizationCustomerDetail(@Param("uid")String uid);
  116. /**
  117. * 查看客户账户信息
  118. * @param uid
  119. * @return
  120. */
  121. User findUserAccountDetail(@Param("uid")String uid);
  122. /**
  123. * 查看客户联系人列表
  124. * @param uid
  125. * @return
  126. */
  127. List<OrganizationContactBook> findCustomerContacts(@Param("uid")String uid,@Param("aid")String aid);
  128. /**
  129. * 查询拜访详情
  130. * @param followId
  131. * @return
  132. */
  133. FollowBusinessBo findFollowById(String followId);
  134. /**
  135. * 查询单次拜访推进的客户业
  136. * @param followId
  137. * @return
  138. */
  139. List<BusinessListBo> findBusinessByFollowId(String followId);
  140. /**
  141. * 查询客户已有联系人
  142. * @param uid
  143. * @return
  144. */
  145. List<OrganizationContactBook> findAllContacts(String uid);
  146. /**
  147. * 查询用户
  148. * @param id
  149. * @param identifyName 认证用户
  150. * @param mobile 手机号码
  151. * @param type 用户类型 0-个人 1-单位
  152. * @param source 来源 0-注册 1-录入
  153. * @return
  154. * @param nickname 昵称
  155. */
  156. List<User> checkUser(@Param("id")String id,@Param("identifyName")String identifyName, @Param("mobile")String mobile,
  157. @Param("type")Integer type,@Param("source") Integer source,@Param("nickname") String nickname);
  158. List<UserInterestBo> userInterest(String uid);
  159. /**
  160. * 查询用户基本信息
  161. * @param id
  162. * @return
  163. */
  164. UserBasicInfo selectBaseInfo(@Param("id")String id);
  165. /**
  166. * 根据用户编号
  167. * @param easemobName
  168. * @return
  169. */
  170. User selectByNumber(@Param("easemobName")String easemobName);
  171. List<Admin> findAdminName(String aid);
  172. int updateEnteringAudit(@Param("id")String id,@Param("auditStatus")Integer auditStatus,@Param("auditOpinion")String auditOpinion);
  173. int updateRefusedCustomer(@Param("id")String id, @Param("nickname")String nickname, @Param("mobile")String mobile, @Param("societyTag")String societyTag);
  174. /**
  175. * 查看客户锁定的业务
  176. * @param uid 客户ID
  177. * @param aid 管理员ID
  178. * @param businessProjectId 业务项目的ID
  179. * @param type 锁定类型 0-客户 1-业务
  180. * @param status 锁定状态 0-锁定 1-待释放 2-已释放
  181. * @return
  182. */
  183. List<LockingReleaseBo> selectLockedProject(@Param("uid")String uid,@Param("aid")String aid,@Param("businessProjectId")String businessProjectId, @Param("type")Integer type,@Param("status")Integer status);
  184. List<CustomerSimpleBo> selectPrivateCustomerByName(@Param("name")String name,@Param("aid")String aid);
  185. List<CustomerSimpleBo> selectSignedCustomerByName(@Param("name")String name,@Param("aid")String aid);
  186. List<User> selectUserByRoleName(@Param("roleName1")String roleName1,@Param("roleName2")String roleName2);
  187. void updateReleaseLock(String time);
  188. marketingESBo marketingStatistics(@Param("id")String id, @Param("dailyStart")String dailyStart, @Param("dailyEnd")String dailyEnd);
  189. marketingESBo marketingDepStatistics(@Param("depId")String depId, @Param("dailyStart")String dailyStart, @Param("dailyEnd")String dailyEnd);
  190. CountMarketingStatisticsBo countmarketingDepStatistics(@Param("depId")String depId, @Param("dailyStart")String dailyStart, @Param("dailyEnd")String dailyEnd);
  191. int checkCustomerInformation(String uid);
  192. void updateDimissionTransfer(@Param("aid")String aid, @Param("transferId")String transferId);
  193. List<userDataListBo> userDataStatistics(@Param("depId")String depId);
  194. userDataListBo userDataStatisticsCount(@Param("depId")String depId);
  195. int UserReceiveCount( @Param("aid")String aid);
  196. int getAidAndUser(@Param("uid")String uid,@Param("aid") String aid);
  197. List<CustomerListOut> privateUnitCustomerList(@Param("params")Map<String, Object> params);
  198. int pushUserGuidance(@Param("id")String id, @Param("guidance")Integer guidance);
  199. /**
  200. *
  201. * @param aid 归属人
  202. * @param level 等级
  203. * @param source 来源
  204. * @param transferTime 转换时间
  205. * @param shareType 私有标示
  206. * @param list 用户id列表
  207. */
  208. void updateList(@Param("aid")String aid,@Param("level")Integer level, @Param("source")Integer source,
  209. @Param("transferTime")Date transferTime,@Param("shareType")Integer shareType,@Param("list")List<String> list);
  210. int checkUserMax(String aid);
  211. int checkLock(@Param("uid")String uid);
  212. void updateShareType(@Param("uid")String uid,@Param("aid")String aid);
  213. void updateRelease(String orderNo);
  214. }