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 user_id field
//
$editor = new TextEdit('user_id_edit');
$editColumn = new CustomEditColumn('User Id', 'user_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 page_name field
//
$editor = new TextAreaEdit('page_name_edit', 50, 8);
$editColumn = new CustomEditColumn('Page Name', 'page_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 perm_name field
//
$editor = new TextEdit('perm_name_edit');
$editor->SetMaxLength(6);
$editColumn = new CustomEditColumn('Perm Name', 'perm_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);
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('Programm Id', 'programm_id', $editor, $this->dataset, 'program_id', 'program_name', $lookupDataset);
$editColumn->SetAllowSetToNull(true);
$this->ApplyCommonColumnEditProperties($editColumn);
$grid->AddInsertColumn($editColumn);
//
// Edit column for project_name field
//
$editor = new TextAreaEdit('project_name_edit', 50, 8);
$editColumn = new CustomEditColumn('Project Name', 'project_name', $editor, $this->dataset);
$editColumn->SetAllowSetToNull(true);
$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->SetAllowSetToNull(true);
$this->ApplyCommonColumnEditProperties($editColumn);
$grid->AddInsertColumn($editColumn);
//
// Edit column for date_end field
//
$editor = new DateTimeEdit('date_end_edit', true, 'Y-m-d H:i:s', GetFirstDayOfWeek());
$editColumn = new CustomEditColumn('Date End', 'date_end', $editor, $this->dataset);
$editColumn->SetAllowSetToNull(true);
$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);
$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);
$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 priority field
//
$editor = new TextEdit('priority_edit');
$editor->SetSize(100);
$editor->SetMaxLength(100);
$editColumn = new CustomEditColumn('Priority', 'priority', $editor, $this->dataset);
$editColumn->SetAllowSetToNull(true);
$this->ApplyCommonColumnEditProperties($editColumn);
$grid->AddInsertColumn($editColumn);
//
// Edit column for lead field
//
$editor = new TextEdit('lead_edit');
$editor->SetSize(50);
$editor->SetMaxLength(50);
$editColumn = new CustomEditColumn('Lead', 'lead', $editor, $this->dataset);
$editColumn->SetAllowSetToNull(true);
$this->ApplyCommonColumnEditProperties($editColumn);
$grid->AddInsertColumn($editColumn);
//
// Edit column for level_of_service field
//
$editor = new TextEdit('level_of_service_edit');
$editor->SetSize(55);
$editor->SetMaxLength(55);
$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 multi_year field
//
$editor = new TextEdit('multi_year_edit');
$editor->SetSize(10);
$editor->SetMaxLength(10);
$editColumn = new CustomEditColumn('Multi Year', 'multi_year', $editor, $this->dataset);
$editColumn->SetAllowSetToDefault(true);
$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 public_engagement field
//
$editor = new TextEdit('public_engagement_edit');
$editor->SetSize(100);
$editor->SetMaxLength(100);
$editColumn = new CustomEditColumn('Public Engagement', 'public_engagement', $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 year field
//
$editor = new TextEdit('year_edit');
$editor->SetSize(4);
$editor->SetMaxLength(4);
$editColumn = new CustomEditColumn('Year', 'year', $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 TextEdit('approved_edit');
$editor->SetSize(10);
$editor->SetMaxLength(10);
$editColumn = new CustomEditColumn('Approved', 'approved', $editor, $this->dataset);
$editColumn->SetAllowSetToDefault(true);
$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 progress field
//
$editor = new TextEdit('progress_edit');
$editor->SetSize(11);
$editor->SetMaxLength(11);
$editColumn = new CustomEditColumn('Progress', 'progress', $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 TextEdit('dept_id_edit');
$editColumn = new CustomEditColumn('Dept Id', 'dept_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 budget_spent field
//
$editor = new TextEdit('budget_spent_edit');
$editColumn = new CustomEditColumn('Budget Spent', 'budget_spent', $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 CreateGrid()
{
$result = new Grid($this, $this->dataset, 'public_office_docsGrid');
if ($this->GetSecurityInfo()->HasDeleteGrant()) {
$result->SetAllowDeleteSelected(true);
} else {
$result->SetAllowDeleteSelected(false);
}
ApplyCommonPageSettings($this, $result);
$result->SetUseImagesForActions(false);
$result->SetUseFixedHeader(false);
$result->SetShowLineNumbers(false);
$result->SetUseModalInserting(true);
$result->SetHighlightRowAtHover(false);
$result->SetWidth('');
$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(false);
$this->SetExportToWordAvailable(false);
$this->SetExportToXmlAvailable(false);
$this->SetExportToCsvAvailable(false);
$this->SetExportToPdfAvailable(false);
$this->SetPrinterFriendlyAvailable(false);
$this->SetSimpleSearchAvailable(true);
$this->SetAdvancedSearchAvailable(false);
$this->SetFilterRowAvailable(false);
$this->SetVisualEffectsEnabled(false);
$this->SetShowTopPageNavigator(true);
$this->SetShowBottomPageNavigator(true);
//
// Http Handlers
//
//
// View column for link field
//
$column = new TextViewColumn('link', 'URL to Document', $this->dataset);
$column->SetOrderable(true);
/* <inline edit column> */
//
// 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);
$column->SetEditOperationColumn($editColumn);
/* </inline edit column> */
/* <inline insert column> */
//
// 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);
$column->SetInsertOperationColumn($editColumn);
/* </inline insert column> */
$handler = new ShowTextBlobHandler($this->dataset, $this, 'public_office_docsGrid_link_handler_list', $column);
GetApplication()->RegisterHTTPHandler($handler);
//
// View column for link field
//
$column = new TextViewColumn('link', 'URL to Document', $this->dataset);
$column->SetOrderable(true);
$handler = new ShowTextBlobHandler($this->dataset, $this, 'public_office_docsGrid_link_handler_view', $column);
GetApplication()->RegisterHTTPHandler($handler);
return $result;
}
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 project_id field
//
$editor = new ComboBox('project_id_edit', $this->GetLocalizerCaptions()->GetMessageString('PleaseSelect'));
$editColumn = new CustomEditColumn('Parent Project', 'project_id', $editor, $this->dataset);
$editColumn->SetReadOnly(true);
$editColumn->setEnabled(false);
$editColumn->SetAllowSetToNull(true);
$this->ApplyCommonColumnEditProperties($editColumn);
$grid->AddInsertColumn($editColumn);
//
// Edit column for assigned_to field
//
$editor = new TextEdit('assigned_to_edit');
$editor->SetSize(50);
$editor->SetMaxLength(50);
$editColumn = new CustomEditColumn('Assigned To', 'assigned_to', $editor, $this->dataset);
$editColumn->SetAllowSetToNull(true);
$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->SetAllowSetToNull(true);
$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->SetAllowSetToNull(true);
$this->ApplyCommonColumnEditProperties($editColumn);
$grid->AddInsertColumn($editColumn);
//
// Edit column for task_name field
//
$editor = new TextAreaEdit('task_name_edit', 50, 8);
$editColumn = new CustomEditColumn('Task Name', 'task_name', $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);
$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 hrs field
//
$editor = new TextEdit('hrs_edit');
$editColumn = new CustomEditColumn('Hrs', 'hrs', $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 CreateGrid()
{
$result = new Grid($this, $this->dataset, 'act_movimientosGrid');
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 Entrega field
//
$column = new TextViewColumn('Entrega', 'Entrega', $this->dataset);
$column->SetOrderable(true);
/* <inline edit column> */
//
// Edit column for Entrega field
//
$editor = new TextEdit('entrega_edit');
$editor->SetSize(100);
$editor->SetMaxLength(100);
$editColumn = new CustomEditColumn('Entrega', 'Entrega', $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 Entrega field
//
$editor = new TextEdit('entrega_edit');
$editor->SetSize(100);
$editor->SetMaxLength(100);
$editColumn = new CustomEditColumn('Entrega', 'Entrega', $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, 'Entrega_handler', $column);
GetApplication()->RegisterHTTPHandler($handler);
//
// View column for Recibe field
//
$column = new TextViewColumn('Recibe', 'Recibe', $this->dataset);
$column->SetOrderable(true);
/* <inline edit column> */
//
// Edit column for Recibe field
//
$editor = new TextEdit('recibe_edit');
$editor->SetSize(100);
$editor->SetMaxLength(100);
$editColumn = new CustomEditColumn('Recibe', 'Recibe', $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 Recibe field
//
$editor = new TextEdit('recibe_edit');
$editor->SetSize(100);
$editor->SetMaxLength(100);
$editColumn = new CustomEditColumn('Recibe', 'Recibe', $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, 'Recibe_handler', $column);
GetApplication()->RegisterHTTPHandler($handler);
//
// View column for MotivoMovimiento field
//
$column = new TextViewColumn('MotivoMovimiento', 'MotivoMovimiento', $this->dataset);
$column->SetOrderable(true);
/* <inline edit column> */
//
// Edit column for MotivoMovimiento field
//
$editor = new TextAreaEdit('motivomovimiento_edit', 50, 8);
$editColumn = new CustomEditColumn('MotivoMovimiento', 'MotivoMovimiento', $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 MotivoMovimiento field
//
$editor = new TextAreaEdit('motivomovimiento_edit', 50, 8);
$editColumn = new CustomEditColumn('MotivoMovimiento', 'MotivoMovimiento', $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, 'MotivoMovimiento_handler', $column);
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);
$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 Observaciones field
//
$editor = new TextAreaEdit('observaciones_edit', 50, 8);
$editColumn = new CustomEditColumn('Observaciones', 'Observaciones', $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, 'Observaciones_handler', $column);
GetApplication()->RegisterHTTPHandler($handler);
//
// View column for Entrega field
//
$column = new TextViewColumn('Entrega', 'Entrega', $this->dataset);
$column->SetOrderable(true);
$handler = new ShowTextBlobHandler($this->dataset, $this, 'Entrega_handler', $column);
GetApplication()->RegisterHTTPHandler($handler);
//
// View column for Recibe field
//
$column = new TextViewColumn('Recibe', 'Recibe', $this->dataset);
$column->SetOrderable(true);
$handler = new ShowTextBlobHandler($this->dataset, $this, 'Recibe_handler', $column);
GetApplication()->RegisterHTTPHandler($handler);
//
// View column for MotivoMovimiento field
//
$column = new TextViewColumn('MotivoMovimiento', 'MotivoMovimiento', $this->dataset);
$column->SetOrderable(true);
$handler = new ShowTextBlobHandler($this->dataset, $this, 'MotivoMovimiento_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);
return $result;
}
protected function AddInsertColumns(Grid $grid)
{
//
// Edit column for num_req_padre field
//
$editor = new TextEdit('num_req_padre_edit');
$editor->SetMaxLength(64);
$editColumn = new CustomEditColumn('MrCoo', 'num_req_padre', $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_req_hijo field
//
$editor = new TextEdit('num_req_hijo_edit');
$editor->SetMaxLength(64);
$editColumn = new CustomEditColumn('Caso de Uso', 'num_req_hijo', $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 etapa field
//
$editor = new ComboBox('etapa_edit', $this->GetLocalizerCaptions()->GetMessageString('PleaseSelect'));
$editor->AddValue('ANALISIS', $this->RenderText('ANÁLISIS'));
$editor->AddValue('DESARROLLO', $this->RenderText('DESARROLLO'));
$editor->AddValue('PRUEBAS', $this->RenderText('PRUEBAS'));
$editor->AddValue('INTEGRACION', $this->RenderText('INTEGRACIÓN'));
$editColumn = new CustomEditColumn('Etapa de Planificación', 'etapa', $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 TextEdit('descripcion_edit');
$editColumn = new CustomEditColumn('Descripción', '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 criterios_aceptacion field
//
$editor = new TextAreaEdit('criterios_aceptacion_edit', 50, 8);
$editColumn = new CustomEditColumn('Criterios Aceptación', 'criterios_aceptacion', $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 esfuerzo field
//
$editor = new TextEdit('esfuerzo_edit');
$editColumn = new CustomEditColumn('Esfuerzo', 'esfuerzo', $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 observaciones field
//
$editor = new TextAreaEdit('observaciones_edit', 50, 8);
$editColumn = new CustomEditColumn('Observaciones', 'observaciones', $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 report_style_id field
//
$editor = new TextEdit('report_style_id_edit');
$editColumn = new CustomEditColumn('Report Style Id', 'report_style_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 type field
//
$editor = new TextEdit('type_edit');
$editor->SetSize(6);
$editor->SetMaxLength(6);
$editColumn = new CustomEditColumn('Type', 'type', $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 field field
//
$editor = new TextEdit('field_edit');
$editColumn = new CustomEditColumn('Field', 'field', $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 group field
//
$editor = new TextEdit('group_edit');
$editColumn = new CustomEditColumn('Group', 'group', $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 style_str field
//
$editor = new ImageUploader('style_str_edit');
$editor->SetShowImage(false);
$editColumn = new FileUploadingColumn('Style Str', 'style_str', $editor, $this->dataset, false, false, 'GE_webreport_styleGrid_style_str_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 uniq field
//
$editor = new TextEdit('uniq_edit');
$editColumn = new CustomEditColumn('Uniq', 'uniq', $editor, $this->dataset);
$editColumn->SetAllowSetToNull(true);
$this->ApplyCommonColumnEditProperties($editColumn);
$grid->AddInsertColumn($editColumn);
//
// Edit column for repname field
//
$editor = new TextAreaEdit('repname_edit', 50, 8);
$editColumn = new CustomEditColumn('Repname', 'repname', $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 styletype field
//
$editor = new TextEdit('styletype_edit');
$editor->SetSize(40);
$editor->SetMaxLength(40);
$editColumn = new CustomEditColumn('Styletype', 'styletype', $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 CreateGrid()
{
$result = new Grid($this, $this->dataset, 'imvGrid');
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
//
$pageView = new kardexmercanciasDetailView0imvPage($this, 'Kardexmercancias', 'Kardexmercancias', array('ProductosVenta_idProductosVenta'), GetCurrentUserGrantForDataSource('imv.'), 'UTF-8', 20, 'kardexmercanciasDetailEdit0imv_handler');
$pageView->SetRecordPermission(GetCurrentUserRecordPermissionsForDataSource('imv.'));
$handler = new PageHTTPHandler('kardexmercanciasDetailView0imv_handler', $pageView);
GetApplication()->RegisterHTTPHandler($handler);
$pageEdit = new kardexmercanciasDetailEdit0imvPage($this, array('ProductosVenta_idProductosVenta'), array('id'), $this->GetForeingKeyFields(), $this->CreateMasterDetailRecordGridForkardexmercanciasDetailEdit0imvGrid(), $this->dataset, GetCurrentUserGrantForDataSource('imv.'), 'UTF-8');
$pageEdit->SetRecordPermission(GetCurrentUserRecordPermissionsForDataSource('imv.'));
$pageEdit->SetShortCaption('Kardexmercancias');
$pageEdit->SetHeader(GetPagesHeader());
$pageEdit->SetFooter(GetPagesFooter());
$pageEdit->SetCaption('Kardexmercancias');
$pageEdit->SetHttpHandlerName('kardexmercanciasDetailEdit0imv_handler');
$handler = new PageHTTPHandler('kardexmercanciasDetailEdit0imv_handler', $pageEdit);
GetApplication()->RegisterHTTPHandler($handler);
//
// View column for cod_cups field
//
$column = new TextViewColumn('cod_cups', 'Cod Cups', $this->dataset);
$column->SetOrderable(true);
/* <inline edit column> */
//
// Edit column for cod_cups field
//
$editor = new TextEdit('cod_cups_edit');
$editor->SetSize(100);
$editor->SetMaxLength(100);
$editColumn = new CustomEditColumn('Cod Cups', 'cod_cups', $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 cod_cups field
//
$editor = new TextEdit('cod_cups_edit');
$editor->SetSize(100);
$editor->SetMaxLength(100);
$editColumn = new CustomEditColumn('Cod Cups', 'cod_cups', $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, 'cod_cups_handler', $column);
GetApplication()->RegisterHTTPHandler($handler);
//
// View column for cod_admin field
//
$column = new TextViewColumn('cod_admin', 'Cod Admin', $this->dataset);
$column->SetOrderable(true);
/* <inline edit column> */
//
// Edit column for cod_admin field
//
$editor = new TextEdit('cod_admin_edit');
$editor->SetSize(100);
$editor->SetMaxLength(100);
$editColumn = new CustomEditColumn('Cod Admin', 'cod_admin', $editor, $this->dataset);
$editColumn->SetAllowSetToNull(true);
$this->ApplyCommonColumnEditProperties($editColumn);
$column->SetEditOperationColumn($editColumn);
/* </inline edit column> */
/* <inline insert column> */
//
// Edit column for cod_admin field
//
$editor = new TextEdit('cod_admin_edit');
$editor->SetSize(100);
$editor->SetMaxLength(100);
$editColumn = new CustomEditColumn('Cod Admin', 'cod_admin', $editor, $this->dataset);
$editColumn->SetAllowSetToNull(true);
$this->ApplyCommonColumnEditProperties($editColumn);
$column->SetInsertOperationColumn($editColumn);
/* </inline insert column> */
$handler = new ShowTextBlobHandler($this->dataset, $this, 'cod_admin_handler', $column);
GetApplication()->RegisterHTTPHandler($handler);
//
// View column for cums field
//
$column = new TextViewColumn('cums', 'Cums', $this->dataset);
$column->SetOrderable(true);
/* <inline edit column> */
//
// Edit column for cums field
//
$editor = new TextEdit('cums_edit');
$editor->SetSize(100);
$editor->SetMaxLength(100);
$editColumn = new CustomEditColumn('Cums', 'cums', $editor, $this->dataset);
$editColumn->SetAllowSetToNull(true);
$this->ApplyCommonColumnEditProperties($editColumn);
$column->SetEditOperationColumn($editColumn);
/* </inline edit column> */
/* <inline insert column> */
//
// Edit column for cums field
//
$editor = new TextEdit('cums_edit');
$editor->SetSize(100);
$editor->SetMaxLength(100);
$editColumn = new CustomEditColumn('Cums', 'cums', $editor, $this->dataset);
$editColumn->SetAllowSetToNull(true);
$this->ApplyCommonColumnEditProperties($editColumn);
$column->SetInsertOperationColumn($editColumn);
/* </inline insert column> */
$handler = new ShowTextBlobHandler($this->dataset, $this, 'cums_handler', $column);
GetApplication()->RegisterHTTPHandler($handler);
//
// View column for nombre field
//
$column = new TextViewColumn('nombre', 'Nombre', $this->dataset);
$column->SetOrderable(true);
/* <inline edit column> */
//
// Edit column for nombre field
//
$editor = new TextAreaEdit('nombre_edit', 50, 8);
$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);
$column->SetEditOperationColumn($editColumn);
/* </inline edit column> */
/* <inline insert column> */
//
// Edit column for nombre field
//
$editor = new TextAreaEdit('nombre_edit', 50, 8);
$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);
$column->SetInsertOperationColumn($editColumn);
/* </inline insert column> */
$handler = new ShowTextBlobHandler($this->dataset, $this, 'nombre_handler', $column);
GetApplication()->RegisterHTTPHandler($handler);
//
// View column for tipo_imv field
//
$column = new TextViewColumn('tipo_imv', 'Tipo Imv', $this->dataset);
$column->SetOrderable(true);
/* <inline edit column> */
//
// Edit column for tipo_imv field
//
$editor = new TextEdit('tipo_imv_edit');
$editor->SetSize(100);
$editor->SetMaxLength(100);
$editColumn = new CustomEditColumn('Tipo Imv', 'tipo_imv', $editor, $this->dataset);
$editColumn->SetAllowSetToNull(true);
$this->ApplyCommonColumnEditProperties($editColumn);
$column->SetEditOperationColumn($editColumn);
/* </inline edit column> */
/* <inline insert column> */
//
// Edit column for tipo_imv field
//
$editor = new TextEdit('tipo_imv_edit');
$editor->SetSize(100);
$editor->SetMaxLength(100);
$editColumn = new CustomEditColumn('Tipo Imv', 'tipo_imv', $editor, $this->dataset);
$editColumn->SetAllowSetToNull(true);
$this->ApplyCommonColumnEditProperties($editColumn);
$column->SetInsertOperationColumn($editColumn);
/* </inline insert column> */
$handler = new ShowTextBlobHandler($this->dataset, $this, 'tipo_imv_handler', $column);
GetApplication()->RegisterHTTPHandler($handler);
//
// View column for uni_medida field
//
$column = new TextViewColumn('uni_medida', 'Uni Medida', $this->dataset);
$column->SetOrderable(true);
/* <inline edit column> */
//
// Edit column for uni_medida field
//
$editor = new TextEdit('uni_medida_edit');
$editor->SetSize(100);
$editor->SetMaxLength(100);
$editColumn = new CustomEditColumn('Uni Medida', 'uni_medida', $editor, $this->dataset);
$editColumn->SetAllowSetToNull(true);
$this->ApplyCommonColumnEditProperties($editColumn);
$column->SetEditOperationColumn($editColumn);
/* </inline edit column> */
/* <inline insert column> */
//
// Edit column for uni_medida field
//
$editor = new TextEdit('uni_medida_edit');
$editor->SetSize(100);
$editor->SetMaxLength(100);
$editColumn = new CustomEditColumn('Uni Medida', 'uni_medida', $editor, $this->dataset);
$editColumn->SetAllowSetToNull(true);
$this->ApplyCommonColumnEditProperties($editColumn);
$column->SetInsertOperationColumn($editColumn);
/* </inline insert column> */
$handler = new ShowTextBlobHandler($this->dataset, $this, 'uni_medida_handler', $column);
GetApplication()->RegisterHTTPHandler($handler);
//
// View column for tipo_med field
//
$column = new TextViewColumn('tipo_med', 'Tipo Med', $this->dataset);
$column->SetOrderable(true);
/* <inline edit column> */
//
// Edit column for tipo_med field
//
$editor = new TextEdit('tipo_med_edit');
$editor->SetSize(100);
$editor->SetMaxLength(100);
$editColumn = new CustomEditColumn('Tipo Med', 'tipo_med', $editor, $this->dataset);
$editColumn->SetAllowSetToNull(true);
$this->ApplyCommonColumnEditProperties($editColumn);
$column->SetEditOperationColumn($editColumn);
/* </inline edit column> */
/* <inline insert column> */
//
// Edit column for tipo_med field
//
$editor = new TextEdit('tipo_med_edit');
$editor->SetSize(100);
$editor->SetMaxLength(100);
$editColumn = new CustomEditColumn('Tipo Med', 'tipo_med', $editor, $this->dataset);
$editColumn->SetAllowSetToNull(true);
$this->ApplyCommonColumnEditProperties($editColumn);
$column->SetInsertOperationColumn($editColumn);
/* </inline insert column> */
$handler = new ShowTextBlobHandler($this->dataset, $this, 'tipo_med_handler', $column);
GetApplication()->RegisterHTTPHandler($handler);
//
// View column for cod_cups field
//
$column = new TextViewColumn('cod_cups', 'Cod Cups', $this->dataset);
$column->SetOrderable(true);
$handler = new ShowTextBlobHandler($this->dataset, $this, 'cod_cups_handler', $column);
GetApplication()->RegisterHTTPHandler($handler);
//
// View column for cod_admin field
//
$column = new TextViewColumn('cod_admin', 'Cod Admin', $this->dataset);
$column->SetOrderable(true);
$handler = new ShowTextBlobHandler($this->dataset, $this, 'cod_admin_handler', $column);
GetApplication()->RegisterHTTPHandler($handler);
//
// View column for cums field
//
$column = new TextViewColumn('cums', 'Cums', $this->dataset);
$column->SetOrderable(true);
$handler = new ShowTextBlobHandler($this->dataset, $this, 'cums_handler', $column);
GetApplication()->RegisterHTTPHandler($handler);
//
// View column for nombre field
//
$column = new TextViewColumn('nombre', 'Nombre', $this->dataset);
$column->SetOrderable(true);
$handler = new ShowTextBlobHandler($this->dataset, $this, 'nombre_handler', $column);
GetApplication()->RegisterHTTPHandler($handler);
//
// View column for tipo_imv field
//
$column = new TextViewColumn('tipo_imv', 'Tipo Imv', $this->dataset);
$column->SetOrderable(true);
$handler = new ShowTextBlobHandler($this->dataset, $this, 'tipo_imv_handler', $column);
GetApplication()->RegisterHTTPHandler($handler);
//
// View column for uni_medida field
//
$column = new TextViewColumn('uni_medida', 'Uni Medida', $this->dataset);
$column->SetOrderable(true);
$handler = new ShowTextBlobHandler($this->dataset, $this, 'uni_medida_handler', $column);
GetApplication()->RegisterHTTPHandler($handler);
//
// View column for tipo_med field
//
$column = new TextViewColumn('tipo_med', 'Tipo Med', $this->dataset);
$column->SetOrderable(true);
$handler = new ShowTextBlobHandler($this->dataset, $this, 'tipo_med_handler', $column);
GetApplication()->RegisterHTTPHandler($handler);
return $result;
}
protected function CreateGrid()
{
$result = new Grid($this, $this->dataset, 'activosGrid');
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
//
$pageView = new act_movimientosDetailView0activosPage($this, 'Act Movimientos', 'Act Movimientos', array('idActivo'), GetCurrentUserGrantForDataSource('activos.act_movimientos'), 'UTF-8', 20, 'act_movimientosDetailEdit0activos_handler');
$pageView->SetRecordPermission(GetCurrentUserRecordPermissionsForDataSource('activos.act_movimientos'));
$handler = new PageHTTPHandler('act_movimientosDetailView0activos_handler', $pageView);
GetApplication()->RegisterHTTPHandler($handler);
$pageEdit = new act_movimientosDetailEdit0activosPage($this, array('idActivo'), array('idActivos'), $this->GetForeingKeyFields(), $this->CreateMasterDetailRecordGridForact_movimientosDetailEdit0activosGrid(), $this->dataset, GetCurrentUserGrantForDataSource('activos.act_movimientos'), 'UTF-8');
$pageEdit->SetRecordPermission(GetCurrentUserRecordPermissionsForDataSource('activos.act_movimientos'));
$pageEdit->SetShortCaption('Act Movimientos');
$pageEdit->SetHeader(GetPagesHeader());
$pageEdit->SetFooter(GetPagesFooter());
$pageEdit->SetCaption('Act Movimientos');
$pageEdit->SetHttpHandlerName('act_movimientosDetailEdit0activos_handler');
$handler = new PageHTTPHandler('act_movimientosDetailEdit0activos_handler', $pageEdit);
GetApplication()->RegisterHTTPHandler($handler);
//
// View column for NombreAct field
//
$column = new TextViewColumn('NombreAct', 'NombreAct', $this->dataset);
$column->SetOrderable(true);
/* <inline edit column> */
//
// 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);
$column->SetEditOperationColumn($editColumn);
/* </inline edit column> */
/* <inline insert column> */
//
// 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);
$column->SetInsertOperationColumn($editColumn);
/* </inline insert column> */
$handler = new ShowTextBlobHandler($this->dataset, $this, 'NombreAct_handler', $column);
GetApplication()->RegisterHTTPHandler($handler);
//
// View column for Marca field
//
$column = new TextViewColumn('Marca', 'Marca', $this->dataset);
$column->SetOrderable(true);
/* <inline edit column> */
//
// 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);
$column->SetEditOperationColumn($editColumn);
/* </inline edit column> */
/* <inline insert column> */
//
// 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);
$column->SetInsertOperationColumn($editColumn);
/* </inline insert column> */
$handler = new ShowTextBlobHandler($this->dataset, $this, 'Marca_handler', $column);
GetApplication()->RegisterHTTPHandler($handler);
//
// View column for NombreAct field
//
$column = new TextViewColumn('NombreAct', 'NombreAct', $this->dataset);
$column->SetOrderable(true);
$handler = new ShowTextBlobHandler($this->dataset, $this, 'NombreAct_handler', $column);
GetApplication()->RegisterHTTPHandler($handler);
//
// View column for Marca field
//
$column = new TextViewColumn('Marca', 'Marca', $this->dataset);
$column->SetOrderable(true);
$handler = new ShowTextBlobHandler($this->dataset, $this, 'Marca_handler', $column);
GetApplication()->RegisterHTTPHandler($handler);
return $result;
}
protected function AddInsertColumns(Grid $grid)
{
//
// Edit column for base_datos field
//
$editor = new TextAreaEdit('base_datos_edit', 50, 8);
$editColumn = new CustomEditColumn('Base Datos', 'base_datos', $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_creacion field
//
$editor = new DateTimeEdit('fecha_creacion_edit', false, 'Y-m-d H:i:s', GetFirstDayOfWeek());
$editColumn = new CustomEditColumn('Fecha Creacion', 'fecha_creacion', $editor, $this->dataset);
$editColumn->SetAllowSetToNull(true);
$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 project_id field
//
$editor = new ComboBox('project_id_edit', $this->GetLocalizerCaptions()->GetMessageString('PleaseSelect'));
$lookupDataset = new TableDataset(new MyConnectionFactory(), GetConnectionOptions(), '`project`');
$field = new IntegerField('project_id', null, null, true);
$field->SetIsNotNull(true);
$lookupDataset->AddField($field, true);
$field = new IntegerField('programm_id');
$lookupDataset->AddField($field, false);
$field = new StringField('project_name');
$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('approved_budget');
$lookupDataset->AddField($field, false);
$field = new StringField('notes');
$field->SetIsNotNull(true);
$lookupDataset->AddField($field, false);
$field = new StringField('priority');
$lookupDataset->AddField($field, false);
$field = new StringField('lead');
$lookupDataset->AddField($field, false);
$field = new StringField('level_of_service');
$field->SetIsNotNull(true);
$lookupDataset->AddField($field, false);
$field = new StringField('multi_year');
$field->SetIsNotNull(true);
$lookupDataset->AddField($field, false);
$field = new StringField('public_engagement');
$field->SetIsNotNull(true);
$lookupDataset->AddField($field, false);
$field = new StringField('year');
$field->SetIsNotNull(true);
$lookupDataset->AddField($field, false);
$field = new StringField('approved');
$field->SetIsNotNull(true);
$lookupDataset->AddField($field, false);
$field = new StringField('progress');
$field->SetIsNotNull(true);
$lookupDataset->AddField($field, false);
$field = new IntegerField('staff_id');
$field->SetIsNotNull(true);
$lookupDataset->AddField($field, false);
$field = new IntegerField('dept_id');
$field->SetIsNotNull(true);
$lookupDataset->AddField($field, false);
$field = new IntegerField('budget_spent');
$field->SetIsNotNull(true);
$lookupDataset->AddField($field, false);
$field = new IntegerField('admin_flag');
$field->SetIsNotNull(true);
$lookupDataset->AddField($field, false);
$lookupDataset->SetOrderBy('project_name', GetOrderTypeAsSQL(otAscending));
$editColumn = new LookUpEditColumn('Parent Project', 'project_id', $editor, $this->dataset, 'project_id', 'project_name', $lookupDataset);
$editColumn->SetReadOnly(true);
$editColumn->setEnabled(false);
$editColumn->SetAllowSetToNull(true);
$this->ApplyCommonColumnEditProperties($editColumn);
$grid->AddInsertColumn($editColumn);
//
// Edit column for assigned_to field
//
$editor = new TextEdit('assigned_to_edit');
$editor->SetSize(50);
$editor->SetMaxLength(50);
$editColumn = new CustomEditColumn('Assigned To', 'assigned_to', $editor, $this->dataset);
$editColumn->SetAllowSetToNull(true);
$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->SetAllowSetToNull(true);
$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->SetAllowSetToNull(true);
$this->ApplyCommonColumnEditProperties($editColumn);
$grid->AddInsertColumn($editColumn);
//
// Edit column for task_name field
//
$editor = new TextAreaEdit('task_name_edit', 50, 8);
$editColumn = new CustomEditColumn('Task Name', 'task_name', $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);
$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 hrs field
//
$editor = new TextEdit('hrs_edit');
$editColumn = new CustomEditColumn('Hrs', 'hrs', $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 id_paquete field
//
$editor = new TextEdit('id_paquete_edit');
$editor->SetMaxLength(64);
$editColumn = new CustomEditColumn('CMO', 'id_paquete', $editor, $this->dataset);
$editColumn->SetAllowSetToNull(true);
$this->ApplyCommonColumnEditProperties($editColumn);
$grid->AddInsertColumn($editColumn);
//
// Edit column for ruta field
//
$editor = new TextAreaEdit('ruta_edit', 50, 8);
$editColumn = new CustomEditColumn('Ruta', 'ruta', $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->SetMaxLength(64);
$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 tipo field
//
$editor = new ComboBox('tipo_edit', $this->GetLocalizerCaptions()->GetMessageString('PleaseSelect'));
$editor->AddValue('HTML', $this->RenderText('HTML'));
$editor->AddValue('JS', $this->RenderText('JS'));
$editor->AddValue('PHP', $this->RenderText('PHP'));
$editor->AddValue('PL/SQL', $this->RenderText('PL/SQL'));
$editor->AddValue('SCRIPT', $this->RenderText('SCRIPT ADJUNTO'));
$editColumn = new CustomEditColumn('Tipo', 'tipo', $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 aplicacion field
//
$editor = new ComboBox('aplicacion_edit', $this->GetLocalizerCaptions()->GetMessageString('PleaseSelect'));
$editor->AddValue('COOEPS', $this->RenderText('COOEPS'));
$editor->AddValue('CIKLOS', $this->RenderText('CIKLOS'));
$editColumn = new CustomEditColumn('Aplicacion', 'aplicacion', $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 nuevo field
//
$editor = new RadioEdit('nuevo_edit');
$editor->SetDisplayMode(RadioEdit::StackedMode);
$editor->AddValue('S', $this->RenderText('SI'));
$editor->AddValue('N', $this->RenderText('NO'));
$editColumn = new CustomEditColumn('Nuevo', 'nuevo', $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);
}
}
