diff options
Diffstat (limited to 'Postman/PostmanEmailLogs.php')
-rw-r--r-- | Postman/PostmanEmailLogs.php | 113 |
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 |