@include('admin.layouts.header')
@include('admin.layouts.sidebar')
<style>
    .font-weight{
        font-weight: 600;
    }
    .panel-title .badge {
        float: right;
    }
    .panel-heading:hover {
        background-color: #e9ecef;
    }
</style>
<div class="m-grid__item m-grid__item--fluid m-wrapper">
    <!-- BEGIN: Subheader -->
    <div class="m-subheader ">
        <div class="d-flex align-items-center">
            <div class="mr-auto">
                <h3 class="m-subheader__title m-subheader__title--separator">
                    {!! $application->name !!} Score Card
                </h3>

                <ul class="m-subheader__breadcrumbs m-nav m-nav--inline">
                    <li class="m-nav__item m-nav__item--home">
                        <a href="{{ asset('/') }}" class="m-nav__link m-nav__link--icon">
                            <i class="m-nav__link-icon la la-home"></i>
                        </a>
                    </li>
                    <li class="m-nav__separator">
                        -
                    </li>
                    <li class="m-nav__item">
                        <a href="/admin/consumer-applications" class="m-nav__link">
                            <span class="m-nav__link-text">
                                 ScoreCard
                            </span>
                        </a>
                    </li>
                </ul>
            </div>
        </div>
    </div>
    <!-- END: Subheader -->
    <div class="m-content">
        @if($errors->any()) @foreach($errors->all() as $key => $error)
            <div class="alert alert-danger alert-dismissible fade show" role="alert">
                <button type="button" class="close" data-dismiss="alert" aria-label="Close"></button>
                {{$error}}
            </div>
        @endforeach @endif

        @if(Session::has('success'))
            <div class="alert alert-success alert-dismissible fade show" role="alert">
                <button type="button" class="close" data-dismiss="alert" aria-label="Close"></button>
                {{ Session::get('success') }}
            </div>
        @endif
        @if(Session::has('error'))
            <div class="alert alert-danger alert-dismissible fade show" role="alert">
                <button type="button" class="close" data-dismiss="alert" aria-label="Close"></button>
                {{ Session::get('error') }}
            </div>
        @endif

        <?php setlocale(LC_MONETARY, 'en_IN.UTF-8'); ?>
        <div class="m-portlet m-portlet--mobile">
            <div class="m-portlet__head">
                <div class="m-portlet__head-caption" style="position:relative;">
                    <div class="m-portlet__head-title">
                        <span class="m-portlet__head-icon">
                            <i class="flaticon-add"></i>
                        </span>
                        <h3 class="m-portlet__head-text">
                            Score Card
                        </h3>
                    </div>
                    @if(isset($fraud_report) && $fraud_report)
                        <div style="right: 1px;top: 18px;position: absolute;">
                            <?php $_file = \App\ConsumerApplicationFiles::where('consumer_application_id', $application->id)->where('file_type','like','%fraud_report_%')->orderBy('created_at','desc')->first(['file_path']); ?>
                            @if(isset($_file->file_path))
                             <div class="btn btn-primary"><a style="color: white;text-decoration: none;" href="/admin/consumer-application/get-documents/{!! $_file->file_path !!}">Download Fraud Report</a></div>
                            @endif
                            <div style="right: -25px;top: 8px;position: absolute;background-color: #d83232;width: 21px;border-radius: 12px;height: 21px;border-style: solid;border-width: 2px;border-color: #921717;"></div>
                        </div>
                    @endif
                </div>
            </div>
            <div>
                <div class="row">
                    <div class="col-md-4" style="background-color: #f2f3f8;padding-top: 5px;">
                        <div class="panel panel-warning" style="padding: 9px;background-color: white;">
                            <div class="panel-heading"><h5>General</h5></div>
                            <div class="panel-body">
                                <table class="table">
                                    <tr>
                                        <th>Name</th>
                                        <td>{!! $application->name !!}</td>
                                    </tr>
                                    <tr>
                                        <th>Score</th>
                                        <td>{!! $score !!}<p>@if(isset($manual_applicant_creditscore)){!! $manual_applicant_creditscore !!} (Manual)@endif</p>
                                        </td>
                                    </tr>
                                    <tr>
                                        <th>Purpose</th>
                                        <td>
                                            <?php
                                            if(isset($application->category->id) && $application->category->id == 24){
                                                switch ($application->application_element->type_of_customer){
                                                    case 1:
                                                        echo 'Residential';
                                                        break;
                                                    case 2:
                                                        echo 'Rural C&I MSME ( Attachakki, Oil Expeller etc)';
                                                        break;
                                                    case 3:
                                                        echo 'Urban C&I MSME (Factories, Hospitals, Hotels, Offices, etc)';
                                                        break;
                                                    case 4:
                                                        echo 'Housing Society';
                                                        break;
                                                    case 5:
                                                        echo 'Schools & Universities';
                                                        break;
                                                }
                                            }else{
                                                echo '-';
                                            }
                                            ?>
                                        </td>
                                    </tr>
                                    <tr>
                                        <th># Enq L12M</th>
                                        <td>{!! $enquiryPast12 !!}</td>
                                    </tr>
                                    <tr>
                                        <th>Co-Applicant Name</th>
                                        @if(isset($auto_co_applicant_name))
                                        <td>{!! $auto_co_applicant_name !!}</td>
                                        @else
                                        <td><i class="text-muted">--missing--</i></td>
                                        @endif
                                    </tr>
                                    <tr>
                                        <th>Co-Applicant Score</th>
                                        @if(isset($auto_creditscore))
                                        <td>{!! $auto_creditscore->Score !!}<p>@if(isset($manual_co_applicant_creditscore)){!! $manual_co_applicant_creditscore !!} (Manual)@endif</p></td>
                                        @else
                                        <td>0<p>@if(isset($manual_co_applicant_creditscore)){!! $manual_co_applicant_creditscore !!} (Manual)@endif</p></td>
                                        @endif
                                    </tr>
                                    <!-- <tr>
                                        <th># Enq L12M</th>
                                        <td>{!! $enquiryPast12 !!}</td>
                                    </tr> -->
                                </table>
                            </div>
                        </div>
                    </div>
                    <div class="col-md-4" style="background-color: #f2f3f8;padding-top: 5px;">
                        <div class="panel panel-warning" style="padding: 9px;background-color: white;">
                            <div class="panel-heading"><h5>FOIR</h5></div>
                            <div class="panel-body">
                                <table class="table">
                                    <tr>
                                        <th>Monthly Income</th>
                                        <td style="font-family: sans-serif;">&#8377;{!! money_format('%!i',$monthly_income) !!}</td>
                                    </tr>
                                    <tr>
                                        <th>FOIR</th>
                                        <td>{!! $foir !!}%</td>
                                    </tr>
                                    <tr>
                                        <th>ResidualFOIR</th>
                                        <td>{!! $ResidualFOIR !!}%</td>
                                    </tr>
                                    <tr>
                                        <th>Max Eligible (Loan Amount)</th>
                                        <td style="font-family: sans-serif;">&#8377;{!! money_format('%!i',$max_eligible) !!}</td>
                                    </tr>
                                    <tr>
                                        <th>Max EMI serviced in last 36 months (A)</th>
                                        <td style="font-family: sans-serif;">&#8377;{!! money_format('%!i',$max_emi_serviced) !!}</td>
                                    </tr>
                                    <tr>
                                        <th>Current EMI amount (B)</th>
                                        <td style="font-family: sans-serif;">&#8377;{!! money_format('%!i',$current_emi_sum) !!}</td>
                                    </tr>
                                    <tr>
                                        <th>Eligibility Amount [(A-B)*50/100]</th>
                                        <td style="font-family: sans-serif;">&#8377;{!! money_format('%!i',(($max_emi_serviced - $current_emi_sum) * 50 / 100)) !!}</td>
                                    </tr>
                                </table>
                            </div>
                        </div>
                    </div>
                    <div class="col-md-4" style="background-color: #f2f3f8;padding-top: 5px;">
                        <div class="panel panel-warning" style="padding: 9px;background-color: white;">
                            <div class="panel-heading"><h5>Loan + Demog</h5></div>
                            <div class="panel-body" style="overflow-y: auto;height: 182px;">
                                <table class="table">
                                    <tr>
                                        <th>Loan Value</th>
                                        <td style="font-family: sans-serif;">&#8377;{!! money_format('%!i',$loan_amount) !!}</td>
                                    </tr>
                                    <tr>
                                        <th>ROI %</th>
                                        <td>{!! $interest_rate !!}</td>
                                    </tr>
                                    <tr>
                                        <th>Tenure</th>
                                        <td>{!! $tenure !!}</td>
                                    </tr>
                                    <tr>
                                        <th>Profession</th>
                                        <td>{!! $profession !!}</td>
                                    </tr>
                                    <tr>
                                        <th>Profession Type</th>
                                        <td>{!! $profession_type !!}</td>
                                    </tr>
                                    <tr>
                                        <th>Industry</th>
                                        <td>{!! $industry !!}</td>
                                    </tr>
                                    <tr>
                                        <th>Company Category</th>
                                        <td>{!! $company_category !!}</td>
                                    </tr>
                                    <tr>
                                        <th>Company Name</th>
                                        <td>{!! $company_name !!}</td>
                                    </tr>
                                </table>
                            </div>
                        </div>
                    </div>
                    @if(isset($manual_applicant_creditscore))
                    <div class="col-md-12" style="background-color: #f2f3f8;padding-top: 5px;">
                        <div class="panel panel-default" style="padding-bottom: 9px;background-color: #e8e8e8;border: 1px solid #d6d6c8;padding-top: 9px;padding-left: 8px;">
                            <div class="panel-heading"><span class="panel-title" data-toggle="collapse" data-parent="#accordion" >Applicant <code>(Manual Pulled Bureau)</code></span><button onclick="opendoc('/admin/consumer-application/get-documents/{!! $manual_applicant_file_path !!}')" style="cursor:pointer">View File</button></div>
                        </div>
                    </div>
                    @endif
                    @if(isset($manual_co_applicant_creditscore))
                    <div class="col-md-12" style="background-color: #f2f3f8;padding-top: 5px;">
                        <div class="panel panel-default" style="padding-bottom: 9px;background-color: #e8e8e8;border: 1px solid #d6d6c8;padding-top: 9px;padding-left: 8px;">
                            <div class="panel-heading"><span class="panel-title" data-toggle="collapse" data-parent="#accordion" >Co-Applicant <code>(Manual Pulled Bureau)</code></span><button onclick="opendoc('/admin/consumer-application/get-documents/{!! $manual_co_applicant_file_path !!}')" style="cursor:pointer">View File</button></div>
                        </div>
                    </div>
                    @endif
                    @if(isset($bureauInput) && count($bureauInput) > 0)
                    <div class="col-md-12" style="background-color: #f2f3f8;padding-top: 5px;">
                        <div class="panel panel-default" style="cursor: pointer;padding-bottom: 9px;background-color: #e8e8e8;border: 1px solid #d6d6c8;padding-top: 9px;padding-left: 8px;">
                            <div class="panel-heading"><span class="panel-title" data-toggle="collapse" data-parent="#accordion" href="#bureau_report">BUREAU INPUT (Live + Closed) <code>(Applicant)</code></span></div>
                            <div id="bureau_report" style="background-color: white;margin-left: -8px;margin-top: 10px;" class="panel-collapse collapse in show">
                            <div class="panel-body" style="overflow-y: scroll">
                                <table class="table" >
                                    <tr>
                                        <th>Account Status</th>
                                        <th>Last Reporting Date</th>
                                        <th>Last Payment Date</th>
                                        <th>Date Opened</th>
                                        <th>Date Closed</th>
                                        <th>Type of Loan</th>
                                        <th>Ownership</th>
                                        <th>Loan Sanctioned</th>
                                        <th>Loan Outstanding</th>
                                        <th>Overdue Amount</th>
                                        {{--<th>Schedule EMI</th>--}}
                                        <th>Principal Write-off</th>
                                        <th>EMI Calc-Old</th>
                                        <th>EMI Calc-New</th>
                                        <th>Last EMI Amount paid</th>
                                        <th>Max DPD</th>
                                        <th>Avg. DPD</th>
                                        <th>DPD in 6 Months</th>
                                        <th>DPD in 12 Months</th>
                                    </tr>
                                    @foreach($bureauInput as $item)
                                        <tr>
                                            <?php $red = ''; if(empty($item['date_closed']) && $item['reported_date'] && $login_date && (strtotime($item['reported_date']) <= strtotime($login_date)) && $item['loan_outstanding'] > 0){
                                                $red = "color:red;";
                                            } ?>
                                            <?php $red1 = ''; if(empty($item['date_closed']) && $item['last_payment_date'] && $login_date && (strtotime($item['last_payment_date']) <= strtotime($login_date)) && $item['loan_outstanding'] > 0){
                                                $red1 = "color:red;";
                                            }

                                            $red2 = '';
                                            if($item['AccountStatus'] == 'Settled' || $item['AccountStatus'] == 'Suit Filed(Wilful Default) and Written-off' || $item['AccountStatus'] == 'Suit Filed' || $item['AccountStatus'] == 'Post (WO) Settled'|| $item['AccountStatus'] == 'Wilful default'|| $item['AccountStatus'] == 'Written-off'|| $item['AccountStatus'] == 'Doubtful'|| $item['AccountStatus'] == 'Restructured Loan'|| $item['AccountStatus'] == 'Loss' || $item['AccountStatus'] == 'Account Sold'){
                                                $red2 = "color:red;";
                                            }
                                            $red3 = '';
                                            if($item['PrincipalWriteOff'] > 0) {
                                                $red3 = "color:red;";
                                            }
                                            if(isset($item['highlight']) && $item['highlight']){
                                                $red2 = "color:red;";
                                            }
                                            ?>
                                            <td style="<?php echo $red2; ?>">{!! $item['AccountStatus'] or '' !!}</td>
                                            <td style="<?php echo $red; ?>">{!! $item['reported_date'] or '' !!}</td>
                                            <td style="<?php echo $red1; ?>">{!! $item['last_payment_date'] or '' !!}</td>
                                            <td><?php echo ($item['date_opened']) ? date('Y-m-d',strtotime($item['date_opened'])) : $item['date_opened'] ?></td>
                                            <td><?php echo ($item['date_closed']) ?  date('Y-m-d',strtotime($item['date_closed'])) : $item['date_closed'] ?></td>
                                            <td>@if(isset($item['is_close_date_updated']) && $item['is_close_date_updated'])<span class="fa fa-exclamation-triangle" data-toggle="tooltip" data-placement="top" title="Closed but balance o/s" style="color: red;"></span>@endif {!! $item['type_of_loan'] !!}</td>
                                            <td>{!! $item['owner_ship'] !!}</td>
                                            <td style="font-family: sans-serif;">&#8377;{!! money_format('%!i',$item['loan_sanctioned']) !!}</td>
                                            <td style="font-family: sans-serif;">&#8377;{!! money_format('%!i',$item['loan_outstanding']) !!}</td>
                                            <td style="@if($item['over_due_amount'] > 0) color:red; @endif font-family: sans-serif;">&#8377;{!! money_format('%!i',$item['over_due_amount']) !!}</td>
                                            <td style="<?php echo $red3; ?>">{!! $item['PrincipalWriteOff'] or '' !!}</td>
                                            <td>{!! $item['schedule_emi'] !!}</td>
                                            <td>{!! $item['schedule_emi_new'] !!}</td>
                                            <td style="font-family: sans-serif;">&#8377;{!! money_format('%!i',$item['last_emi_amount_paid']) !!}</td>
                                            <td>{!! $item['max_dpd'] !!}</td>
                                            <td>{!! $item['average_dpd'] !!}</td>
                                            <td>{!! $item['sixmonth'] !!}</td>
                                            <td>{!! $item['twelvemonth'] !!}</td>
                                        </tr>
                                    @endforeach
                                    @if($guarantor_loans !== '')
                                        <tr>
                                            <th colspan=3>
                                                <div id="my_box">
                                                    Guarantor Loans:
                                                </div>
                                            </th>
                                        </tr>
                                        @foreach($guarantor_loans as $item)
                                            <tr>

                                                <?php
                                                if(isset($item['highlight']) && $item['highlight']){
                                                    $red2 = "color:red;";
                                                }
                                                $red2 = '';
                                                if($item['AccountStatus'] == 'Settled' || $item['AccountStatus'] == 'Suit Filed(Wilful Default) and Written-off' || $item['AccountStatus'] == 'Suit Filed' || $item['AccountStatus'] == 'Post (WO) Settled'|| $item['AccountStatus'] == 'Wilful default'|| $item['AccountStatus'] == 'Written-off'|| $item['AccountStatus'] == 'Doubtful'|| $item['AccountStatus'] == 'Restructured Loan'|| $item['AccountStatus'] == 'Loss' || $item['AccountStatus'] == 'Account Sold'){
                                                $red2 = "color:red;";
                                                }
                                                $red3 = '';
                                                if($item['PrincipalWriteOff'] > 0) {
                                                $red3 = "color:red;";
                                                }
                                                ?>

                                                <?php if(!isset($red)){$red = '';}if(!isset($red1)){$red1 = '';} ?>
                                                <td style="<?php echo $red2; ?>">{!! $item['AccountStatus'] or '' !!}</td>
                                                <td style="<?php echo $red; ?>">{!! $item['ReportedDate'] or '' !!}</td>
                                                <td style="<?php echo $red1; ?>">{!! $item['LastPaymentDate'] or '' !!}</td>
                                                <td><?php echo ($item['DateOpened']) ? date('Y-m-d',strtotime($item['DateOpened'])) : $item['DateOpened'] ?></td>
                                                <td><?php echo ($item['DateClosed']) ?  date('Y-m-d',strtotime($item['DateClosed'])) : $item['DateClosed'] ?></td>
                                                <td>{!! $item['AccountType'] !!}</td>
                                                <td>{!! $item['OwnershipType'] !!}</td>
                                                <td style="font-family: sans-serif;">&#8377;{!! money_format('%!i',$item['ApprovedAmount']) !!}</td>
                                                <td style="font-family: sans-serif;">&#8377;{!! money_format('%!i',$item['Balance']) !!}</td>
                                                <td style="@if($item['over_due_amount'] > 0) color:red; @endif font-family: sans-serif;">&#8377;{!! money_format('%!i',$item['PastDueAmount']) !!}</td>
                                                <td style="<?php echo $red3; ?>">{!! $item['PrincipalWriteOff'] or '' !!}</td>
                                                <td>{!! $item['InstallmentAmountNew'] !!}</td>
                                                <td>{!! $item['InstallmentAmountNew'] !!}</td>
                                                <td style="font-family: sans-serif;">&#8377;{!! money_format('%!i',$item['LastPayment']) !!}</td>
                                                <td>{!! $item['max_dpd'] or ''!!}</td>
                                                <td>{!! $item['average_dpd'] or '' !!}</td>
                                                <td>{!! $item['sixmonth'] !!}</td>
                                                <td>{!! $item['twelvemonth'] !!}</td>
                                            </tr>
                                        @endforeach
                                    @endif
                                </table>
                    <?php
                    $accountType = [1   => "AUTO LOAN", 2   => "HOUSING LOAN", 3   => "PROPERTY LOAN", 4   => "LOAN AGAINST SHARES/SECURITIES", 5   => "PERSONAL LOAN", 6   => "CONSUMER LOAN", 7   => "GOLD LOAN", 8   => "EDUCATIONAL LOAN", 9   => "LOAN TO PROFESSIONAL", 10  => "CREDIT CARD", 11  => "LEASING", 12  => "OVERDRAFT", 13  => "TWO-WHEELER LOAN", 14  => "NON-FUNDED CREDIT FACILITY", 15  => "LOAN AGAINST BANK DEPOSITS", 16  => "FLEET CARD", 17  =>  "Commercial Vehicle Loan", 18  =>  "Telco – Wireless", 19  =>  "Telco – Broadband", 20  =>  "Telco – Landline", 23  =>  "GECL Secured", 24  =>  "GECL Unsecured", 31  =>  "Secured Credit Card", 32  =>  "Used Car Loan", 33  =>  "Construction Equipment Loan", 34  =>  "Tractor Loan", 35  =>  "Corporate Credit Card", 36  =>  "Kisan Credit Card", 37  =>  "Loan on Credit Card", 38  =>  "Prime Minister Jaan Dhan Yojana - Overdraft", 39  =>  "Mudra Loans – Shishu / Kishor / Tarun", 40  =>  "Microfinance – Business Loan", 41  =>  "Microfinance – Personal Loan", 42  =>  "Microfinance – Housing Loan", 43  =>  "Microfinance – Others", 44  =>  "Pradhan Mantri Awas Yojana - Credit Link Subsidy Scheme MAY CLSS", 45  =>  "P2P Personal Loan", 46  =>  "P2P Auto Loan", 47  =>  "P2P Education Loan", 51  =>  "BUSINESS LOAN – GENERAL", 52  =>  "BUSINESS LOAN –PRIORITY SECTOR – SMALL BUSINESS", 53  =>  "BUSINESS LOAN –PRIORITY SECTOR – AGRICULTURE", 54  =>  "BUSINESS LOAN –PRIORITY SECTOR – OTHERS", 55  =>  "BUSINESS NON-FUNDED CREDIT FACILITY – GENERAL", 56  =>  "BUSINESS NON-FUNDED CREDIT FACILITY – PRIORITY SECTOR – SMALL BUSINESS", 57  =>  "BUSINESS NON-FUNDED CREDIT FACILITY – PRIORITY SECTOR – AGRICULTURE", 58  =>  "BUSINESS NON-FUNDED CREDIT FACILITY – PRIORITY SECTOR – OTHERS", 59  =>  "BUSINESS LOANS AGAINST BANK DEPOSITS", 60  =>  "Staff Loan", 61  =>  "Business Loan - Unsecured", 0  =>  "Others"];
                    ?>
                <table width="100%">
                    <tr>
                        <td bgcolor="#FFFFFF">&nbsp;</td>
                    </tr>
                    <tr>
                        <td height="19" bgcolor="#FFFFFF" style="border:1px solid #e5e5e5;">
                            <table width="100%" border="0" cellspacing="0" cellpadding="0">
                                <tr>
                                    <td height="30" valign="middle" background="data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAAUAAAAeCAIAAABrHEPqAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAAyJpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBiZWdpbj0i77u/IiBpZD0iVzVNME1wQ2VoaUh6cmVTek5UY3prYzlkIj8+IDx4OnhtcG1ldGEgeG1sbnM6eD0iYWRvYmU6bnM6bWV0YS8iIHg6eG1wdGs9IkFkb2JlIFhNUCBDb3JlIDUuMy1jMDExIDY2LjE0NTY2MSwgMjAxMi8wMi8wNi0xNDo1NjoyNyAgICAgICAgIj4gPHJkZjpSREYgeG1sbnM6cmRmPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5LzAyLzIyLXJkZi1zeW50YXgtbnMjIj4gPHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9IiIgeG1sbnM6eG1wPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvIiB4bWxuczp4bXBNTT0iaHR0cDovL25zLmFkb2JlLmNvbS94YXAvMS4wL21tLyIgeG1sbnM6c3RSZWY9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9zVHlwZS9SZXNvdXJjZVJlZiMiIHhtcDpDcmVhdG9yVG9vbD0iQWRvYmUgUGhvdG9zaG9wIENTNiAoV2luZG93cykiIHhtcE1NOkluc3RhbmNlSUQ9InhtcC5paWQ6QUVENTVFRDMxNzBDMTFFNDk3QTZEQzQ1NEE2Njk4RUQiIHhtcE1NOkRvY3VtZW50SUQ9InhtcC5kaWQ6QUVENTVFRDQxNzBDMTFFNDk3QTZEQzQ1NEE2Njk4RUQiPiA8eG1wTU06RGVyaXZlZEZyb20gc3RSZWY6aW5zdGFuY2VJRD0ieG1wLmlpZDpBRUQ1NUVEMTE3MEMxMUU0OTdBNkRDNDU0QTY2OThFRCIgc3RSZWY6ZG9jdW1lbnRJRD0ieG1wLmRpZDpBRUQ1NUVEMjE3MEMxMUU0OTdBNkRDNDU0QTY2OThFRCIvPiA8L3JkZjpEZXNjcmlwdGlvbj4gPC9yZGY6UkRGPiA8L3g6eG1wbWV0YT4gPD94cGFja2V0IGVuZD0iciI/PvGwHv0AAABRSURBVHjarM0xDgAhCADB8/9PVRAoVMTCVhoSkttuqi3HzvdUzCzlvbezqv7qtVboOafzGMMZAFKutYZurYXO/hDRuffuTETOzBxaRF5fAQYALOtVmKwQhcAAAAAASUVORK5CYII=">
                                        <table width="100%" border="0" cellspacing="0" cellpadding="0">
                                            <tr>
                                                <td width="4%"><span class="sectionHeading">&nbsp;&nbsp;&nbsp;<img src="data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAACXBIWXMAAAsTAAALEwEAmpwYAAAKT2lDQ1BQaG90b3Nob3AgSUNDIHByb2ZpbGUAAHjanVNnVFPpFj333vRCS4iAlEtvUhUIIFJCi4AUkSYqIQkQSoghodkVUcERRUUEG8igiAOOjoCMFVEsDIoK2AfkIaKOg6OIisr74Xuja9a89+bN/rXXPues852zzwfACAyWSDNRNYAMqUIeEeCDx8TG4eQuQIEKJHAAEAizZCFz/SMBAPh+PDwrIsAHvgABeNMLCADATZvAMByH/w/qQplcAYCEAcB0kThLCIAUAEB6jkKmAEBGAYCdmCZTAKAEAGDLY2LjAFAtAGAnf+bTAICd+Jl7AQBblCEVAaCRACATZYhEAGg7AKzPVopFAFgwABRmS8Q5ANgtADBJV2ZIALC3AMDOEAuyAAgMADBRiIUpAAR7AGDIIyN4AISZABRG8lc88SuuEOcqAAB4mbI8uSQ5RYFbCC1xB1dXLh4ozkkXKxQ2YQJhmkAuwnmZGTKBNA/g88wAAKCRFRHgg/P9eM4Ors7ONo62Dl8t6r8G/yJiYuP+5c+rcEAAAOF0ftH+LC+zGoA7BoBt/qIl7gRoXgugdfeLZrIPQLUAoOnaV/Nw+H48PEWhkLnZ2eXk5NhKxEJbYcpXff5nwl/AV/1s+X48/Pf14L7iJIEyXYFHBPjgwsz0TKUcz5IJhGLc5o9H/LcL//wd0yLESWK5WCoU41EScY5EmozzMqUiiUKSKcUl0v9k4t8s+wM+3zUAsGo+AXuRLahdYwP2SycQWHTA4vcAAPK7b8HUKAgDgGiD4c93/+8//UegJQCAZkmScQAAXkQkLlTKsz/HCAAARKCBKrBBG/TBGCzABhzBBdzBC/xgNoRCJMTCQhBCCmSAHHJgKayCQiiGzbAdKmAv1EAdNMBRaIaTcA4uwlW4Dj1wD/phCJ7BKLyBCQRByAgTYSHaiAFiilgjjggXmYX4IcFIBBKLJCDJiBRRIkuRNUgxUopUIFVIHfI9cgI5h1xGupE7yAAygvyGvEcxlIGyUT3UDLVDuag3GoRGogvQZHQxmo8WoJvQcrQaPYw2oefQq2gP2o8+Q8cwwOgYBzPEbDAuxsNCsTgsCZNjy7EirAyrxhqwVqwDu4n1Y8+xdwQSgUXACTYEd0IgYR5BSFhMWE7YSKggHCQ0EdoJNwkDhFHCJyKTqEu0JroR+cQYYjIxh1hILCPWEo8TLxB7iEPENyQSiUMyJ7mQAkmxpFTSEtJG0m5SI+ksqZs0SBojk8naZGuyBzmULCAryIXkneTD5DPkG+Qh8lsKnWJAcaT4U+IoUspqShnlEOU05QZlmDJBVaOaUt2ooVQRNY9aQq2htlKvUYeoEzR1mjnNgxZJS6WtopXTGmgXaPdpr+h0uhHdlR5Ol9BX0svpR+iX6AP0dwwNhhWDx4hnKBmbGAcYZxl3GK+YTKYZ04sZx1QwNzHrmOeZD5lvVVgqtip8FZHKCpVKlSaVGyovVKmqpqreqgtV81XLVI+pXlN9rkZVM1PjqQnUlqtVqp1Q61MbU2epO6iHqmeob1Q/pH5Z/YkGWcNMw09DpFGgsV/jvMYgC2MZs3gsIWsNq4Z1gTXEJrHN2Xx2KruY/R27iz2qqaE5QzNKM1ezUvOUZj8H45hx+Jx0TgnnKKeX836K3hTvKeIpG6Y0TLkxZVxrqpaXllirSKtRq0frvTau7aedpr1Fu1n7gQ5Bx0onXCdHZ4/OBZ3nU9lT3acKpxZNPTr1ri6qa6UbobtEd79up+6Ynr5egJ5Mb6feeb3n+hx9L/1U/W36p/VHDFgGswwkBtsMzhg8xTVxbzwdL8fb8VFDXcNAQ6VhlWGX4YSRudE8o9VGjUYPjGnGXOMk423GbcajJgYmISZLTepN7ppSTbmmKaY7TDtMx83MzaLN1pk1mz0x1zLnm+eb15vft2BaeFostqi2uGVJsuRaplnutrxuhVo5WaVYVVpds0atna0l1rutu6cRp7lOk06rntZnw7Dxtsm2qbcZsOXYBtuutm22fWFnYhdnt8Wuw+6TvZN9un2N/T0HDYfZDqsdWh1+c7RyFDpWOt6azpzuP33F9JbpL2dYzxDP2DPjthPLKcRpnVOb00dnF2e5c4PziIuJS4LLLpc+Lpsbxt3IveRKdPVxXeF60vWdm7Obwu2o26/uNu5p7ofcn8w0nymeWTNz0MPIQ+BR5dE/C5+VMGvfrH5PQ0+BZ7XnIy9jL5FXrdewt6V3qvdh7xc+9j5yn+M+4zw33jLeWV/MN8C3yLfLT8Nvnl+F30N/I/9k/3r/0QCngCUBZwOJgUGBWwL7+Hp8Ib+OPzrbZfay2e1BjKC5QRVBj4KtguXBrSFoyOyQrSH355jOkc5pDoVQfujW0Adh5mGLw34MJ4WHhVeGP45wiFga0TGXNXfR3ENz30T6RJZE3ptnMU85ry1KNSo+qi5qPNo3ujS6P8YuZlnM1VidWElsSxw5LiquNm5svt/87fOH4p3iC+N7F5gvyF1weaHOwvSFpxapLhIsOpZATIhOOJTwQRAqqBaMJfITdyWOCnnCHcJnIi/RNtGI2ENcKh5O8kgqTXqS7JG8NXkkxTOlLOW5hCepkLxMDUzdmzqeFpp2IG0yPTq9MYOSkZBxQqohTZO2Z+pn5mZ2y6xlhbL+xW6Lty8elQfJa7OQrAVZLQq2QqboVFoo1yoHsmdlV2a/zYnKOZarnivN7cyzytuQN5zvn//tEsIS4ZK2pYZLVy0dWOa9rGo5sjxxedsK4xUFK4ZWBqw8uIq2Km3VT6vtV5eufr0mek1rgV7ByoLBtQFr6wtVCuWFfevc1+1dT1gvWd+1YfqGnRs+FYmKrhTbF5cVf9go3HjlG4dvyr+Z3JS0qavEuWTPZtJm6ebeLZ5bDpaql+aXDm4N2dq0Dd9WtO319kXbL5fNKNu7g7ZDuaO/PLi8ZafJzs07P1SkVPRU+lQ27tLdtWHX+G7R7ht7vPY07NXbW7z3/T7JvttVAVVN1WbVZftJ+7P3P66Jqun4lvttXa1ObXHtxwPSA/0HIw6217nU1R3SPVRSj9Yr60cOxx++/p3vdy0NNg1VjZzG4iNwRHnk6fcJ3/ceDTradox7rOEH0x92HWcdL2pCmvKaRptTmvtbYlu6T8w+0dbq3nr8R9sfD5w0PFl5SvNUyWna6YLTk2fyz4ydlZ19fi753GDborZ752PO32oPb++6EHTh0kX/i+c7vDvOXPK4dPKy2+UTV7hXmq86X23qdOo8/pPTT8e7nLuarrlca7nuer21e2b36RueN87d9L158Rb/1tWeOT3dvfN6b/fF9/XfFt1+cif9zsu72Xcn7q28T7xf9EDtQdlD3YfVP1v+3Njv3H9qwHeg89HcR/cGhYPP/pH1jw9DBY+Zj8uGDYbrnjg+OTniP3L96fynQ89kzyaeF/6i/suuFxYvfvjV69fO0ZjRoZfyl5O/bXyl/erA6xmv28bCxh6+yXgzMV70VvvtwXfcdx3vo98PT+R8IH8o/2j5sfVT0Kf7kxmTk/8EA5jz/GMzLdsAAAAgY0hSTQAAeiUAAICDAAD5/wAAgOkAAHUwAADqYAAAOpgAABdvkl/FRgAAAZxJREFUeNqU001IVFEYxvGfc0dHxTKTPmBy0dSAKUItgiIKajLUokWu2oqYJC2kTS0CNwPVQoM+DQuqhW1mqUSIkAQtgjaCREHRok3UKoSYampzr1wu5uQDB855zvs/533PR83+4gYJdWAQvdgZeh/wDFNYigenYv063MIiRtGOTNj2hN4i7qEhgtIxeAbHra0UziEfZliOMpj4DziuYxiPVuwMV62qM/sG4sNhdKbCAwuqwUfyfUaOjsWtAINp9FSD21pyxk7fl0nXJ6d6Usgl3dqgzqbGVlBf2+Bq/xNNmY2evr6bDM2lks7etoMeDyy42H0dXOq5Ib+1y4OX19ycv5IML6fDR9IeOa1N221u3KK7o9+35S/6us569Grc5EJxteo+BdlCZjcORM7Hr289Xyo5tOuEw/lepTdTJuYu/+t4poNsIfM5vMaVcpbL3714N2tb8w7FmQsqfyqrwb8xVBP+hds4b326g5Fo11HMrQOeD5mVtMs4GWZSWQOsYBKnQkaQLWTiNc2ihJ9oQTN+4D2mMYSH+BVBfwcAR2JZGqsMussAAAAASUVORK5CYII=" width="16" height="16" alt="Arrow" /></span></td>
                                                <td width="83%"><span class="sectionHeading">Credit Enquiries </span></td>
                                                @if(count((array)$Enquiries) > 0)
                                                    <td width="13%" class="subHeding"><?php echo count((array)$Enquiries)?></td>
                                                @else
                                                    <td width="13%" class="subHeding">No Records Found</td>
                                                @endif
                                            </tr>
                                        </table>
                                    </td>
                                </tr>
                                <tr>
                                    <td height="25" style="border-top:1px solid #E5E5E5;"><span class="sectionTooltip" >&nbsp;&nbsp;&nbsp;This section shows the names of the credit institutions that have processed a credit / loan application for you.</span></td>
                                </tr>
                            </table>
                        </td>
                    </tr>
                    @if(count((array)$Enquiries) > 0 && !empty($Enquiries))
                    <tr>
                        <td valign="top" bgcolor="#FFFFFF">
                            <div class="reportDetailWrap">
                                <table width="100%" border="0" align="center" cellpadding="5" cellspacing="0" class="reportCapEnquiryDetails" style="border-color: #333 !important;">
                                    <tr>
                                        <td valign="top" class="subHeding" style="border:1px solid #E5E5E5;">Sr. No</td>
                                        <td valign="top" style="border:1px solid #E5E5E5;" class="subHeding">Enquiry Date</td>
                                        <td valign="top" style="border:1px solid #E5E5E5;" class="subHeding">Member Type</td>
                                        <td valign="top" style="border:1px solid #e5e5e5;" class="subHeding">Purpose</td>
                                        <td valign="top" style="border:1px solid #e5e5e5;" class="subHeding">Enquiry Amount</td>
                                        <td valign="top" style="border:1px solid #e5e5e5;" class="subHeding">Enquiry Type</td>
                                    </tr>
                                    <?php $keyMes = 1; ?>
                                    @foreach($Enquiries as $key=>$credit_caps_detail)
                                        <tr>
                                            <?php
                                                if($keyMes==5){
                                                    break;
                                                }
                                            ?>
                                            <td style="border:1px solid #e5e5e5;" class="sectionDataElementValues summaryDetailColumn" >{!! $keyMes !!}</td>
                                            <td style="border:1px solid #e5e5e5;" class="sectionDataElementValues summaryDetailColumn" ><?php echo !empty($credit_caps_detail->Date_of_Request) && !empty($credit_caps_detail->ReportTime) ? \Carbon\Carbon::parse($credit_caps_detail->Date_of_Request)->format('d-M-Y').' '.\Carbon\Carbon::parse($credit_caps_detail->ReportTime)->format('H:i:s') : '-'?></td>
                                            <td style="border:1px solid #e5e5e5;" class="sectionDataElementValues summaryDetailColumn" >-</td>
                                            <td style="border:1px solid #e5e5e5;" class="sectionDataElementValues summaryDetailColumn" ><?php echo !empty($credit_caps_detail->Enquiry_Reason) && array_key_exists((int)$credit_caps_detail->Enquiry_Reason, $accountType) ? $accountType[(int)$credit_caps_detail->Enquiry_Reason] : '-' ?></td>
                                            <td style="border:1px solid #e5e5e5;" class="sectionDataElementValues summaryDetailColumn" ><?php echo !empty($credit_caps_detail->Amount_Financed) ? $credit_caps_detail->Amount_Financed : '-'?></td>
                                            <td style="border:1px solid #e5e5e5;" class="sectionDataElementValues summaryDetailColumn" >Credit</td>
                                        </tr>
                                        <?php $keyMes++; ?>
                                    @endforeach
                                </table>
                            </div>
                        </td>
                    </tr>
                        @endif
                </table>
            </div>
        </div>
    </div>
