RyXéo » GLPI

<?php

/*

* recherche les contrats qui ne sont pas raccrochés aux epacks

* dans la table glpi_plugin_anet_epacks on a un FK_contract qui doit faire référence au bon contrat.

* pour mettre à jour on cherche donc les FK_enduser dans glpi_plugin_anet_epacks WHERE FK_contract=0

* ensuite on cherche si ce FK_enduser existe dans glpi_contracts FK_entities

* si c'est le cas on met à jour glpi_plugin_anet_epacks

*

*/

if(!defined('GLPI_ROOT')){

  define('GLPI_ROOT', '../../..');

}

include_once (GLPI_ROOT . "/inc/includes.php");

checkRight("config","w");

global $DB;

commonHeader("anet_epacks",$_SERVER['PHP_SELF'],"config","plugins");

print "<h3>Recollage automatique des epacks <-> contrats</h3>\n";

print "<div style=\"text-align:left\">";

$automatique = "";

$manuel = "";

$query = "SELECT FK_enduser,code FROM glpi_plugin_anet_epacks WHERE (FK_contract='0' OR FK_contract='-1') AND FK_enduser>'0'";

$result = $DB->query($query);

//print $query;

while($data=$DB->fetch_array($result)) {

  $enduser=$data[0];

  $code=$data[1];

  $query1 = "SELECT * FROM glpi_entities WHERE ID='" . $enduser  . "'";

  $result1 = $DB->query($query1);

  $data1=$DB->fetch_array($result1);

  $clientfinal = $data1['completename'];

  //order by pour prendre le dernier contrat ... si on recolle automatiquement et qu'il y a un ancien contrat il faut recoller avecle plus recent

  $query2 = "SELECT *,(TO_DAYS(begin_date) + (duration*30)) AS endDay FROM glpi_contracts WHERE FK_entities='" . $enduser  . "' AND (TO_DAYS(begin_date) + (duration*30)) > TO_DAYS(NOW()) AND deleted='0' ORDER BY begin_date DESC LIMIT 1";

  //print "<pre>$query2</pre>";

  $result2 = $DB->query($query2);

  $data2=$DB->fetch_array($result2);

  if(trim($data2['name']) != "") {

    $query3 = "UPDATE glpi_plugin_anet_epacks SET FK_contract='" . $data2['ID']  . "' WHERE FK_enduser='$enduser'";

    //$query3 = "UPDATE glpi_plugin_anet_epacks SET FK_contract='-1' WHERE FK_enduser='$enduser'";

    $automatique .= "<p>Recollement automatique pour $code -> $clientfinal -> nouvelle ref contrat: " . $data2['ID'] . "</p>";

    //print $query3;

    $result3 = $DB->query($query3);

    $data3=$DB->fetch_array($result3);

  }

  else {

    if(is_array($data2)) {

      $manuel .= "<tr><td>$code</td><td>$clientfinal</td><td>$enduser</td><td>" . $data2['ID'] . "</td></tr>\n";

    }

  }

 }

print "<h4>Recollage automatique :</h4>";

print $automatique;

print "<h4>Recollage manuel à faire ou à vérifier :</h4>";

print "<table>

<tr>

 <td>epack</td>

 <td>client final</td>

 <td>ref</td>

 <td>recollement auto</td>

</tr>

";

print $manuel;

print "</table>";

//$query = "UPDATE `glpi_users` SET FK_entities='1' WHERE `FK_entities` = 0 AND email NOT LIKE '%ryxeo.com'";

//$result = $DB->query($query);

commonFooter();

?>