* @copyright 2007-2011 PrestaShop SA * @version Release: $Revision: 8783 $ * @license http://opensource.org/licenses/afl-3.0.php Academic Free License (AFL 3.0) * International Registered Trademark & Property of PrestaShop SA */ if (!defined('_PS_VERSION_')) exit; class Newsletter extends Module { private $_postErrors = array(); private $_html = ''; private $_postSucess; public function __construct() { global $cookie; $this->name = 'newsletter'; $this->tab = 'administration'; $this->version = 2.0; $this->author = 'PrestaShop'; $this->need_instance = 0; parent::__construct(); $this->displayName = $this->l('Newsletter'); $this->description = $this->l('Generates a .CSV file for mass mailings'); if ($this->id) { $this->_file = 'export_'.Configuration::get('PS_NEWSLETTER_RAND').'.csv'; $this->_postValid = array(); // Getting data... $_countries = Country::getCountries((int)($cookie->id_lang)); // ...formatting array $countries[0] = $this->l('All countries'); foreach ($_countries as $country) $countries[$country['id_country']] = $country['name']; // And filling fields to show ! $this->_fieldsExport = array( 'COUNTRY' => array( 'title' => $this->l('Customers\' country'), 'desc' => $this->l('Operate a filter on customers\' country.'), 'type' => 'select', 'value' => $countries, 'value_default' => 0 ), 'SUSCRIBERS' => array( 'title' => $this->l('Newsletter subscribers'), 'desc' => $this->l('Filter newsletter subscribers.'), 'type' => 'select', 'value' => array(0 => $this->l('All customers'), 2 => $this->l('Subscribers'), 1 => $this->l('Non-subscribers')), 'value_default' => 2 ), 'OPTIN' => array( 'title' => $this->l('Opted-in subscribers'), 'desc' => $this->l('Filter opted-in subscribers.'), 'type' => 'select', 'value' => array(0 => $this->l('All customers'), 2 => $this->l('Subscribers'), 1 => $this->l('Non-subscribers')), 'value_default' => 0 ), ); } } public function install() { return (parent::install() AND Configuration::updateValue('PS_NEWSLETTER_RAND', rand().rand())); } private function _postProcess() { if (isset($_POST['submitExport']) AND isset($_POST['action'])) { if ($_POST['action'] == 'customers') $result = $this->_getCustomers(); else { if (!Module::isInstalled('blocknewsletter')) $this->_html .= $this->displayError('The module "blocknewsletter" is required for this feature'); else $result = $this->_getBlockNewsletter(); } if (!$nb = (int)(Db::getInstance(_PS_USE_SQL_SLAVE_)->NumRows())) $this->_html .= $this->displayError($this->l('No customers found with these filters!')); elseif ($fd = @fopen(dirname(__FILE__).'/'.strval(preg_replace('#\.{2,}#', '.', $_POST['action'])).'_'.$this->_file, 'w')) { foreach ($result AS $tab) $this->_my_fputcsv($fd, $tab); fclose($fd); $this->_html .= $this->displayConfirmation( $this->l('The .CSV file has been successfully exported.'). ' ('.$nb.' '.$this->l('customers found').')
> '.$this->l('Download the file').' '.$this->_file.'

'.$this->l('WARNING: If opening this .csv file with Excel, remember to choose UTF-8 encoding or you may see strange characters.').'

'); } else $this->_html .= $this->displayError($this->l('Error: cannot write').' '.dirname(__FILE__).'/'.strval($_POST['action']).'_'.$this->_file.' !'); } } private function _getCustomers() { $rq = Db::getInstance(_PS_USE_SQL_SLAVE_)->ExecuteS(' SELECT c.`id_customer`, c.`lastname`, c.`firstname`, c.`email`, c.`ip_registration_newsletter`, c.`newsletter_date_add` FROM `'._DB_PREFIX_.'customer` c WHERE 1 '.((isset($_POST['SUSCRIBERS']) AND (int)($_POST['SUSCRIBERS']) != 0) ? 'AND c.`newsletter` = '.(int)($_POST['SUSCRIBERS'] - 1) : '').' '.((isset($_POST['OPTIN']) AND (int)($_POST['OPTIN']) != 0) ? 'AND c.`optin` = '.(int)($_POST['OPTIN'] - 1) : '').' '.((isset($_POST['COUNTRY']) AND (int)($_POST['COUNTRY']) != 0) ? 'AND (SELECT COUNT(a.`id_address`) as nb_country FROM `'._DB_PREFIX_.'address` a WHERE a.deleted = 0 AND a.`id_customer` = c.`id_customer` AND a.`id_country` = '.(int)($_POST['COUNTRY']).') >= 1' : '').' GROUP BY c.`email`'); $header = array('id_customer', 'lastname', 'firstname', 'email', 'ip_address', 'newsletter_date_add'); $result = (is_array($rq) ? array_merge(array($header), $rq) : $header); return $result; } private function _getBlockNewsletter() { $rq = Db::getInstance(_PS_USE_SQL_SLAVE_)->ExecuteS(' SELECT * FROM `'._DB_PREFIX_.'newsletter`'); $header = array('id_customer', 'email', 'newsletter_date_add', 'ip_address'); $result = (is_array($rq) ? array_merge(array($header), $rq) : $header); return $result; } private function _my_fputcsv($fd, $array) { $line = implode(';', $array); $line .= "\n"; if (!fwrite($fd, $line, 4096)) $this->_postErrors[] = $this->l('Error: cannot write').' '.dirname(__FILE__).'/'.$this->_file.' !'; } private function _displayFormExport() { $this->_html .= '

'.$this->l('There are two sorts for this module:').'

'.$this->l('Persons who have subscribed using the BlockNewsletter block in the front office.').'
'.$this->l('This is a list of e-mail addresses of persons who come to your store that do not become customers, but have subscribed to your newsletter. Using the "Export Newsletter Subscribers" below will generate a .CSV file based on the BlockNewsletter subscribers data.').'

'.'
'.$this->l('Customers that have checked "yes" to receive a newsletter in their customer profile.').'
'.$this->l('The "Export Customers" section below filters which customers you want to send a newsletter to.').'

'.$this->l('Export Newsletter Subscribers').'

'.$this->l('Export customers').'

'; } private function _displayForm() { $this->_displayFormExport(); } public function getContent() { $this->_html .= '

'.$this->displayName.'

'; if (!empty($_POST)) $this->_html .= $this->_postProcess(); $this->_displayForm(); return $this->_html; } }