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 "CPDTrainingMaterialinfo.php" ?> <?php include "CPDServiceProviderinfo.php" ?> <?php include "CPDAdminUsersinfo.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 $CPDTrainingMaterial_list = new cCPDTrainingMaterial_list(); $Page =& $CPDTrainingMaterial_list; // Page init $CPDTrainingMaterial_list->Page_Init(); // Page main $CPDTrainingMaterial_list->Page_Main(); ?> <?php include "header.php" ?> <?php if ($CPDTrainingMaterial->Export == "") { ?> <script type="text/javascript"> <!-- // Create page object var CPDTrainingMaterial_list = new ew_Page("CPDTrainingMaterial_list"); // page properties CPDTrainingMaterial_list.PageID = "list"; // page ID CPDTrainingMaterial_list.FormID = "fCPDTrainingMateriallist"; // form ID var EW_PAGE_ID = CPDTrainingMaterial_list.PageID; // for backward compatibility // extend page with validate function for search CPDTrainingMaterial_list.ValidateSearch = function(fobj) { ew_PostAutoSuggest(fobj); if (this.ValidateRequired) { var infix = ""; elm = fobj.elements["x" + infix + "_DateApproved"]; if (elm && !ew_CheckDate(elm.value)) return ew_OnError(this, elm, "<?php echo ew_JsEncode2($CPDTrainingMaterial->DateApproved->FldErrMsg()) ?>"); // Call Form Custom Validate event if (!this.Form_CustomValidate(fobj)) return false; } for (var i=0; i<fobj.elements.length; i++) { var elem = fobj.elements[i]; if (elem.name.substring(0,2) == "s_" || elem.name.substring(0,3) == "sv_") elem.value = ""; } return true; } // extend page with Form_CustomValidate function CPDTrainingMaterial_list.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) { ?> CPDTrainingMaterial_list.ValidateRequired = true; // uses JavaScript validation <?php } else { ?> CPDTrainingMaterial_list.ValidateRequired = false; // no JavaScript validation <?php } ?> //--> </script> <link rel="stylesheet" type="text/css" media="all" href="calendar/calendar-win2k-cold-1.css" title="win2k-1"> <script type="text/javascript" src="calendar/calendar.js"></script> <script type="text/javascript" src="calendar/lang/calendar-en.js"></script> <script type="text/javascript" src="calendar/calendar-setup.js"></script> <script type="text/javascript"> <!-- var ew_DHTMLEditors = []; //--> </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 } ?> <?php if ($CPDTrainingMaterial->Export == "") { ?> <?php $gsMasterReturnUrl = "CPDServiceProviderlist.php"; if ($CPDTrainingMaterial_list->sDbMasterFilter <> "" && $CPDTrainingMaterial->getCurrentMasterTable() == "CPDServiceProvider") { if ($CPDTrainingMaterial_list->bMasterRecordExists) { if ($CPDTrainingMaterial->getCurrentMasterTable() == $CPDTrainingMaterial->TableVar) $gsMasterReturnUrl .= "?" . EW_TABLE_SHOW_MASTER . "="; ?> <?php include "CPDServiceProvidermaster.php" ?> <?php } } ?> <?php } ?> <?php $bSelectLimit = EW_SELECT_LIMIT; if ($bSelectLimit) { $CPDTrainingMaterial_list->lTotalRecs = $CPDTrainingMaterial->SelectRecordCount(); } else { if ($rs = $CPDTrainingMaterial_list->LoadRecordset()) $CPDTrainingMaterial_list->lTotalRecs = $rs->RecordCount(); } $CPDTrainingMaterial_list->lStartRec = 1; if ($CPDTrainingMaterial_list->lDisplayRecs <= 0 || ($CPDTrainingMaterial->Export <> "" && $CPDTrainingMaterial->ExportAll)) // Display all records $CPDTrainingMaterial_list->lDisplayRecs = $CPDTrainingMaterial_list->lTotalRecs; if (!($CPDTrainingMaterial->Export <> "" && $CPDTrainingMaterial->ExportAll)) $CPDTrainingMaterial_list->SetUpStartRec(); // Set up start record position if ($bSelectLimit) $rs = $CPDTrainingMaterial_list->LoadRecordset($CPDTrainingMaterial_list->lStartRec-1, $CPDTrainingMaterial_list->lDisplayRecs); ?> <p><span class="phpmaker" style="white-space: nowrap;"><?php echo $Language->Phrase("TblTypeTABLE") ?><?php echo $CPDTrainingMaterial->TableCaption() ?> <?php if ($CPDTrainingMaterial->Export == "" && $CPDTrainingMaterial->CurrentAction == "") { ?> <a href="<?php echo $CPDTrainingMaterial_list->ExportPrintUrl ?>"><img src="images/print.gif" alt="<?php echo ew_HtmlEncode($Language->Phrase("PrinterFriendly")) ?>" title="<?php echo ew_HtmlEncode($Language->Phrase("PrinterFriendly")) ?>" width="16" height="16" border="0"></a> <a href="<?php echo $CPDTrainingMaterial_list->ExportExcelUrl ?>"><img src='images/exportxls.gif' alt='<?php echo ew_HtmlEncode($Language->Phrase("ExportToExcel")) ?>' title='<?php echo ew_HtmlEncode($Language->Phrase("ExportToExcel")) ?>' width='16' height='16' border='0'></a> <a href="<?php echo $CPDTrainingMaterial_list->ExportWordUrl ?>"><img src='images/exportdoc.gif' alt='<?php echo ew_HtmlEncode($Language->Phrase("ExportToWord")) ?>' title='<?php echo ew_HtmlEncode($Language->Phrase("ExportToWord")) ?>' width='16' height='16' border='0'></a> <a name="emf_CPDTrainingMaterial" id="emf_CPDTrainingMaterial" href="javascript:void(0);" onclick="ew_EmailDialogShow({lnk:'emf_CPDTrainingMaterial',hdr:ewLanguage.Phrase('ExportToEmail'),f:document.fCPDTrainingMateriallist,sel:false});"><img src='images/exportemail.gif' alt='<?php echo ew_HtmlEncode($Language->Phrase("ExportToEmail")) ?>' title='<?php echo ew_HtmlEncode($Language->Phrase("ExportToEmail")) ?>' width='16' height='16' border='0'></a> <?php } ?> </span></p> <?php if ($Security->IsLoggedIn()) { ?> <?php if ($CPDTrainingMaterial->Export == "" && $CPDTrainingMaterial->CurrentAction == "") { ?> <a href="javascript:ew_ToggleSearchPanel(CPDTrainingMaterial_list);" style="text-decoration: none;"><img id="CPDTrainingMaterial_list_SearchImage" src="images/collapse.gif" alt="" width="9" height="9" border="0"></a><span class="phpmaker"> <?php echo $Language->Phrase("Search") ?></span><br> <div id="CPDTrainingMaterial_list_SearchPanel"> <form name="fCPDTrainingMateriallistsrch" id="fCPDTrainingMateriallistsrch" class="ewForm" action="<?php echo ew_CurrentPage() ?>" onsubmit="return CPDTrainingMaterial_list.ValidateSearch(this);"> <input type="hidden" id="t" name="t" value="CPDTrainingMaterial"> <?php if ($gsSearchError == "") $CPDTrainingMaterial_list->LoadAdvancedSearch(); // Load advanced search // Render for search $CPDTrainingMaterial->RowType = EW_ROWTYPE_SEARCH; // Render row $CPDTrainingMaterial_list->RenderRow(); ?> <table class="ewBasicSearch"> <tr> <td><span class="phpmaker"><?php echo $CPDTrainingMaterial->Subject->FldCaption() ?></span></td> <td><span class="ewSearchOpr"><?php echo $Language->Phrase("LIKE") ?><input type="hidden" name="z_Subject" id="z_Subject" value="LIKE"></span></td> <td> <div style="white-space: nowrap;"> <span class="phpmaker" style="float: left;"> <input type="text" name="x_Subject" id="x_Subject" title="<?php echo $CPDTrainingMaterial->Subject->FldTitle() ?>" size="30" maxlength="255" value="<?php echo $CPDTrainingMaterial->Subject->EditValue ?>"<?php echo $CPDTrainingMaterial->Subject->EditAttributes() ?>> </span> </div> </td> </tr> <tr> <td><span class="phpmaker"><?php echo $CPDTrainingMaterial->Status->FldCaption() ?></span></td> <td><span class="ewSearchOpr"><?php echo $Language->Phrase("LIKE") ?><input type="hidden" name="z_Status" id="z_Status" value="LIKE"></span></td> <td> <div style="white-space: nowrap;"> <span class="phpmaker" style="float: left;"> <div id="tp_x_Status" class="<?php echo EW_ITEM_TEMPLATE_CLASSNAME ?>"><label><input type="radio" name="x_Status" id="x_Status" title="<?php echo $CPDTrainingMaterial->Status->FldTitle() ?>" value="{value}"<?php echo $CPDTrainingMaterial->Status->EditAttributes() ?>></label></div> <div id="dsl_x_Status" repeatcolumn="5"> <?php $arwrk = $CPDTrainingMaterial->Status->EditValue; if (is_array($arwrk)) { $rowswrk = count($arwrk); $emptywrk = TRUE; for ($rowcntwrk = 0; $rowcntwrk < $rowswrk; $rowcntwrk++) { $selwrk = (strval($CPDTrainingMaterial->Status->AdvancedSearch->SearchValue) == strval($arwrk[$rowcntwrk][0])) ? " checked=\"checked\"" : ""; if ($selwrk <> "") $emptywrk = FALSE; // Note: No spacing within the LABEL tag ?> <?php echo ew_RepeatColumnTable($rowswrk, $rowcntwrk, 5, 1) ?> <label><input type="radio" name="x_Status" id="x_Status" title="<?php echo $CPDTrainingMaterial->Status->FldTitle() ?>" value="<?php echo ew_HtmlEncode($arwrk[$rowcntwrk][0]) ?>"<?php echo $selwrk ?><?php echo $CPDTrainingMaterial->Status->EditAttributes() ?>><?php echo $arwrk[$rowcntwrk][1] ?></label> <?php echo ew_RepeatColumnTable($rowswrk, $rowcntwrk, 5, 2) ?> <?php } } ?> </div> </span> </div> </td> </tr> <tr> <td><span class="phpmaker"><?php echo $CPDTrainingMaterial->AccredNum->FldCaption() ?></span></td> <td><span class="ewSearchOpr"><?php echo $Language->Phrase("LIKE") ?><input type="hidden" name="z_AccredNum" id="z_AccredNum" value="LIKE"></span></td> <td> <div style="white-space: nowrap;"> <span class="phpmaker" style="float: left;"> <input type="text" name="x_AccredNum" id="x_AccredNum" title="<?php echo $CPDTrainingMaterial->AccredNum->FldTitle() ?>" size="30" maxlength="50" value="<?php echo $CPDTrainingMaterial->AccredNum->EditValue ?>"<?php echo $CPDTrainingMaterial->AccredNum->EditAttributes() ?>> </span> </div> </td> </tr> <tr> <td><span class="phpmaker"><?php echo $CPDTrainingMaterial->PrevAccredNum->FldCaption() ?></span></td> <td><span class="ewSearchOpr"><?php echo $Language->Phrase("LIKE") ?><input type="hidden" name="z_PrevAccredNum" id="z_PrevAccredNum" value="LIKE"></span></td> <td> <div style="white-space: nowrap;"> <span class="phpmaker" style="float: left;"> <input type="text" name="x_PrevAccredNum" id="x_PrevAccredNum" title="<?php echo $CPDTrainingMaterial->PrevAccredNum->FldTitle() ?>" size="30" maxlength="50" value="<?php echo $CPDTrainingMaterial->PrevAccredNum->EditValue ?>"<?php echo $CPDTrainingMaterial->PrevAccredNum->EditAttributes() ?>> </span> </div> </td> </tr> <tr> <td><span class="phpmaker"><?php echo $CPDTrainingMaterial->DateApproved->FldCaption() ?></span></td> <td><span class="ewSearchOpr"><?php echo $Language->Phrase("BETWEEN") ?><input type="hidden" name="z_DateApproved" id="z_DateApproved" value="BETWEEN"></span></td> <td> <div style="white-space: nowrap;"> <span class="phpmaker" style="float: left;"> <input type="text" name="x_DateApproved" id="x_DateApproved" title="<?php echo $CPDTrainingMaterial->DateApproved->FldTitle() ?>" value="<?php echo $CPDTrainingMaterial->DateApproved->EditValue ?>"<?php echo $CPDTrainingMaterial->DateApproved->EditAttributes() ?>> <img src="images/calendar.png" id="cal_x_DateApproved" name="cal_x_DateApproved" alt="<?php echo $Language->Phrase("PickDate") ?>" title="<?php echo $Language->Phrase("PickDate") ?>" style="cursor:pointer;cursor:hand;"> <script type="text/javascript"> Calendar.setup({ inputField: "x_DateApproved", // input field id ifFormat: "%Y/%m/%d", // date format button: "cal_x_DateApproved" // button id }); </script> </span> <span class="ewSearchOpr" id="btw1_DateApproved" name="btw1_DateApproved"> <?php echo $Language->Phrase("AND") ?> </span> <span class="phpmaker" style="float: left;" id="btw1_DateApproved" name="btw1_DateApproved"> <input type="text" name="y_DateApproved" id="y_DateApproved" title="<?php echo $CPDTrainingMaterial->DateApproved->FldTitle() ?>" value="<?php echo $CPDTrainingMaterial->DateApproved->EditValue2 ?>"<?php echo $CPDTrainingMaterial->DateApproved->EditAttributes() ?>> <img src="images/calendar.png" id="cal_y_DateApproved" name="cal_y_DateApproved" alt="<?php echo $Language->Phrase("PickDate") ?>" title="<?php echo $Language->Phrase("PickDate") ?>" style="cursor:pointer;cursor:hand;"> <script type="text/javascript"> Calendar.setup({ inputField: "y_DateApproved", // input field id ifFormat: "%Y/%m/%d", // date format button: "cal_y_DateApproved" // button id }); </script> </span> </div> </td> </tr> </table> <table class="ewBasicSearch"> <tr> <td><span class="phpmaker"> <input type="text" name="<?php echo EW_TABLE_BASIC_SEARCH ?>" id="<?php echo EW_TABLE_BASIC_SEARCH ?>" size="20" value="<?php echo ew_HtmlEncode($CPDTrainingMaterial->getSessionBasicSearchKeyword()) ?>"> <input type="Submit" name="Submit" id="Submit" value="<?php echo ew_BtnCaption($Language->Phrase("QuickSearchBtn")) ?>"> <a href="<?php echo $CPDTrainingMaterial_list->PageUrl() ?>cmd=reset"><?php echo $Language->Phrase("ShowAll") ?></a> </span></td> </tr> <tr> <td><span class="phpmaker"><label><input type="radio" name="<?php echo EW_TABLE_BASIC_SEARCH_TYPE ?>" id="<?php echo EW_TABLE_BASIC_SEARCH_TYPE ?>" value=""<?php if ($CPDTrainingMaterial->getSessionBasicSearchType() == "") { ?> checked="checked"<?php } ?>><?php echo $Language->Phrase("ExactPhrase") ?></label> <label><input type="radio" name="<?php echo EW_TABLE_BASIC_SEARCH_TYPE ?>" id="<?php echo EW_TABLE_BASIC_SEARCH_TYPE ?>" value="AND"<?php if ($CPDTrainingMaterial->getSessionBasicSearchType() == "AND") { ?> checked="checked"<?php } ?>><?php echo $Language->Phrase("AllWord") ?></label> <label><input type="radio" name="<?php echo EW_TABLE_BASIC_SEARCH_TYPE ?>" id="<?php echo EW_TABLE_BASIC_SEARCH_TYPE ?>" value="OR"<?php if ($CPDTrainingMaterial->getSessionBasicSearchType() == "OR") { ?> checked="checked"<?php } ?>><?php echo $Language->Phrase("AnyWord") ?></label></span></td> </tr> </table> </form> </div> <?php } ?> <?php } ?> <?php if (EW_DEBUG_ENABLED) echo ew_DebugMsg(); $CPDTrainingMaterial_list->ShowMessage(); ?> <br> <table cellspacing="0" class="ewGrid"><tr><td class="ewGridContent"> <?php if ($CPDTrainingMaterial->Export == "") { ?> <div class="ewGridUpperPanel"> <?php if ($CPDTrainingMaterial->CurrentAction <> "gridadd" && $CPDTrainingMaterial->CurrentAction <> "gridedit") { ?> <form name="ewpagerform" id="ewpagerform" class="ewForm" action="<?php echo ew_CurrentPage() ?>"> <table border="0" cellspacing="0" cellpadding="0" class="ewPager"> <tr> <td nowrap> <?php if (!isset($CPDTrainingMaterial_list->Pager)) $CPDTrainingMaterial_list->Pager = new cPrevNextPager($CPDTrainingMaterial_list->lStartRec, $CPDTrainingMaterial_list->lDisplayRecs, $CPDTrainingMaterial_list->lTotalRecs) ?> <?php if ($CPDTrainingMaterial_list->Pager->RecordCount > 0) { ?> <table border="0" cellspacing="0" cellpadding="0"><tr><td><span class="phpmaker"><?php echo $Language->Phrase("Page") ?> </span></td> <!--first page button--> <?php if ($CPDTrainingMaterial_list->Pager->FirstButton->Enabled) { ?> <td><a href="<?php echo $CPDTrainingMaterial_list->PageUrl() ?>start=<?php echo $CPDTrainingMaterial_list->Pager->FirstButton->Start ?>"><img src="images/first.gif" alt="<?php echo $Language->Phrase("PagerFirst") ?>" width="16" height="16" border="0"></a></td> <?php } else { ?> <td><img src="images/firstdisab.gif" alt="<?php echo $Language->Phrase("PagerFirst") ?>" width="16" height="16" border="0"></td> <?php } ?> <!--previous page button--> <?php if ($CPDTrainingMaterial_list->Pager->PrevButton->Enabled) { ?> <td><a href="<?php echo $CPDTrainingMaterial_list->PageUrl() ?>start=<?php echo $CPDTrainingMaterial_list->Pager->PrevButton->Start ?>"><img src="images/prev.gif" alt="<?php echo $Language->Phrase("PagerPrevious") ?>" width="16" height="16" border="0"></a></td> <?php } else { ?> <td><img src="images/prevdisab.gif" alt="<?php echo $Language->Phrase("PagerPrevious") ?>" width="16" height="16" border="0"></td> <?php } ?> <!--current page number--> <td><input type="text" name="<?php echo EW_TABLE_PAGE_NO ?>" id="<?php echo EW_TABLE_PAGE_NO ?>" value="<?php echo $CPDTrainingMaterial_list->Pager->CurrentPage ?>" size="4"></td> <!--next page button--> <?php if ($CPDTrainingMaterial_list->Pager->NextButton->Enabled) { ?> <td><a href="<?php echo $CPDTrainingMaterial_list->PageUrl() ?>start=<?php echo $CPDTrainingMaterial_list->Pager->NextButton->Start ?>"><img src="images/next.gif" alt="<?php echo $Language->Phrase("PagerNext") ?>" width="16" height="16" border="0"></a></td> <?php } else { ?> <td><img src="images/nextdisab.gif" alt="<?php echo $Language->Phrase("PagerNext") ?>" width="16" height="16" border="0"></td> <?php } ?> <!--last page button--> <?php if ($CPDTrainingMaterial_list->Pager->LastButton->Enabled) { ?> <td><a href="<?php echo $CPDTrainingMaterial_list->PageUrl() ?>start=<?php echo $CPDTrainingMaterial_list->Pager->LastButton->Start ?>"><img src="images/last.gif" alt="<?php echo $Language->Phrase("PagerLast") ?>" width="16" height="16" border="0"></a></td> <?php } else { ?> <td><img src="images/lastdisab.gif" alt="<?php echo $Language->Phrase("PagerLast") ?>" width="16" height="16" border="0"></td> <?php } ?> <td><span class="phpmaker"> <?php echo $Language->Phrase("of") ?> <?php echo $CPDTrainingMaterial_list->Pager->PageCount ?></span></td> </tr></table> </td> <td> </td> <td> <span class="phpmaker"><?php echo $Language->Phrase("Record") ?> <?php echo $CPDTrainingMaterial_list->Pager->FromIndex ?> <?php echo $Language->Phrase("To") ?> <?php echo $CPDTrainingMaterial_list->Pager->ToIndex ?> <?php echo $Language->Phrase("Of") ?> <?php echo $CPDTrainingMaterial_list->Pager->RecordCount ?></span> <?php } else { ?> <?php if ($CPDTrainingMaterial_list->sSrchWhere == "0=101") { ?> <span class="phpmaker"><?php echo $Language->Phrase("EnterSearchCriteria") ?></span> <?php } else { ?> <span class="phpmaker"><?php echo $Language->Phrase("NoRecord") ?></span> <?php } ?> <?php } ?> </td> </tr> </table> </form> <?php } ?> <span class="phpmaker"> <?php if ($Security->IsLoggedIn()) { ?> <a href="<?php echo $CPDTrainingMaterial_list->AddUrl ?>"><?php echo $Language->Phrase("AddLink") ?></a> <?php } ?> </span> </div> <?php } ?> <form name="fCPDTrainingMateriallist" id="fCPDTrainingMateriallist" class="ewForm" action="" method="post"> <div id="gmp_CPDTrainingMaterial" class="ewGridMiddlePanel"> <?php if ($CPDTrainingMaterial_list->lTotalRecs > 0) { ?> <table cellspacing="0" rowhighlightclass="ewTableHighlightRow" rowselectclass="ewTableSelectRow" roweditclass="ewTableEditRow" class="ewTable ewTableSeparate"> <?php echo $CPDTrainingMaterial->TableCustomInnerHtml ?> <thead><!-- Table header --> <tr class="ewTableHeader"> <?php // Render list options $CPDTrainingMaterial_list->RenderListOptions(); // Render list options (header, left) $CPDTrainingMaterial_list->ListOptions->Render("header", "left"); ?> <?php if ($CPDTrainingMaterial->ProviderID->Visible) { // ProviderID ?> <?php if ($CPDTrainingMaterial->SortUrl($CPDTrainingMaterial->ProviderID) == "") { ?> <td><?php echo $CPDTrainingMaterial->ProviderID->FldCaption() ?></td> <?php } else { ?> <td><div class="ewPointer" onmousedown="ew_Sort(event,'<?php echo $CPDTrainingMaterial->SortUrl($CPDTrainingMaterial->ProviderID) ?>',2);"> <table cellspacing="0" class="ewTableHeaderBtn"><thead><tr><td><?php echo $CPDTrainingMaterial->ProviderID->FldCaption() ?></td><td style="width: 10px;"><?php if ($CPDTrainingMaterial->ProviderID->getSort() == "ASC") { ?><img src="images/sortup.gif" width="10" height="9" border="0"><?php } elseif ($CPDTrainingMaterial->ProviderID->getSort() == "DESC") { ?><img src="images/sortdown.gif" width="10" height="9" border="0"><?php } ?></td></tr></thead></table> </div></td> <?php } ?> <?php } ?> <?php if ($CPDTrainingMaterial->Subject->Visible) { // Subject ?> <?php if ($CPDTrainingMaterial->SortUrl($CPDTrainingMaterial->Subject) == "") { ?> <td><?php echo $CPDTrainingMaterial->Subject->FldCaption() ?></td> <?php } else { ?> <td><div class="ewPointer" onmousedown="ew_Sort(event,'<?php echo $CPDTrainingMaterial->SortUrl($CPDTrainingMaterial->Subject) ?>',2);"> <table cellspacing="0" class="ewTableHeaderBtn"><thead><tr><td><?php echo $CPDTrainingMaterial->Subject->FldCaption() ?><?php echo $Language->Phrase("SrchLegend") ?></td><td style="width: 10px;"><?php if ($CPDTrainingMaterial->Subject->getSort() == "ASC") { ?><img src="images/sortup.gif" width="10" height="9" border="0"><?php } elseif ($CPDTrainingMaterial->Subject->getSort() == "DESC") { ?><img src="images/sortdown.gif" width="10" height="9" border="0"><?php } ?></td></tr></thead></table> </div></td> <?php } ?> <?php } ?> <?php if ($CPDTrainingMaterial->RenewOrNew->Visible) { // RenewOrNew ?> <?php if ($CPDTrainingMaterial->SortUrl($CPDTrainingMaterial->RenewOrNew) == "") { ?> <td><?php echo $CPDTrainingMaterial->RenewOrNew->FldCaption() ?></td> <?php } else { ?> <td><div class="ewPointer" onmousedown="ew_Sort(event,'<?php echo $CPDTrainingMaterial->SortUrl($CPDTrainingMaterial->RenewOrNew) ?>',2);"> <table cellspacing="0" class="ewTableHeaderBtn"><thead><tr><td><?php echo $CPDTrainingMaterial->RenewOrNew->FldCaption() ?></td><td style="width: 10px;"><?php if ($CPDTrainingMaterial->RenewOrNew->getSort() == "ASC") { ?><img src="images/sortup.gif" width="10" height="9" border="0"><?php } elseif ($CPDTrainingMaterial->RenewOrNew->getSort() == "DESC") { ?><img src="images/sortdown.gif" width="10" height="9" border="0"><?php } ?></td></tr></thead></table> </div></td> <?php } ?> <?php } ?> <?php if ($CPDTrainingMaterial->Status->Visible) { // Status ?> <?php if ($CPDTrainingMaterial->SortUrl($CPDTrainingMaterial->Status) == "") { ?> <td><?php echo $CPDTrainingMaterial->Status->FldCaption() ?></td> <?php } else { ?> <td><div class="ewPointer" onmousedown="ew_Sort(event,'<?php echo $CPDTrainingMaterial->SortUrl($CPDTrainingMaterial->Status) ?>',2);"> <table cellspacing="0" class="ewTableHeaderBtn"><thead><tr><td><?php echo $CPDTrainingMaterial->Status->FldCaption() ?></td><td style="width: 10px;"><?php if ($CPDTrainingMaterial->Status->getSort() == "ASC") { ?><img src="images/sortup.gif" width="10" height="9" border="0"><?php } elseif ($CPDTrainingMaterial->Status->getSort() == "DESC") { ?><img src="images/sortdown.gif" width="10" height="9" border="0"><?php } ?></td></tr></thead></table> </div></td> <?php } ?> <?php } ?> <?php if ($CPDTrainingMaterial->AccredNum->Visible) { // AccredNum ?> <?php if ($CPDTrainingMaterial->SortUrl($CPDTrainingMaterial->AccredNum) == "") { ?> <td><?php echo $CPDTrainingMaterial->AccredNum->FldCaption() ?></td> <?php } else { ?> <td><div class="ewPointer" onmousedown="ew_Sort(event,'<?php echo $CPDTrainingMaterial->SortUrl($CPDTrainingMaterial->AccredNum) ?>',2);"> <table cellspacing="0" class="ewTableHeaderBtn"><thead><tr><td><?php echo $CPDTrainingMaterial->AccredNum->FldCaption() ?><?php echo $Language->Phrase("SrchLegend") ?></td><td style="width: 10px;"><?php if ($CPDTrainingMaterial->AccredNum->getSort() == "ASC") { ?><img src="images/sortup.gif" width="10" height="9" border="0"><?php } elseif ($CPDTrainingMaterial->AccredNum->getSort() == "DESC") { ?><img src="images/sortdown.gif" width="10" height="9" border="0"><?php } ?></td></tr></thead></table> </div></td> <?php } ?> <?php } ?> <?php if ($CPDTrainingMaterial->PrevAccredNum->Visible) { // PrevAccredNum ?> <?php if ($CPDTrainingMaterial->SortUrl($CPDTrainingMaterial->PrevAccredNum) == "") { ?> <td><?php echo $CPDTrainingMaterial->PrevAccredNum->FldCaption() ?></td> <?php } else { ?> <td><div class="ewPointer" onmousedown="ew_Sort(event,'<?php echo $CPDTrainingMaterial->SortUrl($CPDTrainingMaterial->PrevAccredNum) ?>',2);"> <table cellspacing="0" class="ewTableHeaderBtn"><thead><tr><td><?php echo $CPDTrainingMaterial->PrevAccredNum->FldCaption() ?><?php echo $Language->Phrase("SrchLegend") ?></td><td style="width: 10px;"><?php if ($CPDTrainingMaterial->PrevAccredNum->getSort() == "ASC") { ?><img src="images/sortup.gif" width="10" height="9" border="0"><?php } elseif ($CPDTrainingMaterial->PrevAccredNum->getSort() == "DESC") { ?><img src="images/sortdown.gif" width="10" height="9" border="0"><?php } ?></td></tr></thead></table> </div></td> <?php } ?> <?php } ?> <?php if ($CPDTrainingMaterial->DateApproved->Visible) { // DateApproved ?> <?php if ($CPDTrainingMaterial->SortUrl($CPDTrainingMaterial->DateApproved) == "") { ?> <td><?php echo $CPDTrainingMaterial->DateApproved->FldCaption() ?></td> <?php } else { ?> <td><div class="ewPointer" onmousedown="ew_Sort(event,'<?php echo $CPDTrainingMaterial->SortUrl($CPDTrainingMaterial->DateApproved) ?>',2);"> <table cellspacing="0" class="ewTableHeaderBtn"><thead><tr><td><?php echo $CPDTrainingMaterial->DateApproved->FldCaption() ?></td><td style="width: 10px;"><?php if ($CPDTrainingMaterial->DateApproved->getSort() == "ASC") { ?><img src="images/sortup.gif" width="10" height="9" border="0"><?php } elseif ($CPDTrainingMaterial->DateApproved->getSort() == "DESC") { ?><img src="images/sortdown.gif" width="10" height="9" border="0"><?php } ?></td></tr></thead></table> </div></td> <?php } ?> <?php } ?> <?php if ($CPDTrainingMaterial->DatePaid->Visible) { // DatePaid ?> <?php if ($CPDTrainingMaterial->SortUrl($CPDTrainingMaterial->DatePaid) == "") { ?> <td><?php echo $CPDTrainingMaterial->DatePaid->FldCaption() ?></td> <?php } else { ?> <td><div class="ewPointer" onmousedown="ew_Sort(event,'<?php echo $CPDTrainingMaterial->SortUrl($CPDTrainingMaterial->DatePaid) ?>',2);"> <table cellspacing="0" class="ewTableHeaderBtn"><thead><tr><td><?php echo $CPDTrainingMaterial->DatePaid->FldCaption() ?></td><td style="width: 10px;"><?php if ($CPDTrainingMaterial->DatePaid->getSort() == "ASC") { ?><img src="images/sortup.gif" width="10" height="9" border="0"><?php } elseif ($CPDTrainingMaterial->DatePaid->getSort() == "DESC") { ?><img src="images/sortdown.gif" width="10" height="9" border="0"><?php } ?></td></tr></thead></table> </div></td> <?php } ?> <?php } ?> <?php if ($CPDTrainingMaterial->DateCreated->Visible) { // DateCreated ?> <?php if ($CPDTrainingMaterial->SortUrl($CPDTrainingMaterial->DateCreated) == "") { ?> <td><?php echo $CPDTrainingMaterial->DateCreated->FldCaption() ?></td> <?php } else { ?> <td><div class="ewPointer" onmousedown="ew_Sort(event,'<?php echo $CPDTrainingMaterial->SortUrl($CPDTrainingMaterial->DateCreated) ?>',2);"> <table cellspacing="0" class="ewTableHeaderBtn"><thead><tr><td><?php echo $CPDTrainingMaterial->DateCreated->FldCaption() ?></td><td style="width: 10px;"><?php if ($CPDTrainingMaterial->DateCreated->getSort() == "ASC") { ?><img src="images/sortup.gif" width="10" height="9" border="0"><?php } elseif ($CPDTrainingMaterial->DateCreated->getSort() == "DESC") { ?><img src="images/sortdown.gif" width="10" height="9" border="0"><?php } ?></td></tr></thead></table> </div></td> <?php } ?> <?php } ?> <?php // Render list options (header, right) $CPDTrainingMaterial_list->ListOptions->Render("header", "right"); ?> </tr> </thead> <?php if ($CPDTrainingMaterial->ExportAll && $CPDTrainingMaterial->Export <> "") { $CPDTrainingMaterial_list->lStopRec = $CPDTrainingMaterial_list->lTotalRecs; } else { $CPDTrainingMaterial_list->lStopRec = $CPDTrainingMaterial_list->lStartRec + $CPDTrainingMaterial_list->lDisplayRecs - 1; // Set the last record to display } $CPDTrainingMaterial_list->lRecCount = $CPDTrainingMaterial_list->lStartRec - 1; if ($rs && !$rs->EOF) { $rs->MoveFirst(); if (!$bSelectLimit && $CPDTrainingMaterial_list->lStartRec > 1) $rs->Move($CPDTrainingMaterial_list->lStartRec - 1); } // Initialize aggregate $CPDTrainingMaterial->RowType = EW_ROWTYPE_AGGREGATEINIT; $CPDTrainingMaterial_list->RenderRow(); $CPDTrainingMaterial_list->lRowCnt = 0; while (($CPDTrainingMaterial->CurrentAction == "gridadd" || !$rs->EOF) && $CPDTrainingMaterial_list->lRecCount < $CPDTrainingMaterial_list->lStopRec) { $CPDTrainingMaterial_list->lRecCount++; if (intval($CPDTrainingMaterial_list->lRecCount) >= intval($CPDTrainingMaterial_list->lStartRec)) { $CPDTrainingMaterial_list->lRowCnt++; // Init row class and style $CPDTrainingMaterial->CssClass = ""; $CPDTrainingMaterial->CssStyle = ""; $CPDTrainingMaterial->RowAttrs = array('onmouseover'=>'ew_MouseOver(event, this);', 'onmouseout'=>'ew_MouseOut(event, this);', 'onclick'=>'ew_Click(event, this);'); if ($CPDTrainingMaterial->CurrentAction == "gridadd") { $CPDTrainingMaterial_list->LoadDefaultValues(); // Load default values } else { $CPDTrainingMaterial_list->LoadRowValues($rs); // Load row values } $CPDTrainingMaterial->RowType = EW_ROWTYPE_VIEW; // Render view // Render row $CPDTrainingMaterial_list->RenderRow(); // Render list options $CPDTrainingMaterial_list->RenderListOptions(); ?> <tr<?php echo $CPDTrainingMaterial->RowAttributes() ?>> <?php // Render list options (body, left) $CPDTrainingMaterial_list->ListOptions->Render("body", "left"); ?> <?php if ($CPDTrainingMaterial->ProviderID->Visible) { // ProviderID ?> <td<?php echo $CPDTrainingMaterial->ProviderID->CellAttributes() ?>> <div<?php echo $CPDTrainingMaterial->ProviderID->ViewAttributes() ?>><?php echo $CPDTrainingMaterial->ProviderID->ListViewValue() ?></div> </td> <?php } ?> <?php if ($CPDTrainingMaterial->Subject->Visible) { // Subject ?> <td<?php echo $CPDTrainingMaterial->Subject->CellAttributes() ?>> <div<?php echo $CPDTrainingMaterial->Subject->ViewAttributes() ?>><?php echo $CPDTrainingMaterial->Subject->ListViewValue() ?></div> </td> <?php } ?> <?php if ($CPDTrainingMaterial->RenewOrNew->Visible) { // RenewOrNew ?> <td<?php echo $CPDTrainingMaterial->RenewOrNew->CellAttributes() ?>> <div<?php echo $CPDTrainingMaterial->RenewOrNew->ViewAttributes() ?>><?php echo $CPDTrainingMaterial->RenewOrNew->ListViewValue() ?></div> </td> <?php } ?> <?php if ($CPDTrainingMaterial->Status->Visible) { // Status ?> <td<?php echo $CPDTrainingMaterial->Status->CellAttributes() ?>> <div<?php echo $CPDTrainingMaterial->Status->ViewAttributes() ?>><?php echo $CPDTrainingMaterial->Status->ListViewValue() ?></div> </td> <?php } ?> <?php if ($CPDTrainingMaterial->AccredNum->Visible) { // AccredNum ?> <td<?php echo $CPDTrainingMaterial->AccredNum->CellAttributes() ?>> <div<?php echo $CPDTrainingMaterial->AccredNum->ViewAttributes() ?>><?php echo $CPDTrainingMaterial->AccredNum->ListViewValue() ?></div> </td> <?php } ?> <?php if ($CPDTrainingMaterial->PrevAccredNum->Visible) { // PrevAccredNum ?> <td<?php echo $CPDTrainingMaterial->PrevAccredNum->CellAttributes() ?>> <div<?php echo $CPDTrainingMaterial->PrevAccredNum->ViewAttributes() ?>><?php echo $CPDTrainingMaterial->PrevAccredNum->ListViewValue() ?></div> </td> <?php } ?> <?php if ($CPDTrainingMaterial->DateApproved->Visible) { // DateApproved ?> <td<?php echo $CPDTrainingMaterial->DateApproved->CellAttributes() ?>> <div<?php echo $CPDTrainingMaterial->DateApproved->ViewAttributes() ?>><?php echo $CPDTrainingMaterial->DateApproved->ListViewValue() ?></div> </td> <?php } ?> <?php if ($CPDTrainingMaterial->DatePaid->Visible) { // DatePaid ?> <td<?php echo $CPDTrainingMaterial->DatePaid->CellAttributes() ?>> <div<?php echo $CPDTrainingMaterial->DatePaid->ViewAttributes() ?>><?php echo $CPDTrainingMaterial->DatePaid->ListViewValue() ?></div> </td> <?php } ?> <?php if ($CPDTrainingMaterial->DateCreated->Visible) { // DateCreated ?> <td<?php echo $CPDTrainingMaterial->DateCreated->CellAttributes() ?>> <div<?php echo $CPDTrainingMaterial->DateCreated->ViewAttributes() ?>><?php echo $CPDTrainingMaterial->DateCreated->ListViewValue() ?></div> </td> <?php } ?> <?php // Render list options (body, right) $CPDTrainingMaterial_list->ListOptions->Render("body", "right"); ?> </tr> <?php } if ($CPDTrainingMaterial->CurrentAction <> "gridadd") $rs->MoveNext(); } ?> </tbody> </table> <?php } ?> </div> </form> <?php // Close recordset if ($rs) $rs->Close(); ?> <?php if ($CPDTrainingMaterial_list->lTotalRecs > 0) { ?> <?php if ($CPDTrainingMaterial->Export == "") { ?> <div class="ewGridLowerPanel"> <?php if ($CPDTrainingMaterial->CurrentAction <> "gridadd" && $CPDTrainingMaterial->CurrentAction <> "gridedit") { ?> <form name="ewpagerform" id="ewpagerform" class="ewForm" action="<?php echo ew_CurrentPage() ?>"> <table border="0" cellspacing="0" cellpadding="0" class="ewPager"> <tr> <td nowrap> <?php if (!isset($CPDTrainingMaterial_list->Pager)) $CPDTrainingMaterial_list->Pager = new cPrevNextPager($CPDTrainingMaterial_list->lStartRec, $CPDTrainingMaterial_list->lDisplayRecs, $CPDTrainingMaterial_list->lTotalRecs) ?> <?php if ($CPDTrainingMaterial_list->Pager->RecordCount > 0) { ?> <table border="0" cellspacing="0" cellpadding="0"><tr><td><span class="phpmaker"><?php echo $Language->Phrase("Page") ?> </span></td> <!--first page button--> <?php if ($CPDTrainingMaterial_list->Pager->FirstButton->Enabled) { ?> <td><a href="<?php echo $CPDTrainingMaterial_list->PageUrl() ?>start=<?php echo $CPDTrainingMaterial_list->Pager->FirstButton->Start ?>"><img src="images/first.gif" alt="<?php echo $Language->Phrase("PagerFirst") ?>" width="16" height="16" border="0"></a></td> <?php } else { ?> <td><img src="images/firstdisab.gif" alt="<?php echo $Language->Phrase("PagerFirst") ?>" width="16" height="16" border="0"></td> <?php } ?> <!--previous page button--> <?php if ($CPDTrainingMaterial_list->Pager->PrevButton->Enabled) { ?> <td><a href="<?php echo $CPDTrainingMaterial_list->PageUrl() ?>start=<?php echo $CPDTrainingMaterial_list->Pager->PrevButton->Start ?>"><img src="images/prev.gif" alt="<?php echo $Language->Phrase("PagerPrevious") ?>" width="16" height="16" border="0"></a></td> <?php } else { ?> <td><img src="images/prevdisab.gif" alt="<?php echo $Language->Phrase("PagerPrevious") ?>" width="16" height="16" border="0"></td> <?php } ?> <!--current page number--> <td><input type="text" name="<?php echo EW_TABLE_PAGE_NO ?>" id="<?php echo EW_TABLE_PAGE_NO ?>" value="<?php echo $CPDTrainingMaterial_list->Pager->CurrentPage ?>" size="4"></td> <!--next page button--> <?php if ($CPDTrainingMaterial_list->Pager->NextButton->Enabled) { ?> <td><a href="<?php echo $CPDTrainingMaterial_list->PageUrl() ?>start=<?php echo $CPDTrainingMaterial_list->Pager->NextButton->Start ?>"><img src="images/next.gif" alt="<?php echo $Language->Phrase("PagerNext") ?>" width="16" height="16" border="0"></a></td> <?php } else { ?> <td><img src="images/nextdisab.gif" alt="<?php echo $Language->Phrase("PagerNext") ?>" width="16" height="16" border="0"></td> <?php } ?> <!--last page button--> <?php if ($CPDTrainingMaterial_list->Pager->LastButton->Enabled) { ?> <td><a href="<?php echo $CPDTrainingMaterial_list->PageUrl() ?>start=<?php echo $CPDTrainingMaterial_list->Pager->LastButton->Start ?>"><img src="images/last.gif" alt="<?php echo $Language->Phrase("PagerLast") ?>" width="16" height="16" border="0"></a></td> <?php } else { ?> <td><img src="images/lastdisab.gif" alt="<?php echo $Language->Phrase("PagerLast") ?>" width="16" height="16" border="0"></td> <?php } ?> <td><span class="phpmaker"> <?php echo $Language->Phrase("of") ?> <?php echo $CPDTrainingMaterial_list->Pager->PageCount ?></span></td> </tr></table> </td> <td> </td> <td> <span class="phpmaker"><?php echo $Language->Phrase("Record") ?> <?php echo $CPDTrainingMaterial_list->Pager->FromIndex ?> <?php echo $Language->Phrase("To") ?> <?php echo $CPDTrainingMaterial_list->Pager->ToIndex ?> <?php echo $Language->Phrase("Of") ?> <?php echo $CPDTrainingMaterial_list->Pager->RecordCount ?></span> <?php } else { ?> <?php if ($CPDTrainingMaterial_list->sSrchWhere == "0=101") { ?> <span class="phpmaker"><?php echo $Language->Phrase("EnterSearchCriteria") ?></span> <?php } else { ?> <span class="phpmaker"><?php echo $Language->Phrase("NoRecord") ?></span> <?php } ?> <?php } ?> </td> </tr> </table> </form> <?php } ?> <?php //if ($CPDTrainingMaterial_list->lTotalRecs > 0) { ?> <span class="phpmaker"> <?php if ($Security->IsLoggedIn()) { ?> <a href="<?php echo $CPDTrainingMaterial_list->AddUrl ?>"><?php echo $Language->Phrase("AddLink") ?></a> <?php } ?> </span> <?php //} ?> </div> <?php } ?> <?php } ?> </td></tr></table> <?php if ($CPDTrainingMaterial->Export == "" && $CPDTrainingMaterial->CurrentAction == "") { ?> <?php } ?> <?php if ($CPDTrainingMaterial->Export == "") { ?> <script language="JavaScript" type="text/javascript"> <!-- // Write your table-specific startup script here // document.write("page loaded"); //--> </script> <?php } ?> <?php include "footer.php" ?> <?php $CPDTrainingMaterial_list->Page_Terminate(); ?> <?php // // Page class // class cCPDTrainingMaterial_list { // Page ID var $PageID = 'list'; // Table name var $TableName = 'CPDTrainingMaterial'; // Page object name var $PageObjName = 'CPDTrainingMaterial_list'; // Page name function PageName() { return ew_CurrentPage(); } // Page URL function PageUrl() { $PageUrl = ew_CurrentPage() . "?"; global $CPDTrainingMaterial; if ($CPDTrainingMaterial->UseTokenInUrl) $PageUrl .= "t=" . $CPDTrainingMaterial->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, $CPDTrainingMaterial; if ($CPDTrainingMaterial->UseTokenInUrl) { if ($objForm) return ($CPDTrainingMaterial->TableVar == $objForm->GetValue("t")); if (@$_GET["t"] <> "") return ($CPDTrainingMaterial->TableVar == $_GET["t"]); } else { return TRUE; } } // // Page class constructor // function __construct() { global $conn, $Language; // Language object $Language = new cLanguage(); // Table object (CPDTrainingMaterial) $GLOBALS["CPDTrainingMaterial"] = new cCPDTrainingMaterial(); // Initialize URLs $this->ExportPrintUrl = $this->PageUrl() . "export=print"; $this->ExportExcelUrl = $this->PageUrl() . "export=excel"; $this->ExportWordUrl = $this->PageUrl() . "export=word"; $this->ExportHtmlUrl = $this->PageUrl() . "export=html"; $this->ExportXmlUrl = $this->PageUrl() . "export=xml"; $this->ExportCsvUrl = $this->PageUrl() . "export=csv"; $this->AddUrl = $GLOBALS["CPDTrainingMaterial"]->AddUrl(); $this->InlineAddUrl = $this->PageUrl() . "a=add"; $this->GridAddUrl = $this->PageUrl() . "a=gridadd"; $this->GridEditUrl = $this->PageUrl() . "a=gridedit"; $this->MultiDeleteUrl = "CPDTrainingMaterialdelete.php"; $this->MultiUpdateUrl = "CPDTrainingMaterialupdate.php"; // Table object (CPDServiceProvider) $GLOBALS['CPDServiceProvider'] = new cCPDServiceProvider(); // Table object (CPDAdminUsers) $GLOBALS['CPDAdminUsers'] = new cCPDAdminUsers(); // Page ID if (!defined("EW_PAGE_ID")) define("EW_PAGE_ID", 'list', TRUE); // Table name (for backward compatibility) if (!defined("EW_TABLE_NAME")) define("EW_TABLE_NAME", 'CPDTrainingMaterial', TRUE); // Start timer $GLOBALS["gsTimer"] = new cTimer(); // Open connection $conn = ew_Connect(); // List options $this->ListOptions = new cListOptions(); } // // Page_Init // function Page_Init() { global $gsExport, $gsExportFile, $UserProfile, $Language, $Security, $objForm; global $CPDTrainingMaterial; // 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"); } // Get export parameters if (@$_GET["export"] <> "") { $CPDTrainingMaterial->Export = $_GET["export"]; } elseif (ew_IsHttpPost()) { if (@$_POST["exporttype"] <> "") $CPDTrainingMaterial->Export = $_POST["exporttype"]; } else { $CPDTrainingMaterial->setExportReturnUrl(ew_CurrentUrl()); } $gsExport = $CPDTrainingMaterial->Export; // Get export parameter, used in header $gsExportFile = $CPDTrainingMaterial->TableVar; // Get export file, used in header if ($CPDTrainingMaterial->Export == "excel") { header('Content-Type: application/vnd.ms-excel'); header('Content-Disposition: attachment; filename=' . $gsExportFile .'.xls'); } if ($CPDTrainingMaterial->Export == "word") { header('Content-Type: application/vnd.ms-word'); header('Content-Disposition: attachment; filename=' . $gsExportFile .'.doc'); } // 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(); } // Class variables var $ListOptions; // List options var $lDisplayRecs = 20; var $lStartRec; var $lStopRec; var $lTotalRecs = 0; var $lRecRange = 10; var $sSrchWhere = ""; // Search WHERE clause var $lRecCnt = 0; // Record count var $lEditRowCnt; var $lRowCnt; var $lRowIndex; // Row index var $lRecPerRow = 0; var $lColCnt = 0; var $sDbMasterFilter = ""; // Master filter var $sDbDetailFilter = ""; // Detail filter var $bMasterRecordExists; var $sMultiSelectKey; var $RestoreSearch; // // Page main // function Page_Main() { global $objForm, $Language, $gsSearchError, $Security, $CPDTrainingMaterial; // Search filters $sSrchAdvanced = ""; // Advanced search filter $sSrchBasic = ""; // Basic search filter $sFilter = ""; if ($this->IsPageRequest()) { // Validate request // Handle reset command $this->ResetCmd(); // Set up master detail parameters $this->SetUpMasterDetail(); // Set up list options $this->SetupListOptions(); // Get basic search values $this->LoadBasicSearchValues(); // Get and validate search values for advanced search $this->LoadSearchValues(); // Get search values if (!$this->ValidateSearch()) $this->setMessage($gsSearchError); // Restore search parms from Session $this->RestoreSearchParms(); // Call Recordset SearchValidated event $CPDTrainingMaterial->Recordset_SearchValidated(); // Set up sorting order $this->SetUpSortOrder(); // Get basic search criteria if ($gsSearchError == "") $sSrchBasic = $this->BasicSearchWhere(); // Get search criteria for advanced search if ($gsSearchError == "") $sSrchAdvanced = $this->AdvancedSearchWhere(); } // Restore display records if ($CPDTrainingMaterial->getRecordsPerPage() <> "") { $this->lDisplayRecs = $CPDTrainingMaterial->getRecordsPerPage(); // Restore from Session } else { $this->lDisplayRecs = 20; // Load default } // Load Sorting Order $this->LoadSortOrder(); // Build search criteria if ($sSrchAdvanced <> "") $this->sSrchWhere = ($this->sSrchWhere <> "") ? "(" . $this->sSrchWhere . ") AND (" . $sSrchAdvanced . ")" : $sSrchAdvanced; if ($sSrchBasic <> "") $this->sSrchWhere = ($this->sSrchWhere <> "") ? "(" . $this->sSrchWhere . ") AND (" . $sSrchBasic. ")" : $sSrchBasic; // Call Recordset_Searching event $CPDTrainingMaterial->Recordset_Searching($this->sSrchWhere); // Save search criteria if ($this->sSrchWhere <> "") { if ($sSrchBasic == "") $this->ResetBasicSearchParms(); if ($sSrchAdvanced == "") $this->ResetAdvancedSearchParms(); $CPDTrainingMaterial->setSearchWhere($this->sSrchWhere); // Save to Session if (!$this->RestoreSearch) { $this->lStartRec = 1; // Reset start record counter $CPDTrainingMaterial->setStartRecordNumber($this->lStartRec); } } else { $this->sSrchWhere = $CPDTrainingMaterial->getSearchWhere(); } // Build filter $sFilter = ""; // Restore master/detail filter $this->sDbMasterFilter = $CPDTrainingMaterial->getMasterFilter(); // Restore master filter $this->sDbDetailFilter = $CPDTrainingMaterial->getDetailFilter(); // Restore detail filter if ($this->sDbDetailFilter <> "") $sFilter = ($sFilter <> "") ? "(" . $sFilter . ") AND (" . $this->sDbDetailFilter . ")" : $this->sDbDetailFilter; if ($this->sSrchWhere <> "") $sFilter = ($sFilter <> "") ? "(" . $sFilter . ") AND (". $this->sSrchWhere . ")" : $this->sSrchWhere; // Load master record if ($CPDTrainingMaterial->getMasterFilter() <> "" && $CPDTrainingMaterial->getCurrentMasterTable() == "CPDServiceProvider") { global $CPDServiceProvider; $rsmaster = $CPDServiceProvider->LoadRs($this->sDbMasterFilter); $this->bMasterRecordExists = ($rsmaster && !$rsmaster->EOF); if (!$this->bMasterRecordExists) { $CPDTrainingMaterial->setMasterFilter(""); // Clear master filter $CPDTrainingMaterial->setDetailFilter(""); // Clear detail filter $this->setMessage($Language->Phrase("NoRecord")); // Set no record found $this->Page_Terminate($CPDTrainingMaterial->getReturnUrl()); // Return to caller } else { $CPDServiceProvider->LoadListRowValues($rsmaster); $CPDServiceProvider->RowType = EW_ROWTYPE_MASTER; // Master row $CPDServiceProvider->RenderListRow(); $rsmaster->Close(); } } // Set up filter in session $CPDTrainingMaterial->setSessionWhere($sFilter); $CPDTrainingMaterial->CurrentFilter = ""; // Export data only if (in_array($CPDTrainingMaterial->Export, array("html","word","excel","xml","csv","email"))) { $this->ExportData(); if ($CPDTrainingMaterial->Export <> "email") $this->Page_Terminate(); // Terminate response exit(); } } // Advanced search WHERE clause based on QueryString function AdvancedSearchWhere() { global $Security, $CPDTrainingMaterial; $sWhere = ""; $this->BuildSearchSql($sWhere, $CPDTrainingMaterial->MaterialID, FALSE); // MaterialID $this->BuildSearchSql($sWhere, $CPDTrainingMaterial->ProviderID, FALSE); // ProviderID $this->BuildSearchSql($sWhere, $CPDTrainingMaterial->Subject, FALSE); // Subject $this->BuildSearchSql($sWhere, $CPDTrainingMaterial->RenewOrNew, FALSE); // RenewOrNew $this->BuildSearchSql($sWhere, $CPDTrainingMaterial->Status, FALSE); // Status $this->BuildSearchSql($sWhere, $CPDTrainingMaterial->Duration, FALSE); // Duration $this->BuildSearchSql($sWhere, $CPDTrainingMaterial->DurationUnit, FALSE); // DurationUnit $this->BuildSearchSql($sWhere, $CPDTrainingMaterial->Level, FALSE); // Level $this->BuildSearchSql($sWhere, $CPDTrainingMaterial->EventDescription, FALSE); // EventDescription $this->BuildSearchSql($sWhere, $CPDTrainingMaterial->TrainingManualLink, FALSE); // TrainingManualLink $this->BuildSearchSql($sWhere, $CPDTrainingMaterial->PresentationLink, FALSE); // PresentationLink $this->BuildSearchSql($sWhere, $CPDTrainingMaterial->HandOutsLink, FALSE); // HandOutsLink $this->BuildSearchSql($sWhere, $CPDTrainingMaterial->LearningOutcomes, FALSE); // LearningOutcomes $this->BuildSearchSql($sWhere, $CPDTrainingMaterial->ModeOfDelivery, FALSE); // ModeOfDelivery $this->BuildSearchSql($sWhere, $CPDTrainingMaterial->TargetAudience, FALSE); // TargetAudience $this->BuildSearchSql($sWhere, $CPDTrainingMaterial->Objectives, FALSE); // Objectives $this->BuildSearchSql($sWhere, $CPDTrainingMaterial->Promotion, FALSE); // Promotion $this->BuildSearchSql($sWhere, $CPDTrainingMaterial->Motivation, FALSE); // Motivation $this->BuildSearchSql($sWhere, $CPDTrainingMaterial->AccredNum, FALSE); // AccredNum $this->BuildSearchSql($sWhere, $CPDTrainingMaterial->PrevAccredNum, FALSE); // PrevAccredNum $this->BuildSearchSql($sWhere, $CPDTrainingMaterial->DateApproved, FALSE); // DateApproved $this->BuildSearchSql($sWhere, $CPDTrainingMaterial->DateExpires, FALSE); // DateExpires $this->BuildSearchSql($sWhere, $CPDTrainingMaterial->Certification, FALSE); // Certification $this->BuildSearchSql($sWhere, $CPDTrainingMaterial->CPD, FALSE); // CPD $this->BuildSearchSql($sWhere, $CPDTrainingMaterial->InvoiceCode, FALSE); // InvoiceCode $this->BuildSearchSql($sWhere, $CPDTrainingMaterial->InvoiceNumber, FALSE); // InvoiceNumber $this->BuildSearchSql($sWhere, $CPDTrainingMaterial->Cost, FALSE); // Cost $this->BuildSearchSql($sWhere, $CPDTrainingMaterial->CostToDelegate, FALSE); // CostToDelegate $this->BuildSearchSql($sWhere, $CPDTrainingMaterial->DepositAmt, FALSE); // DepositAmt $this->BuildSearchSql($sWhere, $CPDTrainingMaterial->InvoiceDate, FALSE); // InvoiceDate $this->BuildSearchSql($sWhere, $CPDTrainingMaterial->DatePaid, FALSE); // DatePaid $this->BuildSearchSql($sWhere, $CPDTrainingMaterial->EvaluatorID, FALSE); // EvaluatorID $this->BuildSearchSql($sWhere, $CPDTrainingMaterial->EvaluatorID2, FALSE); // EvaluatorID2 $this->BuildSearchSql($sWhere, $CPDTrainingMaterial->EvaluatorID3, FALSE); // EvaluatorID3 $this->BuildSearchSql($sWhere, $CPDTrainingMaterial->EvaluatorFee, FALSE); // EvaluatorFee $this->BuildSearchSql($sWhere, $CPDTrainingMaterial->EvaluatorFeeAmount, FALSE); // EvaluatorFeeAmount $this->BuildSearchSql($sWhere, $CPDTrainingMaterial->EvaluatorFeeDate, FALSE); // EvaluatorFeeDate $this->BuildSearchSql($sWhere, $CPDTrainingMaterial->StartDate, FALSE); // StartDate $this->BuildSearchSql($sWhere, $CPDTrainingMaterial->Other_Validator, FALSE); // Other_Validator $this->BuildSearchSql($sWhere, $CPDTrainingMaterial->Provider_URL, FALSE); // Provider_URL $this->BuildSearchSql($sWhere, $CPDTrainingMaterial->Category_Reg, FALSE); // Category_Reg $this->BuildSearchSql($sWhere, $CPDTrainingMaterial->Discipline, FALSE); // Discipline $this->BuildSearchSql($sWhere, $CPDTrainingMaterial->Sub_Discipline, FALSE); // Sub_Discipline $this->BuildSearchSql($sWhere, $CPDTrainingMaterial->Activity_Nature, FALSE); // Activity_Nature $this->BuildSearchSql($sWhere, $CPDTrainingMaterial->Instances, FALSE); // Instances $this->BuildSearchSql($sWhere, $CPDTrainingMaterial->LocalUpload, FALSE); // LocalUpload $this->BuildSearchSql($sWhere, $CPDTrainingMaterial->ResponsiblePersonFirstName, FALSE); // ResponsiblePersonFirstName $this->BuildSearchSql($sWhere, $CPDTrainingMaterial->ResponsiblePersonLastName, FALSE); // ResponsiblePersonLastName $this->BuildSearchSql($sWhere, $CPDTrainingMaterial->ResponsiblePersonEMailAddress, FALSE); // ResponsiblePersonEMailAddress $this->BuildSearchSql($sWhere, $CPDTrainingMaterial->ResponsibleBillingAddress, FALSE); // ResponsibleBillingAddress $this->BuildSearchSql($sWhere, $CPDTrainingMaterial->ResponsiblePersonContactNumber, FALSE); // ResponsiblePersonContactNumber $this->BuildSearchSql($sWhere, $CPDTrainingMaterial->ResponsibleVATNumber, FALSE); // ResponsibleVATNumber $this->BuildSearchSql($sWhere, $CPDTrainingMaterial->Comments, FALSE); // Comments $this->BuildSearchSql($sWhere, $CPDTrainingMaterial->Archived, FALSE); // Archived $this->BuildSearchSql($sWhere, $CPDTrainingMaterial->Presenter1Title, FALSE); // Presenter1Title $this->BuildSearchSql($sWhere, $CPDTrainingMaterial->Presenter1FirstName, FALSE); // Presenter1FirstName $this->BuildSearchSql($sWhere, $CPDTrainingMaterial->Presenter1Surname, FALSE); // Presenter1Surname $this->BuildSearchSql($sWhere, $CPDTrainingMaterial->Presenter1Phone, FALSE); // Presenter1Phone $this->BuildSearchSql($sWhere, $CPDTrainingMaterial->Presenter1Email, FALSE); // Presenter1Email $this->BuildSearchSql($sWhere, $CPDTrainingMaterial->Presenter1ID, FALSE); // Presenter1ID $this->BuildSearchSql($sWhere, $CPDTrainingMaterial->Presenter2Title, FALSE); // Presenter2Title $this->BuildSearchSql($sWhere, $CPDTrainingMaterial->Presenter2FirstName, FALSE); // Presenter2FirstName $this->BuildSearchSql($sWhere, $CPDTrainingMaterial->Presenter2Surname, FALSE); // Presenter2Surname $this->BuildSearchSql($sWhere, $CPDTrainingMaterial->Presenter2Phone, FALSE); // Presenter2Phone $this->BuildSearchSql($sWhere, $CPDTrainingMaterial->Presenter2Email, FALSE); // Presenter2Email $this->BuildSearchSql($sWhere, $CPDTrainingMaterial->Presenter2ID, FALSE); // Presenter2ID $this->BuildSearchSql($sWhere, $CPDTrainingMaterial->Presenter3Title, FALSE); // Presenter3Title $this->BuildSearchSql($sWhere, $CPDTrainingMaterial->Presenter3FirstName, FALSE); // Presenter3FirstName $this->BuildSearchSql($sWhere, $CPDTrainingMaterial->Presenter3Surname, FALSE); // Presenter3Surname $this->BuildSearchSql($sWhere, $CPDTrainingMaterial->Presenter3Phone, FALSE); // Presenter3Phone $this->BuildSearchSql($sWhere, $CPDTrainingMaterial->Presenter3Email, FALSE); // Presenter3Email $this->BuildSearchSql($sWhere, $CPDTrainingMaterial->Presenter3ID, FALSE); // Presenter3ID $this->BuildSearchSql($sWhere, $CPDTrainingMaterial->DateCreated, FALSE); // DateCreated // Set up search parm if ($sWhere <> "") { $this->SetSearchParm($CPDTrainingMaterial->MaterialID); // MaterialID $this->SetSearchParm($CPDTrainingMaterial->ProviderID); // ProviderID $this->SetSearchParm($CPDTrainingMaterial->Subject); // Subject $this->SetSearchParm($CPDTrainingMaterial->RenewOrNew); // RenewOrNew $this->SetSearchParm($CPDTrainingMaterial->Status); // Status $this->SetSearchParm($CPDTrainingMaterial->Duration); // Duration $this->SetSearchParm($CPDTrainingMaterial->DurationUnit); // DurationUnit $this->SetSearchParm($CPDTrainingMaterial->Level); // Level $this->SetSearchParm($CPDTrainingMaterial->EventDescription); // EventDescription $this->SetSearchParm($CPDTrainingMaterial->TrainingManualLink); // TrainingManualLink $this->SetSearchParm($CPDTrainingMaterial->PresentationLink); // PresentationLink $this->SetSearchParm($CPDTrainingMaterial->HandOutsLink); // HandOutsLink $this->SetSearchParm($CPDTrainingMaterial->LearningOutcomes); // LearningOutcomes $this->SetSearchParm($CPDTrainingMaterial->ModeOfDelivery); // ModeOfDelivery $this->SetSearchParm($CPDTrainingMaterial->TargetAudience); // TargetAudience $this->SetSearchParm($CPDTrainingMaterial->Objectives); // Objectives $this->SetSearchParm($CPDTrainingMaterial->Promotion); // Promotion $this->SetSearchParm($CPDTrainingMaterial->Motivation); // Motivation $this->SetSearchParm($CPDTrainingMaterial->AccredNum); // AccredNum $this->SetSearchParm($CPDTrainingMaterial->PrevAccredNum); // PrevAccredNum $this->SetSearchParm($CPDTrainingMaterial->DateApproved); // DateApproved $this->SetSearchParm($CPDTrainingMaterial->DateExpires); // DateExpires $this->SetSearchParm($CPDTrainingMaterial->Certification); // Certification $this->SetSearchParm($CPDTrainingMaterial->CPD); // CPD $this->SetSearchParm($CPDTrainingMaterial->InvoiceCode); // InvoiceCode $this->SetSearchParm($CPDTrainingMaterial->InvoiceNumber); // InvoiceNumber $this->SetSearchParm($CPDTrainingMaterial->Cost); // Cost $this->SetSearchParm($CPDTrainingMaterial->CostToDelegate); // CostToDelegate $this->SetSearchParm($CPDTrainingMaterial->DepositAmt); // DepositAmt $this->SetSearchParm($CPDTrainingMaterial->InvoiceDate); // InvoiceDate $this->SetSearchParm($CPDTrainingMaterial->DatePaid); // DatePaid $this->SetSearchParm($CPDTrainingMaterial->EvaluatorID); // EvaluatorID $this->SetSearchParm($CPDTrainingMaterial->EvaluatorID2); // EvaluatorID2 $this->SetSearchParm($CPDTrainingMaterial->EvaluatorID3); // EvaluatorID3 $this->SetSearchParm($CPDTrainingMaterial->EvaluatorFee); // EvaluatorFee $this->SetSearchParm($CPDTrainingMaterial->EvaluatorFeeAmount); // EvaluatorFeeAmount $this->SetSearchParm($CPDTrainingMaterial->EvaluatorFeeDate); // EvaluatorFeeDate $this->SetSearchParm($CPDTrainingMaterial->StartDate); // StartDate $this->SetSearchParm($CPDTrainingMaterial->Other_Validator); // Other_Validator $this->SetSearchParm($CPDTrainingMaterial->Provider_URL); // Provider_URL $this->SetSearchParm($CPDTrainingMaterial->Category_Reg); // Category_Reg $this->SetSearchParm($CPDTrainingMaterial->Discipline); // Discipline $this->SetSearchParm($CPDTrainingMaterial->Sub_Discipline); // Sub_Discipline $this->SetSearchParm($CPDTrainingMaterial->Activity_Nature); // Activity_Nature $this->SetSearchParm($CPDTrainingMaterial->Instances); // Instances $this->SetSearchParm($CPDTrainingMaterial->LocalUpload); // LocalUpload $this->SetSearchParm($CPDTrainingMaterial->ResponsiblePersonFirstName); // ResponsiblePersonFirstName $this->SetSearchParm($CPDTrainingMaterial->ResponsiblePersonLastName); // ResponsiblePersonLastName $this->SetSearchParm($CPDTrainingMaterial->ResponsiblePersonEMailAddress); // ResponsiblePersonEMailAddress $this->SetSearchParm($CPDTrainingMaterial->ResponsibleBillingAddress); // ResponsibleBillingAddress $this->SetSearchParm($CPDTrainingMaterial->ResponsiblePersonContactNumber); // ResponsiblePersonContactNumber $this->SetSearchParm($CPDTrainingMaterial->ResponsibleVATNumber); // ResponsibleVATNumber $this->SetSearchParm($CPDTrainingMaterial->Comments); // Comments $this->SetSearchParm($CPDTrainingMaterial->Archived); // Archived $this->SetSearchParm($CPDTrainingMaterial->Presenter1Title); // Presenter1Title $this->SetSearchParm($CPDTrainingMaterial->Presenter1FirstName); // Presenter1FirstName $this->SetSearchParm($CPDTrainingMaterial->Presenter1Surname); // Presenter1Surname $this->SetSearchParm($CPDTrainingMaterial->Presenter1Phone); // Presenter1Phone $this->SetSearchParm($CPDTrainingMaterial->Presenter1Email); // Presenter1Email $this->SetSearchParm($CPDTrainingMaterial->Presenter1ID); // Presenter1ID $this->SetSearchParm($CPDTrainingMaterial->Presenter2Title); // Presenter2Title $this->SetSearchParm($CPDTrainingMaterial->Presenter2FirstName); // Presenter2FirstName $this->SetSearchParm($CPDTrainingMaterial->Presenter2Surname); // Presenter2Surname $this->SetSearchParm($CPDTrainingMaterial->Presenter2Phone); // Presenter2Phone $this->SetSearchParm($CPDTrainingMaterial->Presenter2Email); // Presenter2Email $this->SetSearchParm($CPDTrainingMaterial->Presenter2ID); // Presenter2ID $this->SetSearchParm($CPDTrainingMaterial->Presenter3Title); // Presenter3Title $this->SetSearchParm($CPDTrainingMaterial->Presenter3FirstName); // Presenter3FirstName $this->SetSearchParm($CPDTrainingMaterial->Presenter3Surname); // Presenter3Surname $this->SetSearchParm($CPDTrainingMaterial->Presenter3Phone); // Presenter3Phone $this->SetSearchParm($CPDTrainingMaterial->Presenter3Email); // Presenter3Email $this->SetSearchParm($CPDTrainingMaterial->Presenter3ID); // Presenter3ID $this->SetSearchParm($CPDTrainingMaterial->DateCreated); // DateCreated } return $sWhere; } // Build search SQL function BuildSearchSql(&$Where, &$Fld, $MultiValue) { $FldParm = substr($Fld->FldVar, 2); $FldVal = $Fld->AdvancedSearch->SearchValue; // @$_GET["x_$FldParm"] $FldOpr = $Fld->AdvancedSearch->SearchOperator; // @$_GET["z_$FldParm"] $FldCond = $Fld->AdvancedSearch->SearchCondition; // @$_GET["v_$FldParm"] $FldVal2 = $Fld->AdvancedSearch->SearchValue2; // @$_GET["y_$FldParm"] $FldOpr2 = $Fld->AdvancedSearch->SearchOperator2; // @$_GET["w_$FldParm"] $sWrk = ""; //$FldVal = ew_StripSlashes($FldVal); if (is_array($FldVal)) $FldVal = implode(",", $FldVal); //$FldVal2 = ew_StripSlashes($FldVal2); if (is_array($FldVal2)) $FldVal2 = implode(",", $FldVal2); $FldOpr = strtoupper(trim($FldOpr)); if ($FldOpr == "") $FldOpr = "="; $FldOpr2 = strtoupper(trim($FldOpr2)); if ($FldOpr2 == "") $FldOpr2 = "="; if (EW_SEARCH_MULTI_VALUE_OPTION == 1 || $FldOpr <> "LIKE" || ($FldOpr2 <> "LIKE" && $FldVal2 <> "")) $MultiValue = FALSE; if ($MultiValue) { $sWrk1 = ($FldVal <> "") ? ew_GetMultiSearchSql($Fld, $FldVal) : ""; // Field value 1 $sWrk2 = ($FldVal2 <> "") ? ew_GetMultiSearchSql($Fld, $FldVal2) : ""; // Field value 2 $sWrk = $sWrk1; // Build final SQL if ($sWrk2 <> "") $sWrk = ($sWrk <> "") ? "($sWrk) $FldCond ($sWrk2)" : $sWrk2; } else { $FldVal = $this->ConvertSearchValue($Fld, $FldVal); $FldVal2 = $this->ConvertSearchValue($Fld, $FldVal2); $sWrk = ew_GetSearchSql($Fld, $FldVal, $FldOpr, $FldCond, $FldVal2, $FldOpr2); } if ($sWrk <> "") { if ($Where <> "") $Where .= " AND "; $Where .= "(" . $sWrk . ")"; } } // Set search parameters function SetSearchParm(&$Fld) { global $CPDTrainingMaterial; $FldParm = substr($Fld->FldVar, 2); $FldVal = $Fld->AdvancedSearch->SearchValue; // @$_GET["x_$FldParm"] $FldVal = ew_StripSlashes($FldVal); if (is_array($FldVal)) $FldVal = implode(",", $FldVal); $FldVal2 = $Fld->AdvancedSearch->SearchValue2; // @$_GET["y_$FldParm"] $FldVal2 = ew_StripSlashes($FldVal2); if (is_array($FldVal2)) $FldVal2 = implode(",", $FldVal2); $CPDTrainingMaterial->setAdvancedSearch("x_$FldParm", $FldVal); $CPDTrainingMaterial->setAdvancedSearch("z_$FldParm", $Fld->AdvancedSearch->SearchOperator); // @$_GET["z_$FldParm"] $CPDTrainingMaterial->setAdvancedSearch("v_$FldParm", $Fld->AdvancedSearch->SearchCondition); // @$_GET["v_$FldParm"] $CPDTrainingMaterial->setAdvancedSearch("y_$FldParm", $FldVal2); $CPDTrainingMaterial->setAdvancedSearch("w_$FldParm", $Fld->AdvancedSearch->SearchOperator2); // @$_GET["w_$FldParm"] } // Get search parameters function GetSearchParm(&$Fld) { global $CPDTrainingMaterial; $FldParm = substr($Fld->FldVar, 2); $Fld->AdvancedSearch->SearchValue = $CPDTrainingMaterial->GetAdvancedSearch("x_$FldParm"); $Fld->AdvancedSearch->SearchOperator = $CPDTrainingMaterial->GetAdvancedSearch("z_$FldParm"); $Fld->AdvancedSearch->SearchCondition = $CPDTrainingMaterial->GetAdvancedSearch("v_$FldParm"); $Fld->AdvancedSearch->SearchValue2 = $CPDTrainingMaterial->GetAdvancedSearch("y_$FldParm"); $Fld->AdvancedSearch->SearchOperator2 = $CPDTrainingMaterial->GetAdvancedSearch("w_$FldParm"); } // Convert search value function ConvertSearchValue(&$Fld, $FldVal) { $Value = $FldVal; if ($Fld->FldDataType == EW_DATATYPE_BOOLEAN) { if ($FldVal <> "") $Value = ($FldVal == "1") ? $Fld->TrueValue : $Fld->FalseValue; } elseif ($Fld->FldDataType == EW_DATATYPE_DATE) { if ($FldVal <> "") $Value = ew_UnFormatDateTime($FldVal, $Fld->FldDateTimeFormat); } return $Value; } // Return basic search SQL function BasicSearchSQL($Keyword) { global $CPDTrainingMaterial; $sKeyword = ew_AdjustSql($Keyword); $sWhere = ""; $this->BuildBasicSearchSQL($sWhere, $CPDTrainingMaterial->Subject, $Keyword); $this->BuildBasicSearchSQL($sWhere, $CPDTrainingMaterial->RenewOrNew, $Keyword); $this->BuildBasicSearchSQL($sWhere, $CPDTrainingMaterial->Status, $Keyword); $this->BuildBasicSearchSQL($sWhere, $CPDTrainingMaterial->DurationUnit, $Keyword); $this->BuildBasicSearchSQL($sWhere, $CPDTrainingMaterial->Level, $Keyword); $this->BuildBasicSearchSQL($sWhere, $CPDTrainingMaterial->EventDescription, $Keyword); $this->BuildBasicSearchSQL($sWhere, $CPDTrainingMaterial->LearningOutcomes, $Keyword); $this->BuildBasicSearchSQL($sWhere, $CPDTrainingMaterial->ModeOfDelivery, $Keyword); $this->BuildBasicSearchSQL($sWhere, $CPDTrainingMaterial->TargetAudience, $Keyword); $this->BuildBasicSearchSQL($sWhere, $CPDTrainingMaterial->Objectives, $Keyword); $this->BuildBasicSearchSQL($sWhere, $CPDTrainingMaterial->Promotion, $Keyword); $this->BuildBasicSearchSQL($sWhere, $CPDTrainingMaterial->Motivation, $Keyword); $this->BuildBasicSearchSQL($sWhere, $CPDTrainingMaterial->AccredNum, $Keyword); $this->BuildBasicSearchSQL($sWhere, $CPDTrainingMaterial->PrevAccredNum, $Keyword); $this->BuildBasicSearchSQL($sWhere, $CPDTrainingMaterial->CPD, $Keyword); $this->BuildBasicSearchSQL($sWhere, $CPDTrainingMaterial->InvoiceCode, $Keyword); $this->BuildBasicSearchSQL($sWhere, $CPDTrainingMaterial->InvoiceNumber, $Keyword); $this->BuildBasicSearchSQL($sWhere, $CPDTrainingMaterial->InvoiceFile, $Keyword); $this->BuildBasicSearchSQL($sWhere, $CPDTrainingMaterial->ProofOfPayment, $Keyword); $this->BuildBasicSearchSQL($sWhere, $CPDTrainingMaterial->EvaluatorInvoice, $Keyword); $this->BuildBasicSearchSQL($sWhere, $CPDTrainingMaterial->EvaluatorTimesheet, $Keyword); $this->BuildBasicSearchSQL($sWhere, $CPDTrainingMaterial->Comments, $Keyword); $this->BuildBasicSearchSQL($sWhere, $CPDTrainingMaterial->Presenter1Title, $Keyword); $this->BuildBasicSearchSQL($sWhere, $CPDTrainingMaterial->Presenter1FirstName, $Keyword); $this->BuildBasicSearchSQL($sWhere, $CPDTrainingMaterial->Presenter1Surname, $Keyword); $this->BuildBasicSearchSQL($sWhere, $CPDTrainingMaterial->Presenter1Phone, $Keyword); $this->BuildBasicSearchSQL($sWhere, $CPDTrainingMaterial->Presenter1Email, $Keyword); $this->BuildBasicSearchSQL($sWhere, $CPDTrainingMaterial->Presenter1ID, $Keyword); $this->BuildBasicSearchSQL($sWhere, $CPDTrainingMaterial->Presenter1CV, $Keyword); $this->BuildBasicSearchSQL($sWhere, $CPDTrainingMaterial->Presenter1SLA, $Keyword); $this->BuildBasicSearchSQL($sWhere, $CPDTrainingMaterial->Presenter1IDDoc, $Keyword); $this->BuildBasicSearchSQL($sWhere, $CPDTrainingMaterial->Presenter2Title, $Keyword); $this->BuildBasicSearchSQL($sWhere, $CPDTrainingMaterial->Presenter2FirstName, $Keyword); $this->BuildBasicSearchSQL($sWhere, $CPDTrainingMaterial->Presenter2Surname, $Keyword); $this->BuildBasicSearchSQL($sWhere, $CPDTrainingMaterial->Presenter2Phone, $Keyword); $this->BuildBasicSearchSQL($sWhere, $CPDTrainingMaterial->Presenter2Email, $Keyword); $this->BuildBasicSearchSQL($sWhere, $CPDTrainingMaterial->Presenter2ID, $Keyword); $this->BuildBasicSearchSQL($sWhere, $CPDTrainingMaterial->Presenter2CV, $Keyword); $this->BuildBasicSearchSQL($sWhere, $CPDTrainingMaterial->Presenter2SLA, $Keyword); $this->BuildBasicSearchSQL($sWhere, $CPDTrainingMaterial->Presenter2IDDoc, $Keyword); $this->BuildBasicSearchSQL($sWhere, $CPDTrainingMaterial->Presenter3Title, $Keyword); $this->BuildBasicSearchSQL($sWhere, $CPDTrainingMaterial->Presenter3FirstName, $Keyword); $this->BuildBasicSearchSQL($sWhere, $CPDTrainingMaterial->Presenter3Surname, $Keyword); $this->BuildBasicSearchSQL($sWhere, $CPDTrainingMaterial->Presenter3Phone, $Keyword); $this->BuildBasicSearchSQL($sWhere, $CPDTrainingMaterial->Presenter3Email, $Keyword); $this->BuildBasicSearchSQL($sWhere, $CPDTrainingMaterial->Presenter3ID, $Keyword); $this->BuildBasicSearchSQL($sWhere, $CPDTrainingMaterial->Presenter3CV, $Keyword); $this->BuildBasicSearchSQL($sWhere, $CPDTrainingMaterial->Presenter3SLA, $Keyword); $this->BuildBasicSearchSQL($sWhere, $CPDTrainingMaterial->Presenter3IDDoc, $Keyword); return $sWhere; } // Build basic search SQL function BuildBasicSearchSql(&$Where, &$Fld, $Keyword) { $sFldExpression = ($Fld->FldVirtualExpression <> "") ? $Fld->FldVirtualExpression : $Fld->FldExpression; $lFldDataType = ($Fld->FldIsVirtual) ? EW_DATATYPE_STRING : $Fld->FldDataType; if ($lFldDataType == EW_DATATYPE_NUMBER) { $sWrk = $sFldExpression . " = " . ew_QuotedValue($Keyword, $lFldDataType); } else { $sWrk = $sFldExpression . " LIKE " . ew_QuotedValue("%" . $Keyword . "%", $lFldDataType); } if ($Where <> "") $Where .= " OR "; $Where .= $sWrk; } // Return basic search WHERE clause based on search keyword and type function BasicSearchWhere() { global $Security, $CPDTrainingMaterial; $sSearchStr = ""; $sSearchKeyword = $CPDTrainingMaterial->BasicSearchKeyword; $sSearchType = $CPDTrainingMaterial->BasicSearchType; if ($sSearchKeyword <> "") { $sSearch = trim($sSearchKeyword); if ($sSearchType <> "") { while (strpos($sSearch, " ") !== FALSE) $sSearch = str_replace(" ", " ", $sSearch); $arKeyword = explode(" ", trim($sSearch)); foreach ($arKeyword as $sKeyword) { if ($sSearchStr <> "") $sSearchStr .= " " . $sSearchType . " "; $sSearchStr .= "(" . $this->BasicSearchSQL($sKeyword) . ")"; } } else { $sSearchStr = $this->BasicSearchSQL($sSearch); } } if ($sSearchKeyword <> "") { $CPDTrainingMaterial->setSessionBasicSearchKeyword($sSearchKeyword); $CPDTrainingMaterial->setSessionBasicSearchType($sSearchType); } return $sSearchStr; } // Clear all search parameters function ResetSearchParms() { global $CPDTrainingMaterial; // Clear search WHERE clause $this->sSrchWhere = ""; $CPDTrainingMaterial->setSearchWhere($this->sSrchWhere); // Clear basic search parameters $this->ResetBasicSearchParms(); // Clear advanced search parameters $this->ResetAdvancedSearchParms(); } // Clear all basic search parameters function ResetBasicSearchParms() { global $CPDTrainingMaterial; $CPDTrainingMaterial->setSessionBasicSearchKeyword(""); $CPDTrainingMaterial->setSessionBasicSearchType(""); } // Clear all advanced search parameters function ResetAdvancedSearchParms() { global $CPDTrainingMaterial; $CPDTrainingMaterial->setAdvancedSearch("x_MaterialID", ""); $CPDTrainingMaterial->setAdvancedSearch("x_ProviderID", ""); $CPDTrainingMaterial->setAdvancedSearch("x_Subject", ""); $CPDTrainingMaterial->setAdvancedSearch("x_RenewOrNew", ""); $CPDTrainingMaterial->setAdvancedSearch("x_Status", ""); $CPDTrainingMaterial->setAdvancedSearch("x_Duration", ""); $CPDTrainingMaterial->setAdvancedSearch("x_DurationUnit", ""); $CPDTrainingMaterial->setAdvancedSearch("x_Level", ""); $CPDTrainingMaterial->setAdvancedSearch("x_EventDescription", ""); $CPDTrainingMaterial->setAdvancedSearch("x_TrainingManualLink", ""); $CPDTrainingMaterial->setAdvancedSearch("x_PresentationLink", ""); $CPDTrainingMaterial->setAdvancedSearch("x_HandOutsLink", ""); $CPDTrainingMaterial->setAdvancedSearch("x_LearningOutcomes", ""); $CPDTrainingMaterial->setAdvancedSearch("x_ModeOfDelivery", ""); $CPDTrainingMaterial->setAdvancedSearch("x_TargetAudience", ""); $CPDTrainingMaterial->setAdvancedSearch("x_Objectives", ""); $CPDTrainingMaterial->setAdvancedSearch("x_Promotion", ""); $CPDTrainingMaterial->setAdvancedSearch("x_Motivation", ""); $CPDTrainingMaterial->setAdvancedSearch("x_AccredNum", ""); $CPDTrainingMaterial->setAdvancedSearch("x_PrevAccredNum", ""); $CPDTrainingMaterial->setAdvancedSearch("x_DateApproved", ""); $CPDTrainingMaterial->setAdvancedSearch("y_DateApproved", ""); $CPDTrainingMaterial->setAdvancedSearch("x_DateExpires", ""); $CPDTrainingMaterial->setAdvancedSearch("x_Certification", ""); $CPDTrainingMaterial->setAdvancedSearch("x_CPD", ""); $CPDTrainingMaterial->setAdvancedSearch("x_InvoiceCode", ""); $CPDTrainingMaterial->setAdvancedSearch("x_InvoiceNumber", ""); $CPDTrainingMaterial->setAdvancedSearch("x_Cost", ""); $CPDTrainingMaterial->setAdvancedSearch("x_CostToDelegate", ""); $CPDTrainingMaterial->setAdvancedSearch("x_DepositAmt", ""); $CPDTrainingMaterial->setAdvancedSearch("x_InvoiceDate", ""); $CPDTrainingMaterial->setAdvancedSearch("x_DatePaid", ""); $CPDTrainingMaterial->setAdvancedSearch("x_EvaluatorID", ""); $CPDTrainingMaterial->setAdvancedSearch("x_EvaluatorID2", ""); $CPDTrainingMaterial->setAdvancedSearch("x_EvaluatorID3", ""); $CPDTrainingMaterial->setAdvancedSearch("x_EvaluatorFee", ""); $CPDTrainingMaterial->setAdvancedSearch("x_EvaluatorFeeAmount", ""); $CPDTrainingMaterial->setAdvancedSearch("x_EvaluatorFeeDate", ""); $CPDTrainingMaterial->setAdvancedSearch("x_StartDate", ""); $CPDTrainingMaterial->setAdvancedSearch("x_Other_Validator", ""); $CPDTrainingMaterial->setAdvancedSearch("x_Provider_URL", ""); $CPDTrainingMaterial->setAdvancedSearch("x_Category_Reg", ""); $CPDTrainingMaterial->setAdvancedSearch("x_Discipline", ""); $CPDTrainingMaterial->setAdvancedSearch("x_Sub_Discipline", ""); $CPDTrainingMaterial->setAdvancedSearch("x_Activity_Nature", ""); $CPDTrainingMaterial->setAdvancedSearch("x_Instances", ""); $CPDTrainingMaterial->setAdvancedSearch("x_LocalUpload", ""); $CPDTrainingMaterial->setAdvancedSearch("x_ResponsiblePersonFirstName", ""); $CPDTrainingMaterial->setAdvancedSearch("x_ResponsiblePersonLastName", ""); $CPDTrainingMaterial->setAdvancedSearch("x_ResponsiblePersonEMailAddress", ""); $CPDTrainingMaterial->setAdvancedSearch("x_ResponsibleBillingAddress", ""); $CPDTrainingMaterial->setAdvancedSearch("x_ResponsiblePersonContactNumber", ""); $CPDTrainingMaterial->setAdvancedSearch("x_ResponsibleVATNumber", ""); $CPDTrainingMaterial->setAdvancedSearch("x_Comments", ""); $CPDTrainingMaterial->setAdvancedSearch("x_Archived", ""); $CPDTrainingMaterial->setAdvancedSearch("x_Presenter1Title", ""); $CPDTrainingMaterial->setAdvancedSearch("x_Presenter1FirstName", ""); $CPDTrainingMaterial->setAdvancedSearch("x_Presenter1Surname", ""); $CPDTrainingMaterial->setAdvancedSearch("x_Presenter1Phone", ""); $CPDTrainingMaterial->setAdvancedSearch("x_Presenter1Email", ""); $CPDTrainingMaterial->setAdvancedSearch("x_Presenter1ID", ""); $CPDTrainingMaterial->setAdvancedSearch("x_Presenter2Title", ""); $CPDTrainingMaterial->setAdvancedSearch("x_Presenter2FirstName", ""); $CPDTrainingMaterial->setAdvancedSearch("x_Presenter2Surname", ""); $CPDTrainingMaterial->setAdvancedSearch("x_Presenter2Phone", ""); $CPDTrainingMaterial->setAdvancedSearch("x_Presenter2Email", ""); $CPDTrainingMaterial->setAdvancedSearch("x_Presenter2ID", ""); $CPDTrainingMaterial->setAdvancedSearch("x_Presenter3Title", ""); $CPDTrainingMaterial->setAdvancedSearch("x_Presenter3FirstName", ""); $CPDTrainingMaterial->setAdvancedSearch("x_Presenter3Surname", ""); $CPDTrainingMaterial->setAdvancedSearch("x_Presenter3Phone", ""); $CPDTrainingMaterial->setAdvancedSearch("x_Presenter3Email", ""); $CPDTrainingMaterial->setAdvancedSearch("x_Presenter3ID", ""); $CPDTrainingMaterial->setAdvancedSearch("x_DateCreated", ""); } // Restore all search parameters function RestoreSearchParms() { global $CPDTrainingMaterial; $bRestore = TRUE; if (@$_GET[EW_TABLE_BASIC_SEARCH] <> "") $bRestore = FALSE; if (@$_GET["x_MaterialID"] <> "") $bRestore = FALSE; if (@$_GET["x_ProviderID"] <> "") $bRestore = FALSE; if (@$_GET["x_Subject"] <> "") $bRestore = FALSE; if (@$_GET["x_RenewOrNew"] <> "") $bRestore = FALSE; if (@$_GET["x_Status"] <> "") $bRestore = FALSE; if (@$_GET["x_Duration"] <> "") $bRestore = FALSE; if (@$_GET["x_DurationUnit"] <> "") $bRestore = FALSE; if (@$_GET["x_Level"] <> "") $bRestore = FALSE; if (@$_GET["x_EventDescription"] <> "") $bRestore = FALSE; if (@$_GET["x_TrainingManualLink"] <> "") $bRestore = FALSE; if (@$_GET["x_PresentationLink"] <> "") $bRestore = FALSE; if (@$_GET["x_HandOutsLink"] <> "") $bRestore = FALSE; if (@$_GET["x_LearningOutcomes"] <> "") $bRestore = FALSE; if (@$_GET["x_ModeOfDelivery"] <> "") $bRestore = FALSE; if (@$_GET["x_TargetAudience"] <> "") $bRestore = FALSE; if (@$_GET["x_Objectives"] <> "") $bRestore = FALSE; if (@$_GET["x_Promotion"] <> "") $bRestore = FALSE; if (@$_GET["x_Motivation"] <> "") $bRestore = FALSE; if (@$_GET["x_AccredNum"] <> "") $bRestore = FALSE; if (@$_GET["x_PrevAccredNum"] <> "") $bRestore = FALSE; if (@$_GET["x_DateApproved"] <> "") $bRestore = FALSE; if (@$_GET["y_DateApproved"] <> "") $bRestore = FALSE; if (@$_GET["x_DateExpires"] <> "") $bRestore = FALSE; if (@$_GET["x_Certification"] <> "") $bRestore = FALSE; if (@$_GET["x_CPD"] <> "") $bRestore = FALSE; if (@$_GET["x_InvoiceCode"] <> "") $bRestore = FALSE; if (@$_GET["x_InvoiceNumber"] <> "") $bRestore = FALSE; if (@$_GET["x_Cost"] <> "") $bRestore = FALSE; if (@$_GET["x_CostToDelegate"] <> "") $bRestore = FALSE; if (@$_GET["x_DepositAmt"] <> "") $bRestore = FALSE; if (@$_GET["x_InvoiceDate"] <> "") $bRestore = FALSE; if (@$_GET["x_DatePaid"] <> "") $bRestore = FALSE; if (@$_GET["x_EvaluatorID"] <> "") $bRestore = FALSE; if (@$_GET["x_EvaluatorID2"] <> "") $bRestore = FALSE; if (@$_GET["x_EvaluatorID3"] <> "") $bRestore = FALSE; if (@$_GET["x_EvaluatorFee"] <> "") $bRestore = FALSE; if (@$_GET["x_EvaluatorFeeAmount"] <> "") $bRestore = FALSE; if (@$_GET["x_EvaluatorFeeDate"] <> "") $bRestore = FALSE; if (@$_GET["x_StartDate"] <> "") $bRestore = FALSE; if (@$_GET["x_Other_Validator"] <> "") $bRestore = FALSE; if (@$_GET["x_Provider_URL"] <> "") $bRestore = FALSE; if (@$_GET["x_Category_Reg"] <> "") $bRestore = FALSE; if (@$_GET["x_Discipline"] <> "") $bRestore = FALSE; if (@$_GET["x_Sub_Discipline"] <> "") $bRestore = FALSE; if (@$_GET["x_Activity_Nature"] <> "") $bRestore = FALSE; if (@$_GET["x_Instances"] <> "") $bRestore = FALSE; if (@$_GET["x_LocalUpload"] <> "") $bRestore = FALSE; if (@$_GET["x_ResponsiblePersonFirstName"] <> "") $bRestore = FALSE; if (@$_GET["x_ResponsiblePersonLastName"] <> "") $bRestore = FALSE; if (@$_GET["x_ResponsiblePersonEMailAddress"] <> "") $bRestore = FALSE; if (@$_GET["x_ResponsibleBillingAddress"] <> "") $bRestore = FALSE; if (@$_GET["x_ResponsiblePersonContactNumber"] <> "") $bRestore = FALSE; if (@$_GET["x_ResponsibleVATNumber"] <> "") $bRestore = FALSE; if (@$_GET["x_Comments"] <> "") $bRestore = FALSE; if (@$_GET["x_Archived"] <> "") $bRestore = FALSE; if (@$_GET["x_Presenter1Title"] <> "") $bRestore = FALSE; if (@$_GET["x_Presenter1FirstName"] <> "") $bRestore = FALSE; if (@$_GET["x_Presenter1Surname"] <> "") $bRestore = FALSE; if (@$_GET["x_Presenter1Phone"] <> "") $bRestore = FALSE; if (@$_GET["x_Presenter1Email"] <> "") $bRestore = FALSE; if (@$_GET["x_Presenter1ID"] <> "") $bRestore = FALSE; if (@$_GET["x_Presenter2Title"] <> "") $bRestore = FALSE; if (@$_GET["x_Presenter2FirstName"] <> "") $bRestore = FALSE; if (@$_GET["x_Presenter2Surname"] <> "") $bRestore = FALSE; if (@$_GET["x_Presenter2Phone"] <> "") $bRestore = FALSE; if (@$_GET["x_Presenter2Email"] <> "") $bRestore = FALSE; if (@$_GET["x_Presenter2ID"] <> "") $bRestore = FALSE; if (@$_GET["x_Presenter3Title"] <> "") $bRestore = FALSE; if (@$_GET["x_Presenter3FirstName"] <> "") $bRestore = FALSE; if (@$_GET["x_Presenter3Surname"] <> "") $bRestore = FALSE; if (@$_GET["x_Presenter3Phone"] <> "") $bRestore = FALSE; if (@$_GET["x_Presenter3Email"] <> "") $bRestore = FALSE; if (@$_GET["x_Presenter3ID"] <> "") $bRestore = FALSE; if (@$_GET["x_DateCreated"] <> "") $bRestore = FALSE; $this->RestoreSearch = $bRestore; if ($bRestore) { // Restore basic search values $CPDTrainingMaterial->BasicSearchKeyword = $CPDTrainingMaterial->getSessionBasicSearchKeyword(); $CPDTrainingMaterial->BasicSearchType = $CPDTrainingMaterial->getSessionBasicSearchType(); // Restore advanced search values $this->GetSearchParm($CPDTrainingMaterial->MaterialID); $this->GetSearchParm($CPDTrainingMaterial->ProviderID); $this->GetSearchParm($CPDTrainingMaterial->Subject); $this->GetSearchParm($CPDTrainingMaterial->RenewOrNew); $this->GetSearchParm($CPDTrainingMaterial->Status); $this->GetSearchParm($CPDTrainingMaterial->Duration); $this->GetSearchParm($CPDTrainingMaterial->DurationUnit); $this->GetSearchParm($CPDTrainingMaterial->Level); $this->GetSearchParm($CPDTrainingMaterial->EventDescription); $this->GetSearchParm($CPDTrainingMaterial->TrainingManualLink); $this->GetSearchParm($CPDTrainingMaterial->PresentationLink); $this->GetSearchParm($CPDTrainingMaterial->HandOutsLink); $this->GetSearchParm($CPDTrainingMaterial->LearningOutcomes); $this->GetSearchParm($CPDTrainingMaterial->ModeOfDelivery); $this->GetSearchParm($CPDTrainingMaterial->TargetAudience); $this->GetSearchParm($CPDTrainingMaterial->Objectives); $this->GetSearchParm($CPDTrainingMaterial->Promotion); $this->GetSearchParm($CPDTrainingMaterial->Motivation); $this->GetSearchParm($CPDTrainingMaterial->AccredNum); $this->GetSearchParm($CPDTrainingMaterial->PrevAccredNum); $this->GetSearchParm($CPDTrainingMaterial->DateApproved); $this->GetSearchParm($CPDTrainingMaterial->DateExpires); $this->GetSearchParm($CPDTrainingMaterial->Certification); $this->GetSearchParm($CPDTrainingMaterial->CPD); $this->GetSearchParm($CPDTrainingMaterial->InvoiceCode); $this->GetSearchParm($CPDTrainingMaterial->InvoiceNumber); $this->GetSearchParm($CPDTrainingMaterial->Cost); $this->GetSearchParm($CPDTrainingMaterial->CostToDelegate); $this->GetSearchParm($CPDTrainingMaterial->DepositAmt); $this->GetSearchParm($CPDTrainingMaterial->InvoiceDate); $this->GetSearchParm($CPDTrainingMaterial->DatePaid); $this->GetSearchParm($CPDTrainingMaterial->EvaluatorID); $this->GetSearchParm($CPDTrainingMaterial->EvaluatorID2); $this->GetSearchParm($CPDTrainingMaterial->EvaluatorID3); $this->GetSearchParm($CPDTrainingMaterial->EvaluatorFee); $this->GetSearchParm($CPDTrainingMaterial->EvaluatorFeeAmount); $this->GetSearchParm($CPDTrainingMaterial->EvaluatorFeeDate); $this->GetSearchParm($CPDTrainingMaterial->StartDate); $this->GetSearchParm($CPDTrainingMaterial->Other_Validator); $this->GetSearchParm($CPDTrainingMaterial->Provider_URL); $this->GetSearchParm($CPDTrainingMaterial->Category_Reg); $this->GetSearchParm($CPDTrainingMaterial->Discipline); $this->GetSearchParm($CPDTrainingMaterial->Sub_Discipline); $this->GetSearchParm($CPDTrainingMaterial->Activity_Nature); $this->GetSearchParm($CPDTrainingMaterial->Instances); $this->GetSearchParm($CPDTrainingMaterial->LocalUpload); $this->GetSearchParm($CPDTrainingMaterial->ResponsiblePersonFirstName); $this->GetSearchParm($CPDTrainingMaterial->ResponsiblePersonLastName); $this->GetSearchParm($CPDTrainingMaterial->ResponsiblePersonEMailAddress); $this->GetSearchParm($CPDTrainingMaterial->ResponsibleBillingAddress); $this->GetSearchParm($CPDTrainingMaterial->ResponsiblePersonContactNumber); $this->GetSearchParm($CPDTrainingMaterial->ResponsibleVATNumber); $this->GetSearchParm($CPDTrainingMaterial->Comments); $this->GetSearchParm($CPDTrainingMaterial->Archived); $this->GetSearchParm($CPDTrainingMaterial->Presenter1Title); $this->GetSearchParm($CPDTrainingMaterial->Presenter1FirstName); $this->GetSearchParm($CPDTrainingMaterial->Presenter1Surname); $this->GetSearchParm($CPDTrainingMaterial->Presenter1Phone); $this->GetSearchParm($CPDTrainingMaterial->Presenter1Email); $this->GetSearchParm($CPDTrainingMaterial->Presenter1ID); $this->GetSearchParm($CPDTrainingMaterial->Presenter2Title); $this->GetSearchParm($CPDTrainingMaterial->Presenter2FirstName); $this->GetSearchParm($CPDTrainingMaterial->Presenter2Surname); $this->GetSearchParm($CPDTrainingMaterial->Presenter2Phone); $this->GetSearchParm($CPDTrainingMaterial->Presenter2Email); $this->GetSearchParm($CPDTrainingMaterial->Presenter2ID); $this->GetSearchParm($CPDTrainingMaterial->Presenter3Title); $this->GetSearchParm($CPDTrainingMaterial->Presenter3FirstName); $this->GetSearchParm($CPDTrainingMaterial->Presenter3Surname); $this->GetSearchParm($CPDTrainingMaterial->Presenter3Phone); $this->GetSearchParm($CPDTrainingMaterial->Presenter3Email); $this->GetSearchParm($CPDTrainingMaterial->Presenter3ID); $this->GetSearchParm($CPDTrainingMaterial->DateCreated); } } // Set up sort parameters function SetUpSortOrder() { global $CPDTrainingMaterial; // Check for Ctrl pressed $bCtrl = (@$_GET["ctrl"] <> ""); // Check for "order" parameter if (@$_GET["order"] <> "") { $CPDTrainingMaterial->CurrentOrder = ew_StripSlashes(@$_GET["order"]); $CPDTrainingMaterial->CurrentOrderType = @$_GET["ordertype"]; $CPDTrainingMaterial->UpdateSort($CPDTrainingMaterial->ProviderID, $bCtrl); // ProviderID $CPDTrainingMaterial->UpdateSort($CPDTrainingMaterial->Subject, $bCtrl); // Subject $CPDTrainingMaterial->UpdateSort($CPDTrainingMaterial->RenewOrNew, $bCtrl); // RenewOrNew $CPDTrainingMaterial->UpdateSort($CPDTrainingMaterial->Status, $bCtrl); // Status $CPDTrainingMaterial->UpdateSort($CPDTrainingMaterial->AccredNum, $bCtrl); // AccredNum $CPDTrainingMaterial->UpdateSort($CPDTrainingMaterial->PrevAccredNum, $bCtrl); // PrevAccredNum $CPDTrainingMaterial->UpdateSort($CPDTrainingMaterial->DateApproved, $bCtrl); // DateApproved $CPDTrainingMaterial->UpdateSort($CPDTrainingMaterial->DatePaid, $bCtrl); // DatePaid $CPDTrainingMaterial->UpdateSort($CPDTrainingMaterial->DateCreated, $bCtrl); // DateCreated $CPDTrainingMaterial->setStartRecordNumber(1); // Reset start position } } // Load sort order parameters function LoadSortOrder() { global $CPDTrainingMaterial; $sOrderBy = $CPDTrainingMaterial->getSessionOrderBy(); // Get ORDER BY from Session if ($sOrderBy == "") { if ($CPDTrainingMaterial->SqlOrderBy() <> "") { $sOrderBy = $CPDTrainingMaterial->SqlOrderBy(); $CPDTrainingMaterial->setSessionOrderBy($sOrderBy); $CPDTrainingMaterial->Subject->setSort("ASC"); $CPDTrainingMaterial->AccredNum->setSort("ASC"); } } } // Reset command // cmd=reset (Reset search parameters) // cmd=resetall (Reset search and master/detail parameters) // cmd=resetsort (Reset sort parameters) function ResetCmd() { global $CPDTrainingMaterial; // Get reset command if (@$_GET["cmd"] <> "") { $sCmd = $_GET["cmd"]; // Reset search criteria if (strtolower($sCmd) == "reset" || strtolower($sCmd) == "resetall") $this->ResetSearchParms(); // Reset master/detail keys if (strtolower($sCmd) == "resetall") { $CPDTrainingMaterial->getCurrentMasterTable = ""; // Clear master table $CPDTrainingMaterial->setMasterFilter(""); // Clear master filter $this->sDbMasterFilter = ""; $CPDTrainingMaterial->setDetailFilter(""); // Clear detail filter $this->sDbDetailFilter = ""; $CPDTrainingMaterial->ProviderID->setSessionValue(""); } // Reset sorting order if (strtolower($sCmd) == "resetsort") { $sOrderBy = ""; $CPDTrainingMaterial->setSessionOrderBy($sOrderBy); $CPDTrainingMaterial->ProviderID->setSort(""); $CPDTrainingMaterial->Subject->setSort(""); $CPDTrainingMaterial->RenewOrNew->setSort(""); $CPDTrainingMaterial->Status->setSort(""); $CPDTrainingMaterial->AccredNum->setSort(""); $CPDTrainingMaterial->PrevAccredNum->setSort(""); $CPDTrainingMaterial->DateApproved->setSort(""); $CPDTrainingMaterial->DatePaid->setSort(""); $CPDTrainingMaterial->DateCreated->setSort(""); } // Reset start position $this->lStartRec = 1; $CPDTrainingMaterial->setStartRecordNumber($this->lStartRec); } } // Set up list options function SetupListOptions() { global $Security, $CPDTrainingMaterial; // "view" $this->ListOptions->Add("view"); $item =& $this->ListOptions->Items["view"]; $item->CssStyle = "white-space: nowrap;"; $item->Visible = $Security->IsLoggedIn(); $item->OnLeft = FALSE; // "edit" $this->ListOptions->Add("edit"); $item =& $this->ListOptions->Items["edit"]; $item->CssStyle = "white-space: nowrap;"; $item->Visible = $Security->IsLoggedIn(); $item->OnLeft = FALSE; // "copy" $this->ListOptions->Add("copy"); $item =& $this->ListOptions->Items["copy"]; $item->CssStyle = "white-space: nowrap;"; $item->Visible = $Security->IsLoggedIn(); $item->OnLeft = FALSE; // "delete" $this->ListOptions->Add("delete"); $item =& $this->ListOptions->Items["delete"]; $item->CssStyle = "white-space: nowrap;"; $item->Visible = $Security->IsLoggedIn(); $item->OnLeft = FALSE; // "detail_CPDStepsTakenTM" $this->ListOptions->Add("detail_CPDStepsTakenTM"); $item =& $this->ListOptions->Items["detail_CPDStepsTakenTM"]; $item->CssStyle = "white-space: nowrap;"; $item->Visible = $Security->IsLoggedIn(); $item->OnLeft = FALSE; // "detail_CPDTMReview" $this->ListOptions->Add("detail_CPDTMReview"); $item =& $this->ListOptions->Items["detail_CPDTMReview"]; $item->CssStyle = "white-space: nowrap;"; $item->Visible = $Security->IsLoggedIn(); $item->OnLeft = FALSE; // Call ListOptions_Load event $this->ListOptions_Load(); if ($CPDTrainingMaterial->Export <> "" || $CPDTrainingMaterial->CurrentAction == "gridadd" || $CPDTrainingMaterial->CurrentAction == "gridedit") $this->ListOptions->HideAllOptions(); } // Render list options function RenderListOptions() { global $Security, $Language, $CPDTrainingMaterial; $this->ListOptions->LoadDefault(); // "view" $oListOpt =& $this->ListOptions->Items["view"]; if ($Security->IsLoggedIn() && $oListOpt->Visible) $oListOpt->Body = "<a href=\"" . $this->ViewUrl . "\">" . "<img src=\"images/view.gif\" alt=\"" . ew_HtmlEncode($Language->Phrase("ViewLink")) . "\" title=\"" . ew_HtmlEncode($Language->Phrase("ViewLink")) . "\" width=\"16\" height=\"16\" border=\"0\">" . "</a>"; // "edit" $oListOpt =& $this->ListOptions->Items["edit"]; if ($Security->IsLoggedIn() && $oListOpt->Visible) { $oListOpt->Body = "<a href=\"" . $this->EditUrl . "\">" . "<img src=\"images/edit.gif\" alt=\"" . ew_HtmlEncode($Language->Phrase("EditLink")) . "\" title=\"" . ew_HtmlEncode($Language->Phrase("EditLink")) . "\" width=\"16\" height=\"16\" border=\"0\">" . "</a>"; } // "copy" $oListOpt =& $this->ListOptions->Items["copy"]; if ($Security->IsLoggedIn() && $oListOpt->Visible) { $oListOpt->Body = "<a href=\"" . $this->CopyUrl . "\">" . "<img src=\"images/copy.gif\" alt=\"" . ew_HtmlEncode($Language->Phrase("CopyLink")) . "\" title=\"" . ew_HtmlEncode($Language->Phrase("CopyLink")) . "\" width=\"16\" height=\"16\" border=\"0\">" . "</a>"; } // "delete" $oListOpt =& $this->ListOptions->Items["delete"]; if ($Security->IsLoggedIn() && $oListOpt->Visible) $oListOpt->Body = "<a" . "" . " href=\"" . $this->DeleteUrl . "\">" . "<img src=\"images/delete.gif\" alt=\"" . ew_HtmlEncode($Language->Phrase("DeleteLink")) . "\" title=\"" . ew_HtmlEncode($Language->Phrase("DeleteLink")) . "\" width=\"16\" height=\"16\" border=\"0\">" . "</a>"; // "detail_CPDStepsTakenTM" $oListOpt =& $this->ListOptions->Items["detail_CPDStepsTakenTM"]; if ($Security->IsLoggedIn()) { $oListOpt->Body = "<img src=\"images/detail.gif\" alt=\"" . ew_HtmlEncode($Language->Phrase("DetailLink")) . "\" title=\"" . ew_HtmlEncode($Language->Phrase("DetailLink")) . "\" width=\"16\" height=\"16\" border=\"0\">" . $Language->TablePhrase("CPDStepsTakenTM", "TblCaption"); $oListOpt->Body = "<a href=\"CPDStepsTakenTMlist.php?" . EW_TABLE_SHOW_MASTER . "=CPDTrainingMaterial&MaterialID=" . urlencode(strval($CPDTrainingMaterial->MaterialID->CurrentValue)) . "\">" . $oListOpt->Body . "</a>"; } // "detail_CPDTMReview" $oListOpt =& $this->ListOptions->Items["detail_CPDTMReview"]; if ($Security->IsLoggedIn()) { $oListOpt->Body = "<img src=\"images/detail.gif\" alt=\"" . ew_HtmlEncode($Language->Phrase("DetailLink")) . "\" title=\"" . ew_HtmlEncode($Language->Phrase("DetailLink")) . "\" width=\"16\" height=\"16\" border=\"0\">" . $Language->TablePhrase("CPDTMReview", "TblCaption"); $oListOpt->Body = "<a href=\"CPDTMReviewlist.php?" . EW_TABLE_SHOW_MASTER . "=CPDTrainingMaterial&MaterialID=" . urlencode(strval($CPDTrainingMaterial->MaterialID->CurrentValue)) . "\">" . $oListOpt->Body . "</a>"; } $this->RenderListOptionsExt(); // Call ListOptions_Rendered event $this->ListOptions_Rendered(); } function RenderListOptionsExt() { global $Security, $Language, $CPDTrainingMaterial; } // Set up starting record parameters function SetUpStartRec() { global $CPDTrainingMaterial; if ($this->lDisplayRecs == 0) return; if ($this->IsPageRequest()) { // Validate request if (@$_GET[EW_TABLE_START_REC] <> "") { // Check for "start" parameter $this->lStartRec = $_GET[EW_TABLE_START_REC]; $CPDTrainingMaterial->setStartRecordNumber($this->lStartRec); } elseif (@$_GET[EW_TABLE_PAGE_NO] <> "") { $this->nPageNo = $_GET[EW_TABLE_PAGE_NO]; if (is_numeric($this->nPageNo)) { $this->lStartRec = ($this->nPageNo-1)*$this->lDisplayRecs+1; if ($this->lStartRec <= 0) { $this->lStartRec = 1; } elseif ($this->lStartRec >= intval(($this->lTotalRecs-1)/$this->lDisplayRecs)*$this->lDisplayRecs+1) { $this->lStartRec = intval(($this->lTotalRecs-1)/$this->lDisplayRecs)*$this->lDisplayRecs+1; } $CPDTrainingMaterial->setStartRecordNumber($this->lStartRec); } } } $this->lStartRec = $CPDTrainingMaterial->getStartRecordNumber(); // Check if correct start record counter if (!is_numeric($this->lStartRec) || $this->lStartRec == "") { // Avoid invalid start record counter $this->lStartRec = 1; // Reset start record counter $CPDTrainingMaterial->setStartRecordNumber($this->lStartRec); } elseif (intval($this->lStartRec) > intval($this->lTotalRecs)) { // Avoid starting record > total records $this->lStartRec = intval(($this->lTotalRecs-1)/$this->lDisplayRecs)*$this->lDisplayRecs+1; // Point to last page first record $CPDTrainingMaterial->setStartRecordNumber($this->lStartRec); } elseif (($this->lStartRec-1) % $this->lDisplayRecs <> 0) { $this->lStartRec = intval(($this->lStartRec-1)/$this->lDisplayRecs)*$this->lDisplayRecs+1; // Point to page boundary $CPDTrainingMaterial->setStartRecordNumber($this->lStartRec); } } // Load basic search values function LoadBasicSearchValues() { global $CPDTrainingMaterial; $CPDTrainingMaterial->BasicSearchKeyword = @$_GET[EW_TABLE_BASIC_SEARCH]; $CPDTrainingMaterial->BasicSearchType = @$_GET[EW_TABLE_BASIC_SEARCH_TYPE]; } // Load search values for validation function LoadSearchValues() { global $objForm, $CPDTrainingMaterial; // Load search values // MaterialID $CPDTrainingMaterial->MaterialID->AdvancedSearch->SearchValue = ew_StripSlashes(@$_GET["x_MaterialID"]); $CPDTrainingMaterial->MaterialID->AdvancedSearch->SearchOperator = @$_GET["z_MaterialID"]; // ProviderID $CPDTrainingMaterial->ProviderID->AdvancedSearch->SearchValue = ew_StripSlashes(@$_GET["x_ProviderID"]); $CPDTrainingMaterial->ProviderID->AdvancedSearch->SearchOperator = @$_GET["z_ProviderID"]; // Subject $CPDTrainingMaterial->Subject->AdvancedSearch->SearchValue = ew_StripSlashes(@$_GET["x_Subject"]); $CPDTrainingMaterial->Subject->AdvancedSearch->SearchOperator = @$_GET["z_Subject"]; // RenewOrNew $CPDTrainingMaterial->RenewOrNew->AdvancedSearch->SearchValue = ew_StripSlashes(@$_GET["x_RenewOrNew"]); $CPDTrainingMaterial->RenewOrNew->AdvancedSearch->SearchOperator = @$_GET["z_RenewOrNew"]; // Status $CPDTrainingMaterial->Status->AdvancedSearch->SearchValue = ew_StripSlashes(@$_GET["x_Status"]); $CPDTrainingMaterial->Status->AdvancedSearch->SearchOperator = @$_GET["z_Status"]; // Duration $CPDTrainingMaterial->Duration->AdvancedSearch->SearchValue = ew_StripSlashes(@$_GET["x_Duration"]); $CPDTrainingMaterial->Duration->AdvancedSearch->SearchOperator = @$_GET["z_Duration"]; // DurationUnit $CPDTrainingMaterial->DurationUnit->AdvancedSearch->SearchValue = ew_StripSlashes(@$_GET["x_DurationUnit"]); $CPDTrainingMaterial->DurationUnit->AdvancedSearch->SearchOperator = @$_GET["z_DurationUnit"]; // Level $CPDTrainingMaterial->Level->AdvancedSearch->SearchValue = ew_StripSlashes(@$_GET["x_Level"]); $CPDTrainingMaterial->Level->AdvancedSearch->SearchOperator = @$_GET["z_Level"]; // EventDescription $CPDTrainingMaterial->EventDescription->AdvancedSearch->SearchValue = ew_StripSlashes(@$_GET["x_EventDescription"]); $CPDTrainingMaterial->EventDescription->AdvancedSearch->SearchOperator = @$_GET["z_EventDescription"]; // TrainingManualLink $CPDTrainingMaterial->TrainingManualLink->AdvancedSearch->SearchValue = ew_StripSlashes(@$_GET["x_TrainingManualLink"]); $CPDTrainingMaterial->TrainingManualLink->AdvancedSearch->SearchOperator = @$_GET["z_TrainingManualLink"]; // PresentationLink $CPDTrainingMaterial->PresentationLink->AdvancedSearch->SearchValue = ew_StripSlashes(@$_GET["x_PresentationLink"]); $CPDTrainingMaterial->PresentationLink->AdvancedSearch->SearchOperator = @$_GET["z_PresentationLink"]; // HandOutsLink $CPDTrainingMaterial->HandOutsLink->AdvancedSearch->SearchValue = ew_StripSlashes(@$_GET["x_HandOutsLink"]); $CPDTrainingMaterial->HandOutsLink->AdvancedSearch->SearchOperator = @$_GET["z_HandOutsLink"]; // LearningOutcomes $CPDTrainingMaterial->LearningOutcomes->AdvancedSearch->SearchValue = ew_StripSlashes(@$_GET["x_LearningOutcomes"]); $CPDTrainingMaterial->LearningOutcomes->AdvancedSearch->SearchOperator = @$_GET["z_LearningOutcomes"]; // ModeOfDelivery $CPDTrainingMaterial->ModeOfDelivery->AdvancedSearch->SearchValue = ew_StripSlashes(@$_GET["x_ModeOfDelivery"]); $CPDTrainingMaterial->ModeOfDelivery->AdvancedSearch->SearchOperator = @$_GET["z_ModeOfDelivery"]; // TargetAudience $CPDTrainingMaterial->TargetAudience->AdvancedSearch->SearchValue = ew_StripSlashes(@$_GET["x_TargetAudience"]); $CPDTrainingMaterial->TargetAudience->AdvancedSearch->SearchOperator = @$_GET["z_TargetAudience"]; // Objectives $CPDTrainingMaterial->Objectives->AdvancedSearch->SearchValue = ew_StripSlashes(@$_GET["x_Objectives"]); $CPDTrainingMaterial->Objectives->AdvancedSearch->SearchOperator = @$_GET["z_Objectives"]; // Promotion $CPDTrainingMaterial->Promotion->AdvancedSearch->SearchValue = ew_StripSlashes(@$_GET["x_Promotion"]); $CPDTrainingMaterial->Promotion->AdvancedSearch->SearchOperator = @$_GET["z_Promotion"]; // Motivation $CPDTrainingMaterial->Motivation->AdvancedSearch->SearchValue = ew_StripSlashes(@$_GET["x_Motivation"]); $CPDTrainingMaterial->Motivation->AdvancedSearch->SearchOperator = @$_GET["z_Motivation"]; // AccredNum $CPDTrainingMaterial->AccredNum->AdvancedSearch->SearchValue = ew_StripSlashes(@$_GET["x_AccredNum"]); $CPDTrainingMaterial->AccredNum->AdvancedSearch->SearchOperator = @$_GET["z_AccredNum"]; // PrevAccredNum $CPDTrainingMaterial->PrevAccredNum->AdvancedSearch->SearchValue = ew_StripSlashes(@$_GET["x_PrevAccredNum"]); $CPDTrainingMaterial->PrevAccredNum->AdvancedSearch->SearchOperator = @$_GET["z_PrevAccredNum"]; // DateApproved $CPDTrainingMaterial->DateApproved->AdvancedSearch->SearchValue = ew_StripSlashes(@$_GET["x_DateApproved"]); $CPDTrainingMaterial->DateApproved->AdvancedSearch->SearchOperator = @$_GET["z_DateApproved"]; $CPDTrainingMaterial->DateApproved->AdvancedSearch->SearchCondition = @$_GET["v_DateApproved"]; $CPDTrainingMaterial->DateApproved->AdvancedSearch->SearchValue2 = ew_StripSlashes(@$_GET["y_DateApproved"]); $CPDTrainingMaterial->DateApproved->AdvancedSearch->SearchOperator2 = @$_GET["w_DateApproved"]; // DateExpires $CPDTrainingMaterial->DateExpires->AdvancedSearch->SearchValue = ew_StripSlashes(@$_GET["x_DateExpires"]); $CPDTrainingMaterial->DateExpires->AdvancedSearch->SearchOperator = @$_GET["z_DateExpires"]; // Certification $CPDTrainingMaterial->Certification->AdvancedSearch->SearchValue = ew_StripSlashes(@$_GET["x_Certification"]); $CPDTrainingMaterial->Certification->AdvancedSearch->SearchOperator = @$_GET["z_Certification"]; // CPD $CPDTrainingMaterial->CPD->AdvancedSearch->SearchValue = ew_StripSlashes(@$_GET["x_CPD"]); $CPDTrainingMaterial->CPD->AdvancedSearch->SearchOperator = @$_GET["z_CPD"]; // InvoiceCode $CPDTrainingMaterial->InvoiceCode->AdvancedSearch->SearchValue = ew_StripSlashes(@$_GET["x_InvoiceCode"]); $CPDTrainingMaterial->InvoiceCode->AdvancedSearch->SearchOperator = @$_GET["z_InvoiceCode"]; // InvoiceNumber $CPDTrainingMaterial->InvoiceNumber->AdvancedSearch->SearchValue = ew_StripSlashes(@$_GET["x_InvoiceNumber"]); $CPDTrainingMaterial->InvoiceNumber->AdvancedSearch->SearchOperator = @$_GET["z_InvoiceNumber"]; // Cost $CPDTrainingMaterial->Cost->AdvancedSearch->SearchValue = ew_StripSlashes(@$_GET["x_Cost"]); $CPDTrainingMaterial->Cost->AdvancedSearch->SearchOperator = @$_GET["z_Cost"]; // CostToDelegate $CPDTrainingMaterial->CostToDelegate->AdvancedSearch->SearchValue = ew_StripSlashes(@$_GET["x_CostToDelegate"]); $CPDTrainingMaterial->CostToDelegate->AdvancedSearch->SearchOperator = @$_GET["z_CostToDelegate"]; // DepositAmt $CPDTrainingMaterial->DepositAmt->AdvancedSearch->SearchValue = ew_StripSlashes(@$_GET["x_DepositAmt"]); $CPDTrainingMaterial->DepositAmt->AdvancedSearch->SearchOperator = @$_GET["z_DepositAmt"]; // InvoiceDate $CPDTrainingMaterial->InvoiceDate->AdvancedSearch->SearchValue = ew_StripSlashes(@$_GET["x_InvoiceDate"]); $CPDTrainingMaterial->InvoiceDate->AdvancedSearch->SearchOperator = @$_GET["z_InvoiceDate"]; // DatePaid $CPDTrainingMaterial->DatePaid->AdvancedSearch->SearchValue = ew_StripSlashes(@$_GET["x_DatePaid"]); $CPDTrainingMaterial->DatePaid->AdvancedSearch->SearchOperator = @$_GET["z_DatePaid"]; // EvaluatorID $CPDTrainingMaterial->EvaluatorID->AdvancedSearch->SearchValue = ew_StripSlashes(@$_GET["x_EvaluatorID"]); $CPDTrainingMaterial->EvaluatorID->AdvancedSearch->SearchOperator = @$_GET["z_EvaluatorID"]; // EvaluatorID2 $CPDTrainingMaterial->EvaluatorID2->AdvancedSearch->SearchValue = ew_StripSlashes(@$_GET["x_EvaluatorID2"]); $CPDTrainingMaterial->EvaluatorID2->AdvancedSearch->SearchOperator = @$_GET["z_EvaluatorID2"]; // EvaluatorID3 $CPDTrainingMaterial->EvaluatorID3->AdvancedSearch->SearchValue = ew_StripSlashes(@$_GET["x_EvaluatorID3"]); $CPDTrainingMaterial->EvaluatorID3->AdvancedSearch->SearchOperator = @$_GET["z_EvaluatorID3"]; // EvaluatorFee $CPDTrainingMaterial->EvaluatorFee->AdvancedSearch->SearchValue = ew_StripSlashes(@$_GET["x_EvaluatorFee"]); $CPDTrainingMaterial->EvaluatorFee->AdvancedSearch->SearchOperator = @$_GET["z_EvaluatorFee"]; // EvaluatorFeeAmount $CPDTrainingMaterial->EvaluatorFeeAmount->AdvancedSearch->SearchValue = ew_StripSlashes(@$_GET["x_EvaluatorFeeAmount"]); $CPDTrainingMaterial->EvaluatorFeeAmount->AdvancedSearch->SearchOperator = @$_GET["z_EvaluatorFeeAmount"]; // EvaluatorFeeDate $CPDTrainingMaterial->EvaluatorFeeDate->AdvancedSearch->SearchValue = ew_StripSlashes(@$_GET["x_EvaluatorFeeDate"]); $CPDTrainingMaterial->EvaluatorFeeDate->AdvancedSearch->SearchOperator = @$_GET["z_EvaluatorFeeDate"]; // StartDate $CPDTrainingMaterial->StartDate->AdvancedSearch->SearchValue = ew_StripSlashes(@$_GET["x_StartDate"]); $CPDTrainingMaterial->StartDate->AdvancedSearch->SearchOperator = @$_GET["z_StartDate"]; // Other_Validator $CPDTrainingMaterial->Other_Validator->AdvancedSearch->SearchValue = ew_StripSlashes(@$_GET["x_Other_Validator"]); $CPDTrainingMaterial->Other_Validator->AdvancedSearch->SearchOperator = @$_GET["z_Other_Validator"]; // Provider_URL $CPDTrainingMaterial->Provider_URL->AdvancedSearch->SearchValue = ew_StripSlashes(@$_GET["x_Provider_URL"]); $CPDTrainingMaterial->Provider_URL->AdvancedSearch->SearchOperator = @$_GET["z_Provider_URL"]; // Category_Reg $CPDTrainingMaterial->Category_Reg->AdvancedSearch->SearchValue = ew_StripSlashes(@$_GET["x_Category_Reg"]); $CPDTrainingMaterial->Category_Reg->AdvancedSearch->SearchOperator = @$_GET["z_Category_Reg"]; // Discipline $CPDTrainingMaterial->Discipline->AdvancedSearch->SearchValue = ew_StripSlashes(@$_GET["x_Discipline"]); $CPDTrainingMaterial->Discipline->AdvancedSearch->SearchOperator = @$_GET["z_Discipline"]; // Sub_Discipline $CPDTrainingMaterial->Sub_Discipline->AdvancedSearch->SearchValue = ew_StripSlashes(@$_GET["x_Sub_Discipline"]); $CPDTrainingMaterial->Sub_Discipline->AdvancedSearch->SearchOperator = @$_GET["z_Sub_Discipline"]; // Activity_Nature $CPDTrainingMaterial->Activity_Nature->AdvancedSearch->SearchValue = ew_StripSlashes(@$_GET["x_Activity_Nature"]); $CPDTrainingMaterial->Activity_Nature->AdvancedSearch->SearchOperator = @$_GET["z_Activity_Nature"]; // Instances $CPDTrainingMaterial->Instances->AdvancedSearch->SearchValue = ew_StripSlashes(@$_GET["x_Instances"]); $CPDTrainingMaterial->Instances->AdvancedSearch->SearchOperator = @$_GET["z_Instances"]; // LocalUpload $CPDTrainingMaterial->LocalUpload->AdvancedSearch->SearchValue = ew_StripSlashes(@$_GET["x_LocalUpload"]); $CPDTrainingMaterial->LocalUpload->AdvancedSearch->SearchOperator = @$_GET["z_LocalUpload"]; // ResponsiblePersonFirstName $CPDTrainingMaterial->ResponsiblePersonFirstName->AdvancedSearch->SearchValue = ew_StripSlashes(@$_GET["x_ResponsiblePersonFirstName"]); $CPDTrainingMaterial->ResponsiblePersonFirstName->AdvancedSearch->SearchOperator = @$_GET["z_ResponsiblePersonFirstName"]; // ResponsiblePersonLastName $CPDTrainingMaterial->ResponsiblePersonLastName->AdvancedSearch->SearchValue = ew_StripSlashes(@$_GET["x_ResponsiblePersonLastName"]); $CPDTrainingMaterial->ResponsiblePersonLastName->AdvancedSearch->SearchOperator = @$_GET["z_ResponsiblePersonLastName"]; // ResponsiblePersonEMailAddress $CPDTrainingMaterial->ResponsiblePersonEMailAddress->AdvancedSearch->SearchValue = ew_StripSlashes(@$_GET["x_ResponsiblePersonEMailAddress"]); $CPDTrainingMaterial->ResponsiblePersonEMailAddress->AdvancedSearch->SearchOperator = @$_GET["z_ResponsiblePersonEMailAddress"]; // ResponsibleBillingAddress $CPDTrainingMaterial->ResponsibleBillingAddress->AdvancedSearch->SearchValue = ew_StripSlashes(@$_GET["x_ResponsibleBillingAddress"]); $CPDTrainingMaterial->ResponsibleBillingAddress->AdvancedSearch->SearchOperator = @$_GET["z_ResponsibleBillingAddress"]; // ResponsiblePersonContactNumber $CPDTrainingMaterial->ResponsiblePersonContactNumber->AdvancedSearch->SearchValue = ew_StripSlashes(@$_GET["x_ResponsiblePersonContactNumber"]); $CPDTrainingMaterial->ResponsiblePersonContactNumber->AdvancedSearch->SearchOperator = @$_GET["z_ResponsiblePersonContactNumber"]; // ResponsibleVATNumber $CPDTrainingMaterial->ResponsibleVATNumber->AdvancedSearch->SearchValue = ew_StripSlashes(@$_GET["x_ResponsibleVATNumber"]); $CPDTrainingMaterial->ResponsibleVATNumber->AdvancedSearch->SearchOperator = @$_GET["z_ResponsibleVATNumber"]; // Comments $CPDTrainingMaterial->Comments->AdvancedSearch->SearchValue = ew_StripSlashes(@$_GET["x_Comments"]); $CPDTrainingMaterial->Comments->AdvancedSearch->SearchOperator = @$_GET["z_Comments"]; // Archived $CPDTrainingMaterial->Archived->AdvancedSearch->SearchValue = ew_StripSlashes(@$_GET["x_Archived"]); $CPDTrainingMaterial->Archived->AdvancedSearch->SearchOperator = @$_GET["z_Archived"]; // Presenter1Title $CPDTrainingMaterial->Presenter1Title->AdvancedSearch->SearchValue = ew_StripSlashes(@$_GET["x_Presenter1Title"]); $CPDTrainingMaterial->Presenter1Title->AdvancedSearch->SearchOperator = @$_GET["z_Presenter1Title"]; // Presenter1FirstName $CPDTrainingMaterial->Presenter1FirstName->AdvancedSearch->SearchValue = ew_StripSlashes(@$_GET["x_Presenter1FirstName"]); $CPDTrainingMaterial->Presenter1FirstName->AdvancedSearch->SearchOperator = @$_GET["z_Presenter1FirstName"]; // Presenter1Surname $CPDTrainingMaterial->Presenter1Surname->AdvancedSearch->SearchValue = ew_StripSlashes(@$_GET["x_Presenter1Surname"]); $CPDTrainingMaterial->Presenter1Surname->AdvancedSearch->SearchOperator = @$_GET["z_Presenter1Surname"]; // Presenter1Phone $CPDTrainingMaterial->Presenter1Phone->AdvancedSearch->SearchValue = ew_StripSlashes(@$_GET["x_Presenter1Phone"]); $CPDTrainingMaterial->Presenter1Phone->AdvancedSearch->SearchOperator = @$_GET["z_Presenter1Phone"]; // Presenter1Email $CPDTrainingMaterial->Presenter1Email->AdvancedSearch->SearchValue = ew_StripSlashes(@$_GET["x_Presenter1Email"]); $CPDTrainingMaterial->Presenter1Email->AdvancedSearch->SearchOperator = @$_GET["z_Presenter1Email"]; // Presenter1ID $CPDTrainingMaterial->Presenter1ID->AdvancedSearch->SearchValue = ew_StripSlashes(@$_GET["x_Presenter1ID"]); $CPDTrainingMaterial->Presenter1ID->AdvancedSearch->SearchOperator = @$_GET["z_Presenter1ID"]; // Presenter2Title $CPDTrainingMaterial->Presenter2Title->AdvancedSearch->SearchValue = ew_StripSlashes(@$_GET["x_Presenter2Title"]); $CPDTrainingMaterial->Presenter2Title->AdvancedSearch->SearchOperator = @$_GET["z_Presenter2Title"]; // Presenter2FirstName $CPDTrainingMaterial->Presenter2FirstName->AdvancedSearch->SearchValue = ew_StripSlashes(@$_GET["x_Presenter2FirstName"]); $CPDTrainingMaterial->Presenter2FirstName->AdvancedSearch->SearchOperator = @$_GET["z_Presenter2FirstName"]; // Presenter2Surname $CPDTrainingMaterial->Presenter2Surname->AdvancedSearch->SearchValue = ew_StripSlashes(@$_GET["x_Presenter2Surname"]); $CPDTrainingMaterial->Presenter2Surname->AdvancedSearch->SearchOperator = @$_GET["z_Presenter2Surname"]; // Presenter2Phone $CPDTrainingMaterial->Presenter2Phone->AdvancedSearch->SearchValue = ew_StripSlashes(@$_GET["x_Presenter2Phone"]); $CPDTrainingMaterial->Presenter2Phone->AdvancedSearch->SearchOperator = @$_GET["z_Presenter2Phone"]; // Presenter2Email $CPDTrainingMaterial->Presenter2Email->AdvancedSearch->SearchValue = ew_StripSlashes(@$_GET["x_Presenter2Email"]); $CPDTrainingMaterial->Presenter2Email->AdvancedSearch->SearchOperator = @$_GET["z_Presenter2Email"]; // Presenter2ID $CPDTrainingMaterial->Presenter2ID->AdvancedSearch->SearchValue = ew_StripSlashes(@$_GET["x_Presenter2ID"]); $CPDTrainingMaterial->Presenter2ID->AdvancedSearch->SearchOperator = @$_GET["z_Presenter2ID"]; // Presenter3Title $CPDTrainingMaterial->Presenter3Title->AdvancedSearch->SearchValue = ew_StripSlashes(@$_GET["x_Presenter3Title"]); $CPDTrainingMaterial->Presenter3Title->AdvancedSearch->SearchOperator = @$_GET["z_Presenter3Title"]; // Presenter3FirstName $CPDTrainingMaterial->Presenter3FirstName->AdvancedSearch->SearchValue = ew_StripSlashes(@$_GET["x_Presenter3FirstName"]); $CPDTrainingMaterial->Presenter3FirstName->AdvancedSearch->SearchOperator = @$_GET["z_Presenter3FirstName"]; // Presenter3Surname $CPDTrainingMaterial->Presenter3Surname->AdvancedSearch->SearchValue = ew_StripSlashes(@$_GET["x_Presenter3Surname"]); $CPDTrainingMaterial->Presenter3Surname->AdvancedSearch->SearchOperator = @$_GET["z_Presenter3Surname"]; // Presenter3Phone $CPDTrainingMaterial->Presenter3Phone->AdvancedSearch->SearchValue = ew_StripSlashes(@$_GET["x_Presenter3Phone"]); $CPDTrainingMaterial->Presenter3Phone->AdvancedSearch->SearchOperator = @$_GET["z_Presenter3Phone"]; // Presenter3Email $CPDTrainingMaterial->Presenter3Email->AdvancedSearch->SearchValue = ew_StripSlashes(@$_GET["x_Presenter3Email"]); $CPDTrainingMaterial->Presenter3Email->AdvancedSearch->SearchOperator = @$_GET["z_Presenter3Email"]; // Presenter3ID $CPDTrainingMaterial->Presenter3ID->AdvancedSearch->SearchValue = ew_StripSlashes(@$_GET["x_Presenter3ID"]); $CPDTrainingMaterial->Presenter3ID->AdvancedSearch->SearchOperator = @$_GET["z_Presenter3ID"]; // DateCreated $CPDTrainingMaterial->DateCreated->AdvancedSearch->SearchValue = ew_StripSlashes(@$_GET["x_DateCreated"]); $CPDTrainingMaterial->DateCreated->AdvancedSearch->SearchOperator = @$_GET["z_DateCreated"]; } // Load recordset function LoadRecordset($offset = -1, $rowcnt = -1) { global $conn, $CPDTrainingMaterial; // Call Recordset Selecting event $CPDTrainingMaterial->Recordset_Selecting($CPDTrainingMaterial->CurrentFilter); // Load List page SQL $sSql = $CPDTrainingMaterial->SelectSQL(); if ($offset > -1 && $rowcnt > -1) $sSql .= " LIMIT $offset, $rowcnt"; // Load recordset $rs = ew_LoadRecordset($sSql); // Call Recordset Selected event $CPDTrainingMaterial->Recordset_Selected($rs); return $rs; } // Load row based on key values function LoadRow() { global $conn, $Security, $CPDTrainingMaterial; $sFilter = $CPDTrainingMaterial->KeyFilter(); // Call Row Selecting event $CPDTrainingMaterial->Row_Selecting($sFilter); // Load SQL based on filter $CPDTrainingMaterial->CurrentFilter = $sFilter; $sSql = $CPDTrainingMaterial->SQL(); $res = FALSE; $rs = ew_LoadRecordset($sSql); if ($rs && !$rs->EOF) { $res = TRUE; $this->LoadRowValues($rs); // Load row values // Call Row Selected event $CPDTrainingMaterial->Row_Selected($rs); $rs->Close(); } return $res; } // Load row values from recordset function LoadRowValues(&$rs) { global $conn, $CPDTrainingMaterial; $CPDTrainingMaterial->MaterialID->setDbValue($rs->fields('MaterialID')); $CPDTrainingMaterial->ProviderID->setDbValue($rs->fields('ProviderID')); $CPDTrainingMaterial->Subject->setDbValue($rs->fields('Subject')); $CPDTrainingMaterial->RenewOrNew->setDbValue($rs->fields('RenewOrNew')); $CPDTrainingMaterial->Status->setDbValue($rs->fields('Status')); $CPDTrainingMaterial->Duration->setDbValue($rs->fields('Duration')); $CPDTrainingMaterial->DurationUnit->setDbValue($rs->fields('DurationUnit')); $CPDTrainingMaterial->DurationType->setDbValue($rs->fields('DurationType')); $CPDTrainingMaterial->Level->setDbValue($rs->fields('Level')); $CPDTrainingMaterial->NQFLevel->setDbValue($rs->fields('NQFLevel')); $CPDTrainingMaterial->EventDescription->setDbValue($rs->fields('EventDescription')); $CPDTrainingMaterial->CourseBrochure->Upload->DbValue = $rs->fields('CourseBrochure'); $CPDTrainingMaterial->ActivityProgramme->Upload->DbValue = $rs->fields('ActivityProgramme'); $CPDTrainingMaterial->LearningOutcomesFile->Upload->DbValue = $rs->fields('LearningOutcomesFile'); $CPDTrainingMaterial->TrainingManualLink->setDbValue($rs->fields('TrainingManualLink')); $CPDTrainingMaterial->PresentationLink->setDbValue($rs->fields('PresentationLink')); $CPDTrainingMaterial->HandOutsLink->setDbValue($rs->fields('HandOutsLink')); $CPDTrainingMaterial->FeedbackForm->Upload->DbValue = $rs->fields('FeedbackForm'); $CPDTrainingMaterial->LearningOutcomes->setDbValue($rs->fields('LearningOutcomes')); $CPDTrainingMaterial->ModeOfDelivery->setDbValue($rs->fields('ModeOfDelivery')); $CPDTrainingMaterial->TargetAudience->setDbValue($rs->fields('TargetAudience')); $CPDTrainingMaterial->Objectives->setDbValue($rs->fields('Objectives')); $CPDTrainingMaterial->Promotion->setDbValue($rs->fields('Promotion')); $CPDTrainingMaterial->Motivation->setDbValue($rs->fields('Motivation')); $CPDTrainingMaterial->AccredNum->setDbValue($rs->fields('AccredNum')); $CPDTrainingMaterial->PrevAccredNum->setDbValue($rs->fields('PrevAccredNum')); $CPDTrainingMaterial->DateApproved->setDbValue($rs->fields('DateApproved')); $CPDTrainingMaterial->DateExpires->setDbValue($rs->fields('DateExpires')); $CPDTrainingMaterial->Certification->setDbValue($rs->fields('Certification')); $CPDTrainingMaterial->CPD->setDbValue($rs->fields('CPD')); $CPDTrainingMaterial->InvoiceCode->setDbValue($rs->fields('InvoiceCode')); $CPDTrainingMaterial->InvoiceNumber->setDbValue($rs->fields('InvoiceNumber')); $CPDTrainingMaterial->Cost->setDbValue($rs->fields('Cost')); $CPDTrainingMaterial->CostToDelegate->setDbValue($rs->fields('CostToDelegate')); $CPDTrainingMaterial->DepositAmt->setDbValue($rs->fields('DepositAmt')); $CPDTrainingMaterial->InvoiceFile->Upload->DbValue = $rs->fields('InvoiceFile'); $CPDTrainingMaterial->InvoiceDate->setDbValue($rs->fields('InvoiceDate')); $CPDTrainingMaterial->DatePaid->setDbValue($rs->fields('DatePaid')); $CPDTrainingMaterial->ProofOfPayment->Upload->DbValue = $rs->fields('ProofOfPayment'); $CPDTrainingMaterial->EvaluatorID->setDbValue($rs->fields('EvaluatorID')); $CPDTrainingMaterial->EvaluatorID2->setDbValue($rs->fields('EvaluatorID2')); $CPDTrainingMaterial->EvaluatorID3->setDbValue($rs->fields('EvaluatorID3')); $CPDTrainingMaterial->EvaluatorFee->setDbValue($rs->fields('EvaluatorFee')); $CPDTrainingMaterial->EvaluatorFeeAmount->setDbValue($rs->fields('EvaluatorFeeAmount')); $CPDTrainingMaterial->EvaluatorFeeDate->setDbValue($rs->fields('EvaluatorFeeDate')); $CPDTrainingMaterial->EvaluatorInvoice->Upload->DbValue = $rs->fields('EvaluatorInvoice'); $CPDTrainingMaterial->EvaluatorTimesheet->Upload->DbValue = $rs->fields('EvaluatorTimesheet'); $CPDTrainingMaterial->StartDate->setDbValue($rs->fields('StartDate')); $CPDTrainingMaterial->Other_Validator->setDbValue($rs->fields('Other_Validator')); $CPDTrainingMaterial->Provider_URL->setDbValue($rs->fields('Provider_URL')); $CPDTrainingMaterial->Notional_Hours->setDbValue($rs->fields('Notional_Hours')); $CPDTrainingMaterial->Category_Reg->setDbValue($rs->fields('Category_Reg')); $CPDTrainingMaterial->Discipline->setDbValue($rs->fields('Discipline')); $CPDTrainingMaterial->Sub_Discipline->setDbValue($rs->fields('Sub_Discipline')); $CPDTrainingMaterial->Activity_Nature->setDbValue($rs->fields('Activity_Nature')); $CPDTrainingMaterial->Instances->setDbValue($rs->fields('Instances')); $CPDTrainingMaterial->RemoteUpload->setDbValue($rs->fields('RemoteUpload')); $CPDTrainingMaterial->LocalUpload->setDbValue($rs->fields('LocalUpload')); $CPDTrainingMaterial->AssessmentDoc->Upload->DbValue = $rs->fields('AssessmentDoc'); $CPDTrainingMaterial->ResponsiblePersonFirstName->setDbValue($rs->fields('ResponsiblePersonFirstName')); $CPDTrainingMaterial->ResponsiblePersonLastName->setDbValue($rs->fields('ResponsiblePersonLastName')); $CPDTrainingMaterial->ResponsiblePersonEMailAddress->setDbValue($rs->fields('ResponsiblePersonEMailAddress')); $CPDTrainingMaterial->ResponsibleBillingAddress->setDbValue($rs->fields('ResponsibleBillingAddress')); $CPDTrainingMaterial->ResponsiblePersonContactNumber->setDbValue($rs->fields('ResponsiblePersonContactNumber')); $CPDTrainingMaterial->ResponsibleVATNumber->setDbValue($rs->fields('ResponsibleVATNumber')); $CPDTrainingMaterial->Comments->setDbValue($rs->fields('Comments')); $CPDTrainingMaterial->Archived->setDbValue($rs->fields('Archived')); $CPDTrainingMaterial->Presenter1Title->setDbValue($rs->fields('Presenter1Title')); $CPDTrainingMaterial->Presenter1FirstName->setDbValue($rs->fields('Presenter1FirstName')); $CPDTrainingMaterial->Presenter1Surname->setDbValue($rs->fields('Presenter1Surname')); $CPDTrainingMaterial->Presenter1Phone->setDbValue($rs->fields('Presenter1Phone')); $CPDTrainingMaterial->Presenter1Email->setDbValue($rs->fields('Presenter1Email')); $CPDTrainingMaterial->Presenter1ID->setDbValue($rs->fields('Presenter1ID')); $CPDTrainingMaterial->Presenter1CV->Upload->DbValue = $rs->fields('Presenter1CV'); $CPDTrainingMaterial->Presenter1SLA->Upload->DbValue = $rs->fields('Presenter1SLA'); $CPDTrainingMaterial->Presenter1IDDoc->Upload->DbValue = $rs->fields('Presenter1IDDoc'); $CPDTrainingMaterial->Presenter2Title->setDbValue($rs->fields('Presenter2Title')); $CPDTrainingMaterial->Presenter2FirstName->setDbValue($rs->fields('Presenter2FirstName')); $CPDTrainingMaterial->Presenter2Surname->setDbValue($rs->fields('Presenter2Surname')); $CPDTrainingMaterial->Presenter2Phone->setDbValue($rs->fields('Presenter2Phone')); $CPDTrainingMaterial->Presenter2Email->setDbValue($rs->fields('Presenter2Email')); $CPDTrainingMaterial->Presenter2ID->setDbValue($rs->fields('Presenter2ID')); $CPDTrainingMaterial->Presenter2CV->Upload->DbValue = $rs->fields('Presenter2CV'); $CPDTrainingMaterial->Presenter2SLA->Upload->DbValue = $rs->fields('Presenter2SLA'); $CPDTrainingMaterial->Presenter2IDDoc->Upload->DbValue = $rs->fields('Presenter2IDDoc'); $CPDTrainingMaterial->Presenter3Title->setDbValue($rs->fields('Presenter3Title')); $CPDTrainingMaterial->Presenter3FirstName->setDbValue($rs->fields('Presenter3FirstName')); $CPDTrainingMaterial->Presenter3Surname->setDbValue($rs->fields('Presenter3Surname')); $CPDTrainingMaterial->Presenter3Phone->setDbValue($rs->fields('Presenter3Phone')); $CPDTrainingMaterial->Presenter3Email->setDbValue($rs->fields('Presenter3Email')); $CPDTrainingMaterial->Presenter3ID->setDbValue($rs->fields('Presenter3ID')); $CPDTrainingMaterial->Presenter3CV->Upload->DbValue = $rs->fields('Presenter3CV'); $CPDTrainingMaterial->Presenter3SLA->Upload->DbValue = $rs->fields('Presenter3SLA'); $CPDTrainingMaterial->Presenter3IDDoc->Upload->DbValue = $rs->fields('Presenter3IDDoc'); $CPDTrainingMaterial->NumReminders->setDbValue($rs->fields('NumReminders')); $CPDTrainingMaterial->LastReminder->setDbValue($rs->fields('LastReminder')); $CPDTrainingMaterial->DateCreated->setDbValue($rs->fields('DateCreated')); } // Render row values based on field settings function RenderRow() { global $conn, $Security, $Language, $CPDTrainingMaterial; // Initialize URLs $this->ViewUrl = $CPDTrainingMaterial->ViewUrl(); $this->EditUrl = $CPDTrainingMaterial->EditUrl(); $this->InlineEditUrl = $CPDTrainingMaterial->InlineEditUrl(); $this->CopyUrl = $CPDTrainingMaterial->CopyUrl(); $this->InlineCopyUrl = $CPDTrainingMaterial->InlineCopyUrl(); $this->DeleteUrl = $CPDTrainingMaterial->DeleteUrl(); // Call Row_Rendering event $CPDTrainingMaterial->Row_Rendering(); // Common render codes for all row types // ProviderID $CPDTrainingMaterial->ProviderID->CellCssStyle = ""; $CPDTrainingMaterial->ProviderID->CellCssClass = ""; $CPDTrainingMaterial->ProviderID->CellAttrs = array(); $CPDTrainingMaterial->ProviderID->ViewAttrs = array(); $CPDTrainingMaterial->ProviderID->EditAttrs = array(); // Subject $CPDTrainingMaterial->Subject->CellCssStyle = ""; $CPDTrainingMaterial->Subject->CellCssClass = ""; $CPDTrainingMaterial->Subject->CellAttrs = array(); $CPDTrainingMaterial->Subject->ViewAttrs = array(); $CPDTrainingMaterial->Subject->EditAttrs = array(); // RenewOrNew $CPDTrainingMaterial->RenewOrNew->CellCssStyle = ""; $CPDTrainingMaterial->RenewOrNew->CellCssClass = ""; $CPDTrainingMaterial->RenewOrNew->CellAttrs = array(); $CPDTrainingMaterial->RenewOrNew->ViewAttrs = array(); $CPDTrainingMaterial->RenewOrNew->EditAttrs = array(); // Status $CPDTrainingMaterial->Status->CellCssStyle = ""; $CPDTrainingMaterial->Status->CellCssClass = ""; $CPDTrainingMaterial->Status->CellAttrs = array(); $CPDTrainingMaterial->Status->ViewAttrs = array(); $CPDTrainingMaterial->Status->EditAttrs = array(); // AccredNum $CPDTrainingMaterial->AccredNum->CellCssStyle = ""; $CPDTrainingMaterial->AccredNum->CellCssClass = ""; $CPDTrainingMaterial->AccredNum->CellAttrs = array(); $CPDTrainingMaterial->AccredNum->ViewAttrs = array(); $CPDTrainingMaterial->AccredNum->EditAttrs = array(); // PrevAccredNum $CPDTrainingMaterial->PrevAccredNum->CellCssStyle = ""; $CPDTrainingMaterial->PrevAccredNum->CellCssClass = ""; $CPDTrainingMaterial->PrevAccredNum->CellAttrs = array(); $CPDTrainingMaterial->PrevAccredNum->ViewAttrs = array(); $CPDTrainingMaterial->PrevAccredNum->EditAttrs = array(); // DateApproved $CPDTrainingMaterial->DateApproved->CellCssStyle = ""; $CPDTrainingMaterial->DateApproved->CellCssClass = ""; $CPDTrainingMaterial->DateApproved->CellAttrs = array(); $CPDTrainingMaterial->DateApproved->ViewAttrs = array(); $CPDTrainingMaterial->DateApproved->EditAttrs = array(); // DatePaid $CPDTrainingMaterial->DatePaid->CellCssStyle = ""; $CPDTrainingMaterial->DatePaid->CellCssClass = ""; $CPDTrainingMaterial->DatePaid->CellAttrs = array(); $CPDTrainingMaterial->DatePaid->ViewAttrs = array(); $CPDTrainingMaterial->DatePaid->EditAttrs = array(); // DateCreated $CPDTrainingMaterial->DateCreated->CellCssStyle = ""; $CPDTrainingMaterial->DateCreated->CellCssClass = ""; $CPDTrainingMaterial->DateCreated->CellAttrs = array(); $CPDTrainingMaterial->DateCreated->ViewAttrs = array(); $CPDTrainingMaterial->DateCreated->EditAttrs = array(); if ($CPDTrainingMaterial->RowType == EW_ROWTYPE_VIEW) { // View row // MaterialID $CPDTrainingMaterial->MaterialID->ViewValue = $CPDTrainingMaterial->MaterialID->CurrentValue; $CPDTrainingMaterial->MaterialID->CssStyle = ""; $CPDTrainingMaterial->MaterialID->CssClass = ""; $CPDTrainingMaterial->MaterialID->ViewCustomAttributes = ""; // ProviderID if (strval($CPDTrainingMaterial->ProviderID->CurrentValue) <> "") { $sFilterWrk = "`CPDProviderID` = " . ew_AdjustSql($CPDTrainingMaterial->ProviderID->CurrentValue) . ""; $sSqlWrk = "SELECT `CompanyName`, `SPNumber` FROM `CPDServiceProvider`"; $sWhereWrk = ""; if ($sWhereWrk <> "") $sWhereWrk .= " AND "; $sWhereWrk .= "(" . "Archived=0" . ")"; if ($sFilterWrk <> "") { if ($sWhereWrk <> "") $sWhereWrk .= " AND "; $sWhereWrk .= "(" . $sFilterWrk . ")"; } if ($sWhereWrk <> "") $sSqlWrk .= " WHERE " . $sWhereWrk; $sSqlWrk .= " ORDER BY `CompanyName`"; $rswrk = $conn->Execute($sSqlWrk); if ($rswrk && !$rswrk->EOF) { // Lookup values found $CPDTrainingMaterial->ProviderID->ViewValue = $rswrk->fields('CompanyName'); $CPDTrainingMaterial->ProviderID->ViewValue .= ew_ValueSeparator(0) . $rswrk->fields('SPNumber'); $rswrk->Close(); } else { $CPDTrainingMaterial->ProviderID->ViewValue = $CPDTrainingMaterial->ProviderID->CurrentValue; } } else { $CPDTrainingMaterial->ProviderID->ViewValue = NULL; } $CPDTrainingMaterial->ProviderID->CssStyle = ""; $CPDTrainingMaterial->ProviderID->CssClass = ""; $CPDTrainingMaterial->ProviderID->ViewCustomAttributes = ""; // Subject $CPDTrainingMaterial->Subject->ViewValue = $CPDTrainingMaterial->Subject->CurrentValue; $CPDTrainingMaterial->Subject->CssStyle = ""; $CPDTrainingMaterial->Subject->CssClass = ""; $CPDTrainingMaterial->Subject->ViewCustomAttributes = ""; // RenewOrNew if (strval($CPDTrainingMaterial->RenewOrNew->CurrentValue) <> "") { switch ($CPDTrainingMaterial->RenewOrNew->CurrentValue) { case "n": $CPDTrainingMaterial->RenewOrNew->ViewValue = "New"; break; case "r": $CPDTrainingMaterial->RenewOrNew->ViewValue = "Renewal"; break; default: $CPDTrainingMaterial->RenewOrNew->ViewValue = $CPDTrainingMaterial->RenewOrNew->CurrentValue; } } else { $CPDTrainingMaterial->RenewOrNew->ViewValue = NULL; } $CPDTrainingMaterial->RenewOrNew->CssStyle = ""; $CPDTrainingMaterial->RenewOrNew->CssClass = ""; $CPDTrainingMaterial->RenewOrNew->ViewCustomAttributes = ""; // Status if (strval($CPDTrainingMaterial->Status->CurrentValue) <> "") { switch ($CPDTrainingMaterial->Status->CurrentValue) { case "Pending": $CPDTrainingMaterial->Status->ViewValue = "Pending"; break; case "Approved": $CPDTrainingMaterial->Status->ViewValue = "Approved"; break; case "Declined": $CPDTrainingMaterial->Status->ViewValue = "Declined"; break; case "Suspended": $CPDTrainingMaterial->Status->ViewValue = "Suspended"; break; case "Discontinued": $CPDTrainingMaterial->Status->ViewValue = "Discontinued"; break; default: $CPDTrainingMaterial->Status->ViewValue = $CPDTrainingMaterial->Status->CurrentValue; } } else { $CPDTrainingMaterial->Status->ViewValue = NULL; } $CPDTrainingMaterial->Status->CssStyle = ""; $CPDTrainingMaterial->Status->CssClass = ""; $CPDTrainingMaterial->Status->ViewCustomAttributes = ""; // Duration $CPDTrainingMaterial->Duration->ViewValue = $CPDTrainingMaterial->Duration->CurrentValue; $CPDTrainingMaterial->Duration->CssStyle = ""; $CPDTrainingMaterial->Duration->CssClass = ""; $CPDTrainingMaterial->Duration->ViewCustomAttributes = ""; // DurationUnit if (strval($CPDTrainingMaterial->DurationUnit->CurrentValue) <> "") { switch ($CPDTrainingMaterial->DurationUnit->CurrentValue) { case "Hours": $CPDTrainingMaterial->DurationUnit->ViewValue = "Hours"; break; case "Days": $CPDTrainingMaterial->DurationUnit->ViewValue = "Days"; break; default: $CPDTrainingMaterial->DurationUnit->ViewValue = $CPDTrainingMaterial->DurationUnit->CurrentValue; } } else { $CPDTrainingMaterial->DurationUnit->ViewValue = NULL; } $CPDTrainingMaterial->DurationUnit->CssStyle = ""; $CPDTrainingMaterial->DurationUnit->CssClass = ""; $CPDTrainingMaterial->DurationUnit->ViewCustomAttributes = ""; // Level if (strval($CPDTrainingMaterial->Level->CurrentValue) <> "") { switch ($CPDTrainingMaterial->Level->CurrentValue) { case "Conference": $CPDTrainingMaterial->Level->ViewValue = "Conference"; break; case "Congress": $CPDTrainingMaterial->Level->ViewValue = "Congress"; break; case "Course": $CPDTrainingMaterial->Level->ViewValue = "Course"; break; case "E-learning": $CPDTrainingMaterial->Level->ViewValue = "E-learning"; break; case "Large Group Workshop": $CPDTrainingMaterial->Level->ViewValue = "Large Group Workshop"; break; case "Lecture": $CPDTrainingMaterial->Level->ViewValue = "Lecture"; break; case "Refresher Course": $CPDTrainingMaterial->Level->ViewValue = "Refresher Course"; break; case "Seminar": $CPDTrainingMaterial->Level->ViewValue = "Seminar"; break; case "Workshop": $CPDTrainingMaterial->Level->ViewValue = "Workshop"; break; case "Webinar": $CPDTrainingMaterial->Level->ViewValue = "Webinar"; break; default: $CPDTrainingMaterial->Level->ViewValue = $CPDTrainingMaterial->Level->CurrentValue; } } else { $CPDTrainingMaterial->Level->ViewValue = NULL; } $CPDTrainingMaterial->Level->CssStyle = ""; $CPDTrainingMaterial->Level->CssClass = ""; $CPDTrainingMaterial->Level->ViewCustomAttributes = ""; // CourseBrochure if (!ew_Empty($CPDTrainingMaterial->CourseBrochure->Upload->DbValue)) { $CPDTrainingMaterial->CourseBrochure->ViewValue = $CPDTrainingMaterial->CourseBrochure->Upload->DbValue; } else { $CPDTrainingMaterial->CourseBrochure->ViewValue = ""; } $CPDTrainingMaterial->CourseBrochure->CssStyle = ""; $CPDTrainingMaterial->CourseBrochure->CssClass = ""; $CPDTrainingMaterial->CourseBrochure->ViewCustomAttributes = ""; // ActivityProgramme if (!ew_Empty($CPDTrainingMaterial->ActivityProgramme->Upload->DbValue)) { $CPDTrainingMaterial->ActivityProgramme->ViewValue = $CPDTrainingMaterial->ActivityProgramme->Upload->DbValue; } else { $CPDTrainingMaterial->ActivityProgramme->ViewValue = ""; } $CPDTrainingMaterial->ActivityProgramme->CssStyle = ""; $CPDTrainingMaterial->ActivityProgramme->CssClass = ""; $CPDTrainingMaterial->ActivityProgramme->ViewCustomAttributes = ""; // LearningOutcomesFile if (!ew_Empty($CPDTrainingMaterial->LearningOutcomesFile->Upload->DbValue)) { $CPDTrainingMaterial->LearningOutcomesFile->ViewValue = $CPDTrainingMaterial->LearningOutcomesFile->Upload->DbValue; } else { $CPDTrainingMaterial->LearningOutcomesFile->ViewValue = ""; } $CPDTrainingMaterial->LearningOutcomesFile->CssStyle = ""; $CPDTrainingMaterial->LearningOutcomesFile->CssClass = ""; $CPDTrainingMaterial->LearningOutcomesFile->ViewCustomAttributes = ""; // TrainingManualLink $CPDTrainingMaterial->TrainingManualLink->ViewValue = $CPDTrainingMaterial->TrainingManualLink->CurrentValue; $CPDTrainingMaterial->TrainingManualLink->CssStyle = ""; $CPDTrainingMaterial->TrainingManualLink->CssClass = ""; $CPDTrainingMaterial->TrainingManualLink->ViewCustomAttributes = ""; // PresentationLink $CPDTrainingMaterial->PresentationLink->ViewValue = $CPDTrainingMaterial->PresentationLink->CurrentValue; $CPDTrainingMaterial->PresentationLink->CssStyle = ""; $CPDTrainingMaterial->PresentationLink->CssClass = ""; $CPDTrainingMaterial->PresentationLink->ViewCustomAttributes = ""; // HandOutsLink $CPDTrainingMaterial->HandOutsLink->ViewValue = $CPDTrainingMaterial->HandOutsLink->CurrentValue; $CPDTrainingMaterial->HandOutsLink->CssStyle = ""; $CPDTrainingMaterial->HandOutsLink->CssClass = ""; $CPDTrainingMaterial->HandOutsLink->ViewCustomAttributes = ""; // FeedbackForm if (!ew_Empty($CPDTrainingMaterial->FeedbackForm->Upload->DbValue)) { $CPDTrainingMaterial->FeedbackForm->ViewValue = $CPDTrainingMaterial->FeedbackForm->Upload->DbValue; } else { $CPDTrainingMaterial->FeedbackForm->ViewValue = ""; } $CPDTrainingMaterial->FeedbackForm->CssStyle = ""; $CPDTrainingMaterial->FeedbackForm->CssClass = ""; $CPDTrainingMaterial->FeedbackForm->ViewCustomAttributes = ""; // ModeOfDelivery $CPDTrainingMaterial->ModeOfDelivery->ViewValue = $CPDTrainingMaterial->ModeOfDelivery->CurrentValue; $CPDTrainingMaterial->ModeOfDelivery->CssStyle = ""; $CPDTrainingMaterial->ModeOfDelivery->CssClass = ""; $CPDTrainingMaterial->ModeOfDelivery->ViewCustomAttributes = ""; // Promotion if (strval($CPDTrainingMaterial->Promotion->CurrentValue) <> "") { switch ($CPDTrainingMaterial->Promotion->CurrentValue) { case "Yes": $CPDTrainingMaterial->Promotion->ViewValue = "Yes"; break; case "No": $CPDTrainingMaterial->Promotion->ViewValue = "No"; break; default: $CPDTrainingMaterial->Promotion->ViewValue = $CPDTrainingMaterial->Promotion->CurrentValue; } } else { $CPDTrainingMaterial->Promotion->ViewValue = NULL; } $CPDTrainingMaterial->Promotion->CssStyle = ""; $CPDTrainingMaterial->Promotion->CssClass = ""; $CPDTrainingMaterial->Promotion->ViewCustomAttributes = ""; // AccredNum $CPDTrainingMaterial->AccredNum->ViewValue = $CPDTrainingMaterial->AccredNum->CurrentValue; $CPDTrainingMaterial->AccredNum->CssStyle = ""; $CPDTrainingMaterial->AccredNum->CssClass = ""; $CPDTrainingMaterial->AccredNum->ViewCustomAttributes = ""; // PrevAccredNum $CPDTrainingMaterial->PrevAccredNum->ViewValue = $CPDTrainingMaterial->PrevAccredNum->CurrentValue; $CPDTrainingMaterial->PrevAccredNum->CssStyle = ""; $CPDTrainingMaterial->PrevAccredNum->CssClass = ""; $CPDTrainingMaterial->PrevAccredNum->ViewCustomAttributes = ""; // DateApproved $CPDTrainingMaterial->DateApproved->ViewValue = $CPDTrainingMaterial->DateApproved->CurrentValue; $CPDTrainingMaterial->DateApproved->ViewValue = ew_FormatDateTime($CPDTrainingMaterial->DateApproved->ViewValue, 5); $CPDTrainingMaterial->DateApproved->CssStyle = ""; $CPDTrainingMaterial->DateApproved->CssClass = ""; $CPDTrainingMaterial->DateApproved->ViewCustomAttributes = ""; // DateExpires $CPDTrainingMaterial->DateExpires->ViewValue = $CPDTrainingMaterial->DateExpires->CurrentValue; $CPDTrainingMaterial->DateExpires->ViewValue = ew_FormatDateTime($CPDTrainingMaterial->DateExpires->ViewValue, 5); $CPDTrainingMaterial->DateExpires->CssStyle = ""; $CPDTrainingMaterial->DateExpires->CssClass = ""; $CPDTrainingMaterial->DateExpires->ViewCustomAttributes = ""; // Certification if (strval($CPDTrainingMaterial->Certification->CurrentValue) <> "") { switch ($CPDTrainingMaterial->Certification->CurrentValue) { case "1": $CPDTrainingMaterial->Certification->ViewValue = "Yes"; break; case "0": $CPDTrainingMaterial->Certification->ViewValue = "No"; break; default: $CPDTrainingMaterial->Certification->ViewValue = $CPDTrainingMaterial->Certification->CurrentValue; } } else { $CPDTrainingMaterial->Certification->ViewValue = NULL; } $CPDTrainingMaterial->Certification->CssStyle = ""; $CPDTrainingMaterial->Certification->CssClass = ""; $CPDTrainingMaterial->Certification->ViewCustomAttributes = ""; // CPD $CPDTrainingMaterial->CPD->ViewValue = $CPDTrainingMaterial->CPD->CurrentValue; $CPDTrainingMaterial->CPD->CssStyle = ""; $CPDTrainingMaterial->CPD->CssClass = ""; $CPDTrainingMaterial->CPD->ViewCustomAttributes = ""; // InvoiceCode $CPDTrainingMaterial->InvoiceCode->ViewValue = $CPDTrainingMaterial->InvoiceCode->CurrentValue; $CPDTrainingMaterial->InvoiceCode->CssStyle = ""; $CPDTrainingMaterial->InvoiceCode->CssClass = ""; $CPDTrainingMaterial->InvoiceCode->ViewCustomAttributes = ""; // InvoiceNumber $CPDTrainingMaterial->InvoiceNumber->ViewValue = $CPDTrainingMaterial->InvoiceNumber->CurrentValue; $CPDTrainingMaterial->InvoiceNumber->CssStyle = ""; $CPDTrainingMaterial->InvoiceNumber->CssClass = ""; $CPDTrainingMaterial->InvoiceNumber->ViewCustomAttributes = ""; // Cost $CPDTrainingMaterial->Cost->ViewValue = $CPDTrainingMaterial->Cost->CurrentValue; $CPDTrainingMaterial->Cost->CssStyle = ""; $CPDTrainingMaterial->Cost->CssClass = ""; $CPDTrainingMaterial->Cost->ViewCustomAttributes = ""; // CostToDelegate $CPDTrainingMaterial->CostToDelegate->ViewValue = $CPDTrainingMaterial->CostToDelegate->CurrentValue; $CPDTrainingMaterial->CostToDelegate->CssStyle = ""; $CPDTrainingMaterial->CostToDelegate->CssClass = ""; $CPDTrainingMaterial->CostToDelegate->ViewCustomAttributes = ""; // DepositAmt $CPDTrainingMaterial->DepositAmt->ViewValue = $CPDTrainingMaterial->DepositAmt->CurrentValue; $CPDTrainingMaterial->DepositAmt->CssStyle = ""; $CPDTrainingMaterial->DepositAmt->CssClass = ""; $CPDTrainingMaterial->DepositAmt->ViewCustomAttributes = ""; // InvoiceFile if (!ew_Empty($CPDTrainingMaterial->InvoiceFile->Upload->DbValue)) { $CPDTrainingMaterial->InvoiceFile->ViewValue = $CPDTrainingMaterial->InvoiceFile->Upload->DbValue; } else { $CPDTrainingMaterial->InvoiceFile->ViewValue = ""; } $CPDTrainingMaterial->InvoiceFile->CssStyle = ""; $CPDTrainingMaterial->InvoiceFile->CssClass = ""; $CPDTrainingMaterial->InvoiceFile->ViewCustomAttributes = ""; // InvoiceDate $CPDTrainingMaterial->InvoiceDate->ViewValue = $CPDTrainingMaterial->InvoiceDate->CurrentValue; $CPDTrainingMaterial->InvoiceDate->ViewValue = ew_FormatDateTime($CPDTrainingMaterial->InvoiceDate->ViewValue, 5); $CPDTrainingMaterial->InvoiceDate->CssStyle = ""; $CPDTrainingMaterial->InvoiceDate->CssClass = ""; $CPDTrainingMaterial->InvoiceDate->ViewCustomAttributes = ""; // DatePaid $CPDTrainingMaterial->DatePaid->ViewValue = $CPDTrainingMaterial->DatePaid->CurrentValue; $CPDTrainingMaterial->DatePaid->ViewValue = ew_FormatDateTime($CPDTrainingMaterial->DatePaid->ViewValue, 5); $CPDTrainingMaterial->DatePaid->CssStyle = ""; $CPDTrainingMaterial->DatePaid->CssClass = ""; $CPDTrainingMaterial->DatePaid->ViewCustomAttributes = ""; // ProofOfPayment if (!ew_Empty($CPDTrainingMaterial->ProofOfPayment->Upload->DbValue)) { $CPDTrainingMaterial->ProofOfPayment->ViewValue = $CPDTrainingMaterial->ProofOfPayment->Upload->DbValue; } else { $CPDTrainingMaterial->ProofOfPayment->ViewValue = ""; } $CPDTrainingMaterial->ProofOfPayment->CssStyle = ""; $CPDTrainingMaterial->ProofOfPayment->CssClass = ""; $CPDTrainingMaterial->ProofOfPayment->ViewCustomAttributes = ""; // EvaluatorID if (strval($CPDTrainingMaterial->EvaluatorID->CurrentValue) <> "") { $sFilterWrk = "`CPDAssessorID` = " . ew_AdjustSql($CPDTrainingMaterial->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 $CPDTrainingMaterial->EvaluatorID->ViewValue = $rswrk->fields('Surname'); $CPDTrainingMaterial->EvaluatorID->ViewValue .= ew_ValueSeparator(0) . $rswrk->fields('FirstName'); $rswrk->Close(); } else { $CPDTrainingMaterial->EvaluatorID->ViewValue = $CPDTrainingMaterial->EvaluatorID->CurrentValue; } } else { $CPDTrainingMaterial->EvaluatorID->ViewValue = NULL; } $CPDTrainingMaterial->EvaluatorID->CssStyle = ""; $CPDTrainingMaterial->EvaluatorID->CssClass = ""; $CPDTrainingMaterial->EvaluatorID->ViewCustomAttributes = ""; // EvaluatorID2 if (strval($CPDTrainingMaterial->EvaluatorID2->CurrentValue) <> "") { $sFilterWrk = "`CPDAssessorID` = " . ew_AdjustSql($CPDTrainingMaterial->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 $CPDTrainingMaterial->EvaluatorID2->ViewValue = $rswrk->fields('Surname'); $CPDTrainingMaterial->EvaluatorID2->ViewValue .= ew_ValueSeparator(0) . $rswrk->fields('FirstName'); $rswrk->Close(); } else { $CPDTrainingMaterial->EvaluatorID2->ViewValue = $CPDTrainingMaterial->EvaluatorID2->CurrentValue; } } else { $CPDTrainingMaterial->EvaluatorID2->ViewValue = NULL; } $CPDTrainingMaterial->EvaluatorID2->CssStyle = ""; $CPDTrainingMaterial->EvaluatorID2->CssClass = ""; $CPDTrainingMaterial->EvaluatorID2->ViewCustomAttributes = ""; // EvaluatorID3 if (strval($CPDTrainingMaterial->EvaluatorID3->CurrentValue) <> "") { $sFilterWrk = "`CPDAssessorID` = " . ew_AdjustSql($CPDTrainingMaterial->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 $CPDTrainingMaterial->EvaluatorID3->ViewValue = $rswrk->fields('Surname'); $CPDTrainingMaterial->EvaluatorID3->ViewValue .= ew_ValueSeparator(0) . $rswrk->fields('FirstName'); $rswrk->Close(); } else { $CPDTrainingMaterial->EvaluatorID3->ViewValue = $CPDTrainingMaterial->EvaluatorID3->CurrentValue; } } else { $CPDTrainingMaterial->EvaluatorID3->ViewValue = NULL; } $CPDTrainingMaterial->EvaluatorID3->CssStyle = ""; $CPDTrainingMaterial->EvaluatorID3->CssClass = ""; $CPDTrainingMaterial->EvaluatorID3->ViewCustomAttributes = ""; // EvaluatorFee if (strval($CPDTrainingMaterial->EvaluatorFee->CurrentValue) <> "") { switch ($CPDTrainingMaterial->EvaluatorFee->CurrentValue) { case "1": $CPDTrainingMaterial->EvaluatorFee->ViewValue = "Yes"; break; case "0": $CPDTrainingMaterial->EvaluatorFee->ViewValue = "No"; break; default: $CPDTrainingMaterial->EvaluatorFee->ViewValue = $CPDTrainingMaterial->EvaluatorFee->CurrentValue; } } else { $CPDTrainingMaterial->EvaluatorFee->ViewValue = NULL; } $CPDTrainingMaterial->EvaluatorFee->CssStyle = ""; $CPDTrainingMaterial->EvaluatorFee->CssClass = ""; $CPDTrainingMaterial->EvaluatorFee->ViewCustomAttributes = ""; // EvaluatorFeeAmount $CPDTrainingMaterial->EvaluatorFeeAmount->ViewValue = $CPDTrainingMaterial->EvaluatorFeeAmount->CurrentValue; $CPDTrainingMaterial->EvaluatorFeeAmount->CssStyle = ""; $CPDTrainingMaterial->EvaluatorFeeAmount->CssClass = ""; $CPDTrainingMaterial->EvaluatorFeeAmount->ViewCustomAttributes = ""; // EvaluatorFeeDate $CPDTrainingMaterial->EvaluatorFeeDate->ViewValue = $CPDTrainingMaterial->EvaluatorFeeDate->CurrentValue; $CPDTrainingMaterial->EvaluatorFeeDate->ViewValue = ew_FormatDateTime($CPDTrainingMaterial->EvaluatorFeeDate->ViewValue, 5); $CPDTrainingMaterial->EvaluatorFeeDate->CssStyle = ""; $CPDTrainingMaterial->EvaluatorFeeDate->CssClass = ""; $CPDTrainingMaterial->EvaluatorFeeDate->ViewCustomAttributes = ""; // EvaluatorInvoice if (!ew_Empty($CPDTrainingMaterial->EvaluatorInvoice->Upload->DbValue)) { $CPDTrainingMaterial->EvaluatorInvoice->ViewValue = $CPDTrainingMaterial->EvaluatorInvoice->Upload->DbValue; } else { $CPDTrainingMaterial->EvaluatorInvoice->ViewValue = ""; } $CPDTrainingMaterial->EvaluatorInvoice->CssStyle = ""; $CPDTrainingMaterial->EvaluatorInvoice->CssClass = ""; $CPDTrainingMaterial->EvaluatorInvoice->ViewCustomAttributes = ""; // EvaluatorTimesheet if (!ew_Empty($CPDTrainingMaterial->EvaluatorTimesheet->Upload->DbValue)) { $CPDTrainingMaterial->EvaluatorTimesheet->ViewValue = $CPDTrainingMaterial->EvaluatorTimesheet->Upload->DbValue; } else { $CPDTrainingMaterial->EvaluatorTimesheet->ViewValue = ""; } $CPDTrainingMaterial->EvaluatorTimesheet->CssStyle = ""; $CPDTrainingMaterial->EvaluatorTimesheet->CssClass = ""; $CPDTrainingMaterial->EvaluatorTimesheet->ViewCustomAttributes = ""; // StartDate $CPDTrainingMaterial->StartDate->ViewValue = $CPDTrainingMaterial->StartDate->CurrentValue; $CPDTrainingMaterial->StartDate->ViewValue = ew_FormatDateTime($CPDTrainingMaterial->StartDate->ViewValue, 5); $CPDTrainingMaterial->StartDate->CssStyle = ""; $CPDTrainingMaterial->StartDate->CssClass = ""; $CPDTrainingMaterial->StartDate->ViewCustomAttributes = ""; // Other_Validator $CPDTrainingMaterial->Other_Validator->ViewValue = $CPDTrainingMaterial->Other_Validator->CurrentValue; $CPDTrainingMaterial->Other_Validator->CssStyle = ""; $CPDTrainingMaterial->Other_Validator->CssClass = ""; $CPDTrainingMaterial->Other_Validator->ViewCustomAttributes = ""; // Provider_URL $CPDTrainingMaterial->Provider_URL->ViewValue = $CPDTrainingMaterial->Provider_URL->CurrentValue; $CPDTrainingMaterial->Provider_URL->CssStyle = ""; $CPDTrainingMaterial->Provider_URL->CssClass = ""; $CPDTrainingMaterial->Provider_URL->ViewCustomAttributes = ""; // Category_Reg $CPDTrainingMaterial->Category_Reg->ViewValue = $CPDTrainingMaterial->Category_Reg->CurrentValue; $CPDTrainingMaterial->Category_Reg->CssStyle = ""; $CPDTrainingMaterial->Category_Reg->CssClass = ""; $CPDTrainingMaterial->Category_Reg->ViewCustomAttributes = ""; // Discipline $CPDTrainingMaterial->Discipline->ViewValue = $CPDTrainingMaterial->Discipline->CurrentValue; $CPDTrainingMaterial->Discipline->CssStyle = ""; $CPDTrainingMaterial->Discipline->CssClass = ""; $CPDTrainingMaterial->Discipline->ViewCustomAttributes = ""; // Sub_Discipline $CPDTrainingMaterial->Sub_Discipline->ViewValue = $CPDTrainingMaterial->Sub_Discipline->CurrentValue; $CPDTrainingMaterial->Sub_Discipline->CssStyle = ""; $CPDTrainingMaterial->Sub_Discipline->CssClass = ""; $CPDTrainingMaterial->Sub_Discipline->ViewCustomAttributes = ""; // Activity_Nature $CPDTrainingMaterial->Activity_Nature->ViewValue = $CPDTrainingMaterial->Activity_Nature->CurrentValue; $CPDTrainingMaterial->Activity_Nature->CssStyle = ""; $CPDTrainingMaterial->Activity_Nature->CssClass = ""; $CPDTrainingMaterial->Activity_Nature->ViewCustomAttributes = ""; // Instances if (strval($CPDTrainingMaterial->Instances->CurrentValue) <> "") { switch ($CPDTrainingMaterial->Instances->CurrentValue) { case "Single": $CPDTrainingMaterial->Instances->ViewValue = "Single"; break; case "Multiple": $CPDTrainingMaterial->Instances->ViewValue = "Multiple"; break; default: $CPDTrainingMaterial->Instances->ViewValue = $CPDTrainingMaterial->Instances->CurrentValue; } } else { $CPDTrainingMaterial->Instances->ViewValue = NULL; } $CPDTrainingMaterial->Instances->CssStyle = ""; $CPDTrainingMaterial->Instances->CssClass = ""; $CPDTrainingMaterial->Instances->ViewCustomAttributes = ""; // RemoteUpload $CPDTrainingMaterial->RemoteUpload->ViewValue = $CPDTrainingMaterial->RemoteUpload->CurrentValue; $CPDTrainingMaterial->RemoteUpload->CssStyle = ""; $CPDTrainingMaterial->RemoteUpload->CssClass = ""; $CPDTrainingMaterial->RemoteUpload->ViewCustomAttributes = ""; // LocalUpload $CPDTrainingMaterial->LocalUpload->ViewValue = $CPDTrainingMaterial->LocalUpload->CurrentValue; $CPDTrainingMaterial->LocalUpload->CssStyle = ""; $CPDTrainingMaterial->LocalUpload->CssClass = ""; $CPDTrainingMaterial->LocalUpload->ViewCustomAttributes = ""; // AssessmentDoc if (!ew_Empty($CPDTrainingMaterial->AssessmentDoc->Upload->DbValue)) { $CPDTrainingMaterial->AssessmentDoc->ViewValue = $CPDTrainingMaterial->AssessmentDoc->Upload->DbValue; } else { $CPDTrainingMaterial->AssessmentDoc->ViewValue = ""; } $CPDTrainingMaterial->AssessmentDoc->CssStyle = ""; $CPDTrainingMaterial->AssessmentDoc->CssClass = ""; $CPDTrainingMaterial->AssessmentDoc->ViewCustomAttributes = ""; // ResponsiblePersonFirstName $CPDTrainingMaterial->ResponsiblePersonFirstName->ViewValue = $CPDTrainingMaterial->ResponsiblePersonFirstName->CurrentValue; $CPDTrainingMaterial->ResponsiblePersonFirstName->CssStyle = ""; $CPDTrainingMaterial->ResponsiblePersonFirstName->CssClass = ""; $CPDTrainingMaterial->ResponsiblePersonFirstName->ViewCustomAttributes = ""; // ResponsiblePersonLastName $CPDTrainingMaterial->ResponsiblePersonLastName->ViewValue = $CPDTrainingMaterial->ResponsiblePersonLastName->CurrentValue; $CPDTrainingMaterial->ResponsiblePersonLastName->CssStyle = ""; $CPDTrainingMaterial->ResponsiblePersonLastName->CssClass = ""; $CPDTrainingMaterial->ResponsiblePersonLastName->ViewCustomAttributes = ""; // ResponsiblePersonEMailAddress $CPDTrainingMaterial->ResponsiblePersonEMailAddress->ViewValue = $CPDTrainingMaterial->ResponsiblePersonEMailAddress->CurrentValue; $CPDTrainingMaterial->ResponsiblePersonEMailAddress->CssStyle = ""; $CPDTrainingMaterial->ResponsiblePersonEMailAddress->CssClass = ""; $CPDTrainingMaterial->ResponsiblePersonEMailAddress->ViewCustomAttributes = ""; // ResponsiblePersonContactNumber $CPDTrainingMaterial->ResponsiblePersonContactNumber->ViewValue = $CPDTrainingMaterial->ResponsiblePersonContactNumber->CurrentValue; $CPDTrainingMaterial->ResponsiblePersonContactNumber->CssStyle = ""; $CPDTrainingMaterial->ResponsiblePersonContactNumber->CssClass = ""; $CPDTrainingMaterial->ResponsiblePersonContactNumber->ViewCustomAttributes = ""; // ResponsibleVATNumber $CPDTrainingMaterial->ResponsibleVATNumber->ViewValue = $CPDTrainingMaterial->ResponsibleVATNumber->CurrentValue; $CPDTrainingMaterial->ResponsibleVATNumber->CssStyle = ""; $CPDTrainingMaterial->ResponsibleVATNumber->CssClass = ""; $CPDTrainingMaterial->ResponsibleVATNumber->ViewCustomAttributes = ""; // Archived if (strval($CPDTrainingMaterial->Archived->CurrentValue) <> "") { switch ($CPDTrainingMaterial->Archived->CurrentValue) { case "1": $CPDTrainingMaterial->Archived->ViewValue = "Yes"; break; case "0": $CPDTrainingMaterial->Archived->ViewValue = "No"; break; default: $CPDTrainingMaterial->Archived->ViewValue = $CPDTrainingMaterial->Archived->CurrentValue; } } else { $CPDTrainingMaterial->Archived->ViewValue = NULL; } $CPDTrainingMaterial->Archived->CssStyle = ""; $CPDTrainingMaterial->Archived->CssClass = ""; $CPDTrainingMaterial->Archived->ViewCustomAttributes = ""; // Presenter1Title $CPDTrainingMaterial->Presenter1Title->ViewValue = $CPDTrainingMaterial->Presenter1Title->CurrentValue; $CPDTrainingMaterial->Presenter1Title->CssStyle = ""; $CPDTrainingMaterial->Presenter1Title->CssClass = ""; $CPDTrainingMaterial->Presenter1Title->ViewCustomAttributes = ""; // Presenter1FirstName $CPDTrainingMaterial->Presenter1FirstName->ViewValue = $CPDTrainingMaterial->Presenter1FirstName->CurrentValue; $CPDTrainingMaterial->Presenter1FirstName->CssStyle = ""; $CPDTrainingMaterial->Presenter1FirstName->CssClass = ""; $CPDTrainingMaterial->Presenter1FirstName->ViewCustomAttributes = ""; // Presenter1Surname $CPDTrainingMaterial->Presenter1Surname->ViewValue = $CPDTrainingMaterial->Presenter1Surname->CurrentValue; $CPDTrainingMaterial->Presenter1Surname->CssStyle = ""; $CPDTrainingMaterial->Presenter1Surname->CssClass = ""; $CPDTrainingMaterial->Presenter1Surname->ViewCustomAttributes = ""; // Presenter1Phone $CPDTrainingMaterial->Presenter1Phone->ViewValue = $CPDTrainingMaterial->Presenter1Phone->CurrentValue; $CPDTrainingMaterial->Presenter1Phone->CssStyle = ""; $CPDTrainingMaterial->Presenter1Phone->CssClass = ""; $CPDTrainingMaterial->Presenter1Phone->ViewCustomAttributes = ""; // Presenter1Email $CPDTrainingMaterial->Presenter1Email->ViewValue = $CPDTrainingMaterial->Presenter1Email->CurrentValue; $CPDTrainingMaterial->Presenter1Email->CssStyle = ""; $CPDTrainingMaterial->Presenter1Email->CssClass = ""; $CPDTrainingMaterial->Presenter1Email->ViewCustomAttributes = ""; // Presenter1ID $CPDTrainingMaterial->Presenter1ID->ViewValue = $CPDTrainingMaterial->Presenter1ID->CurrentValue; $CPDTrainingMaterial->Presenter1ID->CssStyle = ""; $CPDTrainingMaterial->Presenter1ID->CssClass = ""; $CPDTrainingMaterial->Presenter1ID->ViewCustomAttributes = ""; // Presenter1CV if (!ew_Empty($CPDTrainingMaterial->Presenter1CV->Upload->DbValue)) { $CPDTrainingMaterial->Presenter1CV->ViewValue = $CPDTrainingMaterial->Presenter1CV->Upload->DbValue; } else { $CPDTrainingMaterial->Presenter1CV->ViewValue = ""; } $CPDTrainingMaterial->Presenter1CV->CssStyle = ""; $CPDTrainingMaterial->Presenter1CV->CssClass = ""; $CPDTrainingMaterial->Presenter1CV->ViewCustomAttributes = ""; // Presenter1SLA if (!ew_Empty($CPDTrainingMaterial->Presenter1SLA->Upload->DbValue)) { $CPDTrainingMaterial->Presenter1SLA->ViewValue = $CPDTrainingMaterial->Presenter1SLA->Upload->DbValue; } else { $CPDTrainingMaterial->Presenter1SLA->ViewValue = ""; } $CPDTrainingMaterial->Presenter1SLA->CssStyle = ""; $CPDTrainingMaterial->Presenter1SLA->CssClass = ""; $CPDTrainingMaterial->Presenter1SLA->ViewCustomAttributes = ""; // Presenter1IDDoc if (!ew_Empty($CPDTrainingMaterial->Presenter1IDDoc->Upload->DbValue)) { $CPDTrainingMaterial->Presenter1IDDoc->ViewValue = $CPDTrainingMaterial->Presenter1IDDoc->Upload->DbValue; } else { $CPDTrainingMaterial->Presenter1IDDoc->ViewValue = ""; } $CPDTrainingMaterial->Presenter1IDDoc->CssStyle = ""; $CPDTrainingMaterial->Presenter1IDDoc->CssClass = ""; $CPDTrainingMaterial->Presenter1IDDoc->ViewCustomAttributes = ""; // Presenter2Title $CPDTrainingMaterial->Presenter2Title->ViewValue = $CPDTrainingMaterial->Presenter2Title->CurrentValue; $CPDTrainingMaterial->Presenter2Title->CssStyle = ""; $CPDTrainingMaterial->Presenter2Title->CssClass = ""; $CPDTrainingMaterial->Presenter2Title->ViewCustomAttributes = ""; // Presenter2FirstName $CPDTrainingMaterial->Presenter2FirstName->ViewValue = $CPDTrainingMaterial->Presenter2FirstName->CurrentValue; $CPDTrainingMaterial->Presenter2FirstName->CssStyle = ""; $CPDTrainingMaterial->Presenter2FirstName->CssClass = ""; $CPDTrainingMaterial->Presenter2FirstName->ViewCustomAttributes = ""; // Presenter2Surname $CPDTrainingMaterial->Presenter2Surname->ViewValue = $CPDTrainingMaterial->Presenter2Surname->CurrentValue; $CPDTrainingMaterial->Presenter2Surname->CssStyle = ""; $CPDTrainingMaterial->Presenter2Surname->CssClass = ""; $CPDTrainingMaterial->Presenter2Surname->ViewCustomAttributes = ""; // Presenter2Phone $CPDTrainingMaterial->Presenter2Phone->ViewValue = $CPDTrainingMaterial->Presenter2Phone->CurrentValue; $CPDTrainingMaterial->Presenter2Phone->CssStyle = ""; $CPDTrainingMaterial->Presenter2Phone->CssClass = ""; $CPDTrainingMaterial->Presenter2Phone->ViewCustomAttributes = ""; // Presenter2Email $CPDTrainingMaterial->Presenter2Email->ViewValue = $CPDTrainingMaterial->Presenter2Email->CurrentValue; $CPDTrainingMaterial->Presenter2Email->CssStyle = ""; $CPDTrainingMaterial->Presenter2Email->CssClass = ""; $CPDTrainingMaterial->Presenter2Email->ViewCustomAttributes = ""; // Presenter2ID $CPDTrainingMaterial->Presenter2ID->ViewValue = $CPDTrainingMaterial->Presenter2ID->CurrentValue; $CPDTrainingMaterial->Presenter2ID->CssStyle = ""; $CPDTrainingMaterial->Presenter2ID->CssClass = ""; $CPDTrainingMaterial->Presenter2ID->ViewCustomAttributes = ""; // Presenter2CV if (!ew_Empty($CPDTrainingMaterial->Presenter2CV->Upload->DbValue)) { $CPDTrainingMaterial->Presenter2CV->ViewValue = $CPDTrainingMaterial->Presenter2CV->Upload->DbValue; } else { $CPDTrainingMaterial->Presenter2CV->ViewValue = ""; } $CPDTrainingMaterial->Presenter2CV->CssStyle = ""; $CPDTrainingMaterial->Presenter2CV->CssClass = ""; $CPDTrainingMaterial->Presenter2CV->ViewCustomAttributes = ""; // Presenter2SLA if (!ew_Empty($CPDTrainingMaterial->Presenter2SLA->Upload->DbValue)) { $CPDTrainingMaterial->Presenter2SLA->ViewValue = $CPDTrainingMaterial->Presenter2SLA->Upload->DbValue; } else { $CPDTrainingMaterial->Presenter2SLA->ViewValue = ""; } $CPDTrainingMaterial->Presenter2SLA->CssStyle = ""; $CPDTrainingMaterial->Presenter2SLA->CssClass = ""; $CPDTrainingMaterial->Presenter2SLA->ViewCustomAttributes = ""; // Presenter2IDDoc if (!ew_Empty($CPDTrainingMaterial->Presenter2IDDoc->Upload->DbValue)) { $CPDTrainingMaterial->Presenter2IDDoc->ViewValue = $CPDTrainingMaterial->Presenter2IDDoc->Upload->DbValue; } else { $CPDTrainingMaterial->Presenter2IDDoc->ViewValue = ""; } $CPDTrainingMaterial->Presenter2IDDoc->CssStyle = ""; $CPDTrainingMaterial->Presenter2IDDoc->CssClass = ""; $CPDTrainingMaterial->Presenter2IDDoc->ViewCustomAttributes = ""; // Presenter3Title $CPDTrainingMaterial->Presenter3Title->ViewValue = $CPDTrainingMaterial->Presenter3Title->CurrentValue; $CPDTrainingMaterial->Presenter3Title->CssStyle = ""; $CPDTrainingMaterial->Presenter3Title->CssClass = ""; $CPDTrainingMaterial->Presenter3Title->ViewCustomAttributes = ""; // Presenter3FirstName $CPDTrainingMaterial->Presenter3FirstName->ViewValue = $CPDTrainingMaterial->Presenter3FirstName->CurrentValue; $CPDTrainingMaterial->Presenter3FirstName->CssStyle = ""; $CPDTrainingMaterial->Presenter3FirstName->CssClass = ""; $CPDTrainingMaterial->Presenter3FirstName->ViewCustomAttributes = ""; // Presenter3Surname $CPDTrainingMaterial->Presenter3Surname->ViewValue = $CPDTrainingMaterial->Presenter3Surname->CurrentValue; $CPDTrainingMaterial->Presenter3Surname->CssStyle = ""; $CPDTrainingMaterial->Presenter3Surname->CssClass = ""; $CPDTrainingMaterial->Presenter3Surname->ViewCustomAttributes = ""; // Presenter3Phone $CPDTrainingMaterial->Presenter3Phone->ViewValue = $CPDTrainingMaterial->Presenter3Phone->CurrentValue; $CPDTrainingMaterial->Presenter3Phone->CssStyle = ""; $CPDTrainingMaterial->Presenter3Phone->CssClass = ""; $CPDTrainingMaterial->Presenter3Phone->ViewCustomAttributes = ""; // Presenter3Email $CPDTrainingMaterial->Presenter3Email->ViewValue = $CPDTrainingMaterial->Presenter3Email->CurrentValue; $CPDTrainingMaterial->Presenter3Email->CssStyle = ""; $CPDTrainingMaterial->Presenter3Email->CssClass = ""; $CPDTrainingMaterial->Presenter3Email->ViewCustomAttributes = ""; // Presenter3ID $CPDTrainingMaterial->Presenter3ID->ViewValue = $CPDTrainingMaterial->Presenter3ID->CurrentValue; $CPDTrainingMaterial->Presenter3ID->CssStyle = ""; $CPDTrainingMaterial->Presenter3ID->CssClass = ""; $CPDTrainingMaterial->Presenter3ID->ViewCustomAttributes = ""; // Presenter3CV if (!ew_Empty($CPDTrainingMaterial->Presenter3CV->Upload->DbValue)) { $CPDTrainingMaterial->Presenter3CV->ViewValue = $CPDTrainingMaterial->Presenter3CV->Upload->DbValue; } else { $CPDTrainingMaterial->Presenter3CV->ViewValue = ""; } $CPDTrainingMaterial->Presenter3CV->CssStyle = ""; $CPDTrainingMaterial->Presenter3CV->CssClass = ""; $CPDTrainingMaterial->Presenter3CV->ViewCustomAttributes = ""; // Presenter3SLA if (!ew_Empty($CPDTrainingMaterial->Presenter3SLA->Upload->DbValue)) { $CPDTrainingMaterial->Presenter3SLA->ViewValue = $CPDTrainingMaterial->Presenter3SLA->Upload->DbValue; } else { $CPDTrainingMaterial->Presenter3SLA->ViewValue = ""; } $CPDTrainingMaterial->Presenter3SLA->CssStyle = ""; $CPDTrainingMaterial->Presenter3SLA->CssClass = ""; $CPDTrainingMaterial->Presenter3SLA->ViewCustomAttributes = ""; // Presenter3IDDoc if (!ew_Empty($CPDTrainingMaterial->Presenter3IDDoc->Upload->DbValue)) { $CPDTrainingMaterial->Presenter3IDDoc->ViewValue = $CPDTrainingMaterial->Presenter3IDDoc->Upload->DbValue; } else { $CPDTrainingMaterial->Presenter3IDDoc->ViewValue = ""; } $CPDTrainingMaterial->Presenter3IDDoc->CssStyle = ""; $CPDTrainingMaterial->Presenter3IDDoc->CssClass = ""; $CPDTrainingMaterial->Presenter3IDDoc->ViewCustomAttributes = ""; // NumReminders $CPDTrainingMaterial->NumReminders->ViewValue = $CPDTrainingMaterial->NumReminders->CurrentValue; $CPDTrainingMaterial->NumReminders->CssStyle = ""; $CPDTrainingMaterial->NumReminders->CssClass = ""; $CPDTrainingMaterial->NumReminders->ViewCustomAttributes = ""; // LastReminder $CPDTrainingMaterial->LastReminder->ViewValue = $CPDTrainingMaterial->LastReminder->CurrentValue; $CPDTrainingMaterial->LastReminder->ViewValue = ew_FormatDateTime($CPDTrainingMaterial->LastReminder->ViewValue, 5); $CPDTrainingMaterial->LastReminder->CssStyle = ""; $CPDTrainingMaterial->LastReminder->CssClass = ""; $CPDTrainingMaterial->LastReminder->ViewCustomAttributes = ""; // DateCreated $CPDTrainingMaterial->DateCreated->ViewValue = $CPDTrainingMaterial->DateCreated->CurrentValue; $CPDTrainingMaterial->DateCreated->ViewValue = ew_FormatDateTime($CPDTrainingMaterial->DateCreated->ViewValue, 5); $CPDTrainingMaterial->DateCreated->CssStyle = ""; $CPDTrainingMaterial->DateCreated->CssClass = ""; $CPDTrainingMaterial->DateCreated->ViewCustomAttributes = ""; // ProviderID $CPDTrainingMaterial->ProviderID->HrefValue = ""; $CPDTrainingMaterial->ProviderID->TooltipValue = ""; // Subject $CPDTrainingMaterial->Subject->HrefValue = ""; $CPDTrainingMaterial->Subject->TooltipValue = ""; // RenewOrNew $CPDTrainingMaterial->RenewOrNew->HrefValue = ""; $CPDTrainingMaterial->RenewOrNew->TooltipValue = ""; // Status $CPDTrainingMaterial->Status->HrefValue = ""; $CPDTrainingMaterial->Status->TooltipValue = ""; // AccredNum $CPDTrainingMaterial->AccredNum->HrefValue = ""; $CPDTrainingMaterial->AccredNum->TooltipValue = ""; // PrevAccredNum $CPDTrainingMaterial->PrevAccredNum->HrefValue = ""; $CPDTrainingMaterial->PrevAccredNum->TooltipValue = ""; // DateApproved $CPDTrainingMaterial->DateApproved->HrefValue = ""; $CPDTrainingMaterial->DateApproved->TooltipValue = ""; // DatePaid $CPDTrainingMaterial->DatePaid->HrefValue = ""; $CPDTrainingMaterial->DatePaid->TooltipValue = ""; // DateCreated $CPDTrainingMaterial->DateCreated->HrefValue = ""; $CPDTrainingMaterial->DateCreated->TooltipValue = ""; } elseif ($CPDTrainingMaterial->RowType == EW_ROWTYPE_SEARCH) { // Search row // ProviderID $CPDTrainingMaterial->ProviderID->EditCustomAttributes = ""; // Subject $CPDTrainingMaterial->Subject->EditCustomAttributes = ""; $CPDTrainingMaterial->Subject->EditValue = ew_HtmlEncode($CPDTrainingMaterial->Subject->AdvancedSearch->SearchValue); // RenewOrNew $CPDTrainingMaterial->RenewOrNew->EditCustomAttributes = ""; $arwrk = array(); $arwrk[] = array("n", "New"); $arwrk[] = array("r", "Renewal"); $CPDTrainingMaterial->RenewOrNew->EditValue = $arwrk; // Status $CPDTrainingMaterial->Status->EditCustomAttributes = ""; $arwrk = array(); $arwrk[] = array("Pending", "Pending"); $arwrk[] = array("Approved", "Approved"); $arwrk[] = array("Declined", "Declined"); $arwrk[] = array("Suspended", "Suspended"); $arwrk[] = array("Discontinued", "Discontinued"); $CPDTrainingMaterial->Status->EditValue = $arwrk; // AccredNum $CPDTrainingMaterial->AccredNum->EditCustomAttributes = ""; $CPDTrainingMaterial->AccredNum->EditValue = ew_HtmlEncode($CPDTrainingMaterial->AccredNum->AdvancedSearch->SearchValue); // PrevAccredNum $CPDTrainingMaterial->PrevAccredNum->EditCustomAttributes = ""; $CPDTrainingMaterial->PrevAccredNum->EditValue = ew_HtmlEncode($CPDTrainingMaterial->PrevAccredNum->AdvancedSearch->SearchValue); // DateApproved $CPDTrainingMaterial->DateApproved->EditCustomAttributes = ""; $CPDTrainingMaterial->DateApproved->EditValue = ew_HtmlEncode(ew_FormatDateTime(ew_UnFormatDateTime($CPDTrainingMaterial->DateApproved->AdvancedSearch->SearchValue, 5), 5)); $CPDTrainingMaterial->DateApproved->EditCustomAttributes = ""; $CPDTrainingMaterial->DateApproved->EditValue2 = ew_HtmlEncode(ew_FormatDateTime(ew_UnFormatDateTime($CPDTrainingMaterial->DateApproved->AdvancedSearch->SearchValue2, 5), 5)); // DatePaid $CPDTrainingMaterial->DatePaid->EditCustomAttributes = ""; $CPDTrainingMaterial->DatePaid->EditValue = ew_HtmlEncode(ew_FormatDateTime(ew_UnFormatDateTime($CPDTrainingMaterial->DatePaid->AdvancedSearch->SearchValue, 5), 5)); // DateCreated $CPDTrainingMaterial->DateCreated->EditCustomAttributes = ""; $CPDTrainingMaterial->DateCreated->EditValue = ew_HtmlEncode(ew_FormatDateTime(ew_UnFormatDateTime($CPDTrainingMaterial->DateCreated->AdvancedSearch->SearchValue, 5), 5)); } // Call Row Rendered event if ($CPDTrainingMaterial->RowType <> EW_ROWTYPE_AGGREGATEINIT) $CPDTrainingMaterial->Row_Rendered(); } // Validate search function ValidateSearch() { global $gsSearchError, $CPDTrainingMaterial; // Initialize $gsSearchError = ""; // Check if validation required if (!EW_SERVER_VALIDATE) return TRUE; if (!ew_CheckDate($CPDTrainingMaterial->DateApproved->AdvancedSearch->SearchValue)) { if ($gsSearchError <> "") $gsSearchError .= "<br>"; $gsSearchError .= $CPDTrainingMaterial->DateApproved->FldErrMsg(); } if (!ew_CheckDate($CPDTrainingMaterial->DateApproved->AdvancedSearch->SearchValue2)) { if ($gsSearchError <> "") $gsSearchError .= "<br>"; $gsSearchError .= $CPDTrainingMaterial->DateApproved->FldErrMsg(); } // Return validate result $ValidateSearch = ($gsSearchError == ""); // Call Form_CustomValidate event $sFormCustomError = ""; $ValidateSearch = $ValidateSearch && $this->Form_CustomValidate($sFormCustomError); if ($sFormCustomError <> "") { if ($gsSearchError <> "") $gsSearchError .= "<br>"; $gsSearchError .= $sFormCustomError; } return $ValidateSearch; } // Load advanced search function LoadAdvancedSearch() { global $CPDTrainingMaterial; $CPDTrainingMaterial->MaterialID->AdvancedSearch->SearchValue = $CPDTrainingMaterial->getAdvancedSearch("x_MaterialID"); $CPDTrainingMaterial->ProviderID->AdvancedSearch->SearchValue = $CPDTrainingMaterial->getAdvancedSearch("x_ProviderID"); $CPDTrainingMaterial->Subject->AdvancedSearch->SearchValue = $CPDTrainingMaterial->getAdvancedSearch("x_Subject"); $CPDTrainingMaterial->RenewOrNew->AdvancedSearch->SearchValue = $CPDTrainingMaterial->getAdvancedSearch("x_RenewOrNew"); $CPDTrainingMaterial->Status->AdvancedSearch->SearchValue = $CPDTrainingMaterial->getAdvancedSearch("x_Status"); $CPDTrainingMaterial->Duration->AdvancedSearch->SearchValue = $CPDTrainingMaterial->getAdvancedSearch("x_Duration"); $CPDTrainingMaterial->DurationUnit->AdvancedSearch->SearchValue = $CPDTrainingMaterial->getAdvancedSearch("x_DurationUnit"); $CPDTrainingMaterial->Level->AdvancedSearch->SearchValue = $CPDTrainingMaterial->getAdvancedSearch("x_Level"); $CPDTrainingMaterial->EventDescription->AdvancedSearch->SearchValue = $CPDTrainingMaterial->getAdvancedSearch("x_EventDescription"); $CPDTrainingMaterial->TrainingManualLink->AdvancedSearch->SearchValue = $CPDTrainingMaterial->getAdvancedSearch("x_TrainingManualLink"); $CPDTrainingMaterial->PresentationLink->AdvancedSearch->SearchValue = $CPDTrainingMaterial->getAdvancedSearch("x_PresentationLink"); $CPDTrainingMaterial->HandOutsLink->AdvancedSearch->SearchValue = $CPDTrainingMaterial->getAdvancedSearch("x_HandOutsLink"); $CPDTrainingMaterial->LearningOutcomes->AdvancedSearch->SearchValue = $CPDTrainingMaterial->getAdvancedSearch("x_LearningOutcomes"); $CPDTrainingMaterial->ModeOfDelivery->AdvancedSearch->SearchValue = $CPDTrainingMaterial->getAdvancedSearch("x_ModeOfDelivery"); $CPDTrainingMaterial->TargetAudience->AdvancedSearch->SearchValue = $CPDTrainingMaterial->getAdvancedSearch("x_TargetAudience"); $CPDTrainingMaterial->Objectives->AdvancedSearch->SearchValue = $CPDTrainingMaterial->getAdvancedSearch("x_Objectives"); $CPDTrainingMaterial->Promotion->AdvancedSearch->SearchValue = $CPDTrainingMaterial->getAdvancedSearch("x_Promotion"); $CPDTrainingMaterial->Motivation->AdvancedSearch->SearchValue = $CPDTrainingMaterial->getAdvancedSearch("x_Motivation"); $CPDTrainingMaterial->AccredNum->AdvancedSearch->SearchValue = $CPDTrainingMaterial->getAdvancedSearch("x_AccredNum"); $CPDTrainingMaterial->PrevAccredNum->AdvancedSearch->SearchValue = $CPDTrainingMaterial->getAdvancedSearch("x_PrevAccredNum"); $CPDTrainingMaterial->DateApproved->AdvancedSearch->SearchValue = $CPDTrainingMaterial->getAdvancedSearch("x_DateApproved"); $CPDTrainingMaterial->DateApproved->AdvancedSearch->SearchValue2 = $CPDTrainingMaterial->getAdvancedSearch("y_DateApproved"); $CPDTrainingMaterial->DateExpires->AdvancedSearch->SearchValue = $CPDTrainingMaterial->getAdvancedSearch("x_DateExpires"); $CPDTrainingMaterial->Certification->AdvancedSearch->SearchValue = $CPDTrainingMaterial->getAdvancedSearch("x_Certification"); $CPDTrainingMaterial->CPD->AdvancedSearch->SearchValue = $CPDTrainingMaterial->getAdvancedSearch("x_CPD"); $CPDTrainingMaterial->InvoiceCode->AdvancedSearch->SearchValue = $CPDTrainingMaterial->getAdvancedSearch("x_InvoiceCode"); $CPDTrainingMaterial->InvoiceNumber->AdvancedSearch->SearchValue = $CPDTrainingMaterial->getAdvancedSearch("x_InvoiceNumber"); $CPDTrainingMaterial->Cost->AdvancedSearch->SearchValue = $CPDTrainingMaterial->getAdvancedSearch("x_Cost"); $CPDTrainingMaterial->CostToDelegate->AdvancedSearch->SearchValue = $CPDTrainingMaterial->getAdvancedSearch("x_CostToDelegate"); $CPDTrainingMaterial->DepositAmt->AdvancedSearch->SearchValue = $CPDTrainingMaterial->getAdvancedSearch("x_DepositAmt"); $CPDTrainingMaterial->InvoiceDate->AdvancedSearch->SearchValue = $CPDTrainingMaterial->getAdvancedSearch("x_InvoiceDate"); $CPDTrainingMaterial->DatePaid->AdvancedSearch->SearchValue = $CPDTrainingMaterial->getAdvancedSearch("x_DatePaid"); $CPDTrainingMaterial->EvaluatorID->AdvancedSearch->SearchValue = $CPDTrainingMaterial->getAdvancedSearch("x_EvaluatorID"); $CPDTrainingMaterial->EvaluatorID2->AdvancedSearch->SearchValue = $CPDTrainingMaterial->getAdvancedSearch("x_EvaluatorID2"); $CPDTrainingMaterial->EvaluatorID3->AdvancedSearch->SearchValue = $CPDTrainingMaterial->getAdvancedSearch("x_EvaluatorID3"); $CPDTrainingMaterial->EvaluatorFee->AdvancedSearch->SearchValue = $CPDTrainingMaterial->getAdvancedSearch("x_EvaluatorFee"); $CPDTrainingMaterial->EvaluatorFeeAmount->AdvancedSearch->SearchValue = $CPDTrainingMaterial->getAdvancedSearch("x_EvaluatorFeeAmount"); $CPDTrainingMaterial->EvaluatorFeeDate->AdvancedSearch->SearchValue = $CPDTrainingMaterial->getAdvancedSearch("x_EvaluatorFeeDate"); $CPDTrainingMaterial->StartDate->AdvancedSearch->SearchValue = $CPDTrainingMaterial->getAdvancedSearch("x_StartDate"); $CPDTrainingMaterial->Other_Validator->AdvancedSearch->SearchValue = $CPDTrainingMaterial->getAdvancedSearch("x_Other_Validator"); $CPDTrainingMaterial->Provider_URL->AdvancedSearch->SearchValue = $CPDTrainingMaterial->getAdvancedSearch("x_Provider_URL"); $CPDTrainingMaterial->Category_Reg->AdvancedSearch->SearchValue = $CPDTrainingMaterial->getAdvancedSearch("x_Category_Reg"); $CPDTrainingMaterial->Discipline->AdvancedSearch->SearchValue = $CPDTrainingMaterial->getAdvancedSearch("x_Discipline"); $CPDTrainingMaterial->Sub_Discipline->AdvancedSearch->SearchValue = $CPDTrainingMaterial->getAdvancedSearch("x_Sub_Discipline"); $CPDTrainingMaterial->Activity_Nature->AdvancedSearch->SearchValue = $CPDTrainingMaterial->getAdvancedSearch("x_Activity_Nature"); $CPDTrainingMaterial->Instances->AdvancedSearch->SearchValue = $CPDTrainingMaterial->getAdvancedSearch("x_Instances"); $CPDTrainingMaterial->LocalUpload->AdvancedSearch->SearchValue = $CPDTrainingMaterial->getAdvancedSearch("x_LocalUpload"); $CPDTrainingMaterial->ResponsiblePersonFirstName->AdvancedSearch->SearchValue = $CPDTrainingMaterial->getAdvancedSearch("x_ResponsiblePersonFirstName"); $CPDTrainingMaterial->ResponsiblePersonLastName->AdvancedSearch->SearchValue = $CPDTrainingMaterial->getAdvancedSearch("x_ResponsiblePersonLastName"); $CPDTrainingMaterial->ResponsiblePersonEMailAddress->AdvancedSearch->SearchValue = $CPDTrainingMaterial->getAdvancedSearch("x_ResponsiblePersonEMailAddress"); $CPDTrainingMaterial->ResponsibleBillingAddress->AdvancedSearch->SearchValue = $CPDTrainingMaterial->getAdvancedSearch("x_ResponsibleBillingAddress"); $CPDTrainingMaterial->ResponsiblePersonContactNumber->AdvancedSearch->SearchValue = $CPDTrainingMaterial->getAdvancedSearch("x_ResponsiblePersonContactNumber"); $CPDTrainingMaterial->ResponsibleVATNumber->AdvancedSearch->SearchValue = $CPDTrainingMaterial->getAdvancedSearch("x_ResponsibleVATNumber"); $CPDTrainingMaterial->Comments->AdvancedSearch->SearchValue = $CPDTrainingMaterial->getAdvancedSearch("x_Comments"); $CPDTrainingMaterial->Archived->AdvancedSearch->SearchValue = $CPDTrainingMaterial->getAdvancedSearch("x_Archived"); $CPDTrainingMaterial->Presenter1Title->AdvancedSearch->SearchValue = $CPDTrainingMaterial->getAdvancedSearch("x_Presenter1Title"); $CPDTrainingMaterial->Presenter1FirstName->AdvancedSearch->SearchValue = $CPDTrainingMaterial->getAdvancedSearch("x_Presenter1FirstName"); $CPDTrainingMaterial->Presenter1Surname->AdvancedSearch->SearchValue = $CPDTrainingMaterial->getAdvancedSearch("x_Presenter1Surname"); $CPDTrainingMaterial->Presenter1Phone->AdvancedSearch->SearchValue = $CPDTrainingMaterial->getAdvancedSearch("x_Presenter1Phone"); $CPDTrainingMaterial->Presenter1Email->AdvancedSearch->SearchValue = $CPDTrainingMaterial->getAdvancedSearch("x_Presenter1Email"); $CPDTrainingMaterial->Presenter1ID->AdvancedSearch->SearchValue = $CPDTrainingMaterial->getAdvancedSearch("x_Presenter1ID"); $CPDTrainingMaterial->Presenter2Title->AdvancedSearch->SearchValue = $CPDTrainingMaterial->getAdvancedSearch("x_Presenter2Title"); $CPDTrainingMaterial->Presenter2FirstName->AdvancedSearch->SearchValue = $CPDTrainingMaterial->getAdvancedSearch("x_Presenter2FirstName"); $CPDTrainingMaterial->Presenter2Surname->AdvancedSearch->SearchValue = $CPDTrainingMaterial->getAdvancedSearch("x_Presenter2Surname"); $CPDTrainingMaterial->Presenter2Phone->AdvancedSearch->SearchValue = $CPDTrainingMaterial->getAdvancedSearch("x_Presenter2Phone"); $CPDTrainingMaterial->Presenter2Email->AdvancedSearch->SearchValue = $CPDTrainingMaterial->getAdvancedSearch("x_Presenter2Email"); $CPDTrainingMaterial->Presenter2ID->AdvancedSearch->SearchValue = $CPDTrainingMaterial->getAdvancedSearch("x_Presenter2ID"); $CPDTrainingMaterial->Presenter3Title->AdvancedSearch->SearchValue = $CPDTrainingMaterial->getAdvancedSearch("x_Presenter3Title"); $CPDTrainingMaterial->Presenter3FirstName->AdvancedSearch->SearchValue = $CPDTrainingMaterial->getAdvancedSearch("x_Presenter3FirstName"); $CPDTrainingMaterial->Presenter3Surname->AdvancedSearch->SearchValue = $CPDTrainingMaterial->getAdvancedSearch("x_Presenter3Surname"); $CPDTrainingMaterial->Presenter3Phone->AdvancedSearch->SearchValue = $CPDTrainingMaterial->getAdvancedSearch("x_Presenter3Phone"); $CPDTrainingMaterial->Presenter3Email->AdvancedSearch->SearchValue = $CPDTrainingMaterial->getAdvancedSearch("x_Presenter3Email"); $CPDTrainingMaterial->Presenter3ID->AdvancedSearch->SearchValue = $CPDTrainingMaterial->getAdvancedSearch("x_Presenter3ID"); $CPDTrainingMaterial->DateCreated->AdvancedSearch->SearchValue = $CPDTrainingMaterial->getAdvancedSearch("x_DateCreated"); } // Export data in HTML/CSV/Word/Excel/XML/Email format function ExportData() { global $CPDTrainingMaterial; $utf8 = FALSE; $bSelectLimit = EW_SELECT_LIMIT; // Load recordset if ($bSelectLimit) { $this->lTotalRecs = $CPDTrainingMaterial->SelectRecordCount(); } else { if ($rs = $this->LoadRecordset()) $this->lTotalRecs = $rs->RecordCount(); } $this->lStartRec = 1; // Export all if ($CPDTrainingMaterial->ExportAll) { $this->lDisplayRecs = $this->lTotalRecs; $this->lStopRec = $this->lTotalRecs; } else { // Export one page only $this->SetUpStartRec(); // Set up start record position // Set the last record to display if ($this->lDisplayRecs < 0) { $this->lStopRec = $this->lTotalRecs; } else { $this->lStopRec = $this->lStartRec + $this->lDisplayRecs - 1; } } if ($bSelectLimit) $rs = $this->LoadRecordset($this->lStartRec-1, $this->lDisplayRecs); if (!$rs) { header("Content-Type:"); // Remove header header("Content-Disposition:"); $this->ShowMessage(); return; } if ($CPDTrainingMaterial->Export == "xml") { $XmlDoc = new cXMLDocument(EW_XML_ENCODING); $XmlDoc->AddRoot(); } else { $ExportDoc = new cExportDocument($CPDTrainingMaterial, "h"); $ExportDoc->ExportHeader(); if ($ExportDoc->Horizontal) { // Horizontal format, write header $ExportDoc->BeginExportRow(); $ExportDoc->ExportCaption($CPDTrainingMaterial->MaterialID); $ExportDoc->ExportCaption($CPDTrainingMaterial->ProviderID); $ExportDoc->ExportCaption($CPDTrainingMaterial->Subject); $ExportDoc->ExportCaption($CPDTrainingMaterial->RenewOrNew); $ExportDoc->ExportCaption($CPDTrainingMaterial->Status); $ExportDoc->ExportCaption($CPDTrainingMaterial->Duration); $ExportDoc->ExportCaption($CPDTrainingMaterial->DurationUnit); $ExportDoc->ExportCaption($CPDTrainingMaterial->Level); $ExportDoc->ExportCaption($CPDTrainingMaterial->CourseBrochure); $ExportDoc->ExportCaption($CPDTrainingMaterial->ActivityProgramme); $ExportDoc->ExportCaption($CPDTrainingMaterial->LearningOutcomesFile); $ExportDoc->ExportCaption($CPDTrainingMaterial->TrainingManualLink); $ExportDoc->ExportCaption($CPDTrainingMaterial->PresentationLink); $ExportDoc->ExportCaption($CPDTrainingMaterial->HandOutsLink); $ExportDoc->ExportCaption($CPDTrainingMaterial->FeedbackForm); $ExportDoc->ExportCaption($CPDTrainingMaterial->ModeOfDelivery); $ExportDoc->ExportCaption($CPDTrainingMaterial->Promotion); $ExportDoc->ExportCaption($CPDTrainingMaterial->AccredNum); $ExportDoc->ExportCaption($CPDTrainingMaterial->PrevAccredNum); $ExportDoc->ExportCaption($CPDTrainingMaterial->DateApproved); $ExportDoc->ExportCaption($CPDTrainingMaterial->DateExpires); $ExportDoc->ExportCaption($CPDTrainingMaterial->Certification); $ExportDoc->ExportCaption($CPDTrainingMaterial->CPD); $ExportDoc->ExportCaption($CPDTrainingMaterial->InvoiceCode); $ExportDoc->ExportCaption($CPDTrainingMaterial->InvoiceNumber); $ExportDoc->ExportCaption($CPDTrainingMaterial->Cost); $ExportDoc->ExportCaption($CPDTrainingMaterial->CostToDelegate); $ExportDoc->ExportCaption($CPDTrainingMaterial->DepositAmt); $ExportDoc->ExportCaption($CPDTrainingMaterial->InvoiceFile); $ExportDoc->ExportCaption($CPDTrainingMaterial->InvoiceDate); $ExportDoc->ExportCaption($CPDTrainingMaterial->DatePaid); $ExportDoc->ExportCaption($CPDTrainingMaterial->ProofOfPayment); $ExportDoc->ExportCaption($CPDTrainingMaterial->EvaluatorID); $ExportDoc->ExportCaption($CPDTrainingMaterial->EvaluatorID2); $ExportDoc->ExportCaption($CPDTrainingMaterial->EvaluatorID3); $ExportDoc->ExportCaption($CPDTrainingMaterial->EvaluatorFee); $ExportDoc->ExportCaption($CPDTrainingMaterial->EvaluatorFeeAmount); $ExportDoc->ExportCaption($CPDTrainingMaterial->EvaluatorFeeDate); $ExportDoc->ExportCaption($CPDTrainingMaterial->EvaluatorInvoice); $ExportDoc->ExportCaption($CPDTrainingMaterial->EvaluatorTimesheet); $ExportDoc->ExportCaption($CPDTrainingMaterial->StartDate); $ExportDoc->ExportCaption($CPDTrainingMaterial->Other_Validator); $ExportDoc->ExportCaption($CPDTrainingMaterial->Provider_URL); $ExportDoc->ExportCaption($CPDTrainingMaterial->Category_Reg); $ExportDoc->ExportCaption($CPDTrainingMaterial->Discipline); $ExportDoc->ExportCaption($CPDTrainingMaterial->Sub_Discipline); $ExportDoc->ExportCaption($CPDTrainingMaterial->Activity_Nature); $ExportDoc->ExportCaption($CPDTrainingMaterial->Instances); $ExportDoc->ExportCaption($CPDTrainingMaterial->RemoteUpload); $ExportDoc->ExportCaption($CPDTrainingMaterial->LocalUpload); $ExportDoc->ExportCaption($CPDTrainingMaterial->AssessmentDoc); $ExportDoc->ExportCaption($CPDTrainingMaterial->ResponsiblePersonFirstName); $ExportDoc->ExportCaption($CPDTrainingMaterial->ResponsiblePersonLastName); $ExportDoc->ExportCaption($CPDTrainingMaterial->ResponsiblePersonEMailAddress); $ExportDoc->ExportCaption($CPDTrainingMaterial->ResponsiblePersonContactNumber); $ExportDoc->ExportCaption($CPDTrainingMaterial->ResponsibleVATNumber); $ExportDoc->ExportCaption($CPDTrainingMaterial->Archived); $ExportDoc->ExportCaption($CPDTrainingMaterial->Presenter1Title); $ExportDoc->ExportCaption($CPDTrainingMaterial->Presenter1FirstName); $ExportDoc->ExportCaption($CPDTrainingMaterial->Presenter1Surname); $ExportDoc->ExportCaption($CPDTrainingMaterial->Presenter1Phone); $ExportDoc->ExportCaption($CPDTrainingMaterial->Presenter1Email); $ExportDoc->ExportCaption($CPDTrainingMaterial->Presenter1ID); $ExportDoc->ExportCaption($CPDTrainingMaterial->Presenter1CV); $ExportDoc->ExportCaption($CPDTrainingMaterial->Presenter1SLA); $ExportDoc->ExportCaption($CPDTrainingMaterial->Presenter1IDDoc); $ExportDoc->ExportCaption($CPDTrainingMaterial->Presenter2Title); $ExportDoc->ExportCaption($CPDTrainingMaterial->Presenter2FirstName); $ExportDoc->ExportCaption($CPDTrainingMaterial->Presenter2Surname); $ExportDoc->ExportCaption($CPDTrainingMaterial->Presenter2Phone); $ExportDoc->ExportCaption($CPDTrainingMaterial->Presenter2Email); $ExportDoc->ExportCaption($CPDTrainingMaterial->Presenter2ID); $ExportDoc->ExportCaption($CPDTrainingMaterial->Presenter2CV); $ExportDoc->ExportCaption($CPDTrainingMaterial->Presenter2SLA); $ExportDoc->ExportCaption($CPDTrainingMaterial->Presenter2IDDoc); $ExportDoc->ExportCaption($CPDTrainingMaterial->Presenter3Title); $ExportDoc->ExportCaption($CPDTrainingMaterial->Presenter3FirstName); $ExportDoc->ExportCaption($CPDTrainingMaterial->Presenter3Surname); $ExportDoc->ExportCaption($CPDTrainingMaterial->Presenter3Phone); $ExportDoc->ExportCaption($CPDTrainingMaterial->Presenter3Email); $ExportDoc->ExportCaption($CPDTrainingMaterial->Presenter3ID); $ExportDoc->ExportCaption($CPDTrainingMaterial->Presenter3CV); $ExportDoc->ExportCaption($CPDTrainingMaterial->Presenter3SLA); $ExportDoc->ExportCaption($CPDTrainingMaterial->Presenter3IDDoc); $ExportDoc->ExportCaption($CPDTrainingMaterial->NumReminders); $ExportDoc->ExportCaption($CPDTrainingMaterial->LastReminder); $ExportDoc->ExportCaption($CPDTrainingMaterial->DateCreated); $ExportDoc->EndExportRow(); } } // Move to first record $this->lRecCnt = $this->lStartRec - 1; if (!$rs->EOF) { $rs->MoveFirst(); if (!$bSelectLimit && $this->lStartRec > 1) $rs->Move($this->lStartRec - 1); } while (!$rs->EOF && $this->lRecCnt < $this->lStopRec) { $this->lRecCnt++; if (intval($this->lRecCnt) >= intval($this->lStartRec)) { $this->LoadRowValues($rs); // Render row $CPDTrainingMaterial->CssClass = ""; $CPDTrainingMaterial->CssStyle = ""; $CPDTrainingMaterial->RowType = EW_ROWTYPE_VIEW; // Render view $this->RenderRow(); if ($CPDTrainingMaterial->Export == "xml") { $XmlDoc->AddRow(); $XmlDoc->AddField('MaterialID', $CPDTrainingMaterial->MaterialID->ExportValue($CPDTrainingMaterial->Export, $CPDTrainingMaterial->ExportOriginalValue)); $XmlDoc->AddField('ProviderID', $CPDTrainingMaterial->ProviderID->ExportValue($CPDTrainingMaterial->Export, $CPDTrainingMaterial->ExportOriginalValue)); $XmlDoc->AddField('Subject', $CPDTrainingMaterial->Subject->ExportValue($CPDTrainingMaterial->Export, $CPDTrainingMaterial->ExportOriginalValue)); $XmlDoc->AddField('RenewOrNew', $CPDTrainingMaterial->RenewOrNew->ExportValue($CPDTrainingMaterial->Export, $CPDTrainingMaterial->ExportOriginalValue)); $XmlDoc->AddField('Status', $CPDTrainingMaterial->Status->ExportValue($CPDTrainingMaterial->Export, $CPDTrainingMaterial->ExportOriginalValue)); $XmlDoc->AddField('Duration', $CPDTrainingMaterial->Duration->ExportValue($CPDTrainingMaterial->Export, $CPDTrainingMaterial->ExportOriginalValue)); $XmlDoc->AddField('DurationUnit', $CPDTrainingMaterial->DurationUnit->ExportValue($CPDTrainingMaterial->Export, $CPDTrainingMaterial->ExportOriginalValue)); $XmlDoc->AddField('Level', $CPDTrainingMaterial->Level->ExportValue($CPDTrainingMaterial->Export, $CPDTrainingMaterial->ExportOriginalValue)); $XmlDoc->AddField('CourseBrochure', $CPDTrainingMaterial->CourseBrochure->ExportValue($CPDTrainingMaterial->Export, $CPDTrainingMaterial->ExportOriginalValue)); $XmlDoc->AddField('ActivityProgramme', $CPDTrainingMaterial->ActivityProgramme->ExportValue($CPDTrainingMaterial->Export, $CPDTrainingMaterial->ExportOriginalValue)); $XmlDoc->AddField('LearningOutcomesFile', $CPDTrainingMaterial->LearningOutcomesFile->ExportValue($CPDTrainingMaterial->Export, $CPDTrainingMaterial->ExportOriginalValue)); $XmlDoc->AddField('TrainingManualLink', $CPDTrainingMaterial->TrainingManualLink->ExportValue($CPDTrainingMaterial->Export, $CPDTrainingMaterial->ExportOriginalValue)); $XmlDoc->AddField('PresentationLink', $CPDTrainingMaterial->PresentationLink->ExportValue($CPDTrainingMaterial->Export, $CPDTrainingMaterial->ExportOriginalValue)); $XmlDoc->AddField('HandOutsLink', $CPDTrainingMaterial->HandOutsLink->ExportValue($CPDTrainingMaterial->Export, $CPDTrainingMaterial->ExportOriginalValue)); $XmlDoc->AddField('FeedbackForm', $CPDTrainingMaterial->FeedbackForm->ExportValue($CPDTrainingMaterial->Export, $CPDTrainingMaterial->ExportOriginalValue)); $XmlDoc->AddField('ModeOfDelivery', $CPDTrainingMaterial->ModeOfDelivery->ExportValue($CPDTrainingMaterial->Export, $CPDTrainingMaterial->ExportOriginalValue)); $XmlDoc->AddField('Promotion', $CPDTrainingMaterial->Promotion->ExportValue($CPDTrainingMaterial->Export, $CPDTrainingMaterial->ExportOriginalValue)); $XmlDoc->AddField('AccredNum', $CPDTrainingMaterial->AccredNum->ExportValue($CPDTrainingMaterial->Export, $CPDTrainingMaterial->ExportOriginalValue)); $XmlDoc->AddField('PrevAccredNum', $CPDTrainingMaterial->PrevAccredNum->ExportValue($CPDTrainingMaterial->Export, $CPDTrainingMaterial->ExportOriginalValue)); $XmlDoc->AddField('DateApproved', $CPDTrainingMaterial->DateApproved->ExportValue($CPDTrainingMaterial->Export, $CPDTrainingMaterial->ExportOriginalValue)); $XmlDoc->AddField('DateExpires', $CPDTrainingMaterial->DateExpires->ExportValue($CPDTrainingMaterial->Export, $CPDTrainingMaterial->ExportOriginalValue)); $XmlDoc->AddField('Certification', $CPDTrainingMaterial->Certification->ExportValue($CPDTrainingMaterial->Export, $CPDTrainingMaterial->ExportOriginalValue)); $XmlDoc->AddField('CPD', $CPDTrainingMaterial->CPD->ExportValue($CPDTrainingMaterial->Export, $CPDTrainingMaterial->ExportOriginalValue)); $XmlDoc->AddField('InvoiceCode', $CPDTrainingMaterial->InvoiceCode->ExportValue($CPDTrainingMaterial->Export, $CPDTrainingMaterial->ExportOriginalValue)); $XmlDoc->AddField('InvoiceNumber', $CPDTrainingMaterial->InvoiceNumber->ExportValue($CPDTrainingMaterial->Export, $CPDTrainingMaterial->ExportOriginalValue)); $XmlDoc->AddField('Cost', $CPDTrainingMaterial->Cost->ExportValue($CPDTrainingMaterial->Export, $CPDTrainingMaterial->ExportOriginalValue)); $XmlDoc->AddField('CostToDelegate', $CPDTrainingMaterial->CostToDelegate->ExportValue($CPDTrainingMaterial->Export, $CPDTrainingMaterial->ExportOriginalValue)); $XmlDoc->AddField('DepositAmt', $CPDTrainingMaterial->DepositAmt->ExportValue($CPDTrainingMaterial->Export, $CPDTrainingMaterial->ExportOriginalValue)); $XmlDoc->AddField('InvoiceFile', $CPDTrainingMaterial->InvoiceFile->ExportValue($CPDTrainingMaterial->Export, $CPDTrainingMaterial->ExportOriginalValue)); $XmlDoc->AddField('InvoiceDate', $CPDTrainingMaterial->InvoiceDate->ExportValue($CPDTrainingMaterial->Export, $CPDTrainingMaterial->ExportOriginalValue)); $XmlDoc->AddField('DatePaid', $CPDTrainingMaterial->DatePaid->ExportValue($CPDTrainingMaterial->Export, $CPDTrainingMaterial->ExportOriginalValue)); $XmlDoc->AddField('ProofOfPayment', $CPDTrainingMaterial->ProofOfPayment->ExportValue($CPDTrainingMaterial->Export, $CPDTrainingMaterial->ExportOriginalValue)); $XmlDoc->AddField('EvaluatorID', $CPDTrainingMaterial->EvaluatorID->ExportValue($CPDTrainingMaterial->Export, $CPDTrainingMaterial->ExportOriginalValue)); $XmlDoc->AddField('EvaluatorID2', $CPDTrainingMaterial->EvaluatorID2->ExportValue($CPDTrainingMaterial->Export, $CPDTrainingMaterial->ExportOriginalValue)); $XmlDoc->AddField('EvaluatorID3', $CPDTrainingMaterial->EvaluatorID3->ExportValue($CPDTrainingMaterial->Export, $CPDTrainingMaterial->ExportOriginalValue)); $XmlDoc->AddField('EvaluatorFee', $CPDTrainingMaterial->EvaluatorFee->ExportValue($CPDTrainingMaterial->Export, $CPDTrainingMaterial->ExportOriginalValue)); $XmlDoc->AddField('EvaluatorFeeAmount', $CPDTrainingMaterial->EvaluatorFeeAmount->ExportValue($CPDTrainingMaterial->Export, $CPDTrainingMaterial->ExportOriginalValue)); $XmlDoc->AddField('EvaluatorFeeDate', $CPDTrainingMaterial->EvaluatorFeeDate->ExportValue($CPDTrainingMaterial->Export, $CPDTrainingMaterial->ExportOriginalValue)); $XmlDoc->AddField('EvaluatorInvoice', $CPDTrainingMaterial->EvaluatorInvoice->ExportValue($CPDTrainingMaterial->Export, $CPDTrainingMaterial->ExportOriginalValue)); $XmlDoc->AddField('EvaluatorTimesheet', $CPDTrainingMaterial->EvaluatorTimesheet->ExportValue($CPDTrainingMaterial->Export, $CPDTrainingMaterial->ExportOriginalValue)); $XmlDoc->AddField('StartDate', $CPDTrainingMaterial->StartDate->ExportValue($CPDTrainingMaterial->Export, $CPDTrainingMaterial->ExportOriginalValue)); $XmlDoc->AddField('Other_Validator', $CPDTrainingMaterial->Other_Validator->ExportValue($CPDTrainingMaterial->Export, $CPDTrainingMaterial->ExportOriginalValue)); $XmlDoc->AddField('Provider_URL', $CPDTrainingMaterial->Provider_URL->ExportValue($CPDTrainingMaterial->Export, $CPDTrainingMaterial->ExportOriginalValue)); $XmlDoc->AddField('Category_Reg', $CPDTrainingMaterial->Category_Reg->ExportValue($CPDTrainingMaterial->Export, $CPDTrainingMaterial->ExportOriginalValue)); $XmlDoc->AddField('Discipline', $CPDTrainingMaterial->Discipline->ExportValue($CPDTrainingMaterial->Export, $CPDTrainingMaterial->ExportOriginalValue)); $XmlDoc->AddField('Sub_Discipline', $CPDTrainingMaterial->Sub_Discipline->ExportValue($CPDTrainingMaterial->Export, $CPDTrainingMaterial->ExportOriginalValue)); $XmlDoc->AddField('Activity_Nature', $CPDTrainingMaterial->Activity_Nature->ExportValue($CPDTrainingMaterial->Export, $CPDTrainingMaterial->ExportOriginalValue)); $XmlDoc->AddField('Instances', $CPDTrainingMaterial->Instances->ExportValue($CPDTrainingMaterial->Export, $CPDTrainingMaterial->ExportOriginalValue)); $XmlDoc->AddField('RemoteUpload', $CPDTrainingMaterial->RemoteUpload->ExportValue($CPDTrainingMaterial->Export, $CPDTrainingMaterial->ExportOriginalValue)); $XmlDoc->AddField('LocalUpload', $CPDTrainingMaterial->LocalUpload->ExportValue($CPDTrainingMaterial->Export, $CPDTrainingMaterial->ExportOriginalValue)); $XmlDoc->AddField('AssessmentDoc', $CPDTrainingMaterial->AssessmentDoc->ExportValue($CPDTrainingMaterial->Export, $CPDTrainingMaterial->ExportOriginalValue)); $XmlDoc->AddField('ResponsiblePersonFirstName', $CPDTrainingMaterial->ResponsiblePersonFirstName->ExportValue($CPDTrainingMaterial->Export, $CPDTrainingMaterial->ExportOriginalValue)); $XmlDoc->AddField('ResponsiblePersonLastName', $CPDTrainingMaterial->ResponsiblePersonLastName->ExportValue($CPDTrainingMaterial->Export, $CPDTrainingMaterial->ExportOriginalValue)); $XmlDoc->AddField('ResponsiblePersonEMailAddress', $CPDTrainingMaterial->ResponsiblePersonEMailAddress->ExportValue($CPDTrainingMaterial->Export, $CPDTrainingMaterial->ExportOriginalValue)); $XmlDoc->AddField('ResponsiblePersonContactNumber', $CPDTrainingMaterial->ResponsiblePersonContactNumber->ExportValue($CPDTrainingMaterial->Export, $CPDTrainingMaterial->ExportOriginalValue)); $XmlDoc->AddField('ResponsibleVATNumber', $CPDTrainingMaterial->ResponsibleVATNumber->ExportValue($CPDTrainingMaterial->Export, $CPDTrainingMaterial->ExportOriginalValue)); $XmlDoc->AddField('Archived', $CPDTrainingMaterial->Archived->ExportValue($CPDTrainingMaterial->Export, $CPDTrainingMaterial->ExportOriginalValue)); $XmlDoc->AddField('Presenter1Title', $CPDTrainingMaterial->Presenter1Title->ExportValue($CPDTrainingMaterial->Export, $CPDTrainingMaterial->ExportOriginalValue)); $XmlDoc->AddField('Presenter1FirstName', $CPDTrainingMaterial->Presenter1FirstName->ExportValue($CPDTrainingMaterial->Export, $CPDTrainingMaterial->ExportOriginalValue)); $XmlDoc->AddField('Presenter1Surname', $CPDTrainingMaterial->Presenter1Surname->ExportValue($CPDTrainingMaterial->Export, $CPDTrainingMaterial->ExportOriginalValue)); $XmlDoc->AddField('Presenter1Phone', $CPDTrainingMaterial->Presenter1Phone->ExportValue($CPDTrainingMaterial->Export, $CPDTrainingMaterial->ExportOriginalValue)); $XmlDoc->AddField('Presenter1Email', $CPDTrainingMaterial->Presenter1Email->ExportValue($CPDTrainingMaterial->Export, $CPDTrainingMaterial->ExportOriginalValue)); $XmlDoc->AddField('Presenter1ID', $CPDTrainingMaterial->Presenter1ID->ExportValue($CPDTrainingMaterial->Export, $CPDTrainingMaterial->ExportOriginalValue)); $XmlDoc->AddField('Presenter1CV', $CPDTrainingMaterial->Presenter1CV->ExportValue($CPDTrainingMaterial->Export, $CPDTrainingMaterial->ExportOriginalValue)); $XmlDoc->AddField('Presenter1SLA', $CPDTrainingMaterial->Presenter1SLA->ExportValue($CPDTrainingMaterial->Export, $CPDTrainingMaterial->ExportOriginalValue)); $XmlDoc->AddField('Presenter1IDDoc', $CPDTrainingMaterial->Presenter1IDDoc->ExportValue($CPDTrainingMaterial->Export, $CPDTrainingMaterial->ExportOriginalValue)); $XmlDoc->AddField('Presenter2Title', $CPDTrainingMaterial->Presenter2Title->ExportValue($CPDTrainingMaterial->Export, $CPDTrainingMaterial->ExportOriginalValue)); $XmlDoc->AddField('Presenter2FirstName', $CPDTrainingMaterial->Presenter2FirstName->ExportValue($CPDTrainingMaterial->Export, $CPDTrainingMaterial->ExportOriginalValue)); $XmlDoc->AddField('Presenter2Surname', $CPDTrainingMaterial->Presenter2Surname->ExportValue($CPDTrainingMaterial->Export, $CPDTrainingMaterial->ExportOriginalValue)); $XmlDoc->AddField('Presenter2Phone', $CPDTrainingMaterial->Presenter2Phone->ExportValue($CPDTrainingMaterial->Export, $CPDTrainingMaterial->ExportOriginalValue)); $XmlDoc->AddField('Presenter2Email', $CPDTrainingMaterial->Presenter2Email->ExportValue($CPDTrainingMaterial->Export, $CPDTrainingMaterial->ExportOriginalValue)); $XmlDoc->AddField('Presenter2ID', $CPDTrainingMaterial->Presenter2ID->ExportValue($CPDTrainingMaterial->Export, $CPDTrainingMaterial->ExportOriginalValue)); $XmlDoc->AddField('Presenter2CV', $CPDTrainingMaterial->Presenter2CV->ExportValue($CPDTrainingMaterial->Export, $CPDTrainingMaterial->ExportOriginalValue)); $XmlDoc->AddField('Presenter2SLA', $CPDTrainingMaterial->Presenter2SLA->ExportValue($CPDTrainingMaterial->Export, $CPDTrainingMaterial->ExportOriginalValue)); $XmlDoc->AddField('Presenter2IDDoc', $CPDTrainingMaterial->Presenter2IDDoc->ExportValue($CPDTrainingMaterial->Export, $CPDTrainingMaterial->ExportOriginalValue)); $XmlDoc->AddField('Presenter3Title', $CPDTrainingMaterial->Presenter3Title->ExportValue($CPDTrainingMaterial->Export, $CPDTrainingMaterial->ExportOriginalValue)); $XmlDoc->AddField('Presenter3FirstName', $CPDTrainingMaterial->Presenter3FirstName->ExportValue($CPDTrainingMaterial->Export, $CPDTrainingMaterial->ExportOriginalValue)); $XmlDoc->AddField('Presenter3Surname', $CPDTrainingMaterial->Presenter3Surname->ExportValue($CPDTrainingMaterial->Export, $CPDTrainingMaterial->ExportOriginalValue)); $XmlDoc->AddField('Presenter3Phone', $CPDTrainingMaterial->Presenter3Phone->ExportValue($CPDTrainingMaterial->Export, $CPDTrainingMaterial->ExportOriginalValue)); $XmlDoc->AddField('Presenter3Email', $CPDTrainingMaterial->Presenter3Email->ExportValue($CPDTrainingMaterial->Export, $CPDTrainingMaterial->ExportOriginalValue)); $XmlDoc->AddField('Presenter3ID', $CPDTrainingMaterial->Presenter3ID->ExportValue($CPDTrainingMaterial->Export, $CPDTrainingMaterial->ExportOriginalValue)); $XmlDoc->AddField('Presenter3CV', $CPDTrainingMaterial->Presenter3CV->ExportValue($CPDTrainingMaterial->Export, $CPDTrainingMaterial->ExportOriginalValue)); $XmlDoc->AddField('Presenter3SLA', $CPDTrainingMaterial->Presenter3SLA->ExportValue($CPDTrainingMaterial->Export, $CPDTrainingMaterial->ExportOriginalValue)); $XmlDoc->AddField('Presenter3IDDoc', $CPDTrainingMaterial->Presenter3IDDoc->ExportValue($CPDTrainingMaterial->Export, $CPDTrainingMaterial->ExportOriginalValue)); $XmlDoc->AddField('NumReminders', $CPDTrainingMaterial->NumReminders->ExportValue($CPDTrainingMaterial->Export, $CPDTrainingMaterial->ExportOriginalValue)); $XmlDoc->AddField('LastReminder', $CPDTrainingMaterial->LastReminder->ExportValue($CPDTrainingMaterial->Export, $CPDTrainingMaterial->ExportOriginalValue)); $XmlDoc->AddField('DateCreated', $CPDTrainingMaterial->DateCreated->ExportValue($CPDTrainingMaterial->Export, $CPDTrainingMaterial->ExportOriginalValue)); } else { $ExportDoc->BeginExportRow(TRUE); // Allow CSS styles if enabled $ExportDoc->ExportField($CPDTrainingMaterial->MaterialID); $ExportDoc->ExportField($CPDTrainingMaterial->ProviderID); $ExportDoc->ExportField($CPDTrainingMaterial->Subject); $ExportDoc->ExportField($CPDTrainingMaterial->RenewOrNew); $ExportDoc->ExportField($CPDTrainingMaterial->Status); $ExportDoc->ExportField($CPDTrainingMaterial->Duration); $ExportDoc->ExportField($CPDTrainingMaterial->DurationUnit); $ExportDoc->ExportField($CPDTrainingMaterial->Level); $ExportDoc->ExportField($CPDTrainingMaterial->CourseBrochure); $ExportDoc->ExportField($CPDTrainingMaterial->ActivityProgramme); $ExportDoc->ExportField($CPDTrainingMaterial->LearningOutcomesFile); $ExportDoc->ExportField($CPDTrainingMaterial->TrainingManualLink); $ExportDoc->ExportField($CPDTrainingMaterial->PresentationLink); $ExportDoc->ExportField($CPDTrainingMaterial->HandOutsLink); $ExportDoc->ExportField($CPDTrainingMaterial->FeedbackForm); $ExportDoc->ExportField($CPDTrainingMaterial->ModeOfDelivery); $ExportDoc->ExportField($CPDTrainingMaterial->Promotion); $ExportDoc->ExportField($CPDTrainingMaterial->AccredNum); $ExportDoc->ExportField($CPDTrainingMaterial->PrevAccredNum); $ExportDoc->ExportField($CPDTrainingMaterial->DateApproved); $ExportDoc->ExportField($CPDTrainingMaterial->DateExpires); $ExportDoc->ExportField($CPDTrainingMaterial->Certification); $ExportDoc->ExportField($CPDTrainingMaterial->CPD); $ExportDoc->ExportField($CPDTrainingMaterial->InvoiceCode); $ExportDoc->ExportField($CPDTrainingMaterial->InvoiceNumber); $ExportDoc->ExportField($CPDTrainingMaterial->Cost); $ExportDoc->ExportField($CPDTrainingMaterial->CostToDelegate); $ExportDoc->ExportField($CPDTrainingMaterial->DepositAmt); $ExportDoc->ExportField($CPDTrainingMaterial->InvoiceFile); $ExportDoc->ExportField($CPDTrainingMaterial->InvoiceDate); $ExportDoc->ExportField($CPDTrainingMaterial->DatePaid); $ExportDoc->ExportField($CPDTrainingMaterial->ProofOfPayment); $ExportDoc->ExportField($CPDTrainingMaterial->EvaluatorID); $ExportDoc->ExportField($CPDTrainingMaterial->EvaluatorID2); $ExportDoc->ExportField($CPDTrainingMaterial->EvaluatorID3); $ExportDoc->ExportField($CPDTrainingMaterial->EvaluatorFee); $ExportDoc->ExportField($CPDTrainingMaterial->EvaluatorFeeAmount); $ExportDoc->ExportField($CPDTrainingMaterial->EvaluatorFeeDate); $ExportDoc->ExportField($CPDTrainingMaterial->EvaluatorInvoice); $ExportDoc->ExportField($CPDTrainingMaterial->EvaluatorTimesheet); $ExportDoc->ExportField($CPDTrainingMaterial->StartDate); $ExportDoc->ExportField($CPDTrainingMaterial->Other_Validator); $ExportDoc->ExportField($CPDTrainingMaterial->Provider_URL); $ExportDoc->ExportField($CPDTrainingMaterial->Category_Reg); $ExportDoc->ExportField($CPDTrainingMaterial->Discipline); $ExportDoc->ExportField($CPDTrainingMaterial->Sub_Discipline); $ExportDoc->ExportField($CPDTrainingMaterial->Activity_Nature); $ExportDoc->ExportField($CPDTrainingMaterial->Instances); $ExportDoc->ExportField($CPDTrainingMaterial->RemoteUpload); $ExportDoc->ExportField($CPDTrainingMaterial->LocalUpload); $ExportDoc->ExportField($CPDTrainingMaterial->AssessmentDoc); $ExportDoc->ExportField($CPDTrainingMaterial->ResponsiblePersonFirstName); $ExportDoc->ExportField($CPDTrainingMaterial->ResponsiblePersonLastName); $ExportDoc->ExportField($CPDTrainingMaterial->ResponsiblePersonEMailAddress); $ExportDoc->ExportField($CPDTrainingMaterial->ResponsiblePersonContactNumber); $ExportDoc->ExportField($CPDTrainingMaterial->ResponsibleVATNumber); $ExportDoc->ExportField($CPDTrainingMaterial->Archived); $ExportDoc->ExportField($CPDTrainingMaterial->Presenter1Title); $ExportDoc->ExportField($CPDTrainingMaterial->Presenter1FirstName); $ExportDoc->ExportField($CPDTrainingMaterial->Presenter1Surname); $ExportDoc->ExportField($CPDTrainingMaterial->Presenter1Phone); $ExportDoc->ExportField($CPDTrainingMaterial->Presenter1Email); $ExportDoc->ExportField($CPDTrainingMaterial->Presenter1ID); $ExportDoc->ExportField($CPDTrainingMaterial->Presenter1CV); $ExportDoc->ExportField($CPDTrainingMaterial->Presenter1SLA); $ExportDoc->ExportField($CPDTrainingMaterial->Presenter1IDDoc); $ExportDoc->ExportField($CPDTrainingMaterial->Presenter2Title); $ExportDoc->ExportField($CPDTrainingMaterial->Presenter2FirstName); $ExportDoc->ExportField($CPDTrainingMaterial->Presenter2Surname); $ExportDoc->ExportField($CPDTrainingMaterial->Presenter2Phone); $ExportDoc->ExportField($CPDTrainingMaterial->Presenter2Email); $ExportDoc->ExportField($CPDTrainingMaterial->Presenter2ID); $ExportDoc->ExportField($CPDTrainingMaterial->Presenter2CV); $ExportDoc->ExportField($CPDTrainingMaterial->Presenter2SLA); $ExportDoc->ExportField($CPDTrainingMaterial->Presenter2IDDoc); $ExportDoc->ExportField($CPDTrainingMaterial->Presenter3Title); $ExportDoc->ExportField($CPDTrainingMaterial->Presenter3FirstName); $ExportDoc->ExportField($CPDTrainingMaterial->Presenter3Surname); $ExportDoc->ExportField($CPDTrainingMaterial->Presenter3Phone); $ExportDoc->ExportField($CPDTrainingMaterial->Presenter3Email); $ExportDoc->ExportField($CPDTrainingMaterial->Presenter3ID); $ExportDoc->ExportField($CPDTrainingMaterial->Presenter3CV); $ExportDoc->ExportField($CPDTrainingMaterial->Presenter3SLA); $ExportDoc->ExportField($CPDTrainingMaterial->Presenter3IDDoc); $ExportDoc->ExportField($CPDTrainingMaterial->NumReminders); $ExportDoc->ExportField($CPDTrainingMaterial->LastReminder); $ExportDoc->ExportField($CPDTrainingMaterial->DateCreated); $ExportDoc->EndExportRow(); } } $rs->MoveNext(); } if ($CPDTrainingMaterial->Export <> "xml") $ExportDoc->ExportFooter(); // Close recordset $rs->Close(); // Clean output buffer if (!EW_DEBUG_ENABLED && ob_get_length()) ob_end_clean(); // Write BOM if utf-8 if ($utf8 && !in_array($CPDTrainingMaterial->Export, array("email", "xml"))) echo "\xEF\xBB\xBF"; // Write debug message if enabled if (EW_DEBUG_ENABLED) echo ew_DebugMsg(); // Output data if ($CPDTrainingMaterial->Export == "xml") { header("Content-Type: text/xml"); echo $XmlDoc->XML(); } elseif ($CPDTrainingMaterial->Export == "email") { $this->ExportEmail($ExportDoc->Text); $this->Page_Terminate($CPDTrainingMaterial->ExportReturnUrl()); } else { echo $ExportDoc->Text; } } // Export email function ExportEmail($EmailContent) { global $Language, $CPDTrainingMaterial; $sSender = @$_GET["sender"]; $sRecipient = @$_GET["recipient"]; $sCc = @$_GET["cc"]; $sBcc = @$_GET["bcc"]; $sContentType = @$_GET["contenttype"]; // Subject $sSubject = ew_StripSlashes(@$_GET["subject"]); $sEmailSubject = $sSubject; // Message $sContent = ew_StripSlashes(@$_GET["message"]); $sEmailMessage = $sContent; // Check sender if ($sSender == "") { $this->setMessage($Language->Phrase("EnterSenderEmail")); return; } if (!ew_CheckEmail($sSender)) { $this->setMessage($Language->Phrase("EnterProperSenderEmail")); return; } // Check recipient if (!ew_CheckEmailList($sRecipient, EW_MAX_EMAIL_RECIPIENT)) { $this->setMessage($Language->Phrase("EnterProperRecipientEmail")); return; } // Check cc if (!ew_CheckEmailList($sCc, EW_MAX_EMAIL_RECIPIENT)) { $this->setMessage($Language->Phrase("EnterProperCcEmail")); return; } // Check bcc if (!ew_CheckEmailList($sBcc, EW_MAX_EMAIL_RECIPIENT)) { $this->setMessage($Language->Phrase("EnterProperBccEmail")); return; } // Check email sent count if (!isset($_SESSION[EW_EXPORT_EMAIL_COUNTER])) $_SESSION[EW_EXPORT_EMAIL_COUNTER] = 0; if (intval($_SESSION[EW_EXPORT_EMAIL_COUNTER]) > EW_MAX_EMAIL_SENT_COUNT) { $this->setMessage($Language->Phrase("ExceedMaxEmailExport")); return; } if ($sEmailMessage <> "") { $sEmailMessage = ew_RemoveXSS($sEmailMessage); $sEmailMessage .= ($sContentType == "url") ? "\r\n\r\n" : "<br><br>"; } if ($sContentType == "url") { $sUrl = ew_ConvertFullUrl(ew_CurrentPage() . "?" . $this->ExportQueryString()); $sEmailMessage .= $sUrl; // send URL only } else { $sEmailMessage .= $EmailContent; // send HTML } // Send email $Email = new cEmail(); $Email->Sender = $sSender; // Sender $Email->Recipient = $sRecipient; // Recipient $Email->Cc = $sCc; // Cc $Email->Bcc = $sBcc; // Bcc $Email->Subject = $sEmailSubject; // Subject $Email->Content = $sEmailMessage; // Content $Email->Format = ($sContentType == "url") ? "text" : "html"; $Email->Charset = EW_EMAIL_CHARSET; $EventArgs = array(); $bEmailSent = FALSE; if ($CPDTrainingMaterial->Email_Sending($Email, $EventArgs)) $bEmailSent = $Email->Send(); // Check email sent status if ($bEmailSent) { // Update email sent count $_SESSION[EW_EXPORT_EMAIL_COUNTER]++; // Sent email success $this->setMessage($Language->Phrase("SendEmailSuccess")); } else { // Sent email failure $this->setMessage($Email->SendErrDescription); } } // Export QueryString function ExportQueryString() { global $CPDTrainingMaterial; // Initialize $sQry = "export=html"; // Build QueryString for search if ($CPDTrainingMaterial->getSessionBasicSearchKeyword() <> "") { $sQry .= "&" . EW_TABLE_BASIC_SEARCH . "=" . $CPDTrainingMaterial->getSessionBasicSearchKeyword() . "&" . EW_TABLE_BASIC_SEARCH_TYPE . "=" . $CPDTrainingMaterial->getSessionBasicSearchType(); } $this->AddSearchQueryString($sQry, $CPDTrainingMaterial->MaterialID); // MaterialID $this->AddSearchQueryString($sQry, $CPDTrainingMaterial->ProviderID); // ProviderID $this->AddSearchQueryString($sQry, $CPDTrainingMaterial->Subject); // Subject $this->AddSearchQueryString($sQry, $CPDTrainingMaterial->RenewOrNew); // RenewOrNew $this->AddSearchQueryString($sQry, $CPDTrainingMaterial->Status); // Status $this->AddSearchQueryString($sQry, $CPDTrainingMaterial->Duration); // Duration $this->AddSearchQueryString($sQry, $CPDTrainingMaterial->DurationUnit); // DurationUnit $this->AddSearchQueryString($sQry, $CPDTrainingMaterial->Level); // Level $this->AddSearchQueryString($sQry, $CPDTrainingMaterial->EventDescription); // EventDescription $this->AddSearchQueryString($sQry, $CPDTrainingMaterial->TrainingManualLink); // TrainingManualLink $this->AddSearchQueryString($sQry, $CPDTrainingMaterial->PresentationLink); // PresentationLink $this->AddSearchQueryString($sQry, $CPDTrainingMaterial->HandOutsLink); // HandOutsLink $this->AddSearchQueryString($sQry, $CPDTrainingMaterial->LearningOutcomes); // LearningOutcomes $this->AddSearchQueryString($sQry, $CPDTrainingMaterial->ModeOfDelivery); // ModeOfDelivery $this->AddSearchQueryString($sQry, $CPDTrainingMaterial->TargetAudience); // TargetAudience $this->AddSearchQueryString($sQry, $CPDTrainingMaterial->Objectives); // Objectives $this->AddSearchQueryString($sQry, $CPDTrainingMaterial->Promotion); // Promotion $this->AddSearchQueryString($sQry, $CPDTrainingMaterial->Motivation); // Motivation $this->AddSearchQueryString($sQry, $CPDTrainingMaterial->AccredNum); // AccredNum $this->AddSearchQueryString($sQry, $CPDTrainingMaterial->PrevAccredNum); // PrevAccredNum $this->AddSearchQueryString($sQry, $CPDTrainingMaterial->DateApproved); // DateApproved $this->AddSearchQueryString($sQry, $CPDTrainingMaterial->DateExpires); // DateExpires $this->AddSearchQueryString($sQry, $CPDTrainingMaterial->Certification); // Certification $this->AddSearchQueryString($sQry, $CPDTrainingMaterial->CPD); // CPD $this->AddSearchQueryString($sQry, $CPDTrainingMaterial->InvoiceCode); // InvoiceCode $this->AddSearchQueryString($sQry, $CPDTrainingMaterial->InvoiceNumber); // InvoiceNumber $this->AddSearchQueryString($sQry, $CPDTrainingMaterial->Cost); // Cost $this->AddSearchQueryString($sQry, $CPDTrainingMaterial->CostToDelegate); // CostToDelegate $this->AddSearchQueryString($sQry, $CPDTrainingMaterial->DepositAmt); // DepositAmt $this->AddSearchQueryString($sQry, $CPDTrainingMaterial->InvoiceDate); // InvoiceDate $this->AddSearchQueryString($sQry, $CPDTrainingMaterial->DatePaid); // DatePaid $this->AddSearchQueryString($sQry, $CPDTrainingMaterial->EvaluatorID); // EvaluatorID $this->AddSearchQueryString($sQry, $CPDTrainingMaterial->EvaluatorID2); // EvaluatorID2 $this->AddSearchQueryString($sQry, $CPDTrainingMaterial->EvaluatorID3); // EvaluatorID3 $this->AddSearchQueryString($sQry, $CPDTrainingMaterial->EvaluatorFee); // EvaluatorFee $this->AddSearchQueryString($sQry, $CPDTrainingMaterial->EvaluatorFeeAmount); // EvaluatorFeeAmount $this->AddSearchQueryString($sQry, $CPDTrainingMaterial->EvaluatorFeeDate); // EvaluatorFeeDate $this->AddSearchQueryString($sQry, $CPDTrainingMaterial->StartDate); // StartDate $this->AddSearchQueryString($sQry, $CPDTrainingMaterial->Other_Validator); // Other_Validator $this->AddSearchQueryString($sQry, $CPDTrainingMaterial->Provider_URL); // Provider_URL $this->AddSearchQueryString($sQry, $CPDTrainingMaterial->Category_Reg); // Category_Reg $this->AddSearchQueryString($sQry, $CPDTrainingMaterial->Discipline); // Discipline $this->AddSearchQueryString($sQry, $CPDTrainingMaterial->Sub_Discipline); // Sub_Discipline $this->AddSearchQueryString($sQry, $CPDTrainingMaterial->Activity_Nature); // Activity_Nature $this->AddSearchQueryString($sQry, $CPDTrainingMaterial->Instances); // Instances $this->AddSearchQueryString($sQry, $CPDTrainingMaterial->LocalUpload); // LocalUpload $this->AddSearchQueryString($sQry, $CPDTrainingMaterial->ResponsiblePersonFirstName); // ResponsiblePersonFirstName $this->AddSearchQueryString($sQry, $CPDTrainingMaterial->ResponsiblePersonLastName); // ResponsiblePersonLastName $this->AddSearchQueryString($sQry, $CPDTrainingMaterial->ResponsiblePersonEMailAddress); // ResponsiblePersonEMailAddress $this->AddSearchQueryString($sQry, $CPDTrainingMaterial->ResponsibleBillingAddress); // ResponsibleBillingAddress $this->AddSearchQueryString($sQry, $CPDTrainingMaterial->ResponsiblePersonContactNumber); // ResponsiblePersonContactNumber $this->AddSearchQueryString($sQry, $CPDTrainingMaterial->ResponsibleVATNumber); // ResponsibleVATNumber $this->AddSearchQueryString($sQry, $CPDTrainingMaterial->Comments); // Comments $this->AddSearchQueryString($sQry, $CPDTrainingMaterial->Archived); // Archived $this->AddSearchQueryString($sQry, $CPDTrainingMaterial->Presenter1Title); // Presenter1Title $this->AddSearchQueryString($sQry, $CPDTrainingMaterial->Presenter1FirstName); // Presenter1FirstName $this->AddSearchQueryString($sQry, $CPDTrainingMaterial->Presenter1Surname); // Presenter1Surname $this->AddSearchQueryString($sQry, $CPDTrainingMaterial->Presenter1Phone); // Presenter1Phone $this->AddSearchQueryString($sQry, $CPDTrainingMaterial->Presenter1Email); // Presenter1Email $this->AddSearchQueryString($sQry, $CPDTrainingMaterial->Presenter1ID); // Presenter1ID $this->AddSearchQueryString($sQry, $CPDTrainingMaterial->Presenter2Title); // Presenter2Title $this->AddSearchQueryString($sQry, $CPDTrainingMaterial->Presenter2FirstName); // Presenter2FirstName $this->AddSearchQueryString($sQry, $CPDTrainingMaterial->Presenter2Surname); // Presenter2Surname $this->AddSearchQueryString($sQry, $CPDTrainingMaterial->Presenter2Phone); // Presenter2Phone $this->AddSearchQueryString($sQry, $CPDTrainingMaterial->Presenter2Email); // Presenter2Email $this->AddSearchQueryString($sQry, $CPDTrainingMaterial->Presenter2ID); // Presenter2ID $this->AddSearchQueryString($sQry, $CPDTrainingMaterial->Presenter3Title); // Presenter3Title $this->AddSearchQueryString($sQry, $CPDTrainingMaterial->Presenter3FirstName); // Presenter3FirstName $this->AddSearchQueryString($sQry, $CPDTrainingMaterial->Presenter3Surname); // Presenter3Surname $this->AddSearchQueryString($sQry, $CPDTrainingMaterial->Presenter3Phone); // Presenter3Phone $this->AddSearchQueryString($sQry, $CPDTrainingMaterial->Presenter3Email); // Presenter3Email $this->AddSearchQueryString($sQry, $CPDTrainingMaterial->Presenter3ID); // Presenter3ID $this->AddSearchQueryString($sQry, $CPDTrainingMaterial->DateCreated); // DateCreated // Build QueryString for pager $sQry .= "&" . EW_TABLE_REC_PER_PAGE . "=" . $CPDTrainingMaterial->getRecordsPerPage() . "&" . EW_TABLE_START_REC . "=" . $CPDTrainingMaterial->getStartRecordNumber(); return $sQry; } // Add search QueryString function AddSearchQueryString(&$Qry, &$Fld) { global $CPDTrainingMaterial; $FldParm = substr($Fld->FldVar, 2); $FldSearchValue = $CPDTrainingMaterial->GetAdvancedSearch("x_" . $FldParm); if (strval($FldSearchValue) <> "") { $Qry .= "&x_" . $FldParm . "=" . FldSearchValue . "&z_" . $FldParm . "=" . $CPDTrainingMaterial->GetAdvancedSearch("z_" . $FldParm); } $FldSearchValue2 = $CPDTrainingMaterial->GetAdvancedSearch("y_" . $FldParm); if (strval($FldSearchValue2) <> "") { $Qry .= "&v_" . $FldParm . "=" . $CPDTrainingMaterial->GetAdvancedSearch("v_" . $FldParm) . "&y_" . $FldParm . "=" . $FldSearchValue2 . "&w_" . $FldParm . "=" . $CPDTrainingMaterial->GetAdvancedSearch("w_" . $FldParm); } } // Set up master/detail based on QueryString function SetUpMasterDetail() { global $CPDTrainingMaterial; $bValidMaster = FALSE; // Get the keys for master table if (@$_GET[EW_TABLE_SHOW_MASTER] <> "") { $sMasterTblVar = $_GET[EW_TABLE_SHOW_MASTER]; if ($sMasterTblVar == "") { $bValidMaster = TRUE; $this->sDbMasterFilter = ""; $this->sDbDetailFilter = ""; } if ($sMasterTblVar == "CPDServiceProvider") { $bValidMaster = TRUE; $this->sDbMasterFilter = $CPDTrainingMaterial->SqlMasterFilter_CPDServiceProvider(); $this->sDbDetailFilter = $CPDTrainingMaterial->SqlDetailFilter_CPDServiceProvider(); if (@$_GET["CPDProviderID"] <> "") { $GLOBALS["CPDServiceProvider"]->CPDProviderID->setQueryStringValue($_GET["CPDProviderID"]); $CPDTrainingMaterial->ProviderID->setQueryStringValue($GLOBALS["CPDServiceProvider"]->CPDProviderID->QueryStringValue); $CPDTrainingMaterial->ProviderID->setSessionValue($CPDTrainingMaterial->ProviderID->QueryStringValue); if (!is_numeric($GLOBALS["CPDServiceProvider"]->CPDProviderID->QueryStringValue)) $bValidMaster = FALSE; $this->sDbMasterFilter = str_replace("@CPDProviderID@", ew_AdjustSql($GLOBALS["CPDServiceProvider"]->CPDProviderID->QueryStringValue), $this->sDbMasterFilter); $this->sDbDetailFilter = str_replace("@ProviderID@", ew_AdjustSql($GLOBALS["CPDServiceProvider"]->CPDProviderID->QueryStringValue), $this->sDbDetailFilter); } else { $bValidMaster = FALSE; } } } if ($bValidMaster) { // Save current master table $CPDTrainingMaterial->setCurrentMasterTable($sMasterTblVar); // Reset start record counter (new master key) $this->lStartRec = 1; $CPDTrainingMaterial->setStartRecordNumber($this->lStartRec); $CPDTrainingMaterial->setMasterFilter($this->sDbMasterFilter); // Set up master filter $CPDTrainingMaterial->setDetailFilter($this->sDbDetailFilter); // Set up detail filter // Clear previous master key from Session if ($sMasterTblVar <> "CPDServiceProvider") { if ($CPDTrainingMaterial->ProviderID->QueryStringValue == "") $CPDTrainingMaterial->ProviderID->setSessionValue(""); } } else { $this->sDbMasterFilter = $CPDTrainingMaterial->getMasterFilter(); // Restore master filter $this->sDbDetailFilter = $CPDTrainingMaterial->getDetailFilter(); // Restore detail filter } } // 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"; } // Form Custom Validate event function Form_CustomValidate(&$CustomError) { // Return error message in CustomError return TRUE; } // ListOptions Load event function ListOptions_Load() { CPDTrainingMaterialListOptions_Load($this); // Example: //$this->ListOptions->Add("new"); //$this->ListOptions->Items["new"]->OnLeft = TRUE; // Link on left //$this->ListOptions->MoveItem("new", 0); // Move to first column } // ListOptions Rendered event function ListOptions_Rendered() { CPDTrainingMaterialListOptions_Rendered($this); // Example: //$this->ListOptions->Items["new"]->Body = "xxx"; } } ?>