// Page ID

var $PageID = 'view';

// Project ID

var $ProjectID = "{B2F6402D-7C0A-4760-82AD-045088CEBA18}";

// Table name

var $TableName = 'conciliation';

// Page object name

var $PageObjName = 'conciliation_view';

// Page name

function PageName() {

return ew_CurrentPage();

}

// Page URL

function PageUrl() {

$PageUrl = ew_CurrentPage() . "?";

if ($this->UseTokenInUrl) $PageUrl .= "t=" . $this->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;

var $ExportPdfUrl;

// Custom export

var $ExportExcelCustom = FALSE;

var $ExportWordCustom = FALSE;

var $ExportPdfCustom = FALSE;

var $ExportEmailCustom = FALSE;

// 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) {

ew_AddMessage($_SESSION[EW_SESSION_MESSAGE], $v);

}

function getFailureMessage() {

return @$_SESSION[EW_SESSION_FAILURE_MESSAGE];

}

function setFailureMessage($v) {

ew_AddMessage($_SESSION[EW_SESSION_FAILURE_MESSAGE], $v);

}

function getSuccessMessage() {

return @$_SESSION[EW_SESSION_SUCCESS_MESSAGE];

}

function setSuccessMessage($v) {

ew_AddMessage($_SESSION[EW_SESSION_SUCCESS_MESSAGE], $v);

}

function getWarningMessage() {

return @$_SESSION[EW_SESSION_WARNING_MESSAGE];

}

function setWarningMessage($v) {

ew_AddMessage($_SESSION[EW_SESSION_WARNING_MESSAGE], $v);

}

// Methods to clear message

function ClearMessage() {

$_SESSION[EW_SESSION_MESSAGE] = "";

}

function ClearFailureMessage() {

$_SESSION[EW_SESSION_FAILURE_MESSAGE] = "";

}

function ClearSuccessMessage() {

$_SESSION[EW_SESSION_SUCCESS_MESSAGE] = "";

}

function ClearWarningMessage() {

$_SESSION[EW_SESSION_WARNING_MESSAGE] = "";

}

function ClearMessages() {

$_SESSION[EW_SESSION_MESSAGE] = "";

$_SESSION[EW_SESSION_FAILURE_MESSAGE] = "";

$_SESSION[EW_SESSION_SUCCESS_MESSAGE] = "";

$_SESSION[EW_SESSION_WARNING_MESSAGE] = "";

}

// Show message

function ShowMessage() {

$hidden = TRUE;

$html = "";

// Message

$sMessage = $this->getMessage();

$this->Message_Showing($sMessage, "");

if ($sMessage <> "") { // Message in Session, display

if (!$hidden)

$sMessage = "<button type=\"button\" class=\"close\" data-dismiss=\"alert\">&times;</button>" . $sMessage;

$html .= "<div class=\"alert alert-info ewInfo\">" . $sMessage . "</div>";

$_SESSION[EW_SESSION_MESSAGE] = ""; // Clear message in Session

}

// Warning message

$sWarningMessage = $this->getWarningMessage();

$this->Message_Showing($sWarningMessage, "warning");

if ($sWarningMessage <> "") { // Message in Session, display

if (!$hidden)

$sWarningMessage = "<button type=\"button\" class=\"close\" data-dismiss=\"alert\">&times;</button>" . $sWarningMessage;

$html .= "<div class=\"alert alert-warning ewWarning\">" . $sWarningMessage . "</div>";

$_SESSION[EW_SESSION_WARNING_MESSAGE] = ""; // Clear message in Session

}

// Success message

$sSuccessMessage = $this->getSuccessMessage();

$this->Message_Showing($sSuccessMessage, "success");

if ($sSuccessMessage <> "") { // Message in Session, display

if (!$hidden)

$sSuccessMessage = "<button type=\"button\" class=\"close\" data-dismiss=\"alert\">&times;</button>" . $sSuccessMessage;

$html .= "<div class=\"alert alert-success ewSuccess\">" . $sSuccessMessage . "</div>";

$_SESSION[EW_SESSION_SUCCESS_MESSAGE] = ""; // Clear message in Session

}

// Failure message

$sErrorMessage = $this->getFailureMessage();

$this->Message_Showing($sErrorMessage, "failure");

if ($sErrorMessage <> "") { // Message in Session, display

if (!$hidden)

$sErrorMessage = "<button type=\"button\" class=\"close\" data-dismiss=\"alert\">&times;</button>" . $sErrorMessage;

$html .= "<div class=\"alert alert-danger ewError\">" . $sErrorMessage . "</div>";

$_SESSION[EW_SESSION_FAILURE_MESSAGE] = ""; // Clear message in Session

}

echo "<div class=\"ewMessageDialog\"" . (($hidden) ? " style=\"display: none;\"" : "") . ">" . $html . "</div>";

}

