UseTokenInUrl) $PageUrl .= "t=" . $this->TableVar . "&"; // Add page token return $PageUrl; } // Page URLs var $AddUrl; var $EditUrl; var $CopyUrl; var $DeleteUrl; var $ViewUrl; var $ListUrl; // Export URLs var $ExportPrintUrl; var $ExportHtmlUrl; var $ExportExcelUrl; var $ExportWordUrl; var $ExportXmlUrl; var $ExportCsvUrl; var $ExportPdfUrl; // Custom export var $ExportExcelCustom = FALSE; var $ExportWordCustom = FALSE; var $ExportPdfCustom = FALSE; var $ExportEmailCustom = FALSE; // Update URLs var $InlineAddUrl; var $InlineCopyUrl; var $InlineEditUrl; var $GridAddUrl; var $GridEditUrl; var $MultiDeleteUrl; var $MultiUpdateUrl; // Message function getMessage() { return @$_SESSION[EW_SESSION_MESSAGE]; } function setMessage($v) { ew_AddMessage($_SESSION[EW_SESSION_MESSAGE], $v); } function getFailureMessage() { return @$_SESSION[EW_SESSION_FAILURE_MESSAGE]; } function setFailureMessage($v) { ew_AddMessage($_SESSION[EW_SESSION_FAILURE_MESSAGE], $v); } function getSuccessMessage() { return @$_SESSION[EW_SESSION_SUCCESS_MESSAGE]; } function setSuccessMessage($v) { ew_AddMessage($_SESSION[EW_SESSION_SUCCESS_MESSAGE], $v); } function getWarningMessage() { return @$_SESSION[EW_SESSION_WARNING_MESSAGE]; } function setWarningMessage($v) { ew_AddMessage($_SESSION[EW_SESSION_WARNING_MESSAGE], $v); } // Methods to clear message function ClearMessage() { $_SESSION[EW_SESSION_MESSAGE] = ""; } function ClearFailureMessage() { $_SESSION[EW_SESSION_FAILURE_MESSAGE] = ""; } function ClearSuccessMessage() { $_SESSION[EW_SESSION_SUCCESS_MESSAGE] = ""; } function ClearWarningMessage() { $_SESSION[EW_SESSION_WARNING_MESSAGE] = ""; } function ClearMessages() { $_SESSION[EW_SESSION_MESSAGE] = ""; $_SESSION[EW_SESSION_FAILURE_MESSAGE] = ""; $_SESSION[EW_SESSION_SUCCESS_MESSAGE] = ""; $_SESSION[EW_SESSION_WARNING_MESSAGE] = ""; } // Show message function ShowMessage() { $hidden = FALSE; $html = ""; // Message $sMessage = $this->getMessage(); if (method_exists($this, "Message_Showing")) $this->Message_Showing($sMessage, ""); if ($sMessage <> "") { // Message in Session, display if (!$hidden) $sMessage = "" . $sMessage; $html .= "

" . $sMessage . "

"; $_SESSION[EW_SESSION_MESSAGE] = ""; // Clear message in Session } // Warning message $sWarningMessage = $this->getWarningMessage(); if (method_exists($this, "Message_Showing")) $this->Message_Showing($sWarningMessage, "warning"); if ($sWarningMessage <> "") { // Message in Session, display if (!$hidden) $sWarningMessage = "" . $sWarningMessage; $html .= "

" . $sWarningMessage . "

"; $_SESSION[EW_SESSION_WARNING_MESSAGE] = ""; // Clear message in Session } // Success message $sSuccessMessage = $this->getSuccessMessage(); if (method_exists($this, "Message_Showing")) $this->Message_Showing($sSuccessMessage, "success"); if ($sSuccessMessage <> "") { // Message in Session, display if (!$hidden) $sSuccessMessage = "" . $sSuccessMessage; $html .= "

" . $sSuccessMessage . "

"; $_SESSION[EW_SESSION_SUCCESS_MESSAGE] = ""; // Clear message in Session } // Failure message $sErrorMessage = $this->getFailureMessage(); if (method_exists($this, "Message_Showing")) $this->Message_Showing($sErrorMessage, "failure"); if ($sErrorMessage <> "") { // Message in Session, display if (!$hidden) $sErrorMessage = "" . $sErrorMessage; $html .= "

" . $sErrorMessage . "

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

" . $html . "

"; } var $PageHeader; var $PageFooter; // Show Page Header function ShowPageHeader() { $sHeader = $this->PageHeader; $this->Page_DataRendering($sHeader); if ($sHeader <> "") { // Header exists, display echo "

" . $sHeader . "

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

" . $sFooter . "

"; } } // Validate page request function IsPageRequest() { global $objForm; if ($this->UseTokenInUrl) { if ($objForm) return ($this->TableVar == $objForm->GetValue("t")); if (@$_GET["t"] <> "") return ($this->TableVar == $_GET["t"]); } else { return TRUE; } } var $Token = ""; var $TokenTimeout = 0; var $CheckToken = EW_CHECK_TOKEN; var $CheckTokenFn = "ew_CheckToken"; var $CreateTokenFn = "ew_CreateToken"; // Valid Post function ValidPost() { if (!$this->CheckToken || !ew_IsHttpPost()) return TRUE; if (!isset($_POST[EW_TOKEN_NAME])) return FALSE; $fn = $this->CheckTokenFn; if (is_callable($fn)) return $fn($_POST[EW_TOKEN_NAME], $this->TokenTimeout); return FALSE; } // Create Token function CreateToken() { global $gsToken; if ($this->CheckToken) { $fn = $this->CreateTokenFn; if ($this->Token == "" && is_callable($fn)) // Create token $this->Token = $fn(); $gsToken = $this->Token; // Save to global variable } } // // Page class constructor // function __construct() { global $conn, $Language; global $UserTable, $UserTableConn; $GLOBALS["Page"] = &$this; $this->TokenTimeout = ew_SessionTimeoutTime(); // Language object if (!isset($Language)) $Language = new cLanguage(); // Parent constuctor parent::__construct(); // Table object (tospiti) if (!isset($GLOBALS["tospiti"]) || get_class($GLOBALS["tospiti"]) == "ctospiti") { $GLOBALS["tospiti"] = &$this; $GLOBALS["Table"] = &$GLOBALS["tospiti"]; } $KeyUrl = ""; if (@$_GET["idSeeker"] <> "") { $this->RecKey["idSeeker"] = $_GET["idSeeker"]; $KeyUrl .= "&idSeeker=" . urlencode($this->RecKey["idSeeker"]); } $this->ExportPrintUrl = $this->PageUrl() . "export=print" . $KeyUrl; $this->ExportHtmlUrl = $this->PageUrl() . "export=html" . $KeyUrl; $this->ExportExcelUrl = $this->PageUrl() . "export=excel" . $KeyUrl; $this->ExportWordUrl = $this->PageUrl() . "export=word" . $KeyUrl; $this->ExportXmlUrl = $this->PageUrl() . "export=xml" . $KeyUrl; $this->ExportCsvUrl = $this->PageUrl() . "export=csv" . $KeyUrl; $this->ExportPdfUrl = $this->PageUrl() . "export=pdf" . $KeyUrl; // Table object (users) if (!isset($GLOBALS['users'])) $GLOBALS['users'] = new cusers(); // Page ID if (!defined("EW_PAGE_ID")) define("EW_PAGE_ID", 'view', TRUE); // Table name (for backward compatibility) if (!defined("EW_TABLE_NAME")) define("EW_TABLE_NAME", 'tospiti', TRUE); // Start timer if (!isset($GLOBALS["gTimer"])) $GLOBALS["gTimer"] = new cTimer(); // Open connection if (!isset($conn)) $conn = ew_Connect($this->DBID); // User table object (users) if (!isset($UserTable)) { $UserTable = new cusers(); $UserTableConn = Conn($UserTable->DBID); } // Export options $this->ExportOptions = new cListOptions(); $this->ExportOptions->Tag = "div"; $this->ExportOptions->TagClassName = "ewExportOption"; // Other options $this->OtherOptions['action'] = new cListOptions(); $this->OtherOptions['action']->Tag = "div"; $this->OtherOptions['action']->TagClassName = "ewActionOption"; $this->OtherOptions['detail'] = new cListOptions(); $this->OtherOptions['detail']->Tag = "div"; $this->OtherOptions['detail']->TagClassName = "ewDetailOption"; } // // Page_Init // function Page_Init() { global $gsExport, $gsCustomExport, $gsExportFile, $UserProfile, $Language, $Security, $objForm; // Security $Security = new cAdvancedSecurity(); if (!$Security->IsLoggedIn()) $Security->AutoLogin(); if ($Security->IsLoggedIn()) $Security->TablePermission_Loading(); $Security->LoadCurrentUserLevel($this->ProjectID . $this->TableName); if ($Security->IsLoggedIn()) $Security->TablePermission_Loaded(); if (!$Security->CanView()) { $Security->SaveLastUrl(); $this->setFailureMessage(ew_DeniedMsg()); // Set no permission if ($Security->CanList()) $this->Page_Terminate(ew_GetUrl("tospitilist.php")); else $this->Page_Terminate(ew_GetUrl("login.php")); } // Get export parameters $custom = ""; if (@$_GET["export"] <> "") { $this->Export = $_GET["export"]; $custom = @$_GET["custom"]; } elseif (@$_POST["export"] <> "") { $this->Export = $_POST["export"]; $custom = @$_POST["custom"]; } elseif (ew_IsHttpPost()) { if (@$_POST["exporttype"] <> "") $this->Export = $_POST["exporttype"]; $custom = @$_POST["custom"]; } else { $this->setExportReturnUrl(ew_CurrentUrl()); } $gsExportFile = $this->TableVar; // Get export file, used in header if (@$_GET["idSeeker"] <> "") { if ($gsExportFile <> "") $gsExportFile .= "_"; $gsExportFile .= ew_StripSlashes($_GET["idSeeker"]); } // Get custom export parameters if ($this->Export <> "" && $custom <> "") { $this->CustomExport = $this->Export; $this->Export = "print"; } $gsCustomExport = $this->CustomExport; $gsExport = $this->Export; // Get export parameter, used in header // Update Export URLs if (defined("EW_USE_PHPEXCEL")) $this->ExportExcelCustom = FALSE; if ($this->ExportExcelCustom) $this->ExportExcelUrl .= "&custom=1"; if (defined("EW_USE_PHPWORD")) $this->ExportWordCustom = FALSE; if ($this->ExportWordCustom) $this->ExportWordUrl .= "&custom=1"; if ($this->ExportPdfCustom) $this->ExportPdfUrl .= "&custom=1"; $this->CurrentAction = (@$_GET["a"] <> "") ? $_GET["a"] : @$_POST["a_list"]; // Set up current action // Setup export options $this->SetupExportOptions(); $this->Desk->SetVisibility(); $this->UNHCR_code->SetVisibility(); $this->Name->SetVisibility(); $this->Surname->SetVisibility(); $this->BirthDate->SetVisibility(); $this->BirthPlace->SetVisibility(); $this->Nationality->SetVisibility(); $this->Citizenship->SetVisibility(); $this->Sex->SetVisibility(); $this->Phone->SetVisibility(); $this->_Email->SetVisibility(); $this->Religion->SetVisibility(); $this->Place_of_Residence->SetVisibility(); $this->Address_of_Residence->SetVisibility(); $this->Town_of_residence->SetVisibility(); $this->Place_of_Transit->SetVisibility(); $this->Address_of_Transit->SetVisibility(); $this->Town_of_transit->SetVisibility(); $this->domicile_description->SetVisibility(); $this->Disabled->SetVisibility(); $this->Sick->SetVisibility(); $this->Alone->SetVisibility(); $this->Elderly->SetVisibility(); $this->Family->SetVisibility(); $this->Householder->SetVisibility(); $this->Householder_id->SetVisibility(); $this->Householder_reltype->SetVisibility(); $this->Ethnic_group->SetVisibility(); $this->Known_languages->SetVisibility(); $this->Title_of_study->SetVisibility(); $this->Poss_destination_country->SetVisibility(); $this->Document_type->SetVisibility(); $this->Document_number->SetVisibility(); $this->Document_release->SetVisibility(); $this->Document_expiry->SetVisibility(); $this->Document_nationality->SetVisibility(); $this->other_documents->SetVisibility(); $this->Final_evaluation->SetVisibility(); $this->photo->SetVisibility(); $this->doc_image->SetVisibility(); $this->Notes->SetVisibility(); $this->Interview_1->SetVisibility(); $this->interview1_date->SetVisibility(); $this->Interview_2->SetVisibility(); $this->interview_2_date->SetVisibility(); $this->Interview_3->SetVisibility(); $this->interview_3_date->SetVisibility(); $this->Zone_of_Transit->SetVisibility(); $this->Travel_number->SetVisibility(); $this->Travel_arrival_date->SetVisibility(); $this->Travel_arrival_time->SetVisibility(); $this->num_family->SetVisibility(); $this->speak_ENG->SetVisibility(); $this->speak_FRA->SetVisibility(); $this->speak_ARA->SetVisibility(); $this->speak_ITA->SetVisibility(); $this->lives_with->SetVisibility(); $this->family_know->SetVisibility(); $this->date_of_entry_transit->SetVisibility(); $this->marital_status->SetVisibility(); $this->consort_id->SetVisibility(); $this->consort_info->SetVisibility(); $this->other_fam_in_italy->SetVisibility(); $this->other_fam_in_europe->SetVisibility(); $this->where_lived->SetVisibility(); $this->medical_situation->SetVisibility(); $this->social_situation->SetVisibility(); $this->abuse_suffered->SetVisibility(); $this->abuse_description->SetVisibility(); $this->work_done->SetVisibility(); $this->military_service->SetVisibility(); $this->itinerary->SetVisibility(); $this->convictions->SetVisibility(); $this->requested_asylum->SetVisibility(); $this->resettlement_application->SetVisibility(); $this->resettlement_country->SetVisibility(); $this->reunion_application->SetVisibility(); $this->reunion_country->SetVisibility(); $this->belongs_to_organization->SetVisibility(); $this->organizations->SetVisibility(); $this->presentations->SetVisibility(); $this->report->SetVisibility(); // Global Page Loading event (in userfn*.php) Page_Loading(); // Page Load event $this->Page_Load(); // Check token if (!$this->ValidPost()) { echo $Language->Phrase("InvalidPostRequest"); $this->Page_Terminate(); exit(); } // Create Token $this->CreateToken(); } // // Page_Terminate // function Page_Terminate($url = "") { global $gsExportFile, $gTmpImages; // Page Unload event $this->Page_Unload(); // Global Page Unloaded event (in userfn*.php) Page_Unloaded(); // Export global $EW_EXPORT, $tospiti; 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($tospiti); $doc->Text = $sContent; if ($this->Export == "email") echo $this->ExportEmail($doc->Text); else $doc->Export(); ew_DeleteTmpImages(); // Delete temp images exit(); } } $this->Page_Redirecting($url); // Close connection ew_CloseConn(); // Go to URL if specified if ($url <> "") { if (!EW_DEBUG_ENABLED && ob_get_length()) ob_end_clean(); // Handle modal response if ($this->IsModal) { $row = array(); $row["url"] = $url; echo ew_ArrayToJson(array($row)); } else { header("Location: " . $url); } } exit(); } var $ExportOptions; // Export options var $OtherOptions = array(); // Other options var $DisplayRecs = 1; var $DbMasterFilter; var $DbDetailFilter; var $StartRec; var $StopRec; var $TotalRecs = 0; var $RecRange = 10; var $Pager; var $RecCnt; var $RecKey = array(); var $IsModal = FALSE; var $tassigment_Count; var $Recordset; // // Page main // function Page_Main() { global $Language; global $gbSkipHeaderFooter; // Check modal $this->IsModal = (@$_GET["modal"] == "1" || @$_POST["modal"] == "1"); if ($this->IsModal) $gbSkipHeaderFooter = TRUE; // Load current record $bLoadCurrentRecord = FALSE; $sReturnUrl = ""; $bMatchRecord = FALSE; if ($this->IsPageRequest()) { // Validate request if (@$_GET["idSeeker"] <> "") { $this->idSeeker->setQueryStringValue($_GET["idSeeker"]); $this->RecKey["idSeeker"] = $this->idSeeker->QueryStringValue; } elseif (@$_POST["idSeeker"] <> "") { $this->idSeeker->setFormValue($_POST["idSeeker"]); $this->RecKey["idSeeker"] = $this->idSeeker->FormValue; } else { $bLoadCurrentRecord = TRUE; } // Get action $this->CurrentAction = "I"; // Display form switch ($this->CurrentAction) { case "I": // Get a record to display $this->StartRec = 1; // Initialize start position if ($this->Recordset = $this->LoadRecordset()) // Load records $this->TotalRecs = $this->Recordset->RecordCount(); // Get record count if ($this->TotalRecs <= 0) { // No record found if ($this->getSuccessMessage() == "" && $this->getFailureMessage() == "") $this->setFailureMessage($Language->Phrase("NoRecord")); // Set no record message $this->Page_Terminate("tospitilist.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->idSeeker->CurrentValue) == strval($this->Recordset->fields('idSeeker'))) { $this->setStartRecordNumber($this->StartRec); // Save record position $bMatchRecord = TRUE; break; } else { $this->StartRec++; $this->Recordset->MoveNext(); } } } if (!$bMatchRecord) { if ($this->getSuccessMessage() == "" && $this->getFailureMessage() == "") $this->setFailureMessage($Language->Phrase("NoRecord")); // Set no record message $sReturnUrl = "tospitilist.php"; // No matching record, return to list } else { $this->LoadRowValues($this->Recordset); // Load row values } } // Export data only if ($this->CustomExport == "" && in_array($this->Export, array("html","word","excel","xml","csv","email","pdf"))) { $this->ExportData(); $this->Page_Terminate(); // Terminate response exit(); } } else { $sReturnUrl = "tospitilist.php"; // Not page request, return to list } if ($sReturnUrl <> "") $this->Page_Terminate($sReturnUrl); // Set up Breadcrumb if ($this->Export == "") $this->SetupBreadcrumb(); // Render row $this->RowType = EW_ROWTYPE_VIEW; $this->ResetAttrs(); $this->RenderRow(); // Set up detail parameters $this->SetUpDetailParms(); } // Set up other options function SetupOtherOptions() { global $Language, $Security; $options = &$this->OtherOptions; $option = &$options["action"]; // Add $item = &$option->Add("add"); $addcaption = ew_HtmlTitle($Language->Phrase("ViewPageAddLink")); if ($this->IsModal) // Modal $item->Body = "AddUrl) . "',caption:'" . $addcaption . "'});\">" . $Language->Phrase("ViewPageAddLink") . ""; else $item->Body = "AddUrl) . "\">" . $Language->Phrase("ViewPageAddLink") . ""; $item->Visible = ($this->AddUrl <> "" && $Security->CanAdd()); // Edit $item = &$option->Add("edit"); $editcaption = ew_HtmlTitle($Language->Phrase("ViewPageEditLink")); if ($this->IsModal) // Modal $item->Body = "EditUrl) . "',caption:'" . $editcaption . "'});\">" . $Language->Phrase("ViewPageEditLink") . ""; else $item->Body = "EditUrl) . "\">" . $Language->Phrase("ViewPageEditLink") . ""; $item->Visible = ($this->EditUrl <> "" && $Security->CanEdit()); // Delete $item = &$option->Add("delete"); if ($this->IsModal) // Handle as inline delete $item->Body = "Phrase("ViewPageDeleteLink")) . "\" data-caption=\"" . ew_HtmlTitle($Language->Phrase("ViewPageDeleteLink")) . "\" href=\"" . ew_HtmlEncode(ew_AddQueryStringToUrl($this->DeleteUrl, "a_delete=1")) . "\">" . $Language->Phrase("ViewPageDeleteLink") . ""; else $item->Body = "Phrase("ViewPageDeleteLink")) . "\" data-caption=\"" . ew_HtmlTitle($Language->Phrase("ViewPageDeleteLink")) . "\" href=\"" . ew_HtmlEncode($this->DeleteUrl) . "\">" . $Language->Phrase("ViewPageDeleteLink") . ""; $item->Visible = ($this->DeleteUrl <> "" && $Security->CanDelete()); $option = &$options["detail"]; $DetailTableLink = ""; $DetailViewTblVar = ""; $DetailCopyTblVar = ""; $DetailEditTblVar = ""; // "detail_tassigment" $item = &$option->Add("detail_tassigment"); $body = $Language->Phrase("ViewPageDetailLink") . $Language->TablePhrase("tassigment", "TblCaption"); $body .= str_replace("%c", $this->tassigment_Count, $Language->Phrase("DetailCount")); $body = "idSeeker->CurrentValue)) . "") . "\">" . $body . ""; $links = ""; if ($GLOBALS["tassigment_grid"] && $GLOBALS["tassigment_grid"]->DetailView && $Security->CanView() && $Security->AllowView(CurrentProjectID() . 'tassigment')) { $links .= "

Phrase("MasterDetailViewLink")) . "\" href=\"" . ew_HtmlEncode($this->GetViewUrl(EW_TABLE_SHOW_DETAIL . "=tassigment")) . "\">" . ew_HtmlImageAndText($Language->Phrase("MasterDetailViewLink")) . "

