From b8878d139e3b4dc66548053fa61c7f8c8997a2c9 Mon Sep 17 00:00:00 2001
From: www-data <www-data@n3150.home>
Date: Fri, 4 Aug 2023 14:26:19 +0200
Subject: [PATCH] Fix bug. When update transaction act_trans_date and
 voucher_date had wrong format. SQL request failed

---
 app/compta/api_booking.php            | 8 +++++---
 app/compta/controlers/transaction.php | 8 ++++++++
 app/member                            | 2 +-
 3 files changed, 14 insertions(+), 4 deletions(-)

diff --git a/app/compta/api_booking.php b/app/compta/api_booking.php
index 2474d47..f23635e 100644
--- a/app/compta/api_booking.php
+++ b/app/compta/api_booking.php
@@ -197,11 +197,13 @@ _EOF;
      */
     private function updateTransaction($transi,$entries)
     {
-      $trans_id = $transi['trans_id'];
+      $trans_id     = $transi['trans_id'];
+      $trans_date   = date("Y-m-d",strtotime($transi['act_trans_date']));
+      $voucher_date = date("Y-m-d",strtotime($transi['voucher_date']));
       $q =<<<_EOF
 UPDATE Transactions 
-SET voucher_date='{$transi['voucher_date']}'
-   ,act_trans_date='{$transi['act_trans_date']}'
+SET voucher_date='{$voucher_date}'
+   ,act_trans_date='{$trans_date}'
    ,trans_label= '{$transi['trans_label']}'
    ,voucher_ref= '{$transi['voucher_ref']}'
 WHERE  trans_id= {$transi['trans_id']} ;
diff --git a/app/compta/controlers/transaction.php b/app/compta/controlers/transaction.php
index 165ffb6..90c1bcb 100644
--- a/app/compta/controlers/transaction.php
+++ b/app/compta/controlers/transaction.php
@@ -64,6 +64,14 @@ class Transaction
         $page = new \compta\views\transaction\Update($this->_model);
         return $page;
     }
+    
+    public function updatePost($_id)
+    {
+        require_once(controler::$basedir."/views/transaction_update.php");
+        $this->_model->get($_id);
+        $page = new \compta\views\transaction\Update($this->_model);
+        return $page;
+    }
 }
 
 ?>
diff --git a/app/member b/app/member
index 73b7eb2..9709e08 160000
--- a/app/member
+++ b/app/member
@@ -1 +1 @@
-Subproject commit 73b7eb2f49045f87c9b6031661e00d98dc30a9ad
+Subproject commit 9709e08aed9b26ac88b255dc830878cb6e35d224
-- 
2.30.2