Elep

<?php

/**
 * @author          Tassos.gr
 * @link            https://www.tassos.gr
 * @copyright       Copyright © 2024 Tassos All Rights Reserved
 * @license         GNU GPLv3 <http://www.gnu.org/licenses/gpl.html> or later
*/

namespace NRFramework\Conditions\Conditions\Component;

defined('_JEXEC') or die;

class JShoppingBase extends ComponentBase
{
    /**
     * The component's Single Page view name
     *
     * @var string
     */
    protected $viewSingle = 'product';

/**
     * The component's option name
     *
     * @var string
     */
    protected $component_option = 'com_jshopping';

/**
     * Class Constructor
     *
     * @param object $options
     * @param object $factory
     */
    public function __construct($options, $factory)
	{
        parent::__construct($options, $factory);
        $this->request->view = $this->app->input->get('view', $this->app->input->get('controller'));
        $this->request->id = $this->app->input->getInt('product_id');
    }
    
    /**
     * Get single page's assosiated categories
     *
     * @param   Integer  The Single Page id
	 * 
     * @return  array
     */
	protected function getSinglePageCategories($id)
	{
        $db = $this->db;

$query = $db->getQuery(true)
            ->select('category_id')
            ->from('#__jshopping_products_to_categories')
            ->where($db->quoteName('product_id') . '=' . $db->q($id));

$db->setQuery($query);

return $db->loadColumn();
	}
}