protected function populateCategories() { $db = Loader::db(); self::$categories = array(); $r = $db->Execute('select pkCategoryID, pkCategoryHandle, pkgID from PermissionKeyCategories'); while ($row = $r->FetchRow()) { $pkc = new PermissionKeyCategory(); $pkc->setPropertiesFromArray($row); self::$categories[$pkc->getPermissionKeyCategoryID()] = $pkc; self::$categories[$pkc->getPermissionKeyCategoryHandle()] = $pkc; } }
public static function getByHandle($pkCategoryHandle) { $categories = Cache::get('permission_key_categories', false); if (is_array($categories) && $categories[$pkCategoryHandle] instanceof PermissionKeyCategory) { return $categories[$pkCategoryHandle]; } $db = Loader::db(); $row = $db->GetRow('select pkCategoryID, pkCategoryHandle, pkgID from PermissionKeyCategories where pkCategoryHandle = ?', array($pkCategoryHandle)); if (isset($row['pkCategoryID'])) { $pkc = new PermissionKeyCategory(); $pkc->setPropertiesFromArray($row); self::cache($categories, $pkc); return $pkc; } }