<?php
namespace Academy\Lesson\LessonApi\Models;

if ( ! defined( 'ABSPATH' ) ) {
	exit;
}
use Exception;
class PostLesson extends Base\Lesson {

	protected function set_default(): void {
		$this->data = wp_parse_args( $this->data, [
			'ID'                => $this->id,
			'lesson_type'         => 'academy_lessons',
			'lesson_author'       => get_current_user_id(),
			'lesson_date'         => '',
			'lesson_date_gmt'     => '',
			'lesson_title'        => '',
			'lesson_name'         => '',
			'lesson_content'      => '',
			'lesson_excerpt'      => '',
			'lesson_status'       => 'draft',
			'comment_status'    => 'close',
			'comment_count'     => 0,
			'lesson_password'     => '',
			'lesson_modified'     => current_time( 'mysql' ),
			'lesson_modified_gmt' => current_time( 'mysql' ),
		] );
	}

	public function is_slug_available(): bool {
		$slug = $this->data['post_name']
			?? sanitize_title( $this->data['post_title'] ?? '' );

		// phpcs:ignore WordPress.DB.PreparedSQL.InterpolatedNotPrepared
		$sql = "SELECT ID
				FROM {$this->wpdb->posts} 
				WHERE post_name = %s
				LIMIT 1";

		$found_id = (int) $this->wpdb->get_var(
			$this->wpdb->prepare(// phpcs:ignore WordPress.DB.PreparedSQL.NotPrepared
				$sql, $slug// phpcs:ignore WordPress.DB.PreparedSQL.NotPrepared
			)
		);

		return ( 0 === $found_id || $found_id === (int) $this->id );
	}

	public static function by_id( int $id, bool $skip_meta = false, ?int $author = null, ?string $status = null ): self {
		if ( null !== $author ) {
			$posts = get_posts( [
				'post_type' => 'academy_lessons',
				'p'         => $id,
				'author'    => $author,
				'post_status' => null === $status ? 'any' : $status,
				'numberposts' => 1,
			], ARRAY_A );
			$post = $posts ? $posts[0] : null;
		} else {
			$post = get_post( $id, ARRAY_A );
		}

		return self::get_lesson( (array) $post, new self(), $skip_meta );
	}

	public static function by_slug( string $slug, bool $skip_meta = false, ?int $author = null ): self {
		if ( null !== $author ) {
			$posts = get_posts( [
				'post_type'   => 'academy_lessons',
				'name'        => $slug,
				'author'      => $author,
				'post_status' => 'any',
				'numberposts' => 1,
			] );
			$post = $posts ? $posts[0] : null;
		} else {
			$post = get_page_by_path( $slug, ARRAY_A, 'academy_lessons' );
		}

		return self::get_lesson( (array) $post, new self(), $skip_meta );
	}
	public static function by_title( string $title, bool $skip_meta = false, ?int $author = null ): self {
		$ins = new self();

		$sql = "SELECT * FROM {$ins->wpdb->posts} WHERE post_title = %s";
		$params = [ $title ];

		if ( null !== $author ) {
			$sql .= ' AND post_author = %d';
			$params[] = $author;
		}

		return self::get_lesson(
			$ins->wpdb->get_row(
				$ins->wpdb->prepare( $sql, ...$params ), // phpcs:ignore WordPress.DB.PreparedSQL.NotPrepared
				ARRAY_A
			),
			$ins,
			$skip_meta
		);
	}

	public static function get_lesson( ?array $data, self $ins, bool $skip_meta = false ): self {
		if ( is_array( $data ) && isset( $data['ID'] ) && 'academy_lessons' === $data['post_type'] ) {
			$meta_data = $skip_meta ? [] : $ins->wpdb->get_results(
				$ins->wpdb->prepare(// phpcs:ignore WordPress.DB.PreparedSQL.NotPrepared
					"SELECT meta_key, meta_value FROM {$ins->wpdb->postmeta} WHERE post_id = %d", // phpcs:ignore WordPress.DB.PreparedSQL.InterpolatedNotPrepared
					$data['ID']// phpcs:ignore WordPress.DB.PreparedSQL.NotPrepared
				),
				ARRAY_A
			);
			$ins->load_stored_data( array_intersect_key( $data, $ins->data ) );
			$ins->set_meta_data( is_array( $meta_data ) ? array_column( $meta_data, 'meta_value', 'meta_key' ) : [] );
			return $ins;
		}
		throw new Exception( esc_html__( 'Invalid Lesson ID.', 'academy' ) );
	}

