Conheça Características Quem usa Galeria Cursos Docs Fórum
Downloads
Posts Fique por dentro Sobre o Fórum Minha conta
SQLSTATE[3F000]: Invalid schema name 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 ...
RS
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 

 
  1. <?php
  3. class UnitHistory extends TRecord
  4. {
  5.     const TABLENAME = 'sgo.unit_historic';
  6.     const PRIMARYKEY= 'id';
  7.     const IDPOLICY =  'max'; // {max, serial}
  9.     private $unit_type;
  10.     private $person;
  11.     private $system_unit;
  12.     private $upper_unit;
  14.     public function __construct($id = NULL, $callObjectLoad = TRUE)
  15.     {
  16.         parent::__construct($id, $callObjectLoad);
  17.         parent::addAttribute('created');
  18.         parent::addAttribute('updated');
  19.         parent::addAttribute('active');
  20.         parent::addAttribute('end_date');
  21.         parent::addAttribute('start_date');
  22.         parent::addAttribute('system_unit_id');
  23.         parent::addAttribute('type_id');
  24.         parent::addAttribute('observation');
  25.         parent::addAttribute('responsible_id');
  26.         parent::addAttribute('code');
  27.         parent::addAttribute('upper_id');
  28.         parent::addAttribute('code_upper');
  29.     }
  31.     public function set_unit_type(UnitType $object)
  32.     {
  33.         $this->unit_type = $object;
  34.         $this->unit_type_id = $object->id;
  35.     }
  37.     public function get_unit_type()
  38.     {
  39.       try{
  40.           TTransaction::open('teste');
  41.           // loads the associated object
  42.           if (empty($this->unit_type))
  43.               $this->unit_type = new UnitType($this->type_id);
  45.           // returns the associated object
  46.           return $this->unit_type;
  48.           TTransaction::close();
  49.         }
  50.         catch (Exception $e)
  51.         {
  52.             parent::add($e->getMessage());
  53.         }
  54.     }
  55.    
  56.     public function set_person(Person $object)
  57.     {
  58.         $this->person = $object;
  59.         $this->person_id = $object->id;
  60.     }
  62.     public function get_person()
  63.     {
  64.         // loads the associated object
  65.         if (empty($this->person))
  66.             $this->person = new Person($this->person_id);
  68.         // returns the associated object
  69.         return $this->person;
  70.     }
  72.     public function set_system_unit(SystemUnit $object)
  73.     {
  74.         $this->system_unit = $object;
  75.         $this->system_unit_id = $object->id;
  76.     }
  78.     public function get_system_unit()
  79.     {
  80.         try{
  81.             TTransaction::open('permission');
  82.             if (empty($this->system_unit))
  83.             {
  84.                 $system_unit = SystemUnit::where('id','=',$this->system_unit_id)->load();
  85.                 $this->system_unit = $system_unit[0];
  86.             }
  87.             return $this->system_unit;
  88.               TTransaction::close();
  89.         }
  90.         catch (Exception $e)
  91.         {
  92.             parent::add($e->getMessage());
  93.         }
  94.     }
  96.     public function get_upper_unit()
  97.     {
  98.         try{
  99.             TTransaction::open('permission');
  100.             if (empty($this->upper_unit))
  101.             {
  102.                 $upper_unit = SystemUnit::where('id','=',$this->upper_id)->load();
  103.                 $this->upper_unit = $upper_unit[0];
  104.             }
  105.             return $this->upper_unit;
  106.               TTransaction::close();
  107.         }
  108.         catch (Exception $e)
  109.         {
  110.             parent::add($e->getMessage());
  111.         }
  112.     }
  113. }
  114. ?>

