-- phpMyAdmin SQL Dump -- version 5.2.0 -- https://www.phpmyadmin.net/ -- -- Host: 127.0.0.1 -- Generation Time: May 31, 2023 at 06:42 AM -- Server version: 10.4.24-MariaDB -- PHP Version: 7.4.29 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: `agrijayainventory` -- -- -------------------------------------------------------- -- -- Table structure for table `tb_aplikasi` -- CREATE TABLE `tb_aplikasi` ( `id` int(11) NOT NULL, `nama` varchar(256) NOT NULL, `telp` varchar(16) NOT NULL, `email` varchar(256) NOT NULL, `alamat` text NOT NULL, `logo` varchar(128) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `tb_aplikasi` -- INSERT INTO `tb_aplikasi` (`id`, `nama`, `telp`, `email`, `alamat`, `logo`) VALUES (1, 'Aplikasi Barang Masuk Keluar', '083190781585', 'heri@gmail.com', 'jln sukajadi jakarta', 'Logo-1685286289.png'); -- -------------------------------------------------------- -- -- Table structure for table `tb_brand` -- CREATE TABLE `tb_brand` ( `id` int(11) NOT NULL, `brand` varchar(155) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data for table `tb_brand` -- INSERT INTO `tb_brand` (`id`, `brand`) VALUES (1, 'Thosiba'), (3, 'Acer'); -- -------------------------------------------------------- -- -- Table structure for table `tb_category` -- CREATE TABLE `tb_category` ( `id` int(11) NOT NULL, `category` varchar(50) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data for table `tb_category` -- INSERT INTO `tb_category` (`id`, `category`) VALUES (1, 'Komputer'), (3, 'Acc Komputer'), (4, 'Sembako'); -- -------------------------------------------------------- -- -- Table structure for table `tb_iprouter` -- CREATE TABLE `tb_iprouter` ( `id` int(10) NOT NULL, `router` varchar(25) NOT NULL, `ip_router` varchar(25) NOT NULL, `nama` varchar(25) NOT NULL, `alamat` varchar(50) NOT NULL, `status` varchar(25) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data for table `tb_iprouter` -- INSERT INTO `tb_iprouter` (`id`, `router`, `ip_router`, `nama`, `alamat`, `status`) VALUES (123, 'huawei', '192.168.100.1', 'adi', 'kudu', 'aktif'), (125, 'orbitkk', '192.168.100.100kk', 'dedikk', 'jln sukajadikk', 'Tidak Aktif'); -- -------------------------------------------------------- -- -- Table structure for table `tb_issuing` -- CREATE TABLE `tb_issuing` ( `id` int(11) NOT NULL, `date` date NOT NULL, `no_issuing` varchar(128) DEFAULT NULL, `supplier` varchar(128) DEFAULT NULL, `id_master_data_barang` int(11) NOT NULL, `id_category` int(11) NOT NULL, `id_uom` int(11) NOT NULL, `jumlah` int(255) NOT NULL, `keterangan` varchar(128) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data for table `tb_issuing` -- INSERT INTO `tb_issuing` (`id`, `date`, `no_issuing`, `supplier`, `id_master_data_barang`, `id_category`, `id_uom`, `jumlah`, `keterangan`) VALUES (4, '2023-05-24', NULL, 'Garudafood', 13, 4, 3, 5, 'yasakarta'); -- -------------------------------------------------------- -- -- Table structure for table `tb_log` -- CREATE TABLE `tb_log` ( `id` int(11) NOT NULL, `idUser` int(11) NOT NULL, `ipAddress` varchar(32) NOT NULL, `device` text NOT NULL, `status` varchar(16) NOT NULL, `terdaftar` datetime NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `tb_log` -- INSERT INTO `tb_log` (`id`, `idUser`, `ipAddress`, `device`, `status`, `terdaftar`) VALUES (1, 1, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/104.0.0.0 Safari/537.36', 'Login', '2022-09-06 21:47:00'), (2, 1, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/104.0.0.0 Safari/537.36', 'Login', '2022-09-10 11:58:53'), (3, 1, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/105.0.0.0 Safari/537.36', 'Login', '2022-09-11 10:42:02'), (4, 1, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/105.0.0.0 Safari/537.36', 'Login', '2022-09-11 18:20:26'), (5, 1, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/106.0.0.0 Safari/537.36', 'Login', '2022-11-09 20:52:24'), (6, 1, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/106.0.0.0 Safari/537.36', 'Logout', '2022-11-09 20:57:06'), (7, 1, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/106.0.0.0 Safari/537.36', 'Login', '2022-11-09 20:57:14'), (8, 1, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/106.0.0.0 Safari/537.36', 'Logout', '2022-11-09 20:57:37'), (9, 3, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/106.0.0.0 Safari/537.36', 'Login', '2022-11-09 20:57:55'), (10, 3, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/106.0.0.0 Safari/537.36', 'Login', '2022-11-09 21:04:46'), (11, 3, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/106.0.0.0 Safari/537.36', 'Login', '2022-11-09 21:06:26'), (12, 1, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/107.0.0.0 Safari/537.36', 'Login', '2022-11-12 21:05:14'), (13, 1, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/107.0.0.0 Safari/537.36', 'Logout', '2022-11-12 21:05:51'), (14, 3, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/107.0.0.0 Safari/537.36', 'Login', '2022-11-12 21:06:11'), (15, 1, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/107.0.0.0 Safari/537.36', 'Login', '2022-11-14 20:31:08'), (16, 1, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/107.0.0.0 Safari/537.36', 'Logout', '2022-11-14 20:31:20'), (17, 3, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/107.0.0.0 Safari/537.36', 'Login', '2022-11-14 20:31:47'), (18, 3, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/107.0.0.0 Safari/537.36', 'Logout', '2022-11-14 21:03:52'), (19, 1, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/107.0.0.0 Safari/537.36', 'Login', '2022-11-14 21:04:05'), (20, 1, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/107.0.0.0 Safari/537.36', 'Logout', '2022-11-14 21:07:49'), (21, 3, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/107.0.0.0 Safari/537.36', 'Login', '2022-11-14 21:08:04'), (22, 1, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/107.0.0.0 Safari/537.36', 'Login', '2022-11-18 21:25:22'), (23, 1, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/107.0.0.0 Safari/537.36', 'Logout', '2022-11-18 21:25:29'), (24, 3, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/107.0.0.0 Safari/537.36', 'Login', '2022-11-18 21:25:39'), (25, 3, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/107.0.0.0 Safari/537.36', 'Login', '2022-11-18 21:57:13'), (26, 1, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/107.0.0.0 Safari/537.36', 'Login', '2022-11-19 21:46:58'), (27, 1, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/107.0.0.0 Safari/537.36', 'Logout', '2022-11-19 21:47:06'), (28, 3, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/107.0.0.0 Safari/537.36', 'Login', '2022-11-19 21:47:19'), (29, 3, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/107.0.0.0 Safari/537.36', 'Login', '2022-11-20 15:05:46'), (30, 1, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/107.0.0.0 Safari/537.36', 'Logout', '2022-11-20 16:51:23'), (31, 3, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/107.0.0.0 Safari/537.36', 'Login', '2022-11-20 16:51:33'), (32, 3, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/107.0.0.0 Safari/537.36', 'Login', '2022-11-20 21:46:31'), (33, 1, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/107.0.0.0 Safari/537.36', 'Logout', '2022-11-20 22:02:31'), (34, 3, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/107.0.0.0 Safari/537.36', 'Login', '2022-11-20 22:02:42'), (35, 3, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/107.0.0.0 Safari/537.36', 'Login', '2022-11-21 11:31:58'), (36, 3, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/107.0.0.0 Safari/537.36', 'Login', '2022-11-21 20:26:30'), (37, 1, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/107.0.0.0 Safari/537.36', 'Logout', '2022-11-21 20:35:18'), (38, 3, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/107.0.0.0 Safari/537.36', 'Login', '2022-11-21 20:35:28'), (39, 3, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/107.0.0.0 Safari/537.36', 'Login', '2022-11-22 20:47:15'), (40, 3, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/107.0.0.0 Safari/537.36', 'Logout', '2022-11-22 21:31:38'), (41, 3, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/107.0.0.0 Safari/537.36', 'Login', '2022-11-22 21:31:49'), (42, 3, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/107.0.0.0 Safari/537.36', 'Logout', '2022-11-22 21:34:52'), (43, 3, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/107.0.0.0 Safari/537.36', 'Login', '2022-11-22 21:34:56'), (44, 3, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/107.0.0.0 Safari/537.36', 'Logout', '2022-11-22 21:38:15'), (45, 3, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/107.0.0.0 Safari/537.36', 'Login', '2022-11-22 21:38:19'), (46, 3, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/107.0.0.0 Safari/537.36', 'Login', '2022-11-23 06:39:27'), (47, 1, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/107.0.0.0 Safari/537.36', 'Logout', '2022-11-23 06:56:50'), (48, 3, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/107.0.0.0 Safari/537.36', 'Login', '2022-11-23 07:00:55'), (49, 3, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/107.0.0.0 Safari/537.36', 'Login', '2022-11-23 20:30:30'), (50, 3, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/107.0.0.0 Safari/537.36', 'Login', '2022-11-24 20:51:50'), (51, 3, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/107.0.0.0 Safari/537.36', 'Login', '2022-11-26 09:13:46'), (52, 3, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/107.0.0.0 Safari/537.36', 'Login', '2022-11-26 10:48:34'), (53, 3, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/107.0.0.0 Safari/537.36', 'Login', '2022-11-26 15:49:34'), (54, 3, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/107.0.0.0 Safari/537.36', 'Login', '2022-11-27 06:53:32'), (55, 3, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/107.0.0.0 Safari/537.36', 'Login', '2022-11-27 21:35:36'), (56, 3, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/107.0.0.0 Safari/537.36', 'Login', '2022-11-28 20:27:00'), (57, 3, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36', 'Login', '2022-12-01 19:43:14'), (58, 1, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36', 'Login', '2022-12-01 20:04:42'), (59, 1, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36', 'Logout', '2022-12-01 20:04:54'), (60, 3, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36', 'Login', '2022-12-01 20:05:19'), (61, 3, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36', 'Login', '2022-12-02 16:27:26'), (62, 1, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36', 'Logout', '2022-12-02 16:45:38'), (63, 3, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36', 'Login', '2022-12-02 16:45:47'), (64, 3, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36', 'Login', '2022-12-02 17:24:37'), (65, 3, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36', 'Login', '2022-12-02 17:27:14'), (66, 3, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36', 'Login', '2022-12-03 17:55:31'), (67, 3, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36', 'Login', '2022-12-03 18:03:57'), (68, 3, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36', 'Login', '2022-12-03 19:35:05'), (69, 3, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36', 'Login', '2022-12-04 11:17:56'), (70, 3, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36', 'Login', '2022-12-04 12:54:58'), (71, 3, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36', 'Login', '2022-12-05 20:40:49'), (72, 1, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36', 'Login', '2022-12-07 21:55:44'), (73, 1, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36', 'Logout', '2022-12-07 21:55:50'), (74, 3, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36', 'Login', '2022-12-07 21:56:01'), (75, 3, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36', 'Login', '2022-12-08 21:34:37'), (76, 1, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36', 'Login', '2022-12-09 21:22:02'), (77, 1, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36', 'Logout', '2022-12-09 21:22:08'), (78, 3, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36', 'Login', '2022-12-09 21:22:18'), (79, 3, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36', 'Login', '2022-12-11 20:49:25'), (80, 3, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36', 'Login', '2022-12-13 10:06:56'), (81, 3, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36', 'Login', '2022-12-14 06:30:11'), (82, 1, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36', 'Login', '2022-12-18 20:52:06'), (83, 1, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36', 'Logout', '2022-12-18 20:52:16'), (84, 3, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36', 'Login', '2022-12-18 20:52:25'), (85, 3, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36', 'Login', '2022-12-19 20:30:06'), (86, 3, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36', 'Login', '2022-12-20 20:22:56'), (87, 1, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36', 'Logout', '2022-12-20 20:33:38'), (88, 3, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36', 'Login', '2022-12-20 20:33:48'), (89, 3, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36', 'Login', '2022-12-21 08:56:51'), (90, 1, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36', 'Login', '2022-12-21 20:14:09'), (91, 1, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36', 'Logout', '2022-12-21 20:14:16'), (92, 3, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36', 'Login', '2022-12-21 20:14:25'), (93, 1, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36', 'Logout', '2022-12-21 21:19:23'), (94, 3, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36', 'Login', '2022-12-21 21:19:30'), (95, 3, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36', 'Login', '2022-12-22 20:30:00'), (96, 1, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36', 'Logout', '2022-12-22 20:56:06'), (97, 3, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36', 'Login', '2022-12-22 20:56:15'), (98, 1, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36', 'Logout', '2022-12-22 21:28:37'), (99, 3, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36', 'Login', '2022-12-22 21:28:48'), (100, 3, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36', 'Login', '2022-12-23 21:32:56'), (101, 3, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36', 'Login', '2022-12-27 20:08:37'), (102, 1, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36', 'Logout', '2022-12-27 21:43:33'), (103, 3, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36', 'Login', '2022-12-27 21:43:45'), (104, 1, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36', 'Login', '2022-12-28 20:29:49'), (105, 1, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36', 'Logout', '2022-12-28 20:29:55'), (106, 1, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36', 'Login', '2022-12-28 20:30:00'), (107, 1, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36', 'Logout', '2022-12-28 20:30:05'), (108, 1, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36', 'Login', '2022-12-28 20:30:12'), (109, 1, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36', 'Logout', '2022-12-28 20:30:21'), (110, 3, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36', 'Login', '2022-12-28 20:30:37'), (111, 3, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36', 'Login', '2022-12-29 20:37:32'), (112, 3, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36', 'Login', '2022-12-31 12:15:49'), (113, 3, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36', 'Login', '2023-01-04 21:02:59'), (114, 1, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36', 'Login', '2023-01-09 20:55:45'), (115, 1, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36', 'Logout', '2023-01-09 20:55:52'), (116, 3, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36', 'Login', '2023-01-09 20:56:08'), (117, 3, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36', 'Login', '2023-01-10 21:08:19'), (118, 1, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36', 'Login', '2023-01-13 10:32:06'), (119, 1, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36', 'Logout', '2023-01-13 10:32:14'), (120, 3, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36', 'Login', '2023-01-13 10:32:24'), (121, 1, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36', 'Logout', '2023-01-13 22:42:20'), (122, 3, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36', 'Login', '2023-01-13 22:42:27'), (123, 1, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/109.0.0.0 Safari/537.36', 'Logout', '2023-01-25 21:36:46'), (124, 1, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/109.0.0.0 Safari/537.36', 'Login', '2023-01-25 21:37:07'), (125, 1, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/109.0.0.0 Safari/537.36', 'Logout', '2023-01-25 21:38:40'), (126, 3, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/109.0.0.0 Safari/537.36', 'Login', '2023-01-25 21:38:57'), (127, 3, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/109.0.0.0 Safari/537.36', 'Login', '2023-01-26 21:13:48'), (128, 1, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/109.0.0.0 Safari/537.36', 'Login', '2023-01-28 13:25:35'), (129, 1, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/109.0.0.0 Safari/537.36', 'Logout', '2023-01-28 13:26:49'), (130, 3, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/109.0.0.0 Safari/537.36', 'Login', '2023-01-28 13:27:36'), (131, 3, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/109.0.0.0 Safari/537.36', 'Login', '2023-02-01 21:14:45'), (132, 3, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/109.0.0.0 Safari/537.36', 'Login', '2023-02-02 21:11:14'), (133, 3, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/109.0.0.0 Safari/537.36', 'Login', '2023-02-03 21:06:08'), (134, 3, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/109.0.0.0 Safari/537.36', 'Login', '2023-02-04 10:04:54'), (135, 3, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/109.0.0.0 Safari/537.36', 'Logout', '2023-02-04 11:42:04'), (136, 1, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/109.0.0.0 Safari/537.36', 'Login', '2023-02-04 11:42:11'), (137, 1, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/109.0.0.0 Safari/537.36', 'Logout', '2023-02-04 11:47:06'), (138, 4, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/109.0.0.0 Safari/537.36', 'Login', '2023-02-04 11:47:22'), (139, 4, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/109.0.0.0 Safari/537.36', 'Login', '2023-02-04 11:49:29'), (140, 4, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/109.0.0.0 Safari/537.36', 'Login', '2023-02-04 11:50:10'), (141, 4, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/109.0.0.0 Safari/537.36', 'Logout', '2023-02-04 11:50:49'), (142, 3, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/109.0.0.0 Safari/537.36', 'Login', '2023-02-04 11:51:00'), (143, 3, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/109.0.0.0 Safari/537.36', 'Logout', '2023-02-04 11:54:44'), (144, 4, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/109.0.0.0 Safari/537.36', 'Login', '2023-02-04 11:54:53'), (145, 3, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/109.0.0.0 Safari/537.36', 'Login', '2023-02-04 11:56:16'), (146, 3, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/109.0.0.0 Safari/537.36', 'Logout', '2023-02-04 11:56:26'), (147, 4, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/109.0.0.0 Safari/537.36', 'Login', '2023-02-04 11:57:09'), (148, 4, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/109.0.0.0 Safari/537.36', 'Logout', '2023-02-04 11:57:44'), (149, 1, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/109.0.0.0 Safari/537.36', 'Login', '2023-02-04 11:57:54'), (150, 1, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/109.0.0.0 Safari/537.36', 'Logout', '2023-02-04 12:00:05'), (151, 4, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/109.0.0.0 Safari/537.36', 'Login', '2023-02-04 12:00:15'), (152, 4, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/109.0.0.0 Safari/537.36', 'Logout', '2023-02-04 12:19:00'), (153, 3, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/109.0.0.0 Safari/537.36', 'Login', '2023-02-04 12:19:11'), (154, 3, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/109.0.0.0 Safari/537.36', 'Logout', '2023-02-04 12:19:42'), (155, 1, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/109.0.0.0 Safari/537.36', 'Login', '2023-02-04 12:19:58'), (156, 1, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/109.0.0.0 Safari/537.36', 'Logout', '2023-02-04 12:33:51'), (157, 3, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/109.0.0.0 Safari/537.36', 'Login', '2023-02-04 12:34:05'), (158, 3, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/109.0.0.0 Safari/537.36', 'Logout', '2023-02-04 12:36:41'), (159, 3, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/109.0.0.0 Safari/537.36', 'Login', '2023-02-04 12:36:46'), (160, 4, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/109.0.0.0 Safari/537.36', 'Login', '2023-02-04 15:11:58'), (161, 4, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/109.0.0.0 Safari/537.36', 'Logout', '2023-02-04 15:19:04'), (162, 1, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/109.0.0.0 Safari/537.36', 'Login', '2023-02-04 15:19:15'), (163, 1, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/109.0.0.0 Safari/537.36', 'Logout', '2023-02-04 15:23:38'), (164, 3, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/109.0.0.0 Safari/537.36', 'Login', '2023-02-04 15:24:10'), (165, 3, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/113.0.0.0 Safari/537.36', 'Login', '2023-05-28 19:43:53'), (166, 3, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/113.0.0.0 Safari/537.36', 'Logout', '2023-05-28 22:03:35'), (167, 1, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/113.0.0.0 Safari/537.36', 'Login', '2023-05-28 22:03:44'), (168, 1, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/113.0.0.0 Safari/537.36', 'Logout', '2023-05-28 22:04:54'), (169, 3, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/113.0.0.0 Safari/537.36', 'Login', '2023-05-28 22:05:19'), (170, 3, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/113.0.0.0 Safari/537.36', 'Logout', '2023-05-28 22:19:24'), (171, 3, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/113.0.0.0 Safari/537.36', 'Login', '2023-05-29 20:19:18'), (172, 3, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/113.0.0.0 Safari/537.36', 'Login', '2023-05-30 21:00:37'), (173, 3, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/113.0.0.0 Safari/537.36', 'Login', '2023-05-31 08:20:41'); -- -------------------------------------------------------- -- -- Table structure for table `tb_master_data_barang` -- CREATE TABLE `tb_master_data_barang` ( `id` int(11) NOT NULL, `date` date NOT NULL, `kd_barang` varchar(25) NOT NULL, `nama_barang` varchar(225) NOT NULL, `id_category` int(11) NOT NULL, `id_brand` int(11) DEFAULT NULL, `id_uom` int(11) NOT NULL, `move_type` varchar(50) DEFAULT NULL, `price` varchar(50) DEFAULT NULL, `img` varchar(25) DEFAULT NULL, `remarks` varchar(50) DEFAULT NULL, `stock` int(155) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data for table `tb_master_data_barang` -- INSERT INTO `tb_master_data_barang` (`id`, `date`, `kd_barang`, `nama_barang`, `id_category`, `id_brand`, `id_uom`, `move_type`, `price`, `img`, `remarks`, `stock`) VALUES (12, '2023-05-28', '1234', 'Kopii', 1, NULL, 1, NULL, NULL, NULL, NULL, 156), (13, '2023-05-28', '10001', 'Beras Rangkong', 4, NULL, 3, NULL, NULL, NULL, NULL, -41); -- -------------------------------------------------------- -- -- Table structure for table `tb_pelanggan` -- CREATE TABLE `tb_pelanggan` ( `id` int(11) NOT NULL, `nama` varchar(256) NOT NULL, `telp` varchar(256) NOT NULL, `alamat` varchar(256) NOT NULL, `tgltagihan` int(11) NOT NULL, `nominal` int(11) NOT NULL, `status` varchar(32) NOT NULL, `terdaftar` datetime NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data for table `tb_pelanggan` -- INSERT INTO `tb_pelanggan` (`id`, `nama`, `telp`, `alamat`, `tgltagihan`, `nominal`, `status`, `terdaftar`) VALUES (1, 'anis', '23234234', 'jl melati', 8, 200000, 'Aktif', '2022-09-11 11:33:00'), (2, 'heri', '23234234', 'belimbing', 9, 30000, 'Tidak Aktif', '2022-09-11 11:36:24'); -- -------------------------------------------------------- -- -- Table structure for table `tb_pembayaran` -- CREATE TABLE `tb_pembayaran` ( `id` int(11) NOT NULL, `idUser` int(11) NOT NULL, `idPelanggan` int(11) NOT NULL, `tanggal` date NOT NULL, `nominal` int(11) NOT NULL, `terdaftar` datetime NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `tb_pembayaran` -- INSERT INTO `tb_pembayaran` (`id`, `idUser`, `idPelanggan`, `tanggal`, `nominal`, `terdaftar`) VALUES (1, 1, 2, '2022-09-11', 30000, '2022-09-11 11:37:05'); -- -------------------------------------------------------- -- -- Table structure for table `tb_product` -- CREATE TABLE `tb_product` ( `id` int(11) NOT NULL, `id_receiving` int(11) NOT NULL, `product` varchar(50) NOT NULL, `jumlah` varchar(50) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -------------------------------------------------------- -- -- Table structure for table `tb_productissuing` -- CREATE TABLE `tb_productissuing` ( `id` int(11) NOT NULL, `idissuing` int(128) NOT NULL, `id_master_data_barang` int(129) NOT NULL, `id_uom` int(128) NOT NULL, `jumlah` int(50) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data for table `tb_productissuing` -- INSERT INTO `tb_productissuing` (`id`, `idissuing`, `id_master_data_barang`, `id_uom`, `jumlah`) VALUES (2, 5, 5, 3, 3), (7, 2, 7, 3, 2), (8, 2, 7, 3, 45), (11, 3, 13, 3, 55); -- -- Triggers `tb_productissuing` -- DELIMITER $$ CREATE TRIGGER `Kurangi Stok data barang` AFTER INSERT ON `tb_productissuing` FOR EACH ROW BEGIN UPDATE tb_master_data_barang SET stock = stock - NEW.jumlah WHERE id = NEW.id_master_data_barang; END $$ DELIMITER ; DELIMITER $$ CREATE TRIGGER `Tambah Stok dari delete Data Barang` AFTER DELETE ON `tb_productissuing` FOR EACH ROW BEGIN UPDATE tb_master_data_barang SET stock = stock + OLD.jumlah WHERE id= OLD.id_master_data_barang; END $$ DELIMITER ; -- -------------------------------------------------------- -- -- Table structure for table `tb_productreceiving` -- CREATE TABLE `tb_productreceiving` ( `id` int(11) NOT NULL, `idReceiving` int(11) NOT NULL, `id_master_data_barang` int(11) NOT NULL, `id_uom` int(50) NOT NULL, `id_category` int(11) NOT NULL, `jumlah` int(15) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data for table `tb_productreceiving` -- INSERT INTO `tb_productreceiving` (`id`, `idReceiving`, `id_master_data_barang`, `id_uom`, `id_category`, `jumlah`) VALUES (1, 5, 5, 0, 0, 5), (2, 5, 0, 0, 0, 7), (3, 5, 0, 0, 0, 9), (4, 7, 0, 0, 0, 6), (5, 7, 0, 0, 0, 5), (6, 7, 0, 0, 0, 5), (7, 7, 0, 0, 0, 12), (11, 10, 5, 1, 0, 6), (17, 10, 6, 3, 0, 3), (18, 10, 6, 3, 0, 3), (19, 10, 6, 1, 0, 50), (20, 2, 6, 3, 0, 12), (21, 10, 8, 1, 0, 50), (22, 11, 12, 3, 3, 50), (24, 11, 13, 3, 1, 5); -- -- Triggers `tb_productreceiving` -- DELIMITER $$ CREATE TRIGGER `hapus stok dari product receiving` AFTER DELETE ON `tb_productreceiving` FOR EACH ROW BEGIN UPDATE tb_master_data_barang SET stock = stock - OLD.jumlah WHERE id= OLD.id_master_data_barang; END $$ DELIMITER ; DELIMITER $$ CREATE TRIGGER `otomatis menambah jumlah stok dari receiving` AFTER INSERT ON `tb_productreceiving` FOR EACH ROW BEGIN UPDATE tb_master_data_barang SET stock = stock + NEW.jumlah WHERE id = NEW.id_master_data_barang; END $$ DELIMITER ; -- -------------------------------------------------------- -- -- Table structure for table `tb_receiving` -- CREATE TABLE `tb_receiving` ( `id` int(11) NOT NULL, `date` date NOT NULL, `no_receiving` varchar(30) DEFAULT NULL, `supplier` varchar(50) DEFAULT NULL, `id_master_data_barang` int(11) NOT NULL, `id_category` int(11) NOT NULL, `id_uom` int(11) NOT NULL, `kd_barang` int(29) DEFAULT NULL, `nama_barang` varchar(255) DEFAULT NULL, `jumlah` int(11) DEFAULT NULL, `keterangan` varchar(11) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data for table `tb_receiving` -- INSERT INTO `tb_receiving` (`id`, `date`, `no_receiving`, `supplier`, `id_master_data_barang`, `id_category`, `id_uom`, `kd_barang`, `nama_barang`, `jumlah`, `keterangan`) VALUES (11, '2023-05-31', '-', 'garuda foodss', 13, 4, 3, NULL, NULL, 123, 'Wagiyosss'); -- -------------------------------------------------------- -- -- Table structure for table `tb_request` -- CREATE TABLE `tb_request` ( `id` int(11) NOT NULL, `tanggal` date NOT NULL, `category` varchar(150) NOT NULL, `kd_barang` int(11) NOT NULL, `nama_barang` varchar(250) NOT NULL, `jumlah` int(11) NOT NULL, `id_uom` int(11) NOT NULL, `keterangan` varchar(250) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data for table `tb_request` -- INSERT INTO `tb_request` (`id`, `tanggal`, `category`, `kd_barang`, `nama_barang`, `jumlah`, `id_uom`, `keterangan`) VALUES (1, '2023-02-28', 'Minuman', 1111, 'Fanta', 15, 1, 'untuk di beli'); -- -------------------------------------------------------- -- -- Table structure for table `tb_uom` -- CREATE TABLE `tb_uom` ( `id` int(11) NOT NULL, `nama_satuan` varchar(50) NOT NULL, `keterangan` varchar(50) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data for table `tb_uom` -- INSERT INTO `tb_uom` (`id`, `nama_satuan`, `keterangan`) VALUES (1, 'Lsn', 'Lusin'), (3, 'Pcs ', 'Pcs '); -- -------------------------------------------------------- -- -- Table structure for table `tb_user` -- CREATE TABLE `tb_user` ( `id` int(11) NOT NULL, `nama` varchar(256) NOT NULL, `telp` varchar(16) NOT NULL, `email` varchar(256) NOT NULL, `username` varchar(256) NOT NULL, `password` varchar(256) NOT NULL, `foto` varchar(128) NOT NULL, `skin` varchar(8) NOT NULL, `level` varchar(16) NOT NULL, `terdaftar` datetime NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `tb_user` -- INSERT INTO `tb_user` (`id`, `nama`, `telp`, `email`, `username`, `password`, `foto`, `skin`, `level`, `terdaftar`) VALUES (1, 'Heri Munandar', '089618367556', 'heri@gmail.com', 'admin', '$2y$10$9TaSeFe6kKW/cIss60nBMuxlply7m3.STeQ9H76R3uVU2Z9Q5oDUm', 'Profil-1662908905.jpg', 'purple', 'Administrator', '2022-09-06 18:57:59'), (3, 'heri', '123', 'heri@gmail.com', 'heri', '$2y$10$XzN9AlLydCmJIKcB2PU5Lu.njQaYwLBBvjf7jcquvsi598u0Lq1Fy', 'no-image.png', 'blue', 'Operator', '2022-11-08 21:17:53'), (4, 'deni', '0812', 'deni@gmail.com', 'deni', '$2y$10$ALyiHDQTPEcUM8W8n0xuQej.Z2IqW3NVe0eXpC1k652M4TJJzPEey', 'no-image.png', 'blue', 'Manager', '2023-02-04 11:42:54'); -- -- Indexes for dumped tables -- -- -- Indexes for table `tb_aplikasi` -- ALTER TABLE `tb_aplikasi` ADD PRIMARY KEY (`id`); -- -- Indexes for table `tb_brand` -- ALTER TABLE `tb_brand` ADD PRIMARY KEY (`id`); -- -- Indexes for table `tb_category` -- ALTER TABLE `tb_category` ADD PRIMARY KEY (`id`); -- -- Indexes for table `tb_iprouter` -- ALTER TABLE `tb_iprouter` ADD PRIMARY KEY (`id`); -- -- Indexes for table `tb_issuing` -- ALTER TABLE `tb_issuing` ADD PRIMARY KEY (`id`); -- -- Indexes for table `tb_log` -- ALTER TABLE `tb_log` ADD PRIMARY KEY (`id`), ADD KEY `FK04` (`idUser`); -- -- Indexes for table `tb_master_data_barang` -- ALTER TABLE `tb_master_data_barang` ADD PRIMARY KEY (`id`); -- -- Indexes for table `tb_pelanggan` -- ALTER TABLE `tb_pelanggan` ADD PRIMARY KEY (`id`); -- -- Indexes for table `tb_pembayaran` -- ALTER TABLE `tb_pembayaran` ADD PRIMARY KEY (`id`); -- -- Indexes for table `tb_product` -- ALTER TABLE `tb_product` ADD PRIMARY KEY (`id`); -- -- Indexes for table `tb_productissuing` -- ALTER TABLE `tb_productissuing` ADD PRIMARY KEY (`id`); -- -- Indexes for table `tb_productreceiving` -- ALTER TABLE `tb_productreceiving` ADD PRIMARY KEY (`id`); -- -- Indexes for table `tb_receiving` -- ALTER TABLE `tb_receiving` ADD PRIMARY KEY (`id`); -- -- Indexes for table `tb_request` -- ALTER TABLE `tb_request` ADD PRIMARY KEY (`id`); -- -- Indexes for table `tb_uom` -- ALTER TABLE `tb_uom` ADD PRIMARY KEY (`id`); -- -- Indexes for table `tb_user` -- ALTER TABLE `tb_user` ADD PRIMARY KEY (`id`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `tb_aplikasi` -- ALTER TABLE `tb_aplikasi` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `tb_brand` -- ALTER TABLE `tb_brand` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4; -- -- AUTO_INCREMENT for table `tb_category` -- ALTER TABLE `tb_category` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5; -- -- AUTO_INCREMENT for table `tb_iprouter` -- ALTER TABLE `tb_iprouter` MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=126; -- -- AUTO_INCREMENT for table `tb_issuing` -- ALTER TABLE `tb_issuing` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5; -- -- AUTO_INCREMENT for table `tb_log` -- ALTER TABLE `tb_log` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=174; -- -- AUTO_INCREMENT for table `tb_master_data_barang` -- ALTER TABLE `tb_master_data_barang` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14; -- -- AUTO_INCREMENT for table `tb_pelanggan` -- ALTER TABLE `tb_pelanggan` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- AUTO_INCREMENT for table `tb_pembayaran` -- ALTER TABLE `tb_pembayaran` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `tb_product` -- ALTER TABLE `tb_product` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `tb_productissuing` -- ALTER TABLE `tb_productissuing` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12; -- -- AUTO_INCREMENT for table `tb_productreceiving` -- ALTER TABLE `tb_productreceiving` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=26; -- -- AUTO_INCREMENT for table `tb_receiving` -- ALTER TABLE `tb_receiving` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13; -- -- AUTO_INCREMENT for table `tb_request` -- ALTER TABLE `tb_request` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- AUTO_INCREMENT for table `tb_uom` -- ALTER TABLE `tb_uom` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4; -- -- AUTO_INCREMENT for table `tb_user` -- ALTER TABLE `tb_user` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5; -- -- Constraints for dumped tables -- -- -- Constraints for table `tb_log` -- ALTER TABLE `tb_log` ADD CONSTRAINT `FK01` FOREIGN KEY (`idUser`) REFERENCES `tb_user` (`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 */;