[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Noalyss-commit] [noalyss] 94/162: Fin currency : detail operation show
From: |
Dany De Bontridder |
Subject: |
[Noalyss-commit] [noalyss] 94/162: Fin currency : detail operation show currency , rate and amount |
Date: |
Sat, 11 Jul 2020 13:23:49 -0400 (EDT) |
sparkyx pushed a commit to annotated tag E-4
in repository noalyss.
commit ffa1b5af34388f7c2670f0d0a10a00016782796a
Author: Dany De Bontridder <danydb@noalyss.eu>
AuthorDate: 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);
- [Noalyss-commit] [noalyss] 85/162: adapt to 7.2 ,array, (continued)
- [Noalyss-commit] [noalyss] 85/162: adapt to 7.2 ,array, Dany De Bontridder, 2020/07/11
- [Noalyss-commit] [noalyss] 86/162: Code cleaning : remove SQL with hardcoded value, Dany De Bontridder, 2020/07/11
- [Noalyss-commit] [noalyss] 88/162: Merge branch 'master' into r700-currency, Dany De Bontridder, 2020/07/11
- [Noalyss-commit] [noalyss] 87/162: PHP 7.2 : fix incomptability, Dany De Bontridder, 2020/07/11
- [Noalyss-commit] [noalyss] 89/162: translate, Dany De Bontridder, 2020/07/11
- [Noalyss-commit] [noalyss] 92/162: Merge branch 'master' into r700-currency, Dany De Bontridder, 2020/07/11
- [Noalyss-commit] [noalyss] 93/162: Fin : currency , add missing info into Operation_Currency, Dany De Bontridder, 2020/07/11
- [Noalyss-commit] [noalyss] 91/162: currency : adapt for FIN, Dany De Bontridder, 2020/07/11
- [Noalyss-commit] [noalyss] 96/162: Currency : financial use the rate depending of the operation date, Dany De Bontridder, 2020/07/11
- [Noalyss-commit] [noalyss] 90/162: acc_ledger_fin : cosmetic : input, Dany De Bontridder, 2020/07/11
- [Noalyss-commit] [noalyss] 94/162: Fin currency : detail operation show currency , rate and amount,
Dany De Bontridder <=
- [Noalyss-commit] [noalyss] 95/162: Modify quant_fin , we add a column j_id to have a fk to jrnx and operation_currency, Dany De Bontridder, 2020/07/11
- [Noalyss-commit] [noalyss] 97/162: Currency : SQL quant_fin is adapted, Dany De Bontridder, 2020/07/11
- [Noalyss-commit] [noalyss] 98/162: Version DB 131, Dany De Bontridder, 2020/07/11
- [Noalyss-commit] [noalyss] 99/162: reverse for quant_fin, Dany De Bontridder, 2020/07/11
- [Noalyss-commit] [noalyss] 100/162: Reverse for Currency, Dany De Bontridder, 2020/07/11
- [Noalyss-commit] [noalyss] 102/162: Currency : adapt for bank saldo, Dany De Bontridder, 2020/07/11
- [Noalyss-commit] [noalyss] 103/162: Currency : export PDF and CSV with currency for printing financial ledger listing(oneline), Dany De Bontridder, 2020/07/11
- [Noalyss-commit] [noalyss] 101/162: Background color, Dany De Bontridder, 2020/07/11
- [Noalyss-commit] [noalyss] 104/162: acc_ledger_fin . translation, Dany De Bontridder, 2020/07/11
- [Noalyss-commit] [noalyss] 106/162: Currency : All ledger's listing mode , html , csv and pdf, Dany De Bontridder, 2020/07/11