<?php
/**
 * @package   Phoca Cart
 * @author    Jan Pavelka - https://www.phoca.cz
 * @copyright Copyright (C) Jan Pavelka https://www.phoca.cz
 * @license   http://www.gnu.org/licenses/gpl-2.0.html GNU/GPLv2 and later
 * @cms       Joomla
 * @copyright Copyright (C) Open Source Matters. All rights reserved.
 * @license   http://www.gnu.org/copyleft/gpl.html GNU/GPL, see LICENSE.php
 */
defined('_JEXEC') or die();
use Joomla\CMS\Factory;
use Joomla\CMS\HTML\HTMLHelper;


final class PhocacartStatistics
{
	protected $fn = array();

	public function __construct() {

		$app	= Factory::getApplication();
		if ($app->isClient('administrator')) {
			HTMLHelper::_('jquery.framework', false);
			HTMLHelper::_('script', 'media/com_phocacart/js/chartjs/Chart.min.js', array('version' => 'auto'), array('defer' => true));
		} else {
			$media = PhocacartRenderMedia::getInstance('main');
			$media->renderChartJs();
		}

	}

	public function renderChartJsLine($id, $dataA, $dataALabel, $dataB, $dataBLabel, $dataX) {

		/*$bC 	= 'rgba(79,152,195,1)';
        $baC	= 'rgba(79,152,195,0.5)';
        $pbC	= 'rgba(79,152,195,1)';
        $pbaC 	= 'rgba(255,255,255,1)';

        $bC2 	= 'rgba(210,214,222,1)';
        $baC2	= 'rgba(210,214,222,0.5)';
        $pbC2	= 'rgba(210,214,222,1)';
        $pbaC2 	= 'rgba(255,255,255,1)';*/

        $bC 	= 'rgba(247,99,151,1)';
        $baC	= 'rgba(247,99,151,0.5)';
        $pbC	= 'rgba(247,99,151,0.8)';
        $pbaC 	= 'rgba(255,255,255,1)';

        $bC2 	= 'rgba(255, 170, 0,1)';
        $baC2	= 'rgba(255, 170, 0,0.5)';
        $pbC2	= 'rgba(255, 170, 0,0.8)';
        $pbaC2 	= 'rgba(255,255,255,1)';





		$o = "
var config".$id." = {
type: 'line',             
data: {
	datasets: [{
		data: [".$dataA."],
		yAxisID: 'y-axis-2',
		pointRadius : 4,
		borderColor : '".$bC."',
		backgroundColor : '".$baC."',
		pointBorderColor : '".$pbC."',
		pointBackgroundColor :'".$pbaC."',
		pointBorderWidth : 1,
		radius: 4,
		pointHoverRadius: 5,
		 
		label: '".htmlspecialchars($dataALabel)."',
		/*fillColor: '#fff',
		strokeColor: '#fff',
		pointColor: '#fff',
		pointStrokeColor: '#fff',
		pointHighlightFill: '#000',
		pointHighlightStroke: '#fff'*/

	}, {
	   data: [".$dataB."],
		yAxisID: 'y-axis-1',
		borderColor : '".$bC2."',
		backgroundColor : '".$baC2."',
		pointBorderColor : '".$pbC2."',
		pointBackgroundColor :'".$pbaC2."',
		pointBorderWidth : 1,
		radius: 4,
		pointHoverRadius: 5,
		
		label: '".htmlspecialchars($dataBLabel)."',

	}],
	labels: [".htmlspecialchars($dataX, ENT_NOQUOTES)."
	],
},
scaleIntegersOnly: true,
options: {  
		responsive: true,
		hoverMode: 'label',
		stacked: false,
		legend: { labels: { fontColor: 'rgba(255,255,255,0.8)' } }, 
		scales: {
			xAxes: [{
				display: true,
				gridLines: {
					drawOnChartArea: true,
					offsetGridLines: false,
					show: true,
					color: 'rgba(255,255,255,0.2)',
					zeroLineColor: 'rgba(255,255,255,0.2)',
					lineWidth: 1,
					/*drawOnChartArea: true,
					drawTicks: true,
					zeroLineWidth: 10,
					zeroLineColor: '#fff300'*/					
				},
				ticks: {fontColor: 'rgba(255,255,255,0.9)'}
			}],
			yAxes: [{
				type: 'linear',
				display: true,
				position: 'left',
				id: 'y-axis-1',
				gridLines: {
					drawOnChartArea: true,
					color: 'rgba(255,255,255,0.2)',
					zeroLineColor: 'rgba(255,255,255,0.2)',
					lineWidth: 1,
				},
				label: 'text',
				ticks: {
				    fontColor: 'rgba(255,255,255,0.9)',
					callback: function(value) {
						if (value % 1 === 0) {
							return Math.floor(value);
						} else {
							return '';
						}
					}
				}
			}, {
				type: 'linear',
				display: true,
				position: 'right',
				id: 'y-axis-2',
				gridLines: {
					drawOnChartArea: false,
					color: 'rgba(255,255,255,0.2)',
					zeroLineColor: 'rgba(255,255,255,0.2)',
				},
				label: 'text',
				ticks: {
				    fontColor: 'rgba(255,255,255,0.9)',
					callback: function(value) {
						if (value % 1 === 0) {
							return Math.floor(value);
						} else {
							return '';
						}
					}
				}
			}],
		},
	}
};";
		Factory::getDocument()->addScriptDeclaration($o);
	}


