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

<?php

namespace App\Repository;

/**
 * OrderItemRepository
 *
 * This class was generated by the Doctrine ORM. Add your own custom
 * repository methods below.
 */
class OrderItemRepository extends \Doctrine\ORM\EntityRepository
{
	// Select all the items in an order
	public function findOrder($id, $user)
	{
	    return $this->getEntityManager()
	        ->createQuery(
	            'SELECT i.name as name, oi.price as price, oi.discount as discount, oi.quantity as quantity FROM App\Entity\OrderItem oi, App\Entity\Item i WHERE oi.orderId = :orderId AND oi.itemId = i.id AND oi.userId = :user'
	        )->setParameter('orderId', $id)
	        ->setParameter('user', $user)
	        ->getResult();
	}

// Delete item belonging to an order
	public function deleteOrderItem($orderid, $itemid, $user)
	{
	    return $this->getEntityManager()
	        ->createQuery(
	            'DELETE FROM App\Entity\OrderItem oi WHERE oi.orderId = :orderId AND oi.itemId = :itemId AND oi.userId = :user'
	        )->setParameter('orderId', $orderid)
	        ->setParameter('itemId', $itemid)
	        ->setParameter('user', $user)
	        ->getResult();
	}

// Delete items from an order
	public function deleteOrderItems($id, $user)
	{
	    return $this->getEntityManager()
	        ->createQuery(
	            'DELETE FROM App\Entity\OrderItem oi WHERE oi.orderId = :id AND oi.userId = :user'
	        )->setParameter('id', $id)
	        ->setParameter('user', $user)
	        ->getResult();
	}

// Find order item
	public function findItem($id, $user)
	{
	    return $this->getEntityManager()
	        ->createQuery(
	            'SELECT oi FROM App\Entity\OrderItem oi WHERE oi.itemId = :id AND oi.userId = :user'
	        )->setParameter('id', $id)
	        ->setParameter('user', $user)
	        ->getResult();
	}

// Find items by order
	public function findByOrder($id, $user)
	{
	    return $this->getEntityManager()
	        ->createQuery(
	            'SELECT oi FROM App\Entity\OrderItem oi WHERE oi.orderId = :id AND oi.userId = :user'
	        )->setParameter('id', $id)
	        ->setParameter('user', $user)
	        ->getResult();
	}

// Delete items in an order
	public function deleteByOrder($id, $user)
	{
	    return $this->getEntityManager()
	        ->createQuery(
	            'DELETE FROM App\Entity\OrderItem oi WHERE oi.orderId = :id AND oi.userId = :user'
	        )->setParameter('id', $id)
	        ->setParameter('user', $user)
	        ->getResult();
	}
}

${this.title}

Code Editor : OrderItemRepository.php