RyXéo » GLPI

 <li><a href=\"plugin_anet_epacks.generate_odt_client.form.php\">Créer un nouveau pack pour un CLIENT</a></li>

 <li><a href=\"plugin_anet_epacks.generate_odt_client_8_to_9.form.php\">Créer un nouveau pack CLIENT qui migre un serveur 8.08 en 9.08</a></li>

 <li><a href=\"plugin_anet_epacks.generate_odt_contrat_partenaire_enr2009.form.php\">Créer un contrat de maintenance pour partenaire ENR 2009</a></li>

 <li><a href=\"plugin_anet_epacks.view_maintenance.php?year=" . date("Y") . "\">Liste des contrats auto-générés</a></li>

 <li><a href=\"plugin_anet_epacks.view_recap_mensuel_rvd.php?year=" . date("Y") . "&month=" . date("m") . "\">Relevé mensuel pour facturer les revendeurs</a></li>

</ul>

<h2>Tâches pour l'administrateur</h2>

<ul style=\"text-align: left;margin-left: 40px;\">

 <li><a href=\"plugin_anet_epacks.verif_multigroupes.php\">Chercher les erreurs d'affectations des epacks-entités ou des clients qui font partis de plusieurs groupes</a></li>

 <li><a href=\"plugin_anet_epacks.verif_modifhardware.php\">Chercher les serveurs dont le matériel a été modifié</a></li>

</ul>

";

//

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>