-- phpMyAdmin SQL Dump
-- version 5.2.1
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Apr 06, 2025 at 02:51 AM
-- Server version: 10.4.28-MariaDB
-- PHP Version: 8.0.28

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

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

--
-- Table structure for table `tbl_mst_akses`
--

CREATE TABLE `tbl_mst_akses` (
  `mst_akses_id` int(11) NOT NULL,
  `mst_akses_menu_id` int(11) DEFAULT NULL,
  `mst_akses_petugas_id` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `tbl_mst_akses`
--

INSERT INTO `tbl_mst_akses` (`mst_akses_id`, `mst_akses_menu_id`, `mst_akses_petugas_id`) VALUES
(1, 1000, 1),
(2, 250000, 1),
(4, 250002, 1),
(7, 250001, 1),
(8, 50000, 1),
(9, 60000, 1),
(11, 50020, 1),
(12, 60100, 1),
(13, 2000, 1),
(14, 8000, 1),
(15, 9000, 1),
(16, 7000, 1),
(17, 8500, 1),
(18, 4000, 1),
(19, 70000, 1),
(20, 5000, 1),
(21, 6000, 1),
(22, 50011, 1),
(24, 50010, 1),
(26, 50012, 1),
(27, 50013, 1),
(28, 50021, 1),
(29, 50022, 1),
(30, 50023, 1),
(31, 50030, 1),
(32, 50031, 1),
(33, 50032, 1),
(34, 50033, 1),
(35, 50040, 1),
(36, 50041, 1),
(37, 50042, 1),
(38, 50043, 1),
(39, 50050, 1),
(40, 50051, 1),
(41, 50052, 1),
(42, 50053, 1),
(43, 50060, 1),
(44, 50061, 1),
(45, 50062, 1),
(46, 50063, 1),
(47, 50070, 1),
(48, 50071, 1),
(49, 50072, 1),
(50, 50073, 1),
(51, 50080, 1),
(52, 50081, 1),
(53, 50082, 1),
(54, 50083, 1),
(55, 10000, 1),
(56, 9100, 1),
(57, 50090, 1),
(58, 50091, 1),
(59, 50092, 1),
(60, 50093, 1),
(61, 50103, 1),
(62, 50102, 1),
(63, 50100, 1),
(64, 50101, 1),
(65, 50110, 1),
(66, 50111, 1),
(67, 50112, 1),
(68, 50113, 1),
(69, 50120, 1),
(70, 50121, 1),
(71, 50122, 1),
(72, 50123, 1),
(73, 50130, 1),
(74, 50131, 1),
(75, 50132, 1),
(76, 50133, 1),
(77, 50140, 1),
(78, 50141, 1),
(79, 50142, 1),
(80, 50143, 1),
(81, 50150, 1),
(82, 50151, 1),
(83, 50152, 1),
(84, 50153, 1),
(85, 50160, 1),
(86, 50161, 1),
(87, 50162, 1),
(88, 50163, 1),
(89, 50170, 1),
(90, 50171, 1),
(91, 50172, 1),
(92, 50173, 1),
(93, 50180, 1),
(94, 50181, 1),
(95, 50182, 1),
(96, 50183, 1),
(97, 50190, 1),
(98, 50191, 1),
(99, 50192, 1),
(100, 50193, 1),
(101, 50200, 1),
(102, 50201, 1),
(103, 50202, 1),
(104, 50203, 1),
(105, 50210, 1),
(106, 50211, 1),
(107, 50212, 1),
(108, 50213, 1),
(109, 50220, 1),
(110, 50221, 1),
(111, 50222, 1),
(112, 50223, 1),
(113, 50230, 1),
(114, 50231, 1),
(115, 50232, 1),
(116, 50233, 1),
(117, 50240, 1),
(118, 50241, 1),
(119, 50242, 1),
(120, 50243, 1),
(121, 50250, 1),
(122, 50251, 1),
(123, 50252, 1),
(124, 50253, 1),
(125, 50260, 1),
(126, 50261, 1),
(127, 50262, 1),
(128, 50263, 1),
(129, 50270, 1),
(130, 50271, 1),
(131, 50272, 1),
(132, 50273, 1),
(133, 50280, 1),
(134, 50281, 1),
(135, 50282, 1),
(136, 50283, 1),
(137, 50290, 1),
(138, 50291, 1),
(139, 50292, 1),
(140, 50293, 1),
(141, 50300, 1),
(142, 50301, 1),
(143, 50302, 1),
(144, 50303, 1),
(145, 50310, 1),
(146, 50311, 1),
(147, 50312, 1),
(148, 50313, 1),
(149, 50320, 1),
(150, 50321, 1),
(151, 50322, 1),
(152, 50323, 1),
(153, 50330, 1),
(154, 50331, 1),
(155, 50332, 1),
(156, 50333, 1),
(157, 50341, 1),
(158, 50340, 1),
(159, 50342, 1),
(160, 50343, 1),
(161, 50350, 1),
(162, 50351, 1),
(163, 50352, 1),
(164, 50353, 1),
(165, 50360, 1),
(166, 50361, 1),
(167, 50362, 1),
(168, 50363, 1),
(169, 50370, 1),
(170, 50371, 1),
(171, 50372, 1),
(172, 50373, 1),
(173, 50380, 1),
(174, 50381, 1),
(175, 50382, 1),
(176, 50383, 1),
(177, 8100, 1),
(178, 60101, 1),
(179, 10001, 1),
(180, 10002, 1),
(181, 10003, 1),
(182, 10004, 1),
(183, 10005, 1),
(184, 10006, 1),
(185, 10007, 1),
(186, 8002, 1),
(188, 8003, 1),
(191, 8101, 1),
(192, 8102, 1),
(193, 8103, 1),
(195, 60102, 1),
(196, 60103, 1),
(197, 60104, 1),
(198, 60105, 1),
(199, 60106, 1),
(200, 60107, 1),
(201, 60108, 1),
(202, 60109, 1),
(203, 60110, 1),
(204, 60111, 1),
(205, 60112, 1),
(206, 60113, 1),
(207, 60114, 1),
(208, 60115, 1),
(209, 60116, 1),
(210, 60117, 1),
(211, 60118, 1),
(212, 60119, 1),
(213, 60120, 1),
(214, 60121, 1),
(215, 60122, 1),
(216, 60123, 1),
(217, 60124, 1),
(218, 60125, 1),
(219, 60126, 1),
(220, 60127, 1),
(221, 60128, 1),
(222, 60129, 1),
(223, 60130, 1),
(224, 60131, 1),
(225, 60132, 1),
(226, 60133, 1),
(227, 60134, 1),
(228, 60135, 1),
(229, 60136, 1),
(230, 60137, 1),
(231, 60138, 1),
(232, 60139, 1),
(233, 60140, 1),
(234, 60141, 1),
(235, 60142, 1),
(236, 60143, 1),
(237, 60144, 1),
(238, 60145, 1),
(239, 60146, 1),
(240, 2001, 1),
(241, 2002, 1),
(243, 3000, 1),
(244, 7101, 1),
(245, 7102, 1),
(246, 5101, 1),
(247, 5102, 1),
(248, 8001, 1),
(251, 8004, 1),
(259, 10008, 1),
(263, 1000, 2),
(264, 8000, 2),
(266, 8003, 2),
(267, 8004, 2),
(268, 8005, 2),
(270, 8005, 1);

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

--
-- Table structure for table `tbl_mst_menu`
--

CREATE TABLE `tbl_mst_menu` (
  `mst_menu_id` int(11) NOT NULL,
  `mst_menu_grup` varchar(100) DEFAULT NULL,
  `mst_menu_nama` varchar(50) DEFAULT NULL,
  `mst_menu_link` varchar(50) DEFAULT NULL,
  `mst_menu_icon` varchar(30) DEFAULT NULL,
  `mst_menu_is_main` int(11) DEFAULT NULL,
  `mst_menu_class` varchar(100) DEFAULT NULL,
  `mst_menu_status` char(1) DEFAULT 'Y'
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `tbl_mst_menu`
--

INSERT INTO `tbl_mst_menu` (`mst_menu_id`, `mst_menu_grup`, `mst_menu_nama`, `mst_menu_link`, `mst_menu_icon`, `mst_menu_is_main`, `mst_menu_class`, `mst_menu_status`) VALUES
(1000, 'Dashboard', 'Dashboard', 'dashboard', 'nav-icon fa fa-home', 0, '', 'Y'),
(2000, 'User', 'User', 'user', 'nav-icon fas fa-child', 0, NULL, 'Y'),
(2001, 'User Edit', 'User Edit', 'user/edit', NULL, NULL, NULL, 'Y'),
(2002, 'User Hapus', 'User Hapus', 'user/hapus', NULL, NULL, NULL, 'Y'),
(3000, 'Produk', 'Produk', 'produk', 'nav-icon fas fa-mitten', 0, NULL, 'Y'),
(4000, 'Inbox', 'Inbox', 'inbox', 'nav-icon fas fa-bell', 0, NULL, 'Y'),
(5000, 'Referral', 'Referral', '#', 'nav-icon fas fa-infinity', 0, NULL, 'Y'),
(5101, 'Referral', 'Master Referral', 'referral', NULL, 5000, NULL, 'Y'),
(5102, 'Referral', 'Transaksi Referral ', 'referral_transaksi', NULL, 5000, NULL, 'Y'),
(6000, 'Notifikasi', 'Notifikasi', 'notifikasi', 'nav-icon fas fa-bell', 0, NULL, 'Y'),
(7000, 'Hadiah', 'Hadiah', '#', 'nav-icon fas fa-mitten', 0, NULL, 'Y'),
(7101, 'Hadiah', 'Master Hadiah', 'hadiah', NULL, 7000, NULL, 'Y'),
(7102, 'Hadiah', 'Pemenang Hadiah', 'hadiah_pemenang', NULL, 7000, NULL, 'Y'),
(8000, 'Deposit', 'Deposit', '#', 'nav-icon fas fa-plug', 0, NULL, 'Y'),
(8001, 'Deposit', 'Bank Otomatis', 'saldo_bank', NULL, 8000, NULL, 'Y'),
(8002, 'Deposit', 'Bank Manual', 'saldo_bank_manual', NULL, 8000, NULL, 'Y'),
(8003, 'Deposit', 'Transaksi', 'saldo_transaksi', NULL, 8000, NULL, 'Y'),
(8004, 'Deposit', 'Saldo User', 'saldo_user', NULL, 8000, NULL, 'Y'),
(8005, 'Deposit', 'Saldo User Tambah', 'saldo_user/tambah', NULL, 0, NULL, 'N'),
(8100, 'Poin', 'Poin', '#', 'nav-icon fas fa-coins', 0, NULL, 'Y'),
(8101, 'Poin', 'Transaksi Poin', 'poin_transaksi', NULL, 8100, NULL, 'Y'),
(8102, 'Poin', 'Poin User', 'poin_user', NULL, 8100, NULL, 'Y'),
(8103, 'Poin', 'Poin User Tambah', 'poin_user/tambah', NULL, NULL, NULL, 'Y'),
(8500, 'Banner', 'Banner', 'banner', 'nav-icon fas fa-desktop', 0, NULL, 'Y'),
(9000, 'Transfer', 'Transfer', 'transfer', 'nav-icon fab fa-gg-circle', 0, NULL, 'Y'),
(9100, 'Menu', 'Menu', 'menu', 'nav-icon fa fa-list', 0, NULL, 'Y'),
(10000, 'Kategori', 'Kategori', '#', 'nav-icon fas fa-stream', 0, NULL, 'Y'),
(10001, 'Kategori', 'Game', 'kategori/kategori_game', NULL, 10000, NULL, 'Y'),
(10002, 'Kategori', 'HP', 'kategori/kategori_hp', NULL, 10000, NULL, 'Y'),
(10003, 'Kategori', 'Internet', 'kategori/kategori_internet', NULL, 10000, NULL, 'Y'),
(10004, 'Kategori', 'Multifinance', 'kategori/kategori_multifinance', NULL, 10000, NULL, 'Y'),
(10005, 'Kategori', 'PBB', 'kategori/kategori_pbb', NULL, 10000, NULL, 'Y'),
(10006, 'Kategori', 'PDAM', 'kategori/kategori_pdam', NULL, 10000, NULL, 'Y'),
(10007, 'Kategori', 'TV', 'kategori/kategori_tv', NULL, 10000, NULL, 'Y'),
(10008, 'Kategori', 'Produk', 'kategori/kategori_produk', NULL, 10000, NULL, 'Y'),
(50000, 'Master', 'Master', '#', 'nav-icon fas fa-tag', 0, NULL, 'Y'),
(50010, 'Master Pulsa', 'Pulsa', 'master/master_pulsa', NULL, 50000, NULL, 'Y'),
(50011, 'Master Pulsa', 'Pulsa Tambah', 'master/master_pulsa/tambah', NULL, 0, NULL, 'N'),
(50012, 'Master Pulsa', 'Pulsa Edit', 'master/master_pulsa/edit', NULL, 0, NULL, 'N'),
(50013, 'Master Pulsa', 'Pulsa Hapus', 'master/master_pulsa/hapus', NULL, 0, NULL, 'N'),
(50020, 'Master Paket Data', 'Paket Data', 'master/master_paket_data', NULL, 50000, NULL, 'Y'),
(50021, 'Master Paket Data', 'Paket Data Tambah', 'master/master_paket_data/tambah', NULL, NULL, NULL, 'N'),
(50022, 'Master Paket Data', 'Paket Data Edit', 'master/master_paket_data/edit', NULL, NULL, NULL, 'N'),
(50023, 'Master Paket Data', 'Paket Data Hapus', 'master/master_paket_data/hapus', NULL, NULL, NULL, 'N'),
(50030, 'Master Paket Nelfon', 'Paket Nelfon', 'master/master_paket_nelfon', NULL, 50000, NULL, 'Y'),
(50031, 'Master Paket Nelfon', 'Paket Nelfon Tambah', 'master/master_paket_nelfon/tambah', NULL, NULL, NULL, 'Y'),
(50032, 'Master Paket Nelfon', 'Paket Nelfon Edit', 'master/master_paket_nelfon/edit', NULL, NULL, NULL, 'Y'),
(50033, 'Master Paket Nelfon', 'Paket Nelfon Hapus', 'master/master_paket_nelfon/hapus', NULL, NULL, NULL, 'Y'),
(50040, 'Master Paket SMS', 'Paket SMS', 'master/master_paket_sms', NULL, 50000, NULL, 'Y'),
(50041, 'Master Paket SMS', 'Paket SMS Tambah', 'master/master_paket_sms/tambah', NULL, NULL, NULL, 'Y'),
(50042, 'Master Paket SMS', 'Paket SMS Edit', 'master/master_paket_sms/edit', NULL, NULL, NULL, 'Y'),
(50043, 'Master Paket SMS', 'Paket SMS Hapus', 'master/master_paket_sms/hapus', NULL, NULL, NULL, 'Y'),
(50050, 'Master Token PLN', 'Token PLN', 'master/master_token_pln', NULL, 50000, NULL, 'Y'),
(50051, 'Master Token PLN', 'Token PLN Tambah', 'master/master_token_pln/tambah', NULL, NULL, NULL, 'Y'),
(50052, 'Master Token PLN', 'Token PLN Edit', 'master/master_token_pln/edit', NULL, NULL, NULL, 'Y'),
(50053, 'Master Token PLN', 'Token PLN Hapus', 'master/master_token_pln/hapus', NULL, NULL, NULL, 'Y'),
(50060, 'Master Masa Aktif', 'Masa Aktif', 'master/master_masa_aktif', NULL, 50000, NULL, 'Y'),
(50061, 'Master Masa Aktif', 'Masa Aktif Tambah', 'master/master_masa_aktif/tambah', NULL, NULL, NULL, 'Y'),
(50062, 'Master Masa Aktif', 'Masa Aktif Edit', 'master/master_masa_aktif/edit', NULL, NULL, NULL, 'Y'),
(50063, 'Master Masa Aktif', 'Masa Aktif Hapus', 'master/master_masa_aktif/hapus', NULL, NULL, NULL, 'Y'),
(50070, 'Master Pulsa Transfer', 'Pulsa Transfer', 'master/master_pulsa_transfer', NULL, 50000, NULL, 'Y'),
(50071, 'Master Pulsa Transfer', 'Pulsa Transfer Tambah', 'master/master_pulsa_transfer/tambah', NULL, NULL, NULL, 'Y'),
(50072, 'Master Pulsa Transfer', 'Pulsa Transfer Edit', 'master/master_pulsa_transfer/edit', NULL, NULL, NULL, 'Y'),
(50073, 'Master Pulsa Transfer', 'Pulsa Transfer Hapus', 'master/master_pulsa_transfer/hapus', NULL, NULL, NULL, 'Y'),
(50080, 'Master Game', 'Game', 'master/master_game', NULL, 50000, NULL, 'Y'),
(50081, 'Master Game', 'Game Tambah', 'master/master_game/tambah', NULL, NULL, NULL, 'Y'),
(50082, 'Master Game', 'Game Edit', 'master/master_game/edit', NULL, NULL, NULL, 'Y'),
(50083, 'Master Game', 'Game Hapus', 'master/master_game/hapus', NULL, NULL, NULL, 'Y'),
(50090, 'Master Gopay', 'Gopay', 'master/master_gopay', NULL, 50000, NULL, 'Y'),
(50091, 'Master Gopay', 'Gopay Tambah', 'master/master_gopay/tambah', NULL, NULL, NULL, 'Y'),
(50092, 'Master Gopay', 'Gopay Edit', 'master/master_gopay/edit', NULL, NULL, NULL, 'Y'),
(50093, 'Master Gopay', 'Gopay Hapus', 'master/master_gopay/hapus', NULL, NULL, NULL, 'Y'),
(50100, 'Master OVO', 'OVO', 'master/master_ovo', NULL, 50000, NULL, 'Y'),
(50101, 'Master OVO', 'OVO Tambah', 'master/master_ovo/tambah', NULL, NULL, NULL, 'Y'),
(50102, 'Master OVO', 'OVO Edit', 'master/master_ovo/edit', NULL, NULL, NULL, 'Y'),
(50103, 'Master OVO', 'OVO Hapus', 'master/master_ovo/hapus', NULL, NULL, NULL, 'Y'),
(50110, 'Master LinkAja', 'Link Aja', 'master/master_linkaja', NULL, 50000, NULL, 'Y'),
(50111, 'Master LinkAja', 'Link Aja Tambah', 'master/master_linkaja/tambah', NULL, NULL, NULL, 'Y'),
(50112, 'Master LinkAja', 'Link Aja Edit', 'master/master_linkaja/edit', NULL, NULL, NULL, 'Y'),
(50113, 'Master LinkAja', 'Link Aja Hapus', 'master/master_linkaja/hapus', NULL, NULL, NULL, 'Y'),
(50120, 'Master Maxim', 'Maxim', 'master/master_maxim', NULL, 50000, NULL, 'Y'),
(50121, 'Master Maxim', 'Maxim Tambah', 'master/master_maxim/tambah', NULL, NULL, NULL, 'Y'),
(50122, 'Master Maxim', 'Maxim Edit', 'master/master_maxim/edit', NULL, NULL, NULL, 'Y'),
(50123, 'Master Maxim', 'Maxim Hapus', 'master/master_maxim/hapus', NULL, NULL, NULL, 'Y'),
(50130, 'Master DANA', 'DANA', 'master/master_dana', NULL, 50000, NULL, 'Y'),
(50131, 'Master DANA', 'DANA Tambah', 'master/master_dana/tambah', NULL, NULL, NULL, 'Y'),
(50132, 'Master DANA', 'DANA Edit', 'master/master_dana/edit', NULL, NULL, NULL, 'Y'),
(50133, 'Master DANA', 'DANA Hapus', 'master/master_dana/hapus', NULL, NULL, NULL, 'Y'),
(50140, 'Master ShopeePay', 'ShopeePay', 'master/master_shopeepay', NULL, 50000, NULL, 'Y'),
(50141, 'Master ShopeePay', 'ShopeePay Tambah', 'master/master_shopeepay/tambah', NULL, NULL, NULL, 'Y'),
(50142, 'Master ShopeePay', 'ShopeePay Edit', 'master/master_shopeepay/edit', NULL, NULL, NULL, 'Y'),
(50143, 'Master ShopeePay', 'ShopeePay Hapus', 'master/master_shopeepay/hapus', NULL, NULL, NULL, 'Y'),
(50150, 'Master Doku', 'Doku', 'master/master_doku', NULL, 50000, NULL, 'Y'),
(50151, 'Master Doku', 'Doku Tambah', 'master/master_doku/tambah', NULL, NULL, NULL, 'Y'),
(50152, 'Master Doku', 'Doku Edit', 'master/master_doku/edit', NULL, NULL, NULL, 'Y'),
(50153, 'Master Doku', 'Doku Hapus', 'master/master_doku/hapus', NULL, NULL, NULL, 'Y'),
(50160, 'Master Grab', 'Grab', 'master/master_grab', NULL, 50000, NULL, 'Y'),
(50161, 'Master Grab', 'Grab Tambah', 'master/master_grab/tambah', NULL, NULL, NULL, 'Y'),
(50162, 'Master Grab', 'Grab Edit', 'master/master_grab/edit', NULL, NULL, NULL, 'Y'),
(50163, 'Master Grab', 'Grab Hapus', 'master/master_grab/hapus', NULL, NULL, NULL, 'Y'),
(50170, 'Master Sakuku', 'Sakuku', 'master/master_sakuku', NULL, 50000, NULL, 'Y'),
(50171, 'Master Sakuku', 'Sakuku Tambah', 'master/master_sakuku/tambah', NULL, NULL, NULL, 'Y'),
(50172, 'Master Sakuku', 'Sakuku Edit', 'master/master_sakuku/edit', NULL, NULL, NULL, 'Y'),
(50173, 'Master Sakuku', 'Sakuku Hapus', 'master/master_sakuku/hapus', NULL, NULL, NULL, 'Y'),
(50180, 'Master I-Saku', 'I-Saku', 'master/master_isaku', NULL, 50000, NULL, 'Y'),
(50181, 'Master I-Saku', 'I-Saku Tambah', 'master/master_isaku/tambah', NULL, NULL, NULL, 'Y'),
(50182, 'Master I-Saku', 'I-Saku Edit', 'master/master_isaku/edit', NULL, NULL, NULL, 'Y'),
(50183, 'Master I-Saku', 'I-Saku Hapus', 'master/master_isaku/hapus', NULL, NULL, NULL, 'Y'),
(50190, 'Master Gojek Driver', 'Gojek Driver', 'master/master_gojek_driver', NULL, 50000, NULL, 'Y'),
(50191, 'Master Gojek Driver', 'Gojek Driver Tambah', 'master/master_gojek_driver/tambah', NULL, NULL, NULL, 'Y'),
(50192, 'Master Gojek Driver', 'Gojek Driver Edit', 'master/master_gojek_driver/edit', NULL, NULL, NULL, 'Y'),
(50193, 'Master Gojek Driver', 'Gojek Driver Hapus', 'master/master_gojek_driver/hapus', NULL, NULL, NULL, 'Y'),
(50200, 'Master Maxim Driver', 'Maxim Driver', 'master/master_maxim_driver', NULL, 50000, NULL, 'Y'),
(50201, 'Master Maxim Driver', 'Maxim Driver Tambah', 'master/master_maxim_driver/tambah', NULL, NULL, NULL, 'Y'),
(50202, 'Master Maxim Driver', 'Maxim Driver Edit', 'master/master_maxim_driver/edit', NULL, NULL, NULL, 'Y'),
(50203, 'Master Maxim Driver', 'Maxim Driver Hapus', 'master/master_maxim_driver/hapus', NULL, NULL, NULL, 'Y'),
(50210, 'Master Grab Driver', 'Grab Driver', 'master/master_grab_driver', NULL, 50000, NULL, 'Y'),
(50211, 'Master Grab Driver', 'Grab Driver Tambah', 'master/master_grab_driver/tambah', NULL, NULL, NULL, 'Y'),
(50212, 'Master Grab Driver', 'Grab Driver Edit', 'master/master_grab_driver/edit', NULL, NULL, NULL, 'Y'),
(50213, 'Master Grab Driver', 'Grab Driver Hapus', 'master/master_grab_driver/hapus', NULL, NULL, NULL, 'Y'),
(50220, 'Master Shopee Driver', 'Shopee Driver', 'master/master_shopee_driver', NULL, 50000, NULL, 'Y'),
(50221, 'Master Shopee Driver', 'Shopee Driver Tambah', 'master/master_shopee_driver/tambah', NULL, NULL, NULL, 'Y'),
(50222, 'Master Shopee Driver', 'Shopee Driver Edit', 'master/master_shopee_driver/edit', NULL, NULL, NULL, 'Y'),
(50223, 'Master Shopee Driver', 'Shopee Driver Hapus', 'master/master_shopee_driver/hapus', NULL, NULL, NULL, 'Y'),
(50230, 'Master Indomaret', 'Indomaret', 'master/master_indomaret', NULL, 50000, NULL, 'Y'),
(50231, 'Master Indomaret', 'Indomaret Tambah', 'master/master_indomaret/tambah', NULL, NULL, NULL, 'Y'),
(50232, 'Master Indomaret', 'Indomaret Edit', 'master/master_indomaret/edit', NULL, NULL, NULL, 'Y'),
(50233, 'Master Indomaret', 'Indomaret Hapus', 'master/master_indomaret/hapus', NULL, NULL, NULL, 'Y'),
(50240, 'Master Alfamart', 'Alfamart', 'master/master_alfamart', NULL, 50000, NULL, 'Y'),
(50241, 'Master Alfamart', 'Alfamart Tambah', 'master/master_alfamart/tambah', NULL, NULL, NULL, 'Y'),
(50242, 'Master Alfamart', 'Alfamart Edit', 'master/master_alfamart/edit', NULL, NULL, NULL, 'Y'),
(50243, 'Master Alfamart', 'Alfamart Hapus', 'master/master_alfamart/hapus', NULL, NULL, NULL, 'Y'),
(50250, 'Master Tokopedia', 'Tokopedia', 'master/master_tokopedia', NULL, 50000, NULL, 'Y'),
(50251, 'Master Tokopedia', 'Tokopedia Tambah', 'master/master_tokopedia/tambah', NULL, NULL, NULL, 'Y'),
(50252, 'Master Tokopedia', 'Tokopedia Edit', 'master/master_tokopedia/edit', NULL, NULL, NULL, 'Y'),
(50253, 'Master Tokopedia', 'Tokopedia Hapus', 'master/master_tokopedia/hapus', NULL, NULL, NULL, 'Y'),
(50260, 'Master E-Materai', 'E-Materai ', 'master/master_materai', NULL, 50000, NULL, 'Y'),
(50261, 'Master E-Materai', 'E-Materai Tambah', 'master/master_materai/tambah', NULL, NULL, NULL, 'Y'),
(50262, 'Master E-Materai', 'E-Materai Edit', 'master/master_materai/edit', NULL, NULL, NULL, 'Y'),
(50263, 'Master E-Materai', 'E-Materai Hapus', 'master/master_materai/hapus', NULL, NULL, NULL, 'Y'),
(50270, 'Master Traveloka', 'Traveloka', 'master/master_traveloka', NULL, 50000, NULL, 'Y'),
(50271, 'Master Traveloka', 'Traveloka Tambah', 'master/master_traveloka/tambah', NULL, NULL, NULL, 'Y'),
(50272, 'Master Traveloka', 'Traveloka Edit', 'master/master_traveloka/edit', NULL, NULL, NULL, 'Y'),
(50273, 'Master Traveloka', 'Traveloka Hapus', 'master/master_traveloka/hapus', NULL, NULL, NULL, 'Y'),
(50280, 'Master M-TIX', 'M-TIX', 'master/master_mtix', NULL, 50000, NULL, 'Y'),
(50281, 'Master M-TIX', 'M-TIX Tambah', 'master/master_mtix/tambah', NULL, NULL, NULL, 'Y'),
(50282, 'Master M-TIX', 'M-TIX Edit', 'master/master_mtix/edit', NULL, NULL, NULL, 'Y'),
(50283, 'Master M-TIX', 'M-TIX Hapus', 'master/master_mtix/hapus', NULL, NULL, NULL, 'Y'),
(50290, 'Master TIX-ID', 'TIX-ID', 'master/master_tixid', NULL, 50000, NULL, 'Y'),
(50291, 'Master TIX-ID', 'TIX-ID Tambah', 'master/master_tixid/tambah', NULL, NULL, NULL, 'Y'),
(50292, 'Master TIX-ID', 'TIX-ID Edit', 'master/master_tixid/edit', NULL, NULL, NULL, 'Y'),
(50293, 'Master TIX-ID', 'TIX-ID Hapus', 'master/master_tixid/hapus', NULL, NULL, NULL, 'Y'),
(50300, 'Master Spotify', 'Spotify', 'master/master_spotify', NULL, 50000, NULL, 'Y'),
(50301, 'Master Spotify', 'Spotify Tambah', 'master/master_spotify/tambah', NULL, NULL, NULL, 'Y'),
(50302, 'Master Spotify', 'Spotify Edit', 'master/master_spotify/edit', NULL, NULL, NULL, 'Y'),
(50303, 'Master Spotify', 'Spotify Hapus', 'master/master_spotify/hapus', NULL, NULL, NULL, 'Y'),
(50310, 'Master Googleplay', 'Googleplay', 'master/master_googleplay', NULL, 50000, NULL, 'Y'),
(50311, 'Master Googleplay', 'Googleplay Tambah', 'master/master_googleplay/tambah', NULL, NULL, NULL, 'Y'),
(50312, 'Master Googleplay', 'Googleplay Edit', 'master/master_googleplay/edit', NULL, NULL, NULL, 'Y'),
(50313, 'Master Googleplay', 'Googleplay Hapus', 'master/master_googleplay/hapus', NULL, NULL, NULL, 'Y'),
(50320, 'Master Vidio', 'Vidio', 'master/master_vidio', NULL, 50000, NULL, 'Y'),
(50321, 'Master Vidio', 'Vidio Tambah', 'master/master_vidio/tambah', NULL, NULL, NULL, 'Y'),
(50322, 'Master Vidio', 'Vidio Edit', 'master/master_vidio/edit', NULL, NULL, NULL, 'Y'),
(50323, 'Master Vidio', 'Vidio Hapus', 'master/master_vidio/hapus', NULL, NULL, NULL, 'Y'),
(50330, 'Master Unipin', 'Unipin', 'master/master_unipin', NULL, 50000, NULL, 'Y'),
(50331, 'Master Unipin', 'Unipin Tambah', 'master/master_unipin/tambah', NULL, NULL, NULL, 'Y'),
(50332, 'Master Unipin', 'Unipin Edit', 'master/master_unipin/edit', NULL, NULL, NULL, 'Y'),
(50333, 'Master Unipin', 'Unipin Hapus', 'master/master_unipin/hapus', NULL, NULL, NULL, 'Y'),
(50340, 'Master WIFI-ID', 'WIFI-ID', 'master/master_wifiid', NULL, 50000, NULL, 'Y'),
(50341, 'Master WIFI-ID', 'WIFI-ID Tambah', 'master/master_wifiid/tambah', NULL, NULL, NULL, 'Y'),
(50342, 'Master WIFI-ID', 'WIFI-ID Edit', 'master/master_wifiid/edit', NULL, NULL, NULL, 'Y'),
(50343, 'Master WIFI-ID', 'WIFI-ID Hapus', 'master/master_wifiid/hapus', NULL, NULL, NULL, 'Y'),
(50350, 'Master Bukalapak', 'Bukalapak', 'master/master_bukalapak', NULL, 50000, NULL, 'Y'),
(50351, 'Master Bukalapak', 'Bukalapak Tambah', 'master/master_bukalapak/tambah', NULL, NULL, NULL, 'Y'),
(50352, 'Master Bukalapak', 'Bukalapak Edit', 'master/master_bukalapak/edit', NULL, NULL, NULL, 'Y'),
(50353, 'Master Bukalapak', 'Bukalapak Hapus', 'master/master_bukalapak/hapus', NULL, NULL, NULL, 'Y'),
(50360, 'Master E-Money', 'E-Money', 'master/master_emoney', NULL, 50000, NULL, 'Y'),
(50361, 'Master E-Money', 'E-Money Tambah', 'master/master_emoney/tambah', NULL, NULL, NULL, 'Y'),
(50362, 'Master E-Money', 'E-Money Edit', 'master/master_emoney/edit', NULL, NULL, NULL, 'Y'),
(50363, 'Master E-Money', 'E-Money Hapus', 'master/master_emoney/hapus', NULL, NULL, NULL, 'Y'),
(50370, 'Master Tapcash', 'Tapcash', 'master/master_tapcash', NULL, 50000, NULL, 'Y'),
(50371, 'Master Tapcash', 'Tapcash Tambah', 'master/master_tapcash/tambah', NULL, NULL, NULL, 'Y'),
(50372, 'Master Tapcash', 'Tapcash Edit', 'master/master_tapcash/edit', NULL, NULL, NULL, 'Y'),
(50373, 'Master Tapcash', 'Tapcash Hapus', 'master/master_tapcash/hapus', NULL, NULL, NULL, 'Y'),
(50380, 'Master Brizzi', 'Brizzi', 'master/master_brizzi', NULL, 50000, NULL, 'Y'),
(50381, 'Master Brizzi', 'Brizzi Tambah', 'master/master_brizzi/tambah', NULL, NULL, NULL, 'Y'),
(50382, 'Master Brizzi', 'Brizzi Edit', 'master/master_brizzi/edit', NULL, NULL, NULL, 'Y'),
(50383, 'Master Brizzi', 'Brizzi Hapus', 'master/master_brizzi/hapus', NULL, NULL, NULL, 'Y'),
(60000, 'Transaksi', 'Transaksi', '#', 'nav-icon far fa-credit-card', 0, NULL, 'Y'),
(60100, 'Transaksi', 'Pulsa', 'transaksi/transaksi_pulsa', '', 60000, NULL, 'Y'),
(60101, 'Transaksi', 'Paket Data', 'transaksi/transaksi_paket_data', NULL, 60000, NULL, 'Y'),
(60102, 'Transaksi', 'Paket Nelfon', 'transaksi/transaksi_paket_nelfon', NULL, 60000, NULL, 'Y'),
(60103, 'Transaksi', 'Paket SMS', 'transaksi/transaksi_paket_sms', NULL, 60000, NULL, 'Y'),
(60104, 'Transaksi', 'Token PLN', 'transaksi/transaksi_token_pln', NULL, 60000, NULL, 'Y'),
(60105, 'Transaksi', 'Masa Aktif', 'transaksi/transaksi_masa_aktif', NULL, 60000, NULL, 'Y'),
(60106, 'Transaksi', 'Pulsa Transfer', 'transaksi/transaksi_pulsa_transfer', NULL, 60000, NULL, 'Y'),
(60107, 'Transaksi', 'Game', 'transaksi/transaksi_game', NULL, 60000, NULL, 'Y'),
(60108, 'Transaksi', 'BPJS', 'transaksi/transaksi_bpjs', NULL, 60000, NULL, 'Y'),
(60109, 'Transaksi', 'HP', 'transaksi/transaksi_hp', NULL, 60000, NULL, 'Y'),
(60110, 'Transaksi', 'TV', 'transaksi/transaksi_tv', NULL, 60000, NULL, 'Y'),
(60111, 'Transaksi', 'PLN', 'transaksi/transaksi_pln', NULL, 60000, NULL, 'Y'),
(60112, 'Transaksi', 'Internet', 'transaksi/transaksi_internet', NULL, 60000, NULL, 'Y'),
(60113, 'Transaksi', 'Multifinance', 'transaksi/transaksi_multifinance', NULL, 60000, NULL, 'Y'),
(60114, 'Transaksi', 'PDAM', 'transaksi/transaksi_pdam', NULL, 60000, NULL, 'Y'),
(60115, 'Transaksi', 'PBB', 'transaksi/transaksi_pbb', NULL, 60000, NULL, 'Y'),
(60116, 'Transaksi', 'Gas Negara', 'transaksi/transaksi_gas', NULL, 60000, NULL, 'Y'),
(60117, 'Transaksi', 'Gopay', 'transaksi/transaksi_gopay', NULL, 60000, NULL, 'Y'),
(60118, 'Transaksi', 'OVO', 'transaksi/transaksi_ovo', NULL, 60000, NULL, 'Y'),
(60119, 'Transaksi', 'LinkAja', 'transaksi/transaksi_linkaja', NULL, 60000, NULL, 'Y'),
(60120, 'Transaksi', 'Maxim', 'transaksi/transaksi_maxim', NULL, 60000, NULL, 'Y'),
(60121, 'Transaksi', 'DANA', 'transaksi/transaksi_dana', NULL, 60000, NULL, 'Y'),
(60122, 'Transaksi', 'ShopeePay', 'transaksi/transaksi_shopeepay', NULL, 60000, NULL, 'Y'),
(60123, 'Transaksi', 'Doku', 'transaksi/transaksi_doku', NULL, 60000, NULL, 'Y'),
(60124, 'Transaksi', 'Grab', 'transaksi/transaksi_grab', NULL, 60000, NULL, 'Y'),
(60125, 'Transaksi', 'Sakuku', 'transaksi/transaksi_sakuku', NULL, 60000, NULL, 'Y'),
(60126, 'Transaksi', 'I-Saku', 'transaksi/transaksi_isaku', NULL, 60000, NULL, 'Y'),
(60127, 'Transaksi', 'Gojek Driver', 'transaksi/transaksi_gojek_driver', NULL, 60000, NULL, 'Y'),
(60128, 'Transaksi', 'Maxim Driver', 'transaksi/transaksi_maxim_driver', NULL, 60000, NULL, 'Y'),
(60129, 'Transaksi', 'Grab Driver', 'transaksi/transaksi_grab_driver', NULL, 60000, NULL, 'Y'),
(60130, 'Transaksi', 'Shopee Driver', 'transaksi/transaksi_shopee_driver', NULL, 60000, NULL, 'Y'),
(60131, 'Transaksi', 'Indomaret', 'transaksi/transaksi_indomaret', NULL, 60000, NULL, 'Y'),
(60132, 'Transaksi', 'Alfamart', 'transaksi/transaksi_alfamart', NULL, 60000, NULL, 'Y'),
(60133, 'Transaksi', 'Tokopedia', 'transaksi/transaksi_tokopedia', NULL, 60000, NULL, 'Y'),
(60134, 'Transaksi', 'E-Materai', 'transaksi/transaksi_materai', NULL, 60000, NULL, 'Y'),
(60135, 'Transaksi', 'Traveloka', 'transaksi/transaksi_traveloka', NULL, 60000, NULL, 'Y'),
(60136, 'Transaksi', 'M-TIX', 'transaksi/transaksi_mtix', NULL, 60000, NULL, 'Y'),
(60137, 'Transaksi', 'TIX-ID', 'transaksi/transaksi_tixid', NULL, 60000, NULL, 'Y'),
(60138, 'Transaksi', 'Spotify', 'transaksi/transaksi_spotify', NULL, 60000, NULL, 'Y'),
(60139, 'Transaksi', 'Googleplay', 'transaksi/transaksi_googleplay', NULL, 60000, NULL, 'Y'),
(60140, 'Transaksi', 'Vidio', 'transaksi/transaksi_vidio', NULL, 60000, NULL, 'Y'),
(60141, 'Transaksi', 'Unipin', 'transaksi/transaksi_unipin', NULL, 60000, NULL, 'Y'),
(60142, 'Transaksi', 'Wifi ID', 'transaksi/transaksi_wifiid', NULL, 60000, NULL, 'Y'),
(60143, 'Transaksi', 'Bukalapak', 'transaksi/transaksi_bukalapak', NULL, 60000, NULL, 'Y'),
(60144, 'Transaksi', 'E-Money', 'transaksi/transaksi_emoney', NULL, 60000, NULL, 'Y'),
(60145, 'Transaksi', 'TapCash', 'transaksi/transaksi_tapcash', NULL, 60000, NULL, 'Y'),
(60146, 'Transaksi', 'Brizzi', 'transaksi/transaksi_brizzi', NULL, 60000, NULL, 'Y'),
(70000, 'Monitor', 'Monitor', 'monitor', 'nav-icon fas fa-server', 0, NULL, 'Y'),
(250000, 'Utility', 'Utility', '#', 'nav-icon fas fa-cog', 0, '', 'Y'),
(250001, 'Utility', 'Petugas', 'petugas/petugas', '', 250000, '', 'Y'),
(250002, 'Utility', 'Hak Akses', 'petugas/hakakses', '', 250000, '', 'Y');

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

--
-- Table structure for table `tbl_mst_petugas`
--

CREATE TABLE `tbl_mst_petugas` (
  `mst_petugas_id` int(11) NOT NULL,
  `mst_petugas_kode` varchar(50) DEFAULT NULL,
  `mst_petugas_nama_lengkap` varchar(100) DEFAULT NULL,
  `mst_petugas_email` varchar(100) DEFAULT NULL,
  `mst_petugas_password` varchar(100) DEFAULT NULL,
  `mst_petugas_status` enum('Aktif','Tidak Aktif') DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `tbl_mst_petugas`
--

INSERT INTO `tbl_mst_petugas` (`mst_petugas_id`, `mst_petugas_kode`, `mst_petugas_nama_lengkap`, `mst_petugas_email`, `mst_petugas_password`, `mst_petugas_status`) VALUES
(1, 'P-001', 'Administrator', 'admin@mamipulsa.com', '3acd0be86de7dcccdbf91b20f94a68cea535922d', 'Aktif'),
(2, 'PT-7543', 'Agen AKL', 'agenakl@gmail.com', '8cb2237d0679ca88db6464eac60da96345513964', 'Aktif');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `tbl_mst_akses`
--
ALTER TABLE `tbl_mst_akses`
  ADD PRIMARY KEY (`mst_akses_id`),
  ADD KEY `hakaksesmenuid` (`mst_akses_menu_id`),
  ADD KEY `hakaksespetugasid` (`mst_akses_petugas_id`);

--
-- Indexes for table `tbl_mst_menu`
--
ALTER TABLE `tbl_mst_menu`
  ADD PRIMARY KEY (`mst_menu_id`),
  ADD KEY `mst_menu_grup` (`mst_menu_grup`,`mst_menu_nama`,`mst_menu_status`);

--
-- Indexes for table `tbl_mst_petugas`
--
ALTER TABLE `tbl_mst_petugas`
  ADD PRIMARY KEY (`mst_petugas_id`),
  ADD KEY `mst_petugas_kode` (`mst_petugas_kode`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `tbl_mst_akses`
--
ALTER TABLE `tbl_mst_akses`
  MODIFY `mst_akses_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=271;

--
-- AUTO_INCREMENT for table `tbl_mst_menu`
--
ALTER TABLE `tbl_mst_menu`
  MODIFY `mst_menu_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=250003;

--
-- AUTO_INCREMENT for table `tbl_mst_petugas`
--
ALTER TABLE `tbl_mst_petugas`
  MODIFY `mst_petugas_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `tbl_mst_akses`
--
ALTER TABLE `tbl_mst_akses`
  ADD CONSTRAINT `tbl_mst_akses_ibfk_1` FOREIGN KEY (`mst_akses_menu_id`) REFERENCES `tbl_mst_menu` (`mst_menu_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `tbl_mst_akses_ibfk_2` FOREIGN KEY (`mst_akses_petugas_id`) REFERENCES `tbl_mst_petugas` (`mst_petugas_id`) ON DELETE CASCADE ON UPDATE CASCADE;
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 */;