@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><i class="fa fa-edit"></i> Digital Gold Transaction List</h3>
                </div>
                <div class="clearfix"></div>
            </div>

            <div class="row">                
                <div class="col-xs-12">
                    <div class="x_panel">                        
                        <div class="x_content">
                            <form class="form-horizontal">
                                <div class="col-xs-12 col-sm-6">
                                    <div class="form-group">
                                        <label class="col-xs-12 col-sm-3 control-label">Trx Code :</label>
                                        <div class="col-xs-12 col-sm-9">
                                            <input type="text" class="form-control" name="trx_code" value="{{ $request['trx_code'] }}" placeholder="Transaction Code">
                                        </div>
                                    </div>
                                    <div class="form-group">
                                        <label class="col-xs-12 col-sm-3 control-label">Trx Status :</label>
                                        <div class="col-xs-12 col-sm-9">
                                            <select class="form-control" name="status_trx">
                                                <option value="all">All</option>
                                                @if($request['status_trx']) 
                                                    <option value="paid" @if($request['status_trx'] == 'paid') selected @endif>Paid</option>
                                                    <option value="unpaid" @if($request['status_trx'] == 'unpaid') selected @endif>Unpaid</option>
                                                @else
                                                    <option value="paid" selected>Paid</option>
                                                    <option value="unpaid">Unpaid</option>
                                                @endif
                                            </select>
                                        </div>
                                    </div>
                                    <div class="form-group">
                                        <label class="col-xs-12 col-sm-3 control-label">Customer :</label>
                                        <div class="col-xs-12 col-sm-9">
                                            <input type="text" class="form-control" name="customer_name" value="{{ $request['customer_name'] }}" placeholder="Name or Handphone">
                                        </div>
                                    </div>
                                    <div class="form-group">
                                        <label class="col-xs-12 col-sm-3 control-label">JR :</label>
                                        <div class="col-xs-12 col-sm-9">
                                            <input type="text" class="form-control" name="jr_name" value="{{ $request['jr_name'] }}" placeholder="Name or NIK">
                                        </div>
                                    </div>
                                </div>
                                <div class="col-xs-12 col-sm-6">
                                    <div class="form-group">
                                        <label class="col-xs-12 col-sm-3 control-label">Store :</label>
                                        <div class="col-xs-12 col-sm-9">
                                            <select class="form-control" name="store">
                                                <option value="all">All</option>
                                                @foreach($stores as $store)
                                                    <option value="{{ $store->code }}" @if($store->code == $request['store']) @endif>{{ $store->m_nama }}</option>
                                                @endforeach
                                            </select>
                                        </div>
                                    </div>
                                    <div class="form-group">
                                        <label class="col-xs-12 col-sm-3 control-label">Start :</label>
                                        <div class="col-xs-12 col-sm-9">
                                            <input type="date" class="form-control" name="start" value="{{ $request['start'] }}">
                                        </div>
                                    </div>
                                    <div class="form-group">
                                        <label class="col-xs-12 col-sm-3 control-label">End :</label>
                                        <div class="col-xs-12 col-sm-9">
                                            <input type="date" class="form-control" name="end" value="{{ $request['end'] }}">
                                        </div>
                                    </div>
                                </div>
                                <div class="col-xs-12 text-center" style="margin-top: 10px;">
                                    <button type="submit" class="btn btn-primary"><i class="fa fa-search"></i> Search</button>
                                    <a href="{{ url('cmk_lei/digital_gold') }}" class="btn btn-warning"><i class="fa fa-trash"></i> Reset Form</a>
                                    <a href="{{ route('cmk_lei/digital_gold_download', [
                                        'store' => $request['store'],
                                        'start' => $request['start'],
                                        'end' => $request['end'],
                                        'trx_code'=> $request['trx_code'],
                                        'status_trx' => $request['status_trx'],
                                        'unpaid' => $request['unpaid'],
                                        'customer_name' => $request['customer_name'],
                                        'jr_name' => $request['jr_name']
                                    ]) }}" class="btn btn-info"><i class="fa fa-download"></i> Download</a>
                                </div>
                            </form>
                        </div>
                    </div>
                </div>
            </div>

            <div class="row">
                <div class="col-sm-3"></div>
                <div class="col-sm-3">
                    <div class="text-center" style="border: 1px solid #0f967e; border-radius: 5px; background: #1aba9e; color: #fff; width: 100%; padding: 5px;">
                        <div><i class="fa fa-balance-scale"></i> Total By Gram</div>
                        <div style="font-size: 40px;"><b id="sumWeight"><i class="fa fa-spinner fa fa-pulse"></i></b></div>
                        <div>Gram</div>
                    </div>
                </div>
                <div class="col-sm-3">
                    <div class="text-center" style="border: 1px solid #0f967e; border-radius: 5px; background: #FFB300; color: #fff; width: 100%; padding: 5px;">
                        <div><i class="fa fa-money"></i> Total By Rupiah</div>
                        <div style="font-size: 40px;"><b id="sumRupiah"><i class="fa fa-spinner fa fa-pulse"></i></b></div>
                        <div>Rupiah</div>
                    </div>
                </div>
            </div>
            <div class="row">                
                <div class="col-xs-12">
                    <div class="x_panel">                        
                        <div class="x_content" style="zoom: 0.9; overflow: auto;">
                            <table id="table_subscriber" class="table table-bordered table-striped">
                                <thead>
                                    <tr>
                                        <th>No</th>
                                        <th>Store</th>
                                        <th>Trx Code</th>
                                        <th>Date</th>
                                        <th>Customer</th>
                                        <th>JR</th>
                                        <th class="text-right">Gold Weight</th>
                                        <th class="text-right">Harga Jual</th>
                                        <th class="text-right">Harga Beli</th>
                                        <th class="text-right">Total Before Tax</th>
                                        <th class="text-right">Biaya Layanan</th>
                                        <th class="text-right">Discount</th>
                                        {{-- <th class="text-right">Tax Percentage</th>
                                        <th class="text-right">Tax Nominal</th> --}}
                                        <th class="text-right">Total After Tax</th>
                                        <th class="text-right">Payment Method</th>
                                        <th class="text-right">Status</th>
                                        {{-- <th width="50">#</th> --}}
                                    </tr>
                                </thead>
                                <tbody>
                                    @php
                                        $total_weight = $total_rupiah = 0;
                                    @endphp
                                    @forelse($transactions as $key => $transaction)
                                        @php
                                            $transaksi = $transaction->transaksi;
                                            $tabungan_transaksi = $transaksi->tabungan_transaksi[0];
                                            $customer = $tabungan_transaksi->tabungan->customer;

                                            if($transaksi->status == 1) {
                                                $total_weight = bcadd($total_weight, $tabungan_transaksi->credit, 4);
                                                $total_rupiah += ($tabungan_transaksi->jumlah_dana - $tabungan_transaksi->pajak_asli);
                                            }
                                        @endphp
                                        <tr>
                                            <td class="text-left">{{ $key+1 }}</td>
                                            <td class="text-left">
                                                @if($transaction->agent->cmk_sales)
                                                    {{ $transaction->agent->cmk_sales->nama_store }}
                                                @else
                                                    ~
                                                @endif
                                            </td>
                                            <td class="text-left">
                                                {{ $transaction->transaksi->code }}
                                                @if(in_array(auth()->user()->username, explode(',', env('USER_APPROVER_CMK_API'))) && ($transaksi->status == 1))
                                                    @if($transaction->response_status != '200')
                                                        <button class="btn btn-primary" style="color: #ff0" onclick="pushTrx('{{ $transaction->transaksi->code }}')"><i class="fa fa-rocket"></i> Push To CMK Trx</button>
                                                    @else
                                                        <br>
                                                        <small><i class="fa fa-handshake-o"></i> Completed </small>
                                                    @endif
                                                @endif
                                            </td>
                                            <td class="text-left">
                                                <div style="width: 80px;">
                                                    {{ ($transaksi->date_approved) }}
                                                </div>
                                            </td>
                                            <td class="text-left">
                                                {{ $customer->name }}<br>
                                                <small>{{ $customer->handphone }}</small>
                                            </td>
                                            <td class="text-left">
                                                @if($transaction->agent->cmk_sales)
                                                    @php
                                                        $agentSales = $transaction->agent->cmk_sales;
                                                    @endphp
                                                    {{ $agentSales->nama }}<br>
                                                    <small>{{ $agentSales->nik }}</small>
                                                @else
                                                    ~
                                                @endif
                                            </td>
                                            <td class="text-right">{{ $tabungan_transaksi->credit }}</td>
                                            <td class="text-right">{{ number_format($tabungan_transaksi->harga_jual) }}</td>
                                            <td class="text-right">{{ number_format($tabungan_transaksi->harga_beli) }}</td>
                                            {{-- <td class="text-right">{{ number_format($tabungan_transaksi->jumlah_dana - $tabungan_transaksi->pajak_asli) }}</td> --}}

                                            <td class="text-right">{{ number_format($transaction->total_transaction) }}</td>
                                            <td class="text-right">{{ number_format($tabungan_transaksi->biaya_layanan) }}</td>
                                            <td class="text-right">{{ number_format($transaction->discount_nominal) }}</td>
                                            {{-- <td class="text-right">{{ $tabungan_transaksi->pajak_terhitung }}</td>
                                            <td class="text-right">{{ number_format($tabungan_transaksi->pajak_asli) }}</td> --}}
                                            <td class="text-right">{{ number_format($tabungan_transaksi->total_dana_setor) }}</td>
                                            <td class="text-right">{{ $transaction->payment_method }}</td>
                                            <td class="text-right">
                                                @if($transaksi->status == 1) Paid
                                                @elseif($transaksi->status == 2) Cancelled
                                                @elseif($transaksi->status == 0) Unpaid
                                                @else ~
                                                @endif
                                            </td>
                                        </tr>
                                    @empty
                                        <tr>
                                            <td colspan="15" class="text-center">No Data</td>
                                        </tr>
                                    @endforelse
                                </tbody>
                                <tfoot>
                                    <tr>
                                        <td colspan="6" class="text-right">TOTAL WEIGHT</td>
                                        <td class="text-right" id="sumWeightVal">{{ $total_weight }}</td>
                                        <td colspan="2" class="text-right">TOTAL RUPIAH</td>
                                        <td class="text-right" id="sumRupiahVal">{{ number_format($total_rupiah) }}</td>
                                    </tr>
                                </tfoot>
                            </table>
                            <div style="text-align:center">{{ $transactions->appends($_GET)->links() }}</div>
                        </div>
                    </div>
                </div>
            </div>
        </div>
        @include('includes.footer')
    </div>
</div>
@endsection


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

        function getTotalPaid() {
            $.ajax({
                url: '{{ url("cmk_lei/digital_gold/get_total_paid") }}?trx_code={{ $request['trx_code'] }}&status_trx={{ $request['status_trx'] }}&customer_name={{ $request['customer_name'] }}&jr_name={{ $request['jr_name'] }}&store={{ $request['store'] ? : 'all' }}&start={{ $request['start'] }}&end={{ $request['end'] }}',
                method: "GET",
                headers: {
                    'X-CSRF-TOKEN': $('meta[name="csrf-token"]').attr('content')
                },
            }).done(function (response) {
                $('#sumWeight').html(response.result.total_weight);
                $('#sumRupiah').html(response.result.total_rupiah);
            });
        }

        function pushTrx(code) {
            if (confirm("Apakah Anda yakin ingin mengirim transaksi dengan code "+ code +" ke CMK ?") == true) {
                if (confirm("Anda bener - benar yakin kan ?") == true) {
                    location.href = '{{ url('cmk_lei/digital_gold/push_to_cmk') }}/' + code;
                }
            }
        }
    </script>
@endsection