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 [email protected] + +/** + * @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 _______________________________________________ Phpcompta est un logiciel libre de comptabilité en ligne (http://www.phpcompta.eu) Phpcompta-dev mailing list [email protected] https://lists.nongnu.org/mailman/listinfo/phpcompta-dev
