<?php 
include('header.php');
include('../includes/config.php');
if (isset($_POST['txn_form']) && $_POST['txn_form'] == "ahkwebsolutions"  ){
  
  $name = mysqli_real_escape_string($conn, $_POST['name']);
  $email = mysqli_real_escape_string($conn, $_POST['email']);
  $sub = mysqli_real_escape_string($conn, $_POST['sub']);
  $mess = mysqli_real_escape_string($conn, $_POST['mess']);
  $res = mysqli_query($conn,"INSERT INTO `contact`(`name`, `email`, `sub`, `mess`) VALUES ('$name','$email','$sub','$mess')");
  if($res){
      ?>
      <script>
          $(function(){
              Swal.fire(
                  'Success',
                  'Message Send Successfully',
                  'success'
              )

          });
           
  window.setTimeout(function() {
  window.location.href = "index.php";
  }, 1500);
      </script>
      <?php
  }else{
      ?>
      <script>
          $(function(){
              Swal.fire(
                  'Opps',
                  'Internal Server Problem Please Try Again Lates!',
                  'error'
              )

          });
      </script>
      <?php

  }
  
}
?>
<!-- Begin Page Content -->
<div class="container-fluid">

<!-- Page Heading -->
<br>
<a href="https://mega.nz/file/UVYTRQiI#LIEz2dmLkf12XSWPy9D-MC1HXw4nrI-6jbkBeVdgcSU" class="d-none d-sm-inline-block btn btn-sm btn-primary shadow-sm"><i
            class="fas fa-download fa-sm text-white-50"></i> Generate Report</a> 
            &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
<br><br>
<div class="d-sm-flex align-items-center -content-between mb-4">
    <h1 class="h3 mb-0 text-gray-800"></h1>
    
            <a href="https://whatsapp.com/channel/0029VbBMxl4GE56mzUBmtU27" class="d-none d-sm-inline-block btn btn-sm btn-dark shadow-sm"><i
            <strong><sup><img src="https://img-cdn.thepublive.com/entrackr/media/post_attachments/wp-content/uploads/2018/01/Aadhaar_Face-z.gif" alt=""></sup></strong></a>
            &nbsp;&nbsp;
             <a href="https://whatsapp.com/channel/0029VaGzleVFMqrbWMfF9N2p" class="d-none d-sm-inline-block btn btn-sm btn-dark shadow-sm"><i
            <strong><sup><img src="https://ecardcutter.go24.info/img/aadharicon.gif" alt=""></sup></strong></a>
            
            
            
            
            
            
   
    
</div>

<!-- Content Row -->
<div class="row">

    <!-- Earnings (Monthly) Card Example -->
    <div class="col-xl-3 col-md-4 mb-4">
        <div class="card border-left-primary shadow h-100 py-2">
            <div class="card-body">
                <div class="row no-gutters align-items-center">
                    <div class="col mr-2">
                        <div class="text-xs font-weight-bold text-primary text-uppercase mb-1">
                        
                        <!-------------<a href="rr.jpg" class=" btn btn-sm btn-danger shadow-sm"><i
            class="fas fa-plus fa-sm text-white-50"></i>Add Balance</a>------------->
            
            <a href="walletruby.php" class=" btn btn-sm btn-success shadow-sm"><i
            class="fas fa-plus fa-sm text-white-50"></i>Add Balance</a>
                        </div>
                      
                        <div class="h5 mb-0 font-weight-bold text-gray-800">₹ <?php echo $udata['walletamount']?></div>
                    </div>
                    <div class="col-auto">
                        <i class="fas fa-rupee-sign fa-2x text-gray-300"></i>
                    </div>
                </div>
            </div>
        </div>
    </div>
  
    <?php 
                                                $q = "";
                                                $q = "SELECT count(*) as cnt FROM customers where appliedby='$s_phone' ";
                                                $rr = mysqli_query($conn,$q);
                                                $rorw = mysqli_fetch_assoc($rr);
                                                $rorw['cnt'];
                                            ?>
    <!-- Earnings (Monthly) Card Example -->
    <div class="col-xl-3 col-md-4 mb-4">
        <div class="card border-left-info shadow h-100 py-2">
            <div class="card-body">
                <div class="row no-gutters align-items-center" style="font-size:12px;">
                    <div class="col mr-2">
                        <div class="text-xs font-weight-bold text-info text-uppercase mb-1">
                            TOTAL CHILD APPLICATION</div>
                        <div class="h5 mb-0 font-weight-bold text-gray-800"><?php echo $rorw['cnt']; ?></div>
                    </div>
                    <div class="col-auto">
                        <i class="fa fa-street-view fa-2x text-gray-300"></i>
                    </div>
                </div>
            </div>
        </div>
    </div>
     <?php 
                                                $q = "";
                                                $q = "SELECT count(*) as cnt FROM customers WHERE appliedby='$s_phone' && status='reject'";
                                                $rr = mysqli_query($conn,$q);
                                                $rorw = mysqli_fetch_assoc($rr);
                                                $rorw['cnt'];
                                            ?>
    <!-- Earnings (Monthly) Card Example -->
    <div class="col-xl-2 col-md-4 mb-4">
        <div class="card border-left-primary shadow h-100 py-2">
            <div class="card-body">
                <div class="row no-gutters align-items-center" style="font-size:12px;">
                    <div class="col mr-2">
                        <div class="text-xs font-weight-bold text-danger text-uppercase mb-1">
                            REJECT APPLICATIONS</div>
                        <div class="h5 mb-0 font-weight-bold text-gray-800"><?php echo $rorw['cnt']; ?></div>
                    </div>
                    <div class="col-auto">
                        <i class="fa fa-window-close fa-2x text-gray-300"></i>
                    </div>
                </div>
            </div>
        </div>
    </div>
    <?php 
                                                $q = "";
                                                $q = "SELECT count(*) as cnt FROM customers WHERE appliedby='$s_phone' && status='success'";
                                                $rr = mysqli_query($conn,$q);
                                                $rorw = mysqli_fetch_assoc($rr);
                                                $rorw['cnt'];
                                            ?>

    <!-- Earnings (Monthly) Card Example -->
    <div class="col-xl-2 col-md-4 mb-4">
        <div class="card border-left-success shadow h-100 py-2">
            <div class="card-body">
                <div class="row no-gutters align-items-center" style="font-size:12px;">
                    <div class="col mr-2">
                        <div class="text-xs font-weight-bold text-success text-uppercase mb-1">SUCCESS APPLICATIONS
                        </div>
                        <div class="row no-gutters align-items-center">
                            <div class="col-auto">
                                <div class="h5 mb-0 mr-3 font-weight-bold text-gray-800"><?php echo $rorw['cnt']; ?></div>
                            </div>
                            <div class="col">
                                <div class="progress progress-sm mr-2">
                                    <div class="progress-bar bg-success" role="progressbar"
                                        style="width: 50%" aria-valuenow="50" aria-valuemin="0"
                                        aria-valuemax="100"></div>
                                </div>
                            </div>
                        </div>
                    </div>
                    <div class="col-auto">
                        <i class="fa fa-heart fa-2x text-gray-300"></i>
                    </div>
                </div>
            </div>
        </div>
    </div>
    
    <?php 
                                                $q = "";
                                                $q = "SELECT count(*) as cnt FROM customers WHERE appliedby='$s_phone' && status='pending'";
                                                $rr = mysqli_query($conn,$q);
                                                $rorw = mysqli_fetch_assoc($rr);
                                                $rorw['cnt'];
                                            ?>
    <!-- Pending Requests Card Example -->
    <div class="col-xl-2 col-md-4 mb-4">
        <div class="card border-left-warning shadow h-100 py-2">
            <div class="card-body">
                <div class="row no-gutters align-items-center" style="font-size:12px;">
                    <div class="col mr-2">
                        <div class="text-xs font-weight-bold text-warning text-uppercase mb-1">
                            PENDING Requests</div>
                        <div class="h5 mb-0 font-weight-bold text-gray-800"><?php echo $rorw['cnt']; ?></div>
                    </div>
                    <div class="col-auto">
                        <i class="fa fa-history fa-2x text-gray-300"></i>
                    </div>
                </div>
            </div>
        </div>
    
</div>
<?php 
    
                                                $q = "";
                                                $q = "SELECT count(*) as cnt FROM customers where appliedby='$s_phone'";
                                                $rr = mysqli_query($conn,$q);
                                                $rorw = mysqli_fetch_assoc($rr);
                                                $rorw['cnt'];
                                            ?>
    <!-- Earnings (Monthly) Card Example -->
    <div class="col-xl-3 col-md-4 mb-4">
        <div class="card border-left-info shadow h-100 py-2" style="background: url(&quot;https://cms.patrika.com/wp-content/uploads/2020/11/07/mobile.jpg&quot;) center center / cover;">
            <div class="card-body">
                <div class="row no-gutters align-items-center">
                    <div class="col mr-2">
                        <div class="text-xs font-weight-bold text-info text-uppercase mb-1">
                          </div>
                        <div class="h5 mb-0 font-weight-bold text-gray-800"></div>
                    </div>
                    <div class="col-auto">
                        <i class="fas fa-clipboard-lista fa-2x text-gray-300"></i>
                    </div>
                </div>
            </div>
        </div>
    </div>

