<?php

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

class Application_Model_Cms extends Zend_Db_Table_Abstract
{
    function __construct() 
    { 	  
        
    }
       
    /**
    * getPageContentByPageUrl() method is used to get page content by page url
    * @param page_url string
    * @return object 
    */	
    public function getPageContentByPageUrl($page_url,$deviceType){   
        $db = Zend_Db_Table::getDefaultAdapter(); 
        $select = $db->select()
                     ->from(array("tbl_static_pages"), array('application_type','page_name','page_key','page_title','page_description','background_image','content_template_type','content_menu_link_id','meta_title','meta_keywords','meta_description','heading_h1','content_menu_link_id'))
                     ->where('status =?','Activate')
                     ->where('page_key =?',$page_url)
                     ->where('application_type =?',$deviceType)
                     ->where('is_publish =?',1);
        $result = $db->fetchRow($select);
        return $result;
    }
    
    /**
    * getAllContentMenuList() method is used to get all content menu list by page id
    * @param content_menu_link_id string
    * @return object 
    */	
    public function getAllContentMenuList($content_menu_link_id)
    {   
        $db = Zend_Db_Table::getDefaultAdapter(); 
        $content_menu_link_id_arr = @explode(",",$content_menu_link_id);
        $select = $db->select()
                     ->from(array("hierarchy_menu"), array('id','parent_id','level','url','external_url',"IsDisclaimer"))
                     ->where('status =?',1)
                     ->where('id IN (?)',$content_menu_link_id_arr)
                     ->order(array('orderOfAppearance','level DESC'));
        $result = $db->fetchAll($select);
        return $result;
    }


    /**
    * getBoardListByBoardType() method is used to get page content by page url
    * @param page_url string
    * @return object
    */
    public function getBoardListByBoardType($board_type)
    {
        $db = Zend_Db_Table::getDefaultAdapter();
        $select = $db->select()
                     ->from(array("tbl_board_directors"), array('id','board_type','name','designation','profile_image','profile_details','url'))
                     ->where('status =?','Activate')
                     ->where('board_type =?',$board_type)
                     ->order('orderOfAppearance');
        $result = $db->fetchAll($select);
        return $result;
    }

    /**
    * getBoardListByBoardType() method is used to get page content by page url
    * @param page_url string
    * @return object
    */
    public function getListCustomerContact()
    {
        $db = Zend_Db_Table::getDefaultAdapter();
        $select = $db->select()
                     ->from(array("tbl_customercontact"), array('id','title','image'))
                     ->where('status =?','Activate')
                     ->order('id','desc');
        $result = $db->fetchAll($select);
        return $result;
    }
    
    
    /**
    * getBoardDetailsByBoardType() method is used to get board details
    * @param page_url string
    * @return object
    */
    public function getBoardDetailsByBoardType($board_type,$ppage_url_int)
    {
        //echo $ppage_url_int; exit;
        $db = Zend_Db_Table::getDefaultAdapter();
        $select = $db->select()
                     ->from(array("tbl_board_directors"), array('id','board_type','name','designation','profile_image','profile_details','url'))
                     ->where('status =?','Activate')
                     ->where('board_type =?',$board_type)
                     ->where('url =?',$ppage_url_int);
        $result = $db->fetchRow($select);
        return $result;
    }
    
    
    /**
    * getSearchListByKeyword() method is used to get all content by search keyword
    * @param page_url string
    * @return object
    */
    public function getSearchListByKeyword($search_keyword_str,$deviceType)
    {
        $db = Zend_Db_Table::getDefaultAdapter();
        $search_keyword = trim($search_keyword_str);
        $select = "SELECT hm.id,spt.id, spt.page_name, spt.page_key, spt.page_title, spt.page_description, spt.meta_title 
                      FROM `hierarchy_menu` AS hm 
                      JOIN `tbl_static_pages` AS spt ON (spt.page_key=hm.url) 
                      WHERE hm.status='1' and spt.status='Activate' and spt.is_publish='1' and spt.application_type='".$deviceType."'
                      and (hm.level LIKE '%$search_keyword%')  ";
        $result = $db->fetchAll($select);
        return $result;
    }
    
    public function getBlogSearchListByKeyword($search_keyword_str)
    {
        $db = Zend_Db_Table::getDefaultAdapter();
        $search_keyword = trim($search_keyword_str);
        $select = "SELECT bl.id,bl.title, bl.blogPageKey,bl.description
                      FROM `tbl_blog` AS bl 
                      WHERE bl.status='Activate' and (bl.title LIKE '%$search_keyword%')";
        $result = $db->fetchAll($select);
        return $result;
    }
    
    /**
    * getPageDetails() method is used to get board details
    * @param page_url string
    * @return object
    */
    public function getPageDetails()
    {
        $db = Zend_Db_Table::getDefaultAdapter();
        $select = $db->select()
                     ->from(array("tbl_user"), array('page_title','page_description','page_keywords'))
                     ->where('status =?','Activate')
                     ->where('type =?','superadmin')
                     ->where('id =?',1);
        $result = $db->fetchRow($select);
        return $result;
    }
    
    
    /**
    * getForexratesDetails() method is used to get forex rates details
    * @param email string
    * @return object 
    */	
    public function getForexratesDetails()
    {   
        $dbtable = Zend_Db_Table::getDefaultAdapter(); 
        $select = $dbtable->select()
                          ->from("tbl_forex_rates")
                          ->where("status =?",'Active')
                          ->order("id DESC")
                          ->limit(1,0);
        $result = $dbtable->fetchRow($select);
        return $result;
    }
        
}