<?php
/**
 * Per-user saved filter views.
 *
 * Lets each user store named bundles of timeline filters so the
 * "errors only, last 24h" or "Editors over 2 weeks" combo is one
 * click away. Stored in the dedicated wp_apwpm_views table.
 *
 * @package ActivityPilot
 */

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

final class APWPM_Views {

	public static function table() {
		return APWPM_DB::views_table();
	}

	public static function for_user( $user_id ) {
		return APWPM_DB::get_views_for_user( (int) $user_id );
	}

	public static function create( $user_id, $name, $filters ) {
		$name = sanitize_text_field( $name );
		if ( '' === $name ) {
			return new WP_Error( 'apwpm_view_empty_name', __( 'Name is required.', 'activitypilot' ) );
		}
		APWPM_DB::insert_into(
			self::table(),
			array(
				'user_id'    => (int) $user_id,
				'name'       => $name,
				'filters'    => wp_json_encode( $filters ),
				'created_at' => current_time( 'mysql' ),
			),
			array( '%d', '%s', '%s', '%s' )
		);
		return APWPM_DB::insert_id();
	}

	public static function delete( $user_id, $view_id ) {
		return (bool) APWPM_DB::delete_from(
			self::table(),
			array(
				'id'      => (int) $view_id,
				'user_id' => (int) $user_id,
			),
			array( '%d', '%d' )
		);
	}
}