';
return $this->html_code_tracking;
}
/**
*This method is used to show options to the user whether the user wants the plugin to manage
*their subscribers automatically.
*/
public function syncronizeBlockCode()
{
$temp_data = '';
$temp_data.= '
';
// template display for final confirm template mail.
$temp_confirm = '';
$temp_confirm.= '
' . $this->l('You need an active SMTP (transactional) account to be able to send confirmation emails. Please').' ' . $this->l('contact customer service').' ' . $this->l('to activate it.').'
' . $this->l('You need to set up PrestaShop Newsletter module on your Prestashop back office before using it') .'
';
}
if ($this->checkPortStatus() === 0) {
$this->_html.= '
' . $this->l('Your server configuration does not allow to send emails. Please contact you system administrator to allow outgoing connections on port 587 for following IP ranges: 94.143.17.4/32, 94.143.17.6/32 and 185.107.232.0/24.') .'
' . $this->l('We notified that you are using the previous version of our plugin, please uninstall it / remove it and keep only the latest version of SendinBlue') . '
';
}
$this->_html.= '
';
}
/**
* PrestaShop's default method that gets called when page loads.
*/
private function displayForm()
{
// checkFolderStatus after removing from SendinBlue
$this->createFolderCaseTwo();
if (Configuration::get('Sendin_Api_Key_Status', '', $this->id_shop_group, $this->id_shop)) {
$str = '';
} else {
$str = 'style="display:none;"';
}
$this->_html.= '
' . $this->displaySendin() . '
';
$this->_html.= '
';
if (Configuration::get('Sendin_Api_Key_Status', '', $this->id_shop_group, $this->id_shop) == 1) {
$this->_html.= $this->syncronizeBlockCode();
$this->_html.= $this->mailSendBySmtp();
$this->_html.= $this->codeDeTracking();
$this->_html.= $this->automationTracking();
$this->_html.= $this->mailSendBySms();
$this->_html.= $this->displayNewsletterEmail();
}
return $this->_html;
}
/*
* Get the count of total unsubcribed registered users.
*/
public function totalUnsubscribedUser()
{
$condition = $this->conditionalValue();
return Db::getInstance()->getValue('
SELECT count(DISTINCT email) AS Total
FROM `' . _DB_PREFIX_ . 'customer`
WHERE `newsletter` = 0 ' . $condition);
}
/*
* Get the count of total subcribed registered users.
*/
public function totalsubscribedUser()
{
$condition = $this->conditionalValue();
return Db::getInstance()->getValue('
SELECT count(DISTINCT email) AS Total
FROM `' . _DB_PREFIX_ . 'customer`
WHERE `newsletter` = 1 ' . $condition);
}
/*
* Checks if an email address already exists in the sendin_newsletter table
* and returns a value accordingly.
*/
private function isNewsletterRegistered($customer_email, $id_shop_group)
{
if (version_compare(_PS_VERSION_, '1.5', '>=')) {
$condition = 'AND `id_shop_group` = ' . $id_shop_group . '';
} else {
$condition = '';
}
if (Db::getInstance()->getRow('SELECT `email` FROM ' . _DB_PREFIX_ . 'sendin_newsletter
WHERE `email` = \'' . pSQL($customer_email) . '\'' . $condition . '')) {
return 1;
}
if (!$registered = Db::getInstance()->getRow('SELECT `newsletter` FROM ' . _DB_PREFIX_ . 'customer
WHERE `email` = \'' . pSQL($customer_email) . '\'' . $condition . '')) {
return -1;
}
if ($registered['newsletter'] == '1') {
return 2;
}
if ($registered['newsletter'] == '0') {
return 3;
}
return 0;
}
/*
* Checks if an email address is already subscribed in the sendin_newsletter table
* and returns true, otherwise returns false.
*/
private function isNewsletterRegisteredSub($customer_email, $id_shop_group)
{
$condition = $this->checkVersionCondition($id_shop_group);
if (Db::getInstance()->getRow('SELECT `email` FROM ' . _DB_PREFIX_ . 'sendin_newsletter
WHERE `email` = \'' . pSQL($customer_email) . '\' and active=1 ' . $condition . '')) {
return true;
}
if (Db::getInstance()->getRow('SELECT `newsletter` FROM ' . _DB_PREFIX_ . 'customer
WHERE `email` = \'' . pSQL($customer_email) . '\' and newsletter=1 ' . $condition . '')) {
return true;
}
return false;
}
/*
* Checks if an email address is already unsubscribed in the sendin_newsletter table
* and returns true, otherwise returns false.
*/
private function isNewsletterRegisteredUnsub($customer_email)
{
if (Db::getInstance()->getRow('SELECT `email` FROM ' . _DB_PREFIX_ . 'sendin_newsletter
WHERE `email` = \'' . pSQL($customer_email) . '\' and active=0')) {
return true;
}
if (Db::getInstance()->getRow('SELECT `newsletter` FROM ' . _DB_PREFIX_ . 'customer
WHERE `email` = \'' . pSQL($customer_email) . '\' and newsletter=0')) {
return true;
}
return false;
}
/**
* This method is being called when a subsriber subscribes from the front end of PrestaShop.
*/
private function newsletterRegistration($guest_iso)
{
$post_action = Tools::getValue('action');
$s_new_timestamp = date('Y-m-d H:m:s');
// get post email value
$this->email = Tools::getValue('email');
$id_shop = !empty($this->id_shop) ? $this->id_shop : 1;
$id_shop_group = !empty($this->id_shop_group) ? $this->id_shop_group : 1;
if (version_compare(_PS_VERSION_, '1.5', '>=')) {
$condition = 'AND `id_shop_group` = ' . pSQL($id_shop_group) . '';
} else {
$condition = '';
}
if (empty($this->email) || !Validate::isEmail($this->email)) {
return;
} elseif ($post_action == '1') {
$register_status = $this->isNewsletterRegistered($this->email, $id_shop_group);
$register_status_unsub = $this->isNewsletterRegisteredUnsub($this->email, $id_shop_group);
if ($register_status == - 1) {
return;
} elseif ($register_status_unsub == - 1) {
return;
}
// update unsubscribe unregister
if ($register_status == 1) {
// email status send to remote server
$this->unsubscribeByruntime($this->email);
if (!Db::getInstance()->Execute('UPDATE ' . _DB_PREFIX_ . 'sendin_newsletter
SET `active` = 0,
newsletter_date_add = \'' . $s_new_timestamp . '\'
WHERE `email` = \'' . pSQL($this->email) . '\'' . $condition . '')) {
return;
}
return $this->valid = $this->l('Unsubscription successful');
} elseif ($register_status == 2) {
// email status send to remote server
$this->unsubscribeByruntime($this->email);
if (!Db::getInstance()->Execute('UPDATE ' . _DB_PREFIX_ . 'customer
SET `newsletter` = 0,
newsletter_date_add = \'' . $s_new_timestamp . '\',
`ip_registration_newsletter` = \'' . pSQL(Tools::getRemoteAddr()) . '\'
WHERE `email` = \'' . pSQL($this->email) . '\'' . $condition . '')) {
return;
}
return $this->valid = $this->l('Unsubscription successful');
}
} elseif ($post_action == '0') {
$register_status = $this->isNewsletterRegistered($this->email, $id_shop_group);
$register_status_sub = $this->isNewsletterRegisteredSub($this->email, $id_shop_group);
if ($register_status_sub) {
return;
}
$switchQuery = false;
switch ($register_status) {
// email status send to remote server
case -1:
$switchQuery = Db::getInstance()->Execute('INSERT INTO ' . _DB_PREFIX_ . 'sendin_newsletter (id_shop, id_shop_group, email, newsletter_date_add, ip_registration_newsletter, http_referer) VALUES (\'' . pSQL($id_shop) . '\',\'' . pSQL($id_shop_group) . '\',\'' . pSQL($this->email) . '\', \'' . $s_new_timestamp . '\', \'' . pSQL(Tools::getRemoteAddr()) . '\',"")');
break;
// email status send to remote server
case 0:
$switchQuery = Db::getInstance()->Execute('UPDATE ' . _DB_PREFIX_ . 'sendin_newsletter
SET `active` = 1,
newsletter_date_add = \'' . $s_new_timestamp . '\'
WHERE `email` = \'' . pSQL($this->email) . '\'' . $condition . '');
break;
// email status send to remote server
case 1:
$switchQuery = Db::getInstance()->Execute('UPDATE ' . _DB_PREFIX_ . 'sendin_newsletter
SET `active` = 1,
newsletter_date_add = \'' . $s_new_timestamp . '\'
WHERE `email` = \'' . pSQL($this->email) . '\'' . $condition . '');
break;
// email status send to remote server
case 3:
$switchQuery = Db::getInstance()->Execute('UPDATE ' . _DB_PREFIX_ . 'customer
SET `newsletter` = 1,
newsletter_date_add = \'' . $s_new_timestamp . '\',
`ip_registration_newsletter` = \'' . pSQL(Tools::getRemoteAddr()) . '\'
WHERE `email` = \'' . pSQL($this->email) . '\'' . $condition . '');
break;
}
if (!$switchQuery) {
return;
}
$this->subscribeByruntime($this->email, '', '', $guest_iso);
$this->sendWsTemplateMail($this->email);
return $this->valid = $this->l('Subscription successful');
}
}
/**
* Method is being called at the time of uninstalling the SendinBlue module.
*/
public function uninstall()
{
$this->unregisterHook('header');
$this->unregisterHook('rightColumn');
$this->unregisterHook('top');
$this->unregisterHook('footer');
$this->unregisterHook('createAccount');
$this->unregisterHook('createAccountForm');
$this->unregisterHook('OrderConfirmation');
Configuration::deleteByName('Sendin_Api_Sms_Order_Status');
Configuration::deleteByName('Sendin_Api_Sms_shipment_Status');
Configuration::deleteByName('Sendin_Api_Sms_Campaign_Status');
Configuration::deleteByName('Sendin_Sender_Shipment_Message');
Configuration::deleteByName('Sendin_Sender_Shipment');
Configuration::deleteByName('Sendin_Sender_Order');
Configuration::deleteByName('Sendin_Sender_Order_Message');
Configuration::deleteByName('Sendin_Notify_Value');
Configuration::deleteByName('Sendin_Notify_Email');
Configuration::deleteByName('Sendin_Api_Sms_Credit');
Configuration::deleteByName('Sendin_Notify_Cron_Executed');
Configuration::deleteByName('Sendin_Template_Id');
Configuration::deleteByName('Sendin_Rightblock');
Configuration::deleteByName('Sendin_Leftblock');
Configuration::deleteByName('Sendin_Top');
Configuration::deleteByName('Sendin_Footer');
Configuration::deleteByName('Sendin_Confirm_Type');
Configuration::deleteByName('Sendin_doubleoptin_redirect');
Configuration::deleteByName('Sendin_Optin_Url_Check');
Configuration::deleteByName('Sendin_final_confirm_email');
Configuration::deleteByName('Sendin_optin_list_id');
Configuration::deleteByName('Sendin_Final_Template_Id');
Configuration::deleteByName('Sendin_Dubleoptin_Template_Id');
Configuration::deleteByName('Sendin_Automation_Status');
Configuration::deleteByName('Sendin_Automation_Key');
if (Configuration::get('Sendin_Api_Smtp_Status')) {
Configuration::updateValue('Sendin_Api_Smtp_Status', 0);
Configuration::updateValue('PS_MAIL_METHOD', 1);
Configuration::updateValue('PS_MAIL_SERVER', '');
Configuration::updateValue('PS_MAIL_USER', '');
Configuration::updateValue('PS_MAIL_PASSWD', '');
Configuration::updateValue('PS_MAIL_SMTP_ENCRYPTION', '');
Configuration::updateValue('PS_MAIL_SMTP_PORT', 25);
}
// Uninstall module
Configuration::deleteByName('Sendin_First_Request');
Configuration::deleteByName('Sendin_Subscribe_Setting');
Configuration::deleteByName('Sendin_dropdown');
Configuration::deleteByName('Sendin_Tracking_Status');
Configuration::deleteByName('Sendin_order_tracking_Status');
Configuration::deleteByName('Sendin_Smtp_Result');
Configuration::deleteByName('Sendin_Api_Key');
Configuration::deleteByName('Sendin_Api_Smtp_Status');
Configuration::deleteByName('Sendin_import_user_status');
Configuration::deleteByName('Sendin_Selected_List_Data');
Configuration::deleteByName('Sendin_Web_Hook_Status');
Configuration::deleteByName('Sendin_Web_Hook_Recheck');
Configuration::deleteByName('SENDINBLUE_CONFIGURATION_OK');
if (Configuration::get('Sendin_Newsletter_table', '', $this->id_shop_group, $this->id_shop)) {
$this->getRestoreOldNewsletteremails();
Db::getInstance()->Execute('DROP TABLE IF EXISTS ' . _DB_PREFIX_ . 'sendin_newsletter');
Configuration::deleteByName('Sendin_Newsletter_table');
Configuration::deleteByName('Sendin_Api_Key_Status');
}
return parent::uninstall();
}
public function hookupdateOrderStatus($params)
{
$id_order = !empty($params['id_order']) ? $params['id_order'] : Tools::getValue('id_order');
$id_order_state = !empty($params['newOrderStatus']->id) ? $params['newOrderStatus']->id : Tools::getValue('id_order_state');
$order_tracking_status = Configuration::get('Sendin_Tracking_Status', '', $this->id_shop_group, $this->id_shop);
if ($id_order_state == 7 && $order_tracking_status == 1 && is_numeric($id_order) == true) {
$this->orderRefund($id_order);
} elseif ($id_order_state == 4 && Configuration::get('Sendin_Api_Sms_shipment_Status', '', $this->id_shop_group, $this->id_shop) == 1 && Configuration::get('Sendin_Sender_Shipment_Message', '', $this->id_shop_group, $this->id_shop) != '' && is_numeric($id_order) == true) {
$order = new Order($id_order);
$address = new Address((int)$order->id_address_delivery);
$customer_civility_result = Db::getInstance()->ExecuteS('SELECT id_gender,firstname,lastname FROM ' . _DB_PREFIX_ . 'customer WHERE `id_customer` = ' . (int)$order->id_customer);
$firstname = (isset($address->firstname)) ? $address->firstname : '';
$lastname = (isset($address->lastname)) ? $address->lastname : '';
if (Tools::strtolower($firstname) === Tools::strtolower($customer_civility_result[0]['firstname']) && Tools::strtolower($lastname) === Tools::strtolower($customer_civility_result[0]['lastname'])) {
$civility_value = (isset($customer_civility_result['0']['id_gender'])) ? $customer_civility_result['0']['id_gender'] : '';
} else {
$civility_value = '';
}
if ($civility_value == 1) {
$civility = 'Mr.';
} elseif ($civility_value == 2) {
$civility = 'Ms.';
} elseif ($civility_value == 3) {
$civility = 'Miss.';
} else {
$civility = '';
}
$result = Db::getInstance(_PS_USE_SQL_SLAVE_)->getRow('
SELECT `call_prefix`
FROM `' . _DB_PREFIX_ . 'country`
WHERE `id_country` = ' . (int)$address->id_country);
if (isset($address->phone_mobile) && !empty($address->phone_mobile)) {
$order_date = (isset($order->date_upd)) ? $order->date_upd : 0;
if ($this->context->language->id == 1) {
$ord_date = date('m/d/Y', strtotime($order_date));
} else {
$ord_date = date('d/m/Y', strtotime($order_date));
}
$msgbody = Configuration::get('Sendin_Sender_Shipment_Message', '', $this->id_shop_group, $this->id_shop);
$total_pay = (isset($order->total_paid)) ? $order->total_paid : 0;
$total_pay = $total_pay . '' . $this->context->currency->iso_code;
if (version_compare(_PS_VERSION_, '1.5.0.0', '<')) {
$ref_num = (isset($order->id)) ? $order->id : '';
} else {
$ref_num = (isset($order->reference)) ? $order->reference : '';
}
$civility_data = str_replace('{civility}', $civility, $msgbody);
$fname = str_replace('{first_name}', $firstname, $civility_data);
$lname = str_replace('{last_name}', $lastname . "\r\n", $fname);
$product_price = str_replace('{order_price}', $total_pay, $lname);
$order_date = str_replace('{order_date}', $ord_date . "\r\n", $product_price);
$msgbody = str_replace('{order_reference}', $ref_num, $order_date);
$arr = array();
$arr['to'] = $this->checkMobileNumber($address->phone_mobile, $result['call_prefix']);
$arr['from'] = Configuration::get('Sendin_Sender_Shipment', '', $this->id_shop_group, $this->id_shop);
$arr['text'] = $msgbody;
$arr['type'] = "transactional";
$this->sendSmsApi($arr);
}
}
}
/**
* Method is use to delete transactional attribute value in SIB.
*/
public function orderRefund($order_id)
{
$order = new Order($order_id);
$customer_email = Db::getInstance()->ExecuteS('SELECT email FROM ' . _DB_PREFIX_ . 'customer WHERE `id_customer` = ' . (int)$order->id_customer);
$order_id = $order->reference;
$mailin = $this->createObjMailin();
if (!empty($order_id) && !empty($customer_email[0]['email'])) {
$data = array( "order_id" => $order_id,
"email" => $customer_email[0]['email']
);
$mailin->deleteTransnationalAttributeValue($data);
}
}
/**
* Displays the newsletter on the front page in Left column of PrestaShop
*/
public function hookLeftColumn($params)
{
if (!$this->syncSetting()) {
return false;
}
if (Tools::isSubmit('submitNewsletter')) {
if (version_compare(_PS_VERSION_, '1.5.3.4', '>')) {
$guest_iso = Language::getIsoById((int)$params['cookie']->id_lang);
}
$this->newsletterRegistration($guest_iso);
$this->email = Tools::safeOutput(Tools::getValue('email'));
if ($this->valid) {
if (Configuration::get('NW_CONFIRMATION_EMAIL', '', $this->id_shop_group, $this->id_shop)) {
Mail::Send((int)$params['cookie']->id_lang, 'newsletter_conf', Mail::l('Newsletter confirmation', (int)$params['cookie']->id_lang), array(), $this->email, null, null, null, null, null, dirname(__FILE__) . '/mails/');
}
}
}
}
/**
* Displays the newsletter on the front page in Right column of PrestaShop
*/
public function hookRightColumn($params)
{
if (!$this->syncSetting()) {
return false;
}
if (Tools::isSubmit('submitNewsletter')) {
if (version_compare(_PS_VERSION_, '1.5.3.4', '>')) {
$guest_iso = Language::getIsoById((int)$params['cookie']->id_lang);
}
$this->newsletterRegistration($guest_iso);
$this->email = Tools::safeOutput(Tools::getValue('email'));
if ($this->valid) {
if (Configuration::get('NW_CONFIRMATION_EMAIL', '', $this->id_shop_group, $this->id_shop)) {
Mail::Send((int)$params['cookie']->id_lang, 'newsletter_conf', Mail::l('Newsletter confirmation', (int)$params['cookie']->id_lang), array(), $this->email, null, null, null, null, null, dirname(__FILE__) . '/mails/');
}
}
}
}
/**
* Displays the newsletter on the front page in Footer of PrestaShop
*/
public function hookFooter($params)
{
if (!$this->syncSetting()) {
return false;
}
if (Tools::isSubmit('submitNewsletter')) {
if (version_compare(_PS_VERSION_, '1.5.3.4', '>')) {
$guest_iso = Language::getIsoById((int)$params['cookie']->id_lang);
}
$this->newsletterRegistration($guest_iso);
$this->email = Tools::safeOutput(Tools::getValue('email'));
if ($this->valid) {
if (Configuration::get('NW_CONFIRMATION_EMAIL', '', $this->id_shop_group, $this->id_shop)) {
Mail::Send((int)$params['cookie']->id_lang, 'newsletter_conf', Mail::l('Newsletter confirmation', (int)$params['cookie']->id_lang), array(), $this->email, null, null, null, null, null, dirname(__FILE__) . '/mails/');
}
}
}
$this->context->smarty->assign('this_path', $this->local_path);
}
/**
* Displays the newsletter on the front page in Top of PrestaShop
*/
public function hookTop($params)
{
if (!$this->syncSetting()) {
return false;
}
if (Tools::isSubmit('submitNewsletter')) {
if (version_compare(_PS_VERSION_, '1.5.3.4', '>')) {
$guest_iso = Language::getIsoById((int)$params['cookie']->id_lang);
}
$this->newsletterRegistration($guest_iso);
$this->email = Tools::safeOutput(Tools::getValue('email'));
if ($this->valid) {
if (Configuration::get('NW_CONFIRMATION_EMAIL', '', $this->id_shop_group, $this->id_shop)) {
Mail::Send((int)$params['cookie']->id_lang, 'newsletter_conf', Mail::l('Newsletter confirmation', (int)$params['cookie']->id_lang), array(), $this->email, null, null, null, null, null, dirname(__FILE__) . '/mails/');
}
}
}
$this->context->smarty->assign('this_path', $this->local_path);
}
/**
* Displays the newsletter option on registration page of PrestaShop
*/
public function hookcreateAccountForm($params)
{
if (!$this->syncSetting()) {
return false;
}
$this->context->smarty->assign('params', $params);
}
/*
* Displays the CSS for the SendinBlue module.
*/
public function addCss()
{
$min = $_SERVER['HTTP_HOST'] == 'localhost' ? '' : '.min';
$so = $this->l('Select option');
$selected = $this->l('selected');
$html = '';
$html.= '';
$html.= '';
$sendin_js_path = $this->local_path . $this->name . '/views/js/' . $this->name . $min . '.js?_=' . time();
$js_ddl_list = $this->local_path . $this->name . '/views/js/jquery.multiselect.min.js';
$liveclickquery = $this->local_path . $this->name . '/views/js/jquery.livequery.min.js';
$s_css = $this->local_path . $this->name . '/views/css/' . $this->name . '.css?_=' . time();
$js_ddl_list = $this->local_path . $this->name . '/views/js/jquery.multiselect.min.js';
$base = (Configuration::get('PS_SSL_ENABLED') ? 'https://' : 'http://');
$html.= '
';
return $html;
}
/**
* When a user places an order, the tracking code integrates in the order confirmation page.
*/
public function hookOrderConfirmation($params)
{
if (!$this->checkModuleStatus()) {
return false;
}
$customerid = (isset($params['objOrder']->id_customer)) ? $params['objOrder']->id_customer : '';
$customer_result = Db::getInstance()->ExecuteS('SELECT id_gender, firstname, lastname, newsletter FROM ' . _DB_PREFIX_ . 'customer WHERE `id_customer` = ' . (int)$customerid);
$id_delivery = (isset($params['objOrder']->id_address_delivery)) ? $params['objOrder']->id_address_delivery : 0;
$address_delivery = Db::getInstance()->ExecuteS('SELECT * FROM ' . _DB_PREFIX_ . 'address WHERE `id_address` = ' . (int)$id_delivery);
if (version_compare(_PS_VERSION_, '1.5.0.0', '<')) {
$ref_num = (isset($params['objOrder']->id)) ? $params['objOrder']->id : 0;
} else {
$ref_num = (isset($params['objOrder']->reference)) ? $params['objOrder']->reference : 0;
}
$total_to_pay = (isset($params['total_to_pay'])) ? $params['total_to_pay'] : 0;
//get phone number and add country prefix
if (isset($address_delivery[0]['phone_mobile']) && !empty($address_delivery[0]['phone_mobile'])) {
$result_code = Db::getInstance()->getRow('SELECT `call_prefix` FROM ' . _DB_PREFIX_ . 'country
WHERE `id_country` = \'' . pSQL($address_delivery[0]['id_country']) . '\'');
$number = $this->checkMobileNumber($address_delivery[0]['phone_mobile'], $result_code['call_prefix']);
}
if (Configuration::get('Sendin_Api_Sms_Order_Status', '', $this->id_shop_group, $this->id_shop) && Configuration::get('Sendin_Sender_Order', '', $this->id_shop_group, $this->id_shop) && Configuration::get('Sendin_Sender_Order_Message', '', $this->id_shop_group, $this->id_shop)) {
$data = array();
$order_date = (isset($params['objOrder']->date_upd)) ? $params['objOrder']->date_upd : 0;
if ($this->context->language->id == 1) {
$ord_date = date('m/d/Y', strtotime($order_date));
} else {
$ord_date = date('d/m/Y', strtotime($order_date));
}
$firstname = (isset($address_delivery[0]['firstname'])) ? $address_delivery[0]['firstname'] : '';
$lastname = (isset($address_delivery[0]['lastname'])) ? $address_delivery[0]['lastname'] : '';
if ((Tools::strtolower($firstname) === Tools::strtolower($customer_result[0]['firstname'])) && (Tools::strtolower($lastname) === Tools::strtolower($customer_result[0]['lastname']))) {
$civility_value = (isset($this->context->customer->id_gender)) ? $this->context->customer->id_gender : '';
} else {
$civility_value = '';
}
if ($civility_value == 1) {
$civility = 'Mr.';
} elseif ($civility_value == 2) {
$civility = 'Ms.';
} elseif ($civility_value == 3) {
$civility = 'Miss.';
} else {
$civility = '';
}
$total_pay = $total_to_pay . '' . $this->context->currency->iso_code;
$msgbody = Configuration::get('Sendin_Sender_Order_Message', '', $this->id_shop_group, $this->id_shop);
$civility_data = str_replace('{civility}', $civility, $msgbody);
$fname = str_replace('{first_name}', $firstname, $civility_data);
$lname = str_replace('{last_name}', $lastname . "\r\n", $fname);
$product_price = str_replace('{order_price}', $total_pay, $lname);
$order_date = str_replace('{order_date}', $ord_date . "\r\n", $product_price);
$msgbody = str_replace('{order_reference}', $ref_num, $order_date);
$data['from'] = Configuration::get('Sendin_Sender_Order', '', $this->id_shop_group, $this->id_shop);
$data['text'] = $msgbody;
$data['to'] = $number;
$data['type'] = "transactional";
$mailin = $this->createObjMailin();
$data_api = array( "email" => $this->context->customer->email);
$data_resp = $mailin->getUser($data_api);
$order_status = '';
if (!empty($data_resp['data']['transactional_attributes'])) {
$transactional_data = $data_resp['data']['transactional_attributes'];
foreach ($transactional_data as $data_chk) {
if ($data_chk['ORDER_ID'] == $ref_num) {
$order_status = $data_chk['ORDER_ID'];
}
}
}
if (empty($order_status)) {
$this->sendSmsApi($data);
}
}
if (Configuration::get('Sendin_Api_Key_Status', '', $this->id_shop_group, $this->id_shop) == 1 && Configuration::get('Sendin_Tracking_Status', '', $this->id_shop_group, $this->id_shop) == 1 && $customer_result[0]['newsletter'] == 1) {
$this->tracking = $this->trackingResult();
$config_value = $this->getApiConfigValue();
if (isset($config_value->date_format) && $config_value->date_format == 'dd-mm-yyyy') {
$date = date('d-m-Y');
} else {
$date = date('m-d-Y');
}
$list_id = str_replace('|', ',', Configuration::get('Sendin_Selected_List_Data', '', $this->id_shop_group, $this->id_shop));
$sib_list_id = explode('|', $list_id);
$attribute_data = array();
$attribute_key = array();
if (!empty($this->context->customer->firstname)) {
$attribute_data[] = $this->context->customer->firstname;
if ($config_value->language == 'fr') {
$attribute_key[] = 'PRENOM';
} else {
$attribute_key[] = 'NAME';
}
$client = 1;
}
if (!empty($this->context->customer->lastname)) {
$attribute_data[] = $this->context->customer->lastname;
if ($config_value->language == 'fr') {
$attribute_key[] = 'NOM';
} else {
$attribute_key[] = 'SURNAME';
}
}
if (!empty($number)) {
$attribute_data[] = $number;
$attribute_key[] = 'SMS';
}
if (!empty($ref_num)) {
$attribute_data[] = $ref_num;
$attribute_key[] = 'ORDER_ID';
}
if (!empty($date)) {
$attribute_data[] = $date;
$attribute_key[] = 'ORDER_DATE';
}
if (!empty($total_to_pay)) {
$attribute_data[] = Tools::safeOutput($total_to_pay);
$attribute_key[] = 'ORDER_PRICE';
}
if ($client >= 0) {
$attribute_data[] = $client;
$attribute_key[] = 'CLIENT';
}
$mailin = $this->createObjMailin();
$blacklisted_value = 0;
$attr_key_val = array();
$i = 0;
foreach ($attribute_key as $val) {
$attr_key_val[$val] = $attribute_data[$i];
$i = $i + 1;
}
$data = array( "email" => $this->context->customer->email,
"attributes" => $attr_key_val,
"blacklisted" => $blacklisted_value,
"listid" => $sib_list_id
);
$mailin->createUpdateUser($data);
}
}
/**
* Method is used to send test email to the user.
*/
private function sendMail($email, $title)
{
$country_iso = Tools::strtolower($this->context->language->iso_code);
if (is_dir(dirname(__FILE__) . '/mails/' . $country_iso) != true) {
$result = Db::getInstance()->getRow('SELECT `id_lang` FROM ' . _DB_PREFIX_ . 'lang WHERE `iso_code` = \'en\'');
$this->context->language->id = $result['id_lang'];
}
$toname = explode('@', $email);
$toname = preg_replace('/[^a-zA-Z0-9]+/', ' ', $toname[0]);
return Mail::Send((int)$this->context->language->id, 'sendinsmtp_conf', Mail::l($title, (int)$this->context->language->id), array('{title}' => $title), $email, $toname, $this->l('contact@sendinblue.com'), $this->l('SendinBlue'), null, null, dirname(__FILE__) . '/mails/');
}
public function sendNotifySms($email, $id_lang, $id_shop_group, $id_shop)
{
$country_iso = Db::getInstance()->getRow('SELECT `iso_code` FROM ' . _DB_PREFIX_ . 'lang WHERE `id_lang` = \'' . pSQL($id_lang) . '\'');
$iso_code = Tools::strtolower($country_iso['iso_code']);
if (is_dir(dirname(__FILE__) . '/mails/' . $iso_code) != true) {
$result = Db::getInstance()->getRow('SELECT `id_lang` FROM ' . _DB_PREFIX_ . 'lang WHERE `iso_code` = \'en\'');
$id_lang = $result['id_lang'];
}
$title = '[SendinBlue] Notification : Credits SMS';
$site_name = Configuration::get('PS_SHOP_NAME');
$present_credit = $this->getSmsCredit($id_shop_group, $id_shop);
$toname = explode('@', $email);
$toname = preg_replace('/[^a-zA-Z0-9]+/', ' ', $toname[0]);
return Mail::Send((int)$id_lang, 'sendinsms_notify', Mail::l($title, (int)$id_lang), array('{title}' => $title, '{present_credit}' => $present_credit, '{site_name}' => $site_name), $email, $toname, $this->l('contact@sendinblue.com'), $this->l('SendinBlue'), null, null, dirname(__FILE__) . '/mails/');
}
public function checkMobileNumber($number, $call_prefix)
{
$number = preg_replace('/\s+/', '', $number);
$charone = Tools::substr($number, 0, 1);
$chartwo = Tools::substr($number, 0, 2);
if (preg_match('/^' . $call_prefix . '/', $number)) {
return '00' . $number;
} elseif ($charone == '0' && $chartwo != '00') {
if (preg_match('/^0' . $call_prefix . '/', $number)) {
return '00' . Tools::substr($number, 1);
} else {
return '00' . $call_prefix . Tools::substr($number, 1);
}
} elseif ($chartwo == '00') {
if (preg_match('/^00' . $call_prefix . '/', $number)) {
return $number;
} else {
return '00' . $call_prefix . Tools::substr($number, 2);
}
} elseif ($charone == '+') {
if (preg_match('/^\+' . $call_prefix . '/', $number)) {
return '00' . Tools::substr($number, 1);
} else {
return '00' . $call_prefix . Tools::substr($number, 1);
}
} elseif ($charone != '0') {
return '00' . $call_prefix . $number;
}
}
/**
* Retrieve customers by email address
*
* @static
* @param $email
* @return array
*/
public function getCustomersByEmail($email)
{
$sql = 'SELECT *
FROM `' . _DB_PREFIX_ . 'customer`
WHERE `email` = \'' . pSQL($email) . '\'';
return Db::getInstance()->ExecuteS($sql);
}
public function getAllCustomers()
{
$id_shop = !empty($this->id_shop) ? $this->id_shop : 'NULL';
$id_shop_group = !empty($this->id_shop_group) ? $this->id_shop_group : 'NULL';
$condition = $this->conditionalValueSecond($id_shop_group, $id_shop);
$sql = 'SELECT C.id_customer, C.firstname, C.lastname, C.email, C.id_gender, C.newsletter, C.newsletter_date_add FROM ' . _DB_PREFIX_ . 'customer as C ' . $condition;
return Db::getInstance()->ExecuteS($sql);
}
public function conditionalValueOrder($id_shop_group, $id_shop)
{
$id_shop_group = !empty($id_shop_group) ? $id_shop_group : 'NULL';
$id_shop = !empty($id_shop) ? $id_shop : 'NULL';
if ($id_shop === 'NULL' && $id_shop_group === 'NULL') {
$condition = '';
} elseif ($id_shop_group != 'NULL' && $id_shop === 'NULL') {
$condition = 'AND id_shop_group =' . $id_shop_group;
} else {
$condition = 'AND id_shop_group =' . $id_shop_group . ' AND id_shop =' . $id_shop;
}
return $condition;
}
public function getAllCustomersofOrder($id_shop_group, $id_shop)
{
$id_shop = !empty($id_shop) ? $id_shop : 'NULL';
$id_shop_group = !empty($id_shop_group) ? $id_shop_group : 'NULL';
$condition = $this->conditionalValueOrder($id_shop_group, $id_shop);
$sql = 'SELECT id_customer, firstname, lastname, email FROM ' . _DB_PREFIX_ . 'customer WHERE newsletter = 1 ' . $condition;
return Db::getInstance()->ExecuteS($sql);
}
/**
* API config value from SendinBlue.
*/
public function getApiConfigValue($id_shop_group = null, $id_shop = null)
{
if ($id_shop === null) {
$id_shop = $this->id_shop;
}
if ($id_shop_group === null) {
$id_shop_group = $this->id_shop_group;
}
$mailin = $this->createObjMailin();
$result = $mailin->getPluginConfig();
return (object)$result['data'];
}
public function checkOlderVesion()
{
if (version_compare(_PS_VERSION_, '1.4.1.0', '<=')) {
$module_status = Db::getInstance()->getRow('select COUNT(*) totalvalue FROM `' . _DB_PREFIX_ . 'module` WHERE name ="mailin" || name ="mailinblue"');
if ($module_status['totalvalue'] > 0) {
return 1;
} else {
return 0;
}
} else {
$module_newsletter = Module::getInstanceByName('mailin');
$module_newsletter_second = Module::getInstanceByName('mailinblue');
$data_first = !empty($module_newsletter->active) ? $module_newsletter->active : '0';
$data_second = !empty($module_newsletter_second->active) ? $module_newsletter_second->active : '0';
if ($data_first == 1 || $data_second == 1) {
return 1;
} else {
return 0;
}
}
}
public function updateSmsSendinStatus($email, $sms_blacklist_status, $id_shop_group, $id_shop)
{
if (!$this->syncSetting($id_shop_group, $id_shop)) {
return false;
}
if ($sms_blacklist_status == 0) {
$sib_blacklisted_sms = 1;
} else if ($sms_blacklist_status == 1) {
$sib_blacklisted_sms = 0;
}
$mailin = $this->createObjMailin();
$data = array( "email" => $email,
"blacklisted_sms" => $sib_blacklisted_sms
);
$mailin->createUpdateUser($data);
}
/**
* Fetches all the subscribers of PrestaShop and adds them to the SendinBlue database for SMS campaign.
*/
private function smsCampaignList()
{
$id_shop = !empty($this->id_shop) ? $this->id_shop : 'NULL';
$id_shop_group = !empty($this->id_shop_group) ? $this->id_shop_group : 'NULL';
if ($id_shop === 'NULL' && $id_shop_group === 'NULL') {
$condition = '';
} elseif ($id_shop_group != 'NULL' && $id_shop === 'NULL') {
$condition = 'AND C.id_shop_group =' . $id_shop_group;
} else {
$condition = 'AND C.id_shop_group =' . $id_shop_group . ' AND C.id_shop =' . $id_shop;
}
// select only newly added users and registered user
$register_result = Db::getInstance()->ExecuteS('
SELECT C.id_customer, C.newsletter, C.newsletter_date_add, C.email, C.firstname, C.lastname, C.birthday, C.id_gender, PSA.id_address, PSA.date_upd, PSA.phone_mobile, ' . _DB_PREFIX_ . 'country.call_prefix
FROM ' . _DB_PREFIX_ . 'customer as C LEFT JOIN ' . _DB_PREFIX_ . 'address PSA ON (C.id_customer = PSA.id_customer and (PSA.id_customer, PSA.date_upd) IN
(SELECT id_customer, MAX(date_upd) upd FROM ' . _DB_PREFIX_ . 'address GROUP BY ' . _DB_PREFIX_ . 'address.id_customer))
LEFT JOIN ' . _DB_PREFIX_ . 'country ON ' . _DB_PREFIX_ . 'country.id_country = PSA.id_country
WHERE C.newsletter_date_add > 0 ' . $condition . '
GROUP BY C.id_customer');
$value_langauge = $this->getApiConfigValue();
$register_email = array();
// registered user store in array
if ($register_result) {
foreach ($register_result as $register_row) {
if (!empty($register_row['phone_mobile']) && $register_row['phone_mobile'] != '') {
$mobile = $this->checkMobileNumber($register_row['phone_mobile'], $register_row['call_prefix']);
$birthday = (isset($register_row['birthday'])) ? $register_row['birthday'] : '';
if ($value_langauge->date_format == 'dd-mm-yyyy') {
$birthday = date('d-m-Y', strtotime($birthday));
} else {
$birthday = date('m-d-Y', strtotime($birthday));
}
$civility_value = (isset($register_row['id_gender'])) ? $register_row['id_gender'] : '';
if ($civility_value == 1) {
$civility = 'Mr.';
} elseif ($civility_value == 2) {
$civility = 'Ms.';
} elseif ($civility_value == 3) {
$civility = 'Miss.';
} else {
$civility = '';
}
if ($value_langauge->language == 'fr') {
$register_email[] = array('EMAIL' => $register_row['email'], 'CIV' => $civility, 'PRENOM' => $register_row['firstname'], 'NOM' => $register_row['lastname'], 'DDNAISSANCE' => $birthday, 'CLIENT' => 1, 'SMS' => $mobile);
} else {
$register_email[] = array('EMAIL' => $register_row['email'], 'CIV' => $civility, 'NAME' => $register_row['firstname'], 'SURNAME' => $register_row['lastname'], 'BIRTHDAY' => $birthday, 'CLIENT' => 1, 'SMS' => $mobile);
}
}
}
}
return Tools::jsonEncode($register_email);
}
/**
* Send template email by sendinblue for newsletter subscriber user .
*/
public function sendWsTemplateMail($to, $templateid = false)
{
$id_shop = !empty($this->id_shop) ? $this->id_shop : 'NULL';
$id_shop_group = !empty($this->id_shop_group) ? $this->id_shop_group : 'NULL';
$key = Configuration::get('Sendin_Api_Key', '', $id_shop_group, $id_shop);
$mailin = $this->createObjMailin();
if (empty($key)) {
$id_shop = 'NULL';
$id_shop_group = 'NULL';
$key = Configuration::get('Sendin_Api_Key', '', $id_shop_group, $id_shop);
}
$Sendin_Confirm_Type = Configuration::get('Sendin_Confirm_Type', '', $id_shop_group, $id_shop);
if (empty($Sendin_Confirm_Type) || $Sendin_Confirm_Type == 'nocon') {
return false;
}
$attr_array = array();
if (!$templateid) {
if ($Sendin_Confirm_Type == 'simplemail') {
$temp_id_value = Configuration::get('Sendin_Template_Id', '', $id_shop_group, $id_shop);
$templateid = !empty($temp_id_value) ? $temp_id_value : '';
}
if ($Sendin_Confirm_Type == 'doubleoptin') {
$path_resp = '';
$shop_name = Configuration::get('PS_SHOP_NAME');
$email_user = $this->encryptDecrypt('encrypt', $to);
$path_resp = $this->local_path . 'sendinblue/MailResponce.php?'.http_build_query(array('token'=> Tools::encrypt(Configuration::get('PS_SHOP_NAME')), 'resp_val'=> $email_user), null, '&');
$sender_email = '';
$senders_data = Configuration::get('Sendin_Sender_Value', '', $id_shop_group, $id_shop);
$sender_val = Tools::jsonDecode($senders_data);
if (!empty($sender_val)) {
$sender_name = $sender_val->from_name;
$sender_email = $sender_val->from_email;
}
if ($sender_email == '') {
$sender_email = 'no-reply@sendinblue.com';
$sender_name = 'SendinBlue';
}
$template_id = Configuration::get('Sendin_Dubleoptin_Template_Id', '', $id_shop_group, $id_shop);
if ((int)$template_id > 0) {
$data = array(
'id' => $template_id
);
$response = $mailin->getCampaignV2($data);
if ($response['code'] == 'success') {
$html_content = $response['data'][0]['html_content'];
if (trim($response['data'][0]['subject']) != '') {
$subject = trim($response['data'][0]['subject']);
}
if (($response['data'][0]['from_name'] != '[DEFAULT_FROM_NAME]') &&
($response['data'][0]['from_email'] != '[DEFAULT_FROM_EMAIL]') &&
($response['data'][0]['from_email'] != '')) {
$sender_name = $response['data'][0]['from_name'];
$sender_email = $response['data'][0]['from_email'];
}
$transactional_tags = $response['data'][0]['campaign_name'];
}
} else {
return $this->defaultDoubleoptinTemp($to, $path_resp);
}
$to = array($to => '');
$from = array($sender_email, $sender_name);
$html_content = str_replace('{title}', $subject, $html_content);
$html_content = str_replace('https://[DOUBLEOPTIN]', '{subscribe_url}', $html_content);
$html_content = str_replace('http://[DOUBLEOPTIN]', '{subscribe_url}', $html_content);
$html_content = str_replace('[DOUBLEOPTIN]', '{subscribe_url}', $html_content);
$html_content = str_replace('{site_domain}', $shop_name, $html_content);
$html_content = str_replace('{unsubscribe_url}', $path_resp, $html_content);
$html_content = str_replace('{subscribe_url}', $path_resp, $html_content);
$headers = array("Content-Type"=> "text/html;charset=iso-8859-1", "X-Mailin-tag"=>$transactional_tags );
$data = array( "to" => $to,
"cc" => array(),
"bcc" =>array(),
"from" => $from,
"replyto" => array(),
"subject" => $subject,
"text" => '',
"html" => $html_content,
"attachment" => array(),
"headers" => $headers,
"inline_image" => array()
);
return $mailin->sendEmail($data);
}
}
// should be the campaign id of template created on mailin. Please remember this template should be active than only it will be sent, otherwise it will return error.
if (!empty($templateid)) {
$data = array( "id" => $templateid,
"to" => $to,
"attr" => $attr_array
);
$mailin->sendTransactionalTemplate($data);
}
}
/**
* send double optin template and manage.
*/
public function defaultDoubleoptinTemp($subscriber_email, $doubleoptin_url)
{
$id_shop = !empty($this->id_shop) ? $this->id_shop : 'NULL';
$id_shop_group = !empty($this->id_shop_group) ? $this->id_shop_group : 'NULL';
$id_lang = $this->langid;
$title = $this->l('Please confirm your subscription');
$smtp_result = Tools::jsonDecode(Configuration::get('Sendin_Smtp_Result', '', $id_shop_group, $id_shop));
if ($id_shop_group = 'NULL' && $id_shop === 'NULL' && empty($smtp_result)) {
$id_shop_group = 1;
$id_shop = 1;
$smtp_result = Tools::jsonDecode(Configuration::get('Sendin_Smtp_Result', '', $id_shop_group, $id_shop));
}
$country_iso = Db::getInstance()->getRow('SELECT `iso_code` FROM ' . _DB_PREFIX_ . 'lang WHERE `id_lang` = \'' . pSQL($this->langid) . '\'');
$iso_code = Tools::strtolower($country_iso['iso_code']);
if (is_dir(dirname(__FILE__) . '/mails/' . $iso_code) != true) {
$result = Db::getInstance()->getRow('SELECT `id_lang` FROM ' . _DB_PREFIX_ . 'lang WHERE `iso_code` = \'en\'');
$id_lang = $result['id_lang'];
}
$site_name = Configuration::get('PS_SHOP_NAME');
$toname = explode('@', $subscriber_email);
$toname = preg_replace('/[^a-zA-Z0-9]+/', ' ', $toname[0]);
return Mail::Send((int)$id_lang, 'doubleoptin_temp', Mail::l($title, (int)$id_lang), array('{double_optin}' => $doubleoptin_url, '{site_name}' => $site_name), $subscriber_email, $toname, $this->l('contact@sendinblue.com'), $this->l('SendinBlue'), null, null, dirname(__FILE__) . '/mails/');
}
/**
* Get all temlpate list id by sendinblue.
*/
public function templateDisplay()
{
$mailin = $this->createObjMailin();
$data = array( "type"=>"template",
"status"=>"temp_active",
"page"=>1,
"page_limit"=>100
);
$temp_result = $mailin->getCampaignsV2($data);
return $temp_result['data'];
}
/**
* Return customer addresses
* @return array Addresses
*/
public function getCustomerAddresses($id)
{
return Db::getInstance(_PS_USE_SQL_SLAVE_)->ExecuteS('
SELECT a.*, cl.`name` AS country, s.name AS state, s.iso_code AS state_iso
FROM `' . _DB_PREFIX_ . 'address` a
LEFT JOIN `' . _DB_PREFIX_ . 'country` c ON (a.`id_country` = c.`id_country`)
LEFT JOIN `' . _DB_PREFIX_ . 'country_lang` cl ON (c.`id_country` = cl.`id_country`)
LEFT JOIN `' . _DB_PREFIX_ . 'state` s ON (s.`id_state` = a.`id_state`)
WHERE `id_customer` = ' . (int)$id . ' AND a.`deleted` = 0');
}
/**
* Update temlpate id in prestashop configuration.
*/
public function saveTemplateValue()
{
$value_template_id = Tools::getValue('template');
$subscribe_confirm_type = Tools::getValue('subscribe_confirm_type');
$optin_redirect_url_check = Tools::getValue('optin_redirect_url_check');
$doubleoptin_redirect_url = Tools::getValue('doubleoptin-redirect-url');
$final_confirm_email = Tools::getValue('final_confirm_email');
$final_temp_id = Tools::getValue('template_final');
$optin_temp_id = Tools::getValue('optin_template_final');
Configuration::updateValue('Sendin_Template_Id', $value_template_id, '', $this->id_shop_group, $this->id_shop);
Configuration::updateValue('Sendin_Optin_Url_Check', $optin_redirect_url_check, '', $this->id_shop_group, $this->id_shop);
Configuration::updateValue('Sendin_doubleoptin_redirect', $doubleoptin_redirect_url, '', $this->id_shop_group, $this->id_shop);
Configuration::updateValue('Sendin_final_confirm_email', $final_confirm_email, '', $this->id_shop_group, $this->id_shop);
//double optin template id save in prestashop data base.
if (!empty($optin_temp_id)) {
Configuration::updateValue('Sendin_Dubleoptin_Template_Id', $optin_temp_id, '', $this->id_shop_group, $this->id_shop);
}
if (!empty($final_temp_id)) {
Configuration::updateValue('Sendin_Final_Template_Id', $final_temp_id, '', $this->id_shop_group, $this->id_shop);
}
//update sender detail in db get from SIB.
$this->updateSender();
if (!empty($subscribe_confirm_type)) {
Configuration::updateValue('Sendin_Confirm_Type', $subscribe_confirm_type, '', $this->id_shop_group, $this->id_shop);
if ($subscribe_confirm_type == 'doubleoptin') {
$res_optin = $this->checkFolderListDoubleoptin();
if (!empty($res_optin['optin_id'])) {
Configuration::updateValue('Sendin_optin_list_id', $res_optin['optin_id'], '', $this->id_shop_group, $this->id_shop);
}
if ($res_optin === false) {
$api_key = Configuration::get('Sendin_Api_Key', '', $this->id_shop_group, $this->id_shop);
$mailin = $this->createObjMailin($api_key);
$data = array( "name"=> "FORM" );
$folder_res = $mailin->createFolder($data);
$folder_id = $folder_res['data']['id'];
if (!empty($folder_id)) {
$data = array(
"list_name" => 'Temp - DOUBLE OPTIN',
"list_parent" => $folder_id
);
$list_resp = $mailin->createList($data);
$list_id = $list_resp['data']['id'];
}
Configuration::updateValue('Sendin_optin_list_id', $list_id, '', $this->id_shop_group, $this->id_shop);
}
}
}
}
public function checkFolderListDoubleoptin()
{
$api_key = Configuration::get('Sendin_Api_Key', '', $this->id_shop_group, $this->id_shop);
$data = array();
if ($api_key == '') {
return false;
}
$mailin = $this->createObjMailin();
$data_api = array( "page" => 1,
"page_limit" => 50
);
$folder_resp = $mailin->getFolders($data_api);
$data['ids'] = '';
//folder id
$s_array = array();
$return = false;
if (!empty($folder_resp['data']['folders'])) {
foreach ($folder_resp['data']['folders'] as $value) {
if (Tools::strtolower($value['name']) == 'form') {
if (!empty($value['lists'])) {
foreach ($value['lists'] as $val) {
if ($val['name'] == 'Temp - DOUBLE OPTIN') {
$s_array['optin_id'] = $val['id'];
}
}
}
}
}
if (count($s_array) > 0) {
$return = $s_array;
} else {
$return = false;
}
}
return $return;
}
/**
* Check and Update Sendinblue status.
*/
public function enableSendinblueBlock()
{
if (version_compare(_PS_VERSION_, '1.5.3.0', '<')) {
$sendin_status = Db::getInstance()->getRow('SELECT `active` FROM `' . _DB_PREFIX_ . 'module`
WHERE `name` = \'' . pSQL('sendinblue') . '\'');
} else {
$sendin_status = Module::isEnabled('sendinblue');
}
if (empty($sendin_status) || $sendin_status == 0) {
if (version_compare(_PS_VERSION_, '1.5.3.0', '>=')) {
Module::enableByName('sendinblue');
}
}
}
/**
* Make a condition for query.
*/
public function conditionalValue()
{
$id_shop_group = !empty($this->id_shop_group) ? $this->id_shop_group : 'NULL';
$id_shop = !empty($this->id_shop) ? $this->id_shop : 'NULL';
if ($id_shop === 'NULL' && $id_shop_group === 'NULL') {
$condition = '';
} elseif ($id_shop_group !== 'NULL' && $id_shop === 'NULL') {
$condition = 'AND id_shop_group =' . $id_shop_group;
} else {
$condition = 'AND id_shop_group =' . $id_shop_group . ' AND id_shop =' . $id_shop;
}
return $condition;
}
public function conditionalValueSecond($id_shop_group = null, $id_shop = null)
{
$id_shop_group = !empty($id_shop_group) ? $id_shop_group : 'NULL';
$id_shop = !empty($id_shop) ? $id_shop : 'NULL';
if ($id_shop === 'NULL' && $id_shop_group === 'NULL') {
$condition = '';
} elseif ($id_shop_group != 'NULL' && $id_shop === 'NULL') {
$condition = 'WHERE C.id_shop_group =' . $id_shop_group;
} else {
$condition = 'WHERE C.id_shop_group =' . $id_shop_group . ' AND C.id_shop =' . $id_shop;
}
return $condition;
}
/**
* Make a condition after check ps version.
*/
public function checkVersionCondition($id_shop_group)
{
if (version_compare(_PS_VERSION_, '1.5', '>=')) {
$condition = 'and `id_shop_group` = ' . (int)$id_shop_group . '';
} else {
$condition = '';
}
return $condition;
}
/**
* check Default newsletter status enable or not
*/
public function defaultNlStatus()
{
$module_name = 'blocknewsletter';
$data = Module::isInstalled($module_name);
if ($data === false) {
$data_resp = Module::getInstanceByName('blocknewsletter');
if (!empty($data_resp)) {
$data_resp->install();
}
}
if (_PS_VERSION_ <= '1.4.1.0') {
Db::getInstance()->Execute('UPDATE `'._DB_PREFIX_.'module` SET active = 1 WHERE name = "blocknewsletter"');
} else {
$block_resp = Module::getInstanceByName('blocknewsletter');
if (!empty($block_resp)) {
$block_resp->enable();
}
}
$data_final = Module::isInstalled($module_name);
if ($data_final === true) {
return 1;
} else {
return 0;
}
}
/**
* encript/decript string function.
*/
public function encryptDecrypt($action, $string)
{
$output = false;
$encrypt_method = "AES-256-CBC";
$secret_key = 'sendinblue';
$secret_iv = 'sendinblue';
// hash
$key = hash('sha256', $secret_key);
// iv - encrypt method AES-256-CBC expects 16 bytes - else you will get a warning
$iv = Tools::substr(hash('sha256', $secret_iv), 0, 16);
if ($action == 'encrypt') {
$output = openssl_encrypt($string, $encrypt_method, $key, 0, $iv);
} elseif ($action == 'decrypt') {
$output = openssl_decrypt($string, $encrypt_method, $key, 0, $iv);
}
return $output;
}
/**
* create new web hookurl for unsubscribe responce.
*/
public function createPsWebHook()
{
$web_hook = $this->local_path . 'sendinblue/sendinWebHook.php?token=' . Tools::encrypt(Configuration::get('PS_SHOP_NAME'));
$api_key = Configuration::get('Sendin_Api_Key', '', $this->id_shop_group, $this->id_shop);
if (!empty($api_key) && ($_SERVER['HTTP_HOST'] != 'localhost')) {
$mailin = $this->createObjMailin();
$data_api = array( "url" => $web_hook,
"description" => "prestashopWebHook",
"events" => array( "unsubscribe", "spam", "hard_bounce"),
"is_plat" => 1);
$web_resp = $mailin->createWebhook($data_api);
if ($web_resp['code'] == "success" || $web_resp['message'] == "URL already exist with Platform webhook.") {
Configuration::updateValue('Sendin_Web_Hook_Status', 1);
Configuration::updateValue('Sendin_Web_Hook_Recheck', 1);
}
}
}
/**
* check port 587 open or not, for using Sendinblue smtp service.
*/
public function checkPortStatus()
{
$relay_port_status = @fsockopen('smtp-relay.sendinblue.com', 587);
if (!$relay_port_status) {
return 0;
}
}
/**
* Update sender name (from name and from email) from Sendinblue for mail service.
*/
public function updateSender()
{
$mailin = $this->createObjMailin();
$data = array( "option" => "" );
$response = $mailin->getSenders($data);
if ($response['code'] == 'success') {
$senders = array('id' => $response['data']['0']['id'], 'from_name' => $response['data']['0']['from_name'], 'from_email' => $response['data']['0']['from_email']);
Configuration::updateValue('Sendin_Sender_Value', Tools::jsonEncode($senders), '', $this->id_shop_group, $this->id_shop);
}
}
/**
* create object for access data from Sendinblue threw API call.
*/
public function createObjMailin($api_key = '')
{
if (empty($api_key)) {
$api_key = Configuration::get('Sendin_Api_Key', '', $this->id_shop_group, $this->id_shop);
}
if (!empty($api_key)) {
return new Psmailin($this->sib_api_url, $api_key);
}
}
/**
* Check configration and add automation script in Header in PS site.
*/
public function hookDisplayHeader($params)
{
if (!$this->checkModuleStatus()) {
return false;
}
$automation_status = Configuration::get('Sendin_Automation_Status', '', $this->id_shop_group, $this->id_shop);
if ($automation_status == 1) {
$ma_email = isset($params['cookie']) ? $params['cookie']->email : "";
$ma_key = Configuration::get('Sendin_Automation_Key', '', $this->id_shop_group, $this->id_shop);
if (!empty($ma_key)) {
return <<
(function() {
window.sib = { equeue: [], client_key: "$ma_key" };
/* OPTIONAL: email for identify request*/
window.sib.email_id = "$ma_email";
window.sendinblue = {}; for (var j = ['track', 'identify', 'trackLink', 'page'], i = 0; i < j.length; i++) { (function(k) { window.sendinblue[k] = function() { var arg = Array.prototype.slice.call(arguments); (window.sib[k] || function() { var t = {}; t[k] = arg; window.sib.equeue.push(t);})(arg[0], arg[1], arg[2]);};})(j[i]);}var n = document.createElement("script"),i = document.getElementsByTagName("script")[0]; n.type = "text/javascript", n.id = "sendinblue-js", n.async = !0, n.src = "https://sibautomation.com/sa.js?key=" + window.sib.client_key, i.parentNode.insertBefore(n, i), window.sendinblue.page();
})();
EOT;
}
}
}
/**
* Automation bock display .
*/
public function automationTracking()
{
$automation_status = Configuration::get('Sendin_Automation_Status', '', $this->id_shop_group, $this->id_shop);
Tools::safeOutput($_SERVER['REQUEST_URI']);
$this->context->smarty->assign('auto_status', $automation_status);
$this->context->smarty->assign('cl_version', $this->cl_version);
return $this->display(__FILE__, 'views/templates/admin/automation.tpl');
}
/**
* Displays Automation status.
*/
public function automationMsg()
{
$this->registerHook('header');
$automation_status = Configuration::get('Sendin_Automation_Status', '', $this->id_shop_group, $this->id_shop);
$automation_Key = Configuration::get('Sendin_Automation_Key', '', $this->id_shop_group, $this->id_shop);
if ($automation_status == 1 && !empty($automation_Key)) {
return $this->redirectPage($this->l('Your Marketing Automation script is installed correctly.'), 'SUCCESS');
} else if ($automation_status == 2 && empty($automation_Key)) {
return $this->redirectPage($this->l("To activate Marketing Automation (beta), please go to your SendinBlue's account or contact us at contact@sendinblue.com"), 'ERROR');
} else if ($automation_status == 0) {
return $this->redirectPage($this->l("Your Marketing Automation script has been uninstalled"), 'ERROR');
}
}
}
 . ')