/home/mip/public_html_/old-website/employerxxx/backup/report_applicant3.php
<?
session_start();
require_once("func_all.php");
//if($doc==1) header('Content-Type: application/msword');
do_resume_header($applicant_id,"Resume (Employer Version)");
$applicant = getdata_one("*","personal","applicant_id","$applicant_id");
$sex = $applicant[sex];
if($sex=="F") $sex="Female"; else $sex="Male";
$education = getdata("select * from education where applicant_id='$applicant_id' order by to_date desc");
$num_educ = count($education);
$employment = getdata("select *,DATE_FORMAT(from_date,'%b %Y') AS frm_date, IF(to_date,DATE_FORMAT(to_date,'%b %Y'),'PRESENT') as t_date from employment where applicant_id='$applicant_id' order by from_date desc");
$num_emp = count($employment);
$training = getdata("select * from training where applicant_id='$applicant_id' order by date desc");
$num_train = count($training);
?>
<tr><td height="100%" align=center valign="top">
<table align=center cellpadding='2' cellspacing='2'>
<tr><td>
<table width=750>
<tr><td bgcolor="#cccccc">
<table width=100%>
<tr height=30>
<td class="box1"><b>Personal Information</b></td>
</tr>
</table>
<table bgcolor="#cccccc" bordercolor=green width=100%>
<tr>
<td>
<table>
<tr>
<td><b>Application No.</b></td>
<td><b>:</b> <?=$applicant[applicant_id]?></td>
</tr>
<tr>
<td><b>Application Date</b></td>
<td><b>:</b> <?=dateformat($applicant[apply_date])?></td>
</tr>
<tr>
<td><b>Position Applied</b></td>
<td><b>:</b> <?=getname($applicant[position_id1],"positions","position_id")?></td>
</tr>
</table>
</td>
<td align=right><?if ($applicant[picture]){print resize_pic1(150,150,$pic_dir1.$applicant[picture],"","","",1);}?>
</td>
</tr>
</table>
<table bgcolor="#cccccc" width=100% border="0" cellspacing="2" cellpadding="2">
<tr>
<td class="box11" width=20%><b>Last Name</b></td>
<td class="box11" width=30%><?=$applicant[lname]?></td>
<td class="box11" width=15%><b>First Name</b></td>
<td class="box11" width=15%><?=$applicant[fname]?></td>
<td class="box11" width=10%><b>Middle</b></td>
<td class="box11" width=10%><?=$applicant[mname]?></td>
</tr>
<tr>
<td class="box11"><b>Age</b></td>
<td class="box11"><?=get_age($applicant[birthdate])?></td>
<td class="box11"><b>Date of Birth</b></td>
<td class="box11" colspan=3><?=dateformat($applicant[birthdate])?></td>
</tr>
<tr>
<td class="box11"><b>Sex</b></td>
<td class="box11"><?=$sex?></td>
<td class="box11" colspan="1"><b>Civil Status</b></td>
<td class="box11" colspan="3"><?=$applicant[civil_status]?></td>
</tr>
<tr>
<td class="box11"><b>Height</b></td>
<td class="box11"><?=$applicant[height1]." ".$applicant[height2]?></td>
<td class="box11" colspan="1"><b>Weight</b></td>
<td class="box11" colspan="3"><?=$applicant[weight1]." ".$applicant[weight2]?></td>
</tr>
<tr>
<td class="box11"><b>Religion</b></td>
<td class="box11" colspan="5"><?=($applicant[religion])? $applicant[religion] : "N/A"?></td>
</tr>
</table>
<!-- Educational Background-->
<?if($num_educ){?>
<table border=0 width=100% align=center>
<tr height=25 class=trtitle1><td class="box1"><b>Educational Background</b></td>
</tr>
</table>
<table bordercolor=green width=100%>
<tr>
<td class="box11" width=20%><b>Education</b></td>
<td class="box11" width=10%><b>From</b></td>
<td class="box11" width=10%><b>To</b></td>
<td class="box11" width=35%><b>School</b></td>
<td class="box11" width=25%><b>Course</b></td>
</tr>
<?for ($i=1; $i<=$num_educ; $i++){?>
<tr>
<td class="box11" valign=top><?=$education[$i][education]?></td>
<td class="box11" valign=top><?=$education[$i][from_date]?></td>
<td class="box11" valign=top><?=$education[$i][to_date]?></td>
<td class="box11" valign=top><?=$education[$i][school]?></td>
<td class="box11" valign=top><?=($education[$i][course])?$education[$i][course]: "N/A"?></td>
</tr>
<?}?>
</table>
<?}?>
<?if($num_train){?>
<!-- Training -->
<table border=0 width=100% align=center>
<tr height=25 class=trtitle1><td class="box1"><b>Trainings</b></td>
</tr>
</table>
<table width="100%">
<tr>
<td class="box11" align=center width=13%><b>Date</b></td>
<td class="box11" align=center width=28%><b>Training Center</b></td>
<td class="box11" align=center width=23%><b>Position</b></td>
<td class="box11" align=center width=35%><b>Remarks</b></td>
</tr>
<?for ($i=1; $i<=$num_train; $i++){?>
<tr>
<td class="box11"><?=dateformat($training[$i][date])?></td>
<td class="box11"><?=$training[$i][center]?></td>
<td class="box11"><?=$training[$i][title]?></td>
<td class="box11"><?=$training[$i][remarks]?></td>
</tr>
<?}?>
</TABLE>
<?}?>
<!-- Employment Information -->
<?if($num_emp){?>
<table border=0 width=100% align=center>
<tr height=25 class=trtitle1><td class="box1"><b>Employment Information</b></td>
</tr>
</table>
<table bordercolor=green width=100%>
<?for ($i=1; $i<=$num_emp; $i++){?>
<tr>
<td class="box11" width=20%><b>Company/Employer</b></td>
<td class="box11" width=30%><?=($employment[$i][company])? $employment[$i][company] : "N/A"?></td>
<td class="box11" colspan="2"><i>(<?=($employment[$i]['overseas'])? "Overseas" : "Local"?>)</td>
</tr>
<!--
<tr>
<td class="box11"><b>Address</b></td>
<td class="box11"><?=($employment[$i][address])? $employment[$i][address] : "N/A"?></td>
<td class="box11"><b>Contact No.</b></td>
<td class="box11"><?=($employment[$i][contact_no])? $employment[$i][contact_no] : "N/A"?></td>
</tr>
-->
<tr>
<td class="box11"><b>Position</b></td>
<td class="box11"><?=($employment[$i][position])? $employment[$i][position] : "N/A"?> </td>
<td class="box11" width=15%><b>Salary</b></td>
<td class="box11" width=35% colspan="1"><?=$employment[$i][salary]?></td>
</tr>
<tr>
<td class="box11"><b>From</b></td>
<td class="box11"><?=$employment[$i][frm_date]?> </td>
<td class="box11"><b>To</b></td>
<td class="box11" colspan=1><?=$employment[$i][t_date]?> </td>
</tr>
<tr>
<td class="box11" valign=top><b>Job Description</b></td>
<td class="box11" colspan=3><?=($employment[$i][job_desc])? addbreaks($employment[$i][job_desc]) : "N/A" ?></td>
</tr>
<tr>
<td class="box11" valign=top><b>Reason for Leaving</b></td>
<td class="box11" colspan=3><?=($employment[$i][reason_for_leaving])? addbreaks($employment[$i][reason_for_leaving]) : "N/A"?></td>
</tr>
<tr><td colspan=4><hr width=100%></td></tr>
<? }// end of for loop
?>
</table>
<?}?>
</td></tr>
</table>
</td></tr>
</table>
</td></tr>
<?
do_report_footer();
//if($doc!=1) echo "<script>alert('To open this page in a Word document, pls. click on the logo/header.')</script>";
?>