/home/mip/public_html_/old-website/employer/report_jo_applicants.php
<?
session_start();
require_once("func_all.php");

$jo_pos = getdata_one("*","jo_position","jo_pos_id",$jo_pos_id);
$jo = getdata_one("*","job_order","job_order_id",$jo_pos['job_order_id']);
do_report_header("Applicant List for Job Order No.".$jo["job_order_no"]." (".getname($jo_pos[position_id],"positions","position_id").")");

if($status=='deployed') $status = 'Deployed';
if($status=='on process') $status = 'On Process';

$applicant = getdata("select * from process, personal where 1 and process.applicant_id=personal.applicant_id and process.jo_pos_id = '$jo_pos_id' and personal.status = '$status'");
$num_applicant = count($applicant);   

$num = getdata("select COUNT(jo_pos_id) AS n from process, personal where process.applicant_id = personal.applicant_id and process.jo_pos_id='$jo_pos_id' and personal.status = '$status'");
?> 	
<tr><td height="100%" align=center valign="top">
	<table align=center cellpadding='2' cellspacing='2' border=0 width=100%>
	<tr><td>
		<table width=100%><tr>
		<td align=center><font size=4>APPLICANT LIST REPORT</font></td>
		<td align=right width=15%>[<a href="#" onclick="window.close();opener.focus();">Close Window</a>]</td>
		</tr></table>
	</td></tr>		
	<tr><td bgcolor="#f1f1f1">
		<table border=0>
			<tr><td><b>Principal</b></td><td colspan="5">: <?=getname($jo[principal_id],"principals","principal_id")?></td></tr>
			<tr><td><b>Job Order No.</b></td><td colspan="5">: <?=$jo[job_order_no]?></td></tr>
			<tr><td><b>Position</b></td><td colspan="5">: <?=getname($jo_pos['position_id'],"positions","position_id")?></td></tr>
			<tr><td><b>Status</b></td><td colspan="5">: <?=$status?></td></tr>
			<tr>
			<td><b>Total Slots</b></td><td>: <? echo $total=$jo_pos[no_of_coed]+$jo_pos[no_of_female]+$jo_pos[no_of_male]; ?>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</td>
			<td><b>Filled-in Slots</b></td><td>: <?=$num[1][n]?>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</td>
			<td><b>Available Slots</b></td><td>: <?=diff($total,$num[1][n])?></td>
			</tr>
		</table>
	</td></tr>	 
	<? if($num_applicant){?>
	<tr><td>
		<table width=100% class="report">
		<tr>
			<td class=reporthead width=1%>&nbsp;</td>
			<td class=reporthead width=15%><b>APPLICANT ID</b></td>
			<td class=reporthead width=25%><b>NAME</b></td>
			<td class=reporthead width=6% align=center><b>SEX</b></td>
			<td class=reporthead width=7% align=center><b>AGE</b></td>			
			<!--<td class=reporthead width=9% align=center><b>STATUS</td>-->		
			<td class=reporthead width=15%><b>LATEST REMARKS</b></td>								 								 
		</tr>		 
		<? 
		for($i=1;$i<=$num_applicant;$i++){ 
		$data = getdata("select remarks,time from applicant_remarks where applicant_id = '".$applicant[$i]["applicant_id"]."' order by time desc limit 0,1");
		?>
		<tr>
		<td class=report valign=top width=1%><?=$i?>.</td>
		<td class=report valign=top><a href="report_resume.php?applicant_id=<?=$applicant[$i][applicant_id]?>&employer=1" target="_blank"><?=$applicant[$i][applicant_id]?></a></td>
		<td class=report valign=top><?=get_applicantname($applicant[$i][applicant_id])?></td>
		<td class=report valign=top align=center><?=getfield("sex","personal","applicant_id",$applicant[$i][applicant_id])?></td>
		<td class=report valign=top align=center><?=get_age(getfield("birthdate","personal","applicant_id",$applicant[$i][applicant_id]))?></td>
		<!--<td class=report valign=top><?=$applicant[$i]["status"]?></td>-->	
		<td class=report valign=top><?=nl2br($data[1][0])?></U></td>
		</tr>
		<? } ?>
		</table>
	</td></tr>
	<? }// end of if there are applicants ?>
	</table>		
</td></tr>
<? 
do_report_footer();
?>