@extends('layouts.admin', ['title' => 'گزارش دنت کلاب'])

@section('css')
@endsection

@section('content')

<div class="row">
	<div class="col-md-6">
		<h3>گزارشات کلاب

			<a href="{{ route('admin.customers-club.index') }}" class="btn btn-link">بازگشت</a>

		</h3>
	</div>
	<div class="col-md-6 text-left">

		<a href="{{ route('admin.customers-club.usersreport.sendmessage') }}?{{ $queryString }}"
			class="btn btn-default">ارسال پیام</a>

		<a href="{{ route('admin.customers-club.usersreport') }}?excel=true&{{ $queryString }}" class="btn btn-default">
			خروجی
			(کامل)</a>

		<a href="{{ route('admin.customers-club.usersreport.export') }}?{{ $queryString }}" class="btn btn-default">
			خروجی
			(شماره همراه)</a>
	</div>
</div>

<div class="row">
	<div class="col-md-12">
		<form action="{{ route('admin.customers-club.usersreport') }}" method="GET">
			<div class="row">
				<div class="form-group col-md-3">
					<label for="dateFrom">از تاریخ</label>
					<input type="text" name="dateFrom" id="dateFrom" class="form-control" value="{{ $dateFrom }}" />
				</div>
				<div class="form-group col-md-3">
					<label for="dateTo">تا</label>
					<input type="text" name="dateTo" id="dateTo" class="form-control" value="{{ $dateTo }}" />
				</div>
				<div class="form-group col-md-3">
					<label for="dateStatus">وضعیت فیلتر</label>
					<select name="dateStatus" id="dateStatus" class="form-control">
						<option {{ $dateStatus=='none' ? 'selected' : '' }} value="none">غیرفعال</option>
						<option {{ $dateStatus=='register' ? 'selected' : '' }} value="register"> عضویت</option>
						<option {{ $dateStatus=='orders' ? 'selected' : '' }} value="orders"> سفارشات</option>
						<option {{ $dateStatus=='installment' ? 'selected' : '' }} value="installment"> پرداخت قسط
						</option>

					</select>
				</div>
			</div>

			<div class="row">‌
				<div class="form-group col-md-3">
					<label for="pointFrom">از امتیاز</label>
					<input type="text" name="pointFrom" id="pointFrom" class="form-control" value="{{ $pointFrom }}" />
				</div>
				<div class="form-group col-md-3">
					<label for="pointTo">تا</label>
					<input type="text" name="pointTo" id="pointTo" class="form-control" value="{{ $pointTo }}" />
				</div>
				<div class="form-group col-md-3">
					<label for="pointStatus">وضعیت فیلتر</label>
					<select name="pointStatus" id="pointStatus" class="form-control">
						<option {{ $pointStatus=='none' ? 'selected' : '' }} value="none">غیرفعال</option>
						<option {{ $pointStatus=='on' ? 'selected' : '' }} value="on">فعال</option>
					</select>
				</div>
			</div>

			<div class="row">‌
				<div class="form-group col-md-3">
					<label for="sumFrom">از مجموع خرید</label>
					<input type="text" name="sumFrom" id="sumFrom" class="form-control" value="{{ $sumFrom }}" />
				</div>
				<div class="form-group col-md-3">
					<label for="sumTo">تا</label>
					<input type="text" name="sumTo" id="sumTo" class="form-control" value="{{ $sumTo }}" />
				</div>
				<div class="form-group col-md-3">
					<label for="sumStatus">وضعیت فیلتر</label>
					<select name="sumStatus" id="sumStatus" class="form-control">
						<option {{ $sumStatus=='none' ? 'selected' : '' }} value="none">غیرفعال</option>
						<option {{ $sumStatus=='on' ? 'selected' : '' }} value="on">فعال</option>
					</select>
				</div>
			</div>

			<div class="row">‌
				<div class="form-group col-md-3">
					<label for="countFrom">از تعداد سفارش</label>
					<input type="text" name="countFrom" id="countFrom" class="form-control" value="{{ $countFrom }}" />
				</div>
				<div class="form-group col-md-3">
					<label for="countTo">تا</label>
					<input type="text" name="countTo" id="countTo" class="form-control" value="{{ $countTo }}" />
				</div>
				<div class="form-group col-md-3">
					<label for="countStatus">وضعیت فیلتر</label>
					<select name="countStatus" id="countStatus" class="form-control">
						<option {{ $countStatus=='none' ? 'selected' : '' }} value="none">غیرفعال</option>
						<option {{ $countStatus=='on' ? 'selected' : '' }} value="on">فعال</option>
					</select>
				</div>
			</div>

			<div class="row">‌
				<div class="form-group col-md-3">
					<label for="province">استان</label>
					<select name="province" id="province" class="form-control">
						<option {{ $province_val=='none' ? 'selected' : '' }} value="none">همه</option>
						@foreach ($provinces as $province)
						<option {{ $province_val==$province->id ? 'selected' : '' }} value="{{ $province->id }}">
							{{ $province->title }}</option>
						@endforeach
					</select>
				</div>
				<div class="form-group col-md-3">
					<label for="city">شهر</label>
					<select name="city" id="city" class="form-control">
						<option {{ $city_val=='none' ? 'selected' : '' }} value="none">همه</option>
						@foreach ($cities as $city)
						<option {{ $city_val==$city->id ? 'selected' : '' }} class="none" value="{{ $city->id }}"
							data-province="{{ $city->province_id }}">
							{{ $city->title }}</option>
						@endforeach
					</select>
				</div>
				<div class="form-group col-md-3">
					<label for="district">محله (تهران)</label>
					<select name="district" id="district" class="form-control">
						<option {{ $district_val=='none' ? 'selected' : '' }} value="none">همه</option>
						@foreach ($districts as $district)
						<option {{ $district_val==$district->id ? 'selected' : '' }} value="{{ $district->id }}">
							{{ $district->title }}</option>
						@endforeach
					</select>
				</div>
			</div>
			<div class="row">

				<div class="form-group col-md-3">
					<label for="gender">جنسیت</label>
					<select name="gender" id="gender" class="form-control">
						<option {{ $gender=='none' ? 'selected' : '' }} value="none">همه</option>
						<option {{ $gender=='male' ? 'selected' : '' }} value="male">مرد</option>
						<option {{ $gender=='female' ? 'selected' : '' }} value="female">زن</option>
					</select>
				</div>
				<div class="form-group col-md-3">
					<label for="role">نقش</label>
					<select name="role" id="role" class="form-control">
						<option {{ $role_val=='none' ? 'selected' : '' }} value="none">همه</option>
						@foreach ($roles as $role)
						<option {{ $role_val==$role->name ? 'selected' : '' }} value="{{ $role->name }}">
							{{ $role->title }}
						</option>
						@endforeach
					</select>
				</div>
				<div class="form-group col-md-3">
					<label for="permission">سطح دسترسی</label>
					<select name="permission" id="permission" class="form-control">
						<option {{ $permission_val=='none' ? 'selected' : '' }} value="none">همه</option>
						@foreach ($permissions as $permission)
						<option {{ $permission_val==$permission->name ? 'selected' : '' }}
							value="{{ $permission->name }}">
							{{ $permission->title }}</option>
						@endforeach
					</select>
				</div>
				<div class="form-group col-md-3">
					<label for="installment">وضعیت پرداخت اقساطی</label>
					<select name="installment" id="installment" class="form-control">
						<option {{ $installment=='none' ? 'selected' : '' }} value="none">همه</option>
						<option {{ $installment=='on' ? 'selected' : '' }} value="on">فعال</option>
						<option {{ $installment=='off' ? 'selected' : '' }} value="off">غیر فعال</option>
					</select>
				</div>

			</div>

			<div class="row">‌
				<div class="form-group col-md-3">
					<label for="totalInstallmentFrom">از اعتبار اقساطی</label>
					<input type="text" name="totalInstallmentFrom" id="totalInstallmentFrom" class="form-control"
						value="{{ $totalInstallmentFrom }}" />
				</div>
				<div class="form-group col-md-3">
					<label for="totalInstallmentTo">تا</label>
					<input type="text" name="totalInstallmentTo" id="totalInstallmentTo" class="form-control"
						value="{{ $totalInstallmentTo }}" />
				</div>
				<div class="form-group col-md-3">
					<label for="totalInstallmentStatus">وضعیت فیلتر</label>
					<select name="totalInstallmentStatus" id="totalInstallmentStatus" class="form-control">
						<option {{ $totalInstallmentStatus=='none' ? 'selected' : '' }} value="none">غیرفعال
						</option>
						<option {{ $totalInstallmentStatus=='on' ? 'selected' : '' }} value="on">فعال</option>
					</select>
				</div>
			</div>

			<div class="row">‌
				<div class="form-group col-md-3">
					<label for="modInstallmentFrom">از باقی‌مانده اعتبار اقساطی</label>
					<input type="text" name="modInstallmentFrom" id="modInstallmentFrom" class="form-control"
						value="{{ $modInstallmentFrom }}" />
				</div>
				<div class="form-group col-md-3">
					<label for="modInstallmentTo">تا</label>
					<input type="text" name="modInstallmentTo" id="modInstallmentTo" class="form-control"
						value="{{ $modInstallmentTo }}" />
				</div>
				<div class="form-group col-md-3">
					<label for="modInstallmentStatus">وضعیت فیلتر</label>
					<select name="modInstallmentStatus" id="modInstallmentStatus" class="form-control">
						<option {{ $modInstallmentStatus=='none' ? 'selected' : '' }} value="none">غیرفعال
						</option>
						<option {{ $modInstallmentStatus=='on' ? 'selected' : '' }} value="on">فعال</option>
					</select>
				</div>
			</div>

			<div class="row">‌
				<div class="form-group col-md-12">
					<button type="submit" class="btn btn-primary">تایید</button>
				</div>
			</div>
		</form>

	</div>