Grid 
 
  1. <?php
  2. class UnitDataGrid extends TPage
  3. {
  4.     protected $form;     // registration form
  5.     protected $datagrid; // listing
  6.     protected $pageNavigation;
  8.     use Adianti\base\AdiantiStandardListTrait;
  10.     public function __construct()
  11.     {
  12.         parent::__construct();
  14.         $this->setDatabase('sgo');            // defines the database
  15.         $this->setActiveRecord('UnitHistory');   // defines the active record
  16.         $this->setDefaultOrder('id', 'asc');         // defines the default order
  17.         $this->setLimit(5);
  18.         //$this->setCriteria($criteria) // define a standard filter
  20.         $this->addFilterField('id', '=', 'id'); // filterField, operator, formField
  21.         $this->addFilterField('system_unit->code_unit', 'like', 'code'); // filterField, operator, formField
  22.         $this->addFilterField('system_unit_id', '=', 'system_unit_id'); // filterField, operator, formField
  23.         $this->addFilterField('type_id', '=', 'type_id'); // filterField, operator, formField
  24.         $this->addFilterField('code_upper', 'like', 'code_upper'); // filterField, operator, formField
  25.         $this->addFilterField('upper_id', 'like', 'upper_id'); // filterField, operator, formField
  26.         $this->addFilterField('start_date', 'like', 'start_date'); // filterField, operator, formField
  27.         $this->addFilterField('responsible_id', 'like', 'responsible_id'); // filterField, operator, formField
  28.         $this->addFilterField('observation', 'like', 'observation'); // filterField, operator, formField
  29.         $this->addFilterField('active', 'like', 'active'); //filterField, operator, formField
  31.         $this->form = new TForm('form_search_UnitHistory');
  32.         $this->form->style = 'overflow-x:auto';
  34.         $id = new TEntry('id');
  35.         $code = new TEntry('code');
  36.         $system_unit_id = new TDBUniqueSearch('system_unit_id', 'permission', 'SystemUnit', 'id','name');
  37.         //$type_id = new TEntry('type_id');
  38.         $type_id = new TDBUniqueSearch('type_id', 'sgo', 'UnitType', 'id','name');
  39.         $code_upper = new TEntry('code_upper');
  40.         $upper_id = new TEntry('upper_id');
  41.         $start_date = new TEntry('start_date');
  42.         $responsible_id = new TEntry('responsible_id');
  43.         $observation = new TEntry('observation');
  44.         $active = new TEntry('active');
  46.         $id->exitOnEnter();
  47.         $code->exitOnEnter();
  48.         //$type_id->exitOnEnter();
  49.         $code_upper->exitOnEnter();
  50.         $upper_id->exitOnEnter();
  51.         $start_date->exitOnEnter();
  52.         $responsible_id->exitOnEnter();
  53.         $observation->exitOnEnter();
  54.         $active->exitOnEnter();
  56.         $id->setSize('100%');
  57.         $code->setSize('100%');
  58.         $system_unit_id->setSize('100%');
  59.         $type_id->setSize('100%');
  60.         $code_upper->setSize('100%');
  61.         $upper_id->setSize('100%');
  62.         $start_date->setSize('100%');
  63.         $responsible_id->setSize('100%');
  64.         $observation->setSize('100%');
  65.         $active->setSize('100%');
  67.         $id->tabindex = -1;
  68.         $code->tabindex = -1;
  69.         $system_unit_id->tabindex = -1;
  70.         $type_id->tabindex = -1;
  71.         $code_upper->tabindex = -1;
  72.         $upper_id->tabindex = -1;
  73.         $start_date->tabindex = -1;
  74.         $responsible_id->tabindex = -1;
  75.         $observation->tabindex = -1;
  76.         $active->tabindex = -1;
  78.         $id->setExitAction( new TAction([$this, 'onSearch'], ['static'=>'1']));
  79.         $code->setExitAction( new TAction([$this, 'onSearch'], ['static'=>'1']));
  80.         $system_unit_id->setChangeAction( new TAction([$this, 'onSearch'], ['static'=>'1']));
  81.         $type_id->setChangeAction( new TAction([$this, 'onSearch'], ['static'=>'1']));
  82.         //$type_id->setExitAction( new TAction([$this, 'onSearch'], ['static'=>'1']));
  83.         $code_upper->setExitAction( new TAction([$this, 'onSearch'], ['static'=>'1']) );
  84.         $upper_id->setExitAction( new TAction([$this, 'onSearch'], ['static'=>'1']) );
  85.         $start_date->setExitAction( new TAction([$this, 'onSearch'], ['static'=>'1']) );
  86.         $responsible_id->setExitAction( new TAction([$this, 'onSearch'], ['static'=>'1']) );
  87.         $observation->setExitAction( new TAction([$this, 'onSearch'], ['static'=>'1']) );
  88.         $active->setExitAction( new TAction([$this, 'onSearch'], ['static'=>'1']) );
  90.         //creates a DataGrid
  91.         $this->datagrid = new BootstrapDatagridWrapper(new TDataGrid);
  92.         $this->datagrid->style = 'width: 100%';
  93.         //$this->datagrid->enablePopover('Popover', 'Hi <b> {name} </b>');
  95.         //creates the datagrid columns
  96.         $column_id = new TDataGridColumn('id', '#', 'center');
  97.         $column_code = new TDataGridColumn('code',_t('Code'), 'center');
  98.         $column_system_unit_id = new TDataGridColumn('system_unit->name', _t('Unit'), 'left');
  99.         $column_type_id = new TDataGridColumn('unit_type->name',_t('Type'), 'left');
  100.         $column_code_upper = new TDataGridColumn('code_upper',_t('Code'), 'center');
  101.         $column_upper_id = new TDataGridColumn('upper_unit->name', _t('Higher'), 'left');
  102.         $column_start_date = new TDataGridColumn('start_date', 'Start Date', 'left');
  103.         $column_responsible_id = new TDataGridColumn('responsible_id', 'Responsible', 'left');
  104.         $column_observation = new TDataGridColumn('observation', 'Observation', 'left');
  105.         $column_active = new TDataGridColumn('active',_t('Active'), 'center');
  107.         //add the columns to the DataGrid
  108.         $this->datagrid->addColumn($column_id);
  109.         $this->datagrid->addColumn($column_code);
  110.         $this->datagrid->addColumn($column_system_unit_id);
  111.         $this->datagrid->addColumn($column_type_id);
  112.         $this->datagrid->addColumn($column_code_upper);
  113.         $this->datagrid->addColumn($column_upper_id);
  114.         $this->datagrid->addColumn($column_start_date);
  115.         $this->datagrid->addColumn($column_responsible_id);
  116.         $this->datagrid->addColumn($column_observation);
  117.         $this->datagrid->addColumn($column_active);
  119.         //creates the datagrid column actions
  120.         $column_id->setAction(new TAction([$this, 'onReload']), ['order' => 'id']);
  121.         $column_code->setAction(new TAction([$this, 'onReload']), ['order' => 'code']);
  122.         $column_system_unit_id->setAction(new TAction([$this, 'onReload']), ['order' => 'system_unit_id']);
  123.         $column_type_id->setAction(new TAction([$this, 'onReload']), ['order' => 'type_id']);
  124.         $column_code_upper->setAction(new TAction([$this, 'onReload']), ['order' => 'code_upper']);
  125.         $column_upper_id->setAction(new TAction([$this, 'onReload']), ['order' => 'upper_id']);
  126.         $column_start_date->setAction(new TAction([$this, 'onReload']), ['order' => 'start_date']);
  127.         $column_responsible_id->setAction(new TAction([$this, 'onReload']), ['order' => 'responsible_id']);
  129.         //define the transformer method over image
  130.         $column_start_date->setTransformer( function($value, $object, $row) {
  131.             if ($value)
  132.             {
  133.                 try
  134.                 {
  135.                     $date = new DateTime($value);
  136.                     return $date->format('d/m/Y');
  137.                 }
  138.                 catch (Exception $e)
  139.                 {
  140.                     return $value;
  141.                 }
  142.             }
  143.             return $value;
  144.         });
  146.         $action1 = new TDataGridAction(['SgoUnits', 'onEdit'], ['id'=>'{id}']);
  147.         $action2 = new TDataGridAction([$this, 'onDelete'], ['id'=>'{id}']);
  148.         $action3 = new TDataGridAction(['FormResponsible', 'onSend'], ['id'=>'{id}']);
  150.         $this->datagrid->addAction($action1, _t('Edit'),   'far:edit blue');
  151.         $this->datagrid->addAction($action2 ,_t('Delete'), 'far:trash-alt red');
  152.         $this->datagrid->addAction($action3 ,_t('Edit'), 'fa:plus green');
  153.         //create the datagrid model
  154.         $this->datagrid->createModel();
  156.         //add datagrid inside form
  157.         $this->form->add($this->datagrid);
  159.         //create row with search inputs
  160.         $tr = new TElement('tr');
  161.         $this->datagrid->prependRow($tr);
  163.         $tr->add( TElement::tag('td',''));
  164.         $tr->add( TElement::tag('td',''));
  165.         $tr->add( TElement::tag('td',''));
  166.         $tr->add( TElement::tag('td', $id));
  167.         $tr->add( TElement::tag('td', $code));
  168.         $tr->add( TElement::tag('td', $system_unit_id));
  169.         $tr->add( TElement::tag('td', $type_id));
  170.         $tr->add( TElement::tag('td', $code_upper));
  171.         $tr->add( TElement::tag('td', $upper_id));
  172.         $tr->add( TElement::tag('td', $start_date));
  173.         $tr->add( TElement::tag('td', $responsible_id));
  174.         $tr->add( TElement::tag('td', $observation));
  175.         $tr->add( TElement::tag('td', $active));
  177.         $this->form->addField($id);
  178.         $this->form->addField($code);
  179.         $this->form->addField($system_unit_id);
  180.         $this->form->addField($type_id);
  181.         $this->form->addField($code_upper);
  182.         $this->form->addField($upper_id);
  183.         $this->form->addField($start_date);
  184.         $this->form->addField($responsible_id);
  185.         $this->form->addField($observation);
  186.         $this->form->addField($active);
  188.         //keep form filled
  189.         $this->form->setData( TSession::getValue(__CLASS__.'_filter_data'));
  191.         //create the page navigation
  192.         $this->pageNavigation = new TPageNavigation;
  193.         $this->pageNavigation->setAction(new TAction([$this, 'onReload']));
  194.         $this->pageNavigation->enableCounters();
  196.         $panel = new TPanelGroup(_t('Units'));
  197.         //turn on horizontal scrolling inside panel body
  198.         $panel->getBody()->style = "overflow-x:auto;";
  199.         $panel->add($this->form);
  200.         $panel->addFooter($this->pageNavigation);
  202.         //header actions
  203.         $dropdown = new TDropDown(_t('Export'), 'fa:list');
  204.         $dropdown->setPullSide('right');
  205.         $dropdown->setButtonClass('btn btn-default waves-effect dropdown-toggle');
  206.         $dropdown->addAction( _t('Save as CSV'), new TAction([$this, 'onExportCSV'], ['register_state' => 'false', 'static'=>'1']), 'fa:table blue');
  207.         $dropdown->addAction( _t('Save as PDF'), new TAction([$this, 'onExportPDF'], ['register_state' => 'false', 'static'=>'1']), 'far:file-pdf red');
  208.         $dropdown->addAction( 'Save as XLS', new TAction([$this, 'onExportXLS'], ['register_state' => 'false', 'static'=>'1']), 'fa:file-excel fa-fw purple');
  209.         $dropdown->addAction( 'Save as XML', new TAction([$this, 'onExportXML'], ['register_state' => 'false', 'static'=>'1']), 'fa:code fa-fw green');
  210.         $panel->addHeaderWidget( $dropdown );
  212.         $panel->addHeaderActionLink( _t('New'),  new TAction(['SgoUnits', 'onEdit'], ['register_state' => 'false']), 'fa:plus green' );
  213.         $panel->addHeaderActionLink(_t('Record Updated'),new TAction([__CLASS__, 'onReload'],['register_state' => 'false', 'static'=>'1']), 'fa:plus green' );
  215.         //vertical box container
  216.         $container = new TVBox;
  217.         $container->style = 'width: 100%';
  218.         //$container->add(new TXMLBreadCrumb('menu.xml', __CLASS__));
  219.         $container->add($panel);
  221.         parent::add($container);
  222.     }
  223. }
  225. ?>


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

Curso Dominando o Adianti Framework

O material mais completo de treinamento do Framework.
Curso em vídeo aulas + Livro completo + Códigos fontes do projeto ERPHouse.
Conteúdo Atualizado!


Dominando o Adianti Framework Quero me inscrever agora!

Comentários (0)