Gecko [ v3.cesa.co.za ]

Name	Size	Permission	Date
inc	[ DIR ]	drwxr-sr-x	2020-06-06 16:09
pics	[ DIR ]	drwxr-sr-x	2010-05-27 06:26
print	[ DIR ]	drwxr-sr-x	2020-06-06 16:09
ADMarkComplete.php	619 B	-rw-r--r--	2020-01-08 10:39
ADMarkComplete.php4	636 B	-rw-r--r--	2010-05-28 10:40
ADaddDone.php	3.82 KB	-rw-r--r--	2020-01-08 10:39
ADaddDone.php4	3.92 KB	-rw-r--r--	2010-05-28 10:40
ADdeleteDone.php	3.56 KB	-rw-r--r--	2020-01-08 10:39
ADdeleteDone.php4	3.66 KB	-rw-r--r--	2010-05-28 10:40
ADdisplayContacts.php	44.02 KB	-rw-r--r--	2025-08-19 08:12
ADdisplayContacts.php4	27.08 KB	-rw-r--r--	2015-09-16 09:06
ADdisplayContactsTable.php	2.7 KB	-rw-r--r--	2020-01-08 10:39
ADdisplayContactsTable.php4	2.7 KB	-rw-r--r--	2015-04-08 08:21
ADdisplayDone.php	2.24 KB	-rw-r--r--	2020-01-08 10:39
ADdisplayDone.php4	2.29 KB	-rw-r--r--	2010-05-28 10:40
ADdisplayHelp.php	1.26 KB	-rw-r--r--	2020-01-08 10:39
ADdisplayHelp.php4	1.31 KB	-rw-r--r--	2010-05-28 10:31
ADdisplayMemberFirm.php	50.47 KB	-rw-r--r--	2025-12-29 10:37
ADdisplayMemberFirm.php4	59.25 KB	-rw-r--r--	2019-02-25 07:51
ADdisplayOfficeContactsTable.php	3.41 KB	-rw-r--r--	2020-01-08 10:39
ADdisplayOfficeContactsTable.php4	3.41 KB	-rw-r--r--	2015-04-08 08:22
ADdisplayOffices.php	43.24 KB	-rw-r--r--	2025-03-05 14:36
ADdisplayOffices.php4	26.64 KB	-rw-r--r--	2015-04-08 08:23
ADdisplayTest.php	1.17 KB	-rw-r--r--	2020-01-08 10:39
ADdisplayTest.php4	1.21 KB	-rw-r--r--	2010-05-28 10:40
ADdisplayrecords.php	10.24 KB	-rw-r--r--	2025-04-24 11:04
ADdisplayrecords.php4	3.94 KB	-rw-r--r--	2013-04-16 08:09
ADdisplaytblMemberFirmOffices.php	3.63 KB	-rw-r--r--	2025-03-14 16:58
ADdisplaytblMemberFirmOffices.php4	3.56 KB	-rw-r--r--	2015-04-08 08:23
ADdisplaytblMemberFirms.php	3.73 KB	-rw-r--r--	2020-01-08 10:39
ADdisplaytblMemberFirms.php4	3.73 KB	-rw-r--r--	2015-04-08 08:23
ADeditDone.php	3.71 KB	-rw-r--r--	2020-01-08 10:39
ADeditDone.php4	3.81 KB	-rw-r--r--	2010-05-28 10:40
ADfixDisplayTable.php	14.88 KB	-rw-r--r--	2020-01-08 10:39
ADfixDisplayTable.php4	15.27 KB	-rw-r--r--	2010-05-28 10:40
ShadeTable.js	535 B	-rw-r--r--	2010-05-28 10:31
accept.jpg	638 B	-rw-r--r--	2010-05-28 10:31
annualdec.php	935 B	-rw-r--r--	2020-01-08 10:39
annualdec.php4	966 B	-rw-r--r--	2010-05-28 10:31
decline.jpg	723 B	-rw-r--r--	2010-05-28 10:31
next.jpg	491 B	-rw-r--r--	2010-05-28 10:31
previous.jpg	562 B	-rw-r--r--	2010-05-28 10:31

Rename

<html>
<head>
<title>Annual Declaration Admin page</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>

<body bgcolor="#FFFFFF" text="#000000">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
  <tr> 
    <td bgcolor="#CCCCCC"> 
      <?php include( 'inc/menu.inc' ); ?>
    </td>
  </tr>
  <tr> 
    <td>
      <h3><font face="sans-serif" color="#666666">Display Records:</font><font face="sans-serif"> 
        </font></h3>
		<p>
		<?php
