HuaweiBundle/Command/HuaweiOnuOctetsCommand.php

<?php

namespace HuaweiBundle\Command;

use BaseStatsBundle\Command\BaseCommand;
use Symfony\Bundle\FrameworkBundle\Command\ContainerAwareCommand;
use Symfony\Component\Console\Input\InputOption;
use Symfony\Component\Console\Input\InputInterface;
use Symfony\Component\Console\Output\OutputInterface;
use HuaweiBundle\SNMP\SNMP as SNMP;
//use RedisBundle\Services\RedisService;

class HuaweiOnuOctetsCommand extends BaseCommand
{

    protected function configure()
    {
        $this
            ->setName('huawei:onu:octets')
            ->setDescription('Bandwidth ONTs de OLT')
            ->setHelp('Se requieren parámetros para poder realizar la correcta consulta. El comando requiere Redis.')
            ->setDefinition(array(
                new InputOption('olt-device-id', null, InputOption::VALUE_OPTIONAL, "DeviceId de la OLT",1),
                new InputOption('olt-server-id', null, InputOption::VALUE_OPTIONAL, "ServerDevice de la OLT",1),
                new InputOption('olt-ip', false, InputOption::VALUE_OPTIONAL, "IP de la OLT"),
                new InputOption('olt-community', false, InputOption::VALUE_OPTIONAL, "COMMUNITY de la OLT"),
                new InputOption('olt-snmp-library', false, InputOption::VALUE_OPTIONAL, "Versión de librería SNMP"),
                new InputOption('save-historic', null, InputOption::VALUE_OPTIONAL, "Send data to StatsD",1)
            ))
        ;
    }

    /**
     * @param InputInterface $input
     * @param OutputInterface $output
     */
    protected function execute(InputInterface $input, OutputInterface $output)
    {
        parent::execute($input, $output);
        
        $key_olt_scan = "olt_scan_{$this->d_s}";
        $key_olt_onu_bandwidth = "olt_bandwidth_onu_{$this->d_s}";
        $saveHistoric = (int) $input->getOption('save-historic');
        $inicio = microtime(true);

        $SNMP = new SNMP($this->oltIp, $this->oltCommunity);
        $library = "use".$this->oltSnmpLibrary;
        $this->apiSNMP = $SNMP->$library();
        
        $dataCached = $this->getData($key_olt_scan, true);
        $bandwidthCached = $this->getData($key_olt_onu_bandwidth, true);

        if(empty($dataCached)) {
            $this->output->writeln("Se requiere {$key_olt_scan}.");
            $this->removeLock($this->flag);
            return true;
        }

        //counter64
        $inOctets = $this->getSNMP("onuInOctets","onuInOctets");
        $outOctets = $this->getSNMP("onuOutOctets","onuOutOctets");

        $consumptionData = $sendData = array();

        $subId = $this->d_s;
        
        $t1 = time();
        $totalConsOut = $totalConsIn = $totalIn = $totalOut = 0;
        foreach($dataCached as $index => $onu) {
            $inDiff = $outDiff = 0;
            $sn = $onu["serialNumber"];
            
            (isset($inOctets[$index]))? $in1 = $inOctets[$index] : $in1 = 0;
            (isset($outOctets[$index]))? $out1 = $outOctets[$index] : $out1 = 0;

            if(isset($bandwidthCached[$index])) {
                $t0 = $bandwidthCached[$index]['t'];
                $in0 = $bandwidthCached[$index]['inOct'];
                $out0 = $bandwidthCached[$index]['outOct'];
                $inAcc = $bandwidthCached[$index]['inAcc'];
                $outAcc = $bandwidthCached[$index]['outAcc'];

                $inBandwidth = $outBandwidth = 0; 
                 
                if(($in1 >= $in0) && ($t1 > $t0)) {
                    $inDiff = $diff = $in1 - $in0;
                    $inAcc += $diff;
                    $inBandwidth = ($diff / ($t1 - $t0)) * 8;
                }
                
                if(($out1 >= $out0) && ($t1 > $t0)) {
                    $outDiff = $diff = $out1 - $out0;
                    $outAcc += $diff;
                    $outBandwidth = ($diff / ($t1 - $t0)) * 8;
                }

                $totalIn += $inBandwidth;
                $totalOut += $outBandwidth;

                $sendData["inbandwidth_onu_{$sn}"] = "{$inBandwidth}|g";
                $sendData["outbandwidth_onu_{$sn}"] = "{$outBandwidth}|g";

                $div = 1073741824; //bytes => giga
                $consIn = number_format(($inAcc / $div),3,'.','');
                $consOut = number_format(($outAcc / $div),3,'.','');
                
                $sendData["inconsumption_onu_{$sn}"] = "{$consIn}|g";
                $sendData["outconsumption_onu_{$sn}"] = "{$consOut}|g";

                $div = 1073741824; //bytes => giga
                $inGB =  number_format($inDiff / $div, 5,".","");
                $outGB = number_format($outDiff / $div, 5,".","");
                $server = $this->oltServerId;
                $fatherDevice = $this->oltDeviceId;
                $fatherDeviceType = 2;
                $device = $sn;
                $date = date("Y-m-d");
                $consumptionData[] = "({$server},{$fatherDevice}, {$fatherDeviceType},'{$device}','{$date}',{$inGB},{$outGB})";

                if(date("n",$t0) != date("n",$t1)) {
                    $inAcc = $outAcc = 0;
                }

                $totalConsOut += $outAcc;
                $totalConsIn += $inAcc;
                
                $bandwidthCached[$index] = array('sn' => $sn, 't' => $t1, 'inOct' => $in1, 'outOct' => $out1, 'inAcc' => $inAcc, 'outAcc' => $outAcc, 'inBand' => $inBandwidth, 'outBand' => $outBandwidth);
            } else {
                $bandwidthCached[$index] = array('sn' => $sn, 't' => $t1, 'inOct' => $in1, 'outOct' => $out1, 'inAcc' => 0, 'outAcc' => 0, 'inBand' => 0, 'outBand' => 0);
            }
        }

        
        $this->setData($key_olt_onu_bandwidth, $bandwidthCached, true);

        $this->saveConsumption($consumptionData);
        
        if($sendData && $saveHistoric) {
            $t_start_script = microtime(true); 
            $statsdService = $this->getContainer()->get('statsd');
            $statsdService->send($sendData);
            $t_end_script = microtime(true); 
            $time = $t_end_script - $t_start_script;
            print_r("Tiempo de envío al StatsD: {$time} ms / Cantidad: ".count($sendData).PHP_EOL);
        }

        /* Fin de bloqueo */
        $this->removeLock($this->flag);

        $fin = microtime(true);
        $time = $fin - $inicio;
        $this->output->writeln("Tiempo: $time segundos");
        
    }

    /**
     * @param array $data
     */
    function saveConsumption($data)
    {
        if ($data) {
            $query = "INSERT LOW_PRIORITY INTO `device_consumption` (`server_id`, `father_device_id`, `father_device_type`, `device`, `date`,`cons_in`,`cons_out`) VALUES " . implode(",", $data) . " ON DUPLICATE KEY UPDATE cons_out = cons_out + VALUES(cons_out), cons_in = cons_in + VALUES(cons_in);";
            $this->executeQueries(array($query));
            
        }
    }

}