PonPortAdmin.php 6.7 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176
  1. <?php
  2. namespace StatsBundle\Admin;
  3. use Base\AdminBundle\Admin\BaseAdmin;
  4. use Sonata\AdminBundle\Datagrid\DatagridMapper;
  5. use Sonata\AdminBundle\Datagrid\ListMapper;
  6. use Sonata\AdminBundle\Form\FormMapper;
  7. use Sonata\AdminBundle\Show\ShowMapper;
  8. use DeviceBundle\Utils\DeviceTypes;
  9. use Symfony\Component\Form\Extension\Core\Type\ChoiceType;
  10. use Sonata\AdminBundle\Route\RouteCollection;
  11. class PonPortAdmin extends BaseAdmin
  12. {
  13. /**
  14. * @param DatagridMapper $datagridMapper
  15. */
  16. protected function configureDatagridFilters(DatagridMapper $datagridMapper)
  17. {
  18. $em = $this->get("doctrine.orm.entity_manager");
  19. $deviceServer = $this->getParameter("device_server_base");
  20. $olts = $em->getRepository("StatsBundle:device")->findBy(array('deviceServer' => $deviceServer, 'deviceType' => 'FTTHBundle\Entity\OLT'));
  21. $choices = array();
  22. foreach($olts as $olt) {
  23. $data = $olt->jsonExtraData();
  24. $name = null;
  25. (isset($data['name']))? $name = $data['name'] : $name = $olt->getIp();
  26. $choices[$name] = $olt->getDeviceId();
  27. }
  28. $datagridMapper
  29. ->add('oltDeviceId', 'doctrine_orm_string', array(), 'choice', array('choices' => $choices))
  30. ->add('deviceServer')
  31. ->add('tenancyId')
  32. ->add('ponPort')
  33. ;
  34. }
  35. /**
  36. * @param ListMapper $listMapper
  37. */
  38. protected function configureListFields(ListMapper $listMapper)
  39. {
  40. $em = $this->get("doctrine.orm.entity_manager");
  41. $servers = $em->getRepository("StatsBundle:DeviceServer")->findAll();
  42. $olts_server = $urls_server = array();
  43. foreach($servers as $deviceServer) {
  44. $urls = $this->get('webservice')->getData($deviceServer->getUrl());
  45. $urls_server[$deviceServer->getId()] = $urls;
  46. $olts = $em->getRepository("StatsBundle:device")->findBy(array('deviceServer'=>$deviceServer, 'deviceType' => 'FTTHBundle\Entity\OLT'));
  47. $olts_server[$deviceServer->getId()] = array();
  48. foreach($olts as $olt) {
  49. $data = $olt->jsonExtraData();
  50. $name = null;
  51. if(isset($data['name'])) $name = $data['name'];
  52. $olts_server[$deviceServer->getId()][$olt->getDeviceId()] = $name;
  53. }
  54. }
  55. //print_r($urls_server);die;
  56. $this->parameters = array('urls_server' => $urls_server, 'olts_server' => $olts_server);
  57. $listMapper
  58. ->add('deviceServer')
  59. ->add('oltDeviceId', 'string', array('template' => 'StatsBundle:Onu:base_list_field_olt.html.twig'))
  60. //->add('tenancyId')
  61. ->addIdentifier('ponPort')
  62. ->add('txPower', 'string', array('template' => 'StatsBundle:Onu:base_list_field_tx.html.twig'))
  63. ->add('arrayRxPower', 'ponport-rx-power', array('template' => 'StatsBundle:PonPort:base_list_field_rx.html.twig'))
  64. ->add('voltage', 'string', array('template' => 'StatsBundle:Onu:base_list_field_voltage.html.twig'))
  65. ->add('temperature', 'string', array('template' => 'StatsBundle:Onu:base_list_field_temperature.html.twig'))
  66. ->add('biasCurrent')
  67. /* ->add('updated') */
  68. ;
  69. }
  70. /**
  71. * @param FormMapper $formMapper
  72. */
  73. protected function configureFormFields(FormMapper $formMapper)
  74. {
  75. }
  76. /**
  77. * @param ShowMapper $showMapper
  78. */
  79. protected function configureShowFields(ShowMapper $showMapper)
  80. {
  81. $ponPort = $this->getSubject();
  82. $oltDeviceId = $ponPort->getOltDeviceId();
  83. $deviceServer = $ponPort->getDeviceServer();
  84. $em = $this->get("doctrine.orm.entity_manager");
  85. $q = $em->getRepository("StatsBundle:Onu")->createQueryBuilder('o');
  86. $onus = $q->where($q->expr()->like('o.ponPort', ':ponPort'))
  87. ->andWhere('o.oltDeviceId = :oltDeviceId')
  88. ->andWhere('o.deviceServer = :deviceServer')
  89. ->setParameter('ponPort', "{$ponPort->getPonPort()}%")
  90. ->setParameter('oltDeviceId', $oltDeviceId)
  91. ->setParameter('deviceServer', $deviceServer)
  92. ->getQuery()
  93. ->getResult();
  94. $onuPonPorts = $_onus = array();
  95. if($onus) {
  96. $onuPonPorts = $ponPort->getArrayRxPower();
  97. }
  98. foreach($onus as $onu) {
  99. $p = $onu->getPonPort();
  100. $data = explode("/",$p);
  101. $onuIdIndex = 2;
  102. if(count($data) == 4) $onuIdIndex = 3;
  103. if(isset($data[$onuIdIndex])) {
  104. $rxPower = NULL;
  105. if(isset($onuPonPorts[$data[$onuIdIndex]])) {
  106. $rxPower = $onuPonPorts[$data[$onuIdIndex]];
  107. }
  108. $_onus[$data[$onuIdIndex]] = array('onu' => $onu, 'rxPower' => $rxPower);
  109. }
  110. }
  111. ksort($_onus);
  112. $this->parameters = array('onus' => $_onus);
  113. $olt = $em->getRepository("StatsBundle:device")->findOneBy(array('deviceId' => $oltDeviceId, 'deviceServer'=>$deviceServer, 'deviceType' => 'FTTHBundle\Entity\OLT'));
  114. if($olt) {
  115. $data = $olt->jsonExtraData();
  116. $oltName = null;
  117. if(isset($data['name'])) $oltName = $data['name'];
  118. }
  119. $showMapper
  120. ->add('oltDeviceId', 'string', array('template' => 'StatsBundle:Onu:base_show_field_olt.html.twig','oltName' => $oltName))
  121. /* ->add('ponSerialNumber') */
  122. ->add('ponPort')
  123. ->add('txPower', 'string', array('template' => 'StatsBundle:Onu:base_show_field_tx.html.twig'))
  124. /* ->add('rxPower', 'string', array('template' => 'StatsBundle:Onu:base_show_field_rx.html.twig')) */
  125. ->add('voltage', 'string', array('template' => 'StatsBundle:Onu:base_show_field_voltage.html.twig'))
  126. ->add('temperature', 'string', array('template' => 'StatsBundle:Onu:base_show_field_temperature.html.twig'))
  127. ->add('biasCurrent')
  128. /* ->add('updated', 'string', array('template' => 'StatsBundle:Onu:base_show_field_uptime.html.twig')) */
  129. ;
  130. }
  131. /**
  132. * @param string $action
  133. * @param Object $object
  134. *
  135. * @return array
  136. */
  137. public function configureActionButtons($action, $object = null)
  138. {
  139. $actions = parent::configureActionButtons($action, $object);
  140. if($action == "show") {
  141. $actions['show_in_map'] = array('template' => 'StatsBundle:PonPort:map_button.html.twig');
  142. }
  143. return $actions;
  144. }
  145. protected function configureRoutes(RouteCollection $collection)
  146. {
  147. $collection->remove('delete');
  148. $collection->remove('create');
  149. $collection->remove('edit');
  150. }
  151. }