'.$this->displaySendin().'
';
$this->_html .= '
'.$this->sib_logo.''.$this->l('Getting Started').' ';
$this->_html .= '
';
if (!extension_loaded('curl') || !ini_get('allow_url_fopen')) {
$this->_html .= '
'.$this->l('You must enable CURL extension and allow_url_fopen option on your server if you want to use this module.').'
';
}
$this->_html .= $this->keyFormProcess();
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->mailSendBySms();
$this->_html .= $this->codeDeTracking();
$this->_html .= $this->automationTracking();
$this->_html .= $this->displayNewsletterEmail();
}
return $this->_html;
}
/**
* api key put and submit form if validate.
*/
private function keyFormProcess()
{
if (Configuration::get('Sendin_Api_Key_Status', '', $this->id_shop_group, $this->id_shop)) {
$str = '';
} else {
$str = 'style=display:none;';
}
$api_key = Tools::safeOutput(Configuration::get('Sendin_Api_Key', '', $this->id_shop_group, $this->id_shop));
$key_status = Configuration::get('Sendin_Api_Key_Status', '', $this->id_shop_group, $this->id_shop);
$img_source = $this->local_path.$this->name.'/views/img/';
$this->context->smarty->assign('customtoken', Tools::encrypt(Configuration::get('PS_SHOP_NAME')));
$this->context->smarty->assign('langvalue', $this->context->language->id);
$this->context->smarty->assign('id_shop_group', $this->id_shop_group);
$this->context->smarty->assign('id_shop', $this->id_shop);
$this->context->smarty->assign('iso_code', $this->context->currency->iso_code);
$this->context->smarty->assign('cl_version', $this->cl_version);
$this->context->smarty->assign('form_url', Tools::safeOutput($_SERVER['REQUEST_URI']));
$this->context->smarty->assign('img_source', $img_source);
$this->context->smarty->assign('cl_version', $this->cl_version);
$this->context->smarty->assign('str', $str);
$this->context->smarty->assign('api_key', $api_key);
$this->context->smarty->assign('key_status', $key_status);
return $this->display(__FILE__, 'views/templates/admin/keyform.tpl');
}
/*
* 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)
{
$condition = 'AND `id_shop_group` = '.$id_shop_group.'';
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)
{
if (!$this->checkCaptchaValidation()) {
return false;
}
$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;
$condition = 'AND `id_shop_group` = '.pSQL($id_shop_group).'';
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('leftColumn');
$this->unregisterHook('rightColumn');
$this->unregisterHook('top');
$this->unregisterHook('footer');
$this->unregisterHook('createAccount');
$this->unregisterHook('createAccountForm');
$this->unregisterHook('OrderConfirmation');
$this->unregisterHook('actionCartSave');
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');
Configuration::deleteByName('Sendin_Abandoned_Status');
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_state = !empty($params['newOrderStatus']->id) ? $params['newOrderStatus']->id : Tools::getValue('id_order_state');
$id_order = !empty($params['id_order']) ? $params['id_order'] : Tools::getValue('id_order');
$sender_shipment_msg = Configuration::get('Sendin_Sender_Shipment_Message', '', $this->id_shop_group, $this->id_shop);
$sms_sipment_status = Configuration::get('Sendin_Api_Sms_shipment_Status', '', $this->id_shop_group, $this->id_shop);
$order_tracking_status = Configuration::get('Sendin_Tracking_Status', '', $this->id_shop_group, $this->id_shop);
if (($id_order_state == 7 || $id_order_state == 6) && $order_tracking_status == 1 && is_numeric($id_order) == true) {
$this->orderRefund($id_order);
} elseif ($id_order_state == 4 && $sms_sipment_status == 1 && $sender_shipment_msg != '' && 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,id_lang,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 : '';
$lang_value = '';
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'] : '';
$lang_value = (isset($customer_civility_result['0']['id_lang'])) ? $customer_civility_result['0']['id_lang'] : '';
} else {
$civility_value = '';
}
if (!empty($civility_value) && !empty($lang_value)) {
$gender_name = Db::getInstance()->getRow('SELECT `name` FROM '._DB_PREFIX_.'gender_lang WHERE `id_lang` = \''.pSQL($lang_value).'\' AND `id_gender` = \''.pSQL($civility_value).'\'');
$civility = !empty($gender_name['name']) ? $gender_name['name'] : '';
} 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 (!empty($address->phone_mobile) || !empty($address->phone)) {
$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));
}
$sms_value = !empty($address->phone_mobile) ? $address->phone_mobile : $address->phone;
$total_pay = (isset($order->total_paid)) ? round($order->total_paid, 2) : 0;
$total_pay = $total_pay.' '.$this->context->currency->iso_code;
$ref_num = (isset($order->reference)) ? $order->reference : '';
$civility_data = str_replace('{civility}', $civility, $sender_shipment_msg);
$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($sms_value, $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')) {
$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')) {
$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')) {
$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')) {
$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['order']->id_customer)) ? $params['order']->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['order']->id_address_delivery)) ? $params['order']->id_address_delivery : 0;
$id_address_invoice = (isset($params['order']->id_address_invoice)) ? $params['order']->id_address_invoice : 0;
$address_delivery = Db::getInstance()->ExecuteS('SELECT * FROM '._DB_PREFIX_.'address WHERE `id_address` = '.(int) $id_delivery);
$address_billing = Db::getInstance()->ExecuteS('SELECT * FROM '._DB_PREFIX_.'address WHERE `id_address` = '.(int) $id_address_invoice);
$ref_num = (isset($params['order']->reference)) ? $params['order']->reference : 0;
$total_to_pay = (isset($params['order']->total_paid)) ? round($params['order']->total_paid, 2) : 0;
//get phone number and add country prefix
if (!empty($address_delivery[0]['id_country'])) {
$phone_sms = !empty($address_delivery[0]['phone_mobile']) ? $address_delivery[0]['phone_mobile'] : $address_delivery[0]['phone'];
if (!empty($phone_sms)) {
$result_code = Db::getInstance()->getRow('SELECT `call_prefix` FROM '._DB_PREFIX_.'country
WHERE `id_country` = \''.pSQL($address_delivery[0]['id_country']).'\'');
$number = $this->checkMobileNumber($phone_sms, $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_tran_sms = array();
$order_date = (isset($params['order']->date_upd)) ? $params['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));
}
$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 : '';
$lang_value = (isset($this->context->customer->id_lang)) ? $this->context->customer->id_lang : '';
} else {
$civility_value = '';
}
if (!empty($civility_value) && !empty($lang_value)) {
$gender_name = Db::getInstance()->getRow('SELECT `name` FROM '._DB_PREFIX_.'gender_lang WHERE `id_lang` = \''.pSQL($lang_value).'\' AND `id_gender` = \''.pSQL($civility_value).'\'');
$civility = !empty($gender_name['name']) ? $gender_name['name'] : '';
} 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_tran_sms['from'] = Configuration::get('Sendin_Sender_Order', '', $this->id_shop_group, $this->id_shop);
$data_tran_sms['text'] = $msgbody;
$data_tran_sms['to'] = $number;
$data_tran_sms['type'] = 'transactional';
$mailin = $this->createObjMailin();
$this->sendSmsApi($data_tran_sms);
}
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 ($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);
} elseif ($customer_result[0]['newsletter'] == 1 && !empty($this->context->customer->email)) {
$list_id = str_replace('|', ',', Configuration::get('Sendin_Selected_List_Data', '', $this->id_shop_group, $this->id_shop));
$sib_list_id = explode('|', $list_id);
$config_value = $this->getApiConfigValue();
$attribute_data = array();
$attribute_key = array();
if (!empty($this->context->customer->firstname)) {
$attribute_data[] = $this->context->customer->firstname;
if (!empty($config_value->language) && $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 (!empty($config_value->language) && $config_value->language == 'fr') {
$attribute_key[] = 'NOM';
} else {
$attribute_key[] = 'SURNAME';
}
}
if (!empty($number)) {
$attribute_data[] = $number;
$attribute_key[] = 'SMS';
}
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);
}
$automation_Key = Configuration::get('Sendin_Automation_Key', '', $this->id_shop_group, $this->id_shop);
$abandoned_status = Configuration::get('Sendin_Abandoned_Status', '', $this->id_shop_group, $this->id_shop);
if (!empty($automation_Key) && $abandoned_status == 1) {
$this->cartOrderConfirm($params, $address_billing, $address_delivery, $ref_num);
}
}
/**
* 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 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;
} elseif ($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, C.id_lang, PSA.id_address, PSA.date_upd, PSA.phone_mobile, PSA.phone, '._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']) || !empty($register_row['phone'])) {
$sms_data = !empty($register_row['phone_mobile']) ? $register_row['phone_mobile'] : $register_row['phone'];
$mobile = $this->checkMobileNumber($sms_data, $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'] : '';
$lang_value = (isset($lang_value['id_lang'])) ? $lang_value['id_lang'] : '';
if (!empty($civility_value) && !empty($lang_value)) {
$gender_name = Db::getInstance()->getRow('SELECT `name` FROM '._DB_PREFIX_.'gender_lang WHERE `id_lang` = \''.pSQL($lang_value).'\' AND `id_gender` = \''.pSQL($civility_value).'\'');
$civility = !empty($gender_name['name']) ? $gender_name['name'] : '';
} 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);
$search_value = "({{\s*doubleoptin\s*}})";
$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('https://{{doubleoptin}}', '{subscribe_url}', $html_content);
$html_content = str_replace('http://{{doubleoptin}}', '{subscribe_url}', $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 = preg_replace($search_value, '{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);
}
$api_key = Configuration::get('Sendin_Api_Key', '', $this->id_shop_group, $this->id_shop);
$mailin = $this->createObjMailin($api_key);
$data_attr = array();
$data_attr = array('type' => 'category',
'data' => '[ {"name": "DOUBLE_OPT-IN", "enumeration": [ {"label": "Yes"}, {"label": "No"} ]} ]',
);
$mailin->createAttribute($data_attr);
if ($res_optin === false) {
$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);
if ($api_key == '') {
return false;
}
$mailin = $this->createObjMailin();
$data_api = array('page' => 1,
'page_limit' => 50,
);
$folder_resp = $mailin->getFolders($data_api);
//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()
{
$sendin_status = Module::isEnabled('sendinblue');
if (empty($sendin_status) || $sendin_status == 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)
{
$condition = 'and `id_shop_group` = '.(int) $id_shop_group.'';
return $condition;
}
/**
* check Default newsletter status enable or not.
*/
public function defaultNlStatus()
{
$module_name = 'ps_emailsubscription';
$data = Module::isInstalled($module_name);
if ($data === false) {
$data_resp = Module::getInstanceByName('ps_emailsubscription');
if (!empty($data_resp)) {
$data_resp->install();
}
}
$block_resp = Module::isEnabled($module_name);
if ($block_resp === false) {
Module::enableByName($module_name);
}
$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 (($_SERVER['HTTP_HOST'] != 'localhost') && !empty($api_key)) {
$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);
}
}
/**
* Displays the tracking code in the code block.
*/
public function automationTracking()
{
$automation_status = Configuration::get('Sendin_Automation_Status', '', $this->id_shop_group, $this->id_shop);
$abandoned_status = Configuration::get('Sendin_Abandoned_Status', '', $this->id_shop_group, $this->id_shop);
$this->context->smarty->assign('auto_status', $automation_status);
$this->context->smarty->assign('abandoned_status', $abandoned_status);
$this->context->smarty->assign('cl_version', $this->cl_version);
return $this->display(__FILE__, 'views/templates/admin/automation.tpl');
}
/**
* Check configration and add automation script in Header in PS site.
*/
public function hookDisplayHeader($params)
{
if (!$this->checkModuleStatus()) {
return false;
}
$version_nl = $this->newsletterVersion();
if ($version_nl >= '2.6.0') {
$this->context->controller->addJs($this->local_path.$this->name.'/views/js/sendinnlscript.js');
}
$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;
}
}
}
/**
* Displays Automation message after enable/disable script.
*/
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');
} elseif ($automation_status == 2 && empty($automation_Key)) {
return $this->redirectPage($this->l("To activate Marketing Automation, please go to your Sendinblue's account or contact us at contact@sendinblue.com"), 'ERROR');
} elseif ($automation_status == 0) {
return $this->redirectPage($this->l('Your Marketing Automation script has been uninstalled'), 'ERROR');
}
}
/**
* Validate first name and last name.
*/
public static function isCustomerName($name)
{
$validityPattern = Tools::cleanNonUnicodeSupport(
'/^(?:[^0-9!<>,;?=+()\/\\@#"°*`{}_^$%:¤\[\]|\.。]|[\.。](?:\s|$))*$/u'
);
return preg_match($validityPattern, $name);
}
/**
* Tracking Events
* Abandoned Cart.
*/
private function curlpost($data, $method)
{
$url = "https://in-automate.sendinblue.com/api/v2/$method";
$automation_Key = Configuration::get('Sendin_Automation_Key', '', $this->id_shop_group, $this->id_shop);
$headers = array(
'Content-Type: application/json',
'ma-key: '.$automation_Key,
);
$curl = curl_init();
curl_setopt_array($curl, array(
CURLOPT_HTTPHEADER => $headers,
CURLOPT_URL => $url,
CURLOPT_RETURNTRANSFER => true,
CURLOPT_ENCODING => '',
CURLOPT_MAXREDIRS => 10,
CURLOPT_TIMEOUT => 30,
CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
CURLOPT_CUSTOMREQUEST => 'POST',
CURLOPT_POSTFIELDS => json_encode($data),
));
curl_exec($curl);
curl_close($curl);
}
/**
* Tracking Events
* Add product in cart.
* actionCartSave
* hookActionCartSave.
*/
public function hookactionCartSave($params)
{
if (!$this->checkModuleStatus()) {
return false;
}
$automation_Key = Configuration::get('Sendin_Automation_Key', '', $this->id_shop_group, $this->id_shop);
$abandoned_status = Configuration::get('Sendin_Abandoned_Status', '', $this->id_shop_group, $this->id_shop);
if (empty($automation_Key) || $abandoned_status != 1) {
return false;
}
$cart = !empty($params['cart']) ? $params['cart'] : '';
$cookie = !empty($params['cookie']) ? $params['cookie'] : '';
$email = '';
if ($this->context->customer) {
if ($this->context->customer->isLogged()) {
$email = $this->context->customer->email;
}
} elseif (!empty($cookie->email)) {
$email = $cookie->email;
}
if (empty($email) || empty($cart) || empty($cart->id)) {
return false;
}
$first_name = !empty($params['cookie']->customer_firstname) ? $params['cookie']->customer_firstname : '';
$last_name = !empty($params['cookie']->customer_lastname) ? $params['cookie']->customer_lastname : '';
$currency = new CurrencyCore($cart->id_currency);
$my_currency = $currency->iso_code;
$cart_id = $cart->id;
$data = array(
'email' => $email,
'event' => '',
'properties' => array(
'FIRSTNAME' => $first_name,
'LASTNAME' => $last_name,
),
'eventdata' => array(
'id' => 'cart:'.$cart_id,
'data' => array(),
),
);
$products = array();
$subtotal = 0;
$subtotal_predisc = 0;
$subtotal_taxinc = 0;
$subtotal_predisc_taxinc = 0;
$total = 0;
$check_delete = Tools::getValue('delete');
$image_type = ImageType::getFormatedName('home');
$base = (Configuration::get('PS_SSL_ENABLED') ? 'https://' : 'http://');
$link = new Link();
$products_all = $cart->getProducts();
if (!empty($products_all)) {
foreach ($products_all as $product_data) {
$image = $base.$link->getImageLink($product_data['link_rewrite'], $product_data['id_image'], $image_type);
$url = $link->getProductLink(new Product((int) $product_data['id_product']));
$quantity = !empty($product_data['quantity']) ? $product_data['quantity'] : 0;
$size = '';
if (!empty($product_data['attributes_small'])) {
$product_varient = explode('-', $product_data['attributes_small']);
$size = !empty($product_varient['0']) ? $product_varient['0'] : '';
}
// The tax rate percentage
$tax_rate = !empty($product_data['rate']) ? $product_data['rate'] : 0;
// Retail price, including tax, excluding sales discounts
$price_predisc_taxinc = !empty($product_data['price_without_reduction']) ? $product_data['price_without_reduction'] : 0;
// Retail price, excluding tax, excluding sales discounts
$price_predisc_taxexc = $base_price = (100 * $price_predisc_taxinc) / (100 + $tax_rate);
// Retail price, including tax, including sales discounts
$price_taxinc = !empty($product_data['price_with_reduction']) ? $product_data['price_with_reduction'] : 0;
// The monetary value of tax
$tax_amount = ($base_price * $tax_rate) / 100;
// The monetary value of discount, including tax
$disc_amt_taxinc = $price_predisc_taxinc - $price_taxinc;
// The discount percentage
$disc_rate = round(($disc_amt_taxinc / $price_predisc_taxinc) * 100, 2);
// The monetary value of discount, excluding tax
$disc_amt_taxexc = ($disc_rate * $base_price) / 100;
// Sum of (price_predisc * quantity ) = Sum of retail price, excluding tax, excluding sales discounts, excluding shipping, excluding vouchers
$subtotal_predisc += $price_predisc_taxexc * $quantity;
// Sum of (price * quantity ) = Sum of retail price, excluding tax, including sales discounts, excluding shipping, excluding vouchers
$subtotal += !empty($product_data['price']) ? $product_data['price'] * $quantity : 0;
// Sum of (price_predisc_taxinc * quantity ) = Sum of retail price, including tax, excluding sales discounts, excluding shipping, excluding vouchers
$subtotal_predisc_taxinc += $price_predisc_taxinc * $quantity;
// Sum of (price_taxinc * quantity ) = Sum of retail price, including tax, including sales discounts, excluding shipping, excluding vouchers
$subtotal_taxinc += $price_taxinc * $quantity;
$products[] = array(
'id' => !empty($product_data['id_product']) ? $product_data['id_product'] : '',
'name' => !empty($product_data['name']) ? $product_data['name'] : '',
'category' => !empty($product_data['category']) ? $product_data['category'] : '',
'description_short' => !empty($product_data['description_short']) ? $product_data['description_short'] : '',
'available_now' => !empty($product_data['available_now']) ? $product_data['available_now'] : '',
'price' => !empty($product_data['price']) ? $product_data['price'] : '',
'quantity' => !empty($product_data['quantity']) ? $product_data['quantity'] : '',
'variant_id_name' => !empty($product_data['attributes_small']) ? $product_data['attributes_small'] : '',
'variant_name' => !empty($product_data['attributes_small']) ? $product_data['attributes_small'] : '',
'variant_id' => '',
'size' => $size,
'sku' => !empty($product_data['reference']) ? $product_data['reference'] : '',
'quantity' => !empty($product_data['quantity']) ? $product_data['quantity'] : '',
'price' => !empty($product_data['price']) ? $product_data['price'] : '',
'url' => $url,
'image' => $image,
'price_predisc' => round($price_predisc_taxexc, 2),
'price_predisc_taxinc' => round($price_predisc_taxinc, 2),
'price_taxinc' => round($price_taxinc, 2),
'tax_amount' => round($tax_amount, 2),
'tax_rate' => $tax_rate,
'tax_name' => !empty($product_data['tax_name']) ? $product_data['tax_name'] : '',
'disc_amount' => round($disc_amt_taxexc, 2),
'disc_amount_taxinc' => round($disc_amt_taxinc, 2),
'disc_rate' => $disc_rate,
);
}
// Note: to get all vouchers applied in total cart with Filter FILTER_ACTION_ALL_NOCAP(as it will give latest result even on ajax request)
$voucher_discounts = $cart->getCartRules(CartRule::FILTER_ACTION_ALL_NOCAP);
// Sum of value of vouchers, excluding tax
$voucher_disc = 0;
// Sum of value of vouchers, including tax
$voucher_disc_taxinc = 0;
if (!empty($voucher_discounts) && is_array($voucher_discounts)) {
foreach ($voucher_discounts as $voucher_discount) {
$voucher_disc += $voucher_discount['value_tax_exc'];
$voucher_disc_taxinc += $voucher_discount['value_real'];
}
}
// Round off these total types values to 2 decimal places
$subtotal_predisc = round($subtotal_predisc, 2);
$subtotal = round($subtotal, 2);
$subtotal_predisc_taxinc = round($subtotal_predisc_taxinc, 2);
$subtotal_taxinc = round($subtotal_taxinc, 2);
$voucher_disc = round($voucher_disc, 2);
$voucher_disc_taxinc = round($voucher_disc_taxinc, 2);
// Shipping cost, excluding tax (its already round off to 2 decimal places)
$shipping = $cart->getOrderTotal(false, Cart::ONLY_SHIPPING);
// Shipping cost, including tax (its already round off to 2 decimal places)
$shipping_taxinc = $cart->getOrderTotal(true, Cart::ONLY_SHIPPING);
// Sum of subtotal + discount + shipping = Sum of retail price, excluding tax, including sales discounts, including shipping cost (excluding tax), including vouchers (excluding tax)
$total_before_tax = $subtotal + $shipping - $voucher_disc;
// Sum of subtotal_taxinc + discount_taxinc + shipping_taxinc = Sum of retail price, including tax, including sales discounts, including shipping (including tax), including vouchers (including tax)
$total = $subtotal_taxinc + $shipping_taxinc - $voucher_disc_taxinc;
$tax_total = $total - $subtotal;
$data['eventdata']['data']['subtotal_predisc'] = $subtotal_predisc;
$data['eventdata']['data']['subtotal'] = $subtotal;
$data['eventdata']['data']['subtotal_predisc_taxinc'] = $subtotal_predisc_taxinc;
$data['eventdata']['data']['subtotal_taxinc'] = $subtotal_taxinc;
$data['eventdata']['data']['shipping'] = $shipping;
$data['eventdata']['data']['shipping_taxinc'] = $shipping_taxinc;
$data['eventdata']['data']['total_before_tax'] = $total_before_tax;
$data['eventdata']['data']['tax'] = $tax_total;
$data['eventdata']['data']['discount'] = $voucher_disc;
$data['eventdata']['data']['discount_taxinc'] = $voucher_disc_taxinc;
$data['eventdata']['data']['total'] = $total;
$data['eventdata']['data']['revenue'] = $total;
$data['eventdata']['data']['url'] = $this->context->link->getPageLink('order.php', true);
$data['eventdata']['data']['currency'] = $my_currency;
$data['eventdata']['data']['items'] = $products;
if (!empty($products)) {
$data['event'] = 'cart_updated';
$this->curlpost($data, 'trackEvent');
}
} elseif ($check_delete) {
$data['event'] = 'cart_deleted';
$data['eventdata']['data']['items'] = $products;
$this->curlpost($data, 'trackEvent');
}
//end else deleted
}
/*
* Tracking Events
* Abandoned Cart order confirmation.
*/
public function cartOrderConfirm($params, $address_billing, $address_delivery, $ref_num)
{
$email = !empty($this->context->customer->email) ? $this->context->customer->email : '';
$first_name = !empty($this->context->customer->firstname) ? $this->context->customer->firstname : '';
$last_name = !empty($this->context->customer->lastname) ? $this->context->customer->lastname : '';
$cart_id = (isset($params['order']->id_cart)) ? $params['order']->id_cart : '';
$data = array(
'email' => $email,
'event' => 'order_completed',
'properties' => array(
'FIRSTNAME' => $first_name,
'LASTNAME' => $last_name,
),
'eventdata' => array(
'id' => 'cart:'.$cart_id,
'data' => array(),
),
);
$id_currency = !empty($params['order']->id_currency) ? $params['order']->id_currency : '';
$my_currency = new Currency($id_currency);
// Sum of value of vouchers, excluding tax
$discount = !empty($params['order']->total_discounts) ? $params['order']->total_discounts : '';
// sum of subtotal_taxinc + discount_taxinc + shipping_taxinc = Sum of retail price, including tax, including sales discounts, including shipping (including tax), including vouchers (including tax)
$total = round($params['order']->total_paid, 2);
// Sum of (price * quantity ) = Sum of retail price, excluding tax, including sales discounts, excluding shipping, excluding vouchers (for now it is equal to = total_before_tax)
$subtotal = round($params['order']->total_paid_tax_excl, 2);
$tax_total = $total - $subtotal;
$order_date = (isset($params['order']->date_upd)) ? $params['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));
}
$data['eventdata']['data']['id'] = $ref_num;
$data['eventdata']['data']['date'] = !empty($ord_date) ? $ord_date : '';
$data['eventdata']['data']['subtotal'] = $subtotal;
$cart = new Cart($cart_id);
if (!empty($cart)) {
$data['eventdata']['data']['shipping'] = $cart->getOrderTotal(true, Cart::ONLY_SHIPPING);
$data['eventdata']['data']['shipping_tax_exc'] = $cart->getOrderTotal(false, Cart::ONLY_SHIPPING);
}
$data['eventdata']['data']['total_before_tax'] = $subtotal;
$data['eventdata']['data']['tax'] = $tax_total;
$data['eventdata']['data']['discount'] = round($discount, 2);
$data['eventdata']['data']['total'] = $total;
$data['eventdata']['data']['revenue'] = $total;
$data['eventdata']['data']['currency'] = $my_currency->iso_code;
$order_obj = $params['order'];
$products = array();
$products_all = $order_obj->getProductsDetail();
$site_path = Tools::getShopDomainSsl(true);
$base = (Configuration::get('PS_SSL_ENABLED') ? 'https://' : 'http://');
$image_type = ImageType::getFormatedName('home');
$link = new Link();
if (!empty($products_all)) {
foreach ($products_all as $product_data) {
$product_new = new Product($product_data['product_id'], false, $params['order']->id_lang);
$image = Image::getCover($product_data['product_id']);
$image_path = $base.$link->getImageLink($product_new->link_rewrite, $image['id_image'], $image_type);
$url = $site_path.'/index.php?id_product='.$product_data['product_id'].'&controller=product';
if ($product_data['total_price_tax_incl']) {
$total_price = round($product_data['total_price_tax_incl'], 2);
}
if (!empty($product_data['product_name'])) {
$product_attribute = explode(' - ', $product_data['product_name']);
$product_varient = !empty($product_attribute['1']) ? $product_attribute['1'] : '';
}
// Retail price, excluding tax, excluding sales discounts
$price_predisc_taxexc = $base_price = !empty($product_data['product_price']) ? $product_data['product_price'] : 0;
// Retail price, excluding tax, including sales discounts
$price_taxexc = !empty($product_data['unit_price_tax_excl']) ? $product_data['unit_price_tax_excl'] : 0;
// Retail price, including tax, including sales discounts
$price_taxinc = !empty($product_data['unit_price_tax_incl']) ? $product_data['unit_price_tax_incl'] : 0;
// tax amount on discount
$tax_amount_on_disc = $price_taxinc - $price_taxexc;
// The tax rate percentage
$tax_rate = round(($tax_amount_on_disc / $price_taxexc) * 100, 2);
// The monetary value of tax
$tax_amount = ($base_price * $tax_rate) / 100;
// Retail price, including tax, excluding sales discounts
$price_predisc_taxinc = $price_predisc_taxexc + $tax_amount;
// The monetary value of discount, excluding tax
$disc_amt_taxexc = $price_predisc_taxexc - $price_taxexc;
// The discount percentage
$disc_rate = round((($disc_amt_taxexc / $base_price) * 100), 2);
// The monetary value of discount, including tax
$disc_amt_taxinc = ($disc_rate * $price_predisc_taxinc) / 100;
$products[] = array(
'id' => !empty($product_data['product_id']) ? $product_data['product_id'] : '',
'name' => !empty($product_new->name) ? $product_new->name : '',
'category' => !empty($product_new->category) ? $product_new->category : '',
'description_short' => !empty($product_new->description_short) ? $product_new->description_short : '',
'available_now' => !empty($product_new->available_now) ? $product_new->available_now : '',
'price' => $total_price,
'quantity' => !empty($product_data['product_quantity']) ? $product_data['product_quantity'] : '',
'variant_id_name' => $product_varient,
'variant_name' => $product_varient,
'variant_id' => '',
'sku' => !empty($product_data['reference']) ? $product_data['reference'] : '',
'url' => $url,
'image' => $image_path,
'price_predisc' => round($price_predisc_taxexc, 2),
'price_predisc_taxinc' => round($price_predisc_taxinc, 2),
'price_taxinc' => round($price_taxinc, 2),
'tax_amount' => round($tax_amount, 2),
'tax_rate' => $tax_rate,
'tax_name' => !empty($product_data['tax_name']) ? $product_data['tax_name'] : '',
'disc_amount' => round($disc_amt_taxexc, 2),
'disc_amount_taxinc' => round($disc_amt_taxinc, 2),
'disc_rate' => $disc_rate,
);
}
$data['eventdata']['data']['items'] = $products;
}
$code_delivery = !empty($address_delivery[0]['id_country']) ? $address_delivery[0]['id_country'] : 0;
if (!empty($address_delivery[0]['phone_mobile']) || !empty($address_delivery[0]['phone'])) {
$mobile_phone_delivery = !empty($address_delivery[0]['phone_mobile']) ? $address_delivery[0]['phone_mobile'] : $address_delivery[0]['phone'];
$result_code_delivery = $this->countyCode($code_delivery);
$number_delivery = $this->checkMobileNumber($mobile_phone_delivery, $result_code_delivery['call_prefix']);
}
if (!empty($address_delivery[0]['id_country'])) {
$country_delivery = Country::getNameById($params['order']->id_lang, $address_delivery[0]['id_country']);
}
if (!empty($address_delivery[0]['id_state'])) {
$state_delivery = State::getNameById($address_delivery[0]['id_state']);
}
$shipping_address = array(
'firstname' => !empty($address_delivery[0]['firstname']) ? $address_delivery[0]['firstname'] : '',
'lastname' => !empty($address_delivery[0]['lastname']) ? $address_delivery[0]['lastname'] : '',
'company' => !empty($address_delivery[0]['company']) ? $address_delivery[0]['company'] : '',
'phone' => !empty($number_delivery) ? $number_delivery : '',
'country' => !empty($country_delivery) ? $country_delivery : '',
'state' => !empty($state_delivery) ? $state_delivery : '',
'address1' => !empty($address_delivery[0]['address1']) ? $address_delivery[0]['address1'] : '',
'address2' => !empty($address_delivery[0]['address2']) ? $address_delivery[0]['address2'] : '',
'city' => !empty($address_delivery[0]['city']) ? $address_delivery[0]['city'] : '',
'zipcode' => !empty($address_delivery[0]['postcode']) ? $address_delivery[0]['postcode'] : '',
);
if (!empty($address_billing[0]['id_country'])) {
$country_billing = Country::getNameById($params['order']->id_lang, $address_billing[0]['id_country']);
}
if (!empty($address_billing[0]['id_state'])) {
$state_billing = State::getNameById($address_billing[0]['id_state']);
}
$code_billing = !empty($address_billing[0]['id_country']) ? $address_billing[0]['id_country'] : 0;
if (!empty($address_billing[0]['phone_mobile']) || !empty($address_billing[0]['phone'])) {
$mobile_phone = !empty($address_billing[0]['phone_mobile']) ? $address_billing[0]['phone_mobile'] : $address_billing[0]['phone'];
$result_code = $this->countyCode($code_billing);
$number_billing = $this->checkMobileNumber($mobile_phone, $result_code['call_prefix']);
}
$billing_address = array(
'firstname' => !empty($address_billing[0]['firstname']) ? $address_billing[0]['firstname'] : '',
'lastname' => !empty($address_billing[0]['lastname']) ? $address_billing[0]['lastname'] : '',
'company' => !empty($address_billing[0]['company']) ? $address_billing[0]['company'] : '',
'phone' => !empty($number_billing) ? $number_billing : '',
'country' => !empty($country_billing) ? $country_billing : '',
'state' => !empty($state_billing) ? $state_billing : '',
'address1' => !empty($address_billing[0]['address1']) ? $address_billing[0]['address1'] : '',
'address2' => !empty($address_billing[0]['address2']) ? $address_billing[0]['address2'] : '',
'city' => !empty($address_billing[0]['city']) ? $address_billing[0]['city'] : '',
'zipcode' => !empty($address_billing[0]['postcode']) ? $address_billing[0]['postcode'] : '',
);
$data['eventdata']['data']['shipping_address'] = $shipping_address;
$data['eventdata']['data']['billing_address'] = $billing_address;
$tax_discount = $params['order']->total_discounts_tax_incl - $params['order']->total_discounts;
$data['eventdata']['data']['Miscellaneous'] = array(
'cart_DISCOUNT' => round($params['order']->total_discounts, 2),
'cart_DISCOUNT_TAX' => $tax_discount,
'customer_USER ' => $params['order']->id_customer,
'payment_METHOD' => $params['order']->payment,
'payment_METHOD_TITLE' => $params['order']->module,
'customer_IP_ADDRESS' => '',
'customer_USER_AGENT' => '',
'user_LOGIN' => '',
'user_PASSWORD' => '',
'refunded_AMOUNT' => 0,
);
$this->curlpost($data, 'trackEvent');
}
public function countyCode($code)
{
return Db::getInstance()->getRow('SELECT `call_prefix` FROM '._DB_PREFIX_.'country
WHERE `id_country` = \''.(int) $code.'\'');
}
/**
* Displays Abondoned status.
*/
public function abandonedMsg()
{
$this->registerHook('actionCartSave');
$abandoned_status = Configuration::get('Sendin_Abandoned_Status', '', $this->id_shop_group, $this->id_shop);
$automation_Key = Configuration::get('Sendin_Automation_Key', '', $this->id_shop_group, $this->id_shop);
if ($abandoned_status == 1 && !empty($automation_Key)) {
return $this->redirectPage($this->l('Your Abandoned Cart script is installed correctly.'), 'SUCCESS');
} elseif ($abandoned_status == 2 && empty($automation_Key)) {
return $this->redirectPage($this->l("To activate Marketing Automation , please go to your Sendinblue's account or contact us at contact@sendinblue.com"), 'ERROR');
} elseif ($abandoned_status == 0) {
return $this->redirectPage($this->l('Your Abandoned cart script has been uninstalled'), 'ERROR');
}
}
/**
* Register hook for Add product in cart.
*/
public function registerAbandonedHook()
{
$this->registerHook('actionCartSave');
}
/**
* Create Normal, Transactional, Calculated and Global attributes and their values
* on Sendinblue platform. This is necessary for the PrestaShop to add subscriber's details.
*/
public function createNewAttribute()
{
$api_key = Configuration::get('Sendin_Api_Key', '', $this->id_shop_group, $this->id_shop);
if (!empty($api_key)) {
$data_attr = array();
$data_attr = array('DEFAULT_GROUP_ID' => 'TEXT');
$mailin = $this->createObjMailin($api_key);
$data = array('type' => 'normal',
'data' => $data_attr,
);
$mailin->createAttribute($data);
Configuration::updateValue('Sendin_Attribute_Status', 1, '', $this->id_shop_group, $this->id_shop);
}
}
/**
* Create new Attributes 'COMPANY' and 'POSTCODE' as per the client requirements.
*/
public function createCompanyAndPostcodeAttr()
{
$api_key = Configuration::get('Sendin_Api_Key', '', $this->id_shop_group, $this->id_shop);
if (!empty($api_key)) {
$data_attr = array();
$data_attr = array( 'COMPANY' => 'TEXT','POSTCODE' => 'TEXT');
$mailin = $this->createObjMailin();
$data = array('type' => 'normal',
'data' => $data_attr,
);
$mailin->createAttribute($data);
Configuration::updateValue('Sendin_New_Attribute_Status', 1, '', $this->id_shop_group, $this->id_shop);
}
}
/**
* For the Default PS Newsletter i.e. ps_emailsubscription version 2.6.0
*/
public function sendinDefaultNewsletter($email)
{
$lang_id = !empty($this->context->language->id) ? $this->context->language->id : '';
$guest_iso = Language::getIsoById((int) $lang_id);
$this->newsletterRegistration($guest_iso);
$this->email = Tools::safeOutput($email);
}
/**
* For the Default PS Newsletter i.e. ps_emailsubscription version 2.6.0
*/
public function newsletterVersion()
{
$module = Module::getInstanceByName('ps_emailsubscription');
return $module->version;
}
/**
* check google captcha response validate
*/
public function checkCaptchaValidation()
{
$posted_values = Tools::getAllValues();
if (array_key_exists("g-recaptcha-response", $posted_values) && empty($posted_values['g-recaptcha-response'])) {
return false;
} else {
return true;
}
}
//end file
}