Gecko [ v3.cesa.co.za ]

Name	Size	Permission	Date
adobe.inc	107 B	-rw-r--r--	2008-01-09 07:51
auth.inc	3.52 KB	-rw-r--r--	2025-04-30 14:24
auth.inc.bak	1.12 KB	-rw-r--r--	2025-03-07 12:21
calendar.inc	5.46 KB	-rw-r--r--	2008-01-09 08:36
conf.inc	683 B	-rw-r--r--	2025-03-07 12:21
conf.inc.bak	690 B	-rw-r--r--	2025-03-07 12:21
confdec.inc	364 B	-rw-r--r--	2025-03-07 12:21
createadec.inc	175 B	-rw-r--r--	2008-01-09 07:51
db.inc	146 B	-rw-r--r--	2025-03-07 12:21
declaration.inc	19.69 KB	-rw-r--r--	2026-01-20 15:55
declaration_nav.php	4.76 KB	-rw-r--r--	2025-02-20 10:14
declaration_nav.php4	4.69 KB	-rw-r--r--	2008-01-09 08:36
declaration_nav_int.php	5.87 KB	-rw-r--r--	2021-02-24 09:22
declaration_nav_int.php4	5.96 KB	-rw-r--r--	2015-01-22 06:13
default.css	4.06 KB	-rw-r--r--	2008-01-09 07:51
dont-click.prefs.inc	3.38 KB	-rw-r--r--	2008-01-09 08:36
footer.inc	3.13 KB	-rw-r--r--	2025-05-19 11:13
footer2.inc	157 B	-rw-r--r--	2008-01-09 07:51
func.inc	3.36 KB	-rw-r--r--	2025-01-13 14:32
funcinternational.inc	2.66 KB	-rw-r--r--	2008-01-09 07:51
header.inc	4.12 KB	-rw-r--r--	2025-01-31 07:03
header2.inc	2.05 KB	-rw-r--r--	2008-01-09 08:36
internationalheader.inc	590 B	-rw-r--r--	2008-01-09 07:51
internationalmenu.inc	378 B	-rw-r--r--	2008-01-09 07:51
login_footer.inc	748 B	-rw-r--r--	2008-01-09 07:51
login_header.inc	1.43 KB	-rw-r--r--	2008-01-09 07:51
misc.inc	363 B	-rw-r--r--	2008-01-09 07:51
nav.inc	528 B	-rw-r--r--	2008-01-09 07:51
notice.inc	530 B	-rw-r--r--	2008-01-09 08:36
press.inc	1.53 KB	-rw-r--r--	2008-01-09 08:36
rc4cryptclass.inc	1.27 KB	-rw-r--r--	2008-01-09 07:51
readnext.inc	8.77 KB	-rw-r--r--	2025-03-07 12:21
readnext.inc.bak	6.8 KB	-rw-r--r--	2025-03-07 12:21
readnextold.inc	6.64 KB	-rw-r--r--	2025-03-07 12:21
sched1page2gen.inc	7.65 KB	-rw-r--r--	2025-07-18 08:31
submitcheck.inc	23.74 KB	-rw-r--r--	2025-07-18 09:41
submitcheck.inc.bak	6.28 KB	-rw-r--r--	2025-03-07 12:21
submitcheck2.inc	13.04 KB	-rw-r--r--	2025-07-18 07:32
submitcheck2_A.inc	18.75 KB	-rw-r--r--	2025-07-18 07:47
submitcheck2b.inc	11 KB	-rw-r--r--	2025-07-18 07:47
submitcheck2b_A.inc	14.9 KB	-rw-r--r--	2025-03-07 12:21
submitcheckA.inc	21.38 KB	-rw-r--r--	2025-07-18 07:20
submitcheckqmig.inc	1.35 KB	-rw-r--r--	2025-03-07 12:21
survey_footer.inc	2.35 KB	-rw-r--r--	2008-01-09 07:51
test.html	11.56 KB	-rw-r--r--	2008-01-09 07:51
viewcal.inc	2.33 KB	-rw-r--r--	2008-01-09 08:36
voting_class.inc	11.04 KB	-rw-r--r--	2025-03-07 12:21
work.inc	1.26 KB	-rw-r--r--	2008-01-09 08:36

Rename

<?php
// **************************************************************************************
// All the variables for the reading of the information of the Annual Declaration
// **************************************************************************************
include_once($_SERVER['DOCUMENT_ROOT'] . '/cfg/config.php');

$host = EW_CONN_HOST;
$user = EW_CONN_USER;
$password = EW_CONN_PASS;
$db = EW_CONN_DB;
     mysql_connect("$host","$user","$password") or die("Unable to connect to SQL server");
     mysql_select_db("$db") or die("Unable to select database");
// **************************************************************************************
// Get the Office ID that  is valid for the Member firm logged on.
// **************************************************************************************
$CID = GetCID();

$query = "SELECT  * FROM OfficeContacts WHERE OfficeContacts.ContactsID = '$CID'";
	$result = mysql_query($query) or die("Select of id Failed");
	$row = mysql_fetch_array($result);
    $MemberOfficeID = $row['OfficeID'];
    $MemberOfficeMandated = $row['MandatedPrincipal'];

// **************************************************************************************
// Get the Principle responsible person.
// **************************************************************************************
	$query = "SELECT * FROM OfficeContacts WHERE (OfficeContacts.OfficeID = '$MemberOfficeID') AND (OfficeContacts.MandatedPrincipal = 1)";
	$result = mysql_query($query) or die("Select of id Failed");
	$row = mysql_fetch_array($result);
    $MemberContactID = $row['ContactsID'];

