@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>Butik Emas Transaction List</h3>
                </div>
                <div class="clearfix"></div>
            </div>

            <div class="row">                
                <div class="col-xs-12 col-sm-6">
                    <div class="x_panel">                        
                        <div class="x_content">
                            <form class="form-horizontal">
                                    <div class="form-group">
                                        <label class="col-xs-12 col-sm-3 control-label">Invoice :</label>
                                        <div class="col-xs-12 col-sm-9">
                                            <input type="text" class="form-control" name="invoice" value="{{ $request['invoice'] }}" placeholder="Cust Name or Invoice">
                                        </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 class="form-group">
                                        <label class="col-xs-12 col-sm-3 control-label">Status :</label>
                                        <div class="col-xs-12 col-sm-9">
                                            <select class="form-control" name="status">
                                                <option value="all" {{ request('status') == 'all' ? 'selected' : '' }}>All</option>
                                                @foreach($available_status_list as $available_status)
                                                    <option value="{{ $available_status['id'] }}" 
                                                        {{ request('status') == $available_status['id'] ? 'selected' : '' }}>
                                                        {{ $available_status['text'] }}
                                                    </option>
                                                @endforeach
                                            </select>
                                        </div>
                                    </div>
                                    <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" {{ request('store') == 'all' ? 'selected' : '' }}>All</option>
                                                @foreach($store_brands as $store_brand)
                                                    @foreach($store_brand->store as $store)
                                                        <option value="{{ $store->id }}" {{ request('store') == $store->id ? 'selected' : '' }}>
                                                            {{ $store_brand->name }} {{ $store->name }}
                                                        </option>
                                                    @endforeach
                                                @endforeach
                                            </select>
                                        </div>
                                    </div>
                                    <div class="form-group">
                                        <label class="col-xs-12 col-sm-3 control-label">Status Pengiriman :</label>
                                        <div class="col-xs-12 col-sm-9">
                                            <select class="form-control" id="lokasi" name="lokasi">
                                                <option value="all" {{ $request['lokasi'] == 'all' ? 'selected' : '' }}>All</option>
                                                <option value="stock_toko" {{ $request['lokasi'] == 'stock_toko' ? 'selected' : '' }}>Stock Toko</option>
                                                <option value="dalam_perjalanan" {{ $request['lokasi'] == 'dalam_perjalanan' ? 'selected' : '' }}>Dalam Perjalanan</option>
                                                <option value="diterima_di_pusat" {{ $request['lokasi'] == 'diterima_di_pusat' ? 'selected' : '' }}>Diterima di Pusat</option>
                                            </select>
                                        </div>
                                    </div>
                                <div class="col-xs-12 text-right">
                                    <a href="{{ route('butik/resell/transaction/download', [
                                        'invoice' => $request['invoice'],
                                        'status' => $request['status'],
                                        'store' => $request['store'],
                                        'start' => $request['start'],
                                        'end' => $request['end'],
                                        'lokasi' => $request['lokasi'],
                                        ])
                                        }}" target="_blank" class="btn btn-default">Download
                                    </a>
                                    <button type="submit" class="btn btn-default">Search</button>
                                </div>
                            </form>
                        </div>
                    </div>
                </div>
                <div class="col-xs-12 col-sm-6">
                        <div class="x_panel">
                            <div class="x_content">
                                <table class="table table-bordered table-striped">
                                    <thead>
                                        <tr>
                                            <th class="text-center">Item</th>
                                            <th class="text-center">Berat</th>
                                            <th class="text-center">Total Qty</th>
                                            <th class="text-center">Total Berat</th>
                                            <th class="text-center">Total Harga Beli Resell</th>
                                        </tr>
                                    </thead>
                                    <tbody>
                                        @php
                                            $totalQty = 0;
                                            $totalBerat = 0;
                                            $totalHarga = 0;
                                            $currentItemType = null;
                                            $rowspan = 0;
                                        @endphp
                                        
                                        @foreach ($data as $row)
                                            @if ($currentItemType !== $row->item_type->type)
                                                @php
                                                    $currentItemType = $row->item_type->type;
                                                    $rowspan = $data->where('item_type_id', $row->item_type_id)->count();
                                                @endphp

                                                <tr>
                                                    <td class="text-center" rowspan="{{ $rowspan }}">{{ $currentItemType }}</td>
                                                    <td class="text-center">{{ $row->weight_total }}</td>
                                                    <td class="text-right">{{ number_format($row->total_barang) }}</td>
                                                    <td class="text-right">{{ number_format((float) $row->berat, 2, '.', ',') }}</td>
                                                    <td class="text-right">{{ number_format($row->harga) }}</td>
                                                </tr>
                                            @else
                                                <tr>
                                                    <td class="text-center">{{ $row->weight_total }}</td>
                                                    <td class="text-right">{{ number_format($row->total_barang) }}</td>
                                                    <td class="text-right">{{ number_format((float) $row->berat, 2, '.', ',') }}</td>
                                                    <td class="text-right">{{ number_format($row->harga) }}</td>
                                                </tr>
                                            @endif

                                            @php
                                                $totalQty += $row->total_barang;
                                                $totalBerat += $row->berat;
                                                $totalHarga += $row->harga;
                                            @endphp
                                        @endforeach
                                    </tbody>
                                    <tfoot>
                                        <tr>
                                            <th class="text-right" colspan="2">Total</th>
                                            <th class="text-right">{{ number_format($totalQty) }}</th>
                                            <th class="text-right">{{ number_format((float) $totalBerat, 2, '.', ',') }}</th>
                                            <th class="text-right">{{ number_format($totalHarga) }}</th>
                                        </tr>
                                    </tfoot>
                                </table>
                            </div>
                        </div>
                    </div>
            </div>

            <div class="row">                
                <div class="col-xs-12">
                    <div class="x_panel">            
                        <div class="x_content" style="overflow: auto;">
                            <div class="x_title">
                                <div style="font-size: 15px; padding-top: 2px;">
                                    <table class="table table-bordered table-striped">
                                        <thead>
                                            <tr>
                                                <th class="text-center" colspan="3">Total Resell</th>
                                                <th class="text-center" colspan="3">Stock Resell Toko</th>
                                                <th class="text-center" colspan="3">Dalam Perjalanan</th>
                                                <th class="text-center" colspan="3">Diterima SK Pusat</th>
                                            </tr>
                                            <tr>
                                                <th class="text-center">JUMLAH <br> TRANSAKSI</th>
                                                <th class="text-center">JUMLAH <br> BARANG</th>
                                                <th class="text-center">BERAT <br> BARANG</th>
                                                <th class="text-center">JUMLAH <br> TRANSAKSI</th>
                                                <th class="text-center">JUMLAH <br> BARANG</th>
                                                <th class="text-center">BERAT <br> BARANG</th>
                                                <th class="text-center">JUMLAH <br> TRANSAKSI</th>
                                                <th class="text-center">JUMLAH <br> BARANG</th>
                                                <th class="text-center">BERAT <br> BARANG</th>
                                                <th class="text-center">JUMLAH <br> TRANSAKSI</th>
                                                <th class="text-center">JUMLAH <br> BARANG</th>
                                                <th class="text-center">BERAT <br> BARANG</th>
                                            </tr>
                                            </thead>
                                        <tbody>
                                            <tr>
                                                <td class="text-right">{{ number_format($data_transaksi) }}</td>
                                                <td class="text-right">{{ number_format($data_transaksi_qty) }}</td>
                                                <td class="text-right">{{ number_format($total_weight_transaksi, 2) }}</td>
                                                <td class="text-right">{{ number_format($total_toko_document) }}</td>
                                                <td class="text-right">{{ number_format($total_toko_qty) }} </td>
                                                <td class="text-right">{{ number_format($total_toko_weight, 2) }}</td>
                                                <td class="text-right">{{ number_format($dalam_perjalanan_document) }}</td>
                                                <td class="text-right">{{ number_format($dalam_perjalanan_qty) }}</td>
                                                <td class="text-right">{{ number_format($dalam_perjalanan_weight, 2) }}</td>
                                                <td class="text-right">{{ number_format($sk_pusat_document) }}</td>
                                                <td class="text-right">{{ number_format($sk_pusat_qty) }}</td>
                                                <td class="text-right">{{ number_format($sk_pusat_weight, 2) }}</td>
                                            </tr>
                                        </tbody>
                                    </table>
                                </div>
                            </div>
                            <table class="table table-bordered table-striped">
                                <thead>
                                    <tr>
                                        <th class="text-center">ID</th>
                                        <th class="text-center">Invoice</th>
                                        <th class="text-center">Date</th>
                                        <th class="text-center">Status</th>
                                        <th class="text-center">Store</th>
                                        <th class="text-center">Name</th>
                                        <th class="text-center">Email</th>
                                        <th class="text-center">Handphone</th>
                                        <th class="text-right">Total</th>
                                        <th class="text-center">Lokasi Barang</th>
                                        <th width="50"></th>
                                    </tr>
                                </thead>
                                <tbody>
                                    @php
                                        $no = 1;
                                    @endphp
                                    @forelse($transactions as $transaction)
                                        <tr>
                                            <td class="text-center">{{ $no++ }}</td>
                                            <td class="text-center">{{ $transaction->invoice }}</td>
                                            <td class="text-center">{{ $transaction->invoice_date }}</td>
                                            <td class="text-center">{{ (\App\Models\Butik\Butik_store_resell_invoice_model::STATUS)[$transaction->status]['text'] }}</td>
                                            <td class="text-center">
												{{-- @if($transaction->store_request_open)
													{{ $transaction->store_request_open->store->brand->name }}<br>{{ $transaction->store_request_open->store->name }}
												@else
													~
												@endif
                                                --}}
                                                {{ $transaction->store->name }}
											</td>
                                            <td class="text-center">{{ $transaction->customer_name }}</td>
                                            <td class="text-center">{{ $transaction->customer_email }}</td>
                                            <td class="text-center">{{ $transaction->customer_handphone }}</td>
                                            <td class="text-right">{{ number_format($transaction->grandtotal) }}</td>
                                            <td>
                                                @if ($transaction->store_resellbox_id)
                                                        Stock Resell Toko
                                                    @else
                                                        @if ($transaction->resellbox_unload()->whereNotNull('received_at')->whereNotNull('received_by')->first())
                                                            Diterima di SK
                                                        @else
                                                            Dalam Perjalanan
                                                        @endif
                                                    @endif
                                            </td>
                                            <td class="text-center">
                                                <a href="{{ route('butik/resell/transaction/detail', ['id'=>$transaction->id]) }}" target="_blank"><i class="fa fa-search" aria-hidden="true"></i></a>
                                            </td>
                                        </tr>
                                    @empty
                                        <tr>
                                            <td colspan="10" class="text-center">No Data</td>
                                        </tr>
                                    @endforelse
                                </tbody>
                            </table>
                            <div style="text-align:center">{{ $transactions->appends($_GET)->links() }}</div>
                        </div>
                    </div>
                </div>
            </div>
        </div>
        @include('includes.footer')
    </div>
</div>
@endsection