@extends('admin.layout.app')
@section('content')

<style>
  .d-none{
    display:none;
  }
</style>
<style type="text/css">
    #export_excel{
        background-color: #607D8B;
        color: #fff;
        padding: 4px 8px;
        border-radius: 5px;
        font-size: 14px;
        font-weight: 500;
        cursor: pointer;
        margin-bottom: 17px;
    }
</style>
  <div class="content-wrapper">
    <div class="content-header">
      <div class="container-fluid">
        <div class="row mb-2">
          <div class="col-sm-6">
            <h1 class="m-0">Payment Report </h1> </div>
          <div class="col-sm-6">
            <ol class="breadcrumb float-sm-right">
              <li class="breadcrumb-item"><a href="{{url('admin/dashboard')}}"><i class="fas fa-home"></i></a>
                                </li>
              <li class="breadcrumb-item active">Payment Report</li>

            </ol>
          </div>
        </div>
      </div>
    </div>

  
 <section class="content">
    <div class="container-fluid">  
      <form action="{{route('paymentReport')}}" >
        <div class="row">
          <div class="col-3" style="margin-bottom: 20px; ">
            <label>Select Owner</label>
            <select name="owner_id" id="owner_id" class="form-control" onchange="getRestaurent()" required>
              <option value="">All</option>
              @foreach($owner as $owners)
              <option value="{{$owners->reference_owner_id }}" {{@$_GET['owner_id']==$owners->reference_owner_id?'selected':''}}>{{$owners->name}}</option>
              @endforeach
            </select>
          </div>       

          <div class="col-3" style="margin-bottom: 20px;">
            <label> Select Restaurant</label>
            <select name="restaurant_id" id="rest_id" class="form-control" required>              
               @if(!empty(@$_GET['restaurant_id']))
               @php
                $restaurent=\DB::table('owners')->select('b.id','b.reference_market_id','b.name')->leftjoin('business as b','b.owner_id','=','owners.id')->where('owners.reference_owner_id',@$_GET['owner_id'])->get();
               @endphp
               @foreach($restaurent as $busin)
               <option value="{{@$busin->reference_market_id}}" {{$busin->reference_market_id==$_GET['restaurant_id']?'selected':''}}>{{@$busin->name}}</option>
               @endforeach
               
               @endif                
            </select>
          </div>         
          <div class="col-2" style="margin-bottom: 20px;">
            <label>Start Date</label>
            <input type="date" class="form-control" name="start_date" value="{{@$_GET['start_date']}}" required>
          </div>
          <div class="col-2" style="margin-bottom: 20px;">
            <label>End Date</label>
            <input type="date" class="form-control" name="end_date" value="{{@$_GET['end_date']}}" required>
          </div>
          <div class="col-2" style="margin-bottom: 20px;">
            <label></label>
            <button type="submit" class="btn btn-primary mt-4" id="search">Search</button>
            <a href="{{route('paymentReport')}}" class="btn btn-primary mt-4" id="reset">Reset</a>
          </div>
        </div>
      </form>
      <div class="col-12">
        <div class="card">
       
          <div class="row">   
        
            <div class="card-body" id="order">
              <span type="button" id="export_excel">Download Excel</span>
              <table id="example3" class="table table-bordered table-striped">
                <thead>
                  <tr>
                    <th>S No.</th>
                    <th>Restaurant</th>
                    <th>Payment Method</th>
                    <th>Amount</th>
                  </tr>
                </thead>
                <tbody>
                @if(@$_GET['owner_id'] && @$_GET['restaurant_id'])
               
                  @foreach($business as $key=>$busines)
                    <tr>
                      <td>{{$key+1}}</td>
                      <td>{{@$busines->business_name}}</td>
                      <td>{{@$busines->pay_method}}</td>
                      <td>${{@$busines->total_amount}}</td>
                    </tr> 
                  @endforeach
                </tbody>
                @endif
              </table>
            </div>
           
           

          </div>

        </div>
      </div>
    </div>
  </section>
</div>
    <script src="{{asset('admin/plugins/jquery/jquery.min.js')}}"></script>
<script>
$(document).ready(function(){
 
  $("#search").click(function(){
    $("#order").addClass('d-none');
    $('#reservation').removeClass('d-none');
  });
  $("#reset").click(function(){
    $("#order").removeClass('d-none');
    $('#reservation').addClass('d-none');
  });
});

function SelectReportType()
{
    $('#order_type').html('');
    var reportType=$('#report_type_value').val(); 
    if(reportType=='order')
    {
      $('#order_type').append(`<option value="max_number">Order By Count</option>
      <option value="max_amount">Order By Amount</option>`);
    }

    if(reportType=='table_reservation')
    {
      $('#order_type').append(`<option value="max_book">Order By Count</option>
      <option value="max_cover">Order By Cover/People</option>`);
    }

}

function getRestaurent(){
  var owner_id = $("#owner_id").val();
    if(owner_id ==0){
      alert("Please Select Owner First");
      return false;
    }
    jQuery.ajax({
      url:"{{route('getRestaurentByOwner')}}",
      method:"POST",
      data:{"_token":"{{csrf_token()}}",'owner_id':owner_id},
      success:function(getResponse){
        $('#rest_id').empty();
        getResponse.forEach((row,index)=>{
          $('#rest_id').append(`<option value="${row.reference_market_id}">${row.name}</option>`);
        })
      }
    });
  };
</script>
<script type="text/javascript">
    $(document).ready(function () {
      $('#export_excel').click(function () {
        // Get the table and clone it to avoid modifying the original
        let table = document.getElementById('example3').cloneNode(true);
        // let excludeColumns = [3,7,8,9,10,11]; // Specify the column indices to exclude (0-based index)

        // Remove <tfoot> from the cloned table
        let tfoot = table.querySelector('tfoot');
        if (tfoot) {
          tfoot.remove();
        }

        // Remove unwanted columns from the table
        // for (let row of table.rows) {
        //   for (let i = excludeColumns.length - 1; i >= 0; i--) {
        //     // row.deleteCell(excludeColumns[i]); // Remove specified columns
        //     // console.log(excludeColumns[i]);
        //   }
        // }

        // Convert the modified table to a worksheet
        let workbook = XLSX.utils.table_to_book(table, { sheet: "Sheet1" });

        // Create an Excel file
        XLSX.writeFile(workbook, 'transactional_report.xlsx');
      });
    });

</script>

<!-- anuj -->
<script src="https://cdnjs.cloudflare.com/ajax/libs/xlsx/0.18.5/xlsx.full.min.js"></script>

@endsection