예제 #1
0
	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;
		}
	}
예제 #2
0
	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;
		}
	}