" . $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"]; } // 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", 'edit', 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); } } // // 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->CanEdit()) { $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")); } // Create form object $objForm = new cFormObj(); $this->CurrentAction = (@$_GET["a"] <> "") ? $_GET["a"] : @$_POST["a_list"]; // Set up current action $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(); } // Process auto fill if (@$_POST["ajax"] == "autofill") { // Process auto fill for detail table 'tassigment' if (@$_POST["grid"] == "ftassigmentgrid") { if (!isset($GLOBALS["tassigment_grid"])) $GLOBALS["tassigment_grid"] = new ctassigment_grid; $GLOBALS["tassigment_grid"]->Page_Init(); $this->Page_Terminate(); exit(); } $results = $this->GetAutoFill(@$_POST["name"], @$_POST["q"]); if ($results) { // Clean output buffer if (!EW_DEBUG_ENABLED && ob_get_length()) ob_end_clean(); echo $results; $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 $FormClassName = "form-horizontal ewForm ewEditForm"; var $IsModal = FALSE; var $DbMasterFilter; var $DbDetailFilter; var $DisplayRecs = 1; var $StartRec; var $StopRec; var $TotalRecs = 0; var $RecRange = 10; var $Pager; var $RecCnt; var $RecKey = array(); var $Recordset; // // Page main // function Page_Main() { global $objForm, $Language, $gsFormError; 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; // Load key from QueryString if (@$_GET["idAccomodation"] <> "") { $this->idAccomodation->setQueryStringValue($_GET["idAccomodation"]); $this->RecKey["idAccomodation"] = $this->idAccomodation->QueryStringValue; } else { $bLoadCurrentRecord = TRUE; } // Set up master detail parameters $this->SetUpMasterParms(); // Load recordset $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(); } } } // Process form if post back if (@$_POST["a_edit"] <> "") { $this->CurrentAction = $_POST["a_edit"]; // Get action code $this->LoadFormValues(); // Get form values // Set up detail parameters $this->SetUpDetailParms(); } else { $this->CurrentAction = "I"; // Default action is display } // Validate form if post back if (@$_POST["a_edit"] <> "") { if (!$this->ValidateForm()) { $this->CurrentAction = ""; // Form error, reset action $this->setFailureMessage($gsFormError); $this->EventCancelled = TRUE; // Event cancelled $this->RestoreFormValues(); } } switch ($this->CurrentAction) { case "I": // Get a record to display if (!$bMatchRecord) { if ($this->getSuccessMessage() == "" && $this->getFailureMessage() == "") $this->setFailureMessage($Language->Phrase("NoRecord")); // Set no record message $this->Page_Terminate("taccomodationslist.php"); // Return to list page } else { $this->LoadRowValues($this->Recordset); // Load row values } // Set up detail parameters $this->SetUpDetailParms(); break; Case "U": // Update if ($this->getCurrentDetailTable() <> "") // Master/detail edit $sReturnUrl = $this->GetViewUrl(EW_TABLE_SHOW_DETAIL . "=" . $this->getCurrentDetailTable()); // Master/Detail view page else $sReturnUrl = $this->getReturnUrl(); if (ew_GetPageName($sReturnUrl) == "taccomodationslist.php") $sReturnUrl = $this->AddMasterUrl($sReturnUrl); // List page, return to list page with correct master key if necessary $this->SendEmail = TRUE; // Send email on update success if ($this->EditRow()) { // Update record based on key if ($this->getSuccessMessage() == "") $this->setSuccessMessage($Language->Phrase("UpdateSuccess")); // Update success $this->Page_Terminate($sReturnUrl); // Return to caller } elseif ($this->getFailureMessage() == $Language->Phrase("NoRecord")) { $this->Page_Terminate($sReturnUrl); // Return to caller } else { $this->EventCancelled = TRUE; // Event cancelled $this->RestoreFormValues(); // Restore form values if update failed // Set up detail parameters $this->SetUpDetailParms(); } } // Set up Breadcrumb $this->SetupBreadcrumb(); // Render the record $this->RowType = EW_ROWTYPE_EDIT; // Render as Edit $this->ResetAttrs(); $this->RenderRow(); } // 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); } } // Get upload files function GetUploadFiles() { global $objForm, $Language; // Get upload data $this->Rel_doc->Upload->Index = $objForm->Index; $this->Rel_doc->Upload->UploadFile(); $this->Rel_doc->CurrentValue = $this->Rel_doc->Upload->FileName; $this->Rel_doc_type->CurrentValue = $this->Rel_doc->Upload->ContentType; $this->Rel_doc_size->CurrentValue = $this->Rel_doc->Upload->FileSize; } // Load form values function LoadFormValues() { // Load from form global $objForm; $this->GetUploadFiles(); // Get upload files if (!$this->idAccomodation->FldIsDetailKey) $this->idAccomodation->setFormValue($objForm->GetValue("x_idAccomodation")); if (!$this->idOfferer->FldIsDetailKey) { $this->idOfferer->setFormValue($objForm->GetValue("x_idOfferer")); } if (!$this->Accom_Type->FldIsDetailKey) { $this->Accom_Type->setFormValue($objForm->GetValue("x_Accom_Type")); } if (!$this->Address->FldIsDetailKey) { $this->Address->setFormValue($objForm->GetValue("x_Address")); } if (!$this->Town->FldIsDetailKey) { $this->Town->setFormValue($objForm->GetValue("x_Town")); } if (!$this->District->FldIsDetailKey) { $this->District->setFormValue($objForm->GetValue("x_District")); } if (!$this->Region->FldIsDetailKey) { $this->Region->setFormValue($objForm->GetValue("x_Region")); } if (!$this->Beds->FldIsDetailKey) { $this->Beds->setFormValue($objForm->GetValue("x_Beds")); } if (!$this->Rooms->FldIsDetailKey) { $this->Rooms->setFormValue($objForm->GetValue("x_Rooms")); } if (!$this->Bathrooms->FldIsDetailKey) { $this->Bathrooms->setFormValue($objForm->GetValue("x_Bathrooms")); } if (!$this->Private_Kitchen->FldIsDetailKey) { $this->Private_Kitchen->setFormValue($objForm->GetValue("x_Private_Kitchen")); } if (!$this->Auton_heating->FldIsDetailKey) { $this->Auton_heating->setFormValue($objForm->GetValue("x_Auton_heating")); } if (!$this->Arch_barriers->FldIsDetailKey) { $this->Arch_barriers->setFormValue($objForm->GetValue("x_Arch_barriers")); } if (!$this->Furnisched->FldIsDetailKey) { $this->Furnisched->setFormValue($objForm->GetValue("x_Furnisched")); } if (!$this->Private_entrance->FldIsDetailKey) { $this->Private_entrance->setFormValue($objForm->GetValue("x_Private_entrance")); } if (!$this->Time_restrictions->FldIsDetailKey) { $this->Time_restrictions->setFormValue($objForm->GetValue("x_Time_restrictions")); } if (!$this->Time_restr_from->FldIsDetailKey) { $this->Time_restr_from->setFormValue($objForm->GetValue("x_Time_restr_from")); $this->Time_restr_from->CurrentValue = ew_UnFormatDateTime($this->Time_restr_from->CurrentValue, 4); } if (!$this->Time_restr_to->FldIsDetailKey) { $this->Time_restr_to->setFormValue($objForm->GetValue("x_Time_restr_to")); $this->Time_restr_to->CurrentValue = ew_UnFormatDateTime($this->Time_restr_to->CurrentValue, 4); } if (!$this->Services_access->FldIsDetailKey) { $this->Services_access->setFormValue($objForm->GetValue("x_Services_access")); } if (!$this->Available_from->FldIsDetailKey) { $this->Available_from->setFormValue($objForm->GetValue("x_Available_from")); $this->Available_from->CurrentValue = ew_UnFormatDateTime($this->Available_from->CurrentValue, 7); } if (!$this->Available_to->FldIsDetailKey) { $this->Available_to->setFormValue($objForm->GetValue("x_Available_to")); $this->Available_to->CurrentValue = ew_UnFormatDateTime($this->Available_to->CurrentValue, 7); } if (!$this->Rel_type->FldIsDetailKey) { $this->Rel_type->setFormValue($objForm->GetValue("x_Rel_type")); } if (!$this->offer_woman->FldIsDetailKey) { $this->offer_woman->setFormValue($objForm->GetValue("x_offer_woman")); } if (!$this->offer_children->FldIsDetailKey) { $this->offer_children->setFormValue($objForm->GetValue("x_offer_children")); } if (!$this->offer_family->FldIsDetailKey) { $this->offer_family->setFormValue($objForm->GetValue("x_offer_family")); } if (!$this->offer_man->FldIsDetailKey) { $this->offer_man->setFormValue($objForm->GetValue("x_offer_man")); } if (!$this->offer_elderly->FldIsDetailKey) { $this->offer_elderly->setFormValue($objForm->GetValue("x_offer_elderly")); } if (!$this->offer_disabled->FldIsDetailKey) { $this->offer_disabled->setFormValue($objForm->GetValue("x_offer_disabled")); } if (!$this->offer_sick->FldIsDetailKey) { $this->offer_sick->setFormValue($objForm->GetValue("x_offer_sick")); } if (!$this->offer_christian->FldIsDetailKey) { $this->offer_christian->setFormValue($objForm->GetValue("x_offer_christian")); } if (!$this->offer_muslim->FldIsDetailKey) { $this->offer_muslim->setFormValue($objForm->GetValue("x_offer_muslim")); } if (!$this->offer_other->FldIsDetailKey) { $this->offer_other->setFormValue($objForm->GetValue("x_offer_other")); } if (!$this->verify_date->FldIsDetailKey) { $this->verify_date->setFormValue($objForm->GetValue("x_verify_date")); $this->verify_date->CurrentValue = ew_UnFormatDateTime($this->verify_date->CurrentValue, 7); } if (!$this->verify_by->FldIsDetailKey) { $this->verify_by->setFormValue($objForm->GetValue("x_verify_by")); } if (!$this->verify_phone->FldIsDetailKey) { $this->verify_phone->setFormValue($objForm->GetValue("x_verify_phone")); } if (!$this->verify_email->FldIsDetailKey) { $this->verify_email->setFormValue($objForm->GetValue("x_verify_email")); } if (!$this->Outcome->FldIsDetailKey) { $this->Outcome->setFormValue($objForm->GetValue("x_Outcome")); } if (!$this->Outcome_type->FldIsDetailKey) { $this->Outcome_type->setFormValue($objForm->GetValue("x_Outcome_type")); } } // Restore form values function RestoreFormValues() { global $objForm; $this->LoadRow(); $this->idAccomodation->CurrentValue = $this->idAccomodation->FormValue; $this->idOfferer->CurrentValue = $this->idOfferer->FormValue; $this->Accom_Type->CurrentValue = $this->Accom_Type->FormValue; $this->Address->CurrentValue = $this->Address->FormValue; $this->Town->CurrentValue = $this->Town->FormValue; $this->District->CurrentValue = $this->District->FormValue; $this->Region->CurrentValue = $this->Region->FormValue; $this->Beds->CurrentValue = $this->Beds->FormValue; $this->Rooms->CurrentValue = $this->Rooms->FormValue; $this->Bathrooms->CurrentValue = $this->Bathrooms->FormValue; $this->Private_Kitchen->CurrentValue = $this->Private_Kitchen->FormValue; $this->Auton_heating->CurrentValue = $this->Auton_heating->FormValue; $this->Arch_barriers->CurrentValue = $this->Arch_barriers->FormValue; $this->Furnisched->CurrentValue = $this->Furnisched->FormValue; $this->Private_entrance->CurrentValue = $this->Private_entrance->FormValue; $this->Time_restrictions->CurrentValue = $this->Time_restrictions->FormValue; $this->Time_restr_from->CurrentValue = $this->Time_restr_from->FormValue; $this->Time_restr_from->CurrentValue = ew_UnFormatDateTime($this->Time_restr_from->CurrentValue, 4); $this->Time_restr_to->CurrentValue = $this->Time_restr_to->FormValue; $this->Time_restr_to->CurrentValue = ew_UnFormatDateTime($this->Time_restr_to->CurrentValue, 4); $this->Services_access->CurrentValue = $this->Services_access->FormValue; $this->Available_from->CurrentValue = $this->Available_from->FormValue; $this->Available_from->CurrentValue = ew_UnFormatDateTime($this->Available_from->CurrentValue, 7); $this->Available_to->CurrentValue = $this->Available_to->FormValue; $this->Available_to->CurrentValue = ew_UnFormatDateTime($this->Available_to->CurrentValue, 7); $this->Rel_type->CurrentValue = $this->Rel_type->FormValue; $this->offer_woman->CurrentValue = $this->offer_woman->FormValue; $this->offer_children->CurrentValue = $this->offer_children->FormValue; $this->offer_family->CurrentValue = $this->offer_family->FormValue; $this->offer_man->CurrentValue = $this->offer_man->FormValue; $this->offer_elderly->CurrentValue = $this->offer_elderly->FormValue; $this->offer_disabled->CurrentValue = $this->offer_disabled->FormValue; $this->offer_sick->CurrentValue = $this->offer_sick->FormValue; $this->offer_christian->CurrentValue = $this->offer_christian->FormValue; $this->offer_muslim->CurrentValue = $this->offer_muslim->FormValue; $this->offer_other->CurrentValue = $this->offer_other->FormValue; $this->verify_date->CurrentValue = $this->verify_date->FormValue; $this->verify_date->CurrentValue = ew_UnFormatDateTime($this->verify_date->CurrentValue, 7); $this->verify_by->CurrentValue = $this->verify_by->FormValue; $this->verify_phone->CurrentValue = $this->verify_phone->FormValue; $this->verify_email->CurrentValue = $this->verify_email->FormValue; $this->Outcome->CurrentValue = $this->Outcome->FormValue; $this->Outcome_type->CurrentValue = $this->Outcome_type->FormValue; } // 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')); } // 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 // 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 = ""; } elseif ($this->RowType == EW_ROWTYPE_EDIT) { // Edit row // idAccomodation $this->idAccomodation->EditAttrs["class"] = "form-control"; $this->idAccomodation->EditCustomAttributes = ""; $this->idAccomodation->EditValue = $this->idAccomodation->CurrentValue; $this->idAccomodation->ViewCustomAttributes = ""; // idOfferer $this->idOfferer->EditAttrs["class"] = "form-control"; $this->idOfferer->EditCustomAttributes = ""; if ($this->idOfferer->getSessionValue() <> "") { $this->idOfferer->CurrentValue = $this->idOfferer->getSessionValue(); $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 = ""; } else { $this->idOfferer->EditValue = ew_HtmlEncode($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] = ew_HtmlEncode($rswrk->fields('DispFld')); $arwrk[2] = ew_HtmlEncode($rswrk->fields('Disp2Fld')); $arwrk[3] = ew_HtmlEncode($rswrk->fields('Disp3Fld')); $this->idOfferer->EditValue = $this->idOfferer->DisplayValue($arwrk); $rswrk->Close(); } else { $this->idOfferer->EditValue = ew_HtmlEncode($this->idOfferer->CurrentValue); } } else { $this->idOfferer->EditValue = NULL; } $this->idOfferer->PlaceHolder = ew_RemoveHtml($this->idOfferer->FldCaption()); } // Accom_Type $this->Accom_Type->EditAttrs["class"] = "form-control"; $this->Accom_Type->EditCustomAttributes = ""; if (trim(strval($this->Accom_Type->CurrentValue)) == "") { $sFilterWrk = "0=1"; } else { $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`, '' AS `SelectFilterFld`, '' AS `SelectFilterFld2`, '' AS `SelectFilterFld3`, '' AS `SelectFilterFld4` 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`, '' AS `SelectFilterFld`, '' AS `SelectFilterFld2`, '' AS `SelectFilterFld3`, '' AS `SelectFilterFld4` FROM `taccom_type`"; $sWhereWrk = ""; $this->Accom_Type->LookupFilters = array(); break; default: $sSqlWrk = "SELECT `Accom_Type`, `Description` AS `DispFld`, '' AS `Disp2Fld`, '' AS `Disp3Fld`, '' AS `Disp4Fld`, '' AS `SelectFilterFld`, '' AS `SelectFilterFld2`, '' AS `SelectFilterFld3`, '' AS `SelectFilterFld4` 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); $arwrk = ($rswrk) ? $rswrk->GetRows() : array(); if ($rswrk) $rswrk->Close(); $this->Accom_Type->EditValue = $arwrk; // Address $this->Address->EditAttrs["class"] = "form-control"; $this->Address->EditCustomAttributes = ""; $this->Address->EditValue = ew_HtmlEncode($this->Address->CurrentValue); $this->Address->PlaceHolder = ew_RemoveHtml($this->Address->FldCaption()); // Town $this->Town->EditAttrs["class"] = "form-control"; $this->Town->EditCustomAttributes = ""; $this->Town->EditValue = ew_HtmlEncode($this->Town->CurrentValue); $this->Town->PlaceHolder = ew_RemoveHtml($this->Town->FldCaption()); // District $this->District->EditAttrs["class"] = "form-control"; $this->District->EditCustomAttributes = ""; $this->District->EditValue = ew_HtmlEncode($this->District->CurrentValue); $this->District->PlaceHolder = ew_RemoveHtml($this->District->FldCaption()); // Region $this->Region->EditAttrs["class"] = "form-control"; $this->Region->EditCustomAttributes = ""; $this->Region->EditValue = ew_HtmlEncode($this->Region->CurrentValue); $this->Region->PlaceHolder = ew_RemoveHtml($this->Region->FldCaption()); // Beds $this->Beds->EditAttrs["class"] = "form-control"; $this->Beds->EditCustomAttributes = ""; $this->Beds->EditValue = ew_HtmlEncode($this->Beds->CurrentValue); $this->Beds->PlaceHolder = ew_RemoveHtml($this->Beds->FldCaption()); // Rooms $this->Rooms->EditAttrs["class"] = "form-control"; $this->Rooms->EditCustomAttributes = ""; $this->Rooms->EditValue = ew_HtmlEncode($this->Rooms->CurrentValue); $this->Rooms->PlaceHolder = ew_RemoveHtml($this->Rooms->FldCaption()); // Bathrooms $this->Bathrooms->EditAttrs["class"] = "form-control"; $this->Bathrooms->EditCustomAttributes = ""; $this->Bathrooms->EditValue = ew_HtmlEncode($this->Bathrooms->CurrentValue); $this->Bathrooms->PlaceHolder = ew_RemoveHtml($this->Bathrooms->FldCaption()); // Private_Kitchen $this->Private_Kitchen->EditCustomAttributes = ""; $this->Private_Kitchen->EditValue = $this->Private_Kitchen->Options(FALSE); // Auton_heating $this->Auton_heating->EditCustomAttributes = ""; $this->Auton_heating->EditValue = $this->Auton_heating->Options(FALSE); // Arch_barriers $this->Arch_barriers->EditCustomAttributes = ""; $this->Arch_barriers->EditValue = $this->Arch_barriers->Options(FALSE); // Furnisched $this->Furnisched->EditCustomAttributes = ""; $this->Furnisched->EditValue = $this->Furnisched->Options(FALSE); // Private_entrance $this->Private_entrance->EditCustomAttributes = ""; $this->Private_entrance->EditValue = $this->Private_entrance->Options(FALSE); // Time_restrictions $this->Time_restrictions->EditCustomAttributes = ""; $this->Time_restrictions->EditValue = $this->Time_restrictions->Options(FALSE); // Time_restr_from $this->Time_restr_from->EditAttrs["class"] = "form-control"; $this->Time_restr_from->EditCustomAttributes = ""; $this->Time_restr_from->EditValue = ew_HtmlEncode($this->Time_restr_from->CurrentValue); $this->Time_restr_from->PlaceHolder = ew_RemoveHtml($this->Time_restr_from->FldCaption()); // Time_restr_to $this->Time_restr_to->EditAttrs["class"] = "form-control"; $this->Time_restr_to->EditCustomAttributes = ""; $this->Time_restr_to->EditValue = ew_HtmlEncode($this->Time_restr_to->CurrentValue); $this->Time_restr_to->PlaceHolder = ew_RemoveHtml($this->Time_restr_to->FldCaption()); // Services_access $this->Services_access->EditCustomAttributes = ""; $this->Services_access->EditValue = $this->Services_access->Options(FALSE); // Available_from $this->Available_from->EditAttrs["class"] = "form-control"; $this->Available_from->EditCustomAttributes = ""; $this->Available_from->EditValue = ew_HtmlEncode(ew_FormatDateTime($this->Available_from->CurrentValue, 7)); $this->Available_from->PlaceHolder = ew_RemoveHtml($this->Available_from->FldCaption()); // Available_to $this->Available_to->EditAttrs["class"] = "form-control"; $this->Available_to->EditCustomAttributes = ""; $this->Available_to->EditValue = ew_HtmlEncode(ew_FormatDateTime($this->Available_to->CurrentValue, 7)); $this->Available_to->PlaceHolder = ew_RemoveHtml($this->Available_to->FldCaption()); // Rel_type $this->Rel_type->EditAttrs["class"] = "form-control"; $this->Rel_type->EditCustomAttributes = ""; if (trim(strval($this->Rel_type->CurrentValue)) == "") { $sFilterWrk = "0=1"; } else { $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`, '' AS `SelectFilterFld`, '' AS `SelectFilterFld2`, '' AS `SelectFilterFld3`, '' AS `SelectFilterFld4` 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`, '' AS `SelectFilterFld`, '' AS `SelectFilterFld2`, '' AS `SelectFilterFld3`, '' AS `SelectFilterFld4` FROM `trel_type`"; $sWhereWrk = ""; $this->Rel_type->LookupFilters = array(); break; default: $sSqlWrk = "SELECT `Rel_type`, `Description` AS `DispFld`, '' AS `Disp2Fld`, '' AS `Disp3Fld`, '' AS `Disp4Fld`, '' AS `SelectFilterFld`, '' AS `SelectFilterFld2`, '' AS `SelectFilterFld3`, '' AS `SelectFilterFld4` 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); $arwrk = ($rswrk) ? $rswrk->GetRows() : array(); if ($rswrk) $rswrk->Close(); $this->Rel_type->EditValue = $arwrk; // offer_woman $this->offer_woman->EditCustomAttributes = ""; $this->offer_woman->EditValue = $this->offer_woman->Options(FALSE); // offer_children $this->offer_children->EditCustomAttributes = ""; $this->offer_children->EditValue = $this->offer_children->Options(FALSE); // offer_family $this->offer_family->EditCustomAttributes = ""; $this->offer_family->EditValue = $this->offer_family->Options(FALSE); // offer_man $this->offer_man->EditCustomAttributes = ""; $this->offer_man->EditValue = $this->offer_man->Options(FALSE); // offer_elderly $this->offer_elderly->EditCustomAttributes = ""; $this->offer_elderly->EditValue = $this->offer_elderly->Options(FALSE); // offer_disabled $this->offer_disabled->EditCustomAttributes = ""; $this->offer_disabled->EditValue = $this->offer_disabled->Options(FALSE); // offer_sick $this->offer_sick->EditCustomAttributes = ""; $this->offer_sick->EditValue = $this->offer_sick->Options(FALSE); // offer_christian $this->offer_christian->EditCustomAttributes = ""; $this->offer_christian->EditValue = $this->offer_christian->Options(FALSE); // offer_muslim $this->offer_muslim->EditCustomAttributes = ""; $this->offer_muslim->EditValue = $this->offer_muslim->Options(FALSE); // offer_other $this->offer_other->EditAttrs["class"] = "form-control"; $this->offer_other->EditCustomAttributes = ""; $this->offer_other->EditValue = ew_HtmlEncode($this->offer_other->CurrentValue); $this->offer_other->PlaceHolder = ew_RemoveHtml($this->offer_other->FldCaption()); // verify_date $this->verify_date->EditAttrs["class"] = "form-control"; $this->verify_date->EditCustomAttributes = ""; $this->verify_date->EditValue = ew_HtmlEncode(ew_FormatDateTime($this->verify_date->CurrentValue, 7)); $this->verify_date->PlaceHolder = ew_RemoveHtml($this->verify_date->FldCaption()); // verify_by $this->verify_by->EditAttrs["class"] = "form-control"; $this->verify_by->EditCustomAttributes = ""; $this->verify_by->EditValue = ew_HtmlEncode($this->verify_by->CurrentValue); $this->verify_by->PlaceHolder = ew_RemoveHtml($this->verify_by->FldCaption()); // verify_phone $this->verify_phone->EditAttrs["class"] = "form-control"; $this->verify_phone->EditCustomAttributes = ""; $this->verify_phone->EditValue = ew_HtmlEncode($this->verify_phone->CurrentValue); $this->verify_phone->PlaceHolder = ew_RemoveHtml($this->verify_phone->FldCaption()); // verify_email $this->verify_email->EditAttrs["class"] = "form-control"; $this->verify_email->EditCustomAttributes = ""; $this->verify_email->EditValue = ew_HtmlEncode($this->verify_email->CurrentValue); $this->verify_email->PlaceHolder = ew_RemoveHtml($this->verify_email->FldCaption()); // Outcome $this->Outcome->EditAttrs["class"] = "form-control"; $this->Outcome->EditCustomAttributes = ""; if (trim(strval($this->Outcome->CurrentValue)) == "") { $sFilterWrk = "0=1"; } else { $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`, '' AS `SelectFilterFld`, '' AS `SelectFilterFld2`, '' AS `SelectFilterFld3`, '' AS `SelectFilterFld4` FROM `toutcome`"; $sWhereWrk = ""; $this->Outcome->LookupFilters = array(); break; case "it": $sSqlWrk = "SELECT `Outcome`, `Description_it` AS `DispFld`, '' AS `Disp2Fld`, '' AS `Disp3Fld`, '' AS `Disp4Fld`, '' AS `SelectFilterFld`, '' AS `SelectFilterFld2`, '' AS `SelectFilterFld3`, '' AS `SelectFilterFld4` FROM `toutcome`"; $sWhereWrk = ""; $this->Outcome->LookupFilters = array(); break; default: $sSqlWrk = "SELECT `Outcome`, `Description` AS `DispFld`, '' AS `Disp2Fld`, '' AS `Disp3Fld`, '' AS `Disp4Fld`, '' AS `SelectFilterFld`, '' AS `SelectFilterFld2`, '' AS `SelectFilterFld3`, '' AS `SelectFilterFld4` 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); $arwrk = ($rswrk) ? $rswrk->GetRows() : array(); if ($rswrk) $rswrk->Close(); $this->Outcome->EditValue = $arwrk; // Outcome_type $this->Outcome_type->EditAttrs["class"] = "form-control"; $this->Outcome_type->EditCustomAttributes = ""; if (trim(strval($this->Outcome_type->CurrentValue)) == "") { $sFilterWrk = "0=1"; } else { $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`, '' AS `SelectFilterFld`, '' AS `SelectFilterFld2`, '' AS `SelectFilterFld3`, '' AS `SelectFilterFld4` 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`, '' AS `SelectFilterFld`, '' AS `SelectFilterFld2`, '' AS `SelectFilterFld3`, '' AS `SelectFilterFld4` FROM `toutcometype`"; $sWhereWrk = ""; $this->Outcome_type->LookupFilters = array(); break; default: $sSqlWrk = "SELECT `Outcome_type`, `Description` AS `DispFld`, '' AS `Disp2Fld`, '' AS `Disp3Fld`, '' AS `Disp4Fld`, '' AS `SelectFilterFld`, '' AS `SelectFilterFld2`, '' AS `SelectFilterFld3`, '' AS `SelectFilterFld4` 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); $arwrk = ($rswrk) ? $rswrk->GetRows() : array(); if ($rswrk) $rswrk->Close(); $this->Outcome_type->EditValue = $arwrk; // Rel_doc $this->Rel_doc->EditAttrs["class"] = "form-control"; $this->Rel_doc->EditCustomAttributes = ""; $this->Rel_doc->UploadPath = "uploads/accom/".$this->idAccomodation->DbValue; if (!ew_Empty($this->Rel_doc->Upload->DbValue)) { $this->Rel_doc->EditValue = $this->Rel_doc->Upload->DbValue; } else { $this->Rel_doc->EditValue = ""; } if (!ew_Empty($this->Rel_doc->CurrentValue)) $this->Rel_doc->Upload->FileName = $this->Rel_doc->CurrentValue; if ($this->CurrentAction == "I" && !$this->EventCancelled) ew_RenderUploadField($this->Rel_doc); // Edit refer script // idAccomodation $this->idAccomodation->LinkCustomAttributes = ""; $this->idAccomodation->HrefValue = ""; // 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 = ""; } // Accom_Type $this->Accom_Type->LinkCustomAttributes = ""; $this->Accom_Type->HrefValue = ""; // Address $this->Address->LinkCustomAttributes = ""; $this->Address->HrefValue = ""; // Town $this->Town->LinkCustomAttributes = ""; $this->Town->HrefValue = ""; // District $this->District->LinkCustomAttributes = ""; $this->District->HrefValue = ""; // Region $this->Region->LinkCustomAttributes = ""; $this->Region->HrefValue = ""; // Beds $this->Beds->LinkCustomAttributes = ""; $this->Beds->HrefValue = ""; // Rooms $this->Rooms->LinkCustomAttributes = ""; $this->Rooms->HrefValue = ""; // Bathrooms $this->Bathrooms->LinkCustomAttributes = ""; $this->Bathrooms->HrefValue = ""; // Private_Kitchen $this->Private_Kitchen->LinkCustomAttributes = ""; $this->Private_Kitchen->HrefValue = ""; // Auton_heating $this->Auton_heating->LinkCustomAttributes = ""; $this->Auton_heating->HrefValue = ""; // Arch_barriers $this->Arch_barriers->LinkCustomAttributes = ""; $this->Arch_barriers->HrefValue = ""; // Furnisched $this->Furnisched->LinkCustomAttributes = ""; $this->Furnisched->HrefValue = ""; // Private_entrance $this->Private_entrance->LinkCustomAttributes = ""; $this->Private_entrance->HrefValue = ""; // Time_restrictions $this->Time_restrictions->LinkCustomAttributes = ""; $this->Time_restrictions->HrefValue = ""; // Time_restr_from $this->Time_restr_from->LinkCustomAttributes = ""; $this->Time_restr_from->HrefValue = ""; // Time_restr_to $this->Time_restr_to->LinkCustomAttributes = ""; $this->Time_restr_to->HrefValue = ""; // Services_access $this->Services_access->LinkCustomAttributes = ""; $this->Services_access->HrefValue = ""; // Available_from $this->Available_from->LinkCustomAttributes = ""; $this->Available_from->HrefValue = ""; // Available_to $this->Available_to->LinkCustomAttributes = ""; $this->Available_to->HrefValue = ""; // Rel_type $this->Rel_type->LinkCustomAttributes = ""; $this->Rel_type->HrefValue = ""; // offer_woman $this->offer_woman->LinkCustomAttributes = ""; $this->offer_woman->HrefValue = ""; // offer_children $this->offer_children->LinkCustomAttributes = ""; $this->offer_children->HrefValue = ""; // offer_family $this->offer_family->LinkCustomAttributes = ""; $this->offer_family->HrefValue = ""; // offer_man $this->offer_man->LinkCustomAttributes = ""; $this->offer_man->HrefValue = ""; // offer_elderly $this->offer_elderly->LinkCustomAttributes = ""; $this->offer_elderly->HrefValue = ""; // offer_disabled $this->offer_disabled->LinkCustomAttributes = ""; $this->offer_disabled->HrefValue = ""; // offer_sick $this->offer_sick->LinkCustomAttributes = ""; $this->offer_sick->HrefValue = ""; // offer_christian $this->offer_christian->LinkCustomAttributes = ""; $this->offer_christian->HrefValue = ""; // offer_muslim $this->offer_muslim->LinkCustomAttributes = ""; $this->offer_muslim->HrefValue = ""; // offer_other $this->offer_other->LinkCustomAttributes = ""; $this->offer_other->HrefValue = ""; // verify_date $this->verify_date->LinkCustomAttributes = ""; $this->verify_date->HrefValue = ""; // verify_by $this->verify_by->LinkCustomAttributes = ""; $this->verify_by->HrefValue = ""; // verify_phone $this->verify_phone->LinkCustomAttributes = ""; $this->verify_phone->HrefValue = ""; // verify_email $this->verify_email->LinkCustomAttributes = ""; $this->verify_email->HrefValue = ""; // Outcome $this->Outcome->LinkCustomAttributes = ""; $this->Outcome->HrefValue = ""; // Outcome_type $this->Outcome_type->LinkCustomAttributes = ""; $this->Outcome_type->HrefValue = ""; // 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; } if ($this->RowType == EW_ROWTYPE_ADD || $this->RowType == EW_ROWTYPE_EDIT || $this->RowType == EW_ROWTYPE_SEARCH) { // Add / Edit / Search row $this->SetupFieldTitles(); } // Call Row Rendered event if ($this->RowType <> EW_ROWTYPE_AGGREGATEINIT) $this->Row_Rendered(); } // Validate form function ValidateForm() { global $Language, $gsFormError; // Initialize form error message $gsFormError = ""; // Check if validation required if (!EW_SERVER_VALIDATE) return ($gsFormError == ""); if (!$this->idOfferer->FldIsDetailKey && !is_null($this->idOfferer->FormValue) && $this->idOfferer->FormValue == "") { ew_AddMessage($gsFormError, str_replace("%s", $this->idOfferer->FldCaption(), $this->idOfferer->ReqErrMsg)); } if (!ew_CheckInteger($this->idOfferer->FormValue)) { ew_AddMessage($gsFormError, $this->idOfferer->FldErrMsg()); } if (!ew_CheckInteger($this->Beds->FormValue)) { ew_AddMessage($gsFormError, $this->Beds->FldErrMsg()); } if (!ew_CheckInteger($this->Rooms->FormValue)) { ew_AddMessage($gsFormError, $this->Rooms->FldErrMsg()); } if (!ew_CheckInteger($this->Bathrooms->FormValue)) { ew_AddMessage($gsFormError, $this->Bathrooms->FldErrMsg()); } if (!ew_CheckTime($this->Time_restr_from->FormValue)) { ew_AddMessage($gsFormError, $this->Time_restr_from->FldErrMsg()); } if (!ew_CheckTime($this->Time_restr_to->FormValue)) { ew_AddMessage($gsFormError, $this->Time_restr_to->FldErrMsg()); } if (!ew_CheckEuroDate($this->Available_from->FormValue)) { ew_AddMessage($gsFormError, $this->Available_from->FldErrMsg()); } if (!ew_CheckEuroDate($this->Available_to->FormValue)) { ew_AddMessage($gsFormError, $this->Available_to->FldErrMsg()); } if (!ew_CheckEuroDate($this->verify_date->FormValue)) { ew_AddMessage($gsFormError, $this->verify_date->FldErrMsg()); } // Validate detail grid $DetailTblVar = explode(",", $this->getCurrentDetailTable()); if (in_array("tassigment", $DetailTblVar) && $GLOBALS["tassigment"]->DetailEdit) { if (!isset($GLOBALS["tassigment_grid"])) $GLOBALS["tassigment_grid"] = new ctassigment_grid(); // get detail page object $GLOBALS["tassigment_grid"]->ValidateGridForm(); } // Return validate result $ValidateForm = ($gsFormError == ""); // Call Form_CustomValidate event $sFormCustomError = ""; $ValidateForm = $ValidateForm && $this->Form_CustomValidate($sFormCustomError); if ($sFormCustomError <> "") { ew_AddMessage($gsFormError, $sFormCustomError); } return $ValidateForm; } // Update record based on key values function EditRow() { global $Security, $Language; $sFilter = $this->KeyFilter(); $sFilter = $this->ApplyUserIDFilters($sFilter); $conn = &$this->Connection(); $this->CurrentFilter = $sFilter; $sSql = $this->SQL(); $conn->raiseErrorFn = $GLOBALS["EW_ERROR_FN"]; $rs = $conn->Execute($sSql); $conn->raiseErrorFn = ''; if ($rs === FALSE) return FALSE; if ($rs->EOF) { $this->setFailureMessage($Language->Phrase("NoRecord")); // Set no record message $EditRow = FALSE; // Update Failed } else { // Begin transaction if ($this->getCurrentDetailTable() <> "") $conn->BeginTrans(); // Save old values $rsold = &$rs->fields; $this->LoadDbValues($rsold); $this->Rel_doc->OldUploadPath = "uploads/accom/".$this->idAccomodation->DbValue; $this->Rel_doc->UploadPath = $this->Rel_doc->OldUploadPath; $rsnew = array(); // idOfferer $this->idOfferer->SetDbValueDef($rsnew, $this->idOfferer->CurrentValue, 0, $this->idOfferer->ReadOnly); // Accom_Type $this->Accom_Type->SetDbValueDef($rsnew, $this->Accom_Type->CurrentValue, NULL, $this->Accom_Type->ReadOnly); // Address $this->Address->SetDbValueDef($rsnew, $this->Address->CurrentValue, NULL, $this->Address->ReadOnly); // Town $this->Town->SetDbValueDef($rsnew, $this->Town->CurrentValue, NULL, $this->Town->ReadOnly); // District $this->District->SetDbValueDef($rsnew, $this->District->CurrentValue, NULL, $this->District->ReadOnly); // Region $this->Region->SetDbValueDef($rsnew, $this->Region->CurrentValue, NULL, $this->Region->ReadOnly); // Beds $this->Beds->SetDbValueDef($rsnew, $this->Beds->CurrentValue, NULL, $this->Beds->ReadOnly); // Rooms $this->Rooms->SetDbValueDef($rsnew, $this->Rooms->CurrentValue, NULL, $this->Rooms->ReadOnly); // Bathrooms $this->Bathrooms->SetDbValueDef($rsnew, $this->Bathrooms->CurrentValue, NULL, $this->Bathrooms->ReadOnly); // Private_Kitchen $this->Private_Kitchen->SetDbValueDef($rsnew, ((strval($this->Private_Kitchen->CurrentValue) == "Y") ? "Y" : "N"), NULL, $this->Private_Kitchen->ReadOnly); // Auton_heating $this->Auton_heating->SetDbValueDef($rsnew, ((strval($this->Auton_heating->CurrentValue) == "Y") ? "Y" : "N"), NULL, $this->Auton_heating->ReadOnly); // Arch_barriers $this->Arch_barriers->SetDbValueDef($rsnew, ((strval($this->Arch_barriers->CurrentValue) == "Y") ? "Y" : "N"), NULL, $this->Arch_barriers->ReadOnly); // Furnisched $this->Furnisched->SetDbValueDef($rsnew, ((strval($this->Furnisched->CurrentValue) == "Y") ? "Y" : "N"), NULL, $this->Furnisched->ReadOnly); // Private_entrance $this->Private_entrance->SetDbValueDef($rsnew, ((strval($this->Private_entrance->CurrentValue) == "Y") ? "Y" : "N"), NULL, $this->Private_entrance->ReadOnly); // Time_restrictions $this->Time_restrictions->SetDbValueDef($rsnew, ((strval($this->Time_restrictions->CurrentValue) == "Y") ? "Y" : "N"), NULL, $this->Time_restrictions->ReadOnly); // Time_restr_from $this->Time_restr_from->SetDbValueDef($rsnew, $this->Time_restr_from->CurrentValue, NULL, $this->Time_restr_from->ReadOnly); // Time_restr_to $this->Time_restr_to->SetDbValueDef($rsnew, $this->Time_restr_to->CurrentValue, NULL, $this->Time_restr_to->ReadOnly); // Services_access $this->Services_access->SetDbValueDef($rsnew, ((strval($this->Services_access->CurrentValue) == "Y") ? "Y" : "N"), NULL, $this->Services_access->ReadOnly); // Available_from $this->Available_from->SetDbValueDef($rsnew, ew_UnFormatDateTime($this->Available_from->CurrentValue, 7), NULL, $this->Available_from->ReadOnly); // Available_to $this->Available_to->SetDbValueDef($rsnew, ew_UnFormatDateTime($this->Available_to->CurrentValue, 7), NULL, $this->Available_to->ReadOnly); // Rel_type $this->Rel_type->SetDbValueDef($rsnew, $this->Rel_type->CurrentValue, NULL, $this->Rel_type->ReadOnly); // offer_woman $this->offer_woman->SetDbValueDef($rsnew, ((strval($this->offer_woman->CurrentValue) == "Y") ? "Y" : "N"), NULL, $this->offer_woman->ReadOnly); // offer_children $this->offer_children->SetDbValueDef($rsnew, ((strval($this->offer_children->CurrentValue) == "Y") ? "Y" : "N"), NULL, $this->offer_children->ReadOnly); // offer_family $this->offer_family->SetDbValueDef($rsnew, ((strval($this->offer_family->CurrentValue) == "Y") ? "Y" : "N"), NULL, $this->offer_family->ReadOnly); // offer_man $this->offer_man->SetDbValueDef($rsnew, ((strval($this->offer_man->CurrentValue) == "Y") ? "Y" : "N"), NULL, $this->offer_man->ReadOnly); // offer_elderly $this->offer_elderly->SetDbValueDef($rsnew, ((strval($this->offer_elderly->CurrentValue) == "Y") ? "Y" : "N"), NULL, $this->offer_elderly->ReadOnly); // offer_disabled $this->offer_disabled->SetDbValueDef($rsnew, ((strval($this->offer_disabled->CurrentValue) == "Y") ? "Y" : "N"), NULL, $this->offer_disabled->ReadOnly); // offer_sick $this->offer_sick->SetDbValueDef($rsnew, ((strval($this->offer_sick->CurrentValue) == "Y") ? "Y" : "N"), NULL, $this->offer_sick->ReadOnly); // offer_christian $this->offer_christian->SetDbValueDef($rsnew, ((strval($this->offer_christian->CurrentValue) == "Y") ? "Y" : "N"), NULL, $this->offer_christian->ReadOnly); // offer_muslim $this->offer_muslim->SetDbValueDef($rsnew, ((strval($this->offer_muslim->CurrentValue) == "Y") ? "Y" : "N"), NULL, $this->offer_muslim->ReadOnly); // offer_other $this->offer_other->SetDbValueDef($rsnew, $this->offer_other->CurrentValue, NULL, $this->offer_other->ReadOnly); // verify_date $this->verify_date->SetDbValueDef($rsnew, ew_UnFormatDateTime($this->verify_date->CurrentValue, 7), NULL, $this->verify_date->ReadOnly); // verify_by $this->verify_by->SetDbValueDef($rsnew, $this->verify_by->CurrentValue, NULL, $this->verify_by->ReadOnly); // verify_phone $this->verify_phone->SetDbValueDef($rsnew, $this->verify_phone->CurrentValue, NULL, $this->verify_phone->ReadOnly); // verify_email $this->verify_email->SetDbValueDef($rsnew, $this->verify_email->CurrentValue, NULL, $this->verify_email->ReadOnly); // Outcome $this->Outcome->SetDbValueDef($rsnew, $this->Outcome->CurrentValue, NULL, $this->Outcome->ReadOnly); // Outcome_type $this->Outcome_type->SetDbValueDef($rsnew, $this->Outcome_type->CurrentValue, NULL, $this->Outcome_type->ReadOnly); // Rel_doc if ($this->Rel_doc->Visible && !$this->Rel_doc->ReadOnly && !$this->Rel_doc->Upload->KeepFile) { $this->Rel_doc->Upload->DbValue = $rsold['Rel_doc']; // Get original value if ($this->Rel_doc->Upload->FileName == "") { $rsnew['Rel_doc'] = NULL; } else { $rsnew['Rel_doc'] = $this->Rel_doc->Upload->FileName; } $this->Rel_doc_type->SetDbValueDef($rsnew, trim($this->Rel_doc->Upload->ContentType), NULL, FALSE); $this->Rel_doc_size->SetDbValueDef($rsnew, $this->Rel_doc->Upload->FileSize, NULL, FALSE); } // Check referential integrity for master table 'tofferers' $bValidMasterRecord = TRUE; $sMasterFilter = $this->SqlMasterFilter_tofferers(); $KeyValue = isset($rsnew['idOfferer']) ? $rsnew['idOfferer'] : $rsold['idOfferer']; if (strval($KeyValue) <> "") { $sMasterFilter = str_replace("@idOfferer@", ew_AdjustSql($KeyValue), $sMasterFilter); } else { $bValidMasterRecord = FALSE; } if ($bValidMasterRecord) { if (!isset($GLOBALS["tofferers"])) $GLOBALS["tofferers"] = new ctofferers(); $rsmaster = $GLOBALS["tofferers"]->LoadRs($sMasterFilter); $bValidMasterRecord = ($rsmaster && !$rsmaster->EOF); $rsmaster->Close(); } if (!$bValidMasterRecord) { $sRelatedRecordMsg = str_replace("%t", "tofferers", $Language->Phrase("RelatedRecordRequired")); $this->setFailureMessage($sRelatedRecordMsg); $rs->Close(); return FALSE; } if ($this->Rel_doc->Visible && !$this->Rel_doc->Upload->KeepFile) { $this->Rel_doc->UploadPath = "uploads/accom/".$this->idAccomodation->DbValue; $OldFiles = explode(EW_MULTIPLE_UPLOAD_SEPARATOR, $this->Rel_doc->Upload->DbValue); if (!ew_Empty($this->Rel_doc->Upload->FileName)) { $NewFiles = explode(EW_MULTIPLE_UPLOAD_SEPARATOR, $this->Rel_doc->Upload->FileName); $FileCount = count($NewFiles); for ($i = 0; $i < $FileCount; $i++) { $fldvar = ($this->Rel_doc->Upload->Index < 0) ? $this->Rel_doc->FldVar : substr($this->Rel_doc->FldVar, 0, 1) . $this->Rel_doc->Upload->Index . substr($this->Rel_doc->FldVar, 1); if ($NewFiles[$i] <> "") { $file = $NewFiles[$i]; if (file_exists(ew_UploadTempPath($fldvar, $this->Rel_doc->TblVar) . EW_PATH_DELIMITER . $file)) { if (!in_array($file, $OldFiles)) { $file1 = ew_UploadFileNameEx(ew_UploadPathEx(TRUE, $this->Rel_doc->UploadPath), $file); // Get new file name if ($file1 <> $file) { // Rename temp file while (file_exists(ew_UploadTempPath($fldvar, $this->Rel_doc->TblVar) . EW_PATH_DELIMITER . $file1)) // Make sure did not clash with existing upload file $file1 = ew_UniqueFilename(ew_UploadPathEx(TRUE, $this->Rel_doc->UploadPath), $file1, TRUE); // Use indexed name rename(ew_UploadTempPath($fldvar, $this->Rel_doc->TblVar) . EW_PATH_DELIMITER . $file, ew_UploadTempPath($fldvar, $this->Rel_doc->TblVar) . EW_PATH_DELIMITER . $file1); $NewFiles[$i] = $file1; } } } } } $this->Rel_doc->Upload->FileName = implode(EW_MULTIPLE_UPLOAD_SEPARATOR, $NewFiles); $rsnew['Rel_doc'] = $this->Rel_doc->Upload->FileName; } else { $NewFiles = array(); } } // Call Row Updating event $bUpdateRow = $this->Row_Updating($rsold, $rsnew); if ($bUpdateRow) { $conn->raiseErrorFn = $GLOBALS["EW_ERROR_FN"]; if (count($rsnew) > 0) $EditRow = $this->Update($rsnew, "", $rsold); else $EditRow = TRUE; // No field to update $conn->raiseErrorFn = ''; if ($EditRow) { if ($this->Rel_doc->Visible && !$this->Rel_doc->Upload->KeepFile) { $OldFiles = explode(EW_MULTIPLE_UPLOAD_SEPARATOR, $this->Rel_doc->Upload->DbValue); if (!ew_Empty($this->Rel_doc->Upload->FileName)) { $NewFiles = explode(EW_MULTIPLE_UPLOAD_SEPARATOR, $this->Rel_doc->Upload->FileName); $NewFiles2 = explode(EW_MULTIPLE_UPLOAD_SEPARATOR, $rsnew['Rel_doc']); $FileCount = count($NewFiles); for ($i = 0; $i < $FileCount; $i++) { $fldvar = ($this->Rel_doc->Upload->Index < 0) ? $this->Rel_doc->FldVar : substr($this->Rel_doc->FldVar, 0, 1) . $this->Rel_doc->Upload->Index . substr($this->Rel_doc->FldVar, 1); if ($NewFiles[$i] <> "") { $file = ew_UploadTempPath($fldvar, $this->Rel_doc->TblVar) . EW_PATH_DELIMITER . $NewFiles[$i]; if (file_exists($file)) { if (!$this->Rel_doc->Upload->SaveToFile($this->Rel_doc->UploadPath, (@$NewFiles2[$i] <> "") ? $NewFiles2[$i] : $NewFiles[$i], TRUE, $i)) { // Just replace $this->setFailureMessage($Language->Phrase("UploadErrMsg7")); return FALSE; } } } } } else { $NewFiles = array(); } } } // Update detail records $DetailTblVar = explode(",", $this->getCurrentDetailTable()); if ($EditRow) { if (in_array("tassigment", $DetailTblVar) && $GLOBALS["tassigment"]->DetailEdit) { if (!isset($GLOBALS["tassigment_grid"])) $GLOBALS["tassigment_grid"] = new ctassigment_grid(); // Get detail page object $Security->LoadCurrentUserLevel($this->ProjectID . "tassigment"); // Load user level of detail table $EditRow = $GLOBALS["tassigment_grid"]->GridUpdate(); $Security->LoadCurrentUserLevel($this->ProjectID . $this->TableName); // Restore user level of master table } } // Commit/Rollback transaction if ($this->getCurrentDetailTable() <> "") { if ($EditRow) { $conn->CommitTrans(); // Commit transaction } else { $conn->RollbackTrans(); // Rollback transaction } } } else { if ($this->getSuccessMessage() <> "" || $this->getFailureMessage() <> "") { // Use the message, do nothing } elseif ($this->CancelMessage <> "") { $this->setFailureMessage($this->CancelMessage); $this->CancelMessage = ""; } else { $this->setFailureMessage($Language->Phrase("UpdateCancelled")); } $EditRow = FALSE; } } // Call Row_Updated event if ($EditRow) $this->Row_Updated($rsold, $rsnew); $rs->Close(); // Rel_doc ew_CleanUploadTempPath($this->Rel_doc, $this->Rel_doc->Upload->Index); return $EditRow; } // 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"]->DetailEdit) { $GLOBALS["tassigment_grid"]->CurrentMode = "edit"; $GLOBALS["tassigment_grid"]->CurrentAction = "gridedit"; // 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 = "edit"; $Breadcrumb->Add("edit", $PageId, $url); } // Setup lookup filters of a field function SetupLookupFilters($fld, $pageId = null) { global $gsLanguage; $pageId = $pageId ?: $this->PageID; switch ($fld->FldVar) { case "x_idOfferer": $sSqlWrk = ""; switch (@$gsLanguage) { case "en": $sSqlWrk = "SELECT `idOfferer` AS `LinkFld`, `Name` AS `DispFld`, `Surname` AS `Disp2Fld`, `Institution_Name` AS `Disp3Fld`, '' AS `Disp4Fld` FROM `tofferers`"; $sWhereWrk = "{filter}"; $this->idOfferer->LookupFilters = array(); break; case "it": $sSqlWrk = "SELECT `idOfferer` AS `LinkFld`, `Name` AS `DispFld`, `Surname` AS `Disp2Fld`, `Institution_Name` AS `Disp3Fld`, '' AS `Disp4Fld` FROM `tofferers`"; $sWhereWrk = "{filter}"; $this->idOfferer->LookupFilters = array(); break; default: $sSqlWrk = "SELECT `idOfferer` AS `LinkFld`, `Name` AS `DispFld`, `Surname` AS `Disp2Fld`, `Institution_Name` AS `Disp3Fld`, '' AS `Disp4Fld` FROM `tofferers`"; $sWhereWrk = "{filter}"; $this->idOfferer->LookupFilters = array(); break; } $fld->LookupFilters += array("s" => $sSqlWrk, "d" => "", "f0" => '`idOfferer` = {filter_value}', "t0" => "3", "fn0" => ""); $sSqlWrk = ""; $this->Lookup_Selecting($this->idOfferer, $sWhereWrk); // Call Lookup selecting if ($sWhereWrk <> "") $sSqlWrk .= " WHERE " . $sWhereWrk; if ($sSqlWrk <> "") $fld->LookupFilters["s"] .= $sSqlWrk; break; case "x_Accom_Type": $sSqlWrk = ""; switch (@$gsLanguage) { case "en": $sSqlWrk = "SELECT `Accom_Type` AS `LinkFld`, `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` AS `LinkFld`, `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` AS `LinkFld`, `Description` AS `DispFld`, '' AS `Disp2Fld`, '' AS `Disp3Fld`, '' AS `Disp4Fld` FROM `taccom_type`"; $sWhereWrk = ""; $this->Accom_Type->LookupFilters = array(); break; } $fld->LookupFilters += array("s" => $sSqlWrk, "d" => "", "f0" => '`Accom_Type` = {filter_value}', "t0" => "200", "fn0" => ""); $sSqlWrk = ""; $this->Lookup_Selecting($this->Accom_Type, $sWhereWrk); // Call Lookup selecting if ($sWhereWrk <> "") $sSqlWrk .= " WHERE " . $sWhereWrk; if ($sSqlWrk <> "") $fld->LookupFilters["s"] .= $sSqlWrk; break; case "x_Rel_type": $sSqlWrk = ""; switch (@$gsLanguage) { case "en": $sSqlWrk = "SELECT `Rel_type` AS `LinkFld`, `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` AS `LinkFld`, `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` AS `LinkFld`, `Description` AS `DispFld`, '' AS `Disp2Fld`, '' AS `Disp3Fld`, '' AS `Disp4Fld` FROM `trel_type`"; $sWhereWrk = ""; $this->Rel_type->LookupFilters = array(); break; } $fld->LookupFilters += array("s" => $sSqlWrk, "d" => "", "f0" => '`Rel_type` = {filter_value}', "t0" => "200", "fn0" => ""); $sSqlWrk = ""; $this->Lookup_Selecting($this->Rel_type, $sWhereWrk); // Call Lookup selecting if ($sWhereWrk <> "") $sSqlWrk .= " WHERE " . $sWhereWrk; if ($sSqlWrk <> "") $fld->LookupFilters["s"] .= $sSqlWrk; break; case "x_Outcome": $sSqlWrk = ""; switch (@$gsLanguage) { case "en": $sSqlWrk = "SELECT `Outcome` AS `LinkFld`, `Description` AS `DispFld`, '' AS `Disp2Fld`, '' AS `Disp3Fld`, '' AS `Disp4Fld` FROM `toutcome`"; $sWhereWrk = ""; $this->Outcome->LookupFilters = array(); break; case "it": $sSqlWrk = "SELECT `Outcome` AS `LinkFld`, `Description_it` AS `DispFld`, '' AS `Disp2Fld`, '' AS `Disp3Fld`, '' AS `Disp4Fld` FROM `toutcome`"; $sWhereWrk = ""; $this->Outcome->LookupFilters = array(); break; default: $sSqlWrk = "SELECT `Outcome` AS `LinkFld`, `Description` AS `DispFld`, '' AS `Disp2Fld`, '' AS `Disp3Fld`, '' AS `Disp4Fld` FROM `toutcome`"; $sWhereWrk = ""; $this->Outcome->LookupFilters = array(); break; } $fld->LookupFilters += array("s" => $sSqlWrk, "d" => "", "f0" => '`Outcome` = {filter_value}', "t0" => "200", "fn0" => ""); $sSqlWrk = ""; $this->Lookup_Selecting($this->Outcome, $sWhereWrk); // Call Lookup selecting if ($sWhereWrk <> "") $sSqlWrk .= " WHERE " . $sWhereWrk; if ($sSqlWrk <> "") $fld->LookupFilters["s"] .= $sSqlWrk; break; case "x_Outcome_type": $sSqlWrk = ""; switch (@$gsLanguage) { case "en": $sSqlWrk = "SELECT `Outcome_type` AS `LinkFld`, `Description` AS `DispFld`, '' AS `Disp2Fld`, '' AS `Disp3Fld`, '' AS `Disp4Fld` FROM `toutcometype`"; $sWhereWrk = ""; $this->Outcome_type->LookupFilters = array(); break; case "it": $sSqlWrk = "SELECT `Outcome_type` AS `LinkFld`, `Description_it` AS `DispFld`, '' AS `Disp2Fld`, '' AS `Disp3Fld`, '' AS `Disp4Fld` FROM `toutcometype`"; $sWhereWrk = ""; $this->Outcome_type->LookupFilters = array(); break; default: $sSqlWrk = "SELECT `Outcome_type` AS `LinkFld`, `Description` AS `DispFld`, '' AS `Disp2Fld`, '' AS `Disp3Fld`, '' AS `Disp4Fld` FROM `toutcometype`"; $sWhereWrk = ""; $this->Outcome_type->LookupFilters = array(); break; } $fld->LookupFilters += array("s" => $sSqlWrk, "d" => "", "f0" => '`Outcome_type` = {filter_value}', "t0" => "200", "fn0" => ""); $sSqlWrk = ""; $this->Lookup_Selecting($this->Outcome_type, $sWhereWrk); // Call Lookup selecting if ($sWhereWrk <> "") $sSqlWrk .= " WHERE " . $sWhereWrk; if ($sSqlWrk <> "") $fld->LookupFilters["s"] .= $sSqlWrk; break; } } // Setup AutoSuggest filters of a field function SetupAutoSuggestFilters($fld, $pageId = null) { global $gsLanguage; $pageId = $pageId ?: $this->PageID; switch ($fld->FldVar) { case "x_idOfferer": $sSqlWrk = ""; switch (@$gsLanguage) { case "en": $sSqlWrk = "SELECT `idOfferer`, `Name` AS `DispFld`, `Surname` AS `Disp2Fld`, `Institution_Name` AS `Disp3Fld` FROM `tofferers`"; $sWhereWrk = "`Name` LIKE '{query_value}%' OR CONCAT(`Name`,'" . ew_ValueSeparator(1, $this->idOfferer) . "',`Surname`,'" . ew_ValueSeparator(2, $this->idOfferer) . "',`Institution_Name`) LIKE '{query_value}%'"; $this->idOfferer->LookupFilters = array(); break; case "it": $sSqlWrk = "SELECT `idOfferer`, `Name` AS `DispFld`, `Surname` AS `Disp2Fld`, `Institution_Name` AS `Disp3Fld` FROM `tofferers`"; $sWhereWrk = "`Name` LIKE '{query_value}%' OR CONCAT(`Name`,'" . ew_ValueSeparator(1, $this->idOfferer) . "',`Surname`,'" . ew_ValueSeparator(2, $this->idOfferer) . "',`Institution_Name`) LIKE '{query_value}%'"; $this->idOfferer->LookupFilters = array(); break; default: $sSqlWrk = "SELECT `idOfferer`, `Name` AS `DispFld`, `Surname` AS `Disp2Fld`, `Institution_Name` AS `Disp3Fld` FROM `tofferers`"; $sWhereWrk = "`Name` LIKE '{query_value}%' OR CONCAT(`Name`,'" . ew_ValueSeparator(1, $this->idOfferer) . "',`Surname`,'" . ew_ValueSeparator(2, $this->idOfferer) . "',`Institution_Name`) LIKE '{query_value}%'"; $this->idOfferer->LookupFilters = array(); break; } $fld->LookupFilters += array("s" => $sSqlWrk, "d" => ""); $sSqlWrk = ""; $this->Lookup_Selecting($this->idOfferer, $sWhereWrk); // Call Lookup selecting if ($sWhereWrk <> "") $sSqlWrk .= " WHERE " . $sWhereWrk; $sSqlWrk .= " LIMIT " . EW_AUTO_SUGGEST_MAX_ENTRIES; if ($sSqlWrk <> "") $fld->LookupFilters["s"] .= $sSqlWrk; break; } } // 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"; } // Form Custom Validate event function Form_CustomValidate(&$CustomError) { // Return error message in CustomError return TRUE; } } ?> Page_Init(); // Page main $taccomodations_edit->Page_Main(); // Global Page Rendering event (in userfn*.php) Page_Rendering(); // Page Rendering event $taccomodations_edit->Page_Render(); ?> IsModal) { ?> ShowPageHeader(); ?> ShowMessage(); ?> IsModal) { ?> ShowPageFooter(); if (EW_DEBUG_ENABLED) echo ew_DebugMsg(); ?> Page_Terminate(); ?>