spaces_casetracker.module in Spaces 5

File

spaces_casetracker/spaces_casetracker.module

<?php

/**
 * Implementation of hook_menu()
 */
function spaces_casetracker_menu($may_cache) {
  $items = array();
  if ($may_cache) {
    $items[] = array(
      'path' => 'spaces/team/autocomplete',
      'title' => t('Group Members'),
      'callback' => 'spaces_casetracker_users_autocomplete',
      'access' => user_access('access case tracker'),
      'type' => MENU_CALLBACK,
    );
  }
  return $items;
}

/**
 * Implementation of hook_help()
 */
function spaces_casetracker_help($page) {
  if (context_get('spaces', 'feature') == 'casetracker') {
    if (strpos('node/add', $page) === 0) {
    }
    else {
      return "<p>" . t('The casetracker allows you to file tickets for other team members and keep track of tasks that others have filed for you.') . "</p>";
    }
  }
}

/**
 * Implementation of hook_block()
 */
function spaces_casetracker_block($op = 'list', $delta = 0) {
  if ($op == 'list') {
    $blocks = array();
    $blocks[1]['info'] = t('Spaces: User Casetracker Stats');
    return $blocks;
  }
  else {
    if ($op == 'view') {
      switch ($delta) {
        case 1:
          $u = (object) array(
            'uid' => arg(1),
          );
          $u = user_load($u);
          $block['subject'] = t('Case Stats for @user', array(
            '@user' => $u->name,
          ));
          $block['content'] = theme('spaces_casestats', spaces_casetracker_case_stats(arg(1), spaces_gid()), $u->name);
          return $block;
      }
    }
  }
}

/**
 * Implementation of hook_form_alter()
 */
function spaces_casetracker_form_alter($form_id, &$form) {
  switch ($form_id) {
    case 'casetracker_basic_case_node_form':
    case 'comment_form':

      // Allow adding cases in batches
      if ($_GET['batch'] == 1) {
        $form['#redirect'] = array(
          'node/add/casetracker-basic-case',
          'batch=1',
        );
      }

      // Change the autocomplete callback to limit by group & Remove disallowed projects.
      if (isset($form['casetracker_project_information'])) {
        $pid = $form_id == 'casetracker_basic_case_node_form' ? 'pid' : 'prid';

        // "sigh." see casetracker_form_alter() for details.
        if (is_array($form['casetracker_project_information'][$pid]['#options'])) {
          foreach ($form['casetracker_project_information'][$pid]['#options'] as $key => $value) {
            $node = array(
              'nid' => $key,
              'type' => 'casetracker_basic_project',
            );
            $groups = og_get_node_groups((object) $node);
            if ($current_gid = spaces_gid()) {
              if (!array_key_exists($current_gid, $groups)) {
                unset($form['casetracker_project_information'][$pid]['#options'][$key]);
              }
            }
          }
          $form['casetracker_case_information']['assign_to']['#autocomplete_path'] = 'spaces/team/autocomplete/' . $current_gid;
        }
      }
      break;

    // Views filters
    // Handle exposed casetracker filters, sadly case tracker is dumb to og.
    case 'views_filters':
      switch ($form['#view_name']) {
        case 'spaces_cases_my':
        case 'spaces_cases_byproject':
        case 'spaces_cases_bycreated':
          unset($form['filter0']['#options']);
          $form['filter0']['#options'] = spaces_casetracker_project_options();
          break;
        case 'spaces_cases_byuser':
          unset($form['filter0']['#options']);
          $form['filter0']['#options'] = spaces_casetracker_user_options();
          break;
        case 'spaces_cases_filter':
          unset($form['filter0']['#options']);
          $form['filter0']['#options'] = spaces_casetracker_project_options();
          unset($form['filter1']['#options']);
          $form['filter1']['#options'] = spaces_casetracker_user_options();
          break;
      }
      break;
  }
}

/**
 *  Implementation of hook_default_views
 */
function spaces_casetracker_views_default_views() {
  $default_views = array(
    '_spaces_casetracker_views_cases',
    '_spaces_casetracker_views_cases_recent',
    '_spaces_casetracker_views_cases_bystatus',
    '_spaces_casetracker_views_cases_byuser',
    '_spaces_casetracker_views_cases_byproject',
    '_spaces_casetracker_views_cases_my',
    '_spaces_casetracker_views_cases_myblock',
    '_spaces_casetracker_views_cases_mycreated',
    '_spaces_casetracker_views_cases_filter',
    '_spaces_casetracker_views_cases_projects',
  );
  foreach ($default_views as $v) {
    $view = call_user_func($v);
    if (is_object($view) && $view->name) {
      $views[$view->name] = $view;
    }
  }
  return $views;
}

/**
 * hook_context_define()
 */
function spaces_casetracker_context_define() {
  $items = array();
  $items[] = array(
    'namespace' => 'spaces',
    'attribute' => 'feature',
    'value' => 'casetracker',
    'node' => array(
      'casetracker_basic_case',
      'casetracker_basic_project',
    ),
    'views' => _spaces_casetracker_views(),
    'block' => array(
      array(
        'module' => 'views',
        'delta' => 'spaces_cases_myblock',
        'region' => 'right',
        'weight' => -11,
      ),
    ),
    'menu' => array(
      'cases',
    ),
    'spaces' => array(
      'label' => t('Casetracker'),
      'description' => t('A casetracker for managing projects.'),
      'options' => _spaces_group_options(),
    ),
  );
  return $items;
}
function _spaces_casetracker_views() {
  return array(
    'spaces_cases',
    'spaces_cases_my',
    'spaces_cases_mycreated',
    'spaces_cases_bystatus',
    'spaces_cases_byuser',
    'spaces_cases_byproject',
    'spaces_cases_filter',
    'spaces_cases_recent',
    'spaces_cases_projects',
    'spaces_cases_myblock',
  );
}

