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

112 lines
2.8 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>
<table width="100%" height="168" id="customers">
<thead>
<tr>
<th>Bil</th>
<th>No Rujukan</th>
<th>No Kad Pengenalan</th>
<th>No Telefon</th>
<th>Tempoh</th>
<th>Berat (gm)</th>
<th>Pembiayaan (RM)</th>
<th>Baki Pembiayaan (RM)</th>
<th>Keuntungan 6 Bulan (RM)</th>
<th>Keuntungan Telah Bayar (RM)</th>
</tr>
</thead>
@foreach($getsurat as $index1=> $notis)
<tr>
<td>{{ $loop->iteration }}</td>
<td>{{ $notis['norujukan'] }}</td>
<td>{{ $notis['nokp'] }}</td>
<td>6{{ $notis['nama'][0]['telefon'] }}</td>
<td>{{ $notis['tempoh'] }}</td>
<td>{{ $notis['berat'] }}</td>
<td>{{ $notis['pinjaman'] }}</td>
<td>{{ $notis['bakipjm'] }}</td>
<td>{{ $notis['bakiupah'] }}</td>
<td>{{ number_format($notis['ktlhbyr'] , 2, '.', ',')}}</td>
@endforeach
{{-- @foreach($getsurat as $surat)
<tr>
<td>{{ $loop->iteration }}</td>
<td>{{ $surat['list_norujukan'][0]['norujukan'] }}</td>
<td>{{ $surat['list_norujukan'][0]['nokp'] }}</td>
<td>60{{ $surat['list_norujukan'][0]['telefon'] }}</td>
<td>{{ $surat['list_norujukan'][0]['tempoh'] }}</td>
<td>{{ $surat['list_norujukan'][0]['berat'] }}</td>
<td>{{ $surat['list_norujukan'][0]['pinjaman'] }}</td>
<td>{{ $surat['list_norujukan'][0]['bakipjm'] }}</td>
<td>{{ $surat['list_norujukan'][0]['bakiupah'] }}</td>
<td>{{ number_format($surat['ktlhbyr'] , 2, '.', ',')}}</td>
</tr>
@endforeach --}}
</div>
</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>