Gecko [ v3.cesa.co.za ]

Name	Size	Permission	Date
images	[ DIR ]	drwxr-sr-x	2010-05-27 06:28
inc_printheader.php	269 B	-rw-r--r--	2010-05-27 04:41
inc_schedule1.php	15.67 KB	-rw-r--r--	2011-01-18 10:48
inc_schedule1b.php	10.88 KB	-rw-r--r--	2011-01-18 10:48
inc_schedule1p2.php	18.59 KB	-rw-r--r--	2011-03-31 07:59
part1.php	98.26 KB	-rw-r--r--	2025-11-20 13:55
part2.php	2.91 KB	-rw-r--r--	2018-08-01 08:49

Rename

<?php
// Get this office
	$Squery = "SELECT * FROM ".$sOfficesTable." 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'];

$pictoshow1 = "../pics/unselected.jpg";
	 	 $pictoshow2 = "../pics/unselected.jpg";
	 	 $pictoshow3 = "../pics/unselected.jpg";		 
	 	 $pictoshow4 = "../pics/unselected.jpg";
		 		 		 		 		 
		 if ($OfficeStatus == "Head Office")
		 {
			 $pictoshow1 = "../pics/selected.gif";
			 }
		 if ($OfficeStatus == "Branch")
		 {
			 $pictoshow3 = "../pics/selected.gif";
			 }
		 if ($OfficeStatus == "Only Office")
		 {
	 	 $pictoshow2 = "../pics/selected.gif";			 			 
			 }
		 if ($OfficeStatus == "Subsidiary Company")
		 {
	 	 $pictoshow4 = "../pics/selected.gif";			 			 
			 }
?>
<table width="100%" align="center">
 <tr> 
 <td align="center" valign="top"><table width="100%" border="0">
 <tr> 
 <td width="14%">Name of Firm:</td>
 <td width="39%"> 
 <?php echo $OfficeName; ?> </td>
 <td width="47%" rowspan="3"><table border=0 cellspacing=0 cellpadding=0>
 <tr>
 <td width=25% valign=top class="Normal" height="14">Head 
 Office</td>
 <td width=25% valign=top class="Normal" height="14">Only 
 Office</td>
 <td width=25% valign=top class="Normal" height="14">Branch 
 Office</td>
 <td width=25% valign=top class="Normal" height="14">Subsidiary 
 Company </td>
 </tr>
 <tr>
 <td width=25% valign=top class="Normal"><img src="<?php echo $pictoshow1; ?>" ></td>
 <td width=25% valign=top class="Normal"><img src="<?php echo $pictoshow2; ?>" ></td>
 <td width=25% valign=top class="Normal"><img src="<?php echo $pictoshow3; ?>" ></td>
 <td width=25% valign=top class="Normal"><img src="<?php echo $pictoshow4; ?>" ></td>
 </tr>
 </table></td>
 </tr>
 <tr>
 <td>Postal Address:</td>
 <td><?php 
				if (trim($OfficePostalAdd."") =="") {
					//show the physical address
					echo $OfficeBuilding." ".$OfficeStreet." ".$OfficeSuburb." ".$OfficeGeoLocation;
				} else {
					echo $OfficePostalAdd." ".$OfficePostalAddress2." ".$OfficeTownCity;
				}
?>
 
 <?php echo $OfficeCode; ?> </td>
 </tr>
 <tr>
 <td>Telephone 
 No:</td>
 <td><?php echo $OfficeTel; ?></td>
 </tr>
 </table>
 </td>
 </tr>
