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



class Welcome extends Public_Controller

{



	public function __construct()

	{

		parent::__construct();

		$this->load->library('GoogleClient');

		$this->load->library('VisitorTracking');

		$this->load->model('comment_m');

		$this->load->library(['session', 'form_validation']);

		$this->load->helper('url');

		$this->load->model('customer_m');

		$this->load->helper('cart');

		$this->load->model('Top_banner_m');

		$this->load->model('Statistic_m');

		$this->load->model('Carousel_banner_m');

		$this->load->model('Category_m');

		$this->load->model('Review_m');

		$this->load->model('Brand_m');

		$this->load->model('Footer_m');



		if ($this->session->userdata('site_lang') == 'english') {

			$this->lang->load('register_login', 'english');

			$this->lang->load('homepage', 'english');

			$this->lang->load('mainpage', 'english');

		} else {

			$this->lang->load('register_login', 'indonesian');

			$this->lang->load('homepage', 'indonesian');

			$this->lang->load('mainpage', 'indonesian');

		}

		// $this->data['comments'] = $this->comment_m->get_comments();



		$loginUrl = $this->googleclient->getLoginUrl();



		$this->data_footer['googleUrl'] = $loginUrl;



		$ip_address = $this->input->ip_address();

		$data = array(

			'ip_address' => $ip_address

		);

		$this->db->insert('visits', $data);

		$this->visitortracking->trackVisitor();

	}



	public function index()

	{

		$this->load->driver('cache', array('adapter' => 'file', 'backup' => 'file'));

		$website_data = $this->cache->get('website_config');

		if (!$website_data) {

			$website_data = $this->db->select('website_icon, browser_title, meta_description')

				->from('configuration')

				->where('id_configuration', 1)

				->get()

				->row();



			// Cache for 24 hours

			$this->cache->save('website_config', $website_data, 86400);

		}



		if ($this->session->userdata('site_lang') == 'english') {

			$this->lang->load('mainpage', 'english');

		} else {

			$this->lang->load('mainpage', 'indonesian');

		}



		$this->visitortracking->trackVisitor();



		if ($this->session->userdata('customer')) {

			$id_customer = (int) $this->session->userdata('customer')['customer_id'];

			$this->data['customer'] = $this->customer_m->get_customer($id_customer);

		}



		$static_content = $this->cache->get('homepage_static_content');

		if (!$static_content) {

			$static_content = [

				'carousels' => $this->Carousel_banner_m->get_active_carousel(),

				'banners' => $this->Top_banner_m->get_active_banners(),

				'brands' => $this->Brand_m->get_all_brands(),

				'comments' => $this->comment_m->get_comments()

			];



			// Cache for 2 hours

			$this->cache->save('homepage_static_content', $static_content, 7200);

		}



		$testimonials = $this->cache->get('homepage_testimonials');

		if (!$testimonials) {

			// Your existing testimonials query

			$this->db->select('DISTINCT(stock.id_product) as id_product');

			$this->db->from('stock');

			$this->db->where('warehouse_id', 1);

			$this->db->where('(stock - stock_keep) >', 0);

			$available_products = $this->db->get_compiled_select();



			$this->db->select('

				product_review.id,

				product_review.rating,

				product_review.display_name as customer_name,

				product_review.review as testimonial_text,

				products.title as product_name,

				products.alias as product_alias,

				products.id_products as product_id,

				customers.sex_type

			');



			$stock_subquery = "(SELECT SUM(stock - stock_keep) 

                           FROM stock 

                           WHERE stock.id_product = product_review.product_id 

                           AND stock.warehouse_id = 1) as stock_sell";

			$this->db->select($stock_subquery, FALSE);



			$this->db->from('product_review');

			$this->db->join('products', 'product_review.product_id = products.id_products');

			$this->db->join('customers', 'product_review.customer_id = customers.id_customers');

			$this->db->join("($available_products) as available_products", 'product_review.product_id = available_products.id_product');



			$exists_subquery = "EXISTS (

				SELECT 1 

				FROM stock 

				WHERE stock.id_product = product_review.product_id 

				AND stock.warehouse_id = 1 

				AND (stock.stock - stock.stock_keep) > 0

			)";

			$this->db->where($exists_subquery, NULL, FALSE);

			$this->db->where('product_review.id IN (

				SELECT MAX(pr.id) 

				FROM product_review pr 

				GROUP BY pr.product_id

			)');



			$this->db->order_by('product_review.id', 'DESC');

			$this->db->limit(20);

			$reviews = $this->db->get()->result();



			$testimonials = [];

			foreach ($reviews as $review) {

				switch ($review->sex_type) {

					case 'male':

						$image = "https://storage.googleapis.com/laciasmara-photos/laciasmara_test/Laciasmara_testimonial/male.png";

						break;

					case 'female':

						$image = "https://storage.googleapis.com/laciasmara-photos/laciasmara_test/Laciasmara_testimonial/female.png";

						break;

					default:

						$image = "https://storage.googleapis.com/laciasmara-photos/laciasmara_test/Laciasmara_testimonial/others.png";

				}



				$testimonials[] = [

					'customer_image' => $image,

					'customer_name' => $review->customer_name,

					'product_name' => $review->product_name,

					'product_link' => base_url('product/' . $review->product_alias),

					'star_rating' => $review->rating,

					'testimonial_text' => $review->testimonial_text,

				];

			}



			// Cache testimonials for 30 minutes

			$this->cache->save('homepage_testimonials', $testimonials, 1800);

		}



