@extends('layouts.app')

@section('content')
@section('style')
    <style>
        .custom-control-lg .custom-control-label::before,
        .custom-control-lg .custom-control-label::after {
            top: 0.1rem !important;
            left: -2rem !important;
            width: 1.25rem !important;
            height: 1.25rem !important;
        }

        .custom-control-lg .custom-control-label {
            margin-left: 0.5rem !important;
            font-size: 1rem !important;
        }
        .timepickerStart, .timepickerEnd {
            background-color: white !important;
        }
    </style>
@endsection
<div class="col-12">

</div>
<div class="col-12">
    <div class="card">
        <div class="card-header">
            <h5 class="title ">New DDO</h5>
            <nav aria-label="breadcrumb">
                <ol class="breadcrumb"style="background-color: white; padding-left: 2px">
                    <li class="breadcrumb-item"><a href="{{ route('home') }}">Home</a></li>
                    <li class="breadcrumb-item"><a href="{{ route('deployment') }}">Deployments</a></li>
                    <li class="breadcrumb-item"><a href="{{ route('ddo', [ 'id' =>$did ]) }}">{{ $contract->ddo_number }}</a></li>
                    <li class="breadcrumb-item active" aria-current="page">Report</li>
                </ol>
            </nav>
        </div>
        <div class="card-body all-icons">
            <div style="display:flex; justify-content: space-between;">
                <div class="">
                    <h5 class="mb-0">{{ $ppinfo->start_date }} to {{ $ppinfo->end_date }}</h5>
                    <span>{{ $post->branch_name }}</span>
                </div>
                <div class="text-right">
                    <a href="{{ route('ddo.exportexcel', [ 'id' => $did, 'pp' => $pp ]) }}" class="btn btn-success btn-sm text-white">Export</a>
                    <button class="btn btn-primary btn-sm text-white btnReport" onclick="window.print()">Print</button>
                </div>
            </div>
            <div class="table-responsive">
                <table class="table" >
                    <thead class=" text-primary">
                        <tr>
                            <td>Employee's Name</td>
                            <td>Position</td>
                            <td>Day Shift</td>
                            <td>Night Shift</td>
                            <td>Days of Work</td>
                            <td>Basic Pay</td>
                            <!-- <td>Night Differentia</td>
                            <td>Incentive</td>
                            <td>Uniform Allowance</td>
                            <td>Overtime</td>
                            <td>Other Additional</td> -->
                            <td>Gross Pay</td>
                            <td>Deductions</td>
                            
                            <td colspan="11"></td>
                        </tr>
                        <tr>
                            <td colspan="7"></td>
                            <td>SSS CONT</td>
                            <td>PHIC CONT</td>
                            <td>HDMF CONT</td>

                            <td>UNIFORM</td>
                            <td>LICENSE</td>
                            <td>Insurance</td> 

                            <td>LOAN</td> 

                            <td>CASH BOND</td>
                            <td>CASH ADVANCE</td>
                            <td>OTHER DEDUCTION</td>
                            <td>TOTAL</td>
                            <td>NET PAY</td>
                        </tr>
                    </thead>
                    <tbody>
                        @foreach ($payroll as $record)
                            <tr>
                                <td>{{ $record['personnel'] }} </td>
                                <td>SG</td>
                                <td>{{ $record['day_rate'] }} </td>
                                <td>{{ $record['night_rate'] }} </td>
                                <td>{{ $record['wd'] }} </td>
                                <td>{{ number_format($record['wd_amount'], 2) }} </td>
                                <!-- <td>{{ number_format($record['nightdiff'], 2) }} </td>
                                <td>{{ number_format($record['incentive'], 2) }} </td>
                                <td>{{ number_format($record['uniform'], 2) }} </td>
                                <td>{{ number_format(($record['overtime']), 2) }} </td>
                                <td>{{ number_format(($record['adjustment_addition']), 2) }} </td> -->
                                <td>{{ number_format($record['grosspay'], 2) }} </td>
                                <td>{{ number_format($record['sss'], 2) }} </td>
                                <td>{{ number_format($record['philhealth'], 2) }} </td>
                                <td>{{ number_format($record['pagibig'], 2) }} </td>
                                
                                <td>{{ number_format($record['uniform_deduction'], 2) }} </td>
                                <td>{{ number_format($record['license'], 2) }} </td>
                                <td>{{ number_format($record['insurance'], 2) }} </td>

                                <td>{{ number_format($record['loan'], 2) }} </td>

                                <td>{{ number_format($record['cashbond'], 2) }} </td>
                                <td>{{ number_format($record['cashadvance'], 2) }}</td>
                                <td>{{ number_format($record['adjustment_deduction'], 2) }}</td>
                                <td>{{ number_format($record['totaldeductions'], 2) }}</td>
                                <td>{{ number_format($record['netpay'], 2) }}</td>
                            </tr>
                        @endforeach
                        <tr>
                            <th></th>
                            <th></th>
                            <th>{{ $payroll->sum(['day_rate']) }} </th>
                            <th>{{ $payroll->sum(['night_rate']) }} </th>
                            <th>{{ $payroll->sum(['wd']) }} </th>
                            <th>{{ number_format($payroll->sum(['wd_amount']), 2) }} </th>
                            <!-- <th>{{ number_format($payroll->sum(['nightdiff']), 2) }} </th>
                            <th>{{ number_format($payroll->sum(['incentive']), 2) }} </th>
                            <th>{{ number_format($payroll->sum(['uniform']), 2) }} </th>
                            <th>{{ number_format($payroll->sum(['overtime']), 2) }} </th>
                            <th>{{ number_format($payroll->sum(['adjustment_addition']), 2) }} </th> -->
                            <th>{{ number_format($payroll->sum(['grosspay']), 2) }} </th>
                            <th>{{ number_format($payroll->sum(['sss']), 2) }} </th>
                            <th>{{ number_format($payroll->sum(['philhealth']), 2) }} </th>
                            <th>{{ number_format($payroll->sum(['pagibig']), 2) }} </th>

                            <th>{{ number_format($payroll->sum(['uniform']), 2) }} </th>
                            <th>{{ number_format($payroll->sum(['license']), 2) }} </th>
                            <th>{{ number_format($payroll->sum(['insurance']), 2) }} </th>

                            <th>{{ number_format($payroll->sum(['loan']), 2) }} </th>

                            <th>{{ number_format($payroll->sum(['cashbond']), 2) }} </th>
                            <th>{{ number_format($payroll->sum(['cashadvance']), 2) }} </th>
                            <th>{{ number_format($payroll->sum(['adjustment_deduction']), 2) }} </th>
                            <th>{{ number_format($payroll->sum(['totaldeductions']), 2) }} </th>
                            <th>{{ number_format($payroll->sum(['netpay']), 2) }} </th>
                        </tr>
                    </tbody>
                </table>
            </div>
        </div>
    </div>
