/home/mip/public_html_/old-website/employer/manage_job_order.php
<?
session_start();
require_once("func_all.php");
do_html_header("Job Order Manager");
if($job_order_id) $sqljoborder = "and job_order_id = '$job_order_id'";
if($jo_pos_id) $sqljopos = "and jo_pos_id = '$jo_pos_id'";
$stat = array("Open", "Close");
$job_orders = getdata("select * from job_order where 1 and status='Open' and principal_id = $myprincipalid and job_order_id in (select distinct(job_order_id) from jo_position) order by job_order_no asc");
$positions = getdata("select jo.jo_pos_id, pos.name from jo_position as jo, positions as pos where 1 and jo.position_id = pos.position_id and jo.job_order_id='$job_order_id' order by pos.name");
?>
<form action="manage_job_order.php" method="post">
<tr><td height="100%" align=center valign="top">
<table border=0 width=90% cellpadding='0' cellspacing='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="30%"> <b>Job Order Manager</b></td>
<td background="img/addtile.gif" width="70%" align="right">
<b>Job Order:</b>
<select name="job_order_id" id="job_order_id" onChange="load_position();">
<option value="">All</option>
<?selectcode($job_orders,$job_order_id,"job_order_id","job_order_no")?>
</select>
<b>Position:</b>
<select name="jo_pos_id" id="jo_pos_id">
<option value="">All</option>
<?selectcode($positions,$jo_pos_id,"jo_pos_id","name")?>
</select>
<input type="submit" value="Search" name="user" class="button">
</td>
<td valign="top"><img src="img/addright.gif" border="0"></td></tr>
</table>
</td></tr>
<tr><td valign="top">
<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 align=center width="15%"><b>Job Order No.</b></td>
<td align=center width="25%"><b>Position</b></td>
<td align=center width="12%"><b>Required</b></td>
<td align=center width="12%"><b>Selected</b></td>
<td align=center width="12%"><b>On Process</b></td>
<td align=center width="12%"><b>Deployed</b></td>
</tr>
<?
$job_order = getdata("select * from job_order where 1 and status='Open' and principal_id = $myprincipalid $sqljoborder order by date desc");
echo mysql_error();
$num_jo = count($job_order);
for ($count = 1; $count <= $num_jo; ++$count) {
$jo_positions = getdata("select * from jo_position Inner Join positions ON jo_position.position_id = positions.position_id where job_order_id = ".$job_order[$count]["job_order_id"]." $sqljopos ORDER BY positions.name ASC");
$num_jo_positions = count($jo_positions);
for($j=1;$j<=$num_jo_positions;$j++) {
$required = $jo_positions[$j]['no_of_male'] + $jo_positions[$j]['no_of_female'];
$num_applicants_selected = get_count_deployed("lineup","jo_pos_id",$jo_positions[$j]['jo_pos_id'],"and lineup.lineup_status_id = '3'"); // 3 = Selected
$num_applicants_onprocess = get_count_deployed("process","jo_pos_id",$jo_positions[$j]['jo_pos_id'],"and personal.status = 'On Process'");
$num_applicants_deployed = get_count_deployed("process","jo_pos_id",$jo_positions[$j]['jo_pos_id'],"and personal.status = 'Deployed'");
print "<tr>";
if($j==1) print "<td class='box'><b>".$job_order[$count]['job_order_no']."</b></td>";
else print "<td></td>";
print "<td class='box'>".getname($jo_positions[$j]['position_id'],"positions","position_id")."</td>";
print "<td align=center class='box'>".$required."</td>";
if($num_applicants_selected>0){
print "<td class='box' align=center>";
print "<a href='report_lineup_applicants.php?jo_pos_id=".$jo_positions[$j]['jo_pos_id']."' target='_blank'>";
print number_format($num_applicants_selected);
print "</td>";
}else{
print "<td class='box' align=center>0</td>";
}
if($num_applicants_onprocess>0){
print "<td class='box' align=center>";
print "<a href='report_jo_applicants.php?status=on process&jo_pos_id=".$jo_positions[$j]['jo_pos_id']."' target='_blank'>";
print number_format($num_applicants_onprocess);
print "</td>";
}else{
print "<td class='box' align=center>0</td>";
}
if($num_applicants_deployed>0){
print "<td class='box' align=center>";
print "<a href='report_jo_applicants.php?status=deployed&jo_pos_id=".$jo_positions[$j]['jo_pos_id']."' target='_blank'>";
print number_format($num_applicants_deployed);
print "</td>";
}else{
print "<td class='box' align=center>0</td>";
}
print "</tr>";
}// end of jo positions
}// end of for loop for the job order
?>
</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>
</form>
<?
do_html_footer();
?>