1#@!#!123s

��JFIF�� 1#@!#!123s
: / proc / thread-self / root / home / earnlouq / claypremuim.com / admin /
Filename : transaction-details.php
back
<?php
session_start();
error_reporting(0);
include('../../config/cpconn.php');
include('include/checklogin.php');
check_login();
$title="Bed Details";
$currentTime = date( 'd-m-Y h:i:s A', time () );

if(isset($_GET['del']))
		  {
		          mysqli_query($con,"DELETE FROM `transactions` WHERE `id` = '".$_GET['id']."'");
                  echo "<script>window.location.href='private-ward.php';</script>";

		  }

if(isset($_GET) & !empty($_GET)){
	$tid=intval($_GET['tid']);// bed id
}else{
		echo "<script>window.location.href='transactions.php';</script>";
	}

	if(isset($_POST) & !empty($_POST)){
        $status = mysqli_real_escape_string($con, $_POST['status']);
			
		$sql = "UPDATE `transactions` set `status`='$status',updationDate='$currentTime'
         WHERE `id`='$tid' ";	
			$res = mysqli_query($con, $sql);
		if($res){
			$msg = "Transaction Status Updated Successfully!";
      $type = "success";
		}else{
			$msg = "Failed to Update Bed Status";
      $type = "warning";

		}
	
}
	?>
<?php include('include/header.php');?>
		
<?php include('include/sidebar.php');?>


  <!-- Content wrapper -->
  <div class="content-wrapper">
            <!-- Content -->

<div class="container-xxl flex-grow-1 container-p-y">
<h4 class="fw-bold py-3 mb-4"><span class="text-muted fw-light">Transaction/</span> Edit Status</h4>

<?php if(isset($msg)){ ?>
                    <div class="alert alert-<?php echo $type?>">
                          <h6 class="alert-heading fw-bold mb-1"><?php echo $type?></h6>
                          <p class="mb-0"><?php echo $msg?></p>
                        </div>
                        <?php }?>
                        
<?php 
          $query="SELECT * FROM `transactions` WHERE `id`='$tid' ";
          $result=mysqli_query($con,$query);
          while($row=mysqli_fetch_array($result))
{
    $updation_date = $row['updationDate'];
    $updation_date = date('l jS F Y \a\t g:ia');
    ?>
 
 <div class="card mb-4">
                    <h5 class="card-header">Update Status</h5>
                    <!-- Account -->
                    <div class="card-body">
                      <div class="d-flex align-items-start align-items-sm-center gap-4">
                     
                      <div class="button-wrapper">
                       <?php 
                if(isset($row['updationDate'])) {
                ?>
<p class="text-muted mb-0">Last Updated On <?php echo $updation_date;?></p>
                <?php   }?>     
                      </div>   
                      </div>
                    </div>
                    <hr class="my-0" />
                    <div class="card-body">
                    <form  method="post" enctype="multipart/form-data">
                        <div class="row">
                      <div class="mb-3 col-md-6">
                        <label class="form-label" for="basic-default-fullname">Status </label>        
                        <select  name="status" class="select2 form-select">
                       <?php 
                        $id=intval($_GET['id']);
                        $query2="SELECT * FROM `transactions` WHERE `id`='$tid' ";
                        $result2=mysqli_query($con,$query2);
                        while($row2=mysqli_fetch_array($result2))
                        {?>
<option value="<?php echo $row2['status']; ?>" <?php if( $row['status'] == $data['status']){ echo "selected"; } ?>><?php echo $row2['status']; ?></option>
<?php } ?>
                              <option value="Pending">Pending</option>
                              <option value="Confirmed">Confirmed</option>
                            </select>
                      </div> 
                        </div>
                        <div class="mt-2">
                          <button type="submit" class="btn btn-primary me-2" type="submit" name="submit" >Save changes</button>
                        </div>
                      </form>
                    </div>
                    <!-- /Account -->
                  </div>
                  <div class="card">
                    <h5 class="card-header">Delete Bed</h5>
                    <div class="card-body">
                      <div class="mb-3 col-12 mb-0">
                        <div class="alert alert-warning">
                          <h6 class="alert-heading fw-bold mb-1">Are you sure you want to delete record?</h6>
                          <p class="mb-0">Once you delete this record, there is no going back. Please be certain.</p>
                        </div>
                      </div>
                       
                        <a href="?id=<?php echo $row['id'];?>&del=delete" 
                        onClick="return confirm('Are you sure you want to delete?')" class="btn btn-danger deactivate-account">
                        Delete Bed</a>
                    </div>
                  </div>
                </div>

</div></div>

                <?php }?>
              </div>
            </div>
            <!-- / Content -->




<?php include('include/footer.php');?>