Alixar\Base\AlixarModel

Complexity

Total Complexity

1521

Size/Duplication

Total Lines	6635
Duplicated Lines	0 %

Importance

Changes

0

110 Methods

Rating	Name	Duplication	Size	Complexity
A	updateRangOfLine()	0	11	3
A	isFloat()	0	6	4
F	printOriginLine()	0	108	36
B	setPaymentTerms()	0	28	7
A	setDeliveryAddress()	0	15	4
A	line_ajaxorder()	0	6	2
A	getIdOfLine()	0	9	2
A	formAddObjectLine()	0	21	4
C	line_order()	0	64	14
C	updateObjectLinked()	0	27	12
A	quote()	0	5	3
A	setMulticurrencyCode()	0	26	5
F	printObjectLines()	0	125	31
B	fetch_barcode()	0	37	11
B	isObjectUsed()	0	51	11
B	add_object_linked()	0	33	8
A	updateLineUp()	0	17	5
A	setDocModel()	0	23	3
F	printObjectLine()	0	93	28
A	delete_resource()	0	27	4
F	setStatut()	0	70	29
A	fetchComments()	0	13	2
A	getSpecialCode()	0	8	2
A	swapContactStatus()	0	23	3
C	hasProductsOrServices()	0	15	14
B	isExistingObject()	0	26	8
D	deleteCommon()	0	68	16
F	fetch_optionals()	0	80	22
A	deleteExtraFields()	0	17	3
F	getBannerAddress()	0	107	40
A	update_note_public()	0	4	1
A	getValueFrom()	0	15	5
F	fetchObjectLinked()	0	166	58
B	getCanvas()	0	26	8
F	createCommon()	0	81	29
A	getChildrenOfLine()	0	22	3
F	liste_contact()	0	53	16
A	fetch_user()	0	7	1
A	getNbComments()	0	3	1
A	call_trigger()	0	17	3
D	setMulticurrencyRate()	0	84	19
A	line_max()	0	29	5
B	getFullName()	0	16	10
F	load_previous_next_ref()	0	109	99
F	update_price()	0	213	54
B	update_note()	0	36	9
F	insertExtraFields()	0	201	49
A	setWarehouse()	0	20	5
A	isNull()	0	6	4
A	commonReplaceThirdparty()	0	13	4
B	setIncoterms()	0	25	7
F	show_photos()	0	188	55
A	getFieldList()	0	4	1
F	showInputField()	0	506	143
A	line_up()	0	10	1
A	getTotalDiscount()	0	29	3
D	setSaveQuery()	0	41	18
A	errorsToString()	0	3	3
C	getIdContact()	0	47	12
A	isText()	0	6	4
F	updateCommon()	0	72	22
F	getTotalWeightVolume()	0	77	30
B	getFullAddress()	0	19	11
C	liste_type_contact()	0	36	11
D	defineBuyPrice()	0	51	19
A	setExtraParameters()	0	19	4
A	fetch_contact()	0	12	3
C	add_contact()	0	97	17
F	updateExtraField()	0	103	23
A	add_element_resource()	0	29	2
A	fetch_projet()	0	14	4
A	update_contact()	0	15	4
A	update_ref_ext()	0	19	4
F	deleteObjectLinked()	0	38	17
B	getDefaultCreateValueFor()	0	20	7
A	display_incoterms()	0	17	5
A	getIncotermsForPDF()	0	15	3
B	printOriginLinesList()	0	32	10
A	getRights()	0	8	2
A	__clone()	0	7	4
F	showOutputField()	0	287	82
A	getRangOfLine()	0	10	2
F	setValueFrom()	0	56	27
A	trimParameters()	0	6	4
B	fetchCommon()	0	26	9
A	fetchOneLike()	0	17	3
F	commonGenerateDocument()	0	208	46
A	delete_contact()	0	27	4
B	setPaymentMethods()	0	27	7
A	fetch_origin()	0	12	4
A	fetchObjectFrom()	0	25	4
A	line_down()	0	13	1
A	delete_linked_contact()	0	22	4
B	setBankAccount()	0	42	9
A	fetch_product()	0	12	2
C	getLastMainDocLink()	0	70	14
A	copy_linked_contact()	0	11	3
A	updateLineDown()	0	17	5
A	getListContactId()	0	12	3
D	setVarsFromFetchObj()	0	30	19
A	isIndex()	0	6	4
A	isDate()	0	4	5
A	addThumbs()	0	15	2
D	showOptionals()	0	171	54
B	setShippingMethod()	0	42	9
A	initAsSpecimenCommon()	0	3	1
A	isArray()	0	6	4
B	fetch_thirdparty()	0	27	11
A	setProject()	0	25	6
A	isInt()	0	6	5

<?php


namespace Alixar\Base;


use Alxarafe\Base\Table;

class AlixarModel extends Table
{
    /**
     * @var string    The type of originating object ('commande', 'facture', ...)
     * @see fetch_origin()
     */
    public $origin;

    /**
     * @var DoliDb        Database handler (result of a new DoliDB)

The type Alixar\Base\DoliDb was not found. Did you mean DoliDb? If so, make sure to prefix the type with \.

     */
    public $db;

