@extends('layout.app')

@section('content')
    <div class="card">
        <div class="card-header">
            <h3 class="card-title">Month Wise Salary Summary</h3>
            <div class="card-tools">
                <a href="{{ route('payrollEmployee.index') }}" class="btn btn-sm btn-default">Back To List</a>
            </div>
        </div>

        <div class="card-body">
            <div class="row mb-4">
                <div class="col-md-3">
                    <label class="mb-0 text-muted">Employee Id</label>
                    <div><strong>{{ $employee->employee_id }}</strong></div>
                </div>
                <div class="col-md-3">
                    <label class="mb-0 text-muted">Name</label>
                    <div><strong>{{ $employee->name }}</strong></div>
                </div>
                <div class="col-md-3">
                    <label class="mb-0 text-muted">Designation</label>
                    <div><strong>{{ $employee->current_designation ?: 'N/A' }}</strong></div>
                </div>
                <div class="col-md-3">
                    <label class="mb-0 text-muted">Basic Salary</label>
                    <div><strong>{{ $employee->current_salary }}</strong></div>
                </div>
            </div>

            <form method="GET" action="{{ route('payrollEmployee.monthlySummary', $employee->id) }}" class="form-inline mb-4">
                <label class="mr-2" for="year">Year</label>
                <select name="year" id="year" class="form-control form-control-sm mr-2">
                    @foreach ($years as $option)
                        <option value="{{ $option }}" {{ $option == $year ? 'selected' : '' }}>{{ $option }}</option>
                    @endforeach
                </select>
                <button type="submit" class="btn btn-sm btn-primary">Search</button>
            </form>

            <div class="table-responsive">
                <table class="table table-bordered table-sm">
                    <thead class="bg-gray-50">
                        <tr>
                            <th>Month</th>
                            <th class="text-right">Total Salary</th>
                            <th class="text-right">Total Paid</th>
                            <th class="text-right">Due</th>
                        </tr>
                    </thead>
                    <tbody>
                        @foreach ($months as $month)
                            <tr>
                                <td>{{ $month['name'] }}</td>
                                <td class="text-right">{{ number_format($month['salary'], 2) }}</td>
                                <td class="text-right">{{ number_format($month['paid'], 2) }}</td>
                                <td class="text-right {{ $month['due'] > 0 ? 'text-danger' : '' }}">
                                    {{ number_format($month['due'], 2) }}</td>
                            </tr>
                        @endforeach
                    </tbody>
                    <tfoot>
                        <tr class="font-weight-bold">
                            <td>Total</td>
                            <td class="text-right">{{ number_format(collect($months)->sum('salary'), 2) }}</td>
                            <td class="text-right">{{ number_format(collect($months)->sum('paid'), 2) }}</td>
                            <td class="text-right">{{ number_format(collect($months)->sum('due'), 2) }}</td>
                        </tr>
                    </tfoot>
                </table>
            </div>
        </div>
    </div>
@endsection