Gecko [ v3.cesa.co.za ]

Name	Size	Permission	Date
adobe.inc	107 B	-rw-r--r--	2008-01-09 07:51
auth.inc	3.52 KB	-rw-r--r--	2025-04-30 14:24
auth.inc.bak	1.12 KB	-rw-r--r--	2025-03-07 12:21
calendar.inc	5.46 KB	-rw-r--r--	2008-01-09 08:36
conf.inc	683 B	-rw-r--r--	2025-03-07 12:21
conf.inc.bak	690 B	-rw-r--r--	2025-03-07 12:21
confdec.inc	364 B	-rw-r--r--	2025-03-07 12:21
createadec.inc	175 B	-rw-r--r--	2008-01-09 07:51
db.inc	146 B	-rw-r--r--	2025-03-07 12:21
declaration.inc	19.69 KB	-rw-r--r--	2026-01-20 15:55
declaration_nav.php	4.76 KB	-rw-r--r--	2025-02-20 10:14
declaration_nav.php4	4.69 KB	-rw-r--r--	2008-01-09 08:36
declaration_nav_int.php	5.87 KB	-rw-r--r--	2021-02-24 09:22
declaration_nav_int.php4	5.96 KB	-rw-r--r--	2015-01-22 06:13
default.css	4.06 KB	-rw-r--r--	2008-01-09 07:51
dont-click.prefs.inc	3.38 KB	-rw-r--r--	2008-01-09 08:36
footer.inc	3.13 KB	-rw-r--r--	2025-05-19 11:13
footer2.inc	157 B	-rw-r--r--	2008-01-09 07:51
func.inc	3.36 KB	-rw-r--r--	2025-01-13 14:32
funcinternational.inc	2.66 KB	-rw-r--r--	2008-01-09 07:51
header.inc	4.12 KB	-rw-r--r--	2025-01-31 07:03
header2.inc	2.05 KB	-rw-r--r--	2008-01-09 08:36
internationalheader.inc	590 B	-rw-r--r--	2008-01-09 07:51
internationalmenu.inc	378 B	-rw-r--r--	2008-01-09 07:51
login_footer.inc	748 B	-rw-r--r--	2008-01-09 07:51
login_header.inc	1.43 KB	-rw-r--r--	2008-01-09 07:51
misc.inc	363 B	-rw-r--r--	2008-01-09 07:51
nav.inc	528 B	-rw-r--r--	2008-01-09 07:51
notice.inc	530 B	-rw-r--r--	2008-01-09 08:36
press.inc	1.53 KB	-rw-r--r--	2008-01-09 08:36
rc4cryptclass.inc	1.27 KB	-rw-r--r--	2008-01-09 07:51
readnext.inc	8.77 KB	-rw-r--r--	2025-03-07 12:21
readnext.inc.bak	6.8 KB	-rw-r--r--	2025-03-07 12:21
readnextold.inc	6.64 KB	-rw-r--r--	2025-03-07 12:21
sched1page2gen.inc	7.65 KB	-rw-r--r--	2025-07-18 08:31
submitcheck.inc	23.74 KB	-rw-r--r--	2025-07-18 09:41
submitcheck.inc.bak	6.28 KB	-rw-r--r--	2025-03-07 12:21
submitcheck2.inc	13.04 KB	-rw-r--r--	2025-07-18 07:32
submitcheck2_A.inc	18.75 KB	-rw-r--r--	2025-07-18 07:47
submitcheck2b.inc	11 KB	-rw-r--r--	2025-07-18 07:47
submitcheck2b_A.inc	14.9 KB	-rw-r--r--	2025-03-07 12:21
submitcheckA.inc	21.38 KB	-rw-r--r--	2025-07-18 07:20
submitcheckqmig.inc	1.35 KB	-rw-r--r--	2025-03-07 12:21
survey_footer.inc	2.35 KB	-rw-r--r--	2008-01-09 07:51
test.html	11.56 KB	-rw-r--r--	2008-01-09 07:51
viewcal.inc	2.33 KB	-rw-r--r--	2008-01-09 08:36
voting_class.inc	11.04 KB	-rw-r--r--	2025-03-07 12:21
work.inc	1.26 KB	-rw-r--r--	2008-01-09 08:36