    /**
     * @var int The object identifier
     */
    public $id;

    /**
     * @var string        Error string
     * @see             errors
     */
    public $error;

    /**
     * @var string[]    Array of error strings
     */
    public $errors = array();

    /**
     * @var string ID to identify managed object
     */
    public $element;

    /**
     * @var string Name of table without prefix where object is stored
     */
    public $table_element;

    /**
     * @var int    Name of subtable line
     */
    public $table_element_line = '';

    /**
     * @var string        Key value used to track if data is coming from import wizard
     */
    public $import_key;

    /**
     * @var mixed        Contains data to manage extrafields
     */
    public $array_options = array();

    /**
     * @var int[][]        Array of linked objects ids. Loaded by ->fetchObjectLinked
     */
    public $linkedObjectsIds;

    /**
     * @var mixed        Array of linked objects. Loaded by ->fetchObjectLinked
     */
    public $linkedObjects;

    /**
     * @var Object      To store a cloned copy of object before to edit it and keep track of old properties
     */
    public $oldcopy;
    /**
     * @var array<string,mixed>        Can be used to pass information when only object is provided to method
     */
    public $context = array();


    // Following vars are used by some objects only. We keep this property here in CommonObject to be able to provide common method using them.
    /**
     * @var string        Contains canvas name if record is an alternative canvas record
     */
    public $canvas;
    /**
     * @var Project The related project

The type Alixar\Base\Project was not found. Did you mean Project? If so, make sure to prefix the type with \.

     * @see fetch_projet()
     */
    public $project;
    /**
     * @var int The related project ID
     * @see setProject(), project
     */
    public $fk_project;
    /**
     * @deprecated
     * @see project
     */
    public $projet;
    /**
     * @var Contact a related contact

The type Alixar\Base\Contact was not found. Did you mean Contact? If so, make sure to prefix the type with \.

     * @see fetch_contact()
     */
    public $contact;
    /**
     * @var int The related contact ID
     * @see fetch_contact()
     */
    public $contact_id;
    /**
     * @var Societe A related thirdparty

The type Alixar\Base\Societe was not found. Did you mean Societe? If so, make sure to prefix the type with \.

     * @see fetch_thirdparty()
     */
    public $thirdparty;
    /**
     * @var User A related user
     * @see fetch_user()
     */
    public $user;
    /**
     * @var int    The id of originating object
     * @see fetch_origin()
     */
    public $origin_id;
    /**
     * @var string The object's reference
     */
    public $ref;
    /**
     * @var string The object's previous reference
     */
    public $ref_previous;
    /**
     * @var string The object's next reference
     */
    public $ref_next;
    /**
     * @var string An external reference for the object
     */
    public $ref_ext;
    /**
     * @var int The object's status
     * @see setStatut()
     */
    public $statut;
    /**
     * @var string
     * @see getFullAddress()
     */
    public $country;
    /**
     * @var int
     * @see getFullAddress(), country
     */
    public $country_id;
    /**
     * @var string
     * @see getFullAddress(), isInEEC(), country
     */
    public $country_code;
    /**
     * @var string
     * @see getFullAddress()
     */
    public $state;
    /**
     * @var int
     * @see getFullAddress(), state
     */
    public $state_id;
    /**
     * @var string
     * @see getFullAddress(), state
     */
    public $state_code;
    /**
     * @var string
     * @see getFullAddress(), region
     */
    public $region;
    /**
     * @var string
     * @see getFullAddress(), region
     */
    public $region_code;
    /**
     * @var int
     * @see fetch_barcode()
     */
    public $barcode_type;
    /**
     * @var string
     * @see fetch_barcode(), barcode_type
     */
    public $barcode_type_code;
    /**
     * @var string
     * @see fetch_barcode(), barcode_type
     */
    public $barcode_type_label;
    /**
     * @var string
     * @see fetch_barcode(), barcode_type
     */
    public $barcode_type_coder;
    /**
     * @var int Payment method ID (cheque, cash, ...)
     * @see setPaymentMethods()
     */
    public $mode_reglement_id;
    /**
     * @var int Payment terms ID
     * @see setPaymentTerms()
     */
    public $cond_reglement_id;
    /**
     * @var int Payment terms ID
     * @deprecated Kept for compatibility
     * @see cond_reglement_id;
     */
    public $cond_reglement;
    /**
     * @var int Delivery address ID
     * @deprecated
     * @see setDeliveryAddress()
     */
    public $fk_delivery_address;
    /**
     * @var int Shipping method ID
     * @see setShippingMethod()
     */
    public $shipping_method_id;
    /**
     * @var string
     * @see SetDocModel()
     */
    public $modelpdf;
    /**
     * @var int Bank account ID
     * @see SetBankAccount()
     */
    public $fk_account;
    /**
     * @var string Public note
     * @see update_note()
     */
    public $note_public;
    /**
     * @var string Private note
     * @see update_note()
     */
    public $note_private;
    /**
     * @deprecated
     * @see note_public
     */
    public $note;
    /**
     * @var float Total amount before taxes
     * @see update_price()
     */
    public $total_ht;
    /**
     * @var float Total VAT amount
     * @see update_price()
     */
    public $total_tva;
    /**
     * @var float Total local tax 1 amount
     * @see update_price()
     */
    public $total_localtax1;
    /**
     * @var float Total local tax 2 amount
     * @see update_price()
     */
    public $total_localtax2;
    /**
     * @var float Total amount with taxes
     * @see update_price()
     */
    public $total_ttc;
    /**
     * @var CommonObjectLine[]
     */
    public $lines;
    /**
     * @var mixed        Contains comments
     * @see fetchComments()
     */
    public $comments = array();
    /**
     * @var int
     * @see setIncoterms()
     */
    public $fk_incoterms;
    /**
     * @var string
     * @see SetIncoterms()
     */
    public $libelle_incoterms;
    /**
     * @var string
     * @see display_incoterms()
     */
    public $location_incoterms;
    public $name;
    public $lastname;
    public $firstname;
    public $civility_id;
    public $date_creation;

