<?php
/**
 * 2007-2016 PrestaShop
 *
 * NOTICE OF LICENSE
 *
 * This source file is subject to the Academic Free License (AFL 3.0)
 * that is bundled with this package in the file LICENSE.txt.
 * It is also available through the world-wide-web at this URL:
 * http://opensource.org/licenses/afl-3.0.php
 * If you did not receive a copy of the license and are unable to
 * obtain it through the world-wide-web, please send an email
 * to license@prestashop.com so we can send you a copy immediately.
 *
 * DISCLAIMER
 *
 * Do not edit or add to this file if you wish to upgrade PrestaShop to newer
 * versions in the future. If you wish to customize PrestaShop for your
 * needs please refer to http://www.prestashop.com for more information.
 *
 * @author    202 ecommerce <contact@202-ecommerce.com>
 * @copyright Copyright (c) 202 ecommerce 2014
 * @license   Commercial license
 */

if (!defined('_PS_VERSION_')) {
    exit;
}
include_once(dirname(__FILE__).'/TotLoyaltyState.php');

class TotLoyalty extends ObjectModel
{
    public $id_loyalty_state;
    public $id_customer;
    public $id_order;
    public $id_cart_rule;
    public $points;
    public $date_add;
    public $date_upd;

    /**
     * @see ObjectModel::$definition
     */
    public static $definition = array(
        'table'   => 'totloyalty',
        'primary' => 'id_loyalty',
        'fields'  => array(
            'id_loyalty_state' => array('type' => self::TYPE_INT, 'validate' => 'isInt'),
            'id_customer'      => array('type' => self::TYPE_INT, 'validate' => 'isInt', 'required' => true),
            'id_order'         => array('type' => self::TYPE_INT, 'validate' => 'isInt'),
            'id_cart_rule'     => array('type' => self::TYPE_INT, 'validate' => 'isInt'),
            'points'           => array('type' => self::TYPE_INT, 'validate' => 'isInt', 'required' => true),
            'date_add'         => array('type' => self::TYPE_DATE, 'validate' => 'isDate'),
            'date_upd'         => array('type' => self::TYPE_DATE, 'validate' => 'isDate'),
        ),
    );

    public function save($nullValues = false, $autodate = true)
    {
        parent::save($nullValues, $autodate);
        $this->historize();
    }

    public static function getByOrderId($id_order)
    {
        if (!Validate::isUnsignedId($id_order)) {
            return false;
        }

        $result = Db::getInstance()->getRow('SELECT f.id_loyalty FROM `'._DB_PREFIX_.'totloyalty` f WHERE f.id_order = '.(int)($id_order));

        return isset($result['id_loyalty']) ? $result['id_loyalty'] : false;
    }

    /**
     * @param Order $order
     * @return bool|int
     */
    public static function getOrderNbPoints($order)
    {
        if (!Validate::isLoadedObject($order)) {
            return false;
        }

        return self::getCartNbPoints(new Cart((int)$order->id_cart));
    }

    /**
     * @param Cart    $cart
     * @param Product $newProduct
     * @return int
     */
    public static function getCartNbPoints($cart, $newProduct = null)
    {
        $total = 0;
        if (Validate::isLoadedObject($cart)) {
            $currentContext = Context::getContext();
            $context        = clone $currentContext;
            $context->cart  = $cart;
            // if customer is logged we do not recreate it
            if (!$context->customer->isLogged(true)) {
                $context->customer = new Customer($context->cart->id_customer);
            }
            $context->language = new Language($context->cart->id_lang);
            $context->shop     = new Shop($context->cart->id_shop);
            $context->currency = new Currency($context->cart->id_currency, null, $context->shop->id);

            $cartProducts    = $cart->getProducts();
            $taxesEnabled    = Product::getTaxCalculationMethod();
            $cartProductsNew = array();
            if (isset($newProduct) and !empty($newProduct)) {
                $cartProductsNew['id_product'] = (int)$newProduct->id;
                if ($taxesEnabled == PS_TAX_EXC) {
                    $cartProductsNew['price'] = number_format($newProduct->getPrice(false, (int)$newProduct->getIdProductAttributeMostExpensive()), 2, '.', '');
                } else {
                    $cartProductsNew['price_wt'] = number_format($newProduct->getPrice(true, (int)$newProduct->getIdProductAttributeMostExpensive()), 2, '.', '');
                }
                $cartProductsNew['cart_quantity'] = 1;
                $cartProducts[]                   = $cartProductsNew;
            }
            foreach ($cartProducts as $product) {
                if (!(int)(Configuration::get('PS_LOYALTY_NONE_AWARD')) and Product::isDiscounted((int)$product['id_product'])) {
                    if (isset(Context::getContext()->smarty) and is_object($newProduct) and $product['id_product'] == $newProduct->id) {
                        Context::getContext()->smarty->assign('no_pts_discounted', 1);
                    }
                    continue;
                }
                $total += ($taxesEnabled == PS_TAX_EXC ? $product['price'] : $product['price_wt']) * (int)($product['cart_quantity']);
            }
            foreach ($cart->getCartRules(false) as $cart_rule) {
                if ($taxesEnabled == PS_TAX_EXC) {
                    $total -= $cart_rule['value_tax_exc'];
                } else {
                    $total -= $cart_rule['value_real'];
                }
            }
        }

        return self::getNbPointsByPrice($total);
    }

