|
Server : Apache/2.4.18 (Ubuntu) System : Linux canvaswebdesign 3.13.0-71-generic #114-Ubuntu SMP Tue Dec 1 02:34:22 UTC 2015 x86_64 User : oppastar ( 1041) PHP Version : 7.0.33-0ubuntu0.16.04.15 Disable Function : pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wifcontinued,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority, Directory : /var/www/asietex.co.id/public_html/application/controllers/ |
Upload File : |
<?php defined('BASEPATH') OR exit('No direct script access allowed');
class Page extends Public_Controller {
public function __construct() {
parent::__construct();
}
public function get($alias = NULL) {
if ($alias == NULL) { show_404(); }
if($this->session->userdata('site_lang') == 'english') {
//check if english page exist
$this->db->select('*')->from('pages')->where('alias_en', $alias)->where('status', 1);
$count_en = $this->db->get()->num_rows();
if ($count_en == 0) {
//page not exist in english alias. So check to indonesian
$this->db->select('*')->from('pages')->where('alias', $alias)->where('status', 1);
$count_id = $this->db->get()->num_rows();
if($count_id == 0) {
show_404();
} else {
//page exist for indonesian
//get page parameters
$this->db->select('*')->from('pages')->where('alias', $alias);
$data['page'] = $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 {
//page exist for english
//get page parameters
$this->db->select('*')->from('pages')->where('alias_en', $alias);
$data['page'] = $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 {
//initial language is indonesian
//check if indonesian page exist
$this->db->select('*')->from('pages')->where('alias', $alias)->where('status', 1);
$count_id = $this->db->get()->num_rows();
if ($count_id == 0) {
//page not exist in indonesian alias. So check to english
$this->db->select('*')->from('pages')->where('alias_en', $alias)->where('status', 1);
$count_en = $this->db->get()->num_rows();
if($count_en == 0) {
show_404();
} else {
//page exist for english
//get page parameters
$this->db->select('*')->from('pages')->where('alias_en', $alias);
$data['page'] = $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 {
//page exist for indonesian
//get page parameters
$this->db->select('*')->from('pages')->where('alias', $alias);
$data['page'] = $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');
}
}
if($this->session->userdata('site_lang') == 'english') {
$this->db->select('type_view')->from('pages')->where('alias_en', $alias);
$type_view = $this->db->get()->row()->type_view;
}
else{
$this->db->select('type_view')->from('pages')->where('alias', $alias);
$type_view = $this->db->get()->row()->type_view;
}
if($this->session->userdata('site_lang') == 'english') {
$this->db->select('banner')->from('pages')->where('alias_en', $alias);
}
else{
$this->db->select('banner')->from('pages')->where('alias', $alias);
}
$this->data_header['banner'] = $this->db->get()->row()->banner;
if ($type_view == '1') {
//get SEO
$this->data_header['browser_title'] = 'Page - ' . ucwords($data['page']->page_title);
$this->data_header['meta_description'] = $data['page']->meta_description;
$this->data_header['meta_keywords'] = $data['page']->meta_keywords;
$this->load->view('template/header', $this->data_header);
$this->load->view('page', $data);
$this->load->view('template/footer', $this->data_footer);
}
else if ($type_view == '2') {
if($this->session->userdata('site_lang') == 'english') {
$this->db->select('id_pages')->from('pages')->where('alias_en', $alias);
$id_pages = $this->db->get()->row()->id_pages;
}
else{
$this->db->select('id_pages')->from('pages')->where('alias', $alias);
$id_pages = $this->db->get()->row()->id_pages;
}
// $this->db->select('image1, description, description_en, year(publish_date) as year_publish')->from('products')->where('page_id', $id_pages);
// $data['products'] = $this->db->get()->result();
$this->load->library('pagination');
$config = array();
$this->load->helper('pagination_helper');
$config = pagination_format();
$config['base_url'] = base_url() . 'page/' . $alias . '/' ;
$config['total_rows'] = $this->db->select('*')->from('products')->where('page_id', $id_pages)->where('product_status',1)->get()->num_rows();
$config['per_page'] = 9;
$config['uri_segment'] = 3;
$this->pagination->initialize($config);
$this->db->select('image1, description, description_en, year(publish_date) as year_publish')->order_by('publish_date','desc')->from('products')->where('page_id', $id_pages)->where('product_status',1)->limit($config['per_page'], $this->uri->segment($config['uri_segment']));
$data['products'] = $this->db->get()->result();
//get SEO
$this->data_header['browser_title'] = 'Page - ' . ucwords($data['page']->page_title);
$this->data_header['meta_description'] = $data['page']->meta_description;
$this->data_header['meta_keywords'] = $data['page']->meta_keywords;
$this->load->view('template/header', $this->data_header);
$this->load->view('page2', $data);
$this->load->view('template/footer', $this->data_footer);
}
else if ($type_view == '3') {
if($this->session->userdata('site_lang') == 'english') {
$this->db->select('id_pages')->from('pages')->where('alias_en', $alias);
$id_pages = $this->db->get()->row()->id_pages;
}
else{
$this->db->select('id_pages')->from('pages')->where('alias', $alias);
$id_pages = $this->db->get()->row()->id_pages;
}
$this->load->library('pagination');
$config = array();
$this->load->helper('pagination_helper');
$config = pagination_format();
$config['base_url'] = base_url() . 'page/' . $alias . '/' ;
$config['total_rows'] = $this->db->where('blog_type','news')->get('blog')->num_rows();
$config['per_page'] = 9;
$config['uri_segment'] = 3;
$this->pagination->initialize($config);
$this->db->where('blog_type','news')->order_by('publish_date','desc')->limit($config['per_page'], $this->uri->segment($config['uri_segment']));
$data['blogs'] = $this->db->get('blog')->result();
//get SEO
$this->data_header['browser_title'] = 'Page - ' . ucwords($data['page']->page_title);
$this->data_header['meta_description'] = $data['page']->meta_description;
$this->data_header['meta_keywords'] = $data['page']->meta_keywords;
$this->load->view('template/header', $this->data_header);
$this->load->view('page3', $data);
$this->load->view('template/footer', $this->data_footer);
}
else if ($type_view == '4') {
// $this->db->get('blog');
$data['blogs'] = $this->db->limit(4)->where('blog_type','news')->get('blog')->result();
//get SEO
$this->data_header['browser_title'] = 'Page - ' . ucwords($data['page']->page_title);
$this->data_header['meta_description'] = $data['page']->meta_description;
$this->data_header['meta_keywords'] = $data['page']->meta_keywords;
$this->load->view('template/header', $this->data_header);
$this->load->view('page4', $data);
$this->load->view('template/footer', $this->data_footer);
}
else if ($type_view == '5') {
if($this->session->userdata('site_lang') == 'english') {
$this->db->select('id_pages')->from('pages')->where('alias_en', $alias);
$id_pages = $this->db->get()->row()->id_pages;
}
else{
$this->db->select('id_pages')->from('pages')->where('alias', $alias);
$id_pages = $this->db->get()->row()->id_pages;
}
$this->db->select('category, category_en, id_categories')->from('categories')
->join('products', 'products.categories_id = categories.id_categories')
->group_by('category')
->order_by('categories.priority','asc')
->where('page_id',$id_pages);
$data['categories'] = $this->db->get()->result();
$data['id_pages'] = $id_pages;
//get SEO
$this->data_header['browser_title'] = 'Page - ' . ucwords($data['page']->page_title);
$this->data_header['meta_description'] = $data['page']->meta_description;
$this->data_header['meta_keywords'] = $data['page']->meta_keywords;
$this->load->view('template/header', $this->data_header);
$this->load->view('page5', $data);
$this->load->view('template/footer', $this->data_footer);
}
else if ($type_view == '6') {
if($this->session->userdata('site_lang') == 'english') {
$this->db->select('id_pages')->from('pages')->where('alias_en', $alias);
$id_pages = $this->db->get()->row()->id_pages;
}
else{
$this->db->select('id_pages')->from('pages')->where('alias', $alias);
$id_pages = $this->db->get()->row()->id_pages;
}
$this->db->select('title, image1, description, description_en')->from('products')->where('page_id', $id_pages)->order_by('priority','asc');
$data['products'] = $this->db->get()->result();
//get SEO
$this->data_header['browser_title'] = 'Page - ' . ucwords($data['page']->page_title);
$this->data_header['meta_description'] = $data['page']->meta_description;
$this->data_header['meta_keywords'] = $data['page']->meta_keywords;
$this->load->view('template/header', $this->data_header);
$this->load->view('page6', $data);
$this->load->view('template/footer', $this->data_footer);
}
else if ($type_view == '7') {
if($this->session->userdata('site_lang') == 'english') {
$this->db->select('id_pages')->from('pages')->where('alias_en', $alias);
$id_pages = $this->db->get()->row()->id_pages;
}
else{
$this->db->select('id_pages')->from('pages')->where('alias', $alias);
$id_pages = $this->db->get()->row()->id_pages;
}
$this->load->library('pagination');
$config = array();
$this->load->helper('pagination_helper');
$config = pagination_format();
$config['base_url'] = base_url() . 'page/' . $alias . '/' ;
$config['total_rows'] = $this->db->where('blog_type','csr')->get('blog')->num_rows();
$config['per_page'] = 9;
$config['uri_segment'] = 3;
$this->pagination->initialize($config);
$this->db->where('blog_type','csr')->order_by('publish_date','desc')->limit($config['per_page'], $this->uri->segment($config['uri_segment']));
$data['blogs'] = $this->db->get('blog')->result();
// $this->db->select('category, category_en')->from('categories')
// ->join('products', 'products.categories_id = categories.id_categories')
// ->group_by('category')
// ->order_by('categories.priority','asc')
// ->where('page_id',$id_pages);
// $data['categories'] = $this->db->get()->result();
// $this->db->select('products.description, products.description_en, products.image1, categories.category, categories.category_en')->from('categories')
// ->join('products', 'products.categories_id = categories.id_categories')
// ->where('page_id',$id_pages);
// $data['products'] = $this->db->get()->result();
//get SEO
$this->data_header['browser_title'] = 'Page - ' . ucwords($data['page']->page_title);
$this->data_header['meta_description'] = $data['page']->meta_description;
$this->data_header['meta_keywords'] = $data['page']->meta_keywords;
$this->load->view('template/header', $this->data_header);
$this->load->view('page7', $data);
$this->load->view('template/footer', $this->data_footer);
}
else if ($type_view == '8') {
if($this->session->userdata('site_lang') == 'english') {
$this->db->select('id_pages')->from('pages')->where('alias_en', $alias);
$id_pages = $this->db->get()->row()->id_pages;
}
else{
$this->db->select('id_pages')->from('pages')->where('alias', $alias);
$id_pages = $this->db->get()->row()->id_pages;
}
$this->db->select('title, image1, description, description_en')->from('products')->where('page_id', $id_pages)->order_by('priority','asc');
$data['products'] = $this->db->get()->result();
$this->db->select('banner1_image, banner7_text, banner7_text_en')->from('home_centerbanners');
$data['banners'] = $this->db->get()->row();
//get SEO
$this->data_header['browser_title'] = 'Page - ' . ucwords($data['page']->page_title);
$this->data_header['meta_description'] = $data['page']->meta_description;
$this->data_header['meta_keywords'] = $data['page']->meta_keywords;
$this->load->view('template/header', $this->data_header);
$this->load->view('page8', $data);
$this->load->view('template/footer', $this->data_footer);
}
else if ($type_view == '9') {
if($this->session->userdata('site_lang') == 'english') {
$this->db->select('id_pages')->from('pages')->where('alias_en', $alias);
$id_pages = $this->db->get()->row()->id_pages;
}
else{
$this->db->select('id_pages')->from('pages')->where('alias', $alias);
$id_pages = $this->db->get()->row()->id_pages;
}
$this->db->select('category, category_en, id_categories')->from('categories')
->join('products', 'products.categories_id = categories.id_categories')
->group_by('category')
->order_by('categories.priority','asc')
->where('page_id',$id_pages);
$data['categories'] = $this->db->get()->result();
$data['id_pages'] = $id_pages;
//get SEO
$this->data_header['browser_title'] = 'Page - ' . ucwords($data['page']->page_title);
$this->data_header['meta_description'] = $data['page']->meta_description;
$this->data_header['meta_keywords'] = $data['page']->meta_keywords;
$this->load->view('template/header', $this->data_header);
$this->load->view('page9', $data);
$this->load->view('template/footer', $this->data_footer);
}
}
}