<?php
/**
 * This file provides the BusinessAdmin class
 *
 * @author Camil Staps
 *
 * BusinessAdmin: administrative software for small companies
 * Copyright (C) 2015 Camil Staps (ViviSoft)
 *
 * This program 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.
 *
 * This program 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 this program.  If not, see <http://www.gnu.org/licenses/>.
 */

/**
 * Provides basic functions like adding elements to the database
 */
class BusinessAdmin {
	//------------------------------------------------------------------------------
	// Getters and setters
	//------------------------------------------------------------------------------

	/**
	 * Get all user ids
	 *
	 * @see BusinessAdmin::getUsers()         This funtion returns instances of the user class instead of just the ids
	 *
	 * @param PDO $pdo                        The PDO class for database connection
	 * @param string[] $where                 An array of WHERE clauses that will be AND-ed into a prepared statement
	 * @param mixed[] $variables              An array of variables that should go into the prepared statement
	 *
	 * @throws PDOException                   Is something went wrong with the database
	 *
	 * @return int[]                          The ids
	 */
	public static function getUserIds($pdo, $where = [], $variables = []) {
		$ids = [];
		$users = $pdo->prepare("SELECT `id` FROM `".Constants::db_prefix."user`" . ((count($where) > 0) ? (" WHERE (" . implode(') AND (', $where) . ")") : ""));
		$users->execute($variables);
		$users = $users->fetchAll(PDO::FETCH_ASSOC);
		foreach ($users as $user) {
			$ids[] = $user['id'];
		}
		return $ids;
	}

	/**
	 * Get all users
	 *
	 * @see BusinessAdmin::getUserIds()       This function returns just the ids of the users, and not instances of the user class
	 *
	 * @param PDO $pdo                        The PDO class for database connection
	 * @param string[] $where                 An array of WHERE clauses that will be AND-ed into a prepared statement
	 * @param mixed[] $variables              An array of variables that should go into the prepared statement
	 *
	 * @throws PDOException                   If something went wrong with the database
	 *
	 * @return user[]                         An array indexed by id of instances of the user class
	 */
	public static function getUsers($pdo, $where = [], $variables = []) {
		$ids = self::getUserIds($pdo, $where, $variables);
		$users = [];
		foreach ($ids as $id) {
			$users[$id] = new User($pdo, $id);
		}
		return $users;
	}

	/**
	 * Get all file ids
	 *
	 * @see BusinessAdmin::getFiles()         This funtion returns instances of the file class instead of just the ids
	 *
	 * @param PDO $pdo                        The PDO class for database connection
	 * @param string[] $where                 An array of WHERE clauses that will be AND-ed into a prepared statement
	 * @param mixed[] $variables              An array of variables that should go into the prepared statement
	 *
	 * @throws PDOException                   Is something went wrong with the database
	 *
	 * @return int[]                          The ids
	 */
	public static function getFileIds($pdo, $where = [], $variables = []) {
		$ids = [];
		$files = $pdo->prepare("SELECT `id` FROM `".Constants::db_prefix."file`" . ((count($where) > 0) ? (" WHERE (" . implode(') AND (', $where) . ")") : ""));
		$files->execute($variables);
		$files = $files->fetchAll(PDO::FETCH_ASSOC);
		foreach ($files as $file) {
			$ids[] = $file['id'];
		}
		return $ids;
	}

	/**
	 * Get all files
	 *
	 * @see BusinessAdmin::getFileIds()       This function returns just the ids of the files, and not instances of the file class
	 *
	 * @param PDO $pdo                        The PDO class for database connection
	 * @param string[] $where                 An array of WHERE clauses that will be AND-ed into a prepared statement
	 * @param mixed[] $variables              An array of variables that should go into the prepared statement
	 *
	 * @throws PDOException                   If something went wrong with the database
	 *
	 * @return file[]                         An array indexed by id of instances of the file class
	 */
	public static function getFiles($pdo, $where = [], $variables = []) {
		$ids = self::getFileIds($pdo, $where, $variables);
		$files = [];
		foreach ($ids as $id) {
			$files[$id] = new File($pdo, $id);
		}
		return $files;
	}

	/**
	 * Get all client ids
	 *
	 * @see BusinessAdmin::getClients()       This funtion returns instances of the client class instead of just the ids
	 *
	 * @param PDO $pdo                        The PDO class for database connection
	 *
	 * @throws PDOException                   If something went wrong with the database
	 *
	 * @return int[]                          The ids
	 */
	public static function getClientIds($pdo) {
		$ids = array();
		$clients = $pdo->query("SELECT `id` FROM `".Constants::db_prefix."client`")->fetchAll(PDO::FETCH_ASSOC);
		foreach ($clients as $client) {
			$ids[] = $client['id'];
		}
		return $ids;
	}