</div>
                    @endif
                    @if(isset($bureauInputCoApplicant) && count($bureauInputCoApplicant) > 0)
                    <div class="col-md-12" style="background-color: #f2f3f8;padding-top: 5px;">
                        <div class="panel panel-default" style="cursor: pointer;padding-bottom: 9px;background-color: #e8e8e8;border: 1px solid #d6d6c8;padding-top: 9px;padding-left: 8px;">
                            <div class="panel-heading"><span class="panel-title" data-toggle="collapse" data-parent="#accordion" href="#bureau_report_co">BUREAU INPUT (Live + Closed) <code>(Co-Applicant)</code></span></div>
                            <div id="bureau_report_co" style="background-color: white;margin-left: -8px;margin-top: 10px;" class="panel-collapse collapse">
                                <div class="panel-body" style="overflow-y: scroll">
                                    <table class="table" >
                                        <tr>
                                            <th>Account Status</th>
                                            <th>Last Reporting Date</th>
                                            <th>Last Payment Date</th>
                                            <th>Date Opened</th>
                                            <th>Date Closed</th>
                                            <th>Type of Loan</th>
                                            <th>Ownership</th>
                                            <th>Loan Sanctioned</th>
                                            <th>Loan Outstanding</th>
                                            <th>Overdue Amount</th>
                                            {{--<th>Schedule EMI</th>--}}
                                            <th>Principal Write-off</th>
                                            <th>EMI Calc-Old</th>
                                            <th>EMI Calc-New</th>
                                            <th>Last EMI Amount paid</th>
                                            <th>Max DPD</th>
                                            <th>Avg. DPD</th>
                                            <th>DPD in 6 Months</th>
                                            <th>DPD in 12 Months</th>
                                        </tr>
                                        @foreach($bureauInputCoApplicant as $item)
                                            <tr>
                                                <?php $red = ''; if(empty($item['date_closed']) && $item['reported_date'] && $login_date && (strtotime($item['reported_date']) <= strtotime($login_date)) && $item['loan_outstanding'] > 0){
                                                    $red = "color:red;";
                                                } ?>
                                                <?php $red1 = ''; if(empty($item['date_closed']) && $item['last_payment_date'] && ($login_date && strtotime($item['last_payment_date']) <= strtotime($login_date)) && $item['loan_outstanding'] > 0){
                                                    $red1 = "color:red;";
                                                }

                                                    $red2 = '';
                                                if($item['AccountStatus'] == 'Settled' || $item['AccountStatus'] == 'Suit Filed(Wilful Default) and Written-off' || $item['AccountStatus'] == 'Suit Filed' || $item['AccountStatus'] == 'Post (WO) Settled'|| $item['AccountStatus'] == 'Wilful default'|| $item['AccountStatus'] == 'Written-off'|| $item['AccountStatus'] == 'Doubtful'|| $item['AccountStatus'] == 'Restructured Loan'|| $item['AccountStatus'] == 'Loss' || $item['AccountStatus'] == 'Account Sold'){
                                                    $red2 = "color:red;";
                                                }
                                                    $red3 = '';
                                                if($item['PrincipalWriteOff'] > 0) {
                                                    $red3 = "color:red;";
                                                }

                                                if(isset($item['highlight']) && $item['highlight']){
                                                    $red2 = "color:red;";
                                                }

                                                ?>
                                                <td style="<?php echo $red2; ?>">{!! $item['AccountStatus'] or '' !!}</td>
                                                    <td style="<?php echo $red; ?>">{!! $item['reported_date'] or '' !!}</td>
                                                    <td style="<?php echo $red1; ?>">{!! $item['last_payment_date'] or '' !!}</td>
                                                <td><?php echo ($item['date_opened']) ? date('Y-m-d',strtotime($item['date_opened'])) : $item['date_opened'] ?></td>
                                                <td><?php echo ($item['date_closed']) ?  date('Y-m-d',strtotime($item['date_closed'])) : $item['date_closed'] ?></td>
                                                <td>@if(isset($item['is_close_date_updated']) && $item['is_close_date_updated'])<span class="fa fa-exclamation-triangle" data-toggle="tooltip" data-placement="top" title="Closed but balance o/s" style="color: red;"></span>@endif {!! $item['type_of_loan'] !!}</td>
                                                <td>{!! $item['owner_ship'] !!}</td>
                                                <td style="font-family: sans-serif;">&#8377;{!! money_format('%!i',$item['loan_sanctioned']) !!}</td>
                                                <td style="font-family: sans-serif;">&#8377;{!! money_format('%!i',$item['loan_outstanding']) !!}</td>
                                                <td style="@if($item['over_due_amount'] > 0) color:red; @endif font-family: sans-serif;">&#8377;{!! money_format('%!i',$item['over_due_amount']) !!}</td>
                                                <td style="<?php echo $red3; ?>">{!! $item['PrincipalWriteOff'] or '' !!}</td>
                                                <td>{!! $item['schedule_emi'] !!}</td>
                                                <td>{!! $item['schedule_emi_new'] !!}</td>
                                                <td style="font-family: sans-serif;">&#8377;{!! money_format('%!i',$item['last_emi_amount_paid']) !!}</td>
                                                <td>{!! $item['max_dpd'] !!}</td>
                                                <td>{!! $item['average_dpd'] !!}</td>
                                                <td>{!! $item['sixmonth'] !!}</td>
                                                <td>{!! $item['twelvemonth'] !!}</td>
                                            </tr>
                                        @endforeach
                                        @if($guarantor_loans !== '')
                                        <tr>
                                            <th colspan=3>
                                                <div id="my_box">
                                                    Guarantor Loans:
                                                </div>
                                            </th>
                                        </tr>
                                        @foreach($guarantor_loans as $item)
                                            <tr>

                                                <?php
                                                if(isset($item['highlight']) && $item['highlight']){
                                                    $red2 = "color:red;";
                                                }

                                                $red2 = '';
                                                if($item['AccountStatus'] == 'Settled' || $item['AccountStatus'] == 'Suit Filed(Wilful Default) and Written-off' || $item['AccountStatus'] == 'Suit Filed' || $item['AccountStatus'] == 'Post (WO) Settled'|| $item['AccountStatus'] == 'Wilful default'|| $item['AccountStatus'] == 'Written-off'|| $item['AccountStatus'] == 'Doubtful'|| $item['AccountStatus'] == 'Restructured Loan'|| $item['AccountStatus'] == 'Loss' || $item['AccountStatus'] == 'Account Sold'){
                                                    $red2 = "color:red;";
                                                }
                                                $red3 = '';
                                                if($item['PrincipalWriteOff'] > 0) {
                                                    $red3 = "color:red;";
                                                }
                                                ?>

                                                <?php if(!isset($red)){$red = '';}if(!isset($red1)){$red1 = '';} ?>
                                                <td style="<?php echo $red2; ?>">{!! $item['AccountStatus'] or '' !!}</td>
                                                <td style="<?php echo $red; ?>">{!! $item['ReportedDate'] or '' !!}</td>
                                                <td style="<?php echo $red1; ?>">{!! $item['LastPaymentDate'] or '' !!}</td>
                                                <td><?php echo ($item['DateOpened']) ? date('Y-m-d',strtotime($item['DateOpened'])) : $item['DateOpened'] ?></td>
                                                <td><?php echo ($item['DateClosed']) ?  date('Y-m-d',strtotime($item['DateClosed'])) : $item['DateClosed'] ?></td>
                                                <td>{!! $item['AccountType'] !!}</td>
                                                <td>{!! $item['OwnershipType'] !!}</td>
                                                <td style="font-family: sans-serif;">&#8377;{!! money_format('%!i',$item['ApprovedAmount']) !!}</td>
                                                <td style="font-family: sans-serif;">&#8377;{!! money_format('%!i',$item['Balance']) !!}</td>
                                                <td style="@if($item['over_due_amount'] > 0) color:red; @endif font-family: sans-serif;">&#8377;{!! money_format('%!i',$item['PastDueAmount']) !!}</td>
                                                <td style="<?php echo $red3; ?>">{!! $item['PrincipalWriteOff'] or '' !!}</td>
                                                <td>{!! $item['InstallmentAmountNew'] !!}</td>
                                                <td>{!! $item['InstallmentAmountNew'] !!}</td>
                                                <td style="font-family: sans-serif;">&#8377;{!! money_format('%!i',$item['LastPayment']) !!}</td>
                                                <td>{!! $item['max_dpd'] or ''!!}</td>
                                                <td>{!! $item['average_dpd'] or '' !!}</td>
                                                <td>{!! $item['sixmonth'] or '' !!}</td>
                                                <td>{!! $item['twelvemonth'] or '' !!}</td>
                                            </tr>
                                        @endforeach
                                    @endif
                                    </table>
                                    <?php
                                    $accountType = [1   => "AUTO LOAN", 2   => "HOUSING LOAN", 3   => "PROPERTY LOAN", 4   => "LOAN AGAINST SHARES/SECURITIES", 5   => "PERSONAL LOAN", 6   => "CONSUMER LOAN", 7   => "GOLD LOAN", 8   => "EDUCATIONAL LOAN", 9   => "LOAN TO PROFESSIONAL", 10  => "CREDIT CARD", 11  => "LEASING", 12  => "OVERDRAFT", 13  => "TWO-WHEELER LOAN", 14  => "NON-FUNDED CREDIT FACILITY", 15  => "LOAN AGAINST BANK DEPOSITS", 16  => "FLEET CARD", 17  =>  "Commercial Vehicle Loan", 18  =>  "Telco – Wireless", 19  =>  "Telco – Broadband", 20  =>  "Telco – Landline", 23  =>  "GECL Secured", 24  =>  "GECL Unsecured", 31  =>  "Secured Credit Card", 32  =>  "Used Car Loan", 33  =>  "Construction Equipment Loan", 34  =>  "Tractor Loan", 35  =>  "Corporate Credit Card", 36  =>  "Kisan Credit Card", 37  =>  "Loan on Credit Card", 38  =>  "Prime Minister Jaan Dhan Yojana - Overdraft", 39  =>  "Mudra Loans – Shishu / Kishor / Tarun", 40  =>  "Microfinance – Business Loan", 41  =>  "Microfinance – Personal Loan", 42  =>  "Microfinance – Housing Loan", 43  =>  "Microfinance – Others", 44  =>  "Pradhan Mantri Awas Yojana - Credit Link Subsidy Scheme MAY CLSS", 45  =>  "P2P Personal Loan", 46  =>  "P2P Auto Loan", 47  =>  "P2P Education Loan", 51  =>  "BUSINESS LOAN – GENERAL", 52  =>  "BUSINESS LOAN –PRIORITY SECTOR – SMALL BUSINESS", 53  =>  "BUSINESS LOAN –PRIORITY SECTOR – AGRICULTURE", 54  =>  "BUSINESS LOAN –PRIORITY SECTOR – OTHERS", 55  =>  "BUSINESS NON-FUNDED CREDIT FACILITY – GENERAL", 56  =>  "BUSINESS NON-FUNDED CREDIT FACILITY – PRIORITY SECTOR – SMALL BUSINESS", 57  =>  "BUSINESS NON-FUNDED CREDIT FACILITY – PRIORITY SECTOR – AGRICULTURE", 58  =>  "BUSINESS NON-FUNDED CREDIT FACILITY – PRIORITY SECTOR – OTHERS", 59  =>  "BUSINESS LOANS AGAINST BANK DEPOSITS", 60  =>  "Staff Loan", 61  =>  "Business Loan - Unsecured", 0  =>  "Others"];
                                    ?>
                                <table width="100%">
                                    <tr>
                                        <td bgcolor="#FFFFFF">&nbsp;</td>
                                    </tr>
                                    <tr>
                                        <td height="19" bgcolor="#FFFFFF" style="border:1px solid #e5e5e5;">
                                            <table width="100%" border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td height="30" valign="middle" background="data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAAUAAAAeCAIAAABrHEPqAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAAyJpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBiZWdpbj0i77u/IiBpZD0iVzVNME1wQ2VoaUh6cmVTek5UY3prYzlkIj8+IDx4OnhtcG1ldGEgeG1sbnM6eD0iYWRvYmU6bnM6bWV0YS8iIHg6eG1wdGs9IkFkb2JlIFhNUCBDb3JlIDUuMy1jMDExIDY2LjE0NTY2MSwgMjAxMi8wMi8wNi0xNDo1NjoyNyAgICAgICAgIj4gPHJkZjpSREYgeG1sbnM6cmRmPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5LzAyLzIyLXJkZi1zeW50YXgtbnMjIj4gPHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9IiIgeG1sbnM6eG1wPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvIiB4bWxuczp4bXBNTT0iaHR0cDovL25zLmFkb2JlLmNvbS94YXAvMS4wL21tLyIgeG1sbnM6c3RSZWY9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9zVHlwZS9SZXNvdXJjZVJlZiMiIHhtcDpDcmVhdG9yVG9vbD0iQWRvYmUgUGhvdG9zaG9wIENTNiAoV2luZG93cykiIHhtcE1NOkluc3RhbmNlSUQ9InhtcC5paWQ6QUVENTVFRDMxNzBDMTFFNDk3QTZEQzQ1NEE2Njk4RUQiIHhtcE1NOkRvY3VtZW50SUQ9InhtcC5kaWQ6QUVENTVFRDQxNzBDMTFFNDk3QTZEQzQ1NEE2Njk4RUQiPiA8eG1wTU06RGVyaXZlZEZyb20gc3RSZWY6aW5zdGFuY2VJRD0ieG1wLmlpZDpBRUQ1NUVEMTE3MEMxMUU0OTdBNkRDNDU0QTY2OThFRCIgc3RSZWY6ZG9jdW1lbnRJRD0ieG1wLmRpZDpBRUQ1NUVEMjE3MEMxMUU0OTdBNkRDNDU0QTY2OThFRCIvPiA8L3JkZjpEZXNjcmlwdGlvbj4gPC9yZGY6UkRGPiA8L3g6eG1wbWV0YT4gPD94cGFja2V0IGVuZD0iciI/PvGwHv0AAABRSURBVHjarM0xDgAhCADB8/9PVRAoVMTCVhoSkttuqi3HzvdUzCzlvbezqv7qtVboOafzGMMZAFKutYZurYXO/hDRuffuTETOzBxaRF5fAQYALOtVmKwQhcAAAAAASUVORK5CYII=">
                                                        <table width="100%" border="0" cellspacing="0" cellpadding="0">
                                                            <tr>
                                                                <td width="4%"><span class="sectionHeading">&nbsp;&nbsp;&nbsp;<img src="data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAACXBIWXMAAAsTAAALEwEAmpwYAAAKT2lDQ1BQaG90b3Nob3AgSUNDIHByb2ZpbGUAAHjanVNnVFPpFj333vRCS4iAlEtvUhUIIFJCi4AUkSYqIQkQSoghodkVUcERRUUEG8igiAOOjoCMFVEsDIoK2AfkIaKOg6OIisr74Xuja9a89+bN/rXXPues852zzwfACAyWSDNRNYAMqUIeEeCDx8TG4eQuQIEKJHAAEAizZCFz/SMBAPh+PDwrIsAHvgABeNMLCADATZvAMByH/w/qQplcAYCEAcB0kThLCIAUAEB6jkKmAEBGAYCdmCZTAKAEAGDLY2LjAFAtAGAnf+bTAICd+Jl7AQBblCEVAaCRACATZYhEAGg7AKzPVopFAFgwABRmS8Q5ANgtADBJV2ZIALC3AMDOEAuyAAgMADBRiIUpAAR7AGDIIyN4AISZABRG8lc88SuuEOcqAAB4mbI8uSQ5RYFbCC1xB1dXLh4ozkkXKxQ2YQJhmkAuwnmZGTKBNA/g88wAAKCRFRHgg/P9eM4Ors7ONo62Dl8t6r8G/yJiYuP+5c+rcEAAAOF0ftH+LC+zGoA7BoBt/qIl7gRoXgugdfeLZrIPQLUAoOnaV/Nw+H48PEWhkLnZ2eXk5NhKxEJbYcpXff5nwl/AV/1s+X48/Pf14L7iJIEyXYFHBPjgwsz0TKUcz5IJhGLc5o9H/LcL//wd0yLESWK5WCoU41EScY5EmozzMqUiiUKSKcUl0v9k4t8s+wM+3zUAsGo+AXuRLahdYwP2SycQWHTA4vcAAPK7b8HUKAgDgGiD4c93/+8//UegJQCAZkmScQAAXkQkLlTKsz/HCAAARKCBKrBBG/TBGCzABhzBBdzBC/xgNoRCJMTCQhBCCmSAHHJgKayCQiiGzbAdKmAv1EAdNMBRaIaTcA4uwlW4Dj1wD/phCJ7BKLyBCQRByAgTYSHaiAFiilgjjggXmYX4IcFIBBKLJCDJiBRRIkuRNUgxUopUIFVIHfI9cgI5h1xGupE7yAAygvyGvEcxlIGyUT3UDLVDuag3GoRGogvQZHQxmo8WoJvQcrQaPYw2oefQq2gP2o8+Q8cwwOgYBzPEbDAuxsNCsTgsCZNjy7EirAyrxhqwVqwDu4n1Y8+xdwQSgUXACTYEd0IgYR5BSFhMWE7YSKggHCQ0EdoJNwkDhFHCJyKTqEu0JroR+cQYYjIxh1hILCPWEo8TLxB7iEPENyQSiUMyJ7mQAkmxpFTSEtJG0m5SI+ksqZs0SBojk8naZGuyBzmULCAryIXkneTD5DPkG+Qh8lsKnWJAcaT4U+IoUspqShnlEOU05QZlmDJBVaOaUt2ooVQRNY9aQq2htlKvUYeoEzR1mjnNgxZJS6WtopXTGmgXaPdpr+h0uhHdlR5Ol9BX0svpR+iX6AP0dwwNhhWDx4hnKBmbGAcYZxl3GK+YTKYZ04sZx1QwNzHrmOeZD5lvVVgqtip8FZHKCpVKlSaVGyovVKmqpqreqgtV81XLVI+pXlN9rkZVM1PjqQnUlqtVqp1Q61MbU2epO6iHqmeob1Q/pH5Z/YkGWcNMw09DpFGgsV/jvMYgC2MZs3gsIWsNq4Z1gTXEJrHN2Xx2KruY/R27iz2qqaE5QzNKM1ezUvOUZj8H45hx+Jx0TgnnKKeX836K3hTvKeIpG6Y0TLkxZVxrqpaXllirSKtRq0frvTau7aedpr1Fu1n7gQ5Bx0onXCdHZ4/OBZ3nU9lT3acKpxZNPTr1ri6qa6UbobtEd79up+6Ynr5egJ5Mb6feeb3n+hx9L/1U/W36p/VHDFgGswwkBtsMzhg8xTVxbzwdL8fb8VFDXcNAQ6VhlWGX4YSRudE8o9VGjUYPjGnGXOMk423GbcajJgYmISZLTepN7ppSTbmmKaY7TDtMx83MzaLN1pk1mz0x1zLnm+eb15vft2BaeFostqi2uGVJsuRaplnutrxuhVo5WaVYVVpds0atna0l1rutu6cRp7lOk06rntZnw7Dxtsm2qbcZsOXYBtuutm22fWFnYhdnt8Wuw+6TvZN9un2N/T0HDYfZDqsdWh1+c7RyFDpWOt6azpzuP33F9JbpL2dYzxDP2DPjthPLKcRpnVOb00dnF2e5c4PziIuJS4LLLpc+Lpsbxt3IveRKdPVxXeF60vWdm7Obwu2o26/uNu5p7ofcn8w0nymeWTNz0MPIQ+BR5dE/C5+VMGvfrH5PQ0+BZ7XnIy9jL5FXrdewt6V3qvdh7xc+9j5yn+M+4zw33jLeWV/MN8C3yLfLT8Nvnl+F30N/I/9k/3r/0QCngCUBZwOJgUGBWwL7+Hp8Ib+OPzrbZfay2e1BjKC5QRVBj4KtguXBrSFoyOyQrSH355jOkc5pDoVQfujW0Adh5mGLw34MJ4WHhVeGP45wiFga0TGXNXfR3ENz30T6RJZE3ptnMU85ry1KNSo+qi5qPNo3ujS6P8YuZlnM1VidWElsSxw5LiquNm5svt/87fOH4p3iC+N7F5gvyF1weaHOwvSFpxapLhIsOpZATIhOOJTwQRAqqBaMJfITdyWOCnnCHcJnIi/RNtGI2ENcKh5O8kgqTXqS7JG8NXkkxTOlLOW5hCepkLxMDUzdmzqeFpp2IG0yPTq9MYOSkZBxQqohTZO2Z+pn5mZ2y6xlhbL+xW6Lty8elQfJa7OQrAVZLQq2QqboVFoo1yoHsmdlV2a/zYnKOZarnivN7cyzytuQN5zvn//tEsIS4ZK2pYZLVy0dWOa9rGo5sjxxedsK4xUFK4ZWBqw8uIq2Km3VT6vtV5eufr0mek1rgV7ByoLBtQFr6wtVCuWFfevc1+1dT1gvWd+1YfqGnRs+FYmKrhTbF5cVf9go3HjlG4dvyr+Z3JS0qavEuWTPZtJm6ebeLZ5bDpaql+aXDm4N2dq0Dd9WtO319kXbL5fNKNu7g7ZDuaO/PLi8ZafJzs07P1SkVPRU+lQ27tLdtWHX+G7R7ht7vPY07NXbW7z3/T7JvttVAVVN1WbVZftJ+7P3P66Jqun4lvttXa1ObXHtxwPSA/0HIw6217nU1R3SPVRSj9Yr60cOxx++/p3vdy0NNg1VjZzG4iNwRHnk6fcJ3/ceDTradox7rOEH0x92HWcdL2pCmvKaRptTmvtbYlu6T8w+0dbq3nr8R9sfD5w0PFl5SvNUyWna6YLTk2fyz4ydlZ19fi753GDborZ752PO32oPb++6EHTh0kX/i+c7vDvOXPK4dPKy2+UTV7hXmq86X23qdOo8/pPTT8e7nLuarrlca7nuer21e2b36RueN87d9L158Rb/1tWeOT3dvfN6b/fF9/XfFt1+cif9zsu72Xcn7q28T7xf9EDtQdlD3YfVP1v+3Njv3H9qwHeg89HcR/cGhYPP/pH1jw9DBY+Zj8uGDYbrnjg+OTniP3L96fynQ89kzyaeF/6i/suuFxYvfvjV69fO0ZjRoZfyl5O/bXyl/erA6xmv28bCxh6+yXgzMV70VvvtwXfcdx3vo98PT+R8IH8o/2j5sfVT0Kf7kxmTk/8EA5jz/GMzLdsAAAAgY0hSTQAAeiUAAICDAAD5/wAAgOkAAHUwAADqYAAAOpgAABdvkl/FRgAAAZxJREFUeNqU001IVFEYxvGfc0dHxTKTPmBy0dSAKUItgiIKajLUokWu2oqYJC2kTS0CNwPVQoM+DQuqhW1mqUSIkAQtgjaCREHRok3UKoSYampzr1wu5uQDB855zvs/533PR83+4gYJdWAQvdgZeh/wDFNYigenYv063MIiRtGOTNj2hN4i7qEhgtIxeAbHra0UziEfZliOMpj4DziuYxiPVuwMV62qM/sG4sNhdKbCAwuqwUfyfUaOjsWtAINp9FSD21pyxk7fl0nXJ6d6Usgl3dqgzqbGVlBf2+Bq/xNNmY2evr6bDM2lks7etoMeDyy42H0dXOq5Ib+1y4OX19ycv5IML6fDR9IeOa1N221u3KK7o9+35S/6us569Grc5EJxteo+BdlCZjcORM7Hr289Xyo5tOuEw/lepTdTJuYu/+t4poNsIfM5vMaVcpbL3714N2tb8w7FmQsqfyqrwb8xVBP+hds4b326g5Fo11HMrQOeD5mVtMs4GWZSWQOsYBKnQkaQLWTiNc2ihJ9oQTN+4D2mMYSH+BVBfwcAR2JZGqsMussAAAAASUVORK5CYII=" width="16" height="16" alt="Arrow" /></span></td>
                                                                <td width="83%"><span class="sectionHeading">Credit Enquiries </span></td>
                                                                @if(count((array)$Co_Enquiries) > 0)
                                                                    <td width="13%" class="subHeding"><?php echo count((array)$Co_Enquiries)?></td>
                                                                @else
                                                                    <td width="13%" class="subHeding">No Records Found</td>
                                                                @endif
                                                            </tr>
                                                        </table>
                                                    </td>
                                                </tr>
                                                <tr>
                                                    <td height="25" style="border-top:1px solid #E5E5E5;"><span class="sectionTooltip" >&nbsp;&nbsp;&nbsp;This section shows the names of the credit institutions that have processed a credit / loan application for you.</span></td>
                                                </tr>
                                            </table>
                                        </td>
                                    </tr>
                                    @if(count((array)$Co_Enquiries) > 0 && !empty($Co_Enquiries))
                                    <tr>
                                        <td valign="top" bgcolor="#FFFFFF">
                                            <div class="reportDetailWrap">
                                                <table width="100%" border="0" align="center" cellpadding="5" cellspacing="0" class="reportCapEnquiryDetails" style="border-color: #333 !important;">
                                                    <tr>
                                                        <td valign="top" class="subHeding" style="border:1px solid #E5E5E5;">Sr. No</td>
                                                        <td valign="top" style="border:1px solid #E5E5E5;" class="subHeding">Enquiry Date</td>
                                                        <td valign="top" style="border:1px solid #E5E5E5;" class="subHeding">Member Type</td>
                                                        <td valign="top" style="border:1px solid #e5e5e5;" class="subHeding">Purpose</td>
                                                        <td valign="top" style="border:1px solid #e5e5e5;" class="subHeding">Enquiry Amount</td>
                                                        <td valign="top" style="border:1px solid #e5e5e5;" class="subHeding">Enquiry Type</td>
                                                    </tr>
                                                    <?php $nKeysEs = 1; ?>
                                                    @foreach($Co_Enquiries as $key=>$credit_caps_detail)
                                                        <tr>
                                                            <?php
                                                                if($nKeysEs==5){
                                                                    break;
                                                                }
                                                            ?>
                                                            <td style="border:1px solid #e5e5e5;" class="sectionDataElementValues summaryDetailColumn" >{!! $nKeysEs !!}</td>
                                                            <td style="border:1px solid #e5e5e5;" class="sectionDataElementValues summaryDetailColumn" ><?php echo !empty($credit_caps_detail->Date_of_Request) && !empty($credit_caps_detail->ReportTime) ? \Carbon\Carbon::parse($credit_caps_detail->Date_of_Request)->format('d-M-Y').' '.\Carbon\Carbon::parse($credit_caps_detail->ReportTime)->format('H:i:s') : '-'?></td>
                                                            <td style="border:1px solid #e5e5e5;" class="sectionDataElementValues summaryDetailColumn" >-</td>
                                                            <td style="border:1px solid #e5e5e5;" class="sectionDataElementValues summaryDetailColumn" ><?php echo !empty($credit_caps_detail->Enquiry_Reason) && array_key_exists((int)$credit_caps_detail->Enquiry_Reason, $accountType) ? $accountType[(int)$credit_caps_detail->Enquiry_Reason] : '-' ?></td>
                                                            <td style="border:1px solid #e5e5e5;" class="sectionDataElementValues summaryDetailColumn" ><?php echo !empty($credit_caps_detail->Amount_Financed) ? $credit_caps_detail->Amount_Financed : '-'?></td>
                                                            <td style="border:1px solid #e5e5e5;" class="sectionDataElementValues summaryDetailColumn" >Credit</td>
                                                        </tr>
                                                        <?php $nKeysEs++; ?>
                                                    @endforeach
                                                </table>
                                            </div>
                                        </td>
                                    </tr>
                                        @endif
                                </table>
                            </div>
                        </div>
                    </div>
                </div>
                    @endif
                    @if(isset($finbit_data) and count($finbit_data) > 0)

                        <?php
                        $table = '';
                        $tableCoApplicant = '';

                        foreach($finbit_data as $finbit){

                                $type = $finbit->applicant_type == 2 ? 2 : 1;
                                $accountHolder = '-';
                                foreach ($finbit->consumer_application_file as $item) {
                                    if ($finbit->finbit_uid == str_replace('"',"",$item->accountUID)) {
                                        $fraudReport = \App\FraudReport::where('consumer_application_file_id', $item->id)->first(['accountHolder']);
                                        $accountHolder = isset($fraudReport->accountHolder) ? $fraudReport->accountHolder : '-';
                                    }
                                }

                            if($type == 1){
                            $average_balance = isset($finbit->average_balance) && $finbit->average_balance > 0 ? money_format('%!i',$finbit->average_balance) : '-';
                            $average_balance_three_months = isset($finbit->average_balance_three_months) && $finbit->average_balance_three_months > 0 ? money_format('%!i',$finbit->average_balance_three_months) : '-';
                            $avg_emi_three_months = isset($finbit->avg_emi_three_months) && $finbit->avg_emi_three_months > 0 ? money_format('%!i',$finbit->avg_emi_three_months) : '-';
                            $table .= '<tr><td>'.$finbit->consumer_application->name.'</td>'.
                                '<td>'.$accountHolder.'</td>'.
                                '<td>'.$finbit->period_from.'</td>'.
                                '<td>'.$finbit->period_too.'</td>'.
                                '<td style="font-family: sans-serif;">&#8377;'.$average_balance.'</td>'.
                                '<td style="font-family: sans-serif;">&#8377;'.$average_balance_three_months.'</td>'.
                                '<td style="font-family: sans-serif;">&#8377;'.$avg_emi_three_months.'</td>'.
                                '<td>'.$finbit->inwards_bounce_transaction.'</td>'.
                                '<td>'.$finbit->outwards_bounce_transaction.'</td>'.
                            '</tr>';
                            }else{
                                $average_balance = isset($finbit->average_balance) && $finbit->average_balance > 0 ? money_format('%!i',$finbit->average_balance) : '-';
                                $average_balance_three_months = isset($finbit->average_balance_three_months) && $finbit->average_balance_three_months > 0 ? money_format('%!i',$finbit->average_balance_three_months) : '-';
                                $avg_emi_three_months = isset($finbit->avg_emi_three_months) && $finbit->avg_emi_three_months > 0 ? money_format('%!i',$finbit->avg_emi_three_months) : '-';
                                $tableCoApplicant = '<tr><td>'.$finbit->consumer_application->co_applicant_name.'</td>'.
                                    '<td>'.$accountHolder.'</td>'.
                                    '<td>'.$finbit->period_from.'</td>'.
                                    '<td>'.$finbit->period_too.'</td>'.
                                    '<td style="font-family: sans-serif;">&#8377;'.$average_balance.'</td>'.
                                    '<td style="font-family: sans-serif;">&#8377;'.$average_balance_three_months.'</td>'.
                                    '<td style="font-family: sans-serif;">&#8377;'.$avg_emi_three_months.'</td>'.
                                    '<td>'.$finbit->inwards_bounce_transaction.'</td>'.
                                    '<td>'.$finbit->outwards_bounce_transaction.'</td>'.
                                    '</tr>';
                            }
                        }
                            ?>
                    @endif

                    @if(isset($dataApplicant) || isset($dataCoApplicant))
                    <?php
                        $pirimid_table = "";
                        $co_pirimid_table = "";
                        if(isset($dataApplicant) && count($dataApplicant)){
                            $pirimid_table .= '<tr><td>'.$dataApplicant['name'].'</td>'.
                                '<td>'.$dataApplicant['name'].'</td>'.
                                '<td>'.$dataApplicant['startDate'].'</td>'.
                                '<td>'.$dataApplicant['endDate'].'</td>'.
                                '<td style="font-family: sans-serif;">&#8377;'.$dataApplicant['avgBalance'].'</td>'.
                                '<td style="font-family: sans-serif;">&#8377;'.$dataApplicant['adjustedAvgBalance'].'</td>'.
                                '<td>'.$dataApplicant['noOfEmiBounces'].'</td>'.
                                '<td style="font-family: sans-serif;">&#8377;'.$dataApplicant['inwardChequeBounce'].'</td>'.
                                '<td style="font-family: sans-serif;">&#8377;'.$dataApplicant['outwardChequeBounce'].'</td>'.
                                '<td style="font-family: sans-serif;">&#8377;'.$dataApplicant['avgMonthlyEmi'].'</td>'.
                                '<td>'.$dataApplicant['speculativeTradeCount'].'</td>'.
                                '<td style="font-family: sans-serif;">&#8377;'.$dataApplicant['speculativeTradeAmount'].'</td>'.
                            '</tr>';
                        }
                        if(isset($dataCoApplicant) && count($dataCoApplicant)){
                            $co_pirimid_table .= '<tr><td>'.$dataCoApplicant['name'].'</td>'.
                                '<td>'.$dataCoApplicant['name'].'</td>'.
                                '<td>'.$dataCoApplicant['startDate'].'</td>'.
                                '<td>'.$dataCoApplicant['endDate'].'</td>'.
                                '<td style="font-family: sans-serif;">&#8377;'.$dataCoApplicant['avgBalance'].'</td>'.
                                '<td style="font-family: sans-serif;">&#8377;'.$dataCoApplicant['adjustedAvgBalance'].'</td>'.
                                '<td>'.$dataCoApplicant['noOfEmiBounces'].'</td>'.
                                '<td style="font-family: sans-serif;">&#8377;'.$dataCoApplicant['inwardChequeBounce'].'</td>'.
                                '<td style="font-family: sans-serif;">&#8377;'.$dataCoApplicant['outwardChequeBounce'].'</td>'.
                                '<td style="font-family: sans-serif;">&#8377;'.$dataCoApplicant['avgMonthlyEmi'].'</td>'.
                                '<td>'.$dataCoApplicant['speculativeTradeCount'].'</td>'.
                                '<td style="font-family: sans-serif;">&#8377;'.$dataCoApplicant['speculativeTradeAmount'].'</td>'.
                            '</tr>';
                        }
                    ?>
                    @endif
                    @if(isset($pirimid_table) && $pirimid_table != "" && false)
                    <div class="col-md-12" style="background-color: #f2f3f8;padding-top: 5px;">
                        <div class="panel panel-warning" style="padding: 9px;background-color: white;">
                            <div class="panel-heading"><h5>Pirimid Account Details - Applicant</h5></div>
                            <div class="panel-body" style="overflow-y: scroll">
                                <table class="table">
                                    <tr>
                                        <th>Name</th>
                                        <th>Account Holder Name</th>
                                        <th>Statement From</th>
                                        <th>Statement Too</th>
                                        <th>Average Balance</th>
                                        <th>Adjusted Average balance</th>
                                        <th>No. EMI Bounces</th>
                                        <th>Inwards Cheque Bounce Txns</th>
                                        <th>Outward Cheque Bounce Txns</th>
                                        <th>Average Monthly EMI Amount</th>
                                        <th>Speculative Trade Count</th>
                                        <th>Speculative Trade Amount</th>
                                    </tr>
                                    {!! $pirimid_table !!}
                                </table>
                            </div>
                        </div>
                    </div>
                    @endif
                    @if(isset($co_pirimid_table) && $co_pirimid_table != "" && false)
                        <div class="col-md-12" style="background-color: #f2f3f8;padding-top: 5px;">
                            <div class="panel panel-warning" style="padding: 9px;background-color: white;">
                                <div class="panel-heading"><h5>Pirimid Account Details - Co-Applicant</h5></div>
                                <div class="panel-body" style="overflow-y: scroll">
                                    <table class="table">
                                        <tr>
                                            <th>Name</th>
                                            <th>Account Holder Name</th>
                                            <th>Statement From</th>
                                            <th>Statement Too</th>
                                            <th>Average Balance</th>
                                            <th>Adjusted Average balance</th>
                                            <th>No. EMI Bounces</th>
                                            <th>Inwards Cheque Bounce Txns</th>
                                            <th>Outward Cheque Bounce Txns</th>
                                            <th>Average Monthly EMI Amount</th>
                                            <th>Speculative Trade Count</th>
                                            <th>Speculative Trade Amount</th>
                                        </tr>
                                        {!! $co_pirimid_table !!}
                                    </table>
                                </div>
                            </div>
                        </div>
                    @endif
                    @if(isset($table) && $table)
                        <div class="col-md-12" style="background-color: #f2f3f8;padding-top: 5px;">
                            <div class="panel panel-warning" style="padding: 9px;background-color: white;">
                                <div class="panel-heading"><h5>Finbit Account Details - Applicant</h5></div>
                                <div class="panel-body" style="overflow-y: scroll">
                                    <table class="table">
                                        <tr>
                                            <th>Name</th>
                                            <th>Account Holder Name</th>
                                            <th>Statement From</th>
                                            <th>Statement Too</th>
                                            <th>Average balance</th>
                                            <th>Average balance 3 months</th>
                                            <th>Average EMI 3 months</th>
                                            <th>Inwards Bounce Transaction</th>
                                            <th>Outwards Bounce Transaction</th>
                                        </tr>
                                        {!! $table !!}
                                    </table>
                                </div>
                            </div>
                        </div>
                    @endif
                        @if(isset($tableCoApplicant) && $tableCoApplicant)
                            <div class="col-md-12" style="background-color: #f2f3f8;padding-top: 5px;">
                                <div class="panel panel-warning" style="padding: 9px;background-color: white;">
                                    <div class="panel-heading"><h5>Finbit Account Details - Co-Applicant</h5></div>
                                    <div class="panel-body" style="overflow-y: scroll">
                                        <table class="table">
                                            <tr>
                                                <th>Name</th>
                                                <th>Account Holder Name</th>
                                                <th>Statement From</th>
                                                <th>Statement Too</th>
                                                <th>Average balance</th>
                                                <th>Average balance 3 months</th>
                                                <th>Average EMI 3 months</th>
                                                <th>Inwards Bounce Transaction</th>
                                                <th>Outwards Bounce Transaction</th>
                                            </tr>
                                            {!! $tableCoApplicant !!}
                                        </table>
                                    </div>
                                </div>
                            </div>
                        @endif

                        @if(isset($dataApplicant['salaryList']) and count($dataApplicant['salaryList']) > 0 && false)
                            <div class="col-md-12" style="background-color: #f2f3f8;padding-top: 5px;">
                                <div class="panel panel-warning" style="padding: 9px;background-color: white;">
                                    <div class="panel-heading"><h5>Salary Details of Applicant</h5></div>
                                    <div class="panel-body" style="overflow-y: scroll">
                                        <table class="table">
                                            <tr>
                                            <th>Amount of Salary</th>
                                            @foreach($dataApplicant['salaryList'] as $salary)
                                                <td style="font-family: sans-serif;">&#8377; {{ $salary['amount'] or '-' }}</td>
                                            @endforeach
                                            </tr>
                                            <tr>
                                            <th>Date Salary was credited</th>
                                            @foreach($dataApplicant['salaryList'] as $salary)
                                                <td>{!! $salary['date'] or '-' !!}</td>
                                            @endforeach
                                            </tr>
                                        </table>
                                    </div>
                                </div>
                            </div>
                        @endif

                        @if(isset($dataCoApplicant['salaryList']) and count($dataCoApplicant['salaryList']) > 0  && false)
                            <div class="col-md-12" style="background-color: #f2f3f8;padding-top: 5px;">
                                <div class="panel panel-warning" style="padding: 9px;background-color: white;">
                                    <div class="panel-heading"><h5>Salary Details of Applicant</h5></div>
                                    <div class="panel-body" style="overflow-y: scroll">
                                        <table class="table">
                                            <tr>
                                            <th>Amount of Salary</th>
                                            @foreach($dataCoApplicant['salaryList'] as $salary)
                                                <td style="font-family: sans-serif;">&#8377; {{ $salary['amount'] or '-' }}</td>
                                            @endforeach
                                            </tr>
                                            <tr>
                                            <th>Date Salary was credited</th>
                                            @foreach($dataCoApplicant['salaryList'] as $salary)
                                                <td>{!! $salary['date'] or '-' !!}</td>
                                            @endforeach
                                            </tr>
                                        </table>
                                    </div>
                                </div>
                            </div>
                        @endif
                       
                    @if(isset($epfReport) and count($epfReport) > 0)
                        <div class="col-md-12" style="background-color: #f2f3f8;padding-top: 5px;">
                            <div class="panel panel-warning" style="padding: 9px;background-color: white;">
                                <div class="panel-heading"><h5>EPF Details</h5></div>
                                <div class="panel-body" style="overflow-y: scroll">
                                    <table class="table">
                                        <tr>
                                            <th>Applicant Type</th>
                                            <th>Employee Name</th>
                                            <th>Organization Name</th>
                                            <th>isEmployed</th>
                                            <th>isRecent</th>
                                        </tr>
                                        @foreach($epfReport as $epfReportItem)



                                            <?php

                                            // $epf_data = json_decode($epfReportItem->data, 1);
                                            // $isEmployed = $uanNameMatch = false;
                                            // if($epf_data['result']['uan'] && is_array($epf_data['result']['uan']) && !empty($epf_data['result']['uan'])) {
                                            //     foreach ($epf_data['result']['uan'] as $uanData) {
                                            //         foreach ($uanData['employer'] as $uanDataEmployer) {
                                            //             $isEmployed = $uanDataEmployer['isEmployed'] ?? false;
                                            //             $uanNameMatch = $uanDataEmployer['uanNameMatch'] ?? false;
                                            //         }
                                            //     }
                                            // }else{
                                            //         $isEmployed = isset($epf_data['result']['nameLookup']['isEmployed']) ? $epf_data['result']['nameLookup']['isEmployed'] : '-';
                                            //         $uanNameMatch = isset($epf_data['result']['nameLookup']['uanNameMatch']) ? $epf_data['result']['nameLookup']['uanNameMatch'] : '-';
                                            // }

                                            if(isset($epfReportItem['data'])){
                                                $epf_data = json_decode($epfReportItem['data'], 1);
                                                $isEmployed = $isRecent = false;
                                                $summary = $epf_data['result']['summary'];
                                                if (isset($summary)){
                                                    $current_employer = $summary['uanLookup']['currentEmployer'] ?? '';
                                                    // $employee_name = $summary['nameLookup']['matchName'] ?? "";
                                                    if($current_employer){
                                                        $uan_data = $epf_data['result']['uan'];
                                                        foreach ($uan_data as $data) {}
                                                        $current_employer_details = array_filter($data['employer'], function($employer) use ($current_employer) {
                                                            return $employer['name'] === $current_employer;
                                                        });
                                                        if($current_employer_details){
                                                            $firstEmployer = reset($current_employer_details);
                                                            $employee_name = $firstEmployer['matchName'] ?? "";
                                                            $isEmployed = $firstEmployer['isEmployed'] ?? null;
                                                            $isRecent   = $firstEmployer['isRecent'] ?? null;
                                                        }
                                                    }
                                                    else if (isset($epf_data['result']['nameLookup']['organizationName'])) {
                                                        $current_employer = $epf_data['result']['nameLookup']['organizationName'];
                                                        $employee_name = $epf_data['result']['nameLookup']['employeeName'] ?? "";
                                                        $isEmployed = $epf_data['result']['nameLookup']['isEmployed'] ?? "";
                                                        $isRecent = $epf_data['result']['nameLookup']['isRecent'] ?? "";
                                                    }
                                                }
                                            }
                                            // }else{
                                            //         $isEmployed = isset($epf_data['result']['nameLookup']['isEmployed']) ? $epf_data['result']['nameLookup']['isEmployed'] : '-';
                                            //         $uanNameMatch = isset($epf_data['result']['nameLookup']['uanNameMatch']) ? $epf_data['result']['nameLookup']['uanNameMatch'] : '-';
                                            // }

                                            ?>



                                            <tr>
                                                <td><?php echo isset($epfReportItem['applicant_type']) && $epfReportItem['applicant_type'] == 1 ? 'Applicant' : 'Co-Applicant' ?></td>
                                                <!-- <td>{!! $epfReportItem->employeeName or '' !!}</td> -->
                                                <td>{!! $employee_name or '' !!}</td>
                                                <!-- <td>{!! $$epfReportItem->employerName or '' !!}</td> -->
                                                <td>{!! $current_employer or '' !!}</td>
                                                <td><?php echo ($isEmployed && $isEmployed !== '-') ? 'Yes' : (($isEmployed == '-') ? $isEmployed : 'No'); ?></td>
                                                <td><?php echo ($isRecent && $isRecent !== '-') ? 'Yes' : (($isRecent == '-') ? $isRecent : 'No'); ?></td>
                                            </tr>
                                        @endforeach
                                    </table>
                                </div>
                            </div>
                        </div>
                    @endif

                    @if(isset($fraud_report_data) and !empty($fraud_report_data) and count($fraud_report_data) > 0)
                        @include('admin.consumer-application.scorecard.file_validation', ['fraud_report_data' => $fraud_report_data, 'type' => 'Applicant'])

                    @endif

                    @if(isset($fraud_report_coapplicants) and !empty($fraud_report_coapplicants) and count($fraud_report_coapplicants) > 0)
                        @include('admin.consumer-application.scorecard.file_validation', ['fraud_report_data' => $fraud_report_coapplicants, 'type' => 'Co-Applicant'])

                    @endif


                    {{-- @if(isset($bounce_charges) and count($bounce_charges) > 0)
                        <div class="col-md-12" style="background-color: #f2f3f8;padding-top: 5px;">
                            <div class="panel panel-warning" style="padding: 9px;background-color: white;">
                                <div class="panel-heading"><h5>Bounce Transaction</h5></div>
                                <div class="panel-body" style="overflow-y: scroll">
                                    <table class="table">
                                        <tr>
                                            <th>Transsaction Type</th>
                                            <th>Date</th>
                                            <th>Description</th>
                                            <th>Category</th>
                                            <th>Amount</th>
                                            <th>Transaction Type</th>
                                            <th>Balance</th>
                                            <th>Remark</th>
                                        </tr>
                                        @foreach($bounce_charges as $bounce_charge)
                                            <tr>
                                                <td>{!! $bounce_charge->transsaction_type !!}</td>
                                                <td>{!! $bounce_charge->date !!}</td>
                                                <td>{!! $bounce_charge->description !!}</td>
                                                <td>{!! $bounce_charge->category !!}</td>
                                                <td style="font-family: sans-serif;">&#8377;{!! money_format('%!i',$bounce_charge->amount) !!}</td>
                                                <td>{!! $bounce_charge->transactionType !!}</td>
                                                <td style="font-family: sans-serif;">&#8377;{!! money_format('%!i',$bounce_charge->balance) !!}</td>
                                                <td>{!! $bounce_charge->remark !!}</td>

                                            </tr>
                                        @endforeach

                                    </table>
                                </div>
                            </div>
                        </div>
                    @endif --}}
                    @if(isset($dataApplicant['bounceTransactions']) and count($dataApplicant['bounceTransactions']) > 0 && false)
                        <div class="col-md-12" style="background-color: #f2f3f8; padding-top: 5px;">
                            <div class="panel panel-warning" style="padding: 9px; background-color: white;">
                                <div class="panel-heading d-flex justify-content-between align-items-center" style="cursor: pointer;" data-toggle="collapse" data-target="#bounceTransactionsCollapse" aria-expanded="false" aria-controls="bounceTransactionsCollapse">
                                    <h5 style="margin: 0;">Bounce Transaction (Applicant)</h5>
                                    <span class="badge badge-info">{{ count($dataApplicant['bounceTransactions']) }}</span>
                                </div>
                    
                                <div id="bounceTransactionsCollapse" class="panel-collapse collapse">
                                    <div class="panel-body" style="overflow-y: auto;">
                                        <table class="table table-bordered table-striped mt-3">
                                            <thead class="thead-dark">
                                                <tr>
                                                    <th>Transaction Type</th>
                                                    <th>Date</th>
                                                    <th>Description</th>
                                                    <th>Category</th>
                                                    <th>Amount</th>
                                                    <th>Transaction Type</th>
                                                    <th>Balance</th>
                                                    <th>Remark</th>
                                                </tr>
                                            </thead>
                                            <tbody>
                                                @foreach($dataApplicant['bounceTransactions'] as $transaction)
                                                    <tr>
                                                        <td>{!! $transaction['counterParty'] !!}</td>
                                                        <td>{!! $transaction['dateOfTransaction'] !!}</td>
                                                        <td>{!! $transaction['narration'] !!}</td>
                                                        <td>{!! $transaction['category'] !!}</td>
                                                        <td style="font-family: sans-serif;">&#8377;{!! number_format($transaction['amount'], 2) !!}</td>
                                                        <td>{!! $transaction['type'] !!}</td>
                                                        <td style="font-family: sans-serif;">&#8377;{!! number_format($transaction['balance'], 2) !!}</td>
                                                        <td>{!! $transaction['reference'] !!}</td>
                                                    </tr>
                                                @endforeach
                                            </tbody>
                                        </table>
                                    </div>
                                </div>
                            </div>
                        </div>
                    @endif
                
                    @if(isset($dataCoApplicant['bounceTransactions']) and count($dataCoApplicant['bounceTransactions']) > 0 && false)
                        <div class="col-md-12" style="background-color: #f2f3f8; padding-top: 5px;">
                            <div class="panel panel-warning" style="padding: 9px; background-color: white;">
                                <div class="panel-heading d-flex justify-content-between align-items-center" style="cursor: pointer;" data-toggle="collapse" data-target="#bounceTransactionsCollapse" aria-expanded="false" aria-controls="bounceTransactionsCollapse">
                                    <h5 style="margin: 0;">Bounce Transactions (Co-Applicant)</h5>
                                    <span class="badge badge-info">{{ count($dataCoApplicant['bounceTransactions']) }}</span>
                                </div>
                    
                                <div id="bounceTransactionsCollapse" class="panel-collapse collapse">
                                    <div class="panel-body" style="overflow-y: auto;">
                                        <table class="table table-bordered table-striped mt-3">
                                            <thead class="thead-dark">
                                                <tr>
                                                    <th>Transaction Type</th>
                                                    <th>Date</th>
                                                    <th>Description</th>
                                                    <th>Category</th>
                                                    <th>Amount</th>
                                                    <th>Transaction Type</th>
                                                    <th>Balance</th>
                                                    <th>Remark</th>
                                                </tr>
                                            </thead>
                                            <tbody>
                                                @foreach($dataCoApplicant['bounceTransactions'] as $transaction)
                                                    <tr>
                                                        <td>{!! $transaction['counterParty'] !!}</td>
                                                        <td>{!! $transaction['dateOfTransaction'] !!}</td>
                                                        <td>{!! $transaction['narration'] !!}</td>
                                                        <td>{!! $transaction['category'] !!}</td>
                                                        <td style="font-family: sans-serif;">&#8377;{!! number_format($transaction['amount'], 2) !!}</td>
                                                        <td>{!! $transaction['type'] !!}</td>
                                                        <td style="font-family: sans-serif;">&#8377;{!! number_format($transaction['balance'], 2) !!}</td>
                                                        <td>{!! $transaction['reference'] !!}</td>
                                                    </tr>
                                                @endforeach
                                            </tbody>
                                        </table>
                                    </div>
                                </div>
                            </div>
                        </div>
                    @endif

                    @if(isset($dataApplicant['fcuIndicatorTransactions']) && count($dataApplicant['fcuIndicatorTransactions']) > 0 && false)
                        <div class="col-md-12" style="background-color: #f2f3f8; padding: 10px;">
                            <div class="panel panel-warning" style="padding: 9px; background-color: white;">

                                {{-- Collapsible toggle for main section --}}
                                <div class="panel-heading" style="cursor: pointer;" data-toggle="collapse" data-target="#riskEventsCollapse" aria-expanded="false" aria-controls="riskEventsCollapse">
                                    <h5>
                                        Risk Events Transactions (Applicant)
                                        <span class="float-right">&#9660;</span> {{-- Down arrow icon --}}
                                    </h5>
                                </div>

                                {{-- Collapsible content --}}
                                <div id="riskEventsCollapse" class="collapse show">
                                    @php
                                        $fcuData = $dataApplicant['fcuIndicatorTransactions'];
                                        $sectionTitles = [
                                            'fraudIndicators' => 'Fraud Indicators',
                                            'behaviouralIndicators' => 'Behavioural Indicators',
                                            'riskIndicators' => 'Risk Indicators'
                                        ];
                                    @endphp

                                    @foreach($sectionTitles as $sectionKey => $sectionTitle)
                                        @if(isset($fcuData[$sectionKey]))
                                            <h5 class="text-secondary mt-3" style="margin-top: 20px; border-bottom: 1px solid #000000; padding-bottom: 5px;">
                                                <strong style="color: #2b0947">{{ $sectionTitle }}</strong>
                                            </h5>

                                            <div class="panel-group" id="accordion-{{ $sectionKey }}">
                                                @foreach($fcuData[$sectionKey] as $indicatorKey => $indicator)
                                                    @if(isset($indicator['transactions']) && count($indicator['transactions']) > 0)
                                                        <div class="panel panel-default" style="border: none; box-shadow: none;">
                                                            <div class="panel-heading" style="background-color: #f9f9f9; padding: 10px 15px; cursor: pointer;" data-toggle="collapse" data-parent="#accordion-{{ $sectionKey }}" href="#collapse-{{ $sectionKey }}-{{ $loop->index }}">
                                                                <h5 class="panel-title" style="margin: 0; font-size: 16px; font-weight: 600;">
                                                                    {{ ucwords(preg_replace('/([a-z])([A-Z])/', '$1 $2', str_replace('_', ' ', $indicatorKey))) }}
                                                                    <span class="badge badge-info" style="background-color: #17a2b8; float: right;">{{ count($indicator['transactions']) }}</span>
                                                                </h5>
                                                            </div>
                                                            <div id="collapse-{{ $sectionKey }}-{{ $loop->index }}" class="panel-collapse collapse">
                                                                <div class="panel-body" style="max-height: 400px; overflow-y: auto; padding: 10px;">
                                                                    <table class="table table-bordered table-hover table-sm">
                                                                        <thead class="thead-light">
                                                                            <tr>
                                                                                @foreach(array_keys($indicator['transactions'][0]) as $header)
                                                                                    <th>{{ ucwords(str_replace('_', ' ', $header)) }}</th>
                                                                                @endforeach
                                                                            </tr>
                                                                        </thead>
                                                                        <tbody>
                                                                            @foreach($indicator['transactions'] as $txn)
                                                                                <tr>
                                                                                    @foreach($txn as $value)
                                                                                        <td>{{ $value }}</td>
                                                                                    @endforeach
                                                                                </tr>
                                                                            @endforeach
                                                                        </tbody>
                                                                    </table>
                                                                </div>
                                                            </div>
                                                        </div>
                                                    @endif
                                                @endforeach
                                            </div>
                                        @endif
                                    @endforeach
                                </div>
                            </div>
                        </div>
                    @endif

                    @if(isset($dataCoApplicant['fcuIndicatorTransactions']) && count($dataCoApplicant['fcuIndicatorTransactions']) > 0 && false)
                        <div class="col-md-12" style="background-color: #f2f3f8; padding: 10px;">
                            <div class="panel panel-warning" style="padding: 9px; background-color: white;">
                                <div class="panel-heading" style="cursor: pointer;" data-toggle="collapse" data-target="#coApplicantRiskEvents" aria-expanded="true" aria-controls="coApplicantRiskEvents">
                                    <h5>
                                        Risk Events Transactions (Co-Applicant)
                                        <span style="float: right;"><i class="fa fa-chevron-down"></i></span>
                                    </h5>
                                </div>
                                <div id="coApplicantRiskEvents" class="collapse show">
                                    @php
                                        $fcuData = $dataCoApplicant['fcuIndicatorTransactions'];
                                        $sectionTitles = [
                                            'fraudIndicators' => 'Fraud Indicators',
                                            'behaviouralIndicators' => 'Behavioural Indicators',
                                            'riskIndicators' => 'Risk Indicators'
                                        ];
                                    @endphp

                                    @foreach($sectionTitles as $sectionKey => $sectionTitle)
                                        @if(isset($fcuData[$sectionKey]))
                                            <h5 class="text-secondary mt-3" style="margin-top: 20px; border-bottom: 1px solid #000000; padding-bottom: 5px;">
                                                <strong style="color: #2b0947">{{ $sectionTitle }}</strong>
                                            </h5>

                                            <div class="panel-group" id="accordion-{{ $sectionKey }}-coapp">
                                                @foreach($fcuData[$sectionKey] as $indicatorKey => $indicator)
                                                    @if(isset($indicator['transactions']) && count($indicator['transactions']) > 0)
                                                        <div class="panel panel-default" style="border: none; box-shadow: none;">
                                                            <div class="panel-heading" style="background-color: #f9f9f9; padding: 10px 15px; cursor: pointer;" data-toggle="collapse" data-parent="#accordion-{{ $sectionKey }}-coapp" href="#collapse-{{ $sectionKey }}-coapp-{{ $loop->index }}">
                                                                <h5 class="panel-title" style="margin: 0; font-size: 16px; font-weight: 600;">
                                                                    {{ ucwords(preg_replace('/([a-z])([A-Z])/', '$1 $2', str_replace('_', ' ', $indicatorKey))) }}
                                                                    <span class="badge badge-info" style="background-color: #17a2b8; float: right;">{{ count($indicator['transactions']) }}</span>
                                                                </h5>
                                                            </div>
                                                            <div id="collapse-{{ $sectionKey }}-coapp-{{ $loop->index }}" class="panel-collapse collapse">
                                                                <div class="panel-body" style="max-height: 400px; overflow-y: auto; padding: 10px;">
                                                                    <table class="table table-bordered table-hover table-sm">
                                                                        <thead class="thead-light">
                                                                            <tr>
                                                                                @foreach(array_keys($indicator['transactions'][0]) as $header)
                                                                                    <th>{{ ucwords(str_replace('_', ' ', $header)) }}</th>
                                                                                @endforeach
                                                                            </tr>
                                                                        </thead>
                                                                        <tbody>
                                                                            @foreach($indicator['transactions'] as $txn)
                                                                                <tr>
                                                                                    @foreach($txn as $value)
                                                                                        <td>{{ $value }}</td>
                                                                                    @endforeach
                                                                                </tr>
                                                                            @endforeach
                                                                        </tbody>
                                                                    </table>
                                                                </div>
                                                            </div>
                                                        </div>
                                                    @endif
                                                @endforeach
                                            </div>
                                        @endif
                                    @endforeach
                                </div>
                            </div>
                        </div>
                    @endif

                    <div class="col-md-12" style="background-color: #f2f3f8;padding-top: 5px;">
                        <div class="panel panel-warning" style="padding: 9px;background-color: white;">
                            <div class="panel-heading"><h5>OUTPUT</h5></div>
                            <div class="panel-body" style="overflow-y: scroll">
                                <table class="table">
                                    @if(\Illuminate\Support\Facades\Session::has('Score_Card_Weights|-18'))
                                    <tr>
                                        <th>Parameter</th>
                                        <th>Value</th>
                                        <th>Score</th>
                                        <th>Max Score</th>
                                    </tr>
                                        @foreach($scoreCard as $item)
                                        <tr>
                                            <td>{!! $item['Parameter'] !!}</td>
                                            <td>{!! $item['value'] !!}</td>
                                            <td>{!! $item['score'] !!}</td>
                                            <td>{!! $item['max_score'] !!}</td>
                                        </tr>
                                        @endforeach
                                    <tr>
                                        <td></td>
                                        <td class="font-weight">Score</td>
                                        <td>{!! $finalScore !!}</td>
                                        <td>{!! $maxScore !!}</td>
                                    </tr>
                                    @endif
                                    <tr>
                                        <td></td>
                                        <td class="font-weight">Category</td>
                                        <td style="color: white;font-size: 19px;font-weight: 600;text-align: center;" class="score-card-{!! $finalCategory !!}">Score : {!! $finalCategory !!}</td>
                                        <td></td>
                                    </tr>
                                </table>
                            </div>
                        </div>
                    </div>

                    @if(isset($telecom_response->result))

                    <div class="col-md-12" style="background-color: #f2f3f8;padding-top: 5px;">
                        <div class="panel panel-warning" style="padding: 9px;background-color: white;">
                            <div class="panel-heading"><h5>Telecom Data</h5></div>
                            <div class="panel-body" style="overflow-y: scroll">
                                <table class="table">
                                        <tr>
                                            <td colspan="4"  style="text-align: center;font-size: large;font-weight: 600;">Contact</td>
                                        </tr>
                                        <tr>
                                            <th>Address</th>
                                            <th>Alt Contact</th>
                                            <th>Email id</th>
                                            <th>Work Email</th>

                                        </tr>
                                            <tr>
                                                <td>{!! $telecom_response->result->contact->address !!}</td>
                                                <td>{!! $telecom_response->result->contact->alt_contact !!}</td>
                                                <td>{!! $telecom_response->result->contact->email_id !!}</td>
                                                <td>{!! $telecom_response->result->contact->work_email !!}</td>

                                            </tr>
                                        <tr>
                                            <td colspan="4"  style="text-align: center;font-size: large;font-weight: 600;">Device</td>
                                        </tr>
                                        <tr>
                                            <th>device_activation_date</th>
                                            <th>imei</th>
                                            <th>model</th>
                                            <th></th>
                                        </tr>
                                        <tr>
                                            <td>{!! $telecom_response->result->device->device_activation_date !!}</td>
                                            <td>{!! $telecom_response->result->device->imei !!}</td>
                                            <td>{!! $telecom_response->result->device->model !!}</td>
                                            <td></td>
                                        </tr>
                                        <tr>
                                            <td colspan="4"  style="text-align: center;font-size: large;font-weight: 600;">Identity</td>
                                        </tr>
                                        <tr>
                                            <th>date_of_birth</th>
                                            <th>gender</th>
                                            <th>name</th>
                                            <th></th>
                                        </tr>
                                        <tr>
                                            <td>{!! $telecom_response->result->identity->date_of_birth !!}</td>
                                            <td>{!! $telecom_response->result->identity->gender !!}</td>
                                            <td>{!! $telecom_response->result->identity->name !!}</td>
                                            <td></td>
                                        </tr>
                                        <tr>
                                            <td colspan="4" style="text-align: center;font-size: large;font-weight: 600;">Sim Details</td>
                                        </tr>
                                        <tr>
                                            <th>activation_date</th>
                                            <th>last_activity_date</th>
                                            <th>provider</th>
                                            <th>type</th>
                                        </tr>
                                        <tr>
                                            <td>{!! $telecom_response->result->sim_details->activation_date !!}</td>
                                            <td>{!! $telecom_response->result->sim_details->last_activity_date !!}</td>
                                            <td>{!! $telecom_response->result->sim_details->provider !!}</td>
                                            <td>{!! $telecom_response->result->sim_details->type !!}</td>
                                        </tr>
                                            @if(isset($telecom_response->result->history))
                                            <tr>
                                                <td colspan="4" style="text-align: center;font-size: large;font-weight: 600;">Payment History</td>
                                            </tr>
                                            <tr>
                                                <th>Amount</th>
                                                <th>Payment Date</th>
                                                <th>Payment Type</th>
                                                <th></th>
                                            </tr>
                                                @foreach($telecom_response->result->history as $payment_history)
                                                <tr>
                                                    <td>{!! $payment_history->amount !!}</td>
                                                    <td>{!! $payment_history->payment_date !!}</td>
                                                    <td>{!! $payment_history->payment_type !!}</td>
                                                    <td></td>
                                                </tr>
                                                @endforeach
                                            @endif
                                        {{--<input type="text" class="form-control" id="otp">--}}
                                        {{--<input type="number" class="form-control" id="mobile_number" name="mobile_number" min="0">--}}

                                        {{--<a href="javascript:void(0)" id="verify_otp" class="submit_otp btn-sm btn btn-primary">Get Telecom Data</a>--}}

                                </table>
                            </div>
                        </div>
                    </div>
                    @endif
                    @if(isset($mobileData) && $mobileData)
                        <div class="col-md-12" style="background-color: #f2f3f8;padding-top: 15px;">
                            <div class="panel panel-default" style="cursor: pointer;padding-bottom: 9px;background-color: #e8e8e8;border: 1px solid #d6d6c8;padding-top: 9px;padding-left: 8px;">
                                <div class="panel-heading"><span class="panel-title" data-toggle="collapse" data-parent="#accordion" href="#mobile_data">Mobile Data (Downloaded on Customer’s Device)</span></div>
                                <div id="mobile_data" style="background-color: white;margin-left: -8px;margin-top: 10px;" class="panel-collapse collapse">


                                    <div class="col-md-12" style="background-color: #f2f3f8;padding-top: 5px;">
                                        <div class="panel panel-default" style="cursor: pointer;padding-bottom: 9px;background-color: #e8e8e8;border: 1px solid #d6d6c8;padding-top: 9px;padding-left: 8px;">
                                            <div class="panel-heading"><span class="panel-title collapsed" data-toggle="collapse" data-parent="#accordion" href="#risky" aria-expanded="false">Risky Applications</span></div>
                                            <div id="risky" style="background-color: white; margin-left: -8px; margin-top: 10px;" class="panel-collapse in collapse">
                                                <div class="panel-body" style="overflow-y: scroll">
                                                    <table class="table">
                                                        @if(isset($mobileData['risky']) && $mobileData['risky'])
                                                            <tr>
                                                                <td>
                                                                    <div>
                                                                        <ul>
                                                                            @foreach($mobileData['risky'] as $risky)
                                                                                <li>{!! $risky !!} | <a target="_blank" href="https://play.google.com/store/apps/details?id=<?php echo $risky; ?>">View on PlayStore</a></li>
                                                                            @endforeach
                                                                        </ul>
                                                                    </div>
                                                                </td>
                                                            </tr>
                                                    @endif
                                                    </table>
                                                </div>
                                            </div>
                                        </div>
                                    </div>

                                    <div class="col-md-12" style="background-color: #f2f3f8;padding-top: 5px;">
                                        <div class="panel panel-default" style="cursor: pointer;padding-bottom: 9px;background-color: #e8e8e8;border: 1px solid #d6d6c8;padding-top: 9px;padding-left: 8px;">
                                            <div class="panel-heading"><span class="panel-title collapsed" data-toggle="collapse" data-parent="#accordion" href="#salary" aria-expanded="false">Salary</span></div>
                                            <div id="salary" style="background-color: white; margin-left: -8px; margin-top: 10px;" class="panel-collapse in collapse">
                                                <div class="panel-body" style="overflow-y: scroll">
                                                    <table class="table">
                                                        @if(isset($mobileData['salary']) && $mobileData['salary'])
                                                            <tr>
                                                                <td>
                                                                    <div>
                                                                        <table class="table">
                                                                            <tr><td>Message</td></tr>
                                                                            @foreach($mobileData['salary'] as $risky)
                                                                                <tr><td style="padding-bottom: 30px;">{!! $risky['message'] !!} <div style="color:red;padding-top: 4px;">{!! $risky['address'] !!} - {!! $risky['date'] !!}</div></td></tr>
                                                                            @endforeach
                                                                        </table>
                                                                    </div>
                                                                </td>
                                                            </tr>
                                                        @endif
                                                    </table>
                                                </div>
                                            </div>
                                        </div>
                                    </div>

                                    <div class="col-md-12" style="background-color: #f2f3f8;padding-top: 5px;padding-bottom: 5px;">
                                        <div class="panel panel-default" style="cursor: pointer;padding-bottom: 9px;background-color: #e8e8e8;border: 1px solid #d6d6c8;padding-top: 9px;padding-left: 8px;">
                                            <div class="panel-heading"><span class="panel-title collapsed" data-toggle="collapse" data-parent="#accordion" href="#charges" aria-expanded="false">Charges Debited/Charged</span></div>
                                            <div id="charges" style="background-color: white; margin-left: -8px; margin-top: 10px;" class="panel-collapse in collapse">
                                                <div class="panel-body" style="overflow-y: scroll">
                                                    <table class="table">
                                                        @if(isset($mobileData['charges']) && $mobileData['charges'])
                                                            <tr>
                                                                <td>
                                                                    <div>
                                                                        <table class="table">
                                                                            <tr><td>Message</td></tr>
                                                                            @foreach($mobileData['charges'] as $risky)
                                                                                <tr><td style="padding-bottom: 30px;">{!! $risky['message'] !!} <div style="color:red;padding-top: 4px;">{!! $risky['address'] !!} - {!! $risky['date'] !!}</div></td></tr>
                                                                            @endforeach
                                                                        </table>
                                                                    </div>
                                                                </td>
                                                            </tr>
                                                        @endif
                                                    </table>
                                                </div>
                                            </div>
                                        </div>
                                    </div>

                                </div>
                            </div>
                        </div>
                    @endif
                </div>
            </div>
        </div>
    </div>
    </div>

    <div class="show-object-view" style="position: fixed;width: 100%;height: 100%;background-color: rgba(0,0,0,0.8);display: none;text-align: center;overflow-y: auto; z-index: 200; top:0;">
    <img class="img-show-object-loader" style="padding-top: 100px;" src="/assets/front/img/loading.gif"/>
    <img class="img-show-object" id="img-show-object-id" style="padding-top: 10px;"/>
    <div id="floating_opt" style="position: fixed; bottom: 10px; width: 100%">
        <span class="rotate-object" style="
        cursor: pointer;
        font-size: 17px;
        background-color: black;
        color: white;
         padding: 5px 15px;
        margin: -2px;
        border-radius: 13px 1px 1px 13px;
    "><i class="fa fa-rotate-right" style="color: white;font-size: 17px;"></i></span>
        <span class="zoomin-object" style="
        cursor: pointer;
        font-size: 17px;
        background-color: black;
        color: white;
         padding: 5px 15px;
        margin: -2px;
    "> <i class="fa fa-search-plus" style="color: white;font-size: 17px;"></i></span>
        <span class="zoomout-object" style="
        cursor: pointer;
        font-size: 17px;
        background-color: black;
        color: white;
         padding: 5px 15px;
        margin: -2px;
    "> <i class="fa fa-search-minus" style="color: white;font-size: 17px;"></i></span>
        <span class="open-in-new-tab" style="
        cursor: pointer;
        font-size: 17px;
        background-color: black;
        color: white;
        padding: 5px 15px;
        margin: -2px;