/*
 * Implementation of hook_views_post_view()
 */
function spaces_casetracker_views_post_view(&$view) {
  if ($view->build_type == 'page' && in_array($view->name, _spaces_casetracker_views())) {
    context_set('theme', 'layout', 'wide');
  }
}

/**
 * Build option array of project id's for the current group.
 */
function spaces_casetracker_project_options() {
  $return = array();
  $results = db_query(db_rewrite_sql("SELECT ct.project_number, n.title FROM {node} n INNER JOIN {casetracker_project} ct ON n.nid = ct.nid INNER JOIN {og_ancestry} og ON n.nid = og.nid WHERE n.type IN (" . str_pad('', count(array_filter(variable_get('casetracker_project_node_types', array(
    'casetracker_basic_project',
  )))) * 5 - 1, "'%s',") . ") AND og.group_nid = %d AND n.status = 1 ORDER BY n.title"), array_merge(array_filter(variable_get('casetracker_project_node_types', array(
    'casetracker_basic_project',
  ))), array(
    spaces_gid(),
  )));
  while ($row = db_fetch_object($results)) {
    $return[$row->project_number] = $row->project_number . " - " . $row->title;
  }
  return $return;
}

/**
 * Build option array of users in the current group
 */
function spaces_casetracker_user_options() {
  $return = array();
  $result = db_query(og_list_users_sql(0), spaces_gid());
  while ($user = db_fetch_object($result)) {
    $return[$user->uid] = $user->name;
  }
  return $return;
}

/**
 * Autocomplete callback.  This should be moved into casetracker eventually.
 */
function spaces_casetracker_users_autocomplete($gid, $string) {
  $matches = array();
  $result = db_query_range("SELECT name FROM {users} u INNER JOIN {og_uid} og ON u.uid = og.uid WHERE og.nid = %d AND LOWER(u.name) LIKE LOWER('%s%%')", $gid, $string, 0, 10);
  while ($user = db_fetch_object($result)) {
    $matches[$user->name] = check_plain($user->name);
  }
  print drupal_to_js($matches);
  exit;
}

/**
 * Casetracker: produce case stats for a user.
 */
function spaces_casetracker_case_stats($uid, $gid = NULL) {
  $status_closed = 7;
  $status_open = 6;
  $week = time() - 7 * 24 * 3600;
  $args = array();

  // ASSIGNED
  if ($gid) {
    $args[] = $gid;
    $q = "SELECT COUNT(c.nid) AS count FROM {casetracker_case} c INNER JOIN {og_ancestry} og ON c.nid = og.nid WHERE og.group_nid = %d AND c.case_status_id = %d AND c.assign_to = %d";
  }
  else {
    $q = "SELECT COUNT(nid) AS count FROM {casetracker_case} WHERE case_status_id = %d AND assign_to = %d";
  }
  $stats['assigned']['total_open'] = db_result(db_query($q, array_merge($args, array(
    $status_open,
    $uid,
  ))));
  $stats['assigned']['total_closed'] = db_result(db_query($q, array_merge($args, array(
    $status_closed,
    $uid,
  ))));
  if ($gid) {
    $q = "SELECT COUNT(c.nid) AS count FROM {casetracker_case} c INNER JOIN {node} n ON c.nid = n.nid INNER JOIN {og_ancestry} og ON c.nid = og.nid WHERE og.group_nid = %d AND c.case_status_id = %d AND c.assign_to = %d AND n.created > %d";
  }
  else {
    $q = "SELECT COUNT(c.nid) AS count FROM {casetracker_case} c INNER JOIN {node} n ON c.nid = n.nid WHERE c.case_status_id = %d AND c.assign_to = %d AND n.created > %d";
  }
  $stats['assigned']['week_open'] = db_result(db_query($q, array_merge($args, array(
    $status_open,
    $uid,
    $week,
  ))));
  $stats['assigned']['week_closed'] = db_result(db_query($q, array_merge($args, array(
    $status_closed,
    $uid,
    $week,
  ))));

  // CREATED
  if ($gid) {
    $q = "SELECT COUNT(c.nid) AS count FROM {casetracker_case} c INNER JOIN {node} n ON c.nid = n.nid INNER JOIN {og_ancestry} og ON c.nid = og.nid WHERE og.group_nid = %d AND c.case_status_id = %d AND n.uid = %d";
  }
  else {
    $q = "SELECT COUNT(c.nid) AS count FROM {casetracker_case} c INNER JOIN {node} n ON c.nid = n.nid WHERE c.case_status_id = %d AND n.uid = %d";
  }
  $stats['created']['total_open'] = db_result(db_query($q, array_merge($args, array(
    $status_open,
    $uid,
  ))));
  $stats['created']['total_closed'] = db_result(db_query($q, array_merge($args, array(
    $status_closed,
    $uid,
  ))));
  $q .= " AND n.created > %d";
  $stats['created']['week_open'] = db_result(db_query($q, array_merge($args, array(
    $status_open,
    $uid,
    $week,
  ))));
  $stats['created']['week_closed'] = db_result(db_query($q, array_merge($args, array(
    $status_closed,
    $uid,
    $week,
  ))));
  if ($gid) {
    $q = "SELECT COUNT(c.case_type_id) AS count, cs.case_state_name AS name FROM {casetracker_case} c INNER JOIN {node} n ON c.nid = n.nid INNER JOIN {casetracker_case_states} cs ON c.case_type_id = cs.csid INNER JOIN {og_ancestry} og ON c.nid = og.nid WHERE og.group_nid = %d AND n.uid = %d GROUP BY c.case_type_id";
  }
  else {
    $q = "SELECT COUNT(c.case_type_id) AS count, cs.case_state_name AS name FROM {casetracker_case} c INNER JOIN {node} n ON c.nid = n.nid INNER JOIN {casetracker_case_states} cs ON c.case_type_id = cs.csid WHERE n.uid = %d GROUP BY c.case_type_id";
  }
  $result = db_query($q, array_merge($args, array(
    $uid,
  )));
  while ($type = db_fetch_array($result)) {
    $stats['created']['breakdown'][$type['name']] = $type['count'];
  }
  return $stats;
}

