<?php
/**
 * @package DJ-Classifieds
 * @copyright Copyright (C) DJ-Extensions.com, All rights reserved.
 * @license http://www.gnu.org/licenses GNU/GPL
 * @author url: http://dj-extensions.com
 * @author email contact@dj-extensions.com
 */

defined ('_JEXEC') or die('Restricted access');

use Joomla\CMS\Factory;
use Joomla\CMS\Component\ComponentHelper;

require_once(JPATH_ROOT.'/administrator/components/com_djclassifieds/lib/djregion.php');

class modDjClassifiedsRegionsHelper
{
    static function getCategoryRegionItemsCount($cat_path, $reg_path)
    {
        $db = Factory::getDBO();
        $par = ComponentHelper::getParams('com_djclassifieds');
        $date_now = Factory::getDate()->format('Y-m-d H:00:00');
        
        $where = '';
        $reglist = DJClassifiedsRegion::getDefaultRegionsIds();
        if($reglist){
            $where .= 'AND region_id IN ('.$reglist.') ';
        }

		if($par->get('show_archived',0)==2){
			$where .= "AND ((published=1 AND date_exp > '".$date_now."') OR published=2) ";				
		}else{
			$where .= "AND published=1 AND date_exp > '".$date_now."' ";
		}

        $query = "SELECT count(*) as items_count "
        ."FROM #__djcf_items "
        ."WHERE cat_id IN (".$cat_path.") AND region_id IN (".$reg_path.") AND blocked=0 ".$where;
        $db->setQuery($query);
        $items_count = $db->loadResult();

        return $items_count;
    }
}