<?php
/**
*
* user_shoppergroup__xref table
*
* @package	VirtueMart
* @subpackage User
* @author Max Milbers
* @link http://www.virtuemart.net
* @copyright Copyright (c) 2004 - 2010 VirtueMart Team. All rights reserved.
* @license http://www.gnu.org/copyleft/gpl.html GNU/GPL, see LICENSE.php
* VirtueMart is free software. This version may have been modified pursuant
* to the GNU General Public License, and as distributed it includes or
* is derivative of works licensed under the GNU General Public License or
* other free or open source software licenses.
* @version $Id: user_shoppergroup.php 2420 2010-06-01 21:12:57Z oscar $
*/

// Check to ensure this file is included in Joomla!
defined('_JEXEC') or die('Restricted access');

if(!class_exists('VmTableXarray'))require(JPATH_VM_ADMINISTRATOR.DS.'helpers'.DS.'vmtablexarray.php');

/**
 * user_shoppergroup_xref table class
 * The class is used to link users to shoppergroups.
 *
 * @package	VirtueMart
 * @author Max Milbers
 */

 class TableVmuser_shoppergroups extends VmTableXarray {

//	/** @var int User ID */
//	var $id			= 0;
//	/** @var int Vendor ID */
//	var $virtuemart_user_id			= 0;
//	/** @var int shoppergroup ID */
//	var $virtuemart_shoppergroup_id	= 0;


	/**
	 * @param $db Class constructor; connect to the database
	 */
	function __construct(&$db)
	{
		parent::__construct('#__virtuemart_vmuser_shoppergroups', 'id', $db);
		$this->setPrimaryKey('virtuemart_user_id');
		$this->setSecondaryKey('virtuemart_shoppergroup_id');
	}

 	/**
	 * Records in this table do not need to exist, so we might need to create a record even
	 * if the primary key is set. Therefore we need to overload the store() function.
	 *
	 * @author Oscar van Eijk
	 * @see libraries/joomla/database/JTable#store($updateNulls)
	 */
//	public function store()
//	{
//		$_qry = 'SELECT virtuemart_user_id '
//				. 'FROM #__virtuemart_vmuser_shoppergroups '
//				. 'WHERE virtuemart_user_id = ' . $this->virtuemart_user_id
//		;
//		$this->_db->setQuery($_qry);
//		$_count = $this->_db->loadResultArray();
//
//		if (count($_count) > 0) {
//			$returnCode = $this->_db->updateObject( $this->_tbl, $this, $this->_tbl_key, false );
//		} else {
//			$returnCode = $this->_db->insertObject( $this->_tbl, $this, $this->_tbl_key);
//		}
//
//		if (!$returnCode){
//			$this->setError(get_class( $this ).'::store failed - '.$this->_db->getErrorMsg());
//			return false;
//		}
//		else return true;
//	}

 }
