RyXéo » GLPI

<?php

/*

   ----------------------------------------------------------------------

   GLPI - Gestionnaire Libre de Parc Informatique

   Copyright (C) 2003-2008 by the INDEPNET Development Team.

   http://indepnet.net/   http://glpi-project.org/

   ----------------------------------------------------------------------

   LICENSE

   This file is part of GLPI.

   GLPI is free software; you can redistribute it and/or modify

   it under the terms of the GNU General Public License as published by

   the Free Software Foundation; either version 2 of the License, or

   (at your option) any later version.

   GLPI is distributed in the hope that it will be useful,

   but WITHOUT ANY WARRANTY; without even the implied warranty of

   MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the

   GNU General Public License for more details.

   You should have received a copy of the GNU General Public License

   along with GLPI; if not, write to the Free Software

   Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA

   ------------------------------------------------------------------------

 */

// ----------------------------------------------------------------------

// Original Author of file: GRISARD Jean Marc & CAILLAUD Xavier

// Purpose of file:

// ----------------------------------------------------------------------

if (!defined('GLPI_ROOT')){

        die("Sorry. You can't access directly to this file");

        }

function plugin_manageentity_checkIfPreferenceExists($user_id)

{

        global $DB;

        $result = $DB->query("SELECT ID FROM glpi_plugin_manageentity_preference WHERE user_id=".$user_id);

        if ($DB->numrows($result) > 0)

                return $DB->result($result,0,"ID");

        else

                return 0;        

}

function plugin_manageentity_addDefaultPreference($user_id)

{

        $input["user_id"]=$user_id;

        $input["show"]=2;

        $pref = new plugin_manageentity_preference;

        return $pref->add($input);

}

function plugin_manageentity_checkPreferenceValue($user_id)

{

        global $DB;

        $result = $DB->query("SELECT * FROM glpi_plugin_manageentity_preference WHERE user_id=".$user_id);

        if ($DB->numrows($result) > 0)

                return $DB->result($result,0,"show");

        else

                return 0;        

}

function plugin_manageentity_addcontracts($eID,$cID){

                $DB = new DB;

                $query="INSERT INTO glpi_plugin_manageentity_contracts (FK_contracts,FK_entity) VALUES ('$eID','$cID');";

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

}

function plugin_manageentity_deletecontracts($ID){

                $DB = new DB;

                $query="DELETE FROM glpi_plugin_manageentity_contracts WHERE ID= '$ID';";

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

}

function plugin_manageentity_adddocuments($eID,$cID){

        $DB = new DB;

        $query="INSERT INTO glpi_plugin_manageentity_documents (FK_documents,FK_entity) VALUES ('$eID','$cID');";

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

}

function plugin_manageentity_deletecontacts($ID){

        $DB = new DB;

        $query="DELETE FROM glpi_plugin_manageentity_contacts WHERE ID= '$ID';";

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

}

function plugin_manageentity_addcontacts($eID,$cID){

        $DB = new DB;

        $query="INSERT INTO glpi_plugin_manageentity_contacts (FK_contacts,FK_entity) VALUES ('$eID','$cID');";

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

}

function plugin_manageentity_deletedocuments($ID){

        $DB = new DB;

        $query="DELETE FROM glpi_plugin_manageentity_documents WHERE ID= '$ID';";

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

}

function plugin_manageentity_createfirstaccess($ID){

        GLOBAL $DB;

        $plugin_manageentity_Profile=new plugin_manageentity_Profile();

        if (!$plugin_manageentity_Profile->GetfromDB($ID)){

                $Profile=new Profile();

                $Profile->GetfromDB($ID);

                $name=$Profile->fields["name"];

                $query ="INSERT INTO `glpi_plugin_manageentity_profiles` ( `ID`, `name` , `interface`, `is_default`, `manageentity`) VALUES ('$ID', '$name','manageentity','0','w');";

                $DB->query($query);

        }

}

function plugin_manageentity_createaccess($ID){

        GLOBAL $DB;

        $Profile=new Profile();

        $Profile->GetfromDB($ID);

        $name=$Profile->fields["name"];

        $query ="INSERT INTO `glpi_plugin_manageentity_profiles` ( `ID`, `name` , `interface`, `is_default`, `manageentity`) VALUES ('$ID', '$name','manageentity','0',NULL);";

        $DB->query($query);

}

//ryxeo

function plugin_manageentity_anetinsertnextupgrade($eID,$text){

  $DB = new DB;

  $query="SELECT ID FROM glpi_plugin_anet_epacks_upgrade WHERE FK_serveur='$eID';";

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

  if($DB->numrows($result)>0)

    $query="UPDATE glpi_plugin_anet_epacks_upgrade SET upgradecmd='$text' WHERE FK_serveur='$eID';";

  else

    $query="INSERT INTO glpi_plugin_anet_epacks_upgrade (FK_serveur,upgradecmd) VALUES ('$eID','$text');";

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

}

?>