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">
 <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');
    // mysql_connect("$host", "$user", "$password") or die("Unable to connect to SQL server");
    // mysql_select_db("$db") or die("Unable to select database");

// ** ADEC_TBLMEMBERFIRMS
    // **********************

$currentYear = $_REQUEST['selectYear'];

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

$tableName = 'ADec_tblMemberFirms';
    $tableWhere = '';
    $FirmID = $_REQUEST['FirmID'];

if ($currentYear <= 2022) {
 $tableName = 'ADec_tblMemberFirms_' . $currentYear;
 } elseif ($currentYear == 2023) {
 $tableName = 'ADec_tblMemberFirms_Prev';
 } else {
 $tableWhere = ' AND admf.DeclarationYear = ' . $currentYear;
 }

$query = "SELECT admf.FirmID, admf.Prev_FirmID, admf.FirmName, admf.PIUnderwriter, 
                admf.LevelOfCover, admf.FormOfIncorporation, admf.`Quality Management`, 
                admf.`Date of last peer review`, admf.URL
                , admf.QMSPlan, admf.QMSDocs, admf.QMSISOComply, admf.QMSISOCert
                , admf.QMSOffices, admf.QMSConsult, admf.QMSCertBody, admf.QMSISOCertDate, 
                admf.QMSImplemented, admf.QMSImplFully, admf.QMSImplPart, admf.QMSAssess
                , admf.QMSUseConsult, admf.QMSIntend, admf.DeclarationReceived, admf.MainFirmInvoice, 
                admf.GroupFirmsInvoice, admf.MentoringProg, admf.CandidateProg, admf.SubscriptionsContact, 
                admf.SubscriptionsEmail, admf.HRTrainingContact, admf.HRTrainingEmail, 
                admf.MarketingContact, admf.MarketingEmail, admf.CAUSigned, admf.BBBEE, admf.YPFContact, 
                admf.YPFEmail, admf.SMME, admf.SMMEAmount, admf.BlackOwned, admf.BlackWomenOwned,
                admf.WomenOwned, admf.SABTACO, admf.BBCBE, admf.GBCSA, admf.GoToPersonEmail, 
                admf.GoToPersonName, adt.ThreeYearsAverageTurnover, admf.SustainabilityPolicy,
                admf.SustainabilityIssues, admf.SustainabilityProcess, admf.SustainabilityChampion,
                admf.SustainabilityChampName, admf.SustainabilityFramework, admf.SustainabilityDiscussed,
                admf.SustainabilityIndicator1, admf.SustainabilityIndicator2, admf.SustainabilityIndicator3,
                admf.SustainabilityIndicator4, admf.SustainabilityIndicator5, admf.QMIG, admf.QMSChampion,
                admf.QMSChampName, admf.QMSChampEmail, admf.SustainabilityChampEmail,
                admf.ProcurementContact, admf.ProcurementEmail, admf.SubscriptionsTel,
                admf.HRTrainingTel, admf.MarketingTel, admf.ProcurementTel
	        FROM $tableName admf "
        . "LEFT JOIN ADec_Transformation adt ON admf.Prev_FirmID = adt.Prev_FirmID 
                AND admf.DeclarationYear = adt.DeclarationYear "
        . "WHERE admf.FirmID = '$FirmID' $tableWhere";

// echo 'Please ignore debug info: ' . $query . ' ';
 // exit;

$result = mysql_query($query) or die("Select of id Failed; " . 'Please ignore debug info: ' . $query . ' ');
 $rs = mysql_fetch_array($result);
 $FirmID = $rs['FirmID'];
 $Prev_FirmID = $rs['Prev_FirmID'];
 $Mx1 = $rs['MainFirmInvoice'];
 $My1 = $rs['GroupFirmsInvoice'];
 $Ma1 = $rs['FirmName'];
 $Mb1 = $rs['PIUnderwriter'];
 $Mc1 = $rs['LevelOfCover'];
 $Md1 = $rs['FormOfIncorporation'];
 $Me1 = $rs['URL'];
 $Mf1 = $rs['QMSPlan'];
 $Mg1 = $rs['QMSDocs'];
 $Mh1 = $rs['QMSISOComply'];
 $Mi1 = $rs['QMSISOCert'];
 $Mj1 = ($rs['QMSISOCertDate'] == '') ? "NULL" : "'" . $rs['QMSISOCertDate'] . "'";
 $Mk1 = $rs['QMSOffices'];
 $Ml1 = $rs['QMSConsult'];
 $Mm1 = $rs['QMSCertBody'];
 $Mn1 = date("Y-m-d H:i");

$Q2 = $rs['QMSImplemented'];
    $Q3 = $rs['QMSImplFully'];
    $Q4 = $rs['QMSImplPart'];
    $Q5 = $rs['QMSAssess'];
    $Q6 = $rs['QMSUseConsult'];
    $Q7 = $rs['QMSIntend'];

