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

do_html_header("Job Order Manager");
$stat = array("Open", "Close");	


?>	
		<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' 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="#dbdee3">
				<table border=1 cellpadding='3' cellspacing='3' width="100%">
				
				<tr>
						    <td class='box'><b>Job Order No.</td>
								<td align=center class='box'><b>Position</b></td>								
     						<td align=center class='box'><b>Male</b></td>
								<td align=center class='box'><b>Female</b></td>
     						<td align=center class='box'><b>M/F</b></td>
								<!--
								<td align=center><b>Age</b></td>
								<td align=center><b>Civil Status</b></td>
								<td align=center><b>Posting Date</b></td>
								<td align=center><b>Expiry Date</b></td>								
								-->
								<td align=center class='box'><b>Proposed<br>Wage</b></td>
								<td align=center class='box'><b>No.of Applicants</b></td>								
								<td class='box'>&nbsp;</td>								
				</tr>
<?   
    $sql = "select * from job_order where 1 and status='Open' and principal_id = $myprincipalid order by date desc";		                      		                      																										 													
		$job_order = getdata($sql);
		echo mysql_error();
		$num_jo = count($job_order);
		
		for ($count = 1; $count <= $num_jo; ++$count)
    {		
		$sql = "select * from jo_position where job_order_id = ".$job_order[$count]["job_order_id"];
		$jo_positions = getdata($sql);
		$num_jo_positions = count($jo_positions);       
   
	  	for($j=1;$j<=$num_jo_positions;$j++){
			    /*
					if(!$jo_positions[$j][min_age] && !$jo_positions[$j][max_age]) $age = "any";
					else{
						  $age = $jo_positions[$j][min_age];
						  if(!$jo_positions[$j][max_age]) $age .= " and above";
							else $age .= " - ".$jo_positions[$j][max_age];
					}
					*/
					$sql = "Select pro.*, per.status 
					        from process as pro, personal as per 
									where pro.applicant_id=per.applicant_id
									and per.status = 'For Selection'
									and pro.jo_pos_id=" . $jo_positions[$j]['jo_pos_id'];
					
					$num_applicants = count(getdata($sql));				
					//$num_applicants = get_count("process","jo_pos_id",$jo_positions[$j]['jo_pos_id']);	
									
				  print "<tr>";
					if($j==1) print "<td class='box'><b>".$job_order[$count]['job_order_no']."</b><br>Date : ".dateformat($job_order[$count]['date'])."</td>";
					else print "<td class='box'>&nbsp;</td>";		
					print "<td class='box'>".getname($jo_positions[$j]['position_id'],"positions","position_id")."</td>";
					print "<td align=right class='box'>".$jo_positions[$j]['no_of_male']."</td>";
					print "<td align=right class='box'>".$jo_positions[$j]['no_of_female']."</td>";
					print "<td align=right class='box'>".$jo_positions[$j]['no_of_coed']."</td>";
					/*
					print "<td align=center class='box'>".$age."</td>";
					print "<td align=center class='box'>";
					print ($jo_positions[$j]['civil_status'])? $jo_positions[$j]['civil_status'] : "any";
					print "</td>";
					print "<td class='box'>".dateformat($jo_positions[$j]['posting_date'])."</td>";
					print "<td class='box'>".dateformat($jo_positions[$j]['expiry_date'])."</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'>" : ""; 
					if(number_format($num_applicants)==0){
					print number_format($num_applicants);
					}else{
					print "[" . number_format($num_applicants) . "]";
					}
					print "</td>";
					print "<td class='box' align='center'>[<a href='report_jo_applicants.php?jo_pos_id=".$jo_positions[$j]['jo_pos_id']."' target='_blank'>View Applicants</a>]</td>";															
					print "</tr>";
					
			}// end of jo positions						
			print "<tr><td colspan=8 class='box'>&nbsp;</td></tr>";
   }// 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();
?>