21include_once DOL_DOCUMENT_ROOT.
'/core/modules/mailings/modules_mailings.php';
30 public $name =
'AttendeesOfOrganizedEvent';
31 public $desc =
"Attendees of an organized event";
33 public $require_admin = 0;
35 public $require_module = array();
40 public $picto =
'conferenceorbooth';
42 public $enabled =
'isModEnabled("eventorganization")';
53 $langs->load(
'companies');
74 $sql =
"SELECT p.ref, p.entity, e.rowid as id, e.fk_project, e.email as email, e.email_company as company_name, e.firstname as firstname, e.lastname as lastname,";
75 $sql .=
" 'eventorganizationattendee' as source";
76 $sql .=
" FROM ".MAIN_DB_PREFIX.
"eventorganization_conferenceorboothattendee as e,";
77 $sql .=
" ".MAIN_DB_PREFIX.
"projet as p";
78 $sql .=
" WHERE e.email <> ''";
79 $sql .=
" AND e.fk_project = p.rowid";
80 $sql .=
" AND p.entity IN (".getEntity(
'project').
")";
81 $sql .=
" AND e.email NOT IN (SELECT email FROM ".MAIN_DB_PREFIX.
"mailing_cibles WHERE fk_mailing=".((int) $mailing_id).
")";
82 if (
GETPOSTINT(
'filter_eventorganization') > 0) {
83 $sql .=
" AND e.fk_project = ".(GETPOSTINT(
'filter_eventorganization'));
85 if (empty($this->evenunsubscribe)) {
86 $sql .=
" AND NOT EXISTS (SELECT rowid FROM ".MAIN_DB_PREFIX.
"mailing_unsubscribe as mu WHERE mu.email = e.email and mu.entity = ".((int) $conf->entity).
")";
88 $sql .=
" ORDER BY e.email";
91 $result = $this->db->query($sql);
93 $num = $this->db->num_rows($result);
97 dol_syslog(get_class($this).
"::add_to_target mailing ".$num.
" targets found");
101 $obj = $this->db->fetch_object($result);
102 if ($old != $obj->email) {
103 $otherTxt = ($obj->ref ? $langs->transnoentities(
"Project").
'='.$obj->ref :
'');
104 if (strlen($addDescription) > 0 && strlen($otherTxt) > 0) {
107 $otherTxt .= $addDescription;
109 'email' => $obj->email,
110 'fk_project' => $obj->fk_project,
111 'lastname' => $obj->lastname,
112 'firstname' => $obj->firstname,
113 'other' => $otherTxt,
114 'source_url' => $this->url($obj->id, $obj->source),
115 'source_id' => $obj->id,
116 'source_type' => $obj->source
126 $this->error = $this->db->error();
130 return parent::addTargetsToDatabase($mailing_id, $cibles);
164 $sql =
"SELECT COUNT(DISTINCT(e.email)) as nb";
165 $sql .=
" FROM ".MAIN_DB_PREFIX.
"eventorganization_conferenceorboothattendee as e, ";
166 $sql .=
" ".MAIN_DB_PREFIX.
"projet as p";
167 $sql .=
" WHERE e.email <> ''";
168 $sql .=
" AND e.fk_project = p.rowid";
169 $sql .=
" AND p.entity IN (".getEntity(
'project').
")";
170 if (empty($this->evenunsubscribe)) {
171 $sql .=
" AND NOT EXISTS (SELECT rowid FROM ".MAIN_DB_PREFIX.
"mailing_unsubscribe as mu WHERE mu.email = e.email and mu.entity = ".((int) $conf->entity).
")";
177 return parent::getNbOfRecipients($sql);
188 global $conf, $langs;
190 $langs->load(
"companies");
192 include_once DOL_DOCUMENT_ROOT.
'/core/class/html.formprojet.class.php';
195 $s =
img_picto($langs->trans(
"OrganizedEvent"),
'project',
'class="pictofixedwidth"');
196 $s .= $formproject->select_projects(-1, 0,
"filter_eventorganization", 0, 0, $langs->trans(
"OrganizedEvent"), 1, 0, 0, 0,
'', 1, 0,
'',
'',
'usage_organize_event=1');
209 public function url($id, $sourcetype =
'thirdparty')
211 if ($sourcetype ==
'project') {
212 return '<a href="'.DOL_URL_ROOT.
'/eventorganization/conferenceorboothattendee_card.php?id='.((int) $id).
'">'.
img_object(
'',
"eventorganization").
'</a>';
Parent class of emailing target selectors modules.
Class to manage a list of personalised recipients for mailing feature.
add_to_target($mailing_id)
This is the main function that returns the array of emails.
__construct($db)
Constructor.
getSqlArrayForStats()
On the main mailing area, there is a box with statistics.
getNbOfRecipients($sql='')
Return here number of distinct emails returned by your selector.
formFilter()
This is to add a form filter to provide variant of selector If used, the HTML select must be called "...
url($id, $sourcetype='thirdparty')
Can include an URL link on each record provided by selector shown on target page.
img_object($titlealt, $picto, $moreatt='', $pictoisfullpath=0, $srconly=0, $notitle=0)
Show a picto called object_picto (generic function)
img_picto($titlealt, $picto, $moreatt='', $pictoisfullpath=0, $srconly=0, $notitle=0, $alt='', $morecss='', $marginleftonlyshort=2)
Show picto whatever it's its name (generic function)
GETPOSTINT($paramname, $method=0)
Return the value of a $_GET or $_POST supervariable, converted into integer.
dol_syslog($message, $level=LOG_INFO, $ident=0, $suffixinfilename='', $restricttologhandler='', $logcontext=null)
Write log message into outputs.