@extends('admin.layout.master')
@section('home')
    <style>
        label {
            margin-bottom: 1px;
        }

        .form-group {
            margin-bottom: 9px;
        }

        .table-responsive {
            height: calc(100vh - 360px);
        }

        th {
            background: #007bff;
            color: white !important;
            position: sticky;
            top: 0;
            text-align: center;
        }

        table {
            position: relative;
        }

        .table-bordered td, .table-bordered th {
            border: 1px solid #aaabab;
        }

        td {
            text-align: center;
        }

        @media print {
            table.listdb {
                border-collapse: unset;
            }

            table td {
                border: 1px solid #000 !important;
            }
        }
    </style>

    <div class="row">
        <div class="col-lg-12">
            <h4 class="card-title text-center font-weight-bold">Bonus Report</h4>
            <div class="card-box">
                <div class="card-block">
                    <!-- Button trigger modal -->
                    @if (count($errors) > 0)
                        <div class="alert alert-danger">
                            <ul>
                                @foreach ($errors->all() as $error)
                                    <li>{{ $error }}</li>
                                @endforeach
                            </ul>
                        </div>
                    @endif
                    <form action="{{route('bonus.report_search')}}" method="get">
                        <div class='row'>
                            <div class='col-md-3'>
                                <div class="form-group">
                                    <label>Emp Code</label>
                                    <input type="text" class="form-control input-sm" name="emp_code" id="emp_code">
                                </div>
                            </div>
                            <div class='col-md-3'>
                                <div class="form-group">
                                    <label>Department</label>
                                    <select name="emp_department" id="emp_department" class="form-control input-sm">
                                        <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-3'>
                                <div class="form-group">
                                    <label>Designation</label>
                                    <select name="emp_designation" id="emp_designation" class="form-control input-sm">
                                        <option value="0">--Select--</option>
                                        @if(!empty($designation_lists))
                                            @foreach($designation_lists as $design_val)
                                                <option value="{{$design_val->id}}">{{$design_val->name}}</option>
                                            @endforeach
                                        @endif
                                    </select>
                                </div>
                            </div>
                            <div class='col-md-3'>
                                <div class="form-group">
                                    <label>Join Date From </label>
                                    <input type="text" class="datepicker form-control input-sm"
                                           name="join_date_from" id="join_date_from">
                                </div>
                            </div>
                            <div class='col-md-3'>
                                <div class="form-group">
                                    <label>Join Date To</label>
                                    <input type="text" class="datepicker form-control input-sm"
                                           name="join_date_to" id="join_date_to">
                                </div>
                            </div>
                            <div class='col-md-2'>
                                <div class="form-group">
                                    <label>Joining month ></label>
                                    <input type="text" class="form-control input-sm" name="subtract_month_from_bonus_month"
                                           id="subtract_month_from_bonus_month">
                                </div>
                            </div>
                            <div class='col-md-3'>
                                <div class="form-group">
                                    <label>Bonus Type</label>
                                    <select class="form-control input-sm" name=bonus_type_filter id="bonus_type_filter">
                                        <option value="">Select</option>
                                        @foreach($bonus_types as $b_type)
                                            <option value="{{$b_type->id}}">{{$b_type->title}}</option>
                                        @endforeach
                                    </select>
                                </div>
                            </div>
                            <div class='col-md-3'>
                                <div class="form-group">
                                    <label>Print Month</label>
                                    <select class="form-control input-sm" name=print_month id="print_month">
                                        <option value="">Select</option>
                                        <option value="January">January</option>
                                        <option value="February">February</option>
                                        <option value="March">March</option>
                                        <option value="April">April</option>
                                        <option value="May">May</option>
                                        <option value="June">June</option>
                                        <option value="July">July</option>
                                        <option value="August">August</option>
                                        <option value="September">September</option>
                                        <option value="October">October</option>
                                        <option value="November">November</option>
                                        <option value="December">December</option>
                                    </select>
                                </div>
                            </div>
                            <div class='col-md-3 mt-4'>
                                <button class='btn btn-sm w-100 btn-danger'>Search</button>
                            </div>
                        </div>
                    </form>
                </div>
            </div>
            <hr>
            <button class="btn btn-md btn-info text-right" onclick="PrintTable();">Print</button>
            <div class="table-responsive" id="print">
                <table class="table table-bordered table-hover" id="salary_table">
                    <thead>
                    <tr>
                        <td colspan="11"><h4 class="card-title text-center">BCL (Marketing Division)</h4>
                            <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">@if(!empty($_GET['bonus_type_filter']))
                                    @foreach($bonus_types as $b_type)
                                        @if($b_type->id==$_GET['bonus_type_filter'])
                                            {{$b_type->title}}
                                        @endif
                                    @endforeach @endif
                            </h5>
                            <h5 class="text-center">For the Year Of @if(!empty($_GET['print_month'])){{$_GET['print_month']}}-@endif{{date('Y')}}</h5>
                        </td>
                    </tr>
                    <tr>
                        <th>Sl#</th>
                        <th>Name</th>
                        <th>Design</th>
                        <th>Station</th>
                        <th>Joining</th>
                        <th>Basic Salary</th>
                        @if(!empty($_GET['bonus_type_filter']) && $_GET['bonus_type_filter']==1)
                            <th>Leave Day</th>
                            <th>Salary</th>
                        @else
                            @if(!empty($_GET['bonus_type_filter']) && $_GET['bonus_type_filter']==3)
                                <th>Half Bonus</th>
                            @else
                                <th>Full Bonus</th>
                            @endif
                            <th>Bonus</th>
                        @endif
                        <th>Bank</th>
                        <th>NetPayable</th>
                        <!--<th>Remarks</th>-->
                        <th>Signature</th>
                    </tr>
                    </thead>
                    <tbody class="bonus_tbody">
                                        @if(!empty($bonus_info)) @php($i=1)@php($j=1)
                    @foreach($bonus_info as $bonus_val)
                        <tr data-id="{{$i}}">
                            <td>{{$j++}}</td>
                            <td>{{$bonus_val->empBasicInfo->emp_name}}</td>
                            <td>{{$bonus_val->empBasicInfo->fetch_designation->name}}</td>
                            <td class="text-center">{{$bonus_val->empBasicInfo->station_vehicle_no}}</td>
                                                        <td class="text-center">@if(!empty($_GET['bonus_type_filter']) && $_GET['bonus_type_filter']==1 && $emp_job_duration<18)
                                    {{$bonus_val->empBasicInfo->joining_date}}
                                @elseif(!empty($_GET['bonus_type_filter']) && $_GET['bonus_type_filter']==3 && $emp_job_duration<12)
                                    {{$bonus_val->empBasicInfo->joining_date}}
                                @endif
                            </td>
                            <td class="text-right">{{number_format($basic_salary)}}</td>

                            @if(!empty($_GET['bonus_type_filter']) && $_GET['bonus_type_filter']==1)
                                                                <td class="text-center">{{$emp_job_duration}}
                            @else
                               <td class="text-right">
                                   @if(!empty($_GET['bonus_type_filter']) && $_GET['bonus_type_filter']==3)
                                    {{number_format($half_bonus_amount)}}
                                   @endif
                            @endif
                            </td>
                            <td class="text-right">{{number_format($bonus_amount)}}</td>
                            <td class="text-right">{{number_format($bank_amount)}}</td>
                            <td class="text-right">{{number_format($cash_amount)}}</td>
                           <!-- <td class="text-center">&nbsp;</td>-->
                            <td class="text-right">&nbsp;</td>
                            @php($i++)
                        </tr>
                    @endforeach
                    @endif
                    </tbody>
                    @if(!empty($bonus_info))
                        <tr style="font-weight: bold;border-top: 2px solid black">
                            <td colspan="5">Total</td>
                            <td class="text-right">{{number_format($total_basic)}}</td>
                            <td class="text-right">@if(!empty($_GET['bonus_type_filter']) && $_GET['bonus_type_filter']==3){{round($total_half_bonus_amount)}}@else &nbsp; @endif</td>
                            <td class="text-right">{{number_format($total_bonus_amount)}}</td>
                            <td class="text-right">{{number_format($total_bank_amount)}}</td>
                            <td class="text-right">{{number_format($total_cash_amount)}}</td>
                            <!--<td class="text-right">&nbsp;</td>-->
                            <td class="text-right">&nbsp;</td>
                        </tr>
                    @endif
                    <tr>
                        <td colspan="26">                            <div class="col-sm-12 col-xs-12">
                                <div class="row">
                                    <div class="col-sm-2">
                                        <hr style="color: black; border: 1px solid;margin-top: 50px;margin-bottom: 0px;margin-left: 0px">
                                        <span class="sign"
                                              style="margin-left: 0px; font-size: 12px"><b>Officer(Accounts)</b></span>
                                    </div>
                                    <div class="col-sm-2">
                                        <hr style="color: black; border: 1px solid;margin-top: 50px;margin-bottom: 0px;margin-left: 0px">
                                        <span class="sign"
                                              style="margin-left: 0px; font-size: 12px"><b>Asstt Manager(Accounts)</b></span>
                                    </div>
                                    <div class="col-sm-2">
                                        <hr style="color: black; border: 1px solid;margin-top: 50px;margin-bottom: 0px;">
                                        <span style="margin-left: 0px;font-size: 13px"><b>Manager(Accounts)</b></span>
                                    </div>
                                    <div class="col-sm-2">
                                        <hr style="color: black; border: 1px solid;margin-top: 50px;margin-bottom: 0px;">
                                        <span
                                            style="font-size: 13px; margin-left: 0px;"><b>GM(Accounts & Finance)</b></span>
                                    </div>
                                    <div class="col-sm-2">
                                        <hr style="color: black; border: 1px solid;margin-top: 50px;margin-bottom: 0px;">
                                        <span style="margin-left: 0px;font-size: 13px"><b>GM(Marketing)</b></span>
                                    </div>
                                    <div class="col-sm-2">
                                        <hr style="color: black; border: 1px solid;margin-top: 50px;margin-bottom: 0px;">
                                        <span style="margin-left: 0px;font-size: 13px"><b>Managing Director</b></span>
                                    </div>
                                </div>
                            </div>
                        </td>
                    </tr>
                </table>
            </div>
        </div>
    </div>

    <script type="text/javascript">
        function PrintTable() {
            var printWindow = window.open('', '', 'height=200,width=400');
            printWindow.document.write('<html><head><title>Table Contents</title><link href="{{ asset('/') }}assets/css/bootstrap.min.css" rel="stylesheet">');

            //Print the Table CSS.
            var table_style = document.getElementById("salary_table").innerHTML;
            printWindow.document.write('<style>@page{size:landscape;}#print{font-size: 10px !important;}\n' +
                '    .table>tbody>tr>td, .table>tbody>tr>th, .table>tfoot>tr>td, .table>tfoot>tr>th, .table>thead>tr>td, .table>thead>tr>th {\n' +
                '        padding: 1px;\n' +
                '        line-height: 1.428571;\n' +
                '        font-size: 11px !important;\n' +
                '        vertical-align: top;\n' +
                '        border: 1px solid black !important;\n' +
                '    }\n' +
                '    .sign{ width: 30%!important;}' +
                '    .table>thead>tr>th{ text-align: center !important;}' +
                '    .center_id{ text-align: center !important;}' +
                '</style>');
            printWindow.document.write('</head>');

            //Print the DIV contents i.e. the HTML Table.
            printWindow.document.write('<body>');
            var divContents = document.getElementById("print").innerHTML;
            printWindow.document.write(divContents);
            printWindow.document.write('</body>');

            printWindow.document.write('</html>');
            printWindow.document.close();
            printWindow.print();
        }
    </script>

    
    <script src="{{asset('payroll_assets/bonus/bonus.js')}}"></script>
@endsection