<?php
if ( ! defined( 'ABSPATH' ) ) {
	exit;
}

class Awp_Top_Authors extends WP_Widget {
	protected $defaults;

	function __construct() {
		$this->defaults = array(
			'title'        => __( 'Top Authors', 'advance-widget-pack' ),
			'author_count' => '5',
			'rank_by'      => 'views',
			'show_avatar'  => '1',
			'show_count'   => '1',
		);
		$widget_ops = array(
			'classname'   => 'awp_top_authors awp_widget',
			'description' => __( 'Widget to rank authors by total post views or comments.', 'advance-widget-pack' ),
		);
		$control_ops = array(
			'id_base' => 'awp_top_authors',
			'width'   => 200,
			'height'  => 250,
		);
		parent::__construct( 'awp_top_authors', __( 'AWP Top Authors', 'advance-widget-pack' ), $widget_ops, $control_ops );
	}

	public function widget( $args, $instance ) {
		$instance     = wp_parse_args( (array) $instance, $this->defaults );
		$title        = apply_filters( 'widget_title', $instance['title'] );
		$author_count = absint( $instance['author_count'] );
		$rank_by      = 'comments' === $instance['rank_by'] ? 'comments' : 'views';
		$show_avatar  = ! empty( $instance['show_avatar'] );
		$show_count   = ! empty( $instance['show_count'] );

		$rows = self::get_rows( $rank_by, $author_count );

		if ( ! $rows ) {
			return;
		}

		echo $args['before_widget']; // phpcs:ignore WordPress.Security.EscapeOutput.OutputNotEscaped -- sidebar-provided wrapper markup, trusted per WP core convention.
		if ( ! empty( $title ) ) {
			echo $args['before_title'] . esc_html( $title ) . $args['after_title']; // phpcs:ignore WordPress.Security.EscapeOutput.OutputNotEscaped -- title text is esc_html()'d; before/after_title are sidebar-provided wrapper markup.
		}

		self::render_rows( $rows, $rank_by, $show_avatar, $show_count );

		echo $args['after_widget']; // phpcs:ignore WordPress.Security.EscapeOutput.OutputNotEscaped -- sidebar-provided wrapper markup, trusted per WP core convention.
	}

	/**
	 * Fetches ranked author rows (author_id, total), using the shared
	 * transient cache. Used by both the widget and the Top Authors block.
	 *
	 * @param string $rank_by      'views' or 'comments'.
	 * @param int    $author_count Max number of authors to fetch.
	 * @return array[] Array of objects with author_id and total properties.
	 */
	public static function get_rows( $rank_by, $author_count ) {
		$rank_by      = 'comments' === $rank_by ? 'comments' : 'views';
		$author_count = absint( $author_count );

		// View counts change on nearly every pageview, so (unlike post lists)
		// this cache is intentionally NOT invalidated via awp_cache_generation()
		// when a view is recorded — that would defeat caching almost entirely
		// under real traffic. It refreshes via the 15-minute TTL below, and
		// still gets invalidated immediately by the generation bump on new/edited posts.
		$cache_key = 'awp_top_authors_' . $rank_by . '_' . awp_cache_generation() . '_' . $author_count;
		$rows      = get_transient( $cache_key );

		if ( false === $rows ) {
			global $wpdb;

			if ( 'comments' === $rank_by ) {
				// Total approved comments received across each author's published posts.
				// phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching -- no core API for this aggregate; result is cached via the transient wrapping this whole block.
				$rows = $wpdb->get_results(
					$wpdb->prepare(
						"SELECT p.post_author AS author_id, COUNT(c.comment_ID) AS total
						FROM {$wpdb->posts} p
						INNER JOIN {$wpdb->comments} c ON c.comment_post_ID = p.ID AND c.comment_approved = '1'
						WHERE p.post_type = 'post' AND p.post_status = 'publish'
						GROUP BY p.post_author
						ORDER BY total DESC
						LIMIT %d",
						$author_count
					)
				);
			} else {
				// Total views (wp_views postmeta) summed across each author's published posts.
				// phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching -- no core API for this aggregate; result is cached via the transient wrapping this whole block.
				$rows = $wpdb->get_results(
					$wpdb->prepare(
						"SELECT p.post_author AS author_id, SUM(CAST(pm.meta_value AS UNSIGNED)) AS total
						FROM {$wpdb->posts} p
						INNER JOIN {$wpdb->postmeta} pm ON pm.post_id = p.ID AND pm.meta_key = 'wp_views'
						WHERE p.post_type = 'post' AND p.post_status = 'publish'
						GROUP BY p.post_author
						ORDER BY total DESC
						LIMIT %d",
						$author_count
					)
				);
			}

			set_transient( $cache_key, $rows, 15 * MINUTE_IN_SECONDS );
		}

		return $rows;
	}

