<?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_Slider extends Zend_Db_Table_Abstract
{
    function __construct() 
    { 	  
        
    }
       
    /**
    * add() method is used to add menu
    * @param array
    * @return true 
    */
    public function add($addData=array())
    {   
        $dbtable = new Zend_Db_Table('tbl_slider');
        $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_slider');
        $dbtable->update($editData,$where);
    }
    
    /**
    * getAllSliderList() method is used to get all menus list
    * @param email string
    * @return object 
    */	
    public function getAllSliderList($type = null)
    {   
        $dbtable = new Zend_Db_Table('tbl_slider');
        $select = $dbtable->select()
                ->where('type = ?',$type)
                ->order('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 getSliderDetailsById($id)
    {   
        $dbtable = new Zend_Db_Table('tbl_slider');
        $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 getSliderDetailsBySlideId($id)
    {   
        $dbtable = new Zend_Db_Table('tbl_slider');
        $select = $dbtable->select()->where('md5(concat("PTC",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_slider');
        $where = array('md5(concat("PTC",id))=?'=>$sid);
        $dbtable->delete($where);
    }
        
}