<?
session_start();
require_once("func_all.php");	
//	$company_logo = getfield("agency_logo","company",1,1);
	$applicant = getdata_one("*","personal","applicant_id","$applicant_id"); 
  
	$version = (!$employer)? 'Agency' : 'Employer';
	do_report_header2b("Information Report ($version Version) - " . $applicant['fname'].' '.$applicant['mname'].' '.$applicant['lname']);
			
	$sex = $applicant[sex];
	if($sex=="F") $sex="Female"; else $sex="Male"; 
	
    $education = getdata("select * from education where applicant_id='$applicant_id' order by to_date desc");
	$num_educ = count($education);
	
	$licenses = getdata("select * from licenses where applicant_id='$applicant_id' order by license asc");
	$num_licenses = count($licenses);	
	
	$employment = getdata("select *,DATE_FORMAT(from_date,'%b %Y') AS frm_date, IF(to_date,DATE_FORMAT(to_date,'%b %Y'),'PRESENT') as t_date from employment where applicant_id='$applicant_id' order by from_date desc");
	$num_emp = count($employment);
	
	$skills = getdata("select * from skills where applicant_id='$applicant_id' order by skill asc");
	$num_skills = count($skills);
	
	$training = getdata("select * from training where applicant_id='$applicant_id' order by title asc");
	$num_train = count($training);

	
?> 	
<tr><td height="100%" align=center valign="top">
<table align=center cellpadding='2' cellspacing='2' width=100% border=0>
<tr>
		<td>
				<table width=100%>
				<tr>
						<td valign="top">
						
						<table width="100%">  
				    <tr>
								<td class="resumehighlight"><b><?=$applicant[fname].' '.$applicant[mname].' '.$applicant[lname]?></td>
						</tr>		
						<?if(!$employer){ // not for employer						
						?>
						<tr>
								<td><?=$applicant[address1]?></td>
						</tr>
						<?
						if($applicant[cellphone]){
						    echo '<tr>' .
										 '<td>Cellphone: ' . $applicant[cellphone] . '</td>' .
										 '</tr>';
						}
						if($applicant[email]){
						    echo '<tr>' .
										 '<td>Email Add: <a href="mailto:'. $applicant[email] .'">' . $applicant[email] . '</a></td>' .
										 '</tr>';
						}
						if($applicant[home_phone]){
						    echo '<tr>' .
										 '<td>Tel [Home]: ' . $applicant[home_phone] . '</td>' .
										 '</tr>';
						}
						if($applicant[office_phone]){
						    echo '<tr>' .
										 '<td>Tel [Office]: ' . $applicant[office_phone] . '</td>' .
										 '</tr>';
						}
						}// not for employer
						?>
						<tr>
						    <td>Position Applying For: <b><?=getname($applicant[position_id1],"positions","position_id")?>
								<?
								if($applicant[position1_yrsofexp] || $applicant[position1_mosofexp]){
								    echo '&nbsp;Local:&nbsp;(';
										echo ($applicant[position1_yrsofexp])? $applicant[position1_yrsofexp]." yrs" : "";
										echo ($applicant[position1_yrsofexp] && $applicant[position1_mosofexp])? " & " : "";
										echo ($applicant[position1_mosofexp])? $applicant[position1_mosofexp]." mos" : "";
										echo ')';
								}								
								?>
								<?
								if($applicant[position1_yrsofexp_abroad] || $applicant[position1_mosofexp_abroad]){
								    echo '&nbsp;Abroad:&nbsp;(';
										echo ($applicant[position1_yrsofexp_abroad])? $applicant[position1_yrsofexp_abroad]." yrs" : "";
										echo ($applicant[position1_yrsofexp_abroad] && $applicant[position1_mosofexp_abroad])? " & " : "";
										echo ($applicant[position1_mosofexp_abroad])? $applicant[position1_mosofexp_abroad]." mos" : "";
										echo ')';
								}								
								?>
								</td>						
						</tr>
						<?if($applicant[position_id2]){?>
						<tr>
								<td>Position Applying For (2nd Choice): <b><?=getname($applicant[position_id2],"positions","position_id")?>
								<?
								if($applicant[position2_yrsofexp] || $applicant[position2_mosofexp]){
								    echo '&nbsp;Local:&nbsp;(';
										echo ($applicant[position2_yrsofexp])? $applicant[position2_yrsofexp]." yrs" : "";
										echo ($applicant[position2_yrsofexp] && $applicant[position2_mosofexp])? " & " : "";
										echo ($applicant[position2_mosofexp])? $applicant[position2_mosofexp]." mos" : "";
										echo ')';
								}								
								?>		
								<?
								if($applicant[position2_yrsofexp_abroad] || $applicant[position2_mosofexp_abroad]){
								    echo '&nbsp;Abroad:&nbsp;(';
										echo ($applicant[position2_yrsofexp_abroad])? $applicant[position2_yrsofexp_abroad]." yrs" : "";
										echo ($applicant[position2_yrsofexp_abroad] && $applicant[position2_mosofexp_abroad])? " & " : "";
										echo ($applicant[position2_mosofexp_abroad])? $applicant[position2_mosofexp_abroad]." mos" : "";
										echo ')';
								}								
								?>					
						</tr>						
						<?}?>
						</table>
						</td>
						<td align=right valign="top">
						<?
						if(strstr($applicant[picture],"www.workabroad.ph")) {
							print resize_pic1(150,150,$applicant[picture],"","","","1");
						} else { 
							if (is_file($pic_dir.$applicant[picture])) {
								print resize_pic1(150,150,$pic_dir.$applicant[picture],"","","","1");
							} else {
								print resize_pic1(150,150,$pic_dir."nophoto.jpg","","","","1");
							}	
						}	
						?>
						
						</td>
				</tr>		
				</table>
		</td>
