pryley / site-reviews

plugin/Database/CountsManager.php

Spacing +35 added lines, -35 removed lines

@@ -64,7 +64,7 @@ 
 			$this->getCounts(),
 			$review->review_type,
 			$review->rating
-		));
+		) );
 	}
 
 	/**
@@ -72,7 +72,7 @@ 
 	 */
 	public function decreasePostCounts( Review $review )
 	{
-		if( empty( $counts = $this->getPostCounts( $review->assigned_to )))return;
+		if( empty($counts = $this->getPostCounts( $review->assigned_to )) )return;
 		$counts = $this->decreaseRating( $counts, $review->review_type, $review->rating );
 		$this->setPostCounts( $review->assigned_to, $counts );
 	}
@@ -83,7 +83,7 @@ 
 	public function decreaseTermCounts( Review $review )
 	{
 		foreach( $review->term_ids as $termId ) {
-			if( empty( $counts = $this->getTermCounts( $termId )))continue;
+			if( empty($counts = $this->getTermCounts( $termId )) )continue;
 			$counts = $this->decreaseRating( $counts, $review->review_type, $review->rating );
 			$this->setTermCounts( $termId, $counts );
 		}
@@ -95,15 +95,15 @@ 
 	public function flatten( array $reviewCounts, array $args = [] )
 	{
 		$counts = [];
-		array_walk_recursive( $reviewCounts, function( $num, $index ) use( &$counts ) {
-			$counts[$index] = $num + intval( glsr_get( $counts, $index, 0 ));
+		array_walk_recursive( $reviewCounts, function( $num, $index ) use(&$counts) {
+			$counts[$index] = $num + intval( glsr_get( $counts, $index, 0 ) );
 		});
 		$args = wp_parse_args( $args, [
 			'max' => Rating::MAX_RATING,
 			'min' => Rating::MIN_RATING,
-		]);
+		] );
 		foreach( $counts as $index => &$num ) {
-			if( $index >= intval( $args['min'] ) && $index <= intval( $args['max'] ))continue;
+			if( $index >= intval( $args['min'] ) && $index <= intval( $args['max'] ) )continue;
 			$num = 0;
 		}
 		return $counts;
@@ -116,7 +116,7 @@ 
 	{
 		$args = $this->normalizeArgs( $args );
 
-		if( !empty( $args['post_ids'] ) && !empty( $args['term_ids'] )) {
+		if( !empty($args['post_ids']) && !empty($args['term_ids']) ) {
 			$counts = [$this->build( $args )];
 		}
 		else {
@@ -130,13 +130,13 @@ 
 				// @todo if multiple ids are provided, a query must be used!
 				$counts[] = $this->getTermCounts( $termId );
 			}
-			if( empty( $counts )) {
+			if( empty($counts) ) {
 				$counts[] = $this->getCounts();
 			}
 		}
 		return in_array( $args['type'], ['', 'all'] )
 			? $this->normalize( [$this->flatten( $counts )] )
-			: $this->normalize( glsr_array_column( $counts, $args['type'] ));
+			: $this->normalize( glsr_array_column( $counts, $args['type'] ) );
 	}
 
 	/**
@@ -145,7 +145,7 @@ 
 	public function getCounts()
 	{
 		$counts = glsr( OptionManager::class )->get( 'counts', [] );
-		if( !is_array( $counts )) {
+		if( !is_array( $counts ) ) {
 			glsr_log()->error( '$counts is not an array' )->debug( $counts );
 			return [];
 		}
@@ -158,7 +158,7 @@ 
 	 */
 	public function getPostCounts( $postId )
 	{
-		return array_filter( (array)get_post_meta( $postId, static::META_COUNT, true ));
+		return array_filter( (array)get_post_meta( $postId, static::META_COUNT, true ) );
 	}
 
 	/**
@@ -167,7 +167,7 @@ 
 	 */
 	public function getTermCounts( $termId )
 	{
-		return array_filter( (array)get_term_meta( $termId, static::META_COUNT, true ));
+		return array_filter( (array)get_term_meta( $termId, static::META_COUNT, true ) );
 	}
 
 	/**
@@ -185,10 +185,10 @@ 
 	 */
 	public function increaseCounts( Review $review )
 	{
-		if( empty( $counts = $this->getCounts() )) {
+		if( empty($counts = $this->getCounts()) ) {
 			$counts = $this->buildCounts();
 		}
-		$this->setCounts( $this->increaseRating( $counts, $review->review_type, $review->rating ));
+		$this->setCounts( $this->increaseRating( $counts, $review->review_type, $review->rating ) );
 	}
 
 	/**
@@ -196,9 +196,9 @@ 
 	 */
 	public function increasePostCounts( Review $review )
 	{
-		if( !( get_post( $review->assigned_to ) instanceof WP_Post ))return;
+		if( !(get_post( $review->assigned_to ) instanceof WP_Post) )return;
 		$counts = $this->getPostCounts( $review->assigned_to );
-		$counts = empty( $counts )
+		$counts = empty($counts)
 			? $this->buildPostCounts( $review->assigned_to )
 			: $this->increaseRating( $counts, $review->review_type, $review->rating );
 		$this->setPostCounts( $review->assigned_to, $counts );
@@ -209,10 +209,10 @@ 
 	 */
 	public function increaseTermCounts( Review $review )
 	{
-		$terms = glsr( ReviewManager::class )->normalizeTerms( implode( ',', $review->term_ids ));
+		$terms = glsr( ReviewManager::class )->normalizeTerms( implode( ',', $review->term_ids ) );
 		foreach( $terms as $term ) {
 			$counts = $this->getTermCounts( $term['term_id'] );
-			$counts = empty( $counts )
+			$counts = empty($counts)
 				? $this->buildTermCounts( $term['term_taxonomy_id'] )
 				: $this->increaseRating( $counts, $review->review_type, $review->rating );
 			$this->setTermCounts( $term['term_id'], $counts );
@@ -235,8 +235,8 @@ 
 	{
 		$ratingCounts = $this->flatten( $reviewCounts );
 		update_post_meta( $postId, static::META_COUNT, $reviewCounts );
-		update_post_meta( $postId, static::META_AVERAGE, glsr( Rating::class )->getAverage( $ratingCounts ));
-		update_post_meta( $postId, static::META_RANKING, glsr( Rating::class )->getRanking( $ratingCounts ));
+		update_post_meta( $postId, static::META_AVERAGE, glsr( Rating::class )->getAverage( $ratingCounts ) );
+		update_post_meta( $postId, static::META_RANKING, glsr( Rating::class )->getRanking( $ratingCounts ) );
 	}
 
 	/**
@@ -246,11 +246,11 @@ 
 	public function setTermCounts( $termId, array $reviewCounts )
 	{
 		$term = get_term( $termId, Application::TAXONOMY );
-		if( !isset( $term->term_id ))return;
+		if( !isset($term->term_id) )return;
 		$ratingCounts = $this->flatten( $reviewCounts );
 		update_term_meta( $termId, static::META_COUNT, $reviewCounts );
-		update_term_meta( $termId, static::META_AVERAGE, glsr( Rating::class )->getAverage( $ratingCounts ));
-		update_term_meta( $termId, static::META_RANKING, glsr( Rating::class )->getRanking( $ratingCounts ));
+		update_term_meta( $termId, static::META_AVERAGE, glsr( Rating::class )->getAverage( $ratingCounts ) );
+		update_term_meta( $termId, static::META_RANKING, glsr( Rating::class )->getRanking( $ratingCounts ) );
 	}
 
 	/**
@@ -262,12 +262,12 @@ 
 	{
 		$counts = [];
 		$lastPostId = 0;
-		while( $reviews = $this->queryReviews( $args, $lastPostId )) {
-			$types = array_keys( array_flip( glsr_array_column( $reviews, 'type' )));
-			$types = array_unique( array_merge( ['local'], $types ));
+		while( $reviews = $this->queryReviews( $args, $lastPostId ) ) {
+			$types = array_keys( array_flip( glsr_array_column( $reviews, 'type' ) ) );
+			$types = array_unique( array_merge( ['local'], $types ) );
 			foreach( $types as $type ) {
 				$type = $this->normalizeType( $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 ) {
@@ -286,7 +286,7 @@ 
 	 */
 	protected function decreaseRating( 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;
@@ -299,10 +299,10 @@ 
 	 */
 	protected function increaseRating( 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 );
@@ -315,12 +315,12 @@ 
 	 */
 	protected function normalize( array $reviewCounts )
 	{
-		if( empty( $reviewCounts )) {
+		if( empty($reviewCounts) ) {
 			$reviewCounts = [[]];
 		}
 		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 );
@@ -337,7 +337,7 @@ 
 			'post_ids' => [],
 			'term_ids' => [],
 			'type' => 'local',
-		]);
+		] );
 		$args['post_ids'] = glsr( Polylang::class )->getPostIds( $args['post_ids'] );
 		$args['type'] = $this->normalizeType( $args['type'] );
 		return $args;
@@ -349,7 +349,7 @@ 
 	 */
 	protected function normalizeType( $type )
 	{
-		return empty( $type ) || !is_string( $type )
+		return empty($type) || !is_string( $type )
 			? 'local'
 			: $type;
 	}

plugin/Database/SqlQueries.php

Spacing +26 added lines, -26 removed lines

@@ -21,11 +21,11 @@ 
 	 */
 	public function deleteAllSessions( $sessionCookiePrefix )
 	{
-		return $this->db->query("
+		return $this->db->query( "
 			DELETE
 			FROM {$this->db->options}
 			WHERE option_name LIKE '{$sessionCookiePrefix}_%'
-		");
+		" );
 	}
 
 	/**
@@ -34,11 +34,11 @@ 
 	 */
 	public function deleteExpiredSessions( $expiredSessions )
 	{
-		return $this->db->query("
+		return $this->db->query( "
 			DELETE
 			FROM {$this->db->options}
 			WHERE option_name IN ('{$expiredSessions}')
-		");
+		" );
 	}
 
 	/**
@@ -48,13 +48,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}
-		");
+		" );
 	}
 
 	/**
@@ -63,14 +63,14 @@ 
 	 */
 	public function getPostIdFromReviewId( $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 m ON p.ID = m.post_id
 			WHERE p.post_type = '{Application::POST_TYPE}'
 			AND m.meta_key = 'review_id'
 			AND m.meta_value = '{$metaReviewId}'
-		");
+		" );
 		return intval( $postId );
 	}
 
@@ -81,7 +81,7 @@ 
 	 */
 	public function getReviewCounts( array $args, $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
@@ -104,14 +104,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 = '{Application::POST_TYPE}'
 			AND m.meta_key = '{$metaKey}'
 			GROUP BY name
-		");
+		" );
 	}
 
 	/**
@@ -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,9 +141,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
@@ -167,7 +167,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
@@ -175,7 +175,7 @@ 
 			AND ({$key})
 			AND ({$status})
 			ORDER BY m.meta_value
-		");
+		" );
 	}
 
 	/**
@@ -184,11 +184,11 @@ 
 	 */
 	protected function getAndForCounts( array $args, $and = '' )
 	{
-		if( !empty( $args['post_id'] )) {
-			$and.= "AND m3.meta_key = 'assigned_to' AND m3.meta_value = {$args['post_id']}";
+		if( !empty($args['post_id']) ) {
+			$and .= "AND m3.meta_key = 'assigned_to' AND m3.meta_value = {$args['post_id']}";
 		}
-		if( !empty( $args['term_taxonomy_id'] )) {
-			$and.= "AND tr.term_taxonomy_id = {$args['term_taxonomy_id']}";
+		if( !empty($args['term_taxonomy_id']) ) {
+			$and .= "AND tr.term_taxonomy_id = {$args['term_taxonomy_id']}";
 		}
 		return $and;
 	}
@@ -199,11 +199,11 @@ 
 	 */
 	protected function getInnerJoinForCounts( array $args, $innerJoin = '' )
 	{
-		if( !empty( $args['post_id'] )) {
-			$innerJoin.= "INNER JOIN {$this->db->postmeta} AS m3 ON p.ID = m3.post_id";
+		if( !empty($args['post_id']) ) {
+			$innerJoin .= "INNER JOIN {$this->db->postmeta} AS m3 ON p.ID = m3.post_id";
 		}
-		if( !empty( $args['term_taxonomy_id'] )) {
-			$innerJoin.= "INNER JOIN {$this->db->term_relationships} AS tr ON p.ID = tr.object_id";
+		if( !empty($args['term_taxonomy_id']) ) {
+			$innerJoin .= "INNER JOIN {$this->db->term_relationships} AS tr ON p.ID = tr.object_id";
 		}
 		return $innerJoin;
 	}