Gecko [ v3.cesa.co.za ]

Name	Size	Permission	Date
docs	[ DIR ]	drwxr-sr-x	2011-01-04 11:30
images	[ DIR ]	drwxr-sr-x	2008-01-09 08:05
CodeOfConduct.php	14 KB	-rw-r--r--	2019-12-19 07:10
CodeOfConduct.php4	14.1 KB	-rw-r--r--	2008-01-09 08:05
ExplanatoryNotes.php	8.6 KB	-rw-r--r--	2019-12-19 07:10
ExplanatoryNotes.php4	8.71 KB	-rw-r--r--	2008-01-09 08:05
adecstyles.css	0 B	-rw-r--r--	2008-01-09 08:05
annualDec2003.php	18.08 KB	-rw-r--r--	2025-02-18 15:01
annualDec2003.php4	18.05 KB	-rw-r--r--	2008-01-09 08:05
annualDecMain.php	14.15 KB	-rw-r--r--	2025-02-18 15:01
annualDecMain.php4	14.13 KB	-rw-r--r--	2008-01-09 08:05
annualDecPrint.php	18.19 KB	-rw-r--r--	2025-02-18 15:01
annualDecPrint.php4	18.17 KB	-rw-r--r--	2008-01-09 08:05
annualGENERIC.php	13.72 KB	-rw-r--r--	2025-02-18 15:01
annualGENERIC.php4	13.69 KB	-rw-r--r--	2008-01-09 08:05
annualGENERIC2.php	15.61 KB	-rw-r--r--	2025-02-18 15:01
annualGENERIC2.php4	15.59 KB	-rw-r--r--	2008-01-09 08:05
annualGENERIC3.php	15.92 KB	-rw-r--r--	2025-02-18 15:01
annualGENERIC3.php4	15.89 KB	-rw-r--r--	2008-01-09 08:05
annualGENERIC4.php	35.31 KB	-rw-r--r--	2025-02-18 15:01
annualGENERIC4.php4	22.9 KB	-rw-r--r--	2008-02-18 11:04
annualGENERIC_A.php	21.19 KB	-rw-r--r--	2019-12-19 07:10
annualGENERIC_A.php4	21.61 KB	-rw-r--r--	2008-01-09 08:05
declcomplete.php	2.65 KB	-rw-r--r--	2024-01-09 07:58
declcomplete.php4	2.25 KB	-rw-r--r--	2008-01-16 12:11
navigation.html	3.22 KB	-rw-r--r--	2019-12-19 07:10
primedb.php	544 B	-rw-r--r--	2019-12-19 07:10
primedb.php4	559 B	-rw-r--r--	2008-01-16 12:11
printschedules.php	20.29 KB	-rw-r--r--	2024-01-09 07:58
printschedules.php4	12.68 KB	-rw-r--r--	2008-01-16 08:00
schedule1.php	33.16 KB	-rw-r--r--	2019-12-19 07:10
schedule1.php4	33.95 KB	-rw-r--r--	2008-02-22 07:07
schedule1_page1.php	19.11 KB	-rw-r--r--	2019-12-19 07:10
schedule1_page1.php4	19.56 KB	-rw-r--r--	2008-02-22 07:07
schedule1_page1BLANK.php	22.82 KB	-rw-r--r--	2019-12-19 07:10
schedule1_page1BLANK.php4	23.27 KB	-rw-r--r--	2008-02-22 07:07
schedule1_page1GENERIC.php	24.9 KB	-rw-r--r--	2019-12-19 07:10
schedule1_page1GENERIC.php4	25.38 KB	-rw-r--r--	2008-02-22 07:07
schedule1_page1GENERIC_A.php	21.57 KB	-rw-r--r--	2019-12-19 07:10
schedule1_page1GENERIC_A.php4	21.97 KB	-rw-r--r--	2008-01-09 08:05
schedule1_page2.php	14.09 KB	-rw-r--r--	2019-12-19 07:10
schedule1_page2.php4	14.33 KB	-rw-r--r--	2008-02-01 06:32
schedule1_page2GENERIC.php	87.78 KB	-rw-r--r--	2025-08-19 08:12
schedule1_page2GENERIC.php4	45.36 KB	-rw-r--r--	2011-01-20 08:16
schedule1_page2GENERIC_A.php	42.61 KB	-rw-r--r--	2025-08-19 08:12
schedule1_page2GENERIC_A.php4	26.36 KB	-rw-r--r--	2008-01-09 08:07
schedule1a.php	3.11 KB	-rw-r--r--	2019-12-19 07:10
schedule1a.php4	3.19 KB	-rw-r--r--	2008-01-09 08:05
schedule1aGENERIC.php	20.19 KB	-rw-r--r--	2024-01-09 07:58
schedule1aGENERIC.php4	15.47 KB	-rw-r--r--	2008-01-16 08:00
schedule1aGENERIC_A.php	15.22 KB	-rw-r--r--	2024-01-09 07:58
schedule1aGENERIC_A.php4	10.22 KB	-rw-r--r--	2008-01-09 08:07
schedule1b.php	32.47 KB	-rw-r--r--	2019-12-19 07:10
schedule1b.php4	33.31 KB	-rw-r--r--	2008-02-01 06:32
schedule1b_page1.php	25.85 KB	-rw-r--r--	2019-12-19 07:10
schedule1b_page1.php4	26.41 KB	-rw-r--r--	2008-02-01 06:32
schedule1b_page1BLANK.php	21.93 KB	-rw-r--r--	2019-12-19 07:10
schedule1b_page1BLANK.php4	22.35 KB	-rw-r--r--	2008-01-09 08:05
schedule1b_page1GENERIC.php	23.04 KB	-rw-r--r--	2019-12-19 07:10
schedule1b_page1GENERIC.php4	23.46 KB	-rw-r--r--	2008-01-09 08:05
schedule1b_page1GENERIC_A.php	18.75 KB	-rw-r--r--	2019-12-19 07:10
schedule1b_page1GENERIC_A.php4	19.09 KB	-rw-r--r--	2008-01-09 08:05
schedule1b_page2.php	13.29 KB	-rw-r--r--	2019-12-19 07:10
schedule1b_page2.php4	13.56 KB	-rw-r--r--	2008-02-01 06:32
schedule1b_page2GENERIC.php	61.67 KB	-rw-r--r--	2025-07-18 08:30
schedule1b_page2GENERIC.php4	36.81 KB	-rw-r--r--	2011-01-20 08:16
schedule1b_page2GENERIC_A.php	43.97 KB	-rw-r--r--	2025-07-18 08:30
schedule1b_page2GENERIC_A.php4	26.08 KB	-rw-r--r--	2008-01-09 08:07
schedule2.php	20.91 KB	-rw-r--r--	2019-12-19 07:10
schedule2.php4	21.44 KB	-rw-r--r--	2008-02-01 06:32
schedule2GENERIC.php	59.42 KB	-rw-r--r--	2024-01-09 07:58
schedule2GENERIC.php4	36.98 KB	-rw-r--r--	2008-01-16 08:00
schedule2GENERIC_A.php	48.71 KB	-rw-r--r--	2024-01-09 07:58
schedule2GENERIC_A.php4	28.93 KB	-rw-r--r--	2008-01-09 08:07
schedule3.php	5.53 KB	-rw-r--r--	2019-12-19 07:10
schedule3.php4	5.55 KB	-rw-r--r--	2008-01-09 08:05
schedule4GENERIC.php	3.63 KB	-rw-r--r--	2019-12-19 07:10
schedule4GENERIC.php4	3.73 KB	-rw-r--r--	2008-01-09 08:05
schedule4GENERIC_A.php	3.63 KB	-rw-r--r--	2019-12-19 07:10
schedule4GENERIC_A.php4	3.73 KB	-rw-r--r--	2008-01-09 08:05
spacer.gif	43 B	-rw-r--r--	2019-12-19 07:10
subscriptione.php	12.31 KB	-rw-r--r--	2019-12-19 07:10
subscriptione.php4	12.59 KB	-rw-r--r--	2008-01-09 08:05

