department code: prefix . 'departments'; $user_table_name = $wpdb->prefix . 'users'; $message = ''; $message_type = ''; // Handle success messages from redirect if (isset($_GET['message'])) { if ($_GET['message'] === 'updated') { $message = 'Department updated successfully!'; $message_type = 'success'; } elseif ($_GET['message'] === 'added') { $message = 'Department added successfully!'; $message_type = 'success'; } } // --- Handle delete department action --- if (isset($_GET['action']) && $_GET['action'] === 'delete_dept' && isset($_GET['id']) && isset($_GET['_wpnonce']) && wp_verify_nonce($_GET['_wpnonce'], 'delete_dept_' . absint($_GET['id']))) { $dept_id_to_delete = absint($_GET['id']); if ($dept_id_to_delete) { // Check if department has users $users_count = $wpdb->get_var($wpdb->prepare( "SELECT COUNT(*) FROM $user_table_name WHERE department_id = %d", $dept_id_to_delete )); if ($users_count > 0) { $message = 'Cannot delete department with assigned users.'; $message_type = 'error'; } else { $deleted = $wpdb->delete( $dept_table_name, ['id' => $dept_id_to_delete], ['%d'] ); if ($deleted) { wp_redirect(add_query_arg(['message' => 'deleted'], remove_query_arg(['action', 'id', '_wpnonce']))); exit; } else { $message = 'Error deleting department.'; $message_type = 'error'; } } } } // --- Handle edit department action (prepare form) --- $editing_dept = null; if (isset($_GET['action']) && $_GET['action'] === 'edit_dept' && isset($_GET['id'])) { $dept_id_to_edit = absint($_GET['id']); if ($dept_id_to_edit) { $editing_dept = $wpdb->get_row( $wpdb->prepare("SELECT * FROM $dept_table_name WHERE id = %d", $dept_id_to_edit), ARRAY_A ); if (!$editing_dept) { $message = 'Department not found for editing.'; $message_type = 'error'; } } } // --- Handle add/update department form submission --- if (isset($_POST['add_dept']) || isset($_POST['edit_dept'])) { $name = trim($_POST['name']); $description = trim($_POST['description']); // Validate inputs if (empty($name)) { $message = 'Department name is required.'; $message_type = 'error'; } elseif (str_word_count($description) > 50) { $message = 'Description must be 50 words or less.'; $message_type = 'error'; } else { $dept_data = [ 'name' => $name, 'description' => $description, 'updated_at' => current_time('mysql') ]; if (isset($_POST['edit_dept'])) { $dept_id = absint($_POST['dept_id']); $updated = $wpdb->update( $dept_table_name, $dept_data, ['id' => $dept_id], ['%s', '%s', '%s'], ['%d'] ); if ($updated !== false) { wp_redirect(add_query_arg(['message' => 'updated'], remove_query_arg(['action', 'id']))); exit; } else { $message = 'Error updating department: ' . $wpdb->last_error; $message_type = 'error'; } } else { $dept_data['created_at'] = current_time('mysql'); $inserted = $wpdb->insert( $dept_table_name, $dept_data, ['%s', '%s', '%s', '%s'] ); if ($inserted) { wp_safe_redirect(add_query_arg(['message' => 'added'], wp_get_referer())); exit; } else { $message = 'Error adding department: ' . $wpdb->last_error; $message_type = 'error'; } } } } // Fetch all departments with user counts $departments = $wpdb->get_results(" SELECT d.*, COUNT(u.id) as user_count FROM $dept_table_name d LEFT JOIN $user_table_name u ON d.id = u.department_id GROUP BY d.id ORDER BY d.name ASC ", ARRAY_A); ?> Department Management

Department Management

All Departments

ID	Department Name	Description	No. of Personnel	Action
				Edit Delete

