/core/model/modx/mysql/modusersetting.class.php
PHP | 40 lines | 31 code | 1 blank | 8 comment | 0 complexity | 702992756c3acfc8206bcf0ed6b4497f MD5 | raw file
Possible License(s): GPL-2.0, Apache-2.0, BSD-3-Clause, LGPL-2.1
- <?php
- /*
- * This file is part of MODX Revolution.
- *
- * Copyright (c) MODX, LLC. All Rights Reserved.
- *
- * For complete copyright and license information, see the COPYRIGHT and LICENSE
- * files found in the top-level directory of this distribution.
- */
- include_once (strtr(realpath(dirname(__FILE__)), '\\', '/') . '/../modusersetting.class.php');
- /**
- * @package modx
- * @subpackage mysql
- */
- class modUserSetting_mysql extends modUserSetting {
- public static function listSettings(xPDO &$xpdo, array $criteria = array(), array $sort = array('id' => 'ASC'), $limit = 0, $offset = 0) {
- $c = $xpdo->newQuery('modUserSetting');
- $c->select(array(
- $xpdo->getSelectColumns('modUserSetting','modUserSetting'),
- 'Entry.value AS name_trans',
- 'Description.value AS description_trans',
- ));
- $c->leftJoin('modLexiconEntry','Entry',"CONCAT('setting_',modUserSetting.`key`) = Entry.name");
- $c->leftJoin('modLexiconEntry','Description',"CONCAT('setting_',modUserSetting.`key`,'_desc') = Description.name");
- $c->where($criteria);
- $count = $xpdo->getCount('modUserSetting',$c);
- $c->sortby($xpdo->getSelectColumns('modUserSetting','modUserSetting','',array('area')),'ASC');
- foreach($sort as $field=> $dir) {
- $c->sortby($xpdo->getSelectColumns('modUserSetting','modUserSetting','',array($field)),$dir);
- }
- if ((int) $limit > 0) {
- $c->limit((int) $limit, (int) $offset);
- }
- return array(
- 'count'=> $count,
- 'collection'=> $xpdo->getCollection('modUserSetting',$c)
- );
- }
- }