@extends('admin.layout.master')
@section('content')
<style>
    
</style>
<style>
  
    @media print{
            @page{
                size: A4 portrait;
                /* size: legal landscape; */
              
            }
            body {
                zoom:50%; /*or whatever percentage you need, play around with this number*/
                font-family: serif;
                font-size:17px;
                font-weight: bold;
                background-color: #FFFFFF !important;
            }

        }
 </style>
    <div class="row">
        <div class="col-xs-12">
            <h4 class="page-title"></h4>
        </div>
    </div>
    <div class="row">
        <div class="col-lg-12">
            <div class="card">
                <div class="card-header" style="padding: 0 10px">
                    <div class='row'>
                        <div class='col-md-10 text-left' pt-2>
                            <h3>Advance Report</h3>
                        </div>
                        @if(count($advance_salaries) >0)
                        <div class='col-md-1 text-right'>
                          
                            <div class="form-group">
                                <button type="button" class="btn btn-sm btn-info text-right" onclick="PrintDiv();">Print</button>
                            </div>
                         
                        </div>
                        <div class='col-md-1 text-right'>
                           
                            @include('payroll.includes.printAndExcel')
                           
                        </div>
                        @endif

                    </div>
                </div>
                <div class="card-body">
                   
                    <form action="{{route('payroll.payroll.manage_loan.advance_report')}}" method="get">
                        <input type="hidden" name="search" value="true">

                     <div class='row'>
                        <div class='col-2'>
                            <div class="form-group">

                                <label>Employee Name/Code</label>
                                <select class="form-control input-sm name_code_live_search" name="emp_id" id="emp_id">
                                </select>
                              
                            </div>
                        </div>
                        <div class='col-md-3'>
                            <div class="form-group">
                                <label>Department</label>
                                <select name="emp_department" id="emp_department" class="form-control select_2">
                                    <option value="0">--Select--</option>
                                    @if(!empty($department_lists))
                                        @foreach($department_lists as $depart_val)
                                            <option value="{{$depart_val->id}}">{{$depart_val->name}}</option>
                                        @endforeach
                                    @endif
                                </select>
                            </div>
                        </div>
                   
                        <div class='col-md-2'>
                            <div class="form-group">
                                <label>Year</label>
                                <select class="form-control input-sm" name=year id="year" required>
                                    <option value="">Select Year</option>
                                        <option value="2020">2020</option>
                                        <option value="2021">2021</option>
                                        <option value="2022">2022</option>
                                        <option value="2023">2023</option>
                                        <option value="2024">2024</option>
                                        <option value="2025">2025</option>
                                </select>
                            </div>
                        </div>

                        <div class='col-md-2'>
                            <div class="form-group">
                                <label>Print Month</label>
                                <input type="text" class="datepicker form-control input-sm" name="print_month" id="print_month">

                            </div>
                        </div>
                      
                        <div class='col-md-1 mt-4'>
                            <button class='btn btn-sm w-100 btn-danger'>Search</button>
                        </div>
                    </div>
                    </form>
                    </div>
                </div>
            </div>
        </div>
       
    @if(count($advance_salaries) >0)
     <div id="divTableDataHolder" class="table2excel">
            <div class="row" >
                <div class="col-lg-12">
                    <div class="card">
                        <div class="card-body" style="padding: 0 ">
                                <div class=" row m-3">
                                    <table class="table table-stripped table-bordered" style="width:100%">
                                        <tr>
                                            <th colspan="15" class="text-center">
                                                <h4 class="card-title text-center m-0">{{store_info()->name_eng}}</h4>
                                                <span id="heading_name" style="display: none">Advance Report</span>
                                                <h5 class="text-center">@if(!empty($_GET['emp_department']))
                                                        {{\App\Models\Payroll\Settings\PayDepartments::find($_GET['emp_department'])->name}}@endif</h5>
                                                <h5 class="card-title text-center" >Adance For The Year Of
                                                            @if($print_month)
                                                            {{ carbon()->parse($print_month)->format("F-Y")}} 
                                                            @else
                                                            {{request()->get('year')}}
                                                            @endif
                                                </h5>
                                            </th>
                                        </tr>
                                       
                                    </table>
                                 </div>
                        
                            <div class="col-lg-12 col-md-12 col-sm-12 " style="">
                                <table class="table table-stripped table-bordered text-center" style="width:100%">
                                    <thead>
                                       
                                        <tr>
                                            <th>Sl#</th>
                                            <th>Name</th>
                                            <th>Design</th>
                                            <th>Station</th>
                                            <th>Basic Salary</th>
                                            <th>Amount</th>
                                            <th style="width:20%">Note</th>
                                            <th>Signature</th>
                                        </tr>
                                        </thead>
                                        <tbody id="tbody_data">
                                            @php
                                               $total_advance_amount = 0;$total_basic = 0;
                                               $i=1;
                                               $j=1;
                                            @endphp
                                           
                                            @foreach($advance_salaries as $advance_salary)
                                            {{-- @dd($advance_salary) --}}
                                            @php
                                                $basic_salary = $advance_salary->empinfo ? $advance_salary->empinfo->basic_salary : null;
                                                $total_basic += $basic_salary; 
                                                $advance_amount = $advance_salary->amount;
                                                $total_advance_amount += $advance_amount;
                                            @endphp
                                      
                                                <tr data-id="{{$i}}">
                                                    <td>{{$j++}}</td>
                                                    <td class="text-left">{{$advance_salary->empinfo->emp_name}}</td>
                                                    <td class="text-left">{{$advance_salary->empinfo->fetch_designation->name}}</td>
                                                    <td class="text-center">{{$advance_salary->empinfo->station_vehicle_no}}</td>
                                                    {{-- <td class="text-center">{{calculate_employee_job_duration($advance_salary->empinfo->joining_date,date("Y-m-d"))}}</td> --}}
                        
                                                    <td class="text-right">
                                                        {{number_format($basic_salary)}}
                                                    </td>
                                                  
                                                    <td class="text-right">
                                                   
                                                     {{number_format($advance_amount)}}</td>
                                                    <td class="text-left">{{$advance_salary->note}}</td>
                                                    <td class="text-right">&nbsp;</td>
                                                    @php($i++)
                                                </tr>
                                            @endforeach
                                            @if(!empty($bonus_info))
                                            <tr style="font-weight: bold;border-top: 2px solid black">
                                                <td colspan="4">Total</td>
                                                <td class="text-right">{{number_format($total_basic)}}</td>
                                                <td class="text-right">{{number_format($total_advance_amount)}}</td>
                                                <td class="text-right">&nbsp;</td>
                                                <td class="text-right">&nbsp;</td>
                                            </tr>
                                         @endif
                                        <tr>
                                            <td colspan="15">                                            
                                            @include('payroll.signature')
                                            </td>
                                        </tr> 
                                        </tbody>  
                                       
                                </table>
                                
                            </div>                         
                           
                        </div>
                     </div>
                    </div>
                </div>
             
     </div>
     @else
     
     @if(request()->get('search') !=null)
     <div class="row">
        <div class="col-lg-12">
            <div class="card">
                <div class="card-body">
                    <h4 class="text-center"> No Data Found</h4>
                </div>
           </div>
        </div>
    </div>
    @endif
     @endif

@endsection


@section('script')
    <script src="{{ asset('payroll_assets/payroll_common.js') }}"></script>
    <script src="{{ asset('payroll_assets/payroll_print.js') }}"></script>

    <script>
   
        $('.select_2').select2();
        
    </script>
    
@endsection