@extends('layouts.customer')

@section('content')

    @php 
        $payroll_type = $payrollSetting->payroll_type;
        $start_day    = $payrollSetting->start_day;
        if($payroll_type == 'biweekly'){
            // Get the current date
            $currentDate = date('Y-m-d');

            // Get the start date of the pay period from your model
            $payStartDate = $payrollSetting->start_date;

            // Calculate the number of days between the start date and the current date
            $daysDifference = floor((strtotime($currentDate) - strtotime($payStartDate)) / (60 * 60 * 24));

            // Calculate the pay period (assuming biweekly)
            $payPeriod = floor($daysDifference / 14) + 1;

            // Calculate the start and end dates of the current pay period
            $currentPayStartDate = date('Y-m-d', strtotime($payStartDate . ' +' . (($payPeriod - 1) * 14) . ' days'));
            $currentPayEndDate = date('Y-m-d', strtotime($currentPayStartDate . ' +13 days'));

            // Get the last pay period's start date
            $lastPayStartDate = date('Y-m-d', strtotime($currentPayStartDate . ' -14 days'));
            
            // Calculate the end date of the last pay period
            $lastPayEndDate = date('Y-m-d', strtotime($lastPayStartDate . ' +13 days'));

        }

        if($payroll_type == 'weekly'){
            // Get the current date
            $currentDate = date('Y-m-d');

            // Get the start date of the pay period from your model
            $payStartDate = $payrollSetting->start_date;

            // Calculate the number of days between the start date and the current date
            $daysDifference = floor((strtotime($currentDate) - strtotime($payStartDate)) / (60 * 60 * 24));

            // Calculate the pay period (assuming weekly)
            $payPeriod = floor($daysDifference / 7) + 1;

            // Calculate the start and end dates of the current pay period
            $currentPayStartDate = date('Y-m-d', strtotime($payStartDate . ' +' . (($payPeriod - 1) * 7) . ' days'));
            $currentPayEndDate = date('Y-m-d', strtotime($currentPayStartDate . ' +6 days'));

            // Get the last pay period's start date
            $lastPayStartDate = date('Y-m-d', strtotime($currentPayStartDate . ' -7 days'));
            
            // Calculate the end date of the last pay period
            $lastPayEndDate = date('Y-m-d', strtotime($lastPayStartDate . ' +6 days'));

        }
    @endphp 
    <style>.search.search-sm:after {content: '' !important;} </style>
    <div class="container-fluid">
            <div class="row">
                <div class="col-12">
                    <h1>Timesheets</h1>
                    <nav class="breadcrumb-container d-none d-sm-block d-lg-inline-block" aria-label="breadcrumb">
                        <ol class="breadcrumb pt-0">
                             <li class="breadcrumb-item">
                                <a href="{{url('/')}}/dashboard">Dashboard</a>
                            </li>

                            <li class="breadcrumb-item active" aria-current="page">Timesheets</li>
                        </ol>
                    </nav>
                    <div class="btn-group mb-1 float-right date-filter">
                        <button class="btn btn-secondary btn-sm dropdown-toggle" type="button" data-toggle="dropdown" aria-haspopup="true" aria-expanded="false">
                            @php
                                $filter = '';
                                if( request()->get('filter') ) {
                                    if( request()->get('filter') == 'this_week' ) {
                                        $filter = 'This Pay Period';
                                    } else if( request()->get('filter') == 'last_week' ) {
                                        $filter = 'Last Pay Period';
                                    } else {
                                        $filter = ucfirst(str_replace("_", " ", request()->get('filter')));
                                    }
                                } else {
                                    $filter = 'Today';
                                }

                            @endphp
                            {{ $filter }}
                        </button>
                        <div class="dropdown-menu" x-placement="bottom-start" style="position: absolute; will-change: transform; top: 0px; left: 0px; transform: translate3d(0px, 36px, 0px);cursor: pointer;">
                            <a class="dropdown-item date-filter-item @if( request()->get('filter') == 'today' ) current @endif" data-filter="today">Today</a>
                            <a class="dropdown-item date-filter-item @if( request()->get('filter') == 'yesterday' ) current @endif" data-filter="yesterday">Yesterday</a>
                            <a class="dropdown-item date-filter-item @if( request()->get('filter') == 'this_week' ) current @endif" data-filter="this_week">This Pay Period</a>
                            <a class="dropdown-item date-filter-item @if( request()->get('filter') == 'last_week' ) current @endif" data-filter="last_week">Last Pay Period</a>
                            <a class="dropdown-item date-filter-item @if( request()->get('filter') == 'this_month' ) current @endif" data-filter="this_month">This Month</a>
                            <a class="dropdown-item date-filter-item @if( request()->get('filter') == 'last_month' ) current @endif" data-filter="last_month">Last Month</a>
                            <a class="dropdown-item date-filter-item @if( request()->get('filter') == 'custom' ) current @endif" data-filter="custom">Custom</a>
                           <!--  <a class="dropdown-item date-filter-item @if( request()->get('filter') == 'all_time' ) current @endif" data-filter="all_time">All Time</a> -->
                            <!-- <a class="dropdown-item date-filter-item @if( request()->get('filter') == 'today' ) current @endif">Last Year</a> -->
                            
                        </div>
                        {!! Form::open(['route' => ['staffs.timesheets', ['account'=>$account]], 'method' => 'GET', 'id' => 'date-filter-form', 'class' => 'form-inline d-inline-flex', 'style'=>'display:inline']) !!}
                            {{ Form::hidden( 'filter', request()->get('filter') ?? 'today' ) }}
                            <div id="custom-filter" class="d-flex mx-2">
                                @if("custom" == request()->get('filter'))
                                <div class="form-group">
                                    <label>From</label>
                                    <input type="date" name="from" class="form-control" value="{{ request()->get('from') }}" required />
                                </div>
                                <div class="form-group">
                                    <label>To</label>
                                    <input type="date" name="to" class="form-control" value="{{ request()->get('to') }}" required />
                                </div>
                                @endif
                            </div>
                            <input type="submit" class="btn btn-info {{ 'custom' == request()->get('filter') ? '' : 'd-none' }}" value="Submit" />
                        {!! Form::close() !!}
                    </div>
                    <div class="separator mb-5"></div>
                </div>
            </div>
            

            <div class="row mb-2">
                @if ($message = Session::get('success'))
                    <div class="w-100 alert alert-success">
                        <p>{{ $message }}</p>
                    </div>
                @endif
            </div>

            <div class="row mb-4">
                <div class="col-12 col-sm-6 col-md-6 col-lg-4 col-xl-4 px-1">
                    <a class="card mb-2" style="border-radius: 10px; overflow: hidden;">
                        <div class="card-body" style="display: flex; align-items: center; padding: 14px 20px 18px;">
                            <div class="flex-1" style="flex-direction: column;">
                                <div class="lead" style="font-size: 2.4rem; line-height: 3.2rem; color: rgb(169, 42, 64);">@if($staffs) {{ count( $staffs ) }} @else {{ 0 }} @endif</div>
                                <p class="card-text mb-0" style="font-size: 1.4rem;">Total Employees</p>
                            </div>
                        </div>
                    </a>
                </div>

                <div class="col-12 col-sm-6 col-md-6 col-lg-4 col-xl-4 px-1">
                    <a class="card mb-2" style="border-radius: 10px; overflow: hidden;">
                        <div class="card-body" style="display: flex; align-items: center; padding: 14px 20px 18px;">
                            <div class="flex-1" style="flex-direction: column;">
                                <div class="lead" style="font-size: 2.4rem; line-height: 3.2rem; color: rgb(169, 42, 64);">
                                    @php
                                        $hours = floor( $total_sec / 3600 );
                                        $mins = floor( $total_sec / 60 % 60 );
                                        echo timeDiffInHoursAndMins( $hours, $mins );
                                    @endphp
                                </div>
                                <p class="card-text mb-0" style="font-size: 1.4rem;">Total Hours</p>
                            </div>
                        </div>
                    </a>
                </div>

                <div class="col-12 col-sm-6 col-md-6 col-lg-4 col-xl-4 px-1">
                    <a class="card mb-2" style="border-radius: 10px; overflow: hidden;">
                        <div class="card-body" style="display: flex; align-items: center; padding: 14px 20px 18px;">
                            <div class="flex-1" style="flex-direction: column;">
                                <div class="lead" style="font-size: 2.4rem; line-height: 3.2rem; color: rgb(169, 42, 64);">${{ number_format($total_billings, 2) }}</div>
                                <p class="card-text mb-0" style="font-size: 1.4rem;">Total Pay</p>
                            </div>
                        </div>
                    </a>
                </div>
            </div>

            <div class="row mb-4">
                <div class="col-12 mb-4">
                    <div class="card">
                        <div class="card-body">
                            @if (request()->get('filter') == 'this_week')
                                <p style="float:right; color:#a3314b;">
                                    <span><b>Current Pay Period:</b> {{ date('M d, Y',strtotime($currentPayStartDate)) }} to {{ date('M d, Y',strtotime($currentPayEndDate)) }}</span>
                                </p>
                            @elseif (request()->get('filter') == 'last_week')
                                <p style="float:right; color:#a3314b;">
                                    <span><b>Last Pay Period:</b> {{ date('M d, Y',strtotime($lastPayStartDate)) }} to {{ date('M d, Y',strtotime($lastPayEndDate)) }}</span>
                                </p>
                            @endif
                            <div>
                                <div id="DataTables_Table_00_wrapper">
                                    <table class="data-table table" id="DataTables_Table_00"> <!-- data-table data-table-feature -->
                                        <thead>
                                            <tr>
                                                <th scope="col">Employee</th>
                                                <th scope="col">Role</th>
                                                {{-- <th scope="col">Regular Hours</th> --}}
                                                <th scope="col">Hours</th>
                                                <th scope="col">Break</th>
                                                <th scope="col">OT</th>
                                                <th scope="col">Wage</th>
                                                <th scope="col">OT</th>
                                                <th scope="col">Total</th>
                                                <!-- <th scope="col">Tip </th> -->
                                                <th scope="col">Action</th>
                                            </tr>
                                        </thead>
                                        <tbody>
                                            @php $total = 0; @endphp
                                            @if($staffs)
                                                @foreach($staffs as $staff)
                                                    <tr>
                                                        <td>
                                                            <div class="d-flex flex-row">
                                                                <a class="d-flex" href="{{ route('staffs.user.timesheet', ['account' => $account, 'staff_id' => $staff->id]) }}">
                                                                    <img alt="Profile Picture" src="{{ $staff->getProfileImage() ?: url('img/profiles/default.png') }}" class="img-thumbnail border-0 rounded-circle list-thumbnail align-self-center xsmall">
                                                                </a>
                                                                <div class="d-flex flex-grow-1 min-width-zero">
                                                                    <div class="m-2 pl-0 align-self-center d-flex flex-column flex-lg-row justify-content-between min-width-zero">
                                                                        <div class="min-width-zero">
                                                                            <a href="{{ route('staffs.user.timesheet', ['account' => $account, 'staff_id' => $staff->id]) }}">
                                                                                <p class="mb-0 truncate">{{ $staff->getName() ?? 'Guest' }}</p>
                                                                            </a>
                                                                        </div>
                                                                    </div>
                                                                </div>
                                                            </div>
                                                        </td>
                                                        <td>
                                                            {{ $staff->roles->whereNotIn('name', 'BranchStaffMember')->first()->display_name ?? '-' }}
                                                        </td>
                                                        {{-- <td>40</td> --}}
                                                        <td>
                                                            @if( $staff->clock )
                                                                @php
                                                                    $total += collect($staff->clock)->sum('time');
                                                                    $hours = floor(collect($staff->clock)->sum('time') / 3600);
                                                                    $mins = floor(collect($staff->clock)->sum('time') / 60 % 60);

                                                                    // echo sprintf('%02d:%02d', $hours, $mins);
                                                                    echo timeDiffInHoursAndMins($hours, $mins);
                                                                @endphp
                                                            @else
                                                                0
                                                            @endif
                                                        </td>
                                                        <td>{{ $staff->break_time ?? '-' }}</td>
                                                        <td>
                                                            @php
                                                                /*
                                                                Daily OT
                                                                // $working_hours = 8; // Dynamically added
                                                                $regular_hours = $working_hours * 60 * 60;
                                                                $overtime_clocked = 0;
                                                                foreach( $staff->clock as $date => $clock ) {
                                                                    if( $clock['time'] > $regular_hours ) {
                                                                        $overtime_clocked += $clock['time'] - $regular_hours;
                                                                    }
                                                                }
                                                                
                                                                $hours = floor($overtime_clocked / 3600);
                                                                $mins = floor($overtime_clocked / 60 % 60);
                                                                echo timeDiffInHoursAndMins($hours, $mins);
                                                                */

                                                                // Weekly OT
                                                                $overtime_clocked = $staff->otGrandTotal ?? 0;

                                                                $hours = floor($overtime_clocked / 3600);
                                                                $mins = floor($overtime_clocked / 60 % 60);
                                                                echo timeDiffInHoursAndMins($hours, $mins);
                                                            @endphp
                                                        </td>
                                                        <td>${{ !empty($staff->payment_type_hourly) ? number_format($staff->payment_type_hourly, 2) : '0.00' }}</td>

                                                        <td>
                                                            @if( isset($staff->payment_type_hourly) && $staff->payment_type_hourly > 0 )
                                                                @if( $overtime_clocked )
                                                                    @php
                                                                        $per_hour = $staff->payment_type_hourly;
                                                                        $hours = floor($overtime_clocked / 3600);
                                                                        $mins = floor($overtime_clocked / 60 % 60);

                                                                         // Calculate the total amount (rate = 1.5 is for overtime pay)
                                                                        $total_amount = round($hours * $per_hour + $mins * ($per_hour / 60), 2) * 1.5;

                                                                        // Format the total amount to always have two digits after the decimal point
                                                                        $formatted_amount = number_format($total_amount, 2);
                                                                        
                                                                        echo '$' . $formatted_amount;
                                                                    @endphp
                                                                @else
                                                                    $ {{ '0' }}
                                                                @endif
                                                            @else
                                                                {{ 'N/A' }}
                                                            @endif
                                                        </td>
                                                        <td>
                                                            @if( isset($staff->payment_type_hourly) && $staff->payment_type_hourly > 0 )
                                                                @if( $staff->clock )
                                                                    @php
                                                                        $per_hour = $staff->payment_type_hourly;
                                                                        $hours = floor( ( collect($staff->clock)->sum('time') - $overtime_clocked ) / 3600);
                                                                        $mins = floor( ( collect($staff->clock)->sum('time') - $overtime_clocked ) / 60 % 60);

                                                                        $ohours = floor( $overtime_clocked / 3600);
                                                                        $omins = floor( $overtime_clocked / 60 % 60);

                                                                         // Calculate the total amount + OT
                                                                        $total_amount = round($hours * $per_hour + $mins * ($per_hour / 60), 2)
                                                                            + round($ohours * $per_hour + $omins * ($per_hour / 60), 2) * 1.5; // rate = 1.5 for OT(Over time)

                                                                        // $total_amount = round($hours * $per_hour + $mins * ($per_hour / 60), 2);

                                                                        // Format the total amount to always have two digits after the decimal point
                                                                        $formatted_amount = number_format($total_amount, 2);
                                                                        
                                                                        echo '$' . $formatted_amount;
                                                                    @endphp
                                                                @else
                                                                    $ {{ '0' }}
                                                                @endif
                                                            @else
                                                                {{ 'N/A' }}
                                                            @endif
                                                        </td>
                                                        <td>
                                                            <div class="d-flex align-items-center">
                                                                <div class="dropdown">
                                                                    <div style="cursor: pointer;" data-toggle="dropdown" aria-haspopup="true" aria-expanded="false" class="glyph-icon simple-icon-options-vertical"></div>
                                                                    <div class="dropdown-menu" aria-labelledby="dropdownMenuButton">
                                                                        <a class="dropdown-item pe-3" href="{{ route('staffs.user.timesheet', ['account' => $account, 'staff_id' => $staff->id]) }}">
                                                                            View
                                                                        </a>       
                                                                        <!-- <a class="dropdown-item pe-3" href="javascript:void(0);">
                                                                            Edit
                                                                        </a>                                      -->
                                                                    </div>
                                                                </div>
                                                            </div>
                                                        </td>
                                                    </tr>
                                                @endforeach
                                            @else
                                                <tr colspans="5">
                                                    <p>No records found!</p>
                                                </tr>
                                            @endif
                                        </tbody>
                                        {{-- <tfoot style="background-color: #ccc;">
                                            <tr>
                                                <td>
                                                    <strong>Payroll Total</strong>
                                                </td>
                                                <td></td>
                                                <td></td>
                                                <td>
                                                    @if( $total > 0 )
                                                        @php
                                                            $hours = floor($total / 3600);
                                                            $mins = floor($total / 60 % 60);

                                                            // echo sprintf('%02d:%02d', $hours, $mins);
                                                            echo timeDiffInHoursAndMins($hours, $mins);
                                                        @endphp
                                                    @else
                                                        0
                                                    @endif
                                                </td>
                                                <td></td>
                                            </tr>
                                        </tfoot> --}}
                                    </table>

                                    {{-- $staffs->links('vendor.pagination.dore') --}}
                                </div>
                                
                            </div>
                        </div>
                    </div>
                </div>
            </div>
        </div>
