[Glpi-dev] Patch plugins Report

[Adrien Beudin]

 

Bonjour, 

j'ai fait un petit patch pour ajouter la possibilité de
voir les contrats qui on était déplacé d'une entité à une autre dans le
rapport "Liste des objets transférés" 

Cordialement 

Adrien Beudin -
05 82 95 65 36
Objectif Libre www.objectif-libre.com
Infrastructure et
Formations Linux
 
--- reports/report/transferreditems/transferreditems.php        2013-05-02 
15:03:33.000000000 +0200
+++ 
/var/www/html/glpi/plugins/reports/report/transferreditems/transferreditems.php 
    2014-04-22 13:14:06.580330286 +0200
@@ -42,7 +42,7 @@
 new PluginReportsDateIntervalCriteria($report, "`glpi_logs`.`date_mod`");
 
 $types = array();
-foreach (array('Computer', 'Monitor', 'NetworkEquipment', 'Peripheral', 
'Phone', 'Printer',
+foreach (array('Computer', 'Contract',  'Monitor', 'NetworkEquipment', 
'Peripheral', 'Phone', 'Printer',
                'Software','SoftwareLicense') as $type) {
    $label       = call_user_func(array($type, 'getTypeName'));
    $types[$type] = $label;
@@ -65,8 +65,22 @@
                     new PluginReportsColumn('new_value', __('Target entity', 
'reports')),
                     new PluginReportsColumnDateTime('date_mod', __('Transfert 
date', 'reports')));
    $report->setColumns($columns);
-
-   $query = "SELECT `$table`.`id` as `items_id`,
+   if ($itemtype == 'Contract') {
+      $query = "SELECT `$table`.`id` as `items_id`,
+                    `$table`.`name`,
+                    `glpi_logs`.`date_mod` as `date_mod`,
+                    `glpi_logs`.`itemtype` as `itemtype`,
+                    `glpi_logs`.`old_value`,
+                    `glpi_logs`.`new_value`
+             FROM `$table`, `glpi_logs` ".
+             $report->addSqlCriteriasRestriction("WHERE")."
+                   AND `glpi_logs`.`items_id` = `$table`.`id`
+                   AND `glpi_logs`.`itemtype` = '$itemtype'
+                   AND `glpi_logs`.`id_search_option`='80'
+             ORDER BY `date_mod` ASC";
+   }
+   else {
+      $query = "SELECT `$table`.`id` as `items_id`,
                     `$table`.`name`,
                     `$table`.`otherserial`,
                     `glpi_logs`.`date_mod` as `date_mod`,
@@ -79,8 +93,9 @@
                    AND `glpi_logs`.`itemtype` = '$itemtype'
                    AND `glpi_logs`.`id_search_option`='80'
              ORDER BY `date_mod` ASC";
+   }
 
    $report->setSqlRequest($query);
    $report->execute();
 }
-?>
\ Pas de fin de ligne à la fin du fichier.
+?>
_______________________________________________
Glpi-dev mailing list
Glpi-dev@gna.org
https://mail.gna.org/listinfo/glpi-dev