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.

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:

$ 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.

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:

<?php
// app/AppKernel.php

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

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

        // ...
    }
}

Usage

inside your repository:

    /**
     * @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

License

Copyrights (c) 2017 Matthias Morin

Distributed under the MIT license.

If you like TangoMan DQL Helper Bundle please star! And follow me on GitHub: TangoMan75 ... And check my other cool projects.

tangoman.free.fr