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 05:49
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_edit = new cCPDTMReview_edit(); $Page =& $CPDTMReview_edit; // Page init $CPDTMReview_edit->Page_Init(); // Page main $CPDTMReview_edit->Page_Main(); ?> <?php include "header.php" ?> <script type="text/javascript"> <!-- // Create page object var CPDTMReview_edit = new ew_Page("CPDTMReview_edit"); // page properties CPDTMReview_edit.PageID = "edit"; // page ID CPDTMReview_edit.FormID = "fCPDTMReviewedit"; // form ID var EW_PAGE_ID = CPDTMReview_edit.PageID; // for backward compatibility // extend page with ValidateForm function CPDTMReview_edit.ValidateForm = function(fobj) { ew_PostAutoSuggest(fobj); if (!this.ValidateRequired) return true; // ignore validation if (fobj.a_confirm && fobj.a_confirm.value == "F") return true; var i, elm, aelm, infix; var rowcnt = (fobj.key_count) ? Number(fobj.key_count.value) : 1; for (i=0; i<rowcnt; i++) { infix = (fobj.key_count) ? String(i+1) : ""; elm = fobj.elements["x" + infix + "_DateReviewed"]; if (elm && !ew_HasValue(elm)) return ew_OnError(this, elm, ewLanguage.Phrase("EnterRequiredField") + " - <?php echo ew_JsEncode2($CPDTMReview->DateReviewed->FldCaption()) ?>"); elm = fobj.elements["x" + infix + "_DateReviewed"]; if (elm && !ew_CheckDate(elm.value)) return ew_OnError(this, elm, "<?php echo ew_JsEncode2($CPDTMReview->DateReviewed->FldErrMsg()) ?>"); elm = fobj.elements["x" + infix + "_NotionalHours"]; if (elm && !ew_CheckInteger(elm.value)) return ew_OnError(this, elm, "<?php echo ew_JsEncode2($CPDTMReview->NotionalHours->FldErrMsg()) ?>"); elm = fobj.elements["x" + infix + "_CPDCredits"]; if (elm && !ew_CheckInteger(elm.value)) return ew_OnError(this, elm, "<?php echo ew_JsEncode2($CPDTMReview->CPDCredits->FldErrMsg()) ?>"); // Call Form Custom Validate event if (!this.Form_CustomValidate(fobj)) return false; } return true; } // extend page with Form_CustomValidate function CPDTMReview_edit.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_edit.ValidateRequired = true; // uses JavaScript validation <?php } else { ?> CPDTMReview_edit.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> <p><span class="phpmaker"><?php echo $Language->Phrase("Edit") ?> <?php echo $Language->Phrase("TblTypeTABLE") ?><?php echo $CPDTMReview->TableCaption() ?><br><br> <a href="<?php echo $CPDTMReview->getReturnUrl() ?>"><?php echo $Language->Phrase("GoBack") ?></a></span></p> <?php if (EW_DEBUG_ENABLED) echo ew_DebugMsg(); $CPDTMReview_edit->ShowMessage(); ?> <form name="fCPDTMReviewedit" id="fCPDTMReviewedit" action="<?php echo ew_CurrentPage() ?>" method="post" onsubmit="return CPDTMReview_edit.ValidateForm(this);"> <p> <input type="hidden" name="a_table" id="a_table" value="CPDTMReview"> <input type="hidden" name="a_edit" id="a_edit" value="U"> <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() ?>><span id="el_CPDTMReviewID"> <div<?php echo $CPDTMReview->CPDTMReviewID->ViewAttributes() ?>><?php echo $CPDTMReview->CPDTMReviewID->EditValue ?></div><input type="hidden" name="x_CPDTMReviewID" id="x_CPDTMReviewID" value="<?php echo ew_HtmlEncode($CPDTMReview->CPDTMReviewID->CurrentValue) ?>"> </span><?php echo $CPDTMReview->CPDTMReviewID->CustomMsg ?></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() ?>><span id="el_ProviderID"> <div<?php echo $CPDTMReview->ProviderID->ViewAttributes() ?>><?php echo $CPDTMReview->ProviderID->EditValue ?></div><input type="hidden" name="x_ProviderID" id="x_ProviderID" value="<?php echo ew_HtmlEncode($CPDTMReview->ProviderID->CurrentValue) ?>"> </span><?php echo $CPDTMReview->ProviderID->CustomMsg ?></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() ?>><span id="el_MaterialID"> <div<?php echo $CPDTMReview->MaterialID->ViewAttributes() ?>><?php echo $CPDTMReview->MaterialID->EditValue ?></div><input type="hidden" name="x_MaterialID" id="x_MaterialID" value="<?php echo ew_HtmlEncode($CPDTMReview->MaterialID->CurrentValue) ?>"> </span><?php echo $CPDTMReview->MaterialID->CustomMsg ?></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() ?>><span id="el_CPDAssessorID"> <select id="x_CPDAssessorID" name="x_CPDAssessorID" title="<?php echo $CPDTMReview->CPDAssessorID->FldTitle() ?>"<?php echo $CPDTMReview->CPDAssessorID->EditAttributes() ?>> <?php if (is_array($CPDTMReview->CPDAssessorID->EditValue)) { $arwrk = $CPDTMReview->CPDAssessorID->EditValue; $rowswrk = count($arwrk); $emptywrk = TRUE; for ($rowcntwrk = 0; $rowcntwrk < $rowswrk; $rowcntwrk++) { $selwrk = (strval($CPDTMReview->CPDAssessorID->CurrentValue) == strval($arwrk[$rowcntwrk][0])) ? " selected=\"selected\"" : ""; if ($selwrk <> "") $emptywrk = FALSE; ?> <option value="<?php echo ew_HtmlEncode($arwrk[$rowcntwrk][0]) ?>"<?php echo $selwrk ?>> <?php echo $arwrk[$rowcntwrk][1] ?> <?php if ($arwrk[$rowcntwrk][2] <> "") { ?> <?php echo ew_ValueSeparator($rowcntwrk) ?><?php echo $arwrk[$rowcntwrk][2] ?> <?php } ?> </option> <?php } } ?> </select> </span><?php echo $CPDTMReview->CPDAssessorID->CustomMsg ?></td> </tr> <?php } ?> <?php if ($CPDTMReview->DateReviewed->Visible) { // DateReviewed ?> <tr<?php echo $CPDTMReview->RowAttributes() ?>> <td class="ewTableHeader"><?php echo $CPDTMReview->DateReviewed->FldCaption() ?><?php echo $Language->Phrase("FieldRequiredIndicator") ?></td> <td<?php echo $CPDTMReview->DateReviewed->CellAttributes() ?>><span id="el_DateReviewed"> <input type="text" name="x_DateReviewed" id="x_DateReviewed" title="<?php echo $CPDTMReview->DateReviewed->FldTitle() ?>" value="<?php echo $CPDTMReview->DateReviewed->EditValue ?>"<?php echo $CPDTMReview->DateReviewed->EditAttributes() ?>> <img src="images/calendar.png" id="cal_x_DateReviewed" name="cal_x_DateReviewed" 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_DateReviewed", // input field id ifFormat: "%Y/%m/%d", // date format button: "cal_x_DateReviewed" // button id }); </script> </span><?php echo $CPDTMReview->DateReviewed->CustomMsg ?></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() ?>><span id="el_Q1Knowledge"> <div id="tp_x_Q1Knowledge" class="<?php echo EW_ITEM_TEMPLATE_CLASSNAME ?>"><label><input type="radio" name="x_Q1Knowledge" id="x_Q1Knowledge" title="<?php echo $CPDTMReview->Q1Knowledge->FldTitle() ?>" value="{value}"<?php echo $CPDTMReview->Q1Knowledge->EditAttributes() ?>></label></div> <div id="dsl_x_Q1Knowledge" repeatcolumn="5"> <?php $arwrk = $CPDTMReview->Q1Knowledge->EditValue; if (is_array($arwrk)) { $rowswrk = count($arwrk); $emptywrk = TRUE; for ($rowcntwrk = 0; $rowcntwrk < $rowswrk; $rowcntwrk++) { $selwrk = (strval($CPDTMReview->Q1Knowledge->CurrentValue) == 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_Q1Knowledge" id="x_Q1Knowledge" title="<?php echo $CPDTMReview->Q1Knowledge->FldTitle() ?>" value="<?php echo ew_HtmlEncode($arwrk[$rowcntwrk][0]) ?>"<?php echo $selwrk ?><?php echo $CPDTMReview->Q1Knowledge->EditAttributes() ?>><?php echo $arwrk[$rowcntwrk][1] ?></label> <?php echo ew_RepeatColumnTable($rowswrk, $rowcntwrk, 5, 2) ?> <?php } } ?> </div> </span><?php echo $CPDTMReview->Q1Knowledge->CustomMsg ?></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() ?>><span id="el_Q2Learning"> <div id="tp_x_Q2Learning" class="<?php echo EW_ITEM_TEMPLATE_CLASSNAME ?>"><label><input type="radio" name="x_Q2Learning" id="x_Q2Learning" title="<?php echo $CPDTMReview->Q2Learning->FldTitle() ?>" value="{value}"<?php echo $CPDTMReview->Q2Learning->EditAttributes() ?>></label></div> <div id="dsl_x_Q2Learning" repeatcolumn="5"> <?php $arwrk = $CPDTMReview->Q2Learning->EditValue; if (is_array($arwrk)) { $rowswrk = count($arwrk); $emptywrk = TRUE; for ($rowcntwrk = 0; $rowcntwrk < $rowswrk; $rowcntwrk++) { $selwrk = (strval($CPDTMReview->Q2Learning->CurrentValue) == 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_Q2Learning" id="x_Q2Learning" title="<?php echo $CPDTMReview->Q2Learning->FldTitle() ?>" value="<?php echo ew_HtmlEncode($arwrk[$rowcntwrk][0]) ?>"<?php echo $selwrk ?><?php echo $CPDTMReview->Q2Learning->EditAttributes() ?>><?php echo $arwrk[$rowcntwrk][1] ?></label> <?php echo ew_RepeatColumnTable($rowswrk, $rowcntwrk, 5, 2) ?> <?php } } ?> </div> </span><?php echo $CPDTMReview->Q2Learning->CustomMsg ?></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() ?>><span id="el_Q3Depth"> <div id="tp_x_Q3Depth" class="<?php echo EW_ITEM_TEMPLATE_CLASSNAME ?>"><label><input type="radio" name="x_Q3Depth" id="x_Q3Depth" title="<?php echo $CPDTMReview->Q3Depth->FldTitle() ?>" value="{value}"<?php echo $CPDTMReview->Q3Depth->EditAttributes() ?>></label></div> <div id="dsl_x_Q3Depth" repeatcolumn="5"> <?php $arwrk = $CPDTMReview->Q3Depth->EditValue; if (is_array($arwrk)) { $rowswrk = count($arwrk); $emptywrk = TRUE; for ($rowcntwrk = 0; $rowcntwrk < $rowswrk; $rowcntwrk++) { $selwrk = (strval($CPDTMReview->Q3Depth->CurrentValue) == 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_Q3Depth" id="x_Q3Depth" title="<?php echo $CPDTMReview->Q3Depth->FldTitle() ?>" value="<?php echo ew_HtmlEncode($arwrk[$rowcntwrk][0]) ?>"<?php echo $selwrk ?><?php echo $CPDTMReview->Q3Depth->EditAttributes() ?>><?php echo $arwrk[$rowcntwrk][1] ?></label> <?php echo ew_RepeatColumnTable($rowswrk, $rowcntwrk, 5, 2) ?> <?php } } ?> </div> </span><?php echo $CPDTMReview->Q3Depth->CustomMsg ?></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() ?>><span id="el_Q4EvalForm"> <div id="tp_x_Q4EvalForm" class="<?php echo EW_ITEM_TEMPLATE_CLASSNAME ?>"><label><input type="radio" name="x_Q4EvalForm" id="x_Q4EvalForm" title="<?php echo $CPDTMReview->Q4EvalForm->FldTitle() ?>" value="{value}"<?php echo $CPDTMReview->Q4EvalForm->EditAttributes() ?>></label></div> <div id="dsl_x_Q4EvalForm" repeatcolumn="5"> <?php $arwrk = $CPDTMReview->Q4EvalForm->EditValue; if (is_array($arwrk)) { $rowswrk = count($arwrk); $emptywrk = TRUE; for ($rowcntwrk = 0; $rowcntwrk < $rowswrk; $rowcntwrk++) { $selwrk = (strval($CPDTMReview->Q4EvalForm->CurrentValue) == 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_Q4EvalForm" id="x_Q4EvalForm" title="<?php echo $CPDTMReview->Q4EvalForm->FldTitle() ?>" value="<?php echo ew_HtmlEncode($arwrk[$rowcntwrk][0]) ?>"<?php echo $selwrk ?><?php echo $CPDTMReview->Q4EvalForm->EditAttributes() ?>><?php echo $arwrk[$rowcntwrk][1] ?></label> <?php echo ew_RepeatColumnTable($rowswrk, $rowcntwrk, 5, 2) ?> <?php } } ?> </div> </span><?php echo $CPDTMReview->Q4EvalForm->CustomMsg ?></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() ?>><span id="el_Q5Objectives"> <div id="tp_x_Q5Objectives" class="<?php echo EW_ITEM_TEMPLATE_CLASSNAME ?>"><label><input type="radio" name="x_Q5Objectives" id="x_Q5Objectives" title="<?php echo $CPDTMReview->Q5Objectives->FldTitle() ?>" value="{value}"<?php echo $CPDTMReview->Q5Objectives->EditAttributes() ?>></label></div> <div id="dsl_x_Q5Objectives" repeatcolumn="5"> <?php $arwrk = $CPDTMReview->Q5Objectives->EditValue; if (is_array($arwrk)) { $rowswrk = count($arwrk); $emptywrk = TRUE; for ($rowcntwrk = 0; $rowcntwrk < $rowswrk; $rowcntwrk++) { $selwrk = (strval($CPDTMReview->Q5Objectives->CurrentValue) == 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_Q5Objectives" id="x_Q5Objectives" title="<?php echo $CPDTMReview->Q5Objectives->FldTitle() ?>" value="<?php echo ew_HtmlEncode($arwrk[$rowcntwrk][0]) ?>"<?php echo $selwrk ?><?php echo $CPDTMReview->Q5Objectives->EditAttributes() ?>><?php echo $arwrk[$rowcntwrk][1] ?></label> <?php echo ew_RepeatColumnTable($rowswrk, $rowcntwrk, 5, 2) ?> <?php } } ?> </div> </span><?php echo $CPDTMReview->Q5Objectives->CustomMsg ?></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() ?>><span id="el_Q6Outcomes"> <div id="tp_x_Q6Outcomes" class="<?php echo EW_ITEM_TEMPLATE_CLASSNAME ?>"><label><input type="radio" name="x_Q6Outcomes" id="x_Q6Outcomes" title="<?php echo $CPDTMReview->Q6Outcomes->FldTitle() ?>" value="{value}"<?php echo $CPDTMReview->Q6Outcomes->EditAttributes() ?>></label></div> <div id="dsl_x_Q6Outcomes" repeatcolumn="5"> <?php $arwrk = $CPDTMReview->Q6Outcomes->EditValue; if (is_array($arwrk)) { $rowswrk = count($arwrk); $emptywrk = TRUE; for ($rowcntwrk = 0; $rowcntwrk < $rowswrk; $rowcntwrk++) { $selwrk = (strval($CPDTMReview->Q6Outcomes->CurrentValue) == 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_Q6Outcomes" id="x_Q6Outcomes" title="<?php echo $CPDTMReview->Q6Outcomes->FldTitle() ?>" value="<?php echo ew_HtmlEncode($arwrk[$rowcntwrk][0]) ?>"<?php echo $selwrk ?><?php echo $CPDTMReview->Q6Outcomes->EditAttributes() ?>><?php echo $arwrk[$rowcntwrk][1] ?></label> <?php echo ew_RepeatColumnTable($rowswrk, $rowcntwrk, 5, 2) ?> <?php } } ?> </div> </span><?php echo $CPDTMReview->Q6Outcomes->CustomMsg ?></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() ?>><span id="el_Q7Presentation"> <div id="tp_x_Q7Presentation" class="<?php echo EW_ITEM_TEMPLATE_CLASSNAME ?>"><label><input type="radio" name="x_Q7Presentation" id="x_Q7Presentation" title="<?php echo $CPDTMReview->Q7Presentation->FldTitle() ?>" value="{value}"<?php echo $CPDTMReview->Q7Presentation->EditAttributes() ?>></label></div> <div id="dsl_x_Q7Presentation" repeatcolumn="5"> <?php $arwrk = $CPDTMReview->Q7Presentation->EditValue; if (is_array($arwrk)) { $rowswrk = count($arwrk); $emptywrk = TRUE; for ($rowcntwrk = 0; $rowcntwrk < $rowswrk; $rowcntwrk++) { $selwrk = (strval($CPDTMReview->Q7Presentation->CurrentValue) == 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_Q7Presentation" id="x_Q7Presentation" title="<?php echo $CPDTMReview->Q7Presentation->FldTitle() ?>" value="<?php echo ew_HtmlEncode($arwrk[$rowcntwrk][0]) ?>"<?php echo $selwrk ?><?php echo $CPDTMReview->Q7Presentation->EditAttributes() ?>><?php echo $arwrk[$rowcntwrk][1] ?></label> <?php echo ew_RepeatColumnTable($rowswrk, $rowcntwrk, 5, 2) ?> <?php } } ?> </div> </span><?php echo $CPDTMReview->Q7Presentation->CustomMsg ?></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() ?>><span id="el_Q8Benefit"> <div id="tp_x_Q8Benefit" class="<?php echo EW_ITEM_TEMPLATE_CLASSNAME ?>"><label><input type="radio" name="x_Q8Benefit" id="x_Q8Benefit" title="<?php echo $CPDTMReview->Q8Benefit->FldTitle() ?>" value="{value}"<?php echo $CPDTMReview->Q8Benefit->EditAttributes() ?>></label></div> <div id="dsl_x_Q8Benefit" repeatcolumn="5"> <?php $arwrk = $CPDTMReview->Q8Benefit->EditValue; if (is_array($arwrk)) { $rowswrk = count($arwrk); $emptywrk = TRUE; for ($rowcntwrk = 0; $rowcntwrk < $rowswrk; $rowcntwrk++) { $selwrk = (strval($CPDTMReview->Q8Benefit->CurrentValue) == 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_Q8Benefit" id="x_Q8Benefit" title="<?php echo $CPDTMReview->Q8Benefit->FldTitle() ?>" value="<?php echo ew_HtmlEncode($arwrk[$rowcntwrk][0]) ?>"<?php echo $selwrk ?><?php echo $CPDTMReview->Q8Benefit->EditAttributes() ?>><?php echo $arwrk[$rowcntwrk][1] ?></label> <?php echo ew_RepeatColumnTable($rowswrk, $rowcntwrk, 5, 2) ?> <?php } } ?> </div> </span><?php echo $CPDTMReview->Q8Benefit->CustomMsg ?></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() ?>><span id="el_FinalStatus"> <div id="tp_x_FinalStatus" class="<?php echo EW_ITEM_TEMPLATE_CLASSNAME ?>"><label><input type="radio" name="x_FinalStatus" id="x_FinalStatus" title="<?php echo $CPDTMReview->FinalStatus->FldTitle() ?>" value="{value}"<?php echo $CPDTMReview->FinalStatus->EditAttributes() ?>></label></div> <div id="dsl_x_FinalStatus" repeatcolumn="5"> <?php $arwrk = $CPDTMReview->FinalStatus->EditValue; if (is_array($arwrk)) { $rowswrk = count($arwrk); $emptywrk = TRUE; for ($rowcntwrk = 0; $rowcntwrk < $rowswrk; $rowcntwrk++) { $selwrk = (strval($CPDTMReview->FinalStatus->CurrentValue) == 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_FinalStatus" id="x_FinalStatus" title="<?php echo $CPDTMReview->FinalStatus->FldTitle() ?>" value="<?php echo ew_HtmlEncode($arwrk[$rowcntwrk][0]) ?>"<?php echo $selwrk ?><?php echo $CPDTMReview->FinalStatus->EditAttributes() ?>><?php echo $arwrk[$rowcntwrk][1] ?></label> <?php echo ew_RepeatColumnTable($rowswrk, $rowcntwrk, 5, 2) ?> <?php } } ?> </div> </span><?php echo $CPDTMReview->FinalStatus->CustomMsg ?></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() ?>><span id="el_ChangesRequired"> <textarea name="x_ChangesRequired" id="x_ChangesRequired" title="<?php echo $CPDTMReview->ChangesRequired->FldTitle() ?>" cols="35" rows="4"<?php echo $CPDTMReview->ChangesRequired->EditAttributes() ?>><?php echo $CPDTMReview->ChangesRequired->EditValue ?></textarea> </span><?php echo $CPDTMReview->ChangesRequired->CustomMsg ?></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() ?>><span id="el_NotionalHours"> <input type="text" name="x_NotionalHours" id="x_NotionalHours" title="<?php echo $CPDTMReview->NotionalHours->FldTitle() ?>" size="30" value="<?php echo $CPDTMReview->NotionalHours->EditValue ?>"<?php echo $CPDTMReview->NotionalHours->EditAttributes() ?>> </span><?php echo $CPDTMReview->NotionalHours->CustomMsg ?></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() ?>><span id="el_CPDCredits"> <input type="text" name="x_CPDCredits" id="x_CPDCredits" title="<?php echo $CPDTMReview->CPDCredits->FldTitle() ?>" size="30" value="<?php echo $CPDTMReview->CPDCredits->EditValue ?>"<?php echo $CPDTMReview->CPDCredits->EditAttributes() ?>> </span><?php echo $CPDTMReview->CPDCredits->CustomMsg ?></td> </tr> <?php } ?> </table> </div> </td></tr></table> <p> <input type="submit" name="btnAction" id="btnAction" value="<?php echo ew_BtnCaption($Language->Phrase("EditBtn")) ?>"> </form> <script language="JavaScript" type="text/javascript"> <!-- // Write your table-specific startup script here // document.write("page loaded"); //--> </script> <?php include "footer.php" ?> <?php $CPDTMReview_edit->Page_Terminate(); ?> <?php // // Page class // class cCPDTMReview_edit { // Page ID var $PageID = 'edit'; // Table name var $TableName = 'CPDTMReview'; // Page object name var $PageObjName = 'CPDTMReview_edit'; // 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", 'edit', 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->CanEdit()) { $Security->SaveLastUrl(); $this->Page_Terminate("CPDTMReviewlist.php"); } $Security->UserID_Loading(); if ($Security->IsLoggedIn()) $Security->LoadUserID(); $Security->UserID_Loaded(); // Create form object $objForm = new cFormObj(); // 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 $sDbMasterFilter; var $sDbDetailFilter; // // Page main // function Page_Main() { global $objForm, $Language, $gsFormError, $CPDTMReview; // Load key from QueryString if (@$_GET["CPDTMReviewID"] <> "") $CPDTMReview->CPDTMReviewID->setQueryStringValue($_GET["CPDTMReviewID"]); // Set up master detail parameters $this->SetUpMasterDetail(); if (@$_POST["a_edit"] <> "") { $CPDTMReview->CurrentAction = $_POST["a_edit"]; // Get action code $this->LoadFormValues(); // Get form values // Validate form if (!$this->ValidateForm()) { $CPDTMReview->CurrentAction = ""; // Form error, reset action $this->setMessage($gsFormError); $CPDTMReview->EventCancelled = TRUE; // Event cancelled $this->RestoreFormValues(); } } else { $CPDTMReview->CurrentAction = "I"; // Default action is display } // Check if valid key if ($CPDTMReview->CPDTMReviewID->CurrentValue == "") $this->Page_Terminate("CPDTMReviewlist.php"); // Invalid key, return to list switch ($CPDTMReview->CurrentAction) { case "I": // Get a record to display if (!$this->LoadRow()) { // Load record based on key $this->setMessage($Language->Phrase("NoRecord")); // No record found $this->Page_Terminate("CPDTMReviewlist.php"); // No matching record, return to list } break; Case "U": // Update $CPDTMReview->SendEmail = TRUE; // Send email on update success if ($this->EditRow()) { // Update record based on key $this->setMessage($Language->Phrase("UpdateSuccess")); // Update success $sReturnUrl = $CPDTMReview->getReturnUrl(); if (ew_GetPageName($sReturnUrl) == "CPDTMReviewview.php") $sReturnUrl = $CPDTMReview->ViewUrl(); // View paging, return to View page directly $this->Page_Terminate($sReturnUrl); // Return to caller } else { $CPDTMReview->EventCancelled = TRUE; // Event cancelled $this->RestoreFormValues(); // Restore form values if update failed } } // Render the record $CPDTMReview->RowType = EW_ROWTYPE_EDIT; // Render as Edit $this->RenderRow(); } // Get upload files function GetUploadFiles() { global $objForm, $CPDTMReview; // Get upload data } // Load form values function LoadFormValues() { // Load from form global $objForm, $CPDTMReview; $CPDTMReview->CPDTMReviewID->setFormValue($objForm->GetValue("x_CPDTMReviewID")); $CPDTMReview->ProviderID->setFormValue($objForm->GetValue("x_ProviderID")); $CPDTMReview->MaterialID->setFormValue($objForm->GetValue("x_MaterialID")); $CPDTMReview->CPDAssessorID->setFormValue($objForm->GetValue("x_CPDAssessorID")); $CPDTMReview->DateReviewed->setFormValue($objForm->GetValue("x_DateReviewed")); $CPDTMReview->DateReviewed->CurrentValue = ew_UnFormatDateTime($CPDTMReview->DateReviewed->CurrentValue, 5); $CPDTMReview->Q1Knowledge->setFormValue($objForm->GetValue("x_Q1Knowledge")); $CPDTMReview->Q2Learning->setFormValue($objForm->GetValue("x_Q2Learning")); $CPDTMReview->Q3Depth->setFormValue($objForm->GetValue("x_Q3Depth")); $CPDTMReview->Q4EvalForm->setFormValue($objForm->GetValue("x_Q4EvalForm")); $CPDTMReview->Q5Objectives->setFormValue($objForm->GetValue("x_Q5Objectives")); $CPDTMReview->Q6Outcomes->setFormValue($objForm->GetValue("x_Q6Outcomes")); $CPDTMReview->Q7Presentation->setFormValue($objForm->GetValue("x_Q7Presentation")); $CPDTMReview->Q8Benefit->setFormValue($objForm->GetValue("x_Q8Benefit")); $CPDTMReview->FinalStatus->setFormValue($objForm->GetValue("x_FinalStatus")); $CPDTMReview->ChangesRequired->setFormValue($objForm->GetValue("x_ChangesRequired")); $CPDTMReview->NotionalHours->setFormValue($objForm->GetValue("x_NotionalHours")); $CPDTMReview->CPDCredits->setFormValue($objForm->GetValue("x_CPDCredits")); } // Restore form values function RestoreFormValues() { global $objForm, $CPDTMReview; $this->LoadRow(); $CPDTMReview->CPDTMReviewID->CurrentValue = $CPDTMReview->CPDTMReviewID->FormValue; $CPDTMReview->ProviderID->CurrentValue = $CPDTMReview->ProviderID->FormValue; $CPDTMReview->MaterialID->CurrentValue = $CPDTMReview->MaterialID->FormValue; $CPDTMReview->CPDAssessorID->CurrentValue = $CPDTMReview->CPDAssessorID->FormValue; $CPDTMReview->DateReviewed->CurrentValue = $CPDTMReview->DateReviewed->FormValue; $CPDTMReview->DateReviewed->CurrentValue = ew_UnFormatDateTime($CPDTMReview->DateReviewed->CurrentValue, 5); $CPDTMReview->Q1Knowledge->CurrentValue = $CPDTMReview->Q1Knowledge->FormValue; $CPDTMReview->Q2Learning->CurrentValue = $CPDTMReview->Q2Learning->FormValue; $CPDTMReview->Q3Depth->CurrentValue = $CPDTMReview->Q3Depth->FormValue; $CPDTMReview->Q4EvalForm->CurrentValue = $CPDTMReview->Q4EvalForm->FormValue; $CPDTMReview->Q5Objectives->CurrentValue = $CPDTMReview->Q5Objectives->FormValue; $CPDTMReview->Q6Outcomes->CurrentValue = $CPDTMReview->Q6Outcomes->FormValue; $CPDTMReview->Q7Presentation->CurrentValue = $CPDTMReview->Q7Presentation->FormValue; $CPDTMReview->Q8Benefit->CurrentValue = $CPDTMReview->Q8Benefit->FormValue; $CPDTMReview->FinalStatus->CurrentValue = $CPDTMReview->FinalStatus->FormValue; $CPDTMReview->ChangesRequired->CurrentValue = $CPDTMReview->ChangesRequired->FormValue; $CPDTMReview->NotionalHours->CurrentValue = $CPDTMReview->NotionalHours->FormValue; $CPDTMReview->CPDCredits->CurrentValue = $CPDTMReview->CPDCredits->FormValue; } // 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 // 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 = ""; } elseif ($CPDTMReview->RowType == EW_ROWTYPE_EDIT) { // Edit row // CPDTMReviewID $CPDTMReview->CPDTMReviewID->EditCustomAttributes = ""; $CPDTMReview->CPDTMReviewID->EditValue = $CPDTMReview->CPDTMReviewID->CurrentValue; $CPDTMReview->CPDTMReviewID->CssStyle = ""; $CPDTMReview->CPDTMReviewID->CssClass = ""; $CPDTMReview->CPDTMReviewID->ViewCustomAttributes = ""; // ProviderID $CPDTMReview->ProviderID->EditCustomAttributes = ""; 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->EditValue = $rswrk->fields('CompanyName'); $rswrk->Close(); } else { $CPDTMReview->ProviderID->EditValue = $CPDTMReview->ProviderID->CurrentValue; } } else { $CPDTMReview->ProviderID->EditValue = NULL; } $CPDTMReview->ProviderID->CssStyle = ""; $CPDTMReview->ProviderID->CssClass = ""; $CPDTMReview->ProviderID->ViewCustomAttributes = ""; // MaterialID $CPDTMReview->MaterialID->EditCustomAttributes = ""; 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->EditValue = $rswrk->fields('Subject'); $CPDTMReview->MaterialID->EditValue .= ew_ValueSeparator(0) . $rswrk->fields('AccredNum'); $rswrk->Close(); } else { $CPDTMReview->MaterialID->EditValue = $CPDTMReview->MaterialID->CurrentValue; } } else { $CPDTMReview->MaterialID->EditValue = NULL; } $CPDTMReview->MaterialID->CssStyle = ""; $CPDTMReview->MaterialID->CssClass = ""; $CPDTMReview->MaterialID->ViewCustomAttributes = ""; // CPDAssessorID $CPDTMReview->CPDAssessorID->EditCustomAttributes = ""; $sFilterWrk = ""; $sSqlWrk = "SELECT `CPDAssessorID`, `Surname`, `FirstName`, '' AS SelectFilterFld 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); $arwrk = ($rswrk) ? $rswrk->GetRows() : array(); if ($rswrk) $rswrk->Close(); array_unshift($arwrk, array("", $Language->Phrase("PleaseSelect"), "")); $CPDTMReview->CPDAssessorID->EditValue = $arwrk; // DateReviewed $CPDTMReview->DateReviewed->EditCustomAttributes = ""; $CPDTMReview->DateReviewed->EditValue = ew_HtmlEncode(ew_FormatDateTime($CPDTMReview->DateReviewed->CurrentValue, 5)); // Q1Knowledge $CPDTMReview->Q1Knowledge->EditCustomAttributes = ""; $arwrk = array(); $arwrk[] = array("a", "Acceptable"); $arwrk[] = array("i", "Inadequate"); $CPDTMReview->Q1Knowledge->EditValue = $arwrk; // Q2Learning $CPDTMReview->Q2Learning->EditCustomAttributes = ""; $arwrk = array(); $arwrk[] = array("a", "Acceptable"); $arwrk[] = array("i", "Inadequate"); $CPDTMReview->Q2Learning->EditValue = $arwrk; // Q3Depth $CPDTMReview->Q3Depth->EditCustomAttributes = ""; $arwrk = array(); $arwrk[] = array("a", "Acceptable"); $arwrk[] = array("i", "Inadequate"); $CPDTMReview->Q3Depth->EditValue = $arwrk; // Q4EvalForm $CPDTMReview->Q4EvalForm->EditCustomAttributes = ""; $arwrk = array(); $arwrk[] = array("a", "Acceptable"); $arwrk[] = array("i", "Inadequate"); $CPDTMReview->Q4EvalForm->EditValue = $arwrk; // Q5Objectives $CPDTMReview->Q5Objectives->EditCustomAttributes = ""; $arwrk = array(); $arwrk[] = array("a", "Acceptable"); $arwrk[] = array("i", "Inadequate"); $CPDTMReview->Q5Objectives->EditValue = $arwrk; // Q6Outcomes $CPDTMReview->Q6Outcomes->EditCustomAttributes = ""; $arwrk = array(); $arwrk[] = array("a", "Acceptable"); $arwrk[] = array("i", "Inadequate"); $CPDTMReview->Q6Outcomes->EditValue = $arwrk; // Q7Presentation $CPDTMReview->Q7Presentation->EditCustomAttributes = ""; $arwrk = array(); $arwrk[] = array("a", "Acceptable"); $arwrk[] = array("i", "Inadequate"); $CPDTMReview->Q7Presentation->EditValue = $arwrk; // Q8Benefit $CPDTMReview->Q8Benefit->EditCustomAttributes = ""; $arwrk = array(); $arwrk[] = array("a", "Acceptable"); $arwrk[] = array("i", "Inadequate"); $CPDTMReview->Q8Benefit->EditValue = $arwrk; // FinalStatus $CPDTMReview->FinalStatus->EditCustomAttributes = ""; $arwrk = array(); $arwrk[] = array("a", "Approved"); $arwrk[] = array("d", "Declined"); $arwrk[] = array("c", "Approved Pending Changes"); $CPDTMReview->FinalStatus->EditValue = $arwrk; // ChangesRequired $CPDTMReview->ChangesRequired->EditCustomAttributes = ""; $CPDTMReview->ChangesRequired->EditValue = ew_HtmlEncode($CPDTMReview->ChangesRequired->CurrentValue); // NotionalHours $CPDTMReview->NotionalHours->EditCustomAttributes = ""; $CPDTMReview->NotionalHours->EditValue = ew_HtmlEncode($CPDTMReview->NotionalHours->CurrentValue); // CPDCredits $CPDTMReview->CPDCredits->EditCustomAttributes = ""; $CPDTMReview->CPDCredits->EditValue = ew_HtmlEncode($CPDTMReview->CPDCredits->CurrentValue); // Edit refer script // CPDTMReviewID $CPDTMReview->CPDTMReviewID->HrefValue = ""; // ProviderID $CPDTMReview->ProviderID->HrefValue = ""; // MaterialID $CPDTMReview->MaterialID->HrefValue = ""; // CPDAssessorID $CPDTMReview->CPDAssessorID->HrefValue = ""; // DateReviewed $CPDTMReview->DateReviewed->HrefValue = ""; // Q1Knowledge $CPDTMReview->Q1Knowledge->HrefValue = ""; // Q2Learning $CPDTMReview->Q2Learning->HrefValue = ""; // Q3Depth $CPDTMReview->Q3Depth->HrefValue = ""; // Q4EvalForm $CPDTMReview->Q4EvalForm->HrefValue = ""; // Q5Objectives $CPDTMReview->Q5Objectives->HrefValue = ""; // Q6Outcomes $CPDTMReview->Q6Outcomes->HrefValue = ""; // Q7Presentation $CPDTMReview->Q7Presentation->HrefValue = ""; // Q8Benefit $CPDTMReview->Q8Benefit->HrefValue = ""; // FinalStatus $CPDTMReview->FinalStatus->HrefValue = ""; // ChangesRequired $CPDTMReview->ChangesRequired->HrefValue = ""; // NotionalHours $CPDTMReview->NotionalHours->HrefValue = ""; // CPDCredits $CPDTMReview->CPDCredits->HrefValue = ""; } // Call Row Rendered event if ($CPDTMReview->RowType <> EW_ROWTYPE_AGGREGATEINIT) $CPDTMReview->Row_Rendered(); } // Validate form function ValidateForm() { global $Language, $gsFormError, $CPDTMReview; // Initialize form error message $gsFormError = ""; // Check if validation required if (!EW_SERVER_VALIDATE) return ($gsFormError == ""); if (!is_null($CPDTMReview->DateReviewed->FormValue) && $CPDTMReview->DateReviewed->FormValue == "") { $gsFormError .= ($gsFormError <> "") ? "<br>" : ""; $gsFormError .= $Language->Phrase("EnterRequiredField") . " - " . $CPDTMReview->DateReviewed->FldCaption(); } if (!ew_CheckDate($CPDTMReview->DateReviewed->FormValue)) { if ($gsFormError <> "") $gsFormError .= "<br>"; $gsFormError .= $CPDTMReview->DateReviewed->FldErrMsg(); } if (!ew_CheckInteger($CPDTMReview->NotionalHours->FormValue)) { if ($gsFormError <> "") $gsFormError .= "<br>"; $gsFormError .= $CPDTMReview->NotionalHours->FldErrMsg(); } if (!ew_CheckInteger($CPDTMReview->CPDCredits->FormValue)) { if ($gsFormError <> "") $gsFormError .= "<br>"; $gsFormError .= $CPDTMReview->CPDCredits->FldErrMsg(); } // Return validate result $ValidateForm = ($gsFormError == ""); // Call Form_CustomValidate event $sFormCustomError = ""; $ValidateForm = $ValidateForm && $this->Form_CustomValidate($sFormCustomError); if ($sFormCustomError <> "") { $gsFormError .= ($gsFormError <> "") ? "<br>" : ""; $gsFormError .= $sFormCustomError; } return $ValidateForm; } // Update record based on key values function EditRow() { global $conn, $Security, $Language, $CPDTMReview; $sFilter = $CPDTMReview->KeyFilter(); $CPDTMReview->CurrentFilter = $sFilter; $sSql = $CPDTMReview->SQL(); $conn->raiseErrorFn = 'ew_ErrorFn'; $rs = $conn->Execute($sSql); $conn->raiseErrorFn = ''; if ($rs === FALSE) return FALSE; if ($rs->EOF) { $EditRow = FALSE; // Update Failed } else { // Save old values $rsold =& $rs->fields; $rsnew = array(); // CPDAssessorID $CPDTMReview->CPDAssessorID->SetDbValueDef($rsnew, $CPDTMReview->CPDAssessorID->CurrentValue, NULL, FALSE); // DateReviewed $CPDTMReview->DateReviewed->SetDbValueDef($rsnew, ew_UnFormatDateTime($CPDTMReview->DateReviewed->CurrentValue, 5, FALSE), NULL); // Q1Knowledge $CPDTMReview->Q1Knowledge->SetDbValueDef($rsnew, $CPDTMReview->Q1Knowledge->CurrentValue, NULL, FALSE); // Q2Learning $CPDTMReview->Q2Learning->SetDbValueDef($rsnew, $CPDTMReview->Q2Learning->CurrentValue, NULL, FALSE); // Q3Depth $CPDTMReview->Q3Depth->SetDbValueDef($rsnew, $CPDTMReview->Q3Depth->CurrentValue, NULL, FALSE); // Q4EvalForm $CPDTMReview->Q4EvalForm->SetDbValueDef($rsnew, $CPDTMReview->Q4EvalForm->CurrentValue, NULL, FALSE); // Q5Objectives $CPDTMReview->Q5Objectives->SetDbValueDef($rsnew, $CPDTMReview->Q5Objectives->CurrentValue, NULL, FALSE); // Q6Outcomes $CPDTMReview->Q6Outcomes->SetDbValueDef($rsnew, $CPDTMReview->Q6Outcomes->CurrentValue, NULL, FALSE); // Q7Presentation $CPDTMReview->Q7Presentation->SetDbValueDef($rsnew, $CPDTMReview->Q7Presentation->CurrentValue, NULL, FALSE); // Q8Benefit $CPDTMReview->Q8Benefit->SetDbValueDef($rsnew, $CPDTMReview->Q8Benefit->CurrentValue, NULL, FALSE); // FinalStatus $CPDTMReview->FinalStatus->SetDbValueDef($rsnew, $CPDTMReview->FinalStatus->CurrentValue, NULL, FALSE); // ChangesRequired $CPDTMReview->ChangesRequired->SetDbValueDef($rsnew, $CPDTMReview->ChangesRequired->CurrentValue, NULL, FALSE); // NotionalHours $CPDTMReview->NotionalHours->SetDbValueDef($rsnew, $CPDTMReview->NotionalHours->CurrentValue, NULL, FALSE); // CPDCredits $CPDTMReview->CPDCredits->SetDbValueDef($rsnew, $CPDTMReview->CPDCredits->CurrentValue, NULL, FALSE); // Call Row Updating event $bUpdateRow = $CPDTMReview->Row_Updating($rsold, $rsnew); if ($bUpdateRow) { $conn->raiseErrorFn = 'ew_ErrorFn'; $EditRow = $conn->Execute($CPDTMReview->UpdateSQL($rsnew)); $conn->raiseErrorFn = ''; } else { if ($CPDTMReview->CancelMessage <> "") { $this->setMessage($CPDTMReview->CancelMessage); $CPDTMReview->CancelMessage = ""; } else { $this->setMessage($Language->Phrase("UpdateCancelled")); } $EditRow = FALSE; } } // Call Row_Updated event if ($EditRow) $CPDTMReview->Row_Updated($rsold, $rsnew); $rs->Close(); return $EditRow; } // Set up master/detail based on QueryString function SetUpMasterDetail() { global $CPDTMReview; $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 == "CPDTrainingMaterial") { $bValidMaster = TRUE; $this->sDbMasterFilter = $CPDTMReview->SqlMasterFilter_CPDTrainingMaterial(); $this->sDbDetailFilter = $CPDTMReview->SqlDetailFilter_CPDTrainingMaterial(); if (@$_GET["MaterialID"] <> "") { $GLOBALS["CPDTrainingMaterial"]->MaterialID->setQueryStringValue($_GET["MaterialID"]); $CPDTMReview->MaterialID->setQueryStringValue($GLOBALS["CPDTrainingMaterial"]->MaterialID->QueryStringValue); $CPDTMReview->MaterialID->setSessionValue($CPDTMReview->MaterialID->QueryStringValue); if (!is_numeric($GLOBALS["CPDTrainingMaterial"]->MaterialID->QueryStringValue)) $bValidMaster = FALSE; $this->sDbMasterFilter = str_replace("@MaterialID@", ew_AdjustSql($GLOBALS["CPDTrainingMaterial"]->MaterialID->QueryStringValue), $this->sDbMasterFilter); $this->sDbDetailFilter = str_replace("@MaterialID@", ew_AdjustSql($GLOBALS["CPDTrainingMaterial"]->MaterialID->QueryStringValue), $this->sDbDetailFilter); } else { $bValidMaster = FALSE; } } } if ($bValidMaster) { // Save current master table $CPDTMReview->setCurrentMasterTable($sMasterTblVar); // Reset start record counter (new master key) $this->lStartRec = 1; $CPDTMReview->setStartRecordNumber($this->lStartRec); $CPDTMReview->setMasterFilter($this->sDbMasterFilter); // Set up master filter $CPDTMReview->setDetailFilter($this->sDbDetailFilter); // Set up detail filter // Clear previous master key from Session if ($sMasterTblVar <> "CPDTrainingMaterial") { if ($CPDTMReview->MaterialID->QueryStringValue == "") $CPDTMReview->MaterialID->setSessionValue(""); } } else { $this->sDbMasterFilter = $CPDTMReview->getMasterFilter(); // Restore master filter $this->sDbDetailFilter = $CPDTMReview->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; } } ?>