<?php

namespace Duplicator\Models\ActivityLog;

use Duplicator\Core\CapMng;
use Duplicator\Core\Views\TplMng;
use Duplicator\Package\AbstractPackage;
use Duplicator\Package\PackageUtils;
use Duplicator\Package\Archive\PackageArchive;
use Duplicator\Package\Create\BuildComponents;
use Duplicator\Package\DupPackage;
use Duplicator\Utils\Logging\DupLog;
use Duplicator\Libs\Snap\SnapString;
use Exception;

/**
 * Log event for backup creation
 */
class LogEventBackupCreate extends AbstractLogEvent
{
    const SUB_TYPE_ERROR     = 'error';
    const SUB_TYPE_CANCELLED = 'cancelled';
    const SUB_TYPE_START     = 'start';
    const SUB_TYPE_DB_DUMP   = 'db_dump';
    const SUB_TYPE_FILE_DUMP = 'file_dump';
    const SUB_TYPE_TRANSFER  = 'transfer';
    const SUB_TYPE_END       = 'end';

    /** @var array<int,DupPackage|null> Static cache for package lookups */
    private static array $packageCache = [];

    /**
     * Class constructor
     *
     * @param AbstractPackage $package  Package
     * @param int             $parentId Parent ID, if 0 the event have no event parent
     */
    public function __construct(AbstractPackage $package, int $parentId = 0)
    {
        $this->initializeBasicData($package, $parentId);
        $this->collectPackageMetadata($package);
        $this->collectContextData($package);
        $this->collectSizeAndDbData($package);
        $this->collectTimingData($package);
        $this->setStatusBasedProperties($package);
    }

    /**
     * Initialize basic data fields
     *
     * @param AbstractPackage $package  Package
     * @param int             $parentId Parent ID
     *
     * @return void
     */
    private function initializeBasicData(AbstractPackage $package, int $parentId): void
    {
        $this->subType               = self::SUB_TYPE_START;
        $this->severity              = self::SEVERITY_INFO;
        $this->parentId              = $parentId;
        $this->data['packageId']     = $package->getId();
        $this->data['packageName']   = $package->getName();
        $this->data['packageStatus'] = $package->getStatus();
        $this->data['components']    = $package->components;
    }

    /**
     * Collect package metadata (filters, counts, engines)
     *
     * @param AbstractPackage $package Package
     *
     * @return void
     */
    private function collectPackageMetadata(AbstractPackage $package): void
    {
        // Archive filters and counts
        $this->data['filterOn']    = $package->Archive->FilterOn;
        $this->data['filterDirs']  = strlen($package->Archive->FilterDirs) > 0 ? explode(';', $package->Archive->FilterDirs) : [];
        $this->data['filterExts']  = strlen($package->Archive->FilterExts) > 0 ? explode(';', $package->Archive->FilterExts) : [];
        $this->data['filterFiles'] = strlen($package->Archive->FilterFiles) > 0 ? explode(';', $package->Archive->FilterFiles) : [];
        $this->data['fileCount']   = $package->Archive->FileCount;
        $this->data['dirCount']    = $package->Archive->DirCount;
        $this->data['size']        = $package->Archive->Size;

        // DB filters - only collect if database component is included
        if (!BuildComponents::isDBExcluded($package->components)) {
            $this->data['dbFilterOn']     = $package->Database->FilterOn;
            $this->data['dbFilterTables'] = strlen($package->Database->FilterTables) > 0 ? explode(';', $package->Database->FilterTables) : [];
            $this->data['dbPrefixFilter'] = $package->Database->prefixFilter;
        } else {
            $this->data['dbFilterOn']     = false;
            $this->data['dbFilterTables'] = [];
            $this->data['dbPrefixFilter'] = false;
        }

        // Engines
        $this->data['archiveEngine'] = $this->getArchiveEngineLabel($package->build_progress->current_build_mode);
        if (!BuildComponents::isDBExcluded($package->components)) {
            $this->data['databaseEngine'] = $package->Database->DBMode;
        } else {
            $this->data['databaseEngine'] = '';
        }
    }