<?php 
    
                                                $q = "";
                                                $q = "SELECT count(*) as cnt FROM mobile where appliedby='$s_phone'";
                                                $rr = mysqli_query($conn,$q);
                                                $rorw = mysqli_fetch_assoc($rr);
                                                $rorw['cnt'];
                                            ?>
    <!-- Earnings (Monthly) Card Example -->
    <div class="col-xl-3 col-md-4 mb-4">
        <div class="card border-left-info shadow h-100 py-2">
            <div class="card-body">
                <div class="row no-gutters align-items-center" style="font-size:12px;">
                    <div class="col mr-2">
                        <div class="text-xs font-weight-bold text-info text-uppercase mb-1">
                            Total Applications Mobile & Email</div>
                        <div class="h5 mb-0 font-weight-bold text-gray-800"><?php echo $rorw['cnt']; ?></div>
                    </div>
                    <div class="col-auto">
                        <i class="fa fa-vcard fa-2x text-gray-300"></i>
                    </div>
                </div>
            </div>
        </div>
    </div>
     <?php 
                                                $q = "";
                                                $q = "SELECT count(*) as cnt FROM mobile where appliedby='$s_phone' AND status='reject'";
                                                $rr = mysqli_query($conn,$q);
                                                $rorw = mysqli_fetch_assoc($rr);
                                                $rorw['cnt'];
                                            ?>
    <!-- Earnings (Monthly) Card Example -->
    <div class="col-xl-2 col-md-4 mb-4">
        <div class="card border-left-danger shadow h-100 py-2">
            <div class="card-body">
                <div class="row no-gutters align-items-center" style="font-size:12px;">
                    <div class="col mr-2">
                        <div class="text-xs font-weight-bold text-danger text-uppercase mb-1">
                            Reject Applications</div>
                        <div class="h5 mb-0 font-weight-bold text-gray-800"><?php echo $rorw['cnt']; ?></div>
                    </div>
                    <div class="col-auto">
                        <i class="fa fa-window-close fa-2x text-gray-300"></i>
                    </div>
                </div>
            </div>
        </div>
    </div>
    <?php 
                                                $q = "";
                                                $q = "SELECT count(*) as cnt FROM mobile WHERE appliedby='$s_phone' && status='success'";
                                                $rr = mysqli_query($conn,$q);
                                                $rorw = mysqli_fetch_assoc($rr);
                                                $rorw['cnt'];
                                            ?>

    <!-- Earnings (Monthly) Card Example -->
    <div class="col-xl-2 col-md-4 mb-4">
        <div class="card border-left-success shadow h-100 py-2">
            <div class="card-body">
                <div class="row no-gutters align-items-center" style="font-size:12px;">
                    <div class="col mr-2">
                        <div class="text-xs font-weight-bold text-success text-uppercase mb-1">Success Applications
                        </div>
                        <div class="row no-gutters align-items-center">
                            <div class="col-auto">
                                <div class="h5 mb-0 mr-3 font-weight-bold text-gray-800"><?php echo $rorw['cnt']; ?></div>
                            </div>
                            <div class="col">
                                <div class="progress progress-sm mr-2">
                                    <div class="progress-bar bg-success" role="progressbar"
                                        style="width: 50%" aria-valuenow="50" aria-valuemin="0"
                                        aria-valuemax="100"></div>
                                </div>
                            </div>
                        </div>
                    </div>
                    <div class="col-auto">
                        <i class="fa fa-check-circle fa-2x text-gray-300"></i>
                    </div>
                </div>
            </div>
        </div>
    </div>
    
    <?php 
                                                $q = "";
                                                $q = "SELECT count(*) as cnt FROM mobile WHERE appliedby='$s_phone' && status='pending'";
                                                $rr = mysqli_query($conn,$q);
                                                $rorw = mysqli_fetch_assoc($rr);
                                                $rorw['cnt'];
                                            ?>
    <!-- Pending Requests Card Example -->
    <div class="col-xl-2 col-md-4 mb-4">
        <div class="card border-left-warning shadow h-100 py-2">
            <div class="card-body">
                <div class="row no-gutters align-items-center" style="font-size:12px;">
                    <div class="col mr-2">
                        <div class="text-xs font-weight-bold text-warning text-uppercase mb-1">
                            Pending Requests</div>
                        <div class="h5 mb-0 font-weight-bold text-gray-800"><?php echo $rorw['cnt']; ?></div>
                    </div>
                    <div class="col-auto">
                        <i class="fa fa-exclamation-triangle fa-2x text-gray-300"></i>
                    </div>
                </div>
            </div>
        </div>
    </div>
    <?php 
    
                                                $q = "";
                                                $q = "SELECT count(*) as cnt FROM mobile where appliedby='$s_phone'";
                                                $rr = mysqli_query($conn,$q);
                                                $rorw = mysqli_fetch_assoc($rr);
                                                $rorw['cnt'];
                                            ?>
    <!-- Earnings (Monthly) Card Example -->
    <div class="col-xl-3 col-md-4 mb-4">
        <div class="card border-left-info shadow h-100 py-2" style="background: url(&quot;https://cdn1.iconfinder.com/data/icons/baby-glyph-set/500/baby_glyph_icon_cake-512.png&quot;) center center / cover;">
            <div class="card-body">
                <div class="row no-gutters align-items-center">
                    <div class="col mr-2">
                        <div class="text-xs font-weight-bold text-info text-uppercase mb-1">
                          </div>
                        <div class="h5 mb-0 font-weight-bold text-gray-800"></div>
                    </div>
                    <div class="col-auto">
                        <i class="fas fa-clipboard-lista fa-2x text-gray-300"></i>
                    </div>
                </div>
            </div>
        </div>
    </div>

<?php 
    
                                                $q = "";
                                                $q = "SELECT count(*) as cnt FROM dob where appliedby='$s_phone'";
                                                $rr = mysqli_query($conn,$q);
                                                $rorw = mysqli_fetch_assoc($rr);
                                                $rorw['cnt'];
                                            ?>
    <!-- Earnings (Monthly) Card Example -->
    <div class="col-xl-3 col-md-4 mb-4">
        <div class="card border-left-info shadow h-100 py-2">
            <div class="card-body">
                <div class="row no-gutters align-items-center" style="font-size:12px;">
                    <div class="col mr-2">
                        <div class="text-xs font-weight-bold text-info text-uppercase mb-1">
                            Total Applications Date Of Birth</div>
                        <div class="h5 mb-0 font-weight-bold text-gray-800"><?php echo $rorw['cnt']; ?></div>
                    </div>
                    <div class="col-auto">
                        <i class="fa fa-vcard fa-2x text-gray-300"></i>
                    </div>
                </div>
            </div>
        </div>
    </div>
     <?php 
                                                $q = "";
                                                $q = "SELECT count(*) as cnt FROM dob where appliedby='$s_phone' AND status='reject'";
                                                $rr = mysqli_query($conn,$q);
                                                $rorw = mysqli_fetch_assoc($rr);
                                                $rorw['cnt'];
                                            ?>
    <!-- Earnings (Monthly) Card Example -->
    <div class="col-xl-2 col-md-4 mb-4">
        <div class="card border-left-danger shadow h-100 py-2">
            <div class="card-body">
                <div class="row no-gutters align-items-center" style="font-size:12px;">
                    <div class="col mr-2">
                        <div class="text-xs font-weight-bold text-danger text-uppercase mb-1">
                            Reject Applications</div>
                        <div class="h5 mb-0 font-weight-bold text-gray-800"><?php echo $rorw['cnt']; ?></div>
                    </div>
                    <div class="col-auto">
                        <i class="fa fa-window-close fa-2x text-gray-300"></i>
                    </div>
                </div>
            </div>
        </div>
    </div>
    <?php 
                                                $q = "";
                                                $q = "SELECT count(*) as cnt FROM dob WHERE appliedby='$s_phone' && status='success'";
                                                $rr = mysqli_query($conn,$q);
                                                $rorw = mysqli_fetch_assoc($rr);
                                                $rorw['cnt'];
                                            ?>

    <!-- Earnings (Monthly) Card Example -->
    <div class="col-xl-2 col-md-4 mb-4">
        <div class="card border-left-success shadow h-100 py-2">
            <div class="card-body">
                <div class="row no-gutters align-items-center" style="font-size:12px;">
                    <div class="col mr-2">
                        <div class="text-xs font-weight-bold text-success text-uppercase mb-1">Success Applications
                        </div>
                        <div class="row no-gutters align-items-center">
                            <div class="col-auto">
                                <div class="h5 mb-0 mr-3 font-weight-bold text-gray-800"><?php echo $rorw['cnt']; ?></div>
                            </div>
                            <div class="col">
                                <div class="progress progress-sm mr-2">
                                    <div class="progress-bar bg-success" role="progressbar"
                                        style="width: 50%" aria-valuenow="50" aria-valuemin="0"
                                        aria-valuemax="100"></div>
                                </div>
                            </div>
                        </div>
                    </div>
                    <div class="col-auto">
                        <i class="fa fa-check-circle fa-2x text-gray-300"></i>
                    </div>
                </div>
            </div>
        </div>
    </div>
    
    <?php 
                                                $q = "";
                                                $q = "SELECT count(*) as cnt FROM dob WHERE appliedby='$s_phone' && status='pending'";
                                                $rr = mysqli_query($conn,$q);
                                                $rorw = mysqli_fetch_assoc($rr);
                                                $rorw['cnt'];
                                            ?>
    <!-- Pending Requests Card Example -->
    <div class="col-xl-2 col-md-4 mb-4">
        <div class="card border-left-warning shadow h-100 py-2">
            <div class="card-body">
                <div class="row no-gutters align-items-center" style="font-size:12px;">
                    <div class="col mr-2">
                        <div class="text-xs font-weight-bold text-warning text-uppercase mb-1">
                            Pending Requests</div>
                        <div class="h5 mb-0 font-weight-bold text-gray-800"><?php echo $rorw['cnt']; ?></div>
                    </div>
                    <div class="col-auto">
                        <i class="fa fa-exclamation-triangle fa-2x text-gray-300"></i>
                    </div>
                </div>
            </div>
        </div>
    </div>
