/mnt/web601/b3/14/57451114/htdocs/httpdocs/admin/module_newsletter.php
<?php
/* --------------------------------------------------------------
module_newsletter.php 2023-03-29
Gambio GmbH
http://www.gambio.de
Copyright (c) 2023 Gambio GmbH
Released under the GNU General Public License (Version 2)
[http://www.gnu.org/licenses/gpl-2.0.html]
IMPORTANT! THIS FILE IS DEPRECATED AND WILL BE REPLACED IN THE FUTURE.
MODIFY IT ONLY FOR FIXES. DO NOT APPEND IT WITH NEW FEATURES, USE THE
NEW GX-ENGINE LIBRARIES INSTEAD.
--------------------------------------------------------------
based on:
(c) 2000-2001 The Exchange Project (earlier name of osCommerce)
(c) 2002-2003 osCommercecoding standards www.oscommerce.com
(c) 2003 nextcommerce (templates_boxes.php,v 1.14 2003/08/18); www.nextcommerce.org
(c) 2003 XT-Commerce - community made shopping http://www.xt-commerce.com ($Id: module_newsletter.php 1142 2005-08-11 08:19:55Z matthias $)
Released under the GNU General Public License
--------------------------------------------------------------*/
require('includes/application_top.php');
require_once(DIR_FS_INC . 'xtc_php_mail.inc.php');
$mainTableClass = (isset($_GET['action'])
&& ($_GET['action'] === 'new'
|| $_GET['action'] === 'edit')) ? ' newsletter-edit' : '';
$result = xtc_db_query("SELECT `value` FROM `gx_configurations` WHERE `key` = 'configuration/EMAIL_MAX_LIMIT'");
$qMaxLimit = xtc_db_fetch_array($result);
switch ($_GET['action'] ?? null) { // actions for datahandling
case 'save': // save newsletter
if ($_SESSION['coo_page_token']->is_valid($_POST['page_token'])) {
$id = xtc_db_prepare_input((int)($_POST['ID']??null));
$status_all = xtc_db_prepare_input($_POST['status_all']??null);
if (!isset($newsletter_title) || $newsletter_title == '') {
$newsletter_title = 'no title';
}
$customers_status = xtc_get_customers_statuses();
// BOF GM_MOD:
sort($customers_status);
$rzp = '';
for ($i = 0, $n = sizeof($customers_status); $i < $n; $i++) {
if (xtc_db_prepare_input((($_POST['status']??[])[$i]??'')) == 'yes') {
if ($rzp != '') {
$rzp .= ',';
}
$rzp .= $customers_status[$i]['id'];
}
}
if (xtc_db_prepare_input($_POST['status_all']??'') == 'yes') {
$rzp .= ',all';
}
$error = false; // reset error flag
if ($error == false) {
$sql_data_array = [
'title' => xtc_db_prepare_input(strip_tags($_POST['title'])),
'status' => '0',
'bc' => $rzp,
'cc' => xtc_db_prepare_input(strip_tags($_POST['cc'])),
'date' => 'now()',
'body' => xtc_db_prepare_input($_POST['newsletter_body'])
];
if (!empty($id)) {
xtc_db_perform(TABLE_MODULE_NEWSLETTER, $sql_data_array, 'update', "newsletter_id = '" . $id . "'");
// create temp table
xtc_db_query("DROP TABLE IF EXISTS module_newsletter_temp_" . $id);
xtc_db_query("CREATE TABLE module_newsletter_temp_" . $id . "
(
id int(11) NOT NULL auto_increment,
customers_id int(11) NOT NULL default '0',
customers_status int(11) NOT NULL default '0',
customers_firstname varchar(64) NOT NULL default '',
customers_lastname varchar(64) NOT NULL default '',
customers_email_address text NOT NULL,
mail_key varchar(32) NOT NULL,
date datetime NOT NULL default '1000-01-01 00:00:00',
comment varchar(64) NOT NULL default '',
PRIMARY KEY (id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8");
} else {
xtc_db_perform(TABLE_MODULE_NEWSLETTER, $sql_data_array);
// create temp table
$id = xtc_db_insert_id();
xtc_db_query("DROP TABLE IF EXISTS module_newsletter_temp_" . $id);
xtc_db_query("CREATE TABLE module_newsletter_temp_" . $id . "
(
id int(11) NOT NULL auto_increment,
customers_id int(11) NOT NULL default '0',
customers_status int(11) NOT NULL default '0',
customers_firstname varchar(64) NOT NULL default '',
customers_lastname varchar(64) NOT NULL default '',
customers_email_address text NOT NULL,
mail_key varchar(32) NOT NULL,
date datetime NOT NULL default '1000-01-01 00:00:00',
comment varchar(64) NOT NULL default '',
PRIMARY KEY (id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8");
}
// filling temp table with data!
$flag = '';
if (!strpos($rzp, 'all')) {
$flag = 'true';
}
$rzp = str_replace(',all', '', $rzp);
$groups = explode(',', $rzp);
$sql_data_array = '';
for ($i = 0, $n = sizeof($groups); $i < $n; $i++) {
// check if customer wants newsletter
if (xtc_db_prepare_input($_POST['status_all'] ?? null) == 'yes') {
$customers_query = xtc_db_query("SELECT
c.customers_id,
c.customers_firstname,
c.customers_lastname,
c.customers_email_address,
n.mail_key
FROM " . TABLE_CUSTOMERS . " c
LEFT JOIN " . TABLE_NEWSLETTER_RECIPIENTS . " AS n USING(customers_id)
WHERE
c.customers_status = '" . $groups[$i] . "'");
} else {
$customers_query = xtc_db_query("SELECT
customers_email_address,
customers_id,
customers_firstname,
customers_lastname,
mail_key
FROM " . TABLE_NEWSLETTER_RECIPIENTS . "
WHERE
customers_status='" . $groups[$i] . "' and
mail_status='1'");
}
while ($customers_data = xtc_db_fetch_array($customers_query)) {
$sql_data_array = [
'customers_id' => $customers_data['customers_id'],
'customers_status' => $groups[$i],
'customers_firstname' => $customers_data['customers_firstname'],
'customers_lastname' => $customers_data['customers_lastname'],
'customers_email_address' => $customers_data['customers_email_address'],
'mail_key' => $customers_data['mail_key'],
'date' => 'now()'
];
xtc_db_perform('module_newsletter_temp_' . $id, $sql_data_array);
}
if ($groups[$i] == 1 && xtc_db_prepare_input($_POST['status_all'] ?? null) == 'yes') {
$customers_query2 = xtc_db_query("SELECT
customers_email_address,
customers_firstname,
customers_lastname,
mail_key
FROM " . TABLE_NEWSLETTER_RECIPIENTS . "
WHERE
customers_id='0' and
mail_status='1'");
}
}
// BOF GM_MOD:
if (isset($customers_query2)) {
while ($customers_data = xtc_db_fetch_array($customers_query2)) {
$sql_data_array = [
'customers_id' => 0,
'customers_status' => 1,
'customers_firstname' => $customers_data['customers_firstname'],
'customers_lastname' => $customers_data['customers_lastname'],
'customers_email_address' => $customers_data['customers_email_address'],
'mail_key' => $customers_data['mail_key'],
'date' => 'now()'
];
xtc_db_perform('module_newsletter_temp_' . $id, $sql_data_array);
}
}
// EOF GM_MOD
xtc_redirect(xtc_href_link(FILENAME_MODULE_NEWSLETTER));
}
}
break;
case 'delete':
if ($_SESSION['coo_page_token']->is_valid($_GET['page_token'])) {
xtc_db_query("DELETE FROM " . TABLE_MODULE_NEWSLETTER . " WHERE newsletter_id='" . (int)$_GET['ID']
. "'");
xtc_redirect(xtc_href_link(FILENAME_MODULE_NEWSLETTER));
}
break;
case 'send':
if ($_SESSION['coo_page_token']->is_valid($_GET['page_token'] ?? null)) {
// max email package -> should be in admin area!
$package_size = $qMaxLimit['value'];
xtc_redirect(xtc_href_link(FILENAME_MODULE_NEWSLETTER,
'send=0,' . $package_size . '&ID=' . (int)$_GET['ID']));
}
}
// action for sending mails!
if (!empty($_GET['send'])) {
$limits = explode(',', $_GET['send']);
$limit_low = $limits['0'];
$limit_up = $limits['1'];
$limit_query = xtc_db_query("SELECT count(*) as count
FROM module_newsletter_temp_" . (int)$_GET['ID'] . "
");
$limit_data = xtc_db_fetch_array($limit_query);
// select emailrange from db
$email_query = xtc_db_query("SELECT
customers_firstname,
customers_lastname,
customers_email_address,
mail_key ,
id
FROM module_newsletter_temp_" . (int)$_GET['ID'] . "
LIMIT " . $limit_low . "," . $limit_up);
$email_data = [];
while ($email_query_data = xtc_db_fetch_array($email_query)) {
$email_data[] = [
'id' => $email_query_data['id'],
'firstname' => $email_query_data['customers_firstname'],
'lastname' => $email_query_data['customers_lastname'],
'email' => $email_query_data['customers_email_address'],
'key' => $email_query_data['mail_key']
];
}
$package_size = $qMaxLimit['value'];
$break = '0';
if ((int)$limit_low + (int)$limit_up > (int)$limit_data['count']) {
// if ((int)$limit_data['count']<$limit_up) {
// $limit_up=$limit_data['count'];
$break = '1';
}
$limit_up = (int)$limit_up;
$limit_low = (int)$limit_low;
$max_runtime = count($email_data);
$newsletters_query = xtc_db_query("SELECT
title,
body,
bc,
cc
FROM " . TABLE_MODULE_NEWSLETTER . "
WHERE newsletter_id='" . (int)$_GET['ID'] . "'");
$newsletters_data = xtc_db_fetch_array($newsletters_query);
// BOF GM_MOD
if (!empty($newsletters_data['cc']) && $limit_low == '0') {
$t_gm_cc_mails = [$newsletters_data['cc']];
if (strpos($newsletters_data['cc'], ',') !== false) {
$t_gm_cc_mails = explode(',', $newsletters_data['cc']);
} elseif (strpos($newsletters_data['cc'], ';') !== false) {
$t_gm_cc_mails = explode(';', $newsletters_data['cc']);
}
for ($i = 0; $i < count($t_gm_cc_mails); $i++) {
xtc_php_mail(EMAIL_SUPPORT_ADDRESS,
EMAIL_SUPPORT_NAME,
trim($t_gm_cc_mails[$i]),
trim($t_gm_cc_mails[$i]),
'',
EMAIL_SUPPORT_REPLY_ADDRESS,
EMAIL_SUPPORT_REPLY_ADDRESS_NAME,
'',
'',
$newsletters_data['title'],
$newsletters_data['body'] . $link2,
$newsletters_data['body'] . $link1);
}
}
// EOF GM_MOD
for ($i = 1; $i <= $max_runtime; $i++) {
// mail
$link1 = '';
$link2 = '';
if (!empty($email_data[$i - 1]['key'])) {
$link1 = chr(13) . chr(10) . chr(13) . chr(10) . TEXT_NEWSLETTER_REMOVE . chr(13) . chr(10) . chr(13)
. chr(10) . HTTP_CATALOG_SERVER . DIR_WS_CATALOG . FILENAME_CATALOG_NEWSLETTER
. '?action=remove&email=' . urlencode($email_data[$i - 1]['email']) . '&key=' . $email_data[$i
- 1]['key'];
$link2 = '<br /><br /><hr>' . TEXT_NEWSLETTER_REMOVE . '<br /><a href="' . HTTP_CATALOG_SERVER
. DIR_WS_CATALOG . FILENAME_CATALOG_NEWSLETTER . '?action=remove&email=' . urlencode($email_data[$i
- 1]['email'])
. '&key=' . $email_data[$i - 1]['key'] . '">' . TEXT_REMOVE_LINK . '</a>';
}
if (!empty($email_data[$i - 1]['email'])) {
xtc_php_mail(EMAIL_SUPPORT_ADDRESS,
EMAIL_SUPPORT_NAME,
$email_data[$i - 1]['email'],
$email_data[$i - 1]['lastname'] . ' ' . $email_data[$i - 1]['firstname'],
'',
EMAIL_SUPPORT_REPLY_ADDRESS,
EMAIL_SUPPORT_REPLY_ADDRESS_NAME,
'',
'',
$newsletters_data['title'],
$newsletters_data['body'] . $link2,
$newsletters_data['body'] . $link1);
xtc_db_query("UPDATE module_newsletter_temp_" . (int)$_GET['ID'] . " SET comment='send' WHERE id='"
. $email_data[$i - 1]['id'] . "'");
}
if (!isset($email_data[$i])) {
break;
}
}
if ($break == '1') {
// finished
$limit1_query = xtc_db_query("SELECT count(*) as count
FROM module_newsletter_temp_" . (int)$_GET['ID'] . "
WHERE comment='send'");
$limit1_data = xtc_db_fetch_array($limit1_query);
if ($limit1_data['count'] - $limit_data['count'] <= 0) {
xtc_db_query("UPDATE " . TABLE_MODULE_NEWSLETTER . " SET status='1' WHERE newsletter_id='"
. (int)$_GET['ID'] . "'");
xtc_redirect(xtc_href_link(FILENAME_MODULE_NEWSLETTER));
} else {
echo '<b>' . $limit1_data['count'] . '<b> emails send<br />';
echo '<b>' . ($limit1_data['count'] - $limit_data['count']) . '<b> emails left';
}
} else {
//$limit_low=$limit_up+1;
//$limit_up=$limit_low+(int)$package_size;
$limit_low = $limit_low + $limit_up;
xtc_redirect(xtc_href_link(FILENAME_MODULE_NEWSLETTER,
'send=' . $limit_low . ',' . $limit_up . '&ID=' . (int)$_GET['ID']));
}
}
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html <?php echo HTML_PARAMS; ?>>
<head>
<meta http-equiv="x-ua-compatible" content="IE=edge">
<meta http-equiv="Content-Type" content="text/html; charset=<?php echo $_SESSION['language_charset']; ?>">
<?php
if (preg_match('/MSIE [\d]{2}\./i', $_SERVER['HTTP_USER_AGENT'])) {
?>
<meta http-equiv="X-UA-Compatible" content="IE=EmulateIE9"/>
<?php
}
?>
<title><?php echo TITLE; ?></title>
<link rel="stylesheet" type="text/css" href="html/assets/styles/legacy/stylesheet.css">
<script type="text/javascript">
<!--
function gm_show_newsletter_recipients(box_id) {
if ($('#' + box_id).css('display') == 'block') {
$('#' + box_id).css({"display": "none"});
} else {
$('#' + box_id).css({"display": "block"});
}
return;
}
//-->
</script>
</head>
<body marginwidth="0" marginheight="0" topmargin="0" bottommargin="0" leftmargin="0" rightmargin="0" bgcolor="#FFFFFF">
<!-- header //-->
<?php require(DIR_WS_INCLUDES . 'header.php'); ?>
<!-- header_eof //-->
<!-- body //-->
<table border="0" width="100%" cellspacing="2" cellpadding="0">
<tr>
<td class="columnLeft2" width="<?php echo BOX_WIDTH; ?>" valign="top">
<table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="1" cellpadding="0" class="columnLeft">
<!-- left_navigation //-->
<?php require(DIR_WS_INCLUDES . 'column_left.php'); ?>
<!-- left_navigation_eof //-->
</table>
</td>
<!-- body_text //-->
<td class="boxCenter" width="100%" valign="top">
<div class="breakpoint-large">
<div class="pageHeading"
><?php echo HEADING_TITLE; ?></div>
<div class="gx-container create-new-wrapper">
<div class="create-new-container pull-right">
<a href="<?php echo xtc_href_link(FILENAME_MODULE_NEWSLETTER, 'action=new'); ?>"
class="btn btn-success">
<i class="fa fa-plus"></i>
<?php echo BUTTON_NEW_NEWSLETTER; ?>
</a>
</div>
</div>
<table border="0" width="100%" cellspacing="0" cellpadding="0">
<?php
if (!empty($_GET['send'])) {
?>
<tr>
<td>
Sending
</td>
</tr>
<?php
}
?>
<tr>
<td class="multi-table-wrapper">
<table width="100%" border="0" cellpadding="0" class="remove-border<?php echo $mainTableClass; ?>">
<tr>
<td>
<?php
// Default seite
switch ($_GET['action'] ?? null) {
default:
$customer_group_query = xtc_db_query("
SELECT
customers_status_name,
customers_status_id,
customers_status_image
FROM " . TABLE_CUSTOMERS_STATUS . "
WHERE
language_id='" . $_SESSION['languages_id'] . "'
");
$customer_group = [];
$gm_newsletter_recipients = '';
while ($customer_group_data = xtc_db_fetch_array($customer_group_query)) {
// get single users
$group_query = xtc_db_query("
SELECT
customers_email_address,
customers_firstname,
customers_lastname
FROM " . TABLE_NEWSLETTER_RECIPIENTS . "
WHERE
mail_status='1'
AND
customers_status='" . $customer_group_data['customers_status_id'] . "'
ORDER BY
customers_email_address
");
$gm_user_count = xtc_db_num_rows($group_query);
$gm_newsletter_recipients .= '<table border="0" width="100%" cellspacing="0" cellpadding="0">';
while ($group_data = xtc_db_fetch_array($group_query)) {
$gm_newsletter_recipients .= '<tr><td class="main" style="width: 171px; padding-left: 67px; padding-right: 12px">'
. $group_data['customers_firstname'] . ' '
. $group_data['customers_lastname']
. '</td><td class="main" style="width: 100px">'
. $group_data['customers_email_address'] . '</td></tr>';
}
$gm_newsletter_recipients .= "</table>";
$customer_group[] = [
'ID' => $customer_group_data['customers_status_id'],
'NAME' => $customer_group_data['customers_status_name'],
'IMAGE' => $customer_group_data['customers_status_image'],
'USERS' => $gm_user_count,
'USERS_INFO' => $gm_newsletter_recipients
];
$gm_user_count = 0;
$gm_newsletter_recipients = '';
}
?>
<!-- Customer Group Table -->
<table width="100%" border="0" cellspacing="0" cellpadding="0" class="gx-compatibility-table">
<tr>
<td>
<table border="0" width="100%" cellspacing="0" cellpadding="0">
<tr class="dataTableHeadingRow">
<td class="dataTableHeadingContent" style="width: 200px">
<?php echo TITLE_CUSTOMERS; ?>
</td>
<td class="dataTableHeadingContent" style="width: 100px">
<?php echo TITLE_STK; ?>
</td>
<td class="dataTableHeadingContent"> </td>
</tr>
</table>
<?php
for ($i = 0, $n = sizeof($customer_group); $i < $n; $i++) {
?>
<table border="0" width="100%" cellspacing="0" cellpadding="0">
<tr class="dataTableRow">
<td class="dataTableContent group_icon" style="width: 200px">
<?php
echo '<span style="cursor:pointer" onMouseover="this.style.textDecoration=\'underline\';" onMouseout="this.style.textDecoration=\'none\';" onclick="gm_show_newsletter_recipients(\'gm_group_'
. $i . '\');">' . $customer_group[$i]['NAME'] . '</span>';
?>
</td>
<td class="dataTableContent numeric_cell" style="width: 100px">
<?php
echo $customer_group[$i]['USERS'];
?>
</td>
<td class="dataTableContent"> </td>
</tr>
</table>
<div style="display:none;" id="gm_group_<?php echo $i; ?>"
class="newsletter-info-wrapper">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td class="dataTableContent" align="left">
<?php
if ((int)$customer_group[$i]['USERS'] == 0) {
echo " ";
} else {
echo $customer_group[$i]['USERS_INFO'];
}
?>
</td>
</tr>
</table>
</div>
<?php
}
?>
</table><!-- END Customer Group Table -->
</td>
</tr>
</table>
<?php
// get data for newsletter overwiev
$newsletters_query = xtc_db_query("SELECT
`newsletter_id`,`date`,`title`
FROM " . TABLE_MODULE_NEWSLETTER . "
WHERE `status`='0'");
$news_data = [];
while ($newsletters_data = xtc_db_fetch_array($newsletters_query)) {
$news_data[] = [
'id' => $newsletters_data['newsletter_id'],
'date' => $newsletters_data['date'],
'title' => $newsletters_data['title']
];
}
?>
<!-- Date Table -->
<table border="0" width="100%" cellspacing="0" cellpadding="0"
class="gx-compatibility-table newsletter-list-table">
<tr class="dataTableHeadingRow">
<td class="dataTableHeadingContent" width="30"><?php echo TITLE_DATE; ?></td>
<td class="dataTableHeadingContent" width="80%"><?php echo TITLE_NOT_SEND; ?></td>
</tr>
<?php
if (count($news_data) == 0) {
$gmLangEditTextManager = MainFactory::create('LanguageTextManager',
'gm_lang_edit',
$_SESSION['languages_id']);
echo '
<tr class="gx-container no-hover">
<td colspan="2" class="text-center">' . $gmLangEditTextManager->get_text('TEXT_NO_RESULT') . '</td>
</tr>
';
}
for ($i = 0, $n = sizeof($news_data); $i < $n; $i++) {
if ($news_data[$i]['id'] != '') {
?>
<tr class="dataTableRow">
<td class="dataTableContent"><?php echo $news_data[$i]['date']; ?></td>
<td class="dataTableContent"><a href="<?php echo xtc_href_link(FILENAME_MODULE_NEWSLETTER,
'ID='
. $news_data[$i]['id']); ?>"><?php echo ($news_data[$i]['title']) ? $news_data[$i]['title'] : '----'; ?></a>
</td>
</tr>
<?php
if (!empty($_GET['ID']) && $_GET['ID'] == $news_data[$i]['id']) {
$total_query = xtc_db_query("SELECT
count(*) as count
FROM module_newsletter_temp_" . (int)$_GET['ID'] . "");
$total_data = xtc_db_fetch_array($total_query);
?>
<tr class="dataTableRow newsletter-receiver-row">
<td class="dataTableContent_products"
style="border-bottom: 1px solid; border-color: #f1f1f1;" align="left"></td>
<td colspan="2" class="dataTableContent_products"
style="border-bottom: 1px solid; border-color: #f1f1f1;"
align="left"><?php echo TEXT_SEND_TO . ' ' . $total_data['count']; ?></td>
</tr>
<tr class="dataTableRow no-hover default-background">
<td colspan="2" class="dataTableContent">
<div style="margin: 10px 0">
<?php
// get data
$newsletters_query = xtc_db_query("SELECT
title,body,cc,bc
FROM " . TABLE_MODULE_NEWSLETTER . "
WHERE newsletter_id='" . (int)$_GET['ID'] . "'");
$newsletters_data = xtc_db_fetch_array($newsletters_query);
echo TEXT_TITLE . ' ' . $newsletters_data['title'] . '<br />';
$customers_status = xtc_get_customers_statuses();
// BOF GM_MOD:
sort($customers_status);
for ($i = 0, $n = sizeof($customers_status); $i < $n; $i++) {
$newsletters_data['bc'] = str_replace($customers_status[$i]['id'],
$customers_status[$i]['text'],
$newsletters_data['bc']);
}
echo TEXT_TO . ' ' . $newsletters_data['bc'] . '<br />';
echo TEXT_CC . ' ' . $newsletters_data['cc']
. '<br /><div style="margin: 24px 0 14px;">' . TEXT_PREVIEW . '</div>';
echo '<table style="border: 1px solid #E4E4E4; margin: 0" width="100%"><tr><td>'
. $newsletters_data['body'] . '</td></tr></table>';
?>
</div>
</td>
</tr>
<tr class="default-background">
<td></td>
<td style="padding-right: 24px">
<div class="grid">
<div class="span12 pull-right bottom-save-bar-content">
<a class="btn"
onClick="return confirm('<?php echo CONFIRM_DELETE; ?>')"
href="<?php echo xtc_href_link(FILENAME_MODULE_NEWSLETTER,
'action=delete&page_token='
. $_SESSION['coo_page_token']->generate_token()
. '&ID=' . $_GET['ID']); ?>">
<?php echo BUTTON_DELETE; ?>
</a>
<a class="btn"
style="margin-right: -3px"
href="<?php echo xtc_href_link(FILENAME_MODULE_NEWSLETTER,
'action=edit&ID='
. $_GET['ID']); ?>"><?php echo BUTTON_EDIT; ?></a>
<a class="btn btn-primary"
href="<?php echo xtc_href_link(FILENAME_MODULE_NEWSLETTER,
'action=send&page_token='
. $_SESSION['coo_page_token']->generate_token()
. '&ID='
. $_GET['ID']); ?>"><?php echo BUTTON_SEND; ?></a>
</div>
</div>
</td>
</tr>
<?php
}
?>
<?php
}
}
?>
</table><!-- END Date Table-->
<?php
$newsletters_query = xtc_db_query("SELECT
`newsletter_id`,`date`,`title`
FROM " . TABLE_MODULE_NEWSLETTER . "
WHERE `status`='1'");
$news_data = [];
while ($newsletters_data = xtc_db_fetch_array($newsletters_query)) {
$news_data[] = [
'id' => $newsletters_data['newsletter_id'],
'date' => $newsletters_data['date'],
'title' => $newsletters_data['title']
];
}
?>
<!-- Sent Newsletters Table -->
<table border="0" width="100%" cellspacing="0" cellpadding="0" class="gx-compatibility-table">
<tr class="dataTableHeadingRow">
<td class="dataTableHeadingContent" width="80%"><?php echo TITLE_SEND; ?></td>
<td class="dataTableHeadingContent"><?php echo TITLE_ACTION; ?></td>
</tr>
<?php
if (count($news_data) == 0) {
$gmLangEditTextManager = MainFactory::create('LanguageTextManager',
'gm_lang_edit',
$_SESSION['languages_id']);
echo '
<tr class="gx-container no-hover">
<td colspan="10" class="text-center">' . $gmLangEditTextManager->get_text('TEXT_NO_RESULT') . '</td>
</tr>
';
}
for ($i = 0, $n = sizeof($news_data); $i < $n; $i++) {
if ($news_data[$i]['id'] != '') {
?>
<tr class="dataTableRow">
<td class="dataTableContent" valign="middle" align="left"><?php echo $news_data[$i]['date']
. ' '; ?><?php echo $news_data[$i]['title']; ?></td>
<td class="dataTableContent action-list" align="left" data-gx-extension="toolbar_icons">
<a class="action-icon btn-edit" href="<?php echo xtc_href_link(FILENAME_MODULE_NEWSLETTER,
'action=edit&ID='
. $news_data[$i]['id']); ?>"></a>
<a class="action-icon btn-delete" href="<?php echo xtc_href_link(FILENAME_MODULE_NEWSLETTER,
'action=delete&page_token='
. $_SESSION['coo_page_token']->generate_token()
. '&ID='
. $news_data[$i]['id']); ?>"
onClick="return confirm('<?php echo CONFIRM_DELETE; ?>')"></a>
</td>
</tr>
<?php
}
}
?>
</table><!-- END Sent Newsletters Table -->
<?php
break; // end default page
case 'edit':
$newsletters_query = xtc_db_query("SELECT title,body,cc,bc FROM " . TABLE_MODULE_NEWSLETTER
. " WHERE newsletter_id='" . (int)($_GET['ID'] ?? null) . "'");
$newsletters_data = xtc_db_fetch_array($newsletters_query);
case 'safe':
case 'new': // action for NEW newsletter!
$customers_status = xtc_get_customers_statuses();
// BOF GM_MOD:
sort($customers_status);
echo xtc_draw_form('edit_newsletter',
FILENAME_MODULE_NEWSLETTER,
'action=save',
'post',
'enctype="multipart/form-data"') . xtc_draw_hidden_field('ID',
$_GET['ID'] ?? null);
?>
<table class="main newsletter-edit-table dataTableRow" width="100%" border="0">
<tr>
<td style="width: 15%"><?php echo TEXT_TITLE; ?></td>
<td style="width: 85%"><?php echo xtc_draw_input_field('title',
$newsletters_data['title'] ?? null,
'size=100'); ?></td>
</tr>
<tr>
<td style="width: 15%"><?php echo TEXT_TO; ?></td>
<td style="width: 85%">
<div><?php
for ($i = 0, $n = sizeof($customers_status); $i < $n; $i++) {
$group_query = xtc_db_query("SELECT count(*) as count
FROM " . TABLE_NEWSLETTER_RECIPIENTS . "
WHERE mail_status='1' and
customers_status='" . $customers_status[$i]['id'] . "'");
$group_data = xtc_db_fetch_array($group_query);
$group_query = xtc_db_query("SELECT count(*) as count
FROM " . TABLE_CUSTOMERS . "
WHERE
customers_status='" . $customers_status[$i]['id'] . "'");
$group_data_all = xtc_db_fetch_array($group_query);
$bc_array = explode(',', $newsletters_data['bc'] ?? '');
echo xtc_draw_checkbox_field('status[' . $i . ']',
'yes',
in_array($customers_status[$i]['id'], $bc_array)) . ' '
. $customers_status[$i]['text'] . ' <i>(<b>' . $group_data['count'] . '</b>'
. TEXT_USERS . $group_data_all['count'] . TEXT_CUSTOMERS . '<br />';
}
echo xtc_draw_checkbox_field('status_all', 'yes', in_array('all', $bc_array)) . ' <b>'
. TEXT_NEWSLETTER_ONLY . '</b>';
?></div>
</td>
</tr>
<tr>
<td style="width: 15%"><?php echo TEXT_CC; ?></td>
<td style="width: 85%"><?php
echo xtc_draw_input_field('cc', $newsletters_data['cc'] ?? null, 'size=100'); ?></td>
</tr>
<tr>
<td style="width: 15%; vertical-align: top"><?php echo TEXT_BODY; ?></td>
<td style="width: 85%">
<div
<?php
if (USE_WYSIWYG == 'true') {
echo 'data-gx-widget="ckeditor" data-ckeditor-height="400px" data-ckeditor-use-rel-path="false"';
}
?>>
<textarea name="newsletter_body"
class="wysiwyg">
<?php
echo htmlspecialchars(stripslashes($newsletters_data['body'] ?? ''));
?>
</textarea>
</div>
<?php
echo xtc_draw_hidden_field('page_token', $_SESSION['coo_page_token']->generate_token());
?>
</td>
</tr>
</table>
<div class="grid add-margin-top-24">
<div class="pull-right bottom-save-bar-content">
<a class="button float_left" onClick="this.blur();"
href="<?php echo xtc_href_link(FILENAME_MODULE_NEWSLETTER); ?>"><?php echo BUTTON_BACK; ?></a>
<?php echo '<input type="submit" class="btn btn-primary float_left" onClick="this.blur();" value="'
. BUTTON_SAVE . '"/>'; ?>
</div>
</div>
</form>
<?php
break;
} // end switch
?>
</td>
</tr>
</table>
</div>
</td>
</tr>
</table>
</td>
<!-- body_text_eof //-->
</tr>
</table>
<!-- body_eof //-->
<!-- footer //-->
<?php require(DIR_WS_INCLUDES . 'footer.php'); ?>
<!-- footer_eof //-->
</body>
</html>
<?php require(DIR_WS_INCLUDES . 'application_bottom.php'); ?>
Unexpected error occurred...
Class "main_ORIGIN" not found