@extends('admin.layout')

@section('content')

    <div class="wrapper-md">
        <div class="panel panel-default">
            <div class="panel-heading">
                <div class="row">
                    <div class="col-md-10">
                        <p class="m-n font-thin h3">Report(Salary)</p>
                    </div>
                    <div class="col-md-2 text-right">

                    </div>
                </div>
            </div>


                <div class="panel-body">
                <div class="card">
                    <div class="card-body">

                  <form method="GET" action="{{ url('/report-salary') }}" accept-charset="UTF-8" autocomplete="off" class="form-inline my-2 my-lg-0 float-right" role="search">
                      <div class="input-group">
                          <label>Invoice No.</label>
                          <input type="text" class="form-control" name="invoice"  value="{{ request('invoice') }}">
                      </div>

                      <div class="input-group"> <label>Month</label>
                          <select name="payment_month" id="payment_month" class="form-control"  >
                              <option value="">--Select Month--</option>
                              @foreach($months as $key=>$month )
                                  <option value="{{$month}}"  {{ (request('payment_month')== $month)?'selected="selected"':''  }}>{{$month}}</option>
                              @endforeach
                          </select>
                      </div>

                      <div class="input-group"> <label>Year</label>
                          <select name="payment_year" id="payment_year" class="form-control"  >
                              <option value="">--Select Year-- </option>
                              @for($year=2021; $year<=(date('Y')+5); $year++)
                                  <option value="{{$year}}"  {{ (request('payment_year')== $year)?'selected="selected"':''  }}>{{$year}}</option>
                              @endfor
                          </select>
                      </div>

                            <div class="input-group">
                                <label>Search By Employee</label>
                                <select class="form-control selectpicker" name="searchEmployee[]" multiple  data-selected-text-format="count"  data-size="5" data-actions-box="true"  data-live-search="true"  >
                                    <option value="">--Search By Employee--</option>
                                    @foreach($employees as $key=>$item)
                                        <option value="{{$item->id}}" @if(  @in_array($item->id, request('searchEmployee'))) selected @endif  >{{$item->profile->name ?? ''}}({{$item->id_card ?? ''}} )</option>
                                    @endforeach


                                </select>

                            </div>




                      <div class="input-group pt-4"><br>
                                    <button class="btn btn-secondary" type="subnit" id="searchBtn">
                                        <i class="fa fa-search"></i> Search
                                    </button>
                      </div>
                        </form>

                        <br/>
                        <br/>
                        <div class="table-responsive">
                            <table class="table table-bordered table-primary   dataTable table-hover">
                                <thead>
                                    <tr>
                                        <th>Date</th><th>Invoice</th>  <th>Name</th>  <th>Designation</th> <th>Month</th>   <th>Year</th>     <th>Sub Total</th>   <th>Leave Fine</th>      <th class="text-right">Salary Amount</th> <th>Status</th>
                                    </tr>
                                </thead>
                                <tbody>
                                @php $total =0; @endphp
                                @foreach($result as $item)
                                    <tr>
                                        <td>{{ !empty($item->created_at)? date('d/m/Y',  strtotime($item->created_at)) : '' }}</td>
                                        <td>{{ $item->invoice_id ?? '' }}</td>
                                        <td>{{ $item->name ?? '' }}</td>
                                        <td>{{ $item->position ?? '' }}</td>
                                        <td>{{ $item->month ?? '' }}</td>
                                        <td>{{ $item->year ?? '' }}</td>
                                        <td>{{ $item->sub_total ?? '' }}</td>
                                        <td>{{ $item->leave_fine ?? '' }}</td>
                                        <td>{{ $item->total_amount ?? '' }} @php $total =  $item->total_amount + $total @endphp</td>
                                        <td>{{ $item->status ?? '' }}</td>
                                    </tr>
                                @endforeach
                                </tbody>
                                <tfoot>
                                <tr>
                                    <td class="text-right" colspan="8">Total</td>

                                    <td class="text-left" colspan="2">{{ $total ?? 0 }} </td>
                                </tr>
                                </tfoot>
                            </table>

                        </div>

                    </div>
                </div>
            </div>
        </div>
    </div>





    <script src="https://cdnjs.cloudflare.com/ajax/libs/jszip/3.1.3/jszip.min.js"></script>

    <script src="https://cdn.datatables.net/buttons/1.5.6/js/buttons.html5.min.js"></script>

    <script src="https://cdn.datatables.net/buttons/1.5.6/js/buttons.print.min.js"></script>
    <script src=" https://cdn.datatables.net/buttons/1.5.6/js/buttons.colVis.min.js"></script>


    <link rel="stylesheet" href="//cdn.datatables.net/1.10.16/css/jquery.dataTables.min.css">
    <script src="//cdn.datatables.net/1.10.16/js/jquery.dataTables.min.js"></script>
    <style>
    .dataTables_wrapper .dataTables_paginate .paginate_button{
    padding: 0 !important;
    }
    </style>

    <link rel="stylesheet" href="https://cdn.datatables.net/buttons/1.4.1/css/buttons.dataTables.min.css">
    <script type="text/javascript" language="javascript" src="https://cdn.datatables.net/buttons/1.4.1/js/dataTables.buttons.min.js"></script>
    <script type="text/javascript" language="javascript" src="https://cdn.datatables.net/buttons/1.4.1/js/buttons.flash.min.js"></script>
    <script type="text/javascript" language="javascript" src="https://cdn.datatables.net/buttons/1.4.1/js/buttons.html5.min.js"></script>
    <script type="text/javascript" language="javascript" src="https://cdn.datatables.net/buttons/1.4.1/js/buttons.print.min.js"></script>

    <script type="text/javascript">
        $(document).ready(function () {


            ////////////////////////////////////////////////////////////////////////////////////////
            $(".dataTable3").dataTable();
            $('.dataTable').dataTable({
                "bPaginate": true,
                "bLengthChange": false,
                "bFilter": true,
                "bSort": false,
                "bInfo": true,
                "bAutoWidth": false,
                dom: 'Bfrtip',
                select: true,
                fixedHeader: true,
                colReorder: true,
                "scrollY": 500,
                buttons: [
                    'csv','pdf', 'excel', 'print'
                ],
                "lengthMenu": [[ 10, 25, 50,100, -1], [ 10, 25, 50,100, "All"]],


                "bPaginate": true,
                "sPaginationType": "full_numbers",

            });
        });
    </script>
@endsection