<?php
/**
 * @package PlugixaCrm
 */

declare( strict_types = 1 );

namespace PlugixaCrm\Modules\DocumentLibrary\Repositories;

use PlugixaCrm\Core\Database\Repository;

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

/**
 * Data access for library documents (the Espo-style Document entity).
 *
 * Not to be confused with `Modules\Documents\Repositories\DocumentRepository`, which is the per-record
 * attachment store. This one is a first-class entity — its table name IS its api_base (`library_documents`),
 * because `RecordLoader` uses api_base as the table and `TagPermissionsTest` enforces the two are equal.
 */
final class DocumentLibraryRepository extends Repository {

	protected function table(): string {
		return 'library_documents';
	}

	protected function entity_type(): string {
		return 'library_document';
	}

	/**
	 * Writable columns.
	 *
	 * The file columns (`original_name`/`disk_name`/`mime`/`size`) are fillable because the service writes
	 * them from FileIntake's return — they are not, however, anything a JSON metadata update can set, since
	 * the update payload never carries them; a file is replaced through its own route.
	 *
	 * @return string[]
	 */
	protected function fillable(): array {
		return array(
			'name',
			'folder_id',
			'type',
			'status',
			'publish_date',
			'expiration_date',
			'description',
			'original_name',
			'disk_name',
			'mime',
			'size',
			'assigned_user_id',
			// The "Visible in portal" switch. The service sanitises it and the form sends it, but it was missing
			// here, so every save silently dropped it and no document could ever reach the portal (E2E run,
			// 2026-09-11). The create path still forces 0; only an edit can share a document.
			'portal_visible',
		);
	}

	/**
	 * @return string[]
	 */
	protected function sortable(): array {
		return array( 'id', 'name', 'status', 'created_at', 'modified_at' );
	}

	/**
	 * Give the numeric columns their real types. $wpdb returns everything as a string.
	 *
	 * @param array<string, mixed> $row Raw row.
	 *
	 * @return array<string, mixed>
	 */
	public function cast( array $row ): array {
		foreach ( array( 'id', 'size' ) as $column ) {
			if ( isset( $row[ $column ] ) ) {
				$row[ $column ] = (int) $row[ $column ];
			}
		}

		foreach ( array( 'folder_id', 'assigned_user_id' ) as $column ) {
			if ( array_key_exists( $column, $row ) ) {
				$row[ $column ] = null === $row[ $column ] ? null : (int) $row[ $column ];
			}
		}

		// The on-disk name is a filesystem secret. The client asks for bytes by id, through a route that
		// checks who is asking — it never learns where the file lives.
		unset( $row['disk_name'] );

		return $row;
	}

	/**
	 * Move every document out of one folder and into another (or to unfiled).
	 *
	 * A bulk reassign used when a folder is deleted — its documents must not be left pointing at a
	 * `folder_id` that no longer exists. Deliberately a single UPDATE, not a loop of {@see update()}: a
	 * folder deletion is not a per-document edit and does not want a modified_at bump or an event per row.
	 *
	 * @param int      $from_folder The folder being emptied.
	 * @param int|null $to_folder   Where its documents go — null unfiles them.
	 */
	public function move_folder( int $from_folder, ?int $to_folder ): void {
		global $wpdb;

		$table = $this->table_name();

		if ( null === $to_folder ) {
			// phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching -- custom table, no object cache to read from.
			$wpdb->query(
				$wpdb->prepare( "UPDATE %i SET folder_id = NULL WHERE folder_id = %d", $table, $from_folder )
			);

			return;
		}

		// phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching -- custom table, no object cache to read from.
		$wpdb->query(
			$wpdb->prepare(
				"UPDATE %i SET folder_id = %d WHERE folder_id = %d",
				$table,
				$to_folder,
				$from_folder
			)
		);
	}

	/**
	 * Global-search hits. Runs through QueryBuilder, so record scoping applies.
	 *
	 * @param string $term  What the user typed.
	 * @param int    $limit Maximum hits.
	 *
	 * @return array<int, array{id: int, title: string, subtitle: string}>
	 */
	public function search( string $term, int $limit ): array {
		$rows = $this->query( 'search' )
			->search( $term, array( 't.name', 't.original_name' ) )
			->order_by( 't.name', 'ASC' )
			->paginate( $limit, 0 )
			->get();

		return array_map(
			static fn( array $row ): array => array(
				'id'       => (int) $row['id'],
				'title'    => (string) $row['name'],
				'subtitle' => (string) $row['original_name'],
			),
			$rows
		);
	}
}