{"action":"created","comment":{"url":"https://api.github.com/repos/edx/edx-platform/pulls/comments/32443149","id":32443149,"diff_hunk":"@@ -0,0 +1,135 @@\n+<%! from django.utils.translation import ugettext as _ %>\n+<!DOCTYPE HTML>\n+<html>\n+<head>\n+<meta http-equiv=\"Content-Type\" content=\"text/html; charset=utf-8\">\n+<title>Edx Executive Summary</title>\n+<style type=\"text/css\">\n+body {\n+\tfont-family: Arial, Helvetica, sans-serif;\n+\tfont-size:14px;\n+\tline-height:22px;\n+\tmargin: 10px;\n+}\n+.box-bg {\n+\tbackground:#f1f1f1;\n+\tpadding:10px;\n+}\n+th {\n+\tpadding:5px;\n+\tbackground:#ccc;\n+}\n+h2 {\n+\tmargin-top:0\n+}\n+</style>\n+</head>\n+\n+<body>\n+<table width=\"650\" border=\"0\" cellspacing=\"5\" cellpadding=\"5\">\n+\t<tr>\n+\t\t<td align=\"left\" valign=\"top\" class=\"box-bg\"><h2>${_(\"Executive Summary for {display_name}\".format(display_name=display_name))}</h2>\n+\t\t\t<table width=\"100%\">\n+\n+\t\t\t\t<tr>\n+\t\t\t\t\t<td width=\"300\">${_(\"Course Start Date:\")}</td>\n+\t\t\t\t\t<td align=\"right\"> ${start_date}</td>\n+\t\t\t\t</tr>\n+\t\t\t\t<tr>\n+\t\t\t\t\t<td width=\"300\">${_(\"Course End Date:\")}</td>\n+\t\t\t\t\t<td align=\"right\"> ${end_date}</td>\n+\t\t\t\t</tr>\n+\t\t\t\t<tr>\n+\t\t\t\t\t<td width=\"300\">${_(\"Report Generation Date:\")}</td>\n+\t\t\t\t\t<td align=\"right\"> ${report_generation_date}</td>\n+\t\t\t  </tr>\n+\t\t\t\t<tr>\n+\t\t\t\t\t<td width=\"300\">${_(\"Total Seats:\")}</td>\n+\t\t\t\t\t<td align=\"right\">${total_seats}</td>\n+\t\t\t\t</tr>\n+\t\t\t\t<tr>\n+\t\t\t\t\t<td width=\"300\">${_(\"Total Enrollments:\")}</td>\n+\t\t\t\t\t<td align=\"right\">${total_enrollments}</td>\n+\t\t\t\t</tr>\n+\t\t\t\t<tr>\n+\t\t\t\t\t<td>${_(\"Gross Revenue Collected to date:\")}</td>\n+\t\t\t\t\t<td align=\"right\">${currency}${\"{0:0.2f}\".format(gross_revenue)}</td>\n+\t\t\t\t</tr>\n+\t\t\t\t<tr>\n+\t\t\t\t\t<td>${_(\"Gross Pending Revenue:\")}</td>\n+\t\t\t\t\t<td align=\"right\">${currency}${\"{0:0.2f}\".format(gross_pending_revenue)}</td>\n+\t\t\t\t</tr>\n+\t\t\t\t<tr>\n+\t\t\t\t\t<td>${_(\"Total Enrollments Refunded:\")}</td>\n+\t\t\t\t\t<td align=\"right\">${total_seats_refunded}</td>\n+\t\t\t\t</tr>\n+\t\t\t\t<tr>\n+\t\t\t\t\t<td>${_(\"Total Amount Refunded:\")}</td>\n+\t\t\t\t\t<td align=\"right\">${currency}${\"{0:0.2f}\".format(total_amount_refunded)}</td>\n+\t\t\t\t</tr>\n+\t\t\t\t<tr>\n+\t\t\t\t\t<td>${_(\"Average price paid:\")}</td>\n+\t\t\t\t\t<td align=\"right\">${currency}${\"{0:0.2f}\".format(average_paid_price)}</td>\n+\t\t\t\t</tr>\n+\t\t\t</table></td>\n+\t</tr>\n+\t<tr>\n+\t\t<td align=\"left\" valign=\"top\" class=\"box-bg\"><h3>${_(\"Top Discount Codes used:\")}</h3>\n+\t\t\t<table width=\"500\">\n+\t\t\t\t<tr>\n+\t\t\t\t\t<td>${_(\"Total seats bough using discount codes:\")}</td>\n+\t\t\t\t\t<td>${total_seats_using_discount_codes['coupon__count']}</td>\n+\t\t\t\t</tr>\n+\t\t\t</table>\n+\t\t\t<table width=\"100%\">\n+\n+\t\t\t\t\t<th>${_(\"Rank\")}</th>\n+\t\t\t\t\t<th>${_(\"Discount Code\")}</th>\n+\t\t\t\t\t<th>${_(\"Discount %\")}</th>\n+\t\t\t\t\t<th>${_(\"Times used\")}</th>\n+        %for i, discount_code_data in enumerate(discount_codes_data):\n+\t\t\t\t<tr>\n+\t\t\t\t\t<td align=\"center\">${i+1}</td>\n+\t\t\t\t\t<td align=\"center\">${discount_code_data['coupon__code']}</td>\n+\t\t\t\t\t<td align=\"center\">${discount_code_data['coupon__percentage_discount']}</td>\n+\t\t\t\t\t<td align=\"center\">${discount_code_data['coupon__used_count']}</td>\n+\t\t\t\t</tr>\n+        %endfor\n+\t\t\t</table></td>\n+\t</tr>\n+\t<tr>\n+\t\t<td align=\"left\" valign=\"top\" class=\"box-bg\"><h3>${_(\"Bulk vs Single Self Purchases\")}</h3>\n+\t\t\t<table width=\"100%\">\n+\t\t\t\t<tr>\n+\t\t\t\t\t<td>${_(\"Total seats bought via single seat purchase:\")}</td>\n+\t\t\t\t\t<td align=\"right\">${total_self_purchase_seats}</td>\n+\t\t\t\t</tr>\n+\t\t\t\t<tr>\n+\t\t\t\t\t<td>${_(\"Total seats bought via bulk purchase:\")}</td>\n+\t\t\t\t\t<td align=\"right\">${total_bulk_purchase_seats}</td>\n+\t\t\t\t</tr>\n+\t\t\t\t<tr>\n+\t\t\t\t\t<td>${_(\"Total seats bought via invoice:\")}</td>\n+\t\t\t\t\t<td align=\"right\">${total_invoiced_seats}</td>\n+\t\t\t\t</tr>\n+\t\t\t\t<tr>\n+\t\t\t\t\t<td>${_(\"Total unused bulk purchase seats (revenue at risk):\")}</td>\n+\t\t\t\t\t<td align=\"right\">${unused_bulk_purchase_code_count}</td>\n+\t\t\t\t</tr>\n+\t\t\t\t<tr>\n+\t\t\t\t\t<td>${_(\"Percentage of total seats bought via single seat purchase:\")}</td>\n+\t\t\t\t\t<td align=\"right\">${\"{0:0.2f}\".format(self_purchases_percentage)}%</td>\n+\t\t\t\t</tr>\n+\t\t\t\t<tr>\n+\t\t\t\t\t<td>${_(\"Percentage of total seats via bulk purchase:\")}</td>\n+\t\t\t\t\t<td align=\"right\">${\"{0:0.2f}\".format(bulk_purchases_percentage)}%</td>\n+\t\t\t\t</tr>\n+\t\t\t\t<tr>\n+\t\t\t\t\t<td>${_(\"Percentage of total seats via invoice:\")}</td>","path":"lms/templates/instructor/instructor_dashboard_2/executive_summary.html","position":128,"original_position":128,"commit_id":"cce8b0b4417168db9af7228817d8852ed282bc62","original_commit_id":"cce8b0b4417168db9af7228817d8852ed282bc62","user":{"login":"srpearce","id":3493253,"avatar_url":"https://avatars.githubusercontent.com/u/3493253?v=3","gravatar_id":"","url":"https://api.github.com/users/srpearce","html_url":"https://github.com/srpearce","followers_url":"https://api.github.com/users/srpearce/followers","following_url":"https://api.github.com/users/srpearce/following{/other_user}","gists_url":"https://api.github.com/users/srpearce/gists{/gist_id}","starred_url":"https://api.github.com/users/srpearce/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/srpearce/subscriptions","organizations_url":"https://api.github.com/users/srpearce/orgs","repos_url":"https://api.github.com/users/srpearce/repos","events_url":"https://api.github.com/users/srpearce/events{/privacy}","received_events_url":"https://api.github.com/users/srpearce/received_events","type":"User","site_admin":false},"body":"Percentage of seats purchased with invoices","created_at":"2015-06-15T17:12:11Z","updated_at":"2015-06-15T17:12:11Z","html_url":"https://github.com/edx/edx-platform/pull/8206#discussion_r32443149","pull_request_url":"https://api.github.com/repos/edx/edx-platform/pulls/8206","_links":{"self":{"href":"https://api.github.com/repos/edx/edx-platform/pulls/comments/32443149"},"html":{"href":"https://github.com/edx/edx-platform/pull/8206#discussion_r32443149"},"pull_request":{"href":"https://api.github.com/repos/edx/edx-platform/pulls/8206"}}},"pull_request":{"url":"https://api.github.com/repos/edx/edx-platform/pulls/8206","id":36303658,"html_url":"https://github.com/edx/edx-platform/pull/8206","diff_url":"https://github.com/edx/edx-platform/pull/8206.diff","patch_url":"https://github.com/edx/edx-platform/pull/8206.patch","issue_url":"https://api.github.com/repos/edx/edx-platform/issues/8206","number":8206,"state":"open","locked":false,"title":"SOL-795 Executive Summary Report","user":{"login":"afzaledx","id":9654006,"avatar_url":"https://avatars.githubusercontent.com/u/9654006?v=3","gravatar_id":"","url":"https://api.github.com/users/afzaledx","html_url":"https://github.com/afzaledx","followers_url":"https://api.github.com/users/afzaledx/followers","following_url":"https://api.github.com/users/afzaledx/following{/other_user}","gists_url":"https://api.github.com/users/afzaledx/gists{/gist_id}","starred_url":"https://api.github.com/users/afzaledx/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/afzaledx/subscriptions","organizations_url":"https://api.github.com/users/afzaledx/orgs","repos_url":"https://api.github.com/users/afzaledx/repos","events_url":"https://api.github.com/users/afzaledx/events{/privacy}","received_events_url":"https://api.github.com/users/afzaledx/received_events","type":"User","site_admin":false},"body":"","created_at":"2015-05-27T13:32:22Z","updated_at":"2015-06-15T17:12:11Z","closed_at":null,"merged_at":null,"merge_commit_sha":"bdcfc737d36d78b1b838a6578917b48927b17870","assignee":null,"milestone":null,"commits_url":"https://api.github.com/repos/edx/edx-platform/pulls/8206/commits","review_comments_url":"https://api.github.com/repos/edx/edx-platform/pulls/8206/comments","review_comment_url":"https://api.github.com/repos/edx/edx-platform/pulls/comments{/number}","comments_url":"https://api.github.com/repos/edx/edx-platform/issues/8206/comments","statuses_url":"https://api.github.com/repos/edx/edx-platform/statuses/cce8b0b4417168db9af7228817d8852ed282bc62","head":{"label":"edx:afzaledx/sol-795-executive-summary-report","ref":"afzaledx/sol-795-executive-summary-report","sha":"cce8b0b4417168db9af7228817d8852ed282bc62","user":{"login":"edx","id":3179841,"avatar_url":"https://avatars.githubusercontent.com/u/3179841?v=3","gravatar_id":"","url":"https://api.github.com/users/edx","html_url":"https://github.com/edx","followers_url":"https://api.github.com/users/edx/followers","following_url":"https://api.github.com/users/edx/following{/other_user}","gists_url":"https://api.github.com/users/edx/gists{/gist_id}","starred_url":"https://api.github.com/users/edx/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/edx/subscriptions","organizations_url":"https://api.github.com/users/edx/orgs","repos_url":"https://api.github.com/users/edx/repos","events_url":"https://api.github.com/users/edx/events{/privacy}","received_events_url":"https://api.github.com/users/edx/received_events","type":"Organization","site_admin":false},"repo":{"id":10391073,"name":"edx-platform","full_name":"edx/edx-platform","owner":{"login":"edx","id":3179841,"avatar_url":"https://avatars.githubusercontent.com/u/3179841?v=3","gravatar_id":"","url":"https://api.github.com/users/edx","html_url":"https://github.com/edx","followers_url":"https://api.github.com/users/edx/followers","following_url":"https://api.github.com/users/edx/following{/other_user}","gists_url":"https://api.github.com/users/edx/gists{/gist_id}","starred_url":"https://api.github.com/users/edx/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/edx/subscriptions","organizations_url":"https://api.github.com/users/edx/orgs","repos_url":"https://api.github.com/users/edx/repos","events_url":"https://api.github.com/users/edx/events{/privacy}","received_events_url":"https://api.github.com/users/edx/received_events","type":"Organization","site_admin":false},"private":false,"html_url":"https://github.com/edx/edx-platform","description":"The Open edX platform, the software that powers edX!","fork":false,"url":"https://api.github.com/repos/edx/edx-platform","forks_url":"https://api.github.com/repos/edx/edx-platform/forks","keys_url":"https://api.github.com/repos/edx/edx-platform/keys{/key_id}","collaborators_url":"https://api.github.com/repos/edx/edx-platform/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/edx/edx-platform/teams","hooks_url":"https://api.github.com/repos/edx/edx-platform/hooks","issue_events_url":"https://api.github.com/repos/edx/edx-platform/issues/events{/number}","events_url":"https://api.github.com/repos/edx/edx-platform/events","assignees_url":"https://api.github.com/repos/edx/edx-platform/assignees{/user}","branches_url":"https://api.github.com/repos/edx/edx-platform/branches{/branch}","tags_url":"https://api.github.com/repos/edx/edx-platform/tags","blobs_url":"https://api.github.com/repos/edx/edx-platform/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/edx/edx-platform/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/edx/edx-platform/git/refs{/sha}","trees_url":"https://api.github.com/repos/edx/edx-platform/git/trees{/sha}","statuses_url":"https://api.github.com/repos/edx/edx-platform/statuses/{sha}","languages_url":"https://api.github.com/repos/edx/edx-platform/languages","stargazers_url":"https://api.github.com/repos/edx/edx-platform/stargazers","contributors_url":"https://api.github.com/repos/edx/edx-platform/contributors","subscribers_url":"https://api.github.com/repos/edx/edx-platform/subscribers","subscription_url":"https://api.github.com/repos/edx/edx-platform/subscription","commits_url":"https://api.github.com/repos/edx/edx-platform/commits{/sha}","git_commits_url":"https://api.github.com/repos/edx/edx-platform/git/commits{/sha}","comments_url":"https://api.github.com/repos/edx/edx-platform/comments{/number}","issue_comment_url":"https://api.github.com/repos/edx/edx-platform/issues/comments{/number}","contents_url":"https://api.github.com/repos/edx/edx-platform/contents/{+path}","compare_url":"https://api.github.com/repos/edx/edx-platform/compare/{base}...{head}","merges_url":"https://api.github.com/repos/edx/edx-platform/merges","archive_url":"https://api.github.com/repos/edx/edx-platform/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/edx/edx-platform/downloads","issues_url":"https://api.github.com/repos/edx/edx-platform/issues{/number}","pulls_url":"https://api.github.com/repos/edx/edx-platform/pulls{/number}","milestones_url":"https://api.github.com/repos/edx/edx-platform/milestones{/number}","notifications_url":"https://api.github.com/repos/edx/edx-platform/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/edx/edx-platform/labels{/name}","releases_url":"https://api.github.com/repos/edx/edx-platform/releases{/id}","created_at":"2013-05-30T20:20:38Z","updated_at":"2015-06-15T17:02:48Z","pushed_at":"2015-06-15T16:22:50Z","git_url":"git://github.com/edx/edx-platform.git","ssh_url":"git@github.com:edx/edx-platform.git","clone_url":"https://github.com/edx/edx-platform.git","svn_url":"https://github.com/edx/edx-platform","homepage":"http://open.edx.org/","size":1916733,"stargazers_count":1983,"watchers_count":1983,"language":"Python","has_issues":false,"has_downloads":true,"has_wiki":true,"has_pages":true,"forks_count":1138,"mirror_url":null,"open_issues_count":172,"forks":1138,"open_issues":172,"watchers":1983,"default_branch":"master"}},"base":{"label":"edx:master","ref":"master","sha":"40b4bc65f6e93928622f634390ce8d643afad3ed","user":{"login":"edx","id":3179841,"avatar_url":"https://avatars.githubusercontent.com/u/3179841?v=3","gravatar_id":"","url":"https://api.github.com/users/edx","html_url":"https://github.com/edx","followers_url":"https://api.github.com/users/edx/followers","following_url":"https://api.github.com/users/edx/following{/other_user}","gists_url":"https://api.github.com/users/edx/gists{/gist_id}","starred_url":"https://api.github.com/users/edx/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/edx/subscriptions","organizations_url":"https://api.github.com/users/edx/orgs","repos_url":"https://api.github.com/users/edx/repos","events_url":"https://api.github.com/users/edx/events{/privacy}","received_events_url":"https://api.github.com/users/edx/received_events","type":"Organization","site_admin":false},"repo":{"id":10391073,"name":"edx-platform","full_name":"edx/edx-platform","owner":{"login":"edx","id":3179841,"avatar_url":"https://avatars.githubusercontent.com/u/3179841?v=3","gravatar_id":"","url":"https://api.github.com/users/edx","html_url":"https://github.com/edx","followers_url":"https://api.github.com/users/edx/followers","following_url":"https://api.github.com/users/edx/following{/other_user}","gists_url":"https://api.github.com/users/edx/gists{/gist_id}","starred_url":"https://api.github.com/users/edx/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/edx/subscriptions","organizations_url":"https://api.github.com/users/edx/orgs","repos_url":"https://api.github.com/users/edx/repos","events_url":"https://api.github.com/users/edx/events{/privacy}","received_events_url":"https://api.github.com/users/edx/received_events","type":"Organization","site_admin":false},"private":false,"html_url":"https://github.com/edx/edx-platform","description":"The Open edX platform, the software that powers edX!","fork":false,"url":"https://api.github.com/repos/edx/edx-platform","forks_url":"https://api.github.com/repos/edx/edx-platform/forks","keys_url":"https://api.github.com/repos/edx/edx-platform/keys{/key_id}","collaborators_url":"https://api.github.com/repos/edx/edx-platform/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/edx/edx-platform/teams","hooks_url":"https://api.github.com/repos/edx/edx-platform/hooks","issue_events_url":"https://api.github.com/repos/edx/edx-platform/issues/events{/number}","events_url":"https://api.github.com/repos/edx/edx-platform/events","assignees_url":"https://api.github.com/repos/edx/edx-platform/assignees{/user}","branches_url":"https://api.github.com/repos/edx/edx-platform/branches{/branch}","tags_url":"https://api.github.com/repos/edx/edx-platform/tags","blobs_url":"https://api.github.com/repos/edx/edx-platform/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/edx/edx-platform/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/edx/edx-platform/git/refs{/sha}","trees_url":"https://api.github.com/repos/edx/edx-platform/git/trees{/sha}","statuses_url":"https://api.github.com/repos/edx/edx-platform/statuses/{sha}","languages_url":"https://api.github.com/repos/edx/edx-platform/languages","stargazers_url":"https://api.github.com/repos/edx/edx-platform/stargazers","contributors_url":"https://api.github.com/repos/edx/edx-platform/contributors","subscribers_url":"https://api.github.com/repos/edx/edx-platform/subscribers","subscription_url":"https://api.github.com/repos/edx/edx-platform/subscription","commits_url":"https://api.github.com/repos/edx/edx-platform/commits{/sha}","git_commits_url":"https://api.github.com/repos/edx/edx-platform/git/commits{/sha}","comments_url":"https://api.github.com/repos/edx/edx-platform/comments{/number}","issue_comment_url":"https://api.github.com/repos/edx/edx-platform/issues/comments{/number}","contents_url":"https://api.github.com/repos/edx/edx-platform/contents/{+path}","compare_url":"https://api.github.com/repos/edx/edx-platform/compare/{base}...{head}","merges_url":"https://api.github.com/repos/edx/edx-platform/merges","archive_url":"https://api.github.com/repos/edx/edx-platform/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/edx/edx-platform/downloads","issues_url":"https://api.github.com/repos/edx/edx-platform/issues{/number}","pulls_url":"https://api.github.com/repos/edx/edx-platform/pulls{/number}","milestones_url":"https://api.github.com/repos/edx/edx-platform/milestones{/number}","notifications_url":"https://api.github.com/repos/edx/edx-platform/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/edx/edx-platform/labels{/name}","releases_url":"https://api.github.com/repos/edx/edx-platform/releases{/id}","created_at":"2013-05-30T20:20:38Z","updated_at":"2015-06-15T17:02:48Z","pushed_at":"2015-06-15T16:22:50Z","git_url":"git://github.com/edx/edx-platform.git","ssh_url":"git@github.com:edx/edx-platform.git","clone_url":"https://github.com/edx/edx-platform.git","svn_url":"https://github.com/edx/edx-platform","homepage":"http://open.edx.org/","size":1916733,"stargazers_count":1983,"watchers_count":1983,"language":"Python","has_issues":false,"has_downloads":true,"has_wiki":true,"has_pages":true,"forks_count":1138,"mirror_url":null,"open_issues_count":172,"forks":1138,"open_issues":172,"watchers":1983,"default_branch":"master"}},"_links":{"self":{"href":"https://api.github.com/repos/edx/edx-platform/pulls/8206"},"html":{"href":"https://github.com/edx/edx-platform/pull/8206"},"issue":{"href":"https://api.github.com/repos/edx/edx-platform/issues/8206"},"comments":{"href":"https://api.github.com/repos/edx/edx-platform/issues/8206/comments"},"review_comments":{"href":"https://api.github.com/repos/edx/edx-platform/pulls/8206/comments"},"review_comment":{"href":"https://api.github.com/repos/edx/edx-platform/pulls/comments{/number}"},"commits":{"href":"https://api.github.com/repos/edx/edx-platform/pulls/8206/commits"},"statuses":{"href":"https://api.github.com/repos/edx/edx-platform/statuses/cce8b0b4417168db9af7228817d8852ed282bc62"}}}}