Projet

Général

Profil

Paste
Statistiques
| Branche: | Révision:

ryxeo-glpi-git / plugins / manageentity / inc / plugin_manageentity.functions_display.php @ 92ce0ffe

Historique | Voir | Annoter | Télécharger (19,3 ko)

1 b67d8923 Eric Seigne
<?php
2
/*
3
   ----------------------------------------------------------------------
4
   GLPI - Gestionnaire Libre de Parc Informatique
5
   Copyright (C) 2003-2008 by the INDEPNET Development Team.
6

7
   http://indepnet.net/   http://glpi-manageentity.org/
8
   ----------------------------------------------------------------------
9

10
   LICENSE
11

12
   This file is part of GLPI.
13

14
   GLPI is free software; you can redistribute it and/or modify
15
   it under the terms of the GNU General Public License as published by
16
   the Free Software Foundation; either version 2 of the License, or
17
   (at your option) any later version.
18

19
   GLPI is distributed in the hope that it will be useful,
20
   but WITHOUT ANY WARRANTY; without even the implied warranty of
21
   MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
22
   GNU General Public License for more details.
23

24
   You should have received a copy of the GNU General Public License
25
   along with GLPI; if not, write to the Free Software
26
   Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA
27
   ------------------------------------------------------------------------
28
 */
29
30
// ----------------------------------------------------------------------
31
// Original Author of file: GRISARD Jean Marc & CAILLAUD Xavier
32
// Purpose of file:
33
// ----------------------------------------------------------------------
34
35
if (!defined('GLPI_ROOT')){
36
        die("Sorry. You can't access directly to this file");
37
        }
