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

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

echo 'Starting export ';

if (!isset($_SERVER['DOCUMENT_ROOT']) || strlen($_SERVER['DOCUMENT_ROOT']) <= 0) {
 $_SERVER['DOCUMENT_ROOT'] = str_replace('/crons', '', getcwd());
}

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");

use Google\Cloud\Storage\StorageClient;

$storage = new StorageClient([
    'keyFilePath' => $_SERVER['DOCUMENT_ROOT'] . '/cfg/google-keyfile-storage-admin.json'
]);

$bucket = $storage->bucket('cesa-membership');

$memberFirmObj = new MemberFirm($sqlf);
$questionnaireObj = new ADecQuestionnaires($sqlf);
$adqFirmObj = new ADQFirms($sqlf);

$memberFirmObj->updateAll();

$memberData = $memberFirmObj->getExportData();
$csvString = '';
$rowCnt = 1;

foreach ($memberData as $row) {

if ($rowCnt == 1) {

$colCnt = 1;

foreach ($row as $key => $val) {

if (is_numeric($key)) {
                continue;
            }

$csvString .= '"' . $key . '"';

if ($colCnt < count($row)) {
 $csvString .= ', ';
 }

$colCnt++;
        } //foreach

$csvString .= ', "FIMS_Current_Start_Date", "QMS_Current_Start_Date", "PSM_Current_Start_Date"';

$csvString .= "\r\n";
    }

$colCnt = 1;

foreach ($row as $key => $val) {

if (is_numeric($key)) {
            continue;
        }

$csvString .= '"' . strip_chars($val) . '"';

if ($colCnt < count($row)) {
 $csvString .= ', ';
 }

$colCnt++;
    }

$csvString .= ', "' . $adqFirmObj->getMSDStartDate($row['FirmID'], 1, date('Y')) . '", '
        . '"' . $adqFirmObj->getMSDStartDate($row['FirmID'], 2, date('Y')) . '", '
        . '"' . $adqFirmObj->getMSDStartDate($row['FirmID'], 3, date('Y')) . '"';

$rowCnt++;
    $csvString .= "\r\n";
} //foreach

$fileName = sys_get_temp_dir() . '/cesa-member-export.csv';

//$current_encoding = mb_detect_encoding($csvString, 'auto');
//echo $current_encoding;
//exit;
//$csvString = iconv($current_encoding, 'ISO-8859-1', $csvString);
//echo $csvString;
//exit;
$csvString = str_replace('≥', '>=', $csvString);
$csvString = str_replace('≤', '<=', $csvString);
file_put_contents($fileName, $csvString);

echo 'Uploading ' . $fileName . ' ';

$bucket->upload(
    fopen($fileName, 'r')
);

echo 'Uploaded ' . $fileName . ' ';

unlink($fileName);

$fileName = sys_get_temp_dir() . '/cesa-adec-questionnaire-fims.csv';
file_put_contents($fileName, $questionnaireObj->getExportDataAsString(1));

echo 'Uploading ' . $fileName . ' ';

$bucket->upload(
    fopen($fileName, 'r')
);

echo 'Uploaded ' . $fileName . ' ';

unlink($fileName);

$fileName = sys_get_temp_dir() . '/cesa-adec-questionnaire-qms.csv';
file_put_contents($fileName, $questionnaireObj->getExportDataAsString(2));

echo 'Uploading ' . $fileName . ' ';

$bucket->upload(
    fopen($fileName, 'r')
);

echo 'Uploaded ' . $fileName . ' ';

unlink($fileName);

$fileName = sys_get_temp_dir() . '/cesa-adec-questionnaire-psm.csv';
file_put_contents($fileName, $questionnaireObj->getExportDataAsString(3));

echo 'Uploading ' . $fileName . ' ';

$bucket->upload(
    fopen($fileName, 'r')
);

echo 'Uploaded ' . $fileName . ' ';

unlink($fileName);

echo 'Export complete';