" . $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 (tofferers) if (!isset($GLOBALS["tofferers"]) || get_class($GLOBALS["tofferers"]) == "ctofferers") { $GLOBALS["tofferers"] = &$this; $GLOBALS["Table"] = &$GLOBALS["tofferers"]; } // Table object (users) if (!isset($GLOBALS['users'])) $GLOBALS['users'] = new cusers(); // Page ID if (!defined("EW_PAGE_ID")) define("EW_PAGE_ID", 'add', TRUE); // Table name (for backward compatibility) if (!defined("EW_TABLE_NAME")) define("EW_TABLE_NAME", 'tofferers', 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->CanAdd()) { $Security->SaveLastUrl(); $this->setFailureMessage(ew_DeniedMsg()); // Set no permission if ($Security->CanList()) $this->Page_Terminate(ew_GetUrl("toffererslist.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->Name->SetVisibility(); $this->Surname->SetVisibility(); $this->Institution_Type->SetVisibility(); $this->Institution_Name->SetVisibility(); $this->Address->SetVisibility(); $this->Phone->SetVisibility(); $this->Phone_Mobile->SetVisibility(); $this->_Email->SetVisibility(); $this->Town->SetVisibility(); $this->District->SetVisibility(); $this->Region->SetVisibility(); $this->Suggest_by->SetVisibility(); $this->Suggest_by_note->SetVisibility(); $this->Referent->SetVisibility(); $this->add_documents->SetVisibility(); $this->add_care->SetVisibility(); $this->add_food->SetVisibility(); $this->add_clothes->SetVisibility(); $this->add_utilities->SetVisibility(); $this->add_job->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 'taccomodations' if (@$_POST["grid"] == "ftaccomodationsgrid") { if (!isset($GLOBALS["taccomodations_grid"])) $GLOBALS["taccomodations_grid"] = new ctaccomodations_grid; $GLOBALS["taccomodations_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, $tofferers; 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($tofferers); $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 ewAddForm"; var $IsModal = FALSE; var $DbMasterFilter = ""; var $DbDetailFilter = ""; var $StartRec; var $Priv = 0; var $OldRecordset; var $CopyRecord; // // 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; // Process form if post back if (@$_POST["a_add"] <> "") { $this->CurrentAction = $_POST["a_add"]; // Get form action $this->CopyRecord = $this->LoadOldRecord(); // Load old recordset $this->LoadFormValues(); // Load form values } else { // Not post back // Load key values from QueryString $this->CopyRecord = TRUE; if (@$_GET["idOfferer"] != "") { $this->idOfferer->setQueryStringValue($_GET["idOfferer"]); $this->setKey("idOfferer", $this->idOfferer->CurrentValue); // Set up key } else { $this->setKey("idOfferer", ""); // Clear key $this->CopyRecord = FALSE; } if ($this->CopyRecord) { $this->CurrentAction = "C"; // Copy record } else { $this->CurrentAction = "I"; // Display blank record } } // Set up Breadcrumb $this->SetupBreadcrumb(); // Set up detail parameters $this->SetUpDetailParms(); // Validate form if post back if (@$_POST["a_add"] <> "") { if (!$this->ValidateForm()) { $this->CurrentAction = "I"; // Form error, reset action $this->EventCancelled = TRUE; // Event cancelled $this->RestoreFormValues(); // Restore form values $this->setFailureMessage($gsFormError); } } else { if ($this->CurrentAction == "I") // Load default values for blank record $this->LoadDefaultValues(); } // Perform action based on action code switch ($this->CurrentAction) { case "I": // Blank record, no action required break; case "C": // Copy an existing record if (!$this->LoadRow()) { // Load record based on key if ($this->getFailureMessage() == "") $this->setFailureMessage($Language->Phrase("NoRecord")); // No record found $this->Page_Terminate("toffererslist.php"); // No matching record, return to list } // Set up detail parameters $this->SetUpDetailParms(); break; case "A": // Add new record $this->SendEmail = TRUE; // Send email on add success if ($this->AddRow($this->OldRecordset)) { // Add successful if ($this->getSuccessMessage() == "") $this->setSuccessMessage($Language->Phrase("AddSuccess")); // Set up success message if ($this->getCurrentDetailTable() <> "") // Master/detail add $sReturnUrl = $this->GetDetailUrl(); else $sReturnUrl = $this->getReturnUrl(); if (ew_GetPageName($sReturnUrl) == "toffererslist.php") $sReturnUrl = $this->AddMasterUrl($sReturnUrl); // List page, return to list page with correct master key if necessary elseif (ew_GetPageName($sReturnUrl) == "tofferersview.php") $sReturnUrl = $this->GetViewUrl(); // View page, return to view page with keyurl directly $this->Page_Terminate($sReturnUrl); // Clean up and return } else { $this->EventCancelled = TRUE; // Event cancelled $this->RestoreFormValues(); // Add failed, restore form values // Set up detail parameters $this->SetUpDetailParms(); } } // Render row based on row type $this->RowType = EW_ROWTYPE_ADD; // Render add type // Render row $this->ResetAttrs(); $this->RenderRow(); } // Get upload files function GetUploadFiles() { global $objForm, $Language; // Get upload data } // Load default values function LoadDefaultValues() { $this->Name->CurrentValue = NULL; $this->Name->OldValue = $this->Name->CurrentValue; $this->Surname->CurrentValue = NULL; $this->Surname->OldValue = $this->Surname->CurrentValue; $this->Institution_Type->CurrentValue = NULL; $this->Institution_Type->OldValue = $this->Institution_Type->CurrentValue; $this->Institution_Name->CurrentValue = NULL; $this->Institution_Name->OldValue = $this->Institution_Name->CurrentValue; $this->Address->CurrentValue = NULL; $this->Address->OldValue = $this->Address->CurrentValue; $this->Phone->CurrentValue = NULL; $this->Phone->OldValue = $this->Phone->CurrentValue; $this->Phone_Mobile->CurrentValue = NULL; $this->Phone_Mobile->OldValue = $this->Phone_Mobile->CurrentValue; $this->_Email->CurrentValue = NULL; $this->_Email->OldValue = $this->_Email->CurrentValue; $this->Town->CurrentValue = NULL; $this->Town->OldValue = $this->Town->CurrentValue; $this->District->CurrentValue = NULL; $this->District->OldValue = $this->District->CurrentValue; $this->Region->CurrentValue = NULL; $this->Region->OldValue = $this->Region->CurrentValue; $this->Suggest_by->CurrentValue = NULL; $this->Suggest_by->OldValue = $this->Suggest_by->CurrentValue; $this->Suggest_by_note->CurrentValue = NULL; $this->Suggest_by_note->OldValue = $this->Suggest_by_note->CurrentValue; $this->Referent->CurrentValue = NULL; $this->Referent->OldValue = $this->Referent->CurrentValue; $this->add_documents->CurrentValue = NULL; $this->add_documents->OldValue = $this->add_documents->CurrentValue; $this->add_care->CurrentValue = NULL; $this->add_care->OldValue = $this->add_care->CurrentValue; $this->add_food->CurrentValue = NULL; $this->add_food->OldValue = $this->add_food->CurrentValue; $this->add_clothes->CurrentValue = NULL; $this->add_clothes->OldValue = $this->add_clothes->CurrentValue; $this->add_utilities->CurrentValue = NULL; $this->add_utilities->OldValue = $this->add_utilities->CurrentValue; $this->add_job->CurrentValue = NULL; $this->add_job->OldValue = $this->add_job->CurrentValue; } // Load form values function LoadFormValues() { // Load from form global $objForm; if (!$this->Name->FldIsDetailKey) { $this->Name->setFormValue($objForm->GetValue("x_Name")); } if (!$this->Surname->FldIsDetailKey) { $this->Surname->setFormValue($objForm->GetValue("x_Surname")); } if (!$this->Institution_Type->FldIsDetailKey) { $this->Institution_Type->setFormValue($objForm->GetValue("x_Institution_Type")); } if (!$this->Institution_Name->FldIsDetailKey) { $this->Institution_Name->setFormValue($objForm->GetValue("x_Institution_Name")); } if (!$this->Address->FldIsDetailKey) { $this->Address->setFormValue($objForm->GetValue("x_Address")); } if (!$this->Phone->FldIsDetailKey) { $this->Phone->setFormValue($objForm->GetValue("x_Phone")); } if (!$this->Phone_Mobile->FldIsDetailKey) { $this->Phone_Mobile->setFormValue($objForm->GetValue("x_Phone_Mobile")); } if (!$this->_Email->FldIsDetailKey) { $this->_Email->setFormValue($objForm->GetValue("x__Email")); } 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->Suggest_by->FldIsDetailKey) { $this->Suggest_by->setFormValue($objForm->GetValue("x_Suggest_by")); } if (!$this->Suggest_by_note->FldIsDetailKey) { $this->Suggest_by_note->setFormValue($objForm->GetValue("x_Suggest_by_note")); } if (!$this->Referent->FldIsDetailKey) { $this->Referent->setFormValue($objForm->GetValue("x_Referent")); } if (!$this->add_documents->FldIsDetailKey) { $this->add_documents->setFormValue($objForm->GetValue("x_add_documents")); } if (!$this->add_care->FldIsDetailKey) { $this->add_care->setFormValue($objForm->GetValue("x_add_care")); } if (!$this->add_food->FldIsDetailKey) { $this->add_food->setFormValue($objForm->GetValue("x_add_food")); } if (!$this->add_clothes->FldIsDetailKey) { $this->add_clothes->setFormValue($objForm->GetValue("x_add_clothes")); } if (!$this->add_utilities->FldIsDetailKey) { $this->add_utilities->setFormValue($objForm->GetValue("x_add_utilities")); } if (!$this->add_job->FldIsDetailKey) { $this->add_job->setFormValue($objForm->GetValue("x_add_job")); } } // Restore form values function RestoreFormValues() { global $objForm; $this->LoadOldRecord(); $this->Name->CurrentValue = $this->Name->FormValue; $this->Surname->CurrentValue = $this->Surname->FormValue; $this->Institution_Type->CurrentValue = $this->Institution_Type->FormValue; $this->Institution_Name->CurrentValue = $this->Institution_Name->FormValue; $this->Address->CurrentValue = $this->Address->FormValue; $this->Phone->CurrentValue = $this->Phone->FormValue; $this->Phone_Mobile->CurrentValue = $this->Phone_Mobile->FormValue; $this->_Email->CurrentValue = $this->_Email->FormValue; $this->Town->CurrentValue = $this->Town->FormValue; $this->District->CurrentValue = $this->District->FormValue; $this->Region->CurrentValue = $this->Region->FormValue; $this->Suggest_by->CurrentValue = $this->Suggest_by->FormValue; $this->Suggest_by_note->CurrentValue = $this->Suggest_by_note->FormValue; $this->Referent->CurrentValue = $this->Referent->FormValue; $this->add_documents->CurrentValue = $this->add_documents->FormValue; $this->add_care->CurrentValue = $this->add_care->FormValue; $this->add_food->CurrentValue = $this->add_food->FormValue; $this->add_clothes->CurrentValue = $this->add_clothes->FormValue; $this->add_utilities->CurrentValue = $this->add_utilities->FormValue; $this->add_job->CurrentValue = $this->add_job->FormValue; } // 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->idOfferer->setDbValue($rs->fields('idOfferer')); $this->Name->setDbValue($rs->fields('Name')); $this->Surname->setDbValue($rs->fields('Surname')); $this->Institution_Type->setDbValue($rs->fields('Institution_Type')); $this->Institution_Name->setDbValue($rs->fields('Institution_Name')); $this->Address->setDbValue($rs->fields('Address')); $this->Phone->setDbValue($rs->fields('Phone')); $this->Phone_Mobile->setDbValue($rs->fields('Phone_Mobile')); $this->_Email->setDbValue($rs->fields('Email')); $this->Town->setDbValue($rs->fields('Town')); $this->District->setDbValue($rs->fields('District')); $this->Region->setDbValue($rs->fields('Region')); $this->Suggest_by->setDbValue($rs->fields('Suggest_by')); $this->Suggest_by_note->setDbValue($rs->fields('Suggest_by_note')); $this->Referent->setDbValue($rs->fields('Referent')); $this->add_network->setDbValue($rs->fields('add_network')); $this->add_documents->setDbValue($rs->fields('add_documents')); $this->add_care->setDbValue($rs->fields('add_care')); $this->add_food->setDbValue($rs->fields('add_food')); $this->add_clothes->setDbValue($rs->fields('add_clothes')); $this->add_utilities->setDbValue($rs->fields('add_utilities')); $this->add_job->setDbValue($rs->fields('add_job')); } // Load DbValue from recordset function LoadDbValues(&$rs) { if (!$rs || !is_array($rs) && $rs->EOF) return; $row = is_array($rs) ? $rs : $rs->fields; $this->idOfferer->DbValue = $row['idOfferer']; $this->Name->DbValue = $row['Name']; $this->Surname->DbValue = $row['Surname']; $this->Institution_Type->DbValue = $row['Institution_Type']; $this->Institution_Name->DbValue = $row['Institution_Name']; $this->Address->DbValue = $row['Address']; $this->Phone->DbValue = $row['Phone']; $this->Phone_Mobile->DbValue = $row['Phone_Mobile']; $this->_Email->DbValue = $row['Email']; $this->Town->DbValue = $row['Town']; $this->District->DbValue = $row['District']; $this->Region->DbValue = $row['Region']; $this->Suggest_by->DbValue = $row['Suggest_by']; $this->Suggest_by_note->DbValue = $row['Suggest_by_note']; $this->Referent->DbValue = $row['Referent']; $this->add_network->DbValue = $row['add_network']; $this->add_documents->DbValue = $row['add_documents']; $this->add_care->DbValue = $row['add_care']; $this->add_food->DbValue = $row['add_food']; $this->add_clothes->DbValue = $row['add_clothes']; $this->add_utilities->DbValue = $row['add_utilities']; $this->add_job->DbValue = $row['add_job']; } // Load old record function LoadOldRecord() { // Load key values from Session $bValidKey = TRUE; if (strval($this->getKey("idOfferer")) <> "") $this->idOfferer->CurrentValue = $this->getKey("idOfferer"); // idOfferer else $bValidKey = FALSE; // Load old recordset if ($bValidKey) { $this->CurrentFilter = $this->KeyFilter(); $sSql = $this->SQL(); $conn = &$this->Connection(); $this->OldRecordset = ew_LoadRecordset($sSql, $conn); $this->LoadRowValues($this->OldRecordset); // Load row values } else { $this->OldRecordset = NULL; } return $bValidKey; } // 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 // idOfferer // Name // Surname // Institution_Type // Institution_Name // Address // Phone // Phone_Mobile // Email // Town // District // Region // Suggest_by // Suggest_by_note // Referent // add_network // add_documents // add_care // add_food // add_clothes // add_utilities // add_job if ($this->RowType == EW_ROWTYPE_VIEW) { // View row // idOfferer $this->idOfferer->ViewValue = $this->idOfferer->CurrentValue; $this->idOfferer->ViewCustomAttributes = ""; // Name $this->Name->ViewValue = $this->Name->CurrentValue; $this->Name->ViewCustomAttributes = ""; // Surname $this->Surname->ViewValue = $this->Surname->CurrentValue; $this->Surname->ViewCustomAttributes = ""; // Institution_Type if (strval($this->Institution_Type->CurrentValue) <> "") { $sFilterWrk = "`Institution_Type`" . ew_SearchString("=", $this->Institution_Type->CurrentValue, EW_DATATYPE_STRING, ""); switch (@$gsLanguage) { case "en": $sSqlWrk = "SELECT `Institution_Type`, `Description` AS `DispFld`, '' AS `Disp2Fld`, '' AS `Disp3Fld`, '' AS `Disp4Fld` FROM `tinstitutions`"; $sWhereWrk = ""; $this->Institution_Type->LookupFilters = array(); break; case "it": $sSqlWrk = "SELECT `Institution_Type`, `Description_it` AS `DispFld`, '' AS `Disp2Fld`, '' AS `Disp3Fld`, '' AS `Disp4Fld` FROM `tinstitutions`"; $sWhereWrk = ""; $this->Institution_Type->LookupFilters = array(); break; default: $sSqlWrk = "SELECT `Institution_Type`, `Description` AS `DispFld`, '' AS `Disp2Fld`, '' AS `Disp3Fld`, '' AS `Disp4Fld` FROM `tinstitutions`"; $sWhereWrk = ""; $this->Institution_Type->LookupFilters = array(); break; } ew_AddFilter($sWhereWrk, $sFilterWrk); $this->Lookup_Selecting($this->Institution_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->Institution_Type->ViewValue = $this->Institution_Type->DisplayValue($arwrk); $rswrk->Close(); } else { $this->Institution_Type->ViewValue = $this->Institution_Type->CurrentValue; } } else { $this->Institution_Type->ViewValue = NULL; } $this->Institution_Type->ViewCustomAttributes = ""; // Institution_Name $this->Institution_Name->ViewValue = $this->Institution_Name->CurrentValue; $this->Institution_Name->ViewCustomAttributes = ""; // Address $this->Address->ViewValue = $this->Address->CurrentValue; $this->Address->ViewCustomAttributes = ""; // Phone $this->Phone->ViewValue = $this->Phone->CurrentValue; $this->Phone->ViewCustomAttributes = ""; // Phone_Mobile $this->Phone_Mobile->ViewValue = $this->Phone_Mobile->CurrentValue; $this->Phone_Mobile->ViewCustomAttributes = ""; // Email $this->_Email->ViewValue = $this->_Email->CurrentValue; $this->_Email->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 = ""; // Suggest_by if (strval($this->Suggest_by->CurrentValue) <> "") { $sFilterWrk = "`suggesttype`" . ew_SearchString("=", $this->Suggest_by->CurrentValue, EW_DATATYPE_STRING, ""); switch (@$gsLanguage) { case "en": $sSqlWrk = "SELECT `suggesttype`, `Description` AS `DispFld`, '' AS `Disp2Fld`, '' AS `Disp3Fld`, '' AS `Disp4Fld` FROM `tsuggest_type`"; $sWhereWrk = ""; $this->Suggest_by->LookupFilters = array(); break; case "it": $sSqlWrk = "SELECT `suggesttype`, `Description_IT` AS `DispFld`, '' AS `Disp2Fld`, '' AS `Disp3Fld`, '' AS `Disp4Fld` FROM `tsuggest_type`"; $sWhereWrk = ""; $this->Suggest_by->LookupFilters = array(); break; default: $sSqlWrk = "SELECT `suggesttype`, `Description` AS `DispFld`, '' AS `Disp2Fld`, '' AS `Disp3Fld`, '' AS `Disp4Fld` FROM `tsuggest_type`"; $sWhereWrk = ""; $this->Suggest_by->LookupFilters = array(); break; } ew_AddFilter($sWhereWrk, $sFilterWrk); $this->Lookup_Selecting($this->Suggest_by, $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->Suggest_by->ViewValue = $this->Suggest_by->DisplayValue($arwrk); $rswrk->Close(); } else { $this->Suggest_by->ViewValue = $this->Suggest_by->CurrentValue; } } else { $this->Suggest_by->ViewValue = NULL; } $this->Suggest_by->ViewCustomAttributes = ""; // Suggest_by_note $this->Suggest_by_note->ViewValue = $this->Suggest_by_note->CurrentValue; $this->Suggest_by_note->ViewCustomAttributes = ""; // Referent $this->Referent->ViewValue = $this->Referent->CurrentValue; $this->Referent->ViewCustomAttributes = ""; // add_documents if (ew_ConvertToBool($this->add_documents->CurrentValue)) { $this->add_documents->ViewValue = $this->add_documents->FldTagCaption(1) <> "" ? $this->add_documents->FldTagCaption(1) : "Y"; } else { $this->add_documents->ViewValue = $this->add_documents->FldTagCaption(2) <> "" ? $this->add_documents->FldTagCaption(2) : "N"; } $this->add_documents->ViewCustomAttributes = ""; // add_care if (ew_ConvertToBool($this->add_care->CurrentValue)) { $this->add_care->ViewValue = $this->add_care->FldTagCaption(1) <> "" ? $this->add_care->FldTagCaption(1) : "Y"; } else { $this->add_care->ViewValue = $this->add_care->FldTagCaption(2) <> "" ? $this->add_care->FldTagCaption(2) : "N"; } $this->add_care->ViewCustomAttributes = ""; // add_food if (ew_ConvertToBool($this->add_food->CurrentValue)) { $this->add_food->ViewValue = $this->add_food->FldTagCaption(1) <> "" ? $this->add_food->FldTagCaption(1) : "Y"; } else { $this->add_food->ViewValue = $this->add_food->FldTagCaption(2) <> "" ? $this->add_food->FldTagCaption(2) : "N"; } $this->add_food->ViewCustomAttributes = ""; // add_clothes if (ew_ConvertToBool($this->add_clothes->CurrentValue)) { $this->add_clothes->ViewValue = $this->add_clothes->FldTagCaption(1) <> "" ? $this->add_clothes->FldTagCaption(1) : "Y"; } else { $this->add_clothes->ViewValue = $this->add_clothes->FldTagCaption(2) <> "" ? $this->add_clothes->FldTagCaption(2) : "N"; } $this->add_clothes->ViewCustomAttributes = ""; // add_utilities if (ew_ConvertToBool($this->add_utilities->CurrentValue)) { $this->add_utilities->ViewValue = $this->add_utilities->FldTagCaption(1) <> "" ? $this->add_utilities->FldTagCaption(1) : "Y"; } else { $this->add_utilities->ViewValue = $this->add_utilities->FldTagCaption(2) <> "" ? $this->add_utilities->FldTagCaption(2) : "N"; } $this->add_utilities->ViewCustomAttributes = ""; // add_job if (ew_ConvertToBool($this->add_job->CurrentValue)) { $this->add_job->ViewValue = $this->add_job->FldTagCaption(1) <> "" ? $this->add_job->FldTagCaption(1) : "Y"; } else { $this->add_job->ViewValue = $this->add_job->FldTagCaption(2) <> "" ? $this->add_job->FldTagCaption(2) : "N"; } $this->add_job->ViewCustomAttributes = ""; // Name $this->Name->LinkCustomAttributes = ""; $this->Name->HrefValue = ""; $this->Name->TooltipValue = ""; // Surname $this->Surname->LinkCustomAttributes = ""; $this->Surname->HrefValue = ""; $this->Surname->TooltipValue = ""; // Institution_Type $this->Institution_Type->LinkCustomAttributes = ""; $this->Institution_Type->HrefValue = ""; $this->Institution_Type->TooltipValue = ""; // Institution_Name $this->Institution_Name->LinkCustomAttributes = ""; $this->Institution_Name->HrefValue = ""; $this->Institution_Name->TooltipValue = ""; // Address $this->Address->LinkCustomAttributes = ""; $this->Address->HrefValue = ""; $this->Address->TooltipValue = ""; // Phone $this->Phone->LinkCustomAttributes = ""; $this->Phone->HrefValue = ""; $this->Phone->TooltipValue = ""; // Phone_Mobile $this->Phone_Mobile->LinkCustomAttributes = ""; $this->Phone_Mobile->HrefValue = ""; $this->Phone_Mobile->TooltipValue = ""; // Email $this->_Email->LinkCustomAttributes = ""; $this->_Email->HrefValue = ""; $this->_Email->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 = ""; // Suggest_by $this->Suggest_by->LinkCustomAttributes = ""; $this->Suggest_by->HrefValue = ""; $this->Suggest_by->TooltipValue = ""; // Suggest_by_note $this->Suggest_by_note->LinkCustomAttributes = ""; $this->Suggest_by_note->HrefValue = ""; $this->Suggest_by_note->TooltipValue = ""; // Referent $this->Referent->LinkCustomAttributes = ""; $this->Referent->HrefValue = ""; $this->Referent->TooltipValue = ""; // add_documents $this->add_documents->LinkCustomAttributes = ""; $this->add_documents->HrefValue = ""; $this->add_documents->TooltipValue = ""; // add_care $this->add_care->LinkCustomAttributes = ""; $this->add_care->HrefValue = ""; $this->add_care->TooltipValue = ""; // add_food $this->add_food->LinkCustomAttributes = ""; $this->add_food->HrefValue = ""; $this->add_food->TooltipValue = ""; // add_clothes $this->add_clothes->LinkCustomAttributes = ""; $this->add_clothes->HrefValue = ""; $this->add_clothes->TooltipValue = ""; // add_utilities $this->add_utilities->LinkCustomAttributes = ""; $this->add_utilities->HrefValue = ""; $this->add_utilities->TooltipValue = ""; // add_job $this->add_job->LinkCustomAttributes = ""; $this->add_job->HrefValue = ""; $this->add_job->TooltipValue = ""; } elseif ($this->RowType == EW_ROWTYPE_ADD) { // Add row // Name $this->Name->EditAttrs["class"] = "form-control"; $this->Name->EditCustomAttributes = ""; $this->Name->EditValue = ew_HtmlEncode($this->Name->CurrentValue); $this->Name->PlaceHolder = ew_RemoveHtml($this->Name->FldCaption()); // Surname $this->Surname->EditAttrs["class"] = "form-control"; $this->Surname->EditCustomAttributes = ""; $this->Surname->EditValue = ew_HtmlEncode($this->Surname->CurrentValue); $this->Surname->PlaceHolder = ew_RemoveHtml($this->Surname->FldCaption()); // Institution_Type $this->Institution_Type->EditAttrs["class"] = "form-control"; $this->Institution_Type->EditCustomAttributes = ""; if (trim(strval($this->Institution_Type->CurrentValue)) == "") { $sFilterWrk = "0=1"; } else { $sFilterWrk = "`Institution_Type`" . ew_SearchString("=", $this->Institution_Type->CurrentValue, EW_DATATYPE_STRING, ""); } switch (@$gsLanguage) { case "en": $sSqlWrk = "SELECT `Institution_Type`, `Description` AS `DispFld`, '' AS `Disp2Fld`, '' AS `Disp3Fld`, '' AS `Disp4Fld`, '' AS `SelectFilterFld`, '' AS `SelectFilterFld2`, '' AS `SelectFilterFld3`, '' AS `SelectFilterFld4` FROM `tinstitutions`"; $sWhereWrk = ""; $this->Institution_Type->LookupFilters = array(); break; case "it": $sSqlWrk = "SELECT `Institution_Type`, `Description_it` AS `DispFld`, '' AS `Disp2Fld`, '' AS `Disp3Fld`, '' AS `Disp4Fld`, '' AS `SelectFilterFld`, '' AS `SelectFilterFld2`, '' AS `SelectFilterFld3`, '' AS `SelectFilterFld4` FROM `tinstitutions`"; $sWhereWrk = ""; $this->Institution_Type->LookupFilters = array(); break; default: $sSqlWrk = "SELECT `Institution_Type`, `Description` AS `DispFld`, '' AS `Disp2Fld`, '' AS `Disp3Fld`, '' AS `Disp4Fld`, '' AS `SelectFilterFld`, '' AS `SelectFilterFld2`, '' AS `SelectFilterFld3`, '' AS `SelectFilterFld4` FROM `tinstitutions`"; $sWhereWrk = ""; $this->Institution_Type->LookupFilters = array(); break; } ew_AddFilter($sWhereWrk, $sFilterWrk); $this->Lookup_Selecting($this->Institution_Type, $sWhereWrk); // Call Lookup selecting if ($sWhereWrk <> "") $sSqlWrk .= " WHERE " . $sWhereWrk; $rswrk = Conn()->Execute($sSqlWrk); $arwrk = ($rswrk) ? $rswrk->GetRows() : array(); if ($rswrk) $rswrk->Close(); $this->Institution_Type->EditValue = $arwrk; // Institution_Name $this->Institution_Name->EditAttrs["class"] = "form-control"; $this->Institution_Name->EditCustomAttributes = ""; $this->Institution_Name->EditValue = ew_HtmlEncode($this->Institution_Name->CurrentValue); $this->Institution_Name->PlaceHolder = ew_RemoveHtml($this->Institution_Name->FldCaption()); // 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()); // Phone $this->Phone->EditAttrs["class"] = "form-control"; $this->Phone->EditCustomAttributes = ""; $this->Phone->EditValue = ew_HtmlEncode($this->Phone->CurrentValue); $this->Phone->PlaceHolder = ew_RemoveHtml($this->Phone->FldCaption()); // Phone_Mobile $this->Phone_Mobile->EditAttrs["class"] = "form-control"; $this->Phone_Mobile->EditCustomAttributes = ""; $this->Phone_Mobile->EditValue = ew_HtmlEncode($this->Phone_Mobile->CurrentValue); $this->Phone_Mobile->PlaceHolder = ew_RemoveHtml($this->Phone_Mobile->FldCaption()); // Email $this->_Email->EditAttrs["class"] = "form-control"; $this->_Email->EditCustomAttributes = ""; $this->_Email->EditValue = ew_HtmlEncode($this->_Email->CurrentValue); $this->_Email->PlaceHolder = ew_RemoveHtml($this->_Email->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()); // Suggest_by $this->Suggest_by->EditAttrs["class"] = "form-control"; $this->Suggest_by->EditCustomAttributes = ""; if (trim(strval($this->Suggest_by->CurrentValue)) == "") { $sFilterWrk = "0=1"; } else { $sFilterWrk = "`suggesttype`" . ew_SearchString("=", $this->Suggest_by->CurrentValue, EW_DATATYPE_STRING, ""); } switch (@$gsLanguage) { case "en": $sSqlWrk = "SELECT `suggesttype`, `Description` AS `DispFld`, '' AS `Disp2Fld`, '' AS `Disp3Fld`, '' AS `Disp4Fld`, '' AS `SelectFilterFld`, '' AS `SelectFilterFld2`, '' AS `SelectFilterFld3`, '' AS `SelectFilterFld4` FROM `tsuggest_type`"; $sWhereWrk = ""; $this->Suggest_by->LookupFilters = array(); break; case "it": $sSqlWrk = "SELECT `suggesttype`, `Description_IT` AS `DispFld`, '' AS `Disp2Fld`, '' AS `Disp3Fld`, '' AS `Disp4Fld`, '' AS `SelectFilterFld`, '' AS `SelectFilterFld2`, '' AS `SelectFilterFld3`, '' AS `SelectFilterFld4` FROM `tsuggest_type`"; $sWhereWrk = ""; $this->Suggest_by->LookupFilters = array(); break; default: $sSqlWrk = "SELECT `suggesttype`, `Description` AS `DispFld`, '' AS `Disp2Fld`, '' AS `Disp3Fld`, '' AS `Disp4Fld`, '' AS `SelectFilterFld`, '' AS `SelectFilterFld2`, '' AS `SelectFilterFld3`, '' AS `SelectFilterFld4` FROM `tsuggest_type`"; $sWhereWrk = ""; $this->Suggest_by->LookupFilters = array(); break; } ew_AddFilter($sWhereWrk, $sFilterWrk); $this->Lookup_Selecting($this->Suggest_by, $sWhereWrk); // Call Lookup selecting if ($sWhereWrk <> "") $sSqlWrk .= " WHERE " . $sWhereWrk; $rswrk = Conn()->Execute($sSqlWrk); $arwrk = ($rswrk) ? $rswrk->GetRows() : array(); if ($rswrk) $rswrk->Close(); $this->Suggest_by->EditValue = $arwrk; // Suggest_by_note $this->Suggest_by_note->EditAttrs["class"] = "form-control"; $this->Suggest_by_note->EditCustomAttributes = ""; $this->Suggest_by_note->EditValue = ew_HtmlEncode($this->Suggest_by_note->CurrentValue); $this->Suggest_by_note->PlaceHolder = ew_RemoveHtml($this->Suggest_by_note->FldCaption()); // Referent $this->Referent->EditAttrs["class"] = "form-control"; $this->Referent->EditCustomAttributes = ""; $this->Referent->EditValue = ew_HtmlEncode($this->Referent->CurrentValue); $this->Referent->PlaceHolder = ew_RemoveHtml($this->Referent->FldCaption()); // add_documents $this->add_documents->EditCustomAttributes = ""; $this->add_documents->EditValue = $this->add_documents->Options(FALSE); // add_care $this->add_care->EditCustomAttributes = ""; $this->add_care->EditValue = $this->add_care->Options(FALSE); // add_food $this->add_food->EditCustomAttributes = ""; $this->add_food->EditValue = $this->add_food->Options(FALSE); // add_clothes $this->add_clothes->EditCustomAttributes = ""; $this->add_clothes->EditValue = $this->add_clothes->Options(FALSE); // add_utilities $this->add_utilities->EditCustomAttributes = ""; $this->add_utilities->EditValue = $this->add_utilities->Options(FALSE); // add_job $this->add_job->EditCustomAttributes = ""; $this->add_job->EditValue = $this->add_job->Options(FALSE); // Add refer script // Name $this->Name->LinkCustomAttributes = ""; $this->Name->HrefValue = ""; // Surname $this->Surname->LinkCustomAttributes = ""; $this->Surname->HrefValue = ""; // Institution_Type $this->Institution_Type->LinkCustomAttributes = ""; $this->Institution_Type->HrefValue = ""; // Institution_Name $this->Institution_Name->LinkCustomAttributes = ""; $this->Institution_Name->HrefValue = ""; // Address $this->Address->LinkCustomAttributes = ""; $this->Address->HrefValue = ""; // Phone $this->Phone->LinkCustomAttributes = ""; $this->Phone->HrefValue = ""; // Phone_Mobile $this->Phone_Mobile->LinkCustomAttributes = ""; $this->Phone_Mobile->HrefValue = ""; // Email $this->_Email->LinkCustomAttributes = ""; $this->_Email->HrefValue = ""; // Town $this->Town->LinkCustomAttributes = ""; $this->Town->HrefValue = ""; // District $this->District->LinkCustomAttributes = ""; $this->District->HrefValue = ""; // Region $this->Region->LinkCustomAttributes = ""; $this->Region->HrefValue = ""; // Suggest_by $this->Suggest_by->LinkCustomAttributes = ""; $this->Suggest_by->HrefValue = ""; // Suggest_by_note $this->Suggest_by_note->LinkCustomAttributes = ""; $this->Suggest_by_note->HrefValue = ""; // Referent $this->Referent->LinkCustomAttributes = ""; $this->Referent->HrefValue = ""; // add_documents $this->add_documents->LinkCustomAttributes = ""; $this->add_documents->HrefValue = ""; // add_care $this->add_care->LinkCustomAttributes = ""; $this->add_care->HrefValue = ""; // add_food $this->add_food->LinkCustomAttributes = ""; $this->add_food->HrefValue = ""; // add_clothes $this->add_clothes->LinkCustomAttributes = ""; $this->add_clothes->HrefValue = ""; // add_utilities $this->add_utilities->LinkCustomAttributes = ""; $this->add_utilities->HrefValue = ""; // add_job $this->add_job->LinkCustomAttributes = ""; $this->add_job->HrefValue = ""; } 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 == ""); // Validate detail grid $DetailTblVar = explode(",", $this->getCurrentDetailTable()); if (in_array("taccomodations", $DetailTblVar) && $GLOBALS["taccomodations"]->DetailAdd) { if (!isset($GLOBALS["taccomodations_grid"])) $GLOBALS["taccomodations_grid"] = new ctaccomodations_grid(); // get detail page object $GLOBALS["taccomodations_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; } // Add record function AddRow($rsold = NULL) { global $Language, $Security; $conn = &$this->Connection(); // Begin transaction if ($this->getCurrentDetailTable() <> "") $conn->BeginTrans(); // Load db values from rsold if ($rsold) { $this->LoadDbValues($rsold); } $rsnew = array(); // Name $this->Name->SetDbValueDef($rsnew, $this->Name->CurrentValue, NULL, FALSE); // Surname $this->Surname->SetDbValueDef($rsnew, $this->Surname->CurrentValue, NULL, FALSE); // Institution_Type $this->Institution_Type->SetDbValueDef($rsnew, $this->Institution_Type->CurrentValue, NULL, FALSE); // Institution_Name $this->Institution_Name->SetDbValueDef($rsnew, $this->Institution_Name->CurrentValue, NULL, FALSE); // Address $this->Address->SetDbValueDef($rsnew, $this->Address->CurrentValue, NULL, FALSE); // Phone $this->Phone->SetDbValueDef($rsnew, $this->Phone->CurrentValue, NULL, FALSE); // Phone_Mobile $this->Phone_Mobile->SetDbValueDef($rsnew, $this->Phone_Mobile->CurrentValue, NULL, FALSE); // Email $this->_Email->SetDbValueDef($rsnew, $this->_Email->CurrentValue, NULL, FALSE); // Town $this->Town->SetDbValueDef($rsnew, $this->Town->CurrentValue, NULL, FALSE); // District $this->District->SetDbValueDef($rsnew, $this->District->CurrentValue, NULL, FALSE); // Region $this->Region->SetDbValueDef($rsnew, $this->Region->CurrentValue, NULL, FALSE); // Suggest_by $this->Suggest_by->SetDbValueDef($rsnew, $this->Suggest_by->CurrentValue, NULL, FALSE); // Suggest_by_note $this->Suggest_by_note->SetDbValueDef($rsnew, $this->Suggest_by_note->CurrentValue, NULL, FALSE); // Referent $this->Referent->SetDbValueDef($rsnew, $this->Referent->CurrentValue, NULL, FALSE); // add_documents $this->add_documents->SetDbValueDef($rsnew, ((strval($this->add_documents->CurrentValue) == "Y") ? "Y" : "N"), NULL, FALSE); // add_care $this->add_care->SetDbValueDef($rsnew, ((strval($this->add_care->CurrentValue) == "Y") ? "Y" : "N"), NULL, FALSE); // add_food $this->add_food->SetDbValueDef($rsnew, ((strval($this->add_food->CurrentValue) == "Y") ? "Y" : "N"), NULL, FALSE); // add_clothes $this->add_clothes->SetDbValueDef($rsnew, ((strval($this->add_clothes->CurrentValue) == "Y") ? "Y" : "N"), NULL, FALSE); // add_utilities $this->add_utilities->SetDbValueDef($rsnew, ((strval($this->add_utilities->CurrentValue) == "Y") ? "Y" : "N"), NULL, FALSE); // add_job $this->add_job->SetDbValueDef($rsnew, ((strval($this->add_job->CurrentValue) == "Y") ? "Y" : "N"), NULL, FALSE); // Call Row Inserting event $rs = ($rsold == NULL) ? NULL : $rsold->fields; $bInsertRow = $this->Row_Inserting($rs, $rsnew); if ($bInsertRow) { $conn->raiseErrorFn = $GLOBALS["EW_ERROR_FN"]; $AddRow = $this->Insert($rsnew); $conn->raiseErrorFn = ''; if ($AddRow) { } } 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("InsertCancelled")); } $AddRow = FALSE; } // Add detail records if ($AddRow) { $DetailTblVar = explode(",", $this->getCurrentDetailTable()); if (in_array("taccomodations", $DetailTblVar) && $GLOBALS["taccomodations"]->DetailAdd) { $GLOBALS["taccomodations"]->idOfferer->setSessionValue($this->idOfferer->CurrentValue); // Set master key if (!isset($GLOBALS["taccomodations_grid"])) $GLOBALS["taccomodations_grid"] = new ctaccomodations_grid(); // Get detail page object $Security->LoadCurrentUserLevel($this->ProjectID . "taccomodations"); // Load user level of detail table $AddRow = $GLOBALS["taccomodations_grid"]->GridInsert(); $Security->LoadCurrentUserLevel($this->ProjectID . $this->TableName); // Restore user level of master table if (!$AddRow) $GLOBALS["taccomodations"]->idOfferer->setSessionValue(""); // Clear master key if insert failed } } // Commit/Rollback transaction if ($this->getCurrentDetailTable() <> "") { if ($AddRow) { $conn->CommitTrans(); // Commit transaction } else { $conn->RollbackTrans(); // Rollback transaction } } if ($AddRow) { // Call Row Inserted event $rs = ($rsold == NULL) ? NULL : $rsold->fields; $this->Row_Inserted($rs, $rsnew); } return $AddRow; } // 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("taccomodations", $DetailTblVar)) { if (!isset($GLOBALS["taccomodations_grid"])) $GLOBALS["taccomodations_grid"] = new ctaccomodations_grid; if ($GLOBALS["taccomodations_grid"]->DetailAdd) { if ($this->CopyRecord) $GLOBALS["taccomodations_grid"]->CurrentMode = "copy"; else $GLOBALS["taccomodations_grid"]->CurrentMode = "add"; $GLOBALS["taccomodations_grid"]->CurrentAction = "gridadd"; // Save current master table to detail table $GLOBALS["taccomodations_grid"]->setCurrentMasterTable($this->TableVar); $GLOBALS["taccomodations_grid"]->setStartRecordNumber(1); $GLOBALS["taccomodations_grid"]->idOfferer->FldIsDetailKey = TRUE; $GLOBALS["taccomodations_grid"]->idOfferer->CurrentValue = $this->idOfferer->CurrentValue; $GLOBALS["taccomodations_grid"]->idOfferer->setSessionValue($GLOBALS["taccomodations_grid"]->idOfferer->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("toffererslist.php"), "", $this->TableVar, TRUE); $PageId = ($this->CurrentAction == "C") ? "Copy" : "Add"; $Breadcrumb->Add("add", $PageId, $url); } // Setup lookup filters of a field function SetupLookupFilters($fld, $pageId = null) { global $gsLanguage; $pageId = $pageId ?: $this->PageID; switch ($fld->FldVar) { case "x_Institution_Type": $sSqlWrk = ""; switch (@$gsLanguage) { case "en": $sSqlWrk = "SELECT `Institution_Type` AS `LinkFld`, `Description` AS `DispFld`, '' AS `Disp2Fld`, '' AS `Disp3Fld`, '' AS `Disp4Fld` FROM `tinstitutions`"; $sWhereWrk = ""; $this->Institution_Type->LookupFilters = array(); break; case "it": $sSqlWrk = "SELECT `Institution_Type` AS `LinkFld`, `Description_it` AS `DispFld`, '' AS `Disp2Fld`, '' AS `Disp3Fld`, '' AS `Disp4Fld` FROM `tinstitutions`"; $sWhereWrk = ""; $this->Institution_Type->LookupFilters = array(); break; default: $sSqlWrk = "SELECT `Institution_Type` AS `LinkFld`, `Description` AS `DispFld`, '' AS `Disp2Fld`, '' AS `Disp3Fld`, '' AS `Disp4Fld` FROM `tinstitutions`"; $sWhereWrk = ""; $this->Institution_Type->LookupFilters = array(); break; } $fld->LookupFilters += array("s" => $sSqlWrk, "d" => "", "f0" => '`Institution_Type` = {filter_value}', "t0" => "200", "fn0" => ""); $sSqlWrk = ""; $this->Lookup_Selecting($this->Institution_Type, $sWhereWrk); // Call Lookup selecting if ($sWhereWrk <> "") $sSqlWrk .= " WHERE " . $sWhereWrk; if ($sSqlWrk <> "") $fld->LookupFilters["s"] .= $sSqlWrk; break; case "x_Suggest_by": $sSqlWrk = ""; switch (@$gsLanguage) { case "en": $sSqlWrk = "SELECT `suggesttype` AS `LinkFld`, `Description` AS `DispFld`, '' AS `Disp2Fld`, '' AS `Disp3Fld`, '' AS `Disp4Fld` FROM `tsuggest_type`"; $sWhereWrk = ""; $this->Suggest_by->LookupFilters = array(); break; case "it": $sSqlWrk = "SELECT `suggesttype` AS `LinkFld`, `Description_IT` AS `DispFld`, '' AS `Disp2Fld`, '' AS `Disp3Fld`, '' AS `Disp4Fld` FROM `tsuggest_type`"; $sWhereWrk = ""; $this->Suggest_by->LookupFilters = array(); break; default: $sSqlWrk = "SELECT `suggesttype` AS `LinkFld`, `Description` AS `DispFld`, '' AS `Disp2Fld`, '' AS `Disp3Fld`, '' AS `Disp4Fld` FROM `tsuggest_type`"; $sWhereWrk = ""; $this->Suggest_by->LookupFilters = array(); break; } $fld->LookupFilters += array("s" => $sSqlWrk, "d" => "", "f0" => '`suggesttype` = {filter_value}', "t0" => "200", "fn0" => ""); $sSqlWrk = ""; $this->Lookup_Selecting($this->Suggest_by, $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) { } } // 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 $tofferers_add->Page_Main(); // Global Page Rendering event (in userfn*.php) Page_Rendering(); // Page Rendering event $tofferers_add->Page_Render(); ?> IsModal) { ?> ShowPageHeader(); ?> ShowMessage(); ?> ShowPageFooter(); if (EW_DEBUG_ENABLED) echo ew_DebugMsg(); ?> Page_Terminate(); ?>