function simplenews_scheduler_filter_value in Simplenews Scheduler 8

Same name and namespace in other branches

1. 5 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 48

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 ss.*,n.created FROM {simplenews_scheduler} ss\n                      LEFT JOIN {node} n on n.nid = ss.snid\n                      WHERE ss.snid IN (%s) \n                      ORDER BY ss.last_run \n                      LIMIT 0,1", implode(',', $filter['value']));
  $last_run = db_fetch_array($result);

  // then it hasnt run yet, so we use the creation date of the newsletter parent instead
  $trigger_time = $last_run['last_run'] > 0 ? $last_run['last_run'] : $last_run['created'];
  $query
    ->add_field('created', 'node');
  $query
    ->add_where("node.created %s %d", $filter['operator'], $trigger_time);
}