Filter Date custom filed

1 month 1 week ago #8781 by Ajeje Brazorf
How can I filter date custom field?

Please Log in or Create an account to join the conversation.

1 month 1 week ago - 1 month 1 week ago #8782 by Ajeje Brazorf
I solved it like this:
- plugins/system/jlcontentfieldsfilter/jlcontentfieldsfilter.php
line 223 add
case 'calendar':
if(!empty($v['from']) && !empty($v['to'])){
$where = '(field_id = '.$k.' AND `value` BETWEEN "'.$v['from'].' 00:00:00" AND "'.$v['to'].' 00:00:00")';
else if(!empty($v['from'])){
$where = '(field_id = '.$k.' AND `value` >= "'.$v['from'].' 00:00:00")';
else if(!empty($v['to'])){
$where = '(field_id = '.$k.' AND `value` <= "'.$v['to'].' 00:00:00")';
$where = '(field_id = '.$k.' AND value LIKE '.$db->quote('%'.$v.'%').')';

- plugins/system/jlcontentfieldsfilter/fields/jlcontentfieldsfilterfields.php
line 83 add
case 'calendar':
$options = HTMLHelper::_('select.option', 'calendar', Text::_('PLG_JLCONTENTFIELDSFILTER_FILTER_CALENDAR'));

- /modules/mod_jlcontentfieldsfilter/layouts/mod_jlcontentfieldsfilter
duplicate range.php file and rename in calendar.php
in input type date change in "date"

- modules/mod_jlcontentfieldsfilter/assets/javascript/jlcontentfilter.js
line 46
form.find('input[type="text"], input[type="date"]').val('');

- modules/mod_jlcontentfieldsfilter/assets/javascript/nojq_jlcontentfilter.js
var els = form.querySelectorAll('input[type="text"], input[type="date"]');
Last edit: 1 month 1 week ago by Ajeje Brazorf.

Please Log in or Create an account to join the conversation.

Powered by Kunena Forum

Last from the forum

    • Slogin не работает на главной странице
    • Столкнулся с проблемой что на главной странице сайта: 1) Не работает вход полину/паролю через Slogin. Вход через соц сети при этом работает. 2) Не работает выход через Slogin. На любой другой странице все ок. Думал дело в кеше, оключал его где только можно. Не помогло.  Может кто-то сталкивался с подобным?  Адрес сайта: Версия компонента - 2.10.1 Версия модуля - 2.7.0 Версия Joomla:  3.10.3 Stable Спасибо!
    • In Component / Slogin
    • problem in current chrome version (android) on goo...
    • Hello First of all thanks a lot for the amazing free extention. I have a poblem with the current slogin on the chrome version 96.0.4664.45 android. it gives you this error ----- object(stdClass)#642 (3) { ["code"]=> int(401) ["message"]=> string(215) "Request is missing required authentication credential. Expected OAuth 2 access token, login cookie or other valid authentication credential. See" ["status"]=> string(15) "UNAUTHENTICATED" } ----- and if you reopen the website you will be logged in already but the user will never know! the problem is not happening on the desktop or even on the same android device using another browser. but most of android devices are using chrome so this is a huge probel for me and I wish you can help me with it. Also, i tried to uninstall and reinstall the google plugin but it did not worked. Waiting for your answer. Thanks in advanced
    • In Component / Slogin
    • вывод плагина в ином месте
    • Добрый день, господа. Не могу разобраться, как вывести кнопку покупки не в конце странице, а к примеру в начале или в определенном блоке #id на странице материала. Может кто подскажет?
    • In Plugins Joomline / Content Cart
© 2010- JoomLine
The Joomla!® name is used under a limited license from Open Source Matters in the United States and other countries. is not affiliated with or endorsed by Open Source Matters or the Joomla! Project.

email: This email address is being protected from spambots. You need JavaScript enabled to view it.