} //end class SiteMap defined('APPLICATION_PATH') || define('APPLICATION_PATH', realpath(dirname(__FILE__) . '/..')); set_include_path(implode(PATH_SEPARATOR, array(realpath(APPLICATION_PATH . '/vendor/zendframework/zendframework/library'), get_include_path()))); require_once 'Zend/Loader/StandardAutoloader.php'; $config = (include APPLICATION_PATH . '/config/autoload/global.php'); $autoLoader = new Zend\Loader\StandardAutoloader(array('prefixes' => array('MyVendor' => '/vendor/zendframework/zendframework/library/Zend'), 'fallback_autoloader' => true)); // register our StandardAutoloader with the SPL autoloader $autoLoader->register(); $adapter = new \Zend\Db\Adapter\Adapter($config['db']); $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);