protected function AddInsertColumns(Grid $grid) { // // Edit column for no_tipo_espacio field // $editor = new TextEdit('no_tipo_espacio_edit'); $editor->SetSize(100); $editor->SetMaxLength(100); $editColumn = new CustomEditColumn('No Tipo Espacio', 'no_tipo_espacio', $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 id_tipo_espacio_padre field // $editor = new ComboBox('id_tipo_espacio_padre_edit', $this->GetLocalizerCaptions()->GetMessageString('PleaseSelect')); $lookupDataset = new TableDataset( new PgConnectionFactory(), GetConnectionOptions(), '"public"."sga_tipo_espacio"'); $field = new IntegerField('id_tipo_espacio', null, null, true); $field->SetIsNotNull(true); $lookupDataset->AddField($field, true); $field = new StringField('no_tipo_espacio'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, false); $field = new IntegerField('id_tipo_espacio_padre'); $lookupDataset->AddField($field, false); $field = new StringField('ds_referencia'); $lookupDataset->AddField($field, false); $lookupDataset->setOrderByField('no_tipo_espacio', GetOrderTypeAsSQL(otAscending)); $editColumn = new LookUpEditColumn( 'Id Tipo Espacio Padre', 'id_tipo_espacio_padre', $editor, $this->dataset, 'id_tipo_espacio', 'no_tipo_espacio', $lookupDataset); $editColumn->SetAllowSetToNull(true); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); // // Edit column for ds_referencia field // $editor = new TextAreaEdit('ds_referencia_edit', 50, 8); $editColumn = new CustomEditColumn('Ds Referencia', 'ds_referencia', $editor, $this->dataset); $editColumn->SetAllowSetToNull(true); $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 id_tipo_accion field // $editor = new ComboBox('id_tipo_accion_edit', $this->GetLocalizerCaptions()->GetMessageString('PleaseSelect')); $lookupDataset = new TableDataset( new PgConnectionFactory(), GetConnectionOptions(), '"public"."sga_tipo_accion"'); $field = new IntegerField('id_tipo_accion', null, null, true); $field->SetIsNotNull(true); $lookupDataset->AddField($field, true); $field = new StringField('no_tipo_accion'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, false); $field = new IntegerField('id_tipo_accion_padre'); $lookupDataset->AddField($field, false); $field = new StringField('ds_referencia'); $lookupDataset->AddField($field, false); $lookupDataset->setOrderByField('ds_referencia', GetOrderTypeAsSQL(otAscending)); $editColumn = new LookUpEditColumn( 'Tipo Accion', 'id_tipo_accion', $editor, $this->dataset, 'id_tipo_accion', 'ds_referencia', $lookupDataset); $editColumn->SetAllowSetToNull(true); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); // // Edit column for id_tipo_espacio field // $editor = new ComboBox('id_tipo_espacio_edit', $this->GetLocalizerCaptions()->GetMessageString('PleaseSelect')); $lookupDataset = new TableDataset( new PgConnectionFactory(), GetConnectionOptions(), '"public"."sga_tipo_espacio"'); $field = new IntegerField('id_tipo_espacio', null, null, true); $field->SetIsNotNull(true); $lookupDataset->AddField($field, true); $field = new StringField('no_tipo_espacio'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, false); $field = new IntegerField('id_tipo_espacio_padre'); $lookupDataset->AddField($field, false); $field = new StringField('ds_referencia'); $lookupDataset->AddField($field, false); $lookupDataset->setOrderByField('ds_referencia', GetOrderTypeAsSQL(otAscending)); $editColumn = new LookUpEditColumn( 'Tipo Espacio', 'id_tipo_espacio', $editor, $this->dataset, 'id_tipo_espacio', 'ds_referencia', $lookupDataset); $editColumn->SetAllowSetToNull(true); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); // // Edit column for id_sector field // $editor = new ComboBox('id_sector_edit', $this->GetLocalizerCaptions()->GetMessageString('PleaseSelect')); $lookupDataset = new TableDataset( new PgConnectionFactory(), GetConnectionOptions(), '"public"."sga_sector"'); $field = new IntegerField('id_sector', null, null, true); $field->SetIsNotNull(true); $lookupDataset->AddField($field, true); $field = new StringField('no_sector'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, false); $lookupDataset->setOrderByField('no_sector', GetOrderTypeAsSQL(otAscending)); $editColumn = new LookUpEditColumn( 'Sector', 'id_sector', $editor, $this->dataset, 'id_sector', 'no_sector', $lookupDataset); $editColumn->SetAllowSetToNull(true); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); // // Edit column for id_origen field // $editor = new ComboBox('id_origen_edit', $this->GetLocalizerCaptions()->GetMessageString('PleaseSelect')); $lookupDataset = new TableDataset( new PgConnectionFactory(), GetConnectionOptions(), '"public"."sga_origen"'); $field = new IntegerField('id_origen', null, null, true); $field->SetIsNotNull(true); $lookupDataset->AddField($field, true); $field = new StringField('no_origen'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, false); $lookupDataset->setOrderByField('no_origen', GetOrderTypeAsSQL(otAscending)); $editColumn = new LookUpEditColumn( 'Origen', 'id_origen', $editor, $this->dataset, 'id_origen', 'no_origen', $lookupDataset); $editColumn->SetAllowSetToNull(true); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); // // Edit column for id_metodologia field // $editor = new ComboBox('id_metodologia_edit', $this->GetLocalizerCaptions()->GetMessageString('PleaseSelect')); $lookupDataset = new TableDataset( new PgConnectionFactory(), GetConnectionOptions(), '"public"."sga_metodologia"'); $field = new IntegerField('id_metodologia', null, null, true); $field->SetIsNotNull(true); $lookupDataset->AddField($field, true); $field = new StringField('no_metodologia'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, false); $field = new StringField('ds_metodologia'); $lookupDataset->AddField($field, false); $field = new IntegerField('id_origen'); $lookupDataset->AddField($field, false); $lookupDataset->setOrderByField('no_metodologia', GetOrderTypeAsSQL(otAscending)); $editColumn = new LookUpEditColumn( 'Metodología', 'id_metodologia', $editor, $this->dataset, 'id_metodologia', 'no_metodologia', $lookupDataset); $editColumn->SetAllowSetToNull(true); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); // // Edit column for id_periodicidad field // $editor = new ComboBox('id_periodicidad_edit', $this->GetLocalizerCaptions()->GetMessageString('PleaseSelect')); $lookupDataset = new TableDataset( new PgConnectionFactory(), GetConnectionOptions(), '"public"."sga_periodicidad"'); $field = new IntegerField('id_periodicidad', null, null, true); $field->SetIsNotNull(true); $lookupDataset->AddField($field, true); $field = new StringField('no_periodicidad'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, false); $field = new IntegerField('va_frecuencia'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, false); $lookupDataset->setOrderByField('no_periodicidad', GetOrderTypeAsSQL(otAscending)); $editColumn = new LookUpEditColumn( 'Periodicidad', 'id_periodicidad', $editor, $this->dataset, 'id_periodicidad', 'no_periodicidad', $lookupDataset); $editColumn->SetAllowSetToNull(true); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); // // Edit column for fl_a_demanda field // $editor = new CheckBox('fl_a_demanda_edit'); $editColumn = new CustomEditColumn('A Demanda', 'fl_a_demanda', $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 nu_personas field // $editor = new TextEdit('nu_personas_edit'); $editColumn = new CustomEditColumn('Personas', 'nu_personas', $editor, $this->dataset); $editColumn->SetAllowSetToNull(true); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); // // Edit column for tm_carga_horaria field // $editor = new TimeEdit('tm_carga_horaria_edit'); $editColumn = new CustomEditColumn('Carga Horária', 'tm_carga_horaria', $editor, $this->dataset); $editColumn->SetAllowSetToNull(true); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); // // Edit column for fe_horas field // $editor = new MultiValueSelect('fe_horas_edit'); $editor->AddValue('00:00', $this->RenderText('00:00')); $editor->AddValue('00:15', $this->RenderText('00:15')); $editor->AddValue('00:30', $this->RenderText('00:30')); $editor->AddValue('00:45', $this->RenderText('00:45')); $editor->AddValue('01:00', $this->RenderText('01:00')); $editor->AddValue('01:15', $this->RenderText('01:15')); $editor->AddValue('01:30', $this->RenderText('01:30')); $editor->AddValue('01:45', $this->RenderText('01:45')); $editor->AddValue('02:00', $this->RenderText('02:00')); $editor->AddValue('02:15', $this->RenderText('02:15')); $editor->AddValue('02:30', $this->RenderText('02:30')); $editor->AddValue('02:45', $this->RenderText('02:45')); $editor->AddValue('03:00', $this->RenderText('03:00')); $editor->AddValue('03:15', $this->RenderText('03:15')); $editor->AddValue('03:30', $this->RenderText('03:30')); $editor->AddValue('03:45', $this->RenderText('03:45')); $editor->AddValue('04:00', $this->RenderText('04:00')); $editor->AddValue('04:15', $this->RenderText('04:15')); $editor->AddValue('04:30', $this->RenderText('04:30')); $editor->AddValue('04:45', $this->RenderText('04:45')); $editor->AddValue('05:00', $this->RenderText('05:00')); $editor->AddValue('05:15', $this->RenderText('05:15')); $editor->AddValue('05:30', $this->RenderText('05:30')); $editor->AddValue('05:45', $this->RenderText('05:45')); $editor->AddValue('06:00', $this->RenderText('06:00')); $editor->AddValue('06:15', $this->RenderText('06:15')); $editor->AddValue('06:30', $this->RenderText('06:30')); $editor->AddValue('06:45', $this->RenderText('06:45')); $editor->AddValue('07:00', $this->RenderText('07:00')); $editor->AddValue('07:15', $this->RenderText('07:15')); $editor->AddValue('07:30', $this->RenderText('07:30')); $editor->AddValue('07:45', $this->RenderText('07:45')); $editor->AddValue('08:00', $this->RenderText('08:00')); $editor->AddValue('08:15', $this->RenderText('08:15')); $editor->AddValue('08:30', $this->RenderText('08:30')); $editor->AddValue('08:45', $this->RenderText('08:45')); $editor->AddValue('09:00', $this->RenderText('09:00')); $editor->AddValue('09:15', $this->RenderText('09:15')); $editor->AddValue('09:30', $this->RenderText('09:30')); $editor->AddValue('09:45', $this->RenderText('09:45')); $editor->AddValue('10:00', $this->RenderText('10:00')); $editor->AddValue('10:15', $this->RenderText('10:15')); $editor->AddValue('10:30', $this->RenderText('10:30')); $editor->AddValue('10:45', $this->RenderText('10:45')); $editor->AddValue('11:00', $this->RenderText('11:00')); $editor->AddValue('11:15', $this->RenderText('11:15')); $editor->AddValue('11:30', $this->RenderText('11:30')); $editor->AddValue('11:45', $this->RenderText('11:45')); $editor->AddValue('12:00', $this->RenderText('12:00')); $editor->AddValue('12:15', $this->RenderText('12:15')); $editor->AddValue('12:30', $this->RenderText('12:30')); $editor->AddValue('12:45', $this->RenderText('12:45')); $editor->AddValue('13:00', $this->RenderText('13:00')); $editor->AddValue('13:15', $this->RenderText('13:15')); $editor->AddValue('13:30', $this->RenderText('13:30')); $editor->AddValue('13:45', $this->RenderText('13:45')); $editor->AddValue('14:00', $this->RenderText('14:00')); $editor->AddValue('14:15', $this->RenderText('14:15')); $editor->AddValue('14:30', $this->RenderText('14:30')); $editor->AddValue('14:45', $this->RenderText('14:45')); $editor->AddValue('15:00', $this->RenderText('15:00')); $editor->AddValue('15:15', $this->RenderText('15:15')); $editor->AddValue('15:30', $this->RenderText('15:30')); $editor->AddValue('15:45', $this->RenderText('15:45')); $editor->AddValue('16:00', $this->RenderText('16:00')); $editor->AddValue('16:15', $this->RenderText('16:15')); $editor->AddValue('16:30', $this->RenderText('16:30')); $editor->AddValue('16:45', $this->RenderText('16:45')); $editor->AddValue('17:00', $this->RenderText('17:00')); $editor->AddValue('17:15', $this->RenderText('17:15')); $editor->AddValue('17:30', $this->RenderText('17:30')); $editor->AddValue('17:45', $this->RenderText('17:45')); $editor->AddValue('18:00', $this->RenderText('18:00')); $editor->AddValue('18:15', $this->RenderText('18:15')); $editor->AddValue('18:30', $this->RenderText('18:30')); $editor->AddValue('18:45', $this->RenderText('18:45')); $editor->AddValue('19:00', $this->RenderText('19:00')); $editor->AddValue('19:15', $this->RenderText('19:15')); $editor->AddValue('19:30', $this->RenderText('19:30')); $editor->AddValue('19:45', $this->RenderText('19:45')); $editor->AddValue('20:00', $this->RenderText('20:00')); $editor->AddValue('20:15', $this->RenderText('20:15')); $editor->AddValue('20:30', $this->RenderText('20:30')); $editor->AddValue('20:45', $this->RenderText('20:45')); $editor->AddValue('21:00', $this->RenderText('21:00')); $editor->AddValue('21:15', $this->RenderText('21:15')); $editor->AddValue('21:30', $this->RenderText('21:30')); $editor->AddValue('21:45', $this->RenderText('21:45')); $editor->AddValue('22:00', $this->RenderText('22:00')); $editor->AddValue('22:15', $this->RenderText('22:15')); $editor->AddValue('22:30', $this->RenderText('22:30')); $editor->AddValue('22:45', $this->RenderText('22:45')); $editor->AddValue('23:00', $this->RenderText('23:00')); $editor->AddValue('23:15', $this->RenderText('23:15')); $editor->AddValue('23:30', $this->RenderText('23:30')); $editor->AddValue('23:45', $this->RenderText('23:45')); $editor->setMaxSelectionSize(0); $editColumn = new CustomEditColumn('Horas Ejecución', 'fe_horas', $editor, $this->dataset); $editColumn->SetAllowSetToNull(true); $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 id_accion field // $editor = new ComboBox('id_accion_edit', $this->GetLocalizerCaptions()->GetMessageString('PleaseSelect')); $lookupDataset = new TableDataset( new PgConnectionFactory(), GetConnectionOptions(), '"public"."sga_accion"'); $field = new IntegerField('id_accion', null, null, true); $field->SetIsNotNull(true); $lookupDataset->AddField($field, true); $field = new IntegerField('id_tipo_espacio'); $lookupDataset->AddField($field, false); $field = new IntegerField('id_tipo_bien'); $lookupDataset->AddField($field, false); $field = new IntegerField('id_origen'); $lookupDataset->AddField($field, false); $field = new IntegerField('id_metodologia'); $lookupDataset->AddField($field, false); $field = new IntegerField('id_periodicidad'); $lookupDataset->AddField($field, false); $field = new BooleanField('fl_a_demanda'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, false); $field = new StringField('ds_referencia'); $lookupDataset->AddField($field, false); $field = new IntegerField('id_tipo_accion'); $lookupDataset->AddField($field, false); $field = new IntegerField('id_sector'); $lookupDataset->AddField($field, false); $lookupDataset->setOrderByField('ds_referencia', GetOrderTypeAsSQL(otAscending)); $editColumn = new LookUpEditColumn( 'Acción', 'id_accion', $editor, $this->dataset, 'id_accion', 'ds_referencia', $lookupDataset); $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 id_espacio field // $editor = new ComboBox('id_espacio_edit', $this->GetLocalizerCaptions()->GetMessageString('PleaseSelect')); $lookupDataset = new TableDataset( new PgConnectionFactory(), GetConnectionOptions(), '"public"."sga_espacio"'); $field = new IntegerField('id_espacio', null, null, true); $field->SetIsNotNull(true); $lookupDataset->AddField($field, true); $field = new IntegerField('id_tipo_espacio'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, false); $field = new IntegerField('id_espacio_contenedor'); $lookupDataset->AddField($field, false); $field = new StringField('co_espacio'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, false); $field = new StringField('no_espacio'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, false); $field = new StringField('co_plano'); $lookupDataset->AddField($field, false); $field = new IntegerField('id_planta'); $lookupDataset->AddField($field, false); $field = new StringField('ds_referencia'); $lookupDataset->AddField($field, false); $field = new IntegerField('id_sector'); $lookupDataset->AddField($field, false); $lookupDataset->setOrderByField('ds_referencia', GetOrderTypeAsSQL(otAscending)); $editColumn = new LookUpEditColumn( 'Espacio', 'id_espacio', $editor, $this->dataset, 'id_espacio', 'ds_referencia', $lookupDataset); $editColumn->SetAllowSetToNull(true); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); // // Edit column for id_bien field // $editor = new ComboBox('id_bien_edit', $this->GetLocalizerCaptions()->GetMessageString('PleaseSelect')); $lookupDataset = new TableDataset( new PgConnectionFactory(), GetConnectionOptions(), '"public"."sga_bien"'); $field = new IntegerField('id_bien', null, null, true); $field->SetIsNotNull(true); $lookupDataset->AddField($field, true); $field = new IntegerField('id_tipo_bien'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, false); $field = new IntegerField('id_espacio'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, false); $field = new StringField('ds_observacion'); $lookupDataset->AddField($field, false); $field = new IntegerField('nu_cantidad'); $lookupDataset->AddField($field, false); $lookupDataset->setOrderByField('ds_observacion', GetOrderTypeAsSQL(otAscending)); $editColumn = new LookUpEditColumn( 'Bien', 'id_bien', $editor, $this->dataset, 'id_bien', 'ds_observacion', $lookupDataset); $editColumn->SetAllowSetToNull(true); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); // // Edit column for id_periodicidad field // $editor = new ComboBox('id_periodicidad_edit', $this->GetLocalizerCaptions()->GetMessageString('PleaseSelect')); $lookupDataset = new TableDataset( new PgConnectionFactory(), GetConnectionOptions(), '"public"."sga_periodicidad"'); $field = new IntegerField('id_periodicidad', null, null, true); $field->SetIsNotNull(true); $lookupDataset->AddField($field, true); $field = new StringField('no_periodicidad'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, false); $field = new IntegerField('va_frecuencia'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, false); $lookupDataset->setOrderByField('no_periodicidad', GetOrderTypeAsSQL(otAscending)); $editColumn = new LookUpEditColumn( 'Periodicidad', 'id_periodicidad', $editor, $this->dataset, 'id_periodicidad', 'no_periodicidad', $lookupDataset); $editColumn->SetAllowSetToNull(true); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); // // Edit column for ds_detalle field // $editor = new TextAreaEdit('ds_detalle_edit', 50, 8); $editColumn = new CustomEditColumn('Detalle', 'ds_detalle', $editor, $this->dataset); $editColumn->SetAllowSetToNull(true); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); // // Edit column for fe_inicio field // $editor = new DateTimeEdit('fe_inicio_edit', true, 'd/m/Y H:i:s', GetFirstDayOfWeek()); $editColumn = new CustomEditColumn('Fecha Início', 'fe_inicio', $editor, $this->dataset); $editColumn->SetAllowSetToNull(true); $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 id_tipo_accion field // $editor = new ComboBox('id_tipo_accion_edit', $this->GetLocalizerCaptions()->GetMessageString('PleaseSelect')); $lookupDataset = new TableDataset( new PgConnectionFactory(), GetConnectionOptions(), '"public"."sga_tipo_accion"'); $field = new IntegerField('id_tipo_accion', null, null, true); $field->SetIsNotNull(true); $lookupDataset->AddField($field, true); $field = new StringField('no_tipo_accion'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, false); $field = new IntegerField('id_tipo_accion_padre'); $lookupDataset->AddField($field, false); $field = new StringField('ds_referencia'); $lookupDataset->AddField($field, false); $lookupDataset->setOrderByField('ds_referencia', GetOrderTypeAsSQL(otAscending)); $editColumn = new LookUpEditColumn( 'Tipo Accion', 'id_tipo_accion', $editor, $this->dataset, 'id_tipo_accion', 'ds_referencia', $lookupDataset); $editColumn->SetAllowSetToNull(true); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); // // Edit column for id_tipo_espacio field // $editor = new ComboBox('id_tipo_espacio_edit', $this->GetLocalizerCaptions()->GetMessageString('PleaseSelect')); $lookupDataset = new TableDataset( new PgConnectionFactory(), GetConnectionOptions(), '"public"."sga_tipo_espacio"'); $field = new IntegerField('id_tipo_espacio', null, null, true); $field->SetIsNotNull(true); $lookupDataset->AddField($field, true); $field = new StringField('no_tipo_espacio'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, false); $field = new IntegerField('id_tipo_espacio_padre'); $lookupDataset->AddField($field, false); $field = new StringField('ds_referencia'); $lookupDataset->AddField($field, false); $lookupDataset->setOrderByField('ds_referencia', GetOrderTypeAsSQL(otAscending)); $editColumn = new LookUpEditColumn( 'Tipo Espacio', 'id_tipo_espacio', $editor, $this->dataset, 'id_tipo_espacio', 'ds_referencia', $lookupDataset); $editColumn->SetAllowSetToNull(true); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); // // Edit column for id_tipo_bien field // $editor = new ComboBox('id_tipo_bien_edit', $this->GetLocalizerCaptions()->GetMessageString('PleaseSelect')); $lookupDataset = new TableDataset( new PgConnectionFactory(), GetConnectionOptions(), '"public"."sga_tipo_bien"'); $field = new IntegerField('id_tipo_bien', null, null, true); $field->SetIsNotNull(true); $lookupDataset->AddField($field, true); $field = new StringField('no_tipo_bien'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, false); $field = new IntegerField('id_tipo_bien_padre'); $lookupDataset->AddField($field, false); $field = new StringField('ds_referencia'); $lookupDataset->AddField($field, false); $lookupDataset->setOrderByField('ds_referencia', GetOrderTypeAsSQL(otAscending)); $editColumn = new LookUpEditColumn( 'Tipo Bien', 'id_tipo_bien', $editor, $this->dataset, 'id_tipo_bien', 'ds_referencia', $lookupDataset); $editColumn->SetAllowSetToNull(true); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); // // Edit column for id_origen field // $editor = new ComboBox('id_origen_edit', $this->GetLocalizerCaptions()->GetMessageString('PleaseSelect')); $lookupDataset = new TableDataset( new PgConnectionFactory(), GetConnectionOptions(), '"public"."sga_origen"'); $field = new IntegerField('id_origen', null, null, true); $field->SetIsNotNull(true); $lookupDataset->AddField($field, true); $field = new StringField('no_origen'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, false); $lookupDataset->setOrderByField('no_origen', GetOrderTypeAsSQL(otAscending)); $editColumn = new LookUpEditColumn( 'Origen', 'id_origen', $editor, $this->dataset, 'id_origen', 'no_origen', $lookupDataset); $editColumn->SetAllowSetToNull(true); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); // // Edit column for id_metodologia field // $editor = new ComboBox('id_metodologia_edit', $this->GetLocalizerCaptions()->GetMessageString('PleaseSelect')); $lookupDataset = new TableDataset( new PgConnectionFactory(), GetConnectionOptions(), '"public"."sga_metodologia"'); $field = new IntegerField('id_metodologia', null, null, true); $field->SetIsNotNull(true); $lookupDataset->AddField($field, true); $field = new StringField('no_metodologia'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, false); $field = new StringField('ds_metodologia'); $lookupDataset->AddField($field, false); $field = new IntegerField('id_origen'); $lookupDataset->AddField($field, false); $lookupDataset->setOrderByField('no_metodologia', GetOrderTypeAsSQL(otAscending)); $editColumn = new LookUpEditColumn( 'Metodología', 'id_metodologia', $editor, $this->dataset, 'id_metodologia', 'no_metodologia', $lookupDataset); $editColumn->SetAllowSetToNull(true); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); // // Edit column for id_periodicidad field // $editor = new ComboBox('id_periodicidad_edit', $this->GetLocalizerCaptions()->GetMessageString('PleaseSelect')); $lookupDataset = new TableDataset( new PgConnectionFactory(), GetConnectionOptions(), '"public"."sga_periodicidad"'); $field = new IntegerField('id_periodicidad', null, null, true); $field->SetIsNotNull(true); $lookupDataset->AddField($field, true); $field = new StringField('no_periodicidad'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, false); $field = new IntegerField('va_frecuencia'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, false); $lookupDataset->setOrderByField('no_periodicidad', GetOrderTypeAsSQL(otAscending)); $editColumn = new LookUpEditColumn( 'Periodicidad', 'id_periodicidad', $editor, $this->dataset, 'id_periodicidad', 'no_periodicidad', $lookupDataset); $editColumn->SetAllowSetToNull(true); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); // // Edit column for fl_a_demanda field // $editor = new CheckBox('fl_a_demanda_edit'); $editColumn = new CustomEditColumn('A Demanda', 'fl_a_demanda', $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 off-numoff field // $editor = new TextEdit('off-numoff_edit'); $editColumn = new CustomEditColumn('Off-numoff', 'off-numoff', $editor, $this->dataset); $editColumn->SetAllowSetToNull(true); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); // // Edit column for off-codcli field // $editor = new ComboBox('off-codcli_edit', $this->GetLocalizerCaptions()->GetMessageString('PleaseSelect')); $lookupDataset = new TableDataset(new MyPDOConnectionFactory(), GetConnectionOptions(), '`clienti`'); $field = new IntegerField('id', null, null, true); $field->SetIsNotNull(true); $lookupDataset->AddField($field, true); $field = new StringField('cli-codcli'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, false); $field = new StringField('cli-ragsoc'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, false); $field = new StringField('cli-codlis'); $lookupDataset->AddField($field, false); $field = new DateTimeField('datains'); $lookupDataset->AddField($field, false); $field = new DateTimeField('datamod'); $lookupDataset->AddField($field, false); $lookupDataset->setOrderByField('cli-ragsoc', GetOrderTypeAsSQL(otAscending)); $editColumn = new LookUpEditColumn('cod.Cliente', 'off-codcli', $editor, $this->dataset, 'cli-codcli', 'cli-ragsoc', $lookupDataset); $editColumn->SetAllowSetToNull(true); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); // // Edit column for off-descriz field // $editor = new TextEdit('off-descriz_edit'); $editor->SetSize(50); $editor->SetMaxLength(50); $editColumn = new CustomEditColumn('Off-descriz', 'off-descriz', $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 off-gg-termine-consegna field // $editor = new TextEdit('off-gg-termine-consegna_edit'); $editColumn = new CustomEditColumn('Off-gg-termine-consegna', 'off-gg-termine-consegna', $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 off-datains field // $editor = new DateTimeEdit('off-datains_edit', true, 'd-m-Y', GetFirstDayOfWeek()); $editColumn = new CustomEditColumn('Data inserimento', 'off-datains', $editor, $this->dataset); $editColumn->SetAllowSetToNull(true); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); // // Edit column for off-dataeva field // $editor = new DateTimeEdit('off-dataeva_edit', true, 'd-m-Y', GetFirstDayOfWeek()); $editColumn = new CustomEditColumn('Data evasione', 'off-dataeva', $editor, $this->dataset); $editColumn->SetAllowSetToNull(true); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); // // Edit column for datains field // $editor = new DateTimeEdit('datains_edit', false, 'd-m-Y', GetFirstDayOfWeek()); $editColumn = new CustomEditColumn('Data ins', 'datains', $editor, $this->dataset); $editColumn->SetAllowSetToNull(true); $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 CreateGrid() { $result = new Grid($this, $this->dataset, 'listino_articoliGrid'); if ($this->GetSecurityInfo()->HasDeleteGrant()) { $result->SetAllowDeleteSelected(false); } else { $result->SetAllowDeleteSelected(false); } ApplyCommonPageSettings($this, $result); $result->SetUseImagesForActions(true); $result->SetUseFixedHeader(false); $result->SetShowLineNumbers(true); $result->SetAllowOrdering(false); $result->SetHighlightRowAtHover(false); $result->SetWidth(''); $result->BeforeUpdateRecord->AddListener('listino_articoliGrid' . '_' . 'BeforeUpdateRecord', $this); $result->BeforeInsertRecord->AddListener('listino_articoliGrid' . '_' . 'BeforeInsertRecord', $this); $this->CreateGridSearchControl($result); $this->CreateGridAdvancedSearchControl($result); $this->AddFieldColumns($result); $this->AddSingleRecordViewColumns($result); $this->AddEditColumns($result); $this->AddInsertColumns($result); $this->AddPrintColumns($result); $this->AddExportColumns($result); $this->AddOperationsColumns($result); $this->SetShowPageList(true); $this->SetHidePageListByDefault(false); $this->SetExportToExcelAvailable(false); $this->SetExportToWordAvailable(false); $this->SetExportToXmlAvailable(false); $this->SetExportToCsvAvailable(false); $this->SetExportToPdfAvailable(false); $this->SetPrinterFriendlyAvailable(false); $this->SetSimpleSearchAvailable(false); $this->SetAdvancedSearchAvailable(false); $this->SetFilterRowAvailable(true); $this->SetVisualEffectsEnabled(true); $this->SetShowTopPageNavigator(true); $this->SetShowBottomPageNavigator(false); // // Http Handlers // // // View column for lisdesc field // $column = new TextViewColumn('lisdesc', 'Descrizione', $this->dataset); $column->SetOrderable(true); $handler = new ShowTextBlobHandler($this->dataset, $this, 'listino_articoliGrid_lisdesc_handler_list', $column); GetApplication()->RegisterHTTPHandler($handler); // // View column for lisdesc field // $column = new TextViewColumn('lisdesc', 'Descrizione', $this->dataset); $column->SetOrderable(true); $handler = new ShowTextBlobHandler($this->dataset, $this, 'listino_articoliGrid_lisdesc_handler_view', $column); GetApplication()->RegisterHTTPHandler($handler); $lookupDataset = new TableDataset(new MyPDOConnectionFactory(), GetConnectionOptions(), '`elenco_articoli_view`'); $field = new StringField('art-codart'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, false); $field = new StringField('descrizione'); $lookupDataset->AddField($field, false); $lookupDataset->setOrderByField('descrizione', GetOrderTypeAsSQL(otAscending)); $lookupDataset->AddCustomCondition(EnvVariablesUtils::EvaluateVariableTemplate($this->GetColumnVariableContainer(), '')); $handler = new DynamicSearchHandler($lookupDataset, $this, 'edit_lis-codart_descrizione_search', 'art-codart', 'descrizione', null); GetApplication()->RegisterHTTPHandler($handler); $lookupDataset = new TableDataset(new MyPDOConnectionFactory(), GetConnectionOptions(), '`elenco_articoli_view`'); $field = new StringField('art-codart'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, false); $field = new StringField('descrizione'); $lookupDataset->AddField($field, false); $lookupDataset->setOrderByField('descrizione', GetOrderTypeAsSQL(otAscending)); $lookupDataset->AddCustomCondition(EnvVariablesUtils::EvaluateVariableTemplate($this->GetColumnVariableContainer(), '')); $handler = new DynamicSearchHandler($lookupDataset, $this, 'insert_lis-codart_descrizione_search', 'art-codart', 'descrizione', null); GetApplication()->RegisterHTTPHandler($handler); return $result; }
protected function AddInsertColumns(Grid $grid) { // // Edit column for id_insumo field // $editor = new ComboBox('id_insumo_edit', $this->GetLocalizerCaptions()->GetMessageString('PleaseSelect')); $lookupDataset = new TableDataset( new PgConnectionFactory(), GetConnectionOptions(), '"public"."ods_insumo"'); $field = new IntegerField('id_insumo', null, null, true); $field->SetIsNotNull(true); $lookupDataset->AddField($field, true); $field = new StringField('no_insumo'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, false); $field = new IntegerField('id_tipo_insumo'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, false); $lookupDataset->setOrderByField('no_insumo', GetOrderTypeAsSQL(otAscending)); $editColumn = new LookUpEditColumn( 'Id Insumo', 'id_insumo', $editor, $this->dataset, 'id_insumo', 'no_insumo', $lookupDataset); $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 ofa-numoff field // $editor = new TextEdit('ofa-numoff_edit'); $editColumn = new CustomEditColumn('Numero Offerta', 'ofa-numoff', $editor, $this->dataset); $editColumn->SetAllowSetToNull(true); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); // // Edit column for ofa-codart field // $editor = new ComboBox('ofa-codart_edit', $this->GetLocalizerCaptions()->GetMessageString('PleaseSelect')); $lookupDataset = new TableDataset(new MyPDOConnectionFactory(), GetConnectionOptions(), '`articoli`'); $field = new IntegerField('id', null, null, true); $field->SetIsNotNull(true); $lookupDataset->AddField($field, true); $field = new StringField('art-codart'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, false); $field = new StringField('art-descart'); $lookupDataset->AddField($field, false); $field = new StringField('art-dessup'); $lookupDataset->AddField($field, false); $field = new StringField('art-codprod'); $lookupDataset->AddField($field, false); $field = new StringField('art-codfam'); $lookupDataset->AddField($field, false); $field = new StringField('unita_misura'); $lookupDataset->AddField($field, false); $field = new StringField('art-gruppo-merc'); $lookupDataset->AddField($field, false); $field = new StringField('art-categoria-omogenea'); $lookupDataset->AddField($field, false); $field = new IntegerField('art-lungsmu'); $lookupDataset->AddField($field, false); $field = new DateTimeField('datains'); $lookupDataset->AddField($field, false); $field = new DateTimeField('datamod'); $lookupDataset->AddField($field, false); $lookupDataset->setOrderByField('art-descart', GetOrderTypeAsSQL(otAscending)); $editColumn = new LookUpEditColumn('Codice articolo', 'ofa-codart', $editor, $this->dataset, 'art-codart', 'art-descart', $lookupDataset); $editColumn->SetAllowSetToNull(true); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); // // Edit column for ofa-descart field // $editor = new TextEdit('ofa-descart_edit'); $editor->SetSize(45); $editor->SetMaxLength(45); $editColumn = new CustomEditColumn('Ofa-descart', 'ofa-descart', $editor, $this->dataset); $editColumn->SetAllowSetToNull(true); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); // // Edit column for ofa-lunghezza field // $editor = new TextEdit('ofa-lunghezza_edit'); $editColumn = new CustomEditColumn('Lunghezza', 'ofa-lunghezza', $editor, $this->dataset); $editColumn->SetAllowSetToNull(true); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); // // Edit column for ofa-larghezza field // $editor = new TextEdit('ofa-larghezza_edit'); $editColumn = new CustomEditColumn('Ofa-larghezza', 'ofa-larghezza', $editor, $this->dataset); $editColumn->SetAllowSetToNull(true); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); // // Edit column for ofa-spessore field // $editor = new TextEdit('ofa-spessore_edit'); $editColumn = new CustomEditColumn('Ofa-spessore', 'ofa-spessore', $editor, $this->dataset); $editColumn->SetAllowSetToNull(true); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); // // Edit column for ofa-quantita field // $editor = new TextEdit('ofa-quantita_edit'); $editColumn = new CustomEditColumn('Ofa-quantita', 'ofa-quantita', $editor, $this->dataset); $editColumn->SetAllowSetToNull(true); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); // // Edit column for ofa-przacq-net field // $editor = new TextEdit('ofa-przacq-net_edit'); $editColumn = new CustomEditColumn('Ofa-przacq-net', 'ofa-przacq-net', $editor, $this->dataset); $editColumn->SetAllowSetToNull(true); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); // // Edit column for ofa-przacq-lor field // $editor = new TextEdit('ofa-przacq-lor_edit'); $editColumn = new CustomEditColumn('Ofa-przacq-lor', 'ofa-przacq-lor', $editor, $this->dataset); $editColumn->SetAllowSetToNull(true); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); // // Edit column for ofa-totuni field // $editor = new TextEdit('ofa-totuni_edit'); $editColumn = new CustomEditColumn('Ofa-totuni', 'ofa-totuni', $editor, $this->dataset); $editColumn->SetAllowSetToNull(true); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); // // Edit column for ofa-totunit-fin field // $editor = new TextEdit('ofa-totunit-fin_edit'); $editColumn = new CustomEditColumn('Ofa-totunit-fin', 'ofa-totunit-fin', $editor, $this->dataset); $editColumn->SetAllowSetToNull(true); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); // // Edit column for ofa-totgen field // $editor = new TextEdit('ofa-totgen_edit'); $editColumn = new CustomEditColumn('Ofa-totgen', 'ofa-totgen', $editor, $this->dataset); $editColumn->SetAllowSetToNull(true); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); // // Edit column for ofa-przven field // $editor = new TextEdit('ofa-przven_edit'); $editColumn = new CustomEditColumn('Ofa-przven', 'ofa-przven', $editor, $this->dataset); $editColumn->SetAllowSetToNull(true); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); // // Edit column for datains field // $editor = new DateTimeEdit('datains_edit', true, 'Y-m-d H:i:s', GetFirstDayOfWeek()); $editColumn = new CustomEditColumn('Datains', 'datains', $editor, $this->dataset); $editColumn->SetAllowSetToNull(true); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); // // Edit column for datamod field // $editor = new DateTimeEdit('datamod_edit', true, 'Y-m-d H:i:s', GetFirstDayOfWeek()); $editColumn = new CustomEditColumn('Datamod', 'datamod', $editor, $this->dataset); $editColumn->SetAllowSetToNull(true); $editColumn->SetAllowSetToDefault(true); $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 CreateGridAdvancedSearchControl(Grid $grid) { $this->AdvancedSearchControl = new AdvancedSearchControl('clientiasearch', $this->dataset, $this->GetLocalizerCaptions(), $this->GetColumnVariableContainer(), $this->CreateLinkBuilder()); $this->AdvancedSearchControl->setTimerInterval(1000); $lookupDataset = new TableDataset(new MyPDOConnectionFactory(), GetConnectionOptions(), '`clienti`'); $field = new IntegerField('id', null, null, true); $field->SetIsNotNull(true); $lookupDataset->AddField($field, true); $field = new StringField('cli-codcli'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, false); $field = new StringField('cli-ragsoc'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, false); $field = new StringField('cli-codlis'); $lookupDataset->AddField($field, false); $field = new DateTimeField('datains'); $lookupDataset->AddField($field, false); $field = new DateTimeField('datamod'); $lookupDataset->AddField($field, false); $lookupDataset->setOrderByField('cli-codcli', GetOrderTypeAsSQL(otAscending)); $this->AdvancedSearchControl->AddSearchColumn($this->AdvancedSearchControl->CreateLookupSearchInput('cli-codcli', $this->RenderText('Codice Cliente'), $lookupDataset, 'cli-codcli', 'cli-codcli', false, 8)); $this->AdvancedSearchControl->AddSearchColumn($this->AdvancedSearchControl->CreateStringSearchInput('cli-ragsoc', $this->RenderText('Ragione sociale'))); }
protected function AddInsertColumns(Grid $grid) { // // Edit column for id_tarea_plan field // $editor = new ComboBox('id_tarea_plan_edit', $this->GetLocalizerCaptions()->GetMessageString('PleaseSelect')); $lookupDataset = new TableDataset( new PgConnectionFactory(), GetConnectionOptions(), '"public"."ods_tarea_plan"'); $field = new IntegerField('id_tarea_plan', null, null, true); $field->SetIsNotNull(true); $lookupDataset->AddField($field, true); $field = new IntegerField('id_accion'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, false); $field = new IntegerField('id_bien'); $lookupDataset->AddField($field, false); $field = new IntegerField('id_periodicidad'); $lookupDataset->AddField($field, false); $field = new StringField('ds_detalle'); $lookupDataset->AddField($field, false); $field = new StringField('ds_referencia'); $lookupDataset->AddField($field, false); $field = new IntegerField('id_espacio'); $lookupDataset->AddField($field, false); $lookupDataset->setOrderByField('id_periodicidad', GetOrderTypeAsSQL(otAscending)); $editColumn = new LookUpEditColumn( 'Id Tarea Plan', 'id_tarea_plan', $editor, $this->dataset, 'id_tarea_plan', 'id_periodicidad', $lookupDataset); $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 fe_ejecucion field // $editor = new DateTimeEdit('fe_ejecucion_edit', true, 'Y-m-d H:i:s', GetFirstDayOfWeek()); $editColumn = new CustomEditColumn('Fecha Ejecucion', 'fe_ejecucion', $editor, $this->dataset); $editColumn->SetAllowSetToNull(true); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); // // Edit column for fl_realizada field // $editor = new CheckBox('fl_realizada_edit'); $editColumn = new CustomEditColumn('Fl Realizada', 'fl_realizada', $editor, $this->dataset); $editColumn->SetAllowSetToNull(true); $editColumn->SetAllowSetToDefault(true); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); // // Edit column for ds_observaciones field // $editor = new TextAreaEdit('ds_observaciones_edit', 50, 8); $editColumn = new CustomEditColumn('Ds Observaciones', 'ds_observaciones', $editor, $this->dataset); $editColumn->SetAllowSetToNull(true); $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 id_persona field // $editor = new ComboBox('id_persona_edit', $this->GetLocalizerCaptions()->GetMessageString('PleaseSelect')); $lookupDataset = new TableDataset(new PgConnectionFactory(), GetConnectionOptions(), '"public"."ods_persona"'); $field = new IntegerField('id_persona', null, null, true); $field->SetIsNotNull(true); $lookupDataset->AddField($field, true); $field = new IntegerField('id_tipo_persona'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, false); $field = new StringField('co_dni_cuit'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, false); $field = new StringField('co_legajo'); $lookupDataset->AddField($field, false); $field = new StringField('no_persona'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, false); $field = new IntegerField('id_empresa'); $lookupDataset->AddField($field, false); $field = new IntegerField('id_area'); $lookupDataset->AddField($field, false); $lookupDataset->setOrderByField('id_tipo_persona', GetOrderTypeAsSQL(otAscending)); $editColumn = new LookUpEditColumn('Id Persona', 'id_persona', $editor, $this->dataset, 'id_persona', 'id_tipo_persona', $lookupDataset); $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 id_lugar field // $editor = new ComboBox('id_lugar_edit', $this->GetLocalizerCaptions()->GetMessageString('PleaseSelect')); $lookupDataset = new TableDataset(new PgConnectionFactory(), GetConnectionOptions(), '"public"."ods_lugar"'); $field = new IntegerField('id_lugar', null, null, true); $field->SetIsNotNull(true); $lookupDataset->AddField($field, true); $field = new StringField('co_lugar'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, false); $field = new StringField('no_lugar'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, false); $field = new StringField('ds_direccion'); $lookupDataset->AddField($field, false); $lookupDataset->setOrderByField('co_lugar', GetOrderTypeAsSQL(otAscending)); $editColumn = new LookUpEditColumn('Id Lugar', 'id_lugar', $editor, $this->dataset, 'id_lugar', 'co_lugar', $lookupDataset); $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 id_origen_lectura field // $editor = new ComboBox('id_origen_lectura_edit', $this->GetLocalizerCaptions()->GetMessageString('PleaseSelect')); $lookupDataset = new TableDataset(new PgConnectionFactory(), GetConnectionOptions(), '"public"."ods_origen_lectura"'); $field = new IntegerField('id_origen_lectura'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, true); $field = new StringField('co_origen_lectura'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, false); $field = new StringField('no_origen_lectura'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, false); $lookupDataset->setOrderByField('co_origen_lectura', GetOrderTypeAsSQL(otAscending)); $editColumn = new LookUpEditColumn('Id Origen Lectura', 'id_origen_lectura', $editor, $this->dataset, 'id_origen_lectura', 'co_origen_lectura', $lookupDataset); $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 fe_fecha_lectura field // $editor = new DateTimeEdit('fe_fecha_lectura_edit', true, 'Y-m-d H:i:s', GetFirstDayOfWeek()); $editColumn = new CustomEditColumn('Fe Fecha Lectura', 'fe_fecha_lectura', $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 no_usuario field // $editor = new TextEdit('no_usuario_edit'); $editor->SetSize(10); $editor->SetMaxLength(10); $editColumn = new CustomEditColumn('Nombre Usuario', 'no_usuario', $editor, $this->dataset); $editColumn->SetAllowSetToNull(true); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); // // Edit column for ds_usuario field // $editor = new TextEdit('ds_usuario_edit'); $editor->SetSize(50); $editor->SetMaxLength(50); $editColumn = new CustomEditColumn('Descripción Usuario', 'ds_usuario', $editor, $this->dataset); $editColumn->SetAllowSetToNull(true); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); // // Edit column for co_lector field // $editor = new TextEdit('co_lector_edit'); $editColumn = new CustomEditColumn('Código Lector', 'co_lector', $editor, $this->dataset); $editColumn->SetAllowSetToNull(true); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); // // Edit column for ds_observaciones field // $editor = new TextAreaEdit('ds_observaciones_edit', 50, 8); $editColumn = new CustomEditColumn('Observaciones', 'ds_observaciones', $editor, $this->dataset); $editColumn->SetAllowSetToNull(true); $editColumn->SetAllowSetToDefault(true); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); // // Edit column for id_carga field // $editor = new TextEdit('id_carga_edit'); $editColumn = new CustomEditColumn('Id Carga', 'id_carga', $editor, $this->dataset); $editColumn->SetAllowSetToDefault(true); $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 id_persona field // $editor = new ComboBox('id_persona_edit', $this->GetLocalizerCaptions()->GetMessageString('PleaseSelect')); $lookupDataset = new TableDataset(new PgConnectionFactory(), GetConnectionOptions(), '"public"."ods_persona"'); $field = new IntegerField('id_persona', null, null, true); $field->SetIsNotNull(true); $lookupDataset->AddField($field, true); $field = new IntegerField('id_tipo_persona'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, false); $field = new StringField('co_dni_cuit'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, false); $field = new StringField('co_legajo'); $lookupDataset->AddField($field, false); $field = new StringField('no_persona'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, false); $field = new IntegerField('id_empresa'); $lookupDataset->AddField($field, false); $field = new IntegerField('id_area'); $lookupDataset->AddField($field, false); $lookupDataset->setOrderByField('id_tipo_persona', GetOrderTypeAsSQL(otAscending)); $editColumn = new LookUpEditColumn('Id Persona', 'id_persona', $editor, $this->dataset, 'id_persona', 'id_tipo_persona', $lookupDataset); $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 id_tarea field // $editor = new ComboBox('id_tarea_edit', $this->GetLocalizerCaptions()->GetMessageString('PleaseSelect')); $lookupDataset = new TableDataset(new PgConnectionFactory(), GetConnectionOptions(), '"public"."ods_tarea"'); $field = new IntegerField('id_tarea', null, null, true); $field->SetIsNotNull(true); $lookupDataset->AddField($field, true); $field = new IntegerField('id_tarea_plan'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, false); $field = new DateTimeField('fe_ejecucion'); $lookupDataset->AddField($field, false); $field = new BooleanField('fl_realizada'); $lookupDataset->AddField($field, false); $field = new StringField('ds_observaciones'); $lookupDataset->AddField($field, false); $lookupDataset->setOrderByField('id_tarea_plan', GetOrderTypeAsSQL(otAscending)); $editColumn = new LookUpEditColumn('Id Tarea', 'id_tarea', $editor, $this->dataset, 'id_tarea', 'id_tarea_plan', $lookupDataset); $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 voc-codvoce field // $editor = new TextEdit('voc-codvoce_edit'); $editor->SetSize(5); $editor->SetMaxLength(5); $editColumn = new CustomEditColumn('Codice voce di costo', 'voc-codvoce', $editor, $this->dataset); $validator = new RequiredValidator(StringUtils::Format($this->GetLocalizerCaptions()->GetMessageString('RequiredValidationMessage'), $this->RenderText($editColumn->GetCaption()))); $editor->GetValidatorCollection()->AddValidator($validator); $validator = new NumberValidator(StringUtils::Format($this->GetLocalizerCaptions()->GetMessageString('NumberValidationMessage'), $this->RenderText($editColumn->GetCaption()))); $editor->GetValidatorCollection()->AddValidator($validator); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); // // Edit column for voc-descriz field // $editor = new TextEdit('voc-descriz_edit'); $editor->SetSize(45); $editor->SetMaxLength(45); $editColumn = new CustomEditColumn('Descrizione', 'voc-descriz', $editor, $this->dataset); $editColumn->SetAllowSetToNull(true); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); // // Edit column for voc-semanual field // $editor = new CheckBox('voc-semanual_edit'); $editColumn = new CustomEditColumn('Manuale', 'voc-semanual', $editor, $this->dataset); $editColumn->SetAllowSetToNull(true); $editColumn->SetAllowSetToDefault(true); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); // // Edit column for voc-formula field // $editor = new ComboBox('voc-formula_edit', $this->GetLocalizerCaptions()->GetMessageString('PleaseSelect')); $lookupDataset = new TableDataset(new MyPDOConnectionFactory(), GetConnectionOptions(), '`formule_calcolo`'); $field = new IntegerField('id', null, null, true); $field->SetIsNotNull(true); $lookupDataset->AddField($field, true); $field = new IntegerField('codice'); $lookupDataset->AddField($field, false); $field = new StringField('formula'); $lookupDataset->AddField($field, false); $field = new StringField('critcalc'); $lookupDataset->AddField($field, false); $field = new StringField('descrizione'); $lookupDataset->AddField($field, false); $field = new DateTimeField('datains'); $lookupDataset->AddField($field, false); $field = new DateTimeField('datamod'); $lookupDataset->AddField($field, false); $lookupDataset->setOrderByField('formula', GetOrderTypeAsSQL(otAscending)); $editColumn = new LookUpEditColumn('Formula di calcolo', 'voc-formula', $editor, $this->dataset, 'codice', 'formula', $lookupDataset); $editColumn->SetAllowSetToNull(true); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); // // Edit column for voc-flagart field // $editor = new ComboBox('voc-flagart_edit', $this->GetLocalizerCaptions()->GetMessageString('PleaseSelect')); $editor->AddValue('S', $this->RenderText('Si')); $editor->AddValue('N', $this->RenderText('No')); $editColumn = new CustomEditColumn('Prevede altri articoli', 'voc-flagart', $editor, $this->dataset); $editColumn->SetAllowSetToNull(true); $editColumn->SetInsertDefaultValue($this->RenderText('N')); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); // // Edit column for voc-przunit field // $editor = new TextEdit('voc-przunit_edit'); $editColumn = new CustomEditColumn('Prezzo unitario', 'voc-przunit', $editor, $this->dataset); $editColumn->SetAllowSetToNull(true); $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 art-codart field // $editor = new TextEdit('art-codart_edit'); $editColumn = new CustomEditColumn('Codice articolo', 'art-codart', $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 art-descart field // $editor = new TextEdit('art-descart_edit'); $editor->SetSize(100); $editor->SetMaxLength(300); $editColumn = new CustomEditColumn('Descrizione', 'art-descart', $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 art-codfam field // $editor = new ComboBox('art-codfam_edit', $this->GetLocalizerCaptions()->GetMessageString('PleaseSelect')); $lookupDataset = new TableDataset(new MyPDOConnectionFactory(), GetConnectionOptions(), '`famiglie`'); $field = new IntegerField('id', null, null, true); $field->SetIsNotNull(true); $lookupDataset->AddField($field, true); $field = new StringField('fam-codfam'); $lookupDataset->AddField($field, false); $field = new StringField('fam-descriz'); $lookupDataset->AddField($field, false); $field = new DateTimeField('datains'); $lookupDataset->AddField($field, false); $field = new DateTimeField('datamod'); $lookupDataset->AddField($field, false); $lookupDataset->setOrderByField('fam-descriz', GetOrderTypeAsSQL(otAscending)); $editColumn = new LookUpEditColumn('Famiglia', 'art-codfam', $editor, $this->dataset, 'fam-codfam', 'fam-descriz', $lookupDataset); $editColumn->SetAllowSetToNull(true); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); // // Edit column for art-codprod field // $editor = new TextEdit('art-codprod_edit'); $editor->SetSize(45); $editor->SetMaxLength(45); $editColumn = new CustomEditColumn('Codice Produzione', 'art-codprod', $editor, $this->dataset); $editColumn->SetAllowSetToNull(true); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); // // Edit column for art-gruppo-merc field // $editor = new TextEdit('art-gruppo-merc_edit'); $editor->SetSize(5); $editor->SetMaxLength(5); $editColumn = new CustomEditColumn('Gruppo merceologico', 'art-gruppo-merc', $editor, $this->dataset); $editColumn->SetAllowSetToNull(true); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); // // Edit column for art-categoria-omogenea field // $editor = new TextEdit('art-categoria-omogenea_edit'); $editor->SetSize(5); $editor->SetMaxLength(5); $editColumn = new CustomEditColumn('Categoria omogenea', 'art-categoria-omogenea', $editor, $this->dataset); $editColumn->SetAllowSetToNull(true); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); // // Edit column for unita_misura field // $editor = new TextEdit('unita_misura_edit'); $editor->SetSize(3); $editor->SetMaxLength(3); $editColumn = new CustomEditColumn('Unita Misura', 'unita_misura', $editor, $this->dataset); $editColumn->SetAllowSetToNull(true); $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 art-codfam field // $editor = new ComboBox('art-codfam_edit', $this->GetLocalizerCaptions()->GetMessageString('PleaseSelect')); $lookupDataset = new TableDataset(new MyPDOConnectionFactory(), GetConnectionOptions(), '`famiglie`'); $field = new IntegerField('id', null, null, true); $field->SetIsNotNull(true); $lookupDataset->AddField($field, true); $field = new StringField('fam-codfam'); $lookupDataset->AddField($field, false); $field = new StringField('fam-descriz'); $lookupDataset->AddField($field, false); $field = new DateTimeField('datains'); $lookupDataset->AddField($field, false); $field = new DateTimeField('datamod'); $lookupDataset->AddField($field, false); $lookupDataset->setOrderByField('fam-descriz', GetOrderTypeAsSQL(otAscending)); $editColumn = new LookUpEditColumn('Codice famiglia', 'art-codfam', $editor, $this->dataset, 'fam-codfam', 'fam-descriz', $lookupDataset); $editColumn->SetReadOnly(true); $editColumn->SetAllowSetToNull(true); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); // // Edit column for art-codart field // $editor = new TextEdit('art-codart_edit'); $editor->SetSize(10); $editor->SetMaxLength(10); $editColumn = new CustomEditColumn('Codice Articolo', 'art-codart', $editor, $this->dataset); $editColumn->SetAllowSetToNull(true); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); // // Edit column for art-descart field // $editor = new TextEdit('art-descart_edit'); $editor->SetSize(100); $editor->SetMaxLength(100); $editColumn = new CustomEditColumn('Descrizione', 'art-descart', $editor, $this->dataset); $editColumn->SetAllowSetToNull(true); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); if ($this->GetSecurityInfo()->HasAddGrant()) { $grid->SetShowAddButton(true); $grid->SetShowInlineAddButton(false); } else { $grid->SetShowInlineAddButton(false); $grid->SetShowAddButton(false); } }