-- phpMyAdmin SQL Dump
-- version 5.2.1
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Aug 18, 2026 at 06:29 PM
-- Server version: 10.4.32-MariaDB
-- PHP Version: 8.2.12

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Database: `absensi_pegawai`
--

-- --------------------------------------------------------

--
-- Table structure for table `karyawan`
--

CREATE TABLE `karyawan` (
  `id_pegawai` int(11) NOT NULL,
  `nama` varchar(100) NOT NULL,
  `username` varchar(50) NOT NULL,
  `password` varchar(255) NOT NULL,
  `role` varchar(20) NOT NULL DEFAULT 'pegawai'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `karyawan`
--

INSERT INTO `karyawan` (`id_pegawai`, `nama`, `username`, `password`, `role`) VALUES
(1, 'Ika', 'ika', '$2y$10$YXnDGIEALN0XdprstCIS.eZFCjAzfvdl9.gQZTTM51iv32b46hICS', 'pegawai'),
(3, 'Sabrina', 'sabrina', '$2y$10$QGN8tKU8REX4Mszfj5klQODB1XWMwfWeITNSfQf7OsUEvUR0iQh2K', 'pegawai'),
(4, '', 'admin', '$2y$10$SnTvc2O.roUMhoiarYoai.H.3ivecZNxJIslr4FEPpGyhCxYo78Ie', 'admin'),
(6, '', 'admin2', '$2y$10$cGuVNR/fzrQSycyYxZ0h9el3p0pB..6nkqwEsyK3iV/w41vTdbmxK', 'admin'),
(7, '', 'admin3', '$2y$10$Q0zgUCBAu46K6wMMvyRXkul5.82/9dYiYLaFCieGyWWdYQZ5bpx4m', 'admin'),
(8, 'ara', 'ara', '$2y$10$n7b0cGCeJLRo.QFCv6DQROMtv6jZCqCz56wSshpsQNT2OoFD/Grt.', 'pegawai'),
(9, 'raa', 'raaa', '$2y$10$YclyI2nVttuZrsMXfhYsW.5ygKncVp5JbsfJtzkiuUZ7Y1CUJ4pd2', 'pegawai'),
(10, 'ikaaa', 'ikaaa', '$2y$10$hMLUKZgKxyTsYe/oeczTxOk9QL70VtOyclsU22.cl6yiK0erALtau', 'pegawai'),
(11, 'sabika', 'sabika', '$2y$10$87YJNO7wYs8MoNoG96lSoOiAosRi1y1zUeb6NYd/6Jg1O/2VBIxT2', 'pegawai'),
(13, 'Karyawan baruu', 'Karbar', '$2y$10$HC5pZ1oZdMiYoewUCVUNLej9slxVs7pqD0Zg9teT/lknAFEkDTxvS', 'pegawai'),
(15, 'Sabrina Nugrahesti', 'G211230066', '$2y$10$Yow0eCcWqz/Lc83eNyi2NO3HnBOc.Yb4g8J3pt70lIBK.3Y87SZe.', 'pegawai');

-- --------------------------------------------------------

--
-- Table structure for table `presensi`
--

CREATE TABLE `presensi` (
  `id` int(11) NOT NULL,
  `pegawai_id` int(11) NOT NULL,
  `tanggal` date NOT NULL,
  `jam_masuk` time DEFAULT NULL,
  `jam_keluar` time DEFAULT NULL,
  `status_masuk` varchar(20) DEFAULT NULL,
  `latitude` varchar(50) DEFAULT NULL,
  `longitude` varchar(50) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `presensi`
--

INSERT INTO `presensi` (`id`, `pegawai_id`, `tanggal`, `jam_masuk`, `jam_keluar`, `status_masuk`, `latitude`, `longitude`) VALUES
(1, 1, '2026-02-03', '03:23:43', '03:23:49', NULL, NULL, NULL),
(2, 1, '2026-02-04', '00:00:00', '00:00:00', NULL, NULL, NULL),
(3, 2, '2026-02-04', '00:00:00', '00:00:00', NULL, NULL, NULL),
(4, 3, '2026-02-04', '00:00:00', '00:00:00', NULL, NULL, NULL),
(5, 1, '2026-02-18', '00:00:00', '00:00:00', NULL, NULL, NULL),
(6, 3, '2026-02-18', '06:25:37', NULL, 'Tepat Waktu', NULL, NULL),
(7, 4, '2026-02-18', '06:57:08', NULL, 'Tepat Waktu', '-6.84784775', '110.71939475'),
(8, 5, '2026-02-18', '11:52:46', NULL, 'Terlambat', '-7.0168842967862135', '110.41804290857542'),
(9, 6, '2026-02-18', '11:54:50', NULL, 'Terlambat', '-7.016847540951898', '110.41803111600073'),
(10, 7, '2026-02-18', '12:10:20', NULL, 'Terlambat', '-7.016882416239535', '110.41804023033194'),
(11, 4, '2026-03-04', '07:31:45', NULL, 'Tepat Waktu', '-6.984446331631025', '110.45204946824131'),
(12, 8, '2026-03-04', '08:21:16', NULL, 'Terlambat', '-6.984446331631025', '110.45204946824131'),
(13, 1, '2026-03-04', '09:00:53', NULL, 'Terlambat', '-6.984446331631025', '110.45204946824131'),
(14, 9, '2026-07-09', '16:42:54', '17:20:40', 'Terlambat', '-7.060843', '110.411288'),
(15, 1, '2026-07-10', '21:56:33', '21:56:37', 'Terlambat', '-6.846745000000001', '110.719666'),
(16, 0, '2026-07-30', '00:05:03', NULL, 'Tepat Waktu', '-6.984457315624432', '110.45207496050365'),
(17, 1, '2026-08-04', '01:02:55', NULL, 'Tepat Waktu', '-6.984462806575167', '110.45214389977657'),
(18, 11, '2026-08-04', '09:56:15', NULL, 'Terlambat', '-6.98447008066163', '110.45215654359814'),
(19, 0, '2026-08-04', '11:34:07', NULL, 'Terlambat', '-6.984462427839395', '110.45217172422669'),
(20, 0, '2026-08-11', '14:13:45', NULL, 'Terlambat', '-6.980349262897441', '110.45415965474864'),
(21, 13, '2026-08-11', '14:29:02', '19:23:44', 'Terlambat', '-6.980296945256716', '110.45398130091806'),
(22, 14, '2026-08-11', '14:34:03', NULL, 'Terlambat', '-6.980138210567787', '110.45402211763577'),
(23, 11, '2026-08-11', '14:39:39', NULL, 'Terlambat', '-6.980348932030598', '110.4540144324889'),
(24, 11, '2026-08-18', '21:31:41', '21:31:42', 'Terlambat', '-6.984413371670433', '110.45218092644738');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `karyawan`
--
ALTER TABLE `karyawan`
  ADD PRIMARY KEY (`id_pegawai`);

--
-- Indexes for table `presensi`
--
ALTER TABLE `presensi`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `karyawan`
--
ALTER TABLE `karyawan`
  MODIFY `id_pegawai` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16;

--
-- AUTO_INCREMENT for table `presensi`
--
ALTER TABLE `presensi`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=25;
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;