fichinterligne.class.php

Go to the documentation of this file.

<?php
/* Copyright (C) 2002-2003 Rodolphe Quiedeville <rodolphe@quiedeville.org>
 * Copyright (C) 2004-2014 Laurent Destailleur  <eldy@users.sourceforge.net>
 * Copyright (C) 2005-2012 Regis Houssin        <regis.houssin@inodbox.com>
 * Copyright (C) 2011-2020 Juanjo Menent        <jmenent@2byte.es>
 * Copyright (C) 2015      Marcos García        <marcosgdf@gmail.com>
 * Copyright (C) 2015-2020 Charlene Benke       <charlie@patas-monkey.com>
 * Copyright (C) 2018      Nicolas ZABOURI      <info@inovea-conseil.com>
 * Copyright (C) 2018-2024  Frédéric France     <frederic.france@free.fr>
 * Copyright (C) 2023-2024  William Mead        <william.mead@manchenumerique.fr>
 * Copyright (C) 2024   MDW         <mdeweerd@users.noreply.github.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/>.
 */
 
require_once DOL_DOCUMENT_ROOT.'/core/class/commonobjectline.class.php';
 
class FichinterLigne extends CommonObjectLine
{
  public $db;
 
  public $error = '';
 
  public $fk_fichinter;
 
  public $desc;
 
  public $date;
  public $datei;
 
  public $duration;
 
  public $rang = 0;
 
  public $tva_tx;
 
  public $subprice;
 
  public $element = 'fichinterdet';
 
  public $table_element = 'fichinterdet';
 
  public $fk_element = 'fk_fichinter';
 
 
 
  public function __construct($db)
  {
    $this->db = $db;
  }
 
  public function fetch($rowid)
  {
    dol_syslog("FichinterLigne::fetch", LOG_DEBUG);
 
    $sql = 'SELECT ft.rowid, ft.fk_fichinter, ft.description, ft.duree, ft.rang, ft.date, ft.extraparams';
    $sql .= ' FROM '.MAIN_DB_PREFIX.'fichinterdet as ft';
    $sql .= ' WHERE ft.rowid = '.((int) $rowid);
 
    $resql = $this->db->query($sql);
    if ($resql) {
      if ($this->db->num_rows($resql)) {
        $objp = $this->db->fetch_object($resql);
        $this->rowid            = $objp->rowid;
        $this->id               = $objp->rowid;
        $this->fk_fichinter     = $objp->fk_fichinter;
        $this->date = $this->db->jdate($objp->date);
        $this->datei = $this->db->jdate($objp->date); // For backward compatibility
        $this->desc             = $objp->description;
        $this->duration         = $objp->duree;
        $this->rang             = $objp->rang;
 
        $this->extraparams = !empty($objp->extraparams) ? (array) json_decode($objp->extraparams, true) : array();
 
        $this->db->free($resql);
 
        $this->fetch_optionals();
 
        return 1;
      }
 
      return 0;
    } else {
      $this->error = $this->db->error().' sql='.$sql;
      return -1;
    }
  }
 
