@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">LAP /</span>LAP Enquiry Detail</h4>
      </div>
      <div class="Col float-right"><button class="btn btn-outline-primary" type="button"><i class="bx bxs-download"></i>
          Download</button></div>
    </div>
    <form action="{{ route('superadmin.lapviewdocumentsubmit') }}" enctype="multipart/form-data" method="POST">
      <input type="hidden" name="lap_id" value="{{$details->id}}">
      @csrf

      <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>Loan Type</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>Property Type</td>
                  <td>{{ $details->property_type }}</td>
                </tr>
                <tr>
                  <td>Construction Status</td>
                  <td>{{ $details->construction_status }}</td>
                </tr>
                <tr>
                  <td>Working Status</td>
                  <td>{{ $details->you_are }}</td>
                </tr>

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

                  <th>Title</th>
                  <th>Details</th>
                </tr>
              </thead>
              <tbody class="table-border-bottom-0">
                @if($details->you_are=="Salaried")
                <tr>
                  <td>6 Months Salary Slip</td>
                  <td>File :
                    @php($count=1)
                    @foreach($salary_slip_6_months as $key => $dc )
                    <a href="{{asset('public/uploads/laps/'. $dc->document)}}" target="_blank"> doc {{ $count }} </a> |
                    @php($count++)
                    @endforeach
                    @if(count($salary_slip_6_months) <1) <input class="form-control" name="salary_slip_6_months[]"
                      type="file" id="salary_slip_6_months" multiple="">
                      @endif

                  </td>
                </tr>
                <tr>
                  <td>6 Months bank Statement</td>
                  <td>File :
                    @php($count=1)
                    @foreach($bank_statement_6_months as $key => $dc )
                    <a href="{{asset('public/uploads/laps/'. $dc->document)}}" target="_blank"> doc {{ $count }} </a> |
                    @php($count++)
                    @endforeach

                    @if(count($bank_statement_6_months) <1) <input class="form-control" name="bank_statement_6_months[]"
                      type="file" id="bank_statement_6_months" multiple="">
                      @endif
                  </td>

                </tr>
                <tr>
                  <td>Upload Form 16</td>
                  <td>File :
                    @if(!empty($upload_form_16))
                    <a href="{{asset('public/uploads/laps/'. $upload_form_16->document)}}" target="_blank">
                      {{ $upload_form_16->document }} </a>
                    @endif
                    @if(empty($upload_form_16))
                    <input class="form-control" name="upload_form_16" type="file" id="upload_form_16">
                    @endif
                  </td>
                </tr>
                <tr>
                  <td>last 3 ITR</td>
                  <td>File :
                    @php($count=1)
                    @foreach($upload_last_3_itr as $key => $dc )
                    <a href="{{asset('public/uploads/laps/'. $dc->document)}}" target="_blank"> doc {{ $count }} </a> |
                    @php($count++)
                    @endforeach

                    @if(count($upload_last_3_itr) <1) <input class="form-control" name="upload_last_3_itr[]" type="file"
                      id="upload_last_3_itr" multiple="">
                      @endif
                  </td>
                </tr>
                @elseif($details->you_are=="Self Employed")
                <tr>
                  <td>Last 1 yr bank statement</td>
                  <td>File :
                    @php($count=1)
                    @foreach($last_1_year_bank_statement as $key => $dc )
                    <a href="{{asset('public/uploads/laps/'. $dc->document)}}" target="_blank"> doc {{ $count }} </a> |
                    @php($count++)
                    @endforeach

                    @if(count($last_1_year_bank_statement) <1) <input class="form-control"
                      name="last_1_year_bank_statement[]" type="file" id="last_1_year_bank_statement" multiple="">
                      @endif
                  </td>
                </tr>
                <tr>
                  <td>GSTR1/3B</td>
                  <td>File :
                    @php($count=1)
                    @foreach($upload_gstr_1_3_b as $key => $dc )
                    <a href="{{asset('public/uploads/laps/'. $dc->document)}}" target="_blank"> doc {{ $count }} </a> |
                    @php($count++)
                    @endforeach
                    @if(count($upload_gstr_1_3_b) <1) <input class="form-control" name="upload_gstr_1_3_b[]" type="file"
                      id="upload_gstr_1_3_b" multiple="">
                      @endif
                  </td>
                </tr>
                <tr>
                  <td>2 yrs Financial</td>
                  <td>File :
                    @php($count=1)
                    @foreach($upload_2_yrs_financial as $key => $dc )
                    <a href="{{asset('public/uploads/laps/'. $dc->document)}}" target="_blank"> doc {{ $count }} </a> |
                    @php($count++)
                    @endforeach
                    @if(count($upload_2_yrs_financial) <1) <input class="form-control" name="upload_2_yrs_financial[]"
                      type="file" id="upload_2_yrs_financial" multiple="">
                      @endif
                  </td>
                </tr>
                <tr>
                  <td>Profit/loss statement</td>
                  <td>File :
                    @php($count=1)
                    @foreach($upload_profit_loss_statement as $key => $dc )
                    <a href="{{asset('public/uploads/laps/'. $dc->document)}}" target="_blank"> doc {{ $count }} </a> |
                    @php($count++)
                    @endforeach
                    @if(count($upload_profit_loss_statement) <1) <input class="form-control"
                      name="upload_profit_loss_statement[]" type="file" id="upload_profit_loss_statement" multiple="">
                      @endif
                  </td>
                </tr>
                <tr>
                  <td>Form 16/ITR</td>
                  <td>File :
                    @php($count=1)
                    @foreach($upload_form_16_itr as $key => $dc )
                    <a href="{{asset('public/uploads/laps/'. $dc->document)}}" target="_blank"> doc {{ $count }} </a> |
                    @php($count++)
                    @endforeach
                    @if(count($upload_form_16_itr) <1) <input class="form-control" name="upload_form_16_itr[]"
                      type="file" id="upload_form_16_itr" multiple="">
                      @endif
                  </td>
                </tr>
                <tr>
                  <td>Company Type</td>
                  <td>{{ $details->company_type }}</td>
                </tr>
                @endif
              </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>

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

          @if($details->you_are=="Self Employed")

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

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

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

                </tr>
                <tr>
                  <td>Director's 2 Contact No.</td>
                  <td>{{ $details->director_contact_no_2 }}</td>
                </tr>
                <tr>
                  <td>Director's 3 Name</td>
                  <td>{{ $details->director_name_3 }}</td>
                </tr>
                <tr>
                  <td>Director's 3 Email Id</td>
                  <td>{{ $details->director_email_3 }}</td>

                </tr>
                <tr>
                  <td>Director's 3 Contact No.</td>
                  <td>{{ $details->director_contact_no_3 }}</td>
                </tr>
                <tr>
                  <td>Director's 4 Name</td>
                  <td>{{ $details->director_name_4 }}</td>
                </tr>
                <tr>
                  <td>Director's 4 Email Id</td>
                  <td>{{ $details->director_email_4 }}</td>

                </tr>
                <tr>
                  <td>Director's 4 Contact No.</td>
                  <td>{{ $details->director_contact_no_4 }}</td>
                </tr>

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

                  <th>Title</th>
                  <th>Details</th>
                </tr>
              </thead>
              <tbody class="table-border-bottom-0">
                @if($details->you_are=="Salaried")
                <tr>
                  <td>Aadhar Card Front</td>

                  <td>File : @if(!empty($aadhar_card_front))<a
                      href="{{asset('public/uploads/laps/'. $aadhar_card_front->document)}}" target="_blank">
                      {{ $aadhar_card_front->document }} </a>
                    @else
                    <input name="aadhar_card_front" class="form-control" type="file" id="formFile">

                    @endif</td>
                </tr>
                {{-- <tr>
                        <td>Aadhar Card Back</td>
						<td>File : <a href="{{asset('public/uploads/laps/'. $aadhar_card_back->document)}}" target="_blank">
                {{ $aadhar_card_back->document }} </a> </td>
                </tr> --}}
                <tr>
                  <td>PAN Card</td>
                  <td>File : @if(!empty($pan_card_front))<a
                      href="{{asset('public/uploads/laps/'. $pan_card_front->document)}}" target="_blank">
                      {{ $pan_card_front->document }} </a> @else
                    <input name="pan_card_front" class="form-control" type="file" id="formFile">

                    @endif </td>
                </tr>
                <tr>
                  <td>Address Proof</td>
                  <td>File : @if(!empty($address_proof))<a
                      href="{{asset('public/uploads/laps/'. $address_proof->document)}}" target="_blank">
                      {{ $address_proof->document }} </a> @else
                    <input name="address_proof" class="form-control" type="file" id="formFile">

                    @endif </td>
                </tr>
                <tr>
                  <td>Photos</td>
                  <td>File :
                    @php($count=1)
                    @foreach($upload_3_photos as $key => $dc )
                    <a href="{{asset('public/uploads/laps/'. $dc->document)}}" target="_blank"> Photo {{ $count }} </a>
                    |
                    @php($count++)
                    @endforeach

                    @if(count($upload_3_photos) < 1) <input class="form-control" name="upload_3_photos[]" type="file"
                      id="formFile" multiple="">
                      @endif
                  </td>
                </tr>
                @elseif($details->you_are=="Self Employed")
                <tr>
                  <td>Aadhar Card Front</td>
                  <td>File : @if(!empty($aadhar_card_front_s)) <a
                      href="{{asset('public/uploads/laps/'. $aadhar_card_front_s->document)}}" target="_blank">
                      {{ $aadhar_card_front_s->document }}
                    </a> @else
                    <input name="aadhar_card_front_s" class="form-control" type="file" id="formFile">
                    @endif
                  </td>
                </tr>
                {{-- <tr>
                        <td>Aadhar Card Back</td>
						<td>File : <a href="{{asset('public/uploads/laps/'. $aadhar_card_back_s->document)}}" target="_blank">
                {{ $aadhar_card_back_s->document }} </a> </td>
                </tr> --}}
                <tr>
                  <td>PAN Card</td>
                  <td>File : @if(!empty($pan_card_front_s))<a
                      href="{{asset('public/uploads/laps/'. $pan_card_front_s->document)}}" target="_blank">
                      {{ $pan_card_front_s->document }} </a> @else
                    <input name="pan_card_front_s" class="form-control" type="file" id="formFile">
                    @endif </td>
                </tr>
                <tr>
                  <td>Address Proof</td>
                  <td>File : @if(!empty($address_proof_s))<a
                      href="{{asset('public/uploads/laps/'. $address_proof_s->document)}}" target="_blank">
                      {{ $address_proof_s->document }} </a> @else
                    <input name="address_proof_s" class="form-control" type="file" id="formFile">
                    @endif </td>
                </tr>
                @endif

                <tr>
                <td>PAN Card</td>
                <td>File : @if(isset($pan_card->document))
                  <a href="{{asset('public/uploads/laps/'. $pan_card->document)}}" target="_blank">
                  <img src="{{asset('public/uploads/laps/'. $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/laps/'. $aadhar_card->document)}}" target="_blank">
                  <img src="{{asset('public/uploads/laps/'. $aadhar_card->document)}}" width="50"> </a> @endif</td>
              </tr>
              <tr>
                <td>Bank Statement</td>
                <td>File : @if(isset($bank_statement->document))
                  <a href="{{asset('public/uploads/laps/'. $bank_statement->document)}}" target="_blank">
                    <img src="{{asset('public/uploads/laps/'. $bank_statement->document)}}" width="50"></a> @endif</td>
              </tr>
              </tbody>
            </table>
          </div>
          <h5 class="green">Property Project Deatils</h5>
          <div class="table-responsive text-nowrap mb-3 ">
            <table class="table table-bordered">
              <thead>
                <th style="display:none">Property Project Details : </th>
                <tr>

                  <th>Title</th>
                  <th>Details</th>
                </tr>
              </thead>
              <tbody class="table-border-bottom-0">
                <tr>
                  <td>Builder/Buyer Agreement</td>
                  <td>File :
                    @php($count=1)
                    @foreach($agreement as $key => $dc )
                    <a href="{{asset('public/uploads/laps/'. $dc->document)}}" target="_blank"> Doc {{ $count }} </a> |
                    @php($count++)
                    @endforeach

                    @if(count($agreement) < 1) <input class="form-control" name="agreement[]" type="file" id="formFile"
                      multiple="">
                      @endif
                  </td>
                </tr>
                <tr>
                  <td>Allotment Letter</td>
                  <td>File :
                    @if($allotment_letter)
                    <a href="{{asset('public/uploads/laps/'. $allotment_letter->document)}}" target="_blank">
                      {{ $allotment_letter->document }} </a>
                    @else
                    <input class="form-control" name="allotment_letter" type="file" id="formFile" multiple="">

                    @endif

                  </td>
                </tr>
                <tr>
                  <td>Reciept of Purchase</td>
                  <td>File :
                    @if($reciept_purchase)
                    <a href="{{asset('public/uploads/laps/'. $reciept_purchase->document)}}" target="_blank">
                      {{ $reciept_purchase->document }} </a>
                    @else
                    <input class="form-control" name="reciept_purchase" type="file" id="formFile">
                    @endif

                  </td>
                </tr>
                <tr>
                  <td>No Obligation letter</td>
                  <td>File :
                    @if($obligation_letter)
                    <a href="{{asset('public/uploads/laps/'. $obligation_letter->document)}}" target="_blank">
                      {{ $obligation_letter->document }} </a>
                    @else
                    <input class="form-control" name="obligation_letter" type="file" id="formFile">
                    @endif
                  </td>
                </tr>
                <tr>
                  <td>Letter from Enrollment</td>
                  <td>File :
                    @if($letter_from_enrollment)
                    <a href="{{asset('public/uploads/laps/'. $letter_from_enrollment->document)}}" target="_blank">
                      {{ $letter_from_enrollment->document }} </a>
                    @else
                    <input class="form-control" name="letter_from_enrollment" type="file" id="formFile">
                    @endif
                  </td>
                </tr>
                <tr>
                  <td>Post Closure Letter</td>
                  <td>File :
                    @if($post_closure_letter)
                    <a href="{{asset('public/uploads/laps/'. $post_closure_letter->document)}}" target="_blank">
                      {{ $post_closure_letter->document }} </a>
                    @else
                    <input class="form-control" name="post_closure_letter" type="file" id="formFile">
                    @endif
                  </td>
                </tr>
                <tr>
                  <td>Power of Attorney</td>
                  <td>File :
                    @if($power_of_attorney)
                    <a href="{{asset('public/uploads/laps/'. $power_of_attorney->document)}}" target="_blank">
                      {{ $power_of_attorney->document }} </a>
                    @else
                    <input class="form-control" name="power_of_attorney" type="file" id="formFile">
                    @endif
                  </td>
                </tr>
                <tr>

                </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>

                <tr>
                  <td>Witness 3 Name</td>
                  <td>{{ $details->guarantor_name_3 }} </td>
                </tr>
                <tr>
                  <td>Witness 3 Email Id</td>
                  <td>{{ $details->guarantor_email_3 }}</td>
                </tr>
                <tr>
                  <td>Witness 3 Contact No.</td>
                  <td>{{ $details->guarantor_contact_no_3 }}</td>
                </tr>
              </tbody>

            </table>
          </div>

        </div>

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

      <div class="content-backdrop fade"></div>
      <button type="submit" class="btn btn-primary">Submit</button>
    </form>
  </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, "lap-enquiry-detail.csv");
  });
</script>
@endsection