<?php

/*
 * Catabatic Technology Pvt. Ltd.
 * File Name :TblHaultInclusions.php
 * File Description :TblHaultInclusions.php
 * Created By : Pardeep Panchal
 * Created Date: 2nd-Aug-2016
 */

class Travel_Model_TblLanguage {

    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 addLanguage($data = array()) {
            $this->db->insert('TB_Master_Lang', $data);
            return $this->db->lastInsertId();
    }
    
    
    public function updateLanguage($data = array(),$intId) {
            $strWhereCondition = array('LangSysId =?' => $intId);
            $this->db->update('TB_Master_Lang', $data,$strWhereCondition);
    }

    

    public function getLanguageList($isActive = NULL) {
        $strCondition = " 1 = 1";
        $select = $this->db->select()
                ->from("TB_Master_Lang")
                ->where($strCondition)
                ->order("TitleEng Asc");
        $result = $this->db->fetchAll($select);
        return $result;
    }

    

    
    public function isLanguageExists($strTitle,$intId = NULL) {
        
        $strCondition = " TitleEng = '".$strTitle."'";
        if(!empty($intId)){
          $strCondition .= " AND LangSysId != '".$intId."'";  
        }
        $select = $this->db->select()
                ->from("TB_Master_Lang", array('count(*) AS totalRecords'))
                ->where($strCondition);
    
        //echo $select->__toString();exit;
        
        $result = $this->db->fetchOne($select); 
        if ($result > 0) {
            return true;
        }
        return false;
    }
    
    
    
    public function getDataByLanguageId($intId = NULL) {
        $select = $this->db->select()
                ->from("TB_Master_Lang")
                ->where("LangSysId =?", $intId);
        $result = $this->db->fetchRow($select);
        return $result;
    }
    
    
   
    

}