Conheça Características Quem usa Galeria Cursos Docs Fórum
Downloads
Posts Fique por dentro Sobre o Fórum Minha conta
Carregar dados de um Datagrid Boa tarde a todos, Preciso carregar os dados de um datagrid de uma tela mestre detalhe. O que acontece é que se eu fizer: ...
WS
Carregar dados de um Datagrid  
William Souza 17/12/2020 (há 4 anos)
Boa tarde a todos,

Preciso carregar os dados de um datagrid de uma tela mestre detalhe. O que acontece é que se eu fizer: 

 
  1. <?php
  2.         $data = $this->datagrid->getItems();
  3.        // var_dump($data);
  4.         if($data)
  5.         {
  6.             foreach ($data as $registro)
  7.             {
  8.                 $teste = 'teste: ' . $registro->id;
  9.                 echo $teste;
  10.                 
  11.             }
  12.         
  13.     }
  14. ?>


não consigo pegar dados. Lei as postagens antigas mas nenhuma resolveu.

Não vou colocar meu codigo aqui porque vai ocupar muito espaço. Vou colar um codigo do tutor com o método save alterado para entendimento apenas. Se conseguir fazer o getItems funcionar eu sigo tranquilo. Segue o código: 

 
  1. <?php
  2. /**
  4. class SaleForm extends TWindow
  5. {
  6.     protected $form; // form
  7.     
  8.     /**
  9.      * Class constructor
  10.      * Creates the page and the registration form
  11.      */
  12.     function __construct()
  13.     {
  14.         parent::__construct();
  15.         parent::setSize(0.8, null);
  16.         parent::removePadding();
  17.         parent::removeTitleBar();
  18.         parent::disableEscape();
  19.         
  20.         // creates the form
  21.         $this->form = new BootstrapFormBuilder('form_Sale');
  22.         $this->form->setFormTitle('Sale');
  23.         $this->form->setProperty('style', 'margin:0;border:0');
  24.         $this->form->setClientValidation(true);
  25.         
  26.         // master fields
  27.         $id          = new TEntry('id');
  28.         $date        = new TDate('date');
  29.         $customer_id = new TDBUniqueSearch('customer_id', 'samples', 'Customer', 'id', 'name');
  30.         $obs         = new TText('obs');
  31.         
  32.         $button = new TActionLink('', new TAction(['CustomerFormWindow', 'onEdit']), 'green', null, null, 'fa:plus-circle');
  33.         $button->class = 'btn btn-default inline-button';
  34.         $button->title = _t('New');
  35.         $customer_id->after($button);
  36.         
  37.         // detail fields
  38.         $product_detail_unqid      = new THidden('product_detail_uniqid');
  39.         $product_detail_id         = new THidden('product_detail_id');
  40.         $product_detail_product_id = new TDBUniqueSearch('product_detail_product_id', 'samples', 'Product', 'id', 'description');
  41.         $product_detail_price      = new TEntry('product_detail_price');
  42.         $product_detail_amount     = new TEntry('product_detail_amount');
  43.         $product_detail_discount   = new TEntry('product_detail_discount');
  44.         $product_detail_total      = new TEntry('product_detail_total');
  45.         
  46.         // adjust field properties
  47.         $id->setEditable(false);
  48.         //$customer_id->setSize('100%');
  49.         $customer_id->setSize('calc(100% - 30px)');
  50.         $customer_id->setMinLength(1);
  51.         $date->setSize('100%');
  52.         $obs->setSize('100%', 80);
  53.         $product_detail_product_id->setSize('100%');
  54.         $product_detail_product_id->setMinLength(1);
  55.         $product_detail_price->setSize('100%');
  56.         $product_detail_amount->setSize('100%');
  57.         $product_detail_discount->setSize('100%');
  58.         
  59.         // add validations
  60.         $date->addValidation('Date', new TRequiredValidator);
  61.         $customer_id->addValidation('Customer', new TRequiredValidator);
  62.         
  63.         // change action
  64.         $product_detail_product_id->setChangeAction(new TAction([$this,'onProductChange']));
  65.         
  66.         // add master form fields
  67.         $this->form->addFields( [new TLabel('ID')], [$id], 
  68.                                 [new TLabel('Date (*)', '#FF0000')], [$date] );
  69.         $this->form->addFields( [new TLabel('Customer (*)', '#FF0000')], [$customer_id ] );
  70.         $this->form->addFields( [new TLabel('Obs')], [$obs] );
  71.         
  72.         $this->form->addContent( ['<h4>Details</h4><hr>'] );
  73.         $this->form->addFields( [ $product_detail_unqid], [$product_detail_id] );
  74.         $this->form->addFields( [ new TLabel('Product (*)', '#FF0000') ], [$product_detail_product_id],
  75.                                 [ new TLabel('Amount(*)', '#FF0000') ],   [$product_detail_amount] );
  76.         $this->form->addFields( [ new TLabel('Price (*)', '#FF0000') ],   [$product_detail_price],
  77.                                 [ new TLabel('Discount')],                [$product_detail_discount] );
  78.         
  79.         $add_product = TButton::create('add_product', [$this, 'onProductAdd'], 'Register', 'fa:plus-circle green');
  80.         $add_product->getAction()->setParameter('static','1');
  81.         $this->form->addFields( [], [$add_product] );
  82.         
  83.         $this->product_list = new BootstrapDatagridWrapper(new TDataGrid);
  84.         $this->product_list->setHeight(150);
  85.         $this->product_list->makeScrollable();
  86.         $this->product_list->setId('products_list');
  87.         $this->product_list->generateHiddenFields();
  88.         $this->product_list->style = "min-width: 700px; width:100%;margin-bottom: 10px";
  89.         
  90.         $col_uniq   = new TDataGridColumn( 'uniqid', 'Uniqid', 'center', '10%');
  91.         $col_id     = new TDataGridColumn( 'id', 'ID', 'center', '10%');
  92.         $col_pid    = new TDataGridColumn( 'product_id', 'ProdID', 'center', '10%');
  93.         $col_descr  = new TDataGridColumn( 'product_id', 'Product', 'left', '30%');
  94.         $col_amount = new TDataGridColumn( 'amount', 'Amount', 'left', '10%');
  95.         $col_price  = new TDataGridColumn( 'sale_price', 'Price', 'right', '15%');
  96.         $col_disc   = new TDataGridColumn( 'discount', 'Discount', 'right', '15%');
  97.         $col_subt   = new TDataGridColumn( '={amount} * ( {sale_price} - {discount} )', 'Subtotal', 'right', '20%');
  98.         
  99.         $this->product_list->addColumn( $col_uniq );
  100.         $this->product_list->addColumn( $col_id );
  101.         $this->product_list->addColumn( $col_pid );
  102.         $this->product_list->addColumn( $col_descr );
  103.         $this->product_list->addColumn( $col_amount );
  104.         $this->product_list->addColumn( $col_price );
  105.         $this->product_list->addColumn( $col_disc );
  106.         $this->product_list->addColumn( $col_subt );
  107.         
  108.         $col_descr->setTransformer(function($value) {
  109.             return Product::findInTransaction('samples', $value)->description;
  110.         });
  111.         
  112.         $col_subt->enableTotal('sum', 'R$', 2, ',', '.');
  113.         
  114.         $col_id->setVisibility(false);
  115.         $col_uniq->setVisibility(false);
  116.         
  117.         // creates two datagrid actions
  118.         $action1 = new TDataGridAction([$this, 'onEditItemProduto'] );
  119.         $action1->setFields( ['uniqid', '*'] );
  120.         
  121.         $action2 = new TDataGridAction([$this, 'onDeleteItem']);
  122.         $action2->setField('uniqid');
  123.         
  124.         // add the actions to the datagrid
  125.         $this->product_list->addAction($action1, _t('Edit'), 'far:edit blue');
  126.         $this->product_list->addAction($action2, _t('Delete'), 'far:trash-alt red');
  127.         
  128.         $this->product_list->createModel();
  129.         
  130.         $panel = new TPanelGroup;
  131.         $panel->add($this->product_list);
  132.         $panel->getBody()->style = 'overflow-x:auto';
  133.         $this->form->addContent( [$panel] );
  134.         
  135.         $format_value = function($value) {
  136.             if (is_numeric($value)) {
  137.                 return 'R$ '.number_format($value, 2, ',', '.');
  138.             }
  139.             return $value;
  140.         };
  141.         
  142.         $col_price->setTransformer( $format_value );
  143.         $col_disc->setTransformer( $format_value );
  144.         $col_subt->setTransformer( $format_value );
  145.         
  146.         $this->form->addHeaderActionLink( _t('Close'),  new TAction([__CLASS__, 'onClose'], ['static'=>'1']), 'fa:times red');
  147.         $this->form->addAction( 'Save',  new TAction([$this, 'onSave'], ['static'=>'1']), 'fa:save green');
  148.         $this->form->addAction( 'Clear', new TAction([$this, 'onClear']), 'fa:eraser red');
  149.         
  150.         // create the page container
  151.         $container = new TVBox;
  152.         $container->style = 'width: 100%';
  153.         //$container->add(new TXMLBreadCrumb('menu.xml', __CLASS__));
  154.         $container->add($this->form);
  155.         parent::add($container);
  156.     }
  157.     
  158.     /**
  159.      * Pre load some data
  160.      */
  161.     public function onLoad($param)
  162.     {
  163.         $data = new stdClass;
  164.         $data->customer_id   = $param['customer_id'];
  165.         $this->form->setData($data);
  166.     }
  167.     
  168.     
  169.     /**
  170.      * On product change
  171.      */
  172.     public static function onProductChange( $params )
  173.     {
  174.         if( !empty($params['product_detail_product_id']) )
  175.         {
  176.             try
  177.             {
  178.                 TTransaction::open('samples');
  179.                 $product   = new Product($params['product_detail_product_id']);
  180.                 TForm::sendData('form_Sale', (object) ['product_detail_price' => $product->sale_price ]);
  181.                 TTransaction::close();
  182.             }
  183.             catch (Exception $e)
  184.             {
  185.                 new TMessage('error', $e->getMessage());
  186.                 TTransaction::rollback();
  187.             }
  188.         }
  189.     }
  190.     
  191.     
  192.     /**
  193.      * Clear form
  194.      * @param $param URL parameters
  195.      */
  196.     function onClear($param)
  197.     {
  198.         $this->form->clear();
  199.     }
  200.     
  201.     /**
  202.      * Add a product into item list
  203.      * @param $param URL parameters
  204.      */
  205.     public function onProductAdd( $param )
  206.     {
  207.         try
  208.         {
  209.             $this->form->validate();
  210.             $data = $this->form->getData();
  211.             
  212.             if( (! $data->product_detail_product_id) || (! $data->product_detail_amount) || (! $data->product_detail_price) )
  213.             {
  214.                 throw new Exception('The fields Product, Amount and Price are required');
  215.             }
  216.             
  217.             $uniqid = !empty($data->product_detail_uniqid) ? $data->product_detail_uniqid : uniqid();
  218.             
  219.             $grid_data = ['uniqid'      => $uniqid,
  220.                           'id'          => $data->product_detail_id,
  221.                           'product_id'  => $data->product_detail_product_id,
  222.                           'amount'      => $data->product_detail_amount,
  223.                           'sale_price'  => $data->product_detail_price,
  224.                           'discount'    => $data->product_detail_discount];
  225.             
  226.             // insert row dynamically
  227.             $row = $this->product_list->addItem( (object) $grid_data );
  228.             $row->id = $uniqid;
  229.             
  230.             TDataGrid::replaceRowById('products_list', $uniqid, $row);
  231.             
  232.             // clear product form fields after add
  233.             $data->product_detail_uniqid     = '';
  234.             $data->product_detail_id         = '';
  235.             $data->product_detail_product_id = '';
  236.             $data->product_detail_name       = '';
  237.             $data->product_detail_amount     = '';
  238.             $data->product_detail_price      = '';
  239.             $data->product_detail_discount   = '';
  240.             
  241.             // send data, do not fire change/exit events
  242.             TForm::sendData( 'form_Sale', $data, false, false );
  243.         }
  244.         catch (Exception $e)
  245.         {
  246.             $this->form->setData( $this->form->getData());
  247.             new TMessage('error', $e->getMessage());
  248.         }
  249.     }
  250.     
  251.     /**
  252.      * Edit a product from item list
  253.      * @param $param URL parameters
  254.      */
  255.     public static function onEditItemProduto( $param )
  256.     {
  257.         $data = new stdClass;
  258.         $data->product_detail_uniqid     = $param['uniqid'];
  259.         $data->product_detail_id         = $param['id'];
  260.         $data->product_detail_product_id = $param['product_id'];
  261.         $data->product_detail_amount     = $param['amount'];
  262.         $data->product_detail_price      = $param['sale_price'];
  263.         $data->product_detail_discount   = $param['discount'];
  264.         
  265.         // send data, do not fire change/exit events
  266.         TForm::sendData( 'form_Sale', $data, false, false );
  267.     }
  268.     
  269.     /**
  270.      * Delete a product from item list
  271.      * @param $param URL parameters
  272.      */
  273.     public static function onDeleteItem( $param )
  274.     {
  275.         $data = new stdClass;
  276.         $data->product_detail_uniqid     = '';
  277.         $data->product_detail_id         = '';
  278.         $data->product_detail_product_id = '';
  279.         $data->product_detail_amount     = '';
  280.         $data->product_detail_price      = '';
  281.         $data->product_detail_discount   = '';
  282.         
  283.         // send data, do not fire change/exit events
  284.         TForm::sendData( 'form_Sale', $data, false, false );
  285.         
  286.         // remove row
  287.         TDataGrid::removeRowById('products_list', $param['uniqid']);
  288.     }
  289.     
  290.     /**
  291.      * Edit Sale
  292.      */
  293.     public function onEdit($param)
  294.     {
  295.         try
  296.         {
  297.             TTransaction::open('samples');
  298.             
  299.             if (isset($param['key']))
  300.             {
  301.                 $key = $param['key'];
  302.                 
  303.                 $object = new Sale($key);
  304.                 $sale_items = SaleItem::where('sale_id', '=', $object->id)->load();
  305.                 
  306.                 foreach( $sale_items as $item )
  307.                 {
  308.                     $item->uniqid = uniqid();
  309.                     $row = $this->product_list->addItem( $item );
  310.                     $row->id = $item->uniqid;
  311.                 }
  312.                 $this->form->setData($object);
  313.                 TTransaction::close();
  314.             }
  315.             else
  316.             {
  317.                 $this->form->clear();
  318.             }
  319.         }
  320.         catch (Exception $e)
  321.         {
  322.             new TMessage('error', $e->getMessage());
  323.             TTransaction::rollback();
  324.         }
  325.     }
  326.     
  327.     /**
  328.      * Save the sale and the sale items
  329.      */
  330.     public function onSave($param)
  331.     {
  332.         $data = $this->datagrid->getItems();
  333.         var_dump($data);
  334.         if($data)
  335.         {
  336.             foreach ($data as $registro)
  337.             {
  338.                 $teste = 'teste: ' . $registro->id;
  339.                 echo $teste;
  340.                 
  341.             }
  342.         }
  343.     }
  344.     
  345.     /**
  346.      * Closes window
  347.      */
  348.     public static function onClose()
  349.     {
  350.         parent::closeWindow();
  351.     }
  352. }
  354. ?>


obrigado

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 (3)

NR
Nataniel Rabaioli       19/12/2020 (há 4 anos)

A solução está nesse mesmo exemplo que você passou. Veja a função onSave original do tutor: 
 
  1. <?php
  2. if( !empty($param['products_list_product_id'] ))
  3. {
  4.      foreach( $param['products_list_product_id'] as $key => $item_id )
  5.      {
  6.            $item = new SaleItem;
  7.            $item->product_id  = $item_id;
  8.            $item->sale_price  = (float) $param['products_list_sale_price'][$key];
  9.            $item->amount      = (float) $param['products_list_amount'][$key];
  10.            $item->discount    = (float) $param['products_list_discount'][$key];
  11.            ....
  12. ?>

Ou seja, você vai pegar os dados da grid via $param(post), pois a grid está sendo alimentada estaticamente e assim na onSave ela vai estar vazia.
NR
Nataniel Rabaioli       19/12/2020 (há 4 anos)

Não recebi o email de confirmação anterior...
WS
William Souza - AUTOR DO POST       21/12/2020 (há 4 anos)

Oi Nataniel Rabaioli,

só agora vou conseguir dar andamento no código.
Vou testar e posto oresultado.

muito obrigado pela ajuda!