ꦫꦣꦺꦤ꧀ꦄꦤ꧀ꦠꦱꦺꦤ

PATH: home / centosnipponia / public_html / nipponiacom2 / caribe / administrator / components / com_djcatalog2 / lib

<?php
/**
 * @version $Id: categories.php 418 2015-05-11 12:43:29Z michal $
 * @package DJ-Catalog2
 * @copyright Copyright (C) 2012 DJ-Extensions.com LTD, All rights reserved.
 * @license http://www.gnu.org/licenses GNU/GPL
 * @author url: http://dj-extensions.com
 * @author email contact@dj-extensions.com
 * @developer Michal Olczyk - michal.olczyk@design-joomla.eu
 *
 * DJ-Catalog2 is free software: you can redistribute it and/or modify
 * it under the terms of the GNU General Public License as published by
 * the Free Software Foundation, either version 3 of the License, or
 * (at your option) any later version.
 *
 * DJ-Catalog2 is distributed in the hope that it will be useful,
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
 * GNU General Public License for more details.
 *
 * You should have received a copy of the GNU General Public License
 * along with DJ-Catalog2. If not, see <http://www.gnu.org/licenses/>.
 *
 */
defined('_JEXEC') or die();

class Djc2CategoryNode extends JObject
{
    public $id = 0;
    public $name = 'root';
    public $catslug = '0:all';
    public $parent_id = null;
    public $published = 1;
    public $_parent = null;
    public $_children = array();
    public $access = 0;
    public static $default_access = 0;

public function __construct($category = null)
    {
    	if ($category) {
			$this->setProperties($category);
    	} else {
    		if (!self::$default_access) {
    			$db = JFactory::getDbo();
    			$query = $db->getQuery(true);
    			$query->select('a.id');
    			$query->from('#__viewlevels AS a');
    			$query->order('a.ordering ASC, a.id ASC');
    			
    			$db->setQuery($query);
    			
    			self::$default_access = $db->loadResult();
    		}
    		$this->access = self::$default_access;
    	}
    }
    
	public function setParent(&$parent) {
    	$this->_parent = $parent;
    }
	public function addChild(&$child) {
		if (!isset($this->_children[$child->id])){
			$this->_children[$child->id] = $child;			
		}
    }
    public function getPath() {
    	if (isset($this->_path)) {
    		return $this->_path;
    	}
    	$path = new stdClass();
    	$path->items = array();
    	$slugs = array();
    	$current = $this;
    	while ($current->parent_id != null) {
    		$pathElement = new stdClass();
    		$pathElement->slug = ($current->alias) ? $current->id.':'.$current->alias : $current->id;
    		$pathElement->id = $current->id;
    		$pathElement->alias = $current->alias;
    		$slugs[] = $pathElement->slug;
    		$path->items[] = $pathElement;
    		$current = $current->_parent;
    	}
    	$this->_path = $slugs;
    	return $this->_path;
    }
    public function getChildren() {
    	return $this->_children;
    }
    public function makeChildrenList(&$list) {
    	if (count($this->_children)) {
    		foreach ($this->_children as $child ){
    			$list[] = $child->id;
    			$child->makeChildrenList($list);
    		}
    	}
    }
	public function getParent() {
    	return $this->_parent;
    }
    public function getProductCount() {
    	if (!isset($this->item_count)) {
    		$db = JFactory::getDbo();
    		$category_subquery = $db->getQuery(true);
    		 
    		$category_subquery->select('ic.item_id');
    		$category_subquery->from('#__djc2_items_categories AS ic');
    		$category_subquery->join('INNER', '#__djc2_categories AS c ON c.id=ic.category_id');
    		$category_subquery->where('c.published = 1');
    		 
    		$childrenList = array($this->id);
    		$this->makeChildrenList($childrenList);
    		 
    		if (!empty($childrenList)) {
    			$cids = implode(',', $childrenList);
    			$category_subquery->where('ic.category_id IN ('.$cids.')');
    		}
    		 
    		$product_query = $db->getQuery(true);
    		 
    		$product_query->select('COUNT(DISTINCT i.id)');
    		$product_query->from('#__djc2_items AS i');
    		$product_query->join('INNER', '('.(string)$category_subquery.') AS category_filter ON i.id = category_filter.item_id');
    		$product_query->where('i.published = 1 AND i.parent_id = 0');
    		 
    		$nullDate = $db->quote($db->getNullDate());
    		$date = JFactory::getDate();
    		$nowDate = $db->quote($date->toSql());
    		 
    		$product_query->where('(i.publish_up = ' . $nullDate . ' OR i.publish_up <= ' . $nowDate . ')');
    		$product_query->where('(i.publish_down = ' . $nullDate . ' OR i.publish_down >= ' . $nowDate . ')');
    		 
    		$db->setQuery($product_query);
    		 
    		$count = $db->loadResult();
    		if ($count !== false) {
    			$this->item_count = $count;
    		}	
    	}
    	
    	return (isset($this->item_count)) ? $this->item_count : false;
    }
}

class Djc2Categories
{
    protected $nodes = array();
    protected $options = array();
    static $instances = null;

[+] ..
[-] categories.php [edit]
[-] controllerform.php [edit]
[-] customfield.php [edit]
[+] customfields
[-] djlicense.php [edit]
[-] events.php [edit]
[-] geocode.php [edit]
[-] index.html [edit]
[-] modeladmin.php [edit]
[-] upload.php [edit]
[-] .htaccess.disabled [edit]