protected function AddInsertColumns(Grid $grid)
{
//
// 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', 'insert_Cliente_RazonSocial_search', $editor, $this->dataset, $lookupDataset, 'idClientes', 'RazonSocial', '');
$editColumn->SetAllowSetToNull(true);
$this->ApplyCommonColumnEditProperties($editColumn);
$grid->AddInsertColumn($editColumn);
//
// 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);
$grid->AddInsertColumn($editColumn);
//
// 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);
$grid->AddInsertColumn($editColumn);
//
// 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);
$grid->AddInsertColumn($editColumn);
//
// Edit column for Saldo field
//
$editor = new TextEdit('saldo_edit');
$editColumn = new CustomEditColumn('Saldo', 'Saldo', $editor, $this->dataset);
$editColumn->SetAllowSetToNull(true);
$this->ApplyCommonColumnEditProperties($editColumn);
$grid->AddInsertColumn($editColumn);
//
// 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);
$grid->AddInsertColumn($editColumn);
//
// Edit column for DiasCartera field
//
$editor = new TextEdit('diascartera_edit');
$editColumn = new CustomEditColumn('DiasCartera', 'DiasCartera', $editor, $this->dataset);
$editColumn->SetAllowSetToNull(true);
$this->ApplyCommonColumnEditProperties($editColumn);
$grid->AddInsertColumn($editColumn);
//
// 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);
$grid->AddInsertColumn($editColumn);
//
// 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);
$grid->AddInsertColumn($editColumn);
if ($this->GetSecurityInfo()->HasAddGrant()) {
$grid->SetShowAddButton(true);
$grid->SetShowInlineAddButton(false);
} else {
$grid->SetShowInlineAddButton(false);
$grid->SetShowAddButton(false);
}
}
protected function AddInsertColumns(Grid $grid)
{
//
// Edit column for project_id field
//
$editor = new ComboBox('project_id_edit', $this->GetLocalizerCaptions()->GetMessageString('PleaseSelect'));
$lookupDataset = new TableDataset(new MyConnectionFactory(), GetConnectionOptions(), '`project`');
$field = new IntegerField('project_id', null, null, true);
$field->SetIsNotNull(true);
$lookupDataset->AddField($field, true);
$field = new IntegerField('programm_id');
$lookupDataset->AddField($field, false);
$field = new StringField('project_name');
$lookupDataset->AddField($field, false);
$field = new DateField('date_start');
$lookupDataset->AddField($field, false);
$field = new DateField('date_end');
$lookupDataset->AddField($field, false);
$field = new IntegerField('approved_budget');
$lookupDataset->AddField($field, false);
$field = new StringField('notes');
$field->SetIsNotNull(true);
$lookupDataset->AddField($field, false);
$field = new StringField('priority');
$lookupDataset->AddField($field, false);
$field = new StringField('lead');
$lookupDataset->AddField($field, false);
$field = new StringField('level_of_service');
$field->SetIsNotNull(true);
$lookupDataset->AddField($field, false);
$field = new StringField('multi_year');
$field->SetIsNotNull(true);
$lookupDataset->AddField($field, false);
$field = new StringField('public_engagement');
$field->SetIsNotNull(true);
$lookupDataset->AddField($field, false);
$field = new StringField('year');
$field->SetIsNotNull(true);
$lookupDataset->AddField($field, false);
$field = new StringField('approved');
$field->SetIsNotNull(true);
$lookupDataset->AddField($field, false);
$field = new StringField('progress');
$field->SetIsNotNull(true);
$lookupDataset->AddField($field, false);
$field = new IntegerField('staff_id');
$field->SetIsNotNull(true);
$lookupDataset->AddField($field, false);
$field = new IntegerField('dept_id');
$field->SetIsNotNull(true);
$lookupDataset->AddField($field, false);
$field = new IntegerField('budget_spent');
$field->SetIsNotNull(true);
$lookupDataset->AddField($field, false);
$field = new IntegerField('admin_flag');
$field->SetIsNotNull(true);
$lookupDataset->AddField($field, false);
$lookupDataset->SetOrderBy('project_name', GetOrderTypeAsSQL(otAscending));
$editColumn = new LookUpEditColumn('Project', 'project_id', $editor, $this->dataset, 'project_id', 'project_name', $lookupDataset);
$editColumn->SetReadOnly(true);
$editColumn->setEnabled(false);
$validator = new RequiredValidator(StringUtils::Format($this->GetLocalizerCaptions()->GetMessageString('RequiredValidationMessage'), $this->RenderText($editColumn->GetCaption())));
$editor->GetValidatorCollection()->AddValidator($validator);
$this->ApplyCommonColumnEditProperties($editColumn);
$grid->AddInsertColumn($editColumn);
//
// Edit column for task_name field
//
$editor = new AutocomleteComboBox('task_name_edit', $this->CreateLinkBuilder());
$editor->SetSize('250px');
$lookupDataset = new TableDataset(new MyConnectionFactory(), GetConnectionOptions(), '`task_names`');
$field = new IntegerField('id', null, null, true);
$field->SetIsNotNull(true);
$lookupDataset->AddField($field, true);
$field = new StringField('Name');
$lookupDataset->AddField($field, false);
$lookupDataset->SetOrderBy('Name', GetOrderTypeAsSQL(otAscending));
$editColumn = new DynamicLookupEditColumn('Task Name', 'task_name', 'task_name_Name', 'insert_task_name_Name_search', $editor, $this->dataset, $lookupDataset, 'Name', 'Name', '');
$editColumn->SetAllowSetToNull(true);
$this->ApplyCommonColumnEditProperties($editColumn);
$grid->AddInsertColumn($editColumn);
//
// 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);
$grid->AddInsertColumn($editColumn);
//
// Edit column for hrs field
//
$editor = new SpinEdit('hrs_edit');
$editColumn = new CustomEditColumn('Estimated Hours', 'hrs', $editor, $this->dataset);
$editColumn->SetInsertDefaultValue($this->RenderText('21'));
$validator = new RequiredValidator(StringUtils::Format($this->GetLocalizerCaptions()->GetMessageString('RequiredValidationMessage'), $this->RenderText($editColumn->GetCaption())));
$editor->GetValidatorCollection()->AddValidator($validator);
$this->ApplyCommonColumnEditProperties($editColumn);
$grid->AddInsertColumn($editColumn);
//
// Edit column for assigned_to field
//
$editor = new ComboBox('assigned_to_edit', $this->GetLocalizerCaptions()->GetMessageString('PleaseSelect'));
$lookupDataset = new TableDataset(new MyConnectionFactory(), GetConnectionOptions(), '`staff`');
$field = new IntegerField('staff_id', null, null, true);
$field->SetIsNotNull(true);
$lookupDataset->AddField($field, true);
$field = new StringField('username');
$field->SetIsNotNull(true);
$lookupDataset->AddField($field, false);
$field = new StringField('email');
$field->SetIsNotNull(true);
$lookupDataset->AddField($field, false);
$field = new StringField('picture');
$field->SetIsNotNull(true);
$lookupDataset->AddField($field, false);
$field = new StringField('password');
$field->SetIsNotNull(true);
$lookupDataset->AddField($field, false);
$field = new IntegerField('dept_id');
$field->SetIsNotNull(true);
$lookupDataset->AddField($field, false);
$field = new StringField('position');
$field->SetIsNotNull(true);
$lookupDataset->AddField($field, false);
$field = new StringField('emp_number');
$field->SetIsNotNull(true);
$lookupDataset->AddField($field, false);
$lookupDataset->SetOrderBy('username', GetOrderTypeAsSQL(otAscending));
$editColumn = new LookUpEditColumn('Assigned To', 'assigned_to', $editor, $this->dataset, 'staff_id', 'username', $lookupDataset);
$editColumn->SetInsertDefaultValue($this->RenderText('%CURRENT_USER_ID%'));
$validator = new RequiredValidator(StringUtils::Format($this->GetLocalizerCaptions()->GetMessageString('RequiredValidationMessage'), $this->RenderText($editColumn->GetCaption())));
$editor->GetValidatorCollection()->AddValidator($validator);
$this->ApplyCommonColumnEditProperties($editColumn);
$grid->AddInsertColumn($editColumn);
//
// Edit column for date_start field
//
$editor = new DateTimeEdit('date_start_edit', false, 'Y-m-d', GetFirstDayOfWeek());
$editColumn = new CustomEditColumn('Date Start', 'date_start', $editor, $this->dataset);
$editColumn->SetInsertDefaultValue($this->RenderText('%CURRENT_DATE%'));
$validator = new RequiredValidator(StringUtils::Format($this->GetLocalizerCaptions()->GetMessageString('RequiredValidationMessage'), $this->RenderText($editColumn->GetCaption())));
$editor->GetValidatorCollection()->AddValidator($validator);
$this->ApplyCommonColumnEditProperties($editColumn);
$grid->AddInsertColumn($editColumn);
//
// Edit column for date_end field
//
$editor = new DateTimeEdit('date_end_edit', false, 'Y-m-d', GetFirstDayOfWeek());
$editColumn = new CustomEditColumn('Date End', 'date_end', $editor, $this->dataset);
$validator = new RequiredValidator(StringUtils::Format($this->GetLocalizerCaptions()->GetMessageString('RequiredValidationMessage'), $this->RenderText($editColumn->GetCaption())));
$editor->GetValidatorCollection()->AddValidator($validator);
$this->ApplyCommonColumnEditProperties($editColumn);
$grid->AddInsertColumn($editColumn);
if ($this->GetSecurityInfo()->HasAddGrant()) {
$grid->SetShowAddButton(true);
$grid->SetShowInlineAddButton(false);
} else {
$grid->SetShowInlineAddButton(false);
$grid->SetShowAddButton(false);
}
}
