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