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: 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;
 if (!($link = mysql_connect("$host", "$user", "$password"))) {
 throw new Exception("Unable to connect to SQL server");
 }
 if (!($result = mysql_select_db("$db"))) {
 throw new Exception("Unable to select database");
 }

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

// **** Check the fields to see if they were completed correctly
 if ($form['nameoffirm']) {
 $errorcondition = "no";
 } else {
 $errorcondition = "yes";
 $ErrorReport = "ERROR !!! : Please complete the field NAME OF FIRM.";
 }
 if ($errorcondition == "no") {
 if ($form['officestreet']) {
 $errorcondition = "no";
 } else {
 $errorcondition = "yes";
 $ErrorReport = "ERROR !!! : Please complete the field PHYSICAL ADDRESS: STREET.";
 }
 }
 if ($errorcondition == "no") {
 if ($form['officesuburb']) {
 $errorcondition = "no";
 } else {
 $errorcondition = "yes";
 $ErrorReport = "ERROR !!! : Please complete the field PHYSICAL ADDRESS: SUBURB.";
 }
 }
 if ($errorcondition == "no") {
 if ($form['officecity']) {
 $errorcondition = "no";
 } else {
 $errorcondition = "yes";
 $ErrorReport = "ERROR !!! : Please complete the field PHYSICAL ADDRESS: CITY.";
 }
 }
 if ($errorcondition == "no") {
 if ($form['country']) {
 $errorcondition = "no";
 } else {
 $errorcondition = "yes";
 $ErrorReport = "ERROR !!! : Please complete the field PHYSICAL ADDRESS: COUNTRY.";
 }
 }
 if ($errorcondition == "no") {
 if ($form['pobox']) {
 $errorcondition = "no";
 } else {
 $errorcondition = "yes";
 $ErrorReport = "ERROR !!! : Please complete the field POSTAL ADDRESS: .";
 }
 }
 if ($errorcondition == "no") {
 if ($form['towncity']) {
 $errorcondition = "no";
 } else {
 $errorcondition = "yes";
 $ErrorReport = "ERROR !!! : Please complete the field POSTAL ADDRESS: TOWN/CITY.";
 }
 }
 if ($errorcondition == "no") {
 if ($form['code']) {
 $errorcondition = "no";
 } else {
 $errorcondition = "yes";
 $ErrorReport = "ERROR !!! : Please complete the field POSTAL ADDRESS: CODE.";
 }
 }
 if ($errorcondition == "no") {
 if ($form['tel']) {
 $errorcondition = "no";
 } else {
 $errorcondition = "Yes";
 $ErrorReport = "ERROR !!! : Please complete the field TELEPHONE NR.";
 }
 }
 if ($errorcondition == "no") {
 if ($form['fax']) {
 $errorcondition = "no";
 } else {
 $errorcondition = "yes";
 $ErrorReport = "ERROR !!! : Please complete the field FAX NR.";
 }
 }

if ($errorcondition == "no") {
 if ($form['email']) {
 $errorcondition = "no";
 } else {
 $errorcondition = "yes";
 $ErrorReport = "ERROR !!! : Please complete the field EMAIL.";
 }
 }