    // Dates
    public $date_validation;            // Date creation
    public $date_modification;        // Date validation
    /**
     * @var string        Column name of the ref field.
     */
    protected $table_ref_field = '';        // Date last change (tms field)


    // No constructor as it is an abstract class

    /**
     * Check an object id/ref exists
     * If you don't need/want to instantiate object and just need to know if object exists, use this method instead of fetch
     *
     * @param string $element String of element ('product', 'facture', ...)
     * @param int $id Id of object
     * @param string $ref Ref of object to check
     * @param string $ref_ext Ref ext of object to check
     * @return int                <0 if KO, 0 if OK but not found, >0 if OK and exists
     */
    static function isExistingObject($element, $id, $ref = '', $ref_ext = '')
    {
        global $db, $conf;

        $sql = "SELECT rowid, ref, ref_ext";
        $sql .= " FROM " . MAIN_DB_PREFIX . $element;
        $sql .= " WHERE entity IN (" . getEntity($element) . ")";

        if ($id > 0) $sql .= " AND rowid = " . $db->escape($id);
        else if ($ref) $sql .= " AND ref = '" . $db->escape($ref) . "'";
        else if ($ref_ext) $sql .= " AND ref_ext = '" . $db->escape($ref_ext) . "'";
        else {
            $error = 'ErrorWrongParameters';
            dol_print_error(get_class() . "::isExistingObject " . $error, LOG_ERR);
            return -1;
        }
        if ($ref || $ref_ext) $sql .= " AND entity = " . $conf->entity;

        dol_syslog(get_class() . "::isExistingObject", LOG_DEBUG);
        $resql = $db->query($sql);
        if ($resql) {
            $num = $db->num_rows($resql);
            if ($num > 0) return 1;
            else return 0;
        }
        return -1;
    }

    /**
     * Function used to replace a thirdparty id with another one.
     * This function is meant to be called from replaceThirdparty with the appropiate tables
     * Column name fk_soc MUST be used to identify thirdparties
     *
     * @param DoliDB $db Database handler
     * @param int $origin_id Old thirdparty id (the thirdparty to delete)
     * @param int $dest_id New thirdparty id (the thirdparty that will received element of the other)
     * @param string[] $tables Tables that need to be changed
     * @param int $ignoreerrors Ignore errors. Return true even if errors. We need this when replacement can fails like for categories (categorie of old thirdparty may already exists on new one)
     * @return bool                          True if success, False if error
     */
    public static function commonReplaceThirdparty(DoliDB $db, $origin_id, $dest_id, array $tables, $ignoreerrors = 0)

The type Alixar\Base\DoliDB was not found. Did you mean DoliDB? If so, make sure to prefix the type with \.

    {
        foreach ($tables as $table) {
            $sql = 'UPDATE ' . MAIN_DB_PREFIX . $table . ' SET fk_soc = ' . $dest_id . ' WHERE fk_soc = ' . $origin_id;

            if (!$db->query($sql)) {
                if ($ignoreerrors) return true;        // TODO Not enough. If there is A-B on kept thirdarty and B-C on old one, we must get A-B-C after merge. Not A-B.
                //$this->errors = $db->lasterror();
                return false;
            }
        }

        return true;
    }

    /**
     * Method to output saved errors
     *
     * @return    string        String with errors
     */
    function errorsToString()
    {
        return $this->error . (is_array($this->errors) ? (($this->error != '' ? ', ' : '') . join(', ', $this->errors)) : '');
    }

