/**
* Retrieve subscribers list. It overrides the abstract method defined
* in SubsRetriever Class, implementing a concrete method of the strategy
* pattern.
*
* Hint: it starts to retrieve from the $start-th subscribers and returns
* $multiplexer * $max_mails results, where $max_mails is the max number
* of mails to send every step of a sending process
*
* @access public
* @param integer $start_time The starting subscription time
* @param integer $start_id The starting subscriber identifier
* @param integer $multiplexer The limit multiplexer
* @param array $attributes array of attributes to retrieve: $attributes['attr_name'] = 0 | 1
* @return mixed the subscribers list or false if something wrong.
* @since 0.6
*/
function getSubscribersList($start_time = 0, $start_id = 0, $multiplexer = 1, $attributes = null)
{
jincimport('utility.servicelocator');
$servicelocator = ServiceLocator::getInstance();
$logger = $servicelocator->getLogger();
$logger->finer('JUserInfoRetriever: Start time ' . $start_time . ' Start id ' . $start_id . ' Multiplexer ' . $multiplexer);
jincimport('utility.parameterprovider');
$max_mails = ParameterProvider::getMaxXStep();
if (is_null($attributes) || !is_array($attributes)) {
$attributes = array();
}
$query = 'SELECT s.id as id, u.email as email, u.username as username, u.name as name, u.id as user_id, ' . 'c.name as con_name, c.con_position as con_con_position, c.address as con_address, ' . 'c.suburb as con_suburb, c.state as con_state, c.country as con_country, ' . 'c.postcode as con_postcode, c.telephone as con_telephone, c.fax as con_fax, ' . 'c.email_to as con_email_to, c.mobile as con_mobile, c.webpage as con_webpage, ' . 'UNIX_TIMESTAMP(s.datasub) as last_time, s.id as last_id, INET_NTOA(s.ipaddr) as ipaddr ';
$i = 0;
foreach ($attributes as $attr_name => $attr_value) {
$table_name = '`#__jinc_attribute_' . $attr_name . '`';
$table_alias = 'att' . $i;
$query .= ', ' . $table_alias . '.value as `attr_' . $attr_name . '`';
$i++;
}
$query .= ' FROM #__jinc_newsletter n ' . 'LEFT JOIN #__jinc_subscriber s ON n.id = s.news_id ' . 'LEFT JOIN #__users u ON s.user_id = u.id ' . 'LEFT JOIN #__contact_details c ON u.id = c.user_id ';
$i = 0;
foreach ($attributes as $attr_name => $attr_value) {
$table_name = '`#__jinc_attribute_' . $attr_name . '`';
$table_alias = 'att' . $i;
$query .= ' LEFT JOIN ' . $table_name . ' ' . $table_alias . ' ON s.id = ' . $table_alias . '.id AND n.id = ' . $table_alias . '.news_id ';
$i++;
}
$query .= 'WHERE n.id = ' . (int) $this->getNewsId() . ' ' . 'AND ( UNIX_TIMESTAMP(s.datasub) > ' . (int) $start_time . ' ' . 'OR (UNIX_TIMESTAMP(s.datasub) = ' . (int) $start_time . ' AND s.id > ' . (int) $start_id . ') ) ' . ' ' . 'ORDER BY s.datasub, s.id ' . 'LIMIT 0, ' . $max_mails * $multiplexer;
$dbo =& JFactory::getDBO();
$dbo->setQuery($query);
$logger->debug('JContactInfoRetriever: executing query: ' . $query);
return $dbo->loadAssocList();
}
/**
* Send a bulk message. It overrides the abstract method defined in Message
* class.
*
* Hint: it starts to send messages from the the $start-th subscribers of
* the message
*
* @access public
* @param int $start_time subscription time to begin to
* @param int $start_id subscriber identifier to begin to
* @return array containing next suscription time, subscriber id and number of sent messages
* @since 0.6
*/
function send($start_time = 0, $start_id = 0, $continue_on_error = false)
{
jincimport('utility.servicelocator');
$servicelocator = ServiceLocator::getInstance();
$logger = $servicelocator->getLogger();
jimport('joomla.filesystem.folder');
jimport('joomla.filesystem.file');
jincimport('utility.parameterprovider');
$mailmsg = JFactory::getMailer();
$root_uri = JURI::root();
$sleeptime = ParameterProvider::getMailTimeInterval();
$max_mails = ParameterProvider::getMaxXStep();
$max_bulk_bcc = ParameterProvider::getMailMaxBcc();
$send_mail = ParameterProvider::getSendMail();
$logger->finer('BulkMessage: Sleep time ' . $sleeptime . ' - Max mails ' . $max_mails . ' Max BCC ' . $max_bulk_bcc . ' Send mail ' . $send_mail);
$last_time = $start_time;
$last_id = $start_id;
$nmessages = 0;
$nsuccess = 0;
if ($newsletter = $this->loadNewsletter()) {
ob_start();
$logger->finer('BulkMessage: Newsletter loaded');
$msg = $this->get('body') . $newsletter->get('disclaimer');
// Newsletter info substitution in message body
$msg = preg_replace('/\\[SENDER\\]/s', $newsletter->get('sendername'), $msg);
$msg = preg_replace('/\\[SENDERMAIL\\]/s', $newsletter->get('senderaddr'), $msg);
$msg = preg_replace('/\\[NEWSLETTER\\]/s', $newsletter->get('name'), $msg);
$news_id = $newsletter->get('id');
$unsub_link = JURI::root() . 'index.php?option=com_jinc&view=newsletter&layout=unsubscription&id=' . $news_id;
$msg = preg_replace('/\\[UNSUBSCRIPTIONURL\\]/s', $unsub_link, $msg);
$msg = preg_replace('#src[ ]*=[ ]*\\"(?!https?://)(?:\\.\\./|\\./|/)?#', 'src="' . $root_uri, $msg);
$msg = preg_replace('#href[ ]*=[ ]*\\"(?!https?://)(?!mailto?:)(?!tel?:)(?:\\.\\./|\\./|/)?#', 'href="' . $root_uri, $msg);
$msg = preg_replace('#url[ ]*\\(\'(?!https?://)(?:\\.\\./|\\./|/)?#', 'url(\'' . $root_uri, $msg);
$subject = $this->get('subject');
$subject = preg_replace('/\\[SENDER\\]/s', $newsletter->get('sendername'), $subject);
$subject = preg_replace('/\\[SENDERMAIL\\]/s', $newsletter->get('senderaddr'), $subject);
$subject = preg_replace('/\\[NEWSLETTER\\]/s', $newsletter->get('name'), $subject);
// Setting message general properties
$mailmsg->ContentType = $this->get('plaintext') ? "text/plain" : "text/html";
$mailmsg->setSubject($subject);
if (strlen($newsletter->get('senderaddr')) > 0) {
$mailmsg->setSender(array($newsletter->get('senderaddr'), $newsletter->get('sendername')));
}
if (strlen($newsletter->get('replyto_addr')) > 0) {
$mailmsg->addReplyTo(array($newsletter->get('replyto_addr'), $newsletter->get('replyto_name')));
}
$path_abs_root = JPATH_ROOT;
$msg_attachment = $this->get('attachment');
$arr_attachment = $msg_attachment->toArray();
foreach ($arr_attachment as $key => $value) {
$attachment = str_replace('/', DIRECTORY_SEPARATOR, $value);
if (strlen($attachment)) {
$logger->finer('BulkMessage: adding attachment ' . $path_abs_root . DIRECTORY_SEPARATOR . $attachment);
$mailmsg->addAttachment($path_abs_root . DIRECTORY_SEPARATOR . $attachment);
}
}
$logger->finer('BulkMessage: going to add recipients');
$recipients = $newsletter->getSubscribersList($start_time, $start_id, $max_bulk_bcc);
$nrecips = count($recipients);
$logger->finer('BulkMessage: found ' . $nrecips . ' subscribers');
$success = true;
ob_end_clean();
for ($i = 0; $i < $nrecips && $success; $i += $max_bulk_bcc) {
ob_start();
$ndest = 0;
for ($j = 0; $j < $max_bulk_bcc && $j + $i < $nrecips; $j++) {
$current = $recipients[$j + $i];
$this->reported_recipients[$current['id']] = 0;
if (!$mailmsg->addBCC($current['email'])) {
$this->reported_recipients[$current['id']] = 1;
}
$ndest = $ndest + 1;
$last_time = $current['last_time'];
$last_id = $current['last_id'];
}
$mailmsg->setBody($this->emogrify($msg));
$nmessages = $nmessages + $ndest;
if ($send_mail) {
$success = $mailmsg->Send();
if ($success === true) {
$nsuccess = $nsuccess + $ndest * $success;
$logger->finer('BulkMessage: success sending mail.');
} else {
$logger->warning('BulkMessage: error sending mail.');
$this->mail_system_error = ob_get_contents();
$logger->warning('BulkMessage: error sending mail. MSG = ' . $this->mail_system_error);
for ($j = 0; $j < $max_bulk_bcc && $j + $i < $nrecips; $j++) {
$current = $recipients[$j + $i];
$this->reported_recipients[$current['id']] = 2;
}
if (!$continue_on_error) {
$success = false;
}
}
} else {
$bcc_addresses = array();
foreach ($mailmsg->bcc as $number_variable => $variable) {
array_push($bcc_addresses, $mailmsg->bcc[$number_variable][0]);
}
$logger->info('BulkMessage: simulate sending mail. BCC = ' . implode(', ', $bcc_addresses));
$logger->info('BulkMessage: simulate sending mail. Body = ' . $msg);
$nsuccess = $nsuccess + $ndest;
}
// socket_select($read = NULL, $write = NULL, $sock = array(socket_create (AF_INET, SOCK_RAW, 0)), 0, $sleeptime);
usleep($sleeptime);
$mailmsg->ClearAllRecipients();
ob_end_clean();
}
} else {
$this->setError('COM_JINC_ERR001');
return false;
}
return array('last_time' => $last_time, 'last_id' => $last_id, 'nmessages' => $nmessages, 'nsuccess' => $nsuccess);
}
/**
* Retrieve subscribers list. It overrides the abstract method defined
* in SubsRetriever Class, implementing a concrete method of the strategy
* pattern.
*
* Hint: it starts to retrieve from the $start-th subscribers and returns
* $multiplexer * $max_mails results, where $max_mails is the max number
* of mails to send every step of a sending process
*
* @access public
* @param integer $start_time The starting subscription time
* @param integer $start_id The starting subscriber identifier
* @param integer $multiplexer The limit multiplexer
* @param array $attributes array of attributes to retrieve: $attributes['attr_name'] = 0 | 1
* @return mixed the subscribers list or false if something wrong.
* @since 0.6
*/
function getSubscribersList($start_time = 0, $start_id = 0, $multiplexer = 1, $attributes = null)
{
jincimport('utility.servicelocator');
$servicelocator = ServiceLocator::getInstance();
$logger = $servicelocator->getLogger();
$logger->finer('PublicRetriever: Start time ' . $start_time . ' Start id ' . $start_id . ' Multiplexer ' . $multiplexer);
jincimport('utility.parameterprovider');
$max_mails = ParameterProvider::getMaxXStep();
if (is_null($attributes) || !is_array($attributes)) {
$attributes = array();
}
$query = 'SELECT s.id as id, s.email as email, ' . 'UNIX_TIMESTAMP(s.datasub) as last_time, s.id as last_id';
$i = 0;
foreach ($attributes as $attr_name => $attr_value) {
$table_name = '`#__jinc_attribute_' . $attr_name . '`';
$table_alias = 'att' . $i;
$query .= ', ' . $table_alias . '.value as `attr_' . $attr_name . '`';
$i++;
}
$query .= ' FROM #__jinc_newsletter n ' . 'LEFT JOIN #__jinc_subscriber s ON s.news_id = n.id ';
$i = 0;
foreach ($attributes as $attr_name => $attr_value) {
$table_name = '`#__jinc_attribute_' . $attr_name . '`';
$table_alias = 'att' . $i;
$query .= ' LEFT JOIN ' . $table_name . ' ' . $table_alias . ' ON s.id = ' . $table_alias . '.id AND n.id = ' . $table_alias . '.news_id ';
$i++;
}
$query .= 'WHERE n.id = ' . (int) $this->getNewsId() . ' ' . 'AND (s.random = \'\' OR s.random IS NULL) ' . 'AND ( UNIX_TIMESTAMP(s.datasub) > ' . (int) $start_time . ' ' . 'OR (UNIX_TIMESTAMP(s.datasub) = ' . (int) $start_time . ' AND s.id > ' . (int) $start_id . ') ) ' . ' ' . 'ORDER BY s.datasub, s.id ' . 'LIMIT 0, ' . $max_mails * $multiplexer;
$dbo = JFactory::getDBO();
$dbo->setQuery($query);
$logger->debug('PublicRetriever: executing query: ' . $query);
return $dbo->loadAssocList();
}