var $PageHeader;

var $PageFooter;

// Show Page Header

function ShowPageHeader() {

$sHeader = $this->PageHeader;

$this->Page_DataRendering($sHeader);

if ($sHeader <> "") { // Header exists, display

echo "<p>" . $sHeader . "</p>";

}

}

// Show Page Footer

function ShowPageFooter() {

$sFooter = $this->PageFooter;

$this->Page_DataRendered($sFooter);

if ($sFooter <> "") { // Footer exists, display

echo "<p>" . $sFooter . "</p>";

}

}

// Validate page request

function IsPageRequest() {

global $objForm;

if ($this->UseTokenInUrl) {

if ($objForm)

return ($this->TableVar == $objForm->GetValue("t"));

if (@$_GET["t"] <> "")

return ($this->TableVar == $_GET["t"]);

} else {

return TRUE;

}

}

var $Token = "";

var $TokenTimeout = 0;

var $CheckToken = EW_CHECK_TOKEN;

var $CheckTokenFn = "ew_CheckToken";

var $CreateTokenFn = "ew_CreateToken";

// Valid Post

function ValidPost() {

if (!$this->CheckToken || !ew_IsHttpPost())

return TRUE;

if (!isset($_POST[EW_TOKEN_NAME]))

return FALSE;

$fn = $this->CheckTokenFn;

if (is_callable($fn))

return $fn($_POST[EW_TOKEN_NAME], $this->TokenTimeout);

return FALSE;

}

// Create Token

function CreateToken() {

global $gsToken;

if ($this->CheckToken) {

$fn = $this->CreateTokenFn;

if ($this->Token == "" && is_callable($fn)) // Create token

$this->Token = $fn();

$gsToken = $this->Token; // Save to global variable

}

}

//

// Page class constructor

//

function __construct() {

global $conn, $Language;

global $UserTable, $UserTableConn;

$GLOBALS["Page"] = &$this;

$this->TokenTimeout = ew_SessionTimeoutTime();

// Language object

if (!isset($Language)) $Language = new cLanguage();

// Parent constuctor

parent::__construct();

// Table object (conciliation)

if (!isset($GLOBALS["conciliation"]) || get_class($GLOBALS["conciliation"]) == "cconciliation") {

$GLOBALS["conciliation"] = &$this;

$GLOBALS["Table"] = &$GLOBALS["conciliation"];

}

$KeyUrl = "";

if (@$_GET["CONCILIATION_ID"] <> "") {

$this->RecKey["CONCILIATION_ID"] = $_GET["CONCILIATION_ID"];

$KeyUrl .= "&amp;CONCILIATION_ID=" . urlencode($this->RecKey["CONCILIATION_ID"]);

}

$this->ExportPrintUrl = $this->PageUrl() . "export=print" . $KeyUrl;

$this->ExportHtmlUrl = $this->PageUrl() . "export=html" . $KeyUrl;

$this->ExportExcelUrl = $this->PageUrl() . "export=excel" . $KeyUrl;

$this->ExportWordUrl = $this->PageUrl() . "export=word" . $KeyUrl;

$this->ExportXmlUrl = $this->PageUrl() . "export=xml" . $KeyUrl;

$this->ExportCsvUrl = $this->PageUrl() . "export=csv" . $KeyUrl;

$this->ExportPdfUrl = $this->PageUrl() . "export=pdf" . $KeyUrl;

// Table object (user)

if (!isset($GLOBALS['user'])) $GLOBALS['user'] = new cuser();

// Page ID

if (!defined("EW_PAGE_ID"))

define("EW_PAGE_ID", 'view', TRUE);

// Table name (for backward compatibility)

if (!defined("EW_TABLE_NAME"))

define("EW_TABLE_NAME", 'conciliation', TRUE);

// Start timer

if (!isset($GLOBALS["gTimer"])) $GLOBALS["gTimer"] = new cTimer();

// Open connection

if (!isset($conn)) $conn = ew_Connect($this->DBID);

// User table object (user)

if (!isset($UserTable)) {

$UserTable = new cuser();

$UserTableConn = Conn($UserTable->DBID);

}

// Export options

$this->ExportOptions = new cListOptions();

$this->ExportOptions->Tag = "div";

$this->ExportOptions->TagClassName = "ewExportOption";

// Other options

$this->OtherOptions['action'] = new cListOptions();

$this->OtherOptions['action']->Tag = "div";

$this->OtherOptions['action']->TagClassName = "ewActionOption";

$this->OtherOptions['detail'] = new cListOptions();

$this->OtherOptions['detail']->Tag = "div";

$this->OtherOptions['detail']->TagClassName = "ewDetailOption";

}

