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">
 <META HTTP-EQUIV="CACHE-CONTROL" CONTENT="NO-CACHE">
 <META HTTP-EQUIV="PRAGMA" CONTENT="NO-CACHE">
 <META HTTP-EQUIV="EXPIRES" CONTENT="0">
 <style>
 .DarkShading {
 BACKGROUND-COLOR: #dceddc
 }
 </style>
</head>

<body bgcolor="#FFFFFF" text="#000000">
 <?php
 include_once("inc/log_query.php");

include_once('inc/database.inc');
    include_once($_SERVER['DOCUMENT_ROOT'] . '/cesanet/inc_shared.php');

$currentYear = $_REQUEST['selectYear'];
    $link_contact_id = $_REQUEST['link_contact_id'];
    $adec_contact_id = $_REQUEST['adec_contact_id'];

// echo "$link_contact_id > 0 && $adec_contact_id > 0 ";
 if ($link_contact_id > 0 && $adec_contact_id > 0) {
 $sql = "UPDATE ADec_Contacts SET Prev_ContactsID = '$link_contact_id' WHERE ContactsID = '$adec_contact_id'";

$aDecOfficeContactsObj = new ADec_OfficeContacts($sqlf);
 $aDecOfficeContactsObj->getOrCreateOne($adec_contact_id, $link_contact_id, $currentYear);
 // echo $sql;
 // exit;
 $result = mysql_query($sql) or die("Update of id Failed");
 echo 'Contact linked successfully.';
 // exit;
 }

// mysql_connect("$host", "$user", "$password") or die("Unable to connect to SQL server");
    // mysql_select_db("$db") or die("Unable to select database");

$Mn1 = date("M d Y g:iA");

if ($currentYear <= 0) {
 $currentYear = date('Y');
 }

$tableName = 'ADec_tblMemberFirmOffices';
    $tableNameMembers = 'Adec_tblMemberFirms';
    $tableNameContacts = 'ADec_OfficeContacts';
    $tableNameDone = 'ADec_Done';
    $tableNameDoneLocal = 'ADec_Done_Local';
    $tableWhere = '';

if ($currentYear <= 2023) {
 $tableName = 'ADec_tblMemberFirmOffices_' . $currentYear;
 $tableNameMembers = 'Adec_tblMemberFirms_' . $currentYear;
 $tableNameContacts = 'ADec_OfficeContacts_' . $currentYear;
 $tableNameDone = 'ADec_Done' . $currentYear;
 $tableNameDoneLocal = 'ADec_Done_Local' . $currentYear;
 } else {
 $tableWhere = ' AND DeclarationYear = ' . $currentYear;
 }

// Get original office ID from annual declaration
    $sql = "SELECT * FROM $tableName 
        WHERE OfficeID = '$OfficeID'";

// echo 'Please ignore debug info: ' . $sql . ' ';

$recOffice = mysql_query($sql);
    $OriginalOfficeID = 0;
    if ($rowOffice = mysql_fetch_array($recOffice)) {
        $OriginalOfficeID = $rowOffice['Prev_OfficeID'];
    }