	public function renderChartJsLine2($id, $dataA, $dataALabel, $dataX) {

		$bC 	= 'rgba(52,140,212,1)';
		$baC	= 'rgba(52,140,212,0.3)';
		$pbC	= 'rgba(255,255,255,1)';
		$pbaC 	= 'rgba(52,140,212,1)';


		$o = "
var config".$id." = {
type: 'line',
data: {
	datasets: [{
		data: [".$dataA."],
		yAxisID: 'y-axis-2',
		pointRadius : 4,
		borderColor : '".$bC."',
		backgroundColor : '".$baC."',
		pointBorderColor : '".$pbC."',
		pointBackgroundColor :'".$pbaC."',
		pointBorderWidth : 1,
		radius: 4,
		pointHoverRadius: 5,
		 
		label: '".htmlspecialchars($dataALabel)."',
		/*fillColor: '#fff',
		strokeColor: '#fff',
		pointColor: '#fff',
		pointStrokeColor: '#fff',
		pointHighlightFill: '#000',
		pointHighlightStroke: '#fff'*/

	}],
	labels: [".htmlspecialchars($dataX, ENT_NOQUOTES)."
	],
},
scaleIntegersOnly: true,
options: {  
		responsive: true,
		hoverMode: 'label',
		stacked: false,
		legend: { labels: { fontColor: '#000000' } }, 
		scales: {
			xAxes: [{
				display: true,
				gridLines: {
					drawOnChartArea: true,
					offsetGridLines: false,
					show: true,
					color: '#ffffff',
					zeroLineColor: '#ffffff',
					lineWidth: 1,
					/*drawOnChartArea: true,
					drawTicks: true,
					zeroLineWidth: 10,
					zeroLineColor: '#fff300'*/					
				},
				ticks: {fontColor: '#000000'}
			}],
			yAxes: [{
				type: 'linear',
				display: false,
				position: 'left',
				id: 'y-axis-1',
				gridLines: {
					drawOnChartArea: true,
					color: '#ffffff',
					zeroLineColor: '#ffffff',
					lineWidth: 1,
				},
				label: 'text',
				ticks: {
				    fontColor: '#000000',
					callback: function(value) {
						if (value % 1 === 0) {
							return Math.floor(value);
						} else {
							return '';
						}
					}
				}
			}, {
				type: 'linear',
				display: true,
				position: 'right',
				id: 'y-axis-2',
				gridLines: {
					drawOnChartArea: false,
					color: '#ffffff',
					zeroLineColor: '#ffffff',
				},
				label: 'text',
				ticks: {
				    fontColor: '#000000',
					callback: function(value) {
						if (value % 1 === 0) {
							return Math.floor(value);
						} else {
							return '';
						}
					}
				}
			}],
		},
	}
};";
		Factory::getDocument()->addScriptDeclaration($o);
	}


	public function renderChartJsPie($id, $data, $limit = 5) {


		$colors = array('#FFCC33', '#FF6633', '#FF3366', '#FF33CC', '#CC33FF');
		$dS = $lS = $bS = '';
		if (!empty($data)) {

			foreach($data as $k => $v) {

				if ($k >= $limit) {
					break;
				}

				$d[$k] = '\''. addslashes($v['items']). '\'';
				$l[$k] = '\''. addslashes(($v['title'])). '\'';
				$c = $k%5;

				$b[$k] = '\''. addslashes($colors[$c]). '\'';
			}

			$dS = implode(',', $d);
			$lS = implode(',', $l);
			$bS = implode(',', $b);
		}


		// labels: [".htmlspecialchars($lS, ENT_NOQUOTES, 'UTF-8')."]
		$o = "
var config".$id." = {
	type: 'pie',
	data: {
		datasets: [{
			data: [".$dS."],
			backgroundColor : [".$bS."],
		}],
		labels: [".$lS."]
	},
	options: {
		responsive: true,
	}
};";
		Factory::getDocument()->addScriptDeclaration($o);
	}

