@Override public void addRestriction(final SearchCriteriaBuilder scb) { scb.add(SearchRestrictions.in(statusFieldName, allowedStatuses)); } };
public void restrictSuppliers(final SearchCriteriaBuilder scb, final FilterValueHolder filterValue) { Long productId = filterValue.getLong(CoverageProductGeneratedFields.PRODUCT_ID); List<Long> ids = deliveriesService.getSuppliersWithIntegration(productId).stream().map(Entity::getId) .collect(Collectors.toList()); if (ids.isEmpty()) { scb.add(SearchRestrictions.idEq(0L)); } else { scb.add(SearchRestrictions.in("id", ids)); } } }
public void showAtachmentsForTechnologies(final SearchCriteriaBuilder scb, final FilterValueHolder filterValue) { List<Long> technologyIDs = Lists.newArrayList(); if (filterValue.has(TECHNOLOGY_IDS)) { technologyIDs = filterValue.getListOfLongs(TECHNOLOGY_IDS); } if (technologyIDs.isEmpty()) { technologyIDs.add(0L); } scb.createAlias(TechnologyAttachmentFields.TECHNOLOGY, "t").add(SearchRestrictions.in("t.id", technologyIDs)); }
public void showAcceptedAndInterrupted(final SearchCriteriaBuilder scb) { scb.add(SearchRestrictions.in(OrderFields.STATE, Lists.newArrayList(OrderState.IN_PROGRESS.getStringValue(), OrderState.INTERRUPTED.getStringValue()))).add( SearchRestrictions.in(OrderFieldsPC.TYPE_OF_PRODUCTION_RECORDING, Lists.newArrayList(TypeOfProductionRecording.CUMULATED.getStringValue(), TypeOfProductionRecording.FOR_EACH.getStringValue()))); }
private void restrictToUserLocations(SearchCriteriaBuilder scb) { Long currentUserId = securityService.getCurrentUserId(); if (Objects.nonNull(currentUserId)) { EntityList userLocations = userDataDefinition().get(currentUserId).getHasManyField(UserFieldsMF.USER_LOCATIONS); if (!userLocations.isEmpty()) { Set<Integer> locationIds = userLocations.stream().map(ul -> ul.getBelongsToField(UserLocationFields.LOCATION)) .mapToInt(e -> e.getId().intValue()).boxed().collect(Collectors.toSet()); scb.add(SearchRestrictions.or(SearchRestrictions.in(LOCATION_TO_ID, locationIds), SearchRestrictions.in(LOCATION_FROM_ID, locationIds))); } } }
public List<Long> getRegisterOrderProductsIds(final List<Entity> order) { List<Long> orderIds = order.stream().map(o -> o.getId()).collect(Collectors.toList()); List<Entity> entries = dataDefinitionService .get(OrderSuppliesConstants.PLUGIN_IDENTIFIER, OrderSuppliesConstants.MODEL_COVERAGE_REGISTER).find() .createAlias(CoverageRegisterFields.ORDER, "ord", JoinType.LEFT) .add(SearchRestrictions.in("ord.id", Lists.newArrayList(orderIds))).list().getEntities(); return entries.stream().map(r -> r.getBelongsToField(CoverageRegisterFields.PRODUCT).getId()) .collect(Collectors.toList()); }
private Date findCalculatedStartAllOrders(final Entity order) { List<Entity> ordersTimeCalculations = dataDefinitionService .get(TimeNormsConstants.PLUGIN_PRODUCTION_SCHEDULING_IDENTIFIER, TimeNormsConstants.MODEL_ORDER_TIME_CALCULATION) .find().createAlias("order", "ord", JoinType.LEFT) .add(SearchRestrictions.in("ord.id", getOrderAndSubOrders(order.getId()).stream().map(entity -> entity.getId()).collect(Collectors.toList()))) .list().getEntities(); return ordersTimeCalculations.stream().map(e -> e.getDateField(OrderTimeCalculationFields.EFFECTIVE_DATE_FROM)) .min(Comparator.<Date>naturalOrder()).get(); }
public void restrictToUserLocations(final SearchCriteriaBuilder scb, final FilterValueHolder filterValue) { Long currentUserId = securityService.getCurrentUserId(); if (Objects.nonNull(currentUserId)) { EntityList userLocations = userDataDefinition().get(currentUserId).getHasManyField(UserFieldsMF.USER_LOCATIONS); if (!userLocations.isEmpty()) { Set<Integer> locationIds = userLocations.stream().map(ul -> ul.getBelongsToField(UserLocationFields.LOCATION)) .mapToInt(e -> e.getId().intValue()).boxed().collect(Collectors.toSet()); scb.add(SearchRestrictions.in(LOCATION_ID, locationIds)); } } }
public void restrictToUserLocations(final SearchCriteriaBuilder scb, final FilterValueHolder filterValue) { Long currentUserId = securityService.getCurrentUserId(); if (Objects.nonNull(currentUserId)) { EntityList userLocations = userDataDefinition().get(currentUserId).getHasManyField(UserFieldsMF.USER_LOCATIONS); if (!userLocations.isEmpty()) { Set<Integer> locationIds = userLocations.stream().map(ul -> ul.getBelongsToField(UserLocationFields.LOCATION)) .mapToInt(e -> e.getId().intValue()).boxed().collect(Collectors.toSet()); scb.add(SearchRestrictions.in(LOCATION_ID, locationIds)); } } }
public void restrictToUserLocations(final SearchCriteriaBuilder scb, final FilterValueHolder filter) { Long currentUserId = securityService.getCurrentUserId(); if (Objects.nonNull(currentUserId)) { EntityList userLocations = userDataDefinition().get(currentUserId).getHasManyField(UserFieldsMF.USER_LOCATIONS); if (!userLocations.isEmpty()) { Set<Integer> locationIds = userLocations.stream().map(ul -> ul.getBelongsToField(UserLocationFields.LOCATION)) .mapToInt(e -> e.getId().intValue()).boxed().collect(Collectors.toSet()); scb.add(SearchRestrictions.in("locationId", locationIds)); } } }
public void restrictToUserLocations(final SearchCriteriaBuilder scb, final FilterValueHolder filterValue) { Long currentUserId = securityService.getCurrentUserId(); if (Objects.nonNull(currentUserId)) { EntityList userLocations = userDataDefinition().get(currentUserId).getHasManyField(UserFieldsMF.USER_LOCATIONS); if (!userLocations.isEmpty()) { Set<Long> locationIds = userLocations.stream().map(ul -> ul.getBelongsToField(UserLocationFields.LOCATION)) .map(Entity::getId).collect(Collectors.toSet()); scb.add(SearchRestrictions.in("location.id", locationIds)); } } }
public void showAcceptedInProgressInterrupted(final SearchCriteriaBuilder scb) { scb.add(SearchRestrictions.in(OrderFields.STATE, Lists.newArrayList(OrderState.ACCEPTED.getStringValue(), OrderState.IN_PROGRESS.getStringValue(), OrderState.INTERRUPTED.getStringValue()))); } }
private List<Entity> findExistingOrderMaterialCosts(final Entity order, final Collection<Long> productIds) { if (order.getId() == null) { return Collections.emptyList(); } OrderMaterialCostsCriteria criteria = OrderMaterialCostsCriteria.forOrder(order.getId()); if (productIds != null) { criteria.setProductCriteria(in("id", productIds)); } return orderMaterialCostsDataProvider.findAll(criteria); }
public void showOrdersForProductionBalance(final SearchCriteriaBuilder scb) { scb.add(SearchRestrictions.in(OrderFields.STATE, Lists.newArrayList(OrderState.IN_PROGRESS.getStringValue(), OrderState.COMPLETED.getStringValue(), OrderState.INTERRUPTED.getStringValue(), OrderState.ABANDONED.getStringValue()))); } }
public void deactivateDictionaryItems(final Collection<String> technicalCodes) { DataDefinition dictionaryItemDD = dictionariesService.getDictionaryItemDD(); List<Entity> dictionaryItems = dictionaryItemDD.find() .add(belongsTo(DictionaryItemFields.DICTIONARY, getAddressTypeDictionary())) .add(in(DictionaryItemFields.TECHNICAL_CODE, technicalCodes)).list().getEntities(); dictionaryItemDD.deactivate(dictionaryItems.stream().map(Entity::getId).toArray(Long[]::new)); }
@Override public List<Entity> getProductRoots(final Entity product) { Entity parent = product.getBelongsToField(PARENT); String productNodeNumber = product.getStringField(NODE_NUMBER); if ((parent == null) || StringUtils.isEmpty(productNodeNumber)) { return Lists.newArrayList(); } else { return getProductDD().find().add(SearchRestrictions.in(NODE_NUMBER, findRootsForNodeNumber(productNodeNumber))) .list().getEntities(); } }
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)); } } }
public void hideAssignedWorkers(final SearchCriteriaBuilder scb, final FilterValueHolder filterValueHolder) { boolean shouldHideAssignedWorkers = parameterService.getParameter().getBooleanField("hideAssignedStaff"); if (shouldHideAssignedWorkers) { if (filterValueHolder.has(WORKERS_IDS)) { List<Long> ids = filterValueHolder.getListOfLongs(WORKERS_IDS); scb.add(SearchRestrictions.not(SearchRestrictions.in("id", ids))); } } }
public void showDivisionsUsedInTechnology(final SearchCriteriaBuilder scb, final FilterValueHolder filterValueHolder) { if (filterValueHolder.has(L_TECHNOLOGY)) { scb.add(SearchRestrictions.in("id", getDivisionsForOrder(filterValueHolder.getLong(L_TECHNOLOGY)))); } else { scb.add(SearchRestrictions.idEq(-1)); } }
public List<Entity> getProductsToIssue() { return getProductToIssueDD() .find() .createAlias(ProductsToIssueFields.PRODUCT, PRODUCT_ALIAS, JoinType.LEFT) .createAlias(ProductsToIssueFields.WAREHOUSE_ISSUE, WAREHOUSE_ISSUE_ALIAS, JoinType.LEFT) .add(SearchRestrictions.in( getStateField(), Lists.newArrayList(WarehouseIssueState.DRAFT.getStringValue(), WarehouseIssueState.IN_PROGRESS.getStringValue()))) .add(SearchRestrictions.isNotNull(getExternalNumberField())).list().getEntities(); }