{

$result = GetGlobalConnectionOptions();

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

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

return $result;

{

protected function DoBeforeCreate()

{

$this->dataset = new TableDataset(

new MySqlIConnectionFactory(),

GetConnectionOptions(),

'`phpgen_user_perms`');

$field = new IntegerField('user_id');

$field->SetIsNotNull(true);

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

$field = new StringField('page_name');

$field->SetIsNotNull(true);

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

$field = new StringField('perm_name');

$field->SetIsNotNull(true);

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

}

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('phpgen_user_permsssearch', $this->dataset,

array('user_id', 'page_name', 'perm_name'),

array($this->RenderText('User Id'), $this->RenderText('Page Name'), $this->RenderText('Perm Name')),

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('phpgen_user_permsasearch', $this->dataset, $this->GetLocalizerCaptions(), $this->GetColumnVariableContainer(), $this->CreateLinkBuilder());

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

$this->AdvancedSearchControl->AddSearchColumn($this->AdvancedSearchControl->CreateStringSearchInput('page_name', $this->RenderText('Page Name')));

$this->AdvancedSearchControl->AddSearchColumn($this->AdvancedSearchControl->CreateStringSearchInput('perm_name', $this->RenderText('Perm Name')));

}

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 user_id field

//

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

$column->SetOrderable(true);

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

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

$column->SetFixedWidth(null);

$grid->AddViewColumn($column);

//

// View column for page_name field

//

$column = new TextViewColumn('page_name', 'Page Name', $this->dataset);

$column->SetOrderable(true);

$column->SetMaxLength(75);

$column->SetFullTextWindowHandlerName('phpgen_user_permsGrid_page_name_handler_list');

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

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

$column->SetFixedWidth(null);

$grid->AddViewColumn($column);

//

// View column for perm_name field

//

$column = new TextViewColumn('perm_name', 'Perm Name', $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 user_id field

//

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

$column->SetOrderable(true);

$grid->AddSingleRecordViewColumn($column);

//

// View column for page_name field

//

$column = new TextViewColumn('page_name', 'Page Name', $this->dataset);

$column->SetOrderable(true);

$column->SetMaxLength(75);

$column->SetFullTextWindowHandlerName('phpgen_user_permsGrid_page_name_handler_view');

$grid->AddSingleRecordViewColumn($column);

//

// View column for perm_name field

//

$column = new TextViewColumn('perm_name', 'Perm Name', $this->dataset);

$column->SetOrderable(true);

$grid->AddSingleRecordViewColumn($column);

}

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

}

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 AddPrintColumns(Grid $grid)

{

//

// View column for user_id field

//

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

$column->SetOrderable(true);

$grid->AddPrintColumn($column);

//

// View column for page_name field

//

$column = new TextViewColumn('page_name', 'Page Name', $this->dataset);

$column->SetOrderable(true);

$grid->AddPrintColumn($column);

//

// View column for perm_name field

//

$column = new TextViewColumn('perm_name', 'Perm Name', $this->dataset);

$column->SetOrderable(true);

$grid->AddPrintColumn($column);

}

protected function AddExportColumns(Grid $grid)

{

//

// View column for user_id field

//

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

$column->SetOrderable(true);

$grid->AddExportColumn($column);

//

// View column for page_name field

//

$column = new TextViewColumn('page_name', 'Page Name', $this->dataset);

$column->SetOrderable(true);

$grid->AddExportColumn($column);

//

// View column for perm_name field

//

$column = new TextViewColumn('perm_name', 'Perm Name', $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 'phpgen_user_perms_modal_delete'; }

protected function GetEnableModalGridDelete() { return true; }

protected function CreateGrid()

{

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

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 page_name field

//

$column = new TextViewColumn('page_name', 'Page Name', $this->dataset);

$column->SetOrderable(true);

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

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

// View column for page_name field

//

$column = new TextViewColumn('page_name', 'Page Name', $this->dataset);

$column->SetOrderable(true);

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

GetApplication()->RegisterHTTPHandler($handler);

return $result;

}

public function OpenAdvancedSearchByDefault()

{

return false;

}

protected function DoGetGridHeader()

{

return '';

}