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;
}