    public static function getVoucherValue($nbPoints, $id_currency = null)
    {
        $currency = $id_currency ? new Currency($id_currency) : Context::getContext()->currency->id;

        return (int)$nbPoints * (float)Tools::convertPrice(Configuration::get('PS_LOYALTY_POINT_VALUE'), $currency);
    }

    public static function getNbPointsByPrice($price)
    {
        if (Configuration::get('PS_CURRENCY_DEFAULT') != Context::getContext()->currency->id) {
            if (Context::getContext()->currency->conversion_rate) {
                $price = $price / Context::getContext()->currency->conversion_rate;
            }
        }

        /* Prevent division by zero */
        $points = 0;
        if ($pointRate = (float)(Configuration::get('PS_LOYALTY_POINT_RATE'))) {
            $points = floor(number_format($price, 2, '.', '') / $pointRate);
        }

        return (int)$points;
    }

    public static function getPointsByCustomer($id_customer)
    {
        $validity_period = Configuration::get('PS_LOYALTY_VALIDITY_PERIOD');
        $sql_period      = '';
        if ((int)$validity_period > 0) {
            $sql_period = ' AND datediff(NOW(),f.date_add) <= '.pSQL($validity_period);
        }

        return
            Db::getInstance()->getValue('
            SELECT SUM(f.points) points
        FROM `'._DB_PREFIX_.'totloyalty` f
        WHERE f.id_customer = '.(int)($id_customer).'
        AND f.id_loyalty_state IN ('.(int)(TotLoyaltyState::getValidationId()).', '.(int)(TotLoyaltyState::getNoneAwardId()).')
        '.$sql_period)
            +
            Db::getInstance()->getValue('
        SELECT SUM(f.points) points
        FROM `'._DB_PREFIX_.'totloyalty` f
        WHERE f.id_customer = '.(int)($id_customer).'
        AND f.id_loyalty_state = '.(int)TotLoyaltyState::getCancelId().'
        AND points < 0
        '.$sql_period);
    }

    public static function getAllByIdCustomer($id_customer, $id_lang, $onlyValidate = false, $pagination = false, $nb = 10, $page = 1)
    {
        $validity_period = Configuration::get('PS_LOYALTY_VALIDITY_PERIOD');
        $sql_period      = '';
        if ((int)$validity_period > 0) {
            $sql_period = ' AND datediff(NOW(),f.date_add) <= '.pSQL($validity_period);
        }

        $query = '
        SELECT f.id_order AS id, f.date_add AS date, (o.total_paid - o.total_shipping) total_without_shipping, f.points, f.id_loyalty, f.id_loyalty_state, fsl.name state, o.reference
        FROM `'._DB_PREFIX_.'totloyalty` f
        LEFT JOIN `'._DB_PREFIX_.'orders` o ON (f.id_order = o.id_order)
        LEFT JOIN `'._DB_PREFIX_.'totloyalty_state_lang` fsl ON (f.id_loyalty_state = fsl.id_loyalty_state AND fsl.id_lang = '.(int)($id_lang).')
        LEFT JOIN `'._DB_PREFIX_.'totloyalty_state` fs ON (fs.id_loyalty_state = fsl.id_loyalty_state)
        WHERE f.id_customer = '.(int)($id_customer).$sql_period;
        if ($onlyValidate === true) {
            $query .= ' AND f.id_loyalty_state = '.(int)TotLoyaltyState::getValidationId();
        }
        $query .= ' GROUP BY f.id_loyalty '.
            ($pagination ? 'LIMIT '.(((int)($page) - 1) * (int)($nb)).', '.(int)($nb) : '');

        return Db::getInstance()->executeS($query);
    }

    public static function getDiscountByIdCustomer($id_customer, $last = false)
    {
        $query = '
        SELECT f.id_cart_rule AS id_cart_rule, f.date_upd AS date_add
        FROM `'._DB_PREFIX_.'totloyalty` f
        LEFT JOIN `'._DB_PREFIX_.'orders` o ON (f.`id_order` = o.`id_order`)
        INNER JOIN `'._DB_PREFIX_.'cart_rule` cr ON (cr.`id_cart_rule` = f.`id_cart_rule`)
        WHERE f.`id_customer` = '.(int)($id_customer).'
        AND f.`id_cart_rule` > 0
        AND o.`valid` = 1
        GROUP BY f.id_cart_rule';
        if ($last) {
            $query .= ' ORDER BY f.id_loyalty DESC LIMIT 0,1';
        }

        return Db::getInstance()->executeS($query);
    }

    public static function registerDiscount($cartRule)
    {
        if (!Validate::isLoadedObject($cartRule)) {
            die(Tools::displayError('Incorrect object CartRule.'));
        }
        $items      = self::getAllByIdCustomer((int)$cartRule->id_customer, null, true);
        $associated = false;
        foreach ($items as $item) {
            $lm = new TotLoyalty((int)$item['id_loyalty']);

            /* Check for negative points for this order */
            $negativePoints = (int)Db::getInstance()->getValue('SELECT SUM(points) points FROM '._DB_PREFIX_.'totloyalty WHERE id_order = '.(int)$item['id'].' AND id_loyalty_state = '.(int)TotLoyaltyState::getCancelId().' AND points < 0');

            if ($lm->points + $negativePoints <= 0) {
                continue;
            }

            $lm->id_cart_rule     = (int)$cartRule->id;
            $lm->id_loyalty_state = (int)TotLoyaltyState::getConvertId();
            $lm->save();
            $associated = true;
        }

        return $associated;
    }

    public static function getOrdersByIdDiscount($id_cart_rule)
    {
        $items = Db::getInstance()->executeS('
        SELECT f.id_order AS id_order, f.points AS points, f.date_upd AS date
        FROM `'._DB_PREFIX_.'totloyalty` f
        WHERE f.id_cart_rule = '.(int)$id_cart_rule.' AND f.id_loyalty_state = '.(int)TotLoyaltyState::getConvertId());

        if (!empty($items) and is_array($items)) {
            foreach ($items as $key => $item) {
                $order                         = new Order((int)$item['id_order']);
                $items[$key]['id_currency']    = (int)$order->id_currency;
                $items[$key]['id_lang']        = (int)$order->id_lang;
                $items[$key]['total_paid']     = $order->total_paid;
                $items[$key]['total_shipping'] = $order->total_shipping;
            }

            return $items;
        }

        return false;
    }

    public static function getVoucher($id_cart_rule)
    {
        $query      = ' SELECT * FROM `'._DB_PREFIX_.'cart_cart_rule` WHERE `id_cart_rule` = '.(int)($id_cart_rule);
        $voucherdel = Db::getInstance()->executeS($query);
        if (empty($voucherdel)) {
            $items = Db::getInstance()->executeS('
            SELECT f.id_order AS id_order, f.points AS points, f.date_upd AS date
            FROM `'._DB_PREFIX_.'totloyalty` f
            WHERE f.id_cart_rule = '.(int)$id_cart_rule.' AND f.id_loyalty_state = '.(int)TotLoyaltyState::getConvertId());

            if (!empty($items) and is_array($items)) {
                foreach ($items as $key => $item) {
                    $order                         = new Order((int)$item['id_order']);
                    $items[$key]['id_currency']    = (int)$order->id_currency;
                    $items[$key]['id_lang']        = (int)$order->id_lang;
                    $items[$key]['total_paid']     = $order->total_paid;
                    $items[$key]['total_shipping'] = $order->total_shipping;
                }

                return $items;
            }
        }

        return false;
    }

    /* Register all transaction in a specific history table */
    private function historize()
    {
        Db::getInstance()->execute('
        INSERT INTO `'._DB_PREFIX_.'totloyalty_history` (`id_loyalty`, `id_loyalty_state`, `points`, `date_add`)
        VALUES ('.(int)($this->id).', '.(int)($this->id_loyalty_state).', '.(int)($this->points).', NOW())');
    }
}