Stats/src/StatsBundle/Admin/OnuAdmin.php

<?php

namespace StatsBundle\Admin;

use Base\AdminBundle\Admin\BaseAdmin;
use Sonata\AdminBundle\Datagrid\DatagridMapper;
use Sonata\AdminBundle\Datagrid\ListMapper;
use Sonata\AdminBundle\Form\FormMapper;
use Sonata\AdminBundle\Show\ShowMapper;
use DeviceBundle\Utils\DeviceTypes;
use Symfony\Component\Form\Extension\Core\Type\ChoiceType;
use Sonata\AdminBundle\Route\RouteCollection;
use Sonata\DoctrineORMAdminBundle\Datagrid\ProxyQuery;
use Sonata\DoctrineORMAdminBundle\Filter\CallbackFilter;

class OnuAdmin extends BaseAdmin
{

    /**
     * @param DatagridMapper $datagridMapper
     */
    protected function configureDatagridFilters(DatagridMapper $datagridMapper)
    {
        $em = $this->get("doctrine.orm.entity_manager");
        $deviceServer = $this->getParameter("device_server_base");
        $olts = $em->getRepository("StatsBundle:device")->findBy(array('deviceServer' => $deviceServer, 'deviceType' => 'FTTHBundle\Entity\OLT'));

        $choices = array();
        foreach($olts as $olt) {
            $data = $olt->jsonExtraData();
            $name = null;
            (isset($data['name']))? $name = $data['name'] : $name = $olt->getIp();
            $choices[$name] = $olt->getDeviceId();
        }

        $datagridMapper
            ->add('oltDeviceId', 'doctrine_orm_string', array(), 'choice', array('choices' => $choices))
            ->add('ponSerialNumber', CallbackFilter::class, array(
                'callback' => function (ProxyQuery $query, $alias, $field, $data) {
                    if (!$data || !is_array($data) || !array_key_exists('value', $data) || !isset($data['value'])) {
                        return;
                    }

                    $alias = $query->getRootAlias();
                    $query
                        ->andWhere("{$alias}.serialNumber LIKE :id OR
                                    {$alias}.ponSerialNumber LIKE :id")
                        ->setParameter('id', "%{$data['value']}%");
                        
                    return true;
                },), null, [
                    'attr' => [
                        'placeholder' => $this->trans('sonata.filter.onu_id')
                    ]
                ])
            ->add('clientName', CallbackFilter::class, array(
                'callback' => function (ProxyQuery $query, $alias, $field, $data) {
                    if (!$data || !is_array($data) || !array_key_exists('value', $data) || !isset($data['value'])) {
                        return;
                    }

                    $alias = $query->getRootAlias();
                    $query
                        ->andWhere("{$alias}.clientExternalId LIKE :id OR
                                    {$alias}.clientAddress LIKE :id OR
                                    {$alias}.clientName LIKE :id")
                        ->setParameter('id', "%{$data['value']}%");
                        
                    return true;
                },), null, [
                    'attr' => [
                        'placeholder' => $this->trans('sonata.filter.onu_client')
                    ]
                ])
            ->add('ponPort')
            ->add('status')
        ;
    }

    /**
     * @param ListMapper $listMapper
     */
    protected function configureListFields(ListMapper $listMapper)
    {
        $em = $this->get("doctrine.orm.entity_manager");
        $servers = $em->getRepository("StatsBundle:DeviceServer")->findAll();
        
        $olts_server = $urls_server = array();

        foreach($servers as $deviceServer) {
            $urls = $this->get('webservice')->getData($deviceServer->getUrl());
            $urls_server[$deviceServer->getId()] = $urls;
            $olts = $em->getRepository("StatsBundle:device")->findBy(array('deviceServer'=>$deviceServer, 'deviceType' => 'FTTHBundle\Entity\OLT'));
            $olts_server[$deviceServer->getId()] = array();
            foreach($olts as $olt) {
                $data = $olt->jsonExtraData();
                $name = null;
                if(isset($data['name'])) $name = $data['name'];
                $olts_server[$deviceServer->getId()][$olt->getDeviceId()] = $name;
            }
        }

        $this->parameters = array('urls_server' => $urls_server, 'olts_server' => $olts_server);

        $listMapper
            ->add('oltDeviceId', 'string', array('template' => 'StatsBundle:Onu:base_list_field_olt.html.twig'))
            ->add('ponSerialNumber', 'string', array('template' => 'StatsBundle:Onu:show_link.html.twig'))
            ->add('serialNumber', 'string', array('template' => 'StatsBundle:Templates:base_list_field_upper.html.twig'))
            ->add('index')
            ->add('ponPort')
            ->add('status',null, array('template' => 'StatsBundle:Templates:field_status.html.twig'))
            ->add('txPower', 'string', array('template' => 'StatsBundle:Onu:field_tx.html.twig'))
            ->add('rxPower', 'string', array('template' => 'StatsBundle:Onu:field_rx.html.twig'))
            ->add('voltage', 'string', array('template' => 'StatsBundle:Onu:field_voltage.html.twig'))
            ->add('temperature', 'string', array('template' => 'StatsBundle:Onu:field_temperature.html.twig'))
            ->add('inOctets',null, array('template' => 'StatsBundle:Onu:field_octets.html.twig'))
            ->add('outOctets',null, array('template' => 'StatsBundle:Onu:field_octets.html.twig'))
            ->add('rxPowerOlt', 'string', array('template' => 'StatsBundle:Onu:field_rx_in_olt.html.twig'))
            ->add('uptime', 'string', array('template' => 'StatsBundle:Onu:field_uptime.html.twig'))
            ->add('clientExternalId', 'string', array('template' => 'StatsBundle:Templates:base_list_field_null.html.twig'))
            ->add('clientName', 'string', array('template' => 'StatsBundle:Templates:base_list_field_null.html.twig'))
            ->add('clientAddress', 'string', array('template' => 'StatsBundle:Templates:base_list_field_null.html.twig'))
        ;
    }

    /**
     * @param FormMapper $formMapper
     */
    protected function configureFormFields(FormMapper $formMapper)
    {
    }

    /**
     * @param ShowMapper $showMapper
     */
    protected function configureShowFields(ShowMapper $showMapper)
    {
        $from = $this->getRequest()->get('from');
        $to = $this->getRequest()->get('to');

        $this->parameters = array('from' => $from, 'to' => $to);
    }

    /**
     * @param string $action
     * @param Object $object
     * 
     * @return array
     */
    public function configureActionButtons($action, $object = null)
    {

        $actions = parent::configureActionButtons($action, $object);
        /* if($action == "list") {
            $actions['show_in_map'] = array('template' => 'StatsBundle:Onu:map_button.html.twig');
        } */
        
        return $actions;
    }

    protected function configureRoutes(RouteCollection $collection)
    {
        $collection->remove('delete');
        $collection->remove('create');
        $collection->remove('edit');
    }

}