if (($action == "next") || ($action == "prev") || ($action == "return")) {
        // ** ADEC_TBLMEMBERFIRMS
        // **********************
        // Number of new contacts
        $numnewquery = "SELECT * FROM $tableNameContacts WHERE OfficeID = '$OfficeID' ";
        $numnewresult = mysql_query($numnewquery) or die("Select of id Failed");
        $numnewcnt = mysql_num_rows($numnewresult);

//		  $rowcountquery = "SELECT * FROM $tableNameContacts WHERE OfficeID = '$OfficeID'  AND ContactsID > '$ContactID' ORDER BY ContactsID ASC";
        //	      $rowcountresult = mysql_query($rowcountquery) or die("Select of id Failed");
        //		  $rowcounter = $numnewcnt - mysql_num_rows($rowcountresult)+1;

if ($action == "prev") {
 $Cquery = "SELECT * 
 FROM $tableNameContacts 
 WHERE OfficeID = '$OfficeID' 
 AND ContactsID < '$ContactID' ORDER BY ContactsID DESC";
 $Cresult = mysql_query($Cquery) or die("Select of id Failed");
 $ds = mysql_fetch_array($Cresult);
 $ContactsID = $ds['ContactsID'];
 $Prev_ContactsID = $ds['Prev_ContactsID'];
 $Prev_OfficeID = $ds['Prev_OfficeID'];
 } elseif ($action == "next") {
 $Cquery = "SELECT * 
 FROM $tableNameContacts 
 WHERE OfficeID = '$OfficeID' 
 AND ContactsID > '$ContactID' ORDER BY ContactsID ASC";
 $Cresult = mysql_query($Cquery) or die("Select of id Failed");
 $ds = mysql_fetch_array($Cresult);
 $ContactsID = $ds['ContactsID'];
 $Prev_ContactsID = $ds['Prev_ContactsID'];
 $Prev_OfficeID = $ds['Prev_OfficeID'];
 } elseif ($action == "return") {
 $Cquery = "SELECT * 
 FROM $tableNameContacts 
 WHERE OfficeID = '$OfficeID' 
 AND ContactsID >= '$ContactID' 
 $tableWhere 
 ORDER BY ContactsID ASC";
 $Cresult = mysql_query($Cquery) or die("Select of id Failed");
 $ds = mysql_fetch_array($Cresult);
 $ContactsID = $ds['ContactsID'];
 $Prev_ContactsID = $ds['Prev_ContactsID'];
 $Prev_OfficeID = $ds['Prev_OfficeID'];
 }

if ($OriginalOfficeID <= 0 && $Prev_OfficeID > 0) {
 $OriginalOfficeID = $Prev_OfficeID;
 }

$Dquery = "SELECT ContactsID, Prev_ContactsID, ContactID, ContactSurname, ContactInitials, 
                            ContactFirstName, ContactDesignation, Comments, ProfessionalRegistrations, 
                            Qualifications, PreferredEmail, IDNumber, CellPhone 
                        FROM ADec_Contacts 
                        WHERE ContactsID = '$ContactsID'";
        $Dresult = mysql_query($Dquery) or die("Select of id Failed");
        $es = mysql_fetch_array($Dresult);

// ** TBLMEMBERFIRMS
 // **********************
 if ($OriginalOfficeID <= 0) {
 $Wquery = "SELECT OfficeID, Prev_OfficeID FROM $tableName WHERE OfficeID = '$OfficeID'";
 $Wresult = mysql_query($Wquery) or die("Select of id Failed");
 $ws = mysql_num_rows($Wresult);
 if ($ws['Prev_OfficeID'] > 0) {
 $OriginalOfficeID = $ws['Prev_OfficeID'];
 }
 }
 } else {
 $rowcounter = 1;

// ** ADEC_TBLMEMBERFIRMS
        // **********************
        // Number of new contacts
        $numnewquery = "SELECT * 
                FROM $tableNameContacts 
                WHERE OfficeID = '$OfficeID' $tableWhere";
        $numnewresult = mysql_query($numnewquery) or die("Select of id Failed");
        $numnewcnt = mysql_num_rows($numnewresult);

if ($numnewcnt <= 0) {
 // Select office contacts from the main database for accpetance
 }

// echo 'Please ignore debug info on new contacts select: ' . $numnewquery . ' ';

$Cquery = "SELECT * 
                FROM $tableNameContacts 
                WHERE OfficeID = '$OfficeID' 
                ORDER BY ContactsID ASC";

// echo 'Please ignore debug info on new contacts select: ' . $Cquery . ' ';

$Cresult = mysql_query($Cquery) or die("Select of id Failed");
        $ds = mysql_fetch_array($Cresult);
        $ContactsID = $ds['ContactsID'];
        $Prev_ContactsID = $ds['Prev_ContactsID'];

if ($OriginalOfficeID <= 0 && $ds['Prev_OfficeID'] > 0) {
 $OriginalOfficeID = $ds['Prev_OfficeID'];
 }

if ($Prev_ContactsID <= 0) {
 // Attempt to find the contact, because it was not linked properly
 $lookForContactSQL = "SELECT * 
 FROM Contacts 
 WHERE OfficeID = '$OfficeID' 
 AND ContactSurname = '" . addslashes($name3) . "' 
 AND ContactInitials = '" . addslashes($name4) . "' 
 AND ContactFirstName = '" . addslashes($name5) . "' 
 AND PreferredEmail = '" . addslashes($name10) . "' ";
 if ($lookForContactResult = mysql_query($lookForContactSQL)) {
 $lookForContactRow = mysql_fetch_array($lookForContactResult);
 if ($lookForContactRow) {
 $Prev_ContactsID = $lookForContactRow['ContactsID'];
 }
 }

if ($Prev_ContactsID <= 0) {
 echo 'Unable to match the AD contact to an existing contact. Accepting will create a new contact.';
 // exit;
 // Display a drop down of office contacts to choose from
 $contactsObj = new MemberContact($sqlf);
 $contacts = $contactsObj->findSelectArrayByOfficeId($OriginalOfficeID);
 echo 'Please select the contact to use for the annual declaration.';
 echo '' . HTMLHelper::drawSelect(
 [
 'choices' => $contacts,
 'name' => 'link_contact_id',
 'attr' => [
 'onchange' => 'window.location.href=\'/echasl23/annualdec/ADdisplayContacts.php?OfficeID=' . $OfficeID . '&selectYear=' . $currentYear . '&adec_contact_id=' . $ContactsID . "&link_contact_id=' + document.getElementById('link_contact_id').value",
 ]
 ]
 ) . '';
 }
 }

if (isset($_REQUEST['action']) && $_REQUEST['action'] == 'COPY_CONTACTS') {

$officeContactsObj = new ADec_OfficeContacts($sqlf);
        $officeContactsObj->getOrCreate($OfficeID, $OriginalOfficeID, $currentYear);
        // exit;

?>
 <script language="javascript">
 window.location = 'ADdisplayContacts.php?OfficeID=<?php echo $OfficeID; ?>&selectYear=<?php echo $currentYear; ?>';
 </script>
 <?php
 }

// set values
    $name1 = $ds['ContactsID'];
    $name2 = $ds['OfficeID'];
    $name3 = $es['ContactSurname'];
    $name4 = $es['ContactInitials'];
    $name5 = $es['ContactFirstName'];
    $name6 = $es['ProfessionalRegistrations'];
    $name7 = $es['Qualifications'];
    $name8 = $es['Comments'];
    $name9 = $ds['ContactPosition'];
    $name10 = $es['PreferredEmail'];
    $name11 = $ds['MandatedPrincipal'];
    $name12 = $ds['OfficeHead'];
    $name13 = $ds['Principal'];
    $name14 = $ds['OfficeLiaison'];
    $name15 = $ds['OfficeLiaisonB'];
    $name16 = $ds['SchoolMail'];
    $name17 = $es['ContactDesignation'];
    $name18 = $ds['Email'];
    $name19 = $ds['Mail'];
    $name20 = $ds['OfficeLiaison'];
    $name21 = $ds['OfficeLiaisonB'];
    $name22 = $es['IDNumber'];
    $name23 = $es['CellPhone'];
    $YPF = $ds['YPF'];

$newrowstyle = '';

if ($es['ContactID'] == 1) {
        $newrowstyle = " style='text-decoration:line-through;'";
    }

if ($something == "ACCEPT" && $currentYear == date('Y')) {

// Check if the contact exists
        $Origquery = "SELECT ContactsID FROM Contacts WHERE ContactsID = '$Prev_ContactsID'";
        $Origresult = mysql_query($Origquery) or die("Select of id Failed");
        $origexists = mysql_num_rows($Origresult);
        if ($origexists > 0) {
            //Check if the record should be deleted

if ($es['ContactID'] == 1) {
                // kill it
                $ACCquery2 = "DELETE FROM MemberContacts WHERE ContactID = '$Prev_ContactsID'";
                $ACCresult2 = mysql_query($ACCquery2) or die("delete failed");

$ACCquery = "DELETE FROM OfficeContacts WHERE ContactsID = '$Prev_ContactsID'";
                $ACCresult = mysql_query($ACCquery) or die("delete failed");

$ACCquery = "DELETE FROM Contacts WHERE ContactsID = '$Prev_ContactsID'";
                $ACCresult = mysql_query($ACCquery) or die("delete failed");
            } else {
                //update it
                $ACCquery2 = "UPDATE MemberContacts SET
			ContactSurname = '" . addslashes($name3) . "',
			ContactInitials = '$name4',
			ContactFirstName = '" . addslashes($name5) . "',
			Comments = '" . addslashes($name8) . "',
			ProfessionalRegistrations = '" . addslashes($name6) . "',
			Qualifications = '" . addslashes($name7) . "',
			ContactPosition = '$name9',
			MandatedPrincipal = '$name11',
			OfficeHead = '$name12',
			Principal = '$name13',
			Email = '$name10',
			IDNumber = '$name22',
			CellPhone = '$name23' WHERE ContactID = '$Prev_ContactsID'";
                // echo $ACCquery2;
                $ACCresult = mysql_query($ACCquery2) or die("update failed " . $ACCquery2);

$ACCquery2 = "UPDATE Contacts SET
			ContactSurname = '" . addslashes($name3) . "',
			ContactInitials = '$name4',
			ContactFirstName = '" . addslashes($name5) . "',
			Comments = '" . addslashes($name8) . "',
			ProfessionalRegistrations = '" . addslashes($name6) . "',
			Qualifications = '" . addslashes($name7) . "',
			PreferredEmail = '$name10',
			IDNumber = '$name22',
			CellPhone = '$name23' WHERE ContactsID = '$Prev_ContactsID'";
                // echo $ACCquery2;
                $ACCresult = mysql_query($ACCquery2) or die("update failed " . $ACCquery2);

$ACCquery2 = "UPDATE OfficeContacts SET
			ContactPosition = '$name9',
			MandatedPrincipal = '$name11',
			OfficeHead = '$name12',
			Principal = '$name13',
			Email = '$name10'
			WHERE ContactsID = '$Prev_ContactsID'";
                // echo $ACCquery2;
                $ACCresult = mysql_query($ACCquery2) or die("update failed " . $ACCquery2);
            }
        } else {
            // New record
            //Check if the record should be deleted

if ($es['ContactID'] != 1) {

$recNewID = mysql_query("SELECT MAX(ContactsID) AS NewID FROM Contacts");
                $rowNewID = mysql_fetch_assoc($recNewID);
                $iCurrentTopID = $rowNewID["NewID"];

$ACCquery2 = "INSERT INTO Contacts (ContactSurname, ContactInitials, ContactFirstName,
				ContactDesignation, Comments, ProfessionalRegistrations, Qualifications,
				PreferredEmail, IDNumber, CellPhone) VALUES ('" . addslashes($name3) . "', '" . addslashes($name4) . "', '" . addslashes($name5) . "', '"
                    . addslashes($name17) . "', '" . addslashes($name8) . "', '" . addslashes($name6) . "', '" . addslashes($name7) . "', '"
                    . addslashes($name10) . "', '" . addslashes($name22) . "', '" . addslashes($name23) . "')";

$ACCresult2 = mysql_query($ACCquery2) or die("update failed " . $ACCquery2);

// Get new ContactsID
                $NewContactsID = $iCurrentTopID++; //mysql_insert_id();

if (intval($NewContactsID) <= intval($iCurrentTopID)) {
 die("Could not create new contact: " . $ACCquery2);
 }

$ACCquery = "INSERT INTO OfficeContacts (ContactsID, OfficeID, ContactPosition, MandatedPrincipal,
				OfficeHead, Principal, Email, Mail, OfficeLiaison, OfficeLiaisonB,
				SchoolMail, YPF) VALUES ('$NewContactsID', '$OriginalOfficeID', '" . addslashes($name9) . "', '" . addslashes($name11) . "', '" . addslashes($name12) . "', '" . addslashes($name13) . "', '" . addslashes($name10) . "', '" . addslashes($name19) . "',
				'" . addslashes($name20) . "', '" . addslashes($name21) . "', '" . addslashes($name16) . "', '$YPF')";
                $ACCresult = mysql_query($ACCquery) or die("update failed " . $ACCquery2);

// add it
                $ACCquery2 = "INSERT INTO MemberContacts (ContactID, ContactSurname, ContactInitials, ContactFirstName,
				ContactDesignation, Comments, ProfessionalRegistrations, Qualifications,
				OfficeID, ContactPosition, MandatedPrincipal,
				OfficeHead, Principal, Email, Mail, OfficeLiaison, OfficeLiaisonB,
				SchoolMail, IDNumber, CellPhone, YPF) VALUES ('$NewContactsID', '" . addslashes($name3) . "', '" . addslashes($name4) . "', '" . addslashes($name5) . "', '" . addslashes($name17) . "', '" . addslashes($name8) . "', '" . addslashes($name6) . "', '" . addslashes($name7) . "',
				'$OriginalOfficeID', '" . addslashes($name9) . "', '" . addslashes($name11) . "', '" . addslashes($name12) . "', '" . addslashes($name13) . "', '" . addslashes($name10) . "', '" . addslashes($name19) . "',
				'" . addslashes($name20) . "', '" . addslashes($name21) . "', '" . addslashes($name16) . "', '" . addslashes($name22) . "', '" . addslashes($name23) . "', '$YPF')";
                $ACCresult2 = mysql_query($ACCquery2) or die("update failed " . $ACCquery2);

$ACCquery = "UPDATE $tableNameContacts Set Prev_ContactsID='$NewContactsID' WHERE ContactsID='$ContactsID'";
                $ACCresult = mysql_query($ACCquery) or die("update failed " . $ACCquery2);
                log_query($ACCquery);

$ACCquery = "UPDATE ADec_Contacts Set Prev_ContactsID='$NewContactsID' WHERE ContactsID='$ContactsID'";
                $ACCresult = mysql_query($ACCquery) or die("update failed " . $ACCquery2);
                log_query($ACCquery);

$Prev_ContactsID = $NewContactsID;
            }
        }

