#!/usr/bin/env php
<?php

// Script to fetch translators from crowdin via the API
// and format into a BookStack attribution file.
$key = getenv('CROWDIN_PROJECT_KEY');
if (!$key) {
    echo "Crowdin project key needs to be set on [CROWDIN_PROJECT_KEY] environment variable to run this script";
    exit(0);
}

// Get the location of the attribution report.
$reportLocation = getcwd() . '/.github/translators.txt';
if (!file_exists($reportLocation)) {
    echo "Could not find the translators file at [{$reportLocation}]";
    echo "Are you running this script from the BookStack root folder?";
    exit(0);
}

$reportDelimiter = ' :: ';

$reportMap = loadExistingReportIntoMap($reportDelimiter, $reportLocation);
$csvReport = exportTopMembersReport($key);
$csvData = csv_to_array($csvReport);
mergeCsvDataIntoReportMap($reportMap, $csvData, $reportDelimiter);
formatAndWriteOutput($reportLocation, $reportMap, $reportDelimiter);

function formatAndWriteOutput(string $reportLocation, array $reportMap, string $reportDelimiter) {
    $output = "Name :: Languages\n";
    foreach ($reportMap as $name => $languages) {
        if (count($languages) === 0 || (count($languages) === 1 && empty($languages[0]))) continue;
        if ($name === 'Dan Brown (ssddanbrown)' || $name === 'Name') continue;
        $output .= $name . $reportDelimiter . implode('; ', $languages) . "\n";
    }

    file_put_contents($reportLocation, $output);
}

function mergeCsvDataIntoReportMap(array &$reportMap, array $csvData, string $reportDelimiter) {
    foreach ($csvData as $csvLine) {
        $name = $csvLine['Name'];
        $name = str_replace($reportDelimiter, '', $name);
        $languages = explode('; ', $csvLine['Languages']);
        if (isset($reportMap[$name])) {
            $languages = array_unique(array_merge($languages, $reportMap[$name]));
        }
        $reportMap[$name] = $languages;
    }
}

function loadExistingReportIntoMap($reportDelimiter, $reportLocation) {
    try {
        $reportData = file_get_contents($reportLocation);
    } catch (Exception $exception) {
        $reportData = '';
    }
    $reportLines = explode("\n", $reportData);
    $reportMap = [];
    foreach ($reportLines as $reportLine) {
        if (empty($reportLine)) continue;
        [$name, $langs] = explode($reportDelimiter, $reportLine);
        $splitLangs = explode('; ', $langs);
        $reportMap[$name] = $splitLangs;
    }
    return $reportMap;
}

function exportTopMembersReport($key) {
    $result = makeMemberExportReport($key);

    $exportHash = $result->hash;
    $csv = downloadMemberReport($exportHash, $key);

    return $csv;
}

function makeMemberExportReport(string $key) {
    $url = 'https://api.crowdin.com/api/project/bookstack/reports/top-members/export';
    $postData = [
        'date_from' => '2019-10-01',
        'date_to' => date('Y-m-d'),
        'format' => 'csv',
        'json' => true,
        'key' => $key,
    ];

    $ch = curl_init();
    curl_setopt($ch, CURLOPT_URL, $url);
    curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
    curl_setopt($ch, CURLOPT_TIMEOUT, 15);
    curl_setopt($ch, CURLOPT_POST, true);
    curl_setopt($ch, CURLOPT_POSTFIELDS, $postData);

    $result = curl_exec($ch);
    $httpCode = curl_getinfo($ch, CURLINFO_HTTP_CODE);
    $error = curl_error($ch);
    if ($error) {
        throw new Exception($error);
    }

    curl_close($ch);

    $data = json_decode($result);

    return $data;
}

function downloadMemberReport(string $exportHash, string $key) {
    $params = [
        'hash' => $exportHash,
        'key' => $key
    ];
    $url = 'https://api.crowdin.com/api/project/bookstack/reports/top-members/download';
    $url .= '?' . http_build_query($params);
    $ch = curl_init();
    curl_setopt($ch, CURLOPT_URL, $url);
    curl_setopt($ch, CURLOPT_TIMEOUT, 15);
    curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);

    $result = curl_exec($ch);
    curl_close($ch);

    return $result;
}

/**
 * Convert a comma separated string into an associated array.
 * @link http://gist.github.com/385876 (Modified)
 * @author Jay Williams <http://myd3.com/> (Modified)
 * @copyright Copyright (c) 2010, Jay Williams (Modified)
 * @license http://www.opensource.org/licenses/mit-license.php MIT License
 */
function csv_to_array(string $csvString): array
{

    $header = null;
    $data = [];
    $lines = explode("\n", trim($csvString));
    foreach ($lines as $line) {
        $csvLine = str_getcsv($line);
        if (!$header) {
            $header = $csvLine;
        } else {
            $data[] = array_combine($header, $csvLine);
        }
    }

    return $data;
}