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

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

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

//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

  $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

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

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

  <td align=\"left\">" . $data['os_license_id'] . " " . $data['otherserial'] . "<br />" . $data['os_license_number'] . " " . $data['otherserial'] ."</td>

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

  <td>" . $data['nbusers'] . "</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

    //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

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

ORDER BY client\n";

    //print $query;

  <td align=\"left\">" . $data['os_license_id'] . " " . $data['otherserial'] . "<br />" . $data['os_license_number'] . " " . $data['otherserial'] . "</td>

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

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

</tr>\n";

      /*

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