-- https://www.phpmyadmin.net/
--

START TRANSACTION;



--
-- Database: `smkncik1_amob_app`
--

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

--
-- Table structure for table `absen`
--

CREATE TABLE `absen` (
  `id_absen` int NOT NULL,
  `id_users` int NOT NULL,
  `tanggal` varchar(255) NOT NULL,
  `jam_masuk` varchar(255) NOT NULL,
  `jam_pulang` varchar(255) NOT NULL,
  `lat_masuk` text NOT NULL,
  `long_masuk` text NOT NULL,
  `jarak_masuk` text NOT NULL,
  `lat_pulang` text NOT NULL,
  `long_pulang` text NOT NULL,
  `jarak_pulang` text NOT NULL,
  `foto_masuk` text NOT NULL,
  `foto_pulang` text NOT NULL,
  `status_absen_masuk` int NOT NULL,
  `status_absen_pulang` int NOT NULL,
  `status_absen` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `absen`
--

INSERT INTO `absen` (`id_absen`, `id_users`, `tanggal`, `jam_masuk`, `jam_pulang`, `lat_masuk`, `long_masuk`, `jarak_masuk`, `lat_pulang`, `long_pulang`, `jarak_pulang`, `foto_masuk`, `foto_pulang`, `status_absen_masuk`, `status_absen_pulang`, `status_absen`) VALUES
(65, 112, '2024-04-27', '07:20:44', '20:01:33', '-6.4739351', '107.7450813', '5542', '-6.5708238', '107.7561515', '16366', '662c44dcaa717.png', '662cf72d9e33e.png', 1, 4, 2),
(66, 122, '2024-04-27', '20:55:28', '20:58:24', '-6.3950051', '107.7544544', '3420', '-6.3949333', '107.7543452', '3424', '662d03d0e1dd5.png', '662d04805646c.png', 2, 4, 2),
(67, 143, '2024-04-28', '06:46:45', '', '-6.4240997', '107.7436209', '90', '', '', '', '662d8e65cc4b6.png', '', 1, 0, 1),
(68, 118, '2024-04-28', '15:21:00', '', '-6.8250605', '107.6315638', '46293', '', '', '', '662e06ec3052e.png', '', 2, 0, 1),
(69, 136, '2024-04-29', '05:10:03', '20:24:21', '-6.4242607', '107.7439601', '55', '-6.4132024', '107.7486316', '1298', '662ec93b2043e.png', '662f9f85ef6c7.png', 1, 4, 2),
(70, 117, '2024-04-29', '05:51:38', '16:03:13', '-6.4242354', '107.7440308', '47', '-6.4242697', '107.7440567', '46', '662ed2fa0986c.png', '662f6251d2809.png', 1, 4, 2),
(72, 130, '2024-04-29', '06:25:32', '16:01:31', '-6.4241727', '107.7441932', '28', '-6.3942449', '107.7559832', '3557', '662edaecf399f.png', '662f61eb35424.png', 1, 4, 2),
(73, 138, '2024-04-29', '06:28:51', '17:28:50', '-6.4132024', '107.7486316', '1298', '-6.4245126', '107.743852', '79', '662edbb351b74.png', '662f7662a7083.png', 1, 4, 2),
(74, 119, '2024-04-29', '06:31:09', '16:00:15', '-6.4243413', '107.7441923', '38', '-6.4242316', '107.7439892', '51', '662edc3def2d4.png', '662f619fe8b14.png', 1, 4, 2),
(75, 112, '2024-04-29', '06:31:23', '16:37:47', '-6.4242229', '107.7440874', '41', '-6.4359017', '107.738269', '1479', '662edc4b72009.png', '662f6a6ba8a5f.png', 1, 4, 2),
(76, 115, '2024-04-29', '06:32:04', '16:02:33', '-6.424313333333333', '107.74366333333334', '89', '-6.424201666666666', '107.74416666666666', '32', '662edc74d9f9c.png', '662f6229a91d7.png', 1, 4, 2),
(77, 150, '2024-04-29', '06:34:33', '16:01:15', '-6.4242322', '107.7439437', '56', '-6.4240803', '107.744201', '26', '662edd0976031.png', '662f61db4037f.png', 1, 4, 2),
(78, 118, '2024-04-29', '06:40:02', '', '-6.8251361', '107.6315432', '46301', '', '', '', '662ede52ada56.png', '', 1, 0, 1),
(79, 127, '2024-04-29', '06:40:44', '16:00:14', '-6.4242239', '107.7441247', '37', '-6.4241271', '107.7441864', '28', '662ede7cbaea4.png', '662f619e57482.png', 1, 4, 2),
(80, 121, '2024-04-29', '06:42:40', '16:01:28', '-6.4240466', '107.744231', '24', '-6.4240486', '107.7442333', '23', '662edef0383cd.png', '662f61e8be839.png', 1, 4, 2),
(81, 142, '2024-04-29', '06:45:21', '16:13:25', '-6.424219', '107.7442132', '28', '-6.4242329', '107.7442036', '29', '662edf919929c.png', '662f64b59be30.png', 1, 4, 2),
(82, 114, '2024-04-29', '06:45:48', '16:01:17', '-6.4242513', '107.743979', '53', '-6.4242984', '107.7442009', '34', '662edfac05c6e.png', '662f61ddb1058.png', 1, 4, 2),
(83, 145, '2024-04-29', '06:47:23', '17:08:07', '-6.4242304', '107.744163', '33', '-6.424591', '107.7438185', '87', '662ee00b0dc03.png', '662f718788dcd.png', 1, 4, 2),
(84, 147, '2024-04-29', '06:49:12', '16:09:16', '-6.3854854', '107.7604895', '4647', '-6.4242067', '107.7441816', '30', '662ee07867ac3.png', '662f63bc2f676.png', 1, 4, 2),
(85, 140, '2024-04-29', '06:50:15', '', '-6.576637', '107.7834814', '17501', '', '', '', '662ee0b744c4f.png', '', 1, 0, 1),
(86, 124, '2024-04-29', '06:54:44', '16:01:36', '-6.4241655', '107.7441688', '30', '-6.4242209', '107.7441852', '31', '662ee1c45a240.png', '662f61f0b96f7.png', 1, 4, 2),
(87, 122, '2024-04-29', '06:56:08', '16:03:51', '-6.3966107', '107.7578842', '3400', '-6.424193', '107.7441105', '37', '662ee218e428a.png', '662f627746fc4.png', 1, 4, 2),
(88, 132, '2024-04-29', '06:58:12', '16:01:10', '-6.4242231', '107.7441839', '31', '-6.4113808', '107.7460409', '1426', '662ee294cfa97.png', '662f61d640f56.png', 1, 4, 2),
(89, 129, '2024-04-29', '06:59:18', '16:00:22', '-6.4241581', '107.7441749', '29', '-6.4241568', '107.744176', '29', '662ee2d6784fd.png', '662f61a6a263f.png', 1, 4, 2),
(90, 131, '2024-04-29', '07:01:46', '16:00:50', '-6.4241664', '107.7438875', '61', '-6.4343484', '107.7460409', '1153', '662ee36a26aa3.png', '662f61c2ec24e.png', 1, 4, 2),
(91, 139, '2024-04-29', '07:02:22', '16:15:07', '-6.424281015203921', '107.74431346591595', '24', '-6.4241382', '107.7441794', '29', '662ee38e16f47.png', '662f651b93314.png', 1, 4, 2),
(92, 146, '2024-04-29', '07:05:59', '16:01:44', '-6.4242071', '107.7441736', '31', '-6.4138403', '107.7486316', '1232', '662ee467d0430.png', '662f61f8da4ad.png', 1, 4, 2),
(93, 137, '2024-04-29', '07:09:47', '16:39:23', '-6.4240412', '107.74423', '24', '-6.4337895', '107.7438204', '1080', '662ee54b7b4e3.png', '662f6acbb4286.png', 1, 4, 2),
(94, 134, '2024-04-29', '07:13:53', '16:30:48', '-6.4244201', '107.7442018', '44', '-6.4242188', '107.7440742', '42', '662ee6418cfcf.png', '662f68c8a7896.png', 1, 4, 2),
(95, 116, '2024-04-29', '07:13:58', '18:33:26', '-6.4242475', '107.7442055', '30', '-6.4244923', '107.7438399', '79', '662ee646c0807.png', '662f858600f8d.png', 1, 4, 2),
(96, 144, '2024-04-29', '07:15:42', '19:57:09', '-6.424036721395759', '107.74423135587139', '24', '-6.424036721395759', '107.74423135587139', '24', '662ee6aee08e2.png', '662f9925778e0.png', 1, 4, 2),
(97, 125, '2024-04-29', '07:17:23', '16:14:48', '-6.4273', '107.74402', '359', '-6.4242651', '107.7442545', '27', '662ee71337cdf.png', '662f65086ec87.png', 1, 4, 2),
(98, 141, '2024-04-29', '07:58:39', '16:30:37', '-6.4242579', '107.74396', '55', '-6.4242633', '107.7439606', '55', '662ef0bf74b40.png', '662f68bd97f57.png', 2, 4, 2),
(99, 143, '2024-04-29', '21:16:12', '', '-6.4241157', '107.7437759', '73', '', '', '', '662fabacc7454.png', '', 2, 0, 1),
(100, 141, '2024-04-30', '05:15:03', '16:46:11', '-6.4242406', '107.7441199', '38', '-6.4242464', '107.7439587', '55', '66301be764359.png', '6630bde3d538c.png', 1, 4, 2),
(101, 95, '2024-04-30', '05:17:42', '', '-6.3562801', '107.764208', '7852', '', '', '', '66301c862e619.png', '', 1, 0, 1),
(102, 136, '2024-04-30', '05:28:09', '20:46:28', '-6.366495', '107.7260565', '6720', '-6.4241369', '107.7439294', '56', '66301ef96e40d.png', '6630f63455de9.png', 1, 4, 2),
(103, 132, '2024-04-30', '06:11:18', '16:02:52', '-6.4242691', '107.7440989', '42', '-6.4241922', '107.7445605', '18', '6630291694878.png', '6630b3bc386eb.png', 1, 4, 2),
(104, 117, '2024-04-30', '06:21:34', '16:00:46', '-6.4242573', '107.7439705', '54', '-6.4242451', '107.7441363', '37', '66302b7ea52fa.png', '6630b33e71b1d.png', 1, 4, 2),
(105, 145, '2024-04-30', '06:22:17', '', '-6.4242477', '107.7440288', '48', '', '', '', '66302ba97391e.png', '', 1, 0, 1),
(106, 137, '2024-04-30', '06:27:44', '16:00:02', '-6.4240456', '107.7442282', '24', '-6.4242538', '107.743971', '54', '66302cf0e2d80.png', '6630b312ef2e9.png', 1, 4, 2),
(107, 112, '2024-04-30', '06:30:16', '17:25:58', '-6.4242266', '107.7440599', '44', '-6.4242509', '107.7440228', '49', '66302d8824fe1.png', '6630c7365dcdf.png', 1, 4, 2),
(108, 118, '2024-04-30', '06:30:37', '18:20:32', '-6.424251', '107.7439666', '54', '-6.4242222', '107.7441919', '30', '66302d9dd760d.png', '6630d4009c841.png', 1, 4, 2),
(109, 125, '2024-04-30', '06:34:19', '16:08:34', '-6.4242114', '107.7441434', '35', '-6.4242355', '107.7440014', '50', '66302e7bc9583.png', '6630b512a99cb.png', 1, 4, 2),
(110, 144, '2024-04-30', '06:36:18', '17:49:59', '-6.424035680667096', '107.74423202524093', '24', '-6.4240474', '107.7442289', '24', '66302ef2e1455.png', '6630ccd7436c8.png', 1, 4, 2),
(111, 121, '2024-04-30', '06:36:40', '16:01:44', '-6.4240472', '107.7442224', '24', '-6.4240456', '107.7442257', '24', '66302f0830339.png', '6630b3782f5aa.png', 1, 4, 2),
(112, 130, '2024-04-30', '07:01:23', '16:00:28', '-6.4242551', '107.7439605', '55', '-6.4242626', '107.7439521', '56', '663034d3552f6.png', '6630b32c151f9.png', 1, 4, 2),
(113, 119, '2024-04-30', '07:03:34', '16:00:08', '-6.4232484', '107.7441905', '99', '-6.4242508', '107.7442097', '30', '66303556e7a94.png', '6630b3180700e.png', 1, 4, 2),
(114, 127, '2024-04-30', '07:04:27', '16:00:32', '-6.4243687', '107.7441033', '47', '-6.4241361', '107.7441824', '28', '6630358b638d6.png', '6630b330cb990.png', 1, 4, 2),
(115, 124, '2024-04-30', '07:05:15', '16:00:18', '-6.4242108', '107.7441812', '31', '-6.424242', '107.7442036', '30', '663035bb8a382.png', '6630b322f322f.png', 1, 4, 2),
(116, 140, '2024-04-30', '07:05:44', '16:02:27', '-6.4240686', '107.7441967', '27', '-6.4240496', '107.7442283', '24', '663035d8e4671.png', '6630b3a3c43c4.png', 1, 4, 2),
(117, 114, '2024-04-30', '07:07:03', '16:01:44', '-6.424254', '107.7440247', '48', '-6.4241283', '107.7448199', '44', '6630362787061.png', '6630b378584d6.png', 1, 4, 2),
(118, 139, '2024-04-30', '07:07:07', '17:19:33', '-6.4242505', '107.744037', '47', '-6.4241627', '107.7441643', '31', '6630362b062f8.png', '6630c5b5775f0.png', 1, 4, 2),
(119, 134, '2024-04-30', '07:08:55', '18:19:51', '-6.4242266', '107.7440716', '43', '-6.4242222', '107.7441919', '30', '6630369754714.png', '6630d3d778ee8.png', 1, 4, 2),
(120, 147, '2024-04-30', '07:10:02', '16:11:37', '-6.4242308', '107.7441097', '39', '-6.4242633', '107.7439732', '54', '663036daac4be.png', '6630b5c944d81.png', 1, 4, 2),
(121, 115, '2024-04-30', '07:14:48', '16:12:17', '-6.425318333333333', '107.74353666666666', '168', '-6.424646666666666', '107.74425833333335', '64', '663037f8ab541.png', '6630b5f1a9ddb.png', 1, 4, 2),
(122, 129, '2024-04-30', '07:14:56', '16:00:50', '-6.4241555', '107.744182', '29', '-6.4254814', '107.7441905', '156', '6630380084861.png', '6630b34221b56.png', 1, 4, 2),
(123, 138, '2024-04-30', '07:23:03', '16:26:23', '-6.424487', '107.7438665', '76', '-6.4242278', '107.7439849', '52', '663039e76dbc9.png', '6630b93f2748e.png', 1, 4, 2),
(124, 120, '2024-04-30', '07:23:34', '16:02:33', '-6.4314216', '107.7386391', '1036', '-6.4244936', '107.74408', '59', '66303a0608d75.png', '6630b3a96433f.png', 1, 4, 2),
(125, 131, '2024-04-30', '07:24:39', '16:04:15', '-6.4343484', '107.7460409', '1153', '-6.4244936', '107.74408', '59', '66303a47d6834.png', '6630b40fe2237.png', 1, 4, 2),
(126, 113, '2024-04-30', '07:29:35', '16:00:16', '-6.4241418', '107.744196', '27', '-6.4243255', '107.7441945', '36', '66303b6fc7cfd.png', '6630b32032739.png', 1, 4, 2),
(127, 146, '2024-04-30', '07:34:20', '16:03:35', '-6.4132156', '107.7482615', '1283', '-6.4242339', '107.7439811', '52', '66303c8c45753.png', '6630b3e71e021.png', 2, 4, 2),
(128, 143, '2024-04-30', '18:02:37', '', '-6.4341876', '107.7415998', '1165', '', '', '', '6630cfcdb17f4.png', '', 2, 0, 1),
(129, 136, '2024-05-01', '06:35:21', '16:42:20', '-6.4242465', '107.7439879', '52', '-6.424254', '107.7440291', '48', '6631803979de4.png', '66320e7c7741c.png', 1, 4, 2),
(130, 143, '2024-05-01', '17:47:02', '', '-6.4242091', '107.7440622', '43', '', '', '', '66321da6d205e.png', '', 2, 0, 1),
(131, 141, '2024-05-02', '05:19:25', '16:46:12', '-6.4242597', '107.7439517', '56', '-6.4242635', '107.7439511', '56', '6632bfedb41e5.png', '663360e4a89b1.png', 1, 4, 2),
(132, 136, '2024-05-02', '06:07:19', '21:59:53', '-6.4242611', '107.7439646', '55', '-6.4162774', '107.7458439', '885', '6632cb2759c2a.png', '6633aa69d52b2.png', 1, 4, 2),
(133, 121, '2024-05-02', '06:16:08', '16:02:05', '-6.4240446', '107.7442331', '23', '-6.4240511', '107.7442283', '24', '6632cd3881696.png', '6633568d8cfa8.png', 1, 4, 2),
(134, 119, '2024-05-02', '06:26:06', '16:00:07', '-6.4341876', '107.7415998', '1165', '-6.4242344', '107.7441444', '35', '6632cf8e7fbbb.png', '6633561743bcf.png', 1, 4, 2),
(135, 120, '2024-05-02', '06:29:00', '16:04:33', '-6.4314216', '107.7386391', '1036', '-6.4314216', '107.7386391', '1036', '6632d03c4c2d5.png', '663357211ee2f.png', 1, 4, 2),
(136, 140, '2024-05-02', '06:29:42', '16:42:26', '-6.4242318', '107.74416', '34', '-6.4242021', '107.7441409', '34', '6632d06679078.png', '6633600223a6e.png', 1, 4, 2),
(137, 131, '2024-05-02', '06:31:12', '16:01:16', '-6.4242343', '107.7440135', '49', '-6.4343089', '107.7471512', '1174', '6632d0c04160c.png', '6633565c979d2.png', 1, 4, 2),
(138, 117, '2024-05-02', '06:35:19', '16:02:00', '-6.4244934', '107.7438542', '78', '-6.4242576', '107.7439595', '55', '6632d1b76f9ad.png', '66335688b7134.png', 1, 4, 2),
(139, 144, '2024-05-02', '06:36:24', '19:14:03', '-6.424035680667096', '107.74423202524093', '24', '-6.424035680667096', '107.74423202524093', '24', '6632d1f8d72c0.png', '6633838b1b652.png', 1, 4, 2),
(140, 142, '2024-05-02', '06:39:13', '16:10:54', '-6.4242772', '107.7441182', '40', '-6.4242492', '107.7442001', '31', '6632d2a1ea144.png', '6633589e7b5cd.png', 1, 4, 2),
(141, 114, '2024-05-02', '06:48:34', '16:04:55', '-6.4242855', '107.7441607', '37', '-6.4241274', '107.7448171', '43', '6632d4d25e2b3.png', '6633573767e09.png', 1, 4, 2),
(142, 147, '2024-05-02', '06:49:31', '', '-6.3854717', '107.7604863', '4648', '', '', '', '6632d50b4ab06.png', '', 1, 0, 1),
(143, 112, '2024-05-02', '06:50:51', '17:48:37', '-6.4242406', '107.7441588', '34', '-6.473833', '107.7452557', '5531', '6632d55b6569e.png', '66336f85daa05.png', 1, 4, 2),
(144, 150, '2024-05-02', '06:50:53', '16:05:39', '-6.4242439', '107.7439633', '55', '-6.4071111', '107.7915737', '5541', '6632d55d28bb8.png', '663357630cf6f.png', 1, 4, 2),
(145, 124, '2024-05-02', '06:51:21', '16:00:52', '-6.4990738', '107.7273321', '8548', '-6.4242436', '107.7441446', '36', '6632d5798a4db.png', '66335644d2e52.png', 1, 4, 2),
(146, 129, '2024-05-02', '06:51:38', '16:00:24', '-6.4242348', '107.7440545', '45', '-6.4242581', '107.7439742', '54', '6632d58ae8d6a.png', '66335628a4c23.png', 1, 4, 2),
(147, 127, '2024-05-02', '06:51:45', '16:00:11', '-6.4242708', '107.7441625', '36', '-6.424205', '107.7440829', '41', '6632d5910af5d.png', '6633561b46130.png', 1, 4, 2),
(148, 113, '2024-05-02', '07:00:41', '16:02:18', '-6.4242578', '107.7440305', '48', '-6.4242337', '107.7442016', '30', '6632d7a9a60ef.png', '6633569a98650.png', 1, 4, 2),
(149, 134, '2024-05-02', '07:01:22', '19:34:45', '-6.4242131', '107.7441848', '30', '-6.445456', '107.7444773', '2375', '6632d7d250265.png', '663388653c69b.png', 1, 4, 2),
(150, 132, '2024-05-02', '07:01:23', '16:01:22', '-6.4242537', '107.7440165', '49', '-6.4138403', '107.7486316', '1232', '6632d7d34fe3a.png', '66335662a7336.png', 1, 4, 2),
(151, 138, '2024-05-02', '07:01:40', '17:01:39', '-6.4245115', '107.7438452', '80', '-6.3920911', '107.7515165', '3645', '6632d7e4c04aa.png', '66336483446f2.png', 1, 4, 2),
(152, 118, '2024-05-02', '07:03:42', '18:12:46', '-6.4242206', '107.7440274', '47', '-6.3980402', '107.7460751', '2904', '6632d85ee7af6.png', '6633752e190a8.png', 1, 4, 2),
(153, 125, '2024-05-02', '07:06:04', '16:03:48', '-6.4242357', '107.7441929', '31', '-6.4242314', '107.7441957', '30', '6632d8ec575cc.png', '663356f4727b4.png', 1, 4, 2),
(154, 139, '2024-05-02', '07:08:52', '16:39:43', '-6.4241829', '107.7441617', '32', '-6.4242546', '107.7439614', '55', '6632d9948eb64.png', '66335f5f6be47.png', 1, 4, 2),
(155, 146, '2024-05-02', '07:09:15', '16:00:31', '-6.4350129', '107.7453007', '1217', '-6.4242246', '107.7441426', '35', '6632d9ab7d4f8.png', '6633562fb9be6.png', 1, 4, 2),
(156, 115, '2024-05-02', '07:10:47', '16:09:47', '-6.424291666666666', '107.74421666666667', '32', '-6.425301666666667', '107.74366666666668', '158', '6632da076caf2.png', '6633585bb0f3a.png', 1, 4, 2),
(157, 137, '2024-05-02', '07:15:14', '19:13:58', '-6.424219', '107.7440571', '44', '-6.4240476', '107.7442285', '24', '6632db128f1fe.png', '6633838614b1d.png', 1, 4, 2),
(158, 122, '2024-05-02', '07:15:35', '16:01:48', '-6.424194', '107.7441053', '38', '-6.424329999999999', '107.74423999999999', '33', '6632db27959ef.png', '6633567c87732.png', 1, 4, 2),
(159, 116, '2024-05-02', '10:13:37', '', '-6.4304176', '107.7432725', '714', '', '', '', '663304e14fe92.png', '', 2, 0, 1),
(160, 143, '2024-05-02', '17:58:04', '19:53:20', '-6.4242855', '107.7439915', '53', '-6.4241851', '107.7438491', '65', '663371bcef02b.png', '66338cc0c62f7.png', 2, 4, 2),
(161, 136, '2024-05-03', '06:10:35', '20:05:17', '-6.424261', '107.7439686', '55', '-6.4242537', '107.743955', '56', '66341d6b9e078.png', '6634e10d0bcc0.png', 1, 4, 2),
(162, 113, '2024-05-03', '06:20:50', '16:00:54', '-6.4241996', '107.7441498', '33', '-6.424242', '107.7441573', '34', '66341fd29aa54.png', '6634a7c68dd56.png', 1, 4, 2),
(163, 146, '2024-05-03', '06:25:48', '16:02:12', '-6.4246246', '107.7437944', '92', '-6.4241184', '107.7438097', '69', '663420fcf2151.png', '6634a814779f9.png', 1, 4, 2),
(164, 117, '2024-05-03', '06:28:55', '16:07:05', '-6.4243784', '107.7437935', '77', '-6.4243317', '107.744195', '37', '663421b786b87.png', '6634a9391392a.png', 1, 4, 2),
(165, 121, '2024-05-03', '06:48:18', '16:01:11', '-6.4240503', '107.7442298', '24', '-6.4240691', '107.7442134', '25', '66342642a4d29.png', '6634a7d72b205.png', 1, 4, 2),
(166, 144, '2024-05-03', '06:53:49', '19:12:40', '-6.424032831037529', '107.74422995121448', '24', '-6.4240441', '107.7442303', '24', '6634278dba5dd.png', '6634d4b80b2d2.png', 1, 4, 2),
(167, 130, '2024-05-03', '06:55:26', '16:03:22', '-6.4242593', '107.7439574', '56', '-6.3854744', '107.7605146', '4649', '663427eea5434.png', '6634a85a00cfa.png', 1, 4, 2),
(168, 127, '2024-05-03', '06:56:25', '16:00:38', '-6.424245', '107.7439651', '54', '-6.424254', '107.744195', '32', '663428294e6bf.png', '6634a7b618933.png', 1, 4, 2),
(169, 140, '2024-05-03', '06:59:26', '18:21:06', '-6.424077', '107.7441954', '27', '-6.4372812', '107.7424968', '1481', '663428de7ffe1.png', '6634c8a274e4d.png', 1, 4, 2),
(170, 150, '2024-05-03', '07:01:19', '16:21:56', '-6.4013051', '107.7693578', '3744', '-6.4028987', '107.7709858', '3765', '6634294f0dd86.png', '6634acb4c3d00.png', 1, 4, 2),
(171, 112, '2024-05-03', '07:01:23', '16:47:14', '-6.4242075', '107.7441614', '32', '-6.42413', '107.7438426', '66', '663429532acda.png', '6634b2a2cddcd.png', 1, 4, 2),
(172, 135, '2024-05-03', '07:08:58', '', '-6.4241992', '107.743945', '55', '', '', '', '66342b1a1ca49.png', '', 1, 0, 1),
(173, 132, '2024-05-03', '07:10:25', '16:02:17', '-6.4242606', '107.7440855', '43', '-6.4243201', '107.7441933', '36', '66342b71907eb.png', '6634a819e5344.png', 1, 4, 2),
(174, 129, '2024-05-03', '07:15:28', '16:00:29', '-6.4242611', '107.7440726', '44', '-6.4351185', '107.74234', '1247', '66342ca017222.png', '6634a7ade4b11.png', 1, 4, 2),
(175, 134, '2024-05-03', '07:17:35', '16:50:51', '-6.4242276', '107.7439953', '51', '-6.4242086', '107.744176', '31', '66342d1f3282e.png', '6634b37b31983.png', 1, 4, 2),
(176, 147, '2024-05-03', '07:18:10', '16:36:28', '-6.4242466', '107.7439723', '54', '-6.4242549', '107.7440812', '43', '66342d425f8f9.png', '6634b01ce3abe.png', 1, 4, 2),
(177, 119, '2024-05-03', '07:20:29', '16:00:41', '-6.424223', '107.7440497', '45', '-6.4242306', '107.7440233', '48', '66342dcd1927f.png', '6634a7b9c89fa.png', 1, 4, 2),
(178, 124, '2024-05-03', '07:20:36', '16:00:53', '-6.424255', '107.7440591', '45', '-6.4241336', '107.7441825', '28', '66342dd4b8c8a.png', '6634a7c50c9f8.png', 1, 4, 2),
(179, 139, '2024-05-03', '07:25:36', '17:15:35', '-6.424316173177312', '107.74449758284874', '25', '-6.424296459741227', '107.74423650627637', '31', '66342f002928f.png', '6634b9473aaf7.png', 1, 4, 2),
(180, 138, '2024-05-03', '07:25:36', '20:01:26', '-6.3920084', '107.7514476', '3652', '-6.3916999', '107.7512091', '3680', '66342f003e54b.png', '6634e02636d16.png', 1, 4, 2),
(181, 115, '2024-05-03', '07:26:47', '16:15:21', '-6.42451', '107.74414333333334', '56', '-6.423725', '107.74489999999999', '67', '66342f479da92.png', '6634ab2932db8.png', 1, 4, 2),
(182, 125, '2024-05-03', '07:27:11', '16:06:12', '-6.4241771', '107.7440801', '40', '-6.4242323', '107.7441989', '30', '66342f5f3cc1f.png', '6634a904576ca.png', 1, 4, 2),
(183, 120, '2024-05-03', '07:28:35', '16:04:26', '-6.4338534', '107.7310903', '1830', '-6.4246273', '107.7438008', '91', '66342fb31a91b.png', '6634a89ac7dfb.png', 1, 4, 2),
(184, 131, '2024-05-03', '07:29:16', '16:00:57', '-6.4343704', '107.7385791', '1312', '-6.4343089', '107.7471512', '1174', '66342fdc9eb1a.png', '6634a7c98e676.png', 1, 4, 2),
(185, 118, '2024-05-03', '07:29:38', '19:22:18', '-6.4244099', '107.7442209', '42', '-6.3890527', '107.7585719', '4199', '66342ff24bc61.png', '6634d6fa26417.png', 1, 4, 2),
(186, 122, '2024-05-03', '07:30:09', '16:00:51', '-6.3971697', '107.7601049', '3460', '-6.424301666666666', '107.744285', '28', '66343011a85f2.png', '6634a7c385231.png', 2, 4, 2),
(187, 114, '2024-05-03', '07:44:31', '16:05:43', '-6.4242489', '107.7441618', '34', '-6.4241279', '107.7448198', '44', '6634336f2dd18.png', '6634a8e754e7b.png', 2, 4, 2),
(188, 141, '2024-05-03', '08:29:01', '16:36:53', '-6.4242596', '107.7439551', '56', '-6.4241593', '107.7441708', '30', '66343ddd38f30.png', '6634b03550e06.png', 2, 4, 2),
(189, 137, '2024-05-03', '09:11:03', '20:35:06', '-6.4242659', '107.7439584', '56', '-6.4240454', '107.7442279', '24', '663447b711178.png', '6634e80a2bcd8.png', 2, 4, 2),
(190, 142, '2024-05-03', '16:15:32', '16:15:41', '-6.4242422', '107.7442008', '30', '-6.4242422', '107.7442008', '30', '6634ab34b0c3c.png', '6634ab3d3523f.png', 2, 4, 2),
(191, 143, '2024-05-04', '17:44:54', '', '-6.4241892', '107.7438783', '62', '', '', '', '663611a654f7a.png', '', 2, 0, 1),
(192, 141, '2024-05-06', '05:35:47', '17:41:46', '-6.4242561', '107.7439978', '51', '-6.4242383', '107.7439861', '52', '663809c36def5.png', '6638b3eabd9e8.png', 1, 4, 2),
(193, 117, '2024-05-06', '05:51:17', '16:02:00', '-6.4242218', '107.7440321', '47', '-6.4242696', '107.7441866', '33', '66380d65b8233.png', '66389c88e9457.png', 1, 4, 2),
(194, 136, '2024-05-06', '06:12:53', '19:58:04', '-6.4242385', '107.743993', '51', '-6.4242642', '107.7440349', '48', '66381275710ee.png', '6638d3dc78216.png', 1, 4, 2),
(195, 123, '2024-05-06', '06:15:23', '16:12:21', '-6.4242343', '107.7440019', '50', '-6.424389', '107.7442313', '39', '6638130be129c.png', '66389ef5bf737.png', 1, 4, 2),
(196, 135, '2024-05-06', '06:17:19', '16:08:24', '-6.5042003', '107.7757737', '9556', '-6.5058976', '107.7740365', '9665', '6638137fb5667.png', '66389e0837ecf.png', 1, 4, 2),
(197, 138, '2024-05-06', '06:25:28', '16:24:06', '-6.3920949', '107.7515164', '3645', '-6.424289', '107.7441736', '36', '66381568ade58.png', '6638a1b60f853.png', 1, 4, 2),
(198, 112, '2024-05-06', '06:34:34', '17:35:46', '-6.4241941', '107.744157', '32', '-6.424236', '107.7441191', '38', '6638178a9d306.png', '6638b28246ac3.png', 1, 4, 2),
(199, 144, '2024-05-06', '06:36:04', '18:25:56', '-6.4205957', '107.7517891', '902', '-6.4205957', '107.7517891', '902', '663817e43b1dd.png', '6638be441dbec.png', 1, 4, 2),
(200, 150, '2024-05-06', '06:36:36', '16:02:37', '-6.4029005', '107.7709777', '3764', '-6.4240931', '107.7442163', '24', '66381804ae7df.png', '66389cad9803b.png', 1, 4, 2),
(201, 115, '2024-05-06', '06:38:52', '16:10:30', '-6.423749999999999', '107.74390999999999', '70', '-6.425688333333333', '107.74405999999999', '181', '6638188c044f2.png', '66389e86338c1.png', 1, 4, 2),
(202, 114, '2024-05-06', '06:41:46', '16:01:12', '-6.424214', '107.7440979', '39', '-6.4241262', '107.7448394', '46', '6638193a22a10.png', '66389c5877f59.png', 1, 4, 2),
(203, 119, '2024-05-06', '06:45:02', '16:00:40', '-6.4241661', '107.7441706', '30', '-6.4241959', '107.7440968', '39', '663819fe9bb97.png', '66389c383f387.png', 1, 4, 2),
(204, 127, '2024-05-06', '06:48:59', '16:00:29', '-6.4242452', '107.7440154', '49', '-6.4241605', '107.7441992', '27', '66381aebe3b9c.png', '66389c2de1289.png', 1, 4, 2),
(205, 129, '2024-05-06', '06:49:04', '16:00:23', '-6.4242343', '107.7441944', '30', '-6.4241264', '107.7441898', '27', '66381af0960fc.png', '66389c2769103.png', 1, 4, 2),
(206, 121, '2024-05-06', '06:49:07', '16:02:17', '-6.4240362', '107.7442276', '24', '-6.4241082', '107.7441218', '35', '66381af3966c4.png', '66389c995df48.png', 1, 4, 2),
(207, 122, '2024-05-06', '06:50:07', '16:03:33', '-6.4241892', '107.7440907', '39', '-6.424183333333334', '107.74424499999999', '23', '66381b2f7031f.png', '66389ce541154.png', 1, 4, 2),
(208, 134, '2024-05-06', '06:51:53', '17:43:08', '-6.4242469', '107.7439585', '55', '-6.4242428', '107.7439836', '52', '66381b9961345.png', '6638b43c27118.png', 1, 4, 2),
(209, 113, '2024-05-06', '06:53:08', '16:02:23', '-6.424265', '107.7441222', '39', '-6.4241175', '107.7448235', '44', '66381be4ad4a0.png', '66389c9f4b419.png', 1, 4, 2),
(210, 130, '2024-05-06', '06:57:05', '16:37:47', '-6.4242597', '107.7439606', '55', '-6.394251', '107.7559519', '3555', '66381cd112949.png', '6638a4ebad9a8.png', 1, 4, 2),
(211, 118, '2024-05-06', '06:57:36', '17:42:40', '-6.424262', '107.7439575', '56', '-6.4242572', '107.7441379', '37', '66381cf02fd64.png', '6638b42034681.png', 1, 4, 2),
(212, 147, '2024-05-06', '06:58:33', '16:11:54', '-6.4242543', '107.7439594', '55', '-6.3854695', '107.7606837', '4656', '66381d299341e.png', '66389eda8d544.png', 1, 4, 2),
(213, 124, '2024-05-06', '07:00:08', '16:06:05', '-6.4240896', '107.7442076', '25', '-6.4240845', '107.744214', '25', '66381d88ebddf.png', '66389d7d030b2.png', 1, 4, 2),
(214, 145, '2024-05-06', '07:00:41', '16:08:26', '-6.4241648', '107.7441393', '33', '-6.4242591', '107.7439558', '56', '66381da970b4e.png', '66389e0ac4c38.png', 1, 4, 2),
(215, 132, '2024-05-06', '07:01:38', '16:02:13', '-6.4241781', '107.7441141', '37', '-6.4113808', '107.7460409', '1426', '66381de2717c0.png', '66389c957d68a.png', 1, 4, 2),
(216, 125, '2024-05-06', '07:04:59', '16:01:31', '-6.4243748', '107.7441369', '45', '-6.4242328', '107.7441902', '31', '66381eabd473d.png', '66389c6b249d5.png', 1, 4, 2),
(217, 120, '2024-05-06', '07:06:32', '16:01:52', '-6.4343324', '107.7342579', '1600', '-6.4245074', '107.7440854', '59', '66381f08dd343.png', '66389c802fb3a.png', 1, 4, 2),
(218, 131, '2024-05-06', '07:07:14', '16:03:28', '-6.4343324', '107.7342579', '1600', '-6.4343089', '107.7471512', '1174', '66381f321af0b.png', '66389ce080256.png', 1, 4, 2),
(219, 146, '2024-05-06', '07:17:06', '16:03:21', '-6.4337763', '107.7441905', '1076', '-6.4242525', '107.744155', '35', '66382182a5600.png', '66389cd94a656.png', 1, 4, 2),
(220, 137, '2024-05-06', '07:21:25', '17:44:38', '-6.4240436', '107.7442296', '24', '-6.4242465', '107.7439785', '53', '663822854497a.png', '6638b496936b0.png', 1, 4, 2),
(221, 140, '2024-05-06', '07:26:37', '16:09:58', '-6.4241015', '107.7441934', '27', '-6.424044999999999', '107.74429666666668', '17', '663823bd0de47.png', '66389e66f2fc3.png', 1, 4, 2),
(222, 139, '2024-05-06', '07:33:52', '', '-6.356074985076495', '107.76487057475664', '7895', '', '', '', '66382570199fc.png', '', 2, 0, 1),
(223, 142, '2024-05-06', '16:03:59', '16:04:28', '-6.4242368', '107.7442095', '29', '-6.4242368', '107.7442095', '29', '66389cff3e356.png', '66389d1c6b344.png', 2, 4, 2),
(224, 141, '2024-05-07', '05:59:14', '17:24:57', '-6.4240491', '107.7442325', '23', '-6.424262', '107.7439655', '55', '663960c2c03eb.png', '663a017917f01.png', 1, 4, 2),
(225, 112, '2024-05-07', '06:06:25', '16:04:19', '-6.4242511', '107.7439996', '51', '-6.4241739', '107.7441874', '29', '6639627103187.png', '6639ee93a610d.png', 1, 4, 2),
(226, 136, '2024-05-07', '06:23:01', '17:45:13', '-6.4242587', '107.7439591', '55', '-6.4242537', '107.7439573', '55', '66396655f1c50.png', '663a0639c4b48.png', 1, 4, 2),
(227, 122, '2024-05-07', '06:29:40', '16:07:19', '-6.424253333333334', '107.74398166666667', '53', '-6.4242433', '107.7442098', '30', '663967e4bc08d.png', '6639ef47b8565.png', 1, 4, 2),
(228, 144, '2024-05-07', '06:30:32', '19:20:46', '-6.4205957', '107.7517891', '902', '-6.424040653051009', '107.74423425638834', '23', '66396818a9bf7.png', '663a1c9e4b200.png', 1, 4, 2),
(229, 117, '2024-05-07', '06:30:34', '16:14:03', '-6.424491', '107.7438729', '76', '-6.4243123', '107.7442091', '34', '6639681a466ef.png', '6639f0db8d06a.png', 1, 4, 2),
(230, 132, '2024-05-07', '06:33:06', '16:01:46', '-6.4242205', '107.7441894', '30', '-6.4138272', '107.7490017', '1250', '663968b21c5c3.png', '6639edfa9858b.png', 1, 4, 2),
(231, 118, '2024-05-07', '06:40:23', '17:40:02', '-6.4242432', '107.7440254', '48', '-6.4242545', '107.7442004', '31', '66396a6734f9b.png', '663a050223002.png', 1, 4, 2),
(232, 135, '2024-05-07', '06:40:39', '', '-6.5041864', '107.7757832', '9555', '', '', '', '66396a77046ef.png', '', 1, 0, 1),
(233, 121, '2024-05-07', '06:45:05', '16:02:01', '-6.4241954', '107.7441793', '30', '-6.4240467', '107.7442279', '24', '66396b814890f.png', '6639ee099380c.png', 1, 4, 2),
(234, 130, '2024-05-07', '06:50:04', '', '-6.39426', '107.7559413', '3554', '', '', '', '66396cac56638.png', '', 1, 0, 1),
(235, 129, '2024-05-07', '06:56:59', '16:00:16', '-6.4242546', '107.7440663', '44', '-6.4240972', '107.7442206', '24', '66396e4b3af6b.png', '6639eda051ea4.png', 1, 4, 2),
(236, 140, '2024-05-07', '06:57:13', '16:21:44', '-6.4241732', '107.744038', '45', '-6.4240425', '107.7442289', '24', '66396e59bd5c5.png', '6639f2a83104c.png', 1, 4, 2),
(237, 127, '2024-05-07', '06:58:12', '16:00:50', '-6.4242764', '107.7441222', '40', '-6.4242233', '107.7441319', '36', '66396e9451def.png', '6639edc2a5511.png', 1, 4, 2),
(238, 142, '2024-05-07', '07:13:30', '', '-6.424237', '107.7442079', '29', '', '', '', '6639722a25e6f.png', '', 1, 0, 1),
(239, 120, '2024-05-07', '07:16:40', '16:01:59', '-6.4351473', '107.7504821', '1399', '-6.4246262', '107.7438005', '91', '663972e846eb4.png', '6639ee0764832.png', 1, 4, 2),
(240, 131, '2024-05-07', '07:17:24', '16:06:07', '-6.4347478', '107.7343232', '1628', '-6.4245082', '107.743835', '80', '6639731415c05.png', '6639eeff1f85b.png', 1, 4, 2),
(241, 139, '2024-05-07', '07:19:16', '17:22:52', '-6.356076680287244', '107.76487164699515', '7894', '-6.424177376075728', '107.74418107860122', '29', '6639738466c57.png', '663a00fc0a45e.png', 1, 4, 2),
(242, 134, '2024-05-07', '07:21:39', '17:40:21', '-6.4242986', '107.7441791', '36', '-6.4242596', '107.7440481', '46', '663974139c228.png', '663a0515ab837.png', 1, 4, 2),
(243, 150, '2024-05-07', '07:23:36', '16:01:15', '-6.4028648', '107.7709814', '3767', '-6.4240619', '107.7442202', '24', '663974884baac.png', '6639eddb1f76c.png', 1, 4, 2),
(244, 145, '2024-05-07', '07:25:29', '16:57:01', '-6.424232', '107.744038', '46', '-6.424047', '107.7442322', '23', '663974f993315.png', '6639faedc9a25.png', 1, 4, 2),
(245, 124, '2024-05-07', '07:26:16', '16:00:36', '-6.4469514', '107.7415998', '2560', '-6.4240537', '107.7442268', '24', '663975281db38.png', '6639edb4d3408.png', 1, 4, 2),
(246, 115, '2024-05-07', '07:27:43', '16:05:36', '-6.4250316666666665', '107.74360833333334', '138', '-6.4246262', '107.7438005', '91', '6639757f5f696.png', '6639eee070b27.png', 1, 4, 2),
(247, 113, '2024-05-07', '07:28:33', '16:07:02', '-6.4244223', '107.744133', '49', '-6.4242458', '107.7442025', '30', '663975b189879.png', '6639ef369c0c5.png', 1, 4, 2),
(248, 146, '2024-05-07', '07:34:37', '16:14:27', '-6.4241124', '107.7437897', '71', '-6.4443229', '107.7453041', '2251', '6639771d9449b.png', '6639f0f38c115.png', 2, 4, 2),
(249, 138, '2024-05-07', '07:35:27', '23:09:39', '-6.3920924', '107.7515149', '3645', '-6.3921029', '107.7515096', '3644', '6639774fde1f3.png', '663a524385078.png', 2, 4, 2),
(250, 137, '2024-05-07', '07:47:35', '', '-6.424254', '107.7440835', '42', '', '', '', '66397a27309e9.png', '', 2, 0, 1),
(251, 114, '2024-05-07', '07:53:41', '16:11:09', '-6.4242498', '107.7440404', '47', '-6.4241344', '107.7448583', '48', '66397b951c44f.png', '6639f02d6510c.png', 2, 4, 2),
(252, 143, '2024-05-07', '17:44:34', '', '-6.4241577', '107.7437902', '72', '', '', '', '663a061202a71.png', '', 2, 0, 1),
(253, 127, '2024-05-08', '06:01:14', '16:00:53', '-6.4241882', '107.7439418', '55', '-6.4241784', '107.744167', '31', '663ab2baae06a.png', '663b3f450b2ec.png', 1, 4, 2),
(254, 134, '2024-05-08', '06:01:51', '', '-6.4242392', '107.7440285', '48', '', '', '', '663ab2dfc55e6.png', '', 1, 0, 1),
(255, 124, '2024-05-08', '06:21:23', '16:00:58', '-6.4242478', '107.744026', '48', '-6.4240685', '107.7442206', '24', '663ab773b98fc.png', '663b3f4a62a2e.png', 1, 4, 2),
(256, 136, '2024-05-08', '06:27:06', '', '-6.4242547', '107.7439605', '55', '', '', '', '663ab8cad0b53.png', '', 1, 0, 1),
(257, 129, '2024-05-08', '06:32:42', '16:00:54', '-6.4241936', '107.7439857', '51', '-6.4240544', '107.7442122', '25', '663aba1aaa747.png', '663b3f46df018.png', 1, 4, 2),
(258, 117, '2024-05-08', '06:37:46', '16:07:08', '-6.4244948', '107.7438475', '78', '-6.4243342', '107.7442099', '36', '663abb4ada0e0.png', '663b40bcce251.png', 1, 4, 2),
(259, 121, '2024-05-08', '06:51:53', '16:02:18', '-6.4240461', '107.7442251', '24', '-6.4240498', '107.7442346', '23', '663abe9951758.png', '663b3f9ae6440.png', 1, 4, 2),
(260, 123, '2024-05-08', '06:55:27', '16:41:43', '-6.424344', '107.744198', '38', '-6.4243498', '107.7442191', '37', '663abf6f88a53.png', '663b48d7a658f.png', 1, 4, 2),
(261, 141, '2024-05-08', '07:00:23', '17:16:11', '-6.4242603', '107.743953', '56', '-6.4243613', '107.7438174', '74', '663ac0974ee56.png', '663b50eb8c5c3.png', 1, 4, 2),
(262, 140, '2024-05-08', '07:01:33', '', '-6.4240483', '107.7442334', '23', '', '', '', '663ac0dd80af2.png', '', 1, 0, 1),
(263, 144, '2024-05-08', '07:04:28', '19:10:42', '-6.4240584', '107.7442234', '24', '-6.4240446', '107.7442275', '24', '663ac18cb27cc.png', '663b6bc2d02a6.png', 1, 4, 2),
(264, 139, '2024-05-08', '07:11:46', '', '-6.356052317037709', '107.76487404840971', '7897', '', '', '', '663ac3429f580.png', '', 1, 0, 1),
(265, 132, '2024-05-08', '07:12:36', '16:01:48', '-6.4351185', '107.74234', '1247', '-6.4162176', '107.7445605', '877', '663ac3743459d.png', '663b3f7cdcf64.png', 1, 4, 2),
(266, 112, '2024-05-08', '07:14:16', '16:49:22', '-6.4432375', '107.7311844', '2583', '-6.424247', '107.7439882', '52', '663ac3d86e4d1.png', '663b4aa2d502f.png', 1, 4, 2),
(267, 130, '2024-05-08', '07:15:53', '', '-6.424248', '107.7439836', '53', '', '', '', '663ac43954e55.png', '', 1, 0, 1),
(268, 118, '2024-05-08', '07:16:03', '17:31:46', '-6.4240505', '107.7442301', '23', '-6.4243732', '107.7442447', '37', '663ac44366e01.png', '663b5492ad15a.png', 1, 4, 2),
(269, 150, '2024-05-08', '07:17:12', '16:02:09', '-6.4030755', '107.7710499', '3758', '-6.4246265', '107.7438004', '91', '663ac48846fd4.png', '663b3f914e0e0.png', 1, 4, 2),
(270, 135, '2024-05-08', '07:21:08', '', '-6.4493988', '107.7445605', '2813', '', '', '', '663ac5742d453.png', '', 1, 0, 1),
(271, 113, '2024-05-08', '07:21:10', '16:02:42', '-6.4241745', '107.7441752', '30', '-6.424115', '107.74481', '42', '663ac576790be.png', '663b3fb2b7245.png', 1, 4, 2),
(272, 120, '2024-05-08', '07:22:53', '16:04:08', '-6.4325531', '107.7173688', '3135', '-6.4352529', '107.7475213', '1286', '663ac5ddce073.png', '663b40080eeae.png', 1, 4, 2),
(273, 131, '2024-05-08', '07:23:39', '16:06:57', '-6.4325531', '107.7173688', '3135', '-6.4247067', '107.743776', '99', '663ac60bd240e.png', '663b40b193c31.png', 1, 4, 2),
(274, 122, '2024-05-08', '07:26:15', '16:01:51', '-6.4242054', '107.7441905', '29', '-6.4242115', '107.7441979', '29', '663ac6a7467e3.png', '663b3f7fe18b0.png', 1, 4, 2),
(275, 146, '2024-05-08', '07:30:27', '16:26:21', '-6.4341569', '107.742624', '1136', '-6.4240946', '107.744217', '24', '663ac7a3a15bc.png', '663b453dbb431.png', 2, 4, 2),
(276, 138, '2024-05-08', '07:30:41', '16:51:27', '-6.3920542', '107.751517', '3649', '-6.4242199', '107.7439837', '52', '663ac7b18c9ad.png', '663b4b1fecf2c.png', 2, 4, 2),
(277, 115, '2024-05-08', '07:34:37', '16:08:00', '-6.4242574', '107.7439543', '56', '-6.426223333333334', '107.74265833333332', '307', '663ac89daf9a8.png', '663b40f0f15c5.png', 2, 4, 2),
(278, 125, '2024-05-08', '07:35:25', '16:23:54', '-6.4242352', '107.7443313', '19', '-6.4242294', '107.7442078', '29', '663ac8cd17cb4.png', '663b44aa4d48c.png', 2, 4, 2),
(279, 114, '2024-05-08', '07:52:10', '16:02:46', '-6.424247', '107.7441877', '32', '-6.424138', '107.7448258', '44', '663accba37149.png', '663b3fb67bf18.png', 2, 4, 2),
(280, 137, '2024-05-08', '16:02:16', '16:02:23', '-6.4240419', '107.744222', '25', '-6.4240419', '107.744222', '25', '663b3f989d277.png', '663b3f9f98774.png', 2, 4, 2),
(281, 142, '2024-05-08', '16:04:52', '16:05:19', '-6.4242272', '107.7442182', '28', '-6.4242272', '107.7442182', '28', '663b40342606c.png', '663b404f784a1.png', 2, 4, 2),
(282, 143, '2024-05-08', '17:58:41', '', '-6.4243535', '107.7440233', '53', '', '', '', '663b5ae144fd2.png', '', 2, 0, 1),
(283, 143, '2024-05-09', '17:54:50', '', '-6.4243119', '107.7439619', '57', '', '', '', '663cab7acda3f.png', '', 2, 0, 1),
(284, 136, '2024-05-10', '07:10:41', '20:59:55', '-6.4242503', '107.7439712', '54', '-6.4242457', '107.7441863', '32', '663d6601673fe.png', '663e285bb93d6.png', 1, 4, 2),
(285, 143, '2024-05-11', '17:50:16', '', '-6.4242271', '107.7439208', '59', '', '', '', '663f4d68431d8.png', '', 2, 0, 1),
(286, 143, '2024-05-12', '18:01:24', '', '-6.4241731', '107.7439152', '58', '', '', '', '6640a18422a3b.png', '', 2, 0, 1),
(287, 141, '2024-05-13', '05:31:53', '16:49:48', '-6.4240515', '107.7442341', '23', '-6.4243985', '107.7438178', '76', '664143590c631.png', '6641e23c672f5.png', 1, 4, 2),
(288, 117, '2024-05-13', '05:57:52', '16:08:21', '-6.4242538', '107.7440043', '51', '-6.4244685', '107.7437154', '89', '66414970bcd91.png', '6641d8857a9cd.png', 1, 4, 2),
(289, 123, '2024-05-13', '06:07:38', '', '-6.4242431', '107.743986', '52', '', '', '', '66414bbac8c5b.png', '', 1, 0, 1),
(290, 136, '2024-05-13', '06:14:19', '18:18:58', '-6.4242502', '107.7439629', '55', '-6.424261', '107.7439594', '56', '66414d4bc8300.png', '6641f72242ca9.png', 1, 4, 2),
(291, 138, '2024-05-13', '06:27:20', '', '-6.3920851', '107.7515212', '3646', '', '', '', '66415058b5b2f.png', '', 1, 0, 1),
(292, 112, '2024-05-13', '06:30:55', '20:30:15', '-6.4242165', '107.74416', '33', '-6.4512362', '107.7020032', '5575', '6641512f2cf0d.png', '664215e7bec24.png', 1, 4, 2),
(293, 150, '2024-05-13', '06:38:02', '16:01:20', '-6.4029047', '107.771005', '3766', '-6.4241149', '107.7441986', '26', '664152da09f03.png', '6641d6e0abb34.png', 1, 4, 2),
(294, 115, '2024-05-13', '06:40:47', '16:16:28', '-6.424176666666667', '107.74402166666665', '46', '-6.4242559', '107.7440549', '45', '6641537f8d153.png', '6641da6c52ed3.png', 1, 4, 2),
(295, 145, '2024-05-13', '06:43:03', '16:29:21', '-6.4242088', '107.7441448', '34', '-6.4240437', '107.7442328', '23', '664154076bc17.png', '6641dd715c657.png', 1, 4, 2),
(296, 129, '2024-05-13', '06:47:52', '16:00:42', '-6.4242402', '107.7440828', '42', '-6.4241908', '107.7442045', '27', '664155283da5b.png', '6641d6bae5af4.png', 1, 4, 2),
(297, 114, '2024-05-13', '06:48:48', '16:01:55', '-6.424132', '107.7441337', '34', '-6.424133', '107.7448409', '46', '66415560815b9.png', '6641d7030d25a.png', 1, 4, 2),
(298, 127, '2024-05-13', '06:50:26', '16:00:58', '-6.4242152', '107.7441528', '34', '-6.4241373', '107.7442047', '26', '664155c223c75.png', '6641d6ca8c2e6.png', 1, 4, 2),
(299, 121, '2024-05-13', '06:50:48', '16:02:47', '-6.4240496', '107.7442262', '24', '-6.424042', '107.7442223', '25', '664155d86a6bd.png', '6641d7376a3ea.png', 1, 4, 2),
(300, 124, '2024-05-13', '06:52:43', '16:04:40', '-6.4242077', '107.7440797', '41', '-6.4240651', '107.7442136', '25', '6641564b5ca5b.png', '6641d7a807390.png', 1, 4, 2),
(301, 113, '2024-05-13', '06:54:49', '', '-6.4241586', '107.744142', '33', '', '', '', '664156c9bd573.png', '', 1, 0, 1),
(302, 130, '2024-05-13', '06:57:46', '15:58:13', '-6.4242382', '107.7440844', '42', '-6.3751086', '107.7335197', '5580', '6641577aed59b.png', '6641d6255a8ff.png', 1, 3, 2),
(303, 140, '2024-05-13', '07:02:08', '16:28:56', '-6.424093', '107.744218', '24', '-6.4240602', '107.7442416', '22', '66415880733ee.png', '6641dd5881895.png', 1, 4, 2),
(304, 132, '2024-05-13', '07:02:48', '16:02:19', '-6.4242152', '107.7441588', '33', '-6.4162176', '107.7445605', '877', '664158a849544.png', '6641d71b997b7.png', 1, 4, 2),
(305, 122, '2024-05-13', '07:03:51', '16:02:12', '-6.4361152', '107.7412297', '1382', '-6.42419', '107.744135', '35', '664158e7d3891.png', '6641d71474fdd.png', 1, 4, 2),
(306, 146, '2024-05-13', '07:04:02', '16:07:25', '-6.4244012', '107.7438176', '76', '-6.4242182', '107.7441357', '36', '664158f2cd943.png', '6641d84d60492.png', 1, 4, 2),
(307, 147, '2024-05-13', '07:04:36', '16:25:00', '-6.4242564', '107.7439978', '51', '-6.4243434', '107.7442067', '37', '664159141e129.png', '6641dc6ca50a4.png', 1, 4, 2),
(308, 134, '2024-05-13', '07:11:52', '', '-6.424202', '107.7441876', '30', '', '', '', '66415ac8b9a89.png', '', 1, 0, 1),
(309, 118, '2024-05-13', '07:12:13', '', '-6.4243567', '107.7442125', '38', '', '', '', '66415add9cdef.png', '', 1, 0, 1),
(310, 125, '2024-05-13', '07:12:25', '16:08:49', '-6.4242321', '107.7442024', '30', '-6.424301', '107.7442048', '34', '66415ae99d9de.png', '6641d8a16bd1c.png', 1, 4, 2),
(311, 120, '2024-05-13', '07:13:21', '16:13:33', '-6.4351473', '107.7504821', '1399', '-6.4244829', '107.7440855', '57', '66415b210c6b7.png', '6641d9bd78df9.png', 1, 4, 2),
(312, 139, '2024-05-13', '07:14:26', '17:37:01', '-6.424161', '107.7441767', '29', '-6.4241686', '107.7441734', '30', '66415b6294333.png', '6641ed4d189a8.png', 1, 4, 2),
(313, 137, '2024-05-13', '07:19:41', '', '-6.4242569', '107.743947', '57', '', '', '', '66415c9d478d5.png', '', 1, 0, 1),
(314, 135, '2024-05-13', '09:20:52', '', '-6.4244167', '107.7441812', '45', '', '', '', '6641790424bce.png', '', 2, 0, 1),
(315, 141, '2024-05-14', '06:13:42', '16:20:36', '-6.4242478', '107.7442098', '30', '-6.4245198', '107.74384', '81', '66429ea69b708.png', '66432ce4545b8.png', 1, 4, 2),
(316, 136, '2024-05-14', '06:20:13', '', '-6.4241978', '107.7439006', '60', '', '', '', '6642a02d1c7b1.png', '', 1, 0, 1),
(317, 117, '2024-05-14', '06:28:50', '16:00:37', '-6.4242377', '107.7440176', '49', '-6.4242151', '107.7440066', '49', '6642a23277d9b.png', '66432835c1c08.png', 1, 4, 2),
(318, 132, '2024-05-14', '06:33:08', '16:03:43', '-6.4242676', '107.7441633', '35', '-6.4232352', '107.7445605', '98', '6642a3342faaf.png', '664328ef29e3b.png', 1, 4, 2),
(319, 118, '2024-05-14', '06:34:15', '17:41:23', '-6.4241839', '107.7441473', '33', '-6.3890573', '107.7585784', '4199', '6642a377531c8.png', '66433fd3d7706.png', 1, 4, 2),
(320, 122, '2024-05-14', '06:39:23', '16:04:19', '-6.4159776', '107.74234', '933', '-6.4242204', '107.7441916', '30', '6642a4ab1ce4c.png', '6643291349ea9.png', 1, 4, 2),
(321, 145, '2024-05-14', '06:48:28', '16:23:28', '-6.4240446', '107.7442317', '24', '-6.4242012', '107.7441579', '33', '6642a6cc92c49.png', '66432d9097eca.png', 1, 4, 2),
(322, 121, '2024-05-14', '06:49:17', '16:01:44', '-6.4241648', '107.7441089', '37', '-6.4242265', '107.7441746', '32', '6642a6fd2816a.png', '664328784a25c.png', 1, 4, 2),
(323, 113, '2024-05-14', '06:50:16', '', '-6.3933133', '107.74877', '3457', '', '', '', '6642a73857701.png', '', 1, 0, 1),
(324, 123, '2024-05-14', '06:51:04', '16:05:43', '-6.4242369', '107.7439971', '51', '-6.4243294', '107.7442086', '36', '6642a768338c8.png', '664329675ebe6.png', 1, 4, 2),
(325, 112, '2024-05-14', '06:52:41', '19:36:45', '-6.4242268', '107.7441323', '36', '-6.4502654', '107.6971122', '5984', '6642a7c902a78.png', '66435addeb181.png', 1, 4, 2),
(326, 114, '2024-05-14', '06:53:55', '15:06:04', '-6.4241877', '107.7442081', '27', '-6.424113', '107.744509', '9', '6642a81332f66.png', '66431b6c7da60.png', 1, 3, 2),
(327, 140, '2024-05-14', '06:56:13', '16:04:47', '-6.4241977', '107.7441448', '34', '-6.4240474', '107.7442396', '23', '6642a89d52ba6.png', '6643292f972d7.png', 1, 4, 2),
(328, 130, '2024-05-14', '07:01:08', '15:59:24', '-6.3942736', '107.755938', '3553', '-6.4241326', '107.7448407', '46', '6642a9c47ee73.png', '664327ec06b1e.png', 1, 3, 2),
(329, 127, '2024-05-14', '07:13:03', '16:00:42', '-6.4242345', '107.7441923', '31', '-6.4241796', '107.7441848', '29', '6642ac8f22fb9.png', '6643283a17641.png', 1, 4, 2),
(330, 120, '2024-05-14', '07:16:14', '16:05:17', '-6.424236', '107.7441666', '33', '-6.4247625', '107.743749', '106', '6642ad4eae9e9.png', '6643294d1b9eb.png', 1, 4, 2),
(331, 129, '2024-05-14', '07:16:28', '16:00:29', '-6.4242836', '107.7442075', '32', '-6.4241193', '107.7441637', '30', '6642ad5c25c46.png', '6643282dd86e0.png', 1, 4, 2),
(332, 135, '2024-05-14', '07:18:45', '', '-6.4883963', '107.7598861', '7350', '', '', '', '6642ade5b9e2e.png', '', 1, 0, 1),
(333, 150, '2024-05-14', '07:19:21', '16:01:34', '-6.4029045', '107.770986', '3764', '-6.4241369', '107.744232', '23', '6642ae0980583.png', '6643286e1521b.png', 1, 4, 2),
(334, 139, '2024-05-14', '07:19:38', '', '-6.4242046537018', '107.7441893443594', '30', '', '', '', '6642ae1a6143a.png', '', 1, 0, 1),
(335, 138, '2024-05-14', '07:19:51', '16:06:12', '-6.3920861', '107.7515165', '3646', '-6.4245123', '107.7438377', '80', '6642ae275641e.png', '664329848bf16.png', 1, 4, 2),
(336, 147, '2024-05-14', '07:25:11', '16:24:12', '-6.4242585', '107.743962', '55', '-6.4243711', '107.7442193', '38', '6642af673fc94.png', '66432dbc512c1.png', 1, 4, 2),
(337, 134, '2024-05-14', '07:26:13', '', '-6.4472177', '107.7430802', '2575', '', '', '', '6642afa5a0511.png', '', 1, 0, 1),
(338, 115, '2024-05-14', '07:27:46', '16:09:32', '-6.4242539', '107.7439534', '56', '-6.4247625', '107.743749', '106', '6642b00282657.png', '66432a4cc56ed.png', 1, 4, 2),
(339, 124, '2024-05-14', '07:28:44', '16:00:32', '-6.42428', '107.7441456', '38', '-6.4241137', '107.744201', '26', '6642b03c0b23b.png', '664328306b0e4.png', 1, 4, 2),
(340, 146, '2024-05-14', '07:32:16', '17:09:13', '-6.4462604', '107.7430802', '2469', '-6.424153', '107.7438207', '68', '6642b110d5108.png', '6643384996320.png', 2, 4, 2),
(341, 143, '2024-05-14', '17:39:45', '', '-6.4241594', '107.7439886', '50', '', '', '', '66433f71aeb2a.png', '', 2, 0, 1),
(342, 141, '2024-05-15', '06:18:55', '17:59:34', '-6.4242624', '107.7439552', '56', '-6.4242624', '107.7439552', '56', '6643f15f3fd83.png', '66449596700a2.png', 1, 4, 2),
(343, 134, '2024-05-15', '06:25:47', '16:45:29', '-6.4242632', '107.7440626', '45', '-6.4244016', '107.7442063', '42', '6643f2fbdf5f1.png', '664484391b697.png', 1, 4, 2),
(344, 129, '2024-05-15', '06:27:28', '16:00:52', '-6.424223', '107.7441095', '38', '-6.4241165', '107.7442138', '25', '6643f360e2ea3.png', '664479c4d5def.png', 1, 4, 2),
(345, 136, '2024-05-15', '06:27:45', '', '-6.4242213', '107.7441943', '30', '', '', '', '6643f3717540d.png', '', 1, 0, 1),
(346, 147, '2024-05-15', '06:29:05', '16:07:55', '-6.4242634', '107.7439674', '55', '-6.4243563', '107.7442202', '37', '6643f3c11c6fe.png', '66447b6b7d144.png', 1, 4, 2),
(347, 127, '2024-05-15', '06:31:52', '16:00:37', '-6.4241969', '107.7440642', '42', '-6.4241261', '107.7441844', '28', '6643f4684d786.png', '664479b514779.png', 1, 4, 2),
(348, 139, '2024-05-15', '06:35:55', '', '-6.424219376938756', '107.74429262924879', '21', '', '', '', '6643f55b51643.png', '', 1, 0, 1),
(349, 132, '2024-05-15', '06:37:32', '16:01:52', '-6.4241683', '107.7439571', '53', '-6.4158724', '107.7453007', '921', '6643f5bc6706e.png', '66447a0045af4.png', 1, 4, 2),
(350, 124, '2024-05-15', '06:41:32', '16:01:03', '-6.4241863', '107.7440984', '38', '-6.4241973', '107.744148', '34', '6643f6ac7d588.png', '664479cf5af00.png', 1, 4, 2),
(351, 123, '2024-05-15', '06:50:29', '16:03:48', '-6.4242582', '107.7440409', '47', '-6.4243647', '107.7442253', '37', '6643f8c58eec5.png', '66447a74138a5.png', 1, 4, 2),
(352, 121, '2024-05-15', '06:52:08', '16:02:36', '-6.424045', '107.7442321', '23', '-6.4240536', '107.7442521', '21', '6643f9289afdb.png', '66447a2cb4398.png', 1, 4, 2),
(353, 145, '2024-05-15', '06:55:33', '', '-6.4240459', '107.7442458', '22', '', '', '', '6643f9f504350.png', '', 1, 0, 1),
(354, 140, '2024-05-15', '06:56:18', '16:02:27', '-6.4240441', '107.7442439', '22', '-6.4240415', '107.7442411', '23', '6643fa2211ebd.png', '66447a23a400a.png', 1, 4, 2),
(355, 118, '2024-05-15', '07:13:06', '17:12:42', '-6.4240536', '107.7442305', '23', '-6.3890629', '107.7585695', '4198', '6643fe127724d.png', '66448a9aee075.png', 1, 4, 2),
(356, 135, '2024-05-15', '07:16:00', '', '-6.4243168', '107.7441667', '38', '', '', '', '6643fec017c84.png', '', 1, 0, 1),
(357, 146, '2024-05-15', '07:17:53', '16:20:32', '-6.4337499', '107.7449306', '1075', '-6.4242331', '107.7441947', '30', '6643ff3114efc.png', '66447e6025775.png', 1, 4, 2),
(358, 120, '2024-05-15', '07:20:55', '16:02:53', '-6.430823', '107.7375289', '1068', '-6.4244893', '107.7440948', '57', '6643ffe76635c.png', '66447a3d4798c.png', 1, 4, 2),
(359, 112, '2024-05-15', '07:21:52', '17:38:52', '-6.4738136', '107.7452422', '5528', '-6.4242289', '107.7442042', '29', '664400204203b.png', '664490bcb0407.png', 1, 4, 2),
(360, 125, '2024-05-15', '07:23:35', '16:00:30', '-6.4358478', '107.7452918', '1310', '-6.4242438', '107.7442036', '30', '66440087933a8.png', '664479aec9bdb.png', 1, 4, 2),
(361, 138, '2024-05-15', '07:24:01', '17:55:45', '-6.3920565', '107.7515222', '3649', '-6.3920833', '107.7515148', '3646', '664400a118e1b.png', '664494b15d0ab.png', 1, 4, 2),
(362, 150, '2024-05-15', '07:25:17', '16:01:44', '-6.3853173', '107.7803937', '5865', '-6.4241731', '107.7441762', '30', '664400ed4022c.png', '664479f8b2127.png', 1, 4, 2),
(363, 115, '2024-05-15', '07:25:48', '16:29:05', '-6.4242643', '107.7439948', '52', '-6.4244015', '107.7440241', '56', '6644010c61d4f.png', '664480619b205.png', 1, 4, 2),
(364, 113, '2024-05-15', '07:27:29', '16:01:59', '-6.4241954', '107.7441208', '36', '-6.4242116', '107.7441758', '31', '66440171e6d5c.png', '66447a07aa6ba.png', 1, 4, 2),
(365, 137, '2024-05-15', '07:32:00', '16:00:15', '-6.4240419', '107.7442286', '24', '-6.4242658', '107.7441875', '33', '66440280810f1.png', '6644799fe89c7.png', 2, 4, 2),
(366, 122, '2024-05-15', '07:46:57', '16:02:21', '-6.3947502', '107.7564038', '3522', '-6.4242446', '107.7442031', '30', '66440601109d6.png', '66447a1d5ef47.png', 2, 4, 2),
(367, 130, '2024-05-15', '16:01:32', '', '-6.4243709', '107.7442172', '39', '', '', '', '664479ec822e2.png', '', 2, 0, 1),
(368, 117, '2024-05-15', '16:03:00', '16:07:00', '-6.424059', '107.7442436', '22', '-6.4242335', '107.7441978', '30', '66447a44474dc.png', '66447b3439149.png', 2, 4, 2);

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

--
-- Table structure for table `ijin`
--

CREATE TABLE `ijin` (
  `id_ijin` int NOT NULL,
  `id_users` int NOT NULL,
  `tanggal_ijin` text NOT NULL,
  `keterangan_ijin` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ijin`
--

INSERT INTO `ijin` (`id_ijin`, `id_users`, `tanggal_ijin`, `keterangan_ijin`) VALUES
(19, 135, '2024-04-29', 'Ijin mengurus keluarga yang sakit dulu'),
(20, 140, '2024-04-29', 'Sidang Skripsi Di Universitas Subang '),
(21, 120, '2024-04-29', 'Anak sedang sakit'),
(22, 118, '2024-04-29', 'Dalam Perjalanan'),
(28, 122, '2024-04-30', 'Anak demam dari semalem.'),
(30, 150, '2024-04-30', 'Assalamualaikum,,mohon maf pak hari ini saya izin tidak ke sekolah dulu dikarenakan suami sedang sakit ????'),
(32, 147, '2024-05-02', 'Mohon Izin Bpk Ibu, tidak bisa hadir kesekolah ada Acara keluarga ????????'),
(33, 147, '2024-05-02', 'Mohon Izin Bpk Ibu, tidak bisa hadir kesekolah ada Acara keluarga ????????'),
(37, 125, '2024-05-07', 'Assalamualaikum, mohon maaf ibu kepala sekolah, hari ini Ijin tidak hadir, dikarenakan anak sakit.'),
(39, 123, '2024-05-07', 'Kontrol ke rumah sakit rayhan wantilan'),
(40, 92, '2024-05-07', 'Ijin datang terlambat mau ke puskesmas dulu. Ada perlu. Selesai dari puskesmas lalu ke sekolah. Untk tugas X TSM 1 jam ke 3,4 sudah dishare di grup WA murid. Terima kasih.'),
(41, 92, '2024-05-07', 'Ijin datang terlambat mau ke puskesmas dulu. Ada perlu. Selesai dari puskesmas lalu ke sekolah. Untk tugas X TSM 1 jam ke 3,4 sudah dishare di grup WA murid. Terima kasih.'),
(42, 111, '2024-05-07', 'Bu pak besok Abi ijin telat bade meser alat heula kangge LKS  nuhun'),
(43, 111, '2024-05-07', 'Bu pak besok Abi ijin telat bade meser alat heula kangge LKS  nuhun'),
(44, 147, '2024-05-08', '\r\nIzin Bpk Ibu, mau nganter mertua ke dokter spesialis Mata '),
(45, 147, '2024-05-08', '\r\nIzin Bpk Ibu, mau nganter mertua ke dokter spesialis Mata '),
(46, 147, '2024-05-08', '\r\nIzin Bpk Ibu, mau nganter mertua ke dokter spesialis Mata '),
(47, 147, '2024-05-08', '\r\nIzin Bpk Ibu, mau nganter mertua ke dokter spesialis Mata '),
(49, 145, '2024-05-08', 'Keperluan keluarga'),
(51, 137, '2024-05-08', 'Mendampingi O2sn'),
(52, 92, '2024-05-13', 'Ijin mengikuti kegiatan numerasi dulu. Untuk tugas anak sudah diberikan lewat WA Grup.'),
(53, 92, '2024-05-13', 'Ijin mengikuti kegiatan numerasi dulu. Untuk tugas anak sudah diberikan lewat WA Grup.'),
(54, 131, '2024-05-13', 'Sakit'),
(56, 125, '2024-05-14', 'Menunggu adik yang dirawat di rumah sakit'),
(58, 113, '2024-05-14', 'Anak demam habis imunisasi '),
(59, 113, '2024-05-14', 'Anak demam habis imunisasi '),
(60, 113, '2024-05-14', 'Izin anak demam habis imunisasi'),
(61, 113, '2024-05-14', 'Izin anak demam habis imunisasi'),
(63, 119, '2024-05-14', 'Izin mendampingi anak study tour.'),
(64, 131, '2024-05-14', 'Sakit'),
(66, 131, '2024-05-15', 'Sakit'),
(67, 131, '2024-05-15', 'Sakit');

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

--
-- Table structure for table `pengaturan`
--

CREATE TABLE `pengaturan` (
  `id_pengaturan` int NOT NULL,
  `nama_sekolah` varchar(255) NOT NULL,
  `lat_sekolah` text NOT NULL,
  `long_sekolah` text NOT NULL,
  `jarak_pengaturan` text NOT NULL,
  `no_wa_wakakur` varchar(255) NOT NULL,
  `no_wa_kepsek` varchar(255) NOT NULL,
  `logo_sekolah` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `pengaturan`
--

INSERT INTO `pengaturan` (`id_pengaturan`, `nama_sekolah`, `lat_sekolah`, `long_sekolah`, `jarak_pengaturan`, `no_wa_wakakur`, `no_wa_kepsek`, `logo_sekolah`) VALUES
(1, 'SMKN 1 Cikaum', '-6.424103328270466', '107.74443132773399', '50000', '082120024039', '085351856006', '1229238720_Untitled-2.png');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `absen`
--
ALTER TABLE `absen`
ADD PRIMARY KEY (`id_absen`);

--
-- Indexes for table `ijin`
--
ALTER TABLE `ijin`
ADD PRIMARY KEY (`id_ijin`);

--
-- Indexes for table `pengaturan`
--
ALTER TABLE `pengaturan`
ADD PRIMARY KEY (`id_pengaturan`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `absen`
--
ALTER TABLE `absen`
MODIFY `id_absen` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=369;

--
-- AUTO_INCREMENT for table `ijin`
--
ALTER TABLE `ijin`
MODIFY `id_ijin` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=68;

--
-- AUTO_INCREMENT for table `pengaturan`
--
ALTER TABLE `pengaturan`
MODIFY `id_pengaturan` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
COMMIT;

