pryley / site-reviews

plugin/Database/CountsManager.php

Spacing +13 added lines, -13 removed lines

@@ -46,7 +46,7 @@ 
 	 */
 	public function decrease( array $reviewCounts, $type, $rating )
 	{
-		if( isset( $reviewCounts[$type][$rating] )) {
+		if( isset($reviewCounts[$type][$rating]) ) {
 			$reviewCounts[$type][$rating] = max( 0, $reviewCounts[$type][$rating] - 1 );
 		}
 		return $reviewCounts;
@@ -58,8 +58,8 @@ 
 	public function flatten( array $reviewCounts )
 	{
 		$counts = [];
-		array_walk_recursive( $reviewCounts, function( $num, $index ) use( &$counts ) {
-			$counts[$index] = isset( $counts[$index] )
+		array_walk_recursive( $reviewCounts, function( $num, $index ) use(&$counts) {
+			$counts[$index] = isset($counts[$index])
 				? $num + $counts[$index]
 				: $num;
 		});
@@ -99,10 +99,10 @@ 
 	 */
 	public function increase( array $reviewCounts, $type, $rating )
 	{
-		if( !array_key_exists( $type, glsr()->reviewTypes )) {
+		if( !array_key_exists( $type, glsr()->reviewTypes ) ) {
 			return $reviewCounts;
 		}
-		if( !array_key_exists( $type, $reviewCounts )) {
+		if( !array_key_exists( $type, $reviewCounts ) ) {
 			$reviewCounts[$type] = [];
 		}
 		$reviewCounts = $this->normalize( $reviewCounts );
@@ -144,10 +144,10 @@ 
 	{
 		$counts = [];
 		$lastPostId = 0;
-		while( $reviews = $this->queryReviews( $args, $lastPostId, $limit )) {
-			$types = array_keys( array_flip( array_column( $reviews, 'type' )));
+		while( $reviews = $this->queryReviews( $args, $lastPostId, $limit ) ) {
+			$types = array_keys( array_flip( array_column( $reviews, 'type' ) ) );
 			foreach( $types as $type ) {
-				if( isset( $counts[$type] ))continue;
+				if( isset($counts[$type]) )continue;
 				$counts[$type] = array_fill_keys( range( 0, Rating::MAX_RATING ), 0 );
 			}
 			foreach( $reviews as $review ) {
@@ -165,7 +165,7 @@ 
 	{
 		foreach( $reviewCounts as &$counts ) {
 			foreach( range( 0, Rating::MAX_RATING ) as $index ) {
-				if( isset( $counts[$index] ))continue;
+				if( isset($counts[$index]) )continue;
 				$counts[$index] = 0;
 			}
 			ksort( $counts );
@@ -180,14 +180,14 @@ 
 	 */
 	protected function queryReviews( array $args = [], $lastPostId, $limit )
 	{
-		$args = wp_parse_args( $args, array_fill_keys( ['post_id', 'term_id'], '' ));
-		if( empty( array_filter( $args ))) {
+		$args = wp_parse_args( $args, array_fill_keys( ['post_id', 'term_id'], '' ) );
+		if( empty(array_filter( $args )) ) {
 			return glsr( SqlQueries::class )->getReviewCounts( $lastPostId, $limit );
 		}
-		if( !empty( $args['post_id'] )) {
+		if( !empty($args['post_id']) ) {
 			return glsr( SqlQueries::class )->getReviewPostCounts( $args['post_id'], $lastPostId, $limit );
 		}
-		if( !empty( $args['term_id'] )) {
+		if( !empty($args['term_id']) ) {
 			return glsr( SqlQueries::class )->getReviewTermCounts( $args['term_id'], $lastPostId, $limit );
 		}
 	}

plugin/Database/SqlQueries.php

Spacing +20 added lines, -20 removed lines

@@ -23,11 +23,11 @@ 
 	 */
 	public function deleteAllSessions( $sessionCookiePrefix )
 	{
-		return $this->db->query("
+		return $this->db->query( "
 			DELETE
 			FROM {$this->db->options}
 			WHERE option_name LIKE '{$sessionCookiePrefix}_%'
-		");
+		" );
 	}
 
 	/**
@@ -36,11 +36,11 @@ 
 	 */
 	public function deleteExpiredSessions( $expiredSessions )
 	{
-		return $this->db->query("
+		return $this->db->query( "
 			DELETE
 			FROM {$this->db->options}
 			WHERE option_name IN ('{$expiredSessions}')
-		");
+		" );
 	}
 
 	/**
@@ -49,14 +49,14 @@ 
 	 */
 	public function getReviewCountsFor( $metaKey )
 	{
-		return (array) $this->db->get_results("
+		return (array)$this->db->get_results( "
 			SELECT m.meta_value AS name, COUNT(*) num_posts
 			FROM {$this->db->posts} AS p
 			INNER JOIN {$this->db->postmeta} AS m ON p.ID = m.post_id
 			WHERE p.post_type = '{$this->postType}'
 			AND m.meta_key = '{$metaKey}'
 			GROUP BY name
-		");
+		" );
 	}
 
 	/**
@@ -66,13 +66,13 @@ 
 	 */
 	public function getExpiredSessions( $sessionCookiePrefix, $limit )
 	{
-		return $this->db->get_results("
+		return $this->db->get_results( "
 			SELECT option_name AS name, option_value AS expiration
 			FROM {$this->db->options}
 			WHERE option_name LIKE '{$sessionCookiePrefix}_expires_%'
 			ORDER BY option_value ASC
 			LIMIT 0, {$limit}
-		");
+		" );
 	}
 
 	/**
@@ -82,7 +82,7 @@ 
 	 */
 	public function getReviewCounts( $lastPostId = 0, $limit = 500 )
 	{
-		return $this->db->get_results("
+		return $this->db->get_results( "
 			SELECT p.ID, m1.meta_value AS rating, m2.meta_value AS type
 			FROM {$this->db->posts} AS p
 			INNER JOIN {$this->db->postmeta} AS m1 ON p.ID = m1.post_id
@@ -103,14 +103,14 @@ 
 	 */
 	public function getReviewPostId( $metaReviewId )
 	{
-		$postId = $this->db->get_var("
+		$postId = $this->db->get_var( "
 			SELECT p.ID
 			FROM {$this->db->posts} AS p
 			INNER JOIN {$this->db->postmeta} AS pm ON p.ID = pm.post_id
 			WHERE p.post_type = '{$this->postType}'
 			AND pm.meta_key = 'review_id'
 			AND pm.meta_value = '{$metaReviewId}'
-		");
+		" );
 		return intval( $postId );
 	}
 
@@ -120,7 +120,7 @@ 
 	 */
 	public function getReviewIdsByType( $reviewType )
 	{
-		$query = $this->db->get_col("
+		$query = $this->db->get_col( "
 			SELECT m1.meta_value AS review_id
 			FROM {$this->db->posts} AS p
 			INNER JOIN {$this->db->postmeta} AS m1 ON p.ID = m1.post_id
@@ -129,8 +129,8 @@ 
 			AND m1.meta_key = 'review_id'
 			AND m2.meta_key = 'review_type'
 			AND m2.meta_value = '{$reviewType}'
-		");
-		return array_keys( array_flip( $query ));
+		" );
+		return array_keys( array_flip( $query ) );
 	}
 
 	/**
@@ -141,7 +141,7 @@ 
 	 */
 	public function getReviewPostCounts( $postId, $lastPostId = 0, $limit = 500 )
 	{
-		return $this->db->get_results("
+		return $this->db->get_results( "
 			SELECT p.ID, m1.meta_value AS rating, m2.meta_value AS type
 			FROM {$this->db->posts} AS p
 			INNER JOIN {$this->db->postmeta} AS m1 ON p.ID = m1.post_id
@@ -167,9 +167,9 @@ 
 	public function getReviewRatingsFromIds( array $postIds, $greaterThanId = 0, $limit = 100 )
 	{
 		sort( $postIds );
-		$postIds = array_slice( $postIds, intval( array_search( $greaterThanId, $postIds )), $limit );
+		$postIds = array_slice( $postIds, intval( array_search( $greaterThanId, $postIds ) ), $limit );
 		$postIds = implode( ',', $postIds );
-		return $this->db->get_results("
+		return $this->db->get_results( "
 			SELECT p.ID, m.meta_value AS rating
 			FROM {$this->db->posts} AS p
 			INNER JOIN {$this->db->postmeta} AS m ON p.ID = m.post_id
@@ -193,7 +193,7 @@ 
 		$queryBuilder = glsr( QueryBuilder::class );
 		$key = $queryBuilder->buildSqlOr( $key, "m.meta_key = '%s'" );
 		$status = $queryBuilder->buildSqlOr( $status, "p.post_status = '%s'" );
-		return $this->db->get_col("
+		return $this->db->get_col( "
 			SELECT DISTINCT m.meta_value
 			FROM {$this->db->postmeta} m
 			LEFT JOIN {$this->db->posts} p ON p.ID = m.post_id
@@ -201,7 +201,7 @@ 
 			AND ({$key})
 			AND ({$status})
 			ORDER BY m.meta_value
-		");
+		" );
 	}
 
 	/**
@@ -212,7 +212,7 @@ 
 	 */
 	public function getReviewTermCounts( $termId, $lastPostId = 0, $limit = 500 )
 	{
-		return $this->db->get_results("
+		return $this->db->get_results( "
 			SELECT p.ID, m1.meta_value AS rating, m2.meta_value AS type
 			FROM {$this->db->posts} AS p
 			INNER JOIN {$this->db->postmeta} AS m1 ON p.ID = m1.post_id