<?php

class Travel_Model_TblFlightNew
{

    protected $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 checkActiveAPI($AgencySysId, $APISourceSysId = NULL)
    {
        $select = $this->db->select()
            ->from("TB_Agency_API")
            ->where("AgencySysId =?", $AgencySysId)
            ->where("IsmarkForDel =?", 0)
            ->where("IsActive =?", 1);

        if (!empty($APISourceSysId)) {
            $select->where("APISourceSysId =?", $APISourceSysId);
            $result = $this->db->fetchRow($select);
        } else {
            $result = $this->db->fetchAll($select);
        }

        return $result;
    }
}