</div>

<div class="row">
	<div class="col-md-12">
		<table class="table">
			<tr>
				<th>ردیف</th>
				<th>نام و نام خانوادگی</th>
				<th>شماره همراه</th>
				<th>ایمیل</th>
				<th>امتیاز</th>
				<th>حجم خرید (تومان)</th>
				<th>تعداد سفارشات</th>
			</tr>
			@foreach ($data as $item)
			<tr>
				<td>{{ $loop->iteration }}</td>
				<td>
					<a href="/admin/profile/{{ $item->id }}" class="btn btn-link">
						{{ $item->full_name }}
					</a>
				</td>
				<td>{{ $item->mobile }}</td>
				<td>{{ $item->email }}</td>
				<td>{{ $item->club_points }}</td>
				<td>{{ number_format($item->active_carts_sum_total_amount, 0, '', ',') }}</td>
				<td>{{ $item->active_carts_count }}</td>
			</tr>
			@endforeach
		</table>

		<div>
			{!! $data->links() !!}
		</div>
	</div>
</div>

@stop

@section('javascript')
<script type="text/javascript">
	$(document).ready(function(){
			$('#province').change(function(){
				var province = $(this).val();

				$('#city option').removeClass('none');
				$('#city option[data-province!="' + province + '"]').addClass('none');
				$('#city option[value="none"]').removeClass('none');
				
			});
		});
</script>
@endsection