@extends('fronted.layout.main')
@section('adcontent')
<style>
   .dataTables_length,
   .dataTables_filter {
      padding: 10px;
   }

   .swal-title {

      font-size: 18px;
   }
   table.dataTable thead th, table.dataTable thead td {
    padding: 8px;
    border-bottom: 0;
    }
    .dataTables_wrapper .dataTables_filter input {
    border: 1px solid #aaa;
    border-radius: 3px;
    padding: 0px;
    background-color: transparent;
    margin-left: 3px;
   }
   .mealdatable table{
   margin-bottom:0;
   }
   .dataTables_wrapper .dataTables_info 
  {
    font-size:12px;
    padding:5px;
  }
  .dataTables_paginate 
  {
    padding:0;
    font-size:12px; 
  }
  .dataTables_wrapper .dataTables_paginate .paginate_button 
    {
       padding:0;
    }
    .addmenuscroll .table-responsive {
        overflow-x: initial;
    }
</style>
<div class="container-fluid mt-2">
   @if ($message = Session::get('success'))
   <script>
      Swal.fire({
         icon: 'success',
         text: 'Old registration restore sucessfully',
      })
   </script>
   @endif

   @if ($message = Session::get('danger'))
   <script>
      Swal.fire({
         icon: 'warning',
         text: 'Old data  Deleted permanently',
      })
   </script>
   @endif
   <div class="container d-flex justify-content-around align-items-center  g-3">
      <div class="container my-1">
         @php
         $totalregis = DB::table('studentregisters')->get()->count('id');
         @endphp
         <p class="text-info p-text">Total Reg :- <span class="text-warning">{{$totalregis }}</span></p>
      </div>
      <div class="container my-1">
         @php
         $RunningReg = DB::table('studentregisters')->where('status',1)->get()->count('id');
         @endphp
         <p> <a href="{{url('register')}}" class="p-text text-decoration-none text-info p-text">Running Reg :- <span class="text-warning">{{$RunningReg}}</span></a></p>
      </div>
      <div class="container my-1">
         <p class="p-text"><a href="{{url('registerform')}}" class="btn btn-sm btn-warning text-white">Add Reg</a></p>
      </div>
      <div class="container my-1">
         @php
         $OldReg = DB::table('olddataregisters')->where('status',0)->get()->count('id');
         @endphp
         <p><a class="p-text text-info text-decoration-none" href="{{url('oldregistration')}}"> Old Reg :- <span class="text-warning">{{ $OldReg}}</span></a></p>
      </div>
      <div class="container my-1">
         @php
         $VacanttReg = DB::table('roomseats')->get()->sum('numberseats');
         $totalVacant = $VacanttReg - $RunningReg;
         @endphp
         <p class="text-info p-text">Vacant reg :- <span class="text-warning">{{$totalVacant}}</span></p>
      </div>
   </div>
   <div class="container-fluid  p-0" style="margin-top:-19px;">
      <div class="container">
         <div class="table-responsive dataTable">
            <table id="example" class="table text-center roomSeatTable">
               <thead class="align-middle">
                  <tr>
                     <th>S.No</th>
                     <th>Room NO</th>
                     <th>Reg No</th>
                     <th>Reg Date</th>
                     <th>Leaving Date</th>
                     <th>Candidate</th>
                     <th>Mobile No</th>
                     <th>Tenure</th>
                     <th>Seat No</th>
                     <th>Rent</th>
                     <th>Fee Status</th>
                     <th>Action</th>
                     <th>Docs</th>
                  </tr>
               </thead>
               @php
               $data = DB::table('olddataregisters')->get();
               @endphp

               <tbody class="align-middle">
                  @php 
                  $count=1;
                  @endphp
                  @foreach($data as $temp)
                  <tr>
                     <td>{{$count++}}</td>
                     <td>{{$temp->roomno}}</td>
                     <td>{{$temp->formno}}</td>
                     <td>01-Jan-1970</td>
                     <td>01-Jan-1970</td>
                     <td class="text-start text-nowrap" style="text-indent:20%">{{ucfirst(trans($temp->candidatename))}}</td>
                     <td>{{$temp->phone}}</td>
                     <td>