@endsection

@section('script')
    <script type="text/javascript">   
        (function($){
            $(document).ready(function () {
                if($("#DataTables_Table_00").length){
                    $('#DataTables_Table_00').DataTable({
                        initComplete: function(){
                            $("#DataTables_Table_00_wrapper div.float-right")
                                .prepend(`
                                    <button type="button" class="btn btn-sm btn-outline-primary mr-3" id="ppdf">
                                        <span class="glyph-icon simple-icon-doc"></span> PDF 
                                    </button>
                                `);           
                        },
                        sDom: '<"row view-filter"<"col-sm-12 mb-2"<"float-left"l><"float-right d-flex align-items-center"f><"clearfix">>>t<"row view-pager"<"col-sm-12"<"text-center"ip>>>',
                    });
                }

                $(document).on('click', '#ppdf', function() {
                    let form = $("#date-filter-form");

                    // Add input field
                    form.append('<input type="hidden" name="download_pdf" value="1" />');

                    // Submit form
                    form.submit();

                    // After submit remove input
                    form.find('input[name="download_pdf"]').remove();
                });

            });

            $(document).ready(function() {
                $('.date-filter .date-filter-item').on('click', function() {
                    let dateFilterText = $(this).text(),
                        dateFilterItem = $(this).data('filter');
                    // Check for base case
                    if( $(this).hasClass('current') ) return;

                    $(this).addClass('current'); // set current
                    $('.date-filter').find('button').text( dateFilterText ); 

                    if( "custom" == dateFilterItem ) {
                        $("#date-filter-form").find("[name=filter]")
                            .val( dateFilterItem );
                        $("#date-filter-form").find("[type=submit]")
                            .removeClass( 'd-none' );

                        $("#date-filter-form").find("#custom-filter")
                            .prepend(`
                                <div class="form-group">
                                    <label>From</label>
                                    <input type="date" name="from" class="form-control" required />
                                </div>
                                <div class="form-group">
                                    <label>To</label>
                                    <input type="date" name="to" class="form-control" required />
                                </div>
                            `);
                        return;
                    } else {
                        $("#date-filter-form").find("#custom-filter")
                            .empty();
                        $("#date-filter-form").find("[type=submit]")
                            .addClass( 'd-none' );
                    }

                    $("#date-filter-form").find("[name=filter]")
                        .val( dateFilterItem );
                    $("#date-filter-form").submit();
                });
            });
        })(jQuery);
    </script>
@endsection