<?
session_start();
require_once("func_all.php");

	do_report_header1("Status List Report Taiwan-$status");
	
	if($country){
	    $country_id = getfield("country_id", "country", "name", "Taiwan");
	}
	if ($country_id){
	      $sql_country = " AND personal.country_id =" . $country_id;
	      $getcountry = getfield("name", "country", "country_id", $country_id);
	}
	
	if ($status){ 
	      $sql_status = "AND ((personal.status='$status' AND personal.applicant_id1 <> '') OR (personal.status2='$status' AND personal.applicant_id2 <> ''))";	
	}
	?>   
	<tr><td valign="top" height="100%" align=center width=100%>
      <table border=0 cellpadding="1" cellspacing="1" width=100%>
			<tr>
			      <td>
						<table border=0 cellpading=0 cellspacing=0>
						<tr>
						<td align=left colspan=2><font size=3 face="Arial Narrow"><b>MIP INTERNATIONAL MANPOWER SERVICES</b></font></td>
						</tr>
						<tr>
		        <td align=left colspan=2><font size=3 face="Arial Narrow"><b><?=strtoupper($getcountry)?><?=($status)?" - ". strtoupper($status):""?></b></font></td>
						</tr>
						<?
						$principal_name = getfield("name", "principals", "principal_id", $principal);
						if($principal_name){?>
						<tr>
						<td width=100%>
						    <table border=0 cellpadding=0 cellspacing=0>
								<tr> 
						    <td align=left><font size=3 face="Arial Narrow"><b>Name of Principal: </b>&nbsp;</font></td>
						    <td align=left class='line'><font size=3 face="Arial Narrow"><b><?=$principal_name?></b></font></td>
						    </tr>
								</table>
								
						</td width=100%>
						</tr>
						<?}?>
						<tr>
						<td>
						    <table border=0 cellpadding=0 cellspacing=0>
								<tr> 
						    <td align=left><font size=3 face="Arial Narrow"><b>As of</b>&nbsp;</font></td>
						    <td align=left class='line'><font size=3 face="Arial Narrow"><b><?=dateformat1($sqltoday,"F d, Y")?></b></font></td>
						    </tr>
								</table>
								<br><br>
						</td>
						</tr>
						</table>
			</tr>		 	
	<?		
	if ($myprincipalid) $sql_broker = "AND brokers.broker_id='$broker'";
	if($principal){
	    $sql_principal = " AND process.principal_id = " . $principal;
			
	}
	if ($order) $sql_order = " ORDER BY $order_by ";
	
	
	if ($from_month || $from_day || $from_year || $to_month || $to_day || $to_year){ 
		 $from_apply_date = "$from_year-$from_month-$from_day";
		 $to_apply_date = "$to_year-$to_month-$to_day";
		 $sql_apply_date = "AND personal.apply_date >= '$from_apply_date' AND personal.apply_date <= '$to_apply_date' ";
		 $order_by = "personal.apply_date";
  }

	$nowunix= time();
	$sql = "SELECT personal.applicant_id,														
														(concat(personal.lname,', ',personal.fname,' ',personal.mname)) as name, 
														personal.country_id,
														personal.apply_date,
	                          personal.birthdate,
														personal.cellphone,
														personal.civil_status,
														personal.applicant_id1,
														personal.applicant_id2,
														personal.picture_body,
														personal.PNBI,
														personal.PA,
														personal.A_BC,
														personal.video,
														personal.remarks,
														personal.picture,
														personal.height1,personal.height2,
														personal.weight1,personal.weight2,
														process.pta_number,	
														personal.GOV,
														personal.DFA,	
														personal.TR,
														process.pdos,	
														personal.medical_d,
														process.visa_filed,
														process.visa_released,
														process.poea_filed,
														process.poea_released,
														process.deployment,
														process.contract_duration,	
														process.date_hired,
														process.jo_received,
														process.cla_date_exp,
														process.principal_id,	
														process.passport,																		
														process.nbi,
														process.poea_filed2,
														process.poea_released2,	
														process.teco_filed,
														process.teco_released,
														process.tentative_departure,
														process.remarks,											
														personal.position_id1											
										 FROM   personal left join  process on personal.applicant_id=process.applicant_id
										 left join principals on process.principal_id = principals.principal_id
										 left join brokers on principals.broker_id = brokers.broker_id
					 					 WHERE  1=1
										 
										 $sql_broker		
										 $sql_principal 								
										 $sql_status										 										 
										 $sql_country
										 ORDER BY personal.applicant_id															
										 ";
  $result = getdata($sql);
										 
  $found = count($result);
  
 
