@extends('backend.admin-master')
@section('site-title')
    {{__('Dashboard')}}
@endsection
@section('content')


          <!-- Content wrapper -->
          <div class="content-wrapper">
            <!-- Content -->

            <div class="container-xxl flex-grow-1 container-p-y">
              <h4 class="fw-bold py-3 mb-4"><span class="text-muted fw-light">Insurance /</span> Health Insurance Enquiry list</h4>
              @if (session('success'))
                    <div class="alert alert-success">
                        {{ session('success') }}
                    </div>
                  @endif
              <nav class="navbar navbar-example navbar-expand-lg bg-light mb-3">
                <div class="container-fluid">
                  <a class="navbar-brand" href="javascript:void(0)">&nbsp;</a>
                  <button
                    class="navbar-toggler"
                    type="button"
                    data-bs-toggle="collapse"
                    data-bs-target="#navbar-ex-3"
                  >
                    <span class="navbar-toggler-icon"></span>
                  </button>

                  <div class="collapse navbar-collapse" id="navbar-ex-3">
                    <div class="navbar-nav me-auto">
                      <ul class="navbar-nav me-auto mb-2 mb-lg-0"> <li class="nav-item dropdown">
                      <a
                        class="nav-link dropdown-toggle"
                        href="javascript:void(0)"
                        id="navbarDropdown"
                        role="button"
                        data-bs-toggle="dropdown"
                      >
                       Posted By
                      </a>
                      <ul class="dropdown-menu" aria-labelledby="navbarDropdown">
                        <li onclick="posted_by(this);" title="dpuser"><a class="dropdown-item" href="javascript:void(0)">DP User</a></li>
                        <li onclick="posted_by(this);" title="dpbuddy"><a class="dropdown-item" href="javascript:void(0)">DP Buddy</a></li>
                        <!--<li onclick="posted_by(this);" title="dpsarthi"><a class="dropdown-item" href="javascript:void(0)">DP Sarthi</a></li>-->
                        {{-- <li>
                          <hr class="dropdown-divider" />
                        </li>
                        <li><a class="dropdown-item" href="javascript:void(0)">Something else here</a></li> --}}
                      </ul>
                    </li></ul>
                      <button type="button" class="btn" data-bs-toggle="modal" data-bs-target="#Modaldate">Date</button>
                    <button type="button" class="btn" data-bs-toggle="modal" data-bs-target="#basicModal">Custom Search</button>
                    </div>
                    <!--<form onsubmit="return false">-->
                      <button class="btn btn-outline-primary" id="csv" type="button"><i class="fa-sharp fa-solid fa-download"></i> Download</button>
                    <!--</form>-->
                    &nbsp;&nbsp;
                    <a
                      href="{{ url('superadmin/health_insurance_enquiry_list?refresh=refresh') }}"
                          class="btn btn-primary mr10"
                    >
						            Reset
					          </a>
                  </div>
                </div>
              </nav>


              <div class="modal fade" id="Modaldate" tabindex="-1" aria-hidden="true">
                <div class="modal-dialog" role="document">
                  <form action="{{ url('superadmin/health_insurance_enquiry_list') }}" method="GET">
                    <div class="modal-content">
                      <div class="modal-header">
                        <h5 class="modal-title" id="exampleModalLabel1">Enquiry Filter</h5>
                        <button
                          type="button"
                          class="btn-close"
                          data-bs-dismiss="modal"
                          aria-label="Close"
                        ></button>
                      </div>
                      <div class="modal-body">
                        <div class="row">
                          <div class="col mb-3">
                            <label for="nameBasic" class="form-label">Date</label>
                            <input type="date" id="nameBasic" class="form-control" placeholder="" name="date" value="{{ Session()->get('date') }}"/>
                          </div>
                        </div>
                      </div>
                      <div class="modal-footer">
                        <button type="button" class="btn btn-outline-secondary" data-bs-dismiss="modal">
                          Close
                        </button>
                        <button type="submit" class="btn btn-primary">Search</button>
                      </div>
                    </div>
                </form>
                </div>
              </div>


			    <!-- Horizontal -->
                  <div class="modal fade" id="basicModal" tabindex="-1" aria-hidden="true">
                    <div class="modal-dialog" role="document">
                      <form action="{{ url('superadmin/health_insurance_enquiry_list') }}" method="GET">
                        <div class="modal-content">
                          <div class="modal-header">
                            <h5 class="modal-title" id="exampleModalLabel1">Enquiry Filter</h5>
                            <button
                              type="button"
                              class="btn-close"
                              data-bs-dismiss="modal"
                              aria-label="Close"
                            ></button>
                          </div>
                          <div class="modal-body">
                            <div class="row">
                              <div class="col mb-3">
                                <label for="nameBasic" class="form-label">Product Title</label>
                                <input type="text" id="nameBasic" class="form-control" placeholder="" name="productname" value="{{ Session()->get('productname') }}"/>
                              </div>
                            </div>
                            <div class="row">
                              <div class="col mb-3">
                                <label for="nameBasic" class="form-label">Customer Name</label>
                                <input type="text" id="nameBasic" class="form-control" placeholder="" name="customername" value="{{ Session()->get('customername') }}"/>
                              </div>
                            </div>
                           <div class="row">
                              <div class="col mb-3">
                                <label for="nameBasic" class="form-label">Email Id</label>
                                <input type="text" id="nameBasic" class="form-control" placeholder="" name="emailid" value="{{ Session()->get('emailid') }}"/>
                              </div>
                            </div>
                          </div>
                          <div class="modal-footer">
                            <button type="button" class="btn btn-outline-secondary" data-bs-dismiss="modal">
                              Close
                            </button>
                            <button type="submit" class="btn btn-primary">Search</button>
                          </div>
                        </div>
                    </form>
                    </div>
                  </div>

              <div class="row mb-5">


             

				 <div class="card">
                <h5 class="card-header">Total Health Insurance Enquiry Details</h5>
                <div class="table-responsive text-nowrap">
                  <table class="table">
                    <thead>
                      <tr>
                        <th>Date</th>
                        <th>Product Title</th>
                        <th>Customer Name</th>
                         <th>DP Buddy/DP Sarthi</th>
						<th>Email Id</th>
						<!-- <th>Contact No.</th> -->

                        {{-- <th>message</th> --}}
                        <th>Posted By</th>
                        <!-- <th>Created At </th> -->
                        <th>Status  </th>
                        <th>Actions</th>
                      </tr>
                    </thead>
                    <tbody class="table-border-bottom-0">
                      <tr>
    @forelse($_details_pms as $_details)

    {{-- show manager name --}}
    @php
    $parent = DB::table('users')->where(['id' => $_details->parentid])->get(['name','last_name']);
    $manager = json_decode(json_encode($parent),true);
