noalyss-commit
[Top][All Lists]
Advanced

[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]);
         
     }
 



reply via email to

[Prev in Thread] Current Thread [Next in Thread]