if($found){  

print "<tr><td><table class='report'>";	 	  			
			print "<tr>";
   		print "<td class='reporthead' valign='top' rowspan=2><b>No.</b></td>";
			print "<td class='reporthead' align=center valign='top' rowspan=2><b>File No.</td>";
			print "<td class='reporthead' align=center valign='top' rowspan=2><b>Employer</td>";
			print "<td class='reporthead' align=center valign='top' rowspan=2><b>Code</td>";
			print "<td class='reporthead' align=center valign='top' rowspan=2><b>Employee</td>";
			print "<td class='reporthead' align=center valign='top' rowspan=2><b>Date<br>Hired</td>";
			print "<td class='reporthead' align=center valign='top' rowspan=2><b>JO Received</td>";
			print "<td class='reporthead' align=center valign='top' colspan=2><b>ACCREDITATION</td>";
			print "<td class='reporthead' align=center valign='top' rowspan=2><b>CLA<br>Expired</td>";
			//print "<td class='reporthead' align=center valign='top' rowspan=2><b>PPT</td>";
			print "<td class='reporthead' align=center valign='top' rowspan=2><b>NBI</td>";
			print "<td class='reporthead' align=center valign='top' rowspan=2><b>MED</td>";
			print "<td class='reporthead' align=center valign='top' rowspan=2><b>GOV</td>";
			print "<td class='reporthead' walign=center valign='top'rowspan=2><b>DFA</td>";		
			print "<td class='reporthead' align=center valign='top' rowspan=2><b>TR</td>";
			print "<td class='reporthead' align=center valign='top' rowspan=2><b>PDOS</td>";
			print "<td class='reporthead' align=center valign='top' rowspan=2><b>PA</td>";
			print "<td class='reporthead' align=center valign='top' rowspan=2><b>B.C</td>";		
			print "<td class='reporthead' align=center valign='top' colspan=2><b>ATTESTATION</td>";
			//print "<td class='reporthead' align=center valign='top' colspan=2><b>TECO</td>";		
			print "<td class='reporthead' align=center valign='top' rowspan=2><b>Tent. Dep</td>";
			print "<td class='reporthead' align=center valign='top' rowspan=2><b>REMARKS</td>";																
			print "</tr>";
			print "<tr>";	
			for($q=1;$q<=2;$q++){
			print "<td class='reporthead' align=center valign='top'><b>Filed</td>";
			print "<td class='reporthead' align=center valign='top'><b>Released</td>";
			}
			print "</tr>";
			print "<tr height=3><td colspan=23 class='reporthead'></td></tr>";
	    print "<tr>";
			for($q=1;$q<=22;$q++){
			print "<td class='report'>&nbsp;</td>";
			}
			print "</tr>";
			for($i=1;$i<=$found;$i++){ 
				$applicant_id = $result[$i]["applicant_id"];
				$principal_id = getfield("principal_id","process","applicant_id",$applicant_id);
			  
				$sql = "Select SUM(total_years) as total_years from employment where applicant_id=". $applicant_id;
				$emp = getdata($sql);
				$emp_num = count($emp);
				
				$sql = "Select education from education where applicant_id=" . $applicant_id . " AND education='licentiate'";															
				$hi_educ = getdata($sql);
				$highest_educ = $hi_educ[1]["education"];
				if($highest_educ==""){
				$sql = "Select education from education where applicant_id=" . $applicant_id . " AND education='Post Graduate'";															
				$hi_educ = getdata($sql);
				$highest_educ = $hi_educ[1]["education"];
				}
				if($highest_educ==""){
				$sql = "Select education from education where applicant_id=" . $applicant_id . " AND education='College/University'";															
				$hi_educ = getdata($sql);
				$highest_educ = $hi_educ[1]["education"];
				}
				if($highest_educ==""){
				$sql = "Select education from education where applicant_id=" . $applicant_id . " AND education='Training/Seminar'";															
				$hi_educ = getdata($sql);
				$highest_educ = $hi_educ[1]["education"];
				}
				if($highest_educ==""){
				$sql = "Select education from education where applicant_id=" . $applicant_id . " AND education='Vocational'";															
				$hi_educ = getdata($sql);
				$highest_educ = $hi_educ[1]["education"];
				}
				if($highest_educ==""){
				$sql = "Select education from education where applicant_id=" . $applicant_id . " AND education='Secondary'";															
				$hi_educ = getdata($sql);
				$highest_educ = $hi_educ[1]["education"];
				}
				if($highest_educ==""){
				$sql = "Select education from education where applicant_id=" . $applicant_id . " AND education='Elementary'";															
				$hi_educ = getdata($sql);
				$highest_educ = $hi_educ[1]["education"];
				}
				print "<tr>";
    		print "<td valign=top class=report align=center>$i</td>";
				print "<td valign=top class=report>".$applicant_id ."</td>";
				print "<td valign=top class=report>". getfield("name", "principals", "principal_id", $result[$i]["principal_id"]) . "</td>";
				print "<td valign=top class=report>".$result[$i]["applicant_id1"]."</td>";    	
				print "<td valign=top class=report><a href=\"report_applicant2.php?applicant_id=".$applicant_id."\" target=\"_blank\">".$result[$i]["name"]."</a></td>";								
				print "<td valign=top class=report>".dateformat1($result[$i]["date_hired"],"m/d/y")."</td>"; 
				print "<td valign=top class=report>".dateformat1($result[$i]["jo_received"],"m/d/y")."</td>";    
				
				
				$sql = "Select * from payment as p inner join payment_detail as pd 
				        on p.payment_id = pd.payment_id
								where p.applicant_id =" . $applicant_id;
				 
				$payment=getdata($sql);
				$payment_count = count($payment);
							
				$training =  getdata("Select * from training where applicant_id ='" . $applicant_id ."'");	
				$training_count = count($training);
				
				$medical =  getdata("Select * from medical where applicant_id ='" . $applicant_id ."'");	
				$medical_count = count($medical);
				     	  				
    						
				print "<td valign=top class=report align=center>";
				print dateformat1($result[$i]["poea_filed"],"m/d/y"); 				     	 				
				print "</td>";					
				
				print "<td valign=top class=report align=center>";
				print dateformat1($result[$i]["poea_released"],"m/d/y"); 				     	 				
				print "</td>";	
				
				print "<td valign=top class=report align=center>";
				print dateformat1($result[$i]["cla_date_exp"],"m/d/y"); 				     	 				
				print "</td>";	
				
				//print "<td valign=top class=report align=center>";
				//if($result[$i]["passport"]){print "ok";}  				     	 								
				//print "</td>";
				
				print "<td valign=top class=report align=center>";
				if($result[$i]["PNBI"]){print "ok";}  				     	 								
				print "</td>";
				
				
				print "<td valign=top class=report align=center>";
				//if($medical_count > 0){print "ok";}  				     	 								
				if($result[$i]["medical_d"]){print "ok";}  
				print "</td>";
				
				print "<td valign=top class=report align=center>";
				if($result[$i]["GOV"]==1){print "ok";}  				     	 								
				print "</td>";
				
				print "<td valign=top class=report align=center>";
				if($result[$i]["DFA"]==1){print "ok";}  				     	 								
				print "</td>";
				
				print "<td valign=top class=report align=center>";
				if($result[$i]["TR"]==1){print "ok";}  				     	 								
				print "</td>";
				
				print "<td valign=top class=report align=center>";
				if($result[$i]["pdos"]!='0000-00-00'){print "ok";}  				     	 								
				print "</td>";
				
				print "<td valign=top class=report align=center>";
				if($result[$i]["PA"] ==1){print "ok";}  				     	 								
				print "</td>";
				
				print "<td valign=top class=report align=center>";
				if($result[$i]["A_BC"] ==1){print "ok";}  				     	 								
				print "</td>";
				
				print "<td valign=top class=report align=center>";
				print dateformat1($result[$i]["poea_filed2"],"m/d/y");  				     	 								
				print "</td>";
				
				print "<td valign=top class=report align=center>";
				print dateformat1($result[$i]["poea_released2"],"m/d/y");  				     	 								
				print "</td>";
				
				
				/*print "<td valign=top class=report align=center>";
				print dateformat1($result[$i]["teco_filed"],"m/d/y");  				     	 								
				print "</td>";
				
				print "<td valign=top class=report align=center>";
				print dateformat1($result[$i]["teco_released"],"m/d/y");  				     	 								
				print "</td>";*/
				
				print "<td valign=top class=report align=center>";
				print dateformat1($result[$i]["tentative_departure"],"m/d/y");  				     	 								
				print "</td>";
				
				
				
				print "<td valign=top class=report>". $result[$i]["remarks"] . "</td>"; 
								
				print "</tr>";
      } // end of for loop

print "</table></td></tr>";			
} // end of if there is a result in found	
else{ // if there is no result
?>
   </form>

	 <tr><td width=100% align="center">
	 <br><br>
   <br><br><br><strong>No Records Found... </strong>
   </td></tr>
	 <tr><td align="center"><br>
	 <form>
	 <input type=button value="Close Window" onclick="window.close()">
	 </form>
	 </td></tr>
	 
<?
}// end of if there is no result
?>