		$products_data = $this->cache->get('homepage_products');

		if (!$products_data) {



			// Top seller products query

			$this->db->cache_on();

			$this->db->select('

            p.id_products, 

            p.title, 

            p.alias,

            p.brand_id,

            p.created_at,

            pd.id AS id_detail, 

            pd.price, 

            pd.discounted_price, 

            pd.sku,

            COALESCE(GROUP_CONCAT(DISTINCT CONCAT_WS(": ", pa.product_attribute, pad.attribute_detail) SEPARATOR "; "), "No variants available") AS variants,

            pi.image AS image, 

            pi_secondary.image AS image_secondary,

            pc.attribute_detail_id, 

            s.stock, 

            s.stock_keep, 

            (s.stock - s.stock_keep) AS stock_sell,

            SUM(od.quantity) AS total_sales,

            COUNT(pr.id) AS total_reviews,

            CASE 

                WHEN pd.discounted_price IS NOT NULL AND pd.discounted_price > 0 AND pd.discounted_price < pd.price 

                THEN (pd.price - pd.discounted_price)

                ELSE 0 

            END AS savings_amount,

            CASE 

                WHEN pd.discounted_price IS NOT NULL AND pd.discounted_price > 0 AND pd.discounted_price < pd.price 

                THEN ROUND(((pd.price - pd.discounted_price) / pd.price) * 100, 0)

                ELSE 0 

            END AS discount_percentage,

            

            -- Badges Information (Added)

            COALESCE(product_badges_data.badges_names, "") AS badges_names,

            COALESCE(product_badges_data.badges_data, "") AS badges_data,

            COALESCE(product_badges_data.badges_count, 0) AS badges_count

        ')

				->from('products p')

				->join('product_details pd', 'p.id_products = pd.product_id', 'left')

				->join('product_images pi', 'pd.id = pi.product_details_id AND pi.priority = 1 AND pi.status = 1', 'left')

				->join('product_images pi_secondary', 'pd.id = pi_secondary.product_details_id AND pi_secondary.priority = 2 AND pi_secondary.status = 1', 'left')

				->join('stock s', 'pd.id = s.id_product_detail AND s.warehouse_id = 1', 'left')

				->join('orders_detail od', 'od.item_id = pd.id AND od.warehouse_id = 1', 'left')

				->join('product_combination pc', 'pd.id = pc.product_details_id', 'left')

				->join('product_attributes pa', 'pc.attribute_id = pa.id', 'left')

				->join('product_attributes_detail pad', 'pc.attribute_detail_id = pad.id', 'left')

				->join('product_review pr', 'pr.product_id = p.id_products', 'left')



				// Product Badges Join (Added)

				->join('(SELECT 

                pb.product_id,

                COUNT(pb.badge_id) AS badges_count,

                GROUP_CONCAT(b.name ORDER BY pb.priority ASC SEPARATOR ", ") AS badges_names,

                GROUP_CONCAT(

                    CONCAT(

                        b.id, ":", 

                        b.name, ":", 

                        b.slug, ":", 

                        IFNULL(b.description, ""), ":", 

                        IFNULL(b.background_color, "#FF6B6B"), ":", 

                        IFNULL(b.text_color, "#FFFFFF"), ":", 

                        IFNULL(b.icon, ""), ":", 

                        pb.position, ":", 

                        pb.priority

                    )

                    ORDER BY pb.priority ASC

                    SEPARATOR "|"

                ) AS badges_data

            FROM product_badges pb

            INNER JOIN badges b ON pb.badge_id = b.id

            WHERE pb.is_active = 1 

                AND b.is_active = 1

                AND (pb.start_date IS NULL OR pb.start_date <= NOW())

                AND (pb.end_date IS NULL OR pb.end_date >= NOW())

            GROUP BY pb.product_id) product_badges_data', 'p.id_products = product_badges_data.product_id', 'left')



				->where('p.product_status', '1')

				->where('p.deleted_at', null)

				->where('s.stock > 1')

				->where('(s.stock - s.stock_keep) > 0')

				->group_by('p.id_products')

				->order_by('total_reviews', 'DESC');

			$top_seller_products = $this->db->get()->result_array();



			// New arrival products query

			$this->db->select('

            p.id_products, 

            p.title, 

            p.alias,

            p.brand_id,

            p.created_at,

            pd.id AS id_detail, 

            pd.price, 

            pd.discounted_price, 

            pd.sku,

            COALESCE(GROUP_CONCAT(DISTINCT CONCAT_WS(": ", pa.product_attribute, pad.attribute_detail) SEPARATOR "; "), "No variants available") AS variants,

            pi.image AS image, 

            pi_secondary.image AS image_secondary,

            pc.attribute_detail_id, 

            s.stock, 

            s.stock_keep,

            s.stock_reject,

            s.stock_sample,

            (s.stock - s.stock_keep - COALESCE(s.stock_reject, 0) - COALESCE(s.stock_sample, 0)) as stock_sell,

            SUM(od.quantity) AS total_sales,

            COUNT(pr.id) AS total_reviews,

            CASE 

                WHEN pd.discounted_price IS NOT NULL AND pd.discounted_price > 0 AND pd.discounted_price < pd.price 

                THEN (pd.price - pd.discounted_price)

                ELSE 0 

            END AS savings_amount,

            CASE 

                WHEN pd.discounted_price IS NOT NULL AND pd.discounted_price > 0 AND pd.discounted_price < pd.price 

                THEN ROUND(((pd.price - pd.discounted_price) / pd.price) * 100, 0)

                ELSE 0 

            END AS discount_percentage,

            

            -- Badges Information (Added)

            COALESCE(product_badges_data.badges_names, "") AS badges_names,

            COALESCE(product_badges_data.badges_data, "") AS badges_data,

            COALESCE(product_badges_data.badges_count, 0) AS badges_count

        ')

				->from('products p')

				->join('product_details pd', 'p.id_products = pd.product_id', 'left')

				->join('product_images pi', 'pd.id = pi.product_details_id AND pi.priority = 1 AND pi.status = 1', 'left')

				->join('product_images pi_secondary', 'pd.id = pi_secondary.product_details_id AND pi_secondary.priority = 2 AND pi_secondary.status = 1', 'left')

				->join('stock s', 'pd.id = s.id_product_detail AND s.warehouse_id = 1', 'left')

				->join('orders_detail od', 'od.item_id = pd.id AND od.warehouse_id = 1', 'left')

				->join('product_combination pc', 'pd.id = pc.product_details_id', 'left')

				->join('product_attributes pa', 'pc.attribute_id = pa.id', 'left')

				->join('product_attributes_detail pad', 'pc.attribute_detail_id = pad.id', 'left')

				->join('product_review pr', 'pr.product_id = p.id_products', 'left')

				->join('category_product cp', 'p.id_products = cp.id_product', 'inner')

				->join('categories c', 'cp.id_category = c.id_categories', 'inner')



				// Product Badges Join (Added)

				->join('(SELECT 

                pb.product_id,

                COUNT(pb.badge_id) AS badges_count,

                GROUP_CONCAT(b.name ORDER BY pb.priority ASC SEPARATOR ", ") AS badges_names,

                GROUP_CONCAT(

                    CONCAT(

                        b.id, ":", 

                        b.name, ":", 

                        b.slug, ":", 

                        IFNULL(b.description, ""), ":", 

                        IFNULL(b.background_color, "#FF6B6B"), ":", 

                        IFNULL(b.text_color, "#FFFFFF"), ":", 

                        IFNULL(b.icon, ""), ":", 

                        pb.position, ":", 

                        pb.priority

                    )

                    ORDER BY pb.priority ASC

                    SEPARATOR "|"

                ) AS badges_data

            FROM product_badges pb

            INNER JOIN badges b ON pb.badge_id = b.id

            WHERE pb.is_active = 1 

                AND b.is_active = 1

                AND (pb.start_date IS NULL OR pb.start_date <= NOW())

                AND (pb.end_date IS NULL OR pb.end_date >= NOW())

            GROUP BY pb.product_id) product_badges_data', 'p.id_products = product_badges_data.product_id', 'left')



				->where('p.product_status', '1')

				->where('p.deleted_at', null)

				->where('s.stock > 1')

				->where('(s.stock - s.stock_keep) > 0')

				->where('(s.stock - s.stock_keep) > 0')

				->where('c.alias', 'pendatang-baru')

				->where('c.alias_en', 'new-arrivals')

				->group_by('p.id_products')

				->order_by('p.created_at', 'DESC');

			$new_arrival_products = $this->db->get()->result_array();

			$this->db->cache_off();



			// Prepare and format product data

			$products_data = [

				'top_seller_products' => $this->prepare_all_products_optimized($top_seller_products),

				'new_products' => $this->prepare_all_products_optimized($new_arrival_products)

			];



			// Cache products for 15 minutes

			$this->cache->save('homepage_products', $products_data, 900);

		}



		$footer_data = $this->cache->get('homepage_footer');

		if (!$footer_data) {

			$footer_data = [

				'footer_categories' => $this->Footer_m->get_all_categories(),

				'footer_social_media' => $this->Footer_m->get_social_media(),

				'footer_payment_methods' => $this->Footer_m->get_payment_methods(),

				'footer_asmaradoor' => $this->Footer_m->get_asmaradoor(),

				'footer_bottom' => $this->Footer_m->get_footer_bottom()

			];



			// Cache footer for 6 hours

			$this->cache->save('homepage_footer', $footer_data, 21600);

		}



		// Prepare header data

		$this->data_header = array_merge([

			'website_icon' => $website_data->website_icon,

			'browser_title' => $website_data->browser_title,

			'meta_description' => $website_data->meta_description,

			'logo_path' => 'https://storage.googleapis.com/laciasmara-photos/laciaasmara_assets/laciasmara_landing_page/laciasmara_landing_page_logo.webp',

			'is_mobile' => $this->isMobile()

		], $static_content, $products_data, $footer_data, [

			'testimonials' => $testimonials

		]);



		$this->data_footer['popular_categories'] = $this->Category_m->get_footer_popular_categories();

		$this->data_footer['trending_searches'] = $this->Statistic_m->get_trending_searches();



		$this->data['comments'] = $static_content['comments'];

		// Load views

		$this->load->view("themes/3/header_new", $this->data_header);

		$this->load->view('themes/3/welcome');

		$this->load->view("themes/3/footer_new", $this->data_footer);

	}



	function isMobile()

	{

		$userAgent = $_SERVER['HTTP_USER_AGENT'];

		$mobileKeywords = array(

			'Mobile',

			'Android',

			'iPhone',

			'iPod',

			'BlackBerry',

			'Windows Phone',

			'Opera Mini'

		);



		foreach ($mobileKeywords as $keyword) {

			if (strpos($userAgent, $keyword) !== false) {

				return true;

			}

		}

		return false;

	}



	private function prepare_all_products_optimized($products)

	{

		$customer = $this->session->userdata('customer');

		$is_reseller = false;

		$reseller_price_map = [];



		// Get reseller information (existing code)

		if (!empty($customer['customer_id'])) {

			$customer_id = $customer['customer_id'];

			$customer_data = $this->db->where('id_customers', $customer_id)->get('customers')->row_array();

			if (!empty($customer_data['reseller_id'])) {

				$reseller = $this->db->where('id_resellers', $customer_data['reseller_id'])->get('resellers')->row_array();

				if ($reseller) {

					$is_reseller = true;

					$reseller_prices = $this->db->where('reseller_id', $reseller['id_resellers'])->get('resellers_price')->result_array();

					foreach ($reseller_prices as $price) {

						$reseller_price_map[$price['product_detail_id']] = $price['price'];

					}

				}

			}

		}



		$formatted_products = [];



		foreach ($products as $product) {

			// Price calculations

			$is_discounted = $product['discounted_price'] > 0;

			$default_price = $product['price'];

			$discounted_price = $product['discounted_price'];

			$current_price = $is_discounted ? $discounted_price : $default_price;

			$msrp_price = null;



			// Handle reseller pricing

			if ($is_reseller && isset($reseller_price_map[$product['id_detail']])) {

				$msrp_price = $current_price;

				$current_price = $reseller_price_map[$product['id_detail']];

			}



			// Get reviews

			$review_data = $this->Review_m->get_product_reviews($product['id_products']);

			$average_rating = isset($review_data['average_rating']) ? round($review_data['average_rating'], 1) : 0;

			$total_reviews = isset($review_data['total_reviews']) ? $review_data['total_reviews'] : 0;



			// Parse variants

			$variants = !empty($product['variants']) ? explode('; ', $product['variants']) : [];



			$badges = $this->parse_badges_data($product['badges_data'] ?? '');

			$badges_names = $product['badges_names'] ?? '';



			// Stock calculations - all done in SQL now, just ensure non-negative values

			$current_variant_stock_sell = max(0, intval($product['current_variant_stock_sell'] ?? 0));

			$total_stock_sell = max(0, intval($product['total_stock_sell'] ?? 0));



			$formatted_products[] = [

				'id' => $product['id_products'],

				'title' => $product['title'],

				'id_detail' => $product['id_detail'],

				'alias' => $product['alias'],

				'sku' => $product['sku'],

				'current_price' => $current_price,

				'original_price' => $is_discounted ? $default_price : null,

				'msrp_price' => $msrp_price,

				'image' => $product['image'],

				'image_secondary' => $product['image_secondary'],

				'stock' => $product['total_stock'],

				'stock_sell' => $current_variant_stock_sell,

				'total_stock_sell' => $total_stock_sell,

				'average_rating' => $average_rating,

				'total_reviews' => $total_reviews,

				'variants' => $variants,

				'is_wishlisted' => $this->_check_wishlist_status($product['id_products'], $customer['customer_id'] ?? null),

				'created_at' => $product['created_at'],

				'brand_priority' => $product['brand_priority'],

				'savings_amount' => $product['savings_amount'],

				'is_discounted' => $is_discounted,

				'discount_percentage' => $product['discount_percentage'],



				// Stock flags - now calculated in SQL

				'is_completely_sold_out' => (bool) $product['is_completely_sold_out'],

				'current_variant_out_of_stock' => (bool) $product['current_variant_out_of_stock'],

				'has_other_variants_available' => (bool) $product['has_other_variants_available'],



				// Additional stock information

				'total_variants' => (int) $product['total_variants'],

				'available_variants' => (int) $product['available_variants'],



				// Badges

				'badges' => $badges,

				'badges_names' => $badges_names, // Simple comma-separated names for quick display

				'badges_count' => (int) ($product['badges_count'] ?? 0),

				'has_badges' => !empty($badges),



				// New arrivals flag for badges

				'new_arrivals' => ($product['new_arrival'] === 'yes'),

				'best_seller' => ($product['best_seller'] === 'yes'),

				'popular_product' => ($product['popular_product'] === 'yes'),

			];

		}



		return $formatted_products;

	}



	private function parse_badges_data($badges_data)

	{

		$badges = [];



		if (empty($badges_data)) {

			return $badges;

		}



		$badges_raw = explode('|', $badges_data);



		foreach ($badges_raw as $badge_raw) {

			if (empty($badge_raw)) continue;



			$badge_parts = explode(':', $badge_raw);



			if (count($badge_parts) >= 9) {

				$badges[] = [

					'id' => (int) $badge_parts[0],

					'name' => $badge_parts[1],

					'slug' => $badge_parts[2],

					'description' => $badge_parts[3],

					'background_color' => !empty($badge_parts[4]) ? $badge_parts[4] : '#FF6B6B',

					'text_color' => !empty($badge_parts[5]) ? $badge_parts[5] : '#FFFFFF',

					'icon' => $badge_parts[6],

					'position' => $badge_parts[7],

					'priority' => (int) $badge_parts[8],



					// Additional computed properties

					'css_class' => 'badge-' . $badge_parts[2],

					'has_icon' => !empty($badge_parts[6]),

					'style' => sprintf(

						'background-color: %s; color: %s;',

						!empty($badge_parts[4]) ? $badge_parts[4] : '#FF6B6B',

						!empty($badge_parts[5]) ? $badge_parts[5] : '#FFFFFF'

					)

				];

			}

		}



		// Already sorted by priority in SQL, but double check

		usort($badges, function ($a, $b) {

			return $a['priority'] - $b['priority'];

		});



		return $badges;

	}



	private function _check_wishlist_status($product_id, $customer_id)

	{

		if (!$customer_id) return false;



		$exists = $this->db->where([

			'customer_id' => $customer_id,

			'product_id' => $product_id

		])->get('wishlists')->num_rows();



		return $exists > 0;

	}





	public function search()

	{

		header('Content-Type: application/json');

		$query = $this->input->get('query', TRUE);



		// Debug query

		if (!$query) {

			echo json_encode(['error' => 'No query provided']);

			return;

		}



		$this->load->model('product_m');



		$results = $this->product_m->search_products($query);

		if (empty($results)) {

			echo json_encode(['results' => []]);

			return;

		}



		foreach ($results as &$result) {

			$result['url'] = base_url('product/' . $result['alias']);

			$result['image'] = base_url('uploads/product/' . $result['image']);

		}



		echo json_encode(['results' => $results]);

	}



	public function track_impression()

	{

		// Pastikan hanya menerima request AJAX

		if (!$this->input->is_ajax_request()) {

			show_error('No direct script access allowed', 403);

		}



		// Ambil data dari request

		$banner_id = $this->input->post('bannerId');



		if (!$banner_id) {

			$this->output

				->set_status_header(400)

				->set_content_type('application/json')

				->set_output(json_encode(['status' => 400, 'success' => false, 'message' => 'Banner ID is required']));

			return;

		}



		$excluded_ips = ['110.137.195.77'];

		$user_ip = $this->input->ip_address();



		// Jika IP ada dalam daftar pengecualian, hentikan tracking

		if (in_array($user_ip, $excluded_ips)) {

			return $this->output

				->set_status_header(200)

				->set_content_type('application/json')

				->set_output(json_encode([

					'status' => 200,

					'success' => false,

					'message' => 'Tracking skipped for this IP'

				]));

		}



		$data = [

			'banner_id'   => $banner_id,

			'timestamp'   => date('Y-m-d H:i:s'),

			'session_id'  => session_id(),

			'user_agent'  => $this->input->user_agent(),

			'ip_address'  => $user_ip

		];



		try {

			$result = $this->Carousel_banner_m->save_impression($data);

			if ($result) {

				$this->output

					->set_status_header(200)

					->set_content_type('application/json')

					->set_output(json_encode(['status' => 200, 'success' => true, 'message' => 'Impression tracked successfully']));

			} else {

				throw new Exception('Failed to save impression.');

			}

		} catch (Exception $e) {

			log_message('error', 'Impression tracking failed: ' . $e->getMessage());

			$this->output

				->set_status_header(500)

				->set_content_type('application/json')

				->set_output(json_encode(['status' => 500, 'success' => false, 'message' => 'Server error: Unable to track impression']));

		}

	}

}