[Phpcompta-dev] r701 - trunk/transform/include

[phpcompta-dev]

Author: danydb
Date: 2014-02-08 14:42:41 +0100 (Sat, 08 Feb 2014)
New Revision: 701

Modified:
   trunk/transform/include/intervat_listing_assujetti_step_2.inc.php
Log:
Bug in compute


Modified: trunk/transform/include/intervat_listing_assujetti_step_2.inc.php
===================================================================
--- trunk/transform/include/intervat_listing_assujetti_step_2.inc.php   
2014-02-07 21:40:00 UTC (rev 700)
+++ trunk/transform/include/intervat_listing_assujetti_step_2.inc.php   
2014-02-08 13:42:41 UTC (rev 701)
@@ -158,7 +158,7 @@
 {
     $ltva = "(" . implode(',', $atva) . ")";
     //------ Operation date ----------------
-    if ($compute_date == 1)
+    if ($compute_date == 2)
     {
         $sql = "
       with  c as 
@@ -187,7 +187,7 @@
     join f_tvanum on (qs_client=f_tvanum.f_id);
 
     ";
-    } elseif ($compute_date == 2) //------ Payment date ----------------
+    } elseif ($compute_date == 1) //------ Payment date ----------------
     {
         $sql = "
         with  c as 
@@ -197,7 +197,7 @@
         from 
             quant_sold join jrnx on (jrnx.j_id=quant_sold.j_id) 
         where 
-        qs_vat_code $ltva
+        qs_vat_code in $ltva
         and j_grpt in (select jr_grpt_id 
                         from jrn 
                         where 



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