</table>
</td></tr>

<?
do_report_footer();
?>

• [D] backup
• [D] img
• [F] autotab.js
  Delete
• [F] common_msg.inc
  Delete
• [F] config.php
  Delete
• [F] display_video.php
  Delete
• [F] edit_configuration.php
  Delete
• [F] edit_password.php
  Delete
• [F] edit_source_survey.php
  Delete
• [F] email.php
  Delete
• [F] func_all.php
  Delete
• [F] func_data_validation.php
  Delete
• [F] func_proc.php
  Delete
• [F] func_select.php
  Delete
• [F] func_select_codes.php
  Delete
• [F] index.php
  Delete
• [F] list_personal.inc
  Delete
• [F] login.php
  Delete
• [F] logout.php
  Delete
• [F] mainpage.php
  Delete
• [F] mainpage_standard.php
  Delete
• [F] manage_job_order.php
  Delete
• [F] manage_job_order1.php
  Delete
• [F] menu.css
  Delete
• [F] menu.js
  Delete
• [F] my_profile.php
  Delete
• [F] report_applicant.php
  Delete
• [F] report_applicant2.php
  Delete
• [F] report_applicant3.php
  Delete
• [F] report_applicant_dubai.php
  Delete
• [F] report_applicant_hongkong.php
  Delete
• [F] report_applicant_hongkong2.php
  Delete
• [F] report_applicant_taiwan.php
  Delete
• [F] report_applicant_taiwan2.php
  Delete
• [F] report_applicant_version2.php
  Delete
• [F] report_jo_applicants.php
  Delete
• [F] report_onProcess_taiwan.php
  Delete
• [F] report_StatusList.php
  Delete
• [F] sqladd.php
  Delete
• [F] sqldelete.php
  Delete
• [F] sqlupdate.php
  Delete
• [F] video_test.php
  Delete