<?php

/***************************************************************
 * Catabatic Technology Pvt. Ltd.
 * File Name : Pressrelease.php
 * File Description : Press Release Model
 * Created By : Pooja choudhary
 * Created Date: 09-November-2015
 ***************************************************************/

class Admin_Model_Pressrelease extends Zend_Db_Table_Abstract
{
    function __construct() 
    { 	  
        
    }
       
    /**
    * add() method is used to add Press Release
    * @param array
    * @return true 
    */
    public function add($addData=array())
    {   
        
//        echo '<pre>'; print_r($addData); die;
        $dbtable = new Zend_Db_Table('tbl_press_releases');
//        echo '<pre>'; print_r($dbtable); die;
        $dbtable->insert($addData);
    }
    
    /**
    * edit() method is used to add Press Release
    * @param array
    * @return true 
    */
    public function edit($editData=array(),$where)
    {   
        $dbtable = new Zend_Db_Table('tbl_press_releases');
        $dbtable->update($editData,$where);
    }
    
    /**
    * getAllPressreleaseList() method is used to get all menus list
    * @param email string
    * @return object 
    */	
    public function getAllPressreleaseList()
    {   
        $dbtable = new Zend_Db_Table('tbl_press_releases');
        $select = $dbtable->select()->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 getPressreleaseDetailsById($id)
    {   
        $dbtable = new Zend_Db_Table('tbl_press_releases');
        $select = $dbtable->select()->where('id = ?',$id);
        $result = $dbtable->fetchRow($select);
        return $result;
    }
    
    /**
    * getReleaseDetailsById() method is used to get press release details by id
    * @param email string
    * @return object 
    */	
    public function getReleaseDetailsById($id)
    {   
        $dbtable = new Zend_Db_Table('tbl_press_releases');
        $select = $dbtable->select()->where('md5(concat("PTC",id))= ?',$id);
        $result = $dbtable->fetchRow($select);
        return $result;
    }
    
    /**
    * delete() method is used to delete press release
    * @param array
    * @return true 
    */
    public function delete($sid)
    {   
        $dbtable = new Zend_Db_Table('tbl_press_releases');
        $where = array('id=?'=>$sid);
        $dbtable->delete($where);
    }
        
}