<?php

/**
 * Install routine
 *
 *@since 1.0
 *@access private
 *@ignore
*/
function eventorganiser_install( $is_networkwide = false ) {

	global $wpdb;

	if ( ! defined( 'EVENT_ORGANISER_URL' ) ) {
		define( 'EVENT_ORGANISER_URL', plugin_dir_url( EVENT_ORGANISER_DIR.'event-organiser.php' ) );
	}

	// If this is multisite and the user clicked network activate - we'll need to loop over all sites
	$is_multisite = ( function_exists( 'is_multisite' ) && is_multisite() );

	if ( $is_multisite && $is_networkwide ) {
		// Get the current blog so we can return to it.
		$current_blog_id = get_current_blog_id();

		$blog_ids = $wpdb->get_col( "SELECT blog_id FROM $wpdb->blogs" );
		if ( $blog_ids ) {
			foreach ( $blog_ids as $blog_id ) {
				switch_to_blog( $blog_id );
				eventorganiser_site_install();
			}
			switch_to_blog( $current_blog_id );
		} else {
			eventorganiser_site_install();
		}
	} else {
		eventorganiser_site_install();
	}
}

function eventorganiser_site_install() {

	global $wpdb;

	$eventorganiser_db_version = defined( 'EVENT_ORGANISER_VER' ) ? EVENT_ORGANISER_VER : false;

	eventorganiser_wpdb_fix();

	$charset_collate = '';
	if ( ! empty($wpdb->charset) ) {
		$charset_collate = "DEFAULT CHARACTER SET $wpdb->charset";
	}
	if ( ! empty($wpdb->collate) ) {
		$charset_collate .= " COLLATE $wpdb->collate";
	}

	//Events table
	$sql_events_table = "CREATE TABLE {$wpdb->eo_events} (
		event_id bigint(20) NOT NULL AUTO_INCREMENT,
		post_id bigint(20) NOT NULL,
		StartDate DATE NOT NULL,
		EndDate DATE NOT NULL,
		StartTime TIME NOT NULL,
		FinishTime TIME NOT NULL,
		event_occurrence bigint(20) NOT NULL,
		PRIMARY KEY  (event_id),
		KEY StartDate (StartDate),
		KEY EndDate (EndDate)
		)".$charset_collate;

	//Venue meta table
	$sql_venuemeta_table = "CREATE TABLE {$wpdb->eo_venuemeta} (
		meta_id bigint(20) unsigned NOT NULL auto_increment,
		eo_venue_id bigint(20) unsigned NOT NULL default '0',
 		meta_key varchar(255) default NULL,
		meta_value longtext,
		PRIMARY KEY  (meta_id),
		KEY eo_venue_id (eo_venue_id),
		KEY meta_key (meta_key)
		) $charset_collate; ";

	require_once( ABSPATH . 'wp-admin/includes/upgrade.php' );
	dbDelta( $sql_events_table );
	dbDelta( $sql_venuemeta_table );

	//Add options and capabilities
	$eventorganiser_options = array(
		'supports'          => array( 'title', 'editor', 'author', 'thumbnail', 'excerpt', 'custom-fields' ),
		'event_redirect'    => 'events',
		'dateformat'        => 'dd-mm',
		'prettyurl'         => 1,
		'templates'         => 'themecompat',
		'addtomenu'         => 0,
		'excludefromsearch' => 0,
		'showpast'          => 0,
		'group_events'      => '',
		'url_venue'         => 'events/event',
		'url_venue'         => 'events/venues',
		'url_cat'           => 'events/category',
		'url_tag'           => 'events/tag',
		'navtitle'          => __( 'Events', 'eventorganiser' ),
		'eventtag'          => 1,
		'feed'              => 1,
		'runningisnotpast' => 0,
		'deleteexpired'    => 0,
	);
	add_option( 'eventorganiser_options', $eventorganiser_options );

	/* Add existing notices */
	$notices = array( 'changedtemplate17' );
	add_option( 'eventorganiser_admin_notices', $notices );

	//Add roles to administrator
	global $wp_roles;
	$all_roles = $wp_roles->roles;
	$eventorganiser_roles = array(
		'edit_events'             => __( 'Edit Events', 'eventorganiser' ),
		'publish_events'          => __( 'Publish Events', 'eventorganiser' ),
		'delete_events'           => __( 'Delete Events', 'eventorganiser' ),
		'edit_others_events'      => __( 'Edit Others\' Events', 'eventorganiser' ),
		'delete_others_events'    => __( 'Delete Other\'s Events', 'eventorganiser' ),
		'read_private_events'     => __( 'Read Private Events', 'eventorganiser' ),
		'manage_venues'           => __( 'Manage Venues', 'eventorganiser' ),
		'manage_event_categories' => __( 'Manage Event Categories & Tags', 'eventorganiser' ),
	);
	foreach ( $all_roles as $role_name => $display_name ) :
		$role = $wp_roles->get_role( $role_name );
		if ( $role->has_cap( 'manage_options' ) ) {
			foreach ( $eventorganiser_roles as $eo_role => $eo_role_display ) :
				$role->add_cap( $eo_role );
			endforeach;
		}
	endforeach;  //End foreach $all_roles

	//Manually register CPT and CTs ready for flushing
	eventorganiser_create_event_taxonomies();
	eventorganiser_cpt_register();

	//Flush rewrite rules only on activation, and after CPT/CTs has been registered.
	flush_rewrite_rules();
}

