<?php
if ( ! defined( 'ABSPATH' ) ) {
	exit;
}

class ANFOWO_Database {
	
	/**
	 * Get WooCommerce order status list formatted for SQL IN clause.
	 */
	public static function get_paid_statuses_sql() {
		$statuses = wc_get_is_paid_statuses();
		
		// Add custom statuses specified by the user
		$custom_statuses = array(
			'confirmed',
			'order-confirmed',
			'ready-pickup',
			'ready-to-pickup',
			'shipped',
			'order-shipped',
			'completed',
			'processing'
		);
		
		$statuses = array_unique(array_merge($statuses, $custom_statuses));

		$statuses = array_map(function($status) {
			$status = str_replace('wc-', '', $status); // remove prefix if present
			return "'wc-" . esc_sql($status) . "'";
		}, $statuses);
		return implode(',', $statuses);
	}

	/**
	 * Common helper to add date constraints to a WHERE clause.
	 */
	public static function append_date_where( $where, $date_col, $start, $end ) {
		global $wpdb;
		if ( ! empty( $start ) && ! empty( $end ) ) {
			// phpcs:ignore WordPress.DB.PreparedSQL.InterpolatedNotPrepared
			$where .= $wpdb->prepare( " AND {$date_col} >= %s AND {$date_col} <= %s", $start, $end );
		}
		return $where;
	}
}