<?php
/**
 * BuddyBoss LearnDash integration reports class.
 *
 * @package BuddyBoss\LearnDash
 * @since BuddyBoss 1.0.0
 */

namespace Buddyboss\LearndashIntegration\Buddypress;

use Buddyboss\LearndashIntegration\Buddypress\Generators\AllReportsGenerator;
use Buddyboss\LearndashIntegration\Buddypress\Generators\AssignmentsReportsGenerator;
use Buddyboss\LearndashIntegration\Buddypress\Generators\CoursesReportsGenerator;
use Buddyboss\LearndashIntegration\Buddypress\Generators\EssaysReportsGenerator;
use Buddyboss\LearndashIntegration\Buddypress\Generators\LessonsReportsGenerator;
use Buddyboss\LearndashIntegration\Buddypress\Generators\QuizzesReportsGenerator;
use Buddyboss\LearndashIntegration\Buddypress\Generators\TopicsReportsGenerator;

// Exit if accessed directly.
defined( 'ABSPATH' ) || exit;

/**
 * Class for all reports related functions
 *
 * @since BuddyBoss 1.0.0
 */
class Reports {

	protected $isRealJoins = false;

	/**
	 * Constructor
	 *
	 * @since BuddyBoss 1.0.0
	 */
	public function __construct() {
		 add_action( 'bp_ld_sync/init', array( $this, 'init' ) );
	}

	/**
	 * Add actions once integration is ready
	 *
	 * @since BuddyBoss 1.0.0
	 */
	public function init() {
		add_action( 'bp_enqueue_scripts', array( $this, 'registerReportsScript' ) );

		// add plugable templates to report actions
		add_action( 'bp_ld_sync/reports', array( $this, 'showReportFilters' ), 10 );
		add_action( 'bp_ld_sync/reports', array( $this, 'showReportUserStats' ), 20 );
		add_action( 'bp_ld_sync/reports', array( $this, 'showReportCourseStats' ), 20 );
		add_action( 'bp_ld_sync/reports', array( $this, 'showReportTables' ), 30 );
		add_action( 'bp_ld_sync/reports', array( $this, 'showReportExport' ), 40 );

		add_filter( 'bp_ld_sync/reports_generator_params', array( $this, 'forceOwnReportResults' ), 99 );
		add_filter( 'bp_ld_sync/reports_generator_params', array( $this, 'courseReportResults' ), 99 );

		add_filter( 'bp_ld_sync/report_filters', array( $this, 'removeCourseFilterIfOnlyOne' ) );
		add_filter( 'bp_ld_sync/report_filters', array( $this, 'removeUserFilterIfStudent' ) );

		add_filter( 'learndash_user_activity_query_fields', array( $this, 'reportAdditionalActivityFields' ), 10, 2 );
		add_filter( 'learndash_user_activity_query_tables', array( $this, 'reportAdditionalActivityTables' ), 10, 2 );
		add_filter( 'learndash_user_activity_query_where', array( $this, 'reportAdditionalActivityWheres' ), 10, 2 );
		add_filter( 'learndash_user_activity_query_where', array( $this, 'reportAdditionalActivityGroups' ), 15, 2 );

		add_filter( 'bp_ld_sync/report_columns', array( $this, 'removeUserColumnIfSelected' ), 10, 2 );
		add_filter( 'bp_ld_sync/report_columns', array( $this, 'removeCourseColumnIfSelected' ), 10, 2 );
		add_filter( 'bp_ld_sync/report_columns', array( $this, 'removePointsColumnIfNotAssigned' ), 10, 2 );

		add_action( 'bp_ld_sync/export_report_column', array( $this, 'export_report_column' ), 10, 2 );
	}

