<?php

class LoyaltyModule extends ObjectModel
{
	public $id_loyalty_state;
	public $id_customer;
	public $id_order;
	public $id_discount;
	public $points;
	public $date_add;
	public $date_upd;

	protected $fieldsRequired = array('id_customer', 'points');
	protected $fieldsSize = array(
		'id_loyalty_state' => 2,
		'id_customer' => 8,
		'id_order' => 8,
		'id_discount' => 8,
		'points' => 16
	);
	protected $fieldsValidate = array(
		'id_loyalty_state' => 'isInt',
		'id_customer' => 'isInt',
		'id_discount' => 'isInt',
		'id_order' => 'isInt',
		'points' => 'isInt'
	);

	protected $table = 'loyalty';
	protected $identifier = 'id_loyalty';
	
	public function getFields()
	{
		parent::validateFields();
		$fields['id_loyalty_state'] = intval($this->id_loyalty_state);
		$fields['id_customer']   = intval($this->id_customer);
		$fields['id_order']      = intval($this->id_order);
		$fields['id_discount']   = intval($this->id_discount);
		$fields['points']        = intval($this->points);
		$fields['date_add']      = pSQL($this->date_add);
		$fields['date_upd']      = pSQL($this->date_upd);
		return $fields;
	}

	public function save($nullValues = false, $autodate = true)
	{
		parent::save($nullValues, $autodate);
		$this->historize();
	}

	static public function getIdByIdCustomerAndIdOrder($id_customer, $id_order)
	{
		if (!is_numeric($id_customer) OR !is_numeric($id_order)) return false;
		$query = '
			SELECT f.id_loyalty
			FROM `'._DB_PREFIX_.'loyalty` f
			WHERE f.id_customer = '.intval($id_customer).'
				AND f.id_order = '.intval($id_order).'
			LIMIT 1
		';
		if ($result = Db::getInstance()->ExecuteS($query))
		{
			return $result[0]['id_loyalty'];
		}
		return $result;
	}

	static public function getOrderNbPoints($order)
	{
		$total = 0;
		if (Validate::isLoadedObject($order))
		{
			$total = self::getCartNbPoints(new Cart($order->id_cart));
		}
		return $total;
	}

	static public function getCartNbPoints($cart)
	{
		$total = 0;
		if (Validate::isLoadedObject($cart))
		{
			foreach ($cart->getProducts() AS $product)
			{
				$p = new Product($product['id_product']);
				$points = self::getNbPointsByProduct($p, $product['id_product_attribute']);
				$points = $points * $product['cart_quantity'];
				$total += $points;
			}
			foreach ($cart->getDiscounts(false) AS $discount)
			{
				$points = self::getNbPointsByPrice($discount['value_real']);
				$total -= $points;
			}
		}
		return $total;
	}

	static public function getVoucherValue($nbPoints)
	{
		return floatval(floatval($nbPoints) * floatval(Configuration::get('PS_LOYALTY_POINT_VALUE')));
	}

	static public function getNbPointsByProduct($product, $id_product_attribute=false)
	{
		global $cookie;
		$points = 0;
		if (Validate::isLoadedObject($product))
		{
			if (!intval(Configuration::get('PS_LOYALTY_NONE_AWARD')) AND ($product->reduction_price > 0 OR $product->reduction_percent > 0 OR $product->on_sale))
				return $points;
			$price = $product->getPrice();
			if (intval($id_product_attribute) AND $id_product_attribute!==false)
			{
				$price = $product->getPrice(true, intval($id_product_attribute));
			}
			else
			{
				$attributesGroups = $product->getAttributesGroups(intval($cookie->id_lang));
				foreach ($attributesGroups AS $attributesGroup)
				{
					$productPrice = $product->getPrice(true, intval($attributesGroup['id_product_attribute']));
					if ($productPrice > $price)
						$price = $productPrice;
				}
			}
			$points = self::getNbPointsByPrice($price);
		}
		return $points;
	}

	static public function getNbPointsByPrice($price)
	{
		$points = 0;
		/* Prevent division by zero */
		if ($pointRate = floatval(Configuration::get('PS_LOYALTY_POINT_RATE')))
			$points = floor($price / $pointRate);
		return $points;
	}

