SQLSTATE[3F000]: Invalid schema name

Rubens Bispo de Souza 26/10/2022 (há 2 anos)

Olá, pessoal, estou recebendo a seguinte mensagem ao carregar uma grid.

SQLSTATE[3F000]: Invalid schema name: 7 ERROR: schema "teste" does not exist LINE 1: SELECT count(*) FROM "teste"."unit_historic" ^..

Porém os dados são carregados.

Meu model

<?php
class UnitHistory extends TRecord
{
const TABLENAME = 'sgo.unit_historic';
const PRIMARYKEY= 'id';
const IDPOLICY = 'max'; // {max, serial}
private $unit_type;
private $person;
private $system_unit;
private $upper_unit;
public function __construct($id = NULL, $callObjectLoad = TRUE)
{
parent::__construct($id, $callObjectLoad);
parent::addAttribute('created');
parent::addAttribute('updated');
parent::addAttribute('active');
parent::addAttribute('end_date');
parent::addAttribute('start_date');
parent::addAttribute('system_unit_id');
parent::addAttribute('type_id');
parent::addAttribute('observation');
parent::addAttribute('responsible_id');
parent::addAttribute('code');
parent::addAttribute('upper_id');
parent::addAttribute('code_upper');
}
public function set_unit_type(UnitType $object)
{
$this->unit_type = $object;
$this->unit_type_id = $object->id;
}
public function get_unit_type()
{
try{
TTransaction::open('teste');
// loads the associated object
if (empty($this->unit_type))
$this->unit_type = new UnitType($this->type_id);
// returns the associated object
return $this->unit_type;
TTransaction::close();
}
catch (Exception $e)
{
parent::add($e->getMessage());
}
}
public function set_person(Person $object)
{
$this->person = $object;
$this->person_id = $object->id;
}
public function get_person()
{
// loads the associated object
if (empty($this->person))
$this->person = new Person($this->person_id);
// returns the associated object
return $this->person;
}
public function set_system_unit(SystemUnit $object)
{
$this->system_unit = $object;
$this->system_unit_id = $object->id;
}
public function get_system_unit()
{
try{
TTransaction::open('permission');
if (empty($this->system_unit))
{
$system_unit = SystemUnit::where('id','=',$this->system_unit_id)->load();
$this->system_unit = $system_unit[0];
}
return $this->system_unit;
TTransaction::close();
}
catch (Exception $e)
{
parent::add($e->getMessage());
}
}
public function get_upper_unit()
{
try{
TTransaction::open('permission');
if (empty($this->upper_unit))
{
$upper_unit = SystemUnit::where('id','=',$this->upper_id)->load();
$this->upper_unit = $upper_unit[0];
}
return $this->upper_unit;
TTransaction::close();
}
catch (Exception $e)
{
parent::add($e->getMessage());
}
}
}
?>

Grid