    /**
     * Collect execution and storage context
     *
     * @param AbstractPackage $package Package
     *
     * @return void
     */
    private function collectContextData(AbstractPackage $package): void
    {
        // Execution context
        $this->data['execType']     = PackageUtils::getExecTypeString($package->getExecutionType(), $package->template_id);
        $this->data['scheduleName'] = $this->getScheduleName($package);
        $this->data['storageNames'] = $this->getStorageNames($package);
    }

    /**
     * Collect size and database statistics
     *
     * @param AbstractPackage $package Package
     *
     * @return void
     */
    private function collectSizeAndDbData(AbstractPackage $package): void
    {
        // Archive size
        $this->data['archiveSizeDisplay'] = $this->getArchiveDisplaySize($package);

        // DB stats - only collect if database component is included
        $this->data['dbExcluded'] = BuildComponents::isDBExcluded($package->components);
        if (!$this->data['dbExcluded'] && $package->Database->info) {
            $this->data['dbTableCount']  = (int) ($package->Database->info->tablesFinalCount);
            $this->data['dbSizeDisplay'] = SnapString::byteSize((int) ($package->Database->info->tablesSizeOnDisk));
        }
    }

    /**
     * Collect timing data from package execution (simple, reliable approach)
     *
     * @param AbstractPackage $package The package object
     *
     * @return void
     */
    private function collectTimingData(AbstractPackage $package): void
    {
        // Store package start time (reliable)
        $this->data['execution_start_time'] = $package->timer_start > 0 ? $package->timer_start : strtotime($package->getCreated());

        // Store total runtime for completed packages (this is accurate)
        if ($package->getStatus() >= AbstractPackage::STATUS_COMPLETE && !empty($package->Runtime)) {
            $this->data['total_runtime'] = $package->Runtime;
        }
    }

    /**
     * Set properties based on package status
     *
     * @param AbstractPackage $package Package
     *
     * @return void
     */
    private function setStatusBasedProperties(AbstractPackage $package): void
    {
        $status = $package->getStatus();

        if ($status == AbstractPackage::STATUS_BUILD_CANCELLED) {
            $this->subType  = self::SUB_TYPE_CANCELLED;
            $this->title    = sprintf(__('Backup cancelled: %s', 'duplicator-pro'), $package->getName());
            $this->severity = self::SEVERITY_WARNING;
        } elseif ($status < AbstractPackage::STATUS_PRE_PROCESS) {
            $this->subType                  = self::SUB_TYPE_ERROR;
            $this->title                    = sprintf(__('Backup create: %s - Error', 'duplicator-pro'), $package->getName());
            $this->severity                 = self::SEVERITY_ERROR;
            $this->data['backupLogContext'] = $this->captureBackupLogContext($package);
        } elseif ($status < AbstractPackage::STATUS_DBSTART) {
            $this->subType = self::SUB_TYPE_START;
            $this->title   = sprintf(__('Backup create: %s', 'duplicator-pro'), $package->getName());
        } elseif ($status < AbstractPackage::STATUS_ARCSTART) {
            $this->subType = self::SUB_TYPE_DB_DUMP;
            $this->title   = sprintf(__('Backup create: %s - DB Dump', 'duplicator-pro'), $package->getName());
        } elseif ($status < AbstractPackage::STATUS_COPIEDPACKAGE) {
            $this->subType = self::SUB_TYPE_FILE_DUMP;
            $this->title   = sprintf(__('Backup create: %s - File Dump', 'duplicator-pro'), $package->getName());
        } elseif ($status < AbstractPackage::STATUS_COMPLETE) {
            $this->subType                 = self::SUB_TYPE_TRANSFER;
            $this->title                   = sprintf(__('Backup create: %s - Transfer', 'duplicator-pro'), $package->getName());
            $this->data['uploadSummaries'] = $this->collectUploadSummaries($package);
        } else {
            $this->subType = self::SUB_TYPE_END;
            $this->title   = sprintf(__('Backup create: %s - Completed', 'duplicator-pro'), $package->getName());
            // Refresh final archive size at completion
            $this->data['archiveSizeDisplay'] = $this->getArchiveDisplaySize($package);
            $this->data['uploadSummaries']    = $this->collectUploadSummaries($package);
        }
    }

