This is an old revision of the document!
Table of Contents
Learnexa Content Update Feature
Requirement
1) Admin/Instructor should be able to update the contents created by them. 2) There should also be an option to auto publish the content based on time periods. 3) Users enrolled to these updated contents should be notified and provided an option to refresh the content.
Implementation
1) In content edit lightbox “Update Content” button should be added, on clicking that it should provide a form to add new item to the content.
2) Once new item is added, all the items of that content should be listed. Beside each item “Publish” link should be shown, the currently active item will have “Published” text mentioned. Only one item can be published at a time, which means a content can have only one active item.
3) Beside each items listed in the content, there should be an optional date time field to set from when the item can be published automatically. The active item will have “Effective Now” text shown instead of date time field. This is to auto publish the items from certain time period.
4) If user is enrolled to a course, the contents of that course will show only the item that got published during course enrolled. Even if that item it set to unpublished state, the same be be seen by the user. The updated contents will reflect on future enrollments only.
5) Enrolled user can get a notification mentioning that the content has been updated and if he would like to refresh the content. This notification will only be should for active enrollments and the progress/score will be reset for the content post refresh.
Database Changes
Add a new table to add multiple items for content
Table name - content_items
content_items belongs_to content
| Column_name | Type | Description |
|---|---|---|
| id | integer | primary key |
| content_id | integer | content id to which it belongs to |
| contentable_id | integer | contentable id to which it belongs to |
| contentable_type | string | contentable type to which it belongs to |
| published | boolean | true or false |
| published_from | datetime | date and time from which the item is active |
| created_at | date_time | created date |
| updated_at | date_time | updated date |
Add a new table to save content details to be viewed by enrolled users
Table name - user_contents
user_contents belongs_to enrollments
| Column_name | Type | Description |
|---|---|---|
| id | integer | primary key |
| content_id | integer | content id to which it belongs to |
| content_item_id | integer | conten_item id to which it belongs to |