  public function insert($user, $notrigger = 0)
  {
    $error = 0;
 
    dol_syslog("FichinterLigne::insert rang=".$this->rang);
 
    if (empty($this->date) && !empty($this->datei)) { // For backward compatibility
      $this->date = $this->datei;
    }
 
    $this->db->begin();
 
    $rangToUse = $this->rang;
    if ($rangToUse == -1) {
      // Recupere rang max de la ligne d'intervention dans $rangmax
      $sql = 'SELECT max(rang) as max FROM '.MAIN_DB_PREFIX.'fichinterdet';
      $sql .= ' WHERE fk_fichinter = '.((int) $this->fk_fichinter);
      $resql = $this->db->query($sql);
      if ($resql) {
        $obj = $this->db->fetch_object($resql);
        $rangToUse = $obj->max + 1;
      } else {
        dol_print_error($this->db);
        $this->db->rollback();
        return -1;
      }
    }
 
    // Insertion dans base de la ligne
    $sql = 'INSERT INTO '.MAIN_DB_PREFIX.'fichinterdet';
    $sql .= ' (fk_fichinter, description, date, duree, rang)';
    $sql .= " VALUES (".((int) $this->fk_fichinter).",";
    $sql .= " '".$this->db->escape($this->desc)."',";
    $sql .= " '".$this->db->idate($this->date)."',";
    $sql .= " ".((int) $this->duration).",";
    $sql .= ' '.((int) $rangToUse);
    $sql .= ')';
 
    dol_syslog("FichinterLigne::insert", LOG_DEBUG);
    $resql = $this->db->query($sql);
    if ($resql) {
      $this->id = $this->db->last_insert_id(MAIN_DB_PREFIX.'fichinterdet');
      $this->rowid = $this->id;
 
      if (!$error) {
        $result = $this->insertExtraFields();
        if ($result < 0) {
          $error++;
        }
      }
 
 
      $result = $this->update_total();
 
      if ($result > 0) {
        $this->rang = $rangToUse;
 
        if (!$notrigger) {
          // Call trigger
          $result = $this->call_trigger('LINEFICHINTER_CREATE', $user);
          if ($result < 0) {
            $error++;
          }
          // End call triggers
        }
      }
 
      if (!$error) {
        $this->db->commit();
        return $result;
      } else {
        $this->db->rollback();
        return -1;
      }
    } else {
      $this->error = $this->db->error()." sql=".$sql;
      $this->db->rollback();
      return -1;
    }
  }
 
 
  public function update($user, $notrigger = 0)
  {
    $error = 0;
 
    if (empty($this->date) && !empty($this->datei)) { // For backward compatibility
      $this->date = $this->datei;
    }
 
    $this->db->begin();
 
    // Mise a jour ligne en base
    $sql = "UPDATE ".MAIN_DB_PREFIX."fichinterdet SET";
    $sql .= " description = '".$this->db->escape($this->desc)."',";
    $sql .= " date = '".$this->db->idate($this->date)."',";
    $sql .= " duree = ".((int) $this->duration).",";
    $sql .= " rang = ".((int) $this->rang);
    $sql .= " WHERE rowid = ".((int) $this->id);
 
    dol_syslog("FichinterLigne::update", LOG_DEBUG);
    $resql = $this->db->query($sql);
    if ($resql) {
      if (!$error) {
        $result = $this->insertExtraFields();
        if ($result < 0) {
          $error++;
        }
      }
 
      $result = $this->update_total();
      if ($result > 0) {
        if (!$notrigger) {
          // Call trigger
          $result = $this->call_trigger('LINEFICHINTER_MODIFY', $user);
          if ($result < 0) {
            $error++;
          }
          // End call triggers
        }
      }
 
      if (!$error) {
        $this->db->commit();
        return $result;
      } else {
        $this->error = $this->db->lasterror();
        $this->db->rollback();
        return -1;
      }
    } else {
      $this->error = $this->db->lasterror();
      $this->db->rollback();
      return -1;
    }
  }
 
  // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps
  public function update_total()
  {
    // phpcs:enable
    global $conf;
 
    $this->db->begin();
 
    $sql = "SELECT SUM(duree) as total_duration, min(date) as dateo, max(date) as datee ";
    $sql .= " FROM ".MAIN_DB_PREFIX."fichinterdet";
    $sql .= " WHERE fk_fichinter=".((int) $this->fk_fichinter);
 
    dol_syslog("FichinterLigne::update_total", LOG_DEBUG);
    $resql = $this->db->query($sql);
    if ($resql) {
      $obj = $this->db->fetch_object($resql);
      $total_duration = 0;
      if (!empty($obj->total_duration)) {
        $total_duration = $obj->total_duration;
      }
 
      $sql = "UPDATE ".MAIN_DB_PREFIX."fichinter";
      $sql .= " SET duree = ".((int) $total_duration);
      $sql .= " , dateo = ".(!empty($obj->dateo) ? "'".$this->db->escape($obj->dateo)."'" : "null");
      $sql .= " , datee = ".(!empty($obj->datee) ? "'".$this->db->escape($obj->datee)."'" : "null");
      $sql .= " WHERE rowid = ".((int) $this->fk_fichinter);
 
      dol_syslog("FichinterLigne::update_total", LOG_DEBUG);
      $resql = $this->db->query($sql);
      if ($resql) {
        $this->db->commit();
        return 1;
      } else {
        $this->error = $this->db->error();
        $this->db->rollback();
        return -2;
      }
    } else {
      $this->error = $this->db->error();
      $this->db->rollback();
      return -1;
    }
  }
 
  public function deleteLine($user, $notrigger = 0)
  {
    $error = 0;
 
    dol_syslog(get_class($this)."::deleteline lineid=".$this->id);
 
    $this->db->begin();
 
    $result = $this->deleteExtraFields();
    if ($result < 0) {
      $error++;
      $this->db->rollback();
      return -1;
    }
 
    $sql = "DELETE FROM ".MAIN_DB_PREFIX."fichinterdet WHERE rowid = ".((int) $this->id);
    $resql = $this->db->query($sql);
 
    if ($resql) {
      $result = $this->update_total();
      if ($result > 0) {
        if (!$notrigger) {
          // Call trigger
          $result = $this->call_trigger('LINEFICHINTER_DELETE', $user);
          if ($result < 0) {
            $error++;
            $this->db->rollback();
            return -1;
          }
          // End call triggers
        }
 
        $this->db->commit();
        return $result;
      } else {
        $this->db->rollback();
        return -1;
      }
    } else {
      $this->error = $this->db->error()." sql=".$sql;
      $this->db->rollback();
      return -1;
    }
  }
}