Proyectos de Subversion LeadersLinked - Services

//use Symfony\Component\Console\Input\InputOption;

//use Symfony\Component\Console\Input\InputOption;

use Symfony\Component\Console\Output\OutputInterface;

use Symfony\Component\Console\Output\OutputInterface;

use Laminas\Db\Adapter\AdapterInterface;

use Laminas\Db\Adapter\AdapterInterface;

use LeadersLinked\Mapper\CompanyMicrolearningSlideMapper;

use LeadersLinked\Mapper\MicrolearningSlideMapper;

use LeadersLinked\Model\CompanyMicrolearningUserProgress;

use LeadersLinked\Model\MicrolearningUserProgress;

use Laminas\Mvc\I18n\Translator;

use Laminas\Mvc\I18n\Translator;

use LeadersLinked\Cache\CacheInterface;

use LeadersLinked\Cache\CacheInterface;

        $output->writeln('Comenzamos a buscar los registros duplicados de los Tópicos');

        $output->writeln('Comenzamos a buscar los registros duplicados de los Tópicos');

        $sql  = " SELECT DISTINCT(user_id) AS user_id FROM " . CompanyMicrolearningUserProgressMapper::_TABLE;

        $sql  = " SELECT DISTINCT(user_id) AS user_id FROM " . MicrolearningUserProgressMapper::_TABLE;

        echo $sql . PHP_EOL;

        echo $sql . PHP_EOL;

        foreach($record_users as $record_user)

        foreach($record_users as $record_user)

        {

        {

            $user_id = $record_user['user_id'];

            $user_id = $record_user['user_id'];

            $sql  = " SELECT DISTINCT(topic_id) AS topic_id FROM " . CompanyMicrolearningUserProgressMapper::_TABLE;

            $sql  = " SELECT DISTINCT(topic_id) AS topic_id FROM " . MicrolearningUserProgressMapper::_TABLE;

            echo $sql . PHP_EOL;

            echo $sql . PHP_EOL;

            $records_topic = $queryMapper->fetchAllUsingParameters($sql);

            $records_topic = $queryMapper->fetchAllUsingParameters($sql);

            foreach($records_topic as $record_topic)

            foreach($records_topic as $record_topic)

                $sql  = " SELECT id FROM " . CompanyMicrolearningUserProgressMapper::_TABLE;

                $sql  = " SELECT id FROM " . MicrolearningUserProgressMapper::_TABLE;

                $sql .= " WHERE  type = '" . CompanyMicrolearningUserProgress::TYPE_TOPIC . "' ";

                $sql .= " WHERE  type = '" . MicrolearningUserProgress::TYPE_TOPIC . "' ";

                $sql .= " AND user_id = $user_id";

                $sql .= " AND user_id = $user_id";

        $output->writeln('Comenzamos a buscar los registros duplicados de las Capsulas');

        $output->writeln('Comenzamos a buscar los registros duplicados de las Capsulas');

        $sql  = " SELECT DISTINCT(user_id) AS user_id FROM " . CompanyMicrolearningUserProgressMapper::_TABLE;

        $sql  = " SELECT DISTINCT(user_id) AS user_id FROM " . MicrolearningUserProgressMapper::_TABLE;

        echo $sql . PHP_EOL;

        echo $sql . PHP_EOL;

        foreach($record_users as $record_user)

        foreach($record_users as $record_user)

        {

        {

            $user_id = $record_user['user_id'];

            $user_id = $record_user['user_id'];

            $sql  = " SELECT DISTINCT(capsule_id) AS capsule_id FROM " . CompanyMicrolearningUserProgressMapper::_TABLE;

            $sql  = " SELECT DISTINCT(capsule_id) AS capsule_id FROM " . MicrolearningUserProgressMapper::_TABLE;

            echo $sql . PHP_EOL;

            echo $sql . PHP_EOL;

            $records_capsule = $queryMapper->fetchAllUsingParameters($sql);

            $records_capsule = $queryMapper->fetchAllUsingParameters($sql);

            foreach($records_capsule as $record_capsule)

            foreach($records_capsule as $record_capsule)

                $sql  = " SELECT id FROM " . CompanyMicrolearningUserProgressMapper::_TABLE;

                $sql  = " SELECT id FROM " . MicrolearningUserProgressMapper::_TABLE;

                $sql .= " WHERE  type = '" . CompanyMicrolearningUserProgress::TYPE_CAPSULE . "' ";

                $sql .= " WHERE  type = '" . MicrolearningUserProgress::TYPE_CAPSULE . "' ";

                $sql .= " AND user_id = $user_id";

                $sql .= " AND user_id = $user_id";

        $output->writeln('Comenzamos a buscar los registros duplicados de las Diapositivas');

        $output->writeln('Comenzamos a buscar los registros duplicados de las Diapositivas');

        $sql  = " SELECT DISTINCT(user_id) AS user_id FROM " . CompanyMicrolearningUserProgressMapper::_TABLE;

        $sql  = " SELECT DISTINCT(user_id) AS user_id FROM " . MicrolearningUserProgressMapper::_TABLE;

        echo $sql . PHP_EOL;

        echo $sql . PHP_EOL;

        foreach($record_users as $record_user)

        foreach($record_users as $record_user)

        {

        {

            $user_id = $record_user['user_id'];

            $user_id = $record_user['user_id'];

            $sql  = " SELECT DISTINCT(slide_id) AS slide_id FROM " . CompanyMicrolearningUserProgressMapper::_TABLE;

            $sql  = " SELECT DISTINCT(slide_id) AS slide_id FROM " . MicrolearningUserProgressMapper::_TABLE;

            echo $sql . PHP_EOL;

            echo $sql . PHP_EOL;

            $records_slides = $queryMapper->fetchAllUsingParameters($sql);

            $records_slides = $queryMapper->fetchAllUsingParameters($sql);

            foreach($records_slides as $record_slide)

            foreach($records_slides as $record_slide)

                $sql  = " SELECT id FROM " . CompanyMicrolearningUserProgressMapper::_TABLE;

                $sql  = " SELECT id FROM " . MicrolearningUserProgressMapper::_TABLE;

                $sql .= " WHERE  type = '" . CompanyMicrolearningUserProgress::TYPE_SLIDE . "' ";

                $sql .= " WHERE  type = '" . MicrolearningUserProgress::TYPE_SLIDE . "' ";

                $sql .= " AND user_id = $user_id";

                $sql .= " AND user_id = $user_id";

        }

        }

        $output->writeln('Terminamos de procesar los registros duplicados de las Diapositivas');

        $output->writeln('Terminamos de procesar los registros duplicados de las Diapositivas');

        $progressMapper = CompanyMicrolearningUserProgressMapper::getInstance($this->adapter);

        $progressMapper = MicrolearningUserProgressMapper::getInstance($this->adapter);

        $slideMapper = CompanyMicrolearningSlideMapper::getInstance($this->adapter);

        $slideMapper = MicrolearningSlideMapper::getInstance($this->adapter);

        $output->writeln('Recalculo del progreso de los Tópicos');

        $records = $progressMapper->fetchAllTopics();

        $output->writeln('Recalculo del progreso de los Tópicos');

       // print_r($records); exit;

        $records = $progressMapper->fetchAllTopics();

        {   $total_slides = $slideMapper->fetchTotalCountByCompanyIdAndTopicId($record->company_id,$record->topic_id);

        {   $total_slides = $slideMapper->fetchTotalCountByCompanyIdAndTopicId($record->company_id,$record->topic_id);

            $view_slides = $progressMapper->fetchCountAllSlideCompletedByUserIdAndTopicId($record->user_id, $record->topic_id);

            $view_slides = $progressMapper->fetchCountAllSlideCompletedByUserIdAndTopicId($record->user_id, $record->topic_id);

            $record->total_slides = $total_slides;

            $record->total_slides = $total_slides;

            $record->view_slides = $view_slides;

            $record->view_slides = $view_slides;

            $record->total_slides = $total_slides;

            $record->total_slides = $total_slides;

            $record->view_slides = $view_slides;

            $record->view_slides = $view_slides;

            $record->progress = $total_slides > 0 ? (($view_slides * 100) / $total_slides) : 0;

            $record->progress = $total_slides > 0 ? (($view_slides * 100) / $total_slides) : 0;

            $sql  = " UPDATE  " . CompanyMicrolearningUserProgressMapper::_TABLE;

            $sql  = " UPDATE  " . MicrolearningUserProgressMapper::_TABLE;

            $sql .= " SET progress =  " . $record->progress; 

            $sql .= " SET progress =  " . $record->progress; 

            $sql .= " , total_slides =  " . $total_slides; 

            $sql .= " , total_slides =  " . $total_slides; 

            $sql .= " , view_slides  =  " . $view_slides; 

            $sql .= " , view_slides  =  " . $view_slides;