// 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();