Node.js updated App

Homework

Goal

To learn how to use node.js to build an app

Method

Choose one of the two following options:

Option 1 – Modify the PhoneNodeREST app to make a new “Task” app.

1. Create a new database table with the following fields:
   a. Task (String)
   b. Due Date (this is a MySQL data type)
   c. Task Status (enum=”completed”,”in process”,”onhold”,”notstarted”)
   d. Comment (String)
2. Modify the Phone app to use this database
   – Use a date picker to choose the date: bootstrap datepicker
   – Use a pull down for the Task Status
   – Allow search by Task (any substring), Date, and Status
   – Allow the adding of new tasks
   – Allow the editing and deletion of tasks
   – Add a “list all” option that lists all tasks in date order
   – Add a “list to do” option that need to be done in the future, in date order. (How to get current time)
   – Add a “overdue” option that list, in date order, tasks that are overdue.
   – Note – thee last three options will ignore the search field.
   

Option 2 – Modify socketChat to save all chat messages in MySQL database

1. Create a MySQL table the following fields
   – A date/time stamp (this is a MySQL DATETIME type. Documentation. How to get current date and time)
   – The senders name (string)
   – the message (string)
2. Modify the socketApp to stored all message in the database table.
3. Add a button to the app web page to bring in the entire history into the chat window, in order.
4. Add a search field and button to only show certain users. The input field is a comma delimited list of names.

Turn in

Set up your program to run in the background, and turn in the web link and the file path.