/home/mip/public_html_/old-website/brokerxxx/report_applicant_dubai.php
<?
session_start();
require_once("func_all.php");
do_report_header2a("Dubai Format - ".get_applicantname($applicant_id));
$company = getdata_one("*","company",1,1);
$applicant = getdata_one("*","personal","applicant_id",$applicant_id);
if(!strcasecmp(getname($applicant['country_id'],"country","country_id"),'Taiwan'))// if 1st country is equal to Taiwan in case insensitive way
$applicantid_taiwan = $applicant['applicant_id1'];
elseif(!strcasecmp(getname($applicant['country_id2'],"country","country_id"),'Taiwan'))// if 2nd country is equal to Taiwan in case insensitive way
$applicantid_taiwan = $applicant['applicant_id2'];
$process = getdata_one("*","process","applicant_id",$applicant_id);
$medical = getdata("select m.status from medical as m,clinics as c where m.clinic_id=c.clinic_id and applicant_id='$applicant_id' order by date desc limit 1");
$education = getdata("select * from education where applicant_id='$applicant_id' order by from_date desc limit 1");
$dependents = getdata_one("*","dependents","applicant_id","$applicant_id");
$children = getdata("select bday from children where applicant_id='$applicant_id' order by bday asc");
$num_children = count($children);
$educ_level = getdata("select * from education where applicant_id ='". $applicant_id . "'");
$num_educ_level = count($educ_level);
$employment2 = 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' and overseas=1 order by from_date desc limit 2");
$num_emp2 = count($employment2);
$questions = getdata_one("*","questions","applicant_id","$applicant_id");
$prequalify = getdata_one("*","prequalify","applicant_id","$applicant_id");
$questions = getdata_one("*","questions_dubai","applicant_id","$applicant_id");
$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 limit 3");
$num_emp = count($employment);
$rating = array("eng_rating", "ara_rating", "chi_rating");
$num_rating = count($rating);
?>
<tr><td height="100%" align=center valign="top">
<table align=center cellpadding='2' cellspacing='2' border=0 width=100%>
<tr><td valign=top width=100% >
<table border=0 align=center width="100%" cellpadding=3 cellspacing=0 bordercolor="whiteviolet">
<tr>
<td width=100%>
<table border=0 class="report" width=100%>
<tr>
<td align="left" class="report"><font size=4><b>EMPLOYMENT APPLICATION</b></font></td>
<td align="center" class="repor">
<font size=5><b>
اســتمارة
توظيـف</b></font></td>
</tr>
</table>
</td>
</tr>
<tr>
<td>
<table border=0 width=100%>
<tr>
<td align="center" width=30%>
<img src="<?=$img_dir?>jakelogoonly.jpg" align="center"><br>
<font color="green">
<span class="smaller">POEA License # 084-LB-082506-R</span>
<br>
<?=$company['agency_address']?><br>
Tel.: <?=$company['agency_tel']?> * Fax: <?=$company['agency_fax']?><br>
Email: <?=$company['agency_email']?>
</font>
</td>
<td width=40% height=100%>
<table border=0 width=100% height=100% bordercolor="#333333" cellpadding=0 cellspacing=0 class="report">
<tr height=40>
<td class="report" width=40% style="padding-left:10px;">Code No.</td>
<td class="report" width=40%> </td>
<td class="repors" width=20%> </td>
</tr>
<tr height=40>
<td class="report" style="padding-left:10px;">Passport No.</td>
<td class="repor" align='center'><?=getfield("passport", "process", "applicant_id", $applicant["applicant_id"])?></td>
<td class="report"> </td>
</tr>
<tr height=40>
<td class="report" style="padding-left:10px;">Post</td>
<td class="report"> </td>
<td class="report" align="center"><font size=3><b>الوظيفة</b></font></td>
</tr>
<tr height=40>
<td class="report" style="padding-left:10px;">Monthly Salary</td>
<td class="report" align="center"> <?=getfield("basic_salary", "process", "applicant_id", $applicant["applicant_id"])?></td>
<td class="report" align="center"><font size=3><b>الراتب
<br>الشهري</b></font></td>
</tr>
<tr height=40>
<td class="report" style="padding-left:10px;">Contract Period</td>
<td class="report" align="center"><?=getfield("contract_duration", "process", "applicant_id", $applicant["applicant_id"])?></td>
<td class="report" align="center"><font size=3><b>مدة<br>
العقد</b></font>
</td>
</tr>
</table>
</td>
<td width=30% align="center" class=><?if ($applicant[picture]){print resize_pic1(200,200,$pic_dir1.$applicant[picture],"","","",1);}else{echo "<img src='". $img_dir1 . "blank.jpg' alt='PHOTO 2 X 2' width=200 height=200 border=1>";}?>
</td>
</tr>
</table>
</td>
</tr>
<tr><td><br></td></tr>
<tr>
<td>
<table width="100%" cellpadding=0 cellspacing=0 border=0 class='report'>
<tr height=30>
<td class="report" width=15% style="padding-left:10px;">Full Name:</td>
<td class="report" width=75% style="padding-left:10px;"><?=$applicant['fname']." ".$applicant['mname']." ".$applicant['lname']?></td>
<td class="report" width=10% style="padding-left:10px;"><font size=3><b>الاسم
الكامل</b></font></td>
</tr>
<tr height=30>
<td class="report" width=15% style="padding-left:10px;">date of Birth:</td>
<td class="report" width=75% style="padding-left:10px;"><?=dateformat($applicant['birthdate']);?></td>
<td class="report" width=10% style="padding-left:10px;"><font size=3><b>تاريخ
الميلاد</b></font></td>
</tr>
<tr height=30>
<td class="report" width=15% style="padding-left:10px;">Nationality</td>
<td class="report" width=70% style="padding-left:10px;"><?=$applicant['nationality']?></td>
<td class="report" width=10% style="padding-left:10px;"><font size=3><b>الجنسية</b></font></td>
</tr>
</table>
</td>
</tr>
<tr height=3><td></td></tr>
<tr height=3><td></td></tr>
<tr>
<td>
<table width="100%" cellpadding=0 cellspacing=0 border=0 class=report>
<tr height=30>
<td width=100 class="report" style="padding-left:10px;">Height:</td>
<td width=100 class="report" style="padding-left:10px;"> <?=$applicant["height1"]?> <?=$applicant["height2"]?></td>
<td width=100 class="report" style="padding-left:10px;"><font size=3><b>الجنسية</b></font></td>
<td width=100 class="report" style="padding-left:10px;">Weight:</td>
<td width=100 class="report" style="padding-left:10px;"> <?=$applicant["weight1"]?> <?=$applicant["weight2"]?></td>
<td width=100 class="report" style="padding-left:10px;"><font size=3><b>الوزن</b></font></td>
</tr>
</table>
</td>
</tr>
<tr>
<td>
<table width="100%" cellpadding=0 cellspacing=0 border=0 class='report'>
<tr height=30>
<? $img_maycheck = "<img src='img/maycheck.gif'>";
$img_walacheck = "<img src='img/walacheck.gif'>";?>
<td class="report" style="padding-left:10px;">Religion:</td>
<td class="report" style="padding-left:10px;">
<? if(stristr($applicant["religion"],"Islam")){
echo $img_maycheck . " Islam";
}else{
echo $img_walacheck . " Islam";
}
?>
</td>
<td class="report" style="padding-left:10px;">
<? if(stristr($applicant["religion"],"Catholic") || stristr($applicant["religion"],"Christian")){
echo $img_maycheck . " Christian";
}else{
echo $img_walacheck . " Christian";
}
?>
</td>
<td class="report" style="padding-left:10px;"><font size=3><b>الديانة</b></font></td>
</tr>
<tr height=30>
<td class="report" style="padding-left:10px;">Civil Status:</td>
<td class="report" style="padding-left:10px;">
<? if($applicant["civil_status"]=="Single"){
echo $img_maycheck . " Single";
}else{
echo $img_walacheck . " Single";
}
?>
</td>
<td class="report" style="padding-left:10px;">
<? if($applicant["civil_status"]=="Married"){
echo $img_maycheck . " Married";
}else{
echo $img_walacheck . " Married";
}
?>
</td>
<td class="report" style="padding-left:10px;"><font size=3><b>الحالة
الاجتماعية</b></font></td>
</tr>
<tr height=30>
<td class="report" style="padding-left:10px;" colspan=2> </td>
<td class="report" style="padding-left:10px;" colspan=2>
<u><?=$applicant["num_child"]?></u>
Number of Children
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td width=100%>
<table width="100%" cellpadding=0 cellspacing=0 border=0 class=report>
<tr height=30>
<td class="report" style="padding-left:10px;" colspan=6><font size=2><b>Languages Known:
<font size=3><b>إجادة
اللغات</b></font>
</b></font></td>
</tr>
<tr height=30>
<td width=100 class="report" style="padding-left:10px;">
<?=($applicant["eng_rating"])?"<img src='img/maycheck.gif'>":"<img src='img/walacheck.gif'>"; ?>
English</td>
<td width=100 class="report" style="padding-left:10px;"><font size=3><b>انكليزي</b></font></td>
<td width=100 class="report" style="padding-left:10px;">
<?=($applicant["ara_rating"])?"<img src='img/maycheck.gif'>":"<img src='img/walacheck.gif'>"; ?>
Arabic</td>
<td width=100 class="report" style="padding-left:10px;"><font size=3><b>عربي</b></font></td>
<td width=100 class="report" style="padding-left:10px;">
<?=($applicant["fil_rating"] || $applicant["chi_rating"])?"<img src='img/maycheck.gif'>":"<img src='img/walacheck.gif'>"; ?>
Others</td>
<td width=100 class="report" style="padding-left:10px;"><font size=3><b>أخرى</b></font></td>
</tr>
<tr height=30>
<td width=100 class="report" style="padding-left:10px;">
<?=$applicant["$eng_rating"]?>
<?=($applicant["$eng_rating"]==1)?"<img src='img/maycheck.gif'>":"<img src='img/walacheck.gif'>"; ?>
Fair</td>
<td width=100 class="report" style="padding-left:10px;"><font size=3><b>مقبول</b></font></td>
<td width=100 class="report" style="padding-left:10px;">
<?=$applicant["$ara_rating"]?>
<?=($applicant["$ara_rating"]==1)?"<img src='img/maycheck.gif'>":"<img src='img/walacheck.gif'>"; ?>
Fair</td>
<td width=100 class="report" style="padding-left:10px;"><font size=3><b>مقبول</b></font></td>
<td width=100 class="report" style="padding-left:10px;">
<?=$applicant["$chi_rating"]?>
<?=($applicant["$chi_rating"]==1 || $applicant["$fil_rating"]==1)?"<img src='img/maycheck.gif'>":"<img src='img/walacheck.gif'>"; ?>
Fair</td>
<td width=100 class="report" style="padding-left:10px;"><font size=3><b>مقبول</b></font></td>
</tr>
<tr height=30>
<td width=100 class="report" style="padding-left:10px;">
<?=$applicant["$eng_rating"]?>
<?=($applicant["eng_rating"]==2)?"<img src='img/maycheck.gif'>":"<img src='img/walacheck.gif'>"; ?>
Good</td>
<td width=100 class="report" style="padding-left:10px;"><font size=3><b>جيد</b></font></td>
<td width=100 class="report" style="padding-left:10px;">
<?=$applicant["$ara_rating"]?>
<?=($applicant["ara_rating"]==2)?"<img src='img/maycheck.gif'>":"<img src='img/walacheck.gif'>"; ?>
Good</td>
<td width=100 class="report" style="padding-left:10px;"><font size=3><b>جيد</b></font></td>
<td width=100 class="report" style="padding-left:10px;">
<?=$applicant["$chi_rating"]?>
<?=($applicant["chi_rating"]==2)?"<img src='img/maycheck.gif'>":"<img src='img/walacheck.gif'>"; ?>
Good</td>
<td width=100 class="report" style="padding-left:10px;"><font size=3><b>جيد</b></font></td>
</tr>
</table>
</td>
</tr>
<tr><td><br></td></tr>
<tr>
<td>
<table width="100%" cellpadding=0 cellspacing=0 border=0>
<tr>
<td valign="top" width=55%>
<table border=0 bordercolor=green width=100%>
<tr>
<td align='center' valign="top">
<table border=0 width=100% class='report' cellpaddingin=0 cellspacing=0>
<tr height=30>
<td class="report" style="padding-left:10px;"><font size=2><b>Educational Level:</b></font></td>
<td class="report" style="padding-left:40px;"><font size=3><b>المستوى
الدراسي</b></font></td>
</tr>
<tr height=30>
<?
$get_college =getdata("select education from education where education='College/University' and applicant_id='$applicant_id'");
$college_found = count($get_college);
$get_high =getdata("select education from education where education='Secondary' and applicant_id='$applicant_id'");
$high_found = count($get_high);
if($college_found>=1){
$high="<img src='img/walacheck.gif'>";
$college="<img src='img/maycheck.gif'>";
}elseif($high_found>=1){
$high="<img src='img/maycheck.gif'>";
$college="<img src='img/walacheck.gif'>";
}else{
$high="<img src='img/walacheck.gif'>";
$college="<img src='img/walacheck.gif'>";
}
?>
<td class="report" style="padding-left:40px;" width=50%>
<?=$high?>High School</td>
<td class="report" style="padding-left:40px;" width=50%>
<?=$college?>
College Level</td>
</tr>
</table>
<br><br>
<table border=0 width=100% class='report' cellpadding=0 cellspacing=0>
<tr height=30>
<td style="padding-left:10px;" colspan=2 width=100%><font size=2><b>Ability To Do: </b></font></td>
</b></font></td>
</tr>
<?
$num_duties = count($array_ability_dubai);
for($i=1;$i<=$num_duties;$i++){
print "<tr height=30 class='report'><td class='report' style='padding-left:40px;' width=50%>";
if($questions[$array_ability_dubai[$i]['field']]=="Yes"){
print "<img src='img/maycheck.gif'>";
}else{
print "<img src='img/walacheck.gif'>";
}
print " ".$array_ability_dubai[$i]['duty']."</td>
<td style='padding-left:40px;' width=50% class='report'><font size=3><b>".$array_ability_dubai[$i]['chi']."</b></font></td>";
print "</tr>";
} ?>
</table>
</td>
<td width=45% align="right">
<table border=0>
<tr>
<td class='report' width=351 height=473 align='center'>
<?if ($applicant[picture_body]){print resize_pic1(351,473,$pic_dir1.$applicant[picture_body],"","","",1);}else{echo "PHOTO<br>WHOLE BODY";}?>
</td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
</table>
</td></tr>
<tr><td><div style='page-break-after:always'></div></td></tr>
<tr><td valign=top width=100%>
<table border=0 align=center width="100%" cellpadding=3>
<tr height=30>
<td>
<table border=1 width=100% class="report">
<tr height=30>
<td width=70% class='report'><font size=2>
<b>Please answer truthfully to the following questions:</b></font>
</td>
<td width=30%><font size=3><b>هلتوافقين على
مايلي</font></b>
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td>
<table width="100%" cellspacing=0 border=1 class="report">
<?
$num_duties = count($array_duties_dubai);
for($i=1;$i<=$num_duties;$i++){
print "
<tr height='35' class='report'>
<td style='padding-left:30px;' class='report' colspan=2 width=50%>".$array_duties_dubai[$i]['duty']."</td>
<td style='padding-right:50px;' align='right' class='report' colspan=2><font size=3>".$array_duties_dubai[$i]['dub']."</font></td>";
print "</tr>
<tr height=30>
<td class='report' colspan=2 width=50%>
";
print ($questions[$array_duties_dubai[$i]['field']]=="Yes")?"<img src='img/maycheck.gif'> Yes":"<img src='img/walacheck.gif'> Yes";
print " ";
print ($questions[$array_duties_dubai[$i]['field']]=="No")?"<img src='img/maycheck.gif'> No":"<img src='img/walacheck.gif'> No";
print "</td>";
print "<td class='report' width= style='padding-left:20px;' colspan=2>
";
print ($questions[$array_duties_dubai[$i]['field']]=="Yes")?"<img src='img/maycheck.gif'> ":"<img src='img/walacheck.gif'> ";
print " <font size=3>لا</font>
";
print ($questions[$array_duties_dubai[$i]['field']]=="No")?"<img src='img/maycheck.gif'> No":"<img src='img/walacheck.gif'> No";
print "<font size=3>نعم</font></td>
</tr>";
}
?>
</table>
</td>
</tr>
<tr><td> </td></tr>
<tr>
<td>
<table width="100%" class="report" cellpadding=0 cellspacing=0>
<tr height=30>
<td class="report" colspan=10 align='left' class="report"><font size=2><b>Working Experience:</b></font></td>
</tr>
<tr height=30>
<td class="report" align='center'><b>Country</td>
<td class="report" align='center'><b>Employment Period</td>
<td class="report" align='center'><b>Position </td>
</tr>
<?for($i=1;$i<=$num_emp;$i++){?>
<tr height=30>
<td valign="bottom" class="report" align="center"> <?=getfield("name","country", "country_id", $employment[$i]['country_id'])?> </td>
<td valign="bottom" class="report" align="center"> <?=$employment[$i]['t_date']?>-<?=$employment[$i]['t_date']?> </td>
<td valign="bottom" class="report" align="center"> <?=$employment[$i]['position']?></td>
</tr>
<?}?>
</table>
</td>
</tr>
<tr>
<td>
<table width="100%" cellpadding=0 cellspacing=0 border=0 height=100>
<tr>
<td colspan=10 align='center' valign='bottom' width=20%>
<table border=1 width=100% height=50 class='report'>
<tr>
<td class='report'> </td>
</tr>
<tr>
<td align='center' valign='top' class='report'>Signature of Applicant</td>
</tr>
</table>
</td>
<td colspan=10 align='left' valign='middle' width=80%><font size=2><b> </b></font></td>
</tr>
</table>
</td>
</tr>
</table>
</td></tr>
<tr><td><div style='page-break-after:always'></div></td></tr>
</table>
<br><br>
</td></tr>
<?
do_report_footer();
?>