UserMapper.java 7.7 KB

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