@extends('layouts.admin_template')
@section('content')
<!-- container Start -->
<div class="container-fluid px-3 px-xxl-5">
	<div class="titel-head pb-4">
        <h1>Management Report</h1>
	</div>
	<div class="row">
		<div class="col-md-12">
			<form class="select2black" method="GET" action="{{ url('/admin/managementreport') }}">
				<div class="row">
					<div class="col-lg-2 col-md-2 col-sm-4 col-xs-6">
						<div class="form-group mb-3">
							<label><strong>@lang('translate.country') :</strong></label>
							<select name="country" class="select2 form-control form-control-lg bg-black">
								<option value="">All</option>
								@foreach($countrylists as $country)
									<option value="{{$country}}" @if($country == $countryselected) selected @endif>{{$country}}</option>
								@endforeach
							</select>
						</div>
					</div>
					<div class="col-lg-2 col-md-2 col-sm-4 col-xs-6">
						<div class="form-group mb-3">
							<label><strong>@lang('translate.marketing_name') :</strong></label>
							<select name="marketingid" class="select2 form-control form-control-lg bg-black">
								<option value="">All</option>
								@foreach($marketinglists as $marketing)
									<option value="{{$marketing->id}}" @if($marketing->id == $marketingselected) selected @endif>{{$marketing->name}}</option>
								@endforeach
							</select>
						</div>
					</div>
					<div class="col-lg-2 col-md-2 col-sm-4 col-xs-6">
						<div class="form-group mb-3">
							<label><strong>@lang('translate.from') :</strong></label>
							<input name="fromdate" type="text" class="form-control form-control-lg bg-dark" id="fromdate" value="{{$fromdate}}">
						</div>
					</div>
					<div class="col-lg-2 col-md-2 col-sm-4 col-xs-6">
						<div class="form-group mb-3">
							<label><strong>@lang('translate.to') :</strong></label>
							<input name="todate" type="text" class="form-control form-control-lg bg-dark" id="todate" value="{{$todate}}">
						</div>
					</div>
					<div class="col-lg-2 col-md-2 col-sm-4 col-xs-6">
						<div class="form-group mb-3" style="padding-top:20px;">
							<button type="submit" class="btn btn-sm btn-primary">@lang('translate.submit')</button>
						</div>
					</div>
				</div>
			</form>
		</div>
	</div>
	<div class="row">
		<div class="col-sm-6 col-md-3">
			<div class="card bg-dark rounded-3 mb-4">
				<div class="card-body">
					<div class="row align-items-center">
						<div class="col">
							<h5 class="card-title">@lang('translate.total_clients')</h5>
							<h1 class="mb-2">{{ count($useridarray) }}</h1>
						</div>
						<div class="col-auto">
							<div class="stat text-primary">
								<i class="fa fa-user"></i>
							</div>
						</div>
					</div>
				</div>
			</div>
		</div>
		<div class="col-sm-6 col-md-3">
			<div class="card bg-dark rounded-3 mb-4">
				<div class="card-body">
					<div class="row align-items-center">
						<div class="col">
							<h5 class="card-title">@lang('translate.total_deposit')</h5>
							<h1 class="mb-2">{{ $totaldeposit }}</h1>
						</div>
						<div class="col-auto">
							<div class="stat text-primary">
								<i class="fa fa-sack-dollar"></i>
							</div>
						</div>
					</div>
				</div>
			</div>
		</div>
		<div class="col-sm-6 col-md-3">
			<div class="card bg-dark rounded-3 mb-4">
				<div class="card-body">
					<div class="row align-items-center">
						<div class="col">
							<h5 class="card-title">@lang('translate.total_withdraw')</h5>
							<h1 class="mb-2">{{ $totalwithdraw }}</h1>
						</div>
						<div class="col-auto">
							<div class="stat text-primary">
								<i class="fa fa-money-bill"></i>
							</div>
						</div>
					</div>
				</div>
			</div>
		</div>
		<div class="col-sm-6 col-md-3">
			<div class="card bg-dark rounded-3 mb-4">
				<div class="card-body">
					<div class="row align-items-center">
						<div class="col">
							<h5 class="card-title">Net Deposit</h5>
							<h1 class="mb-2">{{ $netdeposit }}</h1>
						</div>
						<div class="col-auto">
							<div class="stat text-primary">
								<i class="fa fa-money-bill-transfer"></i>
							</div>
						</div>
					</div>
				</div>
			</div>
		</div>
	</div>
	<div class="row">
		<div class="col-sm-6 col-md-3">
			<div class="card bg-dark rounded-3 mb-4">
				<div class="card-body">
					<div class="row align-items-center">
						<div class="col">
							<h5 class="card-title">Profit</h5>
							<h1 class="mb-2">{{ $totoalpnl }}</h1>
						</div>
						<div class="col-auto">
							<div class="stat text-primary">
								<i class="fa fa-sack-dollar"></i>
							</div>
						</div>
					</div>
				</div>
			</div>
		</div>
		<div class="col-sm-6 col-md-3">
			<div class="card bg-dark rounded-3 mb-4">
				<div class="card-body">
					<div class="row align-items-center">
						<div class="col">
							<h5 class="card-title">Win Profit</h5>
							<h1 class="mb-2">{{ $totoalpositive }}</h1>
						</div>
						<div class="col-auto">
							<div class="stat text-primary">
								<i class="fa fa-sack-dollar"></i>
							</div>
						</div>
					</div>
				</div>
			</div>
		</div>
		<div class="col-sm-6 col-md-3">
			<div class="card bg-dark rounded-3 mb-4">
				<div class="card-body">
					<div class="row align-items-center">
						<div class="col">
							<h5 class="card-title">Loss Profit</h5>
							<h1 class="mb-2">{{ $totoalnegative }}</h1>
						</div>
						<div class="col-auto">
							<div class="stat text-primary">
								<i class="fa fa-sack-dollar"></i>
							</div>
						</div>
					</div>
				</div>
			</div>
		</div>
		<div class="col-sm-6 col-md-3">
			<div class="card bg-dark rounded-3 mb-4">
				<div class="card-body">
					<div class="row align-items-center">
						<div class="col">
							<h5 class="card-title">Closed Trades</h5>
							<h1 class="mb-2">{{ $totoaltrades }}</h1>
						</div>
						<div class="col-auto">
							<div class="stat text-primary">
								<i class="fa fa-sack-dollar"></i>
							</div>
						</div>
					</div>
				</div>
			</div>
		</div>

		<div class="col-sm-6 col-md-3">
			<div class="card bg-dark rounded-3 mb-4">
				<div class="card-body">
					<div class="row align-items-center">
						<div class="col">
							<h5 class="card-title">Avg.Loss</h5>
							<h1 class="mb-2">{{ round($avglossamount,2) }}</h1>
						</div>
						<div class="col-auto">
							<div class="stat text-primary">
								<i class="fa fa-sack-dollar"></i>
							</div>
						</div>
					</div>
				</div>
			</div>
		</div>

		<div class="col-sm-6 col-md-3">
			<div class="card bg-dark rounded-3 mb-4">
				<div class="card-body">
					<div class="row align-items-center">
						<div class="col">
							<h5 class="card-title">Avg.Win</h5>
							<h1 class="mb-2">{{ round($avgwinamount,2) }}</h1>
						</div>
						<div class="col-auto">
							<div class="stat text-primary">
								<i class="fa fa-sack-dollar"></i>
							</div>
						</div>
					</div>
				</div>
			</div>
		</div>

		<div class="col-sm-6 col-md-3">
			<div class="card bg-dark rounded-3 mb-4">
				<div class="card-body">
					<div class="row align-items-center">
						<div class="col">
							<h5 class="card-title">Total Lots</h5>
							<h1 class="mb-2">{{ $totoallot }}</h1>
						</div>
						<div class="col-auto">
							<div class="stat text-primary">
								<i class="fa fa-sack-dollar"></i>
							</div>
						</div>
					</div>
				</div>
			</div>
		</div>
		<div class="col-sm-6 col-md-3">
			<div class="card bg-dark rounded-3 mb-4">
				<div class="card-body">
					<div class="row align-items-center">
						<div class="col">
							<h5 class="card-title">Total Ib Commission</h5>
							<h1 class="mb-2">{{ $totoalibcommission }}</h1>
						</div>
						<div class="col-auto">
							<div class="stat text-primary">
								<i class="fa fa-sack-dollar"></i>
							</div>
						</div>
					</div>
				</div>
			</div>
		</div>

		

	</div>
	<div class="row">
		<div class="col-sm-12 col-md-6">
			<div class=" bg-dark rounded-3 p-3 borderbx mb-4">
				<div class="managementtitle mb-4">
					<h4>Country Wise Deposit Chart</h4>
				</div>
				<div class="chart">
					<canvas id="CountryWiseChart" style="height:300px"></canvas>
				</div>
			</div>
		</div>
		<div class="col-sm-12 col-md-6">
			<div class=" bg-dark rounded-3 p-3 borderbx mb-4">
				<div class="managementtitle mb-4">
					<h4>Top 10 Marketing</h4>
				</div>
				<table class="table table-dark table-striped mb-0 text-center table-hover">
					<thead>
						<tr>
							<th>@lang('translate.id')</th>
							<th>@lang('translate.name')</th>
							<th>@lang('translate.total_deposit')</th>
							<th>@lang('translate.total_withdraw')</th>
						</tr>
					</thead>
					<tbody>
						@foreach($toptendepositlists as $key=>$toptendeposit)	
						@if($toptendeposit->totaldeposit > 0 || $toptendeposit->totalwithdraw > 0)
						<tr>
							<td>{{ $key+1 }}</td>
							<td>{{ $toptendeposit->name }}</td>
							<td>@if($toptendeposit->totaldeposit > 0) {{ $toptendeposit->totaldeposit }} @else 0 @endif</td>
							<td>@if($toptendeposit->totalwithdraw > 0) {{ $toptendeposit->totalwithdraw }} @else 0 @endif</td>
						</tr>		
						@endif
						@endforeach
					</tbody>
				</table>
			</div>
		</div>
	</div>
	<div class="row">
		<div class="col-sm-12 col-md-6">
			<div class=" bg-dark rounded-3 p-3 borderbx mb-4">
				<div class="managementtitle mb-4">
					<h4>Top 10 Depositor</h4>
				</div>
				<table class="table table-dark table-striped mb-0 text-center table-hover">
					<thead>
						<tr>
							<th>@lang('translate.id')</th>
							<th>@lang('translate.name')</th>
							<th>@lang('translate.email')</th>
							<th>@lang('translate.total_deposit')</th>
							<th>Marketing Name</th>
						</tr>
					</thead>
					<tbody>
						@foreach($toptenuserdepositlists as $key=>$toptendeposit)							
						<tr>