";var_dump($currency);exit;

        if(version_compare(_PS_VERSION_, '1.7', '>')) {
            $my_currency_iso_code = isset($currency->symbol)?$currency->symbol:$currency->sign;
        } else {
            $my_currency_iso_code = $currency->sign;
        }

        //var_dump($my_currency_iso_code);


        return array('voucher_points'=>$voucher_points,'my_currency_iso_code'=>$my_currency_iso_code);
    }

    public function createVoucher($data){
        $id_customer = $data['id_customer'];

        $prefix = $this->getPrefix();

        $cookie = $this->context->cookie;
        $name_module = $this->_name;
        $code_module = Configuration::get($name_module.'vouchercode'.$prefix);

        $uid = $id_customer;


        ## select not used points for customer ##
        $sql_validity_of_points = $this->validityPeriodOfPoints();

        $sql = 'SELECT pc.* FROM `'._DB_PREFIX_.'spmreviewsadv_loyalty` pc where id_loyalty_status = 1 and id_customer = '.(int)($id_customer).' '.$sql_validity_of_points.'';

        $data_all = Db::getInstance()->ExecuteS($sql);

        $not_used_points = 0;
        $used_points = 0;

        foreach ($data_all as $k => $item) {
            if($item['is_use']==0){
                $not_used_points += $item['points'];
            } else {
                $used_points += $item['points'];
            }
        }

        $data_voucher = $this->getVoucherValue();
        $voucher_points = $data_voucher['voucher_points'];

        ## select not used points for customer ##


        Db::getInstance()->Execute('BEGIN');


        $id_currency = (int)$cookie->id_currency;
        $id_discount_type = 2;
        $value = $not_used_points*$voucher_points;


        $current_language = (int)$cookie->id_lang;

        $coupon = new CartRule();

        $gen_pass = Tools::strtoupper(Tools::passwdGen(8));

        foreach (Language::getLanguages() AS $language){
            $coupon->name[(int)$language['id_lang']] = $code_module.'-'.$gen_pass;
        }
        $coupon->description = Configuration::get($name_module.'coupondesc'.$prefix.'_'.$current_language);


        $codename = $code_module.'-'.$gen_pass;
        $category = explode(",",Configuration::get($name_module.'catbox'.$prefix));


        $coupon->code = $codename;
        $type = 'reduction_amount';

        $coupon->$type = ($value);

        $is_tax = (int)Configuration::get($name_module.'tax'.$prefix);

        $coupon->reduction_currency = (int)($id_currency);
        if(Configuration::get($name_module.'isminamount'.$prefix) == true ||
            Configuration::get($name_module.'isminamount'.$prefix) == 1){
            $coupon->minimum_amount = (int)(Configuration::get('sdminamount'.$prefix.'_'.(int)$id_currency));
            $coupon->minimum_amount_currency = (int)($id_currency);
            $coupon->minimum_amount_tax= (int)$is_tax;
        }

        if($id_discount_type == 2)
            $coupon->reduction_tax = (int)$is_tax;


        if (sizeof($category)>0) {
            $coupon->product_restriction = 1;

            if($id_discount_type == 1){
                $coupon->reduction_product = -2;
            }
        }


        // shared data
        $coupon->value = ($value);
        $coupon->id_customer = $uid;
        $coupon->quantity = 1;
        $coupon->quantity_per_user = 1;

        // cumulable

        $coupon->cart_rule_restriction = ((Configuration::get($name_module.'cumulativeother'.$prefix))==0?1:0);

        $coupon->cumulable = (int)(Configuration::get($name_module.'cumulativeother'.$prefix));

        $coupon->highlight = (int)(Configuration::get($name_module.'highlight'.$prefix));

        if(version_compare(_PS_VERSION_, '1.7', '>')){
            $coupon->reduction_exclude_special = ((int)(Configuration::get($name_module.'cumulativereduc'.$prefix))==0)?1:0;
        } else {
            $coupon->cumulable_reduction = (int)(Configuration::get($name_module.'cumulativereduc'.$prefix));
        }
        // cumulable


        $coupon->active = 1;

        $start_date = date('Y-m-d H:i:s');
        $coupon->date_from = $start_date;

        $different = strtotime(date('Y-m-d H:i:s')) + Configuration::get($this->_name.'sdvvalid'.$prefix)*24*60*60;
        $end_date = date('Y-m-d H:i:s',$different);
        $coupon->date_to = $end_date;



        $is_voucher_create = $coupon->add(true, false);

        if ($is_voucher_create && sizeof($category)>0)
        {
            // add a cart rule
            $is_voucher_create = $this->addProductRule($coupon->id, 1, 'categories', $category);
        }

        $this->updateIsUsePoints(array('id_customer'=>$uid));

        if (!$is_voucher_create){
            Db::getInstance()->Execute('ROLLBACK');
        }

        $code_v = $codename;

        Db::getInstance()->Execute('COMMIT');



        $data_voucher = array('voucher_code'=>$code_v,'date_until' => date('d/m/Y H:i:s',$different));

        if (Configuration::get($this->_name . 'vis_on' . $prefix) == 1) {

            $data_customer = $this->_getInfoCustomerDB(array('id_customer'=>$id_customer));


            $id_currency = (int)$cookie->id_currency;
            $cur = Currency::getCurrenciesByIdShop(Context::getContext()->shop->id);
            foreach ($cur AS $_cur){
                if($id_currency == $_cur['id_currency']){
                    $valuta = $_cur['sign'];
                }
            }


            $this->sendNotificationCreatedVoucher(
                array(
                    'email' => $data_customer['email'],
                    'name' => $data_customer['firstname'].' '.$data_customer['lastname'],
                    'data_voucher' => $data_voucher,
                    'id_lang' => $current_language,
                    'discountvalue'=>$value.$valuta,
                    'is_tax'=>$is_tax,
                )
            );

        }
        // send voucher with discount //


        return $data_voucher;


    }

    public function addProductRule($cart_rule_id, $qty, $type, array $ids)
    {
        $insert = false;

        // set transaction
        Db::getInstance()->Execute('BEGIN');

        $sql = 'INSERT INTO ' . _DB_PREFIX_ . 'cart_rule_product_rule_group (id_cart_rule, quantity) VALUES('
            . (int)($cart_rule_id) . ', ' . (int)($qty) . ')';

        // only if group rule is added
        if (Db::getInstance()->Execute($sql)) {

            $sql = 'INSERT INTO ' . _DB_PREFIX_ . 'cart_rule_product_rule (id_product_rule_group, type) VALUES('
                . (int)(Db::getInstance()->Insert_ID()) . ', "' . pSQL($type) . '")';

            // only if product rule is added
            if (Db::getInstance()->Execute($sql)) {

                if (!empty($ids)) {
                    $insert = true;

                    $iLastInsertId = Db::getInstance()->Insert_ID();

                    foreach ($ids as $id) {
                        $sql = 'INSERT INTO ' . _DB_PREFIX_ . 'cart_rule_product_rule_value (id_product_rule, id_item) VALUES('
                            . (int)($iLastInsertId) . ', ' . (int)($id) . ')';

                        if (!Db::getInstance()->Execute($sql)) {
                            $insert = false;
                        }

                    }

                    $sql = 'INSERT INTO ' . _DB_PREFIX_ . 'cart_rule_shop (id_cart_rule, id_shop) VALUES('
                        . (int)($cart_rule_id) . ', ' . (int)$this->getIdShop() . ')';

                    if (!Db::getInstance()->Execute($sql)) {
                        $insert = false;
                    }
                }
            }
        }
        // commit or rollback transaction
        $insert = ($insert)? Db::getInstance()->Execute('COMMIT') : Db::getInstance()->Execute('ROLLBACK');

        return $insert;
    }

    private function _getInfoCustomerDB($data){
        $id_customer = $data['id_customer'];
        $sql = 'SELECT * FROM `'._DB_PREFIX_.'customer`
		        WHERE `id_customer` = '.(int)$id_customer.'';
        $result = Db::getInstance()->GetRow($sql);

        return $result;
    }


    public function sendNotificationCreatedVoucher($data = null)
    {

        $prefix = $this->getPrefix();



        if (Configuration::get($this->_name . 'noti' . $prefix) == 1 && Configuration::get($this->_name.'is_loyaltyvouch'.$prefix) == 1) {


            $discountvalue = $data['discountvalue'];
            $is_tax = $data['is_tax'];


            include_once(_PS_MODULE_DIR_ . $this->_name . '/spmreviewsadv.php');
            $obj = new spmreviewsadv();

            $_data_translate_custom = $obj->translateCustom();


            $firsttext = $_data_translate_custom['firsttext'];

            $tax = $is_tax;
            if ($tax) {
                $tax_text = ' (' . $_data_translate_custom['tax_included'] . ') ';
            } else {
                $tax_text = ' (' . $_data_translate_custom['tax_excluded'] . ') ';
            }


            $secondtext = $_data_translate_custom['secondtext'];
            $threetext = $_data_translate_custom['threetext'];


            $discountvalue = $discountvalue . $tax_text;




            $email_customer = $data['email'];
            $customer_name = $data['name'];
            $voucher_code = $data['data_voucher']['voucher_code'];
            $date_until = $data['data_voucher']['date_until'];
            $id_lang = $data['id_lang'];

            include_once(_PS_MODULE_DIR_ . $this->_name . '/classes/spmreviewsadvhelp.class.php');
            $obj_reviewshelp = new spmreviewsadvhelp();
            $data_url = $obj_reviewshelp->getSEOURLs(array('id_lang' => $id_lang));
            $loyalty_account_url = $data_url['loyalty_account_url'];


            /* Email generation */
            $templateVars = array(
                '{firsttext}' => $firsttext,
                '{discountvalue}' => $discountvalue,
                '{secondtext}' => $secondtext,
                '{threetext}' => $threetext,
                '{voucher_code}' => $voucher_code,
                '{date_until}' => $date_until,
                '{customer_name}' => $customer_name,
                '{loyalty_account_url}' => $loyalty_account_url,

            );


            $iso_lng = Language::getIsoById((int)($id_lang));

            $dir_mails = _PS_MODULE_DIR_ . '/' . $this->_name . '/' . 'mails/';

            if (is_dir($dir_mails . $iso_lng . '/')) {
                $id_lang_current = $id_lang;
            } else {
                $id_lang_current = Language::getIdByIso('en');
            }

            $subject_voucher = Configuration::get($this->_name . 'loyaltyvouch' . $prefix . '_' . $id_lang);

            $id_shop = $this->getIdShop();



            /* Email sending */
            Mail::Send($id_lang_current, 'loyalty-voucher', $subject_voucher, $templateVars,
                $email_customer, 'Voucher Form', NULL, NULL,
                NULL, NULL, dirname(__FILE__) . '/../mails/', NULL, $id_shop);


        }

    }


    public function sendNotificationPoints($data = null)
    {

        $prefix = $this->getPrefix();

        if(Configuration::get($this->_name . 'noti' . $prefix) == 1 && Configuration::get($this->_name.'is_points'.$prefix) == 1) {

            $points = $data['points'];
            $id_customer = $data['id_customer'];
            $type = $data['type'];

            $data_customer = $this->_getInfoCustomerDB(array('id_customer'=>$id_customer));

            $cookie = $this->context->cookie;
            $id_lang = (int)($cookie->id_lang);


            $subject_thank_you = Configuration::get($this->_name . 'points' . $prefix . '_' . $id_lang);

            include_once(_PS_MODULE_DIR_ . $this->_name . '/classes/spmreviewsadvhelp.class.php');
            $obj_reviewshelp = new spmreviewsadvhelp();
            $data_url = $obj_reviewshelp->getSEOURLs(array('id_lang' => $id_lang));
            $loyalty_account_url = $data_url['loyalty_account_url'];


            include_once(_PS_MODULE_DIR_ . $this->_name . '/spmreviewsadv.php');
            $obj = new spmreviewsadv();

            $all_points = $obj->getAvailablePoints();
            $action_name = (isset($all_points[$type]['name'])?$all_points[$type]['name']:(isset($all_points[$type])?$all_points[$type]:''));


            $email = $data_customer['email'];
            /* Email generation */
            $templateVars = array(
                '{name}' => $data_customer['firstname'].' '.$data_customer['lastname'],
                '{points}'=>isset($points['points'])?$points['points']:$points,
                '{action_name}'=>$action_name,
                '{loyalty_account_url}'=>$loyalty_account_url

            );


            /* Email sending */

            $iso_lng = Language::getIsoById((int)($id_lang));

            $dir_mails = _PS_MODULE_DIR_ . '/' . $this->_name . '/' . 'mails/';

            if (is_dir($dir_mails . $iso_lng . '/')) {
                $id_lang_current = $id_lang;
            } else {
                $id_lang_current = Language::getIdByIso('en');
            }

            $id_shop = $this->getIdShop();

            //var_dump($id_lang_current);var_dump($subject_thank_you);var_dump($templateVars); var_dump($email); var_dump($id_shop);exit;

            Mail::Send($id_lang_current, 'loyalty-points', $subject_thank_you, $templateVars,
                $email, 'Thank you Form', NULL, NULL,
                NULL, NULL, dirname(__FILE__) . '/../mails/',NULL, $id_shop);


        }


    }

    public function getIdShop()
    {
        $id_shop = Context::getContext()->shop->id;
        return $id_shop;
    }

    public function deleteGDPRCustomerData($email){

        $data_customer = Customer::getCustomersByEmail($email);
        if(count($data_customer)>0) {
            $id_customer = $data_customer[0]['id_customer'];

            $sql =  'DELETE FROM `'._DB_PREFIX_.'spmreviewsadv_loyalty` WHERE id_customer = ' . (int)$id_customer;
            Db::getInstance()->Execute($sql);


        }

        return true;
    }

    public function getGDPRCustomerData($email){

        $data_customer = Customer::getCustomersByEmail($email);
        $customer_data = array();
        if(count($data_customer)>0) {
            $id_customer = $data_customer[0]['id_customer'];


            $sql = 'SELECT * FROM `'._DB_PREFIX_.'spmreviewsadv_loyalty` pc
		        	WHERE  `id_customer` = '.(int)$id_customer.'';

            $result_loyalty = Db::getInstance()->ExecuteS($sql);
            if(count($result_loyalty)>0)
                $customer_data['loyalty'] = json_encode($result_loyalty);



        }

        return $customer_data;

    }

}