<?php
/**
 * Admin: the dashboard (P3), opened by "PAYGRAB" in the menu. Separate from the settings.
 *
 * @package PAYGRAB
 */

defined( 'ABSPATH' ) || exit;

// phpcs:disable PluginCheck.Security.DirectDB.UnescapedDBParameter -- PAYGRAB's own order tables: the names come from Paygrab_Install::tables() (prefix + fixed names), never from input, and orders are always read fresh.

/**
 * Dashboard.
 */
class Paygrab_Admin_Dashboard {

	/** Set once the seller has seen "Ready to sell". */
	const READY_SEEN = 'paygrab_ready_seen';

	/**
	 * Steps before selling, with where to do them.
	 *
	 * @return array<int,array{label:string,done:bool,url:string,button:string}>
	 */
	public static function checks() {
		$settings = admin_url( 'admin.php?page=' . Paygrab_Settings_Page::SLUG );
		$protect  = Paygrab_Files::last_check();
		$pages    = paygrab_page_url( 'checkout' ) && paygrab_page_url( 'mypage' ) && paygrab_page_url( 'register' ) && paygrab_page_url( 'login' ) && paygrab_page_url( 'tokushoho' );
		$product  = (bool) get_posts(
			array(
				'post_type'      => Paygrab_Product::TYPE,
				'post_status'    => 'publish',
				'posts_per_page' => 1,
				'fields'         => 'ids',
			)
		);
		return array(
			array( 'label' => __( 'Create the pages (done automatically)', 'paygrab' ), 'done' => $pages, 'url' => $settings . '#pages', 'button' => __( 'Check the pages', 'paygrab' ) ),
			array(
				'label'  => Paygrab_Gateways::bank_only() ? __( 'Enter the bank account', 'paygrab' ) : __( 'Set up a way to pay', 'paygrab' ),
				'done'   => Paygrab_Gateways::ready(),
				'url'    => $settings . '#payment',
				'button' => Paygrab_Gateways::bank_only() ? __( 'Enter the bank account', 'paygrab' ) : __( 'Set up payments', 'paygrab' ),
			),
			array( 'label' => __( 'Fill in the legal notice', 'paygrab' ), 'done' => ! Paygrab_Settings::missing_law_items(), 'url' => $settings . '#law', 'button' => __( 'Fill in the legal notice', 'paygrab' ) ),
			array( 'label' => __( 'Check that files cannot be opened from outside', 'paygrab' ), 'done' => is_array( $protect ) && 'ok' === $protect['status'], 'url' => $settings . '#protect', 'button' => __( 'Check the file protection', 'paygrab' ) ),
			array( 'label' => __( 'Check that test emails arrive', 'paygrab' ), 'done' => (bool) get_option( 'paygrab_test_mail_sent' ), 'url' => $settings . '#mail', 'button' => __( 'Send a test email', 'paygrab' ) ),
			array( 'label' => __( 'Create your first product', 'paygrab' ), 'done' => $product, 'url' => Paygrab_Admin_Products::form_url(), 'button' => __( 'Add new product', 'paygrab' ) ),
		);
	}

	/**
	 * UTC datetime of the first moment of a month (site time).
	 *
	 * @param string $modify e.g. 'first day of this month', 'first day of last month'.
	 * @return string
	 */
	private static function month_start( $modify ) {
		return ( new DateTimeImmutable( $modify . ' 00:00', wp_timezone() ) )->setTimezone( new DateTimeZone( 'UTC' ) )->format( 'Y-m-d H:i:s' );
	}

	/**
	 * Days until a deadline (site time), and the text for it.
	 *
	 * @param string $gmt Deadline in UTC.
	 * @return array{text:string,soon:bool}
	 */
	private static function due( $gmt ) {
		$tz    = wp_timezone();
		$today = new DateTimeImmutable( 'today', $tz );
		$day   = ( new DateTimeImmutable( $gmt . ' UTC' ) )->setTimezone( $tz )->setTime( 0, 0 );
		$days  = (int) $today->diff( $day )->format( '%r%a' );
		$date  = wp_date( 'n/j', strtotime( $gmt . ' UTC' ) );
		if ( $days < 0 ) {
			/* translators: %s: date */
			return array( 'text' => sprintf( __( 'Due %s (passed)', 'paygrab' ), $date ), 'soon' => true );
		}
		if ( $days <= 1 ) {
			/* translators: 1: today / tomorrow, 2: date */
			return array( 'text' => sprintf( __( 'Due %1$s (%2$s)', 'paygrab' ), 0 === $days ? __( 'today', 'paygrab' ) : __( 'tomorrow', 'paygrab' ), $date ), 'soon' => true );
		}
		/* translators: 1: date, 2: number of days */
		return array( 'text' => sprintf( __( 'Due %1$s (%2$d days left)', 'paygrab' ), $date, $days ), 'soon' => false );
	}

