Files
lelong/resources/views/excel/listnotis_excel.blade.php

113 lines
3.3 KiB
PHP

<meta http-equiv="content-type" content="text/html; charset=UTF-8" />
<script src="{{ asset('js/table2excel.js') }}"></script>
<style>
.letter{
font-family:'Times New Roman', Times, serif;
}
.row::after {
content: "";
clear: both;
display: table;
}
.first-prgph{
float: left;
width: 10%;
padding: 2px;
}
.first-prgph1{
float: left;
width: 30%;
padding-left: 50px;
}
.page-break {
page-break-before: always;
}
.name{
padding-top: 40px;
}
</style>
<body>
<div class = "letter">
{{-- <div class="row">
<div class="first-prgph">
<img src="{{ asset('img/icon_pkb.png') }}" alt="PKB LOGO" width="100" height="100">
</div> --}}
<div class="first-prgph1">
<p> {{$caw['caw_name']}}<br>
{{$caw['alamat1']}}<br>
{{$caw['alamat2']}}<br>
No Tel: {{$caw['notel']}}<br>
No Faks: {{$caw['nofaks']}}
</p><br>
</div>
<br>
</div>
<table width="100%" height="168" id="customers">
<thead>
<tr>
<th align="left">No</th>
<th align="left">Nama</th>
<th align="left">No KP</th>
<th align="left">Alamat 1</th>
<th align="left">Alamat 2</th>
<th align="left">Alamat 3</th>
<th align="left">No Rujukan</th>
<th align="left">No Telefon</th>
<th align="left">Tempoh</th>
<th align="left">Pembiayaan</th>
<th align="left">Keuntungan 6 Bulan</th>
<th align="left">Bayaran Telah Dibuat</th>
</tr>
</thead>
@foreach($marhuns as $index1=> $notis)
<tr>
<td>{{ $loop->iteration }} </td>
<td>@foreach($notis['nama'] as $data){{ $data['nama']}}<br>@endforeach</td>
<td>{{ $notis['nokp']}}</td>
<td>@foreach($notis['nama'] as $data){{ $data['alamat1']}}<br>@endforeach</td>
<td>@foreach($notis['nama'] as $data){{ $data['alamat2']}}<br>@endforeach</td>
<td>@foreach($notis['nama'] as $data){{ $data['alamat3']}}<br>@endforeach</td>
<td>@foreach($notis['listsag'] as $item){{ $item['norujukan']}}, <br>@endforeach</td>
<td>@foreach($notis['nama'] as $data)6{{ $data['telefon']}}<br>@endforeach</td>
<td>@foreach($notis['listsag'] as $item){{ $item['tempoh']}}, <br>@endforeach</td>
<td>@foreach($notis['listsag'] as $item){{ number_format($item['pinjaman'], 2, '.', ',')}}, <br>@endforeach</td>
<td>@foreach($notis['listsag'] as $item){{ number_format($item['bakiupah'], 2, '.', ',')}}, <br>@endforeach</td>
<td>{{ number_format($bayaran, 2, '.', ',')}}<br></td>
@endforeach
</div>
</body>
<script src="{{ asset('js/jquery.min.js') }}"></script>
<script>
$(document).ready(function () {
var table2excel = new Table2Excel();
table2excel.export(document.querySelectorAll("#customers"),'senarai_notis');
setTimeout(function(){ window.close() }, 10);
});
</script>