@@ -8,23 +8,23 @@ discard block |
||
8 | 8 | |
9 | 9 | class SqlQueries |
10 | 10 | { |
11 | - protected $db; |
|
12 | - protected $postType; |
|
11 | + protected $db; |
|
12 | + protected $postType; |
|
13 | 13 | |
14 | - public function __construct() |
|
15 | - { |
|
16 | - global $wpdb; |
|
17 | - $this->db = $wpdb; |
|
18 | - $this->postType = Application::POST_TYPE; |
|
19 | - } |
|
14 | + public function __construct() |
|
15 | + { |
|
16 | + global $wpdb; |
|
17 | + $this->db = $wpdb; |
|
18 | + $this->postType = Application::POST_TYPE; |
|
19 | + } |
|
20 | 20 | |
21 | - /** |
|
22 | - * @param string $metaReviewId |
|
23 | - * @return int |
|
24 | - */ |
|
25 | - public function getPostIdFromReviewId($metaReviewId) |
|
26 | - { |
|
27 | - $postId = $this->db->get_var(" |
|
21 | + /** |
|
22 | + * @param string $metaReviewId |
|
23 | + * @return int |
|
24 | + */ |
|
25 | + public function getPostIdFromReviewId($metaReviewId) |
|
26 | + { |
|
27 | + $postId = $this->db->get_var(" |
|
28 | 28 | SELECT p.ID |
29 | 29 | FROM {$this->db->posts} AS p |
30 | 30 | INNER JOIN {$this->db->postmeta} AS m ON p.ID = m.post_id |
@@ -32,17 +32,17 @@ discard block |
||
32 | 32 | AND m.meta_key = '_review_id' |
33 | 33 | AND m.meta_value = '{$metaReviewId}' |
34 | 34 | "); |
35 | - return intval($postId); |
|
36 | - } |
|
35 | + return intval($postId); |
|
36 | + } |
|
37 | 37 | |
38 | - /** |
|
39 | - * @param int $lastPostId |
|
40 | - * @param int $limit |
|
41 | - * @return array |
|
42 | - */ |
|
43 | - public function getReviewCounts(array $args, $lastPostId = 0, $limit = 500) |
|
44 | - { |
|
45 | - return (array) $this->db->get_results(" |
|
38 | + /** |
|
39 | + * @param int $lastPostId |
|
40 | + * @param int $limit |
|
41 | + * @return array |
|
42 | + */ |
|
43 | + public function getReviewCounts(array $args, $lastPostId = 0, $limit = 500) |
|
44 | + { |
|
45 | + return (array) $this->db->get_results(" |
|
46 | 46 | SELECT DISTINCT p.ID, m1.meta_value AS rating, m2.meta_value AS type |
47 | 47 | FROM {$this->db->posts} AS p |
48 | 48 | INNER JOIN {$this->db->postmeta} AS m1 ON p.ID = m1.post_id |
@@ -57,17 +57,17 @@ discard block |
||
57 | 57 | ORDER By p.ID ASC |
58 | 58 | LIMIT {$limit} |
59 | 59 | "); |
60 | - } |
|
60 | + } |
|
61 | 61 | |
62 | - /** |
|
63 | - * @todo remove this? |
|
64 | - * @param string $metaKey |
|
65 | - * @return array |
|
66 | - */ |
|
67 | - public function getReviewCountsFor($metaKey) |
|
68 | - { |
|
69 | - $metaKey = Str::prefix('_', $metaKey); |
|
70 | - return (array) $this->db->get_results(" |
|
62 | + /** |
|
63 | + * @todo remove this? |
|
64 | + * @param string $metaKey |
|
65 | + * @return array |
|
66 | + */ |
|
67 | + public function getReviewCountsFor($metaKey) |
|
68 | + { |
|
69 | + $metaKey = Str::prefix('_', $metaKey); |
|
70 | + return (array) $this->db->get_results(" |
|
71 | 71 | SELECT DISTINCT m.meta_value AS name, COUNT(*) num_posts |
72 | 72 | FROM {$this->db->posts} AS p |
73 | 73 | INNER JOIN {$this->db->postmeta} AS m ON p.ID = m.post_id |
@@ -75,16 +75,16 @@ discard block |
||
75 | 75 | AND m.meta_key = '{$metaKey}' |
76 | 76 | GROUP BY name |
77 | 77 | "); |
78 | - } |
|
78 | + } |
|
79 | 79 | |
80 | - /** |
|
81 | - * @todo remove this? |
|
82 | - * @param string $reviewType |
|
83 | - * @return array |
|
84 | - */ |
|
85 | - public function getReviewIdsByType($reviewType) |
|
86 | - { |
|
87 | - $results = $this->db->get_col(" |
|
80 | + /** |
|
81 | + * @todo remove this? |
|
82 | + * @param string $reviewType |
|
83 | + * @return array |
|
84 | + */ |
|
85 | + public function getReviewIdsByType($reviewType) |
|
86 | + { |
|
87 | + $results = $this->db->get_col(" |
|
88 | 88 | SELECT DISTINCT m1.meta_value AS review_id |
89 | 89 | FROM {$this->db->posts} AS p |
90 | 90 | INNER JOIN {$this->db->postmeta} AS m1 ON p.ID = m1.post_id |
@@ -94,20 +94,20 @@ discard block |
||
94 | 94 | AND m2.meta_key = '_review_type' |
95 | 95 | AND m2.meta_value = '{$reviewType}' |
96 | 96 | "); |
97 | - return array_keys(array_flip($results)); |
|
98 | - } |
|
97 | + return array_keys(array_flip($results)); |
|
98 | + } |
|
99 | 99 | |
100 | - /** |
|
101 | - * @param int $greaterThanId |
|
102 | - * @param int $limit |
|
103 | - * @return array |
|
104 | - */ |
|
105 | - public function getReviewRatingsFromIds(array $postIds, $greaterThanId = 0, $limit = 100) |
|
106 | - { |
|
107 | - sort($postIds); |
|
108 | - $postIds = array_slice($postIds, intval(array_search($greaterThanId, $postIds)), $limit); |
|
109 | - $postIds = implode(',', $postIds); |
|
110 | - return (array) $this->db->get_results(" |
|
100 | + /** |
|
101 | + * @param int $greaterThanId |
|
102 | + * @param int $limit |
|
103 | + * @return array |
|
104 | + */ |
|
105 | + public function getReviewRatingsFromIds(array $postIds, $greaterThanId = 0, $limit = 100) |
|
106 | + { |
|
107 | + sort($postIds); |
|
108 | + $postIds = array_slice($postIds, intval(array_search($greaterThanId, $postIds)), $limit); |
|
109 | + $postIds = implode(',', $postIds); |
|
110 | + return (array) $this->db->get_results(" |
|
111 | 111 | SELECT p.ID, m.meta_value AS rating |
112 | 112 | FROM {$this->db->posts} AS p |
113 | 113 | INNER JOIN {$this->db->postmeta} AS m ON p.ID = m.post_id |
@@ -120,20 +120,20 @@ discard block |
||
120 | 120 | ORDER By p.ID ASC |
121 | 121 | LIMIT {$limit} |
122 | 122 | "); |
123 | - } |
|
123 | + } |
|
124 | 124 | |
125 | - /** |
|
126 | - * @param string $key |
|
127 | - * @param string $status |
|
128 | - * @return array |
|
129 | - */ |
|
130 | - public function getReviewsMeta($key, $status = 'publish') |
|
131 | - { |
|
132 | - $postStatusQuery = 'all' != $status && !empty($status) |
|
133 | - ? "AND p.post_status = '{$status}'" |
|
134 | - : ''; |
|
135 | - $key = Str::prefix('_', $key); |
|
136 | - $values = $this->db->get_col(" |
|
125 | + /** |
|
126 | + * @param string $key |
|
127 | + * @param string $status |
|
128 | + * @return array |
|
129 | + */ |
|
130 | + public function getReviewsMeta($key, $status = 'publish') |
|
131 | + { |
|
132 | + $postStatusQuery = 'all' != $status && !empty($status) |
|
133 | + ? "AND p.post_status = '{$status}'" |
|
134 | + : ''; |
|
135 | + $key = Str::prefix('_', $key); |
|
136 | + $values = $this->db->get_col(" |
|
137 | 137 | SELECT DISTINCT m.meta_value |
138 | 138 | FROM {$this->db->postmeta} m |
139 | 139 | LEFT JOIN {$this->db->posts} p ON p.ID = m.post_id |
@@ -144,42 +144,42 @@ discard block |
||
144 | 144 | GROUP BY p.ID -- remove duplicate meta_value entries |
145 | 145 | ORDER BY m.meta_id ASC -- sort by oldest meta_value |
146 | 146 | "); |
147 | - sort($values); |
|
148 | - return $values; |
|
149 | - } |
|
147 | + sort($values); |
|
148 | + return $values; |
|
149 | + } |
|
150 | 150 | |
151 | - /** |
|
152 | - * @param string $and |
|
153 | - * @return string |
|
154 | - */ |
|
155 | - protected function getAndForCounts(array $args, $and = '') |
|
156 | - { |
|
157 | - $postIds = implode(',', array_filter(Arr::get($args, 'post_ids', []))); |
|
158 | - $termIds = implode(',', array_filter(Arr::get($args, 'term_ids', []))); |
|
159 | - if (!empty($args['type'])) { |
|
160 | - $and.= "AND m2.meta_value = '{$args['type']}' "; |
|
161 | - } |
|
162 | - if ($postIds) { |
|
163 | - $and.= "AND m3.meta_key = '_assigned_to' AND m3.meta_value IN ({$postIds}) "; |
|
164 | - } |
|
165 | - if ($termIds) { |
|
166 | - $and.= "AND tr.term_taxonomy_id IN ({$termIds}) "; |
|
167 | - } |
|
168 | - return apply_filters('site-reviews/query/and-for-counts', $and); |
|
169 | - } |
|
151 | + /** |
|
152 | + * @param string $and |
|
153 | + * @return string |
|
154 | + */ |
|
155 | + protected function getAndForCounts(array $args, $and = '') |
|
156 | + { |
|
157 | + $postIds = implode(',', array_filter(Arr::get($args, 'post_ids', []))); |
|
158 | + $termIds = implode(',', array_filter(Arr::get($args, 'term_ids', []))); |
|
159 | + if (!empty($args['type'])) { |
|
160 | + $and.= "AND m2.meta_value = '{$args['type']}' "; |
|
161 | + } |
|
162 | + if ($postIds) { |
|
163 | + $and.= "AND m3.meta_key = '_assigned_to' AND m3.meta_value IN ({$postIds}) "; |
|
164 | + } |
|
165 | + if ($termIds) { |
|
166 | + $and.= "AND tr.term_taxonomy_id IN ({$termIds}) "; |
|
167 | + } |
|
168 | + return apply_filters('site-reviews/query/and-for-counts', $and); |
|
169 | + } |
|
170 | 170 | |
171 | - /** |
|
172 | - * @param string $innerJoin |
|
173 | - * @return string |
|
174 | - */ |
|
175 | - protected function getInnerJoinForCounts(array $args, $innerJoin = '') |
|
176 | - { |
|
177 | - if (!empty(Arr::get($args, 'post_ids'))) { |
|
178 | - $innerJoin.= "INNER JOIN {$this->db->postmeta} AS m3 ON p.ID = m3.post_id "; |
|
179 | - } |
|
180 | - if (!empty(Arr::get($args, 'term_ids'))) { |
|
181 | - $innerJoin.= "INNER JOIN {$this->db->term_relationships} AS tr ON p.ID = tr.object_id "; |
|
182 | - } |
|
183 | - return apply_filters('site-reviews/query/inner-join-for-counts', $innerJoin); |
|
184 | - } |
|
171 | + /** |
|
172 | + * @param string $innerJoin |
|
173 | + * @return string |
|
174 | + */ |
|
175 | + protected function getInnerJoinForCounts(array $args, $innerJoin = '') |
|
176 | + { |
|
177 | + if (!empty(Arr::get($args, 'post_ids'))) { |
|
178 | + $innerJoin.= "INNER JOIN {$this->db->postmeta} AS m3 ON p.ID = m3.post_id "; |
|
179 | + } |
|
180 | + if (!empty(Arr::get($args, 'term_ids'))) { |
|
181 | + $innerJoin.= "INNER JOIN {$this->db->term_relationships} AS tr ON p.ID = tr.object_id "; |
|
182 | + } |
|
183 | + return apply_filters('site-reviews/query/inner-join-for-counts', $innerJoin); |
|
184 | + } |
|
185 | 185 | } |
@@ -22,17 +22,17 @@ discard block |
||
22 | 22 | * @param string $metaReviewId |
23 | 23 | * @return int |
24 | 24 | */ |
25 | - public function getPostIdFromReviewId($metaReviewId) |
|
25 | + public function getPostIdFromReviewId( $metaReviewId ) |
|
26 | 26 | { |
27 | - $postId = $this->db->get_var(" |
|
27 | + $postId = $this->db->get_var( " |
|
28 | 28 | SELECT p.ID |
29 | 29 | FROM {$this->db->posts} AS p |
30 | 30 | INNER JOIN {$this->db->postmeta} AS m ON p.ID = m.post_id |
31 | 31 | WHERE p.post_type = '{$this->postType}' |
32 | 32 | AND m.meta_key = '_review_id' |
33 | 33 | AND m.meta_value = '{$metaReviewId}' |
34 | - "); |
|
35 | - return intval($postId); |
|
34 | + " ); |
|
35 | + return intval( $postId ); |
|
36 | 36 | } |
37 | 37 | |
38 | 38 | /** |
@@ -40,23 +40,23 @@ discard block |
||
40 | 40 | * @param int $limit |
41 | 41 | * @return array |
42 | 42 | */ |
43 | - public function getReviewCounts(array $args, $lastPostId = 0, $limit = 500) |
|
43 | + public function getReviewCounts( array $args, $lastPostId = 0, $limit = 500 ) |
|
44 | 44 | { |
45 | - return (array) $this->db->get_results(" |
|
45 | + return (array)$this->db->get_results( " |
|
46 | 46 | SELECT DISTINCT p.ID, m1.meta_value AS rating, m2.meta_value AS type |
47 | 47 | FROM {$this->db->posts} AS p |
48 | 48 | INNER JOIN {$this->db->postmeta} AS m1 ON p.ID = m1.post_id |
49 | 49 | INNER JOIN {$this->db->postmeta} AS m2 ON p.ID = m2.post_id |
50 | - {$this->getInnerJoinForCounts($args)} |
|
50 | + {$this->getInnerJoinForCounts( $args )} |
|
51 | 51 | WHERE p.ID > {$lastPostId} |
52 | 52 | AND p.post_status = 'publish' |
53 | 53 | AND p.post_type = '{$this->postType}' |
54 | 54 | AND m1.meta_key = '_rating' |
55 | 55 | AND m2.meta_key = '_review_type' |
56 | - {$this->getAndForCounts($args)} |
|
56 | + {$this->getAndForCounts( $args )} |
|
57 | 57 | ORDER By p.ID ASC |
58 | 58 | LIMIT {$limit} |
59 | - "); |
|
59 | + " ); |
|
60 | 60 | } |
61 | 61 | |
62 | 62 | /** |
@@ -64,17 +64,17 @@ discard block |
||
64 | 64 | * @param string $metaKey |
65 | 65 | * @return array |
66 | 66 | */ |
67 | - public function getReviewCountsFor($metaKey) |
|
67 | + public function getReviewCountsFor( $metaKey ) |
|
68 | 68 | { |
69 | - $metaKey = Str::prefix('_', $metaKey); |
|
70 | - return (array) $this->db->get_results(" |
|
69 | + $metaKey = Str::prefix( '_', $metaKey ); |
|
70 | + return (array)$this->db->get_results( " |
|
71 | 71 | SELECT DISTINCT m.meta_value AS name, COUNT(*) num_posts |
72 | 72 | FROM {$this->db->posts} AS p |
73 | 73 | INNER JOIN {$this->db->postmeta} AS m ON p.ID = m.post_id |
74 | 74 | WHERE p.post_type = '{$this->postType}' |
75 | 75 | AND m.meta_key = '{$metaKey}' |
76 | 76 | GROUP BY name |
77 | - "); |
|
77 | + " ); |
|
78 | 78 | } |
79 | 79 | |
80 | 80 | /** |
@@ -82,9 +82,9 @@ discard block |
||
82 | 82 | * @param string $reviewType |
83 | 83 | * @return array |
84 | 84 | */ |
85 | - public function getReviewIdsByType($reviewType) |
|
85 | + public function getReviewIdsByType( $reviewType ) |
|
86 | 86 | { |
87 | - $results = $this->db->get_col(" |
|
87 | + $results = $this->db->get_col( " |
|
88 | 88 | SELECT DISTINCT m1.meta_value AS review_id |
89 | 89 | FROM {$this->db->posts} AS p |
90 | 90 | INNER JOIN {$this->db->postmeta} AS m1 ON p.ID = m1.post_id |
@@ -93,8 +93,8 @@ discard block |
||
93 | 93 | AND m1.meta_key = '_review_id' |
94 | 94 | AND m2.meta_key = '_review_type' |
95 | 95 | AND m2.meta_value = '{$reviewType}' |
96 | - "); |
|
97 | - return array_keys(array_flip($results)); |
|
96 | + " ); |
|
97 | + return array_keys( array_flip( $results ) ); |
|
98 | 98 | } |
99 | 99 | |
100 | 100 | /** |
@@ -102,12 +102,12 @@ discard block |
||
102 | 102 | * @param int $limit |
103 | 103 | * @return array |
104 | 104 | */ |
105 | - public function getReviewRatingsFromIds(array $postIds, $greaterThanId = 0, $limit = 100) |
|
105 | + public function getReviewRatingsFromIds( array $postIds, $greaterThanId = 0, $limit = 100 ) |
|
106 | 106 | { |
107 | - sort($postIds); |
|
108 | - $postIds = array_slice($postIds, intval(array_search($greaterThanId, $postIds)), $limit); |
|
109 | - $postIds = implode(',', $postIds); |
|
110 | - return (array) $this->db->get_results(" |
|
107 | + sort( $postIds ); |
|
108 | + $postIds = array_slice( $postIds, intval( array_search( $greaterThanId, $postIds ) ), $limit ); |
|
109 | + $postIds = implode( ',', $postIds ); |
|
110 | + return (array)$this->db->get_results( " |
|
111 | 111 | SELECT p.ID, m.meta_value AS rating |
112 | 112 | FROM {$this->db->posts} AS p |
113 | 113 | INNER JOIN {$this->db->postmeta} AS m ON p.ID = m.post_id |
@@ -119,7 +119,7 @@ discard block |
||
119 | 119 | GROUP BY p.ID |
120 | 120 | ORDER By p.ID ASC |
121 | 121 | LIMIT {$limit} |
122 | - "); |
|
122 | + " ); |
|
123 | 123 | } |
124 | 124 | |
125 | 125 | /** |
@@ -127,13 +127,13 @@ discard block |
||
127 | 127 | * @param string $status |
128 | 128 | * @return array |
129 | 129 | */ |
130 | - public function getReviewsMeta($key, $status = 'publish') |
|
130 | + public function getReviewsMeta( $key, $status = 'publish' ) |
|
131 | 131 | { |
132 | 132 | $postStatusQuery = 'all' != $status && !empty($status) |
133 | 133 | ? "AND p.post_status = '{$status}'" |
134 | 134 | : ''; |
135 | - $key = Str::prefix('_', $key); |
|
136 | - $values = $this->db->get_col(" |
|
135 | + $key = Str::prefix( '_', $key ); |
|
136 | + $values = $this->db->get_col( " |
|
137 | 137 | SELECT DISTINCT m.meta_value |
138 | 138 | FROM {$this->db->postmeta} m |
139 | 139 | LEFT JOIN {$this->db->posts} p ON p.ID = m.post_id |
@@ -143,8 +143,8 @@ discard block |
||
143 | 143 | $postStatusQuery |
144 | 144 | GROUP BY p.ID -- remove duplicate meta_value entries |
145 | 145 | ORDER BY m.meta_id ASC -- sort by oldest meta_value |
146 | - "); |
|
147 | - sort($values); |
|
146 | + " ); |
|
147 | + sort( $values ); |
|
148 | 148 | return $values; |
149 | 149 | } |
150 | 150 | |
@@ -152,34 +152,34 @@ discard block |
||
152 | 152 | * @param string $and |
153 | 153 | * @return string |
154 | 154 | */ |
155 | - protected function getAndForCounts(array $args, $and = '') |
|
155 | + protected function getAndForCounts( array $args, $and = '' ) |
|
156 | 156 | { |
157 | - $postIds = implode(',', array_filter(Arr::get($args, 'post_ids', []))); |
|
158 | - $termIds = implode(',', array_filter(Arr::get($args, 'term_ids', []))); |
|
159 | - if (!empty($args['type'])) { |
|
160 | - $and.= "AND m2.meta_value = '{$args['type']}' "; |
|
157 | + $postIds = implode( ',', array_filter( Arr::get( $args, 'post_ids', [] ) ) ); |
|
158 | + $termIds = implode( ',', array_filter( Arr::get( $args, 'term_ids', [] ) ) ); |
|
159 | + if( !empty($args['type']) ) { |
|
160 | + $and .= "AND m2.meta_value = '{$args['type']}' "; |
|
161 | 161 | } |
162 | - if ($postIds) { |
|
163 | - $and.= "AND m3.meta_key = '_assigned_to' AND m3.meta_value IN ({$postIds}) "; |
|
162 | + if( $postIds ) { |
|
163 | + $and .= "AND m3.meta_key = '_assigned_to' AND m3.meta_value IN ({$postIds}) "; |
|
164 | 164 | } |
165 | - if ($termIds) { |
|
166 | - $and.= "AND tr.term_taxonomy_id IN ({$termIds}) "; |
|
165 | + if( $termIds ) { |
|
166 | + $and .= "AND tr.term_taxonomy_id IN ({$termIds}) "; |
|
167 | 167 | } |
168 | - return apply_filters('site-reviews/query/and-for-counts', $and); |
|
168 | + return apply_filters( 'site-reviews/query/and-for-counts', $and ); |
|
169 | 169 | } |
170 | 170 | |
171 | 171 | /** |
172 | 172 | * @param string $innerJoin |
173 | 173 | * @return string |
174 | 174 | */ |
175 | - protected function getInnerJoinForCounts(array $args, $innerJoin = '') |
|
175 | + protected function getInnerJoinForCounts( array $args, $innerJoin = '' ) |
|
176 | 176 | { |
177 | - if (!empty(Arr::get($args, 'post_ids'))) { |
|
178 | - $innerJoin.= "INNER JOIN {$this->db->postmeta} AS m3 ON p.ID = m3.post_id "; |
|
177 | + if( !empty(Arr::get( $args, 'post_ids' )) ) { |
|
178 | + $innerJoin .= "INNER JOIN {$this->db->postmeta} AS m3 ON p.ID = m3.post_id "; |
|
179 | 179 | } |
180 | - if (!empty(Arr::get($args, 'term_ids'))) { |
|
181 | - $innerJoin.= "INNER JOIN {$this->db->term_relationships} AS tr ON p.ID = tr.object_id "; |
|
180 | + if( !empty(Arr::get( $args, 'term_ids' )) ) { |
|
181 | + $innerJoin .= "INNER JOIN {$this->db->term_relationships} AS tr ON p.ID = tr.object_id "; |
|
182 | 182 | } |
183 | - return apply_filters('site-reviews/query/inner-join-for-counts', $innerJoin); |
|
183 | + return apply_filters( 'site-reviews/query/inner-join-for-counts', $innerJoin ); |
|
184 | 184 | } |
185 | 185 | } |
@@ -14,266 +14,266 @@ |
||
14 | 14 | |
15 | 15 | class ListTableController extends Controller |
16 | 16 | { |
17 | - /** |
|
18 | - * @return void |
|
19 | - * @action admin_action_approve |
|
20 | - */ |
|
21 | - public function approve() |
|
22 | - { |
|
23 | - if (Application::ID != filter_input(INPUT_GET, 'plugin')) { |
|
24 | - return; |
|
25 | - } |
|
26 | - check_admin_referer('approve-review_'.($postId = $this->getPostId())); |
|
27 | - wp_update_post([ |
|
28 | - 'ID' => $postId, |
|
29 | - 'post_status' => 'publish', |
|
30 | - ]); |
|
31 | - wp_safe_redirect(wp_get_referer()); |
|
32 | - exit; |
|
33 | - } |
|
17 | + /** |
|
18 | + * @return void |
|
19 | + * @action admin_action_approve |
|
20 | + */ |
|
21 | + public function approve() |
|
22 | + { |
|
23 | + if (Application::ID != filter_input(INPUT_GET, 'plugin')) { |
|
24 | + return; |
|
25 | + } |
|
26 | + check_admin_referer('approve-review_'.($postId = $this->getPostId())); |
|
27 | + wp_update_post([ |
|
28 | + 'ID' => $postId, |
|
29 | + 'post_status' => 'publish', |
|
30 | + ]); |
|
31 | + wp_safe_redirect(wp_get_referer()); |
|
32 | + exit; |
|
33 | + } |
|
34 | 34 | |
35 | - /** |
|
36 | - * @param array $columns |
|
37 | - * @return array |
|
38 | - * @filter manage_.Application::POST_TYPE._posts_columns |
|
39 | - */ |
|
40 | - public function filterColumnsForPostType($columns) |
|
41 | - { |
|
42 | - $columns = Arr::consolidateArray($columns); |
|
43 | - $postTypeColumns = glsr()->postTypeColumns[Application::POST_TYPE]; |
|
44 | - foreach ($postTypeColumns as $key => &$value) { |
|
45 | - if (!array_key_exists($key, $columns) || !empty($value)) { |
|
46 | - continue; |
|
47 | - } |
|
48 | - $value = $columns[$key]; |
|
49 | - } |
|
50 | - if (count(glsr(Database::class)->getReviewsMeta('review_type')) < 2) { |
|
51 | - unset($postTypeColumns['review_type']); |
|
52 | - } |
|
53 | - return array_filter($postTypeColumns, 'strlen'); |
|
54 | - } |
|
35 | + /** |
|
36 | + * @param array $columns |
|
37 | + * @return array |
|
38 | + * @filter manage_.Application::POST_TYPE._posts_columns |
|
39 | + */ |
|
40 | + public function filterColumnsForPostType($columns) |
|
41 | + { |
|
42 | + $columns = Arr::consolidateArray($columns); |
|
43 | + $postTypeColumns = glsr()->postTypeColumns[Application::POST_TYPE]; |
|
44 | + foreach ($postTypeColumns as $key => &$value) { |
|
45 | + if (!array_key_exists($key, $columns) || !empty($value)) { |
|
46 | + continue; |
|
47 | + } |
|
48 | + $value = $columns[$key]; |
|
49 | + } |
|
50 | + if (count(glsr(Database::class)->getReviewsMeta('review_type')) < 2) { |
|
51 | + unset($postTypeColumns['review_type']); |
|
52 | + } |
|
53 | + return array_filter($postTypeColumns, 'strlen'); |
|
54 | + } |
|
55 | 55 | |
56 | - /** |
|
57 | - * @param string $status |
|
58 | - * @param WP_Post $post |
|
59 | - * @return string |
|
60 | - * @filter post_date_column_status |
|
61 | - */ |
|
62 | - public function filterDateColumnStatus($status, $post) |
|
63 | - { |
|
64 | - if (Application::POST_TYPE == Arr::get($post, 'post_type')) { |
|
65 | - $status = __('Submitted', 'site-reviews'); |
|
66 | - } |
|
67 | - return $status; |
|
68 | - } |
|
56 | + /** |
|
57 | + * @param string $status |
|
58 | + * @param WP_Post $post |
|
59 | + * @return string |
|
60 | + * @filter post_date_column_status |
|
61 | + */ |
|
62 | + public function filterDateColumnStatus($status, $post) |
|
63 | + { |
|
64 | + if (Application::POST_TYPE == Arr::get($post, 'post_type')) { |
|
65 | + $status = __('Submitted', 'site-reviews'); |
|
66 | + } |
|
67 | + return $status; |
|
68 | + } |
|
69 | 69 | |
70 | - /** |
|
71 | - * @param array $hidden |
|
72 | - * @param WP_Screen $post |
|
73 | - * @return array |
|
74 | - * @filter default_hidden_columns |
|
75 | - */ |
|
76 | - public function filterDefaultHiddenColumns($hidden, $screen) |
|
77 | - { |
|
78 | - if (Arr::get($screen, 'id') == 'edit-'.Application::POST_TYPE) { |
|
79 | - $hidden = Arr::consolidateArray($hidden); |
|
80 | - $hidden = array_unique(array_merge($hidden, [ |
|
81 | - 'email', 'ip_address', 'response', 'reviewer', |
|
82 | - ])); |
|
83 | - } |
|
84 | - return $hidden; |
|
85 | - } |
|
70 | + /** |
|
71 | + * @param array $hidden |
|
72 | + * @param WP_Screen $post |
|
73 | + * @return array |
|
74 | + * @filter default_hidden_columns |
|
75 | + */ |
|
76 | + public function filterDefaultHiddenColumns($hidden, $screen) |
|
77 | + { |
|
78 | + if (Arr::get($screen, 'id') == 'edit-'.Application::POST_TYPE) { |
|
79 | + $hidden = Arr::consolidateArray($hidden); |
|
80 | + $hidden = array_unique(array_merge($hidden, [ |
|
81 | + 'email', 'ip_address', 'response', 'reviewer', |
|
82 | + ])); |
|
83 | + } |
|
84 | + return $hidden; |
|
85 | + } |
|
86 | 86 | |
87 | - /** |
|
88 | - * @param array $actions |
|
89 | - * @param WP_Post $post |
|
90 | - * @return array |
|
91 | - * @filter post_row_actions |
|
92 | - */ |
|
93 | - public function filterRowActions($actions, $post) |
|
94 | - { |
|
95 | - if (Application::POST_TYPE != Arr::get($post, 'post_type') || 'trash' == $post->post_status) { |
|
96 | - return $actions; |
|
97 | - } |
|
98 | - unset($actions['inline hide-if-no-js']); //Remove Quick-edit |
|
99 | - $rowActions = [ |
|
100 | - 'approve' => esc_attr__('Approve', 'site-reviews'), |
|
101 | - 'unapprove' => esc_attr__('Unapprove', 'site-reviews'), |
|
102 | - ]; |
|
103 | - $newActions = []; |
|
104 | - foreach ($rowActions as $key => $text) { |
|
105 | - $newActions[$key] = glsr(Builder::class)->a($text, [ |
|
106 | - 'aria-label' => sprintf(esc_attr_x('%s this review', 'Approve the review', 'site-reviews'), $text), |
|
107 | - 'class' => 'glsr-change-status', |
|
108 | - 'href' => wp_nonce_url( |
|
109 | - admin_url('post.php?post='.$post->ID.'&action='.$key.'&plugin='.Application::ID), |
|
110 | - $key.'-review_'.$post->ID |
|
111 | - ), |
|
112 | - ]); |
|
113 | - } |
|
114 | - return $newActions + Arr::consolidateArray($actions); |
|
115 | - } |
|
87 | + /** |
|
88 | + * @param array $actions |
|
89 | + * @param WP_Post $post |
|
90 | + * @return array |
|
91 | + * @filter post_row_actions |
|
92 | + */ |
|
93 | + public function filterRowActions($actions, $post) |
|
94 | + { |
|
95 | + if (Application::POST_TYPE != Arr::get($post, 'post_type') || 'trash' == $post->post_status) { |
|
96 | + return $actions; |
|
97 | + } |
|
98 | + unset($actions['inline hide-if-no-js']); //Remove Quick-edit |
|
99 | + $rowActions = [ |
|
100 | + 'approve' => esc_attr__('Approve', 'site-reviews'), |
|
101 | + 'unapprove' => esc_attr__('Unapprove', 'site-reviews'), |
|
102 | + ]; |
|
103 | + $newActions = []; |
|
104 | + foreach ($rowActions as $key => $text) { |
|
105 | + $newActions[$key] = glsr(Builder::class)->a($text, [ |
|
106 | + 'aria-label' => sprintf(esc_attr_x('%s this review', 'Approve the review', 'site-reviews'), $text), |
|
107 | + 'class' => 'glsr-change-status', |
|
108 | + 'href' => wp_nonce_url( |
|
109 | + admin_url('post.php?post='.$post->ID.'&action='.$key.'&plugin='.Application::ID), |
|
110 | + $key.'-review_'.$post->ID |
|
111 | + ), |
|
112 | + ]); |
|
113 | + } |
|
114 | + return $newActions + Arr::consolidateArray($actions); |
|
115 | + } |
|
116 | 116 | |
117 | - /** |
|
118 | - * @param array $columns |
|
119 | - * @return array |
|
120 | - * @filter manage_edit-.Application::POST_TYPE._sortable_columns |
|
121 | - */ |
|
122 | - public function filterSortableColumns($columns) |
|
123 | - { |
|
124 | - $columns = Arr::consolidateArray($columns); |
|
125 | - $postTypeColumns = glsr()->postTypeColumns[Application::POST_TYPE]; |
|
126 | - unset($postTypeColumns['cb']); |
|
127 | - foreach ($postTypeColumns as $key => $value) { |
|
128 | - if (Str::startsWith('taxonomy', $key)) { |
|
129 | - continue; |
|
130 | - } |
|
131 | - $columns[$key] = $key; |
|
132 | - } |
|
133 | - return $columns; |
|
134 | - } |
|
117 | + /** |
|
118 | + * @param array $columns |
|
119 | + * @return array |
|
120 | + * @filter manage_edit-.Application::POST_TYPE._sortable_columns |
|
121 | + */ |
|
122 | + public function filterSortableColumns($columns) |
|
123 | + { |
|
124 | + $columns = Arr::consolidateArray($columns); |
|
125 | + $postTypeColumns = glsr()->postTypeColumns[Application::POST_TYPE]; |
|
126 | + unset($postTypeColumns['cb']); |
|
127 | + foreach ($postTypeColumns as $key => $value) { |
|
128 | + if (Str::startsWith('taxonomy', $key)) { |
|
129 | + continue; |
|
130 | + } |
|
131 | + $columns[$key] = $key; |
|
132 | + } |
|
133 | + return $columns; |
|
134 | + } |
|
135 | 135 | |
136 | - /** |
|
137 | - * @param string $columnName |
|
138 | - * @param string $postType |
|
139 | - * @return void |
|
140 | - * @action bulk_edit_custom_box |
|
141 | - */ |
|
142 | - public function renderBulkEditFields($columnName, $postType) |
|
143 | - { |
|
144 | - if ('assigned_to' == $columnName && Application::POST_TYPE == $postType) { |
|
145 | - glsr()->render('partials/editor/bulk-edit-assigned-to'); |
|
146 | - } |
|
147 | - } |
|
136 | + /** |
|
137 | + * @param string $columnName |
|
138 | + * @param string $postType |
|
139 | + * @return void |
|
140 | + * @action bulk_edit_custom_box |
|
141 | + */ |
|
142 | + public function renderBulkEditFields($columnName, $postType) |
|
143 | + { |
|
144 | + if ('assigned_to' == $columnName && Application::POST_TYPE == $postType) { |
|
145 | + glsr()->render('partials/editor/bulk-edit-assigned-to'); |
|
146 | + } |
|
147 | + } |
|
148 | 148 | |
149 | - /** |
|
150 | - * @param string $postType |
|
151 | - * @return void |
|
152 | - * @action restrict_manage_posts |
|
153 | - */ |
|
154 | - public function renderColumnFilters($postType) |
|
155 | - { |
|
156 | - glsr(Columns::class)->renderFilters($postType); |
|
157 | - } |
|
149 | + /** |
|
150 | + * @param string $postType |
|
151 | + * @return void |
|
152 | + * @action restrict_manage_posts |
|
153 | + */ |
|
154 | + public function renderColumnFilters($postType) |
|
155 | + { |
|
156 | + glsr(Columns::class)->renderFilters($postType); |
|
157 | + } |
|
158 | 158 | |
159 | - /** |
|
160 | - * @param string $column |
|
161 | - * @param string $postId |
|
162 | - * @return void |
|
163 | - * @action manage_posts_custom_column |
|
164 | - */ |
|
165 | - public function renderColumnValues($column, $postId) |
|
166 | - { |
|
167 | - glsr(Columns::class)->renderValues($column, $postId); |
|
168 | - } |
|
159 | + /** |
|
160 | + * @param string $column |
|
161 | + * @param string $postId |
|
162 | + * @return void |
|
163 | + * @action manage_posts_custom_column |
|
164 | + */ |
|
165 | + public function renderColumnValues($column, $postId) |
|
166 | + { |
|
167 | + glsr(Columns::class)->renderValues($column, $postId); |
|
168 | + } |
|
169 | 169 | |
170 | - /** |
|
171 | - * @param int $postId |
|
172 | - * @return void |
|
173 | - * @action save_post_.Application::POST_TYPE |
|
174 | - */ |
|
175 | - public function saveBulkEditFields($postId) |
|
176 | - { |
|
177 | - if (!current_user_can('edit_posts')) { |
|
178 | - return; |
|
179 | - } |
|
180 | - $assignedTo = filter_input(INPUT_GET, 'assigned_to'); |
|
181 | - if ($assignedTo && get_post($assignedTo)) { |
|
182 | - glsr(Database::class)->update($postId, 'assigned_to', $assignedTo); |
|
183 | - } |
|
184 | - } |
|
170 | + /** |
|
171 | + * @param int $postId |
|
172 | + * @return void |
|
173 | + * @action save_post_.Application::POST_TYPE |
|
174 | + */ |
|
175 | + public function saveBulkEditFields($postId) |
|
176 | + { |
|
177 | + if (!current_user_can('edit_posts')) { |
|
178 | + return; |
|
179 | + } |
|
180 | + $assignedTo = filter_input(INPUT_GET, 'assigned_to'); |
|
181 | + if ($assignedTo && get_post($assignedTo)) { |
|
182 | + glsr(Database::class)->update($postId, 'assigned_to', $assignedTo); |
|
183 | + } |
|
184 | + } |
|
185 | 185 | |
186 | - /** |
|
187 | - * @return void |
|
188 | - * @action pre_get_posts |
|
189 | - */ |
|
190 | - public function setQueryForColumn(WP_Query $query) |
|
191 | - { |
|
192 | - if (!$this->hasPermission($query)) { |
|
193 | - return; |
|
194 | - } |
|
195 | - $this->setMetaQuery($query, [ |
|
196 | - 'rating', 'review_type', |
|
197 | - ]); |
|
198 | - $this->setOrderby($query); |
|
199 | - } |
|
186 | + /** |
|
187 | + * @return void |
|
188 | + * @action pre_get_posts |
|
189 | + */ |
|
190 | + public function setQueryForColumn(WP_Query $query) |
|
191 | + { |
|
192 | + if (!$this->hasPermission($query)) { |
|
193 | + return; |
|
194 | + } |
|
195 | + $this->setMetaQuery($query, [ |
|
196 | + 'rating', 'review_type', |
|
197 | + ]); |
|
198 | + $this->setOrderby($query); |
|
199 | + } |
|
200 | 200 | |
201 | - /** |
|
202 | - * @return void |
|
203 | - * @action admin_action_unapprove |
|
204 | - */ |
|
205 | - public function unapprove() |
|
206 | - { |
|
207 | - if (Application::ID != filter_input(INPUT_GET, 'plugin')) { |
|
208 | - return; |
|
209 | - } |
|
210 | - check_admin_referer('unapprove-review_'.($postId = $this->getPostId())); |
|
211 | - wp_update_post([ |
|
212 | - 'ID' => $postId, |
|
213 | - 'post_status' => 'pending', |
|
214 | - ]); |
|
215 | - wp_safe_redirect(wp_get_referer()); |
|
216 | - exit; |
|
217 | - } |
|
201 | + /** |
|
202 | + * @return void |
|
203 | + * @action admin_action_unapprove |
|
204 | + */ |
|
205 | + public function unapprove() |
|
206 | + { |
|
207 | + if (Application::ID != filter_input(INPUT_GET, 'plugin')) { |
|
208 | + return; |
|
209 | + } |
|
210 | + check_admin_referer('unapprove-review_'.($postId = $this->getPostId())); |
|
211 | + wp_update_post([ |
|
212 | + 'ID' => $postId, |
|
213 | + 'post_status' => 'pending', |
|
214 | + ]); |
|
215 | + wp_safe_redirect(wp_get_referer()); |
|
216 | + exit; |
|
217 | + } |
|
218 | 218 | |
219 | - /** |
|
220 | - * Check if the translation string can be modified. |
|
221 | - * @param string $domain |
|
222 | - * @return bool |
|
223 | - */ |
|
224 | - protected function canModifyTranslation($domain = 'default') |
|
225 | - { |
|
226 | - $screen = glsr_current_screen(); |
|
227 | - return 'default' == $domain |
|
228 | - && 'edit' == $screen->base |
|
229 | - && Application::POST_TYPE == $screen->post_type; |
|
230 | - } |
|
219 | + /** |
|
220 | + * Check if the translation string can be modified. |
|
221 | + * @param string $domain |
|
222 | + * @return bool |
|
223 | + */ |
|
224 | + protected function canModifyTranslation($domain = 'default') |
|
225 | + { |
|
226 | + $screen = glsr_current_screen(); |
|
227 | + return 'default' == $domain |
|
228 | + && 'edit' == $screen->base |
|
229 | + && Application::POST_TYPE == $screen->post_type; |
|
230 | + } |
|
231 | 231 | |
232 | - /** |
|
233 | - * @return bool |
|
234 | - */ |
|
235 | - protected function hasPermission(WP_Query $query) |
|
236 | - { |
|
237 | - global $pagenow; |
|
238 | - return is_admin() |
|
239 | - && $query->is_main_query() |
|
240 | - && Application::POST_TYPE == $query->get('post_type') |
|
241 | - && 'edit.php' == $pagenow; |
|
242 | - } |
|
232 | + /** |
|
233 | + * @return bool |
|
234 | + */ |
|
235 | + protected function hasPermission(WP_Query $query) |
|
236 | + { |
|
237 | + global $pagenow; |
|
238 | + return is_admin() |
|
239 | + && $query->is_main_query() |
|
240 | + && Application::POST_TYPE == $query->get('post_type') |
|
241 | + && 'edit.php' == $pagenow; |
|
242 | + } |
|
243 | 243 | |
244 | - /** |
|
245 | - * @return void |
|
246 | - */ |
|
247 | - protected function setMetaQuery(WP_Query $query, array $metaKeys) |
|
248 | - { |
|
249 | - foreach ($metaKeys as $key) { |
|
250 | - $value = (string) filter_input(INPUT_GET, $key); |
|
251 | - if ('' === $value) { |
|
252 | - continue; |
|
253 | - } |
|
254 | - $metaQuery = (array) $query->get('meta_query'); |
|
255 | - $metaQuery[] = [ |
|
256 | - 'key' => Str::prefix('_', $key, '_'), |
|
257 | - 'value' => $value, |
|
258 | - ]; |
|
259 | - $query->set('meta_query', array_filter($metaQuery)); |
|
260 | - } |
|
261 | - } |
|
244 | + /** |
|
245 | + * @return void |
|
246 | + */ |
|
247 | + protected function setMetaQuery(WP_Query $query, array $metaKeys) |
|
248 | + { |
|
249 | + foreach ($metaKeys as $key) { |
|
250 | + $value = (string) filter_input(INPUT_GET, $key); |
|
251 | + if ('' === $value) { |
|
252 | + continue; |
|
253 | + } |
|
254 | + $metaQuery = (array) $query->get('meta_query'); |
|
255 | + $metaQuery[] = [ |
|
256 | + 'key' => Str::prefix('_', $key, '_'), |
|
257 | + 'value' => $value, |
|
258 | + ]; |
|
259 | + $query->set('meta_query', array_filter($metaQuery)); |
|
260 | + } |
|
261 | + } |
|
262 | 262 | |
263 | - /** |
|
264 | - * @return void |
|
265 | - */ |
|
266 | - protected function setOrderby(WP_Query $query) |
|
267 | - { |
|
268 | - $orderby = $query->get('orderby'); |
|
269 | - $columns = glsr()->postTypeColumns[Application::POST_TYPE]; |
|
270 | - unset($columns['cb'], $columns['title'], $columns['date']); |
|
271 | - if (in_array($orderby, array_keys($columns))) { |
|
272 | - if ('reviewer' == $orderby) { |
|
273 | - $orderby = 'author'; |
|
274 | - } |
|
275 | - $query->set('meta_key', Str::prefix('_', $orderby, '_')); |
|
276 | - $query->set('orderby', 'meta_value'); |
|
277 | - } |
|
278 | - } |
|
263 | + /** |
|
264 | + * @return void |
|
265 | + */ |
|
266 | + protected function setOrderby(WP_Query $query) |
|
267 | + { |
|
268 | + $orderby = $query->get('orderby'); |
|
269 | + $columns = glsr()->postTypeColumns[Application::POST_TYPE]; |
|
270 | + unset($columns['cb'], $columns['title'], $columns['date']); |
|
271 | + if (in_array($orderby, array_keys($columns))) { |
|
272 | + if ('reviewer' == $orderby) { |
|
273 | + $orderby = 'author'; |
|
274 | + } |
|
275 | + $query->set('meta_key', Str::prefix('_', $orderby, '_')); |
|
276 | + $query->set('orderby', 'meta_value'); |
|
277 | + } |
|
278 | + } |
|
279 | 279 | } |
@@ -20,15 +20,15 @@ discard block |
||
20 | 20 | */ |
21 | 21 | public function approve() |
22 | 22 | { |
23 | - if (Application::ID != filter_input(INPUT_GET, 'plugin')) { |
|
23 | + if( Application::ID != filter_input( INPUT_GET, 'plugin' ) ) { |
|
24 | 24 | return; |
25 | 25 | } |
26 | - check_admin_referer('approve-review_'.($postId = $this->getPostId())); |
|
27 | - wp_update_post([ |
|
26 | + check_admin_referer( 'approve-review_'.($postId = $this->getPostId()) ); |
|
27 | + wp_update_post( [ |
|
28 | 28 | 'ID' => $postId, |
29 | 29 | 'post_status' => 'publish', |
30 | - ]); |
|
31 | - wp_safe_redirect(wp_get_referer()); |
|
30 | + ] ); |
|
31 | + wp_safe_redirect( wp_get_referer() ); |
|
32 | 32 | exit; |
33 | 33 | } |
34 | 34 | |
@@ -37,20 +37,20 @@ discard block |
||
37 | 37 | * @return array |
38 | 38 | * @filter manage_.Application::POST_TYPE._posts_columns |
39 | 39 | */ |
40 | - public function filterColumnsForPostType($columns) |
|
40 | + public function filterColumnsForPostType( $columns ) |
|
41 | 41 | { |
42 | - $columns = Arr::consolidateArray($columns); |
|
42 | + $columns = Arr::consolidateArray( $columns ); |
|
43 | 43 | $postTypeColumns = glsr()->postTypeColumns[Application::POST_TYPE]; |
44 | - foreach ($postTypeColumns as $key => &$value) { |
|
45 | - if (!array_key_exists($key, $columns) || !empty($value)) { |
|
44 | + foreach( $postTypeColumns as $key => &$value ) { |
|
45 | + if( !array_key_exists( $key, $columns ) || !empty($value) ) { |
|
46 | 46 | continue; |
47 | 47 | } |
48 | 48 | $value = $columns[$key]; |
49 | 49 | } |
50 | - if (count(glsr(Database::class)->getReviewsMeta('review_type')) < 2) { |
|
50 | + if( count( glsr( Database::class )->getReviewsMeta( 'review_type' ) ) < 2 ) { |
|
51 | 51 | unset($postTypeColumns['review_type']); |
52 | 52 | } |
53 | - return array_filter($postTypeColumns, 'strlen'); |
|
53 | + return array_filter( $postTypeColumns, 'strlen' ); |
|
54 | 54 | } |
55 | 55 | |
56 | 56 | /** |
@@ -59,10 +59,10 @@ discard block |
||
59 | 59 | * @return string |
60 | 60 | * @filter post_date_column_status |
61 | 61 | */ |
62 | - public function filterDateColumnStatus($status, $post) |
|
62 | + public function filterDateColumnStatus( $status, $post ) |
|
63 | 63 | { |
64 | - if (Application::POST_TYPE == Arr::get($post, 'post_type')) { |
|
65 | - $status = __('Submitted', 'site-reviews'); |
|
64 | + if( Application::POST_TYPE == Arr::get( $post, 'post_type' ) ) { |
|
65 | + $status = __( 'Submitted', 'site-reviews' ); |
|
66 | 66 | } |
67 | 67 | return $status; |
68 | 68 | } |
@@ -73,13 +73,13 @@ discard block |
||
73 | 73 | * @return array |
74 | 74 | * @filter default_hidden_columns |
75 | 75 | */ |
76 | - public function filterDefaultHiddenColumns($hidden, $screen) |
|
76 | + public function filterDefaultHiddenColumns( $hidden, $screen ) |
|
77 | 77 | { |
78 | - if (Arr::get($screen, 'id') == 'edit-'.Application::POST_TYPE) { |
|
79 | - $hidden = Arr::consolidateArray($hidden); |
|
80 | - $hidden = array_unique(array_merge($hidden, [ |
|
78 | + if( Arr::get( $screen, 'id' ) == 'edit-'.Application::POST_TYPE ) { |
|
79 | + $hidden = Arr::consolidateArray( $hidden ); |
|
80 | + $hidden = array_unique( array_merge( $hidden, [ |
|
81 | 81 | 'email', 'ip_address', 'response', 'reviewer', |
82 | - ])); |
|
82 | + ] ) ); |
|
83 | 83 | } |
84 | 84 | return $hidden; |
85 | 85 | } |
@@ -90,28 +90,28 @@ discard block |
||
90 | 90 | * @return array |
91 | 91 | * @filter post_row_actions |
92 | 92 | */ |
93 | - public function filterRowActions($actions, $post) |
|
93 | + public function filterRowActions( $actions, $post ) |
|
94 | 94 | { |
95 | - if (Application::POST_TYPE != Arr::get($post, 'post_type') || 'trash' == $post->post_status) { |
|
95 | + if( Application::POST_TYPE != Arr::get( $post, 'post_type' ) || 'trash' == $post->post_status ) { |
|
96 | 96 | return $actions; |
97 | 97 | } |
98 | 98 | unset($actions['inline hide-if-no-js']); //Remove Quick-edit |
99 | 99 | $rowActions = [ |
100 | - 'approve' => esc_attr__('Approve', 'site-reviews'), |
|
101 | - 'unapprove' => esc_attr__('Unapprove', 'site-reviews'), |
|
100 | + 'approve' => esc_attr__( 'Approve', 'site-reviews' ), |
|
101 | + 'unapprove' => esc_attr__( 'Unapprove', 'site-reviews' ), |
|
102 | 102 | ]; |
103 | 103 | $newActions = []; |
104 | - foreach ($rowActions as $key => $text) { |
|
105 | - $newActions[$key] = glsr(Builder::class)->a($text, [ |
|
106 | - 'aria-label' => sprintf(esc_attr_x('%s this review', 'Approve the review', 'site-reviews'), $text), |
|
104 | + foreach( $rowActions as $key => $text ) { |
|
105 | + $newActions[$key] = glsr( Builder::class )->a( $text, [ |
|
106 | + 'aria-label' => sprintf( esc_attr_x( '%s this review', 'Approve the review', 'site-reviews' ), $text ), |
|
107 | 107 | 'class' => 'glsr-change-status', |
108 | 108 | 'href' => wp_nonce_url( |
109 | - admin_url('post.php?post='.$post->ID.'&action='.$key.'&plugin='.Application::ID), |
|
109 | + admin_url( 'post.php?post='.$post->ID.'&action='.$key.'&plugin='.Application::ID ), |
|
110 | 110 | $key.'-review_'.$post->ID |
111 | 111 | ), |
112 | - ]); |
|
112 | + ] ); |
|
113 | 113 | } |
114 | - return $newActions + Arr::consolidateArray($actions); |
|
114 | + return $newActions + Arr::consolidateArray( $actions ); |
|
115 | 115 | } |
116 | 116 | |
117 | 117 | /** |
@@ -119,13 +119,13 @@ discard block |
||
119 | 119 | * @return array |
120 | 120 | * @filter manage_edit-.Application::POST_TYPE._sortable_columns |
121 | 121 | */ |
122 | - public function filterSortableColumns($columns) |
|
122 | + public function filterSortableColumns( $columns ) |
|
123 | 123 | { |
124 | - $columns = Arr::consolidateArray($columns); |
|
124 | + $columns = Arr::consolidateArray( $columns ); |
|
125 | 125 | $postTypeColumns = glsr()->postTypeColumns[Application::POST_TYPE]; |
126 | 126 | unset($postTypeColumns['cb']); |
127 | - foreach ($postTypeColumns as $key => $value) { |
|
128 | - if (Str::startsWith('taxonomy', $key)) { |
|
127 | + foreach( $postTypeColumns as $key => $value ) { |
|
128 | + if( Str::startsWith( 'taxonomy', $key ) ) { |
|
129 | 129 | continue; |
130 | 130 | } |
131 | 131 | $columns[$key] = $key; |
@@ -139,10 +139,10 @@ discard block |
||
139 | 139 | * @return void |
140 | 140 | * @action bulk_edit_custom_box |
141 | 141 | */ |
142 | - public function renderBulkEditFields($columnName, $postType) |
|
142 | + public function renderBulkEditFields( $columnName, $postType ) |
|
143 | 143 | { |
144 | - if ('assigned_to' == $columnName && Application::POST_TYPE == $postType) { |
|
145 | - glsr()->render('partials/editor/bulk-edit-assigned-to'); |
|
144 | + if( 'assigned_to' == $columnName && Application::POST_TYPE == $postType ) { |
|
145 | + glsr()->render( 'partials/editor/bulk-edit-assigned-to' ); |
|
146 | 146 | } |
147 | 147 | } |
148 | 148 | |
@@ -151,9 +151,9 @@ discard block |
||
151 | 151 | * @return void |
152 | 152 | * @action restrict_manage_posts |
153 | 153 | */ |
154 | - public function renderColumnFilters($postType) |
|
154 | + public function renderColumnFilters( $postType ) |
|
155 | 155 | { |
156 | - glsr(Columns::class)->renderFilters($postType); |
|
156 | + glsr( Columns::class )->renderFilters( $postType ); |
|
157 | 157 | } |
158 | 158 | |
159 | 159 | /** |
@@ -162,9 +162,9 @@ discard block |
||
162 | 162 | * @return void |
163 | 163 | * @action manage_posts_custom_column |
164 | 164 | */ |
165 | - public function renderColumnValues($column, $postId) |
|
165 | + public function renderColumnValues( $column, $postId ) |
|
166 | 166 | { |
167 | - glsr(Columns::class)->renderValues($column, $postId); |
|
167 | + glsr( Columns::class )->renderValues( $column, $postId ); |
|
168 | 168 | } |
169 | 169 | |
170 | 170 | /** |
@@ -172,14 +172,14 @@ discard block |
||
172 | 172 | * @return void |
173 | 173 | * @action save_post_.Application::POST_TYPE |
174 | 174 | */ |
175 | - public function saveBulkEditFields($postId) |
|
175 | + public function saveBulkEditFields( $postId ) |
|
176 | 176 | { |
177 | - if (!current_user_can('edit_posts')) { |
|
177 | + if( !current_user_can( 'edit_posts' ) ) { |
|
178 | 178 | return; |
179 | 179 | } |
180 | - $assignedTo = filter_input(INPUT_GET, 'assigned_to'); |
|
181 | - if ($assignedTo && get_post($assignedTo)) { |
|
182 | - glsr(Database::class)->update($postId, 'assigned_to', $assignedTo); |
|
180 | + $assignedTo = filter_input( INPUT_GET, 'assigned_to' ); |
|
181 | + if( $assignedTo && get_post( $assignedTo ) ) { |
|
182 | + glsr( Database::class )->update( $postId, 'assigned_to', $assignedTo ); |
|
183 | 183 | } |
184 | 184 | } |
185 | 185 | |
@@ -187,15 +187,15 @@ discard block |
||
187 | 187 | * @return void |
188 | 188 | * @action pre_get_posts |
189 | 189 | */ |
190 | - public function setQueryForColumn(WP_Query $query) |
|
190 | + public function setQueryForColumn( WP_Query $query ) |
|
191 | 191 | { |
192 | - if (!$this->hasPermission($query)) { |
|
192 | + if( !$this->hasPermission( $query ) ) { |
|
193 | 193 | return; |
194 | 194 | } |
195 | - $this->setMetaQuery($query, [ |
|
195 | + $this->setMetaQuery( $query, [ |
|
196 | 196 | 'rating', 'review_type', |
197 | - ]); |
|
198 | - $this->setOrderby($query); |
|
197 | + ] ); |
|
198 | + $this->setOrderby( $query ); |
|
199 | 199 | } |
200 | 200 | |
201 | 201 | /** |
@@ -204,15 +204,15 @@ discard block |
||
204 | 204 | */ |
205 | 205 | public function unapprove() |
206 | 206 | { |
207 | - if (Application::ID != filter_input(INPUT_GET, 'plugin')) { |
|
207 | + if( Application::ID != filter_input( INPUT_GET, 'plugin' ) ) { |
|
208 | 208 | return; |
209 | 209 | } |
210 | - check_admin_referer('unapprove-review_'.($postId = $this->getPostId())); |
|
211 | - wp_update_post([ |
|
210 | + check_admin_referer( 'unapprove-review_'.($postId = $this->getPostId()) ); |
|
211 | + wp_update_post( [ |
|
212 | 212 | 'ID' => $postId, |
213 | 213 | 'post_status' => 'pending', |
214 | - ]); |
|
215 | - wp_safe_redirect(wp_get_referer()); |
|
214 | + ] ); |
|
215 | + wp_safe_redirect( wp_get_referer() ); |
|
216 | 216 | exit; |
217 | 217 | } |
218 | 218 | |
@@ -221,7 +221,7 @@ discard block |
||
221 | 221 | * @param string $domain |
222 | 222 | * @return bool |
223 | 223 | */ |
224 | - protected function canModifyTranslation($domain = 'default') |
|
224 | + protected function canModifyTranslation( $domain = 'default' ) |
|
225 | 225 | { |
226 | 226 | $screen = glsr_current_screen(); |
227 | 227 | return 'default' == $domain |
@@ -232,48 +232,48 @@ discard block |
||
232 | 232 | /** |
233 | 233 | * @return bool |
234 | 234 | */ |
235 | - protected function hasPermission(WP_Query $query) |
|
235 | + protected function hasPermission( WP_Query $query ) |
|
236 | 236 | { |
237 | 237 | global $pagenow; |
238 | 238 | return is_admin() |
239 | 239 | && $query->is_main_query() |
240 | - && Application::POST_TYPE == $query->get('post_type') |
|
240 | + && Application::POST_TYPE == $query->get( 'post_type' ) |
|
241 | 241 | && 'edit.php' == $pagenow; |
242 | 242 | } |
243 | 243 | |
244 | 244 | /** |
245 | 245 | * @return void |
246 | 246 | */ |
247 | - protected function setMetaQuery(WP_Query $query, array $metaKeys) |
|
247 | + protected function setMetaQuery( WP_Query $query, array $metaKeys ) |
|
248 | 248 | { |
249 | - foreach ($metaKeys as $key) { |
|
250 | - $value = (string) filter_input(INPUT_GET, $key); |
|
251 | - if ('' === $value) { |
|
249 | + foreach( $metaKeys as $key ) { |
|
250 | + $value = (string)filter_input( INPUT_GET, $key ); |
|
251 | + if( '' === $value ) { |
|
252 | 252 | continue; |
253 | 253 | } |
254 | - $metaQuery = (array) $query->get('meta_query'); |
|
254 | + $metaQuery = (array)$query->get( 'meta_query' ); |
|
255 | 255 | $metaQuery[] = [ |
256 | - 'key' => Str::prefix('_', $key, '_'), |
|
256 | + 'key' => Str::prefix( '_', $key, '_' ), |
|
257 | 257 | 'value' => $value, |
258 | 258 | ]; |
259 | - $query->set('meta_query', array_filter($metaQuery)); |
|
259 | + $query->set( 'meta_query', array_filter( $metaQuery ) ); |
|
260 | 260 | } |
261 | 261 | } |
262 | 262 | |
263 | 263 | /** |
264 | 264 | * @return void |
265 | 265 | */ |
266 | - protected function setOrderby(WP_Query $query) |
|
266 | + protected function setOrderby( WP_Query $query ) |
|
267 | 267 | { |
268 | - $orderby = $query->get('orderby'); |
|
268 | + $orderby = $query->get( 'orderby' ); |
|
269 | 269 | $columns = glsr()->postTypeColumns[Application::POST_TYPE]; |
270 | 270 | unset($columns['cb'], $columns['title'], $columns['date']); |
271 | - if (in_array($orderby, array_keys($columns))) { |
|
272 | - if ('reviewer' == $orderby) { |
|
271 | + if( in_array( $orderby, array_keys( $columns ) ) ) { |
|
272 | + if( 'reviewer' == $orderby ) { |
|
273 | 273 | $orderby = 'author'; |
274 | 274 | } |
275 | - $query->set('meta_key', Str::prefix('_', $orderby, '_')); |
|
276 | - $query->set('orderby', 'meta_value'); |
|
275 | + $query->set( 'meta_key', Str::prefix( '_', $orderby, '_' ) ); |
|
276 | + $query->set( 'orderby', 'meta_value' ); |
|
277 | 277 | } |
278 | 278 | } |
279 | 279 | } |
@@ -6,29 +6,29 @@ |
||
6 | 6 | |
7 | 7 | class SiteReviewsFormShortcode extends Shortcode |
8 | 8 | { |
9 | - protected function hideOptions() |
|
10 | - { |
|
11 | - return [ |
|
12 | - 'rating' => __('Hide the rating field', 'site-reviews'), |
|
13 | - 'title' => __('Hide the title field', 'site-reviews'), |
|
14 | - 'content' => __('Hide the review field', 'site-reviews'), |
|
15 | - 'name' => __('Hide the name field', 'site-reviews'), |
|
16 | - 'email' => __('Hide the email field', 'site-reviews'), |
|
17 | - 'terms' => __('Hide the terms field', 'site-reviews'), |
|
18 | - ]; |
|
19 | - } |
|
9 | + protected function hideOptions() |
|
10 | + { |
|
11 | + return [ |
|
12 | + 'rating' => __('Hide the rating field', 'site-reviews'), |
|
13 | + 'title' => __('Hide the title field', 'site-reviews'), |
|
14 | + 'content' => __('Hide the review field', 'site-reviews'), |
|
15 | + 'name' => __('Hide the name field', 'site-reviews'), |
|
16 | + 'email' => __('Hide the email field', 'site-reviews'), |
|
17 | + 'terms' => __('Hide the terms field', 'site-reviews'), |
|
18 | + ]; |
|
19 | + } |
|
20 | 20 | |
21 | - /** |
|
22 | - * @param array|string $atts |
|
23 | - * @param string $type |
|
24 | - * @return array |
|
25 | - */ |
|
26 | - public function normalizeAtts($atts, $type = 'shortcode') |
|
27 | - { |
|
28 | - $atts = parent::normalizeAtts($atts, $type); |
|
29 | - if (empty($atts['id'])) { |
|
30 | - $atts['id'] = Application::PREFIX.substr(md5(serialize($atts)), 0, 8); |
|
31 | - } |
|
32 | - return $atts; |
|
33 | - } |
|
21 | + /** |
|
22 | + * @param array|string $atts |
|
23 | + * @param string $type |
|
24 | + * @return array |
|
25 | + */ |
|
26 | + public function normalizeAtts($atts, $type = 'shortcode') |
|
27 | + { |
|
28 | + $atts = parent::normalizeAtts($atts, $type); |
|
29 | + if (empty($atts['id'])) { |
|
30 | + $atts['id'] = Application::PREFIX.substr(md5(serialize($atts)), 0, 8); |
|
31 | + } |
|
32 | + return $atts; |
|
33 | + } |
|
34 | 34 | } |
@@ -9,12 +9,12 @@ discard block |
||
9 | 9 | protected function hideOptions() |
10 | 10 | { |
11 | 11 | return [ |
12 | - 'rating' => __('Hide the rating field', 'site-reviews'), |
|
13 | - 'title' => __('Hide the title field', 'site-reviews'), |
|
14 | - 'content' => __('Hide the review field', 'site-reviews'), |
|
15 | - 'name' => __('Hide the name field', 'site-reviews'), |
|
16 | - 'email' => __('Hide the email field', 'site-reviews'), |
|
17 | - 'terms' => __('Hide the terms field', 'site-reviews'), |
|
12 | + 'rating' => __( 'Hide the rating field', 'site-reviews' ), |
|
13 | + 'title' => __( 'Hide the title field', 'site-reviews' ), |
|
14 | + 'content' => __( 'Hide the review field', 'site-reviews' ), |
|
15 | + 'name' => __( 'Hide the name field', 'site-reviews' ), |
|
16 | + 'email' => __( 'Hide the email field', 'site-reviews' ), |
|
17 | + 'terms' => __( 'Hide the terms field', 'site-reviews' ), |
|
18 | 18 | ]; |
19 | 19 | } |
20 | 20 | |
@@ -23,11 +23,11 @@ discard block |
||
23 | 23 | * @param string $type |
24 | 24 | * @return array |
25 | 25 | */ |
26 | - public function normalizeAtts($atts, $type = 'shortcode') |
|
26 | + public function normalizeAtts( $atts, $type = 'shortcode' ) |
|
27 | 27 | { |
28 | - $atts = parent::normalizeAtts($atts, $type); |
|
29 | - if (empty($atts['id'])) { |
|
30 | - $atts['id'] = Application::PREFIX.substr(md5(serialize($atts)), 0, 8); |
|
28 | + $atts = parent::normalizeAtts( $atts, $type ); |
|
29 | + if( empty($atts['id']) ) { |
|
30 | + $atts['id'] = Application::PREFIX.substr( md5( serialize( $atts ) ), 0, 8 ); |
|
31 | 31 | } |
32 | 32 | return $atts; |
33 | 33 | } |