//

// Page_Init

//

function Page_Init() {

global $gsExport, $gsCustomExport, $gsExportFile, $UserProfile, $Language, $Security, $objForm;

// User profile

$UserProfile = new cUserProfile();

// Security

$Security = new cAdvancedSecurity();

if (!$Security->IsLoggedIn()) $Security->AutoLogin();

if ($Security->IsLoggedIn()) $Security->TablePermission_Loading();

$Security->LoadCurrentUserLevel($this->ProjectID . $this->TableName);

if ($Security->IsLoggedIn()) $Security->TablePermission_Loaded();

if (!$Security->CanView()) {

$Security->SaveLastUrl();

$this->setFailureMessage($Language->Phrase("NoPermission")); // Set no permission

if ($Security->CanList())

$this->Page_Terminate(ew_GetUrl("conciliationlist.php"));

else

$this->Page_Terminate(ew_GetUrl("login.php"));

}

if ($Security->IsLoggedIn()) {

$Security->UserID_Loading();

$Security->LoadUserID();

$Security->UserID_Loaded();

}

// Get export parameters

$custom = "";

if (@$_GET["export"] <> "") {

$this->Export = $_GET["export"];

$custom = @$_GET["custom"];

} elseif (@$_POST["export"] <> "") {

$this->Export = $_POST["export"];

$custom = @$_POST["custom"];

} elseif (ew_IsHttpPost()) {

if (@$_POST["exporttype"] <> "")

$this->Export = $_POST["exporttype"];

$custom = @$_POST["custom"];

} else {

$this->setExportReturnUrl(ew_CurrentUrl());

}

$gsExportFile = $this->TableVar; // Get export file, used in header

if (@$_GET["CONCILIATION_ID"] <> "") {

if ($gsExportFile <> "") $gsExportFile .= "_";

$gsExportFile .= ew_StripSlashes($_GET["CONCILIATION_ID"]);

}

// Get custom export parameters

if ($this->Export <> "" && $custom <> "") {

$this->CustomExport = $this->Export;

$this->Export = "print";

}

$gsCustomExport = $this->CustomExport;

$gsExport = $this->Export; // Get export parameter, used in header

// Update Export URLs

if (defined("EW_USE_PHPEXCEL"))

$this->ExportExcelCustom = FALSE;

if ($this->ExportExcelCustom)

$this->ExportExcelUrl .= "&amp;custom=1";

if (defined("EW_USE_PHPWORD"))

$this->ExportWordCustom = FALSE;

if ($this->ExportWordCustom)

$this->ExportWordUrl .= "&amp;custom=1";

if ($this->ExportPdfCustom)

$this->ExportPdfUrl .= "&amp;custom=1";

$this->CurrentAction = (@$_GET["a"] <> "") ? $_GET["a"] : @$_POST["a_list"]; // Set up current action

// Setup export options

$this->SetupExportOptions();

$this->CONCILIATION_ID->Visible = !$this->IsAdd() && !$this->IsCopy() && !$this->IsGridAdd();

// Global Page Loading event (in userfn*.php)

Page_Loading();

// Page Load event

$this->Page_Load();

// Check token

if (!$this->ValidPost()) {

echo $Language->Phrase("InvalidPostRequest");

$this->Page_Terminate();

exit();

}

// Create Token

$this->CreateToken();

}

//

// Page_Terminate

//

function Page_Terminate($url = "") {

global $gsExportFile, $gTmpImages;

// Page Unload event

$this->Page_Unload();

// Global Page Unloaded event (in userfn*.php)

Page_Unloaded();

// Export

global $EW_EXPORT, $conciliation;

if ($this->CustomExport <> "" && $this->CustomExport == $this->Export && array_key_exists($this->CustomExport, $EW_EXPORT)) {

$sContent = ob_get_contents();

if ($gsExportFile == "") $gsExportFile = $this->TableVar;

$class = $EW_EXPORT[$this->CustomExport];

if (class_exists($class)) {

$doc = new $class($conciliation);

$doc->Text = $sContent;

if ($this->Export == "email")

echo $this->ExportEmail($doc->Text);

else

$doc->Export();

ew_DeleteTmpImages(); // Delete temp images

exit();

}

}

$this->Page_Redirecting($url);

// Close connection

ew_CloseConn();

// Go to URL if specified

if ($url <> "") {

if (!EW_DEBUG_ENABLED && ob_get_length())

ob_end_clean();

header("Location: " . $url);

}

exit();

}

