Projet

Général

Profil

Paste
Statistiques
| Branche: | Révision:

ryxeo-glpi-git / inc / stat.function.php @ b67d8923

Historique | Voir | Annoter | Télécharger (35,8 ko)

1
<?php
2
/*
3
 * @version $Id: stat.function.php 7881 2009-01-23 17:56:15Z moyo $
4
 -------------------------------------------------------------------------
5
 GLPI - Gestionnaire Libre de Parc Informatique
6
 Copyright (C) 2003-2009 by the INDEPNET Development Team.
7

8
 http://indepnet.net/   http://glpi-project.org
9
 -------------------------------------------------------------------------
10

11
 LICENSE
12

13
 This file is part of GLPI.
14

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

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

25
 You should have received a copy of the GNU General Public License
26
 along with GLPI; if not, write to the Free Software
27
 Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA
28
 --------------------------------------------------------------------------
29
 */
30

    
31
// ----------------------------------------------------------------------
32
// Original Author of file: 
33
// Purpose of file:
34
// ----------------------------------------------------------------------
35

    
36
if (!defined('GLPI_ROOT')){
37
        die("Sorry. You can't access directly to this file");
38
        }
39

    
40
/** Determine if a table is a dropdown one for stat
41
* @param $table string : table name
42
* @return boolean 
43
*/
44
function is_dropdown_stat($table) {
45
        $dropdowns = array ("locations","os","model");
46
        if(in_array(str_replace("glpi_dropdown_","",$table),$dropdowns)) return true;
47
        elseif(strcmp("glpi_type_computers",$table) == 0) return true;
48
        else return false; 
49
}
50

    
51

    
52
function getStatsItems($date1,$date2,$type){
53
        global $CFG_GLPI,$DB;
54
        $val=array();
55

    
56
        switch ($type){
57
                case "technicien":
58
                        $val = getNbIntervTech($date1,$date2);
59
                break;
60
                case "technicien_followup":
61
                        $val = getNbIntervTechFollowup($date1,$date2);
62
                break;
63
                case "enterprise":
64
                        $val = getNbIntervEnterprise($date1,$date2);
65

    
66
                break;
67
                case "user":
68
                        $val = getNbIntervAuthor($date1,$date2);
69
                break;
70
                case "recipient":
71
                        $val = getNbIntervRecipient($date1,$date2);
72
                break;
73
                case "category":
74
                        $val = getNbIntervCategory($date1,$date2);
75
                break;
76
                case "group":
77
                        $val = getNbIntervGroup($date1,$date2);
78
                break;
79
                case "assign_group":
80
                        $val = getNbIntervAssignGroup($date1,$date2);
81
                break;
82

    
83
                case "priority":
84
                        $val = getNbIntervPriority($date1,$date2);
85

    
86
                break;
87
                case "request_type":
88
                        $val = getNbIntervRequestType($date1,$date2);
89

    
90
                break;
91
                case "glpi_type_computers":
92
                case "glpi_dropdown_model":
93
                case "glpi_dropdown_os":
94
                case "glpi_dropdown_locations":
95
                        $val = getNbIntervDropdown($type);
96

    
97
                break;
98
                // DEVICE CASE
99
                default :
100
                $device_table = getDeviceTable($type);
101

    
102
                //select devices IDs (table row)
103
                $query = "select ID, designation from `".$device_table."` order by designation";
104
                $result = $DB->query($query);
105

    
106
                if($DB->numrows($result) >=1) {
107
                        $i = 0;
108
                        while($line = $DB->fetch_assoc($result)) {
109
                                $val[$i]['ID'] = $line['ID'];
110
                                $val[$i]['link'] = $line['designation'];
111
                                $i++;
112
                        }
113
                }
114

    
115
                break;
116
        }
117
        return $val;
118
}
119

    
120
function displayStats($type,$field,$date1,$date2,$start,$value,$value2=""){
121
        global $LANG,$CFG_GLPI;
122

    
123
        // Set display type for export if define
124
        $output_type=HTML_OUTPUT;
125
        if (isset($_GET["display_type"]))
126
                $output_type=$_GET["display_type"];
127

    
128
        if ($output_type==HTML_OUTPUT) // HTML display
129
                echo "<div align ='center'>";
130

    
131
        if (is_array($value)){
132

    
133

    
134
                $end_display=$start+$_SESSION["glpilist_limit"];
135
                $numrows=count($value);
136
                if (isset($_GET['export_all'])) {
137
                        $start=0;
138
                        $end_display=$numrows;
139
                }
140
                $nbcols=8;
141
                if ($output_type!=HTML_OUTPUT) // not HTML display
142
                        $nbcols--;
143
                echo displaySearchHeader($output_type,$end_display-$start+1,$nbcols);
144
                echo displaySearchNewLine($output_type);
145
                $header_num=1;
146
                echo displaySearchHeaderItem($output_type,"&nbsp;",$header_num);
147
                if ($output_type==HTML_OUTPUT){ // HTML display
148
                        echo displaySearchHeaderItem($output_type,"",$header_num);
149
                }
150
                echo displaySearchHeaderItem($output_type,$LANG["stats"][13],$header_num);
151
                echo displaySearchHeaderItem($output_type,$LANG["stats"][11],$header_num);
152
                echo displaySearchHeaderItem($output_type,$LANG["stats"][15],$header_num);
153
                echo displaySearchHeaderItem($output_type,$LANG["stats"][25],$header_num);
154
                echo displaySearchHeaderItem($output_type,$LANG["stats"][27],$header_num);
155
                echo displaySearchHeaderItem($output_type,$LANG["stats"][30],$header_num);
156
                // End Line for column headers                
157
                echo displaySearchEndLine($output_type);
158
                $row_num=1;
159
                for ($i=$start;$i< $numrows && $i<($end_display);$i++){
160
                        $row_num++;
161
                        $item_num=1;
162
                        echo displaySearchNewLine($output_type,$i%2);
163
                        echo displaySearchItem($output_type,$value[$i]['link'],$item_num,$row_num);
164
                        if ($output_type==HTML_OUTPUT){ // HTML display
165
                                
166
                                $link="";
167
                                if ($value[$i]['ID']>0){
168
                                        $link="<a href='stat.graph.php?ID=".$value[$i]['ID']."&amp;date1=$date1&amp;date2=$date2&amp;type=$type".(!empty($value2)?"&amp;champ=$value2":"")."'><img src=\"".$CFG_GLPI["root_doc"]."/pics/stats_item.png\" alt='' title=''></a>";
169
                                }
170
                                echo displaySearchItem($output_type,$link,$item_num,$row_num);
171
                        }
172

    
173
                        //le nombre d'intervention
174
                        //the number of intervention
175
                        $opened=constructEntryValues("inter_total",$date1,$date2,$type,$value[$i]["ID"],$value2);
176
                        $nb_opened=array_sum($opened);
177
                        echo displaySearchItem($output_type,$nb_opened,$item_num,$row_num);
178
                        //le nombre d'intervention resolues
179
                        //the number of resolved intervention
180
                        $solved=constructEntryValues("inter_solved",$date1,$date2,$type,$value[$i]["ID"],$value2);
181
                        $nb_solved=array_sum($solved);
182
                        echo displaySearchItem($output_type,$nb_solved,$item_num,$row_num);
183
                        //Le temps moyen de resolution
184
                        //The average time to resolv
185
                        $data=constructEntryValues("inter_avgsolvedtime",$date1,$date2,$type,$value[$i]["ID"],$value2);
186
                        foreach ($data as $key2 => $val2){
187
                                $data[$key2]*=$solved[$key2];
188
                        }
189
                        if ($nb_solved>0)
190
                                $nb=array_sum($data)/$nb_solved;
191
                        else $nb=0;
192

    
193
                        $timedisplay=$nb*HOUR_TIMESTAMP;
194
                        if ($output_type==HTML_OUTPUT || $output_type==PDF_OUTPUT_LANDSCAPE || $output_type==PDF_OUTPUT_PORTRAIT){
195
                                $timedisplay=timestampToString($timedisplay,0);
196
                        }
197
                        echo displaySearchItem($output_type,$timedisplay,$item_num,$row_num);
198
                        //Le temps moyen de l'intervention r�lle
199
                        //The average realtime to resolv
200
                        $data=constructEntryValues("inter_avgrealtime",$date1,$date2,$type,$value[$i]["ID"],$value2);
201
                        foreach ($data as $key2 => $val2){
202
                                $data[$key2]*=$solved[$key2];
203
                        }
204
                        $total_realtime=array_sum($data);
205
                        if ($nb_solved>0)
206
                                $nb=$total_realtime/$nb_solved;
207
                        else $nb=0;
208

    
209
                        $timedisplay=$nb*MINUTE_TIMESTAMP;
210
                        if ($output_type==HTML_OUTPUT || $output_type==PDF_OUTPUT_LANDSCAPE || $output_type==PDF_OUTPUT_PORTRAIT){
211
                                $timedisplay=timestampToString($timedisplay,0);
212
                        }
213
                        echo displaySearchItem($output_type,$timedisplay,$item_num,$row_num);
214
                        //Le temps total de l'intervention r�lle
215
                        //The total realtime to resolv
216
                        $timedisplay=$total_realtime*MINUTE_TIMESTAMP;
217
                        if ($output_type==HTML_OUTPUT || $output_type==PDF_OUTPUT_LANDSCAPE || $output_type==PDF_OUTPUT_PORTRAIT){
218
                                $timedisplay=timestampToString($timedisplay,0);
219
                        }
220
                        echo displaySearchItem($output_type,$timedisplay,$item_num,$row_num);                                
221
                        //Le temps moyen de prise en compte du ticket
222
                        //The average time to take a ticket into account
223
                        $data=constructEntryValues("inter_avgtakeaccount",$date1,$date2,$type,$value[$i]["ID"],$value2);
224

    
225
                        foreach ($data as $key2 => $val2){
226
                                $data[$key2]*=$solved[$key2];
227
                        }
228
                        if ($nb_solved>0)
229
                                $nb=array_sum($data)/$nb_solved;
230
                        else $nb=0;
231

    
232
                        $timedisplay=$nb*HOUR_TIMESTAMP;
233
                        if ($output_type==HTML_OUTPUT || $output_type==PDF_OUTPUT_LANDSCAPE || $output_type==PDF_OUTPUT_PORTRAIT){
234
                                $timedisplay=timestampToString($timedisplay,0);
235
                        }
236
                        echo displaySearchItem($output_type,$timedisplay,$item_num,$row_num);
237

    
238
                        echo displaySearchEndLine($output_type);
239
                }
240
                // Display footer
241
                echo displaySearchFooter($output_type);
242
        } else {
243
                echo $LANG["stats"][23];
244
        }
245
        if ($output_type==HTML_OUTPUT) // HTML display
246
                echo "</div>";
247
}
248

    
249

    
250
/** Get users which have intervention assigned to  between 2 dates
251
* @param $date1 date : begin date
252
* @param $date2 date : end date
253
* @return array contains the distinct users which have any intervention assigned to.
254
*/
255
function getNbIntervTech($date1,$date2){
256
        global $DB;
257
        $query = "SELECT distinct glpi_tracking.assign as assign, glpi_users.name as name, glpi_users.realname as realname, glpi_users.firstname as firstname";
258
        $query.= " FROM glpi_tracking ";
259
        $query.= " LEFT JOIN glpi_users  ON (glpi_users.ID=glpi_tracking.assign) ";
260

    
261
        $query.=getEntitiesRestrictRequest("WHERE","glpi_tracking");
262
        if ($date1!="") $query.= " AND glpi_tracking.date >= '". $date1 ."' ";
263
        if ($date2!="") $query.= " AND glpi_tracking.date <= adddate( '". $date2 ."' , INTERVAL 1 DAY ) ";
264
        $query.= " ORDER BY realname, firstname, name";
265
        $result = $DB->query($query);
266
        $tab=array();
267

    
268
        if($DB->numrows($result) >=1) {
269
                while($line = $DB->fetch_assoc($result)) {
270
                        $tmp['ID']= $line["assign"];
271
                        $tmp['link']=formatUserName($line["assign"],$line["name"],$line["realname"],$line["firstname"],1);
272
                        $tab[]=$tmp;
273
                }
274
        }
275
        return $tab;
276
}
277

    
278
/** Get users which have followup assigned to  between 2 dates
279
* @param $date1 date : begin date
280
* @param $date2 date : end date
281
* @return array contains the distinct users which have any followup assigned to.
282
*/
283
function getNbIntervTechFollowup($date1,$date2){
284
        global $DB;
285
        $query = "SELECT DISTINCT glpi_followups.author as author, glpi_users.name as name, glpi_users.realname as realname, glpi_users.firstname as firstname";
286
        $query.= " FROM glpi_tracking ";
287
        $query.= " LEFT JOIN glpi_followups ON (glpi_tracking.ID = glpi_followups.tracking) ";
288
        $query.= " LEFT JOIN glpi_users  ON (glpi_users.ID=glpi_followups.author) ";
289

    
290
        $query.=getEntitiesRestrictRequest("WHERE","glpi_tracking");
291
        if ($date1!="") $query.= " AND glpi_tracking.date >= '". $date1 ."' ";
292
        if ($date2!="") $query.= " AND glpi_tracking.date <= adddate( '". $date2 ."' , INTERVAL 1 DAY ) ";
293

    
294
        $query.=" AND glpi_followups.author <> 0 AND glpi_followups.author IS NOT NULL";
295
        $query.= " ORDER BY realname,firstname, name";
296
        $result = $DB->query($query);
297
        $tab=array();
298

    
299
        if($DB->numrows($result) >=1) {
300
                while($line = $DB->fetch_assoc($result)) {
301
                        $tmp['ID']= $line["author"];
302
                        $tmp['link']=formatUserName($line["author"],$line["name"],$line["realname"],$line["firstname"],1);
303
                        $tab[]=$tmp;
304
                }
305
        }
306
        return $tab;
307
}
308

    
309

    
310
/** Get enterprises which have followup assigned to between 2 dates
311
* @param $date1 date : begin date
312
* @param $date2 date : end date
313
* @return array contains the distinct enterprises which have any tickets assigned to.
314
*/
315
function getNbIntervEnterprise($date1,$date2){
316
        global $DB,$CFG_GLPI;
317
        $query = "SELECT distinct glpi_tracking.assign_ent as assign_ent, glpi_enterprises.name as name";
318
        $query.= " FROM glpi_tracking ";
319
        $query.= " LEFT JOIN glpi_enterprises  ON (glpi_enterprises.ID=glpi_tracking.assign_ent) ";
320

    
321
        $query.=getEntitiesRestrictRequest("WHERE","glpi_tracking");
322
        if ($date1!="") $query.= " AND glpi_tracking.date >= '". $date1 ."' ";
323
        if ($date2!="") $query.= " AND glpi_tracking.date <= adddate( '". $date2 ."' , INTERVAL 1 DAY ) ";
324

    
325
        $query.= " ORDER BY name";
326
        $tab=array();
327
        $result = $DB->query($query);
328
        if($DB->numrows($result) >0) {
329

    
330
                while($line = $DB->fetch_assoc($result)) {
331
                        $tmp["ID"]=$line["assign_ent"];
332
                        $tmp["link"]="<a href='".$CFG_GLPI["root_doc"]."/front/enterprise.form.php?ID=".$line["assign_ent"]."'>";
333
                        $tmp["link"].=$line["name"];
334
                        $tmp["link"].="</a>";
335
                        $tab[]=$tmp;
336
                }
337
                
338
        }
339
        return $tab;
340
}
341

    
342
/** Get dropdown values 
343
* @param $dropdown string : table name
344
* @return array contains the distinct dropdown values
345
*/
346
function getNbIntervDropdown($dropdown){
347
        global $DB,$CFG_GLPI;
348
        $field="name";
349

    
350
        if (in_array($dropdown,$CFG_GLPI["dropdowntree_tables"])) {
351
                $field="completename";
352
        }
353
        $where=" ";
354
        $order=" ORDER BY $field";
355
        if (in_array($dropdown,$CFG_GLPI["specif_entities_tables"])){
356
                $where=getEntitiesRestrictRequest(" WHERE",$dropdown);
357
                $order=" ORDER BY FK_entities, $field";        
358
        }
359

    
360
        $query = "SELECT * FROM `". $dropdown."` ".$where.$order;
361
        $tab=array();
362
        $result = $DB->query($query);
363
        if($DB->numrows($result) >0) {
364
                while($line = $DB->fetch_assoc($result)) {
365
                        $tmp['ID']= $line["ID"];
366
                        $tmp['link']=$line[$field];
367
                        $tab[]=$tmp;
368
                }
369
                
370
        }
371
        return $tab;
372

    
373
}
374

    
375
/** Get authors of tickets between 2 dates
376
* @param $date1 date : begin date
377
* @param $date2 date : end date
378
* @return array contains the distinct authors which have tickets
379
*/
380
function getNbIntervAuthor($date1,$date2){        
381
        global $DB;
382
        $query = "SELECT DISTINCT glpi_tracking.author as ID, glpi_users.name as name, glpi_users.realname as realname, glpi_users.firstname as firstname FROM glpi_tracking INNER JOIN glpi_users ON (glpi_users.ID=glpi_tracking.author)";
383
        $query.=getEntitiesRestrictRequest("WHERE","glpi_tracking");
384
        if ($date1!="") $query.= " AND glpi_tracking.date >= '". $date1 ."' ";
385
        if ($date2!="") $query.= " AND glpi_tracking.date <= adddate( '". $date2 ."' , INTERVAL 1 DAY ) ";
386

    
387
        $query.= " ORDER BY realname, firstname, name";
388
        $result = $DB->query($query);
389
        $tab=array();
390
        if($DB->numrows($result) >=1) {
391
                while($line = $DB->fetch_assoc($result)) {
392
                        $tmp['ID']= $line["ID"];
393
                        $tmp['link']=formatUserName($line["ID"],$line["name"],$line["realname"],$line["firstname"],1);
394
                        $tab[]=$tmp;
395
                }
396
        }
397
        return $tab;
398

    
399
}
400

    
401
/** Get recipient of tickets between 2 dates
402
* @param $date1 date : begin date
403
* @param $date2 date : end date
404
* @return array contains the distinct recipents which have tickets
405
*/
406
function getNbIntervRecipient($date1,$date2){        
407
        global $DB;
408
        $query = "SELECT DISTINCT glpi_tracking.recipient as ID, glpi_users.name as name, glpi_users.realname as realname, glpi_users.firstname as firstname FROM glpi_tracking LEFT JOIN glpi_users ON (glpi_users.ID=glpi_tracking.recipient)";
409
        $query.=getEntitiesRestrictRequest("WHERE","glpi_tracking");
410
        if ($date1!="") $query.= " AND glpi_tracking.date >= '". $date1 ."' ";
411
        if ($date2!="") $query.= " AND glpi_tracking.date <= adddate( '". $date2 ."' , INTERVAL 1 DAY ) ";
412

    
413
        $query.= " ORDER BY realname, firstname, name";
414
        $result = $DB->query($query);
415
        $tab=array();
416
        if($DB->numrows($result) >=1) {
417
                while($line = $DB->fetch_assoc($result)) {
418
                        $tmp['ID']= $line["ID"];
419
                        $tmp['link']=formatUserName($line["ID"],$line["name"],$line["realname"],$line["firstname"],1);
420
                        $tab[]=$tmp;
421
                }
422
        }
423
        return $tab;
424

    
425
}
426

    
427
/** Get priorities of tickets between 2 dates
428
* @param $date1 date : begin date
429
* @param $date2 date : end date
430
* @return array contains the distinct priorities of tickets
431
*/
432
function getNbIntervPriority($date1,$date2){        
433
        global $DB;
434

    
435
        $query = "SELECT DISTINCT priority 
436
                FROM glpi_tracking ".getEntitiesRestrictRequest("WHERE","glpi_tracking");
437
        if ($date1!="") $query.= " AND glpi_tracking.date >= '". $date1 ."' ";
438
        if ($date2!="") $query.= " AND glpi_tracking.date <= adddate( '". $date2 ."' , INTERVAL 1 DAY ) ";
439
        $query.=" ORDER BY priority";
440
        
441
        $result = $DB->query($query);
442
        $tab=array();
443
        if($DB->numrows($result) >=1) {
444
                $i = 0;
445
                while($line = $DB->fetch_assoc($result)) {
446
                        $tmp['ID']= $line["priority"];
447
                        $tmp['link']=getPriorityName($line["priority"]);
448
                        $tab[]=$tmp;
449
                }
450
        }
451
        return $tab;        
452

    
453
}
454

    
455
/** Get request types of tickets between 2 dates
456
* @param $date1 date : begin date
457
* @param $date2 date : end date
458
* @return array contains the distinct request types of tickets
459
*/
460
function getNbIntervRequestType($date1,$date2){        
461
        global $DB;
462
        $query = "SELECT DISTINCT request_type 
463
                FROM glpi_tracking ".getEntitiesRestrictRequest("WHERE","glpi_tracking");
464
        if ($date1!="") $query.= " AND glpi_tracking.date >= '". $date1 ."' ";
465
        if ($date2!="") $query.= " AND glpi_tracking.date <= adddate( '". $date2 ."' , INTERVAL 1 DAY ) ";
466
        $query.=" ORDER BY request_type";
467
        $result = $DB->query($query);
468
        $tab=array();
469
        if($DB->numrows($result) >=1) {
470
                while($line = $DB->fetch_assoc($result)) {
471
                        $tmp['ID']= $line["request_type"];
472
                        $tmp['link']=getRequestTypeName($line["request_type"]);
473
                        $tab[]=$tmp;
474
                }
475
        }
476

    
477
        return $tab;
478
}
479

    
480
/** Get categories of tickets between 2 dates
481
* @param $date1 date : begin date
482
* @param $date2 date : end date
483
* @return array contains the distinct categories of tickets
484
*/
485
function getNbIntervCategory($date1,$date2){        
486
        global $DB;
487
        
488
        $query = "SELECT DISTINCT glpi_dropdown_tracking_category.ID,   glpi_dropdown_tracking_category.completename AS category
489
                FROM glpi_tracking 
490
                LEFT JOIN glpi_dropdown_tracking_category ON (glpi_tracking.category = glpi_dropdown_tracking_category.ID) ";
491
        $query.=getEntitiesRestrictRequest(" WHERE","glpi_tracking");
492
        if ($date1!="") $query.= " AND glpi_tracking.date >= '". $date1 ."' ";
493
        if ($date2!="") $query.= " AND glpi_tracking.date <= adddate( '". $date2 ."' , INTERVAL 1 DAY ) ";
494
                
495
        $query.=" ORDER BY glpi_dropdown_tracking_category.completename";
496

    
497
        $result = $DB->query($query);
498
        $tab=array();
499
        if($DB->numrows($result) >=1) {
500
                while($line = $DB->fetch_assoc($result)) {
501
                        $tmp['ID']= $line["ID"];
502
                        $tmp['link']=$line["category"];
503
                        $tab[]=$tmp;
504
                }
505
        }
506
        return $tab;
507
}
508

    
509

    
510
/** Get groups which have tickets between 2 dates
511
* @param $date1 date : begin date
512
* @param $date2 date : end date
513
* @return array contains the distinct groups of tickets
514
*/
515
function getNbIntervGroup($date1,$date2){        
516
        global $DB;
517
        $query = "SELECT DISTINCT glpi_groups.id AS ID,glpi_groups.name FROM glpi_tracking 
518
                LEFT JOIN  glpi_groups ON (glpi_tracking.FK_group = glpi_groups.ID)";
519
        $query.=getEntitiesRestrictRequest(" WHERE","glpi_tracking");
520
        if ($date1!="") $query.= " AND glpi_tracking.date >= '". $date1 ."' ";
521
        if ($date2!="") $query.= " AND glpi_tracking.date <= adddate( '". $date2 ."' , INTERVAL 1 DAY ) ";
522
        $query.=" ORDER BY glpi_groups.name";
523
        
524
        $result = $DB->query($query);
525
        $tab=array();
526

    
527
        if($DB->numrows($result) >=1) {
528
                while($line = $DB->fetch_assoc($result)) {
529
                        $tmp['ID']= $line["ID"];
530
                        $tmp['link']=$line["name"];
531
                        
532
                        $tab[]=$tmp;
533
                }
534
        }
535
        return $tab;
536
}
537

    
538

    
539
/** Get groups assigned to tickets between 2 dates
540
* @param $date1 date : begin date
541
* @param $date2 date : end date
542
* @return array contains the distinct groups assigned to a tickets
543
*/
544
function getNbIntervAssignGroup($date1,$date2){        
545
        global $DB;
546
        $query = "SELECT DISTINCT glpi_groups.id AS ID,glpi_groups.name FROM glpi_tracking 
547
                LEFT JOIN  glpi_groups ON (glpi_tracking.assign_group = glpi_groups.ID)";
548
        $query.=getEntitiesRestrictRequest(" WHERE","glpi_tracking");
549
        if ($date1!="") $query.= " AND glpi_tracking.date >= '". $date1 ."' ";
550
        if ($date2!="") $query.= " AND glpi_tracking.date <= adddate( '". $date2 ."' , INTERVAL 1 DAY ) ";
551
        $query.=" ORDER BY glpi_groups.name";
552
        
553
        $result = $DB->query($query);
554
        $tab=array();
555

    
556
        if($DB->numrows($result) >=1) {
557
                while($line = $DB->fetch_assoc($result)) {
558
                        $tmp['ID']= $line["ID"];
559
                        $tmp['link']=$line["name"];
560
                        
561
                        $tab[]=$tmp;
562
                }
563
        }
564
        return $tab;
565
}
566

    
567
function constructEntryValues($type,$begin="",$end="",$param="",$value="",$value2=""){
568
        global $DB;
569

    
570
        if (empty($end)) $end=date("Y-m-d");
571
        $end.=" 23:59:59";
572
        // 1 an par defaut
573
        if (empty($begin)) $begin=date("Y-m-d",mktime(0,0,0,date("m"),date("d"),date("Y")-1));
574
        $begin.=" 00:00:00";
575

    
576
        $query="";
577

    
578
        $WHERE=getEntitiesRestrictRequest("WHERE","glpi_tracking");
579
        if (empty($WHERE)){
580
                $WHERE=" WHERE 1 ";
581
        }
582
        $LEFTJOIN="";
583
        switch ($param){
584

    
585
                case "technicien":
586
                        $WHERE.=" AND glpi_tracking.assign='$value'";
587
                break;
588
                case "technicien_followup":
589
                        $WHERE.=" AND glpi_followups.author='$value'";
590
                        $LEFTJOIN= "LEFT JOIN glpi_followups ON (glpi_followups.tracking = glpi_tracking.ID)";
591
                break;        
592
                case "enterprise":
593
                        $WHERE.=" AND glpi_tracking.assign_ent='$value'";
594
                break;
595
                case "user":
596
                        $WHERE.=" AND glpi_tracking.author='$value'";
597
                break;
598
                case "recipient":
599
                        $WHERE.=" AND glpi_tracking.recipient='$value'";
600
                break;
601
                case "category":
602
                        if (!empty($value)){
603
                                $categories=getSonsOfTreeItem("glpi_dropdown_tracking_category",$value);
604
                                $condition="";
605
                                $first=true;
606
                                foreach ($categories as $ID){
607
                                        if ($first){
608
                                                $first=false;
609
                                        } else {
610
                                                $condition.=",";
611
                                        }
612
                                        $condition.=$ID;
613
                                }
614
        
615
                                $WHERE.=" AND glpi_tracking.category IN ($condition)";
616
                        } else {
617
                                $WHERE.=" AND glpi_tracking.category = '$value' ";
618
                        }
619
                break;
620
                case "group":
621
                        $WHERE.=" AND glpi_tracking.FK_group='$value'";
622
                break;
623
                case "assign_group":
624
                        $WHERE.=" AND glpi_tracking.assign_group='$value'";
625
                break;
626
                case "priority":
627
                        $WHERE.=" AND glpi_tracking.priority='$value'";
628
                break;
629
                case "request_type":
630
                        $WHERE.=" AND glpi_tracking.request_type='$value'";
631
                break;
632

    
633
                case "device":
634
                        //select computers IDs that are using this device;
635

    
636
                        $LEFTJOIN= "INNER JOIN glpi_computers ON (glpi_computers.ID = glpi_tracking.computer AND glpi_tracking.device_type='".COMPUTER_TYPE."') INNER JOIN glpi_computer_device ON ( glpi_computers.ID = glpi_computer_device.FK_computers AND glpi_computer_device.device_type = '".$value2."' AND glpi_computer_device.FK_device = '".$value."' )";
637

    
638
                        $WHERE.=" AND glpi_computers.is_template <> '1' ";
639

    
640
                break;
641
                case "comp_champ":
642
                        $LEFTJOIN= "INNER JOIN glpi_computers ON (glpi_computers.ID = glpi_tracking.computer AND glpi_tracking.device_type='".COMPUTER_TYPE."')";
643

    
644
                        $WHERE.=" AND `glpi_computers`.`$value2`='$value' AND glpi_computers.is_template <> '1'";
645
                break;
646
        }
647
        switch($type)        {
648

    
649
                case "inter_total": 
650
                        if (!empty($begin)) $WHERE.= " AND glpi_tracking.date >= '$begin' ";
651
                        if (!empty($end)) $WHERE.= " AND glpi_tracking.date <= '$end' ";
652

    
653
                        $query="SELECT FROM_UNIXTIME(UNIX_TIMESTAMP(glpi_tracking.date),'%Y-%m') AS date_unix, COUNT(glpi_tracking.ID) AS total_visites  FROM glpi_tracking ".$LEFTJOIN.$WHERE.
654
                        " GROUP BY date_unix ORDER BY glpi_tracking.date";
655
                break;
656
                case "inter_solved": 
657
                        $WHERE.=" AND ( glpi_tracking.status = 'old_done' OR glpi_tracking.status = 'old_notdone') AND glpi_tracking.closedate <> '0000-00-00 00:00:00' ";
658
                        if (!empty($begin)) $WHERE.= " AND glpi_tracking.closedate >= '$begin' ";
659
                        if (!empty($end)) $WHERE.= " AND glpi_tracking.closedate <= '$end' ";
660

    
661
                        $query="SELECT FROM_UNIXTIME(UNIX_TIMESTAMP(glpi_tracking.closedate),'%Y-%m') AS date_unix, COUNT(glpi_tracking.ID) AS total_visites  FROM glpi_tracking ".$LEFTJOIN.$WHERE.
662
                        " GROUP BY date_unix ORDER BY glpi_tracking.closedate";
663
                break;
664
                case "inter_avgsolvedtime" :
665
                        $WHERE.=" AND ( glpi_tracking.status = 'old_done' OR glpi_tracking.status = 'old_notdone') AND glpi_tracking.closedate <> '0000-00-00 00:00:00' ";
666
                if (!empty($begin)) $WHERE.= " AND glpi_tracking.closedate >= '$begin' ";
667
                if (!empty($end)) $WHERE.= " AND glpi_tracking.closedate <= '$end' ";
668

    
669
                $query="SELECT FROM_UNIXTIME(UNIX_TIMESTAMP(glpi_tracking.closedate),'%Y-%m') AS date_unix, 
670
                        AVG(TIME_TO_SEC( TIMEDIFF(glpi_tracking.closedate,glpi_tracking.date))/".HOUR_TIMESTAMP.") AS total_visites  FROM glpi_tracking ".
671
                        $LEFTJOIN.$WHERE.
672
                        " GROUP BY date_unix ORDER BY glpi_tracking.closedate";
673
                break;
674
                case "inter_avgrealtime" :
675
                        if ($param=="technicien_followup")
676
                                $realtime_table="glpi_followups";
677
                        else $realtime_table="glpi_tracking";
678
                        $WHERE.=" AND $realtime_table.realtime > '0' ";
679
                        if (!empty($begin)) $WHERE.= " AND glpi_tracking.closedate >= '$begin' ";
680
                        if (!empty($end)) $WHERE.= " AND glpi_tracking.closedate <= '$end' ";
681

    
682
                        $query="SELECT FROM_UNIXTIME(UNIX_TIMESTAMP(glpi_tracking.closedate),'%Y-%m') AS date_unix, ".MINUTE_TIMESTAMP."*AVG($realtime_table.realtime) AS total_visites  FROM glpi_tracking ".
683
                                $LEFTJOIN.$WHERE.
684
                                " GROUP BY date_unix ORDER BY glpi_tracking.closedate";
685
                        break;
686
                case "inter_avgtakeaccount" :
687
                        $WHERE.=" AND ( glpi_tracking.status = 'old_done' OR glpi_tracking.status = 'old_notdone') AND glpi_tracking.closedate <> '0000-00-00 00:00:00' ";
688
                        if (!empty($begin)) $WHERE.= " AND glpi_tracking.closedate >= '$begin' ";
689
                        if (!empty($end)) $WHERE.= " AND glpi_tracking.closedate <= '$end' ";
690

    
691
                        $query="SELECT glpi_tracking.ID AS ID, FROM_UNIXTIME(UNIX_TIMESTAMP(glpi_tracking.closedate),'%Y-%m') AS date_unix, MIN(UNIX_TIMESTAMP(glpi_tracking.closedate)-UNIX_TIMESTAMP(glpi_tracking.date)) AS OPEN, MIN(UNIX_TIMESTAMP(glpi_followups.date)-UNIX_TIMESTAMP(glpi_tracking.date)) AS FIRST FROM glpi_tracking LEFT JOIN glpi_followups ON (glpi_followups.tracking = glpi_tracking.ID) ";
692
                        if (!ereg("glpi_followups",$LEFTJOIN)){
693
                                $query.=$LEFTJOIN;
694
                        }
695
                                $query.=$WHERE." GROUP BY glpi_tracking.ID";
696
                        break;
697

    
698
                        //                $query = " from glpi_tracking LEFT JOIN glpi_followups ON (glpi_followups.tracking = glpi_tracking.ID) where glpi_tracking.status ='old'  and closedate != '0000-00-00' and YEAR(glpi_tracking.date) = YEAR(NOW())";        
699

    
700
        }
701
        //echo $query."<br><br>";
702
        $entrees=array();
703
        $count=array();
704
        if (empty($query)) return array();
705
        
706
        $result=$DB->query($query);
707
        if ($result&&$DB->numrows($result)>0)
708
                while ($row = $DB->fetch_array($result)) {
709
                        $date = $row['date_unix'];
710
                        if ($type=="inter_avgtakeaccount"){
711
                                $min=$row["OPEN"];        
712
                                if (!empty($row["FIRST"])&&!is_null($row["FIRST"])&&$row["FIRST"]<$min) $min=$row["FIRST"];
713
                                if (!isset($entrees["$date"])) {$entrees["$date"]=$min; $count["$date"]=1;}
714
                                else {$entrees["$date"]+=$min;$count["$date"]++;}
715
                        } else {
716
                                $visites = round($row['total_visites']);
717
                                $entrees["$date"] = $visites;
718
                        }
719
                }
720

    
721

    
722

    
723
        if ($type=="inter_avgtakeaccount"){
724

    
725
                foreach ($entrees as $key => $val){
726
                        $entrees[$key]=round($entrees[$key]/$count[$key]/HOUR_TIMESTAMP);
727

    
728
                }
729
        }
730

    
731
        // Remplissage de $entrees pour les mois ou il n'y a rien
732

    
733
        $min=-1;                
734
        $max=0;                
735
        if (count($entrees)==0) return $entrees;
736

    
737
        foreach ($entrees as $key => $val){
738
                $time=strtotime($key."-01");
739
                if ($min>$time||$min<0) $min=$time;
740
                if ($max<$time) $max=$time;
741
        }
742

    
743
        $end_time=strtotime(date("Y-m",strtotime($end))."-01");
744
        $begin_time=strtotime(date("Y-m",strtotime($begin))."-01");
745

    
746
        if ($max<$end_time) $max=$end_time;
747
        if ($min>$begin_time) $min=$begin_time;
748
        $current=$min;
749
        
750
        while ($current<=$max){
751
                $curentry=date("Y-m",$current);
752
                if (!isset($entrees["$curentry"])) $entrees["$curentry"]=0;
753
                $month=date("m",$current);
754
                $year=date("Y",$current);
755

    
756
                $current=mktime(0,0,0,intval($month)+1,1,intval($year));
757
        }
758

    
759
        return $entrees;
760
}
761

    
762

    
763

    
764
/** Get groups assigned to tickets between 2 dates
765
* BASED ON SPIP DISPLAY GRAPH : www.spip.net
766
* @param $type string : "month" or "year"
767
* @param $entrees array : array containing data to displayed
768
* @param $titre string : title 
769
* @param $unit string : unit 
770
* @param $showtotal boolean : also show total values ?
771
* @return array contains the distinct groups assigned to a tickets
772
*/
773
function graphBy($entrees,$titre="",$unit="",$showtotal=1,$type="month"){
774

    
775
        global $DB,$CFG_GLPI,$LANG;
776
        ksort($entrees);
777
        $total="";
778
        if ($showtotal==1) $total=array_sum($entrees);
779

    
780
        echo "<p align='center'>";
781
        echo "<font face='verdana,arial,helvetica,sans-serif' size='2'><strong>$titre - $total $unit</strong></font>";
782

    
783
        echo "<div class='center'>";
784

    
785
        if (count($entrees)>0){
786

    
787
                $max = max($entrees);
788
                $maxgraph = substr(ceil(substr($max,0,2) / 10)."000000000000", 0, strlen($max));
789

    
790
                if ($maxgraph < 10) $maxgraph = 10;
791
                if (1.1 * $maxgraph < $max) $maxgraph.="0";        
792
                if (0.8*$maxgraph > $max) $maxgraph = 0.8 * $maxgraph;
793
                $rapport = 200 / $maxgraph;
794

    
795
                $largeur = floor(420 / (count($entrees)));
796
                if ($largeur < 1) $largeur = 1;
797
                if ($largeur > 50) $largeur = 50;
798
        }
799

    
800
        echo "<table cellpadding='0' cellspacing='0' border='0' ><tr><td style='background-image:url(".$CFG_GLPI["root_doc"]."/pics/fond-stats.gif)' >";
801
        echo "<table cellpadding='0' cellspacing='0' border='0'><tr>";
802
        echo "<td bgcolor='black'><img src='".$CFG_GLPI["root_doc"]."/pics/noir.png' width='1' height='200' alt=''></td>";
803

    
804
        // Presentation graphique
805
        $n = 0;
806
        $decal = 0;
807
        $tab_moyenne = "";
808
        $total_loc=0;
809
        while (list($key, $value) = each($entrees)) {
810
                $n++;
811

    
812
                if ($decal == 30) $decal = 0;
813
                $decal ++;
814
                $tab_moyenne[$decal] = $value;
815

    
816
                $total_loc = $total_loc + $value;
817
                reset($tab_moyenne);
818

    
819
                $moyenne = 0;
820
                while (list(,$val_tab) = each($tab_moyenne))
821
                        $moyenne += $val_tab;
822
                $moyenne = $moyenne / count($tab_moyenne);
823

    
824
                $hauteur_moyenne = round($moyenne * $rapport) ;
825
                $hauteur = round($value * $rapport)        ;
826
                echo "<td valign='bottom' width=".$largeur.">";
827

    
828
                if ($hauteur >= 0){
829
                        if ($hauteur_moyenne > $hauteur) {
830
                                $difference = ($hauteur_moyenne - $hauteur) -1;
831
                                echo "<img alt=\"$key: $value\" title=\"$key: $value\"  src='".$CFG_GLPI["root_doc"]."/pics/moyenne.png' width=".$largeur." height='1' >";
832
                                echo "<img alt=\"$key: $value\" title=\"$key: $value\"  src='".$CFG_GLPI["root_doc"]."/pics/rien.gif' width=".$largeur." height=".$difference." >";
833
                                echo "<img alt=\"$key: $value\" title=\"$key: $value\"  src='".$CFG_GLPI["root_doc"]."/pics/noir.png' width=".$largeur." height='1' >";
834
                                if (ereg("-01",$key)){ // janvier en couleur foncee
835
                                        echo "<img alt=\"$key: $value\" title=\"$key: $value\"  src='".$CFG_GLPI["root_doc"]."/pics/fondgraph1.png' width=".$largeur." height=".$hauteur." >";
836
                                } 
837
                                else {
838
                                        echo "<img alt=\"$key: $value\" title=\"$key: $value\"  src='".$CFG_GLPI["root_doc"]."/pics/fondgraph2.png' width=".$largeur." height=".$hauteur." >";
839
                                }
840
                        }
841
                        else if ($hauteur_moyenne < $hauteur) {
842
                                $difference = ($hauteur - $hauteur_moyenne) -1;
843
                                echo "<img alt=\"$key: $value\" title=\"$key: $value\"  src='".$CFG_GLPI["root_doc"]."/pics/noir.png' width=".$largeur." height='1'>";
844
                                if (ereg("-01",$key)){ // janvier en couleur foncee
845
                                        $couleur =  "1";
846
                                        $couleur2 =  "2";
847
                                } 
848
                                else {
849
                                        $couleur = "2";
850
                                        $couleur2 = "1";
851
                                }
852
                                echo "<img alt=\"$key: $value\" title=\"$key: $value\"  src='".$CFG_GLPI["root_doc"]."/pics/fondgraph$couleur.png' width=".$largeur." height=".$difference.">";
853
                                echo "<img alt=\"$key: $value\" title=\"$key: $value\"  src='".$CFG_GLPI["root_doc"]."/pics/moyenne.png' width=".$largeur." height='1'>";
854
                                echo "<img alt=\"$key: $value\" title=\"$key: $value\"  src='".$CFG_GLPI["root_doc"]."/pics/fondgraph$couleur.png' width=".$largeur." height=".$hauteur_moyenne.">";
855
                        }
856
                        else {
857
                                echo "<img alt=\"$key: $value\" title=\"$key: $value\"  src='".$CFG_GLPI["root_doc"]."/pics/noir.png' width=".$largeur." height='1'>";
858
                                if (ereg("-01",$key)){ // janvier en couleur foncee
859
                                        echo "<img alt=\"$key: $val_tab\" title=\"$key: $value\" src='".$CFG_GLPI["root_doc"]."/pics/fondgraph1.png' width=".$largeur." height=".$hauteur.">";
860
                                } 
861
                                else {
862
                                        echo "<img alt=\"$key: $value\" title=\"$key: $value\"  src='".$CFG_GLPI["root_doc"]."/pics/fondgraph2.png' width=".$largeur." height=".$hauteur.">";
863
                                }
864
                        }
865
                }
866

    
867
                echo "<img alt=\"$value\" title=\"$value\"  src='".$CFG_GLPI["root_doc"]."/pics/rien.gif' width=".$largeur." height='1'>";
868
                echo "</td>\n";
869

    
870
        }
871
        echo "<td bgcolor='black'><img src='".$CFG_GLPI["root_doc"]."/pics/noir.png' width='1' height='1' alt=''></td>";
872
        echo "</tr>";
873
        if ($largeur>10){
874
                echo "<tr><td></td>";
875
                foreach ($entrees as $key => $val){
876
                        if ($type=="month"){
877
                                $splitter=split("-",$key);
878
                                echo "<td class='center'>".utf8_substr($LANG["calendarM"][$splitter[1]-1],0,3)."</td>";
879
                        } else if ($type=="year"){
880
                                echo "<td class='center'>".substr($key,2,2)."</td>";
881
                        }
882
                }
883
                echo "</tr>";
884
        }
885

    
886
        if ($maxgraph<=10) $r=2;
887
        else if ($maxgraph<=100) $r=1;
888
        else $r=0;
889
        echo "</table>";
890
        echo "</td>";
891
        echo "<td style='background-image:url(".$CFG_GLPI["root_doc"]."/pics/fond-stats.gif)' valign='bottom'><img src='".$CFG_GLPI["root_doc"]."/pics/rien.gif' style='background-color:black;' width='3' height='1' alt=''></td>";
892
        echo "<td><img src='".$CFG_GLPI["root_doc"]."/pics/rien.gif' width='5' height='1' alt=''></td>";
893
        echo "<td valign='top'>";
894
        echo "<table cellpadding='0' cellspacing='0' border='0'>";
895
        echo "<tr><td height='15' valign='top'>";                
896
        echo "<font face='arial,helvetica,sans-serif' size='1'><strong>".formatNumber($maxgraph,false,$r)."</strong></font>";
897
        echo "</td></tr>";
898
        echo "<tr><td height='25' valign='middle'>";                
899
        echo "<font face='arial,helvetica,sans-serif' size='1' color='#999999'>".formatNumber(7*($maxgraph/8),false,$r)."</font>";
900
        echo "</td></tr>";
901
        echo "<tr><td height='25' valign='middle'>";                
902
        echo "<font face='arial,helvetica,sans-serif' size='1'>".formatNumber(3*($maxgraph/4),false,$r)."</font>";
903
        echo "</td></tr>";
904
        echo "<tr><td height='25' valign='middle'>";                
905
        echo "<font face='arial,helvetica,sans-serif' size='1' color='#999999'>".formatNumber(5*($maxgraph/8),false,$r)."</font>";
906
        echo "</td></tr>";
907
        echo "<tr><td height='25' valign='middle'>";                
908
        echo "<font face='arial,helvetica,sans-serif' size='1'><strong>".formatNumber($maxgraph/2,false,$r)."</strong></font>";
909
        echo "</td></tr>";
910
        echo "<tr><td height='25' valign='middle'>";                
911
        echo "<font face='arial,helvetica,sans-serif' size='1' color='#999999'>".formatNumber(3*($maxgraph/8),false,$r)."</font>";
912
        echo "</td></tr>";
913
        echo "<tr><td height='25' valign='middle'>";                
914
        echo "<font face='arial,helvetica,sans-serif' size='1'>".formatNumber($maxgraph/4,false,$r)."</font>";
915
        echo "</td></tr>";
916
        echo "<tr><td height='25' valign='middle'>";                
917
        echo "<font face='arial,helvetica,sans-serif' size='1' color='#999999'>".formatNumber(1*($maxgraph/8),false,$r)."</font>";
918
        echo "</td></tr>";
919
        echo "<tr><td height='10' valign='bottom'>";                
920
        echo "<font face='arial,helvetica,sans-serif' size='1'><strong>0</strong></font>";
921
        echo "</td>";
922

    
923
        echo "</tr></table>";
924
        echo "</td></tr></table>";
925
        echo "</div>";
926

    
927

    
928

    
929
}
930

    
931

    
932
function showItemStats($target,$date1,$date2,$start){
933
        global $DB,$CFG_GLPI,$LANG;
934

    
935

    
936
        $view_entities=isMultiEntitiesMode();
937

    
938
        if ($view_entities){
939
                $entities=getAllDatasFromTable('glpi_entities');
940
        }
941

    
942
        $output_type=HTML_OUTPUT;
943
        if (isset($_GET["display_type"]))
944
                $output_type=$_GET["display_type"];
945

    
946
        if (empty($date2)) $date2=date("Y-m-d");
947
        $date2.=" 23:59:59";
948
        // 1 an par defaut
949
        if (empty($date1)) $date1=date("Y-m-d",mktime(0,0,0,date("m"),date("d"),date("Y")-1));
950
        $date1.=" 00:00:00";
951

    
952

    
953
        $query="SELECT device_type,computer,COUNT(*) AS NB 
954
                FROM glpi_tracking 
955
                WHERE date<= '".$date2."' AND date>= '".$date1."' ".getEntitiesRestrictRequest("AND","glpi_tracking")." 
956
                GROUP BY device_type,computer ORDER BY NB DESC";
957
        
958
        $result=$DB->query($query);
959
        $numrows=$DB->numrows($result);
960

    
961
        if ($numrows>0){
962
                if ($output_type==HTML_OUTPUT){
963
                        printPager($start,$numrows,$target,"date1=".$date1."&amp;date2=".$date2."&amp;type=hardwares&amp;start=$start",STAT_TYPE);
964
                        echo "<div class='center'>";
965
                }
966

    
967
                $i=$start;
968
                if (isset($_GET['export_all']))
969
                        $i=0;
970

    
971
                $end_display=$start+$_SESSION["glpilist_limit"];
972
                if (isset($_GET['export_all']))
973
                        $end_display=$numrows;
974
                echo displaySearchHeader($output_type,$end_display-$start+1,2,1);
975
                $header_num=1;
976
                echo displaySearchNewLine($output_type);
977
                echo displaySearchHeaderItem($output_type,$LANG["common"][1],$header_num);
978
                if ($view_entities){
979
                        echo displaySearchHeaderItem($output_type,$LANG["entity"][0],$header_num);
980
                }
981
                echo displaySearchHeaderItem($output_type,$LANG["stats"][13],$header_num);
982
                echo displaySearchEndLine($output_type);
983

    
984
                $DB->data_seek($result,$start);
985

    
986
                $ci=new CommonItem();
987
                while ($i < $numrows && $i<($end_display)){
988
                        $item_num=1;
989
                        // Get data and increment loop variables
990
                        $data=$DB->fetch_assoc($result);
991
                        if ($ci->getFromDB($data["device_type"],$data["computer"])){
992
                                //echo "<tr class='tab_bg_2$del'><td>".$ci->getLink()."</td><td>".$data["NB"]."</td></tr>";
993
                                echo displaySearchNewLine($output_type,$i%2);
994
                                echo displaySearchItem($output_type,$ci->getLink(),$item_num,$i-$start+1,"align='center'"." ".($ci->getField("deleted")?" class='deleted' ":""));
995
                                if ($view_entities){
996
                                        $ent=$ci->getField('FK_entities');
997
                                        if ($ent==0){
998
                                                $ent=$LANG["entity"][2];
999
                                        } else {
1000
                                                $ent=$entities[$ent]['completename'];
1001
                                        }
1002
                                        echo displaySearchItem($output_type,$ent,$item_num,$i-$start+1,"align='center'"." ".($ci->getField("deleted")?" class='deleted' ":""));
1003
                                }        
1004
                                echo displaySearchItem($output_type,$data["NB"],$item_num,$i-$start+1,"align='center'"." ".($ci->getField("deleted")?" class='deleted' ":""));
1005
                        }
1006
                        $i++;
1007
                }
1008

    
1009
                echo displaySearchFooter($output_type);
1010
                if ($output_type==HTML_OUTPUT)
1011
                        echo "</div>";
1012
        }
1013

    
1014
}
1015

    
1016

    
1017
?>
Redmine Appliance - Powered by TurnKey Linux