"; if ($DetailViewTblVar <> "") $DetailViewTblVar .= ","; $DetailViewTblVar .= "tassigment"; } if ($GLOBALS["tassigment_grid"] && $GLOBALS["tassigment_grid"]->DetailEdit && $Security->CanEdit() && $Security->AllowEdit(CurrentProjectID() . 'tassigment')) { $links .= "

Phrase("MasterDetailEditLink")) . "\" href=\"" . ew_HtmlEncode($this->GetEditUrl(EW_TABLE_SHOW_DETAIL . "=tassigment")) . "\">" . ew_HtmlImageAndText($Language->Phrase("MasterDetailEditLink")) . "

"; if ($DetailEditTblVar <> "") $DetailEditTblVar .= ","; $DetailEditTblVar .= "tassigment"; } if ($links <> "") { $body .= ""; $body .= ""; } $body = "

" . $body . "

"; $item->Body = $body; $item->Visible = $Security->AllowList(CurrentProjectID() . 'tassigment'); if ($item->Visible) { if ($DetailTableLink <> "") $DetailTableLink .= ","; $DetailTableLink .= "tassigment"; } if ($this->ShowMultipleDetails) $item->Visible = FALSE; // Multiple details if ($this->ShowMultipleDetails) { $body = $Language->Phrase("MultipleMasterDetails"); $body = "

"; $links = ""; if ($DetailViewTblVar <> "") { $links .= "

Phrase("MasterDetailViewLink")) . "\" href=\"" . ew_HtmlEncode($this->GetViewUrl(EW_TABLE_SHOW_DETAIL . "=" . $DetailViewTblVar)) . "\">" . ew_HtmlImageAndText($Language->Phrase("MasterDetailViewLink")) . "

"; } if ($DetailEditTblVar <> "") { $links .= "

Phrase("MasterDetailEditLink")) . "\" href=\"" . ew_HtmlEncode($this->GetEditUrl(EW_TABLE_SHOW_DETAIL . "=" . $DetailEditTblVar)) . "\">" . ew_HtmlImageAndText($Language->Phrase("MasterDetailEditLink")) . "

"; } if ($DetailCopyTblVar <> "") { $links .= "

Phrase("MasterDetailCopyLink")) . "\" href=\"" . ew_HtmlEncode($this->GetCopyUrl(EW_TABLE_SHOW_DETAIL . "=" . $DetailCopyTblVar)) . "\">" . ew_HtmlImageAndText($Language->Phrase("MasterDetailCopyLink")) . "

"; } if ($links <> "") { $body .= ""; $body .= ""; } $body .= "

