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

do_html_header("Job Order Manager");
$stat = array("Open", "Close");		
$principal = getdata("select * from principals where broker_id =" . $myprincipalid);
$num_principal = count($principal);

?>	

		<form action='manage_job_order.php' method=post>	
		<tr><td height="100%" align=center valign="top">
		<table border=0 width=100% cellpadding='0' cellspacing='4'>
		<tr><td valign="top"><br>
		<table border=0 cellpadding='0' cellspacing='0'>
					<tr>
					<td>
					<b>Select Principal :</b>
					<select name="principal_id" onchange="form.submit()">
					<option value="0">---Select principal---
					<? if($principal_id =="All"){ ?>
					<option value="All" selected>All
					<?selectcode($principal, $principal_id, "principal_id","name")?></select>
					<?}else{?>
					<option value="All">All
					<?selectcode($principal, $principal_id, "principal_id","name")?></select>
					<?}?>
					
					
					</td></tr>
					</table>
					<br>
					<?if($principal_id){
					?>
					<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>Job Orders</td></td>
					<td valign="top"><img src="img/addright.gif" border="0"></td></tr>
					</table>
    </td></tr>
		
		<tr>
		  <td><b><font color=red>Note:</font> Pls. click on the No. of Applicants to view the list of applicants.</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="#f1f1f1"><!--dbdee3-#d4d0c8-->
				<table border=1 cellpadding='3' cellspacing='3' width="100%">
				
				
<?   
//$myprincipalid 
if($principal_id == "All"){
    $principal_sql ="";
}elseif($principal_id){
    $principal_sql = " AND principal_id =" . $principal_id;
}


$sql ="select distinct(pr.principal_id) from principals as pr 
					 where 1=1						
					 $principal_sql
					 and pr.broker_id=". $myprincipalid ;
											 
		$arr_principal = getdata($sql);
		echo mysql_error();
		$num_principal = count($arr_principal);
		
		for ($count = 1; $count <= $num_principal; ++$count)
    {		
		
		$sql = "select jp.*, jo.* from job_order as jo inner join jo_position as jp on jo.job_order_id = jp.job_order_id
				 	 where jo.principal_id =" . $arr_principal[$count][principal_id] .
					 " and jo.status = 'Open'";
		$jo_positions = getdata($sql);
		$num_jo_positions = count($jo_positions);
		echo "<br>";
		       
   print "<tr>";
					print "<td colspan=8 class='box_hlight'><b>". strtoupper(getfield("name", "principals", "principal_id", $arr_principal[$count][principal_id])) . "</b></td>";				
				  print"</tr>"; 
	if($num_jo_positions != 0){?>
	
	<tr bgcolor="#f1f1f1">
						    <td><b>Job Order No.</td>
								<td><b>Position</b></td>								
     						<td align=center><b>Male</b></td>
								<td align=center><b>Female</b></td>
     						<td align=center><b>M/F</b></td>
							
								<td align=right><b>Proposed<br>Wage</b></td>
								<td align=right><b>No.of Applicants</b></td>								
								<td>&nbsp;</td>								
				</tr>
		
				<?}
	  	for($j=1;$j<=$num_jo_positions;$j++){
			                               // ( $table,    $field=1,  $id=1,   $and="")
					//$num_applicants = get_count("process","jo_pos_id",$jo_positions[$j]['jo_pos_id']);	
					
					$sql = "Select process.*, personal.status from process, personal where 
					                                 personal.applicant_id = process.applicant_id
																					 and personal.status='For Selection'
																					 and process.jo_pos_id=" . $jo_positions[$j]['jo_pos_id'];
					
					$num_applicants =count(getdata($sql));
																		 
					
					print "<tr>";
					if($j==1) print "<td class='box' valign='top'><b>".$jo_positions[$j]['job_order_no']."</b><br>Date : ".dateformat($jo_positions[$j]['date'])."</td>";
					else print "<td></td>";		
					print "<td class='box' valign='top'>".getname($jo_positions[$j]['position_id'],"positions","position_id")."</td>";
					print "<td align=middle valign='top' class='box'>".$jo_positions[$j]['no_of_male']."</td>";
					print "<td align=middle valign='top' class='box'>".$jo_positions[$j]['no_of_female']."</td>";
					print "<td align=middle valign='top' class='box'>".$jo_positions[$j]['no_of_coed']."</td>";
				
					print "<td align=right class='box'>".$jo_positions[$j]['wage']."</td>";
					print "<td class='box' align=center>";
					print ($num_applicants>0)? "<a href='report_jo_applicants.php?jo_pos_id=".$jo_positions[$j]['jo_pos_id']."' target='_blank'>" : ""; 
					print number_format($num_applicants);
					print "</td>";
					print "<td class='box' align='center'>";
					if($num_applicants>0){
					    print "[<a href='report_jo_applicants.php?jo_pos_id=".$jo_positions[$j]['jo_pos_id']."' target='_blank'>View Applicants</a>]";
					}															
					print "</td>";
					print "</tr>";
					print "<tr><td colspan=8>&nbsp;</td></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();
?>