ryxeo-glpi-git / plugins / anet_epacks / front / plugin_anet_epacks.generate_odt_courrier_end_contract.form.php @ 97e94661
Historique | Voir | Annoter | Télécharger (3,27 ko)
1 |
<?php
|
---|---|
2 |
|
3 |
// Génère le fichier ODT/PDF: courrier indiquant que la maintenance se termine cette année ...
|
4 |
include "../ryxeo.php"; |
5 |
|
6 |
if(!defined('GLPI_ROOT')){ |
7 |
define('GLPI_ROOT', '../../..'); |
8 |
} |
9 |
include_once (GLPI_ROOT . "/inc/includes.php"); |
10 |
include_once("tools.php"); |
11 |
|
12 |
checkRight("config","w"); |
13 |
//checkSeveralRightsOr(array("config" => "w", "profile" => "w"));
|
14 |
|
15 |
require_once('lib/odf.php'); |
16 |
//$odf->exportAsAttachedFile();
|
17 |
//$odf->printVars();
|
18 |
//print_r($odf);
|
19 |
//$odf->saveToDisk('tmp/fichier.odt');
|
20 |
|
21 |
global $DB; |
22 |
|
23 |
//Si on demande a re-generer le fichier ODF on ne fait que ça
|
24 |
//a faire
|
25 |
if(isset($_GET['clientid'])) { |
26 |
$fk_entitee = $_GET['clientid']; |
27 |
//On a demandé a re-générer le contrat
|
28 |
//print "re - creation du contrat ... ";
|
29 |
|
30 |
//Le nom du contrat
|
31 |
$clientid = $_GET['clientid']; |
32 |
$query = "SELECT name FROM glpi_contracts WHERE FK_entities='$clientid'"; |
33 |
//print "<p>$query</p>";
|
34 |
$result = $DB->query($query); |
35 |
$data=$DB->fetch_array($result); |
36 |
if(trim($data[0]) == "") { |
37 |
$clientid=$_GET['cid']; |
38 |
$query = "SELECT name FROM glpi_contracts WHERE FK_entities='$clientid'"; |
39 |
//print "<p>$query</p>";
|
40 |
$result = $DB->query($query); |
41 |
$data=$DB->fetch_array($result); |
42 |
} |
43 |
$cname=$data[0]; |
44 |
|
45 |
//les epacks
|
46 |
$query2 = "SELECT code FROM glpi_plugin_anet_epacks WHERE FK_contract='$clientid'"; |
47 |
//print "<p>$query2</p>";
|
48 |
$result2 = $DB->query($query2); |
49 |
$epackstxt = ""; |
50 |
|
51 |
for($i = 0; $i < $DB->numrows($result2); $i++) { |
52 |
$data2 = $DB->fetch_array($result2); |
53 |
$epackstxt .= " " . $data2[0]; |
54 |
} |
55 |
|
56 |
//le nom du partenaire
|
57 |
$partenaire = ""; |
58 |
if(trim($_GET['clientderyxeoid']) != "") { |
59 |
$query3="SELECT name as partenaire FROM glpi_entities WHERE ID= '" . $_GET['clientderyxeoid'] . "'"; |
60 |
//print "<p>$query3</p>";
|
61 |
$result3 = $DB->query($query3); |
62 |
$data3 = $DB->fetch_array($result3); |
63 |
$partenaire = $data3['partenaire']; |
64 |
} |
65 |
|
66 |
$odf = new odf("abuledu-courrier_fin_maintenance_cette_annee.odt"); |
67 |
setlocale(LC_TIME, 'fr_FR.UTF8', 'fr.UTF8', 'fr_FR.UTF-8', 'fr.UTF-8'); |
68 |
error_reporting(E_ALL); |
69 |
|
70 |
$odf->setVars('date', strftime("%A %e %B %Y"), true, 'UTF-8'); |
71 |
|
72 |
$query2="SELECT * FROM glpi_entities, glpi_entities_data WHERE glpi_entities.ID=FK_entities AND glpi_entities.ID='$fk_entitee';"; |
73 |
//print "<p>$query2</p>";
|
74 |
//$DB->query($query2) or die($DB->error());
|
75 |
$result2 = $DB->query($query2); |
76 |
$data2=$DB->fetch_array($result2); |
77 |
|
78 |
|
79 |
$odf->setVars('client', $data2['name'], true, 'UTF-8'); |
80 |
$odf->setVars('clientadresse', $data2['address'], true, 'UTF-8'); |
81 |
$odf->setVars('clientcp', $data2['postcode']); |
82 |
$odf->setVars('clientville', $data2['town'], true, 'UTF-8'); |
83 |
|
84 |
$odf->setVars('cname', $cname, true, 'UTF-8'); |
85 |
$odf->setVars('partenaire', $partenaire, true, 'UTF-8'); |
86 |
|
87 |
$datefin = strftime("%A %e %B %Y",strtotime($_GET['datefin'])); |
88 |
$odf->setVars('datefin', $datefin, true, 'UTF-8'); |
89 |
|
90 |
//On créé un fichier local pour archive ...
|
91 |
$fichier = "courriers/" . date("Ymd") . "-abuledu-fin_de_maintenance-" . $cname . ".odt"; |
92 |
|
93 |
//debug eric
|
94 |
$odf->saveToDisk($fichier); |
95 |
pushfile($fichier);
|
96 |
|
97 |
|
98 |
//On génère le fichier (autre methode)
|
99 |
//$odf->exportAsAttachedFile();
|
100 |
//print $texte;
|
101 |
|
102 |
} |
103 |
else {
|
104 |
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"; |
105 |
} |
106 |
?>
|