<?php

/***************************************************************
 * Catabatic Technology Pvt. Ltd.
 * File Name : Faq.php
 * File Description : Faq Model
 * Created By : Praveen Kumar
 * Created Date: 05-September-2014
 ***************************************************************/

class Admin_Model_Forexrates extends Zend_Db_Table_Abstract
{
    function __construct() 
    { 	  
        
    }
     
    /**
    * getForexratesDetails() method is used to get check name exists or not
    * @param email string
    * @return object 
    */	
    public function getForexratesDetails()
    {   
        $dbtable = Zend_Db_Table::getDefaultAdapter(); 
        $select = $dbtable->select()
                          ->from("tbl_forex_rates")
                          ->where("status =?",'Active')
                          ->order("id DESC")
                          ->limit(1,0);
        $result = $dbtable->fetchRow($select);
        return $result;
    }
    
    /**
    * add() method is used to add name
    * @param array
    * @return true 
    */
    public function add($addfile)
    {   
        $dbtable = Zend_Db_Table::getDefaultAdapter();
        $sql_query = "INSERT INTO `tbl_forex_rates` SET 
                      `forex_rates_file`='".$addfile."',
                      `status`='Active',
                      `createdOn`='".date('Y-m-d')."' ";
        $dbtable->query($sql_query);
    }
      
    /**
    * edit() method is used to edit name
    * @param array
    * @return true 
    */
    public function edit($addfile,$fid)
    {  
        $dbtable = Zend_Db_Table::getDefaultAdapter();
        $sql_query = "UPDATE `tbl_forex_rates` SET 
                      `forex_rates_file`='".$addfile."',
                      `createdOn`='".date('Y-m-d')."'
                      WHERE `id`='".$fid."'";
        $dbtable->query($sql_query);
    }
         
}