"; // Multiple details $oListOpt = &$option->Add("details"); $oListOpt->Body = $body; } // Set up detail default $option = &$options["detail"]; $options["detail"]->DropDownButtonPhrase = $Language->Phrase("ButtonDetails"); $option->UseImageAndText = TRUE; $ar = explode(",", $DetailTableLink); $cnt = count($ar); $option->UseDropDownButton = ($cnt > 1); $option->UseButtonGroup = TRUE; $item = &$option->Add($option->GroupOptionName); $item->Body = ""; $item->Visible = FALSE; // Set up action default $option = &$options["action"]; $option->DropDownButtonPhrase = $Language->Phrase("ButtonActions"); $option->UseImageAndText = TRUE; $option->UseDropDownButton = FALSE; $option->UseButtonGroup = TRUE; $item = &$option->Add($option->GroupOptionName); $item->Body = ""; $item->Visible = FALSE; } // Set up starting record parameters function SetUpStartRec() { if ($this->DisplayRecs == 0) return; if ($this->IsPageRequest()) { // Validate request if (@$_GET[EW_TABLE_START_REC] <> "") { // Check for "start" parameter $this->StartRec = $_GET[EW_TABLE_START_REC]; $this->setStartRecordNumber($this->StartRec); } elseif (@$_GET[EW_TABLE_PAGE_NO] <> "") { $PageNo = $_GET[EW_TABLE_PAGE_NO]; if (is_numeric($PageNo)) { $this->StartRec = ($PageNo-1)*$this->DisplayRecs+1; if ($this->StartRec <= 0) { $this->StartRec = 1; } elseif ($this->StartRec >= intval(($this->TotalRecs-1)/$this->DisplayRecs)*$this->DisplayRecs+1) { $this->StartRec = intval(($this->TotalRecs-1)/$this->DisplayRecs)*$this->DisplayRecs+1; } $this->setStartRecordNumber($this->StartRec); } } } $this->StartRec = $this->getStartRecordNumber(); // Check if correct start record counter if (!is_numeric($this->StartRec) || $this->StartRec == "") { // Avoid invalid start record counter $this->StartRec = 1; // Reset start record counter $this->setStartRecordNumber($this->StartRec); } elseif (intval($this->StartRec) > intval($this->TotalRecs)) { // Avoid starting record > total records $this->StartRec = intval(($this->TotalRecs-1)/$this->DisplayRecs)*$this->DisplayRecs+1; // Point to last page first record $this->setStartRecordNumber($this->StartRec); } elseif (($this->StartRec-1) % $this->DisplayRecs <> 0) { $this->StartRec = intval(($this->StartRec-1)/$this->DisplayRecs)*$this->DisplayRecs+1; // Point to page boundary $this->setStartRecordNumber($this->StartRec); } } // Load recordset function LoadRecordset($offset = -1, $rowcnt = -1) { // Load List page SQL $sSql = $this->SelectSQL(); $conn = &$this->Connection(); // Load recordset $dbtype = ew_GetConnectionType($this->DBID); if ($this->UseSelectLimit) { $conn->raiseErrorFn = $GLOBALS["EW_ERROR_FN"]; if ($dbtype == "MSSQL") { $rs = $conn->SelectLimit($sSql, $rowcnt, $offset, array("_hasOrderBy" => trim($this->getOrderBy()) || trim($this->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->idSeeker->setDbValue($rs->fields('idSeeker')); $this->Desk->setDbValue($rs->fields('Desk')); $this->UNHCR_code->setDbValue($rs->fields('UNHCR_code')); $this->Name->setDbValue($rs->fields('Name')); $this->Surname->setDbValue($rs->fields('Surname')); $this->BirthDate->setDbValue($rs->fields('BirthDate')); $this->BirthPlace->setDbValue($rs->fields('BirthPlace')); $this->Nationality->setDbValue($rs->fields('Nationality')); if (array_key_exists('EV__Nationality', $rs->fields)) { $this->Nationality->VirtualValue = $rs->fields('EV__Nationality'); // Set up virtual field value } else { $this->Nationality->VirtualValue = ""; // Clear value } $this->Citizenship->setDbValue($rs->fields('Citizenship')); if (array_key_exists('EV__Citizenship', $rs->fields)) { $this->Citizenship->VirtualValue = $rs->fields('EV__Citizenship'); // Set up virtual field value } else { $this->Citizenship->VirtualValue = ""; // Clear value } $this->Sex->setDbValue($rs->fields('Sex')); $this->Phone->setDbValue($rs->fields('Phone')); $this->_Email->setDbValue($rs->fields('Email')); $this->Religion->setDbValue($rs->fields('Religion')); $this->Place_of_Residence->setDbValue($rs->fields('Place_of_Residence')); if (array_key_exists('EV__Place_of_Residence', $rs->fields)) { $this->Place_of_Residence->VirtualValue = $rs->fields('EV__Place_of_Residence'); // Set up virtual field value } else { $this->Place_of_Residence->VirtualValue = ""; // Clear value } $this->Address_of_Residence->setDbValue($rs->fields('Address_of_Residence')); $this->Town_of_residence->setDbValue($rs->fields('Town_of_residence')); $this->Place_of_Transit->setDbValue($rs->fields('Place_of_Transit')); if (array_key_exists('EV__Place_of_Transit', $rs->fields)) { $this->Place_of_Transit->VirtualValue = $rs->fields('EV__Place_of_Transit'); // Set up virtual field value } else { $this->Place_of_Transit->VirtualValue = ""; // Clear value } $this->Address_of_Transit->setDbValue($rs->fields('Address_of_Transit')); $this->Town_of_transit->setDbValue($rs->fields('Town_of_transit')); $this->domicile_description->setDbValue($rs->fields('domicile_description')); $this->Disabled->setDbValue($rs->fields('Disabled')); $this->Sick->setDbValue($rs->fields('Sick')); $this->Alone->setDbValue($rs->fields('Alone')); $this->Elderly->setDbValue($rs->fields('Elderly')); $this->Family->setDbValue($rs->fields('Family')); $this->Householder->setDbValue($rs->fields('Householder')); $this->Householder_id->setDbValue($rs->fields('Householder_id')); if (array_key_exists('EV__Householder_id', $rs->fields)) { $this->Householder_id->VirtualValue = $rs->fields('EV__Householder_id'); // Set up virtual field value } else { $this->Householder_id->VirtualValue = ""; // Clear value } $this->Householder_reltype->setDbValue($rs->fields('Householder_reltype')); $this->Ethnic_group->setDbValue($rs->fields('Ethnic_group')); $this->Known_languages->setDbValue($rs->fields('Known_languages')); $this->Title_of_study->setDbValue($rs->fields('Title_of_study')); $this->Poss_destination_country->setDbValue($rs->fields('Poss_destination_country')); $this->Document_type->setDbValue($rs->fields('Document_type')); $this->Document_number->setDbValue($rs->fields('Document_number')); $this->Document_release->setDbValue($rs->fields('Document_release')); $this->Document_expiry->setDbValue($rs->fields('Document_expiry')); $this->Document_nationality->setDbValue($rs->fields('Document_nationality')); if (array_key_exists('EV__Document_nationality', $rs->fields)) { $this->Document_nationality->VirtualValue = $rs->fields('EV__Document_nationality'); // Set up virtual field value } else { $this->Document_nationality->VirtualValue = ""; // Clear value } $this->other_documents->setDbValue($rs->fields('other_documents')); $this->Final_evaluation->setDbValue($rs->fields('Final_evaluation')); $this->photo->Upload->DbValue = $rs->fields('photo'); $this->photo->CurrentValue = $this->photo->Upload->DbValue; $this->doc_image->Upload->DbValue = $rs->fields('doc_image'); $this->doc_image->CurrentValue = $this->doc_image->Upload->DbValue; $this->Notes->setDbValue($rs->fields('Notes')); $this->Interview_1->setDbValue($rs->fields('Interview_1')); $this->interview1_date->setDbValue($rs->fields('interview1_date')); $this->Interview_2->setDbValue($rs->fields('Interview_2')); $this->interview_2_date->setDbValue($rs->fields('interview_2_date')); $this->Interview_3->setDbValue($rs->fields('Interview_3')); $this->interview_3_date->setDbValue($rs->fields('interview_3_date')); $this->Zone_of_Transit->setDbValue($rs->fields('Zone_of_Transit')); $this->Travel_number->setDbValue($rs->fields('Travel_number')); $this->Travel_arrival_date->setDbValue($rs->fields('Travel_arrival_date')); $this->Travel_arrival_time->setDbValue($rs->fields('Travel_arrival_time')); $this->num_family->setDbValue($rs->fields('num_family')); $this->speak_ENG->setDbValue($rs->fields('speak_ENG')); $this->speak_FRA->setDbValue($rs->fields('speak_FRA')); $this->speak_ARA->setDbValue($rs->fields('speak_ARA')); $this->speak_ITA->setDbValue($rs->fields('speak_ITA')); $this->lives_with->setDbValue($rs->fields('lives_with')); $this->family_know->setDbValue($rs->fields('family_know')); $this->date_of_entry_transit->setDbValue($rs->fields('date_of_entry_transit')); $this->marital_status->setDbValue($rs->fields('marital_status')); $this->consort_id->setDbValue($rs->fields('consort_id')); $this->consort_info->setDbValue($rs->fields('consort_info')); $this->other_fam_in_italy->setDbValue($rs->fields('other_fam_in_italy')); $this->other_fam_in_europe->setDbValue($rs->fields('other_fam_in_europe')); $this->where_lived->setDbValue($rs->fields('where_lived')); $this->medical_situation->setDbValue($rs->fields('medical_situation')); $this->social_situation->setDbValue($rs->fields('social_situation')); $this->abuse_suffered->setDbValue($rs->fields('abuse_suffered')); $this->abuse_description->setDbValue($rs->fields('abuse_description')); $this->work_done->setDbValue($rs->fields('work_done')); $this->military_service->setDbValue($rs->fields('military_service')); $this->itinerary->setDbValue($rs->fields('itinerary')); $this->convictions->setDbValue($rs->fields('convictions')); $this->requested_asylum->setDbValue($rs->fields('requested_asylum')); $this->resettlement_application->setDbValue($rs->fields('resettlement_application')); $this->resettlement_country->setDbValue($rs->fields('resettlement_country')); $this->reunion_application->setDbValue($rs->fields('reunion_application')); $this->reunion_country->setDbValue($rs->fields('reunion_country')); $this->belongs_to_organization->setDbValue($rs->fields('belongs_to_organization')); $this->organizations->setDbValue($rs->fields('organizations')); $this->presentations->setDbValue($rs->fields('presentations')); $this->report->setDbValue($rs->fields('report')); if (!isset($GLOBALS["tassigment_grid"])) $GLOBALS["tassigment_grid"] = new ctassigment_grid; $sDetailFilter = $GLOBALS["tassigment"]->SqlDetailFilter_tospiti(); $sDetailFilter = str_replace("@idkSeeker@", ew_AdjustSql($this->idSeeker->DbValue, "DB"), $sDetailFilter); $GLOBALS["tassigment"]->setCurrentMasterTable("tospiti"); $sDetailFilter = $GLOBALS["tassigment"]->ApplyUserIDFilters($sDetailFilter); $this->tassigment_Count = $GLOBALS["tassigment"]->LoadRecordCount($sDetailFilter); } // Load DbValue from recordset function LoadDbValues(&$rs) { if (!$rs || !is_array($rs) && $rs->EOF) return; $row = is_array($rs) ? $rs : $rs->fields; $this->idSeeker->DbValue = $row['idSeeker']; $this->Desk->DbValue = $row['Desk']; $this->UNHCR_code->DbValue = $row['UNHCR_code']; $this->Name->DbValue = $row['Name']; $this->Surname->DbValue = $row['Surname']; $this->BirthDate->DbValue = $row['BirthDate']; $this->BirthPlace->DbValue = $row['BirthPlace']; $this->Nationality->DbValue = $row['Nationality']; $this->Citizenship->DbValue = $row['Citizenship']; $this->Sex->DbValue = $row['Sex']; $this->Phone->DbValue = $row['Phone']; $this->_Email->DbValue = $row['Email']; $this->Religion->DbValue = $row['Religion']; $this->Place_of_Residence->DbValue = $row['Place_of_Residence']; $this->Address_of_Residence->DbValue = $row['Address_of_Residence']; $this->Town_of_residence->DbValue = $row['Town_of_residence']; $this->Place_of_Transit->DbValue = $row['Place_of_Transit']; $this->Address_of_Transit->DbValue = $row['Address_of_Transit']; $this->Town_of_transit->DbValue = $row['Town_of_transit']; $this->domicile_description->DbValue = $row['domicile_description']; $this->Disabled->DbValue = $row['Disabled']; $this->Sick->DbValue = $row['Sick']; $this->Alone->DbValue = $row['Alone']; $this->Elderly->DbValue = $row['Elderly']; $this->Family->DbValue = $row['Family']; $this->Householder->DbValue = $row['Householder']; $this->Householder_id->DbValue = $row['Householder_id']; $this->Householder_reltype->DbValue = $row['Householder_reltype']; $this->Ethnic_group->DbValue = $row['Ethnic_group']; $this->Known_languages->DbValue = $row['Known_languages']; $this->Title_of_study->DbValue = $row['Title_of_study']; $this->Poss_destination_country->DbValue = $row['Poss_destination_country']; $this->Document_type->DbValue = $row['Document_type']; $this->Document_number->DbValue = $row['Document_number']; $this->Document_release->DbValue = $row['Document_release']; $this->Document_expiry->DbValue = $row['Document_expiry']; $this->Document_nationality->DbValue = $row['Document_nationality']; $this->other_documents->DbValue = $row['other_documents']; $this->Final_evaluation->DbValue = $row['Final_evaluation']; $this->photo->Upload->DbValue = $row['photo']; $this->doc_image->Upload->DbValue = $row['doc_image']; $this->Notes->DbValue = $row['Notes']; $this->Interview_1->DbValue = $row['Interview_1']; $this->interview1_date->DbValue = $row['interview1_date']; $this->Interview_2->DbValue = $row['Interview_2']; $this->interview_2_date->DbValue = $row['interview_2_date']; $this->Interview_3->DbValue = $row['Interview_3']; $this->interview_3_date->DbValue = $row['interview_3_date']; $this->Zone_of_Transit->DbValue = $row['Zone_of_Transit']; $this->Travel_number->DbValue = $row['Travel_number']; $this->Travel_arrival_date->DbValue = $row['Travel_arrival_date']; $this->Travel_arrival_time->DbValue = $row['Travel_arrival_time']; $this->num_family->DbValue = $row['num_family']; $this->speak_ENG->DbValue = $row['speak_ENG']; $this->speak_FRA->DbValue = $row['speak_FRA']; $this->speak_ARA->DbValue = $row['speak_ARA']; $this->speak_ITA->DbValue = $row['speak_ITA']; $this->lives_with->DbValue = $row['lives_with']; $this->family_know->DbValue = $row['family_know']; $this->date_of_entry_transit->DbValue = $row['date_of_entry_transit']; $this->marital_status->DbValue = $row['marital_status']; $this->consort_id->DbValue = $row['consort_id']; $this->consort_info->DbValue = $row['consort_info']; $this->other_fam_in_italy->DbValue = $row['other_fam_in_italy']; $this->other_fam_in_europe->DbValue = $row['other_fam_in_europe']; $this->where_lived->DbValue = $row['where_lived']; $this->medical_situation->DbValue = $row['medical_situation']; $this->social_situation->DbValue = $row['social_situation']; $this->abuse_suffered->DbValue = $row['abuse_suffered']; $this->abuse_description->DbValue = $row['abuse_description']; $this->work_done->DbValue = $row['work_done']; $this->military_service->DbValue = $row['military_service']; $this->itinerary->DbValue = $row['itinerary']; $this->convictions->DbValue = $row['convictions']; $this->requested_asylum->DbValue = $row['requested_asylum']; $this->resettlement_application->DbValue = $row['resettlement_application']; $this->resettlement_country->DbValue = $row['resettlement_country']; $this->reunion_application->DbValue = $row['reunion_application']; $this->reunion_country->DbValue = $row['reunion_country']; $this->belongs_to_organization->DbValue = $row['belongs_to_organization']; $this->organizations->DbValue = $row['organizations']; $this->presentations->DbValue = $row['presentations']; $this->report->DbValue = $row['report']; } // Render row values based on field settings function RenderRow() { global $Security, $Language, $gsLanguage; // Initialize URLs $this->AddUrl = $this->GetAddUrl(); $this->EditUrl = $this->GetEditUrl(); $this->CopyUrl = $this->GetCopyUrl(); $this->DeleteUrl = $this->GetDeleteUrl(); $this->ListUrl = $this->GetListUrl(); $this->SetupOtherOptions(); // Call Row_Rendering event $this->Row_Rendering(); // Common render codes for all row types // idSeeker // Desk // UNHCR_code // Name // Surname // BirthDate // BirthPlace // Nationality // Citizenship // Sex // Phone // Email // Religion // Place_of_Residence // Address_of_Residence // Town_of_residence // Place_of_Transit // Address_of_Transit // Town_of_transit // domicile_description // Disabled // Sick // Alone // Elderly // Family // Householder // Householder_id // Householder_reltype // Ethnic_group // Known_languages // Title_of_study // Poss_destination_country // Document_type // Document_number // Document_release // Document_expiry // Document_nationality // other_documents // Final_evaluation // photo // doc_image // Notes // Interview_1 // interview1_date // Interview_2 // interview_2_date // Interview_3 // interview_3_date // Zone_of_Transit // Travel_number // Travel_arrival_date // Travel_arrival_time // num_family // speak_ENG // speak_FRA // speak_ARA // speak_ITA // lives_with // family_know // date_of_entry_transit // marital_status // consort_id // consort_info // other_fam_in_italy // other_fam_in_europe // where_lived // medical_situation // social_situation // abuse_suffered // abuse_description // work_done // military_service // itinerary // convictions // requested_asylum // resettlement_application // resettlement_country // reunion_application // reunion_country // belongs_to_organization // organizations // presentations // report if ($this->RowType == EW_ROWTYPE_VIEW) { // View row // idSeeker $this->idSeeker->ViewValue = $this->idSeeker->CurrentValue; $this->idSeeker->ViewCustomAttributes = ""; // Desk $this->Desk->ViewValue = $this->Desk->CurrentValue; $this->Desk->ViewCustomAttributes = ""; // UNHCR_code $this->UNHCR_code->ViewValue = $this->UNHCR_code->CurrentValue; $this->UNHCR_code->ViewCustomAttributes = ""; // Name $this->Name->ViewValue = $this->Name->CurrentValue; $this->Name->ViewCustomAttributes = ""; // Surname $this->Surname->ViewValue = $this->Surname->CurrentValue; $this->Surname->ViewCustomAttributes = ""; // BirthDate $this->BirthDate->ViewValue = $this->BirthDate->CurrentValue; $this->BirthDate->ViewValue = ew_FormatDateTime($this->BirthDate->ViewValue, 7); $this->BirthDate->ViewCustomAttributes = ""; // BirthPlace $this->BirthPlace->ViewValue = $this->BirthPlace->CurrentValue; $this->BirthPlace->ViewCustomAttributes = ""; // Nationality if ($this->Nationality->VirtualValue <> "") { $this->Nationality->ViewValue = $this->Nationality->VirtualValue; } else { $this->Nationality->ViewValue = $this->Nationality->CurrentValue; if (strval($this->Nationality->CurrentValue) <> "") { $sFilterWrk = "`id_nation`" . ew_SearchString("=", $this->Nationality->CurrentValue, EW_DATATYPE_STRING, ""); switch (@$gsLanguage) { case "en": $sSqlWrk = "SELECT `id_nation`, `desc_en` AS `DispFld`, '' AS `Disp2Fld`, '' AS `Disp3Fld`, '' AS `Disp4Fld` FROM `tnations`"; $sWhereWrk = ""; $this->Nationality->LookupFilters = array(); break; case "it": $sSqlWrk = "SELECT `id_nation`, `desc_it` AS `DispFld`, '' AS `Disp2Fld`, '' AS `Disp3Fld`, '' AS `Disp4Fld` FROM `tnations`"; $sWhereWrk = ""; $this->Nationality->LookupFilters = array(); break; default: $sSqlWrk = "SELECT `id_nation`, `desc_en` AS `DispFld`, '' AS `Disp2Fld`, '' AS `Disp3Fld`, '' AS `Disp4Fld` FROM `tnations`"; $sWhereWrk = ""; $this->Nationality->LookupFilters = array(); break; } ew_AddFilter($sWhereWrk, $sFilterWrk); $this->Lookup_Selecting($this->Nationality, $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->Nationality->ViewValue = $this->Nationality->DisplayValue($arwrk); $rswrk->Close(); } else { $this->Nationality->ViewValue = $this->Nationality->CurrentValue; } } else { $this->Nationality->ViewValue = NULL; } } $this->Nationality->ViewCustomAttributes = ""; // Citizenship if ($this->Citizenship->VirtualValue <> "") { $this->Citizenship->ViewValue = $this->Citizenship->VirtualValue; } else { $this->Citizenship->ViewValue = $this->Citizenship->CurrentValue; if (strval($this->Citizenship->CurrentValue) <> "") { $sFilterWrk = "`id_nation`" . ew_SearchString("=", $this->Citizenship->CurrentValue, EW_DATATYPE_STRING, ""); switch (@$gsLanguage) { case "en": $sSqlWrk = "SELECT `id_nation`, `desc_en` AS `DispFld`, '' AS `Disp2Fld`, '' AS `Disp3Fld`, '' AS `Disp4Fld` FROM `tnations`"; $sWhereWrk = ""; $this->Citizenship->LookupFilters = array(); break; case "it": $sSqlWrk = "SELECT `id_nation`, `desc_it` AS `DispFld`, '' AS `Disp2Fld`, '' AS `Disp3Fld`, '' AS `Disp4Fld` FROM `tnations`"; $sWhereWrk = ""; $this->Citizenship->LookupFilters = array(); break; default: $sSqlWrk = "SELECT `id_nation`, `desc_en` AS `DispFld`, '' AS `Disp2Fld`, '' AS `Disp3Fld`, '' AS `Disp4Fld` FROM `tnations`"; $sWhereWrk = ""; $this->Citizenship->LookupFilters = array(); break; } ew_AddFilter($sWhereWrk, $sFilterWrk); $this->Lookup_Selecting($this->Citizenship, $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->Citizenship->ViewValue = $this->Citizenship->DisplayValue($arwrk); $rswrk->Close(); } else { $this->Citizenship->ViewValue = $this->Citizenship->CurrentValue; } } else { $this->Citizenship->ViewValue = NULL; } } $this->Citizenship->ViewCustomAttributes = ""; // Sex if (strval($this->Sex->CurrentValue) <> "") { $this->Sex->ViewValue = $this->Sex->OptionCaption($this->Sex->CurrentValue); } else { $this->Sex->ViewValue = NULL; } $this->Sex->ViewCustomAttributes = ""; // Phone $this->Phone->ViewValue = $this->Phone->CurrentValue; $this->Phone->ViewCustomAttributes = ""; // Email $this->_Email->ViewValue = $this->_Email->CurrentValue; $this->_Email->ViewCustomAttributes = ""; // Religion if (strval($this->Religion->CurrentValue) <> "") { $sFilterWrk = "`Religion`" . ew_SearchString("=", $this->Religion->CurrentValue, EW_DATATYPE_STRING, ""); switch (@$gsLanguage) { case "en": $sSqlWrk = "SELECT `Religion`, `Description` AS `DispFld`, '' AS `Disp2Fld`, '' AS `Disp3Fld`, '' AS `Disp4Fld` FROM `treligion`"; $sWhereWrk = ""; $this->Religion->LookupFilters = array(); break; case "it": $sSqlWrk = "SELECT `Religion`, `Description_it` AS `DispFld`, '' AS `Disp2Fld`, '' AS `Disp3Fld`, '' AS `Disp4Fld` FROM `treligion`"; $sWhereWrk = ""; $this->Religion->LookupFilters = array(); break; default: $sSqlWrk = "SELECT `Religion`, `Description` AS `DispFld`, '' AS `Disp2Fld`, '' AS `Disp3Fld`, '' AS `Disp4Fld` FROM `treligion`"; $sWhereWrk = ""; $this->Religion->LookupFilters = array(); break; } ew_AddFilter($sWhereWrk, $sFilterWrk); $this->Lookup_Selecting($this->Religion, $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->Religion->ViewValue = $this->Religion->DisplayValue($arwrk); $rswrk->Close(); } else { $this->Religion->ViewValue = $this->Religion->CurrentValue; } } else { $this->Religion->ViewValue = NULL; } $this->Religion->ViewCustomAttributes = ""; // Place_of_Residence if ($this->Place_of_Residence->VirtualValue <> "") { $this->Place_of_Residence->ViewValue = $this->Place_of_Residence->VirtualValue; } else { if (strval($this->Place_of_Residence->CurrentValue) <> "") { $sFilterWrk = "`id_nation`" . ew_SearchString("=", $this->Place_of_Residence->CurrentValue, EW_DATATYPE_STRING, ""); switch (@$gsLanguage) { case "en": $sSqlWrk = "SELECT `id_nation`, `desc_en` AS `DispFld`, '' AS `Disp2Fld`, '' AS `Disp3Fld`, '' AS `Disp4Fld` FROM `tnations`"; $sWhereWrk = ""; $this->Place_of_Residence->LookupFilters = array(); break; case "it": $sSqlWrk = "SELECT `id_nation`, `desc_it` AS `DispFld`, '' AS `Disp2Fld`, '' AS `Disp3Fld`, '' AS `Disp4Fld` FROM `tnations`"; $sWhereWrk = ""; $this->Place_of_Residence->LookupFilters = array(); break; default: $sSqlWrk = "SELECT `id_nation`, `desc_en` AS `DispFld`, '' AS `Disp2Fld`, '' AS `Disp3Fld`, '' AS `Disp4Fld` FROM `tnations`"; $sWhereWrk = ""; $this->Place_of_Residence->LookupFilters = array(); break; } ew_AddFilter($sWhereWrk, $sFilterWrk); $this->Lookup_Selecting($this->Place_of_Residence, $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->Place_of_Residence->ViewValue = $this->Place_of_Residence->DisplayValue($arwrk); $rswrk->Close(); } else { $this->Place_of_Residence->ViewValue = $this->Place_of_Residence->CurrentValue; } } else { $this->Place_of_Residence->ViewValue = NULL; } } $this->Place_of_Residence->ViewCustomAttributes = ""; // Address_of_Residence $this->Address_of_Residence->ViewValue = $this->Address_of_Residence->CurrentValue; $this->Address_of_Residence->ViewCustomAttributes = ""; // Town_of_residence $this->Town_of_residence->ViewValue = $this->Town_of_residence->CurrentValue; $this->Town_of_residence->ViewCustomAttributes = ""; // Place_of_Transit if ($this->Place_of_Transit->VirtualValue <> "") { $this->Place_of_Transit->ViewValue = $this->Place_of_Transit->VirtualValue; } else { if (strval($this->Place_of_Transit->CurrentValue) <> "") { $sFilterWrk = "`id_nation`" . ew_SearchString("=", $this->Place_of_Transit->CurrentValue, EW_DATATYPE_STRING, ""); switch (@$gsLanguage) { case "en": $sSqlWrk = "SELECT `id_nation`, `desc_en` AS `DispFld`, '' AS `Disp2Fld`, '' AS `Disp3Fld`, '' AS `Disp4Fld` FROM `tnations`"; $sWhereWrk = ""; $this->Place_of_Transit->LookupFilters = array(); break; case "it": $sSqlWrk = "SELECT `id_nation`, `desc_it` AS `DispFld`, '' AS `Disp2Fld`, '' AS `Disp3Fld`, '' AS `Disp4Fld` FROM `tnations`"; $sWhereWrk = ""; $this->Place_of_Transit->LookupFilters = array(); break; default: $sSqlWrk = "SELECT `id_nation`, `desc_en` AS `DispFld`, '' AS `Disp2Fld`, '' AS `Disp3Fld`, '' AS `Disp4Fld` FROM `tnations`"; $sWhereWrk = ""; $this->Place_of_Transit->LookupFilters = array(); break; } ew_AddFilter($sWhereWrk, $sFilterWrk); $this->Lookup_Selecting($this->Place_of_Transit, $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->Place_of_Transit->ViewValue = $this->Place_of_Transit->DisplayValue($arwrk); $rswrk->Close(); } else { $this->Place_of_Transit->ViewValue = $this->Place_of_Transit->CurrentValue; } } else { $this->Place_of_Transit->ViewValue = NULL; } } $this->Place_of_Transit->ViewCustomAttributes = ""; // Address_of_Transit $this->Address_of_Transit->ViewValue = $this->Address_of_Transit->CurrentValue; $this->Address_of_Transit->ViewCustomAttributes = ""; // Town_of_transit $this->Town_of_transit->ViewValue = $this->Town_of_transit->CurrentValue; $this->Town_of_transit->ViewCustomAttributes = ""; // domicile_description $this->domicile_description->ViewValue = $this->domicile_description->CurrentValue; $this->domicile_description->ViewCustomAttributes = ""; // Disabled if (ew_ConvertToBool($this->Disabled->CurrentValue)) { $this->Disabled->ViewValue = $this->Disabled->FldTagCaption(1) <> "" ? $this->Disabled->FldTagCaption(1) : "Y"; } else { $this->Disabled->ViewValue = $this->Disabled->FldTagCaption(2) <> "" ? $this->Disabled->FldTagCaption(2) : "N"; } $this->Disabled->ViewCustomAttributes = ""; // Sick if (ew_ConvertToBool($this->Sick->CurrentValue)) { $this->Sick->ViewValue = $this->Sick->FldTagCaption(1) <> "" ? $this->Sick->FldTagCaption(1) : "Y"; } else { $this->Sick->ViewValue = $this->Sick->FldTagCaption(2) <> "" ? $this->Sick->FldTagCaption(2) : "N"; } $this->Sick->ViewCustomAttributes = ""; // Alone if (ew_ConvertToBool($this->Alone->CurrentValue)) { $this->Alone->ViewValue = $this->Alone->FldTagCaption(1) <> "" ? $this->Alone->FldTagCaption(1) : "Y"; } else { $this->Alone->ViewValue = $this->Alone->FldTagCaption(2) <> "" ? $this->Alone->FldTagCaption(2) : "N"; } $this->Alone->ViewCustomAttributes = ""; // Elderly if (ew_ConvertToBool($this->Elderly->CurrentValue)) { $this->Elderly->ViewValue = $this->Elderly->FldTagCaption(1) <> "" ? $this->Elderly->FldTagCaption(1) : "Y"; } else { $this->Elderly->ViewValue = $this->Elderly->FldTagCaption(2) <> "" ? $this->Elderly->FldTagCaption(2) : "N"; } $this->Elderly->ViewCustomAttributes = ""; // Family if (ew_ConvertToBool($this->Family->CurrentValue)) { $this->Family->ViewValue = $this->Family->FldTagCaption(1) <> "" ? $this->Family->FldTagCaption(1) : "Y"; } else { $this->Family->ViewValue = $this->Family->FldTagCaption(2) <> "" ? $this->Family->FldTagCaption(2) : "N"; } $this->Family->ViewCustomAttributes = ""; // Householder if (ew_ConvertToBool($this->Householder->CurrentValue)) { $this->Householder->ViewValue = $this->Householder->FldTagCaption(1) <> "" ? $this->Householder->FldTagCaption(1) : "Y"; } else { $this->Householder->ViewValue = $this->Householder->FldTagCaption(2) <> "" ? $this->Householder->FldTagCaption(2) : "N"; } $this->Householder->ViewCustomAttributes = ""; // Householder_id if ($this->Householder_id->VirtualValue <> "") { $this->Householder_id->ViewValue = $this->Householder_id->VirtualValue; } else { $this->Householder_id->ViewValue = $this->Householder_id->CurrentValue; if (strval($this->Householder_id->CurrentValue) <> "") { $sFilterWrk = "`idSeeker`" . ew_SearchString("=", $this->Householder_id->CurrentValue, EW_DATATYPE_NUMBER, ""); switch (@$gsLanguage) { case "en": $sSqlWrk = "SELECT `idSeeker`, `Name` AS `DispFld`, `Surname` AS `Disp2Fld`, `BirthDate` AS `Disp3Fld`, `BirthPlace` AS `Disp4Fld` FROM `vhouseholders`"; $sWhereWrk = ""; $this->Householder_id->LookupFilters = array("dx1" => '`Name`', "dx2" => '`Surname`', "df3" => "0", "dx3" => ew_CastDateFieldForLike('`BirthDate`', 0, "DB"), "dx4" => '`BirthPlace`'); break; case "it": $sSqlWrk = "SELECT `idSeeker`, `Name` AS `DispFld`, `Surname` AS `Disp2Fld`, `BirthDate` AS `Disp3Fld`, `BirthPlace` AS `Disp4Fld` FROM `vhouseholders`"; $sWhereWrk = ""; $this->Householder_id->LookupFilters = array("dx1" => '`Name`', "dx2" => '`Surname`', "df3" => "0", "dx3" => ew_CastDateFieldForLike('`BirthDate`', 0, "DB"), "dx4" => '`BirthPlace`'); break; default: $sSqlWrk = "SELECT `idSeeker`, `Name` AS `DispFld`, `Surname` AS `Disp2Fld`, `BirthDate` AS `Disp3Fld`, `BirthPlace` AS `Disp4Fld` FROM `vhouseholders`"; $sWhereWrk = ""; $this->Householder_id->LookupFilters = array("dx1" => '`Name`', "dx2" => '`Surname`', "df3" => "0", "dx3" => ew_CastDateFieldForLike('`BirthDate`', 0, "DB"), "dx4" => '`BirthPlace`'); break; } ew_AddFilter($sWhereWrk, $sFilterWrk); $this->Lookup_Selecting($this->Householder_id, $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'), 0); $arwrk[4] = $rswrk->fields('Disp4Fld'); $this->Householder_id->ViewValue = $this->Householder_id->DisplayValue($arwrk); $rswrk->Close(); } else { $this->Householder_id->ViewValue = $this->Householder_id->CurrentValue; } } else { $this->Householder_id->ViewValue = NULL; } } $this->Householder_id->ViewCustomAttributes = ""; // Householder_reltype if (strval($this->Householder_reltype->CurrentValue) <> "") { $sFilterWrk = "`family_rel`" . ew_SearchString("=", $this->Householder_reltype->CurrentValue, EW_DATATYPE_STRING, ""); switch (@$gsLanguage) { case "en": $sSqlWrk = "SELECT `family_rel`, `desc_en` AS `DispFld`, '' AS `Disp2Fld`, '' AS `Disp3Fld`, '' AS `Disp4Fld` FROM `tfamily_rel`"; $sWhereWrk = ""; $this->Householder_reltype->LookupFilters = array(); break; case "it": $sSqlWrk = "SELECT `family_rel`, `desc_it` AS `DispFld`, '' AS `Disp2Fld`, '' AS `Disp3Fld`, '' AS `Disp4Fld` FROM `tfamily_rel`"; $sWhereWrk = ""; $this->Householder_reltype->LookupFilters = array(); break; default: $sSqlWrk = "SELECT `family_rel`, `desc_en` AS `DispFld`, '' AS `Disp2Fld`, '' AS `Disp3Fld`, '' AS `Disp4Fld` FROM `tfamily_rel`"; $sWhereWrk = ""; $this->Householder_reltype->LookupFilters = array(); break; } ew_AddFilter($sWhereWrk, $sFilterWrk); $this->Lookup_Selecting($this->Householder_reltype, $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->Householder_reltype->ViewValue = $this->Householder_reltype->DisplayValue($arwrk); $rswrk->Close(); } else { $this->Householder_reltype->ViewValue = $this->Householder_reltype->CurrentValue; } } else { $this->Householder_reltype->ViewValue = NULL; } $this->Householder_reltype->ViewCustomAttributes = ""; // Ethnic_group $this->Ethnic_group->ViewValue = $this->Ethnic_group->CurrentValue; $this->Ethnic_group->ViewCustomAttributes = ""; // Known_languages $this->Known_languages->ViewValue = $this->Known_languages->CurrentValue; $this->Known_languages->ViewCustomAttributes = ""; // Title_of_study $this->Title_of_study->ViewValue = $this->Title_of_study->CurrentValue; $this->Title_of_study->ViewCustomAttributes = ""; // Poss_destination_country $this->Poss_destination_country->ViewValue = $this->Poss_destination_country->CurrentValue; $this->Poss_destination_country->ViewCustomAttributes = ""; // Document_type if (strval($this->Document_type->CurrentValue) <> "") { $sFilterWrk = "`Doc_type`" . ew_SearchString("=", $this->Document_type->CurrentValue, EW_DATATYPE_STRING, ""); switch (@$gsLanguage) { case "en": $sSqlWrk = "SELECT `Doc_type`, `Description` AS `DispFld`, '' AS `Disp2Fld`, '' AS `Disp3Fld`, '' AS `Disp4Fld` FROM `tdoc_type`"; $sWhereWrk = ""; $this->Document_type->LookupFilters = array(); break; case "it": $sSqlWrk = "SELECT `Doc_type`, `Description_it` AS `DispFld`, '' AS `Disp2Fld`, '' AS `Disp3Fld`, '' AS `Disp4Fld` FROM `tdoc_type`"; $sWhereWrk = ""; $this->Document_type->LookupFilters = array(); break; default: $sSqlWrk = "SELECT `Doc_type`, `Description` AS `DispFld`, '' AS `Disp2Fld`, '' AS `Disp3Fld`, '' AS `Disp4Fld` FROM `tdoc_type`"; $sWhereWrk = ""; $this->Document_type->LookupFilters = array(); break; } ew_AddFilter($sWhereWrk, $sFilterWrk); $this->Lookup_Selecting($this->Document_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->Document_type->ViewValue = $this->Document_type->DisplayValue($arwrk); $rswrk->Close(); } else { $this->Document_type->ViewValue = $this->Document_type->CurrentValue; } } else { $this->Document_type->ViewValue = NULL; } $this->Document_type->ViewCustomAttributes = ""; // Document_number $this->Document_number->ViewValue = $this->Document_number->CurrentValue; $this->Document_number->ViewCustomAttributes = ""; // Document_release $this->Document_release->ViewValue = $this->Document_release->CurrentValue; $this->Document_release->ViewValue = ew_FormatDateTime($this->Document_release->ViewValue, 7); $this->Document_release->ViewCustomAttributes = ""; // Document_expiry $this->Document_expiry->ViewValue = $this->Document_expiry->CurrentValue; $this->Document_expiry->ViewValue = ew_FormatDateTime($this->Document_expiry->ViewValue, 7); $this->Document_expiry->ViewCustomAttributes = ""; // Document_nationality if ($this->Document_nationality->VirtualValue <> "") { $this->Document_nationality->ViewValue = $this->Document_nationality->VirtualValue; } else { if (strval($this->Document_nationality->CurrentValue) <> "") { $sFilterWrk = "`id_nation`" . ew_SearchString("=", $this->Document_nationality->CurrentValue, EW_DATATYPE_STRING, ""); switch (@$gsLanguage) { case "en": $sSqlWrk = "SELECT `id_nation`, `desc_en` AS `DispFld`, '' AS `Disp2Fld`, '' AS `Disp3Fld`, '' AS `Disp4Fld` FROM `tnations`"; $sWhereWrk = ""; $this->Document_nationality->LookupFilters = array(); break; case "it": $sSqlWrk = "SELECT `id_nation`, `desc_it` AS `DispFld`, '' AS `Disp2Fld`, '' AS `Disp3Fld`, '' AS `Disp4Fld` FROM `tnations`"; $sWhereWrk = ""; $this->Document_nationality->LookupFilters = array(); break; default: $sSqlWrk = "SELECT `id_nation`, `desc_en` AS `DispFld`, '' AS `Disp2Fld`, '' AS `Disp3Fld`, '' AS `Disp4Fld` FROM `tnations`"; $sWhereWrk = ""; $this->Document_nationality->LookupFilters = array(); break; } ew_AddFilter($sWhereWrk, $sFilterWrk); $this->Lookup_Selecting($this->Document_nationality, $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->Document_nationality->ViewValue = $this->Document_nationality->DisplayValue($arwrk); $rswrk->Close(); } else { $this->Document_nationality->ViewValue = $this->Document_nationality->CurrentValue; } } else { $this->Document_nationality->ViewValue = NULL; } } $this->Document_nationality->ViewCustomAttributes = ""; // other_documents $this->other_documents->ViewValue = $this->other_documents->CurrentValue; $this->other_documents->ViewCustomAttributes = ""; // Final_evaluation if (strval($this->Final_evaluation->CurrentValue) <> "") { $sFilterWrk = "`Eval_type`" . ew_SearchString("=", $this->Final_evaluation->CurrentValue, EW_DATATYPE_STRING, ""); switch (@$gsLanguage) { case "en": $sSqlWrk = "SELECT `Eval_type`, `Description` AS `DispFld`, '' AS `Disp2Fld`, '' AS `Disp3Fld`, '' AS `Disp4Fld` FROM `teval_type`"; $sWhereWrk = ""; $this->Final_evaluation->LookupFilters = array(); break; case "it": $sSqlWrk = "SELECT `Eval_type`, `Description_it` AS `DispFld`, '' AS `Disp2Fld`, '' AS `Disp3Fld`, '' AS `Disp4Fld` FROM `teval_type`"; $sWhereWrk = ""; $this->Final_evaluation->LookupFilters = array(); break; default: $sSqlWrk = "SELECT `Eval_type`, `Description` AS `DispFld`, '' AS `Disp2Fld`, '' AS `Disp3Fld`, '' AS `Disp4Fld` FROM `teval_type`"; $sWhereWrk = ""; $this->Final_evaluation->LookupFilters = array(); break; } ew_AddFilter($sWhereWrk, $sFilterWrk); $this->Lookup_Selecting($this->Final_evaluation, $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->Final_evaluation->ViewValue = $this->Final_evaluation->DisplayValue($arwrk); $rswrk->Close(); } else { $this->Final_evaluation->ViewValue = $this->Final_evaluation->CurrentValue; } } else { $this->Final_evaluation->ViewValue = NULL; } $this->Final_evaluation->ViewCustomAttributes = ""; // photo $this->photo->UploadPath = "uploads/ospiti/".$this->idSeeker->DbValue; if (!ew_Empty($this->photo->Upload->DbValue)) { $this->photo->ImageWidth = EW_THUMBNAIL_DEFAULT_WIDTH; $this->photo->ImageHeight = EW_THUMBNAIL_DEFAULT_HEIGHT; $this->photo->ImageAlt = $this->photo->FldAlt(); $this->photo->ViewValue = $this->photo->Upload->DbValue; } else { $this->photo->ViewValue = ""; } $this->photo->ViewCustomAttributes = ""; // doc_image $this->doc_image->UploadPath = "uploads/ospiti_doc/".$this->idSeeker->DbValue; if (!ew_Empty($this->doc_image->Upload->DbValue)) { $this->doc_image->ImageWidth = EW_THUMBNAIL_DEFAULT_WIDTH; $this->doc_image->ImageHeight = EW_THUMBNAIL_DEFAULT_HEIGHT; $this->doc_image->ImageAlt = $this->doc_image->FldAlt(); $this->doc_image->ViewValue = $this->doc_image->Upload->DbValue; } else { $this->doc_image->ViewValue = ""; } $this->doc_image->ViewCustomAttributes = ""; // Notes $this->Notes->ViewValue = $this->Notes->CurrentValue; $this->Notes->ViewCustomAttributes = ""; // Interview_1 if (ew_ConvertToBool($this->Interview_1->CurrentValue)) { $this->Interview_1->ViewValue = $this->Interview_1->FldTagCaption(1) <> "" ? $this->Interview_1->FldTagCaption(1) : "Y"; } else { $this->Interview_1->ViewValue = $this->Interview_1->FldTagCaption(2) <> "" ? $this->Interview_1->FldTagCaption(2) : "N"; } $this->Interview_1->ViewCustomAttributes = ""; // interview1_date $this->interview1_date->ViewValue = $this->interview1_date->CurrentValue; $this->interview1_date->ViewValue = ew_FormatDateTime($this->interview1_date->ViewValue, 0); $this->interview1_date->ViewCustomAttributes = ""; // Interview_2 if (ew_ConvertToBool($this->Interview_2->CurrentValue)) { $this->Interview_2->ViewValue = $this->Interview_2->FldTagCaption(1) <> "" ? $this->Interview_2->FldTagCaption(1) : "Y"; } else { $this->Interview_2->ViewValue = $this->Interview_2->FldTagCaption(2) <> "" ? $this->Interview_2->FldTagCaption(2) : "N"; } $this->Interview_2->ViewCustomAttributes = ""; // interview_2_date $this->interview_2_date->ViewValue = $this->interview_2_date->CurrentValue; $this->interview_2_date->ViewValue = ew_FormatDateTime($this->interview_2_date->ViewValue, 0); $this->interview_2_date->ViewCustomAttributes = ""; // Interview_3 if (ew_ConvertToBool($this->Interview_3->CurrentValue)) { $this->Interview_3->ViewValue = $this->Interview_3->FldTagCaption(1) <> "" ? $this->Interview_3->FldTagCaption(1) : "Y"; } else { $this->Interview_3->ViewValue = $this->Interview_3->FldTagCaption(2) <> "" ? $this->Interview_3->FldTagCaption(2) : "N"; } $this->Interview_3->ViewCustomAttributes = ""; // interview_3_date $this->interview_3_date->ViewValue = $this->interview_3_date->CurrentValue; $this->interview_3_date->ViewValue = ew_FormatDateTime($this->interview_3_date->ViewValue, 0); $this->interview_3_date->ViewCustomAttributes = ""; // Zone_of_Transit $this->Zone_of_Transit->ViewValue = $this->Zone_of_Transit->CurrentValue; $this->Zone_of_Transit->ViewCustomAttributes = ""; // Travel_number $this->Travel_number->ViewValue = $this->Travel_number->CurrentValue; $this->Travel_number->ViewCustomAttributes = ""; // Travel_arrival_date $this->Travel_arrival_date->ViewValue = $this->Travel_arrival_date->CurrentValue; $this->Travel_arrival_date->ViewValue = ew_FormatDateTime($this->Travel_arrival_date->ViewValue, 0); $this->Travel_arrival_date->ViewCustomAttributes = ""; // Travel_arrival_time $this->Travel_arrival_time->ViewValue = $this->Travel_arrival_time->CurrentValue; $this->Travel_arrival_time->ViewValue = ew_FormatDateTime($this->Travel_arrival_time->ViewValue, 4); $this->Travel_arrival_time->ViewCustomAttributes = ""; // num_family $this->num_family->ViewValue = $this->num_family->CurrentValue; $this->num_family->ViewCustomAttributes = ""; // speak_ENG if (ew_ConvertToBool($this->speak_ENG->CurrentValue)) { $this->speak_ENG->ViewValue = $this->speak_ENG->FldTagCaption(1) <> "" ? $this->speak_ENG->FldTagCaption(1) : "Y"; } else { $this->speak_ENG->ViewValue = $this->speak_ENG->FldTagCaption(2) <> "" ? $this->speak_ENG->FldTagCaption(2) : "N"; } $this->speak_ENG->ViewCustomAttributes = ""; // speak_FRA if (ew_ConvertToBool($this->speak_FRA->CurrentValue)) { $this->speak_FRA->ViewValue = $this->speak_FRA->FldTagCaption(1) <> "" ? $this->speak_FRA->FldTagCaption(1) : "Y"; } else { $this->speak_FRA->ViewValue = $this->speak_FRA->FldTagCaption(2) <> "" ? $this->speak_FRA->FldTagCaption(2) : "N"; } $this->speak_FRA->ViewCustomAttributes = ""; // speak_ARA if (ew_ConvertToBool($this->speak_ARA->CurrentValue)) { $this->speak_ARA->ViewValue = $this->speak_ARA->FldTagCaption(1) <> "" ? $this->speak_ARA->FldTagCaption(1) : "Y"; } else { $this->speak_ARA->ViewValue = $this->speak_ARA->FldTagCaption(2) <> "" ? $this->speak_ARA->FldTagCaption(2) : "N"; } $this->speak_ARA->ViewCustomAttributes = ""; // speak_ITA if (ew_ConvertToBool($this->speak_ITA->CurrentValue)) { $this->speak_ITA->ViewValue = $this->speak_ITA->FldTagCaption(1) <> "" ? $this->speak_ITA->FldTagCaption(1) : "Y"; } else { $this->speak_ITA->ViewValue = $this->speak_ITA->FldTagCaption(2) <> "" ? $this->speak_ITA->FldTagCaption(2) : "N"; } $this->speak_ITA->ViewCustomAttributes = ""; // lives_with $this->lives_with->ViewValue = $this->lives_with->CurrentValue; $this->lives_with->ViewCustomAttributes = ""; // family_know if (ew_ConvertToBool($this->family_know->CurrentValue)) { $this->family_know->ViewValue = $this->family_know->FldTagCaption(1) <> "" ? $this->family_know->FldTagCaption(1) : "Y"; } else { $this->family_know->ViewValue = $this->family_know->FldTagCaption(2) <> "" ? $this->family_know->FldTagCaption(2) : "N"; } $this->family_know->ViewCustomAttributes = ""; // date_of_entry_transit $this->date_of_entry_transit->ViewValue = $this->date_of_entry_transit->CurrentValue; $this->date_of_entry_transit->ViewValue = ew_FormatDateTime($this->date_of_entry_transit->ViewValue, 0); $this->date_of_entry_transit->ViewCustomAttributes = ""; // marital_status $this->marital_status->ViewValue = $this->marital_status->CurrentValue; $this->marital_status->ViewCustomAttributes = ""; // consort_id $this->consort_id->ViewValue = $this->consort_id->CurrentValue; $this->consort_id->ViewCustomAttributes = ""; // consort_info $this->consort_info->ViewValue = $this->consort_info->CurrentValue; $this->consort_info->ViewCustomAttributes = ""; // other_fam_in_italy $this->other_fam_in_italy->ViewValue = $this->other_fam_in_italy->CurrentValue; $this->other_fam_in_italy->ViewCustomAttributes = ""; // other_fam_in_europe $this->other_fam_in_europe->ViewValue = $this->other_fam_in_europe->CurrentValue; $this->other_fam_in_europe->ViewCustomAttributes = ""; // where_lived $this->where_lived->ViewValue = $this->where_lived->CurrentValue; $this->where_lived->ViewCustomAttributes = ""; // medical_situation $this->medical_situation->ViewValue = $this->medical_situation->CurrentValue; $this->medical_situation->ViewCustomAttributes = ""; // social_situation $this->social_situation->ViewValue = $this->social_situation->CurrentValue; $this->social_situation->ViewCustomAttributes = ""; // abuse_suffered if (ew_ConvertToBool($this->abuse_suffered->CurrentValue)) { $this->abuse_suffered->ViewValue = $this->abuse_suffered->FldTagCaption(1) <> "" ? $this->abuse_suffered->FldTagCaption(1) : "Y"; } else { $this->abuse_suffered->ViewValue = $this->abuse_suffered->FldTagCaption(2) <> "" ? $this->abuse_suffered->FldTagCaption(2) : "N"; } $this->abuse_suffered->ViewCustomAttributes = ""; // abuse_description $this->abuse_description->ViewValue = $this->abuse_description->CurrentValue; $this->abuse_description->ViewCustomAttributes = ""; // work_done $this->work_done->ViewValue = $this->work_done->CurrentValue; $this->work_done->ViewCustomAttributes = ""; // military_service $this->military_service->ViewValue = $this->military_service->CurrentValue; $this->military_service->ViewCustomAttributes = ""; // itinerary $this->itinerary->ViewValue = $this->itinerary->CurrentValue; $this->itinerary->ViewCustomAttributes = ""; // convictions if (ew_ConvertToBool($this->convictions->CurrentValue)) { $this->convictions->ViewValue = $this->convictions->FldTagCaption(1) <> "" ? $this->convictions->FldTagCaption(1) : "Y"; } else { $this->convictions->ViewValue = $this->convictions->FldTagCaption(2) <> "" ? $this->convictions->FldTagCaption(2) : "N"; } $this->convictions->ViewCustomAttributes = ""; // requested_asylum $this->requested_asylum->ViewValue = $this->requested_asylum->CurrentValue; $this->requested_asylum->ViewCustomAttributes = ""; // resettlement_application if (ew_ConvertToBool($this->resettlement_application->CurrentValue)) { $this->resettlement_application->ViewValue = $this->resettlement_application->FldTagCaption(1) <> "" ? $this->resettlement_application->FldTagCaption(1) : "Y"; } else { $this->resettlement_application->ViewValue = $this->resettlement_application->FldTagCaption(2) <> "" ? $this->resettlement_application->FldTagCaption(2) : "N"; } $this->resettlement_application->ViewCustomAttributes = ""; // resettlement_country $this->resettlement_country->ViewValue = $this->resettlement_country->CurrentValue; $this->resettlement_country->ViewCustomAttributes = ""; // reunion_application if (ew_ConvertToBool($this->reunion_application->CurrentValue)) { $this->reunion_application->ViewValue = $this->reunion_application->FldTagCaption(1) <> "" ? $this->reunion_application->FldTagCaption(1) : "Y"; } else { $this->reunion_application->ViewValue = $this->reunion_application->FldTagCaption(2) <> "" ? $this->reunion_application->FldTagCaption(2) : "N"; } $this->reunion_application->ViewCustomAttributes = ""; // reunion_country $this->reunion_country->ViewValue = $this->reunion_country->CurrentValue; $this->reunion_country->ViewCustomAttributes = ""; // belongs_to_organization if (ew_ConvertToBool($this->belongs_to_organization->CurrentValue)) { $this->belongs_to_organization->ViewValue = $this->belongs_to_organization->FldTagCaption(1) <> "" ? $this->belongs_to_organization->FldTagCaption(1) : "Y"; } else { $this->belongs_to_organization->ViewValue = $this->belongs_to_organization->FldTagCaption(2) <> "" ? $this->belongs_to_organization->FldTagCaption(2) : "N"; } $this->belongs_to_organization->ViewCustomAttributes = ""; // organizations $this->organizations->ViewValue = $this->organizations->CurrentValue; $this->organizations->ViewCustomAttributes = ""; // presentations $this->presentations->ViewValue = $this->presentations->CurrentValue; $this->presentations->ViewCustomAttributes = ""; // report $this->report->ViewValue = $this->report->CurrentValue; $this->report->ViewCustomAttributes = ""; // Desk $this->Desk->LinkCustomAttributes = ""; $this->Desk->HrefValue = ""; $this->Desk->TooltipValue = ""; // UNHCR_code $this->UNHCR_code->LinkCustomAttributes = ""; $this->UNHCR_code->HrefValue = ""; $this->UNHCR_code->TooltipValue = ""; // Name $this->Name->LinkCustomAttributes = ""; $this->Name->HrefValue = ""; $this->Name->TooltipValue = ""; // Surname $this->Surname->LinkCustomAttributes = ""; $this->Surname->HrefValue = ""; $this->Surname->TooltipValue = ""; // BirthDate $this->BirthDate->LinkCustomAttributes = ""; $this->BirthDate->HrefValue = ""; $this->BirthDate->TooltipValue = ""; // BirthPlace $this->BirthPlace->LinkCustomAttributes = ""; $this->BirthPlace->HrefValue = ""; $this->BirthPlace->TooltipValue = ""; // Nationality $this->Nationality->LinkCustomAttributes = ""; $this->Nationality->HrefValue = ""; $this->Nationality->TooltipValue = ""; // Citizenship $this->Citizenship->LinkCustomAttributes = ""; $this->Citizenship->HrefValue = ""; $this->Citizenship->TooltipValue = ""; // Sex $this->Sex->LinkCustomAttributes = ""; $this->Sex->HrefValue = ""; $this->Sex->TooltipValue = ""; // Phone $this->Phone->LinkCustomAttributes = ""; $this->Phone->HrefValue = ""; $this->Phone->TooltipValue = ""; // Email $this->_Email->LinkCustomAttributes = ""; $this->_Email->HrefValue = ""; $this->_Email->TooltipValue = ""; // Religion $this->Religion->LinkCustomAttributes = ""; $this->Religion->HrefValue = ""; $this->Religion->TooltipValue = ""; // Place_of_Residence $this->Place_of_Residence->LinkCustomAttributes = ""; $this->Place_of_Residence->HrefValue = ""; $this->Place_of_Residence->TooltipValue = ""; // Address_of_Residence $this->Address_of_Residence->LinkCustomAttributes = ""; $this->Address_of_Residence->HrefValue = ""; $this->Address_of_Residence->TooltipValue = ""; // Town_of_residence $this->Town_of_residence->LinkCustomAttributes = ""; $this->Town_of_residence->HrefValue = ""; $this->Town_of_residence->TooltipValue = ""; // Place_of_Transit $this->Place_of_Transit->LinkCustomAttributes = ""; $this->Place_of_Transit->HrefValue = ""; $this->Place_of_Transit->TooltipValue = ""; // Address_of_Transit $this->Address_of_Transit->LinkCustomAttributes = ""; $this->Address_of_Transit->HrefValue = ""; $this->Address_of_Transit->TooltipValue = ""; // Town_of_transit $this->Town_of_transit->LinkCustomAttributes = ""; $this->Town_of_transit->HrefValue = ""; $this->Town_of_transit->TooltipValue = ""; // domicile_description $this->domicile_description->LinkCustomAttributes = ""; $this->domicile_description->HrefValue = ""; $this->domicile_description->TooltipValue = ""; // Disabled $this->Disabled->LinkCustomAttributes = ""; $this->Disabled->HrefValue = ""; $this->Disabled->TooltipValue = ""; // Sick $this->Sick->LinkCustomAttributes = ""; $this->Sick->HrefValue = ""; $this->Sick->TooltipValue = ""; // Alone $this->Alone->LinkCustomAttributes = ""; $this->Alone->HrefValue = ""; $this->Alone->TooltipValue = ""; // Elderly $this->Elderly->LinkCustomAttributes = ""; $this->Elderly->HrefValue = ""; $this->Elderly->TooltipValue = ""; // Family $this->Family->LinkCustomAttributes = ""; $this->Family->HrefValue = ""; $this->Family->TooltipValue = ""; // Householder $this->Householder->LinkCustomAttributes = ""; $this->Householder->HrefValue = ""; $this->Householder->TooltipValue = ""; // Householder_id $this->Householder_id->LinkCustomAttributes = ""; $this->Householder_id->HrefValue = ""; $this->Householder_id->TooltipValue = ""; // Householder_reltype $this->Householder_reltype->LinkCustomAttributes = ""; $this->Householder_reltype->HrefValue = ""; $this->Householder_reltype->TooltipValue = ""; // Ethnic_group $this->Ethnic_group->LinkCustomAttributes = ""; $this->Ethnic_group->HrefValue = ""; $this->Ethnic_group->TooltipValue = ""; // Known_languages $this->Known_languages->LinkCustomAttributes = ""; $this->Known_languages->HrefValue = ""; $this->Known_languages->TooltipValue = ""; // Title_of_study $this->Title_of_study->LinkCustomAttributes = ""; $this->Title_of_study->HrefValue = ""; $this->Title_of_study->TooltipValue = ""; // Poss_destination_country $this->Poss_destination_country->LinkCustomAttributes = ""; $this->Poss_destination_country->HrefValue = ""; $this->Poss_destination_country->TooltipValue = ""; // Document_type $this->Document_type->LinkCustomAttributes = ""; $this->Document_type->HrefValue = ""; $this->Document_type->TooltipValue = ""; // Document_number $this->Document_number->LinkCustomAttributes = ""; $this->Document_number->HrefValue = ""; $this->Document_number->TooltipValue = ""; // Document_release $this->Document_release->LinkCustomAttributes = ""; $this->Document_release->HrefValue = ""; $this->Document_release->TooltipValue = ""; // Document_expiry $this->Document_expiry->LinkCustomAttributes = ""; $this->Document_expiry->HrefValue = ""; $this->Document_expiry->TooltipValue = ""; // Document_nationality $this->Document_nationality->LinkCustomAttributes = ""; $this->Document_nationality->HrefValue = ""; $this->Document_nationality->TooltipValue = ""; // other_documents $this->other_documents->LinkCustomAttributes = ""; $this->other_documents->HrefValue = ""; $this->other_documents->TooltipValue = ""; // Final_evaluation $this->Final_evaluation->LinkCustomAttributes = ""; $this->Final_evaluation->HrefValue = ""; $this->Final_evaluation->TooltipValue = ""; // photo $this->photo->LinkCustomAttributes = ""; $this->photo->UploadPath = "uploads/ospiti/".$this->idSeeker->DbValue; if (!ew_Empty($this->photo->Upload->DbValue)) { $this->photo->HrefValue = ew_GetFileUploadUrl($this->photo, $this->photo->Upload->DbValue); // Add prefix/suffix $this->photo->LinkAttrs["target"] = ""; // Add target if ($this->Export <> "") $this->photo->HrefValue = ew_ConvertFullUrl($this->photo->HrefValue); } else { $this->photo->HrefValue = ""; } $this->photo->HrefValue2 = $this->photo->UploadPath . $this->photo->Upload->DbValue; $this->photo->TooltipValue = ""; if ($this->photo->UseColorbox) { if (ew_Empty($this->photo->TooltipValue)) $this->photo->LinkAttrs["title"] = $Language->Phrase("ViewImageGallery"); $this->photo->LinkAttrs["data-rel"] = "tospiti_x_photo"; ew_AppendClass($this->photo->LinkAttrs["class"], "ewLightbox"); } // doc_image $this->doc_image->LinkCustomAttributes = ""; $this->doc_image->UploadPath = "uploads/ospiti_doc/".$this->idSeeker->DbValue; if (!ew_Empty($this->doc_image->Upload->DbValue)) { $this->doc_image->HrefValue = ew_GetFileUploadUrl($this->doc_image, $this->doc_image->Upload->DbValue); // Add prefix/suffix $this->doc_image->LinkAttrs["target"] = ""; // Add target if ($this->Export <> "") $this->doc_image->HrefValue = ew_ConvertFullUrl($this->doc_image->HrefValue); } else { $this->doc_image->HrefValue = ""; } $this->doc_image->HrefValue2 = $this->doc_image->UploadPath . $this->doc_image->Upload->DbValue; $this->doc_image->TooltipValue = ""; if ($this->doc_image->UseColorbox) { if (ew_Empty($this->doc_image->TooltipValue)) $this->doc_image->LinkAttrs["title"] = $Language->Phrase("ViewImageGallery"); $this->doc_image->LinkAttrs["data-rel"] = "tospiti_x_doc_image"; ew_AppendClass($this->doc_image->LinkAttrs["class"], "ewLightbox"); } // Notes $this->Notes->LinkCustomAttributes = ""; $this->Notes->HrefValue = ""; $this->Notes->TooltipValue = ""; // Interview_1 $this->Interview_1->LinkCustomAttributes = ""; $this->Interview_1->HrefValue = ""; $this->Interview_1->TooltipValue = ""; // interview1_date $this->interview1_date->LinkCustomAttributes = ""; $this->interview1_date->HrefValue = ""; $this->interview1_date->TooltipValue = ""; // Interview_2 $this->Interview_2->LinkCustomAttributes = ""; $this->Interview_2->HrefValue = ""; $this->Interview_2->TooltipValue = ""; // interview_2_date $this->interview_2_date->LinkCustomAttributes = ""; $this->interview_2_date->HrefValue = ""; $this->interview_2_date->TooltipValue = ""; // Interview_3 $this->Interview_3->LinkCustomAttributes = ""; $this->Interview_3->HrefValue = ""; $this->Interview_3->TooltipValue = ""; // interview_3_date $this->interview_3_date->LinkCustomAttributes = ""; $this->interview_3_date->HrefValue = ""; $this->interview_3_date->TooltipValue = ""; // Zone_of_Transit $this->Zone_of_Transit->LinkCustomAttributes = ""; $this->Zone_of_Transit->HrefValue = ""; $this->Zone_of_Transit->TooltipValue = ""; // Travel_number $this->Travel_number->LinkCustomAttributes = ""; $this->Travel_number->HrefValue = ""; $this->Travel_number->TooltipValue = ""; // Travel_arrival_date $this->Travel_arrival_date->LinkCustomAttributes = ""; $this->Travel_arrival_date->HrefValue = ""; $this->Travel_arrival_date->TooltipValue = ""; // Travel_arrival_time $this->Travel_arrival_time->LinkCustomAttributes = ""; $this->Travel_arrival_time->HrefValue = ""; $this->Travel_arrival_time->TooltipValue = ""; // num_family $this->num_family->LinkCustomAttributes = ""; $this->num_family->HrefValue = ""; $this->num_family->TooltipValue = ""; // speak_ENG $this->speak_ENG->LinkCustomAttributes = ""; $this->speak_ENG->HrefValue = ""; $this->speak_ENG->TooltipValue = ""; // speak_FRA $this->speak_FRA->LinkCustomAttributes = ""; $this->speak_FRA->HrefValue = ""; $this->speak_FRA->TooltipValue = ""; // speak_ARA $this->speak_ARA->LinkCustomAttributes = ""; $this->speak_ARA->HrefValue = ""; $this->speak_ARA->TooltipValue = ""; // speak_ITA $this->speak_ITA->LinkCustomAttributes = ""; $this->speak_ITA->HrefValue = ""; $this->speak_ITA->TooltipValue = ""; // lives_with $this->lives_with->LinkCustomAttributes = ""; $this->lives_with->HrefValue = ""; $this->lives_with->TooltipValue = ""; // family_know $this->family_know->LinkCustomAttributes = ""; $this->family_know->HrefValue = ""; $this->family_know->TooltipValue = ""; // date_of_entry_transit $this->date_of_entry_transit->LinkCustomAttributes = ""; $this->date_of_entry_transit->HrefValue = ""; $this->date_of_entry_transit->TooltipValue = ""; // marital_status $this->marital_status->LinkCustomAttributes = ""; $this->marital_status->HrefValue = ""; $this->marital_status->TooltipValue = ""; // consort_id $this->consort_id->LinkCustomAttributes = ""; $this->consort_id->HrefValue = ""; $this->consort_id->TooltipValue = ""; // consort_info $this->consort_info->LinkCustomAttributes = ""; $this->consort_info->HrefValue = ""; $this->consort_info->TooltipValue = ""; // other_fam_in_italy $this->other_fam_in_italy->LinkCustomAttributes = ""; $this->other_fam_in_italy->HrefValue = ""; $this->other_fam_in_italy->TooltipValue = ""; // other_fam_in_europe $this->other_fam_in_europe->LinkCustomAttributes = ""; $this->other_fam_in_europe->HrefValue = ""; $this->other_fam_in_europe->TooltipValue = ""; // where_lived $this->where_lived->LinkCustomAttributes = ""; $this->where_lived->HrefValue = ""; $this->where_lived->TooltipValue = ""; // medical_situation $this->medical_situation->LinkCustomAttributes = ""; $this->medical_situation->HrefValue = ""; $this->medical_situation->TooltipValue = ""; // social_situation $this->social_situation->LinkCustomAttributes = ""; $this->social_situation->HrefValue = ""; $this->social_situation->TooltipValue = ""; // abuse_suffered $this->abuse_suffered->LinkCustomAttributes = ""; $this->abuse_suffered->HrefValue = ""; $this->abuse_suffered->TooltipValue = ""; // abuse_description $this->abuse_description->LinkCustomAttributes = ""; $this->abuse_description->HrefValue = ""; $this->abuse_description->TooltipValue = ""; // work_done $this->work_done->LinkCustomAttributes = ""; $this->work_done->HrefValue = ""; $this->work_done->TooltipValue = ""; // military_service $this->military_service->LinkCustomAttributes = ""; $this->military_service->HrefValue = ""; $this->military_service->TooltipValue = ""; // itinerary $this->itinerary->LinkCustomAttributes = ""; $this->itinerary->HrefValue = ""; $this->itinerary->TooltipValue = ""; // convictions $this->convictions->LinkCustomAttributes = ""; $this->convictions->HrefValue = ""; $this->convictions->TooltipValue = ""; // requested_asylum $this->requested_asylum->LinkCustomAttributes = ""; $this->requested_asylum->HrefValue = ""; $this->requested_asylum->TooltipValue = ""; // resettlement_application $this->resettlement_application->LinkCustomAttributes = ""; $this->resettlement_application->HrefValue = ""; $this->resettlement_application->TooltipValue = ""; // resettlement_country $this->resettlement_country->LinkCustomAttributes = ""; $this->resettlement_country->HrefValue = ""; $this->resettlement_country->TooltipValue = ""; // reunion_application $this->reunion_application->LinkCustomAttributes = ""; $this->reunion_application->HrefValue = ""; $this->reunion_application->TooltipValue = ""; // reunion_country $this->reunion_country->LinkCustomAttributes = ""; $this->reunion_country->HrefValue = ""; $this->reunion_country->TooltipValue = ""; // belongs_to_organization $this->belongs_to_organization->LinkCustomAttributes = ""; $this->belongs_to_organization->HrefValue = ""; $this->belongs_to_organization->TooltipValue = ""; // organizations $this->organizations->LinkCustomAttributes = ""; $this->organizations->HrefValue = ""; $this->organizations->TooltipValue = ""; // presentations $this->presentations->LinkCustomAttributes = ""; $this->presentations->HrefValue = ""; $this->presentations->TooltipValue = ""; // report $this->report->LinkCustomAttributes = ""; $this->report->HrefValue = ""; $this->report->TooltipValue = ""; } // Call Row Rendered event if ($this->RowType <> EW_ROWTYPE_AGGREGATEINIT) $this->Row_Rendered(); } // Set up export options function SetupExportOptions() { global $Language; // Printer friendly $item = &$this->ExportOptions->Add("print"); $item->Body = "ExportPrintUrl . "\" class=\"ewExportLink ewPrint\" title=\"" . ew_HtmlEncode($Language->Phrase("PrinterFriendlyText")) . "\" data-caption=\"" . ew_HtmlEncode($Language->Phrase("PrinterFriendlyText")) . "\">" . $Language->Phrase("PrinterFriendly") . ""; $item->Visible = TRUE; // Export to Excel $item = &$this->ExportOptions->Add("excel"); $item->Body = "ExportExcelUrl . "\" class=\"ewExportLink ewExcel\" title=\"" . ew_HtmlEncode($Language->Phrase("ExportToExcelText")) . "\" data-caption=\"" . ew_HtmlEncode($Language->Phrase("ExportToExcelText")) . "\">" . $Language->Phrase("ExportToExcel") . ""; $item->Visible = TRUE; // Export to Word $item = &$this->ExportOptions->Add("word"); $item->Body = "ExportWordUrl . "\" class=\"ewExportLink ewWord\" title=\"" . ew_HtmlEncode($Language->Phrase("ExportToWordText")) . "\" data-caption=\"" . ew_HtmlEncode($Language->Phrase("ExportToWordText")) . "\">" . $Language->Phrase("ExportToWord") . ""; $item->Visible = TRUE; // Export to Html $item = &$this->ExportOptions->Add("html"); $item->Body = "ExportHtmlUrl . "\" class=\"ewExportLink ewHtml\" title=\"" . ew_HtmlEncode($Language->Phrase("ExportToHtmlText")) . "\" data-caption=\"" . ew_HtmlEncode($Language->Phrase("ExportToHtmlText")) . "\">" . $Language->Phrase("ExportToHtml") . ""; $item->Visible = TRUE; // Export to Xml $item = &$this->ExportOptions->Add("xml"); $item->Body = "ExportXmlUrl . "\" class=\"ewExportLink ewXml\" title=\"" . ew_HtmlEncode($Language->Phrase("ExportToXmlText")) . "\" data-caption=\"" . ew_HtmlEncode($Language->Phrase("ExportToXmlText")) . "\">" . $Language->Phrase("ExportToXml") . ""; $item->Visible = FALSE; // Export to Csv $item = &$this->ExportOptions->Add("csv"); $item->Body = "ExportCsvUrl . "\" class=\"ewExportLink ewCsv\" title=\"" . ew_HtmlEncode($Language->Phrase("ExportToCsvText")) . "\" data-caption=\"" . ew_HtmlEncode($Language->Phrase("ExportToCsvText")) . "\">" . $Language->Phrase("ExportToCsv") . ""; $item->Visible = TRUE; // Export to Pdf $item = &$this->ExportOptions->Add("pdf"); $item->Body = "ExportPdfUrl . "\" class=\"ewExportLink ewPdf\" title=\"" . ew_HtmlEncode($Language->Phrase("ExportToPDFText")) . "\" data-caption=\"" . ew_HtmlEncode($Language->Phrase("ExportToPDFText")) . "\">" . $Language->Phrase("ExportToPDF") . ""; $item->Visible = TRUE; // Export to Email $item = &$this->ExportOptions->Add("email"); $url = ""; $item->Body = ""; $item->Visible = TRUE; // Drop down button for export $this->ExportOptions->UseButtonGroup = TRUE; $this->ExportOptions->UseImageAndText = TRUE; $this->ExportOptions->UseDropDownButton = TRUE; if ($this->ExportOptions->UseButtonGroup && ew_IsMobile()) $this->ExportOptions->UseDropDownButton = TRUE; $this->ExportOptions->DropDownButtonPhrase = $Language->Phrase("ButtonExport"); // Add group option item $item = &$this->ExportOptions->Add($this->ExportOptions->GroupOptionName); $item->Body = ""; $item->Visible = FALSE; // Hide options for export if ($this->Export <> "") $this->ExportOptions->HideAllOptions(); } // Export data in HTML/CSV/Word/Excel/XML/Email/PDF format function ExportData() { $utf8 = (strtolower(EW_CHARSET) == "utf-8"); $bSelectLimit = FALSE; // Load recordset if ($bSelectLimit) { $this->TotalRecs = $this->SelectRecordCount(); } else { if (!$this->Recordset) $this->Recordset = $this->LoadRecordset(); $rs = &$this->Recordset; if ($rs) $this->TotalRecs = $rs->RecordCount(); } $this->StartRec = 1; $this->SetUpStartRec(); // Set up start record position // Set the last record to display if ($this->DisplayRecs <= 0) { $this->StopRec = $this->TotalRecs; } else { $this->StopRec = $this->StartRec + $this->DisplayRecs - 1; } if (!$rs) { header("Content-Type:"); // Remove header header("Content-Disposition:"); $this->ShowMessage(); return; } $this->ExportDoc = ew_ExportDocument($this, "v"); $Doc = &$this->ExportDoc; if ($bSelectLimit) { $this->StartRec = 1; $this->StopRec = $this->DisplayRecs <= 0 ? $this->TotalRecs : $this->DisplayRecs; } else { //$this->StartRec = $this->StartRec; //$this->StopRec = $this->StopRec; } // Call Page Exporting server event $this->ExportDoc->ExportCustom = !$this->Page_Exporting(); $ParentTable = ""; $sHeader = $this->PageHeader; $this->Page_DataRendering($sHeader); $Doc->Text .= $sHeader; $this->ExportDocument($Doc, $rs, $this->StartRec, $this->StopRec, "view"); // Export detail records (tassigment) if (EW_EXPORT_DETAIL_RECORDS && in_array("tassigment", explode(",", $this->getCurrentDetailTable()))) { global $tassigment; if (!isset($tassigment)) $tassigment = new ctassigment; $rsdetail = $tassigment->LoadRs($tassigment->GetDetailFilter()); // Load detail records if ($rsdetail && !$rsdetail->EOF) { $ExportStyle = $Doc->Style; $Doc->SetStyle("h"); // Change to horizontal if ($this->Export <> "csv" || EW_EXPORT_DETAIL_RECORDS_FOR_CSV) { $Doc->ExportEmptyRow(); $detailcnt = $rsdetail->RecordCount(); $tassigment->ExportDocument($Doc, $rsdetail, 1, $detailcnt); } $Doc->SetStyle($ExportStyle); // Restore $rsdetail->Close(); } } $sFooter = $this->PageFooter; $this->Page_DataRendered($sFooter); $Doc->Text .= $sFooter; // Close recordset $rs->Close(); // Call Page Exported server event $this->Page_Exported(); // Export header and footer $Doc->ExportHeaderAndFooter(); // Clean output buffer if (!EW_DEBUG_ENABLED && ob_get_length()) ob_end_clean(); // Write debug message if enabled if (EW_DEBUG_ENABLED && $this->Export <> "pdf") echo ew_DebugMsg(); // Output data if ($this->Export == "email") { echo $this->ExportEmail($Doc->Text); } else { $Doc->Export(); } } // Export email function ExportEmail($EmailContent) { global $gTmpImages, $Language; $sSender = @$_POST["sender"]; $sRecipient = @$_POST["recipient"]; $sCc = @$_POST["cc"]; $sBcc = @$_POST["bcc"]; $sContentType = @$_POST["contenttype"]; // Subject $sSubject = ew_StripSlashes(@$_POST["subject"]); $sEmailSubject = $sSubject; // Message $sContent = ew_StripSlashes(@$_POST["message"]); $sEmailMessage = $sContent; // Check sender if ($sSender == "") { return "

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

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

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

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

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

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

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

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

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

