@extends('layouts.adminmaster')
@section('styles')
<link rel="stylesheet" href="{{asset('css/admincss/select2.min.css')}}">


@endsection

@php
$sitesetting = App\Models\sitesetting::first();
use App\Models\routereports;
$routeReports = new routeReports();
@endphp
@section('admincontent')
<div class="breadcrumbs-area"></div>

@if ($message = Session::get('success'))
<div class="alert alert-success alert-dismissible">
  {{ $message }}
  <button type="button" class="close" data-dismiss="alert" aria-label="Close">
    <span aria-hidden="true">&times;</span>
  </button>
</div>
@elseif($message = Session::get('failure'))
<div class="alert alert-dismissible alert-danger">
  {{ $message }}
  <button type="button" class="close" data-dismiss="alert" aria-label="Close">
    <span aria-hidden="true">&times;</span>
  </button>
</div>
@endif
<!-- Breadcubs Area End Here -->
<!-- Student Table Area Start Here -->
<div class="card height-auto">
  <div class="card-body">
    <div class="heading-layout1">
      <div class="item-title">
        <h3>Route Details</h3>
      </div>
      <div class="pull-right">
        <a href="#detailtable" class="btn btn-primary btn-lg">View Details</a>
      </div>
    </div>
    @can('routereports-list')
        <div class="row">
        	<div class="col-lg-4">
        		<table class="table display table-bordered table-striped">
        			<thead>
        				<tr>
        					<th><b>Title</b></th>
        					<th><b>Description</b></th>
        				</tr>
        			</thead>
        			<tbody>
        				<tr>
        					<td>Name</td>
        					<td>{{$route->name}}</td>
        				</tr>
        				<tr>
        					<td>Start Point</td>
        					<td>{{$route->start_point}}</td>
        				</tr>
                <tr>
                  <td>End Point</td>
                  <td>{{$route->end_point}}</td>
                </tr>
                <tr>
                  <td>Distance</td>
                  <td>{{$route->distance}}</td>
                </tr>
        			</tbody>
        		</table>
        	</div>
        	<div class="col-lg-4">
        		@php
	            	$tickets = $routeReports->routereportsdaily($route->id);
	            	$ticketmonthly = $routeReports->routereportsmonthly($route->id);
	            	$routereportsyearly = $routeReports->routereportsyearly($route->id);
	            @endphp
        		<table class="table display table-bordered table-striped">
        			<thead>
        				<tr>
        					<th><b>Title</b></th>
        					<th><b>Description</b></th>
        				</tr>
        			</thead>
        			<tbody>
        				<tr>
        					<td>Total ticket today</td>
        					<td class="text-right">{{$tickets['tickettoday']}}</td>
        				</tr>
        				<tr>
        					<td>Total collection today</td>
        					<td class="text-right">Rs. {{$tickets['totalcollection']}}</td>
        				</tr>
        				<tr>
        					<td>Total ticket this month</td>
        					<td class="text-right">{{$ticketmonthly['ticket']}}</td>
        				</tr>
        				<tr>
        					<td>Total collection this month</td>
        					<td class="text-right">Rs. {{$ticketmonthly['totalcollection']}}</td>
        				</tr>
        				<tr>
        					<td>Total ticket this year</td>
        					<td class="text-right">{{$routereportsyearly['ticket']}}</td>
        				</tr>
        				<tr>
        					<td>Total collection this year</td>
        					<td class="text-right">Rs. {{$routereportsyearly['totalcollection']}}</td>
        				</tr>
        			</tbody>
        		</table>
        	</div>
        	<div class="col-lg-4">
        		<table class="table display table-bordered table-striped">
        			<thead>
        				<tr>
        					<th><b>Months</b></th>
        					<th><b>Total Collection</b></th>
        				</tr>
        			</thead>
        			<tbody>
        				@foreach($months as $key => $mnth)
	        				@php
	        					$monthlycollectionroute = $routeReports->routereportsmonthlybyname($route->id,$key);
	        				@endphp
        					<tr>
        						<td>{{$mnth}}</td>
        						<td class="text-right">Rs. {{$monthlycollectionroute['totalcollection']}}</td>
        					</tr>
        				@endforeach
        			</tbody>
        		</table>
        	</div>
        </div>
        <div class="row" style="margin-top: 15px;">
          <div class="col-lg-12 table-responsive" id="detailtable" >
              <table class="table data-table">
                  <thead>
                    <tr>
                      <th>S no.</th>
                      <th>Bill Type</th>
                      <th>Vehicle Type</th>
                      <th>Vehicle No</th>
                      <th>Amount</th>
                      <th>route</th>
                      <th>Date</th>
                      <th>Time</th>
                    </tr>
                  </thead>
                  <tbody>
                    @if(count($savedbills)> 0)
                      @foreach ($savedbills as $key => $per)
                      <tr>
                        <td>{{ ++$key }}</td> 
                        <td>{{$per->description}}</td>
                        <td>
                          </td>
                        <td></td>
                        <td>Rs {{ $per->amount}}</td>
                        <td>{{ $per->users->name}}</td>
                        <td>