<?php

namespace AdditionalAuthors;
use function AdditionalAuthors\Table\tablename;

/**
 * Class QueryManipulation
 * @package AdditionalAuthors
 * @deprecated Use taxonomy solution
 */
class QueryManipulation {

	/**
	 * @var string author query
	 */
	private $author_name;

	/**
	 * Query constructor.
	 *
	 * @param Plugin $plugin
	 */
	function __construct( Plugin $plugin ) {

		$this->plugin = $plugin;
		$this->isGroupingNeeded = false;

		// Manipulate author query to show also posts, where this author is set
		// in a post meta field.
		add_filter( 'posts_join', array( $this, 'posts_join' ), 10, 2 );
		add_filter( 'posts_where', array( $this, 'posts_where' ), 10, 2 );
		add_filter( 'posts_groupby', array( $this, 'posts_groupby' ) );
		add_filter( 'get_usernumposts', array( $this, 'change_num_posts' ), 10, 4 );

		// WP_User query
		add_action('pre_user_query', array($this, 'pre_user_query'));
	}

	/**
	 * @param \WP_Query $wp_query
	 *
	 * @return bool
	 */
	private function isIgnored($wp_query){
		return $wp_query->get('author_ignore_additional', apply_filters(Plugin::FILTER_WP_QUERY_IGNORE_ADDITIONAL_DEFAULT, false)) !== false;
	}

	/**
	 * @param \WP_Query $wp_query
	 *
	 * @return bool|int
	 */
	private function getAuthorId($wp_query){

		// at the moment we are only compatible with an single author id
		// TODO: handle coma separated list of ids
		// TODO: handle author__in
		// TODO: handle author__not_in
		$author_id = $wp_query->get('author');
		if( (is_int($author_id) && $author_id > 0) || (is_string($author_id) && $author_id != "" && intval($author_id)."" === $author_id)){
			return intval($author_id);
		}
		return false;
	}

	/**
	 * @param \WP_Query $wp_query
	 *
	 * @return bool
	 */
	private function isManipulationNeeded($wp_query){
		$author_id = $this->getAuthorId($wp_query);
		return $author_id !== false && (is_author() || !$this->isIgnored($wp_query));

	}

	/**
	 * JOIN statement
	 *
	 * @param  string $join The JOIN clause of the query.
	 *
	 * @param \WP_Query $wp_query
	 *
	 * @return string $join
	 */
	function posts_join( $join, $wp_query ) {
		if(
			$this->isManipulationNeeded($wp_query)
		){
			global $wpdb;
			$join .= "LEFT JOIN ".Table\tablename()." ON ({$wpdb->posts}.ID = ".Table\tablename().".post_id)";
			$this->isGroupingNeeded = true;
		} else {
			$this->isGroupingNeeded = false;
		}

		return $join;
	}

	/**
	 * WHERE statement
	 *
	 * @param  string $where The WHERE clause of the query.
	 *
	 * @param \WP_Query $wp_query
	 *
	 * @return string $where
	 */
	function posts_where( $where, $wp_query ) {

		if ( !$this->isManipulationNeeded($wp_query) ) {
			return $where;
		}

		$author_id = $this->getAuthorId($wp_query);

		global $wpdb;

		$where = str_replace(
			"{$wpdb->posts}.post_author IN ({$author_id})",
			"( {$wpdb->posts}.post_author IN ({$author_id}) OR ".Table\tablename().".author_id = {$author_id})",
			$where
		);

		$where = str_replace(
			"{$wpdb->posts}.post_author = {$author_id}",
			Table\tablename().".author_id = {$author_id} OR {$wpdb->posts}.post_author = {$author_id}",
			$where
		);

		return $where;
	}

	/**
	 * GROUP BY statement
	 *
	 * @param  string $groupby The GROUP BY clause of the query.
	 *
	 * @return string $groupby
	 */
	function posts_groupby( $groupby ) {

		if ( !$this->isGroupingNeeded ) {
			return $groupby;
		}

		global $wpdb;
		return "{$wpdb->posts}.ID";
	}

	function change_num_posts( $count, $userid, $post_type, $public_only ) {

		global $wpdb;

		$select = "SELECT count(*) FROM $wpdb->posts LEFT JOIN ".tablename()." ON ".tablename().".post_id = $wpdb->posts.ID ";
		$where = "WHERE author_id = $userid";
		if($post_type != "any") $where.= " AND post_type = '$post_type'";

		$additional_count = $wpdb->get_var( $select.$where );

		return (int)$count + (int)$additional_count;
	}

	/**
	 * @param \WP_User_Query $query
	 */
	function pre_user_query($query){
		global $wpdb;
		if(
			$query->get("has_published_posts") === true
		   &&
			$query->get(Plugin::WP_USER_QUERY_ARG_IGNORE_PUBLISHED_AS_ADDITIONAL_AUTHOR) !== true
		) {
			$start_string = "AND $wpdb->users.ID IN ( ";
			
			$inject_where_additional_authors = " $wpdb->users.ID IN ( SELECT author_id FROM ".Table\tablename()." ) ";

			$new_start    = "AND ( $inject_where_additional_authors OR $wpdb->users.ID IN ( ";
			$end_string   = ") )";

			$where = $query->query_where;
			$start = strpos( $where, $start_string );
			$end   = strpos( $where, $end_string, $start );

			$where = substr_replace( $where, ") ", $end, 0 );

			$where = str_replace( $start_string, $new_start, $where );

			$query->query_where = $where;
		}
	}
}