protected function execute(InputInterface $input, OutputInterface $output)
{
set_time_limit(0);
ini_set("memory_limit", "-1");
$container = $this->getContainer();
$em = $this->getContainer()->get('doctrine')->getManager();
$em->createQuery('DELETE FROM AppBundle:Log l')->execute();
// Удаляем старые логи
$log = new Log();
$log->setTitle('Начало синхронизации');
$em->persist($log);
$em->flush($log);
$files = scandir($container->get('kernel')->getRootDir() . '/../web/upload/files');
foreach ($files as $f) {
/**
* Проверяем этот файл горящих предложений или нет
*/
$p = explode('_', $f);
if ($p[0] === 'HOT') {
$hot = $p[1];
} else {
$hot = false;
if (is_numeric($p[0])) {
$sale = $p[0];
} else {
$sale = 0;
}
}
$path = $container->get('kernel')->getRootDir() . '/../web/upload/files/' . $f;
$type = 0;
if (strripos($f, 'Gema') !== false) {
$type = 1;
}
if (strripos($f, 'VeraOlimp') !== false) {
$type = 2;
}
if (strripos($f, 'Rosvero') !== false) {
$type = 3;
}
if (strripos($f, 'Gallery_3x6') !== false) {
$type = 4;
}
if (strripos($f, 'Gallery_scroll') !== false) {
$type = 5;
}
if (strripos($f, 'Gallery_roller') !== false) {
$type = 6;
}
// if ($type != 0){
// $em->createQuery('DELETE AppBundle:Banner b WHERE b.company_id = '.$type)->execute(); // Удаляем старые логи
// }
if ($type != 0) {
$log = new Log();
$log->setTitle('Синхронизация ' . $f);
$em->persist($log);
$em->flush($log);
}
if ($type == 1) {
$log = new Log();
$log->setTitle('Опа');
$em->persist($log);
$em->flush($log);
$parser = new GemaParser($em, $container, $path);
try {
$parser->parserGema1Action($hot);
} catch (\Exception $e) {
if ($type != 0) {
$log = new Log();
$log->setTitle($f . ' Строка: ' . $e->getLine() . '. ' . $e->getMessage());
$em->persist($log);
$em->flush($log);
}
}
}
if ($type == 2) {
$parser = new VeraParser($em, $container, $path);
try {
$parser->parserVera1Action($hot);
$parser->parserVera2Action($hot);
$parser->parserVera3Action($hot);
$parser->parserVera4Action($hot);
$parser->parserVera5Action($hot);
$parser->parserVera6Action($hot);
$parser->parseImageAction();
// $output->write($sale);
// if ($sale != 0){
// $company = $em->getRepository('AppBundle:Company')->findOneByTitle('Вера Олимп');
// if ($company == null){
// $company = new Company();
// $company->setTitle('Вера Олимп');
// $em->persist($company);
// $em->flush($company);
// $em->refresh($company);
// }
// $city = $em->getRepository('AppBundle:City')->findOneById(1);
// for ($i = 1; $i <= 12 ; $i ++){
// $date = new \DateTime('2015-'.$i.'-01 00:00:00');
// $month = $em->getRepository('AppBundle:Sale')->findOneBy(array('date' => $date, 'company' => $company, 'city' => $city));
// if (!$month){
//
// $month = new Sale();
// $month->setCity($city);
// $month->setDate($date);
// $month->setCompany($company);
// $month->setPercent($sale);
// $em->persist($month);
// $em->flush($month);
// }
// }
// }
} catch (\Exception $e) {
echo $f . ' Строка: ' . $e->getLine() . '. ' . $e->getMessage();
if ($type != 0) {
$log = new Log();
$log->setTitle('<span class="text-danger">' . $f . ' Строка: ' . $e->getLine() . '. ' . $e->getMessage() . '</span>');
$em->persist($log);
$em->flush($log);
}
}
}
if ($type == 3) {
$parser = new RosveroParser($em, $container, $path);
try {
$parser->parserRasvero1Action($hot);
// if ($sale != 0){
// $company = $em->getRepository('AppBundle:Company')->findOneByTitle('Расверо');
// if ($company == null){
// $company = new Company();
// $company->setTitle('Расверо');
// $em->persist($company);
// $em->flush($company);
// $em->refresh($company);
// }
// $city = $em->getRepository('AppBundle:City')->findOneById(1);
// for ($i = 1; $i <= 12 ; $i ++){
// $date = new \DateTime('2015-'.$i.'-01 00:00:00');
// $month = $em->getRepository('AppBundle:Sale')->findOneBy(array('date' => $date, 'company' => $company, 'city' => $city));
// if (!$month){
//
// $month = new Sale();
// $month->setCity($city);
// $month->setDate($date);
// $month->setCompany($company);
// $month->setPercent($sale);
// $em->persist($month);
// $em->flush($month);
// }
// }
// }
} catch (\Exception $e) {
if ($type != 0) {
$log = new Log();
$log->setTitle($f . ' Строка: ' . $e->getLine() . '. ' . $e->getFile() . '. ' . $e->getMessage());
$em->persist($log);
$em->flush($log);
}
}
}
if ($type == 4) {
$parser = new GellaryParser($em, $container, $path);
try {
$parser->parserGellary1Action($hot);
} catch (\Exception $e) {
if ($type != 0) {
$log = new Log();
$log->setTitle($f . ' Строка: ' . $e->getLine() . '. ' . $e->getMessage());
$em->persist($log);
$em->flush($log);
}
}
}
if ($type == 5) {
$parser = new GellaryParser($em, $container, $path);
try {
$parser->parserGellary2Action($hot);
} catch (\Exception $e) {
if ($type != 0) {
$log = new Log();
$log->setTitle($f . ' Строка: ' . $e->getLine() . '. ' . $e->getMessage());
$em->persist($log);
$em->flush($log);
}
}
}
if ($type == 6) {
$parser = new GellaryParser($em, $container, $path);
try {
$parser->parserGellary3Action($hot);
} catch (\Exception $e) {
if ($type != 0) {
$log = new Log();
$log->setTitle($f . ' Строка: ' . $e->getLine() . '. ' . $e->getMessage());
$em->persist($log);
$em->flush($log);
}
}
}
if ($type != 0) {
$log = new Log();
$log->setTitle('Синхронизация ' . $f . ' завершена');
$em->persist($log);
$em->flush($log);
}
}
}
/**
* @Security("has_role('ROLE_OPERATOR')")
* @Template()
*/
public function indexAction(Request $request)
{
if ($request->getMethod() == 'POST') {
$file = $request->files->get('xml');
if ($file) {
$type = $request->request->get('type');
$percent = $request->request->get('percent');
$hot = $request->request->get('hot');
if ($hot == 'on') {
$hot = true;
} else {
$hot = false;
}
$em = $this->getDoctrine()->getManager();
$path = $file->getPathName();
$container = $this->container;
if ($type == 4) {
$company = $this->getDoctrine()->getRepository('AppBundle:Company')->findOneByTitle('Gallery 3x6');
if ($company) {
$em = $this->getDoctrine()->getManager();
$em->createQuery('DELETE FROM AppBundle:Banner b WHERE b.company = ' . $company->getId())->execute();
}
$parser = new GellaryParser($em, $container, $path);
$parser->parserGellary1Action($hot);
}
if ($type == 5) {
$company = $this->getDoctrine()->getRepository('AppBundle:Company')->findOneByTitle('Gallery scroll');
if ($company) {
$em = $this->getDoctrine()->getManager();
$em->createQuery('DELETE FROM AppBundle:Banner b WHERE b.company = ' . $company->getId())->execute();
}
$parser = new GellaryParser($em, $container, $path);
$parser->parserGellary2Action($hot);
}
if ($type == 6) {
$company = $this->getDoctrine()->getRepository('AppBundle:Company')->findOneByTitle('Gallery roller');
if ($company) {
$em = $this->getDoctrine()->getManager();
$em->createQuery('DELETE FROM AppBundle:Banner b WHERE b.company = ' . $company->getId())->execute();
}
$parser = new GellaryParser($em, $container, $path);
$parser->parserGellary3Action($hot);
}
if ($type == 1) {
$company = $this->getDoctrine()->getRepository('AppBundle:Company')->findOneByTitle('Гема');
if ($company) {
$em = $this->getDoctrine()->getManager();
$em->createQuery('DELETE FROM AppBundle:Banner b WHERE b.company = ' . $company->getId())->execute();
}
$parser = new GemaParser($em, $container, $path);
$parser->parserGema1Action($hot);
}
if ($type == 3) {
$company = $this->getDoctrine()->getRepository('AppBundle:Company')->findOneByTitle('Расверо');
if ($company) {
$em = $this->getDoctrine()->getManager();
$em->createQuery('DELETE FROM AppBundle:Banner b WHERE b.company = ' . $company->getId())->execute();
}
$parser = new RosveroParser($em, $container, $path);
$parser->parserRasvero1Action($hot);
}
if ($type == 2) {
$company = $this->getDoctrine()->getRepository('AppBundle:Company')->findOneByTitle('Вера Олимп');
if ($company) {
$em = $this->getDoctrine()->getManager();
$em->createQuery('DELETE FROM AppBundle:Banner b WHERE b.company = ' . $company->getId())->execute();
}
$parser = new VeraParser($em, $container, $path);
$parser->parserVera1Action($hot);
$parser->parserVera2Action($hot);
$parser->parserVera3Action($hot);
$parser->parserVera4Action($hot);
$parser->parserVera5Action($hot);
$parser->parserVera6Action($hot);
$parser->parseImageAction();
}
}
$session = new Session();
$session->getFlashBag()->set('success', 'Загрузка завершена');
}
return array();
}