#concrete5 retrieve file download statistics

get_download_statistics.php

<?php
$conn = Database::connection();
$qb = $conn->createQueryBuilder();

$qb->select('*')
   ->from('DownloadStatistics')
   ->orderBy('timestamp', 'ASC');
   
if ($startdate = $_GET['startdate']) {
    $qb->andWhere(
        $qb->expr()->gt('timestamp', ':startdate')
    )->setParameter('startdate', $startdate);
}
if ($enddate = $_GET['enddate']) {
    $qb->andWhere(
        $qb->expr()->lt('timestamp', ':enddate')
    )->setParameter('enddate', $enddate);
}

$results = $qb->execute();

while ($row = $results->fetch()) {
    $f = File::getByID($row['fID']);
    $fv = $f->getVersion($row['fvID']);
    $ui = UserInfo::getByID($row['uID']);
}