HEX
Server: Apache/2.4.58 (Ubuntu)
System: Linux ip-172-31-18-78 6.17.0-1017-aws #17~24.04.1-Ubuntu SMP Tue May 26 21:09:53 UTC 2026 aarch64
User: ubuntu (1000)
PHP: 8.2.31
Disabled: NONE
Upload Files
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>