Rename

<?php
// **** All the variables for the reading of the information of the Annual Declaration
include_once($_SERVER['DOCUMENT_ROOT'] . '/cfg/config.php');

$host = EW_CONN_HOST;
$user = EW_CONN_USER;
$password = EW_CONN_PASS;
$db = EW_CONN_DB;
    mysql_connect("$host","$user","$password") or die("Unable to connect to SQL server");
    mysql_select_db("$db") or die("Unable to select database");
	
// **** Check the fields to see if they were completed correctly

var_dump($_REQUEST);
var_dump($form);

if (empty($_REQUEST["form[firmname]"])) 
{ $errorcondition = "no"; }
else
{ 
$errorcondition = "yes";
$ErrorReport = "ERROR !!! : Please complete the field FIRM NAME.";
}
if ($errorcondition == "no")
{
if ($form[name]) 
{ $errorcondition = "no"; }
else
{ 
$errorcondition = "yes";
$ErrorReport = "ERROR !!! : Please complete the field NAME OF INSURER.";
}
}
if ($errorcondition == "no")
{
if ($form[amount]) 
{ $errorcondition = "no"; }
else
{ 
$errorcondition = "yes";
$ErrorReport = "ERROR !!! : Please complete the field AMOUNT OF COVER.";
}
}
$boxselected = 0 ;
if ($box[1]) { $boxselected = $boxselected + 1; }
if ($box[2]) { $boxselected = $boxselected + 1; }
if ($box[3]) { $boxselected = $boxselected + 1; }
if ($box[4]) { $boxselected = $boxselected + 1; }
if ($box[5]) { $boxselected = $boxselected + 1; }
if ($box[6]) { $boxselected = $boxselected + 1; }

if ($errorcondition == "no")
{
if ($boxselected > 1)
{
$errorcondition = "yes";
$ErrorReport = "ERROR !!! : Please select only ONE form of the Member Firm.";
}
else
{ $errorcondition = "no"; }
}
if ($errorcondition == "no")
{
if ($boxselected == 0)
{ 
$errorcondition = "yes";
$ErrorReport = "ERROR !!! : Please select at least ONE form of the Member Firm.";
}
else
{ $errorcondition = "no"; }
}
if ($errorcondition == "no")
{
if ($form[q3]) 
{ $errorcondition = "no"; }
else
{ 
$errorcondition = "yes";
$ErrorReport = "ERROR !!! : Please complete the field Quality Management System Question 1.";
}
}
if ($errorcondition == "no")
{
if ($form[q4]) 
{ $errorcondition = "no"; }
else
{ 
$errorcondition = "yes";
$ErrorReport = "ERROR !!! : Please complete the field Quality Management System Question 2(a).";
}
}
if ($errorcondition == "no")
{
if ($form[firstname]) 
{ $errorcondition = "no"; }
else
{ 
$errorcondition = "yes";
$ErrorReport = "ERROR !!! : Please complete the field FIRST NAME OF MANDATED PRINCIPLE.";
}
}
if ($errorcondition == "no")
{
if ($form[lastname]) 
{ $errorcondition = "no"; }
else
{ 
$errorcondition = "Yes";
$ErrorReport = "ERROR !!! : Please complete the field LAST NAME OF MANDATED PRINCIPLE.";
}
}
if ($errorcondition == "no")
{
if ($form[date]) 
{ 
	if (strtotime($form[date]) != -1) {
		$errorcondition = "no"; 
	} else {
		$errorcondition = "yes";
		$ErrorReport = "ERROR !!! : Please provide a valid date for: DATE DOCUMENT COMPLETED.";
	}		
}
else
{ 
$errorcondition = "yes";
$ErrorReport = "ERROR !!! : Please complete the field DATE DOCUMENT COMPLETED.";
}
}
// **** Set the values to put in the type of incorporation field
		 if ($box[1])
		 {
			 $form[incorp] = "Sole Practice";			 
			 }
		 if ($box[2])
		 {
			 $form[incorp] = "Limited Company";			 
			 }
		 if ($box[3])
		 {
			 $form[incorp] = "Partnership";			 
			 }
		 if ($box[4])
		 {
			 $form[incorp] = "(Pty) Ltd";			 
			 }
		 if ($box[5])
		 {
			 $form[incorp] = "Close Corporation";
			 }
 if ($box[6])
		 {
			 $form[incorp] = $form[other];
			 }