	/**
	 * Renders the ranked author <ul>. Shared by the widget and the Top
	 * Authors block's render.php.
	 *
	 * @param array[] $rows        Rows from get_rows().
	 * @param string  $rank_by     'views' or 'comments'.
	 * @param bool    $show_avatar Whether to show each author's avatar.
	 * @param bool    $show_count  Whether to show the view/comment total.
	 */
	public static function render_rows( $rows, $rank_by, $show_avatar, $show_count ) {
		echo '<ul class="awp-list awp-top-authors-list">';
		foreach ( $rows as $rank => $row ) {
			$author_id = (int) $row->author_id;
			$author    = get_userdata( $author_id );
			if ( ! $author ) {
				continue;
			}
			?>
			<li class="awp-post-item awp-top-author-item">
				<span class="awp-top-author-rank"><?php echo esc_html( $rank + 1 ); ?>.</span>
				<?php if ( $show_avatar ) : ?>
					<span class="awp-top-author-avatar"><?php echo get_avatar( $author_id, 32 ); // phpcs:ignore WordPress.Security.EscapeOutput.OutputNotEscaped -- get_avatar() output is escaped by core. ?></span>
				<?php endif; ?>
				<a class="awp-top-author-name" href="<?php echo esc_url( get_author_posts_url( $author_id ) ); ?>">
					<?php echo esc_html( $author->display_name ); ?>
				</a>
				<?php if ( $show_count ) : ?>
					<span class="awp-top-author-count">
						<?php
						echo esc_html(
							'comments' === $rank_by
								/* translators: %s: number of comments. */
								? sprintf( _n( '%s comment', '%s comments', (int) $row->total, 'advance-widget-pack' ), number_format_i18n( (int) $row->total ) )
								/* translators: %s: number of views. */
								: sprintf( _n( '%s view', '%s views', (int) $row->total, 'advance-widget-pack' ), number_format_i18n( (int) $row->total ) )
						);
						?>
					</span>
				<?php endif; ?>
			</li>
			<?php
		}
		echo '</ul>';
	}

	public function form( $instance ) {
		$instance     = wp_parse_args( (array) $instance, $this->defaults );
		$title        = $instance['title'];
		$author_count = $instance['author_count'];
		?>
		<p>
			<label for="<?php echo esc_attr( $this->get_field_id( 'title' ) ); ?>"><?php esc_html_e( 'Title', 'advance-widget-pack' ); ?></label>
			<input class="widefat" id="<?php echo esc_attr( $this->get_field_id( 'title' ) ); ?>" name="<?php echo esc_attr( $this->get_field_name( 'title' ) ); ?>" type="text" value="<?php echo esc_attr( $title ); ?>" />
		</p>
		<p>
			<label for="<?php echo esc_attr( $this->get_field_id( 'author_count' ) ); ?>"><?php esc_html_e( 'Number of authors', 'advance-widget-pack' ); ?></label>
			<input class="widefat" id="<?php echo esc_attr( $this->get_field_id( 'author_count' ) ); ?>" name="<?php echo esc_attr( $this->get_field_name( 'author_count' ) ); ?>" type="number" min="1" max="20" value="<?php echo esc_attr( $author_count ); ?>">
		</p>
		<p>
			<input type="radio" id="<?php echo esc_attr( $this->get_field_id( 'rank_by' ) ); ?>_views"
				name="<?php echo esc_attr( $this->get_field_name( 'rank_by' ) ); ?>"
				<?php checked( $instance['rank_by'], 'views' ); ?>
				value="views"> <label for="<?php echo esc_attr( $this->get_field_id( 'rank_by' ) ); ?>_views"><?php esc_html_e( 'Rank by Views', 'advance-widget-pack' ); ?></label><br>
			<input type="radio" id="<?php echo esc_attr( $this->get_field_id( 'rank_by' ) ); ?>_comments"
				name="<?php echo esc_attr( $this->get_field_name( 'rank_by' ) ); ?>"
				<?php checked( $instance['rank_by'], 'comments' ); ?>
				value="comments"> <label for="<?php echo esc_attr( $this->get_field_id( 'rank_by' ) ); ?>_comments"><?php esc_html_e( 'Rank by Comments', 'advance-widget-pack' ); ?></label>
		</p>
		<p>
			<input class="checkbox" type="checkbox" <?php checked( $instance['show_avatar'], 'on' ); ?> id="<?php echo esc_attr( $this->get_field_id( 'show_avatar' ) ); ?>" name="<?php echo esc_attr( $this->get_field_name( 'show_avatar' ) ); ?>" />
			<label for="<?php echo esc_attr( $this->get_field_id( 'show_avatar' ) ); ?>"><?php esc_html_e( 'Show avatar', 'advance-widget-pack' ); ?></label>
		</p>
		<p>
			<input class="checkbox" type="checkbox" <?php checked( $instance['show_count'], 'on' ); ?> id="<?php echo esc_attr( $this->get_field_id( 'show_count' ) ); ?>" name="<?php echo esc_attr( $this->get_field_name( 'show_count' ) ); ?>" />
			<label for="<?php echo esc_attr( $this->get_field_id( 'show_count' ) ); ?>"><?php esc_html_e( 'Show count', 'advance-widget-pack' ); ?></label>
		</p>
		<?php
	}

	public function update( $new_instance, $old_instance ) {
		$instance                 = $old_instance;
		$instance['title']        = sanitize_text_field( $new_instance['title'] );
		$instance['author_count'] = max( 1, min( 20, absint( $new_instance['author_count'] ) ) );
		$instance['rank_by']      = 'comments' === ( $new_instance['rank_by'] ?? '' ) ? 'comments' : 'views';
		$instance['show_avatar']  = ! empty( $new_instance['show_avatar'] ) ? 'on' : '';
		$instance['show_count']   = ! empty( $new_instance['show_count'] ) ? 'on' : '';
		return $instance;
	}
}