<?php
defined( 'ABSPATH' ) || exit;

/**
 * Class AISP_Customer_Activity_Notes
 *
 * Handles customer follow-up notes and reminder dates stored in user_meta.
 * Registered as AJAX endpoints for inline editing in the Dormant Customers tab.
 *
 * Meta keys:
 *   aisp_ca_note          — text note (string)
 *   aisp_ca_reminder_date — reminder date (Y-m-d string, or empty)
 *
 * @since 1.2.0
 */
class AISP_Customer_Activity_Notes {

	const META_NOTE     = 'aisp_ca_note';
	const META_REMINDER = 'aisp_ca_reminder_date';
	const NONCE_ACTION  = 'aisp_ca_save_note';

	public static function init() {
		add_action( 'wp_ajax_aisp_ca_save_note', [ __CLASS__, 'ajax_save_note' ] );
		add_action( 'wp_ajax_aisp_ca_get_note',  [ __CLASS__, 'ajax_get_note'  ] );
	}

	// -------------------------------------------------------------------------
	// Getters
	// -------------------------------------------------------------------------

	public static function get_note( int $user_id ): string {
		return (string) get_user_meta( $user_id, self::META_NOTE, true );
	}

	public static function get_reminder( int $user_id ): string {
		return (string) get_user_meta( $user_id, self::META_REMINDER, true );
	}

	/**
	 * Bulk-fetch notes and reminders for a list of user IDs.
	 * Returns [ user_id => [ 'note' => '', 'reminder' => '' ], ... ]
	 */
	public static function get_bulk( array $user_ids ): array {
		global $wpdb;

		if ( empty( $user_ids ) ) {
			return [];
		}

		$ids_sql = implode( ',', array_map( 'intval', $user_ids ) );
		$keys    = [ self::META_NOTE, self::META_REMINDER ];
		$map     = [];

		foreach ( $user_ids as $id ) {
			$map[ (int) $id ] = [ 'note' => '', 'reminder' => '' ];
		}

		foreach ( $keys as $meta_key ) {
			// phpcs:ignore WordPress.DB.PreparedSQL.InterpolatedNotPrepared
			$rows = $wpdb->get_results( $wpdb->prepare(
				"SELECT user_id, meta_value FROM {$wpdb->usermeta}
				 WHERE meta_key = %s AND user_id IN ({$ids_sql})",
				$meta_key
			) );
			foreach ( $rows as $row ) {
				$uid = (int) $row->user_id;
				if ( $meta_key === self::META_NOTE ) {
					$map[ $uid ]['note'] = (string) $row->meta_value;
				} else {
					$map[ $uid ]['reminder'] = (string) $row->meta_value;
				}
			}
		}

		return $map;
	}

	// -------------------------------------------------------------------------
	// AJAX — save
	// -------------------------------------------------------------------------

	public static function ajax_save_note() {
		check_ajax_referer( self::NONCE_ACTION, 'nonce' );

		if ( ! current_user_can( 'edit_users' ) ) {
			wp_send_json_error( [ 'message' => __( 'Permission denied.', 'aisp-customer-activity' ) ], 403 );
		}

		$user_id  = isset( $_POST['user_id'] )  ? (int) $_POST['user_id']                          : 0;
		$note     = isset( $_POST['note'] )      ? sanitize_textarea_field( wp_unslash( $_POST['note'] ) )     : '';
		$reminder = isset( $_POST['reminder'] )  ? sanitize_text_field( wp_unslash( $_POST['reminder'] ) )     : '';

		if ( ! $user_id || ! get_userdata( $user_id ) ) {
			wp_send_json_error( [ 'message' => __( 'Invalid user.', 'aisp-customer-activity' ) ], 400 );
		}

		// Validate date format if provided.
		if ( $reminder && ! preg_match( '/^\d{4}-\d{2}-\d{2}$/', $reminder ) ) {
			$reminder = '';
		}

		update_user_meta( $user_id, self::META_NOTE,     $note );
		update_user_meta( $user_id, self::META_REMINDER, $reminder );

		wp_send_json_success( [
			'note'     => $note,
			'reminder' => $reminder,
			'reminder_formatted' => $reminder
				? date_i18n( get_option( 'date_format' ), strtotime( $reminder ) )
				: '',
		] );
	}

	// -------------------------------------------------------------------------
	// AJAX — get (for populating the form on open)
	// -------------------------------------------------------------------------

	public static function ajax_get_note() {
		check_ajax_referer( self::NONCE_ACTION, 'nonce' );

		if ( ! current_user_can( 'edit_users' ) ) {
			wp_send_json_error( [], 403 );
		}

		$user_id = isset( $_POST['user_id'] ) ? (int) $_POST['user_id'] : 0;

		if ( ! $user_id ) {
			wp_send_json_error( [], 400 );
		}

		wp_send_json_success( [
			'note'     => self::get_note( $user_id ),
			'reminder' => self::get_reminder( $user_id ),
		] );
	}

