Gecko [ v3.cesa.co.za ]

Name	Size	Permission	Date
Mandrill	[ DIR ]	drwxr-sr-x	2016-02-10 08:42
temp	[ DIR ]	drwxr-sr-x	2022-06-16 13:37
.htaccess	35 B	-rw-r--r--	2023-03-13 09:52
CESA_Ci Applications2b.pdf	800.6 KB	-rw-r--r--	2008-08-14 11:23
CESA_vector logo_high res.jpg	334.84 KB	-rw-r--r--	2008-08-14 11:10
Fulton_Press_small.pdf	84.39 KB	-rw-r--r--	2008-08-11 10:41
LAUNCH OF CESA.pdf	69.23 KB	-rw-r--r--	2008-08-14 11:24
Mandrill.php	6.44 KB	-rw-r--r--	2016-02-10 08:42
Overview_template_QMS_for_SMME-v2 _2.pdf	43.08 KB	-rw-r--r--	2008-09-26 12:04
ToSendProcess.php	46.4 KB	-rw-r--r--	2026-04-01 10:55
XPertMailer.php	38.69 KB	-rw-r--r--	2008-08-06 07:29
ad-reminders.php	2.7 KB	-rw-r--r--	2024-05-16 09:16
awards-from-forminator-debug.php	7.13 KB	-rw-r--r--	2025-06-23 16:02
awards-from-forminator-direct.php	9.69 KB	-rw-r--r--	2025-06-24 06:23
awards-from-forminator-fixed.php	7.42 KB	-rw-r--r--	2025-06-23 16:09
awards-from-forminator-step-by-step.php	6.93 KB	-rw-r--r--	2025-06-23 16:12
awards-from-forminator.php	18.54 KB	-rw-r--r--	2026-06-29 10:02
batch-job.php	948 B	-rw-r--r--	2026-08-24 10:20
bulk-mail-check.php	443 B	-rw-r--r--	2025-08-22 11:48
checkmail.php	6.35 KB	-rw-r--r--	2008-08-06 09:18
class.email-reader.php	15.58 KB	-rw-r--r--	2008-08-06 09:18
cron-5-minutes-root.sh	527 B	-rwxr-xr-x	2026-08-21 08:23
cron-daily-v3.sh	192 B	-rwxr-xr-x	2025-09-11 17:37
cron-daily.sh	500 B	-rwxr-xr-x	2025-12-29 09:32
cron-hourly.sh	413 B	-rwxr-xr-x	2025-09-01 13:33
cron-monthly.sh	83 B	-rwxr-xr-x	2025-06-27 15:38
cron.sh	369 B	-rwxr-xr-x	2026-04-16 10:02
export-attendees-google.php	3.07 KB	-rw-r--r--	2026-08-24 10:20
export-member-data-google.php	3.69 KB	-rw-r--r--	2026-08-24 10:20
export.php	1.96 KB	-rw-r--r--	2010-04-13 14:54
exportgooglecontacts.php	1.18 KB	-rw-r--r--	2022-06-16 14:41
import.php.bak	4.84 KB	-rw-r--r--	2010-05-06 07:59
importdup.php	3.34 KB	-rw-r--r--	2010-05-19 14:20
importschool.php	5.09 KB	-rw-r--r--	2010-05-19 14:05
php8.1_cli_errors.log	43.15 KB	-rw-r--r--	2025-12-31 10:58
phpinfo.php	20 B	-rw-r--r--	2024-04-16 11:40
receivemail.class.php	4.65 KB	-rw-r--r--	2008-08-06 07:51
sce-send-certificates.php	750 B	-rw-r--r--	2026-08-24 10:20
sendlater.php	12.86 KB	-rw-r--r--	2026-01-16 09:53
sendsms.php	4.3 KB	-rw-r--r--	2026-01-16 09:43
simple-wp-test.php	1.74 KB	-rw-r--r--	2025-06-23 16:05
sync-anual-declarations.php	3.22 KB	-rw-r--r--	2026-08-24 10:20
system-checks.php	798 B	-rw-r--r--	2026-08-24 10:20
test-send.php	786 B	-rw-r--r--	2024-04-11 07:55
test-wp-load.php	2.29 KB	-rw-r--r--	2025-06-23 16:02
training-material-expiry-check.php	4.12 KB	-rw-r--r--	2026-06-12 11:48
training-provider-expiry-check.php	4.51 KB	-rw-r--r--	2026-06-12 11:48
unemployed-reminders.php	2.43 KB	-rw-r--r--	2024-05-16 09:06
update-qms-cert-status.php	3.54 KB	-rw-r--r--	2026-08-24 10:20
wp-diagnostic.php	4.39 KB	-rw-r--r--	2025-06-23 16:08
wp-load-bypass.php	3.03 KB	-rw-r--r--	2025-06-23 16:08
wp-load-minimal.php	3.01 KB	-rw-r--r--	2025-06-23 16:08