    /**
     *    Return full address for banner
     *
     * @param string $htmlkey HTML id to make banner content unique
     * @param Object $object Object (thirdparty, thirdparty of contact for contact, null for a member)
     * @return        string                            Full address string
     */
    function getBannerAddress($htmlkey, $object)
    {
        global $conf, $langs;

        $countriesusingstate = array('AU', 'US', 'IN', 'GB', 'ES', 'UK', 'TR');    // See also option MAIN_FORCE_STATE_INTO_ADDRESS

        $contactid = 0;
        $thirdpartyid = 0;
        if ($this->element == 'societe') {
            $thirdpartyid = $this->id;
        }
        if ($this->element == 'contact') {
            $contactid = $this->id;
            $thirdpartyid = $object->fk_soc;
        }
        if ($this->element == 'user') {
            $contactid = $this->contact_id;
            $thirdpartyid = $object->fk_soc;
        }

        $out = '<!-- BEGIN part to show address block -->';

        $outdone = 0;
        $coords = $this->getFullAddress(1, ', ', $conf->global->MAIN_SHOW_REGION_IN_STATE_SELECT);
        if ($coords) {
            if (!empty($conf->use_javascript_ajax)) {
                $namecoords = $this->getFullName($langs, 1) . '<br>' . $coords;
                // hideonsmatphone because copyToClipboard call jquery dialog that does not work with jmobile
                $out .= '<a href="#" class="hideonsmartphone" onclick="return copyToClipboard(\'' . dol_escape_js($namecoords) . '\',\'' . dol_escape_js($langs->trans("HelpCopyToClipboard")) . '\');">';
                $out .= img_picto($langs->trans("Address"), 'object_address.png');
                $out .= '</a> ';
            }
            $out .= dol_print_address($coords, 'address_' . $htmlkey . '_' . $this->id, $this->element, $this->id, 1, ', ');
            $outdone++;
            $outdone++;
        }

        if (!in_array($this->country_code, $countriesusingstate) && empty($conf->global->MAIN_FORCE_STATE_INTO_ADDRESS)   // If MAIN_FORCE_STATE_INTO_ADDRESS is on, state is already returned previously with getFullAddress
            && empty($conf->global->SOCIETE_DISABLE_STATE) && $this->state) {
            if (!empty($conf->global->MAIN_SHOW_REGION_IN_STATE_SELECT) && $conf->global->MAIN_SHOW_REGION_IN_STATE_SELECT == 1 && $this->region) {
                $out .= ($outdone ? ' - ' : '') . $this->region . ' - ' . $this->state;
            } else {
                $out .= ($outdone ? ' - ' : '') . $this->state;
            }
            $outdone++;
        }

        if (!empty($this->phone) || !empty($this->phone_pro) || !empty($this->phone_mobile) || !empty($this->phone_perso) || !empty($this->fax) || !empty($this->office_phone) || !empty($this->user_mobile) || !empty($this->office_fax)) $out .= ($outdone ? '<br>' : '');
        if (!empty($this->phone) && empty($this->phone_pro)) {        // For objects that store pro phone into ->phone
            $out .= dol_print_phone($this->phone, $this->country_code, $contactid, $thirdpartyid, 'AC_TEL', '&nbsp;', 'phone', $langs->trans("PhonePro"));
            $outdone++;
        }
        if (!empty($this->phone_pro)) {
            $out .= dol_print_phone($this->phone_pro, $this->country_code, $contactid, $thirdpartyid, 'AC_TEL', '&nbsp;', 'phone', $langs->trans("PhonePro"));
            $outdone++;
        }
        if (!empty($this->phone_mobile)) {
            $out .= dol_print_phone($this->phone_mobile, $this->country_code, $contactid, $thirdpartyid, 'AC_TEL', '&nbsp;', 'mobile', $langs->trans("PhoneMobile"));
            $outdone++;
        }
        if (!empty($this->phone_perso)) {
            $out .= dol_print_phone($this->phone_perso, $this->country_code, $contactid, $thirdpartyid, 'AC_TEL', '&nbsp;', 'phone', $langs->trans("PhonePerso"));
            $outdone++;
        }
        if (!empty($this->office_phone)) {
            $out .= dol_print_phone($this->office_phone, $this->country_code, $contactid, $thirdpartyid, 'AC_TEL', '&nbsp;', 'phone', $langs->trans("PhonePro"));
            $outdone++;
        }
        if (!empty($this->user_mobile)) {
            $out .= dol_print_phone($this->user_mobile, $this->country_code, $contactid, $thirdpartyid, 'AC_TEL', '&nbsp;', 'mobile', $langs->trans("PhoneMobile"));
            $outdone++;
        }
        if (!empty($this->fax)) {
            $out .= dol_print_phone($this->fax, $this->country_code, $contactid, $thirdpartyid, 'AC_FAX', '&nbsp;', 'fax', $langs->trans("Fax"));
            $outdone++;
        }
        if (!empty($this->office_fax)) {
            $out .= dol_print_phone($this->office_fax, $this->country_code, $contactid, $thirdpartyid, 'AC_FAX', '&nbsp;', 'fax', $langs->trans("Fax"));
            $outdone++;
        }

        $out .= '<div style="clear: both;"></div>';
        $outdone = 0;
        if (!empty($this->email)) {
            $out .= dol_print_email($this->email, $this->id, $object->id, 'AC_EMAIL', 0, 0, 1);
            $outdone++;
        }
        if (!empty($this->url)) {
            $out .= dol_print_url($this->url, '_goout', 0, 1);
            $outdone++;
        }
        $out .= '<div style="clear: both;">';
        if (!empty($conf->socialnetworks->enabled)) {
            if ($this->skype) $out .= dol_print_socialnetworks($this->skype, $this->id, $object->id, 'skype');
            $outdone++;
            if ($this->jabberid) $out .= dol_print_socialnetworks($this->jabberid, $this->id, $object->id, 'jabber');
            $outdone++;
            if ($this->twitter) $out .= dol_print_socialnetworks($this->twitter, $this->id, $object->id, 'twitter');
            $outdone++;
            if ($this->facebook) $out .= dol_print_socialnetworks($this->facebook, $this->id, $object->id, 'facebook');
            $outdone++;
        }
        $out .= '</div>';

        $out .= '<!-- END Part to show address block -->';

        return $out;
    }

