<?php

namespace ChargeForms\Includes;

if ( ! defined( 'ABSPATH' ) ) {
	exit;
}

/**
 * CSV entry import, extracted out of Admin\Entries_Page (roadmap issue
 * #31 — see Entry_Exporter's identical doc comment for the full
 * rationale). Entries_Page's handle_import() still owns the actual HTTP
 * request (nonce, capability, $_FILES validation, opening/closing the
 * uploaded file) — this class only knows "given a form id, its data
 * fields, and an already-open file handle, import rows from it."
 */
class Entry_Importer {

	/**
	 * Imports entries from a CSV in the exact shape Entry_Exporter::
	 * stream_csv() produces: "Date" column first, then one column per
	 * non-layout field in form-field order. Columns are matched
	 * positionally rather than by header name, so a round-trip
	 * export→import always works even if a field's label changed since
	 * export — matching by position is also simpler to reason about than
	 * name-based mapping for a first pass of this feature.
	 *
	 * @param resource $handle An already-opened, readable file handle —
	 *                         the caller owns opening/closing it.
	 * @return int Number of rows actually imported.
	 */
	public static function import_csv( $form_id, array $csv_fields, $handle ) {
		fgetcsv( $handle ); // Header row — informational only, columns are matched by position.

		$imported = 0;
		while ( false !== ( $row = fgetcsv( $handle ) ) ) { // phpcs:ignore WordPress.CodeAnalysis.AssignmentInCondition
			if ( empty( $row ) || ( 1 === count( $row ) && null === $row[0] ) ) {
				continue;
			}

			// GMT (roadmap issue #27) — matches Entry::create()'s own explicit GMT created_at.
			$date   = ! empty( $row[0] ) ? sanitize_text_field( $row[0] ) : current_time( 'mysql', true );
			$values = [];
			foreach ( $csv_fields as $index => $field ) {
				$values[ $field['id'] ] = isset( $row[ $index + 1 ] ) ? sanitize_textarea_field( $row[ $index + 1 ] ) : '';
			}

			Entry::create_with_date( $form_id, $values, $date );
			$imported++;
		}

		return $imported;
	}
}