' . "\n" .
' ' . "\n" .
' | ' . sprintf(TEXT_COUNT_CUSTOMERS, sizeof($audience)) . ' | ' . "\n" .
'
' . "\n" .
' ' . "\n" .
' | ' . zen_draw_separator('pixel_trans.gif', '1', '10') . ' | ' . "\n" .
'
' . "\n" .
' ' . "\n" .
' | ' . $this->title . ' | ' . "\n" .
'
' . "\n" .
' ' . "\n" .
' ' . zen_draw_separator('pixel_trans.gif', '1', '10') . '
| ' . "\n" .
'
' . "\n" .
' ' . "\n" .
' | ' . nl2br($this->content_html) . ' | ' . "\n" .
'
' . "\n" .
' ' . "\n" .
'
' . zen_draw_separator('pixel_trans.gif', '1', '10') . ' | ' . "\n" .
'
' . "\n" .
' ' . "\n" .
' ' . nl2br($this->content) . '
| ' . "\n" .
'
' . "\n" .
' ' . "\n" .
' | ' . zen_draw_separator('pixel_trans.gif', '1', '10') . ' | ' . "\n" .
'
' . "\n" .
' ' . zen_draw_form('confirm', FILENAME_NEWSLETTERS, 'page=' . $_GET['page'] . '&nID=' . $_GET['nID'] . '&action=confirm_send') . "\n" .
' | ';
if (sizeof($audience) > 0) {
if (isset($_GET['global']) && ($_GET['global'] == 'true')) {
$confirm_string .= zen_draw_hidden_field('global', 'true');
} else {
for ($i = 0, $n = sizeof($chosen); $i < $n; $i++) {
$confirm_string .= zen_draw_hidden_field('chosen[]', $chosen[$i]);
}
}
$confirm_string .= zen_image_submit('button_send.gif', IMAGE_SEND) . ' ';
}
$confirm_string .= '' . zen_image_button('button_back.gif', IMAGE_BACK) . ' ' . zen_image_button('button_cancel.gif', IMAGE_CANCEL) . ' | ' . "\n" .
'
' . "\n" .
'
';
return $confirm_string;
}
function send($newsletter_id) {
global $_POST, $db;
$audience = array();
if (isset($_POST['global']) && ($_POST['global'] == 'true')) {
$products = $db->Execute("select distinct pn.customers_id, c.customers_firstname,
c.customers_lastname, c.customers_email_address
from " . TABLE_CUSTOMERS . " c, " . TABLE_PRODUCTS_NOTIFICATIONS . " pn
where c.customers_id = pn.customers_id");
while (!$products->EOF) {
$audience[$products->fields['customers_id']] = array('firstname' => $products->fields['customers_firstname'],
'lastname' => $products->fields['customers_lastname'],
'email_address' => $products->fields['customers_email_address']);
$products->MoveNext();
}
$customers = $db->Execute("select c.customers_id, c.customers_firstname, c.customers_lastname,
c.customers_email_address
from " . TABLE_CUSTOMERS . " c, " . TABLE_CUSTOMERS_INFO . " ci
where c.customers_id = ci.customers_info_id
and ci.global_product_notifications = '1'");
while (!$customers->EOF) {
$audience[$customers->fields['customers_id']] = array('firstname' => $customers->fields['customers_firstname'],
'lastname' => $customers->fields['customers_lastname'],
'email_address' => $customers->fields['customers_email_address']);
$customers->MoveNext();
}
} else { //not global==true; instead, process all selected products
$chosen = $_POST['chosen'];
$ids = zen_db_input(implode(',', $chosen));
$products = $db->Execute("select distinct pn.customers_id, c.customers_firstname,
c.customers_lastname, c.customers_email_address
from " . TABLE_CUSTOMERS . " c, " . TABLE_PRODUCTS_NOTIFICATIONS . " pn
where c.customers_id = pn.customers_id
and pn.products_id in (" . $ids . ")");
while (!$products->EOF) {
$audience[$products->fields['customers_id']] = array('firstname' => $products->fields['customers_firstname'],
'lastname' => $products->fields['customers_lastname'],
'email_address' => $products->fields['customers_email_address']);
$products->MoveNext();
}
$customers = $db->Execute("select c.customers_id, c.customers_firstname, c.customers_lastname,
c.customers_email_address
from " . TABLE_CUSTOMERS . " c, " . TABLE_CUSTOMERS_INFO . " ci
where c.customers_id = ci.customers_info_id
and ci.global_product_notifications = '1'");
while (!$customers->EOF) {
$audience[$customers->fields['customers_id']] = array('firstname' => $customers->fields['customers_firstname'],
'lastname' => $customers->fields['customers_lastname'],
'email_address' => $customers->fields['customers_email_address']);
$customers->MoveNext();
}
}
//send emails
reset($audience);
$i=0;
while (list($key, $value) = each ($audience)) {
$i++;
$html_msg['EMAIL_FIRST_NAME'] = $value['firstname'];
$html_msg['EMAIL_LAST_NAME'] = $value['lastname'];
$html_msg['EMAIL_MESSAGE_HTML'] = $this->content_html;
zen_mail($value['firstname'] . ' ' . $value['lastname'], $value['email_address'], $this->title, $this->content, STORE_NAME, EMAIL_FROM, $html_msg, 'product_notification','');
echo zen_image(DIR_WS_ICONS . 'tick.gif', $value['email_address']);
//force output to the screen to show status indicator each time a message is sent...
if (function_exists('ob_flush')) @ob_flush();
@flush();
}
$newsletter_id = zen_db_prepare_input($newsletter_id);
$db->Execute("update " . TABLE_NEWSLETTERS . "
set date_sent = now(), status = '1'
where newsletters_id = '" . zen_db_input($newsletter_id) . "'");
return $i; //return number of records processed whether successful or not
}
}