File: /var/www/grapossconnect/admin-dash/api/update_emp_status.php
<?php
require_once('../_dbconfig.php');
$empId = $_REQUEST['empId'];
$EMPLOYEES = 'grp_employees';
$checkStatus = $conn->query("SELECT status, additional_notes FROM $EMPLOYEES WHERE `id`='$empId'");
$show_res = $checkStatus->fetch_assoc();
$empStatus = $show_res['status'];
?>
<div class="row">
<div class="col-lg-12">
<div class="card border-0 mb-4">
<form method="post">
<div class="card-body">
<div class="row">
<div class="col-md-12">
<div class="mb-3">
<label class="form-label">Employee Status Update (If the employee is no longer associated with the company) <span class="text-danger">*</span></label>
<select class="form-select" name="emp_status" id="emp_status">
<option value="working" <?php echo ($empStatus == 'working') ? 'selected' : ''; ?>>working</option>
<option value="left" <?php echo ($empStatus == 'left') ? 'selected' : ''; ?>>left</option>
</select>
</div>
<div class="mb-3">
<label class="form-label">Additional Remakrs (if any)</label>
<div class="form-control p-0 overflow-hidden">
<textarea class="form-control" name="additionalnotes" placeholder="Enter text ..." rows="10"><?php echo $show_res['additional_notes']; ?></textarea>
</div>
</div>
<?php if ($empStatus == 'left') {
echo "<div class='text-danger'><font>This employee is no longer associated with company, no need to update</font></div>";
} else { ?>
<input type="hidden" name="emp_id" value="<?php echo $empId; ?>" />
<div class="card-footer bg-none d-flex p-0 mt-3">
<button class="btn btn-primary" name="updateEmpStatus" type="submit">Update Status </button>
</div>
<?php } ?>
</div>
</div>
</div>
</form>
</div>
</div>
</div>