{

$result = GetGlobalConnectionOptions();

$result['client_encoding'] = 'utf8';

GetApplication()->GetUserAuthorizationStrategy()->ApplyIdentityToConnectionOptions($result);

return $result;

{

protected function DoBeforeCreate()

{

$this->dataset = new TableDataset(

new MySqlIConnectionFactory(),

GetConnectionOptions(),

'`objeto`');

$field = new IntegerField('id', null, null, true);

$field->SetIsNotNull(true);

$this->dataset->AddField($field, true);

$field = new IntegerField('id_planificacion');

$this->dataset->AddField($field, false);

$field = new StringField('id_paquete');

$this->dataset->AddField($field, false);

$field = new StringField('ruta');

$field->SetIsNotNull(true);

$this->dataset->AddField($field, false);

$field = new StringField('nombre');

$field->SetIsNotNull(true);

$this->dataset->AddField($field, false);

$field = new StringField('tipo');

$field->SetIsNotNull(true);

$this->dataset->AddField($field, false);

$field = new StringField('aplicacion');

$field->SetIsNotNull(true);

$this->dataset->AddField($field, false);

$field = new StringField('nuevo');

$field->SetIsNotNull(true);

$this->dataset->AddField($field, false);

}

protected function DoPrepare() {

}

protected function CreatePageNavigator()

{

$result = new CompositePageNavigator($this);

$partitionNavigator = new PageNavigator('pnav', $this, $this->dataset);

$partitionNavigator->SetRowsPerPage(20);

$result->AddPageNavigator($partitionNavigator);

return $result;

}

protected function CreateRssGenerator()

{

return null;

}

protected function CreateGridSearchControl(Grid $grid)

{

$grid->UseFilter = true;

$grid->SearchControl = new SimpleSearch('objetossearch', $this->dataset,

array('id', 'id_planificacion', 'tipo', 'id_paquete', 'ruta', 'nombre', 'aplicacion', 'nuevo'),

array($this->RenderText('Id'), $this->RenderText('Id Planificación'), $this->RenderText('Tipo'), $this->RenderText('CMO'), $this->RenderText('Ruta'), $this->RenderText('Nombre'), $this->RenderText('Aplicacion'), $this->RenderText('Nuevo')),

array(

'=' => $this->GetLocalizerCaptions()->GetMessageString('equals'),

'<>' => $this->GetLocalizerCaptions()->GetMessageString('doesNotEquals'),

'<' => $this->GetLocalizerCaptions()->GetMessageString('isLessThan'),

'<=' => $this->GetLocalizerCaptions()->GetMessageString('isLessThanOrEqualsTo'),

'>' => $this->GetLocalizerCaptions()->GetMessageString('isGreaterThan'),

'>=' => $this->GetLocalizerCaptions()->GetMessageString('isGreaterThanOrEqualsTo'),

'ILIKE' => $this->GetLocalizerCaptions()->GetMessageString('Like'),

'STARTS' => $this->GetLocalizerCaptions()->GetMessageString('StartsWith'),

'ENDS' => $this->GetLocalizerCaptions()->GetMessageString('EndsWith'),

'CONTAINS' => $this->GetLocalizerCaptions()->GetMessageString('Contains')

), $this->GetLocalizerCaptions(), $this, 'CONTAINS'

);

}

protected function CreateGridAdvancedSearchControl(Grid $grid)

{

$this->AdvancedSearchControl = new AdvancedSearchControl('objetoasearch', $this->dataset, $this->GetLocalizerCaptions(), $this->GetColumnVariableContainer(), $this->CreateLinkBuilder());

$this->AdvancedSearchControl->AddSearchColumn($this->AdvancedSearchControl->CreateStringSearchInput('id', $this->RenderText('Id')));

$this->AdvancedSearchControl->AddSearchColumn($this->AdvancedSearchControl->CreateStringSearchInput('id_planificacion', $this->RenderText('Id Planificación')));

$this->AdvancedSearchControl->AddSearchColumn($this->AdvancedSearchControl->CreateStringSearchInput('tipo', $this->RenderText('Tipo')));

$this->AdvancedSearchControl->AddSearchColumn($this->AdvancedSearchControl->CreateStringSearchInput('id_paquete', $this->RenderText('CMO')));

$this->AdvancedSearchControl->AddSearchColumn($this->AdvancedSearchControl->CreateStringSearchInput('ruta', $this->RenderText('Ruta')));

$this->AdvancedSearchControl->AddSearchColumn($this->AdvancedSearchControl->CreateStringSearchInput('nombre', $this->RenderText('Nombre')));

$this->AdvancedSearchControl->AddSearchColumn($this->AdvancedSearchControl->CreateStringSearchInput('aplicacion', $this->RenderText('Aplicacion')));

$this->AdvancedSearchControl->AddSearchColumn($this->AdvancedSearchControl->CreateStringSearchInput('nuevo', $this->RenderText('Nuevo')));

}

protected function AddOperationsColumns(Grid $grid)

{

$actions = $grid->getActions();

$actions->setCaption($this->GetLocalizerCaptions()->GetMessageString('Actions'));

$actions->setPosition(ActionList::POSITION_LEFT);

if ($this->GetSecurityInfo()->HasViewGrant())

{

$operation = new LinkOperation($this->GetLocalizerCaptions()->GetMessageString('View'), OPERATION_VIEW, $this->dataset, $grid);

$operation->setUseImage(true);

$actions->addOperation($operation);

}

if ($this->GetSecurityInfo()->HasEditGrant())

{

$operation = new LinkOperation($this->GetLocalizerCaptions()->GetMessageString('Edit'), OPERATION_EDIT, $this->dataset, $grid);

$operation->setUseImage(true);

$actions->addOperation($operation);

$operation->OnShow->AddListener('ShowEditButtonHandler', $this);

}

if ($this->GetSecurityInfo()->HasDeleteGrant())

{

$operation = new LinkOperation($this->GetLocalizerCaptions()->GetMessageString('Delete'), OPERATION_DELETE, $this->dataset, $grid);

$operation->setUseImage(true);

$actions->addOperation($operation);

$operation->OnShow->AddListener('ShowDeleteButtonHandler', $this);

$operation->SetAdditionalAttribute('data-modal-operation', 'delete');

$operation->SetAdditionalAttribute('data-delete-handler-name', $this->GetModalGridDeleteHandler());

}

if ($this->GetSecurityInfo()->HasAddGrant())

{

$operation = new LinkOperation($this->GetLocalizerCaptions()->GetMessageString('Copy'), OPERATION_COPY, $this->dataset, $grid);

$operation->setUseImage(true);

$actions->addOperation($operation);

}

}

protected function AddFieldColumns(Grid $grid)

{

//

// View column for id field

//

$column = new TextViewColumn('id', 'Id', $this->dataset);

$column->SetOrderable(true);

$column->setMinimalVisibility(ColumnVisibility::PHONE);

$column->SetDescription($this->RenderText(''));

$column->SetFixedWidth(null);

$grid->AddViewColumn($column);

//

// View column for id_planificacion field

//

$column = new TextViewColumn('id_planificacion', 'Id Planificación', $this->dataset);

$column->SetOrderable(true);

$column->setMinimalVisibility(ColumnVisibility::PHONE);

$column->SetDescription($this->RenderText(''));

$column->SetFixedWidth(null);

$grid->AddViewColumn($column);

//

// View column for tipo field

//

$column = new TextViewColumn('tipo', 'Tipo', $this->dataset);

$column->SetOrderable(true);

$column->setMinimalVisibility(ColumnVisibility::PHONE);

$column->SetDescription($this->RenderText(''));

$column->SetFixedWidth(null);

$grid->AddViewColumn($column);

//

// View column for id_paquete field

//

$column = new TextViewColumn('id_paquete', 'CMO', $this->dataset);

$column->SetOrderable(true);

$column->setMinimalVisibility(ColumnVisibility::PHONE);

$column->SetDescription($this->RenderText(''));

$column->SetFixedWidth(null);

$grid->AddViewColumn($column);

//

// View column for ruta field

//

$column = new TextViewColumn('ruta', 'Ruta', $this->dataset);

$column->SetOrderable(true);

$column->SetMaxLength(75);

$column->SetFullTextWindowHandlerName('objetoGrid_ruta_handler_list');

$column->setMinimalVisibility(ColumnVisibility::PHONE);

$column->SetDescription($this->RenderText(''));

$column->SetFixedWidth(null);

$grid->AddViewColumn($column);

//

// View column for nombre field

//

$column = new TextViewColumn('nombre', 'Nombre', $this->dataset);

$column->SetOrderable(true);

$column->setMinimalVisibility(ColumnVisibility::PHONE);

$column->SetDescription($this->RenderText(''));

$column->SetFixedWidth(null);

$grid->AddViewColumn($column);

//

// View column for aplicacion field

//

$column = new TextViewColumn('aplicacion', 'Aplicacion', $this->dataset);

$column->SetOrderable(true);

$column->setMinimalVisibility(ColumnVisibility::PHONE);

$column->SetDescription($this->RenderText(''));

$column->SetFixedWidth(null);

$grid->AddViewColumn($column);

//

// View column for nuevo field

//

$column = new TextViewColumn('nuevo', 'Nuevo', $this->dataset);

$column->SetOrderable(true);

$column->setMinimalVisibility(ColumnVisibility::PHONE);

$column->SetDescription($this->RenderText(''));

$column->SetFixedWidth(null);

$grid->AddViewColumn($column);

}

protected function AddSingleRecordViewColumns(Grid $grid)

{

//

// View column for id field

//

$column = new TextViewColumn('id', 'Id', $this->dataset);

$column->SetOrderable(true);

$grid->AddSingleRecordViewColumn($column);

//

// View column for id_planificacion field

//

$column = new TextViewColumn('id_planificacion', 'Id Planificación', $this->dataset);

$column->SetOrderable(true);

$grid->AddSingleRecordViewColumn($column);

//

// View column for tipo field

//

$column = new TextViewColumn('tipo', 'Tipo', $this->dataset);

$column->SetOrderable(true);

$grid->AddSingleRecordViewColumn($column);

//

// View column for id_paquete field

//

$column = new TextViewColumn('id_paquete', 'CMO', $this->dataset);

$column->SetOrderable(true);

$grid->AddSingleRecordViewColumn($column);

//

// View column for ruta field

//

$column = new TextViewColumn('ruta', 'Ruta', $this->dataset);

$column->SetOrderable(true);

$column->SetMaxLength(75);

$column->SetFullTextWindowHandlerName('objetoGrid_ruta_handler_view');

$grid->AddSingleRecordViewColumn($column);

//

// View column for nombre field

//

$column = new TextViewColumn('nombre', 'Nombre', $this->dataset);

$column->SetOrderable(true);

$grid->AddSingleRecordViewColumn($column);

//

// View column for aplicacion field

//

$column = new TextViewColumn('aplicacion', 'Aplicacion', $this->dataset);

$column->SetOrderable(true);

$grid->AddSingleRecordViewColumn($column);

//

// View column for nuevo field

//

$column = new TextViewColumn('nuevo', 'Nuevo', $this->dataset);

$column->SetOrderable(true);

$grid->AddSingleRecordViewColumn($column);

}

protected function AddEditColumns(Grid $grid)

{

//

// Edit column for id_planificacion field

//

$editor = new TextEdit('id_planificacion_edit');

$editColumn = new CustomEditColumn('Id Planificación', 'id_planificacion', $editor, $this->dataset);

$editColumn->SetAllowSetToNull(true);

$this->ApplyCommonColumnEditProperties($editColumn);

$grid->AddEditColumn($editColumn);

//

// Edit column for tipo field

//

$editor = new TextEdit('tipo_edit');

$editor->SetMaxLength(20);

$editColumn = new CustomEditColumn('Tipo', 'tipo', $editor, $this->dataset);

$editColumn->SetAllowSetToNull(true);

$this->ApplyCommonColumnEditProperties($editColumn);

$grid->AddEditColumn($editColumn);

//

// 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->AddEditColumn($editColumn);

//

// Edit column for ruta field

//

$editor = new TextEdit('ruta_edit');

$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->AddEditColumn($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->AddEditColumn($editColumn);

//

// Edit column for aplicacion field

//

$editor = new TextEdit('aplicacion_edit');

$editor->SetMaxLength(64);

$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->AddEditColumn($editColumn);

//

// Edit column for nuevo field

//

$editor = new TextEdit('nuevo_edit');

$editor->SetMaxLength(1);

$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->AddEditColumn($editColumn);

}

protected function AddInsertColumns(Grid $grid)

{

//

// Edit column for id_planificacion field

//

$editor = new TextEdit('id_planificacion_edit');

$editColumn = new CustomEditColumn('Id Planificación', 'id_planificacion', $editor, $this->dataset);

$editColumn->SetAllowSetToNull(true);

$this->ApplyCommonColumnEditProperties($editColumn);

$grid->AddInsertColumn($editColumn);

//

// Edit column for tipo field

//

$editor = new TextEdit('tipo_edit');

$editor->SetMaxLength(20);

$editColumn = new CustomEditColumn('Tipo', 'tipo', $editor, $this->dataset);

$editColumn->SetAllowSetToNull(true);

$this->ApplyCommonColumnEditProperties($editColumn);

$grid->AddInsertColumn($editColumn);

//

// 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 TextEdit('ruta_edit');

$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 aplicacion field

//

$editor = new TextEdit('aplicacion_edit');

$editor->SetMaxLength(64);

$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 TextEdit('nuevo_edit');

$editor->SetMaxLength(1);

$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);

}

}

protected function AddPrintColumns(Grid $grid)

{

//

// View column for id field

//

$column = new TextViewColumn('id', 'Id', $this->dataset);

$column->SetOrderable(true);

$grid->AddPrintColumn($column);

//

// View column for id_planificacion field

//

$column = new TextViewColumn('id_planificacion', 'Id Planificación', $this->dataset);

$column->SetOrderable(true);

$grid->AddPrintColumn($column);

//

// View column for tipo field

//

$column = new TextViewColumn('tipo', 'Tipo', $this->dataset);

$column->SetOrderable(true);

$grid->AddPrintColumn($column);

//

// View column for id_paquete field

//

$column = new TextViewColumn('id_paquete', 'CMO', $this->dataset);

$column->SetOrderable(true);

$grid->AddPrintColumn($column);

//

// View column for ruta field

//

$column = new TextViewColumn('ruta', 'Ruta', $this->dataset);

$column->SetOrderable(true);

$grid->AddPrintColumn($column);

//

// View column for nombre field

//

$column = new TextViewColumn('nombre', 'Nombre', $this->dataset);

$column->SetOrderable(true);

$grid->AddPrintColumn($column);

//

// View column for aplicacion field

//

$column = new TextViewColumn('aplicacion', 'Aplicacion', $this->dataset);

$column->SetOrderable(true);

$grid->AddPrintColumn($column);

//

// View column for nuevo field

//

$column = new TextViewColumn('nuevo', 'Nuevo', $this->dataset);

$column->SetOrderable(true);

$grid->AddPrintColumn($column);

}

protected function AddExportColumns(Grid $grid)

{

//

// View column for id field

//

$column = new TextViewColumn('id', 'Id', $this->dataset);

$column->SetOrderable(true);

$grid->AddExportColumn($column);

//

// View column for id_planificacion field

//

$column = new TextViewColumn('id_planificacion', 'Id Planificación', $this->dataset);

$column->SetOrderable(true);

$grid->AddExportColumn($column);

//

// View column for tipo field

//

$column = new TextViewColumn('tipo', 'Tipo', $this->dataset);

$column->SetOrderable(true);

$grid->AddExportColumn($column);

//

// View column for id_paquete field

//

$column = new TextViewColumn('id_paquete', 'CMO', $this->dataset);

$column->SetOrderable(true);

$grid->AddExportColumn($column);

//

// View column for ruta field

//

$column = new TextViewColumn('ruta', 'Ruta', $this->dataset);

$column->SetOrderable(true);

$grid->AddExportColumn($column);

//

// View column for aplicacion field

//

$column = new TextViewColumn('aplicacion', 'Aplicacion', $this->dataset);

$column->SetOrderable(true);

$grid->AddExportColumn($column);

//

// View column for nuevo field

//

$column = new TextViewColumn('nuevo', 'Nuevo', $this->dataset);

$column->SetOrderable(true);

$grid->AddExportColumn($column);

}

public function GetPageDirection()

{

return null;

}

protected function ApplyCommonColumnEditProperties(CustomEditColumn $column)

{

$column->SetDisplaySetToNullCheckBox(false);

$column->SetDisplaySetToDefaultCheckBox(false);

$column->SetVariableContainer($this->GetColumnVariableContainer());

}

function GetCustomClientScript()

{

return ;

}

function GetOnPageLoadedClientScript()

{

return ;

}

public function ShowEditButtonHandler(&$show)

{

if ($this->GetRecordPermission() != null)

$show = $this->GetRecordPermission()->HasEditGrant($this->GetDataset());

}

public function ShowDeleteButtonHandler(&$show)

{

if ($this->GetRecordPermission() != null)

$show = $this->GetRecordPermission()->HasDeleteGrant($this->GetDataset());

}

public function GetModalGridDeleteHandler() { return 'objeto_modal_delete'; }

protected function GetEnableModalGridDelete() { return true; }

protected function CreateGrid()

{

$result = new Grid($this, $this->dataset, 'objetoGrid');

if ($this->GetSecurityInfo()->HasDeleteGrant())

$result->SetAllowDeleteSelected(true);

else

$result->SetAllowDeleteSelected(false);

ApplyCommonPageSettings($this, $result);

$result->SetUseImagesForActions(true);

$result->SetUseFixedHeader(false);

$result->SetShowLineNumbers(false);

$result->SetShowKeyColumnsImagesInHeader(false);

$result->SetViewMode(ViewMode::TABLE);

$result->setEnableRuntimeCustomization(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->SetExportToExcelAvailable(true);

$this->SetExportToWordAvailable(true);

$this->SetExportToXmlAvailable(true);

$this->SetExportToCsvAvailable(true);

$this->SetExportToPdfAvailable(true);

$this->SetPrinterFriendlyAvailable(true);

$this->SetSimpleSearchAvailable(true);

$this->SetAdvancedSearchAvailable(true);

$this->SetVisualEffectsEnabled(true);

$this->SetShowTopPageNavigator(true);

$this->SetShowBottomPageNavigator(true);

//

// Http Handlers

//

//

// View column for ruta field

//

$column = new TextViewColumn('ruta', 'Ruta', $this->dataset);

$column->SetOrderable(true);

$handler = new ShowTextBlobHandler($this->dataset, $this, 'objetoGrid_ruta_handler_list', $column);

GetApplication()->RegisterHTTPHandler($handler);//

// View column for ruta field

//

$column = new TextViewColumn('ruta', 'Ruta', $this->dataset);

$column->SetOrderable(true);

$handler = new ShowTextBlobHandler($this->dataset, $this, 'objetoGrid_ruta_handler_view', $column);

GetApplication()->RegisterHTTPHandler($handler);

return $result;

}

public function OpenAdvancedSearchByDefault()

{

return false;

}

protected function DoGetGridHeader()

{

return '';

}