{"action":"created","issue":{"url":"https://api.github.com/repos/zebraf1/Kassa/issues/13","labels_url":"https://api.github.com/repos/zebraf1/Kassa/issues/13/labels{/name}","comments_url":"https://api.github.com/repos/zebraf1/Kassa/issues/13/comments","events_url":"https://api.github.com/repos/zebraf1/Kassa/issues/13/events","html_url":"https://github.com/zebraf1/Kassa/issues/13","id":94590071,"number":13,"title":"Display responsible user (valves olija) for the current day","user":{"login":"zebraf1","id":1769654,"avatar_url":"https://avatars.githubusercontent.com/u/1769654?v=3","gravatar_id":"","url":"https://api.github.com/users/zebraf1","html_url":"https://github.com/zebraf1","followers_url":"https://api.github.com/users/zebraf1/followers","following_url":"https://api.github.com/users/zebraf1/following{/other_user}","gists_url":"https://api.github.com/users/zebraf1/gists{/gist_id}","starred_url":"https://api.github.com/users/zebraf1/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/zebraf1/subscriptions","organizations_url":"https://api.github.com/users/zebraf1/orgs","repos_url":"https://api.github.com/users/zebraf1/repos","events_url":"https://api.github.com/users/zebraf1/events{/privacy}","received_events_url":"https://api.github.com/users/zebraf1/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/zebraf1/Kassa/labels/enhancement","name":"enhancement","color":"84b6eb"},{"url":"https://api.github.com/repos/zebraf1/Kassa/labels/help%20wanted","name":"help wanted","color":"159818"}],"state":"open","locked":false,"assignee":{"login":"zebraf1","id":1769654,"avatar_url":"https://avatars.githubusercontent.com/u/1769654?v=3","gravatar_id":"","url":"https://api.github.com/users/zebraf1","html_url":"https://github.com/zebraf1","followers_url":"https://api.github.com/users/zebraf1/followers","following_url":"https://api.github.com/users/zebraf1/following{/other_user}","gists_url":"https://api.github.com/users/zebraf1/gists{/gist_id}","starred_url":"https://api.github.com/users/zebraf1/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/zebraf1/subscriptions","organizations_url":"https://api.github.com/users/zebraf1/orgs","repos_url":"https://api.github.com/users/zebraf1/repos","events_url":"https://api.github.com/users/zebraf1/events{/privacy}","received_events_url":"https://api.github.com/users/zebraf1/received_events","type":"User","site_admin":false},"milestone":{"url":"https://api.github.com/repos/zebraf1/Kassa/milestones/4","html_url":"https://github.com/zebraf1/Kassa/milestones/Sprint4","labels_url":"https://api.github.com/repos/zebraf1/Kassa/milestones/4/labels","id":1320900,"number":4,"title":"Sprint4","description":"October","creator":{"login":"zebraf1","id":1769654,"avatar_url":"https://avatars.githubusercontent.com/u/1769654?v=3","gravatar_id":"","url":"https://api.github.com/users/zebraf1","html_url":"https://github.com/zebraf1","followers_url":"https://api.github.com/users/zebraf1/followers","following_url":"https://api.github.com/users/zebraf1/following{/other_user}","gists_url":"https://api.github.com/users/zebraf1/gists{/gist_id}","starred_url":"https://api.github.com/users/zebraf1/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/zebraf1/subscriptions","organizations_url":"https://api.github.com/users/zebraf1/orgs","repos_url":"https://api.github.com/users/zebraf1/repos","events_url":"https://api.github.com/users/zebraf1/events{/privacy}","received_events_url":"https://api.github.com/users/zebraf1/received_events","type":"User","site_admin":false},"open_issues":5,"closed_issues":3,"state":"open","created_at":"2015-09-23T18:20:57Z","updated_at":"2015-10-05T20:40:24Z","due_on":"2015-10-30T22:00:00Z","closed_at":null},"comments":1,"created_at":"2015-07-12T18:40:17Z","updated_at":"2015-10-21T18:47:20Z","closed_at":null,"body":"In addition, the valvete table should display whether or not the user has filled in his report (requires new task for Hannes K)"},"comment":{"url":"https://api.github.com/repos/zebraf1/Kassa/issues/comments/149990628","html_url":"https://github.com/zebraf1/Kassa/issues/13#issuecomment-149990628","issue_url":"https://api.github.com/repos/zebraf1/Kassa/issues/13","id":149990628,"user":{"login":"zebraf1","id":1769654,"avatar_url":"https://avatars.githubusercontent.com/u/1769654?v=3","gravatar_id":"","url":"https://api.github.com/users/zebraf1","html_url":"https://github.com/zebraf1","followers_url":"https://api.github.com/users/zebraf1/followers","following_url":"https://api.github.com/users/zebraf1/following{/other_user}","gists_url":"https://api.github.com/users/zebraf1/gists{/gist_id}","starred_url":"https://api.github.com/users/zebraf1/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/zebraf1/subscriptions","organizations_url":"https://api.github.com/users/zebraf1/orgs","repos_url":"https://api.github.com/users/zebraf1/repos","events_url":"https://api.github.com/users/zebraf1/events{/privacy}","received_events_url":"https://api.github.com/users/zebraf1/received_events","type":"User","site_admin":false},"created_at":"2015-10-21T18:47:20Z","updated_at":"2015-10-21T18:47:20Z","body":"Sql to fetch members who filled in reports for the given cycle:\r\n```sql\r\nSELECT member_id, DATE(created_at) \r\nFROM ollekassa_report \r\n  JOIN valve_tsyklid ON valve_tsyklid.id = :valveTsykliId\r\nWHERE \r\n  DATE(created_at) BETWEEN valve_tsyklid.algaeg AND valve_tsyklid.loppaeg\r\n  AND ollekassa_report.type = 'VERIFICATION'\r\nORDER BY created_at DESC;\r\n```"}}