<?php
/**
 * Class Package Master
 * Description 	This model contains the basic activity functions needed for packages.
 * @name	Package Master
 * @author	Ravi Khare
 * @version 	1.0
 * @copyright 	Catabatic Automation Pvt. Ltd.
 * Handle 	Packate Related function
 *
 */

class Hotels_Model_TblMPAccomMarkup extends Zend_Db_Table_Abstract
{
    private $db          = NULL;
    
    /**
     * Class Constructors
    */
    public function __construct(){
        
        #initialize db adapter
        $this->db = Zend_Db_Table::getDefaultAdapter(); 
        
    }
    
    public function __destruct() {
        $this->db->closeConnection(); 
    }  
    
   
    public function getAgencyMarkupsAccom($AccomType = 1,$AgencySysId = NULL) {
        
        $arrAccom = array('MarkUpType','MarkUp','SOccupMarkUp','DOccupMarkUp','ExtraBedMarkUp','ExtraWOBedMarkUp');
        $select = $this->db->select();
        $select->from(array('tbl' => "TB_MP_StdMarkup_Accom") ,$arrAccom);
        if(!empty($AgencySysId)){
           $select->where("tbl.AgencySysId = ?", $AgencySysId);
        }
        
        $select->where("tbl.ItemSourceType = ?", 1);
        $select->where("tbl.AccomType = ?", $AccomType);
        $select->where("tbl.MPType = ?", 1);
        $select->where("tbl.IsApproved = ?", 1);
        $select->where("tbl.IsMarkForDel = ?", 0);
        $select->where("tbl.IsActive = ?", 1);
        $select->limit(1);
        $result = $this->db->fetchRow($select);
        return $result;
    }
    
    
    
    public function getGTXMarkups($intAccomType,$AgencySysId) {
        $arrAllocMarkups = array('Currency','AccomType','MarkUpType','MarkUp');
        $select = $this->db->select();
        $select->from(array('tbl' => "TB_System_StdMarkup_Accom_Alloc") ,$arrAllocMarkups);
        if(!empty($AgencySysId)){
           $select->where("tbl.AgencySysId = ?", $AgencySysId);
        }
        $select->where("tbl.AccomType = ?", $intAccomType);
        $select->where("tbl.ItemSourceType = ?", 1);
        $select->where("tbl.IsApproved = ?", 1);
        $select->where("tbl.IsMarkForDel = ?", 0);
        $select->where("tbl.IsActive = ?", 1);
        $select->limit(1);
        //echo $select; exit;
        $result = $this->db->fetchAll($select);
        if(count($result) > 0){
            return $result;
        }else{
            $arrAccomMarkups = array('Currency','AccomType','MarkUpType','MarkUp');
            $select = $this->db->select();
            $select->from(array('tbl' => "TB_System_StdMarkup_Accom") ,$arrAllocMarkups);
            $select->where("tbl.ItemSourceType = ?", 1);
            $select->where("tbl.AccomType = ?", $intAccomType);
            $select->where("tbl.IsApproved = ?", 1);
            $select->where("tbl.IsMarkForDel = ?", 0);
            $select->where("tbl.IsActive = ?", 1);
            $select->limit(1);
            $result = $this->db->fetchAll($select);
        }
        return $result;
    }
    
    
    public function getAgencyMarkups($intAccomType = 1,$AgencySysId) {
        $arrAllocMarkups = array('Currency','AccomType','MarkUpType','MarkUp','Tax');
        $select = $this->db->select();
        $select->from(array('tbl' => "TB_MP_StdMarkup_Accom") ,$arrAllocMarkups);
        if(!empty($AgencySysId)){
           $select->where("tbl.AgencySysId = ?", $AgencySysId);
        }
        $select->where("tbl.AccomType = ?", $intAccomType);
        $select->where("tbl.ItemSourceType = ?", 1);
        $select->where("tbl.IsApproved = ?", 1);
        $select->where("tbl.IsMarkForDel = ?", 0);
        $select->where("tbl.IsActive = ?", 1);
        $select->limit(1);
        //echo $select; exit;
        $result = $this->db->fetchAll($select);
        
        return $result;
    }
   
   
    
}