var $ExportOptions; // Export options

var $OtherOptions = array(); // Other options

var $DisplayRecs = 1;

var $DbMasterFilter;

var $DbDetailFilter;

var $StartRec;

var $StopRec;

var $TotalRecs = 0;

var $RecRange = 10;

var $RecCnt;

var $RecKey = array();

var $Recordset;

//

// Page main

//

function Page_Main() {

global $Language;

// Load current record

$bLoadCurrentRecord = FALSE;

$sReturnUrl = "";

$bMatchRecord = FALSE;

// Set up Breadcrumb

if ($this->Export == "")

$this->SetupBreadcrumb();

if ($this->IsPageRequest()) { // Validate request

if (@$_GET["CONCILIATION_ID"] <> "") {

$this->CONCILIATION_ID->setQueryStringValue($_GET["CONCILIATION_ID"]);

$this->RecKey["CONCILIATION_ID"] = $this->CONCILIATION_ID->QueryStringValue;

} elseif (@$_POST["CONCILIATION_ID"] <> "") {

$this->CONCILIATION_ID->setFormValue($_POST["CONCILIATION_ID"]);

$this->RecKey["CONCILIATION_ID"] = $this->CONCILIATION_ID->FormValue;

} else {

$sReturnUrl = "conciliationlist.php"; // Return to list

}

// Get action

$this->CurrentAction = "I"; // Display form

switch ($this->CurrentAction) {

case "I": // Get a record to display

if (!$this->LoadRow()) { // Load record based on key

if ($this->getSuccessMessage() == "" && $this->getFailureMessage() == "")

$this->setFailureMessage($Language->Phrase("NoRecord")); // Set no record message

$sReturnUrl = "conciliationlist.php"; // No matching record, return to list

}

}

// Export data only

if ($this->CustomExport == "" && in_array($this->Export, array("html","word","excel","xml","csv","email","pdf"))) {

$this->ExportData();

$this->Page_Terminate(); // Terminate response

exit();

}

} else {

$sReturnUrl = "conciliationlist.php"; // Not page request, return to list

}

if ($sReturnUrl <> "")

$this->Page_Terminate($sReturnUrl);

// Render row

$this->RowType = EW_ROWTYPE_VIEW;

$this->ResetAttrs();

$this->RenderRow();

}

// Set up other options

function SetupOtherOptions() {

global $Language, $Security;

$options = &$this->OtherOptions;

$option = &$options["action"];

// Add

$item = &$option->Add("add");

$item->Body = "<a class=\"ewAction ewAdd\" title=\"" . ew_HtmlTitle($Language->Phrase("ViewPageAddLink")) . "\" data-caption=\"" . ew_HtmlTitle($Language->Phrase("ViewPageAddLink")) . "\" href=\"" . ew_HtmlEncode($this->AddUrl) . "\">" . $Language->Phrase("ViewPageAddLink") . "</a>";

$item->Visible = ($this->AddUrl <> "" && $Security->CanAdd());

// Edit

$item = &$option->Add("edit");

$item->Body = "<a class=\"ewAction ewEdit\" title=\"" . ew_HtmlTitle($Language->Phrase("ViewPageEditLink")) . "\" data-caption=\"" . ew_HtmlTitle($Language->Phrase("ViewPageEditLink")) . "\" href=\"" . ew_HtmlEncode($this->EditUrl) . "\">" . $Language->Phrase("ViewPageEditLink") . "</a>";

$item->Visible = ($this->EditUrl <> "" && $Security->CanEdit());

// Copy

$item = &$option->Add("copy");

$item->Body = "<a class=\"ewAction ewCopy\" title=\"" . ew_HtmlTitle($Language->Phrase("ViewPageCopyLink")) . "\" data-caption=\"" . ew_HtmlTitle($Language->Phrase("ViewPageCopyLink")) . "\" href=\"" . ew_HtmlEncode($this->CopyUrl) . "\">" . $Language->Phrase("ViewPageCopyLink") . "</a>";

$item->Visible = ($this->CopyUrl <> "" && $Security->CanAdd());

// Delete

$item = &$option->Add("delete");

$item->Body = "<a class=\"ewAction ewDelete\" title=\"" . ew_HtmlTitle($Language->Phrase("ViewPageDeleteLink")) . "\" data-caption=\"" . ew_HtmlTitle($Language->Phrase("ViewPageDeleteLink")) . "\" href=\"" . ew_HtmlEncode($this->DeleteUrl) . "\">" . $Language->Phrase("ViewPageDeleteLink") . "</a>";

$item->Visible = ($this->DeleteUrl <> "" && $Security->CanDelete());

// Set up action default

$option = &$options["action"];

$option->DropDownButtonPhrase = $Language->Phrase("ButtonActions");

$option->UseImageAndText = TRUE;

$option->UseDropDownButton = FALSE;

$option->UseButtonGroup = TRUE;

$item = &$option->Add($option->GroupOptionName);

$item->Body = "";

$item->Visible = FALSE;

}

