<?php
/**
 * @package DJ-Catalog2
 * @copyright Copyright (C) DJ-Extensions.com, All rights reserved.
 * @license http://www.gnu.org/licenses GNU/GPL
 * @author url: http://dj-extensions.com
 * @author email contact@dj-extensions.com
 */

// No direct access
defined('_JEXEC') or die;
use Joomla\CMS\Table\Table;
use Joomla\CMS\Factory;
use Joomla\CMS\Component\ComponentHelper;
class Djcatalog2TableOrders extends Table
{
	public function __construct(&$db)
	{
		parent::__construct('#__djc2_orders', 'id', $db);
		$this->items = array();
	}
	public function bind($array, $ignore = '')
	{
		$db = Factory::getDbo();

		$user = Factory::getUser();
		$salesman = $user->authorise('djcatalog2.salesman', 'com_djcatalog2') || $user->authorise('core.admin', 'com_djcatalog2');

		$params = ComponentHelper::getParams('com_djcatalog2');

		$net_prices = (bool)((int)$params->get('price_including_tax', 1) == 0);
		if (!empty($array['order_items']) && is_array($array['order_items'])) {
			$items = array();
			$rows = $array['order_items'];
			foreach($rows['id'] as $id => $value) {
				$row = new stdClass();
				if (empty($rows['item_name'][$id])
					|| !$salesman && (
					floatval($rows['quantity'][$id] == 0.0)
						/*|| floatval($rows['base_cost'][$id] == 0.0)
						|| floatval($rows['cost'] == 0.0)
						|| floatval($rows['total'] == 0.0)*/
					)
				) {
					continue;
				}
				$row->id = $value;
				if (isset($rows['item_type'])) {
					$row->item_type         = $rows['item_type'][$id];
				}
				if (isset($rows['combination_id'])) {
					$row->combination_id         = $rows['combination_id'][$id];
				}
				$row->order_id        = $array['id'];
				$row->item_id           = (empty($rows['item_id'][$id])) ? 0 : $rows['item_id'][$id];
				$row->item_name         = $rows['item_name'][$id];
				$row->sku        		= $rows['sku'][$id];
				if (isset($rows['shipping_day']) && isset($rows['shipping_day'][$id])) {
					$row->shipping_day      = $rows['shipping_day'][$id];
				}
				$row->quantity          = $rows['quantity'][$id];

				if (isset($rows['unit'][$id])) {
					$row->unit = $rows['unit'][$id];
				}

				$row->cost              = $rows['cost'][$id];
				$row->base_cost         = $rows['base_cost'][$id];
				$row->tax               = $rows['tax'][$id];
				$row->tax_rate          = $rows['tax_rate'][$id];
				$row->total             = $rows['total'][$id];

				if (!empty($rows['additional_info'][$id])) {
					$row->additional_info   = $rows['additional_info'][$id];
				}

				if (!empty($rows['combination_info'][$id])) {
					$row->combination_info   = $rows['combination_info'][$id];
				}

				if (!empty($rows['features_info'][$id])) {
					$row->features_info   = $rows['features_info'][$id];
				}

				$items[] = $row;
			}

			$array['items'] = $items;
			unset($array['order_items']);
		}

		if (isset($array['items']) &&  count($array['items']) > 0) {
			$sub_totals = array();
			$total = 0.0;
			$tax = 0.0;
			$grand_total = 0.0;
			foreach($array['items'] as $item) {
				$tax_rate = (int)($item->tax_rate * 100);
				if (!array_key_exists($tax_rate, $sub_totals)) {
					$sub_totals[$tax_rate] = array('total'=>0.0, 'grand_total'=>0.0, 'tax'=>0.0);
				}
				$sub_totals[$tax_rate]['grand_total'] += round($item->total, 2);
				$sub_totals[$tax_rate]['total'] += round($item->cost, 2);
				$sub_totals[$tax_rate]['tax'] += round($item->tax, 2);
			}

			if (isset($array['delivery_method_id']) && isset($array['delivery_price']) && isset($array['delivery_tax']) && isset($array['delivery_tax_rate']) && isset($array['delivery_total'])) {
				$tax_rate = (int)((float)$array['delivery_tax_rate'] * 100);
				if (!array_key_exists($tax_rate, $sub_totals)) {
					$sub_totals[$tax_rate] = array('total'=>0.0, 'grand_total'=>0.0, 'tax'=>0.0);
				}
				$sub_totals[$tax_rate]['grand_total'] += round((float)$array['delivery_total'], 2);
				$sub_totals[$tax_rate]['total'] += round((float)$array['delivery_price'], 2);
				$sub_totals[$tax_rate]['tax'] += round((float)$array['delivery_tax'], 2);
			}

			if (isset($array['payment_method_id']) && isset($array['payment_price']) && isset($array['payment_tax']) && isset($array['payment_tax_rate']) && isset($array['payment_total'])) {
				$tax_rate = (int)((float)$array['payment_tax_rate'] * 100);
				if (!array_key_exists($tax_rate, $sub_totals)) {
					$sub_totals[$tax_rate] = array('total'=>0.0, 'grand_total'=>0.0, 'tax'=>0.0);
				}
				$sub_totals[$tax_rate]['grand_total'] += round((float)$array['payment_total'], 2);
				$sub_totals[$tax_rate]['total'] += round((float)$array['payment_price'], 2);
				$sub_totals[$tax_rate]['tax'] += round((float)$array['payment_tax'], 2);
			}

			foreach($sub_totals as $tax_rate => $sub_total) {
				if ($net_prices) {
					// calculate tax from net price and then calculate grand total
					$sub_totals[$tax_rate]['tax'] = round(($tax_rate * $sub_total['total'])/100, 2);
					$sub_totals[$tax_rate]['grand_total'] =   $sub_totals[$tax_rate]['total'] + $sub_totals[$tax_rate]['tax'];
				} else {
					// calculating tax from grand total
					$sub_totals[$tax_rate]['tax'] = round(($tax_rate/(100+$tax_rate)) * $sub_total['grand_total'], 2);
					$sub_totals[$tax_rate]['total'] =   $sub_totals[$tax_rate]['grand_total'] -  $sub_totals[$tax_rate]['tax'];
				}

				$tax += $sub_totals[$tax_rate]['tax'];
				$total += $sub_totals[$tax_rate]['total'];
				$grand_total += $sub_totals[$tax_rate]['grand_total'];
			}

			$array['total'] = $total;
			$array['grand_total'] = $grand_total;
			$array['tax'] = $tax;
		}


		return parent::bind($array, $ignore);
	}

