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)); $lookupDataset->AddCustomCondition(EnvVariablesUtils::EvaluateVariableTemplate($this->GetColumnVariableContainer(), '%CURRENT_USER_ID% = 1 OR project.lead=%CURRENT_USER_ID%')); $editColumn = new LookUpEditColumn('Parent Project', 'project_id', $editor, $this->dataset, 'project_id', 'project_name', $lookupDataset); $editColumn->SetReadOnly(true); $editColumn->setEnabled(false); $editColumn->SetAllowSetToNull(true); $editColumn->SetInsertDefaultValue($this->RenderText('%project_name%')); $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); $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); // // Edit column for task_name field // $editor = new ComboBox('task_name_edit', $this->GetLocalizerCaptions()->GetMessageString('PleaseSelect')); $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 LookUpEditColumn('Task Name', 'task_name', $editor, $this->dataset, 'Name', 'Name', $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 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('Hrs', '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); $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 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); 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, 'carteraGrid'); if ($this->GetSecurityInfo()->HasDeleteGrant()) { $result->SetAllowDeleteSelected(false); } else { $result->SetAllowDeleteSelected(false); } ApplyCommonPageSettings($this, $result); $result->SetUseImagesForActions(true); $result->SetUseFixedHeader(false); $result->SetShowLineNumbers(false); $result->SetHighlightRowAtHover(false); $result->SetWidth(''); $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(true); $this->SetExportToWordAvailable(true); $this->SetExportToXmlAvailable(true); $this->SetExportToCsvAvailable(true); $this->SetExportToPdfAvailable(true); $this->SetPrinterFriendlyAvailable(true); $this->SetSimpleSearchAvailable(true); $this->SetAdvancedSearchAvailable(true); $this->SetFilterRowAvailable(true); $this->SetVisualEffectsEnabled(true); $this->SetShowTopPageNavigator(true); $this->SetShowBottomPageNavigator(true); // // Http Handlers // $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)); $lookupDataset->AddCustomCondition(EnvVariablesUtils::EvaluateVariableTemplate($this->GetColumnVariableContainer(), '')); $handler = new DynamicSearchHandler($lookupDataset, $this, 'inline_edit_Cliente_RazonSocial_search', 'idClientes', 'RazonSocial', null); GetApplication()->RegisterHTTPHandler($handler); $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)); $lookupDataset->AddCustomCondition(EnvVariablesUtils::EvaluateVariableTemplate($this->GetColumnVariableContainer(), '')); $handler = new DynamicSearchHandler($lookupDataset, $this, 'inline_insert_Cliente_RazonSocial_search', 'idClientes', 'RazonSocial', null); GetApplication()->RegisterHTTPHandler($handler); // // View column for Observaciones field // $column = new TextViewColumn('Observaciones', 'Observaciones', $this->dataset); $column->SetOrderable(true); /* <inline edit column> */ // // 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); $column->SetEditOperationColumn($editColumn); /* </inline edit column> */ /* <inline insert column> */ // // 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); $column->SetInsertOperationColumn($editColumn); /* </inline insert column> */ $handler = new ShowTextBlobHandler($this->dataset, $this, 'Observaciones_handler', $column); GetApplication()->RegisterHTTPHandler($handler); // // View column for Observaciones field // $column = new TextViewColumn('Observaciones', 'Observaciones', $this->dataset); $column->SetOrderable(true); $handler = new ShowTextBlobHandler($this->dataset, $this, 'Observaciones_handler', $column); GetApplication()->RegisterHTTPHandler($handler); $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)); $lookupDataset->AddCustomCondition(EnvVariablesUtils::EvaluateVariableTemplate($this->GetColumnVariableContainer(), '')); $handler = new DynamicSearchHandler($lookupDataset, $this, 'edit_Cliente_RazonSocial_search', 'idClientes', 'RazonSocial', null); GetApplication()->RegisterHTTPHandler($handler); $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)); $lookupDataset->AddCustomCondition(EnvVariablesUtils::EvaluateVariableTemplate($this->GetColumnVariableContainer(), '')); $handler = new DynamicSearchHandler($lookupDataset, $this, 'insert_Cliente_RazonSocial_search', 'idClientes', 'RazonSocial', null); GetApplication()->RegisterHTTPHandler($handler); return $result; }
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_accion field // $editor = new ComboBox('id_accion_edit', $this->GetLocalizerCaptions()->GetMessageString('PleaseSelect')); $lookupDataset = new TableDataset( new PgConnectionFactory(), GetConnectionOptions(), '"public"."ods_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); $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"."ods_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 IntegerField('nu_planta'); $lookupDataset->AddField($field, false); $field = new StringField('co_plano'); $lookupDataset->AddField($field, false); $lookupDataset->setOrderByField('no_espacio', GetOrderTypeAsSQL(otAscending)); $lookupDataset->AddCustomCondition(EnvVariablesUtils::EvaluateVariableTemplate($this->GetColumnVariableContainer(), '1=0')); $editColumn = new LookUpEditColumn( 'Espacio', 'id_espacio', $editor, $this->dataset, 'id_espacio', 'no_espacio', $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"."ods_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); $lookupDataset->setOrderByField('ds_observacion', GetOrderTypeAsSQL(otAscending)); $lookupDataset->AddCustomCondition(EnvVariablesUtils::EvaluateVariableTemplate($this->GetColumnVariableContainer(), '1=0')); $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"."ods_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); 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, 'clientesGrid'); if ($this->GetSecurityInfo()->HasDeleteGrant()) { $result->SetAllowDeleteSelected(false); } else { $result->SetAllowDeleteSelected(false); } ApplyCommonPageSettings($this, $result); $result->SetUseImagesForActions(true); $result->SetUseFixedHeader(false); $result->SetShowLineNumbers(false); $result->SetHighlightRowAtHover(false); $result->SetWidth(''); $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(true); $this->SetExportToWordAvailable(true); $this->SetExportToXmlAvailable(true); $this->SetExportToCsvAvailable(true); $this->SetExportToPdfAvailable(true); $this->SetPrinterFriendlyAvailable(true); $this->SetSimpleSearchAvailable(true); $this->SetAdvancedSearchAvailable(true); $this->SetFilterRowAvailable(true); $this->SetVisualEffectsEnabled(true); $this->SetShowTopPageNavigator(true); $this->SetShowBottomPageNavigator(true); // // Http Handlers // // // View column for RazonSocial field // $column = new TextViewColumn('RazonSocial', 'RazonSocial', $this->dataset); $column->SetOrderable(true); /* <inline edit column> */ // // Edit column for RazonSocial field // $editor = new TextEdit('razonsocial_edit'); $editor->SetSize(100); $editor->SetMaxLength(100); $editColumn = new CustomEditColumn('RazonSocial', 'RazonSocial', $editor, $this->dataset); $validator = new RequiredValidator(StringUtils::Format($this->GetLocalizerCaptions()->GetMessageString('RequiredValidationMessage'), $this->RenderText($editColumn->GetCaption()))); $editor->GetValidatorCollection()->AddValidator($validator); $this->ApplyCommonColumnEditProperties($editColumn); $column->SetEditOperationColumn($editColumn); /* </inline edit column> */ /* <inline insert column> */ // // Edit column for RazonSocial field // $editor = new TextEdit('razonsocial_edit'); $editor->SetSize(100); $editor->SetMaxLength(100); $editColumn = new CustomEditColumn('RazonSocial', 'RazonSocial', $editor, $this->dataset); $validator = new RequiredValidator(StringUtils::Format($this->GetLocalizerCaptions()->GetMessageString('RequiredValidationMessage'), $this->RenderText($editColumn->GetCaption()))); $editor->GetValidatorCollection()->AddValidator($validator); $this->ApplyCommonColumnEditProperties($editColumn); $column->SetInsertOperationColumn($editColumn); /* </inline insert column> */ $handler = new ShowTextBlobHandler($this->dataset, $this, 'RazonSocial_handler', $column); GetApplication()->RegisterHTTPHandler($handler); $lookupDataset = new TableDataset(new MyConnectionFactory(), GetConnectionOptions(), '`cod_departamentos`'); $field = new IntegerField('Cod_dpto'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, true); $field = new StringField('Nombre'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, false); $lookupDataset->SetOrderBy('Nombre', GetOrderTypeAsSQL(otAscending)); $lookupDataset->AddCustomCondition(EnvVariablesUtils::EvaluateVariableTemplate($this->GetColumnVariableContainer(), '')); $handler = new DynamicSearchHandler($lookupDataset, $this, 'inline_edit_Cod_Dpto_Nombre_search', 'Cod_dpto', 'Nombre', null); GetApplication()->RegisterHTTPHandler($handler); $lookupDataset = new TableDataset(new MyConnectionFactory(), GetConnectionOptions(), '`cod_departamentos`'); $field = new IntegerField('Cod_dpto'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, true); $field = new StringField('Nombre'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, false); $lookupDataset->SetOrderBy('Nombre', GetOrderTypeAsSQL(otAscending)); $lookupDataset->AddCustomCondition(EnvVariablesUtils::EvaluateVariableTemplate($this->GetColumnVariableContainer(), '')); $handler = new DynamicSearchHandler($lookupDataset, $this, 'inline_insert_Cod_Dpto_Nombre_search', 'Cod_dpto', 'Nombre', null); GetApplication()->RegisterHTTPHandler($handler); $lookupDataset = new TableDataset(new MyConnectionFactory(), GetConnectionOptions(), '`cod_paises`'); $field = new IntegerField('Codigo'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, true); $field = new StringField('Pais'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, false); $lookupDataset->SetOrderBy('Pais', GetOrderTypeAsSQL(otAscending)); $lookupDataset->AddCustomCondition(EnvVariablesUtils::EvaluateVariableTemplate($this->GetColumnVariableContainer(), '')); $handler = new DynamicSearchHandler($lookupDataset, $this, 'inline_edit_Pais_Domicilio_Pais_search', 'Codigo', 'Pais', null); GetApplication()->RegisterHTTPHandler($handler); $lookupDataset = new TableDataset(new MyConnectionFactory(), GetConnectionOptions(), '`cod_paises`'); $field = new IntegerField('Codigo'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, true); $field = new StringField('Pais'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, false); $lookupDataset->SetOrderBy('Pais', GetOrderTypeAsSQL(otAscending)); $lookupDataset->AddCustomCondition(EnvVariablesUtils::EvaluateVariableTemplate($this->GetColumnVariableContainer(), '')); $handler = new DynamicSearchHandler($lookupDataset, $this, 'inline_insert_Pais_Domicilio_Pais_search', 'Codigo', 'Pais', null); GetApplication()->RegisterHTTPHandler($handler); // // View column for Telefono field // $column = new TextViewColumn('Telefono', 'Telefono', $this->dataset); $column->SetOrderable(true); /* <inline edit column> */ // // Edit column for Telefono field // $editor = new TextEdit('telefono_edit'); $editor->SetSize(100); $editor->SetMaxLength(100); $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); $column->SetEditOperationColumn($editColumn); /* </inline edit column> */ /* <inline insert column> */ // // Edit column for Telefono field // $editor = new TextEdit('telefono_edit'); $editor->SetSize(100); $editor->SetMaxLength(100); $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); $column->SetInsertOperationColumn($editColumn); /* </inline insert column> */ $handler = new ShowTextBlobHandler($this->dataset, $this, 'Telefono_handler', $column); GetApplication()->RegisterHTTPHandler($handler); // // View column for Contacto field // $column = new TextViewColumn('Contacto', 'Contacto', $this->dataset); $column->SetOrderable(true); /* <inline edit column> */ // // Edit column for Contacto field // $editor = new TextEdit('contacto_edit'); $editor->SetSize(100); $editor->SetMaxLength(100); $editColumn = new CustomEditColumn('Contacto', 'Contacto', $editor, $this->dataset); $editColumn->SetAllowSetToNull(true); $this->ApplyCommonColumnEditProperties($editColumn); $column->SetEditOperationColumn($editColumn); /* </inline edit column> */ /* <inline insert column> */ // // Edit column for Contacto field // $editor = new TextEdit('contacto_edit'); $editor->SetSize(100); $editor->SetMaxLength(100); $editColumn = new CustomEditColumn('Contacto', 'Contacto', $editor, $this->dataset); $editColumn->SetAllowSetToNull(true); $this->ApplyCommonColumnEditProperties($editColumn); $column->SetInsertOperationColumn($editColumn); /* </inline insert column> */ $handler = new ShowTextBlobHandler($this->dataset, $this, 'Contacto_handler', $column); GetApplication()->RegisterHTTPHandler($handler); // // View column for RazonSocial field // $column = new TextViewColumn('RazonSocial', 'RazonSocial', $this->dataset); $column->SetOrderable(true); $handler = new ShowTextBlobHandler($this->dataset, $this, 'RazonSocial_handler', $column); GetApplication()->RegisterHTTPHandler($handler); // // View column for Telefono field // $column = new TextViewColumn('Telefono', 'Telefono', $this->dataset); $column->SetOrderable(true); $handler = new ShowTextBlobHandler($this->dataset, $this, 'Telefono_handler', $column); GetApplication()->RegisterHTTPHandler($handler); // // View column for Contacto field // $column = new TextViewColumn('Contacto', 'Contacto', $this->dataset); $column->SetOrderable(true); $handler = new ShowTextBlobHandler($this->dataset, $this, 'Contacto_handler', $column); GetApplication()->RegisterHTTPHandler($handler); $lookupDataset = new TableDataset(new MyConnectionFactory(), GetConnectionOptions(), '`cod_departamentos`'); $field = new IntegerField('Cod_dpto'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, true); $field = new StringField('Nombre'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, false); $lookupDataset->SetOrderBy('Nombre', GetOrderTypeAsSQL(otAscending)); $lookupDataset->AddCustomCondition(EnvVariablesUtils::EvaluateVariableTemplate($this->GetColumnVariableContainer(), '')); $handler = new DynamicSearchHandler($lookupDataset, $this, 'edit_Cod_Dpto_Nombre_search', 'Cod_dpto', 'Nombre', null); GetApplication()->RegisterHTTPHandler($handler); $lookupDataset = new TableDataset(new MyConnectionFactory(), GetConnectionOptions(), '`cod_paises`'); $field = new IntegerField('Codigo'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, true); $field = new StringField('Pais'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, false); $lookupDataset->SetOrderBy('Pais', GetOrderTypeAsSQL(otAscending)); $lookupDataset->AddCustomCondition(EnvVariablesUtils::EvaluateVariableTemplate($this->GetColumnVariableContainer(), '')); $handler = new DynamicSearchHandler($lookupDataset, $this, 'edit_Pais_Domicilio_Pais_search', 'Codigo', 'Pais', null); GetApplication()->RegisterHTTPHandler($handler); $lookupDataset = new TableDataset(new MyConnectionFactory(), GetConnectionOptions(), '`cod_departamentos`'); $field = new IntegerField('Cod_dpto'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, true); $field = new StringField('Nombre'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, false); $lookupDataset->SetOrderBy('Nombre', GetOrderTypeAsSQL(otAscending)); $lookupDataset->AddCustomCondition(EnvVariablesUtils::EvaluateVariableTemplate($this->GetColumnVariableContainer(), '')); $handler = new DynamicSearchHandler($lookupDataset, $this, 'insert_Cod_Dpto_Nombre_search', 'Cod_dpto', 'Nombre', null); GetApplication()->RegisterHTTPHandler($handler); $lookupDataset = new TableDataset(new MyConnectionFactory(), GetConnectionOptions(), '`cod_paises`'); $field = new IntegerField('Codigo'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, true); $field = new StringField('Pais'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, false); $lookupDataset->SetOrderBy('Pais', GetOrderTypeAsSQL(otAscending)); $lookupDataset->AddCustomCondition(EnvVariablesUtils::EvaluateVariableTemplate($this->GetColumnVariableContainer(), '')); $handler = new DynamicSearchHandler($lookupDataset, $this, 'insert_Pais_Domicilio_Pais_search', 'Codigo', 'Pais', null); GetApplication()->RegisterHTTPHandler($handler); return $result; }
protected function CreateGrid() { $result = new Grid($this, $this->dataset, 'taskGrid'); if ($this->GetSecurityInfo()->HasDeleteGrant()) { $result->SetAllowDeleteSelected(true); } else { $result->SetAllowDeleteSelected(false); } ApplyCommonPageSettings($this, $result); $result->SetUseImagesForActions(true); $result->SetUseFixedHeader(false); $result->SetShowLineNumbers(false); $result->SetHighlightRowAtHover(false); $result->SetWidth(''); $result->OnCustomRenderTotal->AddListener('taskGrid' . '_' . 'OnCustomRenderTotal', $this); $result->BeforeUpdateRecord->AddListener('taskGrid' . '_' . 'BeforeUpdateRecord', $this); $result->BeforeDeleteRecord->AddListener('taskGrid' . '_' . 'BeforeDeleteRecord', $this); $result->BeforeInsertRecord->AddListener('taskGrid' . '_' . 'BeforeInsertRecord', $this); $this->CreateGridSearchControl($result); $this->CreateGridAdvancedSearchControl($result); $this->AddOperationsColumns($result); $this->AddFieldColumns($result); $this->AddSingleRecordViewColumns($result); $this->AddEditColumns($result); $this->AddInsertColumns($result); $this->AddPrintColumns($result); $this->AddExportColumns($result); $this->SetShowPageList(true); $this->SetHidePageListByDefault(false); $this->SetExportToExcelAvailable(true); $this->SetExportToWordAvailable(true); $this->SetExportToXmlAvailable(false); $this->SetExportToCsvAvailable(true); $this->SetExportToPdfAvailable(true); $this->SetPrinterFriendlyAvailable(true); $this->SetSimpleSearchAvailable(true); $this->SetAdvancedSearchAvailable(true); $this->SetFilterRowAvailable(true); $this->SetVisualEffectsEnabled(true); $this->SetShowTopPageNavigator(true); $this->SetShowBottomPageNavigator(true); // // Http Handlers // $pageView = new timesheetDetailView0taskPage($this, 'Timesheet', 'Timesheet', array('task_id'), GetCurrentUserGrantForDataSource('task.timesheet'), 'UTF-8', 20, 'timesheetDetailEdit0task_handler'); $pageView->SetRecordPermission(GetCurrentUserRecordPermissionsForDataSource('task.timesheet')); $handler = new PageHTTPHandler('timesheetDetailView0task_handler', $pageView); GetApplication()->RegisterHTTPHandler($handler); $pageEdit = new timesheetDetailEdit0taskPage($this, array('task_id'), array('task_id'), $this->GetForeingKeyFields(), $this->CreateMasterDetailRecordGridFortimesheetDetailEdit0taskGrid(), $this->dataset, GetCurrentUserGrantForDataSource('task.timesheet'), 'UTF-8'); $pageEdit->SetRecordPermission(GetCurrentUserRecordPermissionsForDataSource('task.timesheet')); $pageEdit->SetShortCaption('Timesheet'); $pageEdit->SetHeader(GetPagesHeader()); $pageEdit->SetFooter(GetPagesFooter()); $pageEdit->SetCaption('Timesheet'); $pageEdit->SetHttpHandlerName('timesheetDetailEdit0task_handler'); $handler = new PageHTTPHandler('timesheetDetailEdit0task_handler', $pageEdit); GetApplication()->RegisterHTTPHandler($handler); // // View column for Name field // $column = new TextViewColumn('task_name_Name', 'Name', $this->dataset); $column->SetOrderable(true); $handler = new ShowTextBlobHandler($this->dataset, $this, 'taskGrid_Name_handler_list', $column); GetApplication()->RegisterHTTPHandler($handler); // // View column for notes field // $column = new TextViewColumn('notes', 'Notes', $this->dataset); $column->SetOrderable(true); $handler = new ShowTextBlobHandler($this->dataset, $this, 'taskGrid_notes_handler_list', $column); GetApplication()->RegisterHTTPHandler($handler); // // View column for Name field // $column = new TextViewColumn('task_name_Name', 'Name', $this->dataset); $column->SetOrderable(true); $handler = new ShowTextBlobHandler($this->dataset, $this, 'taskGrid_Name_handler_view', $column); GetApplication()->RegisterHTTPHandler($handler); // // View column for notes field // $column = new TextViewColumn('notes', 'Notes', $this->dataset); $column->SetOrderable(true); $handler = new ShowTextBlobHandler($this->dataset, $this, 'taskGrid_notes_handler_view', $column); GetApplication()->RegisterHTTPHandler($handler); $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)); $lookupDataset->AddCustomCondition(EnvVariablesUtils::EvaluateVariableTemplate($this->GetColumnVariableContainer(), '')); $handler = new DynamicSearchHandler($lookupDataset, $this, 'edit_task_name_Name_search', 'Name', 'Name', null); GetApplication()->RegisterHTTPHandler($handler); $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)); $lookupDataset->AddCustomCondition(EnvVariablesUtils::EvaluateVariableTemplate($this->GetColumnVariableContainer(), '')); $handler = new DynamicSearchHandler($lookupDataset, $this, 'insert_task_name_Name_search', 'Name', 'Name', null); GetApplication()->RegisterHTTPHandler($handler); return $result; }
protected function CreateGridAdvancedSearchControl(Grid $grid) { $this->AdvancedSearchControl = new AdvancedSearchControl('timesheetasearch', $this->dataset, $this->GetLocalizerCaptions(), $this->GetColumnVariableContainer(), $this->CreateLinkBuilder()); $this->AdvancedSearchControl->setTimerInterval(1000); $this->AdvancedSearchControl->AddSearchColumn($this->AdvancedSearchControl->CreateStringSearchInput('name', $this->RenderText('Name'))); $lookupDataset = new TableDataset(new MyConnectionFactory(), GetConnectionOptions(), '`task`'); $field = new IntegerField('task_id', null, null, true); $field->SetIsNotNull(true); $lookupDataset->AddField($field, true); $field = new IntegerField('project_id'); $lookupDataset->AddField($field, false); $field = new StringField('assigned_to'); $lookupDataset->AddField($field, false); $field = new DateField('date_start'); $lookupDataset->AddField($field, false); $field = new DateField('date_end'); $lookupDataset->AddField($field, false); $field = new StringField('task_name'); $lookupDataset->AddField($field, false); $field = new StringField('notes'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, false); $field = new IntegerField('hrs'); $lookupDataset->AddField($field, false); $field = new StringField('wo'); $lookupDataset->AddField($field, false); $field = new IntegerField('staff_id'); $lookupDataset->AddField($field, false); $lookupDataset->SetOrderBy('task_name', GetOrderTypeAsSQL(otAscending)); $lookupDataset->AddCustomCondition(EnvVariablesUtils::EvaluateVariableTemplate($this->GetColumnVariableContainer(), ' task.assigned_to=%CURRENT_USER_ID%')); $this->AdvancedSearchControl->AddSearchColumn($this->AdvancedSearchControl->CreateLookupSearchInput('task_id', $this->RenderText('Task'), $lookupDataset, 'task_id', 'task_name', false, 8)); $this->AdvancedSearchControl->AddSearchColumn($this->AdvancedSearchControl->CreateStringSearchInput('hours', $this->RenderText('Hours'))); $this->AdvancedSearchControl->AddSearchColumn($this->AdvancedSearchControl->CreateStringSearchInput('notes', $this->RenderText('Notes'))); $this->AdvancedSearchControl->AddSearchColumn($this->AdvancedSearchControl->CreateDateTimeSearchInput('date', $this->RenderText('Date'), 'Y-m-d')); }
protected function AddFieldColumns(Grid $grid) { // // View column for name field // $column = new TextViewColumn('name', 'Name', $this->dataset); $column->SetOrderable(true); /* <inline edit column> */ // // Edit column for name field // $editor = new TextEdit('name_edit'); $editColumn = new CustomEditColumn('Name', 'name', $editor, $this->dataset); $editColumn->setVisible(false); $validator = new RequiredValidator(StringUtils::Format($this->GetLocalizerCaptions()->GetMessageString('RequiredValidationMessage'), $this->RenderText($editColumn->GetCaption()))); $editor->GetValidatorCollection()->AddValidator($validator); $this->ApplyCommonColumnEditProperties($editColumn); $column->SetEditOperationColumn($editColumn); /* </inline edit column> */ /* <inline insert column> */ // // Edit column for name field // $editor = new TextEdit('name_edit'); $editColumn = new CustomEditColumn('Name', 'name', $editor, $this->dataset); $editColumn->setVisible(false); $editColumn->SetInsertDefaultValue($this->RenderText('%CURRENT_USER_NAME%')); $validator = new RequiredValidator(StringUtils::Format($this->GetLocalizerCaptions()->GetMessageString('RequiredValidationMessage'), $this->RenderText($editColumn->GetCaption()))); $editor->GetValidatorCollection()->AddValidator($validator); $this->ApplyCommonColumnEditProperties($editColumn); $column->SetInsertOperationColumn($editColumn); /* </inline insert column> */ $column->SetDescription($this->RenderText('')); $column->SetFixedWidth(null); $grid->AddViewColumn($column); // // View column for date field // $column = new DateTimeViewColumn('date', 'Date', $this->dataset); $column->SetDateTimeFormat('Y-m-d'); $column->SetOrderable(true); /* <inline edit column> */ // // Edit column for date field // $editor = new DateTimeEdit('date_edit', false, 'Y-m-d H:i:s', GetFirstDayOfWeek()); $editColumn = new CustomEditColumn('Date', 'date', $editor, $this->dataset); $validator = new RequiredValidator(StringUtils::Format($this->GetLocalizerCaptions()->GetMessageString('RequiredValidationMessage'), $this->RenderText($editColumn->GetCaption()))); $editor->GetValidatorCollection()->AddValidator($validator); $this->ApplyCommonColumnEditProperties($editColumn); $column->SetEditOperationColumn($editColumn); /* </inline edit column> */ /* <inline insert column> */ // // Edit column for date field // $editor = new DateTimeEdit('date_edit', false, 'Y-m-d H:i:s', GetFirstDayOfWeek()); $editColumn = new CustomEditColumn('Date', 'date', $editor, $this->dataset); $validator = new RequiredValidator(StringUtils::Format($this->GetLocalizerCaptions()->GetMessageString('RequiredValidationMessage'), $this->RenderText($editColumn->GetCaption()))); $editor->GetValidatorCollection()->AddValidator($validator); $this->ApplyCommonColumnEditProperties($editColumn); $column->SetInsertOperationColumn($editColumn); /* </inline insert column> */ $column->SetDescription($this->RenderText('')); $column->SetFixedWidth(null); $grid->AddViewColumn($column); // // View column for Task field // $column = new TextViewColumn('task_id_Task', 'Project & Task', $this->dataset); $column->SetOrderable(true); /* <inline edit column> */ // // Edit column for task_id field // $editor = new ComboBox('task_id_edit', $this->GetLocalizerCaptions()->GetMessageString('PleaseSelect')); $lookupDataset = new TableDataset(new MyConnectionFactory(), GetConnectionOptions(), '`taskview`'); $field = new IntegerField('task_id'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, false); $field = new IntegerField('project_id'); $lookupDataset->AddField($field, false); $field = new StringField('assigned_to'); $lookupDataset->AddField($field, false); $field = new DateField('date_start'); $lookupDataset->AddField($field, false); $field = new DateField('date_end'); $lookupDataset->AddField($field, false); $field = new StringField('task_name'); $lookupDataset->AddField($field, false); $field = new StringField('notes'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, false); $field = new IntegerField('hrs'); $lookupDataset->AddField($field, false); $field = new StringField('wo'); $lookupDataset->AddField($field, false); $field = new IntegerField('staff_id'); $lookupDataset->AddField($field, false); $field = new StringField('Task'); $lookupDataset->AddField($field, false); $field = new StringField('Assigned'); $lookupDataset->AddField($field, false); $lookupDataset->SetOrderBy('Task', GetOrderTypeAsSQL(otAscending)); $lookupDataset->AddCustomCondition(EnvVariablesUtils::EvaluateVariableTemplate($this->GetColumnVariableContainer(), 'assigned_to=%CURRENT_USER_ID%')); $editColumn = new LookUpEditColumn('Project & Task', 'task_id', $editor, $this->dataset, 'task_id', 'Task', $lookupDataset); $validator = new RequiredValidator(StringUtils::Format($this->GetLocalizerCaptions()->GetMessageString('RequiredValidationMessage'), $this->RenderText($editColumn->GetCaption()))); $editor->GetValidatorCollection()->AddValidator($validator); $this->ApplyCommonColumnEditProperties($editColumn); $column->SetEditOperationColumn($editColumn); /* </inline edit column> */ /* <inline insert column> */ // // Edit column for task_id field // $editor = new ComboBox('task_id_edit', $this->GetLocalizerCaptions()->GetMessageString('PleaseSelect')); $lookupDataset = new TableDataset(new MyConnectionFactory(), GetConnectionOptions(), '`taskview`'); $field = new IntegerField('task_id'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, false); $field = new IntegerField('project_id'); $lookupDataset->AddField($field, false); $field = new StringField('assigned_to'); $lookupDataset->AddField($field, false); $field = new DateField('date_start'); $lookupDataset->AddField($field, false); $field = new DateField('date_end'); $lookupDataset->AddField($field, false); $field = new StringField('task_name'); $lookupDataset->AddField($field, false); $field = new StringField('notes'); $field->SetIsNotNull(true); $lookupDataset->AddField($field, false); $field = new IntegerField('hrs'); $lookupDataset->AddField($field, false); $field = new StringField('wo'); $lookupDataset->AddField($field, false); $field = new IntegerField('staff_id'); $lookupDataset->AddField($field, false); $field = new StringField('Task'); $lookupDataset->AddField($field, false); $field = new StringField('Assigned'); $lookupDataset->AddField($field, false); $lookupDataset->SetOrderBy('Task', GetOrderTypeAsSQL(otAscending)); $lookupDataset->AddCustomCondition(EnvVariablesUtils::EvaluateVariableTemplate($this->GetColumnVariableContainer(), 'assigned_to=%CURRENT_USER_ID%')); $editColumn = new LookUpEditColumn('Project & Task', 'task_id', $editor, $this->dataset, 'task_id', 'Task', $lookupDataset); $validator = new RequiredValidator(StringUtils::Format($this->GetLocalizerCaptions()->GetMessageString('RequiredValidationMessage'), $this->RenderText($editColumn->GetCaption()))); $editor->GetValidatorCollection()->AddValidator($validator); $this->ApplyCommonColumnEditProperties($editColumn); $column->SetInsertOperationColumn($editColumn); /* </inline insert column> */ $column->SetDescription($this->RenderText('')); $column->SetFixedWidth(null); $grid->AddViewColumn($column); // // View column for hours field // $column = new TextViewColumn('hours', 'Hours', $this->dataset); $column->SetOrderable(true); /* <inline edit column> */ // // Edit column for hours field // $editor = new TextEdit('hours_edit'); $editColumn = new CustomEditColumn('Hours', 'hours', $editor, $this->dataset); $validator = new RequiredValidator(StringUtils::Format($this->GetLocalizerCaptions()->GetMessageString('RequiredValidationMessage'), $this->RenderText($editColumn->GetCaption()))); $editor->GetValidatorCollection()->AddValidator($validator); $this->ApplyCommonColumnEditProperties($editColumn); $column->SetEditOperationColumn($editColumn); /* </inline edit column> */ /* <inline insert column> */ // // Edit column for hours field // $editor = new TextEdit('hours_edit'); $editColumn = new CustomEditColumn('Hours', 'hours', $editor, $this->dataset); $validator = new RequiredValidator(StringUtils::Format($this->GetLocalizerCaptions()->GetMessageString('RequiredValidationMessage'), $this->RenderText($editColumn->GetCaption()))); $editor->GetValidatorCollection()->AddValidator($validator); $this->ApplyCommonColumnEditProperties($editColumn); $column->SetInsertOperationColumn($editColumn); /* </inline insert column> */ $column->SetDescription($this->RenderText('')); $column->SetFixedWidth(null); $grid->AddViewColumn($column); // // View column for notes field // $column = new TextViewColumn('notes', 'Notes', $this->dataset); $column->SetOrderable(true); /* <inline edit column> */ // // Edit column for notes field // $editor = new TextEdit('notes_edit'); $editColumn = new CustomEditColumn('Notes', 'notes', $editor, $this->dataset); $editColumn->SetAllowSetToNull(true); $this->ApplyCommonColumnEditProperties($editColumn); $column->SetEditOperationColumn($editColumn); /* </inline edit column> */ /* <inline insert column> */ // // Edit column for notes field // $editor = new TextEdit('notes_edit'); $editColumn = new CustomEditColumn('Notes', 'notes', $editor, $this->dataset); $editColumn->SetAllowSetToNull(true); $this->ApplyCommonColumnEditProperties($editColumn); $column->SetInsertOperationColumn($editColumn); /* </inline insert column> */ $column->SetDescription($this->RenderText('')); $column->SetFixedWidth(null); $grid->AddViewColumn($column); }