	/**
	 * Add scripts when it's on the reports page
	 *
	 * @since BuddyBoss 1.0.0
	 */
	public function registerReportsScript() {
		if ( ! bp_is_groups_component() || ! bp_is_current_action( 'reports' ) ) {
			return;
		}

		wp_enqueue_script( 'bp-ld-reports-datatable', '//cdn.datatables.net/1.10.19/js/jquery.dataTables.min.js', array( 'jquery' ), false, true );
		wp_enqueue_style( 'bp-ld-reports-datatable', '//cdn.datatables.net/1.10.19/css/jquery.dataTables.min.css', array(), false );

		wp_enqueue_script(
			'bp-ld-reports',
			bp_learndash_url( $filePath = '/assets/scripts/bp-learndash.js' ),
			array( 'jquery', 'bp-ld-reports-datatable' ),
			filemtime( bp_learndash_path( $filePath ) ),
			true
		);

		$per_page = bp_ld_sync( 'settings' )->get( 'reports.per_page', 20 );
		wp_localize_script(
			'bp-ld-reports',
			'BP_LD_REPORTS_DATA',
			array(
				'current_group' => groups_get_current_group()->id,
				'nonce'         => wp_create_nonce( 'bp_ld_report' ),
				'ajax_url'      => admin_url( 'admin-ajax.php' ),
				'table_columns' => $this->getCurrentTableColumns(),
				'config'        => array(
					'perpage' => ( '' === $per_page ) ? 20 : $per_page,
				),
				'text'          => array(
					'processing'     => __( 'Loading&hellip;', 'buddyboss' ),
					'emptyTable'     => __( 'No result found&hellip;', 'buddyboss' ),
					'paginate_first' => __( 'First', 'buddyboss' ),
					'paginate_last'  => __( 'Last', 'buddyboss' ),
					'paginate_next'  => __( 'Next', 'buddyboss' ),
					'export_failed'  => __( 'Export failed, please refresh and try again.', 'buddyboss' ),
					'export_ready'   => __( 'Export is ready.', 'buddyboss' ),
				),
			)
		);

		wp_enqueue_style(
			'bp-ld-reports',
			bp_learndash_url( $filePath = '/assets/styles/bp-learndash.css' ),
			array(),
			filemtime( bp_learndash_path( $filePath ) )
		);
	}

	/**
	 * Output report filters html
	 *
	 * @since BuddyBoss 1.0.0
	 */
	public function showReportFilters() {
		$filters = $this->getReportFilters();
		require bp_locate_template( 'groups/single/reports-filters.php', false, false );
	}

	/**
	 * Output report user stats html
	 *
	 * @since BuddyBoss 1.0.0
	 */
	public function showReportUserStats() {
		if ( empty( $_GET['user'] ) ) {
			return;
		}

		$courseId = bp_ld_sync()->getRequest( 'course' );
		$course   = $courseId ? get_post( $courseId ) : null;
		$group    = groups_get_current_group();
		$user     = get_user_by( 'ID', $_GET['user'] );

		require bp_locate_template( 'groups/single/reports-user-stats.php', false, false );
	}

	/**
	 * Output report course stats html
	 *
	 * @since BuddyBoss 1.0.0
	 */
	public function showReportCourseStats() {
		if ( ! empty( $_GET['user'] ) || empty( $_GET['course'] ) ) {
			return;
		}

		$course                = get_post( $_GET['course'] );
		$group                 = groups_get_current_group();
		$ldGroupId             = bp_ld_sync( 'buddypress' )->helpers->getLearndashGroupId( $group->id );
		$ldGroup               = get_post( $ldGroupId );
		$ldGroupUsers          = learndash_get_groups_users( $ldGroupId );
		$ldGroupUsersCompleted = array_filter(
			$ldGroupUsers,
			function( $user ) use ( $course ) {
				return learndash_course_completed( $user->ID, $course->ID );
			}
		);
		$courseHasPoints       = ! ! $coursePoints = get_post_meta( $course->ID, 'course_points', true );
		$averagePoints         = $courseHasPoints ? count( $ldGroupUsersCompleted ) * $coursePoints : 0;

		require bp_locate_template( 'groups/single/reports-course-stats.php', false, false );
	}

