public static function delete_handler() { $id = $_POST['autoresponder']; Autoresponder::delete(Autoresponder::getAutoresponder(intval($id))); wp_redirect("admin.php?page=_wpr/autoresponders"); }
public function testDeletionOfAutoresponderResultsInCorrespondingQueueEmailsPendingDeliveryBeingDeleted() { global $wpdb; $addAutoresponderQuery = sprintf("INSERT INTO %swpr_autoresponders (nid, id, name) VALUES (%d, 1, '%s')", $wpdb->prefix, $this->newsletterId, 'Test'); $wpdb->query($addAutoresponderQuery); for ($iter = 0; $iter < 30; $iter++) { $addAutoresponderSubscription = sprintf("INSERT INTO %swpr_followup_subscriptions (sid, type, eid, sequence, last_date, last_processed, doc) VALUES (%d, 'autoresponder', 1, %d, %d, %d, %d)", $wpdb->prefix, $iter, -1, time() - 5000, time(), time() - 30000, time() - 50000); $wpdb->query($addAutoresponderSubscription); } for ($iter = 0; $iter < 50; $iter++) { $addAutoresponderEmailsQuery = sprintf("INSERT INTO {$wpdb->prefix}wpr_queue (meta_key, hash) VALUES ('AR-%d-%d-%d-%d', '%s');", 1, $iter, $iter, $iter, md5(microtime() . $iter)); $wpdb->query($addAutoresponderEmailsQuery); } $getAutoresponderEmails = sprintf("SELECT COUNT(*) num FROM %swpr_queue WHERE meta_key LIKE 'AR-%d-%%';", $wpdb->prefix, 1); $emailsPendingDelivery = $wpdb->get_results($getAutoresponderEmails); $num = $emailsPendingDelivery[0]->num; $this->assertEquals(50, $num); Autoresponder::delete(Autoresponder::getAutoresponder(1)); $getAutoresponderEmails = sprintf("SELECT COUNT(*) num FROM %swpr_queue WHERE meta_key LIKE 'AR-%d-%%';", $wpdb->prefix, 1); $emailsPendingDelivery = $wpdb->get_results($getAutoresponderEmails); $num = $emailsPendingDelivery[0]->num; $this->assertEquals(0, $num); }