<?php

/**
 * The database operations for the 404 error monitor.
 *
 * @since      1.0.0
 * @package    Metasync
 * @subpackage Metasync/404-monitor
 * @author     Engineering Team <support@searchatlas.com>
 */
class Metasync_Common
{
	/**
	 * Sanitize a array with urls and text field.
	 * @param $data Pass a Array.
	 */
	public function sanitize_array($data)
	{
		// Ensure $data is always an array from the start
		if (!is_array($data)) {
			$data = (array) $data;
		}
		
		foreach ($data as $key => $value) {
			if (is_array($value) && !empty($value)) {
				$data[$key] =  $this->sanitize_array($value);
			} else {
				if ($value) {
					// Ensure $value is a string before processing
					if (!is_string($value) && !is_numeric($value)) {
						$value = (string) $value;
					}
					
					if (filter_var($value, FILTER_VALIDATE_URL)) {
						$data[$key] = sanitize_url($value);
					} else {
						$data[$key] = sanitize_text_field($value);
					}
				}
			}
		}
		return $data;
	}

	/**
	 * Get post by post name.
	 * @param $attachment_name Attachment name will be string.
	 */
	public function get_attachment_by_name($attachment_name)
	{
		global $wpdb;
		$post = $wpdb->get_row(
			$wpdb->prepare(
				"SELECT * FROM $wpdb->posts WHERE `post_name` = %s and `post_type` = 'attachment' LIMIT 1",
				$attachment_name
			)
		);
		return get_post($post);
	}

	public function get_permalink_from_url($url)
	{
		$parse_url = wp_parse_url($url);
		$path = isset($parse_url['path']) ? $parse_url['path'] : '';
		return end(array_diff(explode('/', $path), array('')));
	}

	/**
	 * Get file name from a URL.
	 * @param $url Valid URL as string.
	 */
	public function get_file_name_by_url($url)
	{
		if (stripos($url, "https://cdn.midjourney.com/") !== false) {
			return pathinfo(str_replace("/", "_", parse_url($url, PHP_URL_PATH) ?? ''), PATHINFO_FILENAME);
		} elseif (stripos($url, "https://drive.google.com/") !== false) {
			$parse_url = wp_parse_url($url);
			$args = [];
			wp_parse_str($parse_url['query'], $args);
			return $args['id'];
		} else {
			return pathinfo(parse_url($url, PHP_URL_PATH), PATHINFO_FILENAME);
		}
	}

	public function allowedDownloadSources($url)
	{
		return false;
		$allowed_sources = array(
			"https://storage.googleapis.com",
			"https://drive.google.com"
		);
		foreach ($allowed_sources as $source) {
			if (stripos($url, $source) !== false)
				return true;
		}
		return false;
	}

