From 200d92c8491d5060af5dd839aa82d1e51b058dd6 Mon Sep 17 00:00:00 2001
From: Simon Rettberg
Date: Fri, 2 Dec 2022 15:21:26 +0100
Subject: [statistics] Per-location usage stats; include active lecture count

---
 modules-available/locationinfo/api.inc.php | 68 +-----------------------------
 1 file changed, 1 insertion(+), 67 deletions(-)

(limited to 'modules-available/locationinfo/api.inc.php')

diff --git a/modules-available/locationinfo/api.inc.php b/modules-available/locationinfo/api.inc.php
index 2fbf1e84..ab1f2358 100644
--- a/modules-available/locationinfo/api.inc.php
+++ b/modules-available/locationinfo/api.inc.php
@@ -36,7 +36,7 @@ function HandleParameters()
 		$output = getLocationTree($locationIds);
 	} elseif ($get === "calendar") {
 		$locationIds = LocationInfo::getLocationsOr404($uuid);
-		$output = getCalendar($locationIds);
+		$output = LocationInfo::getCalendar($locationIds);
 	}
 	if ($output !== false) {
 		Header('Content-Type: application/json; charset=utf-8');
@@ -153,69 +153,3 @@ function findLocations($locations, $idList)
 	}
 	return $ret;
 }
-
-// ########## <Calendar> ###########
-/**
- * Gets the calendar of the given ids.
- *
- * @param int[] $idList list with the location ids.
- * @return array Calendar.
- */
-function getCalendar($idList)
-{
-	if (empty($idList))
-		return [];
-
-	// Build SQL query for multiple ids.
-	$query = "SELECT l.locationid, l.serverid, l.serverlocationid, s.servertype, s.credentials
-				FROM `locationinfo_locationconfig` AS l
-				INNER JOIN locationinfo_coursebackend AS s ON (s.serverid = l.serverid)
-				WHERE l.locationid IN (:idlist)
-				ORDER BY s.servertype ASC";
-	$dbquery = Database::simpleQuery($query, array('idlist' => array_values($idList)));
-
-	$serverList = array();
-	foreach ($dbquery as $dbresult) {
-		if (!isset($serverList[$dbresult['serverid']])) {
-			$serverList[$dbresult['serverid']] = array(
-				'credentials' => (array)json_decode($dbresult['credentials'], true),
-				'type' => $dbresult['servertype'],
-				'idlist' => array()
-			);
-		}
-		$serverList[$dbresult['serverid']]['idlist'][] = $dbresult['locationid'];
-	}
-
-	$resultArray = array();
-	foreach ($serverList as $serverid => $server) {
-		$serverInstance = CourseBackend::getInstance($server['type']);
-		if ($serverInstance === false) {
-			EventLog::warning('Cannot fetch schedule for location (' . implode(', ', $server['idlist']) . ')'
-				. ': Backend type ' . $server['type'] . ' unknown. Disabling location.');
-			Database::exec("UPDATE locationinfo_locationconfig SET serverid = NULL WHERE locationid IN (:lid)",
-				array('lid' => $server['idlist']));
-			continue;
-		}
-		$credentialsOk = $serverInstance->setCredentials($serverid, $server['credentials']);
-
-		if ($credentialsOk) {
-			$calendarFromBackend = $serverInstance->fetchSchedule($server['idlist']);
-		} else {
-			$calendarFromBackend = array();
-		}
-
-		LocationInfo::setServerError($serverid, $serverInstance->getErrors());
-
-		if (is_array($calendarFromBackend)) {
-			foreach ($calendarFromBackend as $key => $value) {
-				$resultArray[] = array(
-					'id' => $key,
-					'calendar' => $value,
-				);
-			}
-		}
-	}
-	return $resultArray;
-}
-
-// ########## </Calendar> ##########
-- 
cgit v1.2.3-55-g7522