コード例 #1
0
ファイル: user.php プロジェクト: ronlobo/concrete5
	public static function getByHandle($akHandle) {
		$ak = CacheLocal::getEntry('user_attribute_key_by_handle', $akHandle);
		if (is_object($ak)) {
			return $ak;
		} else if ($ak == -1) {
			return false;
		}
		$ak = -1;
		$db = Loader::db();
		
		$q = "SELECT ak.akID 
			FROM AttributeKeys ak
			INNER JOIN AttributeKeyCategories akc ON ak.akCategoryID = akc.akCategoryID 
			WHERE ak.akHandle = ?
			AND akc.akCategoryHandle = 'user'";
		$akID = $db->GetOne($q, array($akHandle));
		if ($akID > 0) {
			$ak = UserAttributeKey::getByID($akID);
		}

		CacheLocal::set('user_attribute_key_by_handle', $akHandle, $ak);
		if ($ak === -1) {
			return false;
		}
		return $ak;
	}
コード例 #2
0
ファイル: file.php プロジェクト: Zyqsempai/amanet
 public static function getByHandle($akHandle)
 {
     $ak = CacheLocal::getEntry('file_attribute_key_by_handle', $akHandle);
     if (is_object($ak)) {
         return $ak;
     } else {
         if ($ak == -1) {
             return false;
         }
     }
     $ak = -1;
     $db = Loader::db();
     $q = "SELECT ak.akID FROM AttributeKeys ak INNER JOIN AttributeKeyCategories akc ON ak.akCategoryID = akc.akCategoryID  WHERE ak.akHandle = ? AND akc.akCategoryHandle = 'file'";
     $akID = $db->GetOne($q, array($akHandle));
     if ($akID > 0) {
         $ak = self::getByID($akID);
     } else {
         // else we check to see if it's listed in the initial registry
         $ia = FileTypeList::getImporterAttribute($akHandle);
         if (is_object($ia)) {
             // we create this attribute and return it.
             $at = AttributeType::getByHandle($ia->akType);
             $args = array('akHandle' => $akHandle, 'akName' => $ia->akName, 'akIsSearchable' => 1, 'akIsAutoCreated' => 1, 'akIsEditable' => $ia->akIsEditable);
             $ak = FileAttributeKey::add($at, $args);
         }
     }
     CacheLocal::set('file_attribute_key_by_handle', $akHandle, $ak);
     if ($ak === -1) {
         return false;
     }
     return $ak;
 }
コード例 #3
0
ファイル: model.php プロジェクト: nveid/concrete5
	public static function getByName($stackName, $cvID = 'RECENT') {
		$cID = CacheLocal::getEntry('stack_by_name', $stackName);
		if (!$cID) {
			$db = Loader::db();
			$cID = $db->GetOne('select cID from Stacks where stName = ?', array($stackName));
			CacheLocal::set('stack_by_name', $stackName, $cID);
		}
		
		if ($cID) {
			return self::getByID($cID, $cvID);
		}
	}
コード例 #4
0
ファイル: page.php プロジェクト: Mihail9575/concrete5
 /**
  * @param int $cID Collection ID of a page
  * @param string $versionOrig ACTIVE or RECENT
  * @param string $class
  * @return Page
  */
 public static function getByID($cID, $version = 'RECENT', $class = 'Page')
 {
     $c = CacheLocal::getEntry('page', $cID . ':' . $version);
     if ($c instanceof $class) {
         return $c;
     }
     $where = "where Pages.cID = ?";
     $c = new $class();
     $c->populatePage($cID, $where, $version);
     // must use cID instead of c->getCollectionID() because cID may be the pointer to another page
     CacheLocal::set('page', $cID . ':' . $version, $c);
     return $c;
 }
コード例 #5
0
ファイル: package.php プロジェクト: ojalehto/concrete5-legacy
 public static function get($pkgIsInstalled = 1)
 {
     $pkgList = CacheLocal::getEntry('pkgList', $pkgIsInstalled);
     if ($pkgList != false) {
         return $pkgList;
     }
     $db = Loader::db();
     $r = $db->query("select pkgID, pkgName, pkgIsInstalled, pkgDescription, pkgVersion, pkgHandle, pkgDateInstalled from Packages where pkgIsInstalled = ? order by pkgID asc", array($pkgIsInstalled));
     $list = new PackageList();
     while ($row = $r->fetchRow()) {
         $pkg = new Package();
         $pkg->setPropertiesFromArray($row);
         $list->add($pkg);
     }
     CacheLocal::set('pkgList', $pkgIsInstalled, $list);
     return $list;
 }
