Download the PHP package silpo-tech/filter-bundle without Composer

Filter Bundle

About

The Filter Bundle contains mapping and criteria builder

Installation

Require the bundle and its dependencies with composer:

Register the bundle:

Usage

1. Action:

2. Repository method

Filter DTO example:

Search Filter

If Doctrine ORM or MongoDB ODM support is enabled, adding filters is as easy as registering a filter service in the api/config/services.yaml file and adding an attribute to your resource configuration.

The search filter supports exact, partial, start, end, and word_start matching strategies:

• exact strategy uses IN (...) to search for fields that contain value1, value2, ..., valueN.
• partial strategy uses LIKE %text% to search for fields that contain text.
• start strategy uses LIKE text% to search for fields that start with text.
• end strategy uses LIKE %text to search for fields that end with text.
• word_start strategy uses LIKE text% OR LIKE % text% to search for fields that contain words starting with text.

Prepend the letter i to the filter if you want it to be case insensitive. For example ipartial or iexact. Note that this will use the LOWER function and will impact performance if there is no proper index.

Case insensitivity may already be enforced at the database level depending on the collation used. If you are using MySQL, note that the commonly used utf8_unicode_ci collation (and its sibling utf8mb4_unicode_ci) are already case-insensitive, as indicated by the _ci part in their names.

You can dynamically change the strategy to filters from the client, for this behavior your dto must implement StrategyInterface: ?filter[title:istart]=Ukrainian

Example syntax for exact strategy: ?filter[status][0]=new&filter[status][1]=completed

Date Filter

Usage syntax: ?filter[createdAt][from]=2022-05&filter[createdAt][to]=2022-06

Managing null Values

The date filter is able to deal with date properties having null values. Four behaviors are available at the property level of the filter via the arguments parameter:

To configure null management for a date property, pass the nullManagement key in the arguments array of the #[ApiFilter] attribute:

Behavior details:

• exclude_null — adds IS NOT NULL condition, completely excluding records where the date field is null.
• include_null_before — when filtering with to/strictly_to, records with null are included in the results (treated as oldest).
• include_null_after — when filtering with from/strictly_from, records with null are included in the results (treated as youngest).
• include_null_before_and_after — records with null are always included regardless of the filter direction.

You can also combine nullManagement with other DateFilter arguments like compareDateToDateTime or convertToTz:

Order Filter (Sorting)

The order filter allows to sort a collection against the given properties.

Syntax: ?filter[sort][0]=-createdAt&filter[sort][0]=updatedAt

By default, whenever the query does not specify the direction explicitly (e.g.: ?filter[sort][0]=-createdAt), filters will not be applied unless you configure a default order direction to use.

Constraints

ValidDateRange

Validates that given array value is a valid date range, e.g. property is an array with two keys: from, to; array values should date string of valid format, default format is Y-m-d

Basic usage

Options

format

Defines date string format

invalidDateTimeMessage

Message that will be shown if from or to values are not valid date string

invalidDateRangeMessage

Message that will be shown if from is greater than to

min

If provided additional check will be performed to check to is greater than from for at least min value. Value should be valid DateInterval string with leading plus sign, e.g. +1 sec, +2 hour 3 min.

max

If provided additional check will be performed to check to is greater than from for at most max value. Value should be valid DateInterval string with leading plus sign, e.g. +1 sec, +2 hour 3 min.

minMessage

Message that will be shown if to is not greater than from for at least min value

maxMessage

Message that will be shown if to is greater than from for more than max value