kaunter/resources/views/excel/excel_stokauditkhasbysag.blade.php

<meta http-equiv="content-type" content="text/html; charset=UTF-8" />
<script src="{{ asset('js/table2excel.js') }}"></script>
<style>

    .radiostyle .radio-green {
                background-color: #27ae60;
                color:white;
                box-shadow: 5px 10px #888888;
                width:200px;
                margin-right:5px;
                transition: 0.5s ease;
            }
    
            .radiostyle .radio-red {
                background-color: #e74c3c;
                color:white;
                width:200px;
                margin-right:5px;
                box-shadow: 5px 10px #888888;
                transition: 0.5s ease;
            }
    
            .radiostyle .radio-yellow {
                background-color: #3498db;
                color:white;
                width:200px;
                margin-right:5px;
                box-shadow: 5px 10px #888888;
                transition: 0.5s ease;
            }
    
            .radiostyle .radio-green:hover {
                box-shadow: 5px 5px #888888;
    
    
            }
    
            .radiostyle .radio-red:hover {
                box-shadow: 5px 5px #888888;
    
            }
    
            .radiostyle .radio-yellow:hover {
                box-shadow: 5px 5px #888888;
    
            }
    
            .radiostyle .radio-green input[type="radio"]:checked{
                box-shadow: 5px 10px #888888;
            }
    
            .radiostyle .radio-yellow input[type="radio"]:checked{
                box-shadow: 5px 10px #888888;
            }
    
            .radiostyle .radio-red input[type="radio"]:checked{
                box-shadow: 5px 10px #888888;
            }
    
    
    </style>
    
    <style>
        #header {
            font-family: Arial, Helvetica, sans-serif;
            border-collapse: collapse;
            width: 100%;
        }
    
        #header td,
        #customers th {
    
            padding: 4px;
            font-size: 10px;
        }
    
        #header tr:nth-child(even) {
            background-color: #ffffff;
        }
    
        #header tr:hover {
            background-color: #ddd;
        }
    
        #header th {
            padding-top: 12px;
            padding-bottom: 12px;
            text-align: left;
            padding: 4px;
            color: black;
        }
    </style>
    
    
    
    
    <style>
        #scan {
            font-family: Arial, Helvetica, sans-serif;
            border-collapse: collapse;
            width: 100%;
        }
    
        #scan td,
        #scan th {
    
            padding: 8px;
            font-size: 11px;
        }
    
        #scan tr:nth-child(even) {
            background-color: #ffffff;
        }
    
        #scan tr:hover {
            background-color: #ddd;
        }
    
        #scan th {
            padding-top: 12px;
            padding-bottom: 12px;
            text-align: left;
            padding: 4px;
            color: black;
        }
    </style>
    
    
    <style>
        #scan {
            font-family: Arial, Helvetica, sans-serif;
            border-collapse: collapse;
            width: 100%;
        }
    
        #scan td,
        #scan th {
            border-collapse: collapse;
            padding: 8px;
            font-size: 11px;
        }
    
        #scan tr:nth-child(even) {
            background-color: #ffffff;
        }
    
        #scan tr:hover {
            background-color: #ddd;
        }
    
        #scan th {
            border-collapse: collapse;
            padding-top: 12px;
            padding-bottom: 12px;
            text-align: left;
            padding: 4px;
            color: black;
        }
    </style>
    
    
    
    <style>
        #details {
            font-family: Arial, Helvetica, sans-serif;
            border-collapse: collapse;
            width: 100%;
        }
    
        #details td,
        #details th {
    
            padding: 8px;
            font-size: 11px;
        }
    
        #details tr:nth-child(even) {
            background-color: #ffffff;
        }
    
        #details tr:hover {
            background-color: #ddd;
        }
    
        #details th {
            padding-top: 12px;
            font-style: bold;
            padding-bottom: 12px;
            text-align: left;
            padding: 4px;
            color: black;
        }
    </style>
    
    <style>
        #sign {
            font-family: Arial, Helvetica, sans-serif;
            border-collapse: collapse;
            width: 100%;
        }
    
        #sign td,
        #sign th {
    
            padding: 8px;
            font-size: 11px;
            text-align: center;
        }
    
        #sign tr:nth-child(even) {
            background-color: #ffffff;
        }
    
        #sign tr:hover {
            background-color: #ddd;
        }
    
        #sign th {
            padding-top: 12px;
            padding-bottom: 12px;
            text-align: left;
            padding: 4px;
            color: black;
        }
    </style>

    


