/**
 * @snippet       Programmatically Complete Paid WooCommerce Orders
 * @how-to        businessbloomer.com/woocommerce-customization
 * @author        Rodolfo Melogli, Business Bloomer
 * @testedwith    WooCommerce 9
 * @community     https://businessbloomer.com/club/
 */
 
add_filter( 'woocommerce_payment_complete_order_status', 'bbloomer_autocomplete_processing_orders', 9999 );
 
function bbloomer_autocomplete_processing_orders() {
	return 'completed';
}

add_action( 'woocommerce_email_customer_details', 'fooevents_display_attendee_details_in_new_order_email', 10 , 4);
function fooevents_display_attendee_details_in_new_order_email($order, $sent_to_admin, $plain_text, $email){
	echo "<h3>Attendee Details</h3>";
	$WooCommerceEventsOrderTickets = get_post_meta($order->get_id(), 'WooCommerceEventsOrderTickets', true);
	foreach($WooCommerceEventsOrderTickets as $event) {
		foreach($event as $ticket) {
			echo "<p>";
			echo '<strong>First Name</strong>: '.$ticket['WooCommerceEventsAttendeeName'].'<br />';
			echo '<strong>Last Name</strong>: '.$ticket['WooCommerceEventsAttendeeLastName'].'<br />';
			echo '<strong>Email Address</strong>: '.$ticket['WooCommerceEventsAttendeeEmail'].'<br />';
			echo "</p>";
		}
	}
}

.

[php]
add_action( 'woocommerce_email_customer_details', 'fooevents_display_attendee_details_in_new_order_email', 10 , 4);
function fooevents_display_attendee_details_in_new_order_email($order, $sent_to_admin, $plain_text, $email){
    echo "<h3>Dettagli sui partecipanti</h3>";
    $WooCommerceEventsOrderTickets = get_post_meta($order-&gt;get_id(), 'WooCommerceEventsOrderTickets', true);
    foreach($WooCommerceEventsOrderTickets as $event) {
        foreach($event as $ticket) {
            echo "<p>";
            echo '<strong>Nome</strong>: '.$ticket['WooCommerceEventsAttendeeName'].'<br />';
            echo '<strong>Cognome</strong>: '.$ticket['WooCommerceEventsAttendeeLastName'].'<br />';
            echo '<strong>Indirizzo e-mail</strong>: '.$ticket['WooCommerceEventsAttendeeEmail'].'<br />';
            foreach ($ticket['WooCommerceEventsCustomAttendeeFields'] as $caf) {
                 echo $caf.'<br />';
            }
            echo "</p>";
        }
    }
}

.

[php]
add_action( 'woocommerce_email_customer_details', 'fooevents_display_attendee_details_in_new_order_email', 10 , 4);
function fooevents_display_attendee_details_in_new_order_email($order, $sent_to_admin, $plain_text, $email){
    echo "<h3>Dettagli sui partecipanti</h3>";
    $WooCommerceEventsOrderTickets = get_post_meta($order-&gt;get_id(), 'WooCommerceEventsOrderTickets', true);
    foreach($WooCommerceEventsOrderTickets as $event) {
        foreach($event as $ticket) {
            echo "<p>";
            echo '<strong>Nome</strong>: '.$ticket['WooCommerceEventsAttendeeName'].'<br />';
            echo '<strong>Cognome</strong>: '.$ticket['WooCommerceEventsAttendeeLastName'].'<br />';
            echo '<strong>Indirizzo e-mail</strong>: '.$ticket['WooCommerceEventsAttendeeEmail'].'<br />';
            echo '<strong>Compleanno</strong>: '.$ticket['WooCommerceEventsCustomAttendeeFields']['fooevents_custom_ovsxtmynwagotamjqieq'].'<br />';
            echo '<strong>Canzone preferita</strong>: '.$ticket['WooCommerceEventsCustomAttendeeFields']['fooevents_custom_ruzwhgbuhzuzzdwnnaxe'].'<br />';
            echo "</p>";
        }
    }
}

function fooevents_display_time_in_shop_listing() {
global $post;
if (is_front_page() || is_home() || is_shop() || is_product_category() || is_product_tag()) {
echo '<div class="fooevents-date">';
echo get_post_meta($post->ID, 'WooCommerceEventsHour', true).':';
echo get_post_meta($post->ID, 'WooCommerceEventsMinutes', true). ' ';
echo get_post_meta($post->ID, 'WooCommerceEventsPeriod', true);
echo '</div>';
}
}
add_filter( 'woocommerce_after_shop_loop_item_title', 'fooevents_display_time_in_shop_listing', 35 );

