KuaishouPromoterMapper.java 6.0 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146
  1. package com.ruixuan.isc.mapper;
  2. import com.alibaba.fastjson.JSONObject;
  3. import com.ruixuan.isc.entity.JYKuaishouPromoter;
  4. import com.ruixuan.isc.entity.KuaishouPromoter;
  5. import org.apache.ibatis.annotations.Param;
  6. import java.util.List;
  7. public interface KuaishouPromoterMapper {
  8. /**
  9. * 查询快手达人 信息
  10. *
  11. * @param id 快手达人 信息主键
  12. * @return 快手达人 信息
  13. */
  14. public KuaishouPromoter selectKuaishouPromoterById(Long id);
  15. /**
  16. * 查询快手达人 信息列表
  17. *
  18. * @param kuaishouPromoter 快手达人 信息
  19. * @return 快手达人 信息集合
  20. */
  21. public List<KuaishouPromoter> selectKuaishouPromoterList(@Param("userList") List<Long> userList, @Param("promoterId") String promoterId,
  22. @Param("promoterNickName") String promoterNickName,
  23. @Param("mediaId") String mediaId,
  24. @Param("parameter") String parameter, @Param("orderBy") String orderBy,
  25. @Param("bdUserId") Long bdUserId);
  26. public List<JYKuaishouPromoter> selectKuaishouPromoterList3(@Param("userList") List<Long> userList, @Param("promoterId") String promoterId,
  27. @Param("promoterNickName") String promoterNickName,
  28. @Param("mediaId") String mediaId,
  29. @Param("type") String type,
  30. @Param("parameter") String parameter, @Param("orderBy") String orderBy,
  31. @Param("expertMentorId") Long expertMentorId, @Param("expertBusinessId") Long expertBusinessId
  32. );
  33. /**
  34. * 新增快手达人 信息
  35. *
  36. * @param kuaishouPromoter 快手达人 信息
  37. * @return 结果
  38. */
  39. public int insertKuaishouPromoter(KuaishouPromoter kuaishouPromoter);
  40. /**
  41. * 修改快手达人 信息
  42. *
  43. * @param kuaishouPromoter 快手达人 信息
  44. * @return 结果
  45. */
  46. public int updateKuaishouPromoter(KuaishouPromoter kuaishouPromoter);
  47. /**
  48. * 删除快手达人 信息
  49. *
  50. * @param id 快手达人 信息主键
  51. * @return 结果
  52. */
  53. public int deleteKuaishouPromoterById(Long id);
  54. /**
  55. * 批量删除快手达人 信息
  56. *
  57. * @param ids 需要删除的数据主键集合
  58. * @return 结果
  59. */
  60. public int deleteKuaishouPromoterByIds(Long[] ids);
  61. KuaishouPromoter getOneByIdAndPromoterId(@Param("userId") Long userId, @Param("promoterId") String promoterId);
  62. JSONObject getNearlyMonthGmv(@Param("promoterId") String promoterId, @Param("start") String start, @Param("end") String end);
  63. void insertKuaishouPromoterRecord(JSONObject record);
  64. List<String> selectPromoterIdList(@Param("userList") List<Long> userList, @Param("mediaId") String mediaId);
  65. JSONObject getgetMonthPromoterTotal(@Param("userList") List<Long> userList, @Param("start") String start, @Param("end") String end, @Param("mediaId") String mediaId);
  66. void updateKuaishouPromoterByPromoterId(KuaishouPromoter promoters);
  67. List<JSONObject> selectAllPromoterList(@Param("userId") Long userId, @Param("promoterId") String promoterId, @Param("promoterNickName") String promoterNickName, @Param("status") String status, @Param("parameter") String parameter, @Param("orderBy") String orderBy);
  68. List<KuaishouPromoter> getFailInfo();
  69. List<JSONObject> getBoundPromoterRoleKey(@Param("promoterId") String promoterId);
  70. int addFollowUpRecords(@Param("result") JSONObject result);
  71. void updateFollowUpRecords(@Param("result") JSONObject result);
  72. JSONObject getFollowUpRecordsByUserId(@Param("promoterId") String promoterId, @Param("userId") Long userId);
  73. List<JSONObject> getFollowUpRecordListByPromoterId(@Param("promoterId") String promoterId, @Param("id") Long id);
  74. int deletePromoterLabel(@Param("promoterId") String promoterId, @Param("userId") Long userId);
  75. void insertPromoterLabels(@Param("list") List<JSONObject> list);
  76. List<JSONObject> getPromoterLabel(@Param("promoterId") String promoterId, @Param("userId") Long userId);
  77. KuaishouPromoter getOnlyPromoterInfoByUserId(@Param("promoterId") String promoterId, @Param("userId") Long userId);
  78. Integer getUserPromotersCount(@Param("userId") Long userId, @Param("mediaId") String mediaId);
  79. Integer getBoundCount(@Param("userId") Long userId);
  80. Integer addPromotersCount(@Param("userId") Long userId, @Param("promotersCount") Long promotersCount, @Param("mediaId") String mediaId);
  81. String getRuleName(@Param("ruleId") Long ruleId);
  82. int addRule(@Param("promoterId") String promoterId, @Param("ruleId") Long ruleId, @Param("ruleName") String ruleName);
  83. List<String> selectPromoterIdListByTime(@Param("userList") List<Long> userList, @Param("startDate") Long startDate, @Param("endDate") Long endDate);
  84. KuaishouPromoter getOneByIdAndPromoterId3(@Param("userId") Long userId, @Param("promoterId") String promoterId);
  85. void insertKuaishouPromoter3(JYKuaishouPromoter promoter);
  86. void updateKuaishouPromoterByPromoterId3(JYKuaishouPromoter kuaishouPromoter);
  87. int updateKuaishouPromoter3(JYKuaishouPromoter kuaishouPromoter);
  88. JYKuaishouPromoter selectKuaishouPromoterById3(Long id);
  89. void deleteKuaishouPromoterById3(Long id);
  90. List<JYKuaishouPromoter> getFailInfo3();
  91. JSONObject selectKuaishouRulePromoterById(@Param("promoterId") Long promoterId);
  92. List<JSONObject> jyExpertMentorList();
  93. List<JSONObject> jyExpertBusiness();
  94. List<JYKuaishouPromoter> getMiaogousiInfoFailInfo();
  95. void updateMiaogousiKuaishouPromoterByPromoterId(KuaishouPromoter kuaishouPromoter);
  96. List<JYKuaishouPromoter> getRocketFailInfo();
  97. void updateRocketKuaishouPromoterByPromoterId(KuaishouPromoter kuaishouPromoter);
  98. }