	public static function get_total_number_of_lessons( string $status = 'any', int $user_id = 0 ): int {
		$ins = new self();
		$query = $ins->wpdb->prepare( "SELECT COUNT(*) FROM {$ins->wpdb->posts} WHERE post_type = %s ", 'academy_lessons' );// phpcs:ignore WordPress.DB.PreparedSQL.InterpolatedNotPrepared
		if ( 'any' !== $status ) {
			$query .= $ins->wpdb->prepare( ' AND post_status = %s', $status );
		}
		if ( $user_id ) {
			$query .= $ins->wpdb->prepare( ' AND post_author = %d', $user_id );
		}
		// phpcs:ignore WordPress.DB.PreparedSQL.NotPrepared
		return (int) $ins->wpdb->get_var( $query );
	}
	public static function get_slug_by_id( int $id ): ?string {
		$ins = new self();
		return $ins->wpdb->get_row(
			$ins->wpdb->prepare(// phpcs:ignore WordPress.DB.PreparedSQL.NotPrepared
				"SELECT post_name FROM {$ins->wpdb->posts} WHERE ID = %d", // phpcs:ignore WordPress.DB.PreparedSQL.InterpolatedNotPrepared
				$id// phpcs:ignore WordPress.DB.PreparedSQL.NotPrepared
			),
			ARRAY_A
		)['post_name'] ?? null;
	}
	public static function get_title_by_id( int $id ): ?string {
		$ins = new self();
		return $ins->wpdb->get_row(
			$ins->wpdb->prepare(// phpcs:ignore WordPress.DB.PreparedSQL.NotPrepared
				"SELECT post_title FROM {$ins->wpdb->posts} WHERE ID = %d", // phpcs:ignore WordPress.DB.PreparedSQL.InterpolatedNotPrepared
				$id// phpcs:ignore WordPress.DB.PreparedSQL.NotPrepared
			),
			ARRAY_A
		)['post_title'] ?? null;
	}
	public static function get_lesson_meta_data( int $id ): array {
		$ins = new self();
		return $ins->set_meta_data( array_column( $ins->wpdb->get_results(
			$ins->wpdb->prepare(// phpcs:ignore WordPress.DB.PreparedSQL.NotPrepared
				"SELECT meta_key, meta_value FROM {$ins->wpdb->postmeta} WHERE post_id = %d", // phpcs:ignore WordPress.DB.PreparedSQL.InterpolatedNotPrepared
				$id// phpcs:ignore WordPress.DB.PreparedSQL.NotPrepared
			),
			ARRAY_A
		) ?? [], 'meta_value', 'meta_key' ) )->get_data()['meta'] ?? [];
	}
	public static function get_lesson_meta( int $id, string $key ) {
		$value = get_post_meta( $id, $key, true );
		if ( '' === $value || null === $value ) {
			return $value;
		}

		// Same shape as the lessons table gives: values kept as JSON come back
		// as arrays, which is what the templates read.
		$ins = new self();
		$ins->set_meta_data( [ $key => $value ] );

		return $ins->get_data()['meta'][ $key ] ?? $value;
	}

	protected function inspect_key( string $key, bool $is_meta = false ): string {
		return $is_meta ? $key : preg_replace( '|^lesson_|i', 'post_', $key );
	}

	public function get_data(): array {
		$output = parent::get_data();
		foreach ( $output as $key => $value ) {
			unset( $output[ $key ] );
			$output[ preg_replace( '|^post_|i', 'lesson_', $key ) ] = $value;
		}
		return $output;
	}

