-- phpMyAdmin SQL Dump
-- version 5.2.0
-- https://www.phpmyadmin.net/
--
-- Host: localhost:3306
-- Generation Time: Jul 05, 2024 at 03:10 AM
-- Server version: 8.0.30
-- PHP Version: 8.1.10

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: `tugas_akhir`
--

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

--
-- Table structure for table `absensi`
--

CREATE TABLE `absensi` (
  `id_absensi` int NOT NULL,
  `bulan` int NOT NULL,
  `tahun` year NOT NULL,
  `nip` varchar(25) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `nama` varchar(255) NOT NULL,
  `sakit` int DEFAULT '0',
  `ijin` int DEFAULT NULL,
  `alpa` int DEFAULT NULL,
  `cuti` int DEFAULT NULL,
  `total_kehadiran` int NOT NULL,
  `total_kerja` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `absensi`
--

INSERT INTO `absensi` (`id_absensi`, `bulan`, `tahun`, `nip`, `nama`, `sakit`, `ijin`, `alpa`, `cuti`, `total_kehadiran`, `total_kerja`) VALUES
(102, 1, 2021, '198504162020051001', 'Aisha Anindya', NULL, 2, NULL, NULL, 20, 21),
(103, 1, 2021, '197809302017032002', 'Bintang Arya Satria', 4, 1, 1, NULL, 15, 21),
(104, 1, 2021, '199012122016053003', 'Damar Eka Prasetya', 1, 3, NULL, NULL, 17, 21),
(105, 1, 2021, '198702252019041004', 'Luthfi Hadi', NULL, NULL, NULL, NULL, 21, 21),
(106, 1, 2021, '199605192021062005', 'Mila Harum', NULL, NULL, NULL, NULL, 21, 21),
(107, 1, 2021, '198903072018023006', 'Maulana Akbar Ramadhan', NULL, NULL, NULL, 13, 8, 21),
(108, 1, 2021, '198111282014111007', 'Miftah Akmal Rendra', NULL, NULL, NULL, NULL, 22, 21),
(109, 1, 2021, '199203172017012008', 'Munir Zaky Arsyad', NULL, NULL, NULL, NULL, 21, 21),
(110, 1, 2021, '199404042020033009', 'Nisa Maharani Juwita', NULL, 2, NULL, NULL, 19, 21),
(111, 1, 2021, '198510222015121010', 'Ovan Yudhistira', NULL, NULL, NULL, NULL, 21, 21),
(112, 1, 2021, '199801052022072011', 'Putra Manggala Rendra', 1, 4, NULL, NULL, 16, 21),
(113, 1, 2021, '197612152013083012', 'Salsabila Qurrota', NULL, 1, NULL, NULL, 20, 21),
(114, 1, 2021, '198905012016101013', 'Wiro', NULL, 1, NULL, NULL, 20, 21),
(115, 1, 2021, '199311232018092014', 'Yulia Anggraini', NULL, 2, NULL, NULL, 19, 21),
(116, 1, 2021, '199705302020013015', 'Yusuf', NULL, NULL, NULL, NULL, 23, 21),
(117, 1, 2021, '199502112021052017', 'Dwi Krisnanto', NULL, 3, NULL, NULL, 18, 21),
(118, 2, 2021, '198504162020051001', 'Aisha Anindya', NULL, 2, NULL, NULL, 19, 21),
(119, 2, 2021, '197809302017032002', 'Bintang Arya Satria', NULL, NULL, NULL, NULL, 23, 21),
(120, 2, 2021, '199012122016053003', 'Damar Eka Prasetya', 4, 1, NULL, NULL, 16, 21),
(121, 2, 2021, '198702252019041004', 'Luthfi Hadi', 1, NULL, 2, NULL, 18, 21),
(122, 2, 2021, '199605192021062005', 'Mila Harum', 1, NULL, NULL, NULL, 30, 21),
(123, 2, 2021, '198903072018023006', 'Maulana Akbar Ramadhan', 2, NULL, NULL, NULL, 19, 21),
(124, 2, 2021, '198111282014111007', 'Miftah Akmal Rendra', NULL, 1, NULL, NULL, 30, 21),
(125, 2, 2021, '199203172017012008', 'Munir Zaky Arsyad', NULL, NULL, NULL, NULL, 21, 21),
(126, 2, 2021, '199404042020033009', 'Nisa Maharani Juwita', NULL, NULL, 1, NULL, 30, 21),
(127, 2, 2021, '198510222015121010', 'Ovan Yudhistira', 1, NULL, NULL, NULL, 20, 21),
(128, 2, 2021, '199801052022072011', 'Putra Manggala Rendra', 5, NULL, 2, NULL, 14, 21),
(129, 2, 2021, '197612152013083012', 'Salsabila Qurrota', NULL, 2, NULL, NULL, 27, 21),
(130, 2, 2021, '198905012016101013', 'Wiro', NULL, 1, NULL, NULL, 30, 21),
(131, 2, 2021, '199311232018092014', 'Yulia Anggraini', NULL, NULL, NULL, NULL, 31, 21),
(132, 2, 2021, '199705302020013015', 'Yusuf', 5, NULL, NULL, NULL, 16, 21),
(133, 2, 2021, '199502112021052017', 'Dwi Krisnanto', NULL, NULL, NULL, NULL, 21, 21),
(134, 3, 2021, '198504162020051001', 'Aisha Anindya', NULL, NULL, NULL, NULL, 18, 18),
(135, 3, 2021, '197809302017032002', 'Bintang Arya Satria', 6, NULL, 1, NULL, 11, 18),
(136, 3, 2021, '199012122016053003', 'Damar Eka Prasetya', NULL, NULL, NULL, NULL, 18, 18),
(137, 3, 2021, '198702252019041004', 'Luthfi Hadi', NULL, NULL, NULL, NULL, 18, 18),
(138, 3, 2021, '199605192021062005', 'Mila Harum', 1, NULL, NULL, NULL, 17, 18),
(139, 3, 2021, '198903072018023006', 'Maulana Akbar Ramadhan', NULL, NULL, NULL, NULL, 18, 18),
(140, 3, 2021, '198111282014111007', 'Miftah Akmal Rendra', NULL, 2, NULL, NULL, 16, 18),
(141, 3, 2021, '199203172017012008', 'Munir Zaky Arsyad', NULL, NULL, NULL, NULL, 18, 18),
(142, 3, 2021, '199404042020033009', 'Nisa Maharani Juwita', NULL, 2, NULL, NULL, 16, 18),
(143, 3, 2021, '198510222015121010', 'Ovan Yudhistira', NULL, 1, 1, NULL, 16, 18),
(144, 3, 2021, '199801052022072011', 'Putra Manggala Rendra', NULL, NULL, NULL, NULL, 18, 18),
(145, 3, 2021, '197612152013083012', 'Salsabila Qurrota', NULL, NULL, NULL, NULL, 18, 18),
(146, 3, 2021, '198905012016101013', 'Wiro', NULL, NULL, NULL, NULL, 18, 18),
(147, 3, 2021, '199311232018092014', 'Yulia Anggraini', NULL, 1, NULL, NULL, 16, 18),
(148, 3, 2021, '199705302020013015', 'Yusuf', 5, NULL, NULL, NULL, 13, 18),
(149, 3, 2021, '199502112021052017', 'Dwi Krisnanto', NULL, 5, NULL, NULL, 13, 18),
(150, 4, 2021, '198504162020051001', 'Aisha Anindya', 1, NULL, NULL, NULL, 17, 18),
(151, 4, 2021, '197809302017032002', 'Bintang Arya Satria', 7, 2, NULL, NULL, 9, 18),
(152, 4, 2021, '199012122016053003', 'Damar Eka Prasetya', NULL, NULL, NULL, NULL, 26, 26),
(153, 4, 2021, '198702252019041004', 'Luthfi Hadi', NULL, NULL, NULL, NULL, 18, 18),
(154, 4, 2021, '199605192021062005', 'Mila Harum', NULL, 1, NULL, NULL, 25, 26),
(155, 4, 2021, '198903072018023006', 'Maulana Akbar Ramadhan', NULL, NULL, NULL, NULL, 18, 18),
(156, 4, 2021, '198111282014111007', 'Miftah Akmal Rendra', NULL, NULL, NULL, NULL, 26, 26),
(157, 4, 2021, '199203172017012008', 'Munir Zaky Arsyad', NULL, NULL, NULL, NULL, 18, 18),
(158, 4, 2021, '199404042020033009', 'Nisa Maharani Juwita', NULL, NULL, NULL, NULL, 18, 18),
(159, 4, 2021, '198510222015121010', 'Ovan Yudhistira', NULL, NULL, NULL, NULL, 26, 26),
(160, 4, 2021, '199801052022072011', 'Putra Manggala Rendra', NULL, NULL, NULL, NULL, 26, 26),
(161, 4, 2021, '197612152013083012', 'Salsabila Qurrota', NULL, NULL, NULL, NULL, 26, 26),
(162, 4, 2021, '198905012016101013', 'Wiro', 1, NULL, NULL, NULL, 17, 18),
(163, 4, 2021, '199311232018092014', 'Yulia Anggraini', NULL, 1, NULL, NULL, 17, 18),
(164, 4, 2021, '199705302020013015', 'Yusuf', NULL, NULL, NULL, NULL, 18, 18),
(165, 4, 2021, '199502112021052017', 'Dwi Krisnanto', 1, NULL, NULL, NULL, 17, 18),
(166, 5, 2021, '198504162020051001', 'Aisha Anindya', NULL, NULL, NULL, NULL, 23, 23),
(167, 5, 2021, '197809302017032002', 'Bintang Arya Satria', NULL, NULL, NULL, 16, 7, 23),
(168, 5, 2021, '199012122016053003', 'Damar Eka Prasetya', NULL, NULL, NULL, NULL, 23, 23),
(169, 5, 2021, '198702252019041004', 'Luthfi Hadi', NULL, NULL, NULL, NULL, 23, 23),
(170, 5, 2021, '199605192021062005', 'Mila Harum', NULL, NULL, 1, NULL, 22, 23),
(171, 5, 2021, '198903072018023006', 'Maulana Akbar Ramadhan', NULL, NULL, NULL, NULL, 23, 23),
(172, 5, 2021, '198111282014111007', 'Miftah Akmal Rendra', NULL, 1, NULL, NULL, 22, 23),
(173, 5, 2021, '199203172017012008', 'Munir Zaky Arsyad', NULL, NULL, NULL, NULL, 23, 23),
(174, 5, 2021, '199404042020033009', 'Nisa Maharani Juwita', 1, 4, 1, NULL, 17, 23),
(175, 5, 2021, '198510222015121010', 'Ovan Yudhistira', NULL, NULL, 1, NULL, 22, 23),
(176, 5, 2021, '199801052022072011', 'Putra Manggala Rendra', NULL, 2, NULL, NULL, 21, 23),
(177, 5, 2021, '197612152013083012', 'Salsabila Qurrota', NULL, NULL, 2, NULL, 21, 23),
(178, 5, 2021, '198905012016101013', 'Wiro', NULL, 2, 1, NULL, 20, 23),
(179, 5, 2021, '199311232018092014', 'Yulia Anggraini', NULL, NULL, NULL, NULL, 23, 23),
(180, 5, 2021, '199705302020013015', 'Yusuf', NULL, 4, NULL, NULL, 19, 23),
(181, 5, 2021, '199502112021052017', 'Dwi Krisnanto', NULL, NULL, NULL, NULL, 23, 23),
(182, 6, 2021, '198504162020051001', 'Aisha Anindya', NULL, NULL, NULL, NULL, 22, 22),
(183, 6, 2021, '197809302017032002', 'Bintang Arya Satria', NULL, NULL, NULL, NULL, 23, 23),
(184, 6, 2021, '199012122016053003', 'Damar Eka Prasetya', 1, NULL, NULL, NULL, 28, 29),
(185, 6, 2021, '198702252019041004', 'Luthfi Hadi', NULL, NULL, 3, NULL, 20, 23),
(186, 6, 2021, '199605192021062005', 'Mila Harum', NULL, NULL, 3, NULL, 26, 29),
(187, 6, 2021, '198903072018023006', 'Maulana Akbar Ramadhan', NULL, NULL, NULL, NULL, 23, 23),
(188, 6, 2021, '198111282014111007', 'Miftah Akmal Rendra', NULL, NULL, NULL, NULL, 31, 31),
(189, 6, 2021, '199203172017012008', 'Munir Zaky Arsyad', NULL, 1, NULL, NULL, 22, 23),
(190, 6, 2021, '199404042020033009', 'Nisa Maharani Juwita', 1, 3, NULL, NULL, 19, 23),
(191, 6, 2021, '198510222015121010', 'Ovan Yudhistira', NULL, NULL, NULL, NULL, 30, 30),
(192, 6, 2021, '199801052022072011', 'Putra Manggala Rendra', NULL, NULL, NULL, NULL, 29, 29),
(193, 6, 2021, '197612152013083012', 'Salsabila Qurrota', NULL, NULL, NULL, NULL, 31, 31),
(194, 6, 2021, '198905012016101013', 'Wiro', 2, 2, NULL, NULL, 19, 23),
(195, 6, 2021, '199311232018092014', 'Yulia Anggraini', NULL, 1, NULL, NULL, 22, 23),
(196, 6, 2021, '199705302020013015', 'Yusuf', NULL, 1, NULL, NULL, 22, 23),
(197, 6, 2021, '199502112021052017', 'Dwi Krisnanto', 1, NULL, 1, NULL, 21, 23),
(198, 7, 2021, '198504162020051001', 'Aisha Anindya', NULL, NULL, NULL, NULL, 21, 21),
(199, 7, 2021, '197809302017032002', 'Bintang Arya Satria', 3, NULL, 2, NULL, 16, 21),
(200, 7, 2021, '199012122016053003', 'Damar Eka Prasetya', NULL, 1, NULL, NULL, 21, 21),
(201, 7, 2021, '198702252019041004', 'Luthfi Hadi', NULL, NULL, NULL, NULL, 21, 21),
(202, 7, 2021, '199605192021062005', 'Mila Harum', NULL, 5, NULL, NULL, 16, 21),
(203, 7, 2021, '198903072018023006', 'Maulana Akbar Ramadhan', NULL, NULL, NULL, NULL, 21, 21),
(204, 7, 2021, '198111282014111007', 'Miftah Akmal Rendra', NULL, NULL, NULL, NULL, 22, 21),
(205, 7, 2021, '199203172017012008', 'Munir Zaky Arsyad', NULL, NULL, NULL, NULL, 21, 21),
(206, 7, 2021, '199404042020033009', 'Nisa Maharani Juwita', 2, 1, 2, NULL, 16, 21),
(207, 7, 2021, '198510222015121010', 'Ovan Yudhistira', NULL, NULL, NULL, NULL, 21, 21),
(208, 7, 2021, '199801052022072011', 'Putra Manggala Rendra', NULL, 1, NULL, NULL, 19, 21),
(209, 7, 2021, '197612152013083012', 'Salsabila Qurrota', NULL, NULL, NULL, NULL, 21, 21),
(210, 7, 2021, '198905012016101013', 'Wiro', NULL, 5, NULL, NULL, 16, 21),
(211, 7, 2021, '199311232018092014', 'Yulia Anggraini', NULL, NULL, NULL, NULL, 21, 21),
(212, 7, 2021, '199705302020013015', 'Yusuf', NULL, 4, 1, NULL, 16, 21),
(213, 7, 2021, '199502112021052017', 'Dwi Krisnanto', NULL, NULL, NULL, NULL, 21, 21),
(214, 8, 2021, '198504162020051001', 'Aisha Anindya', NULL, 4, NULL, NULL, 17, 21),
(215, 8, 2021, '197809302017032002', 'Bintang Arya Satria', NULL, 1, 1, NULL, 19, 21),
(216, 8, 2021, '199012122016053003', 'Damar Eka Prasetya', NULL, NULL, NULL, NULL, 31, 31),
(217, 8, 2021, '198702252019041004', 'Luthfi Hadi', NULL, NULL, NULL, NULL, 21, 21),
(218, 8, 2021, '199605192021062005', 'Mila Harum', 2, NULL, NULL, NULL, 29, 31),
(219, 8, 2021, '198903072018023006', 'Maulana Akbar Ramadhan', NULL, NULL, NULL, NULL, 21, 21),
(220, 8, 2021, '198111282014111007', 'Miftah Akmal Rendra', NULL, NULL, NULL, NULL, 27, 27),
(221, 8, 2021, '199203172017012008', 'Munir Zaky Arsyad', NULL, NULL, NULL, NULL, 21, 21),
(222, 8, 2021, '199404042020033009', 'Nisa Maharani Juwita', NULL, NULL, NULL, NULL, 21, 21),
(223, 8, 2021, '198510222015121010', 'Ovan Yudhistira', NULL, NULL, NULL, NULL, 29, 29),
(224, 8, 2021, '199801052022072011', 'Putra Manggala Rendra', NULL, NULL, NULL, NULL, 31, 31),
(225, 8, 2021, '197612152013083012', 'Salsabila Qurrota', NULL, NULL, NULL, NULL, 31, 31),
(226, 8, 2021, '198905012016101013', 'Wiro', NULL, 7, NULL, NULL, 14, 21),
(227, 8, 2021, '199311232018092014', 'Yulia Anggraini', NULL, 1, NULL, NULL, 20, 21),
(228, 8, 2021, '199705302020013015', 'Yusuf', NULL, 2, NULL, NULL, 19, 21),
(229, 8, 2021, '199502112021052017', 'Dwi Krisnanto', NULL, NULL, NULL, NULL, 21, 21),
(230, 9, 2021, '198504162020051001', 'Aisha Anindya', NULL, NULL, 1, NULL, 25, 26),
(231, 9, 2021, '197809302017032002', 'Bintang Arya Satria', NULL, 4, 6, NULL, 16, 26),
(232, 9, 2021, '199012122016053003', 'Damar Eka Prasetya', NULL, 1, NULL, NULL, 25, 26),
(233, 9, 2021, '198702252019041004', 'Luthfi Hadi', NULL, NULL, NULL, NULL, 28, 28),
(234, 9, 2021, '199605192021062005', 'Mila Harum', NULL, NULL, NULL, NULL, 28, 28),
(235, 9, 2021, '198903072018023006', 'Maulana Akbar Ramadhan', NULL, NULL, NULL, NULL, 28, 28),
(236, 9, 2021, '198111282014111007', 'Miftah Akmal Rendra', NULL, NULL, NULL, NULL, 26, 26),
(237, 9, 2021, '199203172017012008', 'Munir Zaky Arsyad', 2, NULL, NULL, NULL, 27, 29),
(238, 9, 2021, '199404042020033009', 'Nisa Maharani Juwita', NULL, 1, 1, NULL, 26, 28),
(239, 9, 2021, '198510222015121010', 'Ovan Yudhistira', NULL, 1, NULL, NULL, 24, 25),
(240, 9, 2021, '199801052022072011', 'Putra Manggala Rendra', NULL, NULL, NULL, NULL, 27, 27),
(241, 9, 2021, '197612152013083012', 'Salsabila Qurrota', NULL, 1, NULL, NULL, 25, 26),
(242, 9, 2021, '198905012016101013', 'Wiro', NULL, 1, NULL, NULL, 26, 27),
(243, 9, 2021, '199311232018092014', 'Yulia Anggraini', NULL, NULL, NULL, NULL, 26, 26),
(244, 9, 2021, '199705302020013015', 'Yusuf', NULL, 4, 2, NULL, 21, 27),
(245, 9, 2021, '199502112021052017', 'Dwi Krisnanto', 2, 2, NULL, NULL, 23, 27),
(246, 10, 2021, '198504162020051001', 'Aisha Anindya', NULL, NULL, NULL, NULL, 15, 15),
(247, 10, 2021, '197809302017032002', 'Bintang Arya Satria', NULL, 2, NULL, NULL, 13, 15),
(248, 10, 2021, '199012122016053003', 'Damar Eka Prasetya', NULL, NULL, NULL, 5, 10, 15),
(249, 10, 2021, '198702252019041004', 'Luthfi Hadi', NULL, 1, NULL, NULL, 14, 15),
(250, 10, 2021, '199605192021062005', 'Mila Harum', 2, 1, NULL, NULL, 12, 15),
(251, 10, 2021, '198903072018023006', 'Maulana Akbar Ramadhan', NULL, NULL, NULL, NULL, 15, 15),
(252, 10, 2021, '198111282014111007', 'Miftah Akmal Rendra', 2, NULL, 1, NULL, 12, 15),
(253, 10, 2021, '199203172017012008', 'Munir Zaky Arsyad', NULL, NULL, NULL, NULL, 15, 15),
(254, 10, 2021, '199404042020033009', 'Nisa Maharani Juwita', NULL, 1, NULL, NULL, 14, 15),
(255, 10, 2021, '198510222015121010', 'Ovan Yudhistira', NULL, 2, NULL, 3, 10, 15),
(256, 10, 2021, '199801052022072011', 'Putra Manggala Rendra', NULL, NULL, NULL, NULL, 15, 15),
(257, 10, 2021, '197612152013083012', 'Salsabila Qurrota', NULL, NULL, NULL, NULL, 15, 15),
(258, 10, 2021, '198905012016101013', 'Wiro', NULL, NULL, NULL, NULL, 15, 15),
(259, 10, 2021, '199311232018092014', 'Yulia Anggraini', NULL, NULL, NULL, NULL, 18, 18),
(260, 10, 2021, '199705302020013015', 'Yusuf', NULL, 2, NULL, NULL, 13, 15),
(261, 10, 2021, '199502112021052017', 'Dwi Krisnanto', NULL, NULL, NULL, NULL, 16, 16),
(262, 11, 2021, '198504162020051001', 'Aisha Anindya', NULL, NULL, NULL, NULL, 15, 15),
(263, 11, 2021, '197809302017032002', 'Bintang Arya Satria', NULL, 2, NULL, NULL, 13, 15),
(264, 11, 2021, '199012122016053003', 'Damar Eka Prasetya', NULL, NULL, NULL, 5, 10, 15),
(265, 11, 2021, '198702252019041004', 'Luthfi Hadi', NULL, 1, NULL, NULL, 14, 15),
(266, 11, 2021, '199605192021062005', 'Mila Harum', 2, 1, NULL, NULL, 12, 15),
(267, 11, 2021, '198903072018023006', 'Maulana Akbar Ramadhan', NULL, NULL, NULL, NULL, 15, 15),
(268, 11, 2021, '198111282014111007', 'Miftah Akmal Rendra', 2, NULL, 1, NULL, 12, 15),
(269, 11, 2021, '199203172017012008', 'Munir Zaky Arsyad', NULL, NULL, NULL, NULL, 15, 15),
(270, 11, 2021, '199404042020033009', 'Nisa Maharani Juwita', NULL, 1, NULL, NULL, 14, 15),
(271, 11, 2021, '198510222015121010', 'Ovan Yudhistira', NULL, 2, NULL, 3, 10, 15),
(272, 11, 2021, '199801052022072011', 'Putra Manggala Rendra', NULL, NULL, NULL, NULL, 15, 15),
(273, 11, 2021, '197612152013083012', 'Salsabila Qurrota', NULL, NULL, NULL, NULL, 15, 15),
(274, 11, 2021, '198905012016101013', 'Wiro', NULL, NULL, NULL, NULL, 15, 15),
(275, 11, 2021, '199311232018092014', 'Yulia Anggraini', NULL, NULL, NULL, NULL, 18, 18),
(276, 11, 2021, '199705302020013015', 'Yusuf', NULL, 2, NULL, NULL, 13, 15),
(277, 11, 2021, '199502112021052017', 'Dwi Krisnanto', NULL, NULL, NULL, NULL, 16, 16),
(278, 12, 2021, '198504162020051001', 'Aisha Anindya', NULL, NULL, NULL, NULL, 15, 15),
(279, 12, 2021, '197809302017032002', 'Bintang Arya Satria', NULL, NULL, NULL, NULL, 15, 15),
(280, 12, 2021, '199012122016053003', 'Damar Eka Prasetya', NULL, NULL, NULL, NULL, 26, 26),
(281, 12, 2021, '198702252019041004', 'Luthfi Hadi', NULL, NULL, NULL, NULL, 15, 15),
(282, 12, 2021, '199605192021062005', 'Mila Harum', NULL, NULL, NULL, NULL, 26, 26),
(283, 12, 2021, '198903072018023006', 'Maulana Akbar Ramadhan', NULL, NULL, NULL, NULL, 15, 15),
(284, 12, 2021, '198111282014111007', 'Miftah Akmal Rendra', NULL, NULL, NULL, NULL, 22, 22),
(285, 12, 2021, '199203172017012008', 'Munir Zaky Arsyad', NULL, NULL, NULL, NULL, 15, 15),
(286, 12, 2021, '199404042020033009', 'Nisa Maharani Juwita', NULL, NULL, 3, 3, 9, 15),
(287, 12, 2021, '198510222015121010', 'Ovan Yudhistira', NULL, NULL, NULL, NULL, 26, 26),
(288, 12, 2021, '199801052022072011', 'Putra Manggala Rendra', NULL, NULL, NULL, NULL, 19, 19),
(289, 12, 2021, '197612152013083012', 'Salsabila Qurrota', NULL, NULL, NULL, NULL, 26, 26),
(290, 12, 2021, '198905012016101013', 'Wiro', 2, 2, NULL, NULL, 11, 15),
(291, 12, 2021, '199311232018092014', 'Yulia Anggraini', NULL, NULL, NULL, NULL, 15, 15),
(292, 12, 2021, '199705302020013015', 'Yusuf', NULL, 2, NULL, NULL, 13, 15),
(293, 12, 2021, '199502112021052017', 'Dwi Krisnanto', 2, 1, 1, 1, 10, 15);

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

--
-- Table structure for table `amal`
--

CREATE TABLE `amal` (
  `id_amal` int NOT NULL,
  `nip` varchar(25) NOT NULL,
  `bulan` varchar(255) NOT NULL,
  `tahun` year NOT NULL,
  `sholat_jamaah` int NOT NULL,
  `tilawah` int NOT NULL,
  `sholat_tahajud` int NOT NULL,
  `sholat_dhuha` int NOT NULL,
  `bantu_ortu` int NOT NULL,
  `literasi` int NOT NULL,
  `infaq` int NOT NULL,
  `olahraga` int NOT NULL,
  `hafalan` int NOT NULL,
  `lampiran` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

--
-- Table structure for table `detail_penilaian`
--

CREATE TABLE `detail_penilaian` (
  `id_detailpenilaian` int NOT NULL,
  `id_penilaian` int NOT NULL,
  `nip` varchar(25) NOT NULL,
  `nip_penilai` varchar(25) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `tanggal` date NOT NULL,
  `k1` int NOT NULL,
  `k2` int NOT NULL,
  `k3` int NOT NULL,
  `k4` int NOT NULL,
  `k5` int NOT NULL,
  `k6` int NOT NULL,
  `k7` int NOT NULL,
  `k8` int NOT NULL,
  `k9` int NOT NULL,
  `hasil` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `status` int NOT NULL,
  `is_eval` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `detail_penilaian`
--

INSERT INTO `detail_penilaian` (`id_detailpenilaian`, `id_penilaian`, `nip`, `nip_penilai`, `tanggal`, `k1`, `k2`, `k3`, `k4`, `k5`, `k6`, `k7`, `k8`, `k9`, `hasil`, `status`, `is_eval`) VALUES
(26, 21, '197612152013083012', '199502112021052017', '2024-06-02', 4, 3, 3, 3, 3, 3, 3, 3, 3, '80', 1, 1),
(27, 21, '197809302017032002', '199502112021052017', '2024-06-02', 3, 3, 4, 3, 3, 3, 4, 3, 3, '79.5', 1, 0),
(28, 21, '198111282014111007', '199502112021052017', '2024-06-02', 3, 3, 3, 3, 3, 3, 4, 3, 3, '76', 1, 0),
(29, 21, '198504162020051001', '199502112021052017', '2024-06-02', 3, 3, 3, 3, 3, 3, 3, 3, 3, '75', 1, 0),
(30, 21, '198510222015121010', '199502112021052017', '2024-06-02', 3, 3, 3, 3, 3, 3, 4, 3, 3, '76', 1, 0),
(31, 21, '198702252019041004', '199502112021052017', '2024-06-03', 4, 2, 2, 2, 2, 3, 2, 3, 2, '64', 1, 0),
(32, 21, '198903072018023006', '199502112021052017', '2024-06-03', 3, 3, 3, 3, 3, 3, 3, 3, 3, '75', 1, 0),
(33, 21, '198905012016101013', '199502112021052017', '2024-06-03', 3, 3, 4, 3, 3, 2, 4, 3, 3, '78', 1, 0),
(34, 21, '199012122016053003', '199502112021052017', '2024-06-03', 3, 3, 3, 3, 2, 3, 4, 3, 3, '73.5', 1, 0),
(35, 21, '199203172017012008', '199502112021052017', '2024-06-03', 3, 3, 3, 3, 3, 4, 3, 4, 3, '79', 1, 0),
(36, 21, '199311232018092014', '199502112021052017', '2024-06-03', 4, 4, 4, 4, 4, 4, 3, 2, 3, '92', 1, 0),
(37, 21, '199404042020033009', '199502112021052017', '2024-06-03', 3, 4, 4, 4, 4, 4, 4, 4, 3, '93', 1, 0),
(39, 21, '199605192021062005', '199502112021052017', '2024-06-03', 3, 3, 4, 3, 3, 4, 4, 3, 3, '81', 1, 0),
(40, 21, '199705302020013015', '199502112021052017', '2024-06-03', 4, 3, 3, 4, 3, 3, 3, 3, 3, '83', 1, 0),
(41, 21, '199801052022072011', '199502112021052017', '2024-06-03', 3, 4, 4, 4, 4, 4, 4, 4, 3, '93', 1, 0),
(42, 22, '197612152013083012', '199502112021052017', '2024-06-04', 1, 1, 1, 1, 1, 1, 1, 1, 1, '25', 1, 0),
(43, 22, '197809302017032002', '199502112021052017', '2024-06-04', 4, 4, 4, 4, 4, 4, 4, 4, 4, '100', 1, 0),
(44, 22, '198001122014083054', '199502112021052017', '2024-06-04', 1, 4, 4, 4, 4, 4, 4, 4, 4, '85', 1, 0),
(45, 22, '198111282014111007', '199502112021052017', '2024-06-04', 4, 1, 4, 4, 4, 4, 4, 4, 4, '88', 1, 0),
(46, 22, '198504162020051001', '199502112021052017', '2024-06-04', 4, 3, 3, 4, 1, 2, 4, 4, 3, '80', 1, 0),
(47, 22, '198509152017031052', '199502112021052017', '2024-06-04', 3, 4, 3, 1, 4, 1, 3, 4, 3, '75', 1, 0),
(48, 22, '198510222015121010', '199502112021052017', '2024-06-04', 4, 2, 4, 3, 4, 3, 1, 3, 3, '80', 1, 0),
(49, 22, '198607212015092050', '199502112021052017', '2024-06-04', 3, 4, 4, 3, 3, 3, 3, 4, 3, '85', 1, 0),
(50, 22, '198702252019041004', '199502112021052017', '2024-06-04', 3, 4, 3, 1, 4, 3, 1, 3, 4, '75.5', 1, 0),
(51, 22, '198810052017032056', '199108122017062047', '2024-06-05', 3, 3, 2, 2, 3, 3, 2, 2, 3, '65', 1, 0),
(52, 22, '198903072018023006', '199502112021052017', '2024-06-20', 4, 2, 4, 4, 3, 1, 3, 4, 3, '82', 1, 0),
(53, 22, '198905012016101013', '', '0000-00-00', 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 0),
(54, 22, '198905252016101046', '', '0000-00-00', 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 0),
(55, 22, '199012122016053003', '', '0000-00-00', 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 0),
(56, 22, '199108122017062047', '', '0000-00-00', 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 0),
(57, 22, '199203172017012008', '', '0000-00-00', 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 0),
(58, 22, '199311232018092014', '', '0000-00-00', 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 0),
(59, 22, '199404042020033009', '', '0000-00-00', 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 0),
(60, 22, '199502112021052017', '', '0000-00-00', 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 0),
(61, 22, '199605192021062005', '', '0000-00-00', 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 0),
(62, 22, '199705302020013015', '', '0000-00-00', 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 0),
(63, 22, '199801052022072011', '', '0000-00-00', 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 0);

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

--
-- Table structure for table `evaluasi`
--

CREATE TABLE `evaluasi` (
  `id_evaluasi` int NOT NULL,
  `id_detailpenilaian` int NOT NULL,
  `keterangan` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `evaluasi`
--

INSERT INTO `evaluasi` (`id_evaluasi`, `id_detailpenilaian`, `keterangan`) VALUES
(3, 26, 'Kinerja Setiap Aspek Sudah Cukup Baik');

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

--
-- Table structure for table `guru`
--

CREATE TABLE `guru` (
  `nip` varchar(25) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `nama_guru` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `tanggal_lahir` date DEFAULT NULL,
  `jenis_kelamin` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `alamat` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `jabatan` varchar(255) NOT NULL,
  `username` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `password` varchar(255) NOT NULL,
  `hak_akses` int NOT NULL,
  `is_aktif` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `guru`
--

INSERT INTO `guru` (`nip`, `nama_guru`, `tanggal_lahir`, `jenis_kelamin`, `alamat`, `jabatan`, `username`, `password`, `hak_akses`, `is_aktif`) VALUES
('1', 'Admin', '2024-06-26', 'Laki-Laki', 'Jalan Kaliurang', 'Admin', 'admin', '123', 2, 1),
('197612152013083012', 'Salsabila Qurrota', '1976-12-15', 'Perempuan', 'Jalan Kaliurang', 'Guru Al-Quran Boarding', 'salsabilaqurrota', '151276', 4, 1),
('197809302017032002', 'Bintang Arya Satria', '1978-09-27', 'Laki-Laki', 'Jalan Kaliurang', 'Guru Bahasa Indonesia', 'bintangaryasatria', '270978', 4, 1),
('198001122014083054', 'Imam Budi Santoso', '1980-01-12', 'Laki-Laki', 'Jalan Kaliurang', 'Guru IPA Biologi', 'imambudisantoso', '120180', 3, 1),
('198111282014111007', 'Miftah Akmal Rendra', '1981-11-28', 'Laki-Laki', 'Jalan Kaliurang', 'PJ Kebersihan & Sarana Umum Kampus 1', 'Miftah Akmal Rendra', '281181', 4, 1),
('198504162020051001', 'Aisha Anindya', '1993-04-14', 'Perempuan', 'Jalan Kaliurang', 'Pengasuhan Asrama Putri', 'aishaanindya', '140493', 4, 1),
('198509152017031052', 'Moch. Sauqi Lufisanto', '1985-09-15', 'Laki-Laki', 'Jalan Kaliurang', 'Guru PJOK', 'mochsauqilufisanto', '150985', 3, 1),
('198510222015121010', 'Ovan Yudhistira', '1985-10-22', 'Laki-Laki', 'Jalan Kaliurang', 'Guru Al-Quran Boarding', 'ovanyudhistira', '221085', 4, 1),
('198607212015092050', 'Oemi Asijah', '1986-07-21', 'Perempuan', 'Jalan Kaliurang', 'Guru Al-Quran Fullday', 'oemiasijah', '210786', 3, 1),
('198702252019041004', 'Luthfi Hadi', '1987-02-25', 'Laki-Laki', 'Jalan Kaliurang', 'Guru Al-Quran Boarding', 'lutfhihadi', '250287', 4, 1),
('198810052017032056', 'Ismail Zulqornain', '1988-10-05', 'Laki-Laki', 'Jalan Kaliurang', 'Guru PAI', 'ismailzuqornain', '051088', 3, 1),
('198903072018023006', 'Maulana Akbar Ramadhan', '1989-03-07', 'Laki-Laki', 'Jalan Kaliurang', 'Guru Al-Quran Fullday', 'maulanaakbarramadhan', '070389', 4, 1),
('198905012016101013', 'Wira', '1989-05-01', 'Laki-Laki', '', 'PJ Kebersihan & Sarana Umum Kampus 2', 'wira', '010589', 4, 1),
('198905252016101046', 'Moch. Ruslan', '1989-05-25', 'Laki-Laki', 'Jalan Kaliurang', 'Koordinator Bidang Sarana dan Prasarana', 'mochruslan', '250589', 3, 1),
('199012122016053003', 'Damar Eka Prasetya', '1990-12-12', 'Laki-Laki', 'Jalan Kaliurang', 'Guru PPKN', 'damarekaprasetya', '121290', 4, 1),
('199108122017062047', 'Putri Kusuma Wardani', '1991-08-12', 'Perempuan', 'Jalan Kaliurang', 'Kepala TU', 'putrikusumawardani', '120891', 3, 1),
('199203172017012008', 'Munir Zaky Arsyad', '1992-03-17', 'Laki-Laki', 'Jalan Kaliurang', 'Guru PAI', 'munirzakyarsyad', '170392', 4, 1),
('199311232018092014', 'Yulia Anggraini', '1993-11-23', 'Perempuan', 'Jalan Kaliurang', 'Guru Matematika', 'yuliaanggraini', '231193', 4, 1),
('199404042020033009', 'Nisa Maharani Juwita', '1994-04-04', 'Perempuan', 'Jalan Kaliurang', 'Guru Bahasa Indonesia', 'nisamaharanijuwita', '040494', 4, 1),
('199502112021052017', 'Dwi Krisnanto', '1980-06-19', 'Laki-Laki', 'Jalan Kaliurang', 'Kepala Sekolah', 'dwikrisnanto', '190680', 1, 1),
('199605192021062005', 'Mila Harum', '1996-05-19', 'Perempuan', 'Jalan Kaliurang', 'Guru IPS', 'milaharum', '190596', 4, 1),
('199705302020013015', 'Yusuf', '1970-05-30', 'Laki-Laki', 'Jalan Kaliurang', 'PJ Keamanan Kampus 2', 'yusuf', '300570', 4, 1),
('199801052022072011', 'Putra Manggala Rendra', '1998-01-05', 'Laki-Laki', 'Jalan Kaliurang', 'Guru BK', 'putramanggalarendra', '050198', 4, 1);

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

--
-- Table structure for table `jurnal`
--

CREATE TABLE `jurnal` (
  `id_jurnal` int NOT NULL,
  `bulan` int NOT NULL,
  `tahun` year NOT NULL,
  `mapel` varchar(255) NOT NULL,
  `total_jurnal` int NOT NULL,
  `keterangan` varchar(255) NOT NULL,
  `nip` varchar(25) NOT NULL,
  `lampiran` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `jurnal`
--

INSERT INTO `jurnal` (`id_jurnal`, `bulan`, `tahun`, `mapel`, `total_jurnal`, `keterangan`, `nip`, `lampiran`) VALUES
(2, 6, 2024, 'IPS', 0, 'Test', '199502112021052017', '14. Meita Kurniyati_IPS 8_Jurnal Mengajar Guru.doc');

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

--
-- Table structure for table `kriteria`
--

CREATE TABLE `kriteria` (
  `id_kriteria` int NOT NULL,
  `kode_kriteria` varchar(255) NOT NULL,
  `nama_kriteria` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `tipe` varchar(255) NOT NULL,
  `bobot` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `kriteria`
--

INSERT INTO `kriteria` (`id_kriteria`, `kode_kriteria`, `nama_kriteria`, `tipe`, `bobot`) VALUES
(1, 'K1', 'Ibadah', 'Benefit', 20),
(2, 'K2', 'Kesetiaan dan Ketaatan', 'Benefit', 16),
(3, 'K3', 'Kedisiplinan dan Ketertiban', 'Benefit', 14),
(4, 'K4', 'Tanggung Jawab', 'Benefit', 12),
(5, 'K5', 'Ketuntasan Kerja dan Penguasaan Tugas ', 'Benefit', 10),
(6, 'K6', 'Kejujuran', 'Benefit', 6),
(7, 'K7', 'Interaksi Sosial', 'Benefit', 4),
(8, 'K8', 'Kepemimpinan', 'Benefit', 10),
(9, 'K9', 'Inisiatif', 'Benefit', 8);

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

--
-- Table structure for table `penilaian`
--

CREATE TABLE `penilaian` (
  `id_penilaian` int NOT NULL,
  `bulan` int NOT NULL,
  `tahun` year NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `penilaian`
--

INSERT INTO `penilaian` (`id_penilaian`, `bulan`, `tahun`) VALUES
(21, 6, 2021),
(22, 5, 2024);

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

--
-- Table structure for table `surat`
--

CREATE TABLE `surat` (
  `id_surat` int NOT NULL,
  `nip` varchar(25) NOT NULL,
  `jenis_surat` varchar(255) NOT NULL,
  `jabatan` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `tanggal` date NOT NULL,
  `keterangan_surat` varchar(255) NOT NULL,
  `lampiran` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Indexes for dumped tables
--

--
-- Indexes for table `absensi`
--
ALTER TABLE `absensi`
  ADD PRIMARY KEY (`id_absensi`);

--
-- Indexes for table `amal`
--
ALTER TABLE `amal`
  ADD PRIMARY KEY (`id_amal`);

--
-- Indexes for table `detail_penilaian`
--
ALTER TABLE `detail_penilaian`
  ADD PRIMARY KEY (`id_detailpenilaian`);

--
-- Indexes for table `evaluasi`
--
ALTER TABLE `evaluasi`
  ADD PRIMARY KEY (`id_evaluasi`);

--
-- Indexes for table `guru`
--
ALTER TABLE `guru`
  ADD PRIMARY KEY (`nip`) USING BTREE;

--
-- Indexes for table `jurnal`
--
ALTER TABLE `jurnal`
  ADD PRIMARY KEY (`id_jurnal`);

--
-- Indexes for table `kriteria`
--
ALTER TABLE `kriteria`
  ADD PRIMARY KEY (`id_kriteria`);

--
-- Indexes for table `penilaian`
--
ALTER TABLE `penilaian`
  ADD PRIMARY KEY (`id_penilaian`);

--
-- Indexes for table `surat`
--
ALTER TABLE `surat`
  ADD PRIMARY KEY (`id_surat`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `absensi`
--
ALTER TABLE `absensi`
  MODIFY `id_absensi` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=294;

--
-- AUTO_INCREMENT for table `amal`
--
ALTER TABLE `amal`
  MODIFY `id_amal` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `detail_penilaian`
--
ALTER TABLE `detail_penilaian`
  MODIFY `id_detailpenilaian` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=64;

--
-- AUTO_INCREMENT for table `evaluasi`
--
ALTER TABLE `evaluasi`
  MODIFY `id_evaluasi` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `jurnal`
--
ALTER TABLE `jurnal`
  MODIFY `id_jurnal` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `kriteria`
--
ALTER TABLE `kriteria`
  MODIFY `id_kriteria` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

--
-- AUTO_INCREMENT for table `penilaian`
--
ALTER TABLE `penilaian`
  MODIFY `id_penilaian` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=23;

--
-- AUTO_INCREMENT for table `surat`
--
ALTER TABLE `surat`
  MODIFY `id_surat` int NOT NULL AUTO_INCREMENT;
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 */;