    /**
     * Get cached package instance for performance
     *
     * @param int $packageId Package ID
     *
     * @return DupPackage
     */
    private function getCachedPackage(int $packageId): DupPackage
    {
        if (!isset(self::$packageCache[$packageId])) {
            self::$packageCache[$packageId] = DupPackage::getById($packageId);
        }
        if (!self::$packageCache[$packageId]) {
            self::$packageCache[$packageId] = new DupPackage();
        }
        return self::$packageCache[$packageId];
    }

    /**
     * Get archive engine label
     *
     * @param int $buildMode Build mode constant
     *
     * @return string
     */
    private function getArchiveEngineLabel(int $buildMode): string
    {
        switch ($buildMode) {
            case PackageArchive::BUILD_MODE_SHELL_EXEC:
                return __('Shell Exec', 'duplicator-pro');
            case PackageArchive::BUILD_MODE_ZIP_ARCHIVE:
                return __('Zip Archive', 'duplicator-pro');
            case PackageArchive::BUILD_MODE_DUP_ARCHIVE:
                return __('Dup Archive', 'duplicator-pro');
            default:
                return __('Unknown', 'duplicator-pro');
        }
    }

    /**
     * Get schedule name if available
     *
     * @param AbstractPackage $package Package
     *
     * @return string
     */
    private function getScheduleName(AbstractPackage $package): string
    {
        $schedule = $package->getSchedule();
        return $schedule ? (string) $schedule->name : '';
    }

    /**
     * Get storage names
     *
     * @param AbstractPackage $package Package
     *
     * @return string[]
     */
    private function getStorageNames(AbstractPackage $package): array
    {
        $storages = $package->getStorages();
        return array_map(function ($storage) {
            return $storage->getName();
        }, $storages);
    }

    /**
     * Get archive display size
     *
     * @param AbstractPackage $package Package
     *
     * @return string
     */
    private function getArchiveDisplaySize(AbstractPackage $package): string
    {
        if ($package instanceof DupPackage) {
            return (string) $package->getDisplaySize();
        }

        return '';
    }

    /**
     * Collect upload summaries
     *
     * @param AbstractPackage $package Package
     *
     * @return array<string,mixed>[]
     */
    private function collectUploadSummaries(AbstractPackage $package): array
    {
        $summaries = [];
        if (is_array($package->upload_infos)) {
            foreach ($package->upload_infos as $uInfo) {
                $storage     = $uInfo->getStorage();
                $summaries[] = [
                    'storageId' => $uInfo->getStorageId(),
                    'name'      => $storage->getName(),
                    'status'    => $uInfo->getStatusText(),
                    'progress'  => $uInfo->progress,
                    'startedAt' => $uInfo->getStartedTimestamp(),
                    'stoppedAt' => $uInfo->getStoppedTimestamp(),
                ];
            }
        }
        return $summaries;
    }

    /**
     * Return entity type identifier
     *
     * @return string
     */
    public static function getType(): string
    {
        return 'backup_create';
    }

    /**
     * Return entity type label
     *
     * @return string
     */
    public static function getTypeLabel(): string
    {
        return __('Backup Create', 'duplicator-pro');
    }

    /**
     * Return required capability for this log event
     *
     * @return string
     */
    public static function getCapability(): string
    {
        return CapMng::CAP_CREATE;
    }

