[Phpcompta-dev] r609 - trunk/rapport_avance/include

[phpcompta-dev]

Author: danydb
Date: 2013-12-11 17:21:19 +0100 (Wed, 11 Dec 2013)
New Revision: 609

Modified:
   trunk/rapport_avance/include/class_rapav_declaration.php
Log:
save bug when computing the sql_date

Modified: trunk/rapport_avance/include/class_rapav_declaration.php
===================================================================
--- trunk/rapport_avance/include/class_rapav_declaration.php    2013-12-11 
13:26:51 UTC (rev 608)
+++ trunk/rapport_avance/include/class_rapav_declaration.php    2013-12-11 
16:21:19 UTC (rev 609)
@@ -247,6 +247,7 @@
             {
                 if (is_numeric($value['dr_amount']))
                 {
+                    /* -- works only with OOo Calc -- */
                     $searched = 'office:value-type="string"><text:p>' . 
$value['code'];
                     $replaced = 'office:value-type="float" office:value="' . 
$value['dr_amount'] . '"><text:p>' . $value['code'];
                     $buffer = str_replace($searched, $replaced, $buffer);
@@ -978,7 +979,7 @@
             $filter_ledger = " and jrn1.j_jrn_def = " . 
sql_string($this->form->jrn_def_id);
         }
         
-        $sql_date=RAPAV::get_sql_date($this->form->date_paid );
+        
 
         bcscale(2);
         switch ($this->form->type_sum_account)
@@ -986,6 +987,7 @@
             // Saldo
             case 1:
             case 2:
+                $sql_date=RAPAV::get_sql_date($this->form->date_paid,'jrn1' );
                 // Compute D-C
                 $sql = "
                         select sum(jrnx_amount)
@@ -1013,6 +1015,7 @@
                 break;
             // Only DEBIT
             case 3:
+                $sql_date=RAPAV::get_sql_date($this->form->date_paid,'jrn1' );
                 $sql = "
                         select sum(jrnx_amount)
                         from (
@@ -1038,6 +1041,7 @@
                 break;
             // Only CREDIT
             case 4:
+                $sql_date=RAPAV::get_sql_date($this->form->date_paid,'jrn1' );
                 $sql = "
                         select sum(jrnx_amount)
                         from (



---
PhpCompta est un logiciel de comptabilité libre en ligne (full web)
Projet opensource http://www.phpcompta.eu