protected function AddExportColumns(Grid $grid)
{
//
// View column for codice field
//
$column = new TextViewColumn('codice', 'Codice', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for descrizione field
//
$column = new TextViewColumn('descrizione', 'Descrizione', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
}
/**
* @param TextViewColumn $column
*/
public function RenderTextViewColumn($column)
{
$value = $column->GetValue();
$dataset = $column->GetDataset();
$column->BeforeColumnRender->Fire(array(&$value, &$dataset));
if (!isset($value)) {
$this->result = $this->GetNullValuePresentation($column);
} else {
if ($column->GetEscapeHTMLSpecialChars()) {
$value = htmlspecialchars($value);
}
$columnMaxLength = $column->GetMaxLength();
if ($this->HttpHandlersAvailable() && $this->ChildPagesAvailable() && isset($columnMaxLength) && isset($value) && StringUtils::StringLength($value, $column->GetGrid()->GetPage()->GetContentEncoding()) > $columnMaxLength) {
$originalValue = $value;
if ($this->HtmlMarkupAvailable() && $column->GetReplaceLFByBR()) {
$originalValue = str_replace("\n", "<br/>", $originalValue);
}
$value = StringUtils::SubString($value, 0, $columnMaxLength, $column->GetGrid()->GetPage()->GetContentEncoding());
$value .= '... <span class="more_hint"><a href="' . $column->GetMoreLink() . '" ' . 'onClick="javascript: pwin = window.open(\'\',null,\'height=300,width=400,status=yes,resizable=yes,toolbar=no,menubar=no,location=no,left=150,top=200,scrollbars=yes\'); pwin.location=\'' . $column->GetMoreLink() . '\'; return false;">' . $this->captions->GetMessageString('more') . '</a>';
$value .= '<div class="box_hidden">' . $originalValue . '</div></span>';
}
if ($this->HtmlMarkupAvailable() && $column->GetReplaceLFByBR()) {
$value = str_replace("\n", "<br/>", $value);
}
$this->result = $value;
}
}
protected function AddExportColumns(Grid $grid)
{
//
// View column for priority field
//
$column = new TextViewColumn('priority', 'Priority', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for total_allocated_hrs field
//
$column = new TextViewColumn('total_allocated_hrs', 'Total Allocated Hrs', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
}
protected function AddExportColumns(Grid $grid)
{
//
// View column for project_name field
//
$column = new TextViewColumn('project_name', 'Project Name', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for approved_budget field
//
$column = new TextViewColumn('approved_budget', 'Approved Budget', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for lead field
//
$column = new TextViewColumn('lead', 'Lead', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
}
protected function AddExportColumns(Grid $grid)
{
//
// View column for FEC_WINK field
//
$column = new DateTimeViewColumn('FEC_WINK', 'FEC WINK', $this->dataset);
$column->SetDateTimeFormat('Y-m-d');
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for ES_ADMIN field
//
$column = new TextViewColumn('LA1', 'USERNAME EMISOR', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for ES_ADMIN field
//
$column = new TextViewColumn('LA2', 'USERNAME RECEPTOR', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for FEC_CREACION field
//
$column = new DateTimeViewColumn('FEC_CREACION', 'FEC CREACION', $this->dataset);
$column->SetDateTimeFormat('Y-m-d');
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for USUARIO_CREACION field
//
$column = new TextViewColumn('USUARIO_CREACION', 'USUARIO CREACION', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for FEC_ULTIMA_MOD field
//
$column = new DateTimeViewColumn('FEC_ULTIMA_MOD', 'FEC ULTIMA MOD', $this->dataset);
$column->SetDateTimeFormat('Y-m-d');
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for USUARIO_ULTIMA_MOD field
//
$column = new TextViewColumn('USUARIO_ULTIMA_MOD', 'USUARIO ULTIMA MOD', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
}
protected function AddExportColumns(Grid $grid)
{
//
// View column for USERNAME field
//
$column = new TextViewColumn('USERNAME', 'USERNAME', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for ES_REAL field
//
$column = new TextViewColumn('ES_REAL', 'ES REAL', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for NOMBRE field
//
$column = new TextViewColumn('LA1', 'EJERCICIO ID', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for FEC_CREACION field
//
$column = new DateTimeViewColumn('FEC_CREACION', 'FEC CREACION', $this->dataset);
$column->SetDateTimeFormat('Y-m-d');
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for USUARIO_CREACION field
//
$column = new TextViewColumn('USUARIO_CREACION', 'USUARIO CREACION', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for FEC_ULTIMA_MOD field
//
$column = new DateTimeViewColumn('FEC_ULTIMA_MOD', 'FEC ULTIMA MOD', $this->dataset);
$column->SetDateTimeFormat('Y-m-d');
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for USUARIO_ULTIMA_MOD field
//
$column = new TextViewColumn('USUARIO_ULTIMA_MOD', 'USUARIO ULTIMA MOD', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($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 ofv-numoff field
//
$column = new TextViewColumn('ofv-numoff', 'Ofv-numoff', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for ofv-codvoce field
//
$column = new TextViewColumn('ofv-codvoce', 'Ofv-codvoce', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for ofv-quantita field
//
$column = new TextViewColumn('ofv-quantita', 'Ofv-quantita', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for ofv-lunghezza field
//
$column = new TextViewColumn('ofv-lunghezza', 'Ofv-lunghezza', $this->dataset);
$column->SetOrderable(true);
$column = new NumberFormatValueViewColumnDecorator($column, 2, '.', ',');
$grid->AddExportColumn($column);
//
// View column for ofv-larghezza field
//
$column = new TextViewColumn('ofv-larghezza', 'Ofv-larghezza', $this->dataset);
$column->SetOrderable(true);
$column = new NumberFormatValueViewColumnDecorator($column, 2, '.', ',');
$grid->AddExportColumn($column);
//
// View column for ofv-tiposmu field
//
$column = new TextViewColumn('ofv-tiposmu', 'Ofv-tiposmu', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for ofv-przacq field
//
$column = new TextViewColumn('ofv-przacq', 'Ofv-przacq', $this->dataset);
$column->SetOrderable(true);
$column = new NumberFormatValueViewColumnDecorator($column, 2, '.', ',');
$grid->AddExportColumn($column);
//
// View column for ofv-sconto field
//
$column = new TextViewColumn('ofv-sconto', 'Ofv-sconto', $this->dataset);
$column->SetOrderable(true);
$column = new NumberFormatValueViewColumnDecorator($column, 2, '.', ',');
$grid->AddExportColumn($column);
//
// View column for ofv-valuni-cal field
//
$column = new TextViewColumn('ofv-valuni-cal', 'Ofv-valuni-cal', $this->dataset);
$column->SetOrderable(true);
$column = new NumberFormatValueViewColumnDecorator($column, 2, '.', ',');
$grid->AddExportColumn($column);
//
// View column for ofv-valuni-fin field
//
$column = new TextViewColumn('ofv-valuni-fin', 'Ofv-valuni-fin', $this->dataset);
$column->SetOrderable(true);
$column = new NumberFormatValueViewColumnDecorator($column, 2, '.', ',');
$grid->AddExportColumn($column);
//
// View column for datains field
//
$column = new DateTimeViewColumn('datains', 'Datains', $this->dataset);
$column->SetDateTimeFormat('d-m-Y H:i:s');
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for datamod field
//
$column = new DateTimeViewColumn('datamod', 'Datamod', $this->dataset);
$column->SetDateTimeFormat('d-m-Y H:i:s');
$column->SetOrderable(true);
$grid->AddExportColumn($column);
}
protected function AddExportColumns(Grid $grid)
{
//
// View column for name field
//
$column = new TextViewColumn('name', 'Name', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for total_hours field
//
$column = new TextViewColumn('total_hours', 'Actual Hours', $this->dataset);
$column->SetOrderable(true);
$column = new NumberFormatValueViewColumnDecorator($column, 2, ',', '.');
$grid->AddExportColumn($column);
//
// View column for project_name field
//
$column = new TextViewColumn('project_name', 'Project Name', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for task_name field
//
$column = new TextViewColumn('task_name', 'Task Name', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
}
protected function AddExportColumns(Grid $grid)
{
//
// View column for name field
//
$column = new TextViewColumn('name', 'Name', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for actual_hours field
//
$column = new TextViewColumn('actual_hours', 'Actual Hours', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
}
function CreateMasterDetailRecordGridForfacturas_abonosDetailEdit0facturasGrid()
{
$result = new Grid($this, $this->dataset, 'MasterDetailRecordGridForfacturas_abonosDetailEdit0facturas');
$result->SetAllowDeleteSelected(false);
$result->SetShowFilterBuilder(false);
$result->SetAdvancedSearchAvailable(false);
$result->SetFilterRowAvailable(false);
$result->SetShowUpdateLink(false);
$result->SetEnabledInlineEditing(false);
$result->SetName('master_grid');
//
// View column for idFacturas field
//
$column = new TextViewColumn('idFacturas', 'IdFacturas', $this->dataset);
$column->SetOrderable(true);
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$result->AddViewColumn($column);
//
// View column for Fecha field
//
$column = new TextViewColumn('Fecha', 'Fecha', $this->dataset);
$column->SetOrderable(true);
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$result->AddViewColumn($column);
//
// View column for OCompra field
//
$column = new TextViewColumn('OCompra', 'OCompra', $this->dataset);
$column->SetOrderable(true);
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$result->AddViewColumn($column);
//
// View column for OSalida field
//
$column = new TextViewColumn('OSalida', 'OSalida', $this->dataset);
$column->SetOrderable(true);
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$result->AddViewColumn($column);
//
// View column for FormaPago field
//
$column = new TextViewColumn('FormaPago', 'FormaPago', $this->dataset);
$column->SetOrderable(true);
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$result->AddViewColumn($column);
//
// View column for Subtotal field
//
$column = new TextViewColumn('Subtotal', 'Subtotal', $this->dataset);
$column->SetOrderable(true);
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$result->AddViewColumn($column);
//
// View column for IVA field
//
$column = new TextViewColumn('IVA', 'IVA', $this->dataset);
$column->SetOrderable(true);
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$result->AddViewColumn($column);
//
// View column for Descuentos field
//
$column = new TextViewColumn('Descuentos', 'Descuentos', $this->dataset);
$column->SetOrderable(true);
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$result->AddViewColumn($column);
//
// View column for Total field
//
$column = new TextViewColumn('Total', 'Total', $this->dataset);
$column->SetOrderable(true);
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$result->AddViewColumn($column);
//
// View column for SaldoFact field
//
$column = new TextViewColumn('SaldoFact', 'SaldoFact', $this->dataset);
$column->SetOrderable(true);
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$result->AddViewColumn($column);
//
// View column for TotalCostos field
//
$column = new TextViewColumn('TotalCostos', 'TotalCostos', $this->dataset);
$column->SetOrderable(true);
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$result->AddViewColumn($column);
//
// View column for Cotizaciones_idCotizaciones field
//
$column = new TextViewColumn('Cotizaciones_idCotizaciones', 'Cotizaciones IdCotizaciones', $this->dataset);
$column->SetOrderable(true);
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$result->AddViewColumn($column);
//
// View column for EmpresaPro_idEmpresaPro field
//
$column = new TextViewColumn('EmpresaPro_idEmpresaPro', 'EmpresaPro IdEmpresaPro', $this->dataset);
$column->SetOrderable(true);
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$result->AddViewColumn($column);
//
// View column for Usuarios_idUsuarios field
//
$column = new TextViewColumn('Usuarios_idUsuarios', 'Usuarios IdUsuarios', $this->dataset);
$column->SetOrderable(true);
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$result->AddViewColumn($column);
//
// View column for Clientes_idClientes field
//
$column = new TextViewColumn('Clientes_idClientes', 'Clientes IdClientes', $this->dataset);
$column->SetOrderable(true);
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$result->AddViewColumn($column);
//
// View column for nombre field
//
$column = new TextViewColumn('CentroCosto_nombre', 'CentroCosto', $this->dataset);
$column->SetOrderable(true);
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$result->AddViewColumn($column);
//
// View column for idFacturas field
//
$column = new TextViewColumn('idFacturas', 'IdFacturas', $this->dataset);
$column->SetOrderable(true);
$result->AddPrintColumn($column);
//
// View column for Fecha field
//
$column = new TextViewColumn('Fecha', 'Fecha', $this->dataset);
$column->SetOrderable(true);
$result->AddPrintColumn($column);
//
// View column for OCompra field
//
$column = new TextViewColumn('OCompra', 'OCompra', $this->dataset);
$column->SetOrderable(true);
$result->AddPrintColumn($column);
//
// View column for OSalida field
//
$column = new TextViewColumn('OSalida', 'OSalida', $this->dataset);
$column->SetOrderable(true);
$result->AddPrintColumn($column);
//
// View column for FormaPago field
//
$column = new TextViewColumn('FormaPago', 'FormaPago', $this->dataset);
$column->SetOrderable(true);
$result->AddPrintColumn($column);
//
// View column for Subtotal field
//
$column = new TextViewColumn('Subtotal', 'Subtotal', $this->dataset);
$column->SetOrderable(true);
$result->AddPrintColumn($column);
//
// View column for IVA field
//
$column = new TextViewColumn('IVA', 'IVA', $this->dataset);
$column->SetOrderable(true);
$result->AddPrintColumn($column);
//
// View column for Descuentos field
//
$column = new TextViewColumn('Descuentos', 'Descuentos', $this->dataset);
$column->SetOrderable(true);
$result->AddPrintColumn($column);
//
// View column for Total field
//
$column = new TextViewColumn('Total', 'Total', $this->dataset);
$column->SetOrderable(true);
$result->AddPrintColumn($column);
//
// View column for SaldoFact field
//
$column = new TextViewColumn('SaldoFact', 'SaldoFact', $this->dataset);
$column->SetOrderable(true);
$result->AddPrintColumn($column);
//
// View column for TotalCostos field
//
$column = new TextViewColumn('TotalCostos', 'TotalCostos', $this->dataset);
$column->SetOrderable(true);
$result->AddPrintColumn($column);
//
// View column for Cotizaciones_idCotizaciones field
//
$column = new TextViewColumn('Cotizaciones_idCotizaciones', 'Cotizaciones IdCotizaciones', $this->dataset);
$column->SetOrderable(true);
$result->AddPrintColumn($column);
//
// View column for EmpresaPro_idEmpresaPro field
//
$column = new TextViewColumn('EmpresaPro_idEmpresaPro', 'EmpresaPro IdEmpresaPro', $this->dataset);
$column->SetOrderable(true);
$result->AddPrintColumn($column);
//
// View column for Usuarios_idUsuarios field
//
$column = new TextViewColumn('Usuarios_idUsuarios', 'Usuarios IdUsuarios', $this->dataset);
$column->SetOrderable(true);
$result->AddPrintColumn($column);
//
// View column for Clientes_idClientes field
//
$column = new TextViewColumn('Clientes_idClientes', 'Clientes IdClientes', $this->dataset);
$column->SetOrderable(true);
$result->AddPrintColumn($column);
//
// View column for nombre field
//
$column = new TextViewColumn('CentroCosto_nombre', 'CentroCosto', $this->dataset);
$column->SetOrderable(true);
$result->AddPrintColumn($column);
return $result;
}
protected function AddExportColumns(Grid $grid)
{
//
// View column for project_name field
//
$column = new TextViewColumn('project_name', 'Project Name', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for date_start field
//
$column = new TextViewColumn('date_start', 'Date Start', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for date_end field
//
$column = new TextViewColumn('date_end', 'Date End', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
}
protected function AddExportColumns(Grid $grid)
{
//
// View column for idPUC field
//
$column = new TextViewColumn('idPUC', 'IdPUC', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for Nombre field
//
$column = new TextViewColumn('Nombre', 'Nombre', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for Valor field
//
$column = new TextViewColumn('Valor', 'Valor', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for GupoCuentas_PUC field
//
$column = new TextViewColumn('GupoCuentas_PUC', 'GupoCuentas PUC', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
}
protected function CreateGrid()
{
$result = new Grid($this, $this->dataset, 'field_namesGrid');
if ($this->GetSecurityInfo()->HasDeleteGrant()) {
$result->SetAllowDeleteSelected(true);
} else {
$result->SetAllowDeleteSelected(false);
}
ApplyCommonPageSettings($this, $result);
$result->SetUseImagesForActions(true);
$result->SetUseFixedHeader(false);
$result->SetShowLineNumbers(false);
$result->SetHighlightRowAtHover(false);
$result->SetWidth('');
$this->CreateGridSearchControl($result);
$this->CreateGridAdvancedSearchControl($result);
$this->AddOperationsColumns($result);
$this->AddFieldColumns($result);
$this->AddSingleRecordViewColumns($result);
$this->AddEditColumns($result);
$this->AddInsertColumns($result);
$this->AddPrintColumns($result);
$this->AddExportColumns($result);
$this->SetShowPageList(true);
$this->SetHidePageListByDefault(false);
$this->SetExportToExcelAvailable(true);
$this->SetExportToWordAvailable(true);
$this->SetExportToXmlAvailable(false);
$this->SetExportToCsvAvailable(true);
$this->SetExportToPdfAvailable(true);
$this->SetPrinterFriendlyAvailable(true);
$this->SetSimpleSearchAvailable(true);
$this->SetAdvancedSearchAvailable(true);
$this->SetFilterRowAvailable(true);
$this->SetVisualEffectsEnabled(true);
$this->SetShowTopPageNavigator(true);
$this->SetShowBottomPageNavigator(true);
//
// Http Handlers
//
//
// View column for task_name field
//
$column = new TextViewColumn('task_name', 'Task Name', $this->dataset);
$column->SetOrderable(true);
$handler = new ShowTextBlobHandler($this->dataset, $this, 'field_namesGrid_task_name_handler_list', $column);
GetApplication()->RegisterHTTPHandler($handler);
//
// View column for public_engagement field
//
$column = new TextViewColumn('public_engagement', 'Public Engagement', $this->dataset);
$column->SetOrderable(true);
$handler = new ShowTextBlobHandler($this->dataset, $this, 'field_namesGrid_public_engagement_handler_list', $column);
GetApplication()->RegisterHTTPHandler($handler);
//
// View column for level_of_service field
//
$column = new TextViewColumn('level_of_service', 'Level Of Service', $this->dataset);
$column->SetOrderable(true);
$handler = new ShowTextBlobHandler($this->dataset, $this, 'field_namesGrid_level_of_service_handler_list', $column);
GetApplication()->RegisterHTTPHandler($handler);
//
// View column for project_type field
//
$column = new TextViewColumn('project_type', 'Project Type', $this->dataset);
$column->SetOrderable(true);
$handler = new ShowTextBlobHandler($this->dataset, $this, 'field_namesGrid_project_type_handler_list', $column);
GetApplication()->RegisterHTTPHandler($handler);
//
// View column for task_name field
//
$column = new TextViewColumn('task_name', 'Task Name', $this->dataset);
$column->SetOrderable(true);
$handler = new ShowTextBlobHandler($this->dataset, $this, 'field_namesGrid_task_name_handler_view', $column);
GetApplication()->RegisterHTTPHandler($handler);
//
// View column for public_engagement field
//
$column = new TextViewColumn('public_engagement', 'Public Engagement', $this->dataset);
$column->SetOrderable(true);
$handler = new ShowTextBlobHandler($this->dataset, $this, 'field_namesGrid_public_engagement_handler_view', $column);
GetApplication()->RegisterHTTPHandler($handler);
//
// View column for level_of_service field
//
$column = new TextViewColumn('level_of_service', 'Level Of Service', $this->dataset);
$column->SetOrderable(true);
$handler = new ShowTextBlobHandler($this->dataset, $this, 'field_namesGrid_level_of_service_handler_view', $column);
GetApplication()->RegisterHTTPHandler($handler);
//
// View column for project_type field
//
$column = new TextViewColumn('project_type', 'Project Type', $this->dataset);
$column->SetOrderable(true);
$handler = new ShowTextBlobHandler($this->dataset, $this, 'field_namesGrid_project_type_handler_view', $column);
GetApplication()->RegisterHTTPHandler($handler);
return $result;
}
protected function AddExportColumns(Grid $grid)
{
//
// View column for TIPO_RELACION_ID field
//
$column = new TextViewColumn('TIPO_RELACION_ID', 'TIPO RELACION ID', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for NOMBRE field
//
$column = new TextViewColumn('NOMBRE', 'NOMBRE', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for FECHA_CREACION field
//
$column = new DateTimeViewColumn('FECHA_CREACION', 'FECHA CREACION', $this->dataset);
$column->SetDateTimeFormat('Y-m-d');
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for FECHA_MODIFICACION field
//
$column = new DateTimeViewColumn('FECHA_MODIFICACION', 'FECHA MODIFICACION', $this->dataset);
$column->SetDateTimeFormat('Y-m-d');
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for USUARIO_CREACION field
//
$column = new TextViewColumn('USUARIO_CREACION', 'USUARIO CREACION', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for USUARIO_MODIFICACION field
//
$column = new TextViewColumn('USUARIO_MODIFICACION', 'USUARIO MODIFICACION', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
}
protected function CreateGrid()
{
$result = new Grid($this, $this->dataset, 'public_office_holderGrid');
if ($this->GetSecurityInfo()->HasDeleteGrant()) {
$result->SetAllowDeleteSelected(false);
} 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 photo_link field
//
$column = new TextViewColumn('photo_link', 'Photo Link', $this->dataset);
$column->SetOrderable(true);
/* <inline edit column> */
//
// Edit column for photo_link field
//
$editor = new TextAreaEdit('photo_link_edit', 50, 8);
$editColumn = new CustomEditColumn('Photo Link', 'photo_link', $editor, $this->dataset);
$editColumn->SetAllowSetToNull(true);
$this->ApplyCommonColumnEditProperties($editColumn);
$column->SetEditOperationColumn($editColumn);
/* </inline edit column> */
/* <inline insert column> */
//
// Edit column for photo_link field
//
$editor = new TextAreaEdit('photo_link_edit', 50, 8);
$editColumn = new CustomEditColumn('Photo Link', 'photo_link', $editor, $this->dataset);
$editColumn->SetAllowSetToNull(true);
$this->ApplyCommonColumnEditProperties($editColumn);
$column->SetInsertOperationColumn($editColumn);
/* </inline insert column> */
$handler = new ShowTextBlobHandler($this->dataset, $this, 'public_office_holderGrid_photo_link_handler_list', $column);
GetApplication()->RegisterHTTPHandler($handler);
//
// View column for notes field
//
$column = new TextViewColumn('notes', 'Notes', $this->dataset);
$column->SetOrderable(true);
/* <inline edit column> */
//
// Edit column for notes field
//
$editor = new TextAreaEdit('notes_edit', 50, 8);
$editColumn = new CustomEditColumn('Notes', 'notes', $editor, $this->dataset);
$editColumn->SetAllowSetToNull(true);
$this->ApplyCommonColumnEditProperties($editColumn);
$column->SetEditOperationColumn($editColumn);
/* </inline edit column> */
/* <inline insert column> */
//
// Edit column for notes field
//
$editor = new TextAreaEdit('notes_edit', 50, 8);
$editColumn = new CustomEditColumn('Notes', 'notes', $editor, $this->dataset);
$editColumn->SetAllowSetToNull(true);
$this->ApplyCommonColumnEditProperties($editColumn);
$column->SetInsertOperationColumn($editColumn);
/* </inline insert column> */
$handler = new ShowTextBlobHandler($this->dataset, $this, 'public_office_holderGrid_notes_handler_list', $column);
GetApplication()->RegisterHTTPHandler($handler);
//
// View column for photo_link field
//
$column = new TextViewColumn('photo_link', 'Photo Link', $this->dataset);
$column->SetOrderable(true);
$handler = new ShowTextBlobHandler($this->dataset, $this, 'public_office_holderGrid_photo_link_handler_view', $column);
GetApplication()->RegisterHTTPHandler($handler);
//
// View column for notes field
//
$column = new TextViewColumn('notes', 'Notes', $this->dataset);
$column->SetOrderable(true);
$handler = new ShowTextBlobHandler($this->dataset, $this, 'public_office_holderGrid_notes_handler_view', $column);
GetApplication()->RegisterHTTPHandler($handler);
return $result;
}
function CreateMasterDetailRecordGridForofferte_dettaglio_articoliDetailEdit0offerteGrid()
{
$result = new Grid($this, $this->dataset, 'MasterDetailRecordGridForofferte_dettaglio_articoliDetailEdit0offerte');
$result->SetAllowDeleteSelected(false);
$result->SetShowFilterBuilder(false);
$result->SetAdvancedSearchAvailable(false);
$result->SetFilterRowAvailable(false);
$result->SetShowUpdateLink(false);
$result->SetEnabledInlineEditing(false);
$result->SetShowKeyColumnsImagesInHeader(false);
$result->SetName('master_grid');
//
// View column for off-numoff field
//
$column = new TextViewColumn('off-numoff', 'Off-numoff', $this->dataset);
$column->SetOrderable(true);
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$result->AddViewColumn($column);
//
// View column for cli-ragsoc field
//
$column = new TextViewColumn('off-codcli_cli-ragsoc', 'cod.Cliente', $this->dataset);
$column->SetOrderable(true);
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$result->AddViewColumn($column);
//
// View column for off-descriz field
//
$column = new TextViewColumn('off-descriz', 'Off-descriz', $this->dataset);
$column->SetOrderable(true);
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$result->AddViewColumn($column);
//
// View column for off-gg-termine-consegna field
//
$column = new TextViewColumn('off-gg-termine-consegna', 'Off-gg-termine-consegna', $this->dataset);
$column->SetOrderable(true);
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$result->AddViewColumn($column);
//
// View column for off-datains field
//
$column = new DateTimeViewColumn('off-datains', 'Data inserimento', $this->dataset);
$column->SetDateTimeFormat('d-m-Y');
$column->SetOrderable(true);
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$result->AddViewColumn($column);
//
// View column for off-dataeva field
//
$column = new DateTimeViewColumn('off-dataeva', 'Data evasione', $this->dataset);
$column->SetDateTimeFormat('d-m-Y');
$column->SetOrderable(true);
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$result->AddViewColumn($column);
//
// View column for datains field
//
$column = new DateTimeViewColumn('datains', 'Data ins', $this->dataset);
$column->SetDateTimeFormat('d-m-Y');
$column->SetOrderable(true);
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$result->AddViewColumn($column);
//
// View column for off-numoff field
//
$column = new TextViewColumn('off-numoff', 'Off-numoff', $this->dataset);
$column->SetOrderable(true);
$result->AddPrintColumn($column);
//
// View column for cli-ragsoc field
//
$column = new TextViewColumn('off-codcli_cli-ragsoc', 'cod.Cliente', $this->dataset);
$column->SetOrderable(true);
$result->AddPrintColumn($column);
//
// View column for off-descriz field
//
$column = new TextViewColumn('off-descriz', 'Off-descriz', $this->dataset);
$column->SetOrderable(true);
$result->AddPrintColumn($column);
//
// View column for off-gg-termine-consegna field
//
$column = new TextViewColumn('off-gg-termine-consegna', 'Off-gg-termine-consegna', $this->dataset);
$column->SetOrderable(true);
$result->AddPrintColumn($column);
//
// View column for off-datains field
//
$column = new DateTimeViewColumn('off-datains', 'Data inserimento', $this->dataset);
$column->SetDateTimeFormat('d-m-Y');
$column->SetOrderable(true);
$result->AddPrintColumn($column);
//
// View column for off-dataeva field
//
$column = new DateTimeViewColumn('off-dataeva', 'Data evasione', $this->dataset);
$column->SetDateTimeFormat('d-m-Y');
$column->SetOrderable(true);
$result->AddPrintColumn($column);
//
// View column for datains field
//
$column = new DateTimeViewColumn('datains', 'Data ins', $this->dataset);
$column->SetDateTimeFormat('d-m-Y');
$column->SetOrderable(true);
$result->AddPrintColumn($column);
return $result;
}
protected function AddExportColumns(Grid $grid)
{
//
// View column for Cod_dpto field
//
$column = new TextViewColumn('Cod_dpto', 'Cod Dpto', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for Nombre field
//
$column = new TextViewColumn('Nombre', 'Nombre', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
}
protected function AddExportColumns(Grid $grid)
{
//
// View column for total_hrs field
//
$column = new TextViewColumn('total_hrs', 'Total Hours', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
}
protected function AddExportColumns(Grid $grid)
{
//
// View column for Name field
//
$column = new TextViewColumn('Name', 'Name', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
}
protected function AddExportColumns(Grid $grid)
{
//
// View column for MASCOTA_ID field
//
$column = new TextViewColumn('MASCOTA_ID', 'MASCOTA ID', $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 FEC_CREACION field
//
$column = new DateTimeViewColumn('FEC_CREACION', 'FEC CREACION', $this->dataset);
$column->SetDateTimeFormat('Y-m-d');
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for USUARIO_CREACION field
//
$column = new TextViewColumn('USUARIO_CREACION', 'USUARIO CREACION', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for FEC_ULTIMA_MOD field
//
$column = new DateTimeViewColumn('FEC_ULTIMA_MOD', 'FEC ULTIMA MOD', $this->dataset);
$column->SetDateTimeFormat('Y-m-d');
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for USUARIO_ULTIMA_MOD field
//
$column = new TextViewColumn('USUARIO_ULTIMA_MOD', 'USUARIO ULTIMA MOD', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
}
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;
}
protected function CreateGrid()
{
$result = new Grid($this, $this->dataset, 'empresaGrid');
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 nombre field
//
$column = new TextViewColumn('nombre', 'Nombre', $this->dataset);
$column->SetOrderable(true);
/* <inline edit column> */
//
// Edit column for nombre field
//
$editor = new TextEdit('nombre_edit');
$editor->SetSize(80);
$editor->SetMaxLength(80);
$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 TextEdit('nombre_edit');
$editor->SetSize(80);
$editor->SetMaxLength(80);
$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 depto field
//
$column = new TextViewColumn('depto', 'Depto', $this->dataset);
$column->SetOrderable(true);
/* <inline edit column> */
//
// Edit column for depto field
//
$editor = new TextAreaEdit('depto_edit', 50, 8);
$editColumn = new CustomEditColumn('Depto', 'depto', $editor, $this->dataset);
$editColumn->SetAllowSetToNull(true);
$this->ApplyCommonColumnEditProperties($editColumn);
$column->SetEditOperationColumn($editColumn);
/* </inline edit column> */
/* <inline insert column> */
//
// Edit column for depto field
//
$editor = new TextAreaEdit('depto_edit', 50, 8);
$editColumn = new CustomEditColumn('Depto', 'depto', $editor, $this->dataset);
$editColumn->SetAllowSetToNull(true);
$this->ApplyCommonColumnEditProperties($editColumn);
$column->SetInsertOperationColumn($editColumn);
/* </inline insert column> */
$handler = new ShowTextBlobHandler($this->dataset, $this, 'depto_handler', $column);
GetApplication()->RegisterHTTPHandler($handler);
//
// View column for mupio field
//
$column = new TextViewColumn('mupio', 'Mupio', $this->dataset);
$column->SetOrderable(true);
/* <inline edit column> */
//
// Edit column for mupio field
//
$editor = new TextAreaEdit('mupio_edit', 50, 8);
$editColumn = new CustomEditColumn('Mupio', 'mupio', $editor, $this->dataset);
$editColumn->SetAllowSetToNull(true);
$this->ApplyCommonColumnEditProperties($editColumn);
$column->SetEditOperationColumn($editColumn);
/* </inline edit column> */
/* <inline insert column> */
//
// Edit column for mupio field
//
$editor = new TextAreaEdit('mupio_edit', 50, 8);
$editColumn = new CustomEditColumn('Mupio', 'mupio', $editor, $this->dataset);
$editColumn->SetAllowSetToNull(true);
$this->ApplyCommonColumnEditProperties($editColumn);
$column->SetInsertOperationColumn($editColumn);
/* </inline insert column> */
$handler = new ShowTextBlobHandler($this->dataset, $this, 'mupio_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 depto field
//
$column = new TextViewColumn('depto', 'Depto', $this->dataset);
$column->SetOrderable(true);
$handler = new ShowTextBlobHandler($this->dataset, $this, 'depto_handler', $column);
GetApplication()->RegisterHTTPHandler($handler);
//
// View column for mupio field
//
$column = new TextViewColumn('mupio', 'Mupio', $this->dataset);
$column->SetOrderable(true);
$handler = new ShowTextBlobHandler($this->dataset, $this, 'mupio_handler', $column);
GetApplication()->RegisterHTTPHandler($handler);
return $result;
}
protected function CreateGrid()
{
$result = new Grid($this, $this->dataset, 'projectGrid');
if ($this->GetSecurityInfo()->HasDeleteGrant()) {
$result->SetAllowDeleteSelected(true);
} else {
$result->SetAllowDeleteSelected(false);
}
ApplyCommonPageSettings($this, $result);
$result->SetUseImagesForActions(true);
$result->SetInsertClientValidationScript($this->RenderText('if ( Number(fieldValues[\'budget_spent\']) > Number(fieldValues[\'approved_budget\']))
{
errorInfo.SetMessage(\'"Budget spent is greater than the Approved Budget"\');
return false;
}
else if
(fieldValues[\'date_start\'] >= fieldValues[\'date_end\'])
{
errorInfo.SetMessage(\'"Start date is greater than or equal to End date"\');
return false;
}'));
$result->SetEditClientFormLoadedScript($this->RenderText('if (editors[\'approved\'].getValue() == 1) {
editors[\'programm_id\'].setEnabled(false);
editors[\'project_name\'].setEnabled(false);
editors[\'date_start\'].setEnabled(false);
editors[\'date_end\'].setEnabled(false);
editors[\'approved_budget\'].setEnabled(false);
editors[\'notes\'].setEnabled(false);
editors[\'priority\'].setEnabled(false);
editors[\'lead\'].setEnabled(false);
editors[\'level_of_service\'].setEnabled(false);
editors[\'multi_year\'].setEnabled(false);
editors[\'public_engagement\'].setEnabled(false);
editors[\'year\'].setEnabled(false);
editors[\'dept_id\'].setEnabled(false);
}
else
{
editors[\'programm_id\'].setEnabled(true);
editors[\'project_name\'].setEnabled(true);
editors[\'date_start\'].setEnabled(true);
editors[\'date_end\'].setEnabled(true);
editors[\'approved_budget\'].setEnabled(true);
editors[\'notes\'].setEnabled(true);
editors[\'priority\'].setEnabled(true);
editors[\'lead\'].setEnabled(true);
editors[\'level_of_service\'].setEnabled(true);
editors[\'multi_year\'].setEnabled(true);
editors[\'public_engagement\'].setEnabled(true);
editors[\'year\'].setEnabled(true);
editors[\'dept_id\'].setEnabled(true);
}'));
$result->SetEditClientValidationScript($this->RenderText('if ( Number(fieldValues[\'budget_spent\']) > Number(fieldValues[\'approved_budget\']))
{
errorInfo.SetMessage(\'"Budget spent is greater than the Approved Budget"\');
return false;
}
else if
(fieldValues[\'date_start\'] >= fieldValues[\'date_end\'])
{
errorInfo.SetMessage(\'"Start date is greater than or equal to End date"\');
return false;
}'));
$result->SetUseFixedHeader(false);
$result->SetShowLineNumbers(false);
$result->SetHighlightRowAtHover(false);
$result->SetWidth('');
$this->OnGetCustomTemplate->AddListener('projectGrid' . '_OnGetCustomTemplate', $this);
$result->OnCustomDrawCell->AddListener('projectGrid' . '_OnCustomDrawRow', $this);
$result->OnCustomRenderColumn->AddListener('projectGrid' . '_' . 'OnCustomRenderColumn', $this);
$result->OnCustomRenderTotal->AddListener('projectGrid' . '_' . 'OnCustomRenderTotal', $this);
$result->BeforeUpdateRecord->AddListener('projectGrid' . '_' . 'BeforeUpdateRecord', $this);
$result->BeforeInsertRecord->AddListener('projectGrid' . '_' . 'BeforeInsertRecord', $this);
$this->CreateGridSearchControl($result);
$this->CreateGridAdvancedSearchControl($result);
$this->AddOperationsColumns($result);
$this->AddFieldColumns($result);
$this->AddSingleRecordViewColumns($result);
$this->AddEditColumns($result);
$this->AddInsertColumns($result);
$this->AddPrintColumns($result);
$this->AddExportColumns($result);
$this->SetShowPageList(true);
$this->SetHidePageListByDefault(false);
$this->SetExportToExcelAvailable(true);
$this->SetExportToWordAvailable(true);
$this->SetExportToXmlAvailable(false);
$this->SetExportToCsvAvailable(true);
$this->SetExportToPdfAvailable(true);
$this->SetPrinterFriendlyAvailable(true);
$this->SetSimpleSearchAvailable(true);
$this->SetAdvancedSearchAvailable(true);
$this->SetFilterRowAvailable(true);
$this->SetVisualEffectsEnabled(true);
$this->SetShowTopPageNavigator(true);
$this->SetShowBottomPageNavigator(true);
//
// Http Handlers
//
$pageView = new taskDetailView0projectPage($this, 'Tasks', 'Tasks', array('project_id'), GetCurrentUserGrantForDataSource('project.task'), 'UTF-8', 20, 'taskDetailEdit0project_handler');
$pageView->SetRecordPermission(GetCurrentUserRecordPermissionsForDataSource('project.task'));
$handler = new PageHTTPHandler('taskDetailView0project_handler', $pageView);
GetApplication()->RegisterHTTPHandler($handler);
$pageEdit = new taskDetailEdit0projectPage($this, array('project_id'), array('project_id'), $this->GetForeingKeyFields(), $this->CreateMasterDetailRecordGridFortaskDetailEdit0projectGrid(), $this->dataset, GetCurrentUserGrantForDataSource('project.task'), 'UTF-8');
$pageEdit->SetRecordPermission(GetCurrentUserRecordPermissionsForDataSource('project.task'));
$pageEdit->SetShortCaption('Tasks within this project');
$pageEdit->SetHeader(GetPagesHeader());
$pageEdit->SetFooter(GetPagesFooter());
$pageEdit->SetCaption('Tasks');
$pageEdit->SetHttpHandlerName('taskDetailEdit0project_handler');
$handler = new PageHTTPHandler('taskDetailEdit0project_handler', $pageEdit);
GetApplication()->RegisterHTTPHandler($handler);
$pageView = new projectDetailView1projectPage($this, 'Project Budget', 'Project Budget', array('project_id'), GetCurrentUserGrantForDataSource('project.project'), 'UTF-8', 20, 'projectDetailEdit1project_handler');
$pageView->SetRecordPermission(GetCurrentUserRecordPermissionsForDataSource('project.project'));
$handler = new PageHTTPHandler('projectDetailView1project_handler', $pageView);
GetApplication()->RegisterHTTPHandler($handler);
$pageEdit = new projectDetailEdit1projectPage($this, array('project_id'), array('project_id'), $this->GetForeingKeyFields(), $this->CreateMasterDetailRecordGridForprojectDetailEdit1projectGrid(), $this->dataset, GetCurrentUserGrantForDataSource('project.project'), 'UTF-8');
$pageEdit->SetRecordPermission(GetCurrentUserRecordPermissionsForDataSource('project.project'));
$pageEdit->SetShortCaption('Project Budget Chart');
$pageEdit->SetHeader(GetPagesHeader());
$pageEdit->SetFooter(GetPagesFooter());
$pageEdit->SetCaption('Project Budget');
$pageEdit->SetHttpHandlerName('projectDetailEdit1project_handler');
$handler = new PageHTTPHandler('projectDetailEdit1project_handler', $pageEdit);
GetApplication()->RegisterHTTPHandler($handler);
$pageView = new project_timeline_detailDetailView2projectPage($this, 'Tasks Gantt view', 'Tasks Gantt view', array('task_project_id'), GetCurrentUserGrantForDataSource('project.project_timeline_detail'), 'UTF-8', 20, 'project_timeline_detailDetailEdit2project_handler');
$pageView->SetRecordPermission(GetCurrentUserRecordPermissionsForDataSource('project.project_timeline_detail'));
$handler = new PageHTTPHandler('project_timeline_detailDetailView2project_handler', $pageView);
GetApplication()->RegisterHTTPHandler($handler);
$pageEdit = new project_timeline_detailDetailEdit2projectPage($this, array('task_project_id'), array('project_id'), $this->GetForeingKeyFields(), $this->CreateMasterDetailRecordGridForproject_timeline_detailDetailEdit2projectGrid(), $this->dataset, GetCurrentUserGrantForDataSource('project.project_timeline_detail'), 'UTF-8');
$pageEdit->SetRecordPermission(GetCurrentUserRecordPermissionsForDataSource('project.project_timeline_detail'));
$pageEdit->SetShortCaption('Tasks Gantt view');
$pageEdit->SetHeader(GetPagesHeader());
$pageEdit->SetFooter(GetPagesFooter());
$pageEdit->SetCaption('Tasks Gantt view');
$pageEdit->SetHttpHandlerName('project_timeline_detailDetailEdit2project_handler');
$handler = new PageHTTPHandler('project_timeline_detailDetailEdit2project_handler', $pageEdit);
GetApplication()->RegisterHTTPHandler($handler);
//
// View column for notes field
//
$column = new TextViewColumn('notes', 'Objectives', $this->dataset);
$column->SetOrderable(true);
$handler = new ShowTextBlobHandler($this->dataset, $this, 'projectGrid_notes_handler_list', $column);
GetApplication()->RegisterHTTPHandler($handler);
//
// View column for public_engagement field
//
$column = new TextViewColumn('public_engagement', 'Public Engagement', $this->dataset);
$column->SetOrderable(true);
$handler = new ShowTextBlobHandler($this->dataset, $this, 'projectGrid_public_engagement_handler_list', $column);
GetApplication()->RegisterHTTPHandler($handler);
//
// View column for notes field
//
$column = new TextViewColumn('notes', 'Objectives', $this->dataset);
$column->SetOrderable(true);
$handler = new ShowTextBlobHandler($this->dataset, $this, 'projectGrid_notes_handler_view', $column);
GetApplication()->RegisterHTTPHandler($handler);
//
// View column for public_engagement field
//
$column = new TextViewColumn('public_engagement', 'Public Engagement', $this->dataset);
$column->SetOrderable(true);
$handler = new ShowTextBlobHandler($this->dataset, $this, 'projectGrid_public_engagement_handler_view', $column);
GetApplication()->RegisterHTTPHandler($handler);
return $result;
}
protected function AddExportColumns(Grid $grid)
{
//
// View column for COLOR_PELO_ID field
//
$column = new TextViewColumn('COLOR_PELO_ID', 'COLOR PELO ID', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for NOMBRE field
//
$column = new TextViewColumn('NOMBRE', 'NOMBRE', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for FEC_CREACION field
//
$column = new DateTimeViewColumn('FEC_CREACION', 'FEC CREACION', $this->dataset);
$column->SetDateTimeFormat('Y-m-d');
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for USUARIO_CREACION field
//
$column = new TextViewColumn('USUARIO_CREACION', 'USUARIO CREACION', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for FEC_ULTIMA_MOD field
//
$column = new DateTimeViewColumn('FEC_ULTIMA_MOD', 'FEC ULTIMA MOD', $this->dataset);
$column->SetDateTimeFormat('Y-m-d');
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for USUARIO_ULTIMA_MOD field
//
$column = new TextViewColumn('USUARIO_ULTIMA_MOD', 'USUARIO ULTIMA MOD', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
}
protected function CreateGrid()
{
$result = new Grid($this, $this->dataset, 'public_sga_accionGrid');
if ($this->GetSecurityInfo()->HasDeleteGrant())
$result->SetAllowDeleteSelected(true);
else
$result->SetAllowDeleteSelected(true);
ApplyCommonPageSettings($this, $result);
$result->SetUseImagesForActions(true);
$defaultSortedColumns = array();
$defaultSortedColumns[] = new SortColumn('id_accion', 'DESC');
$result->setDefaultOrdering($defaultSortedColumns);
$result->SetUseFixedHeader(false);
$result->SetShowLineNumbers(false);
$result->SetHighlightRowAtHover(true);
$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 fe_horas field
//
$column = new TextViewColumn('fe_horas', 'Horas Ejecución', $this->dataset);
$column->SetOrderable(true);
$handler = new ShowTextBlobHandler($this->dataset, $this, 'public_sga_accionGrid_fe_horas_handler_list', $column);
GetApplication()->RegisterHTTPHandler($handler);//
// View column for fe_horas field
//
$column = new TextViewColumn('fe_horas', 'Horas Ejecución', $this->dataset);
$column->SetOrderable(true);
$handler = new ShowTextBlobHandler($this->dataset, $this, 'public_sga_accionGrid_fe_horas_handler_view', $column);
GetApplication()->RegisterHTTPHandler($handler);
//
// View column for ds_referencia field
//
$column = new TextViewColumn('ds_referencia', 'Descripción', $this->dataset);
$column->SetOrderable(true);
$handler = new ShowTextBlobHandler($this->dataset, $this, 'public_sga_accionGrid_ds_referencia_handler_view', $column);
GetApplication()->RegisterHTTPHandler($handler);
return $result;
}
protected function CreateGrid()
{
$result = new Grid($this, $this->dataset, 'listino_articoliGrid');
if ($this->GetSecurityInfo()->HasDeleteGrant()) {
$result->SetAllowDeleteSelected(false);
} else {
$result->SetAllowDeleteSelected(false);
}
ApplyCommonPageSettings($this, $result);
$result->SetUseImagesForActions(true);
$result->SetUseFixedHeader(false);
$result->SetShowLineNumbers(true);
$result->SetAllowOrdering(false);
$result->SetHighlightRowAtHover(false);
$result->SetWidth('');
$result->BeforeUpdateRecord->AddListener('listino_articoliGrid' . '_' . 'BeforeUpdateRecord', $this);
$result->BeforeInsertRecord->AddListener('listino_articoliGrid' . '_' . 'BeforeInsertRecord', $this);
$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(false);
$this->SetExportToWordAvailable(false);
$this->SetExportToXmlAvailable(false);
$this->SetExportToCsvAvailable(false);
$this->SetExportToPdfAvailable(false);
$this->SetPrinterFriendlyAvailable(false);
$this->SetSimpleSearchAvailable(false);
$this->SetAdvancedSearchAvailable(false);
$this->SetFilterRowAvailable(true);
$this->SetVisualEffectsEnabled(true);
$this->SetShowTopPageNavigator(true);
$this->SetShowBottomPageNavigator(false);
//
// Http Handlers
//
//
// View column for lisdesc field
//
$column = new TextViewColumn('lisdesc', 'Descrizione', $this->dataset);
$column->SetOrderable(true);
$handler = new ShowTextBlobHandler($this->dataset, $this, 'listino_articoliGrid_lisdesc_handler_list', $column);
GetApplication()->RegisterHTTPHandler($handler);
//
// View column for lisdesc field
//
$column = new TextViewColumn('lisdesc', 'Descrizione', $this->dataset);
$column->SetOrderable(true);
$handler = new ShowTextBlobHandler($this->dataset, $this, 'listino_articoliGrid_lisdesc_handler_view', $column);
GetApplication()->RegisterHTTPHandler($handler);
$lookupDataset = new TableDataset(new MyPDOConnectionFactory(), GetConnectionOptions(), '`elenco_articoli_view`');
$field = new StringField('art-codart');
$field->SetIsNotNull(true);
$lookupDataset->AddField($field, false);
$field = new StringField('descrizione');
$lookupDataset->AddField($field, false);
$lookupDataset->setOrderByField('descrizione', GetOrderTypeAsSQL(otAscending));
$lookupDataset->AddCustomCondition(EnvVariablesUtils::EvaluateVariableTemplate($this->GetColumnVariableContainer(), ''));
$handler = new DynamicSearchHandler($lookupDataset, $this, 'edit_lis-codart_descrizione_search', 'art-codart', 'descrizione', null);
GetApplication()->RegisterHTTPHandler($handler);
$lookupDataset = new TableDataset(new MyPDOConnectionFactory(), GetConnectionOptions(), '`elenco_articoli_view`');
$field = new StringField('art-codart');
$field->SetIsNotNull(true);
$lookupDataset->AddField($field, false);
$field = new StringField('descrizione');
$lookupDataset->AddField($field, false);
$lookupDataset->setOrderByField('descrizione', GetOrderTypeAsSQL(otAscending));
$lookupDataset->AddCustomCondition(EnvVariablesUtils::EvaluateVariableTemplate($this->GetColumnVariableContainer(), ''));
$handler = new DynamicSearchHandler($lookupDataset, $this, 'insert_lis-codart_descrizione_search', 'art-codart', 'descrizione', null);
GetApplication()->RegisterHTTPHandler($handler);
return $result;
}
protected function CreateGrid()
{
$result = new Grid($this, $this->dataset, 'GE_PERSONAGrid');
if ($this->GetSecurityInfo()->HasDeleteGrant()) {
$result->SetAllowDeleteSelected(true);
} else {
$result->SetAllowDeleteSelected(false);
}
ApplyCommonPageSettings($this, $result);
$result->SetUseImagesForActions(false);
$result->SetUseFixedHeader(false);
$result->SetShowLineNumbers(false);
$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 SLOGAN field
//
$column = new TextViewColumn('SLOGAN', 'SLOGAN', $this->dataset);
$column->SetOrderable(true);
$handler = new ShowTextBlobHandler($this->dataset, $this, 'GE_PERSONAGrid_SLOGAN_handler_list', $column);
GetApplication()->RegisterHTTPHandler($handler);
//
// View column for EMAIL field
//
$column = new TextViewColumn('EMAIL', 'EMAIL', $this->dataset);
$column->SetOrderable(true);
$handler = new ShowTextBlobHandler($this->dataset, $this, 'GE_PERSONAGrid_EMAIL_handler_list', $column);
GetApplication()->RegisterHTTPHandler($handler);
//
// View column for SLOGAN field
//
$column = new TextViewColumn('SLOGAN', 'SLOGAN', $this->dataset);
$column->SetOrderable(true);
$handler = new ShowTextBlobHandler($this->dataset, $this, 'GE_PERSONAGrid_SLOGAN_handler_view', $column);
GetApplication()->RegisterHTTPHandler($handler);
//
// View column for EMAIL field
//
$column = new TextViewColumn('EMAIL', 'EMAIL', $this->dataset);
$column->SetOrderable(true);
$handler = new ShowTextBlobHandler($this->dataset, $this, 'GE_PERSONAGrid_EMAIL_handler_view', $column);
GetApplication()->RegisterHTTPHandler($handler);
return $result;
}
protected function AddExportColumns(Grid $grid)
{
//
// View column for name field
//
$column = new TextViewColumn('name', 'Name', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for date field
//
$column = new DateTimeViewColumn('date', 'Timesheet Date', $this->dataset);
$column->SetDateTimeFormat('Y-m-d');
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for project_name field
//
$column = new TextViewColumn('project_name', 'Project Name', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for pay_period_number field
//
$column = new TextViewColumn('pay_period_number', 'Pay Period ', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for hours field
//
$column = new TextViewColumn('hours', 'Hours', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for position field
//
$column = new TextViewColumn('position', 'Position', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for emp_number field
//
$column = new TextViewColumn('emp_number', 'Emp Number', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
}
protected function AddExportColumns(Grid $grid)
{
//
// View column for assigned_to field
//
$column = new TextViewColumn('assigned_to', 'Assigned To', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for total_hrs field
//
$column = new TextViewColumn('total_hrs', 'Total Hrs', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for username field
//
$column = new TextViewColumn('username', 'Username', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
}
protected function AddExportColumns(Grid $grid)
{
//
// View column for DEPT_ID field
//
$column = new TextViewColumn('DEPT_ID', 'DEPT ID', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for DEPARTMENT field
//
$column = new TextViewColumn('DEPARTMENT', 'Department', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for LOCATION field
//
$column = new TextViewColumn('LOCATION', 'Location', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for PHONE_NO field
//
$column = new TextViewColumn('PHONE_NO', 'Phone No', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
}
