class list_clients_locations extends listing { public $status; public $method; public $client_id; public $results; public function __construct($context) { parent::set_data($context); $this->client_id = $context['client_id']; $this->status = $context['status']; $this->method = (empty($context['method'])) ? "client" : $context['method']; } public function get_data() { global $database; $status = 1; $client_id = $this->client_id; $client_details = common_clients::get_details($client_id); $primary_location_id = $client_details['primary_location_id']; $users = common_users::get_users(); $get_clients = " SELECT * FROM clients_locations WHERE status = '$status' AND client_id = '$client_id' "; $results = $database->getAll($get_clients); $count = 0; $return_results = array(); foreach($results AS $result) { $result['address_full'] = $result['address'].", ".$result['suburb'].", ".$result['state'].", ".$result['post_code']; $result['submitter'] = $users[$result['submitter']]; $result = cleanup::filter_empty($result); $result['primary'] = ($primary_location_id == $result['id']) ? true : false; $return_results[] = $result; } $this->final_results = $return_results; parent::prepare(); return $this; } public function show_block() { $results = $this->final_results; $avail_status = $this->avail_status; $avail_edit = $this->avail_edit; $link_view = $this->link_view; $link_edit = $this->link_edit; $columns = $this->columns; $sortable = $this->sortable; $pagination = $this->pagination; $start = $this->start; $size = $this->size; $total_results = $this->total_results; $max_size = $this->max_size; $normalise_get = $this->normalise_get; $new_normalised_results = $this->normalised_results; ?>