<?php

class Travel_Model_TblAgencyEnquiry {

    protected $db = NULL;
    
    /***************************************/

    /* Added By Pardeep Panchal Starts */
    
    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 checkIfAgencyCustomerExists($mobileNumber){
        $arrAgency = array('count(*) as total');
        $select = $this->db->select();
        $select->from(array('t1' => 'TB_Agency_Customer'),$arrAgency);
        $select->where("LTRIM(RTRIM(t1.Contacts)) = ? ",$mobileNumber);
        //echo $select; exit;
        $result = $this->db->fetchRow($select);
        return $result['total'];
    }
    
    
    public function createCrmCustomerAccount($data){
        $this->db->insert('TB_CRM_CustomerAccount', $data);
        return $this->db->lastInsertId('TB_CRM_CustomerAccount');
                    
    }
    
    public function createAgencyCustomer($data){
        $this->db->insert('TB_Agency_Customer', $data);
        return $this->db->lastInsertId('TB_Agency_Customer');
                    
    }
    
    
    /* Added By Pardeep Panchal Ends */
    
    

}