@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 Financing /</span> Business Financing 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>
			   
              <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>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>
						
                    </tbody>
                  </table>
                </div>
				
				<h5 class="green">Property Project Details</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>Aadhar Card Front</td>
						<td>File : 
						@if($aadhar_card_front)
							<a href="{{asset('public/uploads/pfs/'. $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/pfs/'. $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/pfs/'. $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/pfs/'. $address_proof->document)}}" target="_blank"> {{ $address_proof->document }} </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/pfs/'. $dc->document)}}" target="_blank"> Doc {{ $count }} </a> |
							 @php($count++)
							@endforeach							
						</td>
                      </tr> 
					  <tr>
                        <td>Income Tax details</td>
						<td>File :
							@php($count=1)
							@foreach($income_tax as $key => $dc )							
							<a href="{{asset('public/uploads/pfs/'. $dc->document)}}" target="_blank"> Doc {{ $count }} </a> |
							 @php($count++)
							@endforeach							
						</td>
                      </tr> 
					  <tr>
                        <td>Property Deatils Documents</td>
						<td>File :
							@php($count=1)
							@foreach($property_details as $key => $dc )							
							<a href="{{asset('public/uploads/pfs/'. $dc->document)}}" target="_blank"> Doc {{ $count }} </a> |
							 @php($count++)
							@endforeach							
						</td>
                      </tr> 
					  <tr>
                        <td>Salary Slip (Last 6 Months)</td>
						<td>File :
							@php($count=1)
							@foreach($salery_slip as $key => $dc )							
							<a href="{{asset('public/uploads/pfs/'. $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/pfs/'. $dc->document)}}" target="_blank"> Doc {{ $count }} </a> |
							 @php($count++)
							@endforeach							
						</td>
                      </tr> 
					  <tr>
                        <td>GSTR1/3B</td>
						<td>File :
							@php($count=1)
							@foreach($gstr_1_3_b as $key => $dc )							
							<a href="{{asset('public/uploads/pfs/'. $dc->document)}}" target="_blank"> Doc {{ $count }} </a> |
							 @php($count++)
							@endforeach							
						</td>
                      </tr> 
                      
					  <tr>
                <td>PAN Card</td>
                <td>File : @if(isset($pan_card->document))
                  <a href="{{asset('public/uploads/pfs/'. $pan_card->document)}}" target="_blank">
                  <img src="{{asset('public/uploads/pfs/'. $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/pfs/'. $aadhar_card->document)}}" target="_blank">
                  <img src="{{asset('public/uploads/pfs/'. $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/pfs/'. $bank_statement_new->document)}}" target="_blank">
                    <img src="{{asset('public/uploads/pfs/'. $bank_statement_new->document)}}" width="50"></a> @endif</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-financing-enquiry-detail.csv");
});
</script>
@endsection