MessageFromSystemMapper.java 4.7 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163
  1. package com.goafanti.common.dao;
  2. import com.goafanti.common.model.MessageConsumer;
  3. import com.goafanti.common.model.MessageFromSystem;
  4. import com.goafanti.common.model.MessageFromSystemExample;
  5. import com.goafanti.common.model.MessageProducer;
  6. import com.goafanti.message.bo.MessageBo;
  7. import java.util.Date;
  8. import java.util.List;
  9. import org.apache.ibatis.annotations.Param;
  10. public interface MessageFromSystemMapper {
  11. /**
  12. * This method was generated by MyBatis Generator.
  13. * This method corresponds to the database table message_from_system
  14. *
  15. * @mbg.generated Thu Dec 14 21:04:23 CST 2017
  16. */
  17. long countByExample(MessageFromSystemExample example);
  18. /**
  19. * This method was generated by MyBatis Generator.
  20. * This method corresponds to the database table message_from_system
  21. *
  22. * @mbg.generated Thu Dec 14 21:04:23 CST 2017
  23. */
  24. int deleteByExample(MessageFromSystemExample example);
  25. /**
  26. * This method was generated by MyBatis Generator.
  27. * This method corresponds to the database table message_from_system
  28. *
  29. * @mbg.generated Thu Dec 14 21:04:23 CST 2017
  30. */
  31. int deleteByPrimaryKey(String id);
  32. /**
  33. * This method was generated by MyBatis Generator.
  34. * This method corresponds to the database table message_from_system
  35. *
  36. * @mbg.generated Thu Dec 14 21:04:23 CST 2017
  37. */
  38. int insert(MessageFromSystem record);
  39. /**
  40. * This method was generated by MyBatis Generator.
  41. * This method corresponds to the database table message_from_system
  42. *
  43. * @mbg.generated Thu Dec 14 21:04:23 CST 2017
  44. */
  45. int insertSelective(MessageFromSystem record);
  46. /**
  47. * This method was generated by MyBatis Generator.
  48. * This method corresponds to the database table message_from_system
  49. *
  50. * @mbg.generated Thu Dec 14 21:04:23 CST 2017
  51. */
  52. List<MessageFromSystem> selectByExample(MessageFromSystemExample example);
  53. /**
  54. * This method was generated by MyBatis Generator.
  55. * This method corresponds to the database table message_from_system
  56. *
  57. * @mbg.generated Thu Dec 14 21:04:23 CST 2017
  58. */
  59. MessageFromSystem selectByPrimaryKey(String id);
  60. /**
  61. * This method was generated by MyBatis Generator.
  62. * This method corresponds to the database table message_from_system
  63. *
  64. * @mbg.generated Thu Dec 14 21:04:23 CST 2017
  65. */
  66. int updateByExampleSelective(@Param("record") MessageFromSystem record, @Param("example") MessageFromSystemExample example);
  67. /**
  68. * This method was generated by MyBatis Generator.
  69. * This method corresponds to the database table message_from_system
  70. *
  71. * @mbg.generated Thu Dec 14 21:04:23 CST 2017
  72. */
  73. int updateByExample(@Param("record") MessageFromSystem record, @Param("example") MessageFromSystemExample example);
  74. /**
  75. * This method was generated by MyBatis Generator.
  76. * This method corresponds to the database table message_from_system
  77. *
  78. * @mbg.generated Thu Dec 14 21:04:23 CST 2017
  79. */
  80. int updateByPrimaryKeySelective(MessageFromSystem record);
  81. /**
  82. * This method was generated by MyBatis Generator.
  83. * This method corresponds to the database table message_from_system
  84. *
  85. * @mbg.generated Thu Dec 14 21:04:23 CST 2017
  86. */
  87. int updateByPrimaryKey(MessageFromSystem record);
  88. /**
  89. * 查询发送目标
  90. * @param sql
  91. * @return
  92. */
  93. String selectSendTarget(@Param("sql")String sql);
  94. /**
  95. *
  96. * @param target
  97. * @return
  98. */
  99. int insertBatchMessage(List<MessageFromSystem> target);
  100. /**
  101. *
  102. * @param target
  103. */
  104. int insertBatchProducer(List<MessageProducer> target);
  105. /**
  106. *
  107. * @param target
  108. * @return
  109. */
  110. int insertBatchConsumer(List<MessageConsumer> target);
  111. /**
  112. * 查询单个用户的未发消息
  113. * @param uid
  114. * @return
  115. */
  116. List<MessageBo> selectSendMessage(@Param("uid")String uid);
  117. /**
  118. * 绑定第三方账号
  119. * @param uuid
  120. * @param registrationId
  121. * @param userName
  122. * @param uid
  123. * @return
  124. */
  125. int updateJpushEasemobAccount(@Param("uuid")String uuid, @Param("registrationId")String registrationId,
  126. @Param("userName")String userName, @Param("uid")String uid);
  127. /**
  128. * 把消息置为已读
  129. * @param messageId
  130. * @param uid
  131. * @param readTime
  132. * @return
  133. */
  134. int updateMessageConsumer(@Param("messageId")String messageId, @Param("uid")String uid,@Param("readTime")Date readTime);
  135. /**
  136. * 查询推荐目标
  137. * @param sql
  138. * @return
  139. */
  140. List<MessageFromSystem> selectRecommendTarget(@Param("sql")String sql);
  141. }