	public function get_media_id_from_url($url) {
		global $wpdb;

	   // Search for any attachment matching the URL
	   $query = $wpdb->prepare("
		   SELECT ID 
		   FROM $wpdb->posts 
		   WHERE post_type = 'attachment' 
		   AND guid = %s 
		   LIMIT 1
	   ", $url);
   
	   $attachment_id = $wpdb->get_var($query);
   
	   // Return the attachment ID if found, otherwise return false
	   return $attachment_id ? intval($attachment_id) : false;
   }
	/**
	 * Upload image to media library if URL is valid.
	 * @param $url Valid URL.
	 * add title to the image default value value is empty string
	 */
	public function upload_image_by_url($url,$alt='',$title_text='')
	{
		require_once(ABSPATH . "/wp-load.php");
		require_once(ABSPATH . "/wp-admin/includes/image.php");
		require_once(ABSPATH . "/wp-admin/includes/file.php");
		require_once(ABSPATH . "/wp-admin/includes/media.php");

		$tmp = download_url($url);
		if (is_wp_error($tmp)){
			$attachment_id = $this->get_media_id_from_url($url);
			error_log($attachment_id);
			return $attachment_id;
		}

		$filename  = $this->get_file_name_by_url($url);
		// $filename = pathinfo($url, PATHINFO_FILENAME);
		// eliminating query params from file name
		$filename = explode("?", $filename)[0];
		$extension = pathinfo($url, PATHINFO_EXTENSION);

		if (!$extension || strlen($extension) > 4) {
			// fileinfo extension is not always enabled on shared hosts — guard the call
			// and fall back to WordPress's extension-based detection.
			if (function_exists('mime_content_type')) {
				$mime = mime_content_type($tmp);
			} else {
				$filetype = wp_check_filetype(basename($url));
				$mime = $filetype['type'] ?? false;
			}
			$mime = is_string($mime) ? sanitize_mime_type($mime) : false;

			$mime_extensions = array(
				'image/jpe' 	=> 'jpe',
				'image/jpg'		=> 'jpg',
				'image/jpeg'	=> 'jpeg',
				'image/gif'		=> 'gif',
				'image/png'		=> 'png',
				'image/webp'	=> 'webp'
			);

			if (isset($mime_extensions[$mime])) {
				$extension = $mime_extensions[$mime];
			} else {
				// Safely delete temporary file if it exists
				if (file_exists($tmp)) {
					unlink($tmp);
				}
				return false;
			}
		}

		$args = array(
			'name' => "$filename.$extension",
			/*
				Generate a sanitized post_name by replacing double dashes with a single dash
    			and appending the file extension with a hyphen
			*/
			'post_name' => str_replace('--', '-', $filename ?? '') ."-".$extension,
			'tmp_name' => $tmp,
		);

		$get_attachment = $this->get_attachment_by_name($args['post_name']);

		# remove if null logic check on 11 march 2025 for issue 264 and merge request 320
		if (empty($get_attachment)) {
			$attachment_id 	= media_handle_sideload($args, 0, $args['name']);
			update_post_meta($attachment_id, '_wp_attachment_image_alt', $alt);
			// check if the title is empty or not if it's has title update the title
			if($title_text !== ''){
				wp_update_post(
					array (
						'ID'         => $attachment_id,
						'post_title' => $title_text
					)
				);
			}
			$attach_data 	= wp_generate_attachment_metadata(
				$attachment_id,
				wp_get_original_image_path($attachment_id)
			);
			wp_update_attachment_metadata($attachment_id, $attach_data);
			
			// Safely delete temporary file if it exists
			if (file_exists($tmp)) {
				unlink($tmp);
			}

			if (is_wp_error($attachment_id)) return false;
			return $attachment_id;
		} else {
			// An attachment record can outlive its file (e.g. the file was
			// deleted from disk outside WordPress). Since we already have a
			// fresh download, restore it into the existing attachment so its
			// URL stops 404ing — reusing the record keeps post references
			// intact and avoids piling up duplicate attachments.
			$existing_file = get_attached_file($get_attachment->ID);
			if (empty($existing_file) || !file_exists($existing_file)) {
				// wp_handle_sideload() takes $file by reference, so the
				// argument must be a variable — a literal array here is a
				// runtime fatal that kills the whole sync request.
				$file_array = array(
					'name'     => $args['name'],
					'tmp_name' => $tmp,
				);
				$upload = wp_handle_sideload($file_array, array('test_form' => false));
				if (empty($upload['error']) && !empty($upload['file'])) {
					update_attached_file($get_attachment->ID, $upload['file']);
					$attach_data = wp_generate_attachment_metadata($get_attachment->ID, $upload['file']);
					wp_update_attachment_metadata($get_attachment->ID, $attach_data);
				}
			}

			// Delete the temporary file unless the sideload above moved it
			if (file_exists($tmp)) {
				unlink($tmp);
			}

			// check if the title attribute is set on the image tag and then update the title
			if($title_text !== ''){
				wp_update_post(
					array (
						'ID'         => $get_attachment->ID,
						'post_title' => $title_text
					)
				);
			}
			// update the alt attribute in the image
			update_post_meta($get_attachment->ID, '_wp_attachment_image_alt', $alt);
			return $get_attachment->ID;
		}
	}
	/**
     * Check if Gutenberg is enabled as the default page editor
     */
    protected function is_gutenberg_enabled() {
        $current_screen = get_current_screen();
        return method_exists($current_screen, 'is_block_editor') && $current_screen->is_block_editor();
    }
   	/**
     * Check if Elementor is active
     */
    protected function is_elementor_active() {
        return class_exists('Elementor\Plugin') && \Elementor\Plugin::$instance->preview->is_preview_mode();
    }
	/**
     * Check if Gutenberg is enabled or Elementor is active
    */
    public static function check_default_page_editor() {
        $instance = new self();
        if ($instance->is_gutenberg_enabled()) {
            return 'gutenberg';
        } elseif ($instance->is_elementor_active()) {
            return 'elementor';
        } else {
            return 'neither';
        }
    }
}