/home/mip/public_html_/old-website/employerxxx/backup/report_applicant.php
<?
session_start();
require_once("func_all.php");
do_html_header("Applicant's Information");
$applicant = getdata_one("*",
"personal","applicant_id","$applicant_id");
if($applicant[sex]=="F") $sex="Female"; else $sex="Male";
$bene = getdata_one("*","beneficiary","applicant_id","$applicant_id");
$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,'%M %Y') AS frm_date, IF(to_date,DATE_FORMAT(to_date,'%M %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);
$prequalify = getdata_one("*,DATE_FORMAT(date,'%b %d, %Y') AS date","prequalify","applicant_id","applicant_id");
$cvsents = getdata("select * from cv_sents where applicant_id='$applicant_id' order by date desc");
$num_cvsents = count($cvsents);
$complaint = getdata("select *,DATE_FORMAT(complaint_date,'%b %d, %Y') AS complaint_date,DATE_FORMAT(resolved_date,'%b %d, %Y') AS resolved_date from complaints where applicant_id='$applicant_id' order by complaint_date desc");
$num_comp = count($complaint);
$medical = getdata("select m.medical_id,m.applicant_id,m.status,m.description,c.name as clinic_name,DATE_FORMAT(m.date,'%b %d, %Y') AS date from medical as m,clinics as c where m.clinic_id=c.clinic_id and applicant_id='$applicant_id' order by date desc");
$num_med = count($medical);
$process = getdata_one("*,DATE_FORMAT(pp_date_issued,'%b %d, %Y') AS pp_date_issued,
DATE_FORMAT(pp_date_expires,'%b %d, %Y') AS pp_date_expires,
DATE_FORMAT(job_acceptance,'%b %d, %Y') AS job_acceptance,
DATE_FORMAT(pdos,'%b %d, %Y') AS pdos,
DATE_FORMAT(attest,'%b %d, %Y') AS attest,
DATE_FORMAT(drug_test,'%b %d, %Y') AS drug_test,
DATE_FORMAT(visa_filed,'%b %d, %Y') AS visa_filed,
DATE_FORMAT(visa_released,'%b %d, %Y') AS visa_released,
DATE_FORMAT(poea_filed,'%b %d, %Y') AS poea_filed,
DATE_FORMAT(poea_released,'%b %d, %Y') AS poea_released,
DATE_FORMAT(ticket,'%b %d, %Y') AS ticket,
DATE_FORMAT(cla_date,'%b %d, %Y') AS cla_date,
DATE_FORMAT(deployment,'%b %d, %Y') AS deployment",
"process","applicant_id","$applicant_id");
?>
<tr><td height="100%" align=center valign="top">
<table align=center cellpadding='2' cellspacing='2'>
<tr><td>
<table width=750 border=0>
<tr><td valign="top"><br>
<table border=0 cellpadding='0' cellspacing='0' width="100%">
<tr><td valign="top"><img src="img/addleft.gif" border="0"></td>
<td background="img/addtile.gif" width="100%">
<table width=100% border=0>
<tr height=25>
<td><b><a href="edit_personal.php?Action=edit&applicant_id=<?=$applicant_id?>">Personal Information</a></b></td>
<td align=right>
[<a href="report_applicant2.php?applicant_id=<?=$applicant_id?>" target="print"> Agency Version</a>]
[<a href="report_applicant3.php?applicant_id=<?=$applicant_id?>" target="email"> Employer Version</a>]
[<a href="report_ofwform.php?applicant_id=<?=$applicant_id?>" target="_blank">Agency Hired OFW ID Form</a>]
[<a href="report_ofwinfosheet.php?applicant_id=<?=$applicant_id?>" target="_blank">OFW Info Sheet</a>]
</td>
</tr>
</table>
</td>
<td valign="top"><img src="img/addright.gif" border="0"></td></tr>
</table>
</td></tr>
<tr><td>
<table border="0" cellpadding="0" cellspacing="0" width=100%>
<tr><td><img src="img/topleft-login.gif" border="0"></td>
<td background="img/toptile-login.gif"><img src="img/toptile-login.gif" border="0"></td>
<td><img src="img/topright-login.gif" border="0"></td></tr>
<tr><td background="img/midleft-login.gif"><img src="img/midleft-login.gif" border="0"></td>
<td width="100%" align="center" bgcolor="#dbdee3">
<table border="0" cellpadding="0" cellspacing="0" width=100%>
<tr><td>
<table border=0 cellpadding="3" cellspacing="3">
<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>
<td><b>Yrs Exp.</b></td>
<td><b>:</b> <?=($applicant[position1_yrsofexp])? $applicant[position1_yrsofexp]." yrs" : ""?><?=($applicant[position1_yrsofexp] && $applicant[position1_mosofexp])? " & " : ""?><?=($applicant[position1_mosofexp])? $applicant[position1_mosofexp]." mos" : ""?></td>
</tr>
<tr>
<td><b>Position 2nd Choice</b></td>
<td><b>:</b> <?=getname($applicant[position_id2],"positions","position_id")?></td>
<td><b>Yrs Exp.</b></td>
<td><b>:</b> <?=($applicant[position2_yrsofexp])? $applicant[position2_yrsofexp]." yrs" : ""?><?=($applicant[position2_yrsofexp] && $applicant[position2_mosofexp])? " & " : ""?><?=($applicant[position2_mosofexp])? $applicant[position2_mosofexp]." mos" : ""?></td>
</tr>
<tr>
<td><b>Country Applied</b></td>
<td><b>:</b> <?=getname($applicant[country_id],"country","country_id")?></td>
</tr>
</table>
</td>
<td align=right class="picture" width="1"><?if ($applicant[picture]){?><img src="<?=$pic_dir1.$applicant[picture]?>" alt="<?=$applicant[lname]?>" width=150 height=150><?}?>
</td></tr>
</table>
</td>
<td background="img/midright-login.gif"><img src="img/midright-login.gif" border="0"></td></tr>
<tr><td><img src="img/botleft-login.gif" border="0"></td>
<td background="img/bottile-login.gif"><img src="img/bottile-login.gif" border="0"></td>
<td><img src="img/botright-login.gif" border="0"></td></tr>
</table><br>
<table border="0" cellpadding="0" cellspacing="0" width=100%>
<tr><td><img src="img/topleft-login.gif" border="0"></td>
<td background="img/toptile-login.gif"><img src="img/toptile-login.gif" border="0"></td>
<td><img src="img/topright-login.gif" border="0"></td></tr>
<tr><td background="img/midleft-login.gif"><img src="img/midleft-login.gif" border="0"></td>
<td width="100%" align="center" bgcolor="#dbdee3">
<table border=0 cellpadding='0' cellspacing='0' width="100%">
<tr><td>
<table width=100% border=0 cellpadding='3' cellspacing='3'>
<tr>
<td class="box" width=20%><b>Last Name</b></td>
<td class="box" width=30%><?=$applicant[lname]?></td>
<td class="box" width=15%><b>First Name</b></td>
<td class="box" width=15%><?=$applicant[fname]?></td>
<td class="box" width=10%><b>Middle</b></td>
<td class="box" width=10%><?=$applicant[mname]?></td>
</tr>
<tr>
<td class="box"><b>Age</b></td>
<td class="box" colspan=5><?=get_age($applicant[birthdate])?></td>
</tr>
<tr>
<td class="box"><b>Date of Birth</b></td>
<td class="box"><?=dateformat($applicant[birthdate])?></td>
<td class="box" colspan="1"><b>Place of Birth</b></td>
<td class="box" colspan="3"><?=$applicant[birthplace]?></td>
</tr>
<tr>
<td class="box"><b>Sex</b></td>
<td class="box"><?=$sex?></td>
<td class="box" colspan="1"><b>Civil Status</b></td>
<td class="box" colspan="3"><?=$applicant[civil_status]?></td>
</tr>
<tr>
<td class="box"><b>Height</b></td>
<td class="box"><?=$applicant[height1]." ".$applicant[height2]?></td>
<td class="box" colspan="1"><b>Weight</b></td>
<td class="box" colspan="3"><?=$applicant[weight1]." ".$applicant[weight2]?></td>
</tr>
<tr>
<td class="box"><b>Religion</b></td>
<td class="box"><?=$applicant[religion]?></td>
<td class="box"><b>Nationality</b></td>
<td class="box" colspan="3"><?=$applicant[nationality]?></td>
</tr>
<tr>
<td class="box"><b>Present Address</b></td>
<td class="box" colspan=5><?=$applicant[address1]?></td>
</tr>
<tr>
<td class="box"><b>Tel [Office]</b></td>
<td class="box" colspan="5"><?=$applicant[office_phone]?></td>
</tr>
<tr>
<td class="box"><b>Tel [Home]</b></td>
<td class="box" colspan="5"><?=$applicant[home_phone]?></td>
</tr>
<tr>
<td class="box"><b>Cellphone</b></td>
<td class="box" colspan="5"><?=$applicant[cellphone]?></td>
</tr>
<tr>
<td class="box"><b>Permanent Address</b></td>
<td class="box" colspan=5><?=$applicant[perm_no]." ".$applicant[perm_st]?><?=($applicant[perm_city])? ", ".$applicant[perm_city] : ""?><?=($applicant[perm_prov])? ", ".$applicant[perm_prov] : ""?> <?=$applicant[perm_zip]?></td>
</tr>
</table>
</td></tr>
</TABLE>
</td>
<td background="img/midright-login.gif"><img src="img/midright-login.gif" border="0"></td></tr>
<tr><td><img src="img/botleft-login.gif" border="0"></td>
<td background="img/bottile-login.gif"><img src="img/bottile-login.gif" border="0"></td>
<td><img src="img/botright-login.gif" border="0"></td></tr>
</table><br>
<!-- Beneficiary Information-->
<table border=0 cellpadding='0' cellspacing='0' width="100%">
<tr><td valign="top"><img src="img/addleft.gif" border="0"></td>
<td background="img/addtile.gif" width="100%"><b><a href="edit_beneficiary.php?Action=edit&applicant_id=<?echo$applicant_id?>">Beneficiary Data</a></b></td>
<td valign="top"><img src="img/addright.gif" border="0"></td></tr>
</table>
<table border="0" cellpadding="0" cellspacing="0" width=100%>
<tr><td><img src="img/topleft-login.gif" border="0"></td>
<td background="img/toptile-login.gif"><img src="img/toptile-login.gif" border="0"></td>
<td><img src="img/topright-login.gif" border="0"></td></tr>
<tr><td background="img/midleft-login.gif"><img src="img/midleft-login.gif" border="0"></td>
<td width="100%" align="center" bgcolor="#dbdee3">
<table border=0 cellpadding='0' cellspacing='0' width="100%">
<tr>
<td>
<table width=100% border=0 cellpadding='3' cellspacing='3'>
<tr>
<td class="box"><b>Beneficiary Name:</b></td>
<td class="box"><?=$bene[ben_fname]. " ".$bene[ben_mname]." ".$bene[ben_lname]?></td>
<td class="box"><b>Relationship to Worker:</b></td>
<td class="box"><?=$bene[ben_relationship]?></td>
</tr>
<tr>
<td class="box"><b>Allotee Name:</b></td>
<td class="box"><?=$bene[allo_fname]. " ".$bene[allo_mname]." ".$bene[allo_lname]?></td>
<td class="box"><b>Relationship to Allotee:</b></td>
<td class="box"><?=$bene[allo_relationship]?></td>
</tr>
<tr>
<td class="box"><b>Permanent Address:</b></td>
<td class="box" colspan=3><?=$bene[add_no]. " ".$bene[add_st]?><?=($bene[add_city])? ", ".$bene[add_city] : ""?><?=($bene[add_prov])? ", ".$bene[add_prov] : ""?></td>
</tr>
</table>
</td></tr>
</TABLE>
</td>
<td background="img/midright-login.gif"><img src="img/midright-login.gif" border="0"></td></tr>
<tr><td><img src="img/botleft-login.gif" border="0"></td>
<td background="img/bottile-login.gif"><img src="img/bottile-login.gif" border="0"></td>
<td><img src="img/botright-login.gif" border="0"></td></tr>
</table><br>
<!-- Educational Background-->
<table border=0 cellpadding='0' cellspacing='0' width="100%">
<tr><td valign="top"><img src="img/addleft.gif" border="0"></td>
<td background="img/addtile.gif" width="100%"><b><a href="edit_education.php?Action=edit&applicant_id=<?echo$applicant_id?>">Educational Background</a></b></td>
<td valign="top"><img src="img/addright.gif" border="0"></td></tr>
</table>
<table border="0" cellpadding="0" cellspacing="0" width=100%>
<tr><td><img src="img/topleft-login.gif" border="0"></td>
<td background="img/toptile-login.gif"><img src="img/toptile-login.gif" border="0"></td>
<td><img src="img/topright-login.gif" border="0"></td></tr>
<tr><td background="img/midleft-login.gif"><img src="img/midleft-login.gif" border="0"></td>
<td width="100%" align="center" bgcolor="#dbdee3">
<table border=0 cellpadding='0' cellspacing='0' width="100%">
<tr>
<td>
<table width=100% border=0 cellpadding='3' cellspacing='3'>
<?if($num_educ){?>
<tr>
<td class="box" width=20%><b>Education</b></td>
<td class="box" width=10%><b>From</b></td>
<td class="box" width=10%><b>To</b></td>
<td class="box" width=40%><b>School</b></td>
<td class="box" width=20%><b>Course</b></td>
</tr>
<?}
for ($i=1; $i<=$num_educ; $i++){?>
<tr>
<td class="box"><?=$education[$i][education]?></td>
<td class="box"><?=$education[$i][from_date]?></td>
<td class="box"><?=$education[$i][to_date]?></td>
<td class="box"><?=$education[$i][school]?></td>
<td class="box"><?=$education[$i][course]?></td>
</tr>
<?}?>
</table>
</td></tr>
</TABLE>
</td>
<td background="img/midright-login.gif"><img src="img/midright-login.gif" border="0"></td></tr>
<tr><td><img src="img/botleft-login.gif" border="0"></td>
<td background="img/bottile-login.gif"><img src="img/bottile-login.gif" border="0"></td>
<td><img src="img/botright-login.gif" border="0"></td></tr>
</table><br>
<!-- Training -->
<table border=0 cellpadding='0' cellspacing='0' width="100%">
<tr><td valign="top"><img src="img/addleft.gif" border="0"></td>
<td background="img/addtile.gif" width="100%"><b><a href="edit_training.php?Action=edit&applicant_id=<?echo$applicant_id?>">Trainings</a></b></td>
<td valign="top"><img src="img/addright.gif" border="0"></td></tr>
</table>
<table border="0" cellpadding="0" cellspacing="0" width=100%>
<tr><td><img src="img/topleft-login.gif" border="0"></td>
<td background="img/toptile-login.gif"><img src="img/toptile-login.gif" border="0"></td>
<td><img src="img/topright-login.gif" border="0"></td></tr>
<tr><td background="img/midleft-login.gif"><img src="img/midleft-login.gif" border="0"></td>
<td width="100%" align="center" bgcolor="#dbdee3">
<table border=0 cellpadding='0' cellspacing='0' width="100%">
<tr><td>
<table width=100% border=0 cellpadding='3' cellspacing='3'>
<?if($num_train){?>
<tr>
<td class="box" align=center width=13%><b>Date</b></td>
<td class="box" align=center width=28%><b>Training Center</b></td>
<td class="box" align=center width=23%><b>Position</b></td>
<td class="box" align=center width=35%><b>Remarks</b></td>
</tr>
<?}
for ($i=1; $i<=$num_train; $i++){?>
<tr class=none>
<td class="box"><?=dateformat($training[$i][date])?></td>
<td class="box"><?=$training[$i][center]?></td>
<td class="box"><?=$training[$i][title]?></td>
<td class="box"><?=$training[$i][remarks]?></td>
</tr>
<?}?>
</table>
</td></tr>
</TABLE>
</td>
<td background="img/midright-login.gif"><img src="img/midright-login.gif" border="0"></td></tr>
<tr><td><img src="img/botleft-login.gif" border="0"></td>
<td background="img/bottile-login.gif"><img src="img/bottile-login.gif" border="0"></td>
<td><img src="img/botright-login.gif" border="0"></td></tr>
</table><br>
<!-- Employment Information -->
<table border=0 cellpadding='0' cellspacing='0' width="100%">
<tr><td valign="top"><img src="img/addleft.gif" border="0"></td>
<td background="img/addtile.gif" width="100%"><b><a href="edit_employment.php?Action=edit&applicant_id=<?echo$applicant_id?>">Employment Information</a></b></td>
<td valign="top"><img src="img/addright.gif" border="0"></td></tr>
</table>
<table border="0" cellpadding="0" cellspacing="0" width=100%>
<tr><td><img src="img/topleft-login.gif" border="0"></td>
<td background="img/toptile-login.gif"><img src="img/toptile-login.gif" border="0"></td>
<td><img src="img/topright-login.gif" border="0"></td></tr>
<tr><td background="img/midleft-login.gif"><img src="img/midleft-login.gif" border="0"></td>
<td width="100%" align="center" bgcolor="#dbdee3">
<table border=0 cellpadding='0' cellspacing='0' width="100%">
<tr>
<td>
<table border=0 cellpadding="3" cellspacing="3" width="100%">
<?
for ($i=1; $i<=$num_emp; $i++){?>
<tr>
<td class="box" width=20%><b>Company</b></td>
<td class="box" width=30%><?=$employment[$i][company]?></td>
<td class="box" width=20%><b>Department</b></td>
<td class="box" width=30% colspan="1"><?=$employment[$i][department]?></td>
</tr>
<tr>
<td class="box"><b>Address</b></td>
<td class="box" colspan=3><?=$employment[$i][address]?></td>
</tr>
<tr>
<td class="box"><b>Position</b></td>
<td class="box"><?=$employment[$i][position]?> </td>
<td class="box"><b>Salary</b></td>
<td class="box" colspan="1"><?=$employment[$i][salary]?></td>
</tr>
<tr>
<td class="box"><b>From</b></td>
<td class="box"><?=$employment[$i][frm_date]?> </td>
<td class="box"><b>To</b></td>
<td class="box" colspan=1><?=$employment[$i][t_date]?> </td>
</tr>
<tr>
<td class="box"><b>Job Description</b></td>
<td class="box" colspan=3><?=$employment[$i][job_desc]?></td>
</tr>
<tr>
<td class="box"><b>Reason for Leaving</b></td>
<td class="box" colspan=3><?=$employment[$i][reason_for_leaving]?></td>
</tr>
<tr><td colspan=4><hr width=100%></td></tr>
<? }// end of for loop
?>
</table>
</td></tr>
</TABLE>
</td>
<td background="img/midright-login.gif"><img src="img/midright-login.gif" border="0"></td></tr>
<tr><td><img src="img/botleft-login.gif" border="0"></td>
<td background="img/bottile-login.gif"><img src="img/bottile-login.gif" border="0"></td>
<td><img src="img/botright-login.gif" border="0"></td></tr>
</table><br>
<!-- Interview -->
<table border=0 cellpadding='0' cellspacing='0' width="100%">
<tr><td valign="top"><img src="img/addleft.gif" border="0"></td>
<td background="img/addtile.gif" width="100%"><b><a href="edit_prequalify.php?Action=edit&applicant_id=<?echo$applicant_id?>">Interview</a></b></td>
<td valign="top"><img src="img/addright.gif" border="0"></td></tr>
</table>
<table border="0" cellpadding="0" cellspacing="0" width=100%>
<tr><td><img src="img/topleft-login.gif" border="0"></td>
<td background="img/toptile-login.gif"><img src="img/toptile-login.gif" border="0"></td>
<td><img src="img/topright-login.gif" border="0"></td></tr>
<tr><td background="img/midleft-login.gif"><img src="img/midleft-login.gif" border="0"></td>
<td width="100%" align="center" bgcolor="#dbdee3">
<table border=0 cellpadding='0' cellspacing='0' width="100%">
<tr>
<td>
<table border=0 width=100% cellpadding='3' cellspacing='3'>
<tr>
<td class="box" width=21%><b>Interviewer</b></td>
<td class="box" width=29%><?=$prequalify[RO]?></td>
<td class="box" width=21%><b>Date</b></td>
<td class="box" width=29%><?=$prequalify[date]?></td>
</tr>
<tr>
<td class="box"><b>Appearance & Bearing</b></td>
<td class="box"><?=$prequalify[appearance]?></td>
<td class="box"><b>Personality & Attitude</b></td>
<td class="box"><?=$prequalify[personality]?></td>
</tr>
<tr>
<td class="box"><b>Work Experience</b></td>
<td class="box"><?=$prequalify[experience]?></td>
<td class="box"><b>Job Knowledge</b></td>
<td class="box"><?=$prequalify[knowledge]?></td>
</tr>
<tr>
<td class="box"><b>Communication Skills</b></td>
<td class="box" colspan=3><?=$prequalify[comm_skills]?></td>
</tr>
<tr>
<td class="box" valign=top><b>Remarks</b></td>
<td class="box" colspan=3><?=$prequalify[remarks]?></td>
</tr>
</table>
</td></tr>
</TABLE>
</td>
<td background="img/midright-login.gif"><img src="img/midright-login.gif" border="0"></td></tr>
<tr><td><img src="img/botleft-login.gif" border="0"></td>
<td background="img/bottile-login.gif"><img src="img/bottile-login.gif" border="0"></td>
<td><img src="img/botright-login.gif" border="0"></td></tr>
</table><br>
<!-- Medical Information-->
<table border=0 cellpadding='0' cellspacing='0' width="100%">
<tr><td valign="top"><img src="img/addleft.gif" border="0"></td>
<td background="img/addtile.gif" width="100%"><b><a href="edit_medical.php?Action=edit&applicant_id=<?echo$applicant_id?>">Medical Information</a></b></td>
<td valign="top"><img src="img/addright.gif" border="0"></td></tr>
</table>
<table border="0" cellpadding="0" cellspacing="0" width=100%>
<tr><td><img src="img/topleft-login.gif" border="0"></td>
<td background="img/toptile-login.gif"><img src="img/toptile-login.gif" border="0"></td>
<td><img src="img/topright-login.gif" border="0"></td></tr>
<tr><td background="img/midleft-login.gif"><img src="img/midleft-login.gif" border="0"></td>
<td width="100%" align="center" bgcolor="#dbdee3">
<table border=0 cellpadding='3' cellspacing='3' width="100%">
<?if($num_med){?>
<tr>
<td class="box" width=17%><b>Date</b></td>
<td class="box" width=30%><b>Clinic</b></td>
<td class="box" width=13%><b>Condition</b></td>
<td class="box" width=40%><b>Description</b></td>
</tr>
<? }
for ($i=1; $i<=$num_med; $i++){?>
<tr>
<td class="box"><?=$i.". ".$medical[$i][date]?></td>
<td class="box"><?=$medical[$i][clinic_name]?></td>
<td class="box"><?=$medical[$i][status]?></td>
<td class="box"><?=$medical[$i][description]?></td>
</tr>
</tr><tr>
<?}?>
</TABLE>
</td>
<td background="img/midright-login.gif"><img src="img/midright-login.gif" border="0"></td></tr>
<tr><td><img src="img/botleft-login.gif" border="0"></td>
<td background="img/bottile-login.gif"><img src="img/bottile-login.gif" border="0"></td>
<td><img src="img/botright-login.gif" border="0"></td></tr>
</table><br>
<!-- Process -->
<table border=0 cellpadding='0' cellspacing='0' width="100%">
<tr><td valign="top"><img src="img/addleft.gif" border="0"></td>
<td background="img/addtile.gif" width="100%"><b><a href="edit_process.php?Action=edit&applicant_id=<?echo$applicant_id?>">Process</a></b></td>
<td valign="top"><img src="img/addright.gif" border="0"></td></tr>
</table>
<table border="0" cellpadding="0" cellspacing="0" width=100%>
<tr><td><img src="img/topleft-login.gif" border="0"></td>
<td background="img/toptile-login.gif"><img src="img/toptile-login.gif" border="0"></td>
<td><img src="img/topright-login.gif" border="0"></td></tr>
<tr><td background="img/midleft-login.gif"><img src="img/midleft-login.gif" border="0"></td>
<td width="100%" align="center" bgcolor="#dbdee3">
<table border=0 cellpadding='3' cellspacing='3' width="100%">
<tr>
<td class="box" width=20%><b>Principal</b></td>
<td class="box"><?=($process[principal_id])? getfield("principal_name","principals","principal_id",$process[principal_id]) : ""?></td>
<td class="box" width=20%><b>Position</b></td>
<td class="box"><?=$process[position]?></td>
</tr>
<tr>
<td class="box"><b>Contract Duration</b></td>
<td class="box" colspan=3><?=$process[contract_duration]?></td>
</tr>
<tr>
<td class="box"><b>Basic Salary</b></td>
<td class="box"><?=$process[basic_salary]?></td>
<td class="box"><b>Food Allowance</b></td>
<td class="box"><?=$process[food_allowance]?></td>
</tr>
<tr>
<td class="box"><b>Passport No.</b></td>
<td class="box"><?=$process[passport]?></td>
<td class="box"><b>Place Issued</b></td>
<td class="box"><?=$process[pp_place_issued]?></td>
</tr>
<tr>
<td class="box"><b>Date Issued</b></td>
<td class="box"><?=$process[pp_date_issued]?></td>
<td class="box"><b>Date Expires</b></td>
<td class="box"><?=$process[pp_date_expires]?></td>
</tr>
<tr>
<td class="box"><b>TIN No.</b></td>
<td class="box"><?=$process[tin]?></td>
<td class="box"><b>NBI</b></td>
<td class="box"><?=$process[nbi]?></td>
</tr>
<tr>
<td class="box"><b>CLA No.</b></td>
<td class="box" width=30%><?=$process[cla]?></td>
<td class="box"><b>CLA Date</b></td>
<td class="box" width=20%><?=$process[cla_date]?></td>
</tr>
<tr>
<td class="box" width=20%><b>OEC No.</b></td>
<td class="box"><?=$process[OEC]?></td>
<td class="box"><b>MOFA/Category</b></td>
<td class="box"><?=$process[mofa]?></td>
</tr>
<tr>
<td class="box"><b>Job Accepted</b></td>
<td class="box"><?=$process[job_acceptance]?></td>
<td class="box"><b>Drug Test</b></td>
<td class="box"><?=$process[drug_test]?></td>
</tr>
<tr>
<td class="box"><b>PDOS</b></td>
<td class="box"><?=$process[pdos]?></td>
<td class="box"><b>Attest</b></td>
<td class="box"><?=$process[attest]?></td>
</tr>
<tr>
<td class="box"><b>Visa Filed</b></td>
<td class="box"><?=$process[visa_filed]?></td>
<td class="box"><b>Visa Released</b></td>
<td class="box"><?=$process[visa_released]?></td>
</tr>
<tr>
<td class="box"><b>POEA Filed</b></td>
<td class="box"><?=$process[poea_filed]?></td>
<td class="box"><b>POEA Released</b></td>
<td class="box"><?=$process[poea_released]?></td>
</tr>
<tr>
<td class="box"><b>Ticket</b></td>
<td class="box"><?=$process[ticket]?></td>
<td class="box"><b>Deployed</b></td>
<td class="box"><?=$process[deployment]?></td>
</tr>
<tr>
<td class="box" valign=top><b>Remarks</b></td>
<td class="box" colspan="4"><?=$process[remarks]?></td>
</tr>
</TABLE>
</td>
<td background="img/midright-login.gif"><img src="img/midright-login.gif" border="0"></td></tr>
<tr><td><img src="img/botleft-login.gif" border="0"></td>
<td background="img/bottile-login.gif"><img src="img/bottile-login.gif" border="0"></td>
<td><img src="img/botright-login.gif" border="0"></td></tr>
</table><br>
<!-- CV Sents -->
<table border=0 cellpadding='0' cellspacing='0' width="100%">
<tr><td valign="top"><img src="img/addleft.gif" border="0"></td>
<td background="img/addtile.gif" width="100%"><b><a href="edit_cvsent.php?Action=edit&applicant_id=<?echo$applicant_id?>">CV Sent</a></b></td>
<td valign="top"><img src="img/addright.gif" border="0"></td></tr>
</table>
<table border="0" cellpadding="0" cellspacing="0" width=100%>
<tr><td><img src="img/topleft-login.gif" border="0"></td>
<td background="img/toptile-login.gif"><img src="img/toptile-login.gif" border="0"></td>
<td><img src="img/topright-login.gif" border="0"></td></tr>
<tr><td background="img/midleft-login.gif"><img src="img/midleft-login.gif" border="0"></td>
<td width="100%" align="center" bgcolor="#dbdee3">
<table border=0 cellpadding='0' cellspacing='0' width="100%">
<tr>
<td>
<table width=100% border=0 cellpadding='3' cellspacing='3'>
<?if($num_cvsents){?>
<tr><td class="box"><b>Principal</td><td class="box" align=center><b>Job Order</td><td class="box" align=center><b>CV Sent Date</td></tr>
<?}
for ($i=1; $i<=$num_cvsents; $i++){
$jopos = getdata_one("job_order_id,position_id","jo_position","jo_pos_id",$cvsents[$i][jo_pos_id]);
?>
<tr>
<td class="box" valign=top><?=getfield("principal_name","principals","principal_id",$cvsents[$i][principal_id])?></td>
<td class="box" valign=top><?=@getfield("job_order_no","job_order","job_order_id",$jopos["job_order_id"])?> - <?=@getname($jopos["position_id"],"positions","position_id")?></td>
<td class="box" valign=top><?=dateformat($cvsents[$i][date])?></td>
</tr>
<?
unset($jopos);
}// end of for loop
?>
</table>
</td></tr>
</TABLE>
</td>
<td background="img/midright-login.gif"><img src="img/midright-login.gif" border="0"></td></tr>
<tr><td><img src="img/botleft-login.gif" border="0"></td>
<td background="img/bottile-login.gif"><img src="img/bottile-login.gif" border="0"></td>
<td><img src="img/botright-login.gif" border="0"></td></tr>
<!-- Complaints -->
<table border=0 cellpadding='0' cellspacing='0' width="100%"><br>
<tr><td valign="top"><img src="img/addleft.gif" border="0"></td>
<td background="img/addtile.gif" width="100%"><b><a href="edit_complaint.php?Action=edit&applicant_id=<?echo$applicant_id?>">Complaints</a></b></td>
<td valign="top"><img src="img/addright.gif" border="0"></td></tr>
</table>
<table border="0" cellpadding="0" cellspacing="0" width=100%>
<tr><td><img src="img/topleft-login.gif" border="0"></td>
<td background="img/toptile-login.gif"><img src="img/toptile-login.gif" border="0"></td>
<td><img src="img/topright-login.gif" border="0"></td></tr>
<tr><td background="img/midleft-login.gif"><img src="img/midleft-login.gif" border="0"></td>
<td width="100%" align="center" bgcolor="#dbdee3">
<table border=0 cellpadding='0' cellspacing='0' width="100%">
<tr>
<td>
<table width=100% border=0 cellpadding='3' cellspacing='3'>
<?
for ($i=1; $i<=$num_comp; $i++){?>
<tr>
<td class="box" width=20%><b>Complaint Date</b></td>
<td class="box" width=20%><?=$complaint[$i][complaint_date]?></td>
<td class="box" width=20%><b>Complaint</b></td>
<td class="box" width=40%><?=$complaint[$i][complaint]?></td>
</tr>
<tr>
<td class="box"><b>Remark</b></td>
<td class="box" colspan=3><?=$complaint[$i][remarks]?></td>
</tr>
<tr>
<td class="box"><b>Broker's Comment</b></td>
<td class="box" colspan=3><?=$complaint[$i][comment]?></td>
</tr>
<tr>
<td class="box"><b>Date Resolved</b></td>
<td class="box"><?=$complaint[$i][resolved_date]?> </td>
<td class="box"><b>Resolved by</b></td>
<td class="box"><?=$complaint[$i][resolvedby]?> </td>
</tr>
<tr><td colspan=5><hr width=100%></td></tr>
<? }// end of for loop
?>
</table>
</td></tr>
</TABLE>
</td>
<td background="img/midright-login.gif"><img src="img/midright-login.gif" border="0"></td></tr>
<tr><td><img src="img/botleft-login.gif" border="0"></td>
<td background="img/bottile-login.gif"><img src="img/bottile-login.gif" border="0"></td>
<td><img src="img/botright-login.gif" border="0"></td></tr>
</table>
</td></tr>
</table>
</td></tr>
</table>
</td></tr>
<?
do_html_footer();
?>