	/**
	 * Output report results tables
	 *
	 * @since BuddyBoss 1.0.0
	 */
	public function showReportTables() {
		$generator               = $this->getCurrentGenerator();
		$completed_table_title   = $generator->completed_table_title ?: __( 'Completed', 'buddyboss' );
		$incompleted_table_title = $generator->incompleted_table_title ?: __( 'Incomplete', 'buddyboss' );
		require bp_locate_template( 'groups/single/reports-tables.php', false, false );
	}

	/**
	 * Filter to sort the report by Course
	 *
	 * @since BuddyBoss 1.0.0
	 */
	public function courseReportResults( $params ) {
		if ( ! empty( $_REQUEST['course'] ) && is_string( $_REQUEST['course'] ) ) {
			$params['course_ids'] = absint( $_REQUEST['course'] );
		}
		return $params;
	}

	/**
	 * Only allow non admin/mod to view his own reports
	 *
	 * @since BuddyBoss 1.0.0
	 */
	public function forceOwnReportResults( $params ) {
		if ( ! $currentGroup = groups_get_current_group() ) {
			return $params;
		}

		$userId  = bp_loggedin_user_id();
		$groupId = $currentGroup->id;

		if ( groups_is_user_admin( $userId, $groupId ) || groups_is_user_mod( $userId, $groupId ) || is_user_admin() ) {
			return $params;
		}

		$params['user_ids'] = array( bp_loggedin_user_id() );
		return $params;
	}

	/**
	 * Output report export button html
	 *
	 * @since BuddyBoss 1.0.0
	 */
	public function showReportExport() {
		require bp_locate_template( 'groups/single/reports-export.php', false, false );
	}

	/**
	 * Remove the filter if only 1 option available
	 *
	 * @since BuddyBoss 1.0.0
	 */
	public function removeCourseFilterIfOnlyOne( $filters ) {
		if ( ! $currentGroup = groups_get_current_group() ) {
			return $filters;
		}

		if ( count( bp_learndash_get_group_courses( $currentGroup->id ) ) < 2 ) {
			unset( $filters['course'] );
		}

		return $filters;
	}

	/**
	 * Remove user filter is nond admin/mod are viewing reports tab
	 *
	 * @since BuddyBoss 1.0.0
	 */
	public function removeUserFilterIfStudent( $filters ) {
		if ( ! $currentGroup = groups_get_current_group() ) {
			return $filters;
		}

		// admin can always view
		if ( learndash_is_admin_user() ) {
			return $filters;
		}

		$userId  = bp_loggedin_user_id();
		$groupId = $currentGroup->id;

		if ( ! groups_is_user_admin( $userId, $groupId ) && ! groups_is_user_mod( $userId, $groupId ) ) {
			unset( $filters['user'] );
		}

		return $filters;
	}

	/**
	 * Sub filter for ld's activity sql query on fields
	 *
	 * @since BuddyBoss 1.0.0
	 */
	public function reportAdditionalActivityFields( $strFields, $queryArgs ) {
		return apply_filters( 'bp_ld_sync/reports/activity_fields', $strFields, $queryArgs );
	}

	/**
	 * Sub filter for ld's activity sql query on joins
	 *
	 * @since BuddyBoss 1.0.0
	 */
	public function reportAdditionalActivityTables( $strJoins, $queryArgs ) {
		// Learndash Bug https://screencast.com/t/iBajWvdt
		if ( ! $this->isRealJoins() ) {
			$this->isRealJoins = true;
			return $strJoins;
		}

		return apply_filters( 'bp_ld_sync/reports/activity_joins', $strJoins, $queryArgs );
	}

	/**
	 * Sub filter for ld's activity sql query on wheres
	 *
	 * @since BuddyBoss 1.0.0
	 */
	public function reportAdditionalActivityWheres( $strWheres, $queryArgs ) {
		return apply_filters( 'bp_ld_sync/reports/activity_wheres', $strWheres, $queryArgs );
	}

	/**
	 * Sub filter for ld's activity sql query on group_by
	 *
	 * @since BuddyBoss 1.0.0
	 */
	public function reportAdditionalActivityGroups( $strWheres, $queryArgs ) {
		return apply_filters( 'bp_ld_sync/reports/activity_groups', $strWheres, $queryArgs );
	}

