UserMapper.java 9.0 KB

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