2026-11-15 10:41:29 -08:00
<? php
declare ( strict_types = 1 );
namespace StreamGoals\Core ;
/**
* Daily housekeeping: removes checkouts that were started but never paid.
*
* Only rows that never received a PayPal capture id are purged, and only after a week, so a slow payment
* that PayPal finalizes later through the webhook is never discarded.
*/
final class Maintenance {
public const HOOK = 'sg_purge_abandoned' ;
public const MAX_AGE_DAYS = 7 ;
public static function register () : void {
add_action ( self :: HOOK , array ( self :: class , 'purge_abandoned' ) );
if ( ! wp_next_scheduled ( self :: HOOK ) ) {
wp_schedule_event ( time () + HOUR_IN_SECONDS , 'daily' , self :: HOOK );
}
}
public static function unschedule () : void {
wp_clear_scheduled_hook ( self :: HOOK );
}
2026-11-15 14:07:44 -08:00
/**
* The single definition of "abandoned checkout", mirrored by the DELETE below (MaintenancePurgeTest checks both).
* Never purgeable: not pending, younger than MAX_AGE_DAYS, a test row (goal_id 0), or ANY row carrying PayPal capture
* evidence (a capture id, even from a PENDING/under-review capture: PayPal may still finalize it by webhook).
*
* @param array|object $row status, goal_id, paypal_capture_id, created_at (UTC 'Y-m-d H:i:s')
*/
public static function isPurgeable ( array | object $row , int $now ) : bool {
$r = ( array ) $row ;
if ( 'pending' !== ( string ) ( $r [ 'status' ] ?? '' ) || ( int ) ( $r [ 'goal_id' ] ?? 0 ) <= 0 ) {
return false ;
}
if ( '' !== trim ( ( string ) ( $r [ 'paypal_capture_id' ] ?? '' ) ) ) {
return false ;
}
$created = strtotime ( ( string ) ( $r [ 'created_at' ] ?? '' ) . ' UTC' );
return false !== $created && $created < $now - self :: MAX_AGE_DAYS * DAY_IN_SECONDS ;
}
2026-11-15 10:41:29 -08:00
/** @return int Number of rows removed. */
public static function purge_abandoned () : int {
global $wpdb ;
$table = $wpdb -> prefix . 'sg_donations' ;
$cutoff = gmdate ( 'Y-m-d H:i:s' , time () - self :: MAX_AGE_DAYS * DAY_IN_SECONDS );
$n = $wpdb -> query (
$wpdb -> prepare (
"DELETE FROM { $table } WHERE status = 'pending' AND (paypal_capture_id IS NULL OR paypal_capture_id = '') AND goal_id > 0 AND created_at < %s" , // phpcs:ignore WordPress.DB.PreparedSQL.InterpolatedNotPrepared
$cutoff
)
);
return ( int ) $n ;
}
}