@extends('layouts.layout')

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

@section('css')
<link rel="stylesheet" href="{{ asset('/css/dashboard.css') }}">
<link rel="stylesheet" href="//cdnjs.cloudflare.com/ajax/libs/morris.js/0.5.1/morris.css">
<style type="text/css">
.h-50 {
	height: 50px;
}
</style>
@endsection

@section('body_content')
<div class="container body">
	<div class="main_container">
		@include('includes.sidebar')
		<div class="right_col" role="main">
			<div class="row">
				<div class="col-xs-12">
					<div class="x_panel">
						<div class="row x_title">
							<div class="col-md-12 h-50">
								<h5>Customer Wallet Transaction</h5>
							</div>
						</div>
						<div class="x_content">
							<form class="form-horizontal">
								<div class="form-group">
									<label for="find" class="col-sm-2 control-label">Start Date</label>
									<div class="col-sm-10">
										<input type="date" class="form-control" id="sdate" name="sdate" placeholder="Keyword"@if(!empty($_GET['sdate'])) value="{{ $_GET['sdate'] }}" @else value="2021-11-14" @endif required>
									</div>
								</div>
								<div class="form-group">
									<label for="find" class="col-sm-2 control-label">End Date</label>
									<div class="col-sm-10">
										<input type="date" class="form-control" id="edate" name="edate" placeholder="Keyword"@if(!empty($_GET['edate'])) value="{{ $_GET['edate'] }}" @endif required>
									</div>
								</div>
								<div class="form-group">
									<!--<label for="find" class="col-sm-2 control-label">Find</label>
									<div class="col-sm-10">
										<input class="form-control" id="find" name="find"@if(!empty($_GET['find'])) value="{{ $_GET['find'] }}" @endif placeholder="Search by Email, Mobile Phone or Customer Code" required>
									</div>-->
									<label for="find" class="col-sm-2 control-label">Find</label>
									<div class="col-sm-10">
										<!--<label class="sr-only" for="find">Amount (in dollars)</label>-->
										<div class="input-group">
											<!--<div class="input-group-addon">$</div>-->
											<input class="form-control" id="find" name="find"@if(!empty($_GET['find'])) value="{{ $_GET['find'] }}" @endif placeholder="Search by Email, Mobile Phone, Customer Code, Trx. Code or Wallet Trx. Code">
											<div class="input-group-addon">@if(trim(@$_GET['find'])!='' && !empty($wallet_trx[0]->wallet->customer->name)) {!! $wallet_trx[0]->wallet->customer->name . ' / <a class="btn-find" role="button">' . $wallet_trx[0]->wallet->customer->email . '</a> / '.(number_format($wallet_trx[0]->wallet->nominal + 0, 0, ',', '.')) !!} @else &nbsp; @endif</div>
										</div>
									</div>
								</div>
								<div class="form-group">
									<div class="col-sm-offset-2 col-sm-10"><input type="submit" class="btn btn-default" value="Get Data">
								</div>
							</form>
						</div>
					</div>
				</div>
			</div>
			@if(!empty($wallet_trx))
			<div class="row">
				<div class="col-xs-12">
					<table class="table table-striped">
					<thead>
					<tr>
						<th class="text-center">ID</th>
						<th class="text-center">Kode Trx. Wallet</th>
						<th class="text-center">Tipe Trx.</th>
						<th class="text-center">Nominal</th>
						{{-- <th class="text-center">Saldo Akhir</th> --}}
						<th class="text-center">HB</th>
						<th class="text-center">Status</th>
						<th class="text-center">Wkt. Approval</th>
						{{-- <th class="text-center">Wkt. Transaksi</th> --}}
					</tr>
					</thead>
					<tbody>
				@php
					$nilai_baru = $last_val = 0;
				@endphp
				@foreach($wallet_trx as $k=>$v)
					<tr>
						<td class="text-center">{{ $v->id }}</td>
						<td class="text-center"><a class="btn-find" role="button">{{ $v->code }}</a></td>
						<td class="text-center">{{ App\Models\Wallet_transaction_model::TYPE[$v->type] }} <span class="label label-info">@if($v->type==1) {{ @$v->metode_pembayaran->label }} @elseif($v->type==2) {{ $v->customer_bank . ' / '.preg_replace('/^\d{6}/', 'xxxxxx', $v->customer_bank_nomor_rekening) }}</span> @elseif(in_array($v->type, [3, 4, 5, 7])) <a class="btn-find" role="button"><span class="label label-info">@if(in_array($v->type, [3, 4])) {{ @$v->parent_trx->code }} @elseif(in_array($v->type, [5, 7])) {{ @$v->transaksi->code }} @endif</span></a> @endif</td>
						<td class="text-right">{{ $v->nominal }}</td>
						{{-- <td class="text-right">{{ $v->saldo_akhir }}</td> --}}
						
						@php
							if($k == 0) {
								$nilai_baru = $last_val = $v->saldo_akhir;
							}
							else {
								if(in_array($v->type, ['4', '7'])) {
									$last_val = $last_val + $v->nominal;
								}
								else { 
									# 3
									$last_val = $last_val - $v->nominal;
								}
								
								$nilai_baru = $last_val;
							}
						@endphp
						
						<td class="text-right">{{ $nilai_baru }}</td>
						<td class="text-center">
							<span class="label @if($v->status==0) label-default @elseif($v->status==1) label-success @elseif($v->status==2) label-danger @elseif($v->status==5) label-warning @endif">{{ App\Models\Wallet_transaction_model::STATUS[$v->status] }}</span>
						</td>
						<td class="text-center">@if(empty($v->date_approved)) - @else {{ date('d-m-Y H:i:s', strtotime($v->date_approved)) }} @endif</td>
						{{-- <td class="text-center">{{ date('d-m-Y H:i:s', strtotime($v->created_at)) }}</td> --}}
					</tr>
				@endforeach
					</tbody>
					<tfoot>
					<tr>
						<td align="center" colspan="10">{{ $wallet_trx->appends(['sdate' => @$_GET['sdate'], 'edate' => @$_GET['edate'], 'find' => @$_GET['find']])->links() }}</td>
					</tr>
					</tfoot>
					</table>
				</div>
			</div>
			@endif
		</div>
		@include('includes.footer')
	</div>
