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 '
'; echo '

Applications

'; if (!empty($applications)) { echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; foreach ($applications as $application) { echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; } echo '
IDJob TitleNameEmailPhoneMessageResumeCompanyAddressPhone (Prev)SupervisorTitle (Prev)Salary StartSalary EndFromToReasonMay ContactResponsibilitiesSubmitted At
' . esc_html($application->id) . '' . esc_html($application->job_title) . '' . esc_html($application->name) . '' . esc_html($application->email) . '' . esc_html($application->phone) . '' . esc_html($application->message) . ''; echo !empty($application->resume_url) ? 'Download' : 'No Resume'; echo '' . esc_html($application->prev_company) . '' . esc_html($application->prev_address) . '' . esc_html($application->prev_phone) . '' . esc_html($application->prev_supervisor) . '' . esc_html($application->prev_title) . '' . esc_html($application->prev_salary_start) . '' . esc_html($application->prev_salary_end) . '' . esc_html($application->prev_from) . '' . esc_html($application->prev_to) . '' . esc_html($application->prev_reason) . '' . esc_html($application->prev_may_contact) . '' . nl2br(esc_html($application->prev_responsibilities)) . '' . esc_html($application->submitted_at) . '
'; } else { echo '

No applications have been submitted yet.

'; } echo '
'; }