<?php
/*
 * This file is part of the WikiTagBundle package.
 *
 * (c) IRI <http://www.iri.centrepompidou.fr/>
 *
 * For the full copyright and license information, please view the LICENSE
 * file that was distributed with this source code.
 */

namespace IRI\Bundle\WikiTagBundle\Command;

use Symfony\Bundle\FrameworkBundle\Command\ContainerAwareCommand;
use Symfony\Component\Console\Input\InputArgument;
use Symfony\Component\Console\Input\InputInterface;
use Symfony\Component\Console\Input\InputOption;
use Symfony\Component\Console\Output\OutputInterface;

class ReorderTagsCommand extends ContainerAwareCommand
{
    
    protected function configure()
    {
        parent::configure();
    
        $this
        ->setName('wikitag:reorder-tags')
        ->setDescription('Reorder tags')
        ->addOption("force","f",InputOption::VALUE_NONE, "Force all reorder");
    }
    
    
    protected function execute(InputInterface $input, OutputInterface $output)
    {
        $doctrine = $this->getContainer()->get('doctrine');
        $configuration = $doctrine->getConnection()->getConfiguration();
        $configuration->setSQLLogger(null);
        
        $force = $input->getOption('force');
        
        if($force)
        {
            $query = $doctrine->getEntityManager()->createQuery("SELECT doc from WikiTagBundle:Document doc");
            $querycount = $doctrine->getEntityManager()->createQuery("SELECT count(doc) from WikiTagBundle:Document doc");
        }
        else
        {
            $query = $doctrine->getEntityManager()->createQuery("SELECT doc from WikiTagBundle:Document doc WHERE doc.manualOrder = FALSE");
            $querycount = $doctrine->getEntityManager()->createQuery("SELECT count(doc) from WikiTagBundle:Document doc WHERE doc.manualOrder = FALSE");
        }
        
        $total = $querycount->getSingleScalarResult();
        $search_service = $this->getContainer()->get('wiki_tag.search');
        
        $done = 0;
        $iterable = $query->iterate();
        $doctrine->getEntityManager()->beginTransaction();
        while (($row = $iterable->next()) !== false)
        {
            $done++;
            $doc = $row[0];
            
            $output->writeln("Process doc id ".$doc->getId()." $done/$total ".strval(intval(floatval($done)/floatval($total)*100.0))."%");
            
            $doc->setManualOrder(false);
            $doctrine->getEntityManager()->persist($doc);
            
            $search_service->reorderTagsForDocument($doc);
            
            
            if($done%100 == 0)
            {
                $doctrine->getEntityManager()->flush();
                $doctrine->getEntityManager()->commit();
                $doctrine->getEntityManager()->clear();
                $output->writeln("memory : ".strval(memory_get_usage(true)));
                $doctrine->getEntityManager()->beginTransaction();
            }
            
        }
        
        $doctrine->getEntityManager()->commit();
        
    }

}