user code: update( $user_table_name, ['last_logged_in' => current_time('mysql')], ['username' => $username] ); } // --- Handle delete user action --- if (isset($_GET['action']) && $_GET['action'] === 'delete_user' && isset($_GET['id']) && isset($_GET['_wpnonce']) && wp_verify_nonce($_GET['_wpnonce'], 'delete_user_' . absint($_GET['id']))) { $user_id_to_delete = absint($_GET['id']); if ($user_id_to_delete) { $deleted = $wpdb->delete( $user_table_name, ['id' => $user_id_to_delete], ['%d'] ); if ($deleted) { $message = 'User deleted successfully!'; $message_type = 'success'; } else { $message = 'Error deleting user.'; $message_type = 'error'; } } } // --- Handle edit user action (prepare form) --- $editing_user = null; if (isset($_GET['action']) && $_GET['action'] === 'edit_user' && isset($_GET['id'])) { $user_id_to_edit = absint($_GET['id']); if ($user_id_to_edit) { $editing_user = $wpdb->get_row( $wpdb->prepare("SELECT * FROM $user_table_name WHERE id = %d", $user_id_to_edit), ARRAY_A ); if (!$editing_user) { $message = 'User not found for editing.'; $message_type = 'error'; } } } // --- Handle add/update user form submission --- if (isset($_POST['add_user']) || isset($_POST['edit_user'])) { $first_name = trim($_POST['first_name']); $last_name = trim($_POST['last_name']); $username = trim($_POST['username']); $password = $_POST['password']; $confirm_password = $_POST['confirm_password']; $role = $_POST['role']; $department_id = !empty($_POST['department_id']) ? $_POST['department_id'] : NULL; // Validate names if (!preg_match('/^[a-zA-Z .]+$/', $first_name)) { $message = 'First name can only contain letters, spaces, and periods.'; $message_type = 'error'; } elseif (!preg_match('/^[a-zA-Z .]+$/', $last_name)) { $message = 'Last name can only contain letters, spaces, and periods.'; $message_type = 'error'; } elseif (empty($username)) { $message = 'Username is required.'; $message_type = 'error'; } elseif (isset($_POST['add_user']) && empty($password)) { $message = 'Password is required.'; $message_type = 'error'; } elseif (!empty($password) && $password !== $confirm_password) { $message = 'Passwords do not match.'; $message_type = 'error'; } else { $user_data = [ 'first_name' => $first_name, 'last_name' => $last_name, 'username' => $username, 'role' => $role, 'department_id' => $department_id ]; if (!empty($password)) { $user_data['password'] = password_hash($password, PASSWORD_DEFAULT); } if (isset($_POST['edit_user'])) { $user_id = absint($_POST['user_id']); $updated = $wpdb->update( $user_table_name, $user_data, ['id' => $user_id], ['%s', '%s', '%s', '%s', '%d'], ['%d'] ); if ($updated !== false) { wp_redirect(add_query_arg(['message' => 'updated'], remove_query_arg(['action', 'id']))); exit; } else { $message = 'Error updating user: ' . $wpdb->last_error; $message_type = 'error'; } } else { $user_data['created_at'] = current_time('mysql'); $inserted = $wpdb->insert( $user_table_name, $user_data ); if ($inserted) { wp_redirect(add_query_arg(['message' => 'added'], $_SERVER['REQUEST_URI'])); exit; } else { $message = 'Error adding user: ' . $wpdb->last_error; $message_type = 'error'; } } } } // Fetch all users with department names $users = $wpdb->get_results(" SELECT u.*, d.name as department_name FROM $user_table_name u LEFT JOIN departments d ON u.department_id = d.id ", ARRAY_A); // Fetch all departments for dropdown $departments = $wpdb->get_results("SELECT * FROM departments", ARRAY_A); ?> User Management

User Management

All Users

ID	First Name	Last Name	Username	Role	Department	Created At	Last Login	Action
						setTimezone(new DateTimeZone('Asia/Manila')); echo esc_html($date->format('Y-m-d h:i A')); } catch (Exception $e) { echo esc_html($user['created_at']); } } else { echo 'N/A'; } ?>	setTimezone(new DateTimeZone('Asia/Manila')); echo esc_html($date->format('Y-m-d h:i A')); } catch (Exception $e) { echo esc_html(date('Y-m-d h:i A', strtotime($user['last_logged_in']))); } } else { echo 'Never'; } ?>	Edit Delete

Replaced all the information for the adding user with the information for adding departments. Also replaces the information needed for listing the users with information needed to list the departments