public function index()
{
$conditions = array("list.is_featured" => 1, "list.is_enable" => 1, "list.status" => 1, "list_photo.is_featured" => 1, "list_photo.is_featured" => 1, "list.banned" => 0);
$limit = array(30);
$data['lists'] = $this->Rooms_model->get_rooms_byImage($conditions, NULL, $limit);
$limit = array(3);
$orderby = array("id", "desc");
$conditionL = array("list.is_enable" => 1, "list.status" => 1);
$data['latest_ads'] = $this->Rooms_model->get_rooms($conditionL, NULL, $limit, $orderby);
$this->db->distinct()->select()->select('neigh_city.id')->where('neigh_city.is_home', 1);
$this->db->from('neigh_city')->order_by("id", "random")->limit(8, 0);
/*$this->db->join('neigh_city_place', 'neigh_city_place.city_name = neigh_city.city_name');
$this->db->join('neigh_post', 'neigh_post.city = neigh_city_place.city_name');
$this->db->where('neigh_city_place.is_featured',1)->where('neigh_post.is_featured',1);*/
$data['cities'] = $this->db->get();
$this->db->select()->from("list")->limit(4, 0);
$data['rooms'] = $this->db->get();
// Advertisement popup 1 start
$data['PagePopupContent'] = GetPagePopupContent('home');
// Advertisement popup 1 end
$data["title"] = $this->dx_auth->get_site_title();
$data["meta_keyword"] = $this->Common_model->getTableData('settings', array('code' => 'META_KEYWORD'))->row()->string_value;
$data["meta_description"] = $this->Common_model->getTableData('settings', array('code' => 'META_DESCRIPTION'))->row()->string_value;
$data['message_element'] = "home/view_home";
$this->load->view('template', $data);
}
public function index()
{
//Get the checkin and chekout dates
$checkin = '';
$checkout = '';
$stack = array();
$room_types = array();
$checkin = $this->input->post('checkin');
$checkout = $this->input->post('checkout');
$nof_guest = $this->input->post('number_of_guests');
if ($this->input->post('room_types1')) {
$room_types1 = $this->input->post('room_types1');
$data['room_types1'] = $room_types1;
}
if ($this->input->post('room_types2')) {
$room_types2 = $this->input->post('room_types2');
$data['room_types2'] = $room_types2;
}
if ($this->input->post('room_types3')) {
$room_types3 = $this->input->post('room_types3');
$data['room_types3'] = $room_types3;
}
if ($this->input->post('room_types4')) {
$room_types1 = $this->input->post('room_types4');
$data['room_types1'] = $room_types1;
}
if ($this->input->post('room_types5')) {
$room_types2 = $this->input->post('room_types5');
$data['room_types2'] = $room_types2;
}
if ($this->input->post('room_types6')) {
$room_types3 = $this->input->post('room_types6');
$data['room_types3'] = $room_types3;
}
if ($this->input->post('room_types11')) {
$room_types1 = $this->input->post('room_types11');
$data['room_types1'] = $room_types1;
}
if ($this->input->post('room_types22')) {
$room_types2 = $this->input->post('room_types22');
$data['room_types2'] = $room_types2;
}
if ($this->input->post('room_types33')) {
$room_types3 = $this->input->post('room_types33');
$data['room_types3'] = $room_types3;
}
$min = $this->input->post('min');
$max = $this->input->post('max');
//get starred list status
$star = $this->input->get('starred');
$page = $this->input->get('page', 1);
$data['page'] = $page;
$array_items = array('Vcheckin' => '', 'Vcheckout' => '', 'Vcheckout' => '');
$this->session->unset_userdata($array_items);
if ($this->input->post('checkin') != '' || $this->input->post('checkin') != 'mm/dd/yy') {
$freshdata = array('Vcheckin' => $this->input->post('checkin'), 'Vcheckout' => $this->input->post('checkout'), 'Vnumber_of_guests' => $this->input->post('number_of_guests'));
$this->session->set_userdata($freshdata);
}
if ($this->input->post('location')) {
$location = $this->input->post('location');
//$this->session->unset_userdata('location1');
//$this->session->set_userdata('location',$location);
} else {
if ($this->input->get('location')) {
$location = $this->input->get('location');
} else {
if ($this->session->userdata('ajax_search_location') != '') {
//$location = $this->session->userdata('ajax_search_location');
}
}
}
$ser = $this->input->post('searchbox');
if ($this->input->post('searchbox') != '') {
$location = $this->input->post('searchbox');
//$this->session->unset_userdata('location');
//$this->session->set_userdata('location1',$location);
}
if (!isset($location)) {
$location = '';
}
if (isset($location)) {
$pieces = explode(",", $location);
$data['pieces'] = $pieces;
$check = $this->input->post('checkin');
if (isset($check)) {
$checkin = $this->input->post('checkin');
//$this->session->set_userdata('checkin',$checkin);
} else {
$checkin = 'mm/dd/yy';
}
$check_out = $this->input->post('checkout');
if (isset($check_out)) {
$checkout = $this->input->post('checkout');
//$this->session->set_userdata('checkout',$checkout);
} else {
$checkout = 'mm/dd/yy';
}
if ($this->input->post('number_of_guests')) {
$number_of_guests = $this->input->post('number_of_guests');
//$this->session->set_userdata('number_of_guests',$number_of_guests);
} else {
$number_of_guests = '1';
}
/* if(!$this->input->post('location'))
{
$location = $this->session->userdata('location');
}
if($location == '')
{
$location = $this->session->userdata('location1');
}
if($this->input->get('location'))
{
$location = $this->input->get('location');
}*/
if (!$this->input->post('checkin')) {
//$checkin = $this->session->userdata('checkin');
}
if (!$this->input->post('checkout')) {
//$checkout = $this->session->userdata('checkout');
}
if (!$this->input->post('number_of_guests')) {
//$number_of_guests = $this->session->userdata('number_of_guests');
}
$data['property_type'] = $this->Common_model->getTableData('property_type')->result_array();
$data['query'] = $location;
$data['checkin'] = $checkin;
$data['checkout'] = $checkout;
$data['number_of_guests'] = $number_of_guests;
$data['room_types'] = $room_types;
$data['min'] = $min;
$data['max'] = $max;
$data['amnities'] = $this->Rooms_model->get_amnities();
$data['lat'] = $this->input->post('lat');
$data['lng'] = $this->input->post('lng');
if ($this->input->post('lat') != '') {
$this->session->set_userdata('lat', $data['lat']);
$this->session->set_userdata('lng', $data['lng']);
} else {
$data['lat'] = $this->session->userdata('lat');
$data['lng'] = $this->session->userdata('lng');
}
//echo $this->input->post('lat1');exit;
}
$data['wishlist_category'] = $this->Common_model->getTableData('wishlists', array('user_id' => $this->dx_auth->get_user_id()));
$data['user_wishlist'] = $this->Common_model->getTableData('user_wishlist', array('user_id' => $this->dx_auth->get_user_id()));
// $data['query'] = '';
//$data['property_type'] = $this->Common_model->getTableData('property_type')->result_array();
// Advertisement popup 1 start
$data['PagePopupContent'] = GetPagePopupContent('search');
// Advertisement popup 1 end
$data['title'] = get_meta_details('Search_Elements', 'title');
$data["meta_keyword"] = get_meta_details('Search_Elements', 'meta_keyword');
$data["meta_description"] = get_meta_details('Search_Elements', 'meta_description');
$data['message_element'] = 'view_search_result';
$this->load->view('template', $data);
}
public function index($room_id = '', $preview = '')
{
// if($this->dx_auth->get_user_id() != "")
// {
// $conditions = array("id" => $room_id, "list.status" => 1, "list.is_enable"=>1, "list.list_pay"=>1);
// }
// else {
$conditions = array("id" => $room_id, "list.status" => 1);
// }
$result = $this->Common_model->getTableData('list', $conditions);
$conditions1 = array("id" => $room_id);
$lys_status = $this->Common_model->getTableData('lys_status', $conditions1)->row();
$total_status = $lys_status->calendar + $lys_status->price + $lys_status->overview + $lys_status->address + $lys_status->photo + $lys_status->listing;
if ($result->row()->user_id != $this->dx_auth->get_user_id()) {
if ($result->row()->is_enable != 1 || $result->row()->list_pay != 1 || $total_status != 6) {
redirect('info');
}
}
$data['preview'] = $preview;
////////////////For viewing page statistics -Update///////////
$today_month = date("F");
$today_date = date("j");
$today_year = date("Y");
$conditions_statistics = array("list_id" => $room_id, "date" => trim($today_date), "month" => trim($today_month), "year" => trim($today_year));
$result_statistics = $this->Common_model->add_page_statistics($room_id, $conditions_statistics);
//////////////////////////
if ($result->num_rows() == 0) {
redirect('info/deny');
}
$data['list'] = $list = $result->row();
$title = $list->title;
$page_viewed = $list->page_viewed;
$data['page_viewed'] = $this->Trips_model->update_pageViewed($room_id, $page_viewed);
$id = $room_id;
$checkin = $this->session->userdata('Vcheckin');
$checkout = $this->session->userdata('Vcheckout');
$data['guests'] = $this->session->userdata('Vnumber_of_guests');
$ckin = explode('/', $checkin);
$ckout = explode('/', $checkout);
$xprice = $this->Common_model->getTableData('price', array('id' => $id))->row();
$guests = $xprice->guests;
if (isset($xprice->cleaning)) {
$data['cleaning'] = $xprice->cleaning;
} else {
$data['cleaning'] = 0;
}
if (isset($xprice->security)) {
$data['security'] = $xprice->security;
} else {
$data['security'] = 0;
}
if (isset($xprice->night)) {
$price = $xprice->night;
} else {
$price = 0;
}
if (isset($xprice->week)) {
$Wprice = $xprice->week;
} else {
$Wprice = 0;
}
if (isset($xprice->month)) {
$Mprice = $xprice->month;
} else {
$Mprice = 0;
}
$data['guest_price'] = $xprice->addguests;
$data['extra_guest'] = $xprice->guests;
// Discount label 2 start
if ($price < $xprice->previous_price) {
$discount = ($xprice->previous_price - $price) / $xprice->previous_price * 100;
$data['discount'] = $discount;
} else {
$data['discount'] = 0;
}
// Discount label 2 end
//check admin premium condition and apply so for
$query = $this->Common_model->getTableData('paymode', array('id' => 2));
$row = $query->row();
if ($ckin[0] == "mm" && $ckout[0] == "mm" or $ckin[0] == "" && $ckout[0] == "" or $checkin == 'Check in' or $checkout == 'Check out') {
$data['price'] = $price;
if ($Wprice == 0) {
$data['Wprice'] = $price * 7;
} else {
$data['Wprice'] = $Wprice;
}
if ($Mprice == 0) {
$data['Mprice'] = $price * 30;
} else {
$data['Mprice'] = $Mprice;
}
if ($row->is_premium == 1) {
if ($row->is_fixed == 1) {
$fix = $row->fixed_amount;
$amt = $price + $fix;
$data['commission'] = $fix;
$Fprice = $amt;
} else {
$per = $row->percentage_amount;
$camt = floatval($price * $per / 100);
$amt = $price + $camt;
$data['commission'] = $camt;
$Fprice = $amt;
}
if ($Wprice == 0) {
$data['Wprice'] = $price * 7;
} else {
$data['Wprice'] = $Wprice;
}
if ($Mprice == 0) {
$data['Mprice'] = $price * 30;
} else {
$data['Mprice'] = $Mprice;
}
}
} else {
$diff = strtotime($ckout[2] . '-' . $ckout[0] . '-' . $ckout[1]) - strtotime($ckin[2] . '-' . $ckin[0] . '-' . $ckin[1]);
$days = ceil($diff / (3600 * 24));
if ($data['guests'] > $guests) {
$price = $price * $days + $days * $xprice->addguests;
} else {
$price = $price * $days;
}
//Entering it into data variables
$data['price'] = $price;
if ($Wprice == 0) {
$data['Wprice'] = $price * 7;
} else {
$data['Wprice'] = $Wprice;
}
if ($Mprice == 0) {
$data['Mprice'] = $price * 30;
} else {
$data['Mprice'] = $Mprice;
}
$data['commission'] = 0;
if ($row->is_premium == 1) {
if ($row->is_fixed == 1) {
$fix = $row->fixed_amount;
$amt = $price + $fix;
$data['commission'] = $fix;
$Fprice = $amt;
} else {
$per = $row->percentage_amount;
$camt = floatval($price * $per / 100);
$amt = $price + $camt;
$data['commission'] = $camt;
$Fprice = $amt;
}
if ($Wprice == 0) {
$data['Wprice'] = $price * 7;
} else {
$data['Wprice'] = $Wprice;
}
if ($Mprice == 0) {
$data['Mprice'] = $price * 30;
} else {
$data['Mprice'] = $Mprice;
}
}
}
$conditions = array('list_id' => $room_id);
$data['images'] = $this->Gallery->get_imagesG(NULL, $conditions);
$data['amnities'] = $this->Rooms_model->get_amnities();
$conditions = array('list_id' => $room_id, 'userto' => $list->user_id);
$data['result'] = $this->Trips_model->get_review($conditions);
$conditions = array('list_id' => $room_id, 'userto' => $list->user_id);
$data['stars'] = $this->Trips_model->get_review_sum($conditions)->row();
$data['room_id'] = $room_id;
$price = $this->Common_model->getTableData('price', array('id' => $room_id));
$data['prices'] = $price->row();
$data['lat'] = $list->lat;
$data['long'] = $list->long;
$data['policy'] = $this->Common_model->getTableData('cancellation_policy', array('id' => $list->cancellation_policy))->row()->name;
$data['city'] = $list->city;
$data['state'] = $list->state;
$data['country'] = $list->country;
$data['street_address'] = $list->street_address;
$data['optional_address'] = $list->optional_address;
$data['zip_code'] = $list->zip_code;
$data['instance_book'] = $list->instance_book;
// wishlist count 1 start
// wishlist count 1 end
// Advertisement popup 1 start
$data['PagePopupContent'] = GetPagePopupContent('rooms');
// Advertisement popup 1 end
$data['title'] = substr($title, 0, 70);
$data["meta_keyword"] = "";
$data["meta_description"] = "";
$data['fb_app_id'] = $this->db->get_where('settings', array('code' => 'SITE_FB_API_ID'))->row()->string_value;
$data['message_element'] = "rooms/view_edit_confirm";
$this->load->view('template', $data);
}
function paypal_success()
{
$token = $_GET['token'];
$payer_id = $_GET['PayerID'];
// GetExpressCheckoutDetails
$get_ec_return = $this->paypal_ec->get_ec($token);
if (isset($get_ec_return['ec_status']) && $get_ec_return['ec_status'] === true) {
// at this point, you have all of the data for the transaction.
// you may want to save the data for future action. what's left to
// do is to collect the money -- you do that by call DoExpressCheckoutPayment
// via $this->paypal_ec->do_ec();
//
// I suggest to save all of the details of the transaction. You get all that
// in $get_ec_return array
$currency_code = $this->session->userdata('currency_code_payment');
if ($currency_code == 'INR' || $currency_code == 'MYR' || $currency_code == 'ARS' || $currency_code == 'CNY' || $currency_code == 'IDR' || $currency_code == 'KRW' || $currency_code == 'VND' || $currency_code == 'ZAR') {
$currency_code = 'USD';
//$currency_code = $this->session->userdata('booking_currency_symbol');
$amt = get_currency_value_lys($currency_code, $currency_code, $amt);
} else {
//$currency_code = $this->session->userdata('booking_currency_symbol');
$currency_code = $currency_code;
$amt = $amt;
}
$ec_details = array('token' => $token, 'payer_id' => $payer_id, 'currency' => $currency_code, 'amount' => $get_ec_return['PAYMENTREQUEST_0_AMT'], 'IPN_URL' => site_url('payments/ipn'), 'type' => 'sale');
// DoExpressCheckoutPayment
$do_ec_return = $this->paypal_ec->do_ec($ec_details);
if (isset($do_ec_return['ec_status']) && $do_ec_return['ec_status'] === true) {
// at this point, you have collected payment from your customer
// you may want to process the order now.
/* echo "<h1>Thank you. We will process your order now.</h1>";
echo "<pre>";
echo "\nGetExpressCheckoutDetails Data\n" . print_r($get_ec_return, true);
echo "\n\nDoExpressCheckoutPayment Data\n" . print_r($do_ec_return, true);
echo "</pre>";exit; */
if (isset($do_ec_return['L_SHORTMESSAGE0']) && $do_ec_return['L_SHORTMESSAGE0'] === 'Duplicate Request') {
redirect('home');
}
$refer = $this->db->query("select * from `referral_management` where `id`=1 ")->row();
//$data['fixed_status']=$refer->fixed_status;
$refamt = $refer->fixed_amt;
$refcur = $refer->currency;
$type = $refer->type;
$trip_amt = $refer->trip_amt;
$trip_per = $refer->trip_per;
$rent_amt = $refer->rent_amt;
$rent_per = $refer->rent_per;
$ref_total = get_currency_value2($refcur, 'USD', $refamt);
if ($type == 1) {
$trip_amt0 = $trip_amt;
$rent_amt0 = $rent_amt;
$trip = get_currency_value2($refcur, 'USD', $trip_amt);
$rent = get_currency_value2($refcur, 'USD', $rent_amt);
}
if ($type == 0) {
$trip = $trip_per / 100 * $ref_total;
$rent = $rent_per / 100 * $ref_total;
$current = $this->session->userdata("locale_currency");
}
$custom = $this->session->userdata('custom');
$data = array();
$list = array();
$data = explode('@', $custom);
$contact_key = $data[9];
$list['list_id'] = $data[0];
$list['userby'] = $data[1];
$query1 = $this->Common_model->getTableData('list', array('id' => $list['list_id']));
$buyer_id = $query1->row()->user_id;
$list['userto'] = $buyer_id;
$list['checkin'] = $data[2];
$list['checkout'] = $data[3];
$list['no_quest'] = $data[4];
$date1 = new DateTime(date('Y-m-d H:i:s', $list['checkin']));
$date2 = new DateTime(date('Y-m-d H:i:s', $list['checkout']));
$interval = $date1->diff($date2);
if ($interval->days >= 28) {
$list['policy'] = 5;
} else {
$list['policy'] = $query1->row()->cancellation_policy;
}
$amt = $data[14];
$list['price'] = $data[14];
$currency = $data[15];
$list['payment_id'] = 2;
$list['credit_type'] = 1;
$list['transaction_id'] = 0;
$is_travelCretids = $data[5];
$user_travel_cretids = $data[6];
$list['currency'] = get_currency_code();
if ($currency != 'USD') {
$list['admin_commission'] = $data[8];
$list['cleaning'] = $data[10];
$list['security'] = $data[11];
$list['topay'] = $this->session->userdata('subtotal');
} else {
$list['admin_commission'] = $data[8];
$list['cleaning'] = $data[10];
$list['security'] = $data[11];
$list['topay'] = $this->session->userdata('subtotal');
}
$list['guest_count'] = $data[13];
if ($list['no_quest'] > $list['guest_count']) {
if ($currency != 'USD') {
$list['extra_guest_price'] = $data[12];
} else {
$list['extra_guest_price'] = $data[12];
}
}
if ($this->session->userdata('contact_key') != '') {
$updateKey = array('contact_key' => $this->session->userdata('contact_key'));
$updateData = array();
$updateData['status'] = 10;
$list['contacts_offer'] = $this->session->userdata('contacts_offer');
$this->Contacts_model->update_contact($updateKey, $updateData);
}
if ($contact_key != "None") {
$list['status'] = 1;
$this->db->select_max('group_id');
$group_id = $this->db->get('calendar')->row()->group_id;
if (empty($group_id)) {
echo $countJ = 0;
} else {
$countJ = $group_id;
}
$insertData['list_id'] = $list['list_id'];
$insertData['group_id'] = $countJ + 1;
$insertData['availability'] = 'Booked';
$insertData['booked_using'] = 'Other';
$checkin = date('m/d/Y', $list['checkin']);
$checkout = date('m/d/Y', $list['checkout']);
$days = getDaysInBetween($checkin, $checkout);
$count = count($days);
$i = 1;
foreach ($days as $val) {
if ($count == 1) {
$insertData['style'] = 'single';
} else {
if ($count > 1) {
if ($i == 1) {
$insertData['style'] = 'left';
} else {
if ($count == $i) {
$insertData['notes'] = '';
$insertData['style'] = 'right';
} else {
$insertData['notes'] = '';
$insertData['style'] = 'both';
}
}
}
}
$insertData['booked_days'] = $val;
$this->Trips_model->insert_calendar($insertData);
$i++;
}
} else {
$listid1 = $list['list_id'];
$instance_book = $this->db->where('id', $listid1)->get('list')->row()->instance_book;
//echo $this->db->last_query();
if ($instance_book == 1) {
$list['status'] = 3;
} else {
$list['status'] = 1;
}
}
if ($list['price'] > $rent) {
$user_id = $list['userby'];
$details = $this->Referrals_model->get_details_by_Iid($user_id);
$row = $details->row();
$count = $details->num_rows();
if ($count > 0) {
$user = $this->Users_model->get_user_by_id($this->dx_auth->get_user_id())->row();
$trip1 = $user->ref_trip;
$rent1 = $user->ref_rent;
$details1 = $this->Referrals_model->get_details_refamount($row->invite_from);
$amt_check = $this->db->where('id', $row->invite_from)->get('users');
if ($amt_check->num_rows() == 0) {
$insertData = array();
$insertData['user_id'] = $row->invite_from;
$insertData['count_trip'] = 1;
$insertData['amount'] = $trip1;
$this->Referrals_model->insertReferralsAmount($insertData);
} else {
$count_trip = $details1->row()->count_trip;
$amount = $amt_check->row()->amount;
$updateKey = array('id' => $row->id);
$updateData = array();
$updateData['count_trip'] = $count_trip + 1;
$updateData['amount'] = $amount + $trip1;
$this->Referrals_model->updateReferralsAmount($updateKey, $updateData);
}
}
}
$q = $query1->result();
$row_list = $query1->row();
$iUser_id = $q[0]->user_id;
$details2 = $this->Referrals_model->get_details_by_Iid($iUser_id);
$row = $details2->row();
$count = $details2->num_rows();
if ($count > 0) {
$user = $this->Users_model->get_user_by_id($this->dx_auth->get_user_id())->row();
$trip1 = $user->ref_trip;
$rent1 = $user->ref_rent;
$details3 = $this->Referrals_model->get_details_refamount($row->invite_from);
$amt_check1 = $this->db->where('id', $row->invite_from)->get('users');
if ($amt_check1->num_rows() == 0) {
$insertData = array();
$insertData['user_id'] = $row->invite_from;
$insertData['count_book'] = 1;
$insertData['amount'] = $rent1;
$this->Referrals_model->insertReferralsAmount($insertData);
} else {
$count_book = $amt_check1->row()->count_book;
$amount = $amt_check1->row()->amount;
$updateKey = array('id' => $row->id);
$updateData = array();
$updateData['count_trip'] = $count_book + 1;
$updateData['amount'] = $amount + $rent1;
$this->Referrals_model->updateReferralsAmount($updateKey, $updateData);
}
}
$admin_email = $this->dx_auth->get_site_sadmin();
$admin_name = $this->dx_auth->get_site_title();
$query3 = $this->Common_model->getTableData('users', array('id' => $list['userby']));
$rows = $query3->row();
$username = $rows->username;
$user_id = $rows->id;
$email_id = $rows->email;
$query4 = $this->Users_model->get_user_by_id($buyer_id);
$buyer_name = $query4->row()->username;
$buyer_email = $query4->row()->email;
//Check md5('No Travel Cretids') || md5('Yes Travel Cretids')
if ($is_travelCretids == '7c4f08a53f4454ea2a9fdd94ad0c2eeb') {
$query5 = $this->Referrals_model->get_details_refamount($user_id);
$amount = $query5->row()->amount;
$updateKey = array('user_id ' => $user_id);
$updateData = array();
$updateData['amount'] = $amount - $user_travel_cretids;
$this->Referrals_model->updateReferralsAmount($updateKey, $updateData);
$list['credit_type'] = 2;
$list['ref_amount'] = $user_travel_cretids;
$row = $query4->row();
//sent mail to administrator
$email_name = 'tc_book_to_admin';
$splVars = array("{site_name}" => $this->dx_auth->get_site_title(), "{traveler_name}" => ucfirst($username), "{list_title}" => $row_list->title, "{book_date}" => date('m/d/Y'), "{book_time}" => date('g:i A'), "{traveler_email_id}" => $email_id, "{checkin}" => date('d-m-Y', $list['checkin']), "{checkout}" => date('d-m-Y', $list['checkout']), "{market_price}" => $user_travel_cretids + $list['price'], "{payed_amount}" => $list['price'], "{travel_credits}" => $user_travel_cretids, "{host_name}" => ucfirst($buyer_name), "{host_email_id}" => $buyer_email);
//Send Mail
$this->Email_model->sendMail($admin_email, $email_id, ucfirst($username), $email_name, $splVars);
//sent mail to buyer
$email_name = 'tc_book_to_host';
$splVars = array("{site_name}" => $this->dx_auth->get_site_title(), "{username}" => ucfirst($buyer_name), "{traveler_name}" => ucfirst($username), "{list_title}" => $row_list->title, "{book_date}" => date('m/d/Y'), "{book_time}" => date('g:i A'), "{traveler_email_id}" => $email_id, "{checkin}" => date('d-m-Y', $list['checkin']), "{checkout}" => date('d-m-Y', $list['checkout']), "{market_price}" => $list['price']);
//Send Mail
if ($buyer_email != '0') {
$this->Email_model->sendMail($buyer_email, $admin_email, ucfirst($admin_name), $email_name, $splVars);
}
}
$list['book_date'] = local_to_gmt();
if ($this->session->userdata('coupon_code_used') == 1) {
$list['coupon'] = $this->session->userdata('coupon_code');
$this->db->where('couponcode', $list['coupon'])->update('coupon', array('status' => 1));
$this->db->where('used_coupon_code', $list['coupon'])->update('coupon_users', array('status' => 1));
$this->session->unset_userdata('coupon_code');
$this->session->unset_userdata('coupon_code_used');
} else {
$list['coupon'] = 0;
}
//Actual insertion into the database
$this->Common_model->insertData('reservation', $list);
$reservation_id = $this->db->insert_id();
$reservation_result = $this->Common_model->getTableData('reservation', array('id' => $reservation_id))->row();
$currency_symbol = $this->Common_model->getTableData('currency', array('currency_code' => $reservation_result->currency))->row()->currency_symbol;
$price = $reservation_result->currency . ' ' . $currency_symbol . $reservation_result->price;
$host_price = $reservation_result->currency . ' ' . $currency_symbol . $reservation_result->topay;
if ($interval->days >= 28) {
$conversation = $this->db->where('userto', $list['userto'])->where('userby', $list['userby'])->order_by('id', 'desc')->get('messages');
$conversation1 = $this->db->where('userto', $list['userby'])->where('userby', $list['userto'])->order_by('id', 'desc')->get('messages');
if ($conversation->num_rows() != 0) {
$conversation_id = $conversation->row()->id;
} elseif ($conversation1->num_rows() != 0) {
$conversation_id = $conversation1->row()->id;
} else {
$conversation_id = $reservation_id . '1';
}
//Send Message Notification
$insertData = array('list_id' => $list['list_id'], 'reservation_id' => $reservation_id, 'conversation_id' => $conversation_id, 'userby' => 1, 'userto' => $list['userby'], 'message' => "Your reservation is 28 days or more. So, Long Term cancellation policy applied for " . $row_list->title, 'created' => local_to_gmt(), 'message_type' => 3);
$this->Message_model->sentMessage($insertData, ucfirst($buyer_name), ucfirst($username), $row_list->title, $reservation_id);
//Send Message Notification
$insertData = array('list_id' => $list['list_id'], 'reservation_id' => $reservation_id, 'conversation_id' => $conversation_id, 'userby' => 1, 'userto' => $list['userto'], 'message' => ucfirst($username) . " reservation is 28 days or more. So, Long Term cancellation policy applied for " . $row_list->title, 'created' => local_to_gmt(), 'message_type' => 3);
$this->Message_model->sentMessage($insertData, ucfirst($buyer_name), ucfirst($username), $row_list->title, $reservation_id);
}
//Send Message Notification
if ($instance_book == 1) {
$insertData = array('list_id' => $list['list_id'], 'reservation_id' => $reservation_id, 'conversation_id' => $reservation_id, 'userby' => $list['userto'], 'userto' => $list['userby'], 'message' => 'Your reservation is successfully done ', 'created' => local_to_gmt(), 'message_type' => 3);
$this->Message_model->sentMessage($insertData, ucfirst($username), ucfirst($buyer_name), $row_list->title, $reservation_id);
$message_id = $this->db->insert_id();
$insertData = array('list_id' => $list['list_id'], 'reservation_id' => $reservation_id, 'conversation_id' => $reservation_id, 'userby' => $list['userby'], 'userto' => $list['userto'], 'message' => 'You have a new reservation from ' . ucfirst($username), 'created' => local_to_gmt(), 'message_type' => 1);
} else {
$insertData = array('list_id' => $list['list_id'], 'reservation_id' => $reservation_id, 'userby' => $list['userby'], 'userto' => $list['userto'], 'message' => 'You have a new reservation request from ' . ucfirst($username), 'created' => local_to_gmt(), 'message_type' => 1);
}
$this->Message_model->sentMessage($insertData, ucfirst($buyer_name), ucfirst($username), $row_list->title, $reservation_id);
$message_id = $this->db->insert_id();
$actionurl = site_url('trips/request/' . $reservation_id);
//date_default_timezone_set('Asia/Kolkata');
//Reservation Notification To Host
$email_name = 'host_reservation_notification';
$splVars = array("{site_name}" => $this->dx_auth->get_site_title(), "{username}" => ucfirst($buyer_name), "{traveler_name}" => ucfirst($username), "{list_title}" => $row_list->title, "{book_date}" => date('m/d/Y'), "{book_time}" => date('g:i A', time()), "{traveler_email_id}" => $email_id, "{checkin}" => date('m/d/Y', $list['checkin']), "{checkout}" => date('m/d/Y', $list['checkout']), "{market_price}" => $host_price, "{action_url}" => $actionurl);
//Send Mail
//
if ($buyer_email != '0') {
$this->Email_model->sendMail($buyer_email, $admin_email, ucfirst($admin_name), $email_name, $splVars);
}
//Reservation Notification To Traveller
$email_name = 'traveller_reservation_notification';
$splVars = array("{site_name}" => $this->dx_auth->get_site_title(), "{traveler_name}" => ucfirst($username));
//Send Mail
$this->Email_model->sendMail($email_id, $admin_email, ucfirst($admin_name), $email_name, $splVars);
//Reservation Notification To Administrator
$email_name = 'admin_reservation_notification';
$splVars = array("{site_name}" => $this->dx_auth->get_site_title(), "{traveler_name}" => ucfirst($username), "{list_title}" => $row_list->title, "{book_date}" => date('m/d/Y'), "{book_time}" => date('g:i A', time()), "{traveler_email_id}" => $email_id, "{checkin}" => date('m/d/Y', $list['checkin']), "{checkout}" => date('m/d/Y', $list['checkout']), "{market_price}" => $price, "{payed_amount}" => $list['price'], "{travel_credits}" => $user_travel_cretids, "{host_name}" => ucfirst($buyer_name), "{host_email_id}" => $buyer_email);
//Send Mail
$this->Email_model->sendMail($admin_email, $email_id, ucfirst($username), $email_name, $splVars);
// if($is_block == 'on')
// {
$this->db->select_max('group_id');
$group_id = $this->db->get('calendar')->row()->group_id;
if (empty($group_id)) {
echo $countJ = 0;
} else {
$countJ = $group_id;
}
$insertData1['list_id'] = $list['list_id'];
//$insertData['reservation_id'] = $reservation_id;
$insertData1['group_id'] = $countJ + 1;
$insertData1['availability'] = 'Not Available';
$insertData1['booked_using'] = 'Other';
$checkin = date('m/d/Y', $list['checkin']);
$checkout = date('m/d/Y', $list['checkout']);
$days = getDaysInBetween($checkin, $checkout);
// print_r($days);exit;
$count = count($days);
$i = 1;
foreach ($days as $val) {
if ($count == 1) {
$insertData1['style'] = 'single';
} else {
if ($count > 1) {
if ($i == 1) {
$insertData1['style'] = 'left';
} else {
if ($count == $i) {
$insertData1['notes'] = '';
$insertData1['style'] = 'right';
} else {
$insertData1['notes'] = '';
$insertData1['style'] = 'both';
}
}
}
}
$insertData1['booked_days'] = $val;
$this->Trips_model->insert_calendar($insertData1);
$i++;
}
$referral_amount = $this->db->where('id', $this->dx_auth->get_user_id())->get('users')->row()->referral_amount;
if ($referral_amount > $ref_total) {
$this->db->set('referral_amount', $referral_amount - $ref_total)->where('id', $this->dx_auth->get_user_id())->update('users');
}
// else
// {
// $this->db->set('referral_amount',0)->where('id',$this->dx_auth->get_user_id())->update('users');
// }
if ($this->session->userdata('call_back') == 'mobile') {
$message_element = 'payments/paypal_success_mobile';
} else {
// Advertisement popup 2 start
$data['PagePopupContent'] = GetPagePopupContent('step4');
// Advertisement popup 2 end
$message_element = 'payments/paypal_success';
}
$data['title'] = "Payment Success !";
$data['message_element'] = $message_element;
$this->load->view('template', $data);
} else {
$this->_error($do_ec_return);
}
} else {
$this->_error($get_ec_return);
}
}
