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';
55 public $element =
'member';
60 public $table_element =
'adherent';
65 public $picto =
'member';
85 public $pass_indatabase;
90 public $pass_indatabase_crypted;
106 public $civility_code;
140 public $socialnetworks;
160 public $phone_mobile;
186 public $default_lang;
235 public $need_subscription;
258 public $first_subscription_date;
263 public $first_subscription_date_start;
268 public $first_subscription_date_end;
273 public $first_subscription_amount;
278 public $last_subscription_date;
283 public $last_subscription_date_start;
288 public $last_subscription_date_end;
293 public $last_subscription_amount;
298 public $subscriptions = array();
310 public $partnerships = 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'))
434 $this->ismultientitymanaged = 1;
435 $this->isextrafieldmanaged = 1;
437 $this->array_options = array();
439 $this->fields[
'ref_ext'][
'visible'] =
getDolGlobalInt(
'MAIN_LIST_SHOW_REF_EXT');
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 =
'')
465 dol_syslog(
'Warning using deprecated Adherent::send_an_email', LOG_WARNING);
467 return $this->
sendEmail($text, $subject, $filename_list, $mimetype_list, $mimefilename_list, $addr_cc, $addr_bcc, $deliveryreceipt, $msgishtml, $errors_to, $moreinheader);
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 =
'')
489 global $conf, $langs;
492 if ($msgishtml == -1) {
499 dol_syslog(
'sendEmail msgishtml='.$msgishtml);
510 $trackid =
'mem'.$this->id;
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()) {
518 $this->error = $langs->trans(
"ErrorFailedToSendMail", $from, (
string) $this->email).
'. '.$mailfile->error;
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 :
'';
546 if ($this->civility_id) {
547 $infos .= $langs->transnoentities(
"UserTitle").
": ".$this->
getCivilityLabel().
"\n";
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";
563 $infos .= $langs->transnoentities(
"Login").
": ".$login.
"\n";
564 $infos .= $langs->transnoentities(
"Password").
": ".$pass.
"\n";
566 $infos .= $langs->transnoentities(
"Birthday").
": ".$birthday.
"\n";
567 $infos .= $langs->transnoentities(
"Photo").
": ".$photo.
"\n";
568 $infos .= $langs->transnoentities(
"Public").
": ".
yn($this->
public);
571 $substitutionarray = array(
572 '__ID__' => $this->
id,
573 '__REF__' => $this->
ref,
574 '__MEMBER_ID__' => $this->
id,
576 '__FIRSTNAME__' => $msgishtml ?
dol_htmlentitiesbr($this->firstname) : ($this->firstname ? $this->firstname :
''),
577 '__LASTNAME__' => $msgishtml ?
dol_htmlentitiesbr($this->lastname) : ($this->lastname ? $this->lastname :
''),
579 '__COMPANY__' => $msgishtml ?
dol_htmlentitiesbr((
string) $this->company) : ($this->company ? $this->company :
''),
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 :
''),
585 '__BIRTH__' => $msgishtml ?
dol_htmlentitiesbr($birthday) : ($birthday ? $birthday :
''),
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 :
''),
615 $morphy = $this->morphy;
619 $labeltoshowm = $langs->trans(
"Moral");
620 $labeltoshowp = $langs->trans(
"Physical");
621 if ($morphy ==
'phy') {
622 $labeltoshow = $labeltoshowp;
623 if ($addbadge == 2) {
629 $s .=
'<span class="member-individual-back paddingleftimp paddingrightimp" title="'.$langs->trans(
"Physical").
'">'.$labeltoshow.
'</span>';
631 if ($morphy ==
'mor') {
632 $labeltoshow = $labeltoshowm;
633 if ($addbadge == 2) {
639 $s .=
'<span class="member-company-back paddingleftimp paddingrightimp" title="'.$langs->trans(
"Moral").
'">'.$labeltoshow.
'</span>';
642 if ($morphy ==
'phy') {
643 $s = $langs->trans(
"Physical");
644 } elseif ($morphy ==
'mor') {
645 $s = $langs->trans(
"Moral");
659 public function create($user, $notrigger = 0)
668 if (isset($this->import_key)) {
669 $this->import_key = trim($this->import_key);
674 $langs->load(
"errors");
675 $this->error = $langs->trans(
"ErrorBadEMail", (
string) $this->email);
682 if (empty($this->login)) {
683 $this->error = $langs->trans(
"ErrorWrongValueForParameterX",
"Login");
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)";
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");
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");
708 dol_syslog(get_class($this).
"::create", LOG_DEBUG);
709 $result = $this->db->query($sql);
711 $id = $this->db->last_insert_id(MAIN_DB_PREFIX.
"adherent");
717 $modfile =
dol_buildpath(
'core/modules/member/'.$modulenum.
'.php', 0);
719 require_once $modfile;
720 $modname = $modulenum;
721 $modCodeMember =
new $modname();
722 '@phan-var-force ModeleNumRefMembers $modCodeMember';
724 $this->
ref = $modCodeMember->getNextValue(
$mysoc, $this);
731 $result = $this->
update($user, 1, 1, 0, 0,
'add');
733 $this->db->rollback();
738 if ($this->user_id) {
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);
746 $this->error =
'Failed to update user to make link with member';
747 $this->db->rollback();
754 $result = $this->call_trigger(
'MEMBER_CREATE', $user);
761 if (count($this->errors)) {
762 dol_syslog(get_class($this).
"::create ".implode(
',', $this->errors), LOG_ERR);
763 $this->db->rollback();
770 $this->error =
'Failed to get last insert id';
771 dol_syslog(get_class($this).
"::create ".$this->error, LOG_ERR);
772 $this->db->rollback();
776 $this->error = $this->db->error();
777 $this->db->rollback();
794 public function update($user, $notrigger = 0, $nosyncuser = 0, $nosyncuserpass = 0, $nosyncthirdparty = 0, $action =
'update')
796 global $langs, $hookmanager;
798 require_once DOL_DOCUMENT_ROOT.
'/core/lib/functions2.lib.php';
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;
808 dol_syslog(get_class($this).
"::update notrigger=".$notrigger.
", nosyncuser=".$nosyncuser.
", nosyncuserpass=".$nosyncuserpass.
" nosyncthirdparty=".$nosyncthirdparty.
", email=".$this->email);
811 $this->lastname = trim($this->lastname) ? trim($this->lastname) : trim($this->lastname);
812 $this->firstname = trim($this->firstname) ? trim($this->firstname) : trim($this->firstname);
814 if (empty($this->civility_code) && !empty($this->civility_id)) {
815 $this->civility_code = $this->civility_id;
817 if (isset($this->gender)) {
818 $this->gender = trim($this->gender);
827 $this->url = $this->url ?
clean_url($this->url, 0) :
'';
832 $langs->load(
"errors");
833 $this->error = $langs->trans(
"ErrorBadEMail", (
string) $this->email);
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");
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"));
849 $sql .=
", fk_soc = ".($this->socid > 0 ? (int) $this->socid :
"null");
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");
872 if ($this->datefin) {
873 $sql .=
", datefin = '".$this->db->idate($this->datefin).
"'";
875 if ($this->datevalid) {
876 $sql .=
", datevalid = '".$this->db->idate($this->datevalid).
"'";
878 $sql .=
", fk_user_mod = ".($user->id > 0 ? $user->id :
'null');
879 $sql .=
" WHERE rowid = ".((int) $this->
id);
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);
889 while ($obj = $this->db->fetch_object($resql2)) {
890 $this->
type = $obj->label;
895 dol_syslog(get_class($this).
"::update update member", LOG_DEBUG);
896 $resql = $this->db->query($sql);
898 unset($this->country_code);
899 unset($this->country);
900 unset($this->state_code);
903 $nbrowsaffected += $this->db->affected_rows($resql);
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) {
920 $result = $this->
setPassword($user, $this->pass, $isencrypted, $notrigger, $nosyncuserpass);
921 if (!$nbrowsaffected) {
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);
934 $this->error = $this->db->error();
935 $this->db->rollback();
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);
944 $this->error = $this->db->error();
945 $this->db->rollback();
951 if (!$error && $nbrowsaffected) {
953 if ($this->user_id > 0 && !$nosyncuser) {
954 require_once DOL_DOCUMENT_ROOT.
'/user/class/user.class.php';
956 dol_syslog(get_class($this).
"::update update linked user");
958 $luser =
new User($this->db);
959 $result = $luser->fetch($this->user_id);
964 $luser->login = $this->login;
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 :
'';
975 $luser->birth = $this->birth;
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;
983 $luser->email = $this->email;
984 $luser->socialnetworks = $this->socialnetworks;
985 $luser->office_phone = $this->phone;
986 $luser->user_mobile = $this->phone_mobile;
988 $luser->lang = $this->default_lang;
990 $luser->fk_member = $this->id;
992 $result = $luser->update($user, 0, 1, 1);
994 $this->error = $luser->error;
995 dol_syslog(get_class($this).
"::update ".$this->error, LOG_ERR);
999 $this->error = $luser->error;
1005 if (!$error && $this->socid > 0 && !$nosyncthirdparty) {
1006 require_once DOL_DOCUMENT_ROOT.
'/societe/class/societe.class.php';
1008 dol_syslog(get_class($this).
"::update update linked thirdparty");
1012 $lthirdparty =
new Societe($this->db);
1013 $result = $lthirdparty->fetch($this->socid);
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;
1025 $lthirdparty->default_lang = $this->default_lang;
1027 $result = $lthirdparty->update($this->socid, $user, 0, 1, 1,
'update');
1030 $this->error = $lthirdparty->error;
1031 $this->errors = $lthirdparty->errors;
1032 dol_syslog(get_class($this).
"::update ".$this->error, LOG_ERR);
1035 } elseif ($result < 0) {
1036 $this->error = $lthirdparty->error;
1042 if (!$error && !$notrigger) {
1044 $result = $this->call_trigger(
'MEMBER_MODIFY', $user);
1052 $this->db->commit();
1053 return $nbrowsaffected;
1055 $this->db->rollback();
1059 $this->db->rollback();
1060 $this->error = $this->db->lasterror();
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";
1085 dol_syslog(get_class($this).
"::update_end_date", LOG_DEBUG);
1086 $resql = $this->db->query($sql);
1094 $dateendmember =
'';
1096 while ($obj = $this->db->fetch_object($resql)) {
1097 $dateendsubscription = $this->db->jdate($obj->datefin);
1099 $dateop = $this->db->jdate($obj->dateop);
1100 $datedeb = $this->db->jdate($obj->datedeb);
1101 $datefin = $dateendsubscription;
1103 if ($dateendsubscription !=
'' && ($dateendmember ==
'' || $dateendsubscription > $dateendmember)) {
1104 $dateendmember = $dateendsubscription;
1109 $sql =
"UPDATE ".MAIN_DB_PREFIX.
"adherent SET";
1110 $sql .=
" datefin=".($dateendmember !=
'' ?
"'".$this->db->idate($dateendmember).
"'" :
"null");
1111 $sql .=
" WHERE rowid = ".((int) $this->
id);
1113 dol_syslog(get_class($this).
"::update_end_date", LOG_DEBUG);
1114 $resql = $this->db->query($sql);
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();
1123 $this->db->rollback();
1127 $this->error = $this->db->lasterror();
1128 $this->db->rollback();
1140 public function delete($user, $notrigger = 0)
1155 $result = $this->call_trigger(
'MEMBER_DELETE', $user);
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);
1168 $this->error .= $this->db->lasterror();
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);
1179 $this->error .= $this->db->lasterror();
1186 require_once DOL_DOCUMENT_ROOT.
'/partnership/class/partnership.class.php';
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);
1192 while ($obj = $this->db->fetch_object($resql)) {
1194 if ($partnership->fetch($obj->rowid) > 0 && $partnership->delete($user) <= 0) {
1196 $this->error .= $partnership->error;
1203 $this->error .= $this->db->lasterror();
1218 $dirofdocuments =
'';
1219 $subdirofdocuments =
get_exdir(0, 0, 0, 1, $this,
'member');
1220 if (!empty($conf->adherent->dir_output) && $subdirofdocuments !==
'') {
1221 $dirofdocuments = $conf->adherent->dir_output.
'/'.$subdirofdocuments;
1223 if (!$error && $dirofdocuments) {
1224 require_once DOL_DOCUMENT_ROOT.
'/core/lib/files.lib.php';
1227 $this->error .= $this->db->lasterror();
1237 $this->error .= $this->db->lasterror();
1248 dol_syslog(get_class($this).
"::delete erreur ".$errorflag.
" ".$this->error, LOG_ERR);
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);
1259 $this->error .= $this->db->lasterror();
1265 $this->db->commit();
1268 if ($dirofdocuments) {
1269 require_once DOL_DOCUMENT_ROOT.
'/core/lib/files.lib.php';
1277 $this->db->rollback();
1294 global $conf, $langs, $hookmanager, $user, $action;
1297 $member_origin =
new Adherent($this->db);
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');
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'
1313 foreach ($listofproperties as $property) {
1314 if (empty($this->$property)) {
1315 $this->$property = $member_origin->$property;
1320 $listofproperties = array(
1321 'note_public',
'note_private'
1323 foreach ($listofproperties as $property) {
1324 $this->$property =
dol_concatdesc($this->$property, $member_origin->$property);
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;
1337 include_once DOL_DOCUMENT_ROOT.
'/categories/class/categorie.class.php';
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);
1344 $result = $this->
update($user, 1, 1, 1, 1,
'merge');
1350 if (!$error && $member_origin->fetch_subscriptions() < 1) {
1355 foreach ($member_origin->subscriptions as $key => $subscription) {
1356 $subscription->fk_adherent = $this->id;
1357 $result = $subscription->update($user);
1367 $parameters = array(
'member_origin' => $member_origin->id,
'member_dest' => $this->id);
1368 $reshook = $hookmanager->executeHooks(
'replaceMember', $parameters, $this, $action);
1377 $this->context = array(
'merge' => 1,
'mergefromid' => $member_origin->id);
1380 $result = $this->call_trigger(
'MEMBER_MODIFY', $user);
1389 if ($member_origin->delete($user) < 1) {
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;
1403 foreach ($dirlist as $filetomove) {
1404 $destfile = $destdir.
'/'.$filetomove[
'relativename'];
1405 $result =
dol_move($filetomove[
'fullname'], $destfile,
'0', 0, 0, 1);
1415 $this->db->commit();
1418 $langs->load(
"errors");
1419 $this->error = $langs->trans(
'ErrorMembersMerge');
1420 $this->db->rollback();
1437 public function setPassword($user, $password =
'', $isencrypted = 0, $notrigger = 0, $nosyncuser = 0)
1439 global $conf, $langs;
1443 dol_syslog(get_class($this).
"::setPassword user=".$user->id.
" password=".preg_replace(
'/./i',
'*', $password).
" isencrypted=".$isencrypted);
1447 require_once DOL_DOCUMENT_ROOT.
'/core/lib/security2.lib.php';
1452 $password_crypted =
dol_hash($password);
1454 $password_indatabase =
'';
1455 if (!$isencrypted) {
1456 $password_indatabase = $password;
1462 $sql =
"UPDATE ".MAIN_DB_PREFIX.
"adherent";
1463 $sql .=
" SET pass_crypted = '".$this->db->escape($password_crypted).
"'";
1465 $sql .=
", pass = null";
1467 $sql .=
", pass = '".$this->db->escape($password_indatabase).
"'";
1469 $sql .=
" WHERE rowid = ".((int) $this->
id);
1472 dol_syslog(get_class($this).
"::setPassword", LOG_DEBUG);
1473 $result = $this->db->query($sql);
1475 $nbaffectedrows = $this->db->affected_rows($result);
1477 if ($nbaffectedrows) {
1478 $this->pass = $password;
1479 $this->pass_indatabase = $password_indatabase;
1480 $this->pass_indatabase_crypted = $password_crypted;
1482 if ($this->user_id && !$nosyncuser) {
1483 require_once DOL_DOCUMENT_ROOT.
'/user/class/user.class.php';
1487 $luser =
new User($this->db);
1488 $result = $luser->fetch($this->user_id);
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);
1498 $this->error = $luser->error;
1503 if (!$error && !$notrigger) {
1505 $result = $this->call_trigger(
'MEMBER_NEW_PASSWORD', $user);
1508 $this->db->rollback();
1514 $this->db->commit();
1517 $this->db->rollback();
1521 $this->db->rollback();
1536 global $conf, $langs;
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);
1545 $this->error = $this->db->error();
1546 $this->db->rollback();
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);
1557 $this->error = $this->db->error();
1558 $this->db->rollback();
1563 $this->db->commit();
1577 global $conf, $langs;
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);
1591 $sql =
"UPDATE ".MAIN_DB_PREFIX.
"adherent SET fk_soc = ".($thirdpartyid > 0 ? (int) $thirdpartyid :
'null');
1592 $sql .=
" WHERE rowid = ".((int) $this->
id);
1594 dol_syslog(get_class($this).
"::setThirdPartyId", LOG_DEBUG);
1595 $resql = $this->db->query($sql);
1597 $this->db->commit();
1600 $this->error = $this->db->error();
1601 $this->db->rollback();
1619 $sql =
"SELECT rowid FROM ".MAIN_DB_PREFIX.
"adherent";
1620 $sql .=
" WHERE login='".$this->db->escape($login).
"'";
1621 $sql .=
" AND entity = ".$conf->entity;
1623 $resql = $this->db->query($sql);
1625 if ($this->db->num_rows($resql)) {
1626 $obj = $this->db->fetch_object($resql);
1627 $this->
fetch($obj->rowid);
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;
1652 $resql = $this->db->query($sql);
1654 if ($this->db->num_rows($resql)) {
1655 $obj = $this->db->fetch_object($resql);
1656 $this->
fetch($obj->rowid);
1674 public function fetch($rowid, $ref =
'', $socid = 0, $ref_ext =
'', $fetch_optionals =
true, $fetch_subscriptions =
true)
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";
1702 $sql .=
" AND d.rowid=".((int) $rowid);
1703 } elseif ($ref || $socid) {
1704 $sql .=
" AND d.entity IN (".getEntity(
'adherent').
")";
1706 $sql .=
" AND d.ref='".$this->db->escape($ref).
"'";
1707 } elseif ($socid > 0) {
1708 $sql .=
" AND d.fk_soc=".((int) $socid);
1710 } elseif ($ref_ext) {
1711 $sql .=
" AND d.ref_ext='".$this->db->escape($ref_ext).
"'";
1714 dol_syslog(get_class($this).
"::fetch", LOG_DEBUG);
1715 $resql = $this->db->query($sql);
1717 if ($this->db->num_rows($resql)) {
1718 $obj = $this->db->fetch_object($resql);
1720 $this->entity = $obj->entity;
1721 $this->
id = $obj->rowid;
1722 $this->
ref = $obj->ref;
1723 $this->ref_ext = $obj->ref_ext;
1725 $this->civility_id = $obj->civility_code;
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) :
'';
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;
1737 $this->
address = $obj->address;
1738 $this->zip = $obj->zip;
1739 $this->town = $obj->town;
1741 $this->pass = $obj->pass;
1742 $this->pass_indatabase = $obj->pass;
1743 $this->pass_indatabase_crypted = $obj->pass_crypted;
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 :
'';
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);
1754 $this->country = $obj->country;
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;
1763 $this->socialnetworks = ($obj->socialnetworks ? (array) json_decode($obj->socialnetworks,
true) : array());
1765 $this->photo = $obj->photo;
1766 $this->statut = $obj->statut;
1767 $this->
status = $obj->statut;
1768 $this->
public = $obj->public;
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);
1779 $this->default_lang = $obj->default_lang;
1781 $this->note_private = $obj->note_private;
1782 $this->note_public = $obj->note_public;
1783 $this->morphy = $obj->morphy;
1785 $this->
typeid = $obj->fk_adherent_type;
1786 $this->
type = $obj->type;
1787 $this->need_subscription = $obj->subscription;
1789 $this->user_id = $obj->user_id;
1790 $this->user_login = $obj->user_login;
1792 $this->model_pdf = $obj->model_pdf;
1796 if ($fetch_optionals) {
1801 if ($fetch_subscriptions) {
1810 $this->error = $this->db->lasterror();
1828 require_once DOL_DOCUMENT_ROOT.
'/adherents/class/subscription.class.php';
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);
1840 $resql = $this->db->query($sql);
1842 $this->subscriptions = array();
1845 while ($obj = $this->db->fetch_object($resql)) {
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;
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;
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);
1870 $this->subscriptions[] = $subscription;
1876 $this->error = $this->db->error().
' sql='.$sql;
1890 require_once DOL_DOCUMENT_ROOT.
'/partnership/class/partnership.class.php';
1893 $this->partnerships[] = array();
1915 public function subscription($date, $amount, $accountid = 0, $operation =
'', $label =
'', $num_chq =
'', $emetteur_nom =
'', $emetteur_banque =
'', $datesubend = 0, $fk_type =
null, $ref_ext =
'')
1919 require_once DOL_DOCUMENT_ROOT.
'/adherents/class/subscription.class.php';
1931 $datefin = $datesubend;
1940 $subscription->fk_adherent = $this->id;
1941 $subscription->dateh = $date;
1942 $subscription->datef = $datefin;
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;
1949 if (empty($subscription->user_creation_id)) {
1950 $subscription->user_creation_id = $user->id;
1953 $rowid = $subscription->create($user);
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;
1969 $this->db->commit();
1972 $this->db->rollback();
1977 $this->db->rollback();
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 =
'')
2004 global $conf, $langs, $user,
$mysoc;
2008 $this->invoice =
null;
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);
2014 if ($option ==
'bankdirect' && $accountid) {
2015 require_once DOL_DOCUMENT_ROOT.
'/compta/bank/class/account.class.php';
2017 $acct =
new Account($this->db);
2018 $result = $acct->fetch($accountid);
2020 $dateop = $paymentdate;
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) {
2027 $sql =
"UPDATE ".MAIN_DB_PREFIX.
"subscription SET fk_bank=".((int) $insertid);
2028 $sql .=
" WHERE rowid=".((int) $subscriptionid);
2030 dol_syslog(
"subscription::subscription", LOG_DEBUG);
2031 $resql = $this->db->query($sql);
2034 $this->error = $this->db->lasterror();
2035 $this->errors[] = $this->error;
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';
2052 $invoice =
new Facture($this->db);
2053 $customer =
new Societe($this->db);
2056 if (!($this->socid > 0)) {
2057 if ($autocreatethirdparty) {
2062 if ($this->morphy ==
'mor') {
2063 $companyname = $this->company;
2064 if (!empty($fullname)) {
2065 $companyalias = $fullname;
2068 $companyname = $fullname;
2069 if (!empty($this->company)) {
2070 $companyalias = $this->company;
2074 $result = $customer->create_from_member($this, (
string) $companyname, $companyalias);
2076 $this->error = $customer->error;
2077 $this->errors = $customer->errors;
2080 $this->fk_soc = $result;
2081 $this->socid = $result;
2084 $langs->load(
"errors");
2085 $this->error = $langs->trans(
"ErrorMemberNotLinkedToAThirpartyLinkOrCreateFirst");
2086 $this->errors[] = $this->error;
2092 $result = $customer->fetch($this->socid);
2094 $this->error = $customer->error;
2095 $this->errors = $customer->errors;
2103 $invoice->cond_reglement_id = $customer->cond_reglement_id;
2104 if (empty($invoice->cond_reglement_id)) {
2106 $invoice->cond_reglement_id = $paymenttermstatic->getDefaultId();
2107 if (empty($invoice->cond_reglement_id)) {
2109 $this->error =
'ErrorNoPaymentTermRECEPFound';
2110 $this->errors[] = $this->error;
2113 $invoice->socid = $this->socid;
2115 if (!empty($customer->fk_account)) {
2116 $invoice->fk_account = $customer->fk_account;
2122 if (!empty($customer->mode_reglement_id)) {
2123 $invoice->mode_reglement_id = $customer->mode_reglement_id;
2129 $invoice->linked_objects[
'subscription'] = $subscriptionid;
2131 $invoice->linked_objects = array_merge($invoice->linked_objects,
GETPOST(
'other_linked_objects',
'array:int'));
2134 $result = $invoice->create($user);
2139 $this->invoice = $invoice;
2145 $idprodsubscription = 0;
2151 if (
getDolGlobalString(
'ADHERENT_VAT_FOR_SUBSCRIPTIONS') ==
'defaultforfoundationcountry') {
2156 $result = $invoice->addline($label, 0, 1, $vattouse, 0, 0, $idprodsubscription, 0, $datesubscription,
'', 0, 0, 0,
'TTC', $amount, 1);
2165 $result = $invoice->validate($user);
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';
2183 $amounts[$invoice->id] = (float)
price2num($amount);
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;
2196 $paiement_id = $paiement->create($user);
2197 if (!($paiement_id > 0)) {
2204 $bank_line_id = $paiement->addPaymentToBank($user,
'payment',
'(SubscriptionPayment)', $accountid, $emetteur_nom, $emetteur_banque);
2205 if (!($bank_line_id > 0)) {
2211 if (!$error && !empty($bank_line_id)) {
2213 $sql =
'UPDATE '.MAIN_DB_PREFIX.
'subscription SET fk_bank='.((int) $bank_line_id);
2214 $sql .=
' WHERE rowid='.((int) $subscriptionid);
2216 $result = $this->db->query($sql);
2224 $invoice->setPaid($user);
2230 $outputlangs = $langs;
2232 $lang_id =
GETPOST(
'lang_id');
2233 if (
getDolGlobalInt(
'MAIN_MULTILANGS') && empty($newlang) && !empty($lang_id)) {
2234 $newlang = $lang_id;
2237 $newlang = $customer->default_lang;
2239 if (!empty($newlang)) {
2240 $outputlangs =
new Translate(
"", $conf);
2241 $outputlangs->setDefaultLang($newlang);
2246 $invoice->fetch($invoice->id);
2247 $invoice->generateDocument($invoice->model_pdf, $outputlangs);
2267 global $langs, $conf;
2273 if ($this->statut == self::STATUS_VALIDATED) {
2274 dol_syslog(get_class($this).
"::validate statut of member does not allow this", LOG_WARNING);
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);
2286 dol_syslog(get_class($this).
"::validate", LOG_DEBUG);
2287 $result = $this->db->query($sql);
2292 $result = $this->call_trigger(
'MEMBER_VALIDATE', $user);
2295 $this->db->rollback();
2300 $this->datevalid = $now;
2302 $this->db->commit();
2305 $this->error = $this->db->error();
2306 $this->db->rollback();
2320 global $langs, $conf;
2325 if ($this->statut == self::STATUS_RESILIATED) {
2326 dol_syslog(get_class($this).
"::resiliate statut of member does not allow this", LOG_WARNING);
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);
2337 $result = $this->db->query($sql);
2342 $result = $this->call_trigger(
'MEMBER_RESILIATE', $user);
2345 $this->db->rollback();
2350 $this->db->commit();
2353 $this->error = $this->db->error();
2354 $this->db->rollback();
2373 if ($this->statut == self::STATUS_EXCLUDED) {
2374 dol_syslog(get_class($this).
"::resiliate statut of member does not allow this", LOG_WARNING);
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);
2385 $result = $this->db->query($sql);
2390 $result = $this->call_trigger(
'MEMBER_EXCLUDE', $user);
2393 $this->db->rollback();
2398 $this->db->commit();
2401 $this->error = $this->db->error();
2402 $this->db->rollback();
2418 include_once DOL_DOCUMENT_ROOT.
'/mailmanspip/class/mailmanspip.class.php';
2425 $result = $mailmanspip->add_to_mailman($this);
2428 if (!empty($mailmanspip->error)) {
2429 $this->errors[] = $mailmanspip->error;
2433 foreach ($mailmanspip->mladded_ko as $tmplist => $tmpemail) {
2434 $langs->load(
"errors");
2435 $this->errors[] = $langs->trans(
"ErrorFailedToAddToMailmanList", $tmpemail, $tmplist);
2437 foreach ($mailmanspip->mladded_ok as $tmplist => $tmpemail) {
2438 $langs->load(
"mailmanspip");
2439 $this->mesgs[] = $langs->trans(
"SuccessToAddToMailmanList", $tmpemail, $tmplist);
2445 $result = $mailmanspip->add_to_spip($this);
2447 $this->errors[] = $mailmanspip->error;
2468 global $conf, $langs;
2470 include_once DOL_DOCUMENT_ROOT.
'/mailmanspip/class/mailmanspip.class.php';
2477 $result = $mailmanspip->del_to_mailman($this);
2479 if (!empty($mailmanspip->error)) {
2480 $this->errors[] = $mailmanspip->error;
2485 foreach ($mailmanspip->mlremoved_ko as $tmplist => $tmpemail) {
2486 $langs->load(
"errors");
2487 $this->errors[] = $langs->trans(
"ErrorFailedToRemoveToMailmanList", $tmpemail, $tmplist);
2489 foreach ($mailmanspip->mlremoved_ok as $tmplist => $tmpemail) {
2490 $langs->load(
"mailmanspip");
2491 $this->mesgs[] = $langs->trans(
"SuccessToRemoveToMailmanList", $tmpemail, $tmplist);
2496 $result = $mailmanspip->del_to_spip($this);
2498 $this->errors[] = $mailmanspip->error;
2519 $langs->load(
"dict");
2521 $code = (empty($this->civility_id) ?
'' : $this->civility_id);
2525 return $langs->getLabelFromKey($this->db,
"Civility".$code,
"c_civility",
"code",
"label", $code);
2538 $langs->loadLangs([
'members',
'companies']);
2539 $nofetch = !empty($params[
'nofetch']);
2544 $langs->load(
"users");
2545 return [
'optimize' => $langs->trans(
"ShowUser")];
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);
2551 $datas[
'photo'] = $photo;
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'] .=
' ' . $this->
getmorphylib(
'', 1);
2559 if (!empty($this->
ref)) {
2560 $datas[
'ref'] =
'<br><b>'.$langs->trans(
'Ref').
':</b> '.$this->ref;
2562 if (!empty($this->login)) {
2563 $datas[
'login'] =
'<br><b>'.$langs->trans(
'Login').
':</b> '.$this->login;
2565 if (!empty($this->firstname) || !empty($this->lastname)) {
2566 $datas[
'name'] =
'<br><b>'.$langs->trans(
'Name').
':</b> '.$this->
getFullName($langs);
2568 if (!empty($this->company)) {
2569 $datas[
'company'] =
'<br><b>'.$langs->trans(
'Company').
':</b> '.$this->company;
2571 if (!empty($this->email)) {
2572 $datas[
'email'] =
'<br><b>'.$langs->trans(
"EMail").
':</b> '.$this->email;
2574 $datas[
'address'] =
'<br><b>'.$langs->trans(
"Address").
':</b> '.
dol_format_address($this, 1,
' ', $langs);
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);
2581 $datas[
'divclose'] =
'</div>';
2599 public function getNomUrl($withpictoimg = 0, $maxlen = 0, $option =
'card', $mode =
'', $morecss =
'', $save_lastsearch_value = -1, $notooltip = 0, $addlinktonotes = 0)
2601 global $conf, $langs, $hookmanager;
2610 $classfortooltip =
'classfortooltip';
2614 'objecttype' => $this->element,
2615 'option' => $option,
2619 $classfortooltip =
'classforajaxtooltip';
2620 $dataparams =
' data-params="'.dol_escape_htmltag(json_encode($params)).
'"';
2626 $baseurl = DOL_URL_ROOT .
'/adherents/card.php';
2627 if ($option ==
'subscription') {
2628 $baseurl = DOL_URL_ROOT .
'/adherents/subscription.php';
2630 $query = [
'rowid' => $this->id];
2632 if ($option !=
'nolink') {
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;
2638 if ($add_save_lastsearch_values) {
2639 $query = array_merge($query, [
'save_lastsearch_values' => 1]);
2644 $linkstart .=
'<a href="'.$url.
'"';
2646 if (empty($notooltip)) {
2648 $langs->load(
"users");
2649 $label = $langs->trans(
"ShowUser");
2650 $linkclose .=
' alt="'.dolPrintHTMLForAttribute($label).
'"';
2652 $linkclose .= ($label ?
' title="'.dolPrintHTMLForAttribute($label).
'"' :
' title="tocomplete"');
2653 $linkclose .= $dataparams.
' class="'.$classfortooltip.($morecss ?
' '.$morecss :
'').
'"';
2656 $linkstart .= $linkclose.
'>';
2659 $result .= $linkstart;
2661 if ($withpictoimg) {
2662 if (abs($withpictoimg) == 1 || abs($withpictoimg) == 4) {
2663 $morecss .=
' paddingrightonly';
2666 if ($withpictoimg > 0) {
2667 $picto =
'<span class="nopadding'.($morecss ?
' userimg'.$morecss :
'').
'">'.
img_object(
'',
'user',
' '.($notooltip ?
'' : $dataparams), 0, 0, $notooltip ? 0 : 1).
'</span>';
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>';
2676 if (($withpictoimg > -2 && $withpictoimg != 2) || $withpictoimg == -4) {
2678 $result .=
'<span class="nopadding valignmiddle'.((!isset($this->
status) || $this->status) ?
'' :
' strikefordisabled').
2679 ($morecss ?
' usertext'.$morecss :
'').
'">';
2681 if ($mode ==
'login') {
2682 $result .=
dol_trunc(isset($this->login) ? $this->login :
'', $maxlen);
2683 } elseif ($mode ==
'ref') {
2684 $result .= $this->ref;
2686 $result .= $this->
getFullName($langs, 0, ($mode ==
'firstname' ? 2 : ($mode ==
'lastname' ? 4 : -1)), $maxlen);
2689 $result .=
'</span>';
2693 $result .= $linkend;
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).
'">';
2702 $result .=
'</span>';
2706 $hookmanager->initHooks(array($this->element .
'dao'));
2707 $parameters = array(
'id' => $this->
id,
'getnomurl' => &$result);
2708 $reshook = $hookmanager->executeHooks(
'getNomUrl', $parameters, $this, $action);
2710 $result = $hookmanager->resPrint;
2712 $result .= $hookmanager->resPrint;
2725 return $this->
LibStatut($this->
status, $this->need_subscription, $this->datefin, $mode);
2738 public function LibStatut($status, $need_subscription, $date_end_subscription, $mode = 0)
2742 $langs->load(
"members");
2746 $labelStatusShort =
'';
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()) {
2762 $statusType =
'status2';
2763 $labelStatus = $langs->trans(
"Validated").
' - '.$langs->trans(
"MemberStatusActiveLate");
2764 $labelStatusShort = $langs->trans(
"MemberStatusActiveLateShort");
2766 $statusType =
'status4';
2767 $labelStatus = $langs->trans(
"Validated").
' - '.$langs->trans(
"MemberStatusPaid");
2768 $labelStatusShort = $langs->trans(
"MemberStatusPaidShort");
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");
2780 return dolGetStatus($labelStatus, $labelStatusShort,
'', $statusType, $mode);
2793 $this->nb = array();
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').
")";
2800 $resql = $this->db->query($sql);
2802 while ($obj = $this->db->fetch_object($resql)) {
2803 $this->nb[
"members"] = $obj->nb;
2805 $this->db->free($resql);
2809 $this->error = $this->db->error();
2825 global $conf, $langs;
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').
")";
2846 $resql = $this->db->query($sql);
2848 $langs->load(
"members");
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");
2868 $response->warning_delay = $warning_delay;
2869 $response->label = $label;
2870 $response->labelShort = $labelShort;
2871 $response->url = $url;
2874 $adherentstatic =
new Adherent($this->db);
2876 while ($obj = $this->db->fetch_object($resql)) {
2877 $response->nbtodo++;
2879 $adherentstatic->datefin = $this->db->jdate($obj->datefin);
2880 $adherentstatic->statut = $obj->status;
2881 $adherentstatic->status = $obj->status;
2883 if ($adherentstatic->hasDelay()) {
2884 $response->nbtodolate++;
2891 $this->error = $this->db->error();
2908 public function generateDocument($modele, $outputlangs, $hidedetails = 0, $hidedesc = 0, $hideref = 0, $moreparams =
null)
2910 global $conf, $langs;
2912 $langs->load(
"orders");
2915 $modele =
'standard';
2917 if ($this->model_pdf) {
2918 $modele = $this->model_pdf;
2924 $modelpath =
"core/modules/member/doc/";
2926 return $this->
commonGenerateDocument($modelpath, $modele, $outputlangs, $hidedetails, $hidedesc, $hideref, $moreparams);
2939 global $user, $langs;
2944 $this->
ref =
'ABC001';
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',
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;
2979 $this->datefin = $now;
2980 $this->datevalid = $now;
2981 $this->default_lang =
'';
2984 $this->
type =
'Type adherent';
2985 $this->need_subscription = 0;
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;
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;
3039 global $conf, $langs;
3043 $keymodified =
false;
3051 if ($this->morphy ==
'mor' && (empty($this->fullname) || $this->fullname == $this->company)) {
3052 $this->fullname = $this->company;
3053 $this->lastname = $this->company;
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'
3066 foreach ($ldapkey as $constname => $varname) {
3072 if (!empty($this->oldcopy) && $this->$varname != $this->oldcopy->$varname) {
3073 $keymodified =
true;
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']];
3128 if ($this->datefin &&
getDolGlobalString(
'LDAP_FIELD_MEMBER_END_LASTSUBSCRIPTION')) {
3133 if (!empty($this->pass)) {
3146 if ($this->pass_indatabase_crypted &&
getDolGlobalString(
'LDAP_MEMBER_FIELD_PASSWORD_CRYPTED')) {
3152 } elseif (!empty($this->pass_indatabase)) {
3164 if ($this->first_subscription_date &&
getDolGlobalString(
'LDAP_FIELD_MEMBER_FIRSTSUBSCRIPTION_DATE')) {
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;
3170 if ($this->last_subscription_date &&
getDolGlobalString(
'LDAP_FIELD_MEMBER_LASTSUBSCRIPTION_DATE')) {
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;
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);
3197 dol_syslog(get_class($this).
"::info", LOG_DEBUG);
3198 $result = $this->db->query($sql);
3200 if ($this->db->num_rows($result)) {
3201 $obj = $this->db->fetch_object($result);
3203 $this->
id = $obj->rowid;
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);
3213 $this->db->free($result);
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)";
3231 $resql = $this->db->query($sql);
3233 $obj = $this->db->fetch_object($resql);
3234 $nb = (int) $obj->nb;
3236 $this->db->free($resql);
3239 $this->error = $this->db->error();
3256 require_once DOL_DOCUMENT_ROOT.
'/categories/class/categorie.class.php';
3257 return parent::setCategoriesCommon($categories, Categorie::TYPE_MEMBER);
3270 $tables = array(
'adherent');
3285 if ($this->
status != self::STATUS_VALIDATED) {
3288 if (!$this->datefin) {
3294 return $this->datefin < ($now -
getWarningDelay(
'member',
'subscription'));
3308 global $conf, $langs,
$mysoc, $user;
3314 $blockingerrormsg =
'';
3317 $langs->load(
"agenda");
3318 $this->output = $langs->trans(
'ModuleNotEnabled', $langs->transnoentitiesnoconv(
"Adherent"));
3322 $langs->load(
"agenda");
3323 $this->output = $langs->trans(
'EventRemindersByEmailNotEnabled', $langs->transnoentitiesnoconv(
"Adherent"));
3331 $listofmembersok = array();
3332 $listofmembersko = array();
3334 $arraydaysbeforeend = explode(
';', $daysbeforeendlist);
3335 foreach ($arraydaysbeforeend as $daysbeforeend) {
3336 dol_syslog(__METHOD__.
' - Process delta = '.$daysbeforeend, LOG_DEBUG);
3338 if (!is_numeric($daysbeforeend)) {
3339 $blockingerrormsg =
"Value for delta is not a numeric value";
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');
3348 $sql =
'SELECT rowid FROM '.MAIN_DB_PREFIX.
'adherent';
3349 $sql .=
" WHERE entity = ".((int) $conf->entity);
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);
3358 $resql = $this->db->query($sql);
3360 $num_rows = $this->db->num_rows($resql);
3362 include_once DOL_DOCUMENT_ROOT.
'/core/class/html.formmail.class.php';
3363 $formmail =
new FormMail($this->db);
3366 while ($i < $num_rows) {
3367 $obj = $this->db->fetch_object($resql);
3371 $adherent =
new Adherent($this->db);
3372 $adherent->fetch($obj->rowid,
'', 0,
'',
true,
true);
3374 if (empty($adherent->email)) {
3376 $listofmembersko[$adherent->id] = $adherent->id;
3378 $thirdpartyres = $adherent->fetch_thirdparty();
3379 if ($thirdpartyres === -1) {
3380 $languagecodeformember =
$mysoc->default_lang;
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);
3386 if (!empty($adherent->default_lang)) {
3388 $languagecodeformember = $adherent->default_lang;
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);
3397 $arraydefaultmessage =
null;
3400 if (!empty($labeltouse)) {
3401 $arraydefaultmessage = $formmail->getEMailTemplate($this->db,
'member', $user, $outputlangs, 0, 1, $labeltouse);
3404 if (!empty($labeltouse) && is_object($arraydefaultmessage) && $arraydefaultmessage->id > 0) {
3405 $substitutionarray = getCommonSubstitutionArray($outputlangs, 0,
null, $adherent);
3409 $subject =
make_substitutions($arraydefaultmessage->topic, $substitutionarray, $outputlangs);
3410 $msg =
make_substitutions($arraydefaultmessage->content, $substitutionarray, $outputlangs);
3412 $to = $adherent->email;
3415 $trackid =
'mem'.$adherent->id;
3416 $moreinheader =
'X-Dolibarr-Info: sendReminderForExpiredSubscription'.
"\r\n";
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();
3423 $this->error .= $cmail->error.
' ';
3424 if (!is_null($cmail->errors)) {
3425 $this->errors += $cmail->errors;
3428 $listofmembersko[$adherent->id] = $adherent->id;
3431 $listofmembersok[$adherent->id] = $adherent->id;
3437 $actioncode =
'EMAIL';
3438 $extraparams = array();
3448 $actionmsg =
dol_concatdesc($actionmsg, $langs->transnoentities(
'MailTopic').
": ".$subject);
3449 $actionmsg =
dol_concatdesc($actionmsg, $langs->transnoentities(
'TextUsedInTheMessageBody').
":");
3453 require_once DOL_DOCUMENT_ROOT.
'/comm/action/class/actioncomm.class.php';
3458 $actioncomm->type_code =
'AC_OTH_AUTO';
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;
3466 $actioncomm->socid = (is_object($adherent->thirdparty) ? $adherent->thirdparty->id : 0);
3467 $actioncomm->contact_id = 0;
3468 $actioncomm->authorid = $user->id;
3469 $actioncomm->userownerid = $user->id;
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 =
'';
3480 $actioncomm->fk_element = $adherent->id;
3481 $actioncomm->elementid = $adherent->id;
3482 $actioncomm->elementtype = $adherent->element;
3484 $actioncomm->extraparams = $extraparams;
3486 $actioncomm->create($user);
3492 $this->error .=
"Can't find email template with label=".$labeltouse.
", to use for the reminding email ";
3495 $listofmembersko[$adherent->id] = $adherent->id;
3504 $this->error = $this->db->lasterror();
3509 if ($blockingerrormsg) {
3510 $this->error = $blockingerrormsg;
3513 $this->output =
'Found '.($nbok + $nbko).
' members to send reminder to.';
3514 $this->output .=
' Send email successfully to '.$nbok.
' members';
3517 foreach ($listofmembersok as $idmember) {
3519 $listofids .=
', ...';
3522 if (empty($listofids)) {
3527 $listofids .= $idmember;
3533 $this->output .= ($listofids ?
' ids='.$listofids :
'');
3536 $this->output .=
' - Canceled for '.$nbko.
' member (no email or email sending error)';
3539 foreach ($listofmembersko as $idmember) {
3541 $listofids .=
', ...';
3544 if (empty($listofids)) {
3549 $listofids .= $idmember;
3555 $this->output .= ($listofids ?
' ids='.$listofids :
'');
3571 $selected = (empty($arraydata[
'selected']) ? 0 : $arraydata[
'selected']);
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);
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"' :
'').
'>';
3587 $return .=
'<br><span class="info-box-label paddingright">'.$this->getmorphylib(
'', 2).
'</span>';
3588 $return .=
'<span class="info-box-label opacitymedium">'.$this->type.
'</span>';
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>';
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 mailman and spip.
Class to manage payments of customer invoices.
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...
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.
dol_time_plus_duree($time, $duration_value, $duration_unit, $ruleforendofmonth=0, $tz='')
Add a delay to a date.
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.
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]]]',...
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.