1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
|
<?php
/**
* Functions for getting the correct adjacent post
*
* @package Draggable_Post_Order
*/
namespace Draggable_Post_Order;
/**
* Class Adjacent_Post_Order
*
* @package Draggable_Post_Order
*/
class Adjacent_Post_Order {
/**
* Initialize.
*/
public static function init() {
add_filter( 'get_previous_post_join', [ self::class, 'get_post_join' ], 10, 5 );
add_filter( 'get_next_post_join', [ self::class, 'get_post_join' ], 10, 5 );
add_filter( 'get_previous_post_where', [ self::class, 'get_previous_post_where' ], 10, 5 );
add_filter( 'get_next_post_where', [ self::class, 'get_next_post_where' ], 10, 5 );
add_filter( 'get_previous_post_sort', [ self::class, 'get_post_sort' ], 10, 3 );
add_filter( 'get_next_post_sort', [ self::class, 'get_post_sort' ], 10, 3 );
}
/**
* Callback for "get_previous_post_join" and "get_previous_post_join" filters.
* Joins in the postmeta table for further use.
*
* @param string $join The JOIN clause in the SQL.
* @param bool $in_same_term Whether post should be in a same taxonomy term.
* @param array $excluded_terms Array of excluded term IDs.
* @param string $taxonomy Taxonomy. Used to identify the term used when `$in_same_term` is true.
* @param WP_Post $post WP_Post object.
*
* @return string
*/
public static function get_post_join( $join, $in_same_term, $excluded_terms, $taxonomy, $post ) {
if ( ! Draggable_Post_Order::supports( $post->post_type ) ) {
return $join;
}
global $wpdb;
$join .= " INNER JOIN {$wpdb->postmeta} as pm ON p.id = pm.post_id";
return $join;
}
/**
* Helper function to set the WHERE clause.
*
* @param string $where The `WHERE` clause in the SQL.
* @param WP_Post $post WP_Post object.
* @param string $op The comparative operator to use.
*
* @return string
*/
private static function get_post_where( $where, $post, $op ) {
if ( ! Draggable_Post_Order::supports( $post->post_type ) ) {
return $where;
}
global $wpdb;
$post_order = get_post_meta( $post->ID, Draggable_Post_Order::$meta_key, true );
return $wpdb->prepare(
// phpcs:ignore WordPress.DB.PreparedSQL.InterpolatedNotPrepared
"WHERE pm.meta_key = %s AND pm.meta_value $op %s AND p.post_type = %s AND p.post_status = 'publish'",
Draggable_Post_Order::$meta_key,
$post_order,
$post->post_type
);
}
/**
* Callback for "get_previous_post_where" filter.
*
* @param string $where The `WHERE` clause in the SQL.
* @param bool $in_same_term Whether post should be in a same taxonomy term.
* @param array $excluded_terms Array of excluded term IDs.
* @param string $taxonomy Taxonomy. Used to identify the term used when `$in_same_term` is true.
* @param WP_Post $post WP_Post object.
* @return string
*/
public static function get_previous_post_where( $where, $in_same_term, $excluded_terms, $taxonomy, $post ) {
return self::get_post_where( $where, $post, '<' );
}
/**
* Callback for "get_next_post_where" filter.
*
* @param string $where The `WHERE` clause in the SQL.
* @param bool $in_same_term Whether post should be in a same taxonomy term.
* @param array $excluded_terms Array of excluded term IDs.
* @param string $taxonomy Taxonomy. Used to identify the term used when `$in_same_term` is true.
* @param WP_Post $post WP_Post object.
* @return string
*/
public static function get_next_post_where( $where, $in_same_term, $excluded_terms, $taxonomy, $post ) {
return self::get_post_where( $where, $post, '>' );
}
/**
* Callback for "get_previous_post_sort" and "get_next_post_sort" filters.
*
* @param string $order_by The `ORDER BY` clause in the SQL.
* @param WP_Post $post WP_Post object.
* @param string $order Sort order. 'DESC' for previous post, 'ASC' for next.
*
* @return string
*/
public static function get_post_sort( $order_by, $post, $order ) {
if ( ! Draggable_Post_Order::supports( $post->post_type ) ) {
return $order_by;
}
return "ORDER BY pm.meta_value $order LIMIT 1";
}
}
|