</tr>    
<tr>
		<td class="resumehead">PERSONAL DATA</td>
</tr>				
<tr>
		<td>	 	
				<table width=100% border="0">
				<tr>
						<td width="15%">Age:</td>
						<td><?=get_age($applicant[birthdate])?></td>
				</tr>
				<tr>
						<td>Date of Birth:</td>
						<td><?=dateformat($applicant[birthdate])?></td>
				</tr>
				<?if(!$employer){?>
				<tr>		
						<td>Place of Birth:</td>
						<td><?=($applicant[birthplace])? $applicant[birthplace] : "N/A"?></td>
				</tr>
				<?}?>
				<tr>
						<td>Gender:</td>
						<td><?=$sex?></td>
				</tr>
				<tr>		
						<td>Civil Status:</td>
						<td><?=$applicant[civil_status]?></td>
				</tr>
				<tr>
						<td>Height:</td>
						<td><?=$applicant[height1]." ".$applicant[height2]?></td>
				</tr>
				<tr>		
						<td>Weight:</td>
						<td><?=$applicant[weight1]." ".$applicant[weight2]?></td>
				</tr>
				<tr>
						<td>Nationality:</td>
						<td><?=$applicant[nationality]?></td>						
				</tr>
				<tr>
						<td>Religion:</td>
						<td><?=($applicant[religion])? $applicant[religion] : "N/A"?></td>						
				</tr>
				<?if(!$employer){?>																									
				<tr>
						<td>Provincial Address:</td>						
						<td><?=$applicant[perm_no]." ".$applicant[perm_st]?><?=($applicant[perm_city])? ", ".$applicant[perm_city] : ""?><?=($applicant[perm_prov])? ", ".$applicant[perm_prov] : ""?> <?=$applicant[perm_zip]?></td>
				</tr>
				<?}?>																		
		</table>
	</td>
</tr>

<?if($num_educ){?><!-- Educational Background-->
<tr>
		<td class="spacer"></td>
</tr>
<tr>
		<td class="resumehead">EDUCATION</td>
</tr>		
<tr>
		<td>		
				<table width=100%>															  				    		
				<tr>
						<td width=20%><b>Education Level</b></td>
						<td width=25%><b>Course</b></td>
						<td width=35%><b>School/University</b></td>
						<td width=20%><b>Date</b></td>												
				</tr>
				<?for ($i=1; $i<=$num_educ; $i++){?>
				<tr>
						<td valign=top><?=$education[$i][education]?></td>
						<td valign=top><?=$education[$i][course]?></td>
						<td valign=top><?=$education[$i][school]?></td>						
						<td valign=top><? if($education[$i][from_date] || $education[$i][to_date]) {?><?=dateformat($education[$i][from_date]).' - '.dateformat($education[$i][to_date])?><? } ?></td>
				</tr>
				<?}?>						
		</table>
	</td>
</tr>
<?
}// end if there is education
?>

<?if($num_licenses){?><!-- Licenses/Certifications -->
<tr>
		<td class="spacer"></td>
</tr>
<tr>
		<td class="resumehead">LICENSES/CERTIFICATIONS</td>
</tr>		
<tr>
		<td>		
				<table width=100%>															  				    		
				<tr class=none>						
     				<td width=26%><b>Licence/Certification Taken</b></td>
						<td width=20%><b>License/Certificate No.</b></td>
						<td width=13%><b>Date</b></td>
			  </tr>
				<?for ($i=1; $i<=$num_licenses; $i++){?>
				<tr>
						<td valign=top><?=$licenses[$i][license]?></td>
						<td valign=top><?=$licenses[$i][number]?></td>						
						<td valign=top><?=dateformat($licenses[$i][datetaken])?></td>
				</tr>
				<?}?>						
		</table>
	</td>
</tr>
<?
}// end if there is licenses
?>

