<?php

/***************************************************************
 * Catabatic Technology Pvt. Ltd.
 * File Name : Investor.php
 * File Description : Investor Model
 * Created By : Pooja
 * Created Date: 16-November-2015
 ***************************************************************/

class Admin_Model_Investor extends Zend_Db_Table_Abstract
{
    function __construct() 
    { 	  
        
    }
       
    /**
    * add() method is used to add  Financial year
    * @param array
    * @return true 
    */
    public function add($addData=array())
    {   
        $dbtable = new Zend_Db_Table('tbl_financial_year_manager');
        $dbtable->insert($addData);
    }
    
    /**
    * edit() method is used to edit Financial year
    * @param array
    * @return true 
    */
    public function edit($editData=array(),$where)
    {   
        $dbtable = new Zend_Db_Table('tbl_financial_year_manager');
        $dbtable->update($editData,$where);
    }
    
    /**
    * getAllfinancialyearList() method is used to get all menus list
    * @param email string
    * @return object 
    */	
    public function getAllfinancialyearList()
    {   
        $dbtable = new Zend_Db_Table('tbl_financial_year_manager');
        $select = $dbtable->select()
                ->order('id');
        $result = $dbtable->fetchAll($select);
        return $result;
    }
    
    /**
    * getFinancialYearDetailsById() method is used to get all menus details by hierarchy menu id
    * @param email string
    * @return object 
    */	
    public function getFinancialYearDetailsById($id)
    {   
        $dbtable = new Zend_Db_Table('tbl_financial_year_manager');
        $select = $dbtable->select()->where('id = ?',$id);
        $result = $dbtable->fetchRow($select);
        return $result;
    }
    
    /**
    * getFinancialYearBySlideId() method is used to get all menus details by hierarchy menu id
    * @param email string
    * @return object 
    */	
    public function getFinancialYearBySlideId($id)
    {   
        $dbtable = new Zend_Db_Table('tbl_financial_year_manager');
        $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_financial_year_manager');
        $where = array('md5(concat("PTC",id))=?'=>$sid);
        $dbtable->delete($where);
    }
    
    
        /**
    * getAllInvestorRelationList() method is used to get all investor relation data
    * @param email string
    * @return object 
    */	
    public function getAllInvestorRelationList()
    {   
//        $dbtable = new Zend_Db_Table('tbl_investor_relations');
        $db = Zend_Db_Table::getDefaultAdapter();
        
        $query = "SELECT ir.id, ir.type, title, investorRelationType, subTitle, Q, Q1, Q2, Q3, Q4
FROM `tbl_investor_relations` ir LEFT JOIN tbl_financial_year_manager fym
on ir.financial_year_manager_id = fym.id ORDER BY ir.investorRelationType ASC";
//        echo $query; die;
        $result = $db->fetchAll($query);
        return $result;
    }
    
    
    
      /**
    * addInvestor() method is used to add  Investor relations
    * @param array
    * @return true 
    */
    public function addInvestor($addData=array())
    {   
        $dbtable = new Zend_Db_Table('tbl_investor_relations');
        $dbtable->insert($addData);
    }
    
    /**
    * editInvestor() method is used to edit Investor relations
    * @param array
    * @return true 
    */
    public function editInvestor($editData=array(),$where)
    {   
        $dbtable = new Zend_Db_Table('tbl_investor_relations');
        $dbtable->update($editData,$where);
    }
    
    /**
    * getAllListByTypeId() method is used to list data by type id
    * @param array
    * @return true 
    */
    public function getAllListByTypeId($type)
    {   
        $dbtable = new Zend_Db_Table('tbl_financial_year_manager');
        $select = $dbtable->select()->where('type = ?',$type);
        $result = $dbtable->fetchAll($select);
        return $result;
    }
    
    
        /**
    * getInvestorRelationBySlideId() method is used to get all menus details by hierarchy menu id
    * @param email string
    * @return object 
    */	
    public function getInvestorRelationBySlideId($id)
    {   
        $dbtable = new Zend_Db_Table('tbl_investor_relations');
        $select = $dbtable->select()->where('md5(concat("PTC",id))= ?',$id);
        $result = $dbtable->fetchRow($select);
        return $result;
    }
    
    
        
        /**
    * getFinancialYearBySlideId() method is used to get all menus details by hierarchy menu id
    * @param email string
    * @return object 
    */	
    public function getinvestorrelationsId($id)
    {   
        $dbtable = new Zend_Db_Table('tbl_investor_relations');
        $select = $dbtable->select()->where('id = ?',$id);
        $result = $dbtable->fetchRow($select);
        return $result;
    }
    
    /**
    * delete() method is used to add menu
    * @param array
    * @return true 
    */
    public function deleteRelation($sid)
    {   
        $dbtable = new Zend_Db_Table('tbl_investor_relations');
        $where = array('id=?'=>$sid);
        $dbtable->delete($where);
    }
    
    
    public function getFinancialYearbyId($id){
      $dbtable = new Zend_Db_Table('tbl_financial_year_manager');
        $select = $dbtable->select()->where('id = ?',$id);
        $result = $dbtable->fetchRow($select);
        return $result;  
    }
    
    

        
}