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

// Start output buffering to prevent "headers already sent" warnings
ob_start();

ini_set('display_errors', 1);
error_reporting(E_ALL);
//header('Content-type: text/json');

// CLI bootstrap: derive site root from this file's location (…/crons/awards-….php).
// Do not use getcwd() — the shell may be anywhere (e.g. /home/otto).
// Do not trust $_SERVER['DOCUMENT_ROOT'] in CLI — PHP may set it to the user's home.
if (PHP_SAPI === 'cli') {
    $_SERVER['DOCUMENT_ROOT'] = dirname(__DIR__);
} elseif (!isset($_SERVER['DOCUMENT_ROOT']) || $_SERVER['DOCUMENT_ROOT'] === '') {
    $_SERVER['DOCUMENT_ROOT'] = dirname(__DIR__);
}

// echo $_SERVER['DOCUMENT_ROOT'];
// exit;

include_once($_SERVER['DOCUMENT_ROOT'] . "/ADOdb/adodb.inc.php");
include_once($_SERVER['DOCUMENT_ROOT'] . "/vendor/autoload.php");
include_once($_SERVER['DOCUMENT_ROOT'] . "/cfg/config.php");
include_once($_SERVER['DOCUMENT_ROOT'] . "/php/includes/sqlFunctions.php");
include_once($_SERVER['DOCUMENT_ROOT'] . "/php/includes/BaseTableClass.php");
include_once($_SERVER['DOCUMENT_ROOT'] . "/php/includes/MemberFirm.php");

// Load WordPress with error handling
// try {
//     require_once($_SERVER['DOCUMENT_ROOT'] . '/wp-load.php');
//     echo 'WordPress loaded successfully' . "\r\n";
// } catch (Exception $e) {
//     echo 'Error loading WordPress: ' . $e->getMessage() . "\r\n";
//     exit(1);
// }

// Verify WordPress functions are available
// if (!function_exists('get_post_meta')) {
//     echo 'WordPress function get_post_meta is not available. WordPress may not have loaded properly.' . "\r\n";
//     exit(1);
// }

$sqlfWP = new sqlFunctions(WP_HOST, WPDB_USER, WPDB_PASS, WPDB_DB);
if (!$sqlfWP->isConnected()) {
    fwrite(STDERR, "WordPress DB connection failed (" . WP_HOST . "/" . WPDB_DB . "). "
        . "Check WP_HOST, WPDB_USER, WPDB_PASS, WPDB_DB in cfg/config.php.\n");
    exit(1);
}

$wpFormsSQL = "SELECT * FROM wp_posts p "
    . "INNER JOIN wp_postmeta pm ON p.id = pm.post_id "
    . "WHERE p.post_type = 'forminator_forms'";

echo $wpFormsSQL . "\r\n";

$wpForms = $sqlfWP->getAll($wpFormsSQL);

$forms = array();

echo count($wpForms) . " forms found\r\n";

