1
I have a code like this in extcall module
le="color: #000000"><?php $now = time(); $criteriaNoRecur = new CriteriaCompo(); $criteriaNoRecur->add(new Criteria('event_end', $now, '>=')); $criteriaNoRecur->add(new Criteria('event_isrecur', 0));
This produce MySQL select code like
le="color: #000000"><?php OR (event_end >= $now AND event_isrecur = 0) in MySQL query filter.
How can I create criteria
I need to produce this code in MySQL query
le="color: #000000"><?php AND (FIND_IN_SET($Today,REPLACE(event_recur_rules,'|',',')) AND event_isrecur = 1)
e.g.
le="color: #000000"><?php $Today = substr(strtoupper(date('l')),0,2); $criteriaNo = new CriteriaCompo(); $criteriaNo->add(new Criteria('event_recur_rules', $Today, 'FIND_IN_SET'));//?????????? $criteriaNo->add(new Criteria('event_isrecur', 1)); //event_recur_rules column has values like MO|TU|WE $criteriaCompo = new CriteriaCompo(); $criteriaCompo->add($criteriaNoRecur, 'OR'); $criteriaCompo->add($criteriaNo, 'AND');
