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

//ini_set('display_errors', 1);
//error_reporting(E_ALL);
// **************************************************************************************
// 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();

if (empty($CID)) {
 $AppID = GetAppID();
 if (empty($AppID)) {
 echo "You are no longer logged in, your session has timed out. <a href='http://www.cesa.co.za'>Please login again.</a>";
 die();
 }
}

//echo "CID = " . $CID . " ";
//exit;
if (!empty($CID)) {
 $query = "SELECT * FROM OfficeContacts WHERE OfficeContacts.ContactsID = '$CID'";
 echo '';
 if (!($result = mysql_query($query))) {
 throw new Exception("Query failed in declaration.inc: " . $query);
 }
 $row = mysql_fetch_array($result);
 $MemberOfficeID = $row['OfficeID'];
 $MemberOfficeMandated = $row['MandatedPrincipal'];

// **************************************************************************************
// Get the Firm ID that is valid for the Member firm logged on.
// **************************************************************************************
 $query = "SELECT * FROM tblMemberFirmOffices WHERE tblMemberFirmOffices.OfficeID = '$MemberOfficeID'";
 echo '';
 if (!($result = mysql_query($query))) {
 throw new Exception("Query failed in declaration.inc: " . $query);
 }
 $row = mysql_fetch_array($result);
 $MemberFirmID = $row['FirmID'];
// echo $MemberFirmID; 
// exit;
} elseif (!empty($AppID)) {
 $query = "SELECT * FROM ADec_tblMemberFirms WHERE ApplicationID=" . $AppID;
 echo '';
 if (!($result = mysql_query($query))) {
 throw new Exception("Query failed in declaration.inc: " . $query);
 }
 $row = mysql_fetch_array($result);
 $MemberFirmID = $row['Prev_FirmID'];
}

$aDecMemberFirmObj = new ADec_tblMemberFirms($sqlf);
$aDecMemberFirm = $aDecMemberFirmObj->getOrCreate($MemberFirmID, $DeclarationYear);

// **************************************************************************************
// Get the Principal responsible person.
// **************************************************************************************
$aDecOfficeContactsObj = new ADec_OfficeContacts($sqlf);

$mandatedPrincipal = $aDecOfficeContactsObj->getOrCreateOneMandatedPrincipal($MemberFirmID, $DeclarationYear);

if (is_array($mandatedPrincipal) && count($mandatedPrincipal) > 0) {
    
    $MemberContactID = $mandatedPrincipal['ContactsID'];

$query = "SELECT * FROM ADec_Contacts WHERE ContactsID = '$MemberContactID'";
    if (!($result = mysql_query($query))) {
        throw new Exception("Query failed in declaration.inc: " . $query);
    }
    $row = mysql_fetch_array($result);
    $MemberContactSurname = $row['ContactSurname'];
    $MemberContactFirstname = $row['ContactFirstName'];
    $MemberContactDesignation = $row['ContactDesignation'];
}

$Squery = "SELECT Prev_FirmID FROM ADec_tblMemberFirms WHERE ADec_tblMemberFirms.Prev_FirmID = '$MemberFirmID'";
echo '';
//exit;

if (!($Sresult = mysql_query($Squery))) {
    throw new Exception("Query failed in declaration.inc: " . $Squery);
}
$row = mysql_fetch_array($Sresult);

// **************************************************************************************
// Count how many Firm Offices there are.
// **************************************************************************************
$Squery = "SELECT * 
 FROM ADec_tblMemberFirmOffices 
 WHERE Prev_FirmID = '$MemberFirmID' 
 AND (SaaceBranch<>'International' OR SaaceBranch IS NULL) 
 AND DeclarationYear = $DeclarationYear";
if (!($Sresult = mysql_query($Squery))) {
 throw new Exception("Query failed in declaration.inc: " . $Squery);
}
$OfficeCount = mysql_num_rows($Sresult);