コード例 #6
0
 public static function getList()
 {
     $gaItemTemplateTypeList = CacheLocal::getEntry('gaItemTemplateTypeList', false);
     if ($gaItemTemplateTypeList != false) {
         return $gaItemTemplateTypeList;
     }
     $db = Loader::db();
     $list = array();
     $r = $db->Execute('select gatTypeID from GatheringItemTemplateTypes order by gatTypeID asc');
     while ($row = $r->FetchRow()) {
         $type = static::getByID($row['gatTypeID']);
         if (is_object($type)) {
             $list[] = $type;
         }
     }
     $r->Close();
     CacheLocal::set('gaItemTemplateTypeList', false, $list);
     return $list;
 }
コード例 #7
0
ファイル: form_key.php プロジェクト: sixeightmedia/formify
 public static function getByHandle($akHandle)
 {
     $ak = CacheLocal::getEntry('form_attribute_key_by_handle', $akHandle);
     if (is_object($ak)) {
         return $ak;
     } else {
         if ($ak == -1) {
             return false;
         }
     }
     $ak = new FormAttributeKey();
     $ak->load($akHandle, 'akHandle');
     if ($ak->getAttributeKeyID() < 1) {
         $ak = -1;
     }
     CacheLocal::set('form_attribute_key_by_handle', $akHandle, $ak);
     if ($ak === -1) {
         return false;
     }
     return $ak;
 }
コード例 #8
0
ファイル: model.php プロジェクト: ojalehto/concrete5-legacy
 static final function getByID($peID)
 {
     $obj = CacheLocal::getEntry('permission_access_entity', $peID);
     if ($obj instanceof PermissionAccessEntity) {
         return $obj;
     }
     $db = Loader::db();
     $r = $db->GetRow('select petID, peID from PermissionAccessEntities where peID = ?', array($peID));
     if (is_array($r)) {
         $pt = PermissionAccessEntityType::getByID($r['petID']);
         if (!is_object($pt)) {
             return false;
         }
         $class = Loader::helper('text')->camelcase($pt->getAccessEntityTypeHandle());
         $class .= 'PermissionAccessEntity';
         $obj = new $class();
         $r['petHandle'] = $pt->getAccessEntityTypeHandle();
         $obj->setPropertiesFromArray($r);
         $obj->load();
     }
     CacheLocal::set('permission_access_entity', $peID, $obj);
     return $obj;
 }
コード例 #9
0
ファイル: area.php プロジェクト: ojalehto/concrete5-legacy
 /**
  * Gets or creates if necessary an Area for the given Page, Handle 
  * @param Page|Collection $c
  * @param string $arHandle
  * @param boolean $arIsGlobal
  * @return Area
  */
 public static function getOrCreate(&$c, $arHandle, $arIsGlobal = 0)
 {
     /*
     	different than get(), getOrCreate() is called by the templates. If no area record exists for the
     	permissions cID / handle combination, we create one. This is to make our lives easier
     */
     $area = self::get($c, $arHandle, $arIsGlobal);
     if (is_object($area)) {
         if ($area->isGlobalArea() == $arIsGlobal) {
             return $area;
         } else {
             if (!$area->isGlobalArea() && !$arIsGlobal) {
                 return $area;
             }
         }
     }
     $cID = $c->getCollectionID();
     $db = Loader::db();
     if (!$arIsGlobal) {
         $arIsGlobal = 0;
     }
     $db->Replace('Areas', array('cID' => $cID, 'arHandle' => $arHandle, 'arIsGlobal' => $arIsGlobal), array('arHandle', 'cID'), true);
     if ($arIsGlobal) {
         // we create a stack for it
         Stack::getOrCreateGlobalArea($arHandle);
     }
     $area = self::get($c, $arHandle);
     // we're assuming the insert succeeded
     $area->rescanAreaPermissionsChain();
     // we need to update the local cache
     $globalCache = $arIsGlobal ? ':1' : '';
     CacheLocal::set('area', $c->getCollectionID() . ':' . $arHandle . $globalCache, $area);
     return $area;
 }
