@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>

<section class="section">
        <div class="container-fluid">
          <!-- ========== title-wrapper start ========== -->
          <div class="title-wrapper pt-30">
            <div class="row align-items-center">
              <div class="col-md-6">
                <div class="title">
                  <h2>Dashboard</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 active" aria-current="page">
                        eCommerce
                      </li>
                    </ol>
                  </nav>
                </div> -->
              </div>
              <!-- end col -->
            </div>
            <!-- end row -->
          </div>
          <!-- ========== title-wrapper end ========== -->
          <div class="row">
            <!-- <div class="col-xl-3 col-lg-4 col-sm-6">
              <div class="icon-card mb-30">
                <div class="icon purple">
                  <i class="lni lni-question-circle"></i>
                </div>
                <div class="content">
                  <h6 class="mb-10" style="width: max-content;">Inquries Pending</h6>
                  <h3 class="text-bold mb-10"></h3>
                  
                </div>
              </div>
            </div>
            <div class="col-xl-3 col-lg-4 col-sm-6">
              <div class="icon-card mb-30">
                <div class="icon success">
                  <i class="lni lni-users"></i>
                </div>
                <div class="content">
                  <h6 class="mb-10">Subscribers</h6>
                  <h3 class="text-bold mb-10"></h3>
                  
                </div>
              </div>
            </div> -->
            <div class="col-xl-6 col-lg-8 col-sm-12">
              <div class="icon-card mb-30">
                <div class="icon primary">
                <i class="lni lni-stats-up"></i>
                </div>
                <div class="content">
                  <h6 class="mb-10">Total Reports</h6>
                  <h3 class="text-bold mb-10">{{ count($reports) }}</h3>
                  
                </div>
              </div>
              <!-- End Icon Cart -->
            </div>
            <div class="col-xl-6 col-lg-8 col-sm-12">
              <div class="icon-card mb-30">
                <div class="icon orange">
                  <i class="lni lni-user"></i>
                </div>
                <div class="content">
                  <h6 class="mb-10">Total Users</h6>
                  <h3 class="text-bold mb-10">{{ $userCount }}</h3>
                  
                </div>
              </div>
            </div>
          </div>
          
          <div class="row">
          <!-- <div class="col-lg-12">
              <div class="card-style mb-30">
                <div class="title d-flex flex-wrap align-items-center justify-content-between">
                  <div class="left">
                    <h6 class="text-medium mb-30">Inquries History</h6>
                  </div>
                  <div class="right">
                  

                  <input class="btn light-btn-outline rounded-full" type="text" placeholder="Select Date" onfocus="(this.type='date')" id="dateFilter">
                  <button class="btn light-btn-outline rounded-full" onclick="clearFilter()">Clear Filter</button>
                <button class="btn light-btn-outline rounded-full " onclick="filterData()">Apply Filter</button>
                <p id="noDataMessage" style="display: none; color: red;">No data found for the selected date.</p>


                    
                  </div>
                </div>
                
                  @if(session('success'))
                      <div class="alert alert-success">
                          {{ session('success') }}
                      </div>
                  @endif
                <div class="table-responsive">
                    <table class="table top-selling-table">
                        <thead>
                            <tr>
                                <th>
                                    <h6 class="text-sm text-medium">First Name</h6>
                                </th>
                                <th>
                                    <h6 class="text-sm text-medium">Last Name</h6>
                                </th>
                                <th class="min-width">
                                    <h6 class="text-sm text-medium">Email<i class="lni lni-arrows-vertical"></i></h6>
                                </th>
                                <th class="min-width">
                                    <h6 class="text-sm text-medium">Phone<i class="lni lni-arrows-vertical"></i></h6>
                                </th>
                                <th class="min-width">
                                    <h6 class="text-sm text-medium">Status <i class="lni lni-arrows-vertical"></i></h6>
                                </th>
                                <th class="min-width">
                                    <h6 class="text-sm text-medium">Date <i class="lni lni-arrows-vertical"></i></h6>
                                </th>
                            </tr>
                        </thead>
                        <tbody>
                    {{--    @foreach($inquiries as $inquiry)
                            <tr class="table-row" data-date="{{ $inquiry->created_at }}">
                                <td>
                                    <div class="product">
                                        <p class="text-sm">{{ $inquiry->firstName }}</p>
                                    </div>
                                </td>
                                <td>
                                    <div class="product">
                                        <p class="text-sm">{{ $inquiry->lastName }}</p>
                                    </div>
                                </td>
                                <td>
                                    <p class="text-sm"> <a href="mailto:{{ $inquiry->email }}">{{ $inquiry->email }}</a></p>
                                </td>
                                <td>
                                    <p class="text-sm">{{ $inquiry->phone }}</p>
                                </td>
                                <td>
                                    <span class="status-btn @if($inquiry->status == 'Pending') close-btn @elseif($inquiry->status == 'In Progress') warning-btn @else success-btn @endif">{{ $inquiry->status }}</span>
                                </td>
                                <td>
                                <p class="text-sm">{{ $inquiry->created_at->format('d/m/Y') }}</p>
                                </td>
                                <td>
                                <div class="row flex-nowrap">
                                      <div class="col col-md-5" style="display: flex;">
                                      <a href="{{ route('admin.inquries.view_inquiry', $inquiry->id) }}" class="main-btn primary-btn-light rounded-full btn-hover" style="padding: 10px 30px;">View</a>
                                      </div>
                                    </div>
                                    </div>
                                </td>
                            </tr>
                            @endforeach --}}
                        </tbody>
                    </table>
                </div>
                <div class="row mt-4">
                  <div class="main-btn light-btn-outline square-btn btn-hover col-md-12 d-flex justify-content-center">
                  <a href="{{ url('/admin/inquries')}}"><h3 class="mb-10">View All</h3></a>
                  </div>
                </div>
              </div>
            </div>
          </div> -->
        </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>
                    </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 id="archiveButton" class="btn"></button> -->
                <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>

          <!-- End Row -->
        </div>
        <!-- end container -->
      </section>

      <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