<?php
/**
 * Copyright 2013 Catabatic Automation Technology Pvt Ltd.
 * All rights reserved
 *
 * @description: Travel_Model_TblUser.php, User Model. 2016/07/01 13:29
 * @author: Shakti Rana <shakti@catpl.co.in>
 */

include_once 'BaseModel.php';

class Travel_Model_TblCurrencyCon  extends BaseModel{
    
    public function getAgentTrxCurrency() {
        $sessionLogin_user = new Zend_Session_Namespace('sessionLogin_user');
           
        $sql ="SELECT TrxCurrency FROM  TB_Agency WHERE AgencySysId=".$sessionLogin_user->intLoggedinUserAgencySysId;
        $trxCur=$this->db->query($sql)->fetchAll();
        foreach($trxCur as $val){
           $result= $val['TrxCurrency'];
        }
        return $result;
    }
    
    
    public function getMastCurrencyCon($fCurrencyType,$tCurrencyType)
    {
       $sql = "SELECT Rate FROM TB_IC_CurrencyConversion WHERE FCurrencyType='$fCurrencyType' AND TCurrencyType='".$tCurrencyType."'";
        return $this->db->query($sql)->fetch();
    }
    
    
}