1:   2:   3:   4:   5:   6:   7:   8:   9:  10:  11:  12:  13:  14:  15:  16:  17:  18:  19:  20:  21:  22:  23:  24:  25:  26:  27:  28:  29:  30:  31:  32:  33:  34:  35:  36:  37:  38:  39:  40:  41:  42:  43:  44:  45:  46:  47:  48:  49:  50:  51:  52:  53:  54:  55:  56:  57:  58:  59:  60:  61:  62:  63:  64:  65:  66:  67:  68:  69:  70:  71:  72:  73:  74:  75:  76:  77:  78:  79:  80:  81:  82:  83:  84:  85:  86:  87:  88:  89:  90:  91:  92:  93:  94:  95:  96:  97:  98:  99: 100: 101: 102: 103: 104: 105: 106: 107: 108: 109: 110: 111: 112: 113: 114: 115: 116: 117: 118: 119: 120: 121: 122: 123: 

<?php
/**
 * Contains the basic classe for managing a category object based on icms_ipf_Object
 *
 * @copyright   The ImpressCMS Project http://www.impresscms.org/
 * @license     http://www.gnu.org/licenses/old-licenses/gpl-2.0.html GNU General Public License (GPL)
 * @category    ICMS
 * @package     Ipf
 * @subpackage  Category
 * @since       1.2
 * @author      marcan <marcan@impresscms.org>
 * @author      Sina Asghari (aka stranger) <pesian_stranger@users.sourceforge.net>
 * @version     SVN: $Id:Handler.php 19775 2010-07-11 18:54:25Z malanciault $
 */

defined("ICMS_ROOT_PATH") or die("ImpressCMS root path not defined");

/**
 * Provides data access mechanisms to the icms_ipf_category_Object object
 * @copyright   The ImpressCMS Project http://www.impresscms.org/
 * @license     http://www.gnu.org/licenses/old-licenses/gpl-2.0.html GNU General Public License (GPL)
 * @category    ICMS
 * @package     Ipf
 * @subpackage  Category
 * @since       1.1
 */
class icms_ipf_category_Handler extends icms_ipf_Handler {
    /** */
    public $allCategoriesObj = false;
    /** */
    private $_allCategoriesId = false;

    /**
     * Constructor for the object handler
     *
     * @param object $db A database object
     * @param string $modulename The directory name for the module
     * @return icms_ipf_category_Handler
     */
    public function __construct($db, $modulename) {
        parent::__construct($db, 'category', 'categoryid', 'name', 'description', $modulename);
    }

    /**
     * Return all categories in an array
     *
     * @param int $parentid
     * @param string $perm_name
     * @param string $sort
     * @param string $order
     * @return array
     */
    public function getAllCategoriesArray($parentid=0, $perm_name=false, $sort = 'parentid', $order='ASC') {

        if (!$this->allCategoriesObj) {
            $criteria = new icms_db_criteria_Compo();
            $criteria->setSort($sort);
            $criteria->setOrder($order);
            $userIsAdmin = is_object(icms::$user) && icms::$user->isAdmin();

            if ($perm_name && !$userIsAdmin) {
                if (!$this->setGrantedObjectsCriteria($criteria, $perm_name)) {
                    return false;
                }
            }

            $this->allCategoriesObj =& $this->getObjects($criteria, 'parentid');
        }

        $ret = array();
        if (isset($this->allCategoriesObj[$parentid])) {
            foreach ( $this->allCategoriesObj[$parentid] as $categoryid=>$categoryObj) {
                $ret[$categoryid]['self'] =& $categoryObj->toArray();
                if (isset($this->allCategoriesObj[$categoryid])) {
                    $ret[$categoryid]['sub'] =& $this->getAllCategoriesArray($categoryid);
                    $ret[$categoryid]['subcatscount'] = count($ret[$categoryid]['sub']);
                }
            }
        }
        return $ret;
    }

    /**
     *
     * @param   int     $parentid
     * @param   bool    $asString
     * @return  array|string    array of ids, or if $asString is TRUE a comma-separated string of ids
     */
    public function getParentIds($parentid, $asString=true) {

        if (!$this->allCategoriesId) {

            $ret = array();
            $sql = 'SELECT categoryid, parentid FROM ' . $this->table
                . " AS " . $this->_itemname . ' ORDER BY parentid';

            $result = $this->db->query($sql);

            if (!$result) {
                return $ret;
            }

            while ($myrow = $this->db->fetchArray($result)) {
                $this->allCategoriesId[$myrow['categoryid']] =  $myrow['parentid'];
            }
        }

        $retArray = array($parentid);
        while ($parentid != 0) {
            $parentid = $this->allCategoriesId[$parentid];
            if ($parentid != 0) {
                $retArray[] = $parentid;
            }
        }
        if ($asString) {
            return implode(', ', $retArray);
        } else {
            return $retArray;
        }
    }
}