"; } // Check email sent count if (!isset($_SESSION[EW_EXPORT_EMAIL_COUNTER])) $_SESSION[EW_EXPORT_EMAIL_COUNTER] = 0; if (intval($_SESSION[EW_EXPORT_EMAIL_COUNTER]) > EW_MAX_EMAIL_SENT_COUNT) { return "

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

"; } // Send email $Email = new cEmail(); $Email->Sender = $sSender; // Sender $Email->Recipient = $sRecipient; // Recipient $Email->Cc = $sCc; // Cc $Email->Bcc = $sBcc; // Bcc $Email->Subject = $sEmailSubject; // Subject $Email->Format = ($sContentType == "url") ? "text" : "html"; if ($sEmailMessage <> "") { $sEmailMessage = ew_RemoveXSS($sEmailMessage); $sEmailMessage .= ($sContentType == "url") ? "\r\n\r\n" : "

"; } if ($sContentType == "url") { $sUrl = ew_ConvertFullUrl(ew_CurrentPage() . "?" . $this->ExportQueryString()); $sEmailMessage .= $sUrl; // Send URL only } else { foreach ($gTmpImages as $tmpimage) $Email->AddEmbeddedImage($tmpimage); $sEmailMessage .= ew_CleanEmailContent($EmailContent); // Send HTML } $Email->Content = $sEmailMessage; // Content $EventArgs = array(); if ($this->Recordset) { $this->RecCnt = $this->StartRec - 1; $this->Recordset->MoveFirst(); if ($this->StartRec > 1) $this->Recordset->Move($this->StartRec - 1); $EventArgs["rs"] = &$this->Recordset; } $bEmailSent = FALSE; if ($this->Email_Sending($Email, $EventArgs)) $bEmailSent = $Email->Send(); // Check email sent status if ($bEmailSent) { // Update email sent count $_SESSION[EW_EXPORT_EMAIL_COUNTER]++; // Sent email success return "

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

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

