pryley / site-reviews

plugin/Database/SqlQueries.php

Spacing +30 added lines, -30 removed lines

@@ -22,11 +22,11 @@ 
 	 */
 	public function deleteAllSessions( $sessionCookiePrefix )
 	{
-		return $this->db->query("
+		return $this->db->query( "
 			DELETE
 			FROM {$this->db->options}
 			WHERE option_name LIKE '{$sessionCookiePrefix}_%'
-		");
+		" );
 	}
 
 	/**
@@ -35,11 +35,11 @@ 
 	 */
 	public function deleteExpiredSessions( $expiredSessions )
 	{
-		return $this->db->query("
+		return $this->db->query( "
 			DELETE
 			FROM {$this->db->options}
 			WHERE option_name IN ('{$expiredSessions}')
-		");
+		" );
 	}
 
 	/**
@@ -49,13 +49,13 @@ 
 	 */
 	public function getExpiredSessions( $sessionCookiePrefix, $limit )
 	{
-		return (array) $this->db->get_results("
+		return (array)$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}
-		");
+		" );
 	}
 
 	/**
@@ -64,14 +64,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 = '{$this->postType}'
 			AND m.meta_key = 'review_id'
 			AND m.meta_value = '{$metaReviewId}'
-		");
+		" );
 		return intval( $postId );
 	}
 
@@ -82,7 +82,7 @@ 
 	 */
 	public function getReviewCounts( array $args, $lastPostId = 0, $limit = 500 )
 	{
-		return (array) $this->db->get_results("
+		return (array)$this->db->get_results( "
 			SELECT DISTINCT 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
@@ -96,7 +96,7 @@ 
 			{$this->getAndForCounts( $args )}
 			ORDER By p.ID ASC
 			LIMIT {$limit}
-		");
+		" );
 	}
 
 	/**
@@ -106,14 +106,14 @@ 
 	 */
 	public function getReviewCountsFor( $metaKey )
 	{
-		return (array) $this->db->get_results("
+		return (array)$this->db->get_results( "
 			SELECT DISTINCT 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
-		");
+		" );
 	}
 
 	/**
@@ -123,7 +123,7 @@ 
 	 */
 	public function getReviewIdsByType( $reviewType )
 	{
-		$results = $this->db->get_col("
+		$results = $this->db->get_col( "
 			SELECT DISTINCT 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
@@ -132,8 +132,8 @@ 
 			AND m1.meta_key = 'review_id'
 			AND m2.meta_key = 'review_type'
 			AND m2.meta_value = '{$reviewType}'
-		");
-		return array_keys( array_flip( $results ));
+		" );
+		return array_keys( array_flip( $results ) );
 	}
 
 	/**
@@ -144,9 +144,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 (array) $this->db->get_results("
+		return (array)$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
@@ -158,7 +158,7 @@ 
 			GROUP BY p.ID
 			ORDER By p.ID ASC
 			LIMIT {$limit}
-		");
+		" );
 	}
 
 	/**
@@ -168,7 +168,7 @@ 
 	 */
 	public function getReviewsMeta( $key, $status = 'publish' )
 	{
-		$values = $this->db->get_col("
+		$values = $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
@@ -178,7 +178,7 @@ 
 			AND p.post_status = '{$status}'
 			GROUP BY p.ID -- remove duplicate meta_value entries
 			ORDER BY m.meta_id ASC -- sort by oldest meta_value
-		");
+		" );
 		sort( $values );
 		return $values;
 	}
@@ -189,16 +189,16 @@ 
 	 */
 	protected function getAndForCounts( array $args, $and = '' )
 	{
-		$postIds = implode( ',', array_filter( glsr_get( $args, 'post_ids')));
-		$termIds = implode( ',', array_filter( glsr_get( $args, 'term_ids')));
-		if( !empty( $args['type'] )) {
-			$and.= "AND m2.meta_value = '{$args['type']}' ";
+		$postIds = implode( ',', array_filter( glsr_get( $args, 'post_ids' ) ) );
+		$termIds = implode( ',', array_filter( glsr_get( $args, 'term_ids' ) ) );
+		if( !empty($args['type']) ) {
+			$and .= "AND m2.meta_value = '{$args['type']}' ";
 		}
 		if( $postIds ) {
-			$and.= "AND m3.meta_key = 'assigned_to' AND m3.meta_value IN ({$postIds}) ";
+			$and .= "AND m3.meta_key = 'assigned_to' AND m3.meta_value IN ({$postIds}) ";
 		}
 		if( $termIds ) {
-			$and.= "AND tr.term_taxonomy_id IN ({$termIds}) ";
+			$and .= "AND tr.term_taxonomy_id IN ({$termIds}) ";
 		}
 		return apply_filters( 'site-reviews/query/and-for-counts', $and );
 	}
@@ -209,11 +209,11 @@ 
 	 */
 	protected function getInnerJoinForCounts( array $args, $innerJoin = '' )
 	{
-		if( !empty( glsr_get( $args, 'post_ids'))) {
-			$innerJoin.= "INNER JOIN {$this->db->postmeta} AS m3 ON p.ID = m3.post_id ";
+		if( !empty(glsr_get( $args, 'post_ids' )) ) {
+			$innerJoin .= "INNER JOIN {$this->db->postmeta} AS m3 ON p.ID = m3.post_id ";
 		}
-		if( !empty( glsr_get( $args, 'term_ids'))) {
-			$innerJoin.= "INNER JOIN {$this->db->term_relationships} AS tr ON p.ID = tr.object_id ";
+		if( !empty(glsr_get( $args, 'term_ids' )) ) {
+			$innerJoin .= "INNER JOIN {$this->db->term_relationships} AS tr ON p.ID = tr.object_id ";
 		}
 		return apply_filters( 'site-reviews/query/inner-join-for-counts', $innerJoin );
 	}