// no direct access
defined('_JEXEC') or die('Restricted access');

require_once(JPATH_ADMIN_JSTORESOCIAL .DS. "classes" .DS. "jcontroller.item.php");


/**
* Jstoresocial Product Controller
*
* @package	Jstoresocial
* @subpackage	Product
*/
class JstoresocialControllerProduct extends JstoresocialControllerItem
{
	/**
	* The context for storing internal data, e.g. record.
	*
	* @var string
	*/
	protected $context = 'product';

	/**
	* The URL view item variable.
	*
	* @var string
	*/
	protected $view_item = 'product';

	/**
	* The URL view list variable.
	*
	* @var string
	*/
	protected $view_list = 'products';

	/**
	* Constructor
	*
	* @access	public
	* @param	array	$config	An optional associative array of configuration settings.
	* @return	void
	*/
	public function __construct($config = array())
	{
		parent::__construct($config);
		$app = JFactory::getApplication();



	}

	/**
	* Return the current layout.
	*
	* @access	protected
	* @param	bool	$default	If true, return the default layout.
	*
	* @return	string	Requested layout or default layout
	*/
	protected function getLayout($default = null)
	{
		if ($default === 'edit')
			return 'product';

		if ($default)
			return 'product';

		$jinput = JFactory::getApplication()->input;
		return $jinput->get('layout', 'product', 'CMD');
	}


}

// no direct access
defined('_JEXEC') or die('Restricted access');

cimport('classes.jtable');


/**
* Jstoresocial Table class
*
* @package	Jstoresocial
* @subpackage	Product
*/
class JstoresocialTableProduct extends JstoresocialTable
{
	/**
	* Constructor
	*
	* @access	public
	* @param	object	&$db	Database connector object
	* @return	void
	*/
	public function __construct(&$db)
	{
		parent::__construct('#__jstoresocial_products', 'id', $db);
	}


}

/**
* Jstoresocial Item Model
*
* @package	Jstoresocial
* @subpackage	Classes
*/
class JstoresocialModelProduct extends JstoresocialModelItem
{
	/**
	* View list alias
	*
	* @var string
	*/
	protected $view_item = 'product';

	/**
	* View list alias
	*
	* @var string
	*/
	protected $view_list = 'products';

	/**
	* Constructor
	*
	* @access	public
	* @param	array	$config	An optional associative array of configuration settings.
	* @return	void
	*/
	public function __construct($config = array())
	{
		parent::__construct();
	}

	/**
	* Method to delete a product
	*
	* @access	public
	* @param	array	&$pks	The Ids of elements to delete.
	*
	* @return	boolean	True on success
	*/
	public function delete(&$pks = array())
	{
		if (!count( $pks ))
			return true;


		if (!parent::delete($pks))
			return false;



		return true;
	}

	/**
	* Method to get the layout (including default).
	*
	* @access	public
	*
	* @return	string	The layout alias.
	*/
	public function getLayout()
	{
		$jinput = JFactory::getApplication()->input;
		return $jinput->get('layout', 'product', 'STRING');
	}

	/**
	* Returns a Table object, always creating it.
	*
	* @access	public
	* @param	string	$type	The table type to instantiate.
	* @param	string	$prefix	A prefix for the table class name. Optional.
	* @param	array	$config	Configuration array for model. Optional.
	*
	* @return	JTable	A database object
	*
	* @since	1.6
	*/
	public function getTable($type = 'Product', $prefix = 'JstoresocialTable', $config = array())
	{
		return JTable::getInstance($type, $prefix, $config);
	}

	/**
	* Method to increment hits (check session and layout)
	*
	* @access	public
	*
	* @return	boolean	Null if skipped. True when incremented. False if error.
	*
	* @since	11.1
	*/
	public function hit()
	{
		return parent::hit(array());
	}

