search

justinschuldt / syr-marketplace

Open-source marketplace front-end powered by Stelace API including search, platform automation, user management, transactions, real-time messaging, ratings and much more :zap:
https://marketplace.demo.stelace.com
MIT License
1 stars 3 forks source link

Rating system - add medals in addition to the stars based on interactions. #30

Open sittingbull15 opened 3 years ago

sittingbull15 commented 3 years ago

Bluemark for sellers who submit Safe food handler certification and acknowledge that they read the Safe Food Protection Manual during onboarding.

Every time a chef sells a dish, he/she get +30 pts, if he/she has to cancel or get complaints it's -50 pts. If the chef have all 4 social icons listed (+30 for each link). Have safe food handling cert and acknowledge that he/she finishes the Food Protection Manual (+2000 pts). Each medal needs 2000 pts to get to the next level (bronze, silver, gold, diamond, platinum). Each medal has 1 to 5 stars as a chef progresses. Hence the chefs who submit the docs start off as silver one-star medal and if not start with bronze one star - A SQL equation/algo in the backend database. Refer below for reference.

A ranking board will be displayed on the main landing page.

https://www.theloadout.com/dota-2/ranks

junyanyao commented 3 years ago

Not sure what the table is looking like. Sounds like you will need some case when and window functions (rank, dense_rank, row_number, etc). If you can give me the table view, I probably can help further