Test MM : how-to filter on a linked field (select) ?

[Charled]

Hi everyone,

I'm testing MetaModels (Contao3 - dev-contao3 @ c18945) with a Contao 3.2 installation. I have to develop a module to display cultural events. These events :
- are grouped by season (ie : 2013/2014, 2014/2015…)
- group different dates.

For the moment, I've created :
- a MM Seasons with title (text) ; start date (date) ; end date (date);
- a MM Events with at first a select field seasons which is linked to MM season (id column : id ; value : title_season).

In the front-end, I want to display only the events corresponding to season_startdate =< today =<season_enddate ? I've tried with filter but didn't find anyway.
I thought to add a checkbox for the user can check which is the active season but the question remains the same : how to filter "I want to display event where the selected season is the active one".

thanks for your help.

[KlausGrenoble]

Je crois, qu'il faudrait utiliser le filtre " Custom SQL [customsql]" comme ici:
http://contao.klausgraf.fr/metamodel...mp-filter.html
Salutations Klaus

[zonky]

Hi Charled,

I'm not sure whether I heard you...

you have a mm_events with a 1:n relation to mm_season? with items at mm_events

event-1 => season 2013/14
event-2 => season 2013/14
event-3 => season 2015/16
event-4 => season 2017/18

correct?

you can make a filter with the items of season e.g. with a pull-down select

the filter item "season 2013/14" give you the items "event-1" and "event-2"

[KlausGrenoble]

a filter with the items of season e.g. with a pull-down select

Indeed, I think this is the way to proceed. Très bien !

[Charled]

Hi Charled,

I'm not sure whether I heard you...

you have a mm_events with a 1:n relation to mm_season? with items at mm_events

event-1 => season 2013/14
event-2 => season 2013/14
event-3 => season 2015/16
event-4 => season 2017/18

correct?

you can make a filter with the items of season e.g. with a pull-down select

the filter item "season 2013/14" give you the items "event-1" and "event-2"

Hi Zonky,

Thanks for your answer. You're right for the link but I will only display one saison at a time. So I don't need a pull-down select for visitors can choose which season they want to see. I just want the ebents to be automatically selected based on the active season : using the dates [ selectedseason::startdate => today <= selectedseason::enddate ] or simply a checkbox "Season-Active season" (so the BE user can choose when the season changes).

[Charled]

Je crois, qu'il faudrait utiliser le filtre " Custom SQL [customsql]" comme ici:
http://contao.klausgraf.fr/metamodel...mp-filter.html
Salutations Klaus

Thanks Klaus ;-)) If I guessed you will answer, I would have post on the french forum. Even if I suppose we meet more MM user on this one ;-))

[zonky]

Hi Charled,

you can try this with a filter as "own sql" with a subselect

like

SELECT * FROM mm_events WHERE season_id = (SELECT id FROM mm_season WHERE NOW()>FROM_UNIXTIME(date_start) and NOW() < FROM_UNIXTIME(date_end))
// untested !! 

a good way is to work with phpMyAdmin and copy the sql at your filter...

[Charled]

Thanks. I'll test.

[zonky]

a alternative to the "AND" is "BETWEEN"

http://www.techonthenet.com/mysql/between.php

[Charled]

SELECT * FROM mm_events WHERE season_id = (SELECT id FROM mm_season WHERE NOW()>FROM_UNIXTIME(date_start) and NOW() < FROM_UNIXTIME(date_end))
// untested !! 

This works fine. Vielen danke !

[zonky]

YAW! :-)