</div>

@section('print')
    <div id="print" style="width: 100% !important; font-size: 8px; padding: 3px; color: black !important">
        <div class="row" style="padding-left: 6px">
            <div class="col-12">
                <p class="mb-0"><b>BWPSSI SECURITY AGENCY</b></p>
            </div>
            <div class="col-12">
                <p class="mb-0"><b>(BLACKWATER PHILIPPINES SECURITY SOLUTIONS), INC.</b></p>
            </div>
            <div class="col-12">
                <p class="mb-0"><b>GOMEZ0BURGOS STS., BARANGAY 7, POBLACION, CAGAYAN DE ORO CITY</b></p>
            </div>
            <div class="col-12">
                <p class="mb-0"><b>PAYROLL SHEET</b></p>
            </div>
            <div class="col-12">
                <p class="mb-0"><b>{{ $contract->branch_name  . ', ' . $contract->branch_address }}</b></p>
            </div>
        </div>
        <div class="row" style="width: 100% !important; padding: 5px; margin-left: 1px">

            <table class="table  table-bordered">
                <thead class=" text-primary">

                </thead>
                <tbody>
                    <tr>
                        <th>Employee's Name</th>
                        <th>Position</th>
                        <th>Day Shift</th>
                        <th>Night Shift</th>
                        <th>Days of Work</th>
                        <th>Basic Pay</th>
                        <th>Gross Pay</th>
                        <th>Deductions</th>
                        <th></th>
                        <th></th>
                        <th></th>
                        <th></th>
                        <th></th>
                        <th></th>
                    </tr>
                    <tr>
                        <th></th>
                        <th></th>
                        <th></th>
                        <th></th>
                        <th></th>
                        <th></th>
                        <th></th>
                        <th>SSS CONT</th>
                        <th>PHIC CONT</th>
                        <th>HDMF CONT</th>
                        {{-- <th>SSS LOAN</th>
                        <th>LICENSE</th>
                        <th>HANDBOOK</th> --}}
                        <th>CASH BOND</th>
                        <th>CASH ADVANCE</th>
                        <th>TOTAL</th>
                        <th>NET PAY</th>
                    </tr>
                    @foreach ($payroll as $record)
                        <tr>
                            <td>{{ $record['personnel'] }} </td>
                            <td>SG</td>
                            <td>{{ $record['day_rate'] }} </td>
                            <td>{{ $record['night_rate'] }} </td>
                            <td>{{ $record['wd'] }} </td>
                            <td>{{ number_format($record['wd_amount'], 2) }} </td>
                            <td>{{ number_format($record['grosspay'], 2) }} </td>
                            <td>{{ number_format($record['sss'], 2) }} </td>
                            <td>{{ number_format($record['philhealth'], 2) }} </td>
                            <td>{{ number_format($record['pagibig'], 2) }} </td>
                            {{-- <td>0.00 </td>
                            <td>0.00 </td>
                            <td>0.00 </td> --}}
                            <td>{{ number_format($record['cashbond'], 2) }} </td>
                            <td>{{ number_format($record['cashadvance'], 2) }}</td>
                            <td>{{ number_format($record['totaldeductions'], 2) }}</td>
                            <td>{{ number_format($record['netpay'], 2) }}</td>
                        </tr>
                    @endforeach
                    <tr>
                        <th></th>
                        <th></th>
                        <th>{{ $payroll->sum(['day_rate']) }} </th>
                        <th>{{ $payroll->sum(['night_rate']) }} </th>
                        <th>{{ $payroll->sum(['wd']) }} </th>
                        <th>{{ number_format($payroll->sum(['wd_amount']), 2) }} </th>
                        <th>{{ number_format($payroll->sum(['wd_amount']), 2) }} </th>
                        <th>{{ number_format($payroll->sum(['sss']), 2) }} </th>
                        <th>{{ number_format($payroll->sum(['philhealth']), 2) }} </th>
                        <th>{{ number_format($payroll->sum(['pagibig']), 2) }} </th>
                        <th>{{ number_format($payroll->sum(['cashbond']), 2) }} </th>
                        <th>{{ number_format($payroll->sum(['cashadvance']), 2) }} </th>
                        <th>{{ number_format($payroll->sum(['totaldeductions']), 2) }} </th>
                        <th>{{ number_format($payroll->sum(['netpay']), 2) }} </th>
                    </tr>
                </tbody>
            </table>

        </div>
    </div>
@endsection

@section('script')
    <script>

    </script>

@endsection

@endsection