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