<?php
/**
 * Creates course enrollment records.
 *
 * @package Aims_Infosoft_LMS
 */

defined( 'ABSPATH' ) || exit;

/**
 * Enrolls a user in a course after a successful order/payment.
 */
class AIMSLMS_Enrollment {

	/**
	 * Enroll a user in a course, unless an active enrollment already exists for this order.
	 *
	 * @param int    $user_id   User ID.
	 * @param int    $course_id Course post ID.
	 * @param int    $order_id  Order ID.
	 * @param string $txn_id    Payment transaction ID.
	 */
	public static function enroll( $user_id, $course_id, $order_id, $txn_id ) {

		global $wpdb;

		// Prevent duplicate enrollment.
		// phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching -- Custom table, no WP API alternative.
		$exists = $wpdb->get_var(
			$wpdb->prepare(
				"SELECT id FROM {$wpdb->prefix}aimslms_course_enrollments
                 WHERE user_id=%d AND course_id=%d AND course_id=%d AND status = %s",
				$user_id,
				$course_id,
				$order_id,
				'active'
			)
		);

		if ( $exists ) {
			return;
		}

		// phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery -- Custom table, no WP API alternative.
		$wpdb->insert(
			$wpdb->prefix . 'aimslms_course_enrollments',
			array(
				'user_id'         => $user_id,
				'course_id'       => $course_id,
				'order_id'        => $order_id,
				'transaction_id'  => $txn_id,
				'status'          => 'active',
				'payment_type'    => 'one_time',
				'enrollment_date' => current_time( 'mysql' ),
			)
		);
	}
}