/** * @brief summarize monthly actions */ function summarizeMonthlyActions() { require_once 'include/action.php'; $action = new action(); Database::get()->queryFunc("SELECT id FROM course", function($course) use (&$action) { $min_time = ($res = Database::get()->querySingle("SELECT MIN(day) as min_time FROM actions_daily WHERE course_id = ?d", intval($course->id))) ? $res->min_time : time(); if ($min_time + get_config('actions_expire_interval') * 30 * 24 * 3600 < time()) { $action->summarize($course->id); } }); }
$u_date_end = $date_end->format('Y-m-d H:i'); $user_date_end = $date_end->format('d-m-Y H:i'); } $result = Database::get()->queryArray("SELECT MIN(day) AS min_time FROM actions_daily WHERE course_id = ?d", $course_id); foreach ($result as $row) { if (!empty($row->min_time)) { $min_time = strtotime($row->min_time); } else break; } if ($min_time + get_config('actions_expire_interval') * 30 * 24 * 3600 < time()) { // actions more than X months old $action = new action(); $action->summarize(); // move data to action_summary } $result = Database::get()->queryArray("SELECT MIN(day) AS min_time FROM actions_daily WHERE course_id = ?d", $course_id); foreach ($result as $row) { if (!empty($row->min_time)) { $min_time = strtotime($row->min_time); } else break; } $min_t = date("d-m-Y", $min_time); $made_chart = true; //make chart require_once 'modules/graphics/plotter.php';