{"action":"created","issue":{"url":"https://api.github.com/repos/rcarle3911/Hotel-Reservation-Project/issues/41","repository_url":"https://api.github.com/repos/rcarle3911/Hotel-Reservation-Project","labels_url":"https://api.github.com/repos/rcarle3911/Hotel-Reservation-Project/issues/41/labels{/name}","comments_url":"https://api.github.com/repos/rcarle3911/Hotel-Reservation-Project/issues/41/comments","events_url":"https://api.github.com/repos/rcarle3911/Hotel-Reservation-Project/issues/41/events","html_url":"https://github.com/rcarle3911/Hotel-Reservation-Project/issues/41","id":190899556,"number":41,"title":"Create History Table","user":{"login":"Fish5802","id":21179203,"avatar_url":"https://avatars.githubusercontent.com/u/21179203?v=3","gravatar_id":"","url":"https://api.github.com/users/Fish5802","html_url":"https://github.com/Fish5802","followers_url":"https://api.github.com/users/Fish5802/followers","following_url":"https://api.github.com/users/Fish5802/following{/other_user}","gists_url":"https://api.github.com/users/Fish5802/gists{/gist_id}","starred_url":"https://api.github.com/users/Fish5802/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Fish5802/subscriptions","organizations_url":"https://api.github.com/users/Fish5802/orgs","repos_url":"https://api.github.com/users/Fish5802/repos","events_url":"https://api.github.com/users/Fish5802/events{/privacy}","received_events_url":"https://api.github.com/users/Fish5802/received_events","type":"User","site_admin":false},"labels":[{"id":485495386,"url":"https://api.github.com/repos/rcarle3911/Hotel-Reservation-Project/labels/Back%20End","name":"Back End","color":"1d76db","default":false},{"id":472415260,"url":"https://api.github.com/repos/rcarle3911/Hotel-Reservation-Project/labels/enhancement","name":"enhancement","color":"84b6eb","default":true},{"id":485330156,"url":"https://api.github.com/repos/rcarle3911/Hotel-Reservation-Project/labels/Week%206%20Sprint","name":"Week 6 Sprint","color":"c2e0c6","default":false}],"state":"open","locked":false,"assignee":{"login":"rcarle3911","id":5898415,"avatar_url":"https://avatars.githubusercontent.com/u/5898415?v=3","gravatar_id":"","url":"https://api.github.com/users/rcarle3911","html_url":"https://github.com/rcarle3911","followers_url":"https://api.github.com/users/rcarle3911/followers","following_url":"https://api.github.com/users/rcarle3911/following{/other_user}","gists_url":"https://api.github.com/users/rcarle3911/gists{/gist_id}","starred_url":"https://api.github.com/users/rcarle3911/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/rcarle3911/subscriptions","organizations_url":"https://api.github.com/users/rcarle3911/orgs","repos_url":"https://api.github.com/users/rcarle3911/repos","events_url":"https://api.github.com/users/rcarle3911/events{/privacy}","received_events_url":"https://api.github.com/users/rcarle3911/received_events","type":"User","site_admin":false},"assignees":[{"login":"rcarle3911","id":5898415,"avatar_url":"https://avatars.githubusercontent.com/u/5898415?v=3","gravatar_id":"","url":"https://api.github.com/users/rcarle3911","html_url":"https://github.com/rcarle3911","followers_url":"https://api.github.com/users/rcarle3911/followers","following_url":"https://api.github.com/users/rcarle3911/following{/other_user}","gists_url":"https://api.github.com/users/rcarle3911/gists{/gist_id}","starred_url":"https://api.github.com/users/rcarle3911/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/rcarle3911/subscriptions","organizations_url":"https://api.github.com/users/rcarle3911/orgs","repos_url":"https://api.github.com/users/rcarle3911/repos","events_url":"https://api.github.com/users/rcarle3911/events{/privacy}","received_events_url":"https://api.github.com/users/rcarle3911/received_events","type":"User","site_admin":false},{"login":"dsteele0301","id":18315829,"avatar_url":"https://avatars.githubusercontent.com/u/18315829?v=3","gravatar_id":"","url":"https://api.github.com/users/dsteele0301","html_url":"https://github.com/dsteele0301","followers_url":"https://api.github.com/users/dsteele0301/followers","following_url":"https://api.github.com/users/dsteele0301/following{/other_user}","gists_url":"https://api.github.com/users/dsteele0301/gists{/gist_id}","starred_url":"https://api.github.com/users/dsteele0301/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/dsteele0301/subscriptions","organizations_url":"https://api.github.com/users/dsteele0301/orgs","repos_url":"https://api.github.com/users/dsteele0301/repos","events_url":"https://api.github.com/users/dsteele0301/events{/privacy}","received_events_url":"https://api.github.com/users/dsteele0301/received_events","type":"User","site_admin":false}],"milestone":{"url":"https://api.github.com/repos/rcarle3911/Hotel-Reservation-Project/milestones/14","html_url":"https://github.com/rcarle3911/Hotel-Reservation-Project/milestones/Database%20Functions","labels_url":"https://api.github.com/repos/rcarle3911/Hotel-Reservation-Project/milestones/14/labels","id":2152435,"number":14,"title":"Database Functions","description":"Create functions to interact with user, reservation, and room databases.","creator":{"login":"rcarle3911","id":5898415,"avatar_url":"https://avatars.githubusercontent.com/u/5898415?v=3","gravatar_id":"","url":"https://api.github.com/users/rcarle3911","html_url":"https://github.com/rcarle3911","followers_url":"https://api.github.com/users/rcarle3911/followers","following_url":"https://api.github.com/users/rcarle3911/following{/other_user}","gists_url":"https://api.github.com/users/rcarle3911/gists{/gist_id}","starred_url":"https://api.github.com/users/rcarle3911/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/rcarle3911/subscriptions","organizations_url":"https://api.github.com/users/rcarle3911/orgs","repos_url":"https://api.github.com/users/rcarle3911/repos","events_url":"https://api.github.com/users/rcarle3911/events{/privacy}","received_events_url":"https://api.github.com/users/rcarle3911/received_events","type":"User","site_admin":false},"open_issues":3,"closed_issues":1,"state":"open","created_at":"2016-11-22T20:17:45Z","updated_at":"2016-11-24T23:32:09Z","due_on":"2016-11-27T00:00:00Z","closed_at":null},"comments":4,"created_at":"2016-11-22T03:37:50Z","updated_at":"2016-11-25T17:37:36Z","closed_at":null,"body":"Create a history table that will be used to show what the user, employees, and manager have done on the site. \r\n\r\n|Who|What|Why|When|Where|\r\n|---|---|---|---|---|\r\n|User1|Created Reservation|null|dd/mmm/yyyy|/app/resrevation|\r\n|Emp1|Check-In|Checked in User1 to Room 212|dd/mmm/yyyy|/emp/checkin.html|\r\n|Mgr1|Deleted Reservation|User1 Reservation for 10/Jun/2016 was deleted|dd/mmm/yyyy|/emp/mangaer.html|\r\n|Emp1|Note|Noise Complaint by RM 101 on RM 201 blah blah blah|dd/mmm/yyyy|/History.html|\r\n\r\n\r\nWe can discuss this in more detail if necessary. Names don't have to be the 5 W's that's just the first thing that came to mind. "},"comment":{"url":"https://api.github.com/repos/rcarle3911/Hotel-Reservation-Project/issues/comments/263002998","html_url":"https://github.com/rcarle3911/Hotel-Reservation-Project/issues/41#issuecomment-263002998","issue_url":"https://api.github.com/repos/rcarle3911/Hotel-Reservation-Project/issues/41","id":263002998,"user":{"login":"Fish5802","id":21179203,"avatar_url":"https://avatars.githubusercontent.com/u/21179203?v=3","gravatar_id":"","url":"https://api.github.com/users/Fish5802","html_url":"https://github.com/Fish5802","followers_url":"https://api.github.com/users/Fish5802/followers","following_url":"https://api.github.com/users/Fish5802/following{/other_user}","gists_url":"https://api.github.com/users/Fish5802/gists{/gist_id}","starred_url":"https://api.github.com/users/Fish5802/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Fish5802/subscriptions","organizations_url":"https://api.github.com/users/Fish5802/orgs","repos_url":"https://api.github.com/users/Fish5802/repos","events_url":"https://api.github.com/users/Fish5802/events{/privacy}","received_events_url":"https://api.github.com/users/Fish5802/received_events","type":"User","site_admin":false},"created_at":"2016-11-25T17:37:36Z","updated_at":"2016-11-25T17:37:36Z","body":"We are talking about two different things at this point. You are talking about an Audit log... Which we should implement but way way down the line if we have time. \r\n\r\nI am talking about a history table that when you go to the Check-in / Check-out Tabs in the employee interface it will show events based on the customer. \r\n\r\nAlso if the manager looks up a customer account it will show the events for the customer. \r\n\r\nIf we elect to build a room interface (add, edit) then it would show a history of the room. \r\n\r\nThis would track when a customer makes a reservation, Checks in, Checks out, or has a complaint. \r\n\r\nThis information would mainly be per stored per user in the databases. My who what where why example above was not specific enough so here is what I am thinking. \r\n\r\n\r\n|Date|Action|Note|User|Room|CreatedBy|\r\n|---|---|---|---|---|---|\r\n|mmddyy HH:MM:SS|Reservation|Online Reservation made for two nights (12-2-16 to 12-4-16)|HotelGuestName|Null|OnlineReservation|\r\n|mmddyy HH:MM:SS|Reservation|Phone Reservation made for two nights (12-2-16 to 12-4-16)|HotelGuestName2|Null|EmployeeName|\r\n|mmddyy HH:MM:SS|Checkin|Guest Checkin for two nights (12-2-16 to 12-4-16)|HotelGuestName|204|EmployeeName|\r\n|mmddyy HH:MM:SS|Note|Guest Requested More Towels|HotelGuestName|204|EmployeeName|\r\n|mmddyy HH:MM:SS|Note|Guest Requested Late Checkout|HotelGuestName|204|EmployeeName|\r\n|mmddyy HH:MM:SS|MaintIssue|Report of broken lamp|HotelGuestName|204|EmployeeName|\r\n|mmddyy HH:MM:SS|Checkout|Guest checkout on 12-4-16:1300|HotelGuestName|204|EmployeeName|\r\n\r\nThis will allow us to pull a history of the guest or a history of the room quickly and easily without having to parse through other audit data. \r\n\r\n\r\n\r\n"}}
{"actor":{"display_login":"Fish5802"}}