@extends('layouts.layout')

@section('body_class', 'nav-md')
@section('css')
    <style>
		.form-group-x {
			margin-top: -20px;
		}
		
        .form-group-x label {
			font-weight: bold;
			text-align: left !important;
		}
		
		.summary {
			padding: 0px !important;
		}
		
		.summary h2 {
			text-align: center !important;
		}
		
		
    </style>
@endsection

@section('body_content')
    <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>Reporting Transaksi Lakuemas</h3>
                    </div>
                    <div class="clearfix"></div>
                </div>

                <div class="row">
                    <div class="col-xs-12">
                        <ol class="breadcrumb">
                            <li><a href="{{ url('/dashboard') }}">Home</a></li>
                            <li><a href="{{ url('/reporting/transaksi_lakuemas') }}">Reporting</a></li>
                            <li class="active">Transaksi Lakuemas</li>
                        </ol>
                    </div>

                    <div class="col-xs-12">
                        <div id="loadingSummary" class="text-center">
                            Waiting for transaction summary
                            <h2>
                                <i class="fa fa-2x fa-pulse fa-spinner"></i>
                            </h2>
                        </div>
                        <div id="summaryData" class="row" style="display: none; zoom: 0.9;">
							{{--
                            <div class="col-xs-12 col-sm-2">
                                <div class="x_panel bg-blue summary">
                                    <div class="x_title">
                                        <h2>Summary</h2>
                                    </div>

                                    <div class="x_content">
                                        <div class="form-horizontal">
                                            <div class="form-group">
                                                <div class="col-md-3">
                                                    <p class="form-control-static"><span id="summary_total_emas"
                                                            style="font-size: 30px;"></span></p>
                                                    Gram
                                                </div>
                                                <div class="col-md-3">
                                                    <p class="form-control-static"><span id="summary_total_tabungan_aktif"
                                                            style="font-size: 30px;"></span></p>
                                                    Rekening
                                                </div>
                                            </div>
                                        </div>
                                    </div>
                                </div>
                            </div>
							--}}
	
                            <div class="col-xs-12 col-sm-3">
                                <div class="x_panel bg-green summary">
                                    <div class="x_title">
                                        <h2>Summary Beli</h2>
                                        {{-- 
                                    <ul class="nav navbar-right panel_toolbox">
                                        <li><a class="collapse-link"><i class="fa fa-chevron-up"></i></a></li>
                                    </ul>
                                    <div class="clearfix"></div>
                                     --}}
                                    </div>

                                    <div class="x_content">
                                        <div class="form-horizontal">

                                            <div class="form-group form-group-x" style="margin-top: 1px;">
                                                <label class="col-xs-4 control-label">Beli</label>
                                                <div class="col-xs-8">
                                                    <p class="form-control-static"><span id="summary_total_beli"></span>
                                                        Gram</p>
                                                </div>
                                            </div>

                                            <div class="form-group form-group-x">
                                                <label class="col-xs-4 control-label">Pajak</label>
                                                <div class="col-xs-8">
                                                    <p class="form-control-static">Rp. <span
                                                            id="summary_total_pajak"></span>,-</p>
                                                </div>
                                            </div>

                                            <div class="form-group form-group-x">
                                                <label class="col-xs-4 control-label">Rupiah</label>
                                                <div class="col-xs-8">
                                                    <p class="form-control-static">Rp. <span id="summary_rp_beli"></span>,-
                                                    </p>
                                                </div>
                                            </div>
											
                                            <div class="form-group form-group-x">
                                                <label class="col-xs-4 control-label">Discount</label>
                                                <div class="col-xs-8">
                                                    <p class="form-control-static" id="summary_discount_rp_beli"><i class="fa fa-spinner fa-pulse"></i>
                                                    </p>
                                                </div>
                                            </div>
											
                                            <div class="form-group form-group-x">
                                                <label class="col-xs-4 control-label">Total Rupiah</label>
                                                <div class="col-xs-8">
                                                    <p class="form-control-static" id="summary_total_rp_beli"><i class="fa fa-spinner fa-pulse"></i>
                                                    </p>
                                                </div>
                                            </div>
                                        </div>
                                    </div>
                                </div>
                            </div>
							
							<div class="col-xs-12 col-sm-2">
                                <div class="x_panel bg-blue summary">
                                    <div class="x_title">
                                        <h2>Tukar Fisik</h2>
                                    </div>

                                    <div class="x_content">
                                        <div class="form-horizontal">

                                            <div class="form-group form-group-x" style="margin-top: 1px;">
                                                <label class="col-xs-4 control-label">QTY</label>
                                                <div class="col-xs-8">
                                                    <p class="form-control-static"><span id="summary_tf_totalqty">0</span></p>
                                                </div>
                                            </div>

                                            <div class="form-group form-group-x">
                                                <label class="col-xs-4 control-label">Emas</label>
                                                <div class="col-xs-8">
                                                    <p class="form-control-static"><span id="summary_tf_totalpecahan">0</span> Gram</p>
                                                </div>
                                            </div>

                                            <div class="form-group form-group-x">
                                                <label class="col-xs-4 control-label">Rupiah</label>
                                                <div class="col-xs-8">
                                                    <p class="form-control-static">Rp. <span id="summary_tf_totalrupiah">0</span>,-
                                                    </p>
                                                </div>
                                            </div>
                                        </div>
                                    </div>
                                </div>
                            </div>

                            <div class="col-xs-12 col-sm-2">
                                <div class="x_panel bg-red summary">
                                    <div class="x_title">
                                        <h2>Summary Jual</h2>
                                    </div>

                                    <div class="x_content">
                                        <div class="form-horizontal">
                                            <div class="form-group form-group-x" style="margin-top: 1px;">
                                                <label class="col-xs-4 control-label">Jual</label>
                                                <div class="col-xs-8">
                                                    <p class="form-control-static"><span id="summary_total_jual"></span>
                                                        Gram</p>
                                                </div>
                                            </div>

                                            <div class="form-group form-group-x">
                                                <label class="col-xs-4 control-label">Rupiah</label>
                                                <div class="col-xs-8">
                                                    <p class="form-control-static">Rp. <span id="summary_rp_jual"></span>,-
                                                    </p>
                                                </div>
                                            </div>
                                        </div>
                                    </div>
                                </div>
                            </div>

                            <div class="col-xs-12 col-sm-2">
                                <div class="x_panel bg-red summary">
                                    <div class="x_title">
                                        <h2>Summary Tarik</h2>
                                    </div>

                                    <div class="x_content">
                                        <div class="form-horizontal">
                                            <div class="form-group form-group-x" style="margin-top: 1px;">
                                                <label class="col-xs-4 control-label">Tarik</label>
                                                <div class="col-xs-8">
                                                    <p class="form-control-static"><span id="summary_total_tarik"></span>
                                                        Gram</p>
                                                </div>
                                            </div>
                                        </div>
                                        <div class="form-horizontal">
                                            <div class="form-group form-group-x">
                                                <label class="col-xs-4 control-label">Biaya Cetak</label>
                                                <div class="col-xs-8">
                                                    <p class="form-control-static">Rp. <span
                                                            id="summary_total_tarik_biaya_cetak"></span></p>
                                                </div>
                                            </div>
                                        </div>
                                    </div>
                                </div>
                            </div>

                            <div class="col-xs-12 col-sm-3">
                                <div class="x_panel summary" style="background: #7986CB !important; color: #fff;">
                                    <div class="x_title">
                                        <h2>Redeem Voucher</h2>
                                    </div>

                                    <div class="x_content">
                                        <div class="form-horizontal">
                                            <div class="form-group form-group-x" style="margin-top: 1px;">
                                                <label class="col-xs-4 control-label">Redeem</label>
                                                <div class="col-xs-8">
                                                    <p class="form-control-static"><span id="summary_total_redeem"></span>
                                                        Gram</p>
                                                </div>
                                            </div>
                                        </div>
                                        <div class="form-horizontal">
                                            <div class="form-group form-group-x">
                                                <label class="col-xs-4 control-label">Pajak</label>
                                                <div class="col-xs-8">
                                                    <p class="form-control-static">Rp. <span
                                                            id="summary_total_redeem_pajak"></span></p>
                                                </div>
                                            </div>
                                        </div>
                                        <div class="form-horizontal">
                                            <div class="form-group form-group-x">
                                                <label class="col-xs-4 control-label">Rupiah</label>
                                                <div class="col-xs-8">
                                                    <p class="form-control-static">Rp. <span
                                                            id="summary_total_redeem_rupiah"></span></p>
                                                </div>
                                            </div>
                                        </div>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>

                    <div class="col-xs-12">
                        <div class="x_panel">
                            <div class="x_title">
                                <h2>Filter</h2>
                                <ul class="nav navbar-right panel_toolbox">
                                    <li><a class="collapse-link"><i class="fa fa-chevron-up"></i></a></li>
                                </ul>
                                <div class="clearfix"></div>
                            </div>
                            <div class="x_content">
                                <form id="form_filter" class="form-horizontal">
                                    <div class="form-group">
                                        <label class="col-sm-2 control-label">Tanggal Mulai</label>
                                        <div class="col-sm-10">
                                            <input name="date_start" type="date" class="form-control"
                                                placeholder="Date Start"
                                                value="{{ $request['date_start'] ?: date('Y-m-d') }}" required>
                                        </div>
                                    </div>

                                    <div class="form-group">
                                        <label class="col-sm-2 control-label">Tanggal Selesai</label>
                                        <div class="col-sm-10">
                                            <input name="date_end" type="date" class="form-control"
                                                placeholder="Date End" value="{{ $request['date_end'] ?: date('Y-m-d') }}"
                                                required>
                                        </div>
                                    </div>

                                    <div class="form-group">
                                        <label class="col-sm-2 control-label">Tipe Transaksi</label>
                                        <div class="col-sm-10">
                                            <select name="transaction_type" class="form-control">
                                                <option value="" selected>Pilih Tipe Transaksi</option>
                                                @foreach ($transaction_type as $key => $value)
                                                    <option value="{{ $key }}"
                                                        {{ $request_transaction_type == $key ? 'selected' : '' }}>
                                                        {{ $value }}</option>
                                                @endforeach
                                            </select>
                                        </div>
                                    </div>

                                    <div class="form-group">
                                        <label class="col-sm-2 control-label">Keyword</label>
                                        <div class="col-sm-10">
                                            <input name="find" class="form-control" placeholder="Search by Kode"@isset($_GET['find']) {!! ' value="' . htmlentities($_GET['find'], ENT_COMPAT) . '"' !!} @endisset>
                                            @if(session('warning'))
                                                 <div class="alert alert-danger">
                                                    {{ session('warning') }}
                                                 </div>
                                            @endif
                                        </div>
                                    </div>

                                    <div class="form-group">
                                        <div class="col-sm-offset-2 col-sm-10">
                                            <button type="submit" class="btn btn-default"><i class="fa fa-search"></i>
                                                Cari</button>
                                        </div>
                                    </div>
                                </form>
                            </div>
                        </div>
                    </div>

                    <div class="col-xs-12">
                        <div class="x_panel">
                            <div class="x_title">
                                <div class="row">
                                    <div class="col-sm-6">
                                        <h2>Data Transaksi Lakuemas</h2>
                                    </div>
                                </div>
                                <div class="clearfix"></div>
                            </div>
                            <div class="x_content" style="overflow: auto;">
                                <div class="form-group">
                                    <label class="col-sm-2 control-label">Total redeemed voucher</label>
                                    <div class="col-sm-10">{{ $total_redeemed_gram }} gram</div>
                                </div>

                                <table id="table_transaksi" class="table table-bordered">
                                    <thead>
                                        <tr>
                                            <th class="text-center">Tanggal</th>
                                            <th class="text-center">Kode</th>
                                            <th class="text-center">Customer Code</th>
                                            <th class="text-center">Customer Name</th>
                                            {{--  <th class="text-center">KTP</th> --}}
                                            {{-- <th class="text-center">NPWP</th> --}}    
                                            <th class="text-center">Rekening</th>
                                            <th class="text-center" colspan="2">Amount</th>
                                            <th class="text-center">Total Dana</th>
                                            <th class="text-center" colspan="2">Pajak</th>
                                            <th class="text-center">Voucher</th>
                                            <th class="text-center">Total Setor</th>
                                            <th class="text-center">Harga Jual</th>
                                            <th class="text-center">Harga Beli</th>
                                            <th class="text-center">Keterangan</th>
                                            <th class="text-center">Metode Pembayaran</th>
                                        </tr>
                                    </thead>
                                    <tbody>
                                        @forelse($transaksi as $k=>$item_transaksi)
                                            @foreach ($item_transaksi->tabungan_transaksi as $item_tabungan_transaksi)
                                                <tr>
                                                    <!--<td>{{ ((empty($_GET['page']) ? 1 : $_GET['page']) - 1) * $paginate + ($k + 1) }}</td>-->
                                                    <td class="text-center">
                                                        {{ strftime('%d %b %Y %R', strtotime($item_transaksi->date_approved)) }}
                                                    </td>
                                                    <td class="text-center">{{ $item_transaksi->code }}</td>
                                                    <td class="text-center">
                                                        {{ @$item_tabungan_transaksi->tabungan->customer->code }}</td>
                                                    <td class="text-center">
                                                        {{ @$item_tabungan_transaksi->tabungan->customer->name }}<br><small>{{ date('d-m-Y',  strtotime(@$item_tabungan_transaksi->tabungan->customer->created_at)) }}</small>

                                                    </td>
                                                    {{-- <td class="text-center">
                                                        {{ @$item_tabungan_transaksi->tabungan->customer->ktp }}</td> --}}
                                                    {{--  <td class="text-center">
                                                        {{ @$item_tabungan_transaksi->tabungan->customer->npwp }}</td> --}}
                                                    <td class="text-center">
                                                        {{ @$item_tabungan_transaksi->tabungan->nomor_rekening }}</td>
                                                    <td class="text-right">
                                                        @if (!empty($item_tabungan_transaksi->debet))
                                                            {{ $item_tabungan_transaksi->debet }}
                                                        @else
                                                            {{ @$item_tabungan_transaksi->credit }}
                                                        @endif
                                                    </td>
                                                    <td class="text-center">
                                                        @if (!empty($item_tabungan_transaksi->debet))
                                                            DB
                                                        @else
                                                            CR
                                                        @endif
                                                    </td>
                                                    <td class="text-right">
                                                        @if (!empty($item_tabungan_transaksi->jumlah_dana))
                                                            Rp. {{ number_format($item_tabungan_transaksi->jumlah_dana) }}
                                                        @else
                                                            @if(strstr(strtolower($item_tabungan_transaksi->keterangan), 'saver'))
                                                                {{ number_format(@$item_tabungan_transaksi->gold_saver_detail->nominal) }}
                                                            @endif
                                                        @endif
                                                    </td>
                                                    <td class="text-right">
                                                        @if (!empty($item_tabungan_transaksi->pajak_asli))
                                                            Rp. {{ number_format($item_tabungan_transaksi->pajak_asli) }}
                                                        @endif
                                                    </td>
                                                    <td class="text-right">
                                                        @if (!empty($item_tabungan_transaksi->pajak_terhitung))
                                                            {{ $item_tabungan_transaksi->pajak_terhitung }} %
                                                        @endif
                                                    </td>
                                                    <td class="text-right">
                                                        @if (!empty($item_tabungan_transaksi->id_transaksi_voucher_lakuemasbeli))
                                                            {{ $item_tabungan_transaksi->transaksi_voucher_lakuemasbeli->voucher_code }}
                                                            @if (!empty($item_tabungan_transaksi->transaksi_voucher_lakuemasbeli->voucher_percentage))
                                                                ({{ $item_tabungan_transaksi->transaksi_voucher_lakuemasbeli->voucher_percentage }}%)
                                                            @endif
                                                            <br>Rp.
                                                            {{ number_format($item_tabungan_transaksi->transaksi_voucher_lakuemasbeli->voucher_nominal) }}
                                                        @endif
                                                    </td>
                                                    <td class="text-right">
                                                        @if (!empty($item_tabungan_transaksi->total_dana_setor))
                                                            Rp.
                                                            {{ number_format($item_tabungan_transaksi->total_dana_setor) }}
                                                        @endif
                                                    </td>
                                                    <td class="text-right">Rp.
                                                        {{ number_format($item_tabungan_transaksi->harga_beli) }}</td>
                                                    <td class="text-right">Rp.
                                                        {{ number_format($item_tabungan_transaksi->harga_jual) }}
                                                        @if($item_tabungan_transaksi->is_elite == 'yes') 
                                                        <br><img src="{{ asset('images/logo-elite.png') }}" width="15" alt=""> 
                                                        @endif
                                                    </td>
                                                    <td class="text-center">{{ $item_tabungan_transaksi->keterangan }}
                                                    </td>
                                                    <td class="text-center">
                                                        {{ @$item_tabungan_transaksi->payment_channel->label }}</td>
                                                </tr>
                                            @endforeach
                                        @empty
                                            <tr>
                                                <td colspan="19" class="text-center">No data</td>
                                            </tr>
                                        @endforelse
                                    </tbody>
                                </table>

                                <div style="padding:30; text-align:center">
                                    {{ $transaksi->appends(['date_start' => @$_GET['date_start'], 'date_end' => @$_GET['date_end'], 'transaction_type' => @$_GET['transaction_type'], 'find' => @$_GET['find']])->links() }}
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
            <input type="hidden" id="is_downloaded" value="0">
            @include('includes.footer')
        </div>
    </div>