	/**
	 * Get all clients
	 *
	 * @see BusinessAdmin::getClientIds()     This function returns just the ids of the clients, and not instances of the client class
	 *
	 * @param PDO $pdo                        The PDO class for database connection
	 *
	 * @throws PDOException                   If something went wrong with the database
	 *
	 * @return client[]                       An array indexed by id of instances of the client class
	 */
	public static function getClients($pdo) {
		$ids = self::getClientIds($pdo);
		$clients = array();
		foreach ($ids as $id) {
			$clients[$id] = new Client($pdo, $id);
		}
		return $clients;
	}

	/**
	 * Get all contact ids
	 *
	 * @see BusinessAdmin::getContacts()      This funtion returns instances of the contact class instead of just the ids
	 *
	 * @param PDO $pdo                        The PDO class for database connection
	 *
	 * @throws PDOException                   Is something went wrong with the database
	 *
	 * @return int[]                          The ids
	 */
	public static function getContactIds($pdo) {
		$ids = array();
		$contacts = $pdo->query("SELECT `id` FROM `".Constants::db_prefix."contact`")->fetchAll(PDO::FETCH_ASSOC);
		foreach ($contacts as $contact) {
			$ids[] = $contact['id'];
		}
		return $ids;
	}

	/**
	 * Get all contacts
	 *
	 * @see BusinessAdmin::getContactIds()    This function returns just the ids of the contacts, and not instances of the contact class
	 *
	 * @param PDO $pdo                        The PDO class for database connection
	 *
	 * @throws PDOException                   If something went wrong with the database
	 *
	 * @return contact[]                      An array indexed by id of instances of the contact class
	 */
	public static function getContacts($pdo) {
		$ids = self::getContactIds($pdo);
		$contacts = array();
		foreach ($ids as $id) {
			$contacts[$id] = new Contact($pdo, $id);
		}
		return $contacts;
	}

	/**
	 * Get all offer ids
	 *
	 * @see BusinessAdmin::getOffers()        This funtion returns instances of the offer class instead of just the ids
	 *
	 * @param PDO $pdo                        The PDO class for database connection
	 * @param string[] $where                 An array of WHERE clauses that will be AND-ed
	 *
	 * @throws PDOException                   Is something went wrong with the database
	 *
	 * @return int[]                          The ids
	 */
	public static function getOfferIds($pdo, $where = array()) {
		$ids = array();
		$offers = $pdo->query("SELECT `id` FROM `".Constants::db_prefix."offer`" . ((count($where) > 0) ? (" WHERE (" . implode(') AND (', $where) . ")") : ""))->fetchAll(PDO::FETCH_ASSOC);
		foreach ($offers as $offer) {
			$ids[] = $offer['id'];
		}
		return $ids;
	}

	/**
	 * Get all offers
	 *
	 * @see BusinessAdmin::getOfferIds()      This function returns just the ids of the offers, and not instances of the offer class
	 *
	 * @param PDO $pdo                        The PDO class for database connection
	 * @param string[] $where                 An array of WHERE clauses that will be AND-ed
	 *
	 * @throws PDOException                   If something went wrong with the database
	 *
	 * @return offer[]                        An array indexed by id of instances of the offer class
	 */
	public static function getOffers($pdo, $where = array()) {
		$ids = self::getOfferIds($pdo, $where);
		$offers = array();
		foreach ($ids as $id) {
			$offers[$id] = new Offer($pdo, $id);
		}
		return $offers;
	}

	/**
	 * Get all assignment ids
	 *
	 * @see BusinessAdmin::getAssignments()   This funtion returns instances of the assignment class instead of just the ids
	 *
	 * @param PDO $pdo                        The PDO class for database connection
	 * @param string[] $where                 An array of WHERE clauses that will be AND-ed
	 *
	 * @throws PDOException                   Is something went wrong with the database
	 *
	 * @return int[]                          The ids
	 */
	public static function getAssignmentIds($pdo, $where = array()) {
		$ids = array();
		$assignments = $pdo->query("SELECT `id` FROM `".Constants::db_prefix."assignment`" . ((count($where) > 0) ? (" WHERE (" . implode(') AND (', $where) . ")") : ""))->fetchAll(PDO::FETCH_ASSOC);
		foreach ($assignments as $assignment) {
			$ids[] = $assignment['id'];
		}
		return $ids;
	}