$Squery = "SELECT  * FROM ADec_tblMemberFirmOffices WHERE Prev_FirmID = '$MemberFirmID' AND SaaceBranch='International'";
if (!($Sresult = mysql_query($Squery))) {
    throw new Exception("Query failed in declaration.inc: " . $Squery);
}
$OfficeCountInternat = mysql_num_rows($Sresult);

//     mysql_connect("$host","$user","$password") or die("Unable to connect to SQL server");
//     mysql_select_db("$db") or die("Unable to select database");
$Squery = "SELECT  * FROM ADec_tblMemberFirmOffices WHERE ADec_tblMemberFirmOffices.Prev_FirmID = '$MemberFirmID'";
if (!($Sresult = mysql_query($Squery))) {
    throw new Exception("Query failed in declaration.inc: " . $Squery);
}
if ($Srow = mysql_fetch_array($Sresult)) {
    $OfficeID = $Srow['OfficeID'];
    $OfficeStatus = $Srow['OfficeStatus'];
    $OfficeBuilding = $Srow['BldgName'];
    $OfficeStreet = $Srow['StreetName'];
    $OfficeSuburb = $Srow['Suburb'];
    $OfficeName = $Srow['OfficeName'];
    $OfficeLanguage = $Srow['Language'];
    $OfficeTownCity = $Srow['TownCity'];
    $OfficeCode = $Srow['PostalCode'];
    $OfficeProvince = $Srow['Province'];
    $OfficePostalAdd = $Srow['PostalAddress'];
    $OfficeTel = $Srow['Telephone'];
    $OfficeFax = $Srow['Fax'];
    $OfficeEmail = $Srow['Email'];
    $OfficeLocalM = $Srow['GeoLocationLocal'];
    $OfficeDistrict = $Srow['GeoLocationDistrict'];
    $OfficeAddress2 = $Srow['Address2'];
    $OfficeGeoLocation = $Srow['GeoLocation'];
}

// **************************************************************************************
// Get the Firm Details that is valid for the Member firm logged on.
// **************************************************************************************
// mysql_connect("$host","$user","$password") or die("Unable to connect to SQL server");
// mysql_select_db("$db") or die("Unable to select database");
$query = "SELECT * FROM ADec_tblMemberFirms 
 WHERE Prev_FirmID = '$MemberFirmID' AND DeclarationYear = " . $DeclarationYear;
// echo $query . ' ';

if (!($result = mysql_query($query))) {
    throw new Exception("Query failed in declaration.inc: " . $query);
}
$row = mysql_fetch_array($result);
$MemberFirmName = $row['FirmName'];
$MemberFirmInsurer = $row['PIUnderwriter'];
$MemberFirmLevelCover = $row['LevelOfCover'];

if ($MemberFirmLevelCover <= 0) {
 $MemberFirmLevelCover = $row['LevelOfCoverShort'];
} else {
 $MemberFirmLevelCover = number_format($MemberFirmLevelCover, 0, ".", "");
}

//echo 'Please ignore debug data ';
//var_dump($row);
//echo 'Please ignore debug data ';
//echo $MemberFirmLevelCover;
//exit;
//Pull data from member database
//if (strlen($row['ProcurementContact']) <= 0) {
// //Member has not completed an AD yet. Pull data from tblMemberFirms
// $query = "SELECT * FROM tblMemberFirms WHERE FirmID = '$MemberFirmID'";
// echo 'Please ignore debug info ' . $query . ' Please ignore debug info ';
// $result = mysql_query($query) or die($query);
// $row = mysql_fetch_array($result);
//}

