function fetchAll($UserID, $property_status = NULL, $is_expired = FALSE)
{
// var_dump($property_status); exit;
// $this->db->select('*');
$this->db->select('p.property_id, pp.name AS property_purpose_name, pt.name AS property_type_name, loc.name AS location_name, p.price, p.created_on, p.property_status, p.area');
$this->db->from('property p');
$this->db->join('property_purpose pp', 'pp.property_purpose_id = p.property_purpose_id');
$this->db->join('property_type pt', 'pt.property_type_id = p.property_type_id');
$this->db->join('location loc', 'loc.location_id = p.location_id');
if ($property_status !== NULL) {
$this->db->where('property_status', $property_status);
}
if ($is_expired === FALSE) {
$this->db->where('expires_after <=', date("Y-m-d H:i:s"));
} else {
$this->db->where('expires_after >', date("Y-m-d H:i:s"));
}
if (getLoginUserType() == 2) {
// USER type User/Agent
$this->db->where('created_by', $UserID);
}
$this->db->where('is_deleted', 0);
$query = $this->db->get();
return $query->result();
}
<?php
if (getLoginUserType() == 1) {
?>
<a href="<?php
echo base_url('admin/property/reject/' . $property->property_id);
?>
" class="btn btn-default btn-danger">Reject</a>
<a class="btn default mdlFeaturedPropertiesBtn" data-toggle="modal" href="#mdlFeaturedProperties" data-prop-id="<?php
echo $property->property_id;
?>
">Add to Featured</a>
<?php
}
?>
<?php
if (getLoginUserType() == 2) {
?>
<a href="<?php
echo base_url('admin/property/edit/' . $property->property_id);
?>
" class="btn btn-default">Edit</a>
<a href="<?php
echo base_url('admin/property/delete/' . $property->property_id);
?>
" class="btn btn-default btn-danger">Delete</a>
<?php
}
?>
</td>
</tr>
<?php
