<?php 
class Travel_Model_Taxcalculation {
  private $db = NULL;

    public function __construct() {
        $request = Zend_Controller_Front::getInstance()->getRequest();
        $this->baseUrl = $request->getScheme() . '://' . $request->getHttpHost();
        $this->db = Zend_Db_Table::getDefaultAdapter();
    }

    public function __destruct() {
        $this->db->closeConnection();
    }    
   
    public function getTaxdetail($countryId,$TaxCatSysId){
            $SQL="SELECT TX.Percentage FROM TB_Master_TaxRate TX
            LEFT JOIN   TB_Master_TaxCategory TC  ON TX.TaxCatSysId=TC.TaxCatSysId 
            WHERE CountrySysId='".$countryId."' AND  TX.TaxCatSysId='".$TaxCatSysId."'";
            $res= $this->db->query($SQL)->fetchAll();
             foreach($res as $val){
              echo $result=round($val['Percentage']);
           
            }
       return ;
       
   }
   
    public function getTaxdetailAmt($countryId,$TaxCatSysId,$amt){
            $SQL="SELECT TX.Percentage FROM TB_Master_TaxRate TX
            LEFT JOIN   TB_Master_TaxCategory TC  ON TX.TaxCatSysId=TC.TaxCatSysId 
            WHERE CountrySysId='".$countryId."' AND  TX.TaxCatSysId='".$TaxCatSysId."'";
            $res= $this->db->query($SQL)->fetchAll();
             foreach($res as $val){
               $result=round($val['Percentage']);
                   $tax=(100+$result)/100;
                    $amtTax=$amt*$tax;
              echo  $finalTaxAmt= $amtTax-$amt;
            }
       return $finalTaxAmt ;
   }
   public function getTaxdetailWithAmt($countryId,$TaxCatSysId,$amt){
            $SQL="SELECT TX.Percentage FROM TB_Master_TaxRate TX
            LEFT JOIN   TB_Master_TaxCategory TC  ON TX.TaxCatSysId=TC.TaxCatSysId 
            WHERE CountrySysId='".$countryId."' AND  TX.TaxCatSysId='".$TaxCatSysId."'";
            $res= $this->db->query($SQL)->fetchAll();
             foreach($res as $val){
               $result=round($val['Percentage']);
                   $tax=(100+$result)/100;
                    $amtTax=$amt*$tax;
               $finalTaxAmt= $amtTax-$amt;
              echo round($finalTaxAmt+$amt);
            }
       return  ;
   }
}



?>