</div>
@endsection

@section('scripts')
<script src="//cdnjs.cloudflare.com/ajax/libs/raphael/2.1.0/raphael-min.js"></script>
<script src="//cdnjs.cloudflare.com/ajax/libs/morris.js/0.5.1/morris.min.js"></script>
<script type="text/javascript">
$(function(){
	if($.trim($("#find").val())!="") $("#find").select();
	else $(".form-horizontal :input:eq(0)").focus();

	$("#sdate, #edate").change(function(){
		if($("#sdate").val()!="undefined" && $("#edate").val()!="undefined" && new Date($("#sdate").val())>new Date($("#edate").val())) {
			var tmp = $("#edate").val();
			$("#edate").val($("#sdate").val());
			$("#sdate").val(tmp);
			$(this).trigger("blur");
			$("#find").focus();
		}
	});

	$(".btn-find").click(function(){
		window.location.href = "{!! route('wallet/customer', ['sdate' => @$_GET['sdate'], 'edate' => @$_GET['edate']  ]) !!}&find="+$.trim($(this).text());
	});

	$(".fa-bars").trigger("click");

	$("#calculate").click(function(){
		$(this).hide();
		if($("abbr:contains('HB')").length==0) {
			$("th:contains('Saldo Akhir')").after($("<th>").attr({"class":"text-center"}).append($("<abbr>").attr({"title":"Hitung Baru"}).html("HB")));
			$(".table-striped tbody tr").each(function(i, row){
				if($("td:eq(5)", row).text().toLowerCase()=="active") {
					if(i==0) {
						nilai_baru = last_val = parseInt($("td:eq(4)", row).html().replace(/\./g,""));
					} else {
						nilai_baru = parseInt($("td:eq(5)", $(row).prev()).html().replace(/\./g,""));
						if($("td:eq(2)", row).html().toLowerCase().match(/^(top up|sell gold|buy payment|cashout payment|withdraw|correction credit)/g)!=null && $.inArray($("td:eq(2)", row).html().toLowerCase().match(/^(top up|sell gold|buy payment|cashout payment|withdraw|correction credit)/g)[0], ['top up', 'sell gold', 'correction credit'])!=-1) nilai_baru = last_val + parseInt($("td:eq(3)", row).html().replace(/\./g,""));
						else if($("td:eq(2)", row).html().toLowerCase().match(/^(top up|sell gold|buy payment|cashout payment|withdraw|correction debet)/g)!=null && $.inArray($("td:eq(2)", row).html().toLowerCase().match(/^(top up|sell gold|buy payment|cashout payment|withdraw|correction debet)/g)[0], ['buy payment', 'cashout payment', 'withdraw', 'correction debet'])!=-1) nilai_baru = last_val - parseInt($("td:eq(3)", row).html().replace(/\./g,""));
						last_val = nilai_baru;
					}
					console.log('last_val', row, last_val);
				} else nilai_baru = 0;
				$("td:eq(4)", row).after($("<td>").attr({"class":"text-right"}).html(nilai_baru));
				if($("td:eq(6)", row).text().toLowerCase()=="active" && $("td:eq(4)", row).html()!=$("td:eq(5)", row).html()) $(row).css("border", "2px solid red");
			});
		}
	});
});
</script>
@endsection