dolibarr 23.0.4
adherent.class.php
Go to the documentation of this file.
1<?php
2/* Copyright (C) 2002-2003 Rodolphe Quiedeville <rodolphe@quiedeville.org>
3 * Copyright (C) 2002-2003 Jean-Louis Bergamo <jlb@j1b.org>
4 * Copyright (C) 2004-2012 Laurent Destailleur <eldy@users.sourceforge.net>
5 * Copyright (C) 2004 Sebastien Di Cintio <sdicintio@ressource-toi.org>
6 * Copyright (C) 2004 Benoit Mortier <benoit.mortier@opensides.be>
7 * Copyright (C) 2009-2017 Regis Houssin <regis.houssin@inodbox.com>
8 * Copyright (C) 2014-2018 Alexandre Spangaro <alexandre@inovea-conseil.com>
9 * Copyright (C) 2015 Marcos García <marcosgdf@gmail.com>
10 * Copyright (C) 2015-2026 Frédéric France <frederic.france@free.fr>
11 * Copyright (C) 2015 Raphaël Doursenaud <rdoursenaud@gpcsolutions.fr>
12 * Copyright (C) 2016 Juanjo Menent <jmenent@2byte.es>
13 * Copyright (C) 2018-2019 Thibault FOUCART <support@ptibogxiv.net>
14 * Copyright (C) 2019 Nicolas ZABOURI <info@inovea-conseil.com>
15 * Copyright (C) 2020 Josep Lluís Amador <joseplluis@lliuretic.cat>
16 * Copyright (C) 2021 Waël Almoman <info@almoman.com>
17 * Copyright (C) 2021 Philippe Grand <philippe.grand@atoo-net.com>
18 * Copyright (C) 2024-2025 MDW <mdeweerd@users.noreply.github.com>
19 *
20 * This program is free software; you can redistribute it and/or modify
21 * it under the terms of the GNU General Public License as published by
22 * the Free Software Foundation; either version 3 of the License, or
23 * (at your option) any later version.
24 *
25 * This program is distributed in the hope that it will be useful,
26 * but WITHOUT ANY WARRANTY; without even the implied warranty of
27 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
28 * GNU General Public License for more details.
29 *
30 * You should have received a copy of the GNU General Public License
31 * along with this program. If not, see <https://www.gnu.org/licenses/>.
32 */
33
39require_once DOL_DOCUMENT_ROOT.'/core/class/commonobject.class.php';
40require_once DOL_DOCUMENT_ROOT.'/core/lib/date.lib.php';
41require_once DOL_DOCUMENT_ROOT.'/categories/class/categorie.class.php';
42require_once DOL_DOCUMENT_ROOT.'/core/class/commonpeople.class.php';
43
44
49{
50 use CommonPeople;
51
55 public $element = 'member';
56
60 public $table_element = 'adherent';
61
65 public $picto = 'member';
66
70 public $mesgs;
71
75 public $login;
76
80 public $pass;
81
85 public $pass_indatabase;
86
90 public $pass_indatabase_crypted;
91
95 public $fullname;
96
101 public $civility_id;
102
106 public $civility_code;
107
111 public $civility;
112
118 public $societe;
119
123 public $company;
124
130 public $fk_soc;
131
135 public $socid;
136
140 public $socialnetworks;
141
145 public $phone;
146
150 public $phone_perso;
151
155 public $phone_pro;
156
160 public $phone_mobile;
161
165 public $fax;
166
170 public $poste;
171
175 public $morphy;
176
180 public $public;
181
186 public $default_lang;
187
191 public $photo;
192
198 public $datec;
199
205 public $datem;
206
210 public $datevalid;
211
215 public $gender;
216
220 public $birth;
221
225 public $typeid;
226
230 public $type;
231
235 public $need_subscription;
236
240 public $user_id;
241
245 public $user_login;
246
250 public $datefin;
251
252
253 // Fields loaded by fetch_subscriptions() from member table
254
258 public $first_subscription_date;
259
263 public $first_subscription_date_start;
264
268 public $first_subscription_date_end;
269
273 public $first_subscription_amount;
274
278 public $last_subscription_date;
279
283 public $last_subscription_date_start;
284
288 public $last_subscription_date_end;
289
293 public $last_subscription_amount;
294
298 public $subscriptions = array();
299
303 public $ip;
304
305 // Fields loaded by fetchPartnerships() from partnership table
306
310 public $partnerships = array();
311
315 public $invoice;
316
358 public $fields = array(
359 'rowid' => array('type' => 'integer', 'label' => 'TechnicalID', 'enabled' => 1, 'visible' => -1, 'notnull' => 1, 'position' => 10),
360 'ref' => array('type' => 'varchar(30)', 'label' => 'Ref', 'default' => '1', 'enabled' => 1, 'visible' => 1, 'notnull' => 1, 'position' => 12, 'index' => 1),
361 'entity' => array('type' => 'integer', 'label' => 'Entity', 'default' => '1', 'enabled' => 1, 'visible' => 3, 'notnull' => 1, 'position' => 15, 'index' => 1),
362 'ref_ext' => array('type' => 'varchar(128)', 'label' => 'RefExt', 'enabled' => 1, 'visible' => 0, 'position' => 20),
363 'civility' => array('type' => 'varchar(6)', 'label' => 'Civility', 'enabled' => 1, 'visible' => -1, 'position' => 25),
364 'lastname' => array('type' => 'varchar(50)', 'label' => 'Lastname', 'enabled' => 1, 'visible' => 1, 'position' => 30, 'showoncombobox' => 1),
365 'firstname' => array('type' => 'varchar(50)', 'label' => 'Firstname', 'enabled' => 1, 'visible' => 1, 'position' => 35, 'showoncombobox' => 1),
366 'login' => array('type' => 'varchar(50)', 'label' => 'Login', 'enabled' => 1, 'visible' => 1, 'position' => 40),
367 'pass' => array('type' => 'varchar(50)', 'label' => 'Pass', 'enabled' => 1, 'visible' => 3, 'position' => 45),
368 'pass_crypted' => array('type' => 'varchar(128)', 'label' => 'Pass crypted', 'enabled' => 1, 'visible' => 3, 'position' => 50),
369 'morphy' => array('type' => 'varchar(3)', 'label' => 'MemberNature', 'enabled' => 1, 'visible' => 1, 'notnull' => 1, 'position' => 55),
370 'fk_adherent_type' => array('type' => 'integer', 'label' => 'MemberType', 'enabled' => 1, 'visible' => 1, 'notnull' => 1, 'position' => 60),
371 'societe' => array('type' => 'varchar(128)', 'label' => 'Societe', 'enabled' => 1, 'visible' => 1, 'position' => 65, 'showoncombobox' => 2),
372 'fk_soc' => array('type' => 'integer:Societe:societe/class/societe.class.php', 'label' => 'LinkedToDolibarrThirdParty', 'enabled' => 1, 'visible' => 1, 'position' => 70),
373 'address' => array('type' => 'text', 'label' => 'Address', 'enabled' => 1, 'visible' => -1, 'position' => 75),
374 'zip' => array('type' => 'varchar(10)', 'label' => 'Zip', 'enabled' => 1, 'visible' => -1, 'position' => 80),
375 'town' => array('type' => 'varchar(50)', 'label' => 'Town', 'enabled' => 1, 'visible' => -1, 'position' => 85),
376 'state_id' => array('type' => 'integer', 'label' => 'State', 'enabled' => 1, 'visible' => -1, 'position' => 90),
377 'country' => array('type' => 'integer:Ccountry:core/class/ccountry.class.php', 'label' => 'Country', 'enabled' => 1, 'visible' => 1, 'position' => 95),
378 'phone' => array('type' => 'varchar(30)', 'label' => 'Phone', 'enabled' => 1, 'visible' => -1, 'position' => 115),
379 'phone_perso' => array('type' => 'varchar(30)', 'label' => 'Phone perso', 'enabled' => 1, 'visible' => -1, 'position' => 120),
380 'phone_mobile' => array('type' => 'varchar(30)', 'label' => 'Phone mobile', 'enabled' => 1, 'visible' => -1, 'position' => 125),
381 'email' => array('type' => 'varchar(255)', 'label' => 'Email', 'enabled' => 1, 'visible' => 1, 'position' => 126),
382 'url' => array('type' => 'varchar(255)', 'label' => 'Url', 'enabled' => 1, 'visible' => -1, 'position' => 127),
383 'socialnetworks' => array('type' => 'text', 'label' => 'Socialnetworks', 'enabled' => 1, 'visible' => 3, 'position' => 128),
384 'birth' => array('type' => 'date', 'label' => 'DateOfBirth', 'enabled' => 1, 'visible' => -1, 'position' => 130),
385 'gender' => array('type' => 'varchar(10)', 'label' => 'Gender', 'enabled' => 1, 'visible' => -1, 'position' => 132),
386 'photo' => array('type' => 'varchar(255)', 'label' => 'Photo', 'enabled' => 1, 'visible' => -1, 'position' => 135),
387 'public' => array('type' => 'smallint(6)', 'label' => 'Public', 'enabled' => 1, 'visible' => 3, 'notnull' => 1, 'position' => 145),
388 'datefin' => array('type' => 'datetime', 'label' => 'DateEnd', 'enabled' => 1, 'visible' => 1, 'position' => 150),
389 'default_lang' => array('type' => 'varchar(6)', 'label' => 'Default lang', 'enabled' => 1, 'visible' => -1, 'position' => 153),
390 'note_public' => array('type' => 'text', 'label' => 'NotePublic', 'enabled' => 1, 'visible' => 0, 'position' => 155),
391 'note_private' => array('type' => 'text', 'label' => 'NotePrivate', 'enabled' => 1, 'visible' => 0, 'position' => 160),
392 'datevalid' => array('type' => 'datetime', 'label' => 'DateValidation', 'enabled' => 1, 'visible' => -1, 'position' => 165),
393 'datec' => array('type' => 'datetime', 'label' => 'DateCreation', 'enabled' => 1, 'visible' => -1, 'position' => 170),
394 'tms' => array('type' => 'timestamp', 'label' => 'DateModification', 'enabled' => 1, 'visible' => -1, 'notnull' => 1, 'position' => 175),
395 'fk_user_author' => array('type' => 'integer:User:user/class/user.class.php', 'label' => 'UserCreation', 'enabled' => 1, 'visible' => 3, 'position' => 180),
396 'fk_user_mod' => array('type' => 'integer:User:user/class/user.class.php', 'label' => 'UserModification', 'enabled' => 1, 'visible' => 3, 'position' => 185),
397 'fk_user_valid' => array('type' => 'integer:User:user/class/user.class.php', 'label' => 'UserValidation', 'enabled' => 1, 'visible' => 3, 'position' => 190),
398 'canvas' => array('type' => 'varchar(32)', 'label' => 'Canvas', 'enabled' => 1, 'visible' => 0, 'position' => 195),
399 'model_pdf' => array('type' => 'varchar(255)', 'label' => 'Model pdf', 'enabled' => 1, 'visible' => 0, 'position' => 800),
400 'import_key' => array('type' => 'varchar(14)', 'label' => 'ImportId', 'enabled' => 1, 'visible' => -2, 'position' => 805),
401 'statut' => array('type' => 'smallint(6)', 'label' => 'Statut', 'enabled' => 1, 'visible' => 1, 'notnull' => 1, 'position' => 1000, 'arrayofkeyval' => array(-1 => 'Draft', 1 => 'Validated', 0 => 'MemberStatusResiliatedShort', -2 => 'MemberStatusExcludedShort'))
402 );
403
407 const STATUS_DRAFT = -1;
419 const STATUS_EXCLUDED = -2;
420
421
427 public function __construct($db)
428 {
429 $this->db = $db;
430 $this->statut = self::STATUS_DRAFT;
431 $this->status = self::STATUS_DRAFT;
432 // l'adherent n'est pas public par default
433 $this->public = 0;
434 $this->ismultientitymanaged = 1;
435 $this->isextrafieldmanaged = 1;
436 // les champs optionnels sont vides
437 $this->array_options = array();
438
439 $this->fields['ref_ext']['visible'] = getDolGlobalInt('MAIN_LIST_SHOW_REF_EXT');
440 }
441
442
443 // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps
462 public function send_an_email($text, $subject, $filename_list = array(), $mimetype_list = array(), $mimefilename_list = array(), $addr_cc = "", $addr_bcc = "", $deliveryreceipt = 0, $msgishtml = -1, $errors_to = '', $moreinheader = '')
463 {
464 // phpcs:enable
465 dol_syslog('Warning using deprecated Adherent::send_an_email', LOG_WARNING);
466
467 return $this->sendEmail($text, $subject, $filename_list, $mimetype_list, $mimefilename_list, $addr_cc, $addr_bcc, $deliveryreceipt, $msgishtml, $errors_to, $moreinheader);
468 }
469
487 public function sendEmail($text, $subject, $filename_list = array(), $mimetype_list = array(), $mimefilename_list = array(), $addr_cc = "", $addr_bcc = "", $deliveryreceipt = 0, $msgishtml = -1, $errors_to = '', $moreinheader = '')
488 {
489 global $conf, $langs;
490
491 // Detect if message is HTML
492 if ($msgishtml == -1) {
493 $msgishtml = 0;
494 if (dol_textishtml($text, 0)) {
495 $msgishtml = 1;
496 }
497 }
498
499 dol_syslog('sendEmail msgishtml='.$msgishtml);
500
501 $texttosend = $this->makeSubstitution($text);
502 $subjecttosend = $this->makeSubstitution($subject);
503 if ($msgishtml) {
504 $texttosend = dol_htmlentitiesbr($texttosend);
505 }
506
507 // Send mail confirmation
508 $from = getDolGlobalString('ADHERENT_MAIL_FROM', $conf->email_from);
509
510 $trackid = 'mem'.$this->id;
511
512 // Send email (substitutionarray must be done just before this)
513 include_once DOL_DOCUMENT_ROOT.'/core/class/CMailFile.class.php';
514 $mailfile = new CMailFile($subjecttosend, (string) $this->email, $from, $texttosend, $filename_list, $mimetype_list, $mimefilename_list, $addr_cc, $addr_bcc, $deliveryreceipt, $msgishtml, '', '', $trackid, $moreinheader);
515 if ($mailfile->sendfile()) {
516 return 1;
517 } else {
518 $this->error = $langs->trans("ErrorFailedToSendMail", $from, (string) $this->email).'. '.$mailfile->error;
519 return -1;
520 }
521 }
522
523
530 public function makeSubstitution($text)
531 {
532 global $langs;
533
534 $birthday = dol_print_date($this->birth, 'day');
535 $photo = isset($this->photo) ? $this->photo : '';
536 $login = isset($this->login) ? $this->login : '';
537 $type = isset($this->type) ? $this->type : '';
538 $pass = isset($this->pass) ? $this->pass : '';
539
540 $msgishtml = 0;
541 if (dol_textishtml($text, 1)) {
542 $msgishtml = 1;
543 }
544
545 $infos = '';
546 if ($this->civility_id) {
547 $infos .= $langs->transnoentities("UserTitle").": ".$this->getCivilityLabel()."\n";
548 }
549 $infos .= $langs->transnoentities("Id").": ".$this->id."\n";
550 $infos .= $langs->transnoentities("Ref").": ".$this->ref."\n";
551 $infos .= $langs->transnoentities("Lastname").": ".$this->lastname."\n";
552 $infos .= $langs->transnoentities("Firstname").": ".$this->firstname."\n";
553 $infos .= $langs->transnoentities("Company").": ".$this->company."\n";
554 $infos .= $langs->transnoentities("Address").": ".$this->address."\n";
555 $infos .= $langs->transnoentities("Zip").": ".$this->zip."\n";
556 $infos .= $langs->transnoentities("Town").": ".$this->town."\n";
557 $infos .= $langs->transnoentities("Country").": ".$this->country."\n";
558 $infos .= $langs->transnoentities("EMail").": ".$this->email."\n";
559 $infos .= $langs->transnoentities("PhonePro").": ".$this->phone."\n";
560 $infos .= $langs->transnoentities("PhonePerso").": ".$this->phone_perso."\n";
561 $infos .= $langs->transnoentities("PhoneMobile").": ".$this->phone_mobile."\n";
562 if (!getDolGlobalString('ADHERENT_LOGIN_NOT_REQUIRED')) {
563 $infos .= $langs->transnoentities("Login").": ".$login."\n";
564 $infos .= $langs->transnoentities("Password").": ".$pass."\n";
565 }
566 $infos .= $langs->transnoentities("Birthday").": ".$birthday."\n";
567 $infos .= $langs->transnoentities("Photo").": ".$photo."\n";
568 $infos .= $langs->transnoentities("Public").": ".yn($this->public);
569
570 // Substitutions
571 $substitutionarray = array(
572 '__ID__' => $this->id,
573 '__REF__' => $this->ref,
574 '__MEMBER_ID__' => $this->id,
575 '__CIVILITY__' => $this->getCivilityLabel(),
576 '__FIRSTNAME__' => $msgishtml ? dol_htmlentitiesbr($this->firstname) : ($this->firstname ? $this->firstname : ''),
577 '__LASTNAME__' => $msgishtml ? dol_htmlentitiesbr($this->lastname) : ($this->lastname ? $this->lastname : ''),
578 '__FULLNAME__' => $msgishtml ? dol_htmlentitiesbr($this->getFullName($langs)) : $this->getFullName($langs),
579 '__COMPANY__' => $msgishtml ? dol_htmlentitiesbr((string) $this->company) : ($this->company ? $this->company : ''),
580 '__ADDRESS__' => $msgishtml ? dol_htmlentitiesbr((string) $this->address) : ($this->address ? $this->address : ''),
581 '__ZIP__' => $msgishtml ? dol_htmlentitiesbr((string) $this->zip) : ($this->zip ? $this->zip : ''),
582 '__TOWN__' => $msgishtml ? dol_htmlentitiesbr((string) $this->town) : ($this->town ? $this->town : ''),
583 '__COUNTRY__' => $msgishtml ? dol_htmlentitiesbr($this->country) : ($this->country ? $this->country : ''),
584 '__EMAIL__' => $msgishtml ? dol_htmlentitiesbr((string) $this->email) : ($this->email ? $this->email : ''),
585 '__BIRTH__' => $msgishtml ? dol_htmlentitiesbr($birthday) : ($birthday ? $birthday : ''),
586 '__PHOTO__' => $msgishtml ? dol_htmlentitiesbr($photo) : $photo,
587 '__LOGIN__' => $msgishtml ? dol_htmlentitiesbr($login) : $login,
588 '__PASSWORD__' => $msgishtml ? dol_htmlentitiesbr($pass) : $pass,
589 '__PHONE__' => $msgishtml ? dol_htmlentitiesbr($this->phone) : ($this->phone ? $this->phone : ''),
590 '__PHONEPRO__' => $msgishtml ? dol_htmlentitiesbr($this->phone_perso) : ($this->phone_perso ? $this->phone_perso : ''),
591 '__PHONEMOBILE__' => $msgishtml ? dol_htmlentitiesbr($this->phone_mobile) : ($this->phone_mobile ? $this->phone_mobile : ''),
592 '__TYPE__' => $msgishtml ? dol_htmlentitiesbr($type) : $type,
593 );
594
595 complete_substitutions_array($substitutionarray, $langs, $this);
596
597 return make_substitutions($text, $substitutionarray, $langs);
598 }
599
600
608 public function getmorphylib($morphy = '', $addbadge = 0)
609 {
610 global $langs;
611 $s = '';
612
613 // Clean var
614 if (!$morphy) {
615 $morphy = $this->morphy;
616 }
617
618 if ($addbadge) {
619 $labeltoshowm = $langs->trans("Moral");
620 $labeltoshowp = $langs->trans("Physical");
621 if ($morphy == 'phy') {
622 $labeltoshow = $labeltoshowp;
623 if ($addbadge == 2) {
624 $labeltoshow = dol_strtoupper(dolGetFirstLetters($labeltoshowp));
625 if ($labeltoshow == dol_strtoupper(dolGetFirstLetters($labeltoshowm))) {
626 $labeltoshow = dol_strtoupper(dolGetFirstLetters($labeltoshowp, 2));
627 }
628 }
629 $s .= '<span class="member-individual-back paddingleftimp paddingrightimp" title="'.$langs->trans("Physical").'">'.$labeltoshow.'</span>';
630 }
631 if ($morphy == 'mor') {
632 $labeltoshow = $labeltoshowm;
633 if ($addbadge == 2) {
634 $labeltoshow = dol_strtoupper(dolGetFirstLetters($labeltoshowm));
635 if ($labeltoshow == dol_strtoupper(dolGetFirstLetters($labeltoshowp))) {
636 $labeltoshow = dol_strtoupper(dolGetFirstLetters($labeltoshowm, 2));
637 }
638 }
639 $s .= '<span class="member-company-back paddingleftimp paddingrightimp" title="'.$langs->trans("Moral").'">'.$labeltoshow.'</span>';
640 }
641 } else {
642 if ($morphy == 'phy') {
643 $s = $langs->trans("Physical");
644 } elseif ($morphy == 'mor') {
645 $s = $langs->trans("Moral");
646 }
647 }
648
649 return $s;
650 }
651
659 public function create($user, $notrigger = 0)
660 {
661 global $langs, $mysoc;
662
663 $error = 0;
664
665 $now = dol_now();
666
667 // Clean parameters
668 if (isset($this->import_key)) {
669 $this->import_key = trim($this->import_key);
670 }
671
672 // Check parameters
673 if (getDolGlobalString('ADHERENT_MAIL_REQUIRED') && !isValidEmail((string) $this->email)) {
674 $langs->load("errors");
675 $this->error = $langs->trans("ErrorBadEMail", (string) $this->email);
676 return -1;
677 }
678 if (!$this->datec) {
679 $this->datec = $now;
680 }
681 if (!getDolGlobalString('ADHERENT_LOGIN_NOT_REQUIRED')) {
682 if (empty($this->login)) {
683 $this->error = $langs->trans("ErrorWrongValueForParameterX", "Login");
684 return -1;
685 }
686 }
687
688 // setEntity will set entity with the right value if empty or change it for the right value if multicompany module is active
689 $this->entity = setEntity($this);
690
691 $this->db->begin();
692
693 // Insert member
694 $sql = "INSERT INTO ".MAIN_DB_PREFIX."adherent";
695 $sql .= " (ref, datec, login, fk_user_author, fk_user_mod, fk_user_valid, morphy, fk_adherent_type, entity, import_key, ip)";
696 $sql .= " VALUES (";
697 $sql .= " '(PROV)'";
698 $sql .= ", '".$this->db->idate($this->datec)."'";
699 $sql .= ", ".($this->login ? "'".$this->db->escape($this->login)."'" : "null");
700 $sql .= ", ".($user->id > 0 ? $user->id : "null"); // Can be null because member can be created by a guest or a script
701 $sql .= ", null, null, '".$this->db->escape($this->morphy)."'";
702 $sql .= ", ".((int) $this->typeid);
703 $sql .= ", ".((int) $this->entity);
704 $sql .= ", ".(!empty($this->import_key) ? "'".$this->db->escape($this->import_key)."'" : "null");
705 $sql .= ", ".(!empty($this->ip) ? "'".$this->db->escape($this->ip)."'" : "null");
706 $sql .= ")";
707
708 dol_syslog(get_class($this)."::create", LOG_DEBUG);
709 $result = $this->db->query($sql);
710 if ($result) {
711 $id = $this->db->last_insert_id(MAIN_DB_PREFIX."adherent");
712 if ($id > 0) {
713 $this->id = $id;
714
715 $modulenum = getDolGlobalString('MEMBER_CODEMEMBER_ADDON', 'mod_member_simple');
716
717 $modfile = dol_buildpath('core/modules/member/'.$modulenum.'.php', 0);
718 try {
719 require_once $modfile;
720 $modname = $modulenum;
721 $modCodeMember = new $modname();
722 '@phan-var-force ModeleNumRefMembers $modCodeMember';
724 $this->ref = $modCodeMember->getNextValue($mysoc, $this);
725 } catch (Exception $e) {
726 dol_syslog($e->getMessage(), LOG_ERR);
727 $error++;
728 }
729
730 // Update minor fields
731 $result = $this->update($user, 1, 1, 0, 0, 'add'); // nosync is 1 to avoid update data of user
732 if ($result < 0) {
733 $this->db->rollback();
734 return -1;
735 }
736
737 // Add link to user
738 if ($this->user_id) {
739 // Add link to user
740 $sql = "UPDATE ".MAIN_DB_PREFIX."user SET";
741 $sql .= " fk_member = ".((int) $this->id);
742 $sql .= " WHERE rowid = ".((int) $this->user_id);
743 dol_syslog(get_class($this)."::create", LOG_DEBUG);
744 $resql = $this->db->query($sql);
745 if (!$resql) {
746 $this->error = 'Failed to update user to make link with member';
747 $this->db->rollback();
748 return -4;
749 }
750 }
751
752 if (!$notrigger) {
753 // Call trigger
754 $result = $this->call_trigger('MEMBER_CREATE', $user);
755 if ($result < 0) {
756 $error++;
757 }
758 // End call triggers
759 }
760
761 if (count($this->errors)) {
762 dol_syslog(get_class($this)."::create ".implode(',', $this->errors), LOG_ERR);
763 $this->db->rollback();
764 return -3;
765 } else {
766 $this->db->commit();
767 return $this->id;
768 }
769 } else {
770 $this->error = 'Failed to get last insert id';
771 dol_syslog(get_class($this)."::create ".$this->error, LOG_ERR);
772 $this->db->rollback();
773 return -2;
774 }
775 } else {
776 $this->error = $this->db->error();
777 $this->db->rollback();
778 return -1;
779 }
780 }
781
782
794 public function update($user, $notrigger = 0, $nosyncuser = 0, $nosyncuserpass = 0, $nosyncthirdparty = 0, $action = 'update')
795 {
796 global $langs, $hookmanager;
797
798 require_once DOL_DOCUMENT_ROOT.'/core/lib/functions2.lib.php';
799
800 if (empty($this->country_id) && !empty($this->country_code)) {
801 $country_id = getCountry($this->country_code, '3');
802 $this->country_id = is_int($country_id) ? $country_id : 0;
803 }
804
805 $nbrowsaffected = 0;
806 $error = 0;
807
808 dol_syslog(get_class($this)."::update notrigger=".$notrigger.", nosyncuser=".$nosyncuser.", nosyncuserpass=".$nosyncuserpass." nosyncthirdparty=".$nosyncthirdparty.", email=".$this->email);
809
810 // Clean parameters
811 $this->lastname = trim($this->lastname) ? trim($this->lastname) : trim($this->lastname);
812 $this->firstname = trim($this->firstname) ? trim($this->firstname) : trim($this->firstname);
813 // civility_code is the reference property. Fall back to the deprecated civility_id alias only when civility_code was not set by the caller.
814 if (empty($this->civility_code) && !empty($this->civility_id)) {
815 $this->civility_code = $this->civility_id;
816 }
817 if (isset($this->gender)) {
818 $this->gender = trim($this->gender);
819 }
820 // $this->address = ($this->address ? $this->address : $this->address);
821 // $this->zip = ($this->zip ? $this->zip : $this->zip);
822 // $this->town = ($this->town ? $this->town : $this->town);
823 // $this->country_id = ($this->country_id > 0 ? $this->country_id : $this->country_id);
824 // $this->state_id = ($this->state_id > 0 ? $this->state_id : $this->state_id);
825 // $this->note_public = ($this->note_public ? $this->note_public : $this->note_public);
826 // $this->note_private = ($this->note_private ? $this->note_private : $this->note_private);
827 $this->url = $this->url ? clean_url($this->url, 0) : '';
828 $this->setUpperOrLowerCase();
829
830 // Check parameters
831 if (getDolGlobalString('ADHERENT_MAIL_REQUIRED') && !isValidEmail((string) $this->email)) {
832 $langs->load("errors");
833 $this->error = $langs->trans("ErrorBadEMail", (string) $this->email);
834 return -1;
835 }
836
837 $this->db->begin();
838
839 $sql = "UPDATE ".MAIN_DB_PREFIX."adherent SET";
840 $sql .= " ref = '".$this->db->escape($this->ref)."'";
841 $sql .= ", ref_ext = ".(empty($this->ref_ext) ? "null" : "'".$this->db->escape($this->ref_ext)."'");
842 $sql .= ", civility = ".($this->civility_code ? "'".$this->db->escape($this->civility_code)."'" : "null");
843 $sql .= ", firstname = ".($this->firstname ? "'".$this->db->escape($this->firstname)."'" : "null");
844 $sql .= ", lastname = ".($this->lastname ? "'".$this->db->escape($this->lastname)."'" : "null");
845 $sql .= ", gender = ".($this->gender != -1 ? "'".$this->db->escape($this->gender)."'" : "null"); // 'man' or 'woman'
846 $sql .= ", login = ".($this->login ? "'".$this->db->escape($this->login)."'" : "null");
847 $sql .= ", societe = ".($this->company ? "'".$this->db->escape($this->company)."'" : ($this->societe ? "'".$this->db->escape($this->societe)."'" : "null"));
848 if ($this->socid) {
849 $sql .= ", fk_soc = ".($this->socid > 0 ? (int) $this->socid : "null"); // Must be modified only when creating from a third-party
850 }
851 $sql .= ", address = ".($this->address ? "'".$this->db->escape($this->address)."'" : "null");
852 $sql .= ", zip = ".($this->zip ? "'".$this->db->escape($this->zip)."'" : "null");
853 $sql .= ", town = ".($this->town ? "'".$this->db->escape($this->town)."'" : "null");
854 $sql .= ", country = ".($this->country_id > 0 ? (int) $this->country_id : "null");
855 $sql .= ", state_id = ".($this->state_id > 0 ? (int) $this->state_id : "null");
856 $sql .= ", email = '".$this->db->escape((string) $this->email)."'";
857 $sql .= ", url = ".(!empty($this->url) ? "'".$this->db->escape($this->url)."'" : "null");
858 $sql .= ", socialnetworks = ".($this->socialnetworks ? "'".$this->db->escape(json_encode($this->socialnetworks))."'" : "null");
859 $sql .= ", phone = ".($this->phone ? "'".$this->db->escape($this->phone)."'" : "null");
860 $sql .= ", phone_perso = ".($this->phone_perso ? "'".$this->db->escape($this->phone_perso)."'" : "null");
861 $sql .= ", phone_mobile = ".($this->phone_mobile ? "'".$this->db->escape($this->phone_mobile)."'" : "null");
862 $sql .= ", note_private = ".($this->note_private ? "'".$this->db->escape($this->note_private)."'" : "null");
863 $sql .= ", note_public = ".($this->note_public ? "'".$this->db->escape($this->note_public)."'" : "null");
864 $sql .= ", photo = ".($this->photo ? "'".$this->db->escape($this->photo)."'" : "null");
865 $sql .= ", public = ".(int) $this->public;
866 $sql .= ", statut = ".(int) $this->statut;
867 $sql .= ", default_lang = ".(!empty($this->default_lang) ? "'".$this->db->escape($this->default_lang)."'" : "null");
868 $sql .= ", fk_adherent_type = ".(int) $this->typeid;
869 $sql .= ", morphy = '".$this->db->escape($this->morphy)."'";
870 $sql .= ", birth = ".($this->birth ? "'".$this->db->idate($this->birth)."'" : "null");
871
872 if ($this->datefin) {
873 $sql .= ", datefin = '".$this->db->idate($this->datefin)."'"; // Must be modified only when deleting a subscription
874 }
875 if ($this->datevalid) {
876 $sql .= ", datevalid = '".$this->db->idate($this->datevalid)."'"; // Must be modified only when validating a member
877 }
878 $sql .= ", fk_user_mod = ".($user->id > 0 ? $user->id : 'null'); // Can be null because member can be create by a guest
879 $sql .= " WHERE rowid = ".((int) $this->id);
880
881 // If we change the type of membership, we set also label of new type..
882 '@phan-var-force Adherent $oldcopy';
883 if (!empty($this->oldcopy) && $this->typeid != $this->oldcopy->typeid) {
884 $sql2 = "SELECT libelle as label";
885 $sql2 .= " FROM ".MAIN_DB_PREFIX."adherent_type";
886 $sql2 .= " WHERE rowid = ".((int) $this->typeid);
887 $resql2 = $this->db->query($sql2);
888 if ($resql2) {
889 while ($obj = $this->db->fetch_object($resql2)) {
890 $this->type = $obj->label;
891 }
892 }
893 }
894
895 dol_syslog(get_class($this)."::update update member", LOG_DEBUG);
896 $resql = $this->db->query($sql);
897 if ($resql) {
898 unset($this->country_code);
899 unset($this->country);
900 unset($this->state_code);
901 unset($this->state);
902
903 $nbrowsaffected += $this->db->affected_rows($resql);
904
905 $action = 'update';
906
907 // Actions on extra fields
908 $result = $this->insertExtraFields();
909 if ($result < 0) {
910 $error++;
911 }
912
913 // Update password
914 if (!$error && $this->pass) {
915 dol_syslog(get_class($this)."::update update password");
916 if ($this->pass != $this->pass_indatabase && $this->pass != $this->pass_indatabase_crypted) {
917 $isencrypted = getDolGlobalString('DATABASE_PWD_ENCRYPTED') ? 1 : 0;
918
919 // If password to set differs from the one found into database
920 $result = $this->setPassword($user, $this->pass, $isencrypted, $notrigger, $nosyncuserpass);
921 if (!$nbrowsaffected) {
922 $nbrowsaffected++;
923 }
924 }
925 }
926
927 // Remove links to user and replace with new one
928 if (!$error) {
929 dol_syslog(get_class($this)."::update update link to user");
930 $sql = "UPDATE ".MAIN_DB_PREFIX."user SET fk_member = NULL WHERE fk_member = ".((int) $this->id);
931 dol_syslog(get_class($this)."::update", LOG_DEBUG);
932 $resql = $this->db->query($sql);
933 if (!$resql) {
934 $this->error = $this->db->error();
935 $this->db->rollback();
936 return -5;
937 }
938 // If there is a user linked to this member
939 if ($this->user_id > 0) {
940 $sql = "UPDATE ".MAIN_DB_PREFIX."user SET fk_member = ".((int) $this->id)." WHERE rowid = ".((int) $this->user_id);
941 dol_syslog(get_class($this)."::update", LOG_DEBUG);
942 $resql = $this->db->query($sql);
943 if (!$resql) {
944 $this->error = $this->db->error();
945 $this->db->rollback();
946 return -5;
947 }
948 }
949 }
950
951 if (!$error && $nbrowsaffected) { // If something has change in main data
952 // Update information on linked user if it is an update
953 if ($this->user_id > 0 && !$nosyncuser) {
954 require_once DOL_DOCUMENT_ROOT.'/user/class/user.class.php';
955
956 dol_syslog(get_class($this)."::update update linked user");
957
958 $luser = new User($this->db);
959 $result = $luser->fetch($this->user_id);
960
961 if ($result > 0) {
962 // If option ADHERENT_LOGIN_NOT_REQUIRED is on, there is no login of member, so we do not overwrite user login to keep existing one.
963 if (!getDolGlobalString('ADHERENT_LOGIN_NOT_REQUIRED')) {
964 $luser->login = $this->login;
965 }
966
967 $luser->ref = $this->ref;
968 $luser->civility_code = $this->civility_code;
969 $luser->firstname = $this->firstname;
970 $luser->lastname = $this->lastname;
971 $luser->gender = $this->gender;
972 $luser->pass = isset($this->pass) ? $this->pass : '';
973 //$luser->socid=$this->fk_soc; // We do not enable this. This may transform a user into an external user.
974
975 $luser->birth = $this->birth;
976
977 $luser->address = $this->address;
978 $luser->zip = $this->zip;
979 $luser->town = $this->town;
980 $luser->country_id = $this->country_id;
981 $luser->state_id = $this->state_id;
982
983 $luser->email = $this->email;
984 $luser->socialnetworks = $this->socialnetworks;
985 $luser->office_phone = $this->phone;
986 $luser->user_mobile = $this->phone_mobile;
987
988 $luser->lang = $this->default_lang;
989
990 $luser->fk_member = $this->id;
991
992 $result = $luser->update($user, 0, 1, 1); // Use nosync to 1 to avoid cyclic updates
993 if ($result < 0) {
994 $this->error = $luser->error;
995 dol_syslog(get_class($this)."::update ".$this->error, LOG_ERR);
996 $error++;
997 }
998 } else {
999 $this->error = $luser->error;
1000 $error++;
1001 }
1002 }
1003
1004 // Update information on linked thirdparty if it is an update
1005 if (!$error && $this->socid > 0 && !$nosyncthirdparty) {
1006 require_once DOL_DOCUMENT_ROOT.'/societe/class/societe.class.php';
1007
1008 dol_syslog(get_class($this)."::update update linked thirdparty");
1009
1010 // This member is linked with a thirdparty, so we also update thirdparty information
1011 // if this is an update.
1012 $lthirdparty = new Societe($this->db);
1013 $result = $lthirdparty->fetch($this->socid);
1014
1015 if ($result > 0) {
1016 $lthirdparty->address = $this->address;
1017 $lthirdparty->zip = $this->zip;
1018 $lthirdparty->town = $this->town;
1019 $lthirdparty->email = $this->email;
1020 $lthirdparty->socialnetworks = $this->socialnetworks;
1021 $lthirdparty->phone = $this->phone;
1022 $lthirdparty->state_id = $this->state_id;
1023 $lthirdparty->country_id = $this->country_id;
1024 //$lthirdparty->phone_mobile=$this->phone_mobile;
1025 $lthirdparty->default_lang = $this->default_lang;
1026
1027 $result = $lthirdparty->update($this->socid, $user, 0, 1, 1, 'update'); // Use sync to 0 to avoid cyclic updates
1028
1029 if ($result < 0) {
1030 $this->error = $lthirdparty->error;
1031 $this->errors = $lthirdparty->errors;
1032 dol_syslog(get_class($this)."::update ".$this->error, LOG_ERR);
1033 $error++;
1034 }
1035 } elseif ($result < 0) {
1036 $this->error = $lthirdparty->error;
1037 $error++;
1038 }
1039 }
1040 }
1041
1042 if (!$error && !$notrigger) {
1043 // Call trigger
1044 $result = $this->call_trigger('MEMBER_MODIFY', $user);
1045 if ($result < 0) {
1046 $error++;
1047 }
1048 // End call triggers
1049 }
1050
1051 if (!$error) {
1052 $this->db->commit();
1053 return $nbrowsaffected;
1054 } else {
1055 $this->db->rollback();
1056 return -1;
1057 }
1058 } else {
1059 $this->db->rollback();
1060 $this->error = $this->db->lasterror();
1061 return -2;
1062 }
1063 }
1064
1065
1066 // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps
1074 public function update_end_date($user)
1075 {
1076 // phpcs:enable
1077 $this->db->begin();
1078
1079 // Search for last subscription id and end date
1080 $sql = "SELECT rowid, datec as dateop, dateadh as datedeb, datef as datefin";
1081 $sql .= " FROM ".MAIN_DB_PREFIX."subscription";
1082 $sql .= " WHERE fk_adherent = ".((int) $this->id);
1083 $sql .= " ORDER by dateadh DESC"; // Sort by start subscription date
1084
1085 dol_syslog(get_class($this)."::update_end_date", LOG_DEBUG);
1086 $resql = $this->db->query($sql);
1087 if ($resql) {
1088 // The last subscription is the one with the latest start date (first record), but the end date of the member is
1089 // the latest end date of all its subscriptions: a short subscription that starts after a longer one must not
1090 // shorten the membership. There is no record at all when the last subscription of the member was deleted.
1091 $dateop = '';
1092 $datedeb = '';
1093 $datefin = '';
1094 $dateendmember = '';
1095 $i = 0;
1096 while ($obj = $this->db->fetch_object($resql)) {
1097 $dateendsubscription = $this->db->jdate($obj->datefin);
1098 if ($i == 0) {
1099 $dateop = $this->db->jdate($obj->dateop);
1100 $datedeb = $this->db->jdate($obj->datedeb);
1101 $datefin = $dateendsubscription;
1102 }
1103 if ($dateendsubscription != '' && ($dateendmember == '' || $dateendsubscription > $dateendmember)) {
1104 $dateendmember = $dateendsubscription;
1105 }
1106 $i++;
1107 }
1108
1109 $sql = "UPDATE ".MAIN_DB_PREFIX."adherent SET";
1110 $sql .= " datefin=".($dateendmember != '' ? "'".$this->db->idate($dateendmember)."'" : "null");
1111 $sql .= " WHERE rowid = ".((int) $this->id);
1112
1113 dol_syslog(get_class($this)."::update_end_date", LOG_DEBUG);
1114 $resql = $this->db->query($sql);
1115 if ($resql) {
1116 $this->last_subscription_date = $dateop;
1117 $this->last_subscription_date_start = $datedeb;
1118 $this->last_subscription_date_end = $datefin;
1119 $this->datefin = $dateendmember;
1120 $this->db->commit();
1121 return 1;
1122 } else {
1123 $this->db->rollback();
1124 return -1;
1125 }
1126 } else {
1127 $this->error = $this->db->lasterror();
1128 $this->db->rollback();
1129 return -1;
1130 }
1131 }
1132
1140 public function delete($user, $notrigger = 0)
1141 {
1142 global $conf;
1143
1144 $result = 0;
1145 $error = 0;
1146 $errorflag = 0;
1147
1148 // Check parameters
1149 $rowid = $this->id;
1150
1151 $this->db->begin();
1152
1153 if (!$notrigger) {
1154 // Call trigger
1155 $result = $this->call_trigger('MEMBER_DELETE', $user);
1156 if ($result < 0) {
1157 $error++;
1158 }
1159 // End call triggers
1160 }
1161
1162 // Remove category
1163 $sql = "DELETE FROM ".MAIN_DB_PREFIX."categorie_member WHERE fk_member = ".((int) $rowid);
1164 dol_syslog(get_class($this)."::delete", LOG_DEBUG);
1165 $resql = $this->db->query($sql);
1166 if (!$resql) {
1167 $error++;
1168 $this->error .= $this->db->lasterror();
1169 $errorflag = -1;
1170 }
1171
1172 // Remove subscription
1173 if (!$error) {
1174 $sql = "DELETE FROM ".MAIN_DB_PREFIX."subscription WHERE fk_adherent = ".((int) $rowid);
1175 dol_syslog(get_class($this)."::delete", LOG_DEBUG);
1176 $resql = $this->db->query($sql);
1177 if (!$resql) {
1178 $error++;
1179 $this->error .= $this->db->lasterror();
1180 $errorflag = -2;
1181 }
1182 }
1183
1184 // Remove the partnerships of the member
1185 if (!$error && isModEnabled('partnership')) {
1186 require_once DOL_DOCUMENT_ROOT.'/partnership/class/partnership.class.php';
1187
1188 $sql = "SELECT rowid FROM ".MAIN_DB_PREFIX."partnership WHERE fk_member = ".((int) $rowid);
1189 dol_syslog(get_class($this)."::delete", LOG_DEBUG);
1190 $resql = $this->db->query($sql);
1191 if ($resql) {
1192 while ($obj = $this->db->fetch_object($resql)) {
1193 $partnership = new Partnership($this->db);
1194 if ($partnership->fetch($obj->rowid) > 0 && $partnership->delete($user) <= 0) {
1195 $error++;
1196 $this->error .= $partnership->error;
1197 $errorflag = -9;
1198 break;
1199 }
1200 }
1201 } else {
1202 $error++;
1203 $this->error .= $this->db->lasterror();
1204 $errorflag = -9;
1205 }
1206 }
1207
1208 // Remove the links with other objects
1209 if (!$error) {
1210 $ret = $this->deleteObjectLinked();
1211 if ($ret < 0) {
1212 $error++;
1213 $errorflag = -7;
1214 }
1215 }
1216
1217 // Remove the index of the documents of the member (the files are removed after the commit)
1218 $dirofdocuments = '';
1219 $subdirofdocuments = get_exdir(0, 0, 0, 1, $this, 'member');
1220 if (!empty($conf->adherent->dir_output) && $subdirofdocuments !== '') { // Never the root directory of the module
1221 $dirofdocuments = $conf->adherent->dir_output.'/'.$subdirofdocuments;
1222 }
1223 if (!$error && $dirofdocuments) {
1224 require_once DOL_DOCUMENT_ROOT.'/core/lib/files.lib.php';
1225 if (deleteFilesIntoDatabaseIndex($dirofdocuments, '', '') < 0 || !$this->deleteEcmFiles(1)) {
1226 $error++;
1227 $this->error .= $this->db->lasterror();
1228 $errorflag = -8;
1229 }
1230 }
1231
1232 // Remove linked user
1233 if (!$error) {
1234 $ret = $this->setUserId(0);
1235 if ($ret < 0) {
1236 $error++;
1237 $this->error .= $this->db->lasterror();
1238 $errorflag = -3;
1239 }
1240 }
1241
1242 // Removed extrafields
1243 if (!$error) {
1244 $result = $this->deleteExtraFields();
1245 if ($result < 0) {
1246 $error++;
1247 $errorflag = -4;
1248 dol_syslog(get_class($this)."::delete erreur ".$errorflag." ".$this->error, LOG_ERR);
1249 }
1250 }
1251
1252 // Remove adherent
1253 if (!$error) {
1254 $sql = "DELETE FROM ".MAIN_DB_PREFIX."adherent WHERE rowid = ".((int) $rowid);
1255 dol_syslog(get_class($this)."::delete", LOG_DEBUG);
1256 $resql = $this->db->query($sql);
1257 if (!$resql) {
1258 $error++;
1259 $this->error .= $this->db->lasterror();
1260 $errorflag = -5;
1261 }
1262 }
1263
1264 if (!$error) {
1265 $this->db->commit();
1266
1267 // Delete the directory of the documents of the member
1268 if ($dirofdocuments) {
1269 require_once DOL_DOCUMENT_ROOT.'/core/lib/files.lib.php';
1270 if (dol_is_dir($dirofdocuments)) {
1271 dol_delete_dir_recursive($dirofdocuments);
1272 }
1273 }
1274
1275 return 1;
1276 } else {
1277 $this->db->rollback();
1278 return $errorflag;
1279 }
1280 }
1281
1292 public function mergeMembers($member_origin_id)
1293 {
1294 global $conf, $langs, $hookmanager, $user, $action;
1295
1296 $error = 0;
1297 $member_origin = new Adherent($this->db); // The member that we will delete
1298
1299 dol_syslog("mergeMembers merge member id=".$member_origin_id." (will be deleted) into the member id=".$this->id);
1300 if ($member_origin->fetch($member_origin_id) < 1) {
1301 $this->error = $langs->trans('ErrorRecordNotFound');
1302 $error++;
1303 }
1304
1305 if (!$error) {
1306 $this->db->begin();
1307 $listofproperties = array(
1308 'ref_ext', 'civility', 'lastname', 'firstname', 'morphy', 'societe', 'socid', 'user_id','address',
1309 'zip', 'town', 'state_id', 'country', 'phone', 'phone_perso', 'phone_mobile', 'email',
1310 'url', 'socialnetworks', 'birth', 'gender', 'photo', 'public', 'datefin', 'default_lang',
1311 'canvas', 'model_pdf', 'import_key'
1312 );
1313 foreach ($listofproperties as $property) {
1314 if (empty($this->$property)) {
1315 $this->$property = $member_origin->$property;
1316 }
1317 }
1318
1319 // Concat some data
1320 $listofproperties = array(
1321 'note_public', 'note_private'
1322 );
1323 foreach ($listofproperties as $property) {
1324 $this->$property = dol_concatdesc($this->$property, $member_origin->$property);
1325 }
1326
1327 // Merge extrafields
1328 if (is_array($member_origin->array_options)) {
1329 foreach ($member_origin->array_options as $key => $val) {
1330 if (empty($this->array_options[$key])) {
1331 $this->array_options[$key] = $val;
1332 }
1333 }
1334 }
1335
1336 // Merge categories
1337 include_once DOL_DOCUMENT_ROOT.'/categories/class/categorie.class.php';
1338 $static_cat = new Categorie($this->db);
1339 $custcats_ori = $static_cat->containing($member_origin->id, 'member', 'id');
1340 $custcats = $static_cat->containing($this->id, 'member', 'id');
1341 $custcats = array_merge($custcats, $custcats_ori);
1342 $this->setCategories($custcats);
1343
1344 $result = $this->update($user, 1, 1, 1, 1, 'merge');
1345 if ($result < 0) {
1346 $error++;
1347 }
1348
1349 // Merge subscriptions
1350 if (!$error && $member_origin->fetch_subscriptions() < 1) {
1351 $error++;
1352 }
1353
1354 if (!$error) {
1355 foreach ($member_origin->subscriptions as $key => $subscription) {
1356 $subscription->fk_adherent = $this->id;
1357 $result = $subscription->update($user);
1358 if ($result < 0) {
1359 $error++;
1360 break;
1361 }
1362 }
1363 }
1364
1365 // External modules should update their ones too
1366 if (!$error) {
1367 $parameters = array('member_origin' => $member_origin->id, 'member_dest' => $this->id);
1368 $reshook = $hookmanager->executeHooks('replaceMember', $parameters, $this, $action);
1369
1370 if ($reshook < 0) {
1371 $this->setErrorsFromObject($hookmanager);
1372 $error++;
1373 }
1374 }
1375
1376 if (!$error) {
1377 $this->context = array('merge' => 1, 'mergefromid' => $member_origin->id);
1378
1379 // Call trigger
1380 $result = $this->call_trigger('MEMBER_MODIFY', $user);
1381 if ($result < 0) {
1382 $error++;
1383 }
1384 // End call triggers
1385 }
1386
1387 if (!$error) {
1388 // We finally remove the old member
1389 if ($member_origin->delete($user) < 1) {
1390 $this->setErrorsFromObject($member_origin);
1391 $error++;
1392 }
1393 }
1394
1395 if (!$error) {
1396 // Move files from the dir of the third party to delete into the dir of the third party to keep
1397 if (!empty($conf->adherent->multidir_output[$this->entity])) {
1398 $srcdir = $conf->adherent->multidir_output[$this->entity]."/".$member_origin->id;
1399 $destdir = $conf->adherent->multidir_output[$this->entity]."/".$this->id;
1400
1401 if (dol_is_dir($srcdir)) {
1402 $dirlist = dol_dir_list($srcdir, 'files', 1);
1403 foreach ($dirlist as $filetomove) {
1404 $destfile = $destdir.'/'.$filetomove['relativename'];
1405 $result = dol_move($filetomove['fullname'], $destfile, '0', 0, 0, 1);
1406 if (!$result) {
1407 $error++;
1408 }
1409 }
1410 }
1411 }
1412 }
1413
1414 if (!$error) {
1415 $this->db->commit();
1416 return 0;
1417 } else {
1418 $langs->load("errors");
1419 $this->error = $langs->trans('ErrorMembersMerge');
1420 $this->db->rollback();
1421 return -1;
1422 }
1423 }
1424 return -1;
1425 }
1426
1437 public function setPassword($user, $password = '', $isencrypted = 0, $notrigger = 0, $nosyncuser = 0)
1438 {
1439 global $conf, $langs;
1440
1441 $error = 0;
1442
1443 dol_syslog(get_class($this)."::setPassword user=".$user->id." password=".preg_replace('/./i', '*', $password)." isencrypted=".$isencrypted);
1444
1445 // If new password not provided, we generate one
1446 if (!$password) {
1447 require_once DOL_DOCUMENT_ROOT.'/core/lib/security2.lib.php';
1448 $password = getRandomPassword(false);
1449 }
1450
1451 // Crypt password
1452 $password_crypted = dol_hash($password);
1453
1454 $password_indatabase = '';
1455 if (!$isencrypted) {
1456 $password_indatabase = $password;
1457 }
1458
1459 $this->db->begin();
1460
1461 // Mise a jour
1462 $sql = "UPDATE ".MAIN_DB_PREFIX."adherent";
1463 $sql .= " SET pass_crypted = '".$this->db->escape($password_crypted)."'";
1464 if ($isencrypted) {
1465 $sql .= ", pass = null";
1466 } else {
1467 $sql .= ", pass = '".$this->db->escape($password_indatabase)."'";
1468 }
1469 $sql .= " WHERE rowid = ".((int) $this->id);
1470
1471 //dol_syslog("Adherent::Password sql=hidden");
1472 dol_syslog(get_class($this)."::setPassword", LOG_DEBUG);
1473 $result = $this->db->query($sql);
1474 if ($result) {
1475 $nbaffectedrows = $this->db->affected_rows($result);
1476
1477 if ($nbaffectedrows) {
1478 $this->pass = $password;
1479 $this->pass_indatabase = $password_indatabase;
1480 $this->pass_indatabase_crypted = $password_crypted;
1481
1482 if ($this->user_id && !$nosyncuser) {
1483 require_once DOL_DOCUMENT_ROOT.'/user/class/user.class.php';
1484
1485 // This member is linked with a user, so we also update users information
1486 // if this is an update.
1487 $luser = new User($this->db);
1488 $result = $luser->fetch($this->user_id);
1489
1490 if ($result > 0) {
1491 $result = $luser->setPassword($user, $this->pass, 0, 0, 1);
1492 if (is_int($result) && $result < 0) {
1493 $this->error = $luser->error;
1494 dol_syslog(get_class($this)."::setPassword ".$this->error, LOG_ERR);
1495 $error++;
1496 }
1497 } else {
1498 $this->error = $luser->error;
1499 $error++;
1500 }
1501 }
1502
1503 if (!$error && !$notrigger) {
1504 // Call trigger
1505 $result = $this->call_trigger('MEMBER_NEW_PASSWORD', $user);
1506 if ($result < 0) {
1507 $error++;
1508 $this->db->rollback();
1509 return -1;
1510 }
1511 // End call triggers
1512 }
1513
1514 $this->db->commit();
1515 return $this->pass;
1516 } else {
1517 $this->db->rollback();
1518 return 0;
1519 }
1520 } else {
1521 $this->db->rollback();
1522 dol_print_error($this->db);
1523 return -1;
1524 }
1525 }
1526
1527
1534 public function setUserId($userid)
1535 {
1536 global $conf, $langs;
1537
1538 $this->db->begin();
1539
1540 // If user is linked to this member, remove old link to this member
1541 $sql = "UPDATE ".MAIN_DB_PREFIX."user SET fk_member = NULL WHERE fk_member = ".((int) $this->id);
1542 dol_syslog(get_class($this)."::setUserId", LOG_DEBUG);
1543 $resql = $this->db->query($sql);
1544 if (!$resql) {
1545 $this->error = $this->db->error();
1546 $this->db->rollback();
1547 return -1;
1548 }
1549
1550 // Set link to user
1551 if ($userid > 0) {
1552 $sql = "UPDATE ".MAIN_DB_PREFIX."user SET fk_member = ".((int) $this->id);
1553 $sql .= " WHERE rowid = ".((int) $userid);
1554 dol_syslog(get_class($this)."::setUserId", LOG_DEBUG);
1555 $resql = $this->db->query($sql);
1556 if (!$resql) {
1557 $this->error = $this->db->error();
1558 $this->db->rollback();
1559 return -2;
1560 }
1561 }
1562
1563 $this->db->commit();
1564
1565 return 1;
1566 }
1567
1568
1575 public function setThirdPartyId($thirdpartyid)
1576 {
1577 global $conf, $langs;
1578
1579 $this->db->begin();
1580
1581 // Remove link to third party onto any other members
1582 if ($thirdpartyid > 0) {
1583 $sql = "UPDATE ".MAIN_DB_PREFIX."adherent SET fk_soc = null";
1584 $sql .= " WHERE fk_soc = ".((int) $thirdpartyid);
1585 $sql .= " AND entity = ".$conf->entity;
1586 dol_syslog(get_class($this)."::setThirdPartyId", LOG_DEBUG);
1587 $resql = $this->db->query($sql);
1588 }
1589
1590 // Add link to third party for current member
1591 $sql = "UPDATE ".MAIN_DB_PREFIX."adherent SET fk_soc = ".($thirdpartyid > 0 ? (int) $thirdpartyid : 'null');
1592 $sql .= " WHERE rowid = ".((int) $this->id);
1593
1594 dol_syslog(get_class($this)."::setThirdPartyId", LOG_DEBUG);
1595 $resql = $this->db->query($sql);
1596 if ($resql) {
1597 $this->db->commit();
1598 return 1;
1599 } else {
1600 $this->error = $this->db->error();
1601 $this->db->rollback();
1602 return -1;
1603 }
1604 }
1605
1606
1607 // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps
1614 public function fetch_login($login)
1615 {
1616 // phpcs:enable
1617 global $conf;
1618
1619 $sql = "SELECT rowid FROM ".MAIN_DB_PREFIX."adherent";
1620 $sql .= " WHERE login='".$this->db->escape($login)."'";
1621 $sql .= " AND entity = ".$conf->entity;
1622
1623 $resql = $this->db->query($sql);
1624 if ($resql) {
1625 if ($this->db->num_rows($resql)) {
1626 $obj = $this->db->fetch_object($resql);
1627 $this->fetch($obj->rowid);
1628 }
1629 } else {
1630 dol_print_error($this->db);
1631 }
1632 }
1633
1634 // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps
1642 public function fetch_name($firstname, $lastname)
1643 {
1644 // phpcs:enable
1645 global $conf;
1646
1647 $sql = "SELECT rowid FROM ".MAIN_DB_PREFIX."adherent";
1648 $sql .= " WHERE firstname='".$this->db->escape($firstname)."'";
1649 $sql .= " AND lastname='".$this->db->escape($lastname)."'";
1650 $sql .= " AND entity = ".$conf->entity;
1651
1652 $resql = $this->db->query($sql);
1653 if ($resql) {
1654 if ($this->db->num_rows($resql)) {
1655 $obj = $this->db->fetch_object($resql);
1656 $this->fetch($obj->rowid);
1657 }
1658 } else {
1659 dol_print_error($this->db);
1660 }
1661 }
1662
1674 public function fetch($rowid, $ref = '', $socid = 0, $ref_ext = '', $fetch_optionals = true, $fetch_subscriptions = true)
1675 {
1676 global $langs;
1677
1678 $sql = "SELECT d.rowid, d.ref, d.ref_ext, d.civility as civility_code, d.gender, d.firstname, d.lastname,";
1679 $sql .= " d.societe as company, d.fk_soc as socid, d.statut, d.public, d.address, d.zip, d.town, d.note_private,";
1680 $sql .= " d.note_public,";
1681 $sql .= " d.email, d.url, d.socialnetworks, d.phone, d.phone_perso, d.phone_mobile, d.login, d.pass, d.pass_crypted,";
1682 $sql .= " d.photo, d.fk_adherent_type, d.morphy, d.entity,";
1683 $sql .= " d.datec as datec,";
1684 $sql .= " GREATEST(d.tms, COALESCE(aef.tms, d.tms)) as datem,";
1685 $sql .= " d.datefin as datefin, d.default_lang,";
1686 $sql .= " d.birth as birthday,";
1687 $sql .= " d.datevalid as datev,";
1688 $sql .= " d.country,";
1689 $sql .= " d.state_id,";
1690 $sql .= " d.model_pdf,";
1691 $sql .= " c.rowid as country_id, c.code as country_code, c.label as country,";
1692 $sql .= " dep.nom as state, dep.code_departement as state_code,";
1693 $sql .= " t.libelle as type, t.subscription as subscription,";
1694 $sql .= " u.rowid as user_id, u.login as user_login";
1695 $sql .= " FROM ".MAIN_DB_PREFIX."adherent_type as t, ".MAIN_DB_PREFIX."adherent as d";
1696 $sql .= ' LEFT JOIN '.MAIN_DB_PREFIX.'adherent_extrafields as aef ON aef.fk_object = d.rowid';
1697 $sql .= " LEFT JOIN ".MAIN_DB_PREFIX."c_country as c ON d.country = c.rowid";
1698 $sql .= " LEFT JOIN ".MAIN_DB_PREFIX."c_departements as dep ON d.state_id = dep.rowid";
1699 $sql .= " LEFT JOIN ".MAIN_DB_PREFIX."user as u ON d.rowid = u.fk_member";
1700 $sql .= " WHERE d.fk_adherent_type = t.rowid";
1701 if ($rowid) {
1702 $sql .= " AND d.rowid=".((int) $rowid);
1703 } elseif ($ref || $socid) {
1704 $sql .= " AND d.entity IN (".getEntity('adherent').")";
1705 if ($ref) {
1706 $sql .= " AND d.ref='".$this->db->escape($ref)."'";
1707 } elseif ($socid > 0) {
1708 $sql .= " AND d.fk_soc=".((int) $socid);
1709 }
1710 } elseif ($ref_ext) {
1711 $sql .= " AND d.ref_ext='".$this->db->escape($ref_ext)."'";
1712 }
1713
1714 dol_syslog(get_class($this)."::fetch", LOG_DEBUG);
1715 $resql = $this->db->query($sql);
1716 if ($resql) {
1717 if ($this->db->num_rows($resql)) {
1718 $obj = $this->db->fetch_object($resql);
1719
1720 $this->entity = $obj->entity;
1721 $this->id = $obj->rowid;
1722 $this->ref = $obj->ref;
1723 $this->ref_ext = $obj->ref_ext;
1724
1725 $this->civility_id = $obj->civility_code; // Bad. Kept for backward compatibility
1726 $this->civility_code = $obj->civility_code;
1727 $this->civility = $obj->civility_code ? ($langs->trans("Civility".$obj->civility_code) != "Civility".$obj->civility_code ? $langs->trans("Civility".$obj->civility_code) : $obj->civility_code) : '';
1728
1729 $this->firstname = $obj->firstname;
1730 $this->lastname = $obj->lastname;
1731 $this->gender = $obj->gender;
1732 $this->login = $obj->login;
1733 $this->societe = $obj->company;
1734 $this->company = $obj->company;
1735 $this->socid = $obj->socid;
1736 $this->fk_soc = $obj->socid; // For backward compatibility
1737 $this->address = $obj->address;
1738 $this->zip = $obj->zip;
1739 $this->town = $obj->town;
1740
1741 $this->pass = $obj->pass;
1742 $this->pass_indatabase = $obj->pass;
1743 $this->pass_indatabase_crypted = $obj->pass_crypted;
1744
1745 $this->state_id = $obj->state_id;
1746 $this->state_code = $obj->state_id ? $obj->state_code : '';
1747 $this->state = $obj->state_id ? $obj->state : '';
1748
1749 $this->country_id = $obj->country_id;
1750 $this->country_code = $obj->country_code;
1751 if ($langs->trans("Country".$obj->country_code) != "Country".$obj->country_code) {
1752 $this->country = $langs->transnoentitiesnoconv("Country".$obj->country_code);
1753 } else {
1754 $this->country = $obj->country;
1755 }
1756
1757 $this->phone = $obj->phone;
1758 $this->phone_perso = $obj->phone_perso;
1759 $this->phone_mobile = $obj->phone_mobile;
1760 $this->email = $obj->email;
1761 $this->url = $obj->url;
1762
1763 $this->socialnetworks = ($obj->socialnetworks ? (array) json_decode($obj->socialnetworks, true) : array());
1764
1765 $this->photo = $obj->photo;
1766 $this->statut = $obj->statut;
1767 $this->status = $obj->statut;
1768 $this->public = $obj->public;
1769
1770 $this->datec = $this->db->jdate($obj->datec);
1771 $this->date_creation = $this->db->jdate($obj->datec);
1772 $this->datem = $this->db->jdate($obj->datem);
1773 $this->date_modification = $this->db->jdate($obj->datem);
1774 $this->datefin = $this->db->jdate($obj->datefin);
1775 $this->datevalid = $this->db->jdate($obj->datev);
1776 $this->date_validation = $this->db->jdate($obj->datev);
1777 $this->birth = $this->db->jdate($obj->birthday);
1778
1779 $this->default_lang = $obj->default_lang;
1780
1781 $this->note_private = $obj->note_private;
1782 $this->note_public = $obj->note_public;
1783 $this->morphy = $obj->morphy;
1784
1785 $this->typeid = $obj->fk_adherent_type;
1786 $this->type = $obj->type;
1787 $this->need_subscription = $obj->subscription;
1788
1789 $this->user_id = $obj->user_id;
1790 $this->user_login = $obj->user_login;
1791
1792 $this->model_pdf = $obj->model_pdf;
1793
1794 // Retrieve all extrafield
1795 // fetch optionals attributes and labels
1796 if ($fetch_optionals) {
1797 $this->fetch_optionals();
1798 }
1799
1800 // Load other properties
1801 if ($fetch_subscriptions) {
1802 $result = $this->fetch_subscriptions();
1803 }
1804
1805 return $this->id;
1806 } else {
1807 return 0;
1808 }
1809 } else {
1810 $this->error = $this->db->lasterror();
1811 return -1;
1812 }
1813 }
1814
1815
1816 // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps
1825 public function fetch_subscriptions()
1826 {
1827 // phpcs:enable
1828 require_once DOL_DOCUMENT_ROOT.'/adherents/class/subscription.class.php';
1829
1830 $sql = "SELECT c.rowid, c.fk_adherent, c.fk_type, c.subscription, c.note as note_public, c.fk_bank,";
1831 $sql .= " c.tms as datem,";
1832 $sql .= " c.datec as datec,";
1833 $sql .= " c.dateadh as dateh,";
1834 $sql .= " c.datef as datef";
1835 $sql .= " FROM ".MAIN_DB_PREFIX."subscription as c";
1836 $sql .= " WHERE c.fk_adherent = ".((int) $this->id);
1837 $sql .= " ORDER BY c.dateadh";
1838 dol_syslog(get_class($this)."::fetch_subscriptions", LOG_DEBUG);
1839
1840 $resql = $this->db->query($sql);
1841 if ($resql) {
1842 $this->subscriptions = array();
1843
1844 $i = 0;
1845 while ($obj = $this->db->fetch_object($resql)) {
1846 if ($i == 0) {
1847 $this->first_subscription_date = $this->db->jdate($obj->datec);
1848 $this->first_subscription_date_start = $this->db->jdate($obj->dateh);
1849 $this->first_subscription_date_end = $this->db->jdate($obj->datef);
1850 $this->first_subscription_amount = $obj->subscription;
1851 }
1852 $this->last_subscription_date = $this->db->jdate($obj->datec);
1853 $this->last_subscription_date_start = $this->db->jdate($obj->dateh);
1854 $this->last_subscription_date_end = $this->db->jdate($obj->datef);
1855 $this->last_subscription_amount = (float) $obj->subscription;
1856
1857 $subscription = new Subscription($this->db);
1858 $subscription->id = $obj->rowid;
1859 $subscription->fk_adherent = $obj->fk_adherent;
1860 $subscription->fk_type = $obj->fk_type;
1861 $subscription->amount = (float) $obj->subscription;
1862 $subscription->note = $obj->note_public;
1863 $subscription->note_public = $obj->note_public;
1864 $subscription->fk_bank = $obj->fk_bank;
1865 $subscription->datem = $this->db->jdate($obj->datem);
1866 $subscription->datec = $this->db->jdate($obj->datec);
1867 $subscription->dateh = $this->db->jdate($obj->dateh);
1868 $subscription->datef = $this->db->jdate($obj->datef);
1869
1870 $this->subscriptions[] = $subscription;
1871
1872 $i++;
1873 }
1874 return 1;
1875 } else {
1876 $this->error = $this->db->error().' sql='.$sql;
1877 return -1;
1878 }
1879 }
1880
1881
1888 public function fetchPartnerships($mode)
1889 {
1890 require_once DOL_DOCUMENT_ROOT.'/partnership/class/partnership.class.php';
1891
1892
1893 $this->partnerships[] = array();
1894
1895 return 1;
1896 }
1897
1898
1915 public function subscription($date, $amount, $accountid = 0, $operation = '', $label = '', $num_chq = '', $emetteur_nom = '', $emetteur_banque = '', $datesubend = 0, $fk_type = null, $ref_ext = '')
1916 {
1917 global $user;
1918
1919 require_once DOL_DOCUMENT_ROOT.'/adherents/class/subscription.class.php';
1920
1921 $error = 0;
1922
1923 // Clean parameters
1924 if (!$amount) {
1925 $amount = 0;
1926 }
1927
1928 $this->db->begin();
1929
1930 if ($datesubend) {
1931 $datefin = $datesubend;
1932 } else {
1933 // If no end date, end date = date + 1 year - 1 day
1934 $datefin = dol_time_plus_duree($date, 1, 'y');
1935 $datefin = dol_time_plus_duree($datefin, -1, 'd');
1936 }
1937
1938 // Create subscription
1939 $subscription = new Subscription($this->db);
1940 $subscription->fk_adherent = $this->id;
1941 $subscription->dateh = $date; // Date of new subscription
1942 $subscription->datef = $datefin; // End data of new subscription
1943 $subscription->amount = $amount;
1944 $subscription->note_public = $label;
1945 $subscription->note_private = '';
1946 $subscription->fk_type = $fk_type;
1947 $subscription->ref_ext = $ref_ext;
1948
1949 if (empty($subscription->user_creation_id)) {
1950 $subscription->user_creation_id = $user->id;
1951 }
1952
1953 $rowid = $subscription->create($user);
1954 if ($rowid > 0) {
1955 // Update denormalized subscription end date (read database subscription to find values)
1956 // This will also update this->datefin
1957 $result = $this->update_end_date($user);
1958 if ($result > 0) {
1959 // Change properties of object (used by triggers)
1960 $this->last_subscription_date = dol_now();
1961 $this->last_subscription_date_start = $date;
1962 $this->last_subscription_date_end = $datefin;
1963 $this->last_subscription_amount = $amount;
1964 } else {
1965 $error++;
1966 }
1967
1968 if (!$error) {
1969 $this->db->commit();
1970 return $rowid;
1971 } else {
1972 $this->db->rollback();
1973 return -2;
1974 }
1975 } else {
1976 $this->setErrorsFromObject($subscription);
1977 $this->db->rollback();
1978 return -1;
1979 }
1980 }
1981
1982
2002 public function subscriptionComplementaryActions($subscriptionid, $option, $accountid, $datesubscription, $paymentdate, $operation, $label, $amount, $num_chq, $emetteur_nom = '', $emetteur_banque = '', $autocreatethirdparty = 0, $ext_payment_id = '', $ext_payment_site = '')
2003 {
2004 global $conf, $langs, $user, $mysoc;
2005
2006 $error = 0;
2007
2008 $this->invoice = null; // This will contains invoice if an invoice is created
2009
2010 dol_syslog("subscriptionComplementaryActions subscriptionid=".$subscriptionid." option=".$option." accountid=".$accountid." datesubscription=".$datesubscription." paymentdate=".
2011 $paymentdate." label=".$label." amount=".$amount." num_chq=".$num_chq." autocreatethirdparty=".$autocreatethirdparty);
2012
2013 // Insert into bank account directlty (if option chosen for) + link to llx_subscription if option is 'bankdirect'
2014 if ($option == 'bankdirect' && $accountid) {
2015 require_once DOL_DOCUMENT_ROOT.'/compta/bank/class/account.class.php';
2016
2017 $acct = new Account($this->db);
2018 $result = $acct->fetch($accountid);
2019
2020 $dateop = $paymentdate;
2021
2022 $insertid = $acct->addline($dateop, $operation, $label, $amount, $num_chq, 0, $user, $emetteur_nom, $emetteur_banque);
2023 if ($insertid > 0) {
2024 $inserturlid = $acct->add_url_line($insertid, $this->id, DOL_URL_ROOT.'/adherents/card.php?rowid=', $this->getFullName($langs), 'member');
2025 if ($inserturlid > 0) {
2026 // Update table subscription
2027 $sql = "UPDATE ".MAIN_DB_PREFIX."subscription SET fk_bank=".((int) $insertid);
2028 $sql .= " WHERE rowid=".((int) $subscriptionid);
2029
2030 dol_syslog("subscription::subscription", LOG_DEBUG);
2031 $resql = $this->db->query($sql);
2032 if (!$resql) {
2033 $error++;
2034 $this->error = $this->db->lasterror();
2035 $this->errors[] = $this->error;
2036 }
2037 } else {
2038 $error++;
2039 $this->setErrorsFromObject($acct);
2040 }
2041 } else {
2042 $error++;
2043 $this->setErrorsFromObject($acct);
2044 }
2045 }
2046
2047 // If option chosen, we create invoice
2048 if (($option == 'bankviainvoice' && $accountid) || $option == 'invoiceonly') {
2049 require_once DOL_DOCUMENT_ROOT.'/compta/facture/class/facture.class.php';
2050 require_once DOL_DOCUMENT_ROOT.'/compta/facture/class/paymentterm.class.php';
2051
2052 $invoice = new Facture($this->db);
2053 $customer = new Societe($this->db);
2054
2055 if (!$error) {
2056 if (!($this->socid > 0)) { // If not yet linked to a company
2057 if ($autocreatethirdparty) {
2058 // Create a linked thirdparty to member
2059 $companyalias = '';
2060 $fullname = $this->getFullName($langs);
2061
2062 if ($this->morphy == 'mor') {
2063 $companyname = $this->company;
2064 if (!empty($fullname)) {
2065 $companyalias = $fullname;
2066 }
2067 } else {
2068 $companyname = $fullname;
2069 if (!empty($this->company)) {
2070 $companyalias = $this->company;
2071 }
2072 }
2073
2074 $result = $customer->create_from_member($this, (string) $companyname, $companyalias);
2075 if ($result < 0) {
2076 $this->error = $customer->error;
2077 $this->errors = $customer->errors;
2078 $error++;
2079 } else {
2080 $this->fk_soc = $result;
2081 $this->socid = $result;
2082 }
2083 } else {
2084 $langs->load("errors");
2085 $this->error = $langs->trans("ErrorMemberNotLinkedToAThirpartyLinkOrCreateFirst");
2086 $this->errors[] = $this->error;
2087 $error++;
2088 }
2089 }
2090 }
2091 if (!$error) {
2092 $result = $customer->fetch($this->socid);
2093 if ($result <= 0) {
2094 $this->error = $customer->error;
2095 $this->errors = $customer->errors;
2096 $error++;
2097 }
2098 }
2099
2100 if (!$error) {
2101 // Create draft invoice
2102 $invoice->type = Facture::TYPE_STANDARD;
2103 $invoice->cond_reglement_id = $customer->cond_reglement_id;
2104 if (empty($invoice->cond_reglement_id)) {
2105 $paymenttermstatic = new PaymentTerm($this->db);
2106 $invoice->cond_reglement_id = $paymenttermstatic->getDefaultId();
2107 if (empty($invoice->cond_reglement_id)) {
2108 $error++;
2109 $this->error = 'ErrorNoPaymentTermRECEPFound';
2110 $this->errors[] = $this->error;
2111 }
2112 }
2113 $invoice->socid = $this->socid;
2114 // set customer's payment bank account on the invoice
2115 if (!empty($customer->fk_account)) {
2116 $invoice->fk_account = $customer->fk_account;
2117 } elseif (getDolGlobalString('FACTURE_RIB_NUMBER')) {
2118 // set default bank account from invoice module settings
2119 $invoice->fk_account = (int) getDolGlobalString('FACTURE_RIB_NUMBER');
2120 }
2121 //set customer's payment method on the invoice
2122 if (!empty($customer->mode_reglement_id)) {
2123 $invoice->mode_reglement_id = $customer->mode_reglement_id;
2124 }
2125 //$invoice->date = $datesubscription;
2126 $invoice->date = dol_now();
2127
2128 // Possibility to add external linked objects with hooks
2129 $invoice->linked_objects['subscription'] = $subscriptionid;
2130 if (GETPOSTISARRAY('other_linked_objects')) {
2131 $invoice->linked_objects = array_merge($invoice->linked_objects, GETPOST('other_linked_objects', 'array:int'));
2132 }
2133
2134 $result = $invoice->create($user);
2135 if ($result <= 0) {
2136 $this->setErrorsFromObject($invoice);
2137 $error++;
2138 } else {
2139 $this->invoice = $invoice;
2140 }
2141 }
2142
2143 if (!$error) {
2144 // Add line to draft invoice
2145 $idprodsubscription = 0;
2146 if (getDolGlobalString('ADHERENT_PRODUCT_ID_FOR_SUBSCRIPTIONS') && (isModEnabled("product") || isModEnabled("service"))) {
2147 $idprodsubscription = getDolGlobalString('ADHERENT_PRODUCT_ID_FOR_SUBSCRIPTIONS');
2148 }
2149
2150 $vattouse = 0;
2151 if (getDolGlobalString('ADHERENT_VAT_FOR_SUBSCRIPTIONS') == 'defaultforfoundationcountry') {
2152 $vattouse = get_default_tva($mysoc, $mysoc, $idprodsubscription);
2153 }
2154 //print xx".$vattouse." - ".$mysoc." - ".$customer;exit;
2155 // @phan-suppress-next-line PhanPluginSuspiciousParamPosition
2156 $result = $invoice->addline($label, 0, 1, $vattouse, 0, 0, $idprodsubscription, 0, $datesubscription, '', 0, 0, 0, 'TTC', $amount, 1);
2157 if ($result <= 0) {
2158 $this->setErrorsFromObject($invoice);
2159 $error++;
2160 }
2161 }
2162
2163 if (!$error) {
2164 // Validate invoice
2165 $result = $invoice->validate($user);
2166 if ($result <= 0) {
2167 $this->setErrorsFromObject($invoice);
2168 $error++;
2169 }
2170 }
2171
2172 if (!$error) {
2173 // TODO Link invoice with subscription ?
2174 }
2175
2176 // Add payment onto invoice
2177 if (!$error && $option == 'bankviainvoice' && $accountid) {
2178 require_once DOL_DOCUMENT_ROOT.'/compta/paiement/class/paiement.class.php';
2179 require_once DOL_DOCUMENT_ROOT.'/compta/bank/class/account.class.php';
2180 require_once DOL_DOCUMENT_ROOT.'/core/lib/functions.lib.php';
2181
2182 $amounts = array();
2183 $amounts[$invoice->id] = (float) price2num($amount);
2184
2185 $paiement = new Paiement($this->db);
2186 $paiement->datepaye = $paymentdate;
2187 $paiement->amounts = $amounts;
2188 $paiement->paiementcode = $operation;
2189 $paiement->paiementid = dol_getIdFromCode($this->db, $operation, 'c_paiement', 'code', 'id', 1);
2190 $paiement->num_payment = $num_chq;
2191 $paiement->note_public = $label;
2192 $paiement->ext_payment_id = $ext_payment_id;
2193 $paiement->ext_payment_site = $ext_payment_site;
2194
2195 // Create payment line for invoice
2196 $paiement_id = $paiement->create($user);
2197 if (!($paiement_id > 0)) {
2198 $this->setErrorsFromObject($paiement);
2199 $error++;
2200 }
2201
2202 if (!$error) {
2203 // Add transaction into bank account
2204 $bank_line_id = $paiement->addPaymentToBank($user, 'payment', '(SubscriptionPayment)', $accountid, $emetteur_nom, $emetteur_banque);
2205 if (!($bank_line_id > 0)) {
2206 $this->setErrorsFromObject($paiement);
2207 $error++;
2208 }
2209 }
2210
2211 if (!$error && !empty($bank_line_id)) {
2212 // Update fk_bank into subscription table
2213 $sql = 'UPDATE '.MAIN_DB_PREFIX.'subscription SET fk_bank='.((int) $bank_line_id);
2214 $sql .= ' WHERE rowid='.((int) $subscriptionid);
2215
2216 $result = $this->db->query($sql);
2217 if (!$result) {
2218 $error++;
2219 }
2220 }
2221
2222 if (!$error) {
2223 // Set invoice as paid
2224 $invoice->setPaid($user);
2225 }
2226 }
2227
2228 if (!$error) {
2229 // Define output language
2230 $outputlangs = $langs;
2231 $newlang = '';
2232 $lang_id = GETPOST('lang_id');
2233 if (getDolGlobalInt('MAIN_MULTILANGS') && empty($newlang) && !empty($lang_id)) {
2234 $newlang = $lang_id;
2235 }
2236 if (getDolGlobalInt('MAIN_MULTILANGS') && empty($newlang)) {
2237 $newlang = $customer->default_lang;
2238 }
2239 if (!empty($newlang)) {
2240 $outputlangs = new Translate("", $conf);
2241 $outputlangs->setDefaultLang($newlang);
2242 }
2243 // Generate PDF (whatever is option MAIN_DISABLE_PDF_AUTOUPDATE) so we can include it into email
2244 //if (!getDolGlobalString('MAIN_DISABLE_PDF_AUTOUPDATE'))
2245
2246 $invoice->fetch($invoice->id); // Reload invoice object data
2247 $invoice->generateDocument($invoice->model_pdf, $outputlangs);
2248 }
2249 }
2250
2251 if ($error) {
2252 return -1;
2253 } else {
2254 return 1;
2255 }
2256 }
2257
2258
2265 public function validate($user)
2266 {
2267 global $langs, $conf;
2268
2269 $error = 0;
2270 $now = dol_now();
2271
2272 // Check parameters
2273 if ($this->statut == self::STATUS_VALIDATED) {
2274 dol_syslog(get_class($this)."::validate statut of member does not allow this", LOG_WARNING);
2275 return 0;
2276 }
2277
2278 $this->db->begin();
2279
2280 $sql = "UPDATE ".MAIN_DB_PREFIX."adherent SET";
2281 $sql .= " statut = ".self::STATUS_VALIDATED;
2282 $sql .= ", datevalid = '".$this->db->idate($now)."'";
2283 $sql .= ", fk_user_valid = ".((int) $user->id);
2284 $sql .= " WHERE rowid = ".((int) $this->id);
2285
2286 dol_syslog(get_class($this)."::validate", LOG_DEBUG);
2287 $result = $this->db->query($sql);
2288 if ($result) {
2289 $this->statut = self::STATUS_VALIDATED;
2290
2291 // Call trigger
2292 $result = $this->call_trigger('MEMBER_VALIDATE', $user);
2293 if ($result < 0) {
2294 $error++;
2295 $this->db->rollback();
2296 return -1;
2297 }
2298 // End call triggers
2299
2300 $this->datevalid = $now;
2301
2302 $this->db->commit();
2303 return 1;
2304 } else {
2305 $this->error = $this->db->error();
2306 $this->db->rollback();
2307 return -1;
2308 }
2309 }
2310
2311
2318 public function resiliate($user)
2319 {
2320 global $langs, $conf;
2321
2322 $error = 0;
2323
2324 // Check parameters
2325 if ($this->statut == self::STATUS_RESILIATED) {
2326 dol_syslog(get_class($this)."::resiliate statut of member does not allow this", LOG_WARNING);
2327 return 0;
2328 }
2329
2330 $this->db->begin();
2331
2332 $sql = "UPDATE ".MAIN_DB_PREFIX."adherent SET";
2333 $sql .= " statut = ".((int) self::STATUS_RESILIATED);
2334 $sql .= ", fk_user_valid = ".((int) $user->id);
2335 $sql .= " WHERE rowid = ".((int) $this->id);
2336
2337 $result = $this->db->query($sql);
2338 if ($result) {
2339 $this->statut = self::STATUS_RESILIATED;
2340
2341 // Call trigger
2342 $result = $this->call_trigger('MEMBER_RESILIATE', $user);
2343 if ($result < 0) {
2344 $error++;
2345 $this->db->rollback();
2346 return -1;
2347 }
2348 // End call triggers
2349
2350 $this->db->commit();
2351 return 1;
2352 } else {
2353 $this->error = $this->db->error();
2354 $this->db->rollback();
2355 return -1;
2356 }
2357 }
2358
2368 public function exclude($user)
2369 {
2370 $error = 0;
2371
2372 // Check parameters
2373 if ($this->statut == self::STATUS_EXCLUDED) {
2374 dol_syslog(get_class($this)."::resiliate statut of member does not allow this", LOG_WARNING);
2375 return 0;
2376 }
2377
2378 $this->db->begin();
2379
2380 $sql = "UPDATE ".MAIN_DB_PREFIX."adherent SET";
2381 $sql .= " statut = ".((int) self::STATUS_EXCLUDED);
2382 $sql .= ", fk_user_valid = ".((int) $user->id);
2383 $sql .= " WHERE rowid = ".((int) $this->id);
2384
2385 $result = $this->db->query($sql);
2386 if ($result) {
2387 $this->statut = self::STATUS_EXCLUDED;
2388
2389 // Call trigger
2390 $result = $this->call_trigger('MEMBER_EXCLUDE', $user);
2391 if ($result < 0) {
2392 $error++;
2393 $this->db->rollback();
2394 return -1;
2395 }
2396 // End call triggers
2397
2398 $this->db->commit();
2399 return 1;
2400 } else {
2401 $this->error = $this->db->error();
2402 $this->db->rollback();
2403 return -1;
2404 }
2405 }
2406
2407 // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps
2413 public function add_to_abo()
2414 {
2415 // phpcs:enable
2416 global $langs;
2417
2418 include_once DOL_DOCUMENT_ROOT.'/mailmanspip/class/mailmanspip.class.php';
2419 $mailmanspip = new MailmanSpip($this->db);
2420
2421 $err = 0;
2422
2423 // mailman
2424 if (getDolGlobalString('ADHERENT_USE_MAILMAN') && isModEnabled('mailmanspip')) {
2425 $result = $mailmanspip->add_to_mailman($this);
2426
2427 if ($result < 0) {
2428 if (!empty($mailmanspip->error)) {
2429 $this->errors[] = $mailmanspip->error;
2430 }
2431 $err += 1;
2432 }
2433 foreach ($mailmanspip->mladded_ko as $tmplist => $tmpemail) {
2434 $langs->load("errors");
2435 $this->errors[] = $langs->trans("ErrorFailedToAddToMailmanList", $tmpemail, $tmplist);
2436 }
2437 foreach ($mailmanspip->mladded_ok as $tmplist => $tmpemail) {
2438 $langs->load("mailmanspip");
2439 $this->mesgs[] = $langs->trans("SuccessToAddToMailmanList", $tmpemail, $tmplist);
2440 }
2441 }
2442
2443 // spip
2444 if (getDolGlobalString('ADHERENT_USE_SPIP') && isModEnabled('mailmanspip')) {
2445 $result = $mailmanspip->add_to_spip($this);
2446 if ($result < 0) {
2447 $this->errors[] = $mailmanspip->error;
2448 $err += 1;
2449 }
2450 }
2451 if ($err) {
2452 return -$err;
2453 } else {
2454 return 1;
2455 }
2456 }
2457
2458
2459 // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps
2465 public function del_to_abo()
2466 {
2467 // phpcs:enable
2468 global $conf, $langs;
2469
2470 include_once DOL_DOCUMENT_ROOT.'/mailmanspip/class/mailmanspip.class.php';
2471 $mailmanspip = new MailmanSpip($this->db);
2472
2473 $err = 0;
2474
2475 // mailman
2476 if (getDolGlobalString('ADHERENT_USE_MAILMAN')) {
2477 $result = $mailmanspip->del_to_mailman($this);
2478 if ($result < 0) {
2479 if (!empty($mailmanspip->error)) {
2480 $this->errors[] = $mailmanspip->error;
2481 }
2482 $err += 1;
2483 }
2484
2485 foreach ($mailmanspip->mlremoved_ko as $tmplist => $tmpemail) {
2486 $langs->load("errors");
2487 $this->errors[] = $langs->trans("ErrorFailedToRemoveToMailmanList", $tmpemail, $tmplist);
2488 }
2489 foreach ($mailmanspip->mlremoved_ok as $tmplist => $tmpemail) {
2490 $langs->load("mailmanspip");
2491 $this->mesgs[] = $langs->trans("SuccessToRemoveToMailmanList", $tmpemail, $tmplist);
2492 }
2493 }
2494
2495 if (getDolGlobalString('ADHERENT_USE_SPIP') && isModEnabled('mailmanspip')) {
2496 $result = $mailmanspip->del_to_spip($this);
2497 if ($result < 0) {
2498 $this->errors[] = $mailmanspip->error;
2499 $err += 1;
2500 }
2501 }
2502 if ($err) {
2503 // error
2504 return -$err;
2505 } else {
2506 return 1;
2507 }
2508 }
2509
2510
2516 public function getCivilityLabel()
2517 {
2518 global $langs;
2519 $langs->load("dict");
2520
2521 $code = (empty($this->civility_id) ? '' : $this->civility_id);
2522 if (empty($code)) {
2523 return '';
2524 }
2525 return $langs->getLabelFromKey($this->db, "Civility".$code, "c_civility", "code", "label", $code);
2526 }
2527
2534 public function getTooltipContentArray($params)
2535 {
2536 global $langs;
2537
2538 $langs->loadLangs(['members', 'companies']);
2539 $nofetch = !empty($params['nofetch']);
2540
2541 $datas = array();
2542
2543 if (getDolGlobalString('MAIN_OPTIMIZEFORTEXTBROWSER')) {
2544 $langs->load("users");
2545 return ['optimize' => $langs->trans("ShowUser")];
2546 }
2547 if (!empty($this->photo)) {
2548 $photo = '<div class="photointooltip floatright">';
2549 $photo .= Form::showphoto('memberphoto', $this, 80, 0, 0, 'photoref photowithmargin photologintooltip', 'small', 0, 1);
2550 $photo .= '</div>';
2551 $datas['photo'] = $photo;
2552 }
2553
2554 $datas['divopen'] = '<div class="centpercent">';
2555 $datas['picto'] = img_picto('', $this->picto).' <u class="paddingrightonly">'.$langs->trans("Member").'</u> '.$this->getLibStatut(4);
2556 if (!empty($this->morphy)) {
2557 $datas['picto'] .= '&nbsp;' . $this->getmorphylib('', 1);
2558 }
2559 if (!empty($this->ref)) {
2560 $datas['ref'] = '<br><b>'.$langs->trans('Ref').':</b> '.$this->ref;
2561 }
2562 if (!empty($this->login)) {
2563 $datas['login'] = '<br><b>'.$langs->trans('Login').':</b> '.$this->login;
2564 }
2565 if (!empty($this->firstname) || !empty($this->lastname)) {
2566 $datas['name'] = '<br><b>'.$langs->trans('Name').':</b> '.$this->getFullName($langs);
2567 }
2568 if (!empty($this->company)) {
2569 $datas['company'] = '<br><b>'.$langs->trans('Company').':</b> '.$this->company;
2570 }
2571 if (!empty($this->email)) {
2572 $datas['email'] = '<br><b>'.$langs->trans("EMail").':</b> '.$this->email;
2573 }
2574 $datas['address'] = '<br><b>'.$langs->trans("Address").':</b> '.dol_format_address($this, 1, ' ', $langs);
2575 // show categories for this record only in ajax to not overload lists
2576 if (isModEnabled('category') && !$nofetch) {
2577 require_once DOL_DOCUMENT_ROOT . '/categories/class/categorie.class.php';
2578 $form = new Form($this->db);
2579 $datas['categories'] = '<br>' . $form->showCategories($this->id, Categorie::TYPE_MEMBER, 1);
2580 }
2581 $datas['divclose'] = '</div>';
2582
2583 return $datas;
2584 }
2585
2599 public function getNomUrl($withpictoimg = 0, $maxlen = 0, $option = 'card', $mode = '', $morecss = '', $save_lastsearch_value = -1, $notooltip = 0, $addlinktonotes = 0)
2600 {
2601 global $conf, $langs, $hookmanager;
2602
2603 if (getDolGlobalString('MAIN_OPTIMIZEFORTEXTBROWSER') && $withpictoimg) {
2604 $withpictoimg = 0;
2605 }
2606
2607 $result = '';
2608 $linkstart = '';
2609 $linkend = '';
2610 $classfortooltip = 'classfortooltip';
2611 $dataparams = '';
2612 $params = [
2613 'id' => $this->id,
2614 'objecttype' => $this->element,
2615 'option' => $option,
2616 'nofetch' => 1,
2617 ];
2618 if (getDolGlobalInt('MAIN_ENABLE_AJAX_TOOLTIP')) {
2619 $classfortooltip = 'classforajaxtooltip';
2620 $dataparams = ' data-params="'.dol_escape_htmltag(json_encode($params)).'"';
2621 $label = '';
2622 } else {
2623 $label = implode($this->getTooltipContentArray($params));
2624 }
2625
2626 $baseurl = DOL_URL_ROOT . '/adherents/card.php';
2627 if ($option == 'subscription') {
2628 $baseurl = DOL_URL_ROOT . '/adherents/subscription.php';
2629 }
2630 $query = ['rowid' => $this->id];
2631
2632 if ($option != 'nolink') {
2633 // Add param to save lastsearch_values or not
2634 $add_save_lastsearch_values = ($save_lastsearch_value == 1 ? 1 : 0);
2635 if ($save_lastsearch_value == -1 && isset($_SERVER["PHP_SELF"]) && preg_match('/list\.php/', $_SERVER["PHP_SELF"])) {
2636 $add_save_lastsearch_values = 1;
2637 }
2638 if ($add_save_lastsearch_values) {
2639 $query = array_merge($query, ['save_lastsearch_values' => 1]);
2640 }
2641 }
2642 $url = dolBuildUrl($baseurl, $query);
2643
2644 $linkstart .= '<a href="'.$url.'"';
2645 $linkclose = "";
2646 if (empty($notooltip)) {
2647 if (getDolGlobalString('MAIN_OPTIMIZEFORTEXTBROWSER')) {
2648 $langs->load("users");
2649 $label = $langs->trans("ShowUser");
2650 $linkclose .= ' alt="'.dolPrintHTMLForAttribute($label).'"';
2651 }
2652 $linkclose .= ($label ? ' title="'.dolPrintHTMLForAttribute($label).'"' : ' title="tocomplete"');
2653 $linkclose .= $dataparams.' class="'.$classfortooltip.($morecss ? ' '.$morecss : '').'"';
2654 }
2655
2656 $linkstart .= $linkclose.'>';
2657 $linkend = '</a>';
2658
2659 $result .= $linkstart;
2660
2661 if ($withpictoimg) {
2662 if (abs($withpictoimg) == 1 || abs($withpictoimg) == 4) {
2663 $morecss .= ' paddingrightonly';
2664 }
2665 // Only picto
2666 if ($withpictoimg > 0) {
2667 $picto = '<span class="nopadding'.($morecss ? ' userimg'.$morecss : '').'">'.img_object('', 'user', ' '.($notooltip ? '' : $dataparams), 0, 0, $notooltip ? 0 : 1).'</span>';
2668 } else {
2669 // Picto must be a photo
2670 $picto = '<span class="nopadding'.($morecss ? ' userimg'.$morecss : '').'">';
2671 $picto .= Form::showphoto('memberphoto', $this, 0, 0, 0, 'userphoto'.(($withpictoimg == -3 || $withpictoimg == -4) ? 'small' : ''), 'mini', 0, 1);
2672 $picto .= '</span>';
2673 }
2674 $result .= $picto;
2675 }
2676 if (($withpictoimg > -2 && $withpictoimg != 2) || $withpictoimg == -4) {
2677 if (!getDolGlobalString('MAIN_OPTIMIZEFORTEXTBROWSER')) {
2678 $result .= '<span class="nopadding valignmiddle'.((!isset($this->status) || $this->status) ? '' : ' strikefordisabled').
2679 ($morecss ? ' usertext'.$morecss : '').'">';
2680 }
2681 if ($mode == 'login') {
2682 $result .= dol_trunc(isset($this->login) ? $this->login : '', $maxlen);
2683 } elseif ($mode == 'ref') {
2684 $result .= $this->ref;
2685 } else {
2686 $result .= $this->getFullName($langs, 0, ($mode == 'firstname' ? 2 : ($mode == 'lastname' ? 4 : -1)), $maxlen);
2687 }
2688 if (!getDolGlobalString('MAIN_OPTIMIZEFORTEXTBROWSER')) {
2689 $result .= '</span>';
2690 }
2691 }
2692
2693 $result .= $linkend;
2694
2695 if ($addlinktonotes) {
2696 if ($this->note_private) {
2697 $notetoshow = $langs->trans("ViewPrivateNote").':<br>'.dol_string_nohtmltag($this->note_private, 1);
2698 $result .= ' <span class="note inline-block">';
2699 $result .= '<a href="'.DOL_URL_ROOT.'/adherents/note.php?id='.$this->id.'" class="classfortooltip" title="'.dol_escape_htmltag($notetoshow).'">';
2700 $result .= img_picto('', 'note');
2701 $result .= '</a>';
2702 $result .= '</span>';
2703 }
2704 }
2705 global $action;
2706 $hookmanager->initHooks(array($this->element . 'dao'));
2707 $parameters = array('id' => $this->id, 'getnomurl' => &$result);
2708 $reshook = $hookmanager->executeHooks('getNomUrl', $parameters, $this, $action); // Note that $action and $object may have been modified by some hooks
2709 if ($reshook > 0) {
2710 $result = $hookmanager->resPrint;
2711 } else {
2712 $result .= $hookmanager->resPrint;
2713 }
2714 return $result;
2715 }
2716
2723 public function getLibStatut($mode = 0)
2724 {
2725 return $this->LibStatut($this->status, $this->need_subscription, $this->datefin, $mode);
2726 }
2727
2728 // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps
2738 public function LibStatut($status, $need_subscription, $date_end_subscription, $mode = 0)
2739 {
2740 // phpcs:enable
2741 global $langs;
2742 $langs->load("members");
2743
2744 $statusType = '';
2745 $labelStatus = '';
2746 $labelStatusShort = '';
2747
2748 if ($status == self::STATUS_DRAFT) {
2749 $statusType = 'status0';
2750 $labelStatus = $langs->trans("MemberStatusDraft");
2751 $labelStatusShort = $langs->trans("MemberStatusDraftShort");
2752 } elseif ($status >= self::STATUS_VALIDATED) {
2753 if (empty($need_subscription)) {
2754 $statusType = 'status4';
2755 $labelStatus = $langs->trans("Validated").' - '.$langs->trans("SubscriptionNotNeeded");
2756 $labelStatusShort = $langs->trans("MemberStatusNoSubscriptionShort");
2757 } elseif (!$date_end_subscription) {
2758 $statusType = 'status1';
2759 $labelStatus = $langs->trans("Validated").' - '.$langs->trans("WaitingSubscription");
2760 $labelStatusShort = $langs->trans("WaitingSubscriptionShort");
2761 } elseif ($date_end_subscription < dol_now()) { // expired
2762 $statusType = 'status2';
2763 $labelStatus = $langs->trans("Validated").' - '.$langs->trans("MemberStatusActiveLate");
2764 $labelStatusShort = $langs->trans("MemberStatusActiveLateShort");
2765 } else {
2766 $statusType = 'status4';
2767 $labelStatus = $langs->trans("Validated").' - '.$langs->trans("MemberStatusPaid");
2768 $labelStatusShort = $langs->trans("MemberStatusPaidShort");
2769 }
2770 } elseif ($status == self::STATUS_RESILIATED) {
2771 $statusType = 'status6';
2772 $labelStatus = $langs->transnoentitiesnoconv("MemberStatusResiliated");
2773 $labelStatusShort = $langs->transnoentitiesnoconv("MemberStatusResiliatedShort");
2774 } elseif ($status == self::STATUS_EXCLUDED) {
2775 $statusType = 'status10';
2776 $labelStatus = $langs->transnoentitiesnoconv("MemberStatusExcluded");
2777 $labelStatusShort = $langs->transnoentitiesnoconv("MemberStatusExcludedShort");
2778 }
2779
2780 return dolGetStatus($labelStatus, $labelStatusShort, '', $statusType, $mode);
2781 }
2782
2783
2789 public function loadStateBoard()
2790 {
2791 global $conf;
2792
2793 $this->nb = array();
2794
2795 $sql = "SELECT count(a.rowid) as nb";
2796 $sql .= " FROM ".MAIN_DB_PREFIX."adherent as a";
2797 $sql .= " WHERE a.statut > 0";
2798 $sql .= " AND a.entity IN (".getEntity('adherent').")";
2799
2800 $resql = $this->db->query($sql);
2801 if ($resql) {
2802 while ($obj = $this->db->fetch_object($resql)) {
2803 $this->nb["members"] = $obj->nb;
2804 }
2805 $this->db->free($resql);
2806 return 1;
2807 } else {
2808 dol_print_error($this->db);
2809 $this->error = $this->db->error();
2810 return -1;
2811 }
2812 }
2813
2814 // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps
2822 public function load_board($user, $mode)
2823 {
2824 // phpcs:enable
2825 global $conf, $langs;
2826
2827 if ($user->socid) {
2828 return -1; // protection pour eviter appel par utilisateur externe
2829 }
2830
2831 $now = dol_now();
2832
2833 $sql = "SELECT a.rowid, a.datefin, a.statut as status";
2834 $sql .= " FROM ".MAIN_DB_PREFIX."adherent as a";
2835 $sql .= ", ".MAIN_DB_PREFIX."adherent_type as t";
2836 $sql .= " WHERE a.fk_adherent_type = t.rowid";
2837 if ($mode == 'expired') {
2838 $sql .= " AND a.statut = ".self::STATUS_VALIDATED;
2839 $sql .= " AND a.entity IN (".getEntity('adherent').")";
2840 $sql .= " AND ((a.datefin IS NULL or a.datefin < '".$this->db->idate($now)."') AND t.subscription = '1')";
2841 } elseif ($mode == 'shift') {
2842 $sql .= " AND a.statut = ".self::STATUS_DRAFT;
2843 $sql .= " AND a.entity IN (".getEntity('adherent').")";
2844 }
2845
2846 $resql = $this->db->query($sql);
2847 if ($resql) {
2848 $langs->load("members");
2849
2850 $warning_delay = 0;
2851 $url = '';
2852 $label = '';
2853 $labelShort = '';
2854
2855 if ($mode == 'expired') {
2856 $warning_delay = getWarningDelay('member', 'subscription') / 60 / 60 / 24;
2857 $label = $langs->trans("MembersWithSubscriptionToReceive");
2858 $labelShort = $langs->trans("MembersWithSubscriptionToReceiveShort");
2859 $url = dolBuildUrl(DOL_URL_ROOT.'/adherents/list.php', ['mainmenu' => 'members', 'statut' => self::STATUS_VALIDATED, 'filter' => 'outofdate']);
2860 } elseif ($mode == 'shift') {
2861 $warning_delay = getWarningDelay('member', 'subscription') / 60 / 60 / 24;
2862 $url = dolBuildUrl(DOL_URL_ROOT.'/adherents/list.php', ['mainmenu' => 'members', 'statut' => self::STATUS_DRAFT]);
2863 $label = $langs->trans("MembersListToValid");
2864 $labelShort = $langs->trans("ToValidate");
2865 }
2866
2867 $response = new WorkboardResponse();
2868 $response->warning_delay = $warning_delay;
2869 $response->label = $label;
2870 $response->labelShort = $labelShort;
2871 $response->url = $url;
2872 $response->img = img_object('', "user");
2873
2874 $adherentstatic = new Adherent($this->db);
2875
2876 while ($obj = $this->db->fetch_object($resql)) {
2877 $response->nbtodo++;
2878
2879 $adherentstatic->datefin = $this->db->jdate($obj->datefin);
2880 $adherentstatic->statut = $obj->status;
2881 $adherentstatic->status = $obj->status;
2882
2883 if ($adherentstatic->hasDelay()) {
2884 $response->nbtodolate++;
2885 }
2886 }
2887
2888 return $response;
2889 } else {
2890 dol_print_error($this->db);
2891 $this->error = $this->db->error();
2892 return -1;
2893 }
2894 }
2895
2896
2908 public function generateDocument($modele, $outputlangs, $hidedetails = 0, $hidedesc = 0, $hideref = 0, $moreparams = null)
2909 {
2910 global $conf, $langs;
2911
2912 $langs->load("orders");
2913
2914 if (!dol_strlen($modele)) {
2915 $modele = 'standard';
2916
2917 if ($this->model_pdf) {
2918 $modele = $this->model_pdf;
2919 } elseif (getDolGlobalString('ADHERENT_ADDON_PDF')) {
2920 $modele = getDolGlobalString('ADHERENT_ADDON_PDF');
2921 }
2922 }
2923
2924 $modelpath = "core/modules/member/doc/";
2925
2926 return $this->commonGenerateDocument($modelpath, $modele, $outputlangs, $hidedetails, $hidedesc, $hideref, $moreparams);
2927 }
2928
2929
2937 public function initAsSpecimen()
2938 {
2939 global $user, $langs;
2940 $now = dol_now();
2941
2942 // Initialise parameters
2943 $this->id = 0;
2944 $this->ref = 'ABC001';
2945 $this->entity = 1;
2946 $this->specimen = 1;
2947 $this->civility_id = 'MR';
2948 $this->lastname = 'DOLIBARR';
2949 $this->firstname = 'SPECIMEN';
2950 $this->gender = 'man';
2951 $this->login = 'dolibspec';
2952 $this->pass = 'dolibspec';
2953 $this->company = 'Societe ABC';
2954 $this->address = '61 jump street';
2955 $this->zip = '75000';
2956 $this->town = 'Paris';
2957 $this->country_id = 1;
2958 $this->country_code = 'FR';
2959 $this->country = 'France';
2960 $this->morphy = 'mor';
2961 $this->email = 'specimen@specimen.com';
2962 $this->socialnetworks = array(
2963 'skype' => 'skypepseudo',
2964 'twitter' => 'twitterpseudo',
2965 'facebook' => 'facebookpseudo',
2966 'linkedin' => 'linkedinpseudo',
2967 );
2968 $this->phone = '0999999999';
2969 $this->phone_perso = '0999999998';
2970 $this->phone_mobile = '0999999997';
2971 $this->note_public = 'This is a public note';
2972 $this->note_private = 'This is a private note';
2973 $this->birth = $now;
2974 $this->photo = '';
2975 $this->public = 1;
2976 $this->statut = self::STATUS_DRAFT;
2977 $this->status = self::STATUS_DRAFT;
2978
2979 $this->datefin = $now;
2980 $this->datevalid = $now;
2981 $this->default_lang = '';
2982
2983 $this->typeid = 1; // Id type adherent
2984 $this->type = 'Type adherent'; // Libelle type adherent
2985 $this->need_subscription = 0;
2986
2987 $this->first_subscription_date = $now;
2988 $this->first_subscription_date_start = $this->first_subscription_date;
2989 $this->first_subscription_date_end = dol_time_plus_duree($this->first_subscription_date_start, 1, 'y');
2990 $this->first_subscription_amount = 10;
2991
2992 $this->last_subscription_date = $this->first_subscription_date;
2993 $this->last_subscription_date_start = $this->first_subscription_date;
2994 $this->last_subscription_date_end = dol_time_plus_duree($this->last_subscription_date_start, 1, 'y');
2995 $this->last_subscription_amount = 10;
2996 return 1;
2997 }
2998
2999
3000 // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps
3001 // phpcs:disable PEAR.NamingConventions.ValidFunctionName.PublicUnderscore
3011 public function _load_ldap_dn($info, $mode = 0)
3012 {
3013 // phpcs:enable
3014 global $conf;
3015 $dn = '';
3016 if ($mode == 0) {
3017 $dn = getDolGlobalString('LDAP_KEY_MEMBERS') . "=".$info[getDolGlobalString('LDAP_KEY_MEMBERS')]."," . getDolGlobalString('LDAP_MEMBER_DN');
3018 }
3019 if ($mode == 1) {
3020 $dn = getDolGlobalString('LDAP_MEMBER_DN');
3021 }
3022 if ($mode == 2) {
3023 $dn = getDolGlobalString('LDAP_KEY_MEMBERS') . "=".$info[getDolGlobalString('LDAP_KEY_MEMBERS')];
3024 }
3025 return $dn;
3026 }
3027
3028
3029 // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps
3030 // phpcs:disable PEAR.NamingConventions.ValidFunctionName.PublicUnderscore
3036 public function _load_ldap_info()
3037 {
3038 // phpcs:enable
3039 global $conf, $langs;
3040
3041 $info = array();
3042 $socialnetworks = getArrayOfSocialNetworks();
3043 $keymodified = false;
3044
3045 // Object classes
3046 $info["objectclass"] = explode(',', getDolGlobalString('LDAP_MEMBER_OBJECT_CLASS'));
3047
3048 $this->fullname = $this->getFullName($langs);
3049
3050 // For avoid ldap error when firstname and lastname are empty
3051 if ($this->morphy == 'mor' && (empty($this->fullname) || $this->fullname == $this->company)) {
3052 $this->fullname = $this->company;
3053 $this->lastname = $this->company;
3054 }
3055
3056 // Possible LDAP KEY (constname => varname)
3057 $ldapkey = array(
3058 'LDAP_MEMBER_FIELD_FULLNAME' => 'fullname',
3059 'LDAP_MEMBER_FIELD_NAME' => 'lastname',
3060 'LDAP_MEMBER_FIELD_LOGIN' => 'login',
3061 'LDAP_MEMBER_FIELD_LOGIN_SAMBA' => 'login',
3062 'LDAP_MEMBER_FIELD_MAIL' => 'email'
3063 );
3064
3065 // Member
3066 foreach ($ldapkey as $constname => $varname) {
3067 if (!empty($this->$varname) && getDolGlobalString($constname)) {
3068 $info[getDolGlobalString($constname)] = $this->$varname;
3069
3070 // Check if it is the LDAP key and if its value has been changed
3071 if (getDolGlobalString('LDAP_KEY_MEMBERS') && getDolGlobalString('LDAP_KEY_MEMBERS') == getDolGlobalString($constname)) {
3072 if (!empty($this->oldcopy) && $this->$varname != $this->oldcopy->$varname) {
3073 $keymodified = true; // For check if LDAP key has been modified
3074 }
3075 }
3076 }
3077 }
3078 if ($this->firstname && getDolGlobalString('LDAP_MEMBER_FIELD_FIRSTNAME')) {
3079 $info[getDolGlobalString('LDAP_MEMBER_FIELD_FIRSTNAME')] = $this->firstname;
3080 }
3081 if ($this->poste && getDolGlobalString('LDAP_MEMBER_FIELD_TITLE')) {
3082 $info[getDolGlobalString('LDAP_MEMBER_FIELD_TITLE')] = $this->poste;
3083 }
3084 if ($this->company && getDolGlobalString('LDAP_MEMBER_FIELD_COMPANY')) {
3085 $info[getDolGlobalString('LDAP_MEMBER_FIELD_COMPANY')] = $this->company;
3086 }
3087 if ($this->address && getDolGlobalString('LDAP_MEMBER_FIELD_ADDRESS')) {
3088 $info[getDolGlobalString('LDAP_MEMBER_FIELD_ADDRESS')] = $this->address;
3089 }
3090 if ($this->zip && getDolGlobalString('LDAP_MEMBER_FIELD_ZIP')) {
3091 $info[getDolGlobalString('LDAP_MEMBER_FIELD_ZIP')] = $this->zip;
3092 }
3093 if ($this->town && getDolGlobalString('LDAP_MEMBER_FIELD_TOWN')) {
3094 $info[getDolGlobalString('LDAP_MEMBER_FIELD_TOWN')] = $this->town;
3095 }
3096 if ($this->country_code && getDolGlobalString('LDAP_MEMBER_FIELD_COUNTRY')) {
3097 $info[getDolGlobalString('LDAP_MEMBER_FIELD_COUNTRY')] = $this->country_code;
3098 }
3099 foreach ($socialnetworks as $key => $value) {
3100 if ($this->socialnetworks[$value['label']] && getDolGlobalString('LDAP_MEMBER_FIELD_'.strtoupper($value['label']))) {
3101 $info[getDolGlobalString('LDAP_MEMBER_FIELD_'.strtoupper($value['label']))] = $this->socialnetworks[$value['label']];
3102 }
3103 }
3104 if ($this->phone && getDolGlobalString('LDAP_MEMBER_FIELD_PHONE')) {
3105 $info[getDolGlobalString('LDAP_MEMBER_FIELD_PHONE')] = $this->phone;
3106 }
3107 if ($this->phone_perso && getDolGlobalString('LDAP_MEMBER_FIELD_PHONE_PERSO')) {
3108 $info[getDolGlobalString('LDAP_MEMBER_FIELD_PHONE_PERSO')] = $this->phone_perso;
3109 }
3110 if ($this->phone_mobile && getDolGlobalString('LDAP_MEMBER_FIELD_MOBILE')) {
3111 $info[getDolGlobalString('LDAP_MEMBER_FIELD_MOBILE')] = $this->phone_mobile;
3112 }
3113 if ($this->fax && getDolGlobalString('LDAP_MEMBER_FIELD_FAX')) {
3114 $info[getDolGlobalString('LDAP_MEMBER_FIELD_FAX')] = $this->fax;
3115 }
3116 if ($this->note_private && getDolGlobalString('LDAP_MEMBER_FIELD_DESCRIPTION')) {
3117 $info[getDolGlobalString('LDAP_MEMBER_FIELD_DESCRIPTION')] = dol_string_nohtmltag($this->note_private, 2);
3118 }
3119 if ($this->note_public && getDolGlobalString('LDAP_MEMBER_FIELD_NOTE_PUBLIC')) {
3120 $info[getDolGlobalString('LDAP_MEMBER_FIELD_NOTE_PUBLIC')] = dol_string_nohtmltag($this->note_public, 2);
3121 }
3122 if ($this->birth && getDolGlobalString('LDAP_MEMBER_FIELD_BIRTHDATE')) {
3123 $info[getDolGlobalString('LDAP_MEMBER_FIELD_BIRTHDATE')] = dol_print_date($this->birth, 'dayhourldap');
3124 }
3125 if (isset($this->statut) && getDolGlobalString('LDAP_FIELD_MEMBER_STATUS')) {
3126 $info[getDolGlobalString('LDAP_FIELD_MEMBER_STATUS')] = $this->statut;
3127 }
3128 if ($this->datefin && getDolGlobalString('LDAP_FIELD_MEMBER_END_LASTSUBSCRIPTION')) {
3129 $info[getDolGlobalString('LDAP_FIELD_MEMBER_END_LASTSUBSCRIPTION')] = dol_print_date($this->datefin, 'dayhourldap');
3130 }
3131
3132 // When password is modified
3133 if (!empty($this->pass)) {
3134 if (getDolGlobalString('LDAP_MEMBER_FIELD_PASSWORD')) {
3135 $info[getDolGlobalString('LDAP_MEMBER_FIELD_PASSWORD')] = $this->pass; // this->pass = Unencrypted password
3136 }
3137 if (getDolGlobalString('LDAP_MEMBER_FIELD_PASSWORD_CRYPTED')) {
3138 $info[getDolGlobalString('LDAP_MEMBER_FIELD_PASSWORD_CRYPTED')] = dol_hash($this->pass, 'openldap'); // Create OpenLDAP password (see LDAP_PASSWORD_HASH_TYPE)
3139 }
3140 } elseif (getDolGlobalString('LDAP_SERVER_PROTOCOLVERSION') !== '3') {
3141 // Set LDAP password if possible
3142 // If ldap key is modified and LDAPv3 we use ldap_rename function for avoid lose encrypt password
3143 if (getDolGlobalString('DATABASE_PWD_ENCRYPTED')) { // This should be on on default installation
3144 // Just for the case we use old md5 encryption (deprecated, no more used, kept for compatibility)
3145 if (!getDolGlobalString('MAIN_SECURITY_HASH_ALGO') || getDolGlobalString('MAIN_SECURITY_HASH_ALGO') == 'md5') {
3146 if ($this->pass_indatabase_crypted && getDolGlobalString('LDAP_MEMBER_FIELD_PASSWORD_CRYPTED')) {
3147 // Create OpenLDAP MD5 password from Dolibarr MD5 password
3148 // Note: This suppose that "pass_indatabase_crypted" is a md5 (this should not happen anymore)"
3149 $info[getDolGlobalString('LDAP_MEMBER_FIELD_PASSWORD_CRYPTED')] = dolGetLdapPasswordHash($this->pass_indatabase_crypted, 'md5frommd5');
3150 }
3151 }
3152 } elseif (!empty($this->pass_indatabase)) {
3153 // Use $this->pass_indatabase value if exists
3154 if (getDolGlobalString('LDAP_MEMBER_FIELD_PASSWORD')) {
3155 $info[getDolGlobalString('LDAP_MEMBER_FIELD_PASSWORD')] = $this->pass_indatabase; // $this->pass_indatabase = Unencrypted password
3156 }
3157 if (getDolGlobalString('LDAP_MEMBER_FIELD_PASSWORD_CRYPTED')) {
3158 $info[getDolGlobalString('LDAP_MEMBER_FIELD_PASSWORD_CRYPTED')] = dol_hash($this->pass_indatabase, 'openldap'); // Create OpenLDAP password (see LDAP_PASSWORD_HASH_TYPE)
3159 }
3160 }
3161 }
3162
3163 // Subscriptions
3164 if ($this->first_subscription_date && getDolGlobalString('LDAP_FIELD_MEMBER_FIRSTSUBSCRIPTION_DATE')) {
3165 $info[getDolGlobalString('LDAP_FIELD_MEMBER_FIRSTSUBSCRIPTION_DATE')] = dol_print_date($this->first_subscription_date, 'dayhourldap');
3166 }
3167 if (isset($this->first_subscription_amount) && getDolGlobalString('LDAP_FIELD_MEMBER_FIRSTSUBSCRIPTION_AMOUNT')) {
3168 $info[getDolGlobalString('LDAP_FIELD_MEMBER_FIRSTSUBSCRIPTION_AMOUNT')] = $this->first_subscription_amount;
3169 }
3170 if ($this->last_subscription_date && getDolGlobalString('LDAP_FIELD_MEMBER_LASTSUBSCRIPTION_DATE')) {
3171 $info[getDolGlobalString('LDAP_FIELD_MEMBER_LASTSUBSCRIPTION_DATE')] = dol_print_date($this->last_subscription_date, 'dayhourldap');
3172 }
3173 if (isset($this->last_subscription_amount) && getDolGlobalString('LDAP_FIELD_MEMBER_LASTSUBSCRIPTION_AMOUNT')) {
3174 $info[getDolGlobalString('LDAP_FIELD_MEMBER_LASTSUBSCRIPTION_AMOUNT')] = $this->last_subscription_amount;
3175 }
3176
3177 return $info;
3178 }
3179
3180
3187 public function info($id)
3188 {
3189 $sql = 'SELECT a.rowid, a.datec as datec,';
3190 $sql .= ' a.datevalid as datev,';
3191 $sql .= ' GREATEST(a.tms, COALESCE(aef.tms, a.tms)) as datem,';
3192 $sql .= ' a.fk_user_author, a.fk_user_valid, a.fk_user_mod';
3193 $sql .= ' FROM '.MAIN_DB_PREFIX.'adherent as a';
3194 $sql .= ' LEFT JOIN '.MAIN_DB_PREFIX.'adherent_extrafields as aef ON aef.fk_object = a.rowid';
3195 $sql .= ' WHERE a.rowid = '.((int) $id);
3196
3197 dol_syslog(get_class($this)."::info", LOG_DEBUG);
3198 $result = $this->db->query($sql);
3199 if ($result) {
3200 if ($this->db->num_rows($result)) {
3201 $obj = $this->db->fetch_object($result);
3202
3203 $this->id = $obj->rowid;
3204
3205 $this->user_creation_id = $obj->fk_user_author;
3206 $this->user_validation_id = $obj->fk_user_valid;
3207 $this->user_modification_id = $obj->fk_user_mod;
3208 $this->date_creation = $this->db->jdate($obj->datec);
3209 $this->date_validation = $this->db->jdate($obj->datev);
3210 $this->date_modification = $this->db->jdate($obj->datem);
3211 }
3212
3213 $this->db->free($result);
3214 } else {
3215 dol_print_error($this->db);
3216 }
3217 }
3218
3224 public function getNbOfEMailings()
3225 {
3226 $sql = "SELECT count(mc.email) as nb";
3227 $sql .= " FROM ".MAIN_DB_PREFIX."mailing_cibles as mc";
3228 $sql .= " WHERE mc.email = '".$this->db->escape($this->email)."'";
3229 $sql .= " AND mc.statut NOT IN (-1,0)"; // -1 erreur, 0 non envoye, 1 envoye avec success
3230
3231 $resql = $this->db->query($sql);
3232 if ($resql) {
3233 $obj = $this->db->fetch_object($resql);
3234 $nb = (int) $obj->nb;
3235
3236 $this->db->free($resql);
3237 return $nb;
3238 } else {
3239 $this->error = $this->db->error();
3240 return -1;
3241 }
3242 }
3243
3254 public function setCategories($categories)
3255 {
3256 require_once DOL_DOCUMENT_ROOT.'/categories/class/categorie.class.php';
3257 return parent::setCategoriesCommon($categories, Categorie::TYPE_MEMBER);
3258 }
3259
3268 public static function replaceThirdparty($db, $origin_id, $dest_id)
3269 {
3270 $tables = array('adherent');
3271
3272 return CommonObject::commonReplaceThirdparty($db, $origin_id, $dest_id, $tables);
3273 }
3274
3280 public function hasDelay()
3281 {
3282 global $conf;
3283
3284 //Only valid members
3285 if ($this->status != self::STATUS_VALIDATED) {
3286 return false;
3287 }
3288 if (!$this->datefin) {
3289 return false;
3290 }
3291
3292 $now = dol_now();
3293
3294 return $this->datefin < ($now - getWarningDelay('member', 'subscription'));
3295 }
3296
3297
3306 public function sendReminderForExpiredSubscription($daysbeforeendlist = '10', $fk_adherent_type = 0)
3307 {
3308 global $conf, $langs, $mysoc, $user;
3309
3310 $error = 0;
3311 $this->output = '';
3312 $this->error = '';
3313
3314 $blockingerrormsg = '';
3315
3316 if (!isModEnabled('member')) { // Should not happen. If module disabled, cron job should not be visible.
3317 $langs->load("agenda");
3318 $this->output = $langs->trans('ModuleNotEnabled', $langs->transnoentitiesnoconv("Adherent"));
3319 return 0;
3320 }
3321 if (!getDolGlobalString('MEMBER_REMINDER_EMAIL')) {
3322 $langs->load("agenda");
3323 $this->output = $langs->trans('EventRemindersByEmailNotEnabled', $langs->transnoentitiesnoconv("Adherent"));
3324 return 0;
3325 }
3326
3327 $now = dol_now();
3328 $nbok = 0;
3329 $nbko = 0;
3330
3331 $listofmembersok = array();
3332 $listofmembersko = array();
3333
3334 $arraydaysbeforeend = explode(';', $daysbeforeendlist);
3335 foreach ($arraydaysbeforeend as $daysbeforeend) { // Loop on each delay
3336 dol_syslog(__METHOD__.' - Process delta = '.$daysbeforeend, LOG_DEBUG);
3337
3338 if (!is_numeric($daysbeforeend)) {
3339 $blockingerrormsg = "Value for delta is not a numeric value";
3340 $nbko++;
3341 break;
3342 }
3343
3344 $tmp = dol_getdate($now);
3345 $datetosearchfor = dol_time_plus_duree(dol_mktime(0, 0, 0, $tmp['mon'], $tmp['mday'], $tmp['year'], 'tzserver'), (int) $daysbeforeend, 'd');
3346 $datetosearchforend = dol_time_plus_duree(dol_mktime(23, 59, 59, $tmp['mon'], $tmp['mday'], $tmp['year'], 'tzserver'), (int) $daysbeforeend, 'd');
3347
3348 $sql = 'SELECT rowid FROM '.MAIN_DB_PREFIX.'adherent';
3349 $sql .= " WHERE entity = ".((int) $conf->entity); // Do not use getEntity('adherent').")" here, we want the batch to be on its entity only;
3350 $sql .= " AND statut = 1";
3351 $sql .= " AND datefin >= '".$this->db->idate($datetosearchfor)."'";
3352 $sql .= " AND datefin <= '".$this->db->idate($datetosearchforend)."'";
3353 if ((int) $fk_adherent_type > 0) {
3354 $sql .= " AND fk_adherent_type = ".((int) $fk_adherent_type);
3355 }
3356 //$sql .= " LIMIT 10000";
3357
3358 $resql = $this->db->query($sql);
3359 if ($resql) {
3360 $num_rows = $this->db->num_rows($resql);
3361
3362 include_once DOL_DOCUMENT_ROOT.'/core/class/html.formmail.class.php';
3363 $formmail = new FormMail($this->db);
3364
3365 $i = 0;
3366 while ($i < $num_rows) {
3367 $obj = $this->db->fetch_object($resql);
3368
3369 // A new object for each member: fetch() does not reset the properties loaded for the previous member,
3370 // like ->thirdparty that would be reused for a member that has no third party.
3371 $adherent = new Adherent($this->db);
3372 $adherent->fetch($obj->rowid, '', 0, '', true, true);
3373
3374 if (empty($adherent->email)) {
3375 $nbko++;
3376 $listofmembersko[$adherent->id] = $adherent->id;
3377 } else {
3378 $thirdpartyres = $adherent->fetch_thirdparty();
3379 if ($thirdpartyres === -1) {
3380 $languagecodeformember = $mysoc->default_lang;
3381 } else {
3382 // Language code to use ($languagecodeformember) is default language of thirdparty, if no thirdparty, the language found from country of member then country of thirdparty, and if still not found we use the language of company.
3383 $languagefromcountrycode = getLanguageCodeFromCountryCode($adherent->country_code ? $adherent->country_code : (is_object($adherent->thirdparty) ? $adherent->thirdparty->country_code : ''));
3384 $languagecodeformember = (empty($adherent->thirdparty->default_lang) ? ($languagefromcountrycode ? $languagefromcountrycode : $mysoc->default_lang) : $adherent->thirdparty->default_lang);
3385 }
3386 if (!empty($adherent->default_lang)) {
3387 // The language set on the member itself has priority
3388 $languagecodeformember = $adherent->default_lang;
3389 }
3390
3391 // Send reminder email
3392 $outputlangs = new Translate('', $conf);
3393 $outputlangs->setDefaultLang($languagecodeformember);
3394 $outputlangs->loadLangs(array("main", "members"));
3395 dol_syslog("sendReminderForExpiredSubscription Language for member id ".$adherent->id." set to ".$outputlangs->defaultlang." mysoc->default_lang=".$mysoc->default_lang);
3396
3397 $arraydefaultmessage = null;
3398 $labeltouse = getDolGlobalString('ADHERENT_EMAIL_TEMPLATE_REMIND_EXPIRATION');
3399
3400 if (!empty($labeltouse)) {
3401 $arraydefaultmessage = $formmail->getEMailTemplate($this->db, 'member', $user, $outputlangs, 0, 1, $labeltouse);
3402 }
3403
3404 if (!empty($labeltouse) && is_object($arraydefaultmessage) && $arraydefaultmessage->id > 0) {
3405 $substitutionarray = getCommonSubstitutionArray($outputlangs, 0, null, $adherent);
3406 //if (is_array($adherent->thirdparty)) $substitutionarraycomp = ...
3407 complete_substitutions_array($substitutionarray, $outputlangs, $adherent);
3408
3409 $subject = make_substitutions($arraydefaultmessage->topic, $substitutionarray, $outputlangs);
3410 $msg = make_substitutions($arraydefaultmessage->content, $substitutionarray, $outputlangs);
3411 $from = getDolGlobalString('ADHERENT_MAIL_FROM', $conf->email_from);
3412 $to = $adherent->email;
3413 $cc = getDolGlobalString('ADHERENT_CC_MAIL_FROM');
3414
3415 $trackid = 'mem'.$adherent->id;
3416 $moreinheader = 'X-Dolibarr-Info: sendReminderForExpiredSubscription'."\r\n";
3417
3418 include_once DOL_DOCUMENT_ROOT.'/core/class/CMailFile.class.php';
3419 $cmail = new CMailFile($subject, $to, $from, $msg, array(), array(), array(), $cc, '', 0, 1, '', '', $trackid, $moreinheader);
3420 $result = $cmail->sendfile();
3421 if (!$result) {
3422 $error++;
3423 $this->error .= $cmail->error.' ';
3424 if (!is_null($cmail->errors)) {
3425 $this->errors += $cmail->errors;
3426 }
3427 $nbko++;
3428 $listofmembersko[$adherent->id] = $adherent->id;
3429 } else {
3430 $nbok++;
3431 $listofmembersok[$adherent->id] = $adherent->id;
3432
3433 $message = $msg;
3434 $sendto = $to;
3435 $sendtocc = '';
3436 $sendtobcc = '';
3437 $actioncode = 'EMAIL';
3438 $extraparams = array();
3439
3440 $actionmsg = '';
3441 $actionmsg2 = $langs->transnoentities('MailSentByTo', CMailFile::getValidAddress($from, 4, 0, 1), CMailFile::getValidAddress($sendto, 4, 0, 1));
3442 if ($message) {
3443 $actionmsg = $langs->transnoentities('MailFrom').': '.dol_escape_htmltag($from);
3444 $actionmsg = dol_concatdesc($actionmsg, $langs->transnoentities('MailTo').': '.dol_escape_htmltag($sendto));
3445 // if ($sendtocc) {
3446 // $actionmsg = dol_concatdesc($actionmsg, $langs->transnoentities('Bcc').": ".dol_escape_htmltag($sendtocc));
3447 // }
3448 $actionmsg = dol_concatdesc($actionmsg, $langs->transnoentities('MailTopic').": ".$subject);
3449 $actionmsg = dol_concatdesc($actionmsg, $langs->transnoentities('TextUsedInTheMessageBody').":");
3450 $actionmsg = dol_concatdesc($actionmsg, $message);
3451 }
3452
3453 require_once DOL_DOCUMENT_ROOT.'/comm/action/class/actioncomm.class.php';
3454
3455 // Insert record of emails sent
3456 $actioncomm = new ActionComm($this->db);
3457
3458 $actioncomm->type_code = 'AC_OTH_AUTO'; // Type of event ('AC_OTH', 'AC_OTH_AUTO', 'AC_XXX'...)
3459 $actioncomm->code = 'AC_'.$actioncode;
3460 $actioncomm->label = $actionmsg2;
3461 $actioncomm->note_private = $actionmsg;
3462 $actioncomm->fk_project = 0;
3463 $actioncomm->datep = $now;
3464 $actioncomm->datef = $now;
3465 $actioncomm->percentage = -1; // Not applicable
3466 $actioncomm->socid = (is_object($adherent->thirdparty) ? $adherent->thirdparty->id : 0);
3467 $actioncomm->contact_id = 0;
3468 $actioncomm->authorid = $user->id; // User saving action
3469 $actioncomm->userownerid = $user->id; // Owner of action
3470 // Fields when action is an email (content should be added into note)
3471 $actioncomm->email_msgid = $cmail->msgid;
3472 $actioncomm->email_from = $from;
3473 $actioncomm->email_sender = '';
3474 $actioncomm->email_to = $to;
3475 $actioncomm->email_tocc = $sendtocc;
3476 $actioncomm->email_tobcc = $sendtobcc;
3477 $actioncomm->email_subject = $subject;
3478 $actioncomm->errors_to = '';
3479
3480 $actioncomm->fk_element = $adherent->id;
3481 $actioncomm->elementid = $adherent->id;
3482 $actioncomm->elementtype = $adherent->element;
3483
3484 $actioncomm->extraparams = $extraparams;
3485
3486 $actioncomm->create($user);
3487 }
3488 } else {
3489 //$blockingerrormsg = "Can't find email template with label=".$labeltouse.", to use for the reminding email";
3490
3491 $error++;
3492 $this->error .= "Can't find email template with label=".$labeltouse.", to use for the reminding email ";
3493
3494 $nbko++;
3495 $listofmembersko[$adherent->id] = $adherent->id;
3496
3497 break;
3498 }
3499 }
3500
3501 $i++;
3502 }
3503 } else {
3504 $this->error = $this->db->lasterror();
3505 return 1;
3506 }
3507 }
3508
3509 if ($blockingerrormsg) {
3510 $this->error = $blockingerrormsg;
3511 return 1;
3512 } else {
3513 $this->output = 'Found '.($nbok + $nbko).' members to send reminder to.';
3514 $this->output .= ' Send email successfully to '.$nbok.' members';
3515 $listofids = '';
3516 $i = 0;
3517 foreach ($listofmembersok as $idmember) {
3518 if ($i > 100) {
3519 $listofids .= ', ...';
3520 break;
3521 }
3522 if (empty($listofids)) {
3523 $listofids .= ' [';
3524 } else {
3525 $listofids .= ', ';
3526 }
3527 $listofids .= $idmember;
3528 $i++;
3529 }
3530 if ($listofids) {
3531 $listofids .= ']';
3532 }
3533 $this->output .= ($listofids ? ' ids='.$listofids : '');
3534
3535 if ($nbko) {
3536 $this->output .= ' - Canceled for '.$nbko.' member (no email or email sending error)';
3537 $listofids = '';
3538 $i = 0;
3539 foreach ($listofmembersko as $idmember) {
3540 if ($i > 100) {
3541 $listofids .= ', ...';
3542 break;
3543 }
3544 if (empty($listofids)) {
3545 $listofids .= ' [';
3546 } else {
3547 $listofids .= ', ';
3548 }
3549 $listofids .= $idmember;
3550 $i++;
3551 }
3552 if ($listofids) {
3553 $listofids .= ']';
3554 }
3555 $this->output .= ($listofids ? ' ids='.$listofids : '');
3556 }
3557 }
3558
3559 return $nbko;
3560 }
3561
3569 public function getKanbanView($option = '', $arraydata = null)
3570 {
3571 $selected = (empty($arraydata['selected']) ? 0 : $arraydata['selected']);
3572
3573 $return = '<div class="box-flex-item box-flex-grow-zero">';
3574 $return .= '<div class="info-box info-box-sm">';
3575 $return .= '<span class="info-box-icon bg-infobox-action">';
3576 if (!empty($this->photo)) {
3577 $return .= Form::showphoto('memberphoto', $this, 0, 60, 0, 'photokanban photowithmargin photologintooltip', 'small', 0, 1);
3578 } else {
3579 $return .= img_picto('', 'user');
3580 }
3581 $return .= '</span>';
3582 $return .= '<div class="info-box-content">';
3583 $return .= '<span class="info-box-ref inline-block tdoverflowmax150 valignmiddle">' . $this->getNomUrl() . '</span>';
3584 if ($selected >= 0) {
3585 $return .= '<input id="cb'.$this->id.'" class="flat checkforselect fright" type="checkbox" name="toselect[]" value="'.$this->id.'"'.($selected ? ' checked="checked"' : '').'>';
3586 }
3587 $return .= '<br><span class="info-box-label paddingright">'.$this->getmorphylib('', 2).'</span>';
3588 $return .= '<span class="info-box-label opacitymedium">'.$this->type.'</span>';
3589
3590 $return .= '<br><div class="info-box-status paddingtop">';
3591 $return .= $this->LibStatut($this->status, $this->need_subscription, $this->datefin, 5);
3592 $return .= '</div>';
3593 $return .= '</div>';
3594 $return .= '</div>';
3595 $return .= '</div>';
3596 return $return;
3597 }
3598}
$object ref
Definition info.php:90
Class to manage bank accounts.
Class to manage agenda events (actions)
Class to manage members of a foundation.
mergeMembers($member_origin_id)
Merge a member with current one, deleting the given company $member_origin_id.
setThirdPartyId($thirdpartyid)
Set link to a third party.
hasDelay()
Return if a member is late (subscription late) or not.
exclude($user)
Functiun to exclude (set adherent.status to -2) a member TODO A private note should be added to know ...
add_to_abo()
Function to add member into external tools mailing-list, spip, etc.
loadStateBoard()
Load indicators this->nb in state board.
_load_ldap_dn($info, $mode=0)
Retourne chaine DN complete dans l'annuaire LDAP pour l'objet.
update($user, $notrigger=0, $nosyncuser=0, $nosyncuserpass=0, $nosyncthirdparty=0, $action='update')
Update a member in database (standard information and password)
setCategories($categories)
Sets object to supplied categories.
getTooltipContentArray($params)
getTooltipContentArray
getNbOfEMailings()
Return number of mass Emailing received by this member with its email.
update_end_date($user)
Update denormalized last subscription date.
static replaceThirdparty($db, $origin_id, $dest_id)
Function used to replace a thirdparty id with another one.
makeSubstitution($text)
Make substitution of tags into text with value of current object.
const STATUS_EXCLUDED
Excluded.
LibStatut($status, $need_subscription, $date_end_subscription, $mode=0)
Renvoi le libelle d'un statut donne.
fetch_name($firstname, $lastname)
Method to load member from its name.
initAsSpecimen()
Initialise an instance with random values.
del_to_abo()
Function to delete a member from external tools like mailing-list, spip, etc.
resiliate($user)
Fonction qui resilie un adherent.
getCivilityLabel()
Return civility label of a member.
getmorphylib($morphy='', $addbadge=0)
Return translated label by the nature of a adherent (physical or moral)
sendEmail($text, $subject, $filename_list=array(), $mimetype_list=array(), $mimefilename_list=array(), $addr_cc="", $addr_bcc="", $deliveryreceipt=0, $msgishtml=-1, $errors_to='', $moreinheader='')
Function sending an email to the current member with the text supplied in parameter.
fetchPartnerships($mode)
Function to get partnerships array.
load_board($user, $mode)
Load indicators for dashboard (this->nbtodo and this->nbtodolate)
setPassword($user, $password='', $isencrypted=0, $notrigger=0, $nosyncuser=0)
Change password of a user.
$fields
'type' field format: 'integer', 'integer:ObjectClass:PathToClass[:AddCreateButtonOrNot[:Filter[:Sortf...
getKanbanView($option='', $arraydata=null)
Return clickable link of object (with eventually picto)
const STATUS_DRAFT
Draft status.
const STATUS_RESILIATED
Resiliated (membership end and was not renew)
sendReminderForExpiredSubscription($daysbeforeendlist='10', $fk_adherent_type=0)
Send reminders by emails before subscription end CAN BE A CRON TASK.
fetch_login($login)
Method to load member from its login.
_load_ldap_info()
Initialise tableau info (tableau des attributes LDAP)
getLibStatut($mode=0)
Retourne le libelle du statut d'un adherent (brouillon, valide, resilie, exclu)
info($id)
Load type info information in the member object.
subscription($date, $amount, $accountid=0, $operation='', $label='', $num_chq='', $emetteur_nom='', $emetteur_banque='', $datesubend=0, $fk_type=null, $ref_ext='')
Insert subscription into database and eventually add links to banks, mailman, etc....
__construct($db)
Constructor.
send_an_email($text, $subject, $filename_list=array(), $mimetype_list=array(), $mimefilename_list=array(), $addr_cc="", $addr_bcc="", $deliveryreceipt=0, $msgishtml=-1, $errors_to='', $moreinheader='')
Function sending an email to the current member with the text supplied in parameter.
getNomUrl($withpictoimg=0, $maxlen=0, $option='card', $mode='', $morecss='', $save_lastsearch_value=-1, $notooltip=0, $addlinktonotes=0)
Return clickable name (with picto eventually)
generateDocument($modele, $outputlangs, $hidedetails=0, $hidedesc=0, $hideref=0, $moreparams=null)
Create a document onto disk according to template module.
subscriptionComplementaryActions($subscriptionid, $option, $accountid, $datesubscription, $paymentdate, $operation, $label, $amount, $num_chq, $emetteur_nom='', $emetteur_banque='', $autocreatethirdparty=0, $ext_payment_id='', $ext_payment_site='')
Do complementary actions after subscription recording.
setUserId($userid)
Set link to a user.
const STATUS_VALIDATED
Validated status.
fetch_subscriptions()
Function to get member subscriptions data: subscriptions, first_subscription_date,...
fetch($rowid, $ref='', $socid=0, $ref_ext='', $fetch_optionals=true, $fetch_subscriptions=true)
Load member from database.
validate($user)
Function that validate a member.
Class to send emails (with attachments or not) Usage: $mailfile = new CMailFile($subject,...
static getValidAddress($address, $format, $encode=0, $maxnumberofemail=0)
Return a formatted address string for SMTP protocol.
Class to manage categories.
Parent class of all other business classes (invoices, contracts, proposals, orders,...
fetch_optionals($rowid=null, $optionsArray=null)
Function to get extra fields of an object into $this->array_options This method is in most cases call...
deleteEcmFiles($mode=0)
Delete related files of object in database.
commonGenerateDocument($modelspath, $modele, $outputlangs, $hidedetails, $hidedesc, $hideref, $moreparams=null)
Common function for all objects extending CommonObject for generating documents.
deleteObjectLinked($sourceid=null, $sourcetype='', $targetid=null, $targettype='', $rowid=0, $f_user=null, $notrigger=0)
Delete all links between an object $this.
setErrorsFromObject($object)
setErrorsFromObject
deleteExtraFields()
Delete all extra fields values for the current object.
static commonReplaceThirdparty(DoliDB $dbs, $origin_id, $dest_id, array $tables, $ignoreerrors=0)
Function used to replace a thirdparty id with another one.
insertExtraFields($trigger='', $userused=null)
Add/Update all extra fields values for the current object.
Class to manage invoices.
const TYPE_STANDARD
Standard invoice.
Class to manage generation of HTML components Only common components must be here.
static showphoto($modulepart, $object, $width=100, $height=0, $caneditfield=0, $cssclass='photowithmargin', $imagesize='', $addlinktofullsize=1, $cache=0, $forcecapture='', $noexternsourceoverwrite=0, $usesharelinkifavailable=0)
Return HTML code to output a photo.
Class permettant la generation du formulaire html d'envoi de mail unitaire Usage: $formail = new Form...
Class to manage mailman and spip.
Class to manage payments of customer invoices.
Class for Partnership.
Class to manage payment terms records in dictionary.
Class to manage third parties objects (customers, suppliers, prospects...)
Class to manage subscriptions of foundation members.
Class to manage translations.
Class to manage Dolibarr users.
print $langs trans("Ref").' m titre as m m statut as status
Or an array listing all the potential status of the object: array: int of the status => translated la...
Definition index.php:171
getFullName($langs, $option=0, $nameorder=-1, $maxlen=0)
Return full name (civility+' '+name+' '+lastname)
setUpperOrLowerCase()
Set to upper or ucwords/lower if needed.
getCountry($searchkey, $withcode='', $dbtouse=null, $outputlangs=null, $entconv=1, $searchlabel='')
Return country label, code or id from an id, code or label.
global $mysoc
dol_time_plus_duree($time, $duration_value, $duration_unit, $ruleforendofmonth=0, $tz='')
Add a delay to a date.
Definition date.lib.php:128
print $script_file $mode $langs defaultlang(is_numeric($duration_value) ? " delay=". $duration_value :"").(is_numeric($duration_value2) ? " after cd cd cd description as p label as s rowid as s nom as s email
Sender: Who sends the email ("Sender" has sent emails on behalf of "From").
dol_move($srcfile, $destfile, $newmask='0', $overwriteifexists=1, $testvirus=0, $indexdatabase=1, $moreinfo=array(), $entity=null)
Move a file into another name.
dol_delete_dir_recursive($dir, $count=0, $nophperrors=0, $onlysub=0, &$countdeleted=0, $indexdatabase=1, $nolog=0, $level=0)
Remove a directory $dir and its subdirectories (or only files and subdirectories)
dol_dir_list($utf8_path, $types="all", $recursive=0, $filter="", $excludefilter=null, $sortcriteria="name", $sortorder=SORT_ASC, $mode=0, $nohook=0, $relativename="", $donotfollowsymlinks=0, $nbsecondsold=0)
Scan a directory and return a list of files/directories.
Definition files.lib.php:64
dol_is_dir($folder)
Test if filename is a directory.
deleteFilesIntoDatabaseIndex($dir, $file, $mode='uploaded', $object=null)
Delete files into database index using search criteria.
clean_url($url, $http=1)
Clean an url string.
dol_now($mode='gmt')
Return date for now.
dol_mktime($hour, $minute, $second, $month, $day, $year, $gm='auto', $check=1)
Return a timestamp date built from detailed information (by default a local PHP server timestamp) Rep...
dol_getIdFromCode($db, $key, $tablename, $fieldkey='code', $fieldid='id', $entityfilter=0, $filters='', $useCache=true)
Return an id or code from a code or id.
getLanguageCodeFromCountryCode($countrycode)
Return default language from country code.
setEntity($currentobject)
Set entity id to use when to create an object.
img_picto($titlealt, $picto, $moreatt='', $pictoisfullpath=0, $srconly=0, $notitle=0, $alt='', $morecss='', $marginleftonlyshort=2, $allowothertags=array())
Show picto whatever it's its name (generic function)
dol_format_address($object, $withcountry=0, $sep="\n", $outputlangs=null, $mode=0, $extralangcode='')
Return a formatted address (part address/zip/town/state) according to country rules.
dolBuildUrl($url, $params=[], $addtoken=false)
Return path of url.
dol_string_nohtmltag($stringtoclean, $removelinefeed=1, $pagecodeto='UTF-8', $strip_tags=0, $removedoublespaces=1)
Clean a string from all HTML tags and entities.
price2num($amount, $rounding='', $option=0)
Function that return a number with universal decimal format (decimal separator is '.
img_object($titlealt, $picto, $moreatt='', $pictoisfullpath=0, $srconly=0, $notitle=0, $allowothertags=array())
Show a picto called object_picto (generic function)
dol_strlen($string, $stringencoding='UTF-8')
Make a strlen call.
GETPOSTISARRAY($paramname, $method=0)
Return true if the parameter $paramname is submit from a POST OR GET as an array.
getDolGlobalInt($key, $default=0)
Return a Dolibarr global constant int value.
dol_concatdesc($text1, $text2, $forxml=false, $invert=false)
Concat 2 descriptions with a new line between them (second operand after first one with appropriate n...
dolGetFirstLetters($s, $nbofchar=1)
Return first letters of a strings.
dol_strtoupper($string, $encoding="UTF-8")
Convert a string to upper.
yn($yesno, $format=1, $color=0)
Return yes or no in current language.
complete_substitutions_array(&$substitutionarray, $outputlangs, $object=null, $parameters=null, $callfunc="completesubstitutionarray")
Complete the $substitutionarray with more entries coming from external module that had set the "subst...
dolGetStatus($statusLabel='', $statusLabelShort='', $html='', $statusType='status0', $displayMode=0, $url='', $params=array())
Output the badge of a status.
make_substitutions($text, $substitutionarray, $outputlangs=null, $converttextinhtmlifnecessary=0)
Make substitution into a text string, replacing keys with vals from $substitutionarray (oldval=>newva...
getArrayOfSocialNetworks()
Get array of social network dictionary.
dol_textishtml($msg, $option=0)
Return if a text is a html content.
GETPOST($paramname, $check='alphanohtml', $method=0, $filter=null, $options=null, $noreplace=0)
Return value of a param into GET or POST supervariable.
dol_buildpath($path, $type=0, $returnemptyifnotfound=0)
Return path of url or filesystem.
dol_print_date($time, $format='', $tzoutput='auto', $outputlangs=null, $encodetooutput=false, $decorate=0)
Output date in a string format according to outputlangs (or langs if not defined).
dol_print_error($db=null, $error='', $errors=null)
Displays error message system with all the information to facilitate the diagnosis and the escalation...
dol_trunc($string, $size=40, $trunc='right', $stringencoding='UTF-8', $nodot=0, $display=0)
Truncate a string to a particular length adding '…' if string larger than length.
dol_htmlentitiesbr($stringtoencode, $nl2brmode=0, $pagecodefrom='UTF-8', $removelasteolbr=1)
This function is called to encode a string into a HTML string but differs from htmlentities because a...
isValidEmail($address, $acceptsupervisorkey=0, $acceptuserkey=0)
Return true if email syntax is ok.
getDolGlobalString($key, $default='')
Return a Dolibarr global constant string value.
isModEnabled($module)
Is Dolibarr module enabled.
getWarningDelay($module, $parmlevel1, $parmlevel2='')
Return a warning delay You can use it like this: if (getWarningDelay('module', 'paramlevel1')) It rep...
get_default_tva(Societe $thirdparty_seller, Societe $thirdparty_buyer, $idprod=0, $idprodfournprice=0)
Function that return vat rate of a product line (according to seller, buyer and product vat rate) VAT...
get_exdir($num, $level, $alpha, $withoutslash, $object, $modulepart='')
Return a path to have a the directory according to object where files are stored.
dol_syslog($message, $level=LOG_INFO, $ident=0, $suffixinfilename='', $restricttologhandler='', $logcontext=null)
Write log message into outputs.
dol_getdate($timestamp, $fast=false, $forcetimezone='')
Return an array with locale date info.
dol_escape_htmltag($stringtoescape, $keepb=0, $keepn=0, $noescapetags='', $escapeonlyhtmltags=0, $cleanalsojavascript=0)
Returns text escaped for inclusion in HTML alt or title or value tags, or into values of HTML input f...
div refaddress div address
if(preg_match('/(crypted|dolcrypt):/i', $dolibarr_main_db_pass)||!empty($dolibarr_main_db_encrypted_pass)) $conf db type
'integer', 'integer:ObjectClass:PathToClass[:AddCreateButtonOrNot[:Filter[:Sortfield]]]',...
Definition repair.php:132
getRandomPassword($generic=false, $replaceambiguouschars=null, $length=32)
Return a generated password using default module.
dol_hash($chain, $type='0', $nosalt=0, $mode=0)
Returns a hash (non reversible encryption) of a string.
dolGetLdapPasswordHash($password, $type='md5')
Returns a specific ldap hash of a password.