class list_workflow extends listing { public $status; public function __construct($context) { $this->status = $context['status']; $this->master_id = $context['master_id']; parent::set_data($context); $this->method = "stage"; } public function get_data() { global $database; $status = $this->status; $master_id = $this->master_id; $users = common_users::get_all_names_link(); $sql =" SELECT * FROM workflow WHERE status='$status' AND master_id = '$master_id' "; $results = $database->query($sql); $count = 0; $return_results = array(); foreach($results AS $result) { $result['submitter'] = $users[$result['submitter']]; $return_results[] = $result; } $this->final_results = $return_results; self::prepare(); return $this; } public function list_body() { $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; $count = 0; if(count($results) > 0) { ?>
for($i = $start; $i < $max_size; $i++) { $key = $new_normalised_results[$i]; $mod = $count%2; $class = ($mod == 0) ? "odd" : "even"; $count++; $results[$key]['date_submitted'] = dates::change_date_time($results[$key]['date_submitted']); $results[$key]['date_created'] = dates::change_date_time($results[$key]['date_created']); ?>