<?php

function asset_views_tables(){
	$tables['asset_node'] = array(
		'name' => 'asset_node',
		'join' => array(
			'type' => 'inner',
			'left' => array(
				'table' => 'node',
				'field' => 'nid',
	),
			'right' => array(
				'field' => 'nid',
	),
	),
	);

	$tables['asset'] = array(
		'name' => 'asset',
		'join' => array(
			'type' => 'inner',
			'left' => array(
				'table' => 'asset_node',
				'field' => 'aid',
	),
			'right' => array(
				'field' => 'aid',
	),
	),
		'fields' => array(
			'aid' => array(
				'name' => t('Asset'),
				'help' => t('Display the formatted asset. NOTE: If using one of the formatters under <em><strong>Only Available for Specific Extensions</strong></em>, be sure to apply the Asset:Extension filter for the specific extensions that apply to that formatter.'),
				'option' => array(
					'#type' => 'select', 
					'#options' => 'asset_views_options_formatters',
	),
				'handler' => array(
					'asset_views_handler_field_asset' => t('No Link'),
					'asset_views_handler_field_asset_link' => t('Link to asset'),          
					'asset_views_handler_field_asset_node_link' => t('Link to node'),
	),
	),
			'filename' => array(
				'name' => t('Asset: Filename'),
				'help' => t('Display the filename of the asset.'),
	),
			'extension' => array(
				'name' => t('Asset: Extension'),
				'help' => t('Display the extension of the asset.'),
	),
			'dirname' => array(
				'name' => t('Asset: Directory'),
				'help' => t('Display the directory of the asset.'),
	),
			'filesize' => array(
				'name' => t('Asset: File Size'),
				'help' => t('Display the file size of the asset.'),
	),
	),
		'filters' => array(
			'extension' => array(
				'name' => t('Asset: File Extension'),
				'help' => t('Filter by file extension.'),
				'operator' => views_handler_operator_andor(),
				'value' => array(
					'#type' => 'select',
					'#options' => 'asset_views_options_file_extensions',
					'#multiple' => true,
					'#size' => 4,
	),
	),
			'type' => array(
				'name' => t('Asset: File Type'),
				'help' => t('Filter by file type.'),
				'operator' => views_handler_operator_andor(),
				'value' => array(
					'#type' => 'select',
					'#options' => 'asset_views_options_file_types',
					'#multiple' => true,
					'#size' => 4,
	),
	),
			'dirname' => array(
				'name' =>t ('Asset: Directory'),
				'help' => t('Filter by an assets parent directory.'),
				'operator' => views_handler_operator_eqneq(),
	),
			'distinct' => array(
				'name' => t('Asset: Distinct'),
				'operator' => array('=' => 'is'),
				'list' => array('distinct' => 'distinct'),
				'handler' => 'asset_views_handler_filter_distinct',
				'value-type' => 'array',
				'help' => t('This filter ensures that each asset may only be listed once, even if it matches multiple criteria.'),
	),
	),
	);
	return $tables;
}


function asset_views_handler_field_asset_node_link($fieldinfo, $fielddata, $value, $data) {
	$link = 'node/'.$data->nid;
	return asset_views_handler_field_asset($fieldinfo, $fielddata, $value, $data, $link);
}

function asset_views_handler_field_asset_link($fieldinfo, $fielddata, $value, $data) {
	$asset = asset_load($value);
	$link = $asset->url;
	return asset_views_handler_field_asset($fieldinfo, $fielddata, $value, $data, $link);
}

function asset_views_handler_field_asset($fieldinfo, $fielddata, $value, $data, $link = false) {
	static $formatters;
	if(!$formatters){
		$formatters = asset_get_formatters();
	}

	$asset = asset_load($value);
	switch($fielddata['options']){
		case 'full':
			list($module,$format) = explode(':',asset_get_default_formatter($asset->type, $asset->extension, false));
			break;
		case 'teaser':
			list($module,$format) = explode(':',asset_get_default_formatter($asset->type, $asset->extension, true));
			break;
		default:
			list($module,$format) = explode(':',$fielddata['options']);
			$found = false;
			foreach ((array)$formatters[$asset->type][$asset->extension] as $formatter) {
				if($formatter['module'] == $module && $formatter['format'] == $format) {
					$found = true;
					break;
				}
			}
			foreach((array)$formatters[$asset->type]['*'] as $formatter){
				if($formatter['module'] == $module && $formatter['format'] == $format){
					$found = true;
					break;
				}
			}
			foreach((array)$formatters['*']['*'] as $formatter){
				if($formatter['module'] == $module && $formatter['format'] == $format){
					$found = true;
					break;
				}
			}
			if (!$found) {
				$module = 'asset';
				$format = 'link';
			}
			break;
	}

	if ($link) {
		if ($format == 'link'){
			$html = $asset->title ? $asset->title : $asset->filename;
		} else {
			$html = module_invoke($module, 'asset_formatter', 'render', $asset, array('format'=>$format));
		}
		return l($html, $link, array('html' => true));
	} else {
		return module_invoke($module, 'asset_formatter', 'render', $asset, array('format'=>$format));
	}
}

function asset_views_options_formatters(){
	$all = t('Available for all Extensions');
	$specific = t('Only available for specific Extensions');

	$options[$all]['full'] = t('Default Full-Text');
	$options[$all]['teaser'] = t('Default Teaser');
	foreach (module_implements('asset_formatter') as $module) {
		$list = module_invoke($module, 'asset_formatter', 'info');
		foreach ($list as $key => $data) {
			foreach ($data['types'] as $type=>$exts) {
				if ($exts == array('*')) {
					$options[$all][$module.':'.$key] = $data['name'] . ' (' . join($exts,',').')';
				} else {
					$options[$specific][$module.':'.$key] = $data['name'] . ' (' . join($exts,',').')';
				}
			}
		}
	}
	return $options;
}

function asset_views_options_file_extensions(){
	$result = db_query('SELECT DISTINCT(extension) FROM {asset} ORDER BY extension');
	$options = array();
	while($row = db_fetch_object($result)){
		$options[] = $row->extension;
	}
	return drupal_map_assoc($options);
}

function asset_views_options_file_types(){
	$result = db_query('SELECT DISTINCT(type) FROM {asset} ORDER BY type');
	$options = array();
	while($row = db_fetch_object($result)){
		$options[] = $row->type;
	}
	return drupal_map_assoc($options);
}

function asset_views_handler_filter_distinct($op, $filter, $filterinfo, &$query) {
	if (!$query->no_distinct) {
		$query->set_distinct();
		$query->add_groupby('asset_node.aid');
	}
}
?>