Search in sources :

Example 1 with Param

use of com.haulmont.cuba.gui.components.filter.Param in project cuba by cuba-platform.

the class CustomConditionCreator method createCondition.

@Override
public AbstractCondition createCondition() {
    CustomCondition customCondition = new CustomCondition(this, null, null, entityAlias, false);
    // default editor - text
    customCondition.setJavaClass(String.class);
    Param param = AppBeans.get(ConditionParamBuilder.class).createParam(customCondition);
    customCondition.setParam(param);
    return customCondition;
}
Also used : ConditionParamBuilder(com.haulmont.cuba.gui.components.filter.ConditionParamBuilder) CustomCondition(com.haulmont.cuba.gui.components.filter.condition.CustomCondition) Param(com.haulmont.cuba.gui.components.filter.Param)

Example 2 with Param

use of com.haulmont.cuba.gui.components.filter.Param in project cuba by cuba-platform.

the class DynamicAttributesConditionFrame method commit.

@Override
public boolean commit() {
    if (!super.commit())
        return false;
    String error = checkCondition();
    if (error != null) {
        showNotification(messages.getMainMessage(error), Frame.NotificationType.TRAY);
        return false;
    }
    CategoryAttribute attribute = attributeLookup.getValue();
    String alias = condition.getEntityAlias();
    String cavAlias = "cav" + RandomStringUtils.randomNumeric(5);
    String paramName;
    String operation = operationLookup.<Op>getValue().forJpql();
    Op op = operationLookup.getValue();
    Class javaClass = DynamicAttributesUtils.getAttributeClass(attribute);
    String propertyPath = Strings.isNullOrEmpty(condition.getPropertyPath()) ? "" : "." + condition.getPropertyPath();
    ConditionParamBuilder paramBuilder = AppBeans.get(ConditionParamBuilder.class);
    paramName = paramBuilder.createParamName(condition);
    String cavEntityId = referenceToEntitySupport.getReferenceIdPropertyName(condition.getDatasource().getMetaClass());
    String where;
    if (op == Op.NOT_EMPTY) {
        where = "(exists (select " + cavAlias + " from sys$CategoryAttributeValue " + cavAlias + " where " + cavAlias + ".entity." + cavEntityId + "=" + "{E}" + propertyPath + ".id and " + cavAlias + ".categoryAttribute.id='" + attributeLookup.<CategoryAttribute>getValue().getId() + "'))";
    } else {
        String valueFieldName = "stringValue";
        if (Entity.class.isAssignableFrom(javaClass))
            valueFieldName = "entityValue." + referenceToEntitySupport.getReferenceIdPropertyName(metadata.getClassNN(javaClass));
        else if (String.class.isAssignableFrom(javaClass))
            valueFieldName = "stringValue";
        else if (Integer.class.isAssignableFrom(javaClass))
            valueFieldName = "intValue";
        else if (Double.class.isAssignableFrom(javaClass))
            valueFieldName = "doubleValue";
        else if (Boolean.class.isAssignableFrom(javaClass))
            valueFieldName = "booleanValue";
        else if (Date.class.isAssignableFrom(javaClass))
            valueFieldName = "dateValue";
        if (!attribute.getIsCollection()) {
            condition.setJoin(", sys$CategoryAttributeValue " + cavAlias + " ");
            String paramStr = " ? ";
            where = cavAlias + ".entity." + cavEntityId + "=" + "{E}" + propertyPath + ".id and " + cavAlias + "." + valueFieldName + " " + operation + (op.isUnary() ? " " : paramStr) + "and " + cavAlias + ".categoryAttribute.id='" + attributeLookup.<CategoryAttribute>getValue().getId() + "'";
            where = where.replace("?", ":" + paramName);
        } else {
            where = "(exists (select " + cavAlias + " from sys$CategoryAttributeValue " + cavAlias + " where " + cavAlias + ".entity." + cavEntityId + "=" + "{E}" + propertyPath + ".id and " + cavAlias + "." + valueFieldName + " = :" + paramName + " and " + cavAlias + ".categoryAttribute.id='" + attributeLookup.<CategoryAttribute>getValue().getId() + "'))";
        }
    }
    condition.setWhere(where);
    condition.setUnary(op.isUnary());
    condition.setEntityParamView(null);
    condition.setEntityParamWhere(null);
    condition.setInExpr(Op.IN.equals(op) || Op.NOT_IN.equals(op));
    condition.setOperator(operationLookup.<Op>getValue());
    Class paramJavaClass = op.isUnary() ? Boolean.class : javaClass;
    condition.setJavaClass(javaClass);
    Param param = Param.Builder.getInstance().setName(paramName).setJavaClass(paramJavaClass).setDataSource(condition.getDatasource()).setProperty(DynamicAttributesUtils.getMetaPropertyPath(null, attribute).getMetaProperty()).setInExpr(condition.getInExpr()).setRequired(condition.getRequired()).setCategoryAttrId(attribute.getId()).build();
    Object defaultValue = condition.getParam().getDefaultValue();
    param.setDefaultValue(defaultValue);
    condition.setParam(param);
    condition.setCategoryId(categoryLookup.<Category>getValue().getId());
    condition.setCategoryAttributeId(attributeLookup.<CategoryAttribute>getValue().getId());
    condition.setIsCollection(BooleanUtils.isTrue(attributeLookup.<CategoryAttribute>getValue().getIsCollection()));
    condition.setLocCaption(attribute.getLocaleName());
    condition.setCaption(caption.getValue());
    return true;
}
Also used : Op(com.haulmont.cuba.core.global.filter.Op) ConditionParamBuilder(com.haulmont.cuba.gui.components.filter.ConditionParamBuilder) CategoryAttribute(com.haulmont.cuba.core.entity.CategoryAttribute) Category(com.haulmont.cuba.core.entity.Category) Param(com.haulmont.cuba.gui.components.filter.Param) MetaClass(com.haulmont.chile.core.model.MetaClass)