<body>

    <table id="header">
        <tr>
          <th rowspan="4"  style="width:50px"><br><img src="{{ asset('img/ARRAHN1.png') }}" style="width:70px"></img></th>
          <th colspan="1">KOPERASI PERMODALAN KELANTAN BERHAD</th>
        </tr>
        <tr>
          <td>{{ $cawangan_detail['namacaw'] }}</td>
          <td></td>
        </tr>
        <tr>
          <td>{{ $cawangan_detail['alamat1'] }}</td>
          <td></td>
        </tr>
        <tr>
          <td>{{ $cawangan_detail['alamat2'].' No Tel : '. $cawangan_detail['notel'].' No Faks : '. $cawangan_detail['nofaks'] }}</td>
          <td></td>
        </tr>
      </table>
      <br>
      
      <table id="scan">
        <tr>
          <th colspan ="5"><b>Laporan Stok Audit</b></th>
          <th> </th>
          <th> </th>
          <th><b> Tarikh Cetak:</b>
              @php
                $myDateTime = DateTime::createFromFormat('Y-m-d', $tarikh_cetak);
                $formattedweddingdate = $myDateTime->format('d-m-Y');
                echo($formattedweddingdate)
              @endphp
          </th>
          <th></th>
        </tr>

      </table>

             
         <table id="details" class="table table-bordered">
            <thead>
                <th>Bil</th>
                <!-- <th>Status</th> -->
                <th>Nama</th>
                <th>No. KP</th>
                <th>No. Telefon</th>
                <th>Norujukan</th>
                <th>Tempoh</th>
                <th>Berat</th>
                <th>Nilai Marhun (RM)</th>
                <th>Pembiayaan Asal (RM)</th>
                <th>Baki Pembiayaan (RM)</th>
                <th>Keuntungan Belum Bayar (RM)</th>
            </thead>
                @php
                    $counter = 1;
                    $totalpinjaman = 0;

                    // Sort ikut norujukan
                    $rekod = collect($stokaudit[0])->sortBy('norujukan')->values();
                @endphp

                @foreach ($rekod as $item)
                    @php
                        $status = $item['blasted'] == null ? 'Belum' : 'Selesai';
                        $totalpinjaman += $item['pinjaman'];
                    @endphp

                    <tr>
                        <td>{{ $counter }}</td>
                        <!-- <td style="white-space: nowrap">{{ $status }}</td> -->
                        <td style="white-space: nowrap;">{{ $item['customer']['nama'] ?? '-' }}</td>
                        <td>{{ $item['nokp'] }}</td>
                        <td>{{ $item['customer']['telefon'] ?? '-' }}</td>
                        <td style="white-space: nowrap;">{{ $item['norujukan'] }}</td>
                        <td>{{ $item['tempoh'] }}</td>
                        <td>{{ $item['berat'] }}</td>
                        <td align="right">{{ number_format($item['nilaimarhun'], 2) }}</td>
                        <td align="right">{{ number_format($item['pinjaman'], 2) }}</td>
                        <td align="right">{{ number_format($item['bakipjm'], 2) }}</td>
                        <td align="right">{{ number_format($item['tunggakan'], 2) }}</td>
                    </tr>
                    @php $counter++; @endphp
                @endforeach

                <tfoot>
                    <th colspan='6'>Jumlah</th>
                    <th>{{ number_format(collect($rekod)->sum('berat'), 2) }}</th>
                    <th style="text-align:right; font-weight:bold;">{{ number_format(collect($rekod)->sum('nilaimarhun'), 2) }}</th>
                    <th style="text-align:right; font-weight:bold;">{{ number_format(collect($rekod)->sum('pinjaman'), 2) }}</th>
                    <th style="text-align:right; font-weight:bold;">{{ number_format(collect($rekod)->sum('bakipjm'), 2) }}</th>
                    <th style="text-align:right; font-weight:bold;">{{ number_format(collect($rekod)->sum('tunggakan'), 2) }}</th>
                </tfoot>
            </table>


</body>
<script src="{{ asset('js/jquery.min.js') }}"></script>
<script>

    $(document).ready(function () {
        
        var table2excel = new Table2Excel();
        table2excel.export(document.querySelectorAll("#details"),'stok_audit_khas');
        setTimeout(function(){ window.close() }, 10);
        
        
      });
      
    </script>
    
<meta http-equiv="content-type" content="text/html; charset=UTF-8" />
<script src="{{ asset('js/table2excel.js') }}"></script>