{"action":"created","comment":{"url":"https://api.github.com/repos/PavloConan/DobryGracz/pulls/comments/203991162","pull_request_review_id":138991942,"id":203991162,"node_id":"MDI0OlB1bGxSZXF1ZXN0UmV2aWV3Q29tbWVudDIwMzk5MTE2Mg==","diff_hunk":"@@ -0,0 +1,422 @@\n+module Admin\n+  module UsersStats\n+    class Report\n+      require 'spreadsheet'\n+\n+      def generate\n+        users_amount = Spreadsheet::Workbook.new\n+        format = Spreadsheet::Format.new :pattern_fg_color => :yellow, :pattern => 1\n+        sheet1 = users_amount.create_worksheet name: \"Liczba użytkowników\"\n+        sheet1.column(0).width = 50\n+        sheet1.column(1).width = 30\n+        sheet1[1,0] = \"Liczba zarejestrowanych użytkowników\"\n+        sheet1[1,1] = User.all.count\n+        sheet1[2,0] = \"Liczba wejść na stonę\"\n+        sheet1[2,1] = Ahoy::Visit.all.count\n+        sheet1[3,0] = \"Liczba odebranych nagród\"\n+        sheet1[3,1] = user_prize.count\n+        sheet1[3,3] = \"Liczba odebranych nagród z konkursów\"\n+        sheet1[3,4] = user_prize.where(contest_origin: true).count\n+        sheet1[3,5] = \"Liczba kupionych nagród\"\n+        sheet1[3,6] = user_prize.where(contest_origin: false).count\n+        sheet1[4,0] = \"Liczba zdobytych achievementów\"\n+        sheet1[4,1] = \"xxxxxxxxxxxxxxxxxxxx\"\n+        sheet1[5,0] = \"Liczba zdobytych punktów łącznie\"\n+        sheet1[5,1] = overall_points\n+        sheet1[6,0] = \"Liczba graczy League of Legends\"\n+        sheet1[6,1] = User.where.not(lol_summoner_name: nil).count\n+        sheet1[7,0] = \"Liczba graczy CS:GO\"\n+        sheet1[7,1] = User.where.not(steam_id: nil).count\n+        sheet1[8,0] = \"Liczba graczy grających w obie gry\"\n+        sheet1[8,1] = User.where.not(steam_id: nil, lol_summoner_name: nil).count\n+        sheet1[9,0] = \"Liczba kliknięć na promocję\"\n+        sheet1[9,1] = \"xxxxxxxxxxxxxx\"\n+        sheet1[10,0] = \"Łączna ilość zabójstw CS + LOL\"\n+        sheet1[10,1] = total_kills + kills\n+        sheet1[11,0] = \"Łączna ilość zgonów CS + LOL\"\n+        sheet1[11,1] = total_deaths + deaths\n+        sheet1[12,0] = \"Łączna liczba godzin grania z Dobrym Graczem\"\n+        sheet1[12,1] =\"xxxxxxxxxxxxxx\"\n+        sheet1[13,0] = \"Łączna liczba gier rozegranych z Dobrym Graczem\"","path":"app/services/admin/users_stats/report.rb","position":40,"original_position":40,"commit_id":"c7519254748e05134f12c589c719ff77aeb9460a","original_commit_id":"c7519254748e05134f12c589c719ff77aeb9460a","user":{"login":"marekls","id":26872375,"node_id":"MDQ6VXNlcjI2ODcyMzc1","avatar_url":"https://avatars1.githubusercontent.com/u/26872375?v=4","gravatar_id":"","url":"https://api.github.com/users/marekls","html_url":"https://github.com/marekls","followers_url":"https://api.github.com/users/marekls/followers","following_url":"https://api.github.com/users/marekls/following{/other_user}","gists_url":"https://api.github.com/users/marekls/gists{/gist_id}","starred_url":"https://api.github.com/users/marekls/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/marekls/subscriptions","organizations_url":"https://api.github.com/users/marekls/orgs","repos_url":"https://api.github.com/users/marekls/repos","events_url":"https://api.github.com/users/marekls/events{/privacy}","received_events_url":"https://api.github.com/users/marekls/received_events","type":"User","site_admin":false},"body":"liczba godzin tez ?","created_at":"2018-07-20T09:43:07Z","updated_at":"2018-07-20T09:43:07Z","html_url":"https://github.com/PavloConan/DobryGracz/pull/81#discussion_r203991162","pull_request_url":"https://api.github.com/repos/PavloConan/DobryGracz/pulls/81","author_association":"COLLABORATOR","_links":{"self":{"href":"https://api.github.com/repos/PavloConan/DobryGracz/pulls/comments/203991162"},"html":{"href":"https://github.com/PavloConan/DobryGracz/pull/81#discussion_r203991162"},"pull_request":{"href":"https://api.github.com/repos/PavloConan/DobryGracz/pulls/81"}},"in_reply_to_id":203804344},"pull_request":{"url":"https://api.github.com/repos/PavloConan/DobryGracz/pulls/81","id":201889017,"node_id":"MDExOlB1bGxSZXF1ZXN0MjAxODg5MDE3","html_url":"https://github.com/PavloConan/DobryGracz/pull/81","diff_url":"https://github.com/PavloConan/DobryGracz/pull/81.diff","patch_url":"https://github.com/PavloConan/DobryGracz/pull/81.patch","issue_url":"https://api.github.com/repos/PavloConan/DobryGracz/issues/81","number":81,"state":"open","locked":false,"title":"generator listy uzytkownikow","user":{"login":"marekls","id":26872375,"node_id":"MDQ6VXNlcjI2ODcyMzc1","avatar_url":"https://avatars1.githubusercontent.com/u/26872375?v=4","gravatar_id":"","url":"https://api.github.com/users/marekls","html_url":"https://github.com/marekls","followers_url":"https://api.github.com/users/marekls/followers","following_url":"https://api.github.com/users/marekls/following{/other_user}","gists_url":"https://api.github.com/users/marekls/gists{/gist_id}","starred_url":"https://api.github.com/users/marekls/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/marekls/subscriptions","organizations_url":"https://api.github.com/users/marekls/orgs","repos_url":"https://api.github.com/users/marekls/repos","events_url":"https://api.github.com/users/marekls/events{/privacy}","received_events_url":"https://api.github.com/users/marekls/received_events","type":"User","site_admin":false},"body":"https://www.pivotaltracker.com/story/show/157593223","created_at":"2018-07-17T10:06:38Z","updated_at":"2018-07-20T09:43:07Z","closed_at":null,"merged_at":null,"merge_commit_sha":"b9055895afcd14f74137d03ed178aff5223f6322","assignee":null,"assignees":[],"requested_reviewers":[],"requested_teams":[],"labels":[],"milestone":null,"commits_url":"https://api.github.com/repos/PavloConan/DobryGracz/pulls/81/commits","review_comments_url":"https://api.github.com/repos/PavloConan/DobryGracz/pulls/81/comments","review_comment_url":"https://api.github.com/repos/PavloConan/DobryGracz/pulls/comments{/number}","comments_url":"https://api.github.com/repos/PavloConan/DobryGracz/issues/81/comments","statuses_url":"https://api.github.com/repos/PavloConan/DobryGracz/statuses/c7519254748e05134f12c589c719ff77aeb9460a","head":{"label":"PavloConan:excel-users","ref":"excel-users","sha":"c7519254748e05134f12c589c719ff77aeb9460a","user":{"login":"PavloConan","id":14057325,"node_id":"MDQ6VXNlcjE0MDU3MzI1","avatar_url":"https://avatars1.githubusercontent.com/u/14057325?v=4","gravatar_id":"","url":"https://api.github.com/users/PavloConan","html_url":"https://github.com/PavloConan","followers_url":"https://api.github.com/users/PavloConan/followers","following_url":"https://api.github.com/users/PavloConan/following{/other_user}","gists_url":"https://api.github.com/users/PavloConan/gists{/gist_id}","starred_url":"https://api.github.com/users/PavloConan/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/PavloConan/subscriptions","organizations_url":"https://api.github.com/users/PavloConan/orgs","repos_url":"https://api.github.com/users/PavloConan/repos","events_url":"https://api.github.com/users/PavloConan/events{/privacy}","received_events_url":"https://api.github.com/users/PavloConan/received_events","type":"User","site_admin":false},"repo":{"id":136295355,"node_id":"MDEwOlJlcG9zaXRvcnkxMzYyOTUzNTU=","name":"DobryGracz","full_name":"PavloConan/DobryGracz","owner":{"login":"PavloConan","id":14057325,"node_id":"MDQ6VXNlcjE0MDU3MzI1","avatar_url":"https://avatars1.githubusercontent.com/u/14057325?v=4","gravatar_id":"","url":"https://api.github.com/users/PavloConan","html_url":"https://github.com/PavloConan","followers_url":"https://api.github.com/users/PavloConan/followers","following_url":"https://api.github.com/users/PavloConan/following{/other_user}","gists_url":"https://api.github.com/users/PavloConan/gists{/gist_id}","starred_url":"https://api.github.com/users/PavloConan/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/PavloConan/subscriptions","organizations_url":"https://api.github.com/users/PavloConan/orgs","repos_url":"https://api.github.com/users/PavloConan/repos","events_url":"https://api.github.com/users/PavloConan/events{/privacy}","received_events_url":"https://api.github.com/users/PavloConan/received_events","type":"User","site_admin":false},"private":false,"html_url":"https://github.com/PavloConan/DobryGracz","description":"temporary repo","fork":false,"url":"https://api.github.com/repos/PavloConan/DobryGracz","forks_url":"https://api.github.com/repos/PavloConan/DobryGracz/forks","keys_url":"https://api.github.com/repos/PavloConan/DobryGracz/keys{/key_id}","collaborators_url":"https://api.github.com/repos/PavloConan/DobryGracz/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/PavloConan/DobryGracz/teams","hooks_url":"https://api.github.com/repos/PavloConan/DobryGracz/hooks","issue_events_url":"https://api.github.com/repos/PavloConan/DobryGracz/issues/events{/number}","events_url":"https://api.github.com/repos/PavloConan/DobryGracz/events","assignees_url":"https://api.github.com/repos/PavloConan/DobryGracz/assignees{/user}","branches_url":"https://api.github.com/repos/PavloConan/DobryGracz/branches{/branch}","tags_url":"https://api.github.com/repos/PavloConan/DobryGracz/tags","blobs_url":"https://api.github.com/repos/PavloConan/DobryGracz/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/PavloConan/DobryGracz/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/PavloConan/DobryGracz/git/refs{/sha}","trees_url":"https://api.github.com/repos/PavloConan/DobryGracz/git/trees{/sha}","statuses_url":"https://api.github.com/repos/PavloConan/DobryGracz/statuses/{sha}","languages_url":"https://api.github.com/repos/PavloConan/DobryGracz/languages","stargazers_url":"https://api.github.com/repos/PavloConan/DobryGracz/stargazers","contributors_url":"https://api.github.com/repos/PavloConan/DobryGracz/contributors","subscribers_url":"https://api.github.com/repos/PavloConan/DobryGracz/subscribers","subscription_url":"https://api.github.com/repos/PavloConan/DobryGracz/subscription","commits_url":"https://api.github.com/repos/PavloConan/DobryGracz/commits{/sha}","git_commits_url":"https://api.github.com/repos/PavloConan/DobryGracz/git/commits{/sha}","comments_url":"https://api.github.com/repos/PavloConan/DobryGracz/comments{/number}","issue_comment_url":"https://api.github.com/repos/PavloConan/DobryGracz/issues/comments{/number}","contents_url":"https://api.github.com/repos/PavloConan/DobryGracz/contents/{+path}","compare_url":"https://api.github.com/repos/PavloConan/DobryGracz/compare/{base}...{head}","merges_url":"https://api.github.com/repos/PavloConan/DobryGracz/merges","archive_url":"https://api.github.com/repos/PavloConan/DobryGracz/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/PavloConan/DobryGracz/downloads","issues_url":"https://api.github.com/repos/PavloConan/DobryGracz/issues{/number}","pulls_url":"https://api.github.com/repos/PavloConan/DobryGracz/pulls{/number}","milestones_url":"https://api.github.com/repos/PavloConan/DobryGracz/milestones{/number}","notifications_url":"https://api.github.com/repos/PavloConan/DobryGracz/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/PavloConan/DobryGracz/labels{/name}","releases_url":"https://api.github.com/repos/PavloConan/DobryGracz/releases{/id}","deployments_url":"https://api.github.com/repos/PavloConan/DobryGracz/deployments","created_at":"2018-06-06T08:11:25Z","updated_at":"2018-07-19T17:33:40Z","pushed_at":"2018-07-19T17:33:38Z","git_url":"git://github.com/PavloConan/DobryGracz.git","ssh_url":"git@github.com:PavloConan/DobryGracz.git","clone_url":"https://github.com/PavloConan/DobryGracz.git","svn_url":"https://github.com/PavloConan/DobryGracz","homepage":null,"size":17811,"stargazers_count":1,"watchers_count":1,"language":"CSS","has_issues":true,"has_projects":true,"has_downloads":true,"has_wiki":true,"has_pages":false,"forks_count":0,"mirror_url":null,"archived":false,"open_issues_count":2,"license":null,"forks":0,"open_issues":2,"watchers":1,"default_branch":"master"}},"base":{"label":"PavloConan:master","ref":"master","sha":"7182669d46bb7faf573afca96220385df8637f7d","user":{"login":"PavloConan","id":14057325,"node_id":"MDQ6VXNlcjE0MDU3MzI1","avatar_url":"https://avatars1.githubusercontent.com/u/14057325?v=4","gravatar_id":"","url":"https://api.github.com/users/PavloConan","html_url":"https://github.com/PavloConan","followers_url":"https://api.github.com/users/PavloConan/followers","following_url":"https://api.github.com/users/PavloConan/following{/other_user}","gists_url":"https://api.github.com/users/PavloConan/gists{/gist_id}","starred_url":"https://api.github.com/users/PavloConan/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/PavloConan/subscriptions","organizations_url":"https://api.github.com/users/PavloConan/orgs","repos_url":"https://api.github.com/users/PavloConan/repos","events_url":"https://api.github.com/users/PavloConan/events{/privacy}","received_events_url":"https://api.github.com/users/PavloConan/received_events","type":"User","site_admin":false},"repo":{"id":136295355,"node_id":"MDEwOlJlcG9zaXRvcnkxMzYyOTUzNTU=","name":"DobryGracz","full_name":"PavloConan/DobryGracz","owner":{"login":"PavloConan","id":14057325,"node_id":"MDQ6VXNlcjE0MDU3MzI1","avatar_url":"https://avatars1.githubusercontent.com/u/14057325?v=4","gravatar_id":"","url":"https://api.github.com/users/PavloConan","html_url":"https://github.com/PavloConan","followers_url":"https://api.github.com/users/PavloConan/followers","following_url":"https://api.github.com/users/PavloConan/following{/other_user}","gists_url":"https://api.github.com/users/PavloConan/gists{/gist_id}","starred_url":"https://api.github.com/users/PavloConan/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/PavloConan/subscriptions","organizations_url":"https://api.github.com/users/PavloConan/orgs","repos_url":"https://api.github.com/users/PavloConan/repos","events_url":"https://api.github.com/users/PavloConan/events{/privacy}","received_events_url":"https://api.github.com/users/PavloConan/received_events","type":"User","site_admin":false},"private":false,"html_url":"https://github.com/PavloConan/DobryGracz","description":"temporary repo","fork":false,"url":"https://api.github.com/repos/PavloConan/DobryGracz","forks_url":"https://api.github.com/repos/PavloConan/DobryGracz/forks","keys_url":"https://api.github.com/repos/PavloConan/DobryGracz/keys{/key_id}","collaborators_url":"https://api.github.com/repos/PavloConan/DobryGracz/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/PavloConan/DobryGracz/teams","hooks_url":"https://api.github.com/repos/PavloConan/DobryGracz/hooks","issue_events_url":"https://api.github.com/repos/PavloConan/DobryGracz/issues/events{/number}","events_url":"https://api.github.com/repos/PavloConan/DobryGracz/events","assignees_url":"https://api.github.com/repos/PavloConan/DobryGracz/assignees{/user}","branches_url":"https://api.github.com/repos/PavloConan/DobryGracz/branches{/branch}","tags_url":"https://api.github.com/repos/PavloConan/DobryGracz/tags","blobs_url":"https://api.github.com/repos/PavloConan/DobryGracz/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/PavloConan/DobryGracz/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/PavloConan/DobryGracz/git/refs{/sha}","trees_url":"https://api.github.com/repos/PavloConan/DobryGracz/git/trees{/sha}","statuses_url":"https://api.github.com/repos/PavloConan/DobryGracz/statuses/{sha}","languages_url":"https://api.github.com/repos/PavloConan/DobryGracz/languages","stargazers_url":"https://api.github.com/repos/PavloConan/DobryGracz/stargazers","contributors_url":"https://api.github.com/repos/PavloConan/DobryGracz/contributors","subscribers_url":"https://api.github.com/repos/PavloConan/DobryGracz/subscribers","subscription_url":"https://api.github.com/repos/PavloConan/DobryGracz/subscription","commits_url":"https://api.github.com/repos/PavloConan/DobryGracz/commits{/sha}","git_commits_url":"https://api.github.com/repos/PavloConan/DobryGracz/git/commits{/sha}","comments_url":"https://api.github.com/repos/PavloConan/DobryGracz/comments{/number}","issue_comment_url":"https://api.github.com/repos/PavloConan/DobryGracz/issues/comments{/number}","contents_url":"https://api.github.com/repos/PavloConan/DobryGracz/contents/{+path}","compare_url":"https://api.github.com/repos/PavloConan/DobryGracz/compare/{base}...{head}","merges_url":"https://api.github.com/repos/PavloConan/DobryGracz/merges","archive_url":"https://api.github.com/repos/PavloConan/DobryGracz/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/PavloConan/DobryGracz/downloads","issues_url":"https://api.github.com/repos/PavloConan/DobryGracz/issues{/number}","pulls_url":"https://api.github.com/repos/PavloConan/DobryGracz/pulls{/number}","milestones_url":"https://api.github.com/repos/PavloConan/DobryGracz/milestones{/number}","notifications_url":"https://api.github.com/repos/PavloConan/DobryGracz/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/PavloConan/DobryGracz/labels{/name}","releases_url":"https://api.github.com/repos/PavloConan/DobryGracz/releases{/id}","deployments_url":"https://api.github.com/repos/PavloConan/DobryGracz/deployments","created_at":"2018-06-06T08:11:25Z","updated_at":"2018-07-19T17:33:40Z","pushed_at":"2018-07-19T17:33:38Z","git_url":"git://github.com/PavloConan/DobryGracz.git","ssh_url":"git@github.com:PavloConan/DobryGracz.git","clone_url":"https://github.com/PavloConan/DobryGracz.git","svn_url":"https://github.com/PavloConan/DobryGracz","homepage":null,"size":17811,"stargazers_count":1,"watchers_count":1,"language":"CSS","has_issues":true,"has_projects":true,"has_downloads":true,"has_wiki":true,"has_pages":false,"forks_count":0,"mirror_url":null,"archived":false,"open_issues_count":2,"license":null,"forks":0,"open_issues":2,"watchers":1,"default_branch":"master"}},"_links":{"self":{"href":"https://api.github.com/repos/PavloConan/DobryGracz/pulls/81"},"html":{"href":"https://github.com/PavloConan/DobryGracz/pull/81"},"issue":{"href":"https://api.github.com/repos/PavloConan/DobryGracz/issues/81"},"comments":{"href":"https://api.github.com/repos/PavloConan/DobryGracz/issues/81/comments"},"review_comments":{"href":"https://api.github.com/repos/PavloConan/DobryGracz/pulls/81/comments"},"review_comment":{"href":"https://api.github.com/repos/PavloConan/DobryGracz/pulls/comments{/number}"},"commits":{"href":"https://api.github.com/repos/PavloConan/DobryGracz/pulls/81/commits"},"statuses":{"href":"https://api.github.com/repos/PavloConan/DobryGracz/statuses/c7519254748e05134f12c589c719ff77aeb9460a"}},"author_association":"COLLABORATOR"}}
{"actor":{"display_login":"marekls"}}