Yesterday, 04:11 PM
![[Image: logo_sumber_rezeki_strong.png]](https://sumberrezeki.co.id/images/logo/logo_sumber_rezeki_strong.png){kind=logo}
Belajar tega sama orang yang udah memperlakukan kita seenaknya, itu bukan jahat tapi mengimbangi.
Manusia tidak akan pernah bisa saling memahami kecuali mereka pernah mengalami penderitaan yang sama.
Hargailah selagi dia menghargai kita dengan niat baik, ingat para hacker tidak meminta uang tapi hanya minta penghargaan ( sertifikat resmi )
Kebanyakan para developer/admin sangat idiot, rela mengorbankan data pribadi para pegawai, karyawan dll yang seharusnya bersifat privasi bocor wkwk
Cyber Sederhana Team
Data :
Code:
-- phpMyAdmin SQL Dump
-- version 5.2.1
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Waktu pembuatan: 14 Mar 2025 pada 10.22
-- Versi server: 10.4.32-MariaDB
-- Versi PHP: 8.2.12
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;
--
-- Database: `inventory`
--
-- --------------------------------------------------------
--
-- Struktur dari tabel `tb_admin`
--
CREATE TABLE `tb_admin` (
`id_admin` int(11) NOT NULL,
`username` varchar(255) NOT NULL,
`password` varchar(255) NOT NULL,
`nama` varchar(255) NOT NULL,
`jabatan` varchar(255) NOT NULL,
`telepon` varchar(255) NOT NULL,
`cabang` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
--
-- Dumping data untuk tabel `tb_admin`
--
INSERT INTO `tb_admin` (`id_admin`, `username`, `password`, `nama`, `jabatan`, `telepon`, `cabang`) VALUES
(12, 'suhendro_it', '21232f297a57a5a743894a0e4a801fc3', 'Suhendro Purnomo', 'IT', '085863440339', 'Jakarta'),
(19, 'budi_it', '21232f297a57a5a743894a0e4a801fc3', 'Budi Mulyono', 'IT', '082299990622', 'Jakarta'),
(27, 'widi_korcap', '21232f297a57a5a743894a0e4a801fc3', 'Widianto', 'Korcap', '081808081981', 'Tangerang'),
(32, 'edi_korcap', '21232f297a57a5a743894a0e4a801fc3', 'Edi', 'Korcap', 'xxx', 'Jakarta');
-- --------------------------------------------------------
--
-- Struktur dari tabel `tb_batangan`
--
CREATE TABLE `tb_batangan` (
`id_batangan` int(11) NOT NULL,
`nama_operator` varchar(255) NOT NULL,
`penempatan` varchar(255) NOT NULL,
`jenis_unit` varchar(255) NOT NULL,
`merek_unit` varchar(255) NOT NULL,
`tonase` varchar(255) NOT NULL,
`no_unit` varchar(255) NOT NULL,
`nama_helper` varchar(255) NOT NULL,
`foto_mou` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
--
-- Dumping data untuk tabel `tb_batangan`
--
INSERT INTO `tb_batangan` (`id_batangan`, `nama_operator`, `penempatan`, `jenis_unit`, `merek_unit`, `tonase`, `no_unit`, `nama_helper`, `foto_mou`) VALUES
(1, 'Lama Irwandi R', 'Palembang', 'TMC (Truck Mounted Crane)', 'Kobelco', '10 ton', '12/89940/09', 'Mandor', '07012025103133mou.jpg'),
(2, 'Budi Agustine', 'Tanggerang', 'Roughter Crane', 'Sany', '10 ton', '12/89940/10', 'Rendy Oktani', '07012025103144mou.jpg'),
(4, 'Andi Lobakus', 'Cikarang', 'Mobil Crane', 'Kato', '10 ton', '12/89940/10', 'Rendy Oktani', '07012025103159mou.jpg'),
(5, 'Andi Stepen', 'Cikarang', 'Mobil Crane', 'Hyundai', '50 Ton', '12/89940/09', 'Ronald', '07012025103214mou.jpg'),
(6, 'Deni Mulyadi ', 'Tangerang', 'Crawler Crane', 'Zoomlion', '50 Ton', '12/89940/10', 'Bimo Akbar', '13022025080349mou.jpg'),
(7, 'Tito Karnavian', 'Jakarta', 'Crawler Crane', 'Tadano', '110 Ton', '12/89940/19', 'Mandor', '13022025080409mou.jpg'),
(8, 'Joko Burhanudin', 'Tangerang', 'TMC (Truck Mounted Crane)', 'Kato', '150 Ton', '12/89940/15', 'Loki', '12022025155133mou.jpg'),
(9, 'Petrick', 'Jakarta', 'TMC (Truck Mounted Crane)', 'JLG', '150 Ton', '12/89940/15', 'Jimy', '13022025080443mou.jpg'),
(10, 'Petrus', 'Cikarang', 'Spider', 'IHI', '110 Ton', '12/89940/10', 'Bimo', '13022025080540mou.jpg'),
(12, 'Islam akbar Monarki', 'Tangerang', 'TMC (Truck Mounted Crane)', 'JLG', '150 Ton', '12/89940/10', 'Bimo Akbar', '12022025155205mou.jpg'),
(15, 'Juno', 'Semarang', 'Forklift', 'Doosan', '50 Ton', '12/89940/19', 'Jimy', '13022025080637mou.jpg'),
(16, 'Robi Komarudin', 'Tangerang', 'Crawler Crane', 'Zoomlion', '50 Ton', '12/89940/43', 'Bimo Subagia', '13022025080735mou.jpg'),
(17, 'Kopral', 'Tangerang', 'Menlift', 'Tadano', '110 Ton', '12/89940/90', 'Ronald', '13022025080750mou.jpg'),
(18, 'Herman Bambang', 'Semarang', 'Mobil Crane', 'Doosan', '100 Ton', '12/89940/15', 'Jimy', '13022025080816mou.jpg'),
(19, 'Pandi Kosware', 'Tangerang', 'Roughter Crane', 'Zoomlion', '25 Ton', '12/89940/15', 'Rendy Oktani', '12022025155045struk.jpg');
-- --------------------------------------------------------
--
-- Struktur dari tabel `tb_cabang`
--
CREATE TABLE `tb_cabang` (
`id_cabang` int(11) NOT NULL,
`nama_cabang` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
--
-- Dumping data untuk tabel `tb_cabang`
--
INSERT INTO `tb_cabang` (`id_cabang`, `nama_cabang`) VALUES
(1, 'Jakarta'),
(2, 'Cikarang'),
(3, 'Tangerang'),
(4, 'Balikpapan'),
(5, 'Palembang'),
(6, 'Semarang');
-- --------------------------------------------------------
--
-- Struktur dari tabel `tb_lain_lain`
--
CREATE TABLE `tb_lain_lain` (
`id_biaya` int(11) NOT NULL,
`nama_operator` varchar(255) NOT NULL,
`penempatan` varchar(255) NOT NULL,
`jenis_unit` varchar(255) NOT NULL,
`merek_unit` varchar(255) NOT NULL,
`tonase` varchar(255) NOT NULL,
`no_unit` varchar(255) NOT NULL,
`keterangan_biaya` varchar(255) NOT NULL,
`waktu` varchar(255) NOT NULL,
`foto_keterangan` varchar(255) CHARACTER SET armscii8 COLLATE armscii8_general_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
--
-- Dumping data untuk tabel `tb_lain_lain`
--
INSERT INTO `tb_lain_lain` (`id_biaya`, `nama_operator`, `penempatan`, `jenis_unit`, `merek_unit`, `tonase`, `no_unit`, `keterangan_biaya`, `waktu`, `foto_keterangan`) VALUES
(1, 'Joko Burhanudin', 'Palembang', 'TMC (Truck Mounted Crane)', 'Zoomlion', '80 Ton', '12/89940/15', 'Mel', '2025-02-10', '13022025144543mou.jpg'),
(2, 'Budi Mansur', 'Palembang', 'TMC (Truck Mounted Crane)', 'Lain Lain', '150 Ton', '12/89940/10', 'Mel', '2025-02-10', '11022025030412struk.jpg'),
(4, 'Ferry Irwandi Ortega', 'Semarang', 'Forklift', 'Kobelco', '100', '12/89940/90', 'Mel', '2025-02-09', '11022025030206Kejadian.jpeg'),
(6, 'Bambang Prakoso', 'Tangerang', 'TMC (Truck Mounted Crane)', 'Doosan', '100 Ton', '12/89940/15', 'Mel Polisi', '2025-02-07', '12022025053721Kejadian.jpeg'),
(7, 'Agus Martono', 'Tangerang', 'Crawler Crane', 'Zoomlion', '100 Ton', '12/89940/11', 'Mel Polisi', '2025-02-12', 'mou.jpg'),
(8, 'Bagus Mulyadi', 'Tangerang', 'Mobil Crane', 'Doosan', '100 Ton', '12/89940/09', 'Mel Ormas', '2025-02-12', '12022025053449Kejadian.jpeg'),
(9, 'Budi Hokmen', 'Tangerang', 'Crawler Crane', 'JLG', '150 Ton', '12/89940/90', 'Mel Dishub', '2025-02-12', '13022025152056struk.jpg'),
(10, 'Sakur', 'Jakarta', 'Forklift', 'Zoomlion', '100 Ton', '12/89940/09', 'Mel', '2025-02-12', 'struk.jpg'),
(11, 'Bagas', 'Jakarta', 'Forklift', 'Doosan', '100 Ton', '12/89940/77', 'Mel Polisi', '2025-02-12', '13022025080957struk.jpg'),
(12, 'Joko Wanda', 'Jakarta', 'Forklift', 'Sany', '10 ton', '12/89940/10', 'Mel Polisi', '2025-02-12', 'struk.jpg'),
(13, 'Muhammad Iqbal', 'Balikpapan', 'Crawler Crane', 'Tadano', '50 Ton', '12/89940/10', 'Mel Polisi', '2025-02-03', 'struk.jpg'),
(19, 'x', 'Cikarang', 'TMC (Truck Mounted Crane)', 'Hyundai', 'x', 'x', 'Mel', '2025-02-25', 'Ramadhan 1.jpg'),
(20, 'y', 'Cikarang', 'TMC (Truck Mounted Crane)', 'Cutter Pillar', 'y', 'y', 'Mel Dishub', '2025-02-26', 'Ramadhan 1.jpg'),
(21, 'xx', 'Cikarang', 'Crawler Crane', 'Doosan', 'xx', 'xx', 'Mel', '2025-02-26', 'Ramadhan 1.jpg');
-- --------------------------------------------------------
--
-- Struktur dari tabel `tb_laporan`
--
CREATE TABLE `tb_laporan` (
`id_laporan` int(11) NOT NULL,
`nama_operator_report` varchar(255) NOT NULL,
`no_sio_opr` varchar(255) NOT NULL,
`penempatan` varchar(255) NOT NULL,
`tgl_kejadian` date NOT NULL,
`kejadian` varchar(255) NOT NULL,
`note` varchar(255) NOT NULL,
`no_berita_acara` varchar(255) NOT NULL,
`foto_kejadian` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
--
-- Dumping data untuk tabel `tb_laporan`
--
INSERT INTO `tb_laporan` (`id_laporan`, `nama_operator_report`, `no_sio_opr`, `penempatan`, `tgl_kejadian`, `kejadian`, `note`, `no_berita_acara`, `foto_kejadian`) VALUES
(34, 'Agus Priyono Budianto', '9898977797', 'Tangerang', '2024-12-08', 'Kecelakaan Kerja', 'Jatuh ketiban tangga', '2024/12/18003', '11022025170505Kejadian.jpeg'),
(35, 'Loki Mangku Bumi', '838747287', 'Tangerang', '2024-12-19', 'Kecelakaan Kerja', 'Nabrak orang', '2024/12/18003', '03022025052922Kejadian.jpeg'),
(38, 'Roby Monarki', '8889432466', 'Jakarta', '2024-12-20', 'Kecelakaan Kerja', 'ketabrak mobil', '2024/12/18001', '09012025052525Kejadian.jpeg'),
(39, 'Bumi Pitulaka Putra', '8889432498', 'Jakarta', '2024-12-20', 'Bolos', 'Nabrak orang dan meninggal', '2024/12/18006', '20122024041027download (2).jpeg'),
(42, 'Jacky Murtado', '8889432498', 'Tangerang', '2024-12-24', 'Kecelakaan Kerja', 'Jatuh ketiban tangga 5 m', '2024/12/18004', '31122024045110sertif4.jpg'),
(44, 'Bokir al Khindi', '8889432498', 'Semarang', '2024-12-31', 'Bolos', 'Pulang cepat ', '2024/12/18007', '31122024053620sertif2.jpg'),
(46, 'Bogo Akbar', '8889432498', 'Jakarta', '2025-01-09', 'Kecelakaan Kerja', 'Nabrak orang dan meninggal', '2024/12/18006', '09012025052713Kejadian.jpeg'),
(47, 'Korfan Ali', '8889432498', 'Jakarta', '2025-01-08', 'Kecelakaan Kerja', 'Nabrak orang', '2024/12/18001', '09012025061249Kejadian.jpeg'),
(48, 'Regi Marsudurini', '8889432498', 'Jakarta', '2025-02-03', 'Kecelakaan Kerja', 'Tidak menggunakan alat P3K', '2024/12/18007', '03022025051907Kejadian.jpeg'),
(49, 'Roby Monarko', '88894324989', 'Tangerang', '2025-02-11', 'Kecelakaan Kerja', 'ketabrak mobil', '2024/12/18003', '11022025084233Kejadian.jpeg'),
(50, 'Junaidi Rohman', '8889432498', 'Tangerang', '2025-02-11', 'Kecelakaan Kerja', 'Pulang cepat', '2024/12/18002', '11022025164239Kejadian.jpeg'),
(52, 'Sukijan', '89849283948', 'Tangerang', '2025-02-11', 'Kecelakaan Kerja', 'Nabrak orang', '2024/12/18003', '11022025171509Kejadian.jpeg'),
(53, 'Juno joki', '989318981', 'Jakarta', '2025-02-09', 'Bolos', 'Jatuh ketiban tangga 5 m', '2024/12/18003', '12022025151605Kejadian.jpeg'),
(54, 'Bimo Kastoni', '98931893819', 'Balikpapan', '2025-02-11', 'Kecelakaan Kerja', 'Jatuh ketiban tangga 5 m', '2024/12/18003', '12022025152212Kejadian.jpeg'),
(55, 'Gaber Oktoni', '99849141917', 'Semarang', '2025-02-12', 'Kecelakaan Kerja', 'Jatuh ketiban tangga', '2024/12/18003', '12022025152552Kejadian.jpeg'),
(56, 'Marsito', '882743798', 'Semarang', '2025-02-09', 'Kecelakaan Kerja', 'Jatuh ketiban tangga', '2024/12/18007', '12022025153454Kejadian.jpeg'),
(64, 'xxx', 'xxs', 'Cikarang', '2025-02-25', 'xxx', 'xxx', 'xxx', '25022025022300Ramadhan 1.jpg'),
(65, 'yy', 'yy', 'Cikarang', '2025-02-26', 'yy', 'yy', 'yy', '26022025023350Ramadhan 1.jpg');
-- --------------------------------------------------------
--
-- Struktur dari tabel `tb_mutasi_operator`
--
CREATE TABLE `tb_mutasi_operator` (
`id_mutasi` int(11) NOT NULL,
`id_operator` int(11) NOT NULL,
`nama_operator` varchar(255) NOT NULL,
`penempatan_opr_baru` varchar(255) NOT NULL,
`status_opr_baru` varchar(255) NOT NULL,
`status_approval` varchar(255) NOT NULL,
`tgl_pengajuan` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
--
-- Dumping data untuk tabel `tb_mutasi_operator`
--
INSERT INTO `tb_mutasi_operator` (`id_mutasi`, `id_operator`, `nama_operator`, `penempatan_opr_baru`, `status_opr_baru`, `status_approval`, `tgl_pengajuan`) VALUES
(31, 36, 'Mbokir', 'Tangerang', 'Aktif', 'Ajukan Mutasi', '2025-02-25'),
(32, 46, 'Modik', 'Jakarta', 'Aktif', 'Ajukan Mutasi', '2025-02-25'),
(33, 33, 'Bagus', 'Tangerang', 'Aktif', 'Ajukan Mutasi', '2025-02-26');
-- --------------------------------------------------------
--
-- Struktur dari tabel `tb_operator`
--
CREATE TABLE `tb_operator` (
`id_operator` int(11) NOT NULL,
`nama_operator` varchar(255) NOT NULL,
`nik` varchar(255) NOT NULL,
`alamat` varchar(255) NOT NULL,
`no_telp` varchar(255) NOT NULL,
`no_sio` varchar(255) NOT NULL,
`jenis_sio` varchar(255) NOT NULL,
`operator` varchar(255) NOT NULL,
`kelas_operator` varchar(255) NOT NULL,
`foto_ktp` varchar(255) NOT NULL,
`foto_sio` varchar(255) NOT NULL,
`foto_sim` varchar(255) NOT NULL,
`foto_sertifikat_dpn` varchar(255) NOT NULL,
`foto_sertifikat_blk` varchar(255) NOT NULL,
`foto_operator` varchar(255) NOT NULL,
`penempatan_opr` varchar(255) NOT NULL,
`tgl_masuk` date NOT NULL,
`status` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
--
-- Dumping data untuk tabel `tb_operator`
--
INSERT INTO `tb_operator` (`id_operator`, `nama_operator`, `nik`, `alamat`, `no_telp`, `no_sio`, `jenis_sio`, `operator`, `kelas_operator`, `foto_ktp`, `foto_sio`, `foto_sim`, `foto_sertifikat_dpn`, `foto_sertifikat_blk`, `foto_operator`, `penempatan_opr`, `tgl_masuk`, `status`) VALUES
(33, 'Bagus', '3172040378472', 'Jl Tipar Cakung Pesada Rt001/004 Kec.Cillincing, Kel. Semper Barat No.48', '084874784004', '8318921319', 'Disnaker', 'TMC (Truck Mounted Crane)', 'Kelas 2', '12022025144307ktp.jpeg', '12022025144211sio.jpg', '12022025144307sim.jpg', '19022025035930my profile.jpg', '19022025035930Untitled.jpg', '19022025035930Untitled.png', 'Tangerang', '2024-12-20', 'Non Aktif'),
(34, 'Ferry Irwandi', '31887319730189021', 'Jl Bogasari 5', '084874784004', '8318921314', 'Disnaker', 'TMC (Truck Mounted Crane)', 'Kelas 1', '12022025144839ktp.jpeg', '12022025144839sio.jpg', '11022025165023sim.jpg', '11022025161534Sertifikat.jpg', '11022025161534Sertifikat.jpg', '13022025085230pas foto.jpg', 'Tangerang', '2024-12-20', 'Aktif'),
(35, 'Bobi Karma', '317204030888002', 'Jl Bogasari ', '084874784004', '8318921319', 'Migas', 'Menlift', 'Kelas 1', '201220240357581.jpeg', '201220240357582.jpg', '20122024035758sertif2.jpg', '11022025154216Sertifikat.jpg', '11022025154235Sertifikat.jpg', '11022025154235pas foto.jpg', 'Balikpapan', '2024-12-09', 'SP'),
(36, 'Mbokir', '317204030888006', 'Jl Tipar cakung ', '085863440339', '8318921319', 'Disnaker', 'Forklift', 'Kelas 3', '20122024035941091220241049431 (1).jpeg', '03022025071524sio.jpg', '03022025071524sim.jpg', '09012025052203Sertifikat.jpg', '09012025051330Pas Foto.jpg', '20122024035941Pas Foto.jpg', 'Jakarta', '2024-12-20', 'Aktif'),
(37, 'Opik', '317204030888002', 'Jl Bogasari ', '084874784004', '873784721998', 'Disnaker', 'Spider', 'Kelas 1', '311220240442551.jpeg', '311220240442551.jpeg', '20122024040843download (4).jpeg', '09012025052222Sertifikat.jpg', '03022025051601Sertifikat 2.jpg', '20122024040843Pas Foto.jpg', 'Jakarta', '2024-12-20', 'Aktif'),
(38, 'Bumi Agustine', '317204030888002', 'Jl Bogasari ', '084874784004', '873784721998', 'BNSP', 'Crawler Crane', 'Kelas 1', '20122024041135download (1).jpeg', '20122024041135download (2).jpeg', '20122024041135download.jpeg', '20122024041135download (3).jpeg', '20122024041135download (2).jpeg', '20122024040843Pas Foto.jpg', 'Jakarta', '2024-12-17', 'Aktif'),
(41, 'Naro Bahlul', '317204030888002', 'Jl Harun', '084874784004', '8318921313', 'Migas', 'Forklift', 'Kelas 1', '2112202412292104122024142448sertif4.jpg', '21122024122921091220241049431.jpeg', '21122024122921091220241049431.jpeg', '21122024122921091220241049431.jpeg', '21122024122921091220241049431.jpeg', '21122024122921091220241049431.jpeg', 'Balikpapan', '2024-12-09', 'Aktif'),
(42, 'Lama Irwandi Pokbar', '317204030888004', 'Jl Tipar cakung', '084874784004', '8318921313', 'Migas', 'Spider', 'Kelas 3', '21122024123303download (1).jpeg', '21122024123303download (2).jpeg', '21122024123303download (1).jpeg', '21122024123303download (1).jpeg', '21122024123303download (1).jpeg', '21122024123303download (1).jpeg', 'Jakarta', '2024-12-21', 'Non Aktif'),
(44, 'Fredi Sambo', '317204030888009', 'Jl Bogasari', '0848747840088', '873784721998', 'Migas', 'Roughter Crane', 'Kelas 1', '27122024084016091220241049431.jpeg', '27122024084016jasa.jpg', '27122024084016sertif4.jpg', '27122024084016091220241049431 (1).jpeg', '27122024084016091220241049431 (1).jpeg', '27122024091934Pas Foto.jpg', 'Jakarta', '2024-12-27', 'Aktif'),
(46, 'Modik', '317204030888002', 'Jl Bogasari', '0848747840088', '873784721998', 'Disnaker', 'Mobil Crane', 'Kelas 2', '27122024091759091220241049431.jpeg', '27122024091759091220241049431.jpeg', '27122024091759091220241049431.jpeg', '27122024093759sertif2.jpg', '27122024093759sertif.jpg', '27122024091759Pas Foto.jpg', 'Cikarang', '2024-12-26', 'Aktif'),
(47, 'Jemi Prasetyo', '317204030888004', 'Jl Bogasari', '084874784004', '8318921319', 'BNSP', 'Forklift', 'Kelas 1', '27122024093500091220241049431.jpeg', '27122024093500091220241049431.jpeg', '27122024093500091220241049431.jpeg', '27122024093500sertif3.jpeg', '311220240443481.jpeg', '27122024093500Pas Foto.jpg', 'Tangerang', '2024-12-27', 'Blacklist'),
(49, 'Ali Imron', '317204030888009', 'Jl Bogasari', '084874784004', '873784721998', 'Disnaker', 'Forklift', 'Kelas 2', '03022025051005ktp.jpeg', '03022025051005sio.jpg', '03022025051005sim.jpg', '03022025051636Sertifikat 2.jpg', '03022025051005Sertifikat 2.jpg', '03022025051005pas foto.jpg', 'Tangerang', '2025-02-03', 'Blacklist'),
(50, 'Fredi Sitanggang', '317204030888004', 'Jl Bogasari', '084874784004', '873784721998', 'Migas', 'Crawler Crane', 'Kelas 2', '11022025080032ktp.jpeg', '11022025080032sio.jpg', '11022025080032sim.jpg', '11022025080032Sertifikat.jpg', '11022025080032Sertifikat 2.jpg', '11022025145742pas foto.jpg', 'Cikarang', '2025-02-13', 'Non Aktif'),
(51, 'Park Jing So', '317204030888002', 'Jl Bogasari', '0848747840088', '873784721990', 'BNSP', 'Roughter Crane', 'Kelas 2', '11022025084811ktp.jpeg', '11022025084811sio.jpg', '11022025084811sim.jpg', '11022025084811Sertifikat.jpg', '11022025084811Sertifikat 2.jpg', '11022025084811pas foto.jpg', 'Jakarta', '2025-02-10', 'Non Aktif'),
(52, 'Limnas joki', '317204030888004', 'Jl Bogasari', '084874784004', '8318921314', 'Disnaker', 'Roughter Crane', 'Kelas 1', '11022025085813ktp.jpeg', '11022025085813sio.jpg', '11022025085813sim.jpg', '11022025085813Sertifikat.jpg', '11022025085813Sertifikat 2.jpg', '11022025085813pas foto.jpg', 'Jakarta', '2025-02-11', 'SP'),
(53, 'Regi Norman', '317204030888002', 'Jl Tipar cakung', '084874784004', '8318921319', 'BNSP', 'Roughter Crane', 'Kelas 1', '11022025145650ktp.jpeg', '11022025145650sio.jpg', '11022025145650sim.jpg', '11022025145650Sertifikat.jpg', '11022025145650Sertifikat 2.jpg', '11022025145650pas foto.jpg', 'Tangerang', '2025-02-11', 'Skorsing'),
(54, 'Junaidi Rohman', '317204030888002', 'Jl Tipar cakung', '084874784004', '873784721990', 'Disnaker', 'TMC (Truck Mounted Crane)', 'Kelas 1', '11022025151757ktp.jpeg', '11022025151757sio.jpg', '11022025151757sim.jpg', '11022025151757Sertifikat.jpg', '11022025151757Sertifikat 2.jpg', '11022025151757pas foto.jpg', 'Jakarta', '2025-02-11', 'Aktif'),
(55, 'Sakur', '317204030888004', 'Jl Tipar cakung', '084874784004', '8318921319', 'Disnaker', 'Menlift', 'Kelas 1', '11022025152033ktp.jpeg', '11022025152033sio.jpg', '11022025152033sim.jpg', '11022025152033Sertifikat.jpg', '11022025152320Sertifikat.jpg', '11022025152033pas foto.jpg', 'Balikpapan', '2025-02-11', 'Aktif'),
(56, 'Akur', '317204030888009', 'Jl Tipar cakung', '084874784004', '873784721990', 'BNSP', 'Spider', 'Kelas 2', '12022025143358ktp.jpeg', '12022025143358sio.jpg', '12022025143358sim.jpg', '12022025143358Sertifikat.jpg', '', '12022025143358pas foto.jpg', 'Semarang', '2025-02-12', 'Aktif'),
(57, 'Bobi Indra', '317204030888002', 'Jl Bogasari', '084874784004', '8318921314', 'Disnaker', 'Menlift', 'Kelas 2', '12022025143602ktp.jpeg', '12022025143602sio.jpg', '12022025143602sim.jpg', '', '', '12022025143602pas foto.jpg', 'Jakarta', '2025-02-03', 'Non Aktif');
-- --------------------------------------------------------
--
-- Struktur dari tabel `tb_petugas`
--
CREATE TABLE `tb_petugas` (
`id_petugas` int(11) NOT NULL,
`username` varchar(255) NOT NULL,
`password` varchar(255) NOT NULL,
`nama` varchar(255) NOT NULL,
`telepon` varchar(255) NOT NULL,
`cabang` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
--
-- Dumping data untuk tabel `tb_petugas`
--
INSERT INTO `tb_petugas` (`id_petugas`, `username`, `password`, `nama`, `telepon`, `cabang`) VALUES
(11, 'admin_cikarang', 'afb91ef692fd08c445e8cb1bab2ccf9c', 'Admin Cikarang', 'xxx', 'Cikarang'),
(12, 'admin_tangerang', 'afb91ef692fd08c445e8cb1bab2ccf9c', 'Wati', '081196503196', 'Tangerang'),
(14, 'admin_jakarta', 'afb91ef692fd08c445e8cb1bab2ccf9c', 'Admin Jakarta', 'xxx', 'Jakarta'),
(16, 'admin_balikpapan', 'afb91ef692fd08c445e8cb1bab2ccf9c', 'Admin Balikpapan', 'xxx', 'Balikpapan'),
(36, 'admin_tangerang5', 'afb91ef692fd08c445e8cb1bab2ccf9c', 'Robi Oktoni', 'xxx', 'Tangerang');
--
-- Indexes for dumped tables
--
--
-- Indeks untuk tabel `tb_admin`
--
ALTER TABLE `tb_admin`
ADD PRIMARY KEY (`id_admin`);
--
-- Indeks untuk tabel `tb_batangan`
--
ALTER TABLE `tb_batangan`
ADD PRIMARY KEY (`id_batangan`);
--
-- Indeks untuk tabel `tb_cabang`
--
ALTER TABLE `tb_cabang`
ADD PRIMARY KEY (`id_cabang`);
--
-- Indeks untuk tabel `tb_lain_lain`
--
ALTER TABLE `tb_lain_lain`
ADD PRIMARY KEY (`id_biaya`);
--
-- Indeks untuk tabel `tb_laporan`
--
ALTER TABLE `tb_laporan`
ADD PRIMARY KEY (`id_laporan`);
--
-- Indeks untuk tabel `tb_mutasi_operator`
--
ALTER TABLE `tb_mutasi_operator`
ADD PRIMARY KEY (`id_mutasi`);
--
-- Indeks untuk tabel `tb_operator`
--
ALTER TABLE `tb_operator`
ADD PRIMARY KEY (`id_operator`);
--
-- Indeks untuk tabel `tb_petugas`
--
ALTER TABLE `tb_petugas`
ADD PRIMARY KEY (`id_petugas`);
--
-- AUTO_INCREMENT untuk tabel yang dibuang
--
--
-- AUTO_INCREMENT untuk tabel `tb_admin`
--
ALTER TABLE `tb_admin`
MODIFY `id_admin` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=35;
--
-- AUTO_INCREMENT untuk tabel `tb_batangan`
--
ALTER TABLE `tb_batangan`
MODIFY `id_batangan` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=24;
--
-- AUTO_INCREMENT untuk tabel `tb_cabang`
--
ALTER TABLE `tb_cabang`
MODIFY `id_cabang` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;
--
-- AUTO_INCREMENT untuk tabel `tb_lain_lain`
--
ALTER TABLE `tb_lain_lain`
MODIFY `id_biaya` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=22;
--
-- AUTO_INCREMENT untuk tabel `tb_laporan`
--
ALTER TABLE `tb_laporan`
MODIFY `id_laporan` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=66;
--
-- AUTO_INCREMENT untuk tabel `tb_mutasi_operator`
--
ALTER TABLE `tb_mutasi_operator`
MODIFY `id_mutasi` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=34;
--
-- AUTO_INCREMENT untuk tabel `tb_operator`
--
ALTER TABLE `tb_operator`
MODIFY `id_operator` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=65;
--
-- AUTO_INCREMENT untuk tabel `tb_petugas`
--
ALTER TABLE `tb_petugas`
MODIFY `id_petugas` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=37;
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 */;
Thx for coming