-- phpMyAdmin SQL Dump -- version 5.2.1 -- https://www.phpmyadmin.net/ -- -- Host: localhost -- Generation Time: Jan 19, 2026 at 02:23 AM -- Server version: 10.4.32-MariaDB -- PHP Version: 8.2.12 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; START TRANSACTION; SET time_zone = "+00:00"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8mb4 */; -- -- Database: `habuukarya` -- -- -------------------------------------------------------- -- -- Table structure for table `klien` -- CREATE TABLE `klien` ( `id_klien` int(5) NOT NULL, `nm_klien` varchar(50) NOT NULL, `logo` varchar(200) NOT NULL, `tlp` varchar(20) NOT NULL, `alamat` varchar(200) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `klien` -- INSERT INTO `klien` (`id_klien`, `nm_klien`, `logo`, `tlp`, `alamat`) VALUES (1, 'DP3AP2KB', 'dp3ap2kb kab bogor.png', '', 'Kabupaten Bogor'), (3, 'IGRA ', 'IGRA kab bogor.png', '', 'Kabupaten Bogor'), (4, 'PT KARIMA JAYA SEJAHTRINDO', 'kjs.png', '(021) 83731049', 'Jl. Nurul Abror Cipayung No.69, RT.04/RW.09, Tengah, Kec. Cibinong, Kabupaten Bogor, Jawa Barat 16914'), (7, 'RA ALFATAH', 'ra alfalah.png', '', 'Kabupaten Bogor'), (11, 'SMA INSAN KREATIF', 'sma insan kreatif.png', '', 'Kabupaten Bogor'), (12, 'Sekolah Menengah Kejuruan YAJ Depok', 'smk yaj depok.png', '(021) 87900425', 'Jl. Aridho No.01, RT.01/RW.04, Jatimulya, Kec. Cilodong, Kota Depok, Jawa Barat 16413'), (18, 'PT SANGKURIANG BANGUNAN SEJATI', '1768645246_habuu.png', '0876454241528', 'Jl. Nurul Abror Kp. Cipayung, RT.002/009 Cibinong, Bogor'); -- -------------------------------------------------------- -- -- Table structure for table `orders` -- CREATE TABLE `orders` ( `id` int(50) NOT NULL, `id_produk` int(50) NOT NULL, `category` varchar(50) NOT NULL, `gambar` varchar(200) NOT NULL, `no_order` varchar(30) NOT NULL, `customer_name` varchar(100) NOT NULL, `tlp` varchar(20) NOT NULL, `alamat` varchar(500) NOT NULL, `product_name` varchar(150) NOT NULL, `quantity` int(11) NOT NULL, `price` decimal(10,2) NOT NULL, `order_date` timestamp NULL DEFAULT current_timestamp(), `status` enum('Pending','Processing','Completed','Cancelled') DEFAULT 'Pending' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `orders` -- INSERT INTO `orders` (`id`, `id_produk`, `category`, `gambar`, `no_order`, `customer_name`, `tlp`, `alamat`, `product_name`, `quantity`, `price`, `order_date`, `status`) VALUES (1, 1, 'Instansi Pemerintah', '', 'HK-IP-23-0001', 'KELOMPOK KERJA RAUDHATUL ATHFAL (KKRA)\r\nKABUPATEN BOGOR', '', 'Kabupaten Bogor', 'Pengadaan cetak buku raport RA Kabupaten Bogor dan Pengadaan custom paper bag', 1000, 10000000.00, '2023-01-15 11:37:47', 'Completed'), (2, 1, 'Instansi Pemerintah', '', 'HK-IP-25-0002', 'UNIVERSITAS PAPUA (UNIPA)', '', 'Papua Barat', 'Pengadaan cetak dan promosi kampus serta Pengadaan custom plakat', 10000, 10000000.00, '2025-01-15 11:40:08', 'Completed'), (3, 1, 'Instansi Pemerintah', '', 'HK-IP-25-0003', 'DP3AP2KB KABUPATEN BOGOR', '', 'Kabupaten Bogor', 'Pengadaan cetak dan Pengadaan custom plakat', 10000, 30000000.00, '2025-01-15 11:40:08', 'Completed'), (4, 1, 'Instansi Pemerintah', '', 'HK-IP-25-0004', 'BKPSDM KABUPATEN BOGOR', '', 'Kabupaten Bogor', 'Pengadaan cetak dan Pengadaan custom ikat pinggang siswa', 10000, 30000000.00, '2025-01-15 11:43:15', 'Completed'), (5, 1, 'Instansi Pemerintah', '', 'HK-IP-25-0006', 'YAYASAN PENDIDIKAN YAJ', '', 'Kota Depok', 'Pengadaan cetak dan Pengadaan plakat', 2000, 16000000.00, '2025-01-15 11:43:42', 'Completed'), (6, 1, 'Instansi Pemerintah', '', 'HK-IP-25-0007', 'DINAS PARIWISATA KESENIAN DAN KEBUDAYAAN KABUPATEN KARAWANG', '', 'Kabupaten Karawang', 'Pengadaan cetak dan promosi dav Pengadaan plakat ', 4000, 20000000.00, '2025-01-15 11:43:42', 'Completed'), (7, 3, 'Retail', '', 'HK-RT-25-0001', 'Fani', '', 'Kabupaten Bogor', 'Pengadaan Paper Bag', 100, 1300000.00, '2025-01-15 11:53:44', 'Completed'), (8, 3, 'Retail', '', 'HK-RT-25-0002', 'Andre', '', 'Kabupaten Bogor', 'Pengadaan nama dada', 10, 500000.00, '2025-01-15 11:53:44', 'Completed'), (9, 3, 'Retail', '', 'HK-RT-25-0003', 'Komariah', '', 'Kota Depok', 'Pengadaan Medali', 10, 250000.00, '2025-01-15 11:57:37', 'Completed'), (10, 3, 'Retail', '', 'HK-RT-25-0004', 'Bagus Saputra', '', 'Kabupaten Bogor', 'Pengadaan cetak buku', 300, 5000000.00, '2025-01-15 11:57:37', 'Completed'), (11, 3, 'Retail', '', 'HK-RT-25-0005', 'Endah', '', 'Kota Bekasi', 'Pengadaan grafir tumbler', 50, 1500000.00, '2025-01-15 12:00:31', 'Completed'), (12, 3, 'Retail', '', 'HK-RT-25-0006', 'Wulan', '', 'Kabupaten Bogor', 'Pengadaan neon box', 1, 2000000.00, '2025-01-15 12:00:31', 'Completed'), (13, 3, 'Retail', '', 'HK-RT-25-0007', 'Dimas', '', 'Kabupaten Bogor', 'Pengadaan cetak buku yasin', 100, 3000000.00, '2025-01-15 12:00:50', 'Completed'), (14, 2, 'Swasta', '', 'HK-ST-19-0006', 'YAYASAN MUTIARA NUSANTARA', '', 'Kabupaten Bogor', 'Pengadaan cetak dan reklame serta Pengadaan plang reklame bahan besi galvanis', 2000, 60000000.00, '2021-01-15 12:00:50', 'Completed'), (15, 2, 'Swasta', '', 'HK-ST-20-0003', 'YAYASAN PENDIDIKAN ISLAM AL FALAH', '', 'Kabupaten Bogor', 'Pengadaan cetak dan Pengadaan Plakat Akrilik Wisuda TK Custom ', 20, 10000000.00, '2020-01-15 12:05:29', 'Completed'), (16, 2, 'Swasta', '', 'HK-ST-20-0005', 'YAYASAN PENDIDIKAN ISLAM AL FALAH', '', 'Kabupaten Bogor', 'Pengadaan cetak dan jam dinding custom', 400, 37000000.00, '2020-01-15 12:05:29', 'Completed'), (17, 2, 'Swasta', '', 'HK-ST-22-0001', 'PT. CON FIRE INDONESIA', '', 'Kota Tanggerang', 'Pengadaan cetak dan alat peraga K3 serta Pengadaan custom plakat', 390, 40000000.00, '2022-01-15 12:05:46', 'Completed'), (18, 2, 'Swasta', '', 'HK-ST-24-0002', 'YAYASAN PENDIDIKAN JAMIAT BINAKHEIR', '', 'Kota Depok', 'Pengadaan custom plakat / Trophy Akrilik', 50, 89000000.00, '2024-01-15 12:05:46', 'Completed'), (19, 2, 'Swasta', '', 'HK-ST-24-0004', 'PT. KARIMA JAYA SEJAHTRINDO', '', 'Kabupaten Bogor', 'Pengadaan cetak dan Pengadaan Plakat Akrilik Custom Bahan 5 mm + Box Bludru', 200, 30000000.00, '2024-01-15 12:14:28', 'Completed'), (20, 2, 'Swasta', '', 'HK-ST-24-0007', 'PONDOK PESANTREN DAARUSSALAAM', '', 'Kota Depok', 'Pengadaan cetak dan Pengadaan nama dada / name tag akrilik lapis resin', 50, 3070000.00, '2024-01-15 12:14:28', 'Completed'), (21, 2, 'Swasta', '', 'HK-2026/0022', 'HABUU KARYA', '', 'jl. muara jaya no567, bandung', 'Pengadaan cetak kalender', 100, 5000000.00, '2026-01-16 03:12:27', 'Completed'), (22, 2, 'Instansi Pemerintah', '', 'HK-2026/0044', 'HABUU KARYA', '', 'jl. h. konenng no34,jakartah nusantara', 'Pengadaan cetak kalender', 100, 4000000.00, '2026-01-16 05:11:24', 'Completed'), (24, 0, 'Swasta', '', 'HK-2026/0023', 'HABUU KARYA', '', 'Jl. Nurul Abror RT. 002/009 N0. 68 Kel. TengahKecamatan Cibinong, Kabupaten Bogor - Jawa Barat', 'Pengadaan cetak kalender', 9000, 4000000.00, '2026-01-16 21:54:41', 'Completed'); -- -------------------------------------------------------- -- -- Table structure for table `perusahaan` -- CREATE TABLE `perusahaan` ( `id_perusahaan` int(5) NOT NULL, `tgl` varchar(50) NOT NULL, `jam` time NOT NULL, `tlp1` varchar(50) NOT NULL, `akta_notaris` varchar(50) NOT NULL, `tlp2` varchar(50) NOT NULL, `file_aktanotaris` varchar(200) NOT NULL, `tlp3` varchar(50) NOT NULL, `alamat` varchar(200) NOT NULL, `email` varchar(50) NOT NULL, `file_npwp` varchar(50) NOT NULL, `nm_perusahaan` varchar(50) NOT NULL, `thn_berdiri` varchar(10) NOT NULL, `file_nib` varchar(200) NOT NULL, `file_sppkp` varchar(200) NOT NULL, `file_kmh_ham` varchar(200) NOT NULL, `npwp` varchar(50) NOT NULL, `nib` varchar(50) NOT NULL, `sppkp` varchar(50) NOT NULL, `kmh_ham` varchar(50) NOT NULL, `file_skt` varchar(200) NOT NULL, `skt` varchar(50) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `perusahaan` -- INSERT INTO `perusahaan` (`id_perusahaan`, `tgl`, `jam`, `tlp1`, `akta_notaris`, `tlp2`, `file_aktanotaris`, `tlp3`, `alamat`, `email`, `file_npwp`, `nm_perusahaan`, `thn_berdiri`, `file_nib`, `file_sppkp`, `file_kmh_ham`, `npwp`, `nib`, `sppkp`, `kmh_ham`, `file_skt`, `skt`) VALUES (1, '2026-01-15', '00:00:00', '081807411979', 'C.256.HT.03.01-TH.2006', '085777750444', '', '', 'Jl. Nurul Abror RT. 002/009 N0. 68 Kel. TengahKecamatan Cibinong, Kabupaten Bogor - Jawa Barat', 'admin@habuukarya.com', '', 'CV Habuu Karya', '2019', '', '', '', '964278352403000', '0299011180144 (4 November 2020)', 'S-00740/SPPKP-CT/KPP.3307/2025', 'AHU-0059413-AH.01.14 TH.2020', '', 'S-48653/SKT-WP-CT/KPP.3307/2025'); -- -------------------------------------------------------- -- -- Table structure for table `pesan` -- CREATE TABLE `pesan` ( `id_pesan` int(10) NOT NULL, `nama` varchar(100) NOT NULL, `email` varchar(100) NOT NULL, `subject` varchar(200) NOT NULL, `pesan` text NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `pesan` -- INSERT INTO `pesan` (`id_pesan`, `nama`, `email`, `subject`, `pesan`) VALUES (1, '$nama', '$mail', '$sub', '$pesan'), (2, 'Eko Sulistio', 'habuukarya@gmail.com', 'Tanya', 'casafafaf'), (3, 'Eko Sulistio', 'ekosulistio.business@gmail.com', 'Tanya', 'dgsga'), (4, 'SulistioEko ', 'habuukarya@gmail.com', 'ss', 'dd'), (5, 'Eko Sulistiofadfa', 'habuukarya@gmail.com', 'afafa', 'sdgsva'), (6, 'afasf', 'habuukarya@gmail.com', 'kjkhjlh;jsfsd', 'af\\fs\\ff'), (7, 'afafa', 'habuukarya@gmail.com', 'agaf', 'acafsgg'), (8, 'afasa', 'gdafa@afdafa', 'acacas', 'acacac'), (9, 'agaag', 'habuukarya@gmail.com', 'fdga', 'gdaggd'), (10, 'Muhyi oye', 'muhye@gmail.com', 'mau tanya dong', 'harga sembako berapa?'); -- -------------------------------------------------------- -- -- Table structure for table `produk` -- CREATE TABLE `produk` ( `id_produk` int(5) NOT NULL, `nm_produk` varchar(100) NOT NULL, `img_produk` varchar(500) NOT NULL, `harga_produk` decimal(10,2) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `produk` -- INSERT INTO `produk` (`id_produk`, `nm_produk`, `img_produk`, `harga_produk`) VALUES (1, 'Plakat Akrilik & Resin', '001.png', 155000.00), (3, 'Custom Tumbler Grafir & Print UV', '003.png', 100000.00), (4, 'Custom Paper Bag', '004.png', 35000.00), (7, 'Mug Custom', '007.png', 17500.00), (11, 'ID Card', '011.png', 15000.00), (12, 'Kartu Nama', '012.png', 100000.00), (16, 'Brosur & Pamflet', '1768671453_1768663205_016.png', 500000.00), (17, 'Goodie Bag', '017.png', 10000.00), (18, 'Plang Nama Ruang', '018.png', 150000.00), (20, 'Neon Box', '020.png', 500000.00), (21, 'Plang / Rambu K3', '021.png', 150000.00), (22, 'Plang / Papan Nama', '022.png', 200000.00), (24, 'Billborad', '024.png', 2000000.00), (29, 'Kalender Dinding & Meja', '1768662884_005.png', 25000.00), (30, 'Notebook & Buku Agenda', '1768662941_006.png', 25000.00), (31, 'Custom Casing ID Card', '1768662989_008.png', 150000.00), (32, 'Umbul-umbul & Bendera', '1768663019_009.png', 20000.00), (33, 'Custom Map', '1768663060_010.png', 15000.00), (34, 'Box Hampers / Box Packaging', '1768663146_015.png', 10000.00), (35, 'Brosur & Pamflet', '1768663205_016.png', 9500.00), (36, 'Huruf Timbul', '1768663289_019.png', 50000.00), (37, 'X-Banner & Roll Up Banner', '1768663387_023.png', 45000.00); -- -------------------------------------------------------- -- -- Table structure for table `team` -- CREATE TABLE `team` ( `id_team` int(5) NOT NULL, `nm` varchar(50) NOT NULL, `posisi` varchar(50) NOT NULL, `tlp` varchar(50) NOT NULL, `foto` varchar(200) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `team` -- INSERT INTO `team` (`id_team`, `nm`, `posisi`, `tlp`, `foto`) VALUES (1, 'Eko Sulistio', 'Business Development', '+62 857 7775 0444', 'eko2.jpg'), (3, 'Muhyi Rifani', 'General Manager', '+62 859 5925 1729', 'oye.jpg'), (4, 'M. Yusuf', 'Finance & Accounting', '', 'ucok.jpg'), (9, 'Muhammad Zakaria', 'Commissioner', '', '1768670347_m yusuf.jpg'), (10, 'Muhammad Bakri', 'Board Of Director', '+62 818 0741 1979', '1768670506_m bakri.jpg'), (11, 'Satria Nugraha', 'Production ', '+62 838 9535 7181', '1768670651_satria.jpg'); -- -------------------------------------------------------- -- -- Table structure for table `template` -- CREATE TABLE `template` ( `id_temp` int(5) NOT NULL, `nm_temp` varchar(50) DEFAULT NULL, `url` varchar(50) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -- Dumping data for table `template` -- INSERT INTO `template` (`id_temp`, `nm_temp`, `url`) VALUES (1, 'Style Default', 'css/style.default.css?'), (2, 'Style Dark', 'css/style.dark.css?'), (3, 'Style Orange', 'css/style.orange.css?'); -- -------------------------------------------------------- -- -- Table structure for table `user_login` -- CREATE TABLE `user_login` ( `id_user` varchar(50) NOT NULL, `username` varchar(50) NOT NULL, `pass` varchar(50) NOT NULL, `login_hash` varchar(50) NOT NULL, `id_temp` int(5) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `user_login` -- INSERT INTO `user_login` (`id_user`, `username`, `pass`, `login_hash`, `id_temp`) VALUES ('3', 'bakri', '698d51a19d8a121ce581499d7b701668', 'user', 3), ('hk001', 'eko', '698d51a19d8a121ce581499d7b701668', 'admin', 0), ('hk002', 'muhyi', '202cb962ac59075b964b07152d234b70', 'user', 1); -- -- Indexes for dumped tables -- -- -- Indexes for table `klien` -- ALTER TABLE `klien` ADD PRIMARY KEY (`id_klien`); -- -- Indexes for table `orders` -- ALTER TABLE `orders` ADD PRIMARY KEY (`id`); -- -- Indexes for table `perusahaan` -- ALTER TABLE `perusahaan` ADD PRIMARY KEY (`id_perusahaan`); -- -- Indexes for table `pesan` -- ALTER TABLE `pesan` ADD PRIMARY KEY (`id_pesan`); -- -- Indexes for table `produk` -- ALTER TABLE `produk` ADD PRIMARY KEY (`id_produk`); -- -- Indexes for table `team` -- ALTER TABLE `team` ADD PRIMARY KEY (`id_team`); -- -- Indexes for table `template` -- ALTER TABLE `template` ADD PRIMARY KEY (`id_temp`); -- -- Indexes for table `user_login` -- ALTER TABLE `user_login` ADD PRIMARY KEY (`username`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `klien` -- ALTER TABLE `klien` MODIFY `id_klien` int(5) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=19; -- -- AUTO_INCREMENT for table `orders` -- ALTER TABLE `orders` MODIFY `id` int(50) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=25; -- -- AUTO_INCREMENT for table `perusahaan` -- ALTER TABLE `perusahaan` MODIFY `id_perusahaan` int(5) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5; -- -- AUTO_INCREMENT for table `pesan` -- ALTER TABLE `pesan` MODIFY `id_pesan` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11; -- -- AUTO_INCREMENT for table `produk` -- ALTER TABLE `produk` MODIFY `id_produk` int(5) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=38; -- -- AUTO_INCREMENT for table `team` -- ALTER TABLE `team` MODIFY `id_team` int(5) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12; -- -- AUTO_INCREMENT for table `template` -- ALTER TABLE `template` MODIFY `id_temp` int(5) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4; 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 */;