" . $Email->SendErrDescription . "

"; } } // Export QueryString function ExportQueryString() { // Initialize $sQry = "export=html"; // Add record key QueryString $sQry .= "&" . substr($this->KeyUrl("", ""), 1); return $sQry; } // Set up detail parms based on QueryString function SetUpDetailParms() { // Get the keys for master table if (isset($_GET[EW_TABLE_SHOW_DETAIL])) { $sDetailTblVar = $_GET[EW_TABLE_SHOW_DETAIL]; $this->setCurrentDetailTable($sDetailTblVar); } else { $sDetailTblVar = $this->getCurrentDetailTable(); } if ($sDetailTblVar <> "") { $DetailTblVar = explode(",", $sDetailTblVar); if (in_array("tassigment", $DetailTblVar)) { if (!isset($GLOBALS["tassigment_grid"])) $GLOBALS["tassigment_grid"] = new ctassigment_grid; if ($GLOBALS["tassigment_grid"]->DetailView) { $GLOBALS["tassigment_grid"]->CurrentMode = "view"; // Save current master table to detail table $GLOBALS["tassigment_grid"]->setCurrentMasterTable($this->TableVar); $GLOBALS["tassigment_grid"]->setStartRecordNumber(1); $GLOBALS["tassigment_grid"]->idkSeeker->FldIsDetailKey = TRUE; $GLOBALS["tassigment_grid"]->idkSeeker->CurrentValue = $this->idSeeker->CurrentValue; $GLOBALS["tassigment_grid"]->idkSeeker->setSessionValue($GLOBALS["tassigment_grid"]->idkSeeker->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("tospitilist.php"), "", $this->TableVar, TRUE); $PageId = "view"; $Breadcrumb->Add("view", $PageId, $url); } // Setup lookup filters of a field function SetupLookupFilters($fld, $pageId = null) { global $gsLanguage; $pageId = $pageId ?: $this->PageID; switch ($fld->FldVar) { } } // Setup AutoSuggest filters of a field function SetupAutoSuggestFilters($fld, $pageId = null) { global $gsLanguage; $pageId = $pageId ?: $this->PageID; switch ($fld->FldVar) { } } // Page Load event function Page_Load() { //echo "Page Load"; } // Page Unload event function Page_Unload() { //echo "Page Unload"; } // Page Redirecting event function Page_Redirecting(&$url) { // Example: //$url = "your URL"; } // Message Showing event // $type = ''|'success'|'failure'|'warning' function Message_Showing(&$msg, $type) { if ($type == 'success') { //$msg = "your success message"; } elseif ($type == 'failure') { //$msg = "your failure message"; } elseif ($type == 'warning') { //$msg = "your warning message"; } else { //$msg = "your message"; } } // Page Render event function Page_Render() { //echo "Page Render"; } // Page Data Rendering event function Page_DataRendering(&$header) { // Example: //$header = "your header"; } // Page Data Rendered event function Page_DataRendered(&$footer) { // Example: //$footer = "your footer"; } // Page Exporting event // $this->ExportDoc = export document object function Page_Exporting() { //$this->ExportDoc->Text = "my header"; // Export header //return FALSE; // Return FALSE to skip default export and use Row_Export event return TRUE; // Return TRUE to use default export and skip Row_Export event } // Row Export event // $this->ExportDoc = export document object function Row_Export($rs) { //$this->ExportDoc->Text .= "my content"; // Build HTML with field value: $rs["MyField"] or $this->MyField->ViewValue } // Page Exported event // $this->ExportDoc = export document object function Page_Exported() { //$this->ExportDoc->Text .= "my footer"; // Export footer //echo $this->ExportDoc->Text; } } ?> Page_Init(); // Page main $tospiti_view->Page_Main(); // Global Page Rendering event (in userfn*.php) Page_Rendering(); // Page Rendering event $tospiti_view->Page_Render(); ?> Export == "") { ?> Export == "") { ?>

