Elep

<?php

namespace App\Repository;

/**
 * LoadingRepository
 *
 * This class was generated by the Doctrine ORM. Add your own custom
 * repository methods below.
 */
class LoadingRepository extends \Doctrine\ORM\EntityRepository
{
	public function findByRelease($id)
	{
	    return $this->getEntityManager()
			        ->createQuery(
			            'SELECT l FROM App\Entity\Loading l WHERE l.release = :id'
			        )->setParameter('id', $id)
			        ->getResult();
	}

public function deleteByRelease($id)
	{
	    return $this->getEntityManager()
			        ->createQuery(
			            'DELETE FROM App\Entity\Loading l WHERE l.release = :id'
			        )->setParameter('id', $id)
			        ->getResult();
	}

public function findByFilter($filter)
	{
		$fin = date('d-m-Y');
		$date = date_create($fin);
		date_sub($date,date_interval_create_from_date_string('12 days'));
		$init = date_format($date,"d-m-Y");
	    return $this->getEntityManager()
			        ->createQuery(
			            'SELECT l FROM App\Entity\Loading l WHERE l.date BETWEEN :init AND :fin'
			        )->setParameter('init', $init)
			        ->setParameter('fin', $fin)
			        ->getResult();
	}

public function findByDate($from, $to)
	{
		return $this->getEntityManager()
					->createQuery(
						'SELECT l FROM App\Entity\Loading l WHERE l.date BETWEEN :fro AND :to'
					)->setParameter('fro', $from)
					->setParameter('to', $to)
					->getResult();
	}

public function findByCustomer($customer)
	{
		return $this->getEntityManager()
					->createQuery(
						'SELECT r.customer FROM App\Entity\Loading l, App\Entity\ReleaseOrder r WHERE l.release = r.id AND r.customer = :customer'
					)->setParameter('customer', $customer)
					->getResult();
	}

public function findLoadedTotal($id)
	{
		return $this->createQueryBuilder('l')
					->andWhere('l.release = :id')
					->setParameter('id', $id)
					->select('SUM(l.quantity) as quantity')
					->getQuery()
					->getOneOrNullResult();
	}
}