RyXéo » GLPI

<?php

/*

 * @version $Id: xml.class.php 7763 2009-01-06 18:44:50Z moyo $

 -------------------------------------------------------------------------

 GLPI - Gestionnaire Libre de Parc Informatique

 Copyright (C) 2003-2009 by the INDEPNET Development Team.

 http://indepnet.net/   http://glpi-project.org

 -------------------------------------------------------------------------

 LICENSE

 This file is part of GLPI.

 GLPI 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.

 GLPI 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 GLPI; if not, write to the Free Software

 Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA

 --------------------------------------------------------------------------

 */

// ----------------------------------------------------------------------

// Based on the original file:

//* Author        : Roberto B.               *

//* E-Mail        : roberto.butti@libero.it  *

//* Version        : 1.0.3                    *

// Purpose of file:

// ----------------------------------------------------------------------

if (!defined('GLPI_ROOT')){

        die("Sorry. You can't access directly to this file");

        }

/// XML class

class XML {

        /// Array of SQL requests to export

        var $SqlString;

        /// 1 there is a problem !!!

        var $IsError;

        /// If there is an error, this string explains it

        var $ErrorString;

        /// Which format do you want your XML ?

        var $Type;

        ///path where the file will be saved.        

        var $FilePath;  

        // HERE I explain $Type

        /* For Example :

           1 (default) each value are in a tag called data

           <dataxml>

           <row>

           <data>value field1 row1</data>

           <data>value field2 row1</data>

           <data>value field3 row1</data>

           </row>

           <row>

           <data>value field1 row2</data>

           <data>value field2 row2</data>

           <data>value field3 row2</data>

           </row>

           </dataxml>

           2 each value is in a tag called dataN , where N is a position of field

           <dataxml>

           <row>

           <data1>value field1 row1</data1>

           <data2>value field2 row1</data2>

           <data3>value field3 row1</data3>

           </row>

           <row>

           <data1>value field1 row2</data1>

           <data2>value field2 row2</data2>

           <data3>value field3 row2</data3>

           </row>

           </dataxml>

           3 each value is in a tag called with the name of field

           <dataxml>

           <row>

           <fieldname1>value field1 row1</fieldname1>

           <fieldname2>value field2 row1</fieldname2>

           <fieldname3>value field3 row1</fieldname3>

           </row>

           <row>

           <fieldname1>value field1 row2</fieldname1>

           <fieldname2>value field2 row2</fieldname2>

           <fieldname3>value field3 row2</fieldname3>

           </row>

           </dataxml>

           4 each value is in a tag with an attributes called fieldname with the name of field

           <dataxml>

           <row>

           <data fieldname="fieldname1">value field1 row1</data>

           <data fieldname="fieldname2">value field1 row1</data>

           <data fieldname="fieldname3">value field1 row1</data>

           </row>

           <row>

           <data fieldname="fieldname1">value field1 row2</data>

           <data fieldname="fieldname2">value field1 row2</data>

           <data fieldname="fieldname3">value field1 row2</data>

           </row>

           </dataxml>

         */

        /**

         * Constructor

        **/

        function XML()

        {

                // Initialize the values with DEFAULT value

                $this->IsError=0;

                $this->Type=1;

                $this->ErrorString="NO errors ;)";

                $this->SqlString="";

        }

        /**

         * Do XML export

        **/

        function DoXML(){

                global $DB;

                $fp = fopen($this->FilePath,'wb');

                fputs($fp, "<?xml version=\"1.0\"?>\n");

                fputs($fp, "<dataxml>\n");

                foreach($this->SqlString as $strqry){

                        if ($strqry==""){

                                $this->IsError=1;

                                $this->ErrorString="Error the query can't be a null string";

                                return -1;

                        }

                        $result = $DB->query($strqry);

                        if ($result==FALSE){

                                $this->IsError=1;

                                $this->ErrorString="Error in SQL Query : ".$strqry;

                                return -1;

                        }

                        // OK... let's create XML ;)

                        fputs($fp, "        <fields>\n");

                        $i = 0;

                        $FieldsVector=array();

                        while ($i < $DB->num_fields ($result)){

                                $name = $DB->field_name($result,$i);

                                fputs($fp, "                <field>".$name."</field>\n");

                                $FieldsVector[]=$name;

                                $i++;

                        }

                        fputs($fp, "        </fields>\n");

                        // And NOW the Data ...

                        fputs($fp, "        <rows>\n");

                        while ($row = $DB->fetch_array ($result)){

                                fputs($fp, "                <row>\n");

                                for ($j=0; $j<$i; $j++){

                                        $FieldName="";                        // Name of TAG

                                        $Attributes="";

                                        switch ($this->Type){

                                                case 1:

                                                        $FieldName="data";

                                                        break;

                                                case 2:

                                                        $FieldName="data".$j;

                                                        break;

                                                case 3:

                                                        $FieldName=$FieldsVector[$j];

                                                        break;

                                                case 4:

                                                        $FieldName="data";

                                                        $Attributes=" fieldname=\"".$FieldsVector[$j]."\"";

                                        }

                                        fputs($fp, "                        <".$FieldName.$Attributes.">".utf8_encode(htmlspecialchars($row[$j]))."</".$FieldName.">\n");

                                }

                                fputs($fp, "                </row>\n");

                        }

                        fputs($fp, "        </rows>\n");

                        $DB->free_result($result);

                }

                fputs($fp, "</dataxml>");

                //OK free ...  ;)

                fclose($fp);

        } // End  Function : DoXML

} // Fine Class XML

?>