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 /
cpdadmin /
Delete
Unzip
Name
Size
Permission
Date
Action
ajax
[ DIR ]
drwxr-sr-x
2025-06-24 07:20
assessordocs
[ DIR ]
drwxr-sr-x
2026-03-23 08:03
calendar
[ DIR ]
drwxr-sr-x
2022-04-19 07:00
certificates
[ DIR ]
drwxrwsr-x
2026-08-25 10:45
ckeditor
[ DIR ]
drwxr-sr-x
2022-04-19 07:00
images
[ DIR ]
drwxr-sr-x
2022-04-19 07:59
js
[ DIR ]
drwxr-sr-x
2022-04-19 06:59
lang
[ DIR ]
drwxr-sr-x
2022-04-19 06:59
providerdocs
[ DIR ]
drwxr-sr-x
2026-08-12 07:21
txt
[ DIR ]
drwxr-sr-x
2022-04-19 06:59
uploads
[ DIR ]
drwxr-sr-x
2026-08-17 12:51
yui280
[ DIR ]
drwxr-sr-x
2022-04-19 07:00
CESA_CPD.css
10.23
KB
-rw-r--r--
2022-04-19 06:59
CPDAdminUsersadd.php
28.52
KB
-rw-r--r--
2022-09-15 19:16
CPDAdminUsersdelete.php
20.94
KB
-rw-r--r--
2022-09-15 19:16
CPDAdminUsersedit.php
29.37
KB
-rw-r--r--
2022-09-15 19:16
CPDAdminUsersinfo.php
24.37
KB
-rw-r--r--
2022-09-15 19:16
CPDAdminUserslist.php
58.77
KB
-rw-r--r--
2022-09-15 19:16
CPDAdminUsersview.php
40.59
KB
-rw-r--r--
2022-09-15 19:16
CPDAssessors_CVFile_bv.php
6.5
KB
-rw-r--r--
2023-04-21 10:09
CPDAssessors_Document1_bv.php
6.54
KB
-rw-r--r--
2023-04-21 10:09
CPDAssessors_Document2_bv.php
6.54
KB
-rw-r--r--
2023-04-21 10:09
CPDAssessors_Document3_bv.php
6.54
KB
-rw-r--r--
2023-04-21 10:09
CPDAssessors_NDAFile_bv.php
6.52
KB
-rw-r--r--
2023-04-21 10:09
CPDAssessors_QualificationFile_bv.php
6.63
KB
-rw-r--r--
2023-04-21 10:09
CPDAssessorsadd.php
77.14
KB
-rw-r--r--
2023-04-21 10:09
CPDAssessorsdelete.php
28.85
KB
-rw-r--r--
2023-04-21 10:09
CPDAssessorsedit.php
92.45
KB
-rw-r--r--
2023-04-21 10:09
CPDAssessorsinfo.php
30.15
KB
-rw-r--r--
2023-04-21 10:09
CPDAssessorslist.php
73.5
KB
-rw-r--r--
2023-04-21 10:09
CPDAssessorsview.php
69.35
KB
-rw-r--r--
2023-04-21 10:09
CPDProviderDocs_DocFile_bv.php
8.02
KB
-rw-r--r--
2023-02-27 12:50
CPDProviderDocsadd.php
40.38
KB
-rw-r--r--
2023-02-27 12:50
CPDProviderDocsdelete.php
24.9
KB
-rw-r--r--
2023-02-27 12:50
CPDProviderDocsedit.php
46.12
KB
-rw-r--r--
2023-02-27 12:50
CPDProviderDocsinfo.php
25.55
KB
-rw-r--r--
2023-02-27 12:50
CPDProviderDocslist.php
84.13
KB
-rw-r--r--
2023-02-27 12:50
CPDProviderDocsview.php
56.09
KB
-rw-r--r--
2023-02-27 12:50
CPDSPReview_ReviewChecklist_bv.php
6.74
KB
-rw-r--r--
2023-03-08 11:27
CPDSPReview_ReviewFile1_bv.php
6.69
KB
-rw-r--r--
2023-03-08 11:27
CPDSPReview_ReviewFile2_bv.php
6.69
KB
-rw-r--r--
2023-03-08 11:27
CPDSPReviewadd.php
54.32
KB
-rw-r--r--
2023-03-08 12:02
CPDSPReviewdelete.php
25.1
KB
-rw-r--r--
2023-03-08 12:02
CPDSPReviewedit.php
64.65
KB
-rw-r--r--
2023-03-08 12:02
CPDSPReviewinfo.php
28.05
KB
-rw-r--r--
2023-03-08 12:02
CPDSPReviewlist.php
69.12
KB
-rw-r--r--
2023-03-08 12:02
CPDSPReviewview.php
51.23
KB
-rw-r--r--
2023-03-08 12:02
CPDServiceProvider_AccountabilityStructure_bv.php
7.13
KB
-rw-r--r--
2024-12-10 09:46
CPDServiceProvider_CPDActivities_bv.php
7.02
KB
-rw-r--r--
2024-12-10 09:46
CPDServiceProvider_EvaluatorInvoice_bv.php
7.34
KB
-rw-r--r--
2025-03-30 11:38
CPDServiceProvider_EvaluatorTimesheet_bv.php
7.36
KB
-rw-r--r--
2025-03-30 11:38
CPDServiceProvider_InvoiceFile_bv.php
7.28
KB
-rw-r--r--
2025-03-30 11:38
CPDServiceProvider_LearnerAssessProcedure_bv.php
7.12
KB
-rw-r--r--
2024-12-10 09:46
CPDServiceProvider_OtherVACPDSPNumberCertificate_bv.php
7.49
KB
-rw-r--r--
2025-03-30 11:38
CPDServiceProvider_PrevSPNumberCertificate_bv.php
7.42
KB
-rw-r--r--
2025-03-30 11:38
CPDServiceProvider_ProofOfPayment_bv.php
7.31
KB
-rw-r--r--
2025-03-30 11:38
CPDServiceProvideradd.php
219.49
KB
-rw-r--r--
2025-04-16 15:56
CPDServiceProviderdelete.php
60.68
KB
-rw-r--r--
2025-04-16 15:56
CPDServiceProvideredit.php
244.46
KB
-rw-r--r--
2025-04-16 15:56
CPDServiceProviderinfo.php
51.93
KB
-rw-r--r--
2025-04-16 15:56
CPDServiceProviderlist.php
204.5
KB
-rw-r--r--
2025-04-16 15:56
CPDServiceProvidermaster.php
7.74
KB
-rw-r--r--
2025-03-30 11:38
CPDServiceProviderview.php
166.72
KB
-rw-r--r--
2025-04-16 15:56
CPDStepsTakenTMadd.php
33.05
KB
-rw-r--r--
2022-09-15 19:16
CPDStepsTakenTMdelete.php
24.02
KB
-rw-r--r--
2022-09-15 19:16
CPDStepsTakenTMedit.php
39.11
KB
-rw-r--r--
2022-09-15 19:16
CPDStepsTakenTMinfo.php
26.47
KB
-rw-r--r--
2022-09-15 19:16
CPDStepsTakenTMlist.php
67.53
KB
-rw-r--r--
2022-09-15 19:16
CPDStepsTakenTMview.php
42.7
KB
-rw-r--r--
2022-09-15 19:16
CPDStepsTakenadd.php
27.91
KB
-rw-r--r--
2022-09-15 19:16
CPDStepsTakendelete.php
21.87
KB
-rw-r--r--
2022-09-15 19:16
CPDStepsTakenedit.php
34
KB
-rw-r--r--
2022-09-15 19:16
CPDStepsTakeninfo.php
24.84
KB
-rw-r--r--
2022-09-15 19:16
CPDStepsTakenlist.php
102.44
KB
-rw-r--r--
2022-09-15 19:16
CPDStepsTakenview.php
39.89
KB
-rw-r--r--
2022-09-15 21:50
CPDTMReviewadd.php
68.75
KB
-rw-r--r--
2022-09-15 19:16
CPDTMReviewdelete.php
30.53
KB
-rw-r--r--
2022-09-15 19:16
CPDTMReviewedit.php
68.14
KB
-rw-r--r--
2022-09-15 19:16
CPDTMReviewinfo.php
30.75
KB
-rw-r--r--
2022-09-15 19:16
CPDTMReviewlist.php
76.95
KB
-rw-r--r--
2022-09-15 19:16
CPDTMReviewview.php
58.41
KB
-rw-r--r--
2022-09-15 19:16
CPDTrainingMaterial_ActivityProgramme_bv.php
6.92
KB
-rw-r--r--
2023-08-24 13:47
CPDTrainingMaterial_AssessmentDoc_bv.php
6.87
KB
-rw-r--r--
2023-08-24 13:47
CPDTrainingMaterial_CourseBrochure_bv.php
6.88
KB
-rw-r--r--
2023-08-24 13:47
CPDTrainingMaterial_EvaluatorInvoice_bv.php
6.91
KB
-rw-r--r--
2023-08-24 13:47
CPDTrainingMaterial_EvaluatorTimesheet_bv.php
6.93
KB
-rw-r--r--
2023-08-24 13:47
CPDTrainingMaterial_FeedbackForm_bv.php
6.86
KB
-rw-r--r--
2023-08-24 13:47
CPDTrainingMaterial_InvoiceFile_bv.php
6.85
KB
-rw-r--r--
2023-08-24 13:47
CPDTrainingMaterial_LearningOutcomesFile_bv.php
6.95
KB
-rw-r--r--
2023-08-24 13:47
CPDTrainingMaterial_Presenter1CV_bv.php
6.86
KB
-rw-r--r--
2023-08-24 13:47
CPDTrainingMaterial_Presenter1IDDoc_bv.php
6.9
KB
-rw-r--r--
2025-01-14 11:59
CPDTrainingMaterial_Presenter1SLA_bv.php
6.87
KB
-rw-r--r--
2025-01-14 12:31
CPDTrainingMaterial_Presenter2CV_bv.php
6.86
KB
-rw-r--r--
2023-08-24 13:47
CPDTrainingMaterial_Presenter2IDDoc_bv.php
6.9
KB
-rw-r--r--
2025-01-14 11:59
CPDTrainingMaterial_Presenter2SLA_bv.php
6.87
KB
-rw-r--r--
2025-01-14 12:31
CPDTrainingMaterial_Presenter3CV_bv.php
6.86
KB
-rw-r--r--
2023-08-24 13:47
CPDTrainingMaterial_Presenter3IDDoc_bv.php
6.9
KB
-rw-r--r--
2025-01-14 11:59
CPDTrainingMaterial_Presenter3SLA_bv.php
6.87
KB
-rw-r--r--
2025-01-14 12:31
CPDTrainingMaterial_ProofOfPayment_bv.php
6.88
KB
-rw-r--r--
2023-08-24 13:47
CPDTrainingMaterialadd.php
312.71
KB
-rw-r--r--
2025-05-20 07:41
CPDTrainingMaterialdelete.php
69.75
KB
-rw-r--r--
2025-05-20 07:41
CPDTrainingMaterialedit.php
367.27
KB
-rw-r--r--
2025-05-20 07:41
CPDTrainingMaterialinfo.php
61.66
KB
-rw-r--r--
2025-05-20 07:41
CPDTrainingMateriallist.php
220.65
KB
-rw-r--r--
2025-05-20 07:41
CPDTrainingMaterialmaster.php
5.84
KB
-rw-r--r--
2024-09-18 11:13
CPDTrainingMaterialview.php
222.22
KB
-rw-r--r--
2025-05-20 07:41
SpryMenuBarHorizontal.css
5.52
KB
-rw-r--r--
2022-04-19 06:59
SpryMenuBarVertical.css
4.52
KB
-rw-r--r--
2022-04-19 06:59
changepwd.php
10.52
KB
-rw-r--r--
2023-02-11 10:44
cstReviewProgressinfo.php
21.94
KB
-rw-r--r--
2022-09-15 19:16
cstReviewProgresslist.php
65.64
KB
-rw-r--r--
2022-09-15 19:16
echasl23add.php
29.32
KB
-rw-r--r--
2022-09-15 21:50
echasl23delete.php
21.56
KB
-rw-r--r--
2022-09-15 21:50
echasl23edit.php
31.02
KB
-rw-r--r--
2022-09-15 21:50
echasl23info.php
24.92
KB
-rw-r--r--
2022-09-15 21:50
echasl23list.php
70.56
KB
-rw-r--r--
2022-09-15 21:50
echasl23srch.php
32.07
KB
-rw-r--r--
2022-09-15 21:50
echasl23view.php
39.44
KB
-rw-r--r--
2022-09-15 21:50
ewbv7.php
1.88
KB
-rw-r--r--
2022-04-19 06:59
ewcfg7.php
68.37
KB
-rw-r--r--
2026-08-24 10:13
ewemail7.php
1.87
KB
-rw-r--r--
2022-04-19 06:59
ewlookup7.php
2.8
KB
-rw-r--r--
2022-04-19 06:59
ewmenu.php
2.14
KB
-rw-r--r--
2024-09-18 11:13
ewmysql7.php
29.43
KB
-rw-r--r--
2026-08-20 18:36
ewshared7.php
26.13
KB
-rw-r--r--
2023-03-08 11:59
footer.php
2.48
KB
-rw-r--r--
2025-06-24 07:24
forgotpwd.php
13.11
KB
-rw-r--r--
2023-02-11 10:44
genspcertificate.php
2.74
KB
-rw-r--r--
2025-07-14 12:09
gentmcertificate.php
4.46
KB
-rw-r--r--
2025-09-12 09:17
header.php
5.62
KB
-rw-r--r--
2022-04-19 08:00
inc_functions.php
15.82
KB
-rw-r--r--
2026-08-14 12:06
index.php
6.01
KB
-rw-r--r--
2023-02-11 10:44
login.php
18.09
KB
-rw-r--r--
2023-02-11 10:44
logout.php
6.14
KB
-rw-r--r--
2023-03-10 10:31
php_errors.log
36.69
KB
-rw-r--r--
2026-08-20 18:36
phpfn7.php
142.58
KB
-rw-r--r--
2026-08-24 10:13
userfn7.php
355
B
-rw-r--r--
2023-02-10 11:50
userlevelpermissionsadd.php
27.07
KB
-rw-r--r--
2022-09-15 19:16
userlevelpermissionsdelete.php
19.54
KB
-rw-r--r--
2022-09-15 19:16
userlevelpermissionsedit.php
26.11
KB
-rw-r--r--
2022-09-15 19:16
userlevelpermissionsinfo.php
21.32
KB
-rw-r--r--
2022-09-15 19:16
userlevelpermissionslist.php
67.92
KB
-rw-r--r--
2022-09-15 19:16
userlevelpermissionssrch.php
21.52
KB
-rw-r--r--
2022-09-15 19:16
userlevelpermissionsview.php
36.58
KB
-rw-r--r--
2022-09-15 19:16
userlevelsadd.php
24.5
KB
-rw-r--r--
2022-09-15 19:16
userlevelsdelete.php
16.89
KB
-rw-r--r--
2022-09-15 19:16
userlevelsedit.php
20.2
KB
-rw-r--r--
2022-09-15 19:16
userlevelsinfo.php
18.72
KB
-rw-r--r--
2022-09-15 19:16
userlevelslist.php
58.24
KB
-rw-r--r--
2022-09-15 19:16
userlevelsmaster.php
1.69
KB
-rw-r--r--
2022-09-15 19:16
userlevelssrch.php
17.79
KB
-rw-r--r--
2022-09-15 19:16
userlevelsview.php
32.56
KB
-rw-r--r--
2022-09-15 19:16
userpriv.php
14.51
KB
-rw-r--r--
2023-02-11 10:44
vwCPD_SPExpiredNotRenewedinfo.php
49.76
KB
-rw-r--r--
2024-09-18 11:03
vwCPD_SPExpiredNotRenewedlist.php
129.54
KB
-rw-r--r--
2024-09-18 11:03
vwCPD_SPExpiredNotRenewedmaster.php
10.96
KB
-rw-r--r--
2024-09-18 11:03
vwCPD_SPLatestinfo.php
53.45
KB
-rw-r--r--
2024-09-18 11:03
vwCPD_SPLatestlist.php
130.76
KB
-rw-r--r--
2024-09-18 11:03
vwCPD_SPLatestmaster.php
14.99
KB
-rw-r--r--
2024-09-18 11:03
xenon.css
0
B
-rw-r--r--
2025-06-24 07:25
Save
Rename
<?php session_start(); // Initialize Session data ob_start(); // Turn on output buffering ?> <?php include "ewcfg7.php" ?> <?php include "ewmysql7.php" ?> <?php include "phpfn7.php" ?> <?php include "CPDServiceProviderinfo.php" ?> <?php include "CPDAdminUsersinfo.php" ?> <?php include "vwCPD_SPExpiredNotRenewedinfo.php" ?> <?php include "vwCPD_SPLatestinfo.php" ?> <?php include "userfn7.php" ?> <?php header("Expires: Mon, 26 Jul 1997 05:00:00 GMT"); // Date in the past header("Last-Modified: " . gmdate("D, d M Y H:i:s") . " GMT"); // Always modified header("Cache-Control: private, no-store, no-cache, must-revalidate"); // HTTP/1.1 header("Cache-Control: post-check=0, pre-check=0", false); header("Pragma: no-cache"); // HTTP/1.0 ?> <?php // Create page object $CPDServiceProvider_delete = new cCPDServiceProvider_delete(); $Page =& $CPDServiceProvider_delete; // Page init $CPDServiceProvider_delete->Page_Init(); // Page main $CPDServiceProvider_delete->Page_Main(); ?> <?php include "header.php" ?> <script type="text/javascript"> <!-- // Create page object var CPDServiceProvider_delete = new ew_Page("CPDServiceProvider_delete"); // page properties CPDServiceProvider_delete.PageID = "delete"; // page ID CPDServiceProvider_delete.FormID = "fCPDServiceProviderdelete"; // form ID var EW_PAGE_ID = CPDServiceProvider_delete.PageID; // for backward compatibility // extend page with Form_CustomValidate function CPDServiceProvider_delete.Form_CustomValidate = function(fobj) { // DO NOT CHANGE THIS LINE! // Your custom validation code here, return false if invalid. return true; } <?php if (EW_CLIENT_VALIDATE) { ?> CPDServiceProvider_delete.ValidateRequired = true; // uses JavaScript validation <?php } else { ?> CPDServiceProvider_delete.ValidateRequired = false; // no JavaScript validation <?php } ?> //--> </script> <script language="JavaScript" type="text/javascript"> <!-- // Write your client script here, no need to add script tags. // To include another .js script, use: // ew_ClientScriptInclude("my_javascript.js"); //--> </script> <?php // Load records for display if ($rs = $CPDServiceProvider_delete->LoadRecordset()) $CPDServiceProvider_deletelTotalRecs = $rs->RecordCount(); // Get record count if ($CPDServiceProvider_deletelTotalRecs <= 0) { // No record found, exit if ($rs) $rs->Close(); $CPDServiceProvider_delete->Page_Terminate("CPDServiceProviderlist.php"); // Return to list } ?> <p><span class="phpmaker"><?php echo $Language->Phrase("Delete") ?> <?php echo $Language->Phrase("TblTypeTABLE") ?><?php echo $CPDServiceProvider->TableCaption() ?><br><br> <a href="<?php echo $CPDServiceProvider->getReturnUrl() ?>"><?php echo $Language->Phrase("GoBack") ?></a></span></p> <?php if (EW_DEBUG_ENABLED) echo ew_DebugMsg(); $CPDServiceProvider_delete->ShowMessage(); ?> <form action="<?php echo ew_CurrentPage() ?>" method="post"> <p> <input type="hidden" name="t" id="t" value="CPDServiceProvider"> <input type="hidden" name="a_delete" id="a_delete" value="D"> <?php foreach ($CPDServiceProvider_delete->arRecKeys as $key) { ?> <input type="hidden" name="key_m[]" id="key_m[]" value="<?php echo ew_HtmlEncode($key) ?>"> <?php } ?> <table class="ewGrid"><tr><td class="ewGridContent"> <div class="ewGridMiddlePanel"> <table cellspacing="0" class="ewTable ewTableSeparate"> <?php echo $CPDServiceProvider->TableCustomInnerHtml ?> <thead> <tr class="ewTableHeader"> <td valign="top"><?php echo $CPDServiceProvider->CompanyName->FldCaption() ?></td> <td valign="top"><?php echo $CPDServiceProvider->TradingAs->FldCaption() ?></td> <td valign="top"><?php echo $CPDServiceProvider->EmailAddress->FldCaption() ?></td> <td valign="top"><?php echo $CPDServiceProvider->ContactFirstName->FldCaption() ?></td> <td valign="top"><?php echo $CPDServiceProvider->ContactSurname->FldCaption() ?></td> <td valign="top"><?php echo $CPDServiceProvider->Approved->FldCaption() ?></td> <td valign="top"><?php echo $CPDServiceProvider->SPNumber->FldCaption() ?></td> <td valign="top"><?php echo $CPDServiceProvider->DateUpdated->FldCaption() ?></td> <td valign="top"><?php echo $CPDServiceProvider->DateAssessed->FldCaption() ?></td> <td valign="top"><?php echo $CPDServiceProvider->DateExpires->FldCaption() ?></td> <td valign="top"><?php echo $CPDServiceProvider->DatePaid->FldCaption() ?></td> <td valign="top"><?php echo $CPDServiceProvider->LastReminder->FldCaption() ?></td> </tr> </thead> <tbody> <?php $CPDServiceProvider_delete->lRecCnt = 0; $i = 0; while (!$rs->EOF) { $CPDServiceProvider_delete->lRecCnt++; // Set row properties $CPDServiceProvider->CssClass = ""; $CPDServiceProvider->CssStyle = ""; $CPDServiceProvider->RowAttrs = array(); $CPDServiceProvider->RowType = EW_ROWTYPE_VIEW; // View // Get the field contents $CPDServiceProvider_delete->LoadRowValues($rs); // Render row $CPDServiceProvider_delete->RenderRow(); ?> <tr<?php echo $CPDServiceProvider->RowAttributes() ?>> <td<?php echo $CPDServiceProvider->CompanyName->CellAttributes() ?>> <div<?php echo $CPDServiceProvider->CompanyName->ViewAttributes() ?>><?php echo $CPDServiceProvider->CompanyName->ListViewValue() ?></div></td> <td<?php echo $CPDServiceProvider->TradingAs->CellAttributes() ?>> <div<?php echo $CPDServiceProvider->TradingAs->ViewAttributes() ?>><?php echo $CPDServiceProvider->TradingAs->ListViewValue() ?></div></td> <td<?php echo $CPDServiceProvider->EmailAddress->CellAttributes() ?>> <div<?php echo $CPDServiceProvider->EmailAddress->ViewAttributes() ?>><?php echo $CPDServiceProvider->EmailAddress->ListViewValue() ?></div></td> <td<?php echo $CPDServiceProvider->ContactFirstName->CellAttributes() ?>> <div<?php echo $CPDServiceProvider->ContactFirstName->ViewAttributes() ?>><?php echo $CPDServiceProvider->ContactFirstName->ListViewValue() ?></div></td> <td<?php echo $CPDServiceProvider->ContactSurname->CellAttributes() ?>> <div<?php echo $CPDServiceProvider->ContactSurname->ViewAttributes() ?>><?php echo $CPDServiceProvider->ContactSurname->ListViewValue() ?></div></td> <td<?php echo $CPDServiceProvider->Approved->CellAttributes() ?>> <div<?php echo $CPDServiceProvider->Approved->ViewAttributes() ?>><?php echo $CPDServiceProvider->Approved->ListViewValue() ?></div></td> <td<?php echo $CPDServiceProvider->SPNumber->CellAttributes() ?>> <div<?php echo $CPDServiceProvider->SPNumber->ViewAttributes() ?>><?php echo $CPDServiceProvider->SPNumber->ListViewValue() ?></div></td> <td<?php echo $CPDServiceProvider->DateUpdated->CellAttributes() ?>> <div<?php echo $CPDServiceProvider->DateUpdated->ViewAttributes() ?>><?php echo $CPDServiceProvider->DateUpdated->ListViewValue() ?></div></td> <td<?php echo $CPDServiceProvider->DateAssessed->CellAttributes() ?>> <div<?php echo $CPDServiceProvider->DateAssessed->ViewAttributes() ?>><?php echo $CPDServiceProvider->DateAssessed->ListViewValue() ?></div></td> <td<?php echo $CPDServiceProvider->DateExpires->CellAttributes() ?>> <div<?php echo $CPDServiceProvider->DateExpires->ViewAttributes() ?>><?php echo $CPDServiceProvider->DateExpires->ListViewValue() ?></div></td> <td<?php echo $CPDServiceProvider->DatePaid->CellAttributes() ?>> <div<?php echo $CPDServiceProvider->DatePaid->ViewAttributes() ?>><?php echo $CPDServiceProvider->DatePaid->ListViewValue() ?></div></td> <td<?php echo $CPDServiceProvider->LastReminder->CellAttributes() ?>> <div<?php echo $CPDServiceProvider->LastReminder->ViewAttributes() ?>><?php echo $CPDServiceProvider->LastReminder->ListViewValue() ?></div></td> </tr> <?php $rs->MoveNext(); } $rs->Close(); ?> </tbody> </table> </div> </td></tr></table> <p> <input type="submit" name="Action" id="Action" value="<?php echo ew_BtnCaption($Language->Phrase("DeleteBtn")) ?>"> </form> <script language="JavaScript" type="text/javascript"> <!-- // Write your table-specific startup script here // document.write("page loaded"); //--> </script> <?php include "footer.php" ?> <?php $CPDServiceProvider_delete->Page_Terminate(); ?> <?php // // Page class // class cCPDServiceProvider_delete { // Page ID var $PageID = 'delete'; // Table name var $TableName = 'CPDServiceProvider'; // Page object name var $PageObjName = 'CPDServiceProvider_delete'; // Page name function PageName() { return ew_CurrentPage(); } // Page URL function PageUrl() { $PageUrl = ew_CurrentPage() . "?"; global $CPDServiceProvider; if ($CPDServiceProvider->UseTokenInUrl) $PageUrl .= "t=" . $CPDServiceProvider->TableVar . "&"; // Add page token return $PageUrl; } // Page URLs var $AddUrl; var $EditUrl; var $CopyUrl; var $DeleteUrl; var $ViewUrl; var $ListUrl; // Export URLs var $ExportPrintUrl; var $ExportHtmlUrl; var $ExportExcelUrl; var $ExportWordUrl; var $ExportXmlUrl; var $ExportCsvUrl; // Update URLs var $InlineAddUrl; var $InlineCopyUrl; var $InlineEditUrl; var $GridAddUrl; var $GridEditUrl; var $MultiDeleteUrl; var $MultiUpdateUrl; // Message function getMessage() { return @$_SESSION[EW_SESSION_MESSAGE]; } function setMessage($v) { if (@$_SESSION[EW_SESSION_MESSAGE] <> "") { // Append $_SESSION[EW_SESSION_MESSAGE] .= "<br>" . $v; } else { $_SESSION[EW_SESSION_MESSAGE] = $v; } } // Show message function ShowMessage() { $sMessage = $this->getMessage(); $this->Message_Showing($sMessage); if ($sMessage <> "") { // Message in Session, display echo "<p><span class=\"ewMessage\">" . $sMessage . "</span></p>"; $_SESSION[EW_SESSION_MESSAGE] = ""; // Clear message in Session } } // Validate page request function IsPageRequest() { global $objForm, $CPDServiceProvider; if ($CPDServiceProvider->UseTokenInUrl) { if ($objForm) return ($CPDServiceProvider->TableVar == $objForm->GetValue("t")); if (@$_GET["t"] <> "") return ($CPDServiceProvider->TableVar == $_GET["t"]); } else { return TRUE; } } // // Page class constructor // function __construct() { global $conn, $Language; // Language object $Language = new cLanguage(); // Table object (CPDServiceProvider) $GLOBALS["CPDServiceProvider"] = new cCPDServiceProvider(); // Table object (CPDAdminUsers) $GLOBALS['CPDAdminUsers'] = new cCPDAdminUsers(); // Table object (vwCPD_SPExpiredNotRenewed) $GLOBALS['vwCPD_SPExpiredNotRenewed'] = new cvwCPD_SPExpiredNotRenewed(); // Table object (vwCPD_SPLatest) $GLOBALS['vwCPD_SPLatest'] = new cvwCPD_SPLatest(); // Page ID if (!defined("EW_PAGE_ID")) define("EW_PAGE_ID", 'delete', TRUE); // Table name (for backward compatibility) if (!defined("EW_TABLE_NAME")) define("EW_TABLE_NAME", 'CPDServiceProvider', TRUE); // Start timer $GLOBALS["gsTimer"] = new cTimer(); // Open connection $conn = ew_Connect(); } // // Page_Init // function Page_Init() { global $gsExport, $gsExportFile, $UserProfile, $Language, $Security, $objForm; global $CPDServiceProvider; // User profile $UserProfile = new cUserProfile(); $UserProfile->LoadProfile(@$_SESSION[EW_SESSION_USER_PROFILE]); // Security $Security = new cAdvancedSecurity(); if (IsPasswordExpired()) $this->Page_Terminate("changepwd.php"); if (!$Security->IsLoggedIn()) $Security->AutoLogin(); if (!$Security->IsLoggedIn()) { $Security->SaveLastUrl(); $this->Page_Terminate("login.php"); } // Global Page Loading event (in userfn*.php) Page_Loading(); // Page Load event $this->Page_Load(); } // // Page_Terminate // function Page_Terminate($url = "") { global $conn; // Page Unload event $this->Page_Unload(); // Global Page Unloaded event (in userfn*.php) Page_Unloaded(); // Close connection $conn->Close(); // Go to URL if specified $this->Page_Redirecting($url); if ($url <> "") { if (!EW_DEBUG_ENABLED && ob_get_length()) ob_end_clean(); header("Location: " . $url); } exit(); } var $lTotalRecs = 0; var $lRecCnt; var $arRecKeys = array(); // // Page main // function Page_Main() { global $Language, $CPDServiceProvider; // Load key parameters $sKey = ""; $bSingleDelete = TRUE; // Initialize as single delete $nKeySelected = 0; // Initialize selected key count $sFilter = ""; if (@$_GET["CPDProviderID"] <> "") { $CPDServiceProvider->CPDProviderID->setQueryStringValue($_GET["CPDProviderID"]); if (!is_numeric($CPDServiceProvider->CPDProviderID->QueryStringValue)) $this->Page_Terminate("CPDServiceProviderlist.php"); // Prevent SQL injection, exit $sKey .= $CPDServiceProvider->CPDProviderID->QueryStringValue; } else { $bSingleDelete = FALSE; } if ($bSingleDelete) { $nKeySelected = 1; // Set up key selected count $this->arRecKeys[0] = $sKey; } else { if (isset($_POST["key_m"])) { // Key in form $nKeySelected = count($_POST["key_m"]); // Set up key selected count $this->arRecKeys = ew_StripSlashes($_POST["key_m"]); } } if ($nKeySelected <= 0) $this->Page_Terminate("CPDServiceProviderlist.php"); // No key specified, return to list // Build filter foreach ($this->arRecKeys as $sKey) { $sFilter .= "("; // Set up key field $sKeyFld = $sKey; if (!is_numeric($sKeyFld)) $this->Page_Terminate("CPDServiceProviderlist.php"); // Prevent SQL injection, return to list $sFilter .= "`CPDProviderID`=" . ew_AdjustSql($sKeyFld) . " AND "; if (substr($sFilter, -5) == " AND ") $sFilter = substr($sFilter, 0, strlen($sFilter)-5) . ") OR "; } if (substr($sFilter, -4) == " OR ") $sFilter = substr($sFilter, 0, strlen($sFilter)-4); // Set up filter (SQL WHHERE clause) and get return SQL // SQL constructor in CPDServiceProvider class, CPDServiceProviderinfo.php $CPDServiceProvider->CurrentFilter = $sFilter; // Get action if (@$_POST["a_delete"] <> "") { $CPDServiceProvider->CurrentAction = $_POST["a_delete"]; } else { $CPDServiceProvider->CurrentAction = "I"; // Display record } switch ($CPDServiceProvider->CurrentAction) { case "D": // Delete $CPDServiceProvider->SendEmail = TRUE; // Send email on delete success if ($this->DeleteRows()) { // delete rows $this->setMessage($Language->Phrase("DeleteSuccess")); // Set up success message $this->Page_Terminate($CPDServiceProvider->getReturnUrl()); // Return to caller } } } // // Delete records based on current filter // function DeleteRows() { global $conn, $Language, $Security, $CPDServiceProvider; $DeleteRows = TRUE; $sWrkFilter = $CPDServiceProvider->CurrentFilter; // Set up filter (SQL WHERE clause) and get return SQL // SQL constructor in CPDServiceProvider class, CPDServiceProviderinfo.php $CPDServiceProvider->CurrentFilter = $sWrkFilter; $sSql = $CPDServiceProvider->SQL(); $conn->raiseErrorFn = 'ew_ErrorFn'; $rs = $conn->Execute($sSql); $conn->raiseErrorFn = ''; if ($rs === FALSE) { return FALSE; } elseif ($rs->EOF) { $this->setMessage($Language->Phrase("NoRecord")); // No record found $rs->Close(); return FALSE; } $conn->BeginTrans(); // Clone old rows $rsold = ($rs) ? $rs->GetRows() : array(); if ($rs) $rs->Close(); // Call row deleting event if ($DeleteRows) { foreach ($rsold as $row) { $DeleteRows = $CPDServiceProvider->Row_Deleting($row); if (!$DeleteRows) break; } } if ($DeleteRows) { $sKey = ""; foreach ($rsold as $row) { $sThisKey = ""; if ($sThisKey <> "") $sThisKey .= EW_COMPOSITE_KEY_SEPARATOR; $sThisKey .= $row['CPDProviderID']; @unlink(ew_UploadPathEx(TRUE, $CPDServiceProvider->InvoiceFile->UploadPath) . $row['InvoiceFile']); @unlink(ew_UploadPathEx(TRUE, $CPDServiceProvider->ProofOfPayment->UploadPath) . $row['ProofOfPayment']); @unlink(ew_UploadPathEx(TRUE, $CPDServiceProvider->EvaluatorInvoice->UploadPath) . $row['EvaluatorInvoice']); @unlink(ew_UploadPathEx(TRUE, $CPDServiceProvider->EvaluatorTimesheet->UploadPath) . $row['EvaluatorTimesheet']); @unlink(ew_UploadPathEx(TRUE, $CPDServiceProvider->PrevSPNumberCertificate->UploadPath) . $row['PrevSPNumberCertificate']); @unlink(ew_UploadPathEx(TRUE, $CPDServiceProvider->OtherVACPDSPNumberCertificate->UploadPath) . $row['OtherVACPDSPNumberCertificate']); @unlink(ew_UploadPathEx(TRUE, $CPDServiceProvider->AccountabilityStructure->UploadPath) . $row['AccountabilityStructure']); $conn->raiseErrorFn = 'ew_ErrorFn'; $DeleteRows = $conn->Execute($CPDServiceProvider->DeleteSQL($row)); // Delete $conn->raiseErrorFn = ''; if ($DeleteRows === FALSE) break; if ($sKey <> "") $sKey .= ", "; $sKey .= $sThisKey; } } else { // Set up error message if ($CPDServiceProvider->CancelMessage <> "") { $this->setMessage($CPDServiceProvider->CancelMessage); $CPDServiceProvider->CancelMessage = ""; } else { $this->setMessage($Language->Phrase("DeleteCancelled")); } } if ($DeleteRows) { $conn->CommitTrans(); // Commit the changes } else { $conn->RollbackTrans(); // Rollback changes } // Call Row Deleted event if ($DeleteRows) { foreach ($rsold as $row) { $CPDServiceProvider->Row_Deleted($row); } } return $DeleteRows; } // Load recordset function LoadRecordset($offset = -1, $rowcnt = -1) { global $conn, $CPDServiceProvider; // Call Recordset Selecting event $CPDServiceProvider->Recordset_Selecting($CPDServiceProvider->CurrentFilter); // Load List page SQL $sSql = $CPDServiceProvider->SelectSQL(); if ($offset > -1 && $rowcnt > -1) $sSql .= " LIMIT $offset, $rowcnt"; // Load recordset $rs = ew_LoadRecordset($sSql); // Call Recordset Selected event $CPDServiceProvider->Recordset_Selected($rs); return $rs; } // Load row based on key values function LoadRow() { global $conn, $Security, $CPDServiceProvider; $sFilter = $CPDServiceProvider->KeyFilter(); // Call Row Selecting event $CPDServiceProvider->Row_Selecting($sFilter); // Load SQL based on filter $CPDServiceProvider->CurrentFilter = $sFilter; $sSql = $CPDServiceProvider->SQL(); $res = FALSE; $rs = ew_LoadRecordset($sSql); if ($rs && !$rs->EOF) { $res = TRUE; $this->LoadRowValues($rs); // Load row values // Call Row Selected event $CPDServiceProvider->Row_Selected($rs); $rs->Close(); } return $res; } // Load row values from recordset function LoadRowValues(&$rs) { global $conn, $CPDServiceProvider; $CPDServiceProvider->CPDProviderID->setDbValue($rs->fields('CPDProviderID')); $CPDServiceProvider->CompanyName->setDbValue($rs->fields('CompanyName')); $CPDServiceProvider->TradingAs->setDbValue($rs->fields('TradingAs')); $CPDServiceProvider->PhoneNumber->setDbValue($rs->fields('PhoneNumber')); $CPDServiceProvider->CellNumber->setDbValue($rs->fields('CellNumber')); $CPDServiceProvider->EmailAddress->setDbValue($rs->fields('EmailAddress')); $CPDServiceProvider->Website->setDbValue($rs->fields('Website')); $CPDServiceProvider->VATNumber->setDbValue($rs->fields('VATNumber')); $CPDServiceProvider->PhysicalAddress1->setDbValue($rs->fields('PhysicalAddress1')); $CPDServiceProvider->PhysicalAddress2->setDbValue($rs->fields('PhysicalAddress2')); $CPDServiceProvider->PhysicalCity->setDbValue($rs->fields('PhysicalCity')); $CPDServiceProvider->PhysicalCode->setDbValue($rs->fields('PhysicalCode')); $CPDServiceProvider->PhysicalProvince->setDbValue($rs->fields('PhysicalProvince')); $CPDServiceProvider->PhysicalCountry->setDbValue($rs->fields('PhysicalCountry')); $CPDServiceProvider->PostalAddress1->setDbValue($rs->fields('PostalAddress1')); $CPDServiceProvider->PostalAddress2->setDbValue($rs->fields('PostalAddress2')); $CPDServiceProvider->PostalCity->setDbValue($rs->fields('PostalCity')); $CPDServiceProvider->PostalCode->setDbValue($rs->fields('PostalCode')); $CPDServiceProvider->PostalProvince->setDbValue($rs->fields('PostalProvince')); $CPDServiceProvider->PostalCountry->setDbValue($rs->fields('PostalCountry')); $CPDServiceProvider->Password->setDbValue($rs->fields('Password')); $CPDServiceProvider->UpdatedBy->setDbValue($rs->fields('UpdatedBy')); $CPDServiceProvider->Archived->setDbValue($rs->fields('Archived')); $CPDServiceProvider->ContactTitle->setDbValue($rs->fields('ContactTitle')); $CPDServiceProvider->ContactInitials->setDbValue($rs->fields('ContactInitials')); $CPDServiceProvider->ContactFirstName->setDbValue($rs->fields('ContactFirstName')); $CPDServiceProvider->ContactSurname->setDbValue($rs->fields('ContactSurname')); $CPDServiceProvider->ContactPosition->setDbValue($rs->fields('ContactPosition')); $CPDServiceProvider->ContactPhone->setDbValue($rs->fields('ContactPhone')); $CPDServiceProvider->ContactCell->setDbValue($rs->fields('ContactCell')); $CPDServiceProvider->ContactEmail->setDbValue($rs->fields('ContactEmail')); $CPDServiceProvider->ContactIDNum->setDbValue($rs->fields('ContactIDNum')); $CPDServiceProvider->AdminTitle->setDbValue($rs->fields('AdminTitle')); $CPDServiceProvider->AdminInitials->setDbValue($rs->fields('AdminInitials')); $CPDServiceProvider->AdminFirstName->setDbValue($rs->fields('AdminFirstName')); $CPDServiceProvider->AdminSurname->setDbValue($rs->fields('AdminSurname')); $CPDServiceProvider->AdminPosition->setDbValue($rs->fields('AdminPosition')); $CPDServiceProvider->AdminPhone->setDbValue($rs->fields('AdminPhone')); $CPDServiceProvider->AdminCell->setDbValue($rs->fields('AdminCell')); $CPDServiceProvider->AdminEmail->setDbValue($rs->fields('AdminEmail')); $CPDServiceProvider->AdminIDNum->setDbValue($rs->fields('AdminIDNum')); $CPDServiceProvider->EvaluatorID->setDbValue($rs->fields('EvaluatorID')); $CPDServiceProvider->EvaluatorID2->setDbValue($rs->fields('EvaluatorID2')); $CPDServiceProvider->EvaluatorID3->setDbValue($rs->fields('EvaluatorID3')); $CPDServiceProvider->Approved->setDbValue($rs->fields('Approved')); $CPDServiceProvider->SPNumber->setDbValue($rs->fields('SPNumber')); $CPDServiceProvider->DateUpdated->setDbValue($rs->fields('DateUpdated')); $CPDServiceProvider->DateAssessed->setDbValue($rs->fields('DateAssessed')); $CPDServiceProvider->DateExpires->setDbValue($rs->fields('DateExpires')); $CPDServiceProvider->InvoiceCode->setDbValue($rs->fields('InvoiceCode')); $CPDServiceProvider->InvoiceNumber->setDbValue($rs->fields('InvoiceNumber')); $CPDServiceProvider->Cost->setDbValue($rs->fields('Cost')); $CPDServiceProvider->InvoiceDate->setDbValue($rs->fields('InvoiceDate')); $CPDServiceProvider->DepositAmt->setDbValue($rs->fields('DepositAmt')); $CPDServiceProvider->DatePaid->setDbValue($rs->fields('DatePaid')); $CPDServiceProvider->InvoiceFile->Upload->DbValue = $rs->fields('InvoiceFile'); $CPDServiceProvider->ProofOfPayment->Upload->DbValue = $rs->fields('ProofOfPayment'); $CPDServiceProvider->EvaluatorFee->setDbValue($rs->fields('EvaluatorFee')); $CPDServiceProvider->EvaluatorFeeAmount->setDbValue($rs->fields('EvaluatorFeeAmount')); $CPDServiceProvider->EvaluatorFeeDate->setDbValue($rs->fields('EvaluatorFeeDate')); $CPDServiceProvider->EvaluatorInvoice->Upload->DbValue = $rs->fields('EvaluatorInvoice'); $CPDServiceProvider->EvaluatorTimesheet->Upload->DbValue = $rs->fields('EvaluatorTimesheet'); $CPDServiceProvider->Comments->setDbValue($rs->fields('Comments')); $CPDServiceProvider->NumReminders->setDbValue($rs->fields('NumReminders')); $CPDServiceProvider->LastReminder->setDbValue($rs->fields('LastReminder')); $CPDServiceProvider->PrevSPNumber->setDbValue($rs->fields('PrevSPNumber')); $CPDServiceProvider->PrevSPNumberCertificate->Upload->DbValue = $rs->fields('PrevSPNumberCertificate'); $CPDServiceProvider->OtherVACPDSPNumber->setDbValue($rs->fields('OtherVACPDSPNumber')); $CPDServiceProvider->OtherVACPDSPNumberCertificate->Upload->DbValue = $rs->fields('OtherVACPDSPNumberCertificate'); $CPDServiceProvider->Renewal->setDbValue($rs->fields('Renewal')); $CPDServiceProvider->DateCreated->setDbValue($rs->fields('DateCreated')); $CPDServiceProvider->AccountabilityStructure->Upload->DbValue = $rs->fields('AccountabilityStructure'); } // Render row values based on field settings function RenderRow() { global $conn, $Security, $Language, $CPDServiceProvider; // Initialize URLs // Call Row_Rendering event $CPDServiceProvider->Row_Rendering(); // Common render codes for all row types // CompanyName $CPDServiceProvider->CompanyName->CellCssStyle = ""; $CPDServiceProvider->CompanyName->CellCssClass = ""; $CPDServiceProvider->CompanyName->CellAttrs = array(); $CPDServiceProvider->CompanyName->ViewAttrs = array(); $CPDServiceProvider->CompanyName->EditAttrs = array(); // TradingAs $CPDServiceProvider->TradingAs->CellCssStyle = ""; $CPDServiceProvider->TradingAs->CellCssClass = ""; $CPDServiceProvider->TradingAs->CellAttrs = array(); $CPDServiceProvider->TradingAs->ViewAttrs = array(); $CPDServiceProvider->TradingAs->EditAttrs = array(); // EmailAddress $CPDServiceProvider->EmailAddress->CellCssStyle = ""; $CPDServiceProvider->EmailAddress->CellCssClass = ""; $CPDServiceProvider->EmailAddress->CellAttrs = array(); $CPDServiceProvider->EmailAddress->ViewAttrs = array(); $CPDServiceProvider->EmailAddress->EditAttrs = array(); // ContactFirstName $CPDServiceProvider->ContactFirstName->CellCssStyle = ""; $CPDServiceProvider->ContactFirstName->CellCssClass = ""; $CPDServiceProvider->ContactFirstName->CellAttrs = array(); $CPDServiceProvider->ContactFirstName->ViewAttrs = array(); $CPDServiceProvider->ContactFirstName->EditAttrs = array(); // ContactSurname $CPDServiceProvider->ContactSurname->CellCssStyle = ""; $CPDServiceProvider->ContactSurname->CellCssClass = ""; $CPDServiceProvider->ContactSurname->CellAttrs = array(); $CPDServiceProvider->ContactSurname->ViewAttrs = array(); $CPDServiceProvider->ContactSurname->EditAttrs = array(); // Approved $CPDServiceProvider->Approved->CellCssStyle = ""; $CPDServiceProvider->Approved->CellCssClass = ""; $CPDServiceProvider->Approved->CellAttrs = array(); $CPDServiceProvider->Approved->ViewAttrs = array(); $CPDServiceProvider->Approved->EditAttrs = array(); // SPNumber $CPDServiceProvider->SPNumber->CellCssStyle = ""; $CPDServiceProvider->SPNumber->CellCssClass = ""; $CPDServiceProvider->SPNumber->CellAttrs = array(); $CPDServiceProvider->SPNumber->ViewAttrs = array(); $CPDServiceProvider->SPNumber->EditAttrs = array(); // DateUpdated $CPDServiceProvider->DateUpdated->CellCssStyle = ""; $CPDServiceProvider->DateUpdated->CellCssClass = ""; $CPDServiceProvider->DateUpdated->CellAttrs = array(); $CPDServiceProvider->DateUpdated->ViewAttrs = array(); $CPDServiceProvider->DateUpdated->EditAttrs = array(); // DateAssessed $CPDServiceProvider->DateAssessed->CellCssStyle = ""; $CPDServiceProvider->DateAssessed->CellCssClass = ""; $CPDServiceProvider->DateAssessed->CellAttrs = array(); $CPDServiceProvider->DateAssessed->ViewAttrs = array(); $CPDServiceProvider->DateAssessed->EditAttrs = array(); // DateExpires $CPDServiceProvider->DateExpires->CellCssStyle = ""; $CPDServiceProvider->DateExpires->CellCssClass = ""; $CPDServiceProvider->DateExpires->CellAttrs = array(); $CPDServiceProvider->DateExpires->ViewAttrs = array(); $CPDServiceProvider->DateExpires->EditAttrs = array(); // DatePaid $CPDServiceProvider->DatePaid->CellCssStyle = ""; $CPDServiceProvider->DatePaid->CellCssClass = ""; $CPDServiceProvider->DatePaid->CellAttrs = array(); $CPDServiceProvider->DatePaid->ViewAttrs = array(); $CPDServiceProvider->DatePaid->EditAttrs = array(); // LastReminder $CPDServiceProvider->LastReminder->CellCssStyle = ""; $CPDServiceProvider->LastReminder->CellCssClass = ""; $CPDServiceProvider->LastReminder->CellAttrs = array(); $CPDServiceProvider->LastReminder->ViewAttrs = array(); $CPDServiceProvider->LastReminder->EditAttrs = array(); if ($CPDServiceProvider->RowType == EW_ROWTYPE_VIEW) { // View row // CPDProviderID $CPDServiceProvider->CPDProviderID->ViewValue = $CPDServiceProvider->CPDProviderID->CurrentValue; $CPDServiceProvider->CPDProviderID->CssStyle = ""; $CPDServiceProvider->CPDProviderID->CssClass = ""; $CPDServiceProvider->CPDProviderID->ViewCustomAttributes = ""; // CompanyName $CPDServiceProvider->CompanyName->ViewValue = $CPDServiceProvider->CompanyName->CurrentValue; $CPDServiceProvider->CompanyName->CssStyle = ""; $CPDServiceProvider->CompanyName->CssClass = ""; $CPDServiceProvider->CompanyName->ViewCustomAttributes = ""; // TradingAs $CPDServiceProvider->TradingAs->ViewValue = $CPDServiceProvider->TradingAs->CurrentValue; $CPDServiceProvider->TradingAs->CssStyle = ""; $CPDServiceProvider->TradingAs->CssClass = ""; $CPDServiceProvider->TradingAs->ViewCustomAttributes = ""; // PhoneNumber $CPDServiceProvider->PhoneNumber->ViewValue = $CPDServiceProvider->PhoneNumber->CurrentValue; $CPDServiceProvider->PhoneNumber->CssStyle = ""; $CPDServiceProvider->PhoneNumber->CssClass = ""; $CPDServiceProvider->PhoneNumber->ViewCustomAttributes = ""; // CellNumber $CPDServiceProvider->CellNumber->ViewValue = $CPDServiceProvider->CellNumber->CurrentValue; $CPDServiceProvider->CellNumber->CssStyle = ""; $CPDServiceProvider->CellNumber->CssClass = ""; $CPDServiceProvider->CellNumber->ViewCustomAttributes = ""; // EmailAddress $CPDServiceProvider->EmailAddress->ViewValue = $CPDServiceProvider->EmailAddress->CurrentValue; $CPDServiceProvider->EmailAddress->CssStyle = ""; $CPDServiceProvider->EmailAddress->CssClass = ""; $CPDServiceProvider->EmailAddress->ViewCustomAttributes = ""; // Website $CPDServiceProvider->Website->ViewValue = $CPDServiceProvider->Website->CurrentValue; $CPDServiceProvider->Website->CssStyle = ""; $CPDServiceProvider->Website->CssClass = ""; $CPDServiceProvider->Website->ViewCustomAttributes = ""; // VATNumber $CPDServiceProvider->VATNumber->ViewValue = $CPDServiceProvider->VATNumber->CurrentValue; $CPDServiceProvider->VATNumber->CssStyle = ""; $CPDServiceProvider->VATNumber->CssClass = ""; $CPDServiceProvider->VATNumber->ViewCustomAttributes = ""; // PhysicalAddress1 $CPDServiceProvider->PhysicalAddress1->ViewValue = $CPDServiceProvider->PhysicalAddress1->CurrentValue; $CPDServiceProvider->PhysicalAddress1->CssStyle = ""; $CPDServiceProvider->PhysicalAddress1->CssClass = ""; $CPDServiceProvider->PhysicalAddress1->ViewCustomAttributes = ""; // PhysicalAddress2 $CPDServiceProvider->PhysicalAddress2->ViewValue = $CPDServiceProvider->PhysicalAddress2->CurrentValue; $CPDServiceProvider->PhysicalAddress2->CssStyle = ""; $CPDServiceProvider->PhysicalAddress2->CssClass = ""; $CPDServiceProvider->PhysicalAddress2->ViewCustomAttributes = ""; // PhysicalCity $CPDServiceProvider->PhysicalCity->ViewValue = $CPDServiceProvider->PhysicalCity->CurrentValue; $CPDServiceProvider->PhysicalCity->CssStyle = ""; $CPDServiceProvider->PhysicalCity->CssClass = ""; $CPDServiceProvider->PhysicalCity->ViewCustomAttributes = ""; // PhysicalCode $CPDServiceProvider->PhysicalCode->ViewValue = $CPDServiceProvider->PhysicalCode->CurrentValue; $CPDServiceProvider->PhysicalCode->CssStyle = ""; $CPDServiceProvider->PhysicalCode->CssClass = ""; $CPDServiceProvider->PhysicalCode->ViewCustomAttributes = ""; // PhysicalProvince if (strval($CPDServiceProvider->PhysicalProvince->CurrentValue) <> "") { $sFilterWrk = "`PicklistValue` = '" . ew_AdjustSql($CPDServiceProvider->PhysicalProvince->CurrentValue) . "'"; $sSqlWrk = "SELECT `PicklistValue` FROM `Picklists`"; $sWhereWrk = ""; if ($sWhereWrk <> "") $sWhereWrk .= " AND "; $sWhereWrk .= "(" . "PicklistType='Province'" . ")"; if ($sFilterWrk <> "") { if ($sWhereWrk <> "") $sWhereWrk .= " AND "; $sWhereWrk .= "(" . $sFilterWrk . ")"; } if ($sWhereWrk <> "") $sSqlWrk .= " WHERE " . $sWhereWrk; $sSqlWrk .= " ORDER BY `DisplayOrder`"; $rswrk = $conn->Execute($sSqlWrk); if ($rswrk && !$rswrk->EOF) { // Lookup values found $CPDServiceProvider->PhysicalProvince->ViewValue = $rswrk->fields('PicklistValue'); $rswrk->Close(); } else { $CPDServiceProvider->PhysicalProvince->ViewValue = $CPDServiceProvider->PhysicalProvince->CurrentValue; } } else { $CPDServiceProvider->PhysicalProvince->ViewValue = NULL; } $CPDServiceProvider->PhysicalProvince->CssStyle = ""; $CPDServiceProvider->PhysicalProvince->CssClass = ""; $CPDServiceProvider->PhysicalProvince->ViewCustomAttributes = ""; // PhysicalCountry $CPDServiceProvider->PhysicalCountry->ViewValue = $CPDServiceProvider->PhysicalCountry->CurrentValue; $CPDServiceProvider->PhysicalCountry->CssStyle = ""; $CPDServiceProvider->PhysicalCountry->CssClass = ""; $CPDServiceProvider->PhysicalCountry->ViewCustomAttributes = ""; // PostalAddress1 $CPDServiceProvider->PostalAddress1->ViewValue = $CPDServiceProvider->PostalAddress1->CurrentValue; $CPDServiceProvider->PostalAddress1->CssStyle = ""; $CPDServiceProvider->PostalAddress1->CssClass = ""; $CPDServiceProvider->PostalAddress1->ViewCustomAttributes = ""; // PostalAddress2 $CPDServiceProvider->PostalAddress2->ViewValue = $CPDServiceProvider->PostalAddress2->CurrentValue; $CPDServiceProvider->PostalAddress2->CssStyle = ""; $CPDServiceProvider->PostalAddress2->CssClass = ""; $CPDServiceProvider->PostalAddress2->ViewCustomAttributes = ""; // PostalCity $CPDServiceProvider->PostalCity->ViewValue = $CPDServiceProvider->PostalCity->CurrentValue; $CPDServiceProvider->PostalCity->CssStyle = ""; $CPDServiceProvider->PostalCity->CssClass = ""; $CPDServiceProvider->PostalCity->ViewCustomAttributes = ""; // PostalCode $CPDServiceProvider->PostalCode->ViewValue = $CPDServiceProvider->PostalCode->CurrentValue; $CPDServiceProvider->PostalCode->CssStyle = ""; $CPDServiceProvider->PostalCode->CssClass = ""; $CPDServiceProvider->PostalCode->ViewCustomAttributes = ""; // PostalProvince if (strval($CPDServiceProvider->PostalProvince->CurrentValue) <> "") { $sFilterWrk = "`PicklistValue` = '" . ew_AdjustSql($CPDServiceProvider->PostalProvince->CurrentValue) . "'"; $sSqlWrk = "SELECT `PicklistValue` FROM `Picklists`"; $sWhereWrk = ""; if ($sWhereWrk <> "") $sWhereWrk .= " AND "; $sWhereWrk .= "(" . "PicklistType='Province'" . ")"; if ($sFilterWrk <> "") { if ($sWhereWrk <> "") $sWhereWrk .= " AND "; $sWhereWrk .= "(" . $sFilterWrk . ")"; } if ($sWhereWrk <> "") $sSqlWrk .= " WHERE " . $sWhereWrk; $sSqlWrk .= " ORDER BY `PicklistValue`"; $rswrk = $conn->Execute($sSqlWrk); if ($rswrk && !$rswrk->EOF) { // Lookup values found $CPDServiceProvider->PostalProvince->ViewValue = $rswrk->fields('PicklistValue'); $rswrk->Close(); } else { $CPDServiceProvider->PostalProvince->ViewValue = $CPDServiceProvider->PostalProvince->CurrentValue; } } else { $CPDServiceProvider->PostalProvince->ViewValue = NULL; } $CPDServiceProvider->PostalProvince->CssStyle = ""; $CPDServiceProvider->PostalProvince->CssClass = ""; $CPDServiceProvider->PostalProvince->ViewCustomAttributes = ""; // PostalCountry $CPDServiceProvider->PostalCountry->ViewValue = $CPDServiceProvider->PostalCountry->CurrentValue; $CPDServiceProvider->PostalCountry->CssStyle = ""; $CPDServiceProvider->PostalCountry->CssClass = ""; $CPDServiceProvider->PostalCountry->ViewCustomAttributes = ""; // Password $CPDServiceProvider->Password->ViewValue = $CPDServiceProvider->Password->CurrentValue; $CPDServiceProvider->Password->CssStyle = ""; $CPDServiceProvider->Password->CssClass = ""; $CPDServiceProvider->Password->ViewCustomAttributes = ""; // UpdatedBy $CPDServiceProvider->UpdatedBy->ViewValue = $CPDServiceProvider->UpdatedBy->CurrentValue; $CPDServiceProvider->UpdatedBy->CssStyle = ""; $CPDServiceProvider->UpdatedBy->CssClass = ""; $CPDServiceProvider->UpdatedBy->ViewCustomAttributes = ""; // Archived if (strval($CPDServiceProvider->Archived->CurrentValue) <> "") { switch ($CPDServiceProvider->Archived->CurrentValue) { case "1": $CPDServiceProvider->Archived->ViewValue = "Yes"; break; case "0": $CPDServiceProvider->Archived->ViewValue = "No"; break; default: $CPDServiceProvider->Archived->ViewValue = $CPDServiceProvider->Archived->CurrentValue; } } else { $CPDServiceProvider->Archived->ViewValue = NULL; } $CPDServiceProvider->Archived->CssStyle = ""; $CPDServiceProvider->Archived->CssClass = ""; $CPDServiceProvider->Archived->ViewCustomAttributes = ""; // ContactTitle if (strval($CPDServiceProvider->ContactTitle->CurrentValue) <> "") { $sFilterWrk = "`PicklistValue` = '" . ew_AdjustSql($CPDServiceProvider->ContactTitle->CurrentValue) . "'"; $sSqlWrk = "SELECT `PicklistValue` FROM `Picklists`"; $sWhereWrk = ""; if ($sWhereWrk <> "") $sWhereWrk .= " AND "; $sWhereWrk .= "(" . "PicklistType='Title'" . ")"; if ($sFilterWrk <> "") { if ($sWhereWrk <> "") $sWhereWrk .= " AND "; $sWhereWrk .= "(" . $sFilterWrk . ")"; } if ($sWhereWrk <> "") $sSqlWrk .= " WHERE " . $sWhereWrk; $sSqlWrk .= " ORDER BY `DisplayOrder`"; $rswrk = $conn->Execute($sSqlWrk); if ($rswrk && !$rswrk->EOF) { // Lookup values found $CPDServiceProvider->ContactTitle->ViewValue = $rswrk->fields('PicklistValue'); $rswrk->Close(); } else { $CPDServiceProvider->ContactTitle->ViewValue = $CPDServiceProvider->ContactTitle->CurrentValue; } } else { $CPDServiceProvider->ContactTitle->ViewValue = NULL; } $CPDServiceProvider->ContactTitle->CssStyle = ""; $CPDServiceProvider->ContactTitle->CssClass = ""; $CPDServiceProvider->ContactTitle->ViewCustomAttributes = ""; // ContactInitials $CPDServiceProvider->ContactInitials->ViewValue = $CPDServiceProvider->ContactInitials->CurrentValue; $CPDServiceProvider->ContactInitials->CssStyle = ""; $CPDServiceProvider->ContactInitials->CssClass = ""; $CPDServiceProvider->ContactInitials->ViewCustomAttributes = ""; // ContactFirstName $CPDServiceProvider->ContactFirstName->ViewValue = $CPDServiceProvider->ContactFirstName->CurrentValue; $CPDServiceProvider->ContactFirstName->CssStyle = ""; $CPDServiceProvider->ContactFirstName->CssClass = ""; $CPDServiceProvider->ContactFirstName->ViewCustomAttributes = ""; // ContactSurname $CPDServiceProvider->ContactSurname->ViewValue = $CPDServiceProvider->ContactSurname->CurrentValue; $CPDServiceProvider->ContactSurname->CssStyle = ""; $CPDServiceProvider->ContactSurname->CssClass = ""; $CPDServiceProvider->ContactSurname->ViewCustomAttributes = ""; // ContactPosition $CPDServiceProvider->ContactPosition->ViewValue = $CPDServiceProvider->ContactPosition->CurrentValue; $CPDServiceProvider->ContactPosition->CssStyle = ""; $CPDServiceProvider->ContactPosition->CssClass = ""; $CPDServiceProvider->ContactPosition->ViewCustomAttributes = ""; // ContactPhone $CPDServiceProvider->ContactPhone->ViewValue = $CPDServiceProvider->ContactPhone->CurrentValue; $CPDServiceProvider->ContactPhone->CssStyle = ""; $CPDServiceProvider->ContactPhone->CssClass = ""; $CPDServiceProvider->ContactPhone->ViewCustomAttributes = ""; // ContactCell $CPDServiceProvider->ContactCell->ViewValue = $CPDServiceProvider->ContactCell->CurrentValue; $CPDServiceProvider->ContactCell->CssStyle = ""; $CPDServiceProvider->ContactCell->CssClass = ""; $CPDServiceProvider->ContactCell->ViewCustomAttributes = ""; // ContactEmail $CPDServiceProvider->ContactEmail->ViewValue = $CPDServiceProvider->ContactEmail->CurrentValue; $CPDServiceProvider->ContactEmail->CssStyle = ""; $CPDServiceProvider->ContactEmail->CssClass = ""; $CPDServiceProvider->ContactEmail->ViewCustomAttributes = ""; // ContactIDNum $CPDServiceProvider->ContactIDNum->ViewValue = $CPDServiceProvider->ContactIDNum->CurrentValue; $CPDServiceProvider->ContactIDNum->CssStyle = ""; $CPDServiceProvider->ContactIDNum->CssClass = ""; $CPDServiceProvider->ContactIDNum->ViewCustomAttributes = ""; // AdminTitle $CPDServiceProvider->AdminTitle->ViewValue = $CPDServiceProvider->AdminTitle->CurrentValue; $CPDServiceProvider->AdminTitle->CssStyle = ""; $CPDServiceProvider->AdminTitle->CssClass = ""; $CPDServiceProvider->AdminTitle->ViewCustomAttributes = ""; // AdminInitials $CPDServiceProvider->AdminInitials->ViewValue = $CPDServiceProvider->AdminInitials->CurrentValue; $CPDServiceProvider->AdminInitials->CssStyle = ""; $CPDServiceProvider->AdminInitials->CssClass = ""; $CPDServiceProvider->AdminInitials->ViewCustomAttributes = ""; // AdminFirstName $CPDServiceProvider->AdminFirstName->ViewValue = $CPDServiceProvider->AdminFirstName->CurrentValue; $CPDServiceProvider->AdminFirstName->CssStyle = ""; $CPDServiceProvider->AdminFirstName->CssClass = ""; $CPDServiceProvider->AdminFirstName->ViewCustomAttributes = ""; // AdminSurname $CPDServiceProvider->AdminSurname->ViewValue = $CPDServiceProvider->AdminSurname->CurrentValue; $CPDServiceProvider->AdminSurname->CssStyle = ""; $CPDServiceProvider->AdminSurname->CssClass = ""; $CPDServiceProvider->AdminSurname->ViewCustomAttributes = ""; // AdminPosition $CPDServiceProvider->AdminPosition->ViewValue = $CPDServiceProvider->AdminPosition->CurrentValue; $CPDServiceProvider->AdminPosition->CssStyle = ""; $CPDServiceProvider->AdminPosition->CssClass = ""; $CPDServiceProvider->AdminPosition->ViewCustomAttributes = ""; // AdminPhone $CPDServiceProvider->AdminPhone->ViewValue = $CPDServiceProvider->AdminPhone->CurrentValue; $CPDServiceProvider->AdminPhone->CssStyle = ""; $CPDServiceProvider->AdminPhone->CssClass = ""; $CPDServiceProvider->AdminPhone->ViewCustomAttributes = ""; // AdminCell $CPDServiceProvider->AdminCell->ViewValue = $CPDServiceProvider->AdminCell->CurrentValue; $CPDServiceProvider->AdminCell->CssStyle = ""; $CPDServiceProvider->AdminCell->CssClass = ""; $CPDServiceProvider->AdminCell->ViewCustomAttributes = ""; // AdminEmail $CPDServiceProvider->AdminEmail->ViewValue = $CPDServiceProvider->AdminEmail->CurrentValue; $CPDServiceProvider->AdminEmail->CssStyle = ""; $CPDServiceProvider->AdminEmail->CssClass = ""; $CPDServiceProvider->AdminEmail->ViewCustomAttributes = ""; // AdminIDNum $CPDServiceProvider->AdminIDNum->ViewValue = $CPDServiceProvider->AdminIDNum->CurrentValue; $CPDServiceProvider->AdminIDNum->CssStyle = ""; $CPDServiceProvider->AdminIDNum->CssClass = ""; $CPDServiceProvider->AdminIDNum->ViewCustomAttributes = ""; // EvaluatorID if (strval($CPDServiceProvider->EvaluatorID->CurrentValue) <> "") { $sFilterWrk = "`CPDAssessorID` = " . ew_AdjustSql($CPDServiceProvider->EvaluatorID->CurrentValue) . ""; $sSqlWrk = "SELECT `Surname`, `FirstName` FROM `CPDAssessors`"; $sWhereWrk = ""; if ($sFilterWrk <> "") { if ($sWhereWrk <> "") $sWhereWrk .= " AND "; $sWhereWrk .= "(" . $sFilterWrk . ")"; } if ($sWhereWrk <> "") $sSqlWrk .= " WHERE " . $sWhereWrk; $sSqlWrk .= " ORDER BY `Surname`"; $rswrk = $conn->Execute($sSqlWrk); if ($rswrk && !$rswrk->EOF) { // Lookup values found $CPDServiceProvider->EvaluatorID->ViewValue = $rswrk->fields('Surname'); $CPDServiceProvider->EvaluatorID->ViewValue .= ew_ValueSeparator(0) . $rswrk->fields('FirstName'); $rswrk->Close(); } else { $CPDServiceProvider->EvaluatorID->ViewValue = $CPDServiceProvider->EvaluatorID->CurrentValue; } } else { $CPDServiceProvider->EvaluatorID->ViewValue = NULL; } $CPDServiceProvider->EvaluatorID->CssStyle = ""; $CPDServiceProvider->EvaluatorID->CssClass = ""; $CPDServiceProvider->EvaluatorID->ViewCustomAttributes = ""; // EvaluatorID2 if (strval($CPDServiceProvider->EvaluatorID2->CurrentValue) <> "") { $sFilterWrk = "`CPDAssessorID` = " . ew_AdjustSql($CPDServiceProvider->EvaluatorID2->CurrentValue) . ""; $sSqlWrk = "SELECT `Surname`, `FirstName` FROM `CPDAssessors`"; $sWhereWrk = ""; if ($sFilterWrk <> "") { if ($sWhereWrk <> "") $sWhereWrk .= " AND "; $sWhereWrk .= "(" . $sFilterWrk . ")"; } if ($sWhereWrk <> "") $sSqlWrk .= " WHERE " . $sWhereWrk; $sSqlWrk .= " ORDER BY `Surname`"; $rswrk = $conn->Execute($sSqlWrk); if ($rswrk && !$rswrk->EOF) { // Lookup values found $CPDServiceProvider->EvaluatorID2->ViewValue = $rswrk->fields('Surname'); $CPDServiceProvider->EvaluatorID2->ViewValue .= ew_ValueSeparator(0) . $rswrk->fields('FirstName'); $rswrk->Close(); } else { $CPDServiceProvider->EvaluatorID2->ViewValue = $CPDServiceProvider->EvaluatorID2->CurrentValue; } } else { $CPDServiceProvider->EvaluatorID2->ViewValue = NULL; } $CPDServiceProvider->EvaluatorID2->CssStyle = ""; $CPDServiceProvider->EvaluatorID2->CssClass = ""; $CPDServiceProvider->EvaluatorID2->ViewCustomAttributes = ""; // EvaluatorID3 if (strval($CPDServiceProvider->EvaluatorID3->CurrentValue) <> "") { $sFilterWrk = "`CPDAssessorID` = " . ew_AdjustSql($CPDServiceProvider->EvaluatorID3->CurrentValue) . ""; $sSqlWrk = "SELECT `Surname`, `FirstName` FROM `CPDAssessors`"; $sWhereWrk = ""; if ($sFilterWrk <> "") { if ($sWhereWrk <> "") $sWhereWrk .= " AND "; $sWhereWrk .= "(" . $sFilterWrk . ")"; } if ($sWhereWrk <> "") $sSqlWrk .= " WHERE " . $sWhereWrk; $sSqlWrk .= " ORDER BY `Surname`"; $rswrk = $conn->Execute($sSqlWrk); if ($rswrk && !$rswrk->EOF) { // Lookup values found $CPDServiceProvider->EvaluatorID3->ViewValue = $rswrk->fields('Surname'); $CPDServiceProvider->EvaluatorID3->ViewValue .= ew_ValueSeparator(0) . $rswrk->fields('FirstName'); $rswrk->Close(); } else { $CPDServiceProvider->EvaluatorID3->ViewValue = $CPDServiceProvider->EvaluatorID3->CurrentValue; } } else { $CPDServiceProvider->EvaluatorID3->ViewValue = NULL; } $CPDServiceProvider->EvaluatorID3->CssStyle = ""; $CPDServiceProvider->EvaluatorID3->CssClass = ""; $CPDServiceProvider->EvaluatorID3->ViewCustomAttributes = ""; // Approved if (strval($CPDServiceProvider->Approved->CurrentValue) <> "") { switch ($CPDServiceProvider->Approved->CurrentValue) { case "P": $CPDServiceProvider->Approved->ViewValue = "Pending Evaluation"; break; case "A": $CPDServiceProvider->Approved->ViewValue = "Approved"; break; case "D": $CPDServiceProvider->Approved->ViewValue = "Declined"; break; case "E": $CPDServiceProvider->Approved->ViewValue = "Expired"; break; default: $CPDServiceProvider->Approved->ViewValue = $CPDServiceProvider->Approved->CurrentValue; } } else { $CPDServiceProvider->Approved->ViewValue = NULL; } $CPDServiceProvider->Approved->CssStyle = ""; $CPDServiceProvider->Approved->CssClass = ""; $CPDServiceProvider->Approved->ViewCustomAttributes = ""; // SPNumber $CPDServiceProvider->SPNumber->ViewValue = $CPDServiceProvider->SPNumber->CurrentValue; $CPDServiceProvider->SPNumber->CssStyle = ""; $CPDServiceProvider->SPNumber->CssClass = ""; $CPDServiceProvider->SPNumber->ViewCustomAttributes = ""; // DateUpdated $CPDServiceProvider->DateUpdated->ViewValue = $CPDServiceProvider->DateUpdated->CurrentValue; $CPDServiceProvider->DateUpdated->ViewValue = ew_FormatDateTime($CPDServiceProvider->DateUpdated->ViewValue, 5); $CPDServiceProvider->DateUpdated->CssStyle = ""; $CPDServiceProvider->DateUpdated->CssClass = ""; $CPDServiceProvider->DateUpdated->ViewCustomAttributes = ""; // DateAssessed $CPDServiceProvider->DateAssessed->ViewValue = $CPDServiceProvider->DateAssessed->CurrentValue; $CPDServiceProvider->DateAssessed->ViewValue = ew_FormatDateTime($CPDServiceProvider->DateAssessed->ViewValue, 5); $CPDServiceProvider->DateAssessed->CssStyle = ""; $CPDServiceProvider->DateAssessed->CssClass = ""; $CPDServiceProvider->DateAssessed->ViewCustomAttributes = ""; // DateExpires $CPDServiceProvider->DateExpires->ViewValue = $CPDServiceProvider->DateExpires->CurrentValue; $CPDServiceProvider->DateExpires->ViewValue = ew_FormatDateTime($CPDServiceProvider->DateExpires->ViewValue, 5); $CPDServiceProvider->DateExpires->CssStyle = ""; $CPDServiceProvider->DateExpires->CssClass = ""; $CPDServiceProvider->DateExpires->ViewCustomAttributes = ""; // InvoiceCode $CPDServiceProvider->InvoiceCode->ViewValue = $CPDServiceProvider->InvoiceCode->CurrentValue; $CPDServiceProvider->InvoiceCode->CssStyle = ""; $CPDServiceProvider->InvoiceCode->CssClass = ""; $CPDServiceProvider->InvoiceCode->ViewCustomAttributes = ""; // InvoiceNumber $CPDServiceProvider->InvoiceNumber->ViewValue = $CPDServiceProvider->InvoiceNumber->CurrentValue; $CPDServiceProvider->InvoiceNumber->CssStyle = ""; $CPDServiceProvider->InvoiceNumber->CssClass = ""; $CPDServiceProvider->InvoiceNumber->ViewCustomAttributes = ""; // Cost $CPDServiceProvider->Cost->ViewValue = $CPDServiceProvider->Cost->CurrentValue; $CPDServiceProvider->Cost->CssStyle = ""; $CPDServiceProvider->Cost->CssClass = ""; $CPDServiceProvider->Cost->ViewCustomAttributes = ""; // InvoiceDate $CPDServiceProvider->InvoiceDate->ViewValue = $CPDServiceProvider->InvoiceDate->CurrentValue; $CPDServiceProvider->InvoiceDate->ViewValue = ew_FormatDateTime($CPDServiceProvider->InvoiceDate->ViewValue, 5); $CPDServiceProvider->InvoiceDate->CssStyle = ""; $CPDServiceProvider->InvoiceDate->CssClass = ""; $CPDServiceProvider->InvoiceDate->ViewCustomAttributes = ""; // DepositAmt $CPDServiceProvider->DepositAmt->ViewValue = $CPDServiceProvider->DepositAmt->CurrentValue; $CPDServiceProvider->DepositAmt->CssStyle = ""; $CPDServiceProvider->DepositAmt->CssClass = ""; $CPDServiceProvider->DepositAmt->ViewCustomAttributes = ""; // DatePaid $CPDServiceProvider->DatePaid->ViewValue = $CPDServiceProvider->DatePaid->CurrentValue; $CPDServiceProvider->DatePaid->ViewValue = ew_FormatDateTime($CPDServiceProvider->DatePaid->ViewValue, 5); $CPDServiceProvider->DatePaid->CssStyle = ""; $CPDServiceProvider->DatePaid->CssClass = ""; $CPDServiceProvider->DatePaid->ViewCustomAttributes = ""; // InvoiceFile if (!ew_Empty($CPDServiceProvider->InvoiceFile->Upload->DbValue)) { $CPDServiceProvider->InvoiceFile->ViewValue = $CPDServiceProvider->InvoiceFile->Upload->DbValue; } else { $CPDServiceProvider->InvoiceFile->ViewValue = ""; } $CPDServiceProvider->InvoiceFile->CssStyle = ""; $CPDServiceProvider->InvoiceFile->CssClass = ""; $CPDServiceProvider->InvoiceFile->ViewCustomAttributes = ""; // ProofOfPayment if (!ew_Empty($CPDServiceProvider->ProofOfPayment->Upload->DbValue)) { $CPDServiceProvider->ProofOfPayment->ViewValue = $CPDServiceProvider->ProofOfPayment->Upload->DbValue; } else { $CPDServiceProvider->ProofOfPayment->ViewValue = ""; } $CPDServiceProvider->ProofOfPayment->CssStyle = ""; $CPDServiceProvider->ProofOfPayment->CssClass = ""; $CPDServiceProvider->ProofOfPayment->ViewCustomAttributes = ""; // EvaluatorFee if (strval($CPDServiceProvider->EvaluatorFee->CurrentValue) <> "") { switch ($CPDServiceProvider->EvaluatorFee->CurrentValue) { case "1": $CPDServiceProvider->EvaluatorFee->ViewValue = "Yes"; break; case "0": $CPDServiceProvider->EvaluatorFee->ViewValue = "No"; break; default: $CPDServiceProvider->EvaluatorFee->ViewValue = $CPDServiceProvider->EvaluatorFee->CurrentValue; } } else { $CPDServiceProvider->EvaluatorFee->ViewValue = NULL; } $CPDServiceProvider->EvaluatorFee->CssStyle = ""; $CPDServiceProvider->EvaluatorFee->CssClass = ""; $CPDServiceProvider->EvaluatorFee->ViewCustomAttributes = ""; // EvaluatorFeeAmount $CPDServiceProvider->EvaluatorFeeAmount->ViewValue = $CPDServiceProvider->EvaluatorFeeAmount->CurrentValue; $CPDServiceProvider->EvaluatorFeeAmount->CssStyle = ""; $CPDServiceProvider->EvaluatorFeeAmount->CssClass = ""; $CPDServiceProvider->EvaluatorFeeAmount->ViewCustomAttributes = ""; // EvaluatorFeeDate $CPDServiceProvider->EvaluatorFeeDate->ViewValue = $CPDServiceProvider->EvaluatorFeeDate->CurrentValue; $CPDServiceProvider->EvaluatorFeeDate->ViewValue = ew_FormatDateTime($CPDServiceProvider->EvaluatorFeeDate->ViewValue, 5); $CPDServiceProvider->EvaluatorFeeDate->CssStyle = ""; $CPDServiceProvider->EvaluatorFeeDate->CssClass = ""; $CPDServiceProvider->EvaluatorFeeDate->ViewCustomAttributes = ""; // EvaluatorInvoice if (!ew_Empty($CPDServiceProvider->EvaluatorInvoice->Upload->DbValue)) { $CPDServiceProvider->EvaluatorInvoice->ViewValue = $CPDServiceProvider->EvaluatorInvoice->Upload->DbValue; } else { $CPDServiceProvider->EvaluatorInvoice->ViewValue = ""; } $CPDServiceProvider->EvaluatorInvoice->CssStyle = ""; $CPDServiceProvider->EvaluatorInvoice->CssClass = ""; $CPDServiceProvider->EvaluatorInvoice->ViewCustomAttributes = ""; // EvaluatorTimesheet if (!ew_Empty($CPDServiceProvider->EvaluatorTimesheet->Upload->DbValue)) { $CPDServiceProvider->EvaluatorTimesheet->ViewValue = $CPDServiceProvider->EvaluatorTimesheet->Upload->DbValue; } else { $CPDServiceProvider->EvaluatorTimesheet->ViewValue = ""; } $CPDServiceProvider->EvaluatorTimesheet->CssStyle = ""; $CPDServiceProvider->EvaluatorTimesheet->CssClass = ""; $CPDServiceProvider->EvaluatorTimesheet->ViewCustomAttributes = ""; // NumReminders $CPDServiceProvider->NumReminders->ViewValue = $CPDServiceProvider->NumReminders->CurrentValue; $CPDServiceProvider->NumReminders->CssStyle = ""; $CPDServiceProvider->NumReminders->CssClass = ""; $CPDServiceProvider->NumReminders->ViewCustomAttributes = ""; // LastReminder $CPDServiceProvider->LastReminder->ViewValue = $CPDServiceProvider->LastReminder->CurrentValue; $CPDServiceProvider->LastReminder->ViewValue = ew_FormatDateTime($CPDServiceProvider->LastReminder->ViewValue, 5); $CPDServiceProvider->LastReminder->CssStyle = ""; $CPDServiceProvider->LastReminder->CssClass = ""; $CPDServiceProvider->LastReminder->ViewCustomAttributes = ""; // PrevSPNumber if (strval($CPDServiceProvider->PrevSPNumber->CurrentValue) <> "") { $sFilterWrk = "`SPNumber` = '" . ew_AdjustSql($CPDServiceProvider->PrevSPNumber->CurrentValue) . "'"; $sSqlWrk = "SELECT `CompanyName`, `SPNumber` FROM `CPDServiceProvider`"; $sWhereWrk = ""; if ($sWhereWrk <> "") $sWhereWrk .= " AND "; $sWhereWrk .= "(" . "`Approved` IN ('A') AND `DateExpires` <= NOW() AND `SPNumber` != ''" . ")"; if ($sFilterWrk <> "") { if ($sWhereWrk <> "") $sWhereWrk .= " AND "; $sWhereWrk .= "(" . $sFilterWrk . ")"; } if ($sWhereWrk <> "") $sSqlWrk .= " WHERE " . $sWhereWrk; $sSqlWrk .= " ORDER BY `CompanyName` Asc"; $rswrk = $conn->Execute($sSqlWrk); if ($rswrk && !$rswrk->EOF) { // Lookup values found $CPDServiceProvider->PrevSPNumber->ViewValue = $rswrk->fields('CompanyName'); $CPDServiceProvider->PrevSPNumber->ViewValue .= ew_ValueSeparator(0) . $rswrk->fields('SPNumber'); $rswrk->Close(); } else { $CPDServiceProvider->PrevSPNumber->ViewValue = $CPDServiceProvider->PrevSPNumber->CurrentValue; } } else { $CPDServiceProvider->PrevSPNumber->ViewValue = NULL; } $CPDServiceProvider->PrevSPNumber->CssStyle = ""; $CPDServiceProvider->PrevSPNumber->CssClass = ""; $CPDServiceProvider->PrevSPNumber->ViewCustomAttributes = ""; // PrevSPNumberCertificate if (!ew_Empty($CPDServiceProvider->PrevSPNumberCertificate->Upload->DbValue)) { $CPDServiceProvider->PrevSPNumberCertificate->ViewValue = $CPDServiceProvider->PrevSPNumberCertificate->Upload->DbValue; } else { $CPDServiceProvider->PrevSPNumberCertificate->ViewValue = ""; } $CPDServiceProvider->PrevSPNumberCertificate->CssStyle = ""; $CPDServiceProvider->PrevSPNumberCertificate->CssClass = ""; $CPDServiceProvider->PrevSPNumberCertificate->ViewCustomAttributes = ""; // OtherVACPDSPNumberCertificate if (!ew_Empty($CPDServiceProvider->OtherVACPDSPNumberCertificate->Upload->DbValue)) { $CPDServiceProvider->OtherVACPDSPNumberCertificate->ViewValue = $CPDServiceProvider->OtherVACPDSPNumberCertificate->Upload->DbValue; } else { $CPDServiceProvider->OtherVACPDSPNumberCertificate->ViewValue = ""; } $CPDServiceProvider->OtherVACPDSPNumberCertificate->CssStyle = ""; $CPDServiceProvider->OtherVACPDSPNumberCertificate->CssClass = ""; $CPDServiceProvider->OtherVACPDSPNumberCertificate->ViewCustomAttributes = ""; // Renewal if (strval($CPDServiceProvider->Renewal->CurrentValue) <> "") { switch ($CPDServiceProvider->Renewal->CurrentValue) { case "1": $CPDServiceProvider->Renewal->ViewValue = "Yes"; break; case "0": $CPDServiceProvider->Renewal->ViewValue = "No"; break; default: $CPDServiceProvider->Renewal->ViewValue = $CPDServiceProvider->Renewal->CurrentValue; } } else { $CPDServiceProvider->Renewal->ViewValue = NULL; } $CPDServiceProvider->Renewal->CssStyle = ""; $CPDServiceProvider->Renewal->CssClass = ""; $CPDServiceProvider->Renewal->ViewCustomAttributes = ""; // DateCreated $CPDServiceProvider->DateCreated->ViewValue = $CPDServiceProvider->DateCreated->CurrentValue; $CPDServiceProvider->DateCreated->ViewValue = ew_FormatDateTime($CPDServiceProvider->DateCreated->ViewValue, 5); $CPDServiceProvider->DateCreated->CssStyle = ""; $CPDServiceProvider->DateCreated->CssClass = ""; $CPDServiceProvider->DateCreated->ViewCustomAttributes = ""; // AccountabilityStructure if (!ew_Empty($CPDServiceProvider->AccountabilityStructure->Upload->DbValue)) { $CPDServiceProvider->AccountabilityStructure->ViewValue = $CPDServiceProvider->AccountabilityStructure->Upload->DbValue; } else { $CPDServiceProvider->AccountabilityStructure->ViewValue = ""; } $CPDServiceProvider->AccountabilityStructure->CssStyle = ""; $CPDServiceProvider->AccountabilityStructure->CssClass = ""; $CPDServiceProvider->AccountabilityStructure->ViewCustomAttributes = ""; // CompanyName $CPDServiceProvider->CompanyName->HrefValue = ""; $CPDServiceProvider->CompanyName->TooltipValue = ""; // TradingAs $CPDServiceProvider->TradingAs->HrefValue = ""; $CPDServiceProvider->TradingAs->TooltipValue = ""; // EmailAddress $CPDServiceProvider->EmailAddress->HrefValue = ""; $CPDServiceProvider->EmailAddress->TooltipValue = ""; // ContactFirstName $CPDServiceProvider->ContactFirstName->HrefValue = ""; $CPDServiceProvider->ContactFirstName->TooltipValue = ""; // ContactSurname $CPDServiceProvider->ContactSurname->HrefValue = ""; $CPDServiceProvider->ContactSurname->TooltipValue = ""; // Approved $CPDServiceProvider->Approved->HrefValue = ""; $CPDServiceProvider->Approved->TooltipValue = ""; // SPNumber $CPDServiceProvider->SPNumber->HrefValue = ""; $CPDServiceProvider->SPNumber->TooltipValue = ""; // DateUpdated $CPDServiceProvider->DateUpdated->HrefValue = ""; $CPDServiceProvider->DateUpdated->TooltipValue = ""; // DateAssessed $CPDServiceProvider->DateAssessed->HrefValue = ""; $CPDServiceProvider->DateAssessed->TooltipValue = ""; // DateExpires $CPDServiceProvider->DateExpires->HrefValue = ""; $CPDServiceProvider->DateExpires->TooltipValue = ""; // DatePaid $CPDServiceProvider->DatePaid->HrefValue = ""; $CPDServiceProvider->DatePaid->TooltipValue = ""; // LastReminder $CPDServiceProvider->LastReminder->HrefValue = ""; $CPDServiceProvider->LastReminder->TooltipValue = ""; } // Call Row Rendered event if ($CPDServiceProvider->RowType <> EW_ROWTYPE_AGGREGATEINIT) $CPDServiceProvider->Row_Rendered(); } // Page Load event function Page_Load() { //echo "Page Load"; } // Page Unload event function Page_Unload() { //echo "Page Unload"; } // Page Redirecting event function Page_Redirecting(&$url) { // Example: //$url = "your URL"; } // Message Showing event function Message_Showing(&$msg) { // Example: //$msg = "your new message"; } } ?>