<?php

/* * *************************************************************
 * Catabatic Technology Pvt. Ltd.
 * File Name : Menu.php
 * File Description : Menu Model for managed all menus
 * Created By : Prashant Kumar
 * Created Date: 9-Nov-2023
 * ************************************************************* */

class Application_Model_Menu extends Zend_Db_Table_Abstract {

    public $data = array();

    function __construct() {
        
    }

    /**
     * getAllHomePageMenuList() method is used to get all quick or tiled menu list
     * @param email string
     * @return object 
     */
    public function getAllHomePageMenuList($type) {
        $db = Zend_Db_Table::getDefaultAdapter();
        $select = $db->select()
                ->from(array("tm" => "tbl_menu"), array('tm.hierarchy_menu_id', 'tm.quick_link_menu_id'))
                ->join(array('hm' => 'hierarchy_menu'), 'tm.hierarchy_menu_id=hm.id', array('hm.id', 'hm.level', 'hm.url', 'hm.image', 'hm.external_url', "IsDisclaimer", "hm.sub_level_name"))
                ->where('tm.hierarchy_menu_type =?', $type)
                ->where('hm.status =?', 1)
                ->order('tm.orderOfAppearance')
                ->order('tm.id');
        $result = $db->fetchAll($select);
        return $result;
    }

    /**
     * getAllSecondLbQuickMenuList() method is used to get all second lebel quick menu list
     * @param email string
     * @return object 
     */
    public function getAllSecondLbQuickMenuList($quick_link_menu_id) {
        $quick_link_menu_id_arr = @explode(",", @$quick_link_menu_id);
        $db = Zend_Db_Table::getDefaultAdapter();
        $select = $db->select()
                ->from("hierarchy_menu", array('id', 'level', 'url', 'image', 'external_url', "IsDisclaimer"))
                ->where('status =?', 1)
                ->where('id IN(?)', $quick_link_menu_id_arr)
                ->order('id');
        //echo $select; die;
        $result = $db->fetchAll($select);
        return $result;
    }

    /**
     * getAllSecondLbTiledMenuList() method is used to get all second lebel tiled menu list
     * @param email string
     * @return object 
     */
    public function getAllSecondLbTiledMenuList($quick_link_menu_id) {
        $tiled_link_menu_id_arr = @explode(",", @$quick_link_menu_id);
        $db = Zend_Db_Table::getDefaultAdapter();
        $select = $db->select()
                ->from("hierarchy_menu", array('id', 'level', 'url', 'image', 'external_url', "IsDisclaimer", "sub_level_name"))
                ->where('id IN(?)', $tiled_link_menu_id_arr)
                ->where('status =?', 1)
                ->order('orderOfAppearance')
                ->limit(4, 0);
        // echo $select; die;
        $result = $db->fetchAll($select);
        return $result;
    }

    /**
     * getAllSecondLbFooterMenuList() method is used to get all second lebel tiled menu list
     * @param email string
     * @return object 
     */
    public function getAllSecondLbFooterMenuList($quick_link_menu_id) {
        $footer_link_menu_id_arr = @explode(",", @$quick_link_menu_id);
        $db = Zend_Db_Table::getDefaultAdapter();
        $select = $db->select()
                ->from("hierarchy_menu", array('id', 'level', 'url', 'image', 'external_url', "IsDisclaimer"))
                ->where('id IN(?)', $footer_link_menu_id_arr)
                ->where('status =?', 1)
                ->order('id')
                ->limit(7, 0);
        //echo $select; die;
        $result = $db->fetchAll($select);
        return $result;
    }

    /**
     * getMenuListByPageUrl() method is used to get all root menu id
     * @param page_url string
     * @return object 
     */
    public function getMenuListByPageUrl($page_url) {
        $db = Zend_Db_Table::getDefaultAdapter();
        $select = $db->select()
                ->from("hierarchy_menu", array('id', 'parent_id', 'url', 'external_url', 'level', "IsDisclaimer"))
                ->where('status =?', 1)
                ->where('url =?', $page_url);

        $result = $db->fetchRow($select);
        return $result;
    }

    /**
     * getLastParentIdByParentId() method is used to get all root menu id
     * @param page_url string
     * @return object 
     */
    public function getLastParentIdByParentId($parent_id) {
        $db = Zend_Db_Table::getDefaultAdapter();
        $select = $db->select()
                ->from("hierarchy_menu", array('id', 'parent_id', 'url', 'external_url', "IsDisclaimer"))
                ->where('status =?', 1)
                ->where('id =?', $parent_id);
        $result = $db->fetchRow($select);
        return $result;
    }

    /**
     * getAllFirstLbMenuListById() method is used to get all first label menu list
     * @param menu_id integer
     * @return array 
     */
    public function getAllFirstLbMenuListById($menu_id) {
        $db = Zend_Db_Table::getDefaultAdapter();
        $select = $db->select()
                ->from("hierarchy_menu", array('id', 'parent_id', 'level', 'sub_level_name', 'url', 'image', 'external_url', "IsDisclaimer"))
                ->where('id =?', $menu_id)
                ->where('status =?', 1)
                ->order('orderOfAppearance');
        $result = $db->fetchAll($select);
        return $result;
    }

