<?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_Faq 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_faq');
        $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_faq');
        $dbtable->update($editData, $where);
    }

    /**
     * getAllSliderList() method is used to get all menus list
     * @param email string
     * @return object 
     */
    public function getAllFaqList($lid = null) {
        $dbtable = Zend_Db_Table::getDefaultAdapter();
        $select = $dbtable->select()->from(array('tbl' =>'tbl_faq'), 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 getFaqDetailsById($id) {
        $dbtable = new Zend_Db_Table('tbl_faq');
        $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 getFaqDetailsBySlideId($id) {
        $dbtable = new Zend_Db_Table('tbl_faq');
        $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_faq');
        $where = array('md5(concat("DCB",id))=?' => $sid);
        $dbtable->delete($where);
    }

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

}