Logo Search packages:      
Sourcecode: ocsinventory-server version File versions  Download package

ipcsv.php

<?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: 2008-02-27 12:34:12 $$Author: hunal $($Revision: 1.13 $)

require("req.class.php");
require("fichierConf.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";
}
?>

Generated by  Doxygen 1.6.0   Back to index