$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;
