TableVar = 'tospiti'; $this->TableName = 'tospiti'; $this->TableType = 'TABLE'; // Update Table $this->UpdateTable = "`tospiti`"; $this->DBID = 'DB'; $this->ExportAll = TRUE; $this->ExportPageBreakCount = 0; // Page break per every n record (PDF only) $this->ExportPageOrientation = "portrait"; // Page orientation (PDF only) $this->ExportPageSize = "a4"; // Page size (PDF only) $this->ExportExcelPageOrientation = PHPExcel_Worksheet_PageSetup::ORIENTATION_DEFAULT; // Page orientation (PHPExcel only) $this->ExportExcelPageSize = PHPExcel_Worksheet_PageSetup::PAPERSIZE_A4; // Page size (PHPExcel only) $this->DetailAdd = FALSE; // Allow detail add $this->DetailEdit = FALSE; // Allow detail edit $this->DetailView = TRUE; // Allow detail view $this->ShowMultipleDetails = FALSE; // Show multiple details $this->GridAddRowCount = 5; $this->AllowAddDeleteRow = ew_AllowAddDeleteRow(); // Allow add/delete row $this->UserIDAllowSecurity = 0; // User ID Allow $this->BasicSearch = new cBasicSearch($this->TableVar); // idSeeker $this->idSeeker = new cField('tospiti', 'tospiti', 'x_idSeeker', 'idSeeker', '`idSeeker`', '`idSeeker`', 19, -1, FALSE, '`idSeeker`', FALSE, FALSE, FALSE, 'FORMATTED TEXT', 'NO'); $this->idSeeker->Sortable = TRUE; // Allow sort $this->idSeeker->FldDefaultErrMsg = $Language->Phrase("IncorrectInteger"); $this->fields['idSeeker'] = &$this->idSeeker; // Desk $this->Desk = new cField('tospiti', 'tospiti', 'x_Desk', 'Desk', '`Desk`', '`Desk`', 200, -1, FALSE, '`Desk`', FALSE, FALSE, FALSE, 'FORMATTED TEXT', 'TEXT'); $this->Desk->Sortable = FALSE; // Allow sort $this->fields['Desk'] = &$this->Desk; // UNHCR_code $this->UNHCR_code = new cField('tospiti', 'tospiti', 'x_UNHCR_code', 'UNHCR_code', '`UNHCR_code`', '`UNHCR_code`', 200, -1, FALSE, '`UNHCR_code`', FALSE, FALSE, FALSE, 'FORMATTED TEXT', 'TEXT'); $this->UNHCR_code->Sortable = TRUE; // Allow sort $this->fields['UNHCR_code'] = &$this->UNHCR_code; // Name $this->Name = new cField('tospiti', 'tospiti', 'x_Name', 'Name', '`Name`', '`Name`', 200, -1, FALSE, '`Name`', FALSE, FALSE, FALSE, 'FORMATTED TEXT', 'TEXT'); $this->Name->Sortable = TRUE; // Allow sort $this->fields['Name'] = &$this->Name; // Surname $this->Surname = new cField('tospiti', 'tospiti', 'x_Surname', 'Surname', '`Surname`', '`Surname`', 200, -1, FALSE, '`Surname`', FALSE, FALSE, FALSE, 'FORMATTED TEXT', 'TEXT'); $this->Surname->Sortable = TRUE; // Allow sort $this->fields['Surname'] = &$this->Surname; // BirthDate $this->BirthDate = new cField('tospiti', 'tospiti', 'x_BirthDate', 'BirthDate', '`BirthDate`', ew_CastDateFieldForLike('`BirthDate`', 7, "DB"), 133, 7, FALSE, '`BirthDate`', FALSE, FALSE, FALSE, 'FORMATTED TEXT', 'TEXT'); $this->BirthDate->Sortable = TRUE; // Allow sort $this->BirthDate->FldDefaultErrMsg = str_replace("%s", $GLOBALS["EW_DATE_SEPARATOR"], $Language->Phrase("IncorrectDateDMY")); $this->fields['BirthDate'] = &$this->BirthDate; // BirthPlace $this->BirthPlace = new cField('tospiti', 'tospiti', 'x_BirthPlace', 'BirthPlace', '`BirthPlace`', '`BirthPlace`', 200, -1, FALSE, '`BirthPlace`', FALSE, FALSE, FALSE, 'FORMATTED TEXT', 'TEXT'); $this->BirthPlace->Sortable = TRUE; // Allow sort $this->fields['BirthPlace'] = &$this->BirthPlace; // Nationality $this->Nationality = new cField('tospiti', 'tospiti', 'x_Nationality', 'Nationality', '`Nationality`', '`Nationality`', 200, -1, FALSE, '`EV__Nationality`', TRUE, FALSE, TRUE, 'FORMATTED TEXT', 'TEXT'); $this->Nationality->Sortable = TRUE; // Allow sort $this->fields['Nationality'] = &$this->Nationality; // Citizenship $this->Citizenship = new cField('tospiti', 'tospiti', 'x_Citizenship', 'Citizenship', '`Citizenship`', '`Citizenship`', 200, -1, FALSE, '`EV__Citizenship`', TRUE, FALSE, TRUE, 'FORMATTED TEXT', 'TEXT'); $this->Citizenship->Sortable = FALSE; // Allow sort $this->fields['Citizenship'] = &$this->Citizenship; // Sex $this->Sex = new cField('tospiti', 'tospiti', 'x_Sex', 'Sex', '`Sex`', '`Sex`', 200, -1, FALSE, '`Sex`', FALSE, FALSE, FALSE, 'FORMATTED TEXT', 'SELECT'); $this->Sex->Sortable = TRUE; // Allow sort $this->Sex->UsePleaseSelect = TRUE; // Use PleaseSelect by default $this->Sex->PleaseSelectText = $Language->Phrase("PleaseSelect"); // PleaseSelect text $this->Sex->OptionCount = 2; $this->fields['Sex'] = &$this->Sex; // Phone $this->Phone = new cField('tospiti', 'tospiti', 'x_Phone', 'Phone', '`Phone`', '`Phone`', 200, -1, FALSE, '`Phone`', FALSE, FALSE, FALSE, 'FORMATTED TEXT', 'TEXT'); $this->Phone->Sortable = TRUE; // Allow sort $this->fields['Phone'] = &$this->Phone; // Email $this->_Email = new cField('tospiti', 'tospiti', 'x__Email', 'Email', '`Email`', '`Email`', 200, -1, FALSE, '`Email`', FALSE, FALSE, FALSE, 'FORMATTED TEXT', 'TEXT'); $this->_Email->Sortable = TRUE; // Allow sort $this->fields['Email'] = &$this->_Email; // Religion $this->Religion = new cField('tospiti', 'tospiti', 'x_Religion', 'Religion', '`Religion`', '`Religion`', 200, -1, FALSE, '`Religion`', FALSE, FALSE, FALSE, 'FORMATTED TEXT', 'SELECT'); $this->Religion->Sortable = TRUE; // Allow sort $this->Religion->UsePleaseSelect = TRUE; // Use PleaseSelect by default $this->Religion->PleaseSelectText = $Language->Phrase("PleaseSelect"); // PleaseSelect text $this->fields['Religion'] = &$this->Religion; // Place_of_Residence $this->Place_of_Residence = new cField('tospiti', 'tospiti', 'x_Place_of_Residence', 'Place_of_Residence', '`Place_of_Residence`', '`Place_of_Residence`', 200, -1, FALSE, '`EV__Place_of_Residence`', TRUE, TRUE, TRUE, 'FORMATTED TEXT', 'SELECT'); $this->Place_of_Residence->Sortable = TRUE; // Allow sort $this->Place_of_Residence->UsePleaseSelect = TRUE; // Use PleaseSelect by default $this->Place_of_Residence->PleaseSelectText = $Language->Phrase("PleaseSelect"); // PleaseSelect text $this->fields['Place_of_Residence'] = &$this->Place_of_Residence; // Address_of_Residence $this->Address_of_Residence = new cField('tospiti', 'tospiti', 'x_Address_of_Residence', 'Address_of_Residence', '`Address_of_Residence`', '`Address_of_Residence`', 200, -1, FALSE, '`Address_of_Residence`', FALSE, FALSE, FALSE, 'FORMATTED TEXT', 'TEXT'); $this->Address_of_Residence->Sortable = FALSE; // Allow sort $this->fields['Address_of_Residence'] = &$this->Address_of_Residence; // Town_of_residence $this->Town_of_residence = new cField('tospiti', 'tospiti', 'x_Town_of_residence', 'Town_of_residence', '`Town_of_residence`', '`Town_of_residence`', 200, -1, FALSE, '`Town_of_residence`', FALSE, FALSE, FALSE, 'FORMATTED TEXT', 'TEXT'); $this->Town_of_residence->Sortable = FALSE; // Allow sort $this->fields['Town_of_residence'] = &$this->Town_of_residence; // Place_of_Transit $this->Place_of_Transit = new cField('tospiti', 'tospiti', 'x_Place_of_Transit', 'Place_of_Transit', '`Place_of_Transit`', '`Place_of_Transit`', 200, -1, FALSE, '`EV__Place_of_Transit`', TRUE, TRUE, TRUE, 'FORMATTED TEXT', 'SELECT'); $this->Place_of_Transit->Sortable = FALSE; // Allow sort $this->Place_of_Transit->UsePleaseSelect = TRUE; // Use PleaseSelect by default $this->Place_of_Transit->PleaseSelectText = $Language->Phrase("PleaseSelect"); // PleaseSelect text $this->fields['Place_of_Transit'] = &$this->Place_of_Transit; // Address_of_Transit $this->Address_of_Transit = new cField('tospiti', 'tospiti', 'x_Address_of_Transit', 'Address_of_Transit', '`Address_of_Transit`', '`Address_of_Transit`', 200, -1, FALSE, '`Address_of_Transit`', FALSE, FALSE, FALSE, 'FORMATTED TEXT', 'TEXT'); $this->Address_of_Transit->Sortable = FALSE; // Allow sort $this->fields['Address_of_Transit'] = &$this->Address_of_Transit; // Town_of_transit $this->Town_of_transit = new cField('tospiti', 'tospiti', 'x_Town_of_transit', 'Town_of_transit', '`Town_of_transit`', '`Town_of_transit`', 200, -1, FALSE, '`Town_of_transit`', FALSE, FALSE, FALSE, 'FORMATTED TEXT', 'TEXT'); $this->Town_of_transit->Sortable = FALSE; // Allow sort $this->fields['Town_of_transit'] = &$this->Town_of_transit; // domicile_description $this->domicile_description = new cField('tospiti', 'tospiti', 'x_domicile_description', 'domicile_description', '`domicile_description`', '`domicile_description`', 200, -1, FALSE, '`domicile_description`', FALSE, FALSE, FALSE, 'FORMATTED TEXT', 'TEXT'); $this->domicile_description->Sortable = FALSE; // Allow sort $this->fields['domicile_description'] = &$this->domicile_description; // Disabled $this->Disabled = new cField('tospiti', 'tospiti', 'x_Disabled', 'Disabled', '`Disabled`', '`Disabled`', 202, -1, FALSE, '`Disabled`', FALSE, FALSE, FALSE, 'FORMATTED TEXT', 'RADIO'); $this->Disabled->Sortable = TRUE; // Allow sort $this->Disabled->FldDataType = EW_DATATYPE_BOOLEAN; $this->Disabled->TrueValue = 'Y'; $this->Disabled->FalseValue = 'N'; $this->Disabled->OptionCount = 2; $this->fields['Disabled'] = &$this->Disabled; // Sick $this->Sick = new cField('tospiti', 'tospiti', 'x_Sick', 'Sick', '`Sick`', '`Sick`', 202, -1, FALSE, '`Sick`', FALSE, FALSE, FALSE, 'FORMATTED TEXT', 'RADIO'); $this->Sick->Sortable = TRUE; // Allow sort $this->Sick->FldDataType = EW_DATATYPE_BOOLEAN; $this->Sick->TrueValue = 'Y'; $this->Sick->FalseValue = 'N'; $this->Sick->OptionCount = 2; $this->fields['Sick'] = &$this->Sick; // Alone $this->Alone = new cField('tospiti', 'tospiti', 'x_Alone', 'Alone', '`Alone`', '`Alone`', 202, -1, FALSE, '`Alone`', FALSE, FALSE, FALSE, 'FORMATTED TEXT', 'RADIO'); $this->Alone->Sortable = TRUE; // Allow sort $this->Alone->FldDataType = EW_DATATYPE_BOOLEAN; $this->Alone->TrueValue = 'Y'; $this->Alone->FalseValue = 'N'; $this->Alone->OptionCount = 2; $this->fields['Alone'] = &$this->Alone; // Elderly $this->Elderly = new cField('tospiti', 'tospiti', 'x_Elderly', 'Elderly', '`Elderly`', '`Elderly`', 202, -1, FALSE, '`Elderly`', FALSE, FALSE, FALSE, 'FORMATTED TEXT', 'RADIO'); $this->Elderly->Sortable = TRUE; // Allow sort $this->Elderly->FldDataType = EW_DATATYPE_BOOLEAN; $this->Elderly->TrueValue = 'Y'; $this->Elderly->FalseValue = 'N'; $this->Elderly->OptionCount = 2; $this->fields['Elderly'] = &$this->Elderly; // Family $this->Family = new cField('tospiti', 'tospiti', 'x_Family', 'Family', '`Family`', '`Family`', 202, -1, FALSE, '`Family`', FALSE, FALSE, FALSE, 'FORMATTED TEXT', 'RADIO'); $this->Family->Sortable = TRUE; // Allow sort $this->Family->FldDataType = EW_DATATYPE_BOOLEAN; $this->Family->TrueValue = 'Y'; $this->Family->FalseValue = 'N'; $this->Family->OptionCount = 2; $this->fields['Family'] = &$this->Family; // Householder $this->Householder = new cField('tospiti', 'tospiti', 'x_Householder', 'Householder', '`Householder`', '`Householder`', 202, -1, FALSE, '`Householder`', FALSE, FALSE, FALSE, 'FORMATTED TEXT', 'RADIO'); $this->Householder->Sortable = TRUE; // Allow sort $this->Householder->FldDataType = EW_DATATYPE_BOOLEAN; $this->Householder->TrueValue = 'Y'; $this->Householder->FalseValue = 'N'; $this->Householder->OptionCount = 2; $this->fields['Householder'] = &$this->Householder; // Householder_id $this->Householder_id = new cField('tospiti', 'tospiti', 'x_Householder_id', 'Householder_id', '`Householder_id`', '`Householder_id`', 3, -1, FALSE, '`EV__Householder_id`', TRUE, FALSE, TRUE, 'FORMATTED TEXT', 'TEXT'); $this->Householder_id->Sortable = FALSE; // Allow sort $this->Householder_id->FldDefaultErrMsg = $Language->Phrase("IncorrectInteger"); $this->fields['Householder_id'] = &$this->Householder_id; // Householder_reltype $this->Householder_reltype = new cField('tospiti', 'tospiti', 'x_Householder_reltype', 'Householder_reltype', '`Householder_reltype`', '`Householder_reltype`', 200, -1, FALSE, '`Householder_reltype`', FALSE, FALSE, FALSE, 'FORMATTED TEXT', 'SELECT'); $this->Householder_reltype->Sortable = FALSE; // Allow sort $this->Householder_reltype->UsePleaseSelect = TRUE; // Use PleaseSelect by default $this->Householder_reltype->PleaseSelectText = $Language->Phrase("PleaseSelect"); // PleaseSelect text $this->fields['Householder_reltype'] = &$this->Householder_reltype; // Ethnic_group $this->Ethnic_group = new cField('tospiti', 'tospiti', 'x_Ethnic_group', 'Ethnic_group', '`Ethnic_group`', '`Ethnic_group`', 200, -1, FALSE, '`Ethnic_group`', FALSE, FALSE, FALSE, 'FORMATTED TEXT', 'TEXT'); $this->Ethnic_group->Sortable = FALSE; // Allow sort $this->fields['Ethnic_group'] = &$this->Ethnic_group; // Known_languages $this->Known_languages = new cField('tospiti', 'tospiti', 'x_Known_languages', 'Known_languages', '`Known_languages`', '`Known_languages`', 200, -1, FALSE, '`Known_languages`', FALSE, FALSE, FALSE, 'FORMATTED TEXT', 'TEXT'); $this->Known_languages->Sortable = FALSE; // Allow sort $this->fields['Known_languages'] = &$this->Known_languages; // Title_of_study $this->Title_of_study = new cField('tospiti', 'tospiti', 'x_Title_of_study', 'Title_of_study', '`Title_of_study`', '`Title_of_study`', 200, -1, FALSE, '`Title_of_study`', FALSE, FALSE, FALSE, 'FORMATTED TEXT', 'TEXT'); $this->Title_of_study->Sortable = FALSE; // Allow sort $this->fields['Title_of_study'] = &$this->Title_of_study; // Poss_destination_country $this->Poss_destination_country = new cField('tospiti', 'tospiti', 'x_Poss_destination_country', 'Poss_destination_country', '`Poss_destination_country`', '`Poss_destination_country`', 200, -1, FALSE, '`Poss_destination_country`', FALSE, FALSE, FALSE, 'FORMATTED TEXT', 'TEXT'); $this->Poss_destination_country->Sortable = FALSE; // Allow sort $this->fields['Poss_destination_country'] = &$this->Poss_destination_country; // Document_type $this->Document_type = new cField('tospiti', 'tospiti', 'x_Document_type', 'Document_type', '`Document_type`', '`Document_type`', 200, -1, FALSE, '`Document_type`', FALSE, FALSE, FALSE, 'FORMATTED TEXT', 'SELECT'); $this->Document_type->Sortable = FALSE; // Allow sort $this->Document_type->UsePleaseSelect = TRUE; // Use PleaseSelect by default $this->Document_type->PleaseSelectText = $Language->Phrase("PleaseSelect"); // PleaseSelect text $this->fields['Document_type'] = &$this->Document_type; // Document_number $this->Document_number = new cField('tospiti', 'tospiti', 'x_Document_number', 'Document_number', '`Document_number`', '`Document_number`', 200, -1, FALSE, '`Document_number`', FALSE, FALSE, FALSE, 'FORMATTED TEXT', 'TEXT'); $this->Document_number->Sortable = FALSE; // Allow sort $this->fields['Document_number'] = &$this->Document_number; // Document_release $this->Document_release = new cField('tospiti', 'tospiti', 'x_Document_release', 'Document_release', '`Document_release`', ew_CastDateFieldForLike('`Document_release`', 7, "DB"), 133, 7, FALSE, '`Document_release`', FALSE, FALSE, FALSE, 'FORMATTED TEXT', 'TEXT'); $this->Document_release->Sortable = FALSE; // Allow sort $this->Document_release->FldDefaultErrMsg = str_replace("%s", $GLOBALS["EW_DATE_SEPARATOR"], $Language->Phrase("IncorrectDateDMY")); $this->fields['Document_release'] = &$this->Document_release; // Document_expiry $this->Document_expiry = new cField('tospiti', 'tospiti', 'x_Document_expiry', 'Document_expiry', '`Document_expiry`', ew_CastDateFieldForLike('`Document_expiry`', 7, "DB"), 133, 7, FALSE, '`Document_expiry`', FALSE, FALSE, FALSE, 'FORMATTED TEXT', 'TEXT'); $this->Document_expiry->Sortable = FALSE; // Allow sort $this->Document_expiry->FldDefaultErrMsg = str_replace("%s", $GLOBALS["EW_DATE_SEPARATOR"], $Language->Phrase("IncorrectDateDMY")); $this->fields['Document_expiry'] = &$this->Document_expiry; // Document_nationality $this->Document_nationality = new cField('tospiti', 'tospiti', 'x_Document_nationality', 'Document_nationality', '`Document_nationality`', '`Document_nationality`', 200, -1, FALSE, '`EV__Document_nationality`', TRUE, TRUE, TRUE, 'FORMATTED TEXT', 'SELECT'); $this->Document_nationality->Sortable = FALSE; // Allow sort $this->Document_nationality->UsePleaseSelect = TRUE; // Use PleaseSelect by default $this->Document_nationality->PleaseSelectText = $Language->Phrase("PleaseSelect"); // PleaseSelect text $this->fields['Document_nationality'] = &$this->Document_nationality; // other_documents $this->other_documents = new cField('tospiti', 'tospiti', 'x_other_documents', 'other_documents', '`other_documents`', '`other_documents`', 200, -1, FALSE, '`other_documents`', FALSE, FALSE, FALSE, 'FORMATTED TEXT', 'TEXT'); $this->other_documents->Sortable = FALSE; // Allow sort $this->fields['other_documents'] = &$this->other_documents; // Final_evaluation $this->Final_evaluation = new cField('tospiti', 'tospiti', 'x_Final_evaluation', 'Final_evaluation', '`Final_evaluation`', '`Final_evaluation`', 200, -1, FALSE, '`Final_evaluation`', FALSE, FALSE, FALSE, 'FORMATTED TEXT', 'SELECT'); $this->Final_evaluation->Sortable = FALSE; // Allow sort $this->Final_evaluation->UsePleaseSelect = TRUE; // Use PleaseSelect by default $this->Final_evaluation->PleaseSelectText = $Language->Phrase("PleaseSelect"); // PleaseSelect text $this->fields['Final_evaluation'] = &$this->Final_evaluation; // photo $this->photo = new cField('tospiti', 'tospiti', 'x_photo', 'photo', '`photo`', '`photo`', 201, -1, TRUE, '`photo`', FALSE, FALSE, FALSE, 'IMAGE', 'FILE'); $this->photo->Sortable = FALSE; // Allow sort $this->photo->ImageResize = TRUE; $this->fields['photo'] = &$this->photo; // doc_image $this->doc_image = new cField('tospiti', 'tospiti', 'x_doc_image', 'doc_image', '`doc_image`', '`doc_image`', 201, -1, TRUE, '`doc_image`', FALSE, FALSE, FALSE, 'IMAGE', 'FILE'); $this->doc_image->Sortable = FALSE; // Allow sort $this->doc_image->ImageResize = TRUE; $this->fields['doc_image'] = &$this->doc_image; // Notes $this->Notes = new cField('tospiti', 'tospiti', 'x_Notes', 'Notes', '`Notes`', '`Notes`', 201, -1, FALSE, '`Notes`', FALSE, FALSE, FALSE, 'FORMATTED TEXT', 'TEXTAREA'); $this->Notes->Sortable = FALSE; // Allow sort $this->fields['Notes'] = &$this->Notes; // Interview_1 $this->Interview_1 = new cField('tospiti', 'tospiti', 'x_Interview_1', 'Interview_1', '`Interview_1`', '`Interview_1`', 202, -1, FALSE, '`Interview_1`', FALSE, FALSE, FALSE, 'FORMATTED TEXT', 'CHECKBOX'); $this->Interview_1->Sortable = FALSE; // Allow sort $this->Interview_1->FldDataType = EW_DATATYPE_BOOLEAN; $this->Interview_1->TrueValue = 'Y'; $this->Interview_1->FalseValue = 'N'; $this->Interview_1->OptionCount = 2; $this->fields['Interview_1'] = &$this->Interview_1; // interview1_date $this->interview1_date = new cField('tospiti', 'tospiti', 'x_interview1_date', 'interview1_date', '`interview1_date`', ew_CastDateFieldForLike('`interview1_date`', 0, "DB"), 133, 0, FALSE, '`interview1_date`', FALSE, FALSE, FALSE, 'FORMATTED TEXT', 'TEXT'); $this->interview1_date->Sortable = FALSE; // Allow sort $this->interview1_date->FldDefaultErrMsg = str_replace("%s", $GLOBALS["EW_DATE_FORMAT"], $Language->Phrase("IncorrectDate")); $this->fields['interview1_date'] = &$this->interview1_date; // Interview_2 $this->Interview_2 = new cField('tospiti', 'tospiti', 'x_Interview_2', 'Interview_2', '`Interview_2`', '`Interview_2`', 202, -1, FALSE, '`Interview_2`', FALSE, FALSE, FALSE, 'FORMATTED TEXT', 'CHECKBOX'); $this->Interview_2->Sortable = FALSE; // Allow sort $this->Interview_2->FldDataType = EW_DATATYPE_BOOLEAN; $this->Interview_2->TrueValue = 'Y'; $this->Interview_2->FalseValue = 'N'; $this->Interview_2->OptionCount = 2; $this->fields['Interview_2'] = &$this->Interview_2; // interview_2_date $this->interview_2_date = new cField('tospiti', 'tospiti', 'x_interview_2_date', 'interview_2_date', '`interview_2_date`', ew_CastDateFieldForLike('`interview_2_date`', 0, "DB"), 133, 0, FALSE, '`interview_2_date`', FALSE, FALSE, FALSE, 'FORMATTED TEXT', 'TEXT'); $this->interview_2_date->Sortable = FALSE; // Allow sort $this->interview_2_date->FldDefaultErrMsg = str_replace("%s", $GLOBALS["EW_DATE_FORMAT"], $Language->Phrase("IncorrectDate")); $this->fields['interview_2_date'] = &$this->interview_2_date; // Interview_3 $this->Interview_3 = new cField('tospiti', 'tospiti', 'x_Interview_3', 'Interview_3', '`Interview_3`', '`Interview_3`', 202, -1, FALSE, '`Interview_3`', FALSE, FALSE, FALSE, 'FORMATTED TEXT', 'CHECKBOX'); $this->Interview_3->Sortable = FALSE; // Allow sort $this->Interview_3->FldDataType = EW_DATATYPE_BOOLEAN; $this->Interview_3->TrueValue = 'Y'; $this->Interview_3->FalseValue = 'N'; $this->Interview_3->OptionCount = 2; $this->fields['Interview_3'] = &$this->Interview_3; // interview_3_date $this->interview_3_date = new cField('tospiti', 'tospiti', 'x_interview_3_date', 'interview_3_date', '`interview_3_date`', ew_CastDateFieldForLike('`interview_3_date`', 0, "DB"), 133, 0, FALSE, '`interview_3_date`', FALSE, FALSE, FALSE, 'FORMATTED TEXT', 'TEXT'); $this->interview_3_date->Sortable = FALSE; // Allow sort $this->interview_3_date->FldDefaultErrMsg = str_replace("%s", $GLOBALS["EW_DATE_FORMAT"], $Language->Phrase("IncorrectDate")); $this->fields['interview_3_date'] = &$this->interview_3_date; // Zone_of_Transit $this->Zone_of_Transit = new cField('tospiti', 'tospiti', 'x_Zone_of_Transit', 'Zone_of_Transit', '`Zone_of_Transit`', '`Zone_of_Transit`', 200, -1, FALSE, '`Zone_of_Transit`', FALSE, FALSE, FALSE, 'FORMATTED TEXT', 'TEXT'); $this->Zone_of_Transit->Sortable = FALSE; // Allow sort $this->fields['Zone_of_Transit'] = &$this->Zone_of_Transit; // Travel_number $this->Travel_number = new cField('tospiti', 'tospiti', 'x_Travel_number', 'Travel_number', '`Travel_number`', '`Travel_number`', 200, -1, FALSE, '`Travel_number`', FALSE, FALSE, FALSE, 'FORMATTED TEXT', 'TEXT'); $this->Travel_number->Sortable = TRUE; // Allow sort $this->fields['Travel_number'] = &$this->Travel_number; // Travel_arrival_date $this->Travel_arrival_date = new cField('tospiti', 'tospiti', 'x_Travel_arrival_date', 'Travel_arrival_date', '`Travel_arrival_date`', ew_CastDateFieldForLike('`Travel_arrival_date`', 0, "DB"), 133, 0, FALSE, '`Travel_arrival_date`', FALSE, FALSE, FALSE, 'FORMATTED TEXT', 'TEXT'); $this->Travel_arrival_date->Sortable = FALSE; // Allow sort $this->Travel_arrival_date->FldDefaultErrMsg = str_replace("%s", $GLOBALS["EW_DATE_FORMAT"], $Language->Phrase("IncorrectDate")); $this->fields['Travel_arrival_date'] = &$this->Travel_arrival_date; // Travel_arrival_time $this->Travel_arrival_time = new cField('tospiti', 'tospiti', 'x_Travel_arrival_time', 'Travel_arrival_time', '`Travel_arrival_time`', ew_CastDateFieldForLike('`Travel_arrival_time`', 4, "DB"), 134, 4, FALSE, '`Travel_arrival_time`', FALSE, FALSE, FALSE, 'FORMATTED TEXT', 'TEXT'); $this->Travel_arrival_time->Sortable = FALSE; // Allow sort $this->Travel_arrival_time->FldDefaultErrMsg = str_replace("%s", $GLOBALS["EW_TIME_SEPARATOR"], $Language->Phrase("IncorrectTime")); $this->fields['Travel_arrival_time'] = &$this->Travel_arrival_time; // num_family $this->num_family = new cField('tospiti', 'tospiti', 'x_num_family', 'num_family', '`num_family`', '`num_family`', 3, -1, FALSE, '`num_family`', FALSE, FALSE, FALSE, 'FORMATTED TEXT', 'TEXT'); $this->num_family->Sortable = FALSE; // Allow sort $this->num_family->FldDefaultErrMsg = $Language->Phrase("IncorrectInteger"); $this->fields['num_family'] = &$this->num_family; // speak_ENG $this->speak_ENG = new cField('tospiti', 'tospiti', 'x_speak_ENG', 'speak_ENG', '`speak_ENG`', '`speak_ENG`', 202, -1, FALSE, '`speak_ENG`', FALSE, FALSE, FALSE, 'FORMATTED TEXT', 'CHECKBOX'); $this->speak_ENG->Sortable = FALSE; // Allow sort $this->speak_ENG->FldDataType = EW_DATATYPE_BOOLEAN; $this->speak_ENG->TrueValue = 'Y'; $this->speak_ENG->FalseValue = 'N'; $this->speak_ENG->OptionCount = 2; $this->fields['speak_ENG'] = &$this->speak_ENG; // speak_FRA $this->speak_FRA = new cField('tospiti', 'tospiti', 'x_speak_FRA', 'speak_FRA', '`speak_FRA`', '`speak_FRA`', 202, -1, FALSE, '`speak_FRA`', FALSE, FALSE, FALSE, 'FORMATTED TEXT', 'CHECKBOX'); $this->speak_FRA->Sortable = FALSE; // Allow sort $this->speak_FRA->FldDataType = EW_DATATYPE_BOOLEAN; $this->speak_FRA->TrueValue = 'Y'; $this->speak_FRA->FalseValue = 'N'; $this->speak_FRA->OptionCount = 2; $this->fields['speak_FRA'] = &$this->speak_FRA; // speak_ARA $this->speak_ARA = new cField('tospiti', 'tospiti', 'x_speak_ARA', 'speak_ARA', '`speak_ARA`', '`speak_ARA`', 202, -1, FALSE, '`speak_ARA`', FALSE, FALSE, FALSE, 'FORMATTED TEXT', 'CHECKBOX'); $this->speak_ARA->Sortable = FALSE; // Allow sort $this->speak_ARA->FldDataType = EW_DATATYPE_BOOLEAN; $this->speak_ARA->TrueValue = 'Y'; $this->speak_ARA->FalseValue = 'N'; $this->speak_ARA->OptionCount = 2; $this->fields['speak_ARA'] = &$this->speak_ARA; // speak_ITA $this->speak_ITA = new cField('tospiti', 'tospiti', 'x_speak_ITA', 'speak_ITA', '`speak_ITA`', '`speak_ITA`', 202, -1, FALSE, '`speak_ITA`', FALSE, FALSE, FALSE, 'FORMATTED TEXT', 'CHECKBOX'); $this->speak_ITA->Sortable = FALSE; // Allow sort $this->speak_ITA->FldDataType = EW_DATATYPE_BOOLEAN; $this->speak_ITA->TrueValue = 'Y'; $this->speak_ITA->FalseValue = 'N'; $this->speak_ITA->OptionCount = 2; $this->fields['speak_ITA'] = &$this->speak_ITA; // lives_with $this->lives_with = new cField('tospiti', 'tospiti', 'x_lives_with', 'lives_with', '`lives_with`', '`lives_with`', 200, -1, FALSE, '`lives_with`', FALSE, FALSE, FALSE, 'FORMATTED TEXT', 'TEXT'); $this->lives_with->Sortable = FALSE; // Allow sort $this->fields['lives_with'] = &$this->lives_with; // family_know $this->family_know = new cField('tospiti', 'tospiti', 'x_family_know', 'family_know', '`family_know`', '`family_know`', 202, -1, FALSE, '`family_know`', FALSE, FALSE, FALSE, 'FORMATTED TEXT', 'CHECKBOX'); $this->family_know->Sortable = FALSE; // Allow sort $this->family_know->FldDataType = EW_DATATYPE_BOOLEAN; $this->family_know->TrueValue = 'Y'; $this->family_know->FalseValue = 'N'; $this->family_know->OptionCount = 2; $this->fields['family_know'] = &$this->family_know; // date_of_entry_transit $this->date_of_entry_transit = new cField('tospiti', 'tospiti', 'x_date_of_entry_transit', 'date_of_entry_transit', '`date_of_entry_transit`', ew_CastDateFieldForLike('`date_of_entry_transit`', 0, "DB"), 133, 0, FALSE, '`date_of_entry_transit`', FALSE, FALSE, FALSE, 'FORMATTED TEXT', 'TEXT'); $this->date_of_entry_transit->Sortable = FALSE; // Allow sort $this->date_of_entry_transit->FldDefaultErrMsg = str_replace("%s", $GLOBALS["EW_DATE_FORMAT"], $Language->Phrase("IncorrectDate")); $this->fields['date_of_entry_transit'] = &$this->date_of_entry_transit; // marital_status $this->marital_status = new cField('tospiti', 'tospiti', 'x_marital_status', 'marital_status', '`marital_status`', '`marital_status`', 200, -1, FALSE, '`marital_status`', FALSE, FALSE, FALSE, 'FORMATTED TEXT', 'TEXT'); $this->marital_status->Sortable = FALSE; // Allow sort $this->fields['marital_status'] = &$this->marital_status; // consort_id $this->consort_id = new cField('tospiti', 'tospiti', 'x_consort_id', 'consort_id', '`consort_id`', '`consort_id`', 3, -1, FALSE, '`consort_id`', FALSE, FALSE, FALSE, 'FORMATTED TEXT', 'TEXT'); $this->consort_id->Sortable = FALSE; // Allow sort $this->consort_id->FldDefaultErrMsg = $Language->Phrase("IncorrectInteger"); $this->fields['consort_id'] = &$this->consort_id; // consort_info $this->consort_info = new cField('tospiti', 'tospiti', 'x_consort_info', 'consort_info', '`consort_info`', '`consort_info`', 201, -1, FALSE, '`consort_info`', FALSE, FALSE, FALSE, 'FORMATTED TEXT', 'TEXTAREA'); $this->consort_info->Sortable = FALSE; // Allow sort $this->fields['consort_info'] = &$this->consort_info; // other_fam_in_italy $this->other_fam_in_italy = new cField('tospiti', 'tospiti', 'x_other_fam_in_italy', 'other_fam_in_italy', '`other_fam_in_italy`', '`other_fam_in_italy`', 201, -1, FALSE, '`other_fam_in_italy`', FALSE, FALSE, FALSE, 'FORMATTED TEXT', 'TEXTAREA'); $this->other_fam_in_italy->Sortable = FALSE; // Allow sort $this->fields['other_fam_in_italy'] = &$this->other_fam_in_italy; // other_fam_in_europe $this->other_fam_in_europe = new cField('tospiti', 'tospiti', 'x_other_fam_in_europe', 'other_fam_in_europe', '`other_fam_in_europe`', '`other_fam_in_europe`', 201, -1, FALSE, '`other_fam_in_europe`', FALSE, FALSE, FALSE, 'FORMATTED TEXT', 'TEXTAREA'); $this->other_fam_in_europe->Sortable = FALSE; // Allow sort $this->fields['other_fam_in_europe'] = &$this->other_fam_in_europe; // where_lived $this->where_lived = new cField('tospiti', 'tospiti', 'x_where_lived', 'where_lived', '`where_lived`', '`where_lived`', 201, -1, FALSE, '`where_lived`', FALSE, FALSE, FALSE, 'FORMATTED TEXT', 'TEXTAREA'); $this->where_lived->Sortable = FALSE; // Allow sort $this->fields['where_lived'] = &$this->where_lived; // medical_situation $this->medical_situation = new cField('tospiti', 'tospiti', 'x_medical_situation', 'medical_situation', '`medical_situation`', '`medical_situation`', 201, -1, FALSE, '`medical_situation`', FALSE, FALSE, FALSE, 'FORMATTED TEXT', 'TEXTAREA'); $this->medical_situation->Sortable = FALSE; // Allow sort $this->fields['medical_situation'] = &$this->medical_situation; // social_situation $this->social_situation = new cField('tospiti', 'tospiti', 'x_social_situation', 'social_situation', '`social_situation`', '`social_situation`', 201, -1, FALSE, '`social_situation`', FALSE, FALSE, FALSE, 'FORMATTED TEXT', 'TEXTAREA'); $this->social_situation->Sortable = FALSE; // Allow sort $this->fields['social_situation'] = &$this->social_situation; // abuse_suffered $this->abuse_suffered = new cField('tospiti', 'tospiti', 'x_abuse_suffered', 'abuse_suffered', '`abuse_suffered`', '`abuse_suffered`', 202, -1, FALSE, '`abuse_suffered`', FALSE, FALSE, FALSE, 'FORMATTED TEXT', 'CHECKBOX'); $this->abuse_suffered->Sortable = FALSE; // Allow sort $this->abuse_suffered->FldDataType = EW_DATATYPE_BOOLEAN; $this->abuse_suffered->TrueValue = 'Y'; $this->abuse_suffered->FalseValue = 'N'; $this->abuse_suffered->OptionCount = 2; $this->fields['abuse_suffered'] = &$this->abuse_suffered; // abuse_description $this->abuse_description = new cField('tospiti', 'tospiti', 'x_abuse_description', 'abuse_description', '`abuse_description`', '`abuse_description`', 201, -1, FALSE, '`abuse_description`', FALSE, FALSE, FALSE, 'FORMATTED TEXT', 'TEXTAREA'); $this->abuse_description->Sortable = FALSE; // Allow sort $this->fields['abuse_description'] = &$this->abuse_description; // work_done $this->work_done = new cField('tospiti', 'tospiti', 'x_work_done', 'work_done', '`work_done`', '`work_done`', 201, -1, FALSE, '`work_done`', FALSE, FALSE, FALSE, 'FORMATTED TEXT', 'TEXTAREA'); $this->work_done->Sortable = FALSE; // Allow sort $this->fields['work_done'] = &$this->work_done; // military_service $this->military_service = new cField('tospiti', 'tospiti', 'x_military_service', 'military_service', '`military_service`', '`military_service`', 200, -1, FALSE, '`military_service`', FALSE, FALSE, FALSE, 'FORMATTED TEXT', 'TEXT'); $this->military_service->Sortable = FALSE; // Allow sort $this->fields['military_service'] = &$this->military_service; // itinerary $this->itinerary = new cField('tospiti', 'tospiti', 'x_itinerary', 'itinerary', '`itinerary`', '`itinerary`', 201, -1, FALSE, '`itinerary`', FALSE, FALSE, FALSE, 'FORMATTED TEXT', 'TEXTAREA'); $this->itinerary->Sortable = FALSE; // Allow sort $this->fields['itinerary'] = &$this->itinerary; // convictions $this->convictions = new cField('tospiti', 'tospiti', 'x_convictions', 'convictions', '`convictions`', '`convictions`', 202, -1, FALSE, '`convictions`', FALSE, FALSE, FALSE, 'FORMATTED TEXT', 'CHECKBOX'); $this->convictions->Sortable = FALSE; // Allow sort $this->convictions->FldDataType = EW_DATATYPE_BOOLEAN; $this->convictions->TrueValue = 'Y'; $this->convictions->FalseValue = 'N'; $this->convictions->OptionCount = 2; $this->fields['convictions'] = &$this->convictions; // requested_asylum $this->requested_asylum = new cField('tospiti', 'tospiti', 'x_requested_asylum', 'requested_asylum', '`requested_asylum`', '`requested_asylum`', 201, -1, FALSE, '`requested_asylum`', FALSE, FALSE, FALSE, 'FORMATTED TEXT', 'TEXTAREA'); $this->requested_asylum->Sortable = FALSE; // Allow sort $this->fields['requested_asylum'] = &$this->requested_asylum; // resettlement_application $this->resettlement_application = new cField('tospiti', 'tospiti', 'x_resettlement_application', 'resettlement_application', '`resettlement_application`', '`resettlement_application`', 202, -1, FALSE, '`resettlement_application`', FALSE, FALSE, FALSE, 'FORMATTED TEXT', 'CHECKBOX'); $this->resettlement_application->Sortable = FALSE; // Allow sort $this->resettlement_application->FldDataType = EW_DATATYPE_BOOLEAN; $this->resettlement_application->TrueValue = 'Y'; $this->resettlement_application->FalseValue = 'N'; $this->resettlement_application->OptionCount = 2; $this->fields['resettlement_application'] = &$this->resettlement_application; // resettlement_country $this->resettlement_country = new cField('tospiti', 'tospiti', 'x_resettlement_country', 'resettlement_country', '`resettlement_country`', '`resettlement_country`', 200, -1, FALSE, '`resettlement_country`', FALSE, FALSE, FALSE, 'FORMATTED TEXT', 'TEXT'); $this->resettlement_country->Sortable = FALSE; // Allow sort $this->fields['resettlement_country'] = &$this->resettlement_country; // reunion_application $this->reunion_application = new cField('tospiti', 'tospiti', 'x_reunion_application', 'reunion_application', '`reunion_application`', '`reunion_application`', 202, -1, FALSE, '`reunion_application`', FALSE, FALSE, FALSE, 'FORMATTED TEXT', 'CHECKBOX'); $this->reunion_application->Sortable = FALSE; // Allow sort $this->reunion_application->FldDataType = EW_DATATYPE_BOOLEAN; $this->reunion_application->TrueValue = 'Y'; $this->reunion_application->FalseValue = 'N'; $this->reunion_application->OptionCount = 2; $this->fields['reunion_application'] = &$this->reunion_application; // reunion_country $this->reunion_country = new cField('tospiti', 'tospiti', 'x_reunion_country', 'reunion_country', '`reunion_country`', '`reunion_country`', 200, -1, FALSE, '`reunion_country`', FALSE, FALSE, FALSE, 'FORMATTED TEXT', 'TEXT'); $this->reunion_country->Sortable = FALSE; // Allow sort $this->fields['reunion_country'] = &$this->reunion_country; // belongs_to_organization $this->belongs_to_organization = new cField('tospiti', 'tospiti', 'x_belongs_to_organization', 'belongs_to_organization', '`belongs_to_organization`', '`belongs_to_organization`', 202, -1, FALSE, '`belongs_to_organization`', FALSE, FALSE, FALSE, 'FORMATTED TEXT', 'CHECKBOX'); $this->belongs_to_organization->Sortable = FALSE; // Allow sort $this->belongs_to_organization->FldDataType = EW_DATATYPE_BOOLEAN; $this->belongs_to_organization->TrueValue = 'Y'; $this->belongs_to_organization->FalseValue = 'N'; $this->belongs_to_organization->OptionCount = 2; $this->fields['belongs_to_organization'] = &$this->belongs_to_organization; // organizations $this->organizations = new cField('tospiti', 'tospiti', 'x_organizations', 'organizations', '`organizations`', '`organizations`', 200, -1, FALSE, '`organizations`', FALSE, FALSE, FALSE, 'FORMATTED TEXT', 'TEXT'); $this->organizations->Sortable = FALSE; // Allow sort $this->fields['organizations'] = &$this->organizations; // presentations $this->presentations = new cField('tospiti', 'tospiti', 'x_presentations', 'presentations', '`presentations`', '`presentations`', 201, -1, FALSE, '`presentations`', FALSE, FALSE, FALSE, 'FORMATTED TEXT', 'TEXTAREA'); $this->presentations->Sortable = FALSE; // Allow sort $this->fields['presentations'] = &$this->presentations; // report $this->report = new cField('tospiti', 'tospiti', 'x_report', 'report', '`report`', '`report`', 201, -1, FALSE, '`report`', FALSE, FALSE, FALSE, 'FORMATTED TEXT', 'TEXTAREA'); $this->report->Sortable = FALSE; // Allow sort $this->fields['report'] = &$this->report; } // Set Field Visibility function SetFieldVisibility($fldparm) { global $Security; return $this->$fldparm->Visible; // Returns original value } // Single column sort function UpdateSort(&$ofld) { if ($this->CurrentOrder == $ofld->FldName) { $sSortField = $ofld->FldExpression; $sLastSort = $ofld->getSort(); if ($this->CurrentOrderType == "ASC" || $this->CurrentOrderType == "DESC") { $sThisSort = $this->CurrentOrderType; } else { $sThisSort = ($sLastSort == "ASC") ? "DESC" : "ASC"; } $ofld->setSort($sThisSort); $this->setSessionOrderBy($sSortField . " " . $sThisSort); // Save to Session $sSortFieldList = ($ofld->FldVirtualExpression <> "") ? $ofld->FldVirtualExpression : $sSortField; $this->setSessionOrderByList($sSortFieldList . " " . $sThisSort); // Save to Session } else { $ofld->setSort(""); } } // Session ORDER BY for List page function getSessionOrderByList() { return @$_SESSION[EW_PROJECT_NAME . "_" . $this->TableVar . "_" . EW_TABLE_ORDER_BY_LIST]; } function setSessionOrderByList($v) { $_SESSION[EW_PROJECT_NAME . "_" . $this->TableVar . "_" . EW_TABLE_ORDER_BY_LIST] = $v; } // Current detail table name function getCurrentDetailTable() { return @$_SESSION[EW_PROJECT_NAME . "_" . $this->TableVar . "_" . EW_TABLE_DETAIL_TABLE]; } function setCurrentDetailTable($v) { $_SESSION[EW_PROJECT_NAME . "_" . $this->TableVar . "_" . EW_TABLE_DETAIL_TABLE] = $v; } // Get detail url function GetDetailUrl() { // Detail url $sDetailUrl = ""; if ($this->getCurrentDetailTable() == "tassigment") { $sDetailUrl = $GLOBALS["tassigment"]->GetListUrl() . "?" . EW_TABLE_SHOW_MASTER . "=" . $this->TableVar; $sDetailUrl .= "&fk_idSeeker=" . urlencode($this->idSeeker->CurrentValue); } if ($sDetailUrl == "") { $sDetailUrl = "tospitilist.php"; } return $sDetailUrl; } // Table level SQL var $_SqlFrom = ""; function getSqlFrom() { // From return ($this->_SqlFrom <> "") ? $this->_SqlFrom : "`tospiti`"; } function SqlFrom() { // For backward compatibility return $this->getSqlFrom(); } function setSqlFrom($v) { $this->_SqlFrom = $v; } var $_SqlSelect = ""; function getSqlSelect() { // Select return ($this->_SqlSelect <> "") ? $this->_SqlSelect : "SELECT * FROM " . $this->getSqlFrom(); } function SqlSelect() { // For backward compatibility return $this->getSqlSelect(); } function setSqlSelect($v) { $this->_SqlSelect = $v; } var $_SqlSelectList = ""; function getSqlSelectList() { // Select for List page $select = ""; global $gsLanguage; switch ($gsLanguage) { case "it": $select = "SELECT * FROM (" . "SELECT *, (SELECT `desc_it` FROM `tnations` `EW_TMP_LOOKUPTABLE` WHERE `EW_TMP_LOOKUPTABLE`.`id_nation` = `tospiti`.`Nationality` LIMIT 1) AS `EV__Nationality`, (SELECT `desc_it` FROM `tnations` `EW_TMP_LOOKUPTABLE` WHERE `EW_TMP_LOOKUPTABLE`.`id_nation` = `tospiti`.`Citizenship` LIMIT 1) AS `EV__Citizenship`, (SELECT `desc_it` FROM `tnations` `EW_TMP_LOOKUPTABLE` WHERE `EW_TMP_LOOKUPTABLE`.`id_nation` = `tospiti`.`Place_of_Residence` LIMIT 1) AS `EV__Place_of_Residence`, (SELECT `desc_it` FROM `tnations` `EW_TMP_LOOKUPTABLE` WHERE `EW_TMP_LOOKUPTABLE`.`id_nation` = `tospiti`.`Place_of_Transit` LIMIT 1) AS `EV__Place_of_Transit`, (SELECT CONCAT(`Name`,'" . ew_ValueSeparator(1, $this->Householder_id) . "',`Surname`,'" . ew_ValueSeparator(2, $this->Householder_id) . "',`BirthDate`,'" . ew_ValueSeparator(3, $this->Householder_id) . "',`BirthPlace`) FROM `vhouseholders` `EW_TMP_LOOKUPTABLE` WHERE `EW_TMP_LOOKUPTABLE`.`idSeeker` = `tospiti`.`Householder_id` LIMIT 1) AS `EV__Householder_id`, (SELECT `desc_it` FROM `tnations` `EW_TMP_LOOKUPTABLE` WHERE `EW_TMP_LOOKUPTABLE`.`id_nation` = `tospiti`.`Document_nationality` LIMIT 1) AS `EV__Document_nationality` FROM `tospiti`" . ") `EW_TMP_TABLE`"; break; default: $select = "SELECT * FROM (" . "SELECT *, (SELECT `desc_en` FROM `tnations` `EW_TMP_LOOKUPTABLE` WHERE `EW_TMP_LOOKUPTABLE`.`id_nation` = `tospiti`.`Nationality` LIMIT 1) AS `EV__Nationality`, (SELECT `desc_en` FROM `tnations` `EW_TMP_LOOKUPTABLE` WHERE `EW_TMP_LOOKUPTABLE`.`id_nation` = `tospiti`.`Citizenship` LIMIT 1) AS `EV__Citizenship`, (SELECT `desc_en` FROM `tnations` `EW_TMP_LOOKUPTABLE` WHERE `EW_TMP_LOOKUPTABLE`.`id_nation` = `tospiti`.`Place_of_Residence` LIMIT 1) AS `EV__Place_of_Residence`, (SELECT `desc_en` FROM `tnations` `EW_TMP_LOOKUPTABLE` WHERE `EW_TMP_LOOKUPTABLE`.`id_nation` = `tospiti`.`Place_of_Transit` LIMIT 1) AS `EV__Place_of_Transit`, (SELECT CONCAT(`Name`,'" . ew_ValueSeparator(1, $this->Householder_id) . "',`Surname`,'" . ew_ValueSeparator(2, $this->Householder_id) . "',`BirthDate`,'" . ew_ValueSeparator(3, $this->Householder_id) . "',`BirthPlace`) FROM `vhouseholders` `EW_TMP_LOOKUPTABLE` WHERE `EW_TMP_LOOKUPTABLE`.`idSeeker` = `tospiti`.`Householder_id` LIMIT 1) AS `EV__Householder_id`, (SELECT `desc_en` FROM `tnations` `EW_TMP_LOOKUPTABLE` WHERE `EW_TMP_LOOKUPTABLE`.`id_nation` = `tospiti`.`Document_nationality` LIMIT 1) AS `EV__Document_nationality` FROM `tospiti`" . ") `EW_TMP_TABLE`"; break; } return ($this->_SqlSelectList <> "") ? $this->_SqlSelectList : $select; } function SqlSelectList() { // For backward compatibility return $this->getSqlSelectList(); } function setSqlSelectList($v) { $this->_SqlSelectList = $v; } var $_SqlWhere = ""; function getSqlWhere() { // Where $sWhere = ($this->_SqlWhere <> "") ? $this->_SqlWhere : ""; $this->TableFilter = ""; ew_AddFilter($sWhere, $this->TableFilter); return $sWhere; } function SqlWhere() { // For backward compatibility return $this->getSqlWhere(); } function setSqlWhere($v) { $this->_SqlWhere = $v; } var $_SqlGroupBy = ""; function getSqlGroupBy() { // Group By return ($this->_SqlGroupBy <> "") ? $this->_SqlGroupBy : ""; } function SqlGroupBy() { // For backward compatibility return $this->getSqlGroupBy(); } function setSqlGroupBy($v) { $this->_SqlGroupBy = $v; } var $_SqlHaving = ""; function getSqlHaving() { // Having return ($this->_SqlHaving <> "") ? $this->_SqlHaving : ""; } function SqlHaving() { // For backward compatibility return $this->getSqlHaving(); } function setSqlHaving($v) { $this->_SqlHaving = $v; } var $_SqlOrderBy = ""; function getSqlOrderBy() { // Order By return ($this->_SqlOrderBy <> "") ? $this->_SqlOrderBy : ""; } function SqlOrderBy() { // For backward compatibility return $this->getSqlOrderBy(); } function setSqlOrderBy($v) { $this->_SqlOrderBy = $v; } // Apply User ID filters function ApplyUserIDFilters($sFilter) { return $sFilter; } // Check if User ID security allows view all function UserIDAllow($id = "") { $allow = EW_USER_ID_ALLOW; switch ($id) { case "add": case "copy": case "gridadd": case "register": case "addopt": return (($allow & 1) == 1); case "edit": case "gridedit": case "update": case "changepwd": case "forgotpwd": return (($allow & 4) == 4); case "delete": return (($allow & 2) == 2); case "view": return (($allow & 32) == 32); case "search": return (($allow & 64) == 64); default: return (($allow & 8) == 8); } } // Get SQL function GetSQL($where, $orderby) { return ew_BuildSelectSql($this->getSqlSelect(), $this->getSqlWhere(), $this->getSqlGroupBy(), $this->getSqlHaving(), $this->getSqlOrderBy(), $where, $orderby); } // Table SQL function SQL() { $sFilter = $this->CurrentFilter; $sFilter = $this->ApplyUserIDFilters($sFilter); $sSort = $this->getSessionOrderBy(); return ew_BuildSelectSql($this->getSqlSelect(), $this->getSqlWhere(), $this->getSqlGroupBy(), $this->getSqlHaving(), $this->getSqlOrderBy(), $sFilter, $sSort); } // Table SQL with List page filter function SelectSQL() { $sFilter = $this->getSessionWhere(); ew_AddFilter($sFilter, $this->CurrentFilter); $sFilter = $this->ApplyUserIDFilters($sFilter); $this->Recordset_Selecting($sFilter); if ($this->UseVirtualFields()) { $sSort = $this->getSessionOrderByList(); return ew_BuildSelectSql($this->getSqlSelectList(), $this->getSqlWhere(), $this->getSqlGroupBy(), $this->getSqlHaving(), $this->getSqlOrderBy(), $sFilter, $sSort); } else { $sSort = $this->getSessionOrderBy(); return ew_BuildSelectSql($this->getSqlSelect(), $this->getSqlWhere(), $this->getSqlGroupBy(), $this->getSqlHaving(), $this->getSqlOrderBy(), $sFilter, $sSort); } } // Get ORDER BY clause function GetOrderBy() { $sSort = ($this->UseVirtualFields()) ? $this->getSessionOrderByList() : $this->getSessionOrderBy(); return ew_BuildSelectSql("", "", "", "", $this->getSqlOrderBy(), "", $sSort); } // Check if virtual fields is used in SQL function UseVirtualFields() { $sWhere = $this->getSessionWhere(); $sOrderBy = $this->getSessionOrderByList(); if ($sWhere <> "") $sWhere = " " . str_replace(array("(",")"), array("",""), $sWhere) . " "; if ($sOrderBy <> "") $sOrderBy = " " . str_replace(array("(",")"), array("",""), $sOrderBy) . " "; if ($this->BasicSearch->getKeyword() <> "") return TRUE; if ($this->Nationality->AdvancedSearch->SearchValue <> "" || $this->Nationality->AdvancedSearch->SearchValue2 <> "" || strpos($sWhere, " " . $this->Nationality->FldVirtualExpression . " ") !== FALSE) return TRUE; if (strpos($sOrderBy, " " . $this->Nationality->FldVirtualExpression . " ") !== FALSE) return TRUE; if ($this->Citizenship->AdvancedSearch->SearchValue <> "" || $this->Citizenship->AdvancedSearch->SearchValue2 <> "" || strpos($sWhere, " " . $this->Citizenship->FldVirtualExpression . " ") !== FALSE) return TRUE; if (strpos($sOrderBy, " " . $this->Citizenship->FldVirtualExpression . " ") !== FALSE) return TRUE; if ($this->Place_of_Residence->AdvancedSearch->SearchValue <> "" || $this->Place_of_Residence->AdvancedSearch->SearchValue2 <> "" || strpos($sWhere, " " . $this->Place_of_Residence->FldVirtualExpression . " ") !== FALSE) return TRUE; if (strpos($sOrderBy, " " . $this->Place_of_Residence->FldVirtualExpression . " ") !== FALSE) return TRUE; if ($this->Place_of_Transit->AdvancedSearch->SearchValue <> "" || $this->Place_of_Transit->AdvancedSearch->SearchValue2 <> "" || strpos($sWhere, " " . $this->Place_of_Transit->FldVirtualExpression . " ") !== FALSE) return TRUE; if (strpos($sOrderBy, " " . $this->Place_of_Transit->FldVirtualExpression . " ") !== FALSE) return TRUE; if ($this->Householder_id->AdvancedSearch->SearchValue <> "" || $this->Householder_id->AdvancedSearch->SearchValue2 <> "" || strpos($sWhere, " " . $this->Householder_id->FldVirtualExpression . " ") !== FALSE) return TRUE; if (strpos($sOrderBy, " " . $this->Householder_id->FldVirtualExpression . " ") !== FALSE) return TRUE; if ($this->Document_nationality->AdvancedSearch->SearchValue <> "" || $this->Document_nationality->AdvancedSearch->SearchValue2 <> "" || strpos($sWhere, " " . $this->Document_nationality->FldVirtualExpression . " ") !== FALSE) return TRUE; if (strpos($sOrderBy, " " . $this->Document_nationality->FldVirtualExpression . " ") !== FALSE) return TRUE; return FALSE; } // Try to get record count function TryGetRecordCount($sSql) { $cnt = -1; if (($this->TableType == 'TABLE' || $this->TableType == 'VIEW' || $this->TableType == 'LINKTABLE') && preg_match("/^SELECT \* FROM/i", $sSql)) { $sSql = "SELECT COUNT(*) FROM" . preg_replace('/^SELECT\s([\s\S]+)?\*\sFROM/i', "", $sSql); $sOrderBy = $this->GetOrderBy(); if (substr($sSql, strlen($sOrderBy) * -1) == $sOrderBy) $sSql = substr($sSql, 0, strlen($sSql) - strlen($sOrderBy)); // Remove ORDER BY clause } else { $sSql = "SELECT COUNT(*) FROM (" . $sSql . ") EW_COUNT_TABLE"; } $conn = &$this->Connection(); if ($rs = $conn->Execute($sSql)) { if (!$rs->EOF && $rs->FieldCount() > 0) { $cnt = $rs->fields[0]; $rs->Close(); } } return intval($cnt); } // Get record count based on filter (for detail record count in master table pages) function LoadRecordCount($sFilter) { $origFilter = $this->CurrentFilter; $this->CurrentFilter = $sFilter; $this->Recordset_Selecting($this->CurrentFilter); //$sSql = $this->SQL(); $sSql = $this->GetSQL($this->CurrentFilter, ""); $cnt = $this->TryGetRecordCount($sSql); if ($cnt == -1) { if ($rs = $this->LoadRs($this->CurrentFilter)) { $cnt = $rs->RecordCount(); $rs->Close(); } } $this->CurrentFilter = $origFilter; return intval($cnt); } // Get record count (for current List page) function SelectRecordCount() { $sSql = $this->SelectSQL(); $cnt = $this->TryGetRecordCount($sSql); if ($cnt == -1) { $conn = &$this->Connection(); if ($rs = $conn->Execute($sSql)) { $cnt = $rs->RecordCount(); $rs->Close(); } } return intval($cnt); } // INSERT statement function InsertSQL(&$rs) { $names = ""; $values = ""; foreach ($rs as $name => $value) { if (!isset($this->fields[$name]) || $this->fields[$name]->FldIsCustom) continue; $names .= $this->fields[$name]->FldExpression . ","; $values .= ew_QuotedValue($value, $this->fields[$name]->FldDataType, $this->DBID) . ","; } while (substr($names, -1) == ",") $names = substr($names, 0, -1); while (substr($values, -1) == ",") $values = substr($values, 0, -1); return "INSERT INTO " . $this->UpdateTable . " ($names) VALUES ($values)"; } // Insert function Insert(&$rs) { $conn = &$this->Connection(); $bInsert = $conn->Execute($this->InsertSQL($rs)); if ($bInsert) { // Get insert id if necessary $this->idSeeker->setDbValue($conn->Insert_ID()); $rs['idSeeker'] = $this->idSeeker->DbValue; } return $bInsert; } // UPDATE statement function UpdateSQL(&$rs, $where = "", $curfilter = TRUE) { $sql = "UPDATE " . $this->UpdateTable . " SET "; foreach ($rs as $name => $value) { if (!isset($this->fields[$name]) || $this->fields[$name]->FldIsCustom) continue; $sql .= $this->fields[$name]->FldExpression . "="; $sql .= ew_QuotedValue($value, $this->fields[$name]->FldDataType, $this->DBID) . ","; } while (substr($sql, -1) == ",") $sql = substr($sql, 0, -1); $filter = ($curfilter) ? $this->CurrentFilter : ""; if (is_array($where)) $where = $this->ArrayToFilter($where); ew_AddFilter($filter, $where); if ($filter <> "") $sql .= " WHERE " . $filter; return $sql; } // Update function Update(&$rs, $where = "", $rsold = NULL, $curfilter = TRUE) { $conn = &$this->Connection(); $bUpdate = $conn->Execute($this->UpdateSQL($rs, $where, $curfilter)); return $bUpdate; } // DELETE statement function DeleteSQL(&$rs, $where = "", $curfilter = TRUE) { $sql = "DELETE FROM " . $this->UpdateTable . " WHERE "; if (is_array($where)) $where = $this->ArrayToFilter($where); if ($rs) { if (array_key_exists('idSeeker', $rs)) ew_AddFilter($where, ew_QuotedName('idSeeker', $this->DBID) . '=' . ew_QuotedValue($rs['idSeeker'], $this->idSeeker->FldDataType, $this->DBID)); } $filter = ($curfilter) ? $this->CurrentFilter : ""; ew_AddFilter($filter, $where); if ($filter <> "") $sql .= $filter; else $sql .= "0=1"; // Avoid delete return $sql; } // Delete function Delete(&$rs, $where = "", $curfilter = TRUE) { $conn = &$this->Connection(); // Cascade delete detail table 'tassigment' if (!isset($GLOBALS["tassigment"])) $GLOBALS["tassigment"] = new ctassigment(); $rscascade = $GLOBALS["tassigment"]->LoadRs("`idkSeeker` = " . ew_QuotedValue($rs['idSeeker'], EW_DATATYPE_NUMBER, "DB")); while ($rscascade && !$rscascade->EOF) { $GLOBALS["tassigment"]->Delete($rscascade->fields); $rscascade->MoveNext(); } $bDelete = $conn->Execute($this->DeleteSQL($rs, $where, $curfilter)); return $bDelete; } // Key filter WHERE clause function SqlKeyFilter() { return "`idSeeker` = @idSeeker@"; } // Key filter function KeyFilter() { $sKeyFilter = $this->SqlKeyFilter(); if (!is_numeric($this->idSeeker->CurrentValue)) $sKeyFilter = "0=1"; // Invalid key $sKeyFilter = str_replace("@idSeeker@", ew_AdjustSql($this->idSeeker->CurrentValue, $this->DBID), $sKeyFilter); // Replace key value return $sKeyFilter; } // Return page URL function getReturnUrl() { $name = EW_PROJECT_NAME . "_" . $this->TableVar . "_" . EW_TABLE_RETURN_URL; // Get referer URL automatically if (ew_ServerVar("HTTP_REFERER") <> "" && ew_ReferPage() <> ew_CurrentPage() && ew_ReferPage() <> "login.php") // Referer not same page or login page $_SESSION[$name] = ew_ServerVar("HTTP_REFERER"); // Save to Session if (@$_SESSION[$name] <> "") { return $_SESSION[$name]; } else { return "tospitilist.php"; } } function setReturnUrl($v) { $_SESSION[EW_PROJECT_NAME . "_" . $this->TableVar . "_" . EW_TABLE_RETURN_URL] = $v; } // List URL function GetListUrl() { return "tospitilist.php"; } // View URL function GetViewUrl($parm = "") { if ($parm <> "") $url = $this->KeyUrl("tospitiview.php", $this->UrlParm($parm)); else $url = $this->KeyUrl("tospitiview.php", $this->UrlParm(EW_TABLE_SHOW_DETAIL . "=")); return $this->AddMasterUrl($url); } // Add URL function GetAddUrl($parm = "") { if ($parm <> "") $url = "tospitiadd.php?" . $this->UrlParm($parm); else $url = "tospitiadd.php"; return $this->AddMasterUrl($url); } // Edit URL function GetEditUrl($parm = "") { if ($parm <> "") $url = $this->KeyUrl("tospitiedit.php", $this->UrlParm($parm)); else $url = $this->KeyUrl("tospitiedit.php", $this->UrlParm(EW_TABLE_SHOW_DETAIL . "=")); return $this->AddMasterUrl($url); } // Inline edit URL function GetInlineEditUrl() { $url = $this->KeyUrl(ew_CurrentPage(), $this->UrlParm("a=edit")); return $this->AddMasterUrl($url); } // Copy URL function GetCopyUrl($parm = "") { if ($parm <> "") $url = $this->KeyUrl("tospitiadd.php", $this->UrlParm($parm)); else $url = $this->KeyUrl("tospitiadd.php", $this->UrlParm(EW_TABLE_SHOW_DETAIL . "=")); return $this->AddMasterUrl($url); } // Inline copy URL function GetInlineCopyUrl() { $url = $this->KeyUrl(ew_CurrentPage(), $this->UrlParm("a=copy")); return $this->AddMasterUrl($url); } // Delete URL function GetDeleteUrl() { return $this->KeyUrl("tospitidelete.php", $this->UrlParm()); } // Add master url function AddMasterUrl($url) { return $url; } function KeyToJson() { $json = ""; $json .= "idSeeker:" . ew_VarToJson($this->idSeeker->CurrentValue, "number", "'"); return "{" . $json . "}"; } // Add key value to URL function KeyUrl($url, $parm = "") { $sUrl = $url . "?"; if ($parm <> "") $sUrl .= $parm . "&"; if (!is_null($this->idSeeker->CurrentValue)) { $sUrl .= "idSeeker=" . urlencode($this->idSeeker->CurrentValue); } else { return "javascript:ew_Alert(ewLanguage.Phrase('InvalidRecord'));"; } return $sUrl; } // Sort URL function SortUrl(&$fld) { if ($this->CurrentAction <> "" || $this->Export <> "" || in_array($fld->FldType, array(128, 204, 205))) { // Unsortable data type return ""; } elseif ($fld->Sortable) { $sUrlParm = $this->UrlParm("order=" . urlencode($fld->FldName) . "&ordertype=" . $fld->ReverseSort()); return $this->AddMasterUrl(ew_CurrentPage() . "?" . $sUrlParm); } else { return ""; } } // Get record keys from $_POST/$_GET/$_SESSION function GetRecordKeys() { global $EW_COMPOSITE_KEY_SEPARATOR; $arKeys = array(); $arKey = array(); if (isset($_POST["key_m"])) { $arKeys = ew_StripSlashes($_POST["key_m"]); $cnt = count($arKeys); } elseif (isset($_GET["key_m"])) { $arKeys = ew_StripSlashes($_GET["key_m"]); $cnt = count($arKeys); } elseif (!empty($_GET) || !empty($_POST)) { $isPost = ew_IsHttpPost(); if ($isPost && isset($_POST["idSeeker"])) $arKeys[] = ew_StripSlashes($_POST["idSeeker"]); elseif (isset($_GET["idSeeker"])) $arKeys[] = ew_StripSlashes($_GET["idSeeker"]); else $arKeys = NULL; // Do not setup //return $arKeys; // Do not return yet, so the values will also be checked by the following code } // Check keys $ar = array(); if (is_array($arKeys)) { foreach ($arKeys as $key) { if (!is_numeric($key)) continue; $ar[] = $key; } } return $ar; } // Get key filter function GetKeyFilter() { $arKeys = $this->GetRecordKeys(); $sKeyFilter = ""; foreach ($arKeys as $key) { if ($sKeyFilter <> "") $sKeyFilter .= " OR "; $this->idSeeker->CurrentValue = $key; $sKeyFilter .= "(" . $this->KeyFilter() . ")"; } return $sKeyFilter; } // Load rows based on filter function &LoadRs($sFilter) { // Set up filter (SQL WHERE clause) and get return SQL //$this->CurrentFilter = $sFilter; //$sSql = $this->SQL(); $sSql = $this->GetSQL($sFilter, ""); $conn = &$this->Connection(); $rs = $conn->Execute($sSql); return $rs; } // Load row values from recordset function LoadListRowValues(&$rs) { $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')); $this->Citizenship->setDbValue($rs->fields('Citizenship')); $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')); $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')); $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')); $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')); $this->other_documents->setDbValue($rs->fields('other_documents')); $this->Final_evaluation->setDbValue($rs->fields('Final_evaluation')); $this->photo->Upload->DbValue = $rs->fields('photo'); $this->doc_image->Upload->DbValue = $rs->fields('doc_image'); $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')); } // Render list row values function RenderListRow() { global $Security, $gsLanguage, $Language; // Call Row Rendering event $this->Row_Rendering(); // Common render codes // 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 // 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 = ""; // idSeeker $this->idSeeker->LinkCustomAttributes = ""; if (!ew_Empty($this->idSeeker->CurrentValue)) { $this->idSeeker->HrefValue = "tospitiview.php?showdetail=&idSeeker=" . $this->idSeeker->CurrentValue; // Add prefix/suffix $this->idSeeker->LinkAttrs["target"] = ""; // Add target if ($this->Export <> "") $this->idSeeker->HrefValue = ew_ConvertFullUrl($this->idSeeker->HrefValue); } else { $this->idSeeker->HrefValue = ""; } $this->idSeeker->TooltipValue = ""; // 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 $this->Row_Rendered(); } // Render edit row values function RenderEditRow() { global $Security, $gsLanguage, $Language; // Call Row Rendering event $this->Row_Rendering(); // idSeeker $this->idSeeker->EditAttrs["class"] = "form-control"; $this->idSeeker->EditCustomAttributes = ""; $this->idSeeker->EditValue = $this->idSeeker->CurrentValue; $this->idSeeker->ViewCustomAttributes = ""; // Desk $this->Desk->EditAttrs["class"] = "form-control"; $this->Desk->EditCustomAttributes = ""; $this->Desk->EditValue = $this->Desk->CurrentValue; $this->Desk->PlaceHolder = ew_RemoveHtml($this->Desk->FldCaption()); // UNHCR_code $this->UNHCR_code->EditAttrs["class"] = "form-control"; $this->UNHCR_code->EditCustomAttributes = ""; $this->UNHCR_code->EditValue = $this->UNHCR_code->CurrentValue; $this->UNHCR_code->PlaceHolder = ew_RemoveHtml($this->UNHCR_code->FldCaption()); // Name $this->Name->EditAttrs["class"] = "form-control"; $this->Name->EditCustomAttributes = ""; $this->Name->EditValue = $this->Name->CurrentValue; $this->Name->PlaceHolder = ew_RemoveHtml($this->Name->FldCaption()); // Surname $this->Surname->EditAttrs["class"] = "form-control"; $this->Surname->EditCustomAttributes = ""; $this->Surname->EditValue = $this->Surname->CurrentValue; $this->Surname->PlaceHolder = ew_RemoveHtml($this->Surname->FldCaption()); // BirthDate $this->BirthDate->EditAttrs["class"] = "form-control"; $this->BirthDate->EditCustomAttributes = ""; $this->BirthDate->EditValue = ew_FormatDateTime($this->BirthDate->CurrentValue, 7); $this->BirthDate->PlaceHolder = ew_RemoveHtml($this->BirthDate->FldCaption()); // BirthPlace $this->BirthPlace->EditAttrs["class"] = "form-control"; $this->BirthPlace->EditCustomAttributes = ""; $this->BirthPlace->EditValue = $this->BirthPlace->CurrentValue; $this->BirthPlace->PlaceHolder = ew_RemoveHtml($this->BirthPlace->FldCaption()); // Nationality $this->Nationality->EditAttrs["class"] = "form-control"; $this->Nationality->EditCustomAttributes = ""; $this->Nationality->EditValue = $this->Nationality->CurrentValue; $this->Nationality->PlaceHolder = ew_RemoveHtml($this->Nationality->FldCaption()); // Citizenship $this->Citizenship->EditAttrs["class"] = "form-control"; $this->Citizenship->EditCustomAttributes = ""; $this->Citizenship->EditValue = $this->Citizenship->CurrentValue; $this->Citizenship->PlaceHolder = ew_RemoveHtml($this->Citizenship->FldCaption()); // Sex $this->Sex->EditAttrs["class"] = "form-control"; $this->Sex->EditCustomAttributes = ""; $this->Sex->EditValue = $this->Sex->Options(TRUE); // Phone $this->Phone->EditAttrs["class"] = "form-control"; $this->Phone->EditCustomAttributes = ""; $this->Phone->EditValue = $this->Phone->CurrentValue; $this->Phone->PlaceHolder = ew_RemoveHtml($this->Phone->FldCaption()); // Email $this->_Email->EditAttrs["class"] = "form-control"; $this->_Email->EditCustomAttributes = ""; $this->_Email->EditValue = $this->_Email->CurrentValue; $this->_Email->PlaceHolder = ew_RemoveHtml($this->_Email->FldCaption()); // Religion $this->Religion->EditAttrs["class"] = "form-control"; $this->Religion->EditCustomAttributes = ""; // Place_of_Residence $this->Place_of_Residence->EditAttrs["class"] = "form-control"; $this->Place_of_Residence->EditCustomAttributes = ""; // Address_of_Residence $this->Address_of_Residence->EditAttrs["class"] = "form-control"; $this->Address_of_Residence->EditCustomAttributes = ""; $this->Address_of_Residence->EditValue = $this->Address_of_Residence->CurrentValue; $this->Address_of_Residence->PlaceHolder = ew_RemoveHtml($this->Address_of_Residence->FldCaption()); // Town_of_residence $this->Town_of_residence->EditAttrs["class"] = "form-control"; $this->Town_of_residence->EditCustomAttributes = ""; $this->Town_of_residence->EditValue = $this->Town_of_residence->CurrentValue; $this->Town_of_residence->PlaceHolder = ew_RemoveHtml($this->Town_of_residence->FldCaption()); // Place_of_Transit $this->Place_of_Transit->EditAttrs["class"] = "form-control"; $this->Place_of_Transit->EditCustomAttributes = ""; // Address_of_Transit $this->Address_of_Transit->EditAttrs["class"] = "form-control"; $this->Address_of_Transit->EditCustomAttributes = ""; $this->Address_of_Transit->EditValue = $this->Address_of_Transit->CurrentValue; $this->Address_of_Transit->PlaceHolder = ew_RemoveHtml($this->Address_of_Transit->FldCaption()); // Town_of_transit $this->Town_of_transit->EditAttrs["class"] = "form-control"; $this->Town_of_transit->EditCustomAttributes = ""; $this->Town_of_transit->EditValue = $this->Town_of_transit->CurrentValue; $this->Town_of_transit->PlaceHolder = ew_RemoveHtml($this->Town_of_transit->FldCaption()); // domicile_description $this->domicile_description->EditAttrs["class"] = "form-control"; $this->domicile_description->EditCustomAttributes = ""; $this->domicile_description->EditValue = $this->domicile_description->CurrentValue; $this->domicile_description->PlaceHolder = ew_RemoveHtml($this->domicile_description->FldCaption()); // Disabled $this->Disabled->EditCustomAttributes = ""; $this->Disabled->EditValue = $this->Disabled->Options(FALSE); // Sick $this->Sick->EditCustomAttributes = ""; $this->Sick->EditValue = $this->Sick->Options(FALSE); // Alone $this->Alone->EditCustomAttributes = ""; $this->Alone->EditValue = $this->Alone->Options(FALSE); // Elderly $this->Elderly->EditCustomAttributes = ""; $this->Elderly->EditValue = $this->Elderly->Options(FALSE); // Family $this->Family->EditCustomAttributes = ""; $this->Family->EditValue = $this->Family->Options(FALSE); // Householder $this->Householder->EditCustomAttributes = ""; $this->Householder->EditValue = $this->Householder->Options(FALSE); // Householder_id $this->Householder_id->EditAttrs["class"] = "form-control"; $this->Householder_id->EditCustomAttributes = ""; $this->Householder_id->EditValue = $this->Householder_id->CurrentValue; $this->Householder_id->PlaceHolder = ew_RemoveHtml($this->Householder_id->FldCaption()); // Householder_reltype $this->Householder_reltype->EditAttrs["class"] = "form-control"; $this->Householder_reltype->EditCustomAttributes = ""; // Ethnic_group $this->Ethnic_group->EditAttrs["class"] = "form-control"; $this->Ethnic_group->EditCustomAttributes = ""; $this->Ethnic_group->EditValue = $this->Ethnic_group->CurrentValue; $this->Ethnic_group->PlaceHolder = ew_RemoveHtml($this->Ethnic_group->FldCaption()); // Known_languages $this->Known_languages->EditAttrs["class"] = "form-control"; $this->Known_languages->EditCustomAttributes = ""; $this->Known_languages->EditValue = $this->Known_languages->CurrentValue; $this->Known_languages->PlaceHolder = ew_RemoveHtml($this->Known_languages->FldCaption()); // Title_of_study $this->Title_of_study->EditAttrs["class"] = "form-control"; $this->Title_of_study->EditCustomAttributes = ""; $this->Title_of_study->EditValue = $this->Title_of_study->CurrentValue; $this->Title_of_study->PlaceHolder = ew_RemoveHtml($this->Title_of_study->FldCaption()); // Poss_destination_country $this->Poss_destination_country->EditAttrs["class"] = "form-control"; $this->Poss_destination_country->EditCustomAttributes = ""; $this->Poss_destination_country->EditValue = $this->Poss_destination_country->CurrentValue; $this->Poss_destination_country->PlaceHolder = ew_RemoveHtml($this->Poss_destination_country->FldCaption()); // Document_type $this->Document_type->EditAttrs["class"] = "form-control"; $this->Document_type->EditCustomAttributes = ""; // Document_number $this->Document_number->EditAttrs["class"] = "form-control"; $this->Document_number->EditCustomAttributes = ""; $this->Document_number->EditValue = $this->Document_number->CurrentValue; $this->Document_number->PlaceHolder = ew_RemoveHtml($this->Document_number->FldCaption()); // Document_release $this->Document_release->EditAttrs["class"] = "form-control"; $this->Document_release->EditCustomAttributes = ""; $this->Document_release->EditValue = ew_FormatDateTime($this->Document_release->CurrentValue, 7); $this->Document_release->PlaceHolder = ew_RemoveHtml($this->Document_release->FldCaption()); // Document_expiry $this->Document_expiry->EditAttrs["class"] = "form-control"; $this->Document_expiry->EditCustomAttributes = ""; $this->Document_expiry->EditValue = ew_FormatDateTime($this->Document_expiry->CurrentValue, 7); $this->Document_expiry->PlaceHolder = ew_RemoveHtml($this->Document_expiry->FldCaption()); // Document_nationality $this->Document_nationality->EditAttrs["class"] = "form-control"; $this->Document_nationality->EditCustomAttributes = ""; // other_documents $this->other_documents->EditAttrs["class"] = "form-control"; $this->other_documents->EditCustomAttributes = ""; $this->other_documents->EditValue = $this->other_documents->CurrentValue; $this->other_documents->PlaceHolder = ew_RemoveHtml($this->other_documents->FldCaption()); // Final_evaluation $this->Final_evaluation->EditAttrs["class"] = "form-control"; $this->Final_evaluation->EditCustomAttributes = ""; // photo $this->photo->EditAttrs["class"] = "form-control"; $this->photo->EditCustomAttributes = ""; $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->EditValue = $this->photo->Upload->DbValue; } else { $this->photo->EditValue = ""; } if (!ew_Empty($this->photo->CurrentValue)) $this->photo->Upload->FileName = $this->photo->CurrentValue; // doc_image $this->doc_image->EditAttrs["class"] = "form-control"; $this->doc_image->EditCustomAttributes = ""; $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->EditValue = $this->doc_image->Upload->DbValue; } else { $this->doc_image->EditValue = ""; } if (!ew_Empty($this->doc_image->CurrentValue)) $this->doc_image->Upload->FileName = $this->doc_image->CurrentValue; // Notes $this->Notes->EditAttrs["class"] = "form-control"; $this->Notes->EditCustomAttributes = ""; $this->Notes->EditValue = $this->Notes->CurrentValue; $this->Notes->PlaceHolder = ew_RemoveHtml($this->Notes->FldCaption()); // Interview_1 $this->Interview_1->EditCustomAttributes = ""; $this->Interview_1->EditValue = $this->Interview_1->Options(FALSE); // interview1_date $this->interview1_date->EditAttrs["class"] = "form-control"; $this->interview1_date->EditCustomAttributes = ""; $this->interview1_date->EditValue = ew_FormatDateTime($this->interview1_date->CurrentValue, 8); $this->interview1_date->PlaceHolder = ew_RemoveHtml($this->interview1_date->FldCaption()); // Interview_2 $this->Interview_2->EditCustomAttributes = ""; $this->Interview_2->EditValue = $this->Interview_2->Options(FALSE); // interview_2_date $this->interview_2_date->EditAttrs["class"] = "form-control"; $this->interview_2_date->EditCustomAttributes = ""; $this->interview_2_date->EditValue = ew_FormatDateTime($this->interview_2_date->CurrentValue, 8); $this->interview_2_date->PlaceHolder = ew_RemoveHtml($this->interview_2_date->FldCaption()); // Interview_3 $this->Interview_3->EditCustomAttributes = ""; $this->Interview_3->EditValue = $this->Interview_3->Options(FALSE); // interview_3_date $this->interview_3_date->EditAttrs["class"] = "form-control"; $this->interview_3_date->EditCustomAttributes = ""; $this->interview_3_date->EditValue = ew_FormatDateTime($this->interview_3_date->CurrentValue, 8); $this->interview_3_date->PlaceHolder = ew_RemoveHtml($this->interview_3_date->FldCaption()); // Zone_of_Transit $this->Zone_of_Transit->EditAttrs["class"] = "form-control"; $this->Zone_of_Transit->EditCustomAttributes = ""; $this->Zone_of_Transit->EditValue = $this->Zone_of_Transit->CurrentValue; $this->Zone_of_Transit->PlaceHolder = ew_RemoveHtml($this->Zone_of_Transit->FldCaption()); // Travel_number $this->Travel_number->EditAttrs["class"] = "form-control"; $this->Travel_number->EditCustomAttributes = ""; $this->Travel_number->EditValue = $this->Travel_number->CurrentValue; $this->Travel_number->PlaceHolder = ew_RemoveHtml($this->Travel_number->FldCaption()); // Travel_arrival_date $this->Travel_arrival_date->EditAttrs["class"] = "form-control"; $this->Travel_arrival_date->EditCustomAttributes = ""; $this->Travel_arrival_date->EditValue = ew_FormatDateTime($this->Travel_arrival_date->CurrentValue, 8); $this->Travel_arrival_date->PlaceHolder = ew_RemoveHtml($this->Travel_arrival_date->FldCaption()); // Travel_arrival_time $this->Travel_arrival_time->EditAttrs["class"] = "form-control"; $this->Travel_arrival_time->EditCustomAttributes = ""; $this->Travel_arrival_time->EditValue = $this->Travel_arrival_time->CurrentValue; $this->Travel_arrival_time->PlaceHolder = ew_RemoveHtml($this->Travel_arrival_time->FldCaption()); // num_family $this->num_family->EditAttrs["class"] = "form-control"; $this->num_family->EditCustomAttributes = ""; $this->num_family->EditValue = $this->num_family->CurrentValue; $this->num_family->PlaceHolder = ew_RemoveHtml($this->num_family->FldCaption()); // speak_ENG $this->speak_ENG->EditCustomAttributes = ""; $this->speak_ENG->EditValue = $this->speak_ENG->Options(FALSE); // speak_FRA $this->speak_FRA->EditCustomAttributes = ""; $this->speak_FRA->EditValue = $this->speak_FRA->Options(FALSE); // speak_ARA $this->speak_ARA->EditCustomAttributes = ""; $this->speak_ARA->EditValue = $this->speak_ARA->Options(FALSE); // speak_ITA $this->speak_ITA->EditCustomAttributes = ""; $this->speak_ITA->EditValue = $this->speak_ITA->Options(FALSE); // lives_with $this->lives_with->EditAttrs["class"] = "form-control"; $this->lives_with->EditCustomAttributes = ""; $this->lives_with->EditValue = $this->lives_with->CurrentValue; $this->lives_with->PlaceHolder = ew_RemoveHtml($this->lives_with->FldCaption()); // family_know $this->family_know->EditCustomAttributes = ""; $this->family_know->EditValue = $this->family_know->Options(FALSE); // date_of_entry_transit $this->date_of_entry_transit->EditAttrs["class"] = "form-control"; $this->date_of_entry_transit->EditCustomAttributes = ""; $this->date_of_entry_transit->EditValue = ew_FormatDateTime($this->date_of_entry_transit->CurrentValue, 8); $this->date_of_entry_transit->PlaceHolder = ew_RemoveHtml($this->date_of_entry_transit->FldCaption()); // marital_status $this->marital_status->EditAttrs["class"] = "form-control"; $this->marital_status->EditCustomAttributes = ""; $this->marital_status->EditValue = $this->marital_status->CurrentValue; $this->marital_status->PlaceHolder = ew_RemoveHtml($this->marital_status->FldCaption()); // consort_id $this->consort_id->EditAttrs["class"] = "form-control"; $this->consort_id->EditCustomAttributes = ""; $this->consort_id->EditValue = $this->consort_id->CurrentValue; $this->consort_id->PlaceHolder = ew_RemoveHtml($this->consort_id->FldCaption()); // consort_info $this->consort_info->EditAttrs["class"] = "form-control"; $this->consort_info->EditCustomAttributes = ""; $this->consort_info->EditValue = $this->consort_info->CurrentValue; $this->consort_info->PlaceHolder = ew_RemoveHtml($this->consort_info->FldCaption()); // other_fam_in_italy $this->other_fam_in_italy->EditAttrs["class"] = "form-control"; $this->other_fam_in_italy->EditCustomAttributes = ""; $this->other_fam_in_italy->EditValue = $this->other_fam_in_italy->CurrentValue; $this->other_fam_in_italy->PlaceHolder = ew_RemoveHtml($this->other_fam_in_italy->FldCaption()); // other_fam_in_europe $this->other_fam_in_europe->EditAttrs["class"] = "form-control"; $this->other_fam_in_europe->EditCustomAttributes = ""; $this->other_fam_in_europe->EditValue = $this->other_fam_in_europe->CurrentValue; $this->other_fam_in_europe->PlaceHolder = ew_RemoveHtml($this->other_fam_in_europe->FldCaption()); // where_lived $this->where_lived->EditAttrs["class"] = "form-control"; $this->where_lived->EditCustomAttributes = ""; $this->where_lived->EditValue = $this->where_lived->CurrentValue; $this->where_lived->PlaceHolder = ew_RemoveHtml($this->where_lived->FldCaption()); // medical_situation $this->medical_situation->EditAttrs["class"] = "form-control"; $this->medical_situation->EditCustomAttributes = ""; $this->medical_situation->EditValue = $this->medical_situation->CurrentValue; $this->medical_situation->PlaceHolder = ew_RemoveHtml($this->medical_situation->FldCaption()); // social_situation $this->social_situation->EditAttrs["class"] = "form-control"; $this->social_situation->EditCustomAttributes = ""; $this->social_situation->EditValue = $this->social_situation->CurrentValue; $this->social_situation->PlaceHolder = ew_RemoveHtml($this->social_situation->FldCaption()); // abuse_suffered $this->abuse_suffered->EditCustomAttributes = ""; $this->abuse_suffered->EditValue = $this->abuse_suffered->Options(FALSE); // abuse_description $this->abuse_description->EditAttrs["class"] = "form-control"; $this->abuse_description->EditCustomAttributes = ""; $this->abuse_description->EditValue = $this->abuse_description->CurrentValue; $this->abuse_description->PlaceHolder = ew_RemoveHtml($this->abuse_description->FldCaption()); // work_done $this->work_done->EditAttrs["class"] = "form-control"; $this->work_done->EditCustomAttributes = ""; $this->work_done->EditValue = $this->work_done->CurrentValue; $this->work_done->PlaceHolder = ew_RemoveHtml($this->work_done->FldCaption()); // military_service $this->military_service->EditAttrs["class"] = "form-control"; $this->military_service->EditCustomAttributes = ""; $this->military_service->EditValue = $this->military_service->CurrentValue; $this->military_service->PlaceHolder = ew_RemoveHtml($this->military_service->FldCaption()); // itinerary $this->itinerary->EditAttrs["class"] = "form-control"; $this->itinerary->EditCustomAttributes = ""; $this->itinerary->EditValue = $this->itinerary->CurrentValue; $this->itinerary->PlaceHolder = ew_RemoveHtml($this->itinerary->FldCaption()); // convictions $this->convictions->EditCustomAttributes = ""; $this->convictions->EditValue = $this->convictions->Options(FALSE); // requested_asylum $this->requested_asylum->EditAttrs["class"] = "form-control"; $this->requested_asylum->EditCustomAttributes = ""; $this->requested_asylum->EditValue = $this->requested_asylum->CurrentValue; $this->requested_asylum->PlaceHolder = ew_RemoveHtml($this->requested_asylum->FldCaption()); // resettlement_application $this->resettlement_application->EditCustomAttributes = ""; $this->resettlement_application->EditValue = $this->resettlement_application->Options(FALSE); // resettlement_country $this->resettlement_country->EditAttrs["class"] = "form-control"; $this->resettlement_country->EditCustomAttributes = ""; $this->resettlement_country->EditValue = $this->resettlement_country->CurrentValue; $this->resettlement_country->PlaceHolder = ew_RemoveHtml($this->resettlement_country->FldCaption()); // reunion_application $this->reunion_application->EditCustomAttributes = ""; $this->reunion_application->EditValue = $this->reunion_application->Options(FALSE); // reunion_country $this->reunion_country->EditAttrs["class"] = "form-control"; $this->reunion_country->EditCustomAttributes = ""; $this->reunion_country->EditValue = $this->reunion_country->CurrentValue; $this->reunion_country->PlaceHolder = ew_RemoveHtml($this->reunion_country->FldCaption()); // belongs_to_organization $this->belongs_to_organization->EditCustomAttributes = ""; $this->belongs_to_organization->EditValue = $this->belongs_to_organization->Options(FALSE); // organizations $this->organizations->EditAttrs["class"] = "form-control"; $this->organizations->EditCustomAttributes = ""; $this->organizations->EditValue = $this->organizations->CurrentValue; $this->organizations->PlaceHolder = ew_RemoveHtml($this->organizations->FldCaption()); // presentations $this->presentations->EditAttrs["class"] = "form-control"; $this->presentations->EditCustomAttributes = ""; $this->presentations->EditValue = $this->presentations->CurrentValue; $this->presentations->PlaceHolder = ew_RemoveHtml($this->presentations->FldCaption()); // report $this->report->EditAttrs["class"] = "form-control"; $this->report->EditCustomAttributes = ""; $this->report->EditValue = $this->report->CurrentValue; $this->report->PlaceHolder = ew_RemoveHtml($this->report->FldCaption()); // Call Row Rendered event $this->Row_Rendered(); } // Aggregate list row values function AggregateListRowValues() { } // Aggregate list row (for rendering) function AggregateListRow() { // Call Row Rendered event $this->Row_Rendered(); } var $ExportDoc; // Export data in HTML/CSV/Word/Excel/Email/PDF format function ExportDocument(&$Doc, &$Recordset, $StartRec, $StopRec, $ExportPageType = "") { if (!$Recordset || !$Doc) return; if (!$Doc->ExportCustom) { // Write header $Doc->ExportTableHeader(); if ($Doc->Horizontal) { // Horizontal format, write header $Doc->BeginExportRow(); if ($ExportPageType == "view") { if ($this->Desk->Exportable) $Doc->ExportCaption($this->Desk); if ($this->UNHCR_code->Exportable) $Doc->ExportCaption($this->UNHCR_code); if ($this->Name->Exportable) $Doc->ExportCaption($this->Name); if ($this->Surname->Exportable) $Doc->ExportCaption($this->Surname); if ($this->BirthDate->Exportable) $Doc->ExportCaption($this->BirthDate); if ($this->BirthPlace->Exportable) $Doc->ExportCaption($this->BirthPlace); if ($this->Nationality->Exportable) $Doc->ExportCaption($this->Nationality); if ($this->Citizenship->Exportable) $Doc->ExportCaption($this->Citizenship); if ($this->Sex->Exportable) $Doc->ExportCaption($this->Sex); if ($this->Phone->Exportable) $Doc->ExportCaption($this->Phone); if ($this->_Email->Exportable) $Doc->ExportCaption($this->_Email); if ($this->Religion->Exportable) $Doc->ExportCaption($this->Religion); if ($this->Place_of_Residence->Exportable) $Doc->ExportCaption($this->Place_of_Residence); if ($this->Address_of_Residence->Exportable) $Doc->ExportCaption($this->Address_of_Residence); if ($this->Town_of_residence->Exportable) $Doc->ExportCaption($this->Town_of_residence); if ($this->Place_of_Transit->Exportable) $Doc->ExportCaption($this->Place_of_Transit); if ($this->Address_of_Transit->Exportable) $Doc->ExportCaption($this->Address_of_Transit); if ($this->Town_of_transit->Exportable) $Doc->ExportCaption($this->Town_of_transit); if ($this->domicile_description->Exportable) $Doc->ExportCaption($this->domicile_description); if ($this->Disabled->Exportable) $Doc->ExportCaption($this->Disabled); if ($this->Sick->Exportable) $Doc->ExportCaption($this->Sick); if ($this->Alone->Exportable) $Doc->ExportCaption($this->Alone); if ($this->Elderly->Exportable) $Doc->ExportCaption($this->Elderly); if ($this->Family->Exportable) $Doc->ExportCaption($this->Family); if ($this->Householder->Exportable) $Doc->ExportCaption($this->Householder); if ($this->Householder_id->Exportable) $Doc->ExportCaption($this->Householder_id); if ($this->Householder_reltype->Exportable) $Doc->ExportCaption($this->Householder_reltype); if ($this->Ethnic_group->Exportable) $Doc->ExportCaption($this->Ethnic_group); if ($this->Known_languages->Exportable) $Doc->ExportCaption($this->Known_languages); if ($this->Title_of_study->Exportable) $Doc->ExportCaption($this->Title_of_study); if ($this->Poss_destination_country->Exportable) $Doc->ExportCaption($this->Poss_destination_country); if ($this->Document_type->Exportable) $Doc->ExportCaption($this->Document_type); if ($this->Document_number->Exportable) $Doc->ExportCaption($this->Document_number); if ($this->Document_release->Exportable) $Doc->ExportCaption($this->Document_release); if ($this->Document_expiry->Exportable) $Doc->ExportCaption($this->Document_expiry); if ($this->Document_nationality->Exportable) $Doc->ExportCaption($this->Document_nationality); if ($this->other_documents->Exportable) $Doc->ExportCaption($this->other_documents); if ($this->Final_evaluation->Exportable) $Doc->ExportCaption($this->Final_evaluation); if ($this->photo->Exportable) $Doc->ExportCaption($this->photo); if ($this->doc_image->Exportable) $Doc->ExportCaption($this->doc_image); if ($this->Notes->Exportable) $Doc->ExportCaption($this->Notes); if ($this->Interview_1->Exportable) $Doc->ExportCaption($this->Interview_1); if ($this->interview1_date->Exportable) $Doc->ExportCaption($this->interview1_date); if ($this->Interview_2->Exportable) $Doc->ExportCaption($this->Interview_2); if ($this->interview_2_date->Exportable) $Doc->ExportCaption($this->interview_2_date); if ($this->Interview_3->Exportable) $Doc->ExportCaption($this->Interview_3); if ($this->interview_3_date->Exportable) $Doc->ExportCaption($this->interview_3_date); if ($this->Zone_of_Transit->Exportable) $Doc->ExportCaption($this->Zone_of_Transit); if ($this->Travel_number->Exportable) $Doc->ExportCaption($this->Travel_number); if ($this->Travel_arrival_date->Exportable) $Doc->ExportCaption($this->Travel_arrival_date); if ($this->Travel_arrival_time->Exportable) $Doc->ExportCaption($this->Travel_arrival_time); if ($this->num_family->Exportable) $Doc->ExportCaption($this->num_family); if ($this->speak_ENG->Exportable) $Doc->ExportCaption($this->speak_ENG); if ($this->speak_FRA->Exportable) $Doc->ExportCaption($this->speak_FRA); if ($this->speak_ARA->Exportable) $Doc->ExportCaption($this->speak_ARA); if ($this->speak_ITA->Exportable) $Doc->ExportCaption($this->speak_ITA); if ($this->lives_with->Exportable) $Doc->ExportCaption($this->lives_with); if ($this->family_know->Exportable) $Doc->ExportCaption($this->family_know); if ($this->date_of_entry_transit->Exportable) $Doc->ExportCaption($this->date_of_entry_transit); if ($this->marital_status->Exportable) $Doc->ExportCaption($this->marital_status); if ($this->consort_id->Exportable) $Doc->ExportCaption($this->consort_id); if ($this->consort_info->Exportable) $Doc->ExportCaption($this->consort_info); if ($this->other_fam_in_italy->Exportable) $Doc->ExportCaption($this->other_fam_in_italy); if ($this->other_fam_in_europe->Exportable) $Doc->ExportCaption($this->other_fam_in_europe); if ($this->where_lived->Exportable) $Doc->ExportCaption($this->where_lived); if ($this->medical_situation->Exportable) $Doc->ExportCaption($this->medical_situation); if ($this->social_situation->Exportable) $Doc->ExportCaption($this->social_situation); if ($this->abuse_suffered->Exportable) $Doc->ExportCaption($this->abuse_suffered); if ($this->abuse_description->Exportable) $Doc->ExportCaption($this->abuse_description); if ($this->work_done->Exportable) $Doc->ExportCaption($this->work_done); if ($this->military_service->Exportable) $Doc->ExportCaption($this->military_service); if ($this->itinerary->Exportable) $Doc->ExportCaption($this->itinerary); if ($this->convictions->Exportable) $Doc->ExportCaption($this->convictions); if ($this->requested_asylum->Exportable) $Doc->ExportCaption($this->requested_asylum); if ($this->resettlement_application->Exportable) $Doc->ExportCaption($this->resettlement_application); if ($this->resettlement_country->Exportable) $Doc->ExportCaption($this->resettlement_country); if ($this->reunion_application->Exportable) $Doc->ExportCaption($this->reunion_application); if ($this->reunion_country->Exportable) $Doc->ExportCaption($this->reunion_country); if ($this->belongs_to_organization->Exportable) $Doc->ExportCaption($this->belongs_to_organization); if ($this->organizations->Exportable) $Doc->ExportCaption($this->organizations); if ($this->presentations->Exportable) $Doc->ExportCaption($this->presentations); if ($this->report->Exportable) $Doc->ExportCaption($this->report); } else { if ($this->idSeeker->Exportable) $Doc->ExportCaption($this->idSeeker); if ($this->Desk->Exportable) $Doc->ExportCaption($this->Desk); if ($this->UNHCR_code->Exportable) $Doc->ExportCaption($this->UNHCR_code); if ($this->Name->Exportable) $Doc->ExportCaption($this->Name); if ($this->Surname->Exportable) $Doc->ExportCaption($this->Surname); if ($this->BirthDate->Exportable) $Doc->ExportCaption($this->BirthDate); if ($this->BirthPlace->Exportable) $Doc->ExportCaption($this->BirthPlace); if ($this->Nationality->Exportable) $Doc->ExportCaption($this->Nationality); if ($this->Sex->Exportable) $Doc->ExportCaption($this->Sex); if ($this->Phone->Exportable) $Doc->ExportCaption($this->Phone); if ($this->_Email->Exportable) $Doc->ExportCaption($this->_Email); if ($this->Religion->Exportable) $Doc->ExportCaption($this->Religion); if ($this->Place_of_Residence->Exportable) $Doc->ExportCaption($this->Place_of_Residence); if ($this->Address_of_Residence->Exportable) $Doc->ExportCaption($this->Address_of_Residence); if ($this->Town_of_residence->Exportable) $Doc->ExportCaption($this->Town_of_residence); if ($this->Place_of_Transit->Exportable) $Doc->ExportCaption($this->Place_of_Transit); if ($this->Address_of_Transit->Exportable) $Doc->ExportCaption($this->Address_of_Transit); if ($this->Town_of_transit->Exportable) $Doc->ExportCaption($this->Town_of_transit); if ($this->domicile_description->Exportable) $Doc->ExportCaption($this->domicile_description); if ($this->Disabled->Exportable) $Doc->ExportCaption($this->Disabled); if ($this->Sick->Exportable) $Doc->ExportCaption($this->Sick); if ($this->Alone->Exportable) $Doc->ExportCaption($this->Alone); if ($this->Elderly->Exportable) $Doc->ExportCaption($this->Elderly); if ($this->Family->Exportable) $Doc->ExportCaption($this->Family); if ($this->Householder->Exportable) $Doc->ExportCaption($this->Householder); if ($this->Householder_id->Exportable) $Doc->ExportCaption($this->Householder_id); if ($this->Householder_reltype->Exportable) $Doc->ExportCaption($this->Householder_reltype); if ($this->Ethnic_group->Exportable) $Doc->ExportCaption($this->Ethnic_group); if ($this->Known_languages->Exportable) $Doc->ExportCaption($this->Known_languages); if ($this->Title_of_study->Exportable) $Doc->ExportCaption($this->Title_of_study); if ($this->Poss_destination_country->Exportable) $Doc->ExportCaption($this->Poss_destination_country); if ($this->Document_type->Exportable) $Doc->ExportCaption($this->Document_type); if ($this->Document_number->Exportable) $Doc->ExportCaption($this->Document_number); if ($this->Document_release->Exportable) $Doc->ExportCaption($this->Document_release); if ($this->Document_expiry->Exportable) $Doc->ExportCaption($this->Document_expiry); if ($this->Document_nationality->Exportable) $Doc->ExportCaption($this->Document_nationality); if ($this->other_documents->Exportable) $Doc->ExportCaption($this->other_documents); if ($this->Final_evaluation->Exportable) $Doc->ExportCaption($this->Final_evaluation); if ($this->Notes->Exportable) $Doc->ExportCaption($this->Notes); if ($this->Interview_1->Exportable) $Doc->ExportCaption($this->Interview_1); if ($this->interview1_date->Exportable) $Doc->ExportCaption($this->interview1_date); if ($this->Interview_2->Exportable) $Doc->ExportCaption($this->Interview_2); if ($this->interview_2_date->Exportable) $Doc->ExportCaption($this->interview_2_date); if ($this->Interview_3->Exportable) $Doc->ExportCaption($this->Interview_3); if ($this->interview_3_date->Exportable) $Doc->ExportCaption($this->interview_3_date); if ($this->Zone_of_Transit->Exportable) $Doc->ExportCaption($this->Zone_of_Transit); if ($this->Travel_number->Exportable) $Doc->ExportCaption($this->Travel_number); if ($this->Travel_arrival_date->Exportable) $Doc->ExportCaption($this->Travel_arrival_date); if ($this->Travel_arrival_time->Exportable) $Doc->ExportCaption($this->Travel_arrival_time); if ($this->num_family->Exportable) $Doc->ExportCaption($this->num_family); if ($this->speak_ENG->Exportable) $Doc->ExportCaption($this->speak_ENG); if ($this->speak_FRA->Exportable) $Doc->ExportCaption($this->speak_FRA); if ($this->speak_ARA->Exportable) $Doc->ExportCaption($this->speak_ARA); if ($this->speak_ITA->Exportable) $Doc->ExportCaption($this->speak_ITA); if ($this->lives_with->Exportable) $Doc->ExportCaption($this->lives_with); if ($this->family_know->Exportable) $Doc->ExportCaption($this->family_know); if ($this->date_of_entry_transit->Exportable) $Doc->ExportCaption($this->date_of_entry_transit); if ($this->marital_status->Exportable) $Doc->ExportCaption($this->marital_status); if ($this->consort_id->Exportable) $Doc->ExportCaption($this->consort_id); if ($this->abuse_suffered->Exportable) $Doc->ExportCaption($this->abuse_suffered); if ($this->military_service->Exportable) $Doc->ExportCaption($this->military_service); if ($this->convictions->Exportable) $Doc->ExportCaption($this->convictions); if ($this->resettlement_application->Exportable) $Doc->ExportCaption($this->resettlement_application); if ($this->resettlement_country->Exportable) $Doc->ExportCaption($this->resettlement_country); if ($this->reunion_application->Exportable) $Doc->ExportCaption($this->reunion_application); if ($this->reunion_country->Exportable) $Doc->ExportCaption($this->reunion_country); if ($this->belongs_to_organization->Exportable) $Doc->ExportCaption($this->belongs_to_organization); if ($this->organizations->Exportable) $Doc->ExportCaption($this->organizations); } $Doc->EndExportRow(); } } // Move to first record $RecCnt = $StartRec - 1; if (!$Recordset->EOF) { $Recordset->MoveFirst(); if ($StartRec > 1) $Recordset->Move($StartRec - 1); } while (!$Recordset->EOF && $RecCnt < $StopRec) { $RecCnt++; if (intval($RecCnt) >= intval($StartRec)) { $RowCnt = intval($RecCnt) - intval($StartRec) + 1; // Page break if ($this->ExportPageBreakCount > 0) { if ($RowCnt > 1 && ($RowCnt - 1) % $this->ExportPageBreakCount == 0) $Doc->ExportPageBreak(); } $this->LoadListRowValues($Recordset); // Render row $this->RowType = EW_ROWTYPE_VIEW; // Render view $this->ResetAttrs(); $this->RenderListRow(); if (!$Doc->ExportCustom) { $Doc->BeginExportRow($RowCnt); // Allow CSS styles if enabled if ($ExportPageType == "view") { if ($this->Desk->Exportable) $Doc->ExportField($this->Desk); if ($this->UNHCR_code->Exportable) $Doc->ExportField($this->UNHCR_code); if ($this->Name->Exportable) $Doc->ExportField($this->Name); if ($this->Surname->Exportable) $Doc->ExportField($this->Surname); if ($this->BirthDate->Exportable) $Doc->ExportField($this->BirthDate); if ($this->BirthPlace->Exportable) $Doc->ExportField($this->BirthPlace); if ($this->Nationality->Exportable) $Doc->ExportField($this->Nationality); if ($this->Citizenship->Exportable) $Doc->ExportField($this->Citizenship); if ($this->Sex->Exportable) $Doc->ExportField($this->Sex); if ($this->Phone->Exportable) $Doc->ExportField($this->Phone); if ($this->_Email->Exportable) $Doc->ExportField($this->_Email); if ($this->Religion->Exportable) $Doc->ExportField($this->Religion); if ($this->Place_of_Residence->Exportable) $Doc->ExportField($this->Place_of_Residence); if ($this->Address_of_Residence->Exportable) $Doc->ExportField($this->Address_of_Residence); if ($this->Town_of_residence->Exportable) $Doc->ExportField($this->Town_of_residence); if ($this->Place_of_Transit->Exportable) $Doc->ExportField($this->Place_of_Transit); if ($this->Address_of_Transit->Exportable) $Doc->ExportField($this->Address_of_Transit); if ($this->Town_of_transit->Exportable) $Doc->ExportField($this->Town_of_transit); if ($this->domicile_description->Exportable) $Doc->ExportField($this->domicile_description); if ($this->Disabled->Exportable) $Doc->ExportField($this->Disabled); if ($this->Sick->Exportable) $Doc->ExportField($this->Sick); if ($this->Alone->Exportable) $Doc->ExportField($this->Alone); if ($this->Elderly->Exportable) $Doc->ExportField($this->Elderly); if ($this->Family->Exportable) $Doc->ExportField($this->Family); if ($this->Householder->Exportable) $Doc->ExportField($this->Householder); if ($this->Householder_id->Exportable) $Doc->ExportField($this->Householder_id); if ($this->Householder_reltype->Exportable) $Doc->ExportField($this->Householder_reltype); if ($this->Ethnic_group->Exportable) $Doc->ExportField($this->Ethnic_group); if ($this->Known_languages->Exportable) $Doc->ExportField($this->Known_languages); if ($this->Title_of_study->Exportable) $Doc->ExportField($this->Title_of_study); if ($this->Poss_destination_country->Exportable) $Doc->ExportField($this->Poss_destination_country); if ($this->Document_type->Exportable) $Doc->ExportField($this->Document_type); if ($this->Document_number->Exportable) $Doc->ExportField($this->Document_number); if ($this->Document_release->Exportable) $Doc->ExportField($this->Document_release); if ($this->Document_expiry->Exportable) $Doc->ExportField($this->Document_expiry); if ($this->Document_nationality->Exportable) $Doc->ExportField($this->Document_nationality); if ($this->other_documents->Exportable) $Doc->ExportField($this->other_documents); if ($this->Final_evaluation->Exportable) $Doc->ExportField($this->Final_evaluation); if ($this->photo->Exportable) $Doc->ExportField($this->photo); if ($this->doc_image->Exportable) $Doc->ExportField($this->doc_image); if ($this->Notes->Exportable) $Doc->ExportField($this->Notes); if ($this->Interview_1->Exportable) $Doc->ExportField($this->Interview_1); if ($this->interview1_date->Exportable) $Doc->ExportField($this->interview1_date); if ($this->Interview_2->Exportable) $Doc->ExportField($this->Interview_2); if ($this->interview_2_date->Exportable) $Doc->ExportField($this->interview_2_date); if ($this->Interview_3->Exportable) $Doc->ExportField($this->Interview_3); if ($this->interview_3_date->Exportable) $Doc->ExportField($this->interview_3_date); if ($this->Zone_of_Transit->Exportable) $Doc->ExportField($this->Zone_of_Transit); if ($this->Travel_number->Exportable) $Doc->ExportField($this->Travel_number); if ($this->Travel_arrival_date->Exportable) $Doc->ExportField($this->Travel_arrival_date); if ($this->Travel_arrival_time->Exportable) $Doc->ExportField($this->Travel_arrival_time); if ($this->num_family->Exportable) $Doc->ExportField($this->num_family); if ($this->speak_ENG->Exportable) $Doc->ExportField($this->speak_ENG); if ($this->speak_FRA->Exportable) $Doc->ExportField($this->speak_FRA); if ($this->speak_ARA->Exportable) $Doc->ExportField($this->speak_ARA); if ($this->speak_ITA->Exportable) $Doc->ExportField($this->speak_ITA); if ($this->lives_with->Exportable) $Doc->ExportField($this->lives_with); if ($this->family_know->Exportable) $Doc->ExportField($this->family_know); if ($this->date_of_entry_transit->Exportable) $Doc->ExportField($this->date_of_entry_transit); if ($this->marital_status->Exportable) $Doc->ExportField($this->marital_status); if ($this->consort_id->Exportable) $Doc->ExportField($this->consort_id); if ($this->consort_info->Exportable) $Doc->ExportField($this->consort_info); if ($this->other_fam_in_italy->Exportable) $Doc->ExportField($this->other_fam_in_italy); if ($this->other_fam_in_europe->Exportable) $Doc->ExportField($this->other_fam_in_europe); if ($this->where_lived->Exportable) $Doc->ExportField($this->where_lived); if ($this->medical_situation->Exportable) $Doc->ExportField($this->medical_situation); if ($this->social_situation->Exportable) $Doc->ExportField($this->social_situation); if ($this->abuse_suffered->Exportable) $Doc->ExportField($this->abuse_suffered); if ($this->abuse_description->Exportable) $Doc->ExportField($this->abuse_description); if ($this->work_done->Exportable) $Doc->ExportField($this->work_done); if ($this->military_service->Exportable) $Doc->ExportField($this->military_service); if ($this->itinerary->Exportable) $Doc->ExportField($this->itinerary); if ($this->convictions->Exportable) $Doc->ExportField($this->convictions); if ($this->requested_asylum->Exportable) $Doc->ExportField($this->requested_asylum); if ($this->resettlement_application->Exportable) $Doc->ExportField($this->resettlement_application); if ($this->resettlement_country->Exportable) $Doc->ExportField($this->resettlement_country); if ($this->reunion_application->Exportable) $Doc->ExportField($this->reunion_application); if ($this->reunion_country->Exportable) $Doc->ExportField($this->reunion_country); if ($this->belongs_to_organization->Exportable) $Doc->ExportField($this->belongs_to_organization); if ($this->organizations->Exportable) $Doc->ExportField($this->organizations); if ($this->presentations->Exportable) $Doc->ExportField($this->presentations); if ($this->report->Exportable) $Doc->ExportField($this->report); } else { if ($this->idSeeker->Exportable) $Doc->ExportField($this->idSeeker); if ($this->Desk->Exportable) $Doc->ExportField($this->Desk); if ($this->UNHCR_code->Exportable) $Doc->ExportField($this->UNHCR_code); if ($this->Name->Exportable) $Doc->ExportField($this->Name); if ($this->Surname->Exportable) $Doc->ExportField($this->Surname); if ($this->BirthDate->Exportable) $Doc->ExportField($this->BirthDate); if ($this->BirthPlace->Exportable) $Doc->ExportField($this->BirthPlace); if ($this->Nationality->Exportable) $Doc->ExportField($this->Nationality); if ($this->Sex->Exportable) $Doc->ExportField($this->Sex); if ($this->Phone->Exportable) $Doc->ExportField($this->Phone); if ($this->_Email->Exportable) $Doc->ExportField($this->_Email); if ($this->Religion->Exportable) $Doc->ExportField($this->Religion); if ($this->Place_of_Residence->Exportable) $Doc->ExportField($this->Place_of_Residence); if ($this->Address_of_Residence->Exportable) $Doc->ExportField($this->Address_of_Residence); if ($this->Town_of_residence->Exportable) $Doc->ExportField($this->Town_of_residence); if ($this->Place_of_Transit->Exportable) $Doc->ExportField($this->Place_of_Transit); if ($this->Address_of_Transit->Exportable) $Doc->ExportField($this->Address_of_Transit); if ($this->Town_of_transit->Exportable) $Doc->ExportField($this->Town_of_transit); if ($this->domicile_description->Exportable) $Doc->ExportField($this->domicile_description); if ($this->Disabled->Exportable) $Doc->ExportField($this->Disabled); if ($this->Sick->Exportable) $Doc->ExportField($this->Sick); if ($this->Alone->Exportable) $Doc->ExportField($this->Alone); if ($this->Elderly->Exportable) $Doc->ExportField($this->Elderly); if ($this->Family->Exportable) $Doc->ExportField($this->Family); if ($this->Householder->Exportable) $Doc->ExportField($this->Householder); if ($this->Householder_id->Exportable) $Doc->ExportField($this->Householder_id); if ($this->Householder_reltype->Exportable) $Doc->ExportField($this->Householder_reltype); if ($this->Ethnic_group->Exportable) $Doc->ExportField($this->Ethnic_group); if ($this->Known_languages->Exportable) $Doc->ExportField($this->Known_languages); if ($this->Title_of_study->Exportable) $Doc->ExportField($this->Title_of_study); if ($this->Poss_destination_country->Exportable) $Doc->ExportField($this->Poss_destination_country); if ($this->Document_type->Exportable) $Doc->ExportField($this->Document_type); if ($this->Document_number->Exportable) $Doc->ExportField($this->Document_number); if ($this->Document_release->Exportable) $Doc->ExportField($this->Document_release); if ($this->Document_expiry->Exportable) $Doc->ExportField($this->Document_expiry); if ($this->Document_nationality->Exportable) $Doc->ExportField($this->Document_nationality); if ($this->other_documents->Exportable) $Doc->ExportField($this->other_documents); if ($this->Final_evaluation->Exportable) $Doc->ExportField($this->Final_evaluation); if ($this->Notes->Exportable) $Doc->ExportField($this->Notes); if ($this->Interview_1->Exportable) $Doc->ExportField($this->Interview_1); if ($this->interview1_date->Exportable) $Doc->ExportField($this->interview1_date); if ($this->Interview_2->Exportable) $Doc->ExportField($this->Interview_2); if ($this->interview_2_date->Exportable) $Doc->ExportField($this->interview_2_date); if ($this->Interview_3->Exportable) $Doc->ExportField($this->Interview_3); if ($this->interview_3_date->Exportable) $Doc->ExportField($this->interview_3_date); if ($this->Zone_of_Transit->Exportable) $Doc->ExportField($this->Zone_of_Transit); if ($this->Travel_number->Exportable) $Doc->ExportField($this->Travel_number); if ($this->Travel_arrival_date->Exportable) $Doc->ExportField($this->Travel_arrival_date); if ($this->Travel_arrival_time->Exportable) $Doc->ExportField($this->Travel_arrival_time); if ($this->num_family->Exportable) $Doc->ExportField($this->num_family); if ($this->speak_ENG->Exportable) $Doc->ExportField($this->speak_ENG); if ($this->speak_FRA->Exportable) $Doc->ExportField($this->speak_FRA); if ($this->speak_ARA->Exportable) $Doc->ExportField($this->speak_ARA); if ($this->speak_ITA->Exportable) $Doc->ExportField($this->speak_ITA); if ($this->lives_with->Exportable) $Doc->ExportField($this->lives_with); if ($this->family_know->Exportable) $Doc->ExportField($this->family_know); if ($this->date_of_entry_transit->Exportable) $Doc->ExportField($this->date_of_entry_transit); if ($this->marital_status->Exportable) $Doc->ExportField($this->marital_status); if ($this->consort_id->Exportable) $Doc->ExportField($this->consort_id); if ($this->abuse_suffered->Exportable) $Doc->ExportField($this->abuse_suffered); if ($this->military_service->Exportable) $Doc->ExportField($this->military_service); if ($this->convictions->Exportable) $Doc->ExportField($this->convictions); if ($this->resettlement_application->Exportable) $Doc->ExportField($this->resettlement_application); if ($this->resettlement_country->Exportable) $Doc->ExportField($this->resettlement_country); if ($this->reunion_application->Exportable) $Doc->ExportField($this->reunion_application); if ($this->reunion_country->Exportable) $Doc->ExportField($this->reunion_country); if ($this->belongs_to_organization->Exportable) $Doc->ExportField($this->belongs_to_organization); if ($this->organizations->Exportable) $Doc->ExportField($this->organizations); } $Doc->EndExportRow(); } } // Call Row Export server event if ($Doc->ExportCustom) $this->Row_Export($Recordset->fields); $Recordset->MoveNext(); } if (!$Doc->ExportCustom) { $Doc->ExportTableFooter(); } } // Get auto fill value function GetAutoFill($id, $val) { $rsarr = array(); $rowcnt = 0; // Output if (is_array($rsarr) && $rowcnt > 0) { $fldcnt = count($rsarr[0]); for ($i = 0; $i < $rowcnt; $i++) { for ($j = 0; $j < $fldcnt; $j++) { $str = strval($rsarr[$i][$j]); $str = ew_ConvertToUtf8($str); if (isset($post["keepCRLF"])) { $str = str_replace(array("\r", "\n"), array("\\r", "\\n"), $str); } else { $str = str_replace(array("\r", "\n"), array(" ", " "), $str); } $rsarr[$i][$j] = $str; } } return ew_ArrayToJson($rsarr); } else { return FALSE; } } // Table level events // Recordset Selecting event function Recordset_Selecting(&$filter) { // Enter your code here } // Recordset Selected event function Recordset_Selected(&$rs) { //echo "Recordset Selected"; } // Recordset Search Validated event function Recordset_SearchValidated() { // Example: //$this->MyField1->AdvancedSearch->SearchValue = "your search criteria"; // Search value } // Recordset Searching event function Recordset_Searching(&$filter) { // Enter your code here } // Row_Selecting event function Row_Selecting(&$filter) { // Enter your code here } // Row Selected event function Row_Selected(&$rs) { //echo "Row Selected"; } // Row Inserting event function Row_Inserting($rsold, &$rsnew) { // Enter your code here // To cancel, set return value to FALSE return TRUE; } // Row Inserted event function Row_Inserted($rsold, &$rsnew) { //echo "Row Inserted" } // Row Updating event function Row_Updating($rsold, &$rsnew) { // Enter your code here // To cancel, set return value to FALSE return TRUE; } // Row Updated event function Row_Updated($rsold, &$rsnew) { //echo "Row Updated"; } // Row Update Conflict event function Row_UpdateConflict($rsold, &$rsnew) { // Enter your code here // To ignore conflict, set return value to FALSE return TRUE; } // Grid Inserting event function Grid_Inserting() { // Enter your code here // To reject grid insert, set return value to FALSE return TRUE; } // Grid Inserted event function Grid_Inserted($rsnew) { //echo "Grid Inserted"; } // Grid Updating event function Grid_Updating($rsold) { // Enter your code here // To reject grid update, set return value to FALSE return TRUE; } // Grid Updated event function Grid_Updated($rsold, $rsnew) { //echo "Grid Updated"; } // Row Deleting event function Row_Deleting(&$rs) { // Enter your code here // To cancel, set return value to False return TRUE; } // Row Deleted event function Row_Deleted(&$rs) { //echo "Row Deleted"; } // Email Sending event function Email_Sending(&$Email, &$Args) { //var_dump($Email); var_dump($Args); exit(); return TRUE; } // Lookup Selecting event function Lookup_Selecting($fld, &$filter) { //var_dump($fld->FldName, $fld->LookupFilters, $filter); // Uncomment to view the filter // Enter your code here } // Row Rendering event function Row_Rendering() { // Enter your code here } // Row Rendered event function Row_Rendered() { // To view properties of field class, use: //var_dump($this->); } // User ID Filtering event function UserID_Filtering(&$filter) { // Enter your code here } } ?>