@@ -108,7 +108,8 @@ |
||
108 | 108 | constant($integrationClass.'::PLUGIN_NAME') |
109 | 109 | )); |
110 | 110 | return false; |
111 | - } elseif (!glsr($integrationClass)->isSupported()) { |
|
111 | + } |
|
112 | + elseif (!glsr($integrationClass)->isSupported()) { |
|
112 | 113 | glsr(Notice::class)->addError(sprintf( |
113 | 114 | __('Please update the %s plugin to v%s or greater to enable integration.', 'site-reviews'), |
114 | 115 | constant($integrationClass.'::PLUGIN_NAME'), |
@@ -22,7 +22,7 @@ discard block |
||
22 | 22 | * @return int |
23 | 23 | */ |
24 | 24 | public function getPostIdFromReviewId($metaReviewId) |
25 | - { |
|
25 | + { |
|
26 | 26 | $postId = $this->db->get_var(" |
27 | 27 | SELECT p.ID |
28 | 28 | FROM {$this->db->posts} AS p |
@@ -40,7 +40,7 @@ discard block |
||
40 | 40 | * @return array |
41 | 41 | */ |
42 | 42 | public function getReviewCounts(array $args, $lastPostId = 0, $limit = 500) |
43 | - { |
|
43 | + { |
|
44 | 44 | return (array) $this->db->get_results(" |
45 | 45 | SELECT DISTINCT p.ID, m1.meta_value AS rating, m2.meta_value AS type |
46 | 46 | FROM {$this->db->posts} AS p |
@@ -64,7 +64,7 @@ discard block |
||
64 | 64 | * @return array |
65 | 65 | */ |
66 | 66 | public function getReviewCountsFor($metaKey) |
67 | - { |
|
67 | + { |
|
68 | 68 | $metaKey = glsr(Helper::class)->prefix('_', $metaKey); |
69 | 69 | return (array) $this->db->get_results(" |
70 | 70 | SELECT DISTINCT m.meta_value AS name, COUNT(*) num_posts |
@@ -82,7 +82,7 @@ discard block |
||
82 | 82 | * @return array |
83 | 83 | */ |
84 | 84 | public function getReviewIdsByType($reviewType) |
85 | - { |
|
85 | + { |
|
86 | 86 | $results = $this->db->get_col(" |
87 | 87 | SELECT DISTINCT m1.meta_value AS review_id |
88 | 88 | FROM {$this->db->posts} AS p |
@@ -102,7 +102,7 @@ discard block |
||
102 | 102 | * @return array |
103 | 103 | */ |
104 | 104 | public function getReviewRatingsFromIds(array $postIds, $greaterThanId = 0, $limit = 100) |
105 | - { |
|
105 | + { |
|
106 | 106 | sort($postIds); |
107 | 107 | $postIds = array_slice($postIds, intval(array_search($greaterThanId, $postIds)), $limit); |
108 | 108 | $postIds = implode(',', $postIds); |
@@ -127,7 +127,7 @@ discard block |
||
127 | 127 | * @return array |
128 | 128 | */ |
129 | 129 | public function getReviewsMeta($key, $status = 'publish') |
130 | - { |
|
130 | + { |
|
131 | 131 | $key = glsr(Helper::class)->prefix('_', $key); |
132 | 132 | $values = $this->db->get_col(" |
133 | 133 | SELECT DISTINCT m.meta_value |
@@ -149,7 +149,7 @@ discard block |
||
149 | 149 | * @return string |
150 | 150 | */ |
151 | 151 | protected function getAndForCounts(array $args, $and = '') |
152 | - { |
|
152 | + { |
|
153 | 153 | $postIds = implode(',', array_filter(glsr_get($args, 'post_ids'))); |
154 | 154 | $termIds = implode(',', array_filter(glsr_get($args, 'term_ids'))); |
155 | 155 | if (!empty($args['type'])) { |
@@ -169,7 +169,7 @@ discard block |
||
169 | 169 | * @return string |
170 | 170 | */ |
171 | 171 | protected function getInnerJoinForCounts(array $args, $innerJoin = '') |
172 | - { |
|
172 | + { |
|
173 | 173 | if (!empty(glsr_get($args, 'post_ids'))) { |
174 | 174 | $innerJoin.= "INNER JOIN {$this->db->postmeta} AS m3 ON p.ID = m3.post_id "; |
175 | 175 | } |