Proyectos de Subversion LeadersLinked - Backend

<?php

declare(strict_types=1);

namespace LeadersLinked\Command;

use Symfony\Component\Console\Command\Command;

use Symfony\Component\Console\Input\InputInterface;

use Symfony\Component\Console\Output\OutputInterface;

use Laminas\Db\Adapter\AdapterInterface;

use Laminas\Log\LoggerInterface;

use GeoIp2\Database\Reader As GeoIp2Reader;

use LeadersLinked\Library\Functions;

use LeadersLinked\Mapper\CompanyServiceMapper;

use LeadersLinked\Mapper\DiscoveryContactInteractionTypeMapper;

use LeadersLinked\Model\Service;

use LeadersLinked\Model\DiscoveryContactInteractionType;

use LeadersLinked\Mapper\DiscoveryContactLogMapper;

use LeadersLinked\Mapper\DiscoveryContactMapper;

use LeadersLinked\Mapper\DiscoveryContactInteractionMapper;

use LeadersLinked\Model\DiscoveryContactLog;

use LeadersLinked\Hydrator\ObjectPropertyHydrator;

use LeadersLinked\Mapper\QueryMapper;

use Laminas\Db\Sql\Expression;

class DuplicateDiscoveryContactCommand extends Command

{

    /**

     *

     * @var \Laminas\Db\Adapter\AdapterInterface

     */

    private $adapter;

    /**

     *

     * @var \LeadersLinked\Cache\CacheInterface

     */

    private $cache;

    /**

     *

     * @var \Laminas\Log\LoggerInterface

     */

    private $logger;

    /**

     *

     * @var array

     */

    private $config;

    /**

     *

     * @var \Laminas\Mvc\I18n\Translator

     */

    private $translator;

    /**

     *

     * @param \Laminas\Db\Adapter\AdapterInterface $adapter

     * @param \LeadersLinked\Cache\CacheInterface $cache

     * @param \Laminas\Log\LoggerInterface

     * @param array $config

     * @param \Laminas\Mvc\I18n\Translator $translator

     */

    public function __construct($adapter, $cache, $logger, $config, $translator)

    {

        $this->adapter      = $adapter;

        $this->cache        = $cache;

        $this->logger       = $logger;

        $this->config       = $config;

        $this->translator   = $translator;

        parent::__construct();

    }

    protected function execute(InputInterface $input, OutputInterface $output) : int

    {

        $output->writeln('Inicio del proceso');

        $queryMapper = QueryMapper::getInstance($this->adapter);

        $select = $queryMapper->getSql()->select();

        $select->from(DiscoveryContactMapper::_TABLE);

        $select->columns(['corporate_email']);

        $select->group('corporate_email');

        $select->having('COUNT(*) > 1');

        $records = $queryMapper->fetchAll($select);

        $output->writeln('hay ' . count($records) . ' registro(s) duplicado(s)');

        foreach($records as $record)

        {

            $sentence = 'DELETE FROM ' . DiscoveryContactMapper::_TABLE .

            ' WHERE corporate_email = :corporate_email ORDER BY id DESC LIMIT 1';

            $queryMapper->delete($sentence, [':corporate_email' => $record['corporate_email'] ]);

        }

        //echo $select->getSqlString($this->adapter->platform); exit;

        $output->writeln('Fin del proceso');

        return 0;

    }

}