public function fetchActivitiesDetails($activitiesId, $status = "Y", $lang = "fr")
{
// fetch details from [projects], specified by productId, and optional status
$sql = "SELECT r.*, r.description_" . $lang . " AS description, r.highlights_" . $lang . " AS highlights,r.name_" . $lang . " AS name";
$sql .= " FROM activities r ";
$sql .= "WHERE r.id = '" . intval($activitiesId) . "' ";
if ($status != "") {
$sql .= "AND r.online = '" . Data::magicAddSlashes($status) . "' ";
}
return $this->_db->select($sql);
}
function fetchContacts($lang = "fr", $status = "Y")
{
$sql = "SELECT id, name, job_" . $lang . " AS job, descr_job_" . $lang . " AS job_desc, email, image, description_" . $lang . " AS description";
$sql .= " FROM contacts ";
$sql .= "WHERE 1 ";
// filter by status
if ($status != "") {
$sql .= "AND online = '" . Data::magicAddSlashes($status) . "' ";
}
return $this->_db->select($sql);
}
public function fetchProjects($lang = "fr", $status = "Y", $order = "rank", $numReturn = 0, $numStart = 0, $location = "", $rooms = "", $exclude_id = 0)
{
$sql = "SELECT p.id AS project_id, p.online, p.name_" . $lang . " AS project_name, p.name_" . $lang;
$sql .= " FROM projects p ";
$sql .= "WHERE 1 ";
if ($status != "") {
$sql .= "AND p.online = '" . Data::magicAddSlashes($status) . "' ";
}
if ($exclude_id > 0) {
$sql .= "AND p.id <> '" . intval($exclude_id) . "' ";
}
$sql .= "ORDER BY project_name ASC ";
if ($numReturn > 0) {
$sql .= "LIMIT " . $numStart . ", " . $numReturn;
}
return $this->_db->select($sql);
}
public function fetchTestimonials($status = "Y", $lang = 'en', $type = 0, $limit = 0)
{
// type 1 Rentals
// type 2 Sales
// type 3 Magnament
$sql = "SELECT * ";
$sql .= "FROM testimonials ";
$sql .= "WHERE 1 ";
if ($status != "") {
$sql .= "AND online = '" . Data::magicAddSlashes($status) . "' ";
}
if ($lang != "") {
$sql .= "AND lang = '" . Data::magicAddSlashes($lang) . "' ";
}
if ($type != 0) {
$sql .= "AND type = '" . Data::magicAddSlashes($type) . "' ";
}
$sql .= "ORDER BY id ";
if ($limit > 0) {
$sql .= "LIMIT " . $limit;
}
return $this->_db->select($sql);
}
</a></li>
<li <?php
echo $data['title_page'] == 'testimonials' ? "class='active'" : "";
?>
><a href="<?php
echo Data::makeUrl('testimonials.php', $_SESSION['site_lang']);
?>
"><?php
echo Language::show('testimonials', 'header', $_SESSION['site_lang']);
?>
</a></li>
<li <?php
echo $data['title_page'] == 'contact' ? "class='active'" : "";
?>
><a href="<?php
echo Data::makeUrl('contact.php', $_SESSION['site_lang']);
?>
"><?php
echo Language::show('contact', 'header', $_SESSION['site_lang']);
?>
</a></li>
</ul>
</div>
</div>
<br><br>
</nav>
</div>
</div>
</div>
</footer>
public function fetchSalesDetails($salesId, $status = "Y", $lang = "fr")
{
// fetch details from [projects], specified by productId, and optional status
$sql = "SELECT r.*, r.locations_id, r.description_" . $lang . " AS description, r.highlights_" . $lang . " AS highlights, r.address, r.has_promotion, r.price_promotion, r.deadline_promotion, r.beds_details_" . $lang . " AS beds_details, p.image, l.name_" . $lang . " AS location ";
$sql .= "FROM sales r ";
$sql .= "LEFT JOIN sale_photos p ON p.sales_id = r.id AND p.rank = 1 ";
$sql .= "INNER JOIN locations l ON l.id = r.locations_id ";
$sql .= "WHERE r.id = '" . intval($salesId) . "' ";
if ($status != "") {
$sql .= "AND r.online = '" . Data::magicAddSlashes($status) . "' ";
}
return $this->_db->select($sql);
}
<?php
if ($value == "rentals") {
?>
<div class="row">
<div class="col-md-12">
<h6 class="pull-right grey-color-text"><?php
echo Language::show('price_per', 'view_index', $site_lang);
?>
<?php
if ($row->has_promotion == 'Y') {
?>
<del><div class="title-inline"><?php
echo number_format($row->price_low, 2);
?>
$US</div></del> <a class="btn btn-warning btn-xs" href="<?php
echo Data::makeUrl($item_url, $_SESSION['site_lang']);
?>
" role="button"><span class="glyphicon glyphicon-certificate" aria-hidden="true"></span> <?php
echo Language::show('promotion', 'view_index', $site_lang);
?>
</a>
<?php
} else {
?>
<div class="title-inline"><?php
echo number_format($row->price_low, 2);
?>
$US</div>
<?php
}
?>
</form>
</div>
<div class="hr_blue"></div>
<div class="row">
<div class="col-md-4 text-left">
<h4><?php
echo count($data['search_results_row']);
?>
<small> <?php
echo Language::show('search_results', 'rentals', $site_lang);
?>
</small></h4>
</div>
<div class="col-md-8 text-right">
<h5><a href="<?php
echo Data::makeUrl('location.php', $_SESSION['site_lang']);
?>
"><?php
echo Language::show('all_rentals', 'rentals', $site_lang);
?>
</a></h5>
<?php
include INCLUDES_PATH . 'form_order.php';
?>
</div>
</div>
<div class="hr_blue"></div>
<br><br><br>
<?php
include INCLUDES_PATH . 'view_index.php';
?>
if ($data['locations_sales_result_row']) {
?>
<?php
foreach ($data['locations_sales_result_row'] as $row) {
?>
<option value="<?php
echo $row->location_id;
?>
" <?php
if ($data['location'] == $row->location_id) {
?>
selected="selected" <?php
}
?>
><?php
echo Data::ucw(Data::slw(str_replace("~", "", $row->location_name)));
?>
</option>
<?php
}
?>
<?php
}
?>
</select>
</div>
<div class="row">
<div class="col-md-6">
<div class="form-group">
<select name="rooms" class="form-control">
<option value="">- <?php
?>
<br><br>
<div class="hr_blue"></div>
<div class="row">
<div class="col-md-4 text-left">
<h4><?php
echo count($data['search_results_row']);
?>
<small> <?php
echo Language::show('search_results', 'sales', $site_lang);
?>
</small></h4>
</div>
<div class="col-md-8 text-right">
<h5><a href="<?php
echo Data::makeUrl("vente.php", $_SESSION['site_lang']);
?>
"><?php
echo Language::show('all_sales', 'sales', $site_lang);
?>
</a></h5>
<?php
include INCLUDES_PATH . 'form_order.php';
?>
</div>
</div>
<div class="hr_blue"></div>
<br><br><br>
<?php
include INCLUDES_PATH . 'view_index.php';
?>
<?php
echo Language::show('bedrooms', 'sales', $site_lang);
?>
</p>
</div>
<div class="col-md-6">
<h6 class="pull-right grey-color-text">
<div class="title-inline"><?php
echo number_format($row->price, 2);
?>
$ US</div>
</h6>
</div>
</div>
<?php
echo Data::shortenString(strip_tags($row->highlights), 200);
?>
</div>
</div>
</div>
</div>
<?php
}
?>
</div>
</div>
<?php
}
?>
</div>
</div>
</div>
</div>
<?php
include INCLUDES_PATH . 'fb_comments.php';
?>
</div>
<div class="col-md-3 col-md-pull-9">
<div class="list-group">
<?php
foreach ($data['search_results_detail_activities'] as $fila) {
?>
<?php
$activities_url = Data::urlAct($_SESSION['site_lang']) . "/" . $fila->activity_id . "/" . Data::makeAlphaUrl($fila->name);
?>
<p><a class="list-group-item" href="<?php
echo Data::makeUrl($activities_url, $_SESSION['site_lang']);
?>
"><?php
echo $fila->name;
?>
</a></p>
<?php
}
?>
</div>
</div>
<?php
}
}
?>
</div>
<div class="col-md-6 altura-caja-location">
<p class="pull-right"><?php
echo $row->location;
?>
</p>
</div>
</div>
</div>
</div>
<?php
}
?>
<div class="hr_blue"></div>
<div class="pull-right">
<h5><a href="<?php
echo Data::makeUrl('vente.php', $_SESSION['site_lang']);
?>
" class="pull-left"><?php
echo Language::show('see_all_sales', 'welcome', $site_lang);
?>
</a></h5><br><br><br><br>
</div>
</div>
</div>
</div>
<div class="col-md-3 col-md-pull-9" id="limit-bottom">
<div class="display-mobile2">
<div class="container-fluid">
<div class="row-fluid">
<center>
<div id='FK_Excellence_Badge5329b52d9247e'>
echo Language::show('testimonial', 'testimonials_left', $site_lang);
?>
</div>
</h3>
<div class="grey-color-text">
<?php
foreach ($data['testimonials'] as $row) {
?>
<blockquote class="blockquote-side">
<?php
echo $row->comment;
?>
<br><br>
<?php
echo $row->name . ", " . $row->place_visited . " " . $row->date;
?>
</blockquote>
<?php
}
?>
</div>
<div class="hr_blue"></div><br>
<h5><a href="<?php
echo Data::makeUrl('testimonials.php', $_SESSION['site_lang']);
?>
" class="pull-right"><?php
echo Language::show('see_all_testimonials', 'testimonials_left', $site_lang);
?>
</a></h5><br><br><br>
<?php
}
