public function addNewGDPRPolicy($privacy_form_values)
{
$required = $privacy_form_values['required'];
$active = $privacy_form_values['active'];
$privacy_link = $privacy_form_values['privacy_link'];
$labels = $privacy_form_values['field_label'];
$labels = $this->processMultilangFieldValues($labels);
$field_data = array(
'url' => pSQL($privacy_link),
'is_manadatory' => (int)$required,
'status' => (int)$active,
);
Db::getInstance()->insert('velsof_supercheckout_policies', $field_data);
// Getting the last inserted id
$id_velsof_supercheckout_policy = Db::getInstance()->Insert_ID();
foreach ($labels as $id_lang => $label) {
$policy_data_lang = array(
'policy_id' => (int)$id_velsof_supercheckout_policy,
'lang_id' => (int)$id_lang,
'description' => pSQL($label)
);
Db::getInstance()->insert('velsof_supercheckout_policy_lang', $policy_data_lang);
}
return $id_velsof_supercheckout_policy;
}
public function getPolicyRowDataCurrentLang($policy_id)
{
$current_language_id = $this->context->language->id;
$query = 'SELECT * FROM ' . _DB_PREFIX_ . 'velsof_supercheckout_policies cf ';
$query = $query . 'JOIN ' . _DB_PREFIX_ . 'velsof_supercheckout_policy_lang cfl ';
$query = $query . 'ON cf.policy_id = cfl.policy_id ';
$query = $query . 'WHERE cf.policy_id = ' . (int)$policy_id . ' AND
lang_id = ' .(int)$current_language_id;
return Db::getInstance()->executeS($query);
}
public function getAllGDPRPolicyDetails()
{
$result_gdpr_policy_details = array();
$current_language_id = $this->context->language->id;
$query = 'SELECT * FROM ' . _DB_PREFIX_ . 'velsof_supercheckout_policies cf ';
$query = $query . 'JOIN ' . _DB_PREFIX_ . 'velsof_supercheckout_policy_lang cfl ';
$query = $query . 'ON cf.policy_id = cfl.policy_id ';
$query = $query . "WHERE cfl.lang_id =". (int)$current_language_id;
$result_gdpr_policy_details = Db::getInstance()->executeS($query);
return $result_gdpr_policy_details;
}
public function deletePolicyRowData($policy_id)
{
$where_delete = "policy_id =".(int) $policy_id;
Db::getInstance()->delete('velsof_supercheckout_policies', $where_delete);
Db::getInstance()->delete('velsof_supercheckout_policy_lang', $where_delete);
}
public function getPolicyLangs($policy_id)
{
$query_field_lang = 'SELECT * FROM ' . _DB_PREFIX_ . 'velsof_supercheckout_policy_lang cfl ';
$query_field_lang .= 'WHERE cfl.policy_id = ' . (int)$policy_id;
$result_policy_details_lang = Db::getInstance()->executeS($query_field_lang);
//Converting array into suitable format
$array_fields_lang = array();
foreach ($result_policy_details_lang as $lang_data) {
$array_fields_lang[$lang_data['lang_id']] = array(
'description' => $lang_data['description']
);
}
return $array_fields_lang;
}
public function updatePolicyDetails($policy_form_values)
{
$policy_id = $policy_form_values['policy_id'];
$required = $policy_form_values['required'];
$active = $policy_form_values['active'];
$privacy_link = $policy_form_values['privacy_link'];
$labels = $policy_form_values['field_label'];
$labels = $this->processMultilangFieldValues($labels);
$update_field_data = array(
'url' => pSQL($privacy_link),
'is_manadatory' => (int)$required,
'status' => (int)$active
);
$where = "policy_id =".(int) $policy_id;
Db::getInstance()->update('velsof_supercheckout_policies', $update_field_data, $where);
$where_delete = 'policy_id = ' .(int) $policy_id;
Db::getInstance()->delete('velsof_supercheckout_policy_lang', $where_delete);
$policy_data_lang = array();
foreach ($labels as $id_lang => $label) {
$policy_data_lang = array(
'policy_id' => (int)$policy_id,
'lang_id' => (int)$id_lang,
'description' => pSQL($label)
);
Db::getInstance()->insert('velsof_supercheckout_policy_lang', $policy_data_lang);
}
return $policy_id;
}
/*
* Function for short code functionality
* Add this hook before the in frontend SuperCheckout tpl file
* {hook h='hookCustomSuperCheckoutGDPRHook'}
*/
public function hookCustomSuperCheckoutGDPRHook($params = array())
{
$gdpr_setting = $this->getGDPRPolicySetting();
$this->context->smarty->assign('supercheckout_gdpr_setting', $gdpr_setting);
return $this->display(__FILE__, 'gdpr_policy_setting.tpl');
}
private function getGDPRPolicySetting()
{
$current_language_id = $this->context->language->id;
$query = 'SELECT cf.policy_id, cf.url, cf.is_manadatory, cfl.description FROM ' . _DB_PREFIX_ . 'velsof_supercheckout_policies cf ';
$query = $query . 'JOIN ' . _DB_PREFIX_ . 'velsof_supercheckout_policy_lang cfl ';
$query = $query . 'ON cf.policy_id = cfl.policy_id ';
$query = $query . 'WHERE cf.status = 1 AND
lang_id = ' .(int)$current_language_id;
return Db::getInstance()->executeS($query);
}
private function insertUserAcceptedConsent($id_order, $acceptedConsent = array(), $default_policy_text = '')
{
$order = new Order($id_order);
$customer = new Customer($order->id_customer);
$acceptedConsentText = array();
if (count($acceptedConsent)) {
foreach ($acceptedConsent as $key => $value) {
$consent_text_sql = 'Select description from '._DB_PREFIX_.'velsof_supercheckout_policy_lang where policy_id ='.(int)$value.' and lang_id ='.(int)$order->id_lang;
$consent_text = Db::getInstance()->getRow($consent_text_sql);
$acceptedConsentText[$value] = $consent_text['description'];
}
}
if (!Tools::isEmpty($default_policy_text)) {
$acceptedConsentText[0] = $default_policy_text;
}
$accepted_consent = Tools::jsonEncode($acceptedConsentText);
$policy_consent_data = array(
'id_customer' => (int)$order->id_customer,
'id_order' => (int)$id_order,
'order_reference' => pSQL($order->reference),
'accepted_consent' => pSQL($accepted_consent),
'id_lang' => (int)$order->id_lang,
);
Db::getInstance()->insert('velsof_supercheckout_customer_consent', $policy_consent_data);
}
private function getGDPRFilteredCustomerData($search_data)
{
$orders_consent = array();
$filterSqlQuery = "Select SCC.order_reference, C.id_customer, O.id_order, C.firstname, C.lastname, C.email, SCC.accepted_consent, O.date_add from "._DB_PREFIX_."velsof_supercheckout_customer_consent SCC JOIN "._DB_PREFIX_."customer C ON SCC.id_customer = C.id_customer JOIN "._DB_PREFIX_."orders O on O.id_order = SCC.id_order"
. " where SCC.order_reference LIKE '%".pSQL($search_data)."%' OR C.email LIKE '%".pSQL($search_data)."%' order by O.id_order desc";
$filterData = Db::getInstance()->executeS($filterSqlQuery);
if (count($filterData)) {
foreach ($filterData as $key => $value) {
$order_reference = $value['order_reference'];
$id_customer = $value['id_customer'];
$id_order = $value['id_order'];
$firstname = $value['firstname'];
$lastname = $value['lastname'];
$email = $value['email'];
$accepted_consent = $value['accepted_consent'];
$date_add = Tools::displayDate($value['date_add'], $this->context->language->id, true);
$orders_consent[] = array(
'reference' => $order_reference,
'customer' => $firstname.' '.$lastname,
'id_customer' => $id_customer,
'id_order' => $id_order,
'email' => $email,
'date' => $date_add,
'consent' => Tools::jsonDecode($accepted_consent, true)
);
}
}
// d($orders_consent);
// $orders_consent = array(
// 'consent_data1' => array('reference' =>'XZDDCRDCDFDS1','customer' =>'Velocity Software','email'=>'hkumar@velsof.com', 'date'=>'2018-12-12', 'consent' => array('I this is a new plugin which allows you to create an array inside smarty','e an array you would need to be consistent in weather your arra','can create either one of the two, but not both at the same time mix')),
// 'consent_data2' => array('reference' =>'XZDDCRDCDFDS2','customer' =>'Velocity Software','email'=>'hkumar@velsof.com', 'date'=>'2018-12-12', 'consent' => array('I this is a new plugin which allows you to create an array inside smarty','e an array you would need to be consistent in weather your arra','can create either one of the two, but not both at the same time mix')),
// 'consent_data3' => array('reference' =>'XZDDCRDCDFDS3','customer' =>'Velocity Software','email'=>'hkumar@velsof.com', 'date'=>'2018-12-12', 'consent' => array('I this is a new plugin which allows you to create an array inside smarty','e an array you would need to be consistent in weather your arra','can create either one of the two, but not both at the same time mix')),
// );
return $orders_consent;
}
private function installGDPRtableNdHook()
{
$this->registerHook('customSuperCheckoutGDPRHook');
$table_customer_consent ='CREATE TABLE IF NOT EXISTS `' . _DB_PREFIX_ . 'velsof_supercheckout_customer_consent` (
`id_velsof_supercheckout_customer_consent` int(11) NOT NULL AUTO_INCREMENT,
`id_customer` int(11) DEFAULT NULL,
`id_order` int(11) DEFAULT NULL,
`order_reference` varchar(15) DEFAULT NULL,
`id_lang` int(11) NOT NULL,
`accepted_consent` varchar(8000) DEFAULT NULL,
PRIMARY KEY (`id_velsof_supercheckout_customer_consent`)
) CHARACTER SET utf8 COLLATE utf8_general_ci';
$table_sup_policies = 'CREATE TABLE IF NOT EXISTS `' . _DB_PREFIX_ . 'velsof_supercheckout_policies` (
`policy_id` int(11) NOT NULL AUTO_INCREMENT,
`url` varchar(1000) DEFAULT NULL,
`is_manadatory` tinyint(4) NOT NULL,
`status` tinyint(4) NOT NULL,
PRIMARY KEY (`policy_id`)
) CHARACTER SET utf8 COLLATE utf8_general_ci';
$table_policy_lang = 'CREATE TABLE IF NOT EXISTS `' . _DB_PREFIX_ . 'velsof_supercheckout_policy_lang` (
`policy_lang_id` int(11) NOT NULL AUTO_INCREMENT,
`policy_id` int(11) NOT NULL,
`lang_id` tinyint(4) NOT NULL,
`description` varchar(1000) NOT NULL,
PRIMARY KEY (`policy_lang_id`)
) CHARACTER SET utf8 COLLATE utf8_general_ci';
Db::getInstance()->execute($table_customer_consent);
Db::getInstance()->execute($table_sup_policies);
Db::getInstance()->execute($table_policy_lang);
die('success');
}
//
/*
* Function added by Anshul to delete the email from Marketing services
*/
public function hookActionDeleteGDPRCustomer($customer)
{
if (!empty($customer['email']) && Validate::isEmail($customer['email'])) {
if (Module::isInstalled('supercheckout')) {
$config = Tools::unserialize(Configuration::get('VELOCITY_SUPERCHECKOUT'));
if ($config['enable'] == 1 && $config['email_marketing_delete'] == 1) {
$this->deleteEmailFromMarketingServices($customer['email']);
return json_encode(true);
}
}
}
}
/*
* Function added by Anshul to delete the email from Marketing services
*/
public function deleteEmailFromMarketingServices($email)
{
$config = Tools::unserialize(Configuration::get('VELOCITY_SUPERCHECKOUT'));
if ($config['email_marketing_delete'] == 1) {
try {
if (!class_exists('KbMailChimp')) {
include_once _PS_MODULE_DIR_ . 'supercheckout/libraries/mailchimpl library.php';
}
$api_key = $config['mailchimp']['api'];
$list_id = $config['mailchimp']['list'];
$Mailchimp = new KbMailChimp($api_key);
$subscriber_hash = $Mailchimp->subscriberHash(trim($email));
$result = $Mailchimp->delete("lists/$list_id/members/$subscriber_hash");
} catch (\Exception $e) {
// $e->getMessage();
}
}
if ($config['email_marketing_delete'] == 1) {
try {
if (!class_exists('Mailin')) {
include_once(dirname(__FILE__) . '/libraries/sendinBlue/Mailin.php');
}
$api_key = $config['SendinBlue']['api'];
$list_id = $config['SendinBlue']['list'];
$mailin = new Mailin('https://api.sendinblue.com/v2.0', $api_key);
$data_arr = array("email" => $email
);
$mailin->delete_user($data_arr); //calling function to add user
} catch (\Exception $e) {
}
}
if ($config['email_marketing_delete'] == 1) {
try {
$api_key = $config['klaviyo']['api'];
$list_id = $config['klaviyo']['list'];
$fields = array(
'api_key=' . $api_key,
'email=' . urlencode($email)
);
$ch = curl_init();
curl_setopt($ch, CURLOPT_URL, 'https://a.klaviyo.com/api/v1/list/' . $list_id . '/members/exclude');
curl_setopt($ch, CURLOPT_POST, count($fields));
curl_setopt($ch, CURLOPT_POSTFIELDS, join('&', $fields));
curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false);
curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, false);
curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
curl_exec($ch);
curl_close($ch);
} catch (\Exception $e) {
}
}
}
}