View difference between Paste ID: p1cJ0xWM and hfNWK5U9
SHOW: | | - or go back to the newest paste.
1
// fire the action for all forms
2-
add_action( 'gform_post_submission', 'my_remove_entries' ), 10, 2 );
2+
add_action( 'gform_after_submission', 'my_remove_entries' ), 10, 2 );
3
4
// to only fire the action for a specific form, replace the "2" with the ID of your form
5-
// add_action( 'gform_post_submission_2', 'my_remove_entries' ), 10, 2 );
5+
// add_action( 'gform_post_submission_2', 'my_remove_entries', 10, 2 );
6
7
function my_remove_entries( $entry, $form ) {
8
9
	global $wpdb;
10
11
	$lead_id                = $entry['id'];
12
	$lead_table             = RGFormsModel::get_lead_table_name();
13
	$lead_notes_table       = RGFormsModel::get_lead_notes_table_name();
14
	$lead_detail_table      = RGFormsModel::get_lead_details_table_name();
15
	$lead_detail_long_table = RGFormsModel::get_lead_details_long_table_name();
16
17
	// Delete from detail long
18
	$sql = $wpdb->prepare( " DELETE FROM $lead_detail_long_table
19
							WHERE lead_detail_id IN(
20
							SELECT id FROM $lead_detail_table WHERE lead_id=%d
21
							)", $lead_id );
22
	$wpdb->query( $sql );
23
24
	// Delete from lead details
25
	$sql = $wpdb->prepare( "DELETE FROM $lead_detail_table WHERE lead_id=%d", $lead_id );
26
	$wpdb->query( $sql );
27
28
	// Delete from lead notes
29
	$sql = $wpdb->prepare( "DELETE FROM $lead_notes_table WHERE lead_id=%d", $lead_id );
30
	$wpdb->query( $sql );
31
32
	// Delete from lead
33
	$sql = $wpdb->prepare( "DELETE FROM $lead_table WHERE id=%d", $lead_id );
34
	$wpdb->query( $sql );
35
36
}