RyXéo » GLPI

<?php

$debug=0;

//Permet de trier le tableau des postes

function localsort_name($a,$b) {

  if ($a == $b) {

    return 0;

  }

  return ($a['host'] < $b['host']) ? -1 : 1;

}

if($debug) {

  ob_start();

  error_reporting(E_ALL);

 }

 else

   error_reporting(E_NONE);

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

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

include ("ryxeo.php");

$object = array('message' => '',

                'header1' => '',

                'header2' => '');

$send_mail = 0; //flag pour savoir s'il faut envoyer un mail (en bref a toute insertion ou update de base)

$code         = $_POST['code'];

$pass         = $_POST['pass'];

$anetlogin    = $_POST['anetlogin'];

$anetpassword = $_POST['anetpassword'];

$version      = $_POST['version'];

$tab_postes   = unserialize(base64_decode($_POST['tab_postes']));

$tab_server   = unserialize(base64_decode($_POST['tab_server']));

$tab_hdd      = unserialize(base64_decode($_POST['tab_hdd']));

$tab_wifi     = unserialize(base64_decode($_POST['tab_wifi']));

$tab_rvd      = unserialize(base64_decode($_POST['tab_rvd']));

$tab_client   = unserialize(base64_decode($_POST['tab_client']));

usort($tab_postes,localsort_name);

//debug

if($debug) {

  $object['message'] .= "<p>Mode debug</p>";

  $object['message'] .= implode(",",$tab_client);

  $object['message'] .= "<p>DEBUG:: " . ob_get_clean() . "</p>";

  ob_end_clean();

 }

//profil 5 -> ce sont les revendeurs, 3 et 4 c'est admin et super admin

$query = "SELECT gu.*,ge.address,ge.postcode,ge.town FROM glpi_users as gu

LEFT JOIN glpi_users_profiles AS gup ON gup.FK_users=gu.ID

LEFT JOIN glpi_entities_data AS ge ON ge.FK_entities=gu.FK_entities

WHERE gu.email='" . $anetlogin . "' AND password_md5=MD5('" . $anetpassword . "') AND (gup.FK_profiles='5' OR gup.FK_profiles='4' OR gup.FK_profiles='3')

GROUP BY gu.email;";

if($debug)

  $object['message'] .= "<p>query: $query</p>";

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

