@extends('layouts.argon')


@section('content')

    <style>
      .containerpopup {
        height: auto;
        overflow: hidden;
      }
      .right {
            color: white;
         width: 200px;
            float: right;
            background: #0f6938;
      }
      
      .start{
           color: white;
         width: 10px;
            float: right;
            background: #0f6938;
      }
       .rightmid {
           color: white;
        width: 200px;
        float: right;
         background: #0f6938;
      }
      
      .left {
          color: white;
         background: #0f6938;
        width: auto;
        overflow: hidden;
      }
    </style>
  <main class="main-content  mt-0">
    <div class="page-header align-items-start pt-5 pb-8 m-3 border-radius-lg">
     
    </div>
    <div class="container">
      <div class="row mt-lg-n10 mt-md-n11 mt-n10 justify-content-center">
        <div class="col-xl-12 col-lg-5 col-md-7 mx-auto">
          <div class="card z-index-0">
            <div class="card-header text-center pt-4">
              <h5>Search leave record here!</h5>
            </div>
            
            <div class="card-body">
              <form role="form" method="POST" action="{{ route('searchattendence') }}">
              @csrf
                <table class="table align-items-center mb-0">
                    <tr>
                                    <td>
                                              <select name="department" class="form-select" id="department" data-search="on">
                                                                <option value="select" selected disabled hidden>Select Department</option>
                                                                <option value="all">All</option>
                                                                @foreach ($Odep as $odeps)
                                                                <option value="{{ $odeps->id   }}">{{ $odeps->name  }}</option>
                                                                @endforeach
                                                            </select>
                                    </td>  
                                    
                                    
                                    <td>
                                  
                                                
                                            <select name="member" class="select2 form-select" id="member" data-search="on">
                                                                <option value="select" selected disabled hidden>Select Member</option>
                                                                @foreach ($members as $user)
                                                                @php
                                                                        $getdep = DB::table('departments')->where('id', $user->department_id)->first();
                                                                @endphp
                                                                <option value="{{ $user->id   }}">{{ Str::of($user->name)->limit(110)->upper() }} ({{$user->jobtitle}}) - @if(isset($getdep->name)) {{$getdep->name}} @endif</option>
                                                                @endforeach
                                                </select>
                                                
                                                
                                                
                                    </td>            
                                                
                                                
                                                            
                        <td>
                        <input type="date" value="{{ date("Y-m-d", strtotime('-1 year')) }}" name="leavefrom" class="form-control" onfocus="this.showPicker()">
                      </td>
                       <td>
                        <input type="date" value="{{ date("Y-m-d") }}" name="leavetill" class="form-control" onfocus="this.showPicker()">
                      </td>
            
                                    <td>    
                                            <button type="submit" class="btn bg-gradient-dark w-100 my-2 mb-2">Search</button>
                                    </td>
                  <td>
                </table>
              </form>
            </div>
          </div>
        </div>
      </div>
    </div>
  </main>
  
  
  
  
  
  <br>  
  
  
  
  
  
  
  
  
  
  
<main class="main-content  mt-0">
<div class="container">
<div class="row">
        <div class="col-12">
          <div class="card mb-4">
            <div class="card-header pb-0">
              <h6>Leave Recod</h6>
            </div>
            
            
            
            
           


            <div class="card-body px-0 pt-0 pb-2">
              <div class="table-responsive p-0">
                <table class="table align-items-center mb-0">
                  <thead>
                    <tr>
                      <th class="text-uppercase text-secondary text-xxs font-weight-bolder opacity-7">Name</th>
                      <th class="text-center text-uppercase text-secondary text-xxs font-weight-bolder opacity-7">Leave Period</th>
                      <th class="text-center text-uppercase text-secondary text-xxs font-weight-bolder opacity-7">Type of leave</th>
                      <th class="text-center text-uppercase text-secondary text-xxs font-weight-bolder opacity-7">Attachment</th>
                      <th class="text-center text-uppercase text-secondary text-xxs font-weight-bolder opacity-7">Allow Leaves</th>
                      <th class="text-center text-uppercase text-secondary text-xxs font-weight-bolder opacity-7">Awail Leaves</th>
                      <th class="text-center text-uppercase text-secondary text-xxs font-weight-bolder opacity-7">Left Leaves</th>
                 
                     
                      <th class="text-secondary opacity-7"></th>
                    </tr>
                  </thead>
                  <tbody>



                  @foreach ($leaverecords as $deps)
                    <tr>
                      
                   
                      <td>
                        <div class="d-flex px-2 py-1">
                        
                          <div class="d-flex flex-column justify-content-center">
                                <h6 data-bs-toggle="modal" data-bs-target="#exampleModal{{ $deps->id }}" class="mb-0 text-sm" style="cursor: pointer;">{{ $deps->username }}</h6>
                                @php
                                    $getdep = DB::table('odepartments')->where('id', $deps->depid)->first();
                                @endphp
                            @if(isset($getdep->name))
                            <p class="text-xs text-secondary mb-0">{{ $getdep->name }}</p>
                            @endif
                          </div>
                        </div>
                      </td>
                      
                     
                      
                  
                      <td class="align-middle text-center">
                        @if($deps->date_start == $deps->date_end)
                        <span class="text-secondary text-xs font-weight-bold">{{ \Carbon\Carbon::parse($deps->date_start)->format('j F, Y') }}</span>
                        @else
                        <span class="text-secondary text-xs font-weight-bold">{{ \Carbon\Carbon::parse($deps->date_start)->format('j F, Y') }}</span> <br>to</br>
                        <span class="text-secondary text-xs font-weight-bold">{{ \Carbon\Carbon::parse($deps->date_end)->format('j F, Y') }}</span>
                        @endif
                        
                      </td>
                      
                     
                   
                   
                    <td class="align-middle text-center">
    
                        <span class="text-secondary text-xs font-weight-bold">{{ $deps->leave_type }}</span>
                      </td>
                      
                      <td class="align-middle text-center">
                        @if(isset($deps->file_path))
                        
                        @if(Str::contains($deps->file_path, ['docx']))
                       <p class="mb-0 text-sm"><a href="http://docs.google.com/gview?url=https://efile.pakmultiservices.com/storage/{{ $deps->file_path }}" target="_blank">View</a></p>
                       @else
                        <p class="mb-0 text-sm"><a href="https://efile.pakmultiservices.com/storage/{{ $deps->file_path }}" target="_blank">View</a></p>
                       @endif
                       @endif
                      </td>
                      
                      
                       <td class="align-middle text-center">
                            @php
                            $getuser = DB::table('users')->where('id', $deps->userid)->first();
                            @endphp
                             @if(isset($getuser->allowleaves))
                            <span class="badge badge-sm bg-gradient-info">{{ $getuser->allowleaves }}</span>
                            @endif
                      
                      </td>
                      <td class="align-middle text-center">
                            @php
                            $getsum = DB::table('leave_records')->where('userid', $deps->userid)->sum('dayscount');
                            @endphp
                            <span class="badge badge-sm bg-gradient-success">{{ $getsum }}</span>
                      
                      </td>
                      <td class="align-middle text-center">
                          @if(isset($getuser->allowleaves))
                            <span class="badge badge-sm bg-gradient-warning">{{ $getuser->allowleaves - $getsum }}</span>
                            @endif
                      
                      </td>
                      
                    
                      
                    </tr>

              
              
              






