WaldorfConnect / portal

Central authentication and management platform - guidepost to all our services!
https://portal.waldorfconnect.de
MIT License
2 stars 0 forks source link

Add buttons to click through schools #51

Open lchristmann opened 11 months ago

lchristmann commented 11 months ago

As a user interested in seeing the different Waldorf schools in Germany (especially see the photos), I'd like to be able to click a school and to swipe (=click) through them, as such:

SwipeThroughSchools

linusgke commented 11 months ago

Looking at the new system where groups and schools are the same, we can't just increment or decrement the id, because unrelated groups could be in between.

lchristmann commented 11 months ago

Indeed. We should get the next school with a SQL query

SELECT * FROM `groups` WHERE `is_school` = 1 AND `id` > currentId ORDER BY `id` LIMIT 1

and the previous school with

SELECT * FROM `groups` WHERE `is_school` = 1 AND `id` < currentId ORDER BY `id` DESC LIMIT 1