	/**
	 * Remove the user column if a user is selected in the filter
	 *
	 * @since BuddyBoss 1.0.0
	 */
	public function removeUserColumnIfSelected( $columns, $args ) {
		if ( $args['user'] ) {
			unset( $columns['user'] );
		}

		return $columns;
	}

	/**
	 * Remove the course column if a course is selected in the filter
	 *
	 * @since BuddyBoss 1.0.0
	 */
	public function removeCourseColumnIfSelected( $columns, $args ) {
		if ( $args['course'] ) {
			unset( $columns['course'] );
		}

		return $columns;
	}

	/**
	 * Remove the points column if all courses doesn't have points
	 *
	 * @since BuddyBoss 1.0.0
	 */
	public function removePointsColumnIfNotAssigned( $columns, $args ) {
		$shouldRemove = false;

		if ( $args['course'] ) {
			$shouldRemove = '' === get_post_meta( $args['course'], 'course_points', true );
		} else {
			$groupCourses = bp_ld_sync( 'buddypress' )->courses->getGroupCourses( $args['group'] );
			$shouldRemove = array_sum(
				array_map(
					function( $course ) use ( $args ) {
						return get_post_meta( $args['course'], 'course_points', true ) ?: 0;
					},
					$groupCourses
				)
			) > 0;
		}

		if ( ! in_array( $args['step'], array( 'all', learndash_get_post_type_slug( 'course' ) ) ) ) {
			unset( $columns['points'] );
		}

		if ( $shouldRemove ) {
			unset( $columns['points'] );
		}

		return $columns;
	}

	/**
	 * Add status columns to export
	 *
	 * @since BuddyBoss 1.0.0
	 */
	public function export_report_column( $columns, $report_generator ) {
		if ( ! empty( $report_generator->args['step'] ) && in_array( $report_generator->args['step'], array( 'forum' ) ) ) {
			$columns['status'] = $report_generator->column( 'status' );
		}

		return $columns;
	}

	/**
	 * Get available report generators
	 *
	 * @since BuddyBoss 1.0.0
	 */
	public function getGenerators() {
		return apply_filters(
			'bp_ld_sync/reports_generators',
			array(
				'all'                                    => array(
					'name'  => __( 'All Steps', 'buddyboss' ),
					'class' => '\Buddyboss\LearndashIntegration\Buddypress\Generators\AllReportsGenerator',
				),
				learndash_get_post_type_slug( 'course' ) => array(
					'name'  => __( 'Courses', 'buddyboss' ),
					'class' => 'Buddyboss\LearndashIntegration\Buddypress\Generators\CoursesReportsGenerator',
				),
				learndash_get_post_type_slug( 'lesson' ) => array(
					'name'  => __( 'Lessons', 'buddyboss' ),
					'class' => 'Buddyboss\LearndashIntegration\Buddypress\Generators\LessonsReportsGenerator',
				),
				learndash_get_post_type_slug( 'topic' )  => array(
					'name'  => __( 'Topics', 'buddyboss' ),
					'class' => 'Buddyboss\LearndashIntegration\Buddypress\Generators\TopicsReportsGenerator',
				),
				learndash_get_post_type_slug( 'quiz' )   => array(
					'name'  => __( 'Quizzes', 'buddyboss' ),
					'class' => 'Buddyboss\LearndashIntegration\Buddypress\Generators\QuizzesReportsGenerator',
				),
				learndash_get_post_type_slug( 'essays' ) => array(
					'name'  => __( 'Essays', 'buddyboss' ),
					'class' => 'Buddyboss\LearndashIntegration\Buddypress\Generators\EssaysReportsGenerator',
				),
				learndash_get_post_type_slug( 'assignment' ) => array(
					'name'  => __( 'Assignments', 'buddyboss' ),
					'class' => 'Buddyboss\LearndashIntegration\Buddypress\Generators\AssignmentsReportsGenerator',
				),
			)
		);
	}

