one-click-accessibility/modules/scanner/database/scan-entry.php

<?php

namespace EA11y\Modules\Scanner\Database;

use EA11y\Classes\Database\Entry;
use EA11y\Modules\Remediation\Exceptions\Missing_URL;

if ( ! defined( 'ABSPATH' ) ) {
	exit; // Exit if accessed directly
}

/**
 * Class Scan_Entry
 */
class Scan_Entry extends Entry {

	public static function get_helper_class(): string {
		return Scans_Table::get_class_name();
	}

	/**
	 *  get_scan_result
	 * @param string $url
	 * @param bool $latest
	 *
	 * @return array
	 */
	public static function get_scan_result( string $url, bool $latest = false ) : array {
		$where = [
			[
				'column' => Scans_Table::URL,
				'value' => $url,
				'operator' => '=',
			],
		];
		$order_by = [ 'id' => $latest ? 'desc' : 'asc' ];
		$entries = Scans_Table::select( 'summary', $where, 1, null, '', $order_by );
		return isset( $entries[0] ) ? json_decode( $entries[0]->summary, true ) : [];
	}

	/**
	 *  get_scans
	 * @param string $url
	 * @param bool $latest
	 *
	 * @return array
	 */
	public static function get_scans( string $url, int $limit = 10 ) : array {
		$where = [
			[
				'column' => Scans_Table::URL,
				'value' => $url,
				'operator' => '=',
			],
		];

		$entries = Scans_Table::select( '*', $where, $limit, null, '', [ 'created_at' => 'desc' ] );

		return array_map( function ( $entry ) {
			$entry->summary = json_decode( $entry->summary, true );

			return $entry;
		}, $entries);
	}

	public static function get_by_id( int $id ) {
		$where = [
			[
				'column' => Scans_Table::ID,
				'value' => $id,
				'operator' => '=',
			],
		];

		$entries = Scans_Table::select( '*', $where, 1 );

		if ( isset( $entries[0] ) ) {
			$entries[0]->summary = json_decode( $entries[0]->summary, true );

			return $entries[0];
		}

		return null;
	}

	/**
	 * @param string $by
	 * @param string $by_value
	 * @param string $content
	 *
	 * @return void
	 */
	public static function update_scan_summary( string $by, string $by_value, string $content ): void {
		$where = [
			$by => $by_value,
		];

		$data = [
			Scans_Table::SUMMARY => $content,
		];

		Scans_Table::update( $data, $where );
	}

	/**
	 * Create
	 * used to ensure:
	 *      the remediation is an array
	 *      the hash is set
	 *      URL is set
	 *
	 * @param string $id
	 *
	 * @throws Missing_URL
	 */
	public function create( string $id = 'id' ) {
		if ( empty( $this->entry_data[ Scans_Table::URL ] ) ) {
			throw new Missing_URL();
		}

		parent::create( $id );
	}
}