function imagepicker_get_all_groups in Image Picker 7

Same name and namespace in other branches

1. 6.2 imagepicker.module \imagepicker_get_all_groups()

2 calls to imagepicker_get_all_groups()

imagepicker_block_form in ./imagepicker.module

imagepicker_settings_form in ./imagepicker.admin.inc

Function to display the imagepicker admin settings form

File

./imagepicker.module, line 855

@author Bob Hutchinson http://drupal.org/user/52366 @copyright GNU GPL

Code

function imagepicker_get_all_groups($override = NULL) {
  $public = FALSE;
  if ($override == NULL) {
    $public = imagepicker_variable_get('imagepicker_galleryblocks_public', 0);
  }
  else {
    $public = $override;
  }
  $data = FALSE;
  $query = db_select('imagepicker_user_groups', 'g');
  $query
    ->fields('g', array(
    'gid',
    'group_name',
  ));
  if ($public) {
    $query
      ->condition('g.public', 1);
  }
  $rows = $query
    ->execute();
  foreach ($rows as $row) {
    $query2 = db_select('imagepicker_group_images', 'gi');
    $query2
      ->addExpression('COUNT(DISTINCT gi.img_id)', 'ct');
    $query2
      ->join('imagepicker_user_groups', 'g', 'g.gid = gi.gid');
    $query2
      ->condition('g.gid', $row->gid);
    $row2 = $query2
      ->execute()
      ->fetchAssoc();
    $totcount = $row2['ct'];
    $data[$row->gid] = $row->group_name . ' - ' . format_plural($totcount, '1 image', '@count images');
  }
  return $data;
}