private List<MenuEntity> findMenuByType(MenuTypeEnum typeEnum) { QMenuEntity entity = QMenuEntity.menuEntity; BooleanExpression ex = entity.status.eq(StatusEnum.STATUS_VALID); if(typeEnum!=null){ ex = ex.and(entity.type.eq(typeEnum)); } JPAQuery query = new JPAQuery(entityManager); List<MenuEntity> list = query.from(entity) .where( ex ) .list(entity); return list; }
@Override public List<MirrorPropertyEntity> findByTypeEnumAndIsEnable(MTypeEnum typeEnum, boolean isEnable) { JPAQuery query = new JPAQuery(entityManager); QMirrorPropertyEntity mirrorProperty = new QMirrorPropertyEntity("mpro"); List<MirrorPropertyEntity> list = query.from(mirrorProperty) .where(mirrorProperty.metaProperty.typeEnum.eq(typeEnum) .and(mirrorProperty.metaProperty.isEnable.eq(isEnable)) ) .list(mirrorProperty); return list; }
private List<MenuEntity> findUserMenuByType(MenuTypeEnum typeEnum, List<RoleEntity> roleList) { QUrlResourcesEntity entity = QUrlResourcesEntity.urlResourcesEntity; BooleanExpression ex = entity.belongRole.isNotNull(); if(roleList != null) { ex = entity.belongRole.in(roleList); } if(typeEnum!=null){ ex = ex.and(entity.menu.type.eq(typeEnum)); } JPAQuery query = new JPAQuery(entityManager); List<UrlResourcesEntity> list = query.from(entity) .where( ex ) .list(entity); List<MenuEntity> menuList = new ArrayList<>(); for (UrlResourcesEntity urlResourcesEntity : list) { if(typeEnum==null){ menuList.add(urlResourcesEntity.getMenu()); }else if (urlResourcesEntity.getMenu().getType() == typeEnum) { menuList.add(urlResourcesEntity.getMenu()); } } return menuList; }
@Test public void Simple_BooleanOperation_ElementCollection() { QEmployee employee = QEmployee.employee; Predicate predicate = employee.jobFunctions.any().eq(JobFunction.CODER); assertMatches("exists \\(select 1\n" + "from Employee employee.*\n" + " inner join employee.*.jobFunctions as employee_jobFunctions.*\n" + "where employee.* = employee and employee_jobFunctions.* = \\?1\\)", serialize(predicate)); }
@Override public List<MirrorPropertyEntity> findByBelongMObjectAndControllerTypeAndIsEnable(MObjectEntity belongMObject, MControllerTypeEnum controllerTypeEnum, boolean isEnable) { JPAQuery query = new JPAQuery(entityManager); QMirrorPropertyEntity mirrorProperty = new QMirrorPropertyEntity("mpro"); List<MirrorPropertyEntity> list = query.from(mirrorProperty) .where(mirrorProperty.rootMObject.eq(belongMObject) .and(mirrorProperty.belongMObject.eq(belongMObject)) .and(mirrorProperty.controllerType.eq(controllerTypeEnum)) ) .list(mirrorProperty); return list; }
public List<MTemplateEntity> findCustomTemplates(MObjectEntity belongMObject, MTemplateTypeEnum templateType, Boolean isSystem) { QMTemplateEntity obj = QMTemplateEntity.mTemplateEntity; JPAQuery query = new JPAQuery(entityManager); List<MTemplateEntity> templateList = query.from(obj) .where(obj.isSystem.eq(isSystem) .and(obj.belongMObject.eq(belongMObject)) .and(obj.templateType.eq(templateType)) ) .orderBy(obj.isSystem.desc()) .orderBy(obj.templateType.asc()) .orderBy(obj.sort.asc()) .list(obj); return templateList; }
predicate = predicate.and(qThesisMetadata.commitState.eq(thesisSearchCriteria.getCommitState()));