コード例 #10
0
ファイル: collection_types.php プロジェクト: Zyqsempai/amanet
 /**
  * Get a collection type by its ID.
  *
  * @param $ctID
  * @return bool|CollectionType
  * @todo refactor to return null on not found.
  */
 public static function getByID($ctID)
 {
     $ctID = intval($ctID);
     $ct = CacheLocal::getEntry('collection_type_by_id', $ctID);
     if (is_object($ct)) {
         return $ct;
     } else {
         if ($ct === -1) {
             return false;
         }
     }
     $db = Loader::db();
     $q = "SELECT PageTypes.ctID, ComposerTypes.ctID as ctIDc, ctHandle, ctIsInternal, ctName, ctIcon, pkgID, ctComposerPublishPageMethod, ctComposerPublishPageTypeID, ctComposerPublishPageParentID from PageTypes left join ComposerTypes on PageTypes.ctID = ComposerTypes.ctID where PageTypes.ctID = ?";
     $r = $db->query($q, array($ctID));
     if ($r) {
         $row = $r->fetchRow();
         $r->free();
         if (is_array($row)) {
             $ct = new CollectionType();
             $ct->setPropertiesFromArray($row);
             if ($row['ctIDc']) {
                 $ct->ctIncludeInComposer = true;
             }
         }
     }
     CacheLocal::set('collection_type_by_id', $ctID, $ct);
     return $ct;
 }
コード例 #11
0
ファイル: model.php プロジェクト: nveid/concrete5
	public function getAccessListItems($accessType = PermissionKey::ACCESS_TYPE_INCLUDE, $filterEntities = array()) {
		if (count($this->paIDList) > 0) {
			$q = 'select paID, peID, pdID, accessType from PermissionAccessList where paID in (' . implode(',', $this->paIDList) . ')';
			return $this->deliverAccessListItems($q, $accessType, $filterEntities);
		} else {
			$filter = $accessType . ':';
			foreach($filterEntities as $pae) {
				$filter .= $pae->getAccessEntityID() . ':';
			}
			$filter = trim($filter, ':');
			$items = CacheLocal::getEntry('permission_access_list_items', $this->getPermissionAccessID() . $filter . strtolower(get_class($this->pk)));
			if (is_array($items)) {
				return $items;
			}				
			$q = 'select paID, peID, pdID, accessType from PermissionAccessList where paID = ' . $this->getPermissionAccessID();
			$items = $this->deliverAccessListItems($q, $accessType, $filterEntities);
			CacheLocal::set('permission_access_list_items', $this->getPermissionAccessID() . $filter . strtolower(get_class($this->pk)), $items);
			return $items;
		}
	}
コード例 #12
0
ファイル: file.php プロジェクト: ronlobo/concrete5
	/**
	 * returns the FileVersion object for the provided fvID
	 * if none provided returns the approved version
	 * @param int $fvID
	 * @return FileVersion
	 */
	public function getVersion($fvID = null) {

		if ($fvID == null) {
			$fvID = $this->fvID; // approved version
		}
		$fv = CacheLocal::getEntry('file', $this->getFileID() . ':' . $fvID);
		if ($fv === -1) {
			return false;
		}
		if ($fv) {
			return $fv;
		}

		$db = Loader::db();
		$row = $db->GetRow("select * from FileVersions where fvID = ? and fID = ?", array($fvID, $this->fID));
		$row['fvAuthorName'] = $db->GetOne("select uName from Users where uID = ?", array($row['fvAuthorUID']));
		
		$fv = new FileVersion();
		$row['fslID'] = $this->fslID;
		$fv->setPropertiesFromArray($row);
		
		CacheLocal::set('file', $this->getFileID() . ':' . $fvID, $fv);
		return $fv;
	}
