get_statistics.php

<?php
require_once 'config.php';
require_once 'classes/ChangesetsWalker.class.php';
require_once 'classes/ChangesetsDao.class.php';
require_once 'classes/UserRanksDao.class.php';
require_once 'classes/ChangesetsWalkerStateDao.class.php';

//mysqli_report(MYSQLI_REPORT_ERROR | MYSQLI_REPORT_STRICT);
// all calculations must be done in UTC!
date_default_timezone_set('UTC');

/* when/if https://github.com/openstreetmap/openstreetmap-website/pull/2145 or similar is
 * merged, we might add a proper check here, requiring each user to prove to this API that
 * this user actually has an access token for the user it tries to get the statistics for. */
if (!startsWith($_SERVER['HTTP_USER_AGENT'], "StreetComplete") && $_SERVER["REMOTE_ADDR"] != '127.0.0.1') {
    returnError(403, 'This is not a public API');
}

if (!isset($_GET['user_id'])) {
    returnError(400, 'Missing user_id parameter');
}
$user_id = (int) $_GET['user_id'];
if (!is_int($user_id)) {
    returnError(400, 'user_id must be an integer');
}

try {

    $mysqli = new mysqli(Config::DB_HOST, Config::DB_USER, Config::DB_PASS, Config::DB_NAME);
    $mysqli->query('SET SESSION time_zone="+0:00"');
    $changesets_walker = new ChangesetsWalker($mysqli, Config::DB_NAME, Config::OSM_OAUTH_TOKEN);
    $last_update_date = $changesets_walker->getLastUpdateDate($user_id);
    if (time() >= $last_update_date + Config::MIN_DELAY_BETWEEN_CHANGESET_ANALYZING_IN_SECONDS) {
        $changesets_walker->analyzeUser($user_id, Config::MAX_CHANGESET_ANALYZING_IN_SECONDS);
    }

    $changesets_dao = new ChangesetsDao($mysqli);
    $solved_quest_types = $changesets_dao->getSolvedQuestCounts($user_id);
    $solved_by_country = $changesets_dao->getSolvedQuestsByCountry($user_id);
    $current_week_solved_quest_types = $changesets_dao->getSolvedQuestCounts($user_id, 7);
    $current_week_solved_by_country = $changesets_dao->getSolvedQuestsByCountry($user_id, 7);
    $days_active = $changesets_dao->getDaysActive($user_id);
    $active_dates_range = 100;
    $active_dates = $changesets_dao->getActiveDates($user_id, $active_dates_range);

    $user_ranks_dao = new UserRanksDao($mysqli);
    $rank = $user_ranks_dao->getRank($user_id);
    $country_ranks = $user_ranks_dao->getCountryRanks($user_id);

    $user_current_week_ranks_dao = new UserRanksDao($mysqli, 'user_ranks_current_week');
    $current_week_rank = $user_current_week_ranks_dao->getRank($user_id);
    $current_week_country_ranks = $user_current_week_ranks_dao->getCountryRanks($user_id);

    $changesets_walker_state_dao = new ChangesetsWalkerStateDao($mysqli);
    $last_update = $changesets_walker_state_dao->getLastUpdateDate($user_id);
    $is_analyzing = $changesets_walker_state_dao->isAnalyzing($user_id);

    $mysqli->close();
} catch (Exception $e) {
    returnError(500, $e->getMessage());
}

http_response_code(200);
header('Content-Type: application/json');
exit(json_encode(array(
    'questTypes' => empty($solved_quest_types) ? new stdClass() : $solved_quest_types,
    'countries' => empty($solved_by_country) ? new stdClass() : $solved_by_country,
    'daysActive' => $days_active,
    'rank' => $rank ? $rank : -1,
    'countryRanks' => empty($country_ranks) ? new stdClass() : $country_ranks,
    'lastUpdate' => date('c', $last_update),
    'isAnalyzing' => $is_analyzing,
    'currentWeekRank' => $current_week_rank ? $current_week_rank : -1,
    'currentWeekCountryRanks' => empty($current_week_country_ranks) ? new stdClass() : $current_week_country_ranks,
    'currentWeekQuestTypes' => empty($current_week_solved_quest_types) ? new stdClass() : $current_week_solved_quest_types,
    'currentWeekCountries' => empty($current_week_solved_by_country) ? new stdClass() : $current_week_solved_by_country,
    'activeDatesRange' => $active_dates_range,
    'activeDates' => empty($active_dates) ? array() : $active_dates
)));

function returnError($code, $message)
{
    http_response_code($code);
    header('Content-Type: application/json');
    exit(json_encode(array('error' => $message)));
}

function startsWith($haystack, $needle): bool
{
     $length = strlen($needle);
     return (substr($haystack, 0, $length) === $needle);
}