Filter by year (custom dropdown)

[nicktfParticipant]

Good day, please could you assist in creating a year dropdown filter? The datepicker isn’t ideal, as we only want to be able to search within a year, and the datepicker requires selection of a month and day as well.

Please note, the server only allows SFTP and requires a port: 57887

I am working on getting the VPN disabled so that you can gain wp-admin access if need be.

I have tried to implement code as per the documentation – though it’s quite difficult to understand, because half of it is commented out, and not even sure if adding a dropdown (select>options) is even possible?
Here is the documentation I tried to follow. I will post my code attempt below. https://knowledgebase.ajaxsearchpro.com/frontend-filters/frontend-filters-api#date-type-custom-field-filter

Otherwise, I know that jquery UI allows you to change the datepicker to a year using: https://api.jqueryui.com/datepicker/#option-changeYear
As well as providing a range using: https://api.jqueryui.com/datepicker/#option-yearRange
In this case we would need to override the initialisation of the datepicker as it’s created.

// --------------------------------
// Date filter example https://knowledgebase.ajaxsearchpro.com/frontend-filters/frontend-filters-api#date-type-custom-field-filter
// --------------------------------
add_action('asp_pre_parse_filters', 'asp_add_my_own_filters', 10, 2);
function asp_add_my_own_filters($search_id, $options) {
    if ( $search_id == 1 ) {
        $filter = wd_asp()->front_filters->create(
            'custom_field',
            'Date Picker',
            'dropdown',
            array(
                'field' => '_date',
                'placeholder' => 'all',
                // The display date format
                'date_format' => 'yy',
            )
        );
        //add years from 2019 to the current year
        $datesArray = array();
        for ($i = 2019; $i <= date('Y'); $i++) {
            //add all
            if($i == 2019) {
                $datesArray[] = array(
                    'label' => 'All',
                    'value' => '',
                    'selected' => true
                );
            }
            $datesArray[] = array(
                'label' => $i,
                'value' => $i
            );
        }
        $filter->add(
            $datesArray
        );
        $filter->selectByOptions($options);
        wd_asp()->front_filters->add($filter);
    }
}

[Ernest MarcinkoKeymaster]

Hi,

If by any chance the date is stored in a mysql datetime format, or something similar to that – and not as timestamp – then there might be a way to achieve that without a single line of code.

The idea is to treat the datetime field as a “string”. Datetime is stored like 2024-12-31 23:59:59 – which is very lucky for us, as the year is the only 4 digit string to match.

Therefore creating a drop-down/radio/checkbox filter with simply the year values like this will actually match the year: https://i.imgur.com/P5zdZvQ.png
If the field is stored as datetime, this will always match the year, as it’s the only 4 digit value in the field.

Doing a range type with this method is not possible. However if you were have a separate custom field to only store the year, then you will be able to also use the range slider filter as well.

Best,
Ernest Marcinko
If you like my products, don't forget to rate them on codecanyon :)

[nicktfParticipant]

Thank you, that worked. I added some code to generate the post_meta based on the published date, and set the custom field to that.

[Ernest MarcinkoKeymaster]

You cannot access this content. Best,
Ernest Marcinko
If you like my products, don't forget to rate them on codecanyon :)

[Author]

Posts