コード例 #13
0
ファイル: block.php プロジェクト: ojalehto/concrete5-legacy
 public static function getByID($bID, $c = null, $a = null)
 {
     if ($c == null && $a == null) {
         $cID = 0;
         $arHandle = "";
         $cvID = 0;
         $b = CacheLocal::getEntry('block', $bID);
     } else {
         if (is_object($a)) {
             $arHandle = $a->getAreaHandle();
         } else {
             if ($a != null) {
                 $arHandle = $a;
                 $a = Area::getOrCreate($c, $a);
             }
         }
         $cID = $c->getCollectionID();
         $cvID = $c->getVersionID();
         $b = CacheLocal::getEntry('block', $bID . ':' . $cID . ':' . $cvID . ':' . $arHandle);
     }
     if ($b instanceof Block) {
         return $b;
     }
     $db = Loader::db();
     $b = new Block();
     if ($c == null && $a == null) {
         // just grab really specific block stuff
         $q = "select bID, bIsActive, BlockTypes.btID, Blocks.btCachedBlockRecord, BlockTypes.btHandle, BlockTypes.pkgID, BlockTypes.btName, bName, bDateAdded, bDateModified, bFilename, Blocks.uID from Blocks inner join BlockTypes on (Blocks.btID = BlockTypes.btID) where bID = ?";
         $b->isOriginal = 1;
         $v = array($bID);
     } else {
         $b->arHandle = $arHandle;
         $b->a = $a;
         $b->cID = $cID;
         $b->c = $c ? $c : '';
         $vo = $c->getVersionObject();
         $cvID = $vo->getVersionID();
         $v = array($b->arHandle, $cID, $cvID, $bID);
         $q = "select CollectionVersionBlocks.isOriginal, Blocks.btCachedBlockRecord, BlockTypes.pkgID, CollectionVersionBlocks.cbOverrideAreaPermissions, CollectionVersionBlocks.cbDisplayOrder, Blocks.bIsActive, Blocks.bID, Blocks.btID, bName, bDateAdded, bDateModified, bFilename, btHandle, Blocks.uID from CollectionVersionBlocks inner join Blocks on (CollectionVersionBlocks.bID = Blocks.bID) inner join BlockTypes on (Blocks.btID = BlockTypes.btID) where CollectionVersionBlocks.arHandle = ? and CollectionVersionBlocks.cID = ? and (CollectionVersionBlocks.cvID = ? or CollectionVersionBlocks.cbIncludeAll=1) and CollectionVersionBlocks.bID = ?";
     }
     $r = $db->query($q, $v);
     $row = $r->fetchRow();
     if (is_array($row)) {
         $b->setPropertiesFromArray($row);
         $r->free();
         $bt = BlockType::getByID($b->getBlockTypeID());
         $class = $bt->getBlockTypeClass();
         if ($class == false) {
             // we can't find the class file, so we return
             return false;
         }
         $b->instance = new $class($b);
         if ($c != null || $a != null) {
             CacheLocal::set('block', $bID . ':' . $cID . ':' . $cvID . ':' . $arHandle, $b);
         } else {
             $ca = new Cache();
             CacheLocal::set('block', $bID, $b);
         }
         return $b;
     }
 }
コード例 #14
0
ファイル: area.php プロジェクト: Remo/concrete5
	/**
	 * Gets the Area object for the given page and area handle
	 * @param Page|Collection $c
	 * @param string $arHandle
	 * @param int|null $arIsGlobal
	 * @return Area
	 */
	public static function get(&$c, $arHandle, $arIsGlobal = null) {
		if (!is_object($c)) {
			return false;
		}
		
		// Right now we are splitting the cache to deal with times when Areas
		// get converted to GlobalAreas and back the other way
		$globalCache = $arIsGlobal ? ':1' : '';
		$a = CacheLocal::getEntry('area', $c->getCollectionID() . ':' . $arHandle . $globalCache);
		if ($a instanceof Area) {
			return $a;
		}
		$db = Loader::db();
		// First, we verify that this is a legitimate area
		$v = array($c->getCollectionID(), $arHandle);
		$q = "select arID, arOverrideCollectionPermissions, arInheritPermissionsFromAreaOnCID, arIsGlobal from Areas where cID = ? and arHandle = ?";
		$arRow = $db->getRow($q, $v);
		if ($arRow['arID'] > 0) {
			$area = new Area($arHandle);

			$area->arID = $arRow['arID'];
			$area->arOverrideCollectionPermissions = $arRow['arOverrideCollectionPermissions'];
			$area->arIsGlobal = $arRow['arIsGlobal'];
			$area->arInheritPermissionsFromAreaOnCID = $arRow['arInheritPermissionsFromAreaOnCID'];
			$area->cID = $c->getCollectionID();
			$area->c = &$c;
			
			CacheLocal::set('area', $c->getCollectionID() . ':' . $arHandle . $globalCache, $area);
			
			return $area;
		}
	}
