Craft CMS Stack Exchange is a question and answer site for administrators, end users, developers and designers for Craft CMS. It only takes a minute to sign up.
Sign up to join this community
I need to count the number of consecutive years a user has been a member of our organization. For example, if they've been a member from in 2018, 2019, 2020 and 2021, their loyalty will be 4 years.
If they've been a member in 2018, 2019 and 2021, their loyalty will be 1 year (they missed 2020.)
I'm currently using Categories to assign a year to Users in Craft to do the assignment of a year to a person.
Hope that makes sense. I would very much appreciate some help on how to tackle it!
If you don't want to build a custom plugin, this would be a good time to use Twig's reduce filter, which takes a set of values and iterates over them to output a single value based on supplied logic.
Using Andy's answer as the basis might look like this (untested):
{% set currentYear = now|date('Y') %}
{% set loyaltyScore = currentUser.years.all()|reduce(
(score, year) =>
score == 0 and year == currentYear or
score > 0 and year == currentYear - 1 ?
score + 1,
0
) %}
I'm assuming your data is already in the right order if it's a category group.
loyaltyScore it's blank. I've not used reduce before so a bit unsure. {% set currentYear = now|date('Y') ~ '/' ~ now|date_modify("+1 year")|date('y') %}
{{ '2021/22'|slice(4) }}
Apr 28, 2021 at 8:21
Pseudo-code:
Fetch all category values, push the year string to an array.
Sort that array in descending order by value.
Initialise a counter, loop over the array, cast each value as an integer:
-- if first array value is same as the current year, increase a counter, otherwise break.
-- if loop year equals previous loop year minus 1, increase a counter otherwise break.
Your loyalty value is the counter.
currentUser.years|myfilter