[Sommaire] [Imprimer]

   1  <?php
   2  /* Copyright (C) 2005 Rodolphe Quiedeville <rodolphe@quiedeville.org>
   3   *
   4   * This program is free software; you can redistribute it and/or modify
   5   * it under the terms of the GNU General Public License as published by
   6   * the Free Software Foundation; either version 2 of the License, or
   7   * (at your option) any later version.
   8   *
   9   * This program is distributed in the hope that it will be useful,
  10   * but WITHOUT ANY WARRANTY; without even the implied warranty of
  11   * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
  12   * GNU General Public License for more details.
  13   *
  14   * You should have received a copy of the GNU General Public License
  15   * along with this program; if not, write to the Free Software
  16   * Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA.
  17   *
  18   * $Id: EnergieCompteur.class.php,v 1.2 2005/07/24 12:12:52 rodolphe Exp $
  19   * $Source: /cvsroot/dolibarr/dolibarr/htdocs/energie/EnergieCompteur.class.php,v $
  20   *
  21   */
  22  
  23  /**
  24     \file       htdocs/energie/EnergieCompteur.class.php
  25     \ingroup    energie
  26     \brief      Fichier des classes de compteur
  27     \version    $Revision: 1.2 $
  28  */
  29  
  30  
  31  /**    
  32     \class      Compteur
  33     \brief      Classe de gestion des compteurs
  34  */
  35  
  36  class EnergieCompteur
  37  {
  38    var $db ;
  39    var $id ;
  40    var $user;
  41  
  42    /**  \brief  Constructeur
  43     */
  44    function EnergieCompteur($DB, $user)
  45    {
  46      $this->db = $DB;
  47      $this->user = $user;
  48  
  49      $this->energies[1] = "Electricité";
  50      $this->energies[2] = "Eau";
  51      $this->energies[3] = "Gaz naturel";
  52  
  53      $this->couleurs[1] = "gray";
  54      $this->couleurs[2] = "blue";
  55      $this->couleurs[3] = "yellow";
  56    }
  57  
  58  
  59    /** 
  60     * Lecture
  61     *
  62     */
  63    function fetch ($id)
  64    {
  65      $sql = "SELECT c.rowid, c.libelle, fk_energie";
  66      $sql .= " FROM ".MAIN_DB_PREFIX."energie_compteur as c";
  67      $sql .= " WHERE c.rowid = ".$id;
  68      
  69      $resql = $this->db->query($sql) ;
  70      
  71      if ( $resql )
  72        {
  73      $obj = $this->db->fetch_object($resql);
  74      
  75      $this->id              = $obj->rowid;
  76      $this->libelle         = $obj->libelle;
  77      $this->energie         = $obj->fk_energie;
  78      $this->db->free();
  79      
  80      return 0;
  81        }
  82      else
  83        {
  84      dolibarr_syslog("");
  85      return -1;
  86        }
  87    }
  88  
  89    /** 
  90     * Lecture
  91     *
  92     */
  93    function Create ($libelle, $energie)
  94    {
  95      $sql  = "INSERT INTO ".MAIN_DB_PREFIX."energie_compteur";
  96      $sql .= " (libelle, datec, fk_user_author, fk_energie, note)";
  97      $sql .= " VALUES (";
  98      $sql .= "'".trim($libelle)."'";
  99      $sql .= ",now()";
 100      $sql .= ",'".$this->user->id."'";
 101      $sql .= ",'".$energie."'";
 102      $sql .= ",'');";
 103  
 104      $resql = $this->db->query($sql) ;
 105  
 106      if ( $resql )
 107        {
 108      $this->id = $this->db->last_insert_id(MAIN_DB_PREFIX."energie_compteur");
 109  
 110      return 0;
 111        }
 112      else
 113        {
 114      dolibarr_syslog("EnergieCompteur::Create Erreur 1");
 115      dolibarr_syslog($this->db->error());
 116      return -1;
 117        }
 118    }
 119  
 120    /** 
 121     * Ajout d'une valeur relevée
 122     *
 123     */
 124    function AjoutReleve ($date_releve, $valeur)
 125    {
 126      $sql  = "INSERT INTO ".MAIN_DB_PREFIX."energie_compteur_releve";
 127      $sql .= " (fk_compteur, date_releve, valeur, datec, fk_user_author)";
 128      $sql .= " VALUES (";
 129      $sql .= "'".$this->id."'";
 130      $sql .= ",'".$this->db->idate($date_releve)."'";
 131      $sql .= ",'".$valeur."'";
 132      $sql .= ",now()";
 133      $sql .= ",'".$this->user->id."');";
 134     
 135      $resql = $this->db->query($sql) ;
 136  
 137      if ( $resql )
 138        {
 139      return 0;
 140        }
 141      else
 142        {
 143      dolibarr_syslog("EnergieCompteur::AjoutReleve Erreur 1");
 144      dolibarr_syslog($this->db->error());
 145      return -1;
 146        }
 147    }
 148    /** 
 149     * Suppression d'une valeur relevée
 150     *
 151     */
 152    function DeleteReleve ($rowid)
 153    {
 154      $sql  = "DELETE FROM ".MAIN_DB_PREFIX."energie_compteur_releve";
 155      $sql .= " WHERE rowid = '".$rowid."';";
 156     
 157      $resql = $this->db->query($sql) ;
 158  
 159      if ( $resql )
 160        {
 161      return 0;
 162        }
 163      else
 164        {
 165      dolibarr_syslog("EnergieCompteur::AjoutReleve Erreur 1");
 166      dolibarr_syslog($this->db->error());
 167      return -1;
 168        }
 169    }
 170    /** 
 171     * Ajout d'une valeur relevée
 172     *
 173     */
 174    function AddGroup ($groupe)
 175    {
 176      $sql  = "INSERT INTO ".MAIN_DB_PREFIX."energie_compteur_groupe";
 177      $sql .= " (fk_energie_compteur, fk_energie_groupe)";
 178      $sql .= " VALUES ('".$this->id."','".$groupe."');";
 179     
 180      $resql = $this->db->query($sql);
 181  
 182      if ( $resql )
 183        {
 184      return 0;
 185        }
 186      else
 187        {
 188      dolibarr_syslog("EnergieCompteur::AddGroup Erreur 1");
 189      dolibarr_syslog($this->db->error());
 190      return -1;
 191        }
 192    }
 193    /** 
 194     * 
 195     *
 196     */
 197    function GroupsAvailable ()
 198    {
 199      $this->groups_available = array();
 200  
 201      $sql = "SELECT g.rowid, g.libelle";
 202      $sql .= " FROM ".MAIN_DB_PREFIX."energie_groupe as g";
 203      
 204      $resql = $this->db->query($sql) ;
 205      
 206      if ( $resql )
 207        {
 208      $num = $this->db->num_rows($resql);
 209      $i = 0;
 210  
 211      while ($i < $num)
 212        {
 213          $obj = $this->db->fetch_object($resql);
 214      
 215          $this->groups_available[$obj->rowid] = $obj->libelle;
 216          $i++;
 217        }
 218      $this->db->free();
 219      
 220      return 0;
 221        }
 222      else
 223        {
 224      dolibarr_syslog("");
 225      return -1;
 226        }
 227    }
 228  }
 229  ?>