Add Views Filter handler for Open/Closed (today/now/soon)

Adding this to the generic issue #696262: Show Status 'Open/Closed (now/today/soon)' in Views

Re-opening this issue, since the issue mentioned in #1 refers to 'showing' not 'selecting' the status.

Latest -dev version contains Views 3 support.
The 2 Filter-handlers in the /includes directory are not converted yet, and should be able to perform this task.
(ATM they are disabled by commenting the out in the .info file.)

Patches are welcome.

See also #1945368: Integrate with Search API / Apache Solr

subscribe

I am achieving "now open" filter in views using a views_php filter with the following code

$node=node_load($data->nid);
foreach($node->field_working_hours['und'] as $day){
	$d = (int)$day['day'];
	$s = (int)$day['starthours']/100;
	$e = (int)$day['endhours']/100;
    $start=strtotime('-1 sunday + ' . $d  . ' days + ' . $s/100  . ' hours');
    if($s>=$e)
		$d=$d+1;
    $end=strtotime('-1 sunday + ' . $d  . ' days + ' . $e/100  . ' hours');
 
   if(microtime()>=$start && microtime()<=$end) return true;
}
return false;

If you use minutes, you need to add them to the code.

Any plans to implement an open now / closed now Exposed filter in views?

Or is there a other way to get this function? Can the result from the views_php module exposed? Or can any other moudel read it? Maybe Rules? So is it possible to unpublish or fill a other field if the views_php filter return false?

This commit adds a filter with options: closed/open now/open today.

Thank you for the commit.
If i try to add filter i get an Ajax error:

An AJAX HTTP error occurred.
HTTP Result Code: 500
Debugging information follows.
Path: ../admin/structure/views/ajax/add-item/navigation/default/filter
StatusText: Internal Server Error
ResponseText:

In addition there is an error in the log:
Notice: Undefined index: aliases in office_hours_field_views_data_alter() (Zeile 22 von ../sites/all/modules/office_hours/office_hours.views.inc).

Above commit is a new try.

This johnv is awesome.
It works better, i can add the filter now but it can only filter the "open" nodes.
The closed dont work.
Bothe Filter display Error:

Notice: Undefined index: und in office_hours_handler_filter_open->post_execute() (line 115 of .../sites/all/modules/office_hours/includes/office_hours_handler_filter_open.inc).
Warning: Invalid argument supplied for foreach() in office_hours_handler_filter_open->post_execute() (line 115 of .../sites/all/modules/office_hours/includes/office_hours_handler_filter_open.inc).
Notice: Undefined index: und in office_hours_handler_filter_open->post_execute() (line 115 of .../sites/all/modules/office_hours/includes/office_hours_handler_filter_open.inc).
Warning: Invalid argument supplied for foreach() in office_hours_handler_filter_open->post_execute() (line 115 of .../sites/all/modules/office_hours/includes/office_hours_handler_filter_open.inc).

Yeah, the current version is very basic:
- you must use nodes. Not other entites, not revisions.
- you must not translate the field (hence the 'und') Please check the database which language you use. Do you use translation? Content Translation? Entity Translation?

I'll see what I can do. Please answer the above questions.

I installed the module and did no translation to it, but i use german language in the frontend. English for backend / Admin.
The vies show only node.
But i can't follow you which language my database is, where should i look ?

Now i deactivated locale module, deinstall it, reinstall office hours, create new contenttype, new office hour field, created a new view for nodes only. Now there is no error.
BUT the closed nodes still not visible if the filter is selected.

Try the next update. It fixes the language problem and the selection problem.

Same Error, closed nodes not displayed. I will trie again a fresh Drupal

REmoving and re-adding the filter from your view might help (save inbetween)

No Change :( Same Error and behavior with 7.x-1.3+16-dev

7.x-1.3+17-dev works. I will try with locale and l10update etc.

Hello guys,
I have a problem

i have created new content type for tenders with following fields:
Title,
Files,
start date,
close date,
status ( open/close)
In view i want to apply following filter.
Between open and close date status will be open and i want to change status to close at closing date.

Hi,
Exposed filter does not work with open now \ closed now.
Drupal 7.64 Office hours 1.8

I see readme.txt, when will it be possible?