@php
function formatDateToKey($date) {
    return $date->format('j-F');
}
@endphp
<style>
    table {
        border-collapse: collapse;
        width: 100%;
    }

    th,
    td {
        text-align: left;
        padding: 6px;
    } 


    @page {

        th,
        td,
        p,
        div,
        b ... {
            margin: 0;
            padding: 0
        }

        html {
            margin: 40px 50px
        }
    }
</style>


<table width="100%" style="text-align: center; ">
    <tr style="">
        <th style="">
            <div style="">
                <h1>Attendance Sheet</h1>
                <h1>{{ date('d-m-Y', strtotime($employees[0]->date_from)) }} -
                    {{ date('d-m-Y', strtotime($employees[0]->date_to)) }}</h1>
            </div>
        </th>
        <th style="">
            <div style="padding-left: 80% !important;">
@php
    // Get the file path
    $imagePath = public_path('storage/settings/companylogo/' . getcompanylogo());

    // Check if the file exists
    if (file_exists($imagePath)) {
        // Read the image file
        $imageContent = file_get_contents($imagePath);

        // Encode image content to base64
        $base64Image = 'data:image/png;base64,' . base64_encode($imageContent);
    } else {
        // Set base64Image to empty string if file doesn't exist
        $base64Image = '';
    }
@endphp

@if ($base64Image)
    <!-- Display image using base64 -->
    <img src="{{ $base64Image }}" width="125px">
@else
    <!-- Display a placeholder or some alternate content -->
    <p>No image found</p>
@endif              </div>
        </th>
    <tr>
</table>

<br>

<table width="100%" style="">
    <tr style="">
        <th style="" width=""><strong>AL</strong> = Annual</th>
        <th style="" width=""><strong>MC</strong> = Medical</th>
        <th style="" width=""><strong>MT</strong> = Maternity</th>
        <th style="" width=""><strong>MR</strong> = Marriage </th>
        <th style="" width=""><strong>CL</strong> = Compassionate </th>
        <th style="" width=""><strong>HL</strong> = Hospital </th>
        <th style="" width=""><strong>EX</strong> = Examination </th>
    </tr>
    <tr style="">
        <th style="" width=""><strong>PT</strong> = Paternity</th>
        <th style="" width=""><strong>AD</strong> = Advance</th>
        <th style="" width=""><strong>RL</strong> = Replacement</th>
        <th style="" width=""><strong>LS</strong> = Out Of Office </th>
        <th style="" width=""><strong>AB</strong> = Absent </th>
        <th style="" width=""><strong>NPL</strong> = NPL </th>
        <th style="" width=""><strong>EL</strong> = Emergency </th>
    </tr>
</table>

<br>

<table width="100%" style="">
    <tr style="">
        <th>&#10003 = Present</th>
        <th width="1%"><span><div style="background: #e0e0e0; border-radius: 10px; width: 50px; height: 20px;"></div></span></th>
        <th width="30%">= Restday </th>
        <th width="1%"><span><div style="background: #7D7C7C; border-radius: 10px; width: 50px; height: 20px;"></div></span> </th>
        <th><span>= Holiday </th>
    </tr>
</table>

<br>

<table width="100%" class="dtable">
    <thead>
        <tr>
            <th class="dth" style="text-transform: capitalize;">User ID</th>
            <th class="dth" style="text-transform: capitalize;">Name</th>
            <th class="dth" style="text-transform: capitalize;">Overtime</th>
            <th class="dth" style="text-transform: capitalize;">Short</th>
            <th class="dth" style="text-transform: capitalize;">Work</th>
            <th class="dth" style="text-transform: capitalize;">Leave</th>
            @php
                // date creation heading
                $sdatefrom = $employees[0]->date_from;
                $sdateto = $employees[0]->date_to;
                
                $dateRange = \Carbon\CarbonPeriod::create($sdatefrom, $sdateto);
                $dates = $dateRange->toArray();
                
                for ($i = 0; $i < count($dateRange); $i++) {
                    $alldate = $dates[$i]->format('d');
                    echo '<th class="dth" style="text-transform: capitalize; text-align:center;">' . $alldate . '</th>';
                }
            @endphp

        </tr>
    </thead>
    <tbody>
        @foreach ($employees as $employee)
        @php
            @endphp
            <tr>
                <td class="dtd" style="text-transform: capitalize;">{{ $employee->employee_no }}</td>
                <td class="dtd" style="text-transform: capitalize;">{{ $employee->personname }}</td>
                <td class="dtd" style="text-transform: capitalize;">{{ $employee->overtime }}</td>
                <td class="dtd" style="text-transform: capitalize;">{{ $employee->short }}</td>
                <td class="dtd" style="text-transform: capitalize;">{{ $employee->workday }}</td>
                <td class="dtd" style="text-transform: capitalize;">{{ $employee->leave }}</td>
                 @php
            $startDay = explode('-', array_key_first(array_reverse(json_decode(json_encode($employee->att), true))))[0];

        @endphp
                
@foreach ($dates as $date)
    <br />
<b>Fatal error</b>:  Uncaught Error: Call to a member function format() on null in /home/ecoleave/public_html/backup/v6/resources/views/hr/reports/pdf/attendance-sheet.blade.php:156
Stack trace:
#0 {main}
  thrown in <b>/home/ecoleave/public_html/backup/v6/resources/views/hr/reports/pdf/attendance-sheet.blade.php</b> on line <b>156</b><br />