@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">Business Loan /</span> Business 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>Description</td>
                <td>{{ $details->description }}</td>
              </tr>

              <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>Loan Tenure</td>
                <td>Rs {{ $details->loan_tenure }}</td>
              </tr>
              <tr>
                <td>DOB</td>
                <td> {{ $details->dob }}</td>
              </tr>
              <tr>
                <td>Annual Income</td>
                <td>Rs {{ $details->annual_income }}</td>
              </tr>
            </tbody>
          </table>
        </div>

        <h5 class="green">Personal Details</h5>
        <div class="table-responsive text-nowrap mb-3 ">
          <table class="table table-bordered">
            <thead>
             
              <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/bls/'. $pan_card->document)}}" target="_blank">
                  <img src="{{asset('public/uploads/bls/'. $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/bls/'. $aadhar_card->document)}}" target="_blank">
                  <img src="{{asset('public/uploads/bls/'. $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/bls/'. $bank_statement_new->document)}}" target="_blank">
                    <img src="{{asset('public/uploads/bls/'. $bank_statement_new->document)}}" width="50"></a> @endif</td>
              </tr>
            </tbody>
          </table>
        </div>

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

                <th>Title</th>
                <th>Details</th>
              </tr>
            </thead>
            <tbody class="table-border-bottom-0">
              <tr>
                <td>Company ITR 3yrs</td>
                <td>File :
                  @php($count=1)
                  @foreach($company_itr_3_year as $key => $dc )
                  <a href="{{asset('public/uploads/bls/'. $dc->document)}}" target="_blank"> Doc {{ $count }} </a> |
                  @php($count++)
                  @endforeach
                </td>
              </tr>
              <tr>
                <td>2 Yrs Bank Statement</td>
                <td>File :
                  @php($count=1)
                  @foreach($bank_statement as $key => $dc )
                  <a href="{{asset('public/uploads/bls/'. $dc->document)}}" target="_blank"> Doc {{ $count }} </a> |
                  @php($count++)
                  @endforeach
                </td>
              </tr>
              <tr>
                <td>Last 6 months GSTR3B</td>
                <td>File :
                  @php($count=1)
                  @foreach($last_6_months_gstr3b as $key => $dc )
                  <a href="{{asset('public/uploads/bls/'. $dc->document)}}" target="_blank"> Doc {{ $count }} </a> |
                  @php($count++)
                  @endforeach
                </td>
              </tr>
              <tr>
                <td>Company P&L Sheet</td>
                <td>File :
                  @if($company_pl_sheet)
                  @php($count=1)
                  @foreach($company_pl_sheet as $key => $dc )
                  <a href="{{asset('public/uploads/bls/'. $dc->document)}}" target="_blank"> Doc {{ $count }} </a> |
                  @php($count++)
                  @endforeach
                  @endif
                </td>
              </tr>
              <tr>
                <td>Share Holding Proof</td>
                <td>File :
                  @if($share_holding_proof)
                  <a href="{{asset('public/uploads/bls/'. $share_holding_proof->document)}}" target="_blank">
                    {{ $share_holding_proof->document }} </a>
                  @endif
                </td>
              </tr>
              <tr>
                <td>MoA</td>
                <td>File :
                  @if($moa)
                  <a href="{{asset('public/uploads/bls/'. $moa->document)}}" target="_blank"> {{ $moa->document }} </a>
                  @endif
                </td>
              </tr>
              <tr>
                <td>AoA</td>
                <td>File :
                  @if($aoa)
                  <a href="{{asset('public/uploads/bls/'. $aoa->document)}}" target="_blank"> {{ $aoa->document }} </a>
                  @endif
                </td>
              </tr>
              <tr>
                <td>Corporation Certificate</td>
                <td>File :
                  @if($corporation_certificate)
                  <a href="{{asset('public/uploads/bls/'. $corporation_certificate->document)}}" target="_blank">
                    {{ $corporation_certificate->document }} </a>
                  @endif
                </td>
              </tr>
              <tr>
                <td>Approximate Turnover</td>
                <td>Rs {{ $details->approximate_turnover }}</td>
              </tr>
            </tbody>
          </table>
        </div>

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

                <th>Title</th>
                <th>Details</th>
              </tr>
            </thead>
            <tbody class="table-border-bottom-0">
              <tr>
                <td>Director's Name</td>
                <td>{{ $details->director_name_1 }} </td>
              </tr>
              <tr>
                <td>Director's Email Id</td>
                <td>{{ $details->director_email_1 }}</td>
              </tr>
              <tr>
                <td>Director's Contact No.</td>
                <td>{{ $details->director_contact_no_1 }}</td>
              </tr>

              <tr>
                <td>Director's Adhaar Card Front</td>
                <td>File :
                  @if($director_aadhar_card_front_1)
                  <a href="{{asset('public/uploads/bls/'. $director_aadhar_card_front_1->document)}}" target="_blank">
                    {{ $director_aadhar_card_front_1->document }} </a>
                  @endif
                </td>
              </tr>
              {{-- <tr>
                        <td>Director's  Adhaar Card Back</td>
						<td>File :
							@if($director_aadhar_card_back_1) 						
							<a href="{{asset('public/uploads/bls/'. $director_aadhar_card_back_1->document)}}" target="_blank">
              {{ $director_aadhar_card_back_1->document }} </a>
              @endif
              </td>
              </tr> --}}
              <tr>
                <td>Director's PAN Card</td>
                <td>File :
                  @if($director_pan_card_1)
                  <a href="{{asset('public/uploads/bls/'. $director_pan_card_1->document)}}" target="_blank">
                    {{ $director_pan_card_1->document }} </a>
                  @endif
                </td>
              </tr>

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

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

                <th>Title</th>
                <th>Details</th>
              </tr>
            </thead>
            <tbody class="table-border-bottom-0">

              <tr>
                <td>Director's Name</td>
                <td>{{ $details->director_name_2 }} </td>
              </tr>
              <tr>
                <td>Director's Email Id</td>
                <td>{{ $details->director_email_2 }}</td>
              </tr>
              <tr>
                <td>Director's Contact No.</td>
                <td>{{ $details->director_contact_no_2 }}</td>
              </tr>

              <tr>
                <td>Director's Adhaar Card Front</td>
                <td>File :
                  @if($director_aadhar_card_front_2)
                  <a href="{{asset('public/uploads/bls/'. $director_aadhar_card_front_2->document)}}" target="_blank">
                    {{ $director_aadhar_card_front_2->document }} </a>
                  @endif
                </td>
              </tr>
              {{-- <tr>
                        <td>Director's  Adhaar Card Back</td>
						<td>File : 
							@if($director_aadhar_card_back_2)
							<a href="{{asset('public/uploads/bls/'. $director_aadhar_card_back_2->document)}}" target="_blank">
              {{ $director_aadhar_card_back_2->document }} </a>
              @endif
              </td>
              </tr> --}}
              <tr>
                <td>Director's PAN Card</td>
                <td>File :
                  @if($director_pan_card_2)
                  <a href="{{asset('public/uploads/bls/'. $director_pan_card_2->document)}}" target="_blank">
                    {{ $director_pan_card_2->document }} </a>
                  @endif
                </td>
              </tr>
            </tbody>
          </table>
        </div>

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

                <th>Title</th>
                <th>Details</th>
              </tr>
            </thead>
            <tbody class="table-border-bottom-0">
              <tr>
                <td>Director's Name</td>
                <td>{{ $details->director_name_3 }} </td>
              </tr>
              <tr>
                <td>Director's Email Id</td>
                <td>{{ $details->director_email_3 }}</td>
              </tr>
              <tr>
                <td>Director's Contact No.</td>
                <td>{{ $details->director_contact_no_3 }}</td>
              </tr>

              <tr>
                <td>Director's Adhaar Card Front</td>
                <td>File :
                  @if($director_aadhar_card_front_3)
                  <a href="{{asset('public/uploads/bls/'. $director_aadhar_card_front_3->document)}}" target="_blank">
                    {{ $director_aadhar_card_front_3->document }} </a>
                  @endif
                </td>
              </tr>
              {{-- <tr>
                        <td>Director's Adhaar Card Back</td>
						<td>File : 
							@if($director_aadhar_card_back_3)
							<a href="{{asset('public/uploads/bls/'. $director_aadhar_card_back_3->document)}}" target="_blank">
              {{ $director_aadhar_card_back_3->document }} </a>
              @endif
              </td>
              </tr> --}}
              <tr>
                <td>Director's PAN Card</td>
                <td>File :
                  @if($director_pan_card_3)
                  <a href="{{asset('public/uploads/bls/'. $director_pan_card_3->document)}}" target="_blank">
                    {{ $director_pan_card_3->document }} </a>
                  @endif
                </td>
              </tr>

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

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

                <th>Title</th>
                <th>Details</th>
              </tr>
            </thead>
            <tbody class="table-border-bottom-0">
              <tr>
                <td>Director's Name</td>
                <td>{{ $details->director_name_4 }} </td>
              </tr>
              <tr>
                <td>Director's Email Id</td>
                <td>{{ $details->director_email_4 }}</td>
              </tr>
              <tr>
                <td>Director's Contact No.</td>
                <td>{{ $details->director_contact_no_4 }}</td>
              </tr>

              <tr>
                <td>Director's Adhaar Card Front</td>
                <td>File :
                  @if($director_aadhar_card_front_4)
                  <a href="{{asset('public/uploads/bls/'. $director_aadhar_card_front_4->document)}}" target="_blank">
                    {{ $director_aadhar_card_front_4->document }} </a>
                  @endif
                </td>
              </tr>
              {{-- <tr>
                        <td>Director's Adhaar Card Back</td>
						<td>File : 
							@if($director_aadhar_card_back_4)
							<a href="{{asset('public/uploads/bls/'. $director_aadhar_card_back_4->document)}}" target="_blank">
              {{ $director_aadhar_card_back_4->document }} </a>
              @endif
              </td>
              </tr> --}}
              <tr>
                <td>Director's PAN Card</td>
                <td>File :
                  @if($director_pan_card_4)
                  <a href="{{asset('public/uploads/bls/'. $director_pan_card_4->document)}}" target="_blank">
                    {{ $director_pan_card_4->document }} </a>
                  @endif
                </td>
              </tr>
            </tbody>
          </table>
        </div>

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

                <th>Title</th>
                <th>Details</th>
              </tr>
            </thead>
            <tbody class="table-border-bottom-0">
              <tr>
                <td>Director's Name</td>
                <td>{{ $details->director_name_5 }} </td>
              </tr>
              <tr>
                <td>Director's Email Id</td>
                <td>{{ $details->director_email_5 }}</td>
              </tr>
              <tr>
                <td>Director's Contact No.</td>
                <td>{{ $details->director_contact_no_5 }}</td>
              </tr>

              <tr>
                <td>Director's Adhaar Card Front</td>
                <td>File :
                  @if($director_aadhar_card_front_5)
                  <a href="{{asset('public/uploads/bls/'. $director_aadhar_card_front_5->document)}}" target="_blank">
                    {{ $director_aadhar_card_front_5->document }} </a>
                  @endif
                </td>
              </tr>
              {{-- <tr>
                        <td>Director's Adhaar Card Back</td>
						<td>File : 
							@if($director_aadhar_card_back_5)
							<a href="{{asset('public/uploads/bls/'. $director_aadhar_card_back_5->document)}}" target="_blank">
              {{ $director_aadhar_card_back_5->document }} </a>
              @endif
              </td>
              </tr> --}}
              <tr>
                <td>Director's PAN Card</td>
                <td>File :
                  @if($director_pan_card_5)
                  <a href="{{asset('public/uploads/bls/'. $director_pan_card_5->document)}}" target="_blank">
                    {{ $director_pan_card_5->document }} </a>
                  @endif
                </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, "business-loan-enquiry-detail.csv");
  });
</script>
@endsection