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 "vwCPD_SPExpiredNotRenewedinfo.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 $vwCPD_SPExpiredNotRenewed_list = new cvwCPD_SPExpiredNotRenewed_list(); $Page =& $vwCPD_SPExpiredNotRenewed_list; // Page init $vwCPD_SPExpiredNotRenewed_list->Page_Init(); // Page main $vwCPD_SPExpiredNotRenewed_list->Page_Main(); ?> <?php include "header.php" ?> <?php if ($vwCPD_SPExpiredNotRenewed->Export == "") { ?> <script type="text/javascript"> <!-- // Create page object var vwCPD_SPExpiredNotRenewed_list = new ew_Page("vwCPD_SPExpiredNotRenewed_list"); // page properties vwCPD_SPExpiredNotRenewed_list.PageID = "list"; // page ID vwCPD_SPExpiredNotRenewed_list.FormID = "fvwCPD_SPExpiredNotRenewedlist"; // form ID var EW_PAGE_ID = vwCPD_SPExpiredNotRenewed_list.PageID; // for backward compatibility // extend page with Form_CustomValidate function vwCPD_SPExpiredNotRenewed_list.Form_CustomValidate = function(fobj) { // DO NOT CHANGE THIS LINE! // Your custom validation code here, return false if invalid. return true; } <?php if (EW_CLIENT_VALIDATE) { ?> vwCPD_SPExpiredNotRenewed_list.ValidateRequired = true; // uses JavaScript validation <?php } else { ?> vwCPD_SPExpiredNotRenewed_list.ValidateRequired = false; // no JavaScript validation <?php } ?> //--> </script> <script type="text/javascript"> <!-- var ew_DHTMLEditors = []; //--> </script> <script language="JavaScript" type="text/javascript"> <!-- // Write your client script here, no need to add script tags. // To include another .js script, use: // ew_ClientScriptInclude("my_javascript.js"); //--> </script> <?php } ?> <?php if ($vwCPD_SPExpiredNotRenewed->Export == "") { ?> <?php } ?> <?php $bSelectLimit = EW_SELECT_LIMIT; if ($bSelectLimit) { $vwCPD_SPExpiredNotRenewed_list->lTotalRecs = $vwCPD_SPExpiredNotRenewed->SelectRecordCount(); } else { if ($rs = $vwCPD_SPExpiredNotRenewed_list->LoadRecordset()) $vwCPD_SPExpiredNotRenewed_list->lTotalRecs = $rs->RecordCount(); } $vwCPD_SPExpiredNotRenewed_list->lStartRec = 1; if ($vwCPD_SPExpiredNotRenewed_list->lDisplayRecs <= 0 || ($vwCPD_SPExpiredNotRenewed->Export <> "" && $vwCPD_SPExpiredNotRenewed->ExportAll)) // Display all records $vwCPD_SPExpiredNotRenewed_list->lDisplayRecs = $vwCPD_SPExpiredNotRenewed_list->lTotalRecs; if (!($vwCPD_SPExpiredNotRenewed->Export <> "" && $vwCPD_SPExpiredNotRenewed->ExportAll)) $vwCPD_SPExpiredNotRenewed_list->SetUpStartRec(); // Set up start record position if ($bSelectLimit) $rs = $vwCPD_SPExpiredNotRenewed_list->LoadRecordset($vwCPD_SPExpiredNotRenewed_list->lStartRec-1, $vwCPD_SPExpiredNotRenewed_list->lDisplayRecs); ?> <p><span class="phpmaker" style="white-space: nowrap;"><?php echo $Language->Phrase("TblTypeVIEW") ?><?php echo $vwCPD_SPExpiredNotRenewed->TableCaption() ?> <?php if ($vwCPD_SPExpiredNotRenewed->Export == "" && $vwCPD_SPExpiredNotRenewed->CurrentAction == "") { ?> <a href="<?php echo $vwCPD_SPExpiredNotRenewed_list->ExportPrintUrl ?>"><img src="images/print.gif" alt="<?php echo ew_HtmlEncode($Language->Phrase("PrinterFriendly")) ?>" title="<?php echo ew_HtmlEncode($Language->Phrase("PrinterFriendly")) ?>" width="16" height="16" border="0"></a> <a href="<?php echo $vwCPD_SPExpiredNotRenewed_list->ExportExcelUrl ?>"><img src='images/exportxls.gif' alt='<?php echo ew_HtmlEncode($Language->Phrase("ExportToExcel")) ?>' title='<?php echo ew_HtmlEncode($Language->Phrase("ExportToExcel")) ?>' width='16' height='16' border='0'></a> <a href="<?php echo $vwCPD_SPExpiredNotRenewed_list->ExportWordUrl ?>"><img src='images/exportdoc.gif' alt='<?php echo ew_HtmlEncode($Language->Phrase("ExportToWord")) ?>' title='<?php echo ew_HtmlEncode($Language->Phrase("ExportToWord")) ?>' width='16' height='16' border='0'></a> <a name="emf_vwCPD_SPExpiredNotRenewed" id="emf_vwCPD_SPExpiredNotRenewed" href="javascript:void(0);" onclick="ew_EmailDialogShow({lnk:'emf_vwCPD_SPExpiredNotRenewed',hdr:ewLanguage.Phrase('ExportToEmail'),f:document.fvwCPD_SPExpiredNotRenewedlist,sel:false});"><img src='images/exportemail.gif' alt='<?php echo ew_HtmlEncode($Language->Phrase("ExportToEmail")) ?>' title='<?php echo ew_HtmlEncode($Language->Phrase("ExportToEmail")) ?>' width='16' height='16' border='0'></a> <?php } ?> </span></p> <?php if ($Security->IsLoggedIn()) { ?> <?php if ($vwCPD_SPExpiredNotRenewed->Export == "" && $vwCPD_SPExpiredNotRenewed->CurrentAction == "") { ?> <a href="javascript:ew_ToggleSearchPanel(vwCPD_SPExpiredNotRenewed_list);" style="text-decoration: none;"><img id="vwCPD_SPExpiredNotRenewed_list_SearchImage" src="images/collapse.gif" alt="" width="9" height="9" border="0"></a><span class="phpmaker"> <?php echo $Language->Phrase("Search") ?></span><br> <div id="vwCPD_SPExpiredNotRenewed_list_SearchPanel"> <form name="fvwCPD_SPExpiredNotRenewedlistsrch" id="fvwCPD_SPExpiredNotRenewedlistsrch" class="ewForm" action="<?php echo ew_CurrentPage() ?>"> <input type="hidden" id="t" name="t" value="vwCPD_SPExpiredNotRenewed"> <table class="ewBasicSearch"> <tr> <td><span class="phpmaker"> <input type="text" name="<?php echo EW_TABLE_BASIC_SEARCH ?>" id="<?php echo EW_TABLE_BASIC_SEARCH ?>" size="20" value="<?php echo ew_HtmlEncode($vwCPD_SPExpiredNotRenewed->getSessionBasicSearchKeyword()) ?>"> <input type="Submit" name="Submit" id="Submit" value="<?php echo ew_BtnCaption($Language->Phrase("QuickSearchBtn")) ?>"> <a href="<?php echo $vwCPD_SPExpiredNotRenewed_list->PageUrl() ?>cmd=reset"><?php echo $Language->Phrase("ShowAll") ?></a> </span></td> </tr> <tr> <td><span class="phpmaker"><label><input type="radio" name="<?php echo EW_TABLE_BASIC_SEARCH_TYPE ?>" id="<?php echo EW_TABLE_BASIC_SEARCH_TYPE ?>" value=""<?php if ($vwCPD_SPExpiredNotRenewed->getSessionBasicSearchType() == "") { ?> checked="checked"<?php } ?>><?php echo $Language->Phrase("ExactPhrase") ?></label> <label><input type="radio" name="<?php echo EW_TABLE_BASIC_SEARCH_TYPE ?>" id="<?php echo EW_TABLE_BASIC_SEARCH_TYPE ?>" value="AND"<?php if ($vwCPD_SPExpiredNotRenewed->getSessionBasicSearchType() == "AND") { ?> checked="checked"<?php } ?>><?php echo $Language->Phrase("AllWord") ?></label> <label><input type="radio" name="<?php echo EW_TABLE_BASIC_SEARCH_TYPE ?>" id="<?php echo EW_TABLE_BASIC_SEARCH_TYPE ?>" value="OR"<?php if ($vwCPD_SPExpiredNotRenewed->getSessionBasicSearchType() == "OR") { ?> checked="checked"<?php } ?>><?php echo $Language->Phrase("AnyWord") ?></label></span></td> </tr> </table> </form> </div> <?php } ?> <?php } ?> <?php if (EW_DEBUG_ENABLED) echo ew_DebugMsg(); $vwCPD_SPExpiredNotRenewed_list->ShowMessage(); ?> <br> <table cellspacing="0" class="ewGrid"><tr><td class="ewGridContent"> <?php if ($vwCPD_SPExpiredNotRenewed->Export == "") { ?> <div class="ewGridUpperPanel"> <?php if ($vwCPD_SPExpiredNotRenewed->CurrentAction <> "gridadd" && $vwCPD_SPExpiredNotRenewed->CurrentAction <> "gridedit") { ?> <form name="ewpagerform" id="ewpagerform" class="ewForm" action="<?php echo ew_CurrentPage() ?>"> <table border="0" cellspacing="0" cellpadding="0" class="ewPager"> <tr> <td nowrap> <?php if (!isset($vwCPD_SPExpiredNotRenewed_list->Pager)) $vwCPD_SPExpiredNotRenewed_list->Pager = new cPrevNextPager($vwCPD_SPExpiredNotRenewed_list->lStartRec, $vwCPD_SPExpiredNotRenewed_list->lDisplayRecs, $vwCPD_SPExpiredNotRenewed_list->lTotalRecs) ?> <?php if ($vwCPD_SPExpiredNotRenewed_list->Pager->RecordCount > 0) { ?> <table border="0" cellspacing="0" cellpadding="0"><tr><td><span class="phpmaker"><?php echo $Language->Phrase("Page") ?> </span></td> <!--first page button--> <?php if ($vwCPD_SPExpiredNotRenewed_list->Pager->FirstButton->Enabled) { ?> <td><a href="<?php echo $vwCPD_SPExpiredNotRenewed_list->PageUrl() ?>start=<?php echo $vwCPD_SPExpiredNotRenewed_list->Pager->FirstButton->Start ?>"><img src="images/first.gif" alt="<?php echo $Language->Phrase("PagerFirst") ?>" width="16" height="16" border="0"></a></td> <?php } else { ?> <td><img src="images/firstdisab.gif" alt="<?php echo $Language->Phrase("PagerFirst") ?>" width="16" height="16" border="0"></td> <?php } ?> <!--previous page button--> <?php if ($vwCPD_SPExpiredNotRenewed_list->Pager->PrevButton->Enabled) { ?> <td><a href="<?php echo $vwCPD_SPExpiredNotRenewed_list->PageUrl() ?>start=<?php echo $vwCPD_SPExpiredNotRenewed_list->Pager->PrevButton->Start ?>"><img src="images/prev.gif" alt="<?php echo $Language->Phrase("PagerPrevious") ?>" width="16" height="16" border="0"></a></td> <?php } else { ?> <td><img src="images/prevdisab.gif" alt="<?php echo $Language->Phrase("PagerPrevious") ?>" width="16" height="16" border="0"></td> <?php } ?> <!--current page number--> <td><input type="text" name="<?php echo EW_TABLE_PAGE_NO ?>" id="<?php echo EW_TABLE_PAGE_NO ?>" value="<?php echo $vwCPD_SPExpiredNotRenewed_list->Pager->CurrentPage ?>" size="4"></td> <!--next page button--> <?php if ($vwCPD_SPExpiredNotRenewed_list->Pager->NextButton->Enabled) { ?> <td><a href="<?php echo $vwCPD_SPExpiredNotRenewed_list->PageUrl() ?>start=<?php echo $vwCPD_SPExpiredNotRenewed_list->Pager->NextButton->Start ?>"><img src="images/next.gif" alt="<?php echo $Language->Phrase("PagerNext") ?>" width="16" height="16" border="0"></a></td> <?php } else { ?> <td><img src="images/nextdisab.gif" alt="<?php echo $Language->Phrase("PagerNext") ?>" width="16" height="16" border="0"></td> <?php } ?> <!--last page button--> <?php if ($vwCPD_SPExpiredNotRenewed_list->Pager->LastButton->Enabled) { ?> <td><a href="<?php echo $vwCPD_SPExpiredNotRenewed_list->PageUrl() ?>start=<?php echo $vwCPD_SPExpiredNotRenewed_list->Pager->LastButton->Start ?>"><img src="images/last.gif" alt="<?php echo $Language->Phrase("PagerLast") ?>" width="16" height="16" border="0"></a></td> <?php } else { ?> <td><img src="images/lastdisab.gif" alt="<?php echo $Language->Phrase("PagerLast") ?>" width="16" height="16" border="0"></td> <?php } ?> <td><span class="phpmaker"> <?php echo $Language->Phrase("of") ?> <?php echo $vwCPD_SPExpiredNotRenewed_list->Pager->PageCount ?></span></td> </tr></table> </td> <td> </td> <td> <span class="phpmaker"><?php echo $Language->Phrase("Record") ?> <?php echo $vwCPD_SPExpiredNotRenewed_list->Pager->FromIndex ?> <?php echo $Language->Phrase("To") ?> <?php echo $vwCPD_SPExpiredNotRenewed_list->Pager->ToIndex ?> <?php echo $Language->Phrase("Of") ?> <?php echo $vwCPD_SPExpiredNotRenewed_list->Pager->RecordCount ?></span> <?php } else { ?> <?php if ($vwCPD_SPExpiredNotRenewed_list->sSrchWhere == "0=101") { ?> <span class="phpmaker"><?php echo $Language->Phrase("EnterSearchCriteria") ?></span> <?php } else { ?> <span class="phpmaker"><?php echo $Language->Phrase("NoRecord") ?></span> <?php } ?> <?php } ?> </td> </tr> </table> </form> <?php } ?> <span class="phpmaker"> </span> </div> <?php } ?> <form name="fvwCPD_SPExpiredNotRenewedlist" id="fvwCPD_SPExpiredNotRenewedlist" class="ewForm" action="" method="post"> <div id="gmp_vwCPD_SPExpiredNotRenewed" class="ewGridMiddlePanel"> <?php if ($vwCPD_SPExpiredNotRenewed_list->lTotalRecs > 0) { ?> <table cellspacing="0" rowhighlightclass="ewTableHighlightRow" rowselectclass="ewTableSelectRow" roweditclass="ewTableEditRow" class="ewTable ewTableSeparate"> <?php echo $vwCPD_SPExpiredNotRenewed->TableCustomInnerHtml ?> <thead><!-- Table header --> <tr class="ewTableHeader"> <?php // Render list options $vwCPD_SPExpiredNotRenewed_list->RenderListOptions(); // Render list options (header, left) $vwCPD_SPExpiredNotRenewed_list->ListOptions->Render("header", "left"); ?> <?php if ($vwCPD_SPExpiredNotRenewed->CompanyName->Visible) { // CompanyName ?> <?php if ($vwCPD_SPExpiredNotRenewed->SortUrl($vwCPD_SPExpiredNotRenewed->CompanyName) == "") { ?> <td><?php echo $vwCPD_SPExpiredNotRenewed->CompanyName->FldCaption() ?></td> <?php } else { ?> <td><div class="ewPointer" onmousedown="ew_Sort(event,'<?php echo $vwCPD_SPExpiredNotRenewed->SortUrl($vwCPD_SPExpiredNotRenewed->CompanyName) ?>',2);"> <table cellspacing="0" class="ewTableHeaderBtn"><thead><tr><td><?php echo $vwCPD_SPExpiredNotRenewed->CompanyName->FldCaption() ?><?php echo $Language->Phrase("SrchLegend") ?></td><td style="width: 10px;"><?php if ($vwCPD_SPExpiredNotRenewed->CompanyName->getSort() == "ASC") { ?><img src="images/sortup.gif" width="10" height="9" border="0"><?php } elseif ($vwCPD_SPExpiredNotRenewed->CompanyName->getSort() == "DESC") { ?><img src="images/sortdown.gif" width="10" height="9" border="0"><?php } ?></td></tr></thead></table> </div></td> <?php } ?> <?php } ?> <?php if ($vwCPD_SPExpiredNotRenewed->TradingAs->Visible) { // TradingAs ?> <?php if ($vwCPD_SPExpiredNotRenewed->SortUrl($vwCPD_SPExpiredNotRenewed->TradingAs) == "") { ?> <td><?php echo $vwCPD_SPExpiredNotRenewed->TradingAs->FldCaption() ?></td> <?php } else { ?> <td><div class="ewPointer" onmousedown="ew_Sort(event,'<?php echo $vwCPD_SPExpiredNotRenewed->SortUrl($vwCPD_SPExpiredNotRenewed->TradingAs) ?>',2);"> <table cellspacing="0" class="ewTableHeaderBtn"><thead><tr><td><?php echo $vwCPD_SPExpiredNotRenewed->TradingAs->FldCaption() ?><?php echo $Language->Phrase("SrchLegend") ?></td><td style="width: 10px;"><?php if ($vwCPD_SPExpiredNotRenewed->TradingAs->getSort() == "ASC") { ?><img src="images/sortup.gif" width="10" height="9" border="0"><?php } elseif ($vwCPD_SPExpiredNotRenewed->TradingAs->getSort() == "DESC") { ?><img src="images/sortdown.gif" width="10" height="9" border="0"><?php } ?></td></tr></thead></table> </div></td> <?php } ?> <?php } ?> <?php if ($vwCPD_SPExpiredNotRenewed->ContactEmail->Visible) { // ContactEmail ?> <?php if ($vwCPD_SPExpiredNotRenewed->SortUrl($vwCPD_SPExpiredNotRenewed->ContactEmail) == "") { ?> <td><?php echo $vwCPD_SPExpiredNotRenewed->ContactEmail->FldCaption() ?></td> <?php } else { ?> <td><div class="ewPointer" onmousedown="ew_Sort(event,'<?php echo $vwCPD_SPExpiredNotRenewed->SortUrl($vwCPD_SPExpiredNotRenewed->ContactEmail) ?>',2);"> <table cellspacing="0" class="ewTableHeaderBtn"><thead><tr><td><?php echo $vwCPD_SPExpiredNotRenewed->ContactEmail->FldCaption() ?><?php echo $Language->Phrase("SrchLegend") ?></td><td style="width: 10px;"><?php if ($vwCPD_SPExpiredNotRenewed->ContactEmail->getSort() == "ASC") { ?><img src="images/sortup.gif" width="10" height="9" border="0"><?php } elseif ($vwCPD_SPExpiredNotRenewed->ContactEmail->getSort() == "DESC") { ?><img src="images/sortdown.gif" width="10" height="9" border="0"><?php } ?></td></tr></thead></table> </div></td> <?php } ?> <?php } ?> <?php if ($vwCPD_SPExpiredNotRenewed->ContactFirstName->Visible) { // ContactFirstName ?> <?php if ($vwCPD_SPExpiredNotRenewed->SortUrl($vwCPD_SPExpiredNotRenewed->ContactFirstName) == "") { ?> <td><?php echo $vwCPD_SPExpiredNotRenewed->ContactFirstName->FldCaption() ?></td> <?php } else { ?> <td><div class="ewPointer" onmousedown="ew_Sort(event,'<?php echo $vwCPD_SPExpiredNotRenewed->SortUrl($vwCPD_SPExpiredNotRenewed->ContactFirstName) ?>',2);"> <table cellspacing="0" class="ewTableHeaderBtn"><thead><tr><td><?php echo $vwCPD_SPExpiredNotRenewed->ContactFirstName->FldCaption() ?><?php echo $Language->Phrase("SrchLegend") ?></td><td style="width: 10px;"><?php if ($vwCPD_SPExpiredNotRenewed->ContactFirstName->getSort() == "ASC") { ?><img src="images/sortup.gif" width="10" height="9" border="0"><?php } elseif ($vwCPD_SPExpiredNotRenewed->ContactFirstName->getSort() == "DESC") { ?><img src="images/sortdown.gif" width="10" height="9" border="0"><?php } ?></td></tr></thead></table> </div></td> <?php } ?> <?php } ?> <?php if ($vwCPD_SPExpiredNotRenewed->ContactSurname->Visible) { // ContactSurname ?> <?php if ($vwCPD_SPExpiredNotRenewed->SortUrl($vwCPD_SPExpiredNotRenewed->ContactSurname) == "") { ?> <td><?php echo $vwCPD_SPExpiredNotRenewed->ContactSurname->FldCaption() ?></td> <?php } else { ?> <td><div class="ewPointer" onmousedown="ew_Sort(event,'<?php echo $vwCPD_SPExpiredNotRenewed->SortUrl($vwCPD_SPExpiredNotRenewed->ContactSurname) ?>',2);"> <table cellspacing="0" class="ewTableHeaderBtn"><thead><tr><td><?php echo $vwCPD_SPExpiredNotRenewed->ContactSurname->FldCaption() ?><?php echo $Language->Phrase("SrchLegend") ?></td><td style="width: 10px;"><?php if ($vwCPD_SPExpiredNotRenewed->ContactSurname->getSort() == "ASC") { ?><img src="images/sortup.gif" width="10" height="9" border="0"><?php } elseif ($vwCPD_SPExpiredNotRenewed->ContactSurname->getSort() == "DESC") { ?><img src="images/sortdown.gif" width="10" height="9" border="0"><?php } ?></td></tr></thead></table> </div></td> <?php } ?> <?php } ?> <?php if ($vwCPD_SPExpiredNotRenewed->Approved->Visible) { // Approved ?> <?php if ($vwCPD_SPExpiredNotRenewed->SortUrl($vwCPD_SPExpiredNotRenewed->Approved) == "") { ?> <td><?php echo $vwCPD_SPExpiredNotRenewed->Approved->FldCaption() ?></td> <?php } else { ?> <td><div class="ewPointer" onmousedown="ew_Sort(event,'<?php echo $vwCPD_SPExpiredNotRenewed->SortUrl($vwCPD_SPExpiredNotRenewed->Approved) ?>',2);"> <table cellspacing="0" class="ewTableHeaderBtn"><thead><tr><td><?php echo $vwCPD_SPExpiredNotRenewed->Approved->FldCaption() ?><?php echo $Language->Phrase("SrchLegend") ?></td><td style="width: 10px;"><?php if ($vwCPD_SPExpiredNotRenewed->Approved->getSort() == "ASC") { ?><img src="images/sortup.gif" width="10" height="9" border="0"><?php } elseif ($vwCPD_SPExpiredNotRenewed->Approved->getSort() == "DESC") { ?><img src="images/sortdown.gif" width="10" height="9" border="0"><?php } ?></td></tr></thead></table> </div></td> <?php } ?> <?php } ?> <?php if ($vwCPD_SPExpiredNotRenewed->SPNumber->Visible) { // SPNumber ?> <?php if ($vwCPD_SPExpiredNotRenewed->SortUrl($vwCPD_SPExpiredNotRenewed->SPNumber) == "") { ?> <td><?php echo $vwCPD_SPExpiredNotRenewed->SPNumber->FldCaption() ?></td> <?php } else { ?> <td><div class="ewPointer" onmousedown="ew_Sort(event,'<?php echo $vwCPD_SPExpiredNotRenewed->SortUrl($vwCPD_SPExpiredNotRenewed->SPNumber) ?>',2);"> <table cellspacing="0" class="ewTableHeaderBtn"><thead><tr><td><?php echo $vwCPD_SPExpiredNotRenewed->SPNumber->FldCaption() ?><?php echo $Language->Phrase("SrchLegend") ?></td><td style="width: 10px;"><?php if ($vwCPD_SPExpiredNotRenewed->SPNumber->getSort() == "ASC") { ?><img src="images/sortup.gif" width="10" height="9" border="0"><?php } elseif ($vwCPD_SPExpiredNotRenewed->SPNumber->getSort() == "DESC") { ?><img src="images/sortdown.gif" width="10" height="9" border="0"><?php } ?></td></tr></thead></table> </div></td> <?php } ?> <?php } ?> <?php if ($vwCPD_SPExpiredNotRenewed->DateUpdated->Visible) { // DateUpdated ?> <?php if ($vwCPD_SPExpiredNotRenewed->SortUrl($vwCPD_SPExpiredNotRenewed->DateUpdated) == "") { ?> <td><?php echo $vwCPD_SPExpiredNotRenewed->DateUpdated->FldCaption() ?></td> <?php } else { ?> <td><div class="ewPointer" onmousedown="ew_Sort(event,'<?php echo $vwCPD_SPExpiredNotRenewed->SortUrl($vwCPD_SPExpiredNotRenewed->DateUpdated) ?>',2);"> <table cellspacing="0" class="ewTableHeaderBtn"><thead><tr><td><?php echo $vwCPD_SPExpiredNotRenewed->DateUpdated->FldCaption() ?></td><td style="width: 10px;"><?php if ($vwCPD_SPExpiredNotRenewed->DateUpdated->getSort() == "ASC") { ?><img src="images/sortup.gif" width="10" height="9" border="0"><?php } elseif ($vwCPD_SPExpiredNotRenewed->DateUpdated->getSort() == "DESC") { ?><img src="images/sortdown.gif" width="10" height="9" border="0"><?php } ?></td></tr></thead></table> </div></td> <?php } ?> <?php } ?> <?php if ($vwCPD_SPExpiredNotRenewed->DateAssessed->Visible) { // DateAssessed ?> <?php if ($vwCPD_SPExpiredNotRenewed->SortUrl($vwCPD_SPExpiredNotRenewed->DateAssessed) == "") { ?> <td><?php echo $vwCPD_SPExpiredNotRenewed->DateAssessed->FldCaption() ?></td> <?php } else { ?> <td><div class="ewPointer" onmousedown="ew_Sort(event,'<?php echo $vwCPD_SPExpiredNotRenewed->SortUrl($vwCPD_SPExpiredNotRenewed->DateAssessed) ?>',2);"> <table cellspacing="0" class="ewTableHeaderBtn"><thead><tr><td><?php echo $vwCPD_SPExpiredNotRenewed->DateAssessed->FldCaption() ?></td><td style="width: 10px;"><?php if ($vwCPD_SPExpiredNotRenewed->DateAssessed->getSort() == "ASC") { ?><img src="images/sortup.gif" width="10" height="9" border="0"><?php } elseif ($vwCPD_SPExpiredNotRenewed->DateAssessed->getSort() == "DESC") { ?><img src="images/sortdown.gif" width="10" height="9" border="0"><?php } ?></td></tr></thead></table> </div></td> <?php } ?> <?php } ?> <?php if ($vwCPD_SPExpiredNotRenewed->DateExpires->Visible) { // DateExpires ?> <?php if ($vwCPD_SPExpiredNotRenewed->SortUrl($vwCPD_SPExpiredNotRenewed->DateExpires) == "") { ?> <td><?php echo $vwCPD_SPExpiredNotRenewed->DateExpires->FldCaption() ?></td> <?php } else { ?> <td><div class="ewPointer" onmousedown="ew_Sort(event,'<?php echo $vwCPD_SPExpiredNotRenewed->SortUrl($vwCPD_SPExpiredNotRenewed->DateExpires) ?>',2);"> <table cellspacing="0" class="ewTableHeaderBtn"><thead><tr><td><?php echo $vwCPD_SPExpiredNotRenewed->DateExpires->FldCaption() ?></td><td style="width: 10px;"><?php if ($vwCPD_SPExpiredNotRenewed->DateExpires->getSort() == "ASC") { ?><img src="images/sortup.gif" width="10" height="9" border="0"><?php } elseif ($vwCPD_SPExpiredNotRenewed->DateExpires->getSort() == "DESC") { ?><img src="images/sortdown.gif" width="10" height="9" border="0"><?php } ?></td></tr></thead></table> </div></td> <?php } ?> <?php } ?> <?php if ($vwCPD_SPExpiredNotRenewed->DatePaid->Visible) { // DatePaid ?> <?php if ($vwCPD_SPExpiredNotRenewed->SortUrl($vwCPD_SPExpiredNotRenewed->DatePaid) == "") { ?> <td><?php echo $vwCPD_SPExpiredNotRenewed->DatePaid->FldCaption() ?></td> <?php } else { ?> <td><div class="ewPointer" onmousedown="ew_Sort(event,'<?php echo $vwCPD_SPExpiredNotRenewed->SortUrl($vwCPD_SPExpiredNotRenewed->DatePaid) ?>',2);"> <table cellspacing="0" class="ewTableHeaderBtn"><thead><tr><td><?php echo $vwCPD_SPExpiredNotRenewed->DatePaid->FldCaption() ?></td><td style="width: 10px;"><?php if ($vwCPD_SPExpiredNotRenewed->DatePaid->getSort() == "ASC") { ?><img src="images/sortup.gif" width="10" height="9" border="0"><?php } elseif ($vwCPD_SPExpiredNotRenewed->DatePaid->getSort() == "DESC") { ?><img src="images/sortdown.gif" width="10" height="9" border="0"><?php } ?></td></tr></thead></table> </div></td> <?php } ?> <?php } ?> <?php if ($vwCPD_SPExpiredNotRenewed->NumReminders->Visible) { // NumReminders ?> <?php if ($vwCPD_SPExpiredNotRenewed->SortUrl($vwCPD_SPExpiredNotRenewed->NumReminders) == "") { ?> <td><?php echo $vwCPD_SPExpiredNotRenewed->NumReminders->FldCaption() ?></td> <?php } else { ?> <td><div class="ewPointer" onmousedown="ew_Sort(event,'<?php echo $vwCPD_SPExpiredNotRenewed->SortUrl($vwCPD_SPExpiredNotRenewed->NumReminders) ?>',2);"> <table cellspacing="0" class="ewTableHeaderBtn"><thead><tr><td><?php echo $vwCPD_SPExpiredNotRenewed->NumReminders->FldCaption() ?></td><td style="width: 10px;"><?php if ($vwCPD_SPExpiredNotRenewed->NumReminders->getSort() == "ASC") { ?><img src="images/sortup.gif" width="10" height="9" border="0"><?php } elseif ($vwCPD_SPExpiredNotRenewed->NumReminders->getSort() == "DESC") { ?><img src="images/sortdown.gif" width="10" height="9" border="0"><?php } ?></td></tr></thead></table> </div></td> <?php } ?> <?php } ?> <?php if ($vwCPD_SPExpiredNotRenewed->LastReminder->Visible) { // LastReminder ?> <?php if ($vwCPD_SPExpiredNotRenewed->SortUrl($vwCPD_SPExpiredNotRenewed->LastReminder) == "") { ?> <td><?php echo $vwCPD_SPExpiredNotRenewed->LastReminder->FldCaption() ?></td> <?php } else { ?> <td><div class="ewPointer" onmousedown="ew_Sort(event,'<?php echo $vwCPD_SPExpiredNotRenewed->SortUrl($vwCPD_SPExpiredNotRenewed->LastReminder) ?>',2);"> <table cellspacing="0" class="ewTableHeaderBtn"><thead><tr><td><?php echo $vwCPD_SPExpiredNotRenewed->LastReminder->FldCaption() ?></td><td style="width: 10px;"><?php if ($vwCPD_SPExpiredNotRenewed->LastReminder->getSort() == "ASC") { ?><img src="images/sortup.gif" width="10" height="9" border="0"><?php } elseif ($vwCPD_SPExpiredNotRenewed->LastReminder->getSort() == "DESC") { ?><img src="images/sortdown.gif" width="10" height="9" border="0"><?php } ?></td></tr></thead></table> </div></td> <?php } ?> <?php } ?> <?php if ($vwCPD_SPExpiredNotRenewed->PrevSPNumber->Visible) { // PrevSPNumber ?> <?php if ($vwCPD_SPExpiredNotRenewed->SortUrl($vwCPD_SPExpiredNotRenewed->PrevSPNumber) == "") { ?> <td><?php echo $vwCPD_SPExpiredNotRenewed->PrevSPNumber->FldCaption() ?></td> <?php } else { ?> <td><div class="ewPointer" onmousedown="ew_Sort(event,'<?php echo $vwCPD_SPExpiredNotRenewed->SortUrl($vwCPD_SPExpiredNotRenewed->PrevSPNumber) ?>',2);"> <table cellspacing="0" class="ewTableHeaderBtn"><thead><tr><td><?php echo $vwCPD_SPExpiredNotRenewed->PrevSPNumber->FldCaption() ?><?php echo $Language->Phrase("SrchLegend") ?></td><td style="width: 10px;"><?php if ($vwCPD_SPExpiredNotRenewed->PrevSPNumber->getSort() == "ASC") { ?><img src="images/sortup.gif" width="10" height="9" border="0"><?php } elseif ($vwCPD_SPExpiredNotRenewed->PrevSPNumber->getSort() == "DESC") { ?><img src="images/sortdown.gif" width="10" height="9" border="0"><?php } ?></td></tr></thead></table> </div></td> <?php } ?> <?php } ?> <?php if ($vwCPD_SPExpiredNotRenewed->Renewal->Visible) { // Renewal ?> <?php if ($vwCPD_SPExpiredNotRenewed->SortUrl($vwCPD_SPExpiredNotRenewed->Renewal) == "") { ?> <td><?php echo $vwCPD_SPExpiredNotRenewed->Renewal->FldCaption() ?></td> <?php } else { ?> <td><div class="ewPointer" onmousedown="ew_Sort(event,'<?php echo $vwCPD_SPExpiredNotRenewed->SortUrl($vwCPD_SPExpiredNotRenewed->Renewal) ?>',2);"> <table cellspacing="0" class="ewTableHeaderBtn"><thead><tr><td><?php echo $vwCPD_SPExpiredNotRenewed->Renewal->FldCaption() ?></td><td style="width: 10px;"><?php if ($vwCPD_SPExpiredNotRenewed->Renewal->getSort() == "ASC") { ?><img src="images/sortup.gif" width="10" height="9" border="0"><?php } elseif ($vwCPD_SPExpiredNotRenewed->Renewal->getSort() == "DESC") { ?><img src="images/sortdown.gif" width="10" height="9" border="0"><?php } ?></td></tr></thead></table> </div></td> <?php } ?> <?php } ?> <?php if ($vwCPD_SPExpiredNotRenewed->DateCreated->Visible) { // DateCreated ?> <?php if ($vwCPD_SPExpiredNotRenewed->SortUrl($vwCPD_SPExpiredNotRenewed->DateCreated) == "") { ?> <td><?php echo $vwCPD_SPExpiredNotRenewed->DateCreated->FldCaption() ?></td> <?php } else { ?> <td><div class="ewPointer" onmousedown="ew_Sort(event,'<?php echo $vwCPD_SPExpiredNotRenewed->SortUrl($vwCPD_SPExpiredNotRenewed->DateCreated) ?>',2);"> <table cellspacing="0" class="ewTableHeaderBtn"><thead><tr><td><?php echo $vwCPD_SPExpiredNotRenewed->DateCreated->FldCaption() ?></td><td style="width: 10px;"><?php if ($vwCPD_SPExpiredNotRenewed->DateCreated->getSort() == "ASC") { ?><img src="images/sortup.gif" width="10" height="9" border="0"><?php } elseif ($vwCPD_SPExpiredNotRenewed->DateCreated->getSort() == "DESC") { ?><img src="images/sortdown.gif" width="10" height="9" border="0"><?php } ?></td></tr></thead></table> </div></td> <?php } ?> <?php } ?> <?php // Render list options (header, right) $vwCPD_SPExpiredNotRenewed_list->ListOptions->Render("header", "right"); ?> </tr> </thead> <?php if ($vwCPD_SPExpiredNotRenewed->ExportAll && $vwCPD_SPExpiredNotRenewed->Export <> "") { $vwCPD_SPExpiredNotRenewed_list->lStopRec = $vwCPD_SPExpiredNotRenewed_list->lTotalRecs; } else { $vwCPD_SPExpiredNotRenewed_list->lStopRec = $vwCPD_SPExpiredNotRenewed_list->lStartRec + $vwCPD_SPExpiredNotRenewed_list->lDisplayRecs - 1; // Set the last record to display } $vwCPD_SPExpiredNotRenewed_list->lRecCount = $vwCPD_SPExpiredNotRenewed_list->lStartRec - 1; if ($rs && !$rs->EOF) { $rs->MoveFirst(); if (!$bSelectLimit && $vwCPD_SPExpiredNotRenewed_list->lStartRec > 1) $rs->Move($vwCPD_SPExpiredNotRenewed_list->lStartRec - 1); } // Initialize aggregate $vwCPD_SPExpiredNotRenewed->RowType = EW_ROWTYPE_AGGREGATEINIT; $vwCPD_SPExpiredNotRenewed_list->RenderRow(); $vwCPD_SPExpiredNotRenewed_list->lRowCnt = 0; while (($vwCPD_SPExpiredNotRenewed->CurrentAction == "gridadd" || !$rs->EOF) && $vwCPD_SPExpiredNotRenewed_list->lRecCount < $vwCPD_SPExpiredNotRenewed_list->lStopRec) { $vwCPD_SPExpiredNotRenewed_list->lRecCount++; if (intval($vwCPD_SPExpiredNotRenewed_list->lRecCount) >= intval($vwCPD_SPExpiredNotRenewed_list->lStartRec)) { $vwCPD_SPExpiredNotRenewed_list->lRowCnt++; // Init row class and style $vwCPD_SPExpiredNotRenewed->CssClass = ""; $vwCPD_SPExpiredNotRenewed->CssStyle = ""; $vwCPD_SPExpiredNotRenewed->RowAttrs = array('onmouseover'=>'ew_MouseOver(event, this);', 'onmouseout'=>'ew_MouseOut(event, this);', 'onclick'=>'ew_Click(event, this);'); if ($vwCPD_SPExpiredNotRenewed->CurrentAction == "gridadd") { $vwCPD_SPExpiredNotRenewed_list->LoadDefaultValues(); // Load default values } else { $vwCPD_SPExpiredNotRenewed_list->LoadRowValues($rs); // Load row values } $vwCPD_SPExpiredNotRenewed->RowType = EW_ROWTYPE_VIEW; // Render view // Render row $vwCPD_SPExpiredNotRenewed_list->RenderRow(); // Render list options $vwCPD_SPExpiredNotRenewed_list->RenderListOptions(); ?> <tr<?php echo $vwCPD_SPExpiredNotRenewed->RowAttributes() ?>> <?php // Render list options (body, left) $vwCPD_SPExpiredNotRenewed_list->ListOptions->Render("body", "left"); ?> <?php if ($vwCPD_SPExpiredNotRenewed->CompanyName->Visible) { // CompanyName ?> <td<?php echo $vwCPD_SPExpiredNotRenewed->CompanyName->CellAttributes() ?>> <div<?php echo $vwCPD_SPExpiredNotRenewed->CompanyName->ViewAttributes() ?>><?php echo $vwCPD_SPExpiredNotRenewed->CompanyName->ListViewValue() ?></div> </td> <?php } ?> <?php if ($vwCPD_SPExpiredNotRenewed->TradingAs->Visible) { // TradingAs ?> <td<?php echo $vwCPD_SPExpiredNotRenewed->TradingAs->CellAttributes() ?>> <div<?php echo $vwCPD_SPExpiredNotRenewed->TradingAs->ViewAttributes() ?>><?php echo $vwCPD_SPExpiredNotRenewed->TradingAs->ListViewValue() ?></div> </td> <?php } ?> <?php if ($vwCPD_SPExpiredNotRenewed->ContactEmail->Visible) { // ContactEmail ?> <td<?php echo $vwCPD_SPExpiredNotRenewed->ContactEmail->CellAttributes() ?>> <div<?php echo $vwCPD_SPExpiredNotRenewed->ContactEmail->ViewAttributes() ?>><?php echo $vwCPD_SPExpiredNotRenewed->ContactEmail->ListViewValue() ?></div> </td> <?php } ?> <?php if ($vwCPD_SPExpiredNotRenewed->ContactFirstName->Visible) { // ContactFirstName ?> <td<?php echo $vwCPD_SPExpiredNotRenewed->ContactFirstName->CellAttributes() ?>> <div<?php echo $vwCPD_SPExpiredNotRenewed->ContactFirstName->ViewAttributes() ?>><?php echo $vwCPD_SPExpiredNotRenewed->ContactFirstName->ListViewValue() ?></div> </td> <?php } ?> <?php if ($vwCPD_SPExpiredNotRenewed->ContactSurname->Visible) { // ContactSurname ?> <td<?php echo $vwCPD_SPExpiredNotRenewed->ContactSurname->CellAttributes() ?>> <div<?php echo $vwCPD_SPExpiredNotRenewed->ContactSurname->ViewAttributes() ?>><?php echo $vwCPD_SPExpiredNotRenewed->ContactSurname->ListViewValue() ?></div> </td> <?php } ?> <?php if ($vwCPD_SPExpiredNotRenewed->Approved->Visible) { // Approved ?> <td<?php echo $vwCPD_SPExpiredNotRenewed->Approved->CellAttributes() ?>> <div<?php echo $vwCPD_SPExpiredNotRenewed->Approved->ViewAttributes() ?>><?php echo $vwCPD_SPExpiredNotRenewed->Approved->ListViewValue() ?></div> </td> <?php } ?> <?php if ($vwCPD_SPExpiredNotRenewed->SPNumber->Visible) { // SPNumber ?> <td<?php echo $vwCPD_SPExpiredNotRenewed->SPNumber->CellAttributes() ?>> <div<?php echo $vwCPD_SPExpiredNotRenewed->SPNumber->ViewAttributes() ?>><?php echo $vwCPD_SPExpiredNotRenewed->SPNumber->ListViewValue() ?></div> </td> <?php } ?> <?php if ($vwCPD_SPExpiredNotRenewed->DateUpdated->Visible) { // DateUpdated ?> <td<?php echo $vwCPD_SPExpiredNotRenewed->DateUpdated->CellAttributes() ?>> <div<?php echo $vwCPD_SPExpiredNotRenewed->DateUpdated->ViewAttributes() ?>><?php echo $vwCPD_SPExpiredNotRenewed->DateUpdated->ListViewValue() ?></div> </td> <?php } ?> <?php if ($vwCPD_SPExpiredNotRenewed->DateAssessed->Visible) { // DateAssessed ?> <td<?php echo $vwCPD_SPExpiredNotRenewed->DateAssessed->CellAttributes() ?>> <div<?php echo $vwCPD_SPExpiredNotRenewed->DateAssessed->ViewAttributes() ?>><?php echo $vwCPD_SPExpiredNotRenewed->DateAssessed->ListViewValue() ?></div> </td> <?php } ?> <?php if ($vwCPD_SPExpiredNotRenewed->DateExpires->Visible) { // DateExpires ?> <td<?php echo $vwCPD_SPExpiredNotRenewed->DateExpires->CellAttributes() ?>> <div<?php echo $vwCPD_SPExpiredNotRenewed->DateExpires->ViewAttributes() ?>><?php echo $vwCPD_SPExpiredNotRenewed->DateExpires->ListViewValue() ?></div> </td> <?php } ?> <?php if ($vwCPD_SPExpiredNotRenewed->DatePaid->Visible) { // DatePaid ?> <td<?php echo $vwCPD_SPExpiredNotRenewed->DatePaid->CellAttributes() ?>> <div<?php echo $vwCPD_SPExpiredNotRenewed->DatePaid->ViewAttributes() ?>><?php echo $vwCPD_SPExpiredNotRenewed->DatePaid->ListViewValue() ?></div> </td> <?php } ?> <?php if ($vwCPD_SPExpiredNotRenewed->NumReminders->Visible) { // NumReminders ?> <td<?php echo $vwCPD_SPExpiredNotRenewed->NumReminders->CellAttributes() ?>> <div<?php echo $vwCPD_SPExpiredNotRenewed->NumReminders->ViewAttributes() ?>><?php echo $vwCPD_SPExpiredNotRenewed->NumReminders->ListViewValue() ?></div> </td> <?php } ?> <?php if ($vwCPD_SPExpiredNotRenewed->LastReminder->Visible) { // LastReminder ?> <td<?php echo $vwCPD_SPExpiredNotRenewed->LastReminder->CellAttributes() ?>> <div<?php echo $vwCPD_SPExpiredNotRenewed->LastReminder->ViewAttributes() ?>><?php echo $vwCPD_SPExpiredNotRenewed->LastReminder->ListViewValue() ?></div> </td> <?php } ?> <?php if ($vwCPD_SPExpiredNotRenewed->PrevSPNumber->Visible) { // PrevSPNumber ?> <td<?php echo $vwCPD_SPExpiredNotRenewed->PrevSPNumber->CellAttributes() ?>> <div<?php echo $vwCPD_SPExpiredNotRenewed->PrevSPNumber->ViewAttributes() ?>><?php echo $vwCPD_SPExpiredNotRenewed->PrevSPNumber->ListViewValue() ?></div> </td> <?php } ?> <?php if ($vwCPD_SPExpiredNotRenewed->Renewal->Visible) { // Renewal ?> <td<?php echo $vwCPD_SPExpiredNotRenewed->Renewal->CellAttributes() ?>> <div<?php echo $vwCPD_SPExpiredNotRenewed->Renewal->ViewAttributes() ?>><?php echo $vwCPD_SPExpiredNotRenewed->Renewal->ListViewValue() ?></div> </td> <?php } ?> <?php if ($vwCPD_SPExpiredNotRenewed->DateCreated->Visible) { // DateCreated ?> <td<?php echo $vwCPD_SPExpiredNotRenewed->DateCreated->CellAttributes() ?>> <div<?php echo $vwCPD_SPExpiredNotRenewed->DateCreated->ViewAttributes() ?>><?php echo $vwCPD_SPExpiredNotRenewed->DateCreated->ListViewValue() ?></div> </td> <?php } ?> <?php // Render list options (body, right) $vwCPD_SPExpiredNotRenewed_list->ListOptions->Render("body", "right"); ?> </tr> <?php } if ($vwCPD_SPExpiredNotRenewed->CurrentAction <> "gridadd") $rs->MoveNext(); } ?> </tbody> </table> <?php } ?> </div> </form> <?php // Close recordset if ($rs) $rs->Close(); ?> <?php if ($vwCPD_SPExpiredNotRenewed_list->lTotalRecs > 0) { ?> <?php if ($vwCPD_SPExpiredNotRenewed->Export == "") { ?> <div class="ewGridLowerPanel"> <?php if ($vwCPD_SPExpiredNotRenewed->CurrentAction <> "gridadd" && $vwCPD_SPExpiredNotRenewed->CurrentAction <> "gridedit") { ?> <form name="ewpagerform" id="ewpagerform" class="ewForm" action="<?php echo ew_CurrentPage() ?>"> <table border="0" cellspacing="0" cellpadding="0" class="ewPager"> <tr> <td nowrap> <?php if (!isset($vwCPD_SPExpiredNotRenewed_list->Pager)) $vwCPD_SPExpiredNotRenewed_list->Pager = new cPrevNextPager($vwCPD_SPExpiredNotRenewed_list->lStartRec, $vwCPD_SPExpiredNotRenewed_list->lDisplayRecs, $vwCPD_SPExpiredNotRenewed_list->lTotalRecs) ?> <?php if ($vwCPD_SPExpiredNotRenewed_list->Pager->RecordCount > 0) { ?> <table border="0" cellspacing="0" cellpadding="0"><tr><td><span class="phpmaker"><?php echo $Language->Phrase("Page") ?> </span></td> <!--first page button--> <?php if ($vwCPD_SPExpiredNotRenewed_list->Pager->FirstButton->Enabled) { ?> <td><a href="<?php echo $vwCPD_SPExpiredNotRenewed_list->PageUrl() ?>start=<?php echo $vwCPD_SPExpiredNotRenewed_list->Pager->FirstButton->Start ?>"><img src="images/first.gif" alt="<?php echo $Language->Phrase("PagerFirst") ?>" width="16" height="16" border="0"></a></td> <?php } else { ?> <td><img src="images/firstdisab.gif" alt="<?php echo $Language->Phrase("PagerFirst") ?>" width="16" height="16" border="0"></td> <?php } ?> <!--previous page button--> <?php if ($vwCPD_SPExpiredNotRenewed_list->Pager->PrevButton->Enabled) { ?> <td><a href="<?php echo $vwCPD_SPExpiredNotRenewed_list->PageUrl() ?>start=<?php echo $vwCPD_SPExpiredNotRenewed_list->Pager->PrevButton->Start ?>"><img src="images/prev.gif" alt="<?php echo $Language->Phrase("PagerPrevious") ?>" width="16" height="16" border="0"></a></td> <?php } else { ?> <td><img src="images/prevdisab.gif" alt="<?php echo $Language->Phrase("PagerPrevious") ?>" width="16" height="16" border="0"></td> <?php } ?> <!--current page number--> <td><input type="text" name="<?php echo EW_TABLE_PAGE_NO ?>" id="<?php echo EW_TABLE_PAGE_NO ?>" value="<?php echo $vwCPD_SPExpiredNotRenewed_list->Pager->CurrentPage ?>" size="4"></td> <!--next page button--> <?php if ($vwCPD_SPExpiredNotRenewed_list->Pager->NextButton->Enabled) { ?> <td><a href="<?php echo $vwCPD_SPExpiredNotRenewed_list->PageUrl() ?>start=<?php echo $vwCPD_SPExpiredNotRenewed_list->Pager->NextButton->Start ?>"><img src="images/next.gif" alt="<?php echo $Language->Phrase("PagerNext") ?>" width="16" height="16" border="0"></a></td> <?php } else { ?> <td><img src="images/nextdisab.gif" alt="<?php echo $Language->Phrase("PagerNext") ?>" width="16" height="16" border="0"></td> <?php } ?> <!--last page button--> <?php if ($vwCPD_SPExpiredNotRenewed_list->Pager->LastButton->Enabled) { ?> <td><a href="<?php echo $vwCPD_SPExpiredNotRenewed_list->PageUrl() ?>start=<?php echo $vwCPD_SPExpiredNotRenewed_list->Pager->LastButton->Start ?>"><img src="images/last.gif" alt="<?php echo $Language->Phrase("PagerLast") ?>" width="16" height="16" border="0"></a></td> <?php } else { ?> <td><img src="images/lastdisab.gif" alt="<?php echo $Language->Phrase("PagerLast") ?>" width="16" height="16" border="0"></td> <?php } ?> <td><span class="phpmaker"> <?php echo $Language->Phrase("of") ?> <?php echo $vwCPD_SPExpiredNotRenewed_list->Pager->PageCount ?></span></td> </tr></table> </td> <td> </td> <td> <span class="phpmaker"><?php echo $Language->Phrase("Record") ?> <?php echo $vwCPD_SPExpiredNotRenewed_list->Pager->FromIndex ?> <?php echo $Language->Phrase("To") ?> <?php echo $vwCPD_SPExpiredNotRenewed_list->Pager->ToIndex ?> <?php echo $Language->Phrase("Of") ?> <?php echo $vwCPD_SPExpiredNotRenewed_list->Pager->RecordCount ?></span> <?php } else { ?> <?php if ($vwCPD_SPExpiredNotRenewed_list->sSrchWhere == "0=101") { ?> <span class="phpmaker"><?php echo $Language->Phrase("EnterSearchCriteria") ?></span> <?php } else { ?> <span class="phpmaker"><?php echo $Language->Phrase("NoRecord") ?></span> <?php } ?> <?php } ?> </td> </tr> </table> </form> <?php } ?> <?php //if ($vwCPD_SPExpiredNotRenewed_list->lTotalRecs > 0) { ?> <span class="phpmaker"> </span> <?php //} ?> </div> <?php } ?> <?php } ?> </td></tr></table> <?php if ($vwCPD_SPExpiredNotRenewed->Export == "" && $vwCPD_SPExpiredNotRenewed->CurrentAction == "") { ?> <?php } ?> <?php if ($vwCPD_SPExpiredNotRenewed->Export == "") { ?> <script language="JavaScript" type="text/javascript"> <!-- // Write your table-specific startup script here // document.write("page loaded"); //--> </script> <?php } ?> <?php include "footer.php" ?> <?php $vwCPD_SPExpiredNotRenewed_list->Page_Terminate(); ?> <?php // // Page class // class cvwCPD_SPExpiredNotRenewed_list { // Page ID var $PageID = 'list'; // Table name var $TableName = 'vwCPD_SPExpiredNotRenewed'; // Page object name var $PageObjName = 'vwCPD_SPExpiredNotRenewed_list'; // Page name function PageName() { return ew_CurrentPage(); } // Page URL function PageUrl() { $PageUrl = ew_CurrentPage() . "?"; global $vwCPD_SPExpiredNotRenewed; if ($vwCPD_SPExpiredNotRenewed->UseTokenInUrl) $PageUrl .= "t=" . $vwCPD_SPExpiredNotRenewed->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, $vwCPD_SPExpiredNotRenewed; if ($vwCPD_SPExpiredNotRenewed->UseTokenInUrl) { if ($objForm) return ($vwCPD_SPExpiredNotRenewed->TableVar == $objForm->GetValue("t")); if (@$_GET["t"] <> "") return ($vwCPD_SPExpiredNotRenewed->TableVar == $_GET["t"]); } else { return TRUE; } } // // Page class constructor // function __construct() { global $conn, $Language; // Language object $Language = new cLanguage(); // Table object (vwCPD_SPExpiredNotRenewed) $GLOBALS["vwCPD_SPExpiredNotRenewed"] = new cvwCPD_SPExpiredNotRenewed(); // Initialize URLs $this->ExportPrintUrl = $this->PageUrl() . "export=print"; $this->ExportExcelUrl = $this->PageUrl() . "export=excel"; $this->ExportWordUrl = $this->PageUrl() . "export=word"; $this->ExportHtmlUrl = $this->PageUrl() . "export=html"; $this->ExportXmlUrl = $this->PageUrl() . "export=xml"; $this->ExportCsvUrl = $this->PageUrl() . "export=csv"; $this->AddUrl = $GLOBALS["vwCPD_SPExpiredNotRenewed"]->AddUrl(); $this->InlineAddUrl = $this->PageUrl() . "a=add"; $this->GridAddUrl = $this->PageUrl() . "a=gridadd"; $this->GridEditUrl = $this->PageUrl() . "a=gridedit"; $this->MultiDeleteUrl = "vwCPD_SPExpiredNotReneweddelete.php"; $this->MultiUpdateUrl = "vwCPD_SPExpiredNotRenewedupdate.php"; // Table object (CPDAdminUsers) $GLOBALS['CPDAdminUsers'] = new cCPDAdminUsers(); // Page ID if (!defined("EW_PAGE_ID")) define("EW_PAGE_ID", 'list', TRUE); // Table name (for backward compatibility) if (!defined("EW_TABLE_NAME")) define("EW_TABLE_NAME", 'vwCPD_SPExpiredNotRenewed', TRUE); // Start timer $GLOBALS["gsTimer"] = new cTimer(); // Open connection $conn = ew_Connect(); // List options $this->ListOptions = new cListOptions(); } // // Page_Init // function Page_Init() { global $gsExport, $gsExportFile, $UserProfile, $Language, $Security, $objForm; global $vwCPD_SPExpiredNotRenewed; // User profile $UserProfile = new cUserProfile(); $UserProfile->LoadProfile(@$_SESSION[EW_SESSION_USER_PROFILE]); // Security $Security = new cAdvancedSecurity(); if (IsPasswordExpired()) $this->Page_Terminate("changepwd.php"); if (!$Security->IsLoggedIn()) $Security->AutoLogin(); if (!$Security->IsLoggedIn()) { $Security->SaveLastUrl(); $this->Page_Terminate("login.php"); } // Get export parameters if (@$_GET["export"] <> "") { $vwCPD_SPExpiredNotRenewed->Export = $_GET["export"]; } elseif (ew_IsHttpPost()) { if (@$_POST["exporttype"] <> "") $vwCPD_SPExpiredNotRenewed->Export = $_POST["exporttype"]; } else { $vwCPD_SPExpiredNotRenewed->setExportReturnUrl(ew_CurrentUrl()); } $gsExport = $vwCPD_SPExpiredNotRenewed->Export; // Get export parameter, used in header $gsExportFile = $vwCPD_SPExpiredNotRenewed->TableVar; // Get export file, used in header if ($vwCPD_SPExpiredNotRenewed->Export == "excel") { header('Content-Type: application/vnd.ms-excel'); header('Content-Disposition: attachment; filename=' . $gsExportFile .'.xls'); } if ($vwCPD_SPExpiredNotRenewed->Export == "word") { header('Content-Type: application/vnd.ms-word'); header('Content-Disposition: attachment; filename=' . $gsExportFile .'.doc'); } // Global Page Loading event (in userfn*.php) Page_Loading(); // Page Load event $this->Page_Load(); } // // Page_Terminate // function Page_Terminate($url = "") { global $conn; // Page Unload event $this->Page_Unload(); // Global Page Unloaded event (in userfn*.php) Page_Unloaded(); // Close connection $conn->Close(); // Go to URL if specified $this->Page_Redirecting($url); if ($url <> "") { if (!EW_DEBUG_ENABLED && ob_get_length()) ob_end_clean(); header("Location: " . $url); } exit(); } // Class variables var $ListOptions; // List options var $lDisplayRecs = 20; var $lStartRec; var $lStopRec; var $lTotalRecs = 0; var $lRecRange = 10; var $sSrchWhere = ""; // Search WHERE clause var $lRecCnt = 0; // Record count var $lEditRowCnt; var $lRowCnt; var $lRowIndex; // Row index var $lRecPerRow = 0; var $lColCnt = 0; var $sDbMasterFilter = ""; // Master filter var $sDbDetailFilter = ""; // Detail filter var $bMasterRecordExists; var $sMultiSelectKey; var $RestoreSearch; // // Page main // function Page_Main() { global $objForm, $Language, $gsSearchError, $Security, $vwCPD_SPExpiredNotRenewed; // Search filters $sSrchAdvanced = ""; // Advanced search filter $sSrchBasic = ""; // Basic search filter $sFilter = ""; if ($this->IsPageRequest()) { // Validate request // Handle reset command $this->ResetCmd(); // Set up list options $this->SetupListOptions(); // Get basic search values $this->LoadBasicSearchValues(); // Restore search parms from Session $this->RestoreSearchParms(); // Call Recordset SearchValidated event $vwCPD_SPExpiredNotRenewed->Recordset_SearchValidated(); // Set up sorting order $this->SetUpSortOrder(); // Get basic search criteria if ($gsSearchError == "") $sSrchBasic = $this->BasicSearchWhere(); } // Restore display records if ($vwCPD_SPExpiredNotRenewed->getRecordsPerPage() <> "") { $this->lDisplayRecs = $vwCPD_SPExpiredNotRenewed->getRecordsPerPage(); // Restore from Session } else { $this->lDisplayRecs = 20; // Load default } // Load Sorting Order $this->LoadSortOrder(); // Build search criteria if ($sSrchAdvanced <> "") $this->sSrchWhere = ($this->sSrchWhere <> "") ? "(" . $this->sSrchWhere . ") AND (" . $sSrchAdvanced . ")" : $sSrchAdvanced; if ($sSrchBasic <> "") $this->sSrchWhere = ($this->sSrchWhere <> "") ? "(" . $this->sSrchWhere . ") AND (" . $sSrchBasic. ")" : $sSrchBasic; // Call Recordset_Searching event $vwCPD_SPExpiredNotRenewed->Recordset_Searching($this->sSrchWhere); // Save search criteria if ($this->sSrchWhere <> "") { if ($sSrchBasic == "") $this->ResetBasicSearchParms(); $vwCPD_SPExpiredNotRenewed->setSearchWhere($this->sSrchWhere); // Save to Session if (!$this->RestoreSearch) { $this->lStartRec = 1; // Reset start record counter $vwCPD_SPExpiredNotRenewed->setStartRecordNumber($this->lStartRec); } } else { $this->sSrchWhere = $vwCPD_SPExpiredNotRenewed->getSearchWhere(); } // Build filter $sFilter = ""; if ($this->sDbDetailFilter <> "") $sFilter = ($sFilter <> "") ? "(" . $sFilter . ") AND (" . $this->sDbDetailFilter . ")" : $this->sDbDetailFilter; if ($this->sSrchWhere <> "") $sFilter = ($sFilter <> "") ? "(" . $sFilter . ") AND (". $this->sSrchWhere . ")" : $this->sSrchWhere; // Set up filter in session $vwCPD_SPExpiredNotRenewed->setSessionWhere($sFilter); $vwCPD_SPExpiredNotRenewed->CurrentFilter = ""; // Export data only if (in_array($vwCPD_SPExpiredNotRenewed->Export, array("html","word","excel","xml","csv","email"))) { $this->ExportData(); if ($vwCPD_SPExpiredNotRenewed->Export <> "email") $this->Page_Terminate(); // Terminate response exit(); } } // Return basic search SQL function BasicSearchSQL($Keyword) { global $vwCPD_SPExpiredNotRenewed; $sKeyword = ew_AdjustSql($Keyword); $sWhere = ""; $this->BuildBasicSearchSQL($sWhere, $vwCPD_SPExpiredNotRenewed->CompanyName, $Keyword); $this->BuildBasicSearchSQL($sWhere, $vwCPD_SPExpiredNotRenewed->TradingAs, $Keyword); $this->BuildBasicSearchSQL($sWhere, $vwCPD_SPExpiredNotRenewed->ContactTitle, $Keyword); $this->BuildBasicSearchSQL($sWhere, $vwCPD_SPExpiredNotRenewed->ContactInitials, $Keyword); $this->BuildBasicSearchSQL($sWhere, $vwCPD_SPExpiredNotRenewed->ContactEmail, $Keyword); $this->BuildBasicSearchSQL($sWhere, $vwCPD_SPExpiredNotRenewed->ContactFirstName, $Keyword); $this->BuildBasicSearchSQL($sWhere, $vwCPD_SPExpiredNotRenewed->ContactSurname, $Keyword); $this->BuildBasicSearchSQL($sWhere, $vwCPD_SPExpiredNotRenewed->ContactPosition, $Keyword); $this->BuildBasicSearchSQL($sWhere, $vwCPD_SPExpiredNotRenewed->ContactIDNum, $Keyword); $this->BuildBasicSearchSQL($sWhere, $vwCPD_SPExpiredNotRenewed->PhoneNumber, $Keyword); $this->BuildBasicSearchSQL($sWhere, $vwCPD_SPExpiredNotRenewed->Password, $Keyword); $this->BuildBasicSearchSQL($sWhere, $vwCPD_SPExpiredNotRenewed->PhysicalAddress1, $Keyword); $this->BuildBasicSearchSQL($sWhere, $vwCPD_SPExpiredNotRenewed->PhysicalAddress2, $Keyword); $this->BuildBasicSearchSQL($sWhere, $vwCPD_SPExpiredNotRenewed->PhysicalCity, $Keyword); $this->BuildBasicSearchSQL($sWhere, $vwCPD_SPExpiredNotRenewed->PhysicalCode, $Keyword); $this->BuildBasicSearchSQL($sWhere, $vwCPD_SPExpiredNotRenewed->PhysicalProvince, $Keyword); $this->BuildBasicSearchSQL($sWhere, $vwCPD_SPExpiredNotRenewed->PhysicalCountry, $Keyword); $this->BuildBasicSearchSQL($sWhere, $vwCPD_SPExpiredNotRenewed->PostalAddress1, $Keyword); $this->BuildBasicSearchSQL($sWhere, $vwCPD_SPExpiredNotRenewed->PostalAddress2, $Keyword); $this->BuildBasicSearchSQL($sWhere, $vwCPD_SPExpiredNotRenewed->PostalCity, $Keyword); $this->BuildBasicSearchSQL($sWhere, $vwCPD_SPExpiredNotRenewed->PostalCode, $Keyword); $this->BuildBasicSearchSQL($sWhere, $vwCPD_SPExpiredNotRenewed->PostalProvince, $Keyword); $this->BuildBasicSearchSQL($sWhere, $vwCPD_SPExpiredNotRenewed->PostalCountry, $Keyword); $this->BuildBasicSearchSQL($sWhere, $vwCPD_SPExpiredNotRenewed->Website, $Keyword); $this->BuildBasicSearchSQL($sWhere, $vwCPD_SPExpiredNotRenewed->VATNumber, $Keyword); $this->BuildBasicSearchSQL($sWhere, $vwCPD_SPExpiredNotRenewed->Approved, $Keyword); $this->BuildBasicSearchSQL($sWhere, $vwCPD_SPExpiredNotRenewed->SPNumber, $Keyword); $this->BuildBasicSearchSQL($sWhere, $vwCPD_SPExpiredNotRenewed->UpdatedBy, $Keyword); $this->BuildBasicSearchSQL($sWhere, $vwCPD_SPExpiredNotRenewed->ContactPhone, $Keyword); $this->BuildBasicSearchSQL($sWhere, $vwCPD_SPExpiredNotRenewed->AdminTitle, $Keyword); $this->BuildBasicSearchSQL($sWhere, $vwCPD_SPExpiredNotRenewed->AdminInitials, $Keyword); $this->BuildBasicSearchSQL($sWhere, $vwCPD_SPExpiredNotRenewed->AdminFirstName, $Keyword); $this->BuildBasicSearchSQL($sWhere, $vwCPD_SPExpiredNotRenewed->AdminSurname, $Keyword); $this->BuildBasicSearchSQL($sWhere, $vwCPD_SPExpiredNotRenewed->AdminPosition, $Keyword); $this->BuildBasicSearchSQL($sWhere, $vwCPD_SPExpiredNotRenewed->AdminIDNum, $Keyword); $this->BuildBasicSearchSQL($sWhere, $vwCPD_SPExpiredNotRenewed->AdminEmail, $Keyword); $this->BuildBasicSearchSQL($sWhere, $vwCPD_SPExpiredNotRenewed->AdminPhone, $Keyword); $this->BuildBasicSearchSQL($sWhere, $vwCPD_SPExpiredNotRenewed->EmailAddress, $Keyword); $this->BuildBasicSearchSQL($sWhere, $vwCPD_SPExpiredNotRenewed->InvoiceCode, $Keyword); $this->BuildBasicSearchSQL($sWhere, $vwCPD_SPExpiredNotRenewed->InvoiceNumber, $Keyword); $this->BuildBasicSearchSQL($sWhere, $vwCPD_SPExpiredNotRenewed->Comments, $Keyword); $this->BuildBasicSearchSQL($sWhere, $vwCPD_SPExpiredNotRenewed->CellNumber, $Keyword); $this->BuildBasicSearchSQL($sWhere, $vwCPD_SPExpiredNotRenewed->ContactCell, $Keyword); $this->BuildBasicSearchSQL($sWhere, $vwCPD_SPExpiredNotRenewed->AdminCell, $Keyword); $this->BuildBasicSearchSQL($sWhere, $vwCPD_SPExpiredNotRenewed->InvoiceFile, $Keyword); $this->BuildBasicSearchSQL($sWhere, $vwCPD_SPExpiredNotRenewed->ProofOfPayment, $Keyword); $this->BuildBasicSearchSQL($sWhere, $vwCPD_SPExpiredNotRenewed->EvaluatorInvoice, $Keyword); $this->BuildBasicSearchSQL($sWhere, $vwCPD_SPExpiredNotRenewed->EvaluatorTimesheet, $Keyword); $this->BuildBasicSearchSQL($sWhere, $vwCPD_SPExpiredNotRenewed->PrevSPNumber, $Keyword); return $sWhere; } // Build basic search SQL function BuildBasicSearchSql(&$Where, &$Fld, $Keyword) { $sFldExpression = ($Fld->FldVirtualExpression <> "") ? $Fld->FldVirtualExpression : $Fld->FldExpression; $lFldDataType = ($Fld->FldIsVirtual) ? EW_DATATYPE_STRING : $Fld->FldDataType; if ($lFldDataType == EW_DATATYPE_NUMBER) { $sWrk = $sFldExpression . " = " . ew_QuotedValue($Keyword, $lFldDataType); } else { $sWrk = $sFldExpression . " LIKE " . ew_QuotedValue("%" . $Keyword . "%", $lFldDataType); } if ($Where <> "") $Where .= " OR "; $Where .= $sWrk; } // Return basic search WHERE clause based on search keyword and type function BasicSearchWhere() { global $Security, $vwCPD_SPExpiredNotRenewed; $sSearchStr = ""; $sSearchKeyword = $vwCPD_SPExpiredNotRenewed->BasicSearchKeyword; $sSearchType = $vwCPD_SPExpiredNotRenewed->BasicSearchType; if ($sSearchKeyword <> "") { $sSearch = trim($sSearchKeyword); if ($sSearchType <> "") { while (strpos($sSearch, " ") !== FALSE) $sSearch = str_replace(" ", " ", $sSearch); $arKeyword = explode(" ", trim($sSearch)); foreach ($arKeyword as $sKeyword) { if ($sSearchStr <> "") $sSearchStr .= " " . $sSearchType . " "; $sSearchStr .= "(" . $this->BasicSearchSQL($sKeyword) . ")"; } } else { $sSearchStr = $this->BasicSearchSQL($sSearch); } } if ($sSearchKeyword <> "") { $vwCPD_SPExpiredNotRenewed->setSessionBasicSearchKeyword($sSearchKeyword); $vwCPD_SPExpiredNotRenewed->setSessionBasicSearchType($sSearchType); } return $sSearchStr; } // Clear all search parameters function ResetSearchParms() { global $vwCPD_SPExpiredNotRenewed; // Clear search WHERE clause $this->sSrchWhere = ""; $vwCPD_SPExpiredNotRenewed->setSearchWhere($this->sSrchWhere); // Clear basic search parameters $this->ResetBasicSearchParms(); } // Clear all basic search parameters function ResetBasicSearchParms() { global $vwCPD_SPExpiredNotRenewed; $vwCPD_SPExpiredNotRenewed->setSessionBasicSearchKeyword(""); $vwCPD_SPExpiredNotRenewed->setSessionBasicSearchType(""); } // Restore all search parameters function RestoreSearchParms() { global $vwCPD_SPExpiredNotRenewed; $bRestore = TRUE; if (@$_GET[EW_TABLE_BASIC_SEARCH] <> "") $bRestore = FALSE; $this->RestoreSearch = $bRestore; if ($bRestore) { // Restore basic search values $vwCPD_SPExpiredNotRenewed->BasicSearchKeyword = $vwCPD_SPExpiredNotRenewed->getSessionBasicSearchKeyword(); $vwCPD_SPExpiredNotRenewed->BasicSearchType = $vwCPD_SPExpiredNotRenewed->getSessionBasicSearchType(); } } // Set up sort parameters function SetUpSortOrder() { global $vwCPD_SPExpiredNotRenewed; // Check for Ctrl pressed $bCtrl = (@$_GET["ctrl"] <> ""); // Check for "order" parameter if (@$_GET["order"] <> "") { $vwCPD_SPExpiredNotRenewed->CurrentOrder = ew_StripSlashes(@$_GET["order"]); $vwCPD_SPExpiredNotRenewed->CurrentOrderType = @$_GET["ordertype"]; $vwCPD_SPExpiredNotRenewed->UpdateSort($vwCPD_SPExpiredNotRenewed->CompanyName, $bCtrl); // CompanyName $vwCPD_SPExpiredNotRenewed->UpdateSort($vwCPD_SPExpiredNotRenewed->TradingAs, $bCtrl); // TradingAs $vwCPD_SPExpiredNotRenewed->UpdateSort($vwCPD_SPExpiredNotRenewed->ContactEmail, $bCtrl); // ContactEmail $vwCPD_SPExpiredNotRenewed->UpdateSort($vwCPD_SPExpiredNotRenewed->ContactFirstName, $bCtrl); // ContactFirstName $vwCPD_SPExpiredNotRenewed->UpdateSort($vwCPD_SPExpiredNotRenewed->ContactSurname, $bCtrl); // ContactSurname $vwCPD_SPExpiredNotRenewed->UpdateSort($vwCPD_SPExpiredNotRenewed->Approved, $bCtrl); // Approved $vwCPD_SPExpiredNotRenewed->UpdateSort($vwCPD_SPExpiredNotRenewed->SPNumber, $bCtrl); // SPNumber $vwCPD_SPExpiredNotRenewed->UpdateSort($vwCPD_SPExpiredNotRenewed->DateUpdated, $bCtrl); // DateUpdated $vwCPD_SPExpiredNotRenewed->UpdateSort($vwCPD_SPExpiredNotRenewed->DateAssessed, $bCtrl); // DateAssessed $vwCPD_SPExpiredNotRenewed->UpdateSort($vwCPD_SPExpiredNotRenewed->DateExpires, $bCtrl); // DateExpires $vwCPD_SPExpiredNotRenewed->UpdateSort($vwCPD_SPExpiredNotRenewed->DatePaid, $bCtrl); // DatePaid $vwCPD_SPExpiredNotRenewed->UpdateSort($vwCPD_SPExpiredNotRenewed->NumReminders, $bCtrl); // NumReminders $vwCPD_SPExpiredNotRenewed->UpdateSort($vwCPD_SPExpiredNotRenewed->LastReminder, $bCtrl); // LastReminder $vwCPD_SPExpiredNotRenewed->UpdateSort($vwCPD_SPExpiredNotRenewed->PrevSPNumber, $bCtrl); // PrevSPNumber $vwCPD_SPExpiredNotRenewed->UpdateSort($vwCPD_SPExpiredNotRenewed->Renewal, $bCtrl); // Renewal $vwCPD_SPExpiredNotRenewed->UpdateSort($vwCPD_SPExpiredNotRenewed->DateCreated, $bCtrl); // DateCreated $vwCPD_SPExpiredNotRenewed->setStartRecordNumber(1); // Reset start position } } // Load sort order parameters function LoadSortOrder() { global $vwCPD_SPExpiredNotRenewed; $sOrderBy = $vwCPD_SPExpiredNotRenewed->getSessionOrderBy(); // Get ORDER BY from Session if ($sOrderBy == "") { if ($vwCPD_SPExpiredNotRenewed->SqlOrderBy() <> "") { $sOrderBy = $vwCPD_SPExpiredNotRenewed->SqlOrderBy(); $vwCPD_SPExpiredNotRenewed->setSessionOrderBy($sOrderBy); $vwCPD_SPExpiredNotRenewed->CompanyName->setSort("ASC"); } } } // Reset command // cmd=reset (Reset search parameters) // cmd=resetall (Reset search and master/detail parameters) // cmd=resetsort (Reset sort parameters) function ResetCmd() { global $vwCPD_SPExpiredNotRenewed; // Get reset command if (@$_GET["cmd"] <> "") { $sCmd = $_GET["cmd"]; // Reset search criteria if (strtolower($sCmd) == "reset" || strtolower($sCmd) == "resetall") $this->ResetSearchParms(); // Reset sorting order if (strtolower($sCmd) == "resetsort") { $sOrderBy = ""; $vwCPD_SPExpiredNotRenewed->setSessionOrderBy($sOrderBy); $vwCPD_SPExpiredNotRenewed->CompanyName->setSort(""); $vwCPD_SPExpiredNotRenewed->TradingAs->setSort(""); $vwCPD_SPExpiredNotRenewed->ContactEmail->setSort(""); $vwCPD_SPExpiredNotRenewed->ContactFirstName->setSort(""); $vwCPD_SPExpiredNotRenewed->ContactSurname->setSort(""); $vwCPD_SPExpiredNotRenewed->Approved->setSort(""); $vwCPD_SPExpiredNotRenewed->SPNumber->setSort(""); $vwCPD_SPExpiredNotRenewed->DateUpdated->setSort(""); $vwCPD_SPExpiredNotRenewed->DateAssessed->setSort(""); $vwCPD_SPExpiredNotRenewed->DateExpires->setSort(""); $vwCPD_SPExpiredNotRenewed->DatePaid->setSort(""); $vwCPD_SPExpiredNotRenewed->NumReminders->setSort(""); $vwCPD_SPExpiredNotRenewed->LastReminder->setSort(""); $vwCPD_SPExpiredNotRenewed->PrevSPNumber->setSort(""); $vwCPD_SPExpiredNotRenewed->Renewal->setSort(""); $vwCPD_SPExpiredNotRenewed->DateCreated->setSort(""); } // Reset start position $this->lStartRec = 1; $vwCPD_SPExpiredNotRenewed->setStartRecordNumber($this->lStartRec); } } // Set up list options function SetupListOptions() { global $Security, $vwCPD_SPExpiredNotRenewed; // "detail_CPDServiceProvider" $this->ListOptions->Add("detail_CPDServiceProvider"); $item =& $this->ListOptions->Items["detail_CPDServiceProvider"]; $item->CssStyle = "white-space: nowrap;"; $item->Visible = $Security->IsLoggedIn(); $item->OnLeft = FALSE; // Call ListOptions_Load event $this->ListOptions_Load(); if ($vwCPD_SPExpiredNotRenewed->Export <> "" || $vwCPD_SPExpiredNotRenewed->CurrentAction == "gridadd" || $vwCPD_SPExpiredNotRenewed->CurrentAction == "gridedit") $this->ListOptions->HideAllOptions(); } // Render list options function RenderListOptions() { global $Security, $Language, $vwCPD_SPExpiredNotRenewed; $this->ListOptions->LoadDefault(); // "detail_CPDServiceProvider" $oListOpt =& $this->ListOptions->Items["detail_CPDServiceProvider"]; if ($Security->IsLoggedIn()) { $oListOpt->Body = "<img src=\"images/detail.gif\" alt=\"" . ew_HtmlEncode($Language->Phrase("DetailLink")) . "\" title=\"" . ew_HtmlEncode($Language->Phrase("DetailLink")) . "\" width=\"16\" height=\"16\" border=\"0\">" . $Language->TablePhrase("CPDServiceProvider", "TblCaption"); $oListOpt->Body = "<a href=\"CPDServiceProviderlist.php?" . EW_TABLE_SHOW_MASTER . "=vwCPD_SPExpiredNotRenewed&CPDProviderID=" . urlencode(strval($vwCPD_SPExpiredNotRenewed->CPDProviderID->CurrentValue)) . "\">" . $oListOpt->Body . "</a>"; } $this->RenderListOptionsExt(); // Call ListOptions_Rendered event $this->ListOptions_Rendered(); } function RenderListOptionsExt() { global $Security, $Language, $vwCPD_SPExpiredNotRenewed; } // Set up starting record parameters function SetUpStartRec() { global $vwCPD_SPExpiredNotRenewed; if ($this->lDisplayRecs == 0) return; if ($this->IsPageRequest()) { // Validate request if (@$_GET[EW_TABLE_START_REC] <> "") { // Check for "start" parameter $this->lStartRec = $_GET[EW_TABLE_START_REC]; $vwCPD_SPExpiredNotRenewed->setStartRecordNumber($this->lStartRec); } elseif (@$_GET[EW_TABLE_PAGE_NO] <> "") { $this->nPageNo = $_GET[EW_TABLE_PAGE_NO]; if (is_numeric($this->nPageNo)) { $this->lStartRec = ($this->nPageNo-1)*$this->lDisplayRecs+1; if ($this->lStartRec <= 0) { $this->lStartRec = 1; } elseif ($this->lStartRec >= intval(($this->lTotalRecs-1)/$this->lDisplayRecs)*$this->lDisplayRecs+1) { $this->lStartRec = intval(($this->lTotalRecs-1)/$this->lDisplayRecs)*$this->lDisplayRecs+1; } $vwCPD_SPExpiredNotRenewed->setStartRecordNumber($this->lStartRec); } } } $this->lStartRec = $vwCPD_SPExpiredNotRenewed->getStartRecordNumber(); // Check if correct start record counter if (!is_numeric($this->lStartRec) || $this->lStartRec == "") { // Avoid invalid start record counter $this->lStartRec = 1; // Reset start record counter $vwCPD_SPExpiredNotRenewed->setStartRecordNumber($this->lStartRec); } elseif (intval($this->lStartRec) > intval($this->lTotalRecs)) { // Avoid starting record > total records $this->lStartRec = intval(($this->lTotalRecs-1)/$this->lDisplayRecs)*$this->lDisplayRecs+1; // Point to last page first record $vwCPD_SPExpiredNotRenewed->setStartRecordNumber($this->lStartRec); } elseif (($this->lStartRec-1) % $this->lDisplayRecs <> 0) { $this->lStartRec = intval(($this->lStartRec-1)/$this->lDisplayRecs)*$this->lDisplayRecs+1; // Point to page boundary $vwCPD_SPExpiredNotRenewed->setStartRecordNumber($this->lStartRec); } } // Load basic search values function LoadBasicSearchValues() { global $vwCPD_SPExpiredNotRenewed; $vwCPD_SPExpiredNotRenewed->BasicSearchKeyword = @$_GET[EW_TABLE_BASIC_SEARCH]; $vwCPD_SPExpiredNotRenewed->BasicSearchType = @$_GET[EW_TABLE_BASIC_SEARCH_TYPE]; } // Load recordset function LoadRecordset($offset = -1, $rowcnt = -1) { global $conn, $vwCPD_SPExpiredNotRenewed; // Call Recordset Selecting event $vwCPD_SPExpiredNotRenewed->Recordset_Selecting($vwCPD_SPExpiredNotRenewed->CurrentFilter); // Load List page SQL $sSql = $vwCPD_SPExpiredNotRenewed->SelectSQL(); if ($offset > -1 && $rowcnt > -1) $sSql .= " LIMIT $offset, $rowcnt"; // Load recordset $rs = ew_LoadRecordset($sSql); // Call Recordset Selected event $vwCPD_SPExpiredNotRenewed->Recordset_Selected($rs); return $rs; } // Load row based on key values function LoadRow() { global $conn, $Security, $vwCPD_SPExpiredNotRenewed; $sFilter = $vwCPD_SPExpiredNotRenewed->KeyFilter(); // Call Row Selecting event $vwCPD_SPExpiredNotRenewed->Row_Selecting($sFilter); // Load SQL based on filter $vwCPD_SPExpiredNotRenewed->CurrentFilter = $sFilter; $sSql = $vwCPD_SPExpiredNotRenewed->SQL(); $res = FALSE; $rs = ew_LoadRecordset($sSql); if ($rs && !$rs->EOF) { $res = TRUE; $this->LoadRowValues($rs); // Load row values // Call Row Selected event $vwCPD_SPExpiredNotRenewed->Row_Selected($rs); $rs->Close(); } return $res; } // Load row values from recordset function LoadRowValues(&$rs) { global $conn, $vwCPD_SPExpiredNotRenewed; $vwCPD_SPExpiredNotRenewed->CPDProviderID->setDbValue($rs->fields('CPDProviderID')); $vwCPD_SPExpiredNotRenewed->CompanyName->setDbValue($rs->fields('CompanyName')); $vwCPD_SPExpiredNotRenewed->TradingAs->setDbValue($rs->fields('TradingAs')); $vwCPD_SPExpiredNotRenewed->ContactTitle->setDbValue($rs->fields('ContactTitle')); $vwCPD_SPExpiredNotRenewed->ContactInitials->setDbValue($rs->fields('ContactInitials')); $vwCPD_SPExpiredNotRenewed->ContactEmail->setDbValue($rs->fields('ContactEmail')); $vwCPD_SPExpiredNotRenewed->ContactFirstName->setDbValue($rs->fields('ContactFirstName')); $vwCPD_SPExpiredNotRenewed->ContactSurname->setDbValue($rs->fields('ContactSurname')); $vwCPD_SPExpiredNotRenewed->ContactPosition->setDbValue($rs->fields('ContactPosition')); $vwCPD_SPExpiredNotRenewed->ContactIDNum->setDbValue($rs->fields('ContactIDNum')); $vwCPD_SPExpiredNotRenewed->PhoneNumber->setDbValue($rs->fields('PhoneNumber')); $vwCPD_SPExpiredNotRenewed->Password->setDbValue($rs->fields('Password')); $vwCPD_SPExpiredNotRenewed->PhysicalAddress1->setDbValue($rs->fields('PhysicalAddress1')); $vwCPD_SPExpiredNotRenewed->PhysicalAddress2->setDbValue($rs->fields('PhysicalAddress2')); $vwCPD_SPExpiredNotRenewed->PhysicalCity->setDbValue($rs->fields('PhysicalCity')); $vwCPD_SPExpiredNotRenewed->PhysicalCode->setDbValue($rs->fields('PhysicalCode')); $vwCPD_SPExpiredNotRenewed->PhysicalProvince->setDbValue($rs->fields('PhysicalProvince')); $vwCPD_SPExpiredNotRenewed->PhysicalCountry->setDbValue($rs->fields('PhysicalCountry')); $vwCPD_SPExpiredNotRenewed->PostalAddress1->setDbValue($rs->fields('PostalAddress1')); $vwCPD_SPExpiredNotRenewed->PostalAddress2->setDbValue($rs->fields('PostalAddress2')); $vwCPD_SPExpiredNotRenewed->PostalCity->setDbValue($rs->fields('PostalCity')); $vwCPD_SPExpiredNotRenewed->PostalCode->setDbValue($rs->fields('PostalCode')); $vwCPD_SPExpiredNotRenewed->PostalProvince->setDbValue($rs->fields('PostalProvince')); $vwCPD_SPExpiredNotRenewed->PostalCountry->setDbValue($rs->fields('PostalCountry')); $vwCPD_SPExpiredNotRenewed->Website->setDbValue($rs->fields('Website')); $vwCPD_SPExpiredNotRenewed->VATNumber->setDbValue($rs->fields('VATNumber')); $vwCPD_SPExpiredNotRenewed->Approved->setDbValue($rs->fields('Approved')); $vwCPD_SPExpiredNotRenewed->SPNumber->setDbValue($rs->fields('SPNumber')); $vwCPD_SPExpiredNotRenewed->DateUpdated->setDbValue($rs->fields('DateUpdated')); $vwCPD_SPExpiredNotRenewed->DateAssessed->setDbValue($rs->fields('DateAssessed')); $vwCPD_SPExpiredNotRenewed->UpdatedBy->setDbValue($rs->fields('UpdatedBy')); $vwCPD_SPExpiredNotRenewed->Archived->setDbValue($rs->fields('Archived')); $vwCPD_SPExpiredNotRenewed->ContactPhone->setDbValue($rs->fields('ContactPhone')); $vwCPD_SPExpiredNotRenewed->AdminTitle->setDbValue($rs->fields('AdminTitle')); $vwCPD_SPExpiredNotRenewed->AdminInitials->setDbValue($rs->fields('AdminInitials')); $vwCPD_SPExpiredNotRenewed->AdminFirstName->setDbValue($rs->fields('AdminFirstName')); $vwCPD_SPExpiredNotRenewed->AdminSurname->setDbValue($rs->fields('AdminSurname')); $vwCPD_SPExpiredNotRenewed->AdminPosition->setDbValue($rs->fields('AdminPosition')); $vwCPD_SPExpiredNotRenewed->AdminIDNum->setDbValue($rs->fields('AdminIDNum')); $vwCPD_SPExpiredNotRenewed->AdminEmail->setDbValue($rs->fields('AdminEmail')); $vwCPD_SPExpiredNotRenewed->AdminPhone->setDbValue($rs->fields('AdminPhone')); $vwCPD_SPExpiredNotRenewed->EmailAddress->setDbValue($rs->fields('EmailAddress')); $vwCPD_SPExpiredNotRenewed->DateExpires->setDbValue($rs->fields('DateExpires')); $vwCPD_SPExpiredNotRenewed->EvaluatorID->setDbValue($rs->fields('EvaluatorID')); $vwCPD_SPExpiredNotRenewed->EvaluatorID2->setDbValue($rs->fields('EvaluatorID2')); $vwCPD_SPExpiredNotRenewed->EvaluatorID3->setDbValue($rs->fields('EvaluatorID3')); $vwCPD_SPExpiredNotRenewed->InvoiceCode->setDbValue($rs->fields('InvoiceCode')); $vwCPD_SPExpiredNotRenewed->InvoiceNumber->setDbValue($rs->fields('InvoiceNumber')); $vwCPD_SPExpiredNotRenewed->Cost->setDbValue($rs->fields('Cost')); $vwCPD_SPExpiredNotRenewed->EvaluatorFee->setDbValue($rs->fields('EvaluatorFee')); $vwCPD_SPExpiredNotRenewed->EvaluatorFeeAmount->setDbValue($rs->fields('EvaluatorFeeAmount')); $vwCPD_SPExpiredNotRenewed->EvaluatorFeeDate->setDbValue($rs->fields('EvaluatorFeeDate')); $vwCPD_SPExpiredNotRenewed->Comments->setDbValue($rs->fields('Comments')); $vwCPD_SPExpiredNotRenewed->CellNumber->setDbValue($rs->fields('CellNumber')); $vwCPD_SPExpiredNotRenewed->ContactCell->setDbValue($rs->fields('ContactCell')); $vwCPD_SPExpiredNotRenewed->AdminCell->setDbValue($rs->fields('AdminCell')); $vwCPD_SPExpiredNotRenewed->DepositAmt->setDbValue($rs->fields('DepositAmt')); $vwCPD_SPExpiredNotRenewed->InvoiceFile->setDbValue($rs->fields('InvoiceFile')); $vwCPD_SPExpiredNotRenewed->InvoiceDate->setDbValue($rs->fields('InvoiceDate')); $vwCPD_SPExpiredNotRenewed->DatePaid->setDbValue($rs->fields('DatePaid')); $vwCPD_SPExpiredNotRenewed->ProofOfPayment->setDbValue($rs->fields('ProofOfPayment')); $vwCPD_SPExpiredNotRenewed->EvaluatorInvoice->setDbValue($rs->fields('EvaluatorInvoice')); $vwCPD_SPExpiredNotRenewed->EvaluatorTimesheet->setDbValue($rs->fields('EvaluatorTimesheet')); $vwCPD_SPExpiredNotRenewed->NumReminders->setDbValue($rs->fields('NumReminders')); $vwCPD_SPExpiredNotRenewed->LastReminder->setDbValue($rs->fields('LastReminder')); $vwCPD_SPExpiredNotRenewed->PrevSPNumber->setDbValue($rs->fields('PrevSPNumber')); $vwCPD_SPExpiredNotRenewed->Renewal->setDbValue($rs->fields('Renewal')); $vwCPD_SPExpiredNotRenewed->DateCreated->setDbValue($rs->fields('DateCreated')); } // Render row values based on field settings function RenderRow() { global $conn, $Security, $Language, $vwCPD_SPExpiredNotRenewed; // Initialize URLs $this->ViewUrl = $vwCPD_SPExpiredNotRenewed->ViewUrl(); $this->EditUrl = $vwCPD_SPExpiredNotRenewed->EditUrl(); $this->InlineEditUrl = $vwCPD_SPExpiredNotRenewed->InlineEditUrl(); $this->CopyUrl = $vwCPD_SPExpiredNotRenewed->CopyUrl(); $this->InlineCopyUrl = $vwCPD_SPExpiredNotRenewed->InlineCopyUrl(); $this->DeleteUrl = $vwCPD_SPExpiredNotRenewed->DeleteUrl(); // Call Row_Rendering event $vwCPD_SPExpiredNotRenewed->Row_Rendering(); // Common render codes for all row types // CompanyName $vwCPD_SPExpiredNotRenewed->CompanyName->CellCssStyle = ""; $vwCPD_SPExpiredNotRenewed->CompanyName->CellCssClass = ""; $vwCPD_SPExpiredNotRenewed->CompanyName->CellAttrs = array(); $vwCPD_SPExpiredNotRenewed->CompanyName->ViewAttrs = array(); $vwCPD_SPExpiredNotRenewed->CompanyName->EditAttrs = array(); // TradingAs $vwCPD_SPExpiredNotRenewed->TradingAs->CellCssStyle = ""; $vwCPD_SPExpiredNotRenewed->TradingAs->CellCssClass = ""; $vwCPD_SPExpiredNotRenewed->TradingAs->CellAttrs = array(); $vwCPD_SPExpiredNotRenewed->TradingAs->ViewAttrs = array(); $vwCPD_SPExpiredNotRenewed->TradingAs->EditAttrs = array(); // ContactEmail $vwCPD_SPExpiredNotRenewed->ContactEmail->CellCssStyle = ""; $vwCPD_SPExpiredNotRenewed->ContactEmail->CellCssClass = ""; $vwCPD_SPExpiredNotRenewed->ContactEmail->CellAttrs = array(); $vwCPD_SPExpiredNotRenewed->ContactEmail->ViewAttrs = array(); $vwCPD_SPExpiredNotRenewed->ContactEmail->EditAttrs = array(); // ContactFirstName $vwCPD_SPExpiredNotRenewed->ContactFirstName->CellCssStyle = ""; $vwCPD_SPExpiredNotRenewed->ContactFirstName->CellCssClass = ""; $vwCPD_SPExpiredNotRenewed->ContactFirstName->CellAttrs = array(); $vwCPD_SPExpiredNotRenewed->ContactFirstName->ViewAttrs = array(); $vwCPD_SPExpiredNotRenewed->ContactFirstName->EditAttrs = array(); // ContactSurname $vwCPD_SPExpiredNotRenewed->ContactSurname->CellCssStyle = ""; $vwCPD_SPExpiredNotRenewed->ContactSurname->CellCssClass = ""; $vwCPD_SPExpiredNotRenewed->ContactSurname->CellAttrs = array(); $vwCPD_SPExpiredNotRenewed->ContactSurname->ViewAttrs = array(); $vwCPD_SPExpiredNotRenewed->ContactSurname->EditAttrs = array(); // Approved $vwCPD_SPExpiredNotRenewed->Approved->CellCssStyle = ""; $vwCPD_SPExpiredNotRenewed->Approved->CellCssClass = ""; $vwCPD_SPExpiredNotRenewed->Approved->CellAttrs = array(); $vwCPD_SPExpiredNotRenewed->Approved->ViewAttrs = array(); $vwCPD_SPExpiredNotRenewed->Approved->EditAttrs = array(); // SPNumber $vwCPD_SPExpiredNotRenewed->SPNumber->CellCssStyle = ""; $vwCPD_SPExpiredNotRenewed->SPNumber->CellCssClass = ""; $vwCPD_SPExpiredNotRenewed->SPNumber->CellAttrs = array(); $vwCPD_SPExpiredNotRenewed->SPNumber->ViewAttrs = array(); $vwCPD_SPExpiredNotRenewed->SPNumber->EditAttrs = array(); // DateUpdated $vwCPD_SPExpiredNotRenewed->DateUpdated->CellCssStyle = ""; $vwCPD_SPExpiredNotRenewed->DateUpdated->CellCssClass = ""; $vwCPD_SPExpiredNotRenewed->DateUpdated->CellAttrs = array(); $vwCPD_SPExpiredNotRenewed->DateUpdated->ViewAttrs = array(); $vwCPD_SPExpiredNotRenewed->DateUpdated->EditAttrs = array(); // DateAssessed $vwCPD_SPExpiredNotRenewed->DateAssessed->CellCssStyle = ""; $vwCPD_SPExpiredNotRenewed->DateAssessed->CellCssClass = ""; $vwCPD_SPExpiredNotRenewed->DateAssessed->CellAttrs = array(); $vwCPD_SPExpiredNotRenewed->DateAssessed->ViewAttrs = array(); $vwCPD_SPExpiredNotRenewed->DateAssessed->EditAttrs = array(); // DateExpires $vwCPD_SPExpiredNotRenewed->DateExpires->CellCssStyle = ""; $vwCPD_SPExpiredNotRenewed->DateExpires->CellCssClass = ""; $vwCPD_SPExpiredNotRenewed->DateExpires->CellAttrs = array(); $vwCPD_SPExpiredNotRenewed->DateExpires->ViewAttrs = array(); $vwCPD_SPExpiredNotRenewed->DateExpires->EditAttrs = array(); // DatePaid $vwCPD_SPExpiredNotRenewed->DatePaid->CellCssStyle = ""; $vwCPD_SPExpiredNotRenewed->DatePaid->CellCssClass = ""; $vwCPD_SPExpiredNotRenewed->DatePaid->CellAttrs = array(); $vwCPD_SPExpiredNotRenewed->DatePaid->ViewAttrs = array(); $vwCPD_SPExpiredNotRenewed->DatePaid->EditAttrs = array(); // NumReminders $vwCPD_SPExpiredNotRenewed->NumReminders->CellCssStyle = ""; $vwCPD_SPExpiredNotRenewed->NumReminders->CellCssClass = ""; $vwCPD_SPExpiredNotRenewed->NumReminders->CellAttrs = array(); $vwCPD_SPExpiredNotRenewed->NumReminders->ViewAttrs = array(); $vwCPD_SPExpiredNotRenewed->NumReminders->EditAttrs = array(); // LastReminder $vwCPD_SPExpiredNotRenewed->LastReminder->CellCssStyle = ""; $vwCPD_SPExpiredNotRenewed->LastReminder->CellCssClass = ""; $vwCPD_SPExpiredNotRenewed->LastReminder->CellAttrs = array(); $vwCPD_SPExpiredNotRenewed->LastReminder->ViewAttrs = array(); $vwCPD_SPExpiredNotRenewed->LastReminder->EditAttrs = array(); // PrevSPNumber $vwCPD_SPExpiredNotRenewed->PrevSPNumber->CellCssStyle = ""; $vwCPD_SPExpiredNotRenewed->PrevSPNumber->CellCssClass = ""; $vwCPD_SPExpiredNotRenewed->PrevSPNumber->CellAttrs = array(); $vwCPD_SPExpiredNotRenewed->PrevSPNumber->ViewAttrs = array(); $vwCPD_SPExpiredNotRenewed->PrevSPNumber->EditAttrs = array(); // Renewal $vwCPD_SPExpiredNotRenewed->Renewal->CellCssStyle = ""; $vwCPD_SPExpiredNotRenewed->Renewal->CellCssClass = ""; $vwCPD_SPExpiredNotRenewed->Renewal->CellAttrs = array(); $vwCPD_SPExpiredNotRenewed->Renewal->ViewAttrs = array(); $vwCPD_SPExpiredNotRenewed->Renewal->EditAttrs = array(); // DateCreated $vwCPD_SPExpiredNotRenewed->DateCreated->CellCssStyle = ""; $vwCPD_SPExpiredNotRenewed->DateCreated->CellCssClass = ""; $vwCPD_SPExpiredNotRenewed->DateCreated->CellAttrs = array(); $vwCPD_SPExpiredNotRenewed->DateCreated->ViewAttrs = array(); $vwCPD_SPExpiredNotRenewed->DateCreated->EditAttrs = array(); if ($vwCPD_SPExpiredNotRenewed->RowType == EW_ROWTYPE_VIEW) { // View row // CPDProviderID $vwCPD_SPExpiredNotRenewed->CPDProviderID->ViewValue = $vwCPD_SPExpiredNotRenewed->CPDProviderID->CurrentValue; $vwCPD_SPExpiredNotRenewed->CPDProviderID->CssStyle = ""; $vwCPD_SPExpiredNotRenewed->CPDProviderID->CssClass = ""; $vwCPD_SPExpiredNotRenewed->CPDProviderID->ViewCustomAttributes = ""; // CompanyName $vwCPD_SPExpiredNotRenewed->CompanyName->ViewValue = $vwCPD_SPExpiredNotRenewed->CompanyName->CurrentValue; $vwCPD_SPExpiredNotRenewed->CompanyName->CssStyle = ""; $vwCPD_SPExpiredNotRenewed->CompanyName->CssClass = ""; $vwCPD_SPExpiredNotRenewed->CompanyName->ViewCustomAttributes = ""; // TradingAs $vwCPD_SPExpiredNotRenewed->TradingAs->ViewValue = $vwCPD_SPExpiredNotRenewed->TradingAs->CurrentValue; $vwCPD_SPExpiredNotRenewed->TradingAs->CssStyle = ""; $vwCPD_SPExpiredNotRenewed->TradingAs->CssClass = ""; $vwCPD_SPExpiredNotRenewed->TradingAs->ViewCustomAttributes = ""; // ContactTitle $vwCPD_SPExpiredNotRenewed->ContactTitle->ViewValue = $vwCPD_SPExpiredNotRenewed->ContactTitle->CurrentValue; $vwCPD_SPExpiredNotRenewed->ContactTitle->CssStyle = ""; $vwCPD_SPExpiredNotRenewed->ContactTitle->CssClass = ""; $vwCPD_SPExpiredNotRenewed->ContactTitle->ViewCustomAttributes = ""; // ContactInitials $vwCPD_SPExpiredNotRenewed->ContactInitials->ViewValue = $vwCPD_SPExpiredNotRenewed->ContactInitials->CurrentValue; $vwCPD_SPExpiredNotRenewed->ContactInitials->CssStyle = ""; $vwCPD_SPExpiredNotRenewed->ContactInitials->CssClass = ""; $vwCPD_SPExpiredNotRenewed->ContactInitials->ViewCustomAttributes = ""; // ContactEmail $vwCPD_SPExpiredNotRenewed->ContactEmail->ViewValue = $vwCPD_SPExpiredNotRenewed->ContactEmail->CurrentValue; $vwCPD_SPExpiredNotRenewed->ContactEmail->CssStyle = ""; $vwCPD_SPExpiredNotRenewed->ContactEmail->CssClass = ""; $vwCPD_SPExpiredNotRenewed->ContactEmail->ViewCustomAttributes = ""; // ContactFirstName $vwCPD_SPExpiredNotRenewed->ContactFirstName->ViewValue = $vwCPD_SPExpiredNotRenewed->ContactFirstName->CurrentValue; $vwCPD_SPExpiredNotRenewed->ContactFirstName->CssStyle = ""; $vwCPD_SPExpiredNotRenewed->ContactFirstName->CssClass = ""; $vwCPD_SPExpiredNotRenewed->ContactFirstName->ViewCustomAttributes = ""; // ContactSurname $vwCPD_SPExpiredNotRenewed->ContactSurname->ViewValue = $vwCPD_SPExpiredNotRenewed->ContactSurname->CurrentValue; $vwCPD_SPExpiredNotRenewed->ContactSurname->CssStyle = ""; $vwCPD_SPExpiredNotRenewed->ContactSurname->CssClass = ""; $vwCPD_SPExpiredNotRenewed->ContactSurname->ViewCustomAttributes = ""; // ContactPosition $vwCPD_SPExpiredNotRenewed->ContactPosition->ViewValue = $vwCPD_SPExpiredNotRenewed->ContactPosition->CurrentValue; $vwCPD_SPExpiredNotRenewed->ContactPosition->CssStyle = ""; $vwCPD_SPExpiredNotRenewed->ContactPosition->CssClass = ""; $vwCPD_SPExpiredNotRenewed->ContactPosition->ViewCustomAttributes = ""; // ContactIDNum $vwCPD_SPExpiredNotRenewed->ContactIDNum->ViewValue = $vwCPD_SPExpiredNotRenewed->ContactIDNum->CurrentValue; $vwCPD_SPExpiredNotRenewed->ContactIDNum->CssStyle = ""; $vwCPD_SPExpiredNotRenewed->ContactIDNum->CssClass = ""; $vwCPD_SPExpiredNotRenewed->ContactIDNum->ViewCustomAttributes = ""; // PhoneNumber $vwCPD_SPExpiredNotRenewed->PhoneNumber->ViewValue = $vwCPD_SPExpiredNotRenewed->PhoneNumber->CurrentValue; $vwCPD_SPExpiredNotRenewed->PhoneNumber->CssStyle = ""; $vwCPD_SPExpiredNotRenewed->PhoneNumber->CssClass = ""; $vwCPD_SPExpiredNotRenewed->PhoneNumber->ViewCustomAttributes = ""; // Password $vwCPD_SPExpiredNotRenewed->Password->ViewValue = $vwCPD_SPExpiredNotRenewed->Password->CurrentValue; $vwCPD_SPExpiredNotRenewed->Password->CssStyle = ""; $vwCPD_SPExpiredNotRenewed->Password->CssClass = ""; $vwCPD_SPExpiredNotRenewed->Password->ViewCustomAttributes = ""; // PhysicalAddress1 $vwCPD_SPExpiredNotRenewed->PhysicalAddress1->ViewValue = $vwCPD_SPExpiredNotRenewed->PhysicalAddress1->CurrentValue; $vwCPD_SPExpiredNotRenewed->PhysicalAddress1->CssStyle = ""; $vwCPD_SPExpiredNotRenewed->PhysicalAddress1->CssClass = ""; $vwCPD_SPExpiredNotRenewed->PhysicalAddress1->ViewCustomAttributes = ""; // PhysicalAddress2 $vwCPD_SPExpiredNotRenewed->PhysicalAddress2->ViewValue = $vwCPD_SPExpiredNotRenewed->PhysicalAddress2->CurrentValue; $vwCPD_SPExpiredNotRenewed->PhysicalAddress2->CssStyle = ""; $vwCPD_SPExpiredNotRenewed->PhysicalAddress2->CssClass = ""; $vwCPD_SPExpiredNotRenewed->PhysicalAddress2->ViewCustomAttributes = ""; // PhysicalCity $vwCPD_SPExpiredNotRenewed->PhysicalCity->ViewValue = $vwCPD_SPExpiredNotRenewed->PhysicalCity->CurrentValue; $vwCPD_SPExpiredNotRenewed->PhysicalCity->CssStyle = ""; $vwCPD_SPExpiredNotRenewed->PhysicalCity->CssClass = ""; $vwCPD_SPExpiredNotRenewed->PhysicalCity->ViewCustomAttributes = ""; // PhysicalCode $vwCPD_SPExpiredNotRenewed->PhysicalCode->ViewValue = $vwCPD_SPExpiredNotRenewed->PhysicalCode->CurrentValue; $vwCPD_SPExpiredNotRenewed->PhysicalCode->CssStyle = ""; $vwCPD_SPExpiredNotRenewed->PhysicalCode->CssClass = ""; $vwCPD_SPExpiredNotRenewed->PhysicalCode->ViewCustomAttributes = ""; // PhysicalProvince $vwCPD_SPExpiredNotRenewed->PhysicalProvince->ViewValue = $vwCPD_SPExpiredNotRenewed->PhysicalProvince->CurrentValue; $vwCPD_SPExpiredNotRenewed->PhysicalProvince->CssStyle = ""; $vwCPD_SPExpiredNotRenewed->PhysicalProvince->CssClass = ""; $vwCPD_SPExpiredNotRenewed->PhysicalProvince->ViewCustomAttributes = ""; // PhysicalCountry $vwCPD_SPExpiredNotRenewed->PhysicalCountry->ViewValue = $vwCPD_SPExpiredNotRenewed->PhysicalCountry->CurrentValue; $vwCPD_SPExpiredNotRenewed->PhysicalCountry->CssStyle = ""; $vwCPD_SPExpiredNotRenewed->PhysicalCountry->CssClass = ""; $vwCPD_SPExpiredNotRenewed->PhysicalCountry->ViewCustomAttributes = ""; // PostalAddress1 $vwCPD_SPExpiredNotRenewed->PostalAddress1->ViewValue = $vwCPD_SPExpiredNotRenewed->PostalAddress1->CurrentValue; $vwCPD_SPExpiredNotRenewed->PostalAddress1->CssStyle = ""; $vwCPD_SPExpiredNotRenewed->PostalAddress1->CssClass = ""; $vwCPD_SPExpiredNotRenewed->PostalAddress1->ViewCustomAttributes = ""; // PostalAddress2 $vwCPD_SPExpiredNotRenewed->PostalAddress2->ViewValue = $vwCPD_SPExpiredNotRenewed->PostalAddress2->CurrentValue; $vwCPD_SPExpiredNotRenewed->PostalAddress2->CssStyle = ""; $vwCPD_SPExpiredNotRenewed->PostalAddress2->CssClass = ""; $vwCPD_SPExpiredNotRenewed->PostalAddress2->ViewCustomAttributes = ""; // PostalCity $vwCPD_SPExpiredNotRenewed->PostalCity->ViewValue = $vwCPD_SPExpiredNotRenewed->PostalCity->CurrentValue; $vwCPD_SPExpiredNotRenewed->PostalCity->CssStyle = ""; $vwCPD_SPExpiredNotRenewed->PostalCity->CssClass = ""; $vwCPD_SPExpiredNotRenewed->PostalCity->ViewCustomAttributes = ""; // PostalCode $vwCPD_SPExpiredNotRenewed->PostalCode->ViewValue = $vwCPD_SPExpiredNotRenewed->PostalCode->CurrentValue; $vwCPD_SPExpiredNotRenewed->PostalCode->CssStyle = ""; $vwCPD_SPExpiredNotRenewed->PostalCode->CssClass = ""; $vwCPD_SPExpiredNotRenewed->PostalCode->ViewCustomAttributes = ""; // PostalProvince $vwCPD_SPExpiredNotRenewed->PostalProvince->ViewValue = $vwCPD_SPExpiredNotRenewed->PostalProvince->CurrentValue; $vwCPD_SPExpiredNotRenewed->PostalProvince->CssStyle = ""; $vwCPD_SPExpiredNotRenewed->PostalProvince->CssClass = ""; $vwCPD_SPExpiredNotRenewed->PostalProvince->ViewCustomAttributes = ""; // PostalCountry $vwCPD_SPExpiredNotRenewed->PostalCountry->ViewValue = $vwCPD_SPExpiredNotRenewed->PostalCountry->CurrentValue; $vwCPD_SPExpiredNotRenewed->PostalCountry->CssStyle = ""; $vwCPD_SPExpiredNotRenewed->PostalCountry->CssClass = ""; $vwCPD_SPExpiredNotRenewed->PostalCountry->ViewCustomAttributes = ""; // Website $vwCPD_SPExpiredNotRenewed->Website->ViewValue = $vwCPD_SPExpiredNotRenewed->Website->CurrentValue; $vwCPD_SPExpiredNotRenewed->Website->CssStyle = ""; $vwCPD_SPExpiredNotRenewed->Website->CssClass = ""; $vwCPD_SPExpiredNotRenewed->Website->ViewCustomAttributes = ""; // VATNumber $vwCPD_SPExpiredNotRenewed->VATNumber->ViewValue = $vwCPD_SPExpiredNotRenewed->VATNumber->CurrentValue; $vwCPD_SPExpiredNotRenewed->VATNumber->CssStyle = ""; $vwCPD_SPExpiredNotRenewed->VATNumber->CssClass = ""; $vwCPD_SPExpiredNotRenewed->VATNumber->ViewCustomAttributes = ""; // Approved $vwCPD_SPExpiredNotRenewed->Approved->ViewValue = $vwCPD_SPExpiredNotRenewed->Approved->CurrentValue; $vwCPD_SPExpiredNotRenewed->Approved->CssStyle = ""; $vwCPD_SPExpiredNotRenewed->Approved->CssClass = ""; $vwCPD_SPExpiredNotRenewed->Approved->ViewCustomAttributes = ""; // SPNumber $vwCPD_SPExpiredNotRenewed->SPNumber->ViewValue = $vwCPD_SPExpiredNotRenewed->SPNumber->CurrentValue; $vwCPD_SPExpiredNotRenewed->SPNumber->CssStyle = ""; $vwCPD_SPExpiredNotRenewed->SPNumber->CssClass = ""; $vwCPD_SPExpiredNotRenewed->SPNumber->ViewCustomAttributes = ""; // DateUpdated $vwCPD_SPExpiredNotRenewed->DateUpdated->ViewValue = $vwCPD_SPExpiredNotRenewed->DateUpdated->CurrentValue; $vwCPD_SPExpiredNotRenewed->DateUpdated->ViewValue = ew_FormatDateTime($vwCPD_SPExpiredNotRenewed->DateUpdated->ViewValue, 5); $vwCPD_SPExpiredNotRenewed->DateUpdated->CssStyle = ""; $vwCPD_SPExpiredNotRenewed->DateUpdated->CssClass = ""; $vwCPD_SPExpiredNotRenewed->DateUpdated->ViewCustomAttributes = ""; // DateAssessed $vwCPD_SPExpiredNotRenewed->DateAssessed->ViewValue = $vwCPD_SPExpiredNotRenewed->DateAssessed->CurrentValue; $vwCPD_SPExpiredNotRenewed->DateAssessed->ViewValue = ew_FormatDateTime($vwCPD_SPExpiredNotRenewed->DateAssessed->ViewValue, 5); $vwCPD_SPExpiredNotRenewed->DateAssessed->CssStyle = ""; $vwCPD_SPExpiredNotRenewed->DateAssessed->CssClass = ""; $vwCPD_SPExpiredNotRenewed->DateAssessed->ViewCustomAttributes = ""; // UpdatedBy $vwCPD_SPExpiredNotRenewed->UpdatedBy->ViewValue = $vwCPD_SPExpiredNotRenewed->UpdatedBy->CurrentValue; $vwCPD_SPExpiredNotRenewed->UpdatedBy->CssStyle = ""; $vwCPD_SPExpiredNotRenewed->UpdatedBy->CssClass = ""; $vwCPD_SPExpiredNotRenewed->UpdatedBy->ViewCustomAttributes = ""; // Archived $vwCPD_SPExpiredNotRenewed->Archived->ViewValue = $vwCPD_SPExpiredNotRenewed->Archived->CurrentValue; $vwCPD_SPExpiredNotRenewed->Archived->CssStyle = ""; $vwCPD_SPExpiredNotRenewed->Archived->CssClass = ""; $vwCPD_SPExpiredNotRenewed->Archived->ViewCustomAttributes = ""; // ContactPhone $vwCPD_SPExpiredNotRenewed->ContactPhone->ViewValue = $vwCPD_SPExpiredNotRenewed->ContactPhone->CurrentValue; $vwCPD_SPExpiredNotRenewed->ContactPhone->CssStyle = ""; $vwCPD_SPExpiredNotRenewed->ContactPhone->CssClass = ""; $vwCPD_SPExpiredNotRenewed->ContactPhone->ViewCustomAttributes = ""; // AdminTitle $vwCPD_SPExpiredNotRenewed->AdminTitle->ViewValue = $vwCPD_SPExpiredNotRenewed->AdminTitle->CurrentValue; $vwCPD_SPExpiredNotRenewed->AdminTitle->CssStyle = ""; $vwCPD_SPExpiredNotRenewed->AdminTitle->CssClass = ""; $vwCPD_SPExpiredNotRenewed->AdminTitle->ViewCustomAttributes = ""; // AdminInitials $vwCPD_SPExpiredNotRenewed->AdminInitials->ViewValue = $vwCPD_SPExpiredNotRenewed->AdminInitials->CurrentValue; $vwCPD_SPExpiredNotRenewed->AdminInitials->CssStyle = ""; $vwCPD_SPExpiredNotRenewed->AdminInitials->CssClass = ""; $vwCPD_SPExpiredNotRenewed->AdminInitials->ViewCustomAttributes = ""; // AdminFirstName $vwCPD_SPExpiredNotRenewed->AdminFirstName->ViewValue = $vwCPD_SPExpiredNotRenewed->AdminFirstName->CurrentValue; $vwCPD_SPExpiredNotRenewed->AdminFirstName->CssStyle = ""; $vwCPD_SPExpiredNotRenewed->AdminFirstName->CssClass = ""; $vwCPD_SPExpiredNotRenewed->AdminFirstName->ViewCustomAttributes = ""; // AdminSurname $vwCPD_SPExpiredNotRenewed->AdminSurname->ViewValue = $vwCPD_SPExpiredNotRenewed->AdminSurname->CurrentValue; $vwCPD_SPExpiredNotRenewed->AdminSurname->CssStyle = ""; $vwCPD_SPExpiredNotRenewed->AdminSurname->CssClass = ""; $vwCPD_SPExpiredNotRenewed->AdminSurname->ViewCustomAttributes = ""; // AdminPosition $vwCPD_SPExpiredNotRenewed->AdminPosition->ViewValue = $vwCPD_SPExpiredNotRenewed->AdminPosition->CurrentValue; $vwCPD_SPExpiredNotRenewed->AdminPosition->CssStyle = ""; $vwCPD_SPExpiredNotRenewed->AdminPosition->CssClass = ""; $vwCPD_SPExpiredNotRenewed->AdminPosition->ViewCustomAttributes = ""; // AdminIDNum $vwCPD_SPExpiredNotRenewed->AdminIDNum->ViewValue = $vwCPD_SPExpiredNotRenewed->AdminIDNum->CurrentValue; $vwCPD_SPExpiredNotRenewed->AdminIDNum->CssStyle = ""; $vwCPD_SPExpiredNotRenewed->AdminIDNum->CssClass = ""; $vwCPD_SPExpiredNotRenewed->AdminIDNum->ViewCustomAttributes = ""; // AdminEmail $vwCPD_SPExpiredNotRenewed->AdminEmail->ViewValue = $vwCPD_SPExpiredNotRenewed->AdminEmail->CurrentValue; $vwCPD_SPExpiredNotRenewed->AdminEmail->CssStyle = ""; $vwCPD_SPExpiredNotRenewed->AdminEmail->CssClass = ""; $vwCPD_SPExpiredNotRenewed->AdminEmail->ViewCustomAttributes = ""; // AdminPhone $vwCPD_SPExpiredNotRenewed->AdminPhone->ViewValue = $vwCPD_SPExpiredNotRenewed->AdminPhone->CurrentValue; $vwCPD_SPExpiredNotRenewed->AdminPhone->CssStyle = ""; $vwCPD_SPExpiredNotRenewed->AdminPhone->CssClass = ""; $vwCPD_SPExpiredNotRenewed->AdminPhone->ViewCustomAttributes = ""; // EmailAddress $vwCPD_SPExpiredNotRenewed->EmailAddress->ViewValue = $vwCPD_SPExpiredNotRenewed->EmailAddress->CurrentValue; $vwCPD_SPExpiredNotRenewed->EmailAddress->CssStyle = ""; $vwCPD_SPExpiredNotRenewed->EmailAddress->CssClass = ""; $vwCPD_SPExpiredNotRenewed->EmailAddress->ViewCustomAttributes = ""; // DateExpires $vwCPD_SPExpiredNotRenewed->DateExpires->ViewValue = $vwCPD_SPExpiredNotRenewed->DateExpires->CurrentValue; $vwCPD_SPExpiredNotRenewed->DateExpires->ViewValue = ew_FormatDateTime($vwCPD_SPExpiredNotRenewed->DateExpires->ViewValue, 5); $vwCPD_SPExpiredNotRenewed->DateExpires->CssStyle = ""; $vwCPD_SPExpiredNotRenewed->DateExpires->CssClass = ""; $vwCPD_SPExpiredNotRenewed->DateExpires->ViewCustomAttributes = ""; // EvaluatorID $vwCPD_SPExpiredNotRenewed->EvaluatorID->ViewValue = $vwCPD_SPExpiredNotRenewed->EvaluatorID->CurrentValue; $vwCPD_SPExpiredNotRenewed->EvaluatorID->CssStyle = ""; $vwCPD_SPExpiredNotRenewed->EvaluatorID->CssClass = ""; $vwCPD_SPExpiredNotRenewed->EvaluatorID->ViewCustomAttributes = ""; // EvaluatorID2 $vwCPD_SPExpiredNotRenewed->EvaluatorID2->ViewValue = $vwCPD_SPExpiredNotRenewed->EvaluatorID2->CurrentValue; $vwCPD_SPExpiredNotRenewed->EvaluatorID2->CssStyle = ""; $vwCPD_SPExpiredNotRenewed->EvaluatorID2->CssClass = ""; $vwCPD_SPExpiredNotRenewed->EvaluatorID2->ViewCustomAttributes = ""; // EvaluatorID3 $vwCPD_SPExpiredNotRenewed->EvaluatorID3->ViewValue = $vwCPD_SPExpiredNotRenewed->EvaluatorID3->CurrentValue; $vwCPD_SPExpiredNotRenewed->EvaluatorID3->CssStyle = ""; $vwCPD_SPExpiredNotRenewed->EvaluatorID3->CssClass = ""; $vwCPD_SPExpiredNotRenewed->EvaluatorID3->ViewCustomAttributes = ""; // InvoiceCode $vwCPD_SPExpiredNotRenewed->InvoiceCode->ViewValue = $vwCPD_SPExpiredNotRenewed->InvoiceCode->CurrentValue; $vwCPD_SPExpiredNotRenewed->InvoiceCode->CssStyle = ""; $vwCPD_SPExpiredNotRenewed->InvoiceCode->CssClass = ""; $vwCPD_SPExpiredNotRenewed->InvoiceCode->ViewCustomAttributes = ""; // InvoiceNumber $vwCPD_SPExpiredNotRenewed->InvoiceNumber->ViewValue = $vwCPD_SPExpiredNotRenewed->InvoiceNumber->CurrentValue; $vwCPD_SPExpiredNotRenewed->InvoiceNumber->CssStyle = ""; $vwCPD_SPExpiredNotRenewed->InvoiceNumber->CssClass = ""; $vwCPD_SPExpiredNotRenewed->InvoiceNumber->ViewCustomAttributes = ""; // Cost $vwCPD_SPExpiredNotRenewed->Cost->ViewValue = $vwCPD_SPExpiredNotRenewed->Cost->CurrentValue; $vwCPD_SPExpiredNotRenewed->Cost->CssStyle = ""; $vwCPD_SPExpiredNotRenewed->Cost->CssClass = ""; $vwCPD_SPExpiredNotRenewed->Cost->ViewCustomAttributes = ""; // EvaluatorFee $vwCPD_SPExpiredNotRenewed->EvaluatorFee->ViewValue = $vwCPD_SPExpiredNotRenewed->EvaluatorFee->CurrentValue; $vwCPD_SPExpiredNotRenewed->EvaluatorFee->CssStyle = ""; $vwCPD_SPExpiredNotRenewed->EvaluatorFee->CssClass = ""; $vwCPD_SPExpiredNotRenewed->EvaluatorFee->ViewCustomAttributes = ""; // EvaluatorFeeAmount $vwCPD_SPExpiredNotRenewed->EvaluatorFeeAmount->ViewValue = $vwCPD_SPExpiredNotRenewed->EvaluatorFeeAmount->CurrentValue; $vwCPD_SPExpiredNotRenewed->EvaluatorFeeAmount->CssStyle = ""; $vwCPD_SPExpiredNotRenewed->EvaluatorFeeAmount->CssClass = ""; $vwCPD_SPExpiredNotRenewed->EvaluatorFeeAmount->ViewCustomAttributes = ""; // EvaluatorFeeDate $vwCPD_SPExpiredNotRenewed->EvaluatorFeeDate->ViewValue = $vwCPD_SPExpiredNotRenewed->EvaluatorFeeDate->CurrentValue; $vwCPD_SPExpiredNotRenewed->EvaluatorFeeDate->ViewValue = ew_FormatDateTime($vwCPD_SPExpiredNotRenewed->EvaluatorFeeDate->ViewValue, 5); $vwCPD_SPExpiredNotRenewed->EvaluatorFeeDate->CssStyle = ""; $vwCPD_SPExpiredNotRenewed->EvaluatorFeeDate->CssClass = ""; $vwCPD_SPExpiredNotRenewed->EvaluatorFeeDate->ViewCustomAttributes = ""; // CellNumber $vwCPD_SPExpiredNotRenewed->CellNumber->ViewValue = $vwCPD_SPExpiredNotRenewed->CellNumber->CurrentValue; $vwCPD_SPExpiredNotRenewed->CellNumber->CssStyle = ""; $vwCPD_SPExpiredNotRenewed->CellNumber->CssClass = ""; $vwCPD_SPExpiredNotRenewed->CellNumber->ViewCustomAttributes = ""; // ContactCell $vwCPD_SPExpiredNotRenewed->ContactCell->ViewValue = $vwCPD_SPExpiredNotRenewed->ContactCell->CurrentValue; $vwCPD_SPExpiredNotRenewed->ContactCell->CssStyle = ""; $vwCPD_SPExpiredNotRenewed->ContactCell->CssClass = ""; $vwCPD_SPExpiredNotRenewed->ContactCell->ViewCustomAttributes = ""; // AdminCell $vwCPD_SPExpiredNotRenewed->AdminCell->ViewValue = $vwCPD_SPExpiredNotRenewed->AdminCell->CurrentValue; $vwCPD_SPExpiredNotRenewed->AdminCell->CssStyle = ""; $vwCPD_SPExpiredNotRenewed->AdminCell->CssClass = ""; $vwCPD_SPExpiredNotRenewed->AdminCell->ViewCustomAttributes = ""; // DepositAmt $vwCPD_SPExpiredNotRenewed->DepositAmt->ViewValue = $vwCPD_SPExpiredNotRenewed->DepositAmt->CurrentValue; $vwCPD_SPExpiredNotRenewed->DepositAmt->CssStyle = ""; $vwCPD_SPExpiredNotRenewed->DepositAmt->CssClass = ""; $vwCPD_SPExpiredNotRenewed->DepositAmt->ViewCustomAttributes = ""; // InvoiceFile $vwCPD_SPExpiredNotRenewed->InvoiceFile->ViewValue = $vwCPD_SPExpiredNotRenewed->InvoiceFile->CurrentValue; $vwCPD_SPExpiredNotRenewed->InvoiceFile->CssStyle = ""; $vwCPD_SPExpiredNotRenewed->InvoiceFile->CssClass = ""; $vwCPD_SPExpiredNotRenewed->InvoiceFile->ViewCustomAttributes = ""; // InvoiceDate $vwCPD_SPExpiredNotRenewed->InvoiceDate->ViewValue = $vwCPD_SPExpiredNotRenewed->InvoiceDate->CurrentValue; $vwCPD_SPExpiredNotRenewed->InvoiceDate->ViewValue = ew_FormatDateTime($vwCPD_SPExpiredNotRenewed->InvoiceDate->ViewValue, 5); $vwCPD_SPExpiredNotRenewed->InvoiceDate->CssStyle = ""; $vwCPD_SPExpiredNotRenewed->InvoiceDate->CssClass = ""; $vwCPD_SPExpiredNotRenewed->InvoiceDate->ViewCustomAttributes = ""; // DatePaid $vwCPD_SPExpiredNotRenewed->DatePaid->ViewValue = $vwCPD_SPExpiredNotRenewed->DatePaid->CurrentValue; $vwCPD_SPExpiredNotRenewed->DatePaid->ViewValue = ew_FormatDateTime($vwCPD_SPExpiredNotRenewed->DatePaid->ViewValue, 5); $vwCPD_SPExpiredNotRenewed->DatePaid->CssStyle = ""; $vwCPD_SPExpiredNotRenewed->DatePaid->CssClass = ""; $vwCPD_SPExpiredNotRenewed->DatePaid->ViewCustomAttributes = ""; // ProofOfPayment $vwCPD_SPExpiredNotRenewed->ProofOfPayment->ViewValue = $vwCPD_SPExpiredNotRenewed->ProofOfPayment->CurrentValue; $vwCPD_SPExpiredNotRenewed->ProofOfPayment->CssStyle = ""; $vwCPD_SPExpiredNotRenewed->ProofOfPayment->CssClass = ""; $vwCPD_SPExpiredNotRenewed->ProofOfPayment->ViewCustomAttributes = ""; // EvaluatorInvoice $vwCPD_SPExpiredNotRenewed->EvaluatorInvoice->ViewValue = $vwCPD_SPExpiredNotRenewed->EvaluatorInvoice->CurrentValue; $vwCPD_SPExpiredNotRenewed->EvaluatorInvoice->CssStyle = ""; $vwCPD_SPExpiredNotRenewed->EvaluatorInvoice->CssClass = ""; $vwCPD_SPExpiredNotRenewed->EvaluatorInvoice->ViewCustomAttributes = ""; // EvaluatorTimesheet $vwCPD_SPExpiredNotRenewed->EvaluatorTimesheet->ViewValue = $vwCPD_SPExpiredNotRenewed->EvaluatorTimesheet->CurrentValue; $vwCPD_SPExpiredNotRenewed->EvaluatorTimesheet->CssStyle = ""; $vwCPD_SPExpiredNotRenewed->EvaluatorTimesheet->CssClass = ""; $vwCPD_SPExpiredNotRenewed->EvaluatorTimesheet->ViewCustomAttributes = ""; // NumReminders $vwCPD_SPExpiredNotRenewed->NumReminders->ViewValue = $vwCPD_SPExpiredNotRenewed->NumReminders->CurrentValue; $vwCPD_SPExpiredNotRenewed->NumReminders->CssStyle = ""; $vwCPD_SPExpiredNotRenewed->NumReminders->CssClass = ""; $vwCPD_SPExpiredNotRenewed->NumReminders->ViewCustomAttributes = ""; // LastReminder $vwCPD_SPExpiredNotRenewed->LastReminder->ViewValue = $vwCPD_SPExpiredNotRenewed->LastReminder->CurrentValue; $vwCPD_SPExpiredNotRenewed->LastReminder->ViewValue = ew_FormatDateTime($vwCPD_SPExpiredNotRenewed->LastReminder->ViewValue, 5); $vwCPD_SPExpiredNotRenewed->LastReminder->CssStyle = ""; $vwCPD_SPExpiredNotRenewed->LastReminder->CssClass = ""; $vwCPD_SPExpiredNotRenewed->LastReminder->ViewCustomAttributes = ""; // PrevSPNumber $vwCPD_SPExpiredNotRenewed->PrevSPNumber->ViewValue = $vwCPD_SPExpiredNotRenewed->PrevSPNumber->CurrentValue; $vwCPD_SPExpiredNotRenewed->PrevSPNumber->CssStyle = ""; $vwCPD_SPExpiredNotRenewed->PrevSPNumber->CssClass = ""; $vwCPD_SPExpiredNotRenewed->PrevSPNumber->ViewCustomAttributes = ""; // Renewal $vwCPD_SPExpiredNotRenewed->Renewal->ViewValue = $vwCPD_SPExpiredNotRenewed->Renewal->CurrentValue; $vwCPD_SPExpiredNotRenewed->Renewal->CssStyle = ""; $vwCPD_SPExpiredNotRenewed->Renewal->CssClass = ""; $vwCPD_SPExpiredNotRenewed->Renewal->ViewCustomAttributes = ""; // DateCreated $vwCPD_SPExpiredNotRenewed->DateCreated->ViewValue = $vwCPD_SPExpiredNotRenewed->DateCreated->CurrentValue; $vwCPD_SPExpiredNotRenewed->DateCreated->ViewValue = ew_FormatDateTime($vwCPD_SPExpiredNotRenewed->DateCreated->ViewValue, 5); $vwCPD_SPExpiredNotRenewed->DateCreated->CssStyle = ""; $vwCPD_SPExpiredNotRenewed->DateCreated->CssClass = ""; $vwCPD_SPExpiredNotRenewed->DateCreated->ViewCustomAttributes = ""; // CompanyName $vwCPD_SPExpiredNotRenewed->CompanyName->HrefValue = ""; $vwCPD_SPExpiredNotRenewed->CompanyName->TooltipValue = ""; // TradingAs $vwCPD_SPExpiredNotRenewed->TradingAs->HrefValue = ""; $vwCPD_SPExpiredNotRenewed->TradingAs->TooltipValue = ""; // ContactEmail $vwCPD_SPExpiredNotRenewed->ContactEmail->HrefValue = ""; $vwCPD_SPExpiredNotRenewed->ContactEmail->TooltipValue = ""; // ContactFirstName $vwCPD_SPExpiredNotRenewed->ContactFirstName->HrefValue = ""; $vwCPD_SPExpiredNotRenewed->ContactFirstName->TooltipValue = ""; // ContactSurname $vwCPD_SPExpiredNotRenewed->ContactSurname->HrefValue = ""; $vwCPD_SPExpiredNotRenewed->ContactSurname->TooltipValue = ""; // Approved $vwCPD_SPExpiredNotRenewed->Approved->HrefValue = ""; $vwCPD_SPExpiredNotRenewed->Approved->TooltipValue = ""; // SPNumber $vwCPD_SPExpiredNotRenewed->SPNumber->HrefValue = ""; $vwCPD_SPExpiredNotRenewed->SPNumber->TooltipValue = ""; // DateUpdated $vwCPD_SPExpiredNotRenewed->DateUpdated->HrefValue = ""; $vwCPD_SPExpiredNotRenewed->DateUpdated->TooltipValue = ""; // DateAssessed $vwCPD_SPExpiredNotRenewed->DateAssessed->HrefValue = ""; $vwCPD_SPExpiredNotRenewed->DateAssessed->TooltipValue = ""; // DateExpires $vwCPD_SPExpiredNotRenewed->DateExpires->HrefValue = ""; $vwCPD_SPExpiredNotRenewed->DateExpires->TooltipValue = ""; // DatePaid $vwCPD_SPExpiredNotRenewed->DatePaid->HrefValue = ""; $vwCPD_SPExpiredNotRenewed->DatePaid->TooltipValue = ""; // NumReminders $vwCPD_SPExpiredNotRenewed->NumReminders->HrefValue = ""; $vwCPD_SPExpiredNotRenewed->NumReminders->TooltipValue = ""; // LastReminder $vwCPD_SPExpiredNotRenewed->LastReminder->HrefValue = ""; $vwCPD_SPExpiredNotRenewed->LastReminder->TooltipValue = ""; // PrevSPNumber $vwCPD_SPExpiredNotRenewed->PrevSPNumber->HrefValue = ""; $vwCPD_SPExpiredNotRenewed->PrevSPNumber->TooltipValue = ""; // Renewal $vwCPD_SPExpiredNotRenewed->Renewal->HrefValue = ""; $vwCPD_SPExpiredNotRenewed->Renewal->TooltipValue = ""; // DateCreated $vwCPD_SPExpiredNotRenewed->DateCreated->HrefValue = ""; $vwCPD_SPExpiredNotRenewed->DateCreated->TooltipValue = ""; } // Call Row Rendered event if ($vwCPD_SPExpiredNotRenewed->RowType <> EW_ROWTYPE_AGGREGATEINIT) $vwCPD_SPExpiredNotRenewed->Row_Rendered(); } // Export data in HTML/CSV/Word/Excel/XML/Email format function ExportData() { global $vwCPD_SPExpiredNotRenewed; $utf8 = FALSE; $bSelectLimit = EW_SELECT_LIMIT; // Load recordset if ($bSelectLimit) { $this->lTotalRecs = $vwCPD_SPExpiredNotRenewed->SelectRecordCount(); } else { if ($rs = $this->LoadRecordset()) $this->lTotalRecs = $rs->RecordCount(); } $this->lStartRec = 1; // Export all if ($vwCPD_SPExpiredNotRenewed->ExportAll) { $this->lDisplayRecs = $this->lTotalRecs; $this->lStopRec = $this->lTotalRecs; } else { // Export one page only $this->SetUpStartRec(); // Set up start record position // Set the last record to display if ($this->lDisplayRecs < 0) { $this->lStopRec = $this->lTotalRecs; } else { $this->lStopRec = $this->lStartRec + $this->lDisplayRecs - 1; } } if ($bSelectLimit) $rs = $this->LoadRecordset($this->lStartRec-1, $this->lDisplayRecs); if (!$rs) { header("Content-Type:"); // Remove header header("Content-Disposition:"); $this->ShowMessage(); return; } if ($vwCPD_SPExpiredNotRenewed->Export == "xml") { $XmlDoc = new cXMLDocument(EW_XML_ENCODING); $XmlDoc->AddRoot(); } else { $ExportDoc = new cExportDocument($vwCPD_SPExpiredNotRenewed, "h"); $ExportDoc->ExportHeader(); if ($ExportDoc->Horizontal) { // Horizontal format, write header $ExportDoc->BeginExportRow(); $ExportDoc->ExportCaption($vwCPD_SPExpiredNotRenewed->CPDProviderID); $ExportDoc->ExportCaption($vwCPD_SPExpiredNotRenewed->CompanyName); $ExportDoc->ExportCaption($vwCPD_SPExpiredNotRenewed->TradingAs); $ExportDoc->ExportCaption($vwCPD_SPExpiredNotRenewed->ContactTitle); $ExportDoc->ExportCaption($vwCPD_SPExpiredNotRenewed->ContactInitials); $ExportDoc->ExportCaption($vwCPD_SPExpiredNotRenewed->ContactEmail); $ExportDoc->ExportCaption($vwCPD_SPExpiredNotRenewed->ContactFirstName); $ExportDoc->ExportCaption($vwCPD_SPExpiredNotRenewed->ContactSurname); $ExportDoc->ExportCaption($vwCPD_SPExpiredNotRenewed->ContactPosition); $ExportDoc->ExportCaption($vwCPD_SPExpiredNotRenewed->ContactIDNum); $ExportDoc->ExportCaption($vwCPD_SPExpiredNotRenewed->PhoneNumber); $ExportDoc->ExportCaption($vwCPD_SPExpiredNotRenewed->Password); $ExportDoc->ExportCaption($vwCPD_SPExpiredNotRenewed->PhysicalAddress1); $ExportDoc->ExportCaption($vwCPD_SPExpiredNotRenewed->PhysicalAddress2); $ExportDoc->ExportCaption($vwCPD_SPExpiredNotRenewed->PhysicalCity); $ExportDoc->ExportCaption($vwCPD_SPExpiredNotRenewed->PhysicalCode); $ExportDoc->ExportCaption($vwCPD_SPExpiredNotRenewed->PhysicalProvince); $ExportDoc->ExportCaption($vwCPD_SPExpiredNotRenewed->PhysicalCountry); $ExportDoc->ExportCaption($vwCPD_SPExpiredNotRenewed->PostalAddress1); $ExportDoc->ExportCaption($vwCPD_SPExpiredNotRenewed->PostalAddress2); $ExportDoc->ExportCaption($vwCPD_SPExpiredNotRenewed->PostalCity); $ExportDoc->ExportCaption($vwCPD_SPExpiredNotRenewed->PostalCode); $ExportDoc->ExportCaption($vwCPD_SPExpiredNotRenewed->PostalProvince); $ExportDoc->ExportCaption($vwCPD_SPExpiredNotRenewed->PostalCountry); $ExportDoc->ExportCaption($vwCPD_SPExpiredNotRenewed->Website); $ExportDoc->ExportCaption($vwCPD_SPExpiredNotRenewed->VATNumber); $ExportDoc->ExportCaption($vwCPD_SPExpiredNotRenewed->Approved); $ExportDoc->ExportCaption($vwCPD_SPExpiredNotRenewed->SPNumber); $ExportDoc->ExportCaption($vwCPD_SPExpiredNotRenewed->DateUpdated); $ExportDoc->ExportCaption($vwCPD_SPExpiredNotRenewed->DateAssessed); $ExportDoc->ExportCaption($vwCPD_SPExpiredNotRenewed->UpdatedBy); $ExportDoc->ExportCaption($vwCPD_SPExpiredNotRenewed->Archived); $ExportDoc->ExportCaption($vwCPD_SPExpiredNotRenewed->ContactPhone); $ExportDoc->ExportCaption($vwCPD_SPExpiredNotRenewed->AdminTitle); $ExportDoc->ExportCaption($vwCPD_SPExpiredNotRenewed->AdminInitials); $ExportDoc->ExportCaption($vwCPD_SPExpiredNotRenewed->AdminFirstName); $ExportDoc->ExportCaption($vwCPD_SPExpiredNotRenewed->AdminSurname); $ExportDoc->ExportCaption($vwCPD_SPExpiredNotRenewed->AdminPosition); $ExportDoc->ExportCaption($vwCPD_SPExpiredNotRenewed->AdminIDNum); $ExportDoc->ExportCaption($vwCPD_SPExpiredNotRenewed->AdminEmail); $ExportDoc->ExportCaption($vwCPD_SPExpiredNotRenewed->AdminPhone); $ExportDoc->ExportCaption($vwCPD_SPExpiredNotRenewed->EmailAddress); $ExportDoc->ExportCaption($vwCPD_SPExpiredNotRenewed->DateExpires); $ExportDoc->ExportCaption($vwCPD_SPExpiredNotRenewed->EvaluatorID); $ExportDoc->ExportCaption($vwCPD_SPExpiredNotRenewed->EvaluatorID2); $ExportDoc->ExportCaption($vwCPD_SPExpiredNotRenewed->EvaluatorID3); $ExportDoc->ExportCaption($vwCPD_SPExpiredNotRenewed->InvoiceCode); $ExportDoc->ExportCaption($vwCPD_SPExpiredNotRenewed->InvoiceNumber); $ExportDoc->ExportCaption($vwCPD_SPExpiredNotRenewed->Cost); $ExportDoc->ExportCaption($vwCPD_SPExpiredNotRenewed->EvaluatorFee); $ExportDoc->ExportCaption($vwCPD_SPExpiredNotRenewed->EvaluatorFeeAmount); $ExportDoc->ExportCaption($vwCPD_SPExpiredNotRenewed->EvaluatorFeeDate); $ExportDoc->ExportCaption($vwCPD_SPExpiredNotRenewed->CellNumber); $ExportDoc->ExportCaption($vwCPD_SPExpiredNotRenewed->ContactCell); $ExportDoc->ExportCaption($vwCPD_SPExpiredNotRenewed->AdminCell); $ExportDoc->ExportCaption($vwCPD_SPExpiredNotRenewed->DepositAmt); $ExportDoc->ExportCaption($vwCPD_SPExpiredNotRenewed->InvoiceFile); $ExportDoc->ExportCaption($vwCPD_SPExpiredNotRenewed->InvoiceDate); $ExportDoc->ExportCaption($vwCPD_SPExpiredNotRenewed->DatePaid); $ExportDoc->ExportCaption($vwCPD_SPExpiredNotRenewed->ProofOfPayment); $ExportDoc->ExportCaption($vwCPD_SPExpiredNotRenewed->EvaluatorInvoice); $ExportDoc->ExportCaption($vwCPD_SPExpiredNotRenewed->EvaluatorTimesheet); $ExportDoc->ExportCaption($vwCPD_SPExpiredNotRenewed->NumReminders); $ExportDoc->ExportCaption($vwCPD_SPExpiredNotRenewed->LastReminder); $ExportDoc->ExportCaption($vwCPD_SPExpiredNotRenewed->PrevSPNumber); $ExportDoc->ExportCaption($vwCPD_SPExpiredNotRenewed->Renewal); $ExportDoc->ExportCaption($vwCPD_SPExpiredNotRenewed->DateCreated); $ExportDoc->EndExportRow(); } } // Move to first record $this->lRecCnt = $this->lStartRec - 1; if (!$rs->EOF) { $rs->MoveFirst(); if (!$bSelectLimit && $this->lStartRec > 1) $rs->Move($this->lStartRec - 1); } while (!$rs->EOF && $this->lRecCnt < $this->lStopRec) { $this->lRecCnt++; if (intval($this->lRecCnt) >= intval($this->lStartRec)) { $this->LoadRowValues($rs); // Render row $vwCPD_SPExpiredNotRenewed->CssClass = ""; $vwCPD_SPExpiredNotRenewed->CssStyle = ""; $vwCPD_SPExpiredNotRenewed->RowType = EW_ROWTYPE_VIEW; // Render view $this->RenderRow(); if ($vwCPD_SPExpiredNotRenewed->Export == "xml") { $XmlDoc->AddRow(); $XmlDoc->AddField('CPDProviderID', $vwCPD_SPExpiredNotRenewed->CPDProviderID->ExportValue($vwCPD_SPExpiredNotRenewed->Export, $vwCPD_SPExpiredNotRenewed->ExportOriginalValue)); $XmlDoc->AddField('CompanyName', $vwCPD_SPExpiredNotRenewed->CompanyName->ExportValue($vwCPD_SPExpiredNotRenewed->Export, $vwCPD_SPExpiredNotRenewed->ExportOriginalValue)); $XmlDoc->AddField('TradingAs', $vwCPD_SPExpiredNotRenewed->TradingAs->ExportValue($vwCPD_SPExpiredNotRenewed->Export, $vwCPD_SPExpiredNotRenewed->ExportOriginalValue)); $XmlDoc->AddField('ContactTitle', $vwCPD_SPExpiredNotRenewed->ContactTitle->ExportValue($vwCPD_SPExpiredNotRenewed->Export, $vwCPD_SPExpiredNotRenewed->ExportOriginalValue)); $XmlDoc->AddField('ContactInitials', $vwCPD_SPExpiredNotRenewed->ContactInitials->ExportValue($vwCPD_SPExpiredNotRenewed->Export, $vwCPD_SPExpiredNotRenewed->ExportOriginalValue)); $XmlDoc->AddField('ContactEmail', $vwCPD_SPExpiredNotRenewed->ContactEmail->ExportValue($vwCPD_SPExpiredNotRenewed->Export, $vwCPD_SPExpiredNotRenewed->ExportOriginalValue)); $XmlDoc->AddField('ContactFirstName', $vwCPD_SPExpiredNotRenewed->ContactFirstName->ExportValue($vwCPD_SPExpiredNotRenewed->Export, $vwCPD_SPExpiredNotRenewed->ExportOriginalValue)); $XmlDoc->AddField('ContactSurname', $vwCPD_SPExpiredNotRenewed->ContactSurname->ExportValue($vwCPD_SPExpiredNotRenewed->Export, $vwCPD_SPExpiredNotRenewed->ExportOriginalValue)); $XmlDoc->AddField('ContactPosition', $vwCPD_SPExpiredNotRenewed->ContactPosition->ExportValue($vwCPD_SPExpiredNotRenewed->Export, $vwCPD_SPExpiredNotRenewed->ExportOriginalValue)); $XmlDoc->AddField('ContactIDNum', $vwCPD_SPExpiredNotRenewed->ContactIDNum->ExportValue($vwCPD_SPExpiredNotRenewed->Export, $vwCPD_SPExpiredNotRenewed->ExportOriginalValue)); $XmlDoc->AddField('PhoneNumber', $vwCPD_SPExpiredNotRenewed->PhoneNumber->ExportValue($vwCPD_SPExpiredNotRenewed->Export, $vwCPD_SPExpiredNotRenewed->ExportOriginalValue)); $XmlDoc->AddField('Password', $vwCPD_SPExpiredNotRenewed->Password->ExportValue($vwCPD_SPExpiredNotRenewed->Export, $vwCPD_SPExpiredNotRenewed->ExportOriginalValue)); $XmlDoc->AddField('PhysicalAddress1', $vwCPD_SPExpiredNotRenewed->PhysicalAddress1->ExportValue($vwCPD_SPExpiredNotRenewed->Export, $vwCPD_SPExpiredNotRenewed->ExportOriginalValue)); $XmlDoc->AddField('PhysicalAddress2', $vwCPD_SPExpiredNotRenewed->PhysicalAddress2->ExportValue($vwCPD_SPExpiredNotRenewed->Export, $vwCPD_SPExpiredNotRenewed->ExportOriginalValue)); $XmlDoc->AddField('PhysicalCity', $vwCPD_SPExpiredNotRenewed->PhysicalCity->ExportValue($vwCPD_SPExpiredNotRenewed->Export, $vwCPD_SPExpiredNotRenewed->ExportOriginalValue)); $XmlDoc->AddField('PhysicalCode', $vwCPD_SPExpiredNotRenewed->PhysicalCode->ExportValue($vwCPD_SPExpiredNotRenewed->Export, $vwCPD_SPExpiredNotRenewed->ExportOriginalValue)); $XmlDoc->AddField('PhysicalProvince', $vwCPD_SPExpiredNotRenewed->PhysicalProvince->ExportValue($vwCPD_SPExpiredNotRenewed->Export, $vwCPD_SPExpiredNotRenewed->ExportOriginalValue)); $XmlDoc->AddField('PhysicalCountry', $vwCPD_SPExpiredNotRenewed->PhysicalCountry->ExportValue($vwCPD_SPExpiredNotRenewed->Export, $vwCPD_SPExpiredNotRenewed->ExportOriginalValue)); $XmlDoc->AddField('PostalAddress1', $vwCPD_SPExpiredNotRenewed->PostalAddress1->ExportValue($vwCPD_SPExpiredNotRenewed->Export, $vwCPD_SPExpiredNotRenewed->ExportOriginalValue)); $XmlDoc->AddField('PostalAddress2', $vwCPD_SPExpiredNotRenewed->PostalAddress2->ExportValue($vwCPD_SPExpiredNotRenewed->Export, $vwCPD_SPExpiredNotRenewed->ExportOriginalValue)); $XmlDoc->AddField('PostalCity', $vwCPD_SPExpiredNotRenewed->PostalCity->ExportValue($vwCPD_SPExpiredNotRenewed->Export, $vwCPD_SPExpiredNotRenewed->ExportOriginalValue)); $XmlDoc->AddField('PostalCode', $vwCPD_SPExpiredNotRenewed->PostalCode->ExportValue($vwCPD_SPExpiredNotRenewed->Export, $vwCPD_SPExpiredNotRenewed->ExportOriginalValue)); $XmlDoc->AddField('PostalProvince', $vwCPD_SPExpiredNotRenewed->PostalProvince->ExportValue($vwCPD_SPExpiredNotRenewed->Export, $vwCPD_SPExpiredNotRenewed->ExportOriginalValue)); $XmlDoc->AddField('PostalCountry', $vwCPD_SPExpiredNotRenewed->PostalCountry->ExportValue($vwCPD_SPExpiredNotRenewed->Export, $vwCPD_SPExpiredNotRenewed->ExportOriginalValue)); $XmlDoc->AddField('Website', $vwCPD_SPExpiredNotRenewed->Website->ExportValue($vwCPD_SPExpiredNotRenewed->Export, $vwCPD_SPExpiredNotRenewed->ExportOriginalValue)); $XmlDoc->AddField('VATNumber', $vwCPD_SPExpiredNotRenewed->VATNumber->ExportValue($vwCPD_SPExpiredNotRenewed->Export, $vwCPD_SPExpiredNotRenewed->ExportOriginalValue)); $XmlDoc->AddField('Approved', $vwCPD_SPExpiredNotRenewed->Approved->ExportValue($vwCPD_SPExpiredNotRenewed->Export, $vwCPD_SPExpiredNotRenewed->ExportOriginalValue)); $XmlDoc->AddField('SPNumber', $vwCPD_SPExpiredNotRenewed->SPNumber->ExportValue($vwCPD_SPExpiredNotRenewed->Export, $vwCPD_SPExpiredNotRenewed->ExportOriginalValue)); $XmlDoc->AddField('DateUpdated', $vwCPD_SPExpiredNotRenewed->DateUpdated->ExportValue($vwCPD_SPExpiredNotRenewed->Export, $vwCPD_SPExpiredNotRenewed->ExportOriginalValue)); $XmlDoc->AddField('DateAssessed', $vwCPD_SPExpiredNotRenewed->DateAssessed->ExportValue($vwCPD_SPExpiredNotRenewed->Export, $vwCPD_SPExpiredNotRenewed->ExportOriginalValue)); $XmlDoc->AddField('UpdatedBy', $vwCPD_SPExpiredNotRenewed->UpdatedBy->ExportValue($vwCPD_SPExpiredNotRenewed->Export, $vwCPD_SPExpiredNotRenewed->ExportOriginalValue)); $XmlDoc->AddField('Archived', $vwCPD_SPExpiredNotRenewed->Archived->ExportValue($vwCPD_SPExpiredNotRenewed->Export, $vwCPD_SPExpiredNotRenewed->ExportOriginalValue)); $XmlDoc->AddField('ContactPhone', $vwCPD_SPExpiredNotRenewed->ContactPhone->ExportValue($vwCPD_SPExpiredNotRenewed->Export, $vwCPD_SPExpiredNotRenewed->ExportOriginalValue)); $XmlDoc->AddField('AdminTitle', $vwCPD_SPExpiredNotRenewed->AdminTitle->ExportValue($vwCPD_SPExpiredNotRenewed->Export, $vwCPD_SPExpiredNotRenewed->ExportOriginalValue)); $XmlDoc->AddField('AdminInitials', $vwCPD_SPExpiredNotRenewed->AdminInitials->ExportValue($vwCPD_SPExpiredNotRenewed->Export, $vwCPD_SPExpiredNotRenewed->ExportOriginalValue)); $XmlDoc->AddField('AdminFirstName', $vwCPD_SPExpiredNotRenewed->AdminFirstName->ExportValue($vwCPD_SPExpiredNotRenewed->Export, $vwCPD_SPExpiredNotRenewed->ExportOriginalValue)); $XmlDoc->AddField('AdminSurname', $vwCPD_SPExpiredNotRenewed->AdminSurname->ExportValue($vwCPD_SPExpiredNotRenewed->Export, $vwCPD_SPExpiredNotRenewed->ExportOriginalValue)); $XmlDoc->AddField('AdminPosition', $vwCPD_SPExpiredNotRenewed->AdminPosition->ExportValue($vwCPD_SPExpiredNotRenewed->Export, $vwCPD_SPExpiredNotRenewed->ExportOriginalValue)); $XmlDoc->AddField('AdminIDNum', $vwCPD_SPExpiredNotRenewed->AdminIDNum->ExportValue($vwCPD_SPExpiredNotRenewed->Export, $vwCPD_SPExpiredNotRenewed->ExportOriginalValue)); $XmlDoc->AddField('AdminEmail', $vwCPD_SPExpiredNotRenewed->AdminEmail->ExportValue($vwCPD_SPExpiredNotRenewed->Export, $vwCPD_SPExpiredNotRenewed->ExportOriginalValue)); $XmlDoc->AddField('AdminPhone', $vwCPD_SPExpiredNotRenewed->AdminPhone->ExportValue($vwCPD_SPExpiredNotRenewed->Export, $vwCPD_SPExpiredNotRenewed->ExportOriginalValue)); $XmlDoc->AddField('EmailAddress', $vwCPD_SPExpiredNotRenewed->EmailAddress->ExportValue($vwCPD_SPExpiredNotRenewed->Export, $vwCPD_SPExpiredNotRenewed->ExportOriginalValue)); $XmlDoc->AddField('DateExpires', $vwCPD_SPExpiredNotRenewed->DateExpires->ExportValue($vwCPD_SPExpiredNotRenewed->Export, $vwCPD_SPExpiredNotRenewed->ExportOriginalValue)); $XmlDoc->AddField('EvaluatorID', $vwCPD_SPExpiredNotRenewed->EvaluatorID->ExportValue($vwCPD_SPExpiredNotRenewed->Export, $vwCPD_SPExpiredNotRenewed->ExportOriginalValue)); $XmlDoc->AddField('EvaluatorID2', $vwCPD_SPExpiredNotRenewed->EvaluatorID2->ExportValue($vwCPD_SPExpiredNotRenewed->Export, $vwCPD_SPExpiredNotRenewed->ExportOriginalValue)); $XmlDoc->AddField('EvaluatorID3', $vwCPD_SPExpiredNotRenewed->EvaluatorID3->ExportValue($vwCPD_SPExpiredNotRenewed->Export, $vwCPD_SPExpiredNotRenewed->ExportOriginalValue)); $XmlDoc->AddField('InvoiceCode', $vwCPD_SPExpiredNotRenewed->InvoiceCode->ExportValue($vwCPD_SPExpiredNotRenewed->Export, $vwCPD_SPExpiredNotRenewed->ExportOriginalValue)); $XmlDoc->AddField('InvoiceNumber', $vwCPD_SPExpiredNotRenewed->InvoiceNumber->ExportValue($vwCPD_SPExpiredNotRenewed->Export, $vwCPD_SPExpiredNotRenewed->ExportOriginalValue)); $XmlDoc->AddField('Cost', $vwCPD_SPExpiredNotRenewed->Cost->ExportValue($vwCPD_SPExpiredNotRenewed->Export, $vwCPD_SPExpiredNotRenewed->ExportOriginalValue)); $XmlDoc->AddField('EvaluatorFee', $vwCPD_SPExpiredNotRenewed->EvaluatorFee->ExportValue($vwCPD_SPExpiredNotRenewed->Export, $vwCPD_SPExpiredNotRenewed->ExportOriginalValue)); $XmlDoc->AddField('EvaluatorFeeAmount', $vwCPD_SPExpiredNotRenewed->EvaluatorFeeAmount->ExportValue($vwCPD_SPExpiredNotRenewed->Export, $vwCPD_SPExpiredNotRenewed->ExportOriginalValue)); $XmlDoc->AddField('EvaluatorFeeDate', $vwCPD_SPExpiredNotRenewed->EvaluatorFeeDate->ExportValue($vwCPD_SPExpiredNotRenewed->Export, $vwCPD_SPExpiredNotRenewed->ExportOriginalValue)); $XmlDoc->AddField('CellNumber', $vwCPD_SPExpiredNotRenewed->CellNumber->ExportValue($vwCPD_SPExpiredNotRenewed->Export, $vwCPD_SPExpiredNotRenewed->ExportOriginalValue)); $XmlDoc->AddField('ContactCell', $vwCPD_SPExpiredNotRenewed->ContactCell->ExportValue($vwCPD_SPExpiredNotRenewed->Export, $vwCPD_SPExpiredNotRenewed->ExportOriginalValue)); $XmlDoc->AddField('AdminCell', $vwCPD_SPExpiredNotRenewed->AdminCell->ExportValue($vwCPD_SPExpiredNotRenewed->Export, $vwCPD_SPExpiredNotRenewed->ExportOriginalValue)); $XmlDoc->AddField('DepositAmt', $vwCPD_SPExpiredNotRenewed->DepositAmt->ExportValue($vwCPD_SPExpiredNotRenewed->Export, $vwCPD_SPExpiredNotRenewed->ExportOriginalValue)); $XmlDoc->AddField('InvoiceFile', $vwCPD_SPExpiredNotRenewed->InvoiceFile->ExportValue($vwCPD_SPExpiredNotRenewed->Export, $vwCPD_SPExpiredNotRenewed->ExportOriginalValue)); $XmlDoc->AddField('InvoiceDate', $vwCPD_SPExpiredNotRenewed->InvoiceDate->ExportValue($vwCPD_SPExpiredNotRenewed->Export, $vwCPD_SPExpiredNotRenewed->ExportOriginalValue)); $XmlDoc->AddField('DatePaid', $vwCPD_SPExpiredNotRenewed->DatePaid->ExportValue($vwCPD_SPExpiredNotRenewed->Export, $vwCPD_SPExpiredNotRenewed->ExportOriginalValue)); $XmlDoc->AddField('ProofOfPayment', $vwCPD_SPExpiredNotRenewed->ProofOfPayment->ExportValue($vwCPD_SPExpiredNotRenewed->Export, $vwCPD_SPExpiredNotRenewed->ExportOriginalValue)); $XmlDoc->AddField('EvaluatorInvoice', $vwCPD_SPExpiredNotRenewed->EvaluatorInvoice->ExportValue($vwCPD_SPExpiredNotRenewed->Export, $vwCPD_SPExpiredNotRenewed->ExportOriginalValue)); $XmlDoc->AddField('EvaluatorTimesheet', $vwCPD_SPExpiredNotRenewed->EvaluatorTimesheet->ExportValue($vwCPD_SPExpiredNotRenewed->Export, $vwCPD_SPExpiredNotRenewed->ExportOriginalValue)); $XmlDoc->AddField('NumReminders', $vwCPD_SPExpiredNotRenewed->NumReminders->ExportValue($vwCPD_SPExpiredNotRenewed->Export, $vwCPD_SPExpiredNotRenewed->ExportOriginalValue)); $XmlDoc->AddField('LastReminder', $vwCPD_SPExpiredNotRenewed->LastReminder->ExportValue($vwCPD_SPExpiredNotRenewed->Export, $vwCPD_SPExpiredNotRenewed->ExportOriginalValue)); $XmlDoc->AddField('PrevSPNumber', $vwCPD_SPExpiredNotRenewed->PrevSPNumber->ExportValue($vwCPD_SPExpiredNotRenewed->Export, $vwCPD_SPExpiredNotRenewed->ExportOriginalValue)); $XmlDoc->AddField('Renewal', $vwCPD_SPExpiredNotRenewed->Renewal->ExportValue($vwCPD_SPExpiredNotRenewed->Export, $vwCPD_SPExpiredNotRenewed->ExportOriginalValue)); $XmlDoc->AddField('DateCreated', $vwCPD_SPExpiredNotRenewed->DateCreated->ExportValue($vwCPD_SPExpiredNotRenewed->Export, $vwCPD_SPExpiredNotRenewed->ExportOriginalValue)); } else { $ExportDoc->BeginExportRow(TRUE); // Allow CSS styles if enabled $ExportDoc->ExportField($vwCPD_SPExpiredNotRenewed->CPDProviderID); $ExportDoc->ExportField($vwCPD_SPExpiredNotRenewed->CompanyName); $ExportDoc->ExportField($vwCPD_SPExpiredNotRenewed->TradingAs); $ExportDoc->ExportField($vwCPD_SPExpiredNotRenewed->ContactTitle); $ExportDoc->ExportField($vwCPD_SPExpiredNotRenewed->ContactInitials); $ExportDoc->ExportField($vwCPD_SPExpiredNotRenewed->ContactEmail); $ExportDoc->ExportField($vwCPD_SPExpiredNotRenewed->ContactFirstName); $ExportDoc->ExportField($vwCPD_SPExpiredNotRenewed->ContactSurname); $ExportDoc->ExportField($vwCPD_SPExpiredNotRenewed->ContactPosition); $ExportDoc->ExportField($vwCPD_SPExpiredNotRenewed->ContactIDNum); $ExportDoc->ExportField($vwCPD_SPExpiredNotRenewed->PhoneNumber); $ExportDoc->ExportField($vwCPD_SPExpiredNotRenewed->Password); $ExportDoc->ExportField($vwCPD_SPExpiredNotRenewed->PhysicalAddress1); $ExportDoc->ExportField($vwCPD_SPExpiredNotRenewed->PhysicalAddress2); $ExportDoc->ExportField($vwCPD_SPExpiredNotRenewed->PhysicalCity); $ExportDoc->ExportField($vwCPD_SPExpiredNotRenewed->PhysicalCode); $ExportDoc->ExportField($vwCPD_SPExpiredNotRenewed->PhysicalProvince); $ExportDoc->ExportField($vwCPD_SPExpiredNotRenewed->PhysicalCountry); $ExportDoc->ExportField($vwCPD_SPExpiredNotRenewed->PostalAddress1); $ExportDoc->ExportField($vwCPD_SPExpiredNotRenewed->PostalAddress2); $ExportDoc->ExportField($vwCPD_SPExpiredNotRenewed->PostalCity); $ExportDoc->ExportField($vwCPD_SPExpiredNotRenewed->PostalCode); $ExportDoc->ExportField($vwCPD_SPExpiredNotRenewed->PostalProvince); $ExportDoc->ExportField($vwCPD_SPExpiredNotRenewed->PostalCountry); $ExportDoc->ExportField($vwCPD_SPExpiredNotRenewed->Website); $ExportDoc->ExportField($vwCPD_SPExpiredNotRenewed->VATNumber); $ExportDoc->ExportField($vwCPD_SPExpiredNotRenewed->Approved); $ExportDoc->ExportField($vwCPD_SPExpiredNotRenewed->SPNumber); $ExportDoc->ExportField($vwCPD_SPExpiredNotRenewed->DateUpdated); $ExportDoc->ExportField($vwCPD_SPExpiredNotRenewed->DateAssessed); $ExportDoc->ExportField($vwCPD_SPExpiredNotRenewed->UpdatedBy); $ExportDoc->ExportField($vwCPD_SPExpiredNotRenewed->Archived); $ExportDoc->ExportField($vwCPD_SPExpiredNotRenewed->ContactPhone); $ExportDoc->ExportField($vwCPD_SPExpiredNotRenewed->AdminTitle); $ExportDoc->ExportField($vwCPD_SPExpiredNotRenewed->AdminInitials); $ExportDoc->ExportField($vwCPD_SPExpiredNotRenewed->AdminFirstName); $ExportDoc->ExportField($vwCPD_SPExpiredNotRenewed->AdminSurname); $ExportDoc->ExportField($vwCPD_SPExpiredNotRenewed->AdminPosition); $ExportDoc->ExportField($vwCPD_SPExpiredNotRenewed->AdminIDNum); $ExportDoc->ExportField($vwCPD_SPExpiredNotRenewed->AdminEmail); $ExportDoc->ExportField($vwCPD_SPExpiredNotRenewed->AdminPhone); $ExportDoc->ExportField($vwCPD_SPExpiredNotRenewed->EmailAddress); $ExportDoc->ExportField($vwCPD_SPExpiredNotRenewed->DateExpires); $ExportDoc->ExportField($vwCPD_SPExpiredNotRenewed->EvaluatorID); $ExportDoc->ExportField($vwCPD_SPExpiredNotRenewed->EvaluatorID2); $ExportDoc->ExportField($vwCPD_SPExpiredNotRenewed->EvaluatorID3); $ExportDoc->ExportField($vwCPD_SPExpiredNotRenewed->InvoiceCode); $ExportDoc->ExportField($vwCPD_SPExpiredNotRenewed->InvoiceNumber); $ExportDoc->ExportField($vwCPD_SPExpiredNotRenewed->Cost); $ExportDoc->ExportField($vwCPD_SPExpiredNotRenewed->EvaluatorFee); $ExportDoc->ExportField($vwCPD_SPExpiredNotRenewed->EvaluatorFeeAmount); $ExportDoc->ExportField($vwCPD_SPExpiredNotRenewed->EvaluatorFeeDate); $ExportDoc->ExportField($vwCPD_SPExpiredNotRenewed->CellNumber); $ExportDoc->ExportField($vwCPD_SPExpiredNotRenewed->ContactCell); $ExportDoc->ExportField($vwCPD_SPExpiredNotRenewed->AdminCell); $ExportDoc->ExportField($vwCPD_SPExpiredNotRenewed->DepositAmt); $ExportDoc->ExportField($vwCPD_SPExpiredNotRenewed->InvoiceFile); $ExportDoc->ExportField($vwCPD_SPExpiredNotRenewed->InvoiceDate); $ExportDoc->ExportField($vwCPD_SPExpiredNotRenewed->DatePaid); $ExportDoc->ExportField($vwCPD_SPExpiredNotRenewed->ProofOfPayment); $ExportDoc->ExportField($vwCPD_SPExpiredNotRenewed->EvaluatorInvoice); $ExportDoc->ExportField($vwCPD_SPExpiredNotRenewed->EvaluatorTimesheet); $ExportDoc->ExportField($vwCPD_SPExpiredNotRenewed->NumReminders); $ExportDoc->ExportField($vwCPD_SPExpiredNotRenewed->LastReminder); $ExportDoc->ExportField($vwCPD_SPExpiredNotRenewed->PrevSPNumber); $ExportDoc->ExportField($vwCPD_SPExpiredNotRenewed->Renewal); $ExportDoc->ExportField($vwCPD_SPExpiredNotRenewed->DateCreated); $ExportDoc->EndExportRow(); } } $rs->MoveNext(); } if ($vwCPD_SPExpiredNotRenewed->Export <> "xml") $ExportDoc->ExportFooter(); // Close recordset $rs->Close(); // Clean output buffer if (!EW_DEBUG_ENABLED && ob_get_length()) ob_end_clean(); // Write BOM if utf-8 if ($utf8 && !in_array($vwCPD_SPExpiredNotRenewed->Export, array("email", "xml"))) echo "\xEF\xBB\xBF"; // Write debug message if enabled if (EW_DEBUG_ENABLED) echo ew_DebugMsg(); // Output data if ($vwCPD_SPExpiredNotRenewed->Export == "xml") { header("Content-Type: text/xml"); echo $XmlDoc->XML(); } elseif ($vwCPD_SPExpiredNotRenewed->Export == "email") { $this->ExportEmail($ExportDoc->Text); $this->Page_Terminate($vwCPD_SPExpiredNotRenewed->ExportReturnUrl()); } else { echo $ExportDoc->Text; } } // Export email function ExportEmail($EmailContent) { global $Language, $vwCPD_SPExpiredNotRenewed; $sSender = @$_GET["sender"]; $sRecipient = @$_GET["recipient"]; $sCc = @$_GET["cc"]; $sBcc = @$_GET["bcc"]; $sContentType = @$_GET["contenttype"]; // Subject $sSubject = ew_StripSlashes(@$_GET["subject"]); $sEmailSubject = $sSubject; // Message $sContent = ew_StripSlashes(@$_GET["message"]); $sEmailMessage = $sContent; // Check sender if ($sSender == "") { $this->setMessage($Language->Phrase("EnterSenderEmail")); return; } if (!ew_CheckEmail($sSender)) { $this->setMessage($Language->Phrase("EnterProperSenderEmail")); return; } // Check recipient if (!ew_CheckEmailList($sRecipient, EW_MAX_EMAIL_RECIPIENT)) { $this->setMessage($Language->Phrase("EnterProperRecipientEmail")); return; } // Check cc if (!ew_CheckEmailList($sCc, EW_MAX_EMAIL_RECIPIENT)) { $this->setMessage($Language->Phrase("EnterProperCcEmail")); return; } // Check bcc if (!ew_CheckEmailList($sBcc, EW_MAX_EMAIL_RECIPIENT)) { $this->setMessage($Language->Phrase("EnterProperBccEmail")); return; } // Check email sent count if (!isset($_SESSION[EW_EXPORT_EMAIL_COUNTER])) $_SESSION[EW_EXPORT_EMAIL_COUNTER] = 0; if (intval($_SESSION[EW_EXPORT_EMAIL_COUNTER]) > EW_MAX_EMAIL_SENT_COUNT) { $this->setMessage($Language->Phrase("ExceedMaxEmailExport")); return; } if ($sEmailMessage <> "") { $sEmailMessage = ew_RemoveXSS($sEmailMessage); $sEmailMessage .= ($sContentType == "url") ? "\r\n\r\n" : "<br><br>"; } if ($sContentType == "url") { $sUrl = ew_ConvertFullUrl(ew_CurrentPage() . "?" . $this->ExportQueryString()); $sEmailMessage .= $sUrl; // send URL only } else { $sEmailMessage .= $EmailContent; // send HTML } // Send email $Email = new cEmail(); $Email->Sender = $sSender; // Sender $Email->Recipient = $sRecipient; // Recipient $Email->Cc = $sCc; // Cc $Email->Bcc = $sBcc; // Bcc $Email->Subject = $sEmailSubject; // Subject $Email->Content = $sEmailMessage; // Content $Email->Format = ($sContentType == "url") ? "text" : "html"; $Email->Charset = EW_EMAIL_CHARSET; $EventArgs = array(); $bEmailSent = FALSE; if ($vwCPD_SPExpiredNotRenewed->Email_Sending($Email, $EventArgs)) $bEmailSent = $Email->Send(); // Check email sent status if ($bEmailSent) { // Update email sent count $_SESSION[EW_EXPORT_EMAIL_COUNTER]++; // Sent email success $this->setMessage($Language->Phrase("SendEmailSuccess")); } else { // Sent email failure $this->setMessage($Email->SendErrDescription); } } // Export QueryString function ExportQueryString() { global $vwCPD_SPExpiredNotRenewed; // Initialize $sQry = "export=html"; // Build QueryString for search if ($vwCPD_SPExpiredNotRenewed->getSessionBasicSearchKeyword() <> "") { $sQry .= "&" . EW_TABLE_BASIC_SEARCH . "=" . $vwCPD_SPExpiredNotRenewed->getSessionBasicSearchKeyword() . "&" . EW_TABLE_BASIC_SEARCH_TYPE . "=" . $vwCPD_SPExpiredNotRenewed->getSessionBasicSearchType(); } // Build QueryString for pager $sQry .= "&" . EW_TABLE_REC_PER_PAGE . "=" . $vwCPD_SPExpiredNotRenewed->getRecordsPerPage() . "&" . EW_TABLE_START_REC . "=" . $vwCPD_SPExpiredNotRenewed->getStartRecordNumber(); return $sQry; } // Add search QueryString function AddSearchQueryString(&$Qry, &$Fld) { global $vwCPD_SPExpiredNotRenewed; $FldParm = substr($Fld->FldVar, 2); $FldSearchValue = $vwCPD_SPExpiredNotRenewed->GetAdvancedSearch("x_" . $FldParm); if (strval($FldSearchValue) <> "") { $Qry .= "&x_" . $FldParm . "=" . FldSearchValue . "&z_" . $FldParm . "=" . $vwCPD_SPExpiredNotRenewed->GetAdvancedSearch("z_" . $FldParm); } $FldSearchValue2 = $vwCPD_SPExpiredNotRenewed->GetAdvancedSearch("y_" . $FldParm); if (strval($FldSearchValue2) <> "") { $Qry .= "&v_" . $FldParm . "=" . $vwCPD_SPExpiredNotRenewed->GetAdvancedSearch("v_" . $FldParm) . "&y_" . $FldParm . "=" . $FldSearchValue2 . "&w_" . $FldParm . "=" . $vwCPD_SPExpiredNotRenewed->GetAdvancedSearch("w_" . $FldParm); } } // Page Load event function Page_Load() { //echo "Page Load"; } // Page Unload event function Page_Unload() { //echo "Page Unload"; } // Page Redirecting event function Page_Redirecting(&$url) { // Example: //$url = "your URL"; } // Message Showing event function Message_Showing(&$msg) { // Example: //$msg = "your new message"; } // Form Custom Validate event function Form_CustomValidate(&$CustomError) { // Return error message in CustomError return TRUE; } // ListOptions Load event function ListOptions_Load() { // Example: //$this->ListOptions->Add("new"); //$this->ListOptions->Items["new"]->OnLeft = TRUE; // Link on left //$this->ListOptions->MoveItem("new", 0); // Move to first column } // ListOptions Rendered event function ListOptions_Rendered() { // Example: //$this->ListOptions->Items["new"]->Body = "xxx"; } } ?>