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 | b67d8923 | Eric Seigne | <?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 | ce399d47 | Eric Seigne | $fichier = "archives/" . str_replace("-","",$_GET['date']) . "-" . $_GET['code'] . $_GET['mode'] . ".activated.odt"; |
17 | b67d8923 | Eric Seigne | |
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 | 97e94661 | Eric Seigne | setlocale(LC_TIME, 'fr_FR.UTF8', 'fr.UTF8', 'fr_FR.UTF-8', 'fr.UTF-8'); |
52 | b67d8923 | Eric Seigne | $odf->setVars('date', strftime("%A %e %B %Y"),'true', 'UTF-8'); |
53 | |||
54 | //Les coordonnées du client de ryxeo
|
||
55 | 3e3ac5b4 | Eric Seigne | $odf->setVars('correspondant', $data['g2name'], true, 'UTF-8'); |
56 | $odf->setVars('adresse', $data['g2daddress'], true, 'UTF-8'); |
||
57 | b67d8923 | Eric Seigne | $odf->setVars('cp', $data['g2dpostcode']); |
58 | 3e3ac5b4 | Eric Seigne | $odf->setVars('ville', $data['g2dtown'], true, 'UTF-8'); |
59 | b67d8923 | Eric Seigne | |
60 | 3e3ac5b4 | Eric Seigne | $odf->setVars('client', $data['g3name'], true, 'UTF-8'); |
61 | $odf->setVars('clientadresse', $data['g3daddress'], true, 'UTF-8'); |
||
62 | b67d8923 | Eric Seigne | $odf->setVars('clientcp', $data['g3dpostcode']); |
63 | 3e3ac5b4 | Eric Seigne | $odf->setVars('clientville', $data['g3dtown'], true, 'UTF-8'); |
64 | b67d8923 | Eric Seigne | |
65 | 3e3ac5b4 | Eric Seigne | $odf->setVars('clientfinal', $data['g4name'], true, 'UTF-8'); |
66 | $odf->setVars('clientfinaladresse', $data['g4daddress'], true, 'UTF-8'); |
||
67 | b67d8923 | Eric Seigne | $odf->setVars('clientfinalcp', $data['g4dpostcode']); |
68 | 3e3ac5b4 | Eric Seigne | $odf->setVars('clientfinalville', $data['g4dtown'], true, 'UTF-8'); |
69 | b67d8923 | Eric Seigne | |
70 | if(preg_match("/avenant_contrat_partenaire/i",$_GET['mode'])) { |
||
71 | fa2eb127 | Eric Seigne | $odf->setVars('cname', "ABE11-" . $data['code'], true, 'UTF-8'); |
72 | b67d8923 | Eric Seigne | |
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 | 3e3ac5b4 | Eric Seigne | $odf->setVars('globalcname', $data2['name'], true, 'UTF-8'); |
81 | b67d8923 | Eric Seigne | |
82 | 3e3ac5b4 | Eric Seigne | $odf->setVars('epack', $data['code'], true, 'UTF-8'); |
83 | 97e94661 | Eric Seigne | setlocale(LC_TIME, 'fr_FR.UTF8', 'fr.UTF8', 'fr_FR.UTF-8', 'fr.UTF-8'); |
84 | b67d8923 | Eric Seigne | $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 | 3e3ac5b4 | Eric Seigne | $odf->setVars('correspondantadresse', $data['g2daddress'], true, 'UTF-8'); |
95 | b67d8923 | Eric Seigne | $odf->setVars('correspondantcp', $data['g2dpostcode']); |
96 | 3e3ac5b4 | Eric Seigne | $odf->setVars('correspondantville', $data['g2dtown'], true, 'UTF-8'); |
97 | b67d8923 | Eric Seigne | |
98 | 3e3ac5b4 | Eric Seigne | $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 | b67d8923 | Eric Seigne | |
104 | |||
105 | } |
||
106 | |||
107 | |||
108 | //On créé un fichier local pour archive ...
|
||
109 | ce399d47 | Eric Seigne | $odf->saveToDisk("archives/" . str_replace("-","",$_GET['date']) . "-" . $data['code'] . $_GET['mode'] . ".activated.odt"); |
110 | b67d8923 | Eric Seigne | |
111 | pushfile($fichier);
|
||
112 | |||
113 | //On génère le fichier
|
||
114 | //$odf->exportAsAttachedFile();
|
||
115 | ?> |