accountancysystem.class.php

Go to the documentation of this file.

<?php
/* Copyright (C) 2013-2014  Olivier Geffroy         <jeff@jeffinfo.com>
 * Copyright (C) 2013-2014  Alexandre Spangaro      <aspangaro@open-dsi.fr>
 * Copyright (C) 2013-2014  Florian Henry           <florian.henry@open-concept.pro>
 * Copyright (C) 2023-2024  Frédéric France         <frederic.france@free.fr>
 * Copyright (C) 2024       Alexandre Janniaux      <alexandre.janniaux@gmail.com>
 *
 * This program 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 3 of the License, or
 * (at your option) any later version.
 *
 * This program 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 this program. If not, see <https://www.gnu.org/licenses/>.
 */
 
class AccountancySystem extends CommonObject
{
  public $db;
 
  public $error = '';
 
  public $errors = array();
 
  public $id;
 
  public $rowid;
 
  public $pcg_version;
 
  public $ref;
 
  public $active;
 
  public $label;
 
  public function __construct($db)
  {
    $this->db = $db;
  }
 
 
  public function fetch($rowid = 0, $ref = '')
  {
    global $conf;
 
    if ($rowid > 0 || $ref) {
      $sql  = "SELECT a.rowid, a.pcg_version, a.label, a.active";
      $sql .= " FROM ".MAIN_DB_PREFIX."accounting_system as a";
      $sql .= " WHERE";
      if ($rowid) {
        $sql .= " a.rowid = ".((int) $rowid);
      } elseif ($ref) {
        $sql .= " a.pcg_version = '".$this->db->escape($ref)."'";
      }
 
      dol_syslog(get_class($this)."::fetch", LOG_DEBUG);
      $result = $this->db->query($sql);
      if ($result) {
        $obj = $this->db->fetch_object($result);
 
        if ($obj) {
          $this->id = $obj->rowid;
          $this->rowid = $obj->rowid;
          $this->pcg_version = $obj->pcg_version;
          $this->ref = $obj->pcg_version;
          $this->label = $obj->label;
          $this->active = $obj->active;
 
          return $this->id;
        } else {
          return 0;
        }
      } else {
        $this->error = "Error ".$this->db->lasterror();
        $this->errors[] = "Error ".$this->db->lasterror();
      }
    }
    return -1;
  }
 
 
  public function create($user)
  {
    $now = dol_now();
 
    $sql = "INSERT INTO ".MAIN_DB_PREFIX."accounting_system";
    $sql .= " (date_creation, fk_user_author, label, pcg_version, active)";
    $sql .= " VALUES ('"
      . $this->db->idate($now)                    ."',"
      . ((int) $user->id)                         .",'"
      . $this->db->escape($this->label)           ."','"
      . $this->db->escape($this->pcg_version)     ."',"
      . ((int) $this->active)                      .")";
 
    dol_syslog(get_class($this)."::create", LOG_DEBUG);
    $resql = $this->db->query($sql);
    if ($resql) {
      $id = $this->db->last_insert_id(MAIN_DB_PREFIX."accounting_system");
 
      if ($id > 0) {
        $this->id = $id;
        $this->rowid = $id;
        $result = $this->rowid;
      } else {
        $result = - 2;
        $this->error = "AccountancySystem::Create Error $result: " . $this->db->lasterror();
        dol_syslog($this->error, LOG_ERR);
      }
    } else {
      $result = - 1;
      $this->error = "AccountancySystem::Create Error $result: " . $this->db->lasterror();
      dol_syslog($this->error, LOG_ERR);
    }
 
    return $result;
  }
}