<?php 
    
                                                $q = "";
                                                $q = "SELECT count(*) as cnt FROM dob where appliedby='$s_phone'";
                                                $rr = mysqli_query($conn,$q);
                                                $rorw = mysqli_fetch_assoc($rr);
                                                $rorw['cnt'];
                                            ?>
    <!-- Earnings (Monthly) Card Example -->
    <div class="col-xl-3 col-md-4 mb-4">
        <div class="card border-left-info shadow h-100 py-2" style="background: url(&quot;https://advocateadvice.in/wp-content/uploads/2025/01/Name-change-in-Aadhaar-Card.jpg&quot;) center center / cover;">
            <div class="card-body">
                <div class="row no-gutters align-items-center">
                    <div class="col mr-2">
                        <div class="text-xs font-weight-bold text-info text-uppercase mb-1">
                          </div>
                        <div class="h5 mb-0 font-weight-bold text-gray-800"></div>
                    </div>
                    <div class="col-auto">
                        <i class="fas fa-clipboard-lista fa-2x text-gray-300"></i>
                    </div>
                </div>
            </div>
        </div>
    </div>

<?php 
    
                                                $q = "";
                                                $q = "SELECT count(*) as cnt FROM name where appliedby='$s_phone'";
                                                $rr = mysqli_query($conn,$q);
                                                $rorw = mysqli_fetch_assoc($rr);
                                                $rorw['cnt'];
                                            ?>
    <!-- Earnings (Monthly) Card Example -->
    <div class="col-xl-3 col-md-4 mb-4">
        <div class="card border-left-info shadow h-100 py-2">
            <div class="card-body">
                <div class="row no-gutters align-items-center" style="font-size:12px;">
                    <div class="col mr-2">
                        <div class="text-xs font-weight-bold text-info text-uppercase mb-1">
                            Total Applications Name Update</div>
                        <div class="h5 mb-0 font-weight-bold text-gray-800"><?php echo $rorw['cnt']; ?></div>
                    </div>
                    <div class="col-auto">
                        <i class="fa fa-vcard fa-2x text-gray-300"></i>
                    </div>
                </div>
            </div>
        </div>
    </div>
     <?php 
                                                $q = "";
                                                $q = "SELECT count(*) as cnt FROM name where appliedby='$s_phone' AND status='reject'";
                                                $rr = mysqli_query($conn,$q);
                                                $rorw = mysqli_fetch_assoc($rr);
                                                $rorw['cnt'];
                                            ?>
    <!-- Earnings (Monthly) Card Example -->
    <div class="col-xl-2 col-md-4 mb-4">
        <div class="card border-left-danger shadow h-100 py-2">
            <div class="card-body">
                <div class="row no-gutters align-items-center" style="font-size:12px;">
                    <div class="col mr-2">
                        <div class="text-xs font-weight-bold text-danger text-uppercase mb-1">
                            Reject Applications</div>
                        <div class="h5 mb-0 font-weight-bold text-gray-800"><?php echo $rorw['cnt']; ?></div>
                    </div>
                    <div class="col-auto">
                        <i class="fa fa-window-close fa-2x text-gray-300"></i>
                    </div>
                </div>
            </div>
        </div>
    </div>
    <?php 
                                                $q = "";
                                                $q = "SELECT count(*) as cnt FROM name WHERE appliedby='$s_phone' && status='success'";
                                                $rr = mysqli_query($conn,$q);
                                                $rorw = mysqli_fetch_assoc($rr);
                                                $rorw['cnt'];
                                            ?>

    <!-- Earnings (Monthly) Card Example -->
    <div class="col-xl-2 col-md-4 mb-4">
        <div class="card border-left-success shadow h-100 py-2">
            <div class="card-body">
                <div class="row no-gutters align-items-center" style="font-size:12px;">
                    <div class="col mr-2">
                        <div class="text-xs font-weight-bold text-success text-uppercase mb-1">Success Applications
                        </div>
                        <div class="row no-gutters align-items-center">
                            <div class="col-auto">
                                <div class="h5 mb-0 mr-3 font-weight-bold text-gray-800"><?php echo $rorw['cnt']; ?></div>
                            </div>
                            <div class="col">
                                <div class="progress progress-sm mr-2">
                                    <div class="progress-bar bg-success" role="progressbar"
                                        style="width: 50%" aria-valuenow="50" aria-valuemin="0"
                                        aria-valuemax="100"></div>
                                </div>
                            </div>
                        </div>
                    </div>
                    <div class="col-auto">
                        <i class="fa fa-check-circle fa-2x text-gray-300"></i>
                    </div>
                </div>
            </div>
        </div>
    </div>
    
    <?php 
                                                $q = "";
                                                $q = "SELECT count(*) as cnt FROM name WHERE appliedby='$s_phone' && status='pending'";
                                                $rr = mysqli_query($conn,$q);
                                                $rorw = mysqli_fetch_assoc($rr);
                                                $rorw['cnt'];
                                            ?>
    <!-- Pending Requests Card Example -->
    <div class="col-xl-2 col-md-4 mb-4">
        <div class="card border-left-warning shadow h-100 py-2">
            <div class="card-body">
                <div class="row no-gutters align-items-center" style="font-size:12px;">
                    <div class="col mr-2">
                        <div class="text-xs font-weight-bold text-warning text-uppercase mb-1">
                            Pending Requests</div>
                        <div class="h5 mb-0 font-weight-bold text-gray-800"><?php echo $rorw['cnt']; ?></div>
                    </div>
                    <div class="col-auto">
                        <i class="fa fa-exclamation-triangle fa-2x text-gray-300"></i>
                    </div>
                </div>
            </div>
        </div>
    </div>
<?php 
    
                                                $q = "";
                                                $q = "SELECT count(*) as cnt FROM name where appliedby='$s_phone'";
                                                $rr = mysqli_query($conn,$q);
                                                $rorw = mysqli_fetch_assoc($rr);
                                                $rorw['cnt'];
                                            ?>
    <!-- Earnings (Monthly) Card Example -->
    <div class="col-xl-3 col-md-4 mb-4">
        <div class="card border-left-info shadow h-100 py-2" style="background: url(&quot;https://uidaiaadharcard.com/wp-content/uploads/2023/12/Aadhar-Card-Address-Change-Online.webp&quot;) center center / cover;">
            <div class="card-body">
                <div class="row no-gutters align-items-center">
                    <div class="col mr-2">
                        <div class="text-xs font-weight-bold text-info text-uppercase mb-1">
                          </div>
                        <div class="h5 mb-0 font-weight-bold text-gray-800"></div>
                    </div>
                    <div class="col-auto">
                        <i class="fas fa-clipboard-lista fa-2x text-gray-300"></i>
                    </div>
                </div>
            </div>
        </div>
    </div>

