FTTH/src/FTTHBundle/Entity/NAP.php

<?php

namespace FTTHBundle\Entity;

use Base\AdminBundle\Traits\TenancyIdTrait;
use Base\AdminBundle\Traits\TenancyIdTraitInterface;
use Doctrine\ORM\Mapping as ORM;
use ExtraDataBundle\Entity\Traits\ExtraDataWithParentTrait;
use MapBundle\Entity\Interfaces\LocationInterface;
use MapBundle\Entity\Traits\LocationTrait;
use Symfony\Component\DependencyInjection\ContainerInterface;
use Symfony\Component\Validator\Constraints as Assert;

/**
 * @ORM\Table
 * @ORM\Entity
 */
class NAP implements TenancyIdTraitInterface, LocationInterface
{

    use ExtraDataWithParentTrait;
    use ONUTrait;
    use TenancyIdTrait;
    use LocationTrait;

    // Cantidad máxima de ONU por NAP
    const MAX_NUMBER_ONU = 64;

    /**
     * @var int
     *
     * @ORM\Column(name="id", type="integer")
     * @ORM\Id
     * @ORM\GeneratedValue(strategy="AUTO")
     */
    private $id;

    /**
     * @var string
     *
     * @ORM\Column(type="string", length=255)
     *
     * @Assert\NotNull
     */
    private $name;

    /**
     * @ORM\ManyToOne(targetEntity="NAP", fetch="EXTRA_LAZY")
     */
    protected $parent;

    /**
     * @ORM\OneToMany(targetEntity="ONU", mappedBy="nap", fetch="EXTRA_LAZY")
     */
    protected $onus;
    /**
     * @var ContainerInterface
     */
    private $container;


    /**
     * @return string
     */
    public function __toString()
    {
        return (string)$this->name;
    }

    /**
     * Get id
     *
     * @return int
     */
    public function getId()
    {
        return $this->id;
    }

    /**
     * @param string $name
     *
     * @return Node
     */
    public function setName($name)
    {
        $this->name = $name;

        return $this;
    }

    /**
     * @return string
     */
    public function getName()
    {
        return $this->name;
    }

    /**
     * @return NAP
     */
    public function getParent()
    {
        return $this->parent;
    }

    /**
     * @param NAP $parent
     *
     * @return $this
     */
    public function setParent($parent = null)
    {
        $this->parent = $parent;

        return $this;
    }

    /**
     * @return ContainerInterface
     */
    public function getContainer()
    {
        return $this->container;
    }

    /**
     * @param ContainerInterface $container
     */
    public function setContainer(ContainerInterface $container)
    {
        $this->container = $container;
    }


    /**
     * @return int Retorna la cantidad de puertos libres.
     */
    public function getFreePort()
    {
        $em = $this->getContainer()->get("doctrine.orm.entity_manager");
        $query = $em->createQuery('SELECT n.id, COUNT(DISTINCT n.id) AS usedPort FROM ' . ONU::class . ' o JOIN o.nap n where n.id = ' . $this->getId());
        $onusQuery = $query->getResult();
        $freePort = $this::MAX_NUMBER_ONU;
        foreach ($onusQuery as $key => $nap) {
            if (is_numeric($nap['usedPort'])) {
                $freePort = NAP::MAX_NUMBER_ONU - $nap['usedPort'];
            }
        }
        return $freePort;
    }
}