Ambassador Dashboard Updated

“>Segment 1-4 Your Stats:
Clicks:
Orders:
Commission: RM

Top 5 Ambassadors:get_results( “SELECT meta_value AS ref, SUM(pm.meta_value) AS commission_sum FROM {$wpdb->postmeta} pm JOIN {$wpdb->posts} p ON p.ID=pm.post_id WHERE pm.meta_key=’_bbb_commission_amount’ AND p.post_type=’shop_order’ GROUP BY meta_value ORDER BY commission_sum DESC LIMIT 5” ); if($top){ foreach($top as $row){ echo ‘‘; } } else { echo ‘‘; } ?>

Ref ID	Commission
‘.esc_html($row->ref).’	RM’.number_format($row->commission_sum,2).’
No data yet

Translate »