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

[phpcompta-dev]

Author: danydb
Date: 2012-06-21 00:00:39 +0200 (Thu, 21 Jun 2012)
New Revision: 4952

Added:
   phpcompta/trunk/include/export_stock_histo_csv.php
Log:
Fix filename 

Copied: phpcompta/trunk/include/export_stock_histo_csv.php (from rev 4950, 
phpcompta/trunk/include/export_stock_histo.php)
===================================================================
--- phpcompta/trunk/include/export_stock_histo_csv.php                          
(rev 0)
+++ phpcompta/trunk/include/export_stock_histo_csv.php  2012-06-20 22:00:39 UTC 
(rev 4952)
@@ -0,0 +1,63 @@
+<?php
+
+/*
+ *   This file is part of PhpCompta.
+ *
+ *   PhpCompta is free software; you can redistribute it and/or modify
+ *   it under the terms of the GNU General Public License as published by
+ *   the Free Software Foundation; either version 2 of the License, or
+ *   (at your option) any later version.
+ *
+ *   PhpCompta is distributed in the hope that it will be useful,
+ *   but WITHOUT ANY WARRANTY; without even the implied warranty of
+ *   MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
+ *   GNU General Public License for more details.
+ *
+ *   You should have received a copy of the GNU General Public License
+ *   along with PhpCompta; if not, write to the Free Software
+ *   Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA
+ */
+/* $Revision$ */
+
+// Copyright Author Dany De Bontridder address@hidden
+
+/**
+ * @file
+ * @brief export in CSV the export of history
+ *
+ */
+require_once 'class_stock.php';
+
+$stock=new Stock();
+$sql = $stock->create_query_histo($_GET);
+$sql .= " order by  real_date asc";
+
+$res=$cn->exec_sql($sql);
+$max_row=Database::num_row($res);
+header('Pragma: public');
+header('Content-type: application/csv');
+header('Content-Disposition: attachment;filename="histo-stock.csv"',FALSE);
+printf('"Date";');
+       printf('"%s";','Code Stock');
+       printf('"%s";','Depot');
+       printf('"%s";','Fiche');
+       printf('"%s";','Commentaire');
+       printf('%s;','Quantité');
+       printf('"%s";','IN/OUT');
+               printf("\n\r");
+for ($i=0;$i<$max_row;$i++)
+{
+       $row=Database::fetch_array($res,$i);
+       printf('"%s";',$row['cdate']);
+       printf('"%s";',$row['sg_code']);
+       printf('"%s";',$row['r_name']);
+       printf('"%s";',$row['qcode']);
+       $row['ccomment']=str_replace('"','',$row['ccomment']);
+       printf('"%s";',$row['ccomment']);
+       printf('%s;',nbm($row['sg_quantity']));
+       printf('"%s";',$row['direction']);
+       printf("\n\r");
+
+}
+
+?>
\ No newline at end of file



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