/home/mip/www/img/credit/datatables/report_jo_applicants.php.tar
home/mip/public_html_/old-website/employer/report_jo_applicants.php 0000644 00000007060 15152100716 0021727 0 ustar 00 <?
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]; ?> </td>
<td><b>Filled-in Slots</b></td><td>: <?=$num[1][n]?> </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%> </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();
?>
