Gecko [ v3.cesa.co.za ]

Name	Size	Permission	Date
auth.inc	734 B	-rw-r--r--	2010-05-27 04:41
conf.inc	2.59 KB	-rw-r--r--	2018-08-01 08:50
database.inc	351 B	-rw-r--r--	2012-02-13 09:24
db.inc	324 B	-rw-r--r--	2020-01-09 09:27
declaration.inc	10.96 KB	-rw-r--r--	2019-02-20 11:15
footer.inc	743 B	-rw-r--r--	2025-03-05 12:29
footer2.inc	157 B	-rw-r--r--	2010-05-27 04:41
func.inc	2.72 KB	-rw-r--r--	2010-05-27 04:41
log_query.php	154 B	-rw-r--r--	2010-05-28 11:22
menu.inc	631 B	-rw-r--r--	2020-01-08 10:37
smenu.inc	627 B	-rw-r--r--	2020-01-08 10:37

Rename

<?php

// **************************************************************************************
// All the variables for the reading of the information of the Annual Declaration
// **************************************************************************************
$host = "sql1.cpt2.host-h.net";
$user = "saacea_1";
$password = "heJxoP40d";
$db = "saacedb";
mysql_connect("$host","$user","$password") or die("Unable to connect to SQL server");
mysql_select_db("$db") or die("Unable to select database");
if (isset($_GET["ApplicationID"])) {
	$sql="SELECT FirmID FROM ADec_tblMemberFirms WHERE ApplicationID=".intval($_GET["ApplicationID"]);
	$Sresult = mysql_query($sql) or die($sql);
	$Srow = mysql_fetch_array($Sresult);
	$MemberFirmID=$Srow["FirmID"];
} else {
	$MemberFirmID=$_GET["FirmID"];
}
// **************************************************************************************
// Count how many Firm Offices there are.
// **************************************************************************************
	$Squery = "SELECT  * FROM ".$sOfficesTable." WHERE ".$sFirmID." = '$MemberFirmID' AND (SaaceBranch<>'International' OR SaaceBranch IS NULL)";
	$Sresult = mysql_query($Squery) or die($Squery);
	$OfficeCount = mysql_num_rows($Sresult);

$Squery = "SELECT  * FROM ".$sOfficesTable." WHERE ".$sFirmID." = '$MemberFirmID' AND SaaceBranch='International'";
	$Sresult = mysql_query($Squery) or die($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 ".$sOfficesTable." WHERE ".$sOfficesTable.".".$sFirmID." = '$MemberFirmID'";
	$Sresult = mysql_query($Squery) or die($Squery);
	$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 ".$sFirmsTable." WHERE ".$sFirmID." = '$MemberFirmID'";
	echo $query;
	$result = mysql_query($query) or die($query);
	$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'];
	$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']."";

$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'];

$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'];

$query = "SELECT * FROM ADec_Transformation WHERE Prev_FirmID = '$MemberFirmID'";
	$result = mysql_query($query) or die($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'];

}
	
//    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 ".$sOfficesTable." WHERE OfficeID = '$SelectOfficeID'";
	$result = mysql_query($query) or die($query);
	$row = mysql_fetch_array($result);
	$MemberProffStaff = $row['ProfessionalStaff'];
	$MemberNonProff = $row['NonProfTechStaff'];	
	$MemberOtherStaff = $row['OtherStaff'];		
	
	*/
?>