Core::pre_post_update() - Code Metrics - Inspection of "Merge branch 'feature__store-timeshift-version-id'..." - KroneMultimedia/plugin-timeshift - Measure and Improve Code Quality continuously with Scrutinizer

Completed

Push — beta ( fe329d...34edd0 )

unknown

created 2019-12-16 19:30 UTC

Core::pre_post_update() A

↳ Parent: Core

Complexity

Conditions	5
Paths	6

Size

Total Lines

Duplication

Lines	0
Ratio	0 %

Code Coverage

Tests	5
CRAP Score	13.7936

Importance

Changes

Metric	Value
cc	5
nc	6
nop	2
dl	0
loc	30
ccs	5
cts	17
cp	0.294
crap	13.7936
rs	9.1288
c	0
b	0
f	0

<?php
/*
 *
 *
 * inspired by https://github.com/adamsilverstein/wp-post-meta-revisions/blob/master/wp-post-meta-revisions.php
 * many thx @adamsilverstein
 *
 */

namespace KMM\Timeshift;

class Core {
    private $plugin_dir;
    private $last_author = false;
    private $timeshift_cached_meta;

    public function __construct($i18n) {
        global $wpdb;
        $this->i18n = $i18n;
class MyClass { }

$x = new MyClass();
$x->foo = true;
        $this->wpdb = $wpdb;
class MyClass { }

$x = new MyClass();
$x->foo = true;
        $this->plugin_dir = plugin_dir_url(__FILE__) . '../';
        $this->timeshift_posts_per_page = 5;
class MyClass { }

$x = new MyClass();
$x->foo = true;
        $this->pagination_ajax_action = 'pagination_timeshift';
class MyClass { }

$x = new MyClass();
$x->foo = true;
        $this->add_filters();
        $this->add_actions();
        $this->add_metabox();
        // Disable WP's own revision system
        remove_post_type_support('post', 'revisions');
    }

    public function hasTimeshifts($post_id) {
        $post_type = get_post_type($post_id);
        $table_name = $this->wpdb->prefix . 'timeshift_' . $post_type;
        $this->checkTable($post_type);
        $sql = "select count(1) as amount from $table_name where post_id=" . $post_id;
        $r = $this->wpdb->get_results($sql);

        if ($r && 1 == count($r)) {
            if (intval($r[0]->amount) > 0) {
                return true;
            }
        }

        return false;
    }

    public function timeshiftVisible() {
        $check = apply_filters('krn_timeshift_visible', true);

        return $check;
    }

    public function add_metabox() {
        $cl = $this;
        if (! $this->timeshiftVisible()) {
            return;
        }
        // Keep adding the metabox even if no timeshifts available, i.e. will render timeshift box with only live version
        if (! isset($_GET['post'])) {
            return;
        }
        add_action('add_meta_boxes', function () use ($cl) {
            add_meta_box('krn-timeshift', __('Timeshift', 'kmm-timeshift'), [$cl, 'timeshift_metabox'], null, 'normal', 'core');
        });
    }

    public function timeshift_metabox() {
        if (! isset($_GET['post'])) {
            return;
        }
        $prod_post = get_post($_GET['post']);

        $start = 0;
        $timeshift_page = 1;
        if (isset($_GET['timeshift_page'])) {
            $start = ($_GET['timeshift_page'] - 1) * $this->timeshift_posts_per_page;
            $timeshift_page = $_GET['timeshift_page'];
        }

        // pagination
        $pagination = $this->get_paginated_links($prod_post, $timeshift_page);
        echo $pagination;

        // load first few & render
        $rows = $this->get_next_rows($prod_post, $start);
        $timeshift_table = $this->render_metabox_table($prod_post, $rows);
        echo $timeshift_table;

        if (isset($_GET['action']) && $_GET['action'] == $this->pagination_ajax_action) {
            wp_die();
        }
    }

    public function add_filters() {
        // When revisioned post meta has changed, trigger a revision save.
        //add_filter('wp_save_post_revision_post_has_changed', [$this, '_wp_check_revisioned_meta_fields_have_changed'], 10, 3);

        add_filter('get_post_metadata', [$this, 'inject_metadata_timeshift'], 1, 4);
        add_filter('update_post_metadata', [$this, 'update_post_metadata'], 1, 5);
    }

