<?php

/*
 * Catabatic Technology Pvt. Ltd.
 * File Name :TblCRMCustomer.php
 * File Description :Manage to Customer Operation
 * Created By : Shobhit Srivastav 
 * Created Date: 03-Aug-2016
 */

class Travel_Model_CRM_CustomerTemplate {
    protected $_dbObj;

    public function __construct() {
		
        $this->_custtemplateObj = new Travel_Model_TblCustomerTemplate();
        $this->_dbObj = Zend_Db_Table::getDefaultAdapter();
    }
	
	
	public function GetAllSmsTemplates($templateType){
		$select = $this->_dbObj->select();
		$select->from(array('tb1' => "TB_Agency_Customer_Template"));
		$select->where('tb1.Type = ?', $templateType); //1 for SMS 2 for Email
		$select->where("tb1.IsActive = ?", 1);
		$select->where("tb1.IsMarkForDelete= ?", 0);
		$result = $this->_dbObj->fetchAll($select);
		return $result;
		
	}
	public function GetSmsTemplateById($templateType,$TempSysId){
		$select = $this->_dbObj->select();
		$select->from(array('tb1' => "TB_Agency_Customer_Template"));
		$select->where('tb1.Type = ?', $templateType); //1 for SMS 2 for Email
		$select->where('tb1.TempSysId IN (?)', $TempSysId); //1 for SMS 2 for Email
		$select->where("tb1.IsActive = ?", 1);
		$select->where("tb1.IsMarkForDelete= ?", 0);
		$result = $this->_dbObj->fetchAll($select);
		return $result;
		
	}
	public function GetSmsTemplateByCode($templateType,$code){
		$select = $this->_dbObj->select();
		$select->from(array('tb1' => "TB_Agency_Customer_Template"));
		$select->where('tb1.Type = ?', $templateType); //1 for SMS 2 for Email
		$select->where('tb1.Code = ?', $code); //1 for SMS 2 for Email
		$select->where("tb1.IsActive = ?", 1);
		$select->where("tb1.IsMarkForDelete= ?", 0);
		$result = $this->_dbObj->fetchAll($select);
		return $result;
		
	}
}