status = $context['status']; $this->order = (empty($context['list_config']['order'])) ? "ASC" : $context['list_config']['order']; $this->method = (empty($context['list_config']['method'])) ? "company_name" : $context['list_config']['method']; } public function get_data() { global $database; $status = $this->status; $get_clients = " SELECT clients.id, clients.client_type, clients.company_name, clients.submitter, clients.date_submitted, CONCAT(clients_locations.address,', ',clients_locations.suburb,', ',clients_locations.state,', ',clients_locations.post_code) AS address, clients_locations.business_phone, clients_locations.fax, CONCAT(contacts.first_name,' ',contacts.last_name) AS contact_person, contacts.email AS email FROM clients LEFT JOIN clients_locations ON clients.primary_location_id = clients_locations.id LEFT JOIN contacts ON clients.primary_contact_id = contacts.id WHERE clients.status = '$status' "; $results = $database->getAll($get_clients); $count = 0; $return_results = array(); foreach($results AS $result) { $id = $result['id']; $company_name = $result['company_name']; $client_type = $result['client_type']; $address = $result['address']; $contact_person = $result['contact_person']; $business_phone = $result['business_phone']; $fax = $result['fax']; $email = $result['email']; $submitter = $result['submitter']; $date_submitted = $result['date_submitted']; $submitter = $users[$submitter]; $contact_person = (empty($contact_person)) ? "-" : $contact_person; $return_results[] = $result; } $this->final_results = $return_results; self::prepare(); return $this; } public function show() { $order = $this->order; $method = $this->method; $status = $this->status; $avail_edit = $this->avail_edit; $avail_status = $this->avail_status; $link_view = $this->link_view; $link_edit = $this->link_edit; $results = $this->final_results; $normalised_results = filter::sort_results($method,$order,$results); $normalise_get = filter::normalise_get($order); $pagination_results = filter::pagination($normalised_results,$normalise_get); filter::pagination_html($pagination_results); $pagination = $pagination_results['pagination']; $start = $pagination_results['start']; $size = $pagination_results['size']; $total_results = $pagination_results['total_results']; $max_size = $pagination_results['max_size']; $order = ($order == "ASC") ? "DESC" : "ASC"; $normalise_get = filter::normalise_get($order); $new_normalised_results = array(); foreach($normalised_results AS $key => $value) $new_normalised_results[] = $key; ?> 0) { ?>

	Edit	Company Name	Address	Contact	Email	Phone