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

<title>Submit Check 2b_A: Schedule One B</title>
<div align="center">
 <?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");

include( '../inc/conf.inc' );

// **** Check to see if the update has been performed.
 $query = "SELECT * FROM ADec_tblMemberFirmOffices WHERE ADec_tblMemberFirmOffices.Prev_OfficeID = '$SelectOfficeID' AND DeclarationYear = $DeclarationYear";
 $result = mysql_query($query) or die("Select of id Failed");
 $row = mysql_fetch_array($result);
 if ($row) {
 $ErrorReport = "U het reeds die dokument voltooi.";
 $NextSection = "complete";
 } else {
// **** Test data is set up and used here.. ****
//	echo " The information is as follows. 1: ".$selected1." 2: ".$selected2." 3: ".$selected3." 4: ".$selected4." form select: ".$form[select]." form choice: ".$form[choice];
// echo " Firm Name: ".$form[nameoffirm];
// echo " Just another test item. ";
// **** Check the fields to see if they were completed correctly
 if ($form[nameoffirm]) {
 $errorcondition = "no";
 } else {
 $errorcondition = "yes";
 $ErrorReport = "FOUT !!! : Voltooi ASB die veld NAAM VAN FIRMA.";
 }
 if ($errorcondition == "no") {
 if ($form[officestreet]) {
 $errorcondition = "no";
 } else {
 $errorcondition = "yes";
 $ErrorReport = "FOUT !!! : Voltooi ASB die veld STRAATADRES: STRAAT.";
 }
 }
 if ($errorcondition == "no") {
 if ($form[officesuburb]) {
 $errorcondition = "no";
 } else {
 $errorcondition = "yes";
 $ErrorReport = "FOUT !!! : Voltooi ASB die veld STRAATADRES: VOORSTAD.";
 }
 }
 if ($errorcondition == "no") {
 if ($form[officecity]) {
 $errorcondition = "no";
 } else {
 $errorcondition = "yes";
 $ErrorReport = "FOUT !!! : Voltooi ASB die veld STRAATADRES: STAD.";
 }
 }
 if ($errorcondition == "no") {
 if ($form[officeprovince]) {
 $errorcondition = "no";
 } else {
 $errorcondition = "yes";
 $ErrorReport = "FOUT !!! : Voltooi ASB die veld STRAATADRES: PROVINSIE.";
 }
 }
 if ($errorcondition == "no") {
 if ($form[country]) {
 $errorcondition = "no";
 } else {
 $errorcondition = "yes";
 $ErrorReport = "FOUT !!! : Voltooi ASB die veld STRAATADRES: LAND.";
 }
 }
 if ($errorcondition == "no") {
 if ($form[pobox]) {
 $errorcondition = "no";
 } else {
 $errorcondition = "yes";
 $ErrorReport = "FOUT !!! : Voltooi ASB die veld POSADRES: .";
 }
 }
 if ($errorcondition == "no") {
 if ($form[towncity]) {
 $errorcondition = "no";
 } else {
 $errorcondition = "yes";
 $ErrorReport = "FOUT !!! : Voltooi ASB die veld POSADRES: STAD.";
 }
 }
 if ($errorcondition == "no") {
 if ($form[code]) {
 $errorcondition = "no";
 } else {
 $errorcondition = "yes";
 $ErrorReport = "FOUT !!! : Voltooi ASB die veld POSADRES: KODE.";
 }
 }
 if ($errorcondition == "no") {
 if ($form[tel]) {
 $errorcondition = "no";
 } else {
 $errorcondition = "Yes";
 $ErrorReport = "FOUT !!! : Voltooi ASB die veld TELEFOONNO: .";
 }
 }
 if ($errorcondition == "no") {
 if ($form[fax]) {
 $errorcondition = "no";
 } else {
 $errorcondition = "yes";
 $ErrorReport = "FOUT !!! : Voltooi ASB die veld FAKSNO: .";
 }
 }

if ($errorcondition == "no") {
 if ($form[email]) {
 $errorcondition = "no";
 } else {
 $errorcondition = "yes";
 $ErrorReport = "FOUT !!! : Voltooi ASB die veld E-POS: .";
 }
 }
 if ($errorcondition == "no") {
 if ($form[hrname]) {
 $errorcondition = "no";
 } else {
 $errorcondition = "yes";
 $ErrorReport = "FOUT !!! : Voltooi ASB die veld MENSLIKE HULPBRONE PERSOON: NAAM.";
 }
 }
 if ($errorcondition == "no") {
 if ($form[hrmail]) {
 $errorcondition = "no";
 } else {
 $errorcondition = "yes";
 $ErrorReport = "FOUT !!! : Voltooi ASB die veld MENSLIKE HULPBRONE PERSOON: E-POS.";
 }
 }
 if ($errorcondition == "no") {
// **** Update the Tables.
// **** Fetch the Details of the TBLMEMBERFIRMOFFICES table and write to ADEC_TBLMEMBERFIRMOFFICES
 $query = "SELECT FirmID, Prev_FirmID FROM ADec_tblMemberFirms WHERE ADec_tblMemberFirms.Prev_FirmID = '$MemberFirmID' AND DeclarationYear = $DeclarationYear";
 $result = mysql_query($query) or die("Select failed");
 $RCrow = mysql_fetch_array($result);
 $rcr[1] = $RCrow['FirmID'];

$query = "SELECT * FROM tblMemberFirmOffices WHERE tblMemberFirmOffices.OfficeID = '$SelectOfficeID' AND DeclarationYear = $DeclarationYear";
            $result = mysql_query($query) or die("Select failed");
            $OCrow = mysql_fetch_array($result);
            $ocr[1] = $SelectOfficeID;
            $ocr[2] = $rcr[1];
            $ocr[3] = $MemberFirmID;
            $ocr[4] = $OCrow['FullOrPartTime'];
            $ocr[22] = $OCrow['OfficeStatus'];
            if ($form[country]) {
                $ocr[5] = $form[country];
            } else {
                $ocr[5] = $OCrow['Country'];
            }
            $ocr[6] = $OCrow['Old_PrincipalPrEng'];
            $ocr[7] = $OCrow['Old_PrincipalPrTech'];
            $ocr[8] = $OCrow['Old_PrincipalOther'];
            $ocr[9] = $OCrow['Old_TechPersonnel'];
            $ocr[10] = $OCrow['Old_OtherPersonnel'];
            $ocr[11] = $OCrow['BulletinCopies'];
            $ocr[12] = $OCrow['SaaceBranch'];
            $ocr[13] = $OCrow['ProfessionalStaff'];
            $ocr[14] = $OCrow['NonProfTechStaff'];
            $ocr[15] = $OCrow['OtherStaff'];
            $form[timeupdate] = date("Y-m-d H:i");
            $ocr[16] = $OCrow['LNumber'];
            $ocr[17] = $OCrow['Language'];
            $ocr[18] = $OCrow['GeoLocationLocal'];
            $ocr[19] = $OCrow['GeoLocationDistrict'];
            if ($form[hrname]) {
                $ocr[20] = $form[hrname];
            } else {
                $ocr[20] = $OCrow['HRName'];
            }
            if ($form[hrmail]) {
                $ocr[21] = $form[hrmail];
            } else {
                $ocr[21] = $OCrow['HREmail'];
            }
            $ocr[22] = $OCrow['HoldingCompany'];

$query = "INSERT INTO ADec_tblMemberFirmOffices (Prev_OfficeID,
FirmID,
Prev_FirmID,
OfficeName,
OfficeStatus,
FullOrPartTime,
Language,
PostalAddress,
Address2,
TownCity,
Country,
PostalCode,
BldgName,
StreetName,
Suburb,
Telephone,
Fax,
Email,
Old_PrincipalPrEng,
Old_PrincipalPrTech,
Old_PrincipalOther,
Old_TechPersonnel,
Old_OtherPersonnel,
BulletinCopies,
Province,
SaaceBranch,
GeoLocation,
ProfessionalStaff,
NonProfTechStaff,
OtherStaff,
TimeUpdate,
GeoLocationLocal,
GeoLocationDistrict,
LNumber,
HoldingCompany,
HRName,
HREmail,
Fidic, DeclarationYear)
values('$ocr[1]'
,'$ocr[2]'
,'$ocr[3]'
,'$form[nameoffirm]'
,'$ocr[22]'
,'$ocr[4]'
,'$ocr[17]'
,'$form[pobox]'
,'$form[poextend]'
,'$form[towncity]'
,'$ocr[5]'
,'$form[code]'
,'$form[officebuilding]'
,'$form[officestreet]'
,'$form[officesuburb]'
,'$form[tel]'
,'$form[fax]'
,'$form[email]'
,'$ocr[6]'
,'$ocr[7]'
,'$ocr[8]'
,'$ocr[9]'
,'$ocr[10]'
,'$ocr[11]'
,'$form[officeprovince]'
,'$ocr[12]'
,'$form[officecity]'
,'$ocr[13]'
,'$ocr[14]'
,'$ocr[15]'
,'$form[timeupdate]'
,'$ocr[18]'
,'$ocr[19]'
,'$ocr[16]'
,'$ocr[22]'
,'$ocr[20]'
,'$ocr[21]'
,'$form[fidic]', $DeclarationYear)";

// echo 'Please ignore debug info: submit check 2 b A inc ' . $query . ' ';

$result = mysql_query($query) or die("Insert Failed");

if ($form[nam] || $form[sur]) {
// **** Fetch the Details of the OFFICECONTACTS, CONTACTS table and write to ADEC_CONTACTS, ADEC_OFFICECONTACTS
                $query = "SELECT * FROM ADec_tblMemberFirmOffices WHERE ADec_tblMemberFirmOffices.Prev_OfficeID = '$SelectOfficeID' AND DeclarationYear = $DeclarationYear";
                $result = mysql_query($query) or die("Select failed");
                $RCrow = mysql_fetch_array($result);
                $rcr[1] = $RCrow['OfficeID'];

$query = "SELECT  * FROM OfficeContacts WHERE (OfficeContacts.ContactsID = '$OfficeID') AND (OfficeContacts.OfficeHead = 1)";
                $result = mysql_query($query) or die("Select failed");
                $CCrow = mysql_fetch_array($result);
                $ccs[1] = $HeadOfficeID;
                $ccs[2] = $CCrow['ContactPosition'];
                $ccs[3] = $CCrow['MandatedPrincipal'];
                $ccs[4] = "1";
                $ccs[5] = $rcr[1];
                $ccs[6] = $SelectOfficeID;
                $ccs[7] = $CCrow['Principal'];
                $ccs[8] = $CCrow['Email'];
                $ccs[9] = $CCrow['Mail'];

$query = "SELECT  * FROM Contacts WHERE Contacts.ContactsID = '$HeadOfficeID'";
                $result = mysql_query($query) or die("Select failed");
                $OCrow = mysql_fetch_array($result);
                $ocs[1] = $OCrow['ContactsID'];
                $ocs[2] = $OCrow['ContactInitials'];
                $ocs[3] = $OCrow['Language'];
                $ocs[4] = $OCrow['BirthDate'];
                $ocs[5] = $OCrow['NameOfSpouse'];
                $ocs[6] = $OCrow['CellPhone'];
                $ocs[8] = $OCrow['PersonalTel'];
                $ocs[9] = $OCrow['PersonalFax'];
                $ocs[10] = $OCrow['Comments'];
                $ocs[13] = $CCrow['ContactID'];
                $ocs[14] = $OCrow['ContactID'];
                $ocs[15] = $OCrow['PreferredEmail'];
                $ocs[16] = $OCrow['ContactType'];
                $ocs[17] = $OCrow['UniqueCode'];
                $ocs[18] = $OCrow['PostalAddress'];
                $ocs[19] = $OCrow['Address2'];
                $ocs[20] = $OCrow['TownCity'];
                $ocs[21] = $OCrow['Country'];
                $ocs[22] = $OCrow['PostalCode'];
                $ocs[23] = $OCrow['OrgName'];
                $ocs[24] = $OCrow['DocumentAccess'];

$query222 = "SELECT ContactsID, Prev_ContactsID FROM ADec_Contacts WHERE Contacts.Prev_ContactsID = '$ocs[1]' AND DeclarationYear = $DeclarationYear";
                $result222 = mysql_query($query222) or die("Select failed");
                if ($row222 = mysql_fetch_array($result222)) {
// perform a update of the office id
                    $Id = $row222['ContactsID'];

$sql = "UPDATE ADec_OfficeContacts SET OfficeID = '$rcr[1]' WHERE ContactsID = '$Id'";
                    $result333 = mysql_query($sql);
                } else {

$query = "INSERT INTO ADec_Contacts (Prev_ContactsID, ContactSurname, ContactInitials, ContactFirstName, ContactDesignation, Language, BirthDate, NameOfSpouse, CellPhone, PersonalTel,
    PersonalFax, Comments, ProfessionalRegistrations, Qualifications, ContactID, Prev_ContactID, PreferredEmail, ContactType, UniqueCode, PostalAddress, Address2, TownCity, Country,
    PostalCode, OrgName, DocumentAccess, DeclarationYear)
values('$ocs[1]'
,'$form[lastname]'
,'$ocs[2]'
,'$form[firstname]'
,'$form[designate]'
,'$ocs[3]'
,'$ocs[4]'
,'$ocs[5]'
,'$ocs[6]'
,'$ocs[8]'
,'$ocs[9]'
,'$ocs[10]'
,'$form[regis]'
,'$form[qual]'
,'$ocs[13]'
,'$ocs[14]'
,'$ocs[15]'
,'$ocs[16]'
,'$ocs[17]'
,'$ocs[18]'
,'$ocs[19]'
,'$ocs[20]'
,'$ocs[21]'
,'$ocs[22]'
,'$ocs[23]'
,'$ocs[24]', $DeclarationYear)";
                    $result = mysql_query($query) or die("Insert Failed");

// get the newly created field
                    $query = "SELECT  * FROM ADec_Contacts WHERE ADec_Contacts.Prev_ContactsID = '$HeadOfficeID' AND DeclarationYear = $DeclarationYear";
                    $result = mysql_query($query) or die("Select failed");
                    $JCrow = mysql_fetch_array($result);
                    $rcrs[1] = $JCrow['ContactsID'];

$query = "INSERT INTO ADec_OfficeContacts (ContactsID,
Prev_ContactsID,
ContactPosition,
MandatedPrincipal,
OfficeHead,
OfficeID,
Prev_OfficeID,
Principal,
Email,
Mail, DeclarationYear) values('$rcrs[1]',
'$ccs[1]',
'$ccs[2]',
'$ccs[3]',
'$ccs[4]',
'$ccs[5]',
'$ccs[6]',
'$ccs[7]',
'$ccs[8]',
'$ccs[9]', $DeclarationYear)";
                    $result = mysql_query($query) or die("Insert Failed");
                }
            }

$query101 = "SELECT OfficeID, Prev_OfficeID FROM ADec_tblMemberFirmOffices WHERE Prev_OfficeID = '$SelectOfficeID' AND DeclarationYear = $DeclarationYear";
            $Hresult = mysql_query($query101) or die("Select failed");
            $Hrow = mysql_fetch_array($Hresult);
            $Hf[1] = $Hrow['OfficeID'];
            $reftype = "OfficeID";
            $refdoc = "Schedule1B";
            $adecdate = date("Y-m-d H:i");
            $query102 = "INSERT INTO ADec_Done (RefID,RefType,RefDoc,ADecDate)
  values('$Hf[1]','$reftype','$refdoc','$adecdate')";
            $Jresult = mysql_query($query102) or die("Insert Failed");

$ErrorReport = "Dankie dat U die seksie voltooi het.";
 $NextSection = "complete";
 } else {
 $NextSection = "notcomplete";
 }
 }
// **** End of the Page
 ?>
</div>