summaryrefslogtreecommitdiff
path: root/job_portal.module
diff options
context:
space:
mode:
Diffstat (limited to 'job_portal.module')
-rwxr-xr-xjob_portal.module1150
1 files changed, 659 insertions, 491 deletions
diff --git a/job_portal.module b/job_portal.module
index 32cc790..f24b72a 100755
--- a/job_portal.module
+++ b/job_portal.module
@@ -1,173 +1,231 @@
-<?php
- function job_portal_permission() {
- return array(
- "access job_portal" => array(
- "title" => t("Access Job Portal"),
- "description" => t("Allows users to view job postings.")
- ),
- "manage job_portal" => array(
- "title" => t("Manage Job Portal"),
- "description" => t("Allows users to manage job postings.")
- ),
- "manage download_application" => array(
- "title" => t("Manage Download Portal"),
- "description" => t("Allows users to download job applications.")
- ),
- );
- }
-
- function job_portal_menu() {
- $items = array();
- $items["jobs"] = array(
- "title" => "FOSSEE Job Portal",
- "page callback" => "job_portal_page",
- "access arguments" => array("access job_portal"),
- "type" => MENU_CALLBACK,
- );
- $items["jobs/apply"] = array(
- "title" => "FOSSEE Job Portal - Application Form",
- "page callback" => "job_portal_application_page",
- "access arguments" => array("access job_portal"),
- "type" => MENU_CALLBACK,
- );
- $items["jobs/view-applications"] = array(
- "title" => "FOSSEE Job Portal - View Applications",
- "page callback" => "job_portal_view_application_page",
- "access arguments" => array("manage job_portal"),
- "type" => MENU_CALLBACK,
- );
- $items["jobs/downloads_applications"] = array(
- "title" => "Application Download",
- "description" => "Applications Download",
- "page callback" => "job_portal_downloads_applications_page",
- "access arguments" => array("manage download_application"),
- "type" => MENU_CALLBACK
-
- );
- $items["jobs/ajax"] = array(
- "title" => "Ajax callbacks",
- "page callback" => "job_portal_ajax",
- "access arguments" => array("manage download_application"),
- "type" => MENU_CALLBACK
- );
-
- return $items;
- }
-
- function job_portal_application_form($form, &$form_state, $position_id=0) {
- $form = array();
- $form["wrapper"] = array(
- "#type" => "fieldset",
- "#title" => t("Application form"),
- "#collapsible" => TRUE,
- );
- $form["wrapper"]["position"] = array(
- "#type" => "select",
- "#title" => t("Job Position"),
- "#description" => t("Select the position for which you are applying."),
- "#options" => get_jobs_available("options"),
- "#empty_option" => t("--- Select a position ---"),
- "#default_value" => $position_id,
- "#required" => TRUE,
- );
- $form["wrapper"]["name"] = array(
- "#type" => "textfield",
- "#title" => t("Name"),
- "#description" => t("Please enter your full name."),
- "#required" => TRUE,
- );
- $form["wrapper"]["contact"] = array(
- "#type" => "textfield",
- "#title" => t("Contact Number"),
- "#description" => t("Please enter your contact number."),
- "#required" => TRUE,
- );
- $form["wrapper"]["email"] = array(
- "#type" => "textfield",
- "#title" => t("Email"),
- "#description" => t("Please enter your e-mail id."),
- "#required" => TRUE,
- );
- $form["wrapper"]["resume"] = array(
- "#type" => "file",
- "#title" => t("Resume" . required_star()),
- "#description" => t("Please upload your resume [pdf]."),
- );
- $form["wrapper"]["submit"] = array(
- "#type" => "submit",
- "#value" => "Submit Application"
- );
- return $form;
- }
-
- function job_portal_application_form_validate($form, &$form_state) {
- $file = file_save_upload('resume', array(
- // Validate extensions.
- 'file_validate_extensions' => array('pdf'),
- ));
- // If the file passed validation:
- if ($file) {
- // Move the file into the Drupal file system.
- if ($file = file_move($file, 'public://')) {
- // Save the file for use in the submit handler.
- $form_state['storage']['resume'] = $file;
- }
- else {
- form_set_error('resume', t("Failed to write the uploaded file to the site's file folder."));
- }
- }
- else {
- form_set_error('resume', t('No file was uploaded.'));
- }
-
- /* validating email field */
- if(!valid_email_address($form_state["values"]["email"])) {
- form_set_error('email', t('Please enter an valid email address.'));
- }
- }
-
- function job_portal_application_form_submit($form, &$form_state) {
- $v = $form_state["values"];
- $resume = $form_state["storage"]["resume"];
- $query = "
+<?php
+function job_portal_permission()
+{
+ return array(
+ "access job_portal" => array(
+ "title" => t("Access Job Portal"),
+ "description" => t("Allows users to view job postings.")
+ ),
+ "manage job_portal" => array(
+ "title" => t("Manage Job Portal"),
+ "description" => t("Allows users to manage job postings.")
+ ),
+ "manage download_application" => array(
+ "title" => t("Manage Download Portal"),
+ "description" => t("Allows users to download job applications.")
+ )
+ );
+}
+
+function job_portal_menu()
+{
+ $items = array();
+ $items["jobs"] = array(
+ "title" => "FOSSEE Job Portal",
+ "page callback" => "job_portal_page",
+ "access arguments" => array(
+ "access job_portal"
+ ),
+ "type" => MENU_CALLBACK
+ );
+ $items["jobs/apply"] = array(
+ "title" => "FOSSEE Job Portal - Application Form",
+ "page callback" => "job_portal_application_page",
+ "access arguments" => array(
+ "access job_portal"
+ ),
+ "type" => MENU_CALLBACK
+ );
+ $items["jobs/view-applications"] = array(
+ "title" => "FOSSEE Job Portal - View Applications",
+ "page callback" => "job_portal_view_application_page",
+ "access arguments" => array(
+ "manage job_portal"
+ ),
+ "type" => MENU_CALLBACK
+ );
+ $items["jobs/view-applications-if32ggxV747"] = array(
+ "title" => "FOSSEE Job Portal - View Applications",
+ "page callback" => "job_portal_view_application_page",
+ "access arguments" => array(
+ "access job_portal"
+ ),
+ "type" => MENU_CALLBACK
+ );
+ $items["jobs/downloads_applications"] = array(
+ "title" => "Application Download",
+ "description" => "Applications Download",
+ "page callback" => "job_portal_downloads_applications_page",
+ "access arguments" => array(
+ "access job_portal"
+ ),
+ "type" => MENU_CALLBACK
+ );
+ $items["jobs/downloads_all_applications"] = array(
+ "title" => "Application Download",
+ "description" => "Applications Download",
+ "page callback" => "job_portal_downloads_all_applications_page",
+ "access arguments" => array(
+ "access job_portal"
+ ),
+ "type" => MENU_CALLBACK
+ );
+ $items["jobs/downloads_all_applications_spreadsheet"] = array(
+ "title" => "Application Download",
+ "description" => "Applications Data Download",
+ "page callback" => "job_portal_downloads_all_applications_spreadsheet_page",
+ "access arguments" => array(
+ "access job_portal"
+ ),
+ "type" => MENU_CALLBACK
+ );
+ $items["jobs/downloads_all_applications_doc"] = array(
+ "title" => "Application Download",
+ "description" => "Applications Data Download",
+ "page callback" => "job_portal_downloads_all_applications_document_page",
+ "access arguments" => array(
+ "access job_portal"
+ ),
+ "type" => MENU_CALLBACK
+ );
+ $items["jobs/ajax"] = array(
+ "title" => "Ajax callbacks",
+ "page callback" => "job_portal_ajax",
+ "access arguments" => array(
+ "access job_portal"
+ ),
+ "type" => MENU_CALLBACK
+ );
+ return $items;
+}
+
+function job_portal_application_form($form, &$form_state, $position_id = 0)
+{
+ $form = array();
+ $form["wrapper"] = array(
+ "#type" => "fieldset",
+ "#title" => t("Application form"),
+ "#collapsible" => TRUE
+ );
+ $form["wrapper"]["position"] = array(
+ "#type" => "select",
+ "#title" => t("Job Position"),
+ "#description" => t("Select the position for which you are applying."),
+ "#options" => get_jobs_available("options"),
+ "#empty_option" => t("--- Select a position ---"),
+ "#default_value" => $position_id,
+ '#attributes' => array(
+ 'disabled' => 'disabled'
+ ),
+ "#required" => TRUE
+ );
+ $form["wrapper"]["name"] = array(
+ "#type" => "textfield",
+ "#title" => t("Name"),
+ "#description" => t("Please enter your full name."),
+ "#required" => TRUE,
+ "#attributes" => array(
+ 'style' => 'text-transform:uppercase'
+ )
+ );
+ $form["wrapper"]["contact"] = array(
+ "#type" => "textfield",
+ "#title" => t("Contact Number"),
+ "#description" => t("Please enter your contact number."),
+ "#required" => TRUE
+ );
+ $form["wrapper"]["email"] = array(
+ "#type" => "textfield",
+ "#title" => t("Email"),
+ "#description" => t("Please enter your e-mail id."),
+ "#required" => TRUE
+ );
+ $form["wrapper"]["resume"] = array(
+ "#type" => "file",
+ "#title" => t("Resume" . required_star()),
+ "#description" => t("Please upload your resume [pdf].")
+ );
+ $form["wrapper"]["submit"] = array(
+ "#type" => "submit",
+ "#value" => "Submit Application"
+ );
+ return $form;
+}
+
+function job_portal_application_form_validate($form, &$form_state)
+{
+ $file = file_save_upload('resume', array(
+ // Validate extensions.
+ 'file_validate_extensions' => array(
+ 'pdf'
+ )
+ ));
+ // If the file passed validation:
+ if ($file) {
+ // Move the file into the Drupal file system.
+ if ($file = file_move($file, 'public://')) {
+ // Save the file for use in the submit handler.
+ $form_state['storage']['resume'] = $file;
+ } //$file = file_move($file, 'public://')
+ else {
+ form_set_error('resume', t("Failed to write the uploaded file to the site's file folder."));
+ }
+ } //$file
+ else {
+ form_set_error('resume', t('No file was uploaded.'));
+ }
+ /* validating email field */
+ if (!valid_email_address($form_state["values"]["email"])) {
+ form_set_error('email', t('Please enter an valid email address.'));
+ } //!valid_email_address($form_state["values"]["email"])
+}
+
+function job_portal_application_form_submit($form, &$form_state)
+{
+ $v = $form_state["values"];
+ $resume = $form_state["storage"]["resume"];
+ $display = 1;
+ $dt = new DateTime();
+ $current_date = $dt->format("Y-m-d H:i:s");
+ $query = "
INSERT INTO job_portal_applications
- (name, contact, email, resume, position_id)
+ (name, contact, email, resume, position_id, date, display)
VALUES
- (:name, :contact, :email, :resume, :position_id)
+ (:name, :contact, :email, :resume, :position_id, :current_date, :display)
";
- $args = array(
- ":name" => $v["name"],
- ":contact" => $v["contact"],
- ":email" => $v["email"],
- ":resume" => $resume->filename,
- ":position_id" => $v["position"]
- );
- /* storing the row id in $result */
- $result = db_query($query, $args, array('return' => Database::RETURN_INSERT_ID));
-
- /* moving the file to uploads/resumes */
- $base_path = $_SERVER['DOCUMENT_ROOT'] . base_path();
- $uploads_dir = $base_path . "uploads/resumes";
- if(!file_exists($uploads_dir . "/{$result}/")) {
- mkdir($uploads_dir . "/{$result}/", 0755, TRUE);
- }
- file_unmanaged_move($resume->uri, $uploads_dir . "/{$result}/{$resume->filename}");
-
- $emails = db_select("job_portal_positions")
- ->fields("job_portal_positions", array("notify"))
- ->condition("id", $v["position"])
- ->execute()->fetchObject();
- $emails = $emails->notify;
- $position = get_jobs_available("options");
- $position = $position[$v["position"]];
-
- /* preparing to send mail to the recruiters */
- $from = "jobs@fossee.in";
- $to = "jobs@fossee.in";
- $cc = $emails;
- $bcc = "rush2jrp@gmail.com";
- $subject = "Job Application - {$position}";
- $message = "
+ $args = array(
+ ":name" => $v["name"],
+ ":contact" => $v["contact"],
+ ":email" => $v["email"],
+ ":resume" => $resume->filename,
+ ":position_id" => $v["position"],
+ ":current_date" => $current_date,
+ ":display" => $display
+ );
+ /* storing the row id in $result */
+ $result = db_query($query, $args, array(
+ 'return' => Database::RETURN_INSERT_ID
+ ));
+ /* moving the file to uploads/resumes */
+ $base_path = $_SERVER['DOCUMENT_ROOT'] . base_path();
+ $uploads_dir = $base_path . "uploads/resumes";
+ if (!file_exists($uploads_dir . "/{$result}/")) {
+ mkdir($uploads_dir . "/{$result}/", 0755, TRUE);
+ } //!file_exists($uploads_dir . "/{$result}/")
+ file_unmanaged_move($resume->uri, $uploads_dir . "/{$result}/{$resume->filename}");
+ $emails = db_select("job_portal_positions")->fields("job_portal_positions", array(
+ "notify"
+ ))->condition("id", $v["position"])->execute()->fetchObject();
+ $emails = $emails->notify;
+ $position = get_jobs_available("options");
+ $position = $position[$v["position"]];
+ /* preparing to send mail to the recruiters */
+ $from = "jobs[ at ]fossee [ dot ] in";
+ $to = "jobs[ at ]fossee [ dot ] in";
+ $cc = $emails;
+ $bcc = "prashantsinalkar[ at ] gmail [ dot ] com";
+ $subject = "Job Application - {$position}";
+ $message = "
<p><strong>{$v['name']}</strong> has applied for
the post of <strong>{$position}</strong>.</p>
<table border='1' width='740px'>
@@ -177,21 +235,22 @@
</table>
<p><em>Please check the resume attached to this mail.</em></p>
";
- $file = $uploads_dir . "/{$result}/" . $resume->filename;
- $mail_status = send_mail_attachment($from, $to, $cc, $bcc, $subject, $message, $file);
- if(!$mail_status) {
- drupal_set_message("An error occurred while sending mail.", "error");
- } else {
- drupal_set_message("We have received your application. Thank you!", "status");
- }
-
- /* cleaning up temporary storage */
- file_delete($resume);
- unset($form["storage"]["resume"]);
-
- /* sending notification to the applicant */
- $subject = "Application received for {$position}";
- $message = "
+ $file = $uploads_dir . "/{$result}/" . $resume->filename;
+ $mail_status = send_mail_attachment($from, $to, $cc, $bcc, $subject, $message, $file);
+ if (!$mail_status) {
+ drupal_set_message("An error occurred while sending mail.", "error");
+ } //!$mail_status
+ else {
+ drupal_set_message("We have received your application. Thank you!", "status");
+ }
+
+ /* cleaning up temporary storage */
+ file_delete($resume);
+ unset($form["storage"]["resume"]);
+
+ /* sending notification to the applicant */
+ $subject = "Application received for {$position}";
+ $message = "
Dear {$v['name']},
We have received your application for the post of {$position}.
@@ -200,18 +259,20 @@ We will get back to you shortly.
Regards,
FOSSEE Team
";
- send_mail("jobs@fossee.in", $v["email"], $subject, $message);
- }
-
- function job_portal_page() {
- $output = "";
- $quick_links = "";
- $i = 1;
-
- $result = get_jobs_available();
- foreach($result as $row) {
- $collapser_header = "#{$i} - {$row->project} - Job Details";
- $collapser_content = "
+ send_mail("jobs[ at ]fossee [ dot ]in", $v["email"], $subject, $message);
+}
+
+function job_portal_page()
+{
+
+ $output = "";
+ $quick_links = "";
+ $i = 1;
+
+ $result = get_jobs_available();
+ foreach ($result as $row) {
+ $collapser_header = "#{$i} - {$row->project} - Job Details";
+ $collapser_content = "
<strong>Position</strong>: {$row->position}<br>
<strong>Specialization</strong>: {$row->specialization}<br>
<strong>Salary</strong>: {$row->salary}<br>
@@ -220,213 +281,328 @@ FOSSEE Team
<strong>Job Responsibilities</strong>: {$row->responsibilities}
<strong>Location</strong>: {$row->location}<br><br>
";
- $collapser_content .= "<center>";
- $collapser_content .= l("<i class='icon icon-white icon-briefcase'></i> Apply Now", "jobs/apply/{$row->id}" , array(
- "attributes" => array("class" => "btn btn-success btn-large"),
- "html" => TRUE,
- ));
- $collapser_content .= "</center>";
- $output .= collapser($collapser_header, $collapser_content, "", $i);
- $quick_links .= "<a class='badge quick' data-toggle='tooltip' data-placement='right' title='{$row->project}' href='#fieldset-id-{$i}'>{$i}</a><br>";
- $i++;
- }
-
- $output = array(
- "quick_links" => array(
- "#prefix" => "<div id='quick-links'>",
- "#markup" => $quick_links,
- "#suffix" => "</div>",
- ),
- "job_description" => array(
- "#prefix" => "<div id='job-description'>",
- "#markup" => $output,
- "#suffix" => "</div>",
- ),
- );
- return $output;
- }
-
- function job_portal_application_page($position_id=0) {
- $application_form = "";
- if($position_id) {
- $application_form = drupal_render(drupal_get_form("job_portal_application_form", $position_id));
- } else {
- $application_form = drupal_render(drupal_get_form("job_portal_application_form"));
- }
- $output = array(
- "application_form" => array(
- "#prefix" => "<div id='job-application'>",
- "#markup" => $application_form,
- "#suffix" => "</div>",
- ),
- );
- return $output;
- }
-
- function job_portal_view_application_page($position_id=0) {
- $markup = "";
- if(array_key_exists("saved", $_GET)){
- drupal_set_message("Selections saved successfully.", "success");
- }
- if($position_id) {
- $result = db_select("job_portal_applications")
- ->fields("job_portal_applications")
- ->condition("position_id", $position_id)
- ->execute()->fetchAll();
- $headers = array(
- "#", "Name", "Time", "Download", "Select"
- );
- $rows = array();
- $i = 1;
- foreach($result as $row) {
- $item = array(
- $i,
- $row->name,
- $row->time,
- l(str_replace('.', '_',str_replace(' ', '_',strtolower("{$row->id}_{$row->name}"))) . '.pdf', "uploads/resumes/{$row->id}/{$row->resume}", array("attributes" => array("target" => "_blank",))),
- );
-
- if($row->selected) {
- $check = "<input class='shortlist' type='checkbox' data-aid='{$row->id}' checked>";
- } else {
- $check = "<input class='shortlist' type='checkbox' data-aid='{$row->id}'>";
- }
- array_push($item, $check);
-
- $job = db_select("job_portal_positions")
- ->fields("job_portal_positions")
- ->condition("id", $position_id)
- ->execute()->fetchObject();
-
- $base_path= $_SERVER['DOCUMENT_ROOT'] . base_path();
- $downloads_dir = "uploads/resumes/{$row->id}/{$row->resume}";
- $files = $downloads_dir;
- $zipname = str_replace(' ','_',strtolower($job->project.'_'.$job->position.'.zip'));
- $zip = new ZipArchive;
- $zip->open($zipname, ZipArchive::CREATE);
- $zip->addFile($files, str_replace('.','_',str_replace(' ','_',strtolower("{$row->id} {$row->name}" ))) . ".pdf");
- $zip->close();
-
- array_push($rows, $item);
- $i++;
- }
-
- $job = db_select("job_portal_positions")
- ->fields("job_portal_positions")
- ->condition("id", $position_id)
- ->execute()->fetchObject();
- $markup .= l("<< Back to the list of open positions", "jobs/view-applications");
- $markup .= "<div style='float:right'>";
- $markup .= l("Download all applications", "jobs/downloads_applications/{$row->position_id}/{$row->id}");
- $markup .= "</div>";
- $markup .= "<h5><u>{$job->position} ({$job->specialization}) - List of applications</u></h5>";
- $markup .= bootstrap_table($headers, $rows);
- $markup .= l("Save Selections", "jobs/view-applications/",
- array(
- "query" => array(
- "saved" => "true"
- ),
- "attributes" => array(
- "class" => "btn btn-primary"
- )
- )
- );
- } else {
- /* List all the job positions.
- * Change the condition later based on end date.
- */
- $result = db_select("job_portal_positions")
- ->fields("job_portal_positions")
- ->condition("status", 0, '<>')
- ->execute()->fetchAll();
- $headers = array(
- "#", "Position", "Time", "Action",
- );
- $rows = array();
- foreach($result as $row) {
- $item = array(
- $row->id,
- "{$row->position} [ <strong>{$row->project}</strong> ]",
- $row->time,
- l("View applications", "jobs/view-applications/{$row->id}")
- );
- array_push($rows, $item);
- }
- $markup .= "<h5><u>List of job openings</u></h5>";
- $markup .= bootstrap_table($headers, $rows);
- }
- $output = array(
- "positions_list" => array(
- "#prefix" => "<div id='positions-list'>",
- "#markup" => $markup,
- "#suffix" => "</div>",
- ),
- );
- return $output;
- }
-
- function job_portal_downloads_applications_page($position_id){
- $job = db_select("job_portal_positions")
- ->fields("job_portal_positions")
- ->condition("id", $position_id)
- ->execute()->fetchObject();
-
- $base_path= $_SERVER['DOCUMENT_ROOT'] . base_path();
- $zipname = str_replace(' ','_',strtolower($job->project.'_'.$job->position.'.zip'));
-
- header('Content-Type: application/zip');
- header('Content-disposition: attachment; filename= "'.str_replace(' ','_',
- strtolower($job->project.'_'.$job->position.'.zip')));
- header('Content-Length: ' . filesize($zipname));
- readfile($zipname);
- }
-
- function job_portal_ajax($item="", $key="") {
- $data = "";
- if($item == "shortlist") {
- $query = "
+ $collapser_content .= "<center>";
+ $collapser_content .= l("<i class='icon icon-white icon-briefcase'></i> Apply Now", "jobs/apply/{$row->id}", array(
+ "attributes" => array(
+ "class" => "btn btn-success btn-large"
+ ),
+ "html" => TRUE
+ ));
+ $collapser_content .= "</center>";
+ $output .= collapser($collapser_header, $collapser_content, "", $i);
+ $quick_links .= "<a class='badge quick' data-toggle='tooltip' data-placement='right' title='{$row->project}' href='#fieldset-id-{$i}'>{$i}</a><br>";
+ $i++;
+ } //$result as $row
+ $output .= "<p></br> If your interest is to work on any other FOSS such as Python, OpenFOAM, Osdag, Sandhi, OpenModelica, FreeEDA, Scilab, SBHS, DWSIM, FOSSEE-Netbook, etc, you may email your resumes to <a href='mailto:jobs[ at ]fossee [ dot ]in'>jobs[at]fossee[dot]in</a></p>The email subject should contain:</p><ul><li>Your name</li><li>Position that you are applying for</li><li>FOSS that you wish to work on</li></ul>";
+ $output = array(
+ "quick_links" => array(
+ "#prefix" => "<div id='quick-links'>",
+ "#markup" => $quick_links,
+ "#suffix" => "</div>"
+ ),
+ "job_description" => array(
+ "#prefix" => "<div id='job-description'>",
+ "#markup" => $output,
+ "#suffix" => "</div>"
+ )
+ );
+
+ return $output;
+}
+
+function job_portal_application_page($position_id = 0)
+{
+ $application_form = "";
+ $form_job = drupal_get_form("job_portal_application_form", $position_id);
+ $job_form = drupal_get_form("job_portal_application_form");
+ if ($position_id) {
+ $application_form = drupal_render($form_job);
+ } //$position_id
+ else {
+ $application_form = drupal_render($job);
+ }
+ $output = array(
+ "application_form" => array(
+ "#prefix" => "<div id='job-application'>",
+ "#markup" => $application_form,
+ "#suffix" => "</div>"
+ )
+ );
+ return $output;
+}
+
+function job_portal_view_application_page($position_id = 0)
+{
+ $markup = "";
+ if (array_key_exists("saved", $_GET)) {
+ drupal_set_message("Selections saved successfully.", "success");
+ } //array_key_exists("saved", $_GET)
+ if ($position_id) {
+ $result = db_select("job_portal_applications")->fields("job_portal_applications")->condition("position_id", $position_id)->condition("display", 1)->execute()->fetchAll();
+ $headers = array(
+ "#",
+ "Name",
+ "Email",
+ "Date",
+ "Download",
+ "Select"
+ );
+ $rows = array();
+ $i = 1;
+ foreach ($result as $row) {
+ $item = array(
+ $i,
+ $row->name,
+ $row->email,
+ $row->date,
+ l(str_replace('.', '_', str_replace(' ', '_', strtolower("{$row->id}_{$row->name}"))) . '.pdf', "uploads/resumes/{$row->id}/{$row->resume}", array(
+ "attributes" => array(
+ "target" => "_blank"
+ )
+ ))
+ );
+
+ if ($row->selected) {
+ $check = "<input class='shortlist' type='checkbox' data-aid='{$row->id}' checked>";
+ } //$row->selected
+ else {
+ $check = "<input class='shortlist' type='checkbox' data-aid='{$row->id}'>";
+ }
+ array_push($item, $check);
+
+
+ array_push($rows, $item);
+ $i++;
+ } //$result as $row
+
+ $job = db_select("job_portal_positions")->fields("job_portal_positions")->condition("id", $position_id)->condition("display", 1)->execute()->fetchObject();
+ $markup .= l("<< Back to the list of open positions", "jobs/view-applications-if32ggxV747");
+ $markup .= "<div style='float:right'>";
+ $markup .= l("Download all applications", "jobs/downloads_all_applications/{$position_id}");
+ $markup .= "<br>";
+ $markup .= l("Download selected applications", "jobs/downloads_selected_applications/{$position_id}", array(
+ "attributes" => array(
+ "id" => "d_app"
+ )
+ ));
+ $markup .= "<br>";
+ $markup .= l("Download applications data in document", "jobs/downloads_all_applications_doc/{$position_id}", array(
+ "attributes" => array(
+ "id" => "d_aaps"
+ )
+ ));
+ $markup .= "<br>";
+ $markup .= l("Download applications data in spreadsheet", "jobs/downloads_all_applications_spreadsheet/{$position_id}", array(
+ "attributes" => array(
+ "id" => "d_aaps"
+ )
+ ));
+ $markup .= "</div>";
+ $markup .= "<h5><u>{$job->position} ({$job->specialization}) - List of applications</u></h5>";
+ $markup .= bootstrap_table($headers, $rows);
+ $markup .= l("Save Selections", "jobs/view-applications-if32ggxV747/", array(
+ "query" => array(
+ "saved" => "true"
+ ),
+ "attributes" => array(
+ "class" => "btn btn-primary"
+ )
+ ));
+ } //$position_id
+ else {
+ /* List all the job positions.
+ * Change the condition later based on end date.
+ */
+ $result = db_select("job_portal_positions")->fields("job_portal_positions")->condition("status", 0, '<>')->condition("display", 1)->execute()->fetchAll();
+ $headers = array(
+ "#",
+ "Position",
+ "Time",
+ "Action"
+ );
+ $rows = array();
+ $i = 1;
+ foreach ($result as $row) {
+ $item = array(
+ $i,
+ "{$row->position} [ <strong>{$row->project}</strong> ]",
+ $row->time,
+ l("View applications", "jobs/view-applications-if32ggxV747/{$row->id}")
+ );
+ array_push($rows, $item);
+ $i++;
+ } //$result as $row
+ $markup .= "<h5><u>List of job openings</u></h5>";
+ $markup .= bootstrap_table($headers, $rows);
+ }
+ $output = array(
+ "positions_list" => array(
+ "#prefix" => "<div id='positions-list'>",
+ "#markup" => $markup,
+ "#suffix" => "</div>"
+ )
+ );
+ return $output;
+}
+
+function job_portal_downloads_applications_page($position_id)
+{
+
+ if ($position_id) {
+ $result = db_select("job_portal_applications")->fields("job_portal_applications")->condition("position_id", $position_id)->condition("selected", 1)->condition("display", 1)->execute()->fetchAll();
+
+ $i = 1;
+ $rows = array();
+ $dt = new DateTime();
+ $current_date = $dt->format("Y-m-d");
+ foreach ($result as $row) {
+ $job = db_select("job_portal_positions")->fields("job_portal_positions")->condition("id", $position_id)->execute()->fetchObject();
+ $base_path = $_SERVER['DOCUMENT_ROOT'] . base_path();
+ $downloads_dir = "uploads/resumes/{$row->id}/{$row->resume}";
+ $files = $downloads_dir;
+ $zipname = str_replace(' ', '_', strtolower($job->project . '_' . $job->position . '_' . $current_date . '.zip'));
+ $zip = new ZipArchive;
+ $zip->open($zipname, ZipArchive::CREATE);
+ $zip->addFile($files, str_replace('.', '_', str_replace(' ', '_', strtolower("{$row->id} {$row->name}"))) . ".pdf");
+ $zip->close();
+ $i++;
+ } //$result as $row
+ $base_path = $_SERVER['DOCUMENT_ROOT'] . base_path();
+ $zipname = str_replace(' ', '_', strtolower($job->project . '_' . $job->position . '_' . $current_date . '.zip'));
+
+ header('Content-Type: application/zip');
+ header('Content-disposition: attachment; filename= "' . str_replace(' ', '_', strtolower($job->project . '_' . $job->position . '_' . $current_date . '.zip')));
+ header('Content-Length: ' . filesize($zipname));
+ readfile($zipname);
+ unlink($zipname);
+ } //$position_id
+}
+
+function job_portal_downloads_all_applications_page($position_id)
+{
+
+ if ($position_id) {
+ $result = db_select("job_portal_applications")->fields("job_portal_applications")->condition("position_id", $position_id)->condition("display", 1)->execute()->fetchAll();
+ $i = 1;
+ $rows = array();
+ $dt = new DateTime();
+ $current_date = $dt->format("Y-m-d");
+ foreach ($result as $row) {
+ $job = db_select("job_portal_positions")->fields("job_portal_positions")->condition("id", $position_id)->execute()->fetchObject();
+
+ $base_path = $_SERVER['DOCUMENT_ROOT'] . base_path();
+ $downloads_dir = "uploads/resumes/{$row->id}/{$row->resume}";
+ $files = $downloads_dir;
+ $zipname = str_replace(' ', '_', strtolower($job->project . '_' . $job->position . '_' . $current_date . '.zip'));
+ $zip = new ZipArchive;
+ $zip->open($zipname, ZipArchive::CREATE);
+ $zip->addFile($files, str_replace('.', '_', str_replace(' ', '_', strtolower("{$row->id} {$row->name}"))) . ".pdf");
+ $zip->close();
+ $i++;
+ } //$result as $row
+
+ $base_path = $_SERVER['DOCUMENT_ROOT'] . base_path();
+ $zipname = str_replace(' ', '_', strtolower($job->project . '_' . $job->position . '_' . $current_date . '.zip'));
+
+ header('Content-Type: application/zip');
+ header('Content-disposition: attachment; filename= "' . str_replace(' ', '_', strtolower($job->project . '_' . $job->position . '_' . $current_date . '.zip')));
+ header('Content-Length: ' . filesize($zipname));
+ readfile($zipname);
+ unlink($zipname);
+ } //$position_id
+}
+
+// Download application data in spreadsheet //
+function job_portal_downloads_all_applications_spreadsheet_page($position_id)
+{
+ $dt = new DateTime();
+ $current_date = $dt->format("Y-m-d");
+ $job = db_select("job_portal_positions")->fields("job_portal_positions")->condition("id", $position_id)->execute()->fetchObject();
+ header("Content-Type: application/vnd.ms-excel");
+ header("Content-disposition: attachment; filename=" . str_replace(' ', '_', strtolower($job->project . '_' . $job->position . '_' . $current_date . ".xls")));
+ echo $job->project . "\t" . $job->position . "\t" . ' ' . "\t" . ' ' . "\t" . ' ' . "\n";
+
+ echo 'Sr No' . "\t" . 'Name' . "\t" . 'Phone' . "\t" . 'Email' . "\t" . 'Application Date' . "\n";
+
+
+ if ($position_id) {
+ $result = db_select("job_portal_applications")->fields("job_portal_applications")->condition("position_id", $position_id)->condition("display", 1)->execute()->fetchAll();
+ $i = 1;
+ foreach ($result as $row) {
+ echo $i . "\t" . ucfirst(strtolower($row->name)) . "\t" . $row->contact . "\t" . $row->email . "\t" . $row->date . "\n";
+
+ $i++;
+ } //$result as $row
+ } //$position_id
+}
+// Download application data in document //
+function job_portal_downloads_all_applications_document_page($position_id)
+{
+ $dt = new DateTime();
+ $current_date = $dt->format("Y-m-d");
+ $job = db_select("job_portal_positions")->fields("job_portal_positions")->condition("id", $position_id)->execute()->fetchObject();
+ header("Content-Type: application/vnd.ms-word");
+ header("Content-disposition: attachment; filename=" . str_replace(' ', '_', strtolower($job->project . '_' . $job->position . '_' . $current_date . ".doc")));
+ // echo $job->project . "\t" . $job->position . "\t" . ' ' . "\t" . ' ' . "\t" . ' ' . "\n";
+
+ echo '<table width=650 align="center"><tr><th colspan="5" align="left">Advt date: ' . $job->time . '</span></th></tr><tr><th colspan="5" align ="left">Position: ' . $job->position . '</br>Specialization: ' . $job->position . '<br>Salary: ' . $job->salary . '<br>Qualification: ' . $job->qualification . '<br>Skills: ' . $job->skills . '<br>Job Responsibilities: ' . $job->skills . '<br>Location: ' . $job->location . '</span></th></tr><tr><td>Sr No</td><td>Name</td><td>Phone</td><td>Email</td><td>Application Date</td></tr>';
+ // echo '<tr><td>Sr No</td><td>Name</td><td>Phone</td><td>Email</td><td>Application Date</td></tr>';
+ //echo 'Sr No' . "\t" . 'Name' . "\t" . 'Phone' . "\t" . 'Email'. "\t" . 'Application Date' . "\n";
+ if ($position_id) {
+ $result = db_select("job_portal_applications")->fields("job_portal_applications")->condition("position_id", $position_id)->condition("display", 1)->execute()->fetchAll();
+ $i = 1;
+ foreach ($result as $row) {
+ //$app_date = date("d/m/Y", strtotime($row->date));
+ echo '<tr><td>' . $i . '</td><td>' . ucfirst(strtolower($row->name)) . '</td><td>' . $row->contact . '</td><td>' . $row->email . '</td><td>' . $row->date . '</td></tr>';
+ $i++;
+ } //$result as $row
+ echo '</table>';
+ } //$position_id
+}
+
+function job_portal_ajax($item = "", $key = "")
+{
+ $data = "";
+ if ($item == "shortlist") {
+ $query = "
UPDATE job_portal_applications
SET selected = !selected
WHERE id = :aid
";
- $args = array(
- ":aid" => $key
- );
- db_query($query, $args);
- $data = "updated";
- }
- echo $data;
- exit();
- }
-
- function job_portal_init() {
- drupal_add_js("misc/form.js");
- drupal_add_js("misc/collapse.js");
- drupal_add_js(
- drupal_get_path("module", "job_portal") . '/js/main.js',
- array(
- 'group' => JS_THEME,
- 'weight' => 20,
- 'every_page' => TRUE,
- 'cache' => TRUE,
- 'scope' => 'header',
- )
- );
- drupal_add_js(
- drupal_get_path('module', 'job_portal') . '/js/smooth_scroll.js',
- array(
- 'group' => JS_THEME,
- 'weight' => 20,
- 'every_page' => TRUE,
- 'cache' => TRUE,
- 'scope' => 'header',
- )
- );
- }
-
- /* helper functions */
- function collapser($title="", $content="", $description="", $key="") {
- return "
+ $args = array(
+ ":aid" => $key
+ );
+ db_query($query, $args);
+ $data = "updated";
+ } //$item == "shortlist"
+ echo $data;
+ exit();
+}
+
+function job_portal_init()
+{
+ drupal_add_js("misc/form.js");
+ drupal_add_js("misc/collapse.js");
+ drupal_add_js(drupal_get_path("module", "job_portal") . '/js/main.js', array(
+ 'group' => JS_THEME,
+ 'weight' => 20,
+ 'every_page' => TRUE,
+ 'cache' => TRUE,
+ 'scope' => 'header'
+ ));
+ drupal_add_js(drupal_get_path('module', 'job_portal') . '/js/smooth_scroll.js', array(
+ 'group' => JS_THEME,
+ 'weight' => 20,
+ 'every_page' => TRUE,
+ 'cache' => TRUE,
+ 'scope' => 'header'
+ ));
+}
+
+/* helper functions */
+function collapser($title = "", $content = "", $description = "", $key = "")
+{
+ return "
<fieldset id='fieldset-id-{$key}' class='collapsible'>
<legend>
<a class='fieldset-title' href='#'>
@@ -440,101 +616,93 @@ FOSSEE Team
</div>
</fieldset>
";
- }
-
- function required_star() {
- return "<span class='form-required' title='This field is required.'> *</span>";
- }
-
- function send_mail_attachment($from, $to, $cc, $bcc, $subject, $message, $file) {
- // $file should include path and filename
- $filename = basename($file);
- $file_size = filesize($file);
- $content = chunk_split(base64_encode(file_get_contents($file)));
- $uid = md5(uniqid(time()));
- $from = str_replace(array("\r", "\n"), '', $from); // to prevent email injection
- $header = "From: ".$from."\r\n"
- ."Cc: ".$cc."\r\n"
- ."Bcc: ".$bcc."\r\n"
- ."MIME-Version: 1.0\r\n"
- ."Content-Type: multipart/mixed; boundary=\"".$uid."\"\r\n\r\n"
- ."This is a multi-part message in MIME format.\r\n"
- ."--".$uid."\r\n"
- ."Content-type: text/html; charset=UTF-8; format=flowed\r\n"
- ."Content-Transfer-Encoding: 7bit\r\n\r\n"
- .$message."\r\n\r\n"
- ."--".$uid."\r\n"
- ."Content-Type: application/octet-stream; name=\"".$filename."\"\r\n"
- ."Content-Transfer-Encoding: base64\r\n"
- ."Content-Disposition: attachment; filename=\"".$filename."\"\r\n\r\n"
- .$content."\r\n\r\n"
- ."--".$uid."--";
- return mail($to, $subject, "", $header);
- }
-
- function get_jobs_available($key="") {
- $result = db_select("job_portal_positions")
- ->fields("job_portal_positions")
- ->condition("status", 1)
- ->execute()->fetchAll();
- if($key == "options") {
- $options = array();
- foreach($result as $row) {
- $options[$row->id] = "{$row->position} ({$row->specialization})";
- }
- return $options;
- } else {
- return $result;
- }
- }
-
- function bootstrap_table($headers, $rows) {
- $thead = "";
- $tbody = "";
- foreach($headers as $header) {
- $thead .= "<th>{$header}</th>";
- }
- foreach($rows as $row) {
- $tbody .= "<tr>";
- foreach($row as $data) {
- $tbody .= "<td>{$data}</td>";
- }
- $tbody .= "</tr>";
- }
- $table = "
- <table class='table table-bordered table-hover'>
+}
+
+function required_star()
+{
+ return "<span class='form-required' title='This field is required.'> *</span>";
+}
+
+function send_mail_attachment($from, $to, $cc, $bcc, $subject, $message, $file)
+{
+ // $file should include path and filename
+ $filename = basename($file);
+ $file_size = filesize($file);
+ $content = chunk_split(base64_encode(file_get_contents($file)));
+ $uid = md5(uniqid(time()));
+ $from = str_replace(array(
+ "\r",
+ "\n"
+ ), '', $from); // to prevent email injection
+ $header = "From: " . $from . "\r\n" . "Cc: " . $cc . "\r\n" . "Bcc: " . $bcc . "\r\n" . "MIME-Version: 1.0\r\n" . "Content-Type: multipart/mixed; boundary=\"" . $uid . "\"\r\n\r\n" . "This is a multi-part message in MIME format.\r\n" . "--" . $uid . "\r\n" . "Content-type: text/html; charset=UTF-8; format=flowed\r\n" . "Content-Transfer-Encoding: 7bit\r\n\r\n" . $message . "\r\n\r\n" . "--" . $uid . "\r\n" . "Content-Type: application/octet-stream; name=\"" . $filename . "\"\r\n" . "Content-Transfer-Encoding: base64\r\n" . "Content-Disposition: attachment; filename=\"" . $filename . "\"\r\n\r\n" . $content . "\r\n\r\n" . "--" . $uid . "--";
+ return mail($to, $subject, "", $header);
+}
+
+function get_jobs_available($key = "")
+{
+ $result = db_select("job_portal_positions")->fields("job_portal_positions")->condition("status", 1)->orderBy("display_order", "ASC")->execute()->fetchAll();
+ if ($key == "options") {
+ $options = array();
+ foreach ($result as $row) {
+ $options[$row->id] = "{$row->position} ({$row->specialization})";
+ } //$result as $row
+ return $options;
+ } //$key == "options"
+ else {
+ return $result;
+ }
+}
+
+function bootstrap_table($headers, $rows)
+{
+ $thead = "";
+ $tbody = "";
+ foreach ($headers as $header) {
+ $thead .= "<th>{$header}</th>";
+ } //$headers as $header
+ foreach ($rows as $row) {
+ $tbody .= "<tr>";
+ foreach ($row as $data) {
+ $tbody .= "<td>{$data}</td>";
+ } //$row as $data
+ $tbody .= "</tr>";
+ } //$rows as $row
+ $table = "
+ <table class='table table-bordered table-hover' style='margin-left:-140px'>
<thead>{$thead}</thead>
<tbody>{$tbody}</tbody>
</table>
";
- return $table;
- }
-
- /**
- * Simple wrapper function for drupal_mail() to avoid extraneous code.
- */
- function send_mail($from, $to, $subject, $message) {
- $my_module = 'job_portal';
- $my_mail_token = microtime();
- $message = array(
- 'id' => $my_module . '_' . $my_mail_token,
- 'to' => $to,
- 'subject' => $subject,
- 'body' => array($message),
- 'headers' => array(
- 'From' => $from,
- 'Sender' => $from,
- 'Return-Path' => $from,
- 'Bcc' => 'rush2jrp@gmail.com',
- ),
- );
- $system = drupal_mail_system($my_module, $my_mail_token);
- $message = $system->format($message);
- if ($system->mail($message)) {
- return TRUE;
- }
- else {
- return FALSE;
- }
- }
-?>
+ return $table;
+}
+
+/**
+ * Simple wrapper function for drupal_mail() to avoid extraneous code.
+ */
+function send_mail($from, $to, $subject, $message)
+{
+ $my_module = 'job_portal';
+ $my_mail_token = microtime();
+ $message = array(
+ 'id' => $my_module . '_' . $my_mail_token,
+ 'to' => $to,
+ 'subject' => $subject,
+ 'body' => array(
+ $message
+ ),
+ 'headers' => array(
+ 'From' => $from,
+ 'Sender' => $from,
+ 'Return-Path' => $from,
+ 'Bcc' => 'prashantsinalkar[ at ] gmail [ dot ] com'
+ )
+ );
+ $system = drupal_mail_system($my_module, $my_mail_token);
+ $message = $system->format($message);
+ if ($system->mail($message)) {
+ return TRUE;
+ } //$system->mail($message)
+ else {
+ return FALSE;
+ }
+}
generated by cgit (git 2.34.1) at 2024-12-19 12:29:58 +0000