Révision f8b606aa plugins/anet_epacks/front/plugin_anet_epacks.view_array_recap.php
| plugins/anet_epacks/front/plugin_anet_epacks.view_array_recap.php | ||
|---|---|---|
| 87 | 87 |
// |
| 88 | 88 |
function local_make_query($data, $entityid, $maintenance) {
|
| 89 | 89 |
$query = "SELECT e.*, e.FK_enduser as entityid, g3.name as client, g4.name as serveur, g4.os_license_number, g4.os_license_id, ssh.*, |
| 90 |
(sum(g5.nbeleves)+sum(g5.nbprofs)) as nbusers, g5.nbpc as nbpc
|
|
| 90 |
(g5.nbeleves+g5.nbprofs) as nbusers, g5.nbpc as nbpc
|
|
| 91 | 91 |
FROM glpi_plugin_anet_epacks AS e |
| 92 | 92 |
LEFT JOIN glpi_plugin_anet_epacks_ssh_max AS ssh ON e.FK_serveur=ssh.FK_serveur |
| 93 | 93 |
LEFT JOIN glpi_entities AS g3 ON e.FK_client=g3.ID |
| ... | ... | |
| 103 | 103 |
$query .= "WHERE e.FK_contract='-1' AND e.FK_activation='" . $entityid . "'\n"; |
| 104 | 104 |
} |
| 105 | 105 |
//GROUP BY e.FK_serveur |
| 106 |
$query .= "GROUP BY e.FK_client
|
|
| 106 |
$query .= "GROUP BY e.FK_serveur
|
|
| 107 | 107 |
ORDER BY client ASC |
| 108 | 108 |
LIMIT 500;"; |
| 109 | 109 |
} |
Formats disponibles : Unified diff