| Server IP : 162.214.74.102 / Your IP : 216.73.216.36 Web Server : Apache System : Linux dedi-4363141.lrsys.com.br 3.10.0-1160.119.1.el7.tuxcare.els25.x86_64 #1 SMP Wed Oct 1 17:37:27 UTC 2025 x86_64 User : lrsys ( 1015) PHP Version : 5.6.40 Disable Function : exec,passthru,shell_exec,system MySQL : ON | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : ON Directory : /home/lrsys/public_html/lrsys_projetos/sopizzas/application/controllers/ |
Upload File : |
<?php if ( ! defined('BASEPATH')) exit('No direct script access allowed');
session_start(); //we need to call PHP's session object to access it through CI
class Restaurantviewpage extends CI_Controller {
function __construct()
{
parent::__construct();
$this->load->helper("url");
$this->load->helper('form');
$this->load->library('session');
$this->load->library('cart');
$session_data = $this->session->userdata('logged_in');
$this->load->model('frontend_model');
$this->load->model('dashboard_model');
$this->load->model('createorder_model');
$this->load->library('googlemaps');
$this->load->library('myemail');
if($this->session->userdata('user_language'))
{
$language = $this->session->userdata('user_language');
}
else
{
$language = $this->config->item("language");
}
$data['user_language'] = $language;
$this->lang->load('frontpage', $language);
}
//if(empty($session_data)) { redirect('login', 'refresh'); }
function index( $restaurant_seourl = '' )
{
/*echo "<pre>";
print_r ($this->cart->contents());
echo "</pre>";
exit();*/
//print_r($this->input->server('REQUEST_METHOD'));exit;
$restaurant_seourl = 's-pizzas-171';
if ($restaurant_seourl != '') {
$this->db->select('restaurant_id, business_type');
$this->db->from('rt_restaurant');
$this->db->where('restaurant_seourl', $restaurant_seourl);
$myQuery = $this->db->get();
if ($myQuery->num_rows() > 0) {
$myData = $myQuery->row();
$restaurant_id = $myData->restaurant_id;
$myArray = array(
'id' => $restaurant_id,
'is_resttablebookingaurant' => $myData->business_type
);
if ($this->session->userdata('order_restaurant_id')) {
$oldData = $this->session->userdata('order_restaurant_id');
if ($oldData['id'] != $restaurant_id) {
if ($this->cart->contents()) {
$this->cart->destroy();
}
}
}
$this->session->set_userdata('order_restaurant_id', $myArray);
}
else {
if($this->input->server('REQUEST_METHOD') != "POST") {
redirect(base_url());
}else{
$restaurant_id = $this->input->post("favorite_restaurant");
}
}
}
else {
redirect(base_url());
}
$dataHead['res_details'] = $this->frontend_model->restaurantDetails($restaurant_id);
if(isset($dataHead['res_details']['restaurant_logo']) && $dataHead['res_details']['restaurant_logo']!=''){
$image_file_path=FCPATH.RESTAURAT_LOGO_PATH_THUMBS.$dataHead['res_details']['restaurant_logo'];
if (file_exists($image_file_path)) //file_exists of a url returns false.It should be real file path
{
$image_name_with_path=base_url().RESTAURAT_LOGO_PATH_THUMBS.$dataHead['res_details']['restaurant_logo'];
}
else
{
$image_name_with_path=base_url().RESTAURAT_LOGO_PATH_THUMBS.RESTAURAT_DEFAULT_IMAGE;
}
}else{
$image_name_with_path=base_url().RESTAURAT_LOGO_PATH_THUMBS.RESTAURAT_DEFAULT_IMAGE;
}
// $config['image_library'] = 'gd2';
// $config['source_image'] = $image_file_path;
// $config['create_thumb'] = TRUE;
// $config['maintain_ratio'] = TRUE;
// $config['width'] = 200;
// $config['height'] = 200;
//
// $this->image_lib->clear();
// $this->image_lib->initialize($config);
// $this->image_lib->resize();
$dataHead['avgRating'] = $this->frontend_model->avgRestaurantrating($restaurant_id);
$dataHead['RestaurantReviewList'] = $this->frontend_model->RestaurantReviewList($restaurant_id);
$dataHead['keywords'] = isset($dataHead['res_details']['seo_meta_keyword']) ? $dataHead['res_details']['seo_meta_keyword'] : '';
$dataHead['description'] = isset($dataHead['res_details']['seo_meta_description']) ? $dataHead['res_details']['seo_meta_description'] : '';
$dataHead['language'] = isset($dataHead['res_details']['seo_meta_language']) ? $dataHead['res_details']['seo_meta_language'] : '';
//$data['$placeName'] = isset($data['seo_state']) ? $data['seo_city'] : '';
if (isset($dataHead['res_details']['seo_city']) && $dataHead['res_details']['seo_city'] != '') {
$dataHead['placeName'] = $dataHead['res_details']['seo_city'];
}
if (isset($dataHead['placeName']) && $dataHead['placeName'] != '' && $dataHead['res_details']['seo_state'] != '') {
$dataHead['placeName'] .= ', '.$dataHead['res_details']['seo_state'];
}
$dataHead['country'] = isset($dataHead['res_details']['seo_country']) ? $dataHead['res_details']['seo_country'] : '';
//YOUR_API_KEY : AIzaSyCEREW-HY406nyTD4X-gy4sLV2U6brtwSA
$streetAddress = $dataHead['res_details']['restaurant_streetaddress'];
if ($streetAddress != '' && $dataHead['res_details']['restaurant_state']) {
$streetAddress .= ', '.$dataHead['res_details']['restaurant_state'];
}
if ($streetAddress != '' && $dataHead['res_details']['restaurant_city']) {
$streetAddress .= ', '.$dataHead['res_details']['restaurant_city'];
}
if ($streetAddress != '' && $dataHead['res_details']['restaurant_zip']) {
$streetAddress .= ', '.$dataHead['res_details']['restaurant_zip'];
}
$geo = file_get_contents('http://maps.googleapis.com/maps/api/geocode/json?address='.urlencode($streetAddress).'&sensor=false');
// We convert the JSON to an array
$geo = json_decode($geo, true);
// If everything is cool
if ($geo['status'] = 'OK') {
// We set our values
$lat = isset($geo['results'][0]['geometry']['location']['lat'])? $geo['results'][0]['geometry']['location']['lat']: "32.926395" ;
$lng = isset($geo['results'][0]['geometry']['location']['lng'])? $geo['results'][0]['geometry']['location']['lng'] : "-117.207948";
}
else {
$lat = $dataHead['res_details']['latitude'];
$lng = $dataHead['res_details']['longitude'];
}
// $lat = $data['res_details']['latitude'];
// $lng = $data['res_details']['longitude'];
$this->googlemaps->initialize();
$marker = array();
$marker['position'] = $lat.','.$lng;
$marker['draggable'] = true;
$marker['ondragend'] = 'alert(\'You just dropped me at: \' + event.latLng.lat() + \', \' + event.latLng.lng());';
$this->googlemaps->add_marker($marker);
$config['center'] = $lat.','.$lng;
$config['zoom'] = '13';
//$config['drawing'] = true;
//$config['drawingDefaultMode'] = 'circle';
//$config['drawingModes'] = array('circle','rectangle','polygon');
$this->googlemaps->initialize($config);
$this->googlemaps->add_marker($marker);
$data['map'] = $this->googlemaps->create_map();
// Checking delivery zone start
if ($this->session->userdata('search_location')) {
$address = $this->session->userdata('search_location');
}
else {
$address = '';
}
$isDeliveryAvailable = false;
$deliveryZone = 0;
$deliveryCharge = 0;
$minOrderPrice = 0;
$delivery_details = $this->createorder_model->restaurantDeliveryDetails($restaurant_id);
// echo json_encode($delivery_details); exit();
if(isset($delivery_details->delivery_zone_1) && $this->mypolygon->checkPolygon($address, $delivery_details->delivery_zone_1, '')) {
$isDeliveryAvailable = true;
$deliveryZone = 1;
$deliveryCharge = $delivery_details->restaurant_delivery_charge;
$minOrderPrice = $delivery_details->restaurant_minorder_price;
}
else if(isset($delivery_details->delivery_zone_2) && $this->mypolygon->checkPolygon($address, $delivery_details->delivery_zone_2, '')) {
$isDeliveryAvailable = true;
$deliveryZone = 2;
$deliveryCharge = $delivery_details->restaurant_delivery_charge_2;
$minOrderPrice = $delivery_details->restaurant_minorder_price_2;
}
else if(isset($delivery_details->delivery_zone_3) && $this->mypolygon->checkPolygon($address, $delivery_details->delivery_zone_3, '')) {
$isDeliveryAvailable = true;
$deliveryZone = 3;
$deliveryCharge = $delivery_details->restaurant_delivery_charge_3;
$minOrderPrice = $delivery_details->restaurant_minorder_price_3;
}
$deliveryDetails['isDeliveryAvailable'] = $isDeliveryAvailable;
$deliveryDetails['deliveryZone'] = $deliveryZone;
$deliveryDetails['deliveryCharge'] = $deliveryCharge;
$deliveryDetails['minOrderPrice'] = $minOrderPrice;
if ($this->session->userdata('delivery_details')) {
$this->session->unset_userdata('delivery_details');
}
$this->session->set_userdata('delivery_details', $deliveryDetails);
// Checking delivery zone end
$data['servingcuisine']=$this->frontend_model->getArrayCuisinesInfo($dataHead['res_details']['restaurant_serving_cuisines']);
$data['categoryList']=$this->frontend_model->categoryList($restaurant_id);
$data['MenuList']=$this->MenuList($restaurant_id);
$data['admin_data'] =$this->dashboard_model->get_website_settings();
$data['DelliveryTimeList'] =$this->dashboard_model->DelliveryTimeList();
$data['Offers'] =$this->dashboard_model->GetOffers($restaurant_id);
$data['page'] = 'restaurantview';
if($this->session->userdata('user_language'))
{
$language = $this->session->userdata('user_language');
}
else
{
$language = $this->config->item("language");
}
$data['user_language'] = $language;
$data['restaurant_seourl'] = $restaurant_seourl;
if ($this->input->server('REQUEST_METHOD') == 'POST') {
$data['tabName'] = "bookTable";
$this->tablebooking();
}
else {
$data['tabName'] = "";
}
$this->lang->load('restaurantview', $language);
$this->load->view('frontend/header', $dataHead);
$this->load->view('frontend/restaurantview', $data);
$this->load->view('frontend/footer');
}
function MenuList($restaurant_id)
{
$this->db->select('*');
$this->db->from('rt_restaurant');
$this->db->where('restaurant_id', $restaurant_id);
$myQuery = $this->db->get();
$myData = $myQuery->row();
$current_time = date('H:i A');
$day = strtolower(date('D'));
$isopen=0;
$fild1 = 'restaurant_delivery_'.$day.'_opentime';
$fild2 = 'restaurant_delivery_'.$day.'_closetime';
$starttime1=$myData->$fild1;
$starttime3=date("H:i", strtotime($starttime1));
$closetime1=$myData->$fild2;
$closetime3=date("H:i", strtotime($closetime1));
if($current_time >= $starttime3 && $current_time <= $closetime3)
{
$isopen=1;
}
$DataTable ='';
$categoryList=$this->frontend_model->categoryList($restaurant_id);
if(is_array($categoryList) && sizeof($categoryList)>0)
{
foreach($categoryList as $key=>$row)
{
if ($row['maincatedesc'] != '') {
$maincatedesc = '<i class="fa fa-question-circle" data-toggle="tooltip" data-placement="right" title="'.$row['maincatedesc'].'"></i>';
}
else {
$maincatedesc = '';
}
$DataTable .= '<div class="menu__category" id="'.$row['maincateid'].'">
<div class="menu__category__header">
<h3 class="menu__category__title">'.$row['maincatename'].' '.$maincatedesc.'</h3>
</div>';
$MenuList=$this->frontend_model->MenuList($row['maincateid'],$restaurant_id);
if(is_array($MenuList) && sizeof($MenuList)>0)
{
foreach($MenuList as $key=>$row2)
{
if ($isopen == 1 && $myData->business_type == 0) {
$addIcon = '<span><img class="cos" onclick="ShowDetails('.$row2['id'].');" src="'.base_url().'assets/img/front-end/add.png"></span>';
}
else {
$addIcon = '';
}
$Isveg1="menu-item__dish-characteristic menu-item__dish-characteristic__vegetarian";
if($row2['menu_type']=='nonveg')
{
$Isveg1="menu-item__dish-characteristic_non menu-item__dish-characteristic__nonvegetarian";
}
if($row2['menu_photo']!=''){
$menu_photo_file_path=FCPATH.MENU_IMAGE_PATH_THUMBS.$row2['menu_photo'];
if (file_exists($menu_photo_file_path)) //file_exists of a url returns false.It should be real file path
{
$menu_image_name_with_path=base_url().MENU_IMAGE_PATH_THUMBS.$row2['menu_photo'];
}
else
{
$menu_image_name_with_path=base_url().MENU_IMAGE_PATH_THUMBS.MENU_IMAGE_DEFAULT_IMAGE;
}
}else{
$menu_image_name_with_path=base_url().MENU_IMAGE_PATH_THUMBS.MENU_IMAGE_DEFAULT_IMAGE;
}
if($row2['sizeoption']=='fixed'){
$menu_price=$row2['menu_price'];
}else{
$menu_price=$this->frontend_model->menu_slice_price($row2['id']);
}
$Imgtag='';
if($row2['menu_hot']=='medium')
{
$Imgtag= '<img src="'.base_url().'assets/img/front-end/mid-hot.png" class="img-chili">';
}
if($row2['menu_hot']=='fair')
{
$Imgtag= '<img src="'.base_url().'assets/img/front-end/fair-hot.png" class="img-chili">';
}
if($row2['menu_hot']=='very')
{
$Imgtag= '<img src="'.base_url().'assets/img/front-end/very-hot.png" class="img-chili">';
}
if($row2['menu_hot']=='extreme')
{
$Imgtag= '<img src="'.base_url().'assets/img/front-end/extremely-hot.png" class="img-chili">';
}
$Imgtagpopular='';
if($row2['menu_popular_dish']=='Yes')
{
$Imgtagpopular= '<img src="'.base_url().'assets/img/front-end/popular.png" class="img-chili">';
}
$menu_nut='';
if($row2['menu_nut']=='Yes')
{
$menu_nut= '<img src="'.base_url().'assets/img/front-end/nuts.png" class="img-chili">';
}
$menu_gluten='';
if($row2['menu_gluten']=='yes')
{
$menu_gluten= '<img src="'.base_url().'assets/img/front-end/gluten.png" class="img-chili">';
}
$DataTable .='<div class="menu-item-content col-md-12 col-sm-12 col-xs-12 custom-padding-0">
<div class="col-md-3 col-sm-3 col-xs-12 after_mid">
<img src="'.$menu_image_name_with_path.'" class="restroimg">
</div>
<div class="col-md-9 col-sm-9 col-xs-12 custom-padding-0 " >
<div class="col-md-9 col-sm-9 col-xs-12 paddleft">
<span class="'.$Isveg1.' data-toggle="tooltip" data-placement="bottom" title="Vegetarian">●</span> <h4>'.$row2['menu_name'].'</h4>'.$Imgtag.''.$Imgtagpopular.''.$menu_nut.''.$menu_gluten.' <div class="clearfix"></div>
<p>'.$row2['menu_description'].'</p>
</div>
<div class="col-xs-12 col-sm-3 col-md-3 paddleft text-center">
<span class="price-gap">'.SITENAME_CURRENCY.$menu_price.'</span>
'.$addIcon.'
</div>
</div>
</div>';
}
}
}
$DataTable .= '</div>';
}
if($DataTable!='')
{
return $DataTable;
}else
{
$DataTable = '<div class="menu__category" id=""><div class="menu-item-content col-md-12 col-sm-12 col-xs-12 custom-padding-0"></div></div>';
return $DataTable;
}
}
function showItemDetails()
{
$menu_id = $this->input->post('id');
$menudetails=$this->frontend_model->GetMenuDetails($menu_id);
if($menudetails['menu_photo']!=''){
$menu_photo_file_path=FCPATH.MENU_IMAGE_PATH_THUMBS.$menudetails['menu_photo'];
if (file_exists($menu_photo_file_path)) //file_exists of a url returns false.It should be real file path
{
$menu_image_name_with_path=base_url().MENU_IMAGE_PATH_THUMBS.$menudetails['menu_photo'];
}
else
{
$menu_image_name_with_path=base_url().MENU_IMAGE_PATH_THUMBS.MENU_IMAGE_DEFAULT_IMAGE;
}
}else{
$menu_image_name_with_path=base_url().MENU_IMAGE_PATH_THUMBS.MENU_IMAGE_DEFAULT_IMAGE;
}
$Fixprice='';
$dataSize='';
$dataSubAddons='';
$dataAddonsHeader='';
$spl_instruction ='';
$dataAddons ='';
if($menudetails['sizeoption']=='size')
{
$MenuSize=$this->frontend_model->GetMenuSize($menudetails['id']);
if(is_array($MenuSize) && sizeof($MenuSize)>0)
{
$dataSize='<span class="col-md-12 col-sm-12 col-xs-12 value-box">
<span class="col-md-3 col-sm-4 col-xs-12">
Price
</span><span class="col-md-9 col-sm-8 col-xs-12 paddingleft0">';
foreach($MenuSize as $key=>$row2)
{
$dataSize .='
<span class="col-md-6 col-sm-6 col-xs-12">
<input name="price" class="radio" type="radio"></input>
<label for="radio"><span><span></span></span>'.htmlentities($row2['menu_slice_name']).' - '.SITENAME_CURRENCY.$row2['menu_slice_price'].'</label>
</span>';
}
$dataSize .='</span></span>';
}
}else{
$Fixprice='<span class="col-md-12 col-sm-12 col-xs-12 value-box">
<span class="col-md-3 col-sm-4 col-xs-6">
Price
</span>
<span class="col-md-9 col-sm-8 col-xs-6">
'.SITENAME_CURRENCY.$menudetails['menu_price'].'
</span>
</span>';
}
if($menudetails['menu_addons']=='Yes')
{
$MenuAddonsHeader=$this->frontend_model->GetMenuAddonsHeader($menudetails['id']);
if(is_array($MenuAddonsHeader) && sizeof($MenuAddonsHeader)>0)
{
foreach($MenuAddonsHeader as $key=>$row3)
{
$dataSubAddons='';
$dataAddonsHeader ='<span class="col-md-12 col-sm-12 col-xs-12 value-box">
<span class="col-md-3 col-sm-4 col-xs-12">
'.$row3['menuaddons_addonsname'].'<br>(Choose up to '.$row3['menuaddons_addonscount'].')
</span>';
$MenuSubAddons=$this->frontend_model->GetMenuSubAddons($row3['menuaddons_id']);
if(is_array($MenuSubAddons) && sizeof($MenuSubAddons)>0)
{
$dataSubAddons ='<span class="col-md-9 col-sm-8 col-xs-12 paddingleft0">';
foreach($MenuSubAddons as $key=>$row4)
{
if($row4['menuaddons_price']!='0')
{
$addonsPrice=SITENAME_CURRENCY.$row4['menuaddons_price'];
}else
{
$addonsPrice='Free';
}
$dataSubAddons .='<span class="col-md-6 col-sm-6 col-xs-12">
<input onclick="addonLimit('.$row3['menuaddons_addonscount'].','.$row4['menuaddons_id'].','.$row3['menuaddons_id'].');" id="advacce_menu_'.$row4['menuaddons_id'].'" class="single-checkbox_'.$row3['menuaddons_id'].' checkbox" name="addons" type="checkbox"></input><label for="checkbox"><span></span>'.$row4['menuaddons_addonsname'].' ('.$addonsPrice.')</label>
</span>';
}
//$dataSubAddons .="</span>";
$dataAddons .=$dataAddonsHeader.$dataSubAddons.'</span></span>';
}
}
//$dataAddons =$dataAddonsHeader.$dataSubAddons;
}
}
if($menudetails['menu_spl_instruction']!='No'){
$spl_instruction = '<span class="col-md-12 col-sm-12 col-xs-12 value-box">
<span class="col-md-3 col-sm-4 col-xs-12">
Special Instructions
</span>
<span class="col-md-9 col-sm-8 col-xs-12">
<textarea class="areatext" style="" class="form-control" rows="5" id="comment"></textarea>
<p>Example: extra cheese, side of dressing, etc.<br>Additional charges may apply.</p>
</span>
</span>';
}
$dataPopup = '<div class="modal-dialog">
<!-- Modal content-->
<div class="modal-content">
<div class="modal-header">
<button type="button" class="close" data-dismiss="modal">×</button>
<h4 class="modal-title text-center">Add item to cart</h4>
</div>
<div class="modal-body">
<div class="col-md-12 col-sm-12 custom-padding-0">
<div class="col-md-8 col-sm-8">
<h3> '.$menudetails['menu_name'].'</h3>
<p style="font-size:15px;">'.$menudetails['menu_description'].'</p>
</div>
<div class="col-md-4 col-sm-4">
<img src="'.$menu_image_name_with_path.'" class="addcart-img">
</div>
</div>
<div class="col-md-12 custom-padding-0 price-body">
'.$Fixprice.'
'.$dataSize.'
'.$dataAddons.'
<span class="col-md-12 col-sm-12 col-xs-12 value-box">
<span class="col-md-3 col-sm-4 col-xs-6">
Quantity
</span>
<span class="col-md-9 col-sm-8 col-xs-6">
<select class="">
<option>1</option>
<option>2</option>
<option>3</option>
<option>4</option>
<option>5</option>
<option>6</option>
<option>7</option>
<option>8</option>
<option>9</option>
<option>10</option>
<option>11</option>
<option>12</option>
<option>13</option>
<option>14</option>
<option>15</option>
<option>16</option>
<option>17</option>
<option>18</option>
<option>19</option>
<option>20</option>
</select>
</span>
</span>
'.$spl_instruction.'
<div class="clearfix"></div>
<div class="col-md-12 text-center mctop20">
<button type="button" class="btn cos-mh-btn" style="float:none;display:none;">Add to Cart</button>
</div>
</div>
</div>
<div class="modal-footer">
<button type="button" class="btn btn-default" data-dismiss="modal">Close</button>
</div>
</div>
</div>';
echo $dataPopup;
}
function tablebooking(){
//print_r($this->input->post());exit;
//ALTER TABLE `rt_order_caterer` ADD `booking_meta` TEXT NULL DEFAULT NULL AFTER `assigned_caterer`;
$choose_party_type = $this->input->post('choose_party_type');
$choose_food = $this->input->post('choose_food');
$choose_delivery_method = $this->input->post('choose_delivery_method');
$favorite_restaurant = $this->input->post('favorite_restaurant');
$assigned_caterer = $this->input->post('favorite_restaurant');
$booking_number_of_attendees_over12 = $this->input->post('booking_number_of_attendees_over12');
$booking_number_of_attendees_under12 = $this->input->post('booking_number_of_attendees_under12');
$booking_date = $this->input->post('booking_date');
$booking_start_time = $this->input->post('booking_start_time');
$booking_end_time = $this->input->post('booking_end_time');
$booking_required_delivery_time = $this->input->post('booking_required_delivery_time');
$booking_required_pick_up_chosen = $this->input->post('booking_required_pick_up_chosen');
$booking_location_name_address = $this->input->post('booking_location_name_address');
$booking_party_theme = $this->input->post('booking_party_theme');
$booking_special_request = $this->input->post('booking_special_request');
// Private party
$booking_name = $this->input->post('booking_name');
$booking_website_address = $this->input->post('booking_website_address');
$booking_home_address = $this->input->post('booking_home_address');
$booking_telephone_number = $this->input->post('booking_telephone_number');
$booking_mobile_number = $this->input->post('booking_mobile_number');
$booking_email_address = $this->input->post('booking_email_address');
$booking_best_time = $this->input->post('booking_best_time');
$private_event_type = $this->input->post('private_event_type');
$private_event_type_other = $this->input->post('private_event_type_other');
$private_additional_service = $this->input->post('private_additional_service');
// Business party
$booking_title = $this->input->post('booking_title');
$booking_ordering_person = $this->input->post('booking_ordering_person');
$booking_company_name = $this->input->post('booking_company_name');
$booking_company_tax_id = $this->input->post('booking_company_tax_id');
$booking_company_address = $this->input->post('booking_company_address');
$booking_company_number = $this->input->post('booking_company_number');
$booking_company_owner_name = $this->input->post('booking_company_owner_name');
$booking_company_owner_number = $this->input->post('booking_company_owner_number');
$booking_company_website_address = $this->input->post('booking_company_website_address');
$booking_company_email_address = $this->input->post('booking_company_email_address');
$booking_number_ordering_person = $this->input->post('booking_number_ordering_person');
$booking_best_time_to_reach = $this->input->post('booking_best_time_to_reach');
$booking_email_address_ordering_person = $this->input->post('booking_email_address_ordering_person');
$business_event_type = $this->input->post('business_event_type');
$business_event_type_other = $this->input->post('business_event_type_other');
$business_additional_service = $this->input->post('business_additional_service');
// Request from app
$requestType = $this->input->post('book_from');
$restaurant_contact_email = '';
if ($favorite_restaurant != '') {
$this->db->select('restaurant_name, restaurant_contact_email');
$this->db->from('rt_restaurant');
$this->db->where('restaurant_id', $favorite_restaurant);
$query = $this->db->get();
$restDetails = $query->row_array();
$favorite_restaurant = $restDetails['restaurant_name'];
$restaurant_contact_email = $restDetails['restaurant_contact_email'];
}
$myData = array();
if ($booking_name !== '') {
$myData['Booking Restaurant Name'] = $favorite_restaurant;
}
if ($booking_name !== '') {
$myData['Booking Name'] = $booking_name;
}
if ($booking_home_address !== '') {
$myData['Home Address'] = $booking_home_address;
}
if ($booking_mobile_number !== '') {
$myData['Mobile No.'] = $booking_mobile_number;
}
if ($booking_email_address !== '') {
$myData['Email Address'] = $booking_email_address;
}
if ($booking_date !== '') {
$myData['Date'] = date('m/d/Y', strtotime($booking_date));
$myData['Date'] = $booking_date;
//$booking_date = date('m/d/Y', strtotime($booking_date));
}
if ($booking_best_time !== '') {
$myData['Time'] = date('h:i A', strtotime($booking_best_time));
$booking_best_time = date('h:i A', strtotime($booking_best_time));
}
if ($booking_number_of_attendees_over12 !== '') {
$myData['Number of guests (Over 12 Yr. Age)'] = $booking_number_of_attendees_over12;
}
if ($booking_number_of_attendees_under12 !== '') {
$myData['Number of guests (Under 12 Yr. Age)'] = $booking_number_of_attendees_under12;
}
if ($booking_special_request !== '') {
$myData['Special Request'] = $booking_special_request;
}
// Saving in database
$data_in['choose_party_type'] = $choose_party_type;
$data_in['choose_food'] = $choose_food;
$data_in['choose_delivery_method'] = $choose_delivery_method;
$data_in['favorite_restaurant'] = $favorite_restaurant;
$data_in['booking_number_of_attendees_over12'] = $booking_number_of_attendees_over12;
$data_in['booking_number_of_attendees_under12'] = $booking_number_of_attendees_under12;
$data_in['booking_date'] = $booking_date;
$data_in['booking_start_time'] = $booking_start_time;
$data_in['booking_end_time'] = $booking_end_time;
$data_in['booking_required_delivery_time'] = $booking_required_delivery_time;
$data_in['booking_required_pick_up_chosen'] = $booking_required_pick_up_chosen;
$data_in['booking_location_name_address'] = $booking_location_name_address;
$data_in['booking_party_theme'] = $booking_party_theme;
$data_in['booking_special_request'] = $booking_special_request;
$data_in['assigned_caterer'] = $assigned_caterer;
// Private Party
$data_in['booking_name'] = $booking_name;
$data_in['booking_website_address'] = $booking_website_address;
$data_in['booking_home_address'] = $booking_home_address;
$data_in['booking_telephone_number'] = $booking_telephone_number;
$data_in['booking_mobile_number'] = $booking_mobile_number;
$data_in['booking_email_address'] = $booking_email_address;
$data_in['booking_best_time'] = $booking_best_time;
$data_in['private_event_type'] = $private_event_type;
$data_in['private_event_type_other'] = $private_event_type_other;
$data_in['private_additional_service'] = $private_additional_service;
// Business Party
$data_in['booking_title'] = $booking_title;
$data_in['booking_ordering_person'] = $booking_ordering_person;
$data_in['booking_company_name'] = $booking_company_name;
$data_in['booking_company_tax_id'] = $booking_company_tax_id;
$data_in['booking_company_address'] = $booking_company_address;
$data_in['booking_company_number'] = $booking_company_number;
$data_in['booking_company_owner_name'] = $booking_company_owner_name;
$data_in['booking_company_owner_number'] = $booking_company_owner_number;
$data_in['booking_company_website_address'] = $booking_company_website_address;
$data_in['booking_company_email_address'] = $booking_company_email_address;
$data_in['booking_number_ordering_person'] = $booking_number_ordering_person;
$data_in['booking_best_time_to_reach'] = $booking_best_time_to_reach;
$data_in['booking_email_address_ordering_person'] = $booking_email_address_ordering_person;
$data_in['business_event_type'] = $business_event_type;
$data_in['business_event_type_other'] = $business_event_type_other;
$data_in['business_additional_service'] = $business_additional_service;
$data_in['booked_from'] = $requestType;
$data_in['booking_meta'] = !empty($myData) ? json_encode($myData) : "";
foreach ($data_in as $k=>$value)
{
$data_in[$k] = !empty($value) ? $value : "";
}
$this->db->trans_start();
$this->db->insert('rt_order_caterer', $data_in);
$this->db->trans_complete();
// Setting up mail
$booking_details = '';
foreach ($myData as $key => $value) {
$booking_details .= '<div style="font-family: arial, sans-serif;"><div style="width: 150px;float: left;">'.$key.'</div>: '.$value.'</div><div style="clear: both;"></div><br>';
}
$variables['sub_heading'] = 'New booking request has been placed. Please check.';
$variables['booking_details'] = $booking_details;
$image_path = base_url().'assets/';
$variables['image_path'] = $image_path;
$variables['site_address'] = SITE_ADDRESS;
$variables['sender_name'] = SITENAME;
$variables['site_name'] = SITENAME;
$template_name = 'bulk_parties_order';
$mail_data = $this->frontend_model->getEmailTemplate($template_name);
$mailcontent=htmlspecialchars_decode($mail_data->template);
$subject = $mail_data->subject;
$mailcontent_admin = $mailcontent;
foreach($variables as $key => $value) {
$mailcontent_admin = str_replace('{{'.$key.'}}', $value, $mailcontent_admin);
}
$this->send_my_mail(SITE_FEEDBACK_EMAIL, $subject, $mailcontent_admin);
if ($restaurant_contact_email != '' && $favorite_restaurant != '') {
$this->send_my_mail($restaurant_contact_email, $subject, $mailcontent_admin);
}
$variables['sub_heading'] = 'We have received your booking request. One of our executive will reach you soon. Plesae check your booking details below.';
$mailcontent_user = $mailcontent;
foreach($variables as $key => $value) {
$mailcontent_user = str_replace('{{'.$key.'}}', $value, $mailcontent_user);
}
$this->send_my_mail($booking_email_address, $subject, $mailcontent_user);
// {{booking_details}} = <div style="font-family: arial, sans-serif;"><div style="width: 77px;float: left;">Email</div>: {{email}}</div>;
$data['success'] = 0;
$data['msg'] = "Please try again.";
if($requestType != "application"){
$data['title'] = "Thank You";
$data['page'] = "bookorder";
$this->load->view('frontend/header',$data);
$this->load->view('frontend/thankyou');
$this->load->view('frontend/footer');
}else{
$data['success'] = 1;
$data['msg'] = "Booking done successfully";
echo json_encode($data);exit();
}
}
function send_my_mail($mail_To,$mail_subject,$mail_Body,$mail_CC="")
{
$mail_From = SITENAME;
$mail = new PHPMailer();
//Your SMTP servers details
$mail->IsSMTP(); // set mailer to use SMTP
$mail->Host = SMTP_HOST; // specify main and backup server or localhost
$mail->SMTPAuth = true; // turn on SMTP authentication
$mail->Username = SMTP_USER; // SMTP username
$mail->Password = SMTP_PASSWORD; // SMTP password It should be same as that of the SMTP user
//$mail->PluginDir = "/home/phpaucti/public_html/website_development/coding/includes/";
$mail->From = $mail->Username; //Default From email same as smtp user
$mail->FromName = $mail_From;
$emailArr = explode(',',$mail_To);
foreach($emailArr AS $emailVal) {
$mail->AddAddress($emailVal, ""); //Email address where you wish to receive/collect those emails.
}
/*$emailCCArr = explode(',',$mail_CC);
foreach($emailCCArr AS $emailCCVal) {
$mail->AddCC($emailCCVal, ""); //Email address where you wish to receive/collect those emails.
}*/
$mail->WordWrap = 100; // set word wrap to 50 characters
$mail->IsHTML(true); // set email format to HTML
$mail->Subject = $mail_subject;
$message = $mail_Body;
$mail->Body = $message;
if(!$mail->Send())
{
/*echo "Message could not be sent. <p>";
echo "Mailer Error: " . $mail->ErrorInfo;
exit;*/
}
else
{
//echo 'ok';
}
}
}