{"action":"closed","issue":{"url":"https://api.github.com/repos/OpenFn/OpenFn-Site/issues/181","labels_url":"https://api.github.com/repos/OpenFn/OpenFn-Site/issues/181/labels{/name}","comments_url":"https://api.github.com/repos/OpenFn/OpenFn-Site/issues/181/comments","events_url":"https://api.github.com/repos/OpenFn/OpenFn-Site/issues/181/events","html_url":"https://github.com/OpenFn/OpenFn-Site/issues/181","id":65062905,"number":181,"title":"Allow logged in users to rate and review technologies","user":{"login":"taylordowns2000","id":8732845,"avatar_url":"https://avatars.githubusercontent.com/u/8732845?v=3","gravatar_id":"","url":"https://api.github.com/users/taylordowns2000","html_url":"https://github.com/taylordowns2000","followers_url":"https://api.github.com/users/taylordowns2000/followers","following_url":"https://api.github.com/users/taylordowns2000/following{/other_user}","gists_url":"https://api.github.com/users/taylordowns2000/gists{/gist_id}","starred_url":"https://api.github.com/users/taylordowns2000/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/taylordowns2000/subscriptions","organizations_url":"https://api.github.com/users/taylordowns2000/orgs","repos_url":"https://api.github.com/users/taylordowns2000/repos","events_url":"https://api.github.com/users/taylordowns2000/events{/privacy}","received_events_url":"https://api.github.com/users/taylordowns2000/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/OpenFn/OpenFn-Site/labels/3%20-%20Done","name":"3 - Done","color":"CCCCCC"},{"url":"https://api.github.com/repos/OpenFn/OpenFn-Site/labels/enhancement","name":"enhancement","color":"84b6eb"}],"state":"closed","locked":false,"assignee":null,"milestone":{"url":"https://api.github.com/repos/OpenFn/OpenFn-Site/milestones/3","html_url":"https://github.com/OpenFn/OpenFn-Site/milestones/v2%20(AppStore)","labels_url":"https://api.github.com/repos/OpenFn/OpenFn-Site/milestones/3/labels","id":1046324,"number":3,"title":"v2 (AppStore)","description":"This second version contains the big changes which bring the AppStore to the forefront, allowing users to buy/manage/pay for technologies, suggest new tech, read and write reviews, etc. The linkage between marketplace, integrations, and content is much stronger. They feel unified into a single product.","creator":{"login":"taylordowns2000","id":8732845,"avatar_url":"https://avatars.githubusercontent.com/u/8732845?v=3","gravatar_id":"","url":"https://api.github.com/users/taylordowns2000","html_url":"https://github.com/taylordowns2000","followers_url":"https://api.github.com/users/taylordowns2000/followers","following_url":"https://api.github.com/users/taylordowns2000/following{/other_user}","gists_url":"https://api.github.com/users/taylordowns2000/gists{/gist_id}","starred_url":"https://api.github.com/users/taylordowns2000/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/taylordowns2000/subscriptions","organizations_url":"https://api.github.com/users/taylordowns2000/orgs","repos_url":"https://api.github.com/users/taylordowns2000/repos","events_url":"https://api.github.com/users/taylordowns2000/events{/privacy}","received_events_url":"https://api.github.com/users/taylordowns2000/received_events","type":"User","site_admin":false},"open_issues":13,"closed_issues":1,"state":"open","created_at":"2015-03-31T06:12:43Z","updated_at":"2015-04-29T13:34:54Z","due_on":"2015-08-30T22:00:00Z","closed_at":null},"comments":0,"created_at":"2015-03-29T13:44:47Z","updated_at":"2015-04-29T13:34:54Z","closed_at":"2015-04-29T13:34:54Z","body":"- [ ] Review initial work on this branch: https://github.com/OpenFn/OpenFn-Site/commit/0a4b29cbcdb16794d08cdfa03eec0ca9a7ada3a4\r\n- [x] Create review table, linked to product (product, rating, review, user, date)\r\n- [ ] Create review modal that pops up when review button is clicked and allows user to submit a new review.\r\n- [ ] Create \"review_vote\" table which belongs to \"review\" and carries a +1 or -1 value.\r\n- [ ] Allow users to vote on reviews as either \"+1, this review is useful\" or \"-1, this review is not useful.\"\r\n- [ ] display list of reviews, with review scores (votes) on the \"reviews\" tab in the product listing.\r\n- [ ] Calculate product rating = (sum of (review rating * (IF(review_vote_score>=0, max(review_vote_score, 1), 0) / sum of (IF(review_vote_score>=0, max(review_vote_score, 1))\r\n- [ ] Display product rating\r\n\r\n<!---\r\n@huboard:{\"order\":112.5,\"milestone_order\":181.0,\"custom_state\":\"\"}\n-->\r\n"}}