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();
360 'rowid' => array(
'type' =>
'integer',
'label' =>
'TechnicalID',
'enabled' => 1,
'visible' => -1,
'notnull' => 1,
'position' => 10),
361 'ref' => array(
'type' =>
'varchar(30)',
'label' =>
'Ref',
'default' =>
'1',
'enabled' => 1,
'visible' => 1,
'notnull' => 1,
'position' => 12,
'index' => 1),
362 'entity' => array(
'type' =>
'integer',
'label' =>
'Entity',
'default' =>
'1',
'enabled' => 1,
'visible' => 3,
'notnull' => 1,
'position' => 15,
'index' => 1),
363 'ref_ext' => array(
'type' =>
'varchar(128)',
'label' =>
'RefExt',
'enabled' => 1,
'visible' => 0,
'position' => 20),
364 'civility' => array(
'type' =>
'varchar(6)',
'label' =>
'Civility',
'enabled' => 1,
'visible' => -1,
'position' => 25),
365 'lastname' => array(
'type' =>
'varchar(50)',
'label' =>
'Lastname',
'enabled' => 1,
'visible' => 1,
'position' => 30,
'showoncombobox' => 1),
366 'firstname' => array(
'type' =>
'varchar(50)',
'label' =>
'Firstname',
'enabled' => 1,
'visible' => 1,
'position' => 35,
'showoncombobox' => 1),
367 'login' => array(
'type' =>
'varchar(50)',
'label' =>
'Login',
'enabled' => 1,
'visible' => 1,
'position' => 40),
368 'pass' => array(
'type' =>
'varchar(50)',
'label' =>
'Pass',
'enabled' => 1,
'visible' => 3,
'position' => 45),
369 'pass_crypted' => array(
'type' =>
'varchar(128)',
'label' =>
'Pass crypted',
'enabled' => 1,
'visible' => 3,
'position' => 50),
370 'morphy' => array(
'type' =>
'varchar(3)',
'label' =>
'MemberNature',
'enabled' => 1,
'visible' => 1,
'notnull' => 1,
'position' => 55),
371 'fk_adherent_type' => array(
'type' =>
'integer',
'label' =>
'MemberType',
'enabled' => 1,
'visible' => 1,
'notnull' => 1,
'position' => 60),
372 'societe' => array(
'type' =>
'varchar(128)',
'label' =>
'Societe',
'enabled' => 1,
'visible' => 1,
'position' => 65,
'showoncombobox' => 2),
373 'fk_soc' => array(
'type' =>
'integer:Societe:societe/class/societe.class.php',
'label' =>
'ThirdParty',
'enabled' => 1,
'visible' => 1,
'position' => 70),
374 'address' => array(
'type' =>
'text',
'label' =>
'Address',
'enabled' => 1,
'visible' => -1,
'position' => 75),
375 'zip' => array(
'type' =>
'varchar(10)',
'label' =>
'Zip',
'enabled' => 1,
'visible' => -1,
'position' => 80),
376 'town' => array(
'type' =>
'varchar(50)',
'label' =>
'Town',
'enabled' => 1,
'visible' => -1,
'position' => 85),
377 'state_id' => array(
'type' =>
'integer',
'label' =>
'State',
'enabled' => 1,
'visible' => -1,
'position' => 90),
378 'country' => array(
'type' =>
'integer:Ccountry:core/class/ccountry.class.php',
'label' =>
'Country',
'enabled' => 1,
'visible' => 1,
'position' => 95),
379 'phone' => array(
'type' =>
'varchar(30)',
'label' =>
'Phone',
'enabled' => 1,
'visible' => -1,
'position' => 115),
380 'phone_perso' => array(
'type' =>
'varchar(30)',
'label' =>
'Phone perso',
'enabled' => 1,
'visible' => -1,
'position' => 120),
381 'phone_mobile' => array(
'type' =>
'varchar(30)',
'label' =>
'Phone mobile',
'enabled' => 1,
'visible' => -1,
'position' => 125),
382 'email' => array(
'type' =>
'varchar(255)',
'label' =>
'Email',
'enabled' => 1,
'visible' => 1,
'position' => 126),
383 'url' => array(
'type' =>
'varchar(255)',
'label' =>
'Url',
'enabled' => 1,
'visible' => -1,
'position' => 127),
384 'socialnetworks' => array(
'type' =>
'text',
'label' =>
'Socialnetworks',
'enabled' => 1,
'visible' => 3,
'position' => 128),
385 'birth' => array(
'type' =>
'date',
'label' =>
'DateOfBirth',
'enabled' => 1,
'visible' => -1,
'position' => 130),
386 'gender' => array(
'type' =>
'varchar(10)',
'label' =>
'Gender',
'enabled' => 1,
'visible' => -1,
'position' => 132),
387 'photo' => array(
'type' =>
'varchar(255)',
'label' =>
'Photo',
'enabled' => 1,
'visible' => -1,
'position' => 135),
388 'public' => array(
'type' =>
'smallint(6)',
'label' =>
'Public',
'enabled' => 1,
'visible' => 3,
'notnull' => 1,
'position' => 145),
389 'datefin' => array(
'type' =>
'datetime',
'label' =>
'DateEnd',
'enabled' => 1,
'visible' => 1,
'position' => 150),
390 'default_lang' => array(
'type' =>
'varchar(6)',
'label' =>
'Default lang',
'enabled' => 1,
'visible' => -1,
'position' => 153),
391 'note_public' => array(
'type' =>
'text',
'label' =>
'NotePublic',
'enabled' => 1,
'visible' => 0,
'position' => 155),
392 'note_private' => array(
'type' =>
'text',
'label' =>
'NotePrivate',
'enabled' => 1,
'visible' => 0,
'position' => 160),
393 'datevalid' => array(
'type' =>
'datetime',
'label' =>
'DateValidation',
'enabled' => 1,
'visible' => -1,
'position' => 165),
394 'datec' => array(
'type' =>
'datetime',
'label' =>
'DateCreation',
'enabled' => 1,
'visible' => -1,
'position' => 170),
395 'tms' => array(
'type' =>
'timestamp',
'label' =>
'DateModification',
'enabled' => 1,
'visible' => -1,
'notnull' => 1,
'position' => 175),
396 'fk_user_author' => array(
'type' =>
'integer:User:user/class/user.class.php',
'label' =>
'UserCreation',
'enabled' => 1,
'visible' => 3,
'position' => 180),
397 'fk_user_mod' => array(
'type' =>
'integer:User:user/class/user.class.php',
'label' =>
'UserModification',
'enabled' => 1,
'visible' => 3,
'position' => 185),
398 'fk_user_valid' => array(
'type' =>
'integer:User:user/class/user.class.php',
'label' =>
'UserValidation',
'enabled' => 1,
'visible' => 3,
'position' => 190),
399 'canvas' => array(
'type' =>
'varchar(32)',
'label' =>
'Canvas',
'enabled' => 1,
'visible' => 0,
'position' => 195),
400 'model_pdf' => array(
'type' =>
'varchar(255)',
'label' =>
'Model pdf',
'enabled' => 1,
'visible' => 0,
'position' => 800),
401 'import_key' => array(
'type' =>
'varchar(14)',
'label' =>
'ImportId',
'enabled' => 1,
'visible' => -2,
'position' => 805),
402 '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'))
435 $this->ismultientitymanaged = 1;
436 $this->isextrafieldmanaged = 1;
438 $this->array_options = array();
440 $this->fields[
'ref_ext'][
'visible'] =
getDolGlobalInt(
'MAIN_LIST_SHOW_REF_EXT');
463 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 =
'')
466 dol_syslog(
'Warning using deprecated Adherent::send_an_email', LOG_WARNING);
468 return $this->
sendEmail($text, $subject, $filename_list, $mimetype_list, $mimefilename_list, $addr_cc, $addr_bcc, $deliveryreceipt, $msgishtml, $errors_to, $moreinheader);
488 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 =
'')
490 global
$conf, $langs;
493 if ($msgishtml == -1) {
500 dol_syslog(
'sendEmail msgishtml='.$msgishtml);
511 $trackid =
'mem'.$this->id;
514 include_once DOL_DOCUMENT_ROOT.
'/core/class/CMailFile.class.php';
515 $mailfile =
new CMailFile($subjecttosend, (
string) $this->
email, $from, $texttosend, $filename_list, $mimetype_list, $mimefilename_list, $addr_cc, $addr_bcc, $deliveryreceipt, $msgishtml,
'',
'', $trackid, $moreinheader);
516 if ($mailfile->sendfile()) {
519 $this->error = $langs->trans(
"ErrorFailedToSendMail", $from, (
string) $this->email).
'. '.$mailfile->error;
536 $photo = isset($this->photo) ? $this->photo :
'';
537 $login = isset($this->login) ? $this->login :
'';
538 $type = isset($this->
type) ? $this->
type :
'';
539 $pass = isset($this->pass) ? $this->pass :
'';
547 if ($this->civility_id) {
548 $infos .= $langs->transnoentities(
"UserTitle").
": ".$this->
getCivilityLabel().
"\n";
550 $infos .= $langs->transnoentities(
"Id").
": ".$this->
id.
"\n";
551 $infos .= $langs->transnoentities(
"Ref").
": ".$this->
ref.
"\n";
552 $infos .= $langs->transnoentities(
"Lastname").
": ".$this->lastname.
"\n";
553 $infos .= $langs->transnoentities(
"Firstname").
": ".$this->firstname.
"\n";
554 $infos .= $langs->transnoentities(
"Company").
": ".$this->company.
"\n";
555 $infos .= $langs->transnoentities(
"Address").
": ".$this->
address.
"\n";
556 $infos .= $langs->transnoentities(
"Zip").
": ".$this->zip.
"\n";
557 $infos .= $langs->transnoentities(
"Town").
": ".$this->town.
"\n";
558 $infos .= $langs->transnoentities(
"Country").
": ".$this->country.
"\n";
559 $infos .= $langs->transnoentities(
"EMail").
": ".$this->
email.
"\n";
560 $infos .= $langs->transnoentities(
"PhonePro").
": ".$this->phone.
"\n";
561 $infos .= $langs->transnoentities(
"PhonePerso").
": ".$this->phone_perso.
"\n";
562 $infos .= $langs->transnoentities(
"PhoneMobile").
": ".$this->phone_mobile.
"\n";
564 $infos .= $langs->transnoentities(
"Login").
": ".$login.
"\n";
565 $infos .= $langs->transnoentities(
"Password").
": ".$pass.
"\n";
567 $infos .= $langs->transnoentities(
"Birthday").
": ".$birthday.
"\n";
568 $infos .= $langs->transnoentities(
"Photo").
": ".$photo.
"\n";
569 $infos .= $langs->transnoentities(
"Public").
": ".
yn($this->
public);
572 $substitutionarray = array(
573 '__ID__' => $this->
id,
574 '__REF__' => $this->
ref,
575 '__MEMBER_ID__' => $this->
id,
577 '__FIRSTNAME__' => $msgishtml ?
dol_htmlentitiesbr($this->firstname) : ($this->firstname ? $this->firstname :
''),
578 '__LASTNAME__' => $msgishtml ?
dol_htmlentitiesbr($this->lastname) : ($this->lastname ? $this->lastname :
''),
580 '__COMPANY__' => $msgishtml ?
dol_htmlentitiesbr((
string) $this->company) : ($this->company ? $this->company :
''),
582 '__ZIP__' => $msgishtml ?
dol_htmlentitiesbr((
string) $this->zip) : ($this->zip ? $this->zip :
''),
583 '__TOWN__' => $msgishtml ?
dol_htmlentitiesbr((
string) $this->town) : ($this->town ? $this->town :
''),
584 '__COUNTRY__' => $msgishtml ?
dol_htmlentitiesbr($this->country) : ($this->country ? $this->country :
''),
586 '__BIRTH__' => $msgishtml ?
dol_htmlentitiesbr($birthday) : ($birthday ? $birthday :
''),
590 '__PHONE__' => $msgishtml ?
dol_htmlentitiesbr($this->phone) : ($this->phone ? $this->phone :
''),
591 '__PHONEPRO__' => $msgishtml ?
dol_htmlentitiesbr($this->phone_perso) : ($this->phone_perso ? $this->phone_perso :
''),
592 '__PHONEMOBILE__' => $msgishtml ?
dol_htmlentitiesbr($this->phone_mobile) : ($this->phone_mobile ? $this->phone_mobile :
''),
616 $morphy = $this->morphy;
620 $labeltoshowm = $langs->trans(
"Moral");
621 $labeltoshowp = $langs->trans(
"Physical");
622 if ($morphy ==
'phy') {
623 $labeltoshow = $labeltoshowp;
624 if ($addbadge == 2) {
630 $s .=
'<span class="member-individual-back paddingleftimp paddingrightimp" title="'.$langs->trans(
"Physical").
'">'.$labeltoshow.
'</span>';
632 if ($morphy ==
'mor') {
633 $labeltoshow = $labeltoshowm;
634 if ($addbadge == 2) {
640 $s .=
'<span class="member-company-back paddingleftimp paddingrightimp" title="'.$langs->trans(
"Moral").
'">'.$labeltoshow.
'</span>';
643 if ($morphy ==
'phy') {
644 $s = $langs->trans(
"Physical");
645 } elseif ($morphy ==
'mor') {
646 $s = $langs->trans(
"Moral");
660 public function create($user, $notrigger = 0)
662 global
$conf, $langs, $mysoc;
669 if (isset($this->import_key)) {
670 $this->import_key = trim($this->import_key);
675 $langs->load(
"errors");
676 $this->error = $langs->trans(
"ErrorBadEMail", (
string) $this->email);
683 if (empty($this->login)) {
684 $this->error = $langs->trans(
"ErrorWrongValueForParameterX",
"Login");
695 $sql =
"INSERT INTO ".MAIN_DB_PREFIX.
"adherent";
696 $sql .=
" (ref, datec, login, fk_user_author, fk_user_mod, fk_user_valid, morphy, fk_adherent_type, entity, import_key, ip)";
699 $sql .=
", '".$this->db->idate($this->datec).
"'";
700 $sql .=
", ".($this->login ?
"'".$this->db->escape($this->login).
"'" :
"null");
701 $sql .=
", ".($user->id > 0 ? $user->id :
"null");
702 $sql .=
", null, null, '".$this->db->escape($this->morphy).
"'";
703 $sql .=
", ".((int) $this->
typeid);
704 $sql .=
", ".((int) $this->entity);
705 $sql .=
", ".(!empty($this->import_key) ?
"'".$this->db->escape($this->import_key).
"'" :
"null");
706 $sql .=
", ".(!empty($this->ip) ?
"'".$this->db->escape($this->ip).
"'" :
"null");
709 dol_syslog(get_class($this).
"::create", LOG_DEBUG);
710 $result = $this->db->query($sql);
712 $id = $this->db->last_insert_id(MAIN_DB_PREFIX.
"adherent");
717 $this->
ref = (string) $id;
722 require_once $modfile;
724 $modCodeMember =
new $modname();
725 '@phan-var-force ModeleNumRefMembers $modCodeMember';
727 $this->
ref = $modCodeMember->getNextValue($mysoc, $this);
735 $result = $this->
update($user, 1, 1, 0, 0,
'add');
737 $this->db->rollback();
742 if ($this->user_id) {
744 $sql =
"UPDATE ".MAIN_DB_PREFIX.
"user SET";
745 $sql .=
" fk_member = ".((int) $this->
id);
746 $sql .=
" WHERE rowid = ".((int) $this->user_id);
747 dol_syslog(get_class($this).
"::create", LOG_DEBUG);
748 $resql = $this->db->query($sql);
750 $this->error =
'Failed to update user to make link with member';
751 $this->db->rollback();
765 if (count($this->errors)) {
766 dol_syslog(get_class($this).
"::create ".implode(
',', $this->errors), LOG_ERR);
767 $this->db->rollback();
774 $this->error =
'Failed to get last insert id';
775 dol_syslog(get_class($this).
"::create ".$this->error, LOG_ERR);
776 $this->db->rollback();
780 $this->error = $this->db->error();
781 $this->db->rollback();
798 public function update($user, $notrigger = 0, $nosyncuser = 0, $nosyncuserpass = 0, $nosyncthirdparty = 0, $action =
'update')
800 global $langs, $hookmanager;
802 require_once DOL_DOCUMENT_ROOT.
'/core/lib/functions2.lib.php';
804 if (empty($this->country_id) && !empty($this->country_code)) {
805 $country_id =
getCountry($this->country_code,
'3');
806 $this->country_id = is_int($country_id) ? $country_id : 0;
812 dol_syslog(get_class($this).
"::update notrigger=".$notrigger.
", nosyncuser=".$nosyncuser.
", nosyncuserpass=".$nosyncuserpass.
" nosyncthirdparty=".$nosyncthirdparty.
", email=".$this->email);
815 $this->lastname = trim($this->lastname) ? trim($this->lastname) : trim($this->lastname);
816 $this->firstname = trim($this->firstname) ? trim($this->firstname) : trim($this->firstname);
817 $this->gender = trim($this->gender);
825 $this->url = $this->url ?
clean_url($this->url, 0) :
'';
829 $langs->load(
"errors");
830 $this->error = $langs->trans(
"ErrorBadEMail", (
string) $this->email);
836 $sql =
"UPDATE ".MAIN_DB_PREFIX.
"adherent SET";
837 $sql .=
" ref = '".$this->db->escape($this->
ref).
"'";
838 $sql .=
", civility = ".($this->civility_id ?
"'".$this->db->escape($this->civility_id).
"'" :
"null");
839 $sql .=
", firstname = ".($this->firstname ?
"'".$this->db->escape($this->firstname).
"'" :
"null");
840 $sql .=
", lastname = ".($this->lastname ?
"'".$this->db->escape($this->lastname).
"'" :
"null");
841 $sql .=
", gender = ".($this->gender != -1 ?
"'".$this->db->escape($this->gender).
"'" :
"null");
842 $sql .=
", login = ".($this->login ?
"'".$this->db->escape($this->login).
"'" :
"null");
843 $sql .=
", societe = ".($this->company ?
"'".$this->db->escape($this->company).
"'" : ($this->societe ?
"'".$this->db->escape($this->societe).
"'" :
"null"));
845 $sql .=
", fk_soc = ".($this->socid > 0 ? (int) $this->socid :
"null");
847 $sql .=
", address = ".($this->address ?
"'".$this->db->escape($this->
address).
"'" :
"null");
848 $sql .=
", zip = ".($this->zip ?
"'".$this->db->escape($this->zip).
"'" :
"null");
849 $sql .=
", town = ".($this->town ?
"'".$this->db->escape($this->town).
"'" :
"null");
850 $sql .=
", country = ".($this->country_id > 0 ? (int) $this->country_id :
"null");
851 $sql .=
", state_id = ".($this->state_id > 0 ? (int) $this->state_id :
"null");
852 $sql .=
", email = '".$this->db->escape((
string) $this->email).
"'";
853 $sql .=
", url = ".(!empty($this->url) ?
"'".$this->db->escape($this->url).
"'" :
"null");
854 $sql .=
", socialnetworks = ".($this->socialnetworks ?
"'".$this->db->escape(json_encode($this->socialnetworks)).
"'" :
"null");
855 $sql .=
", phone = ".($this->phone ?
"'".$this->db->escape($this->phone).
"'" :
"null");
856 $sql .=
", phone_perso = ".($this->phone_perso ?
"'".$this->db->escape($this->phone_perso).
"'" :
"null");
857 $sql .=
", phone_mobile = ".($this->phone_mobile ?
"'".$this->db->escape($this->phone_mobile).
"'" :
"null");
858 $sql .=
", note_private = ".($this->note_private ?
"'".$this->db->escape($this->note_private).
"'" :
"null");
859 $sql .=
", note_public = ".($this->note_public ?
"'".$this->db->escape($this->note_public).
"'" :
"null");
860 $sql .=
", photo = ".($this->photo ?
"'".$this->db->escape($this->photo).
"'" :
"null");
861 $sql .=
", public = ".(int) $this->
public;
862 $sql .=
", statut = ".(int) $this->statut;
863 $sql .=
", default_lang = ".(!empty($this->default_lang) ?
"'".$this->db->escape($this->default_lang).
"'" :
"null");
864 $sql .=
", fk_adherent_type = ".(int) $this->
typeid;
865 $sql .=
", morphy = '".$this->db->escape($this->morphy).
"'";
866 $sql .=
", birth = ".($this->birth ?
"'".$this->db->idate($this->birth).
"'" :
"null");
868 if ($this->datefin) {
869 $sql .=
", datefin = '".$this->db->idate($this->datefin).
"'";
871 if ($this->datevalid) {
872 $sql .=
", datevalid = '".$this->db->idate($this->datevalid).
"'";
874 $sql .=
", fk_user_mod = ".($user->id > 0 ? $user->id :
'null');
875 $sql .=
" WHERE rowid = ".((int) $this->
id);
878 '@phan-var-force Adherent $oldcopy';
879 if (!empty($this->oldcopy) && $this->
typeid != $this->oldcopy->typeid) {
880 $sql2 =
"SELECT libelle as label";
881 $sql2 .=
" FROM ".MAIN_DB_PREFIX.
"adherent_type";
882 $sql2 .=
" WHERE rowid = ".((int) $this->
typeid);
883 $resql2 = $this->db->query($sql2);
885 while ($obj = $this->db->fetch_object($resql2)) {
886 $this->
type = $obj->label;
891 dol_syslog(get_class($this).
"::update update member", LOG_DEBUG);
892 $resql = $this->db->query($sql);
894 unset($this->country_code);
895 unset($this->country);
896 unset($this->state_code);
899 $nbrowsaffected += $this->db->affected_rows($resql);
912 if (!$error && $this->pass) {
913 dol_syslog(get_class($this).
"::update update password");
914 if ($this->pass != $this->pass_indatabase && $this->pass != $this->pass_indatabase_crypted) {
918 $result = $this->
setPassword($user, $this->pass, $isencrypted, $notrigger, $nosyncuserpass);
919 if (!$nbrowsaffected) {
927 dol_syslog(get_class($this).
"::update update link to user");
928 $sql =
"UPDATE ".MAIN_DB_PREFIX.
"user SET fk_member = NULL WHERE fk_member = ".((int) $this->
id);
929 dol_syslog(get_class($this).
"::update", LOG_DEBUG);
930 $resql = $this->db->query($sql);
932 $this->error = $this->db->error();
933 $this->db->rollback();
937 if ($this->user_id > 0) {
938 $sql =
"UPDATE ".MAIN_DB_PREFIX.
"user SET fk_member = ".((int) $this->
id).
" WHERE rowid = ".((int) $this->user_id);
939 dol_syslog(get_class($this).
"::update", LOG_DEBUG);
940 $resql = $this->db->query($sql);
942 $this->error = $this->db->error();
943 $this->db->rollback();
949 if (!$error && $nbrowsaffected) {
951 if (!$error && $this->user_id > 0 && !$nosyncuser) {
952 require_once DOL_DOCUMENT_ROOT.
'/user/class/user.class.php';
954 dol_syslog(get_class($this).
"::update update linked user");
956 $luser =
new User($this->db);
957 $result = $luser->fetch($this->user_id);
962 $luser->login = $this->login;
965 $luser->ref = $this->ref;
966 $luser->civility_id = $this->civility_id;
967 $luser->firstname = $this->firstname;
968 $luser->lastname = $this->lastname;
969 $luser->gender = $this->gender;
970 $luser->pass = isset($this->pass) ? $this->pass :
'';
973 $luser->birth = $this->birth;
975 $luser->address = $this->address;
976 $luser->zip = $this->zip;
977 $luser->town = $this->town;
978 $luser->country_id = $this->country_id;
979 $luser->state_id = $this->state_id;
981 $luser->email = $this->email;
982 $luser->socialnetworks = $this->socialnetworks;
983 $luser->office_phone = $this->phone;
984 $luser->user_mobile = $this->phone_mobile;
986 $luser->lang = $this->default_lang;
988 $luser->fk_member = $this->id;
990 $result = $luser->update($user, 0, 1, 1);
992 $this->error = $luser->error;
993 dol_syslog(get_class($this).
"::update ".$this->error, LOG_ERR);
997 $this->error = $luser->error;
1003 if (!$error && $this->fk_soc > 0 && !$nosyncthirdparty) {
1004 require_once DOL_DOCUMENT_ROOT.
'/societe/class/societe.class.php';
1006 dol_syslog(get_class($this).
"::update update linked thirdparty");
1010 $lthirdparty =
new Societe($this->db);
1011 $result = $lthirdparty->fetch($this->fk_soc);
1014 $lthirdparty->address = $this->address;
1015 $lthirdparty->zip = $this->zip;
1016 $lthirdparty->town = $this->town;
1017 $lthirdparty->email = $this->email;
1018 $lthirdparty->socialnetworks = $this->socialnetworks;
1019 $lthirdparty->phone = $this->phone;
1020 $lthirdparty->state_id = $this->state_id;
1021 $lthirdparty->country_id = $this->country_id;
1023 $lthirdparty->default_lang = $this->default_lang;
1025 $result = $lthirdparty->update($this->fk_soc, $user, 0, 1, 1,
'update');
1028 $this->error = $lthirdparty->error;
1029 $this->errors = $lthirdparty->errors;
1030 dol_syslog(get_class($this).
"::update ".$this->error, LOG_ERR);
1033 } elseif ($result < 0) {
1034 $this->error = $lthirdparty->error;
1040 if (!$error && !$notrigger) {
1050 $this->db->commit();
1051 return $nbrowsaffected;
1053 $this->db->rollback();
1057 $this->db->rollback();
1058 $this->error = $this->db->lasterror();
1078 $sql =
"SELECT rowid, datec as dateop, dateadh as datedeb, datef as datefin";
1079 $sql .=
" FROM ".MAIN_DB_PREFIX.
"subscription";
1080 $sql .=
" WHERE fk_adherent = ".((int) $this->
id);
1081 $sql .=
" ORDER by dateadh DESC";
1083 dol_syslog(get_class($this).
"::update_end_date", LOG_DEBUG);
1084 $resql = $this->db->query($sql);
1092 $dateendmember =
'';
1094 while ($obj = $this->db->fetch_object($resql)) {
1095 $dateendsubscription = $this->db->jdate($obj->datefin);
1097 $dateop = $this->db->jdate($obj->dateop);
1098 $datedeb = $this->db->jdate($obj->datedeb);
1099 $datefin = $dateendsubscription;
1101 if ($dateendsubscription !=
'' && ($dateendmember ==
'' || $dateendsubscription > $dateendmember)) {
1102 $dateendmember = $dateendsubscription;
1107 $sql =
"UPDATE ".MAIN_DB_PREFIX.
"adherent SET";
1108 $sql .=
" datefin=".($dateendmember !=
'' ?
"'".$this->db->idate($dateendmember).
"'" :
"null");
1109 $sql .=
" WHERE rowid = ".((int) $this->
id);
1111 dol_syslog(get_class($this).
"::update_end_date", LOG_DEBUG);
1112 $resql = $this->db->query($sql);
1114 $this->last_subscription_date = $dateop;
1115 $this->last_subscription_date_start = $datedeb;
1116 $this->last_subscription_date_end = $datefin;
1117 $this->datefin = $dateendmember;
1118 $this->db->commit();
1121 $this->db->rollback();
1125 $this->error = $this->db->lasterror();
1126 $this->db->rollback();
1138 public function delete($user, $notrigger = 0)
1151 if (!$error && !$notrigger) {
1161 $sql =
"DELETE FROM ".MAIN_DB_PREFIX.
"categorie_member WHERE fk_member = ".((int) $rowid);
1162 dol_syslog(get_class($this).
"::delete", LOG_DEBUG);
1163 $resql = $this->db->query($sql);
1166 $this->error .= $this->db->lasterror();
1172 $sql =
"DELETE FROM ".MAIN_DB_PREFIX.
"subscription WHERE fk_adherent = ".((int) $rowid);
1173 dol_syslog(get_class($this).
"::delete", LOG_DEBUG);
1174 $resql = $this->db->query($sql);
1177 $this->error .= $this->db->lasterror();
1183 if (!$error && isModEnabled(
'partnership')) {
1184 require_once DOL_DOCUMENT_ROOT.
'/partnership/class/partnership.class.php';
1186 $sql =
"SELECT rowid FROM ".MAIN_DB_PREFIX.
"partnership WHERE fk_member = ".((int) $rowid);
1187 dol_syslog(get_class($this).
"::delete", LOG_DEBUG);
1188 $resql = $this->db->query($sql);
1190 while ($obj = $this->db->fetch_object($resql)) {
1192 if ($partnership->fetch($obj->rowid) > 0 && $partnership->delete($user) <= 0) {
1194 $this->error .= $partnership->error;
1201 $this->error .= $this->db->lasterror();
1216 $dirofdocuments =
'';
1217 $subdirofdocuments =
get_exdir(0, 0, 0, 1, $this,
'member');
1218 if (!empty(
$conf->adherent->dir_output) && $subdirofdocuments !==
'') {
1219 $dirofdocuments =
$conf->adherent->dir_output.
'/'.$subdirofdocuments;
1221 if (!$error && $dirofdocuments) {
1222 require_once DOL_DOCUMENT_ROOT.
'/core/lib/files.lib.php';
1225 $this->error .= $this->db->lasterror();
1235 $this->error .= $this->db->lasterror();
1246 dol_syslog(get_class($this).
"::delete erreur ".$errorflag.
" ".$this->error, LOG_ERR);
1252 $sql =
"DELETE FROM ".MAIN_DB_PREFIX.
"adherent WHERE rowid = ".((int) $rowid);
1253 dol_syslog(get_class($this).
"::delete", LOG_DEBUG);
1254 $resql = $this->db->query($sql);
1257 $this->error .= $this->db->lasterror();
1263 $this->db->commit();
1266 if ($dirofdocuments) {
1267 require_once DOL_DOCUMENT_ROOT.
'/core/lib/files.lib.php';
1275 $this->db->rollback();
1291 public function setPassword($user, $password =
'', $isencrypted = 0, $notrigger = 0, $nosyncuser = 0)
1293 global
$conf, $langs;
1297 dol_syslog(get_class($this).
"::setPassword user=".$user->id.
" password=".preg_replace(
'/./i',
'*', $password).
" isencrypted=".$isencrypted);
1301 require_once DOL_DOCUMENT_ROOT.
'/core/lib/security2.lib.php';
1306 $password_crypted =
dol_hash($password);
1308 $password_indatabase =
'';
1309 if (!$isencrypted) {
1310 $password_indatabase = $password;
1316 $sql =
"UPDATE ".MAIN_DB_PREFIX.
"adherent";
1317 $sql .=
" SET pass_crypted = '".$this->db->escape($password_crypted).
"'";
1319 $sql .=
", pass = null";
1321 $sql .=
", pass = '".$this->db->escape($password_indatabase).
"'";
1323 $sql .=
" WHERE rowid = ".((int) $this->
id);
1326 dol_syslog(get_class($this).
"::setPassword", LOG_DEBUG);
1327 $result = $this->db->query($sql);
1329 $nbaffectedrows = $this->db->affected_rows($result);
1331 if ($nbaffectedrows) {
1332 $this->pass = $password;
1333 $this->pass_indatabase = $password_indatabase;
1334 $this->pass_indatabase_crypted = $password_crypted;
1336 if ($this->user_id && !$nosyncuser) {
1337 require_once DOL_DOCUMENT_ROOT.
'/user/class/user.class.php';
1341 $luser =
new User($this->db);
1342 $result = $luser->fetch($this->user_id);
1345 $result = $luser->setPassword($user, $this->pass, 0, 0, 1);
1346 if (is_int($result) && $result < 0) {
1347 $this->error = $luser->error;
1348 dol_syslog(get_class($this).
"::setPassword ".$this->error, LOG_ERR);
1352 $this->error = $luser->error;
1357 if (!$error && !$notrigger) {
1359 $result = $this->
call_trigger(
'MEMBER_NEW_PASSWORD', $user);
1362 $this->db->rollback();
1368 $this->db->commit();
1371 $this->db->rollback();
1375 $this->db->rollback();
1390 global
$conf, $langs;
1395 $sql =
"UPDATE ".MAIN_DB_PREFIX.
"user SET fk_member = NULL WHERE fk_member = ".((int) $this->
id);
1396 dol_syslog(get_class($this).
"::setUserId", LOG_DEBUG);
1397 $resql = $this->db->query($sql);
1399 $this->error = $this->db->error();
1400 $this->db->rollback();
1406 $sql =
"UPDATE ".MAIN_DB_PREFIX.
"user SET fk_member = ".((int) $this->
id);
1407 $sql .=
" WHERE rowid = ".((int) $userid);
1408 dol_syslog(get_class($this).
"::setUserId", LOG_DEBUG);
1409 $resql = $this->db->query($sql);
1411 $this->error = $this->db->error();
1412 $this->db->rollback();
1417 $this->db->commit();
1431 global
$conf, $langs;
1436 if ($thirdpartyid > 0) {
1437 $sql =
"UPDATE ".MAIN_DB_PREFIX.
"adherent SET fk_soc = null";
1438 $sql .=
" WHERE fk_soc = ".((int) $thirdpartyid);
1439 $sql .=
" AND entity = ".$conf->entity;
1440 dol_syslog(get_class($this).
"::setThirdPartyId", LOG_DEBUG);
1441 $resql = $this->db->query($sql);
1445 $sql =
"UPDATE ".MAIN_DB_PREFIX.
"adherent SET fk_soc = ".($thirdpartyid > 0 ? (int) $thirdpartyid :
'null');
1446 $sql .=
" WHERE rowid = ".((int) $this->
id);
1448 dol_syslog(get_class($this).
"::setThirdPartyId", LOG_DEBUG);
1449 $resql = $this->db->query($sql);
1451 $this->db->commit();
1454 $this->error = $this->db->error();
1455 $this->db->rollback();
1473 $sql =
"SELECT rowid FROM ".MAIN_DB_PREFIX.
"adherent";
1474 $sql .=
" WHERE login='".$this->db->escape($login).
"'";
1475 $sql .=
" AND entity = ".$conf->entity;
1477 $resql = $this->db->query($sql);
1479 if ($this->db->num_rows($resql)) {
1480 $obj = $this->db->fetch_object($resql);
1481 $this->
fetch($obj->rowid);
1501 $sql =
"SELECT rowid FROM ".MAIN_DB_PREFIX.
"adherent";
1502 $sql .=
" WHERE firstname='".$this->db->escape($firstname).
"'";
1503 $sql .=
" AND lastname='".$this->db->escape($lastname).
"'";
1504 $sql .=
" AND entity = ".$conf->entity;
1506 $resql = $this->db->query($sql);
1508 if ($this->db->num_rows($resql)) {
1509 $obj = $this->db->fetch_object($resql);
1510 $this->
fetch($obj->rowid);
1528 public function fetch($rowid, $ref =
'', $fk_soc = 0, $ref_ext =
'', $fetch_optionals =
true, $fetch_subscriptions =
true)
1532 $sql =
"SELECT d.rowid, d.ref, d.ref_ext, d.civility as civility_code, d.gender, d.firstname, d.lastname,";
1533 $sql .=
" d.societe as company, d.fk_soc, d.statut, d.public, d.address, d.zip, d.town, d.note_private,";
1534 $sql .=
" d.note_public,";
1535 $sql .=
" d.email, d.url, d.socialnetworks, d.phone, d.phone_perso, d.phone_mobile, d.login, d.pass, d.pass_crypted,";
1536 $sql .=
" d.photo, d.fk_adherent_type, d.morphy, d.entity,";
1537 $sql .=
" d.datec as datec,";
1538 $sql .=
" d.tms as datem,";
1539 $sql .=
" d.datefin as datefin, d.default_lang,";
1540 $sql .=
" d.birth as birthday,";
1541 $sql .=
" d.datevalid as datev,";
1542 $sql .=
" d.country,";
1543 $sql .=
" d.state_id,";
1544 $sql .=
" d.model_pdf,";
1545 $sql .=
" c.rowid as country_id, c.code as country_code, c.label as country,";
1546 $sql .=
" dep.nom as state, dep.code_departement as state_code,";
1547 $sql .=
" t.libelle as type, t.subscription as subscription,";
1548 $sql .=
" u.rowid as user_id, u.login as user_login";
1549 $sql .=
" FROM ".MAIN_DB_PREFIX.
"adherent_type as t, ".MAIN_DB_PREFIX.
"adherent as d";
1550 $sql .=
" LEFT JOIN ".MAIN_DB_PREFIX.
"c_country as c ON d.country = c.rowid";
1551 $sql .=
" LEFT JOIN ".MAIN_DB_PREFIX.
"c_departements as dep ON d.state_id = dep.rowid";
1552 $sql .=
" LEFT JOIN ".MAIN_DB_PREFIX.
"user as u ON d.rowid = u.fk_member";
1553 $sql .=
" WHERE d.fk_adherent_type = t.rowid";
1555 $sql .=
" AND d.rowid=".((int) $rowid);
1556 } elseif ($ref || $fk_soc) {
1557 $sql .=
" AND d.entity IN (".getEntity(
'adherent').
")";
1559 $sql .=
" AND d.ref='".$this->db->escape($ref).
"'";
1560 } elseif ($fk_soc > 0) {
1561 $sql .=
" AND d.fk_soc=".((int) $fk_soc);
1563 } elseif ($ref_ext) {
1564 $sql .=
" AND d.ref_ext='".$this->db->escape($ref_ext).
"'";
1567 dol_syslog(get_class($this).
"::fetch", LOG_DEBUG);
1568 $resql = $this->db->query($sql);
1570 if ($this->db->num_rows($resql)) {
1571 $obj = $this->db->fetch_object($resql);
1573 $this->entity = $obj->entity;
1574 $this->
id = $obj->rowid;
1575 $this->
ref = $obj->ref;
1576 $this->ref_ext = $obj->ref_ext;
1578 $this->civility_id = $obj->civility_code;
1579 $this->civility_code = $obj->civility_code;
1580 $this->civility = $obj->civility_code ? ($langs->trans(
"Civility".$obj->civility_code) !=
"Civility".$obj->civility_code ? $langs->trans(
"Civility".$obj->civility_code) : $obj->civility_code) :
'';
1582 $this->firstname = $obj->firstname;
1583 $this->lastname = $obj->lastname;
1584 $this->gender = $obj->gender;
1585 $this->login = $obj->login;
1586 $this->societe = $obj->company;
1587 $this->company = $obj->company;
1588 $this->socid = $obj->fk_soc;
1589 $this->fk_soc = $obj->fk_soc;
1590 $this->
address = $obj->address;
1591 $this->zip = $obj->zip;
1592 $this->town = $obj->town;
1594 $this->pass = $obj->pass;
1595 $this->pass_indatabase = $obj->pass;
1596 $this->pass_indatabase_crypted = $obj->pass_crypted;
1598 $this->state_id = $obj->state_id;
1599 $this->state_code = $obj->state_id ? $obj->state_code :
'';
1600 $this->state = $obj->state_id ? $obj->state :
'';
1602 $this->country_id = $obj->country_id;
1603 $this->country_code = $obj->country_code;
1604 if ($langs->trans(
"Country".$obj->country_code) !=
"Country".$obj->country_code) {
1605 $this->country = $langs->transnoentitiesnoconv(
"Country".$obj->country_code);
1607 $this->country = $obj->country;
1610 $this->phone = $obj->phone;
1611 $this->phone_perso = $obj->phone_perso;
1612 $this->phone_mobile = $obj->phone_mobile;
1613 $this->email = $obj->email;
1614 $this->url = $obj->url;
1616 $this->socialnetworks = ($obj->socialnetworks ? (array) json_decode($obj->socialnetworks,
true) : array());
1618 $this->photo = $obj->photo;
1619 $this->statut = $obj->statut;
1620 $this->
status = $obj->statut;
1621 $this->
public = $obj->public;
1623 $this->datec = $this->db->jdate($obj->datec);
1624 $this->date_creation = $this->db->jdate($obj->datec);
1625 $this->datem = $this->db->jdate($obj->datem);
1626 $this->date_modification = $this->db->jdate($obj->datem);
1627 $this->datefin = $this->db->jdate($obj->datefin);
1628 $this->datevalid = $this->db->jdate($obj->datev);
1629 $this->date_validation = $this->db->jdate($obj->datev);
1630 $this->birth = $this->db->jdate($obj->birthday);
1632 $this->default_lang = $obj->default_lang;
1634 $this->note_private = $obj->note_private;
1635 $this->note_public = $obj->note_public;
1636 $this->morphy = $obj->morphy;
1638 $this->
typeid = $obj->fk_adherent_type;
1639 $this->
type = $obj->type;
1640 $this->need_subscription = $obj->subscription;
1642 $this->user_id = $obj->user_id;
1643 $this->user_login = $obj->user_login;
1645 $this->model_pdf = $obj->model_pdf;
1649 if ($fetch_optionals) {
1654 if ($fetch_subscriptions) {
1663 $this->error = $this->db->lasterror();
1683 require_once DOL_DOCUMENT_ROOT.
'/adherents/class/subscription.class.php';
1685 $sql =
"SELECT c.rowid, c.fk_adherent, c.fk_type, c.subscription, c.note as note_public, c.fk_bank,";
1686 $sql .=
" c.tms as datem,";
1687 $sql .=
" c.datec as datec,";
1688 $sql .=
" c.dateadh as dateh,";
1689 $sql .=
" c.datef as datef";
1690 $sql .=
" FROM ".MAIN_DB_PREFIX.
"subscription as c";
1691 $sql .=
" WHERE c.fk_adherent = ".((int) $this->
id);
1692 $sql .=
" ORDER BY c.dateadh";
1693 dol_syslog(get_class($this).
"::fetch_subscriptions", LOG_DEBUG);
1695 $resql = $this->db->query($sql);
1697 $this->subscriptions = array();
1700 while ($obj = $this->db->fetch_object($resql)) {
1702 $this->first_subscription_date = $this->db->jdate($obj->datec);
1703 $this->first_subscription_date_start = $this->db->jdate($obj->dateh);
1704 $this->first_subscription_date_end = $this->db->jdate($obj->datef);
1705 $this->first_subscription_amount = $obj->subscription;
1707 $this->last_subscription_date = $this->db->jdate($obj->datec);
1708 $this->last_subscription_date_start = $this->db->jdate($obj->dateh);
1709 $this->last_subscription_date_end = $this->db->jdate($obj->datef);
1710 $this->last_subscription_amount = $obj->subscription;
1713 $subscription->id = $obj->rowid;
1714 $subscription->fk_adherent = $obj->fk_adherent;
1715 $subscription->fk_type = $obj->fk_type;
1716 $subscription->amount = $obj->subscription;
1717 $subscription->note = $obj->note_public;
1718 $subscription->note_public = $obj->note_public;
1719 $subscription->fk_bank = $obj->fk_bank;
1720 $subscription->datem = $this->db->jdate($obj->datem);
1721 $subscription->datec = $this->db->jdate($obj->datec);
1722 $subscription->dateh = $this->db->jdate($obj->dateh);
1723 $subscription->datef = $this->db->jdate($obj->datef);
1725 $this->subscriptions[] = $subscription;
1731 $this->error = $this->db->error().
' sql='.$sql;
1747 require_once DOL_DOCUMENT_ROOT.
'/partnership/class/partnership.class.php';
1750 $this->partnerships[] = array();
1771 public function subscription($date, $amount, $accountid = 0, $operation =
'', $label =
'', $num_chq =
'', $emetteur_nom =
'', $emetteur_banque =
'', $datesubend = 0, $fk_type =
null)
1775 require_once DOL_DOCUMENT_ROOT.
'/adherents/class/subscription.class.php';
1787 $datefin = $datesubend;
1796 $subscription->fk_adherent = $this->id;
1797 $subscription->dateh = $date;
1798 $subscription->datef = $datefin;
1799 $subscription->amount = $amount;
1800 $subscription->note = $label;
1801 $subscription->note_public = $label;
1802 $subscription->fk_type = $fk_type;
1804 if (empty($subscription->user_creation_id)) {
1805 $subscription->user_creation_id = $user->id;
1808 $rowid = $subscription->create($user);
1815 $this->last_subscription_date =
dol_now();
1816 $this->last_subscription_date_start = $date;
1817 $this->last_subscription_date_end = $datefin;
1818 $this->last_subscription_amount = $amount;
1822 $this->db->commit();
1825 $this->db->rollback();
1830 $this->db->rollback();
1855 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 =
'')
1857 global
$conf, $langs, $user, $mysoc;
1861 $this->invoice =
null;
1863 dol_syslog(
"subscriptionComplementaryActions subscriptionid=".$subscriptionid.
" option=".$option.
" accountid=".$accountid.
" datesubscription=".$datesubscription.
" paymentdate=".
1864 $paymentdate.
" label=".$label.
" amount=".$amount.
" num_chq=".$num_chq.
" autocreatethirdparty=".$autocreatethirdparty);
1867 if ($option ==
'bankdirect' && $accountid) {
1868 require_once DOL_DOCUMENT_ROOT.
'/compta/bank/class/account.class.php';
1870 $acct =
new Account($this->db);
1871 $result = $acct->fetch($accountid);
1873 $dateop = $paymentdate;
1875 $insertid = $acct->addline($dateop, $operation, $label, $amount, $num_chq, 0, $user, $emetteur_nom, $emetteur_banque);
1876 if ($insertid > 0) {
1877 $inserturlid = $acct->add_url_line($insertid, $this->
id, DOL_URL_ROOT.
'/adherents/card.php?rowid=', $this->getFullName($langs),
'member');
1878 if ($inserturlid > 0) {
1880 $sql =
"UPDATE ".MAIN_DB_PREFIX.
"subscription SET fk_bank=".((int) $insertid);
1881 $sql .=
" WHERE rowid=".((int) $subscriptionid);
1883 dol_syslog(
"subscription::subscription", LOG_DEBUG);
1884 $resql = $this->db->query($sql);
1887 $this->error = $this->db->lasterror();
1888 $this->errors[] = $this->error;
1901 if (($option ==
'bankviainvoice' && $accountid) || $option ==
'invoiceonly') {
1902 require_once DOL_DOCUMENT_ROOT.
'/compta/facture/class/facture.class.php';
1903 require_once DOL_DOCUMENT_ROOT.
'/compta/facture/class/paymentterm.class.php';
1905 $invoice =
new Facture($this->db);
1906 $customer =
new Societe($this->db);
1909 if (!($this->fk_soc > 0)) {
1910 if ($autocreatethirdparty) {
1915 if ($this->morphy ==
'mor') {
1916 $companyname = $this->company;
1917 if (!empty($fullname)) {
1918 $companyalias = $fullname;
1921 $companyname = $fullname;
1922 if (!empty($this->company)) {
1923 $companyalias = $this->company;
1927 $result = $customer->create_from_member($this, (
string) $companyname, $companyalias);
1929 $this->error = $customer->error;
1930 $this->errors = $customer->errors;
1933 $this->fk_soc = $result;
1936 $langs->load(
"errors");
1937 $this->error = $langs->trans(
"ErrorMemberNotLinkedToAThirpartyLinkOrCreateFirst");
1938 $this->errors[] = $this->error;
1944 $result = $customer->fetch($this->fk_soc);
1946 $this->error = $customer->error;
1947 $this->errors = $customer->errors;
1955 $invoice->cond_reglement_id = $customer->cond_reglement_id;
1956 if (empty($invoice->cond_reglement_id)) {
1958 $invoice->cond_reglement_id = $paymenttermstatic->getDefaultId();
1959 if (empty($invoice->cond_reglement_id)) {
1961 $this->error =
'ErrorNoPaymentTermRECEPFound';
1962 $this->errors[] = $this->error;
1965 $invoice->socid = $this->fk_soc;
1967 if (!empty($customer->fk_account)) {
1968 $invoice->fk_account = $customer->fk_account;
1974 if (!empty($customer->mode_reglement_id)) {
1975 $invoice->mode_reglement_id = $customer->mode_reglement_id;
1981 $invoice->linked_objects[
'subscription'] = $subscriptionid;
1983 $invoice->linked_objects = array_merge($invoice->linked_objects,
GETPOST(
'other_linked_objects',
'array:int'));
1986 $result = $invoice->create($user);
1988 $this->error = $invoice->error;
1989 $this->errors = $invoice->errors;
1992 $this->invoice = $invoice;
1998 $idprodsubscription = 0;
1999 if (
getDolGlobalString(
'ADHERENT_PRODUCT_ID_FOR_SUBSCRIPTIONS') && (isModEnabled(
"product") || isModEnabled(
"service"))) {
2004 if (
getDolGlobalString(
'ADHERENT_VAT_FOR_SUBSCRIPTIONS') ==
'defaultforfoundationcountry') {
2009 $result = $invoice->addline($label, 0, 1, $vattouse, 0, 0, $idprodsubscription, 0, $datesubscription,
'', 0, 0, 0,
'TTC', $amount, 1);
2011 $this->error = $invoice->error;
2012 $this->errors = $invoice->errors;
2019 $result = $invoice->validate($user);
2021 $this->error = $invoice->error;
2022 $this->errors = $invoice->errors;
2032 if (!$error && $option ==
'bankviainvoice' && $accountid) {
2033 require_once DOL_DOCUMENT_ROOT.
'/compta/paiement/class/paiement.class.php';
2034 require_once DOL_DOCUMENT_ROOT.
'/compta/bank/class/account.class.php';
2035 require_once DOL_DOCUMENT_ROOT.
'/core/lib/functions.lib.php';
2038 $amounts[$invoice->id] = (float)
price2num($amount);
2040 $paiement =
new Paiement($this->db);
2041 $paiement->datepaye = $paymentdate;
2042 $paiement->amounts = $amounts;
2043 $paiement->paiementcode = $operation;
2044 $paiement->paiementid =
dol_getIdFromCode($this->db, $operation,
'c_paiement',
'code',
'id', 1);
2045 $paiement->num_payment = $num_chq;
2046 $paiement->note_public = $label;
2047 $paiement->ext_payment_id = $ext_payment_id;
2048 $paiement->ext_payment_site = $ext_payment_site;
2052 $paiement_id = $paiement->create($user);
2053 if (!($paiement_id > 0)) {
2054 $this->error = $paiement->error;
2055 $this->errors = $paiement->errors;
2062 $bank_line_id = $paiement->addPaymentToBank($user,
'payment',
'(SubscriptionPayment)', $accountid, $emetteur_nom, $emetteur_banque);
2063 if (!($bank_line_id > 0)) {
2064 $this->error = $paiement->error;
2065 $this->errors = $paiement->errors;
2070 if (!$error && !empty($bank_line_id)) {
2072 $sql =
'UPDATE '.MAIN_DB_PREFIX.
'subscription SET fk_bank='.((int) $bank_line_id);
2073 $sql .=
' WHERE rowid='.((int) $subscriptionid);
2075 $result = $this->db->query($sql);
2083 $invoice->setPaid($user);
2089 $outputlangs = $langs;
2091 $lang_id =
GETPOST(
'lang_id');
2092 if (
getDolGlobalInt(
'MAIN_MULTILANGS') && empty($newlang) && !empty($lang_id)) {
2093 $newlang = $lang_id;
2096 $newlang = $customer->default_lang;
2098 if (!empty($newlang)) {
2100 $outputlangs->setDefaultLang($newlang);
2105 $invoice->fetch($invoice->id);
2106 $invoice->generateDocument($invoice->model_pdf, $outputlangs);
2126 global $langs,
$conf;
2132 if ($this->statut == self::STATUS_VALIDATED) {
2133 dol_syslog(get_class($this).
"::validate statut of member does not allow this", LOG_WARNING);
2139 $sql =
"UPDATE ".MAIN_DB_PREFIX.
"adherent SET";
2140 $sql .=
" statut = ".self::STATUS_VALIDATED;
2141 $sql .=
", datevalid = '".$this->db->idate($now).
"'";
2142 $sql .=
", fk_user_valid = ".((int) $user->id);
2143 $sql .=
" WHERE rowid = ".((int) $this->
id);
2145 dol_syslog(get_class($this).
"::validate", LOG_DEBUG);
2146 $result = $this->db->query($sql);
2151 $result = $this->
call_trigger(
'MEMBER_VALIDATE', $user);
2154 $this->db->rollback();
2159 $this->datevalid = $now;
2161 $this->db->commit();
2164 $this->error = $this->db->error();
2165 $this->db->rollback();
2179 global $langs,
$conf;
2184 if ($this->statut == self::STATUS_RESILIATED) {
2185 dol_syslog(get_class($this).
"::resiliate statut of member does not allow this", LOG_WARNING);
2191 $sql =
"UPDATE ".MAIN_DB_PREFIX.
"adherent SET";
2192 $sql .=
" statut = ".((int) self::STATUS_RESILIATED);
2193 $sql .=
", fk_user_valid = ".((int) $user->id);
2194 $sql .=
" WHERE rowid = ".((int) $this->
id);
2196 $result = $this->db->query($sql);
2201 $result = $this->
call_trigger(
'MEMBER_RESILIATE', $user);
2204 $this->db->rollback();
2209 $this->db->commit();
2212 $this->error = $this->db->error();
2213 $this->db->rollback();
2232 if ($this->statut == self::STATUS_EXCLUDED) {
2233 dol_syslog(get_class($this).
"::resiliate statut of member does not allow this", LOG_WARNING);
2239 $sql =
"UPDATE ".MAIN_DB_PREFIX.
"adherent SET";
2240 $sql .=
" statut = ".((int) self::STATUS_EXCLUDED);
2241 $sql .=
", fk_user_valid = ".((int) $user->id);
2242 $sql .=
" WHERE rowid = ".((int) $this->
id);
2244 $result = $this->db->query($sql);
2249 $result = $this->
call_trigger(
'MEMBER_EXCLUDE', $user);
2252 $this->db->rollback();
2257 $this->db->commit();
2260 $this->error = $this->db->error();
2261 $this->db->rollback();
2277 include_once DOL_DOCUMENT_ROOT.
'/mailmanspip/class/mailmanspip.class.php';
2284 $result = $mailmanspip->add_to_mailman($this);
2287 if (!empty($mailmanspip->error)) {
2288 $this->errors[] = $mailmanspip->error;
2292 foreach ($mailmanspip->mladded_ko as $tmplist => $tmpemail) {
2293 $langs->load(
"errors");
2294 $this->errors[] = $langs->trans(
"ErrorFailedToAddToMailmanList", $tmpemail, $tmplist);
2296 foreach ($mailmanspip->mladded_ok as $tmplist => $tmpemail) {
2297 $langs->load(
"mailmanspip");
2298 $this->mesgs[] = $langs->trans(
"SuccessToAddToMailmanList", $tmpemail, $tmplist);
2304 $result = $mailmanspip->add_to_spip($this);
2306 $this->errors[] = $mailmanspip->error;
2327 global
$conf, $langs;
2329 include_once DOL_DOCUMENT_ROOT.
'/mailmanspip/class/mailmanspip.class.php';
2336 $result = $mailmanspip->del_to_mailman($this);
2338 if (!empty($mailmanspip->error)) {
2339 $this->errors[] = $mailmanspip->error;
2344 foreach ($mailmanspip->mlremoved_ko as $tmplist => $tmpemail) {
2345 $langs->load(
"errors");
2346 $this->errors[] = $langs->trans(
"ErrorFailedToRemoveToMailmanList", $tmpemail, $tmplist);
2348 foreach ($mailmanspip->mlremoved_ok as $tmplist => $tmpemail) {
2349 $langs->load(
"mailmanspip");
2350 $this->mesgs[] = $langs->trans(
"SuccessToRemoveToMailmanList", $tmpemail, $tmplist);
2355 $result = $mailmanspip->del_to_spip($this);
2357 $this->errors[] = $mailmanspip->error;
2378 $langs->load(
"dict");
2380 $code = (empty($this->civility_id) ?
'' : $this->civility_id);
2384 return $langs->getLabelFromKey($this->db,
"Civility".$code,
"c_civility",
"code",
"label", $code);
2397 $langs->loadLangs([
'members',
'companies']);
2398 $nofetch = !empty($params[
'nofetch']);
2403 $langs->load(
"users");
2404 return [
'optimize' => $langs->trans(
"ShowUser")];
2406 if (!empty($this->photo)) {
2407 $photo =
'<div class="photointooltip floatright">';
2408 $photo .=
Form::showphoto(
'memberphoto', $this, 80, 0, 0,
'photoref photowithmargin photologintooltip',
'small', 0, 1);
2410 $datas[
'photo'] = $photo;
2413 $datas[
'divopen'] =
'<div class="centpercent">';
2414 $datas[
'picto'] =
img_picto(
'', $this->picto).
' <u class="paddingrightonly">'.$langs->trans(
"Member").
'</u> '.$this->
getLibStatut(4);
2415 if (!empty($this->morphy)) {
2416 $datas[
'picto'] .=
' ' . $this->
getmorphylib(
'', 1);
2418 if (!empty($this->
ref)) {
2419 $datas[
'ref'] =
'<br><b>'.$langs->trans(
'Ref').
':</b> '.$this->ref;
2421 if (!empty($this->login)) {
2422 $datas[
'login'] =
'<br><b>'.$langs->trans(
'Login').
':</b> '.$this->login;
2424 if (!empty($this->firstname) || !empty($this->lastname)) {
2425 $datas[
'name'] =
'<br><b>'.$langs->trans(
'Name').
':</b> '.$this->
getFullName($langs);
2427 if (!empty($this->company)) {
2428 $datas[
'company'] =
'<br><b>'.$langs->trans(
'Company').
':</b> '.$this->company;
2430 if (!empty($this->email)) {
2431 $datas[
'email'] =
'<br><b>'.$langs->trans(
"EMail").
':</b> '.$this->email;
2433 $datas[
'address'] =
'<br><b>'.$langs->trans(
"Address").
':</b> '.
dol_format_address($this, 1,
' ', $langs);
2435 if (isModEnabled(
'category') && !$nofetch) {
2436 require_once DOL_DOCUMENT_ROOT .
'/categories/class/categorie.class.php';
2437 $form =
new Form($this->db);
2438 $datas[
'categories'] =
'<br>' . $form->showCategories($this->
id, Categorie::TYPE_MEMBER, 1);
2440 $datas[
'divclose'] =
'</div>';
2458 public function getNomUrl($withpictoimg = 0, $maxlen = 0, $option =
'card', $mode =
'', $morecss =
'', $save_lastsearch_value = -1, $notooltip = 0, $addlinktonotes = 0)
2460 global
$conf, $langs, $hookmanager;
2469 $classfortooltip =
'classfortooltip';
2473 'objecttype' => $this->element,
2474 'option' => $option,
2478 $classfortooltip =
'classforajaxtooltip';
2479 $dataparams =
' data-params="'.dol_escape_htmltag(json_encode($params)).
'"';
2485 $url = DOL_URL_ROOT.
'/adherents/card.php?rowid='.((int) $this->
id);
2486 if ($option ==
'subscription') {
2487 $url = DOL_URL_ROOT.
'/adherents/subscription.php?rowid='.((int) $this->
id);
2490 if ($option !=
'nolink') {
2492 $add_save_lastsearch_values = ($save_lastsearch_value == 1 ? 1 : 0);
2493 if ($save_lastsearch_value == -1 && isset($_SERVER[
"PHP_SELF"]) && preg_match(
'/list\.php/', $_SERVER[
"PHP_SELF"])) {
2494 $add_save_lastsearch_values = 1;
2496 if ($add_save_lastsearch_values) {
2497 $url .=
'&save_lastsearch_values=1';
2501 $linkstart .=
'<a href="'.$url.
'"';
2503 if (empty($notooltip)) {
2505 $langs->load(
"users");
2506 $label = $langs->trans(
"ShowUser");
2507 $linkclose .=
' alt="'.dolPrintHTMLForAttribute($label).
'"';
2509 $linkclose .= ($label ?
' title="'.dolPrintHTMLForAttribute($label).
'"' :
' title="tocomplete"');
2510 $linkclose .= $dataparams.
' class="'.$classfortooltip.($morecss ?
' '.$morecss :
'').
'"';
2513 $linkstart .= $linkclose.
'>';
2516 $result .= $linkstart;
2518 if ($withpictoimg) {
2519 $paddafterimage =
'';
2520 if (abs($withpictoimg) == 1 || abs($withpictoimg) == 4) {
2521 $morecss .=
' paddingrightonly';
2524 if ($withpictoimg > 0) {
2525 $picto =
'<span class="nopadding'.($morecss ?
' userimg'.$morecss :
'').
'">'.
img_object(
'',
'user', $paddafterimage.
' '.($notooltip ?
'' : $dataparams), 0, 0, $notooltip ? 0 : 1).
'</span>';
2528 $picto =
'<span class="nopadding'.($morecss ?
' userimg'.$morecss :
'').
'"'.($paddafterimage ?
' '.$paddafterimage :
'').
'>';
2529 $picto .=
Form::showphoto(
'memberphoto', $this, 0, 0, 0,
'userphoto'.(($withpictoimg == -3 || $withpictoimg == -4) ?
'small' :
''),
'mini', 0, 1);
2530 $picto .=
'</span>';
2534 if (($withpictoimg > -2 && $withpictoimg != 2) || $withpictoimg == -4) {
2536 $result .=
'<span class="nopadding valignmiddle'.((!isset($this->statut) || $this->statut) ?
'' :
' strikefordisabled').
2537 ($morecss ?
' usertext'.$morecss :
'').
'">';
2539 if ($mode ==
'login') {
2540 $result .=
dol_trunc(isset($this->login) ? $this->login :
'', $maxlen);
2541 } elseif ($mode ==
'ref') {
2542 $result .= $this->ref;
2544 $result .= $this->
getFullName($langs, 0, ($mode ==
'firstname' ? 2 : ($mode ==
'lastname' ? 4 : -1)), $maxlen);
2547 $result .=
'</span>';
2551 $result .= $linkend;
2553 if ($addlinktonotes) {
2554 if ($this->note_private) {
2555 $notetoshow = $langs->trans(
"ViewPrivateNote").
':<br>'.
dol_string_nohtmltag($this->note_private, 1);
2556 $result .=
' <span class="note inline-block">';
2557 $result .=
'<a href="'.DOL_URL_ROOT.
'/adherents/note.php?id='.$this->
id.
'" class="classfortooltip" title="'.
dol_escape_htmltag($notetoshow).
'">';
2560 $result .=
'</span>';
2564 $hookmanager->initHooks(array($this->element .
'dao'));
2565 $parameters = array(
'id' => $this->
id,
'getnomurl' => &$result);
2566 $reshook = $hookmanager->executeHooks(
'getNomUrl', $parameters, $this, $action);
2568 $result = $hookmanager->resPrint;
2570 $result .= $hookmanager->resPrint;
2583 return $this->
LibStatut($this->
status, $this->need_subscription, $this->datefin, $mode);
2596 public function LibStatut($status, $need_subscription, $date_end_subscription, $mode = 0)
2600 $langs->load(
"members");
2604 $labelStatusShort =
'';
2606 if ($status == self::STATUS_DRAFT) {
2607 $statusType =
'status0';
2608 $labelStatus = $langs->trans(
"MemberStatusDraft");
2609 $labelStatusShort = $langs->trans(
"MemberStatusDraftShort");
2610 } elseif ($status >= self::STATUS_VALIDATED) {
2611 if ($need_subscription === 0) {
2612 $statusType =
'status4';
2613 $labelStatus = $langs->trans(
"Validated").
' - '.$langs->trans(
"MemberStatusNoSubscription");
2614 $labelStatusShort = $langs->trans(
"MemberStatusNoSubscriptionShort");
2615 } elseif (!$date_end_subscription) {
2616 $statusType =
'status1';
2617 $labelStatus = $langs->trans(
"Validated").
' - '.$langs->trans(
"WaitingSubscription");
2618 $labelStatusShort = $langs->trans(
"WaitingSubscriptionShort");
2619 } elseif ($date_end_subscription <
dol_now()) {
2620 $statusType =
'status2';
2621 $labelStatus = $langs->trans(
"Validated").
' - '.$langs->trans(
"MemberStatusActiveLate");
2622 $labelStatusShort = $langs->trans(
"MemberStatusActiveLateShort");
2624 $statusType =
'status4';
2625 $labelStatus = $langs->trans(
"Validated").
' - '.$langs->trans(
"MemberStatusPaid");
2626 $labelStatusShort = $langs->trans(
"MemberStatusPaidShort");
2628 } elseif ($status == self::STATUS_RESILIATED) {
2629 $statusType =
'status6';
2630 $labelStatus = $langs->transnoentitiesnoconv(
"MemberStatusResiliated");
2631 $labelStatusShort = $langs->transnoentitiesnoconv(
"MemberStatusResiliatedShort");
2632 } elseif ($status == self::STATUS_EXCLUDED) {
2633 $statusType =
'status10';
2634 $labelStatus = $langs->transnoentitiesnoconv(
"MemberStatusExcluded");
2635 $labelStatusShort = $langs->transnoentitiesnoconv(
"MemberStatusExcludedShort");
2638 return dolGetStatus($labelStatus, $labelStatusShort,
'', $statusType, $mode);
2651 $this->nb = array();
2653 $sql =
"SELECT count(a.rowid) as nb";
2654 $sql .=
" FROM ".MAIN_DB_PREFIX.
"adherent as a";
2655 $sql .=
" WHERE a.statut > 0";
2656 $sql .=
" AND a.entity IN (".getEntity(
'adherent').
")";
2658 $resql = $this->db->query($sql);
2660 while ($obj = $this->db->fetch_object($resql)) {
2661 $this->nb[
"members"] = $obj->nb;
2663 $this->db->free($resql);
2667 $this->error = $this->db->error();
2683 global
$conf, $langs;
2691 $sql =
"SELECT a.rowid, a.datefin, a.statut";
2692 $sql .=
" FROM ".MAIN_DB_PREFIX.
"adherent as a";
2693 $sql .=
", ".MAIN_DB_PREFIX.
"adherent_type as t";
2694 $sql .=
" WHERE a.fk_adherent_type = t.rowid";
2695 if ($mode ==
'expired') {
2696 $sql .=
" AND a.statut = ".self::STATUS_VALIDATED;
2697 $sql .=
" AND a.entity IN (".getEntity(
'adherent').
")";
2698 $sql .=
" AND ((a.datefin IS NULL or a.datefin < '".$this->db->idate($now).
"') AND t.subscription = '1')";
2699 } elseif ($mode ==
'shift') {
2700 $sql .=
" AND a.statut = ".self::STATUS_DRAFT;
2701 $sql .=
" AND a.entity IN (".getEntity(
'adherent').
")";
2704 $resql = $this->db->query($sql);
2706 $langs->load(
"members");
2713 if ($mode ==
'expired') {
2714 $warning_delay =
$conf->adherent->subscription->warning_delay / 60 / 60 / 24;
2715 $label = $langs->trans(
"MembersWithSubscriptionToReceive");
2716 $labelShort = $langs->trans(
"MembersWithSubscriptionToReceiveShort");
2717 $url = DOL_URL_ROOT.
'/adherents/list.php?mainmenu=members&statut='.self::STATUS_VALIDATED.
'&filter=outofdate';
2718 } elseif ($mode ==
'shift') {
2719 $warning_delay =
$conf->adherent->subscription->warning_delay / 60 / 60 / 24;
2720 $url = DOL_URL_ROOT.
'/adherents/list.php?mainmenu=members&statut='.
self::STATUS_DRAFT;
2721 $label = $langs->trans(
"MembersListToValid");
2722 $labelShort = $langs->trans(
"ToValidate");
2726 $response->warning_delay = $warning_delay;
2727 $response->label = $label;
2728 $response->labelShort = $labelShort;
2729 $response->url = $url;
2732 $adherentstatic =
new Adherent($this->db);
2734 while ($obj = $this->db->fetch_object($resql)) {
2735 $response->nbtodo++;
2737 $adherentstatic->datefin = $this->db->jdate($obj->datefin);
2738 $adherentstatic->statut = $obj->statut;
2739 $adherentstatic->status = $obj->statut;
2741 if ($adherentstatic->hasDelay()) {
2742 $response->nbtodolate++;
2749 $this->error = $this->db->error();
2766 public function generateDocument($modele, $outputlangs, $hidedetails = 0, $hidedesc = 0, $hideref = 0, $moreparams =
null)
2768 global
$conf, $langs;
2770 $langs->load(
"orders");
2773 $modele =
'standard';
2775 if ($this->model_pdf) {
2776 $modele = $this->model_pdf;
2782 $modelpath =
"core/modules/member/doc/";
2784 return $this->
commonGenerateDocument($modelpath, $modele, $outputlangs, $hidedetails, $hidedesc, $hideref, $moreparams);
2797 global $user, $langs;
2802 $this->
ref =
'ABC001';
2804 $this->specimen = 1;
2805 $this->civility_id =
'MR';
2806 $this->lastname =
'DOLIBARR';
2807 $this->firstname =
'SPECIMEN';
2808 $this->gender =
'man';
2809 $this->login =
'dolibspec';
2810 $this->pass =
'dolibspec';
2811 $this->company =
'Societe ABC';
2812 $this->
address =
'61 jump street';
2813 $this->zip =
'75000';
2814 $this->town =
'Paris';
2815 $this->country_id = 1;
2816 $this->country_code =
'FR';
2817 $this->country =
'France';
2818 $this->morphy =
'mor';
2819 $this->email =
'specimen@specimen.com';
2820 $this->socialnetworks = array(
2821 'skype' =>
'skypepseudo',
2822 'twitter' =>
'twitterpseudo',
2823 'facebook' =>
'facebookpseudo',
2824 'linkedin' =>
'linkedinpseudo',
2826 $this->phone =
'0999999999';
2827 $this->phone_perso =
'0999999998';
2828 $this->phone_mobile =
'0999999997';
2829 $this->note_public =
'This is a public note';
2830 $this->note_private =
'This is a private note';
2831 $this->birth = $now;
2837 $this->datefin = $now;
2838 $this->datevalid = $now;
2839 $this->default_lang =
'';
2842 $this->
type =
'Type adherent';
2843 $this->need_subscription = 0;
2845 $this->first_subscription_date = $now;
2846 $this->first_subscription_date_start = $this->first_subscription_date;
2847 $this->first_subscription_date_end =
dol_time_plus_duree($this->first_subscription_date_start, 1,
'y');
2848 $this->first_subscription_amount = 10;
2850 $this->last_subscription_date = $this->first_subscription_date;
2851 $this->last_subscription_date_start = $this->first_subscription_date;
2852 $this->last_subscription_date_end =
dol_time_plus_duree($this->last_subscription_date_start, 1,
'y');
2853 $this->last_subscription_amount = 10;
2897 global
$conf, $langs;
2901 $keymodified =
false;
2909 if ($this->morphy ==
'mor' && (empty($this->fullname) || $this->fullname == $this->company)) {
2910 $this->fullname = $this->company;
2911 $this->lastname = $this->company;
2916 'LDAP_MEMBER_FIELD_FULLNAME' =>
'fullname',
2917 'LDAP_MEMBER_FIELD_NAME' =>
'lastname',
2918 'LDAP_MEMBER_FIELD_LOGIN' =>
'login',
2919 'LDAP_MEMBER_FIELD_LOGIN_SAMBA' =>
'login',
2920 'LDAP_MEMBER_FIELD_MAIL' =>
'email'
2924 foreach ($ldapkey as $constname => $varname) {
2930 if (!empty($this->oldcopy) && $this->$varname != $this->oldcopy->$varname) {
2931 $keymodified =
true;
2957 foreach ($socialnetworks as $key => $value) {
2958 if ($this->socialnetworks[$value[
'label']] &&
getDolGlobalString(
'LDAP_MEMBER_FIELD_'.strtoupper($value[
'label']))) {
2959 $info[
getDolGlobalString(
'LDAP_MEMBER_FIELD_'.strtoupper($value[
'label']))] = $this->socialnetworks[$value[
'label']];
2986 if ($this->datefin &&
getDolGlobalString(
'LDAP_FIELD_MEMBER_END_LASTSUBSCRIPTION')) {
2991 if (!empty($this->pass)) {
3004 if ($this->pass_indatabase_crypted &&
getDolGlobalString(
'LDAP_MEMBER_FIELD_PASSWORD_CRYPTED')) {
3010 } elseif (!empty($this->pass_indatabase)) {
3022 if ($this->first_subscription_date &&
getDolGlobalString(
'LDAP_FIELD_MEMBER_FIRSTSUBSCRIPTION_DATE')) {
3025 if (isset($this->first_subscription_amount) &&
getDolGlobalString(
'LDAP_FIELD_MEMBER_FIRSTSUBSCRIPTION_AMOUNT')) {
3026 $info[
getDolGlobalString(
'LDAP_FIELD_MEMBER_FIRSTSUBSCRIPTION_AMOUNT')] = $this->first_subscription_amount;
3028 if ($this->last_subscription_date &&
getDolGlobalString(
'LDAP_FIELD_MEMBER_LASTSUBSCRIPTION_DATE')) {
3031 if (isset($this->last_subscription_amount) &&
getDolGlobalString(
'LDAP_FIELD_MEMBER_LASTSUBSCRIPTION_AMOUNT')) {
3032 $info[
getDolGlobalString(
'LDAP_FIELD_MEMBER_LASTSUBSCRIPTION_AMOUNT')] = $this->last_subscription_amount;
3047 $sql =
'SELECT a.rowid, a.datec as datec,';
3048 $sql .=
' a.datevalid as datev,';
3049 $sql .=
' a.tms as datem,';
3050 $sql .=
' a.fk_user_author, a.fk_user_valid, a.fk_user_mod';
3051 $sql .=
' FROM '.MAIN_DB_PREFIX.
'adherent as a';
3052 $sql .=
' WHERE a.rowid = '.((int) $id);
3054 dol_syslog(get_class($this).
"::info", LOG_DEBUG);
3055 $result = $this->db->query($sql);
3057 if ($this->db->num_rows($result)) {
3058 $obj = $this->db->fetch_object($result);
3060 $this->
id = $obj->rowid;
3062 $this->user_creation_id = $obj->fk_user_author;
3063 $this->user_validation_id = $obj->fk_user_valid;
3064 $this->user_modification_id = $obj->fk_user_mod;
3065 $this->date_creation = $this->db->jdate($obj->datec);
3066 $this->date_validation = $this->db->jdate($obj->datev);
3067 $this->date_modification = $this->db->jdate($obj->datem);
3070 $this->db->free($result);
3083 $sql =
"SELECT count(mc.email) as nb";
3084 $sql .=
" FROM ".MAIN_DB_PREFIX.
"mailing_cibles as mc";
3085 $sql .=
" WHERE mc.email = '".$this->db->escape($this->email).
"'";
3086 $sql .=
" AND mc.statut NOT IN (-1,0)";
3088 $resql = $this->db->query($sql);
3090 $obj = $this->db->fetch_object($resql);
3093 $this->db->free($resql);
3096 $this->error = $this->db->error();
3113 require_once DOL_DOCUMENT_ROOT.
'/categories/class/categorie.class.php';
3114 return parent::setCategoriesCommon($categories, Categorie::TYPE_MEMBER);
3127 $tables = array(
'adherent');
3142 if ($this->statut != self::STATUS_VALIDATED) {
3145 if (!$this->datefin) {
3151 return $this->datefin < ($now -
$conf->adherent->subscription->warning_delay);
3165 global
$conf, $langs, $mysoc, $user;
3171 $blockingerrormsg =
'';
3173 if (!isModEnabled(
'member')) {
3174 $langs->load(
"agenda");
3175 $this->output = $langs->trans(
'ModuleNotEnabled', $langs->transnoentitiesnoconv(
"Adherent"));
3179 $langs->load(
"agenda");
3180 $this->output = $langs->trans(
'EventRemindersByEmailNotEnabled', $langs->transnoentitiesnoconv(
"Adherent"));
3188 $listofmembersok = array();
3189 $listofmembersko = array();
3191 $arraydaysbeforeend = explode(
';', $daysbeforeendlist);
3192 foreach ($arraydaysbeforeend as $daysbeforeend) {
3193 dol_syslog(__METHOD__.
' - Process delta = '.$daysbeforeend, LOG_DEBUG);
3195 if (!is_numeric($daysbeforeend)) {
3196 $blockingerrormsg =
"Value for delta is not a numeric value";
3202 $datetosearchfor =
dol_time_plus_duree(
dol_mktime(0, 0, 0, $tmp[
'mon'], $tmp[
'mday'], $tmp[
'year'],
'tzserver'), (
int) $daysbeforeend,
'd');
3203 $datetosearchforend =
dol_time_plus_duree(
dol_mktime(23, 59, 59, $tmp[
'mon'], $tmp[
'mday'], $tmp[
'year'],
'tzserver'), (
int) $daysbeforeend,
'd');
3205 $sql =
'SELECT rowid FROM '.MAIN_DB_PREFIX.
'adherent';
3206 $sql .=
" WHERE entity = ".((int)
$conf->entity);
3207 $sql .=
" AND statut = 1";
3208 $sql .=
" AND datefin >= '".$this->db->idate($datetosearchfor).
"'";
3209 $sql .=
" AND datefin <= '".$this->db->idate($datetosearchforend).
"'";
3210 if ((
int) $fk_adherent_type > 0) {
3211 $sql .=
" AND fk_adherent_type = ".((int) $fk_adherent_type);
3215 $resql = $this->db->query($sql);
3217 $num_rows = $this->db->num_rows($resql);
3219 include_once DOL_DOCUMENT_ROOT.
'/core/class/html.formmail.class.php';
3220 $formmail =
new FormMail($this->db);
3223 while ($i < $num_rows) {
3224 $obj = $this->db->fetch_object($resql);
3228 $adherent =
new Adherent($this->db);
3229 $adherent->fetch($obj->rowid,
'', 0,
'',
true,
true);
3231 if (empty($adherent->email)) {
3233 $listofmembersko[$adherent->id] = $adherent->id;
3235 $thirdpartyres = $adherent->fetch_thirdparty();
3236 if ($thirdpartyres === -1) {
3237 $languagecodeformember = $mysoc->default_lang;
3240 $languagefromcountrycode =
getLanguageCodeFromCountryCode($adherent->country_code ? $adherent->country_code : (is_object($adherent->thirdparty) ? $adherent->thirdparty->country_code :
''));
3241 $languagecodeformember = (empty($adherent->thirdparty->default_lang) ? ($languagefromcountrycode ? $languagefromcountrycode : $mysoc->default_lang) : $adherent->thirdparty->default_lang);
3243 if (!empty($adherent->default_lang)) {
3245 $languagecodeformember = $adherent->default_lang;
3250 $outputlangs->setDefaultLang($languagecodeformember);
3251 $outputlangs->loadLangs(array(
"main",
"members"));
3252 dol_syslog(
"sendReminderForExpiredSubscription Language for member id ".$adherent->id.
" set to ".$outputlangs->defaultlang.
" mysoc->default_lang=".$mysoc->default_lang);
3254 $arraydefaultmessage =
null;
3257 if (!empty($labeltouse)) {
3258 $arraydefaultmessage = $formmail->getEMailTemplate($this->db,
'member', $user, $outputlangs, 0, 1, $labeltouse);
3261 if (!empty($labeltouse) && is_object($arraydefaultmessage) && $arraydefaultmessage->id > 0) {
3262 $substitutionarray = getCommonSubstitutionArray($outputlangs, 0,
null, $adherent);
3266 $subject =
make_substitutions($arraydefaultmessage->topic, $substitutionarray, $outputlangs);
3267 $msg =
make_substitutions($arraydefaultmessage->content, $substitutionarray, $outputlangs);
3269 $to = $adherent->email;
3272 $trackid =
'mem'.$adherent->id;
3273 $moreinheader =
'X-Dolibarr-Info: sendReminderForExpiredSubscription'.
"\r\n";
3275 include_once DOL_DOCUMENT_ROOT.
'/core/class/CMailFile.class.php';
3276 $cmail =
new CMailFile($subject, $to, $from, $msg, array(), array(), array(), $cc,
'', 0, 1,
'',
'', $trackid, $moreinheader);
3277 $result = $cmail->sendfile();
3280 $this->error .= $cmail->error.
' ';
3281 if (!is_null($cmail->errors)) {
3282 $this->errors += $cmail->errors;
3285 $listofmembersko[$adherent->id] = $adherent->id;
3288 $listofmembersok[$adherent->id] = $adherent->id;
3294 $actioncode =
'EMAIL';
3295 $extraparams = array();
3305 $actionmsg =
dol_concatdesc($actionmsg, $langs->transnoentities(
'MailTopic').
": ".$subject);
3306 $actionmsg =
dol_concatdesc($actionmsg, $langs->transnoentities(
'TextUsedInTheMessageBody').
":");
3310 require_once DOL_DOCUMENT_ROOT.
'/comm/action/class/actioncomm.class.php';
3315 $actioncomm->type_code =
'AC_OTH_AUTO';
3316 $actioncomm->code =
'AC_'.$actioncode;
3317 $actioncomm->label = $actionmsg2;
3318 $actioncomm->note_private = $actionmsg;
3319 $actioncomm->fk_project = 0;
3320 $actioncomm->datep = $now;
3321 $actioncomm->datef = $now;
3322 $actioncomm->percentage = -1;
3323 $actioncomm->socid = (is_object($adherent->thirdparty) ? $adherent->thirdparty->id : 0);
3324 $actioncomm->contact_id = 0;
3325 $actioncomm->authorid = $user->id;
3326 $actioncomm->userownerid = $user->id;
3328 $actioncomm->email_msgid = $cmail->msgid;
3329 $actioncomm->email_from = $from;
3330 $actioncomm->email_sender =
'';
3331 $actioncomm->email_to = $to;
3332 $actioncomm->email_tocc = $sendtocc;
3333 $actioncomm->email_tobcc = $sendtobcc;
3334 $actioncomm->email_subject = $subject;
3335 $actioncomm->errors_to =
'';
3337 $actioncomm->fk_element = $adherent->id;
3338 $actioncomm->elementid = $adherent->id;
3339 $actioncomm->elementtype = $adherent->element;
3341 $actioncomm->extraparams = $extraparams;
3343 $actioncomm->create($user);
3349 $this->error .=
"Can't find email template with label=".$labeltouse.
", to use for the reminding email ";
3352 $listofmembersko[$adherent->id] = $adherent->id;
3361 $this->error = $this->db->lasterror();
3366 if ($blockingerrormsg) {
3367 $this->error = $blockingerrormsg;
3370 $this->output =
'Found '.($nbok + $nbko).
' members to send reminder to.';
3371 $this->output .=
' Send email successfully to '.$nbok.
' members';
3372 if (is_array($listofmembersok)) {
3375 foreach ($listofmembersok as $idmember) {
3377 $listofids .=
', ...';
3380 if (empty($listofids)) {
3385 $listofids .= $idmember;
3392 $this->output .= ($listofids ?
' ids='.$listofids :
'');
3395 $this->output .=
' - Canceled for '.$nbko.
' member (no email or email sending error)';
3396 if (is_array($listofmembersko)) {
3399 foreach ($listofmembersko as $idmember) {
3401 $listofids .=
', ...';
3404 if (empty($listofids)) {
3409 $listofids .= $idmember;
3415 $this->output .= ($listofids ?
' ids='.$listofids :
'');
3432 $selected = (empty($arraydata[
'selected']) ? 0 : $arraydata[
'selected']);
3434 $return =
'<div class="box-flex-item box-flex-grow-zero">';
3435 $return .=
'<div class="info-box info-box-sm">';
3436 $return .=
'<span class="info-box-icon bg-infobox-action">';
3437 if (property_exists($this,
'photo') || !empty($this->photo)) {
3438 $return .=
Form::showphoto(
'memberphoto', $this, 0, 60, 0,
'photokanban photowithmargin photologintooltip',
'small', 0, 1);
3442 $return .=
'</span>';
3443 $return .=
'<div class="info-box-content">';
3444 $return .=
'<span class="info-box-ref inline-block tdoverflowmax150 valignmiddle">'.(method_exists($this,
'getNomUrl') ? $this->
getNomUrl() : $this->ref).
'</span>';
3445 if ($selected >= 0) {
3446 $return .=
'<input id="cb'.$this->id.
'" class="flat checkforselect fright" type="checkbox" name="toselect[]" value="'.$this->
id.
'"'.($selected ?
' checked="checked"' :
'').
'>';
3448 $return .=
'<br><span class="info-box-label paddingright">'.$this->getmorphylib(
'', 2).
'</span>';
3449 $return .=
'<span class="info-box-label opacitymedium">'.$this->type.
'</span>';
3451 if (method_exists($this,
'getLibStatut')) {
3452 $return .=
'<br><div class="info-box-status paddingtop">';
3453 $return .= $this->
LibStatut($this->
status, $this->need_subscription, $this->datefin, 5);
3454 $return .=
'</div>';
3456 $return .=
'</div>';
3457 $return .=
'</div>';
3458 $return .=
'</div>';
Class to manage bank accounts.
Class to manage agenda events (actions)
Class to manage members of a foundation.
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.
fetch($rowid, $ref='', $fk_soc=0, $ref_ext='', $fetch_optionals=true, $fetch_subscriptions=true)
Load member from database.
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.
__construct($db)
Constructor.
subscription($date, $amount, $accountid=0, $operation='', $label='', $num_chq='', $emetteur_nom='', $emetteur_banque='', $datesubend=0, $fk_type=null)
Insert subscription into database and eventually add links to banks, mailman, etc....
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,...
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.
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.
call_trigger($triggerName, $user)
Call trigger based on this instance.
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)
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_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_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_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.
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.
dol_now($mode='auto')
Return date for now.
getDolGlobalInt($key, $default=0)
Return a Dolibarr global constant int value.
dol_print_date($time, $format='', $tzoutput='auto', $outputlangs=null, $encodetooutput=false)
Output date in a string format according to outputlangs (or langs if not defined).
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_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.
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
global $conf
The following vars must be defined: $type2label $form $conf, $lang, The following vars may also be de...
if(preg_match('/(crypted|dolcrypt):/i', $dolibarr_main_db_pass)||!empty($dolibarr_main_db_encrypted_pass)) $conf db type
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.