[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Phpcompta-dev] r4950 - phpcompta/trunk/include
From: |
phpcompta-dev |
Subject: |
[Phpcompta-dev] r4950 - phpcompta/trunk/include |
Date: |
Thu, 21 Jun 2012 00:00:22 +0200 (CEST) |
Author: danydb
Date: 2012-06-21 00:00:22 +0200 (Thu, 21 Jun 2012)
New Revision: 4950
Added:
phpcompta/trunk/include/export_stock_histo.php
Log:
Fix filename
Copied: phpcompta/trunk/include/export_stock_histo.php (from rev 4949,
phpcompta/trunk/include/export_stock_histo.csv)
===================================================================
--- phpcompta/trunk/include/export_stock_histo.php
(rev 0)
+++ phpcompta/trunk/include/export_stock_histo.php 2012-06-20 22:00:22 UTC
(rev 4950)
@@ -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
[Prev in Thread] |
Current Thread |
[Next in Thread] |
- [Phpcompta-dev] r4950 - phpcompta/trunk/include,
phpcompta-dev <=