<?php 
//====================================================================================
// OCS INVENTORY REPORTS
// Copyleft Pierre LEMMET 2005
// Web: http://ocsinventory.sourceforge.net
//
// This code is open source and may be copied and modified as long as the source
// code is always made freely available.
// Please refer to the General Public Licence http://www.gnu.org/ or Licence.txt
//====================================================================================
//Modified on $Date: 2007/02/08 16:59:15 $$Author: plemmet $($Revision: 1.9 $)

require("req.class.php");
require_once("preferences.php");

if( isset($_SESSION["forcedRequest"] )) {
	$lareq = $_SESSION["forcedRequest"];
}
else
	$lareq = $_SESSION["storedRequest"]->getFullRequest();

$lareq = str_replace("h.id AS \"h.id\",","",$lareq);
$lareq = str_replace("deviceid AS \"deviceid\",","",$lareq);
$lareq = str_replace("h.n.ipmask","n.ipmask",$lareq);

//echo $lareq;die();
$result=mysql_query($lareq, $_SESSION["readServer"]) or die(mysql_error($_SESSION["readServer"]));

// iexplorer problem
if( ini_get("zlib.output-compression"))
	ini_set("zlib.output-compression","Off");
	
header("Pragma: public");
header("Expires: 0");
header("Cache-control: must-revalidate, post-check=0, pre-check=0");
header("Cache-control: private", false);
header("Content-type: application/force-download");
header("Content-Disposition: attachment; filename=\"export.csv\"");
header("Content-Transfer-Encoding: binary");

$colnb = 0;
$nameIndex = -1;
$toBeWritten = "";

while( $colname = mysql_fetch_field($result) ) {
	$cols[] = $colname->name;
	$nameIndex = ($colname->name == $l->g(24) ? $colnb : $nameIndex);
	$colnb++;	
}
writeTab($fp,$cols);

while( $cont = mysql_fetch_array($result,MYSQL_ASSOC) ) {
	writeTab($fp,$cont,$nameIndex);
}

header("Content-Length: ".strlen($toBeWritten));
echo $toBeWritten;

function writeTab ($fich,$tab,$rgn=-1) {	
	global $toBeWritten;
	$colnb = 0;
	foreach($tab as $t) {		
		$toBeWritten .= str_replace ( ",", ".", $t);
		$toBeWritten .= ",";
		$colnb++;
	}
	$toBeWritten .= "\r\n";
}
?>
