public function render_applications_page() { global $wpdb; $applications_table = $this->applications_table; $jobs_table = $this->jobs_table; $applications = $wpdb->get_results("SELECT a.*, j.title AS job_title FROM $applications_table a LEFT JOIN $jobs_table j ON a.job_id = j.id ORDER BY a.submitted_at DESC"); echo '
ID | '; echo 'Job Title | '; echo 'Name | '; echo 'Phone | '; echo 'Message | '; echo 'Resume | '; echo 'Company | '; echo 'Address | '; echo 'Phone (Prev) | '; echo 'Supervisor | '; echo 'Title (Prev) | '; echo 'Salary Start | '; echo 'Salary End | '; echo 'From | '; echo 'To | '; echo 'Reason | '; echo 'May Contact | '; echo 'Responsibilities | '; echo 'Submitted At | '; echo '|
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
' . esc_html($application->id) . ' | '; echo '' . esc_html($application->job_title) . ' | '; echo '' . esc_html($application->name) . ' | '; echo '' . esc_html($application->email) . ' | '; echo '' . esc_html($application->phone) . ' | '; echo '' . esc_html($application->message) . ' | '; echo ''; echo !empty($application->resume_url) ? 'Download' : 'No Resume'; echo ' | '; echo '' . esc_html($application->prev_company) . ' | '; echo '' . esc_html($application->prev_address) . ' | '; echo '' . esc_html($application->prev_phone) . ' | '; echo '' . esc_html($application->prev_supervisor) . ' | '; echo '' . esc_html($application->prev_title) . ' | '; echo '' . esc_html($application->prev_salary_start) . ' | '; echo '' . esc_html($application->prev_salary_end) . ' | '; echo '' . esc_html($application->prev_from) . ' | '; echo '' . esc_html($application->prev_to) . ' | '; echo '' . esc_html($application->prev_reason) . ' | '; echo '' . esc_html($application->prev_may_contact) . ' | '; echo '' . nl2br(esc_html($application->prev_responsibilities)) . ' | '; echo '' . esc_html($application->submitted_at) . ' | '; echo '
No applications have been submitted yet.
'; } echo '