RyXéo » GLPI

<?php

/*

  gestion des contrats - affichage et rappel

  http://www.abuledu.net/mac/contract.php/view=toto/mac=08:D8:34:B8:90:CD

  Code retour:

  timestampfincontrat:CODE:nom du contrat:texte informatif:hashcode pour mise a jour(tabuledu):

*/

$g_http_request = $_SERVER['REQUEST_URI'];

preg_match("/.*mac=(.*)/",$_SERVER['REQUEST_URI'],$regs);

$mac  = addslashes(strtoupper($regs[1]));

preg_match("/.*view=(.*)\/mac=/",$_SERVER['REQUEST_URI'],$regs);

$view = addslashes($regs[1]);

$hash = hash("md5", time() + "abuledu.net");

//print "on a $mac et $view";

function insert_hash_allow_upgrade() {

  global $hash, $DB;

  $version = "0.0";

  $ip = $_SERVER['REMOTE_ADDR'];

  //Insere le hash dans la table

  $query = "INSERT INTO glpi_plugin_anet_upgrade_hash VALUES('',NOW(),'$ip','$hash','$version')";

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

}

//Ou du POST

if(trim($mac) == "") {

  $mac = addslashes(strtoupper($_POST['mac']));

}

$_SERVER['REQUEST_URI'] = "";

$_SERVER['HTTP_REFERER'] = "";

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

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

//On recupere l'id du serveur dont la macaddr correspond

$query = "SELECT FK_computers AS ID FROM glpi_computer_device WHERE specificity ='" . $mac . "'";

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

$data = $DB->fetch_assoc($result);

//print_r($data);

if($data['ID']) {

  $serverid=$data['ID'];

  //Quand on a le serverID il faut trouver l'entite dans laquelle il se trouve

  $queryEntity = "SELECT FK_entities AS EntityID FROM glpi_computers WHERE ID='$serverid'";

  $resultEntity = $DB->query($queryEntity);

  $dataEntity = $DB->fetch_assoc($resultEntity);

  $entityID = $dataEntity['EntityID'];

  //Et ensuite on cherche dans les contrats ce qui correspond

  // -> contrat non supprime

  // -> contrat correspondant a ce serveur

  // -> contrat de type 1 ()

  $query2 = "SELECT UNIX_TIMESTAMP(c.begin_date + INTERVAL c.duration MONTH) as endcontract,c.* FROM glpi_contracts as c WHERE 

  c.deleted='0' AND

  c.FK_entities='$entityID'";

  //print $query2;

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

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

  //print_r($data2);

  //print mktime() . " -- ";

  $endc = $data2['endcontract'];

  if($endc > mktime()) {

    if($view == "web") {

      header('Location: http://www.abuledu.net/mac/view/direct.php');

      exit;

    }

    else {

      insert_hash_allow_upgrade();

      print $endc . ":" . "DIRECT:" . $data2['name'] . ":none:$hash";

    }

  }

  //Reconduction automatique ...

  else if($endc < mktime() && $data2['recursive']=='1') {

    if($view == "web") {

      header('Location: http://www.abuledu.net/mac/view/direct.php');

      exit;

    }

    else {

      print mktime(0,0,0, date("m",$endc)+$data2['periodicity'], date("d",$endc), date("Y",$endc)) . ":" . "DIRECT:" . $data2['name'] . ":" . "Renouvellement automatique:$hash";

    }

  }

  else {

    //Le serveur a ete installe par un partenaire qui a un contrat global mais pas encore d'avenant pour ce serveur

    //1 on cherche le partenaire qui a installe ce serveur

    $query3 = "SELECT UNIX_TIMESTAMP(c.begin_date + INTERVAL c.duration MONTH) as endcontract,c.* FROM glpi_plugin_anet_epacks,glpi_contracts as c WHERE FK_serveur='" . $serverid . "' AND c.FK_entities=FK_clientderyxeo";

    //print $query3;

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

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

    /*

    print "<pre>";

    print_r($data3);

    print "</pre>";

    */

    $endc = $data3['endcontract'];

    if($endc > mktime()) {

      if($view == "web") {

        header('Location: http://www.abuledu.net/mac/view/partner.php');

        exit;

      }

      else {

        insert_hash_allow_upgrade();

        print $endc . ":PARTNER" . ":" . $data3['name'] . ":" . "Avenant pour ce serveur manquant:$hash";

      }

    }

    else{

      //Le serveur existe dans notre base mais c'est tout

      if($view == "web") {

        header('Location: http://www.abuledu.net/mac/view/waiting.php');

        exit;

      }

      else {

        print "000:WAITING:000:none:$hash";

      }

    }

  }

 }

 else {

   if($view == "web") {

     header('Location: http://www.abuledu.net/mac/view/forbidden.php');

     exit;

   }

   else {

     print "000:FORBIDDEN:000:NOT:$hash";

   }

 }

?>