<?php

namespace AnyComment\Migrations;

use AnyComment\Models\AnyCommentUploadedFiles;

/**
 * Class AnyCommentMigration_0_0_57 is used to re upload big avatars and make them smaller in favor of speed.
 */
class AnyCommentMigration_0_0_57 extends AnyCommentMigration {
	public $table = 'uploaded_files';
	public $version = '0.0.57';

	/**
	 * {@inheritdoc}
	 */
	public function is_applied() {
		global $wpdb;
		$table = 'anycomment_uploaded_files';

		$queryRes  = $wpdb->get_results( "SHOW COLUMNS FROM $table LIKE 'url_thumbnail';", 'ARRAY_A' );
		$queryRes2 = $wpdb->get_results( "SHOW COLUMNS FROM $table LIKE 'type';", 'ARRAY_A' );

		return ! empty( $queryRes ) && count( $queryRes ) > 0 &&
		       ! empty( $queryRes2 ) && count( $queryRes2 ) > 0;
	}

	/**
	 * {@inheritdoc}
	 */
	public function up() {
		global $wpdb;

		$table = 'anycomment_uploaded_files';

		$sql  = "ALTER TABLE $table ADD COLUMN `url_thumbnail` VARCHAR(255) NULL";
		$sql2 = "ALTER TABLE $table ADD COLUMN `type` VARCHAR(255) NOT NULL";


		$success = $wpdb->query( $sql ) !== false && $wpdb->query( $sql2 ) !== false;

		$sql3 = "SELECT * FROM $table WHERE `type`='' OR `type` IS NULL";

		$rows = $wpdb->get_results( $sql3 );

		if ( ! empty( $rows ) ) {
			/**
			 * @var AnyCommentUploadedFiles $row
			 */
			foreach ( $rows as $key => $row ) {
				$extension = pathinfo( $row->url, PATHINFO_EXTENSION );

				if ( empty( $extension ) ) {
					continue;
				}

				$mime_to_use = null;
				$mime_types  = wp_get_mime_types();

				foreach ( $mime_types as $extensions => $mime_type ) {
					if ( strpos( $extensions, $extension ) !== false ) {
						$mime_to_use = $mime_types[ $extensions ];
					}
				}

				if ( null !== $mime_to_use ) {
					$wpdb->update( $table, [ 'type' => $mime_to_use ], [ 'id' => $row->ID ] );
				}
			}
		}

		return $success;
	}

	/**
	 * {@inheritdoc}
	 */
	public function down() {
		global $wpdb;

		$table = 'anycomment_uploaded_files';


		$sql  = "ALTER TABLE $table DROP COLUMN `url_thumbnail`";
		$sql2 = "ALTER TABLE $table DROP COLUMN `type`";

		return $wpdb->query( $sql ) !== false && $wpdb->query( $sql2 ) !== false;
	}
}

// eof;