<?php

/**
 * Description of ProductImport
 *
 * @author Ali2Woo Team
 */

namespace AliNext_Lite;;

class ProductImport {

    private $order;
    private $order_dir;

    public function add_product($product) {
        if (!isset($product['import_id']) || !$product['import_id']) {
            // 1.7.0 for compatibility with older versions
            $product['import_id'] = $product[ImportedProductService::FIELD_EXTERNAL_PRODUCT_ID];
        }

        if (!isset($product['date_add'])) {
            $product['date_add'] = gmdate('Y-m-d H:i:s');
        }

        $this->save_product($product['import_id'], $product);

        return "ok";
    }

    public function upd_product($product, $merge=true) {
        if(!isset($product['import_id']) || !$product['import_id']){
            // 1.7.0 for compatibility with older versions
            $product['import_id'] = $product[ImportedProductService::FIELD_EXTERNAL_PRODUCT_ID];
        }

        $product_id_list = $this->get_product_id_list();

        if (in_array($product['import_id'], $product_id_list)) {
            $product = $merge?array_merge($this->get_product($product['import_id']), $product):$product;
            $this->save_product($product['import_id'], $product);
        }

        return $product;
    }

    public function del_product($product_id, $processing = false) {
        if (!is_array($product_id)) {
            $to_del = array($product_id);
        } else {
            $to_del = $product_id;
        }

        if ($to_del) {
            foreach ($to_del as $did) {
                a2wl_delete_transient('a2wl_'.($processing?'processing_':'').'product#' . strval($did));
            }
        }
    }

    public function move_to_processing($product_id) {
        $product = $this->get_product($product_id);
        if($product) {
            $this->save_product($product_id, $product, true);
            $this->del_product($product_id);
        }
    }

    public function save_product($product_id, $product, $processing = false): void
    {
        $transientName = 'a2wl_' . ($processing ? 'processing_' : '') . 'product#' . strval($product_id);
        a2wl_set_transient($transientName, $product);
    }

    public function get_product($product_id, $processing = false) {
        $product = a2wl_get_transient('a2wl_' . ($processing ? 'processing_' : '') . 'product#' . strval($product_id));
        if ($product) {
          /*  if (!isset($product[ImportedProductService::FIELD_EXTERNAL_PRODUCT_ID])) {
                return [];
            }*/
            if (!isset($product['import_id']) || !$product['import_id']) {
                // 1.7.0 for compatibility with older versions
                $product['import_id'] = $product[ImportedProductService::FIELD_EXTERNAL_PRODUCT_ID];
            }
            if (!isset($product['product_type'])) {
                $product['product_type'] = get_setting('default_product_type');
            }
            if (!isset($product['product_status'])) {
                $product['product_status'] = get_setting('default_product_status');
            }
            if (!isset($product['tags'])) {
                $product['tags'] = [];
            }
            if (!isset($product['categories'])) {
                $product['categories'] = [];
            }
            if (!isset($product['skip_images'])) {
                $product['skip_images'] = [];
            }
            if (!isset($product['skip_vars'])) {
                $product['skip_vars'] = [];
            }
            if (empty($product['images'])) {
                $product['images'] = [];
            }
            if (empty($product['original_attr_cache'])) {
                $product['original_attr_cache'] = [];
            }
            if (!isset($product['disable_sync'])) {
                $product['disable_sync'] = false;
            }
            if (!isset($product['disable_var_price_change'])) {
                $product['disable_var_price_change'] = false;
            }
            if (!isset($product['disable_var_quantity_change'])) {
                $product['disable_var_quantity_change'] = false;
            }
            if (!isset($product['date_add'])) {
                $product['date_add'] = gmdate('1981-12-29');
            }
            if (!isset($product['tmp_move_images'])) {
                $product['tmp_move_images'] = [];
            }
            if (!isset($product['tmp_copy_images'])) {
                $product['tmp_copy_images'] = [];
            }
            if (!isset($product['tmp_edit_images'])) {
                $product['tmp_edit_images'] = [];
            }
            if (!isset($product[ImportedProductService::FIELD_SHIPPING_INFO])) {
                $product[ImportedProductService::FIELD_SHIPPING_INFO] = [];
            }

            return $product;
        }

        return false;
    }

