alifiharafi

-- ==============================
-- DATA USER (10 orang, 5 gudang, 5 dapur)
-- ==============================
INSERT INTO `user` (id, name, email, password, role, created_at) VALUES
-- Password: pass123; Hashed Password (md5): 32250170a0dca92d53ec9624f336ca24
(1, 'Budi Santoso', 'budi.gudang@mbg.id', '32250170a0dca92d53ec9624f336ca24', 'gudang', '2025-09-01 08:00:00'),
(2, 'Siti Aminah', 'siti.gudang@mbg.id', '32250170a0dca92d53ec9624f336ca24', 'gudang', '2025-09-01 08:05:00'),
(3, 'Rahmat Hidayat', 'rahmat.gudang@mbg.id', '32250170a0dca92d53ec9624f336ca24', 'gudang', '2025-09-01 08:10:00'),
(4, 'Lina Marlina', 'lina.gudang@mbg.id', '32250170a0dca92d53ec9624f336ca24', 'gudang', '2025-09-01 08:15:00'),
(5, 'Anton Saputra', 'anton.gudang@mbg.id', '32250170a0dca92d53ec9624f336ca24', 'gudang', '2025-09-01 08:20:00'),

alifiharafi

-- Anggota: 6 orang (2 Ketua/Wakil, 4 Anggota).
-- Komponen Gaji: 3 + 7 + 13 = 23 item.
-- Penggajian: Masing-masing anggota memiliki komponen yang berbeda, cukup variatif baik berdasarkan "Jabatan" maupun "Satuan".

-- ==============================
-- DATA PENGGUNA (Admin & Public)
-- ==============================
INSERT INTO pengguna (id_pengguna, username, password, email, nama_depan, nama_belakang, role)
VALUES 
  -- username: admin; password: admin123; password_hash(admin123, PASSWORD_DEFAULT);

alifiharafi

### Create New File for Users List ###
sudo vim /tmp/userlist3a # Type all username(s) seperated by new line

### Create New File for Shell Script ###
sudo vim /usr/sbin/createuser3a.sh

### Copy-Paste Shell Script Below ####
#!/bin/bash
userfile=/tmp/userlist3a
username=$(cat $userfile | tr 'A-Z'  'a-z')