if(($DB->numrows($result)>0) || $debug) {

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

  $tab_rvd['RVD_ADDRESS'] = trim($data['address']);

  $tab_rvd['RVD_CP']      = trim($data['postcode']);

  $tab_rvd['RVD_CITY']    = trim($data['town']);

  if((trim($pass) != "" && trim($code) != "") || $debug) {

    $query2 = "SELECT * FROM glpi_plugin_anet_epacks

LEFT JOIN glpi_entities AS g ON FK_client=g.ID

WHERE code='$code' AND password='$pass'";

    if($debug) {

      $object['message'] .= "<p>query2: $query2</p>";

    }

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

    if(($DB->numrows($result2)>0) || $debug) {

      //print serialize($object);

      //print_r($_SERVER);

      require_once('lib/odf.php');

      if($version == "1108")

        $odf = new odf("abuledu-recette-1108.odt");

      else

        $odf = new odf("abuledu-recette.odt");

      //1ere page

      setlocale(LC_TIME, "fr_FR.UTF-8");

      $odf->setVars('date', strftime("%A %e %B %Y"));

      $odf->setVars('datecourte', date("d/m/Y"));

      //L'installateur

      $odf->setVars('installateursociete', $tab_rvd['RVD_CODE'], true, 'UTF-8');

      $odf->setVars('installateuradresse', $tab_rvd['RVD_ADDRESS'], true, 'UTF-8');

      $odf->setVars('installateurcp',      $tab_rvd['RVD_CO'], true, 'UTF-8');

      $odf->setVars('installateurville',   $tab_rvd['RVD_CITY'], true, 'UTF-8');

      $odf->setVars('installateuremail',   $tab_rvd['RVD_EMAIL'], true, 'UTF-8');

      $odf->setVars('installateurtel',     $tab_rvd['RVD_PHONE'], true, 'UTF-8');

      //Le client

      $odf->setVars('client',        $tab_client["installation_name"], true, 'UTF-8');

      $odf->setVars('clientadresse', $tab_client["installation_address0"], true, 'UTF-8');

      $odf->setVars('clientcp',      $tab_client["installation_postalcode"], true, 'UTF-8');

      $odf->setVars('clientville',   $tab_client["installation_city"], true, 'UTF-8');

      $odf->setVars('clienttel',     $tab_client["installation_phone"], true, 'UTF-8');

      $odf->setVars('clientmail',    $tab_client["installation_email"], true, 'UTF-8');

      //abuledu.net

      $odf->setVars('anetdip', "TODO");

      $odf->setVars('anetdyn', "a venir");

      //Internet

      $odf->setVars('internetip', $tab_server["externalip"], true, 'UTF-8');

      $odf->setVars('internetfai', $tab_server["fai"], true, 'UTF-8');

      //wifi

      $odf->setVars('wifimarque', $tab_wifi["wifimarque"], true, 'UTF-8');

      $odf->setVars('wifimodele', $tab_wifi["wifimodele"], true, 'UTF-8');

      $odf->setVars('wifiwpa', $tab_wifi["wifiwpa"], true, 'UTF-8');

      //serveur

      $odf->setVars('serveurmarque', $tab_server["vendor"], true, 'UTF-8');

      $odf->setVars('serveurmodele', $tab_server["product"], true, 'UTF-8');

      if(trim($tab_server["serial"] != ""))

        $odf->setVars('serveurserial', "(SERIAL #" . $tab_server["serial"] . ")", true, 'UTF-8');

      //abuladmin

      $odf->setVars('abuladminpass', "TODO", true, 'UTF-8');

      //disque dur

      //    $odf->setVars('srvhddcount', count($tab_hdd));

      $p = $odf->setSegment('srvhdd');

      $nb=1;

      foreach($tab_hdd AS $element) {

        $p->srvhddnum($nb);

        $p->srvhddsize($element["size"]);

        $p->srvhddvendor($element["vendor"]);

        $p->srvhddproduct($element["product"]);

        $p->srvhddserial($element["serial"]);

        $p->merge();

        $nb++;

      }

      $odf->mergeSegment($p);

      //epack

      $odf->setVars('epackcode', $code);

      $odf->setVars('epackpassword', $pass);

      //    $odf->setVars('', "");

      //Les postes + imprimante + wifi (partiels)

      $p = $odf->setSegment('postes');

      $nb=1;

      foreach($tab_postes AS $element) {

        if(ereg("^wifi-",$element['host'])) {

          $odf->setVars('wifiip', $element['ip']);

          $odf->setVars('wifimac', $element['mac']);

        }

        else if(ereg("^imprimante-",$element['host'])){

          $odf->setVars('imprimanteip', $element['ip']);

          $odf->setVars('imprimantemac', $element['mac']);

          //nothing

        }

        else {

          $p->postenum($nb);

          $p->postenom($element['host']);

          $p->postemodele("modele");

          $p->posteip($element['ip']);

          $p->postemac($element['mac']);

          $p->posteadmin("TODO");

          $p->merge();

          $nb++;

        }

      }

      $odf->mergeSegment($p);

      //On créé un fichier local pour archive ...

      $fichier="archives/" . date("Y-m-d") . "-recette-" . $code . ".odt";

      $odf->saveToDisk($fichier);

      //On génère le fichier

      if(! $debug) {

        $object['header1'] = 'Content-type: application/vnd.oasis.opendocument.text';

        $object['header2'] = 'Content-Disposition: attachment; filename="abuledu-recette.odt"';

        $object['message'] = @file_get_contents($fichier,FILE_BINARY);

      }

      $mail_content = "

Bonjour,

le pack $code :: $pass vient d'être utilisé par $anetlogin pour créer un cahier de recettes

Informations brutes récoltées:

";

      foreach ($tab_rvd as $key => $value) {

        $mail_content .= "$key -> $value\n";

      }

      $mail_content .= "\n\n";

      foreach ($tab_client as $key => $value) {

        $mail_content .= "$key -> $value\n";

      }

      $mail_content .= "\n\n";

      foreach ($tab_postes as $key => $value) {

        $mail_content .= "$key -> " . implode(",",$value) . "\n";

      }

      $mail_content .= "\n\n";

      foreach ($tab_server as $key => $value) {

        $mail_content .= "$key -> $value\n";

      }

      $mail_content .= "\n\n";

      foreach ($tab_hdd as $key => $value) {

        $mail_content .= "$key -> " . implode(",",$value) . "\n";

      }

      $mail_content .= "\n\n";

      foreach ($tab_wifi as $key => $value) {

        $mail_content .= "$key -> $value\n";

      }

      $mail_content .= "\n\n";

      $mail_content .= "

--

abuledu.net est un service de RyXéo SARL, société éditrice d'AbulÉdu

";

      ryxeo_mail("anet@ryxeo.com",$mail_content,"contact@ryxeo.com","$code : Cahier de recettes - " . $tab_client["installation_name"] . " " . $tab_client["installation_city"]);

    }

    else {

      $object['message'] .= "<p>Erreur d'ePack 1 ...</p>";

      //print "<p>Erreur d'ePack ...</p>";

    }

  }

  else {

    $object['message'] .= "<p>Erreur d'ePack 2 ...</p>";

    //print "<p>Erreur d'ePack ...</p>";

  }

 }

 else {

   //print "<p>Erreur d'identifiant ou de mot de passe ...</p>";

   $object['message'] .= "<p>Erreur d'identifiant ou de mot de passe ...</p>";

 }

if($debug) {

  print $object['message'];

  $object['message'] .= "<p>DEBUG:: " . ob_get_clean() . "</p>";

  ob_end_clean();

  print $object['message'];

}

print serialize($object);

?>