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 : ItemPartRepository.php

<?php

namespace App\Repository;

/**
 * ItemPartRepository
 *
 * This class was generated by the Doctrine ORM. Add your own custom
 * repository methods below.
 */
class ItemPartRepository extends \Doctrine\ORM\EntityRepository
{
	// Find all the parts and portions of an item 
	public function findItem($id, $user)
	{
	    return $this->getEntityManager()
	        ->createQuery(
	            'SELECT DISTINCT ip.id as id, s.name as name, ip.portion as portions FROM App\Entity\Item i, App\Entity\Stock s, App\Entity\ItemPart ip WHERE s.id = ip.stockId AND i.id = ip.itemId AND i.id = :id AND ip.userId = :user'
	        )->setParameter('id', $id)
	        ->setParameter('user', $user)
	        ->getResult();
	}

// 
	public function findByItem($id, $user)
	{
	    return $this->getEntityManager()
	        ->createQuery(
	            'SELECT ip FROM App\Entity\ItemPart ip WHERE ip.itemId = :id AND ip.userId = :user'
	        )->setParameter('id', $id)
	        ->setParameter('user', $user)
	        ->getResult();
	}

public function deleteByItem($id, $user)
	{
	    return $this->getEntityManager()
	        ->createQuery(
	            'DELETE FROM App\Entity\ItemPart ip WHERE ip.itemId = :id AND ip.userId = :user'
	        )->setParameter('id', $id)
	        ->setParameter('user', $user)
	        ->getResult();
	}

// 
	public function findByStock($id, $user)
	{
	    return $this->getEntityManager()
	        ->createQuery(
	            'SELECT ip FROM App\Entity\ItemPart ip WHERE ip.stockId = :id AND ip.userId = :user'
	        )->setParameter('id', $id)
	        ->setParameter('user', $user)
	        ->getResult();
	}

public function deleteByStock($id, $user)
	{
	    return $this->getEntityManager()
	        ->createQuery(
	            'DELETE FROM App\Entity\ItemPart ip WHERE ip.stockId = :id AND ip.userId = :user'
	        )->setParameter('id', $id)
	        ->setParameter('user', $user)
	        ->getResult();
	}
}

${this.title}

Code Editor : ItemPartRepository.php