[fooevents_attendees]

[fooevents_attendees product_id=123]

function fooevents_display_attendees($attributes) {
 
	$product_id='';
	if(!empty($attributes['product_id'])) {
	$product_id = $attributes['product_id'];
	}

	$output ='';
	$args = array(
	'numberposts' => -1,
	'posts_per_page' => -1,
	'post_type'   => 'event_magic_tickets',
	'meta_query'  => array(
		'relation'    => 'OR',
		array(
		'key'   => 'WooCommerceEventsProductID',
		'value'   => $product_id,
		'compare' => 'LIKE'
		)
	)
	);  

	$the_query = new WP_Query( $args );

	if( $the_query->have_posts() ):
	while ( $the_query->have_posts() ) : $the_query->the_post();
	$postid = $the_query->post->ID;
	 
		// output all findings - CUSTOMIZE TO YOUR LIKING
		$output .= "<tr>";
		$output .= "<td>".get_the_title()."</td>";
		$output .= "<td>".get_post_meta($postid, 'WooCommerceEventsPurchaserFirstName', true)."</td>";
		$output .= "<td>".get_post_meta($postid, 'WooCommerceEventsPurchaserLastName', true)."</td>";
		$output .= "</tr>";
		 
	endwhile;
	endif;
	wp_reset_query();
	$output ="<table>".$output."</table>";
	return $output;
   
}
add_shortcode("fooevents_attendees", "fooevents_display_attendees");

function fooevents_display_date_on_single() {
	global $post;
	$product = wc_get_product( $post->ID );
	$start_date = $product->get_meta( 'WooCommerceEventsDate' );
	$end_date = $product->get_meta( 'WooCommerceEventsEndDate' );
	if ( $end_date ) {
	printf(
		'<h3>%s</h3>',
		esc_html( $start_date . ' - ' . $end_date )
	);
	} else if( $start_date ) {
	printf(
		'<h3>%s</h3>',
		esc_html( $start_date )
	);
	}
}
add_action( 'woocommerce_single_product_summary', 'fooevents_display_date_on_single' );

add_shortcode( 'fooevents_date_on_single', 'fooevents_display_date_on_single');

#fooevents_seating_dialog .fooevents_seating_chart_view_row span {
	background-image: url(../images/seat.svg);
}

#fooevents_seating_dialog .fooevents_seating_chart_view_row span {
	background-image: none;
}

#fooevents_seating_dialog .fooevents_seating_chart_view_row {
	display: flex;
	flex-direction: row-reverse;
	justify-content: flex-end;
}

#fooevents_seating_dialog .fooevents_seating_chart_view_row > span:nth-of-type(even) {
	float: left;
}

[css]
#fooevents_seating_dialog .fooevents_seating_chart_view_row_name,
#fooevents_seating_dialog .fooevents_seating_chart_view_row {
  text-align: center;
}
[/css]

#fooevents_seating_dialog .fooevents_seating_chart_view_row {
	overflow-x: scroll;
	white-space: nowrap;
}

[fooevents_calendar id="desktop"]

[fooevents_calendar id="mobile" defaultView="listWeek"]

#desktop_fooevents_calendar {
	display: block;
}
	
#mobile_fooevents_calendar {
	display: none;
}
	
@media screen and (max-width: 600px) {
	#desktop_fooevents_calendar {
	display: none;
	}
	
	#mobile_fooevents_calendar {
	display: block;
	}    
}

function dynamic_fooevents_calendar_shortcode() {
	if (is_product()) {
		global $product;
		if ($product) {
			$product_id = $product->get_id();
			return do_shortcode('[fooevents_calendar post="' . $product_id . '"]');
		}
	}
	return ''; // fallback if not on product page
}

add_shortcode('dynamic_fooevents_calendar', 'dynamic_fooevents_calendar_shortcode');

[dynamic_fooevents_calendar]

.fooevents-copy-from-purchaser {
	float: right; 
	margin-bottom:-1.7em
}

.fooevents-copy-from-purchaser {
	float: right; 
	margin-top:-2em
}

add_filter( 'woocommerce_product_tabs', 'reorder_tabs', 98 );
function reorder_tabs( $tabs ) {

	$tabs['woocommerce_events']['priority'] = 1; 
	return $tabs;

}