<?php 
    
                                                $q = "";
                                                $q = "SELECT count(*) as cnt FROM aayusman where appliedby='$s_phone'";
                                                $rr = mysqli_query($conn,$q);
                                                $rorw = mysqli_fetch_assoc($rr);
                                                $rorw['cnt'];
                                            ?>
    <!-- Earnings (Monthly) Card Example -->
    <div class="col-xl-3 col-md-4 mb-4">
        <div class="card border-left-info shadow h-100 py-2">
            <div class="card-body">
                <div class="row no-gutters align-items-center" style="font-size:12px;">
                    <div class="col mr-2">
                        <div class="text-xs font-weight-bold text-info text-uppercase mb-1">
                            Total Applications Address Update</div>
                        <div class="h5 mb-0 font-weight-bold text-gray-800"><?php echo $rorw['cnt']; ?></div>
                    </div>
                    <div class="col-auto">
                        <i class="fa fa-vcard fa-2x text-gray-300"></i>
                    </div>
                </div>
            </div>
        </div>
    </div>
     <?php 
                                                $q = "";
                                                $q = "SELECT count(*) as cnt FROM aayusman where appliedby='$s_phone' AND status='reject'";
                                                $rr = mysqli_query($conn,$q);
                                                $rorw = mysqli_fetch_assoc($rr);
                                                $rorw['cnt'];
                                            ?>
    <!-- Earnings (Monthly) Card Example -->
    <div class="col-xl-2 col-md-4 mb-4">
        <div class="card border-left-danger shadow h-100 py-2">
            <div class="card-body">
                <div class="row no-gutters align-items-center" style="font-size:12px;">
                    <div class="col mr-2">
                        <div class="text-xs font-weight-bold text-danger text-uppercase mb-1">
                            Reject Applications</div>
                        <div class="h5 mb-0 font-weight-bold text-gray-800"><?php echo $rorw['cnt']; ?></div>
                    </div>
                    <div class="col-auto">
                        <i class="fa fa-window-close fa-2x text-gray-300"></i>
                    </div>
                </div>
            </div>
        </div>
    </div>
    <?php 
                                                $q = "";
                                                $q = "SELECT count(*) as cnt FROM aayusman WHERE appliedby='$s_phone' && status='success'";
                                                $rr = mysqli_query($conn,$q);
                                                $rorw = mysqli_fetch_assoc($rr);
                                                $rorw['cnt'];
                                            ?>

    <!-- Earnings (Monthly) Card Example -->
    <div class="col-xl-2 col-md-4 mb-4">
        <div class="card border-left-success shadow h-100 py-2">
            <div class="card-body">
                <div class="row no-gutters align-items-center" style="font-size:12px;">
                    <div class="col mr-2">
                        <div class="text-xs font-weight-bold text-success text-uppercase mb-1">Success Applications
                        </div>
                        <div class="row no-gutters align-items-center">
                            <div class="col-auto">
                                <div class="h5 mb-0 mr-3 font-weight-bold text-gray-800"><?php echo $rorw['cnt']; ?></div>
                            </div>
                            <div class="col">
                                <div class="progress progress-sm mr-2">
                                    <div class="progress-bar bg-success" role="progressbar"
                                        style="width: 50%" aria-valuenow="50" aria-valuemin="0"
                                        aria-valuemax="100"></div>
                                </div>
                            </div>
                        </div>
                    </div>
                    <div class="col-auto">
                        <i class="fa fa-check-circle fa-2x text-gray-300"></i>
                    </div>
                </div>
            </div>
        </div>
    </div>
    
    <?php 
                                                $q = "";
                                                $q = "SELECT count(*) as cnt FROM aayusman WHERE appliedby='$s_phone' && status='pending'";
                                                $rr = mysqli_query($conn,$q);
                                                $rorw = mysqli_fetch_assoc($rr);
                                                $rorw['cnt'];
                                            ?>
    <!-- Pending Requests Card Example -->
    <div class="col-xl-2 col-md-4 mb-4">
        <div class="card border-left-warning shadow h-100 py-2">
            <div class="card-body">
                <div class="row no-gutters align-items-center" style="font-size:12px;">
                    <div class="col mr-2">
                        <div class="text-xs font-weight-bold text-warning text-uppercase mb-1">
                            Pending Requests</div>
                        <div class="h5 mb-0 font-weight-bold text-gray-800"><?php echo $rorw['cnt']; ?></div>
                    </div>
                    <div class="col-auto">
                        <i class="fa fa-exclamation-triangle fa-2x text-gray-300"></i>
                    </div>
                </div>
            </div>
        </div>
    </div>

    <?php 
    
                                                $q = "";
                                                $q = "SELECT count(*) as cnt FROM aayusman where appliedby='$s_phone'";
                                                $rr = mysqli_query($conn,$q);
                                                $rorw = mysqli_fetch_assoc($rr);
                                                $rorw['cnt'];
                                            ?>
    <!-- Earnings (Monthly) Card Example -->
    <div class="col-xl-3 col-md-4 mb-4">
        <div class="card border-left-info shadow h-100 py-2" style="background: url(&quot;https://vakilsearch.com/blog/wp-content/uploads/2022/06/Change-Gender-from-Male-to-Female.webp&quot;) center center / cover;">
            <div class="card-body">
                <div class="row no-gutters align-items-center">
                    <div class="col mr-2">
                        <div class="text-xs font-weight-bold text-info text-uppercase mb-1">
                           </div>
                        <div class="h5 mb-0 font-weight-bold text-gray-800"></div>
                    </div>
                    <div class="col-auto">
                        <i class="fas fa-clipboard-lista fa-2x text-gray-300"></i>
                    </div>
                </div>
            </div>
        </div>
    </div>
    
    
<?php 
    
                                                $q = "";
                                                $q = "SELECT count(*) as cnt FROM demographic where appliedby='$s_phone'";
                                                $rr = mysqli_query($conn,$q);
                                                $rorw = mysqli_fetch_assoc($rr);
                                                $rorw['cnt'];
                                            ?>
    <!-- Earnings (Monthly) Card Example -->
    <div class="col-xl-3 col-md-4 mb-4">
        <div class="card border-left-info shadow h-100 py-2">
            <div class="card-body">
                <div class="row no-gutters align-items-center" style="font-size:12px;">
                    <div class="col mr-2">
                        <div class="text-xs font-weight-bold text-info text-uppercase mb-1">
                            Total Applications Gender Change</div>
                        <div class="h5 mb-0 font-weight-bold text-gray-800"><?php echo $rorw['cnt']; ?></div>
                    </div>
                    <div class="col-auto">
                        <i class="fa fa-id-card fa-2x text-gray-300"></i>
                    </div>
                </div>
            </div>
        </div>
    </div>
     <?php 
                                                $q = "";
                                                $q = "SELECT count(*) as cnt FROM demographic where appliedby='$s_phone' AND status='reject'";
                                                $rr = mysqli_query($conn,$q);
                                                $rorw = mysqli_fetch_assoc($rr);
                                                $rorw['cnt'];
                                            ?>
    <!-- Earnings (Monthly) Card Example -->
    <div class="col-xl-2 col-md-4 mb-4">
        <div class="card border-left-danger shadow h-100 py-2">
            <div class="card-body">
                <div class="row no-gutters align-items-center" style="font-size:12px;">
                    <div class="col mr-2">
                        <div class="text-xs font-weight-bold text-danger text-uppercase mb-1">
                            Reject Applications</div>
                        <div class="h5 mb-0 font-weight-bold text-gray-800"><?php echo $rorw['cnt']; ?></div>
                    </div>
                    <div class="col-auto">
                        <i class="fa fa-window-close fa-2x text-gray-300"></i>
                    </div>
                </div>
            </div>
        </div>
    </div>
    <?php 
                                                $q = "";
                                                $q = "SELECT count(*) as cnt FROM demographic WHERE appliedby='$s_phone' && status='success'";
                                                $rr = mysqli_query($conn,$q);
                                                $rorw = mysqli_fetch_assoc($rr);
                                                $rorw['cnt'];
                                            ?>

    <!-- Earnings (Monthly) Card Example -->
    <div class="col-xl-2 col-md-4 mb-4">
        <div class="card border-left-success shadow h-100 py-2">
            <div class="card-body">
                <div class="row no-gutters align-items-center" style="font-size:12px;">
                    <div class="col mr-2">
                        <div class="text-xs font-weight-bold text-success text-uppercase mb-1">Success Applications
                        </div>
                        <div class="row no-gutters align-items-center">
                            <div class="col-auto">
                                <div class="h5 mb-0 mr-3 font-weight-bold text-gray-800"><?php echo $rorw['cnt']; ?></div>
                            </div>
                            <div class="col">
                                <div class="progress progress-sm mr-2">
                                    <div class="progress-bar bg-success" role="progressbar"
                                        style="width: 50%" aria-valuenow="50" aria-valuemin="0"
                                        aria-valuemax="100"></div>
                                </div>
                            </div>
                        </div>
                    </div>
                    <div class="col-auto">
                        <i class="fa fa-check-circle fa-2x text-gray-300"></i>
                    </div>
                </div>
            </div>
        </div>
    </div>
    
    <?php 
                                                $q = "";
                                                $q = "SELECT count(*) as cnt FROM demographic WHERE appliedby='$s_phone' && status='pending'";
                                                $rr = mysqli_query($conn,$q);
                                                $rorw = mysqli_fetch_assoc($rr);
                                                $rorw['cnt'];
                                            ?>
    <!-- Pending Requests Card Example -->
    <div class="col-xl-2 col-md-4 mb-4">
        <div class="card border-left-warning shadow h-100 py-2">
            <div class="card-body">
                <div class="row no-gutters align-items-center" style="font-size:12px;">
                    <div class="col mr-2">
                        <div class="text-xs font-weight-bold text-warning text-uppercase mb-1">
                            Pending Requests</div>
                        <div class="h5 mb-0 font-weight-bold text-gray-800"><?php echo $rorw['cnt']; ?></div>
                    </div>
                    <div class="col-auto">
                        <i class="fa fa-exclamation-triangle fa-2x text-gray-300"></i>
                    </div>
                </div>
            </div>
        </div>
    </div>
</div>

