Gecko [ v3.cesa.co.za ]

Name	Size	Permission	Date
memberlogin.php	100 B	-rw-r--r--	2018-03-06 12:55
officedata.php	6.56 KB	-rw-r--r--	2020-01-24 10:30
searchresults.php	7 KB	-rw-r--r--	2020-01-24 10:25

Rename

<?php
include_once("/usr/www/users/saacea/php/inc_db.php");

$officeid=intval($_REQUEST["OfficeID"]);

$sql = "SELECT
tblMemberFirmOffices.OfficeStatus,
tblMemberFirmOffices.OfficeName,
tblMemberFirmOffices.Address2,
tblMemberFirmOffices.PostalAddress,
tblMemberFirmOffices.GeoLocation,
tblMemberFirmOffices.TownCity,
tblMemberFirmOffices.PostalCode,
tblMemberFirmOffices.Country,
tblMemberFirmOffices.BldgName,
tblMemberFirmOffices.StreetName,
tblMemberFirmOffices.Suburb,
tblMemberFirmOffices.Telephone,
tblMemberFirmOffices.Fax,
tblMemberFirmOffices.Email,
tblMemberFirmOffices.FullOrPartTime,
tblMemberFirmOffices.OtherStaff,
tblMemberFirmOffices.ProfessionalStaff,
tblMemberFirmOffices.NonProfTechStaff,
tblMemberFirms.URL,
tblMemberFirms.Acoustics,
tblMemberFirms.Agricultural,
tblMemberFirms.BuildingServices,
tblMemberFirms.Chemical,
tblMemberFirms.Civil,
tblMemberFirms.Development,
tblMemberFirms.Electrical,
tblMemberFirms.Electronic,
tblMemberFirms.Environmental,
tblMemberFirms.Geotechnical,
tblMemberFirms.Industrial,
tblMemberFirms.Mechanical,
tblMemberFirms.Marine,
tblMemberFirms.Mining,
tblMemberFirms.Process,
tblMemberFirms.Structural,
tblMemberFirms.Transportation,
tblMemberFirms.Architecture,
tblMemberFirms.RuralDevelopment,		
tblMemberFirms.ProjectManagement,
tblMemberFirms.QuantitySurveying,
tblMemberFirms.TownPlanning,
tblMemberFirms.Multidisciplinary,
tblMemberFirms.DisputeResolution,
tblMemberFirms.ExpertWitness,
tblMemberFirms.InformationSystems,
tblMemberFirms.FacilitiesManagement,
tblMemberFirms.GIS,
tblMemberFirms.QMSISOComply,
tblMemberFirms.QMSISOCert,
tblMemberFirms.BBBEE
FROM tblMemberFirmOffices, tblMemberFirms WHERE (tblMemberFirmOffices.OfficeID = '$officeid') 
AND (tblMemberFirmOffices.FullOrPartTime = 'Full Time') AND (tblMemberFirmOffices.FirmID = tblMemberFirms.FirmID)";
//echo $sql;