<?if($num_emp){?> <!-- Employment Information -->
<tr>
		<td class="spacer"></td>
</tr>
<tr>
		<td class="resumehead">WORK EXPERIENCE</td>
</tr>		
<tr>
		<td>				 				
		<table width=100% border=0>	  			
		<?for ($i=1; $i<=$num_emp; $i++){?>
			<tr>
				<td rowspan="7" valign="top" width="2%"><?=$i?>.</td>
				<td width="15%">Position:</td>
				<td><b><?=$employment[$i][position]?> </td>						
			</tr>
			<tr>
				<td>Duration:</td>
			<td><?=dateformat($employment[$i][from_date])?> - <?if($employment[$i][to_date]!='0000-00-00' ) echo dateformat($employment[$i][to_date]);																														elseif($employment[$i][to_date]=='0000-00-00' && $employment[$i][from_date]!='0000-00-00') echo " PRESENT";?>	</td>
			</tr>
			<tr>		
				<td>Company:</td>
			<td><?=$employment[$i][company]?></td>
			</tr>
			<tr>	
			<td>Industry:</td>
			<td><?=@getname($employment[$i][industry_id],"industry","industry_id")?></td>						
			</tr>	
			<tr>	
				<td>Department:</td>
			<td><?=$employment[$i][department]?></td>						
			</tr>					
			<tr>
				
			</tr>					
			<tr>
				<td valign=top>Job Description:</td>
			<td><?=($employment[$i][job_desc])? $employment[$i][job_desc] : "N/A"?></td>						
			</tr> 
		<?  }// end of for loop 
		?>			  
		</table>		
		<?}?>
		</td>
</tr>		
<?if($num_skills){?><!-- Skills and Strengths -->
<tr>
		<td class="spacer"></td>
</tr>
<tr>
		<td class="resumehead">SPECIAL SKILLS</td>
</tr>		
<tr>
		<td>		
				<table width=100%>															  				    		
				<tr class=none>						
     				<td width=20%><b>Skill</b></td>						
						<td width=13% align="center"><b>Yrs. of<br>Experience</b></td>
						<td width=26%><b>Remarks</b></td>
			  </tr>
				<?for ($i=1; $i<=$num_skills; $i++){?>
				<tr>
						<td valign=top><?=$skills[$i][skill]?></td>
						<td valign=top align="center"><?=$skills[$i][yrs_of_exp]?></td>						
						<td valign=top><?=addbreaks($skills[$i][remarks])?></td>
				</tr>
				<?}?>						
		</table>
	</td>
</tr>
<?
}// end if there is skills
?>
<?if($num_train){?> <!-- Training -->		
<tr>
		<td class="spacer"></td>
</tr>
<tr>
		<td class="resumehead">TRAININGS / SEMINARS </td>
</tr>		
<tr>
		<td>				
		<table width="100%">				
				<tr>
				    <td align=left width=13%><b>Date</b></td>
						<td align=left width=28%><b>Title</b></td>						     																
			 </tr>
			<?for ($i=1; $i<=$num_train; $i++){?>
			 <tr>
						<td valign="top"><?=dateformat($training[$i][date])?></td>
						<td valign="top"><?=$training[$i][title]?>
						<?if($training[$i][center]) echo '<br>'.$training[$i][center]?>
						<? //if($training[$i][remarks]) echo '<br>'.$training[$i][remarks]?>
						</td>
			 </tr>
			 <?}?>
    </table>									 		
    </td>
</tr>
<?}?> 
 
 </table>		
 </td></tr>
<?
 do_report_footer();
?>

• [D] css
• [D] img
• [D] js
• [F] common_msg.inc
  Delete
• [F] edit_remarks.php
  Delete
• [F] edit_source_survey.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] line_up.php
  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_video.php
  Delete
• [F] my_profile.php
  Delete
• [F] new_joborder.php
  Delete
• [F] report_jo_applicants.php
  Delete
• [F] report_lineup_applicants.php
  Delete
• [F] report_resume.php
  Delete
• [F] report_StatusList.php
  Delete
• [F] report_StatusListAdvance.php
  Delete
• [F] sqladd.php
  Delete
• [F] sqldelete.php
  Delete
• [F] sqloptions.php
  Delete
• [F] sqlupdate.php
  Delete