Check Payment Status & Pay Later

Okay, I looked around a little more and came up with this. It is probably doing too much work this way, so it can probably be streamlined. This loops through my entries, and finds people with the Payment Status of "Processing" and then completely deletes them.

function my_remove_entries( $entry, $form ) {

	global $wpdb;

	// Get all Entries for our form ID 1
	$entries =  RGFormsModel::get_leads(1, '', 'DESC', '', '0', '99999999');
	foreach ($entries as $entry){

		// Check to see if the User has paid or not
		if($entry['payment_status'] == 'Processing'){

			// Get our Leads
			$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 );

			// 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 );

		}
	}
	// Message. Take this out later.
	echo 'deleted users!';

}

I have the function being fired on page load in my header.php file. The only piece missing is whether the entry is 24 hours old or not. That's where I am stuck....

Okay, I am on to something here... I am using this function to check every entry and let me know if 1 day has passed since they have signed up. I will work on rolling this into the delete function that I posted above. I will get back to you shortly on it.

function gf_published_entry_time( $entry, $form ) {

	// Get all Entries for our form ID 1
	$entries =  RGFormsModel::get_leads(1, '', 'DESC', '', '0', '99999999');
	foreach ($entries as $entry){

		$time = strtotime($entry['date_created']);
		$one_day_ago = strtotime('-1 day');

		if( $time > $one_day_ago ) {
		    // it's sooner than one day ago
		    $time_left = $time - $one_day_ago;
		    $days_left = floor($time_left / 86400); // 86400 = seconds per day
		    $hours_left = floor(($time_left - $days_left * 86400) / 3600); // 3600 = seconds per hour
		    echo "Still $days_left day(s), $hours_left hour(s) to go.";
		} else {
			echo 'It has been longer than one day!';
		}

	}

}

However, this does not break the site. I am just not sure the logic is correct on this.. My brain is a little scrambled right now. It seems to delete the entry regardless of the time parameters within our conditional statement...

I have gf_published_entry_time() in my header.php file to it is triggered on page load.

function gf_published_entry_time( $entry, $form ) {

	// Get all Entries for our form ID 1
	$entries =  RGFormsModel::get_leads(1, '', 'DESC', '', '0', '99999999');
	foreach ($entries as $entry){

		// Created on
		$time = strtotime($entry['date_created']);
		// Time on Day Ago
		$one_day_ago = strtotime('-24 hour');

		if(
			$entry['payment_status'] == 'Processing' &&
			$time <= $one_day_ago
		){
			// it's sooner than one day ago
			$time_left = $time - $one_day_ago;
			$days_left = floor($time_left / 86400); // 86400 = seconds per day
			$hours_left = floor(($time_left - $days_left * 86400) / 3600); // 3600 = seconds per hour
			echo 'Created On: '.$entry['date_created'];
			echo " Still $days_left day(s), $hours_left hour(s) to go until it is past due.<br/>";
		} else {
			// Delete Appropriate Entries
			my_remove_entries();
		}

	}

}

Hi all, very nice post! i have a similar situation, except that the price for my product is not predetermined.
So I should build the Paypal button/link based on each entry total price before sending it to user email.
Anyone has some suggestion on how it could be achieved?