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

class Model_home extends CI_Model 
{
    public function get_slider_data()
    {
        $query = $this->db->query("SELECT * from tbl_slider ORDER BY id ASC");
        return $query->result_array();
    }
    public function get_why_choose_us_data()
    {
        $query = $this->db->query("SELECT * from tbl_why_choose ORDER BY id ASC");
        return $query->result_array();
    }
    public function get_why_choose_us_photo()
    {
        $query = $this->db->query("SELECT * from tbl_why_choose_photo WHERE id=1");
        return $query->result_array();
    }
    public function get_service_data()
    {
        $query = $this->db->query("SELECT * from tbl_service ORDER BY id ASC");
        return $query->result_array();
    }
    public function get_portfolio_category()
    {
        $query = $this->db->query("SELECT * FROM tbl_portfolio_category ORDER BY category_name ASC");
        return $query->result_array();
    }
    public function get_portfolio_data()
    {
        $query = $this->db->query("SELECT * from tbl_portfolio");
        return $query->result_array();
    }
    public function get_team_member_data()
    {
        $query = $this->db->query("SELECT * 
                                FROM tbl_team_member t1
                                JOIN tbl_designation t2
                                ON t1.designation_id = t2.designation_id
                                ORDER BY t1.id ASC");
        return $query->result_array();
    }
    public function get_testimonial_data()
    {
        $query = $this->db->query("SELECT * from tbl_testimonial ORDER BY id ASC");
        return $query->result_array();
    }
    public function get_testimonial_photo()
    {
        $query = $this->db->query("SELECT * FROM tbl_testimonial_photo WHERE id=1");
        return $query->result_array();
    }
    public function get_faq_data()
    {
        $sql = "SELECT * FROM tbl_faq WHERE faq_show=? OR faq_show=? ORDER BY faq_id ASC";
        $query = $this->db->query($sql,array('On Home Page','On Home and FAQ Page'));
        return $query->result_array();
    }
    public function get_faq_photo()
    {
        $query = $this->db->query("SELECT * FROM tbl_faq_photo WHERE id=1");
        return $query->result_array();
    }
    public function get_gallery_data()
    {
        $query = $this->db->query("SELECT * 
                        FROM tbl_photo
                        WHERE photo_show_home=?
                        ORDER BY photo_id ASC",array('Yes'));
        return $query->result_array();
    }
    public function get_partner_data()
    {
        $query = $this->db->query("SELECT * FROM tbl_partner ORDER BY id ASC");
        return $query->result_array();
    }
}