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');