<?php
//--No direct access
defined('_JEXEC') or die('=;)');

jimport('joomla.application.component.model');

include_once(JPATH_BASE."/components/com_vxc/models/user.php");
include_once(JPATH_BASE."/components/com_vxc/models/settings.php");
include_once(JPATH_BASE."/components/com_vxc/models/order.php");
	
class vxcModelOrderIndia extends JModel
{
	var $_id = 0;
	var $_item = null;
	
	
	
	/**
	 * Constructor
	 *
	 * @access	public
	 * @return	void
	 */
	function __construct()
	{
		parent::__construct();
		$this->setDBO(VoxelCareDB::getDatabase());	
	}//function
				
	function SetId($id)
	{		
		$this->_id = (int)$id;
		$this->_item = null;
	}
	
	function store(&$data)
	{
		$table =& $this->getTable('orderindia');				
		$db =& $this->_db;		
		
		$orderid = (int)$data['orderid'];
		
		$sql = "SELECT id FROM #__vxc_orderindia WHERE orderid = ".$orderid;
		
		$db->setQuery($sql);
		
		$oldId = $db->loadResult();
		
		if ($oldId)
		{
			$data['id'] = $oldId;			
		}		
		
		$id = (int)$data['id'];
		$table->reset();	
		$table->load($id);
		if (!$table->bind($data))		
			return false;		
		
		if (!$table->check())
			return false;		
		
		if (!$table->store(true))
			return false;		
		
		$this->SetId($table->id);		
		$data['id'] = $this->_id;	
		
		return true;	
	}	
	
	function getOrderIndiaInfo($orderId)
	{
		$res = array();
		
		$modelSettings = new vxcModelSettings();
		
		$settings =& $modelSettings->getSettings();
			
		$modelOrder = new vxcModelOrder();
		$modelOrder->SetId($orderId);
		
		$order =& $modelOrder->getData();
		$ats = $modelOrder->getAttributes();
		
		
		$delegateDesign = ($order->delegatedesign=='1');

        $designType = 'Basic';

		foreach($ats as $at)
            if ($at->name == 'general.product') {
                switch($at->value) {
                    case "diabetic":
                        $designType = 'Advanced';
                    break;
                }
            }
		
		$res['usage_fee'] = $settings['india.usageFee'];
		if ($delegateDesign && $designType)
		{
			$res['design_type'] = $designType;
			if ($designType=='Basic')			
				$res['design_fee'] = $settings['india.basicDesignFee'];
			else
				$res['design_fee'] = $settings['india.advancedDesignFee'];				
		}
		else
		{
			$res['design_type'] = '';
			$res['design_fee'] = 0;
		}
	
		/*print 'Usage fee: '.$usageFee ;
		print 'Basic fee: '.$basicFee;
		print 'Advanced fee: '.$advancedFee;*/
		return $res;
	}
	function getData()
	{
		if (empty($this->_item))
		{
			$db =& $this->_db;
		
			$sql = "SELECT  oi.id id,
							oi.usage_fee usage_fee,
							oi.design_type design_type,
							oi.design_fee design_fee
					FROM #__vxc_orderindia oi
					WHERE oi.id = ".$this->_id;	
	
			$db->setQuery($sql);
			
			$row = $db->loadObject();
			
			if (!$row)
			{						
				$row = new stdClass();
				$row->id = 0;							
			}
			
			$this->_item = $row;			
		}				
		
		return $this->_item;	
	}		

}// class