<?php

global $wpdb;

$invites = $wpdb->get_results( "select id,invitee_id,inviter_id,date_created from wp_1_cac_invites where status = 'pending' and invitee_id != 0 and date_created >= '2023-01-01 00:00:00'" );

$progress = \WP_CLI\Utils\make_progress_bar( 'Generating notifications', count( $invites ) );

foreach ( $invites as $invite ) {
    $progress->tick();

    bp_notifications_add_notification( array(
        'user_id'           => $invite->invitee_id,
        'item_id'           => $invite->id,
        'secondary_item_id' => $invite->inviter_id,
        'date_notified'     => $invite->date_created,
        'component_name'    => 'caco',
        'component_action'  => 'new_invitation',
    ) );
}

$progress->finish();