if ($errorcondition == "no")
{
// Update the MemberFirms table
if ($form[partydate]."" > "") {
	$QMSISOCertDate = date('Y-m-d', strtotime($form[partydate]));
} else {
	$QMSISOCertDate = "";
}
$DeclarationReceived = date('Y-m-d', strtotime($form[date]));

$levelofcover = $form[amount];
if (!empty($levelofcover)) $levelofcover = preg_replace("[^0-9]", "", $levelofcover);

$MentoringProg = "n";
if (isset($form[MentoringProg]) && ($form[MentoringProg]=="y")) $MentoringProg = "y";

$CandidateProg = "n";
if (isset($form[CandidateProg]) && ($form[CandidateProg]=="y")) $CandidateProg = "y";

$query = "UPDATE ADec_tblMemberFirms SET FirmName = '$form[firmname]', FormOfIncorporation = '$form[incorp]', PIUnderwriter = '$form[name]', LevelOfCover = '$levelofcover', URL='$form[www]'
, QMSISOComply='$form[q3]', QMSISOCert='$form[q4]', QMSCertBody='$form[q7]'
, DeclarationReceived = '$DeclarationReceived'
, MentoringProg='$MentoringProg', CandidateProg='$CandidateProg', 
	SubscriptionsContact='$form[SubscriptionsContact]', SubscriptionsEmail='$form[SubscriptionsEmail]', 
	HRTrainingContact='$form[HRTrainingContact]', HRTrainingEmail='$form[HRTrainingEmail]', 
	MarketingContact='$form[MarketingContact]', MarketingEmail='$form[MarketingEmail]'
WHERE Prev_FirmID='$MemberFirmID'";
$result = mysql_query($query) or die("Update of ADec_tblMemberFirms Failed");

// Update the Mandated Principal
$query = "UPDATE ADec_Contacts SET ContactSurname = '$form[lastname]', ContactFirstName = '$form[firstname]'
, ContactDesignation = '$form[designate]' WHERE Prev_ContactsID = '$MemberContactID'";
//$result = mysql_query($query) or die("ADec_Contacts Insert Failed");

$query101 = "UPDATE ADec_tblMemberFirms SET ADecStatus='U' WHERE Prev_FirmID = '$MemberFirmID'";
$Hresult = mysql_query($query101) or die("Update failed");

$query = "SELECT  FirmID, Prev_FirmID FROM ADec_tblMemberFirms WHERE Prev_FirmID = '$MemberFirmID'";
$Hresult = mysql_query($query) or die("Select failed");
$Hrow = mysql_fetch_array($Hresult);
$Hf[1] = $Hrow['FirmID'];
$reftype = "FirmID";
$refdoc = "AnnualDeclaration";
$adecdate = date("Y-m-d H:i");
$query = "INSERT INTO ADec_Done (RefID,RefType,RefDoc,ADecDate) 
values('$Hf[1]','$reftype','$refdoc','$adecdate')";
$Jresult = mysql_query($query) or die("Insert Failed");
	
$NextSection = "complete";
}	
else
{
$NextSection = "notcomplete";
}
// **** End of the Page
?>