prefix . ‘invite_requests’;
$results = $wpdb->get_results(“SELECT *, COUNT(referrer_phone) OVER (PARTITION BY referrer_phone) AS invite_count FROM $table_name ORDER BY created_at DESC”);
echo ‘
‘;
echo ‘‘;
echo ‘
‘;
echo ‘
‘;
}
Pozivnice korisnika
‘; echo ‘# | WhatsApp korisnika | Preporučio | Ukupno preporuka | Datum |
---|---|---|---|---|
‘ . $i++ . ‘ | ‘; echo ‘‘ . esc_html($row->user_phone) . ‘ | ‘; echo ‘‘ . esc_html($row->referrer_phone) . ‘ | ‘; echo ‘‘ . esc_html($row->invite_count) . ‘ | ‘; echo ‘‘ . esc_html(date(‘d.m.Y H:i’, strtotime($row->created_at))) . ‘ | ‘; echo ‘