	public function save_data(): void {
		if ( array_key_exists( 'ID', $this->data ) && absint( $this->data['ID'] ) === 0 ) {
			unset( $this->data['ID'] );
		}

		if ( ! array_key_exists( 'ID', $this->data ) ) {
			$this->is_insert = true;
		}

		if ( empty( $this->data['post_name'] ?? '' ) ) {
			unset( $this->data['post_name'] );
		} else {
			$this->data['post_name'] = sanitize_title( $this->data['post_name'] );
		}

		if ( false === $this->ignore_slug_check && ! $this->is_slug_available() ) {
			throw new Exception( esc_html__( 'Slug is not available.', 'academy' ) );
		}

		$id = wp_insert_post( $this->data );

		if ( is_wp_error( $id ) ) {
			throw new Exception( ( $this->data['ID'] ?? false ) > 0 ? esc_html__( 'Lesson update failed. An unexpected error occurred.', 'academy' ) : esc_html__( 'Failed to create Lesson.', 'academy' ) );
		}
		$this->id = $id;
	}

	public function save_meta_data(): void {
		$meta = apply_filters( 'academy/lesson/set_meta_data', [] );
		if ( $this->is_insert && ! empty( $meta ) ) {
			$this->set_meta_data( $meta );
		}
		if ( ! empty( $this->id ) && is_array( $this->meta ) && count( $this->meta ) > 0 ) {
			$this->update_meta();
		}
	}
	public function delete(): void {
		if ( empty( wp_delete_post( $this->id, true ) ) ) {
			throw new Exception( esc_html__( 'Lesson deletion failed. Please try again.', 'academy' ) );
		}
	}

	public function update_meta(): void {
		global $wpdb;

		$table = $wpdb->postmeta;

		$keys = array_keys( $this->meta );

		$placeholders = implode( ',', array_fill( 0, count( $keys ), '%s' ) );

		// phpcs:disable WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching, WordPress.DB.PreparedSQLPlaceholders.UnfinishedPrepare, WordPress.DB.PreparedSQLPlaceholders.ReplacementsWrongNumber -- custom query with no WP API equivalent
		$existing_keys = $wpdb->get_col( $wpdb->prepare(// phpcs:ignore WordPress.DB.PreparedSQL.NotPrepared
			"SELECT meta_key FROM $table WHERE post_id = %d AND meta_key IN ($placeholders)", // phpcs:ignore WordPress.DB.PreparedSQL.InterpolatedNotPrepared
			$this->id, ...$keys// phpcs:ignore WordPress.DB.PreparedSQL.NotPrepared
		) );
		// phpcs:enable WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching, WordPress.DB.PreparedSQLPlaceholders.UnfinishedPrepare, WordPress.DB.PreparedSQLPlaceholders.ReplacementsWrongNumber

		foreach ( $this->meta as $key => $value ) {
			if ( is_array( $value ) || is_object( $value ) ) {
				$value = wp_json_encode( $value );
			}
			if ( in_array( $key, $existing_keys, true ) ) {
				// Update
				// phpcs:disable WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching, WordPress.DB.SlowDBQuery.slow_db_query_meta_value -- custom query with no WP API equivalent; meta/tax lookup the feature depends on; no cheaper equivalent
				$wpdb->update(
					$table,
					[ 'meta_value' => $value ],
					[
						'post_id' => $this->id,
						'meta_key' => $key
					]
				);
				// phpcs:enable WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching, WordPress.DB.SlowDBQuery.slow_db_query_meta_value
			} else {
				// Insert
				// phpcs:disable WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.SlowDBQuery.slow_db_query_meta_value -- custom query with no WP API equivalent; meta/tax lookup the feature depends on; no cheaper equivalent
				$wpdb->insert(
					$table,
					[
						'post_id'    => $this->id,
						'meta_key'   => $key,
						'meta_value' => $value
					]
				);
				// phpcs:enable WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.SlowDBQuery.slow_db_query_meta_value
			}//end if
		}//end foreach
	}
}