@extends('admin.layouts.app')

@section('content')

<style>
        .card-body {
            text-align: center;
        }
        .file-icon {
            font-size: 5rem;
            color: #28a745;
        }
        .action-icon {
            font-size: 2rem;
            margin: 0 10px;
            cursor: pointer;
        }
        .excel-img
        {
          max-width: 50%;
        }
        .table-header
        {
            text-align: center;
        font-size: 30px;
        background: #96c0ff;
        }
    </style>

<div class="title-wrapper pt-30">
          <div class="row align-items-center">
            <div class="col-md-6">
              <div class="title">
                <h2>Saved Reports</h2>
              </div>
            </div>
            <!-- end col -->
            <div class="col-md-6">
              <div class="breadcrumb-wrapper">
                <nav aria-label="breadcrumb">
                  <ol class="breadcrumb">
                    <li class="breadcrumb-item">
                      <a href="#0">Dashboard</a>
                    </li>
                    <li class="breadcrumb-item"><a href="#0">Reports</a></li>
                    <li class="breadcrumb-item active" aria-current="page">
                      Saved Reports
                    </li>
                  </ol>
                </nav>
              </div>
            </div>
            <!-- end col -->
          </div>
          <!-- end row -->
        </div>

        <div class="card-style mb-30">
              <div class="title d-flex justify-content-between align-items-center">
                <h6 class="mb-10">Recent Reports</h6>
                
              </div>

              <div class="row mt-3">
              @if ($reports)
    @foreach ($reports as $report)
        <div class="col-md-4 mb-3">
            <div class="card">
                <div class="card-body">
                    <img class="excel-img" src="{{ asset('assets/images/icons8-excel.svg') }}" alt="">
                    <h5 class="card-title mt-3">{{ $report->input_data->filename }}</h5>
                    <div class="mt-3">
                        <a href="#" class="action-icon download-file" data-id="{{ $report->id }}" title="Download">
                            <span class="mdi mdi-download-circle"></span>
                        </a>
                        <a href="#" class="action-icon view-file" data-id="{{ $report->id }}" title="View">
                            <span class="mdi mdi-eye-circle"></span>
                        </a>
                        <a href="{{ route('reports.edit', $report->id) }}" class="action-icon view-file" title="Edit">
                            <span class="mdi mdi-pencil-circle"></span>
                        </a>
                        <form id="delete-form-{{ $report->id }}" action="{{ route('delete', ['id' => $report->id]) }}" method="POST" style="display: inline;">
                            @csrf
                            @method('DELETE')
                            <a href="#" class="action-icon" title="Delete" onclick="event.preventDefault(); if(confirm('Are you sure you want to delete the report?')) { document.getElementById('delete-form-{{ $report->id }}').submit(); }">
                                <span class="mdi mdi-trash-can"></span>
                            </a>
                        </form>
                    </div>
                </div>
            </div>
        </div>
    @endforeach
@else
    <p>No recent reports.</p>
@endif

</div>

            </div>

            <div class="modal fade modal-full" id="summaryModal" tabindex="-1" aria-labelledby="summaryModalLabel" aria-hidden="true">
    <div class="modal-dialog modal-dialog-centered" style="max-width:100%;">
        <div class="modal-content" style="font-size: 11.5px;">
        <div id="alertContainer" class="mt-3"></div>
            <div class="modal-header">
                <button type="button" class="btn-close" data-bs-dismiss="modal" aria-label="Close"></button>
            </div>
            <div class="modal-body" id="summaryModalBody">
            <div id="excelTableContainer"></div>
            </div>
        </div>
    </div>
</div>

<script src="https://cdnjs.cloudflare.com/ajax/libs/xlsx/0.17.0/xlsx.full.min.js"></script>

<script>

document.addEventListener("DOMContentLoaded", function() {
    document.querySelectorAll(".view-file").forEach(function(button) {
        button.addEventListener("click", function() {
            var reportId = this.getAttribute("data-id");

            // Fetch report data from the backend
            fetch(`/reports/view/${reportId}`)
                .then(response => {
                    if (!response.ok) {
                        throw new Error('Network response was not ok ' + response.statusText);
                    }
                    return response.json();
                })
                .then(data => {
                    // Clear any existing content in modal
                    var modalBody = document.getElementById("excelTableContainer");
                    modalBody.innerHTML = "";

                    // Create a table element
                    var table = document.createElement("table");
                    table.classList.add("table", "table-bordered");

                    // Add table header
                    var thead = document.createElement("thead");
                    var headerRow = thead.insertRow();
                    data[0].forEach(function(column) {
                        var headerCell = document.createElement("th");
                        headerCell.textContent = column;
                        headerCell.colSpan = 15; // Example of setting colspan
                        headerCell.classList.add("table-header"); // Adding table-header class
                        headerRow.appendChild(headerCell);
                    });
                    table.appendChild(thead);

                    // Add table body
                    var tbody = document.createElement("tbody");
                    for (var i = 1; i < data.length; i++) {
                    var rowData = data[i];
                    var row = tbody.insertRow();

                    // Loop through each column in the current row data to create table cells
                    for (var j = 0; j < rowData.length; j++) {
                        var cell = row.insertCell();
                        cell.textContent = rowData[j];
                    }
                }
                    table.appendChild(tbody);

                    // Append table to modal body
                    modalBody.appendChild(table);

                    // Show the modal
                    $('#summaryModal').modal('show');
                })
                .catch(error => console.error('Error fetching report data:', error));
        });
    });
});

document.addEventListener("DOMContentLoaded", function() {
    document.querySelectorAll(".download-file").forEach(function(button) {
        button.addEventListener("click", function() {
            var reportId = this.getAttribute("data-id");

            // Fetch report data from the backend
            fetch(`/reports/download/${reportId}`)
                .then(response => {
                    if (!response.ok) {
                        throw new Error('Network response was not ok ' + response.statusText);
                    }
                    return response.json();
                })
                .then(data => {
                    // Get the title from the first row (assuming it's the first element)
                    var title = data[0][0]; // Adjust this based on your actual data structure

                    // Remove header row for Excel file
                    var excelData = data.slice(0); // Exclude the first row (header)

                    // Create workbook and worksheet
                    var workbook = XLSX.utils.book_new();
                    var worksheet = XLSX.utils.json_to_sheet(excelData, { skipHeader: true }); // Skip header row

                    // Add worksheet to workbook
                    XLSX.utils.book_append_sheet(workbook, worksheet, 'Sheet1');

                    // Generate Excel file and trigger download
                    var excelBuffer = XLSX.write(workbook, { bookType: 'xlsx', type: 'array' });
                    var filename = title + '.xlsx'; // Set filename using the title
                    saveAs(new Blob([excelBuffer], { type: 'application/octet-stream' }), filename);
                })
                .catch(error => console.error('Error fetching or processing Excel file:', error));
        });
    });
});




</script>


@endsection