JL Sitemap - компонент карты сайта - страница 12 - Карта сайта

				if(!empty($this->filtering($href, $filterRaw, $filterStrpos))) continue; // effrit доп условие, иначе битые урл не фильтруются пользовательским списком 

				// Add url to arrays

$q = $db->getQuery(true)
					->select('prod.product_id, prod.product_publish, prod.access, prod.date_modify, prod.product_quantity, cat.category_id, cat.category_publish, cat.access as cat_access')
					->from($db->qn('#__jshopping_products', 'prod'))
					->innerJoin($db->qn('#__jshopping_products_to_categories', 'pr_cat') . ' ON pr_cat.product_id = prod.product_id')
					->leftJoin($db->qn('#__jshopping_categories', 'cat') . ' ON pr_cat.category_id = cat.category_id')
					->where('prod.parent_id = 0')
					->group('prod.product_id');

SET sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));
select prod.`product_id`, prod.`product_publish`, prod.`access`, prod.`date_modify`, prod.`product_quantity`, cat.`category_id`, cat.`category_publish`, cat.`access` as cat_access
from `q3j5c_jshopping_products`as prod
inner Join `q3j5c_jshopping_products_to_categories` as pr_cat ON pr_cat.`product_id` = prod.`product_id`
left Join `q3j5c_jshopping_categories` as cat ON pr_cat.`category_id` = cat.`category_id`
where prod.`parent_id` = 0
group by prod.`product_id`

					$url->loc = 'index.php?option=com_jshopping&controller=product&task=view&category_id=' . $row->category_id . '&product_id=' . $row->product_id . '&Itemid=' . $defaultItemid;

0 Call to undefined method Joomla\CMS\Factory::getUri() 

Call stack
# 	Function 	Location
1 	() 	JROOT/components/com_jlsitemap/controllers/sitemap.php:224
2 	JLSiteMapControllerSitemap->checkLanguage() 	JROOT/components/com_jlsitemap/controllers/sitemap.php:41
3 	JLSiteMapControllerSitemap->generate() 	JROOT/libraries/src/MVC/Controller/BaseController.php:735
4 	Joomla\CMS\MVC\Controller\BaseController->execute() 	JROOT/components/com_jlsitemap/jlsitemap.php:19
5 	require_once() 	JROOT/libraries/src/Dispatcher/LegacyComponentDispatcher.php:69
6 	Joomla\CMS\Dispatcher\LegacyComponentDispatcher::Joomla\CMS\Dispatcher\{closure}() 	JROOT/libraries/src/Dispatcher/LegacyComponentDispatcher.php:71
7 	Joomla\CMS\Dispatcher\LegacyComponentDispatcher->dispatch() 	JROOT/libraries/src/Component/ComponentHelper.php:389
8 	Joomla\CMS\Component\ComponentHelper::renderComponent() 	JROOT/libraries/src/Application/SiteApplication.php:204
9 	Joomla\CMS\Application\SiteApplication->dispatch() 	JROOT/libraries/src/Application/SiteApplication.php:243
10 	Joomla\CMS\Application\SiteApplication->doExecute() 	JROOT/libraries/src/Application/CMSApplication.php:278
11 	Joomla\CMS\Application\CMSApplication->execute() 	JROOT/includes/app.php:63
12 	require_once() 	JROOT/index.php:32 

Deprecated: trim(): Passing null to parameter #1 ($string) of type string is deprecated in /var/www//html/components/com_jlsitemap/models/sitemap.php on line 511

Deprecated: preg_match(): Passing null to parameter #2 ($subject) of type string is deprecated in /var/html/components/com_jlsitemap/models/sitemap.php on line 918

Deprecated: preg_match(): Passing null to parameter #2 ($subject) of type string is deprecated in /var//html/plugins/jlsitemap/content/content.php on line 214

Deprecated: DateTime::__construct(): Passing null to parameter #1 ($datetime) of type string is deprecated in /var//html/libraries/src/Date/Date.php on line 126