class list_task_templates extends listing { public $status; public function __construct($context) { $this->status = $context['status']; parent::set_data($context); } public function get_data() { global $database; $status = $this->status; $users = common_users::get_all_users(); $sql =" SELECT * FROM task_templates WHERE status='$status' "; $results = $database->query($sql); $count = 0; $return_results = array(); foreach($results AS $result) { $result['submitter'] = $users[$result['submitter']]['name']; $return_results[] = $result; } $this->final_results = $return_results; self::prepare(); return $this; } public function show() { $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; ?>