tangoman/dql-helper-bundle

Symfony DQL Helper Bundle

TangoMan DQL Helper Bundle

TangoMan DQL Helper Bundle provides an easy way to add front elements to your pages. TangoMan DQL Helper Bundle makes building back-office for your app a brease., _(*1)

Installation

Step 1: Download the Bundle

Open a command console, enter your project directory and execute the following command to download the latest stable version of this bundle:, _(*2)

$ composer require tangoman/dql-helper-bundle

This command requires you to have Composer installed globally, as explained in the installation chapter of the Composer documentation., _(*3)

Step 2: Enable the Bundle

Then, enable the bundle by adding it to the list of registered bundles in the app/AppKernel.php file of your project:, _(*4)

<?php
// app/AppKernel.php

// ...
class AppKernel extends Kernel
{
    // ...

    public function registerBundles()
    {
        $bundles = array(
            // ...
            new TangoMan\DqlHelperBundle\TangoManDqlHelperBundle(),
        );

        // ...
    }
}

Usage

inside your repository:, _(*5)

    /**
     * @param integer $fromLat
     * @param integer $fromLon
     *
     * @return mixed
     */
    public function getPlaces($fromLat, $fromLon)
    {
        $dql = $this->createQueryBuilder('places');
        $dql->select('places', 'p')
            ->where('DISTANCE(:fromLat, :fromLon, p.Lat, p.Lon') < 100')
            ->setParameter(':fromLat', $fromLat)
            ->setParameter(':fromLon', $fromLon)
        ;

        return $dql->getQuery()->getResult();
    }

Note

If you find any bug please report here : Issues, _(*6)

License

Copyrights (c) 2017 Matthias Morin, _(*7)

Distributed under the MIT license., _(*8)

If you like TangoMan DQL Helper Bundle please star! And follow me on GitHub: TangoMan75 ... And check my other cool projects., _(*9)

tangoman.free.fr, _(*10)