actions_dellink.inc.php

Go to the documentation of this file.

<?php
/* Copyright (C) 2015-2016  Laurent Destailleur     <eldy@users.sourceforge.net>
 * Copyright (C) 2024   MDW           <mdeweerd@users.noreply.github.com>
 * Copyright (C) 2024       Frédéric France         <frederic.france@free.fr>
 *
 * 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/>.
 * or see https://www.gnu.org/
 */
 
// $action must be defined
// $object must be defined
// $permissiondellink must be defined
 
$dellinkid = GETPOSTINT('dellinkid');
$addlink = GETPOST('addlink', 'alpha');
$addlinkids = GETPOST('idtolinkto', 'array:int');
$addlinkref = GETPOST('reftolinkto', 'alpha');
$cancellink = GETPOST('cancel', 'alpha');
 
// Link object to another object
if ($action == 'addlink' && !empty($permissiondellink) && !$cancellink && $id > 0 && !empty($addlinkids)) {
  $object->fetch($id);
  $object->fetch_thirdparty();
  foreach ($addlinkids as $addlinkid) {
    $result = $object->add_object_linked($addlink, $addlinkid);
  }
  $object->clearObjectLinkedCache();
}
 
// Link by reference
if ($action == 'addlinkbyref' && !empty($permissiondellink) && !$cancellink && $id > 0 && !empty($addlinkref) && !getDolGlobalString('MAIN_HIDE_LINK_BY_REF_IN_LINKTO')) {
  $element_prop = getElementProperties($addlink);
  if (is_array($element_prop)) {
    dol_include_once('/' . $element_prop['classpath'] . '/' . $element_prop['classfile'] . '.class.php');
 
    $objecttmp = new $element_prop['classname']($db);
    '@phan-var-force CommonObject $objecttmp';
    $ret = $objecttmp->fetch(0, $addlinkref);
    if ($ret > 0) {
      $object->fetch($id);
      $object->fetch_thirdparty();
      $result = $object->add_object_linked($addlink, $objecttmp->id);
      if (isset($_POST['reftolinkto'])) {
        unset($_POST['reftolinkto']);
      }
      $object->clearObjectLinkedCache();
    } elseif ($ret < 0) {
      setEventMessages($objecttmp->error, $objecttmp->errors, 'errors');
    } else {
      $langs->load('errors');
      setEventMessage($langs->trans('ErrorRecordNotFound'), 'errors');
    }
  }
}
 
// Delete link in table llx_element_element
if ($action == 'dellink' && !empty($permissiondellink) && !$cancellink && $dellinkid > 0) {
  if (empty($object->id) && $id > 0) {
    $object->fetch($id);
  }
  // The link must involve the current object, else any link could be deleted by its rowid alone
  $linkfound = false;
  if ($object->id > 0) {
    $elementtypes = array_unique([$object->getElementType(), $object->element]);
    $sqlelementtypes = "'".implode("','", array_map([$db, 'escape'], $elementtypes))."'";
    $sql = "SELECT rowid FROM ".MAIN_DB_PREFIX."element_element";
    $sql .= " WHERE rowid = ".((int) $dellinkid);
    $sql .= " AND ((fk_source = ".((int) $object->id)." AND sourcetype IN (".$db->sanitize($sqlelementtypes, 1)."))";
    $sql .= " OR (fk_target = ".((int) $object->id)." AND targettype IN (".$db->sanitize($sqlelementtypes, 1).")))";
    $resql = $db->query($sql);
    if ($resql && $db->num_rows($resql) > 0) {
      $linkfound = true;
    }
  }
 
  $result = 0;
  if (!$linkfound) {
    setEventMessages($langs->trans('ErrorRecordNotFound'), null, 'errors');
  } else {
    $result = $object->deleteObjectLinked(0, '', 0, '', $dellinkid);
    $object->clearObjectLinkedCache();
  }
 
  if ($result < 0) {
    setEventMessages($object->error, $object->errors, 'errors');
  }
}