@endsection


@section('scripts')
    <script type="text/javascript">
        $(document).ready(function() {
            getSummaryData();
        });
        function getSummaryData() {

            $.ajax({
                url: '{{ url('reporting/lakuemas_detail/get_summary') }}?date_start={{ $request['date_start'] }}&date_end={{ $request['date_end'] }}&transaction_type={{ $request['transaction_type'] }}&find={{ $request['find'] }}',
                method: "GET",
                headers: {
                    'X-CSRF-TOKEN': $('meta[name="csrf-token"]').attr('content')
                },
            }).done(function(response) {
                setTimeout(function() { 
                    $('#summary_total_emas').html(response.result.total_emas);
                    $('#summary_total_tabungan_aktif').html(response.result.total_tabungan_aktif);
                    $('#summary_total_pajak').html(response.result.total_pajak);
                    $('#summary_total_beli').html(response.result.total_beli);
                    $('#summary_rp_beli').html(response.result.rp_beli);
                    $('#summary_total_jual').html(response.result.total_jual);
                    $('#summary_rp_jual').html(response.result.rp_jual);
                    $('#summary_total_tarik').html(response.result.total_tarik);
                    $('#summary_total_tarik_biaya_cetak').html(response.result.total_tarik_biaya_cetak);
                    $('#summary_total_redeem').html(response.result.total_redeem);
                    $('#summary_total_redeem_pajak').html(response.result.total_redeem_pajak);
                    $('#summary_total_redeem_rupiah').html(response.result.rp_redeem);
					
                    $('#summary_tf_totalqty').html(response.result.tf_qty);
                    $('#summary_tf_totalpecahan').html(response.result.tf_pecahan);
                    $('#summary_tf_totalrupiah').html(response.result.tf_rupiah);

                    $('#loadingSummary').hide();
                    $('#summaryData').fadeIn();
					
					getDetailRupiahBeli(response.result.rp_beli_unformat)
                }, 1000)
            });
        }

        function getDetailRupiahBeli(rp_beli_unformat) {
            $.ajax({
                url: '{{ url('reporting/lakuemas_detail/get_summary_detail_buy') }}?date_start={{ $request['date_start'] }}&date_end={{ $request['date_end'] }}&transaction_type={{ $request['transaction_type'] }}&find={{ $request['find'] }}',
                method: "GET",
                headers: {
                    'X-CSRF-TOKEN': $('meta[name="csrf-token"]').attr('content')
                },
            }).done(function(response) {
                setTimeout(function() { 
                    $('#summary_discount_rp_beli').html("Rp. <span>"+response.result.beli_discount+"</span>,-");
                    $('#summary_total_rp_beli').html("Rp. <span>"+parseInt(rp_beli_unformat - response.result.beli_discount_unformat).toLocaleString()+"</span>,-");
                }, 1000)
            });
        }
    </script>
@endsection