<?php
/**
 * Copyright 2017 Wim van Ravesteijn
*
* This file is part of AEGEE-Europe Statutory Event Applications.
*
* AEGEE-Europe Statutory Event Applications is free software: you can
* redistribute it and/or modify it under the terms of the GNU General
* Public License as published by the Free Software Foundation, either
* version 3 of the License, or (at your option) any later version.
*
* AEGEE-Europe Statutory Event Applications is distributed in the hope
* that it will be useful, but WITHOUT ANY WARRANTY; without even the
* implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR
* PURPOSE.  See the GNU General Public License for more details.
*
* You should have received a copy of the GNU General Public License
* along with AEGEE-Europe Statutory Event Applications.  If not, see
* <http://www.gnu.org/licenses/>.
*/

require_once "../../config.php";
require_once "../../include/dbconnection.php";
require_once "../../include/globals.php";

class ApiStatistics {
	public function __construct($path) {
		header("Content-Type: application/json");
		header("Access-Control-Allow-Origin: *");
		$fields = explode("/", $path);
		if( count($fields) == 2 ) {
			$data = $this->getData($fields[0], $fields[1]);
			if( $data != NULL ) {
				$this->sendJson($data);
			}else {
				$this->info();
			}
		}else {
			$this->info();
		}
	}
	
	private function getData($selection, $title) {
		$queryBuilder = new QueryBuilder($GLOBALS['DB'], "statistics");
		$queryBuilder->addField(array('id', 'json', 'image_height', 'image_width'));
		$queryBuilder->addWhereEquals("selection", $selection);
		$queryBuilder->addWhereEquals("title", $title);
		if( $GLOBALS['DB']->select($queryBuilder->toQuery()) == 1 ) {
			return $GLOBALS['DB']->fetchAssoc();
		}else {
			return NULL;
		}
	}
	
	private function sendJson($data) {
		$json = json_decode($data['json'], true);
		$json['image'] = "https://" . substr(FULL_URL, 0, -15) . "image/statistic.php?id=" . $data['id'];
		$json['height'] = $data['image_height'];
		$json['width'] = $data['image_width'];
		echo json_encode($json);
	}
	
	private function info() {
		$json = array();
		$json['info'] = "Please provide proper parameters: https://" . FULL_URL . "[selection]/[title]";
		$json['selection'] = array();
		$queryBuilder = new QueryBuilder($GLOBALS['DB'], "statistics");
		$queryBuilder->addField("selection");
		$queryBuilder->addGroup("selection");
		if( $GLOBALS['DB']->select($queryBuilder->toQuery()) > 0 ) {
			while( $row = $GLOBALS['DB']->fetchAssoc() ) {
				$json['selection'][] = $row['selection'];
			}
		}
		$json['title'] = array();
		$queryBuilder = new QueryBuilder($GLOBALS['DB'], "statistics");
		$queryBuilder->addField("title");
		$queryBuilder->addGroup("title");
		if( $GLOBALS['DB']->select($queryBuilder->toQuery()) > 0 ) {
			while( $row = $GLOBALS['DB']->fetchAssoc() ) {
				$json['title'][] = $row['title'];
			}
		}
		echo json_encode($json);
	}
}

new ApiStatistics($_SERVER["REDIRECT_QUERY_STRING"]);
?>