function simplenews_scheduler_filter_value in Simplenews Scheduler 5

Same name and namespace in other branches

1. 8 simplenews_scheduler_views.inc \simplenews_scheduler_filter_value()
2. 6.2 simplenews_scheduler_views.inc \simplenews_scheduler_filter_value()
3. 7 simplenews_scheduler_views.inc \simplenews_scheduler_filter_value()
4. 2.0.x simplenews_scheduler_views.inc \simplenews_scheduler_filter_value()

1 string reference to 'simplenews_scheduler_filter_value'

simplenews_scheduler_views_tables in ./simplenews_scheduler_views.inc

Implementation of hook_views_tables

File

./simplenews_scheduler_views.inc, line 55

simplenews_scheduler_views.inc Views support for simplenews

Code

function simplenews_scheduler_filter_value($op, $filter, $filterinfo, &$query) {

  // get oldest last_run time of the selected newsletter
  $result = db_query("SELECT * from {simplenews_scheduler} WHERE snid IN (%s) ORDER BY last_run limit 0,1", implode(',', $filter['value']));
  $last_run = db_fetch_array($result);
  $table = $filterinfo['table'];
  $column = $filterinfo['field'];
  $field = "node.created";
  $query
    ->add_where("%s %s %d", $field, $filter['operator'], $last_run['last_run']);
}