Ajuda com TDBMultiSearch.

Ajuda com TDBMultiSearch. ...

Miguel Lino 17/10/2017 (há 6 anos)

Boa tarde. Comprei o Livro, videos e estou estudando. Porém depois de tentar por semanas, resolvi pedir ajuda.

Estou usando o TDBMultiSearch num form Master/Detalhe. Para Inclusão, está funcionando perfeito.

Mas quando eu abro a tela para Editar, no Detalhe vem todos os campos certinhos, mas o TDBMultiSearch não consigo preencher com os dados da tabela.
Print em anexo.

Desde já agradeço pela ajuda.
Abraço.

Curso completo Meu Negócio Pronto

Use para si, ou transforme em um negócio: Inclui aulas e códigos-fontes
Gestor de conteúdo (SITE) + Loja Virtual (E-Commerce) + Emissor de Notas para infoprodutos

Meu negócio pronto Quero me inscrever agora!

Comentários (4)

Miguel Lino - AUTOR DO POST 17/10/2017 (há 6 anos)

<?php
/**
* ConveniosTeste Master/Detail
* @author <your name here>
*/
class ConveniosForm extends TPage
{
protected $form; // form
protected $table_details;
protected $detail_row;
/**
* Class constructor
* Creates the page and the registration form
*/
function __construct($param)
{
parent::__construct($param);
// creates the form
$this->form = new TForm('form_ModelConvenios');
$this->form->class = 'tform'; // CSS class
$table_master = new TTable;
$table_master->width = '100%';
$table_master->addRowSet( new TLabel('Convênios'), '', '')->class = 'tformtitle';
// add a table inside form
$table_general = new TTable;
$table_general->width = '100%';
$frame_general = new TFrame;
$frame_general->class = 'tframe tframe-custom';
$frame_general->setLegend('Convênios');
$frame_general->style = 'background:whiteSmoke';
$frame_general->add($table_general);
$frame_details = new TFrame;
$frame_details->class = 'tframe tframe-custom';
$frame_details->style = 'background:whiteSmoke';
$frame_details->setLegend('Serviços autorizados para o Convênio');
$frame_details->oid = 'frame_details';
parent::include_css('app/resources/custom-frame.css');
parent::include_css('app/resources/custom-notebook.css');
parent::include_css('app/resources/custom-table.css');
$table_master->addRow()->addCell( $frame_general )->colspan=2;
$row = $table_master->addRow();
$row->addCell( $frame_details );
$this->form->add($table_master);
// master fields
$id = new TEntry('id');
$descricao = new TEntry('descricao');
$observacao = new TEntry('observacao');
// sizes
$id->setSize('100');
$descricao->setSize('200');
$observacao->setSize('200');
$descricao->style = ('text-align:left;color:#00688B;font-weight:bold;font-size:16px;');
$id->style = ('text-align:left;color:#00688B;font-weight:bold;font-size:16px;');
$observacao->style = ('text-align:left;color:#00688B;font-weight:bold;font-size:14px;');
if (!empty($id))
{
$id->setEditable(FALSE);
}
// add form fields to be handled by form
$this->form->addField($id);
$this->form->addField($descricao);
$this->form->addField($observacao);
// add form fields to the screen
$table_general->addRowSet( new TLabel('Id'), $id );
$table_general->addRowSet( new TLabel('Descricao'), $descricao );
$table_general->addRowSet( new TLabel('Observacao'), $observacao );
// detail
$this->table_details = new TTable;
$this->table_details-> width = '100%';
$frame_details->add($this->table_details);
$this->table_details->addSection('thead');
$row = $this->table_details->addRow();
// detail header
$row->addCell( new TLabel('Serviço'));
$row->addCell( new TLabel('Valor') );
$row->addCell( new TLabel('Co Participacao') );
$row->addCell( new TLabel('Ctafin Convenio') );
$row->addCell( new TLabel('Ctafin Cliente') );
$row->addCell( new TLabel('Empresa') );
// create an action button (save)
$save_button=new TButton('save');
$save_button->setAction(new TAction(array($this, 'onSave')), _t('Save'));
$save_button->setImage('ico_save.png');
// create an new button (edit with no parameters)
$new_button=new TButton('new');
$new_button->setAction(new TAction(array($this, 'onClear')), _t('New'));
$new_button->setLabel('Novo Convênio');
$new_button->setImage('ico_new.png');
$button = new TButton('show_hide');
$button->class ='btn btn-warning btn-sm';
$button->setLabel('Mostrar/Ocultar Serviços do Convênio');
$button->addFunction("\$('[oid=frame_details]').slideToggle(); $(this).toggleClass( 'active' )");
$frame_general->add($button);
// define form fields
$this->form->addField($save_button);
$this->form->addField($new_button);
$table_master->addRowSet( array($save_button, $new_button), '', '')->class = 'tformaction'; // CSS class
$this->detail_row = 0;
// create the page container
$container = new TVBox;
$container->style = 'width: 100%';
$container->add($this->form);
parent::add($container);
}
function onEdit($param)
{
try
{
TTransaction::open('SysClinicaWeb');
if (isset($param['key']))
{
$key = $param['key'];
$object = new ModelConvenios($key);
$this->form->setData($object);
$items = ConveniosxservicosModel::where('CONVENIO_ID', '=', $key)->load();
$this->table_details->addSection('tbody');
if ($items)
{
foreach($items as $item )
{
$this->addDetailRow($item);
}
// create add button
$add = new TButton('clone');
$add->setLabel('Incluir Serviço');
$add->class ='btn btn-warning btn-sm';
$add->setImage('fa:plus-circle green');
$add->addFunction('ttable_clone_previous_row(this)');
// add buttons in table
$this->table_details->addRowSet([$add]);
}
else
{
$this->onClear($param);
}
TTransaction::close(); // close transaction
}
}
catch (Exception $e) // in case of exception
{
new TMessage('error', $e->getMessage());
TTransaction::rollback();
}
}
/**
* Add detail row
*/
public function addDetailRow($item)
{
$uniqid = mt_rand(1000000, 9999999);
// create fields
$SERVICO_ID = new TDBMultiSearch('SERVICO_ID[]', 'SysClinicaWeb', 'ServicosModel', 'id', 'descricao');
$SERVICO_ID->setMaxSize(1);
$SERVICO_ID->setMinLength(1);
$VALOR = new TEntry('VALOR[]');
$CO_PARTICIPACAO = new TEntry('CO_PARTICIPACAO[]');
$CTAFIN_CONVENIO = new TEntry('CTAFIN_CONVENIO[]');
$CTAFIN_CLIENTE = new TEntry('CTAFIN_CLIENTE[]');
$EMPRESA = new TEntry('EMPRESA[]');
$CONVENIO_ID = new TEntry('CONVENIO_ID[]');
$SERVICO_ID->style = ('text-align:left;color:#00688B;font-weight:;font-size:15px;');
$VALOR->style = ('text-align:left;color:#00688B;font-weight:;font-size:15px;');
$CO_PARTICIPACAO->style = ('text-align:left;color:#00688B;font-weight:;font-size:15px;');
$CTAFIN_CLIENTE->style = ('text-align:left;color:#00688B;font-weight:;font-size:15px;');
$CTAFIN_CONVENIO->style = ('text-align:left;color:#00688B;font-weight:;font-size:15px;');
// set sizes
$VALOR->setSize('145');
$CO_PARTICIPACAO->setSize('100');
$CTAFIN_CONVENIO->setSize('90');
$CTAFIN_CLIENTE->setSize('90');
$EMPRESA->setSize('40');
$SERVICO_ID->setSize('300');
$CONVENIO_ID->setSize('40');
$VALOR->setNumericMask(2, '.', ',');
$CO_PARTICIPACAO->setNumericMask(2, '.', ',');
$EMPRESA->setEditable(FALSE);
// set id's
$SERVICO_ID->setId('SERVICO_ID_'.$uniqid);
$VALOR->setId('VALOR_'.$uniqid);
$CO_PARTICIPACAO->setId('CO_PARTICIPACAO_'.$uniqid);
$CTAFIN_CONVENIO->setId('CTAFIN_CONVENIO_'.$uniqid);
$CTAFIN_CLIENTE->setId('CTAFIN_CLIENTE_'.$uniqid);
$EMPRESA->setId('EMPRESA_'.$uniqid);
$CONVENIO_ID->setId('CONVENIO_ID_'.$uniqid);
// set row counter
$SERVICO_ID->{'data-row'} = $this->detail_row;
$CONVENIO_ID->{'data-row'} = $this->detail_row;
$VALOR->{'data-row'} = $this->detail_row;
$CO_PARTICIPACAO->{'data-row'} = $this->detail_row;
$CTAFIN_CONVENIO->{'data-row'} = $this->detail_row;
$CTAFIN_CLIENTE->{'data-row'} = $this->detail_row;
$EMPRESA->{'data-row'} = $this->detail_row;
// set value
// *********
if (!empty($item->SERVICO_ID)) { $SERVICO_ID->setValue(array($item->SERVICO_ID=>'descricao') );}
if (!empty($item->CONVENIO_ID)) { $CONVENIO_ID->setValue(array($item->CONVENIO_ID) );}
if (!empty($item->VALOR)) { $VALOR->setValue( $item->VALOR ); }
if (!empty($item->CO_PARTICIPACAO)) { $CO_PARTICIPACAO->setValue( $item->CO_PARTICIPACAO ); }
if (!empty($item->CTAFIN_CONVENIO)) { $CTAFIN_CONVENIO->setValue( $item->CTAFIN_CONVENIO ); }
if (!empty($item->CTAFIN_CLIENTE)) { $CTAFIN_CLIENTE->setValue( $item->CTAFIN_CLIENTE ); }
if (!empty($item->EMPRESA)) { $EMPRESA->setValue( $item->EMPRESA ); }
// create delete button
$del = new TImage('fa:trash-o red');
$del->onclick = 'ttable_remove_row(this)';
$row = $this->table_details->addRow();
$row->{'data-row'} = $this->detail_row;
// add cells
$row->addCell($SERVICO_ID);
$row->addCell($VALOR);
$row->addCell($CO_PARTICIPACAO);
$row->addCell($CTAFIN_CONVENIO);
$row->addCell($CTAFIN_CLIENTE);
$row->addCell($EMPRESA);
// $row->addCell($CONVENIO_ID);
$row->addCell( $del );
// add form field
$this->form->addField($SERVICO_ID);
$this->form->addField($VALOR);
$this->form->addField($CO_PARTICIPACAO);
$this->form->addField($CTAFIN_CONVENIO);
$this->form->addField($CTAFIN_CLIENTE);
$this->form->addField($EMPRESA);
$this->form->addField($CONVENIO_ID);
$this->detail_row ++;
}
/**
* Clear form
*/
public function onClear($param)
{
$this->table_details->addSection('tbody');
$this->addDetailRow( new stdClass );
// create add button
$add = new TButton('clone');
$add->setLabel('Incluir Serviço');
$add->setImage('fa:plus-circle green');
$add->class ='btn btn-warning btn-sm';
$add->addFunction('ttable_clone_previous_row(this)');
// add buttons in table
$this->table_details->addRowSet([$add]);
}
/**
* Save the ModelConvenios and the ConveniosxservicosModel's
*/
public static function onSave($param)
{
try
{
TTransaction::open('SysClinicaWeb');
$id = (int) $param['id'];
$master = new ModelConvenios;
$master->fromArray( $param);
$master->store(); // save master object
// delete details
ConveniosxservicosModel::where('CONVENIO_ID', '=', $master->id)->delete();
if( !empty($param['VALOR']) AND is_array($param['VALOR']) )
{
foreach( $param['VALOR'] as $row => $VALOR)
{
if (!empty($VALOR))
{
$detail = new ConveniosxservicosModel;
$detail->CONVENIO_ID = $master->id;
$detail->VALOR = $param['VALOR'][$row];
$detail->CO_PARTICIPACAO = $param['CO_PARTICIPACAO'][$row];
$detail->CTAFIN_CONVENIO = $param['CTAFIN_CONVENIO'][$row];
$detail->CTAFIN_CLIENTE = $param['CTAFIN_CLIENTE'][$row];
$detail->EMPRESA = $param['EMPRESA'][$row];
$detail->SERVICO_ID = $param['SERVICO_ID'][$row];
$detail->store();
}
}
}
$data = new stdClass;
$data->id = $master->id;
TForm::sendData('form_ModelConvenios', $data);
TTransaction::close(); // close the transaction
new TMessage('info', TAdiantiCoreTranslator::translate('Record saved'));
}
catch (Exception $e) // in case of exception
{
new TMessage('error', $e->getMessage());
TTransaction::rollback();
}
}
}
</your>