//if ($errorcondition == "no")
//{
//if ($form['hrname'])
//{ $errorcondition = "no"; }
//else
//{
//$errorcondition = "yes";
//$ErrorReport = "ERROR !!! : Please complete the field HR RESPONSIBLE PERSON: NAME.";
//}
//}
//if ($errorcondition == "no")
//{
//if ($form['hrmail'])
//{ $errorcondition = "no"; }
//else
//{
//$errorcondition = "yes";
//$ErrorReport = "ERROR !!! : Please complete the field HR RESPONSIBLE PERSON: EMAIL.";
//}
//}
 if ($errorcondition == "no") {
// **** Update the Tables.
// check if deleted
 if ($form['deleteoffice'] . "" == "ON") {
 if (!strstr($form['nameoffirm'], "- *** DELETED ***")) {
 $form['nameoffirm'] .= "- *** DELETED ***";
 }
 }

// check if undeleted
        if ($form['deleteoffice'] . "" != "ON") {
            if (strstr($form['nameoffirm'], "- *** DELETED ***")) {
                $form['nameoffirm'] = str_replace("- *** DELETED ***", "", $form['nameoffirm']);
            }
        }

// **** 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";
        if (!($result = mysql_query($query))) {
            throw new Exception("Select failed: " . $query);
        }
        $RCrow = mysql_fetch_array($result);
        $rcr[1] = $RCrow['FirmID'];

// **** Insert a new office, if necessary
 if ($AddNewOffice == 'yes') {
 $query = "INSERT INTO ADec_tblMemberFirmOffices (FirmID, Prev_FirmID, SaaceBranch, DeclarationYear) 
 VALUES ($rcr[1],$MemberFirmID, 'International', $DeclarationYear)";
 // echo 'Please ignore debug info: submit check 2b inc ' . $query . ' ';
 if (!($result = mysql_query($query))) {
 throw new Exception("Insert office failed submitcheck2b: " . $query);
 }
 $SelectOfficeID = mysql_insert_id();
 }

$query = "SELECT OfficeID, Prev_OfficeID FROM ADec_tblMemberFirmOffices WHERE OfficeID = '$SelectOfficeID'";
        if (!($Hresult = mysql_query($query))) {
            throw new Exception("Select failed: " . $query);
        }
        $Hrow = mysql_fetch_array($Hresult);
        $Hf[1] = $Hrow['Prev_OfficeID'];

$query = "UPDATE ADec_tblMemberFirmOffices 
            SET 
                OfficeName='" . mysqli_real_escape_string($conni, $form['nameoffirm']) . "', 
                PostalAddress='" . mysqli_real_escape_string($conni, $form['pobox']) . "', 
                Address2='" . mysqli_real_escape_string($conni, $form['poextend']) . "', 
                TownCity='" . mysqli_real_escape_string($conni, $form['towncity']) . "', 
                PostalCode='" . mysqli_real_escape_string($conni, $form['code']) . "', 
                BldgName = '" . mysqli_real_escape_string($conni, $form['officebuilding']) . "', 
                StreetName='" . mysqli_real_escape_string($conni, $form['officestreet']) . "', 
                Suburb='" . mysqli_real_escape_string($conni, $form['officesuburb']) . "', 
                Telephone='" . mysqli_real_escape_string($conni, $form['tel']) . "', 
                Fax='" . mysqli_real_escape_string($conni, $form['fax']) . "', 
                Email='" . mysqli_real_escape_string($conni, $form['email']) . "', 
                Province='" . mysqli_real_escape_string($conni, $form['officeprovince']) . "', 
                GeoLocation='" . mysqli_real_escape_string($conni, $form['officecity']) . "', 
                Country='" . mysqli_real_escape_string($conni, $form['country']) . "', 
                TimeUpdate='" . date("Y-m-d H:i") . "', 
                HRName='" . mysqli_real_escape_string($conni, $form['hrname']) . "', 
                HREmail='" . mysqli_real_escape_string($conni, $form['hrmail']) . "', 
                Fidic='" . mysqli_real_escape_string($conni, $select['fidic']) . "', 
                DeclarationYear = $DeclarationYear 
            WHERE OfficeID='$SelectOfficeID'";
//$escapedQuery = str_replace("\'","''",$query);
        if (!($result = mysql_query($query))) {
            throw new Exception("Update ADec_tblMemberFirmOffices Failed submitcheck2b: " . $query);
        }

if ($form['nam'] || $form['sur']) {
// Update the Office Head
// IS THERE ALREADY AN OFFICE HEAD?
            $query = "SELECT ContactsID FROM ADec_OfficeContacts WHERE OFFICEID = '$SelectOfficeID' AND OfficeHead=1 AND DeclarationYear = $DeclarationYear";
            if (!($result = mysql_query($query))) {
                throw new Exception("Select failed: " . $query);
            }
            $Officerow = mysql_fetch_array($result);
            if ($Officerow) {
                // Update existing
                $query2 = "UPDATE ADec_Contacts SET ContactDesignation='" . $form['des'] . "', ContactFirstName='" . $form['nam'] . "',
	ContactSurname='" . $form['sur'] . "', ProfessionalRegistrations='" . $form['regis'] . "', Qualifications='" . $form['qual'] . "'
	WHERE ContactsID='" . $Officerow[0] . "'";
                if (!($result2 = mysql_query($query2))) {
                    throw new Exception("Update ADec_Contacts failed submitcheck2b: " . $query2);
                }
            } else {
                // Insert new
                $query2 = "INSERT INTO ADec_Contacts (ContactDesignation, ContactFirstName, ContactSurname,
	ProfessionalRegistrations, Qualifications, DeclarationYear) VALUES ('" . $form['des'] . "', '" . $form['nam'] . "', '" . $form['sur'] . "', '" . $form['regis'] . "', "
                        . "'" . $form['qual'] . "', $DeclarationYear)";
                if (!($result2 = mysql_query($query2))) {
                    throw new Exception("Insert ADec_Contacts failed submitcheck2b: " . $query2);
                }
//    	$row = mysql_fetch_array($result2);
                $NewContactID = mysql_insert_id();

if ($Hf[1] . "" == "") {
                    $Hf[1] = "NULL";
                }
                $query2 = "INSERT INTO ADec_OfficeContacts (OfficeID, Prev_OfficeID, ContactsID, OfficeHead, DeclarationYear)
	VALUES ($SelectOfficeID, $Hf[1], $NewContactID, 1, $DeclarationYear)";
                if (!($result2 = mysql_query($query2))) {
                    throw new Exception("Insert ADec_OfficeContacts failed submitcheck2b: " . $query2);
                }
            }
        }

$reftype = "OfficeID";
        $refdoc = "Schedule1B";
        $adecdate = date("Y-m-d H:i");
        $query102 = "INSERT INTO ADec_Done (RefID,RefType,RefDoc,ADecDate, DeclarationYear)
  values('$SelectOfficeID','$reftype','$refdoc','$adecdate', $DeclarationYear)";
        if (!($Jresult = mysql_query($query102))) {
            throw new Exception("Insert Failed submitcheck2b: " . $query102);
        }

$ErrorReport = "Thank you for completing this section.";
 $NextSection = "complete";
 } else {
 $NextSection = "notcomplete";
 }
// **** End of the Page
 ?>
</div>