Wordpress Meta_Query open close time

Question

I am trying to make a filter with open and closed checkbox using Meta_Query. The value of metadatas is UNIX time, so the value of $opening_time and $closing_time is number like this - 234321543. It only works without $status_2, $opening_time_2, $closing_time_2. I think that something wrong with time logic.
How can i get it worked?

    $status =         'opening_hours_monday_day_status';
    $opening_time =   'opening_hours_monday_opening_time';
    $closing_time =   'opening_hours_monday_closing_time';
    $status_2 =       'opening_hours_monday2_day_status';
    $opening_time_2 = 'opening_hours_monday2_opening_time';
    $closing_time_2 = 'opening_hours_monday2_closing_time';
    $current_time =   strtotime('2016-01-01 ' . current_time('h:i a'));
    $element_filter_arr = array();
             if ($timings == 'open') {
                    $element_filter_arr[] = array(
                        'key' => $status,
                        'value' => 'on',
                        'compare' => '=',
                    );
                    $element_filter_arr[] = array(
                        'key' => $opening_time,
                        'value' => $current_time,
                        'compare' => '<=',
                    );
                    $element_filter_arr[] = array(
                        'key' => $closing_time,
                        'value' => $current_time,
                        'compare' => '>=',
                    );
                    $element_filter_arr[] = array(
                        'key' => $status_2,
                        'value' => 'on',
                        'compare' => '=',
                    );
                    $element_filter_arr[] = array(
                        'key' => $opening_time_2,
                        'value' => $current_time,
                        'compare' => '<=',
                    );
                    $element_filter_arr[] = array(
                        'key' => $closing_time_2,
                        'value' => $current_time,
                        'compare' => '>=',
                    );
                } else if ($timings == 'close') {
                    $element_filter_arr[] = array(
                        'relation' => 'OR',
                        array(
                            'key' => $status,
                            'value' => 'off',
                            'compare' => '=',
                        ),
                        array(
                            'key' => $opening_time,
                            'value' => $current_time,
                            'compare' => '>',
                        ),
                        array(
                            'key' => $closing_time,
                            'value' => $current_time,
                            'compare' => '<',
                        ),
                    );
                }

$args = array(
                    'posts_per_page' => "-1",
                    'post_type' => 'shop',
                    'post_status' => 'publish',
                    'fields' => 'ids',
                    'meta_query' => array(
                        $element_filter_arr,
                    ),

And are you sure about this value `234321543`, its `06/05/1977 @ 1:19am (UTC)` — Sudharshan Nair, Jul 12 '18 at 04:15
One more thing, We only need time to compare, and we are comparing with date, Can you also give me values that are in opening and close times — Sudharshan Nair, Jul 13 '18 at 04:46
Nair, the values of opening and closing variables are unix time. — Tod, Jul 13 '18 at 10:01
What are you trying to fetch, To pass date and time and get posts which are opened at that time ? Am I correct ? — Sudharshan Nair, Jul 13 '18 at 10:13
yes, correct.If i remove $status_2, $opening_time_2 and $closing_time_2 it works well. — Tod, Jul 13 '18 at 11:34
Hey do you want to look into both dates? or any one of them? You have to use `'relation' => 'OR',` or `'relation' => 'AND',` as per your requirements — Sudharshan Nair, Jul 13 '18 at 11:39
i have open/close time list like this : 01:00 pm - 12:00 am || 12:00 am - 02 am, after it is converted to unix time , open1 = 2345234 closing1 = 231425 and open2= 2343453 closing2 =3425435 , i have filter checkbox showing open/close shops, it works only with one of them either with only open1 etc. or with only open2 etc. — Tod, Jul 13 '18 at 11:48
First of all try my answer only for open condition and tell me whether it is working for you or not ? — Sudharshan Nair, Jul 13 '18 at 11:58

Sudharshan Nair · Answer 1 · 2018-07-13T11:57:15.003

0

Can you try this for open condition

if ($timings == 'open') {       
   $meta_query_args = array(
     'relation' => 'OR',
    array(
    'relation' => 'AND',
        array(
            'key' => $status,
            'value' => 'on',
            'compare' => '=',
        ),
        array(
            'key' => $opening_time,
            'value' => $current_time,
            'compare' => '<=',
        ),
        array(
            'key' => $closing_time,
            'value' => $current_time,
            'compare' => '>=',
        ),
    ),
    array(
    'relation' => 'AND',
        array(
            'key' => $status2,
            'value' => 'on',
            'compare' => '=',
            ),
        array(
            'key' => $opening_time2,
            'value' => $current_time,
            'compare' => '<=',
        ),
    array(
        'key' => $closing_time2,
        'value' => $current_time,
        'compare' => '>=',
    ),
    ),
    );
   }
$meta_query = new WP_Meta_Query( $meta_query_args );

edited Jul 13 '18 at 11:57

answered Jul 13 '18 at 11:44

Sudharshan Nair

1,152
1
10
24

internal 500 error ? Its just an example. I hope you added `post_type` to this meta query – Sudharshan Nair Jul 15 '18 at 05:42
Thank you , bro , for trying to help me, but i have already resolved it . – Tod Jul 15 '18 at 21:36
You can post you answer, So that it may be helpful for others – Sudharshan Nair Jul 16 '18 at 03:59
I just divided it into two blocks and used if(intval(date('H')) – Tod Jul 17 '18 at 14:13

Wordpress Meta_Query open close time

1 Answers1