@extends('layouts.layout')

@section('body_class', 'nav-md')

@section('body_content')
<style>  
    .yellow-table{
        background-color: #FFD51E
    }

    .blue-table{
        background-color: rgb(192, 243, 243)
    }
    .green-table{
        background-color: #56C035
    }
    
    .bnc-table{
        background-color: #E0BF4B;
    }
    .bbx-table{
        background-color: rgb(177, 164, 245)
    }

    .text-center {
    text-align: center;
    }
    .base-data{
        display: none;
    }
    /* .outer-bold {
    border: 2px solid black;
    border-collapse: collapse;
}

    .outer-bold th,
    .outer-bold td {
        border: none;
    } */

</style>

<div class="container body">
    <div class="main_container">
        @include('includes.sidebar')
        <div class="right_col" role="main">
            <div class="page-title">
                <div class="title_left">
                    <h3><i class="fa fa-edit"></i> Summary On Us vs Off Us</h3>
                </div>
                <div class="clearfix"></div>
            </div>

            <div class="row">
                <div class="col-xs-12">
                    <ol class="breadcrumb">
                        <li><a href="{{ route('dashboard') }}">Home</a></li>
                        <li><a href="{{ route('lakuemas_bnc') }}">Summary On Us vs Off Us</a></li>
                    </ol>
                </div>
            </div>

            {{-- <div class="x_panel">
                <div class="x_title">
                    Filter
                </div>
                <div class="x_content">
                    <form id="form-search" class="form-horizontal" style="margin-left: -125px;">
                        <div class="col-xs-11 col-sm-11">
                            <div class="form-group">
                                <label class="col-xs-6 col-sm-2 control-label">Bulan Mulai :</label>
                                <div class="col-xs-6 col-sm-2">
                                    <input  name="month_start" type="month" class="form-control" value="{{ $request['month_start'] }}" placeholder="Date Start">
                                </div>
                            </div>
                            <div class="form-group">

                                <label class="col-xs-6 col-sm-2 control-label">Bulan Selesai :</label>
                                <div class="col-xs-6 col-sm-2">
                                    <input name="month_end" type="month" class="form-control" value="{{ $request['month_end'] }}" placeholder="Date End">
                                </div>
                            </div>
                             
                            
                            <div class="form-group" style="margin-top: 20px; margin-right: 925px;">
                                <label class="col-xs-12 col-sm-5 control-label"></label>
                                <div class="col-xs-12 col-sm-7">
                                    <button type="submit" class="btn btn-primary btn-search"><i class="fa fa-search"></i> Search</button>
                                </div>
                            </div>
                        </div>
                    </form>
                </div>
            </div> --}}
            <div class="row">
                <!-- FILTER -->
                <div class="col-md-4">
                    <div class="x_panel">
                        <div class="x_title">
                            Filter
                        </div>
                        <div class="x_content">
                            <form id="form-search" class="form-horizontal">
                                <div class="form-group">
                                    <label>Bulan Mulai</label>
                                    <input name="month_start" type="month"
                                        class="form-control"
                                        value="{{ $request['month_start'] }}">
                                </div>

                                <div class="form-group">
                                    <label>Bulan Selesai</label>
                                    <input name="month_end" type="month"
                                        class="form-control"
                                        value="{{ $request['month_end'] }}">
                                </div>

                                <button type="submit" class="btn btn-primary btn-block">
                                    <i class="fa fa-search"></i> Search
                                </button>
                            </form>
                        </div>
                    </div>
                </div>

                <!-- TABLE -->
                {{-- <div class="col-md-8">
                    <div class="x_title">
                            <strong>BBX</strong>
                    </div>
                    <table class="table table-bordered table-striped">
                        <thead>
                            <tr>
                                <th class="text-center" rowspan="2">Tahun</th>
                                <th rowspan="2">Bulan</th>
                                <th colspan="7" class="text-center bbx-table">BBX</th>
                            </tr>
                            <tr>
                                <th class="bbx-table text-center">Jumlah Transaksi</th>
                                <th class="bbx-table text-center">Total Emas</th>
                                <th class="bbx-table text-center">Total Rupiah</th>
                                <th class="bbx-table text-center">Total Diskon</th>
                                <th class="bbx-table text-center">Total Harga Net</th>
                            </tr>
                        </thead>
                        <tbody>
                            @php
                                $jumlah_nett_akhir = 0;
                                $jumlah_total_emas = 0;
                                $jumlah_total_transaksi = 0;
                                $jumlah_total_diskon = 0;
                                $jumlah_total_harga = 0;
                            @endphp
                            @foreach ($summary_bbx as $item)
                            @php
                                $jumlah_nett_akhir += $item->total_harga_nett;
                                $jumlah_total_emas += $item->total_emas;
                                $jumlah_total_transaksi += $item->jumlah_transaksi;
                                $jumlah_total_diskon += $item->total_diskon;
                                $jumlah_total_harga += $item->total_harga;
                            @endphp
                            <tr>
                                <td>{{$item->tahun}}</td>
                                <td>{{$item->bulan}}</td>
                                <td class="text-right bbx-table">{{number_format($item->jumlah_transaksi)}}</td>
                                <td class="text-right bbx-table">{{number_format($item->total_emas, 2, ',','.')}}</td>
                                <td class="text-right bbx-table">{{number_format($item->total_harga)}}</td>
                                <td class="text-right bbx-table">{{number_format($item->total_diskon)}}</td>
                                <td class="text-right bbx-table">{{number_format($item->total_harga_nett)}}</td>
                            </tr>
                            @endforeach
                        </tbody>
                        <tfoot>
                            <tr>
                                <td class="text-center" colspan="2"><b>Total</b></td>
                                <td class="text-right bbx-table"><b>{{ number_format($jumlah_total_transaksi)}}</b></td>
                                <td class="text-right bbx-table"><b>{{ number_format($jumlah_total_emas, 2, ',','.') }}</b></td>
                                <td class="text-right bbx-table"><b>{{ number_format($jumlah_total_harga) }}</b></td>
                                <td class="text-right bbx-table"><b>{{ number_format($jumlah_total_diskon) }}</b></td>
                                <td class="text-right bbx-table"><b>{{ number_format($jumlah_nett_akhir) }}</b></td>
                            </tr>
                        </tfoot>   
                    </table>
                </div> --}}
            </div>

            
            
            
            <div class="row base-data">
                <div class="col-xs-12">
                    <div class="table-responsive">
                        <div class="x_panel">
                            <div style="zoom: 0.9; overflow: auto;">
                                <table class="table table-bordered table-striped">
                                  
                                    <tbody>
                                        @php
                                            $total_harga_emas = 0;
                                            $total_diskon_emas = 0;
                                            $total_pajak_emas = 0;
                                            $total_biaya_layanan_emas = 0;
                                            $total_rupiah_beli = 0;
                                            $total_emas_beli = 0;
                                            $total_jumlah_beli = 0;
                                            $total_beli = 0;
                                            $total_emas = 0;
                                            $total_transaksi = 0;
                                            $total_rupiah_redeem = 0;
                                            $total_emas_redeem = 0;
                                            $total_jumlah_redeem = 0;
                                            $total_rupiah_bnc = 0 ;
                                            $total_emas_bnc = 0 ;
                                            $total_transaksi_bnc = 0;
                                        @endphp
                                        @foreach ($lakuemas_beli as $key => $data)
                                            <tr>    

                                                @if(isset($lakuemas_redeem[$data->tahun . '_' . $data->bulan]))

                                                @else
                                                    @php
                                                        $total_beli += 0 + $lakuemas_beli[$key]->total_nett_akhir;
                                                        $total_emas += 0 + $lakuemas_beli[$key]->total_emas;
                                                        $total_transaksi += 0 + $lakuemas_beli[$key]->jumlah_transaksi;
                                                    @endphp
                                                @endif
                                                @if(isset($lakuemas_bnc[$data->tahun . '_' . $data->bulan]))
                                                @php
                                                    $bnc = $lakuemas_bnc[$data->tahun . '_' . $data->bulan];
                                                    $total_rupiah_bnc += $bnc->total_rupiah;
                                                    $total_emas_bnc += $bnc->total_emas;
                                                    $total_transaksi_bnc += $bnc->jumlah_transaksi;
                                                @endphp
                                              
                                            @else
                                            @endif
                                            </tr>
                                        @endforeach
                                    </tbody>
                                    <tfoot>
                                        <tr>
                                            <td class="text-center" colspan="2"><b>Total</b></td>
                                            <td class="text-right yellow-table"><b>{{ number_format($total_harga_emas) }}</b></td>
                                            <td class="text-right yellow-table"><b>{{ number_format($total_diskon_emas) }}</b></td>
                                            <td class="text-right yellow-table"><b>{{ number_format($total_pajak_emas)}}</b></td>
                                            <td class="text-right yellow-table"><b>{{ number_format($total_biaya_layanan_emas) }}</b></td>
                                            <td class="text-right yellow-table"><b>{{ number_format($total_rupiah_beli) }}</b></td>
                                            <td class="text-right yellow-table"><b>{{ number_format($total_emas_beli,2, ',', '.' )}}</b></td>
                                            <td class="text-right yellow-table"><b>{{ number_format($total_jumlah_beli) }}</b></td>
                                            <td class="text-right blue-table"><b>{{ number_format($total_rupiah_redeem)}}</b></td>
                                            <td class="text-right blue-table"><b>{{ number_format($total_emas_redeem,2, ',', '.' )}}</b></td>
                                            <td class="text-right blue-table"><b>{{ number_format($total_jumlah_redeem) }}</b></td>
                                            <td class="text-right green-table"><b>{{ number_format($total_beli)}}</b></td>
                                            <td class="text-right green-table"><b>{{ number_format($total_emas,2, ',', '.' )}}</b></td>
                                            <td class="text-right green-table"><b>{{ number_format($total_transaksi) }}</b></td>
                                            <td class="text-right bnc-table"><b>{{ number_format($total_rupiah_bnc) }}</b></td>
                                            <td class="text-right bnc-table"><b>{{ number_format($total_emas_bnc,2, ',', '.' ) }}</b></td>
                                            <td class="text-right bnc-table"><b>{{ number_format($total_transaksi_bnc) }}</b></td>
                                        </tr>
                                    </tfoot>     
                                </table>
                            </div>  
                        </div>
                    </div>
                </div>
            </div>

            {{-- lakuemas --}}
             <div class="row">
                <div class="col-xs-12">
                    {{-- <div class="x_title">
                            <strong>LAKUEMAS X BNC</strong>
                    </div> --}}
                    <div class="table-responsive">
                        <div class="x_panel">
                            <h4 class="text-center bnc-table" style="width: 25%"><strong>Lakuemas (on us)</strong></h4>
                            <div style="zoom: 0.9; overflow: auto;">
                                <table class="table table-bordered table-striped outer-bold">
                                    <thead>
                                        {{-- <tr>
                                            <th colspan="3" class="text-center bnc-table">Lakuemas (on us)</th>
                                        </tr> --}}
                                        <tr>
                                            <th class="text-center" rowspan="2">Tahun</th>
                                            <th rowspan="2">Bulan</th>
                                            <th colspan="7" class="text-center">Penjualan Digital Gold</th>
                                            <th colspan="3" class="text-center">Redeem Voucher</th>
                                            <th colspan="3" class="text-center">Total All Channel</th>
                                        </tr>
                                        <tr>
                                            {{-- <th class="text-center">Tahun</th>
                                            <th>Bulan</th> --}}
                                            <th class="text-center">Penjualan Sebelum Disc (Rp)</th>
                                            <th class="text-center">Discount</th>
                                            <th class="text-center">Pajak (Rp)</th>
                                            <th class="text-center">Biaya Layanan (Rp)</th>
                                            <th class="text-center">Penjualan Setelah Disc (Rp)</th>
                                            <th class="text-center">Penjualan (Gr)</th>
                                            <th class="text-center">Total Trx</th>
                                            <th class="text-center">Total Redeem (Rp)</th>
                                            <th class="text-center">Total Redeem (Gr)</th>
                                            <th class="text-center">Total Trx</th>
                                            <th class="text-center">Total Penjualan (Rp)</th>
                                            <th class="text-center">Total Penjualan (Gr)</th>
                                            <th class="text-center">Total Trx</th>
                                        </tr>
                                    </thead>
                                    <tbody>
                                        @php
                                            $total_harga_emas = 0;
                                            $total_diskon_emas = 0;
                                            $total_pajak_emas = 0;
                                            $total_biaya_layanan_emas = 0;
                                            $total_rupiah_beli = 0;
                                            $total_emas_beli = 0;
                                            $total_jumlah_beli = 0;
                                            $total_beli = 0;
                                            $total_emas = 0;
                                            $total_transaksi = 0;
                                            $total_rupiah_redeem = 0;
                                            $total_emas_redeem = 0;
                                            $total_jumlah_redeem = 0;
                                            $total_rupiah_bnc = 0 ;
                                            $total_emas_bnc = 0 ;
                                            $total_transaksi_bnc = 0;
                                        @endphp
                                        @foreach ($lakuemas_beli as $key => $data)
                                            <tr>    
                                                <td class="text-right">{{ ($data->tahun)}}</td>
                                                <td class="text-right">{{ ($data->bulan)}}</td>
                                                <td class="text-right">{{ number_format($data->harga_emas)}}</td>
                                                <td class="text-right">{{ number_format($data->total_diskon)}}</td>
                                                <td class="text-right">{{ number_format($data->total_pajak)}}</td>
                                                <td class="text-right">{{ number_format($data->biaya_layanan)}}</td>
                                                <td class="text-right">{{ number_format($data->total_nett_akhir)}}</td>
                                                <td class="text-right">{{ number_format($data->total_emas, 2, ',','.')}}</td>
                                                <td class="text-right">{{ number_format($data->jumlah_transaksi)}}</td>
                                                @php
                                                    $total_harga_emas += $data->harga_emas;
                                                    $total_diskon_emas += $data->total_diskon;
                                                    $total_pajak_emas += $data->total_pajak;
                                                    $total_biaya_layanan_emas += $data->biaya_layanan;
                                                    $total_rupiah_beli += $data->total_nett_akhir;
                                                    $total_emas_beli += $data->total_emas;
                                                    $total_jumlah_beli += $data->jumlah_transaksi;
													\Log::info(['@@@@@@@', $data->tahun . '_' . $data->bulan]);
                                                @endphp
                                               

                                                @if(isset($lakuemas_redeem[$data->tahun . '_' . $data->bulan]))
                                                    @php
                                                        $redeem = $lakuemas_redeem[$data->tahun . '_' . $data->bulan];
                                                        $total_rupiah_redeem += $redeem->total_rupiah;
                                                        $total_emas_redeem += $redeem->total_emas;
                                                        $total_jumlah_redeem += $redeem->jumlah_transaksi;
                                                    @endphp
                                                    @if ($key == $loop -> index)
                                                        <td class="text-right">{{ number_format($redeem->total_rupiah)}}</td>
                                                        <td class="text-right">{{ number_format($redeem->total_emas, 2, ',','.')}}</td>
                                                        <td class="text-right">{{ number_format($redeem->jumlah_transaksi)}}</td>
                                                        

                                                        <td class="text-right">{{ number_format($redeem->total_rupiah + $lakuemas_beli[$key]->total_nett_akhir) }}</td>
                                                        <td class="text-right">{{ number_format($redeem->total_emas + $lakuemas_beli[$key]->total_emas,2, '.',',' )}}</td>
                                                        <td class="text-right">{{ number_format($redeem->jumlah_transaksi + $lakuemas_beli[$key]->jumlah_transaksi) }}</td>
                                                        @php
                                                            $total_beli += $redeem->total_rupiah + $lakuemas_beli[$key]->total_nett_akhir;
                                                            $total_emas += $redeem->total_emas + $lakuemas_beli[$key]->total_emas;
                                                            $total_transaksi += $redeem->jumlah_transaksi + $lakuemas_beli[$key]->jumlah_transaksi;
                                                        @endphp
                                                    @endif
                                                @else
                                                    <td class="text-right">0</td>
                                                    <td class="text-right">0</td>
                                                    <td class="text-right">0</td>
                                                    <td class="text-right">{{ number_format($data->total_nett_akhir)}}</td>
                                                    <td class="text-right">{{ number_format($data->total_emas, 2, ',','')}}</td>
                                                    <td class="text-right">{{ number_format($data->jumlah_transaksi)}}</td>
                                                    @php
                                                        $total_beli += 0 + $lakuemas_beli[$key]->total_nett_akhir;
                                                        $total_emas += 0 + $lakuemas_beli[$key]->total_emas;
                                                        $total_transaksi += 0 + $lakuemas_beli[$key]->jumlah_transaksi;
                                                    @endphp
                                                @endif
                                                @if(isset($lakuemas_bnc[$data->tahun . '_' . $data->bulan]))
                                            @else
                                                <td class="text-right">0</td>
                                                <td class="text-right">0</td>
                                                <td class="text-right">0</td>
                                            @endif
                                            </tr>
                                        @endforeach
                                    </tbody>
                                    <tfoot>
                                        <tr>
                                            <td class="text-center" colspan="2"><b>Total</b></td>
                                            <td class="text-right"><b>{{ number_format($total_harga_emas) }}</b></td>
                                            <td class="text-right"><b>{{ number_format($total_diskon_emas) }}</b></td>
                                            <td class="text-right"><b>{{ number_format($total_pajak_emas)}}</b></td>
                                            <td class="text-right"><b>{{ number_format($total_biaya_layanan_emas) }}</b></td>
                                            <td class="text-right"><b>{{ number_format($total_rupiah_beli) }}</b></td>
                                            <td class="text-right"><b>{{ number_format($total_emas_beli,2, ',', '.' )}}</b></td>
                                            <td class="text-right"><b>{{ number_format($total_jumlah_beli) }}</b></td>
                                            <td class="text-right"><b>{{ number_format($total_rupiah_redeem)}}</b></td>
                                            <td class="text-right"><b>{{ number_format($total_emas_redeem,2, ',', '.' )}}</b></td>
                                            <td class="text-right"><b>{{ number_format($total_jumlah_redeem) }}</b></td>
                                            <td class="text-right"><b>{{ number_format($total_beli)}}</b></td>
                                            <td class="text-right"><b>{{ number_format($total_emas,2, ',', '.' )}}</b></td>
                                            <td class="text-right"><b>{{ number_format($total_transaksi) }}</b></td>
                                        </tr>
                                    </tfoot>     
                                </table>
                            </div>  
                        </div>
                    </div>
                </div>
            </div>

            {{-- bnc --}}
            <div class="row">
                <div class="col-xs-12">
                    {{-- <div class="x_title">
                        <strong>LAKUEMAS X BNC</strong>
                    </div> --}}
                    <div class="table-responsive">
                        <div class="x_panel">
                            <h4 class="text-center yellow-table" style="width: 25%"><strong>BNC (off us)</strong></h4>

                            <div style="zoom: 0.9; overflow: auto;">
                                <table class="table table-bordered table-striped outer-bold">
                                    <thead>
                                        {{-- <tr>
                                            <th colspan="3" class="text-center yellow-table">BNC (off us)</th>
                                        </tr> --}}
                                        <tr>
                                            <th class="text-center">Tahun</th>
                                            <th>Bulan</th>
                                            <th class="text-center">Penjualan Sebelum Disc (Rp)</th>
                                            <th class="text-center">Discount</th>
                                            <th class="text-center">Pajak (Rp)</th>
                                            <th class="text-center">Biaya Layanan (Rp)</th>
                                            <th class="text-center">Total Rupiah</th>
                                            <th class="text-center">Total Emas</th>
                                            <th class="text-center">Jumlah Transaksi</th>
                                        </tr>
                                    </thead>
                                    <tbody>
                                        @php
                                            $total_harga_emas = 0;
                                            $total_diskon_emas = 0;
                                            $total_pajak_emas = 0;
                                            $total_biaya_layanan_emas = 0;
                                            $total_rupiah_beli = 0;
                                            $total_emas_beli = 0;
                                            $total_jumlah_beli = 0;
                                            $total_beli = 0;
                                            $total_emas = 0;
                                            $total_transaksi = 0;
                                            $total_rupiah_redeem = 0;
                                            $total_emas_redeem = 0;
                                            $total_jumlah_redeem = 0;
                                            $total_rupiah_bnc = 0 ;
                                            $total_emas_bnc = 0 ;
                                            $total_transaksi_bnc = 0;
                                        @endphp
                                        @foreach ($lakuemas_beli as $key => $data)
                                            <tr>    
                                                @if(isset($lakuemas_bnc[$data->tahun . '_' . $data->bulan]))
                                                @php
                                                    $bnc = $lakuemas_bnc[$data->tahun . '_' . $data->bulan];
                                                    $total_rupiah_bnc += $bnc->total_rupiah;
                                                    $total_emas_bnc += $bnc->total_emas;
                                                    $total_transaksi_bnc += $bnc->jumlah_transaksi;
                                                @endphp
                                                <td class="text-right">{{ ($data->tahun)}}</td>
                                                <td class="text-right">{{ ($data->bulan)}}</td>
                                                <td class="text-right">{{ number_format($bnc->total_rupiah)}}</td>
                                                <td class="text-right">0</td>
                                                <td class="text-right">0</td>
                                                <td class="text-right">0</td>
                                                
                                                {{-- @if ($key == $loop->index) --}}
                                                    <td class="text-right">{{ number_format($bnc->total_rupiah) }}</td>
                                                    <td class="text-right">{{ number_format($bnc->total_emas, 2, ',','.') }}</td>
                                                    <td class="text-right">{{ number_format($bnc->jumlah_transaksi) }}</td>
                                                {{-- @endif --}}
                                            @else
                                                <td class="text-right">0</td>
                                                <td class="text-right">0</td>
                                                <td class="text-right">0</td>
                                            @endif
                                            </tr>
                                        @endforeach
                                    </tbody>
                                    <tfoot>
                                        <tr>
                                            <td class="text-center" colspan="2"><b>Total</b></td>
                                            <td class="text-right"><b>{{ number_format($total_rupiah_bnc) }}</b></td>
                                            <td class="text-right"><b>0</b></td>
                                            <td class="text-right"><b>0</b></td>
                                            <td class="text-right"><b>0</b></td>
                                            <td class="text-right"><b>{{ number_format($total_rupiah_bnc) }}</b></td>
                                            <td class="text-right"><b>{{ number_format($total_emas_bnc,2, ',', '.' ) }}</b></td>
                                            <td class="text-right"><b>{{ number_format($total_transaksi_bnc) }}</b></td>
                                        </tr>
                                    </tfoot>     
                                </table>
                            </div>  
                        </div>
                    </div>
                </div>
            </div>

            {{-- bbx --}}
            <div class="row">
                <div class="col-xs-12">
                    {{-- <div class="x_title">
                            <strong>LAKUEMAS X BNC</strong>
                    </div> --}}
                    <div class="table-responsive">
                        <div class="x_panel">
                            <h4 class="text-center green-table" style="width: 25%"><strong>BBX (off us)</strong></h4>
                            <div style="zoom: 0.9; overflow: auto;">
                                <table class="table table-bordered table-striped outer-bold">
                                    <thead>
                                        {{-- <tr>
                                            <th class="text-center" rowspan="2">Tahun</th>
                                            <th rowspan="2">Bulan</th>
                                            <th colspan="3" class="text-center green-table">BBX (off us)</th>
                                        </tr> --}}
                                        <tr>
                                            <th class="text-center">Tahun</th>
                                            <th>Bulan</th>
                                            <th class="text-center">Penjualan Sebelum Disc (Rp)</th>
                                            <th class="text-center">Discount</th>
                                            <th class="text-center">Pajak (Rp)</th>
                                            <th class="text-center">Biaya Layanan (Rp)</th>
                                            <th class="text-center">Total Rupiah</th>
                                            <th class="text-center">Total Emas</th>
                                            <th class="text-center">Jumlah Transaksi</th>
                                        </tr>
                                    </thead>
                                    <tbody>
                                        @php
                                            $total_harga_emas = 0;
                                            $total_harga_net = 0;
                                            $total_diskon_emas = 0;
                                            $total_pajak_emas = 0;
                                            $total_biaya_layanan_emas = 0;
                                            $total_rupiah_beli = 0;
                                            $total_emas_beli = 0;
                                            $total_jumlah_beli = 0;
                                            $total_beli = 0;
                                            $total_emas = 0;
                                            $total_transaksi = 0;
                                            $total_rupiah_redeem = 0;
                                            $total_emas_redeem = 0;
                                            $total_jumlah_redeem = 0;
                                            $total_rupiah_bnc = 0 ;
                                            $total_emas_bnc = 0 ;
                                        @endphp
                                        @foreach ($summary_bbx as $key => $data)
                                        @php
                                            $total_harga_emas += $data->total_harga;
                                            $total_diskon_emas += $data->total_diskon;
                                            $total_harga_net += $data->total_harga_nett;
                                            $total_emas += $data->total_emas;
                                            $total_transaksi += $data->jumlah_transaksi;
                                        @endphp
                                            <tr>    
                                                <td class="text-right">{{ ($data->tahun)}}</td>
                                                <td class="text-right">{{ ($data->bulan)}}</td>
                                                <td class="text-right">{{ number_format($data->total_harga)}}</td>
                                                <td class="text-right">{{ number_format($data->total_diskon) }}</td>
                                                <td class="text-right">0</td>
                                                <td class="text-right">0</td>
                                                <td class="text-right">{{ number_format($data->total_harga_nett) }}</td>
                                                <td class="text-right">{{ number_format($data->total_emas, 2, ',','.') }}</td>
                                                <td class="text-right">{{ number_format($data->jumlah_transaksi) }}</td>
                                            </tr>
                                        @endforeach
                                    </tbody>
                                    <tfoot>
                                        <tr>
                                            <td class="text-center" colspan="2"><b>Total</b></td>
                                            <td class="text-right"><b>{{ number_format($total_harga_emas) }}</b></td>
                                            <td class="text-right"><b>{{ number_format($total_diskon_emas) }}</b></td>
                                            <td class="text-right"><b>0</b></td>
                                            <td class="text-right"><b>0</b></td>
                                            <td class="text-right"><b>{{ number_format($total_harga_net) }}</b></td>
                                            <td class="text-right"><b>{{ number_format($total_emas,2, ',', '.' ) }}</b></td>
                                            <td class="text-right"><b>{{ number_format($total_transaksi) }}</b></td>
                                        </tr>
                                    </tfoot>     
                                </table>
                            </div>  
                        </div>
                    </div>
                </div>
            </div>

        </div>
    </div>
</div>
</div>
@endsection




<script>
 document.addEventListener('DOMContentLoaded', function () {
        var form = document.querySelector('form');

        form.addEventListener('submit', function (event) {
            var monthStartInput = document.querySelector('input[name="month_start"]');
            var monthEndInput = document.querySelector('input[name="month_end"]');

            
            var monthStart = monthStartInput.value;
            var monthEnd = monthEndInput.value;

            var dateStart = new Date(monthStart + '-01');
            var dateEnd = new Date(monthEnd + '-01');

          
            if (dateEnd < dateStart) {
                alert('Bulan Selesai tidak boleh lebih kecil dari Bulan Mulai.');
                event.preventDefault();
            }
        });
    });
</script>