@endphp

                        <td>{{ \Carbon\Carbon::parse($_details->created_at)->isoFormat('DD MMM YYYY')}}</td>
                        <td><i class="fab fa-angular fa-lg text-danger me-3"></i> <strong>{{$_details->productname}}</strong></td>
                        <td>{{$_details->name}}</td>

                        @if ($manager)
                          <td>{{$manager[0]['name']}} {{$manager[0]['last_name']}}</td>
                        @else  
                          <td class="text-center">-</td>
                        @endif

            {{-- <td>{{$_details->usermanagername}}</td> --}}
						<td>{{$_details->emailid}}</td>
            <!-- <td>{{$_details->phone}}</td> -->
            <td>
                                                            </td>
						<!-- <td>{{$_details->created_at}}</td> -->
                        <td>
                                                                                                          <span class="badge bg-label-info me-1">Un Seen</span>                        </td>

                        <td>
                        @if($_details->enquirystatus=="completed1")
                          <span>-</span>
                          @else
                          <div class="dropdown">
                            <button type="button" class="btn p-0 dropdown-toggle hide-arrow" data-bs-toggle="dropdown">
                              <i class="bx bx-dots-vertical-rounded"></i>
                            </button>
                            <div class="dropdown-menu">
                              <a class="dropdown-item" href="{{url('superadmin/edit/health_insurance/enquiry' , $_details->id)}}"
                                ><i class="bx bx-edit-alt me-1"></i> Edit</a
                              >
                              <a class="dropdown-item" href="{{ url('superadmin/delete/health_insurance/enquiry',$_details->id) }}"
                                ><i class="bx bx-trash me-1"></i> Delete</a>

							                  {{-- <a class="dropdown-item" href="javascript:void(0);"
                                ><i class="bx bx-trash me-1"></i> Deactivate</a> --}}

                                @if($_details->status==1)
                                <a href="{{ url('superadmin/status/health_insurance/0',$_details->id) }}" class="dropdown-item"><i class="bx bx-trash me-1"></i>Deactivate
                                </a>
                                @elseif($_details->status==0)
                                <a href="{{ url('superadmin/status/health_insurance/1',$_details->id) }}" class="dropdown-item"><i class="bx bx-trash me-1"></i>Activate
                                </a>
                                @endif

                            </div>
                          </div>
                            @endif
                        </td>
                      </tr>
                      @empty
                      <tr><td colspan="7"><h4 class="text-center text-muted">No Records Found !</h4></td></tr>
                     @endforelse
                      <tr>
                    </tbody>
                  </table>
                </div>
              </div>
              {{ $_details_pms->links("pagination::bootstrap-4") }}
            </div>
            <!-- / Content -->
<script>
  var APP_URL = {!! json_encode(url('/')) !!}

  function posted_by(d)
  {
    var title = d.getAttribute("title");
    window.location.href= APP_URL+"/superadmin/health_insurance_enquiry_list?"+"posted_by="+title;
  }

     // download enquires

     function download_csv(csv, filename) {
    var csvFile;
    var downloadLink;

    // CSV FILE
    csvFile = new Blob([csv], {type: "text/csv"});

    // Download link
    downloadLink = document.createElement("a");

    // File name
    downloadLink.download = filename;

    // We have to create a link to the file
    downloadLink.href = window.URL.createObjectURL(csvFile);

    // Make sure that the link is not displayed
    downloadLink.style.display = "none";

    // Add the link to your DOM
    document.body.appendChild(downloadLink);

    // Lanzamos
    downloadLink.click();
}

function export_table_to_csv(html, filename) {
  var csv = [];
  var rows = document.querySelectorAll("table tr");

    for (var i = 0; i < rows.length; i++) {
    var row = [], cols = rows[i].querySelectorAll("td, th");

        for (var j = 0; j < cols.length; j++)
            row.push(cols[j].innerText);

    csv.push(row.join(","));
  }

    // Download CSV
    download_csv(csv.join("\n"), filename);
}

document.getElementById("csv").addEventListener("click", function () {
    var html = document.querySelector("table").outerHTML;
  export_table_to_csv(html, `health-insurance-enquiry-${new Date().toLocaleDateString('de-DE')}.csv`);
});

</script>
@endsection