Rename

<?php

include_once($_SERVER['DOCUMENT_ROOT'] . "/vendor/autoload.php");
include_once($_SERVER['DOCUMENT_ROOT'] . "/echasl23/ewcfg7.php");
include_once($_SERVER['DOCUMENT_ROOT'] . "/php/includes/require_ewmysql.php");
cesa_require_ewmysql($_SERVER['DOCUMENT_ROOT'] . "/echasl23/ewmysql7.php");
include_once($_SERVER['DOCUMENT_ROOT'] . "/echasl23/phpfn7.php");
include_once($_SERVER['DOCUMENT_ROOT'] . "/echasl23/adminusersinfo.php");
include_once($_SERVER['DOCUMENT_ROOT'] . "/echasl23/userfn7.php");

ini_set('error_reporting', 1);
error_log(E_ALL);

$adFirmObj = new ADec_tblMemberFirms($sqlf);
$firmObj = new MemberFirm($sqlf);

echo 'starting... <br />';

$adFirms = $adFirmObj->getAll();

foreach ($adFirms as $adFirm) {

echo 'looking up ' . $adFirm['Prev_FirmID'] . '<br />';
    $firm = $firmObj->find($adFirm['Prev_FirmID']);

$updateFirm = array(
        'FirmID' => $firm['FirmID'],
//        'FirmName' => $adFirm['FirmName'],
//        'PIUnderwriter' => $adFirm['PIUnderwriter'],
//        'LevelOfCover' => $adFirm['LevelOfCover'],
//        'FormOfIncorporation' => $adFirm['FormOfIncorporation'],
//        'URL' => $adFirm['URL'],
//        'QMSPlan' => $adFirm['QMSPlan'],
//        'QMSDocs' => $adFirm['QMSDocs'],
//        'QMSISOComply' => $adFirm['QMSISOComply'],
//        'QMSISOCert' => $adFirm['QMSISOCert'],
//        'QMSISOCertDate' => $adFirm['QMSISOCertDate'],
//        'QMSOffices' => $adFirm['QMSOffices'],
//        'QMSConsult' => $adFirm['QMSConsult'],
//        'QMSCertBody' => $adFirm['QMSCertBody'],
//        'QMSImplemented' => $adFirm['QMSImplemented'],
//        'QMSImplFully' => $adFirm['QMSImplFully'],
//        'QMSImplPart' => $adFirm['QMSImplPart'],
//        'QMSAssess' => $adFirm['QMSAssess'],
//        'QMSUseConsult' => $adFirm['QMSUseConsult'],
//        'QMSIntend' => $adFirm['QMSIntend'],
//        'DeclarationReceived' => $adFirm['DeclarationReceived'],
//        'MentoringProg' => $adFirm['MentoringProg'],
//        'CandidateProg' => $adFirm['CandidateProg'],
//        'SubscriptionsContact' => $adFirm['SubscriptionsContact'],
//        'SubscriptionsEmail' => $adFirm['SubscriptionsEmail'],
//        'HRTrainingContact' => $adFirm['HRTrainingContact'],
//        'HRTrainingEmail' => $adFirm['HRTrainingEmail'],
//        'MarketingContact' => $adFirm['MarketingContact'],
//        'CAUSigned' => $adFirm['CAUSigned'],
//        'BBBEE' => $adFirm['BBBEE'],
//        'YPFContact' => $adFirm['YPFContact'],
//        'YPFEmail' => $adFirm['YPFEmail'],
//        'SABTACO' => $adFirm['SABTACO'],
//        'BBCBE' => $adFirm['BBCBE'],
//        'GBCSA' => $adFirm['BBCBE'],
//        'MainFirmInvoice' => $adFirm['MainFirmInvoice'],
//        'GroupFirmsInvoice' => $adFirm['GroupFirmsInvoice'],
        'ThreeYearsAverageTurnover' => $adFirm['SMMEAmount'],
        'BlackWomenOwned' => ADec_tblMemberFirms::getBlackWomenOwnedValue($adFirm['BlackWomenOwned']),
        'SMME' => ADec_tblMemberFirms::getAnnualTurnoverValue($adFirm['SMME'], $adFirm['SMMEAmount']),
        'BlackOwned' => ADec_tblMemberFirms::getBlackOwnedValue($adFirm['BlackOwned']),
    );

//    if ($firm['FirmID'] == 1255) {
//        var_dump($updateFirm);
//        exit;
//    }

$firmObj->upsert($updateFirm);
}

echo count($adFirms);