    /**
     *    Return full address of contact
     *
     * @param int $withcountry 1=Add country into address string
     * @param string $sep Separator to use to build string
     * @param int $withregion 1=Add region into address string
     * @return        string                            Full address string
     */
    function getFullAddress($withcountry = 0, $sep = "\n", $withregion = 0)
    {
        if ($withcountry && $this->country_id && (empty($this->country_code) || empty($this->country))) {
            require_once DOL_DOCUMENT_ROOT . '/core/lib/company.lib.php';
            $tmparray = getCountry($this->country_id, 'all');
            $this->country_code = $tmparray['code'];
            $this->country = $tmparray['label'];
        }

        if ($withregion && $this->state_id && (empty($this->state_code) || empty($this->state) || empty($this->region) || empty($this->region_cpde))) {
            require_once DOL_DOCUMENT_ROOT . '/core/lib/company.lib.php';
            $tmparray = getState($this->state_id, 'all', 0, 1);
            $this->state_code = $tmparray['code'];
            $this->state = $tmparray['label'];
            $this->region_code = $tmparray['region_code'];
            $this->region = $tmparray['region'];
        }

        return dol_format_address($this, $withcountry, $sep);
    }

    /**
     *    Return full name (civility+' '+name+' '+lastname)
     *
     * @param Translate $langs Language object for translation of civility (used only if option is 1)
     * @param int $option 0=No option, 1=Add civility
     * @param int $nameorder -1=Auto, 0=Lastname+Firstname, 1=Firstname+Lastname, 2=Firstname
     * @param int $maxlen Maximum length
     * @return    string                        String with full name
     */
    function getFullName($langs, $option = 0, $nameorder = -1, $maxlen = 0)
    {
        //print "lastname=".$this->lastname." name=".$this->name." nom=".$this->nom."<br>\n";
        $lastname = $this->lastname;
        $firstname = $this->firstname;
        if (empty($lastname)) $lastname = (isset($this->lastname) ? $this->lastname : (isset($this->name) ? $this->name : (isset($this->nom) ? $this->nom : (isset($this->societe) ? $this->societe : (isset($this->company) ? $this->company : '')))));

        $ret = '';
        if ($option && $this->civility_id) {
            if ($langs->transnoentitiesnoconv("Civility" . $this->civility_id) != "Civility" . $this->civility_id) $ret .= $langs->transnoentitiesnoconv("Civility" . $this->civility_id) . ' ';
            else $ret .= $this->civility_id . ' ';
        }

        $ret .= dolGetFirstLastname($firstname, $lastname, $nameorder);

        return dol_trunc($ret, $maxlen);
    }


    // phpcs:disable PEAR.NamingConventions.ValidFunctionName.NotCamelCaps

    /**
     * Return the link of last main doc file for direct public download.
     *
     * @param string $modulepart Module related to document
     * @param int $initsharekey Init the share key if it was not yet defined
     * @param int $relativelink 0=Return full external link, 1=Return link relative to root of file
     * @return    string                        Link or empty string if there is no download link
     */
    function getLastMainDocLink($modulepart, $initsharekey = 0, $relativelink = 0)
    {
        global $user, $dolibarr_main_url_root;

        if (empty($this->last_main_doc)) {
            return '';        // No way to known which document name to use
        }

        include_once DOL_DOCUMENT_ROOT . '/ecm/class/ecmfiles.class.php';
        $ecmfile = new EcmFiles($this->db);

The type Alixar\Base\EcmFiles was not found. Did you mean EcmFiles? If so, make sure to prefix the type with \.

        $result = $ecmfile->fetch(0, '', $this->last_main_doc);
        if ($result < 0) {
            $this->error = $ecmfile->error;
            $this->errors = $ecmfile->errors;
            return -1;
        }

        if (empty($ecmfile->id)) {
            // Add entry into index
            if ($initsharekey) {
                require_once DOL_DOCUMENT_ROOT . '/core/lib/security2.lib.php';
                // TODO We can't, we dont' have full path of file, only last_main_doc adn ->element, so we must rebuild full path first
                /*
				$ecmfile->filepath = $rel_dir;
				$ecmfile->filename = $filename;
				$ecmfile->label = md5_file(dol_osencode($destfull));	// hash of file content
				$ecmfile->fullpath_orig = '';
				$ecmfile->gen_or_uploaded = 'generated';
				$ecmfile->description = '';    // indexed content
				$ecmfile->keyword = '';        // keyword content
				$ecmfile->share = getRandomPassword(true);
				$result = $ecmfile->create($user);
				if ($result < 0)
				{
					$this->error = $ecmfile->error;
					$this->errors = $ecmfile->errors;
				}
				*/
            } else return '';
        } elseif (empty($ecmfile->share)) {
            // Add entry into index
            if ($initsharekey) {
                require_once DOL_DOCUMENT_ROOT . '/core/lib/security2.lib.php';
                $ecmfile->share = getRandomPassword(true);
                $ecmfile->update($user);
            } else return '';
        }

        // Define $urlwithroot
        $urlwithouturlroot = preg_replace('/' . preg_quote(DOL_URL_ROOT, '/') . '$/i', '', trim($dolibarr_main_url_root));
        $urlwithroot = $urlwithouturlroot . DOL_URL_ROOT;        // This is to use external domain name found into config file
        //$urlwithroot=DOL_MAIN_URL_ROOT;					// This is to use same domain name than current

        $forcedownload = 0;

        $paramlink = '';
        //if (! empty($modulepart)) $paramlink.=($paramlink?'&':'').'modulepart='.$modulepart;		// For sharing with hash (so public files), modulepart is not required.
        //if (! empty($ecmfile->entity)) $paramlink.='&entity='.$ecmfile->entity; 					// For sharing with hash (so public files), entity is not required.
        //$paramlink.=($paramlink?'&':'').'file='.urlencode($filepath);								// No need of name of file for public link, we will use the hash
        if (!empty($ecmfile->share)) $paramlink .= ($paramlink ? '&' : '') . 'hashp=' . $ecmfile->share;            // Hash for public share
        if ($forcedownload) $paramlink .= ($paramlink ? '&' : '') . 'attachment=1';

        if ($relativelink) {
            $linktoreturn = 'document.php' . ($paramlink ? '?' . $paramlink : '');
        } else {
            $linktoreturn = $urlwithroot . '/document.php' . ($paramlink ? '?' . $paramlink : '');
        }

        // Here $ecmfile->share is defined
        return $linktoreturn;
    }