// Set up starting record parameters

function SetUpStartRec() {

if ($this->DisplayRecs == 0)

return;

if ($this->IsPageRequest()) { // Validate request

if (@$_GET[EW_TABLE_START_REC] <> "") { // Check for "start" parameter

$this->StartRec = $_GET[EW_TABLE_START_REC];

$this->setStartRecordNumber($this->StartRec);

} elseif (@$_GET[EW_TABLE_PAGE_NO] <> "") {

$PageNo = $_GET[EW_TABLE_PAGE_NO];

if (is_numeric($PageNo)) {

$this->StartRec = ($PageNo-1)*$this->DisplayRecs+1;

if ($this->StartRec <= 0) {

$this->StartRec = 1;

} elseif ($this->StartRec >= intval(($this->TotalRecs-1)/$this->DisplayRecs)*$this->DisplayRecs+1) {

$this->StartRec = intval(($this->TotalRecs-1)/$this->DisplayRecs)*$this->DisplayRecs+1;

}

$this->setStartRecordNumber($this->StartRec);

}

}

}

$this->StartRec = $this->getStartRecordNumber();

// Check if correct start record counter

if (!is_numeric($this->StartRec) || $this->StartRec == "") { // Avoid invalid start record counter

$this->StartRec = 1; // Reset start record counter

$this->setStartRecordNumber($this->StartRec);

} elseif (intval($this->StartRec) > intval($this->TotalRecs)) { // Avoid starting record > total records

$this->StartRec = intval(($this->TotalRecs-1)/$this->DisplayRecs)*$this->DisplayRecs+1; // Point to last page first record

$this->setStartRecordNumber($this->StartRec);

} elseif (($this->StartRec-1) % $this->DisplayRecs <> 0) {

$this->StartRec = intval(($this->StartRec-1)/$this->DisplayRecs)*$this->DisplayRecs+1; // Point to page boundary

$this->setStartRecordNumber($this->StartRec);

}

}

// Load recordset

function LoadRecordset($offset = -1, $rowcnt = -1) {

// Load List page SQL

$sSql = $this->SelectSQL();

$conn = &$this->Connection();

// Load recordset

$dbtype = ew_GetConnectionType($this->DBID);

if ($this->UseSelectLimit) {

$conn->raiseErrorFn = $GLOBALS["EW_ERROR_FN"];

if ($dbtype == "MSSQL") {

$rs = $conn->SelectLimit($sSql, $rowcnt, $offset, array("_hasOrderBy" => trim($this->getOrderBy()) || trim($this->getSessionOrderBy())));

} else {

$rs = $conn->SelectLimit($sSql, $rowcnt, $offset);

}

$conn->raiseErrorFn = '';

} else {

$rs = ew_LoadRecordset($sSql, $conn);

}

// Call Recordset Selected event

$this->Recordset_Selected($rs);

return $rs;

}

// Load row based on key values

function LoadRow() {

global $Security, $Language;

$sFilter = $this->KeyFilter();

// Call Row Selecting event

$this->Row_Selecting($sFilter);

// Load SQL based on filter

$this->CurrentFilter = $sFilter;

$sSql = $this->SQL();

$conn = &$this->Connection();

$res = FALSE;

$rs = ew_LoadRecordset($sSql, $conn);

if ($rs && !$rs->EOF) {

$res = TRUE;

$this->LoadRowValues($rs); // Load row values

$rs->Close();

}

return $res;

}

// Load row values from recordset

function LoadRowValues(&$rs) {

if (!$rs || $rs->EOF) return;

// Call Row Selected event

$row = &$rs->fields;

$this->Row_Selected($row);

$this->CONCILIATION_ID->setDbValue($rs->fields('CONCILIATION_ID'));

$this->UPLOAD_FILE_DETAIL_ID->setDbValue($rs->fields('UPLOAD_FILE_DETAIL_ID'));

$this->DATETIME->setDbValue($rs->fields('DATETIME'));

$this->CARD_ID->setDbValue($rs->fields('CARD_ID'));

$this->TRANSFERENCE_ID->setDbValue($rs->fields('TRANSFERENCE_ID'));

$this->PAY_TYPE_ID->setDbValue($rs->fields('PAY_TYPE_ID'));

}

