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

class Blog extends Public_Controller
{

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

        $this->db->select('website_default_language')->from('configuration');
        $language = $this->db->get()->row()->website_default_language;

        if ($language == 'english') {
            $this->session->set_userdata('lang', 'english');
        } else {
            $this->session->set_userdata('lang', 'indonesian');
        }

        //LOAD LANGUAGE FILES FOR BLOG
        if ($this->session->userdata('site_lang') == 'english') {
            $this->lang->load('homepage', 'english');
        } else {
            $this->lang->load('homepage', 'indonesian');
        }

        $this->load->library('pagination');
        $this->load->model('blog_m');
    }

    public function index()
    {

        $this->load->helper('pagination_helper');
        $config = pagination_format();

        $config['base_url'] = base_url() . 'blog/all';
        $config['per_page'] = 10;
        $config['uri_segment'] = 3;

        //fetch all menus
        $config['total_rows'] = $this->db->select('*')->from('blog')->where('status', '1')->get()->num_rows();
        $this->pagination->initialize($config);

        //get all blogs for frontpage
        $this->db->select('*')->from('blog')->where('status', '1')->order_by('publish_date', 'DESC')->limit(3);
        $data['blogs'] = $this->db->get()->result();

        $this->load->view('template2/blogs', $data);
    }

    public function all()
    {
        //get all blogs
        // $this->db->select('*')->from('blog')->where('status', '1')->order_by('publish_date', 'DESC');
        // $data['blogs'] = $this->db->get()->result();

        $this->load->helper('pagination_helper');
        $config = pagination_format();

        $config['base_url'] = base_url() . 'blog/all';
        $config['per_page'] = 10;
        $config['uri_segment'] = 3;

        //fetch all menus
        $config['total_rows'] = $this->db->select('*')->from('blog')->where('status', '1')->get()->num_rows();
        $this->pagination->initialize($config);

        //get all blogs for frontpage
        $this->db->select('*')->from('blog')->where('status', '1')->order_by('publish_date', 'DESC')->limit($config['per_page'], $this->uri->segment($config['uri_segment']));
        $data['blogs'] = $this->db->get()->result();

        $this->db->select('*')->from('home_slideshow')->where('status', 1)->order_by('priority', 'ASC');
        $data['slideshows'] = $this->db->get()->result();

        //get SEO
        $this->data_header['browser_title'] = 'News';
        $this->data_header['meta_description'] = 'News';
        $this->data_header['meta_keywords'] = 'News';

        $this->db->select('*');
        $this->db->from('configuration');
        $data['config'] = $this->db->get()->result();

        foreach ($data['config'] as $item) {
            $this->data_header['image'] = $item->logo;
            $this->data_header['icon'] = $item->website_icon;
            $this->data['fax'] = $item->fax;
            $this->data['hp'] = $item->hp;
            $this->data['company_address'] = $item->company_address;
            $this->data_footer['twitter'] = $item->twitter;
            $this->data_header['instagram'] = $item->instagram;
            $this->data_header['facebook'] = $item->facebook;
            $this->data_footer['website_name'] = $item->website_name;
        }

        $this->load->view('template/header', $this->data_header);
        $this->load->view('template2/blog_category', $data);
        $this->load->view('template/footer', $this->data_footer);
    }

    public function search($key)
    {

        $key = str_replace('-', ' ', $key);

        $data['key'] = $key;

        $data['blogs'] = $this->db->select('*')->from('blog')->where('status', 1)->like('blog', $data['key'])->order_by('publish_date', 'DESC')->get()->result();

        $this->data_header['browser_title'] = 'Search';
        $this->data_header['meta_description'] = 'Search';
        $this->data_header['meta_keywords'] = 'Search';

        $this->load->view('template/header', $this->data_header);
        $this->load->view('template2/blog_category', $data);
        $this->load->view('template/footer', $this->data_footer);
    }

    public function category($category = NULL)
    {

        if ($category == NULL) {
            show_404();
        }

        $category = str_replace('-', ' ', $category);

        $this->load->helper('pagination_helper');
        $config = pagination_format();

        $config['base_url'] = base_url() . 'blog/category/' . url_title($category);
        $config['per_page'] = 2;
        $config['uri_segment'] = 4;

        //fetch all menus
        $config['total_rows'] = $this->db->select('blog.*,category')->from('blog')->join('categories', 'blog.parent=categories.id_categories')->where('blog.status', '1')->where('category', $category)->get()->num_rows();
        $this->pagination->initialize($config);

        //get all blogs for frontpage
        $this->db->select('blog.*,category')->from('blog')->join('categories', 'blog.parent=categories.id_categories')->where('blog.status', '1')->where('category', $category)->order_by('blog.publish_date', 'DESC')->limit($config['per_page'], $this->uri->segment($config['uri_segment']));
        $data['blogs'] = $this->db->get()->result();

        $this->db->select('*')->from('home_slideshow')->where('status', 1)->order_by('priority', 'ASC');
        $data['slideshows'] = $this->db->get()->result();

        $this->data_header['browser_title'] = 'Category';
        $this->data_header['meta_description'] = 'Category';
        $this->data_header['meta_keywords'] = 'Category';

        $this->load->view('template/header', $this->data_header);
        $this->load->view('template2/blog_category', $data);
        $this->load->view('template/footer', $this->data_footer);
    }

    public function get($alias = NULL)
    {

        if ($alias == NULL) {
            show_404();
        }

        //the script belows account if user share a link to outside user. to find the blog article in different language, to avoid 404 page not found in different language
        if ($this->session->userdata('site_lang') == 'english') {

            //check if blog exist in english alias
            $this->db->select('*')->from('blog')->where('alias_en', $alias)->where('status', 1);
            $count = $this->db->get()->num_rows();

            if ($count == 0) {

                //blog not exist in english alias. So check to indonesian
                $this->db->select('*')->from('blog')->where('alias', $alias)->where('status', 1);
                $count_indonesian = $this->db->get()->num_rows();

                if ($count_indonesian == 0) {

                    show_404();
                } else {

                    //blog exist in indonesian. get blog parameter
                    $this->db->select('*')->from('blog')->where('alias', $alias);
                    $data['blog'] = $this->db->get()->row();

                    //change the website session language to indonesian
                    $this->session->set_userdata('site_lang', 'indonesian');
                    $this->load->helper('language');
                    $this->lang->load('website', 'indonesian');
                }
            } else {

                //blog exist in english alias. get blog parameter
                $this->db->select('*')->from('blog')->where('alias_en', $alias);
                $data['blog'] = $this->db->get()->row();

                //change the website session language to english
                $this->session->set_userdata('site_lang', 'english');
                $this->load->helper('language');
                $this->lang->load('website', 'english');
            }
        } else {

            //check if blog exist in indonesian alias
            $this->db->select('*')->from('blog')->where('alias', $alias)->where('status', 1);
            $count = $this->db->get()->num_rows();

            if ($count == 0) {

                //blog not exist in indonesian alias. So check to english
                $this->db->select('*')->from('blog')->where('alias_en', $alias)->where('status', 1);
                $count_english = $this->db->get()->num_rows();

                if ($count_english == 0) {

                    show_404();
                } else {

                    //blog exist in english. get blog parameter
                    $this->db->select('*')->from('blog')->where('alias_en', $alias);
                    $data['blog'] = $this->db->get()->row();

                    //change the website session language to english
                    $this->session->set_userdata('site_lang', 'english');
                    $this->load->helper('language');
                    $this->lang->load('website', 'english');
                }
            } else {

                //blog exist in indonesian alias. get blog parameter
                $this->db->select('*')->from('blog')->where('alias', $alias);
                $data['blog'] = $this->db->get()->row();

                //change the website session language to indonesian
                $this->session->set_userdata('site_lang', 'indonesian');
                $this->load->helper('language');
                $this->lang->load('website', 'indonesian');
            }
        }

        //get all blogs with limit to 10 blogs for the side coloumn
        $this->db->select('*')->from('blog')->where('status', '1')->order_by('publish_date', 'DESC')->limit(10);
        $data['blogs'] = $this->db->get()->result();

        //get SEO
        if ($this->session->userdata('site_lang') == 'english') {
            $this->data_header['browser_title'] = 'News & Events - ' . ucwords($data['blog']->blog_en);
            $this->data_header['meta_description'] = 'News & Events - ' . ucwords($data['blog']->blog_en);
            $this->data_header['meta_keywords'] = 'News & Events - ' . ucwords($data['blog']->blog_en);
        } else {
            $this->data_header['browser_title'] = 'News & Events - ' . ucwords($data['blog']->blog);
            $this->data_header['meta_description'] = 'News & Events - ' . ucwords($data['blog']->blog);
            $this->data_header['meta_keywords'] = 'News & Events - ' . ucwords($data['blog']->blog);
        }

        $this->db->select('*')->from('configuration');
        $data['config'] = $this->db->get()->result();

        foreach ($data['config'] as $item) {
            $this->data_footer['twitter'] = $item->twitter;
            $this->data_header['instagram'] = $item->instagram;
            $this->data_header['facebook'] = $item->facebook;
            $this->data_footer['website_name'] = $item->website_name;
        }

        $this->load->view('template/header', $this->data_header);
        $this->load->view('template2/blog_detail', $data);
        $this->load->view('template/footer', $this->data_footer);
    }
}