@extends('layouts.admin')

@section('content')
<!-- Content Header (Page header) -->
<div class="content-wrapper" style="min-height: 2080.12px;">
    <!-- Content Header (Page header) -->
    <section class="content-header">
      <div class="container-fluid">
        <div class="row mb-2">
          <div class="col-sm-6">
            <h1>Attendance Report</h1>
          </div> 
          <!-- <div class="col-sm-6"> 
            <ol class="breadcrumb float-sm-right">
              <li class="breadcrumb-item"><a href="#">Home</a></li>
              <li class="breadcrumb-item active">Sales</li>
            </ol>
          </div> -->
        </div>
      </div><!-- /.container-fluid -->
    </section>
    <section class="content">
        <div class="card">
            <div class="card-header">
                <h3 class="card-title">Attendance Report</h3>
            </div>
            <div class="card-body">
                <form>
                    <div class="row">
                        <div class="form-group col-md-2">
                            <label for="exampleInputEmail1">From</label>
                            <input type="date" class="form-control" name="from" id="exampleInputEmail1"  required>
                        </div>
                        <div class="form-group col-md-2">
                            <label for="exampleInputEmail1">To</label>
                            <input type="date" class="form-control" name="to" id="exampleInputEmail1"  required>
                        </div>
                        <div class="form-group col-md-2">
                            <label for="exampleInputEmail1">Labours</label>
                            <select  class="form-control" name="staff_id" >
                                <option value="" hidden ></option>
                                @foreach($staffs as $labour)
                                    <option value="{{$labour->l_id}}">{{$labour->name}}</option>
                                @endforeach
                            </select>
                        </div>
                        <div class="form-group col-md-3" style="padding-top:30px">
                            <button class="btn btn-primary" type="submit">Submit</button>
                        </div>
                    </div> 
                </form>
                                 @if(count($th_array) > 0)
                <table id="example1" class="table table-bordered table-striped">
                    <thead>
                    <tr>
                            <th>Sl No</th>
                            <th>Labour</th>
                            <th>Attendance</th>
                            <th>Amount</th>
                    </tr>
                    </thead>
                    <tbody>
                                                    
                            
                       
                        
                 @foreach($th_array as $report)
                 
                   <tr>
                        <td>{{$cnt++}}</td>
                        <td>{{$report['staff']}}</td>
                        <td>{{$report['status']}}</td>
                        <td>{{$report['amount']}}</td>
                    </tr>
                @endforeach
                <tr>
                    <td>{{$cnt++}}</td>
                    <td></td>
                    <td><b>Total WorkTime : </b></td>
                    <td><b>{{$total_wrk_time}}</b></td>
                </tr>
                <tr>
                    <td>{{$cnt++}}</td>
                    <td></td>
                    <td><b>Total Salary : </b></td>
                    <td><b>{{$fmt->format($total_salary)}}</b></td>
                </tr>
                 <tr>
                    <td>{{$cnt++}}</td>
                    <td></td>
                    <td><b>Total Salary Paid: </b></td>
                    <td><b>{{$fmt->format($total_salary_paid)}}</b></td>
                </tr>
                 <tr>
                    <td>{{$cnt++}}</td>
                    <td></td>
                    <td><b>Total Advance Paid: </b></td>
                    <td><b>{{$fmt->format($total_advance_paid)}}</b></td>
                </tr>
                 
                  <tr>
                    <td>{{$cnt++}}</td>
                    <td></td>
                    <td>
                        <b>
                            @if($total_advance_paid > $total_salary)
                                Pending Advance :
                            @else
                                Pending Salary : 
                            @endif
                        </b>
                    </td>
                    <td><b>{{$fmt->format(abs($pending_salary))}}</b></td>
                </tr>
                
            @endif
             </table>
                
              
            </div>
        </div>
    </section>
</div>

<script src="{{ asset('plugins/jquery/jquery.min.js')}}"></script>
<!-- jQuery UI 1.11.4 -->
<script src="{{ asset('plugins/jquery-ui/jquery-ui.min.js')}}"></script>



@endsection