RyXéo » GLPI

//

function local_make_query($data, $entityid, $maintenance) {

  $query = "SELECT e.*, e.FK_enduser as entityid, g3.name as client, g4.name as serveur, g4.os_license_number, g4.os_license_id, g4.otherserial, ssh.*,

FROM glpi_plugin_anet_epacks AS e

LEFT JOIN glpi_plugin_anet_epacks_ssh_max AS ssh ON e.FK_serveur=ssh.FK_serveur

LEFT JOIN glpi_entities AS g3 ON (e.FK_client=g3.ID OR e.FK_enduser=g3.ID)

LEFT JOIN glpi_computers AS g4 ON e.FK_serveur=g4.ID

LEFT JOIN glpi_plugin_anet_epacks_recencement_max AS g5 ON e.FK_serveur=g5.FK_serveur

  //WHERE e.Fk_Serveur > '0'\n";

  if($data['name'] == "revendeur" || $data['name'] == "dsi") {

    //On ne peut pas group by client a cause de l'historique ou on avait pas la meme structure

    //de base

    $query .= "GROUP BY e.FK_serveur

LIMIT 500;";

  }

//special pour trouver les serveurs existants mais les enduser=0 (abonnement zen pas fait ou autre ?)

function local_make_query_zarb() {

  $query = "SELECT e.*, e.FK_enduser as entityid, g3.name as client, g4.name as serveur, g4.os_license_number, g4.os_license_id, g4.otherserial, ssh.*,

FROM glpi_plugin_anet_epacks AS e

LEFT JOIN glpi_plugin_anet_epacks_ssh_max AS ssh ON e.FK_serveur=ssh.FK_serveur

LEFT JOIN glpi_entities AS g3 ON (e.FK_client=g3.ID OR e.FK_enduser=g3.ID)

LEFT JOIN glpi_computers AS g4 ON e.FK_serveur=g4.ID

LEFT JOIN glpi_plugin_anet_epacks_recencement_max AS g5 ON e.FK_serveur=g5.FK_serveur

  $query .= "WHERE e.FK_enduser='0' AND e.FK_client!='0'\n";

  $query .= "GROUP BY e.FK_serveur

ORDER BY client ASC

//Special pour les "dsi" quand on convertis a la vollee les comptes post-only en dsi pour les animtice

function local_make_query_dsi($data, $entityid, $maintenance) {

  $query = "SELECT e.*, e.FK_enduser as entityid, g3.name as client, g4.name as serveur, g4.os_license_number, g4.os_license_id, g4.otherserial, ssh.*,

FROM glpi_plugin_anet_epacks AS e

LEFT JOIN glpi_plugin_anet_epacks_ssh_max AS ssh ON e.FK_serveur=ssh.FK_serveur

LEFT JOIN glpi_entities AS g3 ON (e.FK_client=g3.ID OR e.FK_enduser=g3.ID)

LEFT JOIN glpi_computers AS g4 ON e.FK_serveur=g4.ID

LEFT JOIN glpi_plugin_anet_epacks_recencement_max AS g5 ON e.FK_serveur=g5.FK_serveur

  //WHERE e.Fk_Serveur > '0'\n";

  if($data['name'] == "dsi") {

  <td>" . $data['nbpc'] . "</td>

  <td>" . $data['nbusers'] . "</td>

  <td>" . $data['contract'] . "</td>

</tr>\n";

      /*

       <a href=\"../../../front/contract.php?contains[0]=" . $data['client'] . "\"><img src=\"img/stock_hand-signed.png\" title=\"Contrat\"></a>

  if($enduser == 1) {

    $query = "SELECT e.*, e.FK_enduser as entityid, g3.name as client, g4.name as serveur, g4.os_license_number, g4.os_license_id, g4.otherserial, ssh.*,

FROM glpi_plugin_anet_epacks AS e

LEFT JOIN glpi_plugin_anet_epacks_ssh_max AS ssh ON e.FK_serveur=ssh.FK_serveur

LEFT JOIN glpi_entities AS g3 ON (e.FK_client=g3.ID OR e.FK_enduser=g3.ID)

LEFT JOIN glpi_computers AS g4 ON e.FK_serveur=g4.ID

LEFT JOIN glpi_plugin_anet_epacks_recencement_max AS g5 ON e.FK_serveur=g5.FK_serveur

    //WHERE e.Fk_Serveur > '0'\n";

    if($maintenance == 0 || $maintenance ==  1) {

  }

  else {

    //LEFT JOIN glpi_entities AS g3 ON e.FK_client=g3.ID OR e.FK_enduser=g3.ID

FROM glpi_plugin_anet_epacks AS e

LEFT JOIN glpi_plugin_anet_epacks_ssh_max AS ssh ON e.FK_serveur=ssh.FK_serveur

LEFT JOIN glpi_entities AS g3 ON (e.FK_client=g3.ID OR e.FK_enduser=g3.ID)

LEFT JOIN glpi_computers AS g4 ON e.FK_serveur=g4.ID

LEFT JOIN glpi_plugin_anet_epacks_recencement_max AS g5 ON e.FK_serveur=g5.FK_serveur

LEFT JOIN glpi_contracts AS g6 ON e.FK_contract=g6.ID

WHERE e.FK_enduser='0' AND e.FK_client!='0'

ORDER BY client\n";

    //print $query;

  <td>" . $data['nbpc'] . "</td>

  <td>" . $data['nbusers'] . "</td>

  <td>" . $data['contract'] . "</td>

</tr>\n";

      /*

	  <a href=\"../../../front/contract.php?contains[0]=" . $data['client'] . "\"><img src=\"img/stock_hand-signed.png\" title=\"Contrat\"></a>

  <th><img src=\"img/computer.png\" alt=\"Nombre de postes\" title=\"Nombre de postes clients\"></th>

  <th><img src=\"img/stock_people.png\" alt=\"Nombre d'utilisateurs\" title=\"Nombre d'utilisateurs\"></th>

  <th><img src=\"img/stock_hand-signed.png\" title=\"Contrat\"></th>

</tr>\n";

}

  <td>" . $total_nbpc . "</td>

  <td>" . $total_nbusers . "</td>

  <td></td>

</tr>\n";

  $s .= "</table>";