product_notification.php
来自「全新且完善的强大网上商店系统」· PHP 代码 · 共 205 行
PHP
205 行
<?php
/*
[SOOBIC!] admin/modules/newsletters/products_notification.php
Version: 1.5
Author: Soolan (soolan@qq.com)
Copyright: soolan (www.soobic.com)
Last Modified: 2005/4/11 10:00
*/
class product_notification {
var $show_choose_audience, $title, $content;
function product_notification($title, $content) {
$this->show_choose_audience = true;
$this->title = $title;
$this->content = $content;
}
function choose_audience() {
global $HTTP_GET_VARS, $languages_id,$db, $table_products, $table_products_description;
$products_array = array();
$products_query = $db->query("select pd.products_id, pd.products_name from $table_products p, $table_products_description pd where pd.language_id = '" . $languages_id . "' and pd.products_id = p.products_id and p.products_status = '1' order by pd.products_name");
while ($products = $db->fetch_array($products_query)) {
$products_array[] = array('id' => $products['products_id'],
'text' => $products['products_name']);
}
$choose_audience_string = '<script language="javascript"><!--
function mover(move) {
if (move == \'remove\') {
for (x=0; x<(document.notifications.products.length); x++) {
if (document.notifications.products.options[x].selected) {
with(document.notifications.elements[\'chosen[]\']) {
options[options.length] = new Option(document.notifications.products.options[x].text,document.notifications.products.options[x].value);
}
document.notifications.products.options[x] = null;
x = -1;
}
}
}
if (move == \'add\') {
for (x=0; x<(document.notifications.elements[\'chosen[]\'].length); x++) {
if (document.notifications.elements[\'chosen[]\'].options[x].selected) {
with(document.notifications.products) {
options[options.length] = new Option(document.notifications.elements[\'chosen[]\'].options[x].text,document.notifications.elements[\'chosen[]\'].options[x].value);
}
document.notifications.elements[\'chosen[]\'].options[x] = null;
x = -1;
}
}
}
return true;
}
function selectAll(FormName, SelectBox) {
temp = "document." + FormName + ".elements[\'" + SelectBox + "\']";
Source = eval(temp);
for (x=0; x<(Source.length); x++) {
Source.options[x].selected = "true";
}
if (x<1) {
alert(\'' . JS_PLEASE_SELECT_PRODUCTS . '\');
return false;
} else {
return true;
}
}
//--></script>';
$global_button = '<script language="javascript"><!--' . "\n" .
'document.write(\'<input type="button" value="' . BUTTON_GLOBAL . '" style="width: 8em;" onclick="document.location=\\\'' . tep_href_link('admincp.php', 'act=newsletters&page=' . $HTTP_GET_VARS['page'] . '&nID=' . $HTTP_GET_VARS['nID'] . '&type=confirm&global=true') . '\\\'">\');' . "\n" .
'//--></script><noscript><a href="' . tep_href_link('admincp.php', 'act=newsletters&page=' . $HTTP_GET_VARS['page'] . '&nID=' . $HTTP_GET_VARS['nID'] . '&action=confirm&global=true') . '">[ ' . BUTTON_GLOBAL . ' ]</a></noscript>';
$cancel_button = '<script language="javascript"><!--' . "\n" .
'document.write(\'<input type="button" value="' . BUTTON_CANCEL . '" style="width: 8em;" onclick="document.location=\\\'' . tep_href_link('admincp.php', 'act=newsletters&page=' . $HTTP_GET_VARS['page'] . '&nID=' . $HTTP_GET_VARS['nID']) . '\\\'">\');' . "\n" .
'//--></script><noscript><a href="' . tep_href_link('admincp.php', 'act=newsletters&page=' . $HTTP_GET_VARS['page'] . '&nID=' . $HTTP_GET_VARS['nID']) . '">[ ' . BUTTON_CANCEL . ' ]</a></noscript>';
$choose_audience_string .= '<form name="notifications" action="' . tep_href_link('admincp.php', 'act=newsletters&page=' . $HTTP_GET_VARS['page'] . '&nID=' . $HTTP_GET_VARS['nID'] . '&type=confirm') . '" method="post" onSubmit="return selectAll(\'notifications\', \'chosen[]\')"><table border="0" width="100%" cellspacing="0" cellpadding="2">' . "\n" .
' <tr>' . "\n" .
' <td align="center" class="main"><b>' . TEXT_PRODUCTS . '</b><br>' . tep_draw_pull_down_menu('products', $products_array, '', 'size="20" style="width: 20em;" multiple') . '</td>' . "\n" .
' <td align="center" class="main"> <br>' . $global_button . '<br><br><br><input type="button" value="' . BUTTON_SELECT . '" style="width: 8em;" onClick="mover(\'remove\');"><br><br><input type="button" value="' . BUTTON_UNSELECT . '" style="width: 8em;" onClick="mover(\'add\');"><br><br><br><input type="submit" value="' . BUTTON_SUBMIT . '" style="width: 8em;"><br><br>' . $cancel_button . '</td>' . "\n" .
' <td align="center" class="main"><b>' . TEXT_SELECTED_PRODUCTS . '</b><br>' . tep_draw_pull_down_menu('chosen[]', array(), '', 'size="20" style="width: 20em;" multiple') . '</td>' . "\n" .
' </tr>' . "\n" .
'</table></form>';
return $choose_audience_string;
}
function confirm() {
global $HTTP_GET_VARS, $HTTP_POST_VARS, $table_products_notifications, $table_customers, $db;
$audience = array();
if (isset($HTTP_GET_VARS['global']) && ($HTTP_GET_VARS['global'] == 'true')) {
$products_query = $db->query("select distinct customers_id from $table_products_notifications");
while ($products = $db->fetch_array($products_query)) {
$audience[$products['customers_id']] = '1';
}
$customers_query = $db->query("select customers_id from $table_customers where global_product_notifications = '1'");
while ($customers = $db->fetch_array($customers_query)) {
$audience[$customers['customers_id']] = '1';
}
} else {
$chosen = $HTTP_POST_VARS['chosen'];
$ids = implode(',', $chosen);
$products_query = $db->query("select distinct customers_id from $table_products_notifications where products_id in (" . $ids . ")");
while ($products = $db->fetch_array($products_query)) {
$audience[$products['customers_id']] = '1';
}
$customers_query = $db->query("select customers_id from $table_customers where global_product_notifications = '1'");
while ($customers = $db->fetch_array($customers_query)) {
$audience[$customers['customers_id']] = '1';
}
}
$confirm_string = '<table border="0" cellspacing="0" cellpadding="2">' . "\n" .
' <tr>' . "\n" .
' <td><font color="#ff0000"><b>' . sprintf(TEXT_COUNT_CUSTOMERS, sizeof($audience)) . '</b></font></td>' . "\n" .
' </tr>' . "\n" .
' <tr>' . "\n" .
' <td><b>' . $this->title . '</b></td>' . "\n" .
' </tr>' . "\n" .
' <tr>' . "\n" .
' <td><tt>' . nl2br($this->content) . '</tt></td>' . "\n" .
' </tr>' . "\n" .
' <tr>' . tep_draw_form('confirm', 'admincp.php', 'act=newsletters&page=' . $HTTP_GET_VARS['page'] . '&nID=' . $HTTP_GET_VARS['nID'] . '&action=confirm_send') . "\n" .
' <td align="right">';
if (sizeof($audience) > 0) {
if (isset($HTTP_GET_VARS['global']) && ($HTTP_GET_VARS['global'] == 'true')) {
$confirm_string .= tep_draw_hidden_field('global', 'true');
} else {
for ($i = 0, $n = sizeof($chosen); $i < $n; $i++) {
$confirm_string .= tep_draw_hidden_field('chosen[]', $chosen[$i]);
}
}
$confirm_string .= tep_image_submit('button_send.gif', IMAGE_SEND) . ' ';
}
$confirm_string .= '<a href="' . tep_href_link('admincp.php', 'act=newsletters&page=' . $HTTP_GET_VARS['page'] . '&nID=' . $HTTP_GET_VARS['nID'] . '&type=send') . '">' . tep_image_button('button_back.gif', IMAGE_BACK) . '</a> <a href="' . tep_href_link('admincp.php', 'act=newsletters&page=' . $HTTP_GET_VARS['page'] . '&nID=' . $HTTP_GET_VARS['nID']) . '">' . tep_image_button('button_cancel.gif', IMAGE_CANCEL) . '</a></td>' . "\n" .
' </tr>' . "\n" .
'</table>';
return $confirm_string;
}
function send($newsletter_id) {
global $HTTP_POST_VARS, $db, $table_customers, $table_customers_info, $table_products_notifications,$table_newsletters;
$audience = array();
if (isset($HTTP_POST_VARS['global']) && ($HTTP_POST_VARS['global'] == 'true')) {
$products_query = $db->query("select distinct pn.customers_id, c.customers_firstname, c.customers_email_address from $table_customers c, $table_products_notifications pn where c.customers_id = pn.customers_id");
while ($products = $db->fetch_array($products_query)) {
$audience[$products['customers_id']] = array('firstname' => $products['customers_firstname'],
'email_address' => $products['customers_email_address']);
}
$customers_query = $db->query("select customers_id, customers_firstname, customers_email_address from $table_customers where global_product_notifications = '1'");
while ($customers = $db->fetch_array($customers_query)) {
$audience[$customers['customers_id']] = array('firstname' => $customers['customers_firstname'],
'email_address' => $customers['customers_email_address']);
}
} else {
$chosen = $HTTP_POST_VARS['chosen'];
$ids = implode(',', $chosen);
$products_query = $db->query("select distinct pn.customers_id, c.customers_firstname, 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 = $db->fetch_array($products_query)) {
$audience[$products['customers_id']] = array('firstname' => $products['customers_firstname'],
'email_address' => $products['customers_email_address']);
}
$customers_query = $db->query("select customers_id, customers_firstname, customers_email_address from $table_customers where global_product_notifications = '1'");
while ($customers = $db->fetch_array($customers_query)) {
$audience[$customers['customers_id']] = array('firstname' => $customers['customers_firstname'],
'email_address' => $customers['customers_email_address']);
}
}
require($soobic.'includes/classes/mime.php');
require($soobic.'includes/classes/email.php');
$mimemessage = new email(array('X-Mailer: Soobic! bulk mailer'));
$mimemessage->add_text($this->content);
$mimemessage->build_message();
reset($audience);
while (list($key, $value) = each ($audience)) {
$mimemessage->send($value['firstname'], $value['email_address'], '', EMAIL_FROM, $this->title);
}
$newsletter_id = tep_db_prepare_input($newsletter_id);
$db->query("update $table_newsletters set date_sent = now(), status = '1' where newsletters_id = '" .$newsletter_id. "'");
}
}
?>
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?