    /**
     * Return short description
     *
     * @return string
     */
    public function getShortDescription(): string
    {
        switch ($this->subType) {
            case self::SUB_TYPE_ERROR:
                return __('Backup Error', 'duplicator-pro');
            case self::SUB_TYPE_CANCELLED:
                return __('Backup Cancelled', 'duplicator-pro');
            case self::SUB_TYPE_START:
                $subEvents = array_merge(
                    self::getList(
                        [
                            'parent_id' => $this->getId(),
                            'order'     => 'DESC',
                            'orderby'   => 'created_at',
                            'per_page'  => 1,
                        ]
                    )
                );
                if (count($subEvents) > 0) {
                    return $subEvents[0]->getShortDescription();
                } else {
                    return __('Backup Create', 'duplicator-pro');
                }
            case self::SUB_TYPE_DB_DUMP:
                // Only show DB dump info if database component is included
                if (!empty($this->data['dbExcluded'])) {
                    return __('Database Dump', 'duplicator-pro'); // No stats for excluded DB
                }
                if (!empty($this->data['dbTableCount']) && !empty($this->data['dbSizeDisplay'])) {
                    return sprintf(
                        __('Database Dump (%1$d tables, %2$s)', 'duplicator-pro'),
                        (int) $this->data['dbTableCount'],
                        (string) $this->data['dbSizeDisplay']
                    );
                }
                return __('Database Dump', 'duplicator-pro');
            case self::SUB_TYPE_FILE_DUMP:
                // Prefer live size, fall back to stored value
                $pkg      = $this->getCachedPackage($this->data['packageId'] ?? 0);
                $liveSize = (string) $pkg->getDisplaySize();
                if (strlen($liveSize) > 0) {
                    return sprintf(__('File Dump (%s)', 'duplicator-pro'), $liveSize);
                }
                if (!empty($this->data['archiveSizeDisplay'])) {
                    return sprintf(__('File Dump (%s)', 'duplicator-pro'), (string) $this->data['archiveSizeDisplay']);
                }
                return __('File Dump', 'duplicator-pro');
            case self::SUB_TYPE_TRANSFER:
                // Prefer live per-storage completion over stored snapshot
                $pkg = $this->getCachedPackage($this->data['packageId'] ?? 0);
                if (is_array($pkg->upload_infos)) {
                    $completed = 0;
                    $total     = 0;
                    foreach ($pkg->upload_infos as $uInfo) {
                        // Count only upload (skip downloads)
                        if ($uInfo->isDownloadFromRemote()) {
                            continue;
                        }
                        $total++;
                        if ($uInfo->hasCompleted(true)) {
                            $completed++;
                        }
                    }
                    if ($total > 0) {
                        return sprintf(__('Backup Transfer (%1$d/%2$d completed)', 'duplicator-pro'), $completed, $total);
                    }
                }
                if (!empty($this->data['uploadSummaries'])) {
                    $completed = 0;
                    $total     = count($this->data['uploadSummaries']);
                    foreach ($this->data['uploadSummaries'] as $s) {
                        if (($s['status'] ?? '') === __('Succeeded', 'duplicator-pro')) {
                            $completed++;
                        }
                    }
                    return sprintf(__('Backup Transfer (%1$d/%2$d completed)', 'duplicator-pro'), $completed, $total);
                }
                return __('Backup Transfer', 'duplicator-pro');
            case self::SUB_TYPE_END:
                if (!empty($this->data['archiveSizeDisplay']) || !empty($this->data['storageNames'])) {
                    $sizeText = !empty($this->data['archiveSizeDisplay']) ? (string) $this->data['archiveSizeDisplay'] : '';
                    $storages = count($this->data['storageNames'] ?? []);
                    if ($sizeText && $storages > 0) {
                        return sprintf(__('Backup Completed (%1$s, %2$d storage(s))', 'duplicator-pro'), $sizeText, $storages);
                    } elseif ($sizeText) {
                        return sprintf(__('Backup Completed (%s)', 'duplicator-pro'), $sizeText);
                    }
                }
                return __('Backup Completed', 'duplicator-pro');
            default:
                return __('Backup Create', 'duplicator-pro');
        }
    }

