function simplenews_build_subscription_filter_query in Simplenews 7.2

Same name and namespace in other branches

1. 5 simplenews.module \simplenews_build_subscription_filter_query()
2. 6.2 includes/simplenews.admin.inc \simplenews_build_subscription_filter_query()
3. 6 simplenews.admin.inc \simplenews_build_subscription_filter_query()
4. 7 includes/simplenews.admin.inc \simplenews_build_subscription_filter_query()

Apply filters for subscription filters based on session.

Parameters

$query: A SelectQuery to which the filters should be applied.

1 call to simplenews_build_subscription_filter_query()

simplenews_subscription_list_form in includes/simplenews.admin.inc

Menu callback: subscription administration.

File

includes/simplenews.admin.inc, line 1633

Newsletter admin, subscription admin, simplenews settings

Code

function simplenews_build_subscription_filter_query(SelectQueryInterface $query) {
  if (isset($_SESSION['simplenews_subscriptions_filter'])) {
    foreach ($_SESSION['simplenews_subscriptions_filter'] as $key => $value) {
      switch ($key) {
        case 'list':
          if ($value != 'all') {
            list($key, $value) = explode('-', $value, 2);
            $query
              ->condition('su.' . $key, $value);
          }
          break;
        case 'email':
          if (!empty($value)) {
            $query
              ->condition('sn.mail', '%' . $value . '%', 'LIKE');
          }
          break;
      }
    }
  }
}