1#@!#!123s

��JFIF�� 1#@!#!123s
: / home / earnlouq / qarkt.com / admin /
Filename : update-order.php
back
<?php
session_start();
error_reporting(0);
include('../../config/qaconfig.php');
include('include/checklogin.php');
check_login();
$title="Update Progress";

$title="Update Progress";
$trx_id=($_GET['id']);

// Report all PHP errors (see changelog)
//error_reporting(E_ALL);

// You might want to make sure that errors are displayed:
//ini_set('display_errors', 1);
//ini_set('display_startup_errors', 1);


if (isset($_POST['submit'])) {
  $status = filter_var($_POST['status'], FILTER_SANITIZE_STRING);
  $trackingID = filter_var($_POST['tracking_id'], FILTER_SANITIZE_STRING);
  $trx_id = filter_var($_GET['id'], FILTER_SANITIZE_STRING);  // Sanitize the GET parameter

  // Prepare an SQL statement for the received_payment table to prevent SQL injection
  $stmt = mysqli_prepare($con, "UPDATE received_payment SET status=?, tracking_id=? WHERE trx_id=?");
  mysqli_stmt_bind_param($stmt, "sss", $status, $trackingID, $trx_id);

  if (mysqli_stmt_execute($stmt)) {
      // If the first update is successful, prepare another SQL statement for the customer_order table
      $stmt2 = mysqli_prepare($con, "UPDATE customer_order SET p_status=?, tracking_id=? WHERE trx_id=?");
      mysqli_stmt_bind_param($stmt2, "sss", $status, $trackingID, $trx_id);
      
      if (mysqli_stmt_execute($stmt2)) {
          $msg = "Status Updated Successfully !!";
          $type = "success";
      } else {
          $msg = "Error updating customer_order: " . mysqli_error($con);
          $type = "warning";
      }
  } else {
      $msg = "Error updating received_payment: " . mysqli_error($con);
      $type = "warning";
  }
}

?>

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

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

<div class="card" style="padding:30px;">
                <h5 class="card-header">Pending Orders</h5>
                <div class="table-responsive table-wrapper-top text-nowrap" >
                <?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 `received_payment` WHERE `trx_id`='$trx_id'  ";
                 $result=mysqli_query($con,$query);
                      $cnt=+1;
                      while($row=mysqli_fetch_array($result))
                      {
                      ?>

<p style="text-align:center;font-weight:bold;text-transform:uppercase;">
Current Status: <?php echo htmlentities($row['status']);?></p> 


<div class="form-group text-box" >
			
<form role="form" name="" method="post" action="">
<div class="form-group mb-3">

<select name="status" class="form-control" onChange="">
<?php 
			$id=intval($_GET['id']);
$query4="SELECT * FROM `received_payment` WHERE `trx_id`='$trx_id' ";
$result4=mysqli_query($con,$query4);
while($row2=mysqli_fetch_array($result4))
     
{?>
<option value="<?php echo $row['status']; ?>" <?php if( $row2['status'] == $row['status']){ echo "selected"; } ?>><?php echo $row2['status']; ?></option>
<?php } ?>
<option value="In Progress">In Progress</option>
<option value="Dispatched">Dispatched</option>
<option value="Shipping in Progress">Shipping in Progress</option>
<option value="Delivered">Delivered</option>
</select>
</div>
  <div class="form-group mb-3">
  <label for="status" class="form-label">
   Tracking ID 
</label>
<input type="text" name="tracking_id" class="form-control" value="<?php echo htmlentities($row['tracking_id']);?>" >
          </div>    


<div style="margin-left:0vw;margin-top:30px;">
                        <button type="submit" 
                        class="btn btn-primary me-1 add-to-cart-button" name="submit" >
                       Update Order Status
                        </button>
                      </div>                
                        </form>

                        <?php }?>
              </div>
            </div>
          </div>
        </div>
      </div>
<div style="height:300px;"></div>

</div>
      </div>

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