57 lines
2.0 KiB
PHP
57 lines
2.0 KiB
PHP
<?php
|
|
$socket = '/tmp/mysql_3306.sock';
|
|
$dbname = 'hrm';
|
|
$username = 'root';
|
|
$password = '';
|
|
|
|
try {
|
|
$pdo = new PDO("mysql:unix_socket=$socket;dbname=$dbname", $username, $password);
|
|
$pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
|
|
echo "Successfully connected to the database via socket!\n\n";
|
|
|
|
// 1. Begin transaction
|
|
$pdo->beginTransaction();
|
|
|
|
// 2. Update biometric_attendances
|
|
echo "Updating biometric_attendances...\n";
|
|
$stmt1 = $pdo->prepare("UPDATE biometric_attendances SET branch_id = 2 WHERE biometric_emp_id = '2068'");
|
|
$stmt1->execute();
|
|
$affected1 = $stmt1->rowCount();
|
|
echo "-> Updated $affected1 logs for Paul Rei Paas (2068) to Branch 2\n";
|
|
|
|
$stmt2 = $pdo->prepare("UPDATE biometric_attendances SET branch_id = 1 WHERE biometric_emp_id IN ('2111', '2013', '2101')");
|
|
$stmt2->execute();
|
|
$affected2 = $stmt2->rowCount();
|
|
echo "-> Updated $affected2 logs for Donna, Dinh, and Reynah to Branch 1\n";
|
|
|
|
// 3. Update attendance_records
|
|
echo "Updating attendance_records...\n";
|
|
$stmt3 = $pdo->prepare("
|
|
UPDATE attendance_records
|
|
SET branch_id = 2
|
|
WHERE employee_id IN (SELECT user_id FROM employees WHERE biometric_emp_id = '2068')
|
|
");
|
|
$stmt3->execute();
|
|
$affected3 = $stmt3->rowCount();
|
|
echo "-> Updated $affected3 synced attendance records for Paul Rei Paas (2068) to Branch 2\n";
|
|
|
|
$stmt4 = $pdo->prepare("
|
|
UPDATE attendance_records
|
|
SET branch_id = 1
|
|
WHERE employee_id IN (SELECT user_id FROM employees WHERE biometric_emp_id IN ('2111', '2013', '2101'))
|
|
");
|
|
$stmt4->execute();
|
|
$affected4 = $stmt4->rowCount();
|
|
echo "-> Updated $affected4 synced attendance records for Donna, Dinh, and Reynah to Branch 1\n";
|
|
|
|
// Commit transaction
|
|
$pdo->commit();
|
|
echo "\nDatabase transaction committed successfully!\n";
|
|
|
|
} catch (PDOException $e) {
|
|
if (isset($pdo) && $pdo->inTransaction()) {
|
|
$pdo->rollBack();
|
|
}
|
|
echo "ERROR: " . $e->getMessage() . "\n";
|
|
}
|