コード例 #15
0
ファイル: key.php プロジェクト: Zyqsempai/amanet
 public static function loadAll()
 {
     $cl = new CacheLocal();
     $db = Loader::db();
     $permissionkeys = array();
     $e = $db->Execute('select pkID, pkName, pkDescription, pkHandle, pkCategoryHandle, pkCanTriggerWorkflow, pkHasCustomClass, PermissionKeys.pkCategoryID, pkCategoryHandle, PermissionKeys.pkgID from PermissionKeys inner join PermissionKeyCategories on PermissionKeyCategories.pkCategoryID = PermissionKeys.pkCategoryID');
     while ($r = $e->FetchRow()) {
         $class = Loader::helper('text')->camelcase($r['pkCategoryHandle']) . 'PermissionKey';
         if ($r['pkHasCustomClass']) {
             $class = Loader::helper('text')->camelcase($r['pkHandle']) . $class;
         }
         $pk = new $class();
         $pk->setPropertiesFromArray($r);
         $permissionkeys[$r['pkHandle']] = $pk;
         $permissionkeys[$r['pkID']] = $pk;
     }
     CacheLocal::set('permission_keys', false, $permissionkeys);
     return $permissionkeys;
 }
コード例 #16
0
ファイル: collection.php プロジェクト: ronlobo/concrete5
		/**
		 * List the block IDs in a collection or area within a collection
		 * @param string $arHandle. If specified, returns just the blocks in an area
		 * @return array
		 */
		public function getBlockIDs($arHandle = false) {
			$blockIDs = CacheLocal::getEntry('collection_block_ids', $this->getCollectionID() . ':' . $this->getVersionID());
			$blocks = array();
		
			if (!is_array($blockIDs)) {
				$v = array($this->getCollectionID(), $this->getVersionID());
				$db = Loader::db();
				$q = "select Blocks.bID, CollectionVersionBlocks.arHandle from CollectionVersionBlocks inner join Blocks on (CollectionVersionBlocks.bID = Blocks.bID) inner join BlockTypes on (Blocks.btID = BlockTypes.btID) where CollectionVersionBlocks.cID = ? and (CollectionVersionBlocks.cvID = ? or CollectionVersionBlocks.cbIncludeAll=1) order by CollectionVersionBlocks.cbDisplayOrder asc";
				$r = $db->GetAll($q, $v);
				$blockIDs = array();
				if (is_array($r)) {
					foreach($r as $bl) {
						$blockIDs[strtolower($bl['arHandle'])][] = $bl;
					}
				}
				CacheLocal::set('collection_block_ids', $this->getCollectionID() . ':'. $this->getVersionID(), $blockIDs);
			}
			

			if ($arHandle != false) {
				$blockIDsTmp = $blockIDs[strtolower($arHandle)];
				$blockIDs = $blockIDsTmp;
			} else {
				$blockIDsTmp = $blockIDs;
				$blockIDs = array();
				foreach($blockIDsTmp as $arHandle => $row) {
					foreach($row as $brow) {
						if (!in_array($brow, $blockIDs)) {
							$blockIDs[] = $brow;
						}
					}
				}
			}
			return $blockIDs;
		}
コード例 #17
0
ファイル: block_types.php プロジェクト: ronlobo/concrete5
		/**
		 * Gets the BlockType for a given Block Type ID
		 * @param int $btID
		 * @return BlockType
		 */
		public static function getByID($btID) {
			$bt = CacheLocal::getEntry('blocktype', $btID);
			if ($bt === -1) {
				return false;
			} else if (!is_object($bt)) {
				$where = 'btID = ?';
				$bt = BlockType::get($where, array($btID));			
				if (is_object($bt)) {
					CacheLocal::set('blocktype', $btID, $bt);
				} else {
					CacheLocal::set('blocktype', $btID, -1);
				}
			}
			$bt->controller = Loader::controller($bt);
			return $bt;
		}
コード例 #18
0
ファイル: groups.php プロジェクト: Zyqsempai/amanet
 public static function getByID($gID)
 {
     $db = Loader::db();
     $g = CacheLocal::getEntry('group', $gID);
     if (is_object($g)) {
         return $g;
     }
     $row = $db->getRow("select * from Groups where gID = ?", array($gID));
     if (isset($row['gID'])) {
         $g = new Group();
         $g->setPropertiesFromArray($row);
         CacheLocal::set('group', $gID, $g);
         return $g;
     }
 }