RyXéo » GLPI

<?php

// Génère le fichier ODT/PDF pour le revendeur une fois le pack activé.

// Ce fichier contient le cahier de recettage à nous retourner.

// Ce fichier contient le contrat d'abonnement ?

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"));

//Si le fichier existe déjà on le passe

$fichier = "archives/" . $_GET['date'] . "-" . $_GET['code'] . $_GET['mode'] . ".activated.odt";

pushfile($fichier);

require_once('lib/odf.php');

$odf = new odf("abuledu-epack-activated" . $_GET['mode'] . ".odt");

//$odf->exportAsAttachedFile();

//$odf->printVars();

//print_r($odf);

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

global $DB;

$query="SELECT e.*,g2.name as g2name,g2.ID as g2id,g3.name as g3name, g4.name as g4name,

g2d.address as g2daddress, g2d.postcode as g2dpostcode, g2d.town as g2dtown, g2d.state as siret,

g3d.address as g3daddress, g3d.postcode as g3dpostcode, g3d.town as g3dtown,

g4d.address as g4daddress, g4d.postcode as g4dpostcode, g4d.town as g4dtown

FROM glpi_plugin_anet_epacks as e

LEFT JOIN glpi_entities AS g2 ON FK_activation=g2.ID

LEFT JOIN glpi_entities AS g3 ON FK_client=g3.ID

LEFT JOIN glpi_entities AS g4 ON FK_enduser=g4.ID

LEFT JOIN glpi_entities_data AS g2d ON FK_activation=g2d.FK_entities

LEFT JOIN glpi_entities_data AS g3d ON FK_client=g3d.FK_entities

LEFT JOIN glpi_entities_data AS g4d ON FK_enduser=g4d.FK_entities

WHERE e.code='" . $_GET['code'] . "';";

//print $query;

//exit;

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

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

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

$odf->setVars('code', $data['code']);

$odf->setVars('password', $data['password']);

setlocale(LC_TIME, "fr_FR");

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

//Les coordonnées du client de ryxeo

$odf->setVars('correspondant', $data['g2name'], true, 'UTF-8');

$odf->setVars('adresse', $data['g2daddress'], true, 'UTF-8');

$odf->setVars('cp', $data['g2dpostcode']);

$odf->setVars('ville', $data['g2dtown'], true, 'UTF-8');

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

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

$odf->setVars('clientcp', $data['g3dpostcode']);

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

$odf->setVars('clientfinal', $data['g4name'], true, 'UTF-8');

$odf->setVars('clientfinaladresse', $data['g4daddress'], true, 'UTF-8');

$odf->setVars('clientfinalcp', $data['g4dpostcode']);

$odf->setVars('clientfinalville', $data['g4dtown'], true, 'UTF-8');

if(preg_match("/avenant_contrat_partenaire/i",$_GET['mode'])) {

  $odf->setVars('cname', "ABE11-" . $data['code'], true, 'UTF-8');

  $query2 = "SELECT * FROM glpi_contracts WHERE FK_entities='" . $data['g2id'] . "' AND name LIKE '%-ENR20'";

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

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

  //print $query2;

  //print_r($data2);

  //exit;

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

  $odf->setVars('epack', $data['code'], true, 'UTF-8');

  setlocale(LC_TIME, "fr_FR");

  $timestamp = strtotime($_GET['date']);

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

  //Si le SIRET existe (detournement du champ state de glpi)

  if($data['siret']) {

    //print "on a le siret";

    //On peut chercher les coordonnées complètes du client ... dans dolibarr ?

    //a faire / décider 

  }

  $odf->setVars('correspondantadresse', $data['g2daddress'], true, 'UTF-8');

  $odf->setVars('correspondantcp', $data['g2dpostcode']);

  $odf->setVars('correspondantville', $data['g2dtown'], true, 'UTF-8');

  $odf->setVars('correspondanttype', "____________________", true, 'UTF-8');

  $odf->setVars('correspondantcapital', "____________________", true, 'UTF-8');

  $odf->setVars('correspondantrcs', "____________________", true, 'UTF-8');

  $odf->setVars('correspondantsiret', "____________________", true, 'UTF-8');

  $odf->setVars('correspondantcontact', "____________________", true, 'UTF-8');

 }

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

$odf->saveToDisk("archives/" . $_GET['date'] . "-" . $data['code'] . $_GET['mode'] . ".activated.odt");

pushfile($fichier);

//On génère le fichier

//$odf->exportAsAttachedFile();

?>