</table>
<table width="100%" cellpadding="0" cellspacing="0" style="page-break-before:always;">
 <tr> 
 <td align="center" valign="top">DETAILS OF ALL PRINCIPALS AND PROFESSIONAL STAFF AT THIS BRANCH 
 ONLY
 <table width="100%" border="0" cellspacing="0" cellpadding="0">
 <?php 
		//here we do a while to show the info
		 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 ContactsID, ".$sContactsID.", ContactPosition, 
	MandatedPrincipal, 
	OfficeHead, 
	OfficeID, 
	".$sOfficeID.", 
	Principal, 
	Email, 
	Mail, 
	OfficeLiaison, 
	OfficeLiaisonB, 
	SchoolMail, 
	YPF FROM ".$sOfficeContactsTable." WHERE OfficeID = '$SelectOfficeID'";
	 $result = mysql_query($query) or die("Select of id Failed");
		 $iRecordNum = 0;
		 $iCellNum = 0;
 while (($rs = mysql_fetch_array($result)))
		{
		$therightid = $rs[0];
		$iRecordNum++;
		$iCellNum++;
		// Get the relevant details to display
		mysql_connect("$host","$user","$password") or die("Unable to connect to SQL server");
 mysql_select_db("$db") or die("Unable to select database"); 
 $query2 = "SELECT ContactsID, ContactSurname, ContactInitials, ContactFirstName, ProfessionalRegistrations, Qualifications, Comments, PreferredEmail, IDNumber, CellPhone FROM ".$sContactsTable." WHERE ContactsID = '$therightid'";
	 $result2 = mysql_query($query2) or die("Select of id Failed");
		 $ps = mysql_fetch_array($result2);		
		
	 	 $pictoshow1 = "../pics/unselected.jpg";
		 if ($rs[7] == 1)
		 {
			 $pictoshow1 = "../pics/selected.gif";
			 }
	 	 $pictoshow2 = "../pics/unselected.jpg";
		 if ($rs[13] == 'y')
		 {
			 $pictoshow2 = "../pics/selected.gif";
			 }
		
		$bBeginRow = false;
		$bEndRow = false;
		
		if ($iCellNum == 1) $bBeginRow = true;
		if ($iCellNum == 4) {
			$bEndRow = true;
			$iCellNum = 0;
		}
		
		if ($bBeginRow) {
		?>
 <tr>
 <td valign="top" width="25%"><table width="100%" border="0" cellspacing="0" cellpadding="0">
 <tr>
 <td><img src=images/spacer.gif width="1" height=24></td>
 <td>&nbsp;</td>
 </tr>
 <tr>
 <td><img src=images/spacer.gif width="1" height=24></td>
 <td style="border:1px solid black">SURNAME</td>
 </tr>
 <tr>
 <td><img src=images/spacer.gif width="1" height=24></td>
 <td style="border:1px solid black">INITIALS</td>
 </tr>
 <tr>
 <td valign="top"><img src=images/spacer.gif width="1" height=40></td>
 <td valign="top" style="border:1px solid black">KNOWN AS (e.g. &ldquo;Bill&rdquo; for &ldquo;William&rdquo;) </td>
 </tr>
 <tr>
 <td><img src=images/spacer.gif width="1" height=80></td>
 <td valign="top" style="border:1px solid black">Professional 
 Registration (if any) number and date (PrEng, PrTechEng,Quantity Surveyor, 
 Architect, CA(SA) , full Membership of Institutions etc)</td>
 </tr>
 <tr>
 <td><img src=images/spacer.gif width="1" height=65></td>
 <td valign="top" style="border:1px solid black">Qualifications 
 (Degrees/Diplomas etc)</td>
 </tr>
 <tr>
 <td><img src=images/spacer.gif width="1" height=65></td>
 <td valign="top" style="border:1px solid black">Field/s 
 of Expertise</td>
 </tr>
 <tr>
 <td><img src=images/spacer.gif width="1" height=45></td>
 <td valign="top" style="border:1px solid black">Active position 
 in firm (partner, office manager, YPF,other) (**See 
 Note Below) </td>
 </tr>
 <tr>
 <td><img src=images/spacer.gif width="1" height=40></td>
 <td valign="top" style="border:1px solid black">E-mail 
 address </td>
 </tr>
 <tr>
 <td><img src=images/spacer.gif width="1" height=24></td>
 <td valign="top" style="border:1px solid black">Principal</td>
 </tr>
 <tr>
 <td><img src=images/spacer.gif width="1" height=24></td>
 <td valign="top" style="border:1px solid black">ID Number</td>
 </tr>
 <tr>
 <td><img src=images/spacer.gif width="1" height=24></td>
 <td valign="top" style="border:1px solid black">Cellphone Number</td>
 </tr>
 </table></td>
		 <?php
		 }
		 ?>
 <td valign="top" width="25%"><table width="100%" border="0" cellspacing="0" cellpadding="0">
 <tr>
 <td><img src=images/spacer.gif width="1" height=24></td>
 <td valign="top" bgcolor="#EEEEEE"><center>
 <?php echo $iRecordNum; ?>
 </center> </td>
 </tr>
 <tr>
 <td><img src=images/spacer.gif width="1" height=24></td>
 <td valign="top" style="border:1px solid black"><?php echo $ps[1]; ?>&nbsp;</td>
 </tr>
 <tr>
 <td><img src=images/spacer.gif width="1" height=24></td>
 <td valign=top style="border:1px solid black"> <?php echo $ps[2]; ?>&nbsp; </td>
 </tr>
 <tr>
 <td><img src=images/spacer.gif width="1" height=40></td>
 <td valign=top style="border:1px solid black"> <?php echo $ps[3]; ?>&nbsp; </td>
 </tr>
 <tr>
 <td><img src=images/spacer.gif width="1" height=80></td>
 <td valign=top style="border:1px solid black"> <?php echo $ps[4]; ?>&nbsp; </td>
 </tr>
 <tr>
 <td><img src=images/spacer.gif width="1" height=65></td>
 <td valign=top style="border:1px solid black"> <?php echo $ps[5]; ?>&nbsp; </td>
 </tr>
 <tr>
 <td><img src=images/spacer.gif width="1" height=65></td>
 <td valign=top style="border:1px solid black"> <?php echo $ps[6]; ?> &nbsp;&nbsp;</td>
 </tr>
 <tr>
 <td><img src=images/spacer.gif width="1" height=45></td>
 <td valign=top style="border:1px solid black"> <?php echo $rs[2]; ?>&nbsp; </td>
 </tr>
 <tr>
 <td><img src=images/spacer.gif width="1" height=40></td>
 <td valign=top style="border:1px solid black"> <?php echo $ps[7]; ?> &nbsp;</td>
 </tr>
 <tr>
 <td><img src=images/spacer.gif width="1" height=24></td>
 <td valign=top style="border:1px solid black"><img src="<?php echo $pictoshow1; ?>" width="22" height="24" ></td>
 </tr>
 <tr>
 <td><img src=images/spacer.gif width="1" height=24></td>
 <td valign=top nowrap style="border:1px solid black"><?php echo $ps[8]; ?>&nbsp;</td>
 </tr>
 <tr>
 <td><img src=images/spacer.gif width="1" height=24></td>
 <td valign=top style="border:1px solid black"><?php echo $ps[9]; ?>&nbsp;</td>
 </tr>
 </table></td>
 <?php
			if ($bEndRow) {
		?>
		</tr>
		<?php
			}
		// here we end the while
		}
		// was the row properly ended?
		if (!$bEndRow) {
			for ($i=$iCellNum+1; $i <= 4; $i++) {
			?>
			<td>&nbsp;</td>
			<?php
			}
			?>
			</tr>
			<?php
		}
		?>
 <tr>
 <td>&nbsp;</td>
 <td bgcolor="#EEEEEE"><center>
 <?php echo $iRecordNum+1; ?>
 
 </center> </td>
 <td bgcolor="#EEEEEE"><center>
 <?php echo $iRecordNum+2; ?>
 
 </center> </td>
 <td bgcolor="#EEEEEE"><center>
 <?php echo $iRecordNum+3; ?>
 
 </center> </td>
 </tr>
 <tr>
 <td style="border:1px solid black">SURNAME</td>
 <td valign=top style="border:1px solid black; background-color:#CCCCCC">&nbsp;</td>
 <td valign=top style="border:1px solid black; background-color:#CCCCCC">&nbsp;</td>
 <td valign=top style="border:1px solid black; background-color:#CCCCCC">&nbsp;</td>
 </tr>
 <tr>
 <td style="border:1px solid black">INITIALS</td>
 <td valign=top style="border:1px solid black; background-color:#CCCCCC">&nbsp;</td>
 <td valign=top style="border:1px solid black; background-color:#CCCCCC">&nbsp;</td>
 <td valign=top style="border:1px solid black; background-color:#CCCCCC">&nbsp;</td>
 </tr>
 <tr>
 <td style="border:1px solid black">KNOWN AS (e.g. &ldquo;Bill&rdquo; for &ldquo;William&rdquo;) </td>
 <td valign=top style="border:1px solid black; background-color:#CCCCCC">&nbsp;</td>
 <td valign=top style="border:1px solid black; background-color:#CCCCCC">&nbsp;</td>
 <td valign=top style="border:1px solid black; background-color:#CCCCCC">&nbsp;</td>
 </tr>
 <tr>
 <td style="border:1px solid black">Professional 
 Registration (if any) number and date (PrEng, PrTechEng,Quantity Surveyor, 
 Architect, CA(SA) , full Membership of Institutions etc)</td>
 <td valign=top style="border:1px solid black; background-color:#CCCCCC">&nbsp;</td>
 <td valign=top style="border:1px solid black; background-color:#CCCCCC">&nbsp;</td>
 <td valign=top style="border:1px solid black; background-color:#CCCCCC">&nbsp;</td>
 </tr>
 <tr>
 <td style="border:1px solid black">Qualifications 
 (Degrees/Diplomas etc)</td>
 <td valign=top style="border:1px solid black; background-color:#CCCCCC">&nbsp;</td>
 <td valign=top style="border:1px solid black; background-color:#CCCCCC">&nbsp;</td>
 <td valign=top style="border:1px solid black; background-color:#CCCCCC">&nbsp;</td>
 </tr>
 <tr>
 <td style="border:1px solid black">Field/s 
 of Expertise</td>
 <td valign=top style="border:1px solid black; background-color:#CCCCCC">&nbsp;</td>
 <td valign=top style="border:1px solid black; background-color:#CCCCCC">&nbsp;</td>
 <td valign=top style="border:1px solid black; background-color:#CCCCCC">&nbsp;</td>
 </tr>
 <tr>
 <td style="border:1px solid black">Active position 
 in firm (partner, office manager, YPF,other) (**See 
 Note Below) </td>
 <td valign=top style="border:1px solid black; background-color:#CCCCCC">&nbsp;</td>
 <td valign=top style="border:1px solid black; background-color:#CCCCCC">&nbsp;</td>
 <td valign=top style="border:1px solid black; background-color:#CCCCCC">&nbsp;</td>
 </tr>
 <tr>
 <td style="border:1px solid black">E-mail 
 address </td>
 <td valign=top style="border:1px solid black; background-color:#CCCCCC">&nbsp;</td>
 <td valign=top style="border:1px solid black; background-color:#CCCCCC">&nbsp;</td>
 <td valign=top style="border:1px solid black; background-color:#CCCCCC">&nbsp;</td>
 </tr>
 <tr>
 <td style="border:1px solid black">Principal</td>
 <td valign=top style="border:1px solid black; background-color:#CCCCCC"><img src="../pics/unselected.jpg" width="22" height="24" ></td>
 <td valign=top style="border:1px solid black; background-color:#CCCCCC"><img src="../pics/unselected.jpg" width="22" height="24" ></td>
 <td valign=top style="border:1px solid black; background-color:#CCCCCC"><img src="../pics/unselected.jpg" width="22" height="24" ></td>
 </tr>
 <tr>
 <td style="border:1px solid black">ID Number</td>
 <td valign=top style="border:1px solid black; background-color:#CCCCCC">&nbsp;</td>
 <td valign=top style="border:1px solid black; background-color:#CCCCCC">&nbsp;</td>
 <td valign=top style="border:1px solid black; background-color:#CCCCCC">&nbsp;</td>
 </tr>
 <tr>
 <td style="border:1px solid black">Cellphone Number</td>
 <td valign=top style="border:1px solid black; background-color:#CCCCCC">&nbsp;</td>
 <td valign=top style="border:1px solid black; background-color:#CCCCCC">&nbsp;</td>
 <td valign=top style="border:1px solid black; background-color:#CCCCCC">&nbsp;</td>
 </tr>
 </table>
		
 (If insufficient space please supply an additional list)
 NOTE:�� A FULL CURRICULUM 
 VITAE IN RESPECT OF EACH PRINCIPAL MUST 
 BE ATTACHED UNLESS ALREADY SUPPLIED TO THE ASSOCIATION
 **&nbsp;&nbsp;At least 50% of the company directors, partners, members of the 
 close corporation for the firm as a whole must be professionally registered 
 in accordance with Clause 2.1.6 
 A Principal of a Firm shall be any of the following who is in active practice in the firm: 
 A sole practitioner, where the firm is a partnership, all the partners; 
 where the Firm is a close corporation, all the members; 
 where the Firm is a company, all the directors appointed in terms of the Companies Act 
 or equivalent in the country of operation
 </td>
 </tr>
</table>