order = (empty($context['order'])) ? "DESC" : $context['order']; parent::set_data($context); $this->parent_id = $context['parent_id']; $this->method = (empty($context['method'])) ? "id" : $context['method']; } public function get_data() { global $database; $parent_id = $this->parent_id; $parent_status = common_jobs::get_status($parent_id); $default_site_location = ($parent_status == 1) ? "" : "This Job is Not active"; $sql =" SELECT * FROM jobs WHERE parent_job_id='$parent_id' "; $results = $database->query($sql); $users = common_users::get_all_names_link(); $locations = common_location::get_locations(); $quote_types = common_quotes::get_all_quotes(); $job_type[0] = "Single Site"; $job_type[1] = "Single Site"; $job_type[2] = "Multi Site"; $job_type[3] = "LED Media"; $job_type[4] = "Cost Plus"; $return_results = array(); foreach($results AS $result) { $result['client_name'] = common_ref_client::get_client_name($result['client_id']); $result['site_location'] = $locations[$result['location_id']]['name']; $result['submitter'] = $users[$result['submitter']]; $result['job_type'] = $job_type[$quote_types[$result['quote_id']]['name']]; $result['star'] = ($result['parent_job'] == 1) ? "*" : ""; $result['job_type'] = $job_type[$quote_types[$result['quote_id']]['name']]; $result['site_location'] = (!empty($result['location_id'])) ? $result['site_location'] : $default_site_location; $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) { ?>edit $value) { if($value['view'] == true) { if(!empty($results[$key]['site_location'])) { if($results[$key]['site_location'] != "This Job is Not active") { ?>
Add Existing     or     Add New
list_footer(); } return $this; } }