$updatequery2 = "INSERT INTO ADec_Done_Local (RefID,RefType,RefDoc,ADecDate) VALUES ('$ContactsID','ContactsID','UPDATED','$Mn1')";
        $Upresult2 = mysql_query($updatequery2) or die("Update of records failed: " . $updatequery2);
        //log_query($updatequery2);
    }

if ($something == "DECLINED") {
        $updatequery2 = "INSERT INTO ADec_Done_Local (RefID,RefType,RefDoc,ADecDate) VALUES ('$ContactsID','ContactsID','DECLINED','$Mn1')";
        $Upresult2 = mysql_query($updatequery2) or die("Update of records failed: " . $updatequery2);
        //log_query($updatequery2);
    }

// Number of old contacts
    $numoldquery = "SELECT * FROM MemberContacts WHERE OfficeID = '$OriginalOfficeID'";

// echo 'Please ignore debug info: ' . $numoldquery . ' ';

$numoldresult = mysql_query($numoldquery) or die("Select of id Failed " . $numoldquery);
    $numoldcnt = mysql_num_rows($numoldresult);

$Yquery = "SELECT * FROM OfficeContacts WHERE ContactsID = '$Prev_ContactsID'";
    $Yresult = mysql_query($Yquery) or die("Select of id Failed " . $Yquery);
    $ys = mysql_fetch_array($Yresult);

