protected function CreateGrid() { $result = new Grid($this, $this->dataset, 'clientesGrid'); if ($this->GetSecurityInfo()->HasDeleteGrant()) { $result->SetAllowDeleteSelected(false); } else { $result->SetAllowDeleteSelected(false); } ApplyCommonPageSettings($this, $result); $result->SetUseImagesForActions(true); $result->SetUseFixedHeader(false); $result->SetShowLineNumbers(false); $result->SetHighlightRowAtHover(false); $result->SetWidth(''); $this->CreateGridSearchControl($result); $this->CreateGridAdvancedSearchControl($result); $this->AddFieldColumns($result); $this->AddSingleRecordViewColumns($result); $this->AddEditColumns($result); $this->AddInsertColumns($result); $this->AddPrintColumns($result); $this->AddExportColumns($result); $this->AddOperationsColumns($result); $this->SetShowPageList(true); $this->SetHidePageListByDefault(false); $this->SetExportToExcelAvailable(true); $this->SetExportToWordAvailable(true); $this->SetExportToXmlAvailable(true); $this->SetExportToCsvAvailable(true); $this->SetExportToPdfAvailable(true); $this->SetPrinterFriendlyAvailable(true); $this->SetSimpleSearchAvailable(true); $this->SetAdvancedSearchAvailable(true); $this->SetFilterRowAvailable(true); $this->SetVisualEffectsEnabled(true); $this->SetShowTopPageNavigator(true); $this->SetShowBottomPageNavigator(true); // // Http Handlers // // // View column for RazonSocial field // $column = new TextViewColumn('RazonSocial', 'RazonSocial', $this->dataset); $column->SetOrderable(true); /* <inline edit column> */ // // Edit column for RazonSocial field // $editor = new TextEdit('razonsocial_edit'); $editor->SetSize(100); $editor->SetMaxLength(100); $editColumn = new CustomEditColumn('RazonSocial', 'RazonSocial', $editor, $this->dataset); $validator = new RequiredValidator(StringUtils::Format($this->GetLocalizerCaptions()->GetMessageString('RequiredValidationMessage'), $this->RenderText($editColumn->GetCaption()))); $editor->GetValidatorCollection()->AddValidator($validator); $this->ApplyCommonColumnEditProperties($editColumn); $column->SetEditOperationColumn($editColumn); /* </inline edit column> */ /* <inline insert column> */ // // Edit column for RazonSocial field // $editor = new TextEdit('razonsocial_edit'); $editor->SetSize(100); $editor->SetMaxLength(100); $editColumn = new CustomEditColumn('RazonSocial', 'RazonSocial', $editor, $this->dataset); $validator = new RequiredValidator(StringUtils::Format($this->GetLocalizerCaptions()->GetMessageString('RequiredValidationMessage'), $this->RenderText($editColumn->GetCaption()))); $editor->GetValidatorCollection()->AddValidator($validator); $this->ApplyCommonColumnEditProperties($editColumn); $column->SetInsertOperationColumn($editColumn); /* </inline insert column> */ $handler = new ShowTextBlobHandler($this->dataset, $this, 'RazonSocial_handler', $column); GetApplication()->RegisterHTTPHandler($handler); $lookupDataset = new TableDataset(new MyConnectionFactory(), GetConnectionOptions(), '`cod_departamentos`'); $field = new IntegerField('Cod_dpto'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, true); $field = new StringField('Nombre'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, false); $lookupDataset->SetOrderBy('Nombre', GetOrderTypeAsSQL(otAscending)); $lookupDataset->AddCustomCondition(EnvVariablesUtils::EvaluateVariableTemplate($this->GetColumnVariableContainer(), '')); $handler = new DynamicSearchHandler($lookupDataset, $this, 'inline_edit_Cod_Dpto_Nombre_search', 'Cod_dpto', 'Nombre', null); GetApplication()->RegisterHTTPHandler($handler); $lookupDataset = new TableDataset(new MyConnectionFactory(), GetConnectionOptions(), '`cod_departamentos`'); $field = new IntegerField('Cod_dpto'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, true); $field = new StringField('Nombre'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, false); $lookupDataset->SetOrderBy('Nombre', GetOrderTypeAsSQL(otAscending)); $lookupDataset->AddCustomCondition(EnvVariablesUtils::EvaluateVariableTemplate($this->GetColumnVariableContainer(), '')); $handler = new DynamicSearchHandler($lookupDataset, $this, 'inline_insert_Cod_Dpto_Nombre_search', 'Cod_dpto', 'Nombre', null); GetApplication()->RegisterHTTPHandler($handler); $lookupDataset = new TableDataset(new MyConnectionFactory(), GetConnectionOptions(), '`cod_paises`'); $field = new IntegerField('Codigo'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, true); $field = new StringField('Pais'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, false); $lookupDataset->SetOrderBy('Pais', GetOrderTypeAsSQL(otAscending)); $lookupDataset->AddCustomCondition(EnvVariablesUtils::EvaluateVariableTemplate($this->GetColumnVariableContainer(), '')); $handler = new DynamicSearchHandler($lookupDataset, $this, 'inline_edit_Pais_Domicilio_Pais_search', 'Codigo', 'Pais', null); GetApplication()->RegisterHTTPHandler($handler); $lookupDataset = new TableDataset(new MyConnectionFactory(), GetConnectionOptions(), '`cod_paises`'); $field = new IntegerField('Codigo'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, true); $field = new StringField('Pais'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, false); $lookupDataset->SetOrderBy('Pais', GetOrderTypeAsSQL(otAscending)); $lookupDataset->AddCustomCondition(EnvVariablesUtils::EvaluateVariableTemplate($this->GetColumnVariableContainer(), '')); $handler = new DynamicSearchHandler($lookupDataset, $this, 'inline_insert_Pais_Domicilio_Pais_search', 'Codigo', 'Pais', null); GetApplication()->RegisterHTTPHandler($handler); // // View column for Telefono field // $column = new TextViewColumn('Telefono', 'Telefono', $this->dataset); $column->SetOrderable(true); /* <inline edit column> */ // // Edit column for Telefono field // $editor = new TextEdit('telefono_edit'); $editor->SetSize(100); $editor->SetMaxLength(100); $editColumn = new CustomEditColumn('Telefono', 'Telefono', $editor, $this->dataset); $validator = new RequiredValidator(StringUtils::Format($this->GetLocalizerCaptions()->GetMessageString('RequiredValidationMessage'), $this->RenderText($editColumn->GetCaption()))); $editor->GetValidatorCollection()->AddValidator($validator); $this->ApplyCommonColumnEditProperties($editColumn); $column->SetEditOperationColumn($editColumn); /* </inline edit column> */ /* <inline insert column> */ // // Edit column for Telefono field // $editor = new TextEdit('telefono_edit'); $editor->SetSize(100); $editor->SetMaxLength(100); $editColumn = new CustomEditColumn('Telefono', 'Telefono', $editor, $this->dataset); $validator = new RequiredValidator(StringUtils::Format($this->GetLocalizerCaptions()->GetMessageString('RequiredValidationMessage'), $this->RenderText($editColumn->GetCaption()))); $editor->GetValidatorCollection()->AddValidator($validator); $this->ApplyCommonColumnEditProperties($editColumn); $column->SetInsertOperationColumn($editColumn); /* </inline insert column> */ $handler = new ShowTextBlobHandler($this->dataset, $this, 'Telefono_handler', $column); GetApplication()->RegisterHTTPHandler($handler); // // View column for Contacto field // $column = new TextViewColumn('Contacto', 'Contacto', $this->dataset); $column->SetOrderable(true); /* <inline edit column> */ // // Edit column for Contacto field // $editor = new TextEdit('contacto_edit'); $editor->SetSize(100); $editor->SetMaxLength(100); $editColumn = new CustomEditColumn('Contacto', 'Contacto', $editor, $this->dataset); $editColumn->SetAllowSetToNull(true); $this->ApplyCommonColumnEditProperties($editColumn); $column->SetEditOperationColumn($editColumn); /* </inline edit column> */ /* <inline insert column> */ // // Edit column for Contacto field // $editor = new TextEdit('contacto_edit'); $editor->SetSize(100); $editor->SetMaxLength(100); $editColumn = new CustomEditColumn('Contacto', 'Contacto', $editor, $this->dataset); $editColumn->SetAllowSetToNull(true); $this->ApplyCommonColumnEditProperties($editColumn); $column->SetInsertOperationColumn($editColumn); /* </inline insert column> */ $handler = new ShowTextBlobHandler($this->dataset, $this, 'Contacto_handler', $column); GetApplication()->RegisterHTTPHandler($handler); // // View column for RazonSocial field // $column = new TextViewColumn('RazonSocial', 'RazonSocial', $this->dataset); $column->SetOrderable(true); $handler = new ShowTextBlobHandler($this->dataset, $this, 'RazonSocial_handler', $column); GetApplication()->RegisterHTTPHandler($handler); // // View column for Telefono field // $column = new TextViewColumn('Telefono', 'Telefono', $this->dataset); $column->SetOrderable(true); $handler = new ShowTextBlobHandler($this->dataset, $this, 'Telefono_handler', $column); GetApplication()->RegisterHTTPHandler($handler); // // View column for Contacto field // $column = new TextViewColumn('Contacto', 'Contacto', $this->dataset); $column->SetOrderable(true); $handler = new ShowTextBlobHandler($this->dataset, $this, 'Contacto_handler', $column); GetApplication()->RegisterHTTPHandler($handler); $lookupDataset = new TableDataset(new MyConnectionFactory(), GetConnectionOptions(), '`cod_departamentos`'); $field = new IntegerField('Cod_dpto'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, true); $field = new StringField('Nombre'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, false); $lookupDataset->SetOrderBy('Nombre', GetOrderTypeAsSQL(otAscending)); $lookupDataset->AddCustomCondition(EnvVariablesUtils::EvaluateVariableTemplate($this->GetColumnVariableContainer(), '')); $handler = new DynamicSearchHandler($lookupDataset, $this, 'edit_Cod_Dpto_Nombre_search', 'Cod_dpto', 'Nombre', null); GetApplication()->RegisterHTTPHandler($handler); $lookupDataset = new TableDataset(new MyConnectionFactory(), GetConnectionOptions(), '`cod_paises`'); $field = new IntegerField('Codigo'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, true); $field = new StringField('Pais'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, false); $lookupDataset->SetOrderBy('Pais', GetOrderTypeAsSQL(otAscending)); $lookupDataset->AddCustomCondition(EnvVariablesUtils::EvaluateVariableTemplate($this->GetColumnVariableContainer(), '')); $handler = new DynamicSearchHandler($lookupDataset, $this, 'edit_Pais_Domicilio_Pais_search', 'Codigo', 'Pais', null); GetApplication()->RegisterHTTPHandler($handler); $lookupDataset = new TableDataset(new MyConnectionFactory(), GetConnectionOptions(), '`cod_departamentos`'); $field = new IntegerField('Cod_dpto'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, true); $field = new StringField('Nombre'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, false); $lookupDataset->SetOrderBy('Nombre', GetOrderTypeAsSQL(otAscending)); $lookupDataset->AddCustomCondition(EnvVariablesUtils::EvaluateVariableTemplate($this->GetColumnVariableContainer(), '')); $handler = new DynamicSearchHandler($lookupDataset, $this, 'insert_Cod_Dpto_Nombre_search', 'Cod_dpto', 'Nombre', null); GetApplication()->RegisterHTTPHandler($handler); $lookupDataset = new TableDataset(new MyConnectionFactory(), GetConnectionOptions(), '`cod_paises`'); $field = new IntegerField('Codigo'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, true); $field = new StringField('Pais'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, false); $lookupDataset->SetOrderBy('Pais', GetOrderTypeAsSQL(otAscending)); $lookupDataset->AddCustomCondition(EnvVariablesUtils::EvaluateVariableTemplate($this->GetColumnVariableContainer(), '')); $handler = new DynamicSearchHandler($lookupDataset, $this, 'insert_Pais_Domicilio_Pais_search', 'Codigo', 'Pais', null); GetApplication()->RegisterHTTPHandler($handler); return $result; }
protected function AddInsertColumns(Grid $grid) { // // Edit column for program_name field // $editor = new TextEdit('program_name_edit'); $editor->SetSize(50); $editor->SetMaxLength(50); $editColumn = new CustomEditColumn(' Name', 'program_name', $editor, $this->dataset); $validator = new RequiredValidator(StringUtils::Format($this->GetLocalizerCaptions()->GetMessageString('RequiredValidationMessage'), $this->RenderText($editColumn->GetCaption()))); $editor->GetValidatorCollection()->AddValidator($validator); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); // // Edit column for description field // $editor = new TextAreaEdit('description_edit', 50, 8); $editColumn = new CustomEditColumn('Description', 'description', $editor, $this->dataset); $editColumn->SetAllowSetToNull(true); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); // // Edit column for lead field // $editor = new ComboBox('lead_edit', $this->GetLocalizerCaptions()->GetMessageString('PleaseSelect')); $lookupDataset = new TableDataset(new MyConnectionFactory(), GetConnectionOptions(), '`staff`'); $field = new IntegerField('staff_id', null, null, true); $field->SetIsNotNull(true); $lookupDataset->AddField($field, true); $field = new StringField('username'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, false); $field = new StringField('email'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, false); $field = new StringField('picture'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, false); $field = new StringField('password'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, false); $field = new IntegerField('dept_id'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, false); $field = new StringField('position'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, false); $field = new StringField('emp_number'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, false); $lookupDataset->SetOrderBy('username', GetOrderTypeAsSQL(otAscending)); $editColumn = new LookUpEditColumn('Lead', 'lead', $editor, $this->dataset, 'username', 'username', $lookupDataset); $editColumn->SetCaptionTemplate($this->RenderText('%username%')); $validator = new RequiredValidator(StringUtils::Format($this->GetLocalizerCaptions()->GetMessageString('RequiredValidationMessage'), $this->RenderText($editColumn->GetCaption()))); $editor->GetValidatorCollection()->AddValidator($validator); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); // // Edit column for date_start field // $editor = new DateTimeEdit('date_start_edit', false, 'Y-m-d', GetFirstDayOfWeek()); $editColumn = new CustomEditColumn('Date Start', 'date_start', $editor, $this->dataset); $editColumn->SetInsertDefaultValue($this->RenderText('%CURRENT_DATE%')); $validator = new RequiredValidator(StringUtils::Format($this->GetLocalizerCaptions()->GetMessageString('RequiredValidationMessage'), $this->RenderText($editColumn->GetCaption()))); $editor->GetValidatorCollection()->AddValidator($validator); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); // // Edit column for date_end field // $editor = new DateTimeEdit('date_end_edit', false, 'Y-m-d', GetFirstDayOfWeek()); $editColumn = new CustomEditColumn('Date End', 'date_end', $editor, $this->dataset); $editColumn->SetInsertDefaultValue($this->RenderText('%CURRENT_DATE%')); $validator = new RequiredValidator(StringUtils::Format($this->GetLocalizerCaptions()->GetMessageString('RequiredValidationMessage'), $this->RenderText($editColumn->GetCaption()))); $editor->GetValidatorCollection()->AddValidator($validator); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); if ($this->GetSecurityInfo()->HasAddGrant()) { $grid->SetShowAddButton(true); $grid->SetShowInlineAddButton(false); } else { $grid->SetShowInlineAddButton(false); $grid->SetShowAddButton(false); } }
protected function AddInsertColumns(Grid $grid) { // // Edit column for FEC_WINK field // $editor = new DateTimeEdit('fec_wink_edit', false, 'Y-m-d H:i:s', GetFirstDayOfWeek()); $editColumn = new CustomEditColumn('FEC WINK', 'FEC_WINK', $editor, $this->dataset); $validator = new RequiredValidator(StringUtils::Format($this->GetLocalizerCaptions()->GetMessageString('RequiredValidationMessage'), $this->RenderText($editColumn->GetCaption()))); $editor->GetValidatorCollection()->AddValidator($validator); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); // // Edit column for USERNAME_EMISOR field // $editor = new ComboBox('username_emisor_edit', $this->GetLocalizerCaptions()->GetMessageString('PleaseSelect')); $lookupDataset = new TableDataset(new OracleConnectionFactory(), GetConnectionOptions(), '"GE"."PERSONA"'); $field = new StringField('USERNAME'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, true); $field = new StringField('ES_ADMIN'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, false); $field = new DateField('NACIMIENTO'); $lookupDataset->AddField($field, false); $field = new StringField('PRIMER_APELLIDO'); $lookupDataset->AddField($field, false); $field = new StringField('SEGUNDO_APELLIDO'); $lookupDataset->AddField($field, false); $field = new StringField('NOMBRE'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, false); $field = new IntegerField('GENERO_ID'); $lookupDataset->AddField($field, false); $field = new IntegerField('CIUDAD_ID'); $lookupDataset->AddField($field, false); $field = new StringField('SLOGAN'); $lookupDataset->AddField($field, false); $field = new DateField('FEC_CREACION'); $lookupDataset->AddField($field, false); $field = new StringField('USUARIO_CREACION'); $lookupDataset->AddField($field, false); $field = new DateField('FEC_ULTIMA_MOD'); $lookupDataset->AddField($field, false); $field = new StringField('USUARIO_ULTIMA_MOD'); $lookupDataset->AddField($field, false); $field = new StringField('EMAIL'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, false); $field = new StringField('CLAVE'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, false); $lookupDataset->SetOrderBy('ES_ADMIN', GetOrderTypeAsSQL(otAscending)); $editColumn = new LookUpEditColumn('USERNAME EMISOR', 'USERNAME_EMISOR', $editor, $this->dataset, 'USERNAME', 'ES_ADMIN', $lookupDataset); $validator = new RequiredValidator(StringUtils::Format($this->GetLocalizerCaptions()->GetMessageString('RequiredValidationMessage'), $this->RenderText($editColumn->GetCaption()))); $editor->GetValidatorCollection()->AddValidator($validator); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); // // Edit column for USERNAME_RECEPTOR field // $editor = new ComboBox('username_receptor_edit', $this->GetLocalizerCaptions()->GetMessageString('PleaseSelect')); $lookupDataset = new TableDataset(new OracleConnectionFactory(), GetConnectionOptions(), '"GE"."PERSONA"'); $field = new StringField('USERNAME'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, true); $field = new StringField('ES_ADMIN'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, false); $field = new DateField('NACIMIENTO'); $lookupDataset->AddField($field, false); $field = new StringField('PRIMER_APELLIDO'); $lookupDataset->AddField($field, false); $field = new StringField('SEGUNDO_APELLIDO'); $lookupDataset->AddField($field, false); $field = new StringField('NOMBRE'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, false); $field = new IntegerField('GENERO_ID'); $lookupDataset->AddField($field, false); $field = new IntegerField('CIUDAD_ID'); $lookupDataset->AddField($field, false); $field = new StringField('SLOGAN'); $lookupDataset->AddField($field, false); $field = new DateField('FEC_CREACION'); $lookupDataset->AddField($field, false); $field = new StringField('USUARIO_CREACION'); $lookupDataset->AddField($field, false); $field = new DateField('FEC_ULTIMA_MOD'); $lookupDataset->AddField($field, false); $field = new StringField('USUARIO_ULTIMA_MOD'); $lookupDataset->AddField($field, false); $field = new StringField('EMAIL'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, false); $field = new StringField('CLAVE'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, false); $lookupDataset->SetOrderBy('ES_ADMIN', GetOrderTypeAsSQL(otAscending)); $editColumn = new LookUpEditColumn('USERNAME RECEPTOR', 'USERNAME_RECEPTOR', $editor, $this->dataset, 'USERNAME', 'ES_ADMIN', $lookupDataset); $validator = new RequiredValidator(StringUtils::Format($this->GetLocalizerCaptions()->GetMessageString('RequiredValidationMessage'), $this->RenderText($editColumn->GetCaption()))); $editor->GetValidatorCollection()->AddValidator($validator); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); if ($this->GetSecurityInfo()->HasAddGrant()) { $grid->SetShowAddButton(true); $grid->SetShowInlineAddButton(false); } else { $grid->SetShowInlineAddButton(false); $grid->SetShowAddButton(false); } }
protected function AddInsertColumns(Grid $grid) { // // Edit column for project_name field // $editor = new TextEdit('project_name_edit'); $editColumn = new CustomEditColumn('Project Name', 'project_name', $editor, $this->dataset); $validator = new RequiredValidator(StringUtils::Format($this->GetLocalizerCaptions()->GetMessageString('RequiredValidationMessage'), $this->RenderText($editColumn->GetCaption()))); $editor->GetValidatorCollection()->AddValidator($validator); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); // // Edit column for approved_budget field // $editor = new TextEdit('approved_budget_edit'); $editColumn = new CustomEditColumn('Approved Budget', 'approved_budget', $editor, $this->dataset); $editColumn->SetAllowSetToNull(true); $validator = new NumberValidator(StringUtils::Format($this->GetLocalizerCaptions()->GetMessageString('NumberValidationMessage'), $this->RenderText($editColumn->GetCaption()))); $editor->GetValidatorCollection()->AddValidator($validator); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); // // Edit column for lead field // $editor = new ComboBox('lead_edit', $this->GetLocalizerCaptions()->GetMessageString('PleaseSelect')); $lookupDataset = new TableDataset(new MyConnectionFactory(), GetConnectionOptions(), '`staff`'); $field = new IntegerField('staff_id', null, null, true); $field->SetIsNotNull(true); $lookupDataset->AddField($field, true); $field = new StringField('username'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, false); $field = new StringField('email'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, false); $field = new StringField('picture'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, false); $field = new StringField('password'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, false); $field = new IntegerField('dept_id'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, false); $field = new StringField('position'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, false); $field = new StringField('emp_number'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, false); $lookupDataset->SetOrderBy('username', GetOrderTypeAsSQL(otAscending)); $editColumn = new LookUpEditColumn('Lead', 'lead', $editor, $this->dataset, 'staff_id', 'username', $lookupDataset); $validator = new RequiredValidator(StringUtils::Format($this->GetLocalizerCaptions()->GetMessageString('RequiredValidationMessage'), $this->RenderText($editColumn->GetCaption()))); $editor->GetValidatorCollection()->AddValidator($validator); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); if ($this->GetSecurityInfo()->HasAddGrant()) { $grid->SetShowAddButton(false); $grid->SetShowInlineAddButton(false); } else { $grid->SetShowInlineAddButton(false); $grid->SetShowAddButton(false); } }
protected function AddInsertColumns(Grid $grid) { // // Edit column for office_id field // $editor = new ComboBox('office_id_edit', $this->GetLocalizerCaptions()->GetMessageString('PleaseSelect')); $lookupDataset = new TableDataset(new PgConnectionFactory(), GetConnectionOptions(), '"public"."office"'); $field = new IntegerField('id'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, true); $field = new StringField('title'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, false); $field = new IntegerField('num_positions'); $lookupDataset->AddField($field, false); $field = new StringField('responsibilities'); $lookupDataset->AddField($field, false); $field = new IntegerField('term_length_months'); $lookupDataset->AddField($field, false); $field = new StringField('filing_fee'); $lookupDataset->AddField($field, false); $field = new BooleanField('partisan'); $lookupDataset->AddField($field, false); $field = new StringField('age_requirements'); $lookupDataset->AddField($field, false); $field = new StringField('res_requirements'); $lookupDataset->AddField($field, false); $field = new StringField('prof_requirements'); $lookupDataset->AddField($field, false); $field = new IntegerField('salary'); $lookupDataset->AddField($field, false); $field = new StringField('notes'); $lookupDataset->AddField($field, false); $field = new IntegerField('office_rank'); $lookupDataset->AddField($field, false); $lookupDataset->SetOrderBy('title', GetOrderTypeAsSQL(otAscending)); $editColumn = new LookUpEditColumn('Office Title', 'office_id', $editor, $this->dataset, 'id', 'title', $lookupDataset); $editColumn->SetAllowSetToNull(true); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); // // Edit column for name field // $editor = new TextEdit('name_edit'); $editor->SetSize(35); $editor->SetMaxLength(35); $editColumn = new CustomEditColumn('Document Name or Description', 'name', $editor, $this->dataset); $validator = new RequiredValidator(StringUtils::Format($this->GetLocalizerCaptions()->GetMessageString('RequiredValidationMessage'), $this->RenderText($editColumn->GetCaption()))); $editor->GetValidatorCollection()->AddValidator($validator); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); // // Edit column for link field // $editor = new TextAreaEdit('link_edit', 50, 8); $editColumn = new CustomEditColumn('URL to Document', 'link', $editor, $this->dataset); $validator = new RequiredValidator(StringUtils::Format($this->GetLocalizerCaptions()->GetMessageString('RequiredValidationMessage'), $this->RenderText($editColumn->GetCaption()))); $editor->GetValidatorCollection()->AddValidator($validator); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); if ($this->GetSecurityInfo()->HasAddGrant()) { $grid->SetShowAddButton(true); $grid->SetShowInlineAddButton(false); } else { $grid->SetShowInlineAddButton(false); $grid->SetShowAddButton(false); } }
protected function AddInsertColumns(Grid $grid) { // // Edit column for USERNAME field // $editor = new TextEdit('username_edit'); $editor->SetSize(10); $editor->SetMaxLength(10); $editColumn = new CustomEditColumn('USERNAME', 'USERNAME', $editor, $this->dataset); $editColumn->SetAllowSetToNull(true); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); // // Edit column for ES_REAL field // $editor = new TextEdit('es_real_edit'); $editor->SetSize(1); $editor->SetMaxLength(1); $editColumn = new CustomEditColumn('ES REAL', 'ES_REAL', $editor, $this->dataset); $editColumn->SetAllowSetToNull(true); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); // // Edit column for EJERCICIO_ID field // $editor = new ComboBox('ejercicio_id_edit', $this->GetLocalizerCaptions()->GetMessageString('PleaseSelect')); $lookupDataset = new TableDataset(new OracleConnectionFactory(), GetConnectionOptions(), '"GE"."EJERCICIO"'); $field = new IntegerField('EJERCICIO_ID'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, true); $field = new StringField('NOMBRE'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, false); $field = new DateField('FEC_CREACION'); $lookupDataset->AddField($field, false); $field = new StringField('USUARIO_CREACION'); $lookupDataset->AddField($field, false); $field = new DateField('FEC_ULTIMA_MOD'); $lookupDataset->AddField($field, false); $field = new StringField('USUARIO_ULTIMA_MOD'); $lookupDataset->AddField($field, false); $lookupDataset->SetOrderBy('NOMBRE', GetOrderTypeAsSQL(otAscending)); $editColumn = new LookUpEditColumn('EJERCICIO ID', 'EJERCICIO_ID', $editor, $this->dataset, 'EJERCICIO_ID', 'NOMBRE', $lookupDataset); $editColumn->SetAllowSetToNull(true); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); if ($this->GetSecurityInfo()->HasAddGrant()) { $grid->SetShowAddButton(true); $grid->SetShowInlineAddButton(false); } else { $grid->SetShowInlineAddButton(false); $grid->SetShowAddButton(false); } }
protected function AddInsertColumns(Grid $grid) { // // Edit column for Fecha field // $editor = new TextEdit('fecha_edit'); $editColumn = new CustomEditColumn('Fecha', 'Fecha', $editor, $this->dataset); $validator = new RequiredValidator(StringUtils::Format($this->GetLocalizerCaptions()->GetMessageString('RequiredValidationMessage'), $this->RenderText($editColumn->GetCaption()))); $editor->GetValidatorCollection()->AddValidator($validator); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); // // Edit column for Tipo_Documento_Intero field // $editor = new TextEdit('tipo_documento_intero_edit'); $editor->SetSize(45); $editor->SetMaxLength(45); $editColumn = new CustomEditColumn('Tipo Documento Intero', 'Tipo_Documento_Intero', $editor, $this->dataset); $validator = new RequiredValidator(StringUtils::Format($this->GetLocalizerCaptions()->GetMessageString('RequiredValidationMessage'), $this->RenderText($editColumn->GetCaption()))); $editor->GetValidatorCollection()->AddValidator($validator); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); // // Edit column for Num_Documento_Interno field // $editor = new TextEdit('num_documento_interno_edit'); $editor->SetSize(45); $editor->SetMaxLength(45); $editColumn = new CustomEditColumn('Num Documento Interno', 'Num_Documento_Interno', $editor, $this->dataset); $validator = new RequiredValidator(StringUtils::Format($this->GetLocalizerCaptions()->GetMessageString('RequiredValidationMessage'), $this->RenderText($editColumn->GetCaption()))); $editor->GetValidatorCollection()->AddValidator($validator); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); // // Edit column for Tercero_Tipo_Documento field // $editor = new AutocomleteComboBox('tercero_tipo_documento_edit', $this->CreateLinkBuilder()); $editor->SetSize('250px'); $editColumn = new CustomEditColumn('Tercero Tipo Documento', 'Tercero_Tipo_Documento', $editor, $this->dataset); $validator = new RequiredValidator(StringUtils::Format($this->GetLocalizerCaptions()->GetMessageString('RequiredValidationMessage'), $this->RenderText($editColumn->GetCaption()))); $editor->GetValidatorCollection()->AddValidator($validator); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); // // Edit column for Tercero_Identificacion field // $editor = new TextEdit('tercero_identificacion_edit'); $editor->SetSize(45); $editor->SetMaxLength(45); $editColumn = new CustomEditColumn('Tercero Identificacion', 'Tercero_Identificacion', $editor, $this->dataset); $validator = new RequiredValidator(StringUtils::Format($this->GetLocalizerCaptions()->GetMessageString('RequiredValidationMessage'), $this->RenderText($editColumn->GetCaption()))); $editor->GetValidatorCollection()->AddValidator($validator); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); // // Edit column for Tercero_DV field // $editor = new TextEdit('tercero_dv_edit'); $editor->SetSize(3); $editor->SetMaxLength(3); $editColumn = new CustomEditColumn('Tercero DV', 'Tercero_DV', $editor, $this->dataset); $editColumn->SetAllowSetToNull(true); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); // // Edit column for Tercero_Primer_Apellido field // $editor = new TextEdit('tercero_primer_apellido_edit'); $editor->SetSize(45); $editor->SetMaxLength(45); $editColumn = new CustomEditColumn('Tercero Primer Apellido', 'Tercero_Primer_Apellido', $editor, $this->dataset); $editColumn->SetAllowSetToNull(true); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); // // Edit column for Tercero_Segundo_Apellido field // $editor = new TextEdit('tercero_segundo_apellido_edit'); $editor->SetSize(45); $editor->SetMaxLength(45); $editColumn = new CustomEditColumn('Tercero Segundo Apellido', 'Tercero_Segundo_Apellido', $editor, $this->dataset); $editColumn->SetAllowSetToNull(true); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); // // Edit column for Tercero_Primer_Nombre field // $editor = new TextEdit('tercero_primer_nombre_edit'); $editor->SetSize(45); $editor->SetMaxLength(45); $editColumn = new CustomEditColumn('Tercero Primer Nombre', 'Tercero_Primer_Nombre', $editor, $this->dataset); $editColumn->SetAllowSetToNull(true); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); // // Edit column for Tercero_Otros_Nombres field // $editor = new TextEdit('tercero_otros_nombres_edit'); $editor->SetSize(45); $editor->SetMaxLength(45); $editColumn = new CustomEditColumn('Tercero Otros Nombres', 'Tercero_Otros_Nombres', $editor, $this->dataset); $editColumn->SetAllowSetToNull(true); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); // // Edit column for Tercero_Razon_Social field // $editor = new TextEdit('tercero_razon_social_edit'); $editor->SetSize(100); $editor->SetMaxLength(100); $editColumn = new CustomEditColumn('Tercero Razon Social', 'Tercero_Razon_Social', $editor, $this->dataset); $validator = new RequiredValidator(StringUtils::Format($this->GetLocalizerCaptions()->GetMessageString('RequiredValidationMessage'), $this->RenderText($editColumn->GetCaption()))); $editor->GetValidatorCollection()->AddValidator($validator); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); // // Edit column for Tercero_Direccion field // $editor = new TextEdit('tercero_direccion_edit'); $editor->SetSize(100); $editor->SetMaxLength(100); $editColumn = new CustomEditColumn('Tercero Direccion', 'Tercero_Direccion', $editor, $this->dataset); $validator = new RequiredValidator(StringUtils::Format($this->GetLocalizerCaptions()->GetMessageString('RequiredValidationMessage'), $this->RenderText($editColumn->GetCaption()))); $editor->GetValidatorCollection()->AddValidator($validator); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); // // Edit column for Tercero_Cod_Dpto field // $editor = new TextEdit('tercero_cod_dpto_edit'); $editColumn = new CustomEditColumn('Tercero Cod Dpto', 'Tercero_Cod_Dpto', $editor, $this->dataset); $validator = new RequiredValidator(StringUtils::Format($this->GetLocalizerCaptions()->GetMessageString('RequiredValidationMessage'), $this->RenderText($editColumn->GetCaption()))); $editor->GetValidatorCollection()->AddValidator($validator); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); // // Edit column for Tercero_Cod_Mcipio field // $editor = new TextEdit('tercero_cod_mcipio_edit'); $editor->SetSize(10); $editor->SetMaxLength(10); $editColumn = new CustomEditColumn('Tercero Cod Mcipio', 'Tercero_Cod_Mcipio', $editor, $this->dataset); $validator = new RequiredValidator(StringUtils::Format($this->GetLocalizerCaptions()->GetMessageString('RequiredValidationMessage'), $this->RenderText($editColumn->GetCaption()))); $editor->GetValidatorCollection()->AddValidator($validator); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); // // Edit column for Tercero_Pais_Domicilio field // $editor = new TextEdit('tercero_pais_domicilio_edit'); $editor->SetSize(10); $editor->SetMaxLength(10); $editColumn = new CustomEditColumn('Tercero Pais Domicilio', 'Tercero_Pais_Domicilio', $editor, $this->dataset); $validator = new RequiredValidator(StringUtils::Format($this->GetLocalizerCaptions()->GetMessageString('RequiredValidationMessage'), $this->RenderText($editColumn->GetCaption()))); $editor->GetValidatorCollection()->AddValidator($validator); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); // // Edit column for Concepto field // $editor = new TextAreaEdit('concepto_edit', 50, 8); $editColumn = new CustomEditColumn('Concepto', 'Concepto', $editor, $this->dataset); $validator = new RequiredValidator(StringUtils::Format($this->GetLocalizerCaptions()->GetMessageString('RequiredValidationMessage'), $this->RenderText($editColumn->GetCaption()))); $editor->GetValidatorCollection()->AddValidator($validator); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); // // Edit column for CuentaPUC field // $editor = new TextEdit('cuentapuc_edit'); $editor->SetSize(45); $editor->SetMaxLength(45); $editColumn = new CustomEditColumn('CuentaPUC', 'CuentaPUC', $editor, $this->dataset); $validator = new RequiredValidator(StringUtils::Format($this->GetLocalizerCaptions()->GetMessageString('RequiredValidationMessage'), $this->RenderText($editColumn->GetCaption()))); $editor->GetValidatorCollection()->AddValidator($validator); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); // // Edit column for NombreCuenta field // $editor = new TextEdit('nombrecuenta_edit'); $editor->SetSize(45); $editor->SetMaxLength(45); $editColumn = new CustomEditColumn('NombreCuenta', 'NombreCuenta', $editor, $this->dataset); $validator = new RequiredValidator(StringUtils::Format($this->GetLocalizerCaptions()->GetMessageString('RequiredValidationMessage'), $this->RenderText($editColumn->GetCaption()))); $editor->GetValidatorCollection()->AddValidator($validator); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); // // Edit column for Detalle field // $editor = new TextEdit('detalle_edit'); $editor->SetSize(45); $editor->SetMaxLength(45); $editColumn = new CustomEditColumn('Detalle', 'Detalle', $editor, $this->dataset); $validator = new RequiredValidator(StringUtils::Format($this->GetLocalizerCaptions()->GetMessageString('RequiredValidationMessage'), $this->RenderText($editColumn->GetCaption()))); $editor->GetValidatorCollection()->AddValidator($validator); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); // // Edit column for Debito field // $editor = new TextEdit('debito_edit'); $editor->SetSize(45); $editor->SetMaxLength(45); $editColumn = new CustomEditColumn('Debito', 'Debito', $editor, $this->dataset); $validator = new RequiredValidator(StringUtils::Format($this->GetLocalizerCaptions()->GetMessageString('RequiredValidationMessage'), $this->RenderText($editColumn->GetCaption()))); $editor->GetValidatorCollection()->AddValidator($validator); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); // // Edit column for Credito field // $editor = new TextEdit('credito_edit'); $editor->SetSize(45); $editor->SetMaxLength(45); $editColumn = new CustomEditColumn('Credito', 'Credito', $editor, $this->dataset); $validator = new RequiredValidator(StringUtils::Format($this->GetLocalizerCaptions()->GetMessageString('RequiredValidationMessage'), $this->RenderText($editColumn->GetCaption()))); $editor->GetValidatorCollection()->AddValidator($validator); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); // // Edit column for Neto field // $editor = new TextEdit('neto_edit'); $editor->SetSize(45); $editor->SetMaxLength(45); $editColumn = new CustomEditColumn('Neto', 'Neto', $editor, $this->dataset); $validator = new RequiredValidator(StringUtils::Format($this->GetLocalizerCaptions()->GetMessageString('RequiredValidationMessage'), $this->RenderText($editColumn->GetCaption()))); $editor->GetValidatorCollection()->AddValidator($validator); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); // // Edit column for Mayor field // $editor = new ComboBox('mayor_edit', $this->GetLocalizerCaptions()->GetMessageString('PleaseSelect')); $editor->AddValue('NO', $this->RenderText('NO')); $editor->AddValue('SI', $this->RenderText('SI')); $editColumn = new CustomEditColumn('Mayor', 'Mayor', $editor, $this->dataset); $editColumn->SetAllowSetToNull(true); $editColumn->SetInsertDefaultValue($this->RenderText('NO')); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); // // Edit column for servicio_id field // $editor = new ComboBox('servicio_id_edit', $this->GetLocalizerCaptions()->GetMessageString('PleaseSelect')); $lookupDataset = new TableDataset(new MyConnectionFactory(), GetConnectionOptions(), '`servicio`'); $field = new IntegerField('id', null, null, true); $field->SetIsNotNull(true); $lookupDataset->AddField($field, true); $field = new IntegerField('empresa_id'); $lookupDataset->AddField($field, false); $field = new StringField('nombre'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, false); $field = new StringField('estado'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, false); $lookupDataset->SetOrderBy('nombre', GetOrderTypeAsSQL(otAscending)); $editColumn = new LookUpEditColumn('Servicio Id', 'servicio_id', $editor, $this->dataset, 'id', 'nombre', $lookupDataset); $editColumn->SetAllowSetToNull(true); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); // // Edit column for empresa_id field // $editor = new TextEdit('empresa_id_edit'); $editColumn = new CustomEditColumn('Empresa Id', 'empresa_id', $editor, $this->dataset); $editColumn->SetAllowSetToNull(true); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); if ($this->GetSecurityInfo()->HasAddGrant()) { $grid->SetShowAddButton(true); $grid->SetShowInlineAddButton(false); } else { $grid->SetShowInlineAddButton(false); $grid->SetShowAddButton(false); } }
protected function AddInsertColumns(Grid $grid) { // // Edit column for district_id field // $editor = new MultiLevelComboBoxEditor('district_id_edit', $this->CreateLinkBuilder()); $dataset0 = new TableDataset(new PgConnectionFactory(), GetConnectionOptions(), '"public"."state"'); $field = new StringField('abbr'); $field->SetIsNotNull(true); $dataset0->AddField($field, true); $field = new StringField('name'); $dataset0->AddField($field, false); $editor->AddLevel($dataset0, 'abbr', 'name', $this->RenderText('State'), null); $dataset1 = new TableDataset(new PgConnectionFactory(), GetConnectionOptions(), '"public"."district"'); $field = new IntegerField('id'); $field->SetIsNotNull(true); $dataset1->AddField($field, true); $field = new StringField('state'); $dataset1->AddField($field, false); $field = new StringField('name'); $dataset1->AddField($field, false); $field = new StringField('level_id'); $dataset1->AddField($field, false); $field = new IntegerField('election_div_id'); $dataset1->AddField($field, false); $editor->AddLevel($dataset1, 'id', 'name', $this->RenderText('Political District Name'), new ForeignKeyInfo('abbr', 'state')); $editColumn = new MultiLevelLookupEditColumn('Political District Name', 'district_id', $editor, $this->dataset); $editColumn->SetAllowSetToNull(true); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); // // Edit column for office_id field // $editor = new MultiLevelComboBoxEditor('office_id_edit', $this->CreateLinkBuilder()); $dataset0 = new TableDataset(new PgConnectionFactory(), GetConnectionOptions(), '"public"."state"'); $field = new StringField('abbr'); $field->SetIsNotNull(true); $dataset0->AddField($field, true); $field = new StringField('name'); $dataset0->AddField($field, false); $editor->AddLevel($dataset0, 'abbr', 'name', $this->RenderText('State'), null); $selectQuery = 'SELECT op.id office_id, o.title office_title, ed.id election_div_id, ed.name ed_name, ed.phys_addr_state state, concat(d.name, \' - \', o.title) officeTitle FROM office_position op JOIN district d ON op.district_id = d.id JOIN election_div ed ON d.election_div_id = ed.id JOIN office o ON op.office_id = o.id'; $insertQuery = array(); $updateQuery = array(); $deleteQuery = array(); $dataset1 = new QueryDataset(new PgConnectionFactory(), GetConnectionOptions(), $selectQuery, $insertQuery, $updateQuery, $deleteQuery, 'office_title_by_election_div'); $field = new IntegerField('office_id'); $dataset1->AddField($field, false); $field = new StringField('office_title'); $dataset1->AddField($field, false); $field = new IntegerField('election_div_id'); $dataset1->AddField($field, true); $field = new StringField('ed_name'); $dataset1->AddField($field, false); $field = new StringField('state'); $dataset1->AddField($field, false); $field = new StringField('officetitle'); $dataset1->AddField($field, false); $editor->AddLevel($dataset1, 'election_div_id', 'election_div_name', $this->RenderText('Election Division'), new ForeignKeyInfo('abbr', 'election_div_state')); $dataset2 = new TableDataset(new PgConnectionFactory(), GetConnectionOptions(), '"public"."office"'); $field = new IntegerField('id'); $field->SetIsNotNull(true); $dataset2->AddField($field, true); $field = new StringField('title'); $field->SetIsNotNull(true); $dataset2->AddField($field, false); $field = new IntegerField('num_positions'); $dataset2->AddField($field, false); $field = new StringField('responsibilities'); $dataset2->AddField($field, false); $field = new IntegerField('term_length_months'); $dataset2->AddField($field, false); $field = new StringField('filing_fee'); $dataset2->AddField($field, false); $field = new BooleanField('partisan'); $dataset2->AddField($field, false); $field = new StringField('age_requirements'); $dataset2->AddField($field, false); $field = new StringField('res_requirements'); $dataset2->AddField($field, false); $field = new StringField('prof_requirements'); $dataset2->AddField($field, false); $field = new IntegerField('salary'); $dataset2->AddField($field, false); $field = new StringField('notes'); $dataset2->AddField($field, false); $field = new IntegerField('office_rank'); $dataset2->AddField($field, false); $dataset2->SetOrderBy('title', GetOrderTypeAsSQL(otAscending)); $editor->AddLevel($dataset2, 'id', 'title', $this->RenderText('Office Title'), new ForeignKeyInfo('election_div_id', 'election_div_id')); $editColumn = new MultiLevelLookupEditColumn('Office Title', 'office_id', $editor, $this->dataset); $editColumn->SetAllowSetToNull(true); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); // // Edit column for office_holder_id field // $editor = new MultiLevelComboBoxEditor('office_holder_id_edit', $this->CreateLinkBuilder()); $dataset0 = new TableDataset(new PgConnectionFactory(), GetConnectionOptions(), '"public"."state"'); $field = new StringField('abbr'); $field->SetIsNotNull(true); $dataset0->AddField($field, true); $field = new StringField('name'); $dataset0->AddField($field, false); $editor->AddLevel($dataset0, 'abbr', 'name', $this->RenderText('State'), null); $selectQuery = 'SELECT oh.id, oh.state, concat(oh.last_name, \', \', oh.first_name, \' \', oh.middle_name) AS fullName FROM office_holder oh ORDER BY oh.last_name, oh.first_name'; $insertQuery = array(); $updateQuery = array(); $deleteQuery = array(); $dataset1 = new QueryDataset(new PgConnectionFactory(), GetConnectionOptions(), $selectQuery, $insertQuery, $updateQuery, $deleteQuery, 'officeHolderIDs'); $field = new IntegerField('id'); $dataset1->AddField($field, false); $field = new StringField('state'); $dataset1->AddField($field, false); $field = new StringField('fullname'); $dataset1->AddField($field, false); $dataset1->SetOrderBy('fullname', GetOrderTypeAsSQL(otAscending)); $editor->AddLevel($dataset1, 'id', 'fullname', $this->RenderText('Office Holder Id'), new ForeignKeyInfo('abbr', 'state')); $editColumn = new MultiLevelLookupEditColumn('Office Holder Id', 'office_holder_id', $editor, $this->dataset); $editColumn->SetAllowSetToNull(true); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); // // Edit column for position_name field // $editor = new TextEdit('position_name_edit'); $editor->SetSize(25); $editor->SetMaxLength(25); $editColumn = new CustomEditColumn('Position Name', 'position_name', $editor, $this->dataset); $editColumn->SetAllowSetToNull(true); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); // // Edit column for term_start field // $editor = new DateTimeEdit('term_start_edit', false, 'Y-m-d H:i:s', GetFirstDayOfWeek()); $editColumn = new CustomEditColumn('Term Start', 'term_start', $editor, $this->dataset); $editColumn->SetAllowSetToNull(true); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); // // Edit column for term_end field // $editor = new DateTimeEdit('term_end_edit', false, 'Y-m-d H:i:s', GetFirstDayOfWeek()); $editColumn = new CustomEditColumn('Term End', 'term_end', $editor, $this->dataset); $editColumn->SetAllowSetToNull(true); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); // // Edit column for filing_deadline field // $editor = new DateTimeEdit('filing_deadline_edit', false, 'Y-m-d H:i:s', GetFirstDayOfWeek()); $editColumn = new CustomEditColumn('Filing Deadline', 'filing_deadline', $editor, $this->dataset); $editColumn->SetAllowSetToNull(true); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); // // Edit column for next_election field // $editor = new DateTimeEdit('next_election_edit', false, 'Y-m-d H:i:s', GetFirstDayOfWeek()); $editColumn = new CustomEditColumn('Next Election', 'next_election', $editor, $this->dataset); $editColumn->SetAllowSetToNull(true); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); // // Edit column for notes field // $editor = new TextAreaEdit('notes_edit', 50, 8); $editColumn = new CustomEditColumn('Notes', 'notes', $editor, $this->dataset); $editColumn->SetAllowSetToNull(true); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); // // Edit column for office_rank field // $editor = new TextEdit('office_rank_edit'); $editColumn = new CustomEditColumn('Office Rank', 'office_rank', $editor, $this->dataset); $editColumn->SetAllowSetToNull(true); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); if ($this->GetSecurityInfo()->HasAddGrant()) { $grid->SetShowAddButton(true); $grid->SetShowInlineAddButton(false); } else { $grid->SetShowInlineAddButton(false); $grid->SetShowAddButton(false); } }
protected function AddInsertColumns(Grid $grid) { // // Edit column for name field // $editor = new TextEdit('name_edit'); $editor->SetSize(50); $editor->SetMaxLength(100); $editColumn = new CustomEditColumn('Name', 'name', $editor, $this->dataset); $editColumn->SetInsertDefaultValue($this->RenderText('%CURRENT_USER_NAME%')); $validator = new RequiredValidator(StringUtils::Format($this->GetLocalizerCaptions()->GetMessageString('RequiredValidationMessage'), $this->RenderText($editColumn->GetCaption()))); $editor->GetValidatorCollection()->AddValidator($validator); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); // // Edit column for task_id field // $editor = new MultiLevelComboBoxEditor('task_id_edit', $this->CreateLinkBuilder()); $dataset0 = new TableDataset(new MyConnectionFactory(), GetConnectionOptions(), '`project`'); $field = new IntegerField('project_id', null, null, true); $field->SetIsNotNull(true); $dataset0->AddField($field, true); $field = new IntegerField('programm_id'); $dataset0->AddField($field, false); $field = new StringField('project_name'); $dataset0->AddField($field, false); $field = new DateField('date_start'); $dataset0->AddField($field, false); $field = new DateField('date_end'); $dataset0->AddField($field, false); $field = new IntegerField('approved_budget'); $dataset0->AddField($field, false); $field = new StringField('notes'); $field->SetIsNotNull(true); $dataset0->AddField($field, false); $field = new StringField('priority'); $dataset0->AddField($field, false); $field = new StringField('lead'); $dataset0->AddField($field, false); $field = new StringField('level_of_service'); $field->SetIsNotNull(true); $dataset0->AddField($field, false); $field = new StringField('multi_year'); $field->SetIsNotNull(true); $dataset0->AddField($field, false); $field = new StringField('public_engagement'); $field->SetIsNotNull(true); $dataset0->AddField($field, false); $field = new StringField('year'); $field->SetIsNotNull(true); $dataset0->AddField($field, false); $field = new StringField('approved'); $field->SetIsNotNull(true); $dataset0->AddField($field, false); $field = new StringField('progress'); $field->SetIsNotNull(true); $dataset0->AddField($field, false); $field = new IntegerField('staff_id'); $field->SetIsNotNull(true); $dataset0->AddField($field, false); $field = new IntegerField('dept_id'); $field->SetIsNotNull(true); $dataset0->AddField($field, false); $field = new IntegerField('budget_spent'); $field->SetIsNotNull(true); $dataset0->AddField($field, false); $field = new IntegerField('admin_flag'); $field->SetIsNotNull(true); $dataset0->AddField($field, false); $editor->AddLevel($dataset0, 'project_id', 'project_name', $this->RenderText('Project'), null); $dataset1 = new TableDataset(new MyConnectionFactory(), GetConnectionOptions(), '`task`'); $field = new IntegerField('task_id', null, null, true); $field->SetIsNotNull(true); $dataset1->AddField($field, true); $field = new IntegerField('project_id'); $dataset1->AddField($field, false); $field = new StringField('assigned_to'); $dataset1->AddField($field, false); $field = new DateField('date_start'); $dataset1->AddField($field, false); $field = new DateField('date_end'); $dataset1->AddField($field, false); $field = new StringField('task_name'); $dataset1->AddField($field, false); $field = new StringField('notes'); $field->SetIsNotNull(true); $dataset1->AddField($field, false); $field = new IntegerField('hrs'); $dataset1->AddField($field, false); $field = new StringField('wo'); $dataset1->AddField($field, false); $field = new IntegerField('staff_id'); $dataset1->AddField($field, false); $dataset1->SetOrderBy('task_name', GetOrderTypeAsSQL(otAscending)); $editor->AddLevel($dataset1, 'task_id', 'task_name', $this->RenderText('Task'), new ForeignKeyInfo('project_id', 'project_id')); $editColumn = new MultiLevelLookupEditColumn('Task', 'task_id', $editor, $this->dataset); $validator = new RequiredValidator(StringUtils::Format($this->GetLocalizerCaptions()->GetMessageString('RequiredValidationMessage'), $this->RenderText($editColumn->GetCaption()))); $editor->GetValidatorCollection()->AddValidator($validator); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); // // Edit column for hours field // $editor = new SpinEdit('hours_edit'); $editColumn = new CustomEditColumn('Hours', 'hours', $editor, $this->dataset); $editColumn->SetInsertDefaultValue($this->RenderText('7')); $validator = new RequiredValidator(StringUtils::Format($this->GetLocalizerCaptions()->GetMessageString('RequiredValidationMessage'), $this->RenderText($editColumn->GetCaption()))); $editor->GetValidatorCollection()->AddValidator($validator); $validator = new NumberValidator(StringUtils::Format($this->GetLocalizerCaptions()->GetMessageString('NumberValidationMessage'), $this->RenderText($editColumn->GetCaption()))); $editor->GetValidatorCollection()->AddValidator($validator); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); // // Edit column for notes field // $editor = new TextAreaEdit('notes_edit', 50, 8); $editColumn = new CustomEditColumn('Notes', 'notes', $editor, $this->dataset); $editColumn->SetAllowSetToNull(true); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); // // Edit column for date field // $editor = new DateTimeEdit('date_edit', false, 'Y-m-d', GetFirstDayOfWeek()); $editColumn = new CustomEditColumn('Date', 'date', $editor, $this->dataset); $editColumn->SetInsertDefaultValue($this->RenderText('%CURRENT_DATE%')); $validator = new RequiredValidator(StringUtils::Format($this->GetLocalizerCaptions()->GetMessageString('RequiredValidationMessage'), $this->RenderText($editColumn->GetCaption()))); $editor->GetValidatorCollection()->AddValidator($validator); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); if ($this->GetSecurityInfo()->HasAddGrant()) { $grid->SetShowAddButton(true); $grid->SetShowInlineAddButton(false); } else { $grid->SetShowInlineAddButton(false); $grid->SetShowAddButton(false); } }
protected function CreateGrid() { $result = new Grid($this, $this->dataset, 'taskGrid'); if ($this->GetSecurityInfo()->HasDeleteGrant()) { $result->SetAllowDeleteSelected(true); } else { $result->SetAllowDeleteSelected(false); } ApplyCommonPageSettings($this, $result); $result->SetUseImagesForActions(true); $result->SetUseFixedHeader(false); $result->SetShowLineNumbers(false); $result->SetHighlightRowAtHover(false); $result->SetWidth(''); $result->OnCustomRenderTotal->AddListener('taskGrid' . '_' . 'OnCustomRenderTotal', $this); $result->BeforeUpdateRecord->AddListener('taskGrid' . '_' . 'BeforeUpdateRecord', $this); $result->BeforeDeleteRecord->AddListener('taskGrid' . '_' . 'BeforeDeleteRecord', $this); $result->BeforeInsertRecord->AddListener('taskGrid' . '_' . 'BeforeInsertRecord', $this); $this->CreateGridSearchControl($result); $this->CreateGridAdvancedSearchControl($result); $this->AddOperationsColumns($result); $this->AddFieldColumns($result); $this->AddSingleRecordViewColumns($result); $this->AddEditColumns($result); $this->AddInsertColumns($result); $this->AddPrintColumns($result); $this->AddExportColumns($result); $this->SetShowPageList(true); $this->SetHidePageListByDefault(false); $this->SetExportToExcelAvailable(true); $this->SetExportToWordAvailable(true); $this->SetExportToXmlAvailable(false); $this->SetExportToCsvAvailable(true); $this->SetExportToPdfAvailable(true); $this->SetPrinterFriendlyAvailable(true); $this->SetSimpleSearchAvailable(true); $this->SetAdvancedSearchAvailable(true); $this->SetFilterRowAvailable(true); $this->SetVisualEffectsEnabled(true); $this->SetShowTopPageNavigator(true); $this->SetShowBottomPageNavigator(true); // // Http Handlers // $pageView = new timesheetDetailView0taskPage($this, 'Timesheet', 'Timesheet', array('task_id'), GetCurrentUserGrantForDataSource('task.timesheet'), 'UTF-8', 20, 'timesheetDetailEdit0task_handler'); $pageView->SetRecordPermission(GetCurrentUserRecordPermissionsForDataSource('task.timesheet')); $handler = new PageHTTPHandler('timesheetDetailView0task_handler', $pageView); GetApplication()->RegisterHTTPHandler($handler); $pageEdit = new timesheetDetailEdit0taskPage($this, array('task_id'), array('task_id'), $this->GetForeingKeyFields(), $this->CreateMasterDetailRecordGridFortimesheetDetailEdit0taskGrid(), $this->dataset, GetCurrentUserGrantForDataSource('task.timesheet'), 'UTF-8'); $pageEdit->SetRecordPermission(GetCurrentUserRecordPermissionsForDataSource('task.timesheet')); $pageEdit->SetShortCaption('Timesheet'); $pageEdit->SetHeader(GetPagesHeader()); $pageEdit->SetFooter(GetPagesFooter()); $pageEdit->SetCaption('Timesheet'); $pageEdit->SetHttpHandlerName('timesheetDetailEdit0task_handler'); $handler = new PageHTTPHandler('timesheetDetailEdit0task_handler', $pageEdit); GetApplication()->RegisterHTTPHandler($handler); // // View column for Name field // $column = new TextViewColumn('task_name_Name', 'Name', $this->dataset); $column->SetOrderable(true); $handler = new ShowTextBlobHandler($this->dataset, $this, 'taskGrid_Name_handler_list', $column); GetApplication()->RegisterHTTPHandler($handler); // // View column for notes field // $column = new TextViewColumn('notes', 'Notes', $this->dataset); $column->SetOrderable(true); $handler = new ShowTextBlobHandler($this->dataset, $this, 'taskGrid_notes_handler_list', $column); GetApplication()->RegisterHTTPHandler($handler); // // View column for Name field // $column = new TextViewColumn('task_name_Name', 'Name', $this->dataset); $column->SetOrderable(true); $handler = new ShowTextBlobHandler($this->dataset, $this, 'taskGrid_Name_handler_view', $column); GetApplication()->RegisterHTTPHandler($handler); // // View column for notes field // $column = new TextViewColumn('notes', 'Notes', $this->dataset); $column->SetOrderable(true); $handler = new ShowTextBlobHandler($this->dataset, $this, 'taskGrid_notes_handler_view', $column); GetApplication()->RegisterHTTPHandler($handler); $lookupDataset = new TableDataset(new MyConnectionFactory(), GetConnectionOptions(), '`task_names`'); $field = new IntegerField('id', null, null, true); $field->SetIsNotNull(true); $lookupDataset->AddField($field, true); $field = new StringField('Name'); $lookupDataset->AddField($field, false); $lookupDataset->SetOrderBy('Name', GetOrderTypeAsSQL(otAscending)); $lookupDataset->AddCustomCondition(EnvVariablesUtils::EvaluateVariableTemplate($this->GetColumnVariableContainer(), '')); $handler = new DynamicSearchHandler($lookupDataset, $this, 'edit_task_name_Name_search', 'Name', 'Name', null); GetApplication()->RegisterHTTPHandler($handler); $lookupDataset = new TableDataset(new MyConnectionFactory(), GetConnectionOptions(), '`task_names`'); $field = new IntegerField('id', null, null, true); $field->SetIsNotNull(true); $lookupDataset->AddField($field, true); $field = new StringField('Name'); $lookupDataset->AddField($field, false); $lookupDataset->SetOrderBy('Name', GetOrderTypeAsSQL(otAscending)); $lookupDataset->AddCustomCondition(EnvVariablesUtils::EvaluateVariableTemplate($this->GetColumnVariableContainer(), '')); $handler = new DynamicSearchHandler($lookupDataset, $this, 'insert_task_name_Name_search', 'Name', 'Name', null); GetApplication()->RegisterHTTPHandler($handler); return $result; }
protected function AddInsertColumns(Grid $grid) { // // Edit column for Referencia field // $editor = new TextEdit('referencia_edit'); $editor->SetSize(45); $editor->SetMaxLength(45); $editColumn = new CustomEditColumn('Referencia', 'Referencia', $editor, $this->dataset); $validator = new RequiredValidator(StringUtils::Format($this->GetLocalizerCaptions()->GetMessageString('RequiredValidationMessage'), $this->RenderText($editColumn->GetCaption()))); $editor->GetValidatorCollection()->AddValidator($validator); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); // // Edit column for NombreAct field // $editor = new TextAreaEdit('nombreact_edit', 50, 8); $editColumn = new CustomEditColumn('NombreAct', 'NombreAct', $editor, $this->dataset); $validator = new RequiredValidator(StringUtils::Format($this->GetLocalizerCaptions()->GetMessageString('RequiredValidationMessage'), $this->RenderText($editColumn->GetCaption()))); $editor->GetValidatorCollection()->AddValidator($validator); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); // // Edit column for Marca field // $editor = new TextEdit('marca_edit'); $editor->SetSize(100); $editor->SetMaxLength(100); $editColumn = new CustomEditColumn('Marca', 'Marca', $editor, $this->dataset); $validator = new RequiredValidator(StringUtils::Format($this->GetLocalizerCaptions()->GetMessageString('RequiredValidationMessage'), $this->RenderText($editColumn->GetCaption()))); $editor->GetValidatorCollection()->AddValidator($validator); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); // // Edit column for Serie field // $editor = new TextEdit('serie_edit'); $editor->SetSize(45); $editor->SetMaxLength(45); $editColumn = new CustomEditColumn('Serie', 'Serie', $editor, $this->dataset); $validator = new RequiredValidator(StringUtils::Format($this->GetLocalizerCaptions()->GetMessageString('RequiredValidationMessage'), $this->RenderText($editColumn->GetCaption()))); $editor->GetValidatorCollection()->AddValidator($validator); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); // // Edit column for ValorEstimado field // $editor = new TextEdit('valorestimado_edit'); $editor->SetSize(45); $editor->SetMaxLength(45); $editColumn = new CustomEditColumn('ValorEstimado', 'ValorEstimado', $editor, $this->dataset); $validator = new RequiredValidator(StringUtils::Format($this->GetLocalizerCaptions()->GetMessageString('RequiredValidationMessage'), $this->RenderText($editColumn->GetCaption()))); $editor->GetValidatorCollection()->AddValidator($validator); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); // // Edit column for Bodega field // $editor = new ComboBox('bodega_edit', $this->GetLocalizerCaptions()->GetMessageString('PleaseSelect')); $lookupDataset = new TableDataset(new MyConnectionFactory(), GetConnectionOptions(), '`bodega`'); $field = new IntegerField('idBodega', null, null, true); $field->SetIsNotNull(true); $lookupDataset->AddField($field, true); $field = new StringField('Nombre'); $lookupDataset->AddField($field, false); $field = new StringField('Direccion'); $lookupDataset->AddField($field, false); $field = new StringField('Ciudad'); $lookupDataset->AddField($field, false); $field = new StringField('Telefono'); $lookupDataset->AddField($field, false); $lookupDataset->SetOrderBy('Nombre', GetOrderTypeAsSQL(otAscending)); $editColumn = new LookUpEditColumn('Bodega', 'Bodega', $editor, $this->dataset, 'idBodega', 'Nombre', $lookupDataset); $editColumn->SetInsertDefaultValue($this->RenderText('1')); $validator = new RequiredValidator(StringUtils::Format($this->GetLocalizerCaptions()->GetMessageString('RequiredValidationMessage'), $this->RenderText($editColumn->GetCaption()))); $editor->GetValidatorCollection()->AddValidator($validator); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); // // Edit column for CuentaPUC field // $editor = new TextEdit('cuentapuc_edit'); $editor->SetSize(45); $editor->SetMaxLength(45); $editColumn = new CustomEditColumn('CuentaPUC', 'CuentaPUC', $editor, $this->dataset); $editColumn->SetInsertDefaultValue($this->RenderText('1520')); $validator = new RequiredValidator(StringUtils::Format($this->GetLocalizerCaptions()->GetMessageString('RequiredValidationMessage'), $this->RenderText($editColumn->GetCaption()))); $editor->GetValidatorCollection()->AddValidator($validator); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); if ($this->GetSecurityInfo()->HasAddGrant()) { $grid->SetShowAddButton(true); $grid->SetShowInlineAddButton(false); } else { $grid->SetShowInlineAddButton(false); $grid->SetShowAddButton(false); } }
protected function AddInsertColumns(Grid $grid) { // // Edit column for USERNAME field // $editor = new TextEdit('username_edit'); $editor->SetSize(10); $editor->SetMaxLength(10); $editColumn = new CustomEditColumn('USERNAME', 'USERNAME', $editor, $this->dataset); $editColumn->SetAllowSetToNull(true); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); // // Edit column for ES_REAL field // $editor = new TextEdit('es_real_edit'); $editor->SetSize(1); $editor->SetMaxLength(1); $editColumn = new CustomEditColumn('ES REAL', 'ES_REAL', $editor, $this->dataset); $editColumn->SetAllowSetToNull(true); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); // // Edit column for MASCOTA_ID field // $editor = new ComboBox('mascota_id_edit', $this->GetLocalizerCaptions()->GetMessageString('PleaseSelect')); $lookupDataset = new TableDataset(new OracleConnectionFactory(), GetConnectionOptions(), '"GE"."MASCOTA"'); $field = new IntegerField('MASCOTA_ID'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, true); $field = new StringField('TIPO'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, false); $field = new DateField('FEC_CREACION'); $lookupDataset->AddField($field, false); $field = new StringField('USUARIO_CREACION'); $lookupDataset->AddField($field, false); $field = new DateField('FEC_ULTIMA_MOD'); $lookupDataset->AddField($field, false); $field = new StringField('USUARIO_ULTIMA_MOD'); $lookupDataset->AddField($field, false); $lookupDataset->SetOrderBy('TIPO', GetOrderTypeAsSQL(otAscending)); $editColumn = new LookUpEditColumn('MASCOTA ID', 'MASCOTA_ID', $editor, $this->dataset, 'MASCOTA_ID', 'TIPO', $lookupDataset); $editColumn->SetAllowSetToNull(true); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); // // Edit column for CANTIDAD field // $editor = new TextEdit('cantidad_edit'); $editColumn = new CustomEditColumn('CANTIDAD', 'CANTIDAD', $editor, $this->dataset); $validator = new RequiredValidator(StringUtils::Format($this->GetLocalizerCaptions()->GetMessageString('RequiredValidationMessage'), $this->RenderText($editColumn->GetCaption()))); $editor->GetValidatorCollection()->AddValidator($validator); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); if ($this->GetSecurityInfo()->HasAddGrant()) { $grid->SetShowAddButton(true); $grid->SetShowInlineAddButton(false); } else { $grid->SetShowInlineAddButton(false); $grid->SetShowAddButton(false); } }
protected function AddFieldColumns(Grid $grid) { // // View column for name field // $column = new TextViewColumn('name', 'Name', $this->dataset); $column->SetOrderable(true); /* <inline edit column> */ // // Edit column for name field // $editor = new TextEdit('name_edit'); $editColumn = new CustomEditColumn('Name', 'name', $editor, $this->dataset); $editColumn->setVisible(false); $validator = new RequiredValidator(StringUtils::Format($this->GetLocalizerCaptions()->GetMessageString('RequiredValidationMessage'), $this->RenderText($editColumn->GetCaption()))); $editor->GetValidatorCollection()->AddValidator($validator); $this->ApplyCommonColumnEditProperties($editColumn); $column->SetEditOperationColumn($editColumn); /* </inline edit column> */ /* <inline insert column> */ // // Edit column for name field // $editor = new TextEdit('name_edit'); $editColumn = new CustomEditColumn('Name', 'name', $editor, $this->dataset); $editColumn->setVisible(false); $editColumn->SetInsertDefaultValue($this->RenderText('%CURRENT_USER_NAME%')); $validator = new RequiredValidator(StringUtils::Format($this->GetLocalizerCaptions()->GetMessageString('RequiredValidationMessage'), $this->RenderText($editColumn->GetCaption()))); $editor->GetValidatorCollection()->AddValidator($validator); $this->ApplyCommonColumnEditProperties($editColumn); $column->SetInsertOperationColumn($editColumn); /* </inline insert column> */ $column->SetDescription($this->RenderText('')); $column->SetFixedWidth(null); $grid->AddViewColumn($column); // // View column for date field // $column = new DateTimeViewColumn('date', 'Date', $this->dataset); $column->SetDateTimeFormat('Y-m-d'); $column->SetOrderable(true); /* <inline edit column> */ // // Edit column for date field // $editor = new DateTimeEdit('date_edit', false, 'Y-m-d H:i:s', GetFirstDayOfWeek()); $editColumn = new CustomEditColumn('Date', 'date', $editor, $this->dataset); $validator = new RequiredValidator(StringUtils::Format($this->GetLocalizerCaptions()->GetMessageString('RequiredValidationMessage'), $this->RenderText($editColumn->GetCaption()))); $editor->GetValidatorCollection()->AddValidator($validator); $this->ApplyCommonColumnEditProperties($editColumn); $column->SetEditOperationColumn($editColumn); /* </inline edit column> */ /* <inline insert column> */ // // Edit column for date field // $editor = new DateTimeEdit('date_edit', false, 'Y-m-d H:i:s', GetFirstDayOfWeek()); $editColumn = new CustomEditColumn('Date', 'date', $editor, $this->dataset); $validator = new RequiredValidator(StringUtils::Format($this->GetLocalizerCaptions()->GetMessageString('RequiredValidationMessage'), $this->RenderText($editColumn->GetCaption()))); $editor->GetValidatorCollection()->AddValidator($validator); $this->ApplyCommonColumnEditProperties($editColumn); $column->SetInsertOperationColumn($editColumn); /* </inline insert column> */ $column->SetDescription($this->RenderText('')); $column->SetFixedWidth(null); $grid->AddViewColumn($column); // // View column for Task field // $column = new TextViewColumn('task_id_Task', 'Project & Task', $this->dataset); $column->SetOrderable(true); /* <inline edit column> */ // // Edit column for task_id field // $editor = new ComboBox('task_id_edit', $this->GetLocalizerCaptions()->GetMessageString('PleaseSelect')); $lookupDataset = new TableDataset(new MyConnectionFactory(), GetConnectionOptions(), '`taskview`'); $field = new IntegerField('task_id'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, false); $field = new IntegerField('project_id'); $lookupDataset->AddField($field, false); $field = new StringField('assigned_to'); $lookupDataset->AddField($field, false); $field = new DateField('date_start'); $lookupDataset->AddField($field, false); $field = new DateField('date_end'); $lookupDataset->AddField($field, false); $field = new StringField('task_name'); $lookupDataset->AddField($field, false); $field = new StringField('notes'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, false); $field = new IntegerField('hrs'); $lookupDataset->AddField($field, false); $field = new StringField('wo'); $lookupDataset->AddField($field, false); $field = new IntegerField('staff_id'); $lookupDataset->AddField($field, false); $field = new StringField('Task'); $lookupDataset->AddField($field, false); $field = new StringField('Assigned'); $lookupDataset->AddField($field, false); $lookupDataset->SetOrderBy('Task', GetOrderTypeAsSQL(otAscending)); $lookupDataset->AddCustomCondition(EnvVariablesUtils::EvaluateVariableTemplate($this->GetColumnVariableContainer(), 'assigned_to=%CURRENT_USER_ID%')); $editColumn = new LookUpEditColumn('Project & Task', 'task_id', $editor, $this->dataset, 'task_id', 'Task', $lookupDataset); $validator = new RequiredValidator(StringUtils::Format($this->GetLocalizerCaptions()->GetMessageString('RequiredValidationMessage'), $this->RenderText($editColumn->GetCaption()))); $editor->GetValidatorCollection()->AddValidator($validator); $this->ApplyCommonColumnEditProperties($editColumn); $column->SetEditOperationColumn($editColumn); /* </inline edit column> */ /* <inline insert column> */ // // Edit column for task_id field // $editor = new ComboBox('task_id_edit', $this->GetLocalizerCaptions()->GetMessageString('PleaseSelect')); $lookupDataset = new TableDataset(new MyConnectionFactory(), GetConnectionOptions(), '`taskview`'); $field = new IntegerField('task_id'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, false); $field = new IntegerField('project_id'); $lookupDataset->AddField($field, false); $field = new StringField('assigned_to'); $lookupDataset->AddField($field, false); $field = new DateField('date_start'); $lookupDataset->AddField($field, false); $field = new DateField('date_end'); $lookupDataset->AddField($field, false); $field = new StringField('task_name'); $lookupDataset->AddField($field, false); $field = new StringField('notes'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, false); $field = new IntegerField('hrs'); $lookupDataset->AddField($field, false); $field = new StringField('wo'); $lookupDataset->AddField($field, false); $field = new IntegerField('staff_id'); $lookupDataset->AddField($field, false); $field = new StringField('Task'); $lookupDataset->AddField($field, false); $field = new StringField('Assigned'); $lookupDataset->AddField($field, false); $lookupDataset->SetOrderBy('Task', GetOrderTypeAsSQL(otAscending)); $lookupDataset->AddCustomCondition(EnvVariablesUtils::EvaluateVariableTemplate($this->GetColumnVariableContainer(), 'assigned_to=%CURRENT_USER_ID%')); $editColumn = new LookUpEditColumn('Project & Task', 'task_id', $editor, $this->dataset, 'task_id', 'Task', $lookupDataset); $validator = new RequiredValidator(StringUtils::Format($this->GetLocalizerCaptions()->GetMessageString('RequiredValidationMessage'), $this->RenderText($editColumn->GetCaption()))); $editor->GetValidatorCollection()->AddValidator($validator); $this->ApplyCommonColumnEditProperties($editColumn); $column->SetInsertOperationColumn($editColumn); /* </inline insert column> */ $column->SetDescription($this->RenderText('')); $column->SetFixedWidth(null); $grid->AddViewColumn($column); // // View column for hours field // $column = new TextViewColumn('hours', 'Hours', $this->dataset); $column->SetOrderable(true); /* <inline edit column> */ // // Edit column for hours field // $editor = new TextEdit('hours_edit'); $editColumn = new CustomEditColumn('Hours', 'hours', $editor, $this->dataset); $validator = new RequiredValidator(StringUtils::Format($this->GetLocalizerCaptions()->GetMessageString('RequiredValidationMessage'), $this->RenderText($editColumn->GetCaption()))); $editor->GetValidatorCollection()->AddValidator($validator); $this->ApplyCommonColumnEditProperties($editColumn); $column->SetEditOperationColumn($editColumn); /* </inline edit column> */ /* <inline insert column> */ // // Edit column for hours field // $editor = new TextEdit('hours_edit'); $editColumn = new CustomEditColumn('Hours', 'hours', $editor, $this->dataset); $validator = new RequiredValidator(StringUtils::Format($this->GetLocalizerCaptions()->GetMessageString('RequiredValidationMessage'), $this->RenderText($editColumn->GetCaption()))); $editor->GetValidatorCollection()->AddValidator($validator); $this->ApplyCommonColumnEditProperties($editColumn); $column->SetInsertOperationColumn($editColumn); /* </inline insert column> */ $column->SetDescription($this->RenderText('')); $column->SetFixedWidth(null); $grid->AddViewColumn($column); // // View column for notes field // $column = new TextViewColumn('notes', 'Notes', $this->dataset); $column->SetOrderable(true); /* <inline edit column> */ // // Edit column for notes field // $editor = new TextEdit('notes_edit'); $editColumn = new CustomEditColumn('Notes', 'notes', $editor, $this->dataset); $editColumn->SetAllowSetToNull(true); $this->ApplyCommonColumnEditProperties($editColumn); $column->SetEditOperationColumn($editColumn); /* </inline edit column> */ /* <inline insert column> */ // // Edit column for notes field // $editor = new TextEdit('notes_edit'); $editColumn = new CustomEditColumn('Notes', 'notes', $editor, $this->dataset); $editColumn->SetAllowSetToNull(true); $this->ApplyCommonColumnEditProperties($editColumn); $column->SetInsertOperationColumn($editColumn); /* </inline insert column> */ $column->SetDescription($this->RenderText('')); $column->SetFixedWidth(null); $grid->AddViewColumn($column); }
protected function AddInsertColumns(Grid $grid) { // // Edit column for INTERES_ID field // $editor = new ComboBox('interes_id_edit', $this->GetLocalizerCaptions()->GetMessageString('PleaseSelect')); $lookupDataset = new TableDataset(new OracleConnectionFactory(), GetConnectionOptions(), '"GE"."INTERES"'); $field = new IntegerField('INTERES_ID'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, true); $field = new StringField('NOMBRE'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, false); $field = new DateField('FEC_CREACION'); $lookupDataset->AddField($field, false); $field = new StringField('USUARIO_CREACION'); $lookupDataset->AddField($field, false); $field = new DateField('FEC_ULTIMA_MOD'); $lookupDataset->AddField($field, false); $field = new StringField('USUARIO_ULTIMA_MOD'); $lookupDataset->AddField($field, false); $lookupDataset->SetOrderBy('NOMBRE', GetOrderTypeAsSQL(otAscending)); $editColumn = new LookUpEditColumn('INTERES ID', 'INTERES_ID', $editor, $this->dataset, 'INTERES_ID', 'NOMBRE', $lookupDataset); $validator = new RequiredValidator(StringUtils::Format($this->GetLocalizerCaptions()->GetMessageString('RequiredValidationMessage'), $this->RenderText($editColumn->GetCaption()))); $editor->GetValidatorCollection()->AddValidator($validator); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); // // Edit column for CATEGORIA_INTERES_ID field // $editor = new ComboBox('categoria_interes_id_edit', $this->GetLocalizerCaptions()->GetMessageString('PleaseSelect')); $lookupDataset = new TableDataset(new OracleConnectionFactory(), GetConnectionOptions(), '"GE"."CATEGORIA_INTERES"'); $field = new IntegerField('CATEGORIA_INTERES_ID'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, true); $field = new StringField('NOMBRE'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, false); $field = new DateField('FEC_CREACION'); $lookupDataset->AddField($field, false); $field = new StringField('USUARIO_CREACION'); $lookupDataset->AddField($field, false); $field = new DateField('FEC_ULTIMA_MOD'); $lookupDataset->AddField($field, false); $field = new StringField('USUARIO_ULTIMA_MOD'); $lookupDataset->AddField($field, false); $lookupDataset->SetOrderBy('NOMBRE', GetOrderTypeAsSQL(otAscending)); $editColumn = new LookUpEditColumn('CATEGORIA INTERES ID', 'CATEGORIA_INTERES_ID', $editor, $this->dataset, 'CATEGORIA_INTERES_ID', 'NOMBRE', $lookupDataset); $validator = new RequiredValidator(StringUtils::Format($this->GetLocalizerCaptions()->GetMessageString('RequiredValidationMessage'), $this->RenderText($editColumn->GetCaption()))); $editor->GetValidatorCollection()->AddValidator($validator); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); if ($this->GetSecurityInfo()->HasAddGrant()) { $grid->SetShowAddButton(true); $grid->SetShowInlineAddButton(false); } else { $grid->SetShowInlineAddButton(false); $grid->SetShowAddButton(false); } }
protected function AddInsertColumns(Grid $grid) { // // Edit column for USERNAME field // $editor = new ComboBox('username_edit', $this->GetLocalizerCaptions()->GetMessageString('PleaseSelect')); $lookupDataset = new TableDataset(new OracleConnectionFactory(), GetConnectionOptions(), '"GE"."PERSONA"'); $field = new StringField('USERNAME'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, true); $field = new StringField('ES_ADMIN'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, false); $field = new DateField('NACIMIENTO'); $lookupDataset->AddField($field, false); $field = new StringField('PRIMER_APELLIDO'); $lookupDataset->AddField($field, false); $field = new StringField('SEGUNDO_APELLIDO'); $lookupDataset->AddField($field, false); $field = new StringField('NOMBRE'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, false); $field = new IntegerField('GENERO_ID'); $lookupDataset->AddField($field, false); $field = new IntegerField('CIUDAD_ID'); $lookupDataset->AddField($field, false); $field = new StringField('SLOGAN'); $lookupDataset->AddField($field, false); $field = new DateField('FEC_CREACION'); $lookupDataset->AddField($field, false); $field = new StringField('USUARIO_CREACION'); $lookupDataset->AddField($field, false); $field = new DateField('FEC_ULTIMA_MOD'); $lookupDataset->AddField($field, false); $field = new StringField('USUARIO_ULTIMA_MOD'); $lookupDataset->AddField($field, false); $field = new StringField('EMAIL'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, false); $field = new StringField('CLAVE'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, false); $lookupDataset->SetOrderBy('ES_ADMIN', GetOrderTypeAsSQL(otAscending)); $editColumn = new LookUpEditColumn('USERNAME', 'USERNAME', $editor, $this->dataset, 'USERNAME', 'ES_ADMIN', $lookupDataset); $validator = new RequiredValidator(StringUtils::Format($this->GetLocalizerCaptions()->GetMessageString('RequiredValidationMessage'), $this->RenderText($editColumn->GetCaption()))); $editor->GetValidatorCollection()->AddValidator($validator); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); // // Edit column for ES_REAL field // $editor = new TextEdit('es_real_edit'); $editor->SetSize(1); $editor->SetMaxLength(1); $editColumn = new CustomEditColumn('ES REAL', 'ES_REAL', $editor, $this->dataset); $validator = new RequiredValidator(StringUtils::Format($this->GetLocalizerCaptions()->GetMessageString('RequiredValidationMessage'), $this->RenderText($editColumn->GetCaption()))); $editor->GetValidatorCollection()->AddValidator($validator); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); // // Edit column for COLOR_OJOS_ID field // $editor = new ComboBox('color_ojos_id_edit', $this->GetLocalizerCaptions()->GetMessageString('PleaseSelect')); $lookupDataset = new TableDataset(new OracleConnectionFactory(), GetConnectionOptions(), '"GE"."COLOR_OJOS"'); $field = new IntegerField('COLOR_OJOS_ID'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, true); $field = new StringField('NOMBRE'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, false); $field = new DateField('FEC_CREACION'); $lookupDataset->AddField($field, false); $field = new StringField('USUARIO_CREACION'); $lookupDataset->AddField($field, false); $field = new DateField('FEC_ULTIMA_MOD'); $lookupDataset->AddField($field, false); $field = new StringField('USUARIO_ULTIMA_MOD'); $lookupDataset->AddField($field, false); $lookupDataset->SetOrderBy('NOMBRE', GetOrderTypeAsSQL(otAscending)); $editColumn = new LookUpEditColumn('COLOR OJOS ID', 'COLOR_OJOS_ID', $editor, $this->dataset, 'COLOR_OJOS_ID', 'NOMBRE', $lookupDataset); $editColumn->SetAllowSetToNull(true); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); // // Edit column for COLOR_PIEL_ID field // $editor = new ComboBox('color_piel_id_edit', $this->GetLocalizerCaptions()->GetMessageString('PleaseSelect')); $lookupDataset = new TableDataset(new OracleConnectionFactory(), GetConnectionOptions(), '"GE"."COLOR_PIEL"'); $field = new IntegerField('COLOR_PIEL_ID'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, true); $field = new StringField('NOMBRE'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, false); $field = new DateField('FEC_CREACION'); $lookupDataset->AddField($field, false); $field = new StringField('USUARIO_CREACION'); $lookupDataset->AddField($field, false); $field = new DateField('FEC_ULTIMA_MOD'); $lookupDataset->AddField($field, false); $field = new StringField('USUARIO_ULTIMA_MOD'); $lookupDataset->AddField($field, false); $lookupDataset->SetOrderBy('NOMBRE', GetOrderTypeAsSQL(otAscending)); $editColumn = new LookUpEditColumn('COLOR PIEL ID', 'COLOR_PIEL_ID', $editor, $this->dataset, 'COLOR_PIEL_ID', 'NOMBRE', $lookupDataset); $editColumn->SetAllowSetToNull(true); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); // // Edit column for CONTEXTURA_ID field // $editor = new ComboBox('contextura_id_edit', $this->GetLocalizerCaptions()->GetMessageString('PleaseSelect')); $lookupDataset = new TableDataset(new OracleConnectionFactory(), GetConnectionOptions(), '"GE"."CONTEXTURA"'); $field = new IntegerField('CONTEXTURA_ID'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, true); $field = new StringField('TIPO'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, false); $field = new DateField('FEC_CREACION'); $lookupDataset->AddField($field, false); $field = new StringField('USUARIO_CREACION'); $lookupDataset->AddField($field, false); $field = new DateField('FEC_ULTIMA_MOD'); $lookupDataset->AddField($field, false); $field = new StringField('USUARIO_ULTIMA_MOD'); $lookupDataset->AddField($field, false); $lookupDataset->SetOrderBy('TIPO', GetOrderTypeAsSQL(otAscending)); $editColumn = new LookUpEditColumn('CONTEXTURA ID', 'CONTEXTURA_ID', $editor, $this->dataset, 'CONTEXTURA_ID', 'TIPO', $lookupDataset); $editColumn->SetAllowSetToNull(true); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); // // Edit column for NIVEL_EDUCACION_ID field // $editor = new ComboBox('nivel_educacion_id_edit', $this->GetLocalizerCaptions()->GetMessageString('PleaseSelect')); $lookupDataset = new TableDataset(new OracleConnectionFactory(), GetConnectionOptions(), '"GE"."NIVEL_EDUCACION"'); $field = new IntegerField('NIVEL_EDUCACION_ID'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, true); $field = new StringField('GRADO'); $lookupDataset->AddField($field, false); $field = new DateField('FEC_CREACION'); $lookupDataset->AddField($field, false); $field = new StringField('USUARIO_CREACION'); $lookupDataset->AddField($field, false); $field = new DateField('FEC_ULTIMA_MOD'); $lookupDataset->AddField($field, false); $field = new StringField('USUARIO_ULTIMA_MOD'); $lookupDataset->AddField($field, false); $lookupDataset->SetOrderBy('GRADO', GetOrderTypeAsSQL(otAscending)); $editColumn = new LookUpEditColumn('NIVEL EDUCACION ID', 'NIVEL_EDUCACION_ID', $editor, $this->dataset, 'NIVEL_EDUCACION_ID', 'GRADO', $lookupDataset); $editColumn->SetAllowSetToNull(true); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); // // Edit column for ESTADO_CIVIL_ID field // $editor = new ComboBox('estado_civil_id_edit', $this->GetLocalizerCaptions()->GetMessageString('PleaseSelect')); $lookupDataset = new TableDataset(new OracleConnectionFactory(), GetConnectionOptions(), '"GE"."ESTADO_CIVIL"'); $field = new IntegerField('ESTADO_CIVIL_ID'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, true); $field = new StringField('NOMBRE'); $lookupDataset->AddField($field, false); $field = new DateField('FEC_CREACION'); $lookupDataset->AddField($field, false); $field = new StringField('USUARIO_CREACION'); $lookupDataset->AddField($field, false); $field = new DateField('FEC_ULTIMA_MOD'); $lookupDataset->AddField($field, false); $field = new StringField('USUARIO_ULTIMA_MOD'); $lookupDataset->AddField($field, false); $lookupDataset->SetOrderBy('NOMBRE', GetOrderTypeAsSQL(otAscending)); $editColumn = new LookUpEditColumn('ESTADO CIVIL ID', 'ESTADO_CIVIL_ID', $editor, $this->dataset, 'ESTADO_CIVIL_ID', 'NOMBRE', $lookupDataset); $editColumn->SetAllowSetToNull(true); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); // // Edit column for FUMADOR_ID field // $editor = new ComboBox('fumador_id_edit', $this->GetLocalizerCaptions()->GetMessageString('PleaseSelect')); $lookupDataset = new TableDataset(new OracleConnectionFactory(), GetConnectionOptions(), '"GE"."FUMADOR"'); $field = new IntegerField('FUMADOR_ID'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, true); $field = new StringField('TIPO'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, false); $field = new DateField('FEC_CREACION'); $lookupDataset->AddField($field, false); $field = new StringField('USUARIO_CREACION'); $lookupDataset->AddField($field, false); $field = new DateField('FEC_ULTIMA_MOD'); $lookupDataset->AddField($field, false); $field = new StringField('USUARIO_ULTIMA_MOD'); $lookupDataset->AddField($field, false); $lookupDataset->SetOrderBy('TIPO', GetOrderTypeAsSQL(otAscending)); $editColumn = new LookUpEditColumn('FUMADOR ID', 'FUMADOR_ID', $editor, $this->dataset, 'FUMADOR_ID', 'TIPO', $lookupDataset); $editColumn->SetAllowSetToNull(true); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); // // Edit column for BEBEDOR_ID field // $editor = new ComboBox('bebedor_id_edit', $this->GetLocalizerCaptions()->GetMessageString('PleaseSelect')); $lookupDataset = new TableDataset(new OracleConnectionFactory(), GetConnectionOptions(), '"GE"."BEBEDOR"'); $field = new IntegerField('BEBEDOR_ID'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, true); $field = new StringField('TIPO'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, false); $field = new DateField('FEC_CREACION'); $lookupDataset->AddField($field, false); $field = new StringField('USUARIO_CREACION'); $lookupDataset->AddField($field, false); $field = new DateField('FEC_ULTIMA_MOD'); $lookupDataset->AddField($field, false); $field = new StringField('USUARIO_ULTIMA_MOD'); $lookupDataset->AddField($field, false); $lookupDataset->SetOrderBy('TIPO', GetOrderTypeAsSQL(otAscending)); $editColumn = new LookUpEditColumn('BEBEDOR ID', 'BEBEDOR_ID', $editor, $this->dataset, 'BEBEDOR_ID', 'TIPO', $lookupDataset); $editColumn->SetAllowSetToNull(true); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); // // Edit column for FRECUENCIA_EJERCICIO_ID field // $editor = new ComboBox('frecuencia_ejercicio_id_edit', $this->GetLocalizerCaptions()->GetMessageString('PleaseSelect')); $lookupDataset = new TableDataset(new OracleConnectionFactory(), GetConnectionOptions(), '"GE"."FRECUENCIA_EJERCICIO"'); $field = new IntegerField('FRECUENCIA_EJERCICIO_ID'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, true); $field = new StringField('RANGO'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, false); $field = new DateField('FEC_CREACION'); $lookupDataset->AddField($field, false); $field = new StringField('USUARIO_CREACION'); $lookupDataset->AddField($field, false); $field = new DateField('FEC_ULTIMA_MOD'); $lookupDataset->AddField($field, false); $field = new StringField('USUARIO_ULTIMA_MOD'); $lookupDataset->AddField($field, false); $lookupDataset->SetOrderBy('RANGO', GetOrderTypeAsSQL(otAscending)); $editColumn = new LookUpEditColumn('FRECUENCIA EJERCICIO ID', 'FRECUENCIA_EJERCICIO_ID', $editor, $this->dataset, 'FRECUENCIA_EJERCICIO_ID', 'RANGO', $lookupDataset); $editColumn->SetAllowSetToNull(true); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); // // Edit column for SALARIO_ID field // $editor = new ComboBox('salario_id_edit', $this->GetLocalizerCaptions()->GetMessageString('PleaseSelect')); $lookupDataset = new TableDataset(new OracleConnectionFactory(), GetConnectionOptions(), '"GE"."SALARIO"'); $field = new IntegerField('SALARIO_ID'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, true); $field = new StringField('RANGO'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, false); $field = new DateField('FEC_CREACION'); $lookupDataset->AddField($field, false); $field = new StringField('USUARIO_CREACION'); $lookupDataset->AddField($field, false); $field = new DateField('FEC_ULTIMA_MOD'); $lookupDataset->AddField($field, false); $field = new StringField('USUARIO_ULTIMA_MOD'); $lookupDataset->AddField($field, false); $lookupDataset->SetOrderBy('RANGO', GetOrderTypeAsSQL(otAscending)); $editColumn = new LookUpEditColumn('SALARIO ID', 'SALARIO_ID', $editor, $this->dataset, 'SALARIO_ID', 'RANGO', $lookupDataset); $editColumn->SetAllowSetToNull(true); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); // // Edit column for ALTURA field // $editor = new TextEdit('altura_edit'); $editColumn = new CustomEditColumn('ALTURA', 'ALTURA', $editor, $this->dataset); $editColumn->SetAllowSetToNull(true); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); // // Edit column for PESO field // $editor = new TextEdit('peso_edit'); $editColumn = new CustomEditColumn('PESO', 'PESO', $editor, $this->dataset); $editColumn->SetAllowSetToNull(true); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); // // Edit column for NUM_HIJOS field // $editor = new TextEdit('num_hijos_edit'); $editColumn = new CustomEditColumn('NUM HIJOS', 'NUM_HIJOS', $editor, $this->dataset); $editColumn->SetAllowSetToNull(true); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); // // Edit column for QUIERE_HIJOS field // $editor = new TextEdit('quiere_hijos_edit'); $editor->SetSize(1); $editor->SetMaxLength(1); $editColumn = new CustomEditColumn('QUIERE HIJOS', 'QUIERE_HIJOS', $editor, $this->dataset); $editColumn->SetAllowSetToNull(true); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); // // Edit column for TIPO_RELACION_ID field // $editor = new ComboBox('tipo_relacion_id_edit', $this->GetLocalizerCaptions()->GetMessageString('PleaseSelect')); $lookupDataset = new TableDataset(new OracleConnectionFactory(), GetConnectionOptions(), '"GE"."TIPO_RELACION"'); $field = new IntegerField('TIPO_RELACION_ID'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, true); $field = new StringField('NOMBRE'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, false); $field = new DateField('FECHA_CREACION'); $lookupDataset->AddField($field, false); $field = new DateField('FECHA_MODIFICACION'); $lookupDataset->AddField($field, false); $field = new StringField('USUARIO_CREACION'); $lookupDataset->AddField($field, false); $field = new StringField('USUARIO_MODIFICACION'); $lookupDataset->AddField($field, false); $lookupDataset->SetOrderBy('NOMBRE', GetOrderTypeAsSQL(otAscending)); $editColumn = new LookUpEditColumn('TIPO RELACION ID', 'TIPO_RELACION_ID', $editor, $this->dataset, 'TIPO_RELACION_ID', 'NOMBRE', $lookupDataset); $editColumn->SetAllowSetToNull(true); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); if ($this->GetSecurityInfo()->HasAddGrant()) { $grid->SetShowAddButton(true); $grid->SetShowInlineAddButton(false); } else { $grid->SetShowInlineAddButton(false); $grid->SetShowAddButton(false); } }
protected function CreateGrid() { $result = new Grid($this, $this->dataset, 'carteraGrid'); if ($this->GetSecurityInfo()->HasDeleteGrant()) { $result->SetAllowDeleteSelected(false); } else { $result->SetAllowDeleteSelected(false); } ApplyCommonPageSettings($this, $result); $result->SetUseImagesForActions(true); $result->SetUseFixedHeader(false); $result->SetShowLineNumbers(false); $result->SetHighlightRowAtHover(false); $result->SetWidth(''); $this->CreateGridSearchControl($result); $this->CreateGridAdvancedSearchControl($result); $this->AddFieldColumns($result); $this->AddSingleRecordViewColumns($result); $this->AddEditColumns($result); $this->AddInsertColumns($result); $this->AddPrintColumns($result); $this->AddExportColumns($result); $this->AddOperationsColumns($result); $this->SetShowPageList(true); $this->SetHidePageListByDefault(false); $this->SetExportToExcelAvailable(true); $this->SetExportToWordAvailable(true); $this->SetExportToXmlAvailable(true); $this->SetExportToCsvAvailable(true); $this->SetExportToPdfAvailable(true); $this->SetPrinterFriendlyAvailable(true); $this->SetSimpleSearchAvailable(true); $this->SetAdvancedSearchAvailable(true); $this->SetFilterRowAvailable(true); $this->SetVisualEffectsEnabled(true); $this->SetShowTopPageNavigator(true); $this->SetShowBottomPageNavigator(true); // // Http Handlers // $lookupDataset = new TableDataset(new MyConnectionFactory(), GetConnectionOptions(), '`clientes`'); $field = new IntegerField('idClientes', null, null, true); $field->SetIsNotNull(true); $lookupDataset->AddField($field, true); $field = new IntegerField('Tipo_Documento'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, false); $field = new StringField('Num_Identificacion'); $lookupDataset->AddField($field, false); $field = new IntegerField('DV'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, false); $field = new StringField('Primer_Apellido'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, false); $field = new StringField('Segundo_Apellido'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, false); $field = new StringField('Primer_Nombre'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, false); $field = new StringField('Otros_Nombres'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, false); $field = new StringField('RazonSocial'); $lookupDataset->AddField($field, false); $field = new StringField('Direccion'); $lookupDataset->AddField($field, false); $field = new StringField('Cod_Dpto'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, false); $field = new StringField('Cod_Mcipio'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, false); $field = new StringField('Pais_Domicilio'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, false); $field = new StringField('Telefono'); $lookupDataset->AddField($field, false); $field = new StringField('Ciudad'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, false); $field = new StringField('Contacto'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, false); $field = new StringField('TelContacto'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, false); $field = new StringField('Email'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, false); $field = new IntegerField('CIUU'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, false); $field = new IntegerField('empresa_id'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, false); $field = new StringField('codigo'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, false); $field = new StringField('regimen'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, false); $field = new StringField('estado'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, false); $lookupDataset->SetOrderBy('RazonSocial', GetOrderTypeAsSQL(otAscending)); $lookupDataset->AddCustomCondition(EnvVariablesUtils::EvaluateVariableTemplate($this->GetColumnVariableContainer(), '')); $handler = new DynamicSearchHandler($lookupDataset, $this, 'inline_edit_Cliente_RazonSocial_search', 'idClientes', 'RazonSocial', null); GetApplication()->RegisterHTTPHandler($handler); $lookupDataset = new TableDataset(new MyConnectionFactory(), GetConnectionOptions(), '`clientes`'); $field = new IntegerField('idClientes', null, null, true); $field->SetIsNotNull(true); $lookupDataset->AddField($field, true); $field = new IntegerField('Tipo_Documento'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, false); $field = new StringField('Num_Identificacion'); $lookupDataset->AddField($field, false); $field = new IntegerField('DV'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, false); $field = new StringField('Primer_Apellido'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, false); $field = new StringField('Segundo_Apellido'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, false); $field = new StringField('Primer_Nombre'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, false); $field = new StringField('Otros_Nombres'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, false); $field = new StringField('RazonSocial'); $lookupDataset->AddField($field, false); $field = new StringField('Direccion'); $lookupDataset->AddField($field, false); $field = new StringField('Cod_Dpto'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, false); $field = new StringField('Cod_Mcipio'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, false); $field = new StringField('Pais_Domicilio'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, false); $field = new StringField('Telefono'); $lookupDataset->AddField($field, false); $field = new StringField('Ciudad'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, false); $field = new StringField('Contacto'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, false); $field = new StringField('TelContacto'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, false); $field = new StringField('Email'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, false); $field = new IntegerField('CIUU'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, false); $field = new IntegerField('empresa_id'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, false); $field = new StringField('codigo'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, false); $field = new StringField('regimen'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, false); $field = new StringField('estado'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, false); $lookupDataset->SetOrderBy('RazonSocial', GetOrderTypeAsSQL(otAscending)); $lookupDataset->AddCustomCondition(EnvVariablesUtils::EvaluateVariableTemplate($this->GetColumnVariableContainer(), '')); $handler = new DynamicSearchHandler($lookupDataset, $this, 'inline_insert_Cliente_RazonSocial_search', 'idClientes', 'RazonSocial', null); GetApplication()->RegisterHTTPHandler($handler); // // View column for Observaciones field // $column = new TextViewColumn('Observaciones', 'Observaciones', $this->dataset); $column->SetOrderable(true); /* <inline edit column> */ // // Edit column for Observaciones field // $editor = new TextAreaEdit('observaciones_edit', 50, 8); $editColumn = new CustomEditColumn('Observaciones', 'Observaciones', $editor, $this->dataset); $editColumn->SetAllowSetToNull(true); $this->ApplyCommonColumnEditProperties($editColumn); $column->SetEditOperationColumn($editColumn); /* </inline edit column> */ /* <inline insert column> */ // // Edit column for Observaciones field // $editor = new TextAreaEdit('observaciones_edit', 50, 8); $editColumn = new CustomEditColumn('Observaciones', 'Observaciones', $editor, $this->dataset); $editColumn->SetAllowSetToNull(true); $this->ApplyCommonColumnEditProperties($editColumn); $column->SetInsertOperationColumn($editColumn); /* </inline insert column> */ $handler = new ShowTextBlobHandler($this->dataset, $this, 'Observaciones_handler', $column); GetApplication()->RegisterHTTPHandler($handler); // // View column for Observaciones field // $column = new TextViewColumn('Observaciones', 'Observaciones', $this->dataset); $column->SetOrderable(true); $handler = new ShowTextBlobHandler($this->dataset, $this, 'Observaciones_handler', $column); GetApplication()->RegisterHTTPHandler($handler); $lookupDataset = new TableDataset(new MyConnectionFactory(), GetConnectionOptions(), '`clientes`'); $field = new IntegerField('idClientes', null, null, true); $field->SetIsNotNull(true); $lookupDataset->AddField($field, true); $field = new IntegerField('Tipo_Documento'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, false); $field = new StringField('Num_Identificacion'); $lookupDataset->AddField($field, false); $field = new IntegerField('DV'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, false); $field = new StringField('Primer_Apellido'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, false); $field = new StringField('Segundo_Apellido'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, false); $field = new StringField('Primer_Nombre'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, false); $field = new StringField('Otros_Nombres'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, false); $field = new StringField('RazonSocial'); $lookupDataset->AddField($field, false); $field = new StringField('Direccion'); $lookupDataset->AddField($field, false); $field = new StringField('Cod_Dpto'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, false); $field = new StringField('Cod_Mcipio'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, false); $field = new StringField('Pais_Domicilio'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, false); $field = new StringField('Telefono'); $lookupDataset->AddField($field, false); $field = new StringField('Ciudad'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, false); $field = new StringField('Contacto'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, false); $field = new StringField('TelContacto'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, false); $field = new StringField('Email'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, false); $field = new IntegerField('CIUU'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, false); $field = new IntegerField('empresa_id'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, false); $field = new StringField('codigo'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, false); $field = new StringField('regimen'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, false); $field = new StringField('estado'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, false); $lookupDataset->SetOrderBy('RazonSocial', GetOrderTypeAsSQL(otAscending)); $lookupDataset->AddCustomCondition(EnvVariablesUtils::EvaluateVariableTemplate($this->GetColumnVariableContainer(), '')); $handler = new DynamicSearchHandler($lookupDataset, $this, 'edit_Cliente_RazonSocial_search', 'idClientes', 'RazonSocial', null); GetApplication()->RegisterHTTPHandler($handler); $lookupDataset = new TableDataset(new MyConnectionFactory(), GetConnectionOptions(), '`clientes`'); $field = new IntegerField('idClientes', null, null, true); $field->SetIsNotNull(true); $lookupDataset->AddField($field, true); $field = new IntegerField('Tipo_Documento'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, false); $field = new StringField('Num_Identificacion'); $lookupDataset->AddField($field, false); $field = new IntegerField('DV'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, false); $field = new StringField('Primer_Apellido'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, false); $field = new StringField('Segundo_Apellido'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, false); $field = new StringField('Primer_Nombre'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, false); $field = new StringField('Otros_Nombres'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, false); $field = new StringField('RazonSocial'); $lookupDataset->AddField($field, false); $field = new StringField('Direccion'); $lookupDataset->AddField($field, false); $field = new StringField('Cod_Dpto'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, false); $field = new StringField('Cod_Mcipio'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, false); $field = new StringField('Pais_Domicilio'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, false); $field = new StringField('Telefono'); $lookupDataset->AddField($field, false); $field = new StringField('Ciudad'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, false); $field = new StringField('Contacto'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, false); $field = new StringField('TelContacto'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, false); $field = new StringField('Email'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, false); $field = new IntegerField('CIUU'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, false); $field = new IntegerField('empresa_id'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, false); $field = new StringField('codigo'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, false); $field = new StringField('regimen'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, false); $field = new StringField('estado'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, false); $lookupDataset->SetOrderBy('RazonSocial', GetOrderTypeAsSQL(otAscending)); $lookupDataset->AddCustomCondition(EnvVariablesUtils::EvaluateVariableTemplate($this->GetColumnVariableContainer(), '')); $handler = new DynamicSearchHandler($lookupDataset, $this, 'insert_Cliente_RazonSocial_search', 'idClientes', 'RazonSocial', null); GetApplication()->RegisterHTTPHandler($handler); return $result; }
protected function AddInsertColumns(Grid $grid) { // // Edit column for username field // $editor = new TextEdit('username_edit'); $editor->SetSize(50); $editor->SetMaxLength(50); $editColumn = new CustomEditColumn('Username', 'username', $editor, $this->dataset); $validator = new RequiredValidator(StringUtils::Format($this->GetLocalizerCaptions()->GetMessageString('RequiredValidationMessage'), $this->RenderText($editColumn->GetCaption()))); $editor->GetValidatorCollection()->AddValidator($validator); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); // // Edit column for email field // $editor = new TextEdit('email_edit'); $editor->SetSize(50); $editor->SetMaxLength(50); $editColumn = new CustomEditColumn('Email', 'email', $editor, $this->dataset); $validator = new RequiredValidator(StringUtils::Format($this->GetLocalizerCaptions()->GetMessageString('RequiredValidationMessage'), $this->RenderText($editColumn->GetCaption()))); $editor->GetValidatorCollection()->AddValidator($validator); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); // // Edit column for password field // $editor = new TextEdit('password_edit'); $editor->SetPasswordMode(true); $editColumn = new CustomEditColumn('Password', 'password', $editor, $this->dataset); $validator = new RequiredValidator(StringUtils::Format($this->GetLocalizerCaptions()->GetMessageString('RequiredValidationMessage'), $this->RenderText($editColumn->GetCaption()))); $editor->GetValidatorCollection()->AddValidator($validator); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); // // Edit column for dept_id field // $editor = new ComboBox('dept_id_edit', $this->GetLocalizerCaptions()->GetMessageString('PleaseSelect')); $lookupDataset = new TableDataset(new MyConnectionFactory(), GetConnectionOptions(), '`department`'); $field = new IntegerField('DEPT_ID', null, null, true); $field->SetIsNotNull(true); $lookupDataset->AddField($field, true); $field = new StringField('DEPARTMENT'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, false); $field = new IntegerField('MANAGER'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, false); $field = new IntegerField('DIRECTOR'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, false); $field = new StringField('LOCATION'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, false); $field = new StringField('PHONE_NO'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, false); $lookupDataset->SetOrderBy('DEPARTMENT', GetOrderTypeAsSQL(otAscending)); $editColumn = new LookUpEditColumn('Department', 'dept_id', $editor, $this->dataset, 'DEPT_ID', 'DEPARTMENT', $lookupDataset); $validator = new RequiredValidator(StringUtils::Format($this->GetLocalizerCaptions()->GetMessageString('RequiredValidationMessage'), $this->RenderText($editColumn->GetCaption()))); $editor->GetValidatorCollection()->AddValidator($validator); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); // // Edit column for position field // $editor = new TextEdit('position_edit'); $editor->SetSize(50); $editor->SetMaxLength(50); $editColumn = new CustomEditColumn('Position', 'position', $editor, $this->dataset); $editColumn->SetAllowSetToNull(true); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); // // Edit column for emp_number field // $editor = new TextEdit('emp_number_edit'); $editor->SetSize(20); $editor->SetMaxLength(20); $editColumn = new CustomEditColumn('Employee No', 'emp_number', $editor, $this->dataset); $editColumn->SetAllowSetToNull(true); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); // // Edit column for picture field // $editor = new ImageUploader('picture_edit'); $editor->SetShowImage(true); $editColumn = new UploadFileToFolderColumn('Picture', 'picture', $editor, $this->dataset, false, false, 'images'); $editColumn->OnCustomFileName->AddListener('picture_GenerateFileName_insert', $this); $editColumn->SetReplaceUploadedFileIfExist(true); $editColumn->SetGenerationImageThumbnails('picture', 'images', Delegate::CreateFromMethod($this, 'picture_Thumbnail_GenerateFileName_insert'), new ImageFitByHeightResizeFilter(100)); $editColumn->SetAllowSetToNull(true); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); if ($this->GetSecurityInfo()->HasAddGrant()) { $grid->SetShowAddButton(true); $grid->SetShowInlineAddButton(false); } else { $grid->SetShowInlineAddButton(false); $grid->SetShowAddButton(false); } }
protected function AddInsertColumns(Grid $grid) { // // Edit column for idFacturas field // $editor = new TextEdit('idfacturas_edit'); $editColumn = new CustomEditColumn('IdFacturas', 'idFacturas', $editor, $this->dataset); $validator = new RequiredValidator(StringUtils::Format($this->GetLocalizerCaptions()->GetMessageString('RequiredValidationMessage'), $this->RenderText($editColumn->GetCaption()))); $editor->GetValidatorCollection()->AddValidator($validator); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); // // Edit column for Fecha field // $editor = new TextEdit('fecha_edit'); $editor->SetSize(20); $editor->SetMaxLength(20); $editColumn = new CustomEditColumn('Fecha', 'Fecha', $editor, $this->dataset); $editColumn->SetAllowSetToNull(true); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); // // Edit column for OCompra field // $editor = new TextEdit('ocompra_edit'); $editor->SetSize(45); $editor->SetMaxLength(45); $editColumn = new CustomEditColumn('OCompra', 'OCompra', $editor, $this->dataset); $validator = new RequiredValidator(StringUtils::Format($this->GetLocalizerCaptions()->GetMessageString('RequiredValidationMessage'), $this->RenderText($editColumn->GetCaption()))); $editor->GetValidatorCollection()->AddValidator($validator); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); // // Edit column for OSalida field // $editor = new TextEdit('osalida_edit'); $editor->SetSize(45); $editor->SetMaxLength(45); $editColumn = new CustomEditColumn('OSalida', 'OSalida', $editor, $this->dataset); $validator = new RequiredValidator(StringUtils::Format($this->GetLocalizerCaptions()->GetMessageString('RequiredValidationMessage'), $this->RenderText($editColumn->GetCaption()))); $editor->GetValidatorCollection()->AddValidator($validator); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); // // Edit column for FormaPago field // $editor = new TextEdit('formapago_edit'); $editor->SetSize(20); $editor->SetMaxLength(20); $editColumn = new CustomEditColumn('FormaPago', 'FormaPago', $editor, $this->dataset); $editColumn->SetAllowSetToNull(true); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); // // Edit column for Subtotal field // $editor = new TextEdit('subtotal_edit'); $editor->SetSize(45); $editor->SetMaxLength(45); $editColumn = new CustomEditColumn('Subtotal', 'Subtotal', $editor, $this->dataset); $editColumn->SetAllowSetToNull(true); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); // // Edit column for IVA field // $editor = new TextEdit('iva_edit'); $editor->SetSize(45); $editor->SetMaxLength(45); $editColumn = new CustomEditColumn('IVA', 'IVA', $editor, $this->dataset); $editColumn->SetAllowSetToNull(true); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); // // Edit column for Descuentos field // $editor = new TextEdit('descuentos_edit'); $editor->SetSize(45); $editor->SetMaxLength(45); $editColumn = new CustomEditColumn('Descuentos', 'Descuentos', $editor, $this->dataset); $validator = new RequiredValidator(StringUtils::Format($this->GetLocalizerCaptions()->GetMessageString('RequiredValidationMessage'), $this->RenderText($editColumn->GetCaption()))); $editor->GetValidatorCollection()->AddValidator($validator); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); // // Edit column for Total field // $editor = new TextEdit('total_edit'); $editor->SetSize(45); $editor->SetMaxLength(45); $editColumn = new CustomEditColumn('Total', 'Total', $editor, $this->dataset); $editColumn->SetAllowSetToNull(true); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); // // Edit column for SaldoFact field // $editor = new TextEdit('saldofact_edit'); $editor->SetSize(45); $editor->SetMaxLength(45); $editColumn = new CustomEditColumn('SaldoFact', 'SaldoFact', $editor, $this->dataset); $validator = new RequiredValidator(StringUtils::Format($this->GetLocalizerCaptions()->GetMessageString('RequiredValidationMessage'), $this->RenderText($editColumn->GetCaption()))); $editor->GetValidatorCollection()->AddValidator($validator); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); // // Edit column for TotalCostos field // $editor = new TextEdit('totalcostos_edit'); $editor->SetSize(45); $editor->SetMaxLength(45); $editColumn = new CustomEditColumn('TotalCostos', 'TotalCostos', $editor, $this->dataset); $validator = new RequiredValidator(StringUtils::Format($this->GetLocalizerCaptions()->GetMessageString('RequiredValidationMessage'), $this->RenderText($editColumn->GetCaption()))); $editor->GetValidatorCollection()->AddValidator($validator); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); // // Edit column for Cotizaciones_idCotizaciones field // $editor = new TextEdit('cotizaciones_idcotizaciones_edit'); $editor->SetSize(45); $editor->SetMaxLength(45); $editColumn = new CustomEditColumn('Cotizaciones IdCotizaciones', 'Cotizaciones_idCotizaciones', $editor, $this->dataset); $validator = new RequiredValidator(StringUtils::Format($this->GetLocalizerCaptions()->GetMessageString('RequiredValidationMessage'), $this->RenderText($editColumn->GetCaption()))); $editor->GetValidatorCollection()->AddValidator($validator); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); // // Edit column for EmpresaPro_idEmpresaPro field // $editor = new TextEdit('empresapro_idempresapro_edit'); $editColumn = new CustomEditColumn('EmpresaPro IdEmpresaPro', 'EmpresaPro_idEmpresaPro', $editor, $this->dataset); $validator = new RequiredValidator(StringUtils::Format($this->GetLocalizerCaptions()->GetMessageString('RequiredValidationMessage'), $this->RenderText($editColumn->GetCaption()))); $editor->GetValidatorCollection()->AddValidator($validator); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); // // Edit column for Usuarios_idUsuarios field // $editor = new TextEdit('usuarios_idusuarios_edit'); $editColumn = new CustomEditColumn('Usuarios IdUsuarios', 'Usuarios_idUsuarios', $editor, $this->dataset); $validator = new RequiredValidator(StringUtils::Format($this->GetLocalizerCaptions()->GetMessageString('RequiredValidationMessage'), $this->RenderText($editColumn->GetCaption()))); $editor->GetValidatorCollection()->AddValidator($validator); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); // // Edit column for Clientes_idClientes field // $editor = new TextEdit('clientes_idclientes_edit'); $editColumn = new CustomEditColumn('Clientes IdClientes', 'Clientes_idClientes', $editor, $this->dataset); $validator = new RequiredValidator(StringUtils::Format($this->GetLocalizerCaptions()->GetMessageString('RequiredValidationMessage'), $this->RenderText($editColumn->GetCaption()))); $editor->GetValidatorCollection()->AddValidator($validator); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); // // Edit column for CentroCosto field // $editor = new ComboBox('centrocosto_edit', $this->GetLocalizerCaptions()->GetMessageString('PleaseSelect')); $lookupDataset = new TableDataset(new MyConnectionFactory(), GetConnectionOptions(), '`servicio`'); $field = new IntegerField('id', null, null, true); $field->SetIsNotNull(true); $lookupDataset->AddField($field, true); $field = new IntegerField('empresa_id'); $lookupDataset->AddField($field, false); $field = new StringField('nombre'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, false); $field = new StringField('estado'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, false); $lookupDataset->SetOrderBy('nombre', GetOrderTypeAsSQL(otAscending)); $editColumn = new LookUpEditColumn('CentroCosto', 'CentroCosto', $editor, $this->dataset, 'id', 'nombre', $lookupDataset); $editColumn->SetAllowSetToNull(true); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); if ($this->GetSecurityInfo()->HasAddGrant()) { $grid->SetShowAddButton(true); $grid->SetShowInlineAddButton(false); } else { $grid->SetShowInlineAddButton(false); $grid->SetShowAddButton(false); } }
protected function AddInsertColumns(Grid $grid) { // // Edit column for state field // $editor = new ComboBox('state_edit', $this->GetLocalizerCaptions()->GetMessageString('PleaseSelect')); $lookupDataset = new TableDataset(new PgConnectionFactory(), GetConnectionOptions(), '"public"."state"'); $field = new StringField('abbr'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, true); $field = new StringField('name'); $lookupDataset->AddField($field, false); $lookupDataset->SetOrderBy('name', GetOrderTypeAsSQL(otAscending)); $editColumn = new LookUpEditColumn('State', 'state', $editor, $this->dataset, 'abbr', 'name', $lookupDataset); $editColumn->SetAllowSetToNull(true); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); // // Edit column for name field // $editor = new TextEdit('name_edit'); $editor->SetSize(50); $editor->SetMaxLength(50); $editColumn = new CustomEditColumn('District Name', 'name', $editor, $this->dataset); $editColumn->SetAllowSetToNull(true); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); // // Edit column for level_id field // $editor = new ComboBox('level_id_edit', $this->GetLocalizerCaptions()->GetMessageString('PleaseSelect')); $lookupDataset = new TableDataset(new PgConnectionFactory(), GetConnectionOptions(), '"public"."level"'); $field = new StringField('id'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, true); $field = new StringField('name'); $lookupDataset->AddField($field, false); $field = new IntegerField('rank'); $lookupDataset->AddField($field, false); $lookupDataset->SetOrderBy('name', GetOrderTypeAsSQL(otAscending)); $editColumn = new LookUpEditColumn('Level of Government', 'level_id', $editor, $this->dataset, 'id', 'name', $lookupDataset); $editColumn->SetAllowSetToNull(true); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); // // Edit column for election_div_id field // $editor = new MultiLevelComboBoxEditor('election_div_id_edit', $this->CreateLinkBuilder()); $dataset0 = new TableDataset(new PgConnectionFactory(), GetConnectionOptions(), '"public"."state"'); $field = new StringField('abbr'); $field->SetIsNotNull(true); $dataset0->AddField($field, true); $field = new StringField('name'); $dataset0->AddField($field, false); $editor->AddLevel($dataset0, 'abbr', 'name', $this->RenderText('State'), null); $dataset1 = new TableDataset(new PgConnectionFactory(), GetConnectionOptions(), '"public"."election_div"'); $field = new IntegerField('id'); $field->SetIsNotNull(true); $dataset1->AddField($field, true); $field = new StringField('name'); $field->SetIsNotNull(true); $dataset1->AddField($field, false); $field = new StringField('phys_addr_addr1'); $dataset1->AddField($field, false); $field = new StringField('phys_addr_addr2'); $dataset1->AddField($field, false); $field = new StringField('phys_addr_city'); $dataset1->AddField($field, false); $field = new StringField('phys_addr_state'); $dataset1->AddField($field, false); $field = new StringField('phys_addr_zip'); $dataset1->AddField($field, false); $field = new StringField('mail_addr_addr1'); $dataset1->AddField($field, false); $field = new StringField('mail_addr_addr2'); $dataset1->AddField($field, false); $field = new StringField('mail_addr_city'); $dataset1->AddField($field, false); $field = new StringField('mail_addr_state'); $dataset1->AddField($field, false); $field = new StringField('mail_addr_zip'); $dataset1->AddField($field, false); $field = new StringField('phone'); $dataset1->AddField($field, false); $field = new StringField('fax'); $dataset1->AddField($field, false); $field = new StringField('website'); $dataset1->AddField($field, false); $field = new StringField('notes'); $dataset1->AddField($field, false); $dataset1->SetOrderBy('name', GetOrderTypeAsSQL(otAscending)); $editor->AddLevel($dataset1, 'id', 'name', $this->RenderText('Election Division'), new ForeignKeyInfo('abbr', 'phys_addr_state')); $editColumn = new MultiLevelLookupEditColumn('Election Division', 'election_div_id', $editor, $this->dataset); $editColumn->SetAllowSetToNull(true); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); if ($this->GetSecurityInfo()->HasAddGrant()) { $grid->SetShowAddButton(true); $grid->SetShowInlineAddButton(false); } else { $grid->SetShowInlineAddButton(false); $grid->SetShowAddButton(false); } }
protected function AddInsertColumns(Grid $grid) { // // Edit column for EVENTO_ID field // $editor = new TextEdit('evento_id_edit'); $editColumn = new CustomEditColumn('EVENTO ID', 'EVENTO_ID', $editor, $this->dataset); $validator = new RequiredValidator(StringUtils::Format($this->GetLocalizerCaptions()->GetMessageString('RequiredValidationMessage'), $this->RenderText($editColumn->GetCaption()))); $editor->GetValidatorCollection()->AddValidator($validator); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); // // Edit column for NOMBRE field // $editor = new TextEdit('nombre_edit'); $editor->SetSize(30); $editor->SetMaxLength(30); $editColumn = new CustomEditColumn('NOMBRE', 'NOMBRE', $editor, $this->dataset); $validator = new RequiredValidator(StringUtils::Format($this->GetLocalizerCaptions()->GetMessageString('RequiredValidationMessage'), $this->RenderText($editColumn->GetCaption()))); $editor->GetValidatorCollection()->AddValidator($validator); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); // // Edit column for FECHA_HORA field // $editor = new DateTimeEdit('fecha_hora_edit', false, 'Y-m-d H:i:s', GetFirstDayOfWeek()); $editColumn = new CustomEditColumn('FECHA HORA', 'FECHA_HORA', $editor, $this->dataset); $validator = new RequiredValidator(StringUtils::Format($this->GetLocalizerCaptions()->GetMessageString('RequiredValidationMessage'), $this->RenderText($editColumn->GetCaption()))); $editor->GetValidatorCollection()->AddValidator($validator); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); // // Edit column for LUGAR field // $editor = new TextEdit('lugar_edit'); $editor->SetSize(30); $editor->SetMaxLength(30); $editColumn = new CustomEditColumn('LUGAR', 'LUGAR', $editor, $this->dataset); $validator = new RequiredValidator(StringUtils::Format($this->GetLocalizerCaptions()->GetMessageString('RequiredValidationMessage'), $this->RenderText($editColumn->GetCaption()))); $editor->GetValidatorCollection()->AddValidator($validator); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); // // Edit column for DESCRIPCION field // $editor = new TextAreaEdit('descripcion_edit', 50, 8); $editColumn = new CustomEditColumn('DESCRIPCION', 'DESCRIPCION', $editor, $this->dataset); $validator = new RequiredValidator(StringUtils::Format($this->GetLocalizerCaptions()->GetMessageString('RequiredValidationMessage'), $this->RenderText($editColumn->GetCaption()))); $editor->GetValidatorCollection()->AddValidator($validator); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); // // Edit column for CIUDAD field // $editor = new ComboBox('ciudad_edit', $this->GetLocalizerCaptions()->GetMessageString('PleaseSelect')); $lookupDataset = new TableDataset(new OracleConnectionFactory(), GetConnectionOptions(), '"GE"."CIUDAD"'); $field = new IntegerField('CIUDAD_ID'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, true); $field = new StringField('NOMBRE'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, false); $field = new IntegerField('PAIS_ID'); $lookupDataset->AddField($field, false); $field = new DateField('FEC_CREACION'); $lookupDataset->AddField($field, false); $field = new StringField('USUARIO_CREACION'); $lookupDataset->AddField($field, false); $field = new DateField('FEC_ULTIMA_MOD'); $lookupDataset->AddField($field, false); $field = new StringField('USUARIO_ULTIMA_MOD'); $lookupDataset->AddField($field, false); $lookupDataset->SetOrderBy('NOMBRE', GetOrderTypeAsSQL(otAscending)); $editColumn = new LookUpEditColumn('CIUDAD', 'CIUDAD', $editor, $this->dataset, 'CIUDAD_ID', 'NOMBRE', $lookupDataset); $editColumn->SetAllowSetToNull(true); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); if ($this->GetSecurityInfo()->HasAddGrant()) { $grid->SetShowAddButton(true); $grid->SetShowInlineAddButton(false); } else { $grid->SetShowInlineAddButton(false); $grid->SetShowAddButton(false); } }
protected function AddInsertColumns(Grid $grid) { // // Edit column for FOTO_ID field // $editor = new TextEdit('foto_id_edit'); $editColumn = new CustomEditColumn('FOTO ID', 'FOTO_ID', $editor, $this->dataset); $validator = new RequiredValidator(StringUtils::Format($this->GetLocalizerCaptions()->GetMessageString('RequiredValidationMessage'), $this->RenderText($editColumn->GetCaption()))); $editor->GetValidatorCollection()->AddValidator($validator); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); // // Edit column for RUTA field // $editor = new ImageUploader('ruta_edit'); $editor->SetShowImage(false); $editColumn = new FileUploadingColumn('RUTA', 'RUTA', $editor, $this->dataset, false, false, 'GE_FOTOGrid_RUTA_handler_insert'); $validator = new RequiredValidator(StringUtils::Format($this->GetLocalizerCaptions()->GetMessageString('RequiredValidationMessage'), $this->RenderText($editColumn->GetCaption()))); $editor->GetValidatorCollection()->AddValidator($validator); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); // // Edit column for USERNAME field // $editor = new ComboBox('username_edit', $this->GetLocalizerCaptions()->GetMessageString('PleaseSelect')); $lookupDataset = new TableDataset(new OracleConnectionFactory(), GetConnectionOptions(), '"GE"."PERSONA"'); $field = new StringField('USERNAME'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, true); $field = new StringField('ES_ADMIN'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, false); $field = new DateField('NACIMIENTO'); $lookupDataset->AddField($field, false); $field = new StringField('PRIMER_APELLIDO'); $lookupDataset->AddField($field, false); $field = new StringField('SEGUNDO_APELLIDO'); $lookupDataset->AddField($field, false); $field = new StringField('NOMBRE'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, false); $field = new IntegerField('GENERO_ID'); $lookupDataset->AddField($field, false); $field = new IntegerField('CIUDAD_ID'); $lookupDataset->AddField($field, false); $field = new StringField('SLOGAN'); $lookupDataset->AddField($field, false); $field = new DateField('FEC_CREACION'); $lookupDataset->AddField($field, false); $field = new StringField('USUARIO_CREACION'); $lookupDataset->AddField($field, false); $field = new DateField('FEC_ULTIMA_MOD'); $lookupDataset->AddField($field, false); $field = new StringField('USUARIO_ULTIMA_MOD'); $lookupDataset->AddField($field, false); $field = new StringField('EMAIL'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, false); $field = new StringField('CLAVE'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, false); $lookupDataset->SetOrderBy('ES_ADMIN', GetOrderTypeAsSQL(otAscending)); $editColumn = new LookUpEditColumn('USERNAME', 'USERNAME', $editor, $this->dataset, 'USERNAME', 'ES_ADMIN', $lookupDataset); $validator = new RequiredValidator(StringUtils::Format($this->GetLocalizerCaptions()->GetMessageString('RequiredValidationMessage'), $this->RenderText($editColumn->GetCaption()))); $editor->GetValidatorCollection()->AddValidator($validator); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); // // Edit column for TITULO field // $editor = new TextEdit('titulo_edit'); $editor->SetSize(40); $editor->SetMaxLength(40); $editColumn = new CustomEditColumn('TITULO', 'TITULO', $editor, $this->dataset); $validator = new RequiredValidator(StringUtils::Format($this->GetLocalizerCaptions()->GetMessageString('RequiredValidationMessage'), $this->RenderText($editColumn->GetCaption()))); $editor->GetValidatorCollection()->AddValidator($validator); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); if ($this->GetSecurityInfo()->HasAddGrant()) { $grid->SetShowAddButton(true); $grid->SetShowInlineAddButton(false); } else { $grid->SetShowInlineAddButton(false); $grid->SetShowAddButton(false); } }
protected function AddInsertColumns(Grid $grid) { // // Edit column for programm_id field // $editor = new ComboBox('programm_id_edit', $this->GetLocalizerCaptions()->GetMessageString('PleaseSelect')); $lookupDataset = new TableDataset(new MyConnectionFactory(), GetConnectionOptions(), '`program`'); $field = new IntegerField('program_id', null, null, true); $field->SetIsNotNull(true); $lookupDataset->AddField($field, true); $field = new StringField('program_name'); $lookupDataset->AddField($field, false); $field = new StringField('year'); $lookupDataset->AddField($field, false); $field = new StringField('multi'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, false); $field = new StringField('description'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, false); $field = new StringField('lead'); $lookupDataset->AddField($field, false); $field = new DateField('date_start'); $lookupDataset->AddField($field, false); $field = new DateField('date_end'); $lookupDataset->AddField($field, false); $field = new IntegerField('progress'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, false); $field = new StringField('notes'); $lookupDataset->AddField($field, false); $lookupDataset->SetOrderBy('program_name', GetOrderTypeAsSQL(otAscending)); $editColumn = new LookUpEditColumn('Project Type', 'programm_id', $editor, $this->dataset, 'program_id', 'program_name', $lookupDataset); $validator = new RequiredValidator(StringUtils::Format($this->GetLocalizerCaptions()->GetMessageString('RequiredValidationMessage'), $this->RenderText($editColumn->GetCaption()))); $editor->GetValidatorCollection()->AddValidator($validator); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); // // Edit column for project_name field // $editor = new TextEdit('project_name_edit'); $editColumn = new CustomEditColumn('Project Name', 'project_name', $editor, $this->dataset); $validator = new RequiredValidator(StringUtils::Format($this->GetLocalizerCaptions()->GetMessageString('RequiredValidationMessage'), $this->RenderText($editColumn->GetCaption()))); $editor->GetValidatorCollection()->AddValidator($validator); $validator = new CustomRegExpValidator('^[A-Za-z0-9 ]+[-]*[A-Za-z0-9 ]*$', StringUtils::Format($this->GetLocalizerCaptions()->GetMessageString('RegExpValidationMessage'), $this->RenderText($editColumn->GetCaption()))); $editor->GetValidatorCollection()->AddValidator($validator); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); // // Edit column for date_start field // $editor = new DateTimeEdit('date_start_edit', false, 'Y-m-d', GetFirstDayOfWeek()); $editColumn = new CustomEditColumn('Date Start', 'date_start', $editor, $this->dataset); $editColumn->SetInsertDefaultValue($this->RenderText('%CURRENT_DATE%')); $validator = new RequiredValidator(StringUtils::Format($this->GetLocalizerCaptions()->GetMessageString('RequiredValidationMessage'), $this->RenderText($editColumn->GetCaption()))); $editor->GetValidatorCollection()->AddValidator($validator); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); // // Edit column for date_end field // $editor = new DateTimeEdit('date_end_edit', true, 'Y-m-d', GetFirstDayOfWeek()); $editColumn = new CustomEditColumn('Date End', 'date_end', $editor, $this->dataset); $editColumn->SetInsertDefaultValue($this->RenderText('%CURRENT_DATE%')); $validator = new RequiredValidator(StringUtils::Format($this->GetLocalizerCaptions()->GetMessageString('RequiredValidationMessage'), $this->RenderText($editColumn->GetCaption()))); $editor->GetValidatorCollection()->AddValidator($validator); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); // // Edit column for year field // $editor = new TextEdit('year_edit'); $editColumn = new CustomEditColumn('Year', 'year', $editor, $this->dataset); $editColumn->SetInsertDefaultValue($this->RenderText('2015')); $validator = new RequiredValidator(StringUtils::Format($this->GetLocalizerCaptions()->GetMessageString('RequiredValidationMessage'), $this->RenderText($editColumn->GetCaption()))); $editor->GetValidatorCollection()->AddValidator($validator); $validator = new NumberValidator(StringUtils::Format($this->GetLocalizerCaptions()->GetMessageString('NumberValidationMessage'), $this->RenderText($editColumn->GetCaption()))); $editor->GetValidatorCollection()->AddValidator($validator); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); // // Edit column for notes field // $editor = new TextAreaEdit('notes_edit', 50, 8); $editColumn = new CustomEditColumn('Objectives', 'notes', $editor, $this->dataset); $editColumn->SetAllowSetToNull(true); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); // // Edit column for priority field // $editor = new ComboBox('priority_edit', $this->GetLocalizerCaptions()->GetMessageString('PleaseSelect')); $lookupDataset = new TableDataset(new MyConnectionFactory(), GetConnectionOptions(), '`Priority`'); $field = new IntegerField('id', null, null, true); $field->SetIsNotNull(true); $lookupDataset->AddField($field, true); $field = new StringField('Name'); $lookupDataset->AddField($field, false); $lookupDataset->SetOrderBy('Name', GetOrderTypeAsSQL(otAscending)); $editColumn = new LookUpEditColumn('Priority', 'priority', $editor, $this->dataset, 'Name', 'Name', $lookupDataset); $editColumn->SetCaptionTemplate($this->RenderText('%Name%')); $validator = new RequiredValidator(StringUtils::Format($this->GetLocalizerCaptions()->GetMessageString('RequiredValidationMessage'), $this->RenderText($editColumn->GetCaption()))); $editor->GetValidatorCollection()->AddValidator($validator); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); // // Edit column for lead field // $editor = new ComboBox('lead_edit', $this->GetLocalizerCaptions()->GetMessageString('PleaseSelect')); $lookupDataset = new TableDataset(new MyConnectionFactory(), GetConnectionOptions(), '`staff`'); $field = new IntegerField('staff_id', null, null, true); $field->SetIsNotNull(true); $lookupDataset->AddField($field, true); $field = new StringField('username'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, false); $field = new StringField('email'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, false); $field = new StringField('picture'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, false); $field = new StringField('password'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, false); $field = new IntegerField('dept_id'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, false); $field = new StringField('position'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, false); $field = new StringField('emp_number'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, false); $lookupDataset->SetOrderBy('username', GetOrderTypeAsSQL(otAscending)); $editColumn = new LookUpEditColumn('Project Lead', 'lead', $editor, $this->dataset, 'staff_id', 'username', $lookupDataset); $editColumn->SetCaptionTemplate($this->RenderText('%username%')); $editColumn->SetInsertDefaultValue($this->RenderText('%CURRENT_USER_ID%')); $validator = new RequiredValidator(StringUtils::Format($this->GetLocalizerCaptions()->GetMessageString('RequiredValidationMessage'), $this->RenderText($editColumn->GetCaption()))); $editor->GetValidatorCollection()->AddValidator($validator); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); // // Edit column for approved_budget field // $editor = new TextEdit('approved_budget_edit'); $editor->SetPlaceholder($this->RenderText('currency value without comma')); $editor->SetPrefix($this->RenderText('$')); $editor->SetSuffix($this->RenderText('.00')); $editColumn = new CustomEditColumn('Approved Budget', 'approved_budget', $editor, $this->dataset); $editColumn->SetInsertDefaultValue($this->RenderText('0')); $validator = new RequiredValidator(StringUtils::Format($this->GetLocalizerCaptions()->GetMessageString('RequiredValidationMessage'), $this->RenderText($editColumn->GetCaption()))); $editor->GetValidatorCollection()->AddValidator($validator); $validator = new CustomRegExpValidator('^[0-9]*$', StringUtils::Format($this->GetLocalizerCaptions()->GetMessageString('RegExpValidationMessage'), $this->RenderText($editColumn->GetCaption()))); $editor->GetValidatorCollection()->AddValidator($validator); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); // // Edit column for budget_spent field // $editor = new TextEdit('budget_spent_edit'); $editor->SetPlaceholder($this->RenderText('currency value without comma')); $editor->SetPrefix($this->RenderText('$')); $editor->SetSuffix($this->RenderText('.00')); $editColumn = new CustomEditColumn('Budget Spent', 'budget_spent', $editor, $this->dataset); $editColumn->SetAllowSetToNull(true); $editColumn->SetInsertDefaultValue($this->RenderText('0')); $validator = new CustomRegExpValidator('^[0-9]*$', StringUtils::Format($this->GetLocalizerCaptions()->GetMessageString('RegExpValidationMessage'), $this->RenderText($editColumn->GetCaption()))); $editor->GetValidatorCollection()->AddValidator($validator); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); // // Edit column for multi_year field // $editor = new CheckBox('multi_year_edit'); $editColumn = new CustomEditColumn('Multi Year', 'multi_year', $editor, $this->dataset); $editColumn->SetAllowSetToNull(true); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); // // Edit column for public_engagement field // $editor = new ComboBox('public_engagement_edit', $this->GetLocalizerCaptions()->GetMessageString('PleaseSelect')); $editor->AddValue('0 - No Public Engagement (CAO Authorization Only)', $this->RenderText('0 - No Public Engagement (CAO Authorization Only)')); $editor->AddValue('1 - Inform', $this->RenderText('1 - Inform')); $editor->AddValue('2 - Consult', $this->RenderText('2 - Consult')); $editor->AddValue('3 - Involve ', $this->RenderText('3 - Involve')); $editor->AddValue('4 - Collaborate', $this->RenderText('4 - Collaborate')); $editor->AddValue('5- Empower', $this->RenderText('5 - Empower')); $editColumn = new CustomEditColumn('Public Engagement', 'public_engagement', $editor, $this->dataset); $editColumn->SetAllowSetToNull(true); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); // // Edit column for level_of_service field // $editor = new ComboBox('level_of_service_edit', $this->GetLocalizerCaptions()->GetMessageString('PleaseSelect')); $editor->AddValue('Maintain existing Level Of Service', $this->RenderText('Maintain existing Level Of Service')); $editor->AddValue('Upgrade Level Of Service', $this->RenderText('Upgrade Level Of Service')); $editor->AddValue('Downgrade Level Of Service', $this->RenderText('Downgrade Level Of Service')); $editor->AddValue('New Level Of Service/Asset(s)', $this->RenderText('New Level Of Service/Asset(s)')); $editor->AddValue('Eliminate Level Of Service/Asset(s)', $this->RenderText('Eliminate Level Of Service/Asset(s)')); $editor->AddValue('One-Time only Project', $this->RenderText('One-Time only Project')); $editColumn = new CustomEditColumn('Level Of Service', 'level_of_service', $editor, $this->dataset); $validator = new RequiredValidator(StringUtils::Format($this->GetLocalizerCaptions()->GetMessageString('RequiredValidationMessage'), $this->RenderText($editColumn->GetCaption()))); $editor->GetValidatorCollection()->AddValidator($validator); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); // // Edit column for approved field // $editor = new CheckBox('approved_edit'); $editColumn = new CustomEditColumn('Approved by CAO', 'approved', $editor, $this->dataset); $editColumn->SetAllowSetToNull(true); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); // // Edit column for progress field // $editor = new ComboBox('progress_edit', $this->GetLocalizerCaptions()->GetMessageString('PleaseSelect')); $editor->AddValue('0', $this->RenderText('Zero Percent')); $editor->AddValue('0.10', $this->RenderText('10 Percent')); $editor->AddValue('0.20', $this->RenderText('20 Percent')); $editor->AddValue('0.30', $this->RenderText('30 Percent')); $editor->AddValue('0.40', $this->RenderText('40 Percent')); $editor->AddValue('0.5', $this->RenderText('50 Percent')); $editor->AddValue('0.6', $this->RenderText('60 Percent')); $editor->AddValue('0.7', $this->RenderText('70 Percent')); $editor->AddValue('0.8', $this->RenderText('80 Percent')); $editor->AddValue('0.9', $this->RenderText('90 Percent')); $editor->AddValue('1', $this->RenderText('100 Percent')); $editColumn = new CustomEditColumn('Progress', 'progress', $editor, $this->dataset); $editColumn->SetAllowSetToNull(true); $editColumn->SetInsertDefaultValue($this->RenderText('0')); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); // // Edit column for dept_id field // $editor = new ComboBox('dept_id_edit', $this->GetLocalizerCaptions()->GetMessageString('PleaseSelect')); $lookupDataset = new TableDataset(new MyConnectionFactory(), GetConnectionOptions(), '`department`'); $field = new IntegerField('DEPT_ID', null, null, true); $field->SetIsNotNull(true); $lookupDataset->AddField($field, true); $field = new StringField('DEPARTMENT'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, false); $field = new IntegerField('MANAGER'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, false); $field = new IntegerField('DIRECTOR'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, false); $field = new StringField('LOCATION'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, false); $field = new StringField('PHONE_NO'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, false); $lookupDataset->SetOrderBy('DEPARTMENT', GetOrderTypeAsSQL(otAscending)); $editColumn = new LookUpEditColumn('Department', 'dept_id', $editor, $this->dataset, 'DEPT_ID', 'DEPARTMENT', $lookupDataset); $validator = new RequiredValidator(StringUtils::Format($this->GetLocalizerCaptions()->GetMessageString('RequiredValidationMessage'), $this->RenderText($editColumn->GetCaption()))); $editor->GetValidatorCollection()->AddValidator($validator); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); if ($this->GetSecurityInfo()->HasAddGrant()) { $grid->SetShowAddButton(true); $grid->SetShowInlineAddButton(false); } else { $grid->SetShowInlineAddButton(false); $grid->SetShowAddButton(false); } }
protected function AddInsertColumns(Grid $grid) { // // Edit column for election_div_id field // $editor = new MultiLevelComboBoxEditor('election_div_id_edit', $this->CreateLinkBuilder()); $dataset0 = new TableDataset(new PgConnectionFactory(), GetConnectionOptions(), '"public"."state"'); $field = new StringField('abbr'); $field->SetIsNotNull(true); $dataset0->AddField($field, true); $field = new StringField('name'); $dataset0->AddField($field, false); $editor->AddLevel($dataset0, 'abbr', 'name', $this->RenderText('State'), null); $dataset1 = new TableDataset(new PgConnectionFactory(), GetConnectionOptions(), '"public"."election_div"'); $field = new IntegerField('id'); $field->SetIsNotNull(true); $dataset1->AddField($field, true); $field = new StringField('name'); $field->SetIsNotNull(true); $dataset1->AddField($field, false); $field = new StringField('phys_addr_addr1'); $dataset1->AddField($field, false); $field = new StringField('phys_addr_addr2'); $dataset1->AddField($field, false); $field = new StringField('phys_addr_city'); $dataset1->AddField($field, false); $field = new StringField('phys_addr_state'); $dataset1->AddField($field, false); $field = new StringField('phys_addr_zip'); $dataset1->AddField($field, false); $field = new StringField('mail_addr_addr1'); $dataset1->AddField($field, false); $field = new StringField('mail_addr_addr2'); $dataset1->AddField($field, false); $field = new StringField('mail_addr_city'); $dataset1->AddField($field, false); $field = new StringField('mail_addr_state'); $dataset1->AddField($field, false); $field = new StringField('mail_addr_zip'); $dataset1->AddField($field, false); $field = new StringField('phone'); $dataset1->AddField($field, false); $field = new StringField('fax'); $dataset1->AddField($field, false); $field = new StringField('website'); $dataset1->AddField($field, false); $field = new StringField('notes'); $dataset1->AddField($field, false); $dataset1->SetOrderBy('name', GetOrderTypeAsSQL(otAscending)); $editor->AddLevel($dataset1, 'id', 'name', $this->RenderText('Election Division'), new ForeignKeyInfo('abbr', 'phys_addr_state')); $editColumn = new MultiLevelLookupEditColumn('Election Division', 'election_div_id', $editor, $this->dataset); $editColumn->SetAllowSetToNull(true); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); // // Edit column for name field // $editor = new TextEdit('name_edit'); $editor->SetSize(35); $editor->SetMaxLength(35); $editColumn = new CustomEditColumn('Document Name or Description', 'name', $editor, $this->dataset); $validator = new RequiredValidator(StringUtils::Format($this->GetLocalizerCaptions()->GetMessageString('RequiredValidationMessage'), $this->RenderText($editColumn->GetCaption()))); $editor->GetValidatorCollection()->AddValidator($validator); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); // // Edit column for link field // $editor = new TextAreaEdit('link_edit', 50, 8); $editColumn = new CustomEditColumn('URL to Document', 'link', $editor, $this->dataset); $validator = new RequiredValidator(StringUtils::Format($this->GetLocalizerCaptions()->GetMessageString('RequiredValidationMessage'), $this->RenderText($editColumn->GetCaption()))); $editor->GetValidatorCollection()->AddValidator($validator); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); if ($this->GetSecurityInfo()->HasAddGrant()) { $grid->SetShowAddButton(true); $grid->SetShowInlineAddButton(false); } else { $grid->SetShowInlineAddButton(false); $grid->SetShowAddButton(false); } }
protected function AddInsertColumns(Grid $grid) { // // Edit column for USERNAME field // $editor = new TextEdit('username_edit'); $editor->SetSize(10); $editor->SetMaxLength(10); $editColumn = new CustomEditColumn('USERNAME', 'USERNAME', $editor, $this->dataset); $validator = new RequiredValidator(StringUtils::Format($this->GetLocalizerCaptions()->GetMessageString('RequiredValidationMessage'), $this->RenderText($editColumn->GetCaption()))); $editor->GetValidatorCollection()->AddValidator($validator); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); // // Edit column for ES_ADMIN field // $editor = new TextEdit('es_admin_edit'); $editor->SetSize(1); $editor->SetMaxLength(1); $editColumn = new CustomEditColumn('ES ADMIN', 'ES_ADMIN', $editor, $this->dataset); $validator = new RequiredValidator(StringUtils::Format($this->GetLocalizerCaptions()->GetMessageString('RequiredValidationMessage'), $this->RenderText($editColumn->GetCaption()))); $editor->GetValidatorCollection()->AddValidator($validator); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); // // Edit column for NACIMIENTO field // $editor = new DateTimeEdit('nacimiento_edit', false, 'Y-m-d H:i:s', GetFirstDayOfWeek()); $editColumn = new CustomEditColumn('NACIMIENTO', 'NACIMIENTO', $editor, $this->dataset); $editColumn->SetAllowSetToNull(true); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); // // Edit column for PRIMER_APELLIDO field // $editor = new TextEdit('primer_apellido_edit'); $editor->SetSize(30); $editor->SetMaxLength(30); $editColumn = new CustomEditColumn('PRIMER APELLIDO', 'PRIMER_APELLIDO', $editor, $this->dataset); $editColumn->SetAllowSetToNull(true); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); // // Edit column for SEGUNDO_APELLIDO field // $editor = new TextEdit('segundo_apellido_edit'); $editor->SetSize(50); $editor->SetMaxLength(50); $editColumn = new CustomEditColumn('SEGUNDO APELLIDO', 'SEGUNDO_APELLIDO', $editor, $this->dataset); $editColumn->SetAllowSetToNull(true); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); // // Edit column for NOMBRE field // $editor = new TextEdit('nombre_edit'); $editor->SetSize(40); $editor->SetMaxLength(40); $editColumn = new CustomEditColumn('NOMBRE', 'NOMBRE', $editor, $this->dataset); $validator = new RequiredValidator(StringUtils::Format($this->GetLocalizerCaptions()->GetMessageString('RequiredValidationMessage'), $this->RenderText($editColumn->GetCaption()))); $editor->GetValidatorCollection()->AddValidator($validator); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); // // Edit column for GENERO_ID field // $editor = new ComboBox('genero_id_edit', $this->GetLocalizerCaptions()->GetMessageString('PleaseSelect')); $lookupDataset = new TableDataset(new OracleConnectionFactory(), GetConnectionOptions(), '"GE"."GENERO"'); $field = new IntegerField('GENERO_ID'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, true); $field = new StringField('NOMBRE'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, false); $field = new DateField('FEC_CREACION'); $lookupDataset->AddField($field, false); $field = new StringField('USUARIO_CREACION'); $lookupDataset->AddField($field, false); $field = new DateField('FEC_ULTIMA_MOD'); $lookupDataset->AddField($field, false); $field = new StringField('USUARIO_ULTIMA_MOD'); $lookupDataset->AddField($field, false); $lookupDataset->SetOrderBy('NOMBRE', GetOrderTypeAsSQL(otAscending)); $editColumn = new LookUpEditColumn('GENERO ID', 'GENERO_ID', $editor, $this->dataset, 'GENERO_ID', 'NOMBRE', $lookupDataset); $editColumn->SetAllowSetToNull(true); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); // // Edit column for CIUDAD_ID field // $editor = new ComboBox('ciudad_id_edit', $this->GetLocalizerCaptions()->GetMessageString('PleaseSelect')); $lookupDataset = new TableDataset(new OracleConnectionFactory(), GetConnectionOptions(), '"GE"."CIUDAD"'); $field = new IntegerField('CIUDAD_ID'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, true); $field = new StringField('NOMBRE'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, false); $field = new IntegerField('PAIS_ID'); $lookupDataset->AddField($field, false); $field = new DateField('FEC_CREACION'); $lookupDataset->AddField($field, false); $field = new StringField('USUARIO_CREACION'); $lookupDataset->AddField($field, false); $field = new DateField('FEC_ULTIMA_MOD'); $lookupDataset->AddField($field, false); $field = new StringField('USUARIO_ULTIMA_MOD'); $lookupDataset->AddField($field, false); $lookupDataset->SetOrderBy('NOMBRE', GetOrderTypeAsSQL(otAscending)); $editColumn = new LookUpEditColumn('CIUDAD ID', 'CIUDAD_ID', $editor, $this->dataset, 'CIUDAD_ID', 'NOMBRE', $lookupDataset); $editColumn->SetAllowSetToNull(true); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); // // Edit column for SLOGAN field // $editor = new TextAreaEdit('slogan_edit', 50, 8); $editColumn = new CustomEditColumn('SLOGAN', 'SLOGAN', $editor, $this->dataset); $editColumn->SetAllowSetToNull(true); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); // // Edit column for EMAIL field // $editor = new TextAreaEdit('email_edit', 50, 8); $editColumn = new CustomEditColumn('EMAIL', 'EMAIL', $editor, $this->dataset); $validator = new RequiredValidator(StringUtils::Format($this->GetLocalizerCaptions()->GetMessageString('RequiredValidationMessage'), $this->RenderText($editColumn->GetCaption()))); $editor->GetValidatorCollection()->AddValidator($validator); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); // // Edit column for CLAVE field // $editor = new TextEdit('clave_edit'); $editor->SetSize(20); $editor->SetMaxLength(20); $editColumn = new CustomEditColumn('CLAVE', 'CLAVE', $editor, $this->dataset); $validator = new RequiredValidator(StringUtils::Format($this->GetLocalizerCaptions()->GetMessageString('RequiredValidationMessage'), $this->RenderText($editColumn->GetCaption()))); $editor->GetValidatorCollection()->AddValidator($validator); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); if ($this->GetSecurityInfo()->HasAddGrant()) { $grid->SetShowAddButton(true); $grid->SetShowInlineAddButton(false); } else { $grid->SetShowInlineAddButton(false); $grid->SetShowAddButton(false); } }
protected function AddInsertColumns(Grid $grid) { // // Edit column for name field // $editor = new TextEdit('name_edit'); $editColumn = new CustomEditColumn('Name', 'name', $editor, $this->dataset); $validator = new RequiredValidator(StringUtils::Format($this->GetLocalizerCaptions()->GetMessageString('RequiredValidationMessage'), $this->RenderText($editColumn->GetCaption()))); $editor->GetValidatorCollection()->AddValidator($validator); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); // // Edit column for total_hours field // $editor = new TextEdit('total_hours_edit'); $editColumn = new CustomEditColumn('Total Hours', 'total_hours', $editor, $this->dataset); $validator = new RequiredValidator(StringUtils::Format($this->GetLocalizerCaptions()->GetMessageString('RequiredValidationMessage'), $this->RenderText($editColumn->GetCaption()))); $editor->GetValidatorCollection()->AddValidator($validator); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); // // Edit column for date field // $editor = new DateTimeEdit('date_edit', false, 'Y-m-d H:i:s', GetFirstDayOfWeek()); $editColumn = new CustomEditColumn('Date', 'date', $editor, $this->dataset); $validator = new RequiredValidator(StringUtils::Format($this->GetLocalizerCaptions()->GetMessageString('RequiredValidationMessage'), $this->RenderText($editColumn->GetCaption()))); $editor->GetValidatorCollection()->AddValidator($validator); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); // // Edit column for task_id field // $editor = new ComboBox('task_id_edit', $this->GetLocalizerCaptions()->GetMessageString('PleaseSelect')); $lookupDataset = new TableDataset(new MyConnectionFactory(), GetConnectionOptions(), '`task`'); $field = new IntegerField('task_id', null, null, true); $field->SetIsNotNull(true); $lookupDataset->AddField($field, true); $field = new IntegerField('project_id'); $lookupDataset->AddField($field, false); $field = new StringField('assigned_to'); $lookupDataset->AddField($field, false); $field = new DateField('date_start'); $lookupDataset->AddField($field, false); $field = new DateField('date_end'); $lookupDataset->AddField($field, false); $field = new StringField('task_name'); $lookupDataset->AddField($field, false); $field = new StringField('notes'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, false); $field = new IntegerField('hrs'); $lookupDataset->AddField($field, false); $field = new StringField('wo'); $lookupDataset->AddField($field, false); $field = new IntegerField('staff_id'); $lookupDataset->AddField($field, false); $lookupDataset->SetOrderBy('task_name', GetOrderTypeAsSQL(otAscending)); $editColumn = new LookUpEditColumn('Task Id', 'task_id', $editor, $this->dataset, 'task_id', 'task_name', $lookupDataset); $editColumn->SetAllowSetToNull(true); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); // // Edit column for notes field // $editor = new TextEdit('notes_edit'); $editColumn = new CustomEditColumn('Notes', 'notes', $editor, $this->dataset); $validator = new RequiredValidator(StringUtils::Format($this->GetLocalizerCaptions()->GetMessageString('RequiredValidationMessage'), $this->RenderText($editColumn->GetCaption()))); $editor->GetValidatorCollection()->AddValidator($validator); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); if ($this->GetSecurityInfo()->HasAddGrant()) { $grid->SetShowAddButton(false); $grid->SetShowInlineAddButton(false); } else { $grid->SetShowInlineAddButton(false); $grid->SetShowAddButton(false); } }