<?php if (!defined('BASEPATH')) exit('No direct script access allowed');

class Footer_m extends MY_Model
{

    function __construct()
    {
        parent::__construct();
    }

    public function get_all_categories()
    {
        $this->db->order_by('column_position', 'ASC');
        $this->db->order_by('display_order', 'ASC');
        $categories = $this->db->get('footer_categories')->result_array();

        // Get links for each category
        foreach ($categories as &$category) {
            $category['links'] = $this->get_links_by_category($category['id']);
        }

        return $categories;
    }

    public function get_category_by_id($category_id)
    {
        $this->db->where('id', $category_id);
        return $this->db->get('footer_categories')->row();
    }

    public function get_category_link_by_id($category_id)
    {
        $this->db->where('id', $category_id);
        return $this->db->get('footer_links')->row();
    }

    public function get_links_by_category($category_id)
    {
        $this->db->where('category_id', $category_id);
        $this->db->where('is_active', 1);
        $this->db->order_by('display_order', 'ASC');
        return $this->db->get('footer_links')->result_array();
    }

    public function get_social_media()
    {
        $this->db->order_by('display_order', 'ASC');
        return $this->db->get('footer_social_media')->result_array();
    }

    public function get_social_media_by_id($social_id)
    {
        $this->db->where('id', $social_id);
        return $this->db->get('footer_social_media')->row();
    }

    public function get_payment_methods()
    {
        $this->db->order_by('display_order', 'ASC');
        return $this->db->get('footer_payment_methods')->result_array();
    }

    public function get_payment_by_id($payment_id)
    {
        $this->db->where('id', $payment_id);
        return $this->db->get('footer_payment_methods')->row();
    }

    public function get_asmaradoor()
    {
        $this->db->where('is_active', 1);
        $this->db->limit(1);
        return $this->db->get('footer_asmaradoor')->row_array();
    }

    public function get_footer_bottom()
    {
        $this->db->where('is_active', 1);
        $this->db->limit(1);
        return $this->db->get('footer_bottom')->row_array();
    }

    public function get_asmaradoor_by_id($asmaradoor_id)
    {
        $this->db->where('id', $asmaradoor_id);
        return $this->db->get('footer_asmaradoor')->row();
    }

    public function get_footer_bottom_by_id($footer_id)
    {
        $this->db->where('id', $footer_id);
        return $this->db->get('footer_bottom')->row();
    }
}