[Noalyss-commit] [noalyss] 98/218: Fin currency : detail operation show currency , rate and amount

[Dany De Bontridder]

sparkyx pushed a commit to branch entreprise
in repository noalyss.

commit ffa1b5af34388f7c2670f0d0a10a00016782796a
Author: Dany De Bontridder <address@hidden>
Date:   Tue Nov 27 18:11:18 2018 +0100

    Fin currency : detail operation show currency , rate and amount
---
 include/template/ledger_detail_fin.php | 13 +++++++++++++
 1 file changed, 13 insertions(+)

diff --git a/include/template/ledger_detail_fin.php 
b/include/template/ledger_detail_fin.php
index a34f4b6..80b3458 100644
--- a/include/template/ledger_detail_fin.php
+++ b/include/template/ledger_detail_fin.php
@@ -93,6 +93,19 @@ echo td(_('Pièce')).td($itext->input());
 </table>
 
 </td>
+<?php
+/**
+ * Display Currency in a column, if invoice not recorded in EUR
+ */
+if ($obj->det->currency_id!=0)
+{
+    $currency_amount=$obj->db->get_value("select  oc_amount from 
operation_currency where j_id in (select j_id from jrn join jrnx on 
(j_grpt=jr_grpt_id ) where jr_id=$1)", 
+            [$obj->jr_id]);
+    $currency_rate=$obj->db->get_value("select currency_rate from jrn where 
jr_id=$1",[$obj->jr_id]);
+    $currency_code=$obj->db->get_value("select cr_code_iso from currency where 
id=$1",[$obj->det->currency_id]);
+    printf ("%s Taux utilisé %s Montant en devise 
%s",$currency_code,$currency_rate,$currency_amount);
+}
+?>                    
 <div class="myfieldset">
 <?php 
   $detail=new Acc_Misc($cn,$obj->jr_id);