	public function load($keys = null, $reset = true)
	{
		$return = parent::load($keys, $reset);

		if ($return !== false && (int)$this->id > 0 && empty($this->items)) {
			$db = Factory::getDbo();
			$db->setQuery('select * from #__djc2_order_items where order_id='.(int)$this->id);
			$this->items = $db->loadObjectList('id');
		}

		return $return;
	}
	public function store($updateNulls = false)
	{
		$date	= Factory::getDate();
		$user	= Factory::getUser();

		$this->modified = $date->toSql();
		if ($this->id) {
			$this->modified_by = $user->get('id');
		}

		$items = $this->items;
		unset($this->items);

		$success = parent::store($updateNulls);
		//$this->items = $items;

		if (!$success) {
			return false;
		}

		$db = Factory::getDbo();

		$do_not_delete = array();
		if (count($items)) {
			foreach ($items as &$obj) {
				$obj->order_id = $this->id;
				if ($obj->id > 0) {
					$ret = $db->updateObject( '#__djc2_order_items', $obj, 'id', false);
				} else {
					$ret = $db->insertObject( '#__djc2_order_items', $obj, 'id');
				}
				if ($ret) {
					$do_not_delete[] = $obj->id;
				} else {
					$this->setError($db->getErrorMsg());
				}
			}
			unset($obj);
		}

		if (count($do_not_delete) > 0) {
			$db->setQuery('delete from #__djc2_order_items where order_id='.(int)$this->id.' and id not in ('.implode(',', $do_not_delete).')');
		} else {
			$db->setQuery('delete from #__djc2_order_items where order_id='.(int)$this->id);
		}

		if (!$db->execute()) {
			$this->setError($db->getErrorMsg());
			return false;
		}

		$this->items = $items;
		unset($items);

		return true;

	}
}