    /**
     * getAllMenuList() method is used to get all menu list
     * @param menu_id integer
     * @return array 
     */
    public function getAllMenuList() {
        $db = Zend_Db_Table::getDefaultAdapter();
        //$select = $db->select()
        //->from("hierarchy_menu", array('id','parent_id','level','sub_level_name','url','image','external_url'))
        //->where('status =?',1);
        $select = "select id,parent_id,level,url,image,external_url,IsDisclaimer from hierarchy_menu where status='1' and FIND_IN_SET('tiled_menu',hierarchy_menu_type) and id!='10' ";
        $result = $db->fetchAll($select);
        return $result;
    }

    /**
     * getAllSecondORThirdOrFourthLbMenuListById() method is used to get all first label menu list
     * @param menu_id integer
     * @return array 
     */
    public function getAllSecondORThirdOrFourthLbMenuListById($menu_id) {
        $db = Zend_Db_Table::getDefaultAdapter();
        $select = $db->select()
                ->from("hierarchy_menu", array('id', 'parent_id', 'level', 'sub_level_name', 'url', 'image', 'external_url', 'IsDisclaimer'))
                ->where('status =?', 1)
                ->where('parent_id =?', $menu_id)
                ->order('orderOfAppearance');
        $result = $db->fetchAll($select);
        return $result;
    }

    /**
     * getAllThirdOrFourthLbMenuListArrayById() method is used to get all third and fourth label menu list
     * @param menu_id integer
     * @return array
     */
    public function getAllThirdOrFourthLbMenuListArrayById($menu_id) {
        $db = Zend_Db_Table::getDefaultAdapter();

        $select = $db->select()
                ->from("hierarchy_menu", array('GROUP_CONCAT(url) as sub_url'))
                ->where('parent_id =?', $menu_id)
                ->where('status =?', 1)
                ->order('orderOfAppearance');
        $result = $db->fetchRow($select);
        return $result;
    }

    /**
     * getQuickLinkColumn123DataList() method is used to get all quick or tiled menu list
     * @param email string
     * @return object
     */
    public function getQuickLinkColumn123DataList($type) {
        $db = Zend_Db_Table::getDefaultAdapter();
        $select = $db->select()
                ->from(array("tm" => "tbl_menu"), array('tm.quick_link_menu_id'))
                ->join(array('hm' => 'hierarchy_menu'), 'tm.quick_link_menu_id=hm.id', array('hm.id', 'hm.level', 'hm.url', 'hm.image', 'hm.external_url', 'IsDisclaimer'))
                ->where('tm.hierarchy_menu_type =?', $type)
                ->where('hm.status =?', 1)
                ->order(array('tm.orderOfAppearance', 'hm.level'))
                ->limit(11, 0);
        $result = $db->fetchAll($select);
        return $result;
    }

    /**
     * getAllParentDetailsArrayById() method is used to get all first label menu list
     * @param menu_id integer
     * @return array 
     */
    public function getAllParentDetailsArrayById($parent_id) {
        $db = Zend_Db_Table::getDefaultAdapter();
        $select = $db->select()
                ->from("hierarchy_menu", array('id', 'parent_id', 'level', 'sub_level_name', 'url', 'image', 'external_url', 'IsDisclaimer'))
                ->where('status =?', 1)
                ->where('id =?', $parent_id)
                ->order('orderOfAppearance');
        $result = $db->fetchRow($select);
        return $result;
    }

    /**
     * getChildListById() method is used to check state name exists or not in db
     * @param email string
     * @return object 
     */
    public function getChildListById($id) {
        $db = Zend_Db_Table::getDefaultAdapter();
        $select = $db->select()
                ->from("hierarchy_menu", array('count(*) AS total_record'))
                ->where('parent_id = ?', $id)
                ->where('status =?', 1);
        ;
        $result = $db->fetchOne($select);

        return $result;
    }

    /**
     * getParentUrlByUrl() method is used to get all quick or tiled menu list
     * @param email string
     * @return object
     */
    public function getParentUrlByUrl($page_name) {
        $db = Zend_Db_Table::getDefaultAdapter();
        $select = $db->select()
                ->from(array("hmm" => "hierarchy_menu"))
                ->join(array('hm' => 'hierarchy_menu'), 'hmm.parent_id=hm.id', array('hm.id', 'hm.level', 'hm.url', 'hm.image', 'hm.external_url', 'IsDisclaimer'))
                ->where('hmm.url =?', $page_name)
                ->where('hm.status =?', 1);

        $result = $db->fetchRow($select);
        return $result;
    }

