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 "CPDProviderDocsinfo.php" ?> <?php include "CPDServiceProviderinfo.php" ?> <?php include "CPDAdminUsersinfo.php" ?> <?php include "userfn7.php" ?> <?php header("Expires: Mon, 26 Jul 1997 05:00:00 GMT"); // Date in the past header("Last-Modified: " . gmdate("D, d M Y H:i:s") . " GMT"); // Always modified header("Cache-Control: private, no-store, no-cache, must-revalidate"); // HTTP/1.1 header("Cache-Control: post-check=0, pre-check=0", false); header("Pragma: no-cache"); // HTTP/1.0 ?> <?php // Create page object $CPDProviderDocs_edit = new cCPDProviderDocs_edit(); $Page = & $CPDProviderDocs_edit; // Page init $CPDProviderDocs_edit->Page_Init(); // Page main $CPDProviderDocs_edit->Page_Main(); ?> <?php include "header.php" ?> <script type="text/javascript"> <!-- // Create page object var CPDProviderDocs_edit = new ew_Page("CPDProviderDocs_edit"); // page properties CPDProviderDocs_edit.PageID = "edit"; // page ID CPDProviderDocs_edit.FormID = "fCPDProviderDocsedit"; // form ID var EW_PAGE_ID = CPDProviderDocs_edit.PageID; // for backward compatibility // extend page with ValidateForm function CPDProviderDocs_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 + "_DocFile"]; if (elm && !ew_CheckFileType(elm.value)) return ew_OnError(this, elm, ewLanguage.Phrase("WrongFileType")); // Call Form Custom Validate event if (!this.Form_CustomValidate(fobj)) return false; } return true; } // extend page with Form_CustomValidate function CPDProviderDocs_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) { ?> CPDProviderDocs_edit.ValidateRequired = true; // uses JavaScript validation <?php } else { ?> CPDProviderDocs_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 $CPDProviderDocs->TableCaption() ?><br><br> <a href="<?php echo $CPDProviderDocs->getReturnUrl() ?>"><?php echo $Language->Phrase("GoBack") ?></a></span></p> <?php if (EW_DEBUG_ENABLED) echo ew_DebugMsg(); $CPDProviderDocs_edit->ShowMessage(); ?> <form name="fCPDProviderDocsedit" id="fCPDProviderDocsedit" action="<?php echo ew_CurrentPage() ?>" method="post" enctype="multipart/form-data" onsubmit="return CPDProviderDocs_edit.ValidateForm(this);"> <p> <input type="hidden" name="a_table" id="a_table" value="CPDProviderDocs"> <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 ($CPDProviderDocs->CPDProviderDocID->Visible) { // CPDProviderDocID ?> <tr<?php echo $CPDProviderDocs->RowAttributes() ?>> <td class="ewTableHeader"><?php echo $CPDProviderDocs->CPDProviderDocID->FldCaption() ?></td> <td<?php echo $CPDProviderDocs->CPDProviderDocID->CellAttributes() ?>><span id="el_CPDProviderDocID"> <div<?php echo $CPDProviderDocs->CPDProviderDocID->ViewAttributes() ?>><?php echo $CPDProviderDocs->CPDProviderDocID->EditValue ?></div><input type="hidden" name="x_CPDProviderDocID" id="x_CPDProviderDocID" value="<?php echo ew_HtmlEncode($CPDProviderDocs->CPDProviderDocID->CurrentValue) ?>"> </span><?php echo $CPDProviderDocs->CPDProviderDocID->CustomMsg ?></td> </tr> <?php } ?> <?php if ($CPDProviderDocs->CPDProviderID->Visible) { // CPDProviderID ?> <tr<?php echo $CPDProviderDocs->RowAttributes() ?>> <td class="ewTableHeader"><?php echo $CPDProviderDocs->CPDProviderID->FldCaption() ?></td> <td<?php echo $CPDProviderDocs->CPDProviderID->CellAttributes() ?>><span id="el_CPDProviderID"> <?php if ($CPDProviderDocs->CPDProviderID->getSessionValue() <> "") { ?> <div<?php echo $CPDProviderDocs->CPDProviderID->ViewAttributes() ?>><?php echo $CPDProviderDocs->CPDProviderID->ViewValue ?></div> <input type="hidden" id="x_CPDProviderID" name="x_CPDProviderID" value="<?php echo ew_HtmlEncode($CPDProviderDocs->CPDProviderID->CurrentValue) ?>"> <?php } else { ?> <select id="x_CPDProviderID" name="x_CPDProviderID" title="<?php echo $CPDProviderDocs->CPDProviderID->FldTitle() ?>"<?php echo $CPDProviderDocs->CPDProviderID->EditAttributes() ?>> <?php if (is_array($CPDProviderDocs->CPDProviderID->EditValue)) { $arwrk = $CPDProviderDocs->CPDProviderID->EditValue; $rowswrk = count($arwrk); $emptywrk = TRUE; for ($rowcntwrk = 0; $rowcntwrk < $rowswrk; $rowcntwrk++) { $selwrk = (strval($CPDProviderDocs->CPDProviderID->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] ?> </option> <?php } } ?> </select> <?php } ?> </span><?php echo $CPDProviderDocs->CPDProviderID->CustomMsg ?></td> </tr> <?php } ?> <?php if ($CPDProviderDocs->DocType->Visible) { // DocType ?> <tr<?php echo $CPDProviderDocs->RowAttributes() ?>> <td class="ewTableHeader"><?php echo $CPDProviderDocs->DocType->FldCaption() ?></td> <td<?php echo $CPDProviderDocs->DocType->CellAttributes() ?>><span id="el_DocType"> <select id="x_DocType" name="x_DocType" title="<?php echo $CPDProviderDocs->DocType->FldTitle() ?>"<?php echo $CPDProviderDocs->DocType->EditAttributes() ?>> <?php if (is_array($CPDProviderDocs->DocType->EditValue)) { $arwrk = $CPDProviderDocs->DocType->EditValue; $rowswrk = count($arwrk); $emptywrk = TRUE; for ($rowcntwrk = 0; $rowcntwrk < $rowswrk; $rowcntwrk++) { $selwrk = (strval($CPDProviderDocs->DocType->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] ?> </option> <?php } } ?> </select> </span><?php echo $CPDProviderDocs->DocType->CustomMsg ?></td> </tr> <?php } ?> <?php if ($CPDProviderDocs->DocFile->Visible) { // DocFile ?> <tr<?php echo $CPDProviderDocs->RowAttributes() ?>> <td class="ewTableHeader"><?php echo $CPDProviderDocs->DocFile->FldCaption() ?></td> <td<?php echo $CPDProviderDocs->DocFile->CellAttributes() ?>><span id="el_DocFile"> <div id="old_x_DocFile"> <?php if ($CPDProviderDocs->DocFile->HrefValue <> "" || $CPDProviderDocs->DocFile->TooltipValue <> "") { ?> <?php if (!empty($CPDProviderDocs->DocFile->Upload->DbValue)) { ?> <a href="<?php echo $CPDProviderDocs->DocFile->HrefValue ?>" target="_blank"><?php echo $CPDProviderDocs->DocFile->EditValue ?></a> <?php } elseif (!in_array($CPDProviderDocs->CurrentAction, array("I", "edit", "gridedit"))) { ?> <?php } ?> <?php } else { ?> <?php if (!empty($CPDProviderDocs->DocFile->Upload->DbValue)) { ?> <?php echo $CPDProviderDocs->DocFile->EditValue ?> <?php } elseif (!in_array($CPDProviderDocs->CurrentAction, array("I", "edit", "gridedit"))) { ?> <?php } ?> <?php } ?> </div> <div id="new_x_DocFile"> <?php if (!empty($CPDProviderDocs->DocFile->Upload->DbValue)) { ?> <label><input type="radio" name="a_DocFile" id="a_DocFile" value="1" checked="checked"><?php echo $Language->Phrase("Keep") ?></label> <label><input type="radio" name="a_DocFile" id="a_DocFile" value="2"><?php echo $Language->Phrase("Remove") ?></label> <label><input type="radio" name="a_DocFile" id="a_DocFile" value="3"><?php echo $Language->Phrase("Replace") ?><br></label> <?php $CPDProviderDocs->DocFile->EditAttrs["onchange"] = "this.form.a_DocFile[2].checked=true;" . @$CPDProviderDocs->DocFile->EditAttrs["onchange"]; ?> <?php } else { ?> <input type="hidden" name="a_DocFile" id="a_DocFile" value="3"> <?php } ?> <input type="file" name="x_DocFile" id="x_DocFile" title="<?php echo $CPDProviderDocs->DocFile->FldTitle() ?>" size="30"<?php echo $CPDProviderDocs->DocFile->EditAttributes() ?>> </div> </span><?php echo $CPDProviderDocs->DocFile->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 $CPDProviderDocs_edit->Page_Terminate(); ?> <?php // // Page class // class cCPDProviderDocs_edit { // Page ID var $PageID = 'edit'; // Table name var $TableName = 'CPDProviderDocs'; // Page object name var $PageObjName = 'CPDProviderDocs_edit'; // Page name function PageName() { return ew_CurrentPage(); } // Page URL function PageUrl() { $PageUrl = ew_CurrentPage() . "?"; global $CPDProviderDocs; if ($CPDProviderDocs->UseTokenInUrl) $PageUrl .= "t=" . $CPDProviderDocs->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, $CPDProviderDocs; if ($CPDProviderDocs->UseTokenInUrl) { if ($objForm) return ($CPDProviderDocs->TableVar == $objForm->GetValue("t")); if (@$_GET["t"] <> "") return ($CPDProviderDocs->TableVar == $_GET["t"]); } else { return TRUE; } } // // Page class constructor // function __construct() { global $conn, $Language; // Language object $Language = new cLanguage(); // Table object (CPDProviderDocs) $GLOBALS["CPDProviderDocs"] = new cCPDProviderDocs(); // Table object (CPDServiceProvider) $GLOBALS['CPDServiceProvider'] = new cCPDServiceProvider(); // Table object (CPDAdminUsers) $GLOBALS['CPDAdminUsers'] = new cCPDAdminUsers(); // Page ID if (!defined("EW_PAGE_ID")) define("EW_PAGE_ID", 'edit', TRUE); // Table name (for backward compatibility) if (!defined("EW_TABLE_NAME")) define("EW_TABLE_NAME", 'CPDProviderDocs', 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 $CPDProviderDocs; // 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"); } // 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, $CPDProviderDocs; // Load key from QueryString if (@$_GET["CPDProviderDocID"] <> "") $CPDProviderDocs->CPDProviderDocID->setQueryStringValue($_GET["CPDProviderDocID"]); // Set up master detail parameters $this->SetUpMasterDetail(); if (@$_POST["a_edit"] <> "") { $CPDProviderDocs->CurrentAction = $_POST["a_edit"]; // Get action code $this->GetUploadFiles(); // Get upload files $this->LoadFormValues(); // Get form values // Validate form if (!$this->ValidateForm()) { $CPDProviderDocs->CurrentAction = ""; // Form error, reset action $this->setMessage($gsFormError); $CPDProviderDocs->EventCancelled = TRUE; // Event cancelled $this->RestoreFormValues(); } } else { $CPDProviderDocs->CurrentAction = "I"; // Default action is display } // Check if valid key if ($CPDProviderDocs->CPDProviderDocID->CurrentValue == "") $this->Page_Terminate("CPDProviderDocslist.php"); // Invalid key, return to list switch ($CPDProviderDocs->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("CPDProviderDocslist.php"); // No matching record, return to list } break; Case "U": // Update $CPDProviderDocs->SendEmail = TRUE; // Send email on update success if ($this->EditRow()) { // Update record based on key $this->setMessage($Language->Phrase("UpdateSuccess")); // Update success $sReturnUrl = $CPDProviderDocs->getReturnUrl(); if (ew_GetPageName($sReturnUrl) == "CPDProviderDocsview.php") $sReturnUrl = $CPDProviderDocs->ViewUrl(); // View paging, return to View page directly $this->Page_Terminate($sReturnUrl); // Return to caller } else { $CPDProviderDocs->EventCancelled = TRUE; // Event cancelled $this->RestoreFormValues(); // Restore form values if update failed } } // Render the record $CPDProviderDocs->RowType = EW_ROWTYPE_EDIT; // Render as Edit $this->RenderRow(); } // Get upload files function GetUploadFiles() { global $objForm, $CPDProviderDocs; // Get upload data if ($CPDProviderDocs->DocFile->Upload->UploadFile()) { // No action required } else { echo $CPDProviderDocs->DocFile->Upload->Message; $this->Page_Terminate(); exit(); } } // Load form values function LoadFormValues() { // Load from form global $objForm, $CPDProviderDocs; $CPDProviderDocs->CPDProviderDocID->setFormValue($objForm->GetValue("x_CPDProviderDocID")); $CPDProviderDocs->CPDProviderID->setFormValue($objForm->GetValue("x_CPDProviderID")); $CPDProviderDocs->DocType->setFormValue($objForm->GetValue("x_DocType")); $CPDProviderDocs->UploadedBy->setFormValue($objForm->GetValue("x_UploadedBy")); $CPDProviderDocs->DateUploaded->setFormValue($objForm->GetValue("x_DateUploaded")); $CPDProviderDocs->DateUploaded->CurrentValue = ew_UnFormatDateTime($CPDProviderDocs->DateUploaded->CurrentValue, 5); } // Restore form values function RestoreFormValues() { global $objForm, $CPDProviderDocs; $this->LoadRow(); $CPDProviderDocs->CPDProviderDocID->CurrentValue = $CPDProviderDocs->CPDProviderDocID->FormValue; $CPDProviderDocs->CPDProviderID->CurrentValue = $CPDProviderDocs->CPDProviderID->FormValue; $CPDProviderDocs->DocType->CurrentValue = $CPDProviderDocs->DocType->FormValue; $CPDProviderDocs->UploadedBy->CurrentValue = $CPDProviderDocs->UploadedBy->FormValue; $CPDProviderDocs->DateUploaded->CurrentValue = $CPDProviderDocs->DateUploaded->FormValue; $CPDProviderDocs->DateUploaded->CurrentValue = ew_UnFormatDateTime($CPDProviderDocs->DateUploaded->CurrentValue, 5); } // Load row based on key values function LoadRow() { global $conn, $Security, $CPDProviderDocs; $sFilter = $CPDProviderDocs->KeyFilter(); // Call Row Selecting event $CPDProviderDocs->Row_Selecting($sFilter); // Load SQL based on filter $CPDProviderDocs->CurrentFilter = $sFilter; $sSql = $CPDProviderDocs->SQL(); $res = FALSE; $rs = ew_LoadRecordset($sSql); if ($rs && !$rs->EOF) { $res = TRUE; $this->LoadRowValues($rs); // Load row values // Call Row Selected event $CPDProviderDocs->Row_Selected($rs); $rs->Close(); } return $res; } // Load row values from recordset function LoadRowValues(&$rs) { global $conn, $CPDProviderDocs; $CPDProviderDocs->CPDProviderDocID->setDbValue($rs->fields('CPDProviderDocID')); $CPDProviderDocs->CPDProviderID->setDbValue($rs->fields('CPDProviderID')); $CPDProviderDocs->DocType->setDbValue($rs->fields('DocType')); $CPDProviderDocs->DocFile->Upload->DbValue = $rs->fields('DocFile'); $CPDProviderDocs->UploadedBy->setDbValue($rs->fields('UploadedBy')); $CPDProviderDocs->DateUploaded->setDbValue($rs->fields('DateUploaded')); } // Render row values based on field settings function RenderRow() { global $conn, $Security, $Language, $CPDProviderDocs; // Initialize URLs // Call Row_Rendering event $CPDProviderDocs->Row_Rendering(); // Common render codes for all row types // CPDProviderDocID $CPDProviderDocs->CPDProviderDocID->CellCssStyle = ""; $CPDProviderDocs->CPDProviderDocID->CellCssClass = ""; $CPDProviderDocs->CPDProviderDocID->CellAttrs = array(); $CPDProviderDocs->CPDProviderDocID->ViewAttrs = array(); $CPDProviderDocs->CPDProviderDocID->EditAttrs = array(); // CPDProviderID $CPDProviderDocs->CPDProviderID->CellCssStyle = ""; $CPDProviderDocs->CPDProviderID->CellCssClass = ""; $CPDProviderDocs->CPDProviderID->CellAttrs = array(); $CPDProviderDocs->CPDProviderID->ViewAttrs = array(); $CPDProviderDocs->CPDProviderID->EditAttrs = array(); // DocType $CPDProviderDocs->DocType->CellCssStyle = ""; $CPDProviderDocs->DocType->CellCssClass = ""; $CPDProviderDocs->DocType->CellAttrs = array(); $CPDProviderDocs->DocType->ViewAttrs = array(); $CPDProviderDocs->DocType->EditAttrs = array(); // DocFile $CPDProviderDocs->DocFile->CellCssStyle = ""; $CPDProviderDocs->DocFile->CellCssClass = ""; $CPDProviderDocs->DocFile->CellAttrs = array(); $CPDProviderDocs->DocFile->ViewAttrs = array(); $CPDProviderDocs->DocFile->EditAttrs = array(); // UploadedBy $CPDProviderDocs->UploadedBy->CellCssStyle = ""; $CPDProviderDocs->UploadedBy->CellCssClass = ""; $CPDProviderDocs->UploadedBy->CellAttrs = array(); $CPDProviderDocs->UploadedBy->ViewAttrs = array(); $CPDProviderDocs->UploadedBy->EditAttrs = array(); // DateUploaded $CPDProviderDocs->DateUploaded->CellCssStyle = ""; $CPDProviderDocs->DateUploaded->CellCssClass = ""; $CPDProviderDocs->DateUploaded->CellAttrs = array(); $CPDProviderDocs->DateUploaded->ViewAttrs = array(); $CPDProviderDocs->DateUploaded->EditAttrs = array(); if ($CPDProviderDocs->RowType == EW_ROWTYPE_VIEW) { // View row // CPDProviderDocID $CPDProviderDocs->CPDProviderDocID->ViewValue = $CPDProviderDocs->CPDProviderDocID->CurrentValue; $CPDProviderDocs->CPDProviderDocID->CssStyle = ""; $CPDProviderDocs->CPDProviderDocID->CssClass = ""; $CPDProviderDocs->CPDProviderDocID->ViewCustomAttributes = ""; // CPDProviderID if (strval($CPDProviderDocs->CPDProviderID->CurrentValue) <> "") { $sFilterWrk = "`CPDProviderID` = " . ew_AdjustSql($CPDProviderDocs->CPDProviderID->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 $CPDProviderDocs->CPDProviderID->ViewValue = $rswrk->fields('CompanyName'); $rswrk->Close(); } else { $CPDProviderDocs->CPDProviderID->ViewValue = $CPDProviderDocs->CPDProviderID->CurrentValue; } } else { $CPDProviderDocs->CPDProviderID->ViewValue = NULL; } $CPDProviderDocs->CPDProviderID->CssStyle = ""; $CPDProviderDocs->CPDProviderID->CssClass = ""; $CPDProviderDocs->CPDProviderID->ViewCustomAttributes = ""; // DocType if (strval($CPDProviderDocs->DocType->CurrentValue) <> "") { $sFilterWrk = "`PicklistValue` = '" . ew_AdjustSql($CPDProviderDocs->DocType->CurrentValue) . "'"; $sSqlWrk = "SELECT `PicklistValue` FROM `Picklists`"; $sWhereWrk = ""; if ($sWhereWrk <> "") $sWhereWrk .= " AND "; $sWhereWrk .= "(" . "PicklistType='CPD Provider Documents'" . ")"; if ($sFilterWrk <> "") { if ($sWhereWrk <> "") $sWhereWrk .= " AND "; $sWhereWrk .= "(" . $sFilterWrk . ")"; } if ($sWhereWrk <> "") $sSqlWrk .= " WHERE " . $sWhereWrk; $sSqlWrk .= " ORDER BY `PicklistValue`"; $rswrk = $conn->Execute($sSqlWrk); if ($rswrk && !$rswrk->EOF) { // Lookup values found $CPDProviderDocs->DocType->ViewValue = $rswrk->fields('PicklistValue'); $rswrk->Close(); } else { $CPDProviderDocs->DocType->ViewValue = $CPDProviderDocs->DocType->CurrentValue; } } else { $CPDProviderDocs->DocType->ViewValue = NULL; } $CPDProviderDocs->DocType->CssStyle = ""; $CPDProviderDocs->DocType->CssClass = ""; $CPDProviderDocs->DocType->ViewCustomAttributes = ""; // DocFile if (!ew_Empty($CPDProviderDocs->DocFile->Upload->DbValue)) { $CPDProviderDocs->DocFile->ViewValue = $CPDProviderDocs->DocFile->Upload->DbValue; } else { $CPDProviderDocs->DocFile->ViewValue = ""; } $CPDProviderDocs->DocFile->CssStyle = ""; $CPDProviderDocs->DocFile->CssClass = ""; $CPDProviderDocs->DocFile->ViewCustomAttributes = ""; // UploadedBy $CPDProviderDocs->UploadedBy->ViewValue = $CPDProviderDocs->UploadedBy->CurrentValue; $CPDProviderDocs->UploadedBy->CssStyle = ""; $CPDProviderDocs->UploadedBy->CssClass = ""; $CPDProviderDocs->UploadedBy->ViewCustomAttributes = ""; // DateUploaded $CPDProviderDocs->DateUploaded->ViewValue = $CPDProviderDocs->DateUploaded->CurrentValue; $CPDProviderDocs->DateUploaded->ViewValue = ew_FormatDateTime($CPDProviderDocs->DateUploaded->ViewValue, 5); $CPDProviderDocs->DateUploaded->CssStyle = ""; $CPDProviderDocs->DateUploaded->CssClass = ""; $CPDProviderDocs->DateUploaded->ViewCustomAttributes = ""; // CPDProviderDocID $CPDProviderDocs->CPDProviderDocID->HrefValue = ""; $CPDProviderDocs->CPDProviderDocID->TooltipValue = ""; // CPDProviderID $CPDProviderDocs->CPDProviderID->HrefValue = ""; $CPDProviderDocs->CPDProviderID->TooltipValue = ""; // DocType $CPDProviderDocs->DocType->HrefValue = ""; $CPDProviderDocs->DocType->TooltipValue = ""; // DocFile if (!ew_Empty($CPDProviderDocs->DocFile->Upload->DbValue)) { $CPDProviderDocs->DocFile->HrefValue = ew_UploadPathEx(FALSE, $CPDProviderDocs->DocFile->UploadPath) . ((!empty($CPDProviderDocs->DocFile->ViewValue)) ? $CPDProviderDocs->DocFile->ViewValue : $CPDProviderDocs->DocFile->CurrentValue); if ($CPDProviderDocs->Export <> "") $CPDProviderDocs->DocFile->HrefValue = ew_ConvertFullUrl($CPDProviderDocs->DocFile->HrefValue); } else { $CPDProviderDocs->DocFile->HrefValue = ""; } $CPDProviderDocs->DocFile->TooltipValue = ""; // UploadedBy $CPDProviderDocs->UploadedBy->HrefValue = ""; $CPDProviderDocs->UploadedBy->TooltipValue = ""; // DateUploaded $CPDProviderDocs->DateUploaded->HrefValue = ""; $CPDProviderDocs->DateUploaded->TooltipValue = ""; } elseif ($CPDProviderDocs->RowType == EW_ROWTYPE_EDIT) { // Edit row // CPDProviderDocID $CPDProviderDocs->CPDProviderDocID->EditCustomAttributes = ""; $CPDProviderDocs->CPDProviderDocID->EditValue = $CPDProviderDocs->CPDProviderDocID->CurrentValue; $CPDProviderDocs->CPDProviderDocID->CssStyle = ""; $CPDProviderDocs->CPDProviderDocID->CssClass = ""; $CPDProviderDocs->CPDProviderDocID->ViewCustomAttributes = ""; // CPDProviderID $CPDProviderDocs->CPDProviderID->EditCustomAttributes = ""; if ($CPDProviderDocs->CPDProviderID->getSessionValue() <> "") { $CPDProviderDocs->CPDProviderID->CurrentValue = $CPDProviderDocs->CPDProviderID->getSessionValue(); if (strval($CPDProviderDocs->CPDProviderID->CurrentValue) <> "") { $sFilterWrk = "`CPDProviderID` = " . ew_AdjustSql($CPDProviderDocs->CPDProviderID->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 $CPDProviderDocs->CPDProviderID->ViewValue = $rswrk->fields('CompanyName'); $rswrk->Close(); } else { $CPDProviderDocs->CPDProviderID->ViewValue = $CPDProviderDocs->CPDProviderID->CurrentValue; } } else { $CPDProviderDocs->CPDProviderID->ViewValue = NULL; } $CPDProviderDocs->CPDProviderID->CssStyle = ""; $CPDProviderDocs->CPDProviderID->CssClass = ""; $CPDProviderDocs->CPDProviderID->ViewCustomAttributes = ""; } else { $sFilterWrk = ""; $sSqlWrk = "SELECT `CPDProviderID`, `CompanyName`, '' AS Disp2Fld, '' AS SelectFilterFld FROM `CPDServiceProvider`"; $sWhereWrk = ""; if ($sFilterWrk <> "") { if ($sWhereWrk <> "") $sWhereWrk .= " AND "; $sWhereWrk .= "(" . $sFilterWrk . ")"; } if ($sWhereWrk <> "") $sSqlWrk .= " WHERE " . $sWhereWrk; $sSqlWrk .= " ORDER BY `CompanyName`"; $rswrk = $conn->Execute($sSqlWrk); $arwrk = ($rswrk) ? $rswrk->GetRows() : array(); if ($rswrk) $rswrk->Close(); array_unshift($arwrk, array("", $Language->Phrase("PleaseSelect"))); $CPDProviderDocs->CPDProviderID->EditValue = $arwrk; } // DocType $CPDProviderDocs->DocType->EditCustomAttributes = ""; $sFilterWrk = ""; $sSqlWrk = "SELECT `PicklistValue`, `PicklistValue`, '' AS Disp2Fld, '' AS SelectFilterFld FROM `Picklists`"; $sWhereWrk = ""; if ($sWhereWrk <> "") $sWhereWrk .= " AND "; $sWhereWrk .= "(" . "PicklistType='CPD Provider Documents'" . ")"; if ($sFilterWrk <> "") { if ($sWhereWrk <> "") $sWhereWrk .= " AND "; $sWhereWrk .= "(" . $sFilterWrk . ")"; } if ($sWhereWrk <> "") $sSqlWrk .= " WHERE " . $sWhereWrk; $sSqlWrk .= " ORDER BY `PicklistValue`"; $rswrk = $conn->Execute($sSqlWrk); $arwrk = ($rswrk) ? $rswrk->GetRows() : array(); if ($rswrk) $rswrk->Close(); array_unshift($arwrk, array("", $Language->Phrase("PleaseSelect"))); $CPDProviderDocs->DocType->EditValue = $arwrk; // DocFile $CPDProviderDocs->DocFile->EditCustomAttributes = ""; if (!ew_Empty($CPDProviderDocs->DocFile->Upload->DbValue)) { $CPDProviderDocs->DocFile->EditValue = $CPDProviderDocs->DocFile->Upload->DbValue; } else { $CPDProviderDocs->DocFile->EditValue = ""; } // UploadedBy // DateUploaded // Edit refer script // CPDProviderDocID $CPDProviderDocs->CPDProviderDocID->HrefValue = ""; // CPDProviderID $CPDProviderDocs->CPDProviderID->HrefValue = ""; // DocType $CPDProviderDocs->DocType->HrefValue = ""; // DocFile if (!ew_Empty($CPDProviderDocs->DocFile->Upload->DbValue)) { $CPDProviderDocs->DocFile->HrefValue = ew_UploadPathEx(FALSE, $CPDProviderDocs->DocFile->UploadPath) . ((!empty($CPDProviderDocs->DocFile->EditValue)) ? $CPDProviderDocs->DocFile->EditValue : $CPDProviderDocs->DocFile->CurrentValue); if ($CPDProviderDocs->Export <> "") $CPDProviderDocs->DocFile->HrefValue = ew_ConvertFullUrl($CPDProviderDocs->DocFile->HrefValue); } else { $CPDProviderDocs->DocFile->HrefValue = ""; } // UploadedBy $CPDProviderDocs->UploadedBy->HrefValue = ""; // DateUploaded $CPDProviderDocs->DateUploaded->HrefValue = ""; } // Call Row Rendered event if ($CPDProviderDocs->RowType <> EW_ROWTYPE_AGGREGATEINIT) $CPDProviderDocs->Row_Rendered(); } // Validate form function ValidateForm() { global $Language, $gsFormError, $CPDProviderDocs; // Initialize form error message $gsFormError = ""; if (!ew_CheckFileType($CPDProviderDocs->DocFile->Upload->FileName)) { $gsFormError .= ($gsFormError <> "") ? "<br>" : ""; $gsFormError .= $Language->Phrase("WrongFileType"); } if ($CPDProviderDocs->DocFile->Upload->FileSize > 0 && EW_MAX_FILE_SIZE > 0 && $CPDProviderDocs->DocFile->Upload->FileSize > EW_MAX_FILE_SIZE) { $gsFormError .= ($gsFormError <> "") ? "<br>" : ""; $gsFormError .= str_replace("%s", EW_MAX_FILE_SIZE, $Language->Phrase("MaxFileSize")); } if (in_array($CPDProviderDocs->DocFile->Upload->Error, array(1, 2, 3, 6, 7, 8))) { $gsFormError .= ($gsFormError <> "") ? "<br>" : ""; $gsFormError .= $Language->Phrase("PhpUploadErr" . $CPDProviderDocs->DocFile->Upload->Error); } // Check if validation required if (!EW_SERVER_VALIDATE) return ($gsFormError == ""); // 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, $CPDProviderDocs; $sFilter = $CPDProviderDocs->KeyFilter(); $CPDProviderDocs->CurrentFilter = $sFilter; $sSql = $CPDProviderDocs->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(); // CPDProviderID $CPDProviderDocs->CPDProviderID->SetDbValueDef($rsnew, $CPDProviderDocs->CPDProviderID->CurrentValue, NULL, FALSE); // DocType $CPDProviderDocs->DocType->SetDbValueDef($rsnew, $CPDProviderDocs->DocType->CurrentValue, NULL, FALSE); // DocFile $CPDProviderDocs->DocFile->Upload->SaveToSession(); // Save file value to Session if ($CPDProviderDocs->DocFile->Upload->Action == "2" || $CPDProviderDocs->DocFile->Upload->Action == "3") { // Update/Remove $CPDProviderDocs->DocFile->Upload->DbValue = $rs->fields('DocFile'); // Get original value if (is_null($CPDProviderDocs->DocFile->Upload->Value)) { $rsnew['DocFile'] = NULL; } else { if ($CPDProviderDocs->DocFile->Upload->FileName == $CPDProviderDocs->DocFile->Upload->DbValue) { // Upload file name same as old file name $rsnew['DocFile'] = $CPDProviderDocs->DocFile->Upload->FileName; } else { $rsnew['DocFile'] = ew_UploadFileNameEx(ew_UploadPathEx(TRUE, $CPDProviderDocs->DocFile->UploadPath), $CPDProviderDocs->DocFile->Upload->FileName); } } } // Call Row Updating event $bUpdateRow = $CPDProviderDocs->Row_Updating($rsold, $rsnew); if ($bUpdateRow) { if (!ew_Empty($CPDProviderDocs->DocFile->Upload->Value)) { if ($CPDProviderDocs->DocFile->Upload->FileName == $CPDProviderDocs->DocFile->Upload->DbValue) { // Overwrite if same file name $CPDProviderDocs->DocFile->Upload->SaveToFile($CPDProviderDocs->DocFile->UploadPath, $rsnew['DocFile'], TRUE); $CPDProviderDocs->DocFile->Upload->DbValue = ""; // No need to delete any more } else { $CPDProviderDocs->DocFile->Upload->SaveToFile($CPDProviderDocs->DocFile->UploadPath, $rsnew['DocFile'], FALSE); } } if ($CPDProviderDocs->DocFile->Upload->Action == "2" || $CPDProviderDocs->DocFile->Upload->Action == "3") { // Update/Remove if ($CPDProviderDocs->DocFile->Upload->DbValue <> "") @unlink(ew_UploadPathEx(TRUE, $CPDProviderDocs->DocFile->UploadPath) . $CPDProviderDocs->DocFile->Upload->DbValue); } $conn->raiseErrorFn = 'ew_ErrorFn'; $EditRow = $conn->Execute($CPDProviderDocs->UpdateSQL($rsnew)); $conn->raiseErrorFn = ''; } else { if ($CPDProviderDocs->CancelMessage <> "") { $this->setMessage($CPDProviderDocs->CancelMessage); $CPDProviderDocs->CancelMessage = ""; } else { $this->setMessage($Language->Phrase("UpdateCancelled")); } $EditRow = FALSE; } } // Call Row_Updated event if ($EditRow) $CPDProviderDocs->Row_Updated($rsold, $rsnew); $rs->Close(); // DocFile $CPDProviderDocs->DocFile->Upload->RemoveFromSession(); // Remove file value from Session return $EditRow; } // Set up master/detail based on QueryString function SetUpMasterDetail() { global $CPDProviderDocs; $bValidMaster = FALSE; // Get the keys for master table if (@$_GET[EW_TABLE_SHOW_MASTER] <> "") { $sMasterTblVar = $_GET[EW_TABLE_SHOW_MASTER]; if ($sMasterTblVar == "") { $bValidMaster = TRUE; $this->sDbMasterFilter = ""; $this->sDbDetailFilter = ""; } if ($sMasterTblVar == "CPDServiceProvider") { $bValidMaster = TRUE; $this->sDbMasterFilter = $CPDProviderDocs->SqlMasterFilter_CPDServiceProvider(); $this->sDbDetailFilter = $CPDProviderDocs->SqlDetailFilter_CPDServiceProvider(); if (@$_GET["CPDProviderID"] <> "") { $GLOBALS["CPDServiceProvider"]->CPDProviderID->setQueryStringValue($_GET["CPDProviderID"]); $CPDProviderDocs->CPDProviderID->setQueryStringValue($GLOBALS["CPDServiceProvider"]->CPDProviderID->QueryStringValue); $CPDProviderDocs->CPDProviderID->setSessionValue($CPDProviderDocs->CPDProviderID->QueryStringValue); if (!is_numeric($GLOBALS["CPDServiceProvider"]->CPDProviderID->QueryStringValue)) $bValidMaster = FALSE; $this->sDbMasterFilter = str_replace("@CPDProviderID@", ew_AdjustSql($GLOBALS["CPDServiceProvider"]->CPDProviderID->QueryStringValue), $this->sDbMasterFilter); $this->sDbDetailFilter = str_replace("@CPDProviderID@", ew_AdjustSql($GLOBALS["CPDServiceProvider"]->CPDProviderID->QueryStringValue), $this->sDbDetailFilter); } else { $bValidMaster = FALSE; } } } if ($bValidMaster) { // Save current master table $CPDProviderDocs->setCurrentMasterTable($sMasterTblVar); // Reset start record counter (new master key) $this->lStartRec = 1; $CPDProviderDocs->setStartRecordNumber($this->lStartRec); $CPDProviderDocs->setMasterFilter($this->sDbMasterFilter); // Set up master filter $CPDProviderDocs->setDetailFilter($this->sDbDetailFilter); // Set up detail filter // Clear previous master key from Session if ($sMasterTblVar <> "CPDServiceProvider") { if ($CPDProviderDocs->CPDProviderID->QueryStringValue == "") $CPDProviderDocs->CPDProviderID->setSessionValue(""); } } else { $this->sDbMasterFilter = $CPDProviderDocs->getMasterFilter(); // Restore master filter $this->sDbDetailFilter = $CPDProviderDocs->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; } } ?>