    /**
     * Display detailed information in html format
     *
     * @return void
     */
    public function detailHtml(): void
    {
        ?>
        <div class="dup-log-detail-meta">
            <div class="dup-log-type-wrapper">
                <strong><?php esc_html_e('Archive Engine:', 'duplicator-pro'); ?></strong>
                <span class="dup-log-type">
                    <?php echo esc_html($this->data['archiveEngine']); ?>
                </span>
            </div>
            <?php if (empty($this->data['dbExcluded'])) : ?>
                <div class="dup-log-type-wrapper">
                    <strong><?php esc_html_e('Database Engine:', 'duplicator-pro'); ?></strong>
                    <span class="dup-log-type">
                        <?php echo esc_html($this->data['databaseEngine']); ?>
                    </span>
                </div>
            <?php endif; ?>
            <div class="dup-log-type-wrapper">
                <strong><?php esc_html_e('Components:', 'duplicator-pro'); ?></strong>
                <span class="dup-log-type">
                    <?php echo esc_html(BuildComponents::displayComponentsList($this->data['components'], ", ")); ?>
                </span>
            </div>
            <div class="dup-log-type-wrapper">
                <strong><?php esc_html_e('Run Type:', 'duplicator-pro'); ?></strong>
                <span class="dup-log-type">
                    <?php echo esc_html($this->data['execType'] ?? ''); ?>
                </span>
            </div>
            <div class="dup-log-type-wrapper">
                <strong><?php esc_html_e('Execution Time:', 'duplicator-pro'); ?></strong>
                <span class="dup-log-type">
                    <?php
                    // Use real package Runtime for completed packages
                    if (!empty($this->data['total_runtime'])) {
                        echo esc_html($this->data['total_runtime']);
                    } else {
                        // For incomplete packages, calculate from start to last sub-event
                        $startTime = $this->data['execution_start_time'] ?? strtotime($this->getCreatedAt());
                        $endTime   = $startTime;

                        if ($this->getParentId() <= 0) {
                            // Get latest sub-event for more accurate timing
                            $subEvents = self::getList([
                                'parent_id' => $this->getId(),
                                'order'     => 'DESC',
                                'orderby'   => 'created_at',
                                'per_page'  => 1,
                            ]);

                            if (!empty($subEvents)) {
                                $endTime = (float) strtotime($subEvents[0]->getCreatedAt());
                            }
                        }

                        echo esc_html(\Duplicator\Libs\Snap\SnapString::formatHumanReadableDuration($endTime, $startTime));
                    }
                    ?>
                </span>
            </div>
            <?php if (!empty($this->data['scheduleName'])) : ?>
            <div class="dup-log-type-wrapper">
                <strong><?php esc_html_e('Schedule Name:', 'duplicator-pro'); ?></strong>
                <span class="dup-log-type">
                    <?php echo esc_html($this->data['scheduleName']); ?>
                </span>
            </div>
            <?php endif; ?>
            <?php if (!empty($this->data['storageNames'])) : ?>
            <div class="dup-log-type-wrapper">
                <strong><?php esc_html_e('Storages:', 'duplicator-pro'); ?></strong>
                <span class="dup-log-type">
                    <?php echo esc_html(implode(', ', $this->data['storageNames'] ?? [])); ?>
                </span>
            </div>
            <?php endif; ?>
            <?php if (!empty($this->data['archiveSizeDisplay'])) : ?>
            <div class="dup-log-type-wrapper">
                <strong><?php esc_html_e('Backup Size:', 'duplicator-pro'); ?></strong>
                <span class="dup-log-type">
                    <?php
                        // Prefer live package value to avoid stale 0B after completion
                        $archiveSizeDisplay = $this->data['archiveSizeDisplay'] ?? '';
                        $pkg                = $this->getCachedPackage($this->data['packageId'] ?? 0);
                        $archiveSizeDisplay = (string) $pkg->getDisplaySize();
                        echo esc_html($archiveSizeDisplay);
                    ?>
                </span>
            </div>
            <?php endif; ?>
            <?php if (empty($this->data['dbExcluded'])) : ?>
                <?php if (!empty($this->data['dbTableCount']) || !empty($this->data['dbSizeDisplay'])) : ?>
                <div class="dup-log-type-wrapper">
                    <strong><?php esc_html_e('Database Stats:', 'duplicator-pro'); ?></strong>
                    <span class="dup-log-type">
                        <?php
                            $parts = [];
                        if (!empty($this->data['dbTableCount'])) {
                            $parts[] = sprintf(esc_html__('%d tables', 'duplicator-pro'), (int) $this->data['dbTableCount']);
                        }
                        if (!empty($this->data['dbSizeDisplay'])) {
                            $parts[] = sprintf(esc_html__('%s SQL', 'duplicator-pro'), (string) $this->data['dbSizeDisplay']);
                        }
                            echo esc_html(implode(' · ', $parts));
                        ?>
                    </span>
                </div>
                <?php endif; ?>
            <?php endif; ?>

            <?php // File and directory counts ?>
            <?php if (!empty($this->data['fileCount']) || !empty($this->data['dirCount'])) : ?>
            <div class="dup-log-type-wrapper">
                <strong><?php esc_html_e('Files/Folders:', 'duplicator-pro'); ?></strong>
                <span class="dup-log-type">
                    <?php
                        $counts = [];
                    if (!empty($this->data['fileCount'])) {
                        $counts[] = sprintf(esc_html__('%s files', 'duplicator-pro'), number_format((int) $this->data['fileCount']));
                    }
                    if (!empty($this->data['dirCount'])) {
                        $counts[] = sprintf(esc_html__('%s folders', 'duplicator-pro'), number_format((int) $this->data['dirCount']));
                    }
                        echo esc_html(implode(' · ', $counts));
                    ?>
                </span>
            </div>
            <?php endif; ?>

            <hr>

            <?php
            // Check if any filters are active
            $hasArchiveFilters = $this->data['filterOn']
                && ($this->data['filterOn'] == true)
                && (!empty($this->data['filterDirs']) || !empty($this->data['filterExts']) || !empty($this->data['filterFiles']));
            $hasDbFilters      = empty($this->data['dbExcluded'])
                && $this->data['dbFilterOn']
                && ($this->data['dbFilterOn'] == true)
                && (!empty($this->data['dbFilterTables']) || !empty($this->data['dbPrefixFilter']));

            if ($hasArchiveFilters || $hasDbFilters) : ?>
                <div class="dup-log-type-wrapper mb-10">
                    <strong><?php esc_html_e('Applied Filters:', 'duplicator-pro'); ?></strong>
                </div>

                <table class="widefat dup-table-list striped dup-activity-log-table small dup-applied-filters-table">
                    <thead>
                        <tr>
                            <th scope="col" class="manage-column"><?php esc_html_e('Filter Type', 'duplicator-pro'); ?></th>
                            <th scope="col" class="manage-column"><?php esc_html_e('Items', 'duplicator-pro'); ?></th>
                        </tr>
                    </thead>
                    <tbody>
                        <?php if (!empty($this->data['filterDirs'])) : ?>
                            <tr>
                                <td><strong><?php esc_html_e('Excluded Directories', 'duplicator-pro'); ?></strong></td>
                                <td>
                                    <?php
                                    $dirs = array_slice($this->data['filterDirs'], 0, 5);
                                    foreach ($dirs as $dir) {
                                        echo '<div>' . esc_html($dir) . '</div>';
                                    }
                                    if (count($this->data['filterDirs']) > 5) {
                                        echo '<div class="dup-more-count">' .
                                        sprintf(esc_html__('... and %d more directories', 'duplicator-pro'), count($this->data['filterDirs']) - 5) .
                                        '</div>';
                                    }
                                    ?>
                                </td>
                            </tr>
                        <?php endif; ?>

                        <?php if (!empty($this->data['filterExts'])) : ?>
                            <tr>
                                <td><strong><?php esc_html_e('Excluded Extensions', 'duplicator-pro'); ?></strong></td>
                                <td>
                                    <?php
                                    $extensions    = array_slice($this->data['filterExts'], 0, 20);
                                    $formattedExts = array_map(function ($ext) {
                                        return '.' . ltrim($ext, '.');
                                    }, array_filter($extensions));
                                    echo esc_html(implode(', ', $formattedExts));
                                    if (count($this->data['filterExts']) > 20) {
                                        echo '<div class="dup-more-count">' .
                                        sprintf(esc_html__('... and %d more extensions', 'duplicator-pro'), count($this->data['filterExts']) - 20) .
                                        '</div>';
                                    }
                                    ?>
                                </td>
                            </tr>
                        <?php endif; ?>

                        <?php if (!empty($this->data['filterFiles'])) : ?>
                            <tr>
                                <td><strong><?php esc_html_e('Excluded Files', 'duplicator-pro'); ?></strong></td>
                                <td>
                                    <?php
                                    $files = array_slice($this->data['filterFiles'], 0, 5);
                                    foreach ($files as $file) {
                                        echo '<div>' . esc_html($file) . '</div>';
                                    }
                                    if (count($this->data['filterFiles']) > 5) {
                                        echo '<div class="dup-more-count">' .
                                        sprintf(esc_html__('... and %d more files', 'duplicator-pro'), count($this->data['filterFiles']) - 5) .
                                        '</div>';
                                    }
                                    ?>
                                </td>
                            </tr>
                        <?php endif; ?>

                        <?php if (!empty($this->data['dbFilterTables'])) : ?>
                            <tr>
                                <td><strong><?php esc_html_e('Excluded Database Tables', 'duplicator-pro'); ?></strong></td>
                                <td>
                                    <?php
                                    $tables = array_slice($this->data['dbFilterTables'], 0, 10);
                                    echo esc_html(implode(', ', $tables));
                                    if (count($this->data['dbFilterTables']) > 10) {
                                        echo '<div class="dup-more-count">' .
                                        sprintf(esc_html__('... and %d more tables', 'duplicator-pro'), count($this->data['dbFilterTables']) - 10) .
                                        '</div>';
                                    }
                                    ?>
                                </td>
                            </tr>
                        <?php endif; ?>

                        <?php if (!empty($this->data['dbPrefixFilter'])) : ?>
                            <tr>
                                <td><strong><?php esc_html_e('Database Prefix Filter', 'duplicator-pro'); ?></strong></td>
                                <td><?php esc_html_e('Enabled', 'duplicator-pro'); ?></td>
                            </tr>
                        <?php endif; ?>
                    </tbody>
                </table>
                <hr>
            <?php endif; ?>

            <?php
            // Transfer status
            if (!empty($this->data['uploadSummaries'])) : ?>
                <div class="dup-log-type-wrapper">
                    <strong><?php esc_html_e('Transfer Status:', 'duplicator-pro'); ?></strong>
                </div>
                <div class="dup-log-context-content">
                    <ul class="dup-log-list">
                        <?php foreach ($this->data['uploadSummaries'] as $s) :
                            $name     = (string) ($s['name'] ?? '');
                            $status   = (string) ($s['status'] ?? '');
                            $progress = isset($s['progress']) ? (float) $s['progress'] : 0.0; ?>
                            <li>
                                <?php echo esc_html($name); ?>
                                <?php if ($status !== '') :
                                    ?> - <?php echo esc_html($status); ?><?php
                                endif; ?>
                                <?php if ($progress > 0) :
                                    ?> (<?php echo esc_html(number_format($progress, 1)); ?>%)<?php
                                endif; ?>
                            </li>
                        <?php endforeach; ?>
                    </ul>
                </div>
            <?php endif;

            $subEvents = array_merge(
                // [$this],
                self::getList(
                    [
                        'parent_id' => $this->getId(),
                        'order'     => 'ASC',
                        'orderby'   => 'created_at',
                    ]
                )
            );
        if (count($subEvents) > 0) {
            ?>
                <div class="margin-top-1">
                <?php TplMng::getInstance()->render('admin_pages/activity_log/parts/sub_table_mini', ['logs' => $subEvents]); ?>
                </div>
        <?php } ?>

        <?php
            // Show error context for error sub-events OR parent events that have error child events
            $backupLogContext = $this->getBackupLogContextForDisplay();
        if (!empty($backupLogContext)) : ?>
                <hr>
                <div class="dup-log-type-wrapper">
                    <strong><?php esc_html_e('Error Context:', 'duplicator-pro'); ?></strong>
                </div>

                <div class="dup-log-context-content">
                    <?php $this->renderBackupLogContext($backupLogContext); ?>
                </div>
        <?php endif;
        ?>
        </div>
        <?php
    }

