quarterly stats v2 -- funder and "no action" views

[owocki]

this is a v2 of #1016 , which contains the following sections

• view for funders
• view for people who haven't taken action yet

bounty

• build the view for funders
• build the view for people who haven't taken action yet

[owocki]

hat tip @jakerockland 4 the design

[gitcoinbot]

Issue Status: 1. Open 2. Started 3. Submitted 4. Done

---

This issue now has a funding of 0.15 ETH (102.99 USD @ $686.57/ETH) attached to it.

• If you would like to work on this issue you can 'start work' on the Gitcoin Issue Details page.
• Questions? Checkout Gitcoin Help or the Gitcoin Slack
• $7,717.21 more funded OSS Work available on the Gitcoin Issue Explorer

[gitcoinbot]

Issue Status: 1. Open 2. Started 3. Submitted 4. Done

---

Work has been started.

These users each claimed they can complete the work by 8 months, 3 weeks ago.
Please review their action plans below:

1) oogetyboogety has started work.

app/dashboard/models.py: Add queries to method get_quarterly_stats and store the results as variables similar to bounties fulfilled, but for bounties funded
-> Add an array funded_bounties alongside fulfilled_bounties
-> Filter then count total number of issues with a bounty funded by user
-> Filter then count total number of issues with a bounty funded by user in a certain terminal status
-> Filter for list of developers who contributed to issues with a bounty funded by user (BountyFulfillment Django Lookup that Spans Relationship)
-> Total number of hours (bountyfulfillment__bountyfulfiller_hours_worked) worked by developers on issues with a bounty funded by user
-> Total of transactions in USD of issues with bounties with developers who contributed to the issue funded by user
-> Add a function call or inline function at the end to a new method get_inactive_recommendations and pass the profile's list of languages in line 1144's user_languages variable

app/dashboard/models.py: Add method get_inactive_recommendations only to be run for users that are inactive in the last quarter.
-> Find requirements for caching or running this just once for a distinct set of language combinations by profile, and associating a random set of issues with each distinct set
-> Lookup bounties with the highest number of languages in overlap between user_languages and bounty's keywords, limit results to a number in a parameter or configurable constant variable

app/retail/templates/emails/quarterly_stats.html: Add template for if user not active in last quarter

app/retail/templates/emails/quarterly_stats.html: Add template for if user is a funder

Learn more on the Gitcoin Issue Details page.

[gitcoinbot]

@oogetyboogety Hello from Gitcoin Core - are you still working on this issue? Please submit a WIP PR or comment back within the next 3 days or you will be removed from this ticket and it will be returned to an ‘Open’ status. Please let us know if you have questions!

• warning (3 days)
• escalation to mods (6 days)

Funders only: Snooze warnings for 1 day | 3 days | 5 days | 10 days | 100 days

[owocki]

just snoozed the warnings

[oogetyboogety]

@owocki

app/marketing/mails.py as well - I had to twist the quarterly_stats function to look a little like the new_bounty function in the way it loops through EmailSubscribers and gets their keywords and then passes these keywords to the render function.

I am testing these changes now, should be finished by tomorrow or day after.

Thanks!

[thelostone-mc]

@oogetyboogety Give me a heads up and i'll check it out
PS: screenshots always help ^_^

[owocki]

@oogetyboogety sounds good to me. looking forward to testing this!

[owocki]

@oogetyboogety do you think we'll see a PR this week/

[oogetyboogety]

@owocki yup testing with rinkeby now. i'll make a WIP PR today if things start to fail

[oogetyboogety]

@owocki @thelostone-mc #1311 this one has the WIP label for review reasons. Please let me know what you think.

[owocki]

looks good so far

[oogetyboogety]

@owocki @thelostone-mc https://github.com/gitcoinco/web/pull/1311/files final PR for review

[oogetyboogety]

[oogetyboogety]

[gitcoinbot]

Issue Status: 1. Open 2. Started 3. Submitted 4. Done

---

Work for 0.15 ETH (70.52 USD @ $470.16/ETH) has been submitted by:

1. @oogetyboogety
2. @oogetyboogety

@owocki please take a look at the submitted work:

• PR by @oogetyboogety
• PR by @oogetyboogety

---

• Learn more on the Gitcoin Issue Details page
• Questions? Checkout Gitcoin Help or the Gitcoin Slack
  $30,409.54 more funded OSS Work available on the Gitcoin Issue Explorer

[oogetyboogety]

@owocki submitted! let me know if i should do anything else

[gitcoinbot]

Issue Status: 1. Open 2. Started 3. Submitted 4. Done

---

The funding of 0.15 ETH (69.43 USD @ $462.85/ETH) attached to this issue has been approved & issued to @oogetyboogety.

• Learn more on the Gitcoin Issue Details page
• Questions? Checkout Gitcoin Help or the Gitcoin Slack
• $30,007.91 more funded OSS Work available on the Gitcoin Issue Explorer

[alp82]

Shouldn't this be closed?