summaryrefslogtreecommitdiff
path: root/Postman/PostmanEmailLogs.php
diff options
context:
space:
mode:
Diffstat (limited to 'Postman/PostmanEmailLogs.php')
-rw-r--r--Postman/PostmanEmailLogs.php113
1 files changed, 0 insertions, 113 deletions
diff --git a/Postman/PostmanEmailLogs.php b/Postman/PostmanEmailLogs.php
deleted file mode 100644
index b25bfbb..0000000
--- a/Postman/PostmanEmailLogs.php
+++ /dev/null
@@ -1,113 +0,0 @@
-<?php
-if ( ! defined( 'ABSPATH' ) ) {
- exit; // Exit if accessed directly
-}
-class PostmanEmailLogs {
-
- private $db;
-
- public $db_name = 'post_smtp_logs';
-
- private static $fields = array(
- 'success',
- 'from_header',
- 'to_header',
- 'cc_header',
- 'bcc_header',
- 'reply_to_header',
- 'transport_uri',
- 'original_to',
- 'original_subject',
- 'original_message',
- 'original_headers',
- 'session_transcript'
- );
-
- private static $instance;
-
- public static function get_instance() {
- if ( ! self::$instance ) {
- self::$instanc = new static();
- }
-
- return self::$instance;
- }
-
- private function __construct() {
- global $wpdb;
-
- $this->db = $wpdb;
- }
-
- function install_table() {
-
- global $wpdb;
-
- $sql = "CREATE TABLE `{$wpdb->prefix}_{$this->db_name}` (

- `id` bigint(20) NOT NULL AUTO_INCREMENT,
";
-
- foreach ($this->fields as $field ) {
- if ( $field == 'original_message' || $field == 'session_transcript' ) {
- $sql .= "`" . $field . "` longtext DEFAULT NULL,";
- continue;
- }
- $sql .= "`" . $field . "` varchar(255) DEFAULT NULL,";
- }
- $sql .= "PRIMARY KEY (`id`)) ENGINE=InnoDB CHARSET={$wpdb->charset} COLLATE={$wpdb->collate};
";
-
- dbDelta( $sql );
- }
-
- public static function get_data( $post_id ) {
- $fields = array();
- foreach ( self::$fields as $field ) {
- $fields[$field][0] = get_post_meta( $post_id, $field, true );
- }
-
- return $fields;
- }
-
- public static function get_fields() {
- return self::$fields;
- }
-
- function migrate_data() {
- $args = array(
- 'post_type' => 'postman_sent_mail',
- 'posts_per_page' => -1,
- );
-
- $logs = new WP_Query($args);
-
- $failed_records = 0;
- foreach ( $logs->posts as $log ) {
-
- foreach ($this->fields as $key ) {
- $value = $this->get_meta( $log->ID, $key, true );
-
- if ( $this->add_meta( $log->ID, $key, $value ) ) {
- delete_post_meta( $log->ID, $key );
- } else {
- $failed_records++;
- }
- }
- }
- }
-
- function load() {
- $this->db->select();
- }
-
- /**
- * @param array $data
- */
- function save( $data ) {
- $this->db->query( $this->db->prepare(
- "
- INSERT INTO $this->db_name
- ( " . implode( ',', array_keys( $data ) ) . " )
- VALUES ( " . str_repeat( '%s', count( $data ) ) . " )", array_values( $data )
- ) );
- }
-
-} \ No newline at end of file