IsModal) { ?> Export == "") { ?> Render(); ?> ExportOptions->Render("body") ?> OtherOptions as &$option) $option->Render("body"); ?> IsModal) { ?> Export == "") { ?> SelectionForm(); ?>

ShowPageHeader(); ?> ShowMessage(); ?> IsModal) { ?> Export == "") { ?>

CheckToken) { ?> IsModal) { ?> Desk->Visible) { // Desk ?> UNHCR_code->Visible) { // UNHCR_code ?> Name->Visible) { // Name ?> Surname->Visible) { // Surname ?> BirthDate->Visible) { // BirthDate ?> BirthPlace->Visible) { // BirthPlace ?> Nationality->Visible) { // Nationality ?> Citizenship->Visible) { // Citizenship ?> Sex->Visible) { // Sex ?> Phone->Visible) { // Phone ?> _Email->Visible) { // Email ?> Religion->Visible) { // Religion ?> Place_of_Residence->Visible) { // Place_of_Residence ?> Address_of_Residence->Visible) { // Address_of_Residence ?> Town_of_residence->Visible) { // Town_of_residence ?> Place_of_Transit->Visible) { // Place_of_Transit ?> Address_of_Transit->Visible) { // Address_of_Transit ?> Town_of_transit->Visible) { // Town_of_transit ?> domicile_description->Visible) { // domicile_description ?> Disabled->Visible) { // Disabled ?> Sick->Visible) { // Sick ?> Alone->Visible) { // Alone ?> Elderly->Visible) { // Elderly ?> Family->Visible) { // Family ?> Householder->Visible) { // Householder ?> Householder_id->Visible) { // Householder_id ?> Householder_reltype->Visible) { // Householder_reltype ?> Ethnic_group->Visible) { // Ethnic_group ?> Known_languages->Visible) { // Known_languages ?> Title_of_study->Visible) { // Title_of_study ?> Poss_destination_country->Visible) { // Poss_destination_country ?> Document_type->Visible) { // Document_type ?> Document_number->Visible) { // Document_number ?> Document_release->Visible) { // Document_release ?> Document_expiry->Visible) { // Document_expiry ?> Document_nationality->Visible) { // Document_nationality ?> other_documents->Visible) { // other_documents ?> Final_evaluation->Visible) { // Final_evaluation ?> photo->Visible) { // photo ?> doc_image->Visible) { // doc_image ?> Notes->Visible) { // Notes ?> Interview_1->Visible) { // Interview_1 ?> interview1_date->Visible) { // interview1_date ?> Interview_2->Visible) { // Interview_2 ?> interview_2_date->Visible) { // interview_2_date ?> Interview_3->Visible) { // Interview_3 ?> interview_3_date->Visible) { // interview_3_date ?> Zone_of_Transit->Visible) { // Zone_of_Transit ?> Travel_number->Visible) { // Travel_number ?> Travel_arrival_date->Visible) { // Travel_arrival_date ?> Travel_arrival_time->Visible) { // Travel_arrival_time ?> num_family->Visible) { // num_family ?> speak_ENG->Visible) { // speak_ENG ?> speak_FRA->Visible) { // speak_FRA ?> speak_ARA->Visible) { // speak_ARA ?> speak_ITA->Visible) { // speak_ITA ?> lives_with->Visible) { // lives_with ?> family_know->Visible) { // family_know ?> date_of_entry_transit->Visible) { // date_of_entry_transit ?> marital_status->Visible) { // marital_status ?> consort_id->Visible) { // consort_id ?> consort_info->Visible) { // consort_info ?> other_fam_in_italy->Visible) { // other_fam_in_italy ?> other_fam_in_europe->Visible) { // other_fam_in_europe ?> where_lived->Visible) { // where_lived ?> medical_situation->Visible) { // medical_situation ?> social_situation->Visible) { // social_situation ?> abuse_suffered->Visible) { // abuse_suffered ?> abuse_description->Visible) { // abuse_description ?> work_done->Visible) { // work_done ?> military_service->Visible) { // military_service ?> itinerary->Visible) { // itinerary ?> convictions->Visible) { // convictions ?> requested_asylum->Visible) { // requested_asylum ?> resettlement_application->Visible) { // resettlement_application ?> resettlement_country->Visible) { // resettlement_country ?> reunion_application->Visible) { // reunion_application ?> reunion_country->Visible) { // reunion_country ?> belongs_to_organization->Visible) { // belongs_to_organization ?> organizations->Visible) { // organizations ?> presentations->Visible) { // presentations ?> report->Visible) { // report ?> IsModal) { ?> Export == "") { ?> Pager)) $tospiti_view->Pager = new cNumericPager($tospiti_view->StartRec, $tospiti_view->DisplayRecs, $tospiti_view->TotalRecs, $tospiti_view->RecRange) ?> Pager->RecordCount > 0 && $tospiti_view->Pager->Visible) { ?>

Phrase("PagerFirst") ?>
Phrase("PagerPrevious") ?>

Enabled) { echo " class=\" active\""; } ?>>">Text ?> Pager->NextButton->Enabled) { ?>

