CUNY Academic Commons

<?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();