# powerkit/2.3.7/modules/post-views/helpers/query-powerkit-post-views.php

Powerkit – Supercharge your WordPress Site, version 2.3.7. 91 lines.

- Page: https://pluginprobe.com/plugins/powerkit/2.3.7/code/modules/post-views/helpers/query-powerkit-post-views.php
- Raw: https://pluginprobe.com/plugins/powerkit/2.3.7/raw/modules/post-views/helpers/query-powerkit-post-views.php
- Modified: 2020-10-01T06:43:30+00:00

Line numbers below start at 1. Link to a line or a range by appending a fragment to the
page URL, for example `https://pluginprobe.com/plugins/powerkit/2.3.7/code/modules/post-views/helpers/query-powerkit-post-views.php#L10-L20`.

```php
<?php
/**
 * Post Views Query
 *
 * @package    Powerkit
 * @subpackage Modules/Query
 */

class Powerkit_Post_Views_Query {

	/**
	 * Construct.
	 */
	public function __construct() {
		add_action( 'pre_get_posts', array( $this, 'extend_pre_query' ), 1 );
		add_filter( 'posts_join', array( $this, 'posts_join' ), 10, 2 );
		add_filter( 'posts_groupby', array( $this, 'posts_groupby' ), 10, 2 );
		add_filter( 'posts_orderby', array( $this, 'posts_orderby' ), 10, 2 );
	}

	/**
	 * Extend query with post_views orderby parameter.
	 *
	 * @param object $query The query.
	 */
	public function extend_pre_query( $query ) {
		if ( isset( $query->query_vars['orderby'] ) && 'pk_post_views' === $query->query_vars['orderby'] ) {
			$query->pk_post_views = true;
		}
	}

	/**
	 * Modify the db query to use post_views parameter.
	 *
	 * @param string $join  The join.
	 * @param object $query The query.
	 */
	public function posts_join( $join, $query ) {

		if ( isset( $query->pk_post_views ) && $query->pk_post_views ) {
			global $wpdb;

			$join .= ' LEFT JOIN ' . $wpdb->prefix . 'pk_post_views ON ' . $wpdb->prefix . 'pk_post_views.id = ' . $wpdb->prefix . 'posts.ID';
		}

		return $join;
	}

	/**
	 * Group posts using the post ID.
	 *
	 * @param string $groupby The groupby.
	 * @param object $query   The query.
	 */
	public function posts_groupby( $groupby, $query ) {

		if ( isset( $query->pk_post_views ) && $query->pk_post_views ) {
			global $wpdb;

			$groupby = trim( $groupby );

			if ( false === strpos( $groupby, $wpdb->prefix . 'posts.ID' ) ) {
				$groupby = ( '' !== $groupby ? $groupby . ', ' : '' ) . $wpdb->prefix . 'posts.ID';
			}
		}

		return $groupby;
	}

	/**
	 * Order posts by post views.
	 *
	 * @param string $orderby The orderby.
	 * @param object $query   The query.
	 */
	public function posts_orderby( $orderby, $query ) {
		if ( isset( $query->pk_post_views ) && $query->pk_post_views ) {
			global $wpdb;

			$order = $query->get( 'order' );

			$orderby = $wpdb->prefix . 'pk_post_views.count ' . $order . ', ' . $wpdb->prefix . 'posts.ID ' . $order;
		}

		return $orderby;
	}
}


new Powerkit_Post_Views_Query();

```