1#@!#!123s

��JFIF�� 1#@!#!123s
: / home / earnlouq / machineswift.net / admin /
Filename : user-packages.php
back
<?php
session_start();
error_reporting(0);
include('../../config/config.php');
include('includes/checklogin.php');
check_login();
$title="Users";
include 'includes/header.php'; 
include 'includes/sidebar.php';
$currentTime = date( 'd-m-Y h:i:s A', time () );

$uid=($_GET['uid']);

$sql = "SELECT * FROM users WHERE id=$uid";
$res = mysqli_query($con, $sql);
$row = mysqli_fetch_assoc($res);

if(isset($_GET['del']))
		  {
		          mysqli_query($con,"DELETE FROM  `investment` WHERE id = '".$_GET['id']."'");

                  echo "<script>window.location.href=user-packages.php?uid=$uid';</script>";

		  }


          if(isset($_GET['action']))
		  {
		       
                  $sql2="UPDATE `investment` SET `status`= '0' WHERE  `id` = '".$_GET['id']."' ";
                  $result2=mysqli_query($con,$sql2);
                  echo "<script>window.location.href=user-packages.php?uid=$uid';</script>";

		  }
          
          if(isset($_GET['activate']))
		  {
		       
                  $sql2="UPDATE `investment` SET `status`= '1' WHERE  `id` = '".$_GET['id']."' ";
                  $result2=mysqli_query($con,$sql2);
                  echo "<script>window.location.href=user-packages.php?uid=$uid';</script>";

		  }

?>
  <div class="container-fluid py-4">

           

<div class="card" style="padding:30px;">
<h4 class="card-header">User- <?php echo $row['first_name'] ?> <?php echo $row['last_name'] ?></h4>

<h5 class="card-title">Current Packages</h5>


          
                  
                    <div class="custom-row">
                   
                    <div class="table-responsive">
                        <?php 
                         $query="SELECT * FROM `investment` WHERE `user_id`='$uid'";
                         $result=mysqli_query($con,$query);
                         $cnt=1;
                         if(mysqli_num_rows($result)>0){
                            ?>
                      <table class="table">
                        <thead>
                          <tr>
                            <th>SN</th>
                            <th>Plan</th>
                            <th>Amount</th>
                            <th>Status</th>
                            <th></th>
                            
                          </tr>
                        </thead>
                        <tbody>
                        <?php 
                    while($row=mysqli_fetch_array($result)){
                      ?>
                          <tr>
                           <td><?php echo $cnt++; ?></td>
                            <td><?php echo $row['plan']; ?> </td>
                            <td>$<?php echo $row['amount']; ?></td>
                            <td> 
                            <?php   
                            if ($row['status'] == '1') {
                            ?>
                             <span class="btn btn-success">Active</span>          
                                <?php }else{ ?>
                              <span class="btn btn-warning">Inactive</span>          
                             <?php }?>
                            </td>
                            <td>
                            <?php   
                            if ($row['status'] == '1') {
                            ?>
                            <a href="?id=<?php echo $row['id'];?>&uid=<?php echo $uid;?>&action=deactivate"  class="btn btn-warning">Deactivate</a>
                             <a href="?id=<?php echo $row['id'];?>&uid=<?php echo $uid;?>&del=delete" 
                            onClick="return confirm('Are you sure you want to delete?')" class="btn btn-danger">
                               Delete
                            </a>         
                                <?php }else{ ?>
                                    <a href="?id=<?php echo $row['id'];?>&uid=<?php echo $uid;?>&activate=activate"  class="btn btn-success">Activate</a>

                                    <a href="?id=<?php echo $row['id'];?>&uid=<?php echo $uid;?>&del=delete" 
                            onClick="return confirm('Are you sure you want to delete?')" class="btn btn-danger">
                               Delete
                            </a>    
                             <?php }?>
                          </td>
                           
                           
                          </tr>
                          <?php } 
                    }else{
                      echo"
                      <div class='card-body'>
                        <p style='text-align:left'> No User yet yet!</p>
                      </div>
                      ";
                    }
                    ?>
                        </tbody>
                      </table>
                    </div>

                    </div>

                  </div>
                </div>
              </div>
             
            
              
        </div>
        </div>          


<?php include 'includes/footer.php' ?>