MySteemitFriends.Online new feature: 2 Dates filter in Contributors ranking, date integration with contribution calculator

• My Steemit Friends Tool website.
  
• Github repository.
  Relevant commits:
• Commit 2018-02-26
  
  
• Commit 2018-02-27
  
  

New Features

• What feature(s) did you add?

The Contributors Ranking table on My Steemit Friends has a new feature - the 2 Dates Filter. Now you can find out how much your contributors have contributed to your articles between 2 Dates. Please test this feature by going to http://mysteemitfriends.online/contributors.php, enter your username and click "Show Contributors. You will then see not only the amount contributed by each user towards your earnings, but also how many times they have voted you on the right hand side column.

You will see that by default the 2 dates entered in the filter is the date from the start of Steemit until today. You can change these 2 dates to narrow down your search result. In the example below, I decided to see how much my contributors have contributed towards my earnings between 1/Nov and 1/Dec last year.

You will be taken to the contribution calculator page, where it shows you how their contribution is calculated. The total contribution amount should match up to the previous page, as you can see below.

• How did you implement it/them?

Relevant commits:

• Commit 2018-02-26
  
  
• Commit 2018-02-27
  
  

contributors.php: I added two date inputs in the HTML form. When the refresh button is clicked, I used Jquery to append the contents of the two date inputs to the URL and reload the page. When the PHP code on the page detects the two date inputs, it will filter the result with those dates. If there are no dates entered, the default "from" date is 2016-03-30 (when Steemit started) and the "to" date is today's date. I had to restructure the whole prepared SQL statement (it now contains 5 subqueries and 1 main query, each query commented) and bind the dates to the statement. The date filters are applied to the votetime field, which is a field created from extracting the time field in the JSON string in the "active_votes" field in the comments table (using OPENJSON, as shown on line 188) of SteemSQL.

upvotelist.php: I had to remove the rounding for the contribution amount per article. The rounding now occurs at the printing stage only, so even though the amount on the screen is rounded, the background calculations are not rounded. This should ensure that the final amount matches the same amount on the Contributor's Ranking.

---

Posted on Utopian.io - Rewarding Open Source Contributors

---