RyXéo » GLPI

<?php

// Génère le fichier ODT/PDF: courrier indiquant que la maintenance se termine cette année ...

include "../ryxeo.php";

if(!defined('GLPI_ROOT')){

  define('GLPI_ROOT', '../../..');

}

include_once (GLPI_ROOT . "/inc/includes.php");

include_once("tools.php");

checkRight("config","w");

//checkSeveralRightsOr(array("config" => "w", "profile" => "w"));

require_once('lib/odf.php');

//$odf->exportAsAttachedFile();

//$odf->printVars();

//print_r($odf);

//$odf->saveToDisk('tmp/fichier.odt');

global $DB;

//Si on demande a re-generer le fichier ODF on ne fait que ça

//a faire

if(isset($_GET['clientid'])) {

  $fk_entitee = $_GET['clientid'];

  //On a demandé a re-générer le contrat

  //print "re - creation du contrat ... ";

  //Le nom du contrat

  $clientid = $_GET['clientid'];

  $query = "SELECT name FROM glpi_contracts WHERE FK_entities='$clientid'";

  //print "<p>$query</p>";

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

  $data=$DB->fetch_array($result);

  if(trim($data[0]) == "") {

    $clientid=$_GET['cid'];

    $query = "SELECT name FROM glpi_contracts WHERE FK_entities='$clientid'";

    //print "<p>$query</p>";

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

    $data=$DB->fetch_array($result);

  }

  $cname=$data[0];

  //les epacks

  $query2 = "SELECT code FROM glpi_plugin_anet_epacks WHERE FK_contract='$clientid'";

  //print "<p>$query2</p>";

  $result2 = $DB->query($query2);

  $epackstxt = "";

  for($i = 0; $i < $DB->numrows($result2); $i++) {

    $data2      = $DB->fetch_array($result2);

    $epackstxt .= " " . $data2[0];

  }

  //le nom du partenaire

  $partenaire = "";

  if(trim($_GET['clientderyxeoid']) != "") {

    $query3="SELECT name as partenaire FROM glpi_entities WHERE ID= '" . $_GET['clientderyxeoid'] . "'";

    //print "<p>$query3</p>";

    $result3 = $DB->query($query3);

    $data3   = $DB->fetch_array($result3);

    $partenaire = $data3['partenaire'];

  }

  $odf = new odf("abuledu-courrier_fin_maintenance_cette_annee.odt");

  setlocale(LC_TIME, "fr_FR");

  error_reporting(E_ALL);

  $odf->setVars('date', strftime("%A %e %B %Y"), true, 'UTF-8');

  $query2="SELECT * FROM glpi_entities, glpi_entities_data WHERE glpi_entities.ID=FK_entities AND glpi_entities.ID='$fk_entitee';";

  //print "<p>$query2</p>";

  //$DB->query($query2) or die($DB->error());

  $result2 = $DB->query($query2);

  $data2=$DB->fetch_array($result2);

  $odf->setVars('client', $data2['name'], true, 'UTF-8');

  $odf->setVars('clientadresse', $data2['address'], true, 'UTF-8');

  $odf->setVars('clientcp', $data2['postcode']);

  $odf->setVars('clientville', $data2['town'], true, 'UTF-8');

  $odf->setVars('cname',  $cname, true, 'UTF-8');

  $odf->setVars('partenaire', $partenaire, true, 'UTF-8');

  $datefin = strftime("%A %e %B %Y",strtotime($_GET['datefin']));

  $odf->setVars('datefin',  $datefin, true, 'UTF-8');

  //On créé un fichier local pour archive ...

  $fichier = "courriers/" . date("Ymd") . "-abuledu-fin_de_maintenance-" . $cname . ".odt";

  //debug eric

  $odf->saveToDisk($fichier);

  pushfile($fichier);

  //On génère le fichier (autre methode)

  //$odf->exportAsAttachedFile();

  //print $texte;

 }

 else {

   print "<p>Désolé pour la mise en page et cette superbe page blanche ... mais il manque un parametre a l'appel de cette page !</p>\n";

 }

?>