[Noalyss-commit] [noalyss] 27/218: Task #448 : delete unused currency

[Dany De Bontridder]

sparkyx pushed a commit to branch entreprise
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]);
         
     }