<?php
/**
 * Deletes stored documents older than the 2.6 "delete files after N days"
 * setting (File Uploads settings). Off when the setting is empty or 0.
 * Runs on the hourly event, 100 records at a time; each deletion is logged.
 *
 * @package mortgage_application
 */

namespace Mapp\Files;

defined( 'ABSPATH' ) || exit;

class Retention {

	/** Wire hooks. */
	public static function register() {
		add_action( 'mortgate_hourly_event', array( __CLASS__, 'run' ), 30 );
	}

	/** @return int Days, 0 = keep forever. */
	public static function days() {
		// Form & CRM → Security; on a network the site may follow the network's value.
		return max( 0, (int) get_option( 'mortgage_ma_submissions_deleted_file', 0 ) );
	}

	/** Delete what is past retention. */
	public static function run() {
		$days = self::days();
		if ( ! $days ) {
			return;
		}
		global $wpdb;
		$cutoff = time() - $days * DAY_IN_SECONDS;
		// Walk every record holding files, 100 per run, resuming where the last run stopped.
		$cursor = (int) get_option( 'mapp_retention_cursor', 0 );
		// phpcs:ignore WordPress.DB.DirectDatabaseQuery
		$ids = array_map( 'intval', (array) $wpdb->get_col( $wpdb->prepare( "SELECT post_id FROM {$wpdb->postmeta} WHERE meta_key = %s AND post_id > %d ORDER BY post_id ASC LIMIT 100", Store::META, $cursor ) ) );
		update_option( 'mapp_retention_cursor', count( $ids ) < 100 ? 0 : end( $ids ), false );
		foreach ( $ids as $id ) {
			foreach ( Store::files_for( $id ) as $file_id => $file ) {
				if ( (int) $file['uploaded'] < $cutoff ) {
					Store::delete( $id, $file_id );
					Access::log( $id, 'retention_delete', $file['name'], 'system:' . $days . 'd' );
				}
			}
			if ( ! Store::files_for( $id ) ) {
				delete_post_meta( $id, Store::META );
			}
		}
	}
}