@extends('Admin.AdminMaster')
@section('content')

<div class="ibox-content">

    <div class="col-12">
        <h3 class="mb-2 page-title">All Salary Report Or Search By Date</h3>
        <button style="position: absolute; top: 4.5%; right: 20.7%;;" type="button" class="btn mb-2 btn-primary" data-toggle="modal" data-target="#varyModal1" data-whatever="@mdo">Search By Date</button>
        <button style="position: absolute; top: 4.5%; right: 1.7%;;" type="button" class="btn mb-2 btn-primary" data-toggle="modal" data-target="#varyModal" data-whatever="@mdo">Search By Date & Staff Name</button>
    </div>
    <hr>
      <div class="col-6">
        <div class="modal fade" id="varyModal" tabindex="-1" role="dialog" aria-labelledby="varyModalLabel" aria-hidden="true">
          <div class="modal-dialog mw-50 w-50" role="document">
            <div class="modal-content">
              <div class="modal-header">
                <h5 class="modal-title" id="varyModalLabel">Search report by Date </h5>
                <button type="button" class="close" data-dismiss="modal" aria-label="Close">
                  <span aria-hidden="true">&times;</span>
                </button>
              </div>
              <div class="modal-body">
                <form  action="{{ route('AdminFindSalaryReport') }}" method="POST" >
                  @csrf
                 <div class="row">
                     <div class="form-group col-md-12">
                          <label for="Company" class="col-form-label">Starting Date:<span style="color: red">*</span></label>
                          <input type="date"  class="form-control" name="Tarehe1" id="Company"  required>
                          <span style="color: red">
                            @error('Company')
                                {{ $message }}
                            @enderror
                        </span>
                        </div>
                </div>
                <div class="row">
                        <div class="form-group col-md-12">
                          <label for="Title" class="col-form-label">Last Date:<span style="color: red">*</span></label>
                          <input type="date" class="form-control" name="Tarehe2" id="Title" required>
                           <span style="color: red">
                            @error('Title')
                                {{ $message }}
                            @enderror
                        </span>
                        </div>
                      </div>
                  <div class="row">
                     <div class="form-group col-md-12">
                          <label for="Company" class="col-form-label">Staff Names:<span style="color: red">*</span></label>
                         <select class="form-control" name="Staff_id" id="">
                            <option value="">Select Staff Name</option>
                           @foreach ($staff as $staff)
                           <option value="{{ $staff->id }}">{{ $staff->Fname }}{{"  "}}{{$staff->Lname}}</option>
                           @endforeach
                          </select>
                        </div>
                </div>
              <div class="modal-footer">
                <button  type="submit" value="upload" class="btn mb-2 btn-primary left">Find Report</button>
              </div>
          </form>
            </div>
          </div>
        </div>
      </div> 
      <div class="col-6">
        <div class="modal fade" id="varyModal1" tabindex="-1" role="dialog" aria-labelledby="varyModalLabel" aria-hidden="true">
          <div class="modal-dialog mw-50 w-50" role="document">
            <div class="modal-content">
              <div class="modal-header">
                <h5 class="modal-title" id="varyModalLabel">Search report by Date </h5>
                <button type="button" class="close" data-dismiss="modal" aria-label="Close">
                  <span aria-hidden="true">&times;</span>
                </button>
              </div>
              <div class="modal-body">
                <form  action="{{ route('AdminFindSalaryReport') }}" method="POST" >
                  @csrf
                 <div class="row">
                     <div class="form-group col-md-12">
                          <label for="StartDate" class="col-form-label">Start Date:<span style="color: red">*</span></label>
                          <input type="date"  class="form-control" name="StartDate" id="StartDate"  required>
                          <span style="color: red">
                            @error('StartDate')
                                {{ $message }}
                            @enderror
                        </span>
                        </div>
                </div>
                <div class="row">
                        <div class="form-group col-md-12">
                          <label for="EndDate" class="col-form-label">Last Date:<span style="color: red">*</span></label>
                          <input type="date" class="form-control" name="EndDate" id="EndDate" required>
                           <span style="color: red">
                            @error('EndDate')
                                {{ $message }}
                            @enderror
                        </span>
                        </div>
                      </div>
                </div>
              <div class="modal-footer">
                <button  type="submit" value="upload" class="btn mb-2 btn-primary left">Find Report</button>
              </div>
          </form>
            </div>
          </div>
        </div>
      </div>
    </div>
 <div class="wrapper wrapper-content animated fadeInRight">
<div class="row">
        <div class="col-lg-12">
                <div class="ibox ">
                    <div class="ibox-title bg-info">
                       <h3 class="card-title">Salary Report Details Table.</h3>
                        <div class="ibox-tools">
                            <a class="collapse-link">
                                <i class="fa fa-chevron-up"></i>
                            </a>
                            <a class="close-link">
                                <i class="fa fa-times"></i>
                            </a>
                        </div>
                    </div>
                    <div class="ibox-content">

                        <div class="table-responsive">
                      <table style="width:100%"class="table table-striped table-bordered table-hover dataTables-example">
                        <thead class="thead-light">
          <tr>
            <th>Date issued</th>
            <th>Payed member</th>
            <th>Payed Role</th>
            <th>Payer</th>
            <th>Amount Payed</th>
          </tr>
        </thead>
        <tbody>
           @foreach ($mishahara as $item)
           <tr>
            <td>{{ $item->SalaryDate }}</td>
            <td>{{ $item->mishahara->Fname }}{{ " " }}{{ $item->mishahara->Lname }}</td>
            <td>{{ $item->mishahara->Role }}</td>
            <td>{{ $item->Fname }}{{ " " }}{{ $item->Lname }}</td>
            <td>{{ number_format($item->Amount,0) }}</td>
          </tr>
           @endforeach
        </tbody>
          <tfoot>
          <tr>
          <th colspan="4" style="background-color:#4a5aec;color:#ffffff">Total Payed Amount:</th>  <th style="background-color:#4a5aec;color:#ffffff">Tsh. {{ number_format($JumlaYaMishahara,0) }}</th>          
          </tr>
          </tfoot>
      </table>
       </div>
    </div>
    </div>
    </div>
    </div>
    </div>  
    @endsection