/**
 * Deactivate routine
 *
 * Flushes rewrite rules. Don't clear cron jobs, as these won't be re-added.
 *
 *@since 1.5
 *@access private
 *@ignore
*/
function eventorganiser_deactivate() {
	flush_rewrite_rules();
}


/**
 * Upgrade routine. Hooked onto admin_init
 *
 *@since 1.1
 *@access private
 *@ignore
*/
function eventorganiser_upgradecheck() {
	global $wpdb, $EO_Errors;
	$eventorganiser_db_version = defined( 'EVENT_ORGANISER_VER' ) ? EVENT_ORGANISER_VER : false;

	$installed_ver = get_option( 'eventorganiser_version' );

	if ( empty($installed_ver) ) {
		//This is a fresh install. Add current database version
		add_option( 'eventorganiser_version', $eventorganiser_db_version );

		//But a bug in 1.5 means that it could be that they first installed in 1.5 (as no db version was added)
		//So set to 1.5.  Fresh installs will have to go through the 1.6 (and above) update, but this is ok.
		$installed_ver = '1.5';

		eventorganiser_install();
	}

	//If this is an old version, perform some updates.
	if ( ! empty( $installed_ver ) && $installed_ver != $eventorganiser_db_version ) {

		if ( version_compare( $installed_ver, '1.3', '<' ) ) {
			wp_die( 'You cannot upgrade to this version from 1.3 or before. Please upgrade to 1.5.7 first.' );
		}

		if ( version_compare( $installed_ver, '1.4', '<' ) ) {
			eventorganiser_140_update();
		}

		if ( version_compare( $installed_ver, '1.5', '<' ) ) {
			eventorganiser_150_update();
		}
		if ( version_compare( $installed_ver, '1.6', '<' )  ) {
			//Remove columns:
			$columns = $wpdb->get_col( "DESC {$wpdb->eo_events}", 0 );
			$remove_columns = array( 'Venue', 'event_schedule', 'event_schedule_meta', 'event_frequency', 'reoccurrence_start', 'reoccurrence_end' );
			$delete_columns = array_intersect( $remove_columns, $columns );
			if ( ! empty( $delete_columns ) ) {
				$sql = $wpdb->query( "ALTER TABLE {$wpdb->eo_events} DROP COLUMN ".implode( ', DROP COLUMN ', $delete_columns ).';' );
			}

			eventorganiser_install();
		}

		if ( version_compare( $installed_ver, '1.6.2', '<' ) ) {
			$options = get_option( 'eventorganiser_options' );
			if ( ! empty( $options['eventtag'] ) ) {
				$options['supports'][] = 'eventtag';
				update_option( 'eventorganiser_options', $options );
			}
		}

		if ( version_compare( $installed_ver, '2.7.3', '<' ) ) {
			//Ensure event_allday columns is removed. This causes problems on Windows servers.
			$columns = $wpdb->get_col( "DESC {$wpdb->eo_events}", 0 );
			$remove_columns = array( 'event_allday' );
			$delete_columns = array_intersect( $remove_columns, $columns );
			if ( ! empty( $delete_columns ) ) {
				$sql = $wpdb->query( "ALTER TABLE {$wpdb->eo_events} DROP COLUMN ".implode( ', DROP COLUMN ', $delete_columns ).';' );
			}
			flush_rewrite_rules();
		}

		if ( version_compare( $installed_ver, '2.12.0', '<' ) && version_compare( get_bloginfo( 'version' ), '4.2-alpha-31007-src', '>=' ) ) {
			//If the user is upgrading from an earlier version (without the split term fix)
			//and they have already upgraded to WP 4.2.0, then run the update routine
			eventorganiser_021200_update();
		}

		if ( version_compare( $installed_ver, '3.0.0', '<' ) ) {
			//Agenda widget refactored, clear widget cache
			delete_transient( 'eo_widget_agenda' );
			_eventorganiser_delete_calendar_cache();
		}

		if ( version_compare( $installed_ver, '3.0.3', '<' ) ) {
			//Bug with filtering venues fixed - requires cache to be cleared
			delete_transient( 'eo_full_calendar_public' );
			delete_transient( 'eo_full_calendar_public_priv' );
		}

		update_option( 'eventorganiser_version', $eventorganiser_db_version );

		//Run upgrade checks
		add_action( 'admin_notices', 'eventorganiser_db_checks', 0 );
	};

}
add_action( 'admin_init', 'eventorganiser_upgradecheck' );