    public function update_post_metadata($check, int $object_id, string $meta_key, $meta_value, $prev_value) {

        if ('_edit_last' == $meta_key) {
            $lo = get_post_meta($object_id, '_edit_last', true);
            $this->last_author = $lo;
        }

        return null;
    }

    public function inject_metadata_timeshift($value, $post_id, $key, $single) {

        if (! isset($_GET['timeshift'])) {
            return;
        }
        // Load timeshift
        if (! $this->timeshift_cached_meta) {
            $post_type = get_post_type($post_id);
            $table_name = $this->wpdb->prefix . 'timeshift_' . $post_type;
            $sql = "select * from $table_name where id=" . intval($_GET['timeshift']);
            $r = $this->wpdb->get_results($sql);
            if ($r && 1 == count($r)) {

                $payload = unserialize($r[0]->post_payload);
                $this->timeshift_cached_meta = $payload->meta;
            }
        }
        // is the requested meta data in the stored snapshot
        if ($this->timeshift_cached_meta && isset($this->timeshift_cached_meta[$key])) {
            return $this->timeshift_cached_meta[$key];
        } else {
            // Otherwise return default value, like acf core fields.
            return $value;
        }
    }

    public function inject_timeshift($p) {

        global $post;
        if (! isset($_GET['timeshift'])) {
            return;
        }
        // Load timeshift
        $table_name = $this->wpdb->prefix . 'timeshift_' . $post->post_type;
        $sql = "select * from $table_name where id=" . intval($_GET['timeshift']);
        $r = $this->wpdb->get_results($sql);
        if ($r && 1 == count($r)) {

            $payload = unserialize($r[0]->post_payload);
            $post = $payload->post;
        }
    }

    public function add_actions() {
        add_action('edit_form_top', [$this, 'inject_timeshift'], 1, 1);
        add_action('pre_post_update', [$this, 'pre_post_update'], 2, 1);
        add_action('add_attachment', [$this, 'add_attachment'], 1, 1);
        add_action('admin_notices', [$this, 'admin_notice']);
        add_action('krn_timeshift_create_snapshot', [$this, 'create_snapshot'], 1, 1);
        add_action('admin_enqueue_scripts', [$this, 'enqueue_scripts']);
        add_action('wp_ajax_pagination_timeshift', [$this, 'timeshift_metabox']);
    }

    public function admin_notice() {
        if (isset($_GET['timeshift']) && $_GET['timeshift']) {
            echo '<div class="notice notice-warning is-dismissible">';
            echo '<p style="font-weight: 800; color: red">' . __('You are editing a historical version! if you save or publish, this will replace the current live one', 'kmm-timeshift') . '</p>';
            echo '</div>';
        }
    }

    public function enqueue_scripts() {
        wp_enqueue_script('krn-timeshift-pagination-ajax', plugin_dir_url(__FILE__) . '../assets/js/pagination-ajax.js', ['jquery']);
        wp_localize_script('krn-timeshift-pagination-ajax', 'krn_timeshift', [
            'action' => $this->pagination_ajax_action,
            'post' => isset($_GET['post']) ? $_GET['post'] : false,
            'timeshift' => isset($_GET['timeshift']) ? $_GET['timeshift'] : false,
        ]);
    }

    public function checkTable($postType) {
        $table_name = $this->wpdb->prefix . 'timeshift_' . $postType;

        $charset_collate = $this->wpdb->get_charset_collate();

        $sql = "CREATE TABLE IF NOT EXISTS $table_name (
                id int(12) NOT NULL AUTO_INCREMENT,
                post_id int(12) NOT NULL,
                create_date datetime default CURRENT_TIMESTAMP,
                post_payload LONGTEXT,
                PRIMARY KEY (id)
            ) $charset_collate;";

        require_once ABSPATH . 'wp-admin/includes/upgrade.php';
        $a = dbDelta($sql);
$myVar = 'Value';
$higher = false;

if (rand(1, 6) > 3) {
    $higher = true;
} else {
    $higher = false;
}