    /**
     * Get backup log context for display - either from current event or from child error events
     *
     * @return string[] Array of log lines
     */
    private function getBackupLogContextForDisplay(): array
    {
        // If this is an error event with backup log context, return it directly
        if ($this->subType === self::SUB_TYPE_ERROR && !empty($this->data['backupLogContext'])) {
            return $this->data['backupLogContext'];
        }

        // If this is a parent event (parentId = 0) with error severity, look for error context in child events
        if ($this->parentId === 0 && $this->severity === self::SEVERITY_ERROR) {
            $childEvents = self::getList([
                'parent_id' => $this->getId(),
                'order'     => 'DESC',
                'orderby'   => 'created_at',
            ]);

            // Find the first child event with backup log context
            foreach ($childEvents as $childEvent) {
                if ($childEvent->subType === self::SUB_TYPE_ERROR && !empty($childEvent->data['backupLogContext'])) {
                    return $childEvent->data['backupLogContext'];
                }
            }
        }

        return [];
    }

    /**
     * Render backup log context in a simple collapsible section
     *
     * @param string[] $logLines Array of log lines
     *
     * @return void
     */
    private function renderBackupLogContext(array $logLines): void
    {
        $logUrl  = '';
        $package = $this->getCachedPackage($this->data['packageId'] ?? 0);

        $logUrl = $package->getLogUrl();

        TplMng::getInstance()->render('admin_pages/activity_log/parts/error_log_context', [
            'logLines' => $logLines,
            'logUrl'   => $logUrl,
        ]);
    }

