TDataGrid com TCheckButton não funciona (Ajuda)

Israel Souza 16/01/2020 (há 5 anos)

Duas TDataGrid com TCheckButton na segunda não retorna nada no getData mesmo fazendo addField, alguém pode me ajudar? código abaixo:

<?php
class ExameList extends TPage
{
private $form; // search form
private $datagrid; // listing
private $total;
private $cartgrid;
private $pageNavigation;
private $loaded;
public function __construct()
{
parent::__construct();
//new TSession;
// creates the form
$this->form = new TForm('form_exame');
// create the form fields
$description = new TEntry('paciente');
$check = new THidden('check_');
$description->setSize(170);
$description->setValue(TSession::getValue('product_description'));
$table = new TTable;
$row = $table->addRow();
$cell=$row->addCell('');
$cell->width= 100;
$row->addCell($description);
// creates the action button
$button1=new TButton('find');
$button1->setAction(new TAction(array($this, 'onSearch')), 'Busca');
$button1->setImage('fa:search');
$row->addCell($button1);
$this->form->add($table);
$this->form->setFields(array($description, $button1));
// creates a DataGrid
$this->datagrid = new BootstrapDatagridWrapper(new TDataGrid);
$this->cartgrid = new BootstrapDatagridWrapper(new TDataGrid);
$this->datagrid->style = 'width:100%';
$this->cartgrid->style = 'width:100%';
$this->datagrid->disableDefaultClick();
$this->cartgrid->disableDefaultClick();
//$panel = new TPanelGroup(_t('Datagrids with Checkbutton'));
//$panel->add($this->cartgrid)->style = 'overflow-x:auto';
//$this->form->add($panel);
// creates the datagrid columns
$cartao = new TDataGridColumn('CARTAO', 'Cartão SUS', 'left');
$paciente = new TDataGridColumn('NOME_PAC', 'Nome', 'left');
$sexo = new TDataGridColumn('sexo->nome', 'Sexo', 'left');
$this->datagrid->addColumn($cartao);
$this->datagrid->addColumn($paciente);
$this->datagrid->addColumn($sexo);
$DATA_NASC = new TDataGridColumn('DATA_NASC', 'Idade', 'center');
$this->datagrid->addColumn($DATA_NASC);
$DATA_NASC->setTransformer(function($value, $object, $row)
{
$rotulo = calcIdade::calcularIdade($value);
if ($rotulo <= 18)
{
$bar = new TProgressBar;
$bar->setMask(''.$rotulo.'');
$bar->setValue(100);
$bar->setClass('warning');
return $bar;
}
else if (($rotulo >= 19) && ($rotulo <= 59))
{
$bar = new TProgressBar;
$bar->setMask(''.$rotulo.'');
$bar->setValue(100);
$bar->setClass('success');
return $bar;
}
else
{
$bar = new TProgressBar;
$bar->setMask(''.$rotulo.'');
$bar->setValue(100);
$bar->setClass('danger');
return $bar;
}
});
$status = new TDataGridColumn('status', 'Status', 'center');
$status->setTransformer(function($value, $object, $row)
{
if ($value == 1)
{
$bar = new TProgressBar;
$bar->setMask('Coletado');
$bar->setValue(100);
$bar->setClass('warning');
return $bar;
}
else if ($value == 0)
{
$bar = new TProgressBar;
$bar->setMask('Solicitado');
$bar->setValue(100);
$bar->setClass('success');
return $bar;
}
});
$this->datagrid->addColumn($status);
/////////////////////////////////
$check = new TDataGridColumn('check_', 'ID', 'center', '30');
$referencia = new TDataGridColumn('{referencia->procedimento}', 'Procedimento', 'left');
$material = new TDataGridColumn('{material->nome}', 'Material', 'left');
$this->cartgrid->addColumn($check);
$this->cartgrid->addColumn($referencia);
$this->cartgrid->addColumn($material);
// creates datagrid actions
$action1 = new TDataGridAction([$this, 'onSelect'], ['id' => '{id}','CARTAO' => '{CARTAO}'] );
$action2 = new TDataGridAction([$this, 'onSave'], ['id' => '{id}'] );
$this->datagrid->addAction($action1, 'Select', 'far:check-circle green');
$this->datagrid->addAction($action2, 'Save', 'far:trash-alt red');
//$this->cartgrid->addQuickAction('Delete', new TDataGridAction(array($this, 'onDelete')), 'id', 'fa:trash red');
// create the datagrid model
$this->datagrid->createModel();
$this->cartgrid->createModel();
// creates the page navigation
$this->pageNavigation = new TPageNavigation;
$this->pageNavigation->setAction(new TAction(array($this, 'onReload')));
// creates the page structure using a table
$table1 = new TTable;
$table1->style = 'width: 100%';
$table1->addRow()->addCell($this->form)->height='50';
$table1->addRow()->addCell($this->datagrid);
$table1->addRow()->addCell($this->pageNavigation);
$this->total = new TLabel('');
$this->total->setFontStyle('b');
$table2 = new TTable;
$table2->style = 'width: 100%';
$table2->addRow()->addCell($this->total)->height = '50';
$table2->addRow()->addCell($this->cartgrid);
$hbox = new THBox;
$hbox->add($table1)->style.='vertical-align:top; width: 60%';
$hbox->add($table2)->style.='vertical-align:top; width: 30%';
// wrap the page content using vertical box
$vbox = new TVBox;
$vbox->style = 'width: 100%';
$vbox->add(new TXMLBreadCrumb('menu.xml', __CLASS__));
$vbox->add($hbox);
//$vbox->add($this->pageNavigation);
parent::add($vbox);
}
/**
* Put a product inside the cart
*/
public function onSelect($param)
{
// reload datagrids
// $this->onReload( func_get_arg(0) );
}
public function onSave($param)
{
$data = $this->form->getData();
$this->form->setData($data);
try
{
TTransaction::open('marca');
foreach ($this->form->getFields() as $name => $field)
{
if ($field instanceof TCheckButton)
{
if ($field->getValue() == 'on')
{
$obj = new Exame();
$obj->check_ = 'on';
$obj->store();
}
}
}
TTransaction::close();
}
catch (Exception $e)
{
// show the message
new TMessage('error', $e->getMessage());
}
}
/**
* Remove a product from the cart
*/
public function onDelete($param)
{
// get the cart objects from session
$cart_objects = TSession::getValue('cart_objects');
unset($cart_objects[$param['key']]);
TSession::setValue('cart_objects', $cart_objects);
// reload datagrids
$this->onReload( func_get_arg(0) );
}
/**
* method onSearch()
* Register the filter in the session when the user performs a search
*/
function onSearch()
{
// get the search form data
$data = $this->form->getData();
var_dump($data);
// check if the user has filled the form
if ($data->paciente)
{
// creates a filter using what the user has typed
$filter = new TFilter('paciente', 'like', "%{$data->paciente}%");
// stores the filter in the session
TSession::setValue('product_filter1', $filter);
TSession::setValue('product_description', $data->paciente);
}
else
{
TSession::setValue('product_filter1', NULL);
TSession::setValue('product_description', '');
}
// fill the form with data again
$this->form->setData($data);
$param=array();
$param['offset'] =0;
$param['first_page']=1;
$this->onReload($param);
}
/**
* method onReload()
* Load the datagrid with the database objects
*/
function onReload($param = NULL)
{
try
{
// open a transaction with database 'samples'
TTransaction::open('marca');
// creates a repository for Product
$repository = new TRepository('Exame');
$limit = 10;
// creates a criteria
$criteria = new TCriteria;
$criteria->setProperties($param); // order, offset
$criteria->setProperty('limit', $limit);
$criteria->setProperty('order', 'paciente');
if (TSession::getValue('product_filter1'))
{
// add the filter stored in the session to the criteria
$criteria->add(TSession::getValue('product_filter1'));
}
$conn = TTransaction::get();
$sth = $conn->prepare("SELECT * FROM exame GROUP BY paciente");
$sth->execute();
$resultado = $sth->fetchAll(PDO::FETCH_CLASS);
$this->datagrid->clear();
if ($resultado)
{
foreach ($resultado as $product)
{
$criteria = new TCriteria;
$criteria->add(new TFilter('CARTAO', '=', $product->paciente));
// load using repository
$repository = new TRepository('Paciente');
$customers = $repository->load($criteria);
foreach ($customers as $obj)
{
$obj->status = $product->status;
$this->datagrid->addItem($obj);
}
}
}
if(isset($param['CARTAO']))
{
$criteria = new TCriteria;
$criteria->add(new TFilter('paciente', '=', $param['CARTAO']));
$repository = new TRepository('Exame');
$customers = $repository->load($criteria);
$this->cartgrid->clear();
if ($customers)
{
foreach ($customers as $item)
{
$item->check_ = new TCheckButton('check'.$item->id);
$item->check_->setIndexValue('on');
$this->cartgrid->addItem($item);
$this->form->addField($item->check_);
}
}
}
// reset the criteria for record count
$criteria->resetProperties();
$count= $repository->count($criteria);
$this->pageNavigation->setCount($count); // count of records
$this->pageNavigation->setProperties($param); // order, page
$this->pageNavigation->setLimit($limit); // limit
// close the transaction
TTransaction::close();
$this->loaded = true;
}
catch (Exception $e) // in case of exception
{
// shows the exception error message
new TMessage('error', 'Error ' . $e->getMessage());
// undo all pending operations
TTransaction::rollback();
}
}
/**
* method show()
* Shows the page
*/
function show()
{
// check if the datagrid is already loaded
if (!$this->loaded)
{
$this->onReload( func_get_arg(0) );
}
parent::show();
}
}
?>

Curso Dominando o Adianti Framework

Comentários (5)