private SearchCriterion typeOfPalletCriterion(Entity entity) { String typeOfPallet = entity.getStringField(PalletStorageStateDtoFields.TYPE_OF_PALLET); if (StringUtils.isBlank(typeOfPallet)) { return SearchRestrictions.isNull(ResourceFields.TYPE_OF_PALLET); } else { return eq(ResourceFields.TYPE_OF_PALLET, typeOfPallet); } }
private SearchCriterion storageLocationCriterion(Entity entity) { String storageLocationNumber = entity.getStringField(PalletStorageStateDtoFields.STORAGE_LOCATION_NUMBER); if (StringUtils.isBlank(storageLocationNumber)) { return SearchRestrictions.isNull(ResourceFields.STORAGE_LOCATION + ".number"); } else { return eq(ResourceFields.STORAGE_LOCATION + ".number", storageLocationNumber); } }
public void showSolutionsWorkstation(final SearchCriteriaBuilder searchCriteriaBuilder) { showSolutionsSubassembly(searchCriteriaBuilder); searchCriteriaBuilder.add(SearchRestrictions.isNull(MaintenanceEventFields.SUBASSEMBLY)); }
public void showWorkstationTypesWithoutSubassembly(final SearchCriteriaBuilder scb) { scb.add(SearchRestrictions.or(SearchRestrictions.eq(WorkstationTypeFields.SUBASSEMBLY, false), SearchRestrictions.isNull(WorkstationTypeFields.SUBASSEMBLY))); } }
public void showAcceptedPatternTechnology(final SearchCriteriaBuilder scb) { scb.add(SearchRestrictions.isNull(TechnologyFields.TECHNOLOGY_TYPE)); scb.add(SearchRestrictions.eq(TechnologyFields.STATE, TechnologyStateStringValues.ACCEPTED)); }
public void filterAllWithoutOtherAction(final SearchCriteriaBuilder searchCriteriaBuilder, final FilterValueHolder filterValueHolder) { filterActionsForObejct(searchCriteriaBuilder, filterValueHolder); searchCriteriaBuilder.add(SearchRestrictions.or(SearchRestrictions.eq(ActionFields.IS_DEFAULT, false), SearchRestrictions.isNull(ActionFields.IS_DEFAULT))); }
public void showProductForTechnology(final SearchCriteriaBuilder scb, final FilterValueHolder filterValue) { Long productId = filterValue.getLong(PRODUCT_PARAMETER); scb.createAlias(TechnologyFields.PRODUCT, "c").add(SearchRestrictions.eq("c.id", productId)); scb.add(SearchRestrictions.isNull("technologyType")); }
public Optional<Entity> findRoot(final long technologyId) { SearchCriteriaBuilder scb = getTocDataDefinition().find(); scb.createCriteria(TechnologyOperationComponentFields.TECHNOLOGY, "tech_alias", JoinType.INNER).add(idEq(technologyId)); scb.add(isNull(TechnologyOperationComponentFields.PARENT)); return Optional.fromNullable(scb.setMaxResults(1).uniqueResult()); }
public void showEntriesForTechnology(final SearchCriteriaBuilder scb, final FilterValueHolder filterValue) { if (filterValue.has(TECHNOLOGY_PARAMETER)) { Entity technology = dataDefinitionService.get(TechnologiesConstants.PLUGIN_IDENTIFIER, TechnologiesConstants.MODEL_TECHNOLOGY).get(filterValue.getLong(TECHNOLOGY_PARAMETER)); scb.createAlias(OperCompTimeCalculationsFields.TECHNOLOGY_OPERATION_COMPONENT, "opr", JoinType.LEFT); scb.add(SearchRestrictions.in("opr.id", technology.getHasManyField( TechnologyFields.OPERATION_COMPONENTS).stream().map(e -> e.getId()).collect(Collectors.toList()))); scb.add(SearchRestrictions.isNull(OperCompTimeCalculationsFields.ORDER_TIME_CALCULATION)); } else { scb.add(SearchRestrictions.idEq(0l)); } } }
@Override public List<Entity> findMergedEntitiesByOperationComponentId(Long operationComponentId) { return mergesProductOutDD().find() .add(SearchRestrictions.eq(TechnologyOperationComponentMergeProductFields.OPERATION_COMPONENT + ".id", operationComponentId)) .add(SearchRestrictions.isNull(TechnologyOperationComponentMergeProductFields.QUANTITY_CHANGE)) .list().getEntities(); }
@Override public List<Entity> findMergedEntitiesByOperationComponent(Entity operationComponent) { return mergesProductOutDD().find() .add(SearchRestrictions.belongsTo(TechnologyOperationComponentMergeProductFields.OPERATION_COMPONENT, operationComponent)) .add(SearchRestrictions.isNull(TechnologyOperationComponentMergeProductFields.QUANTITY_CHANGE)) .list().getEntities(); }
public Entity getMainTocForOrder(final Entity order) { Entity technology = order.getBelongsToField(OrderFields.TECHNOLOGY); Entity mainTOC = dataDefinitionService .get(TechnologiesConstants.PLUGIN_IDENTIFIER, TechnologiesConstants.MODEL_TECHNOLOGY_OPERATION_COMPONENT).find() .add(SearchRestrictions.belongsTo(TechnologyOperationComponentFields.TECHNOLOGY, technology)) .add(SearchRestrictions.isNull(TechnologyOperationComponentFields.PARENT)).uniqueResult(); return mainTOC; }
private List<Entity> findAllTechnologies() { DataDefinition technologyDD = dataDefinitionService.get(TechnologiesConstants.PLUGIN_IDENTIFIER, TechnologiesConstants.MODEL_TECHNOLOGY); return technologyDD.find().add(SearchRestrictions.isNull(TechnologyFields.TECHNOLOGY_TYPE)) .add(SearchRestrictions.eq(TechnologyFields.ACTIVE, true)).addOrder(SearchOrders.asc(TechnologyFields.NUMBER)) .list().getEntities(); }
public Optional<Entity> find(final Long technologyId) { SearchCriteriaBuilder scb = getOpocDD().findWithAlias("opoc"); scb.createAlias(OperationProductOutComponentFields.OPERATION_COMPONENT, "toc", JoinType.INNER); scb.createAlias("toc." + TechnologyOperationComponentFields.TECHNOLOGY, "tech", JoinType.INNER); scb.add(eqField("tech.product", "opoc.product")); scb.add(isNull("toc.parent")); scb.add(eq("tech.id", technologyId)); scb.addOrder(asc("id")); return Optional.ofNullable(scb.setMaxResults(1).uniqueResult()); }
private Entity getTechnologyForProduct(final Entity product) { Entity technology = null; technology = dataDefinitionService.get(TechnologiesConstants.PLUGIN_IDENTIFIER, TechnologiesConstants.MODEL_TECHNOLOGY) .find().add(SearchRestrictions.belongsTo(TechnologyFields.PRODUCT, product)) .add(SearchRestrictions.isNull(TechnologyFields.TECHNOLOGY_TYPE)) .add(SearchRestrictions.eq(TechnologyFields.STATE, TechnologyState.ACCEPTED.getStringValue())) .add(SearchRestrictions.eq(TechnologyFields.MASTER, true)).uniqueResult(); return technology; }
public Entity findFirstByNumberProductAndOptionallySupplier(final String number, final Entity product, final Entity supplier) { SearchCriteriaBuilder scb = getBatchDataDef().find(); scb.add(eq(BatchFields.NUMBER, number)); scb.add(belongsTo(BatchFields.PRODUCT, product)); scb.add(or(belongsTo(BatchFields.SUPPLIER, supplier), isNull(BatchFields.SUPPLIER))); scb.addOrder(asc(BatchFields.SUPPLIER)); scb.setMaxResults(1); return scb.uniqueResult(); }
public boolean isIntermediate(final Entity product) { SearchCriteriaBuilder scb = dataDefinitionService .get(TechnologiesConstants.PLUGIN_IDENTIFIER, TechnologiesConstants.MODEL_TECHNOLOGY).find() .setProjection(SearchProjections.id()).add(SearchRestrictions.belongsTo(TechnologyFields.PRODUCT, product)) .add(SearchRestrictions.isNull(TechnologyFields.TECHNOLOGY_TYPE)) .add(SearchRestrictions.eq(TechnologyFields.STATE, TechnologyState.ACCEPTED.getStringValue())) .add(SearchRestrictions.eq(TechnologyFields.MASTER, true)); if (scb.setMaxResults(1).uniqueResult() != null) { return true; } return false; }
private List<Entity> getOccupationTypeDictionaryWithoutTechnicalCode() { Entity occupationTypeDictionary = dataDefinitionService .get(QcadooModelConstants.PLUGIN_IDENTIFIER, QcadooModelConstants.MODEL_DICTIONARY).find() .add(SearchRestrictions.eq(DictionaryFields.NAME, L_OCCUPATION_TYPE)).uniqueResult(); return dataDefinitionService.get(QcadooModelConstants.PLUGIN_IDENTIFIER, QcadooModelConstants.MODEL_DICTIONARY_ITEM) .find().add(SearchRestrictions.belongsTo(DictionaryItemFields.DICTIONARY, occupationTypeDictionary)) .add(SearchRestrictions.isNull(DictionaryItemFields.TECHNICAL_CODE)).add(SearchRestrictions.eq("active", true)) .list().getEntities(); }
public Entity findTechnologyForProduct(final Entity product) { DataDefinition technologyDD = dataDefinitionService.get(TechnologiesConstants.PLUGIN_IDENTIFIER, TechnologiesConstants.MODEL_TECHNOLOGY); return technologyDD .find() .add(SearchRestrictions.isNull(TechnologyFields.TECHNOLOGY_TYPE)) .add(SearchRestrictions.belongsTo(ProductStructureTreeNodeFields.PRODUCT, product)) .add(SearchRestrictions.or(SearchRestrictions.eq(TechnologyFields.STATE, TechnologyStateStringValues.ACCEPTED), SearchRestrictions.eq(TechnologyFields.STATE, TechnologyStateStringValues.CHECKED))) .addOrder(SearchOrders.desc(TechnologyFields.MASTER)).addOrder(SearchOrders.asc(TechnologyFields.NUMBER)) .setMaxResults(1).uniqueResult(); }