    /**
     * Capture the last 15 lines from backup log for error context
     *
     * @param AbstractPackage $package The package object
     *
     * @return string[] Array of recent log lines
     */
    private function captureBackupLogContext(AbstractPackage $package): array
    {
        try {
            return DupLog::getLogContext($package->getNameHash(), 15);
        } catch (Exception $e) {
            return ['Error reading backup log: ' . $e->getMessage()];
        }
    }

    /**
     * Return object type label, can be overridden by child classes
     * by default it returns the same as static::getTypeLabel() but can change in base of object properties
     *
     * @return string
     */
    public function getObjectTypeLabel(): string
    {
        switch ($this->subType) {
            case self::SUB_TYPE_ERROR:
                return __('Backup Error', 'duplicator-pro');
            case self::SUB_TYPE_CANCELLED:
                return __('Backup Cancelled', 'duplicator-pro');
            case self::SUB_TYPE_START:
                return __('Backup Create', 'duplicator-pro');
            case self::SUB_TYPE_DB_DUMP:
                return __('Database Dump', 'duplicator-pro');
            case self::SUB_TYPE_FILE_DUMP:
                return __('File Dump', 'duplicator-pro');
            case self::SUB_TYPE_TRANSFER:
                return __('Backup Transfer', 'duplicator-pro');
            case self::SUB_TYPE_END:
                return __('Backup Completed', 'duplicator-pro');
            default:
                return __('Backup Create', 'duplicator-pro');
        }
    }
}