// Load DbValue from recordset

function LoadDbValues(&$rs) {

if (!$rs || !is_array($rs) && $rs->EOF) return;

$row = is_array($rs) ? $rs : $rs->fields;

$this->CONCILIATION_ID->DbValue = $row['CONCILIATION_ID'];

$this->UPLOAD_FILE_DETAIL_ID->DbValue = $row['UPLOAD_FILE_DETAIL_ID'];

$this->DATETIME->DbValue = $row['DATETIME'];

$this->CARD_ID->DbValue = $row['CARD_ID'];

$this->TRANSFERENCE_ID->DbValue = $row['TRANSFERENCE_ID'];

$this->PAY_TYPE_ID->DbValue = $row['PAY_TYPE_ID'];

}

// Render row values based on field settings

function RenderRow() {

global $Security, $Language, $gsLanguage;

// Initialize URLs

$this->AddUrl = $this->GetAddUrl();

$this->EditUrl = $this->GetEditUrl();

$this->CopyUrl = $this->GetCopyUrl();

$this->DeleteUrl = $this->GetDeleteUrl();

$this->ListUrl = $this->GetListUrl();

$this->SetupOtherOptions();

// Call Row_Rendering event

$this->Row_Rendering();

// Common render codes for all row types

// CONCILIATION_ID

// UPLOAD_FILE_DETAIL_ID

// DATETIME

// CARD_ID

// TRANSFERENCE_ID

// PAY_TYPE_ID

if ($this->RowType == EW_ROWTYPE_VIEW) { // View row

// CONCILIATION_ID

$this->CONCILIATION_ID->ViewValue = $this->CONCILIATION_ID->CurrentValue;

$this->CONCILIATION_ID->ViewCustomAttributes = "";

// UPLOAD_FILE_DETAIL_ID

$this->UPLOAD_FILE_DETAIL_ID->ViewValue = $this->UPLOAD_FILE_DETAIL_ID->CurrentValue;

$this->UPLOAD_FILE_DETAIL_ID->ViewCustomAttributes = "";

// DATETIME

$this->DATETIME->ViewValue = $this->DATETIME->CurrentValue;

$this->DATETIME->ViewValue = ew_FormatDateTime($this->DATETIME->ViewValue, 7);

$this->DATETIME->ViewCustomAttributes = "";

// CARD_ID

$this->CARD_ID->ViewValue = $this->CARD_ID->CurrentValue;

$this->CARD_ID->ViewCustomAttributes = "";

// TRANSFERENCE_ID

$this->TRANSFERENCE_ID->ViewValue = $this->TRANSFERENCE_ID->CurrentValue;

$this->TRANSFERENCE_ID->ViewCustomAttributes = "";

// PAY_TYPE_ID

$this->PAY_TYPE_ID->ViewValue = $this->PAY_TYPE_ID->CurrentValue;

$this->PAY_TYPE_ID->ViewCustomAttributes = "";

// CONCILIATION_ID

$this->CONCILIATION_ID->LinkCustomAttributes = "";

$this->CONCILIATION_ID->HrefValue = "";

$this->CONCILIATION_ID->TooltipValue = "";

// UPLOAD_FILE_DETAIL_ID

$this->UPLOAD_FILE_DETAIL_ID->LinkCustomAttributes = "";

$this->UPLOAD_FILE_DETAIL_ID->HrefValue = "";

$this->UPLOAD_FILE_DETAIL_ID->TooltipValue = "";

// DATETIME

$this->DATETIME->LinkCustomAttributes = "";

$this->DATETIME->HrefValue = "";

$this->DATETIME->TooltipValue = "";

// CARD_ID

$this->CARD_ID->LinkCustomAttributes = "";

$this->CARD_ID->HrefValue = "";

$this->CARD_ID->TooltipValue = "";

// TRANSFERENCE_ID

$this->TRANSFERENCE_ID->LinkCustomAttributes = "";

$this->TRANSFERENCE_ID->HrefValue = "";

$this->TRANSFERENCE_ID->TooltipValue = "";

// PAY_TYPE_ID

$this->PAY_TYPE_ID->LinkCustomAttributes = "";

$this->PAY_TYPE_ID->HrefValue = "";

$this->PAY_TYPE_ID->TooltipValue = "";

}

// Call Row Rendered event

if ($this->RowType <> EW_ROWTYPE_AGGREGATEINIT)

$this->Row_Rendered();

}