$Zquery = "SELECT ContactID AS ContactsID, ContactSurname, ContactInitials, ContactFirstName, ProfessionalRegistrations, Qualifications, 
 Comments, Email AS PreferredEmail, CellPhone, IDNumber 
 FROM MemberContacts 
 WHERE ContactID = '$Prev_ContactsID'";
 // echo 'Please ignore debug info: ' . $Zquery . ' ';
 $Zresult = mysql_query($Zquery) or die("Select of id Failed " . $Zquery);
 $zs = mysql_fetch_array($Zresult);
 ?>
 <table width="100%" border="0" cellspacing="0" cellpadding="0">
 <tr>
 <td bgcolor="#CCCCCC">
 <?php include('inc/menu.inc'); ?>
 </td>
 </tr>
 <tr>
 <td align="left" valign="top">
 <h3>
 Display Contacts For The Office:
 
 
 </h3>
 
 <?php echo $ws; ?> Contacts Loaded in Annual Declarations 
 <?php
 if ($ws <= 0) {
 ?>
 <a href="ADdisplayContacts.php?OfficeID=<?php echo $OfficeID; ?>&selectYear=<?php echo $currentYear; ?>&action=COPY_CONTACTS">Copy Contacts from last year</a>
 <?php
 }
 ?>
 
 <table width="100%" border="0" cellspacing="0" cellpadding="0">
 <tr>
 <td>
 
 Record Status
 <?php
 $RefId = $ds['ContactsID'];
 $DDDquery = "SELECT distinct RefDoc FROM ADec_Done WHERE RefID = '$name1' AND RefType = 'OfficeID' AND RefDoc NOT IN ('UPDATED', 'DECLINED', 'DECLINE')";
 $DDDresult = mysql_query($DDDquery) or die("Select of id Failed");
 while ($ddds = mysql_fetch_array($DDDresult)) {
 echo " : " . $ddds['RefDoc'] . " ";
 }
 $DDDquery = "SELECT distinct RefDoc FROM ADec_Done_Local WHERE RefID = '$name1' AND RefType = 'OfficeID' AND RefDoc IN ('UPDATED', 'DECLINED', 'DECLINE')";
 $DDDresult = mysql_query($DDDquery) or die("Select of id Failed");
 while ($ddds = mysql_fetch_array($DDDresult)) {
 echo " : " . $ddds['RefDoc'] . " ";
 }
 ?>
 
 
 </td>
 </tr>
 <tr>
 <td width="25%">
 <div align="left"><?php
 if ($rowcounter > 1) {
 $NewFile = "ADdisplayContacts.php";
 printf("<a href=\"%s?OfficeID=%s&ContactID=%s&action=prev&rowcounter=%s\")'><img src=previous.jpg border=0>PREVIOUS</a>\n", $NewFile, $OfficeID, $ContactsID, $rowcounter - 1);
 }
 ?></div>
 </td>
 <td width="24%">&nbsp;</td>
 <td width="51%">
 <div align="right"><?php
 if ($rowcounter < $numnewcnt) {
 $NewFile = "ADdisplayContacts.php";
 printf("<a href=\"%s?OfficeID=%s&ContactID=%s&action=next&rowcounter=%s\")'>NEXT<img src=next.jpg border=0></a>\n", $NewFile, $OfficeID, $ContactsID, $rowcounter + 1);
 }
 ?></div>
 </td>
 </tr>
 <tr>
 <td colspan="3">
 <table width="100%" border="0" cellspacing="0" cellpadding="0">
 <tr>
 <td colspan="2">
 <div align="center">
 You
 can ACCEPT or DECLINE the changes here. You can only do this
 once!
 </div>
 </td>
 </tr>
 <tr>
 <td width="50%">
 
 <?php
 if (($action == "next") || ($action == "prev")) {
 $NewFile = "ADdisplayContacts.php";
 printf("<a href=\"%s?OfficeID=%s&ContactID=%s&something=DECLINED&action=return&rowcounter=%s\")'><img src=decline.jpg border=0>DECLINE</a>\n", $NewFile, $OfficeID, $ContactsID, $rowcounter);
 } else {
 $NewFile = "ADdisplayContacts.php";
 printf("<a href=\"%s?OfficeID=%s&something=DECLINED\")'><img src=decline.jpg border=0>DECLINE</a>\n", $NewFile, $OfficeID);
 }
 ?>
 
 </td>
 <td width="50%">
 <div align="right">
 
 <?php
 if (($action == "next") || ($action == "prev")) {
 $NewFile = "ADdisplayContacts.php";
 printf("<a href=\"%s?OfficeID=%s&ContactID=%s&something=ACCEPT&action=return&rowcounter=%s\")'><img src=accept.jpg border=0>ACCEPT</a>\n", $NewFile, $OfficeID, $ContactsID, $rowcounter);
 } else {
 $NewFile = "ADdisplayContacts.php";
 printf("<a href=\"%s?OfficeID=%s&something=ACCEPT\")'><img src=accept.jpg border=0>ACCEPT</a>\n", $NewFile, $OfficeID);
 }
 ?>
 
 </div>
 </td>
 </tr>
 </table>

