get_results( "SELECT so.order_id, so.product_id, so.product_owner_user_id, so.order_owner_user_id, so.created_at, u.display_name AS vendor_name FROM {$wpdb->prefix}vv_system_orders so LEFT JOIN {$wpdb->prefix}users u ON so.product_owner_user_id = u.ID ORDER BY so.created_at DESC LIMIT 200" ); echo '

' . esc_html__( 'Vendor Orders', 'vendorverse' ) . '

'; echo ''; echo ''; foreach ( $orders as $row ) { $order = wc_get_order( $row->order_id ); $status = $order ? $order->get_status() : 'unknown'; $total = $order ? wc_price( $order->get_total() ) : '—'; $product = get_the_title( $row->product_id ); echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; } echo '
Order IDVendorProductTotalStatusDateAction
#' . esc_html( $row->order_id ) . '' . esc_html( $row->vendor_name ?? __( 'Unknown Vendor', 'vendorverse' ) ) . '' . esc_html( $product ) . '' . $total . '' . esc_html( $status ) . '' . esc_html( date( 'Y-m-d', strtotime( $row->created_at ) ) ) . 'View
'; } }