	/**
	 * The screen.
	 *
	 * @return void
	 */
	public static function render() {
		if ( ! current_user_can( 'manage_options' ) ) {
			return;
		}
		$checks  = self::checks();
		$done    = count( array_filter( wp_list_pluck( $checks, 'done' ) ) );
		$left    = count( $checks ) - $done;
		$ready   = 0 === $left;
		$first   = $ready && ! get_option( self::READY_SEEN );
		if ( $first ) {
			update_option( self::READY_SEEN, time(), false );
		}
		$protect = Paygrab_Files::last_check();

		$this_month = self::month_start( 'first day of this month' );
		$next_month = self::month_start( 'first day of next month' );
		$last_month = self::month_start( 'first day of last month' );
		$now        = Paygrab_Orders::stats_between( $this_month, $next_month );
		$before     = Paygrab_Orders::stats_between( $last_month, $this_month );
		$diff       = $now['total'] - $before['total'];
		$counts     = Paygrab_Orders::count_by_status();
		$selling    = count( Paygrab_Admin_Products::selling_ids() );
		$bank       = Paygrab_Gateways::get( 'bank_manual' );
		$by_hand    = $bank && $bank->is_available();
		$pending    = $by_hand ? Paygrab_Orders::query( array( 'status' => 'pending', 'per_page' => 20 ) )['items'] : array();
		// Only orders the seller confirms by hand; payments that the gateway confirms (Stripe) are left out.
		$by_gateway = static function ( $id ) {
			$gateway = Paygrab_Gateways::get( (string) $id );
			return $gateway && $gateway->confirms_payments();
		};
		$pending    = array_slice( array_values( array_filter( $pending, static fn( $o ) => ! $by_gateway( $o->gateway ) ) ), 0, 5 );
		$automatic  = 0;
		foreach ( Paygrab_Orders::count_pending_by_gateway() as $paygrab_gateway => $paygrab_count ) {
			$automatic += $by_gateway( $paygrab_gateway ) ? $paygrab_count : 0;
		}
		$recent     = Paygrab_Orders::latest( 5 );
		$settings = admin_url( 'admin.php?page=' . Paygrab_Settings_Page::SLUG );
		?>
		<div class="wrap paygrab-admin paygrab-dash">
			<div class="paygrab-dash__top">
				<h1><?php esc_html_e( 'Dashboard', 'paygrab' ); ?></h1>
				<a class="button button-primary" href="<?php echo esc_url( Paygrab_Admin_Products::form_url() ); ?>"><?php esc_html_e( 'Add new product', 'paygrab' ); ?></a>
			</div>
			<hr class="wp-header-end">

			<?php if ( is_array( $protect ) && 'exposed' === $protect['status'] ) : ?>
				<section class="paygrab-band is-bad">
					<div><strong><?php esc_html_e( 'The files you sell can be opened from outside.', 'paygrab' ); ?></strong> <?php esc_html_e( 'Your server ignores the protection file (nginx). Add the setting shown on the file protection screen.', 'paygrab' ); ?></div>
					<a class="button" href="<?php echo esc_url( $settings . '#protect' ); ?>"><?php esc_html_e( 'Check the file protection', 'paygrab' ); ?></a>
				</section>
			<?php endif; ?>

			<?php if ( ! $ready ) : ?>
				<section class="paygrab-band">
					<div class="paygrab-band__text">
						<strong>
							<?php
							/* translators: %d: number of steps left */
							echo esc_html( sprintf( _n( '%d step left before you can sell', '%d steps left before you can sell', $left, 'paygrab' ), $left ) );
							?>
						</strong>
						<span class="paygrab-band__count">
							<?php
							/* translators: 1: steps done, 2: all steps */
							echo esc_html( sprintf( __( '(%1$d of %2$d done)', 'paygrab' ), $done, count( $checks ) ) );
							?>
						</span>
						<div class="paygrab-band__bar"><i style="width:<?php echo esc_attr( (string) round( 100 * $done / count( $checks ) ) ); ?>%"></i></div>
					</div>
					<div class="paygrab-band__buttons">
						<?php foreach ( $checks as $paygrab_check ) : ?>
							<?php if ( ! $paygrab_check['done'] ) : ?>
								<a class="button" href="<?php echo esc_url( $paygrab_check['url'] ); ?>"><?php echo esc_html( $paygrab_check['button'] ); ?></a>
							<?php endif; ?>
						<?php endforeach; ?>
					</div>
				</section>
			<?php elseif ( $first ) : ?>
				<section class="paygrab-band is-ok">
					<div><strong><?php esc_html_e( 'You are ready to sell.', 'paygrab' ); ?></strong> <?php esc_html_e( 'Paste the shortcode of a product into a post to start selling.', 'paygrab' ); ?></div>
				</section>
			<?php endif; ?>

			<div class="paygrab-tiles">
				<div class="paygrab-tile">
					<div class="paygrab-tile__label"><?php esc_html_e( 'Sales this month (paid)', 'paygrab' ); ?></div>
					<div class="paygrab-tile__value"><?php echo esc_html( paygrab_price( $now['total'] ) ); ?></div>
					<div class="paygrab-tile__sub<?php echo $diff > 0 ? ' is-up' : ''; ?>">
						<?php
						/* translators: %s: difference such as +¥8,200 */
						echo esc_html( sprintf( __( '%s from last month', 'paygrab' ), ( $diff >= 0 ? '+' : '−' ) . paygrab_price( abs( $diff ) ) ) );
						?>
					</div>
				</div>
				<div class="paygrab-tile">
					<div class="paygrab-tile__label"><?php esc_html_e( 'Orders this month', 'paygrab' ); ?></div>
					<div class="paygrab-tile__value">
						<?php
						/* translators: %d: number of orders */
						echo esc_html( sprintf( _n( '%d order', '%d orders', $now['orders'], 'paygrab' ), $now['orders'] ) );
						?>
					</div>
					<div class="paygrab-tile__sub">
						<?php
						/* translators: %d: number of cancelled orders */
						echo esc_html( sprintf( _n( '%d cancelled', '%d cancelled', $now['cancelled'], 'paygrab' ), $now['cancelled'] ) );
						?>
					</div>
				</div>
				<div class="paygrab-tile">
					<div class="paygrab-tile__label"><?php esc_html_e( 'Awaiting payment', 'paygrab' ); ?></div>
					<div class="paygrab-tile__value is-pending">
						<?php
						/* translators: %d: number of orders */
						echo esc_html( sprintf( _n( '%d order', '%d orders', (int) $counts['pending'], 'paygrab' ), (int) $counts['pending'] ) );
						?>
					</div>
					<div class="paygrab-tile__sub">
						<?php if ( $automatic ) : ?>
							<?php /* translators: %d: number of orders */ ?>
							<span class="paygrab-tile__note"><?php echo esc_html( sprintf( _n( 'of which %d is confirmed automatically', 'of which %d are confirmed automatically', $automatic, 'paygrab' ), $automatic ) ); ?></span><br>
						<?php endif; ?>
						<a href="<?php echo esc_url( add_query_arg( 'status', 'pending', paygrab_admin_order_url() ) ); ?>"><?php esc_html_e( 'See them in Orders', 'paygrab' ); ?></a>
					</div>
				</div>
				<div class="paygrab-tile">
					<div class="paygrab-tile__label"><?php esc_html_e( 'Products on sale', 'paygrab' ); ?></div>
					<div class="paygrab-tile__value"><?php echo esc_html( (string) $selling ); ?></div>
					<div class="paygrab-tile__sub"><a href="<?php echo esc_url( Paygrab_Admin_Products::list_url() ); ?>"><?php esc_html_e( 'Go to the product list', 'paygrab' ); ?></a></div>
				</div>
			</div>

			<div class="paygrab-dash__cols">
				<section class="paygrab-card paygrab-dash__main">
					<?php if ( $by_hand ) : ?>
						<h2><?php esc_html_e( 'Orders that need payment confirmation (closest deadline first)', 'paygrab' ); ?><a href="<?php echo esc_url( add_query_arg( 'status', 'pending', paygrab_admin_order_url() ) ); ?>"><?php esc_html_e( 'See all', 'paygrab' ); ?></a></h2>
						<?php if ( ! $pending ) : ?>
							<p class="paygrab-card__empty"><?php esc_html_e( 'No orders need payment confirmation.', 'paygrab' ); ?></p>
						<?php endif; ?>
						<?php foreach ( $pending as $paygrab_order ) : ?>
							<?php
							$paygrab_due   = $paygrab_order->pay_deadline ? self::due( $paygrab_order->pay_deadline ) : array( 'text' => '', 'soon' => false );
							$paygrab_items = $paygrab_order->items();
							$paygrab_ask   = implode(
								"\n",
								array(
									__( 'Mark this order as paid? The customer is told by email.', 'paygrab' ),
									'',
									/* translators: %s: amount */
									sprintf( __( 'Amount: %s', 'paygrab' ), paygrab_price( $paygrab_order->total ) ),
									/* translators: %s: transfer number */
									sprintf( __( 'Transfer no.: %s', 'paygrab' ), $paygrab_order->transfer_code ),
									/* translators: %s: customer name */
									sprintf( __( 'Customer: %s', 'paygrab' ), $paygrab_order->billing_name ),
								)
							);
							?>
							<div class="paygrab-pending-row">
								<div class="paygrab-pending-row__who">
									<strong><?php echo esc_html( $paygrab_order->billing_name ); ?></strong><?php echo esc_html( paygrab_sep() ); ?><?php echo esc_html( $paygrab_items ? $paygrab_items[0]->name : $paygrab_order->order_number ); ?><br>
									<span class="paygrab-due<?php echo $paygrab_due['soon'] ? ' is-soon' : ''; ?>"><?php echo esc_html( $paygrab_due['text'] ); ?></span>
								</div>
								<span class="paygrab-code"><?php echo esc_html( $paygrab_order->transfer_code ); ?></span>
								<span><?php echo esc_html( paygrab_price( $paygrab_order->total ) ); ?></span>
								<form method="post" action="<?php echo esc_url( admin_url( 'admin-post.php' ) ); ?>" onsubmit="return window.confirm(<?php echo esc_attr( wp_json_encode( $paygrab_ask ) ); ?>);">
									<?php wp_nonce_field( 'paygrab_order_action' ); ?>
									<input type="hidden" name="action" value="paygrab_order_action">
									<input type="hidden" name="do" value="paid">
									<input type="hidden" name="ids[]" value="<?php echo esc_attr( (string) $paygrab_order->id ); ?>">
									<input type="hidden" name="back" value="<?php echo esc_url( admin_url( 'admin.php?page=' . Paygrab_Admin::SLUG ) ); ?>">
									<button type="submit" class="button button-primary"><?php esc_html_e( 'Confirm payment', 'paygrab' ); ?></button>
								</form>
							</div>
						<?php endforeach; ?>
					<?php else : ?>
						<h2><?php esc_html_e( 'Recently sold products', 'paygrab' ); ?></h2>
						<?php self::recent_products(); ?>
					<?php endif; ?>
				</section>
				<section class="paygrab-card paygrab-dash__side">
					<h2><?php esc_html_e( 'Recent orders', 'paygrab' ); ?></h2>
					<?php if ( ! $recent ) : ?>
						<p class="paygrab-card__empty"><?php esc_html_e( 'No orders yet.', 'paygrab' ); ?></p>
					<?php else : ?>
						<ul class="paygrab-recent">
							<?php foreach ( $recent as $paygrab_order ) : ?>
								<li>
									<a href="<?php echo esc_url( paygrab_admin_order_url( $paygrab_order->id ) ); ?>"><?php echo esc_html( paygrab_date( $paygrab_order->created_at, 'n/j' ) . ' ' . $paygrab_order->billing_name ); ?></a>
									<span class="paygrab-status paygrab-status--<?php echo esc_attr( $paygrab_order->status ); ?>"><?php echo esc_html( paygrab_status_label( $paygrab_order->status ) ); ?></span>
								</li>
							<?php endforeach; ?>
						</ul>
					<?php endif; ?>
				</section>
			</div>

			<?php if ( $ready && ! $first ) : ?>
				<p class="paygrab-dash__ready"><?php esc_html_e( 'All the steps before selling are done.', 'paygrab' ); ?></p>
			<?php endif; ?>
		</div>
		<?php
	}