$AMentoringProg = $rs['MentoringProg'];
    $ACandidateProg = $rs['CandidateProg'];
    $ASubscriptionsContact = $rs['SubscriptionsContact'];
    $ASubscriptionsEmail = $rs['SubscriptionsEmail'];
    $AHRTrainingContact = $rs['HRTrainingContact'];
    $AHRTrainingEmail = $rs['HRTrainingEmail'];
    $AMarketingContact = $rs['MarketingContact'];
    $AMarketingEmail = $rs['MarketingEmail'];

$ACAUSigned = $rs['CAUSigned'];
    $ABBBEE = $rs['BBBEE'];
    $ASMME = ADec_tblMemberFirms::getAnnualTurnoverValue($rs['SMME'], $rs['SMMEAmount']);
    $ABlackOwned = ADec_tblMemberFirms::getBlackOwnedValue($rs['BlackOwned']);
    $ABlackWomenOwned = ADec_tblMemberFirms::getBlackWomenOwnedValue($rs['BlackWomenOwned']);
    $AWomenOwned = ADec_tblMemberFirms::getBlackWomenOwnedValue($rs['WomenOwned']);
    $AYPFContact = $rs['YPFContact'];
    $AThreeYearsAverageTurnover = $rs['ThreeYearsAverageTurnover'];
    $AYPFEmail = $rs['YPFEmail'];

$SABTACO = $rs['SABTACO'];
    $BBCBE = $rs['BBCBE'];
    $GBCSA = $rs['GBCSA'];

$sql = "SELECT * FROM ADec_tblMemberFirmSkills 
            WHERE FirmID=" . $FirmID; // . " AND DeclarationYear = $currentYear";

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

$recASkills = mysql_query($sql);
    $arrFirmSkillsNew = array();
    while ($rowASkills = mysql_fetch_array($recASkills)) {
        $arrFirmSkillsNew[$rowASkills["SkillsListID"]] = $rowASkills["EngineerName"];
    }

//TODO: Add check box to retrieve skills from previous
    // if (count($arrFirmSkillsNew) > 0) {
    //     // Get the previous year's skills
    //     $sql = "SELECT * FROM ADec_tblMemberFirmSkills 
    //     WHERE FirmID=" . $FirmID . " AND DeclarationYear = " . ($currentYear - 1);

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

//     $recASkills = mysql_query($sql);
    //     $arrFirmSkillsNew = array();
    //     while ($rowASkills = mysql_fetch_array($recASkills)) {
    //         $arrFirmSkillsNew[$rowASkills["SkillsListID"]] = $rowASkills["EngineerName"];
    //     }

// }

mysql_free_result($recASkills);
    // Set defaults ****************
    //******************************
    // Set default values

$Bquery = "SELECT OfficeID, FirmID FROM ADec_tblMemberFirmOffices WHERE FirmID = '$FirmID'";
    $Bresult = mysql_query($Bquery) or die("Select of id Failed");
    $bs = mysql_fetch_array($Bresult);
    $OfficeID = $bs['OfficeID'];

$Cquery = "SELECT ContactsID, OfficeID, MandatedPrincipal FROM ADec_OfficeContacts WHERE OfficeID = '$OfficeID'";
    $Cresult = mysql_query($Cquery) or die("Select of id Failed");
    $ds = mysql_fetch_array($Cresult);
    $ContactsID = $ds['ContactsID'];

$Dquery = "SELECT * FROM ADec_Done WHERE (RefID = '$FirmID') AND (RefDoc = 'AnnualDeclaration')";
    $Dresult = mysql_query($Dquery) or die("Select of id Failed");
    $ds = mysql_fetch_array($Dresult);
    $CompletedDate = date("Y-m-d", strtotime($ds['ADecDate']));

