@extends('layouts.buddy-screens')
@section('content')
    
	
          <!-- Content wrapper -->
          <div class="content-wrapper">
            <!-- Content -->
	
            <div class="container-xxl flex-grow-1 container-p-y">
              <h4 class="fw-bold py-3 mb-2"><span class="text-muted fw-light">Dashboard /</span> Enquiries Report</h4>
              @if ($message = Session::get('success_ibdeal'))
              <div class="modal" id="smallModal_ibdeal" tabindex="-1" aria-hidden="true" style="display:block">
                <div class="modal-dialog modal-sm" role="document">
                  <div class="modal-content">
                    <div class="modal-header">
                      <h5 class="modal-title" id="exampleModalLabel2">Success</h5>
                      <button
                        type="button"
                        class="btn-close"
                        data-bs-dismiss="modal"
                        aria-label="Close"
                        onclick="hide()"
                      ></button>
                    </div>
                    <div class="modal-body" id="body_msg">
                    <p>{{$message}}</p>
                    </div>
                    <div class="modal-footer">
                      <button type="button" onclick="hide()" class="btn btn-outline-secondary" data-bs-dismiss="modal">
                        Close
                      </button>
                      <button type="button" onclick="hide()" class="btn btn-primary" data-bs-dismiss="modal">Ok</button>
                    </div>
                  </div>
                </div>
              </div>
            @endif
            <nav class="navbar navbar-expand-lg">
                <div class="container-fluid ps-0 pr-0">
                <div class="table_top_heading">
                <h2 class="portfolio_heading">Pending List</h2>
                </div>
                <div class="right_btn_box">
                    <a
                        href="{{ url('enquiries-report?department=All&refresh=refresh') }}"
                        class="btn btn-primary mr10 reset_btn"
                        >
                        Reset
                        </a>
                        <button
                        type="button"
                        class="filter_btn"
                        data-bs-toggle="modal"
                        data-bs-target="#basicModal"
                        >
                        <img src="{{asset('assets/dashboard/assets/img/icons/filter_icon.svg')}}"/>


                        </button>
                   </div>

                               <!-- Modal -->
                        <div class="modal fade" id="basicModal" tabindex="-1" aria-hidden="true">
                           <div class="modal-dialog" role="document">
                            <form action="{{ url('enquiries-report') }}" method="GET">
                              <div class="modal-content">
                                 <div class="modal-header">
                                    <h5 class="modal-title" id="exampleModalLabel1">Date Filter</h5>
                                    <button
                                       type="button"
                                       class="btn-close"
                                       data-bs-dismiss="modal"
                                       aria-label="Close"
                                       ></button>
                                 </div>
                                 <div class="modal-body">
                                    <input type="hidden" name="department" value="{{ request()->get('department') != "" ? request()->get('department') : 'All' }}">
									<div class="row">
                                       <div class="col mb-3">
                                          <label for="nameBasic" class="form-label">From Date</label>
                                          <input type="date" id="nameBasic" class="form-control" placeholder="Enter Name" name="from-date" value="{{ Session()->get('from-date') }}"/>
                                       </div>
                                       <div class="col mb-3">
                                          <label for="nameBasic" class="form-label">To Date</label>
                                          <input type="date" id="nameBasic" class="form-control" placeholder="Enter Name" name="to-date" value="{{ Session()->get('to-date') }}"/>
                                       </div>
                                    </div>
                                    
                                 </div>
                                 <div class="modal-footer">
                                    <button type="button" class="btn btn-outline-secondary" data-bs-dismiss="modal">
                                    Close
                                    </button>
                                    <button type="submit" class="btn btn-primary">Search</button>
                                 </div>
                              </div>
                           </form>
                           </div>
                        </div>
                </div>
              </nav>
              <div class="row mb-5">
                <div class="custom_table_cntr">
                        <div class="table-responsive text-nowrap">
                          <table class="table">
                            <thead>
                              <tr>
                                <th>Date</th>
                                <th>Name</th>
                                <th>Email Id</th>
                                <th>Contact No.</th>
                                <th>Product Name</th>
                                <th>Department</th>
                                <th>Remark </th>
                                <th>Status </th>

                            
                              </tr>
                            </thead>
                            <tbody class="table-border-bottom-0">
                              {{-- PMS --}}
                              @if ($pms_query)
                                @foreach($pms_query as $_details)
                                <tr> 
                                    <td>{{ \Carbon\Carbon::parse($_details->created_at)->isoFormat('DD MMM YYYY')}}</td>
                                    <td></td>
                                    <td>@if(isset($_details->full_name) && $_details->full_name !='') {{$_details->full_name}} @else {{ucwords($_details->name)}} {{ucwords($_details->last_name)}} @endif</td>
                                    <td>{{$_details->emailid}}</td>
                                    <td>{{$_details->phone}}</td>
                                    <td>{{$_details->enquirycomments}}</td>
                                    <td>
                                                                                                                                                                                                                                                                          <span class="badge bg-label-info me-1">Un Seen</span>                                                                                                                                                          
                                    </td>
                                </tr>
                                @endforeach
                              @endif

                               {{-- AIF --}}
                               @if ($aif_query)
                               @foreach($aif_query as $_details)
                               <tr> 
                                   <td>{{ \Carbon\Carbon::parse($_details->created_at)->isoFormat('DD MMM YYYY')}}</td>
                                   <td>@if(isset($_details->full_name) && $_details->full_name !='') {{$_details->full_name}} @else {{ucwords($_details->name)}} {{ucwords($_details->last_name)}} @endif</td>                                 
                                   <td>{{$_details->emailid}}</td>
                                   <td>{{$_details->phone}}</td>
                                   <td>{{$_details->product_name}}</td>
                                   <td>{{$aif_department}}</td>
                                   <td>{{$_details->enquirycomments}}</td>
                                   <td>
                                                                                                                                                                                                                                                            <span class="badge bg-label-info me-1">Un Seen</span>                                                                                                                                                  
                                  </td>
                               </tr>
                               @endforeach
                             @endif

                             {{-- stock-market --}}
                             @if ($stock_market_query)
                             @foreach($stock_market_query as $_details)
                             <tr> 
                                 <td>{{ \Carbon\Carbon::parse($_details->created_at)->isoFormat('DD MMM YYYY')}}</td>
                                 <td>@if(isset($_details->full_name) && $_details->full_name !='') {{$_details->full_name}} @else {{ucwords($_details->name)}} {{ucwords($_details->last_name)}} @endif</td>                                   
                                 <td>{{$_details->emailid}}</td>
                                 <td>{{$_details->phone}}</td>
                                 <td>{{$_details->productname}}</td>
                                 <td>{{ucwords(str_replace('-', ' ', $stock_market_department))}}</td>
                                 <td>{{$_details->enquirycomments}}</td>
                                 <td>
                                                                                                                                                                                                                                              <span class="badge bg-label-info me-1">Un Seen</span>                                                                                                                                         
                                </td>
                             </tr>
                             @endforeach
                           @endif

                            {{-- FIS --}}
                            @if ($fis_query)
                            @foreach($fis_query as $_details)
                            <tr> 
                                <td>{{ \Carbon\Carbon::parse($_details->created_at)->isoFormat('DD MMM YYYY')}}</td>
                                <td>@if(isset($_details->full_name) && $_details->full_name !='') {{$_details->full_name}} @else {{ucwords($_details->name)}} {{ucwords($_details->last_name)}} @endif</td>                     
                                <td>{{$_details->emailid}}</td>
                                <td>{{$_details->phone}}</td>
                                <td>{{$_details->productname}}</td>
                                <td>{{$fis_department}}</td>
                                <td>{{$_details->enquirycomments}}</td>
                                <td>
                                                                                                                                                                                                                                       <span class="badge bg-label-info me-1">Un Seen</span>                                                                                                                                     
                                </td>
                            </tr>
                            @endforeach
                          @endif

                          {{-- Home Loan --}}
                          @if ($home_loan_query)
                          @foreach($home_loan_query as $_details)
                          <tr> 
                              <td>{{ \Carbon\Carbon::parse($_details->created_at)->isoFormat('DD MMM YYYY')}}</td>
                              <td>@if(isset($_details->full_name) && $_details->full_name !='') {{$_details->full_name}} @else {{ucwords($_details->name)}} {{ucwords($_details->last_name)}} @endif</td>
                                   
                              <td>{{$_details->email}}</td>
                              <td>{{$_details->contact_no}}</td>
                              <td>Home Loan</td>
                              <td>{{$home_department}}</td>
                              <td>{{$_details->enquirycomments}}</td>
                              <td>
                                                                                                                                                                                                                         <span class="badge bg-label-info me-1">Un Seen</span>                                                                                                                             
                              </td>
                          </tr>
                          @endforeach
                        @endif

                        {{-- LAP --}}
                        @if ($lap_query)
                        @foreach($lap_query as $_details)
                        <tr> 
                            <td>{{ \Carbon\Carbon::parse($_details->created_at)->isoFormat('DD MMM YYYY')}}</td>
                            <td>@if(isset($_details->full_name) && $_details->full_name !='') {{$_details->full_name}} @else {{ucwords($_details->name)}} {{ucwords($_details->last_name)}} @endif</td>
                                   
                            <td>{{$_details->email}}</td>
                            <td>{{$_details->contact_no}}</td>
                            <td>LAP</td>
                            <td>{{$lap_department}}</td>
                            <td>{{$_details->enquirycomments}}</td>
                            <td>
                                                                                                                                                                                                           <span class="badge bg-label-info me-1">Un Seen</span>                                                                                                                     
                            </td>
                        </tr>
                        @endforeach
                      @endif

                      {{-- business-finance --}}
                      @if ($bf_query)
                        @foreach($bf_query as $_details)
                        <tr> 
                            <td>{{ \Carbon\Carbon::parse($_details->created_at)->isoFormat('DD MMM YYYY')}}</td>
                            <td>@if(isset($_details->full_name) && $_details->full_name !='') {{$_details->full_name}} @else {{ucwords($_details->name)}} {{ucwords($_details->last_name)}} @endif</td>
                                   
                            <td>{{$_details->email}}</td>
                            <td>{{$_details->contact_no}}</td>
                            <td>Business-Finance</td>
                            <td>{{$bf_department}}</td>
                            <td>{{$_details->enquirycomments}}</td>
                            <td>
                                                                                                                                                                                                    <span class="badge bg-label-info me-1">Un Seen</span>                                                                                                                   
                          </td>
                        </tr>
                        @endforeach
                      @endif

                       {{-- personal-loan --}}
                       @if ($pl_query)
                       @foreach($pl_query as $_details)
                       <tr> 
                           <td>{{ \Carbon\Carbon::parse($_details->created_at)->isoFormat('DD MMM YYYY')}}</td>
                           <td>@if(isset($_details->full_name) && $_details->full_name !='') {{$_details->full_name}} @else {{ucwords($_details->name)}} {{ucwords($_details->last_name)}} @endif</td>
                                   
                           <td>{{$_details->email}}</td>
                           <td>{{$_details->contact_no}}</td>
                           <td>Personal-Loan</td>
                           <td>{{$pl_department}}</td>
                           <td>{{$_details->enquirycomments}}</td>
                           <td>
                                                                                                                                                                                             <span class="badge bg-label-info me-1">Un Seen</span>                                                                                                              
                          </td>
                       </tr>
                       @endforeach
                     @endif

                      {{-- Business-loan --}}
                      @if ($bl_query)
                        @foreach($bl_query as $_details)
                        <tr> 
                            <td>{{ \Carbon\Carbon::parse($_details->created_at)->isoFormat('DD MMM YYYY')}}</td>
                            <td>@if(isset($_details->full_name) && $_details->full_name !='') {{$_details->full_name}} @else {{ucwords($_details->name)}} {{ucwords($_details->last_name)}} @endif</td>
                                   
                            <td>{{$_details->email}}</td>
                            <td>{{$_details->contact_no}}</td>
                            <td>Business-Loan</td>
                            <td>{{$bl_department}}</td>
                            <td>{{$_details->enquirycomments}}</td>
                            <td>
                                                                                                                                                                                                    <span class="badge bg-label-info me-1">Un Seen</span>                                                                                                                   
                          </td>
                        </tr>
                        @endforeach
                      @endif

                      {{-- Angel Investment --}}
                        @if ($ai_query)
                          @foreach($ai_query as $_details)
                          <tr> 
                              <td>{{ \Carbon\Carbon::parse($_details->created_at)->isoFormat('DD MMM YYYY')}}</td>
                              <td>@if(isset($_details->full_name) && $_details->full_name !='') {{$_details->full_name}} @else {{ucwords($_details->name)}} {{ucwords($_details->last_name)}} @endif</td>
                                   
                              <td>{{$_details->emailid}}</td>
                              <td>{{$_details->phone}}</td>
                              <td>{{$_details->deal_name}}</td>
                              <td>{{$ai_department}}</td>
                              <td>{{$_details->enquirycomments}}</td>
                              <td>
                                                                                                                                                                                                                                                <span class="badge bg-label-info me-1">Un Seen</span>                                                                                                                           
                            </td>
                          </tr>
                          @endforeach
                        @endif

                      {{-- Investment-Banking --}}
                      @if ($ib_query)
                        @foreach($ib_query as $_details)
                        <tr> 
                            <td>{{ \Carbon\Carbon::parse($_details->created_at)->isoFormat('DD MMM YYYY')}}</td>
                            <td>@if(isset($_details->full_name) && $_details->full_name !='') {{$_details->full_name}} @else {{ucwords($_details->name)}} {{ucwords($_details->last_name)}} @endif</td>
                                   
                            <td>{{$_details->email}}</td>
                            <td>{{$_details->contact_no}}</td>
                            <td>{{$_details->deal_name}}</td>
                            <td>{{$ib_department}}</td>
                            <td>{{$_details->enquirycomments}}</td>
                            <td>
                                                                                                                                                                                                    <span class="badge bg-label-info me-1">Un Seen</span>                                                                                                                   
                          </td>
                        </tr>
                        @endforeach
                      @endif

                       {{-- Life-Insurance --}}
                       @if ($life_insurance_query)
                        @foreach($life_insurance_query as $_details)
                        <tr> 
                            <td>{{ \Carbon\Carbon::parse($_details->created_at)->isoFormat('DD MMM YYYY')}}</td>
                            <td>@if(isset($_details->full_name) && $_details->full_name !='') {{$_details->full_name}} @else {{ucwords($_details->name)}} {{ucwords($_details->last_name)}} @endif</td>
                                   
                            <td>{{$_details->email}}</td>
                            <td>{{$_details->contact_no}}</td>
                            <td>Life-Insurance</td>
                            <td>{{$life_insurance_department}}</td>
                            <td>{{$_details->enquirycomments}}</td>
                            <td>
                                                                                                                                                                                                    <span class="badge bg-label-info me-1">Un Seen</span>                                                                                                                   
                          </td>
                        </tr>
                        @endforeach
                      @endif

                      {{-- Health-Insurance --}}
                      @if ($health_insurance_query)
                        @foreach($health_insurance_query as $_details)
                        <tr> 
                            <td>{{ \Carbon\Carbon::parse($_details->created_at)->isoFormat('DD MMM YYYY')}}</td>
                            <td>@if(isset($_details->full_name) && $_details->full_name !='') {{$_details->full_name}} @else {{ucwords($_details->name)}} {{ucwords($_details->last_name)}} @endif</td>
                                   
                            <td>{{$_details->email}}</td>
                            <td>{{$_details->contact_no}}</td>
                            <td>Health-Insurance</td>
                            <td>{{$health_insurance_department}}</td>
                            <td>{{$_details->enquirycomments}}</td>
                            <td>
                                                                                                                                                                                                    <span class="badge bg-label-info me-1">Un Seen</span>                                                                                                                   
                          </td>
                        </tr>
                        @endforeach
                      @endif

                      {{-- General-Insurance --}}
                      @if ($general_insurance_query)
                        @foreach($general_insurance_query as $_details)
                        <tr> 
                            <td>{{ \Carbon\Carbon::parse($_details->created_at)->isoFormat('DD MMM YYYY')}}</td>
                            <td>@if(isset($_details->full_name) && $_details->full_name !='') {{$_details->full_name}} @else {{ucwords($_details->name)}} {{ucwords($_details->last_name)}} @endif</td>
                                   
                            <td>{{$_details->email}}</td>
                            <td>{{$_details->contact_no}}</td>
                            <td>General-Insurance</td>
                            <td>{{$general_insurance_department}}</td>
                            <td>{{$_details->enquirycomments}}</td>
                            <td>
                                                                                                                                                                                                    <span class="badge bg-label-info me-1">Un Seen</span>                                                                                                                   
                          </td>
                        </tr>
                        @endforeach
                      @endif

                      {{-- other-services --}}
                      @if ($services_query)
                        @foreach($services_query as $_details)
                        <tr> 
                            <td>{{ \Carbon\Carbon::parse($_details->created_at)->isoFormat('DD MMM YYYY')}}</td>
                            <td>@if(isset($_details->full_name) && $_details->full_name !='') {{$_details->full_name}} @else {{ucwords($_details->name)}} {{ucwords($_details->last_name)}} @endif</td>
                                   
                            <td>{{$_details->email}}</td>
                            <td>{{$_details->contact_no}}</td>
                            <td>{{$_details->enquiry}}</td>
                            <td>{{$services_department}}</td>
                            <td>-</td>
                            <td>
                                                                                                                                                                                                    <span class="badge bg-label-info me-1">Un Seen</span>                            </td>
                        </tr>
                        @endforeach
                      @endif 
                      
                      @if ($final_data)
                      
                      @foreach($final_data as $key => $details)

                      <tr> 
                        <td>{{ \Carbon\Carbon::parse($details['created_at'])->isoFormat('DD MMM YYYY')}}</td>
                        <td>@if(isset($details['full_name']) && $details['full_name'] !='') {{$details['full_name']}} @else {{ucwords($details['name'])}} {{ucwords($details['last_name'])}} @endif</td>
                                   
                        <td>@if(isset($details['emailid']) && $details['emailid'] !='') {{$details['emailid']}}  @else {{$details['email']}} @endif</td>
                        <td>@if(isset($details['contact_no']) && $details['contact_no'] !='') {{$details['contact_no']}}  @else {{$details['phone']}} @endif</td>
                        <td>{{$details['productname']}}</td>
                       
                        @if (isset($details['dep_pms']))
                        <td>PMS</td>
                        @elseif (isset($details['dep_aif']))
                        <td>AIF</td>
                        @elseif (isset($details['dep_stock']))
                        <td>Stock Market</td>
                        @elseif (isset($details['dep_fis']))
                        <td>FIS</td>
                        @elseif (isset($details['dep_home_loan']))
                        <td>Home Loan</td>
                        @elseif (isset($details['dep_lap']))
                        <td>LAP</td>
                        @elseif (isset($details['dep_bf']))
                        <td>Business Finance</td>
                        @elseif (isset($details['dep_pl']))
                        <td>Personal Loan</td>
                        @elseif (isset($details['dep_bl']))
                        <td>Business Loan</td>
                        @elseif (isset($details['dep_ai']))
                        <td>AI</td>
                        @elseif (isset($details['dep_ib']))
                        <td>IB</td>
                        @elseif (isset($details['dep_li']))
                        <td>Life Insurance</td>
                        @elseif (isset($details['dep_hi']))
                        <td>Health Insurance</td>
                        @elseif (isset($details['dep_gi']))
                        <td>General Insurance</td>
                        @elseif (isset($details['dep_services']))
                        <td>Services</td>
                        @endif
                        <td>@if(isset($details['enquirycomments'])) {{$details['enquirycomments']}} @endif</td>
                        <td>
                                                                                                                                                                                      <span class="badge bg-label-info me-1">Un Seen</span>                                                                                                          
                        </td>
                        </tr>
                        @endforeach
                        @endif
                      </tbody>
                      </table>
                  @if ($pms_query && request()->get('department') == 'PMS')
                    {{ $pms_query->links("pagination::bootstrap-4") }}
                  @endif

                  @if ($aif_query && request()->get('department') == 'AIF')
                    {{ $aif_query->links("pagination::bootstrap-4") }}
                  @endif

                  @if ($stock_market_query && request()->get('department') == 'stock-market')
                  {{ $stock_market_query->links("pagination::bootstrap-4") }}
                  @endif

                  @if ($fis_query && request()->get('department') == 'FIS')
                  {{ $fis_query->links("pagination::bootstrap-4") }}
                  @endif

                  @if ($home_loan_query && request()->get('department') == 'home-loan')
                  {{ $home_loan_query->links("pagination::bootstrap-4") }}
                  @endif

                  @if ($lap_query && request()->get('department') == 'lap')
                  {{ $lap_query->links("pagination::bootstrap-4") }}
                  @endif

                  @if ($bf_query && request()->get('department') == 'business-finance')
                  {{ $bf_query->links("pagination::bootstrap-4") }}
                  @endif

                  @if ($pl_query && request()->get('department') == 'personal-loan')
                  {{ $pl_query->links("pagination::bootstrap-4") }}
                  @endif

                  @if ($bl_query && request()->get('department') == 'business-loan')
                  {{ $bl_query->links("pagination::bootstrap-4") }}
                  @endif

                  @if ($life_insurance_query && request()->get('department') == 'life-insurance')
                  {{ $life_insurance_query->links("pagination::bootstrap-4") }}
                  @endif

                  @if ($health_insurance_query && request()->get('department') == 'health-insurance')
                  {{ $health_insurance_query->links("pagination::bootstrap-4") }}
                  @endif

                  @if ($general_insurance_query && request()->get('department') == 'general-insurance')
                  {{ $general_insurance_query->links("pagination::bootstrap-4") }}
                  @endif

                  @if ($ai_query && request()->get('department') == 'angel-investment')
                  {{ $ai_query->links("pagination::bootstrap-4") }}
                  @endif

                  @if ($ib_query && request()->get('department') == 'investment-banking')
                  {{ $ib_query->links("pagination::bootstrap-4") }}
                  @endif

                  @if ($services_query && request()->get('department') == 'other-services')
                  {{ $services_query->links("pagination::bootstrap-4") }}
                  @endif

                        </div>
                      </div>	
                </div>
					            
              <!--/ Card layout -->
            </div>
            <!-- / Content -->

          </div>
          <!-- Content wrapper -->
       
<script>
var APP_URL = {!! json_encode(url('/')) !!}
function changstatus(d)
{
	var status = d.getAttribute("status");
	var title = d.getAttribute("title");

	// window.location.href= APP_URL+"/user-report?"+"status="+status;
	window.location.href= APP_URL+"/user-report?"+"status-title="+title+"&status="+status;

	// window.location.href= APP_URL+"/life-insurance-enquiry?"+"status_id="+id+"&&status_title="+title;

}

function hide(){
    $('#smallModal_ibdeal').hide();
  }
</script>
  @endsection