public function GetValue()
{
if (!$this->IsNull()) {
return $this->currencySign . parent::GetValue();
} else {
return $this->GetInnerFieldValue();
}
}
protected function AddFieldColumns(Grid $grid)
{
//
// View column for ofa-numoff field
//
$column = new TextViewColumn('ofa-numoff', 'Ofa-numoff', $this->dataset);
$column->SetOrderable(true);
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$grid->AddViewColumn($column);
//
// View column for ofa-codart field
//
$column = new TextViewColumn('ofa-codart', 'Ofa-codart', $this->dataset);
$column->SetOrderable(true);
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$grid->AddViewColumn($column);
//
// View column for ofa-descart field
//
$column = new TextViewColumn('ofa-descart', 'Ofa-descart', $this->dataset);
$column->SetOrderable(true);
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$grid->AddViewColumn($column);
//
// View column for ofa-lungsmu field
//
$column = new TextViewColumn('ofa-lungsmu', 'Ofa-lungsmu', $this->dataset);
$column->SetOrderable(true);
$column = new NumberFormatValueViewColumnDecorator($column, 2, '.', ',');
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$grid->AddViewColumn($column);
//
// View column for ofa-moltipl field
//
$column = new TextViewColumn('ofa-moltipl', 'Ofa-moltipl', $this->dataset);
$column->SetOrderable(true);
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$grid->AddViewColumn($column);
//
// View column for ofa-oneriacc field
//
$column = new TextViewColumn('ofa-oneriacc', 'Ofa-oneriacc', $this->dataset);
$column->SetOrderable(true);
$column = new NumberFormatValueViewColumnDecorator($column, 2, '.', ',');
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$grid->AddViewColumn($column);
//
// View column for ofa-scarto field
//
$column = new TextViewColumn('ofa-scarto', 'Ofa-scarto', $this->dataset);
$column->SetOrderable(true);
$column = new NumberFormatValueViewColumnDecorator($column, 2, '.', ',');
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$grid->AddViewColumn($column);
//
// View column for ofa-lunghezza field
//
$column = new TextViewColumn('ofa-lunghezza', 'Ofa-lunghezza', $this->dataset);
$column->SetOrderable(true);
$column = new NumberFormatValueViewColumnDecorator($column, 2, '.', ',');
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$grid->AddViewColumn($column);
//
// View column for ofa-larghezza field
//
$column = new TextViewColumn('ofa-larghezza', 'Ofa-larghezza', $this->dataset);
$column->SetOrderable(true);
$column = new NumberFormatValueViewColumnDecorator($column, 2, '.', ',');
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$grid->AddViewColumn($column);
//
// View column for ofa-spessore field
//
$column = new TextViewColumn('ofa-spessore', 'Ofa-spessore', $this->dataset);
$column->SetOrderable(true);
$column = new NumberFormatValueViewColumnDecorator($column, 2, '.', ',');
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$grid->AddViewColumn($column);
//
// View column for ofa-quantita field
//
$column = new TextViewColumn('ofa-quantita', 'Ofa-quantita', $this->dataset);
$column->SetOrderable(true);
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$grid->AddViewColumn($column);
//
// View column for ofa-unimis field
//
$column = new TextViewColumn('ofa-unimis', 'Ofa-unimis', $this->dataset);
$column->SetOrderable(true);
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$grid->AddViewColumn($column);
//
// View column for ofa-przacq-net field
//
$column = new TextViewColumn('ofa-przacq-net', 'Ofa-przacq-net', $this->dataset);
$column->SetOrderable(true);
$column = new NumberFormatValueViewColumnDecorator($column, 2, '.', ',');
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$grid->AddViewColumn($column);
//
// View column for ofa-przacq-lor field
//
$column = new TextViewColumn('ofa-przacq-lor', 'Ofa-przacq-lor', $this->dataset);
$column->SetOrderable(true);
$column = new NumberFormatValueViewColumnDecorator($column, 2, '.', ',');
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$grid->AddViewColumn($column);
//
// View column for ofa-totuni field
//
$column = new TextViewColumn('ofa-totuni', 'Ofa-totuni', $this->dataset);
$column->SetOrderable(true);
$column = new NumberFormatValueViewColumnDecorator($column, 2, '.', ',');
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$grid->AddViewColumn($column);
//
// View column for ofa-totunit-fin field
//
$column = new TextViewColumn('ofa-totunit-fin', 'Ofa-totunit-fin', $this->dataset);
$column->SetOrderable(true);
$column = new NumberFormatValueViewColumnDecorator($column, 2, '.', ',');
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$grid->AddViewColumn($column);
//
// View column for ofa-totgen field
//
$column = new TextViewColumn('ofa-totgen', 'Ofa-totgen', $this->dataset);
$column->SetOrderable(true);
$column = new NumberFormatValueViewColumnDecorator($column, 2, '.', ',');
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$grid->AddViewColumn($column);
//
// View column for ofa-przven field
//
$column = new TextViewColumn('ofa-przven', 'Ofa-przven', $this->dataset);
$column->SetOrderable(true);
$column = new NumberFormatValueViewColumnDecorator($column, 2, '.', ',');
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$grid->AddViewColumn($column);
}
protected function AddFieldColumns(Grid $grid)
{
//
// View column for name field
//
$column = new TextViewColumn('name', 'Name', $this->dataset);
$column->SetOrderable(true);
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$grid->AddViewColumn($column);
//
// View column for total_hours field
//
$column = new TextViewColumn('total_hours', 'Actual Hours', $this->dataset);
$column->SetOrderable(true);
$column = new NumberFormatValueViewColumnDecorator($column, 2, ',', '.');
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$grid->AddViewColumn($column);
//
// View column for project_name field
//
$column = new TextViewColumn('project_name', 'Project Name', $this->dataset);
$column->SetOrderable(true);
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$grid->AddViewColumn($column);
//
// View column for task_name field
//
$column = new TextViewColumn('task_name', 'Task Name', $this->dataset);
$column->SetOrderable(true);
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$grid->AddViewColumn($column);
}
public function GetValue()
{
return parent::GetValue() . '%';
}
protected function AddFieldColumns(Grid $grid)
{
//
// View column for id field
//
$column = new TextViewColumn('id', 'Id', $this->dataset);
$column->SetOrderable(true);
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$grid->AddViewColumn($column);
//
// View column for ofa-numoff field
//
$column = new TextViewColumn('ofa-numoff', 'Numero Offerta', $this->dataset);
$column->SetOrderable(true);
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$grid->AddViewColumn($column);
//
// View column for art-descart field
//
$column = new TextViewColumn('ofa-codart_art-descart', 'Codice articolo', $this->dataset);
$column->SetOrderable(true);
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$grid->AddViewColumn($column);
//
// View column for ofa-descart field
//
$column = new TextViewColumn('ofa-descart', 'Ofa-descart', $this->dataset);
$column->SetOrderable(true);
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$grid->AddViewColumn($column);
//
// View column for ofa-lunghezza field
//
$column = new TextViewColumn('ofa-lunghezza', 'Lunghezza', $this->dataset);
$column->SetOrderable(true);
$column = new NumberFormatValueViewColumnDecorator($column, 2, '.', ',');
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$grid->AddViewColumn($column);
//
// View column for ofa-larghezza field
//
$column = new TextViewColumn('ofa-larghezza', 'Ofa-larghezza', $this->dataset);
$column->SetOrderable(true);
$column = new NumberFormatValueViewColumnDecorator($column, 2, '.', ',');
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$grid->AddViewColumn($column);
//
// View column for ofa-spessore field
//
$column = new TextViewColumn('ofa-spessore', 'Ofa-spessore', $this->dataset);
$column->SetOrderable(true);
$column = new NumberFormatValueViewColumnDecorator($column, 2, '.', ',');
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$grid->AddViewColumn($column);
//
// View column for ofa-quantita field
//
$column = new TextViewColumn('ofa-quantita', 'Ofa-quantita', $this->dataset);
$column->SetOrderable(true);
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$grid->AddViewColumn($column);
//
// View column for ofa-przacq-net field
//
$column = new TextViewColumn('ofa-przacq-net', 'Ofa-przacq-net', $this->dataset);
$column->SetOrderable(true);
$column = new NumberFormatValueViewColumnDecorator($column, 2, '.', ',');
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$grid->AddViewColumn($column);
//
// View column for ofa-przacq-lor field
//
$column = new TextViewColumn('ofa-przacq-lor', 'Ofa-przacq-lor', $this->dataset);
$column->SetOrderable(true);
$column = new NumberFormatValueViewColumnDecorator($column, 2, '.', ',');
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$grid->AddViewColumn($column);
//
// View column for ofa-totuni field
//
$column = new TextViewColumn('ofa-totuni', 'Ofa-totuni', $this->dataset);
$column->SetOrderable(true);
$column = new NumberFormatValueViewColumnDecorator($column, 2, '.', ',');
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$grid->AddViewColumn($column);
//
// View column for ofa-totunit-fin field
//
$column = new TextViewColumn('ofa-totunit-fin', 'Ofa-totunit-fin', $this->dataset);
$column->SetOrderable(true);
$column = new NumberFormatValueViewColumnDecorator($column, 2, '.', ',');
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$grid->AddViewColumn($column);
//
// View column for ofa-totgen field
//
$column = new TextViewColumn('ofa-totgen', 'Ofa-totgen', $this->dataset);
$column->SetOrderable(true);
$column = new NumberFormatValueViewColumnDecorator($column, 2, '.', ',');
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$grid->AddViewColumn($column);
//
// View column for ofa-przven field
//
$column = new TextViewColumn('ofa-przven', 'Ofa-przven', $this->dataset);
$column->SetOrderable(true);
$column = new NumberFormatValueViewColumnDecorator($column, 2, '.', ',');
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$grid->AddViewColumn($column);
//
// View column for datains field
//
$column = new DateTimeViewColumn('datains', 'Datains', $this->dataset);
$column->SetDateTimeFormat('d-m-Y H:i:s');
$column->SetOrderable(true);
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$grid->AddViewColumn($column);
//
// View column for datamod field
//
$column = new DateTimeViewColumn('datamod', 'Datamod', $this->dataset);
$column->SetDateTimeFormat('d-m-Y H:i:s');
$column->SetOrderable(true);
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$grid->AddViewColumn($column);
}
protected function AddFieldColumns(Grid $grid)
{
//
// View column for project_id field
//
$column = new TextViewColumn('project_id', 'Parent Project', $this->dataset);
$column->SetOrderable(true);
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$grid->AddViewColumn($column);
//
// View column for assigned_to field
//
$column = new TextViewColumn('assigned_to', 'Assigned To', $this->dataset);
$column->SetOrderable(true);
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$grid->AddViewColumn($column);
//
// View column for date_start field
//
$column = new DateTimeViewColumn('date_start', 'Date Start', $this->dataset);
$column->SetDateTimeFormat('Y-m-d');
$column->SetOrderable(true);
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$grid->AddViewColumn($column);
//
// View column for date_end field
//
$column = new DateTimeViewColumn('date_end', 'Date End', $this->dataset);
$column->SetDateTimeFormat('Y-m-d');
$column->SetOrderable(true);
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$grid->AddViewColumn($column);
//
// View column for task_name field
//
$column = new TextViewColumn('task_name', 'Task Name', $this->dataset);
$column->SetOrderable(true);
$column->SetMaxLength(75);
$column->SetFullTextWindowHandlerName('taskDetailEditGrid1department_projects_task_name_handler_list');
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$grid->AddViewColumn($column);
//
// View column for notes field
//
$column = new TextViewColumn('notes', 'Notes', $this->dataset);
$column->SetOrderable(true);
$column->SetMaxLength(75);
$column->SetFullTextWindowHandlerName('taskDetailEditGrid1department_projects_notes_handler_list');
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$grid->AddViewColumn($column);
//
// View column for hrs field
//
$column = new TextViewColumn('hrs', 'Hrs', $this->dataset);
$column->SetOrderable(true);
$column = new NumberFormatValueViewColumnDecorator($column, 2, ',', '.');
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$grid->AddViewColumn($column);
}
protected function AddFieldColumns(Grid $grid)
{
//
// View column for program_name field
//
$column = new TextViewColumn('programm_id_program_name', 'Programm Id', $this->dataset);
$column->SetOrderable(true);
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$grid->AddViewColumn($column);
//
// View column for project_name field
//
$column = new TextViewColumn('project_name', 'Project Name', $this->dataset);
$column->SetOrderable(true);
$column->SetMaxLength(75);
$column->SetFullTextWindowHandlerName('projectDetailEditGrid1project_project_name_handler_list');
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$grid->AddViewColumn($column);
//
// View column for date_start field
//
$column = new DateTimeViewColumn('date_start', 'Date Start', $this->dataset);
$column->SetDateTimeFormat('Y-m-d');
$column->SetOrderable(true);
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$grid->AddViewColumn($column);
//
// View column for date_end field
//
$column = new DateTimeViewColumn('date_end', 'Date End', $this->dataset);
$column->SetDateTimeFormat('Y-m-d H:i:s');
$column->SetOrderable(true);
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$grid->AddViewColumn($column);
//
// View column for approved_budget field
//
$column = new TextViewColumn('approved_budget', 'Approved Budget', $this->dataset);
$column->SetOrderable(true);
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$grid->AddViewColumn($column);
//
// View column for notes field
//
$column = new TextViewColumn('notes', 'Notes', $this->dataset);
$column->SetOrderable(true);
$column->SetMaxLength(75);
$column->SetFullTextWindowHandlerName('projectDetailEditGrid1project_notes_handler_list');
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$grid->AddViewColumn($column);
//
// View column for priority field
//
$column = new TextViewColumn('priority', 'Priority', $this->dataset);
$column->SetOrderable(true);
$column->SetMaxLength(75);
$column->SetFullTextWindowHandlerName('projectDetailEditGrid1project_priority_handler_list');
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$grid->AddViewColumn($column);
//
// View column for lead field
//
$column = new TextViewColumn('lead', 'Lead', $this->dataset);
$column->SetOrderable(true);
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$grid->AddViewColumn($column);
//
// View column for level_of_service field
//
$column = new TextViewColumn('level_of_service', 'Level Of Service', $this->dataset);
$column->SetOrderable(true);
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$grid->AddViewColumn($column);
//
// View column for multi_year field
//
$column = new TextViewColumn('multi_year', 'Multi Year', $this->dataset);
$column->SetOrderable(true);
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$grid->AddViewColumn($column);
//
// View column for public_engagement field
//
$column = new TextViewColumn('public_engagement', 'Public Engagement', $this->dataset);
$column->SetOrderable(true);
$column->SetMaxLength(75);
$column->SetFullTextWindowHandlerName('projectDetailEditGrid1project_public_engagement_handler_list');
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$grid->AddViewColumn($column);
//
// View column for year field
//
$column = new TextViewColumn('year', 'Year', $this->dataset);
$column->SetOrderable(true);
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$grid->AddViewColumn($column);
//
// View column for approved field
//
$column = new TextViewColumn('approved', 'Approved', $this->dataset);
$column->SetOrderable(true);
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$grid->AddViewColumn($column);
//
// View column for progress field
//
$column = new TextViewColumn('progress', 'Progress', $this->dataset);
$column->SetOrderable(true);
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$grid->AddViewColumn($column);
//
// View column for dept_id field
//
$column = new TextViewColumn('dept_id', 'Dept Id', $this->dataset);
$column->SetOrderable(true);
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$grid->AddViewColumn($column);
//
// View column for budget_spent field
//
$column = new TextViewColumn('budget_spent', 'Budget Spent', $this->dataset);
$column->SetOrderable(true);
$column = new NumberFormatValueViewColumnDecorator($column, 0, '', '');
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$grid->AddViewColumn($column);
}
protected function AddFieldColumns(Grid $grid)
{
//
// View column for voc-codvoce field
//
$column = new TextViewColumn('voc-codvoce', 'Codice voce di costo', $this->dataset);
$column->SetOrderable(true);
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$grid->AddViewColumn($column);
//
// View column for voc-descriz field
//
$column = new TextViewColumn('voc-descriz', 'Descrizione', $this->dataset);
$column->SetOrderable(true);
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$grid->AddViewColumn($column);
//
// View column for voc-semanual field
//
$column = new TextViewColumn('voc-semanual', 'Manuale', $this->dataset);
$column->SetOrderable(true);
$column = new CheckBoxFormatValueViewColumnDecorator($column);
$column->SetDisplayValues($this->RenderText('<img src="images/checked.png" alt="true">'), $this->RenderText(''));
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$grid->AddViewColumn($column);
//
// View column for voc-flagart field
//
$column = new TextViewColumn('voc-flagart', 'Prevede altri articoli', $this->dataset);
$column->SetOrderable(true);
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$grid->AddViewColumn($column);
//
// View column for voc-przunit field
//
$column = new TextViewColumn('voc-przunit', 'Prezzo unitario', $this->dataset);
$column->SetOrderable(true);
$column = new NumberFormatValueViewColumnDecorator($column, 2, '.', ',');
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$grid->AddViewColumn($column);
}
function CreateMasterDetailRecordGridFortimesheetDetailEdit0taskGrid()
{
$result = new Grid($this, $this->dataset, 'MasterDetailRecordGridFortimesheetDetailEdit0task');
$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 project_id field
//
$column = new TextViewColumn('project_id', 'Project', $this->dataset);
$column->SetOrderable(true);
$column = new ExtendedHyperLinkColumnDecorator($column, $this->dataset, 'project.php?operation=view&pk0=%project_id%', '');
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$result->AddViewColumn($column);
//
// View column for task_name field
//
$column = new TextViewColumn('task_name', 'Name', $this->dataset);
$column->SetOrderable(true);
$column->SetMaxLength(75);
$column->SetFullTextWindowHandlerName('taskGrid_task_name_handler_list');
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$result->AddViewColumn($column);
//
// View column for notes field
//
$column = new TextViewColumn('notes', 'Notes', $this->dataset);
$column->SetOrderable(true);
$column->SetMaxLength(75);
$column->SetFullTextWindowHandlerName('taskGrid_notes_handler_list');
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$result->AddViewColumn($column);
//
// View column for hrs field
//
$column = new TextViewColumn('hrs', 'Allocated Hours', $this->dataset);
$column->SetOrderable(true);
$column = new NumberFormatValueViewColumnDecorator($column, 2, ',', '.');
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$result->AddViewColumn($column);
//
// View column for assigned_to field
//
$column = new TextViewColumn('assigned_to', 'Assigned To', $this->dataset);
$column->SetOrderable(true);
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$result->AddViewColumn($column);
//
// View column for date_start field
//
$column = new DateTimeViewColumn('date_start', 'Date Start', $this->dataset);
$column->SetDateTimeFormat('Y-m-d');
$column->SetOrderable(true);
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$result->AddViewColumn($column);
//
// View column for date_end field
//
$column = new DateTimeViewColumn('date_end', 'Date End', $this->dataset);
$column->SetDateTimeFormat('Y-m-d');
$column->SetOrderable(true);
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$result->AddViewColumn($column);
//
// View column for project_id field
//
$column = new TextViewColumn('project_id', 'Project', $this->dataset);
$column->SetOrderable(true);
$column = new ExtendedHyperLinkColumnDecorator($column, $this->dataset, 'project.php?operation=view&pk0=%project_id%', '');
$result->AddPrintColumn($column);
//
// View column for task_name field
//
$column = new TextViewColumn('task_name', 'Task Name', $this->dataset);
$column->SetOrderable(true);
$result->AddPrintColumn($column);
//
// View column for notes field
//
$column = new TextViewColumn('notes', 'Notes', $this->dataset);
$column->SetOrderable(true);
$result->AddPrintColumn($column);
//
// View column for hrs field
//
$column = new TextViewColumn('hrs', 'Allocated Hours', $this->dataset);
$column->SetOrderable(true);
$column = new NumberFormatValueViewColumnDecorator($column, 2, ',', '.');
$result->AddPrintColumn($column);
//
// View column for assigned_to field
//
$column = new TextViewColumn('assigned_to', 'Assigned To', $this->dataset);
$column->SetOrderable(true);
$result->AddPrintColumn($column);
//
// View column for date_start field
//
$column = new DateTimeViewColumn('date_start', 'Date Start', $this->dataset);
$column->SetDateTimeFormat('Y-m-d');
$column->SetOrderable(true);
$result->AddPrintColumn($column);
//
// View column for date_end field
//
$column = new DateTimeViewColumn('date_end', 'Date End', $this->dataset);
$column->SetDateTimeFormat('Y-m-d');
$column->SetOrderable(true);
$result->AddPrintColumn($column);
return $result;
}
protected function AddFieldColumns(Grid $grid)
{
//
// View column for cli-ragsoc field
//
$column = new TextViewColumn('sco-codcli_cli-ragsoc', 'Codice cliente', $this->dataset);
$column->SetOrderable(true);
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$grid->AddViewColumn($column);
//
// View column for descrizione field
//
$column = new TextViewColumn('sco-codart_descrizione', 'Codice articolo', $this->dataset);
$column->SetOrderable(true);
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$grid->AddViewColumn($column);
//
// View column for sco-codvoc field
//
$column = new TextViewColumn('sco-codvoc', 'Codice tipo voce', $this->dataset);
$column->SetOrderable(true);
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$grid->AddViewColumn($column);
//
// View column for sco-sconto field
//
$column = new TextViewColumn('sco-sconto', 'Sconto', $this->dataset);
$column->SetOrderable(true);
$column = new NumberFormatValueViewColumnDecorator($column, 2, '.', ',');
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$grid->AddViewColumn($column);
}
protected function AddFieldColumns(Grid $grid)
{
//
// View column for Fecha field
//
$column = new TextViewColumn('Fecha', 'Fecha', $this->dataset);
$column->SetOrderable(true);
$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->SetMaxLength(75);
$column->SetFullTextWindowHandlerName('dbo_TamanoBaseDatosGrid_Nombre_handler_list');
$column->setMinimalVisibility(ColumnVisibility::PHONE);
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$grid->AddViewColumn($column);
//
// View column for TamanobdMB field
//
$column = new TextViewColumn('TamanobdMB', 'TamanobdMB', $this->dataset);
$column->SetOrderable(true);
$column = new NumberFormatValueViewColumnDecorator($column, 4, ',', '.');
$column->setMinimalVisibility(ColumnVisibility::PHONE);
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$grid->AddViewColumn($column);
//
// View column for LogbdMB field
//
$column = new TextViewColumn('LogbdMB', 'LogbdMB', $this->dataset);
$column->SetOrderable(true);
$column = new NumberFormatValueViewColumnDecorator($column, 4, ',', '.');
$column->setMinimalVisibility(ColumnVisibility::PHONE);
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$grid->AddViewColumn($column);
//
// View column for TotalbdMB field
//
$column = new TextViewColumn('TotalbdMB', 'TotalbdMB', $this->dataset);
$column->SetOrderable(true);
$column = new NumberFormatValueViewColumnDecorator($column, 4, ',', '.');
$column->setMinimalVisibility(ColumnVisibility::PHONE);
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$grid->AddViewColumn($column);
//
// View column for TamanobdGB field
//
$column = new TextViewColumn('TamanobdGB', 'TamanobdGB', $this->dataset);
$column->SetOrderable(true);
$column = new NumberFormatValueViewColumnDecorator($column, 4, ',', '.');
$column->setMinimalVisibility(ColumnVisibility::PHONE);
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$grid->AddViewColumn($column);
//
// View column for LogbdGB field
//
$column = new TextViewColumn('LogbdGB', 'LogbdGB', $this->dataset);
$column->SetOrderable(true);
$column = new NumberFormatValueViewColumnDecorator($column, 4, ',', '.');
$column->setMinimalVisibility(ColumnVisibility::PHONE);
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$grid->AddViewColumn($column);
//
// View column for TotalbdGB field
//
$column = new TextViewColumn('TotalbdGB', 'TotalbdGB', $this->dataset);
$column->SetOrderable(true);
$column = new NumberFormatValueViewColumnDecorator($column, 4, ',', '.');
$column->setMinimalVisibility(ColumnVisibility::PHONE);
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$grid->AddViewColumn($column);
}
protected function AddFieldColumns(Grid $grid)
{
//
// View column for program_name field
//
$column = new TextViewColumn('programm_id_program_name', 'Project Type', $this->dataset);
$column->SetOrderable(true);
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$grid->AddViewColumn($column);
//
// View column for project_name field
//
$column = new TextViewColumn('project_name', 'Project Name', $this->dataset);
$column->SetOrderable(true);
$column->SetMaxLength(75);
$column->SetFullTextWindowHandlerName('project_admin_viewGrid_project_name_handler_list');
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$grid->AddViewColumn($column);
//
// View column for date_start field
//
$column = new DateTimeViewColumn('date_start', 'Date Start', $this->dataset);
$column->SetDateTimeFormat('Y-m-d');
$column->SetOrderable(true);
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$grid->AddViewColumn($column);
//
// View column for date_end field
//
$column = new DateTimeViewColumn('date_end', 'Date End', $this->dataset);
$column->SetDateTimeFormat('Y-m-d');
$column->SetOrderable(true);
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$grid->AddViewColumn($column);
//
// View column for approved_budget field
//
$column = new TextViewColumn('approved_budget', 'Approved Budget', $this->dataset);
$column->SetOrderable(true);
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$grid->AddViewColumn($column);
//
// View column for budget_spent field
//
$column = new TextViewColumn('budget_spent', 'Budget Spent', $this->dataset);
$column->SetOrderable(true);
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$grid->AddViewColumn($column);
//
// View column for notes field
//
$column = new TextViewColumn('notes', 'Objectives', $this->dataset);
$column->SetOrderable(true);
$column->SetMaxLength(75);
$column->SetFullTextWindowHandlerName('project_admin_viewGrid_notes_handler_list');
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$grid->AddViewColumn($column);
//
// View column for Name field
//
$column = new TextViewColumn('priority_Name', 'Priority', $this->dataset);
$column->SetOrderable(true);
$column->SetMaxLength(75);
$column->SetFullTextWindowHandlerName('project_admin_viewGrid_Name_handler_list');
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$grid->AddViewColumn($column);
//
// View column for username field
//
$column = new TextViewColumn('lead_username', 'Project Lead', $this->dataset);
$column->SetOrderable(true);
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$grid->AddViewColumn($column);
//
// View column for level_of_service field
//
$column = new TextViewColumn('level_of_service', 'Level Of Service', $this->dataset);
$column->SetOrderable(true);
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$grid->AddViewColumn($column);
//
// View column for multi_year field
//
$column = new TextViewColumn('multi_year', 'Multi Year', $this->dataset);
$column->SetOrderable(true);
$column = new CheckBoxFormatValueViewColumnDecorator($column);
$column->SetDisplayValues($this->RenderText('<img src="images/checked.png" alt="true">'), $this->RenderText(''));
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$grid->AddViewColumn($column);
//
// View column for public_engagement field
//
$column = new TextViewColumn('public_engagement', 'Public Engagement', $this->dataset);
$column->SetOrderable(true);
$column->SetMaxLength(75);
$column->SetFullTextWindowHandlerName('project_admin_viewGrid_public_engagement_handler_list');
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$grid->AddViewColumn($column);
//
// View column for year field
//
$column = new TextViewColumn('year', 'Year', $this->dataset);
$column->SetOrderable(true);
$column->SetMaxLength(4);
$column->SetFullTextWindowHandlerName('project_admin_viewGrid_year_handler_list');
$column = new NumberFormatValueViewColumnDecorator($column, 0, '', '');
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$grid->AddViewColumn($column);
//
// View column for approved field
//
$column = new TextViewColumn('approved', 'Approved by CAO', $this->dataset);
$column->SetOrderable(true);
$column = new CheckBoxFormatValueViewColumnDecorator($column);
$column->SetDisplayValues($this->RenderText('<img src="images/checked.png" alt="true">'), $this->RenderText(''));
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$grid->AddViewColumn($column);
//
// View column for progress field
//
$column = new TextViewColumn('progress', 'Progress', $this->dataset);
$column->SetOrderable(true);
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$grid->AddViewColumn($column);
//
// View column for DEPARTMENT field
//
$column = new TextViewColumn('dept_id_DEPARTMENT', 'Department', $this->dataset);
$column->SetOrderable(true);
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$grid->AddViewColumn($column);
}
protected function AddFieldColumns(Grid $grid)
{
//
// View column for name field
//
$column = new TextViewColumn('name', 'Name', $this->dataset);
$column->SetOrderable(true);
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$grid->AddViewColumn($column);
//
// View column for total_hours field
//
$column = new TextViewColumn('total_hours', 'Total Hours', $this->dataset);
$grid->SetTotal($column, PredefinedAggregate::$Sum);
$column->SetOrderable(true);
$column = new NumberFormatValueViewColumnDecorator($column, 2, ',', '.');
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$grid->AddViewColumn($column);
//
// View column for date field
//
$column = new DateTimeViewColumn('date', 'Date', $this->dataset);
$column->SetDateTimeFormat('Y-m-d');
$column->SetOrderable(true);
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$grid->AddViewColumn($column);
//
// View column for task_name field
//
$column = new TextViewColumn('task_id_task_name', 'Task Id', $this->dataset);
$column->SetOrderable(true);
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$grid->AddViewColumn($column);
//
// View column for notes field
//
$column = new TextViewColumn('notes', 'Notes', $this->dataset);
$column->SetOrderable(true);
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$grid->AddViewColumn($column);
}
protected function AddFieldColumns(Grid $grid)
{
//
// View column for title field
//
$column = new TextViewColumn('title', 'Office Title', $this->dataset);
$column->SetOrderable(true);
/* <inline edit column> */
//
// Edit column for title field
//
$editor = new TextEdit('title_edit');
$editor->SetSize(35);
$editor->SetMaxLength(35);
$editColumn = new CustomEditColumn('Office Title', 'title', $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 title field
//
$editor = new TextEdit('title_edit');
$editor->SetSize(35);
$editor->SetMaxLength(35);
$editColumn = new CustomEditColumn('Office Title', 'title', $editor, $this->dataset);
$validator = new RequiredValidator(StringUtils::Format($this->GetLocalizerCaptions()->GetMessageString('RequiredValidationMessage'), $this->RenderText($editColumn->GetCaption())));
$editor->GetValidatorCollection()->AddValidator($validator);
$this->ApplyCommonColumnEditProperties($editColumn);
$column->SetInsertOperationColumn($editColumn);
/* </inline insert column> */
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$grid->AddViewColumn($column);
//
// View column for num_positions field
//
$column = new TextViewColumn('num_positions', 'Number of Positions Available', $this->dataset);
$column->SetOrderable(true);
/* <inline edit column> */
//
// Edit column for num_positions field
//
$editor = new TextEdit('num_positions_edit');
$editColumn = new CustomEditColumn('Number of Positions Available', 'num_positions', $editor, $this->dataset);
$editColumn->SetAllowSetToNull(true);
$this->ApplyCommonColumnEditProperties($editColumn);
$column->SetEditOperationColumn($editColumn);
/* </inline edit column> */
/* <inline insert column> */
//
// Edit column for num_positions field
//
$editor = new TextEdit('num_positions_edit');
$editColumn = new CustomEditColumn('Number of Positions Available', 'num_positions', $editor, $this->dataset);
$editColumn->SetAllowSetToNull(true);
$this->ApplyCommonColumnEditProperties($editColumn);
$column->SetInsertOperationColumn($editColumn);
/* </inline insert column> */
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$grid->AddViewColumn($column);
//
// View column for responsibilities field
//
$column = new TextViewColumn('responsibilities', 'Responsibilities', $this->dataset);
$column->SetOrderable(true);
$column->SetMaxLength(75);
$column->SetFullTextWindowHandlerName('public_officeGrid_responsibilities_handler_list');
/* <inline edit column> */
//
// Edit column for responsibilities field
//
$editor = new TextAreaEdit('responsibilities_edit', 50, 8);
$editColumn = new CustomEditColumn('Responsibilities', 'responsibilities', $editor, $this->dataset);
$editColumn->SetAllowSetToNull(true);
$this->ApplyCommonColumnEditProperties($editColumn);
$column->SetEditOperationColumn($editColumn);
/* </inline edit column> */
/* <inline insert column> */
//
// Edit column for responsibilities field
//
$editor = new TextAreaEdit('responsibilities_edit', 50, 8);
$editColumn = new CustomEditColumn('Responsibilities', 'responsibilities', $editor, $this->dataset);
$editColumn->SetAllowSetToNull(true);
$this->ApplyCommonColumnEditProperties($editColumn);
$column->SetInsertOperationColumn($editColumn);
/* </inline insert column> */
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$grid->AddViewColumn($column);
//
// View column for term_length_months field
//
$column = new TextViewColumn('term_length_months', 'Term Length in Months', $this->dataset);
$column->SetOrderable(true);
/* <inline edit column> */
//
// Edit column for term_length_months field
//
$editor = new TextEdit('term_length_months_edit');
$editColumn = new CustomEditColumn('Term Length in Months', 'term_length_months', $editor, $this->dataset);
$editColumn->SetAllowSetToNull(true);
$this->ApplyCommonColumnEditProperties($editColumn);
$column->SetEditOperationColumn($editColumn);
/* </inline edit column> */
/* <inline insert column> */
//
// Edit column for term_length_months field
//
$editor = new TextEdit('term_length_months_edit');
$editColumn = new CustomEditColumn('Term Length in Months', 'term_length_months', $editor, $this->dataset);
$editColumn->SetAllowSetToNull(true);
$this->ApplyCommonColumnEditProperties($editColumn);
$column->SetInsertOperationColumn($editColumn);
/* </inline insert column> */
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$grid->AddViewColumn($column);
//
// View column for filing_fee field
//
$column = new TextViewColumn('filing_fee', 'Filing Fee', $this->dataset);
$column->SetOrderable(true);
$column->SetMaxLength(75);
$column->SetFullTextWindowHandlerName('public_officeGrid_filing_fee_handler_list');
/* <inline edit column> */
//
// Edit column for filing_fee field
//
$editor = new TextAreaEdit('filing_fee_edit', 50, 8);
$editColumn = new CustomEditColumn('Filing Fee', 'filing_fee', $editor, $this->dataset);
$editColumn->SetAllowSetToNull(true);
$this->ApplyCommonColumnEditProperties($editColumn);
$column->SetEditOperationColumn($editColumn);
/* </inline edit column> */
/* <inline insert column> */
//
// Edit column for filing_fee field
//
$editor = new TextAreaEdit('filing_fee_edit', 50, 8);
$editColumn = new CustomEditColumn('Filing Fee', 'filing_fee', $editor, $this->dataset);
$editColumn->SetAllowSetToNull(true);
$this->ApplyCommonColumnEditProperties($editColumn);
$column->SetInsertOperationColumn($editColumn);
/* </inline insert column> */
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$grid->AddViewColumn($column);
//
// View column for partisan field
//
$column = new TextViewColumn('partisan', 'Partisan Position', $this->dataset);
$column->SetOrderable(true);
/* <inline edit column> */
//
// Edit column for partisan field
//
$editor = new CheckBox('partisan_edit');
$editColumn = new CustomEditColumn('Partisan Position', 'partisan', $editor, $this->dataset);
$editColumn->SetAllowSetToNull(true);
$this->ApplyCommonColumnEditProperties($editColumn);
$column->SetEditOperationColumn($editColumn);
/* </inline edit column> */
/* <inline insert column> */
//
// Edit column for partisan field
//
$editor = new CheckBox('partisan_edit');
$editColumn = new CustomEditColumn('Partisan Position', 'partisan', $editor, $this->dataset);
$editColumn->SetAllowSetToNull(true);
$this->ApplyCommonColumnEditProperties($editColumn);
$column->SetInsertOperationColumn($editColumn);
/* </inline insert column> */
$column = new CheckBoxFormatValueViewColumnDecorator($column);
$column->SetDisplayValues($this->RenderText('<img src="images/checked.png" alt="true">'), $this->RenderText(''));
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$grid->AddViewColumn($column);
//
// View column for age_requirements field
//
$column = new TextViewColumn('age_requirements', 'Age Requirements', $this->dataset);
$column->SetOrderable(true);
/* <inline edit column> */
//
// Edit column for age_requirements field
//
$editor = new TextEdit('age_requirements_edit');
$editColumn = new CustomEditColumn('Age Requirements', 'age_requirements', $editor, $this->dataset);
$editColumn->SetAllowSetToNull(true);
$this->ApplyCommonColumnEditProperties($editColumn);
$column->SetEditOperationColumn($editColumn);
/* </inline edit column> */
/* <inline insert column> */
//
// Edit column for age_requirements field
//
$editor = new TextEdit('age_requirements_edit');
$editColumn = new CustomEditColumn('Age Requirements', 'age_requirements', $editor, $this->dataset);
$editColumn->SetAllowSetToNull(true);
$this->ApplyCommonColumnEditProperties($editColumn);
$column->SetInsertOperationColumn($editColumn);
/* </inline insert column> */
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$grid->AddViewColumn($column);
//
// View column for res_requirements field
//
$column = new TextViewColumn('res_requirements', 'Residency Requirements', $this->dataset);
$column->SetOrderable(true);
$column->SetMaxLength(75);
$column->SetFullTextWindowHandlerName('public_officeGrid_res_requirements_handler_list');
/* <inline edit column> */
//
// Edit column for res_requirements field
//
$editor = new TextAreaEdit('res_requirements_edit', 50, 8);
$editColumn = new CustomEditColumn('Residency Requirements', 'res_requirements', $editor, $this->dataset);
$editColumn->SetAllowSetToNull(true);
$this->ApplyCommonColumnEditProperties($editColumn);
$column->SetEditOperationColumn($editColumn);
/* </inline edit column> */
/* <inline insert column> */
//
// Edit column for res_requirements field
//
$editor = new TextAreaEdit('res_requirements_edit', 50, 8);
$editColumn = new CustomEditColumn('Residency Requirements', 'res_requirements', $editor, $this->dataset);
$editColumn->SetAllowSetToNull(true);
$this->ApplyCommonColumnEditProperties($editColumn);
$column->SetInsertOperationColumn($editColumn);
/* </inline insert column> */
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$grid->AddViewColumn($column);
//
// View column for prof_requirements field
//
$column = new TextViewColumn('prof_requirements', 'Professional Requirements', $this->dataset);
$column->SetOrderable(true);
$column->SetMaxLength(75);
$column->SetFullTextWindowHandlerName('public_officeGrid_prof_requirements_handler_list');
/* <inline edit column> */
//
// Edit column for prof_requirements field
//
$editor = new TextAreaEdit('prof_requirements_edit', 50, 8);
$editColumn = new CustomEditColumn('Professional Requirements', 'prof_requirements', $editor, $this->dataset);
$editColumn->SetAllowSetToNull(true);
$this->ApplyCommonColumnEditProperties($editColumn);
$column->SetEditOperationColumn($editColumn);
/* </inline edit column> */
/* <inline insert column> */
//
// Edit column for prof_requirements field
//
$editor = new TextAreaEdit('prof_requirements_edit', 50, 8);
$editColumn = new CustomEditColumn('Professional Requirements', 'prof_requirements', $editor, $this->dataset);
$editColumn->SetAllowSetToNull(true);
$this->ApplyCommonColumnEditProperties($editColumn);
$column->SetInsertOperationColumn($editColumn);
/* </inline insert column> */
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$grid->AddViewColumn($column);
//
// View column for salary field
//
$column = new TextViewColumn('salary', 'Salary', $this->dataset);
$column->SetOrderable(true);
/* <inline edit column> */
//
// Edit column for salary field
//
$editor = new TextEdit('salary_edit');
$editColumn = new CustomEditColumn('Salary', 'salary', $editor, $this->dataset);
$editColumn->SetAllowSetToNull(true);
$this->ApplyCommonColumnEditProperties($editColumn);
$column->SetEditOperationColumn($editColumn);
/* </inline edit column> */
/* <inline insert column> */
//
// Edit column for salary field
//
$editor = new TextEdit('salary_edit');
$editColumn = new CustomEditColumn('Salary', 'salary', $editor, $this->dataset);
$editColumn->SetAllowSetToNull(true);
$this->ApplyCommonColumnEditProperties($editColumn);
$column->SetInsertOperationColumn($editColumn);
/* </inline insert column> */
$column = new NumberFormatValueViewColumnDecorator($column, 0, ',', '.');
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$grid->AddViewColumn($column);
//
// View column for notes field
//
$column = new TextViewColumn('notes', 'Notes', $this->dataset);
$column->SetOrderable(true);
$column->SetMaxLength(75);
$column->SetFullTextWindowHandlerName('public_officeGrid_notes_handler_list');
/* <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> */
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$grid->AddViewColumn($column);
//
// View column for office_rank field
//
$column = new TextViewColumn('office_rank', 'Office Rank', $this->dataset);
$column->SetOrderable(true);
/* <inline edit column> */
//
// Edit column for office_rank field
//
$editor = new TextEdit('office_rank_edit');
$editColumn = new CustomEditColumn('Office Rank', 'office_rank', $editor, $this->dataset);
$editColumn->SetAllowSetToNull(true);
$this->ApplyCommonColumnEditProperties($editColumn);
$column->SetEditOperationColumn($editColumn);
/* </inline edit column> */
/* <inline insert column> */
//
// Edit column for office_rank field
//
$editor = new TextEdit('office_rank_edit');
$editColumn = new CustomEditColumn('Office Rank', 'office_rank', $editor, $this->dataset);
$editColumn->SetAllowSetToNull(true);
$this->ApplyCommonColumnEditProperties($editColumn);
$column->SetInsertOperationColumn($editColumn);
/* </inline insert column> */
$column->SetDescription($this->RenderText('For sorting purposes, lower value = higher rank'));
$column->SetFixedWidth(null);
$grid->AddViewColumn($column);
}
protected function AddFieldColumns(Grid $grid)
{
//
// View column for project_id field
//
$column = new TextViewColumn('project_id', 'Project Id', $this->dataset);
$column->SetOrderable(true);
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$grid->AddViewColumn($column);
//
// View column for project_type field
//
$column = new TextViewColumn('project_type', 'Project Type', $this->dataset);
$column->SetOrderable(true);
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$grid->AddViewColumn($column);
//
// View column for project_name field
//
$column = new TextViewColumn('project_name', 'Project Name', $this->dataset);
$column->SetOrderable(true);
$column->SetMaxLength(75);
$column->SetFullTextWindowHandlerName('ProjectViewGrid_project_name_handler_list');
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$grid->AddViewColumn($column);
//
// View column for date_start field
//
$column = new DateTimeViewColumn('date_start', 'Date Start', $this->dataset);
$column->SetDateTimeFormat('Y-m-d H:i:s');
$column->SetOrderable(true);
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$grid->AddViewColumn($column);
//
// View column for date_end field
//
$column = new DateTimeViewColumn('date_end', 'Date End', $this->dataset);
$column->SetDateTimeFormat('Y-m-d H:i:s');
$column->SetOrderable(true);
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$grid->AddViewColumn($column);
//
// View column for year field
//
$column = new TextViewColumn('year', 'Year', $this->dataset);
$column->SetOrderable(true);
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$grid->AddViewColumn($column);
//
// View column for Objective field
//
$column = new TextViewColumn('Objective', 'Objective', $this->dataset);
$column->SetOrderable(true);
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$grid->AddViewColumn($column);
//
// View column for priority field
//
$column = new TextViewColumn('priority', 'Priority', $this->dataset);
$column->SetOrderable(true);
$column->SetMaxLength(75);
$column->SetFullTextWindowHandlerName('ProjectViewGrid_priority_handler_list');
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$grid->AddViewColumn($column);
//
// View column for project_lead field
//
$column = new TextViewColumn('project_lead', 'Project Lead', $this->dataset);
$column->SetOrderable(true);
$column->SetMaxLength(75);
$column->SetFullTextWindowHandlerName('ProjectViewGrid_project_lead_handler_list');
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$grid->AddViewColumn($column);
//
// View column for approved_budget field
//
$column = new TextViewColumn('approved_budget', 'Approved Budget', $this->dataset);
$column->SetOrderable(true);
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$grid->AddViewColumn($column);
//
// View column for budget_spent field
//
$column = new TextViewColumn('budget_spent', 'Budget Spent', $this->dataset);
$column->SetOrderable(true);
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$grid->AddViewColumn($column);
//
// View column for multi_year field
//
$column = new TextViewColumn('multi_year', 'Multi Year', $this->dataset);
$column->SetOrderable(true);
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$grid->AddViewColumn($column);
//
// View column for public_engagement field
//
$column = new TextViewColumn('public_engagement', 'Public Engagement', $this->dataset);
$column->SetOrderable(true);
$column->SetMaxLength(75);
$column->SetFullTextWindowHandlerName('ProjectViewGrid_public_engagement_handler_list');
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$grid->AddViewColumn($column);
//
// View column for level_of_service field
//
$column = new TextViewColumn('level_of_service', 'Level Of Service', $this->dataset);
$column->SetOrderable(true);
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$grid->AddViewColumn($column);
//
// View column for approved_by_cao field
//
$column = new TextViewColumn('approved_by_cao', 'Approved By Cao', $this->dataset);
$column->SetOrderable(true);
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$grid->AddViewColumn($column);
//
// View column for progress field
//
$column = new TextViewColumn('progress', 'Progress', $this->dataset);
$column->SetOrderable(true);
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$grid->AddViewColumn($column);
//
// View column for DEPARTMENT field
//
$column = new TextViewColumn('DEPARTMENT', 'DEPARTMENT', $this->dataset);
$column->SetOrderable(true);
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$grid->AddViewColumn($column);
//
// View column for total_hours field
//
$column = new TextViewColumn('total_hours', 'Total Hours', $this->dataset);
$column->SetOrderable(true);
$column = new NumberFormatValueViewColumnDecorator($column, 2, ',', '.');
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$grid->AddViewColumn($column);
//
// View column for assigned_hours field
//
$column = new TextViewColumn('assigned_hours', 'Assigned Hours', $this->dataset);
$column->SetOrderable(true);
$column = new NumberFormatValueViewColumnDecorator($column, 2, ',', '.');
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$grid->AddViewColumn($column);
//
// View column for assigned_progress field
//
$column = new TextViewColumn('assigned_progress', 'Assigned Progress', $this->dataset);
$column->SetOrderable(true);
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$grid->AddViewColumn($column);
}
protected function AddFieldColumns(Grid $grid)
{
//
// View column for descrizione field
//
$column = new TextViewColumn('ivo-codart_descrizione', 'Codice Articolo', $this->dataset);
$column->SetOrderable(true);
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$grid->AddViewColumn($column);
//
// View column for voc-descriz field
//
$column = new TextViewColumn('ivo-codvoc_voc-descriz', 'Codice Tipo Voce', $this->dataset);
$column->SetOrderable(true);
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$grid->AddViewColumn($column);
//
// View column for ivo-przunit field
//
$column = new TextViewColumn('ivo-przunit', 'Prezzo unitario', $this->dataset);
$column->SetOrderable(true);
$column = new NumberFormatValueViewColumnDecorator($column, 2, '.', ',');
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$grid->AddViewColumn($column);
//
// View column for ivo-flagart field
//
$column = new TextViewColumn('ivo-flagart', 'Altro articolo', $this->dataset);
$column->SetOrderable(true);
$column = new CheckBoxFormatValueViewColumnDecorator($column);
$column->SetDisplayValues($this->RenderText('<img src="images/checked.png" alt="true">'), $this->RenderText(''));
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$grid->AddViewColumn($column);
//
// View column for ivo-flagsmu field
//
$column = new TextViewColumn('ivo-flagsmu', 'Prevede smusso', $this->dataset);
$column->SetOrderable(true);
$column = new CheckBoxFormatValueViewColumnDecorator($column);
$column->SetDisplayValues($this->RenderText('<img src="images/checked.png" alt="true">'), $this->RenderText(''));
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$grid->AddViewColumn($column);
//
// View column for ivo-dataini field
//
$column = new DateTimeViewColumn('ivo-dataini', 'Data decorrenza listino', $this->dataset);
$column->SetDateTimeFormat('d-m-Y');
$column->SetOrderable(true);
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$grid->AddViewColumn($column);
//
// View column for ivo-datafin field
//
$column = new DateTimeViewColumn('ivo-datafin', 'Data fine decorrenza listino', $this->dataset);
$column->SetDateTimeFormat('d-m-Y');
$column->SetOrderable(true);
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$grid->AddViewColumn($column);
}
protected function AddFieldColumns(Grid $grid)
{
//
// View column for id field
//
$column = new TextViewColumn('id', 'Id', $this->dataset);
$column->SetOrderable(true);
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$grid->AddViewColumn($column);
//
// View column for ofv-numoff field
//
$column = new TextViewColumn('ofv-numoff', 'Ofv-numoff', $this->dataset);
$column->SetOrderable(true);
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$grid->AddViewColumn($column);
//
// View column for ofv-codvoce field
//
$column = new TextViewColumn('ofv-codvoce', 'Ofv-codvoce', $this->dataset);
$column->SetOrderable(true);
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$grid->AddViewColumn($column);
//
// View column for ofv-quantita field
//
$column = new TextViewColumn('ofv-quantita', 'Ofv-quantita', $this->dataset);
$column->SetOrderable(true);
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$grid->AddViewColumn($column);
//
// View column for ofv-lunghezza field
//
$column = new TextViewColumn('ofv-lunghezza', 'Ofv-lunghezza', $this->dataset);
$column->SetOrderable(true);
$column = new NumberFormatValueViewColumnDecorator($column, 2, '.', ',');
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$grid->AddViewColumn($column);
//
// View column for ofv-larghezza field
//
$column = new TextViewColumn('ofv-larghezza', 'Ofv-larghezza', $this->dataset);
$column->SetOrderable(true);
$column = new NumberFormatValueViewColumnDecorator($column, 2, '.', ',');
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$grid->AddViewColumn($column);
//
// View column for ofv-tiposmu field
//
$column = new TextViewColumn('ofv-tiposmu', 'Ofv-tiposmu', $this->dataset);
$column->SetOrderable(true);
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$grid->AddViewColumn($column);
//
// View column for ofv-przacq field
//
$column = new TextViewColumn('ofv-przacq', 'Ofv-przacq', $this->dataset);
$column->SetOrderable(true);
$column = new NumberFormatValueViewColumnDecorator($column, 2, '.', ',');
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$grid->AddViewColumn($column);
//
// View column for ofv-sconto field
//
$column = new TextViewColumn('ofv-sconto', 'Ofv-sconto', $this->dataset);
$column->SetOrderable(true);
$column = new NumberFormatValueViewColumnDecorator($column, 2, '.', ',');
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$grid->AddViewColumn($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, '.', ',');
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$grid->AddViewColumn($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, '.', ',');
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$grid->AddViewColumn($column);
//
// View column for datains field
//
$column = new DateTimeViewColumn('datains', 'Datains', $this->dataset);
$column->SetDateTimeFormat('d-m-Y H:i:s');
$column->SetOrderable(true);
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$grid->AddViewColumn($column);
//
// View column for datamod field
//
$column = new DateTimeViewColumn('datamod', 'Datamod', $this->dataset);
$column->SetDateTimeFormat('d-m-Y H:i:s');
$column->SetOrderable(true);
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$grid->AddViewColumn($column);
}
protected function AddFieldColumns(Grid $grid)
{
//
// View column for idCartera field
//
$column = new TextViewColumn('idCartera', 'IdCartera', $this->dataset);
$column->SetOrderable(true);
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$grid->AddViewColumn($column);
//
// View column for RazonSocial field
//
$column = new TextViewColumn('Cliente_RazonSocial', 'Cliente', $this->dataset);
$column->SetOrderable(true);
/* <inline edit column> */
//
// Edit column for Cliente field
//
$editor = new AutocomleteComboBox('cliente_edit', $this->CreateLinkBuilder());
$editor->SetSize('250px');
$lookupDataset = new TableDataset(new MyConnectionFactory(), GetConnectionOptions(), '`clientes`');
$field = new IntegerField('idClientes', null, null, true);
$field->SetIsNotNull(true);
$lookupDataset->AddField($field, true);
$field = new IntegerField('Tipo_Documento');
$field->SetIsNotNull(true);
$lookupDataset->AddField($field, false);
$field = new StringField('Num_Identificacion');
$lookupDataset->AddField($field, false);
$field = new IntegerField('DV');
$field->SetIsNotNull(true);
$lookupDataset->AddField($field, false);
$field = new StringField('Primer_Apellido');
$field->SetIsNotNull(true);
$lookupDataset->AddField($field, false);
$field = new StringField('Segundo_Apellido');
$field->SetIsNotNull(true);
$lookupDataset->AddField($field, false);
$field = new StringField('Primer_Nombre');
$field->SetIsNotNull(true);
$lookupDataset->AddField($field, false);
$field = new StringField('Otros_Nombres');
$field->SetIsNotNull(true);
$lookupDataset->AddField($field, false);
$field = new StringField('RazonSocial');
$lookupDataset->AddField($field, false);
$field = new StringField('Direccion');
$lookupDataset->AddField($field, false);
$field = new StringField('Cod_Dpto');
$field->SetIsNotNull(true);
$lookupDataset->AddField($field, false);
$field = new StringField('Cod_Mcipio');
$field->SetIsNotNull(true);
$lookupDataset->AddField($field, false);
$field = new StringField('Pais_Domicilio');
$field->SetIsNotNull(true);
$lookupDataset->AddField($field, false);
$field = new StringField('Telefono');
$lookupDataset->AddField($field, false);
$field = new StringField('Ciudad');
$field->SetIsNotNull(true);
$lookupDataset->AddField($field, false);
$field = new StringField('Contacto');
$field->SetIsNotNull(true);
$lookupDataset->AddField($field, false);
$field = new StringField('TelContacto');
$field->SetIsNotNull(true);
$lookupDataset->AddField($field, false);
$field = new StringField('Email');
$field->SetIsNotNull(true);
$lookupDataset->AddField($field, false);
$field = new IntegerField('CIUU');
$field->SetIsNotNull(true);
$lookupDataset->AddField($field, false);
$field = new IntegerField('empresa_id');
$field->SetIsNotNull(true);
$lookupDataset->AddField($field, false);
$field = new StringField('codigo');
$field->SetIsNotNull(true);
$lookupDataset->AddField($field, false);
$field = new StringField('regimen');
$field->SetIsNotNull(true);
$lookupDataset->AddField($field, false);
$field = new StringField('estado');
$field->SetIsNotNull(true);
$lookupDataset->AddField($field, false);
$lookupDataset->SetOrderBy('RazonSocial', GetOrderTypeAsSQL(otAscending));
$editColumn = new DynamicLookupEditColumn('Cliente', 'Cliente', 'Cliente_RazonSocial', 'inline_edit_Cliente_RazonSocial_search', $editor, $this->dataset, $lookupDataset, 'idClientes', 'RazonSocial', '');
$editColumn->SetAllowSetToNull(true);
$this->ApplyCommonColumnEditProperties($editColumn);
$column->SetEditOperationColumn($editColumn);
/* </inline edit column> */
/* <inline insert column> */
//
// Edit column for Cliente field
//
$editor = new AutocomleteComboBox('cliente_edit', $this->CreateLinkBuilder());
$editor->SetSize('250px');
$lookupDataset = new TableDataset(new MyConnectionFactory(), GetConnectionOptions(), '`clientes`');
$field = new IntegerField('idClientes', null, null, true);
$field->SetIsNotNull(true);
$lookupDataset->AddField($field, true);
$field = new IntegerField('Tipo_Documento');
$field->SetIsNotNull(true);
$lookupDataset->AddField($field, false);
$field = new StringField('Num_Identificacion');
$lookupDataset->AddField($field, false);
$field = new IntegerField('DV');
$field->SetIsNotNull(true);
$lookupDataset->AddField($field, false);
$field = new StringField('Primer_Apellido');
$field->SetIsNotNull(true);
$lookupDataset->AddField($field, false);
$field = new StringField('Segundo_Apellido');
$field->SetIsNotNull(true);
$lookupDataset->AddField($field, false);
$field = new StringField('Primer_Nombre');
$field->SetIsNotNull(true);
$lookupDataset->AddField($field, false);
$field = new StringField('Otros_Nombres');
$field->SetIsNotNull(true);
$lookupDataset->AddField($field, false);
$field = new StringField('RazonSocial');
$lookupDataset->AddField($field, false);
$field = new StringField('Direccion');
$lookupDataset->AddField($field, false);
$field = new StringField('Cod_Dpto');
$field->SetIsNotNull(true);
$lookupDataset->AddField($field, false);
$field = new StringField('Cod_Mcipio');
$field->SetIsNotNull(true);
$lookupDataset->AddField($field, false);
$field = new StringField('Pais_Domicilio');
$field->SetIsNotNull(true);
$lookupDataset->AddField($field, false);
$field = new StringField('Telefono');
$lookupDataset->AddField($field, false);
$field = new StringField('Ciudad');
$field->SetIsNotNull(true);
$lookupDataset->AddField($field, false);
$field = new StringField('Contacto');
$field->SetIsNotNull(true);
$lookupDataset->AddField($field, false);
$field = new StringField('TelContacto');
$field->SetIsNotNull(true);
$lookupDataset->AddField($field, false);
$field = new StringField('Email');
$field->SetIsNotNull(true);
$lookupDataset->AddField($field, false);
$field = new IntegerField('CIUU');
$field->SetIsNotNull(true);
$lookupDataset->AddField($field, false);
$field = new IntegerField('empresa_id');
$field->SetIsNotNull(true);
$lookupDataset->AddField($field, false);
$field = new StringField('codigo');
$field->SetIsNotNull(true);
$lookupDataset->AddField($field, false);
$field = new StringField('regimen');
$field->SetIsNotNull(true);
$lookupDataset->AddField($field, false);
$field = new StringField('estado');
$field->SetIsNotNull(true);
$lookupDataset->AddField($field, false);
$lookupDataset->SetOrderBy('RazonSocial', GetOrderTypeAsSQL(otAscending));
$editColumn = new DynamicLookupEditColumn('Cliente', 'Cliente', 'Cliente_RazonSocial', 'inline_insert_Cliente_RazonSocial_search', $editor, $this->dataset, $lookupDataset, 'idClientes', 'RazonSocial', '');
$editColumn->SetAllowSetToNull(true);
$this->ApplyCommonColumnEditProperties($editColumn);
$column->SetInsertOperationColumn($editColumn);
/* </inline insert column> */
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$grid->AddViewColumn($column);
//
// View column for Telefono field
//
$column = new TextViewColumn('Telefono', 'Telefono', $this->dataset);
$column->SetOrderable(true);
/* <inline edit column> */
//
// Edit column for Telefono field
//
$editor = new TextEdit('telefono_edit');
$editor->SetSize(45);
$editor->SetMaxLength(45);
$editColumn = new CustomEditColumn('Telefono', 'Telefono', $editor, $this->dataset);
$validator = new RequiredValidator(StringUtils::Format($this->GetLocalizerCaptions()->GetMessageString('RequiredValidationMessage'), $this->RenderText($editColumn->GetCaption())));
$editor->GetValidatorCollection()->AddValidator($validator);
$this->ApplyCommonColumnEditProperties($editColumn);
$column->SetEditOperationColumn($editColumn);
/* </inline edit column> */
/* <inline insert column> */
//
// Edit column for Telefono field
//
$editor = new TextEdit('telefono_edit');
$editor->SetSize(45);
$editor->SetMaxLength(45);
$editColumn = new CustomEditColumn('Telefono', 'Telefono', $editor, $this->dataset);
$validator = new RequiredValidator(StringUtils::Format($this->GetLocalizerCaptions()->GetMessageString('RequiredValidationMessage'), $this->RenderText($editColumn->GetCaption())));
$editor->GetValidatorCollection()->AddValidator($validator);
$this->ApplyCommonColumnEditProperties($editColumn);
$column->SetInsertOperationColumn($editColumn);
/* </inline insert column> */
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$grid->AddViewColumn($column);
//
// View column for Contacto field
//
$column = new TextViewColumn('Contacto', 'Contacto', $this->dataset);
$column->SetOrderable(true);
/* <inline edit column> */
//
// Edit column for Contacto field
//
$editor = new TextEdit('contacto_edit');
$editor->SetSize(45);
$editor->SetMaxLength(45);
$editColumn = new CustomEditColumn('Contacto', 'Contacto', $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 Contacto field
//
$editor = new TextEdit('contacto_edit');
$editor->SetSize(45);
$editor->SetMaxLength(45);
$editColumn = new CustomEditColumn('Contacto', 'Contacto', $editor, $this->dataset);
$validator = new RequiredValidator(StringUtils::Format($this->GetLocalizerCaptions()->GetMessageString('RequiredValidationMessage'), $this->RenderText($editColumn->GetCaption())));
$editor->GetValidatorCollection()->AddValidator($validator);
$this->ApplyCommonColumnEditProperties($editColumn);
$column->SetInsertOperationColumn($editColumn);
/* </inline insert column> */
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$grid->AddViewColumn($column);
//
// View column for TelContacto field
//
$column = new TextViewColumn('TelContacto', 'TelContacto', $this->dataset);
$column->SetOrderable(true);
/* <inline edit column> */
//
// Edit column for TelContacto field
//
$editor = new TextEdit('telcontacto_edit');
$editor->SetSize(45);
$editor->SetMaxLength(45);
$editColumn = new CustomEditColumn('TelContacto', 'TelContacto', $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 TelContacto field
//
$editor = new TextEdit('telcontacto_edit');
$editor->SetSize(45);
$editor->SetMaxLength(45);
$editColumn = new CustomEditColumn('TelContacto', 'TelContacto', $editor, $this->dataset);
$validator = new RequiredValidator(StringUtils::Format($this->GetLocalizerCaptions()->GetMessageString('RequiredValidationMessage'), $this->RenderText($editColumn->GetCaption())));
$editor->GetValidatorCollection()->AddValidator($validator);
$this->ApplyCommonColumnEditProperties($editColumn);
$column->SetInsertOperationColumn($editColumn);
/* </inline insert column> */
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$grid->AddViewColumn($column);
//
// View column for Saldo field
//
$column = new TextViewColumn('Saldo', 'Saldo', $this->dataset);
$column->SetOrderable(true);
/* <inline edit column> */
//
// Edit column for Saldo field
//
$editor = new TextEdit('saldo_edit');
$editColumn = new CustomEditColumn('Saldo', 'Saldo', $editor, $this->dataset);
$editColumn->SetAllowSetToNull(true);
$this->ApplyCommonColumnEditProperties($editColumn);
$column->SetEditOperationColumn($editColumn);
/* </inline edit column> */
/* <inline insert column> */
//
// Edit column for Saldo field
//
$editor = new TextEdit('saldo_edit');
$editColumn = new CustomEditColumn('Saldo', 'Saldo', $editor, $this->dataset);
$editColumn->SetAllowSetToNull(true);
$this->ApplyCommonColumnEditProperties($editColumn);
$column->SetInsertOperationColumn($editColumn);
/* </inline insert column> */
$column = new NumberFormatValueViewColumnDecorator($column, 2, '', '.');
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$grid->AddViewColumn($column);
//
// View column for FechaVencimiento field
//
$column = new TextViewColumn('FechaVencimiento', 'FechaVencimiento', $this->dataset);
$column->SetOrderable(true);
/* <inline edit column> */
//
// Edit column for FechaVencimiento field
//
$editor = new TextEdit('fechavencimiento_edit');
$editor->SetSize(20);
$editor->SetMaxLength(20);
$editColumn = new CustomEditColumn('FechaVencimiento', 'FechaVencimiento', $editor, $this->dataset);
$editColumn->SetAllowSetToNull(true);
$this->ApplyCommonColumnEditProperties($editColumn);
$column->SetEditOperationColumn($editColumn);
/* </inline edit column> */
/* <inline insert column> */
//
// Edit column for FechaVencimiento field
//
$editor = new TextEdit('fechavencimiento_edit');
$editor->SetSize(20);
$editor->SetMaxLength(20);
$editColumn = new CustomEditColumn('FechaVencimiento', 'FechaVencimiento', $editor, $this->dataset);
$editColumn->SetAllowSetToNull(true);
$this->ApplyCommonColumnEditProperties($editColumn);
$column->SetInsertOperationColumn($editColumn);
/* </inline insert column> */
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$grid->AddViewColumn($column);
//
// View column for DiasCartera field
//
$column = new TextViewColumn('DiasCartera', 'DiasCartera', $this->dataset);
$column->SetOrderable(true);
/* <inline edit column> */
//
// Edit column for DiasCartera field
//
$editor = new TextEdit('diascartera_edit');
$editColumn = new CustomEditColumn('DiasCartera', 'DiasCartera', $editor, $this->dataset);
$editColumn->SetAllowSetToNull(true);
$this->ApplyCommonColumnEditProperties($editColumn);
$column->SetEditOperationColumn($editColumn);
/* </inline edit column> */
/* <inline insert column> */
//
// Edit column for DiasCartera field
//
$editor = new TextEdit('diascartera_edit');
$editColumn = new CustomEditColumn('DiasCartera', 'DiasCartera', $editor, $this->dataset);
$editColumn->SetAllowSetToNull(true);
$this->ApplyCommonColumnEditProperties($editColumn);
$column->SetInsertOperationColumn($editColumn);
/* </inline insert column> */
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$grid->AddViewColumn($column);
//
// View column for Observaciones field
//
$column = new TextViewColumn('Observaciones', 'Observaciones', $this->dataset);
$column->SetOrderable(true);
$column->SetMaxLength(75);
$column->SetFullTextWindowHandlerName('Observaciones_handler');
/* <inline edit column> */
//
// Edit column for Observaciones field
//
$editor = new TextAreaEdit('observaciones_edit', 50, 8);
$editColumn = new CustomEditColumn('Observaciones', 'Observaciones', $editor, $this->dataset);
$editColumn->SetAllowSetToNull(true);
$this->ApplyCommonColumnEditProperties($editColumn);
$column->SetEditOperationColumn($editColumn);
/* </inline edit column> */
/* <inline insert column> */
//
// Edit column for Observaciones field
//
$editor = new TextAreaEdit('observaciones_edit', 50, 8);
$editColumn = new CustomEditColumn('Observaciones', 'Observaciones', $editor, $this->dataset);
$editColumn->SetAllowSetToNull(true);
$this->ApplyCommonColumnEditProperties($editColumn);
$column->SetInsertOperationColumn($editColumn);
/* </inline insert column> */
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$grid->AddViewColumn($column);
//
// View column for Facturas_idFacturas field
//
$column = new TextViewColumn('Facturas_idFacturas', 'Facturas IdFacturas', $this->dataset);
$column->SetOrderable(true);
/* <inline edit column> */
//
// Edit column for Facturas_idFacturas field
//
$editor = new TextEdit('facturas_idfacturas_edit');
$editColumn = new CustomEditColumn('Facturas IdFacturas', 'Facturas_idFacturas', $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 Facturas_idFacturas field
//
$editor = new TextEdit('facturas_idfacturas_edit');
$editColumn = new CustomEditColumn('Facturas IdFacturas', 'Facturas_idFacturas', $editor, $this->dataset);
$validator = new RequiredValidator(StringUtils::Format($this->GetLocalizerCaptions()->GetMessageString('RequiredValidationMessage'), $this->RenderText($editColumn->GetCaption())));
$editor->GetValidatorCollection()->AddValidator($validator);
$this->ApplyCommonColumnEditProperties($editColumn);
$column->SetInsertOperationColumn($editColumn);
/* </inline insert column> */
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$grid->AddViewColumn($column);
}
protected function AddFieldColumns(Grid $grid)
{
//
// View column for id_periodicidad field
//
$column = new TextViewColumn('id_periodicidad', 'Id Periodicidad', $this->dataset);
$column->SetOrderable(true);
$column->SetDescription($this->RenderText('Identificador único de la periodicidad.'));
$column->SetFixedWidth(null);
$grid->AddViewColumn($column);
//
// View column for no_periodicidad field
//
$column = new TextViewColumn('no_periodicidad', 'Nombre Periodicidad', $this->dataset);
$column->SetOrderable(true);
$column->SetMaxLength(75);
$column->SetFullTextWindowHandlerName('public_sga_periodicidadGrid_no_periodicidad_handler_list');
$column->SetDescription($this->RenderText('Nombre de la periodicidad.'));
$column->SetFixedWidth(null);
$grid->AddViewColumn($column);
//
// View column for va_frecuencia field
//
$column = new TextViewColumn('va_frecuencia', 'Frecuencia', $this->dataset);
$column->SetOrderable(true);
$column = new NumberFormatValueViewColumnDecorator($column, 4, ',', '.');
$column->SetDescription($this->RenderText('Frecuencia (en días) de realización de la actividad.'));
$column->SetFixedWidth(null);
$grid->AddViewColumn($column);
}
protected function AddFieldColumns(Grid $grid)
{
//
// View column for task_id field
//
$column = new TextViewColumn('task_id', 'Task Id', $this->dataset);
$column->SetOrderable(true);
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$grid->AddViewColumn($column);
//
// View column for project_id field
//
$column = new TextViewColumn('project_id', 'Project Id', $this->dataset);
$column->SetOrderable(true);
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$grid->AddViewColumn($column);
//
// View column for assigned_to field
//
$column = new TextViewColumn('assigned_to', 'Assigned To', $this->dataset);
$column->SetOrderable(true);
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$grid->AddViewColumn($column);
//
// View column for date_start field
//
$column = new DateTimeViewColumn('date_start', 'Date Start', $this->dataset);
$column->SetDateTimeFormat('Y-m-d H:i:s');
$column->SetOrderable(true);
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$grid->AddViewColumn($column);
//
// View column for date_end field
//
$column = new DateTimeViewColumn('date_end', 'Date End', $this->dataset);
$column->SetDateTimeFormat('Y-m-d H:i:s');
$column->SetOrderable(true);
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$grid->AddViewColumn($column);
//
// View column for task_name field
//
$column = new TextViewColumn('task_name', 'Task Name', $this->dataset);
$column->SetOrderable(true);
$column->SetMaxLength(75);
$column->SetFullTextWindowHandlerName('taskviewGrid_task_name_handler_list');
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$grid->AddViewColumn($column);
//
// View column for notes field
//
$column = new TextViewColumn('notes', 'Notes', $this->dataset);
$column->SetOrderable(true);
$column->SetMaxLength(75);
$column->SetFullTextWindowHandlerName('taskviewGrid_notes_handler_list');
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$grid->AddViewColumn($column);
//
// View column for hrs field
//
$column = new TextViewColumn('hrs', 'Hrs', $this->dataset);
$column->SetOrderable(true);
$column = new NumberFormatValueViewColumnDecorator($column, 2, ',', '.');
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$grid->AddViewColumn($column);
//
// View column for wo field
//
$column = new TextViewColumn('wo', 'Wo', $this->dataset);
$column->SetOrderable(true);
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$grid->AddViewColumn($column);
//
// View column for staff_id field
//
$column = new TextViewColumn('staff_id', 'Staff Id', $this->dataset);
$column->SetOrderable(true);
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$grid->AddViewColumn($column);
//
// View column for Task field
//
$column = new TextViewColumn('Task', 'Task', $this->dataset);
$column->SetOrderable(true);
$column->SetMaxLength(75);
$column->SetFullTextWindowHandlerName('taskviewGrid_Task_handler_list');
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$grid->AddViewColumn($column);
//
// View column for Assigned field
//
$column = new TextViewColumn('Assigned', 'Assigned', $this->dataset);
$column->SetOrderable(true);
$column->SetMaxLength(75);
$column->SetFullTextWindowHandlerName('taskviewGrid_Assigned_handler_list');
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$grid->AddViewColumn($column);
}