    // phpcs:disable PEAR.NamingConventions.ValidFunctionName.NotCamelCaps

    /**
     *    Copy contact from one element to current
     *
     * @param CommonObject $objFrom Source element

The type Alixar\Base\CommonObject was not found. Did you mean CommonObject? If so, make sure to prefix the type with \.

     * @param string $source Nature of contact ('internal' or 'external')
     * @return   int                         >0 if OK, <0 if KO
     */
    function copy_linked_contact($objFrom, $source = 'internal')
    {
        // phpcs:enable
        $contacts = $objFrom->liste_contact(-1, $source);
        foreach ($contacts as $contact) {
            if ($this->add_contact($contact['id'], $contact['fk_c_type_contact'], $contact['source']) < 0) {
                $this->error = $this->db->lasterror();
                return -1;
            }
        }
        return 1;
    }

    // phpcs:disable PEAR.NamingConventions.ValidFunctionName.NotCamelCaps

    /**
     *  Add a link between element $this->element and a contact
     *
     * @param int $fk_socpeople Id of thirdparty contact (if source = 'external') or id of user (if souce = 'internal') to link
     * @param int $type_contact Type of contact (code or id). Must be id or code found into table llx_c_type_contact. For example: SALESREPFOLL
     * @param string $source external=Contact extern (llx_socpeople), internal=Contact intern (llx_user)
     * @param int $notrigger Disable all triggers
     * @return int                        <0 if KO, >0 if OK
     */
    function add_contact($fk_socpeople, $type_contact, $source = 'external', $notrigger = 0)
    {
        // phpcs:enable
        global $user, $langs;


        dol_syslog(get_class($this) . "::add_contact $fk_socpeople, $type_contact, $source, $notrigger");

        // Check parameters
        if ($fk_socpeople <= 0) {
            $langs->load("errors");
            $this->error = $langs->trans("ErrorWrongValueForParameterX", "1");
            dol_syslog(get_class($this) . "::add_contact " . $this->error, LOG_ERR);
            return -1;
        }
        if (!$type_contact) {
            $langs->load("errors");
            $this->error = $langs->trans("ErrorWrongValueForParameterX", "2");
            dol_syslog(get_class($this) . "::add_contact " . $this->error, LOG_ERR);
            return -2;
        }

        $id_type_contact = 0;
        if (is_numeric($type_contact)) {
            $id_type_contact = $type_contact;
        } else {
            // We look for id type_contact
            $sql = "SELECT tc.rowid";
            $sql .= " FROM " . MAIN_DB_PREFIX . "c_type_contact as tc";
            $sql .= " WHERE tc.element='" . $this->db->escape($this->element) . "'";
            $sql .= " AND tc.source='" . $this->db->escape($source) . "'";
            $sql .= " AND tc.code='" . $this->db->escape($type_contact) . "' AND tc.active=1";
            //print $sql;
            $resql = $this->db->query($sql);
            if ($resql) {
                $obj = $this->db->fetch_object($resql);
                if ($obj) $id_type_contact = $obj->rowid;
            }
        }

        if ($id_type_contact == 0) {
            $this->error = 'CODE_NOT_VALID_FOR_THIS_ELEMENT';
            dol_syslog("CODE_NOT_VALID_FOR_THIS_ELEMENT: Code type of contact '" . $type_contact . "' does not exists or is not active for element " . $this->element . ", we can ignore it");
            return -3;
        }

        $datecreate = dol_now();

        // Socpeople must have already been added by some trigger, then we have to check it to avoid DB_ERROR_RECORD_ALREADY_EXISTS error
        $TListeContacts = $this->liste_contact(-1, $source);
        $already_added = false;
        if (!empty($TListeContacts)) {
            foreach ($TListeContacts as $array_contact) {
                if ($array_contact['status'] == 4 && $array_contact['id'] == $fk_socpeople && $array_contact['fk_c_type_contact'] == $id_type_contact) {
                    $already_added = true;
                    break;
                }
            }
        }

        if (!$already_added) {

            $this->db->begin();

            // Insert into database
            $sql = "INSERT INTO " . MAIN_DB_PREFIX . "element_contact";
            $sql .= " (element_id, fk_socpeople, datecreate, statut, fk_c_type_contact) ";
            $sql .= " VALUES (" . $this->id . ", " . $fk_socpeople . " , ";
            $sql .= "'" . $this->db->idate($datecreate) . "'";
            $sql .= ", 4, " . $id_type_contact;
            $sql .= ")";

            $resql = $this->db->query($sql);
            if ($resql) {
                if (!$notrigger) {
                    $result = $this->call_trigger(strtoupper($this->element) . '_ADD_CONTACT', $user);
                    if ($result < 0) {
                        $this->db->rollback();
                        return -1;
                    }
                }

                $this->db->commit();
                return 1;
            } else {
                if ($this->db->errno() == 'DB_ERROR_RECORD_ALREADY_EXISTS') {
                    $this->error = $this->db->errno();
                    $this->db->rollback();
                    echo 'err rollback';
                    return -2;
                } else {
                    $this->error = $this->db->error();
                    $this->db->rollback();
                    return -1;
                }
            }
        } else return 0;
    }

