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;
}
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;
}
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);
}
}
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);
}
}
}
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);
}
}
}
Aggregations