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 = FALSE; $html = ""; // Message $sMessage = $this->getMessage(); if (method_exists($this, "Message_Showing")) $this->Message_Showing($sMessage, ""); if ($sMessage <> "") { // Message in Session, display if (!$hidden) $sMessage = "" . $sMessage; $html .= "
" . $sMessage . "
"; $_SESSION[EW_SESSION_MESSAGE] = ""; // Clear message in Session } // Warning message $sWarningMessage = $this->getWarningMessage(); if (method_exists($this, "Message_Showing")) $this->Message_Showing($sWarningMessage, "warning"); if ($sWarningMessage <> "") { // Message in Session, display if (!$hidden) $sWarningMessage = "" . $sWarningMessage; $html .= "
" . $sWarningMessage . "
"; $_SESSION[EW_SESSION_WARNING_MESSAGE] = ""; // Clear message in Session } // Success message $sSuccessMessage = $this->getSuccessMessage(); if (method_exists($this, "Message_Showing")) $this->Message_Showing($sSuccessMessage, "success"); if ($sSuccessMessage <> "") { // Message in Session, display if (!$hidden) $sSuccessMessage = "" . $sSuccessMessage; $html .= "
" . $sSuccessMessage . "
"; $_SESSION[EW_SESSION_SUCCESS_MESSAGE] = ""; // Clear message in Session } // Failure message $sErrorMessage = $this->getFailureMessage(); if (method_exists($this, "Message_Showing")) $this->Message_Showing($sErrorMessage, "failure"); if ($sErrorMessage <> "") { // Message in Session, display if (!$hidden) $sErrorMessage = "" . $sErrorMessage; $html .= "
" . $sErrorMessage . "
"; $_SESSION[EW_SESSION_FAILURE_MESSAGE] = ""; // Clear message in Session } echo "
" . $html . "
"; } var $PageHeader; var $PageFooter; // Show Page Header function ShowPageHeader() { $sHeader = $this->PageHeader; $this->Page_DataRendering($sHeader); if ($sHeader <> "") { // Header exists, display echo "

" . $sHeader . "

"; } } // Show Page Footer function ShowPageFooter() { $sFooter = $this->PageFooter; $this->Page_DataRendered($sFooter); if ($sFooter <> "") { // Footer exists, display echo "

" . $sFooter . "