add_filter( 'woocommerce_loop_add_to_cart_link', 'fooevents_modify_add_to_cart_button_url', 10, 2 );
function fooevents_modify_add_to_cart_button_url( $button, $product ) {
	if (is_product_category() || is_shop()) {
		$button_text = $product->add_to_cart_text();
		$button_link = $product->get_permalink();
		$button = '<a class="button" href="' . $button_link . '">' . $button_text . '</a>';
		return $button;
	}
}

add_filter( 'woocommerce_get_price_html', 'wp_price_free_zero_empty', 100, 2 );
function wp_price_free_zero_empty( $price, $product ) {
	if ( '' === $product->get_price() || 0 == $product->get_price() ) {
		$price = 'FREE';
	}
	return $price;
}

/**
* @snippet Change WooCommerce ‘Add to Cart’ button to 'View Product'
* @source https://www.wptechnic.com/?p=4615
* @author Muhammad Tamzid
* @compatible WC 4.3.1
*/
// Change WooCommerce 'Add To Cart' button to 'View Product'
add_filter( 'woocommerce_loop_add_to_cart_link', 'wpt_custom_view_product_button', 10, 2 );
function wpt_custom_view_product_button( $button, $product ) {
	// Ignore for variable products
	if ( $product->is_type( 'variable' ) ) {
		return $button;
	}
	// Button text here
	$button_text = __( 'Book Ticket', 'woocommerce' );
	return '<a class="button wpt-custom-view-product-button" href="' . $product->get_permalink() . '">' . $button_text . '</a>';
}

add_filter( 'woocommerce_cart_item_name', 'add_event_date_cart_checkout', 10, 3 );
function add_event_date_cart_checkout( $product_name, $cart_item, $cart_item_key ) {
	$product = $cart_item['data'];

	if ( $value = $product->get_meta( 'WooCommerceEventsDate' ) ) {
		$product_name .= '<small>' . $value . '</small>';
	}
	return $product_name;
}

$order = wc_get_order( $ticket["WooCommerceEventsOrderID"] );

$report_data = [];

foreach ( $order->get_items() as $item ) {
	// Get all meta data for the item
	$meta_data = $item->get_meta_data();
													
	foreach ( $meta_data as $meta ) {
		// We only want to count meta that comes from Product Add-ons. 
		// Most add-ons don't start with an underscore.
		if ( strpos( $meta->key, '_' ) === 0 ) continue;

		$label = $meta->key;
		$value = $meta->value;
		$qty   = $item->get_quantity();

		// 1. Check if it's a 10-digit numeric timestamp
		if ( is_numeric( $value ) && strlen( $value ) === 10 ) {
			$value = date_i18n( get_option( 'date_format' ), (int) $value );
		} 
		// 2. Otherwise, check if it's a YYYY-MM-DD string
		elseif ( preg_match( '/^\d{4}-\d{2}-\d{2}$/', $value ) && strtotime( $value ) ) {
			$value = date_i18n( get_option( 'date_format' ), strtotime( $value ) );
		}

		// Store in a nested array: [Label][Value] = Total Count
		if ( !isset( $report_data[$label][$value] ) ) {
			$report_data[$label][$value] = 0;
		}
		$report_data[$label][$value] += $qty;
	}
}

if ( ! empty( $report_data ) ) {
	echo '<table align="center" style="width:80%; border-collapse: collapse; margin-top: 20px; font-family: sans-serif;">';
	echo '<thead style="background-color: #f1f1f1;">';
	echo '<tr>';
	echo '<th style="padding: 12px; border: 1px solid #ccc;">Add-on Group</th>';
	echo '<th style="padding: 12px; border: 1px solid #ccc;">Selection / Value</th>';
	echo '<th style="padding: 12px; border: 1px solid #ccc; text-align: center;">Total Count</th>';
	echo '</tr>';
	echo '</thead>';
	echo '<tbody>';

	foreach ( $report_data as $label => $selections ) {
		foreach ( $selections as $value => $count ) {
			echo '<tr>';
			echo '<td style="padding: 10px; border: 1px solid #eee;"><strong>' . esc_html( $label ) . '</strong></td>';
			echo '<td style="padding: 10px; border: 1px solid #eee;">' . esc_html( $value ) . '</td>';
			echo '<td style="padding: 10px; border: 1px solid #eee; text-align: center;">' . absint( $count ) . '</td>';
			echo '</tr>';
		}
	}

	echo '</tbody></table>';
} else {
	echo '<p>No add-on data found for these orders.</p>';
}