include( 'inc/database.inc' );
        mysql_connect("$host","$user","$password") or die("Unable to connect to SQL server".print_r(sqlsrv_errors()));
        mysql_select_db("$db") or die("Unable to select database");
		
		// ** ADEC_TBLMEMBERFIRMS
		// **********************
		
		  $query = "SELECT ADecStatus, FirmName, FirmID, Prev_FirmID FROM ADec_tblMemberFirms WHERE ADecStatus IN ('U','D') ORDER BY ADecStatus ASC, FirmName ASC";

$result = mysql_query($query) or die("Select of id Failed");
		  echo "<table width=\"100%\" border=\"1\" cellpadding=\"2\" cellspacing=\"0\">";
		  echo "<tr bgcolor=\"#336699\">
		  <th valign=\"top\"><font color=\"#CCCCCC\" size=\"2\">Member Status</font></th>
		  <th valign=\"top\"><font color=\"#CCCCCC\" size=\"2\">Part 2 Status</font></th>
		  <th valign=\"top\"><font color=\"#CCCCCC\" size=\"2\">Firm Name</font></th>
		  <th valign=\"top\"><font color=\"#CCCCCC\" size=\"2\">Admin Status</font></th>
		  <th valign=\"top\"><font color=\"#CCCCCC\" size=\"2\">Actions</font></th>
		  </tr>";
		  while ($rs = mysql_fetch_array($result))
          {
			if ($rs['ADecStatus'] == 'U') {
				$isdone = 'In progress';
			}
			if ($rs['ADecStatus'] == 'D') {
				$isdone = 'Completed';
			}
			if ($rs['ADecStatus'] == 'H') {
				$isdone = 'Completed (hard copy received)';
			}
$query2 = "SELECT MAX(ADecDate) AS MaxADecDate FROM ADec_Done WHERE RefID = ".$rs['FirmID'];
$result2 = mysql_query($query2) or die("Select of id Failed");

if ($rs2 = mysql_fetch_array($result2)) {
	if (!empty($rs2['MaxADecDate'])) $isdone = $isdone . '<br>' . date_formatted($rs2['MaxADecDate'],"Y-m-d");
}

$UpdateStatus = "&nbsp;";
			$query2 = "SELECT RefDoc, ADecDate FROM ADec_Done_Local WHERE RefID = ".$rs['FirmID']." AND RefType = 'FirmID' AND RefDoc IN ('UPDATED', 'DECLINED', 'DECLINE') ORDER BY ADecDate DESC";
			$result2 = mysql_query($query2) or die("Select of id Failed");
			if ($rs2 = mysql_fetch_array($result2)) {
				$UpdateStatus = $rs2['RefDoc'] . " on " . date_formatted($rs2['ADecDate'],"Y-m-d");
			}
		  
		  echo "<tr>
		  <td valign=\"top\"><font size=\"2\">".$isdone."</font>";
		  if (substr($isdone,0,11)=="In progress") {
		  	echo"<br><a href=\"ADMarkComplete.php4?FirmID=".$rs['FirmID']."\">Click here to mark as Completed (hard copy received)</a>";
		  }
		  echo "</td><td valign=\"top\"><font size=\"2\">";
		  
		  $query2 = "SELECT MAX(ADecDate) AS ADecDate FROM ADec_Done WHERE RefID IN (SELECT OfficeID FROM ADec_tblMemberFirmOffices WHERE FirmID=".$rs['FirmID'].") AND RefDoc = 'Schedule1P2'";
			$result2 = mysql_query($query2);
			if ($rs2 = mysql_fetch_array($result2)) {
				if (!empty($rs2['ADecDate'])) echo "Part 2 updated on ".date_formatted($rs2['ADecDate'],"Y-m-d");
			}
		  
		  echo "</font></td><td valign=\"top\"><font size=\"2\">".$rs['FirmName']."</font></td>
		  <td valign=\"top\"><font size=\"2\">".$UpdateStatus."</font></td>
		  <td valign=\"top\"><font size=\"2\">"  ?>
            <?php $FirmID = $rs['FirmID']; $NewFile = "ADdisplayMemberFirm.php4"; printf ("<a href=\"%s?FirmID=%s\")'>FIRM</a>\n", $NewFile, $FirmID); ?>
            | <?php $NewFile = "ADdisplayOffices.php4"; printf ("<a href=\"%s?FirmID=%s\")'>OFFICES</a>\n", $NewFile, $FirmID); ?> 
			 <?php "</td>
		  </tr>";
          } 
			echo "</table>";
		?>
    </td>
  </tr>
  <tr>
    <td bgcolor="#CCCCCC"><?php include( 'inc/footer.inc' ); ?></td>
  </tr>
</table>
</body>
</html>