add_action( 'gform_after_submission', 'nifty_gform_remove_entries ), 10, 2 );
function nifty_gform_remove_entries( $entry, $form ) {
if($form["id"] == 5){
return;
}
global $wpdb;
$lead_id = $entry['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 );
// Remove file uploads
$sql = $wpdb->prepare("SELECT value FROM $lead_detail_table WHERE lead_id=%d", $lead_id );
$results = $wpdb->get_results($sql, ARRAY_A ) or die(mysql_error());
foreach ($results as $check_value_for_file) {
$file_url = parse_url($check_value_for_file['value']);
$file_path = $file_url['path'];
$upload_dir = wp_upload_dir();
$file_location = realpath($upload_dir['basedir']. "/../../").$file_path;
if (file_exists($file_location)) {
unlink($file_location);
}
}
// 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 );
}
Comments
0 B
|👍
/👎
0 B
|👍
/👎
0 B
|👍
/👎
0 B
|👍
/👎
0 B
|👍
/👎
0 B
|👍
/👎
0 B
|👍
/👎
0 B
|👍
/👎
0 B
|👍
/👎
0 B
|👍
/👎