<div class="modal fade" id="exampleModal{{ $deps->id }}" tabindex="-1" aria-labelledby="exampleModalLabel" aria-hidden="true">
 

  <div class="modal-dialog">
    <div class="modal-content">
      <div class="modal-header">
          @php
                    $getleaves =  DB::table('leave_records')->where('userid' , $deps->userid)->get();
                     $getname =  DB::table('leave_records')->where('userid' , $deps->userid)->first();
            @endphp
        <h5 class="modal-title" id="exampleModalLabel">Leave record of: {{ $getname->username }}</h5>
        <button type="button" class="close" data-bs-dismiss="modal" aria-label="Close">&times;</button>
      </div>


      <div class="modal-body">
   
                    
                <div class="left badge badge-sm bg-gradient-success" style="background: black;">Sr#</div>
                <div class="left badge badge-sm bg-gradient-info" style="background: black;">Leave dates</div>
                <div class="right badge badge-sm bg-gradient-info" style="background: black;">Attachments</div>
                <div class="rightmid badge badge-sm bg-gradient-info" style="background: black;">Reason of leave</div>  
                
              @php
            $i = 1;
            @endphp  
            @foreach ($getleaves as $getus)    
            
           
            
                <div class="containerpopup">
                    
                <div class="left badge badge-sm bg-gradient-success">@php echo $i;  @endphp</div>
                @if($getus->date_start == $getus->date_end)
                 <div class="left badge badge-sm bg-gradient-info" style="margin-left: 16px;">{{ \Carbon\Carbon::parse($getus->date_start)->format('j F, Y') }}</div>
                
                @else
                 <div class="left badge badge-sm bg-gradient-info" style="margin-left: 16px;">{{ \Carbon\Carbon::parse($getus->date_start)->format('j F, Y') }} - {{ \Carbon\Carbon::parse($getus->date_end)->format('j F, Y') }}</div>
                 @endif
                   
                   
                @if(isset($getus->file_path))
                @if(Str::contains($getus->file_path, ['docx']))
                <div class="right badge badge-sm bg-gradient-info"><a href="http://docs.google.com/gview?url=https://efile.pakmultiservices.com/storage/{{ $getus->file_path }}" target="_blank" style="color: white;">View</a></div>
                @else
                <div class="right badge badge-sm bg-gradient-info"><a href="https://efile.pakmultiservices.com/storage/{{ $getus->file_path }}" target="_blank" style="color: white;">View</a></div>
                @endif
                
                @else
                <div class="right badge badge-sm bg-gradient-info">No document found</div>
                @endif
                      
                <div class="rightmid badge badge-sm bg-gradient-info">{{ $getus->leave_type }}</div>        
                        
            @php
            $i++;
            @endphp          
            @endforeach 
                
                
                
                
                
            </div>




      </div>
      <div class="modal-footer">
        <button type="button" class="btn btn-secondary" data-bs-dismiss="modal">Close</button>
      </div>



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




            @endforeach
                 







                   
               
                  </tbody>
                </table>
              </div>
            </div>
          </div>
        </div>
      </div>
</div>
</main>












<!-------Model In Lopp------>






  @endsection