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 '
';
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,
)
)
);
?>
|
|
payment_method_title ); ?> |
|
transaction_id ); ?> |
|
order_key ); ?> |
|
created_at ) ) ); ?> |