Delete Leads

add_action("gform_validation_3", "cancel_brunch_reservation", 10, 2);
function cancel_brunch_reservation($validation_result){

        $form = $validation_result["form"];

        $name = $_POST["input_1"];
        $email = $_POST["input_2"];

        $leads = RGFormsModel::get_leads(1);
        foreach($leads as $lead){
            if($lead[1] == $name && $lead[2] == $email){

                $validation_result["is_valid"] = true;

                global $wpdb, $name, $email, $form;

                $lead_id                = $lead["id"];
                $lead_table             = RGFormsModel::get_lead_table_name();
                $lead_notes_table       = RGFormsModel::get_lead_notes_table_name();
                $lead_detail_table      = RGFormsModel::get_lead_details_table_name();
                $lead_detail_long_table = RGFormsModel::get_lead_details_long_table_name();

                // Delete from detail long
                $sql = $wpdb->prepare( " DELETE FROM $lead_detail_long_table
                                                                WHERE lead_detail_id IN(
                                                                SELECT id FROM $lead_detail_table WHERE lead_id=%d
                                                                )", $lead_id );
                $wpdb->query( $sql );

                // Delete from lead details
                $sql = $wpdb->prepare( "DELETE FROM $lead_detail_table WHERE lead_id=%d", $lead_id );
                $wpdb->query( $sql );

                // Delete from lead notes
                $sql = $wpdb->prepare( "DELETE FROM $lead_notes_table WHERE lead_id=%d", $lead_id );
                $wpdb->query( $sql );

                // Delete from lead
                $sql = $wpdb->prepare( "DELETE FROM $lead_table WHERE id=%d", $lead_id );
                $wpdb->query( $sql );

                break;

            } elseif($lead[1] != $name && $lead[2] != $email) {

                $validation_result["is_valid"] = false;

                //finding Field with ID of 1 and marking it as failed validation
        foreach($form["fields"] as &$field){

            if($field["id"] == "1"){
                $field["failed_validation"] = true;
                $field["validation_message"] = "Sorry we couldn't find anyone with the name <kbd>{$name}</kbd> please try again.";
            }
            if($field["id"] == "2"){
                $field["failed_validation"] = true;
                $field["validation_message"] = "Sorry we couldn't find anyone with the email <kbd>{$email}</kbd> please try again.";
                break;
            }

        }

            } elseif($lead[1] == $name && $lead[2] != $email){
                $validation_result["is_valid"] = false;

                //finding Field with ID of 1 and marking it as failed validation
        foreach($form["fields"] as &$field){

            if($field["id"] == "2"){
                $field["failed_validation"] = true;
                $field["validation_message"] = "Sorry we couldn't find anyone with the email <kbd>{$email}</kbd> please try again.";
                break;
            }

        }

            } elseif($lead[1] != $name && $lead[2] == $email){
                $validation_result["is_valid"] = false;

                //finding Field with ID of 1 and marking it as failed validation
        foreach($form["fields"] as &$field){

            if($field["id"] == "1"){
                $field["failed_validation"] = true;
                $field["validation_message"] = "Sorry we couldn't find anyone with the name <kbd>{$name}</kbd> please try again.";
                break;
            }

        }

            }

            $validation_result["form"] = $form;
            return $validation_result;
        ?>
        <?php
        }

}