x-tools / xtools

     * @param  string     $end End date.

     * @return array

     */

    private function getToolUsageStats(Connection $client, $table, $start, $end)

    {

        $query = $client->prepare("SELECT * FROM $table

                                   WHERE date >= :start AND date <= :end");

        $query->bindParam('start', $start);

        $query->bindParam('end', $end);

        $query->execute();

        $data = $query->fetchAll();

        // Create array of totals, along with formatted timeline data as needed by Chart.js

        $totals = [];

        $dateLabels = [];

        $timeline = [];

        $startObj = new DateTime($start);

        $endObj = new DateTime($end);

        $numDays = (int) $endObj->diff($startObj)->format("%a");

        $grandSum = 0;

        // Generate array of date labels

        for ($dateObj = new DateTime($start); $dateObj <= $endObj; $dateObj->modify('+1 day')) {

            $dateLabels[] = $dateObj->format('Y-m-d');

        }

        foreach ($data as $entry) {

            if (!isset($totals[$entry['tool']])) {

                $totals[$entry['tool']] = (int) $entry['count'];

                // Create arrays for each tool, filled with zeros for each date in the timeline

                $timeline[$entry['tool']] = array_fill(0, $numDays, 0);

            } else {

                $totals[$entry['tool']] += (int) $entry['count'];

            }

            $date = new DateTime($entry['date']);

            $dateIndex = (int) $date->diff($startObj)->format("%a");

            $timeline[$entry['tool']][$dateIndex] = (int) $entry['count'];

            $grandSum += $entry['count'];

        }

        arsort($totals);

        return [

            'totals' => $totals,

            'grandSum' => $grandSum,

            'dateLabels' => $dateLabels,

            'timeline' => $timeline,

        ];

    }

    /**

     * Get usage statistics of the API.

     * @param  string     $end End date.

     * @return array

     */

    private function getApiUsageStats(Connection $client, $start, $end)

    {

        $query = $client->prepare("SELECT * FROM usage_api_timeline

                                   WHERE date >= :start AND date <= :end");

        $query->bindParam('start', $start);

        $query->bindParam('end', $end);

        $query->execute();

        $data = $query->fetchAll();

        // Create array of totals, along with formatted timeline data as needed by Chart.js

        $totals = [];

        $dateLabels = [];

        $timeline = [];

        $startObj = new DateTime($start);

        $endObj = new DateTime($end);

        $numDays = (int) $endObj->diff($startObj)->format("%a");

        $grandSum = 0;

        // Generate array of date labels

        for ($dateObj = new DateTime($start); $dateObj <= $endObj; $dateObj->modify('+1 day')) {

            $dateLabels[] = $dateObj->format('Y-m-d');

        }

        foreach ($data as $entry) {

            if (!isset($totals[$entry['endpoint']])) {

                $totals[$entry['endpoint']] = (int) $entry['count'];

                // Create arrays for each endpoint, filled with zeros for each date in the timeline

                $timeline[$entry['endpoint']] = array_fill(0, $numDays, 0);

            } else {

                $totals[$entry['endpoint']] += (int) $entry['count'];

            }

            $date = new DateTime($entry['date']);

            $dateIndex = (int) $date->diff($startObj)->format("%a");

            $timeline[$entry['endpoint']][$dateIndex] = (int) $entry['count'];

            $grandSum += $entry['count'];

        }

        arsort($totals);

        return [

            'totals' => $totals,

            'grandSum' => $grandSum,

            'dateLabels' => $dateLabels,

            'timeline' => $timeline,

        ];

    }

    /**

     * Record usage of a particular XTools tool. This is called automatically