Gecko [ 35.178.45.201 ]

Name	Size	Permission
CargoRepository.php	1.95 KB	-rw-rw-r--
DepotRepository.php	2.21 KB	-rw-rw-r--
LoadingRepository.php	1.94 KB	-rw-rw-r--
ReleaseOrderRepository.php	8.66 KB	-rw-rw-r--
SubcargoRepository.php	424 B	-rw-rw-r--
UserDepotRepository.php	3.11 KB	-rw-rw-r--
UserRepository.php	463 B	-rw-rw-r--
googleda794cd9937527d01.html	33 B	-rw-r--r--

Code Editor : ReleaseOrderRepository.php

<?php

namespace App\Repository;

/**
 * ReleaseOrderRepository
 *
 * This class was generated by the Doctrine ORM. Add your own custom
 * repository methods below.
 */
class ReleaseOrderRepository extends \Doctrine\ORM\EntityRepository
{

public function findAllSort()
	{
		return $this->createQueryBuilder('r')
					->orderBy('r.dates', 'DESC')
					->getQuery()
					->execute();
	}

public function findAllToday()
	{

return $this->getEntityManager()
					->createQuery(
						'SELECT r FROM App\Entity\ReleaseOrder r WHERE r.depot IS NOT NULL ORDER BY r.dates DESC'
					)->getResult();
	}

public function findDepotsDistinct()
	{

return $this->getEntityManager()
					->createQuery(
						'SELECT DISTINCT r.depot FROM App\Entity\ReleaseOrder r'
					)->getResult();
	}

public function deleteByDepot($id)
	{

return $this->getEntityManager()
					->createQuery(
						'DELETE FROM App\Entity\ReleaseOrder r WHERE r.depot = :id'
					)->setParameter('id', $id)
					->getResult();
	}

public function softDeleteByDepot($id)
	{

return $this->getEntityManager()
					->createQuery(
						'UPDATE App\Entity\ReleaseOrder r SET r.depot = NULL, r.depots = :id WHERE r.depot = :id'
					)->setParameter('id', $id)
					->getResult();
	}

public function findAuthorizedNotLoaded($product)
	{
	    return $this->getEntityManager()
			        ->createQuery(
			            'SELECT r FROM App\Entity\ReleaseOrder r, App\Entity\Cargo c WHERE r.signtwoid IS NOT NULL AND c.product = :product AND r.cargo = c.id AND (r.isLoaded = 0 OR r.isLoaded IS NULL) AND r.depot IS NOT NULL ORDER BY r.dates DESC, r.signtwoid DESC'
			        )->setParameter('product', $product)
			        ->getResult();
	}

public function findAuthorizedNotLoadedByCargo($cargo)
	{
	    return $this->getEntityManager()
			        ->createQuery(
			            'SELECT r FROM App\Entity\ReleaseOrder r, App\Entity\Cargo c WHERE r.signtwoid IS NOT NULL AND c.id = :cargo AND r.cargo = c.id AND (r.isLoaded = 0 OR r.isLoaded IS NULL) AND r.depot IS NOT NULL ORDER BY r.dates DESC, r.signtwoid DESC'
			        )->setParameter('cargo', $cargo)
			        ->getResult();
	}

public function findAllAuthorized($cargo)
	{
	    return $this->getEntityManager()
			        ->createQuery(
			            'SELECT r FROM App\Entity\ReleaseOrder r, App\Entity\Cargo c WHERE r.signtwoid IS NOT NULL AND c.product = :cargo AND r.cargo = c.id AND r.depot IS NOT NULL ORDER BY r.dates DESC'
			        )->setParameter('cargo', $cargo)
			        ->getResult();
	}

public function findCargoAuthorizedNotLoaded()
	{
	    return $this->getEntityManager()
			        ->createQuery(
			            'SELECT c.id, c.cargoname, COUNT(r.id) as release_count, c.date, c.seller, c.initial, c.product FROM App\Entity\ReleaseOrder r, App\Entity\Cargo c WHERE r.signtwoid IS NOT NULL AND r.cargo = c.id AND (r.isLoaded = 0 OR r.isLoaded IS NULL) GROUP BY c.id, c.cargoname, c.date, c.seller, c.product, c.initial ORDER BY c.date DESC'
			        )
			        ->getResult();
	}

public function findDepotsAuthorized()
	{
	    return $this->getEntityManager()
			        ->createQuery(
			            'SELECT distinct d.id, d.name FROM App\Entity\Depot d INNER JOIN App\Entity\ReleaseOrder r WHERE r.depot = d.id AND r.signtwoid IS NOT NULL AND r.depot IS NOT NULL'
			        )
			        ->getResult();
	}

public function findSigned()
	{
	    return $this->getEntityManager()
			        ->createQuery(
			            'SELECT r FROM App\Entity\ReleaseOrder r WHERE r.signoneid IS NOT NULL AND r.signtwoid IS NOT NULL AND r.signthreeid IS NOT NULL AND r.depot IS NOT NULL ORDER BY r.dates DESC'
			        )
			        ->getResult();
	}

public function findSignedByDepot($id)
	{
	    return $this->getEntityManager()
			        ->createQuery(
			            'SELECT r FROM App\Entity\ReleaseOrder r WHERE r.depot = :id ORDER BY r.dates DESC'
			        )->setParameter('id', $id)
			        ->getResult();
	}

public function findUnsigned($year)
	{
		try {
			$startOfYear = new \DateTime(sprintf('first day of january %d 00:00:00', intval($year)));
			$endOfYear = new \DateTime(sprintf('last day of december %d 00:00:00', intval($year)));
		} catch (\Exception $e) {
			$year = null;
		}
		// var_dump($startOfYear);die;
		$startOfTime = new \DateTime('first day of january 1970 00:00:00');
		$now = new \DateTime('now');
	    $query = $this->getEntityManager()
			        ->createQuery(
			            'SELECT r FROM App\Entity\ReleaseOrder r WHERE (r.signoneid IS NULL OR r.signtwoid IS NULL OR r.signthreeid IS NULL) AND (r.dates > :start AND r.dates < :end) ORDER BY r.dates DESC'
			        );
		if ($year) {
			$query->setParameter('start', $startOfYear)
				->setParameter('end', $endOfYear);
		}else {
			$query->setParameter('start', $startOfTime)
				->setParameter('end', $now);
		}
		
		return $query->getResult();
	}

/**
	 * Find the total loaded from a release order
	 * @param  int $release
	 * @return int
	 */
	public function findTotalLoaded($release)
	{
			return $this->getEntityManager()
								->createQuery(
										'SELECT SUM(l.quantity) FROM App\Entity\Loading l WHERE l.release = :id'
									)->setParameter('id', $release)
									->getSingleScalarResult();
	}

public function findJoinCargo($id)
	{
	    return $this->getEntityManager()
			        ->createQuery(
			            'SELECT r.id as id, IDENTITY(r.cargo), r.customer, r.quantity, r.depot, r.bank, r.date, r.signone, r.signtwo, r.signthree, c.product as product, c.id as cargoid FROM App\Entity\ReleaseOrder r, App\Entity\Cargo c WHERE r.cargo = c.id AND r.id = :id AND r.depot IS NOT NULL'
			        )->setParameter('id', $id)
			        ->getResult();
	}

public function findByCargo($id)
	{
		return $this->getEntityManager()
					->createQuery(
						'SELECT r FROM App\Entity\ReleaseOrder r WHERE r.cargo  = :id AND r.depot IS NOT NULL'
					)->setParameter('id', $id)
					->getResult();
	}

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

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

public function findTotalByDate($from, $to)
	{
		return $this->getEntityManager()
					->createQuery(
						'SELECT SUM(r.quantity) FROM App\Entity\ReleaseOrder r WHERE r.dates BETWEEN :fro AND :to ORDER BY r.dates DESC'
					)->setParameter('fro', $from)
					->setParameter('to', $to)
					->getSingleScalarResult();
	}

public function findTotalByTime($from, $to, $today)
	{
		return $this->getEntityManager()
					->createQuery(
						'SELECT SUM(r.quantity) FROM App\Entity\ReleaseOrder r WHERE r.dates BETWEEN :fro AND :to AND r.depot IS NOT NULL ORDER BY r.dates DESC'
					)->setParameter('fro', $from)
					->setParameter('to', $to)
					->getSingleScalarResult();
	}

public function findTotalByProduct($firstMonth, $now, $today, $firstYear, $product)
	{
		// $today = date('m-d-Y');
		// $first = date('m-01-Y');
		$year =  $this->getEntityManager()
					->createQuery(
						'SELECT SUM(r.quantity) FROM App\Entity\ReleaseOrder r, App\Entity\Cargo c WHERE r.dates BETWEEN :firstyear AND :now AND c.product = :product AND r.cargo = c.id AND r.depot IS NOT NULL'
					)->setParameter('firstyear', $firstYear)
					->setParameter('now', $now)
					->setParameter('product', $product)
					->getSingleScalarResult();

$month =  $this->getEntityManager()
					->createQuery(
						'SELECT SUM(r.quantity) FROM App\Entity\ReleaseOrder r, App\Entity\Cargo c WHERE r.dates BETWEEN :firstmonth AND :today AND c.product = :product AND r.cargo = c.id AND r.depot IS NOT NULL'
					)->setParameter('firstmonth', $firstMonth)
					->setParameter('today', $now)
					->setParameter('product', $product)
					->getSingleScalarResult();

$day =  $this->getEntityManager()
					->createQuery(
						'SELECT SUM(r.quantity) FROM App\Entity\ReleaseOrder r, App\Entity\Cargo c WHERE r.dates BETWEEN :today AND :now AND c.product = :product AND r.cargo = c.id AND r.depot IS NOT NULL'
					)->setParameter('today', $today)
					->setParameter('now', $now)
					->setParameter('product', $product)
					->getSingleScalarResult();

return array('day' => $day, 'month' => $month, 'year' => $year);
	}

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

}

${this.title}

Code Editor : ReleaseOrderRepository.php