private function getStockLevel(Part $part) { /** * @var Query $query */ $query = $this->getContainer()->get("doctrine")->getManager()->createQuery("SELECT p.stockLevel FROM PartKeeprPartBundle:Part p WHERE p.id = :id")->setParameter("id", $part->getId()); return $query->getSingleScalarResult(); }
/** * Checks if the given internal part number is unique * * @param string $internalPartNumber The internal part number to checkl * @param Part|null $part An optional part to exclude within the check * * @return bool */ public function isInternalPartNumberUnique($internalPartNumber, Part $part = null) { if (!$this->checkInternalPartNumberUniqueness) { return true; } /** * Empty internal part numbers aren't checked. If you want to require an internal part number, set the * field internalPartNumber to mandatory. */ if ($internalPartNumber == "") { return true; } $dql = 'SELECT COUNT(p) FROM PartKeepr\\PartBundle\\Entity\\Part p WHERE p.internalPartNumber = :internalPartNumber'; if ($part !== null) { $dql .= " AND p.id != :partId"; } $query = $this->entityManager->createQuery($dql)->setParameter('internalPartNumber', $internalPartNumber); if ($part !== null) { $query->setParameter('partId', $part->getId()); } return $query->getSingleScalarResult() == 0 ? true : false; }