	/**
	* Method to get the data that should be injected in the form.
	*
	* @access	protected
	*
	* @return	mixed	The data for the form.
	*/
	protected function loadFormData()
	{
		// Check the session for previously entered form data.
		$data = JFactory::getApplication()->getUserState('com_jstoresocial.edit.product.data', array());

		if (empty($data)) {
			//Default values shown in the form for new item creation
			$data = $this->getItem();

			// Prime some default values.
			if ($this->getState('product.id') == 0)
			{
				$jinput = JFactory::getApplication()->input;

				$data->id = 0;
				$data->params = null;
				$data->title = null;
				$data->alias = null;
				$data->category = $jinput->get('filter_category', $this->getState('filter.category'), 'INT');
				$data->product_code = null;


			}
		}
		return $data;
	}

	/**
	* Method to auto-populate the model state.
	* 
	* This method should only be called once per instantiation and is designed to
	* be called on the first call to the getState() method unless the model
	* configuration flag to ignore the request is set.
	* 
	* Note. Calling getState in this method will result in recursion.
	*
	* @access	public
	* @param	string	$ordering	
	* @param	string	$direction	
	* @return	void
	*
	* @since	11.1
	*/
	public function populateState($ordering = null, $direction = null)
	{
		$app = JFactory::getApplication();
		$session = JFactory::getSession();



		parent::populateState($ordering, $direction);
	}

	/**
	* Preparation of the query.
	*
	* @access	protected
	* @param	object	&$query	returns a filled query object.
	* @param	integer	$pk	The primary id key of the product
	* @return	void
	*/
	protected function prepareQuery(&$query, $pk)
	{

		//FROM : Main table
		$query->from('#__jstoresocial_products AS a');

		switch($this->getState('context'))
		{
			case 'product.product':

				//BASE FIELDS
				$query->select(	'a.id,'
							.	'a.alias,'
							.	'a.category,'
							.	'a.product_code,'
							.	'a.title');

				//SELECT
				$query->select('_category_.title AS `_category_title`');
				$query->select('_category_.section AS `_category_section`');
				$query->select('_category_section_.title AS `_category_section_title`');

				//JOIN
				$query->join('LEFT', '`#__jstoresocial_categories` AS _category_ ON _category_.id = a.category');
				$query->join('LEFT', '`#__jstoresocial_sections` AS _category_section_ ON _category_section_.id = _category_.section');

				break;
			default:
				//SELECT : raw complete query without joins
				$query->select('a.*');
				break;
		}

		//SELECT : Instance Add-ons
		foreach($this->getState('query.select', array()) as $select)
			$query->select($select);

		//JOIN : Instance Add-ons
		foreach($this->getState('query.join.left', array()) as $join)
			$query->join('LEFT', $join);

		//WHERE : Item layout (based on $pk)
		$query->where('a.id = ' . (int) $pk);		//TABLE KEY


		//WHERE : Access
		//WHERE : Publish, publish date (state field)
	}

	/**
	* Prepare and sanitise the table prior to saving.
	*
	* @access	protected
	* @param	JTable	&$table	A JTable object.
	*
	* @return	void	
	* @return	void
	*
	* @since	1.6
	*/
	protected function prepareTable(&$table)
	{


		if (empty($table->id)){

		}
		else{

		}
		//Alias
		if (empty($table->alias))
			$table->alias = JApplication::stringURLSafe($table->title);
	}


}

public function save($data)
{
	//Do what you want before. Work with [b]$data[/b]
	
	$result = parent::save($data)	// Keep the original call
	
	//Do what you want after. Read and work on [b]$result[/b]
	// Redirection must be in controller only (catch this $result (integer))

	return $result;
}

		if ($this->city!= null){
		  $maDB = $this->getDbo(); $requete = $maDB->getQuery(true);
		  $maDB->setQuery ("SELECT m.country FROM #__xxx_cities AS m WHERE m.id = $this->city");
		  $resultat = $maDB->loadResult(); $this->country = $resultat;
		}