Group Email

Refer to ticket #52

Requirements

The instructor (or admin) should be able to send a group email

A group can be:

• Students registered in a course
• Group members in a group
• Each student

Optional:

• User can use and edit his/her own email template
  • Ownership such as private, public, or shared among some group
• Email merge system, so template can have fields for variables
• Allowing a user to see and copy group email addresses, so he/she can use a preferred email client

Implementation

Getting email address

"send email" button on:

1. each type of page ;email addresses for 'to' field would be students who belongs to the type of page, for example
   1. all student if sent from course homepage
   2. all group member if sent from group view page
   3. student if sent from user view page
2. users tab page
   • email address of users are currently listed on the page.
     • currently having problem with ajaxlist to update Group filter by changing Course filter

Database Table

• Create custom_emails:

CREATE TABLE custom_emails (

id int(11) NOT NULL auto_increment,

name varchar(80) NOT NULL,

description text NOT NULL,

content text NOT NULL,

availability tinyint(4) NOT NULL,

creator_id int(11) NOT NULL default '0',

created date NOT NULL default '0000-00-00',

updater_id int(11) default NULL,

updated date default NULL,

PRIMARY KEY (id)

) ENGINE=InnoDB DEFAULT CHARSET=latin1;

• Insert into sys_functions

INSERT INTO sys_functions (id, function_code, function_name, parent_id, controller_name, url_link, permission_type, record_status, creator_id, created, updater_id, modified)

VALUES (1700, 'EMAIL_TEMPLATE', 'Email Templates', 0, 'emailer', 'emailer/index', 'AI', 'A', 0, '0000-00-00 00:00:00', NULL, NULL);

• Create and Insert email_merges:

-- -- Table structure for table email_merge --

CREATE TABLE email_merge (

id int(11) NOT NULL auto_increment,

key varchar(80) NOT NULL,

value varchar(80) NOT NULL,

field_name varchar(80) NOT NULL,

created datetime NOT NULL,

modified datetime NOT NULL,

PRIMARY KEY (id)

) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;

-- -- Dumping data for table email_merge --

INSERT INTO email_merge (id, key, value, field_name, created, modified) VALUES

(1, 'Username', '<<USERNAME>>', 'username', '2011-07-05 11:35:06', '2011-07-05 11:35:11'),

(2, 'First Name', '<<FIRSTNAME>>', 'first_name', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),

(3, 'Last Name', '<<LASTNAME>>', 'last_name', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),

(4, 'Email Address', '<<EMAIL>>', 'email', '0000-00-00 00:00:00', '0000-00-00 00:00:00');