<?php

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

class Travel_Model_TblPackageInclusions {

    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 addPackageInclusions($data = array()) {
            $this->db->insert('TB_Master_PackInclusion', $data);
            return $this->db->lastInsertId();
    }
    
    
    public function updatePackageInclusions($data = array(),$intId) {
            $strWhereCondition = array('InclId =?' => $intId);
            $this->db->update('TB_Master_PackInclusion', $data,$strWhereCondition);
    }

    

    public function getPackageInclusionsList($isActive = NULL) {
        $strCondition = " 1 = 1";
        if ($isActive) {
            $strCondition .= " AND IsActive = ".$isActive;
        }
        $strCondition .= " AND IsMarkForDel != '1' ";
        $select = $this->db->select()
                ->from("TB_Master_PackInclusion")
                ->where($strCondition)
                ->order("Title Asc");
        $result = $this->db->fetchAll($select);
        return $result;
    }

    

    
    public function isPackageInclusionsExists($strTitle,$intId = NULL) {
        
        $strCondition = " Title = '".$strTitle."'";
        if(!empty($intId)){
          $strCondition .= " AND InclId != '".$intId."'";  
        }
        $select = $this->db->select()
                ->from("TB_Master_PackInclusion", array('count(*) AS totalRecords'))
                ->where($strCondition);
    
        //echo $select->__toString();exit;
        
        $result = $this->db->fetchOne($select); 
        if ($result > 0) {
            return true;
        }
        return false;
    }
    
    
    
    public function getDataByPackageInclusionsId($intId = NULL) {
        $select = $this->db->select()
                ->from("TB_Master_PackInclusion")
                ->where("InclId =?", $intId);
        $result = $this->db->fetchRow($select);
        return $result;
    }
    
    
    public function deletePackageInclusions($intId,$data)
    {
        $strWhereCondition = array('InclId =?' => $intId); 
        $this->db->update('TB_Master_PackInclusion',$data,$strWhereCondition);
    }
    

}