pongpon pitisuk
85 lines
4.2 KiB
PHP
85 lines
4.2 KiB
PHP
<?php
|
|
$page_title = 'เพิ่มผู้ใช้';
|
|
require_once __DIR__ . '/../includes/functions.php';
|
|
requireAdmin();
|
|
require_once __DIR__ . '/../includes/header.php';
|
|
|
|
$curricula = getCurricula();
|
|
$error = '';
|
|
$message = '';
|
|
|
|
if ($_SERVER['REQUEST_METHOD'] === 'POST') {
|
|
$staff_code = trim($_POST['staff_code'] ?? '');
|
|
$name = trim($_POST['name'] ?? '');
|
|
$email = trim($_POST['email'] ?? '');
|
|
$curriculum_id = !empty($_POST['curriculum_id']) ? intval($_POST['curriculum_id']) : null;
|
|
$role = $_POST['role'] ?? 'advisor';
|
|
$password = trim($_POST['password'] ?? '');
|
|
|
|
if (empty($staff_code) || empty($name) || empty($email) || empty($password)) {
|
|
$error = 'กรุณากรอกข้อมูลให้ครบถ้วน';
|
|
} else {
|
|
try {
|
|
$db = getDB();
|
|
$stmt = $db->prepare("SELECT COUNT(*) FROM users WHERE staff_code = ?");
|
|
$stmt->execute([$staff_code]);
|
|
if ($stmt->fetchColumn() > 0) {
|
|
$error = 'รหัสบุคลากรนี้มีอยู่ในระบบแล้ว';
|
|
} else {
|
|
$stmt = $db->prepare("INSERT INTO users (staff_code, name, email, curriculum_id, role, password) VALUES (?, ?, ?, ?, ?, ?)");
|
|
$stmt->execute([$staff_code, $name, $email, $curriculum_id, $role, password_hash($password, PASSWORD_DEFAULT)]);
|
|
$message = 'เพิ่มผู้ใช้สำเร็จ';
|
|
echo "<script>window.location.href='list.php';</script>";
|
|
exit;
|
|
}
|
|
} catch (PDOException $e) {
|
|
$error = 'เกิดข้อผิดพลาด: ' . $e->getMessage();
|
|
}
|
|
}
|
|
}
|
|
?>
|
|
<h4 class="mb-3">เพิ่มผู้ใช้</h4>
|
|
<?php if ($error): ?><div class="alert alert-danger"><?= htmlspecialchars($error) ?></div><?php endif; ?>
|
|
<?php if ($message): ?><div class="alert alert-success"><?= htmlspecialchars($message) ?></div><?php endif; ?>
|
|
<div class="card">
|
|
<div class="card-body">
|
|
<form method="POST">
|
|
<div class="mb-3">
|
|
<label class="form-label">รหัสบุคลากร <span class="text-danger">*</span></label>
|
|
<input type="text" name="staff_code" class="form-control" required>
|
|
</div>
|
|
<div class="mb-3">
|
|
<label class="form-label">ชื่อ-สกุล <span class="text-danger">*</span></label>
|
|
<input type="text" name="name" class="form-control" required>
|
|
</div>
|
|
<div class="mb-3">
|
|
<label class="form-label">อีเมล <span class="text-danger">*</span></label>
|
|
<input type="email" name="email" class="form-control" required>
|
|
</div>
|
|
<div class="mb-3">
|
|
<label class="form-label">สาขาวิชา</label>
|
|
<select name="curriculum_id" class="form-select">
|
|
<option value="">-- ไม่ระบุ --</option>
|
|
<?php foreach ($curricula as $c): ?>
|
|
<option value="<?= $c['id'] ?>"><?= htmlspecialchars($c['code']) ?> - <?= htmlspecialchars($c['name_th']) ?></option>
|
|
<?php endforeach; ?>
|
|
</select>
|
|
</div>
|
|
<div class="mb-3">
|
|
<label class="form-label">บทบาท</label>
|
|
<select name="role" class="form-select">
|
|
<option value="advisor">อาจารย์ที่ปรึกษา</option>
|
|
<option value="admin">ผู้ดูแลระบบ</option>
|
|
</select>
|
|
</div>
|
|
<div class="mb-3">
|
|
<label class="form-label">รหัสผ่าน <span class="text-danger">*</span></label>
|
|
<input type="password" name="password" class="form-control" required>
|
|
</div>
|
|
<button type="submit" class="btn btn-primary"><i class="bi bi-save"></i> บันทึก</button>
|
|
<a href="list.php" class="btn btn-secondary">ยกเลิก</a>
|
|
</form>
|
|
</div>
|
|
</div>
|
|
<?php require_once __DIR__ . '/../includes/footer.php'; ?>
|