[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Noalyss-commit] [noalyss] 27/162: Task #448 : delete unused currency
From: |
Dany De Bontridder |
Subject: |
[Noalyss-commit] [noalyss] 27/162: Task #448 : delete unused currency |
Date: |
Sat, 11 Jul 2020 13:23:25 -0400 (EDT) |
sparkyx pushed a commit to annotated tag E-4
in repository noalyss.
commit 694c9769c3c77addead9c4e7c3767068ce47ebbe
Author: Dany De Bontridder <danydb@noalyss.eu>
AuthorDate: Fri May 11 19:53:09 2018 +0200
Task #448 : delete unused currency
---
include/database/v_currency_last_value_sql.class.php | 12 ++++++++++++
1 file changed, 12 insertions(+)
diff --git a/include/database/v_currency_last_value_sql.class.php
b/include/database/v_currency_last_value_sql.class.php
index 7b6ecf8..1edbe57 100644
--- a/include/database/v_currency_last_value_sql.class.php
+++ b/include/database/v_currency_last_value_sql.class.php
@@ -82,6 +82,18 @@ class V_Currency_Last_Value_SQL extends Data_SQL
public function delete()
{
+ /* check if currency is used */
+ $is_used = $this->cn->get_value("select count(*) from jrn where
currency_id=$1",[$this->currency_id]);
+
+ /* if not used , we can delete it */
+ if ( $is_used <> 0 ) { throw new Exception (_("Devise utilisée"));
}
+
+ // We cannot delete EUR
+ if ( $this->currency_id == -1 ) {
+ throw new Exception(_("EUR ne peut pas être effacé"));
+ }
+ $this->cn->exec_sql("delete from currency_history where
currency_id=$1",[$this->currency_id]);
+ $this->cn->exec_sql("delete from currency where
id=$1",[$this->currency_id]);
}
- [Noalyss-commit] [noalyss] 15/162: insert_jrnx : add debug, (continued)
- [Noalyss-commit] [noalyss] 15/162: insert_jrnx : add debug, Dany De Bontridder, 2020/07/11
- [Noalyss-commit] [noalyss] 07/162: Currency : add menu for currency, Dany De Bontridder, 2020/07/11
- [Noalyss-commit] [noalyss] 13/162: indent, Dany De Bontridder, 2020/07/11
- [Noalyss-commit] [noalyss] 14/162: INum : add function onchange with inplace edit, Dany De Bontridder, 2020/07/11
- [Noalyss-commit] [noalyss] 16/162: Currency : insert operation with currency in VEN and ACH, Dany De Bontridder, 2020/07/11
- [Noalyss-commit] [noalyss] 17/162: Currency : fix rounded bugs in detail operation, Dany De Bontridder, 2020/07/11
- [Noalyss-commit] [noalyss] 18/162: task #448 : Currency : display currency info into operation detail, Dany De Bontridder, 2020/07/11
- [Noalyss-commit] [noalyss] 19/162: Task #448 : currency : cosmetic operation detail, Dany De Bontridder, 2020/07/11
- [Noalyss-commit] [noalyss] 23/162: Display the balance difference, Dany De Bontridder, 2020/07/11
- [Noalyss-commit] [noalyss] 25/162: Task #448 : payment method VEN, Dany De Bontridder, 2020/07/11
- [Noalyss-commit] [noalyss] 27/162: Task #448 : delete unused currency,
Dany De Bontridder <=
- [Noalyss-commit] [noalyss] 30/162: remove debug info, Dany De Bontridder, 2020/07/11
- [Noalyss-commit] [noalyss] 32/162: Task #448 : SQL integrated into upgrade128, Dany De Bontridder, 2020/07/11
- [Noalyss-commit] [noalyss] 09/162: Currency : add security for setting, Dany De Bontridder, 2020/07/11
- [Noalyss-commit] [noalyss] 11/162: Currency : SQL menu change, Dany De Bontridder, 2020/07/11
- [Noalyss-commit] [noalyss] 20/162: Task #448 : check currency rate > 0 and payment in eur, Dany De Bontridder, 2020/07/11
- [Noalyss-commit] [noalyss] 22/162: Task #448 : identical operation with currency, Dany De Bontridder, 2020/07/11
- [Noalyss-commit] [noalyss] 24/162: Task #448 : rounded value for VEN, Dany De Bontridder, 2020/07/11
- [Noalyss-commit] [noalyss] 26/162: Task #448 : rounded problem add debug info, Dany De Bontridder, 2020/07/11
- [Noalyss-commit] [noalyss] 28/162: Task #448 : currency , EUR cannot be changed and not display, Dany De Bontridder, 2020/07/11
- [Noalyss-commit] [noalyss] 29/162: Task #448 : currency_id = 0 for the default currency + display currency rate in confirm operation, Dany De Bontridder, 2020/07/11