@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">Home Loan /</span> Home 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>Property Type</td>
						<td>{{ $details->property_type }}</td>
                      </tr>
					  <tr>
                        <td>Construction Status</td>
						<td>{{ $details->construction_status }}</td>
                      </tr>
                      <tr>
                        <td>Annual Income</td>
						<td>{{ $details->annual_income }}</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/loans/'. $dc->document)}}" target="_blank"> doc {{ $count }} </a> |
							 @php($count++)
							@endforeach							
						</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/loans/'. $dc->document)}}" target="_blank"> doc {{ $count }} </a> |
							 @php($count++)
							@endforeach							
						</td>

                      </tr>
					  <tr>
                        <td>Upload Form 16</td>
						<td>File : @if(isset($upload_form_16->document))<a href="{{asset('public/uploads/loans/'. $upload_form_16->document)}}" target="_blank"> {{ $upload_form_16->document }} </a> @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/loans/'. $dc->document)}}" target="_blank"> doc {{ $count }} </a> |
							 @php($count++)
							@endforeach							
						</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/loans/'. $dc->document)}}" target="_blank"> doc {{ $count }} </a> |
							 @php($count++)
							@endforeach							
						</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/loans/'. $dc->document)}}" target="_blank"> doc {{ $count }} </a> |
							 @php($count++)
							@endforeach							
						</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/loans/'. $dc->document)}}" target="_blank"> doc {{ $count }} </a> |
							 @php($count++)
							@endforeach							
						</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/loans/'. $dc->document)}}" target="_blank"> doc {{ $count }} </a> |
							 @php($count++)
							@endforeach							
						</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/loans/'. $dc->document)}}" target="_blank"> doc {{ $count }} </a> |
							 @php($count++)
							@endforeach							
						</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(isset($aadhar_card_front->document))<a href="{{asset('public/uploads/loans/'. $aadhar_card_front->document)}}" target="_blank"> {{ $aadhar_card_front->document }} </a> @endif </td>
                      </tr>
                       {{-- <tr>
                        <td>Aadhar Card Back</td>
						<td>File : <a href="{{asset('public/uploads/loans/'. $aadhar_card_back->document)}}" target="_blank"> {{ $aadhar_card_back->document }} </a> </td>
                      </tr> --}}
					  <tr>
                        <td>PAN Card</td>
						<td>File : @if(isset($pan_card_front->document))<a href="{{asset('public/uploads/loans/'. $pan_card_front->document)}}" target="_blank"> {{ $pan_card_front->document }} </a> @endif</td>
                      </tr>
                      <tr>
                        <td>Address Proof</td>
						<td>File : @if(isset($address_proof->document))<a href="{{asset('public/uploads/loans/'. $address_proof->document)}}" target="_blank"> {{ $address_proof->document }} </a> @endif</td>
					  </tr>
					  <tr>
                        <td>Photos</td>
						<td>File :
							@php($count=1)
							@foreach($upload_3_photos as $key => $dc )							
							<a href="{{asset('public/uploads/loans/'. $dc->document)}}" target="_blank"> Photo {{ $count }} </a> |
							 @php($count++)
							@endforeach							
						</td>
					  </tr>
					@elseif($details->you_are=="Self Employed")
						<tr>
                        <td>Aadhar Card Front</td>
						<td>File : @if(isset($aadhar_card_front_s->document)) <a href="{{asset('public/uploads/loans/'. $aadhar_card_front_s->document)}}" target="_blank"> {{ $aadhar_card_front_s->document }} </a> @endif</td>
                      </tr>
                       {{-- <tr>
                        <td>Aadhar Card Back</td>
						<td>File : <a href="{{asset('public/uploads/loans/'. $aadhar_card_back_s->document)}}" target="_blank"> {{ $aadhar_card_back_s->document }} </a> </td>
                      </tr> --}}
					  <tr>
                        <td>PAN Card</td>
						<td>File :  @if(isset($aadhar_card_front_s->document)) <a href="{{asset('public/uploads/loans/'. $pan_card_front_s->document)}}" target="_blank"> {{ $pan_card_front_s->document }} </a> @endif</td>
                      </tr>
                      <tr>
                        <td>Address Proof</td>
						<td>File :  @if(isset($address_proof_s->document)) <a href="{{asset('public/uploads/loans/'. $address_proof_s->document)}}" target="_blank"> {{ $address_proof_s->document }} </a> @endif</td>
					  </tr>
					@endif
          <tr>
                <td>PAN Card</td>
                <td>File : @if(isset($pan_card->document))
                  <a href="{{asset('public/uploads/loans/'. $pan_card->document)}}" target="_blank">
                  <img src="{{asset('public/uploads/loans/'. $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/loans/'. $aadhar_card->document)}}" target="_blank">
                  <img src="{{asset('public/uploads/loans/'. $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/loans/'. $bank_statement->document)}}" target="_blank">
                    <img src="{{asset('public/uploads/loans/'. $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 Deatils : </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/loans/'. $dc->document)}}" target="_blank"> Doc {{ $count }} </a> |
							 @php($count++)
							@endforeach							
						</td>
                      </tr>
                       <tr>
                        <td>Allotment Letter</td>
						<td>File : 
							@if($allotment_letter)
							<a href="{{asset('public/uploads/loans/'. $allotment_letter->document)}}" target="_blank"> {{ $allotment_letter->document }} </a>
							@endif
							</td>
                      </tr>
					  <tr>
                        <td>Reciept of Purchase</td>
						<td>File : 
							@if($reciept_purchase)
							<a href="{{asset('public/uploads/loans/'. $reciept_purchase->document)}}" target="_blank"> {{ $reciept_purchase->document }} </a> 
							@endif
						</td>
                      </tr>
                       {{-- <tr>
                        <td>No Obligation letter</td>
						<td>File :
							@if($obligation_letter)						
							<a href="{{asset('public/uploads/loans/'. $obligation_letter->document)}}" target="_blank"> {{ $obligation_letter->document }} </a> 
							@endif
						</td>
						</tr> --}}
						<tr>
                        <td>Letter from Enrollment</td>
						<td>File : 
							@if($letter_from_enrollment)
							<a href="{{asset('public/uploads/loans/'. $letter_from_enrollment->document)}}" target="_blank"> {{ $letter_from_enrollment->document }} </a> 
							@endif
						</td>
						</tr>
						{{-- <tr>
                        <td>Post Closure Letter</td>
						<td>File : 
							@if($post_closure_letter)
							<a href="{{asset('public/uploads/loans/'. $post_closure_letter->document)}}" target="_blank"> {{ $post_closure_letter->document }} </a> 
							@endif
						</td>
						</tr> --}}
						<tr>
                        <td>Power of Attorney</td>
						<td>File : 
							@if($power_of_attorney)
							<a href="{{asset('public/uploads/loans/'. $power_of_attorney->document)}}" target="_blank"> {{ $power_of_attorney->document }} </a> 
							@endif
						</td>
						</tr>
						<tr>
                        <td>Letter from GSTR1/3B</td>
						<td>File : 
							@if($gstr_1_3_b)
							<a href="{{asset('public/uploads/loans/'. $gstr_1_3_b->document)}}" target="_blank"> {{ $gstr_1_3_b->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>
					  
					   <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>
          </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, "home-loan-enquiry-detail.csv");
});

</script>
@endsection