PHP xPDO::getTableName方法代码示例

    public static function listProfiles(xPDO &$xpdo, array $criteria = array(), array $sort = array('id' => 'ASC'), $limit = 0, $offset = 0) {
        /* query for profiles */
        $c = $xpdo->newQuery('modFormCustomizationProfile');
        $c->select(array(
            'modFormCustomizationProfile.*',
        ));
        $c->select('
            (SELECT GROUP_CONCAT(UserGroup.name) FROM '.$xpdo->getTableName('modUserGroup').' AS UserGroup
                INNER JOIN '.$xpdo->getTableName('modFormCustomizationProfileUserGroup').' AS fcpug
                ON fcpug.usergroup = UserGroup.id
             WHERE fcpug.profile = modFormCustomizationProfile.id
            ) AS usergroups
        ');
        $c->where($criteria,null,2);// also log issue in remine to look at this usage of where()
        $count = $xpdo->getCount('modFormCustomizationProfile',$c);

        foreach($sort as $field=> $dir) {
            $c->sortby($xpdo->getSelectColumns('modFormCustomizationProfile','modFormCustomizationProfile','',array($field)),$dir);
        }
        if ((int) $limit > 0) {
            $c->limit((int) $limit, (int) $offset);
        }
        return array(
            'count'=> $count,
            'collection'=> $xpdo->getCollection('modFormCustomizationProfile',$c)
        );
    }

 /**
  * Constructor
  *
  * Do not call the constructor directly; see {@link xPDO::newObject()}.
  *
  * All derivatives of xPDOObject must redeclare this method, and must call
  * the parent method explicitly before any additional logic is executed, e.g.
  *
  * <code>
  * public function __construct(xPDO & $xpdo) {
  *     parent  :: __construct($xpdo);
  *     // Any additional constructor tasks here
  * }
  * </code>
  *
  * @access public
  * @param xPDO &$xpdo A reference to a valid xPDO instance.
  * @return xPDOObject
  */
 public function __construct(xPDO &$xpdo)
 {
     $this->xpdo =& $xpdo;
     $this->container = $xpdo->config['dbname'];
     $this->_class = get_class($this);
     $pos = strrpos($this->_class, '_');
     if ($pos !== false && substr($this->_class, $pos + 1) == $xpdo->config['dbtype']) {
         $this->_class = substr($this->_class, 0, $pos);
     }
     $this->_package = $xpdo->getPackage($this->_class);
     $this->_alias = $this->_class;
     $this->_table = $xpdo->getTableName($this->_class);
     $this->_tableMeta = $xpdo->getTableMeta($this->_class);
     $this->_fields = $xpdo->getFields($this->_class);
     $this->_fieldMeta = $xpdo->getFieldMeta($this->_class);
     $this->_fieldAliases = $xpdo->getFieldAliases($this->_class);
     $this->_aggregates = $xpdo->getAggregates($this->_class);
     $this->_composites = $xpdo->getComposites($this->_class);
     if ($relatedObjs = array_merge($this->_aggregates, $this->_composites)) {
         foreach ($relatedObjs as $aAlias => $aMeta) {
             if (!array_key_exists($aAlias, $this->_relatedObjects)) {
                 if ($aMeta['cardinality'] == 'many') {
                     $this->_relatedObjects[$aAlias] = array();
                 } else {
                     $this->_relatedObjects[$aAlias] = null;
                 }
             }
         }
     }
     foreach ($this->_fieldAliases as $fieldAlias => $field) {
         $this->addFieldAlias($field, $fieldAlias);
     }
     $this->setDirty();
 }

 /**
  * Constructor
  *
  * Do not call the constructor directly; see {@link xPDO::newObject()}.
  *
  * All derivatives of xPDOObject must redeclare this method, and must call
  * the parent method explicitly before any additional logic is executed, e.g.
  *
  * <code>
  * protected function __construct(& $xpdo) {
  *     parent  :: __construct($xpdo);
  *     // Any additional constructor tasks here
  * }
  * </code>
  *
  * @access public
  * @param xPDO &$xpdo A reference to a valid xPDO instance.
  * @return xPDOObject
  */
 public function __construct(xPDO &$xpdo)
 {
     $this->container = $xpdo->config['dbname'];
     $this->_class = get_class($this);
     $pos = strrpos($this->_class, '_');
     if ($pos !== false && substr($this->_class, $pos + 1) == $xpdo->config['dbtype']) {
         $this->_class = substr($this->_class, 0, $pos);
     }
     $this->_package = $xpdo->getPackage($this->_class);
     $this->_alias = $this->_class;
     $this->_table = $xpdo->getTableName($this->_class);
     $this->_tableMeta = $xpdo->getTableMeta($this->_class);
     $this->_fields = $xpdo->getFields($this->_class);
     $this->_fieldMeta = $xpdo->getFieldMeta($this->_class);
     $this->_aggregates = $xpdo->getAggregates($this->_class);
     $this->_composites = $xpdo->getComposites($this->_class);
     $this->_options[xPDO::OPT_CALLBACK_ON_REMOVE] = isset($xpdo->config[xPDO::OPT_CALLBACK_ON_REMOVE]) && !empty($xpdo->config[xPDO::OPT_CALLBACK_ON_REMOVE]) ? $xpdo->config[xPDO::OPT_CALLBACK_ON_REMOVE] : null;
     $this->_options[xPDO::OPT_CALLBACK_ON_SAVE] = isset($xpdo->config[xPDO::OPT_CALLBACK_ON_SAVE]) && !empty($xpdo->config[xPDO::OPT_CALLBACK_ON_SAVE]) ? $xpdo->config[xPDO::OPT_CALLBACK_ON_SAVE] : null;
     $this->_options[xPDO::OPT_HYDRATE_RELATED_OBJECTS] = isset($xpdo->config[xPDO::OPT_HYDRATE_RELATED_OBJECTS]) && $xpdo->config[xPDO::OPT_HYDRATE_RELATED_OBJECTS];
     $this->_options[xPDO::OPT_HYDRATE_ADHOC_FIELDS] = isset($xpdo->config[xPDO::OPT_HYDRATE_ADHOC_FIELDS]) && $xpdo->config[xPDO::OPT_HYDRATE_ADHOC_FIELDS];
     $this->_options[xPDO::OPT_HYDRATE_FIELDS] = isset($xpdo->config[xPDO::OPT_HYDRATE_FIELDS]) && $xpdo->config[xPDO::OPT_HYDRATE_FIELDS];
     $this->_options[xPDO::OPT_ON_SET_STRIPSLASHES] = isset($xpdo->config[xPDO::OPT_ON_SET_STRIPSLASHES]) && $xpdo->config[xPDO::OPT_ON_SET_STRIPSLASHES];
     $this->_options[xPDO::OPT_VALIDATE_ON_SAVE] = isset($xpdo->config[xPDO::OPT_VALIDATE_ON_SAVE]) && $xpdo->config[xPDO::OPT_VALIDATE_ON_SAVE];
     $this->_options[xPDO::OPT_VALIDATOR_CLASS] = isset($xpdo->config[xPDO::OPT_VALIDATOR_CLASS]) ? $xpdo->config[xPDO::OPT_VALIDATOR_CLASS] : '';
     $classVars = array();
     if ($relatedObjs = array_merge($this->_aggregates, $this->_composites)) {
         if ($this->_options[xPDO::OPT_HYDRATE_RELATED_OBJECTS]) {
             $classVars = get_object_vars($this);
         }
         foreach ($relatedObjs as $aAlias => $aMeta) {
             if (!array_key_exists($aAlias, $this->_relatedObjects)) {
                 if ($aMeta['cardinality'] == 'many') {
                     $this->_relatedObjects[$aAlias] = array();
                 } else {
                     $this->_relatedObjects[$aAlias] = null;
                 }
             }
             if ($this->_options[xPDO::OPT_HYDRATE_RELATED_OBJECTS] && !array_key_exists($aAlias, $classVars)) {
                 $this->{$aAlias} =& $this->_relatedObjects[$aAlias];
                 $classVars[$aAlias] = 1;
             }
         }
     }
     if ($this->_options[xPDO::OPT_HYDRATE_FIELDS]) {
         if (!$this->_options[xPDO::OPT_HYDRATE_RELATED_OBJECTS]) {
             $classVars = get_object_vars($this);
         }
         foreach ($this->_fields as $fldKey => $fldVal) {
             if (!array_key_exists($fldKey, $classVars)) {
                 $this->{$fldKey} =& $this->_fields[$fldKey];
             }
         }
     }
     $this->setDirty();
     $this->xpdo =& $xpdo;
 }

 /**
  * Constructor
  *
  * Do not call the constructor directly; see {@link xPDO::newObject()}.
  *
  * All derivatives of xPDOObject must redeclare this method, and must call
  * the parent method explicitly before any additional logic is executed, e.g.
  *
  * <code>
  * public function __construct(xPDO & $xpdo) {
  *     parent  :: __construct($xpdo);
  *     // Any additional constructor tasks here
  * }
  * </code>
  *
  * @access public
  * @param xPDO &$xpdo A reference to a valid xPDO instance.
  * @return xPDOObject
  */
 public function __construct(xPDO &$xpdo)
 {
     $this->xpdo =& $xpdo;
     $this->container = $xpdo->config['dbname'];
     $this->_class = get_class($this);
     $pos = strrpos($this->_class, '_');
     if ($pos !== false && substr($this->_class, $pos + 1) == $xpdo->config['dbtype']) {
         $this->_class = substr($this->_class, 0, $pos);
     }
     $this->_package = $xpdo->getPackage($this->_class);
     $this->_alias = $this->_class;
     $this->_table = $xpdo->getTableName($this->_class);
     $this->_tableMeta = $xpdo->getTableMeta($this->_class);
     $this->_fields = $xpdo->getFields($this->_class);
     $this->_fieldMeta = $xpdo->getFieldMeta($this->_class);
     $this->_fieldAliases = $xpdo->getFieldAliases($this->_class);
     $this->_aggregates = $xpdo->getAggregates($this->_class);
     $this->_composites = $xpdo->getComposites($this->_class);
     $classVars = array();
     if ($relatedObjs = array_merge($this->_aggregates, $this->_composites)) {
         if ($this->getOption(xPDO::OPT_HYDRATE_RELATED_OBJECTS)) {
             $classVars = get_object_vars($this);
         }
         foreach ($relatedObjs as $aAlias => $aMeta) {
             if (!array_key_exists($aAlias, $this->_relatedObjects)) {
                 if ($aMeta['cardinality'] == 'many') {
                     $this->_relatedObjects[$aAlias] = array();
                 } else {
                     $this->_relatedObjects[$aAlias] = null;
                 }
             }
             if ($this->getOption(xPDO::OPT_HYDRATE_RELATED_OBJECTS) && !array_key_exists($aAlias, $classVars)) {
                 $this->{$aAlias} =& $this->_relatedObjects[$aAlias];
                 $classVars[$aAlias] = 1;
             }
         }
     }
     if ($this->getOption(xPDO::OPT_HYDRATE_FIELDS)) {
         if (!$this->getOption(xPDO::OPT_HYDRATE_RELATED_OBJECTS)) {
             $classVars = get_object_vars($this);
         }
         foreach ($this->_fields as $fldKey => $fldVal) {
             if (!array_key_exists($fldKey, $classVars)) {
                 $this->{$fldKey} =& $this->_fields[$fldKey];
             }
         }
     }
     foreach ($this->_fieldAliases as $fieldAlias => $field) {
         $this->addFieldAlias($field, $fieldAlias);
     }
     $this->setDirty();
 }

 /**
  * Find all policies for this object
  * 
  * @param string $context
  * @return array
  */
 public function findPolicy($context = '')
 {
     $policy = array();
     $enabled = true;
     $context = 'mgr';
     if ($context === $this->xpdo->context->get('key')) {
         $enabled = (bool) $this->xpdo->getOption('access_media_source_enabled', null, true);
     } elseif ($this->xpdo->getContext($context)) {
         $enabled = (bool) $this->xpdo->contexts[$context]->getOption('access_media_source_enabled', true);
     }
     if ($enabled) {
         if (empty($this->_policies) || !isset($this->_policies[$context])) {
             $accessTable = $this->xpdo->getTableName('sources.modAccessMediaSource');
             $sourceTable = $this->xpdo->getTableName('sources.modMediaSource');
             $policyTable = $this->xpdo->getTableName('modAccessPolicy');
             $sql = "SELECT Acl.target, Acl.principal, Acl.authority, Acl.policy, Policy.data FROM {$accessTable} Acl " . "LEFT JOIN {$policyTable} Policy ON Policy.id = Acl.policy " . "JOIN {$sourceTable} Source ON Acl.principal_class = 'modUserGroup' " . "AND (Acl.context_key = :context OR Acl.context_key IS NULL OR Acl.context_key = '') " . "AND Source.id = Acl.target " . "WHERE Acl.target = :source " . "GROUP BY Acl.target, Acl.principal, Acl.authority, Acl.policy";
             $bindings = array(':source' => $this->get('id'), ':context' => $context);
             $query = new xPDOCriteria($this->xpdo, $sql, $bindings);
             if ($query->stmt && $query->stmt->execute()) {
                 while ($row = $query->stmt->fetch(PDO::FETCH_ASSOC)) {
                     $policy['sources.modAccessMediaSource'][$row['target']][] = array('principal' => $row['principal'], 'authority' => $row['authority'], 'policy' => $row['data'] ? $this->xpdo->fromJSON($row['data'], true) : array());
                 }
             }
             $this->_policies[$context] = $policy;
         } else {
             $policy = $this->_policies[$context];
         }
     }
     return $policy;
 }

 /**
  * Mark all posts in this thread as read
  * @static
  * @param xPDO $modx
  * @param string $type
  * @return bool
  */
 public static function readAll(xPDO &$modx, $type = 'message')
 {
     $userId = $modx->discuss->user->get('id');
     $sql = 'SELECT `disThread`.`id`
     FROM ' . $modx->getTableName('disThread') . ' `disThread`
         INNER JOIN ' . $modx->getTableName('disThreadUser') . ' `ThreadUser`
         ON `ThreadUser`.`thread` = `disThread`.`id`
         LEFT JOIN ' . $modx->getTableName('disThreadRead') . ' `ThreadRead`
         ON `ThreadRead`.`thread` = `disThread`.`id`
     WHERE
         `ThreadUser`.`user` = ' . $userId . '
     AND `ThreadRead`.`id` IS NULL
     AND `private` = 1
     ORDER BY `disThread`.`id` DESC';
     $stmt = $modx->query($sql);
     if (!$stmt) {
         return false;
     }
     while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
         $read = $modx->getCount('disThreadRead', array('thread' => $row['id'], 'user' => $userId));
         if ($read == 0) {
             $read = $modx->newObject('disThreadRead');
             $read->fromArray(array('thread' => $row['id'], 'board' => 0, 'user' => $userId));
             $read->save();
         }
     }
     $stmt->closeCursor();
     return true;
 }