[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Noalyss-commit] [noalyss] 27/238: Task #448 : delete unused currency
From: |
Dany De Bontridder |
Subject: |
[Noalyss-commit] [noalyss] 27/238: Task #448 : delete unused currency |
Date: |
Sat, 26 Oct 2019 04:40:19 -0400 (EDT) |
sparkyx pushed a commit to annotated tag rel7110
in repository noalyss.
commit 694c9769c3c77addead9c4e7c3767068ce47ebbe
Author: Dany De Bontridder <address@hidden>
Date: 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] 13/238: indent, (continued)
- [Noalyss-commit] [noalyss] 13/238: indent, Dany De Bontridder, 2019/10/26
- [Noalyss-commit] [noalyss] 14/238: INum : add function onchange with inplace edit, Dany De Bontridder, 2019/10/26
- [Noalyss-commit] [noalyss] 15/238: insert_jrnx : add debug, Dany De Bontridder, 2019/10/26
- [Noalyss-commit] [noalyss] 04/238: Currency : add test file + database file + mtable, Dany De Bontridder, 2019/10/26
- [Noalyss-commit] [noalyss] 12/238: Action_Code : add validate, cancel and modify icon, Dany De Bontridder, 2019/10/26
- [Noalyss-commit] [noalyss] 22/238: Task #448 : identical operation with currency, Dany De Bontridder, 2019/10/26
- [Noalyss-commit] [noalyss] 24/238: Task #448 : rounded value for VEN, Dany De Bontridder, 2019/10/26
- [Noalyss-commit] [noalyss] 10/238: Currency : add SQL constraint + doc, Dany De Bontridder, 2019/10/26
- [Noalyss-commit] [noalyss] 17/238: Currency : fix rounded bugs in detail operation, Dany De Bontridder, 2019/10/26
- [Noalyss-commit] [noalyss] 19/238: Task #448 : currency : cosmetic operation detail, Dany De Bontridder, 2019/10/26
- [Noalyss-commit] [noalyss] 27/238: Task #448 : delete unused currency,
Dany De Bontridder <=
- [Noalyss-commit] [noalyss] 18/238: task #448 : Currency : display currency info into operation detail, Dany De Bontridder, 2019/10/26
- [Noalyss-commit] [noalyss] 20/238: Task #448 : check currency rate > 0 and payment in eur, Dany De Bontridder, 2019/10/26
- [Noalyss-commit] [noalyss] 21/238: Task #448 : issue with reconciliation amount, Dany De Bontridder, 2019/10/26
- [Noalyss-commit] [noalyss] 23/238: Display the balance difference, Dany De Bontridder, 2019/10/26
- [Noalyss-commit] [noalyss] 26/238: Task #448 : rounded problem add debug info, Dany De Bontridder, 2019/10/26
- [Noalyss-commit] [noalyss] 29/238: Task #448 : currency_id = 0 for the default currency + display currency rate in confirm operation, Dany De Bontridder, 2019/10/26
- [Noalyss-commit] [noalyss] 34/238: Task #448 : Currency : purchase, fix bug for autoreverse VAT, Dany De Bontridder, 2019/10/26
- [Noalyss-commit] [noalyss] 06/238: Currency : add ajax call to delete one rate , add documentation , remove debug info, Dany De Bontridder, 2019/10/26
- [Noalyss-commit] [noalyss] 31/238: task #448 : currency always used and remove parameter 'use_currency' from parameters, add SQL script, Dany De Bontridder, 2019/10/26
- [Noalyss-commit] [noalyss] 32/238: Task #448 : SQL integrated into upgrade128, Dany De Bontridder, 2019/10/26