@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>Labour 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="container-fluid">
        <div class="row">
            <div class="col-12">
                <div class="card">
                    <div class="card-header">
                        <h3 class="card-title">Labour Report</h3>
                    </div>
                    <!-- /.card-header -->
                    <div class="card-body">
                        <form >
                            <div class="row py-4">
                                <div class="col-md-3 form-group">
                                    <label for="exampleInputEmail1">From</label>
                                    <input type="date" name="from" class="form-control" >
                                </div>         
                                <div class="col-md-3 form-group">
                                    <label for="exampleInputEmail1">To</label>
                                    <input type="date" name="to" class="form-control" >
                                </div>  
                                 <div class="col-md-2 form-group">
                                    <label for="exampleInputEmail1">Labour</label>
                                    <select name="labour_id" class="form-control" required>
                                        <option value="" hidden></option>
                                        @foreach($labours as $labour)
                                        <option value="{{$labour->l_id}}">{{$labour->name}}</option>
                                        @endforeach
                                    </select>                  
                                </div>         
                                <div class="col-3 py-2">                         
                                    <br>
                                    <button type="submit" name="go" class="btn btn-primary">Search</button>
                                </div>
                            </div>
                        </form>
                        @if($paid)
                        
                        <div class="row">
                            <div class="col-md-6">
                                 <h5 class="sub-header">Paid Amount</h5>
                                <table id="example1" class="table table-bordered table-striped">
                                    <thead>
                                      <tr>
                                        <th scope="col">Sl No</th>
                                        <th scope="col">Date</th>
                                        <th scope="col">Name</th>
                                        <th scope="col">Site</th>
                                        <th scope="col">Amount</th></th>
                                        <th scope="col">Transaction Method</th>
                                      </tr>
                                    </thead>
                                    <tbody>
                                      @php($i=1)
                                      @foreach($paid as $pay)
                                      <tr>
                                        <th scope="row">{{$i++}}</th>
                                        <td>{{$pay->date}}</td>
                                        <td>{{$pay->name}}</td>
                                        <td>{{$pay->site_name}}</td>
                                        <td>{{$pay->amount}}</td>
                                        <td>{{$pay->method}}</td>
                                      </tr>
                                      @endforeach
                                       <tr>
                                          <td colspan="4"><b>Total :</b></td>
                                          <td><b>{{$total}}</b></td>
                                          <td></td>
                                          <td hidden></td>
                                          <td hidden></td>
                                          <td hidden></td>
                                          <td hidden></td>
                                       </tr>
                                    </tfoot>
                                </table>
                            </div>
                            <div class="col-md-6">
                                <h5 class="sub-header">Attendance</h5>
                                <table id="example4" class="table table-bordered table-striped">
                                    <thead>
                                      <tr>
                                        <th scope="col">Sl No</th>
                                        <th scope="col">Date</th>
                                        <th scope="col">Labour</th>
                                        <th scope="col">Site</th>
                                        <th scope="col">Status</th>
                                        <th scope="col">Amount</th>
                                        <th scope="col">Remarks</th>
                                      </tr>
                                    </thead>
                                    <tbody>
                                      @php($i=1)
                                      @foreach($attendances as $attendance)
                                      
                                      <tr class="odd">
                                      <th scope="row">{{$i++}}</th>
                                        <td>{{$attendance->date}}</td>
                                        <td>{{$attendance->name}}</td>
                                        <td>{{$attendance->site_name}}</td>
                                        <td>{{$attendance->status}}</td>
                                        <td>{{$attendance->amount}}</td>
                                        <td>{{$attendance->remarks}}</td>
                                      </tr>
                                      
                                      @endforeach
                                      <tr>
                                          <td colspan="5"><b>Total :</b></td>
                                          <td><b>{{$atten_total}}</b></td>
                                          <td></td>
                                          <td hidden></td>
                                          <td hidden></td>
                                          <td hidden></td>
                                          <td hidden></td>
                                          <td hidden></td>
                                       </tr>
                                      
                                    </tfoot>
                                </table>
                            </div>
                        </div>
                        @endif
                    </div>
                    <!-- /.card-body -->
                </div>
                <!-- /.card -->
            </div>
            <!-- /.col -->
        </div>
    </div>
    <!-- /.row -->
    </div>
    <!-- /.container-fluid -->
</section>

@endsection