    // phpcs:disable PEAR.NamingConventions.ValidFunctionName.NotCamelCaps

    /**
     *    Get array of all contacts for an object
     *
     * @param int $statut Status of links to get (-1=all)
     * @param string $source Source of contact: external or thirdparty (llx_socpeople) or internal (llx_user)
     * @param int $list 0:Return array contains all properties, 1:Return array contains just id
     * @param string $code Filter on this code of contact type ('SHIPPING', 'BILLING', ...)
     * @return    array|int                Array of contacts, -1 if error
     */
    function liste_contact($statut = -1, $source = 'external', $list = 0, $code = '')
    {
        // phpcs:enable
        global $langs;

        $tab = array();

        $sql = "SELECT ec.rowid, ec.statut as statuslink, ec.fk_socpeople as id, ec.fk_c_type_contact";    // This field contains id of llx_socpeople or id of llx_user
        if ($source == 'internal') $sql .= ", '-1' as socid, t.statut as statuscontact, t.login, t.photo";
        if ($source == 'external' || $source == 'thirdparty') $sql .= ", t.fk_soc as socid, t.statut as statuscontact";
        $sql .= ", t.civility as civility, t.lastname as lastname, t.firstname, t.email";
        $sql .= ", tc.source, tc.element, tc.code, tc.libelle";
        $sql .= " FROM " . MAIN_DB_PREFIX . "c_type_contact tc";
        $sql .= ", " . MAIN_DB_PREFIX . "element_contact ec";
        if ($source == 'internal') $sql .= " LEFT JOIN " . MAIN_DB_PREFIX . "user t on ec.fk_socpeople = t.rowid";
        if ($source == 'external' || $source == 'thirdparty') $sql .= " LEFT JOIN " . MAIN_DB_PREFIX . "socpeople t on ec.fk_socpeople = t.rowid";
        $sql .= " WHERE ec.element_id =" . $this->id;
        $sql .= " AND ec.fk_c_type_contact=tc.rowid";
        $sql .= " AND tc.element='" . $this->db->escape($this->element) . "'";
        if ($code) $sql .= " AND tc.code = '" . $this->db->escape($code) . "'";
        if ($source == 'internal') $sql .= " AND tc.source = 'internal'";
        if ($source == 'external' || $source == 'thirdparty') $sql .= " AND tc.source = 'external'";
        $sql .= " AND tc.active=1";
        if ($statut >= 0) $sql .= " AND ec.statut = '" . $statut . "'";
        $sql .= " ORDER BY t.lastname ASC";

        dol_syslog(get_class($this) . "::liste_contact", LOG_DEBUG);
        $resql = $this->db->query($sql);
        if ($resql) {
            $num = $this->db->num_rows($resql);
            $i = 0;
            while ($i < $num) {
                $obj = $this->db->fetch_object($resql);

                if (!$list) {
                    $transkey = "TypeContact_" . $obj->element . "_" . $obj->source . "_" . $obj->code;
                    $libelle_type = ($langs->trans($transkey) != $transkey ? $langs->trans($transkey) : $obj->libelle);
                    $tab[$i] = array('source' => $obj->source, 'socid' => $obj->socid, 'id' => $obj->id,
                        'nom' => $obj->lastname,      // For backward compatibility
                        'civility' => $obj->civility, 'lastname' => $obj->lastname, 'firstname' => $obj->firstname, 'email' => $obj->email, 'login' => $obj->login, 'photo' => $obj->photo, 'statuscontact' => $obj->statuscontact,
                        'rowid' => $obj->rowid, 'code' => $obj->code, 'libelle' => $libelle_type, 'status' => $obj->statuslink, 'fk_c_type_contact' => $obj->fk_c_type_contact);
                } else {
                    $tab[$i] = $obj->id;
                }

                $i++;
            }

            return $tab;
        } else {
            $this->error = $this->db->lasterror();
            dol_print_error($this->db);
            return -1;
        }
    }

