<?php
namespace Academy\Classes;

if ( ! defined( 'ABSPATH' ) ) {
	exit;
}


use Throwable;
use Academy\Lesson\LessonApi\Lesson as LessonApi;
class CourseExport extends ExportBase {
	public function get_courses_for_export( $status = '' ) {
		$course_array = [];
		$empty_data = array(
			'post_title'       => '',
			'post_author'      => '',
			'post_date'        => '',
			'post_content'     => '',
			'post_excerpt'     => '',
			'post_status'      => '',
			'comment_status'   => '',
			'post_name'        => '',
			'post_parent'      => '',
			'post_type'        => '',
			'comment_count'    => '',
			'course_thumbnail_url' => '',
		);

		$empty_meta = array(
			'course_expire_enrollment' => '',
			'course_type' => '',
			'course_product_id' => '',
			'course_download_id	' => '',
			'course_max_students' => '',
			'course_language' => '',
			'course_difficulty_level' => '',
			'course_benefits' => '',
			'course_requirements' => '',
			'course_audience' => '',
			'course_materials' => '',
			'is_enabled_course_qa' => '',
			'is_enabled_course_announcements' => '',
			'course_duration' => '',
			'course_intro_video' => '',
			'course_curriculum' => '',
			'course_certificate_id' => '',
			'academy_rcp_membership_levels' => [],
			'academy_course_enable_certificate' => false,
			'academy_is_disabled_course_review' => false,
		);

		$courses = $this->get_all_courses( 'course_completed' );
		$course_array = [];
		if ( empty( $courses ) ) {
			return [ $empty_data, $empty_meta ];
		}
		foreach ( $courses as $course ) {
			$course_type = isset( $meta['academy_course_type'][0] ) ? $meta['academy_course_type'][0] : '';
			$meta = get_post_meta( $course->ID );

			$serialized_keys = [ 'academy_rcp_membership_levels', 'academy_course_duration', 'academy_course_intro_video', 'academy_course_curriculum' ];
			foreach ( $serialized_keys as $key ) {
				$meta[ $key ] = array_map( fn ( $item ) => wp_json_encode( maybe_unserialize( $item ) ?? [] ), $meta[ $key ] ?? array() );
			}

			$product_id = 0;
			$download_id = 0;
			$regular_price = 0;
			$sale_price = 0;
			$edd_price = 0;
			if ( 'paid' === $course_type ) {
				$product_id = $meta['academy_course_product_id'][0] ?? 0;
				$download_id = $meta['academy_course_download_id'][0] ?? 0;
				$regular_price = get_post_meta( $product_id, '_regular_price', true );
				$sale_price = get_post_meta( $product_id, '_sale_price', true );
				$edd_price = get_post_meta( $download_id, 'edd_price', true );
			}
			$curriculums = json_decode( $meta['academy_course_curriculum'][0] ?? '', true ) ?? [];
			$course_array[] = $this->extract_post_data( $course );
			$course_array[] = array_merge(
				$this->extract_meta_data( $meta ),
				[
					'course_curriculum' => $meta['academy_course_curriculum'][0] ?? array(),
					'course_download_id' => $download_id,
					'edd_price' => isset( $edd_price ) ? $edd_price : 0,
					'course_product_id' => $product_id,
					'regular_price' => isset( $regular_price ) ? $regular_price : 0,
					'sale_price' => isset( $sale_price ) ? $sale_price : 0,
				],
			);

			if ( ! empty( $curriculums ) ) {
				foreach ( $curriculums as $curriculum ) {
					$is_topics = ! empty( $curriculum['topics'] ) ? true : false;
					if ( $is_topics ) {
						foreach ( $curriculum['topics'] as $topics ) {
							$topics_type = isset( $topics['type'] ) ? $topics['type'] : '';
							if ( 'sub-curriculum' !== $topics_type ) {
								$data = $this->topics_make_for_csv( $topics );
								if ( 'quiz' === $topics_type && $data ) {
									foreach ( $data as $quiz ) {
										$course_array[] = $quiz;
									}
								} else {
									$course_array[] = $data;
								}
							} elseif ( isset( $topics['topics'] ) && ! empty( $topics['topics'] ) ) {
								foreach ( $topics['topics'] as $topic ) {
									$data = $this->topics_make_for_csv( $topic );
									$topic_type = isset( $topic['type'] ) ? $topic['type'] : '';
									if ( 'quiz' === $topic_type && $data ) {
										foreach ( $data as $quiz ) {
											$course_array[] = $quiz;
										}
									} else {
										$course_array[] = $data;
									}
								}
							}//end if
						}//end foreach
					}//end if
				}//end foreach
			}//end if
		}//end foreach
		return $course_array;
	}

	private function extract_post_data( $course ) {
		return [
			'post_title' => $course->post_title,
			'post_author' => $course->post_author,
			'post_date' => $course->post_date,
			'post_content' => $course->post_content,
			'post_excerpt' => $course->post_excerpt,
			'post_status' => $course->post_status,
			'comment_status' => $course->comment_status,
			'post_parent' => $course->post_parent,
			'comment_count' => $course->comment_count,
			'course_thumbnail_url' => MediaImporter::get_attachment_url( get_post_thumbnail_id( $course->ID ) ),
		];
	}

