Gecko [ 35.178.45.201 ]

Name	Size	Permission
.gitignore	0 B	-rw-rw-r--
ActivityRepository.php	1.35 KB	-rw-rw-r--
CustomerRepository.php	1.35 KB	-rw-rw-r--
GroupsRepository.php	229 B	-rw-rw-r--
InventoryRepository.php	235 B	-rw-rw-r--
ItemPartRepository.php	1.9 KB	-rw-rw-r--
ItemRepository.php	648 B	-rw-rw-r--
OrderItemRepository.php	2.43 KB	-rw-rw-r--
OrdersRepository.php	5.33 KB	-rw-rw-r--
PlaceRepository.php	805 B	-rw-rw-r--
StockRepository.php	1.15 KB	-rw-rw-r--
SubscriptionRepository.php	1.39 KB	-rw-rw-r--
SupplierRepository.php	233 B	-rw-rw-r--
SupplyItemRepository.php	4.89 KB	-rw-rw-r--
SupplyRepository.php	655 B	-rw-rw-r--
TransactionRepository.php	1.38 KB	-rw-rw-r--
UsersRepository.php	1.32 KB	-rw-rw-r--

Code Editor : SupplyItemRepository.php

<?php

namespace App\Repository;

/**
 * SupplyItemRepository
 *
 * This class was generated by the Doctrine ORM. Add your own custom
 * repository methods below.
 */
class SupplyItemRepository extends \Doctrine\ORM\EntityRepository
{
	public function findSupplyItems($id, $user)
	{
	    return $this->getEntityManager()
	        ->createQuery(
	            'SELECT si.id as id, si.quantity as quantity, si.amount as amount, s.name as supply_name, s.id as supply_id, sr.name as supplier, s.date as date, st.name as item_name, st.unit as unit FROM App\Entity\SupplyItem si, App\Entity\Supplier sr, App\Entity\Supply s, App\Entity\Stock st WHERE si.stock = st.id AND si.supplyId = s.id AND s.supplier = sr.id AND s.id = :id AND si.userId = :user'
	        )->setParameter('id', $id)
	        ->setParameter('user', $user)
	        ->getResult();
	}

/**
	 * Find all supplies of a given stock item
	 *
	 * @param int $id Stock ID
	 * @param int $user User ID
	 **/
	public function findSupplyItemsByStock($id, $user)
	{
		return $this->getEntityManager()
		    ->createQuery(
		        'SELECT si.id as id, si.quantity as quantity, si.amount as amount, s.name as supply_name, s.id as supply_id, sr.name as supplier, sr.id as supplier_id, s.date as date FROM App\Entity\SupplyItem si, App\Entity\Supplier sr, App\Entity\Supply s, App\Entity\Stock st WHERE si.stock = st.id AND si.supplyId = s.id AND s.supplier = sr.id AND st.id = :id AND si.userId = :user'
		    )->setParameter('id', $id)
		    ->setParameter('user', $user)
		    ->getResult();
	}

public function findAllSupplyItem($user)
	{
	    return $this->getEntityManager()
	        ->createQuery(
	            'SELECT si.id as id, si.quantity as quantity, si.amount as amount, s.name as supply_name, s.id as supply_id, sr.name as supplier, s.date as date, st.name as item_name FROM App\Entity\SupplyItem si, App\Entity\Supplier sr, App\Entity\Supply s, App\Entity\Stock st WHERE si.stock = st.id AND si.supplyId = s.id AND s.supplier = sr.id AND si.userId = :user'
	        )->setParameter('user', $user)
	        ->getResult();
	}

public function findSupply($id, $user)
	{
	    return $this->getEntityManager()
	        ->createQuery(
	            'SELECT si.id as id, si.quantity as quantity, si.amount as amount, s.name as supply_name, s.id as supply_id, sr.name as supplier, s.date as date, st.name as item_name FROM App\Entity\SupplyItem si, App\Entity\Supplier sr, App\Entity\Supply s, App\Entity\Stock st WHERE si.stock = st.id AND si.supplyId = s.id AND s.supplier = sr.id AND s.id = :id AND si.userId = :user'
	        )->setParameter('id', $id)
	        ->setParameter('user', $user)
	        ->getResult();
	}

public function findBySupply($id, $user)
	{
	    return $this->getEntityManager()
	        ->createQuery(
	            'SELECT s FROM App\Entity\SupplyItem s WHERE s.supplyId = :id AND s.userId = :user'
	        )->setParameter('id', $id)
	        ->setParameter('user', $user)
	        ->getResult();
	}

/**
	 * Delete Supply items belonging to a supply
	 * @param int $id Supply ID
	 * @param int $user User ID
	 */
	public function deleteSupplyItems($id, $user)
	{
	    return $this->getEntityManager()
	        ->createQuery(
	            'DELETE FROM App\Entity\SupplyItem s WHERE s.supplyId = :id AND s.userId = :user'
	        )->setParameter('id', $id)
	        ->setParameter('user', $user)
	        ->getResult();
	}

/**
	 * Delete Supply items belonging to a supply
	 * @param int $id Supply ID
	 * @param int $user User ID
	 */
	public function suppierItems($id, $user)
	{
	    return $this->getEntityManager()
	        ->createQuery(
	            'SELECT si.id as id, si.stock as stock, si.quantity as quantity FROM App\Entity\SupplyItem si, App\Entity\Supplier sr, App\Entity\Supply s WHERE si.supplyId = s.id AND s.supplier = sr.id AND sr.id = :id AND s.userId = :user'
	        )->setParameter('id', $id)
	        ->setParameter('user', $user)
	        ->getResult();
	}

public function findBySupplyStock($id, $user)
	{
	    return $this->getEntityManager()
	        ->createQuery(
	            'SELECT s.id as id, s.quantity as quantity, s.amount as amount, st.name as name FROM App\Entity\SupplyItem s, App\Entity\Stock st WHERE s.supplyId = :id AND s.userId = :user AND s.stock = st.id'
	        )->setParameter('id', $id)
	        ->setParameter('user', $user)
	        ->getResult();
	}

/**
	 * Find supply items by stock/inventory
	 *
	 * @param int $id Stock ID
	 * @param int $user User ID
	 **/
	public function findByStock($stockid, $user)
	{
		return $this->getEntityManager()
		    ->createQuery(
		        'SELECT si.id as id, si.quantity as quantity, si.amount as amount, st.name as name, s.name as supply_name, s.id as supply_id FROM App\Entity\SupplyItem si, App\Entity\Stock st, App\Entity\Supply s WHERE si.stock = :id AND si.supplyId = s.id AND si.userId = :user AND si.stock = st.id'
		    )->setParameter('id', $id)
		    ->setParameter('user', $user)
		    ->getResult();
	}
}

${this.title}

Code Editor : SupplyItemRepository.php