petkopara/multi-search-bundle

Symfony bundle for Multi Criteria Search for doctrine entities using Form or Service.

v1.0.0 2016-10-24 20:35 UTC

Requires

• doctrine/doctrine-bundle: ^1.6
• symfony/form: ~2.8|~3.0
• symfony/symfony: ~2.8|~3.0

Requires (Dev)

• phpunit/phpunit: ~4.8

MIT

• Petko Petkov

• doctrine
• query-builder
• symfony3
• multi-search

README

This bundle provides basic service and form type for Multi Search in Doctrine.

Description

Search in all of entity columns by given search term. In response returns Doctrine\ORM\QueryBuilder containing the multiple search criteria. The searched columns can be specified.

Installation

Using composer

composer require petkopara/multi-search-bundle

Add it to the AppKernel.php class:

new Petkopara\MultiSearchBundle\PetkoparaMultiSearchBundle(),

##Usage

Service

You can directly use the service and to apply the multi search to any doctrine query builder.

public function indexAction(Request $request)
{
    $search = $request->get('search');
    $em = $this->getDoctrine()->getManager();
    
    $qb = $em->getRepository('AppBundle:Post')->createQueryBuilder('e');
    $qb = $this->get('petkopara_multi_search.builder')->searchEntity($qb, 'AppBundle:Post', $search);
   //$qb = $this->get('petkopara_multi_search.builder')->searchEntity($qb, 'AppBundle:Post', $search, array('name', 'content'), 'wildcard');

    ..
}

Form

Create your form type and include the multiSearchType in the buildForm function:

use Petkopara\MultiSearchBundle\Form\Type\MultiSearchType;

public function buildForm(FormBuilderInterface $builder, array $options)
{
    $builder
            ->add('search', MultiSearchType::class, array(
                'class' => 'AppBundle:Post', //required
                'search_fields' => array( //optional, if it's empty it will search in the all entity columns
                    'name',
                    'content'
                 ), 
                 'search_comparison_type' => 'wildcard' //optional, what type of comparison to applied ('wildcard','starts_with', 'ends_with', 'equals')
                 
            ))
    ;
}

In the controller add call to the multi search service:

public function indexAction(Request $request)
{
    $search = $request->get('search');
    $em = $this->getDoctrine()->getManager();
    $queryBuilder = $em->getRepository('AppBundle:Post')->createQueryBuilder('e');
    $filterForm = $this->createForm('AppBundle\Form\PostFilterType');

    // Bind values from the request
    $filterForm->handleRequest($request);

    if ($filterForm->isValid()) {
        // Build the query from the given form object
        $queryBuilder = $this->get('petkopara_multi_search.builder')->searchForm($queryBuilder, $filterForm->get('search'));
    }
    
    ..
}

Render your form in the view

{{ form_rest(filterForm) }}

Available Options

The provided type has 2 options:

• search_fields - array of the entity columns that will be added in the search. If it's not set then will search in all columns

• search_comparison_type - how to compare the search term.

  • wildcard - it's equivalent to the %search% like search.

  • equals - like operator without wildcards. Wildcards still can be used with equals if the search term contains *.

  • starts_with - it's equivalent to the %search like search.

  • ends_with - it's equivalent to the search% like search.

These parameters can be applyed to the service as well as 4th and 5th parameter to searchEntity() method

Author

Petko Petkov - [e-mail]

License

MultiSearchBundle is licensed under the MIT License.