protected function AddExportColumns(Grid $grid)
{
//
// View column for id_accion field
//
$column = new TextViewColumn('id_accion', 'Id Accion', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for ds_referencia field
//
$column = new TextViewColumn('id_tipo_accion_ds_referencia', 'Tipo Accion', $this->dataset);
$column->SetOrderable(true);
$column = new ExtendedHyperLinkColumnDecorator($column, $this->dataset, 'tipo_accion.php?operation=view&pk0=%id_tipo_accion%' , '_self');
$grid->AddExportColumn($column);
//
// View column for ds_referencia field
//
$column = new TextViewColumn('id_tipo_espacio_ds_referencia', 'Tipo Espacio', $this->dataset);
$column->SetOrderable(true);
$column = new ExtendedHyperLinkColumnDecorator($column, $this->dataset, 'tipo_espacio.php?operation=view&pk0=%id_tipo_espacio%' , '_self');
$grid->AddExportColumn($column);
//
// View column for no_sector field
//
$column = new TextViewColumn('id_sector_no_sector', 'Sector', $this->dataset);
$column->SetOrderable(true);
$column = new ExtendedHyperLinkColumnDecorator($column, $this->dataset, 'sector.php?operation=view&pk0=%id_sector%' , '_self');
$grid->AddExportColumn($column);
//
// View column for no_origen field
//
$column = new TextViewColumn('id_origen_no_origen', 'Origen', $this->dataset);
$column->SetOrderable(true);
$column = new ExtendedHyperLinkColumnDecorator($column, $this->dataset, 'origen.php?operation=view&pk0=%id_origen%' , '_self');
$grid->AddExportColumn($column);
//
// View column for no_metodologia field
//
$column = new TextViewColumn('id_metodologia_no_metodologia', 'Metodología', $this->dataset);
$column->SetOrderable(true);
$column = new ExtendedHyperLinkColumnDecorator($column, $this->dataset, 'metodologia.php?operation=view&pk0=%id_metodologia%' , '_self');
$grid->AddExportColumn($column);
//
// View column for no_periodicidad field
//
$column = new TextViewColumn('id_periodicidad_no_periodicidad', 'Periodicidad', $this->dataset);
$column->SetOrderable(true);
$column = new ExtendedHyperLinkColumnDecorator($column, $this->dataset, 'periodicidad.php?operation=view&pk0=%id_periodicidad%' , '_self');
$grid->AddExportColumn($column);
//
// View column for fl_a_demanda field
//
$column = new TextViewColumn('fl_a_demanda', 'A Demanda', $this->dataset);
$column->SetOrderable(true);
$column = new CheckBoxFormatValueViewColumnDecorator($column);
$column->SetDisplayValues($this->RenderText('<img src="images/checked.png" alt="true">'), $this->RenderText(''));
$grid->AddExportColumn($column);
//
// View column for nu_personas field
//
$column = new TextViewColumn('nu_personas', 'Personas', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for tm_carga_horaria field
//
$column = new DateTimeViewColumn('tm_carga_horaria', 'Carga Horária', $this->dataset);
$column->SetDateTimeFormat('H:i:s');
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for fe_horas field
//
$column = new TextViewColumn('fe_horas', 'Fe Horas', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for ds_referencia field
//
$column = new TextViewColumn('ds_referencia', 'Ds Referencia', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
}
/**
* @param CheckBoxFormatValueViewColumnDecorator $column
*/
public function RenderCheckBoxViewColumn($column)
{
$value = $column->GetInnerField()->GetData();
if (!isset($value)) {
$this->result = $this->Render($column->GetInnerField());
} else {
if (empty($value)) {
if ($this->HtmlMarkupAvailable()) {
$this->result = $column->GetFalseValue();
} else {
$this->result = 'false';
}
} else {
if ($this->HtmlMarkupAvailable()) {
$this->result = $column->GetTrueValue();
} else {
$this->result = 'true';
}
}
}
}
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 IP field
//
$column = new TextViewColumn('IP', 'IP', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for NomMachine field
//
$column = new TextViewColumn('NomMachine', 'NomMachine', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for EtatMachine field
//
$column = new TextViewColumn('EtatMachine', 'EtatMachine', $this->dataset);
$column->SetOrderable(true);
$column = new CheckBoxFormatValueViewColumnDecorator($column);
$column->SetDisplayValues($this->RenderText('<img src="images/checked.png" alt="true">'), $this->RenderText(''));
$grid->AddExportColumn($column);
//
// View column for Service1 field
//
$column = new TextViewColumn('Service1', 'Service1', $this->dataset);
$column->SetOrderable(true);
$column = new CheckBoxFormatValueViewColumnDecorator($column);
$column->SetDisplayValues($this->RenderText('<img src="images/checked.png" alt="true">'), $this->RenderText(''));
$grid->AddExportColumn($column);
//
// View column for Service2 field
//
$column = new TextViewColumn('Service2', 'Service2', $this->dataset);
$column->SetOrderable(true);
$column = new CheckBoxFormatValueViewColumnDecorator($column);
$column->SetDisplayValues($this->RenderText('<img src="images/checked.png" alt="true">'), $this->RenderText(''));
$grid->AddExportColumn($column);
//
// View column for Service3 field
//
$column = new TextViewColumn('Service3', 'Service3', $this->dataset);
$column->SetOrderable(true);
$column = new CheckBoxFormatValueViewColumnDecorator($column);
$column->SetDisplayValues($this->RenderText('<img src="images/checked.png" alt="true">'), $this->RenderText(''));
$grid->AddExportColumn($column);
}
function CreateMasterDetailRecordGridForproject_timeline_detailDetailEdit2projectGrid()
{
$result = new Grid($this, $this->dataset, 'MasterDetailRecordGridForproject_timeline_detailDetailEdit2project');
$result->SetAllowDeleteSelected(false);
$result->OnCustomDrawCell->AddListener('MasterDetailRecordGridForproject_timeline_detailDetailEdit2project' . '_OnCustomDrawRow', $this);
$result->OnCustomRenderColumn->AddListener('MasterDetailRecordGridForproject_timeline_detailDetailEdit2project' . '_' . 'OnCustomRenderColumn', $this);
$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 program_name field
//
$column = new TextViewColumn('programm_id_program_name', 'Project Type', $this->dataset);
$column->SetOrderable(true);
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$result->AddViewColumn($column);
//
// View column for project_name field
//
$column = new TextViewColumn('project_name', 'Project Name', $this->dataset);
$column->SetOrderable(true);
$column->SetEscapeHTMLSpecialChars(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 year field
//
$column = new TextViewColumn('year', 'Year', $this->dataset);
$column->SetOrderable(true);
$column->SetEscapeHTMLSpecialChars(true);
$column->SetWordWrap(false);
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$result->AddViewColumn($column);
//
// View column for notes field
//
$column = new TextViewColumn('notes', 'Objectives', $this->dataset);
$column->SetOrderable(true);
$column->SetMaxLength(75);
$column->SetFullTextWindowHandlerName('projectGrid_notes_handler_list');
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$result->AddViewColumn($column);
//
// View column for Name field
//
$column = new TextViewColumn('priority_Name', 'Priority', $this->dataset);
$column->SetOrderable(true);
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$result->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);
$result->AddViewColumn($column);
//
// View column for approved_budget field
//
$column = new TextViewColumn('approved_budget', 'Approved Budget', $this->dataset);
$column->SetOrderable(true);
$column = new CurrencyFormatValueViewColumnDecorator($column, 2, ',', '.', $this->RenderText('$'));
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$result->AddViewColumn($column);
//
// View column for budget_spent field
//
$column = new TextViewColumn('budget_spent', 'Budget Spent', $this->dataset);
$column->SetOrderable(true);
$column = new CurrencyFormatValueViewColumnDecorator($column, 2, ',', '.', $this->RenderText('$'));
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$result->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);
$result->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('projectGrid_public_engagement_handler_list');
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$result->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);
$result->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);
$result->AddViewColumn($column);
//
// View column for progress field
//
$column = new TextViewColumn('progress', 'Progress', $this->dataset);
$column->SetOrderable(true);
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$result->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);
$result->AddViewColumn($column);
//
// View column for program_name field
//
$column = new TextViewColumn('programm_id_program_name', 'Project Type', $this->dataset);
$column->SetOrderable(true);
$result->AddPrintColumn($column);
//
// View column for project_name field
//
$column = new TextViewColumn('project_name', 'Project Name', $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);
//
// View column for year field
//
$column = new TextViewColumn('year', 'Year', $this->dataset);
$column->SetOrderable(true);
$column->SetEscapeHTMLSpecialChars(true);
$column->SetWordWrap(false);
$result->AddPrintColumn($column);
//
// View column for notes field
//
$column = new TextViewColumn('notes', 'Notes', $this->dataset);
$column->SetOrderable(true);
$result->AddPrintColumn($column);
//
// View column for Name field
//
$column = new TextViewColumn('priority_Name', 'Priority', $this->dataset);
$column->SetOrderable(true);
$result->AddPrintColumn($column);
//
// View column for username field
//
$column = new TextViewColumn('lead_username', 'Project Lead', $this->dataset);
$column->SetOrderable(true);
$result->AddPrintColumn($column);
//
// View column for approved_budget field
//
$column = new TextViewColumn('approved_budget', 'Approved Budget', $this->dataset);
$column->SetOrderable(true);
$column = new CurrencyFormatValueViewColumnDecorator($column, 2, ',', '.', $this->RenderText('$'));
$result->AddPrintColumn($column);
//
// View column for budget_spent field
//
$column = new TextViewColumn('budget_spent', 'Budget Spent', $this->dataset);
$column->SetOrderable(true);
$column = new CurrencyFormatValueViewColumnDecorator($column, 2, ',', '.', $this->RenderText('$'));
$result->AddPrintColumn($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(''));
$result->AddPrintColumn($column);
//
// View column for public_engagement field
//
$column = new TextViewColumn('public_engagement', 'Public Engagement', $this->dataset);
$column->SetOrderable(true);
$result->AddPrintColumn($column);
//
// View column for level_of_service field
//
$column = new TextViewColumn('level_of_service', 'Level Of Service', $this->dataset);
$column->SetOrderable(true);
$result->AddPrintColumn($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(''));
$result->AddPrintColumn($column);
//
// View column for progress field
//
$column = new TextViewColumn('progress', 'Progress', $this->dataset);
$column->SetOrderable(true);
$result->AddPrintColumn($column);
//
// View column for DEPARTMENT field
//
$column = new TextViewColumn('dept_id_DEPARTMENT', 'Department', $this->dataset);
$column->SetOrderable(true);
$result->AddPrintColumn($column);
return $result;
}
protected function AddExportColumns(Grid $grid)
{
//
// View column for id_tarea field
//
$column = new TextViewColumn('id_tarea', 'Id Tarea', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for id_periodicidad field
//
$column = new TextViewColumn('id_tarea_plan_id_periodicidad', 'Id Tarea Plan', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for fe_ejecucion field
//
$column = new DateTimeViewColumn('fe_ejecucion', 'Fecha Ejecucion', $this->dataset);
$column->SetDateTimeFormat('Y-m-d H:i:s');
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for fl_realizada field
//
$column = new TextViewColumn('fl_realizada', 'Fl Realizada', $this->dataset);
$column->SetOrderable(true);
$column = new CheckBoxFormatValueViewColumnDecorator($column);
$column->SetDisplayValues($this->RenderText('<img src="images/checked.png" alt="true">'), $this->RenderText(''));
$grid->AddExportColumn($column);
//
// View column for ds_observaciones field
//
$column = new TextViewColumn('ds_observaciones', 'Ds Observaciones', $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 descrizione field
//
$column = new TextViewColumn('ivo-codart_descrizione', 'Codice Articolo', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for voc-descriz field
//
$column = new TextViewColumn('ivo-codvoc_voc-descriz', 'Codice Tipo Voce', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for ivo-przunit field
//
$column = new TextViewColumn('ivo-przunit', 'Prezzo unitario', $this->dataset);
$column->SetOrderable(true);
$column = new NumberFormatValueViewColumnDecorator($column, 2, '.', ',');
$grid->AddExportColumn($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(''));
$grid->AddExportColumn($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(''));
$grid->AddExportColumn($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);
$grid->AddExportColumn($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);
$grid->AddExportColumn($column);
}
protected function AddExportColumns(Grid $grid)
{
//
// View column for voc-codvoce field
//
$column = new TextViewColumn('voc-codvoce', 'Codice voce di costo', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for voc-descriz field
//
$column = new TextViewColumn('voc-descriz', 'Descrizione', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($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(''));
$grid->AddExportColumn($column);
//
// View column for formula field
//
$column = new TextViewColumn('voc-formula_formula', 'Formula di calcolo', $this->dataset);
$column->SetOrderable(true);
$column->SetMaxLength(150);
$column->SetFullTextWindowHandlerName('voci_costoGrid_formula_handler_export');
$grid->AddExportColumn($column);
//
// View column for voc-flagart field
//
$column = new TextViewColumn('voc-flagart', 'Prevede altri articoli', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for voc-przunit field
//
$column = new TextViewColumn('voc-przunit', 'Prezzo unitario', $this->dataset);
$column->SetOrderable(true);
$column = new NumberFormatValueViewColumnDecorator($column, 2, '.', ',');
$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 Ping field
//
$column = new TextViewColumn('Ping', 'Ping', $this->dataset);
$column->SetOrderable(true);
$column = new CheckBoxFormatValueViewColumnDecorator($column);
$column->SetDisplayValues($this->RenderText('<img src="images/checked.png" alt="true">'), $this->RenderText(''));
$grid->AddExportColumn($column);
//
// View column for Nsfr field
//
$column = new TextViewColumn('Nsfr', 'Nsfr', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for Nslo field
//
$column = new TextViewColumn('Nslo', 'Nslo', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
}
protected function AddExportColumns(Grid $grid)
{
//
// View column for id_accion field
//
$column = new TextViewColumn('id_accion', 'Id Accion', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for ds_referencia field
//
$column = new TextViewColumn('id_tipo_espacio_ds_referencia', 'Id Tipo Espacio', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for ds_referencia field
//
$column = new TextViewColumn('id_tipo_bien_ds_referencia', 'Id Tipo Bien', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for no_origen field
//
$column = new TextViewColumn('id_origen_no_origen', 'Id Origen', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for no_metodologia field
//
$column = new TextViewColumn('id_metodologia_no_metodologia', 'Id Metodologia', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for no_periodicidad field
//
$column = new TextViewColumn('id_periodicidad_no_periodicidad', 'Id Periodicidad', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for fl_a_demanda field
//
$column = new TextViewColumn('fl_a_demanda', 'A Demanda', $this->dataset);
$column->SetOrderable(true);
$column = new CheckBoxFormatValueViewColumnDecorator($column);
$column->SetDisplayValues($this->RenderText('<img src="images/checked.png" alt="true">'), $this->RenderText(''));
$grid->AddExportColumn($column);
//
// View column for ds_referencia field
//
$column = new TextViewColumn('ds_referencia', 'Ds Referencia', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for ds_referencia field
//
$column = new TextViewColumn('id_tipo_accion_ds_referencia', 'Id Tipo Accion', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
}
protected function AddExportColumns(Grid $grid)
{
//
// View column for program_name field
//
$column = new TextViewColumn('programm_id_program_name', 'Project Type', $this->dataset);
$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 date_start field
//
$column = new DateTimeViewColumn('date_start', 'Date Start', $this->dataset);
$column->SetDateTimeFormat('Y-m-d');
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for date_end field
//
$column = new DateTimeViewColumn('date_end', 'Date End', $this->dataset);
$column->SetDateTimeFormat('Y-m-d');
$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 budget_spent field
//
$column = new TextViewColumn('budget_spent', 'Budget Spent', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for notes field
//
$column = new TextViewColumn('notes', 'Notes', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for priority field
//
$column = new TextViewColumn('priority', 'Priority', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for username field
//
$column = new TextViewColumn('lead_username', 'Project Lead', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for level_of_service field
//
$column = new TextViewColumn('level_of_service', 'Level Of Service', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($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(''));
$grid->AddExportColumn($column);
//
// View column for public_engagement field
//
$column = new TextViewColumn('public_engagement', 'Public Engagement', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($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_export');
$column = new NumberFormatValueViewColumnDecorator($column, 0, '', '');
$grid->AddExportColumn($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(''));
$grid->AddExportColumn($column);
//
// View column for progress field
//
$column = new TextViewColumn('progress', 'Progress', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for DEPARTMENT field
//
$column = new TextViewColumn('dept_id_DEPARTMENT', 'Department', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
}
protected function AddExportColumns(Grid $grid)
{
//
// View column for title field
//
$column = new TextViewColumn('title', 'Office Title', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for num_positions field
//
$column = new TextViewColumn('num_positions', 'Number of Positions Available', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for responsibilities field
//
$column = new TextViewColumn('responsibilities', 'Responsibilities', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for term_length_months field
//
$column = new TextViewColumn('term_length_months', 'Term Length in Months', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for filing_fee field
//
$column = new TextViewColumn('filing_fee', 'Filing Fee', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for partisan field
//
$column = new TextViewColumn('partisan', 'Partisan Position', $this->dataset);
$column->SetOrderable(true);
$column = new CheckBoxFormatValueViewColumnDecorator($column);
$column->SetDisplayValues($this->RenderText('<img src="images/checked.png" alt="true">'), $this->RenderText(''));
$grid->AddExportColumn($column);
//
// View column for age_requirements field
//
$column = new TextViewColumn('age_requirements', 'Age Requirements', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for res_requirements field
//
$column = new TextViewColumn('res_requirements', 'Res Requirements', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for prof_requirements field
//
$column = new TextViewColumn('prof_requirements', 'Prof Requirements', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for salary field
//
$column = new TextViewColumn('salary', 'Salary', $this->dataset);
$column->SetOrderable(true);
$column = new NumberFormatValueViewColumnDecorator($column, 0, ',', '.');
$grid->AddExportColumn($column);
//
// View column for notes field
//
$column = new TextViewColumn('notes', 'Notes', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for office_rank field
//
$column = new TextViewColumn('office_rank', 'Office Rank', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
}
