<?php
/**
 * Mageplaza
 *
 * NOTICE OF LICENSE
 *
 * This source file is subject to the Mageplaza.com license that is
 * available through the world-wide-web at this URL:
 * https://www.mageplaza.com/LICENSE.txt
 *
 * DISCLAIMER
 *
 * Do not edit or add to this file if you wish to upgrade this extension to newer
 * version in the future.
 *
 * @category    Mageplaza
 * @package     Mageplaza_AbandonedCart
 * @copyright   Copyright (c) Mageplaza (https://www.mageplaza.com/)
 * @license     https://www.mageplaza.com/LICENSE.txt
 */

namespace Mageplaza\AbandonedCart\Model;

use Magento\Framework\Api\DataObjectHelper;
use Magento\Framework\App\ResourceConnection;
use Magento\Framework\Stdlib\DateTime\DateTime;
use Magento\Newsletter\Model\ResourceModel\Subscriber as SubscriberResource;
use Magento\Newsletter\Model\Subscriber;
use Magento\Newsletter\Model\SubscriberFactory;
use Mageplaza\AbandonedCart\Helper\Data;

/**
 * Class Token
 * @package Mageplaza\AbandonedCart\Model
 */
class Token
{
    /**
     * Date model
     *
     * @var DateTime
     */
    protected $date;

    /**
     * @var ResourceConnection
     */
    protected $resource;

    /**
     * @var SubscriberFactory
     */
    protected $subscriberFactory;

    /**
     * @var Data
     */
    protected $helper;

    /**
     * @var DataObjectHelper
     */
    private $dataObjectHelper;

    /**
     * @var SubscriberResource
     */
    private $subscriberResource;

    /**
     * Token constructor.
     *
     * @param DateTime $date
     * @param ResourceConnection $resource
     * @param Data $helper
     * @param SubscriberFactory $subscriberFactory
     * @param DataObjectHelper $dataObjectHelper
     * @param SubscriberResource $subscriberResource
     */
    public function __construct(
        DateTime $date,
        ResourceConnection $resource,
        Data $helper,
        SubscriberFactory $subscriberFactory,
        DataObjectHelper $dataObjectHelper,
        SubscriberResource $subscriberResource
    ) {
        $this->resource = $resource;
        $this->date = $date;
        $this->subscriberFactory = $subscriberFactory;
        $this->helper = $helper;
        $this->dataObjectHelper = $dataObjectHelper;
        $this->subscriberResource = $subscriberResource;
    }

    /**
     * @param int $quoteId
     * @param string $configId
     * @param string $token
     *
     * @return void
     */
    public function saveToken($quoteId, $configId, $token)
    {
        $bind = [
            'quote_id' => $quoteId,
            'config_id' => $configId,
            'checkout_token' => $token,
            'checkout_token_created_at' => $this->date->date()
        ];
        $this->resource->getConnection()->insert(
            $this->resource->getTableName('mageplaza_abandonedcart_logs_token'),
            $bind
        );
    }

    /**
     * @param int|null $quoteId
     * @param string|null $token
     *
     * @return bool
     */
    public function validateCartLink($quoteId = null, $token = null)
    {
        if ($quoteId == null || $token == null) {
            return false;
        }
        $connection = $this->resource->getConnection();
        $select = $connection->select()
            ->from($this->resource->getTableName('mageplaza_abandonedcart_logs_token'))
            ->where('checkout_token = :checkout_token')
            ->where('quote_id = :quote_id');
        $bind = [
            'checkout_token' => $token,
            'quote_id' => $quoteId
        ];
        $result = $connection->fetchOne($select, $bind);

        return !empty($result);
    }

    /**
     * Check if an email has been sent to the customer.
     *
     * @param $quoteId
     * @param $configId
     * @param $quoteUpdatedTime
     * @return bool
     */
    public function validateEmailHasSend($quoteId, $configId, $quoteUpdatedTime)
    {
        $connection = $this->resource->getConnection();
        $select = $connection->select()
            ->from($this->resource->getTableName('mageplaza_abandonedcart_logs_token'))
            ->where('config_id = :config_id')
            ->where('quote_id = :quote_id')
            ->where('checkout_token_created_at > :checkout_token_created_at');
        $hasSent = $connection->fetchOne($select, ['config_id' => $configId, 'quote_id' => $quoteId, 'checkout_token_created_at' => $quoteUpdatedTime]);

        return empty($hasSent);
    }

    /**
     * Check customer is subscribed
     *
     * @param $customerEmail
     * @return bool
     */
    public function isSubscribed($customerEmail)
    {
        $connection = $this->resource->getConnection();
        $tableName = $connection->getTableName('newsletter_subscriber');

        $select = $connection->select()
            ->from($tableName, ['subscriber_status'])
            ->where('subscriber_email = ?', $customerEmail)
            ->limit(1);

        $status = (int) $connection->fetchOne($select);

        return $status === Subscriber::STATUS_SUBSCRIBED;
    }
}