|
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 : /proc/self/root/var/www/blue-sky.co.id/public_html/application/controllers/ |
Upload File : |
<?php defined('BASEPATH') or exit('No direct script access allowed');
class Hotel extends Public_Controller
{
public function __construct()
{
parent::__construct();
// $this->load->library('recaptcha');
$this->load->library('form_validation');
//MAIN MENUS
$alias = $this->uri->segment(2);
$hotel_id = null;
if ($alias == null)
{
show_404();
}
else
{
$quer_hotels = $this->db->get_where("hotels", array(
"alias" => $alias
));
if ($quer_hotels->num_rows() == 0)
{
show_404();
}
else
{
$hotel_id = $quer_hotels->row()->id;
$this->data_header['this_hotel'] = $quer_hotels->row();
}
}
if ($this->session->userdata('site_lang') == 'english') {
$this->db->select('alias_en as alias, menu_type, page_id, id_hotel_menus, menu_en as menu, menu_link_en as menu_link')->from('hotel_menus')->where('status', 1)->where('hotels_id', $hotel_id)->where('parent_id',null)->order_by('priority', 'ASC');
} else {
$this->db->select('alias as alias, menu_type, page_id, id_hotel_menus, menu, menu_link')->from('hotel_menus')->where('status', 1)->where('hotels_id', $hotel_id)->where('parent_id',null)->order_by('priority', 'ASC');
}
$this->data_header['main_hotel_menus'] = $this->db->get()->result();
//get configuration hotel
$this->data_header['config'] = $this->db->select('*')->from('hotel_configuration')->where('id_hotel_configuration', $hotel_id)->get()->row_array();
}
public function get($alias = null, $t_case = null, $pars1 = null)
{
$data = array();
if ($alias != null)
{
switch ($t_case)
{
case 'send_email':
$this->business_enquiry_confirmation($_POST);
return false;
break;
case 'rooms':
$this->hotel_rooms();
return false;
break;
case 'room':
$this->hotel_room_details($pars1);
return false;
break;
case 'events':
$this->hotel_events();
return false;
break;
case 'event':
$this->get_event($pars1);
return false;
break;
case 'offers':
$this->hotel_offers();
return false;
break;
default:
if ($t_case != null)
{
// redirect("/hotel/".$alias);
$this->hotel_page($pars1);
return false;
}
break;
}
}
if ($alias == null)
{
show_404();
}
else
{
$quer_hotels = $this->db->get_where("hotels", array(
"alias" => $alias
));
if ($quer_hotels->num_rows() == 0)
{
show_404();
}
else
{
$quer_hotels = $quer_hotels->row();
$data['hotel'] = $quer_hotels;
//get rooms name
$data['rooms'] = $this->db->select('room_name')->from('hotel_rooms')->where('hotel_id', $quer_hotels->id )->order_by('priority', 'ASC')->get()->result_array();
$id = $quer_hotels->id;
$quer_home_slideshow_hotel = $this->db->order_by('priority', 'ASC')->get_where("home_slideshow_hotel", array(
"hotel_id" => $id,
"status" => '1'
));
// $data['quer_home_slideshow_hotel'] = $this->db->select('*')->from('home_slideshow_hotel')->where('hotel_id', $id)->where('status', '1')->order_by('priority', 'ASC')->get->result();
$data['quer_home_slideshow_hotel'] = $quer_home_slideshow_hotel;
$quer_home_about_hotel = $this->db->get_where("home_about_hotel", array(
"hotel_id" => $id
));
$data['quer_home_about_hotel'] = $quer_home_about_hotel;
$quer_hotel_features = $this->db->get_where("hotel_features", array(
"hotel_id" => $id
));
$data['quer_hotel_features'] = $quer_hotel_features;
//get events
$data['events'] = $this->db->select('*')->from('hotel_events')->where('hotel_id', $id)->limit(3)->order_by('event_date', 'DESC')->get()->result_array();
//Get testimonials
$data['testimonies'] = $this->db->select('*')->from('hotel_testimonies')->where('hotel_id', $id)->where('status', 1)->order_by('priority', 'ASC')->get()->result_array();
//Get promotions
$data['promotions'] = $this->db->select('*')->from('hotel_promotions')->where('hotel_id', $id)->get()->result_array();
//Get faqs
$data['faq'] = $this->db->select('faq1_q,faq2_q,faq3_q,faq4_q,faq5_q,faq6_q,faq1_a,faq2_a,faq3_a,faq4_a,faq5_a,faq6_a')->from('home_centerbanners_hotel')->where('hotel_id', $id)->get()->row_array();
$centerbanners_hotel = $this->db->get_where("home_centerbanners_hotel", array(
"hotel_id" => $id
))->row();
$data['centerbanners_hotel'] = $centerbanners_hotel;
}
}
//get logo
if($alias)
{
$hotel = $this->db->select('id')->from('hotels')->where('alias', $alias)->get()->row_array();
if($hotel)
{
$this->data_header['config'] = $this->db->select('website_name, from_email, phone, browser_title, meta_description, logo, alamat, facebook, twitter, instagram, youtube')->from('hotel_configuration')->where('id_hotel_configuration', $hotel['id'])->get()->row_array();
}
}
$this->load->view("themes/$this->theme_no/hotel/header_hotel", $this->data_header);
$this->load->view("themes/$this->theme_no/hotel/welcome_hotel", $data);
$this->load->view("themes/$this->theme_no/hotel/footer_hotel", $this->data_footer);
}
public function business_enquiry_confirmation($t_post)
{
$alias = $this->uri->segment(2);
if (!isset($t_post['business_enquiry_confirmation'])) {
redirect('hotel/' . $alias . '/page/contact-us');
}
$inp_name = $t_post['inp_name'];
$inp_email = $t_post['inp_email'];
$inp_phone = $t_post['inp_phone'];
$inp_subject = $t_post['subject'];
$inp_message = $t_post['message'];
//validation in action
$config = array(
array(
'field' => 'inp_name',
'label' => 'Name',
'rules' => 'trim|required'
),
array(
'field' => 'inp_email',
'label' => 'Email Address',
'rules' => 'trim|required'
),
array(
'field' => 'inp_phone',
'label' => 'Phone Number',
'rules' => 'trim|required'
),
array(
'field' => 'message',
'label' => 'Message Details',
'rules' => 'trim|required'
),
array(
'field' => 'subject',
'label' => 'Subject',
'rules' => 'trim|required'
),
);
$this->form_validation->set_rules($config);
$this->form_validation->set_error_delimiters('<div class="error">', '</div>');
if ($this->form_validation->run($this) == FALSE) {
$data_header['page_title'] = 'Contact Us';
$this->db->select('website_name')->from('configuration')->where('id_configuration', 1);
$website_name = $this->db->get()->row();
$this->data_header['browser_title'] = ucwords($website_name->website_name) . ' - My Account';
$this->data_header['meta_description'] = ucwords($website_name->website_name) . ' - My Account';
//LOAD LANGUAGE FILES
// if($this->session->userdata('site_lang') == 'english') {
// $this->lang->load('contact', 'english');
// } else {
// $this->lang->load('contact', 'indonesian');
// }
$this->load->view("themes/$this->theme_no/header", $this->data_header);
$this->load->view("themes/$this->theme_no/contact");
$this->load->view("themes/$this->theme_no/footer", $this->data_footer);
} else {
//get website data
$this->db->select('logo, from_email, website_name, email_smtp_host, email_smtp_port, email_smtp_password, email_smtp')->from('configuration')->where('id_configuration', 1);
$website_data = $this->db->get()->row();
$data['logo'] = $website_data->logo;
$data['website_name'] = $website_data->website_name;
$this->load->model('configuration_m');
$data['emails'] = $this->configuration_m->get_emails();
$data['bank'] = $this->configuration_m->get_bank();
$data['title'] = 'Contact Us';
$myMessage = '<html><body>';
$myMessage .= '<table style="border-color: #666;" cellpadding="10">';
$myMessage .= "<tr><td><strong>Name:</strong> </td><td>" . $inp_name . "</td></tr>";
$myMessage .= "<tr><td><strong>Email Address:</strong> </td><td>" . $inp_email . "</td></tr>";
$myMessage .= "<tr><td><strong>Phone Number:</strong> </td><td>" . $inp_phone
. "</td></tr>";
$myMessage .= "<tr><td><strong>Details:</strong> </td><td>" . $inp_message . "</td></tr>";
$myMessage .= "</table>";
$myMessage .= "<p>Thanks.</p>";
$myMessage .= "</body></html>";
// send email
// $email_data['email'] = $data['emails']->from_email;
$email_data['email'] = trim($this->input->post('inp_send_email'));
// $email_data['email'] = 'bakrisea@gmail.com';
$email_data['subject'] = $inp_subject;
$this->send_email($myMessage, $email_data, true);
// var_dump($this->email->print_debugger()); exit();
// end email
$this->session->set_flashdata('success', '<br><p style="background:green; color:white; padding:10px; padding:5px; font-weight:bold;">Email ' . strtoupper($inp_subject) . ' BERHASIL TERKIRIM.</p>');
redirect('hotel/' . $alias . '/page/contact-us');
}
}
private function hotel_rooms($pars1 = null)
{
$data = array();
$alias = $this->uri->segment(2);
if ($alias == null)
{
show_404();
}
else
{
$quer_hotels = $this->db->get_where("hotels", array(
"alias" => $alias
));
if ($quer_hotels->num_rows() == 0)
{
show_404();
}
else
{
$hotel_id = $quer_hotels->row()->id;
$data['rooms'] = $this->db->select("id, room_name, room_image, introduction")->from("hotel_rooms")->where("hotel_id", $hotel_id)->order_by('priority', 'ASC')->get()->result_array();
$data['this_hotel'] = $alias;
$data['landing'] = $this->db->select('*')->from('room_landing')->where('hotel_id', $hotel_id)->get()->row_array();
$this->data_header['config'] = $this->db->select('website_name, from_email, phone, browser_title, meta_description, logo, alamat, facebook, twitter, instagram, youtube')->from('hotel_configuration')->where('id_hotel_configuration', $hotel_id)->get()->row_array();
}
}
$this->load->view("themes/$this->theme_no/hotel/header_hotel", $this->data_header);
$this->load->view("themes/$this->theme_no/hotel/rooms", $data);
$this->load->view("themes/$this->theme_no/hotel/footer_hotel", $this->data_footer);
}
private function hotel_room_details($pars1 = null)
{
$data = array();
$alias = $this->uri->segment(2);
if ($alias == null || $pars1 == null)
{
show_404();
}
else
{
$quer_hotels = $this->db->get_where("hotels", array(
"alias" => $alias
));
if ($quer_hotels->num_rows() == 0)
{
show_404();
}
else
{
$hotel_id = $quer_hotels->row()->id;
$quer_rooms = $this->db->select("h.*")->from("hotel_rooms h")->where("h.hotel_id", $hotel_id)->where("id", $pars1)->get();
if ($quer_rooms->num_rows() == 0)
{
show_404();
}
else
{
$data['room'] = $quer_rooms->row_array();
$data['this_hotel'] = $alias;
// Get gallery images for this room
$this->db->select('*');
$this->db->from('hotel_rooms_gallery');
$this->db->where('room_id', $pars1);
$this->db->where('is_active', 'yes');
$this->db->order_by('priority', 'ASC');
$data['gallery_images'] = $this->db->get()->result();
$this->data_header['config'] = $this->db->select('website_name, from_email, phone, browser_title, meta_description, logo, alamat, facebook, twitter, instagram, youtube')->from('hotel_configuration')->where('id_hotel_configuration', $hotel_id)->get()->row_array();
}
}
}
$this->load->view("themes/$this->theme_no/hotel/header_hotel", $this->data_header);
$this->load->view("themes/$this->theme_no/hotel/room_details", $data);
$this->load->view("themes/$this->theme_no/hotel/footer_hotel", $this->data_footer);
}
private function hotel_offers($pars1 = null)
{
$data = array();
$alias = $this->uri->segment(2);
if ($alias == null) {
show_404();
} else {
$quer_hotels = $this->db->get_where("hotels", array(
"alias" => $alias
));
if ($quer_hotels->num_rows() == 0) {
show_404();
} else {
$hotel_id = $quer_hotels->row()->id;
$query_hotel_promotions = $this->db->select('*')->from('hotel_promotions')->where('hotel_id', $hotel_id)->where('type_offer', 'current')->where('type', 'specialoffers')->order_by('id', 'ASC')->get()->result();
$data['hotel_promotions'] = $query_hotel_promotions;
$query_hotel_promotions_past = $this->db->select('*')->from('hotel_promotions')->where('hotel_id', $hotel_id)->where('type_offer', 'past')->where('type', 'specialoffers')->order_by('id', 'ASC')->get()->result();
$data['hotel_promotions_past'] = $query_hotel_promotions_past;
}
}
$this->load->view("themes/$this->theme_no/hotel/header_hotel", $this->data_header);
$this->load->view("themes/$this->theme_no/hotel/offers", $data);
$this->load->view("themes/$this->theme_no/hotel/footer_hotel", $this->data_footer);
}
private function hotel_page($pars1 = null)
{
$data = array();
$alias = $this->uri->segment(2);
if ($alias == null) {
show_404();
} else {
$quer_hotels = $this->db->get_where("hotels", array(
"alias" => $alias
));
if ($quer_hotels->num_rows() == 0) {
show_404();
} else {
$pars1 = strtolower($pars1);
$hotel_id = $quer_hotels->row()->id;
$this->db->select('*')->from('hotel_pages')->where('hotel_id', $hotel_id);
if ($this->session->userdata('site_lang') == 'english') {
$this->db->where('alias_en', $pars1);
} else {
$this->db->where('alias', $pars1);
}
$query_hotel_pages = $this->db->order_by('priority', 'ASC')->get();
if ($query_hotel_pages->num_rows() == 0) {
show_404();
return false;
}
$query_hotel_pages = $query_hotel_pages->row();
$data['hotel_pages'] = $query_hotel_pages;
$query_hotel_pages_gallery = $this->db->get_where("hotel_pages_gallery", array(
"hotel_id" => $hotel_id,
"id_pages" => $query_hotel_pages->id_hotel_pages,
"is_active" => "yes",
));
$data['query_hotel_pages_gallery'] = $query_hotel_pages_gallery;
// echo "<pre>";
// var_dump($query_hotel_pages_gallery->result()); exit();
$data["active_content"] = $query_hotel_pages->active_content;
$data["active_contact"] = $query_hotel_pages->active_contact;
if ($data["active_contact"] == 'yes') {
if ($this->session->userdata('site_lang') == 'english') {
$this->lang->load('homepage', 'english');
$this->lang->load('contact', 'english');
} else {
$this->lang->load('homepage', 'indonesian');
$this->lang->load('contact', 'indonesian');
}
$this->load->library('recaptcha');
$data['recaptcha_html'] = $this->recaptcha->render();
}
$data["active_map"] = $query_hotel_pages->active_map;
$data["active_gallery"] = $query_hotel_pages->active_gallery;
$data["active_all_product"] = $query_hotel_pages->active_all_product;
$data["active_banner_slider"] = $query_hotel_pages->active_banner_slider;
$data["active_center_img"] = $query_hotel_pages->active_center_img;
$data["active_3_contents_texts"] = $query_hotel_pages->active_3_contents_texts;
$this->db->select('*')->from('hotel_configuration')->where('id_hotel_configuration', $hotel_id);
$data["maps"] = $this->db->get()->row();
}
}
$this->load->view("themes/$this->theme_no/hotel/header_hotel", $this->data_header);
$this->load->view("themes/$this->theme_no/hotel/page", $data);
$this->load->view("themes/$this->theme_no/hotel/footer_hotel", $this->data_footer);
}
private function hotel_events($pars1 = null)
{
$data = array();
$alias = $this->uri->segment(2);
if ($alias == null)
{
show_404();
}
else
{
$quer_hotels = $this->db->get_where("hotels", array(
"alias" => $alias
));
if ($quer_hotels->num_rows() == 0)
{
show_404();
}
else
{
$hotel_id = $quer_hotels->row()->id;
$data['events'] = $this->db->select("*")->from("hotel_events")->where("hotel_id", $hotel_id)->order_by('event_date', 'DESC')->get()->result_array();
$data['this_hotel'] = $alias;
$this->data_header['config'] = $this->db->select('website_name, from_email, phone, browser_title, meta_description, logo, alamat, facebook, twitter, instagram, youtube')->from('hotel_configuration')->where('id_hotel_configuration', $hotel_id)->get()->row_array();
}
}
$this->load->view("themes/$this->theme_no/hotel/header_hotel", $this->data_header);
$this->load->view("themes/$this->theme_no/hotel/events", $data);
$this->load->view("themes/$this->theme_no/hotel/footer_hotel", $this->data_footer);
}
private function get_event($pars1 = null)
{
$alias = $this->uri->segment(2);
if ($alias != null && $alias != '')
{
$quer_hotels = $this->db->get_where("hotels", array(
"alias" => $alias
));
if ($quer_hotels->num_rows() == 0)
{
show_404();
}
else
{
$quer_hotels = $quer_hotels->row_array();
$this->data['event'] = $this->db->select('*')->from('hotel_events')->where('slug', $pars1)->where('hotel_id', $quer_hotels['id'])->get()->row_array();
if(!$this->data['event'])
{
show_404();
}
$this->data_header['config'] = $this->db->select('website_name, from_email, phone, browser_title, meta_description, logo, alamat, facebook, twitter, instagram, youtube')->from('hotel_configuration')->where('id_hotel_configuration', $quer_hotels['id'])->get()->row_array();
}
}
$this->load->view("themes/$this->theme_no/hotel/header_hotel", $this->data_header);
$this->load->view("themes/$this->theme_no/hotel/event", $this->data);
$this->load->view("themes/$this->theme_no/hotel/footer_hotel", $this->data_footer);
}
public function dining($hotel_slug = null)
{
$data = array();
//get hotel data
$data['hotel'] = $this->db->select('*')->from('hotels')->where('alias', $hotel_slug)->get()->row_array();
$data['facility'] = $this->db->select('*')->from('facilities')->where('type', 'dining')->where('hotel_id', $data['hotel']['id'])->get()->row_array();
if(!$data['facility'])
{
redirect(base_url());
}
$this->data_header['config'] = $this->db->select('website_name, from_email, phone, browser_title, meta_description, logo, alamat, facebook, twitter, instagram, youtube')->from('hotel_configuration')->where('id_hotel_configuration', $data['hotel']['id'])->get()->row_array();
$this->load->view("themes/$this->theme_no/hotel/header_hotel", $this->data_header);
$this->load->view("themes/$this->theme_no/hotel/hotel_facility", $data);
$this->load->view("themes/$this->theme_no/hotel/footer_hotel", $this->data_footer);
}
public function fitness_spa($hotel_slug = null)
{
$data = array();
//get hotel data
$data['hotel'] = $this->db->select('*')->from('hotels')->where('alias', $hotel_slug)->get()->row_array();
$data['facility'] = $this->db->select('*')->from('facilities')->where('type', 'fitness')->where('hotel_id', $data['hotel']['id'])->get()->row_array();
if(!$data['facility'])
{
redirect(base_url());
}
$this->data_header['config'] = $this->db->select('website_name, from_email, phone, browser_title, meta_description, logo, alamat, facebook, twitter, instagram, youtube')->from('hotel_configuration')->where('id_hotel_configuration', $data['hotel']['id'])->get()->row_array();
$this->load->view("themes/$this->theme_no/hotel/header_hotel", $this->data_header);
$this->load->view("themes/$this->theme_no/hotel/hotel_facility", $data);
$this->load->view("themes/$this->theme_no/hotel/footer_hotel", $this->data_footer);
}
public function meeting($hotel_slug = null)
{
$data = array();
//get hotel data
$data['hotel'] = $this->db->select('*')->from('hotels')->where('alias', $hotel_slug)->get()->row_array();
$data['facility'] = $this->db->select('*')->from('facilities')->where('type', 'meeting')->where('hotel_id', $data['hotel']['id'])->get()->row_array();
if(!$data['facility'])
{
redirect(base_url());
}
$this->data_header['config'] = $this->db->select('website_name, from_email, phone, browser_title, meta_description, logo, alamat, facebook, twitter, instagram, youtube')->from('hotel_configuration')->where('id_hotel_configuration', $data['hotel']['id'])->get()->row_array();
$this->load->view("themes/$this->theme_no/hotel/header_hotel", $this->data_header);
$this->load->view("themes/$this->theme_no/hotel/hotel_facility", $data);
$this->load->view("themes/$this->theme_no/hotel/footer_hotel", $this->data_footer);
}
public function wedding($hotel_slug = null)
{
$data = array();
//get hotel data
$data['hotel'] = $this->db->select('*')->from('hotels')->where('alias', $hotel_slug)->get()->row_array();
$data['facility'] = $this->db->select('*')->from('facilities')->where('type', 'wedding')->where('hotel_id', $data['hotel']['id'])->get()->row_array();
if(!$data['facility'])
{
redirect(base_url());
}
$this->data_header['config'] = $this->db->select('website_name, from_email, phone, browser_title, meta_description, logo, alamat, facebook, twitter, instagram, youtube')->from('hotel_configuration')->where('id_hotel_configuration', $data['hotel']['id'])->get()->row_array();
$this->load->view("themes/$this->theme_no/hotel/header_hotel", $this->data_header);
$this->load->view("themes/$this->theme_no/hotel/hotel_facility", $data);
$this->load->view("themes/$this->theme_no/hotel/footer_hotel", $this->data_footer);
}
}