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

class Product extends Public_Controller {

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

	public function get($alias = NULL) { 

		if ($alias == NULL) { show_404(); }

		//check if product exist 
		$this->db->select('*')->from('products')->where('alias', $alias)->where('product_status', 1);
		$count = $this->db->get()->num_rows();
		if ($count == 0) { show_404(); }

		//set url to session, so can be access by cart page, continue shopping link button
		$this->session->set_userdata('productpage_to_cart', base_url() . 'product/' . $alias);

		//get this product data
		$this->db->select('*')->from('products')->where('alias', $alias);
		$data['product'] = $this->db->get()->row(); 

		//get this product details
		$product_id = (int) $data['product']->id_products;
		$this->db->select('*')->from('product_details')->where('product_id', $product_id);
		$data['product_details'] = $this->db->get()->result();  

		//get initial product code (SKU), weight, and stock
		$this->db->select('id_product_details, sku, weight, stock')->from('product_details')->where('product_id', $product_id)->order_by('id_product_details', 'ASC')->limit(1);	
		$product_details = $this->db->get()->row();
		$data['sku'] = $product_details->sku;
		$data['weight'] = $product_details->weight;
		$data['stock'] = $product_details->stock;

		//get product code (SKU), weight, and stock display status
		$this->db->select('show_product_sku, show_product_weight, show_product_stock')->from('configuration')->where('id_configuration', 1);
		$display_status = $this->db->get()->row();
		$data['display_sku'] = $display_status->show_product_sku;
		$data['display_weight'] = $display_status->show_product_weight;
		$data['display_stock'] = $display_status->show_product_stock;

		$this->load->helper('product');
		$category_discount_percentage = category_discount($product_id);

		//INITIAL PRODUCT PRICE 
		if(isset($this->session->userdata('customer')['customer_id'])) {

			//customer is logged in
			//get product detail id (for 1st detail only)
			$this->db->select('id_product_details')->from('product_details')->where('product_id', $product_id)->limit(1);
			$id_product_detail = $this->db->get()->row()->id_product_details;

			//check if customer is a reseller. if reseller use reseller price
			$this->db->select('reseller_id')->from('customers')->where('id_customers', $this->session->userdata('customer')['customer_id']);
			$reseller_id = $this->db->get()->row()->reseller_id;

			//check if reseller product price already available (already input by admin). If not, display retail price
			$this->db->select('price')->from('resellers_price')->where('reseller_id', $reseller_id)->where('product_detail_id', $id_product_detail);
			$count_reseller_price = $this->db->get()->num_rows();

			if($reseller_id != NULL && $count_reseller_price > 0) {
				
				//customer is reseller, and admin already input the reseller product price, use reseller price
				$this->db->select('price, min_quantity')->from('resellers_price')->where('reseller_id', $reseller_id)->where('product_detail_id', $id_product_detail);
				$reseller_data = $this->db->get()->row();
				$data['price'] = $reseller_data->price;
				$data['discounted_price'] = 0;
				$data['reseller_min_quantity'] = $reseller_data->min_quantity;

			} elseif($reseller_id == NULL || $count_reseller_price == 0) {
				
				//customer is regular customer, or admin not yet input reseller product price
				if($category_discount_percentage != NULL) {
					//category discount is active
					$this->db->select('price, sku, attributes')->from('product_details')->where('product_id', $product_id)->order_by('id_product_details', 'ASC')->limit(1);
					$prices = $this->db->get()->row(); 
					$data['price'] = $prices->price;
					$data['discounted_price'] = $prices->price - ($prices->price * $category_discount_percentage/100);
				} else {
					//get the initial product retail price from stocks table
					$this->db->select('price, discounted_price, sku, attributes')->from('product_details')->where('product_id', $product_id)->order_by('id_product_details', 'ASC')->limit(1);
					$prices = $this->db->get()->row(); 
					$data['price'] = $prices->price;
					$data['discounted_price'] = $prices->discounted_price;	
				}
			}
		} else {
			//customer is not logged in
			if($category_discount_percentage != NULL) {
				//category discount is active
				$this->db->select('price, sku, attributes')->from('product_details')->where('product_id', $product_id)->order_by('id_product_details', 'ASC')->limit(1);
				$prices = $this->db->get()->row(); 
				$data['price'] = $prices->price;
				$data['discounted_price'] = $prices->price - ($prices->price * $category_discount_percentage/100);
			} else {
				//get the initial product price from stocks table
				$this->db->select('price, discounted_price, sku, attributes')->from('product_details')->where('product_id', $product_id)->order_by('id_product_details', 'ASC')->limit(1);
				$prices = $this->db->get()->row(); 
				$data['price'] = $prices->price;
				$data['discounted_price'] = $prices->discounted_price;
			}
		}

		//QUANTITY DISCOUNT
		//check whether quantity_discount_active is no, retail only, reseller only, or both
		$quantity_discount_active = $data['product']->quantity_discount_active;
		//check quantity discount if exist
		$this->db->select('id_quantity_discount')->from('quantity_discount')->where('product_id', $product_id);
		$count_quantity_discount = $this->db->get()->num_rows();

		if(isset($this->session->userdata('customer')['customer_id'])) {
			//customer is loggedin
			//check if customer is a reseller
			$this->db->select('reseller_id')->from('customers')->where('id_customers', $this->session->userdata('customer')['customer_id']);
			$reseller_id = $this->db->get()->row()->reseller_id;

			if($reseller_id != NULL) {
				//this is a reseller
				//display quantity discount
				if($quantity_discount_active == 'reseller' || $quantity_discount_active == 'retail-reseller') {
					if($count_quantity_discount > 0) {
						//quantity discount exist. get quantity discount
						$this->db->select('*')->from('quantity_discount')->where('product_id', $product_id)->order_by('min_quantity', 'ASC');
						$data['quantity_discount'] = $this->db->get()->result();
					}
				}
			} else {
				//this is a regular customer
				//display quantity discount
				if($quantity_discount_active == 'retail' || $quantity_discount_active == 'retail-reseller') {
					if($count_quantity_discount > 0) {
						//quantity discount exist. get quantity discount
						$this->db->select('*')->from('quantity_discount')->where('product_id', $product_id)->order_by('min_quantity', 'ASC');
						$data['quantity_discount'] = $this->db->get()->result();
					}
				}
			}
		} else {
			//customer is not loggedin
			//display quantity discount
			if($quantity_discount_active == 'retail' || $quantity_discount_active == 'retail-reseller') {
				if($count_quantity_discount > 0) {
					//quantity discount exist. get quantity discount
					$this->db->select('*')->from('quantity_discount')->where('product_id', $product_id)->order_by('min_quantity', 'ASC');
					$data['quantity_discount'] = $this->db->get()->result();
				}
			}
		}

		//check if point rewards program is active or not.
		$this->db->select('*')->from('point_rewards')->where('id_point_rewards', 1);
		$data['point_rewards'] = $this->db->get()->row();

		//get brand name
		$this->db->select('brand')->from('brands')->where('id_brands', $data['product']->brand_id);  
		$data['brand_name'] = $this->db->get()->row()->brand;

		//get all product reviews
		$this->db->select('*')->from('product_review')->where('product_id', $product_id)->order_by('review_date', 'DESC');
		$data['product_reviews'] = $this->db->get()->result();

		//get average reviews
		$this->db->select('rating')->from('product_review')->where('product_id', $product_id);
		$data['review_ratings'] = $this->db->get()->result();
		if (count($data['review_ratings']) != 0) {
			$sum_review = 0;
			foreach ($data['review_ratings'] as $rating) {
				$sum_review = $sum_review + $rating->rating; 
			}
			$data['average_rating'] = floor($sum_review / count($data['review_ratings'])); 
		}

		//get product color link 
        //check if color link is available
        $this->db->select('link_to_product_id')->from('product_link')->where('product_id', $product_id);
		$data['product_links'] = $this->db->get()->result();

		//check the stock. if no stock at all, display no stock.
		$this->db->select('stock')->from('product_details')->where('product_id', $product_id)->where('stock !=', 0);
		$data['count_product_stock'] = $this->db->get()->num_rows(); 

		//LOAD LANGUAGE FILES
		if($this->session->userdata('site_lang') == 'english') {
			$this->lang->load('product_detail', 'english');
		} else {
			$this->lang->load('product_detail', 'indonesian');
		}

		//get SEO
		$this->data_header['browser_title'] = 'Product - ' . ucwords($data['product']->title); 
		$this->data_header['meta_description'] = $data['product']->meta_description;
		$this->data_header['meta_keywords'] = $data['product']->meta_keywords;
		
		$this->load->view('template/header', $this->data_header);
		$this->load->view('product', $data);
		$this->load->view('template/footer', $this->data_footer); 

	}

	


}