How to Foreach with Smarty Using Key

Asked

Viewed 20 times

1

I’m making an appointment in my BD to build a relationship with some NF numbers and their respective dates, but the result is being the last record, of which there are three.

What I’ve done so far:

  // BUSCANDO DADOS DA AUTORIZAÇÃO
  $this->GetConnection()->ExecQueryToArray('  
SELECT 
  `cadAutorizacaoNF`.NumeroNF,
  `cadAutorizacaoNF`.DataEmissaoNF
FROM
  `cadAutorizacaoNF`
  INNER JOIN `cadAutorizacao` ON (`cadAutorizacaoNF`.IdAutorizacao = `cadAutorizacao`.IdAutorizacao)
WHERE
  (`cadAutorizacaoNF`.IdAutorizacao = '.$IdAutorizacao.')', $queryResultNF);

  $RegistrosNF = array();

  foreach ($queryResultNF as $RegInfNf) {
      $RegistrosNF[$RegInfNf['IdAutorizacao']] = array(
          'NumeroNF' => $RegInfNf['NumeroNF'],
          'DataEmissaoNF' => $RegInfNf['DataEmissaoNF'],  
      );

  }  
  $params['RegistrosNF'] = $RegistrosNF;

My template that shows the result is like this:

{foreach from=$RegistrosNF item=RegInfNf key=IdAutorizacao}
  <td height="21" align="center">{$RegInfNf.NumeroNF}</td>
  <td height="21" colspan="2" align="center">{if $RegInfNf.DataEmissaoNF != NULL}  {$RegInfNf.DataEmissaoNF|date_format:"%d/%m/%Y"} {else} {/if}</td>
{/foreach}

The syntax for the current key as specified in the Smarty manual looks like this:

$IdAutorizacao = GetApplication()->GetGETValue('pk1');
No answers

Browser other questions tagged

You are not signed in. Login or sign up in order to post.