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 "CPDTMReviewinfo.php" ?> <?php include "CPDTrainingMaterialinfo.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 $CPDTMReview_view = new cCPDTMReview_view(); $Page =& $CPDTMReview_view; // Page init $CPDTMReview_view->Page_Init(); // Page main $CPDTMReview_view->Page_Main(); ?> <?php include "header.php" ?> <?php if ($CPDTMReview->Export == "") { ?> <script type="text/javascript"> <!-- // Create page object var CPDTMReview_view = new ew_Page("CPDTMReview_view"); // page properties CPDTMReview_view.PageID = "view"; // page ID CPDTMReview_view.FormID = "fCPDTMReviewview"; // form ID var EW_PAGE_ID = CPDTMReview_view.PageID; // for backward compatibility // extend page with Form_CustomValidate function CPDTMReview_view.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) { ?> CPDTMReview_view.ValidateRequired = true; // uses JavaScript validation <?php } else { ?> CPDTMReview_view.ValidateRequired = false; // no JavaScript validation <?php } ?> //--> </script> <script language="JavaScript" type="text/javascript"> <!-- // Write your client script here, no need to add script tags. // To include another .js script, use: // ew_ClientScriptInclude("my_javascript.js"); //--> </script> <?php } ?> <p><span class="phpmaker"><?php echo $Language->Phrase("View") ?> <?php echo $Language->Phrase("TblTypeTABLE") ?><?php echo $CPDTMReview->TableCaption() ?> <?php if ($CPDTMReview->Export == "") { ?> <a href="<?php echo $CPDTMReview_view->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 $CPDTMReview_view->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 $CPDTMReview_view->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_CPDTMReview" id="emf_CPDTMReview" href="javascript:void(0);" onclick="ew_EmailDialogShow({lnk:'emf_CPDTMReview',hdr:ewLanguage.Phrase('ExportToEmail'),key:<?php echo ew_ArrayToJsonAttr($CPDTMReview_view->arRecKey) ?>,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 } ?> <br><br> <?php if ($CPDTMReview->Export == "") { ?> <a href="<?php echo $CPDTMReview_view->ListUrl ?>"><?php echo $Language->Phrase("BackToList") ?></a> <?php if ($Security->CanAdd()) { ?> <a href="<?php echo $CPDTMReview_view->AddUrl ?>"><?php echo $Language->Phrase("ViewPageAddLink") ?></a> <?php } ?> <?php if ($Security->CanEdit()) { ?> <a href="<?php echo $CPDTMReview_view->EditUrl ?>"><?php echo $Language->Phrase("ViewPageEditLink") ?></a> <?php } ?> <?php if ($Security->CanDelete()) { ?> <a href="<?php echo $CPDTMReview_view->DeleteUrl ?>"><?php echo $Language->Phrase("ViewPageDeleteLink") ?></a> <?php } ?> <?php } ?> </span></p> <?php if (EW_DEBUG_ENABLED) echo ew_DebugMsg(); $CPDTMReview_view->ShowMessage(); ?> <p> <?php if ($CPDTMReview->Export == "") { ?> <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($CPDTMReview_view->Pager)) $CPDTMReview_view->Pager = new cPrevNextPager($CPDTMReview_view->lStartRec, $CPDTMReview_view->lDisplayRecs, $CPDTMReview_view->lTotalRecs) ?> <?php if ($CPDTMReview_view->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 ($CPDTMReview_view->Pager->FirstButton->Enabled) { ?> <td><a href="<?php echo $CPDTMReview_view->PageUrl() ?>start=<?php echo $CPDTMReview_view->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 ($CPDTMReview_view->Pager->PrevButton->Enabled) { ?> <td><a href="<?php echo $CPDTMReview_view->PageUrl() ?>start=<?php echo $CPDTMReview_view->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 $CPDTMReview_view->Pager->CurrentPage ?>" size="4"></td> <!--next page button--> <?php if ($CPDTMReview_view->Pager->NextButton->Enabled) { ?> <td><a href="<?php echo $CPDTMReview_view->PageUrl() ?>start=<?php echo $CPDTMReview_view->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 ($CPDTMReview_view->Pager->LastButton->Enabled) { ?> <td><a href="<?php echo $CPDTMReview_view->PageUrl() ?>start=<?php echo $CPDTMReview_view->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 $CPDTMReview_view->Pager->PageCount ?></span></td> </tr></table> <?php } else { ?> <?php if ($Security->CanList()) { ?> <?php if ($CPDTMReview_view->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 } else { ?> <span class="phpmaker"><?php echo $Language->Phrase("NoPermission") ?></span> <?php } ?> <?php } ?> </td> </tr> </table> </form> <br> <?php } ?> <table cellspacing="0" class="ewGrid"><tr><td class="ewGridContent"> <div class="ewGridMiddlePanel"> <table cellspacing="0" class="ewTable"> <?php if ($CPDTMReview->CPDTMReviewID->Visible) { // CPDTMReviewID ?> <tr<?php echo $CPDTMReview->RowAttributes() ?>> <td class="ewTableHeader"><?php echo $CPDTMReview->CPDTMReviewID->FldCaption() ?></td> <td<?php echo $CPDTMReview->CPDTMReviewID->CellAttributes() ?>> <div<?php echo $CPDTMReview->CPDTMReviewID->ViewAttributes() ?>><?php echo $CPDTMReview->CPDTMReviewID->ViewValue ?></div></td> </tr> <?php } ?> <?php if ($CPDTMReview->ProviderID->Visible) { // ProviderID ?> <tr<?php echo $CPDTMReview->RowAttributes() ?>> <td class="ewTableHeader"><?php echo $CPDTMReview->ProviderID->FldCaption() ?></td> <td<?php echo $CPDTMReview->ProviderID->CellAttributes() ?>> <div<?php echo $CPDTMReview->ProviderID->ViewAttributes() ?>><?php echo $CPDTMReview->ProviderID->ViewValue ?></div></td> </tr> <?php } ?> <?php if ($CPDTMReview->MaterialID->Visible) { // MaterialID ?> <tr<?php echo $CPDTMReview->RowAttributes() ?>> <td class="ewTableHeader"><?php echo $CPDTMReview->MaterialID->FldCaption() ?></td> <td<?php echo $CPDTMReview->MaterialID->CellAttributes() ?>> <div<?php echo $CPDTMReview->MaterialID->ViewAttributes() ?>><?php echo $CPDTMReview->MaterialID->ViewValue ?></div></td> </tr> <?php } ?> <?php if ($CPDTMReview->CPDAssessorID->Visible) { // CPDAssessorID ?> <tr<?php echo $CPDTMReview->RowAttributes() ?>> <td class="ewTableHeader"><?php echo $CPDTMReview->CPDAssessorID->FldCaption() ?></td> <td<?php echo $CPDTMReview->CPDAssessorID->CellAttributes() ?>> <div<?php echo $CPDTMReview->CPDAssessorID->ViewAttributes() ?>><?php echo $CPDTMReview->CPDAssessorID->ViewValue ?></div></td> </tr> <?php } ?> <?php if ($CPDTMReview->DateReviewed->Visible) { // DateReviewed ?> <tr<?php echo $CPDTMReview->RowAttributes() ?>> <td class="ewTableHeader"><?php echo $CPDTMReview->DateReviewed->FldCaption() ?></td> <td<?php echo $CPDTMReview->DateReviewed->CellAttributes() ?>> <div<?php echo $CPDTMReview->DateReviewed->ViewAttributes() ?>><?php echo $CPDTMReview->DateReviewed->ViewValue ?></div></td> </tr> <?php } ?> <?php if ($CPDTMReview->Q1Knowledge->Visible) { // Q1Knowledge ?> <tr<?php echo $CPDTMReview->RowAttributes() ?>> <td class="ewTableHeader"><?php echo $CPDTMReview->Q1Knowledge->FldCaption() ?></td> <td<?php echo $CPDTMReview->Q1Knowledge->CellAttributes() ?>> <div<?php echo $CPDTMReview->Q1Knowledge->ViewAttributes() ?>><?php echo $CPDTMReview->Q1Knowledge->ViewValue ?></div></td> </tr> <?php } ?> <?php if ($CPDTMReview->Q2Learning->Visible) { // Q2Learning ?> <tr<?php echo $CPDTMReview->RowAttributes() ?>> <td class="ewTableHeader"><?php echo $CPDTMReview->Q2Learning->FldCaption() ?></td> <td<?php echo $CPDTMReview->Q2Learning->CellAttributes() ?>> <div<?php echo $CPDTMReview->Q2Learning->ViewAttributes() ?>><?php echo $CPDTMReview->Q2Learning->ViewValue ?></div></td> </tr> <?php } ?> <?php if ($CPDTMReview->Q3Depth->Visible) { // Q3Depth ?> <tr<?php echo $CPDTMReview->RowAttributes() ?>> <td class="ewTableHeader"><?php echo $CPDTMReview->Q3Depth->FldCaption() ?></td> <td<?php echo $CPDTMReview->Q3Depth->CellAttributes() ?>> <div<?php echo $CPDTMReview->Q3Depth->ViewAttributes() ?>><?php echo $CPDTMReview->Q3Depth->ViewValue ?></div></td> </tr> <?php } ?> <?php if ($CPDTMReview->Q4EvalForm->Visible) { // Q4EvalForm ?> <tr<?php echo $CPDTMReview->RowAttributes() ?>> <td class="ewTableHeader"><?php echo $CPDTMReview->Q4EvalForm->FldCaption() ?></td> <td<?php echo $CPDTMReview->Q4EvalForm->CellAttributes() ?>> <div<?php echo $CPDTMReview->Q4EvalForm->ViewAttributes() ?>><?php echo $CPDTMReview->Q4EvalForm->ViewValue ?></div></td> </tr> <?php } ?> <?php if ($CPDTMReview->Q5Objectives->Visible) { // Q5Objectives ?> <tr<?php echo $CPDTMReview->RowAttributes() ?>> <td class="ewTableHeader"><?php echo $CPDTMReview->Q5Objectives->FldCaption() ?></td> <td<?php echo $CPDTMReview->Q5Objectives->CellAttributes() ?>> <div<?php echo $CPDTMReview->Q5Objectives->ViewAttributes() ?>><?php echo $CPDTMReview->Q5Objectives->ViewValue ?></div></td> </tr> <?php } ?> <?php if ($CPDTMReview->Q6Outcomes->Visible) { // Q6Outcomes ?> <tr<?php echo $CPDTMReview->RowAttributes() ?>> <td class="ewTableHeader"><?php echo $CPDTMReview->Q6Outcomes->FldCaption() ?></td> <td<?php echo $CPDTMReview->Q6Outcomes->CellAttributes() ?>> <div<?php echo $CPDTMReview->Q6Outcomes->ViewAttributes() ?>><?php echo $CPDTMReview->Q6Outcomes->ViewValue ?></div></td> </tr> <?php } ?> <?php if ($CPDTMReview->Q7Presentation->Visible) { // Q7Presentation ?> <tr<?php echo $CPDTMReview->RowAttributes() ?>> <td class="ewTableHeader"><?php echo $CPDTMReview->Q7Presentation->FldCaption() ?></td> <td<?php echo $CPDTMReview->Q7Presentation->CellAttributes() ?>> <div<?php echo $CPDTMReview->Q7Presentation->ViewAttributes() ?>><?php echo $CPDTMReview->Q7Presentation->ViewValue ?></div></td> </tr> <?php } ?> <?php if ($CPDTMReview->Q8Benefit->Visible) { // Q8Benefit ?> <tr<?php echo $CPDTMReview->RowAttributes() ?>> <td class="ewTableHeader"><?php echo $CPDTMReview->Q8Benefit->FldCaption() ?></td> <td<?php echo $CPDTMReview->Q8Benefit->CellAttributes() ?>> <div<?php echo $CPDTMReview->Q8Benefit->ViewAttributes() ?>><?php echo $CPDTMReview->Q8Benefit->ViewValue ?></div></td> </tr> <?php } ?> <?php if ($CPDTMReview->FinalStatus->Visible) { // FinalStatus ?> <tr<?php echo $CPDTMReview->RowAttributes() ?>> <td class="ewTableHeader"><?php echo $CPDTMReview->FinalStatus->FldCaption() ?></td> <td<?php echo $CPDTMReview->FinalStatus->CellAttributes() ?>> <div<?php echo $CPDTMReview->FinalStatus->ViewAttributes() ?>><?php echo $CPDTMReview->FinalStatus->ViewValue ?></div></td> </tr> <?php } ?> <?php if ($CPDTMReview->ChangesRequired->Visible) { // ChangesRequired ?> <tr<?php echo $CPDTMReview->RowAttributes() ?>> <td class="ewTableHeader"><?php echo $CPDTMReview->ChangesRequired->FldCaption() ?></td> <td<?php echo $CPDTMReview->ChangesRequired->CellAttributes() ?>> <div<?php echo $CPDTMReview->ChangesRequired->ViewAttributes() ?>><?php echo $CPDTMReview->ChangesRequired->ViewValue ?></div></td> </tr> <?php } ?> <?php if ($CPDTMReview->NotionalHours->Visible) { // NotionalHours ?> <tr<?php echo $CPDTMReview->RowAttributes() ?>> <td class="ewTableHeader"><?php echo $CPDTMReview->NotionalHours->FldCaption() ?></td> <td<?php echo $CPDTMReview->NotionalHours->CellAttributes() ?>> <div<?php echo $CPDTMReview->NotionalHours->ViewAttributes() ?>><?php echo $CPDTMReview->NotionalHours->ViewValue ?></div></td> </tr> <?php } ?> <?php if ($CPDTMReview->CPDCredits->Visible) { // CPDCredits ?> <tr<?php echo $CPDTMReview->RowAttributes() ?>> <td class="ewTableHeader"><?php echo $CPDTMReview->CPDCredits->FldCaption() ?></td> <td<?php echo $CPDTMReview->CPDCredits->CellAttributes() ?>> <div<?php echo $CPDTMReview->CPDCredits->ViewAttributes() ?>><?php echo $CPDTMReview->CPDCredits->ViewValue ?></div></td> </tr> <?php } ?> </table> </div> </td></tr></table> <?php if ($CPDTMReview->Export == "") { ?> <br> <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($CPDTMReview_view->Pager)) $CPDTMReview_view->Pager = new cPrevNextPager($CPDTMReview_view->lStartRec, $CPDTMReview_view->lDisplayRecs, $CPDTMReview_view->lTotalRecs) ?> <?php if ($CPDTMReview_view->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 ($CPDTMReview_view->Pager->FirstButton->Enabled) { ?> <td><a href="<?php echo $CPDTMReview_view->PageUrl() ?>start=<?php echo $CPDTMReview_view->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 ($CPDTMReview_view->Pager->PrevButton->Enabled) { ?> <td><a href="<?php echo $CPDTMReview_view->PageUrl() ?>start=<?php echo $CPDTMReview_view->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 $CPDTMReview_view->Pager->CurrentPage ?>" size="4"></td> <!--next page button--> <?php if ($CPDTMReview_view->Pager->NextButton->Enabled) { ?> <td><a href="<?php echo $CPDTMReview_view->PageUrl() ?>start=<?php echo $CPDTMReview_view->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 ($CPDTMReview_view->Pager->LastButton->Enabled) { ?> <td><a href="<?php echo $CPDTMReview_view->PageUrl() ?>start=<?php echo $CPDTMReview_view->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 $CPDTMReview_view->Pager->PageCount ?></span></td> </tr></table> <?php } else { ?> <?php if ($Security->CanList()) { ?> <?php if ($CPDTMReview_view->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 } else { ?> <span class="phpmaker"><?php echo $Language->Phrase("NoPermission") ?></span> <?php } ?> <?php } ?> </td> </tr> </table> </form> <?php } ?> <p> <?php if ($CPDTMReview->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 $CPDTMReview_view->Page_Terminate(); ?> <?php // // Page class // class cCPDTMReview_view { // Page ID var $PageID = 'view'; // Table name var $TableName = 'CPDTMReview'; // Page object name var $PageObjName = 'CPDTMReview_view'; // Page name function PageName() { return ew_CurrentPage(); } // Page URL function PageUrl() { $PageUrl = ew_CurrentPage() . "?"; global $CPDTMReview; if ($CPDTMReview->UseTokenInUrl) $PageUrl .= "t=" . $CPDTMReview->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, $CPDTMReview; if ($CPDTMReview->UseTokenInUrl) { if ($objForm) return ($CPDTMReview->TableVar == $objForm->GetValue("t")); if (@$_GET["t"] <> "") return ($CPDTMReview->TableVar == $_GET["t"]); } else { return TRUE; } } // // Page class constructor // function __construct() { global $conn, $Language; // Language object $Language = new cLanguage(); // Table object (CPDTMReview) $GLOBALS["CPDTMReview"] = new cCPDTMReview(); // Table object (CPDTrainingMaterial) $GLOBALS['CPDTrainingMaterial'] = new cCPDTrainingMaterial(); // Table object (CPDAdminUsers) $GLOBALS['CPDAdminUsers'] = new cCPDAdminUsers(); // Page ID if (!defined("EW_PAGE_ID")) define("EW_PAGE_ID", 'view', TRUE); // Table name (for backward compatibility) if (!defined("EW_TABLE_NAME")) define("EW_TABLE_NAME", 'CPDTMReview', TRUE); // Start timer $GLOBALS["gsTimer"] = new cTimer(); // Open connection $conn = ew_Connect(); } // // Page_Init // function Page_Init() { global $gsExport, $gsExportFile, $UserProfile, $Language, $Security, $objForm; global $CPDTMReview; // 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"); } $Security->TablePermission_Loading(); $Security->LoadCurrentUserLevel($this->TableName); $Security->TablePermission_Loaded(); if (!$Security->IsLoggedIn()) { $Security->SaveLastUrl(); $this->Page_Terminate("login.php"); } if (!$Security->CanView()) { $Security->SaveLastUrl(); $this->Page_Terminate("CPDTMReviewlist.php"); } $Security->UserID_Loading(); if ($Security->IsLoggedIn()) $Security->LoadUserID(); $Security->UserID_Loaded(); // Get export parameters if (@$_GET["export"] <> "") { $CPDTMReview->Export = $_GET["export"]; } elseif (ew_IsHttpPost()) { if (@$_POST["exporttype"] <> "") $CPDTMReview->Export = $_POST["exporttype"]; } else { $CPDTMReview->setExportReturnUrl(ew_CurrentUrl()); } $gsExport = $CPDTMReview->Export; // Get export parameter, used in header $gsExportFile = $CPDTMReview->TableVar; // Get export file, used in header if (@$_GET["CPDTMReviewID"] <> "") { if ($gsExportFile <> "") $gsExportFile .= "_"; $gsExportFile .= ew_StripSlashes($_GET["CPDTMReviewID"]); } if ($CPDTMReview->Export == "excel") { header('Content-Type: application/vnd.ms-excel'); header('Content-Disposition: attachment; filename=' . $gsExportFile .'.xls'); } if ($CPDTMReview->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(); } var $lDisplayRecs = 1; var $lStartRec; var $lStopRec; var $lTotalRecs = 0; var $lRecRange = 10; var $lRecCnt; var $arRecKey = array(); // // Page main // function Page_Main() { global $Language, $CPDTMReview; // Load current record $bLoadCurrentRecord = FALSE; $sReturnUrl = ""; $bMatchRecord = FALSE; if ($this->IsPageRequest()) { // Validate request if (@$_GET["CPDTMReviewID"] <> "") { $CPDTMReview->CPDTMReviewID->setQueryStringValue($_GET["CPDTMReviewID"]); $this->arRecKey["CPDTMReviewID"] = $CPDTMReview->CPDTMReviewID->QueryStringValue; } else { $bLoadCurrentRecord = TRUE; } // Get action $CPDTMReview->CurrentAction = "I"; // Display form switch ($CPDTMReview->CurrentAction) { case "I": // Get a record to display $this->lStartRec = 1; // Initialize start position if ($rs = $this->LoadRecordset()) // Load records $this->lTotalRecs = $rs->RecordCount(); // Get record count if ($this->lTotalRecs <= 0) { // No record found $this->setMessage($Language->Phrase("NoRecord")); // Set no record message $this->Page_Terminate("CPDTMReviewlist.php"); // Return to list page } elseif ($bLoadCurrentRecord) { // Load current record position $this->SetUpStartRec(); // Set up start record position // Point to current record if (intval($this->lStartRec) <= intval($this->lTotalRecs)) { $bMatchRecord = TRUE; $rs->Move($this->lStartRec-1); } } else { // Match key values while (!$rs->EOF) { if (strval($CPDTMReview->CPDTMReviewID->CurrentValue) == strval($rs->fields('CPDTMReviewID'))) { $CPDTMReview->setStartRecordNumber($this->lStartRec); // Save record position $bMatchRecord = TRUE; break; } else { $this->lStartRec++; $rs->MoveNext(); } } } if (!$bMatchRecord) { $this->setMessage($Language->Phrase("NoRecord")); // Set no record message $sReturnUrl = "CPDTMReviewlist.php"; // No matching record, return to list } else { $this->LoadRowValues($rs); // Load row values } } // Export data only if (in_array($CPDTMReview->Export, array("html","word","excel","xml","csv","email"))) { $this->ExportData(); if ($CPDTMReview->Export <> "email") $this->Page_Terminate(); // Terminate response exit(); } } else { $sReturnUrl = "CPDTMReviewlist.php"; // Not page request, return to list } if ($sReturnUrl <> "") $this->Page_Terminate($sReturnUrl); // Render row $CPDTMReview->RowType = EW_ROWTYPE_VIEW; $this->RenderRow(); } // Set up starting record parameters function SetUpStartRec() { global $CPDTMReview; 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]; $CPDTMReview->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; } $CPDTMReview->setStartRecordNumber($this->lStartRec); } } } $this->lStartRec = $CPDTMReview->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 $CPDTMReview->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 $CPDTMReview->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 $CPDTMReview->setStartRecordNumber($this->lStartRec); } } // Load recordset function LoadRecordset($offset = -1, $rowcnt = -1) { global $conn, $CPDTMReview; // Call Recordset Selecting event $CPDTMReview->Recordset_Selecting($CPDTMReview->CurrentFilter); // Load List page SQL $sSql = $CPDTMReview->SelectSQL(); if ($offset > -1 && $rowcnt > -1) $sSql .= " LIMIT $offset, $rowcnt"; // Load recordset $rs = ew_LoadRecordset($sSql); // Call Recordset Selected event $CPDTMReview->Recordset_Selected($rs); return $rs; } // Load row based on key values function LoadRow() { global $conn, $Security, $CPDTMReview; $sFilter = $CPDTMReview->KeyFilter(); // Call Row Selecting event $CPDTMReview->Row_Selecting($sFilter); // Load SQL based on filter $CPDTMReview->CurrentFilter = $sFilter; $sSql = $CPDTMReview->SQL(); $res = FALSE; $rs = ew_LoadRecordset($sSql); if ($rs && !$rs->EOF) { $res = TRUE; $this->LoadRowValues($rs); // Load row values // Call Row Selected event $CPDTMReview->Row_Selected($rs); $rs->Close(); } return $res; } // Load row values from recordset function LoadRowValues(&$rs) { global $conn, $CPDTMReview; $CPDTMReview->CPDTMReviewID->setDbValue($rs->fields('CPDTMReviewID')); $CPDTMReview->ProviderID->setDbValue($rs->fields('ProviderID')); $CPDTMReview->MaterialID->setDbValue($rs->fields('MaterialID')); $CPDTMReview->CPDAssessorID->setDbValue($rs->fields('CPDAssessorID')); $CPDTMReview->DateReviewed->setDbValue($rs->fields('DateReviewed')); $CPDTMReview->Q1Knowledge->setDbValue($rs->fields('Q1Knowledge')); $CPDTMReview->Q2Learning->setDbValue($rs->fields('Q2Learning')); $CPDTMReview->Q3Depth->setDbValue($rs->fields('Q3Depth')); $CPDTMReview->Q4EvalForm->setDbValue($rs->fields('Q4EvalForm')); $CPDTMReview->Q5Objectives->setDbValue($rs->fields('Q5Objectives')); $CPDTMReview->Q6Outcomes->setDbValue($rs->fields('Q6Outcomes')); $CPDTMReview->Q7Presentation->setDbValue($rs->fields('Q7Presentation')); $CPDTMReview->Q8Benefit->setDbValue($rs->fields('Q8Benefit')); $CPDTMReview->FinalStatus->setDbValue($rs->fields('FinalStatus')); $CPDTMReview->ChangesRequired->setDbValue($rs->fields('ChangesRequired')); $CPDTMReview->NotionalHours->setDbValue($rs->fields('NotionalHours')); $CPDTMReview->CPDCredits->setDbValue($rs->fields('CPDCredits')); } // Render row values based on field settings function RenderRow() { global $conn, $Security, $Language, $CPDTMReview; // Initialize URLs $this->ExportPrintUrl = $this->PageUrl() . "export=print&" . "CPDTMReviewID=" . urlencode($CPDTMReview->CPDTMReviewID->CurrentValue); $this->ExportHtmlUrl = $this->PageUrl() . "export=html&" . "CPDTMReviewID=" . urlencode($CPDTMReview->CPDTMReviewID->CurrentValue); $this->ExportExcelUrl = $this->PageUrl() . "export=excel&" . "CPDTMReviewID=" . urlencode($CPDTMReview->CPDTMReviewID->CurrentValue); $this->ExportWordUrl = $this->PageUrl() . "export=word&" . "CPDTMReviewID=" . urlencode($CPDTMReview->CPDTMReviewID->CurrentValue); $this->ExportXmlUrl = $this->PageUrl() . "export=xml&" . "CPDTMReviewID=" . urlencode($CPDTMReview->CPDTMReviewID->CurrentValue); $this->ExportCsvUrl = $this->PageUrl() . "export=csv&" . "CPDTMReviewID=" . urlencode($CPDTMReview->CPDTMReviewID->CurrentValue); $this->AddUrl = $CPDTMReview->AddUrl(); $this->EditUrl = $CPDTMReview->EditUrl(); $this->CopyUrl = $CPDTMReview->CopyUrl(); $this->DeleteUrl = $CPDTMReview->DeleteUrl(); $this->ListUrl = $CPDTMReview->ListUrl(); // Call Row_Rendering event $CPDTMReview->Row_Rendering(); // Common render codes for all row types // CPDTMReviewID $CPDTMReview->CPDTMReviewID->CellCssStyle = ""; $CPDTMReview->CPDTMReviewID->CellCssClass = ""; $CPDTMReview->CPDTMReviewID->CellAttrs = array(); $CPDTMReview->CPDTMReviewID->ViewAttrs = array(); $CPDTMReview->CPDTMReviewID->EditAttrs = array(); // ProviderID $CPDTMReview->ProviderID->CellCssStyle = ""; $CPDTMReview->ProviderID->CellCssClass = ""; $CPDTMReview->ProviderID->CellAttrs = array(); $CPDTMReview->ProviderID->ViewAttrs = array(); $CPDTMReview->ProviderID->EditAttrs = array(); // MaterialID $CPDTMReview->MaterialID->CellCssStyle = ""; $CPDTMReview->MaterialID->CellCssClass = ""; $CPDTMReview->MaterialID->CellAttrs = array(); $CPDTMReview->MaterialID->ViewAttrs = array(); $CPDTMReview->MaterialID->EditAttrs = array(); // CPDAssessorID $CPDTMReview->CPDAssessorID->CellCssStyle = ""; $CPDTMReview->CPDAssessorID->CellCssClass = ""; $CPDTMReview->CPDAssessorID->CellAttrs = array(); $CPDTMReview->CPDAssessorID->ViewAttrs = array(); $CPDTMReview->CPDAssessorID->EditAttrs = array(); // DateReviewed $CPDTMReview->DateReviewed->CellCssStyle = ""; $CPDTMReview->DateReviewed->CellCssClass = ""; $CPDTMReview->DateReviewed->CellAttrs = array(); $CPDTMReview->DateReviewed->ViewAttrs = array(); $CPDTMReview->DateReviewed->EditAttrs = array(); // Q1Knowledge $CPDTMReview->Q1Knowledge->CellCssStyle = ""; $CPDTMReview->Q1Knowledge->CellCssClass = ""; $CPDTMReview->Q1Knowledge->CellAttrs = array(); $CPDTMReview->Q1Knowledge->ViewAttrs = array(); $CPDTMReview->Q1Knowledge->EditAttrs = array(); // Q2Learning $CPDTMReview->Q2Learning->CellCssStyle = ""; $CPDTMReview->Q2Learning->CellCssClass = ""; $CPDTMReview->Q2Learning->CellAttrs = array(); $CPDTMReview->Q2Learning->ViewAttrs = array(); $CPDTMReview->Q2Learning->EditAttrs = array(); // Q3Depth $CPDTMReview->Q3Depth->CellCssStyle = ""; $CPDTMReview->Q3Depth->CellCssClass = ""; $CPDTMReview->Q3Depth->CellAttrs = array(); $CPDTMReview->Q3Depth->ViewAttrs = array(); $CPDTMReview->Q3Depth->EditAttrs = array(); // Q4EvalForm $CPDTMReview->Q4EvalForm->CellCssStyle = ""; $CPDTMReview->Q4EvalForm->CellCssClass = ""; $CPDTMReview->Q4EvalForm->CellAttrs = array(); $CPDTMReview->Q4EvalForm->ViewAttrs = array(); $CPDTMReview->Q4EvalForm->EditAttrs = array(); // Q5Objectives $CPDTMReview->Q5Objectives->CellCssStyle = ""; $CPDTMReview->Q5Objectives->CellCssClass = ""; $CPDTMReview->Q5Objectives->CellAttrs = array(); $CPDTMReview->Q5Objectives->ViewAttrs = array(); $CPDTMReview->Q5Objectives->EditAttrs = array(); // Q6Outcomes $CPDTMReview->Q6Outcomes->CellCssStyle = ""; $CPDTMReview->Q6Outcomes->CellCssClass = ""; $CPDTMReview->Q6Outcomes->CellAttrs = array(); $CPDTMReview->Q6Outcomes->ViewAttrs = array(); $CPDTMReview->Q6Outcomes->EditAttrs = array(); // Q7Presentation $CPDTMReview->Q7Presentation->CellCssStyle = ""; $CPDTMReview->Q7Presentation->CellCssClass = ""; $CPDTMReview->Q7Presentation->CellAttrs = array(); $CPDTMReview->Q7Presentation->ViewAttrs = array(); $CPDTMReview->Q7Presentation->EditAttrs = array(); // Q8Benefit $CPDTMReview->Q8Benefit->CellCssStyle = ""; $CPDTMReview->Q8Benefit->CellCssClass = ""; $CPDTMReview->Q8Benefit->CellAttrs = array(); $CPDTMReview->Q8Benefit->ViewAttrs = array(); $CPDTMReview->Q8Benefit->EditAttrs = array(); // FinalStatus $CPDTMReview->FinalStatus->CellCssStyle = ""; $CPDTMReview->FinalStatus->CellCssClass = ""; $CPDTMReview->FinalStatus->CellAttrs = array(); $CPDTMReview->FinalStatus->ViewAttrs = array(); $CPDTMReview->FinalStatus->EditAttrs = array(); // ChangesRequired $CPDTMReview->ChangesRequired->CellCssStyle = ""; $CPDTMReview->ChangesRequired->CellCssClass = ""; $CPDTMReview->ChangesRequired->CellAttrs = array(); $CPDTMReview->ChangesRequired->ViewAttrs = array(); $CPDTMReview->ChangesRequired->EditAttrs = array(); // NotionalHours $CPDTMReview->NotionalHours->CellCssStyle = ""; $CPDTMReview->NotionalHours->CellCssClass = ""; $CPDTMReview->NotionalHours->CellAttrs = array(); $CPDTMReview->NotionalHours->ViewAttrs = array(); $CPDTMReview->NotionalHours->EditAttrs = array(); // CPDCredits $CPDTMReview->CPDCredits->CellCssStyle = ""; $CPDTMReview->CPDCredits->CellCssClass = ""; $CPDTMReview->CPDCredits->CellAttrs = array(); $CPDTMReview->CPDCredits->ViewAttrs = array(); $CPDTMReview->CPDCredits->EditAttrs = array(); if ($CPDTMReview->RowType == EW_ROWTYPE_VIEW) { // View row // CPDTMReviewID $CPDTMReview->CPDTMReviewID->ViewValue = $CPDTMReview->CPDTMReviewID->CurrentValue; $CPDTMReview->CPDTMReviewID->CssStyle = ""; $CPDTMReview->CPDTMReviewID->CssClass = ""; $CPDTMReview->CPDTMReviewID->ViewCustomAttributes = ""; // ProviderID if (strval($CPDTMReview->ProviderID->CurrentValue) <> "") { $sFilterWrk = "`CPDProviderID` = " . ew_AdjustSql($CPDTMReview->ProviderID->CurrentValue) . ""; $sSqlWrk = "SELECT `CompanyName` FROM `CPDServiceProvider`"; $sWhereWrk = ""; 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 $CPDTMReview->ProviderID->ViewValue = $rswrk->fields('CompanyName'); $rswrk->Close(); } else { $CPDTMReview->ProviderID->ViewValue = $CPDTMReview->ProviderID->CurrentValue; } } else { $CPDTMReview->ProviderID->ViewValue = NULL; } $CPDTMReview->ProviderID->CssStyle = ""; $CPDTMReview->ProviderID->CssClass = ""; $CPDTMReview->ProviderID->ViewCustomAttributes = ""; // MaterialID if (strval($CPDTMReview->MaterialID->CurrentValue) <> "") { $sFilterWrk = "`MaterialID` = " . ew_AdjustSql($CPDTMReview->MaterialID->CurrentValue) . ""; $sSqlWrk = "SELECT `Subject`, `AccredNum` FROM `CPDTrainingMaterial`"; $sWhereWrk = ""; if ($sFilterWrk <> "") { if ($sWhereWrk <> "") $sWhereWrk .= " AND "; $sWhereWrk .= "(" . $sFilterWrk . ")"; } if ($sWhereWrk <> "") $sSqlWrk .= " WHERE " . $sWhereWrk; $sSqlWrk .= " ORDER BY `Subject`"; $rswrk = $conn->Execute($sSqlWrk); if ($rswrk && !$rswrk->EOF) { // Lookup values found $CPDTMReview->MaterialID->ViewValue = $rswrk->fields('Subject'); $CPDTMReview->MaterialID->ViewValue .= ew_ValueSeparator(0) . $rswrk->fields('AccredNum'); $rswrk->Close(); } else { $CPDTMReview->MaterialID->ViewValue = $CPDTMReview->MaterialID->CurrentValue; } } else { $CPDTMReview->MaterialID->ViewValue = NULL; } $CPDTMReview->MaterialID->CssStyle = ""; $CPDTMReview->MaterialID->CssClass = ""; $CPDTMReview->MaterialID->ViewCustomAttributes = ""; // CPDAssessorID if (strval($CPDTMReview->CPDAssessorID->CurrentValue) <> "") { $sFilterWrk = "`CPDAssessorID` = " . ew_AdjustSql($CPDTMReview->CPDAssessorID->CurrentValue) . ""; $sSqlWrk = "SELECT `Surname`, `FirstName` FROM `CPDAssessors`"; $sWhereWrk = ""; if ($sWhereWrk <> "") $sWhereWrk .= " AND "; $sWhereWrk .= "(" . CPDFilterAssessorList() . ")"; 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 $CPDTMReview->CPDAssessorID->ViewValue = $rswrk->fields('Surname'); $CPDTMReview->CPDAssessorID->ViewValue .= ew_ValueSeparator(0) . $rswrk->fields('FirstName'); $rswrk->Close(); } else { $CPDTMReview->CPDAssessorID->ViewValue = $CPDTMReview->CPDAssessorID->CurrentValue; } } else { $CPDTMReview->CPDAssessorID->ViewValue = NULL; } $CPDTMReview->CPDAssessorID->CssStyle = ""; $CPDTMReview->CPDAssessorID->CssClass = ""; $CPDTMReview->CPDAssessorID->ViewCustomAttributes = ""; // DateReviewed $CPDTMReview->DateReviewed->ViewValue = $CPDTMReview->DateReviewed->CurrentValue; $CPDTMReview->DateReviewed->ViewValue = ew_FormatDateTime($CPDTMReview->DateReviewed->ViewValue, 5); $CPDTMReview->DateReviewed->CssStyle = ""; $CPDTMReview->DateReviewed->CssClass = ""; $CPDTMReview->DateReviewed->ViewCustomAttributes = ""; // Q1Knowledge if (strval($CPDTMReview->Q1Knowledge->CurrentValue) <> "") { switch ($CPDTMReview->Q1Knowledge->CurrentValue) { case "a": $CPDTMReview->Q1Knowledge->ViewValue = "Acceptable"; break; case "i": $CPDTMReview->Q1Knowledge->ViewValue = "Inadequate"; break; default: $CPDTMReview->Q1Knowledge->ViewValue = $CPDTMReview->Q1Knowledge->CurrentValue; } } else { $CPDTMReview->Q1Knowledge->ViewValue = NULL; } $CPDTMReview->Q1Knowledge->CssStyle = ""; $CPDTMReview->Q1Knowledge->CssClass = ""; $CPDTMReview->Q1Knowledge->ViewCustomAttributes = ""; // Q2Learning if (strval($CPDTMReview->Q2Learning->CurrentValue) <> "") { switch ($CPDTMReview->Q2Learning->CurrentValue) { case "a": $CPDTMReview->Q2Learning->ViewValue = "Acceptable"; break; case "i": $CPDTMReview->Q2Learning->ViewValue = "Inadequate"; break; default: $CPDTMReview->Q2Learning->ViewValue = $CPDTMReview->Q2Learning->CurrentValue; } } else { $CPDTMReview->Q2Learning->ViewValue = NULL; } $CPDTMReview->Q2Learning->CssStyle = ""; $CPDTMReview->Q2Learning->CssClass = ""; $CPDTMReview->Q2Learning->ViewCustomAttributes = ""; // Q3Depth if (strval($CPDTMReview->Q3Depth->CurrentValue) <> "") { switch ($CPDTMReview->Q3Depth->CurrentValue) { case "a": $CPDTMReview->Q3Depth->ViewValue = "Acceptable"; break; case "i": $CPDTMReview->Q3Depth->ViewValue = "Inadequate"; break; default: $CPDTMReview->Q3Depth->ViewValue = $CPDTMReview->Q3Depth->CurrentValue; } } else { $CPDTMReview->Q3Depth->ViewValue = NULL; } $CPDTMReview->Q3Depth->CssStyle = ""; $CPDTMReview->Q3Depth->CssClass = ""; $CPDTMReview->Q3Depth->ViewCustomAttributes = ""; // Q4EvalForm if (strval($CPDTMReview->Q4EvalForm->CurrentValue) <> "") { switch ($CPDTMReview->Q4EvalForm->CurrentValue) { case "a": $CPDTMReview->Q4EvalForm->ViewValue = "Acceptable"; break; case "i": $CPDTMReview->Q4EvalForm->ViewValue = "Inadequate"; break; default: $CPDTMReview->Q4EvalForm->ViewValue = $CPDTMReview->Q4EvalForm->CurrentValue; } } else { $CPDTMReview->Q4EvalForm->ViewValue = NULL; } $CPDTMReview->Q4EvalForm->CssStyle = ""; $CPDTMReview->Q4EvalForm->CssClass = ""; $CPDTMReview->Q4EvalForm->ViewCustomAttributes = ""; // Q5Objectives if (strval($CPDTMReview->Q5Objectives->CurrentValue) <> "") { switch ($CPDTMReview->Q5Objectives->CurrentValue) { case "a": $CPDTMReview->Q5Objectives->ViewValue = "Acceptable"; break; case "i": $CPDTMReview->Q5Objectives->ViewValue = "Inadequate"; break; default: $CPDTMReview->Q5Objectives->ViewValue = $CPDTMReview->Q5Objectives->CurrentValue; } } else { $CPDTMReview->Q5Objectives->ViewValue = NULL; } $CPDTMReview->Q5Objectives->CssStyle = ""; $CPDTMReview->Q5Objectives->CssClass = ""; $CPDTMReview->Q5Objectives->ViewCustomAttributes = ""; // Q6Outcomes if (strval($CPDTMReview->Q6Outcomes->CurrentValue) <> "") { switch ($CPDTMReview->Q6Outcomes->CurrentValue) { case "a": $CPDTMReview->Q6Outcomes->ViewValue = "Acceptable"; break; case "i": $CPDTMReview->Q6Outcomes->ViewValue = "Inadequate"; break; default: $CPDTMReview->Q6Outcomes->ViewValue = $CPDTMReview->Q6Outcomes->CurrentValue; } } else { $CPDTMReview->Q6Outcomes->ViewValue = NULL; } $CPDTMReview->Q6Outcomes->CssStyle = ""; $CPDTMReview->Q6Outcomes->CssClass = ""; $CPDTMReview->Q6Outcomes->ViewCustomAttributes = ""; // Q7Presentation if (strval($CPDTMReview->Q7Presentation->CurrentValue) <> "") { switch ($CPDTMReview->Q7Presentation->CurrentValue) { case "a": $CPDTMReview->Q7Presentation->ViewValue = "Acceptable"; break; case "i": $CPDTMReview->Q7Presentation->ViewValue = "Inadequate"; break; default: $CPDTMReview->Q7Presentation->ViewValue = $CPDTMReview->Q7Presentation->CurrentValue; } } else { $CPDTMReview->Q7Presentation->ViewValue = NULL; } $CPDTMReview->Q7Presentation->CssStyle = ""; $CPDTMReview->Q7Presentation->CssClass = ""; $CPDTMReview->Q7Presentation->ViewCustomAttributes = ""; // Q8Benefit if (strval($CPDTMReview->Q8Benefit->CurrentValue) <> "") { switch ($CPDTMReview->Q8Benefit->CurrentValue) { case "a": $CPDTMReview->Q8Benefit->ViewValue = "Acceptable"; break; case "i": $CPDTMReview->Q8Benefit->ViewValue = "Inadequate"; break; default: $CPDTMReview->Q8Benefit->ViewValue = $CPDTMReview->Q8Benefit->CurrentValue; } } else { $CPDTMReview->Q8Benefit->ViewValue = NULL; } $CPDTMReview->Q8Benefit->CssStyle = ""; $CPDTMReview->Q8Benefit->CssClass = ""; $CPDTMReview->Q8Benefit->ViewCustomAttributes = ""; // FinalStatus if (strval($CPDTMReview->FinalStatus->CurrentValue) <> "") { switch ($CPDTMReview->FinalStatus->CurrentValue) { case "a": $CPDTMReview->FinalStatus->ViewValue = "Approved"; break; case "d": $CPDTMReview->FinalStatus->ViewValue = "Declined"; break; case "c": $CPDTMReview->FinalStatus->ViewValue = "Approved Pending Changes"; break; default: $CPDTMReview->FinalStatus->ViewValue = $CPDTMReview->FinalStatus->CurrentValue; } } else { $CPDTMReview->FinalStatus->ViewValue = NULL; } $CPDTMReview->FinalStatus->CssStyle = ""; $CPDTMReview->FinalStatus->CssClass = ""; $CPDTMReview->FinalStatus->ViewCustomAttributes = ""; // ChangesRequired $CPDTMReview->ChangesRequired->ViewValue = $CPDTMReview->ChangesRequired->CurrentValue; $CPDTMReview->ChangesRequired->CssStyle = ""; $CPDTMReview->ChangesRequired->CssClass = ""; $CPDTMReview->ChangesRequired->ViewCustomAttributes = ""; // NotionalHours $CPDTMReview->NotionalHours->ViewValue = $CPDTMReview->NotionalHours->CurrentValue; $CPDTMReview->NotionalHours->CssStyle = ""; $CPDTMReview->NotionalHours->CssClass = ""; $CPDTMReview->NotionalHours->ViewCustomAttributes = ""; // CPDCredits $CPDTMReview->CPDCredits->ViewValue = $CPDTMReview->CPDCredits->CurrentValue; $CPDTMReview->CPDCredits->CssStyle = ""; $CPDTMReview->CPDCredits->CssClass = ""; $CPDTMReview->CPDCredits->ViewCustomAttributes = ""; // CPDTMReviewID $CPDTMReview->CPDTMReviewID->HrefValue = ""; $CPDTMReview->CPDTMReviewID->TooltipValue = ""; // ProviderID $CPDTMReview->ProviderID->HrefValue = ""; $CPDTMReview->ProviderID->TooltipValue = ""; // MaterialID $CPDTMReview->MaterialID->HrefValue = ""; $CPDTMReview->MaterialID->TooltipValue = ""; // CPDAssessorID $CPDTMReview->CPDAssessorID->HrefValue = ""; $CPDTMReview->CPDAssessorID->TooltipValue = ""; // DateReviewed $CPDTMReview->DateReviewed->HrefValue = ""; $CPDTMReview->DateReviewed->TooltipValue = ""; // Q1Knowledge $CPDTMReview->Q1Knowledge->HrefValue = ""; $CPDTMReview->Q1Knowledge->TooltipValue = ""; // Q2Learning $CPDTMReview->Q2Learning->HrefValue = ""; $CPDTMReview->Q2Learning->TooltipValue = ""; // Q3Depth $CPDTMReview->Q3Depth->HrefValue = ""; $CPDTMReview->Q3Depth->TooltipValue = ""; // Q4EvalForm $CPDTMReview->Q4EvalForm->HrefValue = ""; $CPDTMReview->Q4EvalForm->TooltipValue = ""; // Q5Objectives $CPDTMReview->Q5Objectives->HrefValue = ""; $CPDTMReview->Q5Objectives->TooltipValue = ""; // Q6Outcomes $CPDTMReview->Q6Outcomes->HrefValue = ""; $CPDTMReview->Q6Outcomes->TooltipValue = ""; // Q7Presentation $CPDTMReview->Q7Presentation->HrefValue = ""; $CPDTMReview->Q7Presentation->TooltipValue = ""; // Q8Benefit $CPDTMReview->Q8Benefit->HrefValue = ""; $CPDTMReview->Q8Benefit->TooltipValue = ""; // FinalStatus $CPDTMReview->FinalStatus->HrefValue = ""; $CPDTMReview->FinalStatus->TooltipValue = ""; // ChangesRequired $CPDTMReview->ChangesRequired->HrefValue = ""; $CPDTMReview->ChangesRequired->TooltipValue = ""; // NotionalHours $CPDTMReview->NotionalHours->HrefValue = ""; $CPDTMReview->NotionalHours->TooltipValue = ""; // CPDCredits $CPDTMReview->CPDCredits->HrefValue = ""; $CPDTMReview->CPDCredits->TooltipValue = ""; } // Call Row Rendered event if ($CPDTMReview->RowType <> EW_ROWTYPE_AGGREGATEINIT) $CPDTMReview->Row_Rendered(); } // Export data in HTML/CSV/Word/Excel/XML/Email format function ExportData() { global $CPDTMReview; $utf8 = FALSE; $bSelectLimit = FALSE; // Load recordset if ($bSelectLimit) { $this->lTotalRecs = $CPDTMReview->SelectRecordCount(); } else { if ($rs = $this->LoadRecordset()) $this->lTotalRecs = $rs->RecordCount(); } $this->lStartRec = 1; $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 (!$rs) { header("Content-Type:"); // Remove header header("Content-Disposition:"); $this->ShowMessage(); return; } if ($CPDTMReview->Export == "xml") { $XmlDoc = new cXMLDocument(EW_XML_ENCODING); $XmlDoc->AddRoot(); } else { $ExportDoc = new cExportDocument($CPDTMReview, "v"); $ExportDoc->ExportHeader(); if ($ExportDoc->Horizontal) { // Horizontal format, write header $ExportDoc->BeginExportRow(); $ExportDoc->ExportCaption($CPDTMReview->CPDTMReviewID); $ExportDoc->ExportCaption($CPDTMReview->ProviderID); $ExportDoc->ExportCaption($CPDTMReview->MaterialID); $ExportDoc->ExportCaption($CPDTMReview->CPDAssessorID); $ExportDoc->ExportCaption($CPDTMReview->DateReviewed); $ExportDoc->ExportCaption($CPDTMReview->Q1Knowledge); $ExportDoc->ExportCaption($CPDTMReview->Q2Learning); $ExportDoc->ExportCaption($CPDTMReview->Q3Depth); $ExportDoc->ExportCaption($CPDTMReview->Q4EvalForm); $ExportDoc->ExportCaption($CPDTMReview->Q5Objectives); $ExportDoc->ExportCaption($CPDTMReview->Q6Outcomes); $ExportDoc->ExportCaption($CPDTMReview->Q7Presentation); $ExportDoc->ExportCaption($CPDTMReview->Q8Benefit); $ExportDoc->ExportCaption($CPDTMReview->FinalStatus); $ExportDoc->ExportCaption($CPDTMReview->NotionalHours); $ExportDoc->ExportCaption($CPDTMReview->CPDCredits); $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 $CPDTMReview->CssClass = ""; $CPDTMReview->CssStyle = ""; $CPDTMReview->RowType = EW_ROWTYPE_VIEW; // Render view $this->RenderRow(); if ($CPDTMReview->Export == "xml") { $XmlDoc->AddRow(); $XmlDoc->AddField('CPDTMReviewID', $CPDTMReview->CPDTMReviewID->ExportValue($CPDTMReview->Export, $CPDTMReview->ExportOriginalValue)); $XmlDoc->AddField('ProviderID', $CPDTMReview->ProviderID->ExportValue($CPDTMReview->Export, $CPDTMReview->ExportOriginalValue)); $XmlDoc->AddField('MaterialID', $CPDTMReview->MaterialID->ExportValue($CPDTMReview->Export, $CPDTMReview->ExportOriginalValue)); $XmlDoc->AddField('CPDAssessorID', $CPDTMReview->CPDAssessorID->ExportValue($CPDTMReview->Export, $CPDTMReview->ExportOriginalValue)); $XmlDoc->AddField('DateReviewed', $CPDTMReview->DateReviewed->ExportValue($CPDTMReview->Export, $CPDTMReview->ExportOriginalValue)); $XmlDoc->AddField('Q1Knowledge', $CPDTMReview->Q1Knowledge->ExportValue($CPDTMReview->Export, $CPDTMReview->ExportOriginalValue)); $XmlDoc->AddField('Q2Learning', $CPDTMReview->Q2Learning->ExportValue($CPDTMReview->Export, $CPDTMReview->ExportOriginalValue)); $XmlDoc->AddField('Q3Depth', $CPDTMReview->Q3Depth->ExportValue($CPDTMReview->Export, $CPDTMReview->ExportOriginalValue)); $XmlDoc->AddField('Q4EvalForm', $CPDTMReview->Q4EvalForm->ExportValue($CPDTMReview->Export, $CPDTMReview->ExportOriginalValue)); $XmlDoc->AddField('Q5Objectives', $CPDTMReview->Q5Objectives->ExportValue($CPDTMReview->Export, $CPDTMReview->ExportOriginalValue)); $XmlDoc->AddField('Q6Outcomes', $CPDTMReview->Q6Outcomes->ExportValue($CPDTMReview->Export, $CPDTMReview->ExportOriginalValue)); $XmlDoc->AddField('Q7Presentation', $CPDTMReview->Q7Presentation->ExportValue($CPDTMReview->Export, $CPDTMReview->ExportOriginalValue)); $XmlDoc->AddField('Q8Benefit', $CPDTMReview->Q8Benefit->ExportValue($CPDTMReview->Export, $CPDTMReview->ExportOriginalValue)); $XmlDoc->AddField('FinalStatus', $CPDTMReview->FinalStatus->ExportValue($CPDTMReview->Export, $CPDTMReview->ExportOriginalValue)); $XmlDoc->AddField('NotionalHours', $CPDTMReview->NotionalHours->ExportValue($CPDTMReview->Export, $CPDTMReview->ExportOriginalValue)); $XmlDoc->AddField('CPDCredits', $CPDTMReview->CPDCredits->ExportValue($CPDTMReview->Export, $CPDTMReview->ExportOriginalValue)); } else { $ExportDoc->BeginExportRow(TRUE); // Allow CSS styles if enabled $ExportDoc->ExportField($CPDTMReview->CPDTMReviewID); $ExportDoc->ExportField($CPDTMReview->ProviderID); $ExportDoc->ExportField($CPDTMReview->MaterialID); $ExportDoc->ExportField($CPDTMReview->CPDAssessorID); $ExportDoc->ExportField($CPDTMReview->DateReviewed); $ExportDoc->ExportField($CPDTMReview->Q1Knowledge); $ExportDoc->ExportField($CPDTMReview->Q2Learning); $ExportDoc->ExportField($CPDTMReview->Q3Depth); $ExportDoc->ExportField($CPDTMReview->Q4EvalForm); $ExportDoc->ExportField($CPDTMReview->Q5Objectives); $ExportDoc->ExportField($CPDTMReview->Q6Outcomes); $ExportDoc->ExportField($CPDTMReview->Q7Presentation); $ExportDoc->ExportField($CPDTMReview->Q8Benefit); $ExportDoc->ExportField($CPDTMReview->FinalStatus); $ExportDoc->ExportField($CPDTMReview->NotionalHours); $ExportDoc->ExportField($CPDTMReview->CPDCredits); $ExportDoc->EndExportRow(); } } $rs->MoveNext(); } if ($CPDTMReview->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($CPDTMReview->Export, array("email", "xml"))) echo "\xEF\xBB\xBF"; // Write debug message if enabled if (EW_DEBUG_ENABLED) echo ew_DebugMsg(); // Output data if ($CPDTMReview->Export == "xml") { header("Content-Type: text/xml"); echo $XmlDoc->XML(); } elseif ($CPDTMReview->Export == "email") { $this->ExportEmail($ExportDoc->Text); $this->Page_Terminate($CPDTMReview->ExportReturnUrl()); } else { echo $ExportDoc->Text; } } // Export email function ExportEmail($EmailContent) { global $Language, $CPDTMReview; $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 ($CPDTMReview->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 $CPDTMReview; // Initialize $sQry = "export=html"; // Add record key QueryString $sQry .= "&" . substr($CPDTMReview->KeyUrl("", ""), 1); return $sQry; } // 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"; } } ?>