// Set up export options

function SetupExportOptions() {

global $Language;

// Printer friendly

$item = &$this->ExportOptions->Add("print");

$item->Body = "<a href=\"" . $this->ExportPrintUrl . "\" class=\"ewExportLink ewPrint\" title=\"" . ew_HtmlEncode($Language->Phrase("PrinterFriendlyText")) . "\" data-caption=\"" . ew_HtmlEncode($Language->Phrase("PrinterFriendlyText")) . "\">" . $Language->Phrase("PrinterFriendly") . "</a>";

$item->Visible = TRUE;

// Export to Excel

$item = &$this->ExportOptions->Add("excel");

$item->Body = "<a href=\"" . $this->ExportExcelUrl . "\" class=\"ewExportLink ewExcel\" title=\"" . ew_HtmlEncode($Language->Phrase("ExportToExcelText")) . "\" data-caption=\"" . ew_HtmlEncode($Language->Phrase("ExportToExcelText")) . "\">" . $Language->Phrase("ExportToExcel") . "</a>";

$item->Visible = TRUE;

// Export to Word

$item = &$this->ExportOptions->Add("word");

$item->Body = "<a href=\"" . $this->ExportWordUrl . "\" class=\"ewExportLink ewWord\" title=\"" . ew_HtmlEncode($Language->Phrase("ExportToWordText")) . "\" data-caption=\"" . ew_HtmlEncode($Language->Phrase("ExportToWordText")) . "\">" . $Language->Phrase("ExportToWord") . "</a>";

$item->Visible = FALSE;

// Export to Html

$item = &$this->ExportOptions->Add("html");

$item->Body = "<a href=\"" . $this->ExportHtmlUrl . "\" class=\"ewExportLink ewHtml\" title=\"" . ew_HtmlEncode($Language->Phrase("ExportToHtmlText")) . "\" data-caption=\"" . ew_HtmlEncode($Language->Phrase("ExportToHtmlText")) . "\">" . $Language->Phrase("ExportToHtml") . "</a>";

$item->Visible = FALSE;

// Export to Xml

$item = &$this->ExportOptions->Add("xml");

$item->Body = "<a href=\"" . $this->ExportXmlUrl . "\" class=\"ewExportLink ewXml\" title=\"" . ew_HtmlEncode($Language->Phrase("ExportToXmlText")) . "\" data-caption=\"" . ew_HtmlEncode($Language->Phrase("ExportToXmlText")) . "\">" . $Language->Phrase("ExportToXml") . "</a>";

$item->Visible = FALSE;

// Export to Csv

$item = &$this->ExportOptions->Add("csv");

$item->Body = "<a href=\"" . $this->ExportCsvUrl . "\" class=\"ewExportLink ewCsv\" title=\"" . ew_HtmlEncode($Language->Phrase("ExportToCsvText")) . "\" data-caption=\"" . ew_HtmlEncode($Language->Phrase("ExportToCsvText")) . "\">" . $Language->Phrase("ExportToCsv") . "</a>";

$item->Visible = FALSE;

// Export to Pdf

$item = &$this->ExportOptions->Add("pdf");

$item->Body = "<a href=\"" . $this->ExportPdfUrl . "\" class=\"ewExportLink ewPdf\" title=\"" . ew_HtmlEncode($Language->Phrase("ExportToPDFText")) . "\" data-caption=\"" . ew_HtmlEncode($Language->Phrase("ExportToPDFText")) . "\">" . $Language->Phrase("ExportToPDF") . "</a>";

$item->Visible = TRUE;

// Export to Email

$item = &$this->ExportOptions->Add("email");

$url = "";

$item->Body = "<button id=\"emf_conciliation\" class=\"ewExportLink ewEmail\" title=\"" . $Language->Phrase("ExportToEmailText") . "\" data-caption=\"" . $Language->Phrase("ExportToEmailText") . "\" onclick=\"ew_EmailDialogShow({lnk:'emf_conciliation',hdr:ewLanguage.Phrase('ExportToEmailText'),f:document.fconciliationview,key:" . ew_ArrayToJsonAttr($this->RecKey) . ",sel:false" . $url . "});\">" . $Language->Phrase("ExportToEmail") . "</button>";

$item->Visible = FALSE;

// Drop down button for export

$this->ExportOptions->UseButtonGroup = TRUE;

$this->ExportOptions->UseImageAndText = TRUE;

$this->ExportOptions->UseDropDownButton = FALSE;

if ($this->ExportOptions->UseButtonGroup && ew_IsMobile())

$this->ExportOptions->UseDropDownButton = TRUE;

$this->ExportOptions->DropDownButtonPhrase = $Language->Phrase("ButtonExport");

// Add group option item

$item = &$this->ExportOptions->Add($this->ExportOptions->GroupOptionName);

$item->Body = "";

$item->Visible = FALSE;

// Hide options for export

if ($this->Export <> "")

$this->ExportOptions->HideAllOptions();

}

