<?php

/***************************************************************
 * Catabatic Technology Pvt. Ltd.
 * File Name : Cms.php
 * File Description : Cms Model
 * Created By : Praveen Kumar
 * Created Date: 05-September-2014
 ***************************************************************/

class Application_Model_Campaigns extends Zend_Db_Table_Abstract
{
    function __construct() 
    { 	  
        
    }
     
    public function add($addData=array())
    {   
        $dbtable = new Zend_Db_Table('tbl_leadcampaign');
        return $dbtable->insert($addData);
    }
    
    
     public function getAllActiveCountryCodeList()
    {   
        $dbtable = new Zend_Db_Table('tbl_countries');
        $select = $dbtable->select()
                          ->where('status =?','Activate')  
                          ->order('Name');
        $result = $dbtable->fetchAll($select);
        return $result;
    }
     public function getPixelCode($id)
    {   
         
        $dbtable =Zend_Db_Table::getDefaultAdapter(); 
        $select = $dbtable->select()->from(array("t1" => "tbl_leadcampaign") , array(""))
                ->joinLeft(array('t2' => "tbl_campaignname"), "t1.utm_source = t2.campaignname",array("pixcel_code"))                
                ->where("t1.id =?", $id);
      
        $result = $dbtable->fetchRow($select);
        return $result;
    }
        
}