Add support for the SearchBuilder extension

[darrachequesne]

Reference: https://datatables.net/extensions/searchbuilder/

We will need to handle the additional query parameters (which can be nested):

searchBuilder.criteria[0].condition  			=
searchBuilder.criteria[0].data  			Firstname
searchBuilder.criteria[0].origData  			firstName
searchBuilder.criteria[0].type  			string
searchBuilder.criteria[0].value[]  			john
searchBuilder.criteria[0].value1  			john
searchBuilder.criteria[1].criteria[0].condition		starts
searchBuilder.criteria[1].criteria[0].data  		Lastname
searchBuilder.criteria[1].criteria[0].origData		lastName
searchBuilder.criteria[1].criteria[0].type  		string
searchBuilder.criteria[1].criteria[0].value[]  		do
searchBuilder.criteria[1].criteria[0].value1  		do
searchBuilder.criteria[1].criteria[1].condition  	null
searchBuilder.criteria[1].criteria[1].data  		Lastname
searchBuilder.criteria[1].criteria[1].origData  	lastName
searchBuilder.criteria[1].criteria[1].type  		string
searchBuilder.criteria[1].logic  			OR
searchBuilder.logic					AND

Contribution is welcome!

[Praytic]

Hi @darrachequesne , I have read the documentation for the SearchBuilder, but I'm still not completely sure how it should be applied on the server-side. Could you give some hints?

[Praytic]

I have an idea of creating multiple enums which are mapped to specific CriteriaBuilder methods. Do you think it will be a good design decision?

[Praytic]

For example:

@Data
@NoArgsConstructor
@AllArgsConstructor
public static class Criteria {
    private Condition condition;
    private String data;
    private String origData;
    private String type;
    private List<String> value;
    private String logic;
    private List<Criteria> criteria;

    public <T> Predicate notEmpty(Root<T> root, CriteriaQuery<?> criteriaQuery, CriteriaBuilder criteriaBuilder) {
        return criteriaBuilder.equal(criteriaBuilder.length(root.get(origData)), 0);
    }
}

And condition enum will look like that:

public enum Condition {
  NOT_EMPTY("!null", (builder) -> builder::notEmpty);

  private String key;
  private Function<Criteria, Specification> predicate;

  Condition(String key, Function<Criteria, Specification> predicate) {
      this.key = key;
      this.predicate = predicate;
  }
}

[KrunchMuffin]

I would be willing to throw in $100 to get this working