        return true;
    }

    public function storeTimeshift($timeshift) {
        $table_name = $this->wpdb->prefix . 'timeshift_' . $timeshift->post->post_type;
        $sql = "insert into $table_name (post_id, post_payload) VALUES(%d, '%s')";
        $query = $this->wpdb->prepare($sql, $timeshift->post->ID, serialize($timeshift));
        $this->wpdb->query($query);
    }

    private function updateTimeshiftVersion($postID, $mdata): int {
        $verToSave = 0;
        if (is_array($mdata) && isset($mdata['_timeshift_version'][0]) &&
        is_numeric($mdata['_timeshift_version'][0])) {
            // Increment version for post's meta
            $verToSave = (int) $mdata['_timeshift_version'][0] + 1;
        }
        update_post_meta($postID, '_timeshift_version', $verToSave);
        if ($verToSave > 1) {
            // Previous version for when timeshift existed before
            return $verToSave - 1;
        } else {
            // When this is the first timeshift
            return 0;
        }
    }

    public function create_snapshot($postID) {
        $this->pre_post_update($postID);
    }

    public function add_attachment($postID) {
        $post = get_post($postID);
        update_post_meta($postID, '_edit_last', $post->post_author);
        $this->pre_post_update($postID);
    }

    public function pre_post_update(int $post_ID, array $data = null) {

        if (wp_is_post_autosave($post_ID)) {
            return;
        }
        if ('auto-draft' == get_post_status($post_ID)) {
            return;
        }
        $post_type = get_post_type($post_ID);
        $this->checkTable($post_type);

        $mdata = get_metadata('post', $post_ID);
        $post = get_post($post_ID);

        if ($this->last_author) {
            $mdata['_edit_last'][0] = $this->last_author;
        } else {
            // For unknown last author, clear it. It is a current user now
            $mdata['_edit_last'][0] = '';
        }
        unset($mdata['_edit_lock']);

        // Store timeshift version to post's meta
        $timeshiftVer = $this->updateTimeshiftVersion($post_ID, $mdata);
        // Don't save timeshift when the media was just uploaded, i.e. the post was just created
        if (count($mdata) > 2) {
            $mdata['_timeshift_version'][0] = $timeshiftVer;
            $timeshift = (object) ['post' => $post, 'meta' => $mdata];
            $this->storeTimeshift($timeshift);
        }
    }

    public function get_paginated_links($prod_post, $paged = 1) {
        if (is_null($prod_post)) {
            return;
        }

        // count timeshift-versions
        $table_name = $this->wpdb->prefix . 'timeshift_' . $prod_post->post_type;
        $sql = "select  count(1) as cnt from $table_name where post_id=" . $prod_post->ID;
        $maxrows = $this->wpdb->get_results($sql);
        $allrows = (int) $maxrows[0]->{'cnt'};

        // max. number of pages
        $max_page = ceil($allrows / $this->timeshift_posts_per_page);

        // create pagination links
        $output = paginate_links([
            'current' => max(1, $paged),
            'total' => $max_page,
            'mid_size' => 1,
            'prev_text' => __('«'),
            'next_text' => __('»'),
        ]);

        return $output;
    }

    public function get_next_rows($prod_post, $start = 0) {
        if (! isset($prod_post)) {
            return;
        }

        $table_name = $this->wpdb->prefix . 'timeshift_' . $prod_post->post_type;
        $sql = "select  * from $table_name where post_id=" . $prod_post->ID . ' order by create_date desc limit ' . $start . ', ' . $this->timeshift_posts_per_page;
        $rows = $this->wpdb->get_results($sql);

        return $rows;
    }

    public function render_metabox_table($prod_post, $rows = []) {
        if (! isset($prod_post)) {
            return;
        }

        // get last editor
        $table_postmeta = $this->wpdb->prefix . 'postmeta';
        $sql_last_editor = 'select meta_value from ' . $table_postmeta . ' where post_id=' . $prod_post->ID . " AND meta_key='_edit_last'";
        $last_editor = $this->wpdb->get_var($sql_last_editor);

        $output = '<table class="widefat fixed">';
        $output .= '<thead>';
        $output .= '<tr>';
        $output .= '<th width=30></th>';
        $output .= '<th width="40%" id="columnname" class="manage-column column-columnname"  scope="col">' . __('Title', 'kmm-timeshift') . '</th>';
        $output .= '<th width="30%" id="columnname" class="manage-column column-columnname"  scope="col">' . __('Snapshot Date', 'kmm-timeshift') . '</th>';
        $output .= '<th width="10%" id="columnname" class="manage-column column-columnname"  scope="col">' . __('Author', 'kmm-timeshift') . '</th>';
        $output .= '<th width="10%" id="columnname" class="manage-column column-columnname"  scope="col">' . __('Actions', 'kmm-timeshift') . '</th>';
        $output .= '</tr>';
        $output .= '</thead>';
        $output .= '<tbody>';

        // live-version
        $output .= '<tr style="font-weight: 800;">';
        $output .= '<td>' . get_avatar($last_editor, 30) . '</td>';
        $output .= '<td>' . $prod_post->post_title . '</td>';
        $output .= '<td>' . $prod_post->post_modified . '</td>';
        $output .= '<td>' . get_the_author_meta('display_name', $last_editor) . '</td>';
        $output .= '<td><a href="post.php?post=' . $_GET['post'] . '&action=edit"><span class="dashicons dashicons-admin-site"></span></A></td>';
        $output .= '</tr>';

        foreach ($rows as $rev) {
            $timeshift = unserialize($rev->post_payload);
            $style = '';

            // highlight currently loaded version
            if (isset($_GET['timeshift']) && $_GET['timeshift'] == $rev->id) {
                $style = 'style="font-style:italic;background-color: lightblue;"';
            }

            // some images dont have _edit_last field
            if (! isset($timeshift->meta['_edit_last']) || is_null($timeshift->meta['_edit_last'])) {
                $timeshift->meta['_edit_last'] = 0;
            }

            $output .= '<tr ' . $style . '>';
            $output .= '<td>' . get_avatar($timeshift->meta['_edit_last'][0], 30) . '</td>';
            $output .= '<td>' . $timeshift->post->post_title . '</td>';
            $output .= '<td>' . $timeshift->post->post_modified . '</td>';
            $output .= '<td>' . get_the_author_meta('display_name', $timeshift->meta['_edit_last'][0]) . '</td>';
            $output .= '<td><a href="post.php?post=' . $_GET['post'] . '&action=edit&timeshift=' . $rev->id . '"><span class="dashicons dashicons-backup"></span></a></td>';
            $output .= '</tr>';
        }

        $output .= '</tbody>';
        $output .= '</table>';

        return $output;
    }
}