	public function setFunction($id, $type) {
		$this->fn[$id]['id']	= $id;
		$this->fn[$id]['type']	= $type;
		$this->fn[$id]['area']	= $id;
	}

	public function renderFunctions() {

		$s	 = array();
		$s[] = 'window.onload = function() {';

		if (!empty($this->fn)) {
			foreach($this->fn as $k => $v) {
				$s[] = 'var ctx'.$v['id'].' = document.getElementById(\''.$v['area'].'\').getContext(\'2d\');';
				$s[] = 'window.'.$v['type'].' = new Chart(ctx'.$v['id'].', config'.$v['id'].');';
			}
		}
		$s[] = '};';
		Factory::getDocument()->addScriptDeclaration(implode( "\n", $s ));
	}

	public function getDataChart($numberOfDate = '', $dateFrom = '', $dateTo = '') {


		$db	= Factory::getDbo();
		$q	= $db->getQuery(true);

		//- $q->select('a.id, DATE(a.date) AS date_only, COUNT(DATE(a.date)) AS count_orders');
		$q->select('DATE(a.date) AS date_only, COUNT(DATE(a.date)) AS count_orders');
		$q->from('`#__phocacart_orders` AS a');

		$q->select('SUM(t.amount) AS order_amount');
		$q->join('LEFT', '#__phocacart_order_total AS t ON a.id=t.order_id');
		$q->where('t.type = \'brutto\'' );

		// Filter by order status
		$whereOrderStatus = '';
		if (!PhocacartStatistics::setWhereByOrderStatus($whereOrderStatus)) {
			return false;
		}
		if ($whereOrderStatus != '') {
			$q->where( $whereOrderStatus );
		}

		if ($numberOfDate == '') {
			$numberOfDate = 6; //7 days
		}
		if ($dateFrom == '') {
			$dateFrom 	= PhocacartDate::getCurrentDate($numberOfDate);
		}
		if ($dateTo == '') {
			$dateTo 	= PhocacartDate::getCurrentDate();
		}
		$dateDays = PhocacartDate::getDateDays($dateFrom, $dateTo);



		if ($dateTo != '' && $dateFrom != '') {
			$dateFrom 	= $db->Quote($dateFrom);
			$dateTo 	= $db->Quote($dateTo);
			$q->where('DATE(a.date) >= '.$dateFrom.' AND DATE(a.date) <= '.$dateTo );
		}
		//- $q->group('DATE(a.date), a.id');
		$q->group('DATE(a.date)');

		$q->order($db->escape('a.date ASC'));
		//echo nl2br(str_replace('#__', 'jos_', $q->__toString()));
		$db->setQuery($q);

		$items = $db->loadObjectList();


		$amount		= array();
		$orders		= array();
		if (!empty($items) && !empty($dateDays)) {

			foreach($dateDays as $date) {
				$amount[ $date->format('Y-m-d') ] = 0;
				$orders[ $date->format('Y-m-d') ] = 0;
			}

			foreach($items as $k => $v) {

				if (isset($amount[$v->date_only])) {

					//- $amount[$v->date_only] += $v->order_amount;
					$amount[$v->date_only] = $v->order_amount;
				}
				if (isset($orders[$v->date_only])) {
					//- $orders[$v->date_only] += $v->count_orders;
					$orders[$v->date_only] = $v->count_orders;
				}
			}
		}


		$dataAmount = '';
		$dataOrders = '';
		$dataTicks	= '';
		$i = 1;
		foreach ($amount as $k => $v) {
			if ($dataAmount != '') {
				$dataAmount .= ', ';
			}
			$dataAmount .= (int)$v;
			$i++;
		}
		$i = 1;
		foreach ($orders as $k => $v) {
			if ($dataOrders != '') {
				$dataOrders .= ', ';
			}
			if ($dataTicks != '') {
				$dataTicks .= ', ';
			}
			$dataOrders .= (int)$v;
			$dataTicks .= '\''.$k.'\'';

			$i++;
		}

		$rData				= array();
		$rData['amount']	= $dataAmount;
		$rData['orders']	= $dataOrders;
		$rData['ticks']		= $dataTicks;

		return $rData;
	}