	private function extract_meta_data( $meta ) {
		return [
			'course_expire_enrollment' => $meta['academy_course_expire_enrollment'][0] ?? '',
			'course_type' => $meta['academy_course_type'][0] ?? 'free',
			'course_product_id' => $meta['academy_course_product_id'][0] ?? 0,
			'course_download_id' => $meta['academy_course_download_id'][0] ?? 0,
			'course_max_students' => $meta['academy_course_max_students'][0] ?? 0,
			'course_language' => $meta['academy_course_language'][0] ?? '',
			'course_difficulty_level' => $meta['academy_course_difficulty_level'][0] ?? '',
			'course_benefits' => $meta['academy_course_benefits'][0] ?? '',
			'course_requirements' => $meta['academy_course_requirements'][0] ?? '',
			'course_audience' => $meta['academy_course_audience'][0] ?? '',
			'course_materials' => $meta['academy_course_materials_included'][0] ?? '',
			'is_enabled_course_qa' => $meta['academy_is_enabled_course_qa'][0] ?? '',
			'is_enabled_course_announcements' => $meta['academy_is_enabled_course_announcements'][0] ?? '',
			'course_duration' => $meta['academy_course_duration'][0] ?? array(),
			'course_intro_video' => $meta['academy_course_intro_video'][0] ?? array(),
			'course_certificate_id' => $meta['academy_course_certificate_id'][0] ?? 0,
			'is_disabled_course_review' => $meta['academy_is_disabled_course_review'][0] ?? false,
			'rcp_membership_levels' => $meta['academy_rcp_membership_levels'][0] ?? array(),
			'course_enable_certificate' => $meta['academy_course_enable_certificate'][0] ?? false,
			'academy_course_attachments' => $meta['academy_course_attachments'][0] ?? array(),
		];
	}

	public function get_all_courses( $status ) {
		global $wpdb;
		// phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching, WordPress.DB.PreparedSQL.NotPrepared
		$results = $wpdb->get_results( $wpdb->prepare(
			"SELECT *
			FROM {$wpdb->posts}
			WHERE post_type = %s
			AND post_status = %s",
			'academy_courses',
			'publish',
		) );
		return $results;
	}
	public function topics_make_for_csv( $topic ) {
		$type = isset( $topic['type'] ) ? $topic['type'] : '';
		switch ( $type ) {
			case 'lesson':
				return $this->get_lesson_by_topic( $topic ); // phpcs::ignore Squiz.PHP.NonExecutableCode.Unreachable
			case 'quiz':
				return apply_filters( 'academy_pro/export-import/get_quiz_data', $topic ); // phpcs::ignore Squiz.PHP.NonExecutableCode.Unreachable
			case 'assignment':
				return apply_filters( 'academy_pro/export-import/get_assignment_data', $topic ); // phpcs::ignore Squiz.PHP.NonExecutableCode.Unreachable
			case 'quizpress_quiz':
				return apply_filters( 'academy/export-import/get_quizpress_quiz_data', $topic ); // phpcs::ignore Squiz.PHP.NonExecutableCode.Unreachable
		}
	}

	public function get_lesson_by_topic( $topic ) {
		try {
			$lesson = LessonApi::get_by_id( $topic['id'] );
			$lesson = $lesson->get_data();
			$author = get_userdata( $lesson->lesson_author ?? null );
			$csv_data = [
				'lesson_title'              => $lesson['lesson_title'],
				'lesson_content'            => $lesson['lesson_content'],
				'lesson_status'             => $lesson['lesson_status'],
				'lesson_author'             => $author->user_login ?? 0,
				'is_previewable'            => $lesson['meta']['is_previewable'] ?? false,
				'video_duration'            => wp_json_encode( $lesson['meta']['video_duration'] ),
				'video_source_type'         => $lesson['meta']['video_source']['type'],
				'video_source_url'          => $lesson['meta']['video_source']['url'],
				'lesson_featured_media_url' => MediaImporter::get_attachment_url( $lesson['meta']['featured_media'] ?? 0 ),
			];
			return $csv_data;
		} catch ( Throwable $e ) {
			return null;
		}
		return null;
	}

	/**
	 * Method Overwrite
	 *
	 * Overwrite export base class method
	 *
	 * @param array          $array
	 * @param resource|false $fp
	 * @return void
	 */
	public function write_nested_csv( $array, $fp ) {
		$previousItem = array();
		foreach ( $array as $row ) {
			$flattenRow = $this->flatten_array( $row );
			if ( isset( $flattenRow['post_title'] )
			|| isset( $flattenRow['course_expire_enrollment'] )
			|| isset( $flattenRow['lesson_title'] )
			|| isset( $flattenRow['quiz_title'] )
			|| isset( $flattenRow['question_title'] )
			|| isset( $flattenRow['assignment_title'] )
			|| ( isset( $flattenRow['answer_title'] ) && ! isset( $previousItem['answer_title'] ) ) ) {
				$row_header = array_keys( $flattenRow );
				fputcsv( $fp, $row_header, ',', '"', '\\' ); // phpcs:ignore WordPressVIPMinimum.Functions.RestrictedFunctions.file_ops_fputcsv -- writes to php://output (download stream), not the filesystem
			}
			fputcsv( $fp, array_map( array( ExportBase::class, 'csv_safe_cell' ), $flattenRow ), ',', '"', '\\' ); // phpcs:ignore WordPressVIPMinimum.Functions.RestrictedFunctions.file_ops_fputcsv -- writes to php://output (download stream), not the filesystem
			$previousItem = $row;
		}
	}
}