@extends('backend.layouts.app')

@section('content')

<div class="p-3">
    <div class="row">

          <div class="col-lg-3 col-6">
            <div class="small-box bg-secondary">
              <div class="inner">
                <h3>{{ count(App\Models\Location::select('province')->distinct()->get()) }}</h3>
                <p>Province</p>
              </div>
              <div class="icon">
                <i class="ion ion-person-add"></i>
              </div>
            </div>
          </div>

          <div class="col-lg-3 col-6">
            <div class="small-box bg-secondary">
              <div class="inner">
                <h3>{{ count(App\Models\Location::select('municipality')->distinct()->get()) }}</h3>
                <p>Municipality</p>
              </div>
              <div class="icon">
                <i class="ion ion-person-add"></i>
              </div>
            </div>
          </div>

          <div class="col-lg-3 col-6">
            <div class="small-box bg-secondary">
              <div class="inner">
                <h3>{{ count(App\Models\Location::select('city')->distinct()->get()) }}</h3>
                <p>City</p>
              </div>
              <div class="icon">
                <i class="ion ion-person-add"></i>
              </div>
            </div>
          </div>

          <div class="col-lg-3 col-6">
            <div class="small-box bg-secondary">
              <div class="inner">
                <h3>{{ count(App\Models\Location::select('barangay')->distinct()->get()) }}</h3>
                <p>Barangay</p>
              </div>
              <div class="icon">
                <i class="ion ion-person-add"></i>
              </div>
            </div>
          </div>

    </div>
      <div class="card">
        <div class="card-body">
          <table id="location" class="table table-striped" style="width:100%">
            <thead>
              <tr>
                <th>Province</th>
                <th>Distict</th>
                <th>Municipality</th>
                <th>City</th>
                <th>Barangay</th>
                <th>Shipping Fee Up to 119kg</th>
                <th>Shipping Fee Up 120 to 199</th>
                <th>Shipping 200kg to 299kg</th>
                <th>Free w/ min purchase of (Php 15,000)</th>
                <th>Below min Purchase of (Php 15,000)</th>
                <th>Free w/min purchase of (Php 25,000)</th>
                <th>Below min purchase of (Php 25,000)</th>
                <th>Action</th>
              </tr>
            </thead>
            
            <tbody>
              @foreach($loc as $locations)
                <tr>
                    <td>{{$locations->province ? $locations->province : 'N/A'}}</td>
                    <td>{{$locations->district ? $locations->district : 'N/A'}}</td>
                    <td>{{$locations->municipality ? $locations->municipality : 'N/A'}}</td>
                    <td>{{$locations->city ? $locations->city : 'N/A'}}</td>
                    <td>{{$locations->barangay}}</td>
                    <td>{{$locations->small ? $locations->small : 'N/A'}}</td>
                    <td>{{$locations->medium ? $locations->medium : 'N/A'}}</td>
                    <td>{{$locations->large ? $locations->large : 'N/A'}}</td>
                    <td>{{$locations->freepurch ? $locations->freepurch : 'N/A'}}</td>
                    <td>{{$locations->belowpurch ? $locations->belowpurch : 'N/A' }}</td>
                    <td>{{$locations->freepurch1 ? $locations->freepurch1 : 'N/A'}}</td>
                    <td>{{$locations->belowpurch1 ? $locations->belowpurch1 : 'N/A'}}</td>
                    <td>
                      <button type="button" class="btn btn-danger" data-bs-toggle="modal" data-bs-target="#exampleModal{{$locations->id}}">Delete</button>
                    </td>
                </tr>

                <div class="modal fade" id="exampleModal{{$locations->id}}" tabindex="-1" aria-labelledby="exampleModalLabel" aria-hidden="true">
                  <div class="modal-dialog">
                    <div class="modal-content">
                      <div class="modal-header">
                        <h5 class="modal-title" id="exampleModalLabel">Confirmation</h5>
                        <button type="button" class="btn-close" data-bs-dismiss="modal" aria-label="Close"></button>
                      </div>
                      <div class="modal-body">
                        Are you sure you want to delete this?
                      </div>
                      <div class="modal-footer">
                        <button type="button" class="btn btn-secondary" data-bs-dismiss="modal">Close</button>
                        <!-- Add your delete action button here -->
                        <form method="POST" action="{{ url('admin/location/' . $locations->id) }}">@csrf @method('DELETE')
                        <button type="submit" class="btn btn-danger">Delete</button>
                        </form>
                      </div>
                    </div>
                  </div>
                </div>  
                @endforeach
            </tbody>
          </table>
        </div>
      </div>
</div>





@endsection