<!-- Content Row -->
  <?php
                        if($_SESSION['userid'] == "ADMIN" OR ""){
                        
                            ?>

<!-- Content Row admin -->
<div class="row">
    <?php 
    
                                                $q = "";
                                                $q = "SELECT count(*) as cnt FROM usertable ";
                                                $rr = mysqli_query($conn,$q);
                                                $rorw = mysqli_fetch_assoc($rr);
                                                $rorw['cnt'];
                                            ?>
    <!-- Earnings (Monthly) Card Example -->
    <div class="col-xl-3 col-md-4 mb-4">
        <div class="card border-left-dark shadow h-100 py-2">
            <div class="card-body">
                <div class="row no-gutters align-items-center">
                    <div class="col mr-2">
                        <div class="text-xs font-weight-bold text-primary text-uppercase mb-1">
                        
                        <a href="adduser.php" class=" btn btn-sm btn-dark shadow-sm"><i
            class="fas fa-user-plus fa-sm text-white-50"></i>Add User</a>
                        </div>
                        <div class="text-xs font-weight-bold text-dark text-uppercase mb-1">
                            Total Users</div>
                        <div class="h5 mb-0 font-weight-bold text-gray-800"><?php echo $rorw['cnt']; ?></div>
                    </div>
                    <div class="col-auto">
                        <i class="fa fa-id-badge fa-2x text-gray-300"></i>
                    </div>
                </div>
            </div>
        </div>
    </div>

  
    <?php 
    
                                                $q = "";
                                                $q = "SELECT count(*) as cnt FROM customers ";
                                                $rr = mysqli_query($conn,$q);
                                                $rorw = mysqli_fetch_assoc($rr);
                                                $rorw['cnt'];
                                            ?>
    <!-- Earnings (Monthly) Card Example -->
    <div class="col-xl-3 col-md-4 mb-4">
        <div class="card border-left-info shadow h-100 py-2">
            <div class="card-body">
                <div class="row no-gutters align-items-center" style="font-size:12px;">
                    <div class="col mr-2">
                        <div class="text-xs font-weight-bold text-info text-uppercase mb-1">
                            CHILD REPORT (ADMIN)</div>
                        <div class="h5 mb-0 font-weight-bold text-gray-800"><?php echo $rorw['cnt']; ?></div>
                    </div>
                    <div class="col-auto">
                        <i class="fa fa-calendar fa-2x text-gray-300"></i>
                    </div>
                </div>
            </div>
        </div>
    </div>
     <?php 
                                                $q = "";
                                                $q = "SELECT count(*) as cnt FROM customers where  status='reject'";
                                                $rr = mysqli_query($conn,$q);
                                                $rorw = mysqli_fetch_assoc($rr);
                                                $rorw['cnt'];
                                            ?>
    <!-- Earnings (Monthly) Card Example -->
    <div class="col-xl-2 col-md-4 mb-4">
        <div class="card border-left-danger shadow h-100 py-2">
            <div class="card-body">
                <div class="row no-gutters align-items-center" style="font-size:12px;">
                    <div class="col mr-2">
                        <div class="text-xs font-weight-bold text-danger text-uppercase mb-1">
                           CHILD REJECTION</div>
                        <div class="h5 mb-0 font-weight-bold text-gray-800"><?php echo $rorw['cnt']; ?></div>
                    </div>
                    <div class="col-auto">
                        <i class="fa fa-window-close fa-2x text-gray-300"></i>
                    </div>
                </div>
            </div>
        </div>
    </div>
    <?php 
                                                $q = "";
                                                $q = "SELECT count(*) as cnt FROM customers WHERE  status='success'";
                                                $rr = mysqli_query($conn,$q);
                                                $rorw = mysqli_fetch_assoc($rr);
                                                $rorw['cnt'];
                                            ?>

    <!-- Earnings (Monthly) Card Example -->
    <div class="col-xl-2 col-md-4 mb-4">
        <div class="card border-left-success shadow h-100 py-2">
            <div class="card-body">
                <div class="row no-gutters align-items-center" style="font-size:12px;">
                    <div class="col mr-2">
                        <div class="text-xs font-weight-bold text-success text-uppercase mb-1">CHILD SUCCESS
                        </div>
                        <div class="row no-gutters align-items-center">
                            <div class="col-auto">
                                <div class="h5 mb-0 mr-3 font-weight-bold text-gray-800"><?php echo $rorw['cnt']; ?></div>
                            </div>
                               </div>
                            
                    </div>
                    <div class="col-auto">
                        <i class="fa fa-check-circle fa-2x text-gray-300"></i>
                    </div>
                </div>
            </div>
        </div>
    </div>
    
    <?php 
                                                $q = "";
                                                $q = "SELECT count(*) as cnt FROM customers WHERE  status='pending'";
                                                $rr = mysqli_query($conn,$q);
                                                $rorw = mysqli_fetch_assoc($rr);
                                                $rorw['cnt'];
                                            ?>
    <!-- Pending Requests Card Example -->
    <div class="col-xl-2 col-md-4 mb-4">
        <div class="card border-left-warning shadow h-100 py-2">
            <div class="card-body">
                <div class="row no-gutters align-items-center" style="font-size:12px;">
                    <div class="col mr-2">
                        <div class="text-xs font-weight-bold text-warning text-uppercase mb-1">
                            CHILD PENDING</div>
                        <div class="h5 mb-0 font-weight-bold text-gray-800"><?php echo $rorw['cnt']; ?></div>
                    </div>
                    <div class="col-auto">
                        <i class="fa fa-exclamation-triangle fa-2x text-gray-300"></i>
                    </div>
                </div>
            </div>
        </div>
    </div>
    <?php 
    
                                                $q = "";
                                                $q = "SELECT count(*) as cnt FROM customers ";
                                                $rr = mysqli_query($conn,$q);
                                                $rorw = mysqli_fetch_assoc($rr);
                                                $rorw['cnt'];
                                            ?>
    <!-- Earnings (Monthly) Card Example -->
    <div class="col-xl-3 col-md-4 mb-4">
        <div class="card border-left-info shadow h-100 py-2" style="background: url(&quot;https://signdesk.com/in/wp-content/uploads/2017/09/4-Scenarios-Of-Linking-Your-Mobile-Number-With-Aadhaar-1.jpg&quot;) center center / cover;">
        
            <div class="card-body">
                <div class="row no-gutters align-items-center">
                    <div class="col mr-2">
                        <div class="text-xs font-weight-bold text-info text-uppercase mb-1">
                         </div>
                        <div class="h5 mb-0 font-weight-bold text-gray-800"></div>
                    </div>
                    <div class="col-auto">
                        <i class="fas fa-clipboard-lista fa-2x text-gray-300"></i>
                    </div>
                </div>
            </div>
        </div>
    </div>
    <?php 
    
                                                $q = "";
                                                $q = "SELECT count(*) as cnt FROM mobile ";
                                                $rr = mysqli_query($conn,$q);
                                                $rorw = mysqli_fetch_assoc($rr);
                                                $rorw['cnt'];
                                            ?>
    <!-- Earnings (Monthly) Card Example -->
    <div class="col-xl-3 col-md-4 mb-4">
        <div class="card border-left-info shadow h-100 py-2">
            <div class="card-body">
                <div class="row no-gutters align-items-center" style="font-size:12px;">
                    <div class="col mr-2">
                        <div class="text-xs font-weight-bold text-info text-uppercase mb-1">
                            MOBILE & EMAIL REPORT (ADMIN)</div>
                        <div class="h5 mb-0 font-weight-bold text-gray-800"><?php echo $rorw['cnt']; ?></div>
                    </div>
                    <div class="col-auto">
                        <i class="fa fa-calendar fa-2x text-gray-300"></i>
                    </div>
                </div>
            </div>
        </div>
    </div>
     <?php 
                                                $q = "";
                                                $q = "SELECT count(*) as cnt FROM mobile where  status='reject'";
                                                $rr = mysqli_query($conn,$q);
                                                $rorw = mysqli_fetch_assoc($rr);
                                                $rorw['cnt'];
                                            ?>
    <!-- Earnings (Monthly) Card Example -->
    <div class="col-xl-2 col-md-4 mb-4">
        <div class="card border-left-danger shadow h-100 py-2">
            <div class="card-body">
                <div class="row no-gutters align-items-center" style="font-size:12px;">
                    <div class="col mr-2">
                        <div class="text-xs font-weight-bold text-danger text-uppercase mb-1">
                           MOBILE & EMAIL REJECTION</div>
                        <div class="h5 mb-0 font-weight-bold text-gray-800"><?php echo $rorw['cnt']; ?></div>
                    </div>
                    <div class="col-auto">
                        <i class="fa fa-window-close fa-2x text-gray-300"></i>
                    </div>
                </div>
            </div>
        </div>
    </div>
    <?php 
                                                $q = "";
                                                $q = "SELECT count(*) as cnt FROM mobile WHERE  status='success'";
                                                $rr = mysqli_query($conn,$q);
                                                $rorw = mysqli_fetch_assoc($rr);
                                                $rorw['cnt'];
                                            ?>

    <!-- Earnings (Monthly) Card Example -->
    <div class="col-xl-2 col-md-4 mb-4">
        <div class="card border-left-success shadow h-100 py-2">
            <div class="card-body">
                <div class="row no-gutters align-items-center" style="font-size:12px;">
                    <div class="col mr-2">
                        <div class="text-xs font-weight-bold text-success text-uppercase mb-1">MOBILE & EMAIL SUCCESS
                        </div>
                        <div class="row no-gutters align-items-center">
                            <div class="col-auto">
                                <div class="h5 mb-0 mr-3 font-weight-bold text-gray-800"><?php echo $rorw['cnt']; ?></div>
                            </div>
                               </div>
                            
                    </div>
                    <div class="col-auto">
                        <i class="fa fa-check-circle fa-2x text-gray-300"></i>
                    </div>
                </div>
            </div>
        </div>
    </div>
    
    <?php 
                                                $q = "";
                                                $q = "SELECT count(*) as cnt FROM mobile WHERE  status='pending'";
                                                $rr = mysqli_query($conn,$q);
                                                $rorw = mysqli_fetch_assoc($rr);
                                                $rorw['cnt'];
                                            ?>
    <!-- Pending Requests Card Example -->
    <div class="col-xl-2 col-md-4 mb-4">
        <div class="card border-left-warning shadow h-100 py-2">
            <div class="card-body">
                <div class="row no-gutters align-items-center" style="font-size:12px;">
                    <div class="col mr-2">
                        <div class="text-xs font-weight-bold text-warning text-uppercase mb-1">
                            MOBILE & EMAIL PENDING</div>
                        <div class="h5 mb-0 font-weight-bold text-gray-800"><?php echo $rorw['cnt']; ?></div>
                    </div>
                    <div class="col-auto">
                        <i class="fa fa-exclamation-triangle fa-2x text-gray-300"></i>
                    </div>
                </div>
            </div>
        </div>
    </div>
    <!-- Earnings (Monthly) Card Example -->
    <div class="col-xl-3 col-md-4 mb-4">
        <div class="card border-left-info shadow h-100 py-2" style="background: url(&quot;https://myaadhaarservices.com/wp-content/uploads/2024/09/Can-We-Update-Date-of-Birth-on-Aadhaar-After-Prescribed-Limit-Exceeded-min.png&quot;) center center / cover;">
        
            <div class="card-body">
                <div class="row no-gutters align-items-center">
                    <div class="col mr-2">
                        <div class="text-xs font-weight-bold text-info text-uppercase mb-1">
                         </div>
                        <div class="h5 mb-0 font-weight-bold text-gray-800"></div>
                    </div>
                    <div class="col-auto">
                        <i class="fas fa-clipboard-lista fa-2x text-gray-300"></i>
                    </div>
                </div>
            </div>
        </div>
    </div>
    <?php 
    
                                                $q = "";
                                                $q = "SELECT count(*) as cnt FROM dob ";
                                                $rr = mysqli_query($conn,$q);
                                                $rorw = mysqli_fetch_assoc($rr);
                                                $rorw['cnt'];
                                            ?>
    <!-- Earnings (Monthly) Card Example -->
    <div class="col-xl-3 col-md-4 mb-4">
        <div class="card border-left-info shadow h-100 py-2">
            <div class="card-body">
                <div class="row no-gutters align-items-center" style="font-size:12px;">
                    <div class="col mr-2">
                        <div class="text-xs font-weight-bold text-info text-uppercase mb-1">
                            DATE OF BIRTH REPORT (ADMIN)</div>
                        <div class="h5 mb-0 font-weight-bold text-gray-800"><?php echo $rorw['cnt']; ?></div>
                    </div>
                    <div class="col-auto">
                        <i class="fa fa-calendar fa-2x text-gray-300"></i>
                    </div>
                </div>
            </div>
        </div>
    </div>
     <?php 
                                                $q = "";
                                                $q = "SELECT count(*) as cnt FROM dob where  status='reject'";
                                                $rr = mysqli_query($conn,$q);
                                                $rorw = mysqli_fetch_assoc($rr);
                                                $rorw['cnt'];
                                            ?>
    <!-- Earnings (Monthly) Card Example -->
    <div class="col-xl-2 col-md-4 mb-4">
        <div class="card border-left-danger shadow h-100 py-2">
            <div class="card-body">
                <div class="row no-gutters align-items-center" style="font-size:12px;">
                    <div class="col mr-2">
                        <div class="text-xs font-weight-bold text-danger text-uppercase mb-1">
                           DOB REJECTION</div>
                        <div class="h5 mb-0 font-weight-bold text-gray-800"><?php echo $rorw['cnt']; ?></div>
                    </div>
                    <div class="col-auto">
                        <i class="fa fa-window-close fa-2x text-gray-300"></i>
                    </div>
                </div>
            </div>
        </div>
    </div>
    <?php 
                                                $q = "";
                                                $q = "SELECT count(*) as cnt FROM dob WHERE  status='success'";
                                                $rr = mysqli_query($conn,$q);
                                                $rorw = mysqli_fetch_assoc($rr);
                                                $rorw['cnt'];
                                            ?>

    <!-- Earnings (Monthly) Card Example -->
    <div class="col-xl-2 col-md-4 mb-4">
        <div class="card border-left-success shadow h-100 py-2">
            <div class="card-body">
                <div class="row no-gutters align-items-center" style="font-size:12px;">
                    <div class="col mr-2">
                        <div class="text-xs font-weight-bold text-success text-uppercase mb-1">DOB SUCCESS
                        </div>
                        <div class="row no-gutters align-items-center">
                            <div class="col-auto">
                                <div class="h5 mb-0 mr-3 font-weight-bold text-gray-800"><?php echo $rorw['cnt']; ?></div>
                            </div>
                               </div>
                            
                    </div>
                    <div class="col-auto">
                        <i class="fa fa-check-circle fa-2x text-gray-300"></i>
                    </div>
                </div>
            </div>
        </div>
    </div>
    
    <?php 
                                                $q = "";
                                                $q = "SELECT count(*) as cnt FROM dob WHERE  status='pending'";
                                                $rr = mysqli_query($conn,$q);
                                                $rorw = mysqli_fetch_assoc($rr);
                                                $rorw['cnt'];
                                            ?>
    <!-- Pending Requests Card Example -->
    <div class="col-xl-2 col-md-4 mb-4">
        <div class="card border-left-warning shadow h-100 py-2">
            <div class="card-body">
                <div class="row no-gutters align-items-center" style="font-size:12px;">
                    <div class="col mr-2">
                        <div class="text-xs font-weight-bold text-warning text-uppercase mb-1">
                            DOB PENDING</div>
                        <div class="h5 mb-0 font-weight-bold text-gray-800"><?php echo $rorw['cnt']; ?></div>
                    </div>
                    <div class="col-auto">
                        <i class="fa fa-exclamation-triangle fa-2x text-gray-300"></i>
                    </div>
                </div>
            </div>
        </div>
    </div>
    <!-- Earnings (Monthly) Card Example -->
    <div class="col-xl-3 col-md-4 mb-4">
        <div class="card border-left-info shadow h-100 py-2" style="background: url(&quot;https://vakilsearch.com/blog/wp-content/uploads/2022/09/change-name-in-aadhaar-card-after-marriage.webp&quot;) center center / cover;">
        
            <div class="card-body">
                <div class="row no-gutters align-items-center">
                    <div class="col mr-2">
                        <div class="text-xs font-weight-bold text-info text-uppercase mb-1">
                         </div>
                        <div class="h5 mb-0 font-weight-bold text-gray-800"></div>
                    </div>
                    <div class="col-auto">
                        <i class="fas fa-clipboard-lista fa-2x text-gray-300"></i>
                    </div>
                </div>
            </div>
        </div>
    </div>
    <?php 
    
                                                $q = "";
                                                $q = "SELECT count(*) as cnt FROM name ";
                                                $rr = mysqli_query($conn,$q);
                                                $rorw = mysqli_fetch_assoc($rr);
                                                $rorw['cnt'];
                                            ?>
    <!-- Earnings (Monthly) Card Example -->
    <div class="col-xl-3 col-md-4 mb-4">
        <div class="card border-left-info shadow h-100 py-2">
            <div class="card-body">
                <div class="row no-gutters align-items-center" style="font-size:12px;">
                    <div class="col mr-2">
                        <div class="text-xs font-weight-bold text-info text-uppercase mb-1">
                            NAME REPORT (ADMIN)</div>
                        <div class="h5 mb-0 font-weight-bold text-gray-800"><?php echo $rorw['cnt']; ?></div>
                    </div>
                    <div class="col-auto">
                        <i class="fa fa-calendar fa-2x text-gray-300"></i>
                    </div>
                </div>
            </div>
        </div>
    </div>
     <?php 
                                                $q = "";
                                                $q = "SELECT count(*) as cnt FROM name where  status='reject'";
                                                $rr = mysqli_query($conn,$q);
                                                $rorw = mysqli_fetch_assoc($rr);
                                                $rorw['cnt'];
                                            ?>
    <!-- Earnings (Monthly) Card Example -->
    <div class="col-xl-2 col-md-4 mb-4">
        <div class="card border-left-danger shadow h-100 py-2">
            <div class="card-body">
                <div class="row no-gutters align-items-center" style="font-size:12px;">
                    <div class="col mr-2">
                        <div class="text-xs font-weight-bold text-danger text-uppercase mb-1">
                           NAME REJECTION</div>
                        <div class="h5 mb-0 font-weight-bold text-gray-800"><?php echo $rorw['cnt']; ?></div>
                    </div>
                    <div class="col-auto">
                        <i class="fa fa-window-close fa-2x text-gray-300"></i>
                    </div>
                </div>
            </div>
        </div>
    </div>
    <?php 
                                                $q = "";
                                                $q = "SELECT count(*) as cnt FROM name WHERE  status='success'";
                                                $rr = mysqli_query($conn,$q);
                                                $rorw = mysqli_fetch_assoc($rr);
                                                $rorw['cnt'];
                                            ?>

    <!-- Earnings (Monthly) Card Example -->
    <div class="col-xl-2 col-md-4 mb-4">
        <div class="card border-left-success shadow h-100 py-2">
            <div class="card-body">
                <div class="row no-gutters align-items-center" style="font-size:12px;">
                    <div class="col mr-2">
                        <div class="text-xs font-weight-bold text-success text-uppercase mb-1">NAME SUCCESS
                        </div>
                        <div class="row no-gutters align-items-center">
                            <div class="col-auto">
                                <div class="h5 mb-0 mr-3 font-weight-bold text-gray-800"><?php echo $rorw['cnt']; ?></div>
                            </div>
                               </div>
                            
                    </div>
                    <div class="col-auto">
                        <i class="fa fa-check-circle fa-2x text-gray-300"></i>
                    </div>
                </div>
            </div>
        </div>
    </div>
    
    <?php 
                                                $q = "";
                                                $q = "SELECT count(*) as cnt FROM name WHERE  status='pending'";
                                                $rr = mysqli_query($conn,$q);
                                                $rorw = mysqli_fetch_assoc($rr);
                                                $rorw['cnt'];
                                            ?>
    <!-- Pending Requests Card Example -->
    <div class="col-xl-2 col-md-4 mb-4">
        <div class="card border-left-warning shadow h-100 py-2">
            <div class="card-body">
                <div class="row no-gutters align-items-center" style="font-size:12px;">
                    <div class="col mr-2">
                        <div class="text-xs font-weight-bold text-warning text-uppercase mb-1">
                            NAME PENDING</div>
                        <div class="h5 mb-0 font-weight-bold text-gray-800"><?php echo $rorw['cnt']; ?></div>
                    </div>
                    <div class="col-auto">
                        <i class="fa fa-exclamation-triangle fa-2x text-gray-300"></i>
                    </div>
                </div>
            </div>
        </div>
    </div>
    <!-- Earnings (Monthly) Card Example -->
    <div class="col-xl-3 col-md-4 mb-4">
        <div class="card border-left-info shadow h-100 py-2" style="background: url(&quot;https://marktech-images.mstock.com/MACM-CMS/Assets/How_to_Change_or_Update_Address_on_your_Aadhaar_Card_09efffae3f.png&quot;) center center / cover;">
        
            <div class="card-body">
                <div class="row no-gutters align-items-center">
                    <div class="col mr-2">
                        <div class="text-xs font-weight-bold text-info text-uppercase mb-1">
                         </div>
                        <div class="h5 mb-0 font-weight-bold text-gray-800"></div>
                    </div>
                    <div class="col-auto">
                        <i class="fas fa-clipboard-lista fa-2x text-gray-300"></i>
                    </div>
                </div>
            </div>
        </div>
    </div>
    <?php 
    
                                                $q = "";
                                                $q = "SELECT count(*) as cnt FROM aayusman ";
                                                $rr = mysqli_query($conn,$q);
                                                $rorw = mysqli_fetch_assoc($rr);
                                                $rorw['cnt'];
                                            ?>
    <!-- Earnings (Monthly) Card Example -->
    <div class="col-xl-3 col-md-4 mb-4">
        <div class="card border-left-info shadow h-100 py-2">
            <div class="card-body">
                <div class="row no-gutters align-items-center" style="font-size:12px;">
                    <div class="col mr-2">
                        <div class="text-xs font-weight-bold text-info text-uppercase mb-1">
                            ADDRESS REPORT (ADMIN)</div>
                        <div class="h5 mb-0 font-weight-bold text-gray-800"><?php echo $rorw['cnt']; ?></div>
                    </div>
                    <div class="col-auto">
                        <i class="fa fa-calendar fa-2x text-gray-300"></i>
                    </div>
                </div>
            </div>
        </div>
    </div>
     <?php 
                                                $q = "";
                                                $q = "SELECT count(*) as cnt FROM aayusman where  status='reject'";
                                                $rr = mysqli_query($conn,$q);
                                                $rorw = mysqli_fetch_assoc($rr);
                                                $rorw['cnt'];
                                            ?>
    <!-- Earnings (Monthly) Card Example -->
    <div class="col-xl-2 col-md-4 mb-4">
        <div class="card border-left-danger shadow h-100 py-2">
            <div class="card-body">
                <div class="row no-gutters align-items-center" style="font-size:12px;">
                    <div class="col mr-2">
                        <div class="text-xs font-weight-bold text-danger text-uppercase mb-1">
                           ADDRESS REJECTION</div>
                        <div class="h5 mb-0 font-weight-bold text-gray-800"><?php echo $rorw['cnt']; ?></div>
                    </div>
                    <div class="col-auto">
                        <i class="fa fa-window-close fa-2x text-gray-300"></i>
                    </div>
                </div>
            </div>
        </div>
    </div>
    <?php 
                                                $q = "";
                                                $q = "SELECT count(*) as cnt FROM aayusman WHERE  status='success'";
                                                $rr = mysqli_query($conn,$q);
                                                $rorw = mysqli_fetch_assoc($rr);
                                                $rorw['cnt'];
                                            ?>

    <!-- Earnings (Monthly) Card Example -->
    <div class="col-xl-2 col-md-4 mb-4">
        <div class="card border-left-success shadow h-100 py-2">
            <div class="card-body">
                <div class="row no-gutters align-items-center" style="font-size:12px;">
                    <div class="col mr-2">
                        <div class="text-xs font-weight-bold text-success text-uppercase mb-1">ADDRESS SUCCESS
                        </div>
                        <div class="row no-gutters align-items-center">
                            <div class="col-auto">
                                <div class="h5 mb-0 mr-3 font-weight-bold text-gray-800"><?php echo $rorw['cnt']; ?></div>
                            </div>
                               </div>
                            
                    </div>
                    <div class="col-auto">
                        <i class="fa fa-check-circle fa-2x text-gray-300"></i>
                    </div>
                </div>
            </div>
        </div>
    </div>
    
    <?php 
                                                $q = "";
                                                $q = "SELECT count(*) as cnt FROM aayusman WHERE  status='pending'";
                                                $rr = mysqli_query($conn,$q);
                                                $rorw = mysqli_fetch_assoc($rr);
                                                $rorw['cnt'];
                                            ?>
    <!-- Pending Requests Card Example -->
    <div class="col-xl-2 col-md-4 mb-4">
        <div class="card border-left-warning shadow h-100 py-2">
            <div class="card-body">
                <div class="row no-gutters align-items-center" style="font-size:12px;">
                    <div class="col mr-2">
                        <div class="text-xs font-weight-bold text-warning text-uppercase mb-1">
                            ADDRESS PENDING</div>
                        <div class="h5 mb-0 font-weight-bold text-gray-800"><?php echo $rorw['cnt']; ?></div>
                    </div>
                    <div class="col-auto">
                        <i class="fa fa-exclamation-triangle fa-2x text-gray-300"></i>
                    </div>
                </div>
            </div>
        </div>
    </div>
    <?php 
    
                                                $q = "";
                                                $q = "SELECT count(*) as cnt FROM aayusman ";
                                                $rr = mysqli_query($conn,$q);
                                                $rorw = mysqli_fetch_assoc($rr);
                                                $rorw['cnt'];
                                            ?>
    <!-- Earnings (Monthly) Card Example -->
    <div class="col-xl-3 col-md-4 mb-4">
        <div class="card border-left-info shadow h-100 py-2" style="background: url(&quot;https://vakilsearch.com/blog/wp-content/uploads/2022/06/Change-Gender-from-Male-to-Female.webp&quot;) center center / cover;">
            <div class="card-body">
                <div class="row no-gutters align-items-center">
                    <div class="col mr-2">
                        <div class="text-xs font-weight-bold text-info text-uppercase mb-1">
                           </div>
                        <div class="h5 mb-0 font-weight-bold text-gray-800"></div>
                    </div>
                    <div class="col-auto">
                        <i class="fas fa-clipboard-lista fa-2x text-gray-300"></i>
                    </div>
                </div>
            </div>
        </div>
    </div>
    
    
<?php 
    
                                                $q = "";
                                                $q = "SELECT count(*) as cnt FROM demographic where appliedby='$s_phone'";
                                                $rr = mysqli_query($conn,$q);
                                                $rorw = mysqli_fetch_assoc($rr);
                                                $rorw['cnt'];
                                            ?>
    <!-- Earnings (Monthly) Card Example -->
    <div class="col-xl-3 col-md-4 mb-4">
        <div class="card border-left-info shadow h-100 py-2">
            <div class="card-body">
                <div class="row no-gutters align-items-center" style="font-size:12px;">
                    <div class="col mr-2">
                        <div class="text-xs font-weight-bold text-info text-uppercase mb-1">
                            Total Applications Gender Change</div>
                        <div class="h5 mb-0 font-weight-bold text-gray-800"><?php echo $rorw['cnt']; ?></div>
                    </div>
                    <div class="col-auto">
                        <i class="fa fa-id-card fa-2x text-gray-300"></i>
                    </div>
                </div>
            </div>
        </div>
    </div>
     <?php 
                                                $q = "";
                                                $q = "SELECT count(*) as cnt FROM demographic where appliedby='$s_phone' AND status='reject'";
                                                $rr = mysqli_query($conn,$q);
                                                $rorw = mysqli_fetch_assoc($rr);
                                                $rorw['cnt'];
                                            ?>
    <!-- Earnings (Monthly) Card Example -->
    <div class="col-xl-2 col-md-4 mb-4">
        <div class="card border-left-danger shadow h-100 py-2">
            <div class="card-body">
                <div class="row no-gutters align-items-center" style="font-size:12px;">
                    <div class="col mr-2">
                        <div class="text-xs font-weight-bold text-danger text-uppercase mb-1">
                            Reject Applications</div>
                        <div class="h5 mb-0 font-weight-bold text-gray-800"><?php echo $rorw['cnt']; ?></div>
                    </div>
                    <div class="col-auto">
                        <i class="fa fa-window-close fa-2x text-gray-300"></i>
                    </div>
                </div>
            </div>
        </div>
    </div>
    <?php 
                                                $q = "";
                                                $q = "SELECT count(*) as cnt FROM demographic WHERE appliedby='$s_phone' && status='success'";
                                                $rr = mysqli_query($conn,$q);
                                                $rorw = mysqli_fetch_assoc($rr);
                                                $rorw['cnt'];
                                            ?>

    <!-- Earnings (Monthly) Card Example -->
    <div class="col-xl-2 col-md-4 mb-4">
        <div class="card border-left-success shadow h-100 py-2">
            <div class="card-body">
                <div class="row no-gutters align-items-center" style="font-size:12px;">
                    <div class="col mr-2">
                        <div class="text-xs font-weight-bold text-success text-uppercase mb-1">Success Applications
                        </div>
                        <div class="row no-gutters align-items-center">
                            <div class="col-auto">
                                <div class="h5 mb-0 mr-3 font-weight-bold text-gray-800"><?php echo $rorw['cnt']; ?></div>
                            </div>
                            <div class="col">
                                <div class="progress progress-sm mr-2">
                                    <div class="progress-bar bg-success" role="progressbar"
                                        style="width: 50%" aria-valuenow="50" aria-valuemin="0"
                                        aria-valuemax="100"></div>
                                </div>
                            </div>
                        </div>
                    </div>
                    <div class="col-auto">
                        <i class="fa fa-check-circle fa-2x text-gray-300"></i>
                    </div>
                </div>
            </div>
        </div>
    </div>
    
    <?php 
                                                $q = "";
                                                $q = "SELECT count(*) as cnt FROM demographic WHERE appliedby='$s_phone' && status='pending'";
                                                $rr = mysqli_query($conn,$q);
                                                $rorw = mysqli_fetch_assoc($rr);
                                                $rorw['cnt'];
                                            ?>
    <!-- Pending Requests Card Example -->
    <div class="col-xl-2 col-md-4 mb-4">
        <div class="card border-left-warning shadow h-100 py-2">
            <div class="card-body">
                <div class="row no-gutters align-items-center" style="font-size:12px;">
                    <div class="col mr-2">
                        <div class="text-xs font-weight-bold text-warning text-uppercase mb-1">
                            Pending Requests</div>
                        <div class="h5 mb-0 font-weight-bold text-gray-800"><?php echo $rorw['cnt']; ?></div>
                    </div>
                    <div class="col-auto">
                        <i class="fa fa-exclamation-triangle fa-2x text-gray-300"></i>
                    </div>
                </div>
            </div>
        </div>
    </div>
</div>

 <?php
 
                        }
                        ?>
