PageRenderTime 51ms CodeModel.GetById 24ms RepoModel.GetById 0ms app.codeStats 0ms

/recruitment/apply/print_functions.php

https://bitbucket.org/lecturer34/hrmis
PHP | 209 lines | 153 code | 40 blank | 16 comment | 10 complexity | a943a838d816b6d0ef29a4b25e5e0de4 MD5 | raw file
Possible License(s): LGPL-2.1
  1. <?php
  2. require_once('../helper_functions.php');
  3. require_once('../../lib/database.php');
  4. openConnection();
  5. function get_job_details($app_cv_id){
  6. $q = "SELECT c.advertresponseid, c.titleid, c.surname, c.firstname, c.othernames, c.gender, c.maritalstatus, c.physicalchallenge, c.birthdate, ";
  7. $q .= "c.birthplace, c.hometown, c.lga, c.state, c.nationality, c.personnelid, c.profile_pic, c.highestqualification, c.degreeclass, c.yearobtained, ";
  8. $q .= "c.institutionobtained, c.fieldofstudy, c.degreeclass, c.mainphone, c.otherphone, c.alternateemail, c.contactaddress, c.permanenthomeaddress, ";
  9. $q .= "r.advertid, r.responsedate, r.responsetime, r.datecompleted, r.timecompleted, r.applicantcomments, r.applicationstatus, v.vacancyid, v.rankid, ";
  10. $q .= "v.departmentid, v.jobschedule, v.jobshifts, v.jobhours, v.educationrequirements, v.experiencerequirements, v.additional_requirements, ";
  11. $q .= "rnk.name as position, d.name as department FROM tblapplicantscvs AS c ";
  12. $q .= "INNER JOIN tbladvertresponses AS r ON c.advertresponseid = r.responseid ";
  13. $q .= "INNER JOIN tbladvertisements AS ads ON r.advertid = ads.advertisementid ";
  14. $q .= "INNER JOIN tblvacancies AS v ON ads.vacancyid = v.vacancyid ";
  15. $q .= "INNER JOIN tblrank AS rnk ON v.rankid = rnk.rankid ";
  16. $q .= "INNER JOIN tbldepartment AS d ON v.departmentid = d.departmentid ";
  17. $q .= "WHERE c.rowid = $app_cv_id";
  18. $query = mysql_query($q);
  19. $foundRecord = mysql_num_rows($query);
  20. $returnVal = '<table border="1px" style="border-collapse: collapse; width:100%; margin-top:10px" cellpadding="5px" cellspacing="10px">';
  21. if ($foundRecord == 1) {
  22. $row = mysql_fetch_assoc($query);
  23. $returnVal .= '<tr style="border: solid 1px #999999;background-color:#dddddd;font-size:18px"><td colspan="2"><strong>JOB APPLICATION DETAILS</strong></td></tr>';
  24. $returnVal .= '<tr><td style="width:25%"><strong>Job Title / Position:</strong></td><td>' . $row['position'] . '</td></tr>';
  25. $returnVal .= '<tr><td><strong>Department / Division:</strong></td><td>' . $row['department'] . '</td></tr>';
  26. $returnVal .= '<tr><td><strong>Qualification Required:</strong></td><td>' . $row['educationrequirements'] . '</td></tr>';
  27. $returnVal .= '<tr><td><strong>Experience Required:</strong></td><td>' . $row['experiencerequirements'] . '</td></tr>';
  28. $returnVal .= '<tr><td><strong>Job Schedule:</strong></td><td>' . $row['jobschedule'] . '</td></tr>';
  29. $returnVal .= '<tr><td><strong>Job Shifts:</strong></td><td>' . $row['jobshifts'] . '</td></tr>';
  30. $returnVal .= '<tr><td><strong>Job Hours:</strong></td><td>' . $row['jobhours'] . '</td></tr>';
  31. $returnVal .= '<tr><td><strong>Date &amp; Time Submitted:</strong></td><td>' . get_my_date_format($row['datecompleted'], 'M') . ' @' . $row['timecompleted'] . '</td></tr>';
  32. $returnVal .= '<tr><td><strong>Applicant&rsquo;s Comments:</strong></td><td>' . $row['applicantcomments'] . '</td></tr></table>';
  33. $returnVal .= '<br /><h2 style="text-align: center;">APPLICANT&rsquo;S CV AS AT TIME OF APPLICATION</h2>';
  34. $returnVal .= '<table><tr style="border: solid 1px #999999;background-color:#dddddd;font-size:18px"><td colspan="2"><strong>1:&nbsp;&nbsp;BIODATA</strong></td></tr>';
  35. $returnVal .= '<tr><td style="width:30%"><strong>Gender:</strong></td><td>' . $row['gender'] . '</td></tr>';
  36. $returnVal .= '<tr><td><strong>Marital Status:</strong></td><td>' . $row['maritalstatus'] . '</td></tr>';
  37. $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>';
  38. $returnVal .= '<tr><td><strong>Place of Birth:</strong></td><td>' . $row['birthplace'] . '</td></tr>';
  39. $returnVal .= '<tr><td><strong>Home Town:</strong></td><td>' . $row['hometown'] . '</td></tr>';
  40. $returnVal .= '<tr><td><strong>Local Government Area:</strong></td><td>' . $row['lga'] . '</td></tr>';
  41. $returnVal .= '<tr><td><strong>State of Origin:</strong></td><td>' . $row['state'] . '</td></tr>';
  42. $returnVal .= '<tr><td><strong>Country of Origin:</strong></td><td>' . $row['nationality'] . '</td></tr>';
  43. $returnVal .= '<tr><td><strong>Physical Challenge:</strong></td><td>' . $row['physicalchallenge'] . '</td></tr></table>';
  44. $returnVal .= '<table><tr style="border: solid 1px #999999;background-color:#dddddd;font-size:18px"><td colspan="2"><strong>2:&nbsp;&nbsp;CONTACT DETAILS</strong></td></tr>';
  45. $returnVal .= '<tr><td style="width:30%"><strong>Primary E-Mail:</strong></td><td>' . '' . '</td></tr>';
  46. $returnVal .= '<tr><td><strong>Primary GSM Number:</strong></td><td>' . $row['mainphone'] . '</td></tr>';
  47. $returnVal .= '<tr><td><strong>Alternative E-Mail:</strong></td><td>' . $row['alternateemail'] . '</td></tr>';
  48. $returnVal .= '<tr><td><strong>Alternative GSM Number:</strong></td><td>' . $row['otherphone'] . '</td></tr>';
  49. $returnVal .= '<tr><td><strong>Current Contact Address:</strong></td><td>' . $row['contactaddress'] . '</td></tr>';
  50. $returnVal .= '<tr><td><strong>Permanent Home Address:</strong></td><td>' . $row['permanenthomeaddress'] . '</td></tr></table>';
  51. $returnVal .= '<table><tr style="border: solid 1px #999999;background-color:#dddddd;font-size:18px"><td colspan="5"><strong>3:&nbsp;&nbsp;HIGHEST ACADEMIC QUALIFICATION</strong></td></tr>';
  52. $returnVal .= '<tr><td style="width:30%"><strong>Qualification:</strong></td><td>' . $row['highestqualification'] . '</td></tr>';
  53. $returnVal .= '<tr><td><strong>Field of Study:</strong></td><td>' . $row['fieldofstudy'] . '</td></tr>';
  54. $returnVal .= '<tr><td><strong>Class of Degree:</strong></td><td>' . $row['degreeclass'] . '</td></tr>';
  55. $returnVal .= '<tr><td><strong>Awarding Institution:</strong></td><td>' . $row['institutionobtained'] . '</td></tr>';
  56. $returnVal .= '<tr><td><strong>Year Obtained:</strong></td><td>' . $row['yearobtained'] . '</td></tr>';
  57. $q2 = "SELECT qualification, yearobtained, awardingbody FROM tblapplicantscvsprofquals WHERE cvrowid = $app_cv_id ORDER BY yearobtained DESC";
  58. $query = mysql_query($q2);
  59. $foundRecord = mysql_num_rows($query);
  60. $returnVal .= '<table><tr style="border: solid 1px #999999;background-color:#dddddd;font-size:18px"><td colspan="4"><strong>4:&nbsp;&nbsp;PROFESSIONAL QUALIFICATIONS</strong></td></tr>';
  61. if ($foundRecord > 0) {
  62. $i = 0;
  63. $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>';
  64. while($row = mysql_fetch_assoc($query)){
  65. $i++;
  66. $returnVal .= '<tr><td align="center">' . $i . '.</td><td>' . $row['qualification'] . '</td><td>' . $row['awardingbody'] . '</td><td>' .$row['yearobtained']. '</td></tr>';
  67. }//end while
  68. }else {
  69. $returnVal .= '<tr><td colspan="4">No professional qualification information supplied.</td></tr>';
  70. }//end if ($foundRecord == 1)
  71. $returnVal .= '</table>';
  72. $returnVal .= '<table><tr style="border: solid 1px;background-color:#dddddd;font-size:18px"><td colspan="5"><strong>5:&nbsp;&nbsp;HISTORY OF PREVIOUS WORK EXPERIENCE</strong></td></tr>';
  73. $q2 = "SELECT employer, positionheld, responsibilities, datefrom, dateto FROM tblapplicantscvsworkexp WHERE cvrowid = $app_cv_id ORDER BY datefrom DESC";
  74. $query = mysql_query($q2);
  75. $foundRecord = mysql_num_rows($query);
  76. if ($foundRecord > 0) {
  77. $i = 0;
  78. $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>';
  79. while($row = mysql_fetch_assoc($query)){
  80. $i++;
  81. $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>';
  82. }//end while
  83. }else {
  84. $returnVal .= '<tr><td colspan="4">No previous work experience information supplied.</td></tr>';
  85. }//end if ($foundRecord == 1)
  86. $returnVal .= '</table>';
  87. $returnVal .= '<table><tr style="border: solid 1px;background-color:#dddddd;font-size:18px"><td colspan="5"><strong>6:&nbsp;&nbsp;REFEREES FOR THIS APPLICATION</strong></td></tr>';
  88. $returnVal .= '<tr style="font-weight:bold"><td align="center">SN</td><td>Refrees&rsquo; Names</td><td>GSM Number</td><td>E-Mail</td></tr>';
  89. $applicant_id = get_applicant_row_id_from_cv_id($app_cv_id); //defined in helper_functions.php
  90. $advert_id = get_advert_id_from_cv_id($app_cv_id); //defined in helper_functions.php
  91. $q2 = "SELECT tbladvertresponses.responseid, advertid, tblapplicantsreferees.rowid, advertresponseid, refereetitleid, refereename, refereephone, ";
  92. $q2 .= "refereeemail, salutation FROM tbladvertresponses INNER JOIN tblapplicantsreferees ON ";
  93. $q2 .= "tbladvertresponses.responseid = tblapplicantsreferees.advertresponseid INNER JOIN tblsalutationslookup ON ";
  94. $q2 .= "tblapplicantsreferees.refereetitleid = tblsalutationslookup.salutationid WHERE tbladvertresponses.advertid = $advert_id ";
  95. $q2 .= "AND tbladvertresponses.applicantid = $applicant_id ORDER BY salutation, refereename";
  96. $query2 = mysql_query($q2);
  97. $foundRecord = mysql_num_rows($query2);
  98. if ($foundRecord > 0) {
  99. $i = 0;
  100. $r = '';
  101. while ($row = mysql_fetch_assoc($query2)){
  102. $i++;
  103. $rName = $row['salutation'] . ' ' . $row['refereename'];
  104. $returnVal .= '<tr style="border: solid 1px;"><td align="center">' . $i . '.</td><td>' . $rName . '</td><td>' . $row['refereephone'] . '</td><td>' . $row['refereeemail'] . '</td></tr>';
  105. }//end while
  106. }else{
  107. $returnVal .= '<tr style="border: solid 1px; color:#cc0000"><td colspan="4">No referees supllied.</td></tr>';
  108. }//end if ($foundRecord == 1)
  109. }else{
  110. $returnVal .= '<tr style="border: solid 1px #ff0000;"><td colspan="2">Error while retrieving the job application information: <strong>"Invalid Applicant ID"</strong></td></tr>';
  111. }
  112. $returnVal .= '</table><br />';
  113. echo $returnVal;
  114. }
  115. /*
  116. $q = "SELECT tblapplicantsprofqualifications.rowid, qualificationid, yearobtained, awardingbody, tblprofessionalqualslookup.name ";
  117. $q .= "FROM tblapplicantsprofqualifications LEFT JOIN tblprofessionalqualslookup ON ";
  118. $q .= "tblapplicantsprofqualifications.qualificationid = tblprofessionalqualslookup.id ";
  119. $q .= "WHERE tblapplicantsprofqualifications.appaccountrowid = $applicant_row_id ORDER BY name";
  120. $query = mysql_query($q);
  121. $foundRecord = mysql_num_rows($query);
  122. $returnVal .= '<table border="1px" style="border-collapse: collapse; width:100%; margin-top:10px" cellpadding="5px" cellspacing="10px">';
  123. $returnVal .= '</table></br>';
  124. echo $returnVal;
  125. }
  126. */
  127. function get_printable_work_experience_details($applicant_row_id){
  128. $returnVal = '<table border="1px" style="border-collapse: collapse; width:100%; margin-top:10px" cellpadding="5px" cellspacing="10px">';
  129. if(!is_numeric($applicant_row_id) || ((int)$applicant_row_id < 1) ){
  130. $returnVal .= '<tr><td colspan="2">Error while retrieving the work experience information: <strong>"Invalid Applicant ID"</strong></td></tr>';
  131. }else{
  132. $q = "SELECT workingexpid, employer, positionheld, responsibilities, datefrom, dateto ";
  133. $q .= "FROM tblapplicantsworkexperience WHERE appaccountrowid = $applicant_row_id ORDER BY datefrom DESC";
  134. $query = mysql_query($q);
  135. $foundRecord = mysql_num_rows($query);
  136. $returnVal .= '<table border="1px" style="border-collapse: collapse; width:100%; margin-top:10px" cellpadding="5px" cellspacing="10px">';
  137. $returnVal .= '<tr style="border: solid 1px;background-color:#dddddd;font-size:18px"><td colspan="5"><strong>5:&nbsp;&nbsp;HISTORY OF PREVIOUS WORK EXPERIENCE</strong></td></tr>';
  138. if ($foundRecord > 0) {
  139. $i = 0;
  140. $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>';
  141. while($row = mysql_fetch_assoc($query)){
  142. $i++;
  143. $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>';
  144. }//end while
  145. }else {
  146. $returnVal .= '<tr><td colspan="4">No previous work experience information supplied.</td></tr>';
  147. }//end if ($foundRecord == 1)
  148. }
  149. $returnVal .= '</table></br>';
  150. echo $returnVal;
  151. }
  152. function get_printable_photo($applicant_row_id){
  153. $finalURL = get_current_photo($applicant_row_id,'../profile/');
  154. $fURL = '';
  155. if (user_photo_not_uploaded($applicant_row_id)){
  156. $fURL = '<div style="position:relative; margin-top:-100px; margin-left:5px">' . $finalURL . '</div>';
  157. $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>';
  158. $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>';
  159. }else{
  160. $fURL = '<div style="position:relative; margin-top:-100px; margin-left:5px">' . $finalURL . '</div>';
  161. $finalURL = $fURL;
  162. }
  163. echo $finalURL;
  164. }
  165. ?>