	public function getNumberOfOrders($numberOfDate = -1, $dateFrom = '', $dateTo = '') {

		if ($numberOfDate == -1) {
			$numberOfDate = 7;
		}

		if ($dateFrom == '') {
			$dateFrom 	= PhocacartDate::getCurrentDate($numberOfDate);
		}
		if ($dateTo == '') {
			$dateTo 	= PhocacartDate::getCurrentDate();
		}

		$db		= Factory::getDbo();
		$q = 'SELECT COUNT(a.id) FROM #__phocacart_orders AS a WHERE a.published = 1';
		$q .= ' AND DATE(a.date) >= '.$db->quote($dateFrom).' AND DATE(a.date) <= '.$db->quote($dateTo);

		$whereOrderStatus = '';
		if (!PhocacartStatistics::setWhereByOrderStatus($whereOrderStatus)) {
			return 0;
		}
		if ($whereOrderStatus != '') {
			$q .= 'AND '.$whereOrderStatus;
		}

		$db->setQuery($q);
		$count = $db->loadRow();
		if (isset($count[0]) && (int)$count[0] != 0) {
			return PhocacartStatistics::abreviateNumbers($count[0]);
		}
		return 0;
	}

	public function getNumberOfUsers($numberOfDate = -1, $dateFrom = '', $dateTo = '') {

		if ($numberOfDate == -1) {
			$numberOfDate = 7;
		}

		if ($dateFrom == '') {
			$dateFrom 	= PhocacartDate::getCurrentDate($numberOfDate);
		}
		if ($dateTo == '') {
			$dateTo 	= PhocacartDate::getCurrentDate();
		}

		$db		= Factory::getDbo();
		$q = 'SELECT COUNT(DISTINCT(a.user_id)) FROM #__phocacart_orders AS a WHERE a.published = 1';
		$q .= ' AND DATE(a.date) >= '.$db->quote($dateFrom).' AND DATE(a.date) <= '.$db->quote($dateTo);

		$whereOrderStatus = '';
		if (!PhocacartStatistics::setWhereByOrderStatus($whereOrderStatus)) {
			return 0;
		}
		if ($whereOrderStatus != '') {
			$q .= 'AND '.$whereOrderStatus;
		}

		$db->setQuery($q);
		$count = $db->loadRow();

		if (isset($count[0]) && (int)$count[0] != 0) {
			return PhocacartStatistics::abreviateNumbers($count[0]);
		}
		return 0;
	}

	public function getAmountOfOrders($numberOfDate = -1, $dateFrom = '', $dateTo = '') {


		if ($numberOfDate == -1) {
			$numberOfDate = 7;
		}



		if ($dateFrom == '') {
			$dateFrom 	= PhocacartDate::getCurrentDate($numberOfDate);
		}
		if ($dateTo == '') {
			$dateTo 	= PhocacartDate::getCurrentDate();
		}
		$db		= Factory::getDbo();
		$q = ' SELECT SUM(t.amount) FROM #__phocacart_orders AS a';
		$q .= ' LEFT JOIN #__phocacart_order_total AS t ON a.id = t.order_id';
		$q .= ' WHERE a.published = 1';
		$q .= ' AND t.type = '.$db->quote('brutto');
		$q .= ' AND DATE(a.date) >= '.$db->quote($dateFrom).' AND DATE(a.date) <= '.$db->quote($dateTo);

		$whereOrderStatus = '';
		if (!PhocacartStatistics::setWhereByOrderStatus($whereOrderStatus)) {
			return 0;
		}
		if ($whereOrderStatus != '') {
			$q .= 'AND '.$whereOrderStatus;
		}

		$db->setQuery($q);
		$count = $db->loadRow();
		if (isset($count[0]) && (int)$count[0] != 0) {
			return $this->abreviateNumbers($count[0]);
		}
		return 0;
	}

	/*
	 * http://stackoverflow.com/questions/13049851/php-number-abbreviator
	 */

	public function abreviateNumbers($value) {

		$abbreviations = array(12 => 'T', 9 => 'B', 6 => 'M', 3 => 'K', 0 => '');
		foreach($abbreviations as $exponent => $abbreviation) {
			if($value >= pow(10, $exponent)) {
				//return round(floatval($value / pow(10, $exponent))).$abbreviation;
				return round(floatval($value / pow(10, $exponent)),1).$abbreviation;
			}
		}
	}


	/*
	 * changes the $whereStatus variable
	 * return true or false, if false, this will influence whole sql query which will be completely ignored
	 */
	public static function setWhereByOrderStatus(&$whereStatus) {

		$paramsC					= PhocacartUtils::getComponentParameters();
		$statistics_order_status	= $paramsC->get( 'statistics_order_status', array(-1) );

		if (in_array(-1, $statistics_order_status)) {
			// All order statuses are set in statistics, where clause not needed
			return true;
		} else if (in_array(0, $statistics_order_status)) {
			// No status selected, no statistics, where clause not needed
			return false;
		} else {
			// Only some statuses selected, so where clause changed
			$whereStatus = 'a.status_id IN ('.implode(',', $statistics_order_status).')';
			return true;
		}
		return false;
	}
}
?>
