<?php

namespace ADP\BaseVersion\Includes\CartProcessor;

use ADP\BaseVersion\Includes\Core\Cart\CartCustomer;
use ADP\BaseVersion\Includes\Context;
use WC_Order;

defined('ABSPATH') or exit;

class CartCustomerHelper
{
    /**
     * @var Context
     */
    protected $context;

    /**
     * @var CartCustomer
     */
    protected $cartCustomer;

    /**
     * @param Context|CartCustomer $contextOrCartCustomer
     * @param CartCustomer|null $deprecated
     */
    public function __construct($contextOrCartCustomer, $deprecated = null)
    {
        $this->context      = adp_context();
        $this->cartCustomer = $contextOrCartCustomer instanceof CartCustomer ? $contextOrCartCustomer : $deprecated;
    }

    public function withContext(Context $context)
    {
        $this->context = $context;
    }

    public function isLoggedIn()
    {
        $user         = $this->context->getCurrentUser();
        $cartCustomer = $this->cartCustomer;

        return $this->context->isUserLoggedIn() && $user->ID === $cartCustomer->getId();
    }

    /**
     * @param string $time
     *
     * @return int
     */
    public function getOrderCountAfter($time)
    {
        $time = $this->convertForStrToTime($time);

        if ($time === false) {
            return floatval(0);
        }

        // must ignore draft orders created by blocks-based cart
        $existing_orders_statuses = wc_get_order_statuses();
        if(isset($existing_orders_statuses['wc-checkout-draft']))
            unset($existing_orders_statuses['wc-checkout-draft']);

        $args = array(
            'post_status' => array_keys($existing_orders_statuses),
        );

        if ( ! empty($time)) {
            if ($this->context->isHPOSEnabled()) {
                $args['date_after'] = $time;
            } else {
                $args['date_query'] = array(
                    array(
                        'column' => 'post_date',
                        'after' => $time,
                    ),
                );
            }
        }

        return count($this->getOrderIds($args));
    }

    /**
     * @param string $time
     *
     * @return int
     */
    public function getOrderCountAfterPaidStatuses($time)
    {
        $time = $this->convertForStrToTime($time);

        if ($time === false) {
            return floatval(0);
        }

        $args = array(
            'post_status' => $this->getPreparedIsPaidOrderStatuses(),
        );

        if ( ! empty($time)) {
            if ($this->context->isHPOSEnabled()) {
                $args['date_after'] = $time;
            } else {
                $args['date_query'] = array(
                    array(
                        'column' => 'post_date',
                        'after' => $time,
                    ),
                );
            }
        }

        return count($this->getOrderIds($args));
    }

    /**
     * @return WC_Order|null
     */
    public function getLastPaidOrder()
    {
        $order_ids = $this->getOrderIds(array(
            'post_status' => array('wc-completed'),
            'numberposts' => 1,
            'orderby'     => 'date',
            'order'       => 'DESC',
        ));

        $order = wc_get_order(array_pop($order_ids));

        return $order instanceof WC_Order ? $order : null;
    }

    /**
     * @return bool
     */
    public function isFirstOrder()
    {
        $orderIds = $this->getOrderIds(array(
            'post_status' => $this->getPreparedIsPaidOrderStatuses(),
            'numberposts' => 1,
        ));

        return count($orderIds) > 0;
    }

    public function getRulesAplied()
    {
        global $wpdb;
        $orderIds = $this->getOrderIds(array(
            'post_status' => $this->getPreparedIsPaidOrderStatuses(),
        ));

        if(!count($orderIds)) {
            return [];
        }

        $tableStats = $wpdb->prefix . 'wdp_orders';
        $orderIds     = array_map('absint', $orderIds);
        $placeholders = implode(', ', array_fill(0, count($orderIds), '%d'));

        // $tableStats is a hardcoded internal table name; $placeholders contains only repeated %d tokens, built at runtime so PHPCS can't see them statically.
        // phpcs:disable WordPress.DB.DirectDatabaseQuery, WordPress.DB.PreparedSQL.InterpolatedNotPrepared, WordPress.DB.PreparedSQLPlaceholders.UnfinishedPrepare, PluginCheck.Security.DirectDB.UnescapedDBParameter
        $ids = $wpdb->get_col($wpdb->prepare(
            "SELECT DISTINCT rule_id FROM {$tableStats} WHERE order_id IN ({$placeholders})",
            $orderIds
        ));
        // phpcs:enable

        return $ids;
    }