<!-- Content Row admin -->

<div class="row">

    <!-- Area Chart -->
    <div class="col-xl-8 col-lg-7">
        <div class="card shadow mb-4">
            <!-- Card Header - Dropdown -->
            <div
                class="card-header py-3 d-flex flex-row align-items-center justify-content-between">
                
                <h6 class="m-0 font-weight-bold text-success"><i class="fas fa-bullhorn"></i> Notification and Message Center</h6>
                <div class="dropdown no-arrow">
                    <a class="dropdown-toggle" href="#" role="button" id="dropdownMenuLink"
                        data-toggle="dropdown" aria-haspopup="true" aria-expanded="false">
                        <i class="fas fa-danger-v fa-sm fa-fw text-gray-400"></i>
                    </a>
                    <div class="dropdown-menu dropdown-menu-right shadow animated--fade-in"
                        aria-labelledby="dropdownMenuLink">
                        <div class="dropdown-header">Dropdown Header:</div>
                        <a class="dropdown-item" href="#">Action</a>
                        <a class="dropdown-item" href="#">Another action</a>
                        <div class="dropdown-divider"></div>
                        <a class="dropdown-item" href="#">Something else here</a>
                    </div>
                </div>
            </div>
            <!-- Card Body -->
            <div class="card-body">
            <?php 
                      
                      $dres = mysqli_query($conn,"SELECT * FROM `newsline` ORDER BY id DESC ");
                      if(mysqli_num_rows($dres)>0){
                        while($data = mysqli_fetch_assoc($dres)){
                            ?>
                <div class="panel-body">
                            <div class="list-group">
                                <span href="#" class="list-item text-info">
                                 <h4>   <i class="fa fa-comment fa-fw"></i> <?php echo $data['newstitle']?>


                                                      <span class="pull-right text-primary small"><em><?php echo date('jS F, Y',strtotime($data['date'])) ?></em>
                                    </span>
                        </h4> 
                        </span>
                              
                                </div>  
                            
                            <!-- /.list-group -->
                          
                        </div>
                        <?php
                        }
                      }
                      ?>
                </div>
               
            
        </div>
    </div>

    <!-- Pie Chart -->
    <div class="col-xl-4 col-lg-5">
      
            <!-- Card Body -->
          
            
            <div class="card card-default">
              <div class="card-header">
               
                <h6 class="card-title m-0 font-weight-bold text-danger" style="font-size:12px;"><i class="fas fa-bullhorn"></i> WELCOME  <?php echo $_SESSION['name'] ?></h6>
              </div>
              <!-- /.card-header -->
              <div class="card-body">
                <div class="callout callout-danger">
                  <h6>SEND US MESSAGE</h6>
                </div>
                <form action="" name="contact" method="POST">
          <div class="input-group mb-3">
            <input type="text" class="form-control" style="text-transform:uppercase" id="inputName" name="name" placeholder="Full name"value="<?php echo $_SESSION['name'] ?>" required="">
            <input type="hidden" name="txn_form" value="ahkwebsolutions">
            <div class="input-group-append">
              <div class="input-group-text">
                <span class="fas fa-user"></span>
              </div>
            </div>
          </div>
          
          <div class="input-group mb-3">
          <input type="text" class="form-control" id="inputEmail"  name="email" placeholder="Please enter your e-mail"value="<?php echo $_SESSION['emailid'] ?>" required="">
            <div class="input-group-append">
              <div class="input-group-text">
                <span class="fas fa-envelope"></span>
              </div>
            </div>
          </div>
          <div class="input-group mb-3">
<select name="sub" class="form-control" required>
<option value="">Select</option>
<option value="WALLET UPDATE">WALLET UPDATE</option>
<option value="APPLICATION RELATED">APPLICATION RELATED</option>

</select>
			  
				  </div>
          <div class="input-group mb-3">
          <textarea id="inputName" class="form-control" style="text-transform:uppercase" name="mess" placeholder="Please enter your message"value="" required="" rows="4"></textarea>
                    <div class="input-group-append">
              <div class="input-group-text">
                    <span class="fas fa-envelope"></span>
                   </div>
                  </div>
                     </div>
            <div class="input-group mb-3">
              <button type="submit" class="btn btn-primary btn-block">SEND</button>
              <div class="input-group-append">
            </div>
            <!-- /.col -->
          </div>
        </form>
        <div class="card-body">
                <div class="callout callout-success">
                 

                </div>
                </div>
                 </div>
               </div>
                 </div>
                 </div>
                 
              <!-- /.card-body -->
            

<!-- Content Row -->

        





<!-- /.container-fluid -->

</div>
<!-- End of Main Content -->
<?php include "footer.php";?>