$query = "SELECT * FROM Contacts WHERE Contacts.ContactsID = '$MemberContactID'";
	$result = mysql_query($query) or die("Select of id Failed");
	$row = mysql_fetch_array($result);
    $MemberContactSurname = $row['ContactSurname'];	  
    $MemberContactFirstname = $row['ContactFirstName'];
    $MemberContactDesignation = $row['ContactDesignation'];	
		
// **************************************************************************************
// Get the Firm ID that  is valid for the Member firm logged on.
// **************************************************************************************
	$query = "SELECT  FirmID, OfficeID, HoldingCompany  FROM tblMemberFirmOffices WHERE tblMemberFirmOffices.OfficeID = '$MemberOfficeID'";
	$result = mysql_query($query) or die("Select of id Failed");
	$row = mysql_fetch_array($result);
    $MemberFirmID = $row['FirmID'];
	
	
// **************************************************************************************
// Count how many Firm Offices there are.
// **************************************************************************************
	$Squery = "SELECT  * FROM ADec_tblMemberFirmOffices WHERE Prev_FirmID = '$MemberFirmID' AND (SaaceBranch<>'International' OR SaaceBranch IS NULL)";
	$Sresult = mysql_query($Squery) or die("Select of offices Failed");
	$OfficeCount = mysql_num_rows($Sresult);
	$Squery = "SELECT  * FROM ADec_tblMemberFirmOffices WHERE Prev_FirmID = '$MemberFirmID' AND SaaceBranch='International'";
	echo $Squery;
	$Sresult = mysql_query($Squery) or die("Select of offices Failed");
	$OfficeCountInternat = mysql_num_rows($Sresult);

// Get this office
	$Squery = "SELECT  * FROM ADec_tblMemberFirmOffices WHERE OfficeID = '$SelectOfficeID'";
	$Sresult = mysql_query($Squery) or die("Select of id Failed");
	$Srow = mysql_fetch_array($Sresult);
	$OfficeID = $Srow['OfficeID'];
    $OfficeStatus = $Srow['OfficeStatus'];
    $OfficeName = $Srow['OfficeName'];	
    $OfficeBuilding = $Srow['BldgName'];
    $OfficeStreet = $Srow['StreetName'];			
    $OfficeSuburb = $Srow['Suburb'];
	$OfficeTownCity = $Srow['TownCity'];
	$OfficeCountry = $Srow['Country'];	
	$OfficeCode = $Srow['PostalCode'];
	$OfficeProvince = $Srow['Province'];
	$OfficePostalAdd = $Srow['PostalAddress'];
	$OfficeTel = $Srow['Telephone'];					
	$OfficeFax = $Srow['Fax'];
	$OfficeEmail = $Srow['Email'];
	$OfficeLanguage = $Srow['Language'];
	$OfficeLocalM = $Srow['GeoLocationLocal'];
	$OfficeDistrict = $Srow['GeoLocationDistrict'];
	$OfficeAddress2 = $Srow['Address2'];
	$OfficeGeoLocation = $Srow['GeoLocation'];		
	$MemberProffStaff = $Srow['ProfessionalStaff'];
	$MemberNonProff = $Srow['NonProfTechStaff'];
	$MemberOtherStaff = $Srow['OtherStaff'];
	$HRName = $Srow['HRName'];
	$HREmail = $Srow['HREmail'];
	$HoldingComp = $Srow['HoldingCompany'];
	$Fidic = $Srow['Fidic'];
								
// **************************************************************************************
// Get the Firm Details that  is valid for the Member firm logged on.
// **************************************************************************************
	$query = "SELECT FirmID, FirmName, PIUnderwriter, LevelOfCover, FormOfIncorporation, `Quality Management`, `Date of last peer review`, URL, Acoustics, Agricultural, BuildingServices, Chemical, Civil, Development, Electrical, Electronic, Environmental, Geotechnical, Industrial, Mechanical, Marine, Mining, Process, Structural, Transportation, Architecture, RuralDevelopment, ProjectManagement, QuantitySurveying, TownPlanning, Multidisciplinary, DisputeResolution, ExpertWitness, InformationSystems, FacilitiesManagement, GIS FROM ADec_tblMemberFirms WHERE Prev_FirmID = '$MemberFirmID'";
	$result = mysql_query($query) or die("Select of id Failed");
	$row = mysql_fetch_array($result);
    $MemberFirmName = $row['FirmName'];
    $MemberFirmInsurer = $row['PIUnderwriter'];	
    $MemberFirmLevelCover = $row['LevelOfCover'];
    $MemberFirmFormIncorp = $row['FormOfIncorporation'];
    $MemberFirmISO = $row['Quality Management'];
    $MemberFirmDateReview = $row['Date of last peer review'];
    $MemberFirmURL = $row['URL'];
	$MemberFirmMainInvoice = $row['MainFirmInvoice'];
	$MEmberFirmGroupInvoice = $row['GroupFirmsInvoice'];

// **************************************************************************************
// Get the Principle person responsible for the office.
// **************************************************************************************
	$query = "SELECT  * FROM ADec_OfficeContacts WHERE (OfficeID = '$OfficeID') AND (OfficeHead = 1 )";
	$result = mysql_query($query) or die("Select of id Failed");
	$row = mysql_fetch_array($result);
    $HeadOfficeID = $row['ContactsID'];

$query = "SELECT * FROM ADec_Contacts WHERE ContactsID = '$HeadOfficeID'";
	$result = mysql_query($query) or die("Select of id Failed");
	$row = mysql_fetch_array($result);
    $HeadContactSurname = $row['ContactSurname'];	  
    $HeadContactFirstname = $row['ContactFirstName'];
    $HeadContactDesignation = $row['ContactDesignation'];
    $HeadContactQualifications = $row['Qualifications'];	
		$HeadContactRegistration = $row['ProfessionalRegistrations'];
		$HeadContactEmail = $row['PreferredEmail'];
	
?>