One Hat Cyber Team

Your IP: 216.73.217.37
Server IP: 15.235.14.176
Server: Linux server2.ihostph.com 4.18.0-553.30.1.el8_10.x86_64 #1 SMP Tue Nov 26 02:30:26 EST 2024 x86_64
Server Software: Apache
PHP Version: 8.1.34
Buat File | Buat Folder

Dir : ~/home/gracious/hris.graciousphils.com/hradmin/

View File Name : replace_phone_number.php

<?php
require_once 'includes/config.php';

header('Content-Type: application/json');

try {
    if (!isset($_POST['biocode']) || !isset($_POST['oldNumber']) || !isset($_POST['newNumber']) || !isset($_POST['oozyCode'])) {
        throw new Exception('Missing required parameters');
    }

    $biocode = $_POST['biocode'];
    $oldNumber = $_POST['oldNumber'];
    $newNumber = $_POST['newNumber'];
    $oozyCode = $_POST['oozyCode'];

    // Start transaction
    $dbh->beginTransaction();

    // Split multiple oozy codes if they exist
    $oozyCodes = explode(',', $oozyCode);
    
    foreach ($oozyCodes as $code) {
        $code = trim($code);
        if (empty($code)) continue;

        // Get current data from oozy_code table
        $sql = "SELECT id, Empid, Empname, emp_number FROM tbl_oozy_code WHERE Oozy_code = :oozy_code";
        $stmt = $dbh->prepare($sql);
        $stmt->execute(['oozy_code' => $code]);
        $currentData = $stmt->fetch(PDO::FETCH_ASSOC);

        if ($currentData) {
            // Split the current data
            $empIds = explode(';', $currentData['Empid']);
            $empNames = explode(';', $currentData['Empname']);
            $empNumbers = explode(';', $currentData['emp_number']);

            // Find the index of the biocode
            $key = array_search($biocode, $empIds);
            
            if ($key !== false) 
            {
                // Replace the old number with the new number
                $empNumbers[$key] = $newNumber;

                // Update the record
                $sql = "UPDATE tbl_oozy_code SET 
                        emp_number = :emp_number
                        WHERE id = :id";
                        
                $stmt = $dbh->prepare($sql);
                $stmt->execute([
                    'emp_number' => implode(';', $empNumbers),
                    'id' => $currentData['id']
                ]);

                // Log the update for debugging
                error_log("Updated Oozy Code: $code");
                error_log("New emp_number: " . implode(';', $empNumbers));
            }
        }
    }

    $dbh->commit();
    echo json_encode(['success' => true]);

} catch (Exception $e) {
    if ($dbh->inTransaction()) {
        $dbh->rollBack();
    }
    error_log("Error in replace_phone_number.php: " . $e->getMessage());
    echo json_encode([
        'success' => false,
        'message' => $e->getMessage()
    ]);
}
?>