	// -------------------------------------------------------------------------
	// Render helpers (called from dormant render_row)
	// -------------------------------------------------------------------------

	/**
	 * Render the note cell content for a customer row.
	 *
	 * @param int    $user_id
	 * @param string $note      Pre-fetched note text.
	 * @param string $reminder  Pre-fetched reminder date (Y-m-d).
	 */
	public static function render_note_cell( int $user_id, string $note, string $reminder ) {
		$has_note     = $note !== '';
		$has_reminder = $reminder !== '';
		$reminder_fmt = $has_reminder
			? date_i18n( get_option( 'date_format' ), strtotime( $reminder ) )
			: '';

		// Is the reminder overdue?
		$is_overdue = $has_reminder && strtotime( $reminder ) < strtotime( 'today' );
		$reminder_color = $is_overdue ? '#c0392b' : '#2271b1';

		echo '<td class="aisp-ca-note-cell" data-user-id="' . esc_attr( (string) $user_id ) . '">';

		// Summary line shown when form is closed.
		echo '<div class="aisp-ca-note-summary">';

		if ( $has_reminder ) {
			echo '<span class="aisp-ca-reminder-badge" style="color:' . esc_attr( $reminder_color ) . ';font-weight:600;font-size:12px;display:block;">📅 ' . esc_html( $reminder_fmt ) . '</span>';
		}
		if ( $has_note ) {
			echo '<span class="aisp-ca-note-preview" '
				. 'data-full-note="' . esc_attr( $note ) . '" '
				. 'style="color:#555;font-size:12px;display:block;white-space:nowrap;overflow:hidden;text-overflow:ellipsis;max-width:180px;cursor:pointer;" '
				. 'title="' . esc_attr__( 'Click to read full note', 'aisp-customer-activity' ) . '">'
				. esc_html( wp_trim_words( $note, 6, '…' ) ) . '</span>';
		}

		// Toggle button.
		$btn_label = $has_note || $has_reminder
			? __( '✏️ Edit', 'aisp-customer-activity' )
			: __( '📝 Add note', 'aisp-customer-activity' );

		echo '<button type="button" class="button button-small aisp-ca-note-toggle" style="margin-top:4px;">'
			. esc_html( $btn_label ) . '</button>';

		echo '</div>'; // .aisp-ca-note-summary

		// Inline form (hidden by default).
		echo '<div class="aisp-ca-note-form" style="display:none;margin-top:6px;">';
		echo '<textarea class="aisp-ca-note-text" rows="3" style="width:100%;font-size:12px;resize:vertical;" placeholder="' . esc_attr__( 'Note…', 'aisp-customer-activity' ) . '">' . esc_textarea( $note ) . '</textarea>';
		echo '<input type="date" class="aisp-ca-note-reminder" value="' . esc_attr( $reminder ) . '" style="margin-top:4px;width:100%;" title="' . esc_attr__( 'Reminder date', 'aisp-customer-activity' ) . '">';
		echo '<div style="margin-top:4px;display:flex;gap:4px;">';
		echo '<button type="button" class="button button-primary button-small aisp-ca-note-save">'  . esc_html__( 'Save', 'aisp-customer-activity' )   . '</button>';
		echo '<button type="button" class="button button-small aisp-ca-note-cancel">' . esc_html__( 'Cancel', 'aisp-customer-activity' ) . '</button>';
		echo '</div>';
		echo '</div>'; // .aisp-ca-note-form

		echo '</td>';
	}

	// -------------------------------------------------------------------------
	// Enqueue JS + pass vars
	// -------------------------------------------------------------------------

	public static function enqueue_scripts() {
		wp_enqueue_script(
			'aisp-ca-notes',
			AISP_CA_PLUGIN_URL . 'assets/js/aisp-ca-notes.js',
			[ 'jquery' ],
			AISP_CA_VERSION,
			true
		);
		wp_localize_script( 'aisp-ca-notes', 'aispCaNotes', [
			'ajaxUrl' => admin_url( 'admin-ajax.php' ),
			'nonce'   => wp_create_nonce( self::NONCE_ACTION ),
			'i18n'    => [
				'saving'  => __( 'Saving…',    'aisp-customer-activity' ),
				'saved'   => __( 'Saved!',     'aisp-customer-activity' ),
				'error'   => __( 'Error.',     'aisp-customer-activity' ),
				'addNote' => __( '📝 Add note', 'aisp-customer-activity' ),
				'edit'    => __( '✏️ Edit',     'aisp-customer-activity' ),
			],
		] );
	}
}