To add the total course completed and login chart in the current year to the dashboard, you need to get a query from course complete and login from the database. We created 2 series in the same chart, one is a bar chart (stand by total login) and another is a series type line (stand by total course completed), and both data are displayed by month. $cyear = date("Y"); is getting current year. $userId = $USER->id; is getting user ID or student ID. <pre data-lang="PHP"> // Set labels for months $chart->set_labels([ 'Jan', 'Feb', 'Mar', 'Apr', 'May', 'Jun', 'Jul', 'Aug', 'Sep', 'Oct', 'Nov', 'Dec' ]);</pre> open your code and go to Moodle->My-> <strong>index.php</strong> Follow and add code as below: <div class="hcb_wrap"> <pre class="prism undefined-numbers lang-php" data-lang="PHP"><code><?php global $PAGE, $USER, $DB, $cyear; $cyear = date("Y"); $userId = $USER->id; <h4 class="card-title">Own Summary course completed and login in <?php echo $cyear ?></h4> <div style="overflow-x:auto;"> <?php global $DB; // Query for course completions $completions_sql = "SELECT MONTH(FROM_UNIXTIME(cp.timecompleted)) AS month, COUNT(c.id) AS total_completions FROM {course_completions} cp JOIN {course} c ON cp.course = c.id JOIN {user} u ON cp.userid = u.id WHERE u.id = $userId and YEAR(FROM_UNIXTIME(cp.timecompleted)) = $cyear GROUP BY month"; $completions_data = $DB->get_records_sql($completions_sql); // Query for logins $logins_sql = "SELECT MONTH(FROM_UNIXTIME(l.timecreated)) AS month, COUNT(l.userid) AS total_logins FROM {logstore_standard_log} l WHERE l.action = 'loggedin' AND l.userid = $userId AND YEAR(FROM_UNIXTIME(l.timecreated)) = $cyear GROUP BY month"; $logins_data = $DB->get_records_sql($logins_sql); // Prepare months and series data for the chart $months = range(1, 12); // 12 months $completions_series = []; $logins_series = []; // Loop through months to populate data foreach ($months as $month) { $completions_series[] = isset($completions_data[$month]) ? $completions_data[$month]->total_completions : 0; $logins_series[] = isset($logins_data[$month]) ? $logins_data[$month]->total_logins : 0; } // Add series to the chart $chart = new \core\chart_bar(); $s1 = new \core\chart_series('Total Completions', $completions_series); $s1->set_type(\core\chart_series::TYPE_LINE); $chart->add_series($s1); $s2 = new \core\chart_series('Total Logins', $logins_series); $chart->add_series($s2); // Set labels for months $chart->set_labels([ 'Jan', 'Feb', 'Mar', 'Apr', 'May', 'Jun', 'Jul', 'Aug', 'Sep', 'Oct', 'Nov', 'Dec' ]); // Render the chart echo $OUTPUT->render($chart); ?> </div></code></pre> </div> Check the result with the chart below: [gallery link="file" size="full" columns="1" ids="2639,2640"]
