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 }