@extends('layouts.layout')

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

@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" style="display: none;">
                        <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-3">
                                <div class="x_panel bg-green">
                                    <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">
                                                <label class="col-xs-5 control-label">Beli :</label>
                                                <div class="col-xs-7">
                                                    <p class="form-control-static"><span id="summary_total_beli"></span>
                                                        Gram</p>
                                                </div>
                                            </div>

                                            <div class="form-group">
                                                <label class="col-xs-5 control-label">Pajak :</label>
                                                <div class="col-xs-7">
                                                    <p class="form-control-static">Rp. <span
                                                            id="summary_total_pajak"></span>,-</p>
                                                </div>
                                            </div>

                                            <div class="form-group">
                                                <label class="col-xs-5 control-label">Rupiah :</label>
                                                <div class="col-xs-7">
                                                    <p class="form-control-static">Rp. <span id="summary_rp_beli"></span>,-
                                                    </p>
                                                </div>
                                            </div>
                                        </div>
                                    </div>
                                </div>
                            </div>

                            <div class="col-xs-12 col-sm-3">
                                <div class="x_panel" 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">
                                                <label class="col-xs-5 control-label">Redeem :</label>
                                                <div class="col-xs-7">
                                                    <p class="form-control-static"><span id="summary_total_redeem"></span>
                                                        Gram</p>
                                                </div>
                                            </div>
                                        </div>
                                        <div class="form-horizontal">
                                            <div class="form-group">
                                                <label class="col-xs-5 control-label">Pajak :</label>
                                                <div class="col-xs-7">
                                                    <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">
                                                <label class="col-xs-5 control-label">Rupiah :</label>
                                                <div class="col-xs-7">
                                                    <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, Customer Code or Customer Name"@isset($_GET['find']) {!! ' value="' . htmlentities($_GET['find'], ENT_COMPAT) . '"' !!} @endisset>
                                        </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="form-group">
                                <p>
                                    <a class="btn btn-success" data-toggle="collapse" href="#collapseExample"
                                        role="button" aria-expanded="false" aria-controls="collapseExample">
                                        Log Download
                                    </a>
                                </p>
                                <div class="collapse" id="collapseExample">
                                    <div class="card card-body">
                                        <table id="myTable" class="table table-bordered table-striped"
                                            style="zoom: 0.75;">
                                            <thead>
                                                <tr>
                                                    <th class="text-center">Tanggal</th>
                                                    <th class="text-center">Nama</th>
                                                    <th class="text-center">File Name</th>
                                                    <th class="text-center">Status</th>
                                                    <th class="text-center">Action</th>
                                                </tr>
                                            </thead>
                                            <tbody id="load_summary_customer">
                                                @foreach ($download_file as $data)
                                                <tr>
                                                    <td class="text-left">{{ $data->created_at }}</td>
                                                    <td class="text-left">
                                                        {{ $data->users->name }}
                                                        <div>
                                                            <small>({{ $data->users->username }})</small>
                                                        </div>
                                                    </td>
                                                    <td class="text-left">{{ $data->file_name }}</td>
                                                    <td class="text-left">
                                                        @if ($data->status == '1')
                                                            Berhasil
                                                        @endif
                                                    </td>
                                                    <td class="text-left">
                                                        @if ($data->status == '1')
                                                            @php
                                                                $hasDownloadReady = true;
                                                            @endphp

                                                <a href="{{ route('ready/download_omset_lakuemas', [
                                                                'name' => $data->file_name,
                                                            ]) }}"
                                                                target="_blank" class="btn btn-success"
                                                                id="btn_ready_download" onclick="downloadReadyFile()"
                                                                style="display: ;"><i class="fa fa fa-check"></i>
                                                                Download
                                                            </a>
                                                        @endif
                                                    </td>
                                                </tr>
                                            @endforeach
                                            </tbody>
                                        </table>
                                    </div>
                                </div>
                            </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 class="col-sm-6 text-right">
                                        @if ($download_ready)
                                            @if ($download_ready->status == '0')
                                                <button class="btn btn-warning" id="prosess" style="display: show;"
                                                    disabled><i class="fa fa fa-pulse fa-clock-o"></i> Sedang mendownload
                                                    file</button>
                                            @else
                                                @php
                                                    $date_end = \Carbon\Carbon::parse($request['date_end'])->format('Y-m-d');
                                                @endphp
                                                @if(\Carbon\Carbon::parse($request['date_start'])->diffInDays($date_end) <= 31)
                                                    <a href="{{ route('download_omset_lakuemas', [
                                                        'start' => $request['date_start'] ?: date('Y-m-d'), 
                                                        'end' => $request['date_end'] ?: date('Y-m-d'),
                                                        'transaction_type' => $request['transaction_type'] ?? null
                                                        ]) }}"
                                                        
                                                        class="btn btn-primary" style="display: ;"><i
                                                            class="fa fa-download"></i>
                                                        Download</a>
                                                @else
                                                    <button class="btn btn-primary"
                                                    disabled><i class="fa fa-download"></i> Download</button>
                                                    <br>
                                                    <label class="text-danger">
                                                        Maksimal Download 30 atau 31 Hari
                                                    </label>
                                                @endif
                                            @endif
                                        @else
                                            <a href="{{ route('download_omset_lakuemas', [
                                                'start' => $request['date_start'] ?: date('Y-m-d'), 
                                                'end' => $request['date_end'] ?: date('Y-m-d'),
                                                'transaction_type' => $request['transaction_type'] ?? null
                                                ]) }}"
                                                class="btn btn-primary" style="display: ;"><i class="fa fa-download"></i>
                                                Download</a>
                                        @endif
                                    </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) }}</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() {
            $('#myTable').DataTable({
                searching: false,
                lengthChange: false,
                pageLength: 5,
                order: [
                    [0, 'desc']
                ]
            });
        });
        @if ($download_ready)
            @if ($download_ready->status == '0')
                setInterval(() => {
                    var is_downloaded = $('#is_downloaded').val();
                    if (is_downloaded == '0') {
                        check_download_proceess({{ $download_ready->id }});
                    }
                }, 5000);
            @endif
        @endif

        function check_download_proceess(id) {
            $.ajax({
                url: "{{ url('reporting/transaksi_lakuemas/check_download_process') }}/" + id,
                method: "GET",
                headers: {
                    'X-CSRF-TOKEN': $('meta[name="csrf-token"]').attr('content')
                },
            }).done(function(response) {
                if (response.status == "completed") {
                    $('#is_downloaded').val(1);
                    $('#file_download').show();
                    $('#prosess').hide();

                    //  var downloadConfirmation = confirm("silahkan klik ok untuk proses selanjutnya!!");
                    //  if (downloadConfirmation) {
                    alert("Proses Download Anda Selesai")
                    location.reload();
                    //  }

                    // setTimeout(function() {
                    //     location.reload();
                    // }, 1000);
                }
            });
            return false;
        }
        $(document).ready(function() {
            //getSummaryData();
        });


        function getSummaryData() {

            $.ajax({
                url: "{{ url('reporting/omset_lakuemas/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_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);

                    $('#loadingSummary').hide();
                    $('#summaryData').fadeIn();
                }, 1000)
            });
        }
    </script>
@endsection