<?php

function apply_for_role_views_data() {

	$data = array();
	$data['users_roles_apply']['table']['group'] = t('Role Apps');
	// Make this a base table
	$data['users_roles_apply']['table']['base'] = array(
		'field' => 'aid',
		'title' => t('Role Applications'),
		'help' => t('For displaying role applications, typically used for an admin interface'),
	);
	
	/*
	// Join the table to the user table
	$data['users_roles_apply']['table']['join'] = array(
		'users' => array(
			'left_field' => 'uid',
			'field' => 'uid',
		),
		'users_roles' => array(
			'left_field' => 'rid',
			'field' => 'rid',
		),
	);
	*/

	
	// application ID field
	$data['users_roles_apply']['aid'] = array(
		'title' => t('Application ID'),
		'help' => t('The unique ID of the role application.'),
		'field' => array(
			'handler' => 'views_handler_field',
		),
	);
	
	// user ID field
	$data['users_roles_apply']['uid'] = array(
		'title' => t('User ID'),
		'help' => t('The ID of the role applicant.'),
		'field' => array(
			'handler' => 'views_handler_field',
		),
    'relationship' => array(
      'base' => 'user',
      'handler' => 'views_handler_relationship',
      'label' => t('User'),
      'skip base' => array('user'),
    ),
	);
		
	// role ID field
	$data['users_roles_apply']['rid'] = array(
		'title' => t('Role ID'),
		'help' => t('The unique ID assigned to each role.'),
		'field' => array(
			'handler' => 'views_handler_field',
		),
	);
	
	// approved field
	$data['users_roles_apply']['approved'] = array(
		'title' => t('Approved'),
		'help' => t('If the application was approved or not.'),
		'field' => array(
			'handler' => 'views_handler_field',
		),
	);
	
	// application date
	$data['users_roles_apply']['apply_date'] = array(	
		'title' => t('Application Date'),
		'help' => t('The date the application was received'),
		'field' => array(
			'handler' => 'views_handler_field_date',
		),
	);
		
	// approval date
	$data['users_roles_apply']['approve_date'] = array(		
		'title' => t('Approval Date'),
		'help' => t('The date the application was approved'),
		'field' => array(
			'handler' => 'views_handler_field_date',
		),
	);
	
	return $data;
}