Miguel Lino - AUTOR DO POST 17/10/2017 (há 6 anos)

<?php
/**
* ConveniosxservicosModel Active Record
* @author <your-name-here>
*/
class ConveniosxservicosModel extends TRecord
{
const TABLENAME = 'conveniosxservicos';
const PRIMARYKEY= 'id';
const IDPOLICY = 'max'; // {max, serial}
private $servicos_model;
/**
* Constructor method
*/
public function __construct($id = NULL, $callObjectLoad = TRUE)
{
parent::__construct($id, $callObjectLoad);
parent::addAttribute('VALOR');
parent::addAttribute('CO_PARTICIPACAO');
parent::addAttribute('CTAFIN_CONVENIO');
parent::addAttribute('CTAFIN_CLIENTE');
parent::addAttribute('EMPRESA');
parent::addAttribute('SERVICO_ID');
parent::addAttribute('CONVENIO_ID');
}
}

Nataniel Rabaioli 18/10/2017 (há 6 anos)

Você precisa passar um array associativo(chave,descricao) para o multisearch. Crie uma associação com o modelo correspondente ao SERVICO_ID no modelo ConveniosxservicosModel e aí modifique o trecho abaixo:

<?php
//if (!empty($item->SERVICO_ID)) { $SERVICO_ID->setValue(array($item->SERVICO_ID=>'descricao') );}
// supondo que exista uma função get_servico(associacao) no ConveniosxservicosModel e no modelo da associacao exista uma coluna chamada descricao
if (!empty($item->SERVICO_ID)) { $SERVICO_ID->setValue(array($item->SERVICO_ID=>$item->servico->descricao) );}
?>

Miguel Lino - AUTOR DO POST 18/10/2017 (há 6 anos)

Muito Obrigado Nataniel.

Ótima explicação. Agora ta funcionando perfeitamente.

Novo Comentário