ryxeo-glpi-git / plugins / anet_epacks / front / plugin_anet_epacks.generate_odt_activated.form.php @ 97e94661
Historique | Voir | Annoter | Télécharger (4,37 ko)
1 |
<?php
|
---|---|
2 |
// Génère le fichier ODT/PDF pour le revendeur une fois le pack activé.
|
3 |
// Ce fichier contient le cahier de recettage à nous retourner.
|
4 |
// Ce fichier contient le contrat d'abonnement ?
|
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 |
//Si le fichier existe déjà on le passe
|
16 |
$fichier = "archives/" . str_replace("-","",$_GET['date']) . "-" . $_GET['code'] . $_GET['mode'] . ".activated.odt"; |
17 |
|
18 |
pushfile($fichier);
|
19 |
|
20 |
require_once('lib/odf.php'); |
21 |
|
22 |
$odf = new odf("abuledu-epack-activated" . $_GET['mode'] . ".odt"); |
23 |
//$odf->exportAsAttachedFile();
|
24 |
//$odf->printVars();
|
25 |
//print_r($odf);
|
26 |
//$odf->saveToDisk('tmp/fichier.odt');
|
27 |
|
28 |
global $DB; |
29 |
|
30 |
$query="SELECT e.*,g2.name as g2name,g2.ID as g2id,g3.name as g3name, g4.name as g4name, |
31 |
g2d.address as g2daddress, g2d.postcode as g2dpostcode, g2d.town as g2dtown, g2d.state as siret,
|
32 |
g3d.address as g3daddress, g3d.postcode as g3dpostcode, g3d.town as g3dtown,
|
33 |
g4d.address as g4daddress, g4d.postcode as g4dpostcode, g4d.town as g4dtown
|
34 |
FROM glpi_plugin_anet_epacks as e
|
35 |
LEFT JOIN glpi_entities AS g2 ON FK_activation=g2.ID
|
36 |
LEFT JOIN glpi_entities AS g3 ON FK_client=g3.ID
|
37 |
LEFT JOIN glpi_entities AS g4 ON FK_enduser=g4.ID
|
38 |
LEFT JOIN glpi_entities_data AS g2d ON FK_activation=g2d.FK_entities
|
39 |
LEFT JOIN glpi_entities_data AS g3d ON FK_client=g3d.FK_entities
|
40 |
LEFT JOIN glpi_entities_data AS g4d ON FK_enduser=g4d.FK_entities
|
41 |
WHERE e.code='" . $_GET['code'] . "';"; |
42 |
//print $query;
|
43 |
//exit;
|
44 |
//$DB->query($query) or die($DB->error());
|
45 |
$result = $DB->query($query); |
46 |
|
47 |
$data=$DB->fetch_array($result); |
48 |
$odf->setVars('code', $data['code']); |
49 |
$odf->setVars('password', $data['password']); |
50 |
|
51 |
setlocale(LC_TIME, 'fr_FR.UTF8', 'fr.UTF8', 'fr_FR.UTF-8', 'fr.UTF-8'); |
52 |
$odf->setVars('date', strftime("%A %e %B %Y"),'true', 'UTF-8'); |
53 |
|
54 |
//Les coordonnées du client de ryxeo
|
55 |
$odf->setVars('correspondant', $data['g2name'], true, 'UTF-8'); |
56 |
$odf->setVars('adresse', $data['g2daddress'], true, 'UTF-8'); |
57 |
$odf->setVars('cp', $data['g2dpostcode']); |
58 |
$odf->setVars('ville', $data['g2dtown'], true, 'UTF-8'); |
59 |
|
60 |
$odf->setVars('client', $data['g3name'], true, 'UTF-8'); |
61 |
$odf->setVars('clientadresse', $data['g3daddress'], true, 'UTF-8'); |
62 |
$odf->setVars('clientcp', $data['g3dpostcode']); |
63 |
$odf->setVars('clientville', $data['g3dtown'], true, 'UTF-8'); |
64 |
|
65 |
$odf->setVars('clientfinal', $data['g4name'], true, 'UTF-8'); |
66 |
$odf->setVars('clientfinaladresse', $data['g4daddress'], true, 'UTF-8'); |
67 |
$odf->setVars('clientfinalcp', $data['g4dpostcode']); |
68 |
$odf->setVars('clientfinalville', $data['g4dtown'], true, 'UTF-8'); |
69 |
|
70 |
if(preg_match("/avenant_contrat_partenaire/i",$_GET['mode'])) { |
71 |
$odf->setVars('cname', "ABE11-" . $data['code'], true, 'UTF-8'); |
72 |
|
73 |
$query2 = "SELECT * FROM glpi_contracts WHERE FK_entities='" . $data['g2id'] . "' AND name LIKE '%-ENR20'"; |
74 |
$result2 = $DB->query($query2); |
75 |
$data2=$DB->fetch_array($result2); |
76 |
//print $query2;
|
77 |
//print_r($data2);
|
78 |
//exit;
|
79 |
|
80 |
$odf->setVars('globalcname', $data2['name'], true, 'UTF-8'); |
81 |
|
82 |
$odf->setVars('epack', $data['code'], true, 'UTF-8'); |
83 |
setlocale(LC_TIME, 'fr_FR.UTF8', 'fr.UTF8', 'fr_FR.UTF-8', 'fr.UTF-8'); |
84 |
$timestamp = strtotime($_GET['date']); |
85 |
$odf->setVars('datedebut', strftime("%A %e %B %Y",$timestamp),'true', 'UTF-8'); |
86 |
|
87 |
//Si le SIRET existe (detournement du champ state de glpi)
|
88 |
if($data['siret']) { |
89 |
//print "on a le siret";
|
90 |
//On peut chercher les coordonnées complètes du client ... dans dolibarr ?
|
91 |
//a faire / décider
|
92 |
} |
93 |
|
94 |
$odf->setVars('correspondantadresse', $data['g2daddress'], true, 'UTF-8'); |
95 |
$odf->setVars('correspondantcp', $data['g2dpostcode']); |
96 |
$odf->setVars('correspondantville', $data['g2dtown'], true, 'UTF-8'); |
97 |
|
98 |
$odf->setVars('correspondanttype', "____________________", true, 'UTF-8'); |
99 |
$odf->setVars('correspondantcapital', "____________________", true, 'UTF-8'); |
100 |
$odf->setVars('correspondantrcs', "____________________", true, 'UTF-8'); |
101 |
$odf->setVars('correspondantsiret', "____________________", true, 'UTF-8'); |
102 |
$odf->setVars('correspondantcontact', "____________________", true, 'UTF-8'); |
103 |
|
104 |
|
105 |
} |
106 |
|
107 |
|
108 |
//On créé un fichier local pour archive ...
|
109 |
$odf->saveToDisk("archives/" . str_replace("-","",$_GET['date']) . "-" . $data['code'] . $_GET['mode'] . ".activated.odt"); |
110 |
|
111 |
pushfile($fichier);
|
112 |
|
113 |
//On génère le fichier
|
114 |
//$odf->exportAsAttachedFile();
|
115 |
?>
|