Example 3 with Param

use of com.haulmont.cuba.gui.components.filter.Param in project cuba by cuba-platform.

the class AbstractCondition method setParam.

public void setParam(Param param) {
    Param oldParam = this.param;
    this.param = param;
    for (AbstractCondition.Listener listener : listeners) {
        listener.paramChanged(oldParam, param);
    }
}
Also used : Param(com.haulmont.cuba.gui.components.filter.Param)

Example 4 with Param

use of com.haulmont.cuba.gui.components.filter.Param in project cuba by cuba-platform.

the class DynamicAttributesCondition method setOperator.

@Override
public void setOperator(Op operator) {
    if (!Objects.equals(this.operator, operator)) {
        this.operator = operator;
        String paramName = param.getName();
        ConditionParamBuilder paramBuilder = AppBeans.get(ConditionParamBuilder.class);
        if (operator.isUnary()) {
            unary = true;
            inExpr = false;
            Param param = Param.Builder.getInstance().setName(paramName).setJavaClass(Boolean.class).setInExpr(false).setRequired(required).build();
            setParam(param);
        } else {
            unary = false;
            inExpr = operator.equals(Op.IN) || operator.equals(Op.NOT_IN);
            Param param = paramBuilder.createParam(this);
            setParam(param);
        }
    }
}
Also used : ConditionParamBuilder(com.haulmont.cuba.gui.components.filter.ConditionParamBuilder) Param(com.haulmont.cuba.gui.components.filter.Param)

Example 5 with Param

use of com.haulmont.cuba.gui.components.filter.Param in project cuba by cuba-platform.

the class PropertyCondition method setOperator.

@Override
public void setOperator(Op operator) {
    if (!Objects.equals(this.operator, operator)) {
        this.operator = operator;
        String paramName = param.getName();
        ConditionParamBuilder paramBuilder = AppBeans.get(ConditionParamBuilder.class);
        if (operator.isUnary()) {
            unary = true;
            inExpr = false;
            Param param = Param.Builder.getInstance().setName(paramName).setJavaClass(Boolean.class).setInExpr(false).setRequired(required).build();
            setParam(param);
        } else {
            unary = false;
            inExpr = operator.equals(Op.IN) || operator.equals(Op.NOT_IN);
            Param param = paramBuilder.createParam(this);
            if (operator == Op.DATE_INTERVAL) {
                // each parameter value change must modify the condition text
                param.addValueChangeListener((prevValue, value) -> updateText());
            }
            setParam(param);
        }
    }
}
Also used : ConditionParamBuilder(com.haulmont.cuba.gui.components.filter.ConditionParamBuilder) Param(com.haulmont.cuba.gui.components.filter.Param)

Aggregations

Param (com.haulmont.cuba.gui.components.filter.Param)8 ConditionParamBuilder (com.haulmont.cuba.gui.components.filter.ConditionParamBuilder)5 MetaClass (com.haulmont.chile.core.model.MetaClass)2 CustomCondition (com.haulmont.cuba.gui.components.filter.condition.CustomCondition)2 Category (com.haulmont.cuba.core.entity.Category)1 CategoryAttribute (com.haulmont.cuba.core.entity.CategoryAttribute)1 Op (com.haulmont.cuba.core.global.filter.Op)1 PropertyCondition (com.haulmont.cuba.gui.components.filter.condition.PropertyCondition)1 PropertyConditionDescriptor (com.haulmont.cuba.gui.components.filter.descriptor.PropertyConditionDescriptor)1