View source
<?php
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;
}
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>";
}
}
}
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);
$space = spaces_get_space();
$block['subject'] = t('Case Stats for @user', array(
'@user' => $u->name,
));
$block['content'] = theme('spaces_casestats', spaces_casetracker_case_stats(arg(1), $space->sid), $u->name);
return $block;
}
}
}
}
function spaces_casetracker_form_alter($form_id, &$form) {
switch ($form_id) {
case 'casetracker_basic_case_node_form':
case 'comment_form':
if ($form_id == 'casetracker_basic_case_node_form') {
$form['batch'] = array(
'#type' => 'submit',
'#value' => t('Submit + create another'),
'#weight' => 50,
);
$form['#submit']['_spaces_casetracker_node_form_submit'] = array();
array_reverse($form['#submit']);
}
$space = spaces_get_space();
if (isset($form['casetracker_project_information'])) {
$pid = $form_id == 'casetracker_basic_case_node_form' ? 'pid' : 'prid';
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 (!array_key_exists($space->sid, $groups)) {
unset($form['casetracker_project_information'][$pid]['#options'][$key]);
}
}
}
}
$form['casetracker_case_information']['assign_to']['#autocomplete_path'] = 'spaces/team/autocomplete/' . $space->sid;
break;
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;
}
}
function _spaces_casetracker_node_form_submit($form_id, $form_values) {
if (trim($form_values['op']) == t('Submit + create another')) {
$query = array();
if (module_exists('prepopulate')) {
if (isset($form_values['assign_to'])) {
$query[] = 'edit[casetracker_case_information][assign_to]=' . $form_values['assign_to'];
}
if (isset($form_values['pid'])) {
$query[] = 'edit[casetracker_project_information][pid]=' . $form_values['pid'];
}
}
$query = implode('&', $query);
drupal_goto('node/add/casetracker-basic-case', $query);
}
}
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',
);
if (module_exists('spaces_user')) {
$default_views[] = '_spaces_casetracker_views_user_cases';
$default_views[] = '_spaces_casetracker_views_user_cases_created';
}
foreach ($default_views as $v) {
$view = call_user_func($v);
if (is_object($view) && $view->name) {
$views[$view->name] = $view;
}
}
return $views;
}
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,
),
),
'spaces' => array(
'label' => t('Casetracker'),
'description' => t('A casetracker for managing projects.'),
'types' => array(
'og',
),
'menu' => array(
'cases' => array(
'title' => t('Casetracker'),
),
'cases/my' => array(
'title' => t('My cases'),
),
'cases/mycreated' => array(
'title' => t('Created by me'),
),
'cases/projects' => array(
'title' => t('Projects'),
),
'cases/filter' => array(
'title' => t('Cases filter'),
),
'cases/by-status' => array(
'title' => t('Cases by status'),
),
'cases/by-project' => array(
'title' => t('Cases by project'),
),
'cases/by-user' => array(
'title' => t('Cases by user'),
),
),
),
);
if (module_exists('spaces_user')) {
$items[] = array(
'namespace' => 'spaces',
'attribute' => 'feature',
'value' => 'user_cases',
'node' => array(
'casetracker_basic_case',
),
'views' => array(
'spaces_user_cases',
'spaces_user_cases_created',
),
'block' => array(),
'spaces' => array(
'label' => t('Cases'),
'description' => t('Shows cases authored by and assigned to a user.'),
'types' => array(
'user',
),
'menu' => array(
'user-cases' => array(
'title' => t('Cases'),
),
'user-cases/created' => array(
'title' => t('Created cases'),
),
),
),
);
}
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',
);
}
function spaces_casetracker_views_pre_query(&$view) {
if ($view->name == 'spaces_user_cases') {
$space = spaces_get_space();
if ($space && $space->type == 'user') {
foreach ($view->filter as $k => $filter) {
if ($filter['field'] == 'casetracker_case.assign_to') {
$view->filter[$k]['value'] = array(
$space->sid,
);
$view->is_cacheable = false;
break;
}
}
}
}
}
function spaces_casetracker_views_post_view(&$view) {
if ($view->build_type == 'page' && in_array($view->name, _spaces_casetracker_views())) {
context_set('theme', 'layout', 'wide');
}
}
function spaces_casetracker_project_options() {
if ($space = spaces_get_space()) {
$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(
$space->sid,
)));
while ($row = db_fetch_object($results)) {
$return[$row->project_number] = $row->project_number . " - " . $row->title;
}
return $return;
}
}
function spaces_casetracker_user_options() {
$users = array();
foreach (spaces_og_get_users() as $account) {
$users[$account->uid] = $account->name;
}
return $users;
}
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;
}
function spaces_casetracker_case_stats($uid, $gid = NULL) {
$status_closed = 7;
$status_open = 6;
$week = time() - 7 * 24 * 3600;
$args = array();
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,
))));
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;
}
function _spaces_casestats_count($label, $count) {
$class = strtolower($label);
return "<span class='count {$class}'>{$count}</span><span class='label'>{$label}</span>";
}
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',
));
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;
}
function _spaces_casetracker_views_base() {
$view = new stdClass();
$view->access = array();
$view->view_args_php = '';
$view->menu = FALSE;
$view->page = TRUE;
$view->page_empty = '<?php print _spaces_views_empty("casetracker"); ?>';
$view->page_empty_format = '2';
$view->page_type = 'table';
$view->use_pager = TRUE;
$view->nodes_per_page = '50';
$view->sort = array();
$view->argument = array();
$view->field = array(
'project' => array(
'tablename' => 'casetracker_case',
'field' => 'pid',
'label' => 'Project',
'handler' => 'spaces_views_handler_crayon_name',
'options' => 'casetracker',
'sortable' => '1',
),
'title' => array(
'tablename' => 'node',
'field' => 'title',
'label' => 'Title',
'handler' => 'views_handler_field_nodelink',
'options' => 'link',
),
'status' => array(
'tablename' => 'casetracker_case',
'field' => 'case_status_id',
'label' => 'Status',
),
'assigned' => array(
'tablename' => 'casetracker_case',
'field' => 'assign_to',
'label' => 'Assigned',
'sortable' => '1',
),
'priority' => array(
'tablename' => 'casetracker_case',
'field' => 'case_priority_id',
'label' => 'Priority',
'sortable' => '1',
),
'changed' => array(
'tablename' => 'node',
'field' => 'changed',
'label' => 'Updated',
'handler' => 'views_handler_field_date_small',
'sortable' => '1',
'defaultsort' => 'DESC',
),
);
$view->filter = array(
'type' => array(
'tablename' => 'node',
'field' => 'type',
'operator' => 'OR',
'options' => '',
'value' => array(
0 => 'casetracker_basic_case',
),
),
'status' => array(
'tablename' => 'node',
'field' => 'status',
'operator' => '=',
'options' => '',
'value' => '1',
),
'spaces' => array(
'tablename' => 'spaces',
'field' => 'type',
'operator' => 'all',
'options' => '',
'value' => 'all',
),
);
$view->exposed_filter = array();
$view->requires = array(
node,
casetracker_case,
);
return $view;
}
function _spaces_casetracker_views_cases() {
$view = _spaces_casetracker_views_base();
$view->name = 'spaces_cases';
$view->description = t('Spaces > Casetracker');
$view->menu = TRUE;
$view->menu_title = t('Cases');
$view->page = TRUE;
$view->page_title = t('Cases');
$view->url = 'cases';
$view->sort = array(
array(
'tablename' => 'casetracker_case',
'field' => 'case_status_id',
'sortorder' => 'ASC',
'options' => 'normal',
),
);
return $view;
}
function _spaces_casetracker_views_cases_recent() {
$view = _spaces_casetracker_views_base();
$view->name = 'spaces_cases_recent';
$view->description = t('Spaces > Casetracker > Recent cases');
$view->page = TRUE;
$view->page_title = t('Recent Cases');
$view->url = 'recent-cases';
$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->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['og'] = array(
'tablename' => 'og_uid_node',
'field' => 'currentuid',
'operator' => '=',
'options' => '',
'value' => '***CURRENT_USER***',
);
$view->filter['spaces']['operator'] = 'active';
$view->filter['changed'] = array(
'tablename' => 'node',
'field' => 'changed',
'operator' => '>',
'options' => -1 * SPACES_ARCHIVE_TIMESTAMP,
'value' => 'now',
);
$view->requires = array(
node,
casetracker_case,
og_node_data,
og_uid_node,
);
return $view;
}
function _spaces_casetracker_views_cases_bystatus() {
$view = _spaces_casetracker_views_base();
$view->name = 'spaces_cases_bystatus';
$view->description = t('Filter cases by status.');
$view->menu = TRUE;
$view->menu_title = t('Cases by status');
$view->page = TRUE;
$view->page_title = t('Cases by status');
$view->url = 'cases/by-status';
$view->sort = array(
array(
'tablename' => 'casetracker_case',
'field' => 'case_status_id',
'sortorder' => 'ASC',
'options' => 'normal',
),
);
$view->filter['status_id'] = array(
'tablename' => 'casetracker_case',
'field' => 'case_status_id',
'operator' => 'OR',
'options' => '',
'value' => array(
0 => '6',
),
);
$view->exposed_filter = array(
array(
'tablename' => 'casetracker_case',
'field' => 'case_status_id',
'label' => t('Status'),
'optional' => '0',
'is_default' => '1',
'operator' => '1',
'single' => '1',
),
);
return $view;
}
function _spaces_casetracker_views_cases_byuser() {
$view = _spaces_casetracker_views_base();
$view->name = 'spaces_cases_byuser';
$view->description = t('Filter cases by user.');
$view->menu = TRUE;
$view->menu_title = t('Cases by user');
$view->page = TRUE;
$view->page_title = t('Cases by user');
$view->url = 'cases/by-user';
$view->sort = array(
array(
'tablename' => 'casetracker_case',
'field' => 'case_status_id',
'sortorder' => 'ASC',
'options' => 'normal',
),
);
$view->filter['assign'] = array(
'tablename' => 'casetracker_case',
'field' => 'assign_to',
'operator' => 'OR',
'options' => '',
'value' => array(
0 => '29',
),
);
$view->exposed_filter = array(
array(
'tablename' => 'casetracker_case',
'field' => 'assign_to',
'label' => 'User',
'optional' => '0',
'is_default' => '0',
'operator' => '1',
'single' => '1',
),
);
return $view;
}
function _spaces_casetracker_views_cases_my() {
$view = _spaces_casetracker_views_base();
$view->name = 'spaces_cases_my';
$view->description = 'My cases';
$view->menu = TRUE;
$view->menu_title = t('My cases');
$view->page = TRUE;
$view->page_title = 'My cases';
$view->page_type = 'table';
$view->url = 'cases/my';
$view->sort = array(
array(
'tablename' => 'casetracker_case',
'field' => 'case_status_id',
'sortorder' => 'ASC',
'options' => 'normal',
),
);
$view->filter['user'] = array(
'tablename' => 'casetracker_case',
'field' => 'assign_to_currentuid',
'operator' => '=',
'options' => '',
'value' => '***CURRENT_USER***',
);
$view->filter['project'] = array(
'tablename' => 'casetracker_project',
'field' => 'project_number',
'operator' => 'OR',
'options' => '',
'value' => array(
0 => '100',
),
);
$view->exposed_filter = array(
array(
'tablename' => 'casetracker_project',
'field' => 'project_number',
'label' => 'Project',
'optional' => '1',
'is_default' => '0',
'operator' => '1',
'single' => '1',
),
);
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' => 'spaces',
'field' => 'type',
'operator' => 'all',
'options' => '',
'value' => 'all',
),
);
$view->exposed_filter = array();
$view->requires = array(
node_comment_statistics,
node,
casetracker_case,
);
return $view;
}
function _spaces_casetracker_views_cases_byproject() {
$view = _spaces_casetracker_views_base();
$view->name = 'spaces_cases_byproject';
$view->description = t('Filter cases by project.');
$view->menu = TRUE;
$view->menu_title = t('Cases by project');
$view->page = TRUE;
$view->page_title = 'Cases by project';
$view->url = 'cases/by-project';
$view->sort = array(
array(
'tablename' => 'casetracker_case',
'field' => 'case_status_id',
'sortorder' => 'ASC',
'options' => 'normal',
),
);
$view->filter['project'] = array(
'tablename' => 'casetracker_project',
'field' => 'project_number',
'operator' => 'OR',
'options' => '',
'value' => array(
0 => '100',
),
);
$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 = _spaces_casetracker_views_base();
$view->name = 'spaces_cases_mycreated';
$view->description = t('A view of all cases made by the current user.');
$view->menu = TRUE;
$view->menu_title = t('Created by me');
$view->page = TRUE;
$view->page_title = t('Created by me');
$view->url = 'cases/mycreated';
$view->sort = array(
array(
'tablename' => 'casetracker_case',
'field' => 'case_status_id',
'sortorder' => 'ASC',
'options' => 'normal',
),
);
$view->filter['user'] = array(
'tablename' => 'node',
'field' => 'currentuid',
'operator' => '=',
'options' => '',
'value' => '***CURRENT_USER***',
);
$view->filter['project'] = array(
'tablename' => 'casetracker_project',
'field' => 'project_number',
'operator' => 'OR',
'options' => '',
'value' => array(
0 => '100',
),
);
$view->exposed_filter = array(
array(
'tablename' => 'casetracker_project',
'field' => 'project_number',
'label' => 'Project',
'optional' => '1',
'is_default' => '0',
'operator' => '1',
'single' => '1',
),
);
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' => 'spaces',
'field' => 'type',
'operator' => 'all',
'options' => '',
'value' => 'all',
),
);
$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' => 'spaces',
'field' => 'type',
'operator' => 'all',
'options' => '',
'value' => 'all',
),
);
$view->exposed_filter = array();
$view->requires = array(
node,
casetracker_case_node,
);
return $view;
}
function _spaces_casetracker_views_user_cases() {
$view = _spaces_casetracker_views_base();
$view->name = 'spaces_user_cases';
$view->description = 'A view of all cases by date.';
$view->page = TRUE;
$view->page_title = 'Cases';
$view->url = 'user-cases';
$view->sort = array(
array(
'tablename' => 'casetracker_case',
'field' => 'case_status_id',
'sortorder' => 'ASC',
'options' => '',
),
);
$view->filter['assign'] = array(
'tablename' => 'casetracker_case',
'field' => 'assign_to',
'operator' => 'AND',
'options' => '',
'value' => array(
0 => '1',
),
);
unset($view->filter['spaces']);
return $view;
}
function _spaces_casetracker_views_user_cases_created() {
$view = _spaces_casetracker_views_base();
$view->name = 'spaces_user_cases_created';
$view->description = 'A view of all cases by date.';
$view->view_args_php = '
$space = spaces_get_space();
if ($space && $space->type == \'user\') {
$view->page_title = t(\'Cases created by !user\', array(\'!user\' => $space->title));
}
';
$view->page = TRUE;
$view->page_title = 'Cases created by';
$view->url = 'user-cases/created';
$view->sort = array(
array(
'tablename' => 'casetracker_case',
'field' => 'case_status_id',
'sortorder' => 'ASC',
'options' => '',
),
);
$view->requires = array(
casetracker_case,
node,
spaces,
);
return $view;
}