	static public function getPointsByCustomer($id_customer)
	{
		$return = Db::getInstance()->getRow('
		SELECT sum(f.points) AS points
		FROM `'._DB_PREFIX_.'loyalty` f
		WHERE f.id_customer = '.intval($id_customer).'
		AND f.id_loyalty_state IN
			('.LoyaltyStateModule::getValidationId().', '.LoyaltyStateModule::getCancelId().', '.LoyaltyStateModule::getNoneAwardId().')');
		return $return['points'];
	}

	static public function getAllByIdCustomer($id_customer, $id_lang, $onlyValidate=false)
	{
		$query = '
			SELECT f.id_order AS id, fh.date_add AS date, (o.total_paid - o.total_shipping) AS total_without_shipping, fh.points AS points, fh.id_loyalty AS id_loyalty, fh.id_loyalty_state AS id_loyalty_state, fsl.name AS state
			FROM `'._DB_PREFIX_.'loyalty_history` fh
			LEFT JOIN `'._DB_PREFIX_.'loyalty` f ON (f.id_loyalty = fh.id_loyalty)
			LEFT JOIN `'._DB_PREFIX_.'orders` o ON (f.id_order = o.id_order)
			LEFT JOIN `'._DB_PREFIX_.'loyalty_state_lang` fsl ON (fh.id_loyalty_state = fsl.id_loyalty_state AND fsl.id_lang = '.intval($id_lang).')
			WHERE f.id_customer = '.intval($id_customer);
		if ($onlyValidate===true)
			$query.= ' AND f.id_loyalty_state = '.LoyaltyStateModule::getValidationId().' GROUP BY f.id_loyalty';
		return Db::getInstance()->ExecuteS($query);
	}

	static public function getDiscountByIdCustomer($id_customer, $last=false)
	{
		$query = '
			SELECT f.id_discount AS id_discount, f.date_upd AS date_add
			FROM `'._DB_PREFIX_.'loyalty` f
			WHERE f.id_customer = '.intval($id_customer).'
				AND id_discount > 0';
		if ($last===true) $query.= ' ORDER BY f.id_loyalty DESC LIMIT 0,1';
		$query.= ' GROUP BY f.id_discount';
		return Db::getInstance()->ExecuteS($query);
	}

	static public function registerDiscount($discount)
	{
		if (!Validate::isLoadedObject($discount))
			die (Tools::displayError('Incorrect object Discount.'));
		$items = self::getAllByIdCustomer($discount->id_customer, NULL, true);
		foreach ($items AS $item)
		{
			$f = new LoyaltyModule($item['id_loyalty']);
			$f->id_discount = $discount->id;
			$f->id_loyalty_state = LoyaltyStateModule::getConvertId();
			$f->save();
		}
	}

	static public function getOrdersByIdDiscount($id_discount)
	{
		$query = '
			SELECT f.id_order AS id_order, f.points AS points, f.date_upd AS date
			FROM `'._DB_PREFIX_.'loyalty` f
			WHERE f.id_discount = '.intval($id_discount).'
				AND f.id_loyalty_state = '.LoyaltyStateModule::getConvertId();
		$items = Db::getInstance()->ExecuteS($query);
		if (!empty($items) AND is_array($items))
		{
			foreach ($items AS $key => $item)
			{
				$order = new Order($item['id_order']);
				$items[$key]['id_currency'] = $order->id_currency;
				$items[$key]['id_lang'] = $order->id_lang;
				$items[$key]['total_paid'] = $order->total_paid;
				$items[$key]['total_shipping'] = $order->total_shipping;
			}
			return $items;
		}
		return false;
	}

	/* Register all transaction in a specific history table */
	private function historize()
	{
		$points = intval($this->points);
		$query = '
			INSERT INTO `'._DB_PREFIX_.'loyalty_history`
				(`id_loyalty`, `id_loyalty_state`, `points`, `date_add`)
			VALUES
				('.$this->id.', '.$this->id_loyalty_state.', '.$points.', NOW())';
		Db::getInstance()->Execute($query);
	}

}

?>