$baseUrl = $config['host']['base']; $avisoSitemapCount = 1; $sm = new SiteMap($baseUrl, APPLICATION_PATH . '/public/'); $sm->sitemapIndexFileName = 'sitemap_index.xml'; $sm->sitemapFileName = 'platos' . str_pad($avisoSitemapCount, 2, '0', STR_PAD_LEFT) . '_sitemap.xml'; $sm->init(); $platos = $adapter->query('SELECT ta_plato.in_id,ta_plato.va_nombre,tr.va_nombre AS restaurante FROM ta_plato LEFT JOIN `ta_plato_has_ta_local` AS `pl` ON `pl`.`ta_plato_in_id` = `ta_plato`.`in_id` LEFT JOIN `ta_local` AS `tl` ON `tl`.`in_id` = `pl`.`ta_local_in_id` LEFT JOIN `ta_restaurante` AS `tr` ON `tr`.`in_id` = `tl`.`ta_restaurante_in_id` WHERE ta_plato.en_estado=1 AND tr.en_estado=1 GROUP BY in_id', $adapter::QUERY_MODE_EXECUTE); include APPLICATION_PATH . '/module/Application/src/Application/View/Helper/CanonicalUrl.php'; include APPLICATION_PATH . '/module/Application/src/Application/View/Helper/Canonical.php'; $crul = new Application\View\Helper\CanonicalUrl(); $limpiando = new Application\View\Helper\Canonical(); foreach ($platos as $plato) { $platourl = $crul($limpiando($plato->va_nombre), array('suffix' => $plato->in_id)); $restauranteurl = $crul($limpiando($plato->restaurante)); $sm->addUrl($baseUrl . '/plato/' . $restauranteurl . '/' . $platourl); } $sm->updateRobots(); $result = $sm->send(); print_r($result); $sm->done(); echo "\nUso de memoria: " . number_format(memory_get_peak_usage() / (1024 * 1024), 2) . "MB\n"; $time2 = explode(" ", microtime()); $time2 = $time2[1]; echo "\nTiempo de ejecución: " . number_format($time2 - $time) . "s\n"; die;