class list_clients_contacts extends listing
{
public $status;
public $method;
public $client_id;
public $results;
public function __construct($context)
{
$this->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);
$locations = common_location::get_all_locations($client_id);
$primary_contact_id = $client_details['primary_contact_id'];
$get_clients = "
SELECT *
FROM contacts
WHERE status = '$status' AND client_id = '$client_id'
";
$results = $database->getAll($get_clients);
$count = 0;
$return_results = array();
foreach($results AS $result)
{
$result['location'] = $locations[$result['location_id']]['name'];
$result['full_name'] = $result['first_name']." ".$result['last_name'];
$result = cleanup::filter_empty($result);
$result['primary'] = ($primary_contact_id == $result['id']) ? true : false;
$return_results[] = $result;
}
$this->final_results = $return_results;
$this->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;
?>
for($i = $start; $i < $max_size; $i++)
{
$key = $new_normalised_results[$i];
$mod = $count%2;
$class = ($mod == 0) ? "odd" : "even";
$count++;
$id = $results[$key]['id'];
$first_name = $results[$key]['first_name'];
$last_name = $results[$key]['last_name'];
$client_id = $results[$key]['client_id'];
$location_id = $results[$key]['location_id'];
$job_title = $results[$key]['job_title'];
$title = $results[$key]['title'];
$business_phone = $results[$key]['business_phone'];
$home_phone = $results[$key]['home_phone'];
$mobile_phone = $results[$key]['mobile_phone'];
$fax = $results[$key]['fax'];
$email = $results[$key]['email'];
$status = $results[$key]['status'];
$privacy = $results[$key]['privacy'];
$contact_type_id = $results[$key]['contact_type_id'];
$creator = $results[$key]['creator'];
$date_created = $results[$key]['date_created'];
$submitter = $results[$key]['submitter'];
$date_submitted = $results[$key]['date_submitted'];
$primary = $results[$key]['primary'];
$location = $results[$key]['location'];
$date_submitted = dates::change_date_time($date_submitted);
?>
if($avail_edit)
{
?>
}
?>
Business:
Mobile:
Last submitted by on
$notes = acl::permission("contacts_people_notes");
if($notes)
{
$num_notes = logs::num_notes("contacts",$id);
?>
}
$notes = acl::permission("contacts_people_history");
if($notes)
{
$num_logs = logs::num_logs("contacts",$id);
?>
}
?>
}
}
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);
$pagination_results['show_pagination'] = $this->show_pagination;
$pagination_results['show_search'] = $this->show_search;
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;
?>
}
}