1: <?php
  2: /**
  3:  * This file contains the category tree collection and item class.
  4:  *
  5:  * @package          Core
  6:  * @subpackage       GenericDB_Model
  7:  * @version          SVN Revision $Rev:$
  8:  *
  9:  * @author           Timo Hummel
 10:  * @copyright        four for business AG <www.4fb.de>
 11:  * @license          http://www.contenido.org/license/LIZENZ.txt
 12:  * @link             http://www.4fb.de
 13:  * @link             http://www.contenido.org
 14:  */
 15: 
 16: defined('CON_FRAMEWORK') || die('Illegal call: Missing framework initialization - request aborted.');
 17: 
 18: /**
 19:  * Category tree collection
 20:  *
 21:  * @package Core
 22:  * @subpackage GenericDB_Model
 23:  */
 24: class cApiCategoryTreeCollection extends ItemCollection {
 25: 
 26:     public function __construct($select = false) {
 27:         global $cfg;
 28:         parent::__construct($cfg['tab']['cat_tree'], 'idtree');
 29: 
 30:         // set the join partners so that joins can be used via link() method
 31:         $this->_setJoinPartner('cApiCategoryCollection');
 32: 
 33:         $this->_setItemClass('cApiCategoryTree');
 34:         if ($select !== false) {
 35:             $this->select($select);
 36:         }
 37:     }
 38: 
 39:     /**
 40:      * Returns category tree structure by selecting the data from several tables
 41:      * ().
 42:      *
 43:      * @param int $client Client id
 44:      * @param int $lang Language id
 45:      * @return array Category tree structure as follows:
 46:      *         <pre>
 47:      *         $arr[n] (int) idtree value
 48:      *         $arr[n]['idcat'] (int)
 49:      *         $arr[n]['level'] (int)
 50:      *         $arr[n]['idtplcfg'] (int)
 51:      *         $arr[n]['visible'] (int)
 52:      *         $arr[n]['name'] (string)
 53:      *         $arr[n]['public'] (int)
 54:      *         $arr[n]['urlname'] (string)
 55:      *         $arr[n]['is_start'] (int)
 56:      *         </pre>
 57:      */
 58:     function getCategoryTreeStructureByClientIdAndLanguageId($client, $lang) {
 59:         global $cfg;
 60: 
 61:         $aCatTree = array();
 62: 
 63:         $sql = 'SELECT * FROM `:cat_tree` AS A, `:cat` AS B, `:cat_lang` AS C ' . 'WHERE A.idcat = B.idcat AND B.idcat = C.idcat AND C.idlang = :idlang AND idclient = :idclient ' . 'ORDER BY idtree';
 64: 
 65:         $sql = $this->db->prepare($sql, array(
 66:             'cat_tree' => $this->table,
 67:             'cat' => $cfg['tab']['cat'],
 68:             'cat_lang' => $cfg['tab']['cat_lang'],
 69:             'idlang' => (int) $lang,
 70:             'idclient' => (int) $client
 71:         ));
 72:         $this->db->query($sql);
 73: 
 74:         while ($this->db->nextRecord()) {
 75:             $aCatTree[$this->db->f('idtree')] = array(
 76:                 'idcat' => $this->db->f('idcat'),
 77:                 'level' => $this->db->f('level'),
 78:                 'idtplcfg' => $this->db->f('idtplcfg'),
 79:                 'visible' => $this->db->f('visible'),
 80:                 'name' => $this->db->f('name'),
 81:                 'public' => $this->db->f('public'),
 82:                 'urlname' => $this->db->f('urlname'),
 83:                 'is_start' => $this->db->f('is_start')
 84:             );
 85:         }
 86: 
 87:         return $aCatTree;
 88:     }
 89: 
 90: }
 91: 
 92: /**
 93:  * Category tree item
 94:  *
 95:  * @package Core
 96:  * @subpackage GenericDB_Model
 97:  */
 98: class cApiCategoryTree extends Item {
 99: 
100:     /**
101:      * Constructor Function
102:      *
103:      * @param mixed $mId Specifies the ID of item to load
104:      */
105:     public function __construct($mId = false) {
106:         global $cfg;
107:         parent::__construct($cfg['tab']['cat_tree'], 'idtree');
108:         $this->setFilters(array(), array());
109:         if ($mId !== false) {
110:             $this->loadByPrimaryKey($mId);
111:         }
112:     }
113: 
114: }
115: