@extends('hr_main')
@section('title', '| '. $data['pageTitle'] )

@section('stylesheets')
    <style>
        h4 {
            color: #000 !important;
            font-weight: 900;
        }
        hr {
            border: none;
            border-top: 1px solid black;
        }
        p {
            font-size:11px;
        }
        .background_color {
            background-color: rgb(179, 179, 179) !important;
        }
    </style>
@endsection

@section('content')

<div class="row">
    <div class="col-md-1"></div>
    <div class="col-md-10 fullbody">
        <div class="viewTitle"></div>
        <div class="panel panel-default panel-border">
            
            <div class="panel-heading">
                <div class="col-md-12">
                    <div class="pull-right">
                        <i class="fa fa-print btn btn-xs"  onclick="print()"></i>
                    </div>
                </div>
            </div>

            <div class="panel-body" id="print-content">
                <div class="row">
                    <div class="col-md-12 text-center">
                        <span style="font-size:20px; font-weight: bold;">
                            {{ $data['companyName'] }}
                        </span>
                        <p>
                            <span style="font-size:10px;">
                                {{ $data['companyAddress'] }}
                            </span>
                            <br>
                            <span style="text-decoration: underline; font-size:15px;">
                                {{ $data['pageTitle'] }}
                            </span>
                        </p>
                    </div>
                </div>

                <h4>1. Employee Information:</h4>
                @if($data['emp_info'] != null)
                    <table class="table table-bordered table-striped table-condensed table-report">
                        <tr>
                            <td>Employee Name</td>
                            <td>{{ $data['emp_info']->emp_name }}</td>
                    
                            <td>Job Duration</td>
                            <td>{{ $data['emp_info']->emp_job_duration }}</td>
                        </tr>
                    
                        <tr>
                            <td>Employee Id</td>
                            <td>{{ $data['emp_info']->emp_id_no }}</td>
                    
                            <td>Notice Type</td>
                            <td>{{ $data['emp_info']->emp_notice_type }}</td>
                        </tr>
                    
                        <tr>
                            <td>Designation</td>
                            <td>{{ $data['emp_info']->emp_designation }}</td>
                    
                            <td>Released Type</td>
                            <td>{{ $data['emp_info']->emp_released_type }}</td>
                        </tr>
                    
                        <tr>
                            <td>Mobile Number</td>
                            <td>{{ $data['emp_info']->emp_mobile_number }}</td>
                    
                            <td>Released Note</td>
                            <td>{{ $data['emp_info']->released_note }}</td>
                        </tr>
                    
                        <tr>
                            <td>Recruitment Type</td>
                            <td>{{ $data['emp_info']->emp_recruitment_type }}</td>
                    
                            <td>Released Reason</td>
                            <td>{{ $data['emp_info']->released_reason }}</td>
                        </tr>
                    
                        <tr>
                            <td>Branch Name</td>
                            <td>{{ $data['emp_info']->emp_branch_name }}</td>
                    
                            <td>Joining Date</td>
                            <td>{{ $data['emp_info']->emp_joining_date }}</td>
                        </tr>
                    
                        <tr>
                            <td>Area Name</td>
                            <td>{{ $data['emp_info']->emp_area }}</td>
                    
                            <td>Last Working Date</td>
                            <td>{{ $data['emp_info']->emp_last_working_date }}</td>
                        </tr>
                    
                        <tr>
                            <td>Zone Name</td>
                            <td>{{ $data['emp_info']->emp_zone }}</td>
                    
                            <td>{{ $data['emp_info']->emp_released_type }} Effective Date</td>
                            <td>{{ $data['emp_info']->emp_resign_effective_date }}</td>
                        </tr>
                    
                        <tr>
                            <td>Project</td>
                            <td>{{ $data['emp_info']->emp_project }}</td>
                    
                            @if($data['emp_info']->emp_released_type == 'Resign')
                                <td>Resign Date</td>
                                <td>{{ $data['emp_info']->emp_resign_date }}</td>
                            @else 
                                <td></td>
                                <td></td>
                            @endif
                        </tr>
                    
                        {{-- <tr>
                            <td>Project Type</td>
                            <td>{{ $data['emp_info']->emp_project_type }}</td>
                    
                            <td></td>
                            <td></td>
                        </tr> --}}
                    </table>
                @endif

                <h4>2. Employee Payable Information:</h4>
                @if(isset($data['org_facilities_info']->facilities) && count($data['org_facilities_info']->facilities) > 0)
                    <table class="table table-bordered table-striped table-condensed table-report">
                        <tr class='background_color'>
                            <td style='text-align: center'>Particulars</td>
                            <td style='text-align: center'>Own</td>
                            <td style='text-align: center'>Org</td>
                            <td style='text-align: center'>Interest</td>
                            <td style='text-align: center'>Total</td>
                        </tr>
                        <tr>
                            <td style='text-align: left' colspan='5'><b>Payable Amount<b></td>
                        </tr>

                        @foreach($data['org_facilities_info']->facilities as $org_facility)
                            <tr>
                                <td>{{ $org_facility->name }}</td>
                                <td style='text-align: right'>{{ (isset($org_facility->amount_info['own']) && $org_facility->amount_info['own'] != 0) ? number_format($org_facility->amount_info['own'], 2) : '-' }}</td>
                                <td style='text-align: right'>{{ (isset($org_facility->amount_info['org']) && $org_facility->amount_info['org'] != 0) ? number_format($org_facility->amount_info['org'], 2) : '-' }}</td>
                                <td style='text-align: right'>{{ (isset($org_facility->amount_info['interest']) && $org_facility->amount_info['interest'] != 0) ? number_format($org_facility->amount_info['interest'], 2) : '-' }}</td>
                                <td style='text-align: right'>{{ (isset($org_facility->total_amount) && $org_facility->total_amount != 0) ? number_format($org_facility->total_amount, 2) : '-' }}</td>
                            </tr>
                        @endforeach
                            @php    
                                $earned_leave = $due_salary = $termination_amount = $bill_voucher = $payable_other = 0;
                                if(isset($data['getLatestAmountValue']['payable']->earned_leave)) {
                                    $earned_leave = $data['getLatestAmountValue']['payable']->earned_leave;
                                }
                                if(isset($data['getLatestAmountValue']['payable']->due_salary)) {
                                    $due_salary = $data['getLatestAmountValue']['payable']->due_salary;
                                }
                                if(isset($data['getLatestAmountValue']['payable']->termination_amount)) {
                                    $termination_amount = $data['getLatestAmountValue']['payable']->termination_amount;
                                }
                                if(isset($data['getLatestAmountValue']['payable']->bill_voucher)) {
                                    $bill_voucher = $data['getLatestAmountValue']['payable']->bill_voucher;
                                }
                                if(isset($data['getLatestAmountValue']['payable']->payable_other)) {
                                    $payable_other = $data['getLatestAmountValue']['payable']->payable_other;
                                }

                                $ownTotalAmount = $data['org_facilities_info']->ownTotalAmount;
                                $orgTotalAmount = $data['org_facilities_info']->orgTotalAmount;
                                $interestTotalAmount = $data['org_facilities_info']->interestTotalAmount;
                                $payableTotalAmount = $data['org_facilities_info']->grandTotalAmount + $earned_leave + $due_salary + $termination_amount + $bill_voucher + $payable_other;
                            @endphp

                            <tr>
                                <td colspan='4'>Earned Leave</td>
                                <td style='text-align: right'>{{ ($earned_leave != 0) ? number_format($earned_leave, 2) : '-' }}</td>
                            </tr>
                            <tr>
                                <td colspan='4'>Due Salary</td>
                                <td style='text-align: right'>{{ ($due_salary != 0) ? number_format($due_salary, 2) : '-' }}</td>
                            </tr>
                            <tr>
                                <td colspan='4'>Termination Amount</td>
                                <td style='text-align: right'>{{ ($termination_amount != 0) ? number_format($termination_amount, 2) : '-' }}</td>
                            </tr>
                            <tr>
                                <td colspan='4'>Bill/Voucher</td>
                                <td style='text-align: right'>{{ ($bill_voucher != 0) ? number_format($bill_voucher, 2) : '-' }}</td>
                            </tr>
                            <tr>
                                <td colspan='4'>Other Payable</td>
                                <td style='text-align: right'>{{ ($payable_other != 0) ? number_format($payable_other, 2) : '-' }}</td>
                            </tr>
                            <tr class='background_color'>
                                <td style='text-align: center'>Sub-Total</td>
                                <td style='text-align: right'>{{ ($ownTotalAmount != 0) ? number_format($ownTotalAmount, 2) : '-' }}</td>
                                <td style='text-align: right'>{{ ($orgTotalAmount != 0) ? number_format($orgTotalAmount, 2) : '-' }}</td>
                                <td style='text-align: right'>{{ ($interestTotalAmount != 0) ? number_format($interestTotalAmount, 2) : '-' }}</td>
                                <td style='text-align: right'>{{ ($payableTotalAmount != 0) ? number_format($payableTotalAmount, 2) : '-' }}</td>
                            </tr>

                        <tr>
                            <td style='text-align: left' colspan='5'><b>Deduction Amount<b></td>
                        </tr>
                            @php
                                $deductionTotalAmount = 0;
                                if(isset($data['getLatestAmountValue']['deduction']->total_value)) {
                                    $deductionTotalAmount = $data['getLatestAmountValue']['deduction']->total_value;
                                }
                            @endphp
                            <tr>
                                <td colspan='4'>Salary Advanced</td>
                                <td style='text-align: right'>{{ (isset($data['emp_loan_info']['salary_advanced_loan_amount']) && $data['emp_loan_info']['salary_advanced_loan_amount'] != 0) ? number_format($data['emp_loan_info']['salary_advanced_loan_amount'], 2) : '-' }}</td>
                            </tr>
                            <tr>
                                <td colspan='4'>Vehicle Loan</td>
                                <td style='text-align: right'>{{ (isset($data['emp_loan_info']['vehicle_loan_amount']) && $data['emp_loan_info']['vehicle_loan_amount'] != 0) ? number_format($data['emp_loan_info']['vehicle_loan_amount'], 2) : '-' }}</td>
                            </tr>
                            <tr>
                                <td colspan='4'>PF Loan</td>
                                <td style='text-align: right'>{{ (isset($data['emp_loan_info']['pf_loan_amount']) && $data['emp_loan_info']['pf_loan_amount'] != 0) ? number_format($data['emp_loan_info']['pf_loan_amount'], 2) : '-' }}</td>
                            </tr>
                            <tr>
                                <td colspan='4'>Other Advanced</td>
                                <td style='text-align: right'>{{ (isset($data['emp_loan_info']['other_advanced']) && $data['emp_loan_info']['other_advanced'] != 0) ? number_format($data['emp_loan_info']['other_advanced'], 2) : '-' }}</td>
                            </tr>
                            <tr>
                                <td colspan='4'>Wf Contri.</td>
                                <td style='text-align: right'>{{ (isset($data['emp_loan_info']['wf_loan']) && $data['emp_loan_info']['wf_loan'] != 0) ? number_format($data['emp_loan_info']['wf_loan'], 2) : '-' }}</td>
                            </tr>
                            <tr>
                                <td colspan='4'>Other Loan</td>
                                <td style='text-align: right'>{{ (isset($data['getLatestAmountValue']['other_loan']) && $data['getLatestAmountValue']['other_loan'] != 0) ? number_format($data['getLatestAmountValue']['other_loan'], 2) : '-' }}</td>
                            </tr>
                            <tr>
                                <td colspan='4'>Fine</td>
                                <td style='text-align: right'>{{ (isset($data['getLatestAmountValue']['fine_loan']) && $data['getLatestAmountValue']['fine_loan'] != 0) ? number_format($data['getLatestAmountValue']['fine_loan'], 2) : '-' }}</td>
                            </tr>
                            <tr>
                                <td colspan='4'>Information From BM of RO</td>
                                <td style='text-align: right'>{{ (isset($data['getLatestAmountValue']['deduction']->bm_rm) && $data['getLatestAmountValue']['deduction']->bm_rm != 0) ? number_format($data['getLatestAmountValue']['deduction']->bm_rm, 2) : '-' }}</td>
                            </tr>
                            <tr>
                                <td colspan='4'>PFC & Interest</td>
                                <td style='text-align: right'>{{ (isset($data['getLatestAmountValue']['deduction']->provident_fund) && $data['getLatestAmountValue']['deduction']->provident_fund != 0) ? number_format($data['getLatestAmountValue']['deduction']->provident_fund, 2) : '-' }}</td>
                            </tr>
                            <tr>
                                <td colspan='4'>Notice Pay</td>
                                <td style='text-align: right'>{{ (isset($data['getLatestAmountValue']['deduction']->notice_pay) && $data['getLatestAmountValue']['deduction']->notice_pay != 0) ? number_format($data['getLatestAmountValue']['deduction']->notice_pay, 2) : '-' }}</td>
                            </tr>
                            <tr>
                                <td colspan='4'>Excess Consumed Leave</td>
                                <td style='text-align: right'>{{ (isset($data['getLatestAmountValue']['deduction']->excess_consumed_leave) && $data['getLatestAmountValue']['deduction']->excess_consumed_leave != 0) ? number_format($data['getLatestAmountValue']['deduction']->excess_consumed_leave, 2) : '-' }}</td>
                            </tr>
                            <tr>
                                <td colspan='4'>Salary Deduction</td>
                                <td style='text-align: right'>{{ (isset($data['getLatestAmountValue']['deduction']->deduction_salary) && $data['getLatestAmountValue']['deduction']->deduction_salary != 0) ? number_format($data['getLatestAmountValue']['deduction']->deduction_salary, 2) : '-' }}</td>
                            </tr>
                            <tr>
                                <td colspan='4'>Dismissal Deduction</td>
                                <td style='text-align: right'>{{ (isset($data['getLatestAmountValue']['deduction']->dismissal_deduction) && $data['getLatestAmountValue']['deduction']->dismissal_deduction != 0) ? number_format($data['getLatestAmountValue']['deduction']->dismissal_deduction, 2) : '-' }}</td>
                            </tr>
                            <tr>
                                <td colspan='4'>Maternity Leave Salary Return</td>
                                <td style='text-align: right'>{{ (isset($data['getLatestAmountValue']['deduction']->ml_salary_return) && $data['getLatestAmountValue']['deduction']->ml_salary_return != 0) ? number_format($data['getLatestAmountValue']['deduction']->ml_salary_return, 2) : '-' }}</td>
                            </tr>
                            <tr class='background_color'>
                                <td style='text-align: center' colspan='4'>Sub-Total</td>
                                <td style='text-align: right'>{{ ($deductionTotalAmount != 0) ? number_format($deductionTotalAmount, 2) : '-' }}</td>
                            </tr>
                            <tr>
                                <td colspan="5">&nbsp;</td>
                            </tr>
                            @php
                                $grandTotalAmount = $payableTotalAmount - $deductionTotalAmount;
                            @endphp
                            <tr class='background_color'>
                                <td style='text-align: center' colspan='4'>Net Payable (TK)</td>
                                <td style='text-align: right'>{{ ($grandTotalAmount != 0) ? number_format($grandTotalAmount, 2) : '-' }}</td>
                            </tr>
                    </table>
                @endif

                <h4>3. Employee Bank Account Information:</h4>
                @if($data['emp_bank_info'] != null)
                    <table class="table table-bordered table-striped table-condensed table-report">
                        <tr class='background_color'>
                            <td style='text-align: center'>Account Holder Name</td>
                            <td style='text-align: center'>Bank Name</td>
                            <td style='text-align: center'>Branch Name</td>
                            <td style='text-align: center'>Account Number</td>
                            <td style='text-align: center'>Routing Number</td>
                        </tr>
                        <tr>
                            <td style='text-align: center'>{{ (isset($data['emp_info']->emp_name)) ? $data['emp_info']->emp_name : null }}</td>
                            <td style='text-align: center'>{{ $data['emp_bank_info']->bank_name }}</td>
                            <td style='text-align: center'>{{ $data['emp_bank_info']->bank_branch_name }}</td>
                            <td style='text-align: center'>{{ $data['emp_bank_info']->bank_account_no }}</td>
                            <td style='text-align: center'>{{ $data['emp_bank_info']->bank_routing_number }}</td>
                        </tr>
                    </table>
                @endif

                <div class="report-footer signature" style="display:flex; align-items: center; justify-content: space-between;">
                    <div>
                        <p style="margin-bottom: 40px;"></p>
                        <p style="margin-top: -7px;"></p>
                    </div> 
                    <div>
                        <hr>
                        <p style="margin-top: -7px;">Received Sign</p>
                    </div>   
                </div>

            </div>
            
        </div>
        
    </div>
    
    <div class="col-md-1"></div>
</div>

@endsection

@section('footerAssets')
<script>
    function print() {
        "use strict"; 
        var mainContents = document.getElementById("print-content").innerHTML ;   
        var win = window.open('','printwindow');
        var printStyle = `@include('hr.finalPayment.summarySheet.printStyle')`;
        var printContent = '<div>' + printStyle + mainContents +'</div>';
        win.document.write(printContent);
        win.print();
        win.close();
    }
</script>
@endsection