    /**
     * @throws ServiceException
     */
    public function getProduct($product_id, $processing = false): array
    {
        $product = $this->get_product($product_id, $processing);

        if ($product !== false && is_array($product)) {

            return $product;
        }

        throw new ServiceException(
            __('Invalid external product ID provided.', 'ali2woo')
        );
    }


    public function get_product_list($with_html = true, $search = '', $sort = '', $limit = null, $ofset = null): array
    {
        $product_id_list = $this->get_product_id_list($limit, $ofset);
        $products = array();

        foreach ($product_id_list as $product_id) {
            $product = $this->get_product($product_id);
            if ($product) {
                if (isset($product['html']) && $product['html']) {
                    if (!$with_html) {
                        $product['html'] = "#hidden#";
                    }
                } else {
                    $product['html'] = "#needload#";
                }

                if (empty($search) || str_contains($product['title'], strval($search)) || str_contains($product[ImportedProductService::FIELD_EXTERNAL_PRODUCT_ID], strval($search))) {
                    $products[$product_id] = $product;
                }
                unset($product);
            }
        }
        unset($product_id_list);

        $this->init_sort($sort);
        uasort($products, array($this, 'custom_sort'));

        return $products;
    }

    public function get_product_id_list($limit=null, $ofset=null): array
    {
        global $wpdb;

        $limitStr = "";
        if (isset($limit)) {
            $offsetStr = '';
            if ($ofset) {
                $offsetStr = $wpdb->prepare("%d, ", $ofset);
            }
            // phpcs:ignore WordPress.DB.PreparedSQL.NotPrepared
            $limitStr = $wpdb->prepare("LIMIT " . $offsetStr . "%d", $limit);
        }
        if (a2wl_check_defined('A2WL_SAVE_TRANSIENT_AS_OPTION')) {
            $results = $wpdb->get_results($wpdb->prepare(
                // phpcs:ignore WordPress.DB.PreparedSQL.InterpolatedNotPrepared
                "SELECT option_name FROM {$wpdb->options} WHERE option_name LIKE %s ORDER BY option_id $limitStr",
                $wpdb->esc_like('a2wl_product#') . '%'),
                ARRAY_A);
        } else {
            $results = $wpdb->get_results($wpdb->prepare(
                // phpcs:ignore WordPress.DB.PreparedSQL.InterpolatedNotPrepared
                "select option_name from {$wpdb->options} where option_name like %s order by option_id $limitStr",
                $wpdb->esc_like('_transient_a2wl_product#') . '%'),
                ARRAY_A);
        }
        $ids = array();
        foreach ($results as $r) {
            $tmp = explode("#", $r['option_name']);
            if (count($tmp) == 2) {
                $ids[] = $tmp[1];
            }
        }

        return $ids;
    }
    
    public function get_products_count(): int
    {
        global $wpdb;

        if (a2wl_check_defined('A2WL_SAVE_TRANSIENT_AS_OPTION')) {
            $result = $wpdb->get_var("select count(option_id) from {$wpdb->options} where option_name like 'a2wl_product#%'");
        } else {
            $result = $wpdb->get_var("select count(option_id) from {$wpdb->options} where option_name like '_transient_a2wl_product#%'");
        }

        if (!$result) {
            return 0;
        }

        return (int) $result;
    }

    public function default_sort(): string
    {
        return 'date_add-asc';
    }
    
    public function sort_list(): array
    {
        return [
            'id-asc' => esc_html__('Sort by External Id', 'ali2woo'),
            'title-asc' => esc_html__('Sort by Product title', 'ali2woo'),
            'date_add-asc' => esc_html__('Sort by Date add (old first)', 'ali2woo'),
            'date_add-desc' => esc_html__('Sort by Date add (new first)', 'ali2woo'),
            
        ];
    }

    public function init_sort($sort): void
    {
        if (empty($sort)) {
            $sort = $this->default_sort();
        }
        
        if (in_array($sort, array_keys($this->sort_list()))) {
            $sv = explode("-", strtolower($sort));
            $this->order = $sv[0];
            $this->order_dir = $sv[1];
        }
    }

    private function custom_sort($a, $b): int
    {
        if ($a[$this->order] == $b[$this->order]) {
            return 0;
        }
        return (($a[$this->order] < $b[$this->order]) ? -1 : 1) * ($this->order_dir == 'asc' ? 1 : -1);
    }

}