Phrase("PagerNext") ?>

Pager->LastButton->Enabled) { ?>

Phrase("PagerLast") ?>

getCurrentDetailTable())) && $tassigment->DetailView) { ?> getCurrentDetailTable() <> "") { ?>

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

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

Desk->FldCaption() ?>	Desk->CellAttributes() ?>> Desk->ViewAttributes() ?>> Desk->ViewValue ?>
UNHCR_code->FldCaption() ?>	UNHCR_code->CellAttributes() ?>> UNHCR_code->ViewAttributes() ?>> UNHCR_code->ViewValue ?>
Name->FldCaption() ?>	Name->CellAttributes() ?>> Name->ViewAttributes() ?>> Name->ViewValue ?>
Surname->FldCaption() ?>	Surname->CellAttributes() ?>> Surname->ViewAttributes() ?>> Surname->ViewValue ?>
BirthDate->FldCaption() ?>	BirthDate->CellAttributes() ?>> BirthDate->ViewAttributes() ?>> BirthDate->ViewValue ?>
BirthPlace->FldCaption() ?>	BirthPlace->CellAttributes() ?>> BirthPlace->ViewAttributes() ?>> BirthPlace->ViewValue ?>
Nationality->FldCaption() ?>	Nationality->CellAttributes() ?>> Nationality->ViewAttributes() ?>> Nationality->ViewValue ?>
Citizenship->FldCaption() ?>	Citizenship->CellAttributes() ?>> Citizenship->ViewAttributes() ?>> Citizenship->ViewValue ?>
Sex->FldCaption() ?>	Sex->CellAttributes() ?>> Sex->ViewAttributes() ?>> Sex->ViewValue ?>
Phone->FldCaption() ?>	Phone->CellAttributes() ?>> Phone->ViewAttributes() ?>> Phone->ViewValue ?>
_Email->FldCaption() ?>	_Email->CellAttributes() ?>> _Email->ViewAttributes() ?>> _Email->ViewValue ?>
Religion->FldCaption() ?>	Religion->CellAttributes() ?>> Religion->ViewAttributes() ?>> Religion->ViewValue ?>
Place_of_Residence->FldCaption() ?>	Place_of_Residence->CellAttributes() ?>> Place_of_Residence->ViewAttributes() ?>> Place_of_Residence->ViewValue ?>
Address_of_Residence->FldCaption() ?>	Address_of_Residence->CellAttributes() ?>> Address_of_Residence->ViewAttributes() ?>> Address_of_Residence->ViewValue ?>
Town_of_residence->FldCaption() ?>	Town_of_residence->CellAttributes() ?>> Town_of_residence->ViewAttributes() ?>> Town_of_residence->ViewValue ?>
Place_of_Transit->FldCaption() ?>	Place_of_Transit->CellAttributes() ?>> Place_of_Transit->ViewAttributes() ?>> Place_of_Transit->ViewValue ?>
Address_of_Transit->FldCaption() ?>	Address_of_Transit->CellAttributes() ?>> Address_of_Transit->ViewAttributes() ?>> Address_of_Transit->ViewValue ?>
Town_of_transit->FldCaption() ?>	Town_of_transit->CellAttributes() ?>> Town_of_transit->ViewAttributes() ?>> Town_of_transit->ViewValue ?>
domicile_description->FldCaption() ?>	domicile_description->CellAttributes() ?>> domicile_description->ViewAttributes() ?>> domicile_description->ViewValue ?>
Disabled->FldCaption() ?>	Disabled->CellAttributes() ?>> Disabled->ViewAttributes() ?>> Disabled->ViewValue ?>
Sick->FldCaption() ?>	Sick->CellAttributes() ?>> Sick->ViewAttributes() ?>> Sick->ViewValue ?>
Alone->FldCaption() ?>	Alone->CellAttributes() ?>> Alone->ViewAttributes() ?>> Alone->ViewValue ?>
Elderly->FldCaption() ?>	Elderly->CellAttributes() ?>> Elderly->ViewAttributes() ?>> Elderly->ViewValue ?>
Family->FldCaption() ?>	Family->CellAttributes() ?>> Family->ViewAttributes() ?>> Family->ViewValue ?>
Householder->FldCaption() ?>	Householder->CellAttributes() ?>> Householder->ViewAttributes() ?>> Householder->ViewValue ?>
Householder_id->FldCaption() ?>	Householder_id->CellAttributes() ?>> Householder_id->ViewAttributes() ?>> Householder_id->ViewValue ?>
Householder_reltype->FldCaption() ?>	Householder_reltype->CellAttributes() ?>> Householder_reltype->ViewAttributes() ?>> Householder_reltype->ViewValue ?>
Ethnic_group->FldCaption() ?>	Ethnic_group->CellAttributes() ?>> Ethnic_group->ViewAttributes() ?>> Ethnic_group->ViewValue ?>
Known_languages->FldCaption() ?>	Known_languages->CellAttributes() ?>> Known_languages->ViewAttributes() ?>> Known_languages->ViewValue ?>
Title_of_study->FldCaption() ?>	Title_of_study->CellAttributes() ?>> Title_of_study->ViewAttributes() ?>> Title_of_study->ViewValue ?>
Poss_destination_country->FldCaption() ?>	Poss_destination_country->CellAttributes() ?>> Poss_destination_country->ViewAttributes() ?>> Poss_destination_country->ViewValue ?>
Document_type->FldCaption() ?>	Document_type->CellAttributes() ?>> Document_type->ViewAttributes() ?>> Document_type->ViewValue ?>
Document_number->FldCaption() ?>	Document_number->CellAttributes() ?>> Document_number->ViewAttributes() ?>> Document_number->ViewValue ?>
Document_release->FldCaption() ?>	Document_release->CellAttributes() ?>> Document_release->ViewAttributes() ?>> Document_release->ViewValue ?>
Document_expiry->FldCaption() ?>	Document_expiry->CellAttributes() ?>> Document_expiry->ViewAttributes() ?>> Document_expiry->ViewValue ?>
Document_nationality->FldCaption() ?>	Document_nationality->CellAttributes() ?>> Document_nationality->ViewAttributes() ?>> Document_nationality->ViewValue ?>
other_documents->FldCaption() ?>	other_documents->CellAttributes() ?>> other_documents->ViewAttributes() ?>> other_documents->ViewValue ?>
Final_evaluation->FldCaption() ?>	Final_evaluation->CellAttributes() ?>> Final_evaluation->ViewAttributes() ?>> Final_evaluation->ViewValue ?>
photo->FldCaption() ?>	photo->CellAttributes() ?>> photo, $tospiti->photo->ViewValue) ?>
doc_image->FldCaption() ?>	doc_image->CellAttributes() ?>> doc_image, $tospiti->doc_image->ViewValue) ?>
Notes->FldCaption() ?>	Notes->CellAttributes() ?>> Notes->ViewAttributes() ?>> Notes->ViewValue ?>
Interview_1->FldCaption() ?>	Interview_1->CellAttributes() ?>> Interview_1->ViewAttributes() ?>> Interview_1->CurrentValue)) { ?>
interview1_date->FldCaption() ?>	interview1_date->CellAttributes() ?>> interview1_date->ViewAttributes() ?>> interview1_date->ViewValue ?>
Interview_2->FldCaption() ?>	Interview_2->CellAttributes() ?>> Interview_2->ViewAttributes() ?>> Interview_2->CurrentValue)) { ?>
interview_2_date->FldCaption() ?>	interview_2_date->CellAttributes() ?>> interview_2_date->ViewAttributes() ?>> interview_2_date->ViewValue ?>
Interview_3->FldCaption() ?>	Interview_3->CellAttributes() ?>> Interview_3->ViewAttributes() ?>> Interview_3->CurrentValue)) { ?>
interview_3_date->FldCaption() ?>	interview_3_date->CellAttributes() ?>> interview_3_date->ViewAttributes() ?>> interview_3_date->ViewValue ?>
Zone_of_Transit->FldCaption() ?>	Zone_of_Transit->CellAttributes() ?>> Zone_of_Transit->ViewAttributes() ?>> Zone_of_Transit->ViewValue ?>
Travel_number->FldCaption() ?>	Travel_number->CellAttributes() ?>> Travel_number->ViewAttributes() ?>> Travel_number->ViewValue ?>
Travel_arrival_date->FldCaption() ?>	Travel_arrival_date->CellAttributes() ?>> Travel_arrival_date->ViewAttributes() ?>> Travel_arrival_date->ViewValue ?>
Travel_arrival_time->FldCaption() ?>	Travel_arrival_time->CellAttributes() ?>> Travel_arrival_time->ViewAttributes() ?>> Travel_arrival_time->ViewValue ?>
num_family->FldCaption() ?>	num_family->CellAttributes() ?>> num_family->ViewAttributes() ?>> num_family->ViewValue ?>
speak_ENG->FldCaption() ?>	speak_ENG->CellAttributes() ?>> speak_ENG->ViewAttributes() ?>> speak_ENG->CurrentValue)) { ?>
speak_FRA->FldCaption() ?>	speak_FRA->CellAttributes() ?>> speak_FRA->ViewAttributes() ?>> speak_FRA->CurrentValue)) { ?>
speak_ARA->FldCaption() ?>	speak_ARA->CellAttributes() ?>> speak_ARA->ViewAttributes() ?>> speak_ARA->CurrentValue)) { ?>
speak_ITA->FldCaption() ?>	speak_ITA->CellAttributes() ?>> speak_ITA->ViewAttributes() ?>> speak_ITA->CurrentValue)) { ?>
lives_with->FldCaption() ?>	lives_with->CellAttributes() ?>> lives_with->ViewAttributes() ?>> lives_with->ViewValue ?>
family_know->FldCaption() ?>	family_know->CellAttributes() ?>> family_know->ViewAttributes() ?>> family_know->CurrentValue)) { ?>
date_of_entry_transit->FldCaption() ?>	date_of_entry_transit->CellAttributes() ?>> date_of_entry_transit->ViewAttributes() ?>> date_of_entry_transit->ViewValue ?>
marital_status->FldCaption() ?>	marital_status->CellAttributes() ?>> marital_status->ViewAttributes() ?>> marital_status->ViewValue ?>
consort_id->FldCaption() ?>	consort_id->CellAttributes() ?>> consort_id->ViewAttributes() ?>> consort_id->ViewValue ?>
consort_info->FldCaption() ?>	consort_info->CellAttributes() ?>> consort_info->ViewAttributes() ?>> consort_info->ViewValue ?>
other_fam_in_italy->FldCaption() ?>	other_fam_in_italy->CellAttributes() ?>> other_fam_in_italy->ViewAttributes() ?>> other_fam_in_italy->ViewValue ?>
other_fam_in_europe->FldCaption() ?>	other_fam_in_europe->CellAttributes() ?>> other_fam_in_europe->ViewAttributes() ?>> other_fam_in_europe->ViewValue ?>
where_lived->FldCaption() ?>	where_lived->CellAttributes() ?>> where_lived->ViewAttributes() ?>> where_lived->ViewValue ?>
medical_situation->FldCaption() ?>	medical_situation->CellAttributes() ?>> medical_situation->ViewAttributes() ?>> medical_situation->ViewValue ?>
social_situation->FldCaption() ?>	social_situation->CellAttributes() ?>> social_situation->ViewAttributes() ?>> social_situation->ViewValue ?>
abuse_suffered->FldCaption() ?>	abuse_suffered->CellAttributes() ?>> abuse_suffered->ViewAttributes() ?>> abuse_suffered->CurrentValue)) { ?>
abuse_description->FldCaption() ?>	abuse_description->CellAttributes() ?>> abuse_description->ViewAttributes() ?>> abuse_description->ViewValue ?>
work_done->FldCaption() ?>	work_done->CellAttributes() ?>> work_done->ViewAttributes() ?>> work_done->ViewValue ?>
military_service->FldCaption() ?>	military_service->CellAttributes() ?>> military_service->ViewAttributes() ?>> military_service->ViewValue ?>
itinerary->FldCaption() ?>	itinerary->CellAttributes() ?>> itinerary->ViewAttributes() ?>> itinerary->ViewValue ?>
convictions->FldCaption() ?>	convictions->CellAttributes() ?>> convictions->ViewAttributes() ?>> convictions->CurrentValue)) { ?>
requested_asylum->FldCaption() ?>	requested_asylum->CellAttributes() ?>> requested_asylum->ViewAttributes() ?>> requested_asylum->ViewValue ?>
resettlement_application->FldCaption() ?>	resettlement_application->CellAttributes() ?>> resettlement_application->ViewAttributes() ?>> resettlement_application->CurrentValue)) { ?>
resettlement_country->FldCaption() ?>	resettlement_country->CellAttributes() ?>> resettlement_country->ViewAttributes() ?>> resettlement_country->ViewValue ?>
reunion_application->FldCaption() ?>	reunion_application->CellAttributes() ?>> reunion_application->ViewAttributes() ?>> reunion_application->CurrentValue)) { ?>
reunion_country->FldCaption() ?>	reunion_country->CellAttributes() ?>> reunion_country->ViewAttributes() ?>> reunion_country->ViewValue ?>
belongs_to_organization->FldCaption() ?>	belongs_to_organization->CellAttributes() ?>> belongs_to_organization->ViewAttributes() ?>> belongs_to_organization->CurrentValue)) { ?>
organizations->FldCaption() ?>	organizations->CellAttributes() ?>> organizations->ViewAttributes() ?>> organizations->ViewValue ?>
presentations->FldCaption() ?>	presentations->CellAttributes() ?>> presentations->ViewAttributes() ?>> presentations->ViewValue ?>
report->FldCaption() ?>	report->CellAttributes() ?>> report->ViewAttributes() ?>> report->ViewValue ?>