avail_edit = $context['avail_edit'];
$this->avail_delete = $context['avail_delete'];
$this->database = $context['database'];
$this->db_name = $context['db_name'];
$this->table = $context['table'];
$this->status = (!empty($context['status'])) ? $context['status'] : 1;
$this->client = $context['client'];
$this->link_edit = $context['link_edit'];
$this->link_view = $context['link_view'];
$this->order = (empty($context['order'])) ? "ASC" : $context['order'];
$this->method = (empty($context['method'])) ? "name" : $context['method'];
}
public function get_data()
{
global $database;
//$database->debug = true;
$db_name = $this->db_name;
$table = $this->table;
$table_status = "metro_status.".$table."_status";
$table_add = $table."_add";
$status = $this->status;
$get_clients = "
SELECT *
FROM $db_name$table AS status
WHERE status = '$status'
";
$results = $database->getAll($get_clients);
$final_results = array();
$group_names = common_ref_global_super::get_all_groups($db_name,$database);
$users = common_ref_global_super::get_all_staff($db_name,$database);
foreach($results AS $result)
{
$id = $result['id'];
$name = $result['name'];
$description = $result['description'];
$access = $result['access'];
$submitter = $result['submitter'];
$date_submitted = $result['date_submitted'];
$status = $result['status'];
$access_module = $result['access_module'];
$display_name = $result['display_name'];
$submitter = $users[$submitter]['first_name']." ".$users[$submitter]['last_name'];
$get_add_groups = "
SELECT group_add_id
FROM $db_name$table_add
WHERE group_id = '$id'
";
$groups_add = $database->getAll($get_add_groups);
$adding_groups = "";
if(is_array($groups_add))
foreach($groups_add AS $group_add)
$adding_groups .= $group_names[$group_add['group_add_id']]['name'].", ";
$adding_groups = substr($adding_groups,0,strlen($adding_groups) -2 );
$final_results[] = array(
"id" => $id,
"name" => $name,
"description" => $description,
"access" => $access,
"submitter" => $submitter,
"date_submitted" => $date_submitted,
"status" => $status,
"access_module" => $access_module,
"display_name" => $display_name,
"adding_groups" => $adding_groups
);
}
$this->final_results = $final_results;
return $this;
}
public function show()
{
$status = $this->status;
$order = $this->order;
$method = $this->method;
$database = $this->database;
$avail_edit = $this->avail_edit;
$avail_delete = $this->avail_delete;
$link_view = $this->link_view;
$link_edit = $this->link_edit;
$results = $this->final_results;
$normalised_results = filter::sort_results($method,$order,$results);
$order = ($order == "ASC") ? "DESC" : "ASC";
$normalise_get = filter::normalise_get($order);
?>