38
39
function plugin_manageentity_showcontractsassociated($instID) {
40
        GLOBAL $DB,$CFG_GLPI, $LANG, $LANGMANAGEENTITY;
41
42
        $query = "SELECT glpi_contracts.*, glpi_plugin_manageentity_contracts.ID as ID_us FROM glpi_plugin_manageentity_contracts, glpi_contracts WHERE glpi_plugin_manageentity_contracts.FK_contracts=glpi_contracts.ID AND glpi_plugin_manageentity_contracts.FK_entity = '$instID' ORDER BY glpi_contracts.name";
43
        $result = $DB->query($query);
44
        $number = $DB->numrows($result);
45
        
46
        if($number !="0"){
47
                echo "<form method='post' action=\"./index.php\">";
48
                echo "<div align='center'><table class='tab_cadre' align='center' width='95%'>";
49
                echo "<tr><th colspan='4'>".$LANGMANAGEENTITY["manageentity"][3]."</th></tr>";
50
                echo "<tr><th>".$LANG["common"][16]."</th>";
51
                echo "<th>".$LANG["financial"][4]."</th>";
52
                echo "<th>".$LANG["common"][25]."</th>";        
53
                if(plugin_manageentity_HaveRight("manageentity","w"))
54
                        echo "<th>&nbsp;</th>";
55
                echo "</tr>";
56
57
                while ($data=$DB->fetch_array($result)){
58
59
                        echo "<tr class='tab_bg_1".($data["deleted"]=='1'?"_2":"")."'>";
60
                        echo "<td><a href=\"".$CFG_GLPI["root_doc"]."/front/contract.form.php?ID=".$data["ID"]."\">".$data["name"]."";
61
                        if ($CFG_GLPI["view_ID"]||empty($data["name"])) echo " (".$data["ID"].")";
62
                        echo "</a></td>";
63
                        echo "<td align='center'>".$data["num"]."</td>";
64
                        echo "<td align='center'>".nl2br($data["comments"])."</td>";
65
                        if(plugin_manageentity_HaveRight("manageentity","w"))
66
                                echo "<td align='center' class='tab_bg_2'><a href=\"".$_SERVER["PHP_SELF"]."?deletecontracts=deletecontracts&amp;ID=".$data["ID_us"]."&amp;manageentity=$instID\">".$LANG["buttons"][6]."</a></td>";
67
                        else echo "";
68
                        echo "</tr>";
69
70
                }
71
                echo "</table></div>" ;
72
                echo"</form>";
73
        }
74
        else{
75
                echo "<form method='post' action=\"./index.php\">";
76
                echo "<div align='center'><table class='tab_cadre' align='center' width='95%'>";
77 1b365d67 Eric Seigne
                echo "<tr><th colspan='3'>".$LANGMANAGEENTITY["manageentity"][3]." - <a href=\"" . $CFG_GLPI["root_doc"] . "/front/contract.form.php\">[créer un contrat]</a> :</th></tr>";
78 b67d8923 Eric Seigne
                echo "<tr><th>".$LANG["common"][16]."</th>";
79
                echo "<th>".$LANG["financial"][4]."</th>";
80
                echo "<th>".$LANG["common"][25]."</th>";
81
82
                echo "</tr>";
83
                if(plugin_manageentity_HaveRight("manageentity","w")){
84
                        echo "<tr class='tab_bg_1'><td align='center'>";
85
                        echo "<input type='hidden' name='conID' value='$instID'>";
86
87
                        dropdown("glpi_contracts","entID",1,$instID);
88
                        echo "</td><td align='center'><input type='submit' name='addcontracts' value=\"".$LANG["buttons"][8]."\" class='submit'>";
89
                        echo "</td><td></td>";
90
                        echo "</tr>";
91
                }
92
                echo "</table></div></form>";
93
        }
94
}
95
96
function plugin_manageentity_showreports($instID) {
97
        GLOBAL $DB,$CFG_GLPI, $LANG, $LANGMANAGEENTITY;
98
                
99
        $plugin_ticketreport= new plugin_ticketreport();
100
        $plugin_ticketreport->GetFromDB(1);
101
        
102
        $query = "SELECT glpi_docs.* FROM glpi_docs WHERE glpi_docs.FK_entities='".$instID."' AND rubrique='".$plugin_ticketreport->fields["rubrique"]."' ORDER BY glpi_docs.date_mod DESC LIMIT 10";
103
        $result = $DB->query($query);
104
        $number = $DB->numrows($result);
105
                        
106
        if($number !="0"){
107
                echo "<br><form method='post' action=\"./index.php\">";
108
                echo "<div align='center'><table class='tab_cadre' align='center' width='95%'>";
109
                echo "<tr><th colspan='6'>".$LANGMANAGEENTITY["manageentity"][4]." <a href='".$CFG_GLPI["root_doc"]."/front/document.php?contains%5B0%5D=cri&amp;field%5B0%5D=7&amp;sort=19&amp;deleted=0&amp;start=0'>".$LANGMANAGEENTITY["manageentity"][9]."</a></th></tr>";
110
                echo "<tr><th>".$LANG["common"][16]."</th>";
111
                echo "<th width='100px'>".$LANG["document"][2]."</th>";
112
                echo "<th>".$LANG["common"][27]."</th>";
113
                echo "<th>".$LANGMANAGEENTITY["manageentity"][8]."</th>";
114
                
115
116
                echo "</tr>";
117
118
                while ($data=$DB->fetch_array($result)){
119
                        
120
                        echo "<tr class='tab_bg_1".($data["deleted"]=='1'?"_2":"")."'>";
121
                        echo "<td align='left'><a href='".$CFG_GLPI["root_doc"]."/front/document.form.php?ID=".$data["ID"]."'><b>".$data["name"];
122
                        if ($CFG_GLPI["view_ID"]) echo " (".$data["ID"].")";
123
                        echo "</b></a></td>";
124
125
                        echo "<td align='center'  width='100px'>".getDocumentLink($data["filename"])."</td>";
126
                        echo "<td align='center'>".convdate($data["date_mod"])."</td>";
127
                        $job=new job();
128
                        if($job->getFromDB($data["FK_tracking"])){
129
                                if($job->fields["assign"])
130
                                        echo "<td align='center'>".getUserName($job->fields["assign"])."</td>";
131
                                else echo "<td align='center'>".$LANG["mailing"][105]."</td>";
132
                                }else echo "<td align='center'></td>";
133
                        echo "</tr>";
134
135
                }
136
                echo "</table></div></form>";
137
        }
138
}
139
140
function plugin_manageentity_showJobVeryShort($ID) {
141
        // Prints a job in short form
142
        // Should be called in a <table>-segment
143
        // Print links or not in case of user view
144
145
        global $CFG_GLPI, $LANG;
146
147
        // Make new job object and fill it from database, if success, print it
148
        $job = new Job;
149
        $viewusers=haveRight("user","r");
150
        if ($job->getfromDBwithData($ID,0))
151
        {
152
                $bgcolor=$CFG_GLPI["priority_".$job->fields["priority"]];
153
                
154
                echo "<tr class='tab_bg_2'>";
155
                echo "<td align='center' bgcolor='$bgcolor' >ID: ".$job->fields["ID"]."</td>";
156
                
157
                echo "<td ><a href=\"".$CFG_GLPI["root_doc"]."/front/tracking.form.php?ID=".$job->fields["ID"]."\">".$job->fields["date"] . ": " . $job->fields["name"]."</a></td>";
158
                
159
                echo "<td align='center'>";
160
                if ($job->fields['assign']){
161
                        if ($viewusers){
162
                                        $userdata=getUserName($job->fields['assign'],2);
163
                
164
                                        $comments_display="";
165
                                        $comments_display="<a href='".$userdata["link"]."'>";
166
                                        $comments_display.="<img alt='' src='".$CFG_GLPI["root_doc"]."/pics/aide.png' onmouseout=\"cleanhide('comments_trackassign".$ID."')\" onmouseover=\"cleandisplay('comments_trackassign".$ID."')\">";
167
                                        $comments_display.="</a>";
168
                                        $comments_display.="<span class='over_link' id='comments_trackassign".$ID."'>".$userdata["comments"]."</span>";
169
                
170
                                        echo "<strong>".$userdata['name']."&nbsp;".$comments_display."</strong>";
171
                        } else {
172
                                echo "<strong>".$job->getAssignName()."</strong>";
173
                        }
174
                }else echo $LANG["mailing"][105];
175
176
                echo "</td>";
177
                echo "<td align='center'>".getStatusName($job->fields["status"])."</td>";
178
                
179
                echo "<td ><strong>".resume_text($job->fields["contents"],$CFG_GLPI["cut"]);
180
                echo "</strong>";
181
                echo "</td>";
182
        
183
                // Finish Line
184
                echo "</tr>";
185
        }
186
        else
187
        {
188
                echo "<tr class='tab_bg_2'><td colspan='6' ><i>".$LANG["joblist"][16]."</i></td></tr>";
189
        }
190
}
191
192
function plugin_manageentity_showtickets($instID) {
193
194
        global $DB,$CFG_GLPI, $LANG,$LANGMANAGEENTITY;
195
196
        if (!haveRight("show_all_ticket","1")&&!haveRight("show_assign_ticket","1")) return false;
197
198
        //ryxeo show all tickets
199
        $query = "SELECT ID FROM glpi_tracking WHERE glpi_tracking.FK_entities=".$instID." ORDER BY date DESC";
200
201
                $title=$LANG["central"][9];
202
203
        $result = $DB->query($query);
204
        $i = 0;
205
        $number = $DB->numrows($result);
206
207
        if ($number > 0) {
208
                echo "<br><div align='center'><table class='tab_cadre' align='center' width='95%'>";
209
210
                echo "<tr><th colspan='6'>".$LANGMANAGEENTITY["manageentity"][5]." -- <a href=\"../../front/helpdesk.php\">[ouvrir un nouveau ticket]</a></th></tr>";
211
                echo "<tr><th></th>";
212
                echo "<th>".$LANG["common"][57]."</th>";
213
                echo "<th width='75px'>".$LANG["job"][5]."</th>";
214
                echo "<th>".$LANG["joblist"][0]."</th>";
215
                echo "<th colspan='2'>".$LANG["joblist"][6]."</th></tr>";
216
                while ($i < $number) {
217
                        $ID = $DB->result($result, $i, "ID");
218
                        plugin_manageentity_showJobVeryShort($ID);
219
                        $i++;
220
                }
221
                echo "</table></div>";
222
        }
223
        else
224
        {
225
                echo "<br><div align='center'><table class='tab_cadre' align='center' width='95%'>";
226
                echo "<tr><th>".$LANGMANAGEENTITY["manageentity"][5]." -- <a href=\"../../front/helpdesk.php\">[ouvrir un nouveau ticket]</a></th></tr>";
227
                echo "</table></div>";
228
        }
229
}
230
231
function plugin_manageentity_showdocuments($instID) {
232
        GLOBAL $DB,$CFG_GLPI, $LANG, $LANGMANAGEENTITY;
233
234
        $query = "SELECT glpi_docs.*, glpi_plugin_manageentity_documents.ID as ID_us FROM glpi_plugin_manageentity_documents, glpi_docs WHERE glpi_plugin_manageentity_documents.FK_documents=glpi_docs.ID AND glpi_plugin_manageentity_documents.FK_entity = '$instID' ORDER BY glpi_docs.name";
235
        $result = $DB->query($query);
236
        $number = $DB->numrows($result);
237
        $i = 0;
238
        if($number !="0"){
239
                echo "<form method='post' action=\"./index.php\">";
240
                echo "<br><div align='center'><table class='tab_cadre' align='center' width='95%'>";
241
                echo "<tr><th colspan='6'>".$LANGMANAGEENTITY["manageentity"][6]."</th></tr>";
242
                echo "<tr><th>".$LANG["common"][16]."</th>";
243
                echo "<th width='100px'>".$LANG["document"][2]."</th>";
244
                echo "<th>".$LANG["document"][33]."</th>";
245
                echo "<th>".$LANG["document"][3]."</th>";
246
                echo "<th>".$LANG["document"][4]."</th>";
247
                if(plugin_manageentity_HaveRight("manageentity","w"))
248
                        echo "<th>&nbsp;</th>";
249
                echo "</tr>";
250
251
                while ($data=$DB->fetch_array($result)){
252
                        
253
                        echo "<tr class='tab_bg_1".($data["deleted"]=='1'?"_2":"")."'>";
254
                        echo "<td align='left'><a href='".$CFG_GLPI["root_doc"]."/front/document.form.php?ID=".$data["ID"]."'><b>".$data["name"];
255
                        if ($CFG_GLPI["view_ID"]) echo " (".$data["ID"].")";
256
                        echo "</b></a></td>";
257
258
                        echo "<td align='center' width='100px'>".getDocumentLink($data["filename"])."</td>";
259
260
                        echo "<td align='center'>";
261
                        if (!empty($data["link"]))
262
                                echo "<a target=_blank href='".$data["link"]."'>".$data["link"]."</a>";
263
                        else echo "&nbsp;";
264
                        echo "</td>";
265
                        echo "<td align='center'>".getDropdownName("glpi_dropdown_rubdocs",$data["rubrique"])."</td>";
266
                        echo "<td align='center'>".$data["mime"]."</td>";
267
                        if(plugin_manageentity_HaveRight("manageentity","w"))
268
                                echo "<td align='center' class='tab_bg_2'><a href='".$_SERVER["PHP_SELF"]."?deletedocuments=deletedocuments&amp;ID=".$data["ID_us"]."'><b>".$LANG["buttons"][6]."</b></a></td>";
269
                        echo "</tr>";
270
271
                }
272
                if(plugin_manageentity_HaveRight("manageentity","w")){
273
                        echo "<tr class='tab_bg_1'><td colspan='5' align='center'>";
274
                        echo "<input type='hidden' name='conID' value='$instID'>";
275
                        dropdownDocument("entID",$instID);
276
                        echo "</td><td align='center'><input type='submit' name='adddocuments' value=\"".$LANG["buttons"][8]."\" class='submit'></td>";
277
                        echo "</tr>";
278
                }
279
280
                echo "</table></div></form>";
281
        }
282
        else{
283
284
                echo "<form method='post' action=\"./index.php\">";
285
                echo "<br><div align='center'><table class='tab_cadre' align='center' width='95%'>";
286
                echo "<tr><th colspan='5'>".$LANGMANAGEENTITY["manageentity"][6]."</th></tr>";
287
                echo "<tr><th>".$LANG["common"][16]."</th>";
288
                echo "<th width='100px'>".$LANG["document"][2]."</th>";
289
                echo "<th>".$LANG["document"][33]."</th>";
290
                echo "<th>".$LANG["document"][3]."</th>";
291
                echo "<th>".$LANG["document"][4]."</th>";
292
                echo "</tr>";
293
                if(plugin_manageentity_HaveRight("manageentity","w")){
294
                        echo "<tr class='tab_bg_1'><td colspan='4' align='center'>";
295
                        echo "<input type='hidden' name='conID' value='$instID'>";
296
                        dropdownDocument("entID",$instID);
297
                        echo "</td><td align='center'><input type='submit' name='adddocuments' value=\"".$LANG["buttons"][8]."\" class='submit'></td>";
298
299
                        echo "</tr>";
300
301
                }
302
                echo "</table></div></form>";
303
        }
304
305
}
306
307
function plugin_manageentity_showcontacts($instID) {
308
        global $DB,$CFG_GLPI, $LANG,$LANGMANAGEENTITY;
309
310
311
        $query = "SELECT glpi_contacts.*, glpi_plugin_manageentity_contacts.ID as ID_ent FROM glpi_plugin_manageentity_contacts, glpi_contacts WHERE glpi_plugin_manageentity_contacts.FK_contacts=glpi_contacts.ID AND glpi_plugin_manageentity_contacts.FK_entity = '$instID' order by glpi_contacts.name";
312
313
        $result = $DB->query($query);
314
        $number = $DB->numrows($result);
315
        $i = 0;
316
        if ($number){
317
        echo "<form method='post' action=\"./index.php\">";
318
        echo "<br><div align='center'><table class='tab_cadre' align='center' width='95%'>";
319
        echo "<tr><th colspan='8'>".$LANGMANAGEENTITY["manageentity"][7]."</th></tr>";
320
        echo "<tr><th>".$LANG["common"][16]."</th><th>".$LANG["help"][35]."</th>";
321
        echo "<th>".$LANG["help"][35]." 2</th><th>".$LANG["common"][42]."</th><th>".$LANG["financial"][30]."</th>";
322
        echo "<th>".$LANG["setup"][14]."</th><th>".$LANG["common"][17]."</th>";
323
        echo "<th>&nbsp;</th></tr>";
324
325
        
326
                while ($data=$DB->fetch_array($result)) {
327
                        $ID=$data["ID_ent"];
328
                        echo "<tr class='tab_bg_1'>";
329
                        echo "<td align='left'><a href='".$CFG_GLPI["root_doc"]."/front/contact.form.php?ID=".$data["ID"]."'>".$data["name"]." ".$data["firstname"]."</a></td>";
330
                        echo "<td align='center'  width='100'>".$data["phone"]."</td>";
331
                        echo "<td align='center'  width='100'>".$data["phone2"]."</td>";
332
                        echo "<td align='center'  width='100'>".$data["mobile"]."</td>";
333
                        echo "<td align='center'  width='100'>".$data["fax"]."</td>";
334
                        echo "<td align='center'><a href='mailto:".$data["email"]."'>".$DB->result($result, $i, "glpi_contacts.email")."</a></td>";
335
                        echo "<td align='center'>".getDropdownName("glpi_dropdown_contact_type",$data["type"])."</td>";
336
                        echo "<td align='center' class='tab_bg_2'>";
337
                        if(plugin_manageentity_HaveRight("manageentity","w"))
338
                                echo "<a href='".$_SERVER['PHP_SELF']."?deletecontacts=deletecontacts&amp;ID=$ID&amp;eID=$instID'><strong>".$LANG["buttons"][6]."</strong></a>";
339
                        else echo "&nbsp;";
340
                        echo "</td></tr>";
341
                        $i++;
342
                }
343
                if(plugin_manageentity_HaveRight("manageentity","w")){
344
                        echo "<tr class='tab_bg_1'><td colspan='7' align='center'>";
345
                        echo "<input type='hidden' name='eID' value='$instID'>";
346
                        dropdown("glpi_contacts","cID");
347
                        echo "</td><td align='center'><input type='submit' name='addcontacts' value=\"".$LANG["buttons"][8]."\" class='submit'></td>";
348
                        echo "</tr>";
349
                }
350
        echo "</table></div></form>";
351
        }
352
        else{
353
        
354
                if(plugin_manageentity_HaveRight("manageentity","w")){
355
                        echo "<form method='post' action=\"./index.php\">";
356
                        echo "<br><table class='tab_cadre' align='center' width='95%'>";
357
        
358
                        echo "<tr class='tab_bg_1'><th colspan='2'>".$LANGMANAGEENTITY["manageentity"][7]."</tr><tr><td class='tab_bg_2' align='center'>";
359
                        echo "<input type='hidden' name='eID' value='$instID'>";
360
                        dropdown("glpi_contacts","cID");
361
                        echo "</td><td align='center' class='tab_bg_2'>";
362
                        echo "<input type='submit' name='addcontacts' value=\"".$LANG["buttons"][8]."\" class='submit'>";
363
                        echo "</td></tr>";
364
        
365
                        echo "</table></form>";
366
                }
367
        }
368
}
369
370
371
//ryxeo ... add show inventory
372
373
function plugin_manageentity_showinventory($instID) {
374
375
        global $DB,$CFG_GLPI, $LANG,$LANGMANAGEENTITY;
376
377
        if (!haveRight("computer","r")) return false;
378
379
        $query = "SELECT ID FROM glpi_computers WHERE glpi_computers.FK_entities=".$instID." ORDER BY name";
380
381
        $title=$LANG["central"][9];
382
383
        $result = $DB->query($query);
384
        $i = 0;
385
        $number = $DB->numrows($result);
386
387
        if ($number > 0) {
388
                echo "<br><div align='center'><table class='tab_cadre' align='center' width='95%'>";
389
390
                echo "<tr>";
391
                echo "<th colspan='5'>".$LANGMANAGEENTITY["manageentity"][12]."</th>";
392
                echo "</tr>";
393
                echo "<tr>";
394
                echo "<th>".$LANG["common"][16]."</th>";
395
                echo "<th width='75px'>".$LANG["common"][17]."</th>";
396
                echo "<th>".$LANG["common"][5]."</th>";
397
                echo "<th>".$LANG["common"][22]."</th>";
398
                echo "<th>".$LANG["common"][19]."</th>";
399
                echo "</tr>";
400
                while ($i < $number) {
401
                        $ID = $DB->result($result, $i, "ID");
402
                        plugin_manageentity_showInventoryVeryShort($ID);
403
                        $i++;
404
                }
405
                echo "</table></div>";
406
        }
407
        else
408
        {
409
                echo "<br><div align='center'><table class='tab_cadre' align='center' width='95%'>";
410
                echo "<tr><th>".$LANGMANAGEENTITY["manageentity"][5]." -- <a href=\"../../front/helpdesk.php\">[ouvrir un nouveau ticket]</a></th></tr>";
411
                echo "</table></div>";
412
        }
413
        echo "<br />";
414
}
415
416
417
function plugin_manageentity_showInventoryVeryShort($ID) {
418
        // Prints an inventory in short form
419
        // Should be called in a <table>-segment
420
        // Print links or not in case of user view
421
422
        global $CFG_GLPI, $LANG;
423
424
        // Make new job object and fill it from database, if success, print it
425
        $computer = new Computer;
426
427
        if ($computer->getfromDB($ID))
428
        {
429
                echo "<tr class='tab_bg_2'>";
430
                echo "<td ><a href=\"".$CFG_GLPI["root_doc"]."/front/computer.form.php?ID=".$computer->fields["ID"]."\">".$computer->fields["name"]."</a></td>";
431
                //                echo "<td>" . $computer->fields["model"] . "</td>";
432
                //                echo "<td>" . $computer->fields["type"] . "</td>";
433
                echo "<td>" . $computer->fields[""] . "</td>";
434
                echo "<td>" . $computer->fields[""] . "</td>";
435
                echo "<td>" . $computer->fields[""] . "</td>";
436
437
                //                echo "<td><pre>";
438
                //                print_r($computer);
439
                //                echo "</pre></td>";
440
                echo "<td>".$computer->fields["serial"]."</td>";
441
                // Finish Line
442
                echo "</tr>";
443
        }
444
        else
445
        {
446
                echo "<tr class='tab_bg_2'><td colspan='6' ><i>".$LANG["joblist"][16]."</i></td></tr>";
447
        }
448
}
449
450
//ryxeo
451
function plugin_manageentity_showanetepack($instID) {
452
453
        global $DB,$CFG_GLPI, $LANG,$LANGMANAGEENTITY;
454
455
        if (!haveRight("computer","r")) return false;
456
457 92ce0ffe Eric Seigne
        $query = "SELECT code,activation_date,FK_contract as contract,g.name as installateur FROM glpi_plugin_anet_epacks
458 b67d8923 Eric Seigne
LEFT JOIN glpi_entities AS g ON FK_activation=g.ID
459
WHERE FK_enduser=".$instID;
460
        //        print $query;
461
        $title=$LANG["central"][9];
462
463
        $result = $DB->query($query);
464
        $i = 0;
465
        $number = $DB->numrows($result);
466
467
        if ($number > 0) {
468 d9c543bd Eric Seigne
          echo "<br><div align='center'><table class='tab_cadre' align='center' width='95%'>";
469
          echo "<tr>";
470 92ce0ffe Eric Seigne
          echo "<th colspan='4'>Epack et Installation</th>";
471 d9c543bd Eric Seigne
          echo "</tr>";
472
          while($i < $number) {
473
            echo "<tr class='tab_bg_2'>";
474 92ce0ffe Eric Seigne
            echo "<td width=\"20%\">".$DB->result($result, $i, "code")."</td>";
475
            echo "<td width=\"20%\">Date d'activation: ".$DB->result($result, $i, "activation_date")."</td>";
476
            echo "<td width=\"20%\">Installateur: ".$DB->result($result, $i, "installateur")."</td>";
477
            if($DB->result($result, $i, "contract") < 0)
478
              echo "<td width=\"20%\"><a href=\"".$CFG_GLPI["root_doc"]."/plugins/anet_epacks/front/plugin_anet_epacks.out_of_maintenance.php?status=renewmaintenance&code=" . $DB->result($result, $i, "code") . "\" target=\"_blank\">[remarquer sous maintenance]</a> </td>";
479
            if($DB->result($result, $i, "contract") >= 0)
480
              echo "<td width=\"20%\"><a href=\"".$CFG_GLPI["root_doc"]."/plugins/anet_epacks/front/plugin_anet_epacks.out_of_maintenance.php?status=outofmaintenance&code=" . $DB->result($result, $i, "code") . "\" target=\"_blank\">[marquer hors maintenance]</a> </td>";
481 d9c543bd Eric Seigne
            echo "</tr>";
482
            $i++;
483
          }
484
          echo "</table></div>";
485 b67d8923 Eric Seigne
        }
486
        echo "<br />";
487
}
488
489
490
/**/
491
?>
Redmine Appliance - Powered by TurnKey Linux