/recruitment/apply/print_functions.php
PHP | 209 lines | 153 code | 40 blank | 16 comment | 10 complexity | a943a838d816b6d0ef29a4b25e5e0de4 MD5 | raw file
Possible License(s): LGPL-2.1
- <?php
- require_once('../helper_functions.php');
- require_once('../../lib/database.php');
- openConnection();
-
- function get_job_details($app_cv_id){
- $q = "SELECT c.advertresponseid, c.titleid, c.surname, c.firstname, c.othernames, c.gender, c.maritalstatus, c.physicalchallenge, c.birthdate, ";
- $q .= "c.birthplace, c.hometown, c.lga, c.state, c.nationality, c.personnelid, c.profile_pic, c.highestqualification, c.degreeclass, c.yearobtained, ";
- $q .= "c.institutionobtained, c.fieldofstudy, c.degreeclass, c.mainphone, c.otherphone, c.alternateemail, c.contactaddress, c.permanenthomeaddress, ";
- $q .= "r.advertid, r.responsedate, r.responsetime, r.datecompleted, r.timecompleted, r.applicantcomments, r.applicationstatus, v.vacancyid, v.rankid, ";
- $q .= "v.departmentid, v.jobschedule, v.jobshifts, v.jobhours, v.educationrequirements, v.experiencerequirements, v.additional_requirements, ";
- $q .= "rnk.name as position, d.name as department FROM tblapplicantscvs AS c ";
- $q .= "INNER JOIN tbladvertresponses AS r ON c.advertresponseid = r.responseid ";
- $q .= "INNER JOIN tbladvertisements AS ads ON r.advertid = ads.advertisementid ";
- $q .= "INNER JOIN tblvacancies AS v ON ads.vacancyid = v.vacancyid ";
- $q .= "INNER JOIN tblrank AS rnk ON v.rankid = rnk.rankid ";
- $q .= "INNER JOIN tbldepartment AS d ON v.departmentid = d.departmentid ";
- $q .= "WHERE c.rowid = $app_cv_id";
-
- $query = mysql_query($q);
- $foundRecord = mysql_num_rows($query);
-
- $returnVal = '<table border="1px" style="border-collapse: collapse; width:100%; margin-top:10px" cellpadding="5px" cellspacing="10px">';
- if ($foundRecord == 1) {
- $row = mysql_fetch_assoc($query);
-
- $returnVal .= '<tr style="border: solid 1px #999999;background-color:#dddddd;font-size:18px"><td colspan="2"><strong>JOB APPLICATION DETAILS</strong></td></tr>';
-
- $returnVal .= '<tr><td style="width:25%"><strong>Job Title / Position:</strong></td><td>' . $row['position'] . '</td></tr>';
- $returnVal .= '<tr><td><strong>Department / Division:</strong></td><td>' . $row['department'] . '</td></tr>';
- $returnVal .= '<tr><td><strong>Qualification Required:</strong></td><td>' . $row['educationrequirements'] . '</td></tr>';
- $returnVal .= '<tr><td><strong>Experience Required:</strong></td><td>' . $row['experiencerequirements'] . '</td></tr>';
- $returnVal .= '<tr><td><strong>Job Schedule:</strong></td><td>' . $row['jobschedule'] . '</td></tr>';
- $returnVal .= '<tr><td><strong>Job Shifts:</strong></td><td>' . $row['jobshifts'] . '</td></tr>';
- $returnVal .= '<tr><td><strong>Job Hours:</strong></td><td>' . $row['jobhours'] . '</td></tr>';
- $returnVal .= '<tr><td><strong>Date & Time Submitted:</strong></td><td>' . get_my_date_format($row['datecompleted'], 'M') . ' @' . $row['timecompleted'] . '</td></tr>';
- $returnVal .= '<tr><td><strong>Applicant’s Comments:</strong></td><td>' . $row['applicantcomments'] . '</td></tr></table>';
-
- $returnVal .= '<br /><h2 style="text-align: center;">APPLICANT’S CV AS AT TIME OF APPLICATION</h2>';
- $returnVal .= '<table><tr style="border: solid 1px #999999;background-color:#dddddd;font-size:18px"><td colspan="2"><strong>1: BIODATA</strong></td></tr>';
-
- $returnVal .= '<tr><td style="width:30%"><strong>Gender:</strong></td><td>' . $row['gender'] . '</td></tr>';
- $returnVal .= '<tr><td><strong>Marital Status:</strong></td><td>' . $row['maritalstatus'] . '</td></tr>';
- $returnVal .= '<tr><td><strong>Date of Birth:</strong></td><td>' . get_my_date_format($row['birthdate'], 'L') . ' <i>(' . get_full_age_from_date($row['birthdate'], 'Full Details') . ')</i></td></tr>';
- $returnVal .= '<tr><td><strong>Place of Birth:</strong></td><td>' . $row['birthplace'] . '</td></tr>';
- $returnVal .= '<tr><td><strong>Home Town:</strong></td><td>' . $row['hometown'] . '</td></tr>';
- $returnVal .= '<tr><td><strong>Local Government Area:</strong></td><td>' . $row['lga'] . '</td></tr>';
- $returnVal .= '<tr><td><strong>State of Origin:</strong></td><td>' . $row['state'] . '</td></tr>';
- $returnVal .= '<tr><td><strong>Country of Origin:</strong></td><td>' . $row['nationality'] . '</td></tr>';
- $returnVal .= '<tr><td><strong>Physical Challenge:</strong></td><td>' . $row['physicalchallenge'] . '</td></tr></table>';
-
- $returnVal .= '<table><tr style="border: solid 1px #999999;background-color:#dddddd;font-size:18px"><td colspan="2"><strong>2: CONTACT DETAILS</strong></td></tr>';
- $returnVal .= '<tr><td style="width:30%"><strong>Primary E-Mail:</strong></td><td>' . '' . '</td></tr>';
- $returnVal .= '<tr><td><strong>Primary GSM Number:</strong></td><td>' . $row['mainphone'] . '</td></tr>';
- $returnVal .= '<tr><td><strong>Alternative E-Mail:</strong></td><td>' . $row['alternateemail'] . '</td></tr>';
- $returnVal .= '<tr><td><strong>Alternative GSM Number:</strong></td><td>' . $row['otherphone'] . '</td></tr>';
- $returnVal .= '<tr><td><strong>Current Contact Address:</strong></td><td>' . $row['contactaddress'] . '</td></tr>';
- $returnVal .= '<tr><td><strong>Permanent Home Address:</strong></td><td>' . $row['permanenthomeaddress'] . '</td></tr></table>';
-
- $returnVal .= '<table><tr style="border: solid 1px #999999;background-color:#dddddd;font-size:18px"><td colspan="5"><strong>3: HIGHEST ACADEMIC QUALIFICATION</strong></td></tr>';
-
- $returnVal .= '<tr><td style="width:30%"><strong>Qualification:</strong></td><td>' . $row['highestqualification'] . '</td></tr>';
- $returnVal .= '<tr><td><strong>Field of Study:</strong></td><td>' . $row['fieldofstudy'] . '</td></tr>';
- $returnVal .= '<tr><td><strong>Class of Degree:</strong></td><td>' . $row['degreeclass'] . '</td></tr>';
- $returnVal .= '<tr><td><strong>Awarding Institution:</strong></td><td>' . $row['institutionobtained'] . '</td></tr>';
- $returnVal .= '<tr><td><strong>Year Obtained:</strong></td><td>' . $row['yearobtained'] . '</td></tr>';
-
- $q2 = "SELECT qualification, yearobtained, awardingbody FROM tblapplicantscvsprofquals WHERE cvrowid = $app_cv_id ORDER BY yearobtained DESC";
- $query = mysql_query($q2);
- $foundRecord = mysql_num_rows($query);
-
- $returnVal .= '<table><tr style="border: solid 1px #999999;background-color:#dddddd;font-size:18px"><td colspan="4"><strong>4: PROFESSIONAL QUALIFICATIONS</strong></td></tr>';
-
- if ($foundRecord > 0) {
- $i = 0;
- $returnVal .= '<tr style="border:solid 1px #999999; font-weight:bold"><td align="center">SN</td><td style="width:25%">Qualification</td><td>Awarding Body</td><td>Year Obtained</td></tr>';
- while($row = mysql_fetch_assoc($query)){
- $i++;
- $returnVal .= '<tr><td align="center">' . $i . '.</td><td>' . $row['qualification'] . '</td><td>' . $row['awardingbody'] . '</td><td>' .$row['yearobtained']. '</td></tr>';
- }//end while
- }else {
- $returnVal .= '<tr><td colspan="4">No professional qualification information supplied.</td></tr>';
- }//end if ($foundRecord == 1)
- $returnVal .= '</table>';
-
-
- $returnVal .= '<table><tr style="border: solid 1px;background-color:#dddddd;font-size:18px"><td colspan="5"><strong>5: HISTORY OF PREVIOUS WORK EXPERIENCE</strong></td></tr>';
-
- $q2 = "SELECT employer, positionheld, responsibilities, datefrom, dateto FROM tblapplicantscvsworkexp WHERE cvrowid = $app_cv_id ORDER BY datefrom DESC";
- $query = mysql_query($q2);
- $foundRecord = mysql_num_rows($query);
-
- if ($foundRecord > 0) {
- $i = 0;
- $returnVal .= '<tr style="border:solid 1px; font-weight:bold"><td align="center">SN</td><td>Employer</td><td>From</td><td>To</td><td>Position</td></tr>';
- while($row = mysql_fetch_assoc($query)){
- $i++;
- $returnVal .= '<tr><td align="center">' . $i . '.</td><td>' . $row['employer'] . '</td><td>' . get_my_date_format($row['datefrom'],'M') . '</td><td>' . get_my_date_format($row['dateto'],'M') . '</td><td>' . $row['positionheld'] . '</td></tr>';
- }//end while
- }else {
- $returnVal .= '<tr><td colspan="4">No previous work experience information supplied.</td></tr>';
- }//end if ($foundRecord == 1)
- $returnVal .= '</table>';
-
-
-
- $returnVal .= '<table><tr style="border: solid 1px;background-color:#dddddd;font-size:18px"><td colspan="5"><strong>6: REFEREES FOR THIS APPLICATION</strong></td></tr>';
-
- $returnVal .= '<tr style="font-weight:bold"><td align="center">SN</td><td>Refrees’ Names</td><td>GSM Number</td><td>E-Mail</td></tr>';
-
- $applicant_id = get_applicant_row_id_from_cv_id($app_cv_id); //defined in helper_functions.php
- $advert_id = get_advert_id_from_cv_id($app_cv_id); //defined in helper_functions.php
-
- $q2 = "SELECT tbladvertresponses.responseid, advertid, tblapplicantsreferees.rowid, advertresponseid, refereetitleid, refereename, refereephone, ";
- $q2 .= "refereeemail, salutation FROM tbladvertresponses INNER JOIN tblapplicantsreferees ON ";
- $q2 .= "tbladvertresponses.responseid = tblapplicantsreferees.advertresponseid INNER JOIN tblsalutationslookup ON ";
- $q2 .= "tblapplicantsreferees.refereetitleid = tblsalutationslookup.salutationid WHERE tbladvertresponses.advertid = $advert_id ";
- $q2 .= "AND tbladvertresponses.applicantid = $applicant_id ORDER BY salutation, refereename";
-
- $query2 = mysql_query($q2);
- $foundRecord = mysql_num_rows($query2);
-
- if ($foundRecord > 0) {
- $i = 0;
- $r = '';
- while ($row = mysql_fetch_assoc($query2)){
- $i++;
- $rName = $row['salutation'] . ' ' . $row['refereename'];
- $returnVal .= '<tr style="border: solid 1px;"><td align="center">' . $i . '.</td><td>' . $rName . '</td><td>' . $row['refereephone'] . '</td><td>' . $row['refereeemail'] . '</td></tr>';
- }//end while
- }else{
- $returnVal .= '<tr style="border: solid 1px; color:#cc0000"><td colspan="4">No referees supllied.</td></tr>';
- }//end if ($foundRecord == 1)
-
- }else{
- $returnVal .= '<tr style="border: solid 1px #ff0000;"><td colspan="2">Error while retrieving the job application information: <strong>"Invalid Applicant ID"</strong></td></tr>';
- }
-
- $returnVal .= '</table><br />';
- echo $returnVal;
- }
-
-
-
-
- /*
- $q = "SELECT tblapplicantsprofqualifications.rowid, qualificationid, yearobtained, awardingbody, tblprofessionalqualslookup.name ";
- $q .= "FROM tblapplicantsprofqualifications LEFT JOIN tblprofessionalqualslookup ON ";
- $q .= "tblapplicantsprofqualifications.qualificationid = tblprofessionalqualslookup.id ";
- $q .= "WHERE tblapplicantsprofqualifications.appaccountrowid = $applicant_row_id ORDER BY name";
-
- $query = mysql_query($q);
- $foundRecord = mysql_num_rows($query);
-
- $returnVal .= '<table border="1px" style="border-collapse: collapse; width:100%; margin-top:10px" cellpadding="5px" cellspacing="10px">';
-
- $returnVal .= '</table></br>';
-
- echo $returnVal;
- }
- */
- function get_printable_work_experience_details($applicant_row_id){
- $returnVal = '<table border="1px" style="border-collapse: collapse; width:100%; margin-top:10px" cellpadding="5px" cellspacing="10px">';
-
- if(!is_numeric($applicant_row_id) || ((int)$applicant_row_id < 1) ){
- $returnVal .= '<tr><td colspan="2">Error while retrieving the work experience information: <strong>"Invalid Applicant ID"</strong></td></tr>';
- }else{
- $q = "SELECT workingexpid, employer, positionheld, responsibilities, datefrom, dateto ";
- $q .= "FROM tblapplicantsworkexperience WHERE appaccountrowid = $applicant_row_id ORDER BY datefrom DESC";
-
- $query = mysql_query($q);
- $foundRecord = mysql_num_rows($query);
-
- $returnVal .= '<table border="1px" style="border-collapse: collapse; width:100%; margin-top:10px" cellpadding="5px" cellspacing="10px">';
- $returnVal .= '<tr style="border: solid 1px;background-color:#dddddd;font-size:18px"><td colspan="5"><strong>5: HISTORY OF PREVIOUS WORK EXPERIENCE</strong></td></tr>';
-
- if ($foundRecord > 0) {
- $i = 0;
- $returnVal .= '<tr style="border:solid 1px; font-weight:bold"><td align="center">SN</td><td>Employer</td><td>From</td><td>To</td><td>Position</td></tr>';
- while($row = mysql_fetch_assoc($query)){
- $i++;
- $returnVal .= '<tr><td align="center">' . $i . '.</td><td>' . $row['employer'] . '</td><td>' . get_my_date_format($row['datefrom'],'M') . '</td><td>' . get_my_date_format($row['dateto'],'M') . '</td><td>' . $row['positionheld'] . '</td></tr>';
- }//end while
- }else {
- $returnVal .= '<tr><td colspan="4">No previous work experience information supplied.</td></tr>';
- }//end if ($foundRecord == 1)
- }
- $returnVal .= '</table></br>';
-
- echo $returnVal;
- }
-
-
- function get_printable_photo($applicant_row_id){
- $finalURL = get_current_photo($applicant_row_id,'../profile/');
- $fURL = '';
- if (user_photo_not_uploaded($applicant_row_id)){
- $fURL = '<div style="position:relative; margin-top:-100px; margin-left:5px">' . $finalURL . '</div>';
- $fURL .= '<div style="float:center; text-align:center; width:100px; margin:5px; margin-left:2px; background-color:#eeeeee; border: 1px solid #339933"><a href="photo_upload.php" title="click to upload your photo">upload photo</a></div>';
-
- $finalURL = $fURL; //'<div style="position:relative; margin-top:-100px; margin-left:5px><a href="photo_upload.php" title="click to upload your photo">upload photo</a></div>';
- }else{
- $fURL = '<div style="position:relative; margin-top:-100px; margin-left:5px">' . $finalURL . '</div>';
- $finalURL = $fURL;
- }
-
- echo $finalURL;
- }
- ?>