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); } }