@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>Vendor 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">
        <div class="row">
            <div class="col-12">
                <div class="card">
                    <!--<div class="card-header">-->
                    <!--    <h3 class="card-title">Vendor Report</h3>-->
                    <!--</div>-->
                    <!-- /.card-header -->
                    <div class="card-body">
                        <form >
                            <div class="row ">
                                <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-2 form-group">
                                    <label for="exampleInputEmail1">Vendor/Supplier</label>
                                    <select name="supplier_id" class="form-control" required>
                                        <option value="" hidden></option>
                                        @foreach($suppliers as $supplier)
                                        <option value="{{$supplier->s_id}}">{{$supplier->supplier_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($paid || $purchase)
                        <div class="row">
                            <div class="col-md-6">
                                 <h5 class="sub-header">Paid Amount</h5>
                                <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">Site</th>
                                        <th scope="col">Amount</th></th>
                                        <th scope="col">Transaction Method</th>
                                      </tr>
                                    </thead>
                                    <tbody>
                                      @php($i=1)
                                      @foreach($paid as $pay)
                                      <tr>
                                        <th scope="row">{{$i++}}</th>
                                        <td>{{$pay->date}}</td>
                                        <td>{{$pay->supplier_name}}</td>
                                        <td>{{$pay->site_name}}</td>
                                        <td>{{$pay->amount}}</td>
                                        <td>{{$pay->method}}</td>
                                      </tr>
                                      @endforeach
                                       <tr>
                                          <td colspan="4"><b>Total :</b></td>
                                          <td><b>{{$total_paid}}</b></td>
                                          <td></td>
                                          <td hidden></td>
                                          <td hidden></td>
                                          <td hidden></td>
                                          <td hidden></td>
                                      </tr>
                                    </tfoot>
                                </table>
                            </div>
                            <div class="col-md-6">
                                <h5 class="sub-header">Material Purchase</h5>
                                <table id="example4" 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">Site</th>
                                        <th scope="col">Bill No</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($purchase as $purch)
                                      <tr>
                                        <th scope="row">{{$i++}}</th>
                                        <td>{{$purch->date}}</td>
                                        <td>{{$purch->supplier_name}}</td>
                                        <td>{{$purch->site_name}}</td>
                                        <td>{{$purch->bill_no}}</td>
                                        <td>{{$purch->total_amount}}</td>
                                        <td>{{$purch->method}}</td>
                                        <td>{{$purch->remarks}}</td>
                                      </tr>
                                      @endforeach
                                      <tr>
                                          
                                          <td ></td>
                                          <td ><b>Total :</b></td>
                                          <td ></td>
                                          <td ></td>
                                          <td ></td>
                                          <td><b>{{$total_purchase}}</b></td>
                                          <td></td>
                                          <td ></td>
                                      </tr>
                                    </tfoot>
                                </table>
                            </div>
                            <div class="col-md-3 col-sm-6 col-12">
                                <div class="info-box bg-danger shadow">
                                  <span class="info-box-icon bg-danger"><i class="fas fa-inr"></i></span>
                    
                                  <div class="info-box-content">
                                    <span class="info-box-text">Balance Pending</span>
                                    <span class="info-box-number">{{$pending}}</span>
                                  </div>
                                  <!-- /.info-box-content -->
                                </div>
                                <!-- /.info-box -->
                              </div>
                              <!-- /.col -->
                        </div>
                        @endif
                    </div>
                    <!-- /.card-body -->
                </div>
                <!-- /.card -->
            </div>
            <!-- /.col -->
        </div>
    </div>
    <!-- /.row -->
    </div>
    <!-- /.container-fluid -->
</section>

@endsection