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

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

  <div class="container-xxl flex-grow-1 container-p-y">
    <!-- Horizontal -->
    <div class="row mb-3">
      <div class="Col-md-4">
        <h4 class="fw-bold py-3 mb-4"><span class="text-muted fw-light">Personal Loan /</span>Personal Loan Enquiry
          Detail</h4>
      </div>
      <div class="Col float-right"><button class="btn btn-outline-primary" type="button"><i
            class="fa-sharp fa-solid fa-download"></i> Download</button></div>
    </div>

    <div class="row mb-5">
      <div class="card ">
        <div class="table-responsive text-nowrap mb-3 mt-3">
          <table class="table table-bordered">
            <thead>
              <tr>
                <th>Title</th>
                <th>Details</th>
              </tr>
            </thead>
            <tbody class="table-border-bottom-0">
              <tr>
                <td>Enquiry Code</td>
                <td>{{ $details->enquiry_code }}</td>
              </tr>
              <tr>
                <td>Type of Loan</td>
                <td>{{ $details->type_of_loan }}</td>
              </tr>
              <tr>
                <td>Name</td>
                <td>{{ $details->full_name }}</td>
              </tr>
              <tr>
                <td>Email Id</td>
                <td>{{ $details->email }}</td>
              </tr>
              <tr>
                <td>Contact No.</td>
                <td>{{ $details->contact_no }}</td>
              </tr>
              <tr>
                <td>Address</td>
                @php
                $city = DB::table('master_city')->where('city_id', $details->city)->get('city_name');
                $city_name = json_decode(json_encode($city),true);

                $state = DB::table('master_state')->where('state_id', $details->state)->get('state_name');
                $state_name = json_decode(json_encode($state),true);
                @endphp
                <td>{{ @$details->address }}, {{ @$city_name[0]['city_name'] }} {{ @$state_name[0]['state_name'] }}</td>
              </tr>
              <tr>
                <td>Loan Amount Required</td>
                <td>Rs {{ $details->loan_amount }}</td>
              </tr>
              <tr>
                <td>Photos</td>
                <td>File :
                  @php($count=1)
                  @foreach($photo as $key => $dc )
                  <a href="{{asset('public/uploads/pls/'. $dc->document)}}" target="_blank"> Photo {{ $count }} </a> |
                  @php($count++)
                  @endforeach
                </td>
              </tr>
            </tbody>
          </table>
        </div>

        <h5 class="green">KYC Details</h5>
        <div class="table-responsive text-nowrap mb-3 ">
          <table class="table table-bordered">
            <thead>
              <th style="display:none">KYC Details : </th>
              <tr>

                <th>Title</th>
                <th>Details</th>
              </tr>
            </thead>
            <tbody class="table-border-bottom-0">
              <tr>
                <td>Aadhar Card Front</td>
                <td>File :
                  @if($aadhar_card_front)
                  <a href="{{asset('public/uploads/pls/'. $aadhar_card_front->document)}}" target="_blank">
                    {{ $aadhar_card_front->document }} </a>
                  @endif
                </td>
              </tr>
              {{-- <tr>
                        <td>Aadhar Card Back</td>
						<td>File : 
						@if($aadhar_card_back)
							<a href="{{asset('public/uploads/pls/'. $aadhar_card_back->document)}}" target="_blank">
              {{ $aadhar_card_back->document }} </a>
              @endif
              </td>
              </tr> --}}
              <tr>
                <td>PAN Card Front</td>
                <td>File :
                  @if($pan_card_front)
                  <a href="{{asset('public/uploads/pls/'. $pan_card_front->document)}}" target="_blank">
                    {{ $pan_card_front->document }} </a>
                  @endif
                </td>
              </tr>
              <tr>
                <td> Address Proof</td>
                <td>File :
                  @if($address_proof)
                  <a href="{{asset('public/uploads/pls/'. $address_proof->document)}}" target="_blank">
                    {{ $address_proof->document }} </a>
                  @endif
                </td>
              </tr>

            </tbody>
          </table>
        </div>

        <h5 class="green">Documents Required</h5>
        <div class="table-responsive text-nowrap mb-3 ">
          <table class="table table-bordered">
            <thead>
              <th style="display:none">Documents Required : </th>
              <tr>
                <th>Title</th>
                <th>Details</th>
              </tr>
            </thead>
            <tbody class="table-border-bottom-0">
             
              <tr>
                <td>PAN Card</td>
                <td>File : @if(isset($pan_card->document))
                  <a href="{{asset('public/uploads/pls/'. $pan_card->document)}}" target="_blank">
                  <img src="{{asset('public/uploads/pls/'. $pan_card->document)}}" width="50"> </a> @endif</td>
              </tr>
              <tr>
                <td>Aadhar Card</td>
                <td>File : @if(isset($aadhar_card->document))
                  <a href="{{asset('public/uploads/pls/'. $aadhar_card->document)}}" target="_blank">
                  <img src="{{asset('public/uploads/pls/'. $aadhar_card->document)}}" width="50"> </a> @endif</td>
              </tr>
              <tr>
                <td>Bank Statement</td>
                <td>File : @if(isset($bank_statement_new->document))
                  <a href="{{asset('public/uploads/pls/'. $bank_statement_new->document)}}" target="_blank">
                    <img src="{{asset('public/uploads/pls/'. $bank_statement_new->document)}}" width="50"></a> @endif</td>
              </tr>
              <!-- <tr>
                <td>Bank Statement</td>
                <td>File :
                  @php($count=1)
                  @foreach($bank_statement as $key => $dc )
                  <a href="{{asset('public/uploads/pls/'. $dc->document)}}" target="_blank"> Doc {{ $count }} </a> |
                  @php($count++)
                  @endforeach
                </td>
              </tr> -->
              <tr>
                <td> 3 months Salary Slip</td>
                <td>File :
                  @php($count=1)
                  @foreach($salery_slip as $key => $dc )
                  <a href="{{asset('public/uploads/pls/'. $dc->document)}}" target="_blank"> Doc {{ $count }} </a> |
                  @php($count++)
                  @endforeach
                </td>
              </tr>
              <tr>
                <td> Form 16/IT Returns</td>
                <td>File :
                  @php($count=1)
                  @foreach($form_16_itr as $key => $dc )
                  <a href="{{asset('public/uploads/pls/'. $dc->document)}}" target="_blank"> Doc {{ $count }} </a> |
                  @php($count++)
                  @endforeach
                </td>
              </tr>
              <tr>
                <td> ID Proof</td>
                <td>File :
                  @if($id_proof)
                  <a href="{{asset('public/uploads/pls/'. $id_proof->document)}}" target="_blank">
                    {{ $id_proof->document }} </a>
                  @endif
                </td>
              </tr>

            </tbody>
          </table>
        </div>

        <h5 class="green">Company Details</h5>
        <div class="table-responsive text-nowrap mb-3 ">
          <table class="table table-bordered">
            <thead>
              <th style="display:none">Company Details : </th>
              <tr>

                <th>Title</th>
                <th>Details</th>
              </tr>
            </thead>
            <tbody class="table-border-bottom-0">
              <tr>
                <td>Company Name</td>
                <td>{{ $details->company_name }}</td>
              </tr>
              <tr>
                <td>Company Email Id</td>
                <td>{{ $details->company_email }}</td>
              </tr>
              <tr>
                <td>Company contact No.</td>
                <td>{{ $details->company_contact }}</td>
              </tr>
              <tr>
                <td>Company Website</td>
                <td>{{ $details->company_website }}</td>
              </tr>
              <tr>
                <td>Time period of company existence and individual's vintage in that company</td>
                <td>{{ $details->time_period_of_company }}</td>
              </tr>
            </tbody>
          </table>
        </div>

        <h5 class="green">Witness Details</h5>
        <div class="table-responsive text-nowrap mb-3 ">
          <table class="table table-bordered">
            <thead>
              <th style="display:none">Witness Details : </th>
              <tr>

                <th>Title</th>
                <th>Details</th>
              </tr>
            </thead>
            <tbody class="table-border-bottom-0">
              <tr>
                <td>Witness 1 Name</td>
                <td>{{ $details->guarantor_name_1 }} </td>
              </tr>
              <tr>
                <td>Witness 1 Email Id</td>
                <td>{{ $details->guarantor_email_1 }}</td>
              </tr>
              <tr>
                <td>Witness 1 Contact No.</td>
                <td>{{ $details->guarantor_contact_no_1 }}</td>
              </tr>

              <tr>
                <td>Witness 2 Name</td>
                <td>{{ $details->guarantor_name_2 }} </td>
              </tr>
              <tr>
                <td>Witness 2 Email Id</td>
                <td>{{ $details->guarantor_email_2 }}</td>
              </tr>
              <tr>
                <td>Witness 2 Contact No.</td>
                <td>{{ $details->guarantor_contact_no_2 }}</td>
              </tr>

            </tbody>
          </table>
        </div>

      </div>

    </div>
    <!-- / Content -->

    <div class="content-backdrop fade"></div>
  </div>
  <!-- Content wrapper -->
</div>
<script>
  var APP_URL = {
    !!json_encode(url('/')) !!
  }

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

  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.querySelector("button").addEventListener("click", function() {
    var html = document.querySelector("table").outerHTML;
    export_table_to_csv(html, "personal-loan-enquiry-detail.csv");
  });
</script>
@endsection