<?php

/**
 * Class Agency
 * Description 	This model contains the functions related to Admin.
 * @name	AdminUser
 * @author	Pooja
 * @version 	1.0
 * @copyright 	Catabatic Automation Pvt. Ltd.
 * Handle 	Admin Related function
 *
 */
class Travel_Model_TblAdminUser {

    public $intAgencySysId = NULL;
    public $intMPType = NULL;
    public $intCustGrSysId = NULL;
    public $intMarkupType = NULL;
    private $db = NULL;
    public $baseUrl;

    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 getAdminUserList() {
        $select = $this->db->select()
                ->from("TB_Admin_User")
                ->where("IsMarkForDel =?", 0)
                 ->where("UserRole =1 OR UserRole = 2")
                ->where("IsApproved =?", 1)
                ->where("IsActive =?", 1);
        $result = $this->db->fetchAll($select);
        return $result;
    }

    public function getAdminUserListByRoleId($roleId) {
        $select = $this->db->select()
                ->from("TB_Admin_User")
                ->where("IsMarkForDel =?", 0)
                ->where("UserRole =?",$roleId)
                ->where("IsApproved =?", 1)
                ->where("IsActive =?", 1);
        $result = $this->db->fetchAll($select);
        return $result;
    }

    public function updateData($table, $data, $where) {
        $this->db->update($table, $data, $where);
    }

    public function insertData($table, $data) {
        $this->db->insert($table, $data);
        return $this->db->lastInsertId();
    }
    
    public function getAgencyRelationshipMgr($agencySysId) {
        $select = $this->db->select()
                ->from("TB_Agency_RelationshipMgr")
                ->where("agencySysId =?", $agencySysId);
        $result = $this->db->fetchRow($select);
        return $result;
    }

}