"; } } // 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 (taccomodations) if (!isset($GLOBALS["taccomodations"]) || get_class($GLOBALS["taccomodations"]) == "ctaccomodations") { $GLOBALS["taccomodations"] = &$this; $GLOBALS["Table"] = &$GLOBALS["taccomodations"]; } $KeyUrl = ""; if (@$_GET["idAccomodation"] <> "") { $this->RecKey["idAccomodation"] = $_GET["idAccomodation"]; $KeyUrl .= "&idAccomodation=" . urlencode($this->RecKey["idAccomodation"]); } $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 (tofferers) if (!isset($GLOBALS['tofferers'])) $GLOBALS['tofferers'] = new ctofferers(); // Table object (users) if (!isset($GLOBALS['users'])) $GLOBALS['users'] = new cusers(); // 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", 'taccomodations', TRUE); // Start timer if (!isset($GLOBALS["gTimer"])) $GLOBALS["gTimer"] = new cTimer(); // Open connection if (!isset($conn)) $conn = ew_Connect($this->DBID); // User table object (users) if (!isset($UserTable)) { $UserTable = new cusers(); $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; // 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(ew_DeniedMsg()); // Set no permission if ($Security->CanList()) $this->Page_Terminate(ew_GetUrl("taccomodationslist.php")); else $this->Page_Terminate(ew_GetUrl("login.php")); } // 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["idAccomodation"] <> "") { if ($gsExportFile <> "") $gsExportFile .= "_"; $gsExportFile .= ew_StripSlashes($_GET["idAccomodation"]); } // 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 .= "&custom=1"; if (defined("EW_USE_PHPWORD")) $this->ExportWordCustom = FALSE; if ($this->ExportWordCustom) $this->ExportWordUrl .= "&custom=1"; if ($this->ExportPdfCustom) $this->ExportPdfUrl .= "&custom=1"; $this->CurrentAction = (@$_GET["a"] <> "") ? $_GET["a"] : @$_POST["a_list"]; // Set up current action // Setup export options $this->SetupExportOptions(); $this->idAccomodation->SetVisibility(); $this->idAccomodation->Visible = !$this->IsAdd() && !$this->IsCopy() && !$this->IsGridAdd(); $this->idOfferer->SetVisibility(); $this->Accom_Type->SetVisibility(); $this->Address->SetVisibility(); $this->Town->SetVisibility(); $this->District->SetVisibility(); $this->Region->SetVisibility(); $this->Beds->SetVisibility(); $this->Rooms->SetVisibility(); $this->Bathrooms->SetVisibility(); $this->Private_Kitchen->SetVisibility(); $this->Auton_heating->SetVisibility(); $this->Arch_barriers->SetVisibility(); $this->Furnisched->SetVisibility(); $this->Private_entrance->SetVisibility(); $this->Time_restrictions->SetVisibility(); $this->Time_restr_from->SetVisibility(); $this->Time_restr_to->SetVisibility(); $this->Services_access->SetVisibility(); $this->Available_from->SetVisibility(); $this->Available_to->SetVisibility(); $this->Rel_type->SetVisibility(); $this->offer_woman->SetVisibility(); $this->offer_children->SetVisibility(); $this->offer_family->SetVisibility(); $this->offer_man->SetVisibility(); $this->offer_elderly->SetVisibility(); $this->offer_disabled->SetVisibility(); $this->offer_sick->SetVisibility(); $this->offer_christian->SetVisibility(); $this->offer_muslim->SetVisibility(); $this->offer_other->SetVisibility(); $this->verify_date->SetVisibility(); $this->verify_by->SetVisibility(); $this->verify_phone->SetVisibility(); $this->verify_email->SetVisibility(); $this->Outcome->SetVisibility(); $this->Outcome_type->SetVisibility(); $this->Rel_doc->SetVisibility(); // 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, $taccomodations; 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($taccomodations); $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(); // Handle modal response if ($this->IsModal) { $row = array(); $row["url"] = $url; echo ew_ArrayToJson(array($row)); } else { 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 $Pager; var $RecCnt; var $RecKey = array(); var $IsModal = FALSE; var $tassigment_Count; var $Recordset; // // Page main // function Page_Main() { global $Language; global $gbSkipHeaderFooter; // Check modal $this->IsModal = (@$_GET["modal"] == "1" || @$_POST["modal"] == "1"); if ($this->IsModal) $gbSkipHeaderFooter = TRUE; // Load current record $bLoadCurrentRecord = FALSE; $sReturnUrl = ""; $bMatchRecord = FALSE; // Set up master/detail parameters $this->SetUpMasterParms(); if ($this->IsPageRequest()) { // Validate request if (@$_GET["idAccomodation"] <> "") { $this->idAccomodation->setQueryStringValue($_GET["idAccomodation"]); $this->RecKey["idAccomodation"] = $this->idAccomodation->QueryStringValue; } elseif (@$_POST["idAccomodation"] <> "") { $this->idAccomodation->setFormValue($_POST["idAccomodation"]); $this->RecKey["idAccomodation"] = $this->idAccomodation->FormValue; } else { $bLoadCurrentRecord = TRUE; } // Get action $this->CurrentAction = "I"; // Display form switch ($this->CurrentAction) { case "I": // Get a record to display $this->StartRec = 1; // Initialize start position if ($this->Recordset = $this->LoadRecordset()) // Load records $this->TotalRecs = $this->Recordset->RecordCount(); // Get record count if ($this->TotalRecs <= 0) { // No record found if ($this->getSuccessMessage() == "" && $this->getFailureMessage() == "") $this->setFailureMessage($Language->Phrase("NoRecord")); // Set no record message $this->Page_Terminate("taccomodationslist.php"); // Return to list page } elseif ($bLoadCurrentRecord) { // Load current record position $this->SetUpStartRec(); // Set up start record position // Point to current record if (intval($this->StartRec) <= intval($this->TotalRecs)) { $bMatchRecord = TRUE; $this->Recordset->Move($this->StartRec-1); } } else { // Match key values while (!$this->Recordset->EOF) { if (strval($this->idAccomodation->CurrentValue) == strval($this->Recordset->fields('idAccomodation'))) { $this->setStartRecordNumber($this->StartRec); // Save record position $bMatchRecord = TRUE; break; } else { $this->StartRec++; $this->Recordset->MoveNext(); } } } if (!$bMatchRecord) { if ($this->getSuccessMessage() == "" && $this->getFailureMessage() == "") $this->setFailureMessage($Language->Phrase("NoRecord")); // Set no record message $sReturnUrl = "taccomodationslist.php"; // No matching record, return to list } else { $this->LoadRowValues($this->Recordset); // Load row values } } // 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 = "taccomodationslist.php"; // Not page request, return to list } if ($sReturnUrl <> "") $this->Page_Terminate($sReturnUrl); // Set up Breadcrumb if ($this->Export == "") $this->SetupBreadcrumb(); // Render row $this->RowType = EW_ROWTYPE_VIEW; $this->ResetAttrs(); $this->RenderRow(); // Set up detail parameters $this->SetUpDetailParms(); } // Set up other options function SetupOtherOptions() { global $Language, $Security; $options = &$this->OtherOptions; $option = &$options["action"]; // Add $item = &$option->Add("add"); $addcaption = ew_HtmlTitle($Language->Phrase("ViewPageAddLink")); if ($this->IsModal) // Modal $item->Body = "AddUrl) . "',caption:'" . $addcaption . "'});\">" . $Language->Phrase("ViewPageAddLink") . ""; else $item->Body = "AddUrl) . "\">" . $Language->Phrase("ViewPageAddLink") . ""; $item->Visible = ($this->AddUrl <> "" && $Security->CanAdd()); // Edit $item = &$option->Add("edit"); $editcaption = ew_HtmlTitle($Language->Phrase("ViewPageEditLink")); if ($this->IsModal) // Modal $item->Body = "EditUrl) . "',caption:'" . $editcaption . "'});\">" . $Language->Phrase("ViewPageEditLink") . ""; else $item->Body = "EditUrl) . "\">" . $Language->Phrase("ViewPageEditLink") . ""; $item->Visible = ($this->EditUrl <> "" && $Security->CanEdit()); // Delete $item = &$option->Add("delete"); if ($this->IsModal) // Handle as inline delete $item->Body = "Phrase("ViewPageDeleteLink")) . "\" data-caption=\"" . ew_HtmlTitle($Language->Phrase("ViewPageDeleteLink")) . "\" href=\"" . ew_HtmlEncode(ew_AddQueryStringToUrl($this->DeleteUrl, "a_delete=1")) . "\">" . $Language->Phrase("ViewPageDeleteLink") . ""; else $item->Body = "Phrase("ViewPageDeleteLink")) . "\" data-caption=\"" . ew_HtmlTitle($Language->Phrase("ViewPageDeleteLink")) . "\" href=\"" . ew_HtmlEncode($this->DeleteUrl) . "\">" . $Language->Phrase("ViewPageDeleteLink") . ""; $item->Visible = ($this->DeleteUrl <> "" && $Security->CanDelete()); $option = &$options["detail"]; $DetailTableLink = ""; $DetailViewTblVar = ""; $DetailCopyTblVar = ""; $DetailEditTblVar = ""; // "detail_tassigment" $item = &$option->Add("detail_tassigment"); $body = $Language->Phrase("ViewPageDetailLink") . $Language->TablePhrase("tassigment", "TblCaption"); $body .= str_replace("%c", $this->tassigment_Count, $Language->Phrase("DetailCount")); $body = "idAccomodation->CurrentValue)) . "") . "\">" . $body . ""; $links = ""; if ($GLOBALS["tassigment_grid"] && $GLOBALS["tassigment_grid"]->DetailView && $Security->CanView() && $Security->AllowView(CurrentProjectID() . 'tassigment')) { $links .= "
  • Phrase("MasterDetailViewLink")) . "\" href=\"" . ew_HtmlEncode($this->GetViewUrl(EW_TABLE_SHOW_DETAIL . "=tassigment")) . "\">" . ew_HtmlImageAndText($Language->Phrase("MasterDetailViewLink")) . "
    • "; if ($DetailViewTblVar <> "") $DetailViewTblVar .= ","; $DetailViewTblVar .= "tassigment"; } if ($GLOBALS["tassigment_grid"] && $GLOBALS["tassigment_grid"]->DetailEdit && $Security->CanEdit() && $Security->AllowEdit(CurrentProjectID() . 'tassigment')) { $links .= "
  • Phrase("MasterDetailEditLink")) . "\" href=\"" . ew_HtmlEncode($this->GetEditUrl(EW_TABLE_SHOW_DETAIL . "=tassigment")) . "\">" . ew_HtmlImageAndText($Language->Phrase("MasterDetailEditLink")) . "
    • "; if ($DetailEditTblVar <> "") $DetailEditTblVar .= ","; $DetailEditTblVar .= "tassigment"; } if ($links <> "") { $body .= ""; $body .= ""; } $body = "
    " . $body . "
    "; $item->Body = $body; $item->Visible = $Security->AllowList(CurrentProjectID() . 'tassigment'); if ($item->Visible) { if ($DetailTableLink <> "") $DetailTableLink .= ","; $DetailTableLink .= "tassigment"; } if ($this->ShowMultipleDetails) $item->Visible = FALSE; // Multiple details if ($this->ShowMultipleDetails) { $body = $Language->Phrase("MultipleMasterDetails"); $body = "
    "; $links = ""; if ($DetailViewTblVar <> "") { $links .= "
  • Phrase("MasterDetailViewLink")) . "\" href=\"" . ew_HtmlEncode($this->GetViewUrl(EW_TABLE_SHOW_DETAIL . "=" . $DetailViewTblVar)) . "\">" . ew_HtmlImageAndText($Language->Phrase("MasterDetailViewLink")) . "
    • "; } if ($DetailEditTblVar <> "") { $links .= "
  • Phrase("MasterDetailEditLink")) . "\" href=\"" . ew_HtmlEncode($this->GetEditUrl(EW_TABLE_SHOW_DETAIL . "=" . $DetailEditTblVar)) . "\">" . ew_HtmlImageAndText($Language->Phrase("MasterDetailEditLink")) . "
    • "; } if ($DetailCopyTblVar <> "") { $links .= "
  • Phrase("MasterDetailCopyLink")) . "\" href=\"" . ew_HtmlEncode($this->GetCopyUrl(EW_TABLE_SHOW_DETAIL . "=" . $DetailCopyTblVar)) . "\">" . ew_HtmlImageAndText($Language->Phrase("MasterDetailCopyLink")) . "
    • "; } if ($links <> "") { $body .= ""; $body .= ""; } $body .= "
    "; // Multiple details $oListOpt = &$option->Add("details"); $oListOpt->Body = $body; } // Set up detail default $option = &$options["detail"]; $options["detail"]->DropDownButtonPhrase = $Language->Phrase("ButtonDetails"); $option->UseImageAndText = TRUE; $ar = explode(",", $DetailTableLink); $cnt = count($ar); $option->UseDropDownButton = ($cnt > 1); $option->UseButtonGroup = TRUE; $item = &$option->Add($option->GroupOptionName); $item->Body = ""; $item->Visible = FALSE; // 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->idAccomodation->setDbValue($rs->fields('idAccomodation')); $this->idOfferer->setDbValue($rs->fields('idOfferer')); $this->Accom_Type->setDbValue($rs->fields('Accom_Type')); $this->Address->setDbValue($rs->fields('Address')); $this->Town->setDbValue($rs->fields('Town')); $this->District->setDbValue($rs->fields('District')); $this->Region->setDbValue($rs->fields('Region')); $this->Beds->setDbValue($rs->fields('Beds')); $this->Rooms->setDbValue($rs->fields('Rooms')); $this->Bathrooms->setDbValue($rs->fields('Bathrooms')); $this->Private_Kitchen->setDbValue($rs->fields('Private_Kitchen')); $this->Auton_heating->setDbValue($rs->fields('Auton_heating')); $this->Arch_barriers->setDbValue($rs->fields('Arch_barriers')); $this->Furnisched->setDbValue($rs->fields('Furnisched')); $this->Private_entrance->setDbValue($rs->fields('Private_entrance')); $this->Time_restrictions->setDbValue($rs->fields('Time_restrictions')); $this->Time_restr_from->setDbValue($rs->fields('Time_restr_from')); $this->Time_restr_to->setDbValue($rs->fields('Time_restr_to')); $this->Services_access->setDbValue($rs->fields('Services_access')); $this->Available_from->setDbValue($rs->fields('Available_from')); $this->Available_to->setDbValue($rs->fields('Available_to')); $this->Rel_type->setDbValue($rs->fields('Rel_type')); $this->offer_woman->setDbValue($rs->fields('offer_woman')); $this->offer_children->setDbValue($rs->fields('offer_children')); $this->offer_family->setDbValue($rs->fields('offer_family')); $this->offer_man->setDbValue($rs->fields('offer_man')); $this->offer_elderly->setDbValue($rs->fields('offer_elderly')); $this->offer_disabled->setDbValue($rs->fields('offer_disabled')); $this->offer_sick->setDbValue($rs->fields('offer_sick')); $this->offer_christian->setDbValue($rs->fields('offer_christian')); $this->offer_muslim->setDbValue($rs->fields('offer_muslim')); $this->offer_other->setDbValue($rs->fields('offer_other')); $this->verify_date->setDbValue($rs->fields('verify_date')); $this->verify_by->setDbValue($rs->fields('verify_by')); $this->verify_phone->setDbValue($rs->fields('verify_phone')); $this->verify_email->setDbValue($rs->fields('verify_email')); $this->Outcome->setDbValue($rs->fields('Outcome')); $this->Outcome_type->setDbValue($rs->fields('Outcome_type')); $this->Rel_doc->Upload->DbValue = $rs->fields('Rel_doc'); $this->Rel_doc->CurrentValue = $this->Rel_doc->Upload->DbValue; $this->Rel_doc_type->setDbValue($rs->fields('Rel_doc_type')); $this->Rel_doc_size->setDbValue($rs->fields('Rel_doc_size')); if (!isset($GLOBALS["tassigment_grid"])) $GLOBALS["tassigment_grid"] = new ctassigment_grid; $sDetailFilter = $GLOBALS["tassigment"]->SqlDetailFilter_taccomodations(); $sDetailFilter = str_replace("@idkAccomodation@", ew_AdjustSql($this->idAccomodation->DbValue, "DB"), $sDetailFilter); $GLOBALS["tassigment"]->setCurrentMasterTable("taccomodations"); $sDetailFilter = $GLOBALS["tassigment"]->ApplyUserIDFilters($sDetailFilter); $this->tassigment_Count = $GLOBALS["tassigment"]->LoadRecordCount($sDetailFilter); } // Load DbValue from recordset function LoadDbValues(&$rs) { if (!$rs || !is_array($rs) && $rs->EOF) return; $row = is_array($rs) ? $rs : $rs->fields; $this->idAccomodation->DbValue = $row['idAccomodation']; $this->idOfferer->DbValue = $row['idOfferer']; $this->Accom_Type->DbValue = $row['Accom_Type']; $this->Address->DbValue = $row['Address']; $this->Town->DbValue = $row['Town']; $this->District->DbValue = $row['District']; $this->Region->DbValue = $row['Region']; $this->Beds->DbValue = $row['Beds']; $this->Rooms->DbValue = $row['Rooms']; $this->Bathrooms->DbValue = $row['Bathrooms']; $this->Private_Kitchen->DbValue = $row['Private_Kitchen']; $this->Auton_heating->DbValue = $row['Auton_heating']; $this->Arch_barriers->DbValue = $row['Arch_barriers']; $this->Furnisched->DbValue = $row['Furnisched']; $this->Private_entrance->DbValue = $row['Private_entrance']; $this->Time_restrictions->DbValue = $row['Time_restrictions']; $this->Time_restr_from->DbValue = $row['Time_restr_from']; $this->Time_restr_to->DbValue = $row['Time_restr_to']; $this->Services_access->DbValue = $row['Services_access']; $this->Available_from->DbValue = $row['Available_from']; $this->Available_to->DbValue = $row['Available_to']; $this->Rel_type->DbValue = $row['Rel_type']; $this->offer_woman->DbValue = $row['offer_woman']; $this->offer_children->DbValue = $row['offer_children']; $this->offer_family->DbValue = $row['offer_family']; $this->offer_man->DbValue = $row['offer_man']; $this->offer_elderly->DbValue = $row['offer_elderly']; $this->offer_disabled->DbValue = $row['offer_disabled']; $this->offer_sick->DbValue = $row['offer_sick']; $this->offer_christian->DbValue = $row['offer_christian']; $this->offer_muslim->DbValue = $row['offer_muslim']; $this->offer_other->DbValue = $row['offer_other']; $this->verify_date->DbValue = $row['verify_date']; $this->verify_by->DbValue = $row['verify_by']; $this->verify_phone->DbValue = $row['verify_phone']; $this->verify_email->DbValue = $row['verify_email']; $this->Outcome->DbValue = $row['Outcome']; $this->Outcome_type->DbValue = $row['Outcome_type']; $this->Rel_doc->Upload->DbValue = $row['Rel_doc']; $this->Rel_doc_type->DbValue = $row['Rel_doc_type']; $this->Rel_doc_size->DbValue = $row['Rel_doc_size']; } // 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 // idAccomodation // idOfferer // Accom_Type // Address // Town // District // Region // Beds // Rooms // Bathrooms // Private_Kitchen // Auton_heating // Arch_barriers // Furnisched // Private_entrance // Time_restrictions // Time_restr_from // Time_restr_to // Services_access // Available_from // Available_to // Rel_type // offer_woman // offer_children // offer_family // offer_man // offer_elderly // offer_disabled // offer_sick // offer_christian // offer_muslim // offer_other // verify_date // verify_by // verify_phone // verify_email // Outcome // Outcome_type // Rel_doc // Rel_doc_type // Rel_doc_size if ($this->RowType == EW_ROWTYPE_VIEW) { // View row // idAccomodation $this->idAccomodation->ViewValue = $this->idAccomodation->CurrentValue; $this->idAccomodation->ViewCustomAttributes = ""; // idOfferer $this->idOfferer->ViewValue = $this->idOfferer->CurrentValue; if (strval($this->idOfferer->CurrentValue) <> "") { $sFilterWrk = "`idOfferer`" . ew_SearchString("=", $this->idOfferer->CurrentValue, EW_DATATYPE_NUMBER, ""); switch (@$gsLanguage) { case "en": $sSqlWrk = "SELECT `idOfferer`, `Name` AS `DispFld`, `Surname` AS `Disp2Fld`, `Institution_Name` AS `Disp3Fld`, '' AS `Disp4Fld` FROM `tofferers`"; $sWhereWrk = ""; $this->idOfferer->LookupFilters = array(); break; case "it": $sSqlWrk = "SELECT `idOfferer`, `Name` AS `DispFld`, `Surname` AS `Disp2Fld`, `Institution_Name` AS `Disp3Fld`, '' AS `Disp4Fld` FROM `tofferers`"; $sWhereWrk = ""; $this->idOfferer->LookupFilters = array(); break; default: $sSqlWrk = "SELECT `idOfferer`, `Name` AS `DispFld`, `Surname` AS `Disp2Fld`, `Institution_Name` AS `Disp3Fld`, '' AS `Disp4Fld` FROM `tofferers`"; $sWhereWrk = ""; $this->idOfferer->LookupFilters = array(); break; } ew_AddFilter($sWhereWrk, $sFilterWrk); $this->Lookup_Selecting($this->idOfferer, $sWhereWrk); // Call Lookup selecting if ($sWhereWrk <> "") $sSqlWrk .= " WHERE " . $sWhereWrk; $rswrk = Conn()->Execute($sSqlWrk); if ($rswrk && !$rswrk->EOF) { // Lookup values found $arwrk = array(); $arwrk[1] = $rswrk->fields('DispFld'); $arwrk[2] = $rswrk->fields('Disp2Fld'); $arwrk[3] = $rswrk->fields('Disp3Fld'); $this->idOfferer->ViewValue = $this->idOfferer->DisplayValue($arwrk); $rswrk->Close(); } else { $this->idOfferer->ViewValue = $this->idOfferer->CurrentValue; } } else { $this->idOfferer->ViewValue = NULL; } $this->idOfferer->ViewCustomAttributes = ""; // Accom_Type if (strval($this->Accom_Type->CurrentValue) <> "") { $sFilterWrk = "`Accom_Type`" . ew_SearchString("=", $this->Accom_Type->CurrentValue, EW_DATATYPE_STRING, ""); switch (@$gsLanguage) { case "en": $sSqlWrk = "SELECT `Accom_Type`, `Description` AS `DispFld`, '' AS `Disp2Fld`, '' AS `Disp3Fld`, '' AS `Disp4Fld` FROM `taccom_type`"; $sWhereWrk = ""; $this->Accom_Type->LookupFilters = array(); break; case "it": $sSqlWrk = "SELECT `Accom_Type`, `Description_IT` AS `DispFld`, '' AS `Disp2Fld`, '' AS `Disp3Fld`, '' AS `Disp4Fld` FROM `taccom_type`"; $sWhereWrk = ""; $this->Accom_Type->LookupFilters = array(); break; default: $sSqlWrk = "SELECT `Accom_Type`, `Description` AS `DispFld`, '' AS `Disp2Fld`, '' AS `Disp3Fld`, '' AS `Disp4Fld` FROM `taccom_type`"; $sWhereWrk = ""; $this->Accom_Type->LookupFilters = array(); break; } ew_AddFilter($sWhereWrk, $sFilterWrk); $this->Lookup_Selecting($this->Accom_Type, $sWhereWrk); // Call Lookup selecting if ($sWhereWrk <> "") $sSqlWrk .= " WHERE " . $sWhereWrk; $rswrk = Conn()->Execute($sSqlWrk); if ($rswrk && !$rswrk->EOF) { // Lookup values found $arwrk = array(); $arwrk[1] = $rswrk->fields('DispFld'); $this->Accom_Type->ViewValue = $this->Accom_Type->DisplayValue($arwrk); $rswrk->Close(); } else { $this->Accom_Type->ViewValue = $this->Accom_Type->CurrentValue; } } else { $this->Accom_Type->ViewValue = NULL; } $this->Accom_Type->ViewCustomAttributes = ""; // Address $this->Address->ViewValue = $this->Address->CurrentValue; $this->Address->ViewCustomAttributes = ""; // Town $this->Town->ViewValue = $this->Town->CurrentValue; $this->Town->ViewCustomAttributes = ""; // District $this->District->ViewValue = $this->District->CurrentValue; $this->District->ViewCustomAttributes = ""; // Region $this->Region->ViewValue = $this->Region->CurrentValue; $this->Region->ViewCustomAttributes = ""; // Beds $this->Beds->ViewValue = $this->Beds->CurrentValue; $this->Beds->ViewCustomAttributes = ""; // Rooms $this->Rooms->ViewValue = $this->Rooms->CurrentValue; $this->Rooms->ViewCustomAttributes = ""; // Bathrooms $this->Bathrooms->ViewValue = $this->Bathrooms->CurrentValue; $this->Bathrooms->ViewCustomAttributes = ""; // Private_Kitchen if (ew_ConvertToBool($this->Private_Kitchen->CurrentValue)) { $this->Private_Kitchen->ViewValue = $this->Private_Kitchen->FldTagCaption(1) <> "" ? $this->Private_Kitchen->FldTagCaption(1) : "Y"; } else { $this->Private_Kitchen->ViewValue = $this->Private_Kitchen->FldTagCaption(2) <> "" ? $this->Private_Kitchen->FldTagCaption(2) : "N"; } $this->Private_Kitchen->ViewCustomAttributes = ""; // Auton_heating if (ew_ConvertToBool($this->Auton_heating->CurrentValue)) { $this->Auton_heating->ViewValue = $this->Auton_heating->FldTagCaption(1) <> "" ? $this->Auton_heating->FldTagCaption(1) : "Y"; } else { $this->Auton_heating->ViewValue = $this->Auton_heating->FldTagCaption(2) <> "" ? $this->Auton_heating->FldTagCaption(2) : "N"; } $this->Auton_heating->ViewCustomAttributes = ""; // Arch_barriers if (ew_ConvertToBool($this->Arch_barriers->CurrentValue)) { $this->Arch_barriers->ViewValue = $this->Arch_barriers->FldTagCaption(1) <> "" ? $this->Arch_barriers->FldTagCaption(1) : "Y"; } else { $this->Arch_barriers->ViewValue = $this->Arch_barriers->FldTagCaption(2) <> "" ? $this->Arch_barriers->FldTagCaption(2) : "N"; } $this->Arch_barriers->ViewCustomAttributes = ""; // Furnisched if (ew_ConvertToBool($this->Furnisched->CurrentValue)) { $this->Furnisched->ViewValue = $this->Furnisched->FldTagCaption(1) <> "" ? $this->Furnisched->FldTagCaption(1) : "Y"; } else { $this->Furnisched->ViewValue = $this->Furnisched->FldTagCaption(2) <> "" ? $this->Furnisched->FldTagCaption(2) : "N"; } $this->Furnisched->ViewCustomAttributes = ""; // Private_entrance if (ew_ConvertToBool($this->Private_entrance->CurrentValue)) { $this->Private_entrance->ViewValue = $this->Private_entrance->FldTagCaption(1) <> "" ? $this->Private_entrance->FldTagCaption(1) : "Y"; } else { $this->Private_entrance->ViewValue = $this->Private_entrance->FldTagCaption(2) <> "" ? $this->Private_entrance->FldTagCaption(2) : "N"; } $this->Private_entrance->ViewCustomAttributes = ""; // Time_restrictions if (ew_ConvertToBool($this->Time_restrictions->CurrentValue)) { $this->Time_restrictions->ViewValue = $this->Time_restrictions->FldTagCaption(1) <> "" ? $this->Time_restrictions->FldTagCaption(1) : "Y"; } else { $this->Time_restrictions->ViewValue = $this->Time_restrictions->FldTagCaption(2) <> "" ? $this->Time_restrictions->FldTagCaption(2) : "N"; } $this->Time_restrictions->ViewCustomAttributes = ""; // Time_restr_from $this->Time_restr_from->ViewValue = $this->Time_restr_from->CurrentValue; $this->Time_restr_from->ViewValue = ew_FormatDateTime($this->Time_restr_from->ViewValue, 4); $this->Time_restr_from->ViewCustomAttributes = ""; // Time_restr_to $this->Time_restr_to->ViewValue = $this->Time_restr_to->CurrentValue; $this->Time_restr_to->ViewValue = ew_FormatDateTime($this->Time_restr_to->ViewValue, 4); $this->Time_restr_to->ViewCustomAttributes = ""; // Services_access if (ew_ConvertToBool($this->Services_access->CurrentValue)) { $this->Services_access->ViewValue = $this->Services_access->FldTagCaption(1) <> "" ? $this->Services_access->FldTagCaption(1) : "Y"; } else { $this->Services_access->ViewValue = $this->Services_access->FldTagCaption(2) <> "" ? $this->Services_access->FldTagCaption(2) : "N"; } $this->Services_access->ViewCustomAttributes = ""; // Available_from $this->Available_from->ViewValue = $this->Available_from->CurrentValue; $this->Available_from->ViewValue = ew_FormatDateTime($this->Available_from->ViewValue, 7); $this->Available_from->ViewCustomAttributes = ""; // Available_to $this->Available_to->ViewValue = $this->Available_to->CurrentValue; $this->Available_to->ViewValue = ew_FormatDateTime($this->Available_to->ViewValue, 7); $this->Available_to->ViewCustomAttributes = ""; // Rel_type if (strval($this->Rel_type->CurrentValue) <> "") { $sFilterWrk = "`Rel_type`" . ew_SearchString("=", $this->Rel_type->CurrentValue, EW_DATATYPE_STRING, ""); switch (@$gsLanguage) { case "en": $sSqlWrk = "SELECT `Rel_type`, `Description` AS `DispFld`, '' AS `Disp2Fld`, '' AS `Disp3Fld`, '' AS `Disp4Fld` FROM `trel_type`"; $sWhereWrk = ""; $this->Rel_type->LookupFilters = array(); break; case "it": $sSqlWrk = "SELECT `Rel_type`, `Description_it` AS `DispFld`, '' AS `Disp2Fld`, '' AS `Disp3Fld`, '' AS `Disp4Fld` FROM `trel_type`"; $sWhereWrk = ""; $this->Rel_type->LookupFilters = array(); break; default: $sSqlWrk = "SELECT `Rel_type`, `Description` AS `DispFld`, '' AS `Disp2Fld`, '' AS `Disp3Fld`, '' AS `Disp4Fld` FROM `trel_type`"; $sWhereWrk = ""; $this->Rel_type->LookupFilters = array(); break; } ew_AddFilter($sWhereWrk, $sFilterWrk); $this->Lookup_Selecting($this->Rel_type, $sWhereWrk); // Call Lookup selecting if ($sWhereWrk <> "") $sSqlWrk .= " WHERE " . $sWhereWrk; $rswrk = Conn()->Execute($sSqlWrk); if ($rswrk && !$rswrk->EOF) { // Lookup values found $arwrk = array(); $arwrk[1] = $rswrk->fields('DispFld'); $this->Rel_type->ViewValue = $this->Rel_type->DisplayValue($arwrk); $rswrk->Close(); } else { $this->Rel_type->ViewValue = $this->Rel_type->CurrentValue; } } else { $this->Rel_type->ViewValue = NULL; } $this->Rel_type->ViewCustomAttributes = ""; // offer_woman if (ew_ConvertToBool($this->offer_woman->CurrentValue)) { $this->offer_woman->ViewValue = $this->offer_woman->FldTagCaption(1) <> "" ? $this->offer_woman->FldTagCaption(1) : "Y"; } else { $this->offer_woman->ViewValue = $this->offer_woman->FldTagCaption(2) <> "" ? $this->offer_woman->FldTagCaption(2) : "N"; } $this->offer_woman->ViewCustomAttributes = ""; // offer_children if (ew_ConvertToBool($this->offer_children->CurrentValue)) { $this->offer_children->ViewValue = $this->offer_children->FldTagCaption(1) <> "" ? $this->offer_children->FldTagCaption(1) : "Y"; } else { $this->offer_children->ViewValue = $this->offer_children->FldTagCaption(2) <> "" ? $this->offer_children->FldTagCaption(2) : "N"; } $this->offer_children->ViewCustomAttributes = ""; // offer_family if (ew_ConvertToBool($this->offer_family->CurrentValue)) { $this->offer_family->ViewValue = $this->offer_family->FldTagCaption(1) <> "" ? $this->offer_family->FldTagCaption(1) : "Y"; } else { $this->offer_family->ViewValue = $this->offer_family->FldTagCaption(2) <> "" ? $this->offer_family->FldTagCaption(2) : "N"; } $this->offer_family->ViewCustomAttributes = ""; // offer_man if (ew_ConvertToBool($this->offer_man->CurrentValue)) { $this->offer_man->ViewValue = $this->offer_man->FldTagCaption(1) <> "" ? $this->offer_man->FldTagCaption(1) : "Y"; } else { $this->offer_man->ViewValue = $this->offer_man->FldTagCaption(2) <> "" ? $this->offer_man->FldTagCaption(2) : "N"; } $this->offer_man->ViewCustomAttributes = ""; // offer_elderly if (ew_ConvertToBool($this->offer_elderly->CurrentValue)) { $this->offer_elderly->ViewValue = $this->offer_elderly->FldTagCaption(1) <> "" ? $this->offer_elderly->FldTagCaption(1) : "Y"; } else { $this->offer_elderly->ViewValue = $this->offer_elderly->FldTagCaption(2) <> "" ? $this->offer_elderly->FldTagCaption(2) : "N"; } $this->offer_elderly->ViewCustomAttributes = ""; // offer_disabled if (ew_ConvertToBool($this->offer_disabled->CurrentValue)) { $this->offer_disabled->ViewValue = $this->offer_disabled->FldTagCaption(1) <> "" ? $this->offer_disabled->FldTagCaption(1) : "Y"; } else { $this->offer_disabled->ViewValue = $this->offer_disabled->FldTagCaption(2) <> "" ? $this->offer_disabled->FldTagCaption(2) : "N"; } $this->offer_disabled->ViewCustomAttributes = ""; // offer_sick if (ew_ConvertToBool($this->offer_sick->CurrentValue)) { $this->offer_sick->ViewValue = $this->offer_sick->FldTagCaption(1) <> "" ? $this->offer_sick->FldTagCaption(1) : "Y"; } else { $this->offer_sick->ViewValue = $this->offer_sick->FldTagCaption(2) <> "" ? $this->offer_sick->FldTagCaption(2) : "N"; } $this->offer_sick->ViewCustomAttributes = ""; // offer_christian if (ew_ConvertToBool($this->offer_christian->CurrentValue)) { $this->offer_christian->ViewValue = $this->offer_christian->FldTagCaption(1) <> "" ? $this->offer_christian->FldTagCaption(1) : "Y"; } else { $this->offer_christian->ViewValue = $this->offer_christian->FldTagCaption(2) <> "" ? $this->offer_christian->FldTagCaption(2) : "N"; } $this->offer_christian->ViewCustomAttributes = ""; // offer_muslim if (ew_ConvertToBool($this->offer_muslim->CurrentValue)) { $this->offer_muslim->ViewValue = $this->offer_muslim->FldTagCaption(1) <> "" ? $this->offer_muslim->FldTagCaption(1) : "Y"; } else { $this->offer_muslim->ViewValue = $this->offer_muslim->FldTagCaption(2) <> "" ? $this->offer_muslim->FldTagCaption(2) : "N"; } $this->offer_muslim->ViewCustomAttributes = ""; // offer_other $this->offer_other->ViewValue = $this->offer_other->CurrentValue; $this->offer_other->ViewCustomAttributes = ""; // verify_date $this->verify_date->ViewValue = $this->verify_date->CurrentValue; $this->verify_date->ViewValue = ew_FormatDateTime($this->verify_date->ViewValue, 7); $this->verify_date->ViewCustomAttributes = ""; // verify_by $this->verify_by->ViewValue = $this->verify_by->CurrentValue; $this->verify_by->ViewCustomAttributes = ""; // verify_phone $this->verify_phone->ViewValue = $this->verify_phone->CurrentValue; $this->verify_phone->ViewCustomAttributes = ""; // verify_email $this->verify_email->ViewValue = $this->verify_email->CurrentValue; $this->verify_email->ViewCustomAttributes = ""; // Outcome if (strval($this->Outcome->CurrentValue) <> "") { $sFilterWrk = "`Outcome`" . ew_SearchString("=", $this->Outcome->CurrentValue, EW_DATATYPE_STRING, ""); switch (@$gsLanguage) { case "en": $sSqlWrk = "SELECT `Outcome`, `Description` AS `DispFld`, '' AS `Disp2Fld`, '' AS `Disp3Fld`, '' AS `Disp4Fld` FROM `toutcome`"; $sWhereWrk = ""; $this->Outcome->LookupFilters = array(); break; case "it": $sSqlWrk = "SELECT `Outcome`, `Description_it` AS `DispFld`, '' AS `Disp2Fld`, '' AS `Disp3Fld`, '' AS `Disp4Fld` FROM `toutcome`"; $sWhereWrk = ""; $this->Outcome->LookupFilters = array(); break; default: $sSqlWrk = "SELECT `Outcome`, `Description` AS `DispFld`, '' AS `Disp2Fld`, '' AS `Disp3Fld`, '' AS `Disp4Fld` FROM `toutcome`"; $sWhereWrk = ""; $this->Outcome->LookupFilters = array(); break; } ew_AddFilter($sWhereWrk, $sFilterWrk); $this->Lookup_Selecting($this->Outcome, $sWhereWrk); // Call Lookup selecting if ($sWhereWrk <> "") $sSqlWrk .= " WHERE " . $sWhereWrk; $rswrk = Conn()->Execute($sSqlWrk); if ($rswrk && !$rswrk->EOF) { // Lookup values found $arwrk = array(); $arwrk[1] = $rswrk->fields('DispFld'); $this->Outcome->ViewValue = $this->Outcome->DisplayValue($arwrk); $rswrk->Close(); } else { $this->Outcome->ViewValue = $this->Outcome->CurrentValue; } } else { $this->Outcome->ViewValue = NULL; } $this->Outcome->ViewCustomAttributes = ""; // Outcome_type if (strval($this->Outcome_type->CurrentValue) <> "") { $sFilterWrk = "`Outcome_type`" . ew_SearchString("=", $this->Outcome_type->CurrentValue, EW_DATATYPE_STRING, ""); switch (@$gsLanguage) { case "en": $sSqlWrk = "SELECT `Outcome_type`, `Description` AS `DispFld`, '' AS `Disp2Fld`, '' AS `Disp3Fld`, '' AS `Disp4Fld` FROM `toutcometype`"; $sWhereWrk = ""; $this->Outcome_type->LookupFilters = array(); break; case "it": $sSqlWrk = "SELECT `Outcome_type`, `Description_it` AS `DispFld`, '' AS `Disp2Fld`, '' AS `Disp3Fld`, '' AS `Disp4Fld` FROM `toutcometype`"; $sWhereWrk = ""; $this->Outcome_type->LookupFilters = array(); break; default: $sSqlWrk = "SELECT `Outcome_type`, `Description` AS `DispFld`, '' AS `Disp2Fld`, '' AS `Disp3Fld`, '' AS `Disp4Fld` FROM `toutcometype`"; $sWhereWrk = ""; $this->Outcome_type->LookupFilters = array(); break; } ew_AddFilter($sWhereWrk, $sFilterWrk); $this->Lookup_Selecting($this->Outcome_type, $sWhereWrk); // Call Lookup selecting if ($sWhereWrk <> "") $sSqlWrk .= " WHERE " . $sWhereWrk; $rswrk = Conn()->Execute($sSqlWrk); if ($rswrk && !$rswrk->EOF) { // Lookup values found $arwrk = array(); $arwrk[1] = $rswrk->fields('DispFld'); $this->Outcome_type->ViewValue = $this->Outcome_type->DisplayValue($arwrk); $rswrk->Close(); } else { $this->Outcome_type->ViewValue = $this->Outcome_type->CurrentValue; } } else { $this->Outcome_type->ViewValue = NULL; } $this->Outcome_type->ViewCustomAttributes = ""; // Rel_doc $this->Rel_doc->UploadPath = "uploads/accom/".$this->idAccomodation->DbValue; if (!ew_Empty($this->Rel_doc->Upload->DbValue)) { $this->Rel_doc->ViewValue = $this->Rel_doc->Upload->DbValue; } else { $this->Rel_doc->ViewValue = ""; } $this->Rel_doc->ViewCustomAttributes = ""; // idAccomodation $this->idAccomodation->LinkCustomAttributes = ""; $this->idAccomodation->HrefValue = ""; $this->idAccomodation->TooltipValue = ""; // idOfferer $this->idOfferer->LinkCustomAttributes = ""; if (!ew_Empty($this->idOfferer->CurrentValue)) { $this->idOfferer->HrefValue = "tofferersview.php?showdetail=&idOfferer=" . $this->idOfferer->CurrentValue; // Add prefix/suffix $this->idOfferer->LinkAttrs["target"] = ""; // Add target if ($this->Export <> "") $this->idOfferer->HrefValue = ew_ConvertFullUrl($this->idOfferer->HrefValue); } else { $this->idOfferer->HrefValue = ""; } $this->idOfferer->TooltipValue = ""; // Accom_Type $this->Accom_Type->LinkCustomAttributes = ""; $this->Accom_Type->HrefValue = ""; $this->Accom_Type->TooltipValue = ""; // Address $this->Address->LinkCustomAttributes = ""; $this->Address->HrefValue = ""; $this->Address->TooltipValue = ""; // Town $this->Town->LinkCustomAttributes = ""; $this->Town->HrefValue = ""; $this->Town->TooltipValue = ""; // District $this->District->LinkCustomAttributes = ""; $this->District->HrefValue = ""; $this->District->TooltipValue = ""; // Region $this->Region->LinkCustomAttributes = ""; $this->Region->HrefValue = ""; $this->Region->TooltipValue = ""; // Beds $this->Beds->LinkCustomAttributes = ""; $this->Beds->HrefValue = ""; $this->Beds->TooltipValue = ""; // Rooms $this->Rooms->LinkCustomAttributes = ""; $this->Rooms->HrefValue = ""; $this->Rooms->TooltipValue = ""; // Bathrooms $this->Bathrooms->LinkCustomAttributes = ""; $this->Bathrooms->HrefValue = ""; $this->Bathrooms->TooltipValue = ""; // Private_Kitchen $this->Private_Kitchen->LinkCustomAttributes = ""; $this->Private_Kitchen->HrefValue = ""; $this->Private_Kitchen->TooltipValue = ""; // Auton_heating $this->Auton_heating->LinkCustomAttributes = ""; $this->Auton_heating->HrefValue = ""; $this->Auton_heating->TooltipValue = ""; // Arch_barriers $this->Arch_barriers->LinkCustomAttributes = ""; $this->Arch_barriers->HrefValue = ""; $this->Arch_barriers->TooltipValue = ""; // Furnisched $this->Furnisched->LinkCustomAttributes = ""; $this->Furnisched->HrefValue = ""; $this->Furnisched->TooltipValue = ""; // Private_entrance $this->Private_entrance->LinkCustomAttributes = ""; $this->Private_entrance->HrefValue = ""; $this->Private_entrance->TooltipValue = ""; // Time_restrictions $this->Time_restrictions->LinkCustomAttributes = ""; $this->Time_restrictions->HrefValue = ""; $this->Time_restrictions->TooltipValue = ""; // Time_restr_from $this->Time_restr_from->LinkCustomAttributes = ""; $this->Time_restr_from->HrefValue = ""; $this->Time_restr_from->TooltipValue = ""; // Time_restr_to $this->Time_restr_to->LinkCustomAttributes = ""; $this->Time_restr_to->HrefValue = ""; $this->Time_restr_to->TooltipValue = ""; // Services_access $this->Services_access->LinkCustomAttributes = ""; $this->Services_access->HrefValue = ""; $this->Services_access->TooltipValue = ""; // Available_from $this->Available_from->LinkCustomAttributes = ""; $this->Available_from->HrefValue = ""; $this->Available_from->TooltipValue = ""; // Available_to $this->Available_to->LinkCustomAttributes = ""; $this->Available_to->HrefValue = ""; $this->Available_to->TooltipValue = ""; // Rel_type $this->Rel_type->LinkCustomAttributes = ""; $this->Rel_type->HrefValue = ""; $this->Rel_type->TooltipValue = ""; // offer_woman $this->offer_woman->LinkCustomAttributes = ""; $this->offer_woman->HrefValue = ""; $this->offer_woman->TooltipValue = ""; // offer_children $this->offer_children->LinkCustomAttributes = ""; $this->offer_children->HrefValue = ""; $this->offer_children->TooltipValue = ""; // offer_family $this->offer_family->LinkCustomAttributes = ""; $this->offer_family->HrefValue = ""; $this->offer_family->TooltipValue = ""; // offer_man $this->offer_man->LinkCustomAttributes = ""; $this->offer_man->HrefValue = ""; $this->offer_man->TooltipValue = ""; // offer_elderly $this->offer_elderly->LinkCustomAttributes = ""; $this->offer_elderly->HrefValue = ""; $this->offer_elderly->TooltipValue = ""; // offer_disabled $this->offer_disabled->LinkCustomAttributes = ""; $this->offer_disabled->HrefValue = ""; $this->offer_disabled->TooltipValue = ""; // offer_sick $this->offer_sick->LinkCustomAttributes = ""; $this->offer_sick->HrefValue = ""; $this->offer_sick->TooltipValue = ""; // offer_christian $this->offer_christian->LinkCustomAttributes = ""; $this->offer_christian->HrefValue = ""; $this->offer_christian->TooltipValue = ""; // offer_muslim $this->offer_muslim->LinkCustomAttributes = ""; $this->offer_muslim->HrefValue = ""; $this->offer_muslim->TooltipValue = ""; // offer_other $this->offer_other->LinkCustomAttributes = ""; $this->offer_other->HrefValue = ""; $this->offer_other->TooltipValue = ""; // verify_date $this->verify_date->LinkCustomAttributes = ""; $this->verify_date->HrefValue = ""; $this->verify_date->TooltipValue = ""; // verify_by $this->verify_by->LinkCustomAttributes = ""; $this->verify_by->HrefValue = ""; $this->verify_by->TooltipValue = ""; // verify_phone $this->verify_phone->LinkCustomAttributes = ""; $this->verify_phone->HrefValue = ""; $this->verify_phone->TooltipValue = ""; // verify_email $this->verify_email->LinkCustomAttributes = ""; $this->verify_email->HrefValue = ""; $this->verify_email->TooltipValue = ""; // Outcome $this->Outcome->LinkCustomAttributes = ""; $this->Outcome->HrefValue = ""; $this->Outcome->TooltipValue = ""; // Outcome_type $this->Outcome_type->LinkCustomAttributes = ""; $this->Outcome_type->HrefValue = ""; $this->Outcome_type->TooltipValue = ""; // Rel_doc $this->Rel_doc->LinkCustomAttributes = ""; $this->Rel_doc->UploadPath = "uploads/accom/".$this->idAccomodation->DbValue; if (!ew_Empty($this->Rel_doc->Upload->DbValue)) { $this->Rel_doc->HrefValue = "%u"; // Add prefix/suffix $this->Rel_doc->LinkAttrs["target"] = ""; // Add target if ($this->Export <> "") $this->Rel_doc->HrefValue = ew_ConvertFullUrl($this->Rel_doc->HrefValue); } else { $this->Rel_doc->HrefValue = ""; } $this->Rel_doc->HrefValue2 = $this->Rel_doc->UploadPath . $this->Rel_doc->Upload->DbValue; $this->Rel_doc->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 = "ExportPrintUrl . "\" class=\"ewExportLink ewPrint\" title=\"" . ew_HtmlEncode($Language->Phrase("PrinterFriendlyText")) . "\" data-caption=\"" . ew_HtmlEncode($Language->Phrase("PrinterFriendlyText")) . "\">" . $Language->Phrase("PrinterFriendly") . ""; $item->Visible = TRUE; // Export to Excel $item = &$this->ExportOptions->Add("excel"); $item->Body = "ExportExcelUrl . "\" class=\"ewExportLink ewExcel\" title=\"" . ew_HtmlEncode($Language->Phrase("ExportToExcelText")) . "\" data-caption=\"" . ew_HtmlEncode($Language->Phrase("ExportToExcelText")) . "\">" . $Language->Phrase("ExportToExcel") . ""; $item->Visible = TRUE; // Export to Word $item = &$this->ExportOptions->Add("word"); $item->Body = "ExportWordUrl . "\" class=\"ewExportLink ewWord\" title=\"" . ew_HtmlEncode($Language->Phrase("ExportToWordText")) . "\" data-caption=\"" . ew_HtmlEncode($Language->Phrase("ExportToWordText")) . "\">" . $Language->Phrase("ExportToWord") . ""; $item->Visible = TRUE; // Export to Html $item = &$this->ExportOptions->Add("html"); $item->Body = "ExportHtmlUrl . "\" class=\"ewExportLink ewHtml\" title=\"" . ew_HtmlEncode($Language->Phrase("ExportToHtmlText")) . "\" data-caption=\"" . ew_HtmlEncode($Language->Phrase("ExportToHtmlText")) . "\">" . $Language->Phrase("ExportToHtml") . ""; $item->Visible = TRUE; // Export to Xml $item = &$this->ExportOptions->Add("xml"); $item->Body = "ExportXmlUrl . "\" class=\"ewExportLink ewXml\" title=\"" . ew_HtmlEncode($Language->Phrase("ExportToXmlText")) . "\" data-caption=\"" . ew_HtmlEncode($Language->Phrase("ExportToXmlText")) . "\">" . $Language->Phrase("ExportToXml") . ""; $item->Visible = FALSE; // Export to Csv $item = &$this->ExportOptions->Add("csv"); $item->Body = "ExportCsvUrl . "\" class=\"ewExportLink ewCsv\" title=\"" . ew_HtmlEncode($Language->Phrase("ExportToCsvText")) . "\" data-caption=\"" . ew_HtmlEncode($Language->Phrase("ExportToCsvText")) . "\">" . $Language->Phrase("ExportToCsv") . ""; $item->Visible = TRUE; // Export to Pdf $item = &$this->ExportOptions->Add("pdf"); $item->Body = "ExportPdfUrl . "\" class=\"ewExportLink ewPdf\" title=\"" . ew_HtmlEncode($Language->Phrase("ExportToPDFText")) . "\" data-caption=\"" . ew_HtmlEncode($Language->Phrase("ExportToPDFText")) . "\">" . $Language->Phrase("ExportToPDF") . ""; $item->Visible = TRUE; // Export to Email $item = &$this->ExportOptions->Add("email"); $url = ""; $item->Body = ""; $item->Visible = TRUE; // Drop down button for export $this->ExportOptions->UseButtonGroup = TRUE; $this->ExportOptions->UseImageAndText = TRUE; $this->ExportOptions->UseDropDownButton = TRUE; 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"); // Export detail records (tassigment) if (EW_EXPORT_DETAIL_RECORDS && in_array("tassigment", explode(",", $this->getCurrentDetailTable()))) { global $tassigment; if (!isset($tassigment)) $tassigment = new ctassigment; $rsdetail = $tassigment->LoadRs($tassigment->GetDetailFilter()); // Load detail records if ($rsdetail && !$rsdetail->EOF) { $ExportStyle = $Doc->Style; $Doc->SetStyle("h"); // Change to horizontal if ($this->Export <> "csv" || EW_EXPORT_DETAIL_RECORDS_FOR_CSV) { $Doc->ExportEmptyRow(); $detailcnt = $rsdetail->RecordCount(); $tassigment->ExportDocument($Doc, $rsdetail, 1, $detailcnt); } $Doc->SetStyle($ExportStyle); // Restore $rsdetail->Close(); } } $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 if ($this->Export == "email") { echo $this->ExportEmail($Doc->Text); } else { $Doc->Export(); } } // Export email function ExportEmail($EmailContent) { global $gTmpImages, $Language; $sSender = @$_POST["sender"]; $sRecipient = @$_POST["recipient"]; $sCc = @$_POST["cc"]; $sBcc = @$_POST["bcc"]; $sContentType = @$_POST["contenttype"]; // Subject $sSubject = ew_StripSlashes(@$_POST["subject"]); $sEmailSubject = $sSubject; // Message $sContent = ew_StripSlashes(@$_POST["message"]); $sEmailMessage = $sContent; // Check sender if ($sSender == "") { return "

    " . $Language->Phrase("EnterSenderEmail") . "

    "; } if (!ew_CheckEmail($sSender)) { return "

    " . $Language->Phrase("EnterProperSenderEmail") . "

    "; } // Check recipient if (!ew_CheckEmailList($sRecipient, EW_MAX_EMAIL_RECIPIENT)) { return "

    " . $Language->Phrase("EnterProperRecipientEmail") . "

    "; } // Check cc if (!ew_CheckEmailList($sCc, EW_MAX_EMAIL_RECIPIENT)) { return "

    " . $Language->Phrase("EnterProperCcEmail") . "

    "; } // Check bcc if (!ew_CheckEmailList($sBcc, EW_MAX_EMAIL_RECIPIENT)) { return "

    " . $Language->Phrase("EnterProperBccEmail") . "

    "; } // 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) { return "

    " . $Language->Phrase("ExceedMaxEmailExport") . "

    "; } // 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->Format = ($sContentType == "url") ? "text" : "html"; if ($sEmailMessage <> "") { $sEmailMessage = ew_RemoveXSS($sEmailMessage); $sEmailMessage .= ($sContentType == "url") ? "\r\n\r\n" : "

    "; } if ($sContentType == "url") { $sUrl = ew_ConvertFullUrl(ew_CurrentPage() . "?" . $this->ExportQueryString()); $sEmailMessage .= $sUrl; // Send URL only } else { foreach ($gTmpImages as $tmpimage) $Email->AddEmbeddedImage($tmpimage); $sEmailMessage .= ew_CleanEmailContent($EmailContent); // Send HTML } $Email->Content = $sEmailMessage; // Content $EventArgs = array(); if ($this->Recordset) { $this->RecCnt = $this->StartRec - 1; $this->Recordset->MoveFirst(); if ($this->StartRec > 1) $this->Recordset->Move($this->StartRec - 1); $EventArgs["rs"] = &$this->Recordset; } $bEmailSent = FALSE; if ($this->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 return "

    " . $Language->Phrase("SendEmailSuccess") . "

    "; // Set up success message } else { // Sent email failure return "

    " . $Email->SendErrDescription . "

    "; } } // Export QueryString function ExportQueryString() { // Initialize $sQry = "export=html"; // Add record key QueryString $sQry .= "&" . substr($this->KeyUrl("", ""), 1); return $sQry; } // Set up master/detail based on QueryString function SetUpMasterParms() { $bValidMaster = FALSE; // Get the keys for master table if (isset($_GET[EW_TABLE_SHOW_MASTER])) { $sMasterTblVar = $_GET[EW_TABLE_SHOW_MASTER]; if ($sMasterTblVar == "") { $bValidMaster = TRUE; $this->DbMasterFilter = ""; $this->DbDetailFilter = ""; } if ($sMasterTblVar == "tofferers") { $bValidMaster = TRUE; if (@$_GET["fk_idOfferer"] <> "") { $GLOBALS["tofferers"]->idOfferer->setQueryStringValue($_GET["fk_idOfferer"]); $this->idOfferer->setQueryStringValue($GLOBALS["tofferers"]->idOfferer->QueryStringValue); $this->idOfferer->setSessionValue($this->idOfferer->QueryStringValue); if (!is_numeric($GLOBALS["tofferers"]->idOfferer->QueryStringValue)) $bValidMaster = FALSE; } else { $bValidMaster = FALSE; } } } elseif (isset($_POST[EW_TABLE_SHOW_MASTER])) { $sMasterTblVar = $_POST[EW_TABLE_SHOW_MASTER]; if ($sMasterTblVar == "") { $bValidMaster = TRUE; $this->DbMasterFilter = ""; $this->DbDetailFilter = ""; } if ($sMasterTblVar == "tofferers") { $bValidMaster = TRUE; if (@$_POST["fk_idOfferer"] <> "") { $GLOBALS["tofferers"]->idOfferer->setFormValue($_POST["fk_idOfferer"]); $this->idOfferer->setFormValue($GLOBALS["tofferers"]->idOfferer->FormValue); $this->idOfferer->setSessionValue($this->idOfferer->FormValue); if (!is_numeric($GLOBALS["tofferers"]->idOfferer->FormValue)) $bValidMaster = FALSE; } else { $bValidMaster = FALSE; } } } if ($bValidMaster) { // Save current master table $this->setCurrentMasterTable($sMasterTblVar); $this->setSessionWhere($this->GetDetailFilter()); // Reset start record counter (new master key) $this->StartRec = 1; $this->setStartRecordNumber($this->StartRec); // Clear previous master key from Session if ($sMasterTblVar <> "tofferers") { if ($this->idOfferer->CurrentValue == "") $this->idOfferer->setSessionValue(""); } } $this->DbMasterFilter = $this->GetMasterFilter(); // Get master filter $this->DbDetailFilter = $this->GetDetailFilter(); // Get detail filter } // Set up detail parms based on QueryString function SetUpDetailParms() { // Get the keys for master table if (isset($_GET[EW_TABLE_SHOW_DETAIL])) { $sDetailTblVar = $_GET[EW_TABLE_SHOW_DETAIL]; $this->setCurrentDetailTable($sDetailTblVar); } else { $sDetailTblVar = $this->getCurrentDetailTable(); } if ($sDetailTblVar <> "") { $DetailTblVar = explode(",", $sDetailTblVar); if (in_array("tassigment", $DetailTblVar)) { if (!isset($GLOBALS["tassigment_grid"])) $GLOBALS["tassigment_grid"] = new ctassigment_grid; if ($GLOBALS["tassigment_grid"]->DetailView) { $GLOBALS["tassigment_grid"]->CurrentMode = "view"; // Save current master table to detail table $GLOBALS["tassigment_grid"]->setCurrentMasterTable($this->TableVar); $GLOBALS["tassigment_grid"]->setStartRecordNumber(1); $GLOBALS["tassigment_grid"]->idkAccomodation->FldIsDetailKey = TRUE; $GLOBALS["tassigment_grid"]->idkAccomodation->CurrentValue = $this->idAccomodation->CurrentValue; $GLOBALS["tassigment_grid"]->idkAccomodation->setSessionValue($GLOBALS["tassigment_grid"]->idkAccomodation->CurrentValue); } } } } // 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("taccomodationslist.php"), "", $this->TableVar, TRUE); $PageId = "view"; $Breadcrumb->Add("view", $PageId, $url); } // Setup lookup filters of a field function SetupLookupFilters($fld, $pageId = null) { global $gsLanguage; $pageId = $pageId ?: $this->PageID; switch ($fld->FldVar) { } } // Setup AutoSuggest filters of a field function SetupAutoSuggestFilters($fld, $pageId = null) { global $gsLanguage; $pageId = $pageId ?: $this->PageID; switch ($fld->FldVar) { } } // 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; } } ?> Page_Init(); // Page main $taccomodations_view->Page_Main(); // Global Page Rendering event (in userfn*.php) Page_Rendering(); // Page Rendering event $taccomodations_view->Page_Render(); ?> Export == "") { ?> Export == "") { ?>
    IsModal) { ?> Export == "") { ?> Render(); ?> ExportOptions->Render("body") ?> OtherOptions as &$option) $option->Render("body"); ?> IsModal) { ?> Export == "") { ?> SelectionForm(); ?>
    ShowPageHeader(); ?> ShowMessage(); ?> IsModal) { ?> Export == "") { ?>
    Pager)) $taccomodations_view->Pager = new cNumericPager($taccomodations_view->StartRec, $taccomodations_view->DisplayRecs, $taccomodations_view->TotalRecs, $taccomodations_view->RecRange) ?> Pager->RecordCount > 0 && $taccomodations_view->Pager->Visible) { ?>
    CheckToken) { ?> IsModal) { ?> idAccomodation->Visible) { // idAccomodation ?> idOfferer->Visible) { // idOfferer ?> Accom_Type->Visible) { // Accom_Type ?> Address->Visible) { // Address ?> Town->Visible) { // Town ?> District->Visible) { // District ?> Region->Visible) { // Region ?> Beds->Visible) { // Beds ?> Rooms->Visible) { // Rooms ?> Bathrooms->Visible) { // Bathrooms ?> Private_Kitchen->Visible) { // Private_Kitchen ?> Auton_heating->Visible) { // Auton_heating ?> Arch_barriers->Visible) { // Arch_barriers ?> Furnisched->Visible) { // Furnisched ?> Private_entrance->Visible) { // Private_entrance ?> Time_restrictions->Visible) { // Time_restrictions ?> Time_restr_from->Visible) { // Time_restr_from ?> Time_restr_to->Visible) { // Time_restr_to ?> Services_access->Visible) { // Services_access ?> Available_from->Visible) { // Available_from ?> Available_to->Visible) { // Available_to ?> Rel_type->Visible) { // Rel_type ?> offer_woman->Visible) { // offer_woman ?> offer_children->Visible) { // offer_children ?> offer_family->Visible) { // offer_family ?> offer_man->Visible) { // offer_man ?> offer_elderly->Visible) { // offer_elderly ?> offer_disabled->Visible) { // offer_disabled ?> offer_sick->Visible) { // offer_sick ?> offer_christian->Visible) { // offer_christian ?> offer_muslim->Visible) { // offer_muslim ?> offer_other->Visible) { // offer_other ?> verify_date->Visible) { // verify_date ?> verify_by->Visible) { // verify_by ?> verify_phone->Visible) { // verify_phone ?> verify_email->Visible) { // verify_email ?> Outcome->Visible) { // Outcome ?> Outcome_type->Visible) { // Outcome_type ?> Rel_doc->Visible) { // Rel_doc ?>
    idAccomodation->FldCaption() ?> idAccomodation->CellAttributes() ?>> idAccomodation->ViewAttributes() ?>> idAccomodation->ViewValue ?>
    idOfferer->FldCaption() ?> idOfferer->CellAttributes() ?>> idOfferer->ViewAttributes() ?>> idOfferer->ViewValue)) && $taccomodations->idOfferer->LinkAttributes() <> "") { ?> idOfferer->LinkAttributes() ?>>idOfferer->ViewValue ?> idOfferer->ViewValue ?>
    Accom_Type->FldCaption() ?> Accom_Type->CellAttributes() ?>> Accom_Type->ViewAttributes() ?>> Accom_Type->ViewValue ?>
    Address->FldCaption() ?> Address->CellAttributes() ?>> Address->ViewAttributes() ?>> Address->ViewValue ?>
    Town->FldCaption() ?> Town->CellAttributes() ?>> Town->ViewAttributes() ?>> Town->ViewValue ?>
    District->FldCaption() ?> District->CellAttributes() ?>> District->ViewAttributes() ?>> District->ViewValue ?>
    Region->FldCaption() ?> Region->CellAttributes() ?>> Region->ViewAttributes() ?>> Region->ViewValue ?>
    Beds->FldCaption() ?> Beds->CellAttributes() ?>> Beds->ViewAttributes() ?>> Beds->ViewValue ?>
    Rooms->FldCaption() ?> Rooms->CellAttributes() ?>> Rooms->ViewAttributes() ?>> Rooms->ViewValue ?>
    Bathrooms->FldCaption() ?> Bathrooms->CellAttributes() ?>> Bathrooms->ViewAttributes() ?>> Bathrooms->ViewValue ?>
    Private_Kitchen->FldCaption() ?> Private_Kitchen->CellAttributes() ?>> Private_Kitchen->ViewAttributes() ?>> Private_Kitchen->ViewValue ?>
    Auton_heating->FldCaption() ?> Auton_heating->CellAttributes() ?>> Auton_heating->ViewAttributes() ?>> Auton_heating->ViewValue ?>
    Arch_barriers->FldCaption() ?> Arch_barriers->CellAttributes() ?>> Arch_barriers->ViewAttributes() ?>> Arch_barriers->ViewValue ?>
    Furnisched->FldCaption() ?> Furnisched->CellAttributes() ?>> Furnisched->ViewAttributes() ?>> Furnisched->ViewValue ?>
    Private_entrance->FldCaption() ?> Private_entrance->CellAttributes() ?>> Private_entrance->ViewAttributes() ?>> Private_entrance->ViewValue ?>
    Time_restrictions->FldCaption() ?> Time_restrictions->CellAttributes() ?>> Time_restrictions->ViewAttributes() ?>> Time_restrictions->ViewValue ?>
    Time_restr_from->FldCaption() ?> Time_restr_from->CellAttributes() ?>> Time_restr_from->ViewAttributes() ?>> Time_restr_from->ViewValue ?>
    Time_restr_to->FldCaption() ?> Time_restr_to->CellAttributes() ?>> Time_restr_to->ViewAttributes() ?>> Time_restr_to->ViewValue ?>
    Services_access->FldCaption() ?> Services_access->CellAttributes() ?>> Services_access->ViewAttributes() ?>> Services_access->ViewValue ?>
    Available_from->FldCaption() ?> Available_from->CellAttributes() ?>> Available_from->ViewAttributes() ?>> Available_from->ViewValue ?>
    Available_to->FldCaption() ?> Available_to->CellAttributes() ?>> Available_to->ViewAttributes() ?>> Available_to->ViewValue ?>
    Rel_type->FldCaption() ?> Rel_type->CellAttributes() ?>> Rel_type->ViewAttributes() ?>> Rel_type->ViewValue ?>
    offer_woman->FldCaption() ?> offer_woman->CellAttributes() ?>> offer_woman->ViewAttributes() ?>> offer_woman->ViewValue ?>
    offer_children->FldCaption() ?> offer_children->CellAttributes() ?>> offer_children->ViewAttributes() ?>> offer_children->ViewValue ?>
    offer_family->FldCaption() ?> offer_family->CellAttributes() ?>> offer_family->ViewAttributes() ?>> offer_family->ViewValue ?>
    offer_man->FldCaption() ?> offer_man->CellAttributes() ?>> offer_man->ViewAttributes() ?>> offer_man->ViewValue ?>
    offer_elderly->FldCaption() ?> offer_elderly->CellAttributes() ?>> offer_elderly->ViewAttributes() ?>> offer_elderly->ViewValue ?>
    offer_disabled->FldCaption() ?> offer_disabled->CellAttributes() ?>> offer_disabled->ViewAttributes() ?>> offer_disabled->ViewValue ?>
    offer_sick->FldCaption() ?> offer_sick->CellAttributes() ?>> offer_sick->ViewAttributes() ?>> offer_sick->ViewValue ?>
    offer_christian->FldCaption() ?> offer_christian->CellAttributes() ?>> offer_christian->ViewAttributes() ?>> offer_christian->ViewValue ?>
    offer_muslim->FldCaption() ?> offer_muslim->CellAttributes() ?>> offer_muslim->ViewAttributes() ?>> offer_muslim->ViewValue ?>
    offer_other->FldCaption() ?> offer_other->CellAttributes() ?>> offer_other->ViewAttributes() ?>> offer_other->ViewValue ?>
    verify_date->FldCaption() ?> verify_date->CellAttributes() ?>> verify_date->ViewAttributes() ?>> verify_date->ViewValue ?>
    verify_by->FldCaption() ?> verify_by->CellAttributes() ?>> verify_by->ViewAttributes() ?>> verify_by->ViewValue ?>
    verify_phone->FldCaption() ?> verify_phone->CellAttributes() ?>> verify_phone->ViewAttributes() ?>> verify_phone->ViewValue ?>
    verify_email->FldCaption() ?> verify_email->CellAttributes() ?>> verify_email->ViewAttributes() ?>> verify_email->ViewValue ?>
    Outcome->FldCaption() ?> Outcome->CellAttributes() ?>> Outcome->ViewAttributes() ?>> Outcome->ViewValue ?>
    Outcome_type->FldCaption() ?> Outcome_type->CellAttributes() ?>> Outcome_type->ViewAttributes() ?>> Outcome_type->ViewValue ?>
    Rel_doc->FldCaption() ?> Rel_doc->CellAttributes() ?>> Rel_doc->ViewAttributes() ?>> Rel_doc, $taccomodations->Rel_doc->ViewValue) ?>
    IsModal) { ?> Export == "") { ?> Pager)) $taccomodations_view->Pager = new cNumericPager($taccomodations_view->StartRec, $taccomodations_view->DisplayRecs, $taccomodations_view->TotalRecs, $taccomodations_view->RecRange) ?> Pager->RecordCount > 0 && $taccomodations_view->Pager->Visible) { ?>
    getCurrentDetailTable())) && $tassigment->DetailView) { ?> getCurrentDetailTable() <> "") { ?>

    TablePhrase("tassigment", "TblCaption") ?>

    Export == "") { ?> ShowPageFooter(); if (EW_DEBUG_ENABLED) echo ew_DebugMsg(); ?> Export == "") { ?> Page_Terminate(); ?>