foreach ($wpForms as $wpForm) {

// $formMeta = get_post_meta($wpForm['ID']);

$metaSQL = "SELECT meta_key, meta_value FROM wp_postmeta WHERE post_id = " . $wpForm['ID'];
    $formMeta = $sqlfWP->getAll($metaSQL);

// Find forminator_form_meta
    $forminatorMeta = null;
    foreach ($formMeta as $meta) {
        if ($meta['meta_key'] === 'forminator_form_meta') {
            $forminatorMeta = unserialize($meta['meta_value']);
            break;
        }
    }

// var_dump($forminatorMeta);
    // exit;

$forms[$forminatorMeta['settings']['form_name']] = array('name' => $forminatorMeta['settings']['formName'], 'fields' => array(), 'entries' => array());
    $entriesFinal = array();

// var_dump(array_keys($wpForm));
 // echo $forminatorMeta['settings']['form_name'] . ' - ' . $forminatorMeta['settings']['formName'];
 // echo ' ';
 // exit;

foreach ($forminatorMeta['fields'] as $field) {

if (isset($field['field_label'])) {

// echo 'Field ID: ' . $field['id'] . ' - Label: ' . $field['field_label'] . ' ';

$forms[$forminatorMeta['settings']['form_name']]['fields'][$field['id']] = array('label' => $field['field_label']);
        }
    } //foreach

$entrySQL = "SELECT * FROM wp_frmt_form_entry WHERE form_id = " . $wpForm['ID'];

$formEntries = $sqlfWP->getAll($entrySQL);

$entries = array();

// echo ' Entries: ';
 foreach ($formEntries as $formEntry) {

$oneEntry = array(
 'ExternalFormID' => $forminatorMeta['settings']['form_name'],
 'ExternalEntryID' => $formEntry['entry_id'],
 'EntryFormName' => $forminatorMeta['settings']['formName'],
 'FirmName' => '',
 'FormFields' => array(),
 'PreEntryHTML' => '<table border="0" cellpadding="4" cellspacing="0" border="0">',
 'FullEntryHTML' => '',
 'JV_Partners' => '',
 );

$entries[$formEntry['entry_id']] = array();

foreach ($forms[$forminatorMeta['settings']['form_name']]['fields'] as $fieldId => $vals) {

$fieldSQL = "SELECT * FROM wp_frmt_form_entry_meta WHERE entry_id = " . $formEntry['entry_id'] . " AND meta_key = '" . $fieldId . "'";
 // echo $fieldSQL . ' ';

$fieldValue = $sqlfWP->getRow($fieldSQL);
 $labelText = trim($forms[$forminatorMeta['settings']['form_name']]['fields'][$fieldId]['label']);
 // echo 'Label: ' . $labelText . ' ';

if (is_array($fieldValue) && isset($fieldValue['meta_value'])) {

if (in_array($fieldId, array('text-1'))) {
                    $oneEntry['Firm_Name'] = $fieldValue['meta_value'];
                }

if ($labelText == 'Which awards category(ies) are you entering for? (Please select all relevant)' || $labelText == 'Name of Award Category' || $labelText == 'Which Award Category is the Submission for?') {
                    $numEntries = 0;
                    if (strpos(' ' . $fieldValue['meta_value'], '{') > 0) {
                        $fieldValue['meta_value'] = unserialize($fieldValue['meta_value']);
                        if (is_array($fieldValue['meta_value'])) {
                            $numEntries = count($fieldValue['meta_value']);
                            $fieldValue['meta_value'] = implode(', ', $fieldValue['meta_value']);
                        }
                    }

if ($numEntries <= 0) {
 $numEntries = 1;
 }

$oneEntry['Award_Category'] = $fieldValue['meta_value'];
 // echo $labelText . ' found category: ' . $oneEntry['Award_Category'] . ' ';
 } else {
 // echo 'label not category: ' . $labelText . ' ';
 }

if (in_array($fieldId, array('date-1', 'date-3', 'date-5', 'date-7', 'date-9'))) {
                    $oneEntry['Start_Date'] = $fieldValue['meta_value'];
                }

if ($labelText == 'Name of Project Entered' || $labelText == 'Project Title') {
                    $oneEntry['Project_Name'] = $fieldValue['meta_value'];
                }

if (in_array($fieldId, array('date-2', 'date-4', 'date-6', 'date-8', 'date-10'))) {
 $oneEntry['End_Date'] = $fieldValue['meta_value'];
 $oneEntry['Completion_Date'] = $fieldValue['meta_value'];
 // echo $oneEntry['End_Date'] . ' ';
 }

if ($labelText == 'Full Name' || $labelText == 'Company Contact Person') {
                    $oneEntry['Lead_Consultant_Name'] = $fieldValue['meta_value'];
                }

if ($labelText == 'Office Number') {
                    $oneEntry['Lead_Consultant_Tel'] = $fieldValue['meta_value'];
                }

if ($labelText == 'Mobile Number' || $labelText == 'Phone Number of Contact Person') {
                    $oneEntry['Lead_Consultant_Mobile'] = $fieldValue['meta_value'];
                }

if (substr($fieldId, 0, 5) == 'email') {
                    $oneEntry['Lead_Consultant_Email'] = $fieldValue['meta_value'];
                }

if (substr($fieldId, 0, 5) == 'radio') {
                    $oneEntry['A1_Poster_Required'] = $fieldValue['meta_value'];
                }

if ($labelText == 'Job Title') {
                    $oneEntry['Role_In_Project'] = $fieldValue['meta_value'];
                }

if ($labelText == 'JV Partner Name' || in_array($fieldId, array('text-4', 'text-5', 'text-6', 'text-7', 'text-8', 'text-9'))) {
                    if (strlen($oneEntry['JV_Partners']) > 0) {
                        $oneEntry['JV_Partners'] .= ', ';
                    }
                    $oneEntry['JV_Partners'] .= $fieldValue['meta_value'];
                }

if (substr($fieldId, 0, 6) == 'upload') {
                    $fieldValue['meta_value'] = unserialize($fieldValue['meta_value']);

if (is_array($fieldValue['meta_value']) && count($fieldValue['meta_value']) > 0 && isset($fieldValue['meta_value']['file']) && $fieldValue['meta_value']['file']['success']) {

if (is_array($fieldValue['meta_value']['file']['file_url'])) {
                            $fieldValue['meta_value']['file']['file_url'] = $fieldValue['meta_value']['file']['file_url'][0];
                        }

if (!isset($fieldValue['meta_value']['file']['file_name'])) {
                            $fieldValue['meta_value']['file']['file_name'] = substr($fieldValue['meta_value']['file']['file_url'], strrpos('/', $fieldValue['meta_value']['file']['file_url']));
                        }

$fieldValue['meta_value'] = '<a href="' . $fieldValue['meta_value']['file']['file_url'] . '" target="_blank">' . $fieldValue['meta_value']['file']['file_name'] . '</a>';
 }
 }

$oneEntry['FormFields'][] = array(
                    'id' => $fieldId,
                    'label' => $labelText,
                    'value' => $fieldValue['meta_value'],
                );

// echo $fieldId . ' - ' . $labelText . ' = ' . $fieldValue['meta_value'] . ' ';
 $entries[$formEntry['entry_id']][$fieldId] = array('label' => $forms[$forminatorMeta['settings']['form_name']]['fields'][$fieldId]['label'], 'value' => $fieldValue['meta_value']);
 } else {
 // var_dump($fieldValue);
 // echo ' ';
 }
 } //foreach fields

foreach ($oneEntry['FormFields'] as $oneFormField) {

if (is_array($oneFormField['value'])) {
                $oneFormField['value'] = print_r($oneFormField['value'], true);
            }

$oneEntry['PreEntryHTML'] .= '<tr><td align="left" valign="top" width="40%">' . $oneFormField['label'] . ':</td><td align="left" valign="top">' . $oneFormField['value'] . '</td></tr>';
 }

$oneEntry['PreEntryHTML'] .= '</table>';

// echo ' Entry For DB: ' . "\r\n";
 $entriesFinal[] = $oneEntry;
 // exit;
 // unset($oneEntry['FormFields']);
 // echo nl2br(print_r($oneEntry, true)) . "\r\n";
 // echo var_dump($oneEntry, true) . "\r\n";
 // exit;
 // echo 'Entry done ';
 } //foreach entries

echo '<h4>' . $forminatorMeta['settings']['form_name'] . '</h4>' . "\r\n";
 $firmObj = new MemberFirm($sqlf);

foreach ($entriesFinal as $oneEntry) {

if (isset($oneEntry['Firm_Name']) && is_numeric($oneEntry['Firm_Name'])) {
            $firmArr = $firmObj->find($oneEntry['Firm_Name']);

if (is_array($firmArr) && count($firmArr) > 0) {
                $oneEntry['Firm_Name'] = $firmArr['FirmName'];
            }

//            echo $oneEntry['Firm_Name'];
            //            exit;
        }

if (in_array(
            $forminatorMeta['settings']['form_name'],
            array('pre-entry-form-project-awards', 'pre-entry-form-business-development-award', 'pre-entry-form-individual-awards', 'pre-entry-form-client-awards', 'Pre-Entry Form: Individual Awards')
        )) {

$currentEntry = $sqlf->getRow("SELECT * FROM AwardsEntries WHERE ExternalFormID = '" . $oneEntry['ExternalFormID'] . "' "
                . "AND ExternalEntryID = '" . $oneEntry['ExternalEntryID'] . "' AND PreEntry = 1");

$isNewPreEntry = false;
 if (!is_array($currentEntry) || count($currentEntry) <= 0) {
 $isNewPreEntry = true;
 $sqlf->execute("INSERT INTO AwardsEntries (Firm_Name, ExternalFormID, ExternalEntryID, PreEntry, AwardYear) "
 . "VALUES ('" . $oneEntry['Firm_Name'] . "', '" . $oneEntry['ExternalFormID'] . "', '" . $oneEntry['ExternalEntryID'] . "', 1, " . date('Y') . ")");

$currentEntry = $sqlf->getRow("SELECT * FROM AwardsEntries WHERE ExternalFormID = '" . $oneEntry['ExternalFormID'] . "' "
                    . "AND ExternalEntryID = '" . $oneEntry['ExternalEntryID'] . "'");
            }

$currentEntry = array_merge($currentEntry, $oneEntry);
            unset($currentEntry['FormFields']);
            $currentEntry['FullEntryHTML'] = '';
            if ($isNewPreEntry) {
                $currentEntry['AwardYear'] = date('Y');
            }
            // else: keep existing AwardYear from DB (do not overwrite)

$sqlf->autoExecute('AwardsEntries', $currentEntry, 'UPDATE', 'AwardsEntryID = ' . $currentEntry['AwardsEntryID'], 'AwardsEntryID');

// echo 'Entry ID: ' . $currentEntry['AwardsEntryID'] . ' ';
 // var_dump($oneEntry);
 // echo "\r\n";
 // echo ' ';
 // var_dump($currentEntry);
 // echo ' ';
 // exit;
 } else {

if (!isset($oneEntry['Award_Category'])) {
                $oneEntry['Award_Category'] = '';
            }

if (!isset($oneEntry['Award_Category']) || strlen($oneEntry['Award_Category']) <= 0) {
 if ($forminatorMeta['settings']['form_name'] == 'full-submission-projects-less-then-50-million') {
 $oneEntry['Award_Category'] = 'Projects less than R50 million';
 } elseif ($forminatorMeta['settings']['form_name'] == 'full-submission-projects-ranging-from-r50-less-than-r250-million') {
 $oneEntry['Award_Category'] = 'Projects ranging from R50 – less than R250 million';
 } elseif ($forminatorMeta['settings']['form_name'] == 'full-submission-projects-ranging-from-r250-less-than-r1-billion') {
 $oneEntry['Award_Category'] = 'Projects ranging from R250 – less than R1 billion';
 } elseif ($forminatorMeta['settings']['form_name'] == 'full-submission-mega-projects-greater-than-r1-billion') {
 $oneEntry['Award_Category'] = 'Mega Projects greater than R1 billion';
 } elseif ($forminatorMeta['settings']['form_name'] == 'full-submission-best-international-projects') {
 $oneEntry['Award_Category'] = 'Best International Projects';
 } elseif ($forminatorMeta['settings']['form_name'] == 'full-submission-water-sanitation-and-hygiene-wash-design-excellence-award') {
 $oneEntry['Award_Category'] = 'Engineering Technology and Innovation: Water, Sanitation, and Hygiene (Wash) Design Excellence Award';
 } elseif ($forminatorMeta['settings']['form_name'] == 'full-submission-hvac-building-systems-design-excellence-award') {
 $oneEntry['Award_Category'] = 'Engineering Technology and Innovation: HVAC Building Systems Design Excellence Award';
 } elseif ($forminatorMeta['settings']['form_name'] == 'full-submission-business-development-awards') {
 //TODO: Is this correct mapping?
 $oneEntry['Award_Category'] = 'Business Excellence Award';
 } elseif ($forminatorMeta['settings']['form_name'] == 'full-submission-individual-awards') {
 $oneEntry['Award_Category'] = 'Individual Awards';
 } elseif ($forminatorMeta['settings']['form_name'] == 'full-submission-client-awards') {
 $oneEntry['Award_Category'] = 'Client Awards';
 } elseif ($forminatorMeta['settings']['form_name'] == 'project-awards-full-submission') {
 $oneEntry['Award_Category'] = 'Project Awards';
 } else {
 }
 }

$currentEntry = $sqlf->getRow("SELECT * FROM AwardsEntries "
                . "WHERE ExternalFormID = '" . $oneEntry['ExternalFormID'] . "' AND Firm_Name = '" . $oneEntry['Firm_Name'] . "' "
                . "AND Award_Category LIKE '%" . $oneEntry['Award_Category'] . "%' AND PreEntry = 0");

$isNewFullEntry = false;
 if (!is_array($currentEntry) || count($currentEntry) <= 0) {
 $isNewFullEntry = true;
 $sqlf->execute("INSERT INTO AwardsEntries (Award_Category, Firm_Name, ExternalFormID, ExternalEntryID, PreEntry, AwardYear) "
 . "VALUES ('" . $oneEntry['Award_Category'] . "', '" . $oneEntry['Firm_Name'] . "', '" . $oneEntry['ExternalFormID'] . "', "
 . "'" . $oneEntry['ExternalEntryID'] . "', 0, " . date('Y') . ")");

$currentEntry = $sqlf->getRow("SELECT * FROM AwardsEntries "
                    . "WHERE ExternalFormID = '" . $oneEntry['ExternalFormID'] . "' AND Firm_Name = '" . $oneEntry['Firm_Name'] . "' "
                    . "AND Award_Category LIKE '%" . $oneEntry['Award_Category'] . "%' AND PreEntry = 0");
            }

$currentEntry = array_merge($currentEntry, $oneEntry);
            unset($currentEntry['FormFields']);

$oneEntry['FullEntryHTML'] = '<table border="0" cellpadding="4" cellspacing="0" border="0">';

foreach ($oneEntry['FormFields'] as $oneFormField) {
 $oneEntry['FullEntryHTML'] .= '<tr><td align="left" valign="top" width="40%">' . $oneFormField['label'] . ':</td><td align="left" valign="top">' . $oneFormField['value'] . '</td></tr>';
 }
 $oneEntry['FullEntryHTML'] .= '</table>';

$currentEntry['FullEntryHTML'] = $oneEntry['FullEntryHTML'];
            $currentEntry['PreEntryHTML'] = '';
            if ($isNewFullEntry) {
                $currentEntry['AwardYear'] = date('Y');
            }
            // else: keep existing AwardYear from DB (do not overwrite)

$sqlf->autoExecute('AwardsEntries', $currentEntry, 'UPDATE', 'AwardsEntryID = ' . $currentEntry['AwardsEntryID'], 'AwardsEntryID');

echo 'Entry ID: ' . $currentEntry['AwardsEntryID'] . ' ' . "\r\n";
 // var_dump($oneEntry);
 // echo "\r\n";
 // echo ' ';
 // var_dump($currentEntry);
 // echo "\r\n";
 // echo ' ';
 // exit;
 }
 }

$forms[$forminatorMeta['settings']['form_name']]['entries'] = $entries;
 echo 'DONE one form! ' . "\r\n";
} //foreach form
//echo json_encode($forms);
//echo nl2br(print_r($entriesFinal, true));
//echo ' ';