Email reminders for calendar events

Introduction

Reminders are very useful for both students as well as teachers to recall their scheduled event before the actual moment. This project is about creating a set of reminders for Moodle calendar events and sending them automatically to relevant users on timely manner via Moodle message interface. It will be implemented as a local plugin to the Moodle.

Requirements

Moodle 2.2 required

Community Bonding Period

Milestones

1. Refine the project proposal with Michael and the community
2. Feature discussion
3. Create mockups

Features

Following features are expecting to package with the reminders plugin.

1. Administrator configurations

• Administrator can enable/disable the process of sending reminders without uninstalling the plugin.
• Ability to choose how many days ahead should the reminders be created for every due event in Moodle calendar.
  • Reminders can be created only by days.
  • Supported only fixed amount of days ahead such as 7 days, 5 days, 3 days and 1 day.

2. User configurations

• User can select desired method of receiving reminder notifications on corresponding message provider.

Coding Period

Milestones

1. Finalize the overall architecture.

2. Finalize file structure and database table schema.

3. Building the basic structure of the plugin - Implementation Phase 1

• Creating a suitable version file.
• Define the database structure in XMLDB file.
• Define capabilities.
• Define the message provider.
• Define a set of administrator page settings
  • Implement an option for enabling/disabling reminder.
  • Implement a set of options to configure per-defined number of days ahead which reminders should be invoked.
• Implement the initial script to be run.
• Creating a language file.

4. Building functions - Implementation Phase 2

• Creating a suitable version file.

File Structure

• db/access.php
• db/message.php
• db/install.php
• db/install.xml
• db/upgrade.php
• db/events.php
• lang/en/local_reminders.php
• version.php
• lib.php
• settings.php
• README

Database Structure

A single database will be used to store these reminders. Following shows its structure. (Subject to change)

Field	Type	Description
id	bigint(10)	Primary key for reminder records.
eventid	bigint(10)	Foreign key for corresponding event.
daysahead	bigint(10)	Number of days ahead such that reminder should be invoked.
enabled	smallint(4)	Indicates whether this single reminder is enabled or not. Disabled reminder will not be invoked only for that time. If it has been found enabled later, then it would be invoked.
mailed	smallint(4)	Indicates whether this reminder has been already mailed. Mailed reminders will be deleted after sometime.