<?php

function mymodule_views_data() {

  $data['users_prog_roles']['table']['join']['users'] = array(
    'left_field' => 'uid',
    'field' => 'uid'
  );
  $data['prog_roles']['table']['join']['users'] = array(
    'left_table' => 'users_prog_roles',
    'left_field' => 'prid',
    'field' => 'prid'
  );
  $data['export_short_audit']['table']['join']['users'] = array(
    'left_table' => 'users_prog_roles',
    'left_field' => 'prid',
    'field' => 'prid'
  );
  $data['audit']['table']['join']['users'] = array(
    'left_field' => 'uid',
    'field' => 'uid'
  );
  $data['audits_results']['table']['join']['users'] = array(
    'left_field' => 'uid',
    'field' => 'uid'
  );
  $data['audits_results']['bl_score'] = array(
    'title'  => 'BL score',
    'help'   => 'Shows first audit score',
    'group'  => t('User'),
    'field'  => array('handler' => 'views_handler_field', 'click sortable' => TRUE),
    'sort'   => array('handler' => 'views_handler_sort'),
    'filter' => array('handler' => 'views_handler_filter_numeric'),
  );
  $data['audits_results']['fu_score'] = array(
    'title'  => 'FU score',
    'help'   => 'Shows final audit score',
    'group'  => t('User'),
    'field'  => array('handler' => 'views_handler_field', 'click sortable' => TRUE),
    'sort'   => array('handler' => 'views_handler_sort'),
    'filter' => array('handler' => 'views_handler_filter_numeric'),
  );
  $data['audits_results']['bl_prevalence'] = array(
    'title'  => 'BL Prevalence',
    'help'   => 'Shows first prevalence score',
    'group'  => t('User'),
    'field'  => array('handler' => 'views_handler_field', 'click sortable' => TRUE),
    'sort'   => array('handler' => 'views_handler_sort'),
    'filter' => array('handler' => 'views_handler_filter_numeric'),
  );
  $data['audits_results']['fu_prevalence'] = array(
    'title'  => 'FU Prevalence',
    'help'   => 'Shows final prevalence score',
    'group'  => t('User'),
    'field'  => array('handler' => 'views_handler_field', 'click sortable' => TRUE),
    'sort'   => array('handler' => 'views_handler_sort'),
    'filter' => array('handler' => 'views_handler_filter_numeric'),
  );
  $data['audits_results']['fu_csq'] = array(
    'title'  => 'FU CSQ-8',
    'help'   => 'Shows fu csq8 results',
    'group'  => t('User'),
    'field'  => array('handler' => 'views_handler_field', 'click sortable' => TRUE),
    'sort'   => array('handler' => 'views_handler_sort'),
    'filter' => array('handler' => 'views_handler_filter_numeric'),
  );
  $data['audits_results']['link_to_final'] = array(
    'title'  => 'Link to final questions',
    'help'   => 'Shows link to final questions results',
    'group'  => t('User'),
    'field'  => array('handler' => 'views_handler_field', 'click sortable' => TRUE),
    'sort'   => array('handler' => 'views_handler_sort'),
    'filter' => array('handler' => 'views_handler_filter_string'),
  );
  $data['prog_roles']['name'] = array(
    'title'  => 'Program role name',
    'help'   => 'Shows role of intervention program',
    'group'  => t('User'),
    'field'  => array('handler' => 'views_handler_field', 'click sortable' => TRUE),
    'sort'   => array('handler' => 'views_handler_sort'),
    'filter' => array('handler' => 'views_handler_filter_string'),
  );
  return $data;
}