Weighted-Aggregated-Attestation-API

[MoeNick]

Related to #23 and #24

we should have an aggregated weighted results API which is calculated daily or twice a day. This API is a result of reading all user attestations and weighting them with voting power points and calculating the aggregated results. More information is here: https://www.notion.so/giveth/Weighted-Aggregated-Attestation-APIs-0d7c33180e2744e5943b31f1f53d67d5

Success Criteria

• Calculations will be made on Pairwise servers.
• We need to divide data into 4 views by stakeholder
• each view has a final overall ranking for every project.
• Final number would be like: ProjectX {rankTotal} ({rankInTheirCategory})
• APIs Requirements:
  1. Ranked Projects List and Ranked Category List in Four views:
  2. Filtered by Holders’ vote
  3. Filtered by Delegates’ vote
  4. Filtered by Badgeholders vote
  5. Filtered by Recipients’ vote
  6. The list of projects should include
  7. the logo of the project,
  8. the name of the project,
  9. The category of the project
  10. The rank of the project inside their category.
  11. a relation to RPGF Project ID
  12. The Ranked list of projects should be able to be filtered by category
  13. The list of categories should include
  14. Name
  15. Rank (based on the votes)
  16. Each service preferably has sorting and paginations for all views
  17. A final metric for each project: ProjectX {rankTotal} ({rankInTheirCategory})
• Distribution formula can be kept as pairwise % for now until it has been decided and replaced later. Some Thoughts Are Here
• Sample of Badges Points

[MoeNick]

@jainkrati I added all notion docs for this issue here. The bad news is we should make it up and working 10th June and end up by 18th.

[maryjaf]

I've tested based on this temp/api https://pairwise.melodicdays.shop/flow/temp/api

I tested with different address and badges and it seems it works correctly and weight of each project in category is calculated correctly

Is this view is fine in point of you for this phase ? @MoeNick https://pairwise.melodicdays.shop/flow/temp/api

[MoeNick]

We should have filtering in API as inputs based on :

• StakeHolder (4 voter roles)
• Category

We should have project logo we should have ranking as whole without filtering any category.

For success criteria please go to the notion doc attached to teh isssue.

[MoeNick]

Also please lets have staging and production data separated ASAP.

[MoeNick]

1. We should test on https://rpgf4-be.pairwise.vote/flow/temp/api

2. Atestations here: https://optimism.easscan.org/schema/view/0x8c12749f56c911dbc13a6a6685b6964c3ea03023f246137e9c53ba97974e4b75

3, The logic is here: https://docs.google.com/spreadsheets/d/1G7Csc9Zp-szcl5xF6wiAyyad3DGiTuYUw1xw_fRHp0Y/edit?gid=321434975#gid=321434975

[MoeNick]

Shall I wait for filtering inputs on API r we can call it done? @mmahdigh @maryjaf

[MoeNick]

• Badgeholders filter is important
• Result of csv.