[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Noalyss-commit] [noalyss] 27/31: Task #448 : delete unused currency
From: |
Dany De Bontridder |
Subject: |
[Noalyss-commit] [noalyss] 27/31: Task #448 : delete unused currency |
Date: |
Sat, 21 Jul 2018 07:47:11 -0400 (EDT) |
sparkyx pushed a commit to annotated tag r700-currency-001
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] 08/31: Currency = add a mode currency, possible to work without, (continued)
- [Noalyss-commit] [noalyss] 08/31: Currency = add a mode currency, possible to work without, Dany De Bontridder, 2018/07/21
- [Noalyss-commit] [noalyss] 03/31: Currency : create view + add currency name to table currency, Dany De Bontridder, 2018/07/21
- [Noalyss-commit] [noalyss] 05/31: html_page_start : protect query, improve code, Dany De Bontridder, 2018/07/21
- [Noalyss-commit] [noalyss] 09/31: Currency : add security for setting, Dany De Bontridder, 2018/07/21
- [Noalyss-commit] [noalyss] 17/31: Currency : fix rounded bugs in detail operation, Dany De Bontridder, 2018/07/21
- [Noalyss-commit] [noalyss] 10/31: Currency : add SQL constraint + doc, Dany De Bontridder, 2018/07/21
- [Noalyss-commit] [noalyss] 23/31: Display the balance difference, Dany De Bontridder, 2018/07/21
- [Noalyss-commit] [noalyss] 06/31: Currency : add ajax call to delete one rate , add documentation , remove debug info, Dany De Bontridder, 2018/07/21
- [Noalyss-commit] [noalyss] 24/31: Task #448 : rounded value for VEN, Dany De Bontridder, 2018/07/21
- [Noalyss-commit] [noalyss] 21/31: Task #448 : issue with reconciliation amount, Dany De Bontridder, 2018/07/21
- [Noalyss-commit] [noalyss] 27/31: Task #448 : delete unused currency,
Dany De Bontridder <=
- [Noalyss-commit] [noalyss] 14/31: INum : add function onchange with inplace edit, Dany De Bontridder, 2018/07/21
- [Noalyss-commit] [noalyss] 15/31: insert_jrnx : add debug, Dany De Bontridder, 2018/07/21
- [Noalyss-commit] [noalyss] 07/31: Currency : add menu for currency, Dany De Bontridder, 2018/07/21
- [Noalyss-commit] [noalyss] 19/31: Task #448 : currency : cosmetic operation detail, Dany De Bontridder, 2018/07/21
- [Noalyss-commit] [noalyss] 30/31: remove debug info, Dany De Bontridder, 2018/07/21
- [Noalyss-commit] [noalyss] 28/31: Task #448 : currency , EUR cannot be changed and not display, Dany De Bontridder, 2018/07/21
- [Noalyss-commit] [noalyss] 04/31: Currency : add test file + database file + mtable, Dany De Bontridder, 2018/07/21
- [Noalyss-commit] [noalyss] 29/31: Task #448 : currency_id = 0 for the default currency + display currency rate in confirm operation, Dany De Bontridder, 2018/07/21
- [Noalyss-commit] [noalyss] 26/31: Task #448 : rounded problem add debug info, Dany De Bontridder, 2018/07/21
- [Noalyss-commit] [noalyss] 31/31: task #448 : currency always used and remove parameter 'use_currency' from parameters, add SQL script, Dany De Bontridder, 2018/07/21