// display information about this period
switch ($period) {
// all days
case "month":
$sql = "SELECT UNIX_TIMESTAMP(access_date)\n FROM {$TABLETRACK_ACCESS}\n WHERE access_tool = '{$tool}'\n {$courseCodeEqualcidIfNeeded}\n AND MONTH(access_date) = MONTH(FROM_UNIXTIME('{$reqdate}'))\n AND YEAR(access_date) = YEAR(FROM_UNIXTIME('{$reqdate}'))\n ORDER BY access_date ASC";
$days_array = StatsUtils::daysTab($sql);
StatsUtils::makeHitsTable($days_array, $langDay);
break;
// all days
// all days
case "week":
$sql = "SELECT UNIX_TIMESTAMP(access_date)\n FROM {$TABLETRACK_ACCESS}\n WHERE access_tool = '{$tool}'\n {$courseCodeEqualcidIfNeeded}\n AND WEEK(access_date) = WEEK(FROM_UNIXTIME('{$reqdate}'))\n AND YEAR(access_date) = YEAR(FROM_UNIXTIME('{$reqdate}'))\n ORDER BY access_date ASC";
$days_array = StatsUtils::daysTab($sql);
StatsUtils::makeHitsTable($days_array, $langDay);
break;
// all hours
// all hours
case "day":
$sql = "SELECT UNIX_TIMESTAMP(access_date)\n FROM {$TABLETRACK_ACCESS}\n WHERE access_tool = '{$tool}'\n {$courseCodeEqualcidIfNeeded}\n AND DAYOFYEAR(access_date) = DAYOFYEAR(FROM_UNIXTIME('{$reqdate}'))\n AND YEAR(access_date) = YEAR(FROM_UNIXTIME('{$reqdate}'))\n ORDER BY access_date ASC";
$hours_array = StatsUtils::hoursTab($sql, $reqdate);
StatsUtils::makeHitsTable($hours_array, $langHour);
break;
}
}
} else {
// not allowed to track
echo get_lang('NotAllowed');
}
echo '</table>';
// footer
Display::display_footer();
// all days
// all days
case "month":
$sql = "SELECT UNIX_TIMESTAMP( access_date )\n FROM {$TABLETRACK_ACCESS}\n WHERE MONTH(access_date) = MONTH (FROM_UNIXTIME( '{$reqdate}' ) )\n AND YEAR( access_date ) = YEAR( FROM_UNIXTIME( '{$reqdate}' ) )\n AND c_id = {$courseId}\n AND access_tool IS NULL ";
if ($displayType == "day") {
$sql .= "ORDER BY DAYOFYEAR( access_date)";
$days_array = StatsUtils::daysTab($sql);
StatsUtils::makeHitsTable($days_array, get_lang('PeriodDay'));
} else {
// by hours by default
$sql .= "ORDER BY HOUR( access_date)";
$hours_array = StatsUtils::hoursTab($sql);
StatsUtils::makeHitsTable($hours_array, get_lang('PeriodHour'));
}
break;
// all hours
// all hours
case "day":
$sql = "SELECT UNIX_TIMESTAMP( access_date )\n FROM {$TABLETRACK_ACCESS}\n WHERE DAYOFMONTH(access_date) = DAYOFMONTH(FROM_UNIXTIME( '{$reqdate}' ) )\n AND MONTH(access_date) = MONTH (FROM_UNIXTIME( '{$reqdate}' ) )\n AND YEAR( access_date ) = YEAR( FROM_UNIXTIME( '{$reqdate}' ) )\n AND c_id = {$courseId}\n AND access_tool IS NULL\n ORDER BY HOUR( access_date )";
$hours_array = StatsUtils::hoursTab($sql, $reqdate);
StatsUtils::makeHitsTable($hours_array, get_lang('PeriodHour'));
break;
}
} else {
// not allowed to track
api_not_allowed();
}
?>
</table>
<?php
Display::display_footer();