/*
 *  Theme out casestat counts
 */
function _spaces_casestats_count($label, $count) {
  $class = strtolower($label);
  return "<span class='count {$class}'>{$count}</span><span class='label'>{$label}</span>";
}

/*
 *  Theme out casestats
 */
function theme_spaces_casestats($stats, $username) {
  drupal_add_css(drupal_get_path('module', 'spaces') . '/spaces.css');
  $labels = array(
    array(
      'data' => t('Assigned to !user', array(
        '!user' => $username,
      )),
      'colspan' => 2,
      'class' => 'halfpoint',
    ),
    array(
      'data' => t('Created by !user', array(
        '!user' => $username,
      )),
      'colspan' => 2,
    ),
  );
  $rows[] = array(
    array(
      'data' => t('This Week'),
      'colspan' => 2,
      'class' => 'header halfpoint',
    ),
    array(
      'data' => t('This Week'),
      'colspan' => 2,
      'class' => 'header',
    ),
  );
  $rows[] = array(
    _spaces_casestats_count(t('Open'), $stats['assigned']['week_open']),
    array(
      'data' => _spaces_casestats_count(t('Closed'), $stats['assigned']['week_closed']),
      'class' => 'halfpoint',
    ),
    _spaces_casestats_count(t('Open'), $stats['created']['week_open']),
    _spaces_casestats_count(t('Closed'), $stats['created']['week_closed']),
  );
  $rows[] = array(
    array(
      'data' => t('Total'),
      'colspan' => 2,
      'class' => 'header halfpoint',
    ),
    array(
      'data' => t('Total'),
      'colspan' => 2,
      'class' => 'header',
    ),
  );
  $rows[] = array(
    _spaces_casestats_count(t('Open'), $stats['assigned']['total_open']),
    array(
      'data' => _spaces_casestats_count(t('Closed'), $stats['assigned']['total_closed']),
      'class' => 'halfpoint',
    ),
    _spaces_casestats_count(t('Open'), $stats['created']['total_open']),
    _spaces_casestats_count(t('Closed'), $stats['created']['total_closed']),
  );
  $o = theme('table', $labels, $rows, array(
    'class' => 'casestats',
  ));

  /*** Breakdown ***/
  if ($stats['created']['breakdown']) {
    $total = array_sum($stats['created']['breakdown']);
    foreach ($stats['created']['breakdown'] as $label => $count) {
      $pct = floor($count / $total * 1000) * 0.1;
      $breakdown[] = "<span class='pct'>{$pct}%</span> " . t('in') . " {$label}";
    }
    $breakdown = implode(', ', $breakdown) . ".";
    $breakdown = "<div class='case-breakdown'><span class='label'>" . t('Cases created:') . "</span>{$breakdown}</div>";
  }
  return $o . $breakdown;
}