1			<?php
2			/*
3			*
4			*
5			* inspired by https://github.com/adamsilverstein/wp-post-meta-revisions/blob/master/wp-post-meta-revisions.php
6			* many thx @adamsilverstein
7			*
8			*/
9
10			namespace KMM\Timeshift;
11
12			class Core {
13			private $plugin_dir;
14			private $last_author = false;
15			private $timeshift_cached_meta;
16
17	16		public function __construct($i18n) {
18			global $wpdb;
19	16		$this->i18n = $i18n;
			0 ignored issues – show Bug introduced 2018-04-10 12:59 UTC by Report Bug Copy Issue Report The property `i18n` does not exist. Did you maybe forget to declare it? In PHP it is possible to write to properties without declaring them. For example, the following is perfectly valid PHP code: class MyClass { } $x = new MyClass(); $x->foo = true; Generally, it is a good practice to explictly declare properties to avoid accidental typos and provide IDE auto-completion: class MyClass { public $foo; } $x = new MyClass(); $x->foo = true; Loading history...
20	16		$this->wpdb = $wpdb;
			0 ignored issues – show Bug introduced 2018-04-10 11:32 UTC by Report Bug Copy Issue Report The property `wpdb` does not exist. Did you maybe forget to declare it? In PHP it is possible to write to properties without declaring them. For example, the following is perfectly valid PHP code: class MyClass { } $x = new MyClass(); $x->foo = true; Generally, it is a good practice to explictly declare properties to avoid accidental typos and provide IDE auto-completion: class MyClass { public $foo; } $x = new MyClass(); $x->foo = true; Loading history...
21	16		$this->plugin_dir = plugin_dir_url(__FILE__) . '../';
22	16		$this->timeshift_posts_per_page = 5;
			0 ignored issues – show Bug introduced 2018-09-05 09:39 UTC by Report Bug Copy Issue Report The property `timeshift_posts_per_page` does not exist. Did you maybe forget to declare it? In PHP it is possible to write to properties without declaring them. For example, the following is perfectly valid PHP code: class MyClass { } $x = new MyClass(); $x->foo = true; Generally, it is a good practice to explictly declare properties to avoid accidental typos and provide IDE auto-completion: class MyClass { public $foo; } $x = new MyClass(); $x->foo = true; Loading history...
23	16		$this->pagination_ajax_action = 'pagination_timeshift';
			0 ignored issues – show Bug introduced 2018-09-05 09:39 UTC by Report Bug Copy Issue Report The property `pagination_ajax_action` does not exist. Did you maybe forget to declare it? In PHP it is possible to write to properties without declaring them. For example, the following is perfectly valid PHP code: class MyClass { } $x = new MyClass(); $x->foo = true; Generally, it is a good practice to explictly declare properties to avoid accidental typos and provide IDE auto-completion: class MyClass { public $foo; } $x = new MyClass(); $x->foo = true; Loading history...
24	16		$this->add_filters();
25	16		$this->add_actions();
26	16		$this->add_metabox();
27			// Disable WP's own revision system
28	16		remove_post_type_support('post', 'revisions');
29			}
30
31	2		public function hasTimeshifts($post_id) {
32	2		$post_type = get_post_type($post_id);
33	2		$table_name = $this->wpdb->prefix . 'timeshift_' . $post_type;
34	2		$this->checkTable($post_type);
35	2		$sql = "select count(1) as amount from $table_name where post_id=" . $post_id;
36	2		$r = $this->wpdb->get_results($sql);
37
38	2		if ($r && 1 == count($r)) {
39	1		if (intval($r[0]->amount) > 0) {
40	1		return true;
41			}
42			}
43
44	1		return false;
45			}
46
47	16		public function timeshiftVisible() {
48	16		$check = apply_filters('krn_timeshift_visible', true);
49
50	16		return $check;
51			}
52
53	16		public function add_metabox() {
54	16		$cl = $this;
55	16		if (! $this->timeshiftVisible()) {
56			return;
57			}
58			// Keep adding the metabox even if no timeshifts available, i.e. will render timeshift box with only live version
59	16		if (! isset($_GET['post'])) {
60	16		return;
61			}
62			add_action('add_meta_boxes', function () use ($cl) {
63			add_meta_box('krn-timeshift', __('Timeshift', 'kmm-timeshift'), [$cl, 'timeshift_metabox'], null, 'normal', 'core');
64			});
65			}
66
67	1		public function timeshift_metabox() {
68	1		if (! isset($_GET['post'])) {
69	1		return;
70			}
71			$prod_post = get_post($_GET['post']);
72
73			$start = 0;
74			$timeshift_page = 1;
75			if (isset($_GET['timeshift_page'])) {
76			$start = ($_GET['timeshift_page'] - 1) * $this->timeshift_posts_per_page;
77			$timeshift_page = $_GET['timeshift_page'];
78			}
79
80			// pagination
81			$pagination = $this->get_paginated_links($prod_post, $timeshift_page);
82			echo $pagination;
83
84			// load first few & render
85			$rows = $this->get_next_rows($prod_post, $start);
86			$timeshift_table = $this->render_metabox_table($prod_post, $rows);
87			echo $timeshift_table;
88
89			if (isset($_GET['action']) && $_GET['action'] == $this->pagination_ajax_action) {
90			wp_die();
91			}
92			}
93
94	16		public function add_filters() {
95			// When revisioned post meta has changed, trigger a revision save.
96			//add_filter('wp_save_post_revision_post_has_changed', [$this, '_wp_check_revisioned_meta_fields_have_changed'], 10, 3);
97
98	16		add_filter('get_post_metadata', [$this, 'inject_metadata_timeshift'], 1, 4);
99	16		add_filter('update_post_metadata', [$this, 'update_post_metadata'], 1, 5);
100			}
101
102	4		public function update_post_metadata($check, int $object_id, string $meta_key, $meta_value, $prev_value) {
			0 ignored issues – show Unused Code introduced 2018-04-11 09:56 UTC by Report Bug Copy Issue Report The parameter `$meta_value` is not used and could be removed. This check looks from parameters that have been defined for a function or method, but which are not used in the method body. Loading history... Unused Code introduced 2018-04-11 09:56 UTC by Report Bug Copy Issue Report The parameter `$prev_value` is not used and could be removed. This check looks from parameters that have been defined for a function or method, but which are not used in the method body. Loading history...
103	4		if ('_edit_last' == $meta_key) {
104	4		$lo = get_post_meta($object_id, '_edit_last', true);
105	4		$this->last_author = $lo;
106			}
107
108	4		return null;
109			}
110
111	5		public function inject_metadata_timeshift($value, $post_id, $key, $single) {
			0 ignored issues – show Unused Code introduced 2018-04-10 11:32 UTC by Report Bug Copy Issue Report The parameter `$single` is not used and could be removed. This check looks from parameters that have been defined for a function or method, but which are not used in the method body. Loading history...
112	5		if (! isset($_GET['timeshift'])) {
113	5		return;
114			}
115			// Load timeshift
116			if (! $this->timeshift_cached_meta) {
117			$post_type = get_post_type($post_id);
118			$table_name = $this->wpdb->prefix . 'timeshift_' . $post_type;
119			$sql = "select * from $table_name where id=" . intval($_GET['timeshift']);
120			$r = $this->wpdb->get_results($sql);
121		View Code Duplication	if ($r && 1 == count($r)) {
			0 ignored issues – show Duplication introduced 2018-04-10 11:32 UTC by Report Bug Copy Issue Report This code seems to be duplicated across your project. Duplicated code is one of the most pungent code smells. If you need to duplicate the same code in three or more different places, we strongly encourage you to look into extracting the code into a single class or operation. You can also find more detailed suggestions in the “Code” section of your repository. Loading history...
122			$payload = unserialize($r[0]->post_payload);
123			$this->timeshift_cached_meta = $payload->meta;
124			}
125			}
126			// is the requested meta data in the stored snapshot
127			if ($this->timeshift_cached_meta && isset($this->timeshift_cached_meta[$key])) {
128			return $this->timeshift_cached_meta[$key];
129			} else {
130			// Otherwise return default value, like acf core fields.
131			return $value;
132			}
133			}
134
135	2		public function inject_timeshift($p) {
			0 ignored issues – show Unused Code introduced 2018-04-11 09:56 UTC by Report Bug Copy Issue Report The parameter `$p` is not used and could be removed. This check looks from parameters that have been defined for a function or method, but which are not used in the method body. Loading history...
136			global $post;
137	2		if (! isset($_GET['timeshift'])) {
138	1		return;
139			}
140			// Load timeshift
141	1		$table_name = $this->wpdb->prefix . 'timeshift_' . $post->post_type;
142	1		$sql = "select * from $table_name where id=" . intval($_GET['timeshift']);
143	1		$r = $this->wpdb->get_results($sql);
144	1	View Code Duplication	if ($r && 1 == count($r)) {
			0 ignored issues – show Duplication introduced 2018-04-10 11:32 UTC by Report Bug Copy Issue Report This code seems to be duplicated across your project. Duplicated code is one of the most pungent code smells. If you need to duplicate the same code in three or more different places, we strongly encourage you to look into extracting the code into a single class or operation. You can also find more detailed suggestions in the “Code” section of your repository. Loading history...
145			$payload = unserialize($r[0]->post_payload);
146			$post = $payload->post;
147			}
148			}
149
150	16		public function add_actions() {
151	16		add_action('edit_form_top', [$this, 'inject_timeshift'], 1, 1);
152	16		add_action('pre_post_update', [$this, 'pre_post_update'], 2, 1);
153	16		add_action('add_attachment', [$this, 'add_attachment'], 1, 1);
154	16		add_action('admin_notices', [$this, 'admin_notice']);
155	16		add_action('krn_timeshift_create_snapshot', [$this, 'create_snapshot'], 1, 1);
156	16		add_action('admin_enqueue_scripts', [$this, 'enqueue_scripts']);
157	16		add_action('wp_ajax_pagination_timeshift', [$this, 'timeshift_metabox']);
158			}
159
160			public function admin_notice() {
161			if (isset($_GET['timeshift']) && $_GET['timeshift']) {
162			echo '<div class="notice notice-warning is-dismissible">';
163			echo '<p style="font-weight: 800; color: red">' . __('You are editing a historical version! if you save or publish, this will replace the current live one', 'kmm-timeshift') . '</p>';
164			echo '</div>';
165			}
166			}
167
168			public function enqueue_scripts() {
169			wp_enqueue_script('krn-timeshift-pagination-ajax', plugin_dir_url(__FILE__) . '../assets/js/pagination-ajax.js', ['jquery']);
170			wp_localize_script('krn-timeshift-pagination-ajax', 'krn_timeshift', [
171			'action' => $this->pagination_ajax_action,
172			'post' => isset($_GET['post']) ? $_GET['post'] : false,
173			'timeshift' => isset($_GET['timeshift']) ? $_GET['timeshift'] : false,
174			]);
175			}
176
177	6		public function checkTable($postType) {
178	6		$table_name = $this->wpdb->prefix . 'timeshift_' . $postType;
179
180	6		$charset_collate = $this->wpdb->get_charset_collate();
181
182	6		$sql = "CREATE TABLE IF NOT EXISTS $table_name (
183			id int(12) NOT NULL AUTO_INCREMENT,
184			post_id int(12) NOT NULL,
185			create_date datetime default CURRENT_TIMESTAMP,
186			post_payload LONGTEXT,
187			PRIMARY KEY (id)
188	6		) $charset_collate;";
189
190	6		require_once ABSPATH . 'wp-admin/includes/upgrade.php';
191	6		$a = dbDelta($sql);
			0 ignored issues – show Unused Code introduced 2018-04-10 11:32 UTC by Report Bug Copy Issue Report `$a` is not used, you could remove the assignment. This check looks for variable assignements that are either overwritten by other assignments or where the variable is not used subsequently. $myVar = 'Value'; $higher = false; if (rand(1, 6) > 3) { $higher = true; } else { $higher = false; } Both the `$myVar` assignment in line 1 and the `$higher` assignment in line 2 are dead. The first because `$myVar` is never used and the second because `$higher` is always overwritten for every possible time line. Loading history...
192
193	6		return true;
194			}
195
196	1		public function storeTimeshift($timeshift) {
197	1		$table_name = $this->wpdb->prefix . 'timeshift_' . $timeshift->post->post_type;
198	1		$sql = "insert into $table_name (post_id, post_payload) VALUES(%d, '%s')";
199	1		$query = $this->wpdb->prepare($sql, $timeshift->post->ID, serialize($timeshift));
200	1		$this->wpdb->query($query);
201			}
202
203			private function updateTimeshiftVersion($postID, $mdata): int {
204			$verToSave = 0;
205			if (is_array($mdata) && isset($mdata['_timeshift_version'][0]) &&
206			is_numeric($mdata['_timeshift_version'][0])) {
207	3		// Increment version for post's meta
208	3		$verToSave = (int) $mdata['_timeshift_version'][0] + 1;
209	3		}
210	3		update_post_meta($postID, '_timeshift_version', $verToSave);
211			if ($verToSave > 1) {
212			// Previous version for when timeshift existed before
213	3		return $verToSave - 1;
214	3		} else {
215			// When this is the first timeshift
216			return 0;
217	3		}
218			}
219
220	3		public function create_snapshot($postID) {
221	3		$this->pre_post_update($postID);
222			}
223	3
224	3		public function add_attachment($postID) {
225			$post = get_post($postID);
226	3		update_post_meta($postID, '_edit_last', $post->post_author);
227			$this->pre_post_update($postID);
228			}
229
230	3		public function pre_post_update(int $post_ID, array $data = null) {
			0 ignored issues – show Unused Code introduced 2018-04-10 11:32 UTC by Report Bug Copy Issue Report The parameter `$data` is not used and could be removed. This check looks from parameters that have been defined for a function or method, but which are not used in the method body. Loading history...
231			if (wp_is_post_autosave($post_ID)) {
232	3		return;
233			}
234			if ('auto-draft' == get_post_status($post_ID)) {
235	3		return;
236	1		}
237	1		$post_type = get_post_type($post_ID);
238			$this->checkTable($post_type);
239
240			$mdata = get_metadata('post', $post_ID);
241			$post = get_post($post_ID);
242
243			if ($this->last_author) {
244			$mdata['_edit_last'][0] = $this->last_author;
245			} else {
246			// For unknown last author, clear it. It is a current user now
247			$mdata['_edit_last'][0] = '';
248			}
249			unset($mdata['_edit_lock']);
250
251			// Store timeshift version to post's meta
252			$timeshiftVer = $this->updateTimeshiftVersion($post_ID, $mdata);
253			// Don't save timeshift when the media was just uploaded, i.e. the post was just created
254			if (count($mdata) > 2) {
255			$mdata['_timeshift_version'][0] = $timeshiftVer;
256			$timeshift = (object) ['post' => $post, 'meta' => $mdata];
257			$this->storeTimeshift($timeshift);
258			}
259			}
260
261			public function get_paginated_links($prod_post, $paged = 1) {
262			if (is_null($prod_post)) {
263			return;
264			}
265
266			// count timeshift-versions
267			$table_name = $this->wpdb->prefix . 'timeshift_' . $prod_post->post_type;
268			$sql = "select count(1) as cnt from $table_name where post_id=" . $prod_post->ID;
269			$maxrows = $this->wpdb->get_results($sql);
270			$allrows = (int) $maxrows[0]->{'cnt'};
271
272			// max. number of pages
273			$max_page = ceil($allrows / $this->timeshift_posts_per_page);
274
275			// create pagination links
276			$output = paginate_links([
277			'current' => max(1, $paged),
278			'total' => $max_page,
279			'mid_size' => 1,
280			'prev_text' => __('«'),
281			'next_text' => __('»'),
282			]);
283
284			return $output;
285			}
286
287			public function get_next_rows($prod_post, $start = 0) {
288			if (! isset($prod_post)) {
289			return;
290			}
291
292			$table_name = $this->wpdb->prefix . 'timeshift_' . $prod_post->post_type;
293			$sql = "select * from $table_name where post_id=" . $prod_post->ID . ' order by create_date desc limit ' . $start . ', ' . $this->timeshift_posts_per_page;
294			$rows = $this->wpdb->get_results($sql);
295
296			return $rows;
297			}
298
299			public function render_metabox_table($prod_post, $rows = []) {
300			if (! isset($prod_post)) {
301			return;
302			}
303
304			// get last editor
305			$table_postmeta = $this->wpdb->prefix . 'postmeta';
306			$sql_last_editor = 'select meta_value from ' . $table_postmeta . ' where post_id=' . $prod_post->ID . " AND meta_key='_edit_last'";
307			$last_editor = $this->wpdb->get_var($sql_last_editor);
308
309			$output = '<table class="widefat fixed">';
310			$output .= '<thead>';
311			$output .= '<tr>';
312			$output .= '<th width=30></th>';
313			$output .= '<th width="40%" id="columnname" class="manage-column column-columnname" scope="col">' . __('Title', 'kmm-timeshift') . '</th>';
314			$output .= '<th width="30%" id="columnname" class="manage-column column-columnname" scope="col">' . __('Snapshot Date', 'kmm-timeshift') . '</th>';
315			$output .= '<th width="10%" id="columnname" class="manage-column column-columnname" scope="col">' . __('Author', 'kmm-timeshift') . '</th>';
316			$output .= '<th width="10%" id="columnname" class="manage-column column-columnname" scope="col">' . __('Actions', 'kmm-timeshift') . '</th>';
317			$output .= '</tr>';
318			$output .= '</thead>';
319			$output .= '<tbody>';
320
321			// live-version
322			$output .= '<tr style="font-weight: 800;">';
323			$output .= '<td>' . get_avatar($last_editor, 30) . '</td>';
324			$output .= '<td>' . $prod_post->post_title . '</td>';
325			$output .= '<td>' . $prod_post->post_modified . '</td>';
326			$output .= '<td>' . get_the_author_meta('display_name', $last_editor) . '</td>';
327			$output .= '<td><a href="post.php?post=' . $_GET['post'] . '&action=edit"><span class="dashicons dashicons-admin-site"></span></A></td>';
328			$output .= '</tr>';
329
330			foreach ($rows as $rev) {
331			$timeshift = unserialize($rev->post_payload);
332			$style = '';
333
334			// highlight currently loaded version
335			if (isset($_GET['timeshift']) && $_GET['timeshift'] == $rev->id) {
336			$style = 'style="font-style:italic;background-color: lightblue;"';
337			}
338
339			// some images dont have _edit_last field
340			if (! isset($timeshift->meta['_edit_last']) \|\| is_null($timeshift->meta['_edit_last'])) {
341			$timeshift->meta['_edit_last'] = 0;
342			}
343
344			$output .= '<tr ' . $style . '>';
345			$output .= '<td>' . get_avatar($timeshift->meta['_edit_last'][0], 30) . '</td>';
346			$output .= '<td>' . $timeshift->post->post_title . '</td>';
347			$output .= '<td>' . $timeshift->post->post_modified . '</td>';
348			$output .= '<td>' . get_the_author_meta('display_name', $timeshift->meta['_edit_last'][0]) . '</td>';
349			$output .= '<td><a href="post.php?post=' . $_GET['post'] . '&action=edit&timeshift=' . $rev->id . '"><span class="dashicons dashicons-backup"></span></a></td>';
350			$output .= '</tr>';
351			}
352
353			$output .= '</tbody>';
354			$output .= '</table>';
355
356			return $output;
357			}
358			}
359

KroneMultimedia / plugin-timeshift

Push — beta ( fe329d...34edd0 )

Core::pre_post_update() A

Complexity

Size

Duplication

Code Coverage

Importance

Duplication Side-by-Side

Filter issues like