<table width="100%" border="1" cellspacing="0" cellpadding="0" id="tblShaded" name="tblShaded">
 <tr>
 <td width="26%" bgcolor="#0000FF">
 
 </td>
 <td width="36%" bgcolor="#0000FF">
 Original
 (<?php echo $numoldcnt; ?> records)
 
 </td>
 <td width="38%" bgcolor="#0000FF">
 New
 (record <?php
 if ($es['ContactID'] == 1) {
 echo 'DELETED';
 } else {
 echo $rowcounter . ' of ' . $numnewcnt;
 }
 ?>)
 
 </td>
 </tr>
 
 <tr>
 <td width="26%" bgcolor="#0000FF">
 Surname
 </td>
 <td width="36%">
 <?php echo $zs['ContactSurname']; ?> </td>
 <td width="38%" <?php echo $newrowstyle ?>>
 <?php echo $es['ContactSurname']; ?> </td>
 </tr>
 <tr>
 <td width="26%" bgcolor="#0000FF">
 Initials
 </td>
 <td width="36%">
 <?php echo $zs['ContactInitials']; ?> </td>
 <td width="38%" <?php echo $newrowstyle ?>>
 <?php echo $es['ContactInitials']; ?> </td>
 </tr>
 <tr>
 <td width="26%" bgcolor="#0000FF">
 Known
 As 
 </td>
 <td width="36%">
 <?php echo $zs['ContactFirstName']; ?> </td>
 <td width="38%" <?php echo $newrowstyle ?>>
 <?php echo $es['ContactFirstName']; ?> </td>
 </tr>
 <tr>
 <td width="26%" bgcolor="#0000FF">
 Proff
 Registration
 </td>
 <td width="36%">
 <?php echo $zs['ProfessionalRegistrations']; ?> </td>
 <td width="38%" <?php echo $newrowstyle ?>>
 <?php echo $es['ProfessionalRegistrations']; ?> </td>
 </tr>
 <tr>
 <td width="26%" bgcolor="#0000FF">
 Qualifications
 </td>
 <td width="36%">
 <?php echo $zs['Qualifications']; ?> </td>
 <td width="38%" <?php echo $newrowstyle ?>>
 <?php echo $es['Qualifications']; ?> </td>
 </tr>
 <tr>
 <td width="26%" bgcolor="#0000FF">
 Field/s
 of Expertise
 </td>
 <td width="38%">
 <?php echo $zs['Comments']; ?> </td>
 <td width="38%" <?php echo $newrowstyle ?>>
 <?php echo $es['Comments']; ?> </td>
 </tr>
 <tr>
 <td width="26%" bgcolor="#0000FF">
 Position
 in firm
 </td>
 <td width="38%">
 <?php echo $ys['ContactPosition']; ?> </td>
 <td width="38%" <?php echo $newrowstyle ?>>
 <?php echo $ds['ContactPosition']; ?> </td>
 </tr>
 <tr>
 <td width="26%" bgcolor="#0000FF">
 E-mail
 address 
 </td>
 <td width="38%">
 <?php echo $zs['PreferredEmail']; ?> </td>
 <td width="38%" <?php echo $newrowstyle ?>>
 <?php echo $es['PreferredEmail']; ?> </td>
 </tr>
 <tr>
 <td width="26%" bgcolor="#0000FF">
 Mandated
 Principal
 </td>
 <td width="38%">
 <?php
 if ($ys['MandatedPrincipal'] == 0) {
 echo "No";
 } else {
 echo "Yes";
 }
 ?> </td>
 <td width="38%" <?php echo $newrowstyle ?>>
 <?php
 if ($ds['MandatedPrincipal'] == 0) {
 echo "No";
 } else {
 echo "Yes";
 }
 ?> </td>
 </tr>
 <tr>
 <td width="26%" bgcolor="#0000FF">
 Office
 Head 
 </td>
 <td width="38%">
 <?php
 if ($ys['OfficeHead'] == 0) {
 echo "No";
 } else {
 echo "Yes";
 }
 ?> </td>
 <td width="38%" <?php echo $newrowstyle ?>>
 <?php
 if ($ds['OfficeHead'] == 0) {
 echo "No";
 } else {
 echo "Yes";
 }
 ?> </td>
 </tr>
 <tr>
 <td width="26%" bgcolor="#0000FF">
 Principal
 </td>
 <td width="38%">
 <?php
 if ($ys['Principal'] == 0) {
 echo "No";
 } else {
 echo "Yes";
 }
 ?> </td>
 <td width="38%" <?php echo $newrowstyle ?>>
 <?php
 if ($ds['Principal'] == 0) {
 echo "No";
 } else {
 echo "Yes";
 }
 ?> </td>
 </tr>
 <tr>
 <td width="26%" bgcolor="#0000FF">
 ID Number 
 </td>
 <td><?php echo $zs['IDNumber']; ?></td>
 <td<?php echo $newrowstyle ?>><?php echo $es['IDNumber']; ?>
 </td>
 </tr>
 <tr>
 <td width="26%" bgcolor="#0000FF">
 Cellphone Number 
 </td>
 <td><?php echo $zs['CellPhone']; ?></td>
 <td<?php echo $newrowstyle ?>><?php echo $es['CellPhone']; ?>
 </td>
 </tr>
 <tr>
 <td width="26%" bgcolor="#0000FF">
 Office
 Liaison 
 </td>
 <td width="38%">
 <?php echo $ys['OfficeLiaison']; ?> </td>
 <td width="38%" <?php echo $newrowstyle ?>>
 <?php echo $ds['OfficeLiaison']; ?> </td>
 </tr>
 <tr>
 <td width="26%" bgcolor="#0000FF">
 Office
 Liaison B
 </td>
 <td width="38%">
 <?php echo $ys['OfficeLiaisonB']; ?> </td>
 <td width="38%" <?php echo $newrowstyle ?>>
 <?php echo $ds['OfficeLiaisonB']; ?> </td>
 </tr>
 <tr>
 <td width="26%" bgcolor="#0000FF">
 School
 Mail
 </td>
 <td width="38%">
 <?php echo $ys['SchoolMail']; ?> </td>
 <td width="38%" <?php echo $newrowstyle ?>>
 <?php echo $ds['SchoolMail']; ?> </td>
 </tr>
 <tr>
 <td width="26%" bgcolor="#0000FF">
 YPF (only updated for new contacts)
 </td>
 <td width="38%">
 <?php echo $ys['YPF']; ?> </td>
 <td width="38%" <?php echo $newrowstyle ?>>
 <?php echo $ds['YPF']; ?> </td>
 </tr>
 <tr>
 <td colspan="3">
 <div align="center">
 Click
 here to return to the
 <?php
 $NewFile = "ADdisplayOffices.php";
 printf("<a href=\"%s?OfficeID=%s&action=return&selectYear=$currentYear\")'>OFFICE</a>\n", $NewFile, $OfficeID);
 ?>
 for this Contact 
 </div>
 </td>
 </tr>
 </table>
 </td>
 </tr>
 <tr>
 <td colspan="3">
 <table width="100%" border="0" cellspacing="0" cellpadding="0">
 <tr>
 <td colspan="2">
 <div align="center">
 You
 can ACCEPT or DECLINE the changes here. You can only do this
 once!
 </div>
 </td>
 </tr>
 <tr>
 <td width="50%">
 
 <?php
 if (($action == "next") || ($action == "prev")) {
 $NewFile = "ADdisplayContacts.php";
 printf("<a href=\"%s?OfficeID=%s&ContactID=%s&something=DECLINED&action=return&rowcounter=%s\")'><img src=decline.jpg border=0>DECLINE</a>\n", $NewFile, $OfficeID, $ContactsID, $rowcounter);
 } else {
 $NewFile = "ADdisplayContacts.php";
 printf("<a href=\"%s?OfficeID=%s&something=DECLINED\")'><img src=decline.jpg border=0>DECLINE</a>\n", $NewFile, $OfficeID);
 }
 ?>
 
 </td>
 <td width="50%">
 <div align="right">
 
 <?php
 if (($action == "next") || ($action == "prev")) {
 $NewFile = "ADdisplayContacts.php";
 printf("<a href=\"%s?OfficeID=%s&ContactID=%s&something=ACCEPT&action=return&rowcounter=%s\")'><img src=accept.jpg border=0>ACCEPT</a>\n", $NewFile, $OfficeID, $ContactsID, $rowcounter);
 } else {
 $NewFile = "ADdisplayContacts.php";
 printf("<a href=\"%s?OfficeID=%s&something=ACCEPT\")'><img src=accept.jpg border=0>ACCEPT</a>\n", $NewFile, $OfficeID);
 }
 ?>
 
 </div>
 </td>
 </tr>
 </table>
 </td>
 </tr>
 </table>
 </td>
 </tr>
 <tr>
 <td bgcolor="#CCCCCC"><?php include('inc/footer.inc'); ?></td>
 </tr>
 </table>
 <script language="javascript" src="ShadeTable.js"></script>
 <script language="javascript">
 ShadeTable(document.getElementsByName("tblShaded"));
 </script>
</body>

</html>