Rename

<?php 
// Configuration and Autentication
include( '../inc/auth.inc' );
include( '../inc/func.inc' );
switch ($auth) {
    case valid:
	// System Includes
	//include( '../inc/pref.inc' );
	// Variables Unique to page
	$title = "members.saace.co.za - Annual Declaration " & $DeclarationYear;
	$description = "South African Association of Consulting Engineers. Annual Declaration " & $DeclarationYear & ".";
	$keywords = "online, services, members, consulting, engineers";
	
	// Start Page Includes
	include( '../inc/conf.inc' );
	// include( '../inc/header.inc' );
	
	include( '../inc/db.inc' );
	?>
	
<script language="JavaScript">

</script>
<title>Annual Declaration <?php echo $DeclarationYear; ?></title><body bgcolor="#FFFFFF">
<?php
	include( '../inc/declaration.inc' );
?>
<table width="100%" cellpadding="0" cellspacing="0" height="390">
  <tr> 
    <td align="center" valign="top" height="417"> 
      <table border=0 cellspacing=0 cellpadding=0 width="100%" height="89">
        <tr> 
          <td width=288 valign=top class="Normal" height="89"> 
            <h2>&nbsp; </h2>
          </td>
          <td width=69 valign=top class="Normal" height="89"> 
            <h2> <font size="1" face="Times New Roman, Times, serif"><img width=66 height=84
  src="images/image003.gif" v:shapes="_x0000_i1026"></font></h2>
          </td>
          <td width=120 valign=top class="Normal" height="89"> </td>
          <td width=194 valign=top class="Normal" height="89"> 
            <div align="right"><font size="1" face="Times New Roman, Times, serif"> 
              <b>SCHEDULE 1 B <br>
              <?php echo $DeclarationYear; ?><br>
              (CONTINUED) </b></font></div>
          </td>
        </tr>
      </table>
      <font size="1" face="Times New Roman, Times, serif"><b>A.������� DETAILS 
      OF ALL PRINCIPALS AND PROFESSIONAL STAFF <i><u>AT THIS BRANCH ONLY</u></i></b> 
      </font> 
      <table border=1 cellspacing=0 cellpadding=0 width=100%>
        <tr bgcolor="#999999"> 
          <td width=81 valign=top class="Normal" height="89"> <font size="1" face="Times New Roman, Times, serif"><b>SURNAME 
            </b></font></td>
          <td width=69 valign=top class="Normal" height="89"> <font size="1" face="Times New Roman, Times, serif"><b>INITIALS 
            </b></font></td>
          <td width=95 valign=top class="Normal" height="89"> <font size="1" face="Times New Roman, Times, serif"><b>ALSO 
            KNOWN AS(e.g. �Bill� for �William�) </b></font></td>
          <td width=120 valign=top class="Normal" height="89"> <font size="1" face="Times New Roman, Times, serif"><b>Professional 
            Registration (if any) number and date (PrEng, PrTechEng,Quantity Surveyor, 
            Architect, CA(SA) etc </b></font></td>
          <td width=120 valign=top class="Normal" height="89"> <font size="1" face="Times New Roman, Times, serif"><b>Qualifications 
            (Degrees/Diplomas, fullMembership of Institutions etc) </b></font></td>
          <td width=95 valign=top class="Normal" height="89"> <font size="1" face="Times New Roman, Times, serif"><b>Field/s 
            of Expertise </b></font></td>
          <td width=106 valign=top class="Normal" height="89"> <font size="1" face="Times New Roman, Times, serif"><b>Position 
            in firm(e.g. company director, partner, office manager, other)(**See 
            Note Below) </b></font></td>
          <td valign=top class="Normal" height="89"> <font size="1" face="Times New Roman, Times, serif"><b>E-mail 
            address </b></font></td>
          <td width=8 valign=top class="Normal" height="89"> <font size="1" face="Times New Roman, Times, serif"><b>Principal 
            </b></font></td>
          <td width=8 valign=top class="Normal" height="89"> <font size="1" face="Times New Roman, Times, serif"><b>YPF 
            </b></font></td>
        </tr>
        <?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 * FROM ADec_OfficeContacts WHERE OfficeID = '$SelectOfficeID'";
	      $result = mysql_query($query) or die("Select of id Failed");
          while (($rs = mysql_fetch_array($result)))
		{
		$therightid = $rs[0];
		// 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  * FROM ADec_Contacts WHERE ContactsID = '$therightid'";
	      $result2 = mysql_query($query2) or die("Select of id Failed");
		  $ps = mysql_fetch_array($result2);		
		
		?>
        <tr> 
          <td width=81 valign=top class="Normal"> <font size="1" face="Times New Roman, Times, serif"> 
            <?php echo $ps[1]; ?>
            </font></td>
          <td width=69 valign=top class="Normal"> <font size="1" face="Times New Roman, Times, serif"> 
            <?php echo $ps[2]; ?>
            </font></td>
          <td width=95 valign=top class="Normal"> <font size="1" face="Times New Roman, Times, serif"> 
            <?php echo $ps[3]; ?>
            </font></td>
          <td width=120 valign=top class="Normal"> <font size="1" face="Times New Roman, Times, serif"> 
            <?php echo $ps[13]; ?>
            </font></td>
          <td width=120 valign=top class="Normal"> <font size="1" face="Times New Roman, Times, serif"> 
            <?php echo $ps[14]; ?>
            </font></td>
          <td width=95 valign=top class="Normal"> <font size="1" face="Times New Roman, Times, serif"> 
            <?php echo $ps[12]; ?>
            </font></td>
          <td width=106 valign=top class="Normal"> <font size="1" face="Times New Roman, Times, serif"> 
            <?php echo $rs[1]; ?>
            </font></td>
          <td  valign=top class="Normal"> <font size="1" face="Times New Roman, Times, serif"> 
            <?php echo $ps[16]; ?>
            </font></td>
          <?php
	  	 $pictoshow1 = "../pics/unselected.jpg";
		  if ($rs[5] == 1)
		     {
			 $pictoshow1 = "../pics/selected.gif";
			 }
		  ?>
          <td width=8 valign=top class="Normal"><font size="1" face="Times New Roman, Times, serif"><img src="<?php echo $pictoshow1; ?>" ></font></td>
          <?php
	  	 $pictoshow1 = "../pics/unselected.jpg";
		  if ($rs[11] == 'y')
		     {
			 $pictoshow1 = "../pics/selected.gif";
			 }
		  ?>
          <td width=8 valign=top class="Normal"><font size="1" face="Times New Roman, Times, serif"><img src="<?php echo $pictoshow1; ?>" ></font></td>
        </tr>
        <tr> 
          <td width=81 valign=top class="Normal"> 
            <table width="100%" border="1" cellspacing="0" cellpadding="0" height="100%" bordercolor="#000000" bgcolor="#CCCCCC">
              <tr> 
                <td></td>
              </tr>
            </table>
          </td>
          <td width=69 valign=top class="Normal"> 
            <table width="100%" border="1" cellspacing="0" cellpadding="0" height="100%" bordercolor="#000000" bgcolor="#CCCCCC">
              <tr> 
                <td></td>
              </tr>
            </table>
          </td>
          <td width=95 valign=top class="Normal"> 
            <table width="100%" border="1" cellspacing="0" cellpadding="0" height="100%" bordercolor="#000000" bgcolor="#CCCCCC">
              <tr> 
                <td></td>
              </tr>
            </table>
          </td>
          <td width=120 valign=top class="Normal"> 
            <table width="100%" border="1" cellspacing="0" cellpadding="0" height="100%" bordercolor="#000000" bgcolor="#CCCCCC">
              <tr> 
                <td></td>
              </tr>
            </table>
          </td>
          <td width=120 valign=top class="Normal"> 
            <table width="100%" border="1" cellspacing="0" cellpadding="0" height="100%" bordercolor="#000000" bgcolor="#CCCCCC">
              <tr> 
                <td></td>
              </tr>
            </table>
          </td>
          <td width=95 valign=top class="Normal"> 
            <table width="100%" border="1" cellspacing="0" cellpadding="0" height="100%" bordercolor="#000000" bgcolor="#CCCCCC">
              <tr> 
                <td></td>
              </tr>
            </table>
          </td>
          <td width=106 valign=top class="Normal"> 
            <table width="100%" border="1" cellspacing="0" cellpadding="0" height="100%" bordercolor="#000000" bgcolor="#CCCCCC">
              <tr> 
                <td></td>
              </tr>
            </table>
          </td>
          <td valign=top class="Normal"> 
            <table width="100%" border="1" cellspacing="0" cellpadding="0" height="100%" bordercolor="#000000" bgcolor="#CCCCCC">
              <tr> 
                <td></td>
              </tr>
            </table>
          </td>
          <td width=8 valign=top class="Normal"> 
            <table width="100%" border="1" cellspacing="0" cellpadding="0" height="100%" bordercolor="#000000" bgcolor="#CCCCCC">
              <tr> 
                <td><font size="1" face="Times New Roman, Times, serif"><img src="../pics/unselected.jpg" ></font></td>
              </tr>
            </table>
          </td>
          <td width=8 valign=top class="Normal"> 
            <table width="100%" border="1" cellspacing="0" cellpadding="0" height="100%" bordercolor="#000000" bgcolor="#CCCCCC">
              <tr> 
                <td><font size="1" face="Times New Roman, Times, serif"><img src="../pics/unselected.jpg" ></font></td>
              </tr>
            </table>
          </td>
        </tr>
        <?php
		// here we end the while
		}
		?>
      </table>
      <font size="1" face="Times New Roman, Times, serif"><b><i>(Please us a BLANK 
      form if you would like to add staff)</i></b> </font> 
      <table width="100%" border="1" cellspacing="0" cellpadding="0">
        <tr> 
          <td width="73%"><font size="1" face="Times New Roman, Times, serif"><span
  style='font-size:10.0pt;font-family:"Times New Roman"'>TOTAL OF ALL PRINCIPALS, 
            PROFESSIONAL AND CONTRACT STAFF LISTED IN A ABOVE</span></font></td>
          <td width="6%"> <font size="1" face="Times New Roman, Times, serif"> 
            <?php echo $MemberProffStaff; ?>
            </font></td>
          <td width="21%"> 
            <table width="100%" border="1" cellspacing="0" cellpadding="0" bordercolor="#000000" height="100%" bgcolor="#999999">
              <tr> 
                <td>&nbsp;</td>
              </tr>
            </table>
          </td>
        </tr>
        <tr> 
          <td width="73%"><font size="1" face="Times New Roman, Times, serif"><span
  style='font-size:10.0pt;font-family:"Times New Roman"'>TOTAL OF NON-PROFESSIONAL 
            TECHNICAL AND CONTRACT STAFF (e.g. graduates, draughtsperson, laboratory 
            assistants, etc)</span></font></td>
          <td width="6%"> <font size="1" face="Times New Roman, Times, serif"> 
            <?php echo $MemberNonProff; ?>
            </font></td>
          <td width="21%"> 
            <table width="100%" border="1" cellspacing="0" cellpadding="0" bordercolor="#000000" height="100%" bgcolor="#999999">
              <tr> 
                <td>&nbsp;</td>
              </tr>
            </table>
          </td>
        </tr>
        <tr> 
          <td width="73%"><font size="1" face="Times New Roman, Times, serif"><span
  style='font-size:10.0pt;font-family:"Times New Roman"'>TOTAL OF OTHER STAFF 
            AND CONTRACT STAFF (e.g. secretaries, bookkeepers etc)</span></font></td>
          <td width="6%"> <font size="1" face="Times New Roman, Times, serif"> 
            <?php echo $MemberOtherStaff; ?>
            </font></td>
          <td width="21%"> 
            <table width="100%" border="1" cellspacing="0" cellpadding="0" bordercolor="#000000" height="100%" bgcolor="#999999">
              <tr> 
                <td>&nbsp;</td>
              </tr>
            </table>
          </td>
        </tr>
        <tr> 
          <td width="73%"><font size="1" face="Times New Roman, Times, serif"><span style='font-size:12.0pt;'><b>TOTAL 
            OF ALL STAFF</b></span></font></td>
          <td width="6%"> <font size="1" face="Times New Roman, Times, serif"> 
            <?php $Total = $MemberOtherStaff + $MemberNonProff + $MemberProffStaff; echo $Total; ?>
            </font></td>
          <td width="21%"> 
            <table width="100%" border="1" cellspacing="0" cellpadding="0" bordercolor="#000000" height="100%" bgcolor="#999999">
              <tr> 
                <td>&nbsp;</td>
              </tr>
            </table>
          </td>
        </tr>
      </table>
    </td>
  </tr>
</table>

<?php
	// End page Includes
	include( '../inc/footer2.inc' );
        break;
    case invalid:
        header("Location: http://www.saace.co.za/login.php?pageurl=".$_SERVER['REQUEST_URI']);
        //systemerror("Login Error","Initial Login Failure",getenv ("PATH_INFO"), $authorized);
        break;
    default:
        systemerror("System Error","System Failure on Authentication",getenv ("PATH_INFO"), "There is a problem logging into our system. Try again later or if the problem persists, please contact SAACE to report the problem.");
        break;
}
?>