<?php
defined('BASEPATH') or exit('No direct script access allowed');

class Wishlist_m extends CI_Model
{
    private $table = 'wishlists';

    public function __construct()
    {
        parent::__construct();
    }

    public function add_to_wishlist($data)
    {
        // Cek apakah produk sudah ada di wishlist
        $existing = $this->db->get_where($this->table, [
            'customer_id' => $data['customer_id'],
            'product_id' => $data['product_id'],
            'product_detail_id' => $data['product_detail_id']
        ])->row();

        if ($existing) {
            return false;
        }

        return $this->db->insert($this->table, $data);
    }

    public function get_customer_wishlist($customer_id)
    {
        $this->db->select('w.*, p.title, p.image, p.current_price, pd.variant');
        $this->db->from($this->table . ' w');
        $this->db->join('products p', 'w.product_id = p.id');
        $this->db->join('product_details pd', 'w.product_detail_id = pd.id');
        $this->db->where('w.customer_id', $customer_id);
        return $this->db->get()->result_array();
    }

    public function remove_from_wishlist($wishlist_id, $customer_id)
    {
        return $this->db->delete($this->table, [
            'id_wishlists' => $wishlist_id,
            'customer_id' => $customer_id
        ]);
    }

    public function get_all_wishlists()
    {
        return $this->db->select('*')
            ->from($this->table)
            ->get()
            ->result();
    }
}