@extends('admin.layout')

@section('content')
<div class="container">

    <h2 class="mb-4">Salary Management</h2>

    {{-- FILTER FORM --}}
    <form method="GET" class="row mb-4">
        <div class="col-md-3">
            <label>Month</label>
            <select name="month" class="form-control">
                @foreach(range(1,12) as $m)
                    <option value="{{ $m }}" {{ $month == $m ? 'selected':'' }}>
                        {{ DateTime::createFromFormat('!m',$m)->format('F') }}
                    </option>
                @endforeach
            </select>
        </div>

        <div class="col-md-3">
            <label>Year</label>
            <input type="number" name="year" class="form-control" value="{{ $year }}">
        </div>

        <div class="col-md-3 d-flex align-items-end">
            <button class="btn btn-primary w-100">Filter</button>
        </div>
    </form>

    {{-- SALARY FORM FOR EACH WORKER --}}
    <table class="table table-bordered">
        <thead>
            <tr>
                <th>Worker</th>
                <th>Gross Salary</th>
                <th>Allowance</th>
                <th>Deduction</th>
                <th>Net Salary</th>
                <th>Action</th>
            </tr>
        </thead>

        <tbody>
            @foreach($workers as $worker)
                @php
                    $sal = $worker->monthly_salary;
                    $allowance = app\Models\Allowance::where('worker_id','=',$worker->id)->where('year','=',$year)->where('month','=',$month)->sum('amount');
                 $deduction = app\Models\Deduction::where('worker_id','=',$worker->id)->where('year','=',$year)->where('month','=',$month)->sum('amount');
        
                @endphp

                <tr>
                   
                        @csrf
                        <input type="hidden" name="month" value="{{ $month }}">
                        <input type="hidden" name="year" value="{{ $year }}">
                        <input type="hidden" name="worker_id" value="{{ $worker->id }}">

                        <td>{{ $worker->name }}</td>

                        <td>{{ $sal+$allowance }}</td>

                        <td>{{ $allowance }}</td>

                        <td>{{ $deduction  }}</td>

                        <td>
                            {{ $sal+$allowance-$deduction }}
                        </td>

                        <td class="d-flex gap-1">
                           
                            @if($sal)
                                <a href="{{ route('salary.print',[$worker->id,$month,$year]) }}"
                                   class="btn btn-secondary btn-sm" target="_blank">Print</a>
                            @endif
                        </td>
                  
                </tr>
            @endforeach
        </tbody>
    </table>
</div>
@endsection