/**
 * Upgrade routine for 2.12.0
 * @access private
 * @ignore
 */
function eventorganiser_021200_update() {

	global $wpdb;

	//Venues
	$meta_venue_ids = $wpdb->get_col( "SELECT DISTINCT eo_venue_id FROM {$wpdb->eo_venuemeta} ORDER BY {$wpdb->eo_venuemeta}.meta_id" );
	if( $meta_venue_ids ){
		foreach( $meta_venue_ids as $old_venue_id ){
			$new_venue_id = wp_get_split_term( $old_venue_id, 'event-venue' );

			//If $new_venue_id is false, the term ID never changed
			//If $new_venue_id is in $meta_venue_ids, then it already has data in the meta table
			if( $new_venue_id && !in_array( $new_venue_id, $meta_venue_ids ) ){
				$wpdb->update(
					$wpdb->eo_venuemeta,
					array( 'eo_venue_id' => $new_venue_id ),
					array( 'eo_venue_id' => $old_venue_id )
				);
				wp_cache_delete( $new_venue_id, 'eo_venue_meta' );
			}
		}
	}
	
	//Categories
	$category_options = $wpdb->get_col( "SELECT option_name FROM {$wpdb->options} WHERE option_name LIKE 'eo-event-category\_%'" );
	if( $category_options ){
		foreach( $category_options as $option_name ){
			$old_cat_id = (int) substr( $option_name, 18 );//18 = length of eo-event-category_
			if( $old_cat_id ){
				$new_cat_id = wp_get_split_term( $old_cat_id, 'event-category' );
				if( $new_cat_id && !get_option( "eo-event-category_{$new_cat_id}" ) ){
					$value = get_option( "eo-event-category_{$old_cat_id}" );
					update_option( "eo-event-category_{$new_cat_id}", $value );
					delete_option( "eo-event-category_{$old_cat_id}" );
				}				
			}
		}
	}
	
}

/**
 * Upgrade routine for 1.5
 *
 *@since 1.5
 *@access private
 *@ignore
*/
function eventorganiser_150_update(){
	global $wpdb;
	$et =$wpdb->eo_events;
	$events = $wpdb->get_results("SELECT*, min({$et}.StartDate) as StartDate, min({$et}.EndDate) as EndDate FROM $wpdb->eo_events GROUP BY {$et}.post_id ORDER BY {$et}.StartDate");
	if( $events ):
		foreach( $events as $event ):

			$post_id = (int) $event->post_id;

			$event_data = array(
				'schedule' => $event->event_schedule,
				'all_day' => $event->event_allday,
				'schedule_meta' => ('weekly' == $event->event_schedule ? maybe_unserialize($event->event_schedule_meta) : $event->event_schedule_meta),
				'frequency' => $event->event_frequency,
				'exclude'=>array(),
				'include'=>array(),
			);
			$start = new DateTime($event->StartDate.' '.$event->StartTime, eo_get_blog_timezone());
			$end = new DateTime($event->EndDate.' '.$event->FinishTime, eo_get_blog_timezone());
			$schedule_last = new DateTime($event->reoccurrence_end.' '.$event->StartTime, eo_get_blog_timezone());

			$seconds = round(abs($start->format('U') - $end->format('U')));
			$days = floor($seconds/86400);// 86400 = 60*60*24 seconds in a normal day
			$sec_diff = $seconds - $days*86400;
			$duration_str = '+'.$days.'days '.$sec_diff.' seconds';
			$event_data['duration_str'] =$duration_str;

			$schedule_last_end = clone $schedule_last;
			$schedule_last_end->modify($duration_str);

			update_post_meta( $post_id,'_eventorganiser_event_schedule', $event_data);
			update_post_meta( $post_id,'_eventorganiser_schedule_start_start', $start->format('Y-m-d H:i:s')); //Schedule start
			update_post_meta( $post_id,'_eventorganiser_schedule_start_finish', $end->format('Y-m-d H:i:s')); //Schedule start
			update_post_meta( $post_id,'_eventorganiser_schedule_last_start', $schedule_last->format('Y-m-d H:i:s'));//Schedule last
			update_post_meta( $post_id,'_eventorganiser_schedule_last_finish', $schedule_last_end->format('Y-m-d H:i:s'));//Schedule last

		endforeach;
	endif;

}