	/**
	 * Get all assignments
	 *
	 * @see BusinessAdmin::getAssignmentIds() This function returns just the ids of the assignments, and not instances of the assignment class
	 *
	 * @param PDO $pdo                        The PDO class for database connection
	 * @param string[] $where                 An array of WHERE clauses that will be AND-ed
	 *
	 * @throws PDOException                   If something went wrong with the database
	 *
	 * @return assignment[]                   An array indexed by id of instances of the assignment class
	 */
	public static function getAssignments($pdo, $where = array()) {
		$ids = self::getAssignmentIds($pdo, $where);
		$assignments = array();
		foreach ($ids as $id) {
			$assignments[$id] = new Assignment($pdo, $id);
		}
		return $assignments;
	}

	/**
	 * Get all discount ids
	 *
	 * @see BusinessAdmin::getDiscounts()     This funtion returns instances of the discount class instead of just the ids
	 *
	 * @param PDO $pdo                        The PDO class for database connection
	 * @param string[] $where                 An array of WHERE clauses that will be AND-ed
	 *
	 * @throws PDOException                   Is something went wrong with the database
	 *
	 * @return int[]                          The ids
	 */
	public static function getDiscountIds($pdo, $where = array()) {
		$ids = array();
		$discounts = $pdo->query("SELECT `id` FROM `".Constants::db_prefix."discount`" . ((count($where) > 0) ? (" WHERE (" . implode(') AND (', $where) . ")") : ""))->fetchAll(PDO::FETCH_ASSOC);
		foreach ($discounts as $discount) {
			$ids[] = $discount['id'];
		}
		return $ids;
	}

	/**
	 * Get all discounts
	 *
	 * @see BusinessAdmin::getDiscountIds()   This function returns just the ids of the discounts, and not instances of the discount class
	 *
	 * @param PDO $pdo                        The PDO class for database connection
	 * @param string[] $where                 An array of WHERE clauses that will be AND-ed
	 *
	 * @throws PDOException                   If something went wrong with the database
	 *
	 * @return discount[]                     An array indexed by id of instances of the discount class
	 */
	public static function getDiscounts($pdo, $where = array()) {
		$ids = self::getDiscountIds($pdo, $where);
		$discounts = array();
		foreach ($ids as $id) {
			$discounts[$id] = new Discount($pdo, $id);
		}
		return $discounts;
	}

	//------------------------------------------------------------------------------
	// Other functions
	//------------------------------------------------------------------------------

	/**
	 * Format a date nicely
	 *
	 * @param int $timestamp                  The UNIX timestamp to format
	 * @param bool $with_time                 If false, only the date is returned; if false, also the time
	 * @param bool $full_date                 If true, a year will be outputted even if the date is in the current year
	 * @param bool $relatively                Whether or not to show the date relatively (e.g. '1 day ago')
	 *
	 * @return string The formatted date
	 */
	public static function formatDate($timestamp, $with_time = true, $full_date = false, $relatively = false) {
		if ($relatively) {
			$delta  = time() - $timestamp;
			$second = 1;
			$minute = 60 * $second;
			$hour   = 60 * $minute;
			$day    = 24 * $hour;
			$month  = 30 * $day;
			$year   = 365 * $day;
			if ($delta < 2 * $minute)
				return 'just now';
			if ($delta < 45 * $minute)
				return floor($delta / $minute) . ' minutes ago';
			if ($delta < 90 * $minute)
				return 'an hour ago';
			if ($delta < 24 * $hour)
				return floor($delta / $hour) . ' hours ago';
			if ($delta < 48 * $hour)
				return 'yesterday';
			if ($delta < 30 * $day)
				return floor($delta / $day) . ' days ago';

			$output = [];
			$years = floor($delta / $year);
			if ($years != 0)
				$output[] = $years == 1 ? 'one year' : $years . ' years';
			$delta -= $years * $year;
			$months = floor($delta / $month);
			if ($months != 0)
				$output[] = $months == 1 ? 'one month' : $months . ' months';
			return implode(', ', $output);
		}

		if (date('Y', $timestamp) == 1970)
			return 'never';
		if (date('d/m/Y') == date('d/m/Y', $timestamp))
			return 'today';

		$output = '';
		if (date('Y') != date('Y', $timestamp) || $full_date)
			$output .= date('Y-', $timestamp);
		if (date('d/m/Y') != date('d/m/Y', $timestamp) || $full_date)
			$output .= date('m-d', $timestamp);
		if ($with_time)
			$output .= date(' H:i', $timestamp);

		return $output;
	}
}