<?php
/**
 * Storage gateway: the only place the scanner talks to WordPress for data.
 *
 * Why this exists, and why it is deliberately small.
 *
 * The check registry was already pure and the scanner already kept its queries in one method, so
 * this is not a rescue job. It is a seam. Every data call the scanner makes goes through an object
 * it is handed, so a caller can hand it a different one: a fake in tests, and later a multisite
 * aware implementation for the Pro add-on, which is the only reason a second implementation will
 * ever exist.
 *
 * It is injected as an OPTIONAL argument that defaults to this class, so nothing that already calls
 * the scanner had to change. That was the condition for doing it at all: the plugin is finished and
 * waiting to be submitted, and a seam is not worth a signature break in code that works.
 */
defined('ABSPATH') || exit;

class Postlint_Store {

    /** @return array WP_Post objects, oldest id first. */
    public function published_posts(array $post_types, $limit, $offset) {
        return get_posts([
            'post_type' => $post_types,
            'post_status' => 'publish',
            'numberposts' => max(1, (int) $limit),
            'offset' => max(0, (int) $offset),
            'orderby' => 'ID',
            'order' => 'ASC',
        ]);
    }

    /** Every published title in scope, for the duplicate check. Titles only, so it stays light. */
    public function published_titles(array $post_types) {
        global $wpdb;
        $types = array_values(array_filter(array_map('sanitize_key', $post_types)));
        if (!$types) {
            return [];
        }
        $in = implode(', ', array_fill(0, count($types), '%s'));
        // phpcs:ignore WordPress.DB.PreparedSQLPlaceholders, WordPress.DB.DirectDatabaseQuery
        return $wpdb->get_col($wpdb->prepare("SELECT post_title FROM {$wpdb->posts} WHERE post_status = 'publish' AND post_type IN ($in)", $types));
    }

    /** Record that a post has been looked at, so a later feature can find what went stale. */
    public function mark_scanned($post_id, $when) {
        update_post_meta((int) $post_id, Postlint_Scanner::SCAN_META, $when);
    }

    public function read_report() {
        $report = get_option(POSTLINT_OPTION_REPORT, []);
        return is_array($report) ? $report : [];
    }

    /**
     * Written with autoload off on purpose: the report can grow to the size of the whole site and
     * has no business being loaded into memory on every front-end request.
     */
    public function write_report(array $report) {
        update_option(POSTLINT_OPTION_REPORT, $report, false);
    }

    public function now() {
        return current_time('mysql', true);
    }

    public function timestamp() {
        return time();
    }
}