    /**
     * getAllTopMenuList() method is used to get all tiled menu list
     * @param email string
     * @return object
     */
    public function getAllTopMenuList() {
        $tiled_menus = $this->getAllHomePageMenuList($type = 'tiled_menu');
        //echo "<pre>";print_r($tiled_menus);exit;
        $tiled_menu_list_arr = array();
        foreach ($tiled_menus as $tiled_menus_list) {

            $secondlb_tiled_menus = $this->getAllSecondLbTiledMenuList($tiled_menus_list['quick_link_menu_id']);
            $secondlb_tiled_menus_list_arr = array();
            foreach ($secondlb_tiled_menus as $secondlb_tiled_menus_list) {
                $secondlb_tiled_menus_list_arr[] = array(
                    'id' => $secondlb_tiled_menus_list['id'],
                    'level_name' => $secondlb_tiled_menus_list['level'],
                    'sub_level_name' => $secondlb_tiled_menus_list['sub_level_name'],
                    'url' => $secondlb_tiled_menus_list['url'],
                    'IsDisclaimer' => $secondlb_tiled_menus_list['IsDisclaimer'],
                    'external_url' => $secondlb_tiled_menus_list['external_url'],
                    'image' => $secondlb_tiled_menus_list['image']
                );
            }

            $tiled_menu_list_arr[] = array(
                'id' => $tiled_menus_list['id'],
                'hierarchy_menu_id' => $tiled_menus_list['hierarchy_menu_id'],
                'level_name' => $tiled_menus_list['level'],
                'sub_level_name' => $tiled_menus_list['sub_level_name'],
                'url' => $tiled_menus_list['url'],
                'external_url' => $tiled_menus_list['external_url'],
                'IsDisclaimer' => $tiled_menus_list['IsDisclaimer'],
                'image' => $tiled_menus_list['image'],
                'secondlb_menu_count' => count($secondlb_tiled_menus_list_arr),
                'secondlb_menu' => $secondlb_tiled_menus_list_arr
            );
        }

        return $tiled_menu_list_arr;
    }

    /**
     * getAllHomePageMobileMenuList() method is used to get all quick or tiled menu list
     * @param email string
     * @return object 
     */
    public function getAllHomePageMobileMenuList($type) {
        $db = Zend_Db_Table::getDefaultAdapter();
        $select = $db->select()
                ->from(array("tm" => "tbl_menu"), array('tm.hierarchy_menu_id', 'tm.quick_link_menu_id'))
                ->join(array('hm' => 'hierarchy_menu'), 'tm.hierarchy_menu_id=hm.id', array('hm.id', 'hm.level', 'hm.url', 'hm.image', 'hm.external_url', 'IsDisclaimer'))
                ->where('tm.hierarchy_menu_type =?', $type)
                ->where('hm.status =?', 1)
                ->order('tm.mobileOrder');
        $result = $db->fetchAll($select);
        return $result;
    }

    /**
     * getAllTopMobileOrderMenuList() method is used to get all tiled menu list
     * @param email string
     * @return object
     */
    public function getAllTopMobileOrderMenuList() {
        $m_tiled_menus = $this->getAllHomePageMobileMenuList($type = 'tiled_menu');

        // echo "<pre>";
        // print_r($m_tiled_menus);
        // die();

        $tiled_mobile_menu_list_arr = array();
        foreach ($m_tiled_menus as $m_tiled_menus_list) {

            $m_secondlb_tiled_menus = $this->getAllSecondLbTiledMenuList($m_tiled_menus_list['quick_link_menu_id']);
            $m_secondlb_tiled_menus_list_arr = array();
            foreach ($m_secondlb_tiled_menus as $m_secondlb_tiled_menus_list) {
                $m_secondlb_tiled_menus_list_arr[] = array(
                    'id' => $m_secondlb_tiled_menus_list['id'],
                    'level_name' => $m_secondlb_tiled_menus_list['level'],
                    'url' => $m_secondlb_tiled_menus_list['url'],
                    'external_url' => $m_secondlb_tiled_menus_list['external_url'],
                    'IsDisclaimer' => $m_secondlb_tiled_menus_list['IsDisclaimer'],
                    'image' => $m_secondlb_tiled_menus_list['image']
                );
            }

            $tiled_mobile_menu_list_arr[] = array(
                'id' => $m_tiled_menus_list['id'],
                'hierarchy_menu_id' => $m_tiled_menus_list['hierarchy_menu_id'],
                'level_name' => $m_tiled_menus_list['level'],
                'url' => $m_tiled_menus_list['url'],
                'external_url' => $m_tiled_menus_list['external_url'],
                'image' => $m_tiled_menus_list['image'],
                'IsDisclaimer' => $m_tiled_menus_list['IsDisclaimer'],
                'secondlb_menu_count' => count($m_secondlb_tiled_menus_list_arr),
                'secondlb_menu' => $m_secondlb_tiled_menus_list_arr
            );
        }

        return $tiled_mobile_menu_list_arr;
    }

}