Révision b0bf16dc plugins/anet_epacks/front/plugin_anet_epacks.view_recap_mensuel_rvd.php
| plugins/anet_epacks/front/plugin_anet_epacks.view_recap_mensuel_rvd.php | ||
|---|---|---|
| 36 | 36 |
LEFT JOIN glpi_computers AS g4 ON FK_serveur=g4.ID |
| 37 | 37 |
WHERE creation_date>'0000-00-00' |
| 38 | 38 |
AND activation_date>'2009-01-01' |
| 39 |
AND activation_date<'" . $_GET['year'] . "-" . $_GET['month'] . "-00'
|
|
| 39 |
AND activation_date<'" . $_GET['year'] . "-" . ($_GET['month']-1) . "-20'
|
|
| 40 | 40 |
AND FK_clientderyxeo='" . $id . "' |
| 41 | 41 |
AND FK_contract>='0' |
| 42 | 42 |
ORDER BY activation_date"; |
| 43 |
//print $query2; |
|
| 43 | 44 |
$result2 = $DB->query($query2) or die($DB->error()); |
| 44 | 45 |
|
| 45 | 46 |
//La liste des epacks clairement hors maintenance |
| ... | ... | |
| 77 | 78 |
//Le tableau global pour avoir la liste des revendeurs |
| 78 | 79 |
//parentid=3 -> c'est l'entité "partenaires" |
| 79 | 80 |
$query = "SELECT e.FK_clientderyxeo,g.name as clientderyxeo FROM glpi_plugin_anet_epacks AS e LEFT JOIN glpi_entities AS g ON FK_clientderyxeo=g.ID WHERE parentID='3' GROUP BY FK_clientderyxeo"; |
| 81 |
//print $query; |
|
| 80 | 82 |
$result = $DB->query($query) or die($DB->error()); |
| 81 | 83 |
|
| 82 | 84 |
for($i = 0; $i < $DB->numrows($result); $i++) {
|
Formats disponibles : Unified diff