@extends('layouts.app')

@section('title','Import Monitoring Bank')

@section('content')

<div class="container-fluid">


<div class="row mb-4">

    <div class="col">

        <h2 class="page-title">
            Import Monitoring Bank
        </h2>

        <div class="text-muted">
            Upload laporan neraca BPR dan lakukan validasi sebelum simpan.
        </div>

    </div>

</div>



@if(session('success'))

<div class="alert alert-success">
    {{ session('success') }}
</div>

@endif


@if(session('error'))

<div class="alert alert-danger">
    {{ session('error') }}
</div>

@endif



<div class="card mb-4">

<div class="card-header">

<h3 class="card-title">
Upload File Excel
</h3>

</div>


<div class="card-body">


<form method="POST"
      action="{{ route('import.preview') }}"
      enctype="multipart/form-data">


@csrf



<div class="row">


<div class="col-md-4 mb-3">

<label class="form-label">
File Excel Neraca
</label>


<input type="file"
       name="file"
       class="form-control"
       required>


<div class="form-text">
Format XLSX / XLS
</div>

</div>




<div class="col-md-3 mb-3">

<label class="form-label">
Periode Laporan
</label>


<input type="date"
       name="periode"
       class="form-control"
       required>

</div>




<div class="col-md-2 mb-3">

<label class="form-label">
KAP (%)
</label>


<input type="number"
       step="0.01"
       name="kap"
       class="form-control"
       placeholder="Input KAP">

</div>




<div class="col-md-2 mb-3">

<label class="form-label">
NPL (%)
</label>


<input type="number"
       step="0.01"
       name="npl"
       class="form-control"
       placeholder="Input NPL">

</div>



</div>



<button class="btn btn-primary">

<i class="ti ti-upload"></i>

Baca Excel

</button>


</form>


</div>

</div>





@if($preview)


<div class="card">


<div class="card-header">

<h3 class="card-title">
Preview Monitoring Bank
</h3>

</div>



<div class="card-body">


<table class="table table-bordered">


<tr>
<th>Periode</th>
<td>
{{ $preview['periode'] }}
</td>
</tr>



<tr>
<th>Total Asset</th>
<td>
{{ number_format($preview['asset'],0,',','.') }}
</td>
</tr>



<tr>
<th>Total Kredit</th>
<td>
{{ number_format($preview['kredit'],0,',','.') }}
</td>
</tr>



<tr>
<th>DPK</th>
<td>
{{ number_format($preview['dpk'],0,',','.') }}
</td>
</tr>



<tr>
<th>Laba</th>
<td>
{{ number_format($preview['laba'],0,',','.') }}
</td>
</tr>



<tr>
<th>CR</th>
<td>
{{ $preview['cr'] }} %
</td>
</tr>



<tr>
<th>LDR</th>
<td>
{{ $preview['ldr'] }} %
</td>
</tr>



<tr>
<th>KAP</th>
<td>
{{ $preview['kap'] ?? 0 }} %
</td>
</tr>



<tr>
<th>NPL</th>
<td>
{{ $preview['npl'] ?? 0 }} %
</td>
</tr>


</table>





<form method="POST"
      action="{{ route('import.store') }}">


@csrf


<button class="btn btn-success">

Simpan Monitoring

</button>


</form>


</div>

</div>


@endif



</div>

@endsection