asset.class.php

Go to the documentation of this file.

<?php
/* Copyright (C) 2017   Laurent Destailleur   <eldy@users.sourceforge.net>
 * Copyright (C) 2018-2025  Alexandre Spangaro    <alexandre@inovea-conseil.com>
 * Copyright (C) 2024-2026  Frédéric France     <frederic.france@free.fr>
 * Copyright (C) 2024-2026  MDW           <mdeweerd@users.noreply.github.com>
 * Copyright (C) 2024   Jose MARTINEZ     <jose.martinez@pichinov.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/commonobject.class.php';
require_once DOL_DOCUMENT_ROOT.'/core/lib/asset.lib.php';
 
class Asset extends CommonObject
{
  public $module = 'asset';
 
  public $element = 'asset';
 
  public $table_element = 'asset';
 
  public $picto = 'asset';
 
  public $fk_element = 'fk_asset';
 
  protected $childtablesoncascade = array(
    '@AssetAccountancyCodes:/asset/class/assetaccountancycodes.class.php:fk_asset',
    '@AssetAccountancyCodesFiscal:/asset/class/assetaccountancycodesfiscal.class.php:fk_asset'
  );
 
 
  const STATUS_DRAFT = 0;   // Draft
  const STATUS_VALIDATED = 1;   // In progress
  const STATUS_DISPOSED = 9;  // Disposed
 
  public $fields = array(
    'rowid' => array('type' => 'integer', 'label' => 'TechnicalID', 'enabled' => 1, 'position' => 1, 'notnull' => 1, 'visible' => 0, 'noteditable' => 1, 'index' => 1, 'css' => 'left', 'comment' => "Id"),
    'entity' => array('type' => 'integer', 'label' => 'Entity', 'enabled' => 1, 'visible' => 0, 'notnull' => 1, 'default' => '1', 'index' => 1, 'position' => 5),
    'ref' => array('type' => 'varchar(128)', 'label' => 'Ref', 'enabled' => 1, 'position' => 20, 'notnull' => 1, 'visible' => 4, 'noteditable' => 0, 'default' => '(PROV)', 'index' => 1, 'searchall' => 1, 'showoncombobox' => 1, 'validate' => 1, 'comment' => "Reference of object", "css" => "maxwidth150"),
    'label' => array('type' => 'varchar(255)', 'label' => 'Label', 'enabled' => 1, 'position' => 30, 'notnull' => 1, 'visible' => 1, 'searchall' => 1, 'csslist' => 'tdoverflowmax125', 'css' => 'minwidth300', 'cssview' => 'wordbreak', 'showoncombobox' => 2, 'validate' => 1,),
    'fk_asset_model' => array('type' => 'integer:AssetModel:asset/class/assetmodel.class.php:1:((status:=:1) and (entity:IN:__SHARED_ENTITIES__))', 'label' => 'AssetModel', 'enabled' => 1, 'position' => 40, 'notnull' => 0, 'visible' => 1, 'index' => 1, 'validate' => 1, 'csslist' => 'tdoverflowmax75', 'css' => 'maxwidth300'),
    'qty' => array('type' => 'real', 'label' => 'Qty', 'enabled' => 1, 'position' => 50, 'notnull' => 1, 'visible' => 0, 'default' => '1', 'isameasure' => 1, 'css' => 'maxwidth75imp', 'validate' => 1,),
    'acquisition_type' => array('type' => 'smallint', 'label' => 'AssetAcquisitionType', 'enabled' => 1, 'position' => 60, 'notnull' => 1, 'visible' => 1, 'arrayofkeyval' => array(0 => 'AssetAcquisitionTypeNew', 1 => 'AssetAcquisitionTypeOccasion'), 'validate' => 1, 'csslist' => 'tdoverflowmax75'),
    'asset_type' => array('type' => 'smallint', 'label' => 'AssetType', 'enabled' => 1, 'position' => 70, 'notnull' => 1, 'visible' => 1, 'arrayofkeyval' => array(0 => 'AssetTypeIntangible', 1 => 'AssetTypeTangible', 2 => 'AssetTypeInProgress', 3 => 'AssetTypeFinancial'), 'validate' => 1, 'csslist' => 'tdoverflowmax75'),
    'not_depreciated' => array('type' => 'boolean', 'label' => 'AssetNotDepreciated', 'enabled' => 1, 'position' => 80, 'notnull' => 0, 'default' => '0', 'visible' => 1, 'validate' => 1, 'csslist' => 'maxwidth50 tdoverflowmax50', 'css' => 'maxwidth50imp'),
    'date_acquisition' => array('type' => 'date', 'label' => 'AssetDateAcquisition', 'enabled' => 1, 'position' => 90, 'notnull' => 1, 'visible' => 1,),
    'date_start' => array('type' => 'date', 'label' => 'AssetDateStart', 'enabled' => 1, 'position' => 100, 'notnull' => 0, 'visible' => -1,),
    'acquisition_value_ht' => array('type' => 'price', 'label' => 'AssetAcquisitionValueHT', 'enabled' => 1, 'position' => 110, 'notnull' => 1, 'visible' => 1, 'isameasure' => 1, 'validate' => 1,),
    'recovered_vat' => array('type' => 'price', 'label' => 'AssetRecoveredVAT', 'enabled' => 1, 'position' => 120, 'notnull' => 0, 'visible' => 1, 'isameasure' => 1, 'validate' => 1,),
    'reversal_date' => array('type' => 'date', 'label' => 'AssetReversalDate', 'enabled' => 1, 'position' => 130, 'notnull' => 0, 'visible' => 1,),
    'reversal_amount_ht' => array('type' => 'price', 'label' => 'AssetReversalAmountHT', 'enabled' => 1, 'position' => 140, 'notnull' => 0, 'visible' => 1, 'isameasure' => 1, 'validate' => 1, 'csslist' => 'maxwidth50'),
    'disposal_date' => array('type' => 'date', 'label' => 'AssetDisposalDate', 'enabled' => 1, 'position' => 200, 'notnull' => 0, 'visible' => -2,),
    'disposal_amount_ht' => array('type' => 'price', 'label' => 'AssetDisposalAmount', 'enabled' => 1, 'position' => 210, 'notnull' => 0, 'visible' => -2, 'default' => '0', 'isameasure' => 1, 'validate' => 1,),
    'fk_disposal_type' => array('type' => 'sellist:c_asset_disposal_type:label:rowid::active=1', 'label' => 'AssetDisposalType', 'enabled' => 1, 'position' => 220, 'notnull' => 0, 'visible' => -2, 'index' => 1, 'validate' => 1,),
    'disposal_depreciated' => array('type' => 'boolean', 'label' => 'AssetDisposalDepreciated', 'enabled' => 1, 'position' => 230, 'notnull' => 0, 'default' => '0', 'visible' => -2, 'validate' => 1,),
    'disposal_subject_to_vat' => array('type' => 'boolean', 'label' => 'AssetDisposalSubjectToVat', 'enabled' => 1, 'position' => 240, 'notnull' => 0, 'default' => '0', 'visible' => -2, 'validate' => 1,),
    'note_public' => array('type' => 'html', 'label' => 'NotePublic', 'enabled' => 1, 'position' => 300, 'notnull' => 0, 'visible' => 0, 'validate' => 1,),
    'note_private' => array('type' => 'html', 'label' => 'NotePrivate', 'enabled' => 1, 'position' => 301, 'notnull' => 0, 'visible' => 0, 'validate' => 1,),
    'date_creation' => array('type' => 'datetime', 'label' => 'DateCreation', 'enabled' => 1, 'position' => 500, 'notnull' => 1, 'visible' => -2,),
    'tms' => array('type' => 'timestamp', 'label' => 'DateModification', 'enabled' => 1, 'position' => 501, 'notnull' => 0, 'visible' => -2,),
    'date_valid' => array('type' => 'datetime', 'label' => 'DateValidation', 'enabled' => 1, 'visible' => -2, 'position' => 502, 'notnull' => 0,),
    'fk_user_creat' => array('type' => 'integer:User:user/class/user.class.php', 'label' => 'UserAuthor', 'enabled' => 1, 'position' => 510, 'notnull' => 1, 'visible' => -2, 'foreignkey' => 'user.rowid',),
    'fk_user_modif' => array('type' => 'integer:User:user/class/user.class.php', 'label' => 'UserModif', 'enabled' => 1, 'position' => 511, 'notnull' => -1, 'visible' => -2,),
    'fk_user_valid' => array('type' => 'integer:User:user/class/user.class.php', 'label' => 'UserValidation', 'picto' => 'user', 'enabled' => 1, 'visible' => -2, 'position' => 512, 'notnull' => 0, 'csslist' => 'tdoverflowmax100'),
    'last_main_doc' => array('type' => 'varchar(255)', 'label' => 'LastMainDoc', 'enabled' => 1, 'position' => 600, 'notnull' => 0, 'visible' => 0,),
    'import_key' => array('type' => 'varchar(14)', 'label' => 'ImportId', 'enabled' => 1, 'position' => 1000, 'notnull' => -1, 'visible' => -2,),
    'model_pdf' => array('type' => 'varchar(255)', 'label' => 'Model pdf', 'enabled' => 1, 'position' => 1010, 'notnull' => -1, 'visible' => 0,),
    'status' => array('type' => 'smallint', 'label' => 'Status', 'enabled' => 1, 'position' => 1000, 'notnull' => 1, 'default' => '0', 'visible' => 2, 'index' => 1, 'arrayofkeyval' => array(0 => 'Draft', 1 => 'Validated', 9 => 'Canceled'), 'validate' => 1,),
  );
 
  public $rowid;
  public $ref;
  public $label;
  public $fk_asset_model;
  public $reversal_amount_ht;
  public $acquisition_value_ht;
  public $recovered_vat;
  public $reversal_date;
  public $date_acquisition;
  public $date_start;
  public $qty;
  public $acquisition_type;
  public $asset_type;
  public $not_depreciated;
  public $disposal_date;
  public $disposal_amount_ht;
  public $fk_disposal_type;
  public $disposal_depreciated;
  public $disposal_subject_to_vat;
  public $supplier_invoice_id;
  public $note_public;
  public $note_private;
  public $date_valid;
  public $fk_user_creat;
  public $fk_user_modif;
  public $fk_user_valid;
  public $last_main_doc;
 
  public $import_key;
  public $model_pdf;
 
  public $status;
 
  public $asset_depreciation_options;
 
  public $asset_accountancy_codes;
 
  public $depreciation_lines = array();
 
 
  public function __construct(DoliDB $db)
  {
    global $langs;
 
    $this->db = $db;
 
    $this->ismultientitymanaged = 1;
    $this->isextrafieldmanaged = 1;
 
    if (!getDolGlobalString('MAIN_SHOW_TECHNICAL_ID') && isset($this->fields['rowid'])) {
      $this->fields['rowid']['visible'] = 0;
    }
    if (!isModEnabled('multicompany') && isset($this->fields['entity'])) {
      $this->fields['entity']['enabled'] = 0;
    }
 
    // Unset fields that are disabled
    foreach ($this->fields as $key => $val) {
      if (isset($val['enabled']) && empty($val['enabled'])) {
        unset($this->fields[$key]);
      }
    }
 
    // Translate some data of arrayofkeyval
    if (is_object($langs)) {
      foreach ($this->fields as $key => $val) {
        if (!empty($val['arrayofkeyval']) && is_array($val['arrayofkeyval'])) {
          foreach ($val['arrayofkeyval'] as $key2 => $val2) {
            $this->fields[$key]['arrayofkeyval'][$key2] = $langs->trans($val2);
          }
        }
      }
    }
  }
 
  public function create(User $user, $notrigger = 0)
  {
    if (!isset($this->date_start) || $this->date_start === "") {
      $this->date_start = $this->date_acquisition;
    }
 
    $this->db->begin();
 
    $result = $result_create = $this->createCommon($user, $notrigger);
    if ($result > 0 && $this->fk_asset_model > 0) {
      $result = $this->setDataFromAssetModel($user, $notrigger);
    }
    if ($result > 0) {
      if ($this->supplier_invoice_id > 0) {
        $this->add_object_linked('invoice_supplier', $this->supplier_invoice_id);
      }
    }
 
    if ($result < 0) {
      $this->db->rollback();
    } else {
      $this->db->commit();
    }
 
    return $result > 0 ? $result_create : $result;
  }
 
  public function createFromClone(User $user, $fromid)
  {
    //global $langs, $extrafields;
    //$error = 0;
 
    dol_syslog(__METHOD__, LOG_DEBUG);
 
    //      $object = new self($this->db);
    //
    //      $this->db->begin();
    //
    //      // Load source object
    //      $result = $object->fetchCommon($fromid);
    //
    //
    //      // Reset some properties
    //      unset($object->id);
    //      unset($object->fk_user_creat);
    //      unset($object->import_key);
    //
    //      // Clear fields
    //      if (property_exists($object, 'ref')) {
    //          $object->ref = empty($this->fields['ref']['default']) ? "Copy_Of_".$object->ref : $this->fields['ref']['default'];
    //      }
    //      if (property_exists($object, 'label')) {
    //          $object->label = empty($this->fields['label']['default']) ? $langs->trans("CopyOf")." ".$object->label : $this->fields['label']['default'];
    //      }
    //      if (property_exists($object, 'status')) {
    //          $object->status = self::STATUS_DRAFT;
    //      }
    //      if (property_exists($object, 'date_creation')) {
    //          $object->date_creation = dol_now();
    //      }
    //      if (property_exists($object, 'date_modification')) {
    //          $object->date_modification = null;
    //      }
    //      // ...
    //      // Clear extrafields that are unique
    //      if (is_array($object->array_options) && count($object->array_options) > 0) {
    //          $extrafields->fetch_name_optionals_label($this->table_element);
    //          foreach ($object->array_options as $key => $option) {
    //              $shortkey = preg_replace('/options_/', '', $key);
    //              if (!empty($extrafields->attributes[$this->table_element]['unique'][$shortkey])) {
    //                  //var_dump($key); var_dump($clonedObj->array_options[$key]); exit;
    //                  unset($object->array_options[$key]);
    //              }
    //          }
    //      }
    //
    //      // Create clone
    //      $object->context['createfromclone'] = 'createfromclone';
    //      $result = $object->createCommon($user);
    //      if ($result < 0) {
    //          $error++;
    //          $this->error = $object->error;
    //          $this->errors = $object->errors;
    //      }
    //
    //      if (!$error) {
    //          // copy internal contacts
    //          if ($this->copy_linked_contact($object, 'internal') < 0) {
    //              $error++;
    //          }
    //      }
    //
    //      if (!$error) {
    //          // copy external contacts if same company
    //          if (property_exists($this, 'fk_soc') && $this->fk_soc == $object->socid) {
    //              if ($this->copy_linked_contact($object, 'external') < 0) {
    //                  $error++;
    //              }
    //          }
    //      }
    //
    //      unset($object->context['createfromclone']);
    //
    //      // End
    //      if (!$error) {
    //          $this->db->commit();
    //          return $object;
    //      } else {
    //          $this->db->rollback();
    //          return -1;
    //      }
 
    return -1;
  }
 
  public function fetch($id, $ref = null)
  {
    $result = $this->fetchCommon($id, $ref);
    if ($result > 0) {
      $res = $this->hasDepreciationLinesInBookkeeping();
      if ($res < 0) {
        return -1;
      } elseif ($res > 0) {
        $this->fields['date_acquisition']['noteditable'] = 1;
        $this->fields['date_start']['noteditable'] = 1;
        $this->fields['acquisition_value_ht']['noteditable'] = 1;
        $this->fields['recovered_vat']['noteditable'] = 1;
        $this->fields['reversal_date']['noteditable'] = 1;
        $this->fields['reversal_amount_ht']['noteditable'] = 1;
      }
    }
 
    return $result;
  }
 
 
  public function fetchAll($sortorder = '', $sortfield = '', $limit = 0, $offset = 0, $filter = '', $filtermode = 'AND')
  {
    dol_syslog(__METHOD__, LOG_DEBUG);
 
    $records = array();
 
    $sql = "SELECT ";
    $sql .= $this->getFieldList('t');
    $sql .= " FROM ".MAIN_DB_PREFIX.$this->table_element." as t";
    if (isset($this->ismultientitymanaged) && $this->ismultientitymanaged == 1) {
      $sql .= " WHERE t.entity IN (".getEntity($this->element).")";
    } else {
      $sql .= " WHERE 1 = 1";
    }
 
    // Manage filter
    $errormessage = '';
    $sql .= forgeSQLFromUniversalSearchCriteria($filter, $errormessage);
    if ($errormessage) {
      $this->errors[] = $errormessage;
      dol_syslog(__METHOD__.' '.implode(',', $this->errors), LOG_ERR);
 
      return -1;
    }
 
    if (!empty($sortfield)) {
      $sql .= $this->db->order($sortfield, $sortorder);
    }
    if (!empty($limit)) {
      $sql .= $this->db->plimit($limit, $offset);
    }
 
    $resql = $this->db->query($sql);
    if ($resql) {
      $num = $this->db->num_rows($resql);
      $i = 0;
      while ($i < ($limit ? min($limit, $num) : $num)) {
        $obj = $this->db->fetch_object($resql);
 
        $record = new self($this->db);
        $record->setVarsFromFetchObj($obj);
 
        $records[$record->id] = $record;
 
        $i++;
      }
      $this->db->free($resql);
 
      return $records;
    } else {
      $this->errors[] = 'Error '.$this->db->lasterror();
      dol_syslog(__METHOD__.' '.implode(',', $this->errors), LOG_ERR);
 
      return -1;
    }
  }
 
  public function update(User $user, $notrigger = 0)
  {
    if (!isset($this->date_start) || $this->date_start === "") {
      $this->date_start = $this->date_acquisition;
    }
 
    $this->db->begin();
 
    $result = $this->updateCommon($user, $notrigger);
    if ($result > 0 && $this->fk_asset_model > 0 && $this->fk_asset_model != $this->oldcopy->fk_asset_model) {
      $result = $this->setDataFromAssetModel($user, $notrigger);
    }
    if ($result > 0 && is_object($this->oldcopy) && (
      $this->date_start != $this->oldcopy->date_start ||
      $this->acquisition_value_ht != $this->oldcopy->acquisition_value_ht ||
      $this->reversal_date != $this->oldcopy->reversal_date ||
      $this->reversal_amount_ht != $this->oldcopy->reversal_amount_ht ||
      ($this->fk_asset_model > 0 && $this->fk_asset_model != $this->oldcopy->fk_asset_model)
    )) {
      $result = $this->calculationDepreciation();
    }
 
    if ($result < 0) {
      $this->db->rollback();
    } else {
      $this->db->commit();
    }
 
    return $result;
  }
 
  public function delete(User $user, $notrigger = 0)
  {
    $sql = 'DELETE FROM '.MAIN_DB_PREFIX.'asset_depreciation_codes_economic WHERE fk_asset = '.((int) $this->id);
    $this->db->query($sql);
 
    $sql = 'DELETE FROM '.MAIN_DB_PREFIX.'asset_depreciation_codes_fiscal WHERE fk_asset = '.((int) $this->id);
    $this->db->query($sql);
 
    $sql = 'DELETE FROM '.MAIN_DB_PREFIX.'asset_depreciation_options_fiscal WHERE fk_asset = '.((int) $this->id);
    $this->db->query($sql);
 
    $sql = 'DELETE FROM '.MAIN_DB_PREFIX.'asset_depreciation_options_economic WHERE fk_asset = '.((int) $this->id);
    $this->db->query($sql);
 
    $sql = 'DELETE FROM '.MAIN_DB_PREFIX.'asset_depreciation WHERE fk_asset = '.((int) $this->id);
    $this->db->query($sql);
 
    return $this->deleteCommon($user, $notrigger);
    //return $this->deleteCommon($user, $notrigger, 1);
  }
 
  public function setDataFromAssetModel(User $user, $notrigger = 0)
  {
    global $langs;
    $langs->load('assets');
 
    // Clean parameters
    $this->id = $this->id > 0 ? $this->id : 0;
    $this->fk_asset_model = $this->fk_asset_model > 0 ? $this->fk_asset_model : 0;
 
    // Check parameters
    $error = 0;
    if (empty($this->id)) {
      $this->errors[] = $langs->trans("ErrorFieldRequired", $langs->transnoentitiesnoconv("Asset") . ' (' . $langs->transnoentitiesnoconv("TechnicalID") . ')');
      $error++;
    }
    if (empty($this->fk_asset_model)) {
      $this->errors[] = $langs->trans("ErrorFieldRequired", $langs->transnoentitiesnoconv("AssetModel") . ' (' . $langs->transnoentitiesnoconv("TechnicalID") . ')');
      $error++;
    }
    if ($error) {
      return -1;
    }
 
    $this->db->begin();
 
    // Get depreciation options
    //---------------------------
    require_once DOL_DOCUMENT_ROOT . '/asset/class/assetdepreciationoptions.class.php';
    $options_model = new AssetDepreciationOptions($this->db);
    $result = $options_model->fetchDeprecationOptions(0, $this->fk_asset_model);
    if ($result < 0) {
      $this->error = $options_model->error;
      $this->errors = $options_model->errors;
      $error++;
    } elseif ($result > 0) {
      $options = new AssetDepreciationOptions($this->db);
      $result = $options->fetchDeprecationOptions($this->id);
      if ($result < 0) {
        $this->error = $options->error;
        $this->errors = $options->errors;
        $error++;
      }
 
      if (!$error) {
        foreach ($options_model->deprecation_options as $mode_key => $fields) {
          foreach ($fields as $field_key => $value) {
            $options->deprecation_options[$mode_key][$field_key] = $value;
          }
          // 'amount_base_depreciation_ht' only exists on the asset (not on the model, see 'only_on_asset'),
          // so it is never part of $fields above and must be computed from the asset itself, otherwise
          // it stays at 0 and all depreciation lines are calculated on a zero base.
          if (!array_key_exists('amount_base_depreciation_ht', $options->deprecation_options[$mode_key])) {
            $options->deprecation_options[$mode_key]['amount_base_depreciation_ht'] = $this->reversal_amount_ht > 0 ? $this->reversal_amount_ht : $this->acquisition_value_ht;
          }
        }
 
        $result = $options->updateDeprecationOptions($user, $this->id, 0, $notrigger);
        if ($result < 0) {
          $this->error = $options->error;
          $this->errors = $options->errors;
          $error++;
        }
      }
    }
 
    // Get accountancy codes
    //---------------------------
    if (!$error) {
      require_once DOL_DOCUMENT_ROOT . '/asset/class/assetaccountancycodes.class.php';
      $accountancy_codes_model = new AssetAccountancyCodes($this->db);
      $result = $accountancy_codes_model->fetchAccountancyCodes(0, $this->fk_asset_model);
      if ($result < 0) {
        $this->error = $accountancy_codes_model->error;
        $this->errors = $accountancy_codes_model->errors;
        $error++;
      } elseif ($result > 0) {
        $accountancy_codes = new AssetAccountancyCodes($this->db);
        $result = $accountancy_codes->fetchAccountancyCodes($this->id);
        if ($result < 0) {
          $this->error = $accountancy_codes->error;
          $this->errors = $accountancy_codes->errors;
          $error++;
        }
 
        if (!$error) {
          foreach ($accountancy_codes_model->accountancy_codes as $mode_key => $fields) {
            foreach ($fields as $field_key => $value) {
              $accountancy_codes->accountancy_codes[$mode_key][$field_key] = $value;
            }
          }
 
          $result = $accountancy_codes->updateAccountancyCodes($user, $this->id, 0, $notrigger);
          if ($result < 0) {
            $this->error = $accountancy_codes->error;
            $this->errors = $accountancy_codes->errors;
            $error++;
          }
        }
      }
    }
 
    if ($error) {
      $this->db->rollback();
      return -1;
    } else {
      $this->db->commit();
      return 1;
    }
  }
 
  public function fetchDepreciationLines()
  {
    global $langs;
    $langs->load('assets');
    $this->depreciation_lines = array();
 
    // Clean parameters
    $this->id = $this->id > 0 ? $this->id : 0;
 
    // Check parameters
    $error = 0;
    if (empty($this->id)) {
      $this->errors[] = $langs->trans("ErrorFieldRequired", $langs->transnoentitiesnoconv("Asset") . ' (' . $langs->transnoentitiesnoconv("TechnicalID") . ')');
      $error++;
    }
    if ($error) {
      return -1;
    }
 
    $sql = "SELECT ad.rowid, ad.depreciation_mode, ad.ref, ad.depreciation_date, ad.depreciation_ht, ad.cumulative_depreciation_ht,";
    if (isModEnabled('accounting')) {
      $sql .= " " . $this->db->ifsql('EXISTS (SELECT fk_docdet FROM ' . MAIN_DB_PREFIX . 'accounting_bookkeeping as ab WHERE ab.doc_type = \'asset\' AND ab.fk_docdet = ad.rowid)', '1', '0') . " AS bookkeeping";
    } else {
      $sql .= " 0 AS bookkeeping";
    }
    $sql .= " FROM " . MAIN_DB_PREFIX . "asset_depreciation AS ad";
    $sql .= " WHERE ad.fk_asset = " . (int) $this->id;
    $sql .= " ORDER BY ad.depreciation_date ASC";
 
    $resql = $this->db->query($sql);
    if (!$resql) {
      $this->errors[] = $langs->trans('AssetErrorFetchDepreciationLines') . ': ' . $this->db->lasterror();
      return -1;
    }
 
    while ($obj = $this->db->fetch_object($resql)) {
      if (!isset($this->depreciation_lines[$obj->depreciation_mode])) {
        $this->depreciation_lines[$obj->depreciation_mode] = array();
      }
      $this->depreciation_lines[$obj->depreciation_mode][] = array(
        'id' => $obj->rowid,
        'ref' => $obj->ref,
        'depreciation_date' => $this->db->jdate($obj->depreciation_date),
        'depreciation_ht' => $obj->depreciation_ht,
        'cumulative_depreciation_ht' => $obj->cumulative_depreciation_ht,
        'bookkeeping' => $obj->bookkeeping,
      );
    }
 
    return 1;
  }
 
  public function hasDepreciationLinesInBookkeeping()
  {
    global $langs;
    $langs->load('assets');
 
    // Clean parameters
    $this->id = $this->id > 0 ? $this->id : 0;
 
    // Check parameters
    $error = 0;
    if (empty($this->id)) {
      $this->errors[] = $langs->trans("ErrorFieldRequired", $langs->transnoentitiesnoconv("Asset") . ' (' . $langs->transnoentitiesnoconv("TechnicalID") . ')');
      $error++;
    }
    if ($error) {
      return -1;
    }
    if (!isModEnabled('accounting')) {
      return 0;
    }
 
    // Old request with 'WITH'
    /*
    $sql = "WITH in_accounting_bookkeeping(fk_docdet) AS (";
    $sql .= " SELECT DISTINCT fk_docdet";
    $sql .= " FROM " . MAIN_DB_PREFIX . "accounting_bookkeeping";
    $sql .= " WHERE doc_type = 'asset'";
    $sql .= ")";
    $sql .= "SELECT COUNT(*) AS has_bookkeeping";
    $sql .= " FROM " . MAIN_DB_PREFIX . "asset_depreciation AS ad";
    $sql .= " LEFT JOIN in_accounting_bookkeeping as iab ON iab.fk_docdet = ad.rowid";
    $sql .= " WHERE ad.fk_asset = " . (int) $this->id;
    $sql .= " AND iab.fk_docdet IS NOT NULL";
    */
 
    $sql = "SELECT COUNT(*) AS has_bookkeeping";
    $sql .= " FROM " . MAIN_DB_PREFIX . "asset_depreciation AS ad";
    $sql .= " LEFT JOIN (SELECT DISTINCT fk_docdet FROM " . MAIN_DB_PREFIX . "accounting_bookkeeping WHERE doc_type = 'asset') AS iab ON iab.fk_docdet = ad.rowid";
    $sql .= " WHERE ad.fk_asset = " . (int) $this->id;
    $sql .= " AND iab.fk_docdet IS NOT NULL";
 
    $resql = $this->db->query($sql);
    if (!$resql) {
      $this->errors[] = $langs->trans('AssetErrorFetchDepreciationLines') . ': ' . $this->db->lasterror();
      return -1;
    }
 
    if ($obj = $this->db->fetch_object($resql)) {
      return $obj->has_bookkeeping > 0 ? 1 : 0;
    }
 
    return 0;
  }
 
  public function addDepreciationLine($mode, $ref, $depreciation_date, $depreciation_ht, $cumulative_depreciation_ht, $accountancy_code_debit, $accountancy_code_credit)
  {
    global $langs;
    $langs->load('assets');
 
    // Clean parameters
    $this->id = $this->id > 0 ? $this->id : 0;
    $mode = strtolower(trim($mode));
    $ref = trim($ref);
    $accountancy_code_debit = trim($accountancy_code_debit);
    $accountancy_code_credit = trim($accountancy_code_credit);
 
    // Check parameters
    $error = 0;
    if (empty($this->id)) {
      $this->errors[] = $langs->trans("ErrorFieldRequired", $langs->transnoentitiesnoconv("Asset") . ' (' . $langs->transnoentitiesnoconv("TechnicalID") . ')');
      $error++;
    }
    if ($error) {
      return -1;
    }
 
    $sql = "INSERT INTO " . MAIN_DB_PREFIX . "asset_depreciation(fk_asset, depreciation_mode, ref, depreciation_date, depreciation_ht, cumulative_depreciation_ht, accountancy_code_debit, accountancy_code_credit)";
    $sql .= " VALUES ( ";
    $sql .= " " . (int) $this->id;
    $sql .= ", '" . $this->db->escape($mode) . "'";
    $sql .= ", '" . $this->db->escape($ref) . "'";
    $sql .= ", '" . $this->db->idate($depreciation_date) . "'";
    $sql .= ", " . (float) $depreciation_ht;
    $sql .= ", " . (float) $cumulative_depreciation_ht;
    $sql .= ", '" . $this->db->escape($accountancy_code_debit) . "'";
    $sql .= ", '" . $this->db->escape($accountancy_code_credit) . "'";
    $sql .= ")";
 
    $resql = $this->db->query($sql);
    if (!$resql) {
      $this->errors[] = $langs->trans('AssetErrorAddDepreciationLine') . ': ' . $this->db->lasterror();
      return -1;
    }
 
    return 1;
  }
 
  public function calculationDepreciation()
  {
    global $conf, $langs;
    $langs->load('assets');
 
    // Clean parameters
    $this->id = $this->id > 0 ? $this->id : 0;
 
    // Check parameters
    $error = 0;
    if (empty($this->id)) {
      $this->errors[] = $langs->trans("ErrorFieldRequired", $langs->transnoentitiesnoconv("Asset") . ' (' . $langs->transnoentitiesnoconv("TechnicalID") . ')');
      $error++;
    }
    if ($error) {
      return -1;
    }
 
    if (! empty($this->not_depreciated)) {
      return 1;
    }
 
    // Get depreciation options
    //---------------------------
    require_once DOL_DOCUMENT_ROOT . '/asset/class/assetdepreciationoptions.class.php';
    $options = new AssetDepreciationOptions($this->db);
    $result = $options->fetchDeprecationOptions($this->id);
    if ($result < 0) {
      $this->error = $options->error;
      $this->errors = $options->errors;
      return -1;
    }
 
    // Get accountancy codes
    //---------------------------
    require_once DOL_DOCUMENT_ROOT . '/asset/class/assetaccountancycodes.class.php';
    $accountancy_codes = new AssetAccountancyCodes($this->db);
    $result = $accountancy_codes->fetchAccountancyCodes($this->id);
    if ($result < 0) {
      $this->error = $accountancy_codes->error;
      $this->errors = $accountancy_codes->errors;
      return -1;
    }
 
    $this->db->begin();
 
    // Delete old lines
    $modes = array();
    foreach ($options->deprecation_options as $mode_key => $fields) {
      $modes[$mode_key] = $this->db->escape($mode_key);
    }
    $sql = "DELETE FROM " . MAIN_DB_PREFIX . "asset_depreciation";
    $sql .= " WHERE fk_asset = " . (int) $this->id;
    $sql .= " AND depreciation_mode NOT IN ('" . $this->db->sanitize(implode("', '", $modes)) . "')";
 
    $resql = $this->db->query($sql);
    if (!$resql) {
      $this->errors[] = $langs->trans('AssetErrorClearDepreciationLines') . ': ' . $this->db->lasterror();
      $error++;
    }
 
    if (!$error) {
      // Get fiscal period
      require_once DOL_DOCUMENT_ROOT . '/core/lib/date.lib.php';
      require_once DOL_DOCUMENT_ROOT . '/core/lib/accounting.lib.php';
 
      // @FIXME getCurrentPeriodOfFiscalYear return the first period found. What if there is several ? And what if not closed ? And what if end date not yet defined.
      $dates = getCurrentPeriodOfFiscalYear($this->db, $conf, $this->date_start > $this->date_acquisition ? $this->date_start : $this->date_acquisition);
      $init_fiscal_period_start = $dates['date_start'];
      $init_fiscal_period_end = $dates['date_end'];
      /*
      if (empty($init_fiscal_period_start) || empty($init_fiscal_period_end)) {
        $pastmonthyear = $dates['pastmonthyear'];
        $pastmonth = $dates['pastmonth'];
        $init_fiscal_period_start = dol_get_first_day((int) $pastmonthyear, (int) $pastmonth, false);
        $init_fiscal_period_end = dol_get_last_day((int) $pastmonthyear, (int) $pastmonth, false);
      }
      */
 
      foreach ($options->deprecation_options as $mode_key => $fields) {
        // Get last depreciation lines save in bookkeeping
        //-----------------------------------------------------
 
        // Old request with 'WITH'
        /*
        $sql = "WITH in_accounting_bookkeeping(fk_docdet) AS (";
        $sql .= " SELECT fk_docdet";
        $sql .= " FROM " . MAIN_DB_PREFIX . "accounting_bookkeeping";
        $sql .= " WHERE doc_type = 'asset'";
        $sql .= ")";
        $sql .= "SELECT ad.depreciation_date, ad.cumulative_depreciation_ht";
        $sql .= " FROM " . MAIN_DB_PREFIX . "asset_depreciation AS ad";
        $sql .= " LEFT JOIN in_accounting_bookkeeping as iab ON iab.fk_docdet = ad.rowid";
        $sql .= " WHERE ad.fk_asset = " . (int) $this->id;
        $sql .= " AND ad.depreciation_mode = '" . $this->db->escape($mode_key) . "'";
        $sql .= " AND iab.fk_docdet IS NOT NULL";
        $sql .= " ORDER BY ad.depreciation_date DESC";
        $sql .= " LIMIT 1";
        */
 
        $last_depreciation_date = '';
        $last_cumulative_depreciation_ht = $this->reversal_amount_ht;
        if (isModEnabled('accounting')) {
          $sql = "SELECT ad.depreciation_date, ad.cumulative_depreciation_ht";
          $sql .= " FROM " . MAIN_DB_PREFIX . "asset_depreciation AS ad";
          $sql .= " LEFT JOIN (SELECT DISTINCT fk_docdet FROM " . MAIN_DB_PREFIX . "accounting_bookkeeping WHERE doc_type = 'asset') AS iab ON iab.fk_docdet = ad.rowid";
          $sql .= " WHERE ad.fk_asset = " . (int) $this->id;
          $sql .= " AND ad.depreciation_mode = '" . $this->db->escape($mode_key) . "'";
          $sql .= " AND iab.fk_docdet IS NOT NULL";
          $sql .= " ORDER BY ad.depreciation_date DESC";
          $sql .= " LIMIT 1";
 
          $resql = $this->db->query($sql);
          if (!$resql) {
            $this->errors[] = $langs->trans('AssetErrorFetchMaxDepreciationDateForMode', $mode_key) . ': ' . $this->db->lasterror();
            $error++;
            break;
          }
          if ($obj = $this->db->fetch_object($resql)) {
            $last_depreciation_date = $this->db->jdate($obj->depreciation_date);
            $last_cumulative_depreciation_ht = $obj->cumulative_depreciation_ht;
          }
        }
 
        // Set last cumulative depreciation
        $sql = "UPDATE " . MAIN_DB_PREFIX . $this->db->sanitize($options->deprecation_options_fields[$mode_key]['table']);
        $sql .= " SET total_amount_last_depreciation_ht = " . ((float) (empty($last_cumulative_depreciation_ht) ? 0 : $last_cumulative_depreciation_ht));
        $sql .= " WHERE fk_asset = " . (int) $this->id;
        $resql = $this->db->query($sql);
        if (!$resql) {
          $this->errors[] = $langs->trans('AssetErrorSetLastCumulativeDepreciation') . ': ' . $this->db->lasterror();
          $error++;
          break;
        }
 
        // Delete old lines
        $sql = "DELETE FROM " . MAIN_DB_PREFIX . "asset_depreciation";
        $sql .= " WHERE fk_asset = " . (int) $this->id;
        $sql .= " AND depreciation_mode = '" . $this->db->escape($mode_key) . "'";
        if (isModEnabled('accounting')) {
          $sql .= " AND NOT EXISTS (SELECT fk_docdet FROM " . MAIN_DB_PREFIX . "accounting_bookkeeping WHERE doc_type = 'asset' AND fk_docdet = " . MAIN_DB_PREFIX . "asset_depreciation.rowid)";
        }
        if ($last_depreciation_date !== "") {
          $sql .= " AND ref <> ''";
        }
        $resql = $this->db->query($sql);
        if (!$resql) {
          $this->errors[] = $langs->trans('AssetErrorClearDepreciationLines') . ': ' . $this->db->lasterror();
          $error++;
          break;
        }
 
        // Get depreciation period
        $depreciation_date_start = $this->date_start > $this->date_acquisition ? $this->date_start : $this->date_acquisition;
        $depreciation_date_end = dol_time_plus_duree(dol_time_plus_duree((int) $depreciation_date_start, (float) $fields['duration'], $fields['duration_type'] == 1 ? 'm' : ($fields['duration_type'] == 2 ? 'd' : 'y')), -1, 'd');
        $depreciation_amount = $fields['amount_base_depreciation_ht'];
        if ($fields['duration_type'] == 2) { // Daily
          $fiscal_period_start = $depreciation_date_start;
          $fiscal_period_end = $depreciation_date_start;
        } elseif ($fields['duration_type'] == 1) { // Monthly
          $date_temp = dol_getdate((int) $depreciation_date_start);
          $fiscal_period_start = dol_get_first_day($date_temp['year'], $date_temp['mon'], false);
          $fiscal_period_end = dol_get_last_day($date_temp['year'], $date_temp['mon'], false);
        } else { // Annually
          $fiscal_period_start = $init_fiscal_period_start;
          $fiscal_period_end = $init_fiscal_period_end;
        }
        $cumulative_depreciation_ht = (float) $last_cumulative_depreciation_ht;
        $depreciation_period_amount = $depreciation_amount - (float) $this->reversal_amount_ht;
        $start_date = $depreciation_date_start;
        $disposal_date = isset($this->disposal_date) && $this->disposal_date !== "" ? $this->disposal_date : "";
        $finish_date = $disposal_date !== "" ? $disposal_date : $depreciation_date_end;
        $accountancy_code_depreciation_debit_key = $accountancy_codes->accountancy_codes_fields[$mode_key]['depreciation_debit'];
        $accountancy_code_depreciation_debit = $accountancy_codes->accountancy_codes[$mode_key][$accountancy_code_depreciation_debit_key] ?? '';
        $accountancy_code_depreciation_credit_key = $accountancy_codes->accountancy_codes_fields[$mode_key]['depreciation_credit'];
        $accountancy_code_credit = $accountancy_codes->accountancy_codes[$mode_key][$accountancy_code_depreciation_credit_key] ?? '';
 
        // Reversal depreciation line
        //-----------------------------------------------------
        if ($last_depreciation_date === "" && ($depreciation_date_start < $fiscal_period_start || is_numeric($this->reversal_date))) {
          if (is_numeric($this->reversal_date)) {
            if ($this->reversal_date < $fiscal_period_start) {
              $this->errors[] = $langs->trans('AssetErrorReversalDateNotGreaterThanCurrentBeginFiscalDateForMode', $mode_key);
              $error++;
              break;
            }
 
            if (empty($this->reversal_amount_ht)) {
              $this->errors[] = $langs->trans('AssetErrorReversalAmountNotProvidedForMode', $mode_key);
              $error++;
              break;
            }
 
            $start_date = $this->reversal_date;
            $result = $this->addDepreciationLine($mode_key, '', $start_date, (float) $this->reversal_amount_ht, (float) $this->reversal_amount_ht, $accountancy_code_depreciation_debit, $accountancy_code_credit);
            if ($result < 0) {
              $error++;
              break;
            }
          } else {
            $this->errors[] = $langs->trans('AssetErrorReversalDateNotProvidedForMode', $mode_key);
            $error++;
            break;
          }
        }
 
        // futures depreciation lines
        //-----------------------------------------------------
        $day_count_convention = getAssetDepreciationDayCountConvention();
        $period_amount = (float) ($fields['duration'] > 0 ? price2num($depreciation_period_amount / $fields['duration'], 'MT') : 0);
        $first_period_found = false;
 
        //$first_period_date = isset($begin_period) && $begin_period > $fiscal_period_start ? $begin_period : $fiscal_period_start;
        $first_period_date = $fiscal_period_start;
 
        $ref_date_format = "%Y" . ($fields['duration_type'] == 1 || $fields['duration_type'] == 2 ? '-%m' : '') . ($fields['duration_type'] == 2 ? '-%d' : '');
 
        // Loop security
        $idx_loop = 0;
        $max_loop = $fields['duration'] + 2;
        do {
          // Loop security
          $idx_loop++;
          if ($idx_loop > $max_loop) {
            break;
          }
 
          if ($last_depreciation_date < $fiscal_period_end && ($first_period_date <= $start_date || $first_period_found)) {
            // Disposal not depreciated
            if ($fiscal_period_start <= $disposal_date && $disposal_date <= $fiscal_period_end && empty($this->disposal_depreciated)) {
              break;
            }
 
            $first_period_found = true;
 
            $period_begin = dol_print_date($fiscal_period_start, $ref_date_format);
            $period_end = dol_print_date($fiscal_period_end, $ref_date_format);
            $ref = $period_begin . ($period_begin != $period_end ? ' - ' . $period_end : '');
            if ($fiscal_period_start <= $disposal_date && $disposal_date <= $fiscal_period_end) {
              $ref .= ' - ' . $langs->transnoentitiesnoconv('AssetDisposal');
            }
 
            $begin_date = $fiscal_period_start < $start_date && $start_date <= $fiscal_period_end ? $start_date : $fiscal_period_start;
            $end_date = $fiscal_period_start < $finish_date && $finish_date <= $fiscal_period_end ? $finish_date : $fiscal_period_end;
            if ($fields['duration_type'] == 2) { // Daily
              $depreciation_ht = $period_amount;
            } elseif ($fields['duration_type'] == 1) { // Monthly
              // Same rule as the annual branch: the count of the days and the length of a full
              // month must come from the same day count convention. Counting the real calendar
              // days then dividing them by a conventional month of 30 made the depreciation of a
              // partial month depend on the length of that month, and required a special case to
              // give a full February a whole monthly amount.
              $period_fraction = getAssetDepreciationMonthFraction($begin_date, $end_date, $day_count_convention, 'gmt');
              $depreciation_ht = (float) price2num($period_amount * $period_fraction, 'MT');
            } else { // Annually, taking care for adjustments to shortened or extended periods (e.g., fiscal years of 9 or 15 months)
              // A standard fiscal year lasts 365 days, or 366 when it covers a leap day. Anything else
              // is a shortened or an extended fiscal year (e.g. 9 or 15 months), whose depreciation is
              // prorated with no upper limit.
              $nb_days_fiscal_period = num_between_day($fiscal_period_start, $fiscal_period_end, 1);
              $is_standard_fiscal_period = ($nb_days_fiscal_period >= 365 && $nb_days_fiscal_period <= 366);
 
              if ($is_standard_fiscal_period && $begin_date <= $fiscal_period_start && $end_date >= $fiscal_period_end) {
                // The asset is depreciated over the whole fiscal year: full annuity, whatever the
                // convention. Computing a prorata here would give slightly less than a full annuity
                // with THIRTY_360 when the fiscal year ends in February (a 30/360 count ending on
                // Feb 28th or 29th is 358 or 359 days instead of 360).
                $period_fraction = 1;
              } else {
                // The count of the days and the number of days of a full year must always come from
                // the same day count convention, otherwise every partial period (so the first and the
                // last year of every asset) is over or under evaluated. Counting the real calendar
                // days then dividing them by 360 overestimated every prorata by about 1.39% (365/360).
                // The bounds are anchored on GMT midnight, so the calendar decomposition of
                // THIRTY_360 and ACT_ACT must be read in GMT too, otherwise a partial period is
                // prorated on a day shifted by the UTC offset of the server.
                $period_fraction = getAssetDepreciationPeriodFraction($begin_date, $end_date, $day_count_convention, 'gmt');
                if ($is_standard_fiscal_period) {
                  // Never more than a full annuity on a standard fiscal year
                  $period_fraction = min(1, $period_fraction);
                }
              }
              $depreciation_ht = (float) price2num($period_amount * $period_fraction, 'MT');
            }
            if (getDolGlobalInt('ASSET_ROUND_INTEGER_NUMBER_UPWARDS') == 1) {
              if ($idx_loop < $max_loop) { // avoid last depreciation value
                $depreciation_ht = ceil($depreciation_ht);
              }
            }
 
            if ($fiscal_period_start <= $depreciation_date_end && $depreciation_date_end <= $fiscal_period_end) { // last period
              $depreciation_ht = (float) price2num($depreciation_amount - (float) $cumulative_depreciation_ht, 'MT');
              $cumulative_depreciation_ht = $depreciation_amount;
            } else {
              $cumulative_depreciation_ht += $depreciation_ht;
            }
 
            $result = $this->addDepreciationLine($mode_key, $ref, $fiscal_period_end, $depreciation_ht, (float) $cumulative_depreciation_ht, $accountancy_code_depreciation_debit, $accountancy_code_credit);
            if ($result < 0) {
              $error++;
              break;
            }
          }
 
          // Next fiscal period (+1 day/month/year)
          $fiscal_period_start = dol_time_plus_duree($fiscal_period_end, 1, 'd');
 
          if ($fields['duration_type'] == 0) { // Annually - use fiscal year-end
            // Search for the NEXT fiscal year
            $next_fy = getNextFiscalYear($this->db, $fiscal_period_end, 'gmt');
 
            if ($next_fy !== null) {
              // Exercise found in database
              $fiscal_period_start = $next_fy['date_start'];
              $fiscal_period_end = $next_fy['date_end'];
            } else {
              // If there is no subsequent fiscal year in the database, a one-year fiscal year is automatically generated.
              // based on the structure of the current fiscal year
              $current_fy_start_parts = dol_getdate($fiscal_period_start);
 
              // Calculate the end: 1 year minus 1 day from the start
              $fiscal_period_end = dol_time_plus_duree(dol_time_plus_duree($fiscal_period_start, 1, 'y'), -1, 'd');
 
              // If the amortization end date is exceeded, there is no need to continue after that.
              // The loop will end naturally with the while condition.
            }
          } elseif ($fields['duration_type'] == 1) { // Monthly
            $fiscal_period_end = dol_time_plus_duree(dol_time_plus_duree($fiscal_period_start, 1, 'm'), -1, 'd');
          } else { // Daily
            $fiscal_period_end = $fiscal_period_start;
          }
          $last_period_date = $disposal_date !== "" && $disposal_date < $depreciation_date_end ? $disposal_date : $depreciation_date_end;
        } while ($fiscal_period_start < $last_period_date);
 
        if ($error) {
          break;
        }
      }
    }
 
    if ($error) {
      $this->db->rollback();
      return -1;
    } else {
      $this->db->commit();
      return 1;
    }
  }
 
  public function setLastCumulativeDepreciation($asset_depreciation_id)
  {
    global $langs;
    $langs->load('assets');
 
    // Clean parameters
    $asset_depreciation_id = $asset_depreciation_id > 0 ? $asset_depreciation_id : 0;
 
    // Check parameters
    $error = 0;
    if (empty($asset_depreciation_id)) {
      $this->errors[] = $langs->trans("ErrorFieldRequired", $langs->transnoentitiesnoconv("AssetDepreciation") . ' (' . $langs->transnoentitiesnoconv("TechnicalID") . ')');
      $error++;
    }
    if ($error) {
      return -1;
    }
 
    $this->db->begin();
 
    require_once DOL_DOCUMENT_ROOT . '/asset/class/assetdepreciationoptions.class.php';
    $options = new AssetDepreciationOptions($this->db);
 
    // Get last depreciation lines save in bookkeeping
    //-----------------------------------------------------
    $sql = "SELECT fk_asset, depreciation_mode, cumulative_depreciation_ht";
    $sql .= " FROM " . MAIN_DB_PREFIX . "asset_depreciation";
    $sql .= " WHERE rowid = " . (int) $asset_depreciation_id;
    $resql = $this->db->query($sql);
    if (!$resql) {
      $this->errors[] = $langs->trans('AssetErrorFetchCumulativeDepreciation') . ': ' . $this->db->lasterror();
      $error++;
    } else {
      if ($obj = $this->db->fetch_object($resql)) {
        $mode_key = $obj->depreciation_mode;
        if (!empty($options->deprecation_options_fields[$mode_key])) {
          $sql = "UPDATE " . MAIN_DB_PREFIX . $this->db->sanitize($options->deprecation_options_fields[$mode_key]['table']);
          $sql .= " SET total_amount_last_depreciation_ht = " . ((float) $obj->cumulative_depreciation_ht);
          $sql .= " WHERE fk_asset = " . (int) $obj->fk_asset;
          $resql = $this->db->query($sql);
          if (!$resql) {
            $this->errors[] = $langs->trans('AssetErrorSetLastCumulativeDepreciation') . ': ' . $this->db->lasterror();
            $error++;
          }
        }
      }
    }
 
    if ($error) {
      $this->db->rollback();
      return -1;
    } else {
      $this->db->commit();
      return 1;
    }
  }
 
  public function dispose($user, $disposal_invoice_id, $notrigger = 0)
  {
    global $conf, $langs;
 
    // Protection
    if ($this->status == self::STATUS_DISPOSED) {
      return 0;
    }
 
    $this->db->begin();
 
    $required_fields = array('disposal_date', 'disposal_date', 'fk_disposal_type');
    foreach ($required_fields as $field) {
      $this->fields[$field]['notnull'] = 1;
    }
    $result = $this->update($user, 1);
    foreach ($required_fields as $field) {
      $this->fields[$field]['notnull'] = 0;
    }
    if ($result > 0) {
      if ($disposal_invoice_id > 0) {
        $this->add_object_linked('facture', $disposal_invoice_id);
      }
      $result = $this->setStatusCommon($user, self::STATUS_DISPOSED, $notrigger, 'ASSET_DISPOSED');
    }
    if ($result > 0) {
      $result = $this->calculationDepreciation();
    }
 
    if ($result < 0) {
      $this->db->rollback();
    } else {
      $this->db->commit();
    }
 
    // Define output language
    if ($result > 0 && !getDolGlobalString('MAIN_DISABLE_PDF_AUTOUPDATE')) {
      if (method_exists($this, 'generateDocument')) {
        $hidedetails = (getDolGlobalString('MAIN_GENERATE_DOCUMENTS_HIDE_DETAILS') ? 1 : 0);
        $hidedesc = (getDolGlobalString('MAIN_GENERATE_DOCUMENTS_HIDE_DESC') ? 1 : 0);
        $hideref = (getDolGlobalString('MAIN_GENERATE_DOCUMENTS_HIDE_REF') ? 1 : 0);
        $outputlangs = $langs;
        $newlang = '';
        if (getDolGlobalInt('MAIN_MULTILANGS') /* && empty($newlang) */ && GETPOST('lang_id', 'aZ09')) {
          $newlang = GETPOST('lang_id', 'aZ09');
        }
        if (!empty($newlang)) {
          $outputlangs = new Translate("", $conf);
          $outputlangs->setDefaultLang($newlang);
        }
        $model = $this->model_pdf;
        $ret = $this->fetch($this->id); // Reload to get new records
 
        $this->generateDocument($model, $outputlangs, $hidedetails, $hidedesc, $hideref);
      }
    }
 
    return $result;
  }
 
  public function reopen($user, $notrigger = 0)
  {
    global $conf, $langs;
 
    // Protection
    if ($this->status != self::STATUS_DISPOSED) {
      return 0;
    }
 
 
    $this->db->begin();
 
    $this->disposal_date = null;
    $this->disposal_amount_ht = null;
    $this->fk_disposal_type = null;
    $this->disposal_depreciated = 0;
    $this->disposal_subject_to_vat = 0;
    $result = $this->update($user, 1);
    if ($result > 0) {
      $this->deleteObjectLinked(null, 'facture');
      $result = $this->setStatusCommon($user, self::STATUS_VALIDATED, $notrigger, 'ASSET_REOPEN');
    }
    if ($result > 0) {
      $result = $this->calculationDepreciation();
    }
 
    if ($result < 0) {
      $this->db->rollback();
    } else {
      $this->db->commit();
    }
 
    // Define output language
    if ($result > 0 && !getDolGlobalString('MAIN_DISABLE_PDF_AUTOUPDATE')) {
      if (method_exists($this, 'generateDocument')) {
        $hidedetails = (getDolGlobalString('MAIN_GENERATE_DOCUMENTS_HIDE_DETAILS') ? 1 : 0);
        $hidedesc = (getDolGlobalString('MAIN_GENERATE_DOCUMENTS_HIDE_DESC') ? 1 : 0);
        $hideref = (getDolGlobalString('MAIN_GENERATE_DOCUMENTS_HIDE_REF') ? 1 : 0);
        $outputlangs = $langs;
        $newlang = '';
        if (getDolGlobalInt('MAIN_MULTILANGS') /* && empty($newlang) */ && GETPOST('lang_id', 'aZ09')) {
          $newlang = GETPOST('lang_id', 'aZ09');
        }
        if (!empty($newlang)) {
          $outputlangs = new Translate("", $conf);
          $outputlangs->setDefaultLang($newlang);
        }
        $model = $this->model_pdf;
        $ret = $this->fetch($this->id); // Reload to get new records
 
        $this->generateDocument($model, $outputlangs, $hidedetails, $hidedesc, $hideref);
      }
    }
 
    return $result;
  }
 
  public function getNomUrl($withpicto = 0, $option = '', $maxlen = 0, $notooltip = 0, $morecss = '', $save_lastsearch_value = -1)
  {
    global $db, $conf, $langs, $hookmanager;
    global $dolibarr_main_authentication, $dolibarr_main_demo;
    global $menumanager;
 
    if (!empty($conf->dol_no_mouse_hover)) {
      $notooltip = 1; // Force disable tooltips
    }
 
    $result = '';
 
    $label = img_picto('', $this->picto).' <u>'.$langs->trans("Asset").'</u>';
    if (isset($this->status)) {
      $label .= ' '.$this->getLibStatut(5);
    }
    $label .= '<br>';
    $label .= '<b>'.$langs->trans('Ref').':</b> '.$this->ref;
 
    $url = dol_buildpath('/asset/card.php', 1).'?id='.$this->id;
 
    if ($option != 'nolink') {
      // Add param to save lastsearch_values or not
      $add_save_lastsearch_values = ($save_lastsearch_value == 1 ? 1 : 0);
      if ($save_lastsearch_value == -1 && isset($_SERVER["PHP_SELF"]) && preg_match('/list\.php/', $_SERVER["PHP_SELF"])) {
        $add_save_lastsearch_values = 1;
      }
      if ($add_save_lastsearch_values) {
        $url .= '&save_lastsearch_values=1';
      }
    }
 
    $linkclose = '';
    if (empty($notooltip)) {
      if (getDolGlobalString('MAIN_OPTIMIZEFORTEXTBROWSER')) {
        $label = $langs->trans("ShowAsset");
        $linkclose .= ' alt="'.dolPrintHTMLForAttribute($label).'"';
      }
      $linkclose .= ' title="'.dolPrintHTMLForAttribute($label).'"';
      $linkclose .= ' class="classfortooltip'.($morecss ? ' '.$morecss : '').'"';
    } else {
      $linkclose = ($morecss ? ' class="'.$morecss.'"' : '');
    }
 
    if ($option == 'nolink') {
      $linkstart = '<span';
    } else {
      $linkstart = '<a href="'.$url.'"';
    }
    $linkstart .= $linkclose.'>';
    if ($option == 'nolink') {
      $linkend = '</span>';
    } else {
      $linkend = '</a>';
    }
 
    $result .= $linkstart;
 
    if (empty($this->showphoto_on_popup)) {
      if ($withpicto) {
        $result .= img_object(($notooltip ? '' : $label), ($this->picto ? $this->picto : 'generic'), ($notooltip ? (($withpicto != 2) ? 'class="paddingright"' : '') : 'class="'.(($withpicto != 2) ? 'paddingright ' : '').'classfortooltip"'), 0, 0, $notooltip ? 0 : 1);
      }
    } else {
      if ($withpicto) {
        require_once DOL_DOCUMENT_ROOT.'/core/lib/files.lib.php';
 
        list($class, $module) = explode('@', $this->picto);
        $upload_dir = $conf->$module->multidir_output[$conf->entity]."/$class/".dol_sanitizeFileName($this->ref);
        $filearray = dol_dir_list($upload_dir, "files");
        $filename = $filearray[0]['name'];
        if (!empty($filename)) {
          $pospoint = strpos($filearray[0]['name'], '.');
 
          $pathtophoto = $class.'/'.$this->ref.'/thumbs/'.dol_substr($filename, 0, $pospoint).'_mini'.dol_substr($filename, $pospoint);
          if (!getDolGlobalString(strtoupper($module.'_'.$class).'_FORMATLISTPHOTOSASUSERS')) {
            $result .= '<div class="floatleft inline-block valignmiddle divphotoref"><div class="photoref"><img class="photo'.$module.'" alt="No photo" border="0" src="'.DOL_URL_ROOT.'/viewimage.php?modulepart='.$module.'&entity='.$conf->entity.'&file='.urlencode($pathtophoto).'"></div></div>';
          } else {
            $result .= '<div class="floatleft inline-block valignmiddle divphotoref"><img class="photouserphoto userphoto" alt="No photo" border="0" src="'.DOL_URL_ROOT.'/viewimage.php?modulepart='.$module.'&entity='.$conf->entity.'&file='.urlencode($pathtophoto).'"></div>';
          }
 
          $result .= '</div>';
        } else {
          $result .= img_object(($notooltip ? '' : $label), ($this->picto ? $this->picto : 'generic'), ($notooltip ? (($withpicto != 2) ? 'class="paddingright"' : '') : 'class="'.(($withpicto != 2) ? 'paddingright ' : '').'classfortooltip"'), 0, 0, $notooltip ? 0 : 1);
        }
      }
    }
 
    if ($withpicto != 2) {
      $name = $this->ref;
      if ($option == 'label') {
        $name = $this->label;
      } elseif ($option == 'with_label') {
        $name .= ' - ' . $this->label;
      }
      $result .= dol_escape_htmltag($maxlen ? dol_trunc($name, $maxlen) : $name);
    }
 
    $result .= $linkend;
    //if ($withpicto != 2) $result.=(($addlabel && $this->label) ? $sep . dol_trunc($this->label, ($addlabel > 1 ? $addlabel : 0)) : '');
 
    global $action;
    $hookmanager->initHooks(array($this->element . 'dao'));
    $parameters = array('id' => $this->id, 'getnomurl' => &$result);
    $reshook = $hookmanager->executeHooks('getNomUrl', $parameters, $this, $action); // Note that $action and $object may have been modified by some hooks
    if ($reshook > 0) {
      $result = $hookmanager->resPrint;
    } else {
      $result .= $hookmanager->resPrint;
    }
    return $result;
  }
 
  public function getLabelStatus($mode = 0)
  {
    return $this->LibStatut((int) $this->status, $mode);
  }
 
  public function getLibStatut($mode = 0)
  {
    return $this->LibStatut((int) $this->status, $mode);
  }
 
  // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps
  public function LibStatut($status, $mode = 0)
  {
    // phpcs:enable
    if (empty($this->labelStatus) || empty($this->labelStatusShort)) {
      global $langs;
      //$langs->load("assets");
      $this->labelStatus[self::STATUS_DRAFT] = $langs->transnoentitiesnoconv('AssetInDraft');
      $this->labelStatus[self::STATUS_VALIDATED] = $langs->transnoentitiesnoconv('AssetInProgress');
      $this->labelStatus[self::STATUS_DISPOSED] = $langs->transnoentitiesnoconv('AssetDisposed');
      $this->labelStatusShort[self::STATUS_DRAFT] = $langs->transnoentitiesnoconv('AssetInDraft');
      $this->labelStatusShort[self::STATUS_VALIDATED] = $langs->transnoentitiesnoconv('AssetInProgress');
      $this->labelStatusShort[self::STATUS_DISPOSED] = $langs->transnoentitiesnoconv('AssetDisposed');
    }
 
    $statusType = 'status'.$status;
    if ($status == self::STATUS_VALIDATED) {
      $statusType = 'status4';
    }
    if ($status == self::STATUS_DISPOSED) {
      $statusType = 'status6';
    }
 
    return dolGetStatus($this->labelStatus[$status], $this->labelStatusShort[$status], '', $statusType, $mode);
  }
 
  public function info($id)
  {
    $sql = "SELECT rowid, date_creation as datec, tms as datem, date_valid as datev,";
    $sql .= " fk_user_creat, fk_user_modif, fk_user_valid";
    $sql .= " FROM ".MAIN_DB_PREFIX.$this->table_element." as t";
    $sql .= " WHERE t.rowid = ".((int) $id);
 
    $result = $this->db->query($sql);
    if ($result) {
      if ($this->db->num_rows($result)) {
        $obj = $this->db->fetch_object($result);
        $this->id = $obj->rowid;
 
        $this->user_creation_id   = $obj->fk_user_creat;
        $this->user_modification_id = $obj->fk_user_modif;
        $this->user_validation_id = $obj->fk_user_valid;
        $this->date_creation    = $this->db->jdate($obj->datec);
        $this->date_modification  = $this->db->jdate($obj->datem);
        $this->date_validation    = $this->db->jdate($obj->datev);
      }
 
      $this->db->free($result);
    } else {
      dol_print_error($this->db);
    }
  }
 
  public function initAsSpecimen()
  {
    // Set here init that are not commonf fields
    // $this->property1 = ...
    // $this->property2 = ...
 
    return $this->initAsSpecimenCommon();
  }
 
  public function generateDocument($modele, $outputlangs, $hidedetails = 0, $hidedesc = 0, $hideref = 0, $moreparams = null)
  {
    global $langs;
 
    $langs->load("assets");
 
    if (!dol_strlen($modele)) {
      $modele = 'standard_asset';
 
      if ($this->model_pdf) {
        $modele = $this->model_pdf;
      } elseif (getDolGlobalString('ASSET_ASSET_ADDON_PDF')) {
        $modele = getDolGlobalString('ASSET_ASSET_ADDON_PDF');
      }
    }
 
    $modelpath = "core/modules/asset/doc/";
 
    return $this->commonGenerateDocument($modelpath, $modele, $outputlangs, $hidedetails, $hidedesc, $hideref, $moreparams);
  }
 
  public function getNextNumRef()
  {
    global $langs, $conf;
    $langs->load("assets");
 
    if (!getDolGlobalString('ASSET_ASSET_ADDON')) {
      $conf->global->ASSET_ASSET_ADDON = 'mod_asset_standard';
    }
 
    if (getDolGlobalString('ASSET_ASSET_ADDON')) {
      $mybool = false;
 
      $file = getDolGlobalString('ASSET_ASSET_ADDON') . ".php";
      $classname = getDolGlobalString('ASSET_ASSET_ADDON');
 
      // Include file with class
      $dirmodels = array_merge(array('/'), (array) $conf->modules_parts['models']);
      foreach ($dirmodels as $reldir) {
        $dir = dol_buildpath($reldir."core/modules/asset/");
 
        // Load file with numbering class (if found)
        $mybool = ((bool) @include_once $dir.$file) || $mybool;
      }
 
      if (!$mybool) {
        dol_print_error(null, "Failed to include file ".$file);
        return '';
      }
 
      if (class_exists($classname)) {
        $obj = new $classname();
 
        '@phan-var-force ModeleNumRefAsset $obj';
        $numref = $obj->getNextValue($this);
 
        if ($numref != '' && $numref != '-1') {
          return $numref;
        } else {
          $this->error = $obj->error;
          //dol_print_error($this->db,get_class($this)."::getNextNumRef ".$obj->error);
          return "";
        }
      } else {
        print $langs->trans("Error")." ".$langs->trans("ClassNotFound").' '.$classname;
        return "";
      }
    } else {
      print $langs->trans("ErrorNumberingModuleNotSetup", $this->element);
      return "";
    }
  }
 
  public function validate($user, $notrigger = 0)
  {
    global $conf;
 
    require_once DOL_DOCUMENT_ROOT.'/core/lib/files.lib.php';
 
    $error = 0;
 
    // Protection
    if ($this->status == self::STATUS_VALIDATED) {
      dol_syslog(get_class($this)."::validate action abandoned: already validated", LOG_WARNING);
      return 0;
    }
 
    $now = dol_now();
 
    $this->db->begin();
 
    // Define new ref
    if (/* !$error && */ (preg_match('/^[\‍(]?PROV/i', $this->ref) || empty($this->ref))) { // empty should not happened, but when it occurs, the test save life
      $num = $this->getNextNumRef();
    } else {
      $num = (string) $this->ref;
    }
    $this->newref = dol_sanitizeFileName($num);
 
    // Validate
    $sql = "UPDATE ".MAIN_DB_PREFIX.$this->table_element;
    $sql .= " SET ref = '".$this->db->escape($num)."',";
    $sql .= " status = ".self::STATUS_VALIDATED.",";
    $sql .= " date_valid='".$this->db->idate($now)."',";
    $sql .= " fk_user_valid = ".((int) $user->id);
    $sql .= " WHERE rowid = ".((int) $this->id);
 
    dol_syslog(get_class($this)."::validate()", LOG_DEBUG);
    $resql = $this->db->query($sql);
    if (!$resql) {
      dol_print_error($this->db);
      $this->error = $this->db->lasterror();
      $error++;
    }
 
    if (!$error && !$notrigger) {
      // Call trigger
      $result = $this->call_trigger('ASSET_VALIDATE', $user);
      if ($result < 0) {
        $error++;
      }
      // End call triggers
    }
 
    if (!$error) {
      $this->oldref = $this->ref;
 
      // Rename directory if dir was a temporary ref
      if (preg_match('/^[\‍(]?PROV/i', $this->ref)) {
        // Now we rename also files into index
        $sql = 'UPDATE '.MAIN_DB_PREFIX."ecm_files set filename = CONCAT('".$this->db->escape($this->newref)."', SUBSTR(filename, ".(strlen($this->ref) + 1).")), filepath = 'asset/".$this->db->escape($this->newref)."'";
        $sql .= " WHERE filename LIKE '".$this->db->escape($this->ref)."%' AND filepath = 'asset/".$this->db->escape($this->ref)."' and entity = ".((int) $conf->entity);
        $resql = $this->db->query($sql);
        if (!$resql) {
          $error++;
          $this->error = $this->db->lasterror();
        }
        $sql = 'UPDATE '.MAIN_DB_PREFIX."ecm_files set filepath = 'asset/".$this->db->escape($this->newref)."'";
        $sql .= " WHERE filepath = 'asset/".$this->db->escape($this->ref)."' and entity = ".((int) $conf->entity);
        $resql = $this->db->query($sql);
        if (!$resql) {
          $error++;
          $this->error = $this->db->lasterror();
        }
 
        // We rename directory ($this->ref = old ref, $num = new ref) in order not to lose the attachments
        $oldref = dol_sanitizeFileName($this->ref);
        $newref = dol_sanitizeFileName($num);
        $dirsource = $conf->asset->dir_output.'/'.$oldref;
        $dirdest = $conf->asset->dir_output.'/'.$newref;
        if (!$error && file_exists($dirsource)) {
          dol_syslog(get_class($this)."::validate() rename dir ".$dirsource." into ".$dirdest);
 
          if (@rename($dirsource, $dirdest)) {
            dol_syslog("Rename ok");
            // Rename docs starting with $oldref with $newref
            $listoffiles = dol_dir_list($conf->asset->dir_output.'/'.$newref, 'files', 1, '^'.preg_quote($oldref, '/'));
            foreach ($listoffiles as $fileentry) {
              $dirsource = $fileentry['name'];
              $dirdest = preg_replace('/^'.preg_quote($oldref, '/').'/', $newref, $dirsource);
              $dirsource = $fileentry['path'].'/'.$dirsource;
              $dirdest = $fileentry['path'].'/'.$dirdest;
              @rename($dirsource, $dirdest);
            }
          }
        }
      }
    }
 
    // Set new ref and current status
    if (!$error) {
      $this->ref = $num;
      $this->status = self::STATUS_VALIDATED;
    }
 
    if (!$error) {
      $this->db->commit();
      return 1;
    } else {
      $this->db->rollback();
      return -1;
    }
  }
 
  public function setDraft($user, $notrigger = 0)
  {
    // Protection
    if ($this->status <= self::STATUS_DRAFT) {
      return 0;
    }
 
    return $this->setStatusCommon($user, self::STATUS_DRAFT, $notrigger, 'ASSET_UNVALIDATE');
  }
}