if ($action == "ACCEPT") {
        if (false && $Prev_FirmID > 10000) {
            // Accepting a new application
            $sql = "INSERT INTO tblMemberFirms (FirmName) VALUES ('" . addslashes($Ma1) . "')";
            mysql_query($sql);
            $New_Prev_FirmID = mysql_insert_id();

$sql = "UPDATE ADec_tblMemberFirms SET Prev_FirmID=" . $New_Prev_FirmID . " WHERE Prev_FirmID=" . $Prev_FirmID;
            mysql_query($sql);

$sql = "UPDATE ADec_tblMemberFirmOffices SET Prev_FirmID=" . $New_Prev_FirmID . " WHERE Prev_FirmID=" . $Prev_FirmID;
            mysql_query($sql);

$sql = "UPDATE ADec_QMIG SET Prev_FirmID=" . $New_Prev_FirmID . " WHERE Prev_FirmID=" . $Prev_FirmID;
            mysql_query($sql);

$sql = "UPDATE ADec_Transformation SET Prev_FirmID=" . $New_Prev_FirmID . " WHERE Prev_FirmID=" . $Prev_FirmID;
            mysql_query($sql);

$sql = "UPDATE tblMemberFirmOffices SET FirmID=" . $New_Prev_FirmID . " WHERE FirmID=" . $Prev_FirmID;
            mysql_query($sql);

$sql = "UPDATE tblQMIG SET FirmID=" . $New_Prev_FirmID . " WHERE FirmID=" . $Prev_FirmID;
            mysql_query($sql);

$sql = "UPDATE tblMemberFirmsTransformation SET FirmID=" . $New_Prev_FirmID . " WHERE FirmID=" . $Prev_FirmID;
            mysql_query($sql);

$sql = "UPDATE tblMemberFirmsSkills SET FirmID=" . $New_Prev_FirmID . " WHERE FirmID=" . $Prev_FirmID;
            mysql_query($sql);

$Prev_FirmID = $New_Prev_FirmID;
        }

$updatequery = "UPDATE tblMemberFirms SET
FirmName = '" . addslashes($Ma1) . "',
PIUnderwriter = '" . addslashes($Mb1) . "',
LevelOfCover = '$Mc1',
FormOfIncorporation = '$Md1',
URL = '$Me1',
QMSPlan = '$Mf1',
QMSDocs = '$Mg1',
QMSISOComply = '$Mh1',
QMSISOCert = '$Mi1',
QMSISOCertDate = $Mj1,
QMSOffices = '$Mk1',
QMSConsult = '" . addslashes($Ml1) . "',
QMSCertBody = '" . addslashes($Mm1) . "',
QMSImplemented = '$Q2',
QMSImplFully = '$Q3',
QMSImplPart = '$Q4',
QMSAssess = '$Q5',
QMSUseConsult = '$Q6',
QMSIntend = '$Q7',
DeclarationReceived = '$Mn1',
MentoringProg = '" . addslashes($AMentoringProg) . "',
CandidateProg = '" . addslashes($ACandidateProg) . "',
SubscriptionsContact = '" . addslashes($ASubscriptionsContact) . "',
SubscriptionsEmail = '" . addslashes($ASubscriptionsEmail) . "',
HRTrainingContact = '" . addslashes($AHRTrainingContact) . "',
HRTrainingEmail = '" . addslashes($AHRTrainingEmail) . "',
MarketingContact = '" . addslashes($AMarketingContact) . "',
MarketingEmail = '" . addslashes($AMarketingEmail) . "',
CAUSigned = '" . addslashes($ACAUSigned) . "',
BBBEE = '" . addslashes($ABBBEE) . "',
SMME = '" . addslashes($ASMME) . "',
BlackOwned = '" . addslashes($ABlackOwned) . "',
BlackWomenOwned = '" . addslashes(ADec_tblMemberFirms::getBlackWomenOwnedValue($ABlackWomenOwned)) . "',
WomenOwned = '" . addslashes(ADec_tblMemberFirms::getBlackWomenOwnedValue($AWomenOwned)) . "',
YPFContact = '" . addslashes($AYPFContact) . "',
ThreeYearsAverageTurnover = '" . addslashes((float) $AThreeYearsAverageTurnover) . "',
YPFEmail = '" . addslashes($AYPFEmail) . "',
SABTACO='" . $SABTACO . "',
BBCBE='" . $BBCBE . "',
GBCSA='" . $GBCSA . "',
MainFirmInvoice = '" . addslashes($Mx1) . "',
GroupFirmsInvoice = '" . addslashes($My1) . "' WHERE FirmID = '$Prev_FirmID'";
 // echo 'Please ignore debug info: ' . $updatequery . ' ';
 // exit;

$Upresult = mysql_query($updatequery) or die("Update of records failed " . $updatequery);

$sql = "UPDATE tblMemberFirms, ADec_tblMemberFirms
SET tblMemberFirms.SustainabilityPolicy=ADec_tblMemberFirms.SustainabilityPolicy,
tblMemberFirms.SustainabilityIssues=ADec_tblMemberFirms.SustainabilityIssues,
tblMemberFirms.SustainabilityProcess=ADec_tblMemberFirms.SustainabilityProcess,
tblMemberFirms.SustainabilityChampion=ADec_tblMemberFirms.SustainabilityChampion,
tblMemberFirms.SustainabilityChampName=ADec_tblMemberFirms.SustainabilityChampName,
tblMemberFirms.SustainabilityFramework=ADec_tblMemberFirms.SustainabilityFramework,
tblMemberFirms.SustainabilityDiscussed=ADec_tblMemberFirms.SustainabilityDiscussed,
tblMemberFirms.SustainabilityIndicator1=ADec_tblMemberFirms.SustainabilityIndicator1,
tblMemberFirms.SustainabilityIndicator2=ADec_tblMemberFirms.SustainabilityIndicator2,
tblMemberFirms.SustainabilityIndicator3=ADec_tblMemberFirms.SustainabilityIndicator3,
tblMemberFirms.SustainabilityIndicator4=ADec_tblMemberFirms.SustainabilityIndicator4,
tblMemberFirms.SustainabilityIndicator5=ADec_tblMemberFirms.SustainabilityIndicator5,
tblMemberFirms.QMIG=ADec_tblMemberFirms.QMIG,
tblMemberFirms.QMSChampion=ADec_tblMemberFirms.QMSChampion,
tblMemberFirms.QMSChampName=ADec_tblMemberFirms.QMSChampName,
tblMemberFirms.QMSChampEmail=ADec_tblMemberFirms.QMSChampEmail,
tblMemberFirms.SustainabilityChampEmail=ADec_tblMemberFirms.SustainabilityChampEmail,
tblMemberFirms.ProcurementContact=ADec_tblMemberFirms.ProcurementContact,
tblMemberFirms.ProcurementEmail=ADec_tblMemberFirms.ProcurementEmail,
tblMemberFirms.SubscriptionsTel=ADec_tblMemberFirms.SubscriptionsTel,
tblMemberFirms.HRTrainingTel=ADec_tblMemberFirms.HRTrainingTel,
tblMemberFirms.MarketingTel=ADec_tblMemberFirms.MarketingTel,
tblMemberFirms.ProcurementTel=ADec_tblMemberFirms.ProcurementTel,
tblMemberFirms.GoToPersonName=ADec_tblMemberFirms.GoToPersonName,
tblMemberFirms.GoToPersonEmail=ADec_tblMemberFirms.GoToPersonEmail,
tblMemberFirms.YPFContactTel=ADec_tblMemberFirms.YPFContactTel
WHERE tblMemberFirms.FirmID=ADec_tblMemberFirms.Prev_FirmID 
AND tblMemberFirms.FirmID = '$Prev_FirmID' AND ADec_tblMemberFirms.DeclarationYear = $currentYear";

mysql_query($sql);

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

mysql_query("DELETE FROM tblQMIG WHERE FirmID=" . $Prev_FirmID);
        mysql_query("INSERT INTO tblQMIG (FirmID, QuesNum, QuesAnswer) SELECT Prev_FirmID, QuesNum, QuesAnswer FROM ADec_QMIG WHERE Prev_FirmID=" . $Prev_FirmID);
        mysql_query("DELETE FROM tblMemberFirmsTransformation WHERE FirmID=" . $Prev_FirmID);
        mysql_query("INSERT INTO `tblMemberFirmsTransformation` (`FirmID`,
  `TransTopMA`,  `TransTopMC`,  `TransTopMI`,  `TransTopMW`,  `TransTopFA`,  `TransTopFC`,
  `TransTopFI`,  `TransTopFW`,  `TransTopMN`,  `TransTopFN`,  `TransSeniorMA`,  `TransSeniorMC`,
  `TransSeniorMI`,  `TransSeniorMW`,  `TransSeniorFA`,  `TransSeniorFC`,  `TransSeniorFI`,
  `TransSeniorFW`,  `TransSeniorMN`,  `TransSeniorFN`,  `TransProfMA`,  `TransProfMC`,
  `TransProfMI`,  `TransProfMW`,  `TransProfFA`,  `TransProfFC`,  `TransProfFI`,  `TransProfFW`,
  `TransProfMN`,  `TransProfFN`,  `TransSkilledMA`,  `TransSkilledMC`,  `TransSkilledMI`,
  `TransSkilledMW`,  `TransSkilledFA`,  `TransSkilledFC`,  `TransSkilledFI`, `TransSkilledFW`,
  `TransSkilledMN`,  `TransSkilledFN`,  `TransSemiMA`,  `TransSemiMC`,  `TransSemiMI`,
  `TransSemiMW`,  `TransSemiFA`,  `TransSemiFC`,  `TransSemiFI`,  `TransSemiFW`,  `TransSemiMN`,
  `TransSemiFN`,  `TransUnskillMA`,  `TransUnskillMC`,  `TransUnskillMI`,  `TransUnskillMW`,
  `TransUnskillFA`,  `TransUnskillFC`,  `TransUnskillFI`,  `TransUnskillFW`,  `TransUnskillMN`,
  `TransUnskillFN`,  `TransTempMA`,  `TransTempMC`,  `TransTempMI`,  `TransTempMW`,  `TransTempFA`,
  `TransTempFC`,  `TransTempFI`,  `TransTempFW`,  `TransTempMN`,  `TransTempFN`)
  SELECT `Prev_FirmID`,
  `TransTopMA`,  `TransTopMC`,  `TransTopMI`,  `TransTopMW`,  `TransTopFA`,  `TransTopFC`,
  `TransTopFI`,  `TransTopFW`,  `TransTopMN`,  `TransTopFN`,  `TransSeniorMA`,  `TransSeniorMC`,
  `TransSeniorMI`,  `TransSeniorMW`,  `TransSeniorFA`,  `TransSeniorFC`,  `TransSeniorFI`,
  `TransSeniorFW`,  `TransSeniorMN`,  `TransSeniorFN`,  `TransProfMA`,  `TransProfMC`,
  `TransProfMI`,  `TransProfMW`,  `TransProfFA`,  `TransProfFC`,  `TransProfFI`,  `TransProfFW`,
  `TransProfMN`,  `TransProfFN`,  `TransSkilledMA`,  `TransSkilledMC`,  `TransSkilledMI`,
  `TransSkilledMW`,  `TransSkilledFA`,  `TransSkilledFC`,  `TransSkilledFI`, `TransSkilledFW`,
  `TransSkilledMN`,  `TransSkilledFN`,  `TransSemiMA`,  `TransSemiMC`,  `TransSemiMI`,
  `TransSemiMW`,  `TransSemiFA`,  `TransSemiFC`,  `TransSemiFI`,  `TransSemiFW`,  `TransSemiMN`,
  `TransSemiFN`,  `TransUnskillMA`,  `TransUnskillMC`,  `TransUnskillMI`,  `TransUnskillMW`,
  `TransUnskillFA`,  `TransUnskillFC`,  `TransUnskillFI`,  `TransUnskillFW`,  `TransUnskillMN`,
  `TransUnskillFN`,  `TransTempMA`,  `TransTempMC`,  `TransTempMI`,  `TransTempMW`,  `TransTempFA`,
  `TransTempFC`,  `TransTempFI`,  `TransTempFW`,  `TransTempMN`,  `TransTempFN`
  FROM ADec_Transformation WHERE Prev_FirmID=" . $Prev_FirmID . " AND DeclarationYear = " . $currentYear);

mysql_query("DELETE FROM tblMemberFirmSkills WHERE FirmID=" . $Prev_FirmID);
        mysql_query("INSERT INTO tblMemberFirmSkills (FirmID, SkillsListID, EngineerName) 
                SELECT Prev_FirmID, SkillsListID, EngineerName 
                FROM ADec_tblMemberFirmSkills 
                WHERE Prev_FirmID=" . $Prev_FirmID . " AND DeclarationYear = $currentYear");

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

// ** TBLMEMBERFIRMS
    // **********************
    $Xquery = "SELECT FirmID, FirmName, PIUnderwriter, LevelOfCover, FormOfIncorporation, URL, QMSPlan, 
                QMSDocs, QMSISOComply, QMSISOCert, QMSISOCertDate, QMSOffices, QMSConsult, QMSCertBody, 
                MainFirmInvoice, GroupFirmsInvoice, MentoringProg, CandidateProg, SubscriptionsContact, 
                SubscriptionsEmail, HRTrainingContact, HRTrainingEmail, MarketingContact, MarketingEmail, 
                CAUSigned, BBBEE, SMME, BlackOwned, BlackWomenOwned, WomenOwned, YPFContact, YPFEmail, 
                ThreeYearsAverageTurnover, GoToPersonName, GoToPersonEmail, YPFContactTel
	        FROM tblMemberFirms WHERE FirmID = '$Prev_FirmID'";
    $Xresult = mysql_query($Xquery) or die("Select of id Failed");
    $ps = mysql_fetch_array($Xresult);

$MentoringProg = $ps['MentoringProg'];
    $CandidateProg = $ps['CandidateProg'];
    $SubscriptionsContact = $ps['SubscriptionsContact'];
    $SubscriptionsEmail = $ps['SubscriptionsEmail'];
    $HRTrainingContact = $ps['HRTrainingContact'];
    $HRTrainingEmail = $ps['HRTrainingEmail'];
    $MarketingContact = $ps['MarketingContact'];
    $MarketingEmail = $ps['MarketingEmail'];

$CAUSigned = $ps['CAUSigned'];
    $BBBEE = $ps['BBBEE'];
    $SMME = $ps['SMME'];
    $BlackOwned = $ps['BlackOwned'];
    $YPFContact = $ps['YPFContact'];
    $YPFEmail = $ps['YPFEmail'];

$sql = "SELECT * FROM tblMemberFirmSkills WHERE FirmID=" . $Prev_FirmID;
 $recSkills = mysql_query($sql);
 $arrFirmSkills = array();
 while ($rowSkills = mysql_fetch_array($recSkills)) {
 $arrFirmSkills[$rowSkills["SkillsListID"]] = $rowSkills["EngineerName"];
 }
 mysql_free_result($recSkills);
 ?>
 <table width="100%" border="0" cellspacing="0" cellpadding="0">
 <tr>
 <td bgcolor="#CCCCCC">
 <?php include('inc/menu.inc'); ?>
 </td>
 </tr>
 <tr>
 <td>
 <h3>
 Display Member Firm Details:
 
 <?php echo $rs['FirmName']; ?>
 </h3>
 <table width="100%" border="0" cellspacing="0" cellpadding="0">
 <tr>
 <td>
 
 Documents Completed
 <?php
 $Dquery = "SELECT DISTINCT RefDoc FROM ADec_Done WHERE RefID = '$FirmID' AND RefType = 'FirmID' AND RefDoc NOT IN ('UPDATED', 'DECLINED', 'DECLINE')";
 $Dresult = mysql_query($Dquery) or die("Select of id Failed");
 while ($ds = mysql_fetch_array($Dresult)) {
 echo " : " . $ds['RefDoc'] . " ";
 }
 $Dquery = "SELECT DISTINCT RefDoc FROM ADec_Done_Local WHERE RefID = '$FirmID' AND RefType = 'FirmID' AND RefDoc IN ('UPDATED', 'DECLINED', 'DECLINE')";
 $Dresult = mysql_query($Dquery) or die("Select of id Failed");
 while ($ds = mysql_fetch_array($Dresult)) {
 echo " : " . $ds['RefDoc'] . " ";
 }
 ?>
 
 
 
 </td>
 </tr>
 </table>

<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>
 <div align="right">
 <?php
 $NewFile = "ADdisplayMemberFirm.php";
 printf("<a href=\"%s?FirmID=%s&action=DECLINE\")'><img src=decline.jpg border=0>DECLINE</a>\n", $NewFile, $FirmID);
 ?>
 </div>
 </td>
 <td>
 <?php
 $NewFile = "ADdisplayMemberFirm.php";
 printf("<a href=\"%s?FirmID=%s&action=ACCEPT\")'><img src=accept.jpg border=0>ACCEPT</a>\n", $NewFile, $FirmID);
 ?>
 </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
 </td>
 <td width="38%" bgcolor="#0000FF">
 New
 ( completed:
 <?php echo $CompletedDate; ?>
 )
 
 </td>
 </tr>
 <tr>
 <td width="26%" bgcolor="#0000FF">
 FirmID
 </td>
 <td width="36%">
 <?php echo $ps['FirmID']; ?>
 </td>
 <td width="38%">
 <?php echo $rs['FirmID']; ?>
 </td>
 </tr>
 <tr>
 <td width="26%" bgcolor="#0000FF">
 Firm
 Name
 </td>
 <td width="36%">
 <?php echo $ps['FirmName']; ?>
 </td>
 <td width="38%">
 <?php echo $rs['FirmName']; ?>
 </td>
 </tr>
 <tr>
 <td width="26%" bgcolor="#0000FF">
 Name
 of insurer
 </td>
 <td width="36%">
 <?php echo $ps['PIUnderwriter']; ?>
 </td>
 <td width="38%">
 <?php echo $rs['PIUnderwriter']; ?>
 </td>
 </tr>
 <tr>
 <td width="26%" bgcolor="#0000FF">
 Amount
 of cover
 </td>
 <td width="36%">
 <?php echo $ps['LevelOfCover']; ?>
 </td>
 <td width="38%">
 <?php echo $rs['LevelOfCover']; ?>
 </td>
 </tr>
 <tr>
 <td width="26%" bgcolor="#0000FF">
 Form
 of the member firm
 </td>
 <td width="36%">
 <?php echo $ps['FormOfIncorporation']; ?>
 </td>
 <td width="38%">
 <?php echo $rs['FormOfIncorporation']; ?>
 </td>
 </tr>
 <tr>
 <td width="26%" bgcolor="#0000FF">
 www
 address
 </td>
 <td width="36%">
 <?php echo $ps['URL']; ?>
 </td>
 <td width="38%">
 <?php echo $rs['URL']; ?>
 </td>
 </tr>
 <tr>
 <td colspan="3" bgcolor="#0000FF">
 Quality
 Management 
 </td>
 </tr>
 
 <tr>
 <td width="26%" bgcolor="#0000FF">
 
 Has your firm implemented a Quality Management System?
 
 </td>
 <td width="36%">
 <?php
 switch ($ps['QMSISOComply']) {
 case "y":
 echo "Yes";
 break;
 case "n":
 echo "No";
 break;
 case "p":
 echo "In Progress";
 break;
 }
 ?>
 </td>
 <td width="38%">
 <?php
 switch ($rs['QMSISOComply']) {
 case "y":
 echo "Yes";
 break;
 case "n":
 echo "No";
 break;
 case "p":
 echo "In Progress";
 break;
 }
 ?>
 </td>
 </tr>
 
 <tr>
 <td width="26%" bgcolor="#0000FF">
 
 Is your QMS certified?
 
 </td>
 <td width="36%">
 <?php
 switch ($ps['QMSISOCert']) {
 case "y":
 echo "Yes";
 break;
 case "n":
 echo "No";
 break;
 case "p":
 echo "In Progress";
 break;
 }
 ?>
 </td>
 <td width="38%">
 <?php
 switch ($rs['QMSISOCert']) {
 case "y":
 echo "Yes";
 break;
 case "n":
 echo "No";
 break;
 case "p":
 echo "In Progress";
 break;
 }
 ?>
 </td>
 </tr>
 
 <tr>
 <td width="26%" bgcolor="#0000FF">
 If yes, by whom?
 </td>
 <td width="36%">
 <?php echo $ps['QMSCertBody']; ?>
 </td>
 <td width="38%">
 <?php echo $rs['QMSCertBody']; ?>
 </td>
 </tr>
 
 </tr>
 
 <tr>
 <td width="26%" bgcolor="#0000FF">
 
 Signed Commitment and Undertaking?
 
 </td>
 <td width="36%">
 <?php
 switch ($ps['CAUSigned']) {
 case "y":
 echo "Yes";
 break;
 case "n":
 echo "No";
 break;
 }
 ?>
 </td>
 <td width="38%">
 <?php
 switch ($rs['CAUSigned']) {
 case "y":
 echo "Yes";
 break;
 case "n":
 echo "No";
 break;
 }
 ?>
 </td>
 </tr>
 <tr>
 <td width="26%" bgcolor="#0000FF">
 
 BBBEE Level
 
 </td>
 <td width="36%">
 <?php echo $ps['BBBEE']; ?>
 </td>
 <td width="38%">
 <?php echo $rs['BBBEE']; ?>
 </td>
 </tr>
 <tr>
 <td width="26%" bgcolor="#0000FF">
 
 Revenue
 
 </td>
 <td width="36%">
 <?php echo $ps['SMME']; ?>
 </td>
 <td width="38%">
 <?php echo ADec_tblMemberFirms::getAnnualTurnoverValue($rs['SMME'], $rs['SMMEAmount']); ?>
 </td>
 </tr>
 <tr>
 <td width="26%" bgcolor="#0000FF">
 
 Black Ownership
 
 </td>
 <td width="36%">
 <?php echo $ps['BlackOwned']; ?>
 </td>
 <td width="38%">
 <?php echo $rs['BlackOwned']; ?>
 </td>
 </tr>
 <tr>
 <td width="26%" bgcolor="#0000FF">
 
 Black Women Ownership
 
 </td>
 <td width="36%">
 <?php echo $ps['BlackWomenOwned']; ?>
 </td>
 <td width="38%">
 <?php echo $rs['BlackWomenOwned']; ?>
 </td>
 </tr>
 <tr>
 <td width="26%" bgcolor="#0000FF">
 
 Women Ownership
 
 </td>
 <td width="36%">
 <?php echo $ps['WomenOwned']; ?>
 </td>
 <td width="38%">
 <?php echo $rs['WomenOwned']; ?>
 </td>
 </tr>
 <tr>
 <td width="26%" bgcolor="#0000FF">
 
 Turnover (3-Year Average)
 
 </td>
 <td width="36%">
 <?php echo $ps['ThreeYearsAverageTurnover']; ?>
 </td>
 <td width="38%">
 <?php echo $rs['ThreeYearsAverageTurnover']; ?>
 </td>
 </tr>
 <tr>
 <td width="26%" bgcolor="#0000FF">
 
 YPF contact
 
 </td>
 <td width="36%">
 <?php echo $ps['YPFContact']; ?> 
 <?php echo $ps['YPFEmail']; ?>
 </td>
 <td width="38%">
 <?php echo $rs['YPFContact']; ?> 
 <?php echo $rs['YPFEmail']; ?>
 </td>
 </tr>
 <tr>
 <td width="26%" bgcolor="#0000FF">
 
 Person responsible for subscriptions
 
 </td>
 <td width="36%">
 <?php echo $ps['SubscriptionsContact']; ?> 
 <?php echo $ps['SubscriptionsEmail']; ?>
 </td>
 <td width="38%">
 <?php echo $rs['SubscriptionsContact']; ?> 
 <?php echo $rs['SubscriptionsEmail']; ?>
 </td>
 </tr>
 <tr>
 <td width="26%" bgcolor="#0000FF">
 
 Person responsible for HR and training
 
 </td>
 <td width="36%">
 <?php echo $ps['HRTrainingContact']; ?> 
 <?php echo $ps['HRTrainingEmail']; ?>
 </td>
 <td width="38%">
 <?php echo $rs['HRTrainingContact']; ?> 
 <?php echo $rs['HRTrainingEmail']; ?>
 </td>
 </tr>
 <tr>
 <td width="26%" bgcolor="#0000FF">
 
 Person responsible for marketing
 
 </td>
 <td width="36%">
 <?php echo $ps['MarketingContact']; ?> 
 <?php echo $ps['MarketingEmail']; ?>
 </td>
 <td width="38%">
 <?php echo $rs['MarketingContact']; ?> 
 <?php echo $rs['MarketingEmail']; ?>
 </td>
 </tr>
 <tr>
 <td width="26%" bgcolor="#0000FF">
 
 Go to Person
 
 </td>
 <td width="36%">
 <?php echo $ps['GoToPersonName']; ?> 
 <?php echo $ps['GoToPersonEmail']; ?>
 </td>
 <td width="38%">
 <?php echo $rs['GoToPersonName']; ?> 
 <?php echo $rs['GoToPersonEmail']; ?>
 </td>
 </tr>
 <tr bgcolor="#0099FF">
 <td colspan="2">
 
 SKILLS (Schedule 2)
 
 </td>
 <td>
 <a href="ADdisplayMemberFirm.php?FirmID=<?php echo $FirmID; ?>&selectYear=<?php echo $currentYear; ?>&action=COPY_SKILLS">Copy skills from last year</a>
 </td>
 </tr>
 <?php

if ($_REQUEST['action'] == "COPY_SKILLS") {
 $memberFirmSkillObj = new ADec_tblMemberFirmSkills($sqlf);
 $memberFirmSkillObj->getOrCreate($FirmID, $Prev_FirmID, $currentYear);
 ?>
 <script language="javascript">
 window.location = 'ADdisplayMemberFirm.php?FirmID=<?php echo $FirmID; ?>&selectYear=<?php echo $currentYear; ?>';
 </script>
 <?php
 exit;
 }

$sql = "SELECT * FROM FirmSkillsList ORDER BY SkillPriority, SkillName";
 $recSkills = mysql_query($sql) or die("Select of Firm Skills List Failed");
 while ($rsSkills = mysql_fetch_array($recSkills)) {
 ?>
 <tr>

<td width="26%" bgcolor="#0099FF">
 
 <?php echo $rsSkills["SkillName"]; ?>
 
 </td>
 <td width="38%">
 <?php
 $checked = "";
 $ename = "";
 foreach ($arrFirmSkills as $key => $val) {
 if ($key == $rsSkills["SkillsListID"]) {
 $checked = "checked";
 $ename = " Name: " . $val;
 }
 }
 ?>
 <input type="checkbox" name="skills<?php echo $rsSkills["SkillsListID"]; ?>"
 value="1" <?php echo $checked; ?>><?php echo $ename; ?>
 <?php ?>
 </td>
 <td width="36%">
 <?php
 $nchecked = "";
 $nename = "";
 foreach ($arrFirmSkillsNew as $key => $val) {
 if ($key == $rsSkills["SkillsListID"]) {
 $nchecked = "checked";
 $nename = " Name: " . $val;
 }
 } //foreach
 ?>
 <input type="checkbox" name="newskills<?php echo $rsSkills["SkillsListID"]; ?>"
 value="1" <?php echo $nchecked; ?> /><?php echo $nename; ?>
 </td>
 </tr>
 <?php
 }
 ?>
 <tr bgcolor="#00CCFF">
 <td colspan="3">
 Firms to
 be treated as one (Schedule 1A)
 </td>
 </tr>
 <tr>
 <td width="26%" bgcolor="#00CCFF">
 Main
 firm to invoice
 </td>
 <td width="36%">
 <?php echo $ps['MainFirmInvoice']; ?>
 </td>
 <td width="36%">
 <?php echo $rs['MainFirmInvoice']; ?>
 </td>
 </tr>
 <tr>
 <td width="26%" bgcolor="#00CCFF">
 Group
 of firms to invoice
 </td>
 <td width="36%">
 <?php echo $ps['GroupFirmsInvoice']; ?>
 </td>
 <td width="36%">
 <?php echo $rs['GroupFirmsInvoice']; ?>
 </td>
 </tr>
 <tr>
 <td colspan="3">
 <div align="center">
 Click
 here to view all the
 <?php
 $NewFile = "ADdisplayOffices.php";
 printf("<a href=\"%s?FirmID=%s&selectYear=$currentYear\")'>OFFICES</a>\n", $NewFile, $FirmID);
 ?>
 for this Member Firm
 </div>
 </td>
 </tr>
 </table>
 <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>
 <div align="right">
 <?php
 $NewFile = "ADdisplayMemberFirm.php";
 printf("<a href=\"%s?FirmID=%s&action=DECLINE\")'><img src=decline.jpg border=0>DECLINE</a>\n", $NewFile, $FirmID);
 ?>
 </div>
 </td>
 <td>
 <?php
 $NewFile = "ADdisplayMemberFirm.php";
 printf("<a href=\"%s?FirmID=%s&action=ACCEPT\")'><img src=accept.jpg border=0>ACCEPT</a>\n", $NewFile, $FirmID);
 ?>
 </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>
<?php