<?php

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

class Admin_Model_Banner extends Zend_Db_Table_Abstract
{
    function __construct() 
    { 	  
        
    }
    
    public function addlog ($logData=array())
    {   
        $dbtable = new Zend_Db_Table('tbl_dcb_log');
        $dbtable->insert($logData);
    }   

    public function display_log_history($data)
    {
        $dbtable = new Zend_Db_Table('tbl_dcb_log');
        $select = $dbtable->select()
                          ->where('createdBy =?',$data['createdBy'])
                          ->where('pageName =?',$data['pageName']);

         $historyResult = $dbtable->fetchAll($select);

        return $historyResult;

    }
    
    /**
    * add() method is used to add menu
    * @param array
    * @return true 
    */
    public function add($addData=array())
    {   
        $dbtable = new Zend_Db_Table('tbl_banner');
        $dbtable->insert($addData);
    }
    
    /**
    * edit() method is used to add menu
    * @param array
    * @return true 
    */
    public function edit($editData=array(),$where)
    {   
        $dbtable = new Zend_Db_Table('tbl_banner');
        $dbtable->update($editData,$where);
    }
    
    /**
    * getAllSliderList() method is used to get all menus list
    * @param email string
    * @return object 
    */	
    public function getAllBannerList($lid=null)
    {   
        $dbtable = Zend_Db_Table::getDefaultAdapter();
        $select = $dbtable->select()->from(array('tbl' =>'tbl_banner'), array('*'));
        $select->joinLeft(array('tb2' => "tbl_landingpage"), "tbl.landingpage_id = tb2.pageID" , array('pageName'));
        if ($lid) {
            $select->where('tbl.landingpage_id = ?', $lid);
        }
        $select->order('tbl.id');
        $result = $dbtable->fetchAll($select);
        return $result;
    }
    
    /**
    * getMenuDetailsById() method is used to get all menus details by hierarchy menu id
    * @param email string
    * @return object 
    */	
    public function getBannerDetailsById($id)
    {   
        $dbtable = new Zend_Db_Table('tbl_banner');
        $select = $dbtable->select()->where('id = ?',$id);
        $result = $dbtable->fetchRow($select);
        return $result;
    }
    
    /**
    * getSliderDetailsBySlideId() method is used to get all menus details by hierarchy menu id
    * @param email string
    * @return object 
    */	
    public function getBannerDetailsBySlideId($id)
    {   
        $dbtable = new Zend_Db_Table('tbl_banner');
        $select = $dbtable->select()->where('md5(concat("DCB",id))= ?',$id);
        $result = $dbtable->fetchRow($select);
        return $result;
    }
    
    /**
    * delete() method is used to add menu
    * @param array
    * @return true 
    */
    public function delete($sid)
    {   
        $dbtable = new Zend_Db_Table('tbl_banner');
        $where = array('md5(concat("DCB",id))=?'=>$sid);
        $dbtable->delete($where);
    }

    public function LandingPageBanner($pageID)
    {   
        $dbtable = new Zend_Db_Table('tbl_banner');
        $select = $dbtable->select()->from('tbl_banner', array('count' => 'COUNT(*)'))->where('landingpage_id = ?', $pageID);
        $result = $dbtable->fetchRow($select);
        return $result['count'];
    }
        
}