/**
* 查询是否有权限
*/
@GetMapping(API_PREFIX+"/getPermissionLogCount")
@Override
public Integer getPermissionLogCount(String openId
,@RequestParam(value = "tournamentId",required = false,defaultValue = "") String tournamentId
,@RequestParam(value = "applicationType",required = false,defaultValue = "") String applicationType) {
return permissionLogService.count(
new LambdaQueryWrapper<PermissionLog>() //相当于 select count(id)PermissionLog from where getApplicantOpenid = openId and ((getRoleType = "SYSTEM") or (getRoleType = "TOURNAMENT") or (getTournamentId = tournamentId and getApplicationType = applicationType and getIsApproved = “Y” )) .eq(org.springblade.competition.entity.PermissionLog::getApplicantOpenid, openId) .and(
wrapper1 -> wrapper1.eq(org.springblade.competition.entity.PermissionLog::getRoleType,"SYSTEM")
// 赛事创建者
.or(wrapper -> wrapper.eq(org.springblade.competition.entity.PermissionLog::getRoleType,"TOURNAMENT")
.eq(org.springblade.competition.entity.PermissionLog::getTournamentId,tournamentId)
)
// TOURNAMENT/ACCOUNT/ALBUM
.or(w->w.eq(org.springblade.competition.entity.PermissionLog::getTournamentId,tournamentId)
.eq (org.springblade.competition.entity.PermissionLog::getApplicationType, applicationType)
.eq(org.springblade.competition.entity.PermissionLog::getIsApproved,"Y")
)
)
);
}
mybatis plus中or和and的使用
最新推荐文章于 2025-03-07 22:12:17 发布