function Main()
{
header('Content-Type: text/html; charset=utf-8');
if (!isset($_COOKIE['siacc_lang'])) {
$_COOKIE['siacc_lang'] = '1';
}
$mensagem = $_GET["m"];
$tpl = file_get_contents("tpl/index.html");
$rs = null;
if (!Comuns::ArrayObj("select Codigo, Nome from sisidiomas /*where publicado = 1*/", $rs)) {
echo $rs;
}
$cmb = new ComboBox("selIdioma", $rs, "Codigo", "Nome");
$tpl = str_replace("<!--selIdioma-->", $cmb->RenderHTML($_COOKIE['siacc_lang']), $tpl);
if (isset($mensagem) && $mensagem != "") {
$msg = '<div id="errologin">' . base64_decode($mensagem) . '</div>';
$tpl = str_replace("<!--Mensagem-->", $msg, $tpl);
} else {
$tpl = str_replace("<!--Mensagem-->", "", $tpl);
}
if (strpos(strtolower($_SERVER['HTTP_HOST']), "localhost") === false) {
$tpl = str_replace("<!--analytics-->", Comuns::GOOGLE_ANALYTICS, $tpl);
} else {
$tpl = str_replace("<!--analytics-->", "", $tpl);
}
echo Comuns::Idioma($tpl, "login");
}
function RenderOpcoes()
{
$u = unserialize($_SESSION['usu']);
$tpl = file_get_contents("tpl/frm-opcoeslogin.html");
$grupos = null;
foreach ($u->getGrupos() as $grupo) {
$grupos .= $grupos != "" ? ", " . $grupo : $grupo;
}
$sql = "select Codigo, Descricao from mesgrupousuario where Codigo IN(" . $grupos . ") and Codigo <> 3;";
$cnn = Conexao2::getInstance();
$cmd = $cnn->prepare($sql);
$cmd->execute();
$dsPerfis = $cmd->fetchAll(PDO::FETCH_OBJ);
if ($grupos) {
$cmbGrupos = new ComboBox();
$cmbGrupos->ID("selPerfil");
$cmbGrupos->setDataSet($dsPerfis);
$cmbGrupos->setDataValueField("Codigo");
$cmbGrupos->setDataTextField("Descricao");
$cmbGrupos->setDefaultValue("0");
$cmbGrupos->setDefaultText("@lng[Selecione]");
$cmbGrupos->cssClass("campo req");
$htmlCombo = $cmbGrupos->RenderHTML();
} else {
$htmlCombo = "<p>@lng[Não existem perfis associados ao seu usuário]</p>";
}
$tpl = str_replace("<!--Perfis-->", $htmlCombo, $tpl);
echo Comuns::Idioma($tpl);
}
function Main()
{
$html = "";
if ($_GET['id']) {
$idioma = $_GET['id'];
$sql = "select e.Codigo, e.Expressao, t.Expressao as Traducao ";
$sql .= "from sisexpressoes e left outer join sistraducoes t on t.CodExpressao = e.Codigo and t.CodIdioma = :pCodIdioma ";
$sql .= "order by e.Expressao";
$cnn = Conexao2::getInstance();
$cmd = $cnn->prepare($sql);
$cmd->bindParam(":pCodIdioma", $idioma, PDO::PARAM_INT);
$cmd->execute();
$total = 0;
$feito = 0;
if ($cmd->errorCode() == Comuns::QUERY_OK) {
$html = '<table class="listadados">';
$html .= '<tr class="head"><th>@lng[Expressão]</th><th>@lng[Tradução]</th></tr>';
while ($expressao = $cmd->fetch(PDO::FETCH_OBJ)) {
$html .= '<tr>';
$html .= ' <td><label>' . $expressao->Expressao . '</label></td>';
$html .= ' <td>';
$html .= ' <input type="text" name="exp_' . $expressao->Codigo . '" id="exp_' . $expressao->Codigo . '" value="' . ($expressao->Traducao == null ? '' : $expressao->Traducao) . '" class="campo campomedio" onblur="javascript:fntGravaTraducao(' . $expressao->Codigo . ');" /></td>';
$html .= ' <input type="hidden" name="h_exp_' . $expressao->Codigo . '" id="h_exp_' . $expressao->Codigo . '" value="' . ($expressao->Traducao == null ? '' : $expressao->Traducao) . '" />';
$html .= ' </td>';
$html .= '</tr>';
$total++;
$feito += $expressao->Traducao == null ? 0 : 1;
}
$html .= '</table>';
$html = '<div class="info-percentual">@lng[Percentual traduzido:] ' . $feito / $total * 100 . '%</div>' . $html;
} else {
$msg = $cmd->errorInfo();
$html = $msg[2];
}
}
$usu = unserialize($_SESSION['usu']);
$tpl = file_get_contents("tpl/frm-idiomas.html");
$idiomas = null;
Comuns::ArrayObj("select Codigo, Nome from sisidiomas order by Nome", $idiomas);
$cmbIdiomas = new ComboBox("selIdioma", $idiomas, "Codigo", "Nome", "0", "@lng[Selecione]");
$cmbIdiomas->cssClass("campo");
$cmbIdiomas->setSelectedValue($_GET['id'] ? $_GET['id'] : "0");
$cmbIdiomas->Eventos(array("onchange" => "fntBuscaTraducoes()"));
$botoes = Botao::BotaoNovo("fntAddExpressao();", "@lng[Adicionar expressão]");
$botoes .= Botao::BotaoPesquisar("fntBuscaTraducoes();", "@lng[Buscar traduções]");
$tpl = str_replace("<!--telatopo-->", Comuns::GeraTopoPagina($usu), $tpl);
$tpl = str_replace("<!--itens-toolbar-->", $botoes, $tpl);
$tpl = str_replace("<!--selIdioma-->", $cmbIdiomas->RenderHTML(), $tpl);
$tpl = str_replace("<!--expressoes-->", $html, $tpl);
header('Content-Type: text/html; charset=iso-8859-1');
echo Comuns::Idioma($tpl);
}
function fntTelaNovoUsuario()
{
$tpl = file_get_contents("tpl/frm-add-usuario.html");
$sql = "SELECT Codigo, CONCAT(NomeCompleto, CASE WHEN Sigla IS NOT NULL THEN concat(' (', Sigla, ')') ELSE '' END) AS Nome ";
$sql .= "FROM mesinstituicao ORDER BY NomeCompleto;";
$sqlIdi = "select Codigo, Nome from sisidiomas where publicado = 1";
$dsIns = null;
$dsIdi = null;
if (!Comuns::ArrayObj($sql, $dsIns)) {
echo $dsIns;
}
if (!Comuns::ArrayObj($sqlIdi, $dsIdi)) {
echo $dsIdi;
}
$comboIns = new ComboBox("selInstituicao", $dsIns, "Codigo", "Nome", "0", "@lng[Selecione]");
$comboIns->cssClass("campo req");
$htmlCombo = $comboIns->RenderHTML();
$comboIdi = new ComboBox("selIdioma", $dsIdi, "Codigo", "Nome");
$comboIdi->cssClass("campo req");
$htmlComboIdi = $comboIdi->RenderHTML(1);
$tpl = str_replace("<!--selInstituicao-->", $htmlCombo, $tpl);
$tpl = str_replace("<!--selIdioma-->", $htmlComboIdi, $tpl);
echo Comuns::Idioma($tpl);
}
protected function AddInsertColumns(Grid $grid)
{
//
// Edit column for programm_id field
//
$editor = new ComboBox('programm_id_edit', $this->GetLocalizerCaptions()->GetMessageString('PleaseSelect'));
$lookupDataset = new TableDataset(new MyConnectionFactory(), GetConnectionOptions(), '`program`');
$field = new IntegerField('program_id', null, null, true);
$field->SetIsNotNull(true);
$lookupDataset->AddField($field, true);
$field = new StringField('program_name');
$lookupDataset->AddField($field, false);
$field = new StringField('year');
$lookupDataset->AddField($field, false);
$field = new StringField('multi');
$field->SetIsNotNull(true);
$lookupDataset->AddField($field, false);
$field = new StringField('description');
$field->SetIsNotNull(true);
$lookupDataset->AddField($field, false);
$field = new StringField('lead');
$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('progress');
$field->SetIsNotNull(true);
$lookupDataset->AddField($field, false);
$field = new StringField('notes');
$lookupDataset->AddField($field, false);
$lookupDataset->SetOrderBy('program_name', GetOrderTypeAsSQL(otAscending));
$editColumn = new LookUpEditColumn('Project Type', 'programm_id', $editor, $this->dataset, 'program_id', 'program_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 project_name field
//
$editor = new TextEdit('project_name_edit');
$editColumn = new CustomEditColumn('Project Name', 'project_name', $editor, $this->dataset);
$validator = new RequiredValidator(StringUtils::Format($this->GetLocalizerCaptions()->GetMessageString('RequiredValidationMessage'), $this->RenderText($editColumn->GetCaption())));
$editor->GetValidatorCollection()->AddValidator($validator);
$validator = new CustomRegExpValidator('^[A-Za-z0-9 ]+[-]*[A-Za-z0-9 ]*$', StringUtils::Format($this->GetLocalizerCaptions()->GetMessageString('RegExpValidationMessage'), $this->RenderText($editColumn->GetCaption())));
$editor->GetValidatorCollection()->AddValidator($validator);
$this->ApplyCommonColumnEditProperties($editColumn);
$grid->AddInsertColumn($editColumn);
//
// Edit column for date_start field
//
$editor = new DateTimeEdit('date_start_edit', false, 'Y-m-d', GetFirstDayOfWeek());
$editColumn = new CustomEditColumn('Date Start', 'date_start', $editor, $this->dataset);
$editColumn->SetInsertDefaultValue($this->RenderText('%CURRENT_DATE%'));
$validator = new RequiredValidator(StringUtils::Format($this->GetLocalizerCaptions()->GetMessageString('RequiredValidationMessage'), $this->RenderText($editColumn->GetCaption())));
$editor->GetValidatorCollection()->AddValidator($validator);
$this->ApplyCommonColumnEditProperties($editColumn);
$grid->AddInsertColumn($editColumn);
//
// Edit column for date_end field
//
$editor = new DateTimeEdit('date_end_edit', true, 'Y-m-d', GetFirstDayOfWeek());
$editColumn = new CustomEditColumn('Date End', 'date_end', $editor, $this->dataset);
$editColumn->SetInsertDefaultValue($this->RenderText('%CURRENT_DATE%'));
$validator = new RequiredValidator(StringUtils::Format($this->GetLocalizerCaptions()->GetMessageString('RequiredValidationMessage'), $this->RenderText($editColumn->GetCaption())));
$editor->GetValidatorCollection()->AddValidator($validator);
$this->ApplyCommonColumnEditProperties($editColumn);
$grid->AddInsertColumn($editColumn);
//
// Edit column for year field
//
$editor = new TextEdit('year_edit');
$editColumn = new CustomEditColumn('Year', 'year', $editor, $this->dataset);
$editColumn->SetInsertDefaultValue($this->RenderText('2015'));
$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 notes field
//
$editor = new TextAreaEdit('notes_edit', 50, 8);
$editColumn = new CustomEditColumn('Objectives', 'notes', $editor, $this->dataset);
$editColumn->SetAllowSetToNull(true);
$this->ApplyCommonColumnEditProperties($editColumn);
$grid->AddInsertColumn($editColumn);
//
// Edit column for priority field
//
$editor = new ComboBox('priority_edit', $this->GetLocalizerCaptions()->GetMessageString('PleaseSelect'));
$lookupDataset = new TableDataset(new MyConnectionFactory(), GetConnectionOptions(), '`Priority`');
$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('Priority', 'priority', $editor, $this->dataset, 'Name', 'Name', $lookupDataset);
$editColumn->SetCaptionTemplate($this->RenderText('%Name%'));
$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 lead field
//
$editor = new ComboBox('lead_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('Project Lead', 'lead', $editor, $this->dataset, 'staff_id', 'username', $lookupDataset);
$editColumn->SetCaptionTemplate($this->RenderText('%username%'));
$editColumn->SetInsertDefaultValue($this->RenderText('%CURRENT_USER_ID%'));
$validator = new RequiredValidator(StringUtils::Format($this->GetLocalizerCaptions()->GetMessageString('RequiredValidationMessage'), $this->RenderText($editColumn->GetCaption())));
$editor->GetValidatorCollection()->AddValidator($validator);
$this->ApplyCommonColumnEditProperties($editColumn);
$grid->AddInsertColumn($editColumn);
//
// Edit column for approved_budget field
//
$editor = new TextEdit('approved_budget_edit');
$editor->SetPlaceholder($this->RenderText('currency value without comma'));
$editor->SetPrefix($this->RenderText('$'));
$editor->SetSuffix($this->RenderText('.00'));
$editColumn = new CustomEditColumn('Approved Budget', 'approved_budget', $editor, $this->dataset);
$editColumn->SetInsertDefaultValue($this->RenderText('0'));
$validator = new RequiredValidator(StringUtils::Format($this->GetLocalizerCaptions()->GetMessageString('RequiredValidationMessage'), $this->RenderText($editColumn->GetCaption())));
$editor->GetValidatorCollection()->AddValidator($validator);
$validator = new CustomRegExpValidator('^[0-9]*$', StringUtils::Format($this->GetLocalizerCaptions()->GetMessageString('RegExpValidationMessage'), $this->RenderText($editColumn->GetCaption())));
$editor->GetValidatorCollection()->AddValidator($validator);
$this->ApplyCommonColumnEditProperties($editColumn);
$grid->AddInsertColumn($editColumn);
//
// Edit column for budget_spent field
//
$editor = new TextEdit('budget_spent_edit');
$editor->SetPlaceholder($this->RenderText('currency value without comma'));
$editor->SetPrefix($this->RenderText('$'));
$editor->SetSuffix($this->RenderText('.00'));
$editColumn = new CustomEditColumn('Budget Spent', 'budget_spent', $editor, $this->dataset);
$editColumn->SetAllowSetToNull(true);
$editColumn->SetInsertDefaultValue($this->RenderText('0'));
$validator = new CustomRegExpValidator('^[0-9]*$', StringUtils::Format($this->GetLocalizerCaptions()->GetMessageString('RegExpValidationMessage'), $this->RenderText($editColumn->GetCaption())));
$editor->GetValidatorCollection()->AddValidator($validator);
$this->ApplyCommonColumnEditProperties($editColumn);
$grid->AddInsertColumn($editColumn);
//
// Edit column for multi_year field
//
$editor = new CheckBox('multi_year_edit');
$editColumn = new CustomEditColumn('Multi Year', 'multi_year', $editor, $this->dataset);
$editColumn->SetAllowSetToNull(true);
$this->ApplyCommonColumnEditProperties($editColumn);
$grid->AddInsertColumn($editColumn);
//
// Edit column for public_engagement field
//
$editor = new ComboBox('public_engagement_edit', $this->GetLocalizerCaptions()->GetMessageString('PleaseSelect'));
$editor->AddValue('0 - No Public Engagement (CAO Authorization Only)', $this->RenderText('0 - No Public Engagement (CAO Authorization Only)'));
$editor->AddValue('1 - Inform', $this->RenderText('1 - Inform'));
$editor->AddValue('2 - Consult', $this->RenderText('2 - Consult'));
$editor->AddValue('3 - Involve ', $this->RenderText('3 - Involve'));
$editor->AddValue('4 - Collaborate', $this->RenderText('4 - Collaborate'));
$editor->AddValue('5- Empower', $this->RenderText('5 - Empower'));
$editColumn = new CustomEditColumn('Public Engagement', 'public_engagement', $editor, $this->dataset);
$editColumn->SetAllowSetToNull(true);
$this->ApplyCommonColumnEditProperties($editColumn);
$grid->AddInsertColumn($editColumn);
//
// Edit column for level_of_service field
//
$editor = new ComboBox('level_of_service_edit', $this->GetLocalizerCaptions()->GetMessageString('PleaseSelect'));
$editor->AddValue('Maintain existing Level Of Service', $this->RenderText('Maintain existing Level Of Service'));
$editor->AddValue('Upgrade Level Of Service', $this->RenderText('Upgrade Level Of Service'));
$editor->AddValue('Downgrade Level Of Service', $this->RenderText('Downgrade Level Of Service'));
$editor->AddValue('New Level Of Service/Asset(s)', $this->RenderText('New Level Of Service/Asset(s)'));
$editor->AddValue('Eliminate Level Of Service/Asset(s)', $this->RenderText('Eliminate Level Of Service/Asset(s)'));
$editor->AddValue('One-Time only Project', $this->RenderText('One-Time only Project'));
$editColumn = new CustomEditColumn('Level Of Service', 'level_of_service', $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 approved field
//
$editor = new CheckBox('approved_edit');
$editColumn = new CustomEditColumn('Approved by CAO', 'approved', $editor, $this->dataset);
$editColumn->SetAllowSetToNull(true);
$this->ApplyCommonColumnEditProperties($editColumn);
$grid->AddInsertColumn($editColumn);
//
// Edit column for progress field
//
$editor = new ComboBox('progress_edit', $this->GetLocalizerCaptions()->GetMessageString('PleaseSelect'));
$editor->AddValue('0', $this->RenderText('Zero Percent'));
$editor->AddValue('0.10', $this->RenderText('10 Percent'));
$editor->AddValue('0.20', $this->RenderText('20 Percent'));
$editor->AddValue('0.30', $this->RenderText('30 Percent'));
$editor->AddValue('0.40', $this->RenderText('40 Percent'));
$editor->AddValue('0.5', $this->RenderText('50 Percent'));
$editor->AddValue('0.6', $this->RenderText('60 Percent'));
$editor->AddValue('0.7', $this->RenderText('70 Percent'));
$editor->AddValue('0.8', $this->RenderText('80 Percent'));
$editor->AddValue('0.9', $this->RenderText('90 Percent'));
$editor->AddValue('1', $this->RenderText('100 Percent'));
$editColumn = new CustomEditColumn('Progress', 'progress', $editor, $this->dataset);
$editColumn->SetAllowSetToNull(true);
$editColumn->SetInsertDefaultValue($this->RenderText('0'));
$this->ApplyCommonColumnEditProperties($editColumn);
$grid->AddInsertColumn($editColumn);
//
// Edit column for dept_id field
//
$editor = new ComboBox('dept_id_edit', $this->GetLocalizerCaptions()->GetMessageString('PleaseSelect'));
$lookupDataset = new TableDataset(new MyConnectionFactory(), GetConnectionOptions(), '`department`');
$field = new IntegerField('DEPT_ID', null, null, true);
$field->SetIsNotNull(true);
$lookupDataset->AddField($field, true);
$field = new StringField('DEPARTMENT');
$field->SetIsNotNull(true);
$lookupDataset->AddField($field, false);
$field = new IntegerField('MANAGER');
$field->SetIsNotNull(true);
$lookupDataset->AddField($field, false);
$field = new IntegerField('DIRECTOR');
$field->SetIsNotNull(true);
$lookupDataset->AddField($field, false);
$field = new StringField('LOCATION');
$field->SetIsNotNull(true);
$lookupDataset->AddField($field, false);
$field = new StringField('PHONE_NO');
$field->SetIsNotNull(true);
$lookupDataset->AddField($field, false);
$lookupDataset->SetOrderBy('DEPARTMENT', GetOrderTypeAsSQL(otAscending));
$editColumn = new LookUpEditColumn('Department', 'dept_id', $editor, $this->dataset, 'DEPT_ID', 'DEPARTMENT', $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);
}
}
/**
* dijit.form.FilteringSelect
*
* @param int $id
* @param mixed $value
* @param array $params Parameters to use for dijit creation
* @param array $attribs HTML attributes
* @param array|null $options Select options
* @return string
*/
public function __invoke($id = null, $value = null, array $params = array(), array $attribs = array(), array $options = null)
{
return parent::__invoke($id, $value, $params, $attribs, $options);
}
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);
}
}
/**
* Method prepareFieldsArray
* @access public
* @param mixed $properties [default value: array(]
* @return mixed
* @since 1.2.1
*/
public function prepareFieldsArray($properties = array())
{
$this->fields_array = array();
$list_attribute = $this->database_object->getDbTableAttributes();
$list_attribute_type = $this->database_object->getDbTableAttributesType();
$auto_increment_id = $this->database_object->getDbTableAutoIncrement();
// Add properties to apply on all fields
if (isset($properties[ModelViewMapper::PROPERTIES_ALL]) && is_array($properties[ModelViewMapper::PROPERTIES_ALL])) {
$apply_all_array = $properties[ModelViewMapper::PROPERTIES_ALL];
foreach ($apply_all_array as $property_name => $property_value) {
for ($i = 0; $i < sizeof($list_attribute); $i++) {
$property[$property_name] = $property_value;
if (isset($properties[$list_attribute[$i]])) {
// Handle child override of global property
if (!isset($properties[$list_attribute[$i]][$property_name])) {
$properties[$list_attribute[$i]] = array_merge($properties[$list_attribute[$i]], $property);
}
} else {
$properties[$list_attribute[$i]] = $property;
}
}
}
}
// check foreign keys
$db_table_foreign_keys = $this->database_object->getDbTableForeignKeys();
foreach ($db_table_foreign_keys as $fk_attribute => $value) {
if (isset($properties[$fk_attribute])) {
$fk_property = $properties[$fk_attribute];
if (isset($fk_property["fk_attribute"])) {
// create combobox
$cmb = new ComboBox($this->form_or_page);
// get foreign key data
$query = "select distinct " . $value["column"] . " as id, " . $fk_property["fk_attribute"] . " as value from " . $value["table"];
if (isset($fk_property["fk_where"])) {
$query .= " where " . $fk_property["fk_where"];
}
if (isset($fk_property["fk_orderby"])) {
$query .= " order by " . $fk_property["fk_orderby"];
}
$stmt = DataBase::getInstance()->prepareStatement($query);
$row = DataBase::getInstance()->stmtBindAssoc($stmt, $row);
while ($stmt->fetch()) {
$cmb->addItem(utf8encode($row['id']), utf8encode($row['value']));
}
// add combo box in properties
$value['cmb_obj'] = $cmb;
$properties[$fk_attribute] = array_merge($properties[$fk_attribute], $value);
}
}
}
foreach ($list_attribute as $i => $attribute) {
$wspobject = "TextBox";
$attribute_properties = array();
if (is_array($properties[$attribute])) {
$attribute_properties = $properties[$attribute];
}
if (isset($attribute_properties["display"]) && $attribute_properties["display"] == false) {
continue;
}
$is_update_ok = true;
if (isset($attribute_properties["update"]) && $attribute_properties["update"] == false) {
$is_update_ok = false;
}
$method = "get" . $this->getFormatValue($attribute);
$value = call_user_func_array(array($this->database_model_object, $method), array());
if ($attribute != $auto_increment_id && $is_update_ok) {
// get property cmb_obj
if (isset($attribute_properties['cmb_obj'])) {
$field = $attribute_properties['cmb_obj'];
} else {
if (isset($attribute_properties["wspobject"]) && $attribute_properties["wspobject"] != "") {
$wspobject = $attribute_properties["wspobject"];
} else {
if ($list_attribute_type[$i] == "datetime") {
$wspobject = "Calendar";
} else {
if ($list_attribute_type[$i] == "boolean") {
$wspobject = "CheckBox";
}
}
}
if ($wspobject == "Calendar") {
$field = new Calendar($this->form_or_page);
} else {
if ($wspobject == "CheckBox") {
$field = new CheckBox($this->form_or_page);
} else {
if ($wspobject == "TextArea") {
$field = new TextArea($this->form_or_page);
} else {
if ($wspobject == "Editor") {
$field = new Editor($this->form_or_page);
if (isset($attribute_properties["editor_param"]) && $attribute_properties["editor_param"] != "") {
$field->setToolbar($attribute_properties["editor_param"]);
}
} else {
if ($wspobject == "ComboBox") {
$field = new ComboBox($this->form_or_page);
if (isset($attribute_properties["combobox_values"])) {
if (is_array($attribute_properties["combobox_values"])) {
for ($j = 0; $j < sizeof($attribute_properties["combobox_values"]); $j++) {
$field->addItem($attribute_properties["combobox_values"][$j]['value'], $attribute_properties["combobox_values"][$j]['text']);
}
} else {
throw new NewException(get_class($this) . "->prepareFieldsArray() error: the property combobox_values need to be an array.", 0, getDebugBacktrace(1));
}
}
} else {
$field = new TextBox($this->form_or_page);
if ($list_attribute_type[$i] == "integer" || $list_attribute_type[$i] == "double") {
$field->setWidth(70);
}
if (in_array($attribute, $key_attributes)) {
$lv = new LiveValidation();
$field->setLiveValidation($lv->addValidatePresence());
}
}
}
}
}
}
}
// Handle Checkbox case that only support value as "on" or "off"
if (get_class($field) == "CheckBox") {
if ($value == "1") {
$field->setValue("on");
} else {
$field->setValue("off");
}
} else {
if (get_class($field) == "Calendar") {
$field->setValue($value);
} else {
$field->setValue(utf8encode($value));
}
}
if (isset($attribute_properties["width"]) && method_exists($field, "setWidth")) {
$field->setWidth($attribute_properties["width"]);
}
if (isset($attribute_properties["height"]) && method_exists($field, "setHeight")) {
$field->setHeight($attribute_properties["height"]);
}
if (isset($attribute_properties["class"]) && method_exists($field, "setClass")) {
$field->setClass($attribute_properties["class"]);
}
if (isset($attribute_properties["style"]) && method_exists($field, "setStyle")) {
$field->setStyle($attribute_properties["style"]);
}
if (isset($attribute_properties["disable"])) {
if ($attribute_properties["disable"] == true && method_exists($field, "disable")) {
$field->disable();
} else {
if ($attribute_properties["disable"] == false && method_exists($field, "enable")) {
$field->enable();
}
}
}
if (get_class($field) != "Calendar") {
if (isset($attribute_properties["strip_tags"]) && $attribute_properties["strip_tags"] == true && method_exists($field, "setStripTags")) {
if (isset($attribute_properties["allowable_tags"])) {
$field->setStripTags($attribute_properties["allowable_tags"]);
} else {
$field->setStripTags("");
// no tag allowed
}
}
}
} else {
if (isset($attribute_properties['cmb_obj'])) {
$field_tmp = $attribute_properties['cmb_obj'];
$field_tmp->setValue($value);
$value = $field_tmp->getText();
}
if (get_class($value) == "DateTime") {
$value = $value->format("Y-m-d");
}
$field = new Object(utf8encode($value));
}
$this->fields_array[$attribute] = $field;
}
return $this->fields_array;
}
/**
* Method createDbAttributeObject
* @access private
* @param mixed $row
* @param mixed $list_attribute
* @param mixed $list_attribute_type
* @param mixed $i
* @param mixed $ind
* @param mixed $key_attributes
* @return mixed
* @since 1.1.6
*/
private function createDbAttributeObject($row, $list_attribute, $list_attribute_type, $i, $ind, $key_attributes)
{
// get property cmb_obj (created by method loadFromSqlDataView)
if (isset($this->from_sql_data_view_properties[$list_attribute[$i]]['cmb_obj'])) {
$input_obj_tmp = $this->from_sql_data_view_properties[$list_attribute[$i]]['cmb_obj'];
$input_obj = clone $input_obj_tmp;
$input_obj->setName($this->id . "_input_" . $list_attribute[$i] . "_ind_" . $ind);
$register_objects = WebSitePhpObject::getRegisterObjects();
$register_objects[] = $input_obj;
$_SESSION['websitephp_register_object'] = $register_objects;
} else {
$wspobject = "TextBox";
$attribute_properties = array();
if (is_array($this->from_sql_data_view_properties[$list_attribute[$i]])) {
$attribute_properties = $this->from_sql_data_view_properties[$list_attribute[$i]];
}
if (isset($attribute_properties["wspobject"]) && $attribute_properties["wspobject"] != "") {
$wspobject = $attribute_properties["wspobject"];
} else {
if ($list_attribute_type[$i] == "datetime") {
$wspobject = "Calendar";
} else {
if ($list_attribute_type[$i] == "boolean") {
$wspobject = "CheckBox";
}
}
}
if ($wspobject == "Calendar") {
$input_obj = new Calendar($this->table_form_object, $this->id . "_input_" . $list_attribute[$i] . "_ind_" . $ind);
} else {
if ($wspobject == "CheckBox") {
$input_obj = new CheckBox($this->table_form_object, $this->id . "_input_" . $list_attribute[$i] . "_ind_" . $ind);
} else {
if ($wspobject == "TextArea") {
$input_obj = new TextArea($this->table_form_object, $object_id);
} else {
if ($wspobject == "Editor") {
$input_obj = new Editor($this->table_form_object, $object_id);
if (isset($attribute_properties["editor_param"]) && $attribute_properties["editor_param"] != "") {
$input_obj->setToolbar($attribute_properties["editor_param"]);
}
} else {
if ($wspobject == "ComboBox") {
$input_obj = new ComboBox($this->table_form_object, $object_id);
if (isset($attribute_properties["combobox_values"])) {
if (is_array($attribute_properties["combobox_values"])) {
for ($j = 0; $j < sizeof($attribute_properties["combobox_values"]); $j++) {
$input_obj->addItem($attribute_properties["combobox_values"][$j]['value'], $attribute_properties["combobox_values"][$j]['text']);
}
} else {
throw new NewException(get_class($this) . "->loadFromSqlDataView() error: the property combobox_values need to be an array.", 0, getDebugBacktrace(1));
}
}
} else {
$input_obj = new TextBox($this->table_form_object, $this->id . "_input_" . $list_attribute[$i] . "_ind_" . $ind);
if ($list_attribute_type[$i] == "integer" || $list_attribute_type[$i] == "double") {
$input_obj->setWidth(70);
}
if (in_array($list_attribute[$i], $key_attributes)) {
$lv = new LiveValidation();
$input_obj->setLiveValidation($lv->addValidatePresence());
}
}
}
}
}
}
}
// get properties width and strip_tags
if (is_array($this->from_sql_data_view_properties[$list_attribute[$i]])) {
$attribute_properties = $this->from_sql_data_view_properties[$list_attribute[$i]];
if (isset($attribute_properties["width"]) && method_exists($input_obj, "setWidth")) {
$input_obj->setWidth($attribute_properties["width"]);
}
if (isset($attribute_properties["height"]) && method_exists($input_obj, "setHeight")) {
$input_obj->setHeight($attribute_properties["height"]);
}
if (isset($attribute_properties["class"]) && method_exists($input_obj, "setClass")) {
$input_obj->setClass($attribute_properties["class"]);
}
if (isset($attribute_properties["style"]) && method_exists($input_obj, "setStyle")) {
$input_obj->setStyle($attribute_properties["style"]);
}
if (isset($attribute_properties["disable"])) {
if ($attribute_properties["disable"] == true && method_exists($input_obj, "disable")) {
$input_obj->disable();
} else {
if ($attribute_properties["disable"] == false && method_exists($input_obj, "enable")) {
$input_obj->enable();
}
}
}
if (get_class($input_obj) != "Calendar") {
if (isset($attribute_properties["strip_tags"]) && $attribute_properties["strip_tags"] == true && method_exists($input_obj, "setStripTags")) {
if (isset($attribute_properties["allowable_tags"])) {
$input_obj->setStripTags($attribute_properties["allowable_tags"]);
} else {
$input_obj->setStripTags("");
// no tag allowed
}
}
}
}
if ($row != null) {
// get property db_attribute
$field_value = $row->getValue($list_attribute[$i]);
if (isset($this->from_sql_data_view_properties[$list_attribute[$i]]["db_attribute"])) {
$db_attribute = $this->from_sql_data_view_properties[$list_attribute[$i]]["db_attribute"];
$field_value = $row->getValue($db_attribute);
}
$input_obj->onChange("onChangeTableFromSqlDataView")->setAjaxEvent()->disableAjaxWaitMessage();
if (get_class($input_obj) == "TextBox") {
$input_obj->onKeyUpJs("if (\$(this)[0].defaultValue != \$(this).val()) { \$('#" . $this->id . "_img_" . $ind . "_cancel_" . $list_attribute[$i] . "').hide(); } else { \$('#" . $this->id . "_img_" . $ind . "_cancel_" . $list_attribute[$i] . "').show(); }");
}
if ($list_attribute_type[$i] == "boolean") {
if (!$input_obj->isChanged()) {
$input_obj->setValue($field_value == true ? "on" : "off");
}
} else {
if (gettype($field_value) == "object") {
$input_obj->setValue($field_value);
} else {
$input_obj->setValue(utf8encode($field_value));
}
}
}
return $input_obj;
}
protected function AddInsertColumns(Grid $grid)
{
//
// Edit column for project_id field
//
$editor = new ComboBox('project_id_edit', $this->GetLocalizerCaptions()->GetMessageString('PleaseSelect'));
$editColumn = new CustomEditColumn('Project', 'project_id', $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'));
$editColumn = new CustomEditColumn('Name', 'task_name', $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 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('Allocated Hours', 'hrs', $editor, $this->dataset);
$editColumn->SetInsertDefaultValue($this->RenderText('21'));
$validator = new RequiredValidator(StringUtils::Format($this->GetLocalizerCaptions()->GetMessageString('RequiredValidationMessage'), $this->RenderText($editColumn->GetCaption())));
$editor->GetValidatorCollection()->AddValidator($validator);
$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'));
$editColumn = new CustomEditColumn('Assigned To', 'assigned_to', $editor, $this->dataset);
$editColumn->SetInsertDefaultValue($this->RenderText('%CURRENT_USER_ID%'));
$validator = new RequiredValidator(StringUtils::Format($this->GetLocalizerCaptions()->GetMessageString('RequiredValidationMessage'), $this->RenderText($editColumn->GetCaption())));
$editor->GetValidatorCollection()->AddValidator($validator);
$this->ApplyCommonColumnEditProperties($editColumn);
$grid->AddInsertColumn($editColumn);
//
// Edit column for date_start field
//
$editor = new DateTimeEdit('date_start_edit', false, 'Y-m-d', GetFirstDayOfWeek());
$editColumn = new CustomEditColumn('Date Start', 'date_start', $editor, $this->dataset);
$editColumn->SetInsertDefaultValue($this->RenderText('%CURRENT_DATE%'));
$validator = new RequiredValidator(StringUtils::Format($this->GetLocalizerCaptions()->GetMessageString('RequiredValidationMessage'), $this->RenderText($editColumn->GetCaption())));
$editor->GetValidatorCollection()->AddValidator($validator);
$this->ApplyCommonColumnEditProperties($editColumn);
$grid->AddInsertColumn($editColumn);
//
// Edit column for date_end field
//
$editor = new DateTimeEdit('date_end_edit', true, 'Y-m-d', GetFirstDayOfWeek());
$editColumn = new CustomEditColumn('Date End', 'date_end', $editor, $this->dataset);
$editColumn->SetInsertDefaultValue($this->RenderText('%CURRENT_DATE%'));
$validator = new RequiredValidator(StringUtils::Format($this->GetLocalizerCaptions()->GetMessageString('RequiredValidationMessage'), $this->RenderText($editColumn->GetCaption())));
$editor->GetValidatorCollection()->AddValidator($validator);
$this->ApplyCommonColumnEditProperties($editColumn);
$grid->AddInsertColumn($editColumn);
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_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 num_req_padre field
//
$editor = new TextEdit('num_req_padre_edit');
$editor->SetMaxLength(64);
$editColumn = new CustomEditColumn('MrCoo', 'num_req_padre', $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 num_req_hijo field
//
$editor = new TextEdit('num_req_hijo_edit');
$editor->SetMaxLength(64);
$editColumn = new CustomEditColumn('Caso de Uso', 'num_req_hijo', $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 etapa field
//
$editor = new ComboBox('etapa_edit', $this->GetLocalizerCaptions()->GetMessageString('PleaseSelect'));
$editor->AddValue('ANALISIS', $this->RenderText('ANÁLISIS'));
$editor->AddValue('DESARROLLO', $this->RenderText('DESARROLLO'));
$editor->AddValue('PRUEBAS', $this->RenderText('PRUEBAS'));
$editor->AddValue('INTEGRACION', $this->RenderText('INTEGRACIÓN'));
$editColumn = new CustomEditColumn('Etapa de Planificación', 'etapa', $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 descripcion field
//
$editor = new TextEdit('descripcion_edit');
$editColumn = new CustomEditColumn('Descripción', 'descripcion', $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 criterios_aceptacion field
//
$editor = new TextAreaEdit('criterios_aceptacion_edit', 50, 8);
$editColumn = new CustomEditColumn('Criterios Aceptación', 'criterios_aceptacion', $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 esfuerzo field
//
$editor = new TextEdit('esfuerzo_edit');
$editColumn = new CustomEditColumn('Esfuerzo', 'esfuerzo', $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 observaciones field
//
$editor = new TextAreaEdit('observaciones_edit', 50, 8);
$editColumn = new CustomEditColumn('Observaciones', 'observaciones', $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 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_paquete field
//
$editor = new TextEdit('id_paquete_edit');
$editor->SetMaxLength(64);
$editColumn = new CustomEditColumn('CMO', 'id_paquete', $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 nombre field
//
$editor = new TextEdit('nombre_edit');
$editor->SetMaxLength(64);
$editColumn = new CustomEditColumn('Nombre del Objeto', 'nombre', $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 ruta field
//
$editor = new TextEdit('ruta_edit');
$editColumn = new CustomEditColumn('Ruta', 'ruta', $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 tipo field
//
$editor = new ComboBox('tipo_edit', $this->GetLocalizerCaptions()->GetMessageString('PleaseSelect'));
$editor->AddValue('HTML', $this->RenderText('HTML'));
$editor->AddValue('PHP', $this->RenderText('PHP'));
$editor->AddValue('JS', $this->RenderText('JS'));
$editor->AddValue('PL/SQL', $this->RenderText('PL/SQL'));
$editor->AddValue('SCRIPT', $this->RenderText('SCRIPT ADJUNTO'));
$editColumn = new CustomEditColumn('Tipo', 'tipo', $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 aplicacion field
//
$editor = new ComboBox('aplicacion_edit', $this->GetLocalizerCaptions()->GetMessageString('PleaseSelect'));
$editor->AddValue('CIKLOS', $this->RenderText('CIKLOS'));
$editor->AddValue('COOEPS', $this->RenderText('COOEPS'));
$editColumn = new CustomEditColumn('Aplicación', 'aplicacion', $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 nuevo field
//
$editor = new CheckBoxGroup('nuevo_edit');
$editor->SetDisplayMode(CheckBoxGroup::StackedMode);
$editor->AddValue('N', $this->RenderText('NO'));
$editor->AddValue('S', $this->RenderText('SI'));
$editColumn = new CustomEditColumn('Nuevo', 'nuevo', $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_noconforme field
//
$editor = new TextEdit('id_noconforme_edit');
$editor->SetMaxLength(64);
$editColumn = new CustomEditColumn('Número NC', 'id_noconforme', $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);
}
}
public function FormEdita($cod)
{
$this->codigo = $cod;
$tpl = Comuns::BuscaForm($this->form);
if ($tpl) {
$sql = "SELECT NomeCompleto, NomeUsuario, Email, Ativo, CodInstituicao, CodIdioma ";
$sql .= "FROM mesusuario WHERE Codigo = " . $this->codigo;
$sqlIns = "SELECT Codigo, CONCAT(NomeCompleto, CASE WHEN Sigla IS NOT NULL THEN concat(' (', Sigla, ')') ELSE '' END) AS Nome ";
$sqlIns .= "FROM mesinstituicao ORDER BY NomeCompleto;";
$sqlIdiomas = "select Codigo, Nome from sisidiomas where publicado = 1;";
$cnn = Conexao2::getInstance();
$cmd = $cnn->prepare($sql);
$cmd->execute();
if ($cmd->errorCode() != Comuns::QUERY_OK) {
$msg = $cmd->errorInfo();
echo $msg[2];
}
if ($cmd->rowCount() > 0) {
$rs = $cmd->fetch(PDO::FETCH_OBJ);
$cmd->closeCursor();
$cmd = $cnn->prepare($sqlIns);
$cmd->execute();
if ($cmd->errorCode() != Comuns::QUERY_OK) {
$msg = $cmd->errorInfo();
echo $msg[2];
}
$rsIns = $cmd->fetchAll(PDO::FETCH_OBJ);
$cmbIns = new ComboBox("selInstituicao", $rsIns, "Codigo", "Nome", "0", "Selecione");
$cmbIns->cssClass("campo requerido");
$cmd->closeCursor();
$cmd = $cnn->prepare($sqlIdiomas);
$cmd->execute();
if ($cmd->errorCode() != Comuns::QUERY_OK) {
$msg = $cmd->errorInfo();
echo $msg[2];
}
$rsIdiomas = $cmd->fetchAll(PDO::FETCH_OBJ);
$cmbIdioma = new ComboBox("selIdioma", $rsIdiomas, "Codigo", "Nome");
$cmbIdioma->cssClass("campo requerido");
$tpl = str_replace("##txtCodigo##", $this->codigo, $tpl);
$tpl = str_replace("##txtNome##", $rs->NomeCompleto, $tpl);
$tpl = str_replace("##txtUsuario##", $rs->NomeUsuario, $tpl);
$tpl = str_replace("##txtEmail##", $rs->Email, $tpl);
$tpl = str_replace("##selInstituicao##", $cmbIns->RenderHTML($rs->CodInstituicao), $tpl);
$tpl = str_replace("##selIdioma##", $cmbIdioma->RenderHTML($rs->CodIdioma), $tpl);
if ($rs->Ativo == 1) {
$tpl = str_replace("##selAtivo1##", 'selected="selected"', $tpl);
$tpl = str_replace("##selAtivo2##", '', $tpl);
} else {
$tpl = str_replace("##selAtivo2##", 'selected="selected"', $tpl);
$tpl = str_replace("##selAtivo1##", '', $tpl);
}
} else {
$tpl = "@lng[Nenhum registro encontrado com os dados informados]";
}
} else {
$tpl = "@lng[Erro ao criar a tela de cadastro de usuário].";
}
return $tpl;
}
protected function AddInsertColumns(Grid $grid)
{
//
// Edit column for program_name field
//
$editor = new TextEdit('program_name_edit');
$editor->SetSize(50);
$editor->SetMaxLength(50);
$editColumn = new CustomEditColumn(' Name', 'program_name', $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 description field
//
$editor = new TextAreaEdit('description_edit', 50, 8);
$editColumn = new CustomEditColumn('Description', 'description', $editor, $this->dataset);
$editColumn->SetAllowSetToNull(true);
$this->ApplyCommonColumnEditProperties($editColumn);
$grid->AddInsertColumn($editColumn);
//
// Edit column for lead field
//
$editor = new ComboBox('lead_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('Lead', 'lead', $editor, $this->dataset, 'username', 'username', $lookupDataset);
$editColumn->SetCaptionTemplate($this->RenderText('%username%'));
$validator = new RequiredValidator(StringUtils::Format($this->GetLocalizerCaptions()->GetMessageString('RequiredValidationMessage'), $this->RenderText($editColumn->GetCaption())));
$editor->GetValidatorCollection()->AddValidator($validator);
$this->ApplyCommonColumnEditProperties($editColumn);
$grid->AddInsertColumn($editColumn);
//
// Edit column for date_start field
//
$editor = new DateTimeEdit('date_start_edit', false, 'Y-m-d', GetFirstDayOfWeek());
$editColumn = new CustomEditColumn('Date Start', 'date_start', $editor, $this->dataset);
$editColumn->SetInsertDefaultValue($this->RenderText('%CURRENT_DATE%'));
$validator = new RequiredValidator(StringUtils::Format($this->GetLocalizerCaptions()->GetMessageString('RequiredValidationMessage'), $this->RenderText($editColumn->GetCaption())));
$editor->GetValidatorCollection()->AddValidator($validator);
$this->ApplyCommonColumnEditProperties($editColumn);
$grid->AddInsertColumn($editColumn);
//
// Edit column for date_end field
//
$editor = new DateTimeEdit('date_end_edit', false, 'Y-m-d', GetFirstDayOfWeek());
$editColumn = new CustomEditColumn('Date End', 'date_end', $editor, $this->dataset);
$editColumn->SetInsertDefaultValue($this->RenderText('%CURRENT_DATE%'));
$validator = new RequiredValidator(StringUtils::Format($this->GetLocalizerCaptions()->GetMessageString('RequiredValidationMessage'), $this->RenderText($editColumn->GetCaption())));
$editor->GetValidatorCollection()->AddValidator($validator);
$this->ApplyCommonColumnEditProperties($editColumn);
$grid->AddInsertColumn($editColumn);
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 INTERES_ID field
//
$editor = new ComboBox('interes_id_edit', $this->GetLocalizerCaptions()->GetMessageString('PleaseSelect'));
$lookupDataset = new TableDataset(new OracleConnectionFactory(), GetConnectionOptions(), '"GE"."INTERES"');
$field = new IntegerField('INTERES_ID');
$field->SetIsNotNull(true);
$lookupDataset->AddField($field, true);
$field = new StringField('NOMBRE');
$field->SetIsNotNull(true);
$lookupDataset->AddField($field, false);
$field = new DateField('FEC_CREACION');
$lookupDataset->AddField($field, false);
$field = new StringField('USUARIO_CREACION');
$lookupDataset->AddField($field, false);
$field = new DateField('FEC_ULTIMA_MOD');
$lookupDataset->AddField($field, false);
$field = new StringField('USUARIO_ULTIMA_MOD');
$lookupDataset->AddField($field, false);
$lookupDataset->SetOrderBy('NOMBRE', GetOrderTypeAsSQL(otAscending));
$editColumn = new LookUpEditColumn('INTERES ID', 'INTERES_ID', $editor, $this->dataset, 'INTERES_ID', 'NOMBRE', $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 CATEGORIA_INTERES_ID field
//
$editor = new ComboBox('categoria_interes_id_edit', $this->GetLocalizerCaptions()->GetMessageString('PleaseSelect'));
$lookupDataset = new TableDataset(new OracleConnectionFactory(), GetConnectionOptions(), '"GE"."CATEGORIA_INTERES"');
$field = new IntegerField('CATEGORIA_INTERES_ID');
$field->SetIsNotNull(true);
$lookupDataset->AddField($field, true);
$field = new StringField('NOMBRE');
$field->SetIsNotNull(true);
$lookupDataset->AddField($field, false);
$field = new DateField('FEC_CREACION');
$lookupDataset->AddField($field, false);
$field = new StringField('USUARIO_CREACION');
$lookupDataset->AddField($field, false);
$field = new DateField('FEC_ULTIMA_MOD');
$lookupDataset->AddField($field, false);
$field = new StringField('USUARIO_ULTIMA_MOD');
$lookupDataset->AddField($field, false);
$lookupDataset->SetOrderBy('NOMBRE', GetOrderTypeAsSQL(otAscending));
$editColumn = new LookUpEditColumn('CATEGORIA INTERES ID', 'CATEGORIA_INTERES_ID', $editor, $this->dataset, 'CATEGORIA_INTERES_ID', 'NOMBRE', $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 username field
//
$editor = new TextEdit('username_edit');
$editor->SetSize(50);
$editor->SetMaxLength(50);
$editColumn = new CustomEditColumn('Username', 'username', $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 email field
//
$editor = new TextEdit('email_edit');
$editor->SetSize(50);
$editor->SetMaxLength(50);
$editColumn = new CustomEditColumn('Email', 'email', $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 password field
//
$editor = new TextEdit('password_edit');
$editor->SetPasswordMode(true);
$editColumn = new CustomEditColumn('Password', 'password', $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 dept_id field
//
$editor = new ComboBox('dept_id_edit', $this->GetLocalizerCaptions()->GetMessageString('PleaseSelect'));
$lookupDataset = new TableDataset(new MyConnectionFactory(), GetConnectionOptions(), '`department`');
$field = new IntegerField('DEPT_ID', null, null, true);
$field->SetIsNotNull(true);
$lookupDataset->AddField($field, true);
$field = new StringField('DEPARTMENT');
$field->SetIsNotNull(true);
$lookupDataset->AddField($field, false);
$field = new IntegerField('MANAGER');
$field->SetIsNotNull(true);
$lookupDataset->AddField($field, false);
$field = new IntegerField('DIRECTOR');
$field->SetIsNotNull(true);
$lookupDataset->AddField($field, false);
$field = new StringField('LOCATION');
$field->SetIsNotNull(true);
$lookupDataset->AddField($field, false);
$field = new StringField('PHONE_NO');
$field->SetIsNotNull(true);
$lookupDataset->AddField($field, false);
$lookupDataset->SetOrderBy('DEPARTMENT', GetOrderTypeAsSQL(otAscending));
$editColumn = new LookUpEditColumn('Department', 'dept_id', $editor, $this->dataset, 'DEPT_ID', 'DEPARTMENT', $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 position field
//
$editor = new TextEdit('position_edit');
$editor->SetSize(50);
$editor->SetMaxLength(50);
$editColumn = new CustomEditColumn('Position', 'position', $editor, $this->dataset);
$editColumn->SetAllowSetToNull(true);
$this->ApplyCommonColumnEditProperties($editColumn);
$grid->AddInsertColumn($editColumn);
//
// Edit column for emp_number field
//
$editor = new TextEdit('emp_number_edit');
$editor->SetSize(20);
$editor->SetMaxLength(20);
$editColumn = new CustomEditColumn('Employee No', 'emp_number', $editor, $this->dataset);
$editColumn->SetAllowSetToNull(true);
$this->ApplyCommonColumnEditProperties($editColumn);
$grid->AddInsertColumn($editColumn);
//
// Edit column for picture field
//
$editor = new ImageUploader('picture_edit');
$editor->SetShowImage(true);
$editColumn = new UploadFileToFolderColumn('Picture', 'picture', $editor, $this->dataset, false, false, 'images');
$editColumn->OnCustomFileName->AddListener('picture_GenerateFileName_insert', $this);
$editColumn->SetReplaceUploadedFileIfExist(true);
$editColumn->SetGenerationImageThumbnails('picture', 'images', Delegate::CreateFromMethod($this, 'picture_Thumbnail_GenerateFileName_insert'), new ImageFitByHeightResizeFilter(100));
$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 programm_id field
//
$editor = new ComboBox('programm_id_edit', $this->GetLocalizerCaptions()->GetMessageString('PleaseSelect'));
$editColumn = new CustomEditColumn('Project Type', 'programm_id', $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 project_name field
//
$editor = new TextEdit('project_name_edit');
$editColumn = new CustomEditColumn('Project Name', 'project_name', $editor, $this->dataset);
$validator = new RequiredValidator(StringUtils::Format($this->GetLocalizerCaptions()->GetMessageString('RequiredValidationMessage'), $this->RenderText($editColumn->GetCaption())));
$editor->GetValidatorCollection()->AddValidator($validator);
$validator = new CustomRegExpValidator('^[A-Za-z0-9 ()&]+[-]*[A-Za-z0-9 ()&]*$', StringUtils::Format($this->GetLocalizerCaptions()->GetMessageString('RegExpValidationMessage'), $this->RenderText($editColumn->GetCaption())));
$editor->GetValidatorCollection()->AddValidator($validator);
$this->ApplyCommonColumnEditProperties($editColumn);
$grid->AddInsertColumn($editColumn);
//
// Edit column for date_start field
//
$editor = new DateTimeEdit('date_start_edit', false, 'Y-m-d', GetFirstDayOfWeek());
$editColumn = new CustomEditColumn('Date Start', 'date_start', $editor, $this->dataset);
$editColumn->SetInsertDefaultValue($this->RenderText('%CURRENT_DATE%'));
$validator = new RequiredValidator(StringUtils::Format($this->GetLocalizerCaptions()->GetMessageString('RequiredValidationMessage'), $this->RenderText($editColumn->GetCaption())));
$editor->GetValidatorCollection()->AddValidator($validator);
$this->ApplyCommonColumnEditProperties($editColumn);
$grid->AddInsertColumn($editColumn);
//
// Edit column for date_end field
//
$editor = new DateTimeEdit('date_end_edit', true, 'Y-m-d', GetFirstDayOfWeek());
$editColumn = new CustomEditColumn('Date End', 'date_end', $editor, $this->dataset);
$editColumn->SetInsertDefaultValue($this->RenderText('%CURRENT_DATE%'));
$validator = new RequiredValidator(StringUtils::Format($this->GetLocalizerCaptions()->GetMessageString('RequiredValidationMessage'), $this->RenderText($editColumn->GetCaption())));
$editor->GetValidatorCollection()->AddValidator($validator);
$this->ApplyCommonColumnEditProperties($editColumn);
$grid->AddInsertColumn($editColumn);
//
// Edit column for year field
//
$editor = new TextEdit('year_edit');
$editColumn = new CustomEditColumn('Year', 'year', $editor, $this->dataset);
$editColumn->SetInsertDefaultValue($this->RenderText('2016'));
$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 notes field
//
$editor = new TextAreaEdit('notes_edit', 50, 8);
$editColumn = new CustomEditColumn('Objectives', 'notes', $editor, $this->dataset);
$editColumn->SetAllowSetToNull(true);
$this->ApplyCommonColumnEditProperties($editColumn);
$grid->AddInsertColumn($editColumn);
//
// Edit column for priority field
//
$editor = new ComboBox('priority_edit', $this->GetLocalizerCaptions()->GetMessageString('PleaseSelect'));
$editColumn = new CustomEditColumn('Priority', 'priority', $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 lead field
//
$editor = new ComboBox('lead_edit', $this->GetLocalizerCaptions()->GetMessageString('PleaseSelect'));
$editColumn = new CustomEditColumn('Project Lead', 'lead', $editor, $this->dataset);
$editColumn->SetInsertDefaultValue($this->RenderText('%CURRENT_USER_ID%'));
$validator = new RequiredValidator(StringUtils::Format($this->GetLocalizerCaptions()->GetMessageString('RequiredValidationMessage'), $this->RenderText($editColumn->GetCaption())));
$editor->GetValidatorCollection()->AddValidator($validator);
$this->ApplyCommonColumnEditProperties($editColumn);
$grid->AddInsertColumn($editColumn);
//
// Edit column for approved_budget field
//
$editor = new TextEdit('approved_budget_edit');
$editor->SetPlaceholder($this->RenderText('currency value without comma'));
$editor->SetPrefix($this->RenderText('$'));
$editor->SetSuffix($this->RenderText('.00'));
$editColumn = new CustomEditColumn('Approved Budget', 'approved_budget', $editor, $this->dataset);
$editColumn->SetInsertDefaultValue($this->RenderText('0'));
$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 budget_spent field
//
$editor = new TextEdit('budget_spent_edit');
$editor->SetPlaceholder($this->RenderText('currency value without comma'));
$editor->SetPrefix($this->RenderText('$'));
$editor->SetSuffix($this->RenderText('.00'));
$editColumn = new CustomEditColumn('Budget Spent', 'budget_spent', $editor, $this->dataset);
$editColumn->SetAllowSetToNull(true);
$editColumn->SetInsertDefaultValue($this->RenderText('0'));
$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 multi_year field
//
$editor = new CheckBox('multi_year_edit');
$editColumn = new CustomEditColumn('Multi Year', 'multi_year', $editor, $this->dataset);
$editColumn->SetAllowSetToNull(true);
$this->ApplyCommonColumnEditProperties($editColumn);
$grid->AddInsertColumn($editColumn);
//
// Edit column for public_engagement field
//
$editor = new ComboBox('public_engagement_edit', $this->GetLocalizerCaptions()->GetMessageString('PleaseSelect'));
$editor->AddValue('0 - No Public Engagement (CAO Authorization Only)', $this->RenderText('0 - No Public Engagement (CAO Authorization Only)'));
$editor->AddValue('1 - Inform', $this->RenderText('1 - Inform'));
$editor->AddValue('2 - Consult', $this->RenderText('2 - Consult'));
$editor->AddValue('3 - Involve ', $this->RenderText('3 - Involve'));
$editor->AddValue('4 - Collaborate', $this->RenderText('4 - Collaborate'));
$editor->AddValue('5- Empower', $this->RenderText('5 - Empower'));
$editColumn = new CustomEditColumn('Public Engagement', 'public_engagement', $editor, $this->dataset);
$editColumn->SetAllowSetToNull(true);
$this->ApplyCommonColumnEditProperties($editColumn);
$grid->AddInsertColumn($editColumn);
//
// Edit column for level_of_service field
//
$editor = new ComboBox('level_of_service_edit', $this->GetLocalizerCaptions()->GetMessageString('PleaseSelect'));
$editor->AddValue('Maintain existing Level Of Service', $this->RenderText('Maintain existing Level Of Service'));
$editor->AddValue('Upgrade Level Of Service', $this->RenderText('Upgrade Level Of Service'));
$editor->AddValue('Downgrade Level Of Service', $this->RenderText('Downgrade Level Of Service'));
$editor->AddValue('New Level Of Service/Asset(s)', $this->RenderText('New Level Of Service/Asset(s)'));
$editor->AddValue('Eliminate Level Of Service/Asset(s)', $this->RenderText('Eliminate Level Of Service/Asset(s)'));
$editor->AddValue('One-Time only Project', $this->RenderText('One-Time only Project'));
$editColumn = new CustomEditColumn('Level Of Service', 'level_of_service', $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 approved field
//
$editor = new CheckBox('approved_edit');
$editColumn = new CustomEditColumn('Approved by CAO', 'approved', $editor, $this->dataset);
$editColumn->SetAllowSetToNull(true);
$this->ApplyCommonColumnEditProperties($editColumn);
$grid->AddInsertColumn($editColumn);
//
// Edit column for progress field
//
$editor = new ComboBox('progress_edit', $this->GetLocalizerCaptions()->GetMessageString('PleaseSelect'));
$editor->AddValue('0', $this->RenderText('Zero Percent'));
$editor->AddValue('0.10', $this->RenderText('10 Percent'));
$editor->AddValue('0.20', $this->RenderText('20 Percent'));
$editor->AddValue('0.30', $this->RenderText('30 Percent'));
$editor->AddValue('0.40', $this->RenderText('40 Percent'));
$editor->AddValue('0.5', $this->RenderText('50 Percent'));
$editor->AddValue('0.6', $this->RenderText('60 Percent'));
$editor->AddValue('0.7', $this->RenderText('70 Percent'));
$editor->AddValue('0.8', $this->RenderText('80 Percent'));
$editor->AddValue('0.9', $this->RenderText('90 Percent'));
$editor->AddValue('1', $this->RenderText('100 Percent'));
$editColumn = new CustomEditColumn('Progress', 'progress', $editor, $this->dataset);
$editColumn->SetAllowSetToNull(true);
$editColumn->SetInsertDefaultValue($this->RenderText('0'));
$this->ApplyCommonColumnEditProperties($editColumn);
$grid->AddInsertColumn($editColumn);
//
// Edit column for dept_id field
//
$editor = new ComboBox('dept_id_edit', $this->GetLocalizerCaptions()->GetMessageString('PleaseSelect'));
$editColumn = new CustomEditColumn('Department', 'dept_id', $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);
}
}
<?php
/**
* Main object.
* @author Kikapp
* @version 1.0
*/
$win = new SDPanel();
$win->setCaption("Combo Box!");
$mainTable = new Table();
$actionBar = new ActionBar();
$actionBar->setClass("applicationBars");
$button = new Button();
$button->setCaption("Click me!");
$button->onTap(clickme());
$combo_box = new ComboBox();
$combo_box->setEmptyItem(true);
$combo_box->setEmptyItemText("Choose options");
$combo_box->setValues("Option 1:1, Option 2:2, Option 3:3");
$mainTable->addControl($combo_box, 1, 1);
$mainTable->addControl($button, 5, 1);
$win->addControl($mainTable);
function clickme()
{
echo "You have selected option number " . $combo_box->getValue();
}
protected function AddInsertColumns(Grid $grid)
{
//
// 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"."ods_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('Id Tipo Espacio', 'id_tipo_espacio', $editor, $this->dataset, 'id_tipo_espacio', '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_contenedor field
//
$editor = new ComboBox('id_espacio_contenedor_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('co_espacio', GetOrderTypeAsSQL(otAscending));
$editColumn = new LookUpEditColumn('Id Espacio Contenedor', 'id_espacio_contenedor', $editor, $this->dataset, 'id_espacio', 'co_espacio', $lookupDataset);
$editColumn->SetAllowSetToNull(true);
$this->ApplyCommonColumnEditProperties($editColumn);
$grid->AddInsertColumn($editColumn);
//
// Edit column for co_espacio field
//
$editor = new TextEdit('co_espacio_edit');
$editor->SetSize(5);
$editor->SetMaxLength(5);
$editColumn = new CustomEditColumn('Código Espacio', 'co_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 no_espacio field
//
$editor = new TextEdit('no_espacio_edit');
$editor->SetSize(100);
$editor->SetMaxLength(100);
$editColumn = new CustomEditColumn('Nombre Espacio', 'no_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 nu_planta field
//
$editor = new TextEdit('nu_planta_edit');
$editColumn = new CustomEditColumn('Número Planta', 'nu_planta', $editor, $this->dataset);
$editColumn->SetAllowSetToNull(true);
$this->ApplyCommonColumnEditProperties($editColumn);
$grid->AddInsertColumn($editColumn);
//
// Edit column for co_plano field
//
$editor = new TextEdit('co_plano_edit');
$editor->SetSize(50);
$editor->SetMaxLength(50);
$editColumn = new CustomEditColumn('Código Plano', 'co_plano', $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 program_name field
//
$editor = new TextEdit('program_name_edit');
$editor->SetSize(50);
$editor->SetMaxLength(50);
$editColumn = new CustomEditColumn(' Name', 'program_name', $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 description field
//
$editor = new TextAreaEdit('description_edit', 50, 8);
$editColumn = new CustomEditColumn('Description', 'description', $editor, $this->dataset);
$editColumn->SetAllowSetToNull(true);
$this->ApplyCommonColumnEditProperties($editColumn);
$grid->AddInsertColumn($editColumn);
//
// Edit column for lead field
//
$editor = new ComboBox('lead_edit', $this->GetLocalizerCaptions()->GetMessageString('PleaseSelect'));
$editColumn = new CustomEditColumn('Lead', 'lead', $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_start field
//
$editor = new DateTimeEdit('date_start_edit', false, 'Y-m-d', GetFirstDayOfWeek());
$editColumn = new CustomEditColumn('Date Start', 'date_start', $editor, $this->dataset);
$editColumn->SetInsertDefaultValue($this->RenderText('%CURRENT_DATE%'));
$validator = new RequiredValidator(StringUtils::Format($this->GetLocalizerCaptions()->GetMessageString('RequiredValidationMessage'), $this->RenderText($editColumn->GetCaption())));
$editor->GetValidatorCollection()->AddValidator($validator);
$this->ApplyCommonColumnEditProperties($editColumn);
$grid->AddInsertColumn($editColumn);
//
// Edit column for date_end field
//
$editor = new DateTimeEdit('date_end_edit', false, 'Y-m-d', GetFirstDayOfWeek());
$editColumn = new CustomEditColumn('Date End', 'date_end', $editor, $this->dataset);
$editColumn->SetInsertDefaultValue($this->RenderText('%CURRENT_DATE%'));
$validator = new RequiredValidator(StringUtils::Format($this->GetLocalizerCaptions()->GetMessageString('RequiredValidationMessage'), $this->RenderText($editColumn->GetCaption())));
$editor->GetValidatorCollection()->AddValidator($validator);
$this->ApplyCommonColumnEditProperties($editColumn);
$grid->AddInsertColumn($editColumn);
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 lis-codart field
//
$editor = new AutocomleteComboBox('lis-codart_edit', $this->CreateLinkBuilder());
$editor->SetSize('350px');
$editor->setAllowClear(true);
$editor->setMinimumInputLength(0);
$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));
$editColumn = new DynamicLookupEditColumn('Codice Articolo', 'lis-codart', 'lis-codart_descrizione', 'insert_lis-codart_descrizione_search', $editor, $this->dataset, $lookupDataset, 'art-codart', 'descrizione', '');
$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 lisdesc field
//
$editor = new TextEdit('lisdesc_edit');
$editor->SetSize(100);
$editColumn = new CustomEditColumn('Descrizione', 'lisdesc', $editor, $this->dataset);
$editColumn->SetReadOnly(true);
$editColumn->SetAllowSetToNull(true);
$this->ApplyCommonColumnEditProperties($editColumn);
$grid->AddInsertColumn($editColumn);
//
// Edit column for lis-unimis field
//
$editor = new ComboBox('lis-unimis_edit', $this->GetLocalizerCaptions()->GetMessageString('PleaseSelect'));
$editor->AddValue('N', $this->RenderText('Nessuna'));
$editor->AddValue('LT', $this->RenderText('Litri'));
$editor->AddValue('KG', $this->RenderText('Chili'));
$editor->AddValue('CF', $this->RenderText('Confezione'));
$editor->AddValue('MC', $this->RenderText('Metri cubi'));
$editor->AddValue('MT', $this->RenderText('Metri'));
$editColumn = new CustomEditColumn('Unità misura', 'lis-unimis', $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 lis-przacq field
//
$editor = new TextEdit('lis-przacq_edit');
$editColumn = new CustomEditColumn('Prezzo acquisto', 'lis-przacq', $editor, $this->dataset);
$editColumn->SetInsertDefaultValue($this->RenderText('0'));
$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 lis-moltipl field
//
$editor = new TextEdit('lis-moltipl_edit');
$editColumn = new CustomEditColumn('Moltiplicatore', 'lis-moltipl', $editor, $this->dataset);
$editColumn->SetReadOnly(true);
$editColumn->SetInsertDefaultValue($this->RenderText('5'));
$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 lis-oneriacc field
//
$editor = new TextEdit('lis-oneriacc_edit');
$editor->SetSuffix($this->RenderText('%'));
$editColumn = new CustomEditColumn('Oneri e accessori', 'lis-oneriacc', $editor, $this->dataset);
$editColumn->SetInsertDefaultValue($this->RenderText('0'));
$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 lis-scarto field
//
$editor = new TextEdit('lis-scarto_edit');
$editor->SetSuffix($this->RenderText('%'));
$editColumn = new CustomEditColumn('Scarto', 'lis-scarto', $editor, $this->dataset);
$editColumn->SetInsertDefaultValue($this->RenderText('0'));
$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 lis-dataini field
//
$editor = new DateTimeEdit('lis-dataini_edit', false, 'd-m-Y', GetFirstDayOfWeek());
$editColumn = new CustomEditColumn('Data inizio decorrenza', 'lis-dataini', $editor, $this->dataset);
$editColumn->SetAllowSetToNull(true);
$editColumn->SetInsertDefaultValue($this->RenderText('%CURRENT_DATETIME%'));
$this->ApplyCommonColumnEditProperties($editColumn);
$grid->AddInsertColumn($editColumn);
//
// Edit column for lis-datafin field
//
$editor = new DateTimeEdit('lis-datafin_edit', false, 'd-m-Y', GetFirstDayOfWeek());
$editColumn = new CustomEditColumn('Data fine decorrenza', 'lis-datafin', $editor, $this->dataset);
$editColumn->SetAllowSetToNull(true);
$editColumn->SetInsertDefaultValue($this->RenderText('31-12-9999'));
$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 FOTO_ID field
//
$editor = new TextEdit('foto_id_edit');
$editColumn = new CustomEditColumn('FOTO ID', 'FOTO_ID', $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 RUTA field
//
$editor = new ImageUploader('ruta_edit');
$editor->SetShowImage(false);
$editColumn = new FileUploadingColumn('RUTA', 'RUTA', $editor, $this->dataset, false, false, 'GE_FOTOGrid_RUTA_handler_insert');
$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 USERNAME field
//
$editor = new ComboBox('username_edit', $this->GetLocalizerCaptions()->GetMessageString('PleaseSelect'));
$lookupDataset = new TableDataset(new OracleConnectionFactory(), GetConnectionOptions(), '"GE"."PERSONA"');
$field = new StringField('USERNAME');
$field->SetIsNotNull(true);
$lookupDataset->AddField($field, true);
$field = new StringField('ES_ADMIN');
$field->SetIsNotNull(true);
$lookupDataset->AddField($field, false);
$field = new DateField('NACIMIENTO');
$lookupDataset->AddField($field, false);
$field = new StringField('PRIMER_APELLIDO');
$lookupDataset->AddField($field, false);
$field = new StringField('SEGUNDO_APELLIDO');
$lookupDataset->AddField($field, false);
$field = new StringField('NOMBRE');
$field->SetIsNotNull(true);
$lookupDataset->AddField($field, false);
$field = new IntegerField('GENERO_ID');
$lookupDataset->AddField($field, false);
$field = new IntegerField('CIUDAD_ID');
$lookupDataset->AddField($field, false);
$field = new StringField('SLOGAN');
$lookupDataset->AddField($field, false);
$field = new DateField('FEC_CREACION');
$lookupDataset->AddField($field, false);
$field = new StringField('USUARIO_CREACION');
$lookupDataset->AddField($field, false);
$field = new DateField('FEC_ULTIMA_MOD');
$lookupDataset->AddField($field, false);
$field = new StringField('USUARIO_ULTIMA_MOD');
$lookupDataset->AddField($field, false);
$field = new StringField('EMAIL');
$field->SetIsNotNull(true);
$lookupDataset->AddField($field, false);
$field = new StringField('CLAVE');
$field->SetIsNotNull(true);
$lookupDataset->AddField($field, false);
$lookupDataset->SetOrderBy('ES_ADMIN', GetOrderTypeAsSQL(otAscending));
$editColumn = new LookUpEditColumn('USERNAME', 'USERNAME', $editor, $this->dataset, 'USERNAME', 'ES_ADMIN', $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 TITULO field
//
$editor = new TextEdit('titulo_edit');
$editor->SetSize(40);
$editor->SetMaxLength(40);
$editColumn = new CustomEditColumn('TITULO', 'TITULO', $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);
}
}
function Main()
{
$codTPL = $_GET["t"];
$codPagina = $_GET["p"];
$codMax = $_GET["m"];
$mensagem = $_GET['msg'];
if (!is_numeric($codTPL)) {
$msg = "@lng[A URL acesada é inválida]";
header("Location:index.php?msg=" . base64_encode($msg));
}
if (!is_numeric($codPagina)) {
$codPagina = 1;
}
$u = unserialize($_SESSION['usu']);
$cnn = new Conexao();
$sql = "SELECT Arquivo FROM mestemplates WHERE Codigo = 2;";
$rs = $cnn->Consulta($sql);
$tpl = file_get_contents(mysql_result($rs, 0, "Arquivo"));
$tpl = str_replace("<!--telatopo-->", Comuns::GeraTopoPagina($u), $tpl);
$tpl = str_replace("<!--Mensagem-->", isset($mensagem) && $mensagem != "" ? base64_decode($mensagem) : "", $tpl);
$sql = "SELECT Classe, jsLoad, linkNovoRegistro, QtdPadListagem FROM mestemplates WHERE Codigo = " . $codTPL . ";";
$rs = $cnn->Consulta($sql);
if ($rs != 0) {
// Classe que será instanciada
$classe = mysql_result($rs, 0, 0);
$frm = new $classe();
if (!is_numeric($codMax)) {
$codMax = mysql_result($rs, 0, 3);
// Quantidade padrão para listagem: 15 (exceto listam de Caso que é 10)
}
Log::RegistraLog("Acessou a tela de " . $frm->RetornaDescricaoTela('lista'));
$where = fntConstroiWhere($codTPL, $_GET);
$lista = $frm->ListaTabela($codPagina, $codMax, $_SESSION['usu'], $where);
$tpl = str_replace("##Lista##", $lista, $tpl);
$tpl = str_replace("##CodTpl##", $codTPL, $tpl);
if (is_null(mysql_result($rs, 0, 2)) || trim(mysql_result($rs, 0, 2)) == "") {
$tpl = str_replace("##linkNovo##", "cadastro.php?t=" . $codTPL, $tpl);
} else {
$tpl = str_replace("##linkNovo##", mysql_result($rs, 0, 2), $tpl);
}
$tpl = str_replace("##FuncoesJS##", mysql_result($rs, 0, 1), $tpl);
$cnnFiltros = Conexao2::getInstance();
$sqlFiltro = "select TipoFiltro, NomeCampoTela, DscCampoTela, ComandoFill, CampoSelValue, CampoSelText, CSSClassCampoTela ";
$sqlFiltro .= "from mestemplatesfiltros where CodTemplate = " . $codTPL . ";";
$cmd = $cnnFiltros->prepare($sqlFiltro);
$cmd->execute();
$tplFiltro = "";
if ($cmd->errorCode() == Comuns::QUERY_OK) {
if ($cmd->rowCount() > 0) {
while ($linha = $cmd->fetch(PDO::FETCH_OBJ)) {
$tplFiltro .= '<label id="lbl' . $linha->NomeCampoTela . '" for="' . $linha->NomeCampoTela . '">';
$tplFiltro .= ' @lng[' . $linha->DscCampoTela . ']<br />';
switch ($linha->TipoFiltro) {
case "TEXTO":
$tplFiltro .= ' <input type="text" name="' . $linha->NomeCampoTela . '" id="' . $linha->NomeCampoTela . '" class="' . $linha->CSSClassCampoTela . '" value="' . ($_GET[$linha->NomeCampoTela] ? $_GET[$linha->NomeCampoTela] : "") . '" />';
break;
case "COMBO":
$arr = null;
Comuns::ArrayObj($linha->ComandoFill, $arr);
$combo = new ComboBox($linha->NomeCampoTela, $arr, $linha->CampoSelValue, $linha->CampoSelText);
$combo->cssClass($linha->CSSClassCampoTela);
$combo->setDefaultValue("");
$combo->setDefaultText("@lng[Todos]");
$tplFiltro .= $combo->RenderHTML();
break;
default:
$tplFiltro .= ' <input type="text" name="' . $linha->NomeCampoTela . '" id="' . $linha->NomeCampoTela . '" class="' . $linha->CSSClassCampoTela . '" value="' . ($_GET[$linha->NomeCampoTela] ? $_GET[$linha->NomeCampoTela] : "") . '" />';
}
$tplFiltro .= '</label><br /><br />';
}
$tpl = str_replace("##Filtros##", $tplFiltro, $tpl);
} else {
$tpl = str_replace("##Filtros##", "@lng[Esta tela não possui filtros para serem aplicados]", $tpl);
}
} else {
$msg = $cmd->errorInfo();
echo $msg[2];
}
}
//header('Content-Type: text/html; charset=iso-8859-1');
echo Comuns::Idioma($tpl);
}
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 CreateSecondEditorControl()
{
$controlName = StringUtils::ReplaceIllegalPostVariableNameChars($this->GetFieldName()) . '_secondvalue';
if (!$this->useComboBox) {
$result = new AutocomleteComboBox($controlName, $this->linkBuilder);
$result->SetHandlerName($this->handlerName);
$result->SetSize('155px');
} else {
$result = new ComboBox($controlName, $this->GetLocalizerCaptions()->GetMessageString('PleaseSelect'));
$this->lookupDataset->Open();
while ($this->lookupDataset->Next()) {
$result->AddValue($this->lookupDataset->GetFieldValueByName($this->idColumn), $this->lookupDataset->GetFieldValueByName($this->valueColumn));
}
$this->lookupDataset->CLose();
}
return $result;
}
protected function AddInsertColumns(Grid $grid)
{
//
// Edit column for ivo-codart field
//
$editor = new AutocomleteComboBox('ivo-codart_edit', $this->CreateLinkBuilder());
$editor->SetSize('250px');
$editor->setAllowClear(true);
$editor->setMinimumInputLength(0);
$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));
$editColumn = new DynamicLookupEditColumn('Codice Articolo', 'ivo-codart', 'ivo-codart_descrizione', 'insert_ivo-codart_descrizione_search', $editor, $this->dataset, $lookupDataset, 'art-codart', 'descrizione', '');
$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 ivo-codvoc field
//
$editor = new ComboBox('ivo-codvoc_edit', $this->GetLocalizerCaptions()->GetMessageString('PleaseSelect'));
$lookupDataset = new TableDataset(new MyPDOConnectionFactory(), GetConnectionOptions(), '`voci_costo`');
$field = new IntegerField('id', null, null, true);
$field->SetIsNotNull(true);
$lookupDataset->AddField($field, true);
$field = new IntegerField('voc-codvoce');
$field->SetIsNotNull(true);
$lookupDataset->AddField($field, false);
$field = new StringField('voc-descriz');
$field->SetIsNotNull(true);
$lookupDataset->AddField($field, false);
$field = new IntegerField('voc-semanual');
$lookupDataset->AddField($field, false);
$field = new IntegerField('voc-formula');
$lookupDataset->AddField($field, false);
$field = new StringField('voc-flagart');
$lookupDataset->AddField($field, false);
$field = new IntegerField('voc-przunit');
$lookupDataset->AddField($field, false);
$field = new DateTimeField('datains');
$lookupDataset->AddField($field, false);
$field = new DateTimeField('datamod');
$lookupDataset->AddField($field, false);
$lookupDataset->setOrderByField('voc-descriz', GetOrderTypeAsSQL(otAscending));
$editColumn = new LookUpEditColumn('Codice Tipo Voce', 'ivo-codvoc', $editor, $this->dataset, 'voc-codvoce', 'voc-descriz', $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 ivo-przunit field
//
$editor = new TextEdit('ivo-przunit_edit');
$editColumn = new CustomEditColumn('Prezzo unitario', 'ivo-przunit', $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 ivo-flagart field
//
$editor = new CheckBox('ivo-flagart_edit');
$editColumn = new CustomEditColumn('Altro articolo', 'ivo-flagart', $editor, $this->dataset);
$editColumn->SetAllowSetToNull(true);
$this->ApplyCommonColumnEditProperties($editColumn);
$grid->AddInsertColumn($editColumn);
//
// Edit column for ivo-flagsmu field
//
$editor = new CheckBox('ivo-flagsmu_edit');
$editColumn = new CustomEditColumn('Prevede smusso', 'ivo-flagsmu', $editor, $this->dataset);
$editColumn->SetAllowSetToNull(true);
$this->ApplyCommonColumnEditProperties($editColumn);
$grid->AddInsertColumn($editColumn);
//
// Edit column for ivo-dataini field
//
$editor = new DateTimeEdit('ivo-dataini_edit', false, 'd-m-Y', GetFirstDayOfWeek());
$editColumn = new CustomEditColumn('Data decorrenza listino', 'ivo-dataini', $editor, $this->dataset);
$editColumn->SetAllowSetToNull(true);
$this->ApplyCommonColumnEditProperties($editColumn);
$grid->AddInsertColumn($editColumn);
//
// Edit column for ivo-datafin field
//
$editor = new DateTimeEdit('ivo-datafin_edit', false, 'd-m-Y', GetFirstDayOfWeek());
$editColumn = new CustomEditColumn('Data fine decorrenza listino', 'ivo-datafin', $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 FEC_WINK field
//
$editor = new DateTimeEdit('fec_wink_edit', false, 'Y-m-d H:i:s', GetFirstDayOfWeek());
$editColumn = new CustomEditColumn('FEC WINK', 'FEC_WINK', $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 USERNAME_EMISOR field
//
$editor = new ComboBox('username_emisor_edit', $this->GetLocalizerCaptions()->GetMessageString('PleaseSelect'));
$lookupDataset = new TableDataset(new OracleConnectionFactory(), GetConnectionOptions(), '"GE"."PERSONA"');
$field = new StringField('USERNAME');
$field->SetIsNotNull(true);
$lookupDataset->AddField($field, true);
$field = new StringField('ES_ADMIN');
$field->SetIsNotNull(true);
$lookupDataset->AddField($field, false);
$field = new DateField('NACIMIENTO');
$lookupDataset->AddField($field, false);
$field = new StringField('PRIMER_APELLIDO');
$lookupDataset->AddField($field, false);
$field = new StringField('SEGUNDO_APELLIDO');
$lookupDataset->AddField($field, false);
$field = new StringField('NOMBRE');
$field->SetIsNotNull(true);
$lookupDataset->AddField($field, false);
$field = new IntegerField('GENERO_ID');
$lookupDataset->AddField($field, false);
$field = new IntegerField('CIUDAD_ID');
$lookupDataset->AddField($field, false);
$field = new StringField('SLOGAN');
$lookupDataset->AddField($field, false);
$field = new DateField('FEC_CREACION');
$lookupDataset->AddField($field, false);
$field = new StringField('USUARIO_CREACION');
$lookupDataset->AddField($field, false);
$field = new DateField('FEC_ULTIMA_MOD');
$lookupDataset->AddField($field, false);
$field = new StringField('USUARIO_ULTIMA_MOD');
$lookupDataset->AddField($field, false);
$field = new StringField('EMAIL');
$field->SetIsNotNull(true);
$lookupDataset->AddField($field, false);
$field = new StringField('CLAVE');
$field->SetIsNotNull(true);
$lookupDataset->AddField($field, false);
$lookupDataset->SetOrderBy('ES_ADMIN', GetOrderTypeAsSQL(otAscending));
$editColumn = new LookUpEditColumn('USERNAME EMISOR', 'USERNAME_EMISOR', $editor, $this->dataset, 'USERNAME', 'ES_ADMIN', $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 USERNAME_RECEPTOR field
//
$editor = new ComboBox('username_receptor_edit', $this->GetLocalizerCaptions()->GetMessageString('PleaseSelect'));
$lookupDataset = new TableDataset(new OracleConnectionFactory(), GetConnectionOptions(), '"GE"."PERSONA"');
$field = new StringField('USERNAME');
$field->SetIsNotNull(true);
$lookupDataset->AddField($field, true);
$field = new StringField('ES_ADMIN');
$field->SetIsNotNull(true);
$lookupDataset->AddField($field, false);
$field = new DateField('NACIMIENTO');
$lookupDataset->AddField($field, false);
$field = new StringField('PRIMER_APELLIDO');
$lookupDataset->AddField($field, false);
$field = new StringField('SEGUNDO_APELLIDO');
$lookupDataset->AddField($field, false);
$field = new StringField('NOMBRE');
$field->SetIsNotNull(true);
$lookupDataset->AddField($field, false);
$field = new IntegerField('GENERO_ID');
$lookupDataset->AddField($field, false);
$field = new IntegerField('CIUDAD_ID');
$lookupDataset->AddField($field, false);
$field = new StringField('SLOGAN');
$lookupDataset->AddField($field, false);
$field = new DateField('FEC_CREACION');
$lookupDataset->AddField($field, false);
$field = new StringField('USUARIO_CREACION');
$lookupDataset->AddField($field, false);
$field = new DateField('FEC_ULTIMA_MOD');
$lookupDataset->AddField($field, false);
$field = new StringField('USUARIO_ULTIMA_MOD');
$lookupDataset->AddField($field, false);
$field = new StringField('EMAIL');
$field->SetIsNotNull(true);
$lookupDataset->AddField($field, false);
$field = new StringField('CLAVE');
$field->SetIsNotNull(true);
$lookupDataset->AddField($field, false);
$lookupDataset->SetOrderBy('ES_ADMIN', GetOrderTypeAsSQL(otAscending));
$editColumn = new LookUpEditColumn('USERNAME RECEPTOR', 'USERNAME_RECEPTOR', $editor, $this->dataset, 'USERNAME', 'ES_ADMIN', $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 Tipo_Documento field
//
$editor = new ComboBox('tipo_documento_edit', $this->GetLocalizerCaptions()->GetMessageString('PleaseSelect'));
$lookupDataset = new TableDataset(new MyConnectionFactory(), GetConnectionOptions(), '`cod_documentos`');
$field = new IntegerField('Codigo');
$field->SetIsNotNull(true);
$lookupDataset->AddField($field, false);
$field = new StringField('Descripcion');
$field->SetIsNotNull(true);
$lookupDataset->AddField($field, false);
$lookupDataset->SetOrderBy('Descripcion', GetOrderTypeAsSQL(otAscending));
$editColumn = new LookUpEditColumn('Tipo Documento', 'Tipo_Documento', $editor, $this->dataset, 'Codigo', 'Descripcion', $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 Num_Identificacion field
//
$editor = new TextEdit('num_identificacion_edit');
$editor->SetSize(45);
$editor->SetMaxLength(45);
$editColumn = new CustomEditColumn('Num Identificacion', 'Num_Identificacion', $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 DV field
//
$editor = new TextEdit('dv_edit');
$editColumn = new CustomEditColumn('DV', 'DV', $editor, $this->dataset);
$editColumn->SetAllowSetToNull(true);
$this->ApplyCommonColumnEditProperties($editColumn);
$grid->AddInsertColumn($editColumn);
//
// Edit column for Primer_Apellido field
//
$editor = new TextEdit('primer_apellido_edit');
$editor->SetSize(45);
$editor->SetMaxLength(45);
$editColumn = new CustomEditColumn('Primer Apellido', 'Primer_Apellido', $editor, $this->dataset);
$editColumn->SetAllowSetToNull(true);
$this->ApplyCommonColumnEditProperties($editColumn);
$grid->AddInsertColumn($editColumn);
//
// Edit column for Segundo_Apellido field
//
$editor = new TextEdit('segundo_apellido_edit');
$editor->SetSize(45);
$editor->SetMaxLength(45);
$editColumn = new CustomEditColumn('Segundo Apellido', 'Segundo_Apellido', $editor, $this->dataset);
$editColumn->SetAllowSetToNull(true);
$this->ApplyCommonColumnEditProperties($editColumn);
$grid->AddInsertColumn($editColumn);
//
// Edit column for Primer_Nombre field
//
$editor = new TextEdit('primer_nombre_edit');
$editor->SetSize(45);
$editor->SetMaxLength(45);
$editColumn = new CustomEditColumn('Primer Nombre', 'Primer_Nombre', $editor, $this->dataset);
$editColumn->SetAllowSetToNull(true);
$this->ApplyCommonColumnEditProperties($editColumn);
$grid->AddInsertColumn($editColumn);
//
// Edit column for Otros_Nombres field
//
$editor = new TextEdit('otros_nombres_edit');
$editor->SetSize(45);
$editor->SetMaxLength(45);
$editColumn = new CustomEditColumn('Otros Nombres', 'Otros_Nombres', $editor, $this->dataset);
$editColumn->SetAllowSetToNull(true);
$this->ApplyCommonColumnEditProperties($editColumn);
$grid->AddInsertColumn($editColumn);
//
// 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);
$grid->AddInsertColumn($editColumn);
//
// Edit column for Direccion field
//
$editor = new TextEdit('direccion_edit');
$editor->SetSize(45);
$editor->SetMaxLength(45);
$editColumn = new CustomEditColumn('Direccion', 'Direccion', $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 Cod_Dpto field
//
$editor = new AutocomleteComboBox('cod_dpto_edit', $this->CreateLinkBuilder());
$editor->SetSize('250px');
$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));
$editColumn = new DynamicLookupEditColumn('Cod Dpto', 'Cod_Dpto', 'Cod_Dpto_Nombre', 'insert_Cod_Dpto_Nombre_search', $editor, $this->dataset, $lookupDataset, 'Cod_dpto', 'Nombre', '');
$editColumn->SetInsertDefaultValue($this->RenderText('76'));
$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 Cod_Mcipio field
//
$editor = new TextEdit('cod_mcipio_edit');
$editor->SetSize(10);
$editor->SetMaxLength(10);
$editColumn = new CustomEditColumn('Cod Mcipio', 'Cod_Mcipio', $editor, $this->dataset);
$editColumn->SetInsertDefaultValue($this->RenderText('111'));
$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 Pais_Domicilio field
//
$editor = new AutocomleteComboBox('pais_domicilio_edit', $this->CreateLinkBuilder());
$editor->SetSize('250px');
$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));
$editColumn = new DynamicLookupEditColumn('Pais Domicilio', 'Pais_Domicilio', 'Pais_Domicilio_Pais', 'insert_Pais_Domicilio_Pais_search', $editor, $this->dataset, $lookupDataset, 'Codigo', 'Pais', '');
$editColumn->SetInsertDefaultValue($this->RenderText('169'));
$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 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);
$grid->AddInsertColumn($editColumn);
//
// Edit column for Ciudad field
//
$editor = new TextEdit('ciudad_edit');
$editor->SetSize(45);
$editor->SetMaxLength(45);
$editColumn = new CustomEditColumn('Ciudad', 'Ciudad', $editor, $this->dataset);
$validator = new RequiredValidator(StringUtils::Format($this->GetLocalizerCaptions()->GetMessageString('RequiredValidationMessage'), $this->RenderText($editColumn->GetCaption())));
$editor->GetValidatorCollection()->AddValidator($validator);
$this->ApplyCommonColumnEditProperties($editColumn);
$grid->AddInsertColumn($editColumn);
//
// Edit column for Contacto field
//
$editor = new TextEdit('contacto_edit');
$editor->SetSize(100);
$editor->SetMaxLength(100);
$editColumn = new CustomEditColumn('Contacto', 'Contacto', $editor, $this->dataset);
$editColumn->SetAllowSetToNull(true);
$this->ApplyCommonColumnEditProperties($editColumn);
$grid->AddInsertColumn($editColumn);
//
// Edit column for TelContacto field
//
$editor = new TextEdit('telcontacto_edit');
$editor->SetSize(45);
$editor->SetMaxLength(45);
$editColumn = new CustomEditColumn('TelContacto', 'TelContacto', $editor, $this->dataset);
$editColumn->SetAllowSetToNull(true);
$this->ApplyCommonColumnEditProperties($editColumn);
$grid->AddInsertColumn($editColumn);
//
// Edit column for Email field
//
$editor = new TextEdit('email_edit');
$editor->SetSize(45);
$editor->SetMaxLength(45);
$editColumn = new CustomEditColumn('Email', 'Email', $editor, $this->dataset);
$editColumn->SetAllowSetToNull(true);
$this->ApplyCommonColumnEditProperties($editColumn);
$grid->AddInsertColumn($editColumn);
//
// Edit column for empresa_id field
//
$editor = new ComboBox('empresa_id_edit', $this->GetLocalizerCaptions()->GetMessageString('PleaseSelect'));
$lookupDataset = new TableDataset(new MyConnectionFactory(), GetConnectionOptions(), '`empresa`');
$field = new IntegerField('id', null, null, true);
$field->SetIsNotNull(true);
$lookupDataset->AddField($field, true);
$field = new StringField('habilitacion');
$field->SetIsNotNull(true);
$lookupDataset->AddField($field, false);
$field = new StringField('nit');
$field->SetIsNotNull(true);
$lookupDataset->AddField($field, false);
$field = new StringField('nombre');
$field->SetIsNotNull(true);
$lookupDataset->AddField($field, false);
$field = new StringField('tipo');
$field->SetIsNotNull(true);
$lookupDataset->AddField($field, false);
$field = new StringField('direccion');
$field->SetIsNotNull(true);
$lookupDataset->AddField($field, false);
$field = new StringField('telefono');
$lookupDataset->AddField($field, false);
$field = new StringField('depto');
$lookupDataset->AddField($field, false);
$field = new StringField('mupio');
$lookupDataset->AddField($field, false);
$lookupDataset->SetOrderBy('nombre', GetOrderTypeAsSQL(otAscending));
$editColumn = new LookUpEditColumn('Empresa Id', 'empresa_id', $editor, $this->dataset, 'id', 'nombre', $lookupDataset);
$editColumn->SetInsertDefaultValue($this->RenderText('1'));
$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 codigo field
//
$editor = new TextEdit('codigo_edit');
$editor->SetSize(20);
$editor->SetMaxLength(20);
$editColumn = new CustomEditColumn('Codigo', 'codigo', $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 estado field
//
$editor = new ComboBox('estado_edit', $this->GetLocalizerCaptions()->GetMessageString('PleaseSelect'));
$editor->AddValue('I', $this->RenderText('Inactivo'));
$editor->AddValue('A', $this->RenderText('Activo'));
$editColumn = new CustomEditColumn('Estado', 'estado', $editor, $this->dataset);
$editColumn->SetInsertDefaultValue($this->RenderText('A'));
$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 regimen field
//
$editor = new ComboBox('regimen_edit', $this->GetLocalizerCaptions()->GetMessageString('PleaseSelect'));
$editor->AddValue('1', $this->RenderText('Contributivo'));
$editor->AddValue('2', $this->RenderText('Subsidiado'));
$editor->AddValue('3', $this->RenderText('Vinculado'));
$editor->AddValue('4', $this->RenderText('Particular'));
$editor->AddValue('5', $this->RenderText('Otro'));
$editColumn = new CustomEditColumn('Regimen', 'regimen', $editor, $this->dataset);
$editColumn->SetInsertDefaultValue($this->RenderText('1'));
$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);
}
}