	/**
	 * Products sold lately (when there are no bank transfers to confirm by hand).
	 *
	 * @return void
	 */
	private static function recent_products() {
		global $wpdb;
		$t    = Paygrab_Install::tables();
		$rows = $wpdb->get_results( $wpdb->prepare( "SELECT i.name, COUNT(*) AS n, MAX(o.paid_at) AS last FROM {$t['items']} i INNER JOIN {$t['orders']} o ON o.id = i.order_id WHERE o.status = 'paid' AND o.paid_at >= %s GROUP BY i.product_id, i.name ORDER BY last DESC LIMIT 5", paygrab_now( -30 * DAY_IN_SECONDS ) ) ); // phpcs:ignore WordPress.DB
		if ( ! $rows ) {
			echo '<p class="paygrab-card__empty">' . esc_html__( 'Nothing was sold in the last 30 days.', 'paygrab' ) . '</p>';
			return;
		}
		echo '<ul class="paygrab-recent">';
		foreach ( $rows as $row ) {
			/* translators: %d: number sold */
			echo '<li><span>' . esc_html( $row->name ) . '</span><span>' . esc_html( sprintf( _n( '%d sold', '%d sold', (int) $row->n, 'paygrab' ), (int) $row->n ) ) . '</span></li>';
		}
		echo '</ul>';
	}
}