$result = mysql_query($sql) or die('An error has occured. Please go back and select another option.');
$result_rows = mysql_num_rows($result);
if ($result_rows > 0) {
	if ($row=mysql_fetch_array($result)) {
		$pagetitle=$pagetitle.$row["OfficeName"];
		echo "<h1>Member Firm Details</h1>";
		echo "";
		echo "<h4>".$row["OfficeName"]."</h4>";
		echo "";
		echo "<table width=\"100%\" border=\"0\" cellpadding=\"5\" cellspacing=\"1\">";
		echo "<tr><td valign=\"top\" bgcolor=\"$graylight\">Company</td><td valign=\"top\">".$row["OfficeName"]."</td></tr>";
		echo "<tr><td valign=\"top\" bgcolor=\"$graylight\">Office</td><td valign=\"top\">".$row["OfficeStatus"]."</td></tr>";
		echo "<tr><td valign=\"top\" bgcolor=\"$graylight\">Physical Address</td><td valign=\"top\">";
		if ($row["BldgName"] != '') { echo $row["BldgName"]." "; }
		echo $row["StreetName"]." ".$row["Suburb"]."</td></tr>";
		echo "<tr><td valign=\"top\" bgcolor=\"$graylight\">Postal Address</td><td valign=\"top\">";
		if ($row["Address2"] != '') { echo $row["Address2"]." "; }
		echo $row["PostalAddress"]." ".$row["TownCity"]." ".$row["GeoLocation"]." ".$row["PostalCode"]." ".$row["Country"]."</td></tr>";
		echo "<tr><td valign=\"top\" bgcolor=\"$graylight\">Geographic Location</td><td valign=\"top\">".$row["GeoLocation"]."</td></tr>";
		echo "<tr><td valign=\"top\" bgcolor=\"$graylight\">Telephone</td><td valign=\"top\">".$row["Telephone"]."</td></tr>";
		echo "<tr><td valign=\"top\" bgcolor=\"$graylight\">Fax</td><td valign=\"top\">".$row["Fax"]."</td></tr>";
		echo "<tr><td valign=\"top\" bgcolor=\"$graylight\">Email</td><td valign=\"top\">".generate_obfuscated_mailto($row["Email"])."</td></tr>";
		if ($row["URL"]) {
			if (eregi("http://",$row["URL"])) {
				echo "<tr><td valign=\"top\" bgcolor=\"$graylight\">Website</td><td valign=\"top\"><a href=\"".$row["URL"]."\" target=\"_blank\" class=\"external\">".$row["URL"]."</a></td></tr>";
			} else {
				echo "<tr><td valign=\"top\" bgcolor=\"$graylight\">Website</td><td valign=\"top\"><a href=\"http://".$row["URL"]."\" target=\"_blank\" class=\"external\">".$row["URL"]."</a></td></tr>";
			}
		} else {
			echo "<tr><td valign=\"top\" bgcolor=\"$graylight\">Website</td><td valign=\"top\">None</td></tr>";
		}
		echo "<tr><td valign=\"top\" bgcolor=\"$graylight\">Full or Part Time</td><td valign=\"top\">".$row["FullOrPartTime"]."</td></tr>";
		$total = $row["ProfessionalStaff"] + $row["NonProfTechStaff"] + $row["OtherStaff"];
		echo "<tr><td valign=\"top\" bgcolor=\"$graylight\">Total Staff</td><td valign=\"top\">".$total."</td></tr>";
		if (!empty($row["BBBEE"])) {
			echo "<tr><td valign=\"top\" bgcolor=\"$graylight\">BBBEE Level</td><td valign=\"top\">".$row["BBBEE"]."</td></tr>";
		}
		echo "<tr><td valign=\"top\" bgcolor=\"$graylight\">Skills & Specialisations</td><td valign=\"top\">";
		if ($row["Acoustics"] == 1) { echo "Accoustics "; }
		if ($row["Agricultural"] == 1) { echo "Agricultural "; }
		if ($row["BuildingServices"] == 1) { echo "Building Services "; }
		if ($row["Chemical"] == 1) { echo "Chemical "; }
		if ($row["Civil"] == 1) { echo "Civil "; }
		if ($row["Development"] == 1) { echo "Development "; }
		if ($row["Electrical"] == 1) { echo "Electrical "; }
		if ($row["Electronic"] == 1) { echo "Electronic "; }
		if ($row["Environmental"] == 1) { echo "Environmental "; }
		if ($row["Geotechnical"] == 1) { echo "Geotechnical "; }
		if ($row["Industrial"] == 1) { echo "Industrial "; }
		if ($row["Mechanical"] == 1) { echo "Mechanical "; }
		if ($row["Marine"] == 1) { echo "Marine "; }
		if ($row["Mining"] == 1) { echo "Mining "; }
		if ($row["Process"] == 1) { echo "Process "; }
		if ($row["Structural"] == 1) { echo "Structural "; }
		if ($row["Transportation"] == 1) { echo "Transportation "; }
		if ($row["Architecture"] == 1) { echo "Architecture "; }
		if ($row["RuralDevelopment"] == 1) { echo "Rural Development "; }
		if ($row["ProjectManagement"] == 1) { echo "Project Management "; }
		if ($row["QuantitySurveying"] == 1) { echo "Quantity Surveying "; }
		if ($row["TownPlanning"] == 1) { echo "Town Planning "; }
		if ($row["Multidisciplinary"] == 1) { echo "Multidisciplinary "; }
		if ($row["DisputeResolution"] == 1) { echo "Dispute Resolution "; }
		if ($row["ExpertWitness"] == 1) { echo "Expert Witness "; }
		if ($row["InformationSystems"] == 1) { echo "Information Systems "; }
		if ($row["FacilitiesManagement"] == 1) { echo "Facilities Management "; }
		if ($row["GIS"] == 1) { echo "GIS "; }

if (strtolower($row["QMSISOComply"]) == "y") { echo " Has implemented a Quality Management System "; }
		if (strtolower($row["QMSISOCert"]) == "y") { echo " (ISO Certified QMS) "; }

echo "</td></tr>";
		echo "</table>";
		echo "";
	} //end if
}
?>