public static function selectByItemId($intId) { global $_CONF; parent::$object = "StorageData"; parent::$table = "pcms_storage_data"; $strSql = sprintf("SELECT * FROM " . parent::$table . " WHERE itemId = '%s'", $intId); return parent::select($strSql); }
public static function select($strSql = "") { global $_CONF; parent::$object = "ContentLanguage"; parent::$table = "pcms_language"; if (empty($strSql)) { $strSql = sprintf("SELECT * FROM " . parent::$table . " WHERE accountId = '%s' ORDER BY sort", $_CONF['app']['account']->getId()); } return parent::select($strSql); }
public function save($blnSaveModifiedDate = TRUE) { parent::$object = "Template"; parent::$table = "pcms_template"; $intId = $this->getId(); $blnReturn = parent::save($blnSaveModifiedDate); if (class_exists("AuditLog")) { AuditLog::addLog(AUDIT_TYPE_TEMPLATE, $this->getId(), $this->getName(), empty($intId) ? "create" : "edit"); } return $blnReturn; }
public static function selectByAlias($strAlias) { global $_CONF; parent::$object = "Alias"; parent::$table = "pcms_alias"; $objReturn = null; if (!empty($strAlias)) { $strSql = sprintf("SELECT * FROM " . parent::$table . " WHERE accountId = '%s' AND alias = %s ORDER BY sort", $_CONF['app']['account']->getId(), parent::quote($strAlias)); $objReturn = parent::select($strSql); } return $objReturn; }
public function getItems($intTypeId = STORAGE_TYPE_ALL) { global $_CONF; parent::$object = "StorageItem"; parent::$table = "pcms_storage_item"; $strSql = sprintf("SELECT * FROM " . parent::$table . " WHERE parentId = '%s' AND typeId IN (%s) AND accountId = '%s' ORDER BY sort", $this->getId(), $intTypeId, $_CONF['app']['account']->getId()); return parent::select($strSql); }
public function save($blnSaveModifiedDate = TRUE, $blnCreateForced = TRUE) { parent::$object = "Element"; parent::$table = "pcms_element"; $intId = $this->getId(); $blnReturn = parent::save($blnSaveModifiedDate); if (class_exists("AuditLog")) { AuditLog::addLog(AUDIT_TYPE_ELEMENT, $this->getId(), $this->getName(), empty($intId) ? "create" : "edit", $this->getActive() ? "active" : "inactive"); } //*** Save permissions. if (is_object($this->objPermissions)) { $this->clearPermissions(); $this->objPermissions->setElementId($this->id); $this->objPermissions->save(); } //*** Create forced children. if (empty($intId) && $blnCreateForced) { $this->createForcedElements(); } return $blnReturn; }