[Phpcompta-dev] r4861 - phpcompta/trunk/include

[phpcompta-dev]

Author: danydb
Date: 2012-06-05 22:00:10 +0200 (Tue, 05 Jun 2012)
New Revision: 4861

Modified:
   phpcompta/trunk/include/class_database.php
Log:
Correct query_to_csv

Modified: phpcompta/trunk/include/class_database.php
===================================================================
--- phpcompta/trunk/include/class_database.php  2012-06-02 11:30:47 UTC (rev 
4860)
+++ phpcompta/trunk/include/class_database.php  2012-06-05 20:00:10 UTC (rev 
4861)
@@ -870,29 +870,27 @@
     function query_to_csv($ret,$aheader)
     {
         $seq="";
-        for ($i=0;$i<count($i);$i++)
+        for ($i=0;$i<count($aheader);$i++)
         {
-            echo '"'.$aheader[$i]['title'].'"';
+            echo $seq.'"'.$aheader[$i]['title'].'"';
             $seq=";";
         }
         printf("\n\r");
-
-        $seq="";
         // fetch all the rows
-        for ($i=0;$i<count(Database::num_row($ret));$i++)
+        for ($i=0;$i<Database::num_row($ret);$i++)
         {
             $row=Database::fetch_array($ret, $i);
             $sep2="";
             // for each rows, for each value
-            for ($e=0;$e<count($row);$e++)
+            for ($e=0;$e<count($row)/2;$e++)
             {
-                switch ($aheader[$e]['type'])
+               switch ($aheader[$e]['type'])
                 {
                     case 'num':
-                        echo nb($row[$e]).$sep2;
+                        echo $sep2.nb($row[$e]);
                         break;
                     default:
-                        echo '"'.$row[$e].'"'.$sep2;
+                        echo $sep2.'"'.$row[$e].'"';
                 }
                 $sep2=";";
             }



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