	/**
	 * Get available report filters
	 *
	 * @since BuddyBoss 1.0.0
	 */
	protected function getReportFilters() {
		$filters = apply_filters(
			'bp_ld_sync/report_filters',
			array(
				'user'   => array(
					'name'     => __( 'User', 'buddyboss' ),
					'position' => 10,
					'options'  => $this->getGroupUsersList(),
				),
				'course' => array(
					'name'     => __( 'Course', 'buddyboss' ),
					'position' => 20,
					'options'  => $this->getGroupCoursesList(),
				),
				'step'   => array(
					'name'     => __( 'Step', 'buddyboss' ),
					'position' => 30,
					'options'  => $this->getStepTypes(),
				),
			)
		);

		return wp_list_sort( $filters, 'position', 'ASC', true );
	}

	/**
	 * Get group's member list for filter
	 *
	 * @since BuddyBoss 1.0.0
	 */
	protected function getGroupUsersList() {
		$generator = bp_ld_sync( 'buddypress' )->sync->generator( groups_get_current_group()->id );
		$members   = learndash_get_groups_users( $generator->getLdGroupId() );

		array_unshift(
			$members,
			(object) array(
				'ID'           => '',
				'display_name' => __( 'All Students', 'buddyboss' ),
			)
		);

		return wp_list_pluck( $members, 'display_name', 'ID' );
	}

	/**
	 * Get group's course list for filter
	 *
	 * @since BuddyBoss 1.0.0
	 */
	protected function getGroupCoursesList() {
		$ldGroupId = bp_ld_sync( 'buddypress' )->helpers->getLearndashGroupId( groups_get_current_group()->id );
		$courseIds = learndash_group_enrolled_courses( $ldGroupId );

		/**
		 * Filter to update course lists
		 */
		$courses = array_map( 'get_post', apply_filters( 'bp_ld_learndash_group_enrolled_courses', $courseIds, $ldGroupId ) );

		array_unshift(
			$courses,
			(object) array(
				'ID'         => '',
				'post_title' => __( 'All Courses', 'buddyboss' ),
			)
		);

		return wp_list_pluck( $courses, 'post_title', 'ID' );
	}

	/**
	 * Get list of steps available from all generators
	 *
	 * @since BuddyBoss 1.0.0
	 */
	protected function getStepTypes() {
		 return wp_list_pluck( $this->getGenerators(), 'name' );
	}

	/**
	 * Get the table columns on the current generator
	 *
	 * @since BuddyBoss 1.0.0
	 */
	protected function getCurrentTableColumns() {
		return array_map( array( $this, 'getGeneratorColumns' ), $this->getGenerators() );
	}

	/**
	 * Get the class name for the current generator based on request value
	 *
	 * @since BuddyBoss 1.0.0
	 */
	protected function getCurrentGenerator() {
		$step      = bp_ld_sync()->getRequest( 'step', 'all' );
		$generator = $this->getGenerators()[ $step ];
		return new $generator['class']();
	}

	/**
	 * Convert generator columns to datatable js format by current generator
	 *
	 * @since BuddyBoss 1.0.0
	 */
	protected function getGeneratorColumns( $generator ) {
		$columns = ( new $generator['class']() )->getColumns();

		return array_map( array( $this, 'standarlizeGeneratorColumns' ), $columns, array_keys( $columns ) );
	}

	/**
	 * Convert generator columns to datatable js format
	 *
	 * @since BuddyBoss 1.0.0
	 */
	protected function standarlizeGeneratorColumns( $column, $key ) {
		return array(
			'title'     => $column['label'],
			'data'      => $key,
			'name'      => $key,
			'orderable' => $column['sortable'],
		);
	}

	/**
	 * Fix bug on LD where they typed the action name wrong
	 *
	 * @since BuddyBoss 1.0.0
	 */
	protected function isRealJoins() {
		if ( in_array( current_filter(), array( 'learndash_user_activity_query_joins', 'learndash_user_activity_query_join' ) ) ) {
			return true;
		}

		return $this->isRealJoins;
	}
}