@extends('layouts.admin')

@section('content')
<!-- Content Header (Page header) -->
<div class="content-wrapper" style="min-height: 2080.12px;">
    <!-- Content Header (Page header) -->
    <section class="content-header">
      <div class="container-fluid">
        <div class="row mb-2">
          <div class="col-sm-6">
            <h1>Customer Report</h1>
          </div>
          <!-- <div class="col-sm-6">
            <ol class="breadcrumb float-sm-right">
              <li class="breadcrumb-item"><a href="#">Home</a></li>
              <li class="breadcrumb-item active">Sales</li>
            </ol>
          </div> -->
        </div>
      </div><!-- /.container-fluid -->
    </section>
   <section class="content">
    <div class="container-fluid">
        @if(session('success'))
            <div class="alert alert-success d-flex align-items-center" role="alert">
              <i class="fas fa-check-circle"></i>
                <svg class="bi flex-shrink-0 me-2" width="24" height="24" role="img" aria-label="Success:"><use xlink:href="#check-circle-fill"/></svg>
                <div>
                {{ session('success') }}
                </div>
            </div>
        @endif
        <div class="row">
            <div class="col-12">
                <div class="card">
                    <div class="card-header">
                        <h3 class="card-title">Customer Report</h3>
                    </div>
                    <!-- /.card-header -->
                    <div class="card-body">
                        <form >
                            <div class="row py-4">
                                <div class="col-md-3 form-group">
                                    <label for="exampleInputEmail1">From</label>
                                    <input type="date" name="from" class="form-control" >
                                </div>         
                                <div class="col-md-3 form-group">
                                    <label for="exampleInputEmail1">To</label>
                                    <input type="date" name="to" class="form-control" >
                                </div>  
                                <div class="col-md-3 form-group">
                                    <label for="exampleInputEmail1">Customer Name</label>
                                    <select name="customer_id" class="form-control" required>
                                        <option value="" hidden></option>
                                        @foreach($customers as $customer)
                                        <option value="{{$customer->c_id}}">{{$customer->customer_name}}</option>
                                        @endforeach
                                    </select>                  
                                </div>         
                                <div class="col-3 py-2">                         
                                    <br>
                                    <button type="submit" name="go" class="btn btn-primary">Search</button>
                                </div>
                            </div>
                        </form>
                        @if($received)
                        <table id="example1" class="table table-bordered table-striped">
                            <thead>
                              <tr>
                                <th scope="col">Sl No</th>
                                <th scope="col">Date</th>
                                <th scope="col">Name</th>
                                <th scope="col">Amount</th></th>
                                <th scope="col">Transaction Method</th>
                                <th scope="col">Remarks</th>
                              </tr>
                            </thead>
                            <tbody>
                              @php($i=1)
                              @foreach($received as $receive)
                              <tr>
                                <th scope="row">{{$i++}}</th>
                                <td>{{$receive->date}}</td>
                                <td>{{$receive->customer_name}}</td>
                                <td>{{$receive->amount}}</td>
                                <td>{{$receive->method}}</td>
                                <td>{{$receive->remarks}}</td>
                              </tr>
                              @endforeach
                                <tr>
                                    <th scope="row">{{$i++}}</th>
                                    <td></td>
                                    <th scope="row"> Estimate Amount</th>
                                    <td >{{$estimate}}</td>
                                    <td></td>
                                    <td></td>
                                </tr>
                                <tr>
                                    <th scope="row">{{$i++}}</th>
                                    <td></td>
                                    <th scope="row"> Opening Balance</th>
                                    <td >{{$opBalance}}</td>
                                     <td></td>
                                    <td></td>
                                </tr>
                                <tr>
                                    <th scope="row">{{$i++}}</th>
                                    <td></td>
                                    <th scope="row"> Amount Paid</th>
                                    <td>{{$total_received_amount}}</td>
                                     <td></td>
                                    <td></td>
                                </tr>
                                <tr>
                                    <th scope="row">{{$i++}}</th>
                                    <td></td>
                                    <th scope="row"> Balance Amount</th>
                                    <td>{{$balance}}</td>
                                     <td></td>
                                    <td></td>
                                </tr>
                            </tfoot>
                        </table>
                        @endif
                    </div>
                    <!-- /.card-body -->
                </div>
                <!-- /.card -->
            </div>
            <!-- /.col -->
        </div>
    </div>
    <!-- /.row -->
    </div>
    <!-- /.container-fluid -->
</section>

@endsection