    public function getOrderedProductIds()
    {
        $args = array();

        if ($this->cartCustomer->isGuest()) {
            if(!$this->cartCustomer->getBillingEmail() )
                return array();
            $args['billing_email'] = $this->cartCustomer->getBillingEmail();
        } else {
            $args['customer_id'] = $this->cartCustomer->getId();
        }

        $args = array_merge(array(
            'numberposts' => -1,
            'orderby'     => 'date',
            'order'       => 'DESC',
            'post_type'   => wc_get_order_types(),
            'post_status' => $this->getPreparedIsPaidOrderStatuses(),
            'limit'   => -1,
        ), $args);

        $orders = wc_get_orders($args);

        if(!count($orders)) {
            return [];
        }

        $productIds = [];

        foreach ($orders as $order) {
            foreach ($order->get_items() as $item) {
                $productIds[] = $item->get_product_id();
            }
        }

        return array_unique($productIds);
    }


    /**
     * @return bool
     */
    public function isRulesAplied()
    {
        // phpcs:ignore WordPress.DB.DirectDatabaseQuery, WordPress.DB.PreparedSQL.NotPrepared
        $ids = $this->getRulesAplied();

        return count($ids) > 0;
    }

    /**
     * @param string $time
     *
     * @return float
     */
    public function getTotalSpendAmount($time)
    {
        $time = $this->convertForStrToTime($time);

        if ($time === false) {
            return floatval(0);
        }

        $args = array(
            'post_status' => array('wc-completed'),
        );

        if ( ! empty($time)) {
            if(is_array($time)) {
                if ($this->context->isHPOSEnabled()) {
                    $args['date_after'] = $time[0];
                    $args['date_before'] = $time[1];
                } else {
                    $args['date_query'] = array(
                        array(
                            'column' => 'post_date',
                            'after' => $time[0],
                            'before' => $time[1],
                            'inclusive' => true
                        ),
                    );
                }
            } else if ($this->context->isHPOSEnabled()) {
                $args['date_after'] = $time;
            } else {
                $args['date_query'] = array(
                    array(
                        'column' => 'post_date',
                        'after' => $time,
                    ),
                );
            }
        }

        $order_ids = $this->getOrderIds($args);

        $orders = array_filter(array_map('wc_get_order', $order_ids));

        if ( ! count($orders)) {
            return floatval(0);
        }

        return array_sum(array_map(function ($order) {
            /**
             * @var $order WC_Order
             */
            return $order->get_total() - $order->get_total_refunded();
        }, $orders));
    }

    /**
     * @return float
     */
    public function getAvgSpendAmount()
    {
        $order_ids = $this->getOrderIds(array(
            'post_status' => array('wc-completed'),
        ));

        $orders = array_filter(array_map('wc_get_order', $order_ids));

        if ( ! count($orders)) {
            return floatval(0);
        }

        return array_sum(array_map(function ($order) {
                return $order->get_total();
            }, $orders)) / count($orders);
    }

    /**
     * @param array $args
     *
     * @return array<int,int>
     */
    protected function getOrderIds($args = array()): array
    {

        if ($this->cartCustomer->isGuest()) {
            if(!$this->cartCustomer->getBillingEmail() )
                return array();
            $args['billing_email'] = $this->cartCustomer->getBillingEmail();
        } else {
            $args['customer_id'] = $this->cartCustomer->getId();
        }

        $args = array_merge(array(
            'numberposts' => -1,
            'orderby'     => 'date',
            'order'       => 'DESC',
            'post_type'   => wc_get_order_types(),
            'post_status' => array_keys(wc_get_order_statuses()),
            'return'      => 'ids',

        ), $args);

        return wc_get_orders($args);
    }

    /**
     * @return array<int,string>
     */
    protected function getPreparedIsPaidOrderStatuses()
    {
        return array_map(function ($status) {
            return 'wc-' !== substr($status, 0, 3) ? 'wc-' . $status : $status;
        }, wc_get_is_paid_statuses());
    }

    /**
     * @param string $time
     *
     * @return false|int|string
     */
    public function convertForStrToTime($time)
    {
        if ( ! $time or ! is_string($time)) {
            return false;
        }

        if ('all_time' == $time) {
            $time = 0;
        } elseif ('now' == $time) {
            $time = 'today';
        } elseif ('this week' == $time) {
            $time = 'last monday';
        } elseif ('this month' == $time) {
            $time = 'first day of ' . gmdate('F Y', current_time('timestamp'));
        } elseif ('this year' == $time) {
            $time = 'first day of January ' . gmdate('Y', current_time('timestamp'));
        } elseif ('last week' == $time) {
            $time = ['last week monday 00:00:00', 'last week sunday 23:59:59'];
        } elseif ('last month' == $time) {
            $time = ['first day of last month 00:00:00', 'last day of last month 23:59:59'];
        } elseif ('last year' == $time) {
            $time = ['first day of january last year 00:00:00', 'last day of december last year 23:59:59'];
        }

        return $time;
    }
}