"> <i class="fa fa-external-link" style="color: white;font-size: 17px;"></i></span>
    <span class="close-object" style="
        /* position: fixed; */
        /* right: 38px; */
        /* top: 20px; */
        cursor: pointer;
        font-size: 17px;
        color: white;
        background-color: black;
        padding: 5px 15px;
        margin: -2px;
        border-radius: 1px 13px 13px 1px;
    "><i class="fa fa-close" style="color: white; font-size: 17px;"></i></span>
    </div>
    </div>

@include('admin.modal.email_reminders')
<!--end::Modal-->
@include("admin.layouts.footer")
<script>
    function opendoc(path){
        if(path.indexOf(".pdf") > 1){
            $(".show-object-view > embed").remove();
            $(".show-object-view > div > span.document-name").remove();
            $("show-object-view > div > span.download-object").css('display', '');
            $(".show-object-view").append('<embed class="pdf-show-object" id="pdf-show-object-id" height="100%" width="100%" src="'+path+'">');
            $(".show-object-view > div > span.download-object").css('display', 'none');
            $(".show-object-view > div > span.pdf_new_tab").css('display', '');
            $(".show-object-view > .img-show-object").attr('src', '').css('display', 'none');
            $("#floating_opt").css('display', 'block');
            $(".show-object-view").css({'display':'block'});
        }else if(path.indexOf(".xls") > 1 || path.indexOf(".xlsx") > 1){
            $(".show-object-view > a").remove();
            $('.show-object-view').append('<a target="_blank" class="link" href="'+path+'">&nbsp;</a>');
            $('.link').click(function() {
                window.location = $(this).attr('href');
            }).click();
            $('.show-object-view').css('display', 'none');
        }else{
            $('#img-show-object-id').attr('src',path);
            $("#floating_opt").css('display', 'block');
            $(".show-object-view").css({'display':'block'});
        }
        // $(".show-object-view").css({'display':'block'});
        setTimeout(function () { $(".show-object-view > .img-show-object-loader").css({position: 'fixed',left: '-50px'}); }, 1500);
    }

    var imgrotate = document.getElementById('img-show-object-id');
    $('.zoomout-object').on('click', function(){
        let width = imgrotate.clientWidth;
        width = width - 250;
        $('img.img-show-object').width(width);
    });

    $('.zoomin-object').on('click', function(){
        let width = imgrotate.clientWidth;
        width = width + 250;
        $('img.img-show-object').width(width);
    });

    var angle = 0;
    $('.rotate-object').on('click', function() {
        angle += 90;
        $(".show-object-view > .img-show-object").css('transform','rotate(' + angle + 'deg)');
    });

    $(".show-object-view > div > span.close-object").click(function () {
        $(".show-object-view > .img-show-object").attr('src','');
        $(".show-object-view > .pdf-show-object").attr('src','');
        $("show-object-view > div > span.download-object").css('display', '');
        $(".show-object-view > .img-show-object-loader").removeAttr('style');
        $(".show-object-view > .img-show-object-loader").attr('style','padding-top:100px;');
        $(".m-scroll-top--shown > .m-scroll-top").css('display', 'block');
        $(".show-object-view").css({'display':'none'});
    });

    $(".open-in-new-tab").on('click', function(){
        let curr_src = $("img.img-show-object").attr('src');
        if(curr_src === ''){
            curr_src = $("embed.pdf-show-object").attr('src')
        }
        window.open(curr_src, '_blank');
        // $(".show-object-view > span.close-object").trigger('click');
    });

    $(function () {
        $('[data-toggle="tooltip"]').tooltip({placement: 'bottom'});
    });

    $(document).on('click', '.verify_number', function() {

        if (resendStatus == true) {
            var mobile_number = $("#mobile_number").val();
                $.ajax({
                    url: site_url + "api/generate-otp",
                    method: 'POST',
                    data: {
                        mobile_number: mobile_number,
                    }
                }).done(function(data) {
                    if(typeof data.error !== 'undefined' && data.error.eligibility !== 0){
                        $("#error_message").modal("show");
                    }else if(data.status === 'fail'){
                        toastr["error"](data.message);
                    }else {
                        if(data.request_id != ""){
                            $("#request_id").val(data.request_id);
                        }
                        $("#otp_wrap").slideDown();
                    }
                });
        } else if (resendStatus == false) {
            toastr["error"]("Retry in " + countDownTimer + " Seconds");
        }
    });
</script>