Function update_alerts

actions/toggle_integration_status.php:168–222

* Update Alerts * @param string newstatus * @param string integration_uri */

($new_status, $integration_uri)

 * @param string integration_uri
 */
function update_alerts($new_status, $integration_uri) {

    // Get active sites.
    $sites_filter = array(
        array(
            'name' => 'status',
            'value' => 'active'
        )
    );
    $active_sites = DataAccess::get_db_rows(
        'sites', $sites_filter, 1, 10000
    );

    // Create active sites to alerts filter.
    $site_ids = NULL;
    if(!empty($active_sites['content'])){
        $site_ids = array();
        foreach ($active_sites['content'] as $site){
            array_push(
                $site_ids,
                array(
                    'name' => 'site_id',
                    'value' => $site->id,
                    'operator' => '=',
                    'condition' => 'OR'
                )
            );
        }
    }

    // Create filter to select alerts with the current 
    // integration and active sites.
    $alerts_filters = array(
        array(
            'name' => 'source',
            'value' => $integration_uri 
        ),
        array(
            'name' => 'site_id',
            'value' => $site_ids
        )
    );

    // Now let's update fields.
    $updated_fields = array(
        array(
            'name' => 'archived',
            'value' => $new_status
        )
    );
    DataAccess::update_db_rows(
        'alerts', $updated_fields, $alerts_filters
    );

}