<?php
defined('C5_EXECUTE') or die("Access Denied.");
?>
 
<?php
$db = Loader::db();
$downloads = File::getDownloadStatistics(100);
//$this->set('downloads', $downloads);
 
?>
 
<br /><br />
<h3><center><?php echo t('100 Most Recent Downloads')?></center></h3>
 
<table class="table"  id="ccm-site-statistics-downloads">
<thead>
<tr>
   <th><?php echo t('File')?></th>
   <th><?php echo t('User')?></th>
   <th><?php echo t('Email')?></th>
   <th><?php echo t('Downloaded On')?></th>
</tr>
</thead>
<tbody>
<?php  if (count($downloads) == 0) { ?>
   <tr>
      <td colspan="4" style="text-align: center"><?php echo t('No files have been downloaded.')?></td>
   </tr>
<?php  } else { ?>
<?php 
   foreach($downloads as $download) {
      $f = File::getByID($download['fID']);
      if (!is_object($f)) {
         continue;
      }
      ?>
   <tr>
      <td class='ccm-site-statistics-downloads-title'><a href="<?php echo $f->getDownloadURL()?>" title="<?php echo $f->getTitle();?>"><?php 
      $title = $f->getTitle();
      $maxlen = 70;
      if (strlen($title) > ($maxlen-4)) {
         $ext = substr($title,strrpos($title, '.'));
         if (substr($ext,0,1) != '.') { $ext = ''; }
         $title = substr($title,0,$maxlen-4-strlen($ext)).'[..]'.$ext;
      }
      echo $title;
      ?></a></td>
      <td>
         <?php 
         $uID=intval($download['uID']);
         if(!$uID){
            echo t('Anonymous');
         }else{
            $downloadUI = UserInfo::getById($uID);
            if($downloadUI instanceof UserInfo) {
               echo $downloadUI->getUserName();
            } else {
               echo t('Deleted User');
            }
         }
         ?>
      </td>
 
      <td>
         <?php 
            $uEmail = UserInfo::getByID($uID->uEmail);
            echo $uID;
            //echo $uID;
 
            //$uEmail = $db->GetOne("select uEmail from Users where $uID");
            //$uEmail=$download['uEmail'];
            //echo $uEmail;
 
            //echo $uEmail
         ?>
      </td>
 
      <td><?php echo date(DATE_APP_GENERIC_MDYT, strtotime($download['timestamp']))?></td>
   </tr>
   <?php  } ?>
<?php  } ?>
</table>
 
<br /><br />