index.php

 <?php
// This file is part of Moodle - http://moodle.org/
//
// Moodle is free software: you can redistribute it and/or modify
// it under the terms of the GNU General Public License as published by
// the Free Software Foundation, either version 3 of the License, or
// (at your option) any later version.
//
// Moodle is distributed in the hope that it will be useful,
// but WITHOUT ANY WARRANTY; without even the implied warranty of
// MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
// GNU General Public License for more details.
//
// You should have received a copy of the GNU General Public License
// along with Moodle.  If not, see <http://www.gnu.org/licenses/>.
/**
 * This page prints the blog index page
 *
 * @author Matt Clarkson <mattc@catalyst.net.nz>
 * @package oublog
 */

require_once("../../config.php");
require_once("locallib.php");

$id = required_param('id', PARAM_INT);   // course

if (! $course = $DB->get_record('course', array('id'=>$id))) {
    throw new moodle_exception('coursemisconf');
}

// Support for OU shared activities system, if installed
$grabindex=$CFG->dirroot.'/course/format/sharedactv/grabindex.php';
if (file_exists($grabindex)) {
    require_once($grabindex);
}

require_course_login($course);

// Trigger instances list viewed event.
$params = array(
    'context' => context_course::instance($course->id)
);
$event = \mod_oublog\event\course_module_instance_list_viewed::create($params);
$event->add_record_snapshot('course', $course);
$event->trigger();

$strweek = get_string('week');
$strtopic = get_string('topic');
$strname = get_string('name');
$strdata = get_string('modulename', 'oublog');
$strdataplural  = get_string('modulenameplural', 'oublog');
$url = new moodle_url('/mod/oublog/index.php', array('id' => $course->id));
$PAGE->navbar->add($strdata, $url);
$PAGE->set_title($strdata);
$PAGE->set_heading(format_string($course->fullname));
$PAGE->set_url($url);
echo $OUTPUT->header();

// Print the list of blogs.
if (!$blogs = get_all_instances_in_course('oublog', $course)) {
    notice(get_string('thereareno', 'moodle', $strdataplural) , "$CFG->wwwroot/course/view.php?id=$course->id");
}

// Get the post count
$sql = "SELECT o.id, COUNT(p.id) as postcount
        FROM {oublog} o
        INNER JOIN {oublog_instances} i ON i.oublogid = o.id
        INNER JOIN {oublog_posts} p ON p.oubloginstancesid = i.id
        WHERE o.course = ? AND p.deletedby IS NULL
        GROUP BY o.id ";
$counts = $DB->get_records_sql($sql, array($course->id));

$timenow  = time();
$strname  = get_string('name');
$strweek  = get_string('week');
$strtopic = get_string('topic');
$strdescription = get_string('blogsummary', 'oublog');
$strentries = get_string('posts', 'oublog');
$table = new html_table();

if ($course->format == 'weeks') {
    $table->head  = array ($strweek, $strname, $strdescription, $strentries);
    $table->align = array ('center', 'center', 'center', 'center');
} else if ($course->format == 'topics') {
    $table->head  = array ($strtopic, $strname, $strdescription, $strentries);
    $table->align = array ('center', 'center', 'center', 'center');
} else {
    $table->head  = array ($strname, $strdescription, $strentries);
    $table->align = array ('center', 'center', 'center');
}

$currentsection = '';

foreach ($blogs as $blog) {

    $printsection = '';

    // Calculate the href.
    if (!$blog->visible) {
        // Show dimmed if the mod is hidden.
        $link = "<a class=\"dimmed\" href=\"view.php?id=$blog->coursemodule\">".format_string($blog->name, true)."</a>";
    } else {
        // Show normal if the mod is visible.
        $link = "<a href=\"view.php?id=$blog->coursemodule\">".format_string($blog->name, true)."</a>";
    }

    $numposts = isset($counts[$blog->id]) ? $counts[$blog->id]->postcount : 0;

    if ($course->format == 'weeks' || $course->format == 'topics') {
        if ($blog->section !== $currentsection) {
            if ($blog->section) {
                $printsection = $blog->section;
            }
            if ($currentsection !== '') {
                $table->data[] = 'hr';
            }
            $currentsection = $blog->section;
        }
        $row = array ($printsection, $link, format_string($blog->intro, true), $numposts);

    } else {
        $row = array ($link, format_string($blog->intro, true), $numposts);
    }

    $table->data[] = $row;
}

echo "<br />";
echo html_writer::table($table);
echo $OUTPUT->footer();