<?php

# Adding region dropdown to filter
add_action('restrict_manage_posts', 'tsml_restrict_manage_posts' );
function tsml_restrict_manage_posts(){

	if (@$_GET['post_type'] != 'tsml_meeting') return;

	wp_dropdown_categories(array(
		'show_option_all'    => 'Region',
		'orderby'			 => 'tax_name',
		'hide_empty'         => true,
		'selected'           => @$_GET['region'],
		'hierarchical'       => true,
		'name'               => 'region',
		'taxonomy'           => 'tsml_region',
		'hide_if_empty'      => true,
		'value_field'	     => 'term_id',
	));
}

# If filter is set, restrict results
add_filter('parse_query', 'tsml_posts_filter');
function tsml_posts_filter($query){
	global $pagenow, $wpdb;

	if (($pagenow !='edit.php') || (@$_GET['post_type'] != 'tsml_meeting') || empty($_GET['region'])) return;
	
	$parent_ids = $wpdb->get_col('SELECT p.ID FROM ' . $wpdb->posts . ' p
		JOIN ' . $wpdb->term_relationships . ' r ON r.object_id = p.ID
		JOIN ' . $wpdb->term_taxonomy . ' x ON x.term_taxonomy_id = r.term_taxonomy_id
		WHERE x.term_id = ' . intval($_GET['region']));
	
	if (empty($parent_ids)) $parent_ids = array(0); //impossible scenario to show no results

	$query->query_vars['post_parent__in'] = $parent_ids;
		
}


# Custom columns for meetings
add_filter('manage_edit-tsml_meeting_columns', 'tmsl_admin_meetings_columns');
function tmsl_admin_meetings_columns($defaults) {
	return array(
			'cb'		=> '<input type="checkbox" />',
			'title'		=> __('Meeting', '12-step-meeting-list'),
			'day'		=> __('Day', '12-step-meeting-list'),
			'time'		=> __('Time', '12-step-meeting-list'),
			'region'	=> __('Region'),
			'date'		=> __('Date', '12-step-meeting-list'),
	);	
}

# If you're deleting meetings, also delete locations
add_action('delete_post', 'tsml_delete_post');
function tsml_delete_post($post_id) {
	$post = get_post($post_id);
	if ($post->post_type == 'tsml_meeting') tsml_delete_orphans();
}

# Custom list values for meetings
add_action('manage_tsml_meeting_posts_custom_column', 'tmsl_admin_meetings_custom_column', 10, 2);
function tmsl_admin_meetings_custom_column($column_name, $post_ID) {
	global $tsml_days, $wpdb;
	if ($column_name == 'day') {
		$day = get_post_meta($post_ID, 'day', true);
		echo (empty($day) && $day !== '0') ? __('Appointment', '12-step-meeting-list') : $tsml_days[$day];
	} elseif ($column_name == 'time') {
		echo tsml_format_time(get_post_meta($post_ID, 'time', true));
	} elseif ($column_name == 'region') {
		//don't know how to do this with fewer queries
		echo $wpdb->get_var('SELECT t.name
			FROM ' . $wpdb->terms . ' t
			JOIN ' . $wpdb->term_taxonomy . ' x ON t.term_id = x.term_id
			JOIN ' . $wpdb->term_relationships . ' r ON x.term_taxonomy_id = r.term_taxonomy_id
			JOIN ' . $wpdb->posts . ' p ON r.object_id = p.post_parent
			WHERE p.ID = ' . $post_ID);
	}
}

# Set custom meetings columns to be sortable
add_filter('manage_edit-tsml_meeting_sortable_columns', 'tsml_admin_meetings_sortable_columns');
function tsml_admin_meetings_sortable_columns($columns) {
	$columns['day']		= 'day';
	$columns['time']		= 'time';
	//$columns['region']	= 'region';
	return $columns;
}

# Apply sorting
add_filter('request', 'tsml_sorting');
function tsml_sorting($vars) {
	if (isset($vars['orderby'])) {
			switch($vars['orderby']) {
				case 'day':
					return array_merge($vars, array(
						'meta_key' => 'day',
						'orderby' => 'meta_value'
					));
				case 'time':
					return array_merge($vars, array(
						'meta_key' => 'time',
						'orderby' => 'meta_value'
					));
			/* case 'region':
					return array_merge($vars, array(
						'meta_key' => 'region',
						'orderby' => 'meta_value'
					));
			*/
			}
	}
	return $vars;
}

//remove quick edit because meetings could get messed up without custom fields
add_filter('post_row_actions', 'tsml_post_row_actions', 10, 2);
function tsml_post_row_actions($actions) {
	global $post;
	if ($post->post_type == 'tsml_meeting') {
		unset($actions['inline hide-if-no-js']);
	}
	return $actions;
}