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