<?php
/**
 * Admin dashboard page.
 *
 * @package BoxCart
 */

// If this file is called directly, abort.
if ( ! defined( 'ABSPATH' ) ) {
	exit;
}
// phpcs:disable WordPress.NamingConventions.PrefixAllGlobals.NonPrefixedVariableFound -- Include-scope locals inside a view partial. Not globals; they exist only for the duration of the include.


// phpcs:disable WordPress.DB.DirectDatabaseQuery.DirectQuery -- BoxCart operates on its own custom tables (orders, baskets, locations, slots, etc.); WordPress core APIs (get_posts(), meta_query, etc.) do not apply. User-supplied values are always passed via $wpdb->prepare() placeholders.
// phpcs:disable WordPress.DB.DirectDatabaseQuery.NoCaching -- Caching is applied at the caller level for hot paths (admin dashboard widgets, frontend product listings); per-query wp_cache_get/set would add complexity for one-off admin queries.
// phpcs:disable WordPress.DB.DirectDatabaseQuery.SchemaChange -- Schema changes are intentional and run only during plugin activation via dbDelta() or controlled migrations.
// phpcs:disable WordPress.DB.PreparedSQL.InterpolatedNotPrepared -- Only internal, plugin-owned table names are interpolated into queries (e.g. {$wpdb->prefix}boxcart_orders); user-supplied values always go through prepare() placeholders.
// phpcs:disable WordPress.DB.PreparedSQLPlaceholders.UnfinishedPrepare -- $wpdb->prepare() is still valid with zero placeholders when we only need its auto-escaping of an array.
// phpcs:disable PluginCheck.Security.DirectDB.UnescapedDBParameter -- Interpolated values are internal table-name constants, not user input.

// Authorization gate: the WordPress admin menu already requires the
// `manage_options` capability to load this view (see BoxCart_Admin_Menus),
// but we double-check here so the view itself cannot be reached by an
// unprivileged user even if it's ever included directly.
if ( ! current_user_can( 'manage_options' ) ) {
	wp_die( esc_html__( 'You do not have permission to access this page.', 'boxcart' ) );
}

// Get current data.
global $wpdb;

$orders_table    = $wpdb->prefix . 'boxcart_orders';
$locations_table = $wpdb->prefix . 'boxcart_locations';
$slots_table     = $wpdb->prefix . 'boxcart_slots';

// Get today's date.
$today = current_time( 'Y-m-d' );

// Check if we have any orders at all.
$total_orders = (int) $wpdb->get_var( "SELECT COUNT(*) FROM {$orders_table}" );
$has_orders   = $total_orders > 0;

// Get stat counts.
$todays_orders = (int) $wpdb->get_var(
	$wpdb->prepare(
		"SELECT COUNT(*) FROM {$orders_table} WHERE slot_date = %s AND status != 'cancelled'",
		$today
	)
);

$pending_orders = (int) $wpdb->get_var(
	"SELECT COUNT(*) FROM {$orders_table} WHERE status = 'pending'"
);

$ready_orders = (int) $wpdb->get_var(
	"SELECT COUNT(*) FROM {$orders_table} WHERE status = 'ready'"
);

// Get recent orders (5 most recent).
$recent_orders = $wpdb->get_results(
	"SELECT o.*, l.name as location_name
	FROM {$orders_table} o
	LEFT JOIN {$locations_table} l ON o.location_id = l.id
	ORDER BY o.created_at DESC
	LIMIT 5",
	ARRAY_A
);

// Get active locations with today's slot data.
$locations_data     = BoxCart_Location::get_all_active();
$today_availability = array();

// Get day of week as integer (0=Sunday, 6=Saturday).
$day_of_week = (int) gmdate( 'w', strtotime( $today ) );

foreach ( $locations_data as $location_row ) {
	$location = new BoxCart_Location( $location_row['id'] );

	if ( ! $location->get_id() ) {
		continue;
	}

	$slots = $location->get_slots_for_day( $day_of_week );

	if ( empty( $slots ) ) {
		continue;
	}

	$total_capacity = 0;
	$total_booked   = 0;

	foreach ( $slots as $slot ) {
		$capacity        = $location->get_slot_capacity( $slot['id'], $today );
		$booked          = BoxCart_Order::count_orders_for_slot(
			$location->get_id(),
			$today,
			$slot['time_start'],
			$slot['time_end']
		);
		$total_capacity += $capacity;
		$total_booked   += $booked;
	}

	$today_availability[] = array(
		'location' => $location,
		'capacity' => $total_capacity,
		'booked'   => $total_booked,
		'slots'    => count( $slots ),
	);
}

