@Override public String allowDeleteCategoryOptionGroupSet( CategoryOptionGroupSet categoryOptionGroupSet ) { String sql = "select count(*) from dataapprovallevel where categoryoptiongroupsetid=" + categoryOptionGroupSet.getId(); return jdbcTemplate.queryForObject( sql, Integer.class ) == 0 ? null : ERROR; }
@Override public int saveCategoryOptionGroupSet( CategoryOptionGroupSet group ) { categoryOptionGroupSetStore.save( group ); return group.getId(); }
@Override public List<CategoryOptionGroup> getCategoryOptionGroups( CategoryOptionGroupSet groupSet ) { CriteriaBuilder builder = getCriteriaBuilder(); JpaQueryParameters<CategoryOptionGroup> parameters = newJpaParameters() .addPredicates( getSharingPredicates( builder ) ) .addPredicate( root -> { Join<Object, Object> groupSets = root.join( "groupSets" ); return builder.or( builder.equal( groupSets.get( "id" ) , groupSet.getId() ), builder.isNull( groupSets.get( "id" ) ) ); }); return getList( builder, parameters ); } }
"inner join categoryoptiongroupsetmembers cogsm on cogm.categoryoptiongroupid = cogsm.categoryoptiongroupid " + "where coc.categoryoptioncomboid = cocco.categoryoptioncomboid " + "and cogsm.categoryoptiongroupsetid = " + groupSet.getId() + " " + "limit 1) as " + quote( groupSet.getName() ) + ", "; "inner join categoryoptiongroupsetmembers cogsm on cogm.categoryoptiongroupid = cogsm.categoryoptiongroupid " + "where coc.categoryoptioncomboid = cocco.categoryoptioncomboid " + "and cogsm.categoryoptiongroupsetid = " + groupSet.getId() + " " + "limit 1) as " + quote( groupSet.getUid() ) + ", ";