<?php
class UnitDataGrid extends TPage
{
protected $form; // registration form
protected $datagrid; // listing
protected $pageNavigation;
use Adianti\base\AdiantiStandardListTrait;
public function __construct()
{
parent::__construct();
$this->setDatabase('sgo'); // defines the database
$this->setActiveRecord('UnitHistory'); // defines the active record
$this->setDefaultOrder('id', 'asc'); // defines the default order
$this->setLimit(5);
//$this->setCriteria($criteria) // define a standard filter
$this->addFilterField('id', '=', 'id'); // filterField, operator, formField
$this->addFilterField('system_unit->code_unit', 'like', 'code'); // filterField, operator, formField
$this->addFilterField('system_unit_id', '=', 'system_unit_id'); // filterField, operator, formField
$this->addFilterField('type_id', '=', 'type_id'); // filterField, operator, formField
$this->addFilterField('code_upper', 'like', 'code_upper'); // filterField, operator, formField
$this->addFilterField('upper_id', 'like', 'upper_id'); // filterField, operator, formField
$this->addFilterField('start_date', 'like', 'start_date'); // filterField, operator, formField
$this->addFilterField('responsible_id', 'like', 'responsible_id'); // filterField, operator, formField
$this->addFilterField('observation', 'like', 'observation'); // filterField, operator, formField
$this->addFilterField('active', 'like', 'active'); //filterField, operator, formField
$this->form = new TForm('form_search_UnitHistory');
$this->form->style = 'overflow-x:auto';
$id = new TEntry('id');
$code = new TEntry('code');
$system_unit_id = new TDBUniqueSearch('system_unit_id', 'permission', 'SystemUnit', 'id','name');
//$type_id = new TEntry('type_id');
$type_id = new TDBUniqueSearch('type_id', 'sgo', 'UnitType', 'id','name');
$code_upper = new TEntry('code_upper');
$upper_id = new TEntry('upper_id');
$start_date = new TEntry('start_date');
$responsible_id = new TEntry('responsible_id');
$observation = new TEntry('observation');
$active = new TEntry('active');
$id->exitOnEnter();
$code->exitOnEnter();
//$type_id->exitOnEnter();
$code_upper->exitOnEnter();
$upper_id->exitOnEnter();
$start_date->exitOnEnter();
$responsible_id->exitOnEnter();
$observation->exitOnEnter();
$active->exitOnEnter();
$id->setSize('100%');
$code->setSize('100%');
$system_unit_id->setSize('100%');
$type_id->setSize('100%');
$code_upper->setSize('100%');
$upper_id->setSize('100%');
$start_date->setSize('100%');
$responsible_id->setSize('100%');
$observation->setSize('100%');
$active->setSize('100%');
$id->tabindex = -1;
$code->tabindex = -1;
$system_unit_id->tabindex = -1;
$type_id->tabindex = -1;
$code_upper->tabindex = -1;
$upper_id->tabindex = -1;
$start_date->tabindex = -1;
$responsible_id->tabindex = -1;
$observation->tabindex = -1;
$active->tabindex = -1;
$id->setExitAction( new TAction([$this, 'onSearch'], ['static'=>'1']));
$code->setExitAction( new TAction([$this, 'onSearch'], ['static'=>'1']));
$system_unit_id->setChangeAction( new TAction([$this, 'onSearch'], ['static'=>'1']));
$type_id->setChangeAction( new TAction([$this, 'onSearch'], ['static'=>'1']));
//$type_id->setExitAction( new TAction([$this, 'onSearch'], ['static'=>'1']));
$code_upper->setExitAction( new TAction([$this, 'onSearch'], ['static'=>'1']) );
$upper_id->setExitAction( new TAction([$this, 'onSearch'], ['static'=>'1']) );
$start_date->setExitAction( new TAction([$this, 'onSearch'], ['static'=>'1']) );
$responsible_id->setExitAction( new TAction([$this, 'onSearch'], ['static'=>'1']) );
$observation->setExitAction( new TAction([$this, 'onSearch'], ['static'=>'1']) );
$active->setExitAction( new TAction([$this, 'onSearch'], ['static'=>'1']) );
//creates a DataGrid
$this->datagrid = new BootstrapDatagridWrapper(new TDataGrid);
$this->datagrid->style = 'width: 100%';
//$this->datagrid->enablePopover('Popover', 'Hi <b> {name} </b>');
//creates the datagrid columns
$column_id = new TDataGridColumn('id', '#', 'center');
$column_code = new TDataGridColumn('code',_t('Code'), 'center');
$column_system_unit_id = new TDataGridColumn('system_unit->name', _t('Unit'), 'left');
$column_type_id = new TDataGridColumn('unit_type->name',_t('Type'), 'left');
$column_code_upper = new TDataGridColumn('code_upper',_t('Code'), 'center');
$column_upper_id = new TDataGridColumn('upper_unit->name', _t('Higher'), 'left');
$column_start_date = new TDataGridColumn('start_date', 'Start Date', 'left');
$column_responsible_id = new TDataGridColumn('responsible_id', 'Responsible', 'left');
$column_observation = new TDataGridColumn('observation', 'Observation', 'left');
$column_active = new TDataGridColumn('active',_t('Active'), 'center');
//add the columns to the DataGrid
$this->datagrid->addColumn($column_id);
$this->datagrid->addColumn($column_code);
$this->datagrid->addColumn($column_system_unit_id);
$this->datagrid->addColumn($column_type_id);
$this->datagrid->addColumn($column_code_upper);
$this->datagrid->addColumn($column_upper_id);
$this->datagrid->addColumn($column_start_date);
$this->datagrid->addColumn($column_responsible_id);
$this->datagrid->addColumn($column_observation);
$this->datagrid->addColumn($column_active);
//creates the datagrid column actions
$column_id->setAction(new TAction([$this, 'onReload']), ['order' => 'id']);
$column_code->setAction(new TAction([$this, 'onReload']), ['order' => 'code']);
$column_system_unit_id->setAction(new TAction([$this, 'onReload']), ['order' => 'system_unit_id']);
$column_type_id->setAction(new TAction([$this, 'onReload']), ['order' => 'type_id']);
$column_code_upper->setAction(new TAction([$this, 'onReload']), ['order' => 'code_upper']);
$column_upper_id->setAction(new TAction([$this, 'onReload']), ['order' => 'upper_id']);
$column_start_date->setAction(new TAction([$this, 'onReload']), ['order' => 'start_date']);
$column_responsible_id->setAction(new TAction([$this, 'onReload']), ['order' => 'responsible_id']);
//define the transformer method over image
$column_start_date->setTransformer( function($value, $object, $row) {
if ($value)
{
try
{
$date = new DateTime($value);
return $date->format('d/m/Y');
}
catch (Exception $e)
{
return $value;
}
}
return $value;
});
$action1 = new TDataGridAction(['SgoUnits', 'onEdit'], ['id'=>'{id}']);
$action2 = new TDataGridAction([$this, 'onDelete'], ['id'=>'{id}']);
$action3 = new TDataGridAction(['FormResponsible', 'onSend'], ['id'=>'{id}']);
$this->datagrid->addAction($action1, _t('Edit'), 'far:edit blue');
$this->datagrid->addAction($action2 ,_t('Delete'), 'far:trash-alt red');
$this->datagrid->addAction($action3 ,_t('Edit'), 'fa:plus green');
//create the datagrid model
$this->datagrid->createModel();
//add datagrid inside form
$this->form->add($this->datagrid);
//create row with search inputs
$tr = new TElement('tr');
$this->datagrid->prependRow($tr);
$tr->add( TElement::tag('td',''));
$tr->add( TElement::tag('td',''));
$tr->add( TElement::tag('td',''));
$tr->add( TElement::tag('td', $id));
$tr->add( TElement::tag('td', $code));
$tr->add( TElement::tag('td', $system_unit_id));
$tr->add( TElement::tag('td', $type_id));
$tr->add( TElement::tag('td', $code_upper));
$tr->add( TElement::tag('td', $upper_id));
$tr->add( TElement::tag('td', $start_date));
$tr->add( TElement::tag('td', $responsible_id));
$tr->add( TElement::tag('td', $observation));
$tr->add( TElement::tag('td', $active));
$this->form->addField($id);
$this->form->addField($code);
$this->form->addField($system_unit_id);
$this->form->addField($type_id);
$this->form->addField($code_upper);
$this->form->addField($upper_id);
$this->form->addField($start_date);
$this->form->addField($responsible_id);
$this->form->addField($observation);
$this->form->addField($active);
//keep form filled
$this->form->setData( TSession::getValue(__CLASS__.'_filter_data'));
//create the page navigation
$this->pageNavigation = new TPageNavigation;
$this->pageNavigation->setAction(new TAction([$this, 'onReload']));
$this->pageNavigation->enableCounters();
$panel = new TPanelGroup(_t('Units'));
//turn on horizontal scrolling inside panel body
$panel->getBody()->style = "overflow-x:auto;";
$panel->add($this->form);
$panel->addFooter($this->pageNavigation);
//header actions
$dropdown = new TDropDown(_t('Export'), 'fa:list');
$dropdown->setPullSide('right');
$dropdown->setButtonClass('btn btn-default waves-effect dropdown-toggle');
$dropdown->addAction( _t('Save as CSV'), new TAction([$this, 'onExportCSV'], ['register_state' => 'false', 'static'=>'1']), 'fa:table blue');
$dropdown->addAction( _t('Save as PDF'), new TAction([$this, 'onExportPDF'], ['register_state' => 'false', 'static'=>'1']), 'far:file-pdf red');
$dropdown->addAction( 'Save as XLS', new TAction([$this, 'onExportXLS'], ['register_state' => 'false', 'static'=>'1']), 'fa:file-excel fa-fw purple');
$dropdown->addAction( 'Save as XML', new TAction([$this, 'onExportXML'], ['register_state' => 'false', 'static'=>'1']), 'fa:code fa-fw green');
$panel->addHeaderWidget( $dropdown );
$panel->addHeaderActionLink( _t('New'), new TAction(['SgoUnits', 'onEdit'], ['register_state' => 'false']), 'fa:plus green' );
$panel->addHeaderActionLink(_t('Record Updated'),new TAction([__CLASS__, 'onReload'],['register_state' => 'false', 'static'=>'1']), 'fa:plus green' );
//vertical box container
$container = new TVBox;
$container->style = 'width: 100%';
//$container->add(new TXMLBreadCrumb('menu.xml', __CLASS__));
$container->add($panel);
parent::add($container);
}
}
?>

Editado 26/10/2022 (há 2 anos) - Clique para ver alterações

Curso Dominando o Adianti Framework

Comentários (0)