public static function getRegions()
{
if (!self::$_regions) {
self::$_regions = array();
}
if (self::$_regions) {
return self::$_regions;
}
$db = JFactory::getDBO();
$query = "SELECT r.*, rr.name as parent_name FROM #__djcf_regions r " . "LEFT JOIN #__djcf_regions rr ON r.parent_id=rr.id " . "ORDER BY r.parent_id, r.name COLLATE utf8_polish_ci";
$db->setQuery($query);
$allregions = $db->loadObjectList();
//cho '<pre>';print_r($db);print_r($allregions);die();
self::$_regions = $allregions;
return self::$_regions;
}
public static function getRegions()
{
if (!self::$_regions) {
self::$_regions = array();
}
if (self::$_regions) {
return self::$_regions;
}
$db = JFactory::getDBO();
$date_now = date("Y-m-d H:i:s");
$query = "SELECT r.*, rr.name as parent_name,IFNULL(i.items_count,0) items_count FROM #__djcf_regions r " . "LEFT JOIN #__djcf_regions rr ON r.parent_id=rr.id " . "LEFT JOIN (SELECT i.region_id, count(i.id) as items_count " . "FROM #__djcf_items i WHERE i.published=1 AND i.date_exp > '" . $date_now . "' GROUP BY i.region_id) i ON i.region_id=r.id " . "ORDER BY r.parent_id, r.name COLLATE utf8_polish_ci";
$db->setQuery($query);
$allregions = $db->loadObjectList();
//echo '<pre>';print_r($db);print_r($allregions);die();
self::$_regions = $allregions;
return self::$_regions;
}