// Get product and location counts for empty state.
$products_count  = (int) $wpdb->get_var( "SELECT COUNT(*) FROM {$wpdb->posts} WHERE post_type = 'boxcart_product' AND post_status = 'publish'" );
$locations_count = (int) $wpdb->get_var( "SELECT COUNT(*) FROM {$locations_table} WHERE is_active = 1" );

// Status badge classes.
$status_classes = array(
	'pending'    => 'boxcart-badge--warning',
	'processing' => 'boxcart-badge--info',
	'ready'      => 'boxcart-badge--success',
	'completed'  => 'boxcart-badge--neutral',
	'cancelled'  => 'boxcart-badge--danger',
);

?>
<div class="boxcart-admin boxcart-admin--dashboard">
	<!-- Page Header -->
	<div class="boxcart-page-header">
		<div class="boxcart-page-header__content">
			<h1 class="boxcart-page-header__title"><?php esc_html_e( 'BoxCart Dashboard', 'boxcart' ); ?></h1>
			<span class="boxcart-badge boxcart-badge--neutral">v<?php echo esc_html( BOXCART_VERSION ); ?></span>
		</div>
		<div class="boxcart-page-header__actions">
			<?php BoxCart_Admin_Help::render_help_button( 'dashboard' ); ?>
		</div>
	</div>

	<?php
	/**
	 * Fires at the top of the admin dashboard.
	 * Use this to add custom dashboard sections.
	 */
	do_action( 'boxcart_admin_dashboard' );
	?>

	<?php
	// Setup state drives the three independent sections below: the welcome hero
	// (brand-new install only), the Quick Start guide (persists until setup is
	// complete or the user dismisses it), and the live stats (once there is any
	// activity). Keeping the guide separate from the empty-state check is what
	// stops the guidance vanishing the moment the first product is added.
	$bc_setup_status = BoxCart_Setup::get_status();
	$bc_is_empty     = ( ! $has_orders && 0 === $products_count && 0 === $locations_count );
	// On a brand-new install the welcome hero already leads to Guided Setup.
	$bc_show_guide   = ( ! $bc_setup_status['complete'] && ! BoxCart_Setup::is_quickstart_dismissed() && ! ( ! $has_orders && 0 === $products_count && 0 === $locations_count ) );
	?>

	<?php if ( $bc_is_empty ) : ?>
		<!-- Empty State / Welcome -->
		<div class="boxcart-welcome">
			<div class="boxcart-welcome__icon">
				<span class="dashicons dashicons-cart"></span>
			</div>
			<h2 class="boxcart-welcome__title"><?php esc_html_e( 'Welcome to BoxCart', 'boxcart' ); ?></h2>
			<p class="boxcart-welcome__text">
				<?php esc_html_e( 'Guided Setup takes you through everything in about five minutes: your shop pages, where and when customers collect, your first product and how they pay.', 'boxcart' ); ?>
			</p>
			<div class="boxcart-welcome__actions">
				<a href="<?php echo esc_url( admin_url( 'admin.php?page=boxcart-setup' ) ); ?>" class="boxcart-btn boxcart-btn--primary">
					<span class="dashicons dashicons-yes-alt"></span>
					<?php esc_html_e( 'Start Guided Setup', 'boxcart' ); ?>
				</a>
			</div>
		</div>
	<?php endif; ?>

	<?php if ( $bc_show_guide ) : ?>
		<!-- Quick Start Guide (persistent until complete or dismissed) -->
		<div class="boxcart-card boxcart-quickstart">
			<div class="boxcart-card__header">
				<h3 class="boxcart-card__title"><?php esc_html_e( 'Quick Start Guide', 'boxcart' ); ?></h3>
				<form method="post" action="<?php echo esc_url( admin_url( 'admin.php?page=boxcart' ) ); ?>">
					<input type="hidden" name="boxcart_setup_action" value="dismiss_quickstart">
					<?php wp_nonce_field( 'boxcart_dismiss_quickstart', 'boxcart_dismiss_nonce' ); ?>
					<button type="submit" class="boxcart-quickstart__dismiss"><?php esc_html_e( 'Dismiss', 'boxcart' ); ?></button>
				</form>
			</div>
			<div class="boxcart-quickstart__steps">
				<?php
				$bc_steps = array(
					array(
						'done'  => $bc_setup_status['has_product'],
						'title' => __( 'Add Your Products', 'boxcart' ),
						'desc'  => BoxCart_Helpers::prices_enabled()
							? __( 'Create your product catalogue with prices and images.', 'boxcart' )
							: __( 'Create your product catalogue with images.', 'boxcart' ),
					),
					array(
						'done'  => $bc_setup_status['has_location'],
						'title' => __( 'Set Up Collection', 'boxcart' ),
						'desc'  => __( 'Add your pickup location, opening hours, and time slots.', 'boxcart' ),
					),
					array(
						'done'  => $bc_setup_status['pages_done'],
						'title' => __( 'Create Your Storefront Pages', 'boxcart' ),
						'desc'  => __( 'Use Guided Setup to create the Shop, Basket, Checkout, and My Account pages in one click, or add the shortcodes to your own pages.', 'boxcart' ),
					),
					array(
						'done'  => $bc_setup_status['pages_done'],
						'title' => __( 'Configure Settings', 'boxcart' ),
						'desc'  => __( 'Assign your pages, set up emails, and customise your store under Settings.', 'boxcart' ),
					),
					array(
						'done'  => $has_orders,
						'title' => __( 'Start Taking Orders', 'boxcart' ),
						'desc'  => __( 'Customers can browse, add to basket, and place orders.', 'boxcart' ),
					),
				);
				$bc_step_num = 0;
				foreach ( $bc_steps as $bc_step ) :
					$bc_step_num++;
					?>
					<div class="boxcart-quickstart__step <?php echo esc_attr( $bc_step['done'] ? 'boxcart-quickstart__step--done' : '' ); ?>">
						<div class="boxcart-quickstart__step-number">
							<?php echo $bc_step['done'] ? '&#10003;' : (int) $bc_step_num; ?>
						</div>
						<div class="boxcart-quickstart__step-content">
							<h4><?php echo esc_html( $bc_step['title'] ); ?></h4>
							<p><?php echo esc_html( $bc_step['desc'] ); ?></p>
						</div>
					</div>
				<?php endforeach; ?>
			</div>
			<div class="boxcart-quickstart__footer">
				<a href="<?php echo esc_url( admin_url( 'admin.php?page=boxcart-setup' ) ); ?>" class="boxcart-btn boxcart-btn--primary">
					<?php esc_html_e( 'Continue Guided Setup', 'boxcart' ); ?>
				</a>
			</div>
		</div>
	<?php endif; ?>

	<?php if ( ! $bc_is_empty ) : ?>
		<!-- Stat Cards -->
		<div class="boxcart-stats">
			<div class="boxcart-stat-card">
				<p class="boxcart-stat-card__label"><?php esc_html_e( "TODAY'S ORDERS", 'boxcart' ); ?></p>
				<p class="boxcart-stat-card__value"><?php echo esc_html( $todays_orders ); ?></p>
				<a href="<?php echo esc_url( admin_url( 'admin.php?page=boxcart-orders&slot_date=' . $today ) ); ?>" class="boxcart-stat-card__link">
					<?php esc_html_e( 'View all', 'boxcart' ); ?> &rarr;
				</a>
			</div>

			<div class="boxcart-stat-card">
				<p class="boxcart-stat-card__label"><?php esc_html_e( 'PENDING ORDERS', 'boxcart' ); ?></p>
				<p class="boxcart-stat-card__value"><?php echo esc_html( $pending_orders ); ?></p>
				<a href="<?php echo esc_url( admin_url( 'admin.php?page=boxcart-orders&status=pending' ) ); ?>" class="boxcart-stat-card__link">
					<?php esc_html_e( 'View all', 'boxcart' ); ?> &rarr;
				</a>
			</div>

			<div class="boxcart-stat-card">
				<p class="boxcart-stat-card__label"><?php esc_html_e( 'READY FOR COLLECTION', 'boxcart' ); ?></p>
				<p class="boxcart-stat-card__value"><?php echo esc_html( $ready_orders ); ?></p>
				<a href="<?php echo esc_url( admin_url( 'admin.php?page=boxcart-orders&status=ready' ) ); ?>" class="boxcart-stat-card__link">
					<?php esc_html_e( 'View all', 'boxcart' ); ?> &rarr;
				</a>
			</div>
		</div>

		<!-- Recent Orders -->
		<div class="boxcart-card">
			<div class="boxcart-card__header">
				<h3 class="boxcart-card__title"><?php esc_html_e( 'Recent Orders', 'boxcart' ); ?></h3>
				<a href="<?php echo esc_url( admin_url( 'admin.php?page=boxcart-orders' ) ); ?>" class="boxcart-card__action">
					<?php esc_html_e( 'View All', 'boxcart' ); ?>
				</a>
			</div>

			<?php if ( ! empty( $recent_orders ) ) : ?>
				<table class="boxcart-table boxcart-table--hover">
					<thead>
						<tr>
							<th><?php esc_html_e( 'Order', 'boxcart' ); ?></th>
							<th><?php esc_html_e( 'Customer', 'boxcart' ); ?></th>
							<th><?php esc_html_e( 'Location', 'boxcart' ); ?></th>
							<th><?php esc_html_e( 'Slot', 'boxcart' ); ?></th>
							<th><?php esc_html_e( 'Status', 'boxcart' ); ?></th>
						</tr>
					</thead>
					<tbody>
						<?php foreach ( $recent_orders as $order_row ) : ?>
							<?php
							$order_url    = admin_url( 'admin.php?page=boxcart-orders&action=view&id=' . $order_row['id'] );
							$status_class = isset( $status_classes[ $order_row['status'] ] ) ? $status_classes[ $order_row['status'] ] : 'boxcart-badge--neutral';
							$status_label = isset( BoxCart_Order::STATUSES[ $order_row['status'] ] ) ? BoxCart_Order::STATUSES[ $order_row['status'] ] : ucfirst( $order_row['status'] );

							// Format slot date/time.
							$slot_date = ! empty( $order_row['slot_date'] ) ? gmdate( 'j M', strtotime( $order_row['slot_date'] ) ) : '';
							$slot_time = '';
							if ( ! empty( $order_row['slot_time_start'] ) && ! empty( $order_row['slot_time_end'] ) ) {
								$slot_time = gmdate( 'g:ia', strtotime( $order_row['slot_time_start'] ) ) . '-' . gmdate( 'g:ia', strtotime( $order_row['slot_time_end'] ) );
							}
							?>
							<tr onclick="window.location='<?php echo esc_url( $order_url ); ?>';" style="cursor: pointer;">
								<td>
									<a href="<?php echo esc_url( $order_url ); ?>" class="boxcart-link--primary">
										<?php echo esc_html( $order_row['order_number'] ); ?>
									</a>
								</td>
								<td>
									<?php echo esc_html( $order_row['customer_first_name'] . ' ' . $order_row['customer_last_name'] ); ?>
								</td>
								<td>
									<?php echo esc_html( $order_row['location_name'] ?: '—' ); ?>
								</td>
								<td>
									<?php if ( $slot_date ) : ?>
										<?php echo esc_html( $slot_date ); ?>
										<?php if ( $slot_time ) : ?>
											<span class="boxcart-text--muted"><?php echo esc_html( $slot_time ); ?></span>
										<?php endif; ?>
									<?php else : ?>
										—
									<?php endif; ?>
								</td>
								<td>
									<span class="boxcart-badge <?php echo esc_attr( $status_class ); ?>">
										<?php echo esc_html( $status_label ); ?>
									</span>
								</td>
							</tr>
						<?php endforeach; ?>
					</tbody>
				</table>
			<?php else : ?>
				<div class="boxcart-empty-state boxcart-empty-state--compact">
					<span class="dashicons dashicons-clipboard"></span>
					<p><?php esc_html_e( 'No orders yet. Orders will appear here once customers start placing them.', 'boxcart' ); ?></p>
				</div>
			<?php endif; ?>
		</div>

		<!-- Two Column Layout -->
		<div class="boxcart-dashboard-grid">
			<!-- Today's Availability -->
			<div class="boxcart-card">
				<div class="boxcart-card__header">
					<h3 class="boxcart-card__title"><?php esc_html_e( "Today's Availability", 'boxcart' ); ?></h3>
				</div>

				<?php if ( ! empty( $today_availability ) ) : ?>
					<div class="boxcart-availability-list">
						<?php foreach ( $today_availability as $avail ) : ?>
							<?php
							$location   = $avail['location'];
							$capacity   = $avail['capacity'];
							$booked     = $avail['booked'];
							$available  = max( 0, $capacity - $booked );
							$percentage = $capacity > 0 ? min( 100, ( $booked / $capacity ) * 100 ) : 0;

							// Determine progress bar colour.
							$progress_class = 'boxcart-progress--success';
							if ( $percentage >= 90 ) {
								$progress_class = 'boxcart-progress--danger';
							} elseif ( $percentage >= 70 ) {
								$progress_class = 'boxcart-progress--warning';
							}
							?>
							<div class="boxcart-availability-item">
								<div class="boxcart-availability-item__header">
									<span class="boxcart-availability-item__name">
										<?php echo esc_html( $location->get_name() ); ?>
									</span>
									<span class="boxcart-availability-item__count">
										<?php
										printf(
											/* translators: 1: booked count, 2: total capacity */
											esc_html__( '%1$d of %2$d slots booked', 'boxcart' ),
											(int) $booked,
											(int) $capacity
										);
										?>
									</span>
								</div>
								<div class="boxcart-progress <?php echo esc_attr( $progress_class ); ?>">
									<div class="boxcart-progress__bar" style="width: <?php echo esc_attr( $percentage ); ?>%;"></div>
								</div>
							</div>
						<?php endforeach; ?>
					</div>
				<?php else : ?>
					<div class="boxcart-empty-state boxcart-empty-state--compact">
						<span class="dashicons dashicons-calendar-alt"></span>
						<p><?php esc_html_e( 'No collection slots scheduled for today.', 'boxcart' ); ?></p>
					</div>
				<?php endif; ?>
			</div>

			<!-- Quick Actions -->
			<div class="boxcart-card">
				<div class="boxcart-card__header">
					<h3 class="boxcart-card__title"><?php esc_html_e( 'Quick Actions', 'boxcart' ); ?></h3>
				</div>
				<div class="boxcart-quick-actions">
					<a href="<?php echo esc_url( admin_url( 'admin.php?page=boxcart-products&action=new' ) ); ?>" class="boxcart-quick-action">
						<span class="dashicons dashicons-plus-alt2"></span>
						<span><?php esc_html_e( 'Add New Product', 'boxcart' ); ?></span>
					</a>
					<a href="<?php echo esc_url( admin_url( 'admin.php?page=boxcart-locations' ) ); ?>" class="boxcart-quick-action">
						<span class="dashicons dashicons-location"></span>
						<span><?php
						/* translators: %s: pickup-location menu label (Pickup Location on Free, Locations on Pro). */
						printf( esc_html__( 'Manage %s', 'boxcart' ), esc_html( apply_filters( 'boxcart_locations_menu_label', __( 'Pickup Location', 'boxcart' ) ) ) );
						?></span>
					</a>
					<a href="<?php echo esc_url( admin_url( 'admin.php?page=boxcart-orders' ) ); ?>" class="boxcart-quick-action">
						<span class="dashicons dashicons-clipboard"></span>
						<span><?php esc_html_e( 'View All Orders', 'boxcart' ); ?></span>
					</a>
					<a href="<?php echo esc_url( admin_url( 'admin.php?page=boxcart-settings' ) ); ?>" class="boxcart-quick-action">
						<span class="dashicons dashicons-admin-generic"></span>
						<span><?php esc_html_e( 'Settings', 'boxcart' ); ?></span>
					</a>
				</div>
			</div>
		</div>
	<?php endif; ?>
</div>