/* VIEWS */
function _spaces_casetracker_views_cases() {
  $view = new stdClass();
  $view->name = 'spaces_cases';
  $view->description = t('A view of all cases by date.');
  $view->access = array();
  $view->view_args_php = '';
  $view->menu = TRUE;
  $view->menu_title = t('Cases');
  $view->page = TRUE;
  $view->page_title = t('Cases');
  $view->page_empty = '<?php print _spaces_views_empty("casetracker"); ?>';
  $view->page_empty_format = '2';
  $view->page_type = 'table';
  $view->url = 'cases';
  $view->use_pager = TRUE;
  $view->nodes_per_page = '50';
  $view->sort = array(
    array(
      'tablename' => 'casetracker_case',
      'field' => 'case_status_id',
      'sortorder' => 'ASC',
      'options' => 'normal',
    ),
  );
  $view->argument = array();
  $view->field = array(
    array(
      'tablename' => 'casetracker_case',
      'field' => 'pid',
      'label' => 'Project',
      'handler' => 'spaces_views_handler_crayon_name',
      'options' => 'casetracker',
      'sortable' => '1',
    ),
    array(
      'tablename' => 'node',
      'field' => 'title',
      'label' => 'Title',
      'handler' => 'views_handler_field_nodelink',
      'options' => 'link',
    ),
    array(
      'tablename' => 'casetracker_case',
      'field' => 'case_status_id',
      'label' => 'Status',
    ),
    array(
      'tablename' => 'casetracker_case',
      'field' => 'assign_to',
      'label' => 'Assigned',
      'sortable' => '1',
    ),
    array(
      'tablename' => 'casetracker_case',
      'field' => 'case_priority_id',
      'label' => 'Priority',
      'sortable' => '1',
    ),
    array(
      'tablename' => 'node',
      'field' => 'changed',
      'label' => 'Updated',
      'handler' => 'views_handler_field_date_small',
      'sortable' => '1',
      'defaultsort' => 'DESC',
    ),
  );
  $view->filter = array(
    array(
      'tablename' => 'node',
      'field' => 'type',
      'operator' => 'OR',
      'options' => '',
      'value' => array(
        0 => 'casetracker_basic_case',
      ),
    ),
    array(
      'tablename' => 'node',
      'field' => 'status',
      'operator' => '=',
      'options' => '',
      'value' => '1',
    ),
    array(
      'tablename' => 'og_ancestry',
      'field' => 'picg',
      'operator' => '=',
      'options' => '',
      'value' => '***CURRENT_GID***',
    ),
  );
  $view->exposed_filter = array();
  $view->requires = array(
    node,
    casetracker_case,
  );
  return $view;
}
function _spaces_casetracker_views_cases_recent() {
  $view = new stdClass();
  $view->name = 'spaces_cases_recent';
  $view->description = '';
  $view->view_args_php = 'return _spaces_views_arg_og_handler($args);';
  $view->access = array();
  $view->page = TRUE;
  $view->page_title = t('Recent Cases');
  $view->page_type = 'table';
  $view->url = 'recent-cases';
  $view->use_pager = TRUE;
  $view->nodes_per_page = '50';
  $view->block = TRUE;
  $view->block_title = t('Recent Cases');
  $view->block_empty = "<p class='views-empty'>" . t('No recent cases.') . "</p>";
  $view->block_empty_format = '1';
  $view->block_type = 'spaces_datetitle';
  $view->nodes_per_block = '5';
  $view->argument = array(
    array(
      'type' => 'gid',
      'argdefault' => '2',
    ),
  );
  $view->sort = array(
    array(
      'tablename' => 'node',
      'field' => 'created',
      'sortorder' => 'DESC',
      'options' => 'normal',
    ),
  );
  $view->field = array(
    array(
      'tablename' => 'og_node_data',
      'field' => 'title',
      'label' => 'Group',
      'handler' => 'spaces_views_handler_crayon_name',
      'options' => 'og',
    ),
    array(
      'tablename' => 'node',
      'field' => 'title',
      'label' => 'Case',
      'handler' => 'views_handler_field_nodelink',
      'options' => 'link',
    ),
    array(
      'tablename' => 'node',
      'field' => 'created',
      'label' => 'Created On',
      'handler' => 'views_handler_field_since',
      'options' => 1,
    ),
    array(
      'tablename' => 'casetracker_case',
      'field' => 'assign_to',
      'label' => 'Assigned To',
    ),
  );
  $view->filter = array(
    array(
      'tablename' => 'node',
      'field' => 'type',
      'operator' => 'OR',
      'options' => '',
      'value' => array(
        0 => 'casetracker_basic_case',
      ),
    ),
    array(
      'tablename' => 'node',
      'field' => 'status',
      'operator' => '=',
      'options' => '',
      'value' => '1',
      'defaultsort' => 'ASC',
    ),
    array(
      'tablename' => 'og_uid_node',
      'field' => 'currentuid',
      'operator' => '=',
      'options' => '',
      'value' => '***CURRENT_USER***',
    ),
    array(
      'tablename' => 'node',
      'field' => 'changed',
      'operator' => '>',
      'options' => -1 * SPACES_ARCHIVE_TIMESTAMP,
      'value' => 'now',
    ),
  );
  $view->exposed_filter = array();
  $view->requires = array(
    node,
    casetracker_case,
    og_node_data,
    og_uid_node,
  );
  return $view;
}
function _spaces_casetracker_views_cases_bystatus() {
  $view = new stdClass();
  $view->name = 'spaces_cases_bystatus';
  $view->description = t('Filter cases by status.');
  $view->access = array();
  $view->view_args_php = '';
  $view->menu = TRUE;
  $view->menu_title = t('Cases by status');
  $view->page = TRUE;
  $view->page_title = t('Cases by status');
  $view->page_empty = '<?php print _spaces_views_empty("casetracker"); ?>';
  $view->page_empty_format = '2';
  $view->page_type = 'table';
  $view->url = 'cases/by-status';
  $view->use_pager = TRUE;
  $view->nodes_per_page = '25';
  $view->argument = array();
  $view->sort = array(
    array(
      'tablename' => 'casetracker_case',
      'field' => 'case_status_id',
      'sortorder' => 'ASC',
      'options' => 'normal',
    ),
  );
  $view->field = array(
    array(
      'tablename' => 'casetracker_case',
      'field' => 'pid',
      'label' => 'Project',
      'handler' => 'spaces_views_handler_crayon_name',
      'options' => 'casetracker',
      'sortable' => '1',
    ),
    array(
      'tablename' => 'node',
      'field' => 'title',
      'label' => 'Title',
      'handler' => 'views_handler_field_nodelink',
      'options' => 'link',
    ),
    array(
      'tablename' => 'casetracker_case',
      'field' => 'case_status_id',
      'label' => 'Status',
    ),
    array(
      'tablename' => 'casetracker_case',
      'field' => 'assign_to',
      'label' => 'Assigned',
      'sortable' => '1',
    ),
    array(
      'tablename' => 'casetracker_case',
      'field' => 'case_priority_id',
      'label' => 'Priority',
      'sortable' => '1',
    ),
    array(
      'tablename' => 'node',
      'field' => 'changed',
      'label' => 'Updated',
      'handler' => 'views_handler_field_date_small',
      'sortable' => '1',
      'defaultsort' => 'DESC',
    ),
  );
  $view->filter = array(
    array(
      'tablename' => 'node',
      'field' => 'status',
      'operator' => '=',
      'options' => '',
      'value' => '1',
    ),
    array(
      'tablename' => 'node',
      'field' => 'type',
      'operator' => 'OR',
      'options' => '',
      'value' => array(
        0 => 'casetracker_basic_case',
      ),
    ),
    array(
      'tablename' => 'casetracker_case',
      'field' => 'case_status_id',
      'operator' => 'OR',
      'options' => '',
      'value' => array(
        0 => '6',
      ),
    ),
    array(
      'tablename' => 'og_ancestry',
      'field' => 'picg',
      'operator' => '=',
      'options' => '',
      'value' => '***CURRENT_GID***',
    ),
  );
  $view->exposed_filter = array(
    array(
      'tablename' => 'casetracker_case',
      'field' => 'case_status_id',
      'label' => t('Status'),
      'optional' => '0',
      'is_default' => '1',
      'operator' => '1',
      'single' => '1',
    ),
  );
  $view->requires = array(
    node,
    casetracker_case,
  );
  return $view;
}
function _spaces_casetracker_views_cases_byuser() {
  $view = new stdClass();
  $view->name = 'spaces_cases_byuser';
  $view->description = t('Filter cases by user.');
  $view->access = array();
  $view->view_args_php = '';
  $view->menu = TRUE;
  $view->menu_title = t('Cases by user');
  $view->page = TRUE;
  $view->page_title = t('Cases by user');
  $view->page_empty = '<?php print _spaces_views_empty("casetracker"); ?>';
  $view->page_empty_format = '2';
  $view->page_type = 'table';
  $view->url = 'cases/by-user';
  $view->use_pager = TRUE;
  $view->nodes_per_page = '25';
  $view->argument = array();
  $view->sort = array(
    array(
      'tablename' => 'casetracker_case',
      'field' => 'case_status_id',
      'sortorder' => 'ASC',
      'options' => 'normal',
    ),
  );
  $view->field = array(
    array(
      'tablename' => 'casetracker_case',
      'field' => 'pid',
      'label' => 'Project',
      'handler' => 'spaces_views_handler_crayon_name',
      'options' => 'casetracker',
      'sortable' => '1',
    ),
    array(
      'tablename' => 'node',
      'field' => 'title',
      'label' => 'Title',
      'handler' => 'views_handler_field_nodelink',
      'options' => 'link',
    ),
    array(
      'tablename' => 'casetracker_case',
      'field' => 'case_status_id',
      'label' => 'Status',
    ),
    array(
      'tablename' => 'casetracker_case',
      'field' => 'assign_to',
      'label' => 'Assigned',
    ),
    array(
      'tablename' => 'casetracker_case',
      'field' => 'case_priority_id',
      'label' => 'Priority',
      'sortable' => '1',
    ),
    array(
      'tablename' => 'node',
      'field' => 'changed',
      'label' => 'Updated',
      'handler' => 'views_handler_field_date_small',
      'sortable' => '1',
      'defaultsort' => 'DESC',
    ),
  );
  $view->filter = array(
    array(
      'tablename' => 'node',
      'field' => 'status',
      'operator' => '=',
      'options' => '',
      'value' => '1',
    ),
    array(
      'tablename' => 'node',
      'field' => 'type',
      'operator' => 'OR',
      'options' => '',
      'value' => array(
        0 => 'casetracker_basic_case',
      ),
    ),
    array(
      'tablename' => 'casetracker_case',
      'field' => 'assign_to',
      'operator' => 'OR',
      'options' => '',
      'value' => array(
        0 => '29',
      ),
    ),
    array(
      'tablename' => 'og_ancestry',
      'field' => 'picg',
      'operator' => '=',
      'options' => '',
      'value' => '***CURRENT_GID***',
    ),
  );
  $view->exposed_filter = array(
    array(
      'tablename' => 'casetracker_case',
      'field' => 'assign_to',
      'label' => 'User',
      'optional' => '0',
      'is_default' => '0',
      'operator' => '1',
      'single' => '1',
    ),
  );
  $view->requires = array(
    node,
    casetracker_case,
  );
  return $view;
}
function _spaces_casetracker_views_cases_my() {
  $view = new stdClass();
  $view->name = 'spaces_cases_my';
  $view->description = 'My cases';
  $view->access = array();
  $view->view_args_php = '';
  $view->menu = TRUE;
  $view->menu_title = t('My cases');
  $view->page = TRUE;
  $view->page_title = 'My cases';
  $view->page_empty = '<?php print _spaces_views_empty("casetracker"); ?>';
  $view->page_empty_format = '2';
  $view->page_type = 'table';
  $view->url = 'cases/my';
  $view->use_pager = TRUE;
  $view->nodes_per_page = '25';
  $view->argument = array();
  $view->sort = array(
    array(
      'tablename' => 'casetracker_case',
      'field' => 'case_status_id',
      'sortorder' => 'ASC',
      'options' => 'normal',
    ),
  );
  $view->field = array(
    array(
      'tablename' => 'casetracker_case',
      'field' => 'pid',
      'label' => 'Project',
      'handler' => 'spaces_views_handler_crayon_name',
      'options' => 'casetracker',
      'sortable' => '1',
    ),
    array(
      'tablename' => 'node',
      'field' => 'title',
      'label' => 'Title',
      'handler' => 'views_handler_field_nodelink',
      'options' => 'link',
    ),
    array(
      'tablename' => 'casetracker_case',
      'field' => 'case_status_id',
      'label' => 'Status',
    ),
    array(
      'tablename' => 'casetracker_case',
      'field' => 'assign_to',
      'label' => 'Assigned',
    ),
    array(
      'tablename' => 'casetracker_case',
      'field' => 'case_priority_id',
      'label' => 'Priority',
      'sortable' => '1',
    ),
    array(
      'tablename' => 'node',
      'field' => 'changed',
      'label' => 'Updated',
      'handler' => 'views_handler_field_date_small',
      'sortable' => '1',
      'defaultsort' => 'DESC',
    ),
  );
  $view->filter = array(
    array(
      'tablename' => 'node',
      'field' => 'status',
      'operator' => '=',
      'options' => '',
      'value' => '1',
    ),
    array(
      'tablename' => 'casetracker_case',
      'field' => 'assign_to_currentuid',
      'operator' => '=',
      'options' => '',
      'value' => '***CURRENT_USER***',
    ),
    array(
      'tablename' => 'casetracker_project',
      'field' => 'project_number',
      'operator' => 'OR',
      'options' => '',
      'value' => array(
        0 => '100',
      ),
    ),
    array(
      'tablename' => 'og_ancestry',
      'field' => 'picg',
      'operator' => '=',
      'options' => '',
      'value' => '***CURRENT_GID***',
    ),
  );
  $view->exposed_filter = array(
    array(
      'tablename' => 'casetracker_project',
      'field' => 'project_number',
      'label' => 'Project',
      'optional' => '1',
      'is_default' => '0',
      'operator' => '1',
      'single' => '1',
    ),
  );
  $view->requires = array(
    node,
    casetracker_case,
  );
  return $view;
}
function _spaces_casetracker_views_cases_myblock() {
  $view = new stdClass();
  $view->name = 'spaces_cases_myblock';
  $view->description = t('Provides a block listing of cases assigned to current user.');
  $view->access = array();
  $view->view_args_php = '';
  $view->page = FALSE;
  $view->block = TRUE;
  $view->block_title = t('My Cases');
  $view->block_empty = "<p class='views-empty'>" . t('No cases found.') . "</p>";
  $view->block_empty_format = '2';
  $view->block_type = 'spaces_datetitle';
  $view->nodes_per_block = '10';
  $view->sort = array(
    array(
      'tablename' => 'node_comment_statistics',
      'field' => 'last_comment_timestamp',
      'sortorder' => 'DESC',
      'options' => 'normal',
    ),
  );
  $view->argument = array();
  $view->field = array(
    array(
      'tablename' => 'node_comment_statistics',
      'field' => 'last_comment_timestamp',
      'label' => '',
      'handler' => 'views_handler_field_since',
      'options' => 1,
    ),
    array(
      'tablename' => 'node',
      'field' => 'title',
      'label' => '',
      'handler' => 'views_handler_field_nodelink',
      'options' => 'link',
    ),
    array(
      'tablename' => 'users',
      'field' => 'name',
      'label' => t('Author'),
    ),
  );
  $view->filter = array(
    array(
      'tablename' => 'casetracker_case',
      'field' => 'assign_to_currentuid',
      'operator' => '=',
      'options' => '',
      'value' => '***CURRENT_USER***',
    ),
    array(
      'tablename' => 'casetracker_case',
      'field' => 'case_status_id',
      'operator' => 'OR',
      'options' => '',
      'value' => array(
        0 => '6',
        1 => '8',
        2 => '9',
        3 => '10',
      ),
    ),
    array(
      'tablename' => 'og_ancestry',
      'field' => 'picg',
      'operator' => '=',
      'options' => '',
      'value' => '***CURRENT_GID***',
    ),
  );
  $view->exposed_filter = array();
  $view->requires = array(
    node_comment_statistics,
    node,
    casetracker_case,
  );
  return $view;
}
function _spaces_casetracker_views_cases_byproject() {
  $view = new stdClass();
  $view->name = 'spaces_cases_byproject';
  $view->description = t('Filter cases by project.');
  $view->access = array();
  $view->view_args_php = '';
  $view->menu = TRUE;
  $view->menu_title = t('Cases by project');
  $view->page = TRUE;
  $view->page_title = 'Cases by project';
  $view->page_empty = '<?php print _spaces_views_empty("casetracker"); ?>';
  $view->page_empty_format = '2';
  $view->page_type = 'table';
  $view->url = 'cases/by-project';
  $view->use_pager = TRUE;
  $view->nodes_per_page = '25';
  $view->argument = array();
  $view->sort = array(
    array(
      'tablename' => 'casetracker_case',
      'field' => 'case_status_id',
      'sortorder' => 'ASC',
      'options' => 'normal',
    ),
  );
  $view->field = array(
    array(
      'tablename' => 'casetracker_case',
      'field' => 'pid',
      'label' => 'Project',
      'handler' => 'spaces_views_handler_crayon_name',
      'options' => 'casetracker',
    ),
    array(
      'tablename' => 'node',
      'field' => 'title',
      'label' => 'Title',
      'handler' => 'views_handler_field_nodelink',
      'options' => 'link',
    ),
    array(
      'tablename' => 'casetracker_case',
      'field' => 'case_status_id',
      'label' => 'Status',
    ),
    array(
      'tablename' => 'casetracker_case',
      'field' => 'assign_to',
      'label' => 'Assigned',
      'sortable' => '1',
    ),
    array(
      'tablename' => 'casetracker_case',
      'field' => 'case_priority_id',
      'label' => 'Priority',
      'sortable' => '1',
    ),
    array(
      'tablename' => 'node',
      'field' => 'changed',
      'label' => 'Updated',
      'handler' => 'views_handler_field_date_small',
      'sortable' => '1',
      'defaultsort' => 'DESC',
    ),
  );
  $view->filter = array(
    array(
      'tablename' => 'node',
      'field' => 'status',
      'operator' => '=',
      'options' => '',
      'value' => '1',
    ),
    array(
      'tablename' => 'node',
      'field' => 'type',
      'operator' => 'OR',
      'options' => '',
      'value' => array(
        0 => 'casetracker_basic_case',
      ),
    ),
    array(
      'tablename' => 'casetracker_project',
      'field' => 'project_number',
      'operator' => 'OR',
      'options' => '',
      'value' => array(
        0 => '100',
      ),
    ),
    array(
      'tablename' => 'og_ancestry',
      'field' => 'picg',
      'operator' => '=',
      'options' => '',
      'value' => '***CURRENT_GID***',
    ),
  );
  $view->exposed_filter = array(
    array(
      'tablename' => 'casetracker_project',
      'field' => 'project_number',
      'label' => 'Project',
      'optional' => '0',
      'is_default' => '1',
      'operator' => '1',
      'single' => '1',
    ),
  );
  $view->requires = array(
    node,
    casetracker_case,
    casetracker_project,
  );
  return $view;
}
function _spaces_casetracker_views_cases_mycreated() {
  $view = new stdClass();
  $view->name = 'spaces_cases_mycreated';
  $view->description = t('A view of all cases made by the current user.');
  $view->access = array();
  $view->view_args_php = '';
  $view->menu = TRUE;
  $view->menu_title = t('Created by me');
  $view->page = TRUE;
  $view->page_title = t('Created by me');
  $view->page_empty = '<?php print _spaces_views_empty("casetracker"); ?>';
  $view->page_empty_format = '2';
  $view->page_type = 'table';
  $view->url = 'cases/mycreated';
  $view->use_pager = TRUE;
  $view->nodes_per_page = '50';
  $view->argument = array();
  $view->sort = array(
    array(
      'tablename' => 'casetracker_case',
      'field' => 'case_status_id',
      'sortorder' => 'ASC',
      'options' => 'normal',
    ),
  );
  $view->field = array(
    array(
      'tablename' => 'casetracker_case',
      'field' => 'pid',
      'label' => 'Project',
      'handler' => 'spaces_views_handler_crayon_name',
      'options' => 'casetracker',
      'sortable' => '1',
    ),
    array(
      'tablename' => 'node',
      'field' => 'title',
      'label' => 'Title',
      'handler' => 'views_handler_field_nodelink',
      'options' => 'link',
    ),
    array(
      'tablename' => 'casetracker_case',
      'field' => 'case_status_id',
      'label' => 'Status',
    ),
    array(
      'tablename' => 'casetracker_case',
      'field' => 'assign_to',
      'label' => 'Assigned',
      'sortable' => '1',
    ),
    array(
      'tablename' => 'casetracker_case',
      'field' => 'case_priority_id',
      'label' => 'Priority',
      'sortable' => '1',
    ),
    array(
      'tablename' => 'node',
      'field' => 'changed',
      'label' => 'Updated',
      'handler' => 'views_handler_field_date_small',
      'sortable' => '1',
      'defaultsort' => 'DESC',
    ),
  );
  $view->filter = array(
    array(
      'tablename' => 'node',
      'field' => 'type',
      'operator' => 'OR',
      'options' => '',
      'value' => array(
        0 => 'casetracker_basic_case',
      ),
    ),
    array(
      'tablename' => 'node',
      'field' => 'status',
      'operator' => '=',
      'options' => '',
      'value' => '1',
    ),
    array(
      'tablename' => 'node',
      'field' => 'currentuid',
      'operator' => '=',
      'options' => '',
      'value' => '***CURRENT_USER***',
    ),
    array(
      'tablename' => 'casetracker_project',
      'field' => 'project_number',
      'operator' => 'OR',
      'options' => '',
      'value' => array(
        0 => '100',
      ),
    ),
    array(
      'tablename' => 'og_ancestry',
      'field' => 'picg',
      'operator' => '=',
      'options' => '',
      'value' => '***CURRENT_GID***',
    ),
  );
  $view->exposed_filter = array(
    array(
      'tablename' => 'casetracker_project',
      'field' => 'project_number',
      'label' => 'Project',
      'optional' => '1',
      'is_default' => '0',
      'operator' => '1',
      'single' => '1',
    ),
  );
  $view->requires = array(
    node,
    casetracker_case,
  );
  return $view;
}
function _spaces_casetracker_views_cases_filter() {
  $view = new stdClass();
  $view->name = 'spaces_cases_filter';
  $view->description = t('A massive case filter form.');
  $view->access = array();
  $view->view_args_php = '';
  $view->menu = TRUE;
  $view->menu_title = t('Cases filter');
  $view->page = TRUE;
  $view->page_title = t('Cases filter');
  $view->page_empty = '<?php print _spaces_views_empty("casetracker"); ?>';
  $view->page_empty_format = '2';
  $view->page_type = 'table';
  $view->url = 'cases/filter';
  $view->use_pager = TRUE;
  $view->nodes_per_page = '100';
  $view->argument = array();
  $view->sort = array(
    array(
      'tablename' => 'casetracker_case',
      'field' => 'case_status_id',
      'sortorder' => 'ASC',
      'options' => 'normal',
    ),
  );
  $view->field = array(
    array(
      'tablename' => 'casetracker_case',
      'field' => 'pid',
      'label' => 'Project',
      'handler' => 'spaces_views_handler_crayon_name',
      'options' => 'casetracker',
      'sortable' => '1',
    ),
    array(
      'tablename' => 'node',
      'field' => 'title',
      'label' => 'Title',
      'handler' => 'views_handler_field_nodelink',
      'options' => 'link',
    ),
    array(
      'tablename' => 'casetracker_case',
      'field' => 'case_status_id',
      'label' => 'Status',
    ),
    array(
      'tablename' => 'casetracker_case',
      'field' => 'assign_to',
      'label' => 'Assigned',
      'sortable' => '1',
    ),
    array(
      'tablename' => 'casetracker_case',
      'field' => 'case_priority_id',
      'label' => 'Priority',
      'sortable' => '1',
    ),
    array(
      'tablename' => 'node',
      'field' => 'changed',
      'label' => 'Updated',
      'handler' => 'views_handler_field_date_small',
      'sortable' => '1',
      'defaultsort' => 'DESC',
    ),
  );
  $view->filter = array(
    array(
      'tablename' => 'node',
      'field' => 'type',
      'operator' => 'OR',
      'options' => '',
      'value' => array(
        0 => 'casetracker_basic_case',
      ),
    ),
    array(
      'tablename' => 'node',
      'field' => 'status',
      'operator' => '=',
      'options' => '',
      'value' => '1',
    ),
    array(
      'tablename' => 'casetracker_project',
      'field' => 'project_number',
      'operator' => 'OR',
      'options' => '',
      'value' => array(
        0 => '100',
      ),
    ),
    array(
      'tablename' => 'casetracker_case',
      'field' => 'assign_to',
      'operator' => 'OR',
      'options' => '',
      'value' => array(
        0 => '1',
      ),
    ),
    array(
      'tablename' => 'casetracker_case',
      'field' => 'case_type_id',
      'operator' => 'OR',
      'options' => '',
      'value' => array(
        0 => '11',
      ),
    ),
    array(
      'tablename' => 'casetracker_case',
      'field' => 'case_priority_id',
      'operator' => 'OR',
      'options' => '',
      'value' => array(
        0 => '1',
      ),
    ),
    array(
      'tablename' => 'casetracker_case',
      'field' => 'case_status_id',
      'operator' => 'OR',
      'options' => '',
      'value' => array(
        0 => '6',
      ),
    ),
    array(
      'tablename' => 'og_ancestry',
      'field' => 'picg',
      'operator' => '=',
      'options' => '',
      'value' => '***CURRENT_GID***',
    ),
  );
  $view->exposed_filter = array(
    array(
      'tablename' => 'casetracker_project',
      'field' => 'project_number',
      'label' => 'Project',
      'optional' => '1',
      'is_default' => '0',
      'operator' => '1',
      'single' => '0',
    ),
    array(
      'tablename' => 'casetracker_case',
      'field' => 'assign_to',
      'label' => 'For',
      'optional' => '1',
      'is_default' => '0',
      'operator' => '1',
      'single' => '0',
    ),
    array(
      'tablename' => 'casetracker_case',
      'field' => 'case_type_id',
      'label' => 'Type',
      'optional' => '1',
      'is_default' => '0',
      'operator' => '1',
      'single' => '0',
    ),
    array(
      'tablename' => 'casetracker_case',
      'field' => 'case_priority_id',
      'label' => 'Priority',
      'optional' => '1',
      'is_default' => '0',
      'operator' => '1',
      'single' => '0',
    ),
    array(
      'tablename' => 'casetracker_case',
      'field' => 'case_status_id',
      'label' => 'Status',
      'optional' => '1',
      'is_default' => '0',
      'operator' => '1',
      'single' => '0',
    ),
  );
  $view->requires = array(
    node,
    casetracker_case,
    casetracker_project,
  );
  return $view;
}
function _spaces_casetracker_views_cases_projects() {
  $view = new stdClass();
  $view->name = 'spaces_cases_projects';
  $view->description = t('A listing of all projects.');
  $view->access = array();
  $view->view_args_php = '';
  $view->menu = TRUE;
  $view->menu_title = t('Projects');
  $view->page = TRUE;
  $view->page_title = t('Projects');
  $view->page_empty = '<?php print _spaces_views_empty("casetracker"); ?>';
  $view->page_empty_format = '2';
  $view->page_type = 'table';
  $view->url = 'cases/projects';
  $view->use_pager = TRUE;
  $view->nodes_per_page = '99';
  $view->argument = array();
  $view->sort = array(
    array(
      'tablename' => 'node',
      'field' => 'title',
      'sortorder' => 'ASC',
      'options' => '',
    ),
  );
  $view->field = array(
    array(
      'tablename' => 'node',
      'field' => 'title',
      'label' => 'Project',
      'handler' => 'views_handler_field_nodelink',
      'options' => 'link',
    ),
    array(
      'tablename' => 'node',
      'field' => 'created',
      'label' => '',
      'handler' => 'views_handler_field_date_custom',
      'options' => 'F j, Y',
    ),
    array(
      'tablename' => 'casetracker_case_node',
      'field' => 'nid',
      'label' => '',
    ),
  );
  $view->filter = array(
    array(
      'tablename' => 'node',
      'field' => 'status',
      'operator' => '=',
      'options' => '',
      'value' => '1',
    ),
    array(
      'tablename' => 'node',
      'field' => 'type',
      'operator' => 'OR',
      'options' => '',
      'value' => array(
        0 => 'casetracker_basic_project',
      ),
    ),
    array(
      'tablename' => 'og_ancestry',
      'field' => 'picg',
      'operator' => '=',
      'options' => '',
      'value' => '***CURRENT_GID***',
    ),
  );
  $view->exposed_filter = array();
  $view->requires = array(
    node,
    casetracker_case_node,
  );
  return $view;
}

Functions

Name	Description
spaces_casetracker_block	Implementation of hook_block()
spaces_casetracker_case_stats	Casetracker: produce case stats for a user.
spaces_casetracker_context_define	hook_context_define()
spaces_casetracker_form_alter	Implementation of hook_form_alter()
spaces_casetracker_help	Implementation of hook_help()
spaces_casetracker_menu	Implementation of hook_menu()
spaces_casetracker_project_options	Build option array of project id's for the current group.
spaces_casetracker_users_autocomplete	Autocomplete callback. This should be moved into casetracker eventually.
spaces_casetracker_user_options	Build option array of users in the current group
spaces_casetracker_views_default_views	Implementation of hook_default_views
spaces_casetracker_views_post_view
theme_spaces_casestats
_spaces_casestats_count
_spaces_casetracker_views
_spaces_casetracker_views_cases
_spaces_casetracker_views_cases_byproject
_spaces_casetracker_views_cases_bystatus
_spaces_casetracker_views_cases_byuser
_spaces_casetracker_views_cases_filter
_spaces_casetracker_views_cases_my
_spaces_casetracker_views_cases_myblock
_spaces_casetracker_views_cases_mycreated
_spaces_casetracker_views_cases_projects
_spaces_casetracker_views_cases_recent