public function ajax_get_results()
{
$this->load->library("Ajax_pagination");
//get starred list status
$star = $this->input->get('starred');
//Get the checkin and chekout dates
$checkin = '';
$checkout = '';
$stack = array();
$room_types = array();
$property_type_id = array();
$this->session->set_userdata('ajax_search_location', $this->input->get('location'));
$checkin = $this->input->get('checkin');
$checkout = $this->input->get('checkout');
$nof_guest = $this->input->get('guests');
$room_types = $this->input->get('room_types');
$search_view = $this->input->get('search_view');
$min = $this->input->get('price_min');
$max = $this->input->get('price_max');
$keywords = $this->input->get('keywords');
$search_by_map = $this->input->get('search_by_map');
$sw_lat = $this->input->get('sw_lat');
$sw_lng = $this->input->get('sw_lng');
$ne_lat = $this->input->get('ne_lat');
$ne_lng = $this->input->get('ne_lng');
$min_bedrooms = $this->input->get('min_bedrooms');
$property_type = $this->input->get('property_type');
$min_bathrooms = $this->input->get('min_bathrooms');
$min_beds = $this->input->get('min_beds');
$min_bed_type = $this->input->get('min_bed_type');
$property_type_id = $this->input->get('property_type_id');
$hosting_amenities = $this->input->get('hosting_amenities');
$page = $this->input->get('page');
$sort = $this->input->get('sort');
/* if(empty($sort))
{
$sort = 1;
} */
$data['page'] = $page;
if ($checkin != '--' && $checkout != '--' && $checkin != "yy-mm-dd" && $checkout != "yy-mm-dd") {
// Specify the start date. This date can be any English textual format
$date_from = $checkin;
$date_from = strtotime($date_from);
// Convert date to a UNIX timestamp
// Specify the end date. This date can be any English textual format
$date_to = $checkout;
$date_to = strtotime($date_to);
// Convert date to a UNIX timestamp
$arr = array();
// Loop from the start date to end date and output all dates inbetween
for ($i = $date_from; $i <= $date_to; $i += 86400) {
$arr[] = $i;
}
$ans = $this->db->query("SELECT id,list_id FROM `calendar` WHERE `booked_days` = '" . get_gmt_time(strtotime($checkin)) . "' OR `booked_days` = '" . get_gmt_time(strtotime($checkout)) . "' GROUP BY `list_id`");
if ($ans->num_rows() == 0) {
$ans = $this->db->where_in('booked_days', $arr)->group_by('list_id')->get('calendar');
}
$a = $ans->result();
$this->db->flush_cache();
// Now after the checkin is completed
if (!empty($a)) {
foreach ($a as $a1) {
array_push($stack, $a1->list_id);
}
}
}
$condition = '';
$location = $this->input->get('location');
$pieces = explode(",", $location);
$print = "";
$len = count($pieces);
$condition .= "(`status` != '0')";
if ($search_by_map) {
$condition .= "AND (`lat` BETWEEN {$sw_lat} AND {$ne_lat}) AND (`long` BETWEEN {$sw_lng} AND {$ne_lng})";
} else {
if ($location != '') {
$i = 1;
foreach ($pieces as $address) {
$this->db->flush_cache();
$address = $this->db->escape_like_str($address);
if ($i == $len) {
$and = "";
} else {
$and = " AND ";
}
if ($i == 1) {
$condition .= " AND (";
}
$condition .= "`address` LIKE '%" . $address . "%' OR `neighbor` LIKE '%" . $address . "%'" . $and;
if ($i == $len) {
$condition .= ")";
}
$i++;
}
}
}
if (!empty($min_bedrooms)) {
$condition .= " AND (`bedrooms` = '" . $min_bedrooms . "')";
}
if ($property_type != 1) {
$condition .= " AND (`property_id` = '" . $property_type . "')";
}
if (!empty($min_bathrooms)) {
$condition .= " AND (`bathrooms` = '" . $min_bathrooms . "')";
}
if (!empty($min_beds)) {
$condition .= " AND (`beds` = '" . $min_beds . "')";
}
if (!empty($min_bed_type)) {
$condition .= " AND (`bed_type` = '" . $min_bed_type . "')";
}
if (!empty($stack)) {
$condition .= " AND (`id` NOT IN(" . implode(',', $stack) . "))";
}
if ($nof_guest > 1) {
$condition .= " AND (`capacity` >= '" . $nof_guest . "')";
}
if (is_array($room_types)) {
if (count($room_types) > 0) {
$i = 1;
foreach ($room_types as $room_type) {
if ($i == count($room_types)) {
$and = "";
} else {
$and = " AND ";
}
$or = " OR ";
if ($i == 1) {
$condition .= " AND (";
}
$condition .= "`room_type` = '" . $room_type . "'" . $or . "`neighbor` = '" . $room_type . "'" . $or . "`neighbor` = '" . $room_type . "'" . $or . "`room_type` = '" . $room_type . "'" . $or . "`room_type` = '" . $room_type . "'" . $and;
if ($i == count($room_types)) {
$condition .= ")";
}
$i++;
}
}
}
if (is_array($hosting_amenities)) {
if (count($hosting_amenities) > 0) {
$i = 1;
foreach ($hosting_amenities as $amenity) {
if ($i == count($hosting_amenities)) {
$and = "";
} else {
$and = " AND ";
}
if ($i == 1) {
$condition .= " AND (";
}
$condition .= "`amenities` LIKE '%" . $amenity . "%'" . $and;
if ($i == count($hosting_amenities)) {
$condition .= ")";
}
$i++;
}
}
}
if (isset($min)) {
if ($min > 0) {
$condition .= " AND (`price` >= '" . $min . "')";
}
} else {
if (isset($max)) {
$min = 0;
}
}
if (isset($max)) {
if ($max > $min) {
$condition .= " AND (`price` <= '" . $max . "')";
}
}
if (is_array($property_type_id)) {
if (count($property_type_id) > 0) {
$i = 1;
foreach ($property_type_id as $property_id) {
if ($i == count($property_type_id)) {
$and = "";
} else {
$and = " OR ";
}
if ($i == 1) {
$condition .= " AND (";
}
$condition .= "`property_id` = '" . $property_id . "'" . $and;
if ($i == count($property_type_id)) {
$condition .= ")";
}
$i++;
}
}
}
if (!empty($keywords)) {
$keywords = $this->db->escape_like_str($keywords);
$condition .= " AND (`address` LIKE '%" . $keywords . "%' OR `title` LIKE '%" . $keywords . "%' OR `desc` LIKE '%" . $keywords . "%')";
}
//Final query
$condition .= " AND (`status` != '0') AND (`user_id` != '0') AND (`address` != '0') AND (`is_enable` = '1')";
// Get offset and limit for page viewing
$start = (int) $page;
// Number of record showing per page
$per_page = 20;
if ($start > 0) {
$offset = ($start - 1) * $per_page;
} else {
$offset = $start * $per_page;
}
if ($sort == 2) {
$order = "ORDER BY price ASC";
} else {
if ($sort == 3) {
$order = "ORDER BY price DESC";
} else {
if ($sort == 4) {
$order = "ORDER BY id DESC";
} else {
$order = "ORDER BY id ASC";
}
}
}
//My ShortLists
if ($search_view == 2) {
$constraint = "";
$shortlists = $this->db->where('id', $this->dx_auth->get_user_id())->get('users')->row()->shortlist;
$my_lists = explode(',', $shortlists);
$i = 1;
foreach ($my_lists as $list) {
if ($i == count($my_lists)) {
$OR = "";
} else {
$OR = " OR ";
}
$data['query'] = $this->db->query("SELECT * FROM (`list`) WHERE {$condition} {$order} LIMIT {$offset},{$per_page}");
if ($data['query']->num_rows() != 0) {
foreach ($data['query']->result() as $row) {
if ($row->id == $list) {
$constraint .= "`id`= '" . $list . "'" . $OR;
} else {
}
}
}
$i++;
}
if ($constraint == '') {
$data['query'] = $this->db->query("SELECT * FROM (`list`) where {$condition} AND id=0 {$order} LIMIT {$offset},{$per_page}");
$total_rows = 0;
} else {
$data['query'] = $this->db->query("SELECT * FROM (`list`) where {$condition} AND {$constraint} {$order} LIMIT {$offset},{$per_page}");
$total_rows = $this->db->query("SELECT * FROM (`list`) where {$condition} AND {$constraint}")->num_rows();
}
} else {
$data['query'] = $this->db->query("SELECT * FROM (`list`) WHERE {$condition} {$order} LIMIT {$offset},{$per_page}");
$this->session->unset_userdata('query');
$this->session->set_userdata('query', "SELECT * FROM (`list`) WHERE {$condition} ORDER BY id DESC");
$total_rows = $this->db->query("SELECT * FROM (`list`) WHERE {$condition}")->num_rows();
}
$config['base_url'] = site_url('search') . '?checkin=' . urlencode($checkin) . '&checkout=' . urlencode($checkout) . '&guests=' . $nof_guest . '&location=' . urlencode($location) . '&min_bathrooms=' . $min_bathrooms . '&min_bedrooms=' . $min_bedrooms . '&min_beds=' . $min_beds . '&min_bed_type=' . $min_bed_type . '&per_page=' . $per_page . '&search_view=1&sort=' . $sort;
$config['per_page'] = $per_page;
$config['cur_page'] = $start;
$config['total_rows'] = $total_rows;
$this->ajax_pagination->initialize($config);
$pagination = $this->ajax_pagination->create_links(false);
$tCount = $data['query']->num_rows();
$properties = '';
$sno = 1;
foreach ($data['query']->result() as $row) {
//main photo
$url = getListImage($row->id);
//for map slider full list images
$images = $this->Gallery->get_imagesG($row->id);
$picture_ids = '';
foreach ($images->result() as $image) {
$picture_ids .= '"' . $image->list_id . '/' . $image->name . '",';
}
$profile_pic = $this->Gallery->profilepic($row->user_id, 2);
if ($tCount == $sno) {
$comma = '';
} else {
$comma = ',';
}
$neighbor = $row->neighbor;
$final_price = get_currency_value1($row->id, $row->price);
/* Offer price calculate */
if ($checkin != '--' && $checkout != '--' && $checkin != "yy-mm-dd" && $checkout != "yy-mm-dd") {
$daysdiff = (strtotime($checkout) - strtotime($checkin)) / (60 * 60 * 24);
}
//My shortlist
$short_listed = 0;
$cur_user_id = $this->dx_auth->get_user_id();
if ($cur_user_id) {
$shortlist = $this->Common_model->getTableData('users', array('id' => $cur_user_id))->row()->shortlist;
$my = explode(',', $shortlist);
foreach ($my as $list) {
if ($list == $row->id) {
$short_listed = 1;
}
}
}
/* end of offer calculate */
$properties .= '{
"user_thumbnail_url":"' . $profile_pic . '",
"user_is_superhost":false,
"lat":' . $row->lat . ',
"has_video":false,
"recommendation_count":0,
"lng":' . $row->long . ',
"user_id":' . $row->user_id . ',
"user_name":"' . get_user_by_id($row->user_id)->username . '",
"symbol":"' . get_currency_symbol($row->id) . '",
"review_count":' . $row->review . ',
"address":"' . $row->address . '",
"name":"' . $row->title . '",
"picture_ids":[' . substr($picture_ids, 0, -1) . '],
"hosting_thumbnail_url":"' . $url . '",
"id":' . $row->id . ',
"page_viewed":' . $row->page_viewed . ',
"price":' . $final_price . ',
"short_listed":' . $short_listed . '
}' . $comma;
$sno++;
}
$startlist = 1 + $offset;
$endlist = $offset + $per_page;
if ($endlist > $total_rows) {
$endlist = $total_rows;
}
$ajax_result = '{
"results_count_html":"\\n<b>' . $startlist . ' – ' . $endlist . '</b> of <b>' . $total_rows . ' listings</b>",
"results_count_top_html":" ' . $total_rows . ' ' . translate('results') . '\\n",
"view_type":' . $search_view . ',
"results_pagination_html":"' . $pagination . '\\n",
"present_standby_option":false,
"properties":[';
$ajax_result .= $properties;
$ajax_result .= '],
"banner_info":{},
"sort":' . $sort . '
}';
echo $ajax_result;
}
function currency_format($number)
{
$currencySymbol = get_currency_symbol();
return $currencySymbol . number_format($number, 2, '.', ',');
}
"><?php
echo ucfirst(get_user_by_id($row->userby)->username);
?>
</a>
</span></p>
<p style="margin:5px 0 0 0;"><a class="clsLink2_Bg" href="<?php
echo site_url('trips/send_message/' . $row->userby);
?>
"><?php
echo translate("View") . ' / ' . translate("Send") . ' ' . translate("Message");
?>
</a></p>
</td>
<td width="15%">
<p><?php
echo get_currency_symbol($row->list_id) . get_currency_value1($row->list_id, $row->price);
?>
</p>
<p class="clsBold"><?php
echo anchor('trips/request/' . $row->id, translate("View Confirmation"));
?>
</p>
<?php
if ($row->status < 8 && $row->status != 5 && $row->status != 6 && $row->status != 4 && $row->status != 2) {
?>
<p class="clsBold"><a id="cancellation_<?php
echo $row->id;
?>
" href="<?php
echo site_url('travelling/cancel_travel/' . $row->id . '/' . $row->list_id);
?>
function ajax_get_symbol()
{
extract($this->input->get());
echo '{"symbol":"' . get_currency_symbol($id) . '","min_price":"' . get_currency_value1($id, 10) . '","max_price":"' . get_currency_value1($id, 10000) . '"}';
}
<p> <span><?php
if ($list_staus->num_rows() == 0) {
echo 'List Deletion';
} else {
echo $row->name;
}
?>
</span>
<?php
if (isset($topay) && $topay != '' && $paid != 1) {
if ($hostpaid != 1 && $guestpaid != 1) {
// $topay = get_currency_value2($currency,$topay);
?>
<br>
<span><?php
echo get_currency_symbol($row->list_id) . get_currency_value_lys($currency, get_currency_code(), $topay);
?>
</span>
<?php
}
}
?>
</p>
</div>
<?php
}
?>
</li>
<?php
}
} else {
?>
.</div>
<?php
} else {
?>
<div class="currency_alert"><?php
echo translate("This payment transacts in");
?>
<?php
echo get_currency_symbol($id) . get_currency_code();
?>
. <?php
echo translate("Your total charge is");
?>
<?php
echo get_currency_symbol($id) . $amt;
?>
.</div>
<?php
}
?>
<p class="payment_method_explanation two_c_explanation"> <span class="paypallogo"><?php
echo translate("Instructions:");
?>
</span> <br>
<?php
echo translate("After clicking 'Book it' you will be redirected to Braintree to complete payment.");
?>
<span class="paypallogo"> <?php
echo translate("You must complete the process or the transaction will not occur.");
$this->load->view('pages/trip/listing/list-header-sort-bar');
?>
<div class="catalog-row">
<?php
$redis_functions = new Redisfunctions();
if (!empty($post_records)) {
foreach ($post_records as $key => $value) {
$value = (array) $value;
$post_url_key = $value['post_url_key'];
$post_details = $redis_functions->get_trip_details($post_url_key);
$post_title = stripslashes($post_details['post_title']);
$post_description = getNWordsFromString(stripslashes($post_details['post_description']), 40);
$post_primary_image = base_url(getImage($post_details['post_primary_image']));
$post_url = getTripUrl($post_details['post_url_key']);
$post_total_cost = get_currency_symbol($post_details['post_currency']) . $post_details['post_total_cost'];
$post_start_end_date_string = '--';
if (!empty($post_details['post_start_date']) && !empty($post_details['post_end_date'])) {
$post_date_format = 'd M Y';
$post_start_end_date_string = date($post_date_format, strtotime($post_details['post_start_date'])) . ' - ' . date($post_date_format, strtotime($post_details['post_end_date']));
}
$post_total_days = number_format($post_details['post_total_days']);
$post_region_cities = array();
if (!empty($post_details['post_regions'])) {
foreach ($post_details['post_regions'] as $region_key => $region_value) {
if (!in_array($region_value->pr_source_city, $post_region_cities)) {
$post_region_cities[] = $region_value->pr_source_city;
}
}
}
?>
<?php
$post_title = stripslashes($post_records['post_title']);
$post_description = stripslashes($post_records['post_description']);
$post_primary_image = base_url(getImage($post_records['post_primary_image']));
$post_url = getTripUrl($post_records['post_url_key']);
$post_total_cost = get_currency_symbol($post_records['post_currency']) . $post_records['post_total_cost'];
$post_start_end_date_string = '--';
if (!empty($post_records['post_start_date']) && !empty($post_records['post_end_date'])) {
$post_date_format = 'd M Y';
$post_start_end_date_string = date($post_date_format, strtotime($post_records['post_start_date'])) . ' - ' . date($post_date_format, strtotime($post_records['post_end_date']));
}
$post_total_days = number_format($post_records['post_total_days']);
$post_region_cities = array();
if (!empty($post_records['post_regions'])) {
foreach ($post_records['post_regions'] as $region_key => $region_value) {
if (!in_array($region_value->pr_source_city, $post_region_cities)) {
$post_region_cities[] = $region_value->pr_source_city;
}
}
}
?>
<div class="checkout-coll">
<div class="checkout-head">
<div class="checkout-headl" itemscope itemtype="http://schema.org/Event">
<?php
if (!empty($post_records['post_primary_image']) && file_exists($post_records['post_primary_image'])) {
?>
<a itemprop="url" href="<?php
echo $post_url;
?>
<div class="chk-line">
<span class="chk-l">
<a href="<?php
echo $get_featured_url;
?>
" class="a-no-underline" target="_blank" style="color: #4a90a4;"><?php
echo stripslashes($value['pfm_title']);
?>
:</a>
</span>
<span class="chk-r"><a href="<?php
echo $get_featured_url;
?>
" class="btn" target="_blank"><?php
echo get_currency_symbol($value['pfm_currency']) . ' ' . $value['pfm_amount'];
?>
</a></span>
<div class="clear"></div>
</div>
<?php
}
}
?>
</div>
</div>
<div class="clear"></div>
</div>
<div class="clear"></div>
<?php
echo $created;
?>
</td>
<td><?php
echo $type;
?>
</td>
<td><?php
echo get_user_times($row->checkin, get_user_timezone()) . ' - ' . get_user_times($row->checkout, get_user_timezone()) . '<br>' . $row->title;
?>
</td>
<td><?php
if (is_numeric($row->topay)) {
echo get_currency_symbol($row->list_id) . get_currency_value_lys($row->currency, get_currency_code(), $row->topay);
} else {
echo get_currency_symbol($row->list_id) . $row->topay;
}
?>
</td>
<td><?php
echo $payto;
?>
</tr>
<?php
}
?>
</tbody>
</table>
<div id="results_pagination" class="clsFloatRight">
public function invoice_template($invoice_data_array)
{
$email_subject = 'Payment confirmed #' . $invoice_data_array['payment_reference_number'];
$redis_functions = new Redisfunctions();
$str = '<!doctype html>
<html>
<head>
<meta charset="utf-8">
<title>A simple, clean, and responsive HTML invoice template</title>
<style>
.invoice-box{
max-width:800px;
margin:auto;
padding:30px;
border:1px solid #eee;
box-shadow:0 0 10px rgba(0, 0, 0, .15);
font-size:16px;
line-height:24px;
font-family:"Helvetica Neue", "Helvetica", Helvetica, Arial, sans-serif;
color:#555;
}
.invoice-box table{
width:100%;
line-height:inherit;
text-align:left;
}
.invoice-box table td{
padding:5px;
vertical-align:top;
}
.invoice-box table tr td:nth-child(2){
text-align:right;
}
.invoice-box table tr.top table td{
padding-bottom:20px;
}
.invoice-box table tr.top table td.title{
font-size:45px;
line-height:45px;
color:#333;
}
.invoice-box table tr.information table td{
padding-bottom:40px;
}
.invoice-box table tr.heading td{
background:#eee;
border-bottom:1px solid #ddd;
font-weight:bold;
}
.invoice-box table tr.details td{
padding-bottom:20px;
}
.invoice-box table tr.item td{
border-bottom:1px solid #eee;
}
.invoice-box table tr.item.last td{
border-bottom:none;
}
.invoice-box table tr.total td:nth-child(2){
border-top:2px solid #eee;
font-weight:bold;
}
@media only screen and (max-width: 600px) {
.invoice-box table tr.top table td{
width:100%;
display:block;
text-align:center;
}
.invoice-box table tr.information table td{
width:100%;
display:block;
text-align:center;
}
}
</style>
</head>
<body>
<div class="invoice-box">
<table cellpadding="0" cellspacing="0">
<tr class="top">
<td colspan="2">
<table>
<tr>
<td class="title"><img src="' . IMAGES_PATH . '/logo.png" style="width:100%; max-width:300px;"></td>
<td>
Invoice #: ' . $invoice_data_array['payment_reference_number'] . '<br>
Created: ' . $invoice_data_array['payment_created_on'] . '
</td>
</tr>
</table>
</td>
</tr>
<tr class="information">
<td colspan="2">
<table>
<tr>
<td>' . $redis_functions->get_site_setting('SITE_NAME') . '</td>
<td>' . stripslashes($invoice_data_array['payer_user_fullname']) . '<br>' . $invoice_data_array['payer_user_email'] . '</td>
</tr>
</table>
</td>
</tr>
<tr class="heading">
<td>Payment Method</td>
<td>Transaction #</td>
</tr>
<tr class="details">
<td>Paypal</td>
<td>' . $invoice_data_array['payment_txn_id'] . '</td>
</tr>
<tr class="heading">
<td>
Trip to feature
</td>
<td>
Price
</td>
</tr>
<tr class="item">
<td>' . stripslashes($invoice_data_array['post_title']) . ' <small>(' . $invoice_data_array['pfm_title'] . ')</small></td>
<td>' . get_currency_symbol($invoice_data_array['payment_currency']) . number_format($invoice_data_array['payment_amount'], 2) . '</td>
</tr>
<tr class="total">
<td></td>
<td>Total: ' . get_currency_symbol($invoice_data_array['payment_currency']) . number_format($invoice_data_array['payment_amount'], 2) . '</td>
</tr>
</table>
</div>
</body>
</html>';
return array('email_subject' => $email_subject, 'email_message' => $str);
}
</span></span>
<span class="data col-md-8 col-sm-7 col-xs-12"><span class="inner"><?php
echo get_currency_symbol($result->list_id) . get_currency_value_lys($result->currency, get_currency_code(), $subtotal);
if ($result->contacts_offer == 1) {
$special_offer = '(Special offer used.)';
} else {
$special_offer = '';
}
?>
<!--<li class="clearfix">
<span class="label"><span class="inner"><span class="checkout_icon" id="icon_cal"></span><?php
echo translate("Total Payout");
?>
</span></span>
<span class="data"><span class="inner"><?php
echo get_currency_symbol($result->list_id) . get_currency_value_lys($result->currency, get_currency_code(), $subtotal) . $special_offer;
?>
-->
<?php
if ($result->coupon == 1) {
echo ' (Coupon code used)';
}
?>
</span></span>
</li>
<li class="clearfix bottom">
<span class="label col-md-4 col-sm-5 col-xs-12" style="padding:10px 10px 0 10px;" ><span class="inner"><span class="checkout_icon" id="icon_cal"></span>
<?php
if ($result->status == 1) {
?>
?>
</div>
<div class="line_reg" style="z-index:<?php
echo $j;
?>
;" id="square_<?php
echo $i;
?>
"> <span class="startcap"></span> <span class="content"></span> <span class="endcap"><b><?php
echo get_currency_symbol($list_id) . get_currency_value1($list_id, $price);
?>
</b></span> </div>
<!--Edit calender --->
<?php
echo get_currency_symbol($list_id) . get_currency_value_lys($listcurrency, get_currency_code(), $price);
?>
</b></span> </div>
<!--edit calender -->
</div>
</div>
<?php
}
?>
<?php
$day_count++;
$day_nextmonth++;
$i++;
?>
.</div>
<?php
} else {
?>
<div class="currency_alert"><?php
echo translate("This payment transacts in");
?>
<?php
echo get_currency_symbol($id) . get_currency_code();
?>
. <?php
echo translate("Your total charge is");
?>
<?php
echo get_currency_symbol($id) . get_currency_value1($id, $amt);
?>
.</div>
<?php
}
?>
<p class="payment_method_explanation paypal_explanation"> <span style="font-weight:bold;"><?php
echo translate("Instructions");
?>
:</span> <br>
<?php
echo translate("After clicking 'Book it' you will be redirected to PayPal to complete payment.");
?>
<span style="font-weight:bold;"> <?php
echo translate("You must complete the process or the transaction will not occur.");
?>
</span></span>
<span class="data"><span class="inner"><?php
echo get_currency_symbol($result->list_id) . get_currency_value1($result->list_id, $commission);
?>
</span></span>
</li> -->
<li class="clearfix">
<span class="label"><span class="inner"><span class="checkout_icon" id="icon_cal"></span><?php
echo translate("Total Payout");
?>
</span></span>
<span class="data"><span class="inner"><?php
echo get_currency_symbol($result->list_id) . get_currency_value1($result->list_id, $subtotal);
?>
</span></span>
</li>
<li class="clearfix bottom">
<span class="label" ><span class="inner"><span class="checkout_icon" id="icon_cal"></span>
<?php
if ($result->status == 1) {
?>
<span id="expires_in">
<?php
echo translate("Expires in");
?>
</span>
<div id="expired1" style="display: none"><?php
echo translate('Expired');
<br><br><span class="endcap"><b><?php
echo get_currency_symbol($list_id) . " " . get_currency_value1($list_id, $price);
?>
</b></span>
</td>
<?php
} else {
$full_date = $next_month . '/' . $day_nextmonth . '/' . $next_year;
$pre_schedules = '<td id="day_' . $i . '" class="realday available">
<span class="dom">' . $day_nextmonth . '</span><br><br><span class="endcap"><b>' . get_currency_symbol($list_id) . ' ' . get_currency_value1($list_id, $price) . '</b></span>
</td>';
foreach ($result as $row) {
if (get_gmt_time(strtotime($full_date)) == $row->booked_days) {
$pre_schedules = '<td id="day_' . $i . '" class="realday unavailable">
<span class="dom">' . $day_nextmonth . '</span><br><br><span class="endcap"><b>' . get_currency_symbol($list_id) . ' ' . get_currency_value1($list_id, $price) . '</b></span>
</td>';
}
}
echo $pre_schedules;
}
$day_count++;
$day_nextmonth++;
$i++;
$j++;
if ($k == 7) {
$k = 0;
echo '</tr>';
}
$k++;
}
?>
review</p>
</div>
<div class="Sub_Most_View_Rgt clsFloatRight">
<p><a title="<?php
echo $row->title;
?>
" href="<?php
echo site_url() . "rooms/" . $row->id;
?>
"><?php
echo substr($row->title, 0, 25);
?>
</a></p>
<p> <?php
echo get_currency_symbol($row->id) . get_currency_value1($row->id, $row->price) . ' per night';
?>
</p>
<p><img src="<?php
echo $profpic;
?>
" height='30' width="30" alt="Thump" /></p>
</div>
</div>
<?php
}
} else {
?>
<p> <?php
echo translate("Sorry! No records found.");
echo '+';
}
?>
</option>
<?php
}
?>
</select>
</span> </li>
<li>
<label for="hosting_extras_price_native"><?php
echo translate("Cleaning Fees");
?>
</label>
<span class="currency_symbol"><?php
echo get_currency_symbol($room_id);
?>
</span>
<input id="hosting_extras_price_native" name="cleaning" size="30" maxlength="3" type="text" value=<?php
if ($list_price->cleaning) {
echo get_currency_value1($room_id, $list_price->cleaning);
} else {
echo '""';
}
?>
/>
</li>
</ul>
</div>
</div>
<button style="margin: 10px 0px 0px;" class="btn green gotomsg" type="submit"><span><span><?php
function to_currency($price, $currency = DEFAULT_CURRENCY)
{
return sprintf('%1$s%2$s', get_currency_symbol($currency), number_format($price, 0));
}
echo $query["id"];
?>
"><?php
echo $query["title"];
?>
</a></div>
<?php
//echo $query["user_id"];
?>
</td>
<div class="wish_address"><?php
echo $query["address"];
?>
</div>
<div class="wish_address"><?php
echo get_currency_symbol($query["id"]) . get_currency_value1($query["id"], $query["price"]);
?>
</div>
<div class="wish_remove">
<a title="Remove My Wishlist" href="<?php
echo base_url() . 'account/remove_my_shortlist/' . $query["id"];
?>
" onclick="return confirm('Are you sure to Remove your Wish list?');">
<img src="<?php
echo base_url();
?>
/images/Delete.png" alt="Remove My Wishlist" title="Remove My Wishlist" /></a>
</div> </div>
<?php
} else {
echo '<div class="no_wishlist" style="padding:50px;text-align:center;">' . translate("No Wishlist") . '</div>';
public function ajax_refresh_subtotal()
{
$id = $this->input->get('hosting_id');
$this->session->unset_userdata("total_price_'" . $id . "'_'" . $this->dx_auth->get_user_id() . "'");
$checkin = $this->input->get('checkin');
$checkout = $this->input->get('checkout');
$data['guests'] = $this->input->get('number_of_guests');
$capacity = $this->Common_model->getTableData('list', array('id' => $id))->row()->capacity;
$ckin = explode('/', $checkin);
$ckout = explode('/', $checkout);
$xprice = $this->Common_model->getTableData('price', array('id' => $id))->row();
$guests = $xprice->guests;
$per_night = $xprice->night;
if (isset($xprice->cleaning)) {
$cleaning = $xprice->cleaning;
} else {
$cleaning = 0;
}
if (isset($xprice->security)) {
$security = $xprice->security;
} else {
$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;
}
$guest_count = $xprice->guests;
//check admin premium condition and apply so for
$query = $this->Common_model->getTableData('paymode', array('id' => 2));
$row = $query->row();
//Seasonal Price
//1. Store all the dates between checkin and checkout in an array
$checkin_time = get_gmt_time(strtotime($checkin));
$checkout_time = get_gmt_time(strtotime($checkout));
$travel_dates = array();
$seasonal_prices = array();
$total_nights = 1;
$total_price = 0;
$is_seasonal = 0;
$i = $checkin_time;
while ($i < $checkout_time) {
$checkin_date = date('m/d/Y', $i);
$checkin_date = explode('/', $checkin_date);
$travel_dates[$total_nights] = $checkin_date[1] . $checkin_date[0] . $checkin_date[2];
$i = get_gmt_time(strtotime('+1 day', $i));
$total_nights++;
}
for ($i = 1; $i < $total_nights; $i++) {
$seasonal_prices[$travel_dates[$i]] = "";
}
//Store seasonal price of a list in an array
$seasonal_query = $this->Common_model->getTableData('seasonalprice', array('list_id' => $id));
$seasonal_result = $seasonal_query->result_array();
if ($seasonal_query->num_rows() > 0) {
foreach ($seasonal_result as $time) {
//Get Seasonal price
$seasonalprice_query = $this->Common_model->getTableData('seasonalprice', array('list_id' => $id, 'start_date' => $time['start_date'], 'end_date' => $time['end_date']));
$seasonalprice = $seasonalprice_query->row()->price;
//Days between start date and end date -> seasonal price
$start_time = $time['start_date'];
$end_time = $time['end_date'];
$i = $start_time;
while ($i <= $end_time) {
$start_date = date('m/d/Y', $i);
$s_date = explode('/', $start_date);
$s_date = $s_date[1] . $s_date[0] . $s_date[2];
$seasonal_prices[$s_date] = $seasonalprice;
$i = get_gmt_time(strtotime('+1 day', $i));
}
}
//Total Price
for ($i = 1; $i < $total_nights; $i++) {
if ($seasonal_prices[$travel_dates[$i]] == "") {
$total_price = $total_price + $xprice->night;
} else {
$total_price = $total_price + $seasonal_prices[$travel_dates[$i]];
$is_seasonal = 1;
}
}
//Additional Guests
if ($data['guests'] > $guests) {
$days = $total_nights - 1;
$diff_guests = $data['guests'] - $guests;
$total_price = $total_price + $days * $xprice->addguests * $diff_guests;
$extra_guest = 1;
$extra_guest_price = $xprice->addguests * $diff_guests;
}
//Cleaning
if ($cleaning != 0) {
$total_price = $total_price + $cleaning;
}
if ($security != 0) {
$total_price = $total_price + $security;
}
//Admin Commission
$data['commission'] = 0;
if ($row->is_premium == 1) {
if ($row->is_fixed == 1) {
$fix = $row->fixed_amount;
$amt = $total_price + $fix;
$data['commission'] = $fix;
} else {
$per = $row->percentage_amount;
$camt = floatval($total_price * $per / 100);
$amt = $total_price + $camt;
$data['commission'] = $camt;
}
}
}
if ($is_seasonal == 1) {
//Total days
$days = $total_nights;
//Final price
$data['price'] = $total_price;
} else {
if ($ckin[0] == "mm" && $ckout[0] == "mm" or $ckin[0] == "" && $ckout[0] == "" or $checkin == 'Check in' or $checkout == 'Check out') {
$days = 0;
$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;
}
}
} else {
$diff = strtotime($ckout[2] . '-' . $ckout[0] . '-' . $ckout[1]) - strtotime($ckin[2] . '-' . $ckin[0] . '-' . $ckin[1]);
$days = ceil($diff / (3600 * 24));
$price = $price * $days;
//Additional guests
if ($data['guests'] > $guests) {
$diff_days = $data['guests'] - $guests;
$price = $price + $days * $xprice->addguests * $diff_days;
$extra_guest = 1;
$extra_guest_price = $xprice->addguests * $diff_days;
}
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 ($days >= 7 && $days < 30) {
if (!empty($Wprice)) {
$finalAmount = $Wprice;
$differNights = $days - 7;
$perDay = $Wprice / 7;
$per_night = round($perDay, 2);
if ($differNights > 0) {
$addAmount = $differNights * $per_night;
$finalAmount = $Wprice + $addAmount;
}
$price = $finalAmount;
//Additional guests
if ($data['guests'] > $guests) {
$diff_days = $data['guests'] - $guests;
$price = $price + $days * $xprice->addguests * $diff_days;
$extra_guest = 1;
$extra_guest_price = $xprice->addguests * $diff_days;
}
}
}
if ($days >= 30) {
if (!empty($Mprice)) {
$finalAmount = $Mprice;
$differNights = $days - 30;
$perDay = $Mprice / 30;
$per_night = round($perDay, 2);
if ($differNights > 0) {
$addAmount = $differNights * $per_night;
$finalAmount = $Mprice + $addAmount;
}
$price = $finalAmount;
//Additional guests
if ($data['guests'] > $guests) {
$diff_days = $data['guests'] - $guests;
$price = $price + $days * $xprice->addguests * $diff_days;
$extra_guest = 1;
$extra_guest_price = $xprice->addguests * $diff_days;
}
}
}
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;
}
}
$xprice = $this->Common_model->getTableData('list', array('id' => $id))->row();
if ($cleaning != 0) {
$price = $price + $cleaning;
}
if ($security != 0) {
$price = $price + $security;
}
$data['price'] = $price;
}
}
$query = $this->db->query("SELECT id,list_id FROM `calendar` WHERE `list_id` = '" . $id . "' AND (`booked_days` = '" . get_gmt_time(strtotime($checkin)) . "' OR `booked_days` = '" . get_gmt_time(strtotime($checkout)) . "') GROUP BY `list_id`");
$rows = $query->num_rows();
$daysexist = $this->db->query("SELECT id,list_id,booked_days FROM `calendar` WHERE `list_id` = '" . $id . "' AND (`booked_days` >= '" . get_gmt_time(strtotime($checkin)) . "' AND `booked_days` <= '" . get_gmt_time(strtotime($checkout)) . "') GROUP BY `list_id`");
$rowsexist = $daysexist->num_rows();
if ($rowsexist > 0) {
if (isset($extra_guest)) {
if ($extra_guest == 1) {
echo '{"available":false,"extra_guest":1,"extra_guest_price":"' . get_currency_symbol($id) . get_currency_value1($id, $extra_guest_price) . '","total_price":' . $data['price'] . ',"reason_message":"Those dates are not available"}';
}
} else {
echo '{"available":false,"total_price":' . $data['price'] . ',"reason_message":"Those dates are not available"}';
}
} else {
if ($data['guests'] > $capacity) {
echo '{"available":false,"total_price":' . $data['price'] . ',"reason_message":"' . $capacity . ' guest(s) only allowed"}';
} else {
$this->session->set_userdata("total_price_'" . $id . "'_'" . $this->dx_auth->get_user_id() . "'", $data['price']);
$staggered_price = "";
if ($days >= 30) {
$staggered_price = ',"staggered_price":"' . get_currency_symbol($id) . get_currency_value1($id, $data['price']) . '","staggered":false';
}
if (isset($extra_guest)) {
if ($extra_guest == 1) {
echo '{"service_fee":"' . get_currency_symbol($id) . get_currency_value_lys($row->currency, get_currency_code(), $data['commission']) . '","extra_guest_price":"' . get_currency_symbol($id) . get_currency_value1($id, $extra_guest_price) . '","extra_guest":1,"reason_message":"","price_per_night":"' . get_currency_symbol($id) . get_currency_value1($id, $per_night) . '","nights":' . $days . ',"available":true,"can_instant_book":false,"total_price":"' . get_currency_symbol($id) . get_currency_value1($id, $data['price']) . '"' . $staggered_price . '}';
}
} else {
echo '{"service_fee":"' . get_currency_symbol($id) . get_currency_value_lys($row->currency, get_currency_code(), $data['commission']) . '","reason_message":"","price_per_night":"' . get_currency_symbol($id) . get_currency_value1($id, $per_night) . '","nights":' . $days . ',"available":true,"can_instant_book":false,"total_price":"' . get_currency_symbol($id) . get_currency_value1($id, $data['price']) . '"' . $staggered_price . '}';
}
}
}
}
?>
>
<div style="position:absolute; bottom:0; left:0;">
<table width="500" border="0" cellspacing="0" cellpadding="0">
<tr>
<td align="left" valign="bottom" width="75%">
<?php
echo '<div class="pop_img_h">' . $query['title'] . '</div>';
echo '<div class="pop_img_h_place">' . $city['2'] . ',' . $query['country'] . '</div>';
?>
</td>
<td align="right" valign="bottom" width="25%">
<div class="pop_img_h_dollar" style="position:absolute: right:0; bottom:0;">
<div class="pop_doll">
<?php
echo '<p class="dollor_symbol">' . get_currency_symbol($query['id']) . '</p><p class="dollor_price">' . get_currency_value1($query['id'], $query['price']);
?>
<p class="per_night"><?php
echo translate('per night');
?>
</p>
</div>
</div>
</td>
</tr>
</table>
</div></div></a>
</li>
<?php
}
}
?>
</a> </span>
</strong>
<br>
<!--<a href="<?php
echo base_url() . 'rooms/' . $row->list_id;
?>
"><?php
echo $city[2] . " - " . get_currency_symbol() . "" . $row->price;
?>
</a>
<a href="<?php
echo base_url() . 'rooms/' . $row->list_id;
?>
"><?php
echo $city[2] . " - " . get_currency_symbol($row->list_id) . get_currency_value1($row->list_id, "" . $row->price);
?>
</a>
</div>
<span class="thumb_img">
<img src="<?php
echo $profile_pic;
?>
" height="40" width="40" style="border-radius: 50%;" />
</span>
</div> -->
</li>
<?php
}
?>
</ul>
$result = $db->query("SELECT available_currency FROM wp_pano_wallet WHERE user_id = {$user_id} LIMIT 1");
$final = $result->fetch_assoc();
return $final['available_currency'];
}
function get_currency_symbol()
{
$db = database_connection();
$result = $db->query("SELECT symbol FROM wp_points_info WHERE id = 1 LIMIT 1");
$final = $result->fetch_assoc();
return $final['symbol'];
}
$x = get_currency_available($user);
if ($x < 0) {
$currency_class = 'neg';
}
$symbol = get_currency_symbol();
$currency = get_currency_available($user);
?>
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<link rel="stylesheet" type="text/css" href="./wallet.css">
</head>
<body>
<div id="wrapper">
<h1>Wallet</h1>
<h2>Your current balance is:</h2>
<img src="./wallet-icon.png" alt="wallet icon" />
<p class="<?php
echo $currency_class;
<?php
if (!empty($you_may_like_records)) {
?>
<div class="h-liked">
<div class="h-liked-lbl">You May Also Like</div>
<div class="h-liked-row">
<?php
foreach ($you_may_like_records as $ykey => $yvalue) {
$post_title = stripslashes($yvalue['post_title']);
$post_primary_image = base_url(getImage($yvalue['post_primary_image']));
$post_url = getTripUrl($yvalue['post_url_key']);
$post_total_cost = get_currency_symbol($yvalue['post_currency']) . $yvalue['post_total_cost'];
?>
<!-- // -->
<div class="h-liked-item">
<div class="h-liked-item-i">
<div class="h-liked-item-l">
<a href="<?php
echo $post_url;
?>
"><img alt="<?php
echo $post_title;
?>
" src="<?php
echo $post_primary_image;
?>
"></a>
</div>
<div class="h-liked-item-c">
<div class="h-liked-item-cb">
function fun_friends_fb_id()
{
$id = $this->input->post('fb_id');
$name = $this->input->post('fb_name');
$friends_count = $this->input->post('friends_count');
$i = 0;
// Count for fb user contained Lists
foreach ($id as $fb_id) {
$result = $this->db->select('*')->where('fb_id', $fb_id)->from('users')->get();
if ($result->num_rows() != 0) {
$user_id = $result->row()->id;
$list_user_id = $this->db->where('user_id', $user_id)->get('list');
if ($list_user_id->num_rows() != 0) {
$i++;
foreach ($list_user_id->result() as $list_row) {
$conditions = array('list_id' => $list_row->id);
$limit = array(1);
$result_img = $this->Gallery->get_imagesG(NULL, $conditions, $limit);
if ($result_img->num_rows() != 0) {
foreach ($result_img->result() as $image) {
echo '<div class="fb_main"><a href="' . base_url() . 'rooms/' . $image->list_id . '">
<img src="' . base_url() . 'images/' . $image->list_id . '/' . $image->name . '" width="995" height="427"/></a>';
}
} else {
echo '<div class="fb_main"><a href="' . base_url() . 'rooms/' . $list_row->id . '">
<img src="' . base_url() . 'images/no_image.jpg" width="995" height="427"/></a>';
}
echo '<div class="connect_fb">';
echo '<img src="https://graph.facebook.com/' . $fb_id . '/picture" width="30" height="30"/><br>' . $result->row()->username . ' Saved<br>';
echo '<a class="fb_title" href="' . base_url() . 'rooms/' . $list_row->id . '">' . $list_row->title . '</a><br></div>';
echo '<div class="fb_price_bg"><div class="fb_price"><p class="fb_dollar">' . get_currency_symbol($list_row->id) . '<p>' . get_currency_value1($list_row->id, $list_row->price) . '<br><p class="per_night">' . translate('per night') . '</p></div></div></div>';
}
}
}
}
if ($i == 0) {
echo '<br><br><div class="list-view" data-feed-container="">
<div class="no-fb-friends-container">
<h2 style="font-size: 24px; line-height: 1.5;">' . translate('Looks like none of your friends have signed up for') . ' ' . $this->dx_auth->get_site_title() . ' ' . translate('yet.') . '</h2>
<br><a class="btn green" href="' . base_url() . 'home/dashboard/">' . translate('Invite them now') . '!</a>
</div>
</div>';
}
/* else {
echo '<br><br><img src="'.base_url().'images/page2_spinner.gif">';
} */
}
isMonthly: false,
nameLocked: false,
staggeredPrice: "<?php
echo get_currency_symbol($room_id) . get_currency_value1($room_id, $Mprice);
?>
",
nightlyPrice: "<?php
echo get_currency_symbol($room_id) . get_currency_value1($room_id, $price);
?>
",
weeklyPrice: "<?php
echo get_currency_symbol($room_id) . get_currency_value1($room_id, $Wprice);
?>
",
monthlyPrice: "<?php
echo get_currency_symbol($room_id) . get_currency_value1($room_id, $Mprice);
?>
"});
page3Slideshow.enableKeypressListener();
<?php
if ($this->session->userdata('Vcheckin') != '') {
?>
jQuery("#checkin").val('<?php
echo $this->session->userdata('Vcheckin');
?>
');
<?php
}
?>
echo $i;
?>
);">
<div class="tile_container">
<div class="day"><?php
echo $day_nextmonth;
?>
</div>
<div class="line_reg" style="z-index:<?php
echo $j;
?>
;" id="square_<?php
echo $i;
?>
"> <span class="startcap"></span> <span class="content"></span> <span class="endcap"><b><?php
echo get_currency_symbol($list_id) . get_currency_value1($list_id, $price);
?>
</b></span> </div>
</div>
</div>
<?php
}
?>
<?php
$day_count++;
$day_nextmonth++;
$i++;
$j--;
if ($k == 7) {
$k = 0;
echo '<div class="clear"></div></div>';
}
if ($row->message_type != 9) {
?>
<div class="clsMeg_Off clsFloatRight">
<p> <span><?php
echo $row->name;
?>
</span>
<?php
if (isset($topay)) {
// $topay = get_currency_value2($currency,$topay);
?>
<br>
<span><?php
echo get_currency_symbol($row->list_id) . get_currency_value1($row->list_id, $topay);
?>
</span>
<?php
}
?>
</p>
</div>
<?php
}
?>
</li>
<?php
}
} else {
?>
<?php
}
?>
</div>
<?php
}
if (!empty($post_details['post_costs'])) {
?>
<h2>Your Budget Information:-</h2>
<div class="complete-info-table" style="width: 95%;margin: auto;">
<?php
foreach ($post_details['post_costs'] as $key => $value) {
?>
<div class="complete-info-i">
<div class="complete-info-l"><?php
echo get_currency_symbol($value->cost_currency) . $value->cost_amount;
?>
</div>
<div class="complete-info-r"><?php
echo stripslashes($value->cost_title);
?>
</div>
<div class="clear"></div>
</div>
<div class="complete-devider"></div>
<?php
}
?>
</div>
<?php
}
