Product Massive Update com TCombo

Gustavo Reichelt Emmel 09/11/2015 (há 10 anos)

Oi

Galera.

Alguém já usou o atulizador parecido com deste exemplo:

www.adianti.com.br/framework_files/tutor/index.php?class=ProductUpda

Eu estou tentando usar o exemplo acima em uma FormList, só que ao invés de usar TEntry, eu estou usando TCombos.

Estou com problema ao capturar o valor selecionado na combo, nesta parte do código:

a variavel $field->getValue(); vem vazia...

<?php /** * TipoAtividadeFormList Registration * @author <your name here> */ class TipoAtividadeFormList extends TPage { protected $form; // form protected $datagrid; // datagrid protected $pageNavigation; protected $loaded; /** * Class constructor * Creates the page and the registration form */ function __construct() { parent::__construct(); // creates the form $this->form = new TQuickForm('form_TipoAtividade'); $this->form->class = 'tform'; // CSS class $this->form->setFormTitle('Tabela de Tipos de Atividades'); // define the form title // create the form fields $nome = new TEntry('nome'); $id = new THidden('id'); // add the fields $this->form->addQuickField('Tipo de atividade', $nome, 200, new TRequiredValidator ); $this->form->addQuickField('Cod.', $id, 50); // create the form actions $this->form->addQuickAction(_t('Save'), new TAction(array($this, 'onSave')), 'ico_save.png'); $this->form->addQuickAction(_t('New'), new TAction(array($this, 'onEdit')), 'ico_new.png'); // creates a DataGrid $this->datagrid = new TQuickGrid; $this->datagrid->setHeight(320); $this->datagrid->disableDefaultClick(); // creates the action button $button1 = new TButton('action1'); // define the button action $action_button1 = new TAction(array($this, 'onUpdate')); $action_button1->setParameter('id', filter_input(INPUT_GET, 'id')); $button1->setAction($action_button1, 'Atualizar'); $button1->setImage('ico_apply.png'); $this->form->addField($button1); // creates the datagrid columns $nome = $this->datagrid->addQuickColumn('Tipo de atividade:', 'nome', 'left'); $ticket_id = $this->datagrid->addQuickColumn('Ticket:', 'ticket', 'left'); $sistema_id = $this->datagrid->addQuickColumn('Sistema:', 'sistema', 'left'); // create the datagrid actions $edit_action = new TDataGridAction(array($this, 'onEdit')); $delete_action = new TDataGridAction(array($this, 'onDelete')); // add the actions to the datagrid $this->datagrid->addQuickAction(_t('Edit'), $edit_action, 'id', 'ico_edit.png'); $this->datagrid->addQuickAction(_t('Delete'), $delete_action, 'id', 'ico_delete.png'); // create the datagrid model $this->datagrid->createModel(); // creates the page navigation $this->pageNavigation = new TPageNavigation; $this->pageNavigation->setAction(new TAction(array($this, 'onReload'))); $this->pageNavigation->setWidth($this->datagrid->getWidth()); // create the page container $container = TVBox::pack( $this->form, $button1, $this->datagrid, $this->pageNavigation); $container->style = 'width:80%;max-width:900px'; $this->datagrid->style = 'width:100%'; parent::add($container); } /** * Load the data into the datagrid */ function onReloadTwo() { $this->onReload(); } /** * method onReload() * Load the datagrid with the database objects */ function onReload($param = NULL) { try { TTransaction::open('atividade'); $repository = new TRepository('TipoAtividade'); $criteria = new TCriteria; $criteria->setProperty('order', 'nome asc'); $cadastros = $repository->load($criteria); //array de tickets $ticketItem = array(); $cri = new TCriteria; $cri->setProperty('order', 'id asc'); $repo = new TRepository('Ticket'); $tickets = $repo->load($cri); foreach($tickets as $ticket) { $ticketItem[$ticket->id] = $ticket->id.' - '.$ticket->titulo; } //array de sistemas $sistemaItem = array(); $repo = new TRepository('Sistema'); $sistemas = $repo->load(); foreach($sistemas as $sistema) { $sistemaItem[$sistema->id] = $sistema->nome; } $this->datagrid->clear(); if ($cadastros) { // percorre os objetos retornados foreach ($cadastros as $key => $cadastro) { // add an regular object to the datagrid $itemObj = new StdClass; $itemObj->id = $cadastro->id; $itemObj->nome = $cadastro->nome; $tempId = $cadastro->id; $tempAtiSistema = $cadastro->sistema; $itemObj->sistema = new TCombo('sistema' . $key); $itemObj->sistema->addItems($sistemaItem); $itemObj->sistema->setValue($cadastro->sistema_id); $itemObj->sistema->setSize(180); $tempAtividadeTicket = $cadastro->ticket; $itemObj->ticket = new TCombo('ticket' . $key); $itemObj->ticket->addItems($ticketItem); $itemObj->ticket->setValue($cadastro->ticket_id); $itemObj->ticket->setSize(180); // adiciona o objeto na DataGrid $this->datagrid->addItem($itemObj); $this->form->addField($itemObj->sistema); // important! $this->form->addField($itemObj->ticket); // important! // armazenar valor dos campos no array $itemObj->id = $tempId; $itemObj->sistema = $tempAtiSistema; $itemObj->ticket = $tempAtividadeTicket; // converte campo de objeto para array $array_items[] = get_object_vars($itemObj); } // joga array para sessao TSession::setValue('array_items', $array_items); } // finaliza a transacao TTransaction::close(); $this->loaded = true; } catch (Exception $e) // in case of exception { new TMessage('error', 'Error ' . $e->getMessage()); // shows the exception error message TTransaction::rollback(); // undo all pending operations } } public function onUpdate($param) { $data = $this->form->getData("TipoAtividade"); // optional parameter: active record class // pegar os dados da sessao armazenar na variavel $cotacao_items = TSession::getValue('array_items'); // inicia transacao com o banco 'pg_ceres' TTransaction::open('atividade'); // put the data back to the form $this->form->setData($data); $msg = ''; $contAdd = 0; foreach ($cotacao_items as $item) { $itemObj = new StdClass; $itemObj->id = $item['id']; $itemObj->no = $item['nome']; foreach ($this->form->getFields() as $name => $field) { // pegando valor do combo if ($field instanceof TCombo) { if ($name === ( 'sistema' . $contAdd )) { $itemObj->sistema = $field->getValue(); } if ($name === ( 'ticket' . $contAdd )) { $itemObj->ticket = $field->getValue(); } } } $contAdd++; $cotacao_items_add[] = get_object_vars($itemObj); } try { if ($msg == '') { // percore o objeto e armazena foreach ($cotacao_items_add as $item) { $itemObj = new TipoAtividade($item['id']); $itemObj->nome = $item['nome']; $itemObj->sistema_id = $item['sistema']; $itemObj->ticket_id = $item['ticket']; print $itemObj->sistema_id.' '; // armazena o objeto //$itemObj->store(); } $msg = 'Registro salvo com sucesso!'; // finaliza a transacao TTransaction::close(); } else { $icone = 'error'; } if ($icone == 'error') { // exibe mensagem de erro new TMessage($icone, "Erro ao Salvar o registro!"); } else { // show the message $param = array(); $param['id'] = filter_input(INPUT_GET, 'id'); //chama o formulario com o grid TApplication::gotoPage('TipoAtividadeFormList', 'onReloadTwo', $param); // reload new TMessage("info", $msg); } } catch (Exception $e) { // em caso de exce??o // exibe a mensagem gerada pela excecao new TMessage('error', $e->getMessage()); // desfaz todas altera??es no banco de dados TTransaction::rollback(); } } /** * method onDelete() * executed whenever the user clicks at the delete button * Ask if the user really wants to delete the record */ function onDelete($param) { // define the delete action $action = new TAction(array($this, 'Delete')); $action->setParameters($param); // pass the key parameter ahead // shows a dialog to the user new TQuestion(TAdiantiCoreTranslator::translate('Do you really want to delete ?'), $action); } /** * method Delete() * Delete a record */ function Delete($param) { try { // get the parameter $key $key=$param['key']; TTransaction::open('atividade'); // open the transaction $object = new TipoAtividade($key, FALSE); // instantiates the Active Record $object->delete(); // deletes the object TTransaction::close(); // close the transaction $this->onReload( $param ); // reload the listing new TMessage('info', TAdiantiCoreTranslator::translate('Record deleted')); // success message } catch (Exception $e) // in case of exception { new TMessage('error', 'Error ' . $e->getMessage()); // shows the exception error message TTransaction::rollback(); // undo all pending operations } } /** * method onSave() * Executed whenever the user clicks at the save button */ function onSave() { try { TTransaction::open('atividade'); // open a transaction with database // get the form data into an active record TipoAtividade $object = $this->form->getData('TipoAtividade'); $this->form->validate(); // form validation $object->store(); // stores the object $this->form->setData($object); // fill the form with the active record data TTransaction::close(); // close the transaction new TMessage('info', TAdiantiCoreTranslator::translate('Record saved')); // success message $this->onReload(); // reload the listing } catch (Exception $e) // in case of exception { new TMessage('error', 'Error ' . $e->getMessage()); // shows the exception error message TTransaction::rollback(); // undo all pending operations } } /** * method onEdit() * Executed whenever the user clicks at the edit button da datagrid */ function onEdit($param) { try { if (isset($param['key'])) { $key=$param['key']; // get the parameter $key TTransaction::open('atividade'); // open a transaction with the database $object = new TipoAtividade($key); // instantiates the Active Record $this->form->setData($object); // fill the form with the active record data TTransaction::close(); // close the transaction } else { $this->form->clear(); } } catch (Exception $e) // in case of exception { new TMessage('error', 'Error ' . $e->getMessage()); // shows the exception error message TTransaction::rollback(); // undo all pending operations } } /** * method show() * Shows the page e seu conteÃºdo */ function show() { if (filter_input(INPUT_GET, 'method') == 'onReloadTwo') { // $this->onReloadTwo(); } else { $this->onReload(); } parent::show(); } } ?>

<?php /** * Run before the datagrid is loaded */ public function onBeforeLoad($objects, $param) { // update the action parameters to pass the current page to action // without this, the action will only work for the first page $saveAction = $this->saveButton->getAction(); $saveAction->setParameters($param); // important! $gridfields = array( $this->saveButton ); foreach ($objects as $object) { $object->status_widget = new TDBCombo('status', 'db_academico', 'Status', 'id', 'description'); $object->status_widget->setValue( $object->status ); $object->status_widget->setSize(120); $gridfields[] = $object->status_widget; // important } $this->formgrid->setFields($gridfields); } ?>

Curso Dominando o Adianti Framework

Comentários (11)