get_row( $wpdb->prepare( "SELECT o.*, u.display_name, u.user_email, pay.payment_gateway, pay.currency AS payment_currency FROM {$wpdb->prefix}aimslms_course_orders o JOIN {$wpdb->users} u ON u.ID = o.user_id LEFT JOIN {$wpdb->prefix}aimslms_course_payment pay ON pay.order_id = o.id WHERE o.id = %d", $order_id ) ); if ( ! $aimslms_order ) { echo '

Order not found.

'; return; } $course = get_post( $aimslms_order->course_id ); $status_colors = array( 'completed' => '#46b450', 'pending' => '#ffb900', 'failed' => '#dc3232', ); // Customer Details. $user_id = $aimslms_order->user_id; $user_meta = get_user_meta( $user_id ); $customer_firstname = get_user_meta( $user_id, 'first_name', true ); $customer_lastname = get_user_meta( $user_id, 'last_name', true ); $customer_full_name = trim( $customer_firstname . ' ' . $customer_lastname ); $customer_name = $customer_full_name ? $customer_full_name : $aimslms_order->display_name; $customer_email = $aimslms_order->user_email; $customer_phone = get_user_meta( $user_id, '_aimslms_billing_phone', true ) ?? ''; $customer_address_1 = get_user_meta( $user_id, '_aimslms_billing_address_1', true ) ?? ''; $customer_address_2 = get_user_meta( $user_id, '_aimslms_billing_address_2', true ) ?? ''; $customer_address_city = get_user_meta( $user_id, '_aimslms_billing_city', true ) ?? ''; $customer_address_state = get_user_meta( $user_id, '_aimslms_billing_state', true ) ?? ''; $customer_address_country = get_user_meta( $user_id, '_aimslms_billing_country', true ) ?? ''; $customer_address_postcode = get_user_meta( $user_id, '_aimslms_billing_postcode', true ) ?? ''; $customer_company = get_user_meta( $user_id, '_aimslms_billing_company', true ) ?? ''; $customer_vat = get_user_meta( $user_id, '_aimslms_billing_vat', true ) ?? ''; $countries = aimslms_get_countries(); $states = aimslms_get_states(); $selected_country = get_user_meta( $user_id, '_aimslms_billing_country', true ); $selected_state = get_user_meta( $user_id, '_aimslms_billing_state', true ); $status_color = $status_colors[ $aimslms_order->order_status ] ?? '#777'; $amount = (float) $aimslms_order->order_total; $gateway = $aimslms_order->payment_gateway ?? ''; $currency = $aimslms_order->payment_currency ?? get_option( 'aimslms_currency', 'USD' ); // Razorpay stores amount in paise. if ( 'razorpay' === $gateway ) { $amount = $amount / 100; $currency = 'INR'; } ?>

#id ); ?>

←

post_title : '-' ); ?> x 1 $currency, ) ) ); ?>

order_status ) ); ?>

payment_method_title ); ?>
transaction_id ); ?>
order_key ); ?>
created_at ) ) ); ?>