" . $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 (tassigment) if (!isset($GLOBALS["tassigment"]) || get_class($GLOBALS["tassigment"]) == "ctassigment") { $GLOBALS["tassigment"] = &$this; $GLOBALS["Table"] = &$GLOBALS["tassigment"]; } // Table object (taccomodations) if (!isset($GLOBALS['taccomodations'])) $GLOBALS['taccomodations'] = new ctaccomodations(); // Table object (users) if (!isset($GLOBALS['users'])) $GLOBALS['users'] = new cusers(); // Table object (tospiti) if (!isset($GLOBALS['tospiti'])) $GLOBALS['tospiti'] = new ctospiti(); // 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", 'tassigment', 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("tassigmentlist.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->idkAccomodation->SetVisibility(); $this->idkSeeker->SetVisibility(); $this->Date_ass->SetVisibility(); $this->Date_end->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 'tass_notes' if (@$_POST["grid"] == "ftass_notesgrid") { if (!isset($GLOBALS["tass_notes_grid"])) $GLOBALS["tass_notes_grid"] = new ctass_notes_grid; $GLOBALS["tass_notes_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, $tassigment; 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($tassigment); $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["idAssigment"] <> "") { $this->idAssigment->setQueryStringValue($_GET["idAssigment"]); $this->RecKey["idAssigment"] = $this->idAssigment->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("tassigmentlist.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->idAssigment->CurrentValue) == strval($this->Recordset->fields('idAssigment'))) { $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("tassigmentlist.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) == "tassigmentlist.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 } // Load form values function LoadFormValues() { // Load from form global $objForm; if (!$this->idkAccomodation->FldIsDetailKey) { $this->idkAccomodation->setFormValue($objForm->GetValue("x_idkAccomodation")); } if (!$this->idkSeeker->FldIsDetailKey) { $this->idkSeeker->setFormValue($objForm->GetValue("x_idkSeeker")); } if (!$this->Date_ass->FldIsDetailKey) { $this->Date_ass->setFormValue($objForm->GetValue("x_Date_ass")); $this->Date_ass->CurrentValue = ew_UnFormatDateTime($this->Date_ass->CurrentValue, 7); } if (!$this->Date_end->FldIsDetailKey) { $this->Date_end->setFormValue($objForm->GetValue("x_Date_end")); $this->Date_end->CurrentValue = ew_UnFormatDateTime($this->Date_end->CurrentValue, 7); } if (!$this->idAssigment->FldIsDetailKey) $this->idAssigment->setFormValue($objForm->GetValue("x_idAssigment")); } // Restore form values function RestoreFormValues() { global $objForm; $this->LoadRow(); $this->idAssigment->CurrentValue = $this->idAssigment->FormValue; $this->idkAccomodation->CurrentValue = $this->idkAccomodation->FormValue; $this->idkSeeker->CurrentValue = $this->idkSeeker->FormValue; $this->Date_ass->CurrentValue = $this->Date_ass->FormValue; $this->Date_ass->CurrentValue = ew_UnFormatDateTime($this->Date_ass->CurrentValue, 7); $this->Date_end->CurrentValue = $this->Date_end->FormValue; $this->Date_end->CurrentValue = ew_UnFormatDateTime($this->Date_end->CurrentValue, 7); } // 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->getSessionOrderByList()))); } 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->idAssigment->setDbValue($rs->fields('idAssigment')); $this->idkAccomodation->setDbValue($rs->fields('idkAccomodation')); if (array_key_exists('EV__idkAccomodation', $rs->fields)) { $this->idkAccomodation->VirtualValue = $rs->fields('EV__idkAccomodation'); // Set up virtual field value } else { $this->idkAccomodation->VirtualValue = ""; // Clear value } $this->idkSeeker->setDbValue($rs->fields('idkSeeker')); if (array_key_exists('EV__idkSeeker', $rs->fields)) { $this->idkSeeker->VirtualValue = $rs->fields('EV__idkSeeker'); // Set up virtual field value } else { $this->idkSeeker->VirtualValue = ""; // Clear value } $this->Date_ass->setDbValue($rs->fields('Date_ass')); $this->Date_end->setDbValue($rs->fields('Date_end')); } // Load DbValue from recordset function LoadDbValues(&$rs) { if (!$rs || !is_array($rs) && $rs->EOF) return; $row = is_array($rs) ? $rs : $rs->fields; $this->idAssigment->DbValue = $row['idAssigment']; $this->idkAccomodation->DbValue = $row['idkAccomodation']; $this->idkSeeker->DbValue = $row['idkSeeker']; $this->Date_ass->DbValue = $row['Date_ass']; $this->Date_end->DbValue = $row['Date_end']; } // 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 // idAssigment // idkAccomodation // idkSeeker // Date_ass // Date_end if ($this->RowType == EW_ROWTYPE_VIEW) { // View row // idAssigment $this->idAssigment->ViewValue = $this->idAssigment->CurrentValue; $this->idAssigment->ViewCustomAttributes = ""; // idkAccomodation if ($this->idkAccomodation->VirtualValue <> "") { $this->idkAccomodation->ViewValue = $this->idkAccomodation->VirtualValue; } else { $this->idkAccomodation->ViewValue = $this->idkAccomodation->CurrentValue; if (strval($this->idkAccomodation->CurrentValue) <> "") { $sFilterWrk = "`idAccomodation`" . ew_SearchString("=", $this->idkAccomodation->CurrentValue, EW_DATATYPE_NUMBER, ""); switch (@$gsLanguage) { case "en": $sSqlWrk = "SELECT `idAccomodation`, `Town` AS `DispFld`, `Address` AS `Disp2Fld`, '' AS `Disp3Fld`, '' AS `Disp4Fld` FROM `taccomodations`"; $sWhereWrk = ""; $this->idkAccomodation->LookupFilters = array(); break; case "it": $sSqlWrk = "SELECT `idAccomodation`, `Town` AS `DispFld`, `Address` AS `Disp2Fld`, '' AS `Disp3Fld`, '' AS `Disp4Fld` FROM `taccomodations`"; $sWhereWrk = ""; $this->idkAccomodation->LookupFilters = array(); break; default: $sSqlWrk = "SELECT `idAccomodation`, `Town` AS `DispFld`, `Address` AS `Disp2Fld`, '' AS `Disp3Fld`, '' AS `Disp4Fld` FROM `taccomodations`"; $sWhereWrk = ""; $this->idkAccomodation->LookupFilters = array(); break; } ew_AddFilter($sWhereWrk, $sFilterWrk); $this->Lookup_Selecting($this->idkAccomodation, $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'); $this->idkAccomodation->ViewValue = $this->idkAccomodation->DisplayValue($arwrk); $rswrk->Close(); } else { $this->idkAccomodation->ViewValue = $this->idkAccomodation->CurrentValue; } } else { $this->idkAccomodation->ViewValue = NULL; } } $this->idkAccomodation->ViewCustomAttributes = ""; // idkSeeker if ($this->idkSeeker->VirtualValue <> "") { $this->idkSeeker->ViewValue = $this->idkSeeker->VirtualValue; } else { $this->idkSeeker->ViewValue = $this->idkSeeker->CurrentValue; if (strval($this->idkSeeker->CurrentValue) <> "") { $sFilterWrk = "`idSeeker`" . ew_SearchString("=", $this->idkSeeker->CurrentValue, EW_DATATYPE_NUMBER, ""); switch (@$gsLanguage) { case "en": $sSqlWrk = "SELECT `idSeeker`, `Name` AS `DispFld`, `Surname` AS `Disp2Fld`, `BirthDate` AS `Disp3Fld`, `BirthPlace` AS `Disp4Fld` FROM `tospiti`"; $sWhereWrk = ""; $this->idkSeeker->LookupFilters = array("df3" => "7"); break; case "it": $sSqlWrk = "SELECT `idSeeker`, `Name` AS `DispFld`, `Surname` AS `Disp2Fld`, `BirthDate` AS `Disp3Fld`, `BirthPlace` AS `Disp4Fld` FROM `tospiti`"; $sWhereWrk = ""; $this->idkSeeker->LookupFilters = array("df3" => "7"); break; default: $sSqlWrk = "SELECT `idSeeker`, `Name` AS `DispFld`, `Surname` AS `Disp2Fld`, `BirthDate` AS `Disp3Fld`, `BirthPlace` AS `Disp4Fld` FROM `tospiti`"; $sWhereWrk = ""; $this->idkSeeker->LookupFilters = array("df3" => "7"); break; } ew_AddFilter($sWhereWrk, $sFilterWrk); $this->Lookup_Selecting($this->idkSeeker, $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] = ew_FormatDateTime($rswrk->fields('Disp3Fld'), 7); $arwrk[4] = $rswrk->fields('Disp4Fld'); $this->idkSeeker->ViewValue = $this->idkSeeker->DisplayValue($arwrk); $rswrk->Close(); } else { $this->idkSeeker->ViewValue = $this->idkSeeker->CurrentValue; } } else { $this->idkSeeker->ViewValue = NULL; } } $this->idkSeeker->ViewCustomAttributes = ""; // Date_ass $this->Date_ass->ViewValue = $this->Date_ass->CurrentValue; $this->Date_ass->ViewValue = ew_FormatDateTime($this->Date_ass->ViewValue, 7); $this->Date_ass->ViewCustomAttributes = ""; // Date_end $this->Date_end->ViewValue = $this->Date_end->CurrentValue; $this->Date_end->ViewValue = ew_FormatDateTime($this->Date_end->ViewValue, 7); $this->Date_end->ViewCustomAttributes = ""; // idkAccomodation $this->idkAccomodation->LinkCustomAttributes = ""; if (!ew_Empty($this->idkAccomodation->CurrentValue)) { $this->idkAccomodation->HrefValue = "taccomodationsview.php?showdetail=&idAccomodation=" . $this->idkAccomodation->CurrentValue; // Add prefix/suffix $this->idkAccomodation->LinkAttrs["target"] = "_self"; // Add target if ($this->Export <> "") $this->idkAccomodation->HrefValue = ew_ConvertFullUrl($this->idkAccomodation->HrefValue); } else { $this->idkAccomodation->HrefValue = ""; } $this->idkAccomodation->TooltipValue = ""; // idkSeeker $this->idkSeeker->LinkCustomAttributes = ""; if (!ew_Empty($this->idkSeeker->CurrentValue)) { $this->idkSeeker->HrefValue = "tospitiview.php?showdetail=&idSeeker=" . $this->idkSeeker->CurrentValue; // Add prefix/suffix $this->idkSeeker->LinkAttrs["target"] = "_self"; // Add target if ($this->Export <> "") $this->idkSeeker->HrefValue = ew_ConvertFullUrl($this->idkSeeker->HrefValue); } else { $this->idkSeeker->HrefValue = ""; } $this->idkSeeker->TooltipValue = ""; // Date_ass $this->Date_ass->LinkCustomAttributes = ""; $this->Date_ass->HrefValue = ""; $this->Date_ass->TooltipValue = ""; // Date_end $this->Date_end->LinkCustomAttributes = ""; $this->Date_end->HrefValue = ""; $this->Date_end->TooltipValue = ""; } elseif ($this->RowType == EW_ROWTYPE_EDIT) { // Edit row // idkAccomodation $this->idkAccomodation->EditAttrs["class"] = "form-control"; $this->idkAccomodation->EditCustomAttributes = ""; if ($this->idkAccomodation->getSessionValue() <> "") { $this->idkAccomodation->CurrentValue = $this->idkAccomodation->getSessionValue(); if ($this->idkAccomodation->VirtualValue <> "") { $this->idkAccomodation->ViewValue = $this->idkAccomodation->VirtualValue; } else { $this->idkAccomodation->ViewValue = $this->idkAccomodation->CurrentValue; if (strval($this->idkAccomodation->CurrentValue) <> "") { $sFilterWrk = "`idAccomodation`" . ew_SearchString("=", $this->idkAccomodation->CurrentValue, EW_DATATYPE_NUMBER, ""); switch (@$gsLanguage) { case "en": $sSqlWrk = "SELECT `idAccomodation`, `Town` AS `DispFld`, `Address` AS `Disp2Fld`, '' AS `Disp3Fld`, '' AS `Disp4Fld` FROM `taccomodations`"; $sWhereWrk = ""; $this->idkAccomodation->LookupFilters = array(); break; case "it": $sSqlWrk = "SELECT `idAccomodation`, `Town` AS `DispFld`, `Address` AS `Disp2Fld`, '' AS `Disp3Fld`, '' AS `Disp4Fld` FROM `taccomodations`"; $sWhereWrk = ""; $this->idkAccomodation->LookupFilters = array(); break; default: $sSqlWrk = "SELECT `idAccomodation`, `Town` AS `DispFld`, `Address` AS `Disp2Fld`, '' AS `Disp3Fld`, '' AS `Disp4Fld` FROM `taccomodations`"; $sWhereWrk = ""; $this->idkAccomodation->LookupFilters = array(); break; } ew_AddFilter($sWhereWrk, $sFilterWrk); $this->Lookup_Selecting($this->idkAccomodation, $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'); $this->idkAccomodation->ViewValue = $this->idkAccomodation->DisplayValue($arwrk); $rswrk->Close(); } else { $this->idkAccomodation->ViewValue = $this->idkAccomodation->CurrentValue; } } else { $this->idkAccomodation->ViewValue = NULL; } } $this->idkAccomodation->ViewCustomAttributes = ""; } else { $this->idkAccomodation->EditValue = ew_HtmlEncode($this->idkAccomodation->CurrentValue); $this->idkAccomodation->PlaceHolder = ew_RemoveHtml($this->idkAccomodation->FldCaption()); } // idkSeeker $this->idkSeeker->EditAttrs["class"] = "form-control"; $this->idkSeeker->EditCustomAttributes = ""; if ($this->idkSeeker->getSessionValue() <> "") { $this->idkSeeker->CurrentValue = $this->idkSeeker->getSessionValue(); if ($this->idkSeeker->VirtualValue <> "") { $this->idkSeeker->ViewValue = $this->idkSeeker->VirtualValue; } else { $this->idkSeeker->ViewValue = $this->idkSeeker->CurrentValue; if (strval($this->idkSeeker->CurrentValue) <> "") { $sFilterWrk = "`idSeeker`" . ew_SearchString("=", $this->idkSeeker->CurrentValue, EW_DATATYPE_NUMBER, ""); switch (@$gsLanguage) { case "en": $sSqlWrk = "SELECT `idSeeker`, `Name` AS `DispFld`, `Surname` AS `Disp2Fld`, `BirthDate` AS `Disp3Fld`, `BirthPlace` AS `Disp4Fld` FROM `tospiti`"; $sWhereWrk = ""; $this->idkSeeker->LookupFilters = array("df3" => "7"); break; case "it": $sSqlWrk = "SELECT `idSeeker`, `Name` AS `DispFld`, `Surname` AS `Disp2Fld`, `BirthDate` AS `Disp3Fld`, `BirthPlace` AS `Disp4Fld` FROM `tospiti`"; $sWhereWrk = ""; $this->idkSeeker->LookupFilters = array("df3" => "7"); break; default: $sSqlWrk = "SELECT `idSeeker`, `Name` AS `DispFld`, `Surname` AS `Disp2Fld`, `BirthDate` AS `Disp3Fld`, `BirthPlace` AS `Disp4Fld` FROM `tospiti`"; $sWhereWrk = ""; $this->idkSeeker->LookupFilters = array("df3" => "7"); break; } ew_AddFilter($sWhereWrk, $sFilterWrk); $this->Lookup_Selecting($this->idkSeeker, $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] = ew_FormatDateTime($rswrk->fields('Disp3Fld'), 7); $arwrk[4] = $rswrk->fields('Disp4Fld'); $this->idkSeeker->ViewValue = $this->idkSeeker->DisplayValue($arwrk); $rswrk->Close(); } else { $this->idkSeeker->ViewValue = $this->idkSeeker->CurrentValue; } } else { $this->idkSeeker->ViewValue = NULL; } } $this->idkSeeker->ViewCustomAttributes = ""; } else { $this->idkSeeker->EditValue = ew_HtmlEncode($this->idkSeeker->CurrentValue); $this->idkSeeker->PlaceHolder = ew_RemoveHtml($this->idkSeeker->FldCaption()); } // Date_ass $this->Date_ass->EditAttrs["class"] = "form-control"; $this->Date_ass->EditCustomAttributes = ""; $this->Date_ass->EditValue = ew_HtmlEncode(ew_FormatDateTime($this->Date_ass->CurrentValue, 7)); $this->Date_ass->PlaceHolder = ew_RemoveHtml($this->Date_ass->FldCaption()); // Date_end $this->Date_end->EditAttrs["class"] = "form-control"; $this->Date_end->EditCustomAttributes = ""; $this->Date_end->EditValue = ew_HtmlEncode(ew_FormatDateTime($this->Date_end->CurrentValue, 7)); $this->Date_end->PlaceHolder = ew_RemoveHtml($this->Date_end->FldCaption()); // Edit refer script // idkAccomodation $this->idkAccomodation->LinkCustomAttributes = ""; if (!ew_Empty($this->idkAccomodation->CurrentValue)) { $this->idkAccomodation->HrefValue = "taccomodationsview.php?showdetail=&idAccomodation=" . $this->idkAccomodation->CurrentValue; // Add prefix/suffix $this->idkAccomodation->LinkAttrs["target"] = "_self"; // Add target if ($this->Export <> "") $this->idkAccomodation->HrefValue = ew_ConvertFullUrl($this->idkAccomodation->HrefValue); } else { $this->idkAccomodation->HrefValue = ""; } // idkSeeker $this->idkSeeker->LinkCustomAttributes = ""; if (!ew_Empty($this->idkSeeker->CurrentValue)) { $this->idkSeeker->HrefValue = "tospitiview.php?showdetail=&idSeeker=" . $this->idkSeeker->CurrentValue; // Add prefix/suffix $this->idkSeeker->LinkAttrs["target"] = "_self"; // Add target if ($this->Export <> "") $this->idkSeeker->HrefValue = ew_ConvertFullUrl($this->idkSeeker->HrefValue); } else { $this->idkSeeker->HrefValue = ""; } // Date_ass $this->Date_ass->LinkCustomAttributes = ""; $this->Date_ass->HrefValue = ""; // Date_end $this->Date_end->LinkCustomAttributes = ""; $this->Date_end->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 == ""); if (!$this->idkAccomodation->FldIsDetailKey && !is_null($this->idkAccomodation->FormValue) && $this->idkAccomodation->FormValue == "") { ew_AddMessage($gsFormError, str_replace("%s", $this->idkAccomodation->FldCaption(), $this->idkAccomodation->ReqErrMsg)); } if (!$this->idkSeeker->FldIsDetailKey && !is_null($this->idkSeeker->FormValue) && $this->idkSeeker->FormValue == "") { ew_AddMessage($gsFormError, str_replace("%s", $this->idkSeeker->FldCaption(), $this->idkSeeker->ReqErrMsg)); } if (!ew_CheckEuroDate($this->Date_ass->FormValue)) { ew_AddMessage($gsFormError, $this->Date_ass->FldErrMsg()); } if (!ew_CheckEuroDate($this->Date_end->FormValue)) { ew_AddMessage($gsFormError, $this->Date_end->FldErrMsg()); } // Validate detail grid $DetailTblVar = explode(",", $this->getCurrentDetailTable()); if (in_array("tass_notes", $DetailTblVar) && $GLOBALS["tass_notes"]->DetailEdit) { if (!isset($GLOBALS["tass_notes_grid"])) $GLOBALS["tass_notes_grid"] = new ctass_notes_grid(); // get detail page object $GLOBALS["tass_notes_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); $rsnew = array(); // idkAccomodation $this->idkAccomodation->SetDbValueDef($rsnew, $this->idkAccomodation->CurrentValue, 0, $this->idkAccomodation->ReadOnly); // idkSeeker $this->idkSeeker->SetDbValueDef($rsnew, $this->idkSeeker->CurrentValue, 0, $this->idkSeeker->ReadOnly); // Date_ass $this->Date_ass->SetDbValueDef($rsnew, ew_UnFormatDateTime($this->Date_ass->CurrentValue, 7), NULL, $this->Date_ass->ReadOnly); // Date_end $this->Date_end->SetDbValueDef($rsnew, ew_UnFormatDateTime($this->Date_end->CurrentValue, 7), NULL, $this->Date_end->ReadOnly); // Check referential integrity for master table 'tospiti' $bValidMasterRecord = TRUE; $sMasterFilter = $this->SqlMasterFilter_tospiti(); $KeyValue = isset($rsnew['idkSeeker']) ? $rsnew['idkSeeker'] : $rsold['idkSeeker']; if (strval($KeyValue) <> "") { $sMasterFilter = str_replace("@idSeeker@", ew_AdjustSql($KeyValue), $sMasterFilter); } else { $bValidMasterRecord = FALSE; } if ($bValidMasterRecord) { if (!isset($GLOBALS["tospiti"])) $GLOBALS["tospiti"] = new ctospiti(); $rsmaster = $GLOBALS["tospiti"]->LoadRs($sMasterFilter); $bValidMasterRecord = ($rsmaster && !$rsmaster->EOF); $rsmaster->Close(); } if (!$bValidMasterRecord) { $sRelatedRecordMsg = str_replace("%t", "tospiti", $Language->Phrase("RelatedRecordRequired")); $this->setFailureMessage($sRelatedRecordMsg); $rs->Close(); return FALSE; } // Check referential integrity for master table 'taccomodations' $bValidMasterRecord = TRUE; $sMasterFilter = $this->SqlMasterFilter_taccomodations(); $KeyValue = isset($rsnew['idkAccomodation']) ? $rsnew['idkAccomodation'] : $rsold['idkAccomodation']; if (strval($KeyValue) <> "") { $sMasterFilter = str_replace("@idAccomodation@", ew_AdjustSql($KeyValue), $sMasterFilter); } else { $bValidMasterRecord = FALSE; } if ($bValidMasterRecord) { if (!isset($GLOBALS["taccomodations"])) $GLOBALS["taccomodations"] = new ctaccomodations(); $rsmaster = $GLOBALS["taccomodations"]->LoadRs($sMasterFilter); $bValidMasterRecord = ($rsmaster && !$rsmaster->EOF); $rsmaster->Close(); } if (!$bValidMasterRecord) { $sRelatedRecordMsg = str_replace("%t", "taccomodations", $Language->Phrase("RelatedRecordRequired")); $this->setFailureMessage($sRelatedRecordMsg); $rs->Close(); return FALSE; } // 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) { } // Update detail records $DetailTblVar = explode(",", $this->getCurrentDetailTable()); if ($EditRow) { if (in_array("tass_notes", $DetailTblVar) && $GLOBALS["tass_notes"]->DetailEdit) { if (!isset($GLOBALS["tass_notes_grid"])) $GLOBALS["tass_notes_grid"] = new ctass_notes_grid(); // Get detail page object $Security->LoadCurrentUserLevel($this->ProjectID . "tass_notes"); // Load user level of detail table $EditRow = $GLOBALS["tass_notes_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(); 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 == "tospiti") { $bValidMaster = TRUE; if (@$_GET["fk_idSeeker"] <> "") { $GLOBALS["tospiti"]->idSeeker->setQueryStringValue($_GET["fk_idSeeker"]); $this->idkSeeker->setQueryStringValue($GLOBALS["tospiti"]->idSeeker->QueryStringValue); $this->idkSeeker->setSessionValue($this->idkSeeker->QueryStringValue); if (!is_numeric($GLOBALS["tospiti"]->idSeeker->QueryStringValue)) $bValidMaster = FALSE; } else { $bValidMaster = FALSE; } } if ($sMasterTblVar == "taccomodations") { $bValidMaster = TRUE; if (@$_GET["fk_idAccomodation"] <> "") { $GLOBALS["taccomodations"]->idAccomodation->setQueryStringValue($_GET["fk_idAccomodation"]); $this->idkAccomodation->setQueryStringValue($GLOBALS["taccomodations"]->idAccomodation->QueryStringValue); $this->idkAccomodation->setSessionValue($this->idkAccomodation->QueryStringValue); if (!is_numeric($GLOBALS["taccomodations"]->idAccomodation->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 == "tospiti") { $bValidMaster = TRUE; if (@$_POST["fk_idSeeker"] <> "") { $GLOBALS["tospiti"]->idSeeker->setFormValue($_POST["fk_idSeeker"]); $this->idkSeeker->setFormValue($GLOBALS["tospiti"]->idSeeker->FormValue); $this->idkSeeker->setSessionValue($this->idkSeeker->FormValue); if (!is_numeric($GLOBALS["tospiti"]->idSeeker->FormValue)) $bValidMaster = FALSE; } else { $bValidMaster = FALSE; } } if ($sMasterTblVar == "taccomodations") { $bValidMaster = TRUE; if (@$_POST["fk_idAccomodation"] <> "") { $GLOBALS["taccomodations"]->idAccomodation->setFormValue($_POST["fk_idAccomodation"]); $this->idkAccomodation->setFormValue($GLOBALS["taccomodations"]->idAccomodation->FormValue); $this->idkAccomodation->setSessionValue($this->idkAccomodation->FormValue); if (!is_numeric($GLOBALS["taccomodations"]->idAccomodation->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 <> "tospiti") { if ($this->idkSeeker->CurrentValue == "") $this->idkSeeker->setSessionValue(""); } if ($sMasterTblVar <> "taccomodations") { if ($this->idkAccomodation->CurrentValue == "") $this->idkAccomodation->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("tass_notes", $DetailTblVar)) { if (!isset($GLOBALS["tass_notes_grid"])) $GLOBALS["tass_notes_grid"] = new ctass_notes_grid; if ($GLOBALS["tass_notes_grid"]->DetailEdit) { $GLOBALS["tass_notes_grid"]->CurrentMode = "edit"; $GLOBALS["tass_notes_grid"]->CurrentAction = "gridedit"; // Save current master table to detail table $GLOBALS["tass_notes_grid"]->setCurrentMasterTable($this->TableVar); $GLOBALS["tass_notes_grid"]->setStartRecordNumber(1); $GLOBALS["tass_notes_grid"]->idkAssignment->FldIsDetailKey = TRUE; $GLOBALS["tass_notes_grid"]->idkAssignment->CurrentValue = $this->idAssigment->CurrentValue; $GLOBALS["tass_notes_grid"]->idkAssignment->setSessionValue($GLOBALS["tass_notes_grid"]->idkAssignment->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("tassigmentlist.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_idkAccomodation": $sSqlWrk = ""; switch (@$gsLanguage) { case "en": $sSqlWrk = "SELECT `idAccomodation` AS `LinkFld`, `Town` AS `DispFld`, `Address` AS `Disp2Fld`, '' AS `Disp3Fld`, '' AS `Disp4Fld` FROM `taccomodations`"; $sWhereWrk = "{filter}"; $this->idkAccomodation->LookupFilters = array(); break; case "it": $sSqlWrk = "SELECT `idAccomodation` AS `LinkFld`, `Town` AS `DispFld`, `Address` AS `Disp2Fld`, '' AS `Disp3Fld`, '' AS `Disp4Fld` FROM `taccomodations`"; $sWhereWrk = "{filter}"; $this->idkAccomodation->LookupFilters = array(); break; default: $sSqlWrk = "SELECT `idAccomodation` AS `LinkFld`, `Town` AS `DispFld`, `Address` AS `Disp2Fld`, '' AS `Disp3Fld`, '' AS `Disp4Fld` FROM `taccomodations`"; $sWhereWrk = "{filter}"; $this->idkAccomodation->LookupFilters = array(); break; } $fld->LookupFilters += array("s" => $sSqlWrk, "d" => "", "f0" => '`idAccomodation` = {filter_value}', "t0" => "19", "fn0" => ""); $sSqlWrk = ""; $this->Lookup_Selecting($this->idkAccomodation, $sWhereWrk); // Call Lookup selecting if ($sWhereWrk <> "") $sSqlWrk .= " WHERE " . $sWhereWrk; if ($sSqlWrk <> "") $fld->LookupFilters["s"] .= $sSqlWrk; break; case "x_idkSeeker": $sSqlWrk = ""; switch (@$gsLanguage) { case "en": $sSqlWrk = "SELECT `idSeeker` AS `LinkFld`, `Name` AS `DispFld`, `Surname` AS `Disp2Fld`, `BirthDate` AS `Disp3Fld`, `BirthPlace` AS `Disp4Fld` FROM `tospiti`"; $sWhereWrk = "{filter}"; $this->idkSeeker->LookupFilters = array("df3" => "7"); break; case "it": $sSqlWrk = "SELECT `idSeeker` AS `LinkFld`, `Name` AS `DispFld`, `Surname` AS `Disp2Fld`, `BirthDate` AS `Disp3Fld`, `BirthPlace` AS `Disp4Fld` FROM `tospiti`"; $sWhereWrk = "{filter}"; $this->idkSeeker->LookupFilters = array("df3" => "7"); break; default: $sSqlWrk = "SELECT `idSeeker` AS `LinkFld`, `Name` AS `DispFld`, `Surname` AS `Disp2Fld`, `BirthDate` AS `Disp3Fld`, `BirthPlace` AS `Disp4Fld` FROM `tospiti`"; $sWhereWrk = "{filter}"; $this->idkSeeker->LookupFilters = array("df3" => "7"); break; } $fld->LookupFilters += array("s" => $sSqlWrk, "d" => "", "f0" => '`idSeeker` = {filter_value}', "t0" => "19", "fn0" => ""); $sSqlWrk = ""; $this->Lookup_Selecting($this->idkSeeker, $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_idkAccomodation": $sSqlWrk = ""; switch (@$gsLanguage) { case "en": $sSqlWrk = "SELECT `idAccomodation`, `Town` AS `DispFld`, `Address` AS `Disp2Fld` FROM `taccomodations`"; $sWhereWrk = "`Town` LIKE '{query_value}%' OR CONCAT(`Town`,'" . ew_ValueSeparator(1, $this->idkAccomodation) . "',`Address`) LIKE '{query_value}%'"; $this->idkAccomodation->LookupFilters = array(); break; case "it": $sSqlWrk = "SELECT `idAccomodation`, `Town` AS `DispFld`, `Address` AS `Disp2Fld` FROM `taccomodations`"; $sWhereWrk = "`Town` LIKE '{query_value}%' OR CONCAT(`Town`,'" . ew_ValueSeparator(1, $this->idkAccomodation) . "',`Address`) LIKE '{query_value}%'"; $this->idkAccomodation->LookupFilters = array(); break; default: $sSqlWrk = "SELECT `idAccomodation`, `Town` AS `DispFld`, `Address` AS `Disp2Fld` FROM `taccomodations`"; $sWhereWrk = "`Town` LIKE '{query_value}%' OR CONCAT(`Town`,'" . ew_ValueSeparator(1, $this->idkAccomodation) . "',`Address`) LIKE '{query_value}%'"; $this->idkAccomodation->LookupFilters = array(); break; } $fld->LookupFilters += array("s" => $sSqlWrk, "d" => ""); $sSqlWrk = ""; $this->Lookup_Selecting($this->idkAccomodation, $sWhereWrk); // Call Lookup selecting if ($sWhereWrk <> "") $sSqlWrk .= " WHERE " . $sWhereWrk; $sSqlWrk .= " LIMIT " . EW_AUTO_SUGGEST_MAX_ENTRIES; if ($sSqlWrk <> "") $fld->LookupFilters["s"] .= $sSqlWrk; break; case "x_idkSeeker": $sSqlWrk = ""; switch (@$gsLanguage) { case "en": $sSqlWrk = "SELECT `idSeeker`, `Name` AS `DispFld`, `Surname` AS `Disp2Fld`, `BirthDate` AS `Disp3Fld`, `BirthPlace` AS `Disp4Fld` FROM `tospiti`"; $sWhereWrk = "`Name` LIKE '{query_value}%' OR CONCAT(`Name`,'" . ew_ValueSeparator(1, $this->idkSeeker) . "',`Surname`,'" . ew_ValueSeparator(2, $this->idkSeeker) . "'," . ew_CastDateFieldForLike('`BirthDate`', 7, "DB") . ",'" . ew_ValueSeparator(3, $this->idkSeeker) . "',`BirthPlace`) LIKE '{query_value}%'"; $this->idkSeeker->LookupFilters = array("df3" => "7"); break; case "it": $sSqlWrk = "SELECT `idSeeker`, `Name` AS `DispFld`, `Surname` AS `Disp2Fld`, `BirthDate` AS `Disp3Fld`, `BirthPlace` AS `Disp4Fld` FROM `tospiti`"; $sWhereWrk = "`Name` LIKE '{query_value}%' OR CONCAT(`Name`,'" . ew_ValueSeparator(1, $this->idkSeeker) . "',`Surname`,'" . ew_ValueSeparator(2, $this->idkSeeker) . "'," . ew_CastDateFieldForLike('`BirthDate`', 7, "DB") . ",'" . ew_ValueSeparator(3, $this->idkSeeker) . "',`BirthPlace`) LIKE '{query_value}%'"; $this->idkSeeker->LookupFilters = array("df3" => "7"); break; default: $sSqlWrk = "SELECT `idSeeker`, `Name` AS `DispFld`, `Surname` AS `Disp2Fld`, `BirthDate` AS `Disp3Fld`, `BirthPlace` AS `Disp4Fld` FROM `tospiti`"; $sWhereWrk = "`Name` LIKE '{query_value}%' OR CONCAT(`Name`,'" . ew_ValueSeparator(1, $this->idkSeeker) . "',`Surname`,'" . ew_ValueSeparator(2, $this->idkSeeker) . "'," . ew_CastDateFieldForLike('`BirthDate`', 7, "DB") . ",'" . ew_ValueSeparator(3, $this->idkSeeker) . "',`BirthPlace`) LIKE '{query_value}%'"; $this->idkSeeker->LookupFilters = array("df3" => "7"); break; } $fld->LookupFilters += array("s" => $sSqlWrk, "d" => ""); $sSqlWrk = ""; $this->Lookup_Selecting($this->idkSeeker, $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 $tassigment_edit->Page_Main(); // Global Page Rendering event (in userfn*.php) Page_Rendering(); // Page Rendering event $tassigment_edit->Page_Render(); ?> IsModal) { ?> ShowPageHeader(); ?> ShowMessage(); ?> IsModal) { ?> ShowPageFooter(); if (EW_DEBUG_ENABLED) echo ew_DebugMsg(); ?> Page_Terminate(); ?>