Gecko [ v3.cesa.co.za ]

Name	Size	Permission	Date
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

Rename

<?php

// Global variable for table object
$cstReviewProgress = NULL;

//
// Table class for cstReviewProgress
//
class ccstReviewProgress {
	var $TableVar = 'cstReviewProgress';
	var $TableName = 'cstReviewProgress';
	var $TableType = 'CUSTOMVIEW';
	var $CompanyName;
	var $StepName;
	var $StepDone;
	var $Comments;
	var $DateUpdated;
	var $fields = array();
	var $UseTokenInUrl = EW_USE_TOKEN_IN_URL;
	var $Export; // Export
	var $ExportOriginalValue = EW_EXPORT_ORIGINAL_VALUE;
	var $ExportAll = TRUE;
	var $SendEmail; // Send email
	var $TableCustomInnerHtml; // Custom inner HTML
	var $BasicSearchKeyword; // Basic search keyword
	var $BasicSearchType; // Basic search type
	var $CurrentFilter; // Current filter
	var $CurrentOrder; // Current order
	var $CurrentOrderType; // Current order type
	var $RowType; // Row type
	var $CssClass; // CSS class
	var $CssStyle; // CSS style
	var $RowAttrs = array(); // Row custom attributes
	var $TableFilter = "";
	var $CurrentAction; // Current action
	var $UpdateConflict; // Update conflict
	var $EventName; // Event name
	var $EventCancelled; // Event cancelled
	var $CancelMessage; // Cancel message

//
	// Table class constructor
	//
	function __construct() {
		global $Language;

// CompanyName
		$this->CompanyName = new cField('cstReviewProgress', 'cstReviewProgress', 'x_CompanyName', 'CompanyName', 'CPDServiceProvider.CompanyName', 200, -1, FALSE, 'CPDServiceProvider.CompanyName', FALSE);
		$this->fields['CompanyName'] =& $this->CompanyName;

// StepName
		$this->StepName = new cField('cstReviewProgress', 'cstReviewProgress', 'x_StepName', 'StepName', 'CPDSteps.StepName', 200, -1, FALSE, 'CPDSteps.StepName', FALSE);
		$this->fields['StepName'] =& $this->StepName;

// StepDone
		$this->StepDone = new cField('cstReviewProgress', 'cstReviewProgress', 'x_StepDone', 'StepDone', 'CPDStepsTaken.StepDone', 16, -1, FALSE, 'CPDStepsTaken.StepDone', FALSE);
		$this->StepDone->FldDefaultErrMsg = $Language->Phrase("IncorrectInteger");
		$this->fields['StepDone'] =& $this->StepDone;

// Comments
		$this->Comments = new cField('cstReviewProgress', 'cstReviewProgress', 'x_Comments', 'Comments', 'CPDStepsTaken.Comments', 201, -1, FALSE, 'CPDStepsTaken.Comments', FALSE);
		$this->fields['Comments'] =& $this->Comments;

// DateUpdated
		$this->DateUpdated = new cField('cstReviewProgress', 'cstReviewProgress', 'x_DateUpdated', 'DateUpdated', 'CPDStepsTaken.DateUpdated', 135, 5, FALSE, 'CPDStepsTaken.DateUpdated', FALSE);
		$this->DateUpdated->FldDefaultErrMsg = str_replace("%s", "/", $Language->Phrase("IncorrectDateYMD"));
		$this->fields['DateUpdated'] =& $this->DateUpdated;
	}

// Table caption
	function TableCaption() {
		global $Language;
		return $Language->TablePhrase($this->TableVar, "TblCaption");
	}

// Page caption
	function PageCaption($Page) {
		global $Language;
		$Caption = $Language->TablePhrase($this->TableVar, "TblPageCaption" . $Page);
		if ($Caption == "") $Caption = "Page " . $Page;
		return $Caption;
	}

// Export return page
	function ExportReturnUrl() {
		$url = @$_SESSION[EW_PROJECT_NAME . "_" . $this->TableVar . "_" . EW_TABLE_EXPORT_RETURN_URL];
		return ($url <> "") ? $url : ew_CurrentPage();
	}

function setExportReturnUrl($v) {
		$_SESSION[EW_PROJECT_NAME . "_" . $this->TableVar . "_" . EW_TABLE_EXPORT_RETURN_URL] = $v;
	}

// Records per page
	function getRecordsPerPage() {
		return @$_SESSION[EW_PROJECT_NAME . "_" . $this->TableVar . "_" . EW_TABLE_REC_PER_PAGE];
	}

function setRecordsPerPage($v) {
		$_SESSION[EW_PROJECT_NAME . "_" . $this->TableVar . "_" . EW_TABLE_REC_PER_PAGE] = $v;
	}

// Start record number
	function getStartRecordNumber() {
		return @$_SESSION[EW_PROJECT_NAME . "_" . $this->TableVar . "_" . EW_TABLE_START_REC];
	}

function setStartRecordNumber($v) {
		$_SESSION[EW_PROJECT_NAME . "_" . $this->TableVar . "_" . EW_TABLE_START_REC] = $v;
	}

// Search highlight name
	function HighlightName() {
		return "cstReviewProgress_Highlight";
	}

// Advanced search
	function getAdvancedSearch($fld) {
		return @$_SESSION[EW_PROJECT_NAME . "_" . $this->TableVar . "_" . EW_TABLE_ADVANCED_SEARCH . "_" . $fld];
	}

function setAdvancedSearch($fld, $v) {
		if (@$_SESSION[EW_PROJECT_NAME . "_" . $this->TableVar . "_" . EW_TABLE_ADVANCED_SEARCH . "_" . $fld] <> $v) {
			$_SESSION[EW_PROJECT_NAME . "_" . $this->TableVar . "_" . EW_TABLE_ADVANCED_SEARCH . "_" . $fld] = $v;
		}
	}

// Basic search keyword
	function getSessionBasicSearchKeyword() {
		return @$_SESSION[EW_PROJECT_NAME . "_" . $this->TableVar . "_" . EW_TABLE_BASIC_SEARCH];
	}

function setSessionBasicSearchKeyword($v) {
		$_SESSION[EW_PROJECT_NAME . "_" . $this->TableVar . "_" . EW_TABLE_BASIC_SEARCH] = $v;
	}

// Basic search type
	function getSessionBasicSearchType() {
		return @$_SESSION[EW_PROJECT_NAME . "_" . $this->TableVar . "_" . EW_TABLE_BASIC_SEARCH_TYPE];
	}

function setSessionBasicSearchType($v) {
		$_SESSION[EW_PROJECT_NAME . "_" . $this->TableVar . "_" . EW_TABLE_BASIC_SEARCH_TYPE] = $v;
	}

// Search WHERE clause
	function getSearchWhere() {
		return @$_SESSION[EW_PROJECT_NAME . "_" . $this->TableVar . "_" . EW_TABLE_SEARCH_WHERE];
	}

function setSearchWhere($v) {
		$_SESSION[EW_PROJECT_NAME . "_" . $this->TableVar . "_" . EW_TABLE_SEARCH_WHERE] = $v;
	}

// Multiple column sort
	function UpdateSort(&$ofld, $ctrl) {
		if ($this->CurrentOrder == $ofld->FldName) {
			$sSortField = $ofld->FldExpression;
			$sLastSort = $ofld->getSort();
			if ($this->CurrentOrderType == "ASC" || $this->CurrentOrderType == "DESC") {
				$sThisSort = $this->CurrentOrderType;
			} else {
				$sThisSort = ($sLastSort == "ASC") ? "DESC" : "ASC";
			}
			$ofld->setSort($sThisSort);
			if ($ctrl) {
				$sOrderBy = $this->getSessionOrderBy();
				if (strpos($sOrderBy, $sSortField . " " . $sLastSort) !== FALSE) {
					$sOrderBy = str_replace($sSortField . " " . $sLastSort, $sSortField . " " . $sThisSort, $sOrderBy);
				} else {
					if ($sOrderBy <> "") $sOrderBy .= ", ";
					$sOrderBy .= $sSortField . " " . $sThisSort;
				}
				$this->setSessionOrderBy($sOrderBy); // Save to Session
			} else {
				$this->setSessionOrderBy($sSortField . " " . $sThisSort); // Save to Session
			}
		} else {
			if (!$ctrl) $ofld->setSort("");
		}
	}

// Session WHERE clause
	function getSessionWhere() {
		return @$_SESSION[EW_PROJECT_NAME . "_" . $this->TableVar . "_" . EW_TABLE_WHERE];
	}

function setSessionWhere($v) {
		$_SESSION[EW_PROJECT_NAME . "_" . $this->TableVar . "_" . EW_TABLE_WHERE] = $v;
	}

// Session ORDER BY
	function getSessionOrderBy() {
		return @$_SESSION[EW_PROJECT_NAME . "_" . $this->TableVar . "_" . EW_TABLE_ORDER_BY];
	}

function setSessionOrderBy($v) {
		$_SESSION[EW_PROJECT_NAME . "_" . $this->TableVar . "_" . EW_TABLE_ORDER_BY] = $v;
	}

// Session key
	function getKey($fld) {
		return @$_SESSION[EW_PROJECT_NAME . "_" . $this->TableVar . "_" . EW_TABLE_KEY . "_" . $fld];
	}

function setKey($fld, $v) {
		$_SESSION[EW_PROJECT_NAME . "_" . $this->TableVar . "_" . EW_TABLE_KEY . "_" . $fld] = $v;
	}

// Table level SQL
	function SqlFrom() { // From
		return "CPDStepsTaken Inner Join CPDServiceProvider On CPDServiceProvider.CPDProviderID = CPDStepsTaken.CPDProviderID Inner Join CPDSteps On CPDSteps.CPDStepID = CPDStepsTaken.CPDStepID";
	}

function SqlSelect() { // Select
		return "SELECT CPDServiceProvider.CompanyName, CPDSteps.StepName, CPDStepsTaken.StepDone, CPDStepsTaken.Comments, CPDStepsTaken.DateUpdated FROM " . $this->SqlFrom();
	}

function SqlWhere() { // Where
		$sWhere = "";
		$this->TableFilter = "";
		if ($this->TableFilter <> "") {
			if ($sWhere <> "") $sWhere = "(" . $sWhere . ") AND (";
			$sWhere .= "(" . $this->TableFilter . ")";
		}
		return $sWhere;
	}

function SqlGroupBy() { // Group By
		return "";
	}

function SqlHaving() { // Having
		return "";
	}

function SqlOrderBy() { // Order By
		return "CPDStepsTaken.DateUpdated Desc";
	}

// Check if Anonymous User is allowed
	function AllowAnonymousUser() {
		switch (EW_PAGE_ID) {
			case "add":
			case "register":
			case "addopt":
				return FALSE;
			case "edit":
			case "update":
				return FALSE;
			case "delete":
				return FALSE;
			case "view":
				return FALSE;
			case "search":
				return FALSE;
			default:
				return FALSE;
		}
	}

// Apply User ID filters
	function ApplyUserIDFilters($sFilter) {
		return $sFilter;
	}

// Get SQL
	function GetSQL($where, $orderby) {
		return ew_BuildSelectSql($this->SqlSelect(), $this->SqlWhere(),
			$this->SqlGroupBy(), $this->SqlHaving(), $this->SqlOrderBy(),
			$where, $orderby);
	}

// Table SQL
	function SQL() {
		$sFilter = $this->CurrentFilter;
		$sFilter = $this->ApplyUserIDFilters($sFilter);
		$sSort = $this->getSessionOrderBy();
		return ew_BuildSelectSql($this->SqlSelect(), $this->SqlWhere(),
			$this->SqlGroupBy(), $this->SqlHaving(), $this->SqlOrderBy(),
			$sFilter, $sSort);
	}

// Table SQL with List page filter
	function SelectSQL() {
		$sFilter = $this->getSessionWhere();
		if ($this->CurrentFilter <> "") {
			if ($sFilter <> "") $sFilter = "(" . $sFilter . ") AND ";
			$sFilter .= "(" . $this->CurrentFilter . ")";
		}
		$sFilter = $this->ApplyUserIDFilters($sFilter);
		$sSort = $this->getSessionOrderBy();
		return ew_BuildSelectSql($this->SqlSelect(), $this->SqlWhere(), $this->SqlGroupBy(),
			$this->SqlHaving(), $this->SqlOrderBy(), $sFilter, $sSort);
	}

// Try to get record count
	function TryGetRecordCount($sSql) {
		global $conn;
		$cnt = -1;
		if ($this->TableType == 'TABLE' || $this->TableType == 'VIEW') {
			$sSql = "SELECT COUNT(*) FROM" . substr($sSql, 13);
		} else {
			$sSql = "SELECT COUNT(*) FROM (" . $sSql . ") EW_COUNT_TABLE";
		}
		if ($rs = $conn->Execute($sSql)) {
			if (!$rs->EOF && $rs->FieldCount() > 0) {
				$cnt = $rs->fields[0];
				$rs->Close();
			}
		}
		return intval($cnt);
	}

// Get record count based on filter (for detail record count in master table pages)
	function LoadRecordCount($sFilter) {
		$origFilter = $this->CurrentFilter;
		$this->CurrentFilter = $sFilter;
		$this->Recordset_Selecting($this->CurrentFilter);
		$sSql = $this->SQL();
		$cnt = $this->TryGetRecordCount($sSql);
		if ($cnt == -1) {
			if ($rs = $this->LoadRs($this->CurrentFilter)) {
				$cnt = $rs->RecordCount();
				$rs->Close();
			}
		}
		$this->CurrentFilter = $origFilter;
		return intval($cnt);
	}

// Get record count (for current List page)
	function SelectRecordCount() {
		global $conn;
		$origFilter = $this->CurrentFilter;
		$this->Recordset_Selecting($this->CurrentFilter);
		$sSql = $this->SelectSQL();
		$cnt = $this->TryGetRecordCount($sSql);
		if ($cnt == -1) {
			if ($rs = $conn->Execute($this->SelectSQL())) {
				$cnt = $rs->RecordCount();
				$rs->Close();
			}
		}
		$this->CurrentFilter = $origFilter;
		return intval($cnt);
	}

// INSERT statement
	function InsertSQL(&$rs) {
		global $conn;
		$names = "";
		$values = "";
		foreach ($rs as $name => $value) {
			$names .= $this->fields[$name]->FldExpression . ",";
			$values .= ew_QuotedValue($value, $this->fields[$name]->FldDataType) . ",";
		}
		if (substr($names, -1) == ",") $names = substr($names, 0, strlen($names)-1);
		if (substr($values, -1) == ",") $values = substr($values, 0, strlen($values)-1);
		return "INSERT INTO CPDStepsTaken Inner Join CPDServiceProvider On CPDServiceProvider.CPDProviderID = CPDStepsTaken.CPDProviderID Inner Join CPDSteps On CPDSteps.CPDStepID = CPDStepsTaken.CPDStepID ($names) VALUES ($values)";
	}

// UPDATE statement
	function UpdateSQL(&$rs) {
		global $conn;
		$SQL = "UPDATE CPDStepsTaken Inner Join CPDServiceProvider On CPDServiceProvider.CPDProviderID = CPDStepsTaken.CPDProviderID Inner Join CPDSteps On CPDSteps.CPDStepID = CPDStepsTaken.CPDStepID SET ";
		foreach ($rs as $name => $value) {
			$SQL .= $this->fields[$name]->FldExpression . "=";
			$SQL .= ew_QuotedValue($value, $this->fields[$name]->FldDataType) . ",";
		}
		if (substr($SQL, -1) == ",") $SQL = substr($SQL, 0, strlen($SQL)-1);
		if ($this->CurrentFilter <> "")	$SQL .= " WHERE " . $this->CurrentFilter;
		return $SQL;
	}

// DELETE statement
	function DeleteSQL(&$rs) {
		$SQL = "DELETE FROM CPDStepsTaken Inner Join CPDServiceProvider On CPDServiceProvider.CPDProviderID = CPDStepsTaken.CPDProviderID Inner Join CPDSteps On CPDSteps.CPDStepID = CPDStepsTaken.CPDStepID WHERE ";
		if (substr($SQL, -5) == " AND ") $SQL = substr($SQL, 0, strlen($SQL)-5);
		if ($this->CurrentFilter <> "")	$SQL .= " AND " . $this->CurrentFilter;
		return $SQL;
	}

// Key filter WHERE clause
	function SqlKeyFilter() {
		return "";
	}

// Key filter
	function KeyFilter() {
		$sKeyFilter = $this->SqlKeyFilter();
		return $sKeyFilter;
	}

// Return page URL
	function getReturnUrl() {
		$name = EW_PROJECT_NAME . "_" . $this->TableVar . "_" . EW_TABLE_RETURN_URL;

// Get referer URL automatically
		if (ew_ServerVar("HTTP_REFERER") <> "" && ew_ReferPage() <> ew_CurrentPage() && ew_ReferPage() <> "login.php") // Referer not same page or login page
			$_SESSION[$name] = ew_ServerVar("HTTP_REFERER"); // Save to Session
		if (@$_SESSION[$name] <> "") {
			return $_SESSION[$name];
		} else {
			return "cstReviewProgresslist.php";
		}
	}

function setReturnUrl($v) {
		$_SESSION[EW_PROJECT_NAME . "_" . $this->TableVar . "_" . EW_TABLE_RETURN_URL] = $v;
	}

// List URL
	function ListUrl() {
		return "cstReviewProgresslist.php";
	}

// View URL
	function ViewUrl() {
		return $this->KeyUrl("cstReviewProgressview.php", $this->UrlParm());
	}

// Add URL
	function AddUrl() {
		$AddUrl = "cstReviewProgressadd.php";
		$sUrlParm = $this->UrlParm();
		if ($sUrlParm <> "")
			$AddUrl .= "?" . $sUrlParm;
		return $AddUrl;
	}

// Edit URL
	function EditUrl() {
		return $this->KeyUrl("cstReviewProgressedit.php", $this->UrlParm());
	}

// Inline edit URL
	function InlineEditUrl() {
		return $this->KeyUrl(ew_CurrentPage(), $this->UrlParm("a=edit"));
	}

// Copy URL
	function CopyUrl() {
		return $this->KeyUrl("cstReviewProgressadd.php", $this->UrlParm());
	}

// Inline copy URL
	function InlineCopyUrl() {
		return $this->KeyUrl(ew_CurrentPage(), $this->UrlParm("a=copy"));
	}

// Delete URL
	function DeleteUrl() {
		return $this->KeyUrl("cstReviewProgressdelete.php", $this->UrlParm());
	}

// Add key value to URL
	function KeyUrl($url, $parm = "") {
		$sUrl = $url . "?";
		if ($parm <> "") $sUrl .= $parm . "&";
		return $sUrl;
	}

// Sort URL
	function SortUrl(&$fld) {
		if ($this->CurrentAction <> "" || $this->Export <> "" ||
			in_array($fld->FldType, array(128, 204, 205))) { // Unsortable data type
				return "";
		} elseif ($fld->Sortable) {
			$sUrlParm = $this->UrlParm("order=" . urlencode($fld->FldName) . "&ordertype=" . $fld->ReverseSort());
			return ew_CurrentPage() . "?" . $sUrlParm;
		} else {
			return "";
		}
	}

// Add URL parameter
	function UrlParm($parm = "") {
		$UrlParm = ($this->UseTokenInUrl) ? "t=cstReviewProgress" : "";
		if ($parm <> "") {
			if ($UrlParm <> "")
				$UrlParm .= "&";
			$UrlParm .= $parm;
		}
		return $UrlParm;
	}

// Load rows based on filter
	function &LoadRs($sFilter) {
		global $conn;

// Set up filter (SQL WHERE clause) and get return SQL
		$this->CurrentFilter = $sFilter;
		$sSql = $this->SQL();
		return $conn->Execute($sSql);
	}

// Load row values from recordset
	function LoadListRowValues(&$rs) {
		$this->CompanyName->setDbValue($rs->fields('CompanyName'));
		$this->StepName->setDbValue($rs->fields('StepName'));
		$this->StepDone->setDbValue($rs->fields('StepDone'));
		$this->Comments->setDbValue($rs->fields('Comments'));
		$this->DateUpdated->setDbValue($rs->fields('DateUpdated'));
	}

// Render list row values
	function RenderListRow() {
		global $conn, $Security;

// Call Row Rendering event
		$this->Row_Rendering();

// Common render codes
		// CompanyName

$this->CompanyName->CellCssStyle = ""; $this->CompanyName->CellCssClass = "";
		$this->CompanyName->CellAttrs = array(); $this->CompanyName->ViewAttrs = array(); $this->CompanyName->EditAttrs = array();

// StepName
		$this->StepName->CellCssStyle = ""; $this->StepName->CellCssClass = "";
		$this->StepName->CellAttrs = array(); $this->StepName->ViewAttrs = array(); $this->StepName->EditAttrs = array();

// StepDone
		$this->StepDone->CellCssStyle = ""; $this->StepDone->CellCssClass = "";
		$this->StepDone->CellAttrs = array(); $this->StepDone->ViewAttrs = array(); $this->StepDone->EditAttrs = array();

// Comments
		$this->Comments->CellCssStyle = ""; $this->Comments->CellCssClass = "";
		$this->Comments->CellAttrs = array(); $this->Comments->ViewAttrs = array(); $this->Comments->EditAttrs = array();

// DateUpdated
		$this->DateUpdated->CellCssStyle = ""; $this->DateUpdated->CellCssClass = "";
		$this->DateUpdated->CellAttrs = array(); $this->DateUpdated->ViewAttrs = array(); $this->DateUpdated->EditAttrs = array();

// CompanyName
		$this->CompanyName->ViewValue = $this->CompanyName->CurrentValue;
		$this->CompanyName->CssStyle = "";
		$this->CompanyName->CssClass = "";
		$this->CompanyName->ViewCustomAttributes = "";

// StepName
		$this->StepName->ViewValue = $this->StepName->CurrentValue;
		$this->StepName->CssStyle = "";
		$this->StepName->CssClass = "";
		$this->StepName->ViewCustomAttributes = "";

// StepDone
		if (strval($this->StepDone->CurrentValue) <> "") {
			switch ($this->StepDone->CurrentValue) {
				case "1":
					$this->StepDone->ViewValue = "Yes";
					break;
				case "0":
					$this->StepDone->ViewValue = "No";
					break;
				default:
					$this->StepDone->ViewValue = $this->StepDone->CurrentValue;
			}
		} else {
			$this->StepDone->ViewValue = NULL;
		}
		$this->StepDone->CssStyle = "";
		$this->StepDone->CssClass = "";
		$this->StepDone->ViewCustomAttributes = "";

// Comments
		$this->Comments->ViewValue = $this->Comments->CurrentValue;
		$this->Comments->CssStyle = "";
		$this->Comments->CssClass = "";
		$this->Comments->ViewCustomAttributes = "";

// DateUpdated
		$this->DateUpdated->ViewValue = $this->DateUpdated->CurrentValue;
		$this->DateUpdated->ViewValue = ew_FormatDateTime($this->DateUpdated->ViewValue, 5);
		$this->DateUpdated->CssStyle = "";
		$this->DateUpdated->CssClass = "";
		$this->DateUpdated->ViewCustomAttributes = "";

// CompanyName
		$this->CompanyName->HrefValue = "";
		$this->CompanyName->TooltipValue = "";

// StepName
		$this->StepName->HrefValue = "";
		$this->StepName->TooltipValue = "";

// StepDone
		$this->StepDone->HrefValue = "";
		$this->StepDone->TooltipValue = "";

// Comments
		$this->Comments->HrefValue = "";
		$this->Comments->TooltipValue = "";

// DateUpdated
		$this->DateUpdated->HrefValue = "";
		$this->DateUpdated->TooltipValue = "";

// Call Row Rendered event
		$this->Row_Rendered();
	}

// Aggregate list row values
	function AggregateListRowValues() {
	}

// Aggregate list row (for rendering)
	function AggregateListRow() {
	}

// Row styles
	function RowStyles() {
		$sAtt = "";
		$sStyle = trim($this->CssStyle);
		if (@$this->RowAttrs["style"] <> "")
			$sStyle .= " " . $this->RowAttrs["style"];
		$sClass = trim($this->CssClass);
		if (@$this->RowAttrs["class"] <> "")
			$sClass .= " " . $this->RowAttrs["class"];
		if (trim($sStyle) <> "")
			$sAtt .= " style=\"" . trim($sStyle) . "\"";
		if (trim($sClass) <> "")
			$sAtt .= " class=\"" . trim($sClass) . "\"";
		return $sAtt;
	}

// Row attributes
	function RowAttributes() {
		$sAtt = $this->RowStyles();
		if ($this->Export == "") {
			foreach ($this->RowAttrs as $k => $v) {
				if ($k <> "class" && $k <> "style" && trim($v) <> "")
					$sAtt .= " " . $k . "=\"" . trim($v) . "\"";
			}
		}
		return $sAtt;
	}

// Field object by name
	function fields($fldname) {
		return $this->fields[$fldname];
	}

// Table level events
	// Recordset Selecting event
	function Recordset_Selecting(&$filter) {

// Enter your code here	
	}

// Recordset Selected event
	function Recordset_Selected(&$rs) {

//echo "Recordset Selected";
	}

// Recordset Search Validated event
	function Recordset_SearchValidated() {

// Example:
		//$this->MyField1->AdvancedSearch->SearchValue = "your search criteria"; // Search value

}

// Recordset Searching event
	function Recordset_Searching(&$filter) {

// Enter your code here	
	}

// Row_Selecting event
	function Row_Selecting(&$filter) {

// Enter your code here	
	}

// Row Selected event
	function Row_Selected(&$rs) {

//echo "Row Selected";
	}

// Row Rendering event
	function Row_Rendering() {

// Enter your code here	
	}

// Row Rendered event
	function Row_Rendered() {

// To view properties of field class, use:
		//var_dump($this-><FieldName>);

}

// Row Inserting event
	function Row_Inserting(&$rs) {

// Enter your code here
		// To cancel, set return value to FALSE

return TRUE;
	}

// Row Inserted event
	function Row_Inserted(&$rs) {

//echo "Row Inserted"
	}

// Row Updating event
	function Row_Updating(&$rsold, &$rsnew) {

// Enter your code here
		// To cancel, set return value to FALSE

return TRUE;
	}

// Row Updated event
	function Row_Updated(&$rsold, &$rsnew) {

//echo "Row Updated";
	}

// Row Update Conflict event
	function Row_UpdateConflict(&$rsold, &$rsnew) {

// Enter your code here
		// To ignore conflict, set return value to FALSE

return TRUE;
	}

// Row Deleting event
	function Row_Deleting(&$rs) {

// Enter your code here
		// To cancel, set return value to False

return TRUE;
	}

// Row Deleted event
	function Row_Deleted(&$rs) {

//echo "Row Deleted";
	}

// Email Sending event
	function Email_Sending(&$Email, &$Args) {

//var_dump($Email); var_dump($Args); exit();
		return TRUE;
	}
}
?>