/home/mip/mip/public/img/credit/datatables/report_StatusListAdvance.php.tar
home/mip/public_html_/old-website/employer/report_StatusListAdvance.php 0000644 00000063242 15152076116 0022514 0 ustar 00 <?
session_start();
if($doc==1){
header("Content-type: application/octet-stream");
header("Content-Disposition: attachment; filename=report_StatusListAdvance.xls");
header("Cache-Control: public");
}
require_once("func_all.php");
$principal = getdata_one("*","principals","principal_id",$myprincipalid);
$stat_id = $principal["stat_id"];
$principal = $myprincipalid;
if($doc==1){
check_valid_user();
echo '<html>';
echo '<head>';
echo '<title>'.$title.'</title>';
echo '<link href="http://'.$site_url.'css/menu.css" rel="stylesheet" type="text/css">';
echo '<script type="text/javascript" language="javascript" src="http://'.$site_url.'func_js.js" ></script>';
echo '</head>';
echo '<body marginheight="0" marginwidth="0" leftmargin="0" topmargin="0">';
echo '<table border=0 cellspacing=0 width="100%" height=100% cellpadding="0">';
echo '<tr><td valign="top" height="55" align=center>';
echo report_headers();
echo '</td></tr>';
} else {
do_report_header("Status Report");
}
/*global $broker_feature,$audit_feature;
if($audit_feature) {
reportcreate_log("Advance Status Report");
}*/
$personal_field = getdata("SELECT * from status_report where visible = '1' and id != '1' and tablename = 'personal' and stat_id = '$stat_id' order by order_id");
if ($status) { $sql_status = "AND personal.status='$status'"; }
for($pr=1;$pr<=count($personal_field);$pr++){
$pr_field = $pr_field."personal.".$personal_field[$pr][fieldname].",";
if($personal_field[$pr][fieldname2]) {
$pr_field2 = $pr_field2."personal.".$personal_field[$pr][fieldname2].",";
}
if($personal_field[$pr][fieldname3]) {
$pr_field3 = $pr_field3."personal.".$personal_field[$pr][fieldname3].",";
}
}
$addfield = $pr_field.$pr_field2.$pr_field3;
?>
<script type="text/javascript" language="javascript" src="http://<?=$site_url?>func_js.js" > </script>
<script language="javascript">
// Set the default "show" mode to that specified by W3C DOM
// compliant browsers
var showMode = 'table-cell';
// However, IE5 at least does not render table cells correctly
// using the style 'table-cell', but does when the style 'block'
// is used, so handle this
if (document.all) showMode='block';
// This is the function that actually does the manipulation
function toggleVis(btn){
// First isolate the checkbox by name using the
// name of the form and the name of the checkbox
btn = document.forms['tcol'].elements[btn];
// Next find all the table cells by using the DOM function
// getElementsByName passing in the constructed name of
// the cells, derived from the checkbox name
cells = document.getElementsByName('t'+btn.name);
// Once the cells and checkbox object has been retrieved
// the show hide choice is simply whether the checkbox is
// checked or clear
mode = btn.checked ? showMode : 'none';
// Apply the style to the CSS display property for the cells
for(j = 0; j < cells.length; j++) cells[j].style.display = mode;
}
</script>
<style type="text/css">
@media print{
#ad{ display:none;}
#leftbar{ display:none;}
#contentarea{ width:100%;}
}
</style>
<? if(!$doc) { ?>
<link href="http://<?=$site_url?>css/menu.css" rel="stylesheet" type="text/css">
<? } else {
$bgcolor = 'bgcolor="#FFFFFF"';
?>
<style>
body { font-family: verdana, Arial, Helvetica, sans-serif; font-size:11px;}
table.report {
BORDER-RIGHT: #757575 1px solid; BORDER-TOP: #757575 1px solid; BORDER-LEFT: #757575 1px solid; BORDER-BOTTOM: #757575 1px solid; BORDER-COLLAPSE: collapse; border-spacing: background-color:#ffffff;
}
td.report {
BORDER-RIGHT: #757575 1px solid; PADDING-RIGHT: 2px; BORDER-TOP: #757575 1px solid; PADDING-LEFT: 2px; FONT-SIZE: 11px; PADDING-BOTTOM: 2px; BORDER-LEFT: #757575 1px solid; COLOR: #000000; PADDING-TOP: 2px; BORDER-BOTTOM: #757575 1px solid; FONT-FAMILY: verdana,arial, helvetica, geneva, sans-serif; background-color:#ffffff;
}
td.reporthead {
BORDER-RIGHT: #757575 1px solid; PADDING-RIGHT: 2px; BORDER-TOP: #757575 1px solid; PADDING-LEFT: 2px; FONT-SIZE: 11px; PADDING-BOTTOM: 2px; BORDER-LEFT: #757575 1px solid; COLOR: #000000; PADDING-TOP: 2px; BORDER-BOTTOM: #757575 1px solid; FONT-FAMILY: verdana,arial, helvetica, geneva, sans-serif; background-color:#ffffff;
}
</style>
<? } ?>
<tr><td valign="top" align="center">
<table border="0" cellpadding="0" cellspacing="0" width="100%">
<tr><td height="25" width="100%" align="center" <?=$bgcolor?>>
<? if(!$doc) { ?>
<div class="discuss">
<b><font size="4">STATUS REPORT</font></b> <a href="#" onClick="return overlay(this, 'subcontent','bottom')"><img src="http://<?=$site_url?>img/user-group-16x16.png" width="16" height="16" border="0"/></a>
<a href="<?=$PHP_SELF?>?doc=1&stat_id=<?=$stat_id?>&broker=<?=$broker?>&principal=<?=$principal?>&status=<?=$status?>&from_year=<?=$from_year?>&from_month=<?=$from_month?>&from_day=<?=$from_day?>&to_year=<?=$to_year?>&to_month=<?=$to_month?>&to_day=<?=$to_day?>&cat_id=<?=$cat_id?>" target="jayson"><img src="http://<?=$site_url?>images/excel+icon.png" border="0" width="15" height="15" alt="Open in Excel" title="Open in Excel" /></a>
<div id="subcontent" style="border: 2px solid rgb(61, 61, 61); padding: 2px; position: absolute; background-color: white; width: 210px; display: none; left: 316px; top: 153px; width:300px;">
<div align="center">
<?
$result1 = getdata("SELECT * from status_report where visible = '1' and (stat_id = '$stat_id' or stat_id = '-1') order by order_id");
?>
<form name="tcol" onsubmit="return false">
<table width="300" border="0" cellspacing="1" cellpadding="1">
<tr>
<td colspan="2">
<table width="100%" border="0" cellspacing="1" cellpadding="1">
<tr>
<td><b><font style="font-size:12px;">Check and Uncheck to Show/Hide Columns</font></b></td>
<td align="right"> </td>
</tr>
</table></td>
</tr>
<tr>
<? for($r=1;$r<=count($result1);$r++){
$bb = $bb +1;
if($r=='1' || $r=='2') {
$status = 'disabled="disabled"';
} else {
$status = "";
}
?>
<td width="200"><input type=checkbox name="col<?=$r?>" onclick="toggleVis(this.name)" checked <?=$status?>> <?=$result1[$r][name]?></td>
<? if($bb==2) { $bb = '0'; ?></tr><tr><? } ?>
<? } ?>
</tr>
</table>
</form>
</div>
<div style="font-size: 10px; padding-bottom:5px; padding-right:5px;" align="right"><a href="#" onClick="overlayclose('subcontent'); return false">[Close]</a></div>
</div>
</div>
<? } ?>
</td></tr>
<tr><td><br />
<div id="jzhon">
<table width=100% class="report">
<?
if ($broker) $sql_broker = "AND broker_id='$broker'";
else $add_broker = 1; // to add a broker with no details
if ($principal) $sql_principal = "AND principal_id=$principal ";
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' ";
}
// all principals and all brokers
$brokers = getdata("select broker_id,name from brokers where 1=1 $sql_broker");
$num_bro = count($brokers);
if($add_broker) {
$brokers[$num_bro+1] = array("broker_id"=>"0","name"=>"NO BROKER");
$num_bro++;
}
// for each brokers
for ($b=1;$b<=$num_bro;$b++){
$brok_id = $brokers[$b][broker_id];
$principalids=getdata("select principal_id from principals where 1=1 and broker_id = '$brok_id' $sql_principal");
$num_prin = count($principalids);
$counter=1;
// for each principals
for ($p=1;$p<=$num_prin;$p++){
$broker_name = $brokers[$b][name];
$prin_id = $principalids[$p]["principal_id"];
$principal_name = getname($prin_id,"principals","principal_id");
$result = getdata("SELECT DISTINCT(personal.applicant_id),
(concat(personal.lname,', ',personal.fname,' ',left(personal.mname,1),'.')) as name, $addfield
process.principal_id
FROM personal,process
WHERE process.principal_id=$prin_id AND personal.blacklisted <> '1' and status = 'On Process'
$sql_status
$sql_apply_date
and process.applicant_id = personal.applicant_id
ORDER by personal.lname
");
$found = count($result);
if($found){
if($counter){
$counter=0;
$result2 = getdata("SELECT * from status_report where visible = '1' and (stat_id = '$stat_id' or stat_id = '-1') order by order_id");
?>
<? if($broker_feature) { ?>
<tr height="30" bgcolor="#e0e0e0">
<td><b><font size="3">Broker:</font></b></td>
<td colspan="<?=count($result2)-1?>"><b><font size="3"><?=$broker_name?></font></b></td>
</tr>
<? } ?>
<tr>
<?
for($rr=1;$rr<=count($result2);$rr++){
if($result2[$rr][no_columns]<2) {
$rowspan = 'rowspan="2"';
} else {
$rowspan = 'colspan="'.$result2[$rr][no_columns].'"';
}
?>
<td id="tcol<?=$rr?>" name="tcol<?=$rr?>" class="reporthead" align="center" <?=$rowspan?>><b><?=$result2[$rr][name]?></b></td>
<? } ?>
</tr>
<tr>
<? for($xx=1;$xx<=count($result2);$xx++){ ?>
<? if($result2[$xx][no_columns]>1) { ?>
<? if($result2[$xx][no_columns]=='2') { ?>
<td id="tcol<?=$xx?>" name="tcol<?=$xx?>" class="reporthead" align="center"><b><?=$result2[$xx][caption]?></b></td>
<td id="tcol<?=$xx?>" name="tcol<?=$xx?>" class="reporthead" align="center"><b><?=$result2[$xx][caption2]?></b></td>
<? } ?>
<? if($result2[$xx][no_columns]=='3') { ?>
<td id="tcol<?=$xx?>" name="tcol<?=$xx?>" class="reporthead" align="center"><b><?=$result2[$xx][caption]?></b></td>
<td id="tcol<?=$xx?>" name="tcol<?=$xx?>" class="reporthead" align="center"><b><?=$result2[$xx][caption2]?></b></td>
<td id="tcol<?=$xx?>" name="tcol<?=$xx?>" class="reporthead" align="center"><b><?=$result2[$xx][caption3]?></b></td>
<? } ?>
<? } ?>
<? } ?>
</tr>
<?}?>
<tr height="25">
<td colspan="<?=count($result2)?>"><b><u><?=$principal_name?></u></b></td>
</tr>
<?
for($j=1;$j<=$found;$j++){
$process = getdata_one("*","process","applicant_id",$result[$j]["applicant_id"]);
$med = getdata("SELECT * from status_report where tablename = 'medical' and (stat_id = '$stat_id' or stat_id = '-1')");
if($med) {
$medical= getdata("select m.* from medical as m,clinics as c where m.clinic_id=c.clinic_id and m.applicant_id = '".$result[$j]["applicant_id"]."' order by m.date desc limit 0,1");
}
$docs = getdata("SELECT * from status_report where tablename = 'doc_library' and (stat_id = '$stat_id' or stat_id = '-1')");
if($docs) {
$documents= getdata("select * from doc_library where applicant_id = '".$result[$j]["applicant_id"]."' order by date_submitted desc, id desc limit 0,1");
}
$resultjj = getdata("SELECT * from status_report where visible = '1' and (stat_id = '$stat_id' or stat_id = '-1') order by order_id");
?>
<tr>
<td id="tcol1" name="tcol1" class="report" valign="top" align="left"><a href="report_resume.php?applicant_id=<?=$result[$j][applicant_id]?>&employer=1" target="jayson"><?=$result[$j][name]?></a></td>
<td id="tcol2" name="tcol2" class="report" valign="top" align="left"><?=($process[jo_pos_id])? getname(getfield("position_id","jo_position","jo_pos_id",$process[jo_pos_id]), "positions","position_id") : " "?></td>
<? for($jj=1;$jj<=count($resultjj);$jj++){ ?>
<? if($jj>2) { ?>
<? if($resultjj[$jj][tablename]=='process') { ?>
<? if($resultjj[$jj][no_columns]=='1') { ?>
<td id="tcol<?=$jj?>" name="tcol<?=$jj?>" class="report" valign="top" align="<?=$resultjj[$jj][alignment]?>"><? if($resultjj[$jj][fieldcheck]){ echo dateformat($process[$resultjj[$jj][fieldname]]); } else { //echo $process[$resultjj[$jj][fieldname]];
print (get_morefield($resultjj[$jj][fieldname],$resultjj[$jj][tablename],$result[$j][applicant_id]))?get_morefield($resultjj[$jj][fieldname],$resultjj[$jj][tablename],$result[$j][applicant_id]):$result[$j][$resultjj[$jj][fieldname]];
}?></td>
<? } ?>
<? if($resultjj[$jj][no_columns]=='2') { ?>
<td id="tcol<?=$jj?>" name="tcol<?=$jj?>" class="report" valign="top" align="<?=$resultjj[$jj][alignment]?>"><? if($resultjj[$jj][fieldcheck]){ echo dateformat($process[$resultjj[$jj][fieldname]]); } else { //echo $process[$resultjj[$jj][fieldname]];
print (get_morefield($resultjj[$jj][fieldname],$resultjj[$jj][tablename],$result[$j][applicant_id]))?get_morefield($resultjj[$jj][fieldname],$resultjj[$jj][tablename],$result[$j][applicant_id]):$result[$j][$resultjj[$jj][fieldname]];
}?></td>
<td id="tcol<?=$jj?>" name="tcol<?=$jj?>" class="report" valign="top" align="<?=$resultjj[$jj][alignment]?>"><? if($resultjj[$jj][fieldcheck2]){ echo dateformat($process[$resultjj[$jj][fieldname2]]); } else { //echo $process[$resultjj[$jj][fieldname2]];
print (get_morefield($resultjj[$jj][fieldname2],$resultjj[$jj][tablename],$result[$j][applicant_id]))?get_morefield($resultjj[$jj][fieldname2],$resultjj[$jj][tablename],$result[$j][applicant_id]):$result[$j][$resultjj[$jj][fieldname2]];
}?></td>
<? } ?>
<? if($resultjj[$jj][no_columns]=='3') { ?>
<td id="tcol<?=$jj?>" name="tcol<?=$jj?>" class="report" valign="top" align="<?=$resultjj[$jj][alignment]?>"><? if($resultjj[$jj][fieldcheck]){ echo dateformat($process[$resultjj[$jj][fieldname]]); } else { //echo $process[$resultjj[$jj][fieldname]];
print (get_morefield($resultjj[$jj][fieldname],$resultjj[$jj][tablename],$result[$j][applicant_id]))?get_morefield($resultjj[$jj][fieldname],$resultjj[$jj][tablename],$result[$j][applicant_id]):$result[$j][$resultjj[$jj][fieldname]];
}?></td>
<td id="tcol<?=$jj?>" name="tcol<?=$jj?>" class="report" valign="top" align="<?=$resultjj[$jj][alignment]?>"><? if($resultjj[$jj][fieldcheck2]){ echo dateformat($process[$resultjj[$jj][fieldname2]]); } else { //echo $process[$resultjj[$jj][fieldname2]];
print (get_morefield($resultjj[$jj][fieldname2],$resultjj[$jj][tablename],$result[$j][applicant_id]))?get_morefield($resultjj[$jj][fieldname2],$resultjj[$jj][tablename],$result[$j][applicant_id]):$result[$j][$resultjj[$jj][fieldname2]];
}?></td>
<td id="tcol<?=$jj?>" name="tcol<?=$jj?>" class="report" valign="top" align="<?=$resultjj[$jj][alignment]?>"><? if($resultjj[$jj][fieldcheck3]){ echo dateformat($process[$resultjj[$jj][fieldname3]]); } else { ///echo $process[$resultjj[$jj][fieldname3]];
print (get_morefield($resultjj[$jj][fieldname3],$resultjj[$jj][tablename],$result[$j][applicant_id]))?get_morefield($resultjj[$jj][fieldname3],$resultjj[$jj][tablename],$result[$j][applicant_id]):$result[$j][$resultjj[$jj][fieldname3]];
}?></td>
<? } ?>
<? } if($resultjj[$jj][tablename]=='doc_library') { ?>
<? if($resultjj[$jj][no_columns]=='1') { ?>
<td id="tcol<?=$jj?>" name="tcol<?=$jj?>" class="report" valign="top" align="<?=$resultjj[$jj][alignment]?>"><? if($resultjj[$jj][fieldcheck]){ echo dateformat($documents[1][$resultjj[$jj][fieldname]]); } else { //echo $documents[1][$resultjj[$jj][fieldname]];
print (get_morefield($resultjj[$jj][fieldname],$resultjj[$jj][tablename],$result[$j][applicant_id]))?get_morefield($resultjj[$jj][fieldname],$resultjj[$jj][tablename],$result[$j][applicant_id]):$result[$j][$resultjj[$jj][fieldname]];
}?></td>
<? } ?>
<? if($resultjj[$jj][no_columns]=='2') { ?>
<td id="tcol<?=$jj?>" name="tcol<?=$jj?>" class="report" valign="top" align="<?=$resultjj[$jj][alignment]?>"><? if($resultjj[$jj][fieldcheck]){ echo dateformat($documents[1][$resultjj[$jj][fieldname]]); } else { //echo $documents[1][$resultjj[$jj][fieldname]];
print (get_morefield($resultjj[$jj][fieldname],$resultjj[$jj][tablename],$result[$j][applicant_id]))?get_morefield($resultjj[$jj][fieldname],$resultjj[$jj][tablename],$result[$j][applicant_id]):$result[$j][$resultjj[$jj][fieldname]];
}?></td>
<td id="tcol<?=$jj?>" name="tcol<?=$jj?>" class="report" valign="top" align="<?=$resultjj[$jj][alignment]?>"><? if($resultjj[$jj][fieldcheck2]){ echo dateformat($documents[1][$resultjj[$jj][fieldname2]]); } else { //echo $documents[1][$resultjj[$jj][fieldname2]];
print (get_morefield($resultjj[$jj][fieldname2],$resultjj[$jj][tablename],$result[$j][applicant_id]))?get_morefield($resultjj[$jj][fieldname2],$resultjj[$jj][tablename],$result[$j][applicant_id]):$result[$j][$resultjj[$jj][fieldname2]];
}?></td>
<? } ?>
<? if($resultjj[$jj][no_columns]=='3') { ?>
<td id="tcol<?=$jj?>" name="tcol<?=$jj?>" class="report" valign="top" align="<?=$resultjj[$jj][alignment]?>"><? if($resultjj[$jj][fieldcheck]){ echo dateformat($documents[1][$resultjj[$jj][fieldname]]); } else { //echo $documents[1][$resultjj[$jj][fieldname]];
print (get_morefield($resultjj[$jj][fieldname],$resultjj[$jj][tablename],$result[$j][applicant_id]))?get_morefield($resultjj[$jj][fieldname],$resultjj[$jj][tablename],$result[$j][applicant_id]):$result[$j][$resultjj[$jj][fieldname]];
}?></td>
<td id="tcol<?=$jj?>" name="tcol<?=$jj?>" class="report" valign="top" align="<?=$resultjj[$jj][alignment]?>"><? if($resultjj[$jj][fieldcheck2]){ echo dateformat($documents[1][$resultjj[$jj][fieldname2]]); } else { //echo $documents[1][$resultjj[$jj][fieldname2]];
print (get_morefield($resultjj[$jj][fieldname2],$resultjj[$jj][tablename],$result[$j][applicant_id]))?get_morefield($resultjj[$jj][fieldname2],$resultjj[$jj][tablename],$result[$j][applicant_id]):$result[$j][$resultjj[$jj][fieldname2]];
}?></td>
<td id="tcol<?=$jj?>" name="tcol<?=$jj?>" class="report" valign="top" align="<?=$resultjj[$jj][alignment]?>"><? if($resultjj[$jj][fieldcheck3]){ echo dateformat($documents[1][$resultjj[$jj][fieldname3]]); } else { //echo $documents[1][$resultjj[$jj][fieldname3]];
print (get_morefield($resultjj[$jj][fieldname3],$resultjj[$jj][tablename],$result[$j][applicant_id]))?get_morefield($resultjj[$jj][fieldname3],$resultjj[$jj][tablename],$result[$j][applicant_id]):$result[$j][$resultjj[$jj][fieldname3]];
}?></td>
<? } ?>
<? } if($resultjj[$jj][tablename]=='medical') { ?>
<? if($resultjj[$jj][no_columns]=='1') { ?>
<td id="tcol<?=$jj?>" name="tcol<?=$jj?>" class="report" valign="top" align="<?=$resultjj[$jj][alignment]?>"><? if($resultjj[$jj][fieldcheck]){ echo dateformat($medical[1][$resultjj[$jj][fieldname]]); } else { //echo $medical[1][$resultjj[$jj][fieldname]];
print (get_morefield($resultjj[$jj][fieldname],$resultjj[$jj][tablename],$result[$j][applicant_id]))?get_morefield($resultjj[$jj][fieldname],$resultjj[$jj][tablename],$result[$j][applicant_id]):$result[$j][$resultjj[$jj][fieldname]];
}?></td>
<? } ?>
<? if($resultjj[$jj][no_columns]=='2') { ?>
<td id="tcol<?=$jj?>" name="tcol<?=$jj?>" class="report" valign="top" align="<?=$resultjj[$jj][alignment]?>"><? if($resultjj[$jj][fieldcheck]){ echo dateformat($medical[1][$resultjj[$jj][fieldname]]); } else { //echo $medical[1][$resultjj[$jj][fieldname]];
print (get_morefield($resultjj[$jj][fieldname],$resultjj[$jj][tablename],$result[$j][applicant_id]))?get_morefield($resultjj[$jj][fieldname],$resultjj[$jj][tablename],$result[$j][applicant_id]):$result[$j][$resultjj[$jj][fieldname]];
}?></td>
<td id="tcol<?=$jj?>" name="tcol<?=$jj?>" class="report" valign="top" align="<?=$resultjj[$jj][alignment]?>"><? if($resultjj[$jj][fieldcheck2]){ echo dateformat($medical[1][$resultjj[$jj][fieldname2]]); } else { //echo $medical[1][$resultjj[$jj][fieldname2]];
print (get_morefield($resultjj[$jj][fieldname2],$resultjj[$jj][tablename],$result[$j][applicant_id]))?get_morefield($resultjj[$jj][fieldname2],$resultjj[$jj][tablename],$result[$j][applicant_id]):$result[$j][$resultjj[$jj][fieldname2]];
}?></td>
<? } ?>
<? if($resultjj[$jj][no_columns]=='3') { ?>
<td id="tcol<?=$jj?>" name="tcol<?=$jj?>" class="report" valign="top" align="<?=$resultjj[$jj][alignment]?>"><? if($resultjj[$jj][fieldcheck]){ echo dateformat($medical[1][$resultjj[$jj][fieldname]]); } else { //echo $medical[1][$resultjj[$jj][fieldname]];
print (get_morefield($resultjj[$jj][fieldname],$resultjj[$jj][tablename],$result[$j][applicant_id]))?get_morefield($resultjj[$jj][fieldname],$resultjj[$jj][tablename],$result[$j][applicant_id]):$result[$j][$resultjj[$jj][fieldname]];
}?></td>
<td id="tcol<?=$jj?>" name="tcol<?=$jj?>" class="report" valign="top" align="<?=$resultjj[$jj][alignment]?>"><? if($resultjj[$jj][fieldcheck2]){ echo dateformat($medical[1][$resultjj[$jj][fieldname2]]); } else { //echo $medical[1][$resultjj[$jj][fieldname2]];
print (get_morefield($resultjj[$jj][fieldname2],$resultjj[$jj][tablename],$result[$j][applicant_id]))?get_morefield($resultjj[$jj][fieldname2],$resultjj[$jj][tablename],$result[$j][applicant_id]):$result[$j][$resultjj[$jj][fieldname2]];
}?></td>
<td id="tcol<?=$jj?>" name="tcol<?=$jj?>" class="report" valign="top" align="<?=$resultjj[$jj][alignment]?>"><? if($resultjj[$jj][fieldcheck3]){ echo dateformat($medical[1][$resultjj[$jj][fieldname3]]); } else { //echo $medical[1][$resultjj[$jj][fieldname3]];
print (get_morefield($resultjj[$jj][fieldname3],$resultjj[$jj][tablename],$result[$j][applicant_id]))?get_morefield($resultjj[$jj][fieldname3],$resultjj[$jj][tablename],$result[$j][applicant_id]):$result[$j][$resultjj[$jj][fieldname3]];
}?></td>
<? } ?>
<? } if($resultjj[$jj][tablename]=='personal') { ?>
<? if($resultjj[$jj][no_columns]=='1') { ?>
<td id="tcol<?=$jj?>" name="tcol<?=$jj?>" class="report" valign="top" align="<?=$resultjj[$jj][alignment]?>"><? if($resultjj[$jj][fieldcheck]){ echo dateformat($result[$j][$resultjj[$jj][fieldname]]); } else {
print (get_morefield($resultjj[$jj][fieldname],$resultjj[$jj][tablename],$result[$j][applicant_id]))?get_morefield($resultjj[$jj][fieldname],$resultjj[$jj][tablename],$result[$j][applicant_id]):$result[$j][$resultjj[$jj][fieldname]];
}?></td>
<? } ?>
<? if($resultjj[$jj][no_columns]=='2') { ?>
<td id="tcol<?=$jj?>" name="tcol<?=$jj?>" class="report" valign="top" align="<?=$resultjj[$jj][alignment]?>"><? if($resultjj[$jj][fieldcheck]){ echo dateformat($result[$j][$resultjj[$jj][fieldname]]); } else { //echo $result[$j][$resultjj[$jj][fieldname]];
print (get_morefield($resultjj[$jj][fieldname],$resultjj[$jj][tablename],$result[$j][applicant_id]))?get_morefield($resultjj[$jj][fieldname],$resultjj[$jj][tablename],$result[$j][applicant_id]):$result[$j][$resultjj[$jj][fieldname]];
}?></td>
<td id="tcol<?=$jj?>" name="tcol<?=$jj?>" class="report" valign="top" align="<?=$resultjj[$jj][alignment]?>"><? if($resultjj[$jj][fieldcheck2]){ echo dateformat($result[$j][$resultjj[$jj][fieldname2]]); } else { //echo $result[$j][$resultjj[$jj][fieldname2]];
print (get_morefield($resultjj[$jj][fieldname2],$resultjj[$jj][tablename],$result[$j][applicant_id]))?get_morefield($resultjj[$jj][fieldname2],$resultjj[$jj][tablename],$result[$j][applicant_id]):$result[$j][$resultjj[$jj][fieldname2]];
}?></td>
<? } ?>
<? if($resultjj[$jj][no_columns]=='3') { ?>
<td id="tcol<?=$jj?>" name="tcol<?=$jj?>" class="report" valign="top" align="<?=$resultjj[$jj][alignment]?>"><? if($resultjj[$jj][fieldcheck]){ echo dateformat($result[$j][$resultjj[$jj][fieldname]]); } else { //echo $result[$j][$resultjj[$jj][fieldname]];
print (get_morefield($resultjj[$jj][fieldname],$resultjj[$jj][tablename],$result[$j][applicant_id]))?get_morefield($resultjj[$jj][fieldname],$resultjj[$jj][tablename],$result[$j][applicant_id]):$result[$j][$resultjj[$jj][fieldname]];
}?></td>
<td id="tcol<?=$jj?>" name="tcol<?=$jj?>" class="report" valign="top" align="<?=$resultjj[$jj][alignment]?>"><? if($resultjj[$jj][fieldcheck2]){ echo dateformat($result[$j][$resultjj[$jj][fieldname2]]); } else { //echo $result[$j][$resultjj[$jj][fieldname2]];
print (get_morefield($resultjj[$jj][fieldname2],$resultjj[$jj][tablename],$result[$j][applicant_id]))?get_morefield($resultjj[$jj][fieldname2],$resultjj[$jj][tablename],$result[$j][applicant_id]):$result[$j][$resultjj[$jj][fieldname2]];
}?></td>
<td id="tcol<?=$jj?>" name="tcol<?=$jj?>" class="report" valign="top" align="<?=$resultjj[$jj][alignment]?>"><? if($resultjj[$jj][fieldcheck3]){ echo dateformat($result[$j][$resultjj[$jj][fieldname3]]); } else { //echo $result[$j][$resultjj[$jj][fieldname3]];
print (get_morefield($resultjj[$jj][fieldname3],$resultjj[$jj][tablename],$result[$j][applicant_id]))?get_morefield($resultjj[$jj][fieldname3],$resultjj[$jj][tablename],$result[$j][applicant_id]):$result[$j][$resultjj[$jj][fieldname3]];
}?></td>
<? } ?>
<? } ?>
<? } } ?>
</tr>
<?
} // end of for loop for found<td style="word-wrap: break-word" width="100">
} // end of if there is found
} // end of for loop for principals
} // end of for loop for brokers
?>
</table>
</div>
</td></tr>
<? if(!count($result2)) { ?>
<tr><td align=center><br><br><b>No Applicant Found...</b><br><br><form><input type=button value="Close Window" onclick="window.close()"></form></td></tr>
<? } ?>
</table>
</td></tr>
<?
if(!$doc) {
do_report_footer();
}
?>