/**
 * Upgrade routine for 1.4
 *
 *@since 1.4
 *@access private
 *@ignore
*/
function eventorganiser_140_update(){
	//Migrates from Venue table to venue meta table

	//Run install to create new table:
	eventorganiser_install();

	global $wpdb;
	$eventorganiser_venue_table = $wpdb->prefix."eo_venues";

	$venues = eo_get_the_venues();
	$venue_metavalues = $wpdb->get_results(" SELECT venue_slug, venue_address, venue_postal, venue_country, venue_lng, venue_lat, venue_description FROM $eventorganiser_venue_table");
	$fields = array('venue_address'=>'_address','venue_postal'=>'_postcode','venue_country'=>'_country','venue_lng'=>'_lng','venue_lat'=>'_lat','venue_description'=>'_description');

	foreach( $venue_metavalues as $venue ){
		$term = get_term_by('slug',$venue->venue_slug,'event-venue');
		if( empty($term) || is_wp_error($term) )
			continue;

		foreach ($fields as $column_name => $meta_key){
			if( ! empty($venue->$column_name) ){
				update_metadata('eo_venue',$term->term_id,$meta_key,$venue->$column_name);
			}
		}
	}
}


/**
 * Uninstall routine
 *
 *@since 1.0
 *@access private
 *@ignore
*/
function eventorganiser_uninstall( $is_networkwide = false ){
	global $wpdb;

    	// Is this multisite and did the user click network activate?
    	$is_multisite = ( function_exists('is_multisite') && is_multisite() );

    	if ( $is_multisite && $is_networkwide ) {
    	    	// Get the current blog so we can return to it.
	        $current_blog_id = get_current_blog_id();

	        // Get a list of all blogs.
	        $blog_ids = $wpdb->get_col( "SELECT blog_id FROM $wpdb->blogs" );
		if( $blog_ids ){
			foreach ( $blog_ids as $blog_id ) {
				switch_to_blog( $blog_id );
	            		eventorganiser_uninstall_site();
	       		 }
			switch_to_blog( $current_blog_id );
		}else{
			eventorganiser_uninstall_site();
		}
    	}else {
    	    eventorganiser_uninstall_site();
    	}

}

function eventorganiser_uninstall_site(){
	global $wpdb,$eventorganiser_roles, $wp_roles,$wp_taxonomies;

	eventorganiser_clear_cron_jobs();
	eventorganiser_create_event_taxonomies();

	//Remove 	custom taxonomies and terms.
	$taxs = array('event-category','event-venue','event-tag');
	$terms = get_terms($taxs, 'hide_empty=0' );

	if( $terms ){
		foreach ($terms as $term) {
			$term_id = (int)$term->term_id;
			wp_delete_term($term_id ,$term->taxonomy);
		}
	}

	//Delete options
	delete_option('eventorganiser_options');
	delete_option('eventorganiser_admin_notices');
	delete_option('eventorganiser_version');
	delete_option('eo_notice');
	delete_option('widget_eo_calendar_widget');
	delete_option('widget_eo_list_widget');

	//Remove Event Organiser capabilities
	$all_roles = $wp_roles->roles;
	foreach ($all_roles as $role_name => $display_name):
		$role = $wp_roles->get_role($role_name);
		foreach($eventorganiser_roles as $eo_role=>$eo_role_display):
			$role->remove_cap($eo_role);
		endforeach;  
	endforeach; 
	
	eventorganiser_clear_cron_jobs();

	//Drop tables    
	$wpdb->query("DROP TABLE IF EXISTS $wpdb->eo_events");
	$eventorganiser_venue_table = $wpdb->prefix."eo_venues";
	$wpdb->query("DROP TABLE IF EXISTS $eventorganiser_venue_table");
	$wpdb->query("DROP TABLE IF EXISTS $wpdb->eo_venuemeta");

	//Remove user-meta-data:
	$meta_keys = array('metaboxhidden_event','closedpostboxes_event','wp_event_page_venues_per_page','manageedit-eventcolumnshidden');	
	$sql =$wpdb->prepare("DELETE FROM $wpdb->usermeta WHERE ");
	foreach($meta_keys as $key):
		$sql .= $wpdb->prepare("meta_key = %s OR ",$key);
	endforeach;
	$sql.=" 1=0 "; //Deal with final 'OR', must be something false!
	$re =$wpdb->get_results( $sql);	
	flush_rewrite_rules();
    }
