<?php 
Estou tentando fazer com que todos os itens da venda fiquem listados na fatura mas, não consigo, só salva na fatura o ultimo id (Produto) da lista.
Alguém aí pode me ajudar?????
abaixo segue o Metodo que estou a usar.
 public function onGenerate($param)
        {
            try{
        
            TTransaction::open('bd_venda');
            $conn = TTransaction::get();
            
            $colunas = $conn->query('SELECT v.ven_cod,p.pro_nome,p.pro_preco,iv.quantidade,v.ven_total,v.venda_data,
                                             iv.quantidade * p.pro_preco as Subtotal,v.cliente FROM venda v
                                             inner join itensvenda iv on v.ven_cod = iv.cod_venda
                                             inner join produto p on p.pro_cod = iv.cod_prod WHERE VEN_COD = "'.$_GET['itv_cod'].'"');   
            
              
                   
          
            $designer = new TPDFDesigner;
            $designer->fromXml('app/reports/FacturaVenda.pdf.xml');
            $designer->generate();          
                     
            $designer->gotoAnchorXY('factura');
            $designer->gotoAnchorXY('factura2');  
            $designer->gotoAnchorXY('data');
             $designer->gotoAnchorXY('data2');
            $designer->gotoAnchorXY('cliente');
             $designer->gotoAnchorXY('cliente2');
            $designer->gotoAnchorXY('produto');
               $designer->gotoAnchorXY('produto2');
            $designer->gotoAnchorXY('qtd');   
            $designer->gotoAnchorXY('qtd2');       
            $designer->gotoAnchorXY('preco');
            $designer->gotoAnchorXY('preco2');             
            $designer->gotoAnchorXY('subtotal'); 
              $designer->gotoAnchorXY('subtotal2');           
            $designer->gotoAnchorXY('total');
            $designer->gotoAnchorXY('total2');
            $designer->gotoAnchorXY('operador');    
            $designer->gotoAnchorXY('operador2');            
                                       
            
            foreach($colunas as $coluna);
            
            /*echo "<pre>";
                 print_r($coluna);        
                 print_r($_SESSION['template']['username']);
            echo "</pre>";*/
        
            $designer->writeAtAnchor('factura',$coluna[0]);
             $designer->writeAtAnchor('factura2',$coluna[0]);
            $designer->writeAtAnchor('data',$coluna[5]);
             $designer->writeAtAnchor('data2',$coluna[5]);
            //$designer->writeAtAnchor('dataReport',date('d-m-Y | H:i:s'));           
            $designer->writeAtAnchor('cliente',utf8_decode($coluna[7]));
            $designer->writeAtAnchor('cliente2',utf8_decode($coluna[7]));
            $designer->writeAtAnchor('produto',utf8_decode($coluna[1]));
            $designer->writeAtAnchor('produto2',utf8_decode($coluna[1]));
            $designer->writeAtAnchor('qtd',$coluna[3]);
            $designer->writeAtAnchor('qtd2',$coluna[3]);
            $designer->writeAtAnchor('preco',$coluna[2]);
             $designer->writeAtAnchor('preco2',$coluna[2]);
            $designer->writeAtAnchor('subtotal',$coluna[6]);
            $designer->writeAtAnchor('total',$coluna[4]);
            $designer->writeAtAnchor('operador', utf8_decode($_SESSION['template']['username']));
            $designer->writeAtAnchor('subtotal2',$coluna[6]);
            $designer->writeAtAnchor('total2',$coluna[4]);
            $designer->writeAtAnchor('operador2', utf8_decode($_SESSION['template']['username']));        
            
            $designer->save('app/output/FacturaVenda.pdf');
            parent::openFile('app/output/FacturaVenda.pdf');
       
            TTransaction::close();  
            
            new TMessage('info', _t('Document successfully generated'));
            //header('Location:index.php?class=SepultamentoList');
             
            } 
            catch (Exception $e) 
            {
                // shows the exception error message
                new TMessage('error', $e->getMessage());
    
                // undo all pending operations
                TTransaction::rollback();
            }    
 ?>