| 程序包 | 说明 |
|---|---|
| io.xiaper.jpa.model | |
| io.xiaper.jpa.repository |
| 限定符和类型 | 方法和说明 |
|---|---|
User |
User.getAdmin()
获取客服账号的管理员
|
User |
WorkGroup.getAdmin() |
User |
Thread.getAgent() |
User |
Rate.getAgent() |
User |
Queue.getAgent() |
User |
LeaveMessage.getAgent() |
User |
Block.getBlockedUser() |
User |
LeaveMessage.getClaimer() |
User |
Thread.getContact() |
User |
Transfer.getFromUser() |
User |
Invite.getFromUser() |
User |
BrowseInvite.getFromUser() |
User |
User.getRoBotUser() |
User |
Transfer.getToUser() |
User |
Invite.getToUser() |
User |
BrowseInvite.getToUser() |
User |
Cuw.getUser() |
User |
Block.getUser() |
User |
AnswerQuery.getUser() |
User |
App.getUser() |
User |
PayFeature.getUser() |
User |
Setting.getUser() |
User |
Company.getUser() |
User |
AnswerRate.getUser() |
User |
Rate.getUser() |
User |
Notice.getUser() |
User |
Comment.getUser() |
User |
WeChat.getUser() |
User |
ArticleRate.getUser() |
User |
Robot.getUser() |
User |
User.getUser() |
User |
StatisticDetail.getUser() |
User |
Statistic.getUser() |
User |
Synonym.getUser() |
User |
Category.getUser() |
User |
Subscribe.getUser() |
User |
QuestionnaireItemItem.getUser() |
User |
QuestionnaireAnswer.getUser() |
User |
Department.getUser() |
User |
WeChatUserInfo.getUser() |
User |
Article.getUser() |
User |
Taboo.getUser() |
User |
Payment.getUser() |
User |
Tag.getUser() |
User |
WorkGroup.getUser() |
User |
QuestionnaireItem.getUser() |
User |
Group.getUser() |
User |
WeChatMenu.getUser() |
User |
ArticleRead.getUser() |
User |
MessageStatus.getUser() |
User |
Feedback.getUser() |
User |
Questionnaire.getUser() |
User |
Status.getUser() |
User |
Answer.getUser() |
User |
Message.getUser() |
User |
Post.getUser() |
User |
Thread.getVisitor() |
User |
FingerPrint2.getVisitor() |
User |
Rate.getVisitor() |
User |
Queue.getVisitor() |
User |
LeaveMessage.getVisitor() |
User |
Browse.getVisitor() |
User |
Feedback.getVisitor() |
| 限定符和类型 | 方法和说明 |
|---|---|
Set<User> |
Group.getAdmins() |
Set<User> |
Thread.getAgents() |
Set<User> |
Thread.getDeletedSet() |
Set<User> |
Message.getDeletedSet() |
Set<User> |
Thread.getDisturbSet() |
Set<User> |
User.getFans() |
Set<User> |
User.getFollows() |
Set<User> |
Group.getMembers() |
Set<User> |
Group.getMuted() |
Set<User> |
Notice.getReaders() |
Set<User> |
User.getRobots() |
Set<User> |
Thread.getTopSet() |
Set<User> |
Thread.getUnreadSet() |
Set<User> |
Role.getUsers() |
Set<User> |
Authority.getUsers() |
Set<User> |
Notice.getUsers() |
Set<User> |
Tag.getUsers() |
Set<User> |
WorkGroup.getUsers() |
| 限定符和类型 | 方法和说明 |
|---|---|
boolean |
Thread.isDeleted(User user) |
boolean |
Thread.isTop(User user) |
boolean |
Thread.isUnread(User user) |
void |
WorkGroup.setAdmin(User admin) |
void |
Thread.setAgent(User agent) |
void |
Rate.setAgent(User agent) |
void |
Queue.setAgent(User agent) |
void |
LeaveMessage.setAgent(User agent) |
void |
Block.setBlockedUser(User blockedUser) |
void |
LeaveMessage.setClaimer(User claimer) |
void |
Thread.setContact(User contact) |
void |
Transfer.setFromUser(User fromUser) |
void |
Invite.setFromUser(User fromUser) |
void |
BrowseInvite.setFromUser(User fromUser) |
void |
Transfer.setToUser(User toUser) |
void |
Invite.setToUser(User toUser) |
void |
BrowseInvite.setToUser(User toUser) |
void |
Cuw.setUser(User user) |
void |
Block.setUser(User user) |
void |
AnswerQuery.setUser(User user) |
void |
App.setUser(User user) |
void |
PayFeature.setUser(User user) |
void |
Setting.setUser(User user) |
void |
Company.setUser(User user) |
void |
AnswerRate.setUser(User user) |
void |
Rate.setUser(User user) |
void |
Notice.setUser(User user) |
void |
Comment.setUser(User user) |
void |
WeChat.setUser(User user) |
void |
ArticleRate.setUser(User user) |
void |
Robot.setUser(User user) |
void |
User.setUser(User user) |
void |
StatisticDetail.setUser(User user) |
void |
Statistic.setUser(User user) |
void |
Synonym.setUser(User user) |
void |
Category.setUser(User user) |
void |
Subscribe.setUser(User user) |
void |
QuestionnaireItemItem.setUser(User user) |
void |
QuestionnaireAnswer.setUser(User user) |
void |
Department.setUser(User user) |
void |
WeChatUserInfo.setUser(User user) |
void |
Article.setUser(User user) |
void |
Taboo.setUser(User user) |
void |
Payment.setUser(User user) |
void |
Tag.setUser(User user) |
void |
WorkGroup.setUser(User user) |
void |
QuestionnaireItem.setUser(User user) |
void |
Group.setUser(User user) |
void |
WeChatMenu.setUser(User user) |
void |
ArticleRead.setUser(User user) |
void |
MessageStatus.setUser(User user) |
void |
Feedback.setUser(User user) |
void |
Questionnaire.setUser(User user) |
void |
Status.setUser(User user) |
void |
Answer.setUser(User user) |
void |
Message.setUser(User user) |
void |
Post.setUser(User user) |
void |
Thread.setVisitor(User visitor) |
void |
FingerPrint2.setVisitor(User visitor) |
void |
Rate.setVisitor(User visitor) |
void |
Queue.setVisitor(User visitor) |
void |
LeaveMessage.setVisitor(User visitor) |
void |
Browse.setVisitor(User visitor) |
void |
Feedback.setVisitor(User visitor) |
| 限定符和类型 | 方法和说明 |
|---|---|
void |
Group.setAdmins(Set<User> admins) |
void |
Thread.setAgents(Set<User> agents) |
void |
Thread.setDeletedSet(Set<User> deletedSet) |
void |
Message.setDeletedSet(Set<User> deletedSet) |
void |
Thread.setDisturbSet(Set<User> disturbSet) |
void |
User.setFans(Set<User> fans) |
void |
User.setFollows(Set<User> follows) |
void |
Group.setMembers(Set<User> members) |
void |
Group.setMuted(Set<User> muted) |
void |
Notice.setReaders(Set<User> readers) |
void |
User.setRobots(Set<User> robots) |
void |
Thread.setTopSet(Set<User> topSet) |
void |
Thread.setUnreadSet(Set<User> unreadSet) |
void |
Role.setUsers(Set<User> users) |
void |
Authority.setUsers(Set<User> users) |
void |
Notice.setUsers(Set<User> users) |
void |
Tag.setUsers(Set<User> users) |
void |
WorkGroup.setUsers(Set<User> users) |
| 构造器和说明 |
|---|
User(User user) |
| 限定符和类型 | 方法和说明 |
|---|---|
Optional<User> |
UserRepository.findByEmail(String email) |
Optional<User> |
UserRepository.findByMobile(String mobile) |
Optional<User> |
UserRepository.findByRealName(String realName) |
List<User> |
UserRepository.findByRolesContains(Role role) |
List<User> |
UserRepository.findByRolesNotContains(Role role) |
org.springframework.data.domain.Page<User> |
UserRepository.findBySubDomainAndConnectionStatusAndAcceptStatus(String subDomain,
String connectionStatus,
String acceptStatus,
org.springframework.data.domain.Pageable pageable) |
org.springframework.data.domain.Page<User> |
UserRepository.findBySubDomainAndConnectionStatusAndRolesNotContains(String subDomain,
String connectionStatus,
Role role,
org.springframework.data.domain.Pageable pageable) |
Optional<User> |
UserRepository.findBySubDomainAndRolesContains(String subDomain,
Role role) |
Optional<User> |
UserRepository.findByUid(String uid) |
List<User> |
UserRepository.findByUser(User user) |
org.springframework.data.domain.Page<User> |
UserRepository.findByUser(User user,
org.springframework.data.domain.Pageable pageable) |
org.springframework.data.domain.Page<User> |
UserRepository.findByUserAndConnectionStatusAndAcceptStatus(User user,
String connectionStatus,
String acceptStatus,
org.springframework.data.domain.Pageable pageable) |
List<User> |
UserRepository.findByUserAndRolesNotContains(User user,
Role role) |
Optional<User> |
UserRepository.findByUserAndUsername(User user,
String username) |
Optional<User> |
UserRepository.findByUsername(String username) |
Optional<User> |
UserRepository.findByUsernameAndSubDomain(String username,
String subDomain) |
List<User> |
UserRepository.findByUserOrUsername(User user,
String username) |
org.springframework.data.domain.Page<User> |
UserRepository.findByUserOrUsername(User user,
String username,
org.springframework.data.domain.Pageable pageable) |
org.springframework.data.domain.Page<User> |
UserRepository.findByUserOrUsernameAndRolesNotContains(User user,
String username,
Role role,
org.springframework.data.domain.Pageable pageable) |
List<User> |
UserRepository.findByWorkGroupsContains(WorkGroup workGroup) |
| 限定符和类型 | 方法和说明 |
|---|---|
Long |
ThreadRepository.countByAgentsContainsAndClosed(User agent,
boolean closed) |
void |
SubscribeRepository.deleteByUser(User user) |
org.springframework.data.domain.Page<Queue> |
QueueRepository.findByAgent_User(User user,
org.springframework.data.domain.Pageable pageable) |
org.springframework.data.domain.Page<Rate> |
RateRepository.findByAgent(User user,
org.springframework.data.domain.Pageable pageable) |
org.springframework.data.domain.Page<LeaveMessage> |
LeaveMessageRepository.findByAgent(User user,
org.springframework.data.domain.Pageable pageable) |
List<Thread> |
ThreadRepository.findByAgentAndClosed(User agent,
boolean closed) |
List<Thread> |
ThreadRepository.findByAgentAndTypeAndDeletedSetNotContains(User agent,
String type,
User user) |
org.springframework.data.domain.Page<Rate> |
RateRepository.findByAgentOrAgent_User(User user1,
User user2,
org.springframework.data.domain.Pageable pageable) |
org.springframework.data.domain.Page<Thread> |
ThreadRepository.findByAgentsContainsAndClosed(User agent,
boolean closed,
org.springframework.data.domain.Pageable pageable) |
Optional<AnswerRate> |
AnswerRateRepository.findByAnswerAndUser(Answer answer,
User user) |
Optional<ArticleRate> |
ArticleRateRepository.findByArticleAndUser(Article article,
User user) |
Optional<Block> |
BlockRepository.findByBlockedUser(User user) |
org.springframework.data.domain.Page<Message> |
MessageRepository.findByCidAndUserOrCidAndUserAndDeletedSetNotContains(String cid1,
User user1,
String cid2,
User user2,
User user3,
org.springframework.data.domain.Pageable pageable) |
org.springframework.data.domain.Page<LeaveMessage> |
LeaveMessageRepository.findByClaimer(User claimer,
org.springframework.data.domain.Pageable pageable) |
Optional<WorkGroup> |
WorkGroupRepository.findByCompanyAndUserAndNickname(Company company,
User user,
String nickname) |
Optional<StatisticDetail> |
StatisticDetailRepository.findByDateAndHourAndTimeTypeAndDimensionTypeAndUser(Date date,
int hour,
String timeType,
String dimensionType,
User user) |
Optional<Statistic> |
StatisticRepository.findByDateAndHourAndTypeAndUser(Date date,
int hour,
String type,
User user) |
org.springframework.data.domain.Page<StatisticDetail> |
StatisticDetailRepository.findByDateAndTimeTypeAndUser_User(Date date,
String timeType,
User user,
org.springframework.data.domain.Pageable pageable) |
List<StatisticDetail> |
StatisticDetailRepository.findByDateAndTimeTypeAndUser(Date date,
String timeType,
User user) |
org.springframework.data.domain.Page<StatisticDetail> |
StatisticDetailRepository.findByDateAndTimeTypeAndUser(Date date,
String timeType,
User user,
org.springframework.data.domain.Pageable pageable) |
List<Statistic> |
StatisticRepository.findByDateAndTypeAndUser(Date date,
String type,
User user) |
List<Group> |
GroupRepository.findByDismissedAndMembersContains(boolean dismissed,
User user) |
List<Message> |
MessageRepository.findByGidAndDeletedSetNotContains(String gid,
User user) |
org.springframework.data.domain.Page<Message> |
MessageRepository.findByGidAndDeletedSetNotContains(String gid,
User user,
org.springframework.data.domain.Pageable pageable) |
List<Thread> |
ThreadRepository.findByGroup_MembersContainsAndGroup_DismissedAndType(User user,
boolean dismissed,
String type) |
Optional<Status> |
StatusRepository.findByStatusAndSessionIdAndClientAndUser(String status,
String sessionId,
String client,
User user) |
org.springframework.data.domain.Page<Rate> |
RateRepository.findByThread_AgentsContains(User user,
org.springframework.data.domain.Pageable pageable) |
org.springframework.data.domain.Page<Message> |
MessageRepository.findByThread_VisitorAndDeletedSetNotContains(User visitor,
User user,
org.springframework.data.domain.Pageable pageable) |
org.springframework.data.domain.Page<Message> |
MessageRepository.findByThread_WorkGroup_User(User user,
org.springframework.data.domain.Pageable pageable) |
org.springframework.data.domain.Page<Rate> |
RateRepository.findByThread_WorkGroup_User(User user,
org.springframework.data.domain.Pageable pageable) |
org.springframework.data.domain.Page<Rate> |
RateRepository.findByThread_WorkGroup_UsersContains(User user,
org.springframework.data.domain.Pageable pageable) |
List<Message> |
MessageRepository.findByThreadAndDeletedSetNotContains(Thread thread,
User user) |
org.springframework.data.domain.Page<Thread> |
ThreadRepository.findByTimestampAfterAndAgentsContains(Date timestamp,
User agent,
org.springframework.data.domain.Pageable pageable)
找出某个客服*时间至现在的所有会话
|
Optional<Thread> |
ThreadRepository.findByTypeAndAgentsContainsAndAgentsContains(String type,
User agent1,
User agent2)
查询一对一会话的thread
|
Set<Category> |
CategoryRepository.findByTypeAndUser(String type,
User user) |
List<Subscribe> |
SubscribeRepository.findByUser(User user) |
List<User> |
UserRepository.findByUser(User user) |
List<Synonym> |
SynonymRepository.findByUser(User user) |
List<WorkGroup> |
WorkGroupRepository.findByUser(User user) |
Set<Cuw> |
CuwRepository.findByUser(User user) |
org.springframework.data.domain.Page<Block> |
BlockRepository.findByUser(User user,
org.springframework.data.domain.Pageable pageable) |
org.springframework.data.domain.Page<User> |
UserRepository.findByUser(User user,
org.springframework.data.domain.Pageable pageable) |
org.springframework.data.domain.Page<WorkGroup> |
WorkGroupRepository.findByUser(User user,
org.springframework.data.domain.Pageable pageable) |
org.springframework.data.domain.Page<Company> |
CompanyRepository.findByUser(User user,
org.springframework.data.domain.Pageable pageable) |
org.springframework.data.domain.Page<Article> |
ArticleRepository.findByUser(User user,
org.springframework.data.domain.Pageable pageable) |
org.springframework.data.domain.Page<Cuw> |
CuwRepository.findByUser(User user,
org.springframework.data.domain.Pageable pageable) |
org.springframework.data.domain.Page<Rate> |
RateRepository.findByUser(User user,
org.springframework.data.domain.Pageable pageable) |
Optional<Block> |
BlockRepository.findByUserAndBlockedUser(User user,
User blockedUser) |
org.springframework.data.domain.Page<User> |
UserRepository.findByUserAndConnectionStatusAndAcceptStatus(User user,
String connectionStatus,
String acceptStatus,
org.springframework.data.domain.Pageable pageable) |
org.springframework.data.domain.Page<WeChat> |
WeChatRepository.findByUserAndMiniProgram(User user,
boolean isMiniProgram,
org.springframework.data.domain.Pageable pageable) |
Optional<WorkGroup> |
WorkGroupRepository.findByUserAndNickname(User user,
String nickname) |
Set<Category> |
CategoryRepository.findByUserAndParent(User user,
Category parent) |
List<Article> |
ArticleRepository.findByUserAndRecommend(User user,
boolean recommend) |
org.springframework.data.domain.Page<Answer> |
AnswerRepository.findByUserAndRelated(User user,
boolean related,
org.springframework.data.domain.Pageable pageable) |
List<Tag> |
TagRepository.findByUserAndRobot(User user,
boolean robot) |
List<User> |
UserRepository.findByUserAndRolesNotContains(User user,
Role role) |
org.springframework.data.domain.Page<Taboo> |
TabooRepository.findByUserAndSynonym(User user,
boolean synonym,
org.springframework.data.domain.Pageable pageable) |
org.springframework.data.domain.Page<Synonym> |
SynonymRepository.findByUserAndSynonym(User user,
boolean synonym,
org.springframework.data.domain.Pageable pageable) |
org.springframework.data.domain.Page<App> |
AppRepository.findByUserAndType(User user,
String type,
org.springframework.data.domain.Pageable pageable) |
Set<Category> |
CategoryRepository.findByUserAndTypeAndParent(User user,
String type,
Category category) |
Optional<User> |
UserRepository.findByUserAndUsername(User user,
String username) |
org.springframework.data.domain.Page<Status> |
StatusRepository.findByUserOrUser_User(User user,
User admin,
org.springframework.data.domain.Pageable pageable) |
List<User> |
UserRepository.findByUserOrUsername(User user,
String username) |
org.springframework.data.domain.Page<User> |
UserRepository.findByUserOrUsername(User user,
String username,
org.springframework.data.domain.Pageable pageable) |
org.springframework.data.domain.Page<User> |
UserRepository.findByUserOrUsernameAndRolesNotContains(User user,
String username,
Role role,
org.springframework.data.domain.Pageable pageable) |
List<WorkGroup> |
WorkGroupRepository.findByUsersContains(User user) |
org.springframework.data.domain.Page<Notice> |
NoticeRepository.findByUsersContains(User user,
org.springframework.data.domain.Pageable pageable) |
List<FingerPrint2> |
FingerPrint2Repository.findByVisitor(User visitor) |
org.springframework.data.domain.Page<Thread> |
ThreadRepository.findByVisitor(User visitor,
org.springframework.data.domain.Pageable pageable) |
List<Thread> |
ThreadRepository.findByVisitorAndClosed(User visitor,
boolean closed) |
Optional<FingerPrint2> |
FingerPrint2Repository.findByVisitorAndKeyAndSystem(User visitor,
String key,
boolean system) |
Set<FingerPrint2> |
FingerPrint2Repository.findByVisitorAndKeyIn(User visitor,
Set<String> keys) |
List<Thread> |
ThreadRepository.findByVisitorAndSessionIdAndClosed(User visitor,
String sessionId,
boolean closed) |
List<Queue> |
QueueRepository.findByVisitorAndStatus(User user,
String status) |
Set<FingerPrint2> |
FingerPrint2Repository.findByVisitorAndSystem(User visitor,
boolean system) |
org.springframework.data.domain.Page<Browse> |
BrowseRepository.findByWorkGroup_UserAndActioned(User user,
String actioned,
org.springframework.data.domain.Pageable pageable) |
org.springframework.data.domain.Page<Browse> |
BrowseRepository.findByWorkGroup_UserAndActionedNotNull(User user,
org.springframework.data.domain.Pageable pageable) |
org.springframework.data.domain.Page<Thread> |
ThreadRepository.findByWorkGroup_UserAndClosedAndAgentNotNull(User user,
boolean closed,
org.springframework.data.domain.Pageable pageable) |
org.springframework.data.domain.Page<Thread> |
ThreadRepository.findByWorkGroup_UserAndClosedAndAgentNotNullOrAgentOrAgent_User(User user,
boolean closed,
User user1,
User user2,
org.springframework.data.domain.Pageable pageable) |
org.springframework.data.domain.Page<Thread> |
ThreadRepository.findByWorkGroup_UsersContainsAndClosedAndWorkGroup_AdminAndAgentNotNull(User user,
boolean closed,
User admin,
org.springframework.data.domain.Pageable pageable) |
org.springframework.data.domain.Page<Queue> |
QueueRepository.findByWorkGroup_UsersContainsAndStatus(User user,
String status,
org.springframework.data.domain.Pageable pageable) |
Optional<Thread> |
ThreadRepository.findFirstByContactAndAgent(User contact,
User agent) |
Optional<FingerPrint2> |
FingerPrint2Repository.findFirstByKeyAndVisitor(String key,
User visitor) |
Optional<Browse> |
BrowseRepository.findFirstBySessionIdAndVisitor(String sessionId,
User user) |
Optional<Subscribe> |
SubscribeRepository.findFirstByThreadAndUser(Thread thread,
User user) |
Optional<App> |
AppRepository.findFirstByUser(User user) |
Optional<Answer> |
AnswerRepository.findFirstByUserAndQuestionContainingOrAnswerContaining(User user,
String question,
String answer)
FIXME: and or 执行顺序有问题,实际执行的是 (user and question) or answer, 而需要的是 user and ( question or answer)
|
Optional<Status> |
StatusRepository.findFirstByUserOrderByIdDesc(User user) |
Optional<Thread> |
ThreadRepository.findFirstByVisitorAndAgentAndAppointedAndClosed(User visitor,
User agent,
boolean appointed,
boolean closed) |
Optional<Queue> |
QueueRepository.findFirstByVisitorAndAgentAndStatus(User user,
User agent,
String status) |
Optional<Thread> |
ThreadRepository.findFirstByVisitorAndWorkGroupAndAppointedAndClosed(User visitor,
WorkGroup workGroup,
boolean appointed,
boolean closed) |
Optional<Queue> |
QueueRepository.findFirstByVisitorAndWorkGroupAndStatus(User user,
WorkGroup workGroup,
String status) |
Set<Answer> |
AnswerRepository.findTop5ByUserAndRelatedOrderByQueryCountDesc(User user,
boolean related) |
Copyright © 2019. All rights reserved.