// Export data in HTML/CSV/Word/Excel/XML/Email/PDF format

function ExportData() {

$utf8 = (strtolower(EW_CHARSET) == "utf-8");

$bSelectLimit = FALSE;

// Load recordset

if ($bSelectLimit) {

$this->TotalRecs = $this->SelectRecordCount();

} else {

if (!$this->Recordset)

$this->Recordset = $this->LoadRecordset();

$rs = &$this->Recordset;

if ($rs)

$this->TotalRecs = $rs->RecordCount();

}

$this->StartRec = 1;

$this->SetUpStartRec(); // Set up start record position

// Set the last record to display

if ($this->DisplayRecs <= 0) {

$this->StopRec = $this->TotalRecs;

} else {

$this->StopRec = $this->StartRec + $this->DisplayRecs - 1;

}

if (!$rs) {

header("Content-Type:"); // Remove header

header("Content-Disposition:");

$this->ShowMessage();

return;

}

$this->ExportDoc = ew_ExportDocument($this, "v");

$Doc = &$this->ExportDoc;

if ($bSelectLimit) {

$this->StartRec = 1;

$this->StopRec = $this->DisplayRecs <= 0 ? $this->TotalRecs : $this->DisplayRecs;

} else {

//$this->StartRec = $this->StartRec;

//$this->StopRec = $this->StopRec;

}

// Call Page Exporting server event

$this->ExportDoc->ExportCustom = !$this->Page_Exporting();

$ParentTable = "";

$sHeader = $this->PageHeader;

$this->Page_DataRendering($sHeader);

$Doc->Text .= $sHeader;

$this->ExportDocument($Doc, $rs, $this->StartRec, $this->StopRec, "view");

$sFooter = $this->PageFooter;

$this->Page_DataRendered($sFooter);

$Doc->Text .= $sFooter;

// Close recordset

$rs->Close();

// Call Page Exported server event

$this->Page_Exported();

// Export header and footer

$Doc->ExportHeaderAndFooter();

// Clean output buffer

if (!EW_DEBUG_ENABLED && ob_get_length())

ob_end_clean();

// Write debug message if enabled

if (EW_DEBUG_ENABLED && $this->Export <> "pdf")

echo ew_DebugMsg();

// Output data

$Doc->Export();

}

// Set up Breadcrumb

function SetupBreadcrumb() {

global $Breadcrumb, $Language;

$Breadcrumb = new cBreadcrumb();

$url = substr(ew_CurrentUrl(), strrpos(ew_CurrentUrl(), "/")+1);

$Breadcrumb->Add("list", $this->TableVar, $this->AddMasterUrl("conciliationlist.php"), "", $this->TableVar, TRUE);

$PageId = "view";

$Breadcrumb->Add("view", $PageId, $url);

}

// 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

// $type = ''|'success'|'failure'|'warning'

function Message_Showing(&$msg, $type) {

if ($type == 'success') {

//$msg = "your success message";

} elseif ($type == 'failure') {

//$msg = "your failure message";

} elseif ($type == 'warning') {

//$msg = "your warning message";

} else {

//$msg = "your message";

}

}

// Page Render event

function Page_Render() {

//echo "Page Render";

}

// Page Data Rendering event

function Page_DataRendering(&$header) {

// Example:

//$header = "your header";

}

// Page Data Rendered event

function Page_DataRendered(&$footer) {

// Example:

//$footer = "your footer";

}

// Page Exporting event

// $this->ExportDoc = export document object

function Page_Exporting() {

//$this->ExportDoc->Text = "my header"; // Export header

//return FALSE; // Return FALSE to skip default export and use Row_Export event

return TRUE; // Return TRUE to use default export and skip Row_Export event

}

// Row Export event

// $this->ExportDoc = export document object

function Row_Export($rs) {

//$this->ExportDoc->Text .= "my content"; // Build HTML with field value: $rs["MyField"] or $this->MyField->ViewValue

}

// Page Exported event

// $this->ExportDoc = export document object

function Page_Exported() {

//$this->ExportDoc->Text .= "my footer"; // Export footer

//echo $this->ExportDoc->Text;

}