    // phpcs:disable PEAR.NamingConventions.ValidFunctionName.NotCamelCaps

    /**
     * Call trigger based on this instance.
     * Some context information may also be provided into array property this->context.
     * NB:  Error from trigger are stacked in interface->errors
     * NB2: If return code of triggers are < 0, action calling trigger should cancel all transaction.
     *
     * @param string $trigger_name trigger's name to execute
     * @param User $user Object user
     * @return  int                       Result of run_triggers
     */
    function call_trigger($trigger_name, $user)
    {
        // phpcs:enable
        global $langs, $conf;

        include_once DOL_DOCUMENT_ROOT . '/core/class/interfaces.class.php';
        $interface = new Interfaces($this->db);

The type Alixar\Base\Interfaces was not found. Did you mean Interfaces? If so, make sure to prefix the type with \.

        $result = $interface->run_triggers($trigger_name, $this, $user, $langs, $conf);

        if ($result < 0) {
            if (!empty($this->errors)) {
                $this->errors = array_unique(array_merge($this->errors, $interface->errors));   // We use array_unique because when a trigger call another trigger on same object, this->errors is added twice.
            } else {
                $this->errors = $interface->errors;
            }
        }
        return $result;
    }

    // phpcs:disable PEAR.NamingConventions.ValidFunctionName.NotCamelCaps

    /**
     *    Delete a link to contact line
     *
     * @param int $rowid Id of contact link line to delete
     * @param int $notrigger Disable all triggers
     * @return   int                        >0 if OK, <0 if KO
     */
    function delete_contact($rowid, $notrigger = 0)
    {
        // phpcs:enable
        global $user;


        $this->db->begin();

        $sql = "DELETE FROM " . MAIN_DB_PREFIX . "element_contact";
        $sql .= " WHERE rowid =" . $rowid;

        dol_syslog(get_class($this) . "::delete_contact", LOG_DEBUG);
        if ($this->db->query($sql)) {
            if (!$notrigger) {
                $result = $this->call_trigger(strtoupper($this->element) . '_DELETE_CONTACT', $user);
                if ($result < 0) {
                    $this->db->rollback();
                    return -1;
                }
            }

            $this->db->commit();
            return 1;
        } else {
            $this->error = $this->db->lasterror();
            $this->db->rollback();
            return -1;
        }
    }

    /**
     *    Delete all links between an object $this and all its contacts
     *
     * @param string $source '' or 'internal' or 'external'
     * @param string $code Type of contact (code or id)
     * @return   int                    >0 if OK, <0 if KO
     */
    function delete_linked_contact($source = '', $code = '')
    {
        // phpcs:enable
        $temp = array();
        $typeContact = $this->liste_type_contact($source, '', 0, 0, $code);

        foreach ($typeContact as $key => $value) {
            array_push($temp, $key);
        }
        $listId = implode(",", $temp);

        $sql = "DELETE FROM " . MAIN_DB_PREFIX . "element_contact";
        $sql .= " WHERE element_id = " . $this->id;
        if ($listId)
            $sql .= " AND fk_c_type_contact IN (" . $listId . ")";

        dol_syslog(get_class($this) . "::delete_linked_contact", LOG_DEBUG);
        if ($this->db->query($sql)) {
            return 1;
        } else {
            $this->error = $this->db->lasterror();
            return -1;
        }
    }

    // phpcs:disable PEAR.NamingConventions.ValidFunctionName.NotCamelCaps

    /**
     *      Return array with list of possible values for type of contacts
     *
     * @param string $source 'internal', 'external' or 'all'
     * @param string $order Sort order by : 'position', 'code', 'rowid'...
     * @param int $option 0=Return array id->label, 1=Return array code->label
     * @param int $activeonly 0=all status of contact, 1=only the active
     * @param string $code Type of contact (Example: 'CUSTOMER', 'SERVICE')
     * @return array            Array list of type of contacts (id->label if option=0, code->label if option=1)
     */
    function liste_type_contact($source = 'internal', $order = 'position', $option = 0, $activeonly = 0, $code = '')
    {
        // phpcs:enable
        global $langs;

        if (empty($order)) $order = 'position';
        if ($order == 'position') $order .= ',code';

        $tab = array();
        $sql = "SELECT DISTINCT tc.rowid, tc.code, tc.libelle, tc.position";
        $sql .= " FROM " . MAIN_DB_PREFIX . "c_type_contact as tc";
        $sql .= " WHERE tc.element='" . $this->db->escape($this->element) . "'";
        if ($activeonly == 1) $sql .= " AND tc.active=1"; // only the active types
        if (!empty($source) && $source != 'all') $sql .= " AND tc.source='" . $this->db->escape($source) . "'";
        if (!empty($code)) $sql .= " AND tc.code='" . $this->db->escape($code) . "'";
        $sql .= $this->db->order($order, 'ASC');

        //print "sql=".$sql;
        $resql = $this->db->query($sql);
        if ($resql) {