$MemberFirmFormIncorp = $row['FormOfIncorporation'];
$MemberFirmISO = $row['Quality Management'];
$MemberFirmDateReview = $row['Date of last peer review'];
$MemberFirmURL = $row['URL'];
$M1 = $row['Acoustics'];
$M2 = $row['Agricultural'];
$M3 = $row['BuildingServices'];
$M4 = $row['Chemical'];
$M5 = $row['Civil'];
$M6 = $row['Development'];
$M7 = $row['Electrical'];
$M8 = $row['Electronic'];
$M9 = $row['Environmental'];
$M10 = $row['Geotechnical'];
$M11 = $row['Industrial'];
$M12 = $row['Mechanical'];
$M13 = $row['Marine'];
$M14 = $row['Mining'];
$M15 = $row['Process'];
$M16 = $row['Structural'];
$M17 = $row['Transportation'];
$M18 = $row['Architecture'];
$M19 = $row['RuralDevelopment'];
$M20 = $row['ProjectManagement'];
$M21 = $row['QuantitySurveying'];
$M22 = $row['TownPlanning'];
$M23 = $row['Multidisciplinary'];
$M24 = $row['DisputeResolution'];
$M25 = $row['ExpertWitness'];
$M26 = $row['InformationSystems'];
$M27 = $row['FacilitiesManagement'];
$M28 = $row['GIS'];

$N1 = $row['AcousticsName'] . "";
$N2 = $row['AgriculturalName'] . "";
$N3 = $row['BuildingServicesName'] . "";
$N4 = $row['ChemicalName'] . "";
$N5 = $row['CivilName'] . "";
$N6 = $row['DevelopmentName'] . "";
$N7 = $row['ElectricalName'] . "";
$N8 = $row['ElectronicName'] . "";
$N9 = $row['EnvironmentalName'] . "";
$N10 = $row['GeotechnicalName'] . "";
$N11 = $row['IndustrialName'] . "";
$N12 = $row['MechanicalName'] . "";
$N13 = $row['MarineName'] . "";
$N14 = $row['MiningName'] . "";
$N15 = $row['ProcessName'] . "";
$N16 = $row['StructuralName'] . "";
$N17 = $row['TransportationName'] . "";
$N18 = $row['ArchitectureName'] . "";
$N19 = $row['RuralDevelopmentName'] . "";
$N20 = $row['ProjectManagementName'] . "";
$N21 = $row['QuantitySurveyingName'] . "";
$N22 = $row['TownPlanningName'] . "";
$N23 = $row['MultidisciplinaryName'] . "";
$N24 = $row['DisputeResolutionName'] . "";
$N25 = $row['ExpertWitnessName'] . "";
$N26 = $row['InformationSystemsName'] . "";
$N27 = $row['FacilitiesManagementName'] . "";
$N28 = $row['GISName'] . "";

$P1 = $row['AcousticsProject'] . "";
$P2 = $row['AgriculturalProject'] . "";
$P3 = $row['BuildingServicesProject'] . "";
$P4 = $row['ChemicalProject'] . "";
$P5 = $row['CivilProject'] . "";
$P6 = $row['DevelopmentProject'] . "";
$P7 = $row['ElectricalProject'] . "";
$P8 = $row['ElectronicProject'] . "";
$P9 = $row['EnvironmentalProject'] . "";
$P10 = $row['GeotechnicalProject'] . "";
$P11 = $row['IndustrialProject'] . "";
$P12 = $row['MechanicalProject'] . "";
$P13 = $row['MarineProject'] . "";
$P14 = $row['MiningProject'] . "";
$P15 = $row['ProcessProject'] . "";
$P16 = $row['StructuralProject'] . "";
$P17 = $row['TransportationProject'] . "";
$P18 = $row['ArchitectureProject'] . "";
$P19 = $row['RuralDevelopmentProject'] . "";
$P20 = $row['ProjectManagementProject'] . "";
$P21 = $row['QuantitySurveyingProject'] . "";
$P22 = $row['TownPlanningProject'] . "";
$P24 = $row['DisputeResolutionProject'] . "";
$P25 = $row['ExpertWitnessProject'] . "";
$P26 = $row['InformationSystemsProject'] . "";
$P27 = $row['FacilitiesManagementProject'] . "";
$P28 = $row['GISProject'] . "";

$Q1 = $row['QMSPlan'];
$Q2 = $row['QMSDocs'];
$Q3 = $row['QMSISOComply'];
$Q4 = $row['QMSISOCert'];
$Q5 = $row['QMSOffices'];
$Q6 = $row['QMSConsult'];
$Q7 = $row['QMSCertBody'];
$partydate = $row['QMSISOCertDate'];
$Q8 = $row['QMSImplemented'];
$Q9 = $row['QMSImplFully'];
$Q10 = $row['QMSImplPart'];
$Q11 = $row['QMSAssess'];
$Q12 = $row['QMSUseConsult'];
$Q13 = $row['QMSIntend'];

$datereceived = $row['DeclarationReceived'];

$MentoringProg = $row['MentoringProg'];
$CandidateProg = $row['CandidateProg'];
$SubscriptionsContact = $row['SubscriptionsContact'];
$SubscriptionsEmail = $row['SubscriptionsEmail'];
$HRTrainingContact = $row['HRTrainingContact'];
$HRTrainingEmail = $row['HRTrainingEmail'];
$MarketingContact = $row['MarketingContact'];
$MarketingEmail = $row['MarketingEmail'];
$YPFContact = $row['YPFContact'];
$YPFEmail = $row['YPFEmail'];
$ProcurementContact = $row['ProcurementContact'];
$ProcurementEmail = $row['ProcurementEmail'];
$SubscriptionsTel = $row['SubscriptionsTel'];
$HRTrainingTel = $row['HRTrainingTel'];
$MarketingTel = $row['MarketingTel'];
$ProcurementTel = $row['ProcurementTel'];
$YPFContactTel = $row['YPFContactTel'];
$GoToPersonName = $row['GoToPersonName'];
$GoToPersonTel = $row['GoToPersonTel'];
$GoToPersonEmail = $row['GoToPersonEmail'];

$qQMIG = $row['QMIG'];
$qQChampName = $row['QMSChampName'];
$qQChampEmail = $row['QMSChampEmail'];

$SustainabilityPolicy = $row['SustainabilityPolicy'];
$SustainabilityIssues = $row['SustainabilityIssues'];
$SustainabilityProcess = $row['SustainabilityProcess'];
$SustainabilityFramework = $row['SustainabilityFramework'];
$SustainabilityDiscussed = $row['SustainabilityDiscussed'];
$SustainabilityIndicator1 = $row['SustainabilityIndicator1'];
$SustainabilityIndicator2 = $row['SustainabilityIndicator2'];
$SustainabilityIndicator3 = $row['SustainabilityIndicator3'];
$SustainabilityIndicator4 = $row['SustainabilityIndicator4'];
$SustainabilityIndicator5 = $row['SustainabilityIndicator5'];
$SustainabilityChampion = $row['SustainabilityChampion'];
$qSChampName = $row['SustainabilityChampName'];
$qSChampEmail = $row['SustainabilityChampEmail'];

$CaUSigned = $row['CAUSigned'];
$BBBEE = $row['BBBEE'];
$SMME = $row['SMME'];
$BlackOwned = $row['BlackOwned'];
$BlackWomenOwned = $row['BlackWomenOwned'];
$WomenOwned = $row['WomenOwned'];
$SABTACO = $row['SABTACO'];
$BBCBE = $row['BBCBE'];
$GBCSA = $row['GBCSA'];
$TotalStaff = $row["TotalStaff"];
$ImmigratedStaff = $row["ImmigratedStaff"];
$LevelOfCoverShort = $row['LevelOfCoverShort'];

if (false && $_SESSION["username"] == 'cesatesting') {
 // echo 'Please ignore debug info: ' . $WomenOwned . ' <textarea cols=30>' . $query . '</textarea>';
 // exit;
}

if (empty($TotalStaff)) {

$query = "SELECT ((SUM(`ADec_tblMemberFirmOffices`.`ProfessionalStaff`) + SUM(`ADec_tblMemberFirmOffices`.`NonProfTechStaff`)) + SUM(`ADec_tblMemberFirmOffices`.`OtherStaff`)) AS `TotalStaff`
	FROM `ADec_tblMemberFirmOffices` WHERE Prev_FirmID = '$MemberFirmID'";
    if (!($result = mysql_query($query))) {
        throw new Exception("Query failed in declaration.inc: " . $query);
    }
    if ($row = mysql_fetch_array($result)) {
        $TotalStaff = $row["TotalStaff"];
    }
}

$query = "SELECT * FROM ADec_Transformation WHERE Prev_FirmID = '$MemberFirmID' AND DeclarationYear = '$DeclarationYear'";
if (!($result = mysql_query($query))) {
    throw new Exception("Query failed in declaration.inc: " . $query);
}
if ($row = mysql_fetch_array($result)) {
    $TransTopMA = $row['TransTopMA'];
    $TransTopMC = $row['TransTopMC'];
    $TransTopMI = $row['TransTopMI'];
    $TransTopMW = $row['TransTopMW'];
    $TransTopFA = $row['TransTopFA'];
    $TransTopFC = $row['TransTopFC'];
    $TransTopFI = $row['TransTopFI'];
    $TransTopFW = $row['TransTopFW'];
    $TransTopMN = $row['TransTopMN'];
    $TransTopFN = $row['TransTopFN'];
    $TransSeniorMA = $row['TransSeniorMA'];
    $TransSeniorMC = $row['TransSeniorMC'];
    $TransSeniorMI = $row['TransSeniorMI'];
    $TransSeniorMW = $row['TransSeniorMW'];
    $TransSeniorFA = $row['TransSeniorFA'];
    $TransSeniorFC = $row['TransSeniorFC'];
    $TransSeniorFI = $row['TransSeniorFI'];
    $TransSeniorFW = $row['TransSeniorFW'];
    $TransSeniorMN = $row['TransSeniorMN'];
    $TransSeniorFN = $row['TransSeniorFN'];
    $TransProfMA = $row['TransProfMA'];
    $TransProfMC = $row['TransProfMC'];
    $TransProfMI = $row['TransProfMI'];
    $TransProfMW = $row['TransProfMW'];
    $TransProfFA = $row['TransProfFA'];
    $TransProfFC = $row['TransProfFC'];
    $TransProfFI = $row['TransProfFI'];
    $TransProfFW = $row['TransProfFW'];
    $TransProfMN = $row['TransProfMN'];
    $TransProfFN = $row['TransProfFN'];
    $TransSkilledMA = $row['TransSkilledMA'];
    $TransSkilledMC = $row['TransSkilledMC'];
    $TransSkilledMI = $row['TransSkilledMI'];
    $TransSkilledMW = $row['TransSkilledMW'];
    $TransSkilledFA = $row['TransSkilledFA'];
    $TransSkilledFC = $row['TransSkilledFC'];
    $TransSkilledFI = $row['TransSkilledFI'];
    $TransSkilledFW = $row['TransSkilledFW'];
    $TransSkilledMN = $row['TransSkilledMN'];
    $TransSkilledFN = $row['TransSkilledFN'];
    $TransSemiMA = $row['TransSemiMA'];
    $TransSemiMC = $row['TransSemiMC'];
    $TransSemiMI = $row['TransSemiMI'];
    $TransSemiMW = $row['TransSemiMW'];
    $TransSemiFA = $row['TransSemiFA'];
    $TransSemiFC = $row['TransSemiFC'];
    $TransSemiFI = $row['TransSemiFI'];
    $TransSemiFW = $row['TransSemiFW'];
    $TransSemiMN = $row['TransSemiMN'];
    $TransSemiFN = $row['TransSemiFN'];
    $TransUnskillMA = $row['TransUnskillMA'];
    $TransUnskillMC = $row['TransUnskillMC'];
    $TransUnskillMI = $row['TransUnskillMI'];
    $TransUnskillMW = $row['TransUnskillMW'];
    $TransUnskillFA = $row['TransUnskillFA'];
    $TransUnskillFC = $row['TransUnskillFC'];
    $TransUnskillFI = $row['TransUnskillFI'];
    $TransUnskillFW = $row['TransUnskillFW'];
    $TransUnskillMN = $row['TransUnskillMN'];
    $TransUnskillFN = $row['TransUnskillFN'];
    $TransTempMA = $row['TransTempMA'];
    $TransTempMC = $row['TransTempMC'];
    $TransTempMI = $row['TransTempMI'];
    $TransTempMW = $row['TransTempMW'];
    $TransTempFA = $row['TransTempFA'];
    $TransTempFC = $row['TransTempFC'];
    $TransTempFI = $row['TransTempFI'];
    $TransTempFW = $row['TransTempFW'];
    $TransTempMN = $row['TransTempMN'];
    $TransTempFN = $row['TransTempFN'];
    $ThreeYearsAverageTurnover = $row['ThreeYearsAverageTurnover'];
}

$QSEParticipation = array();
$QSERating = array();

$query = "SELECT * FROM QualitySurvey WHERE FirmID = '$MemberFirmID' ORDER BY DateCreated DESC";
if (!($result = mysql_query($query))) {
    throw new Exception("Query failed in declaration.inc: " . $query);
}
if ($row = mysql_fetch_array($result)) {
    $OverallService = $row["OverallService"];
    $OverallServiceSuggestion = $row["OverallServiceSuggestion"];
    $PersonnelService = $row["PersonnelService"];
    $PersonnelServiceSuggestion = $row["PersonnelServiceSuggestion"];
    $FocusNeeds = $row["FocusNeeds"];
    $NeedsService = $row["NeedsService"];
    $AwareBenefits = $row["AwareBenefits"];
    $QualitySuggestions = $row["QualitySuggestions"];
    $BenefitsPublicSector = $row["BenefitsPublicSector"];
    $BenefitsVoice = $row["BenefitsVoice"];
    $BenefitsTrends = $row["BenefitsTrends"];
    $BenefitsRecognition = $row["BenefitsRecognition"];
    $BenefitsNetworking = $row["BenefitsNetworking"];
    $BenefitsTraining = $row["BenefitsTraining"];

$query = "SELECT * FROM QualitySurveyEvents WHERE QSID=" . $row["QSID"];
    if (!($result = mysql_query($query))) {
        throw new Exception("Query failed in declaration.inc: " . $query);
    }
    while ($row = mysql_fetch_array($result)) {
        $QSEParticipation[$row["EventName"]] = $row["Participation"];
        $QSERating[$row["EventName"]] = $row["Rating"];
    }
}

//    echo "M1 :", $M1;
//    echo "M2 :", $M2;
//    echo "M3 :", $M3;
//    echo "M4 :", $M4;
// **************************************************************************************
// Get the Firm ID that  is valid for the Member firm logged on.
// **************************************************************************************
//     mysql_connect("$host","$user","$password") or die("Unable to connect to SQL server");
//     mysql_select_db("$db") or die("Unable to select database");
$query = "SELECT * FROM ADec_tblMemberFirmOffices WHERE OfficeID = '$SelectOfficeID'";
if (!($result = mysql_query($query))) {
    throw new Exception("Query failed in declaration.inc: " . $query);
}
if ($row = mysql_fetch_array($result)) {
    $MemberProffStaff = $row['ProfessionalStaff'];
    $MemberNonProff = $row['NonProfTechStaff'];
    $MemberOtherStaff = $row['OtherStaff'];
}