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 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('projectDetailEditGrid0program_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 notes field
//
$column = new TextViewColumn('notes', 'Notes', $this->dataset);
$column->SetOrderable(true);
$column->SetMaxLength(75);
$column->SetFullTextWindowHandlerName('projectDetailEditGrid0program_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->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 approved_budget field
//
$column = new TextViewColumn('approved_budget', 'Approved Budget', $this->dataset);
$grid->SetTotal($column, PredefinedAggregate::$Sum);
$column->SetOrderable(true);
$column = new CurrencyFormatValueViewColumnDecorator($column, 2, ',', '.', $this->RenderText('$'));
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$grid->AddViewColumn($column);
}
