-- https://www.phpmyadmin.net/
--

START TRANSACTION;



--
-- Database: `simplepos_db`
--

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

--
-- Table structure for table `cash_flows`
--

CREATE TABLE `cash_flows` (
  `id` int(11) NOT NULL,
  `shift_id` int(11) DEFAULT NULL,
  `jenis` enum('masuk_lain','keluar_ops','setor_bos') NOT NULL,
  `nominal` decimal(15,2) NOT NULL,
  `keterangan` varchar(255) DEFAULT NULL,
  `waktu` datetime DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `cash_flows`
--

INSERT INTO `cash_flows` (`id`, `shift_id`, `jenis`, `nominal`, `keterangan`, `waktu`) VALUES
(1, 1, 'keluar_ops', '10000.00', 'Biaya Makan Siang', '2025-12-07 09:01:38'),
(2, 2, 'keluar_ops', '2000.00', 'parkir bw', '2025-12-07 13:20:03'),
(3, 3, 'keluar_ops', '10000.00', 'uang makan siang / bakso', '2025-12-14 14:43:19'),
(4, 3, 'keluar_ops', '100000.00', 'Bayar Sales Nota No. 23234', '2025-12-14 14:49:17'),
(5, 4, 'keluar_ops', '9500.00', 'beli plastik', '2025-12-14 16:00:27'),
(6, 4, 'keluar_ops', '5000.00', 'Anak Bos beli Bakso', '2025-12-14 16:20:18'),
(7, 9, 'setor_bos', '74000.00', 'setor tutup kasir', '2025-12-14 20:17:47'),
(8, 9, 'keluar_ops', '10000.00', 'plastik', '2025-12-15 07:12:36'),
(9, 10, 'keluar_ops', '1000.00', 'Pengamen', '2025-12-15 11:23:34'),
(10, 10, 'keluar_ops', '5000.00', 'beli plastik', '2025-12-15 11:24:28'),
(11, 10, 'setor_bos', '10000.00', 'Pak bos Ambil Uang', '2025-12-15 11:24:54'),
(12, 10, 'masuk_lain', '5000.00', 'pAK bOS kEMBALIKAN UANG ', '2025-12-15 11:25:39');

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

--
-- Table structure for table `categories`
--

CREATE TABLE `categories` (
  `id` int(11) NOT NULL,
  `kode_kategori` char(2) NOT NULL,
  `nama_kategori` varchar(50) NOT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `categories`
--

INSERT INTO `categories` (`id`, `kode_kategori`, `nama_kategori`, `created_at`) VALUES
(1, '01', 'Makanan', '2025-12-15 05:48:32'),
(2, '02', 'Minuman', '2025-12-15 05:48:32'),
(3, '03', 'Palen Pakaian', '2025-12-15 05:48:32'),
(4, '04', 'Palen Lainnya', '2025-12-15 05:48:32'),
(5, '05', 'AICE', '2025-12-15 05:48:32'),
(6, '99', 'LAINNYA', '2025-12-15 06:00:50');

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

--
-- Table structure for table `orders`
--

CREATE TABLE `orders` (
  `id` int(11) NOT NULL,
  `shift_id` int(11) DEFAULT NULL,
  `no_invoice` varchar(30) DEFAULT NULL,
  `tanggal` datetime DEFAULT NULL,
  `subtotal_barang` decimal(15,2) DEFAULT NULL,
  `diskon_total` decimal(15,2) DEFAULT '0.00',
  `pajak_ppn` decimal(15,2) DEFAULT '0.00',
  `grand_total` decimal(15,2) DEFAULT NULL,
  `bayar` decimal(15,2) DEFAULT NULL,
  `kembali` decimal(15,2) DEFAULT NULL,
  `metode_bayar` varchar(50) DEFAULT 'CASH'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `orders`
--

INSERT INTO `orders` (`id`, `shift_id`, `no_invoice`, `tanggal`, `subtotal_barang`, `diskon_total`, `pajak_ppn`, `grand_total`, `bayar`, `kembali`, `metode_bayar`) VALUES
(1, 1, 'INV/2512/0001', '2025-12-07 06:28:12', '23500.00', '0.00', '0.00', '23500.00', '25000.00', '1500.00', 'CASH'),
(2, 2, 'INV/2512/0002', '2025-12-07 12:32:13', '20000.00', '0.00', '0.00', '20000.00', '20000.00', '0.00', 'CASH'),
(3, 2, 'INV/2512/0003', '2025-12-07 13:44:11', '6000.00', '0.00', '0.00', '6000.00', '10000.00', '4000.00', 'CASH'),
(4, 2, 'INV/2512/0004', '2025-12-07 14:22:56', '120000.00', '0.00', '0.00', '120000.00', '150000.00', '30000.00', 'QRIS'),
(5, 2, 'INV/2512/0005', '2025-12-07 14:24:10', '5000.00', '0.00', '0.00', '5000.00', '10000.00', '5000.00', 'TRANSFER'),
(6, 3, 'INV/2512/0006', '2025-12-11 11:36:10', '12000.00', '0.00', '0.00', '12000.00', '12000.00', '0.00', 'CASH'),
(7, 3, 'INV/2512/0007', '2025-12-11 11:43:49', '3000.00', '0.00', '0.00', '3000.00', '3000.00', '0.00', 'CASH'),
(8, 3, 'INV/2512/0008', '2025-12-11 11:49:16', '20000.00', '0.00', '0.00', '20000.00', '20000.00', '0.00', 'CASH'),
(9, 3, 'INV/2512/0009', '2025-12-11 12:01:08', '3000.00', '0.00', '0.00', '3000.00', '3000.00', '0.00', 'CASH'),
(10, 3, 'INV/2512/0010', '2025-12-11 12:06:18', '3000.00', '0.00', '0.00', '3000.00', '5000.00', '2000.00', 'CASH'),
(11, 3, 'INV/2512/0011', '2025-12-11 12:07:48', '3000.00', '0.00', '0.00', '3000.00', '3500.00', '500.00', 'CASH'),
(12, 3, 'INV/2512/0012', '2025-12-11 12:08:10', '3000.00', '0.00', '0.00', '3000.00', '3000.00', '0.00', 'CASH'),
(13, 3, 'INV/2512/0013', '2025-12-11 12:09:43', '20000.00', '0.00', '0.00', '20000.00', '20000.00', '0.00', 'CASH'),
(14, 3, 'INV/2512/0014', '2025-12-11 12:10:46', '3000.00', '0.00', '0.00', '3000.00', '3000.00', '0.00', 'CASH'),
(15, 3, 'INV/2512/0015', '2025-12-11 12:11:09', '3000.00', '0.00', '0.00', '3000.00', '3000.00', '0.00', 'CASH'),
(16, 3, 'INV/2512/0016', '2025-12-11 12:13:43', '3000.00', '0.00', '0.00', '3000.00', '3000.00', '0.00', 'CASH'),
(17, 3, 'INV/2512/0017', '2025-12-11 12:47:47', '3000.00', '0.00', '0.00', '3000.00', '3000.00', '0.00', 'CASH'),
(18, 3, 'INV/2512/0018', '2025-12-11 20:01:13', '6000.00', '0.00', '0.00', '6000.00', '6000.00', '0.00', 'CASH'),
(19, 3, 'INV/2512/0019', '2025-12-11 21:05:01', '3000.00', '0.00', '0.00', '3000.00', '3000.00', '0.00', 'CASH'),
(20, 3, 'INV/2512/0020', '2025-12-11 21:18:58', '3000.00', '0.00', '0.00', '3000.00', '3000.00', '0.00', 'CASH'),
(21, 3, 'INV/2512/0021', '2025-12-11 21:23:01', '12000.00', '0.00', '0.00', '12000.00', '15000.00', '3000.00', 'CASH'),
(22, 3, 'INV/2512/0022', '2025-12-11 22:37:21', '14000.00', '0.00', '0.00', '14000.00', '15000.00', '1000.00', 'CASH'),
(23, 3, 'INV/2512/0023', '2025-12-12 07:02:47', '8000.00', '0.00', '0.00', '8000.00', '10000.00', '2000.00', 'CASH'),
(24, 3, 'INV/2512/0024', '2025-12-12 07:05:48', '12000.00', '0.00', '0.00', '12000.00', '12000.00', '0.00', 'CASH'),
(25, 3, 'INV/2512/0025', '2025-12-12 07:32:25', '14500.00', '0.00', '0.00', '14500.00', '15000.00', '500.00', 'CASH'),
(26, 3, 'INV/2512/0026', '2025-12-12 07:35:28', '12500.00', '0.00', '0.00', '12500.00', '15000.00', '2500.00', 'CASH'),
(27, 3, 'INV/2512/0027', '2025-12-14 13:45:48', '32000.00', '0.00', '0.00', '32000.00', '35000.00', '3000.00', 'CASH'),
(28, 3, 'INV/2512/0028', '2025-12-14 13:47:50', '38000.00', '0.00', '0.00', '38000.00', '38000.00', '0.00', 'CASH'),
(29, 3, 'INV/2512/0029', '2025-12-14 14:35:49', '4000.00', '0.00', '0.00', '4000.00', '5000.00', '1000.00', 'CASH'),
(30, 4, 'INV/2512/0030', '2025-12-14 16:00:00', '20000.00', '0.00', '0.00', '20000.00', '20000.00', '0.00', 'CASH'),
(31, 5, 'INV/2512/0031', '2025-12-14 16:47:47', '12500.00', '0.00', '0.00', '12500.00', '15000.00', '2500.00', 'CASH'),
(32, 9, 'INV/2512/0032', '2025-12-14 20:08:01', '5000.00', '0.00', '0.00', '5000.00', '5000.00', '0.00', 'CASH'),
(33, 4, 'INV/2512/0033', '2025-12-14 20:15:41', '4000.00', '0.00', '0.00', '4000.00', '4000.00', '0.00', 'CASH'),
(34, 9, 'INV/2512/0034', '2025-12-14 20:16:30', '19000.00', '0.00', '0.00', '19000.00', '19000.00', '0.00', 'CASH'),
(35, 9, 'INV/2512/0035', '2025-12-14 20:27:38', '24000.00', '0.00', '0.00', '24000.00', '24000.00', '0.00', 'QRIS'),
(36, 9, 'INV/2512/0036', '2025-12-15 07:09:55', '18500.00', '0.00', '0.00', '18500.00', '20000.00', '1500.00', 'CASH'),
(37, 9, 'INV/2512/0037', '2025-12-15 07:11:08', '24500.00', '0.00', '0.00', '24500.00', '25000.00', '500.00', 'CASH'),
(38, 9, 'INV/2512/0038', '2025-12-15 07:20:39', '20000.00', '0.00', '0.00', '20000.00', '20000.00', '0.00', 'CASH'),
(39, 9, 'INV/2512/0039', '2025-12-15 11:15:54', '5000.00', '0.00', '0.00', '5000.00', '5000.00', '0.00', 'CASH'),
(40, 9, 'INV/2512/0040', '2025-12-15 11:19:51', '7000.00', '0.00', '0.00', '7000.00', '7000.00', '0.00', 'CASH'),
(41, 10, 'INV/2512/0041', '2025-12-15 11:22:50', '64000.00', '0.00', '0.00', '64000.00', '64000.00', '0.00', 'CASH'),
(42, 4, 'INV/2512/0042', '2025-12-15 15:49:40', '12500.00', '0.00', '0.00', '12500.00', '12500.00', '0.00', 'CASH'),
(43, 4, 'INV/2512/0043', '2025-12-15 16:23:07', '39500.00', '0.00', '0.00', '39500.00', '39500.00', '0.00', 'CASH'),
(44, 4, 'INV/2512/0044', '2025-12-15 16:24:15', '-19500.00', '0.00', '0.00', '-19500.00', '-19500.00', '0.00', 'CASH'),
(45, 4, 'INV/2512/0045', '2025-12-15 16:31:40', '-9000.00', '0.00', '0.00', '-9000.00', '-9000.00', '0.00', 'CASH'),
(46, 4, 'INV/2512/0046', '2025-12-15 16:34:26', '1000.00', '0.00', '0.00', '1000.00', '1000.00', '0.00', 'CASH'),
(47, 11, 'INV/2512/0047', '2025-12-15 17:15:10', '7000.00', '0.00', '0.00', '7000.00', '10000.00', '3000.00', 'CASH'),
(48, 11, 'INV/2512/0048', '2025-12-15 17:16:25', '14000.00', '0.00', '0.00', '14000.00', '14000.00', '0.00', 'CASH'),
(49, 11, 'INV/2512/0049', '2025-12-15 17:18:57', '78000.00', '0.00', '0.00', '78000.00', '78000.00', '0.00', 'CASH'),
(50, 11, 'INV/2512/0050', '2025-12-15 20:55:24', '85000.00', '0.00', '0.00', '85000.00', '100000.00', '15000.00', 'CASH'),
(51, 12, 'INV/2512/0051', '2025-12-19 11:43:25', '26000.00', '0.00', '0.00', '26000.00', '30000.00', '4000.00', 'CASH'),
(52, 13, 'INV/2512/0052', '2025-12-25 21:44:41', '6000.00', '0.00', '0.00', '6000.00', '6000.00', '0.00', 'tagrs'),
(53, 13, 'INV/2512/0053', '2025-12-25 21:53:47', '4000.00', '0.00', '0.00', '4000.00', '4000.00', '0.00', 'cash'),
(54, 13, 'INV/2512/0054', '2025-12-25 21:56:27', '4000.00', '0.00', '0.00', '4000.00', '4000.00', '0.00', 'qris'),
(55, 14, 'INV/2512/0055', '2025-12-26 04:48:14', '4000.00', '0.00', '0.00', '4000.00', '4000.00', '0.00', 'cash'),
(56, 14, 'INV/2512/0056', '2025-12-26 04:49:09', '20000.00', '0.00', '0.00', '20000.00', '20000.00', '0.00', 'tagrs');

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

--
-- Table structure for table `order_items`
--

CREATE TABLE `order_items` (
  `id` int(11) NOT NULL,
  `order_id` int(11) DEFAULT NULL,
  `product_id` int(11) DEFAULT NULL,
  `nama_barang_snapshot` varchar(100) DEFAULT NULL,
  `harga_modal_snapshot` decimal(15,2) DEFAULT NULL,
  `qty` decimal(10,2) DEFAULT NULL,
  `satuan` varchar(20) DEFAULT NULL,
  `harga_jual_deal` decimal(15,2) DEFAULT NULL,
  `diskon_item` decimal(15,2) DEFAULT '0.00',
  `subtotal` decimal(15,2) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `order_items`
--

INSERT INTO `order_items` (`id`, `order_id`, `product_id`, `nama_barang_snapshot`, `harga_modal_snapshot`, `qty`, `satuan`, `harga_jual_deal`, `diskon_item`, `subtotal`) VALUES
(1, 1, 2, 'Mie Ayam Bakso', '12000.00', '1.00', 'Porsi', '20000.00', '0.00', '20000.00'),
(2, 1, 6, 'Indomie Goreng', '2000.00', '1.00', 'Bungkus', '3500.00', '0.00', '3500.00'),
(3, 2, 2, 'Mie Ayam Bakso', '12000.00', '1.00', 'Porsi', '20000.00', '0.00', '20000.00'),
(4, 3, 6, 'Indomie Goreng .', '2000.00', '2.00', 'Bungkus', '3000.00', '0.00', '6000.00'),
(5, 4, 4, 'Kopi Susu Panas', '7000.00', '10.00', 'Cangkir', '12000.00', '0.00', '120000.00'),
(6, 5, 3, 'Es Teh Manis', '3000.00', '1.00', 'Gelas', '5000.00', '0.00', '5000.00'),
(7, 6, 6, 'Indomie Goreng ', '2000.00', '4.00', 'Bungkus', '3000.00', '0.00', '12000.00'),
(8, 7, 6, 'Indomie Goreng ', '2000.00', '1.00', 'Bungkus', '3000.00', '0.00', '3000.00'),
(9, 8, 2, 'Mie Ayam Bakso', '12000.00', '1.00', 'Porsi', '20000.00', '0.00', '20000.00'),
(10, 9, 6, 'Indomie Goreng ', '2000.00', '1.00', 'Bungkus', '3000.00', '0.00', '3000.00'),
(11, 10, 6, 'Indomie Goreng ', '2000.00', '1.00', 'Bungkus', '3000.00', '0.00', '3000.00'),
(12, 11, 6, 'Indomie Goreng ', '2000.00', '1.00', 'Bungkus', '3000.00', '0.00', '3000.00'),
(13, 12, 6, 'Indomie Goreng ', '2000.00', '1.00', 'Bungkus', '3000.00', '0.00', '3000.00'),
(14, 13, 2, 'Mie Ayam Bakso', '12000.00', '1.00', 'Porsi', '20000.00', '0.00', '20000.00'),
(15, 14, 6, 'Indomie Goreng ', '2000.00', '1.00', 'Bungkus', '3000.00', '0.00', '3000.00'),
(16, 15, 6, 'Indomie Goreng ', '2000.00', '1.00', 'Bungkus', '3000.00', '0.00', '3000.00'),
(17, 16, 6, 'Indomie Goreng ', '2000.00', '1.00', 'Bungkus', '3000.00', '0.00', '3000.00'),
(18, 17, 6, 'Indomie Goreng ', '2000.00', '1.00', 'Bungkus', '3000.00', '0.00', '3000.00'),
(19, 18, 6, 'Indomie Goreng ', '2000.00', '2.00', 'Bungkus', '3000.00', '0.00', '6000.00'),
(20, 19, 6, 'Indomie Goreng ', '2000.00', '1.00', 'Bungkus', '3000.00', '0.00', '3000.00'),
(21, 20, 6, 'Indomie Goreng ', '2000.00', '1.00', 'Bungkus', '3000.00', '0.00', '3000.00'),
(22, 21, 4, 'Kopi Susu Panas', '7000.00', '1.00', 'Cangkir', '12000.00', '0.00', '12000.00'),
(23, 22, 82, 'AQUA 1500 ML', '5600.00', '1.00', 'PCS', '7000.00', '0.00', '7000.00'),
(24, 22, 379, 'BENG BENG MAXX 32 gr', '2800.00', '2.00', 'Pcs', '3500.00', '0.00', '7000.00'),
(25, 23, 5, 'Aqua Botol 600ml.', '2500.00', '2.00', 'Botol', '4000.00', '0.00', '8000.00'),
(26, 24, 82, 'AQUA 1500 ML', '5600.00', '1.00', 'PCS', '7000.00', '0.00', '7000.00'),
(27, 24, 85, 'AQUA GELAS 220 mL', '800.00', '5.00', 'PCS', '1000.00', '0.00', '5000.00'),
(28, 25, 7, 'BENG BENG LEBIH KECIL 22 gr', '2000.00', '1.00', 'PCS', '2500.00', '0.00', '2500.00'),
(29, 25, 82, 'AQUA 1500 ML', '5600.00', '1.00', 'PCS', '7000.00', '0.00', '7000.00'),
(30, 25, 85, 'AQUA GELAS 220 mL', '800.00', '5.00', 'PCS', '1000.00', '0.00', '5000.00'),
(31, 26, 7, 'BENG BENG LEBIH KECIL 22 gr', '2000.00', '5.00', 'PCS', '2500.00', '0.00', '12500.00'),
(32, 27, 3, 'Es Teh Manis', '3000.00', '2.00', 'Gelas', '5000.00', '0.00', '10000.00'),
(33, 27, 6, 'Indomie Goreng ', '2000.00', '6.00', 'Bungkus', '3000.00', '0.00', '18000.00'),
(34, 27, 118, 'TEH BOTOL SOSRO', '3200.00', '1.00', 'PCS', '4000.00', '0.00', '4000.00'),
(35, 28, 154, 'HANDUK HAYASI', '30400.00', '1.00', 'PCS', '38000.00', '0.00', '38000.00'),
(36, 29, 118, 'TEH BOTOL SOSRO', '3200.00', '1.00', 'PCS', '4000.00', '0.00', '4000.00'),
(37, 30, 2, 'Mie Ayam Bakso', '12000.00', '1.00', 'Porsi', '20000.00', '0.00', '20000.00'),
(38, 31, 7, 'BENG BENG LEBIH KECIL 22 gr', '2000.00', '5.00', 'PCS', '2500.00', '0.00', '12500.00'),
(39, 32, 3, 'Es Teh Manis', '3000.00', '1.00', 'Gelas', '5000.00', '0.00', '5000.00'),
(40, 33, 119, 'TEH PUCUK 350 ML', '3200.00', '1.00', 'PCS', '4000.00', '0.00', '4000.00'),
(41, 34, 42, 'VAVA POP CORN 60 GR', '15200.00', '1.00', 'PCS', '19000.00', '0.00', '19000.00'),
(42, 35, 2, 'Mie Ayam Bakso', '12000.00', '1.00', 'Porsi', '20000.00', '0.00', '20000.00'),
(43, 35, 118, 'TEH BOTOL SOSRO', '3200.00', '1.00', 'PCS', '4000.00', '0.00', '4000.00'),
(44, 36, 5, 'Aqua Botol 600ml.', '2500.00', '3.00', 'Botol', '4000.00', '0.00', '12000.00'),
(45, 36, 89, 'FANTA BOTOL PLASTIK', '5200.00', '1.00', 'PCS', '6500.00', '0.00', '6500.00'),
(46, 37, 104, 'SPRITE BOTOL KACA K', '2400.00', '4.00', 'PCS', '3000.00', '0.00', '12000.00'),
(47, 37, 278, 'SAMPO DOVE SACHET 10 ML', '2000.00', '5.00', 'PCS', '2500.00', '0.00', '12500.00'),
(48, 38, 2, 'Mie Ayam Bakso', '12000.00', '1.00', 'Porsi', '20000.00', '0.00', '20000.00'),
(49, 39, 3, 'Es Teh Manis', '3000.00', '1.00', 'Gelas', '5000.00', '0.00', '5000.00'),
(50, 40, 6, 'Indomie Goreng ', '2000.00', '1.00', 'Bungkus', '3000.00', '0.00', '3000.00'),
(51, 40, 13, 'INDOMIE SOTO', '3200.00', '1.00', 'PCS', '4000.00', '0.00', '4000.00'),
(52, 41, 2, 'Mie Ayam Bakso', '12000.00', '3.00', 'Porsi', '20000.00', '0.00', '60000.00'),
(53, 41, 83, 'AQUA 600 ML', '3200.00', '1.00', 'PCS', '4000.00', '0.00', '4000.00'),
(54, 42, 383, 'Pulsa Telepon', '0.00', '1.00', 'Unit', '12500.00', '0.00', '12500.00'),
(55, 43, 2, 'Mie Ayam Bakso', '12000.00', '1.00', 'Porsi', '20000.00', '0.00', '20000.00'),
(56, 43, 28, 'POP MIE B 75 gr', '5200.00', '3.00', 'PCS', '6500.00', '0.00', '19500.00'),
(57, 44, 28, 'POP MIE B 75 gr', '5200.00', '-3.00', 'PCS', '6500.00', '0.00', '-19500.00'),
(58, 45, 6, 'Indomie Goreng ', '2500.00', '-3.00', 'Bungkus', '3000.00', '0.00', '-9000.00'),
(59, 46, 76, 'NABATI PINK LAVA 130gr', '4800.00', '3.00', 'PCS', '6000.00', '0.00', '18000.00'),
(60, 46, 280, 'SANDAL SWALLO', '13600.00', '-1.00', 'PCS', '17000.00', '0.00', '-17000.00'),
(61, 47, 99, 'POCARI SWAT 350 ML', '5600.00', '1.00', 'PCS', '7000.00', '0.00', '7000.00'),
(62, 48, 99, 'POCARI SWAT 350 ML', '5600.00', '2.00', 'PCS', '7000.00', '0.00', '14000.00'),
(63, 49, 228, 'BABY DOOL SOFIE/LORITA CP ', '62400.00', '1.00', 'PCS', '78000.00', '0.00', '78000.00'),
(64, 50, 82, 'AQUA 1500 ML', '5600.00', '10.00', 'PCS', '7000.00', '0.00', '70000.00'),
(65, 50, 128, 'LE-MINERAL 600ML', '2400.00', '5.00', 'PCS', '3000.00', '0.00', '15000.00'),
(66, 51, 6, 'Indomie Goreng ', '2500.00', '2.00', 'Bungkus', '3000.00', '0.00', '6000.00'),
(67, 51, 83, 'AQUA 600 ML', '3200.00', '5.00', 'PCS', '4000.00', '0.00', '20000.00'),
(68, 52, 6, 'Indomie Goreng ', '2500.00', '2.00', 'Bungkus', '3000.00', '0.00', '6000.00'),
(69, 53, 118, 'TEH BOTOL SOSRO', '3200.00', '1.00', 'PCS', '4000.00', '0.00', '4000.00'),
(70, 54, 90, 'FRUIT TEA', '3200.00', '1.00', 'PCS', '4000.00', '0.00', '4000.00'),
(71, 55, 127, 'TEH GELAS 350 ML', '3200.00', '1.00', 'PCS', '4000.00', '0.00', '4000.00'),
(72, 56, 127, 'TEH GELAS 350 ML', '3200.00', '5.00', 'PCS', '4000.00', '0.00', '20000.00');

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

--
-- Table structure for table `products`
--

CREATE TABLE `products` (
  `id` int(11) NOT NULL,
  `barcode` varchar(30) DEFAULT NULL,
  `plu` varchar(10) DEFAULT NULL,
  `nama_barang` varchar(100) NOT NULL,
  `category_id` int(11) DEFAULT NULL,
  `satuan_kecil` varchar(20) DEFAULT 'Pcs',
  `stok_base` decimal(10,2) DEFAULT '0.00',
  `harga_modal` decimal(15,2) DEFAULT '0.00',
  `harga_jual` decimal(15,2) DEFAULT '0.00',
  `tax_type` enum('none','include','exclude') DEFAULT 'none',
  `is_active` tinyint(1) DEFAULT '1',
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `quantity` decimal(10,2) DEFAULT NULL,
  `unit_price` decimal(10,2) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `products`
--

INSERT INTO `products` (`id`, `barcode`, `plu`, `nama_barang`, `category_id`, `satuan_kecil`, `stok_base`, `harga_modal`, `harga_jual`, `tax_type`, `is_active`, `created_at`, `quantity`, `unit_price`) VALUES
(1, 'P001', '0001', 'Nasi Goreng Spesial Telur', 1, 'Porsi', '100.00', '15000.00', '25000.00', 'exclude', 1, '2025-12-06 23:15:56', NULL, NULL),
(2, 'P002', '0002', 'Mie Ayam Bakso', 1, 'Porsi', '69.00', '12000.00', '20000.00', 'none', 1, '2025-12-06 23:15:56', NULL, NULL),
(3, 'P003', '0003', 'Es Teh Manis', 1, 'Gelas', '200.00', '3000.00', '5000.00', 'none', 1, '2025-12-06 23:15:56', NULL, NULL),
(4, 'P004', '0004', 'Kopi Susu Panas', 1, 'Cangkir', '144.00', '7000.00', '12000.00', 'none', 1, '2025-12-06 23:15:56', NULL, NULL),
(5, 'P005', '0005', 'Aqua Botol 600ml.', 1, 'Botol', '295.00', '2500.00', '4000.00', 'none', 1, '2025-12-06 23:15:56', NULL, NULL),
(6, 'P006', '0006', 'Indomie Goreng ', 1, 'Bungkus', '492.00', '2500.00', '3000.00', 'none', 1, '2025-12-06 23:15:56', NULL, NULL),
(7, 'P1001', '1001', 'BENG BENG LEBIH KECIL 22 gr', 1, 'PCS', '-11.00', '2000.00', '2500.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(9, 'P1003', '1003', 'BISKUAT COKLAT K 10gr', 1, 'PCS', '0.00', '3200.00', '4000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(10, 'P1004', '1004', 'CRYSPI CRAKER NISSIN 225 gr', 1, 'PCS', '0.00', '10000.00', '12500.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(11, 'P1005', '1005', 'GOODTIME KECIL 16 gr', 1, 'PCS', '100.00', '1600.00', '2000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(12, 'P1006', '1006', 'INDOMIE GORENG', 1, 'PCS', '0.00', '3600.00', '4500.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(13, 'P1007', '1007', 'INDOMIE SOTO', 1, 'PCS', '-1.00', '3200.00', '4000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(14, 'P1008', '1008', 'KACANG DK MIX 65 GR', 1, 'PCS', '0.00', '9600.00', '12000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(15, 'P1009', '1009', 'GOOD TIME B 80 gr', 1, 'PCS', '0.00', '8000.00', '10000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(16, 'P1010', '1010', 'MALKIS ABON 135 gr', 1, 'PCS', '0.00', '6000.00', '7500.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(17, 'P1011', '1011', 'NYAM NYAM SNACK BUBBLE PUFF CHOCO 18 gr', 1, 'PCS', '0.00', '4000.00', '5000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(18, 'P1012', '1012', 'MALKIST CRACKERS 135 gr', 1, 'PCS', '0.00', '5200.00', '6500.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(19, 'P1013', '1013', 'MALKIST ROMA COKLAT 120 gr', 1, 'PCS', '0.00', '6800.00', '8500.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(20, 'P1014', '1014', 'OREO COKLAT B 137 gr', 1, 'PCS', '0.00', '10400.00', '13000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(21, 'P1015', '1015', 'OREO KECIL 29/36 gr', 1, 'PCS', '0.00', '2400.00', '3000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(22, 'P1016', '1016', 'PERMEN ALPENLUBE', 1, 'PCS', '0.00', '200.00', '250.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(23, 'P1017', '1017', 'PERMEN GREEN', 1, 'PCS', '0.00', '200.00', '250.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(24, 'P1018', '1018', 'PERMEN KISS', 1, 'PCS', '0.00', '200.00', '250.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(25, 'P1019', '1019', 'PERMEN KOPIKO', 1, 'PCS', '100.00', '240.00', '300.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(26, 'P1020', '1020', 'PERMEN MENTOS', 1, 'PCS', '0.00', '200.00', '250.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(27, 'P1021', '1021', 'PERMEN MINT', 1, 'PCS', '0.00', '200.00', '250.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(28, 'P1022', '1022', 'POP MIE B 75 gr', 1, 'PCS', '0.00', '5200.00', '6500.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(29, 'P1023', '1023', 'REGAL BESAR', 1, 'PCS', '0.00', '17600.00', '22000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(30, 'P1024', '1024', 'REGAL KECIL 125 gr', 1, 'PCS', '0.00', '12000.00', '15000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(31, 'P1025', '1025', 'ROMA KELAPA 300 gr', 1, 'PCS', '0.00', '9600.00', '12000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(32, 'P1026', '1026', 'SANGHAI GANGSAR BESAR 225 gr', 1, 'PCS', '0.00', '8000.00', '10000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(33, 'P1027', '1027', 'SANGHAI OKE BESAR', 1, 'PCS', '0.00', '10640.00', '13300.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(34, 'P1028', '1028', 'SANGHAI OKE KECIL', 1, 'PCS', '0.00', '6400.00', '8000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(35, 'P1029', '1029', 'SARI GANDUM SANWICTH 115/108 gr', 1, 'PCS', '0.00', '7600.00', '9500.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(36, 'P1030', '1030', 'SARI GANDUM SUSU 149gr', 1, 'PCS', '0.00', '6800.00', '8500.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(37, 'P1031', '1031', 'TANGO BESAR 176gr', 1, 'PCS', '0.00', '12000.00', '15000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(38, 'P1032', '1032', 'TOLAK ANGIN CAIR', 1, 'PCS', '0.00', '3200.00', '4000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(39, 'P1033', '1033', 'TANGO KECIL 35gr', 1, 'PCS', '0.00', '2400.00', '3000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(40, 'P1034', '1034', 'TICTAC 90 gr', 1, 'PCS', '0.00', '5600.00', '7000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(41, 'P1035', '1035', 'BISKUAT B 140gr', 1, 'PCS', '0.00', '9600.00', '12000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(42, 'P1036', '1036', 'VAVA POP CORN 60 GR', 1, 'PCS', '-1.00', '15200.00', '19000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(43, 'P1037', '1037', 'BON CABE MAKARONI 135 GR', 1, 'PCS', '0.00', '9200.00', '11500.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(44, 'P1038', '1038', 'OREO MINI CUP 67 gr', 1, 'PCS', '0.00', '6400.00', '8000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(45, 'P1039', '1039', 'KABIN UBM MANIS', 1, 'PCS', '0.00', '10400.00', '13000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(46, 'P1040', '1040', 'SHANGHAI GANGSAR KECIL 140 gr', 1, 'PCS', '0.00', '5600.00', '7000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(47, 'P1041', '1041', 'NS WALENS SOES 100GR', 1, 'PCS', '0.00', '10000.00', '12500.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(48, 'P1042', '1042', 'CHO CHO WAFER SNACK ', 1, 'PCS', '0.00', '5600.00', '7000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(49, 'P1043', '1043', 'TANGO WALUT BANANA 15GR', 1, 'PCS', '0.00', '1200.00', '1500.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(50, 'P1044', '1044', 'NEXSTAR BROWNIES 34GR', 1, 'PCS', '0.00', '6400.00', '8000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(51, 'P1045', '1045', 'KUACI KRIBO 140 GR', 1, 'PCS', '0.00', '13600.00', '17000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(52, 'P1046', '1046', 'SUN MARIE BISCUAT 80GR', 1, 'PCS', '0.00', '8400.00', '10500.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(53, 'P1047', '1047', 'KUACI KRIBO 70GR', 1, 'PCS', '0.00', '8000.00', '10000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(54, 'P1048', '1048', 'AIM CRISPY CRACK 150GR', 1, 'PCS', '0.00', '8400.00', '10500.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(55, 'P1049', '1049', 'BISKUAT 45/60 gr', 1, 'PCS', '0.00', '4000.00', '5000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(56, 'P1050', '1050', 'SIMBA SEREAL CHO/STRAW', 1, 'PCS', '0.00', '2400.00', '3000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(57, 'P1051', '1051', 'BISCOTO DORAEMON STICK', 1, 'PCS', '0.00', '3200.00', '4000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(58, 'P1052', '1052', 'TANGGO TANGGUNG 78 gr', 1, 'PCS', '0.00', '6400.00', '8000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(59, 'P1053', '1053', 'TANGGO LONG 47 gr', 1, 'PCS', '0.00', '4800.00', '6000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(60, 'P1054', '1054', 'GERY SALUT COKLAT ', 1, 'PCS', '0.00', '6800.00', '8500.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(61, 'P1055', '1055', 'MALKIS ABON B 250 gr', 1, 'PCS', '0.00', '10400.00', '13000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(62, 'P1056', '1056', 'SARI GANDUM SUSU B 240gr', 1, 'PCS', '0.00', '10400.00', '13000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(63, 'P1057', '1057', 'ROMA MALKIS KEJU MANIS 120 gr', 1, 'PCS', '0.00', '6400.00', '8000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(64, 'P1058', '1058', 'GERY SALUT KELAPA 110 gr', 1, 'PCS', '0.00', '6400.00', '8000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(65, 'P1059', '1059', 'GERY SALUT KEJU 110 gr', 1, 'PCS', '0.00', '5600.00', '7000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(66, 'P1060', '1060', 'DILANS CRUNCHY CHOCO 23GR', 1, 'PCS', '0.00', '2000.00', '2500.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(67, 'P1061', '1061', 'BIKA HONEY CRAB 70GR', 1, 'PCS', '0.00', '2800.00', '3500.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(68, 'P1062', '1062', 'GERY CEREAL 100 GR', 1, 'PCS', '0.00', '7200.00', '9000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(69, 'P1063', '1063', 'SARI GANDUM K 39 gr', 1, 'PCS', '0.00', '2400.00', '3000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(70, 'P1064', '1064', 'POP MIE MINI 40 GR', 1, 'PCS', '0.00', '3600.00', '4500.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(71, 'P1065', '1065', 'KABIN UBM ASIN', 1, 'PCS', '0.00', '10400.00', '13000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(72, 'P1066', '1066', 'OREO T 66,5gr', 1, 'PCS', '0.00', '5200.00', '6500.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(73, 'P1067', '1067', 'NS KELAPA IJO 40GR', 1, 'PCS', '0.00', '1600.00', '2000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(74, 'P1068', '1068', 'SUPER KEJU 8gr', 1, 'PCS', '0.00', '800.00', '1000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(75, 'P1069', '1069', 'MALKIS COKLAT KELAPA 135gr', 1, 'PCS', '0.00', '6400.00', '8000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(76, 'P1070', '1070', 'NABATI PINK LAVA 130gr', 1, 'PCS', '-3.00', '4800.00', '6000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(77, 'P1071', '1071', 'CHOCOLATE/MILK SERENA 42gr', 1, 'PCS', '0.00', '2400.00', '3000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(78, 'P1072', '1072', 'GERY SALUT KELAPA K 17,5GR', 1, 'PCS', '0.00', '2000.00', '2500.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(79, 'P1073', '1073', 'DILANS CRUNCHY CHOCO 9,5GR', 1, 'PCS', '0.00', '800.00', '1000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(80, 'P2001', '2001', 'KOPI ABC SUSU', 2, 'PCS', '0.00', '1600.00', '2000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(81, 'P2002', '2002', 'ADES 600 ML', 2, 'PCS', '0.00', '2800.00', '3500.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(82, 'P2003', '2003', 'AQUA 1500 ML', 2, 'PCS', '-13.00', '5600.00', '7000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(83, 'P2004', '2004', 'AQUA 600 ML', 2, 'PCS', '-6.00', '3200.00', '4000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(84, 'P2005', '2005', 'NESTLE PURE LIFE 600 ML', 2, 'PCS', '0.00', '2800.00', '3500.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(85, 'P2006', '2006', 'AQUA GELAS 220 mL', 2, 'PCS', '-10.00', '800.00', '1000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(86, 'P2007', '2007', 'GOLDA CAFE 200 ml', 2, 'PCS', '0.00', '4400.00', '5500.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(87, 'P2008', '2008', 'GOOD DAY CAPUCINO 25 gr', 2, 'PCS', '0.00', '2800.00', '3500.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(88, 'P2009', '2009', 'KOPI NESCAFE 3 IN 1', 2, 'PCS', '0.00', '1600.00', '2000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(89, 'P2010', '2010', 'FANTA BOTOL PLASTIK', 2, 'PCS', '-1.00', '5200.00', '6500.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(90, 'P2011', '2011', 'FRUIT TEA', 2, 'PCS', '-1.00', '3200.00', '4000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(91, 'P2012', '2012', 'FLORIDINA 350 ML', 2, 'PCS', '0.00', '4400.00', '5500.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(92, 'P2013', '2013', 'INDOCOFFE MIX', 2, 'PCS', '0.00', '2000.00', '2500.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(93, 'P2014', '2014', 'KOPI JAHE SIDOMUNCUL', 2, 'PCS', '0.00', '2800.00', '3500.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(94, 'P2015', '2015', 'LUWAK WHITE KOFFIE', 2, 'PCS', '0.00', '2000.00', '2500.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(95, 'P2016', '2016', 'KOPI TOP SUSU ', 2, 'PCS', '0.00', '1600.00', '2000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(96, 'P2017', '2017', 'MIZONE 500 ML', 2, 'PCS', '0.00', '5600.00', '7000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(97, 'P2018', '2018', 'YOU C 1000', 2, 'PCS', '0.00', '8800.00', '11000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(98, 'P2019', '2019', 'KOPI TOP PLUS', 2, 'PCS', '0.00', '1200.00', '1500.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(99, 'P2020', '2020', 'POCARI SWAT 350 ML', 2, 'PCS', '-3.00', '5600.00', '7000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(100, 'P2021', '2021', 'POCARI SWAT 500 ML', 2, 'PCS', '0.00', '6800.00', '8500.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(101, 'P2022', '2022', 'SARI KACANG HIJAU ABC B 250 ml', 2, 'PCS', '0.00', '6000.00', '7500.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(102, 'P2023', '2023', 'PULPY', 2, 'PCS', '0.00', '6000.00', '7500.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(103, 'P2024', '2024', 'SARI KACANG HIJAU ABC T 200 ML', 2, 'PCS', '0.00', '4800.00', '6000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(104, 'P2025', '2025', 'SPRITE BOTOL KACA K', 2, 'PCS', '-4.00', '2400.00', '3000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(105, 'P2026', '2026', 'SPRITE BOTOL PLASTIK', 2, 'PCS', '0.00', '5200.00', '6500.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(106, 'P2027', '2027', 'SUSU BENDERA BTL 180 ML', 2, 'PCS', '0.00', '4800.00', '6000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(107, 'P2028', '2028', 'SUSU BENDERA UHT 115 ML', 2, 'PCS', '0.00', '3200.00', '4000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(108, 'P2029', '2029', 'SUSU BENDERA UHT 180 ML', 2, 'PCS', '0.00', '4400.00', '5500.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(109, 'P2030', '2030', 'SUSU INDOMILK BTL 190 ML', 2, 'PCS', '0.00', '4000.00', '5000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(110, 'P2031', '2031', 'SUSU INDOMILK KOTAK 190 ML', 2, 'PCS', '0.00', '4000.00', '5000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(111, 'P2032', '2032', 'SUSU JAHE SIDOMUNCUL', 2, 'PCS', '0.00', '2800.00', '3500.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(112, 'P2033', '2033', 'SUSU MILO COKLAT 110 ML', 2, 'PCS', '0.00', '3200.00', '4000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(113, 'P2034', '2034', 'SUSU MILO COKLAT 180 ML', 2, 'PCS', '0.00', '5600.00', '7000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(114, 'P2035', '2035', 'SUSU ULTRA B 250 ML', 2, 'PCS', '0.00', '6400.00', '8000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(115, 'P2036', '2036', 'SUSU ULTRA COKLAT & FULL CREAM 1 LTR', 2, 'PCS', '0.00', '14800.00', '18500.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(116, 'P2037', '2037', 'SUSU ULTRA K 125 ML', 2, 'PCS', '0.00', '4000.00', '5000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(117, 'P2038', '2038', 'SUSU ULTRA T 200 ML', 2, 'PCS', '0.00', '5600.00', '7000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(118, 'P2039', '2039', 'TEH BOTOL SOSRO', 2, 'PCS', '96.00', '3200.00', '4000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(119, 'P2040', '2040', 'TEH PUCUK 350 ML', 2, 'PCS', '99.00', '3200.00', '4000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(120, 'P2041', '2041', 'TORABIKA CAPPUCINO 25gr', 2, 'PCS', '0.00', '2800.00', '3500.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(121, 'P2042', '2042', 'TORABIKA SUSU', 2, 'PCS', '0.00', '1600.00', '2000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(122, 'P2043', '2043', 'YAKULT', 2, 'PCS', '0.00', '8800.00', '11000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(123, 'P2044', '2044', 'TOP WHITE COFFE', 2, 'PCS', '0.00', '1200.00', '1500.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(124, 'P2045', '2045', 'SARI KACANG HIJAU K 150 ML', 2, 'PCS', '0.00', '4000.00', '5000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(125, 'P2046', '2046', 'SPRITE BOTOL KACA B 295 ML', 2, 'PCS', '0.00', '4000.00', '5000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(126, 'P2047', '2047', 'ENERGEN B 32/34 GR', 2, 'PCS', '0.00', '2800.00', '3500.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(127, 'P2048', '2048', 'TEH GELAS 350 ML', 2, 'PCS', '-6.00', '3200.00', '4000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(128, 'P2049', '2049', 'LE-MINERAL 600ML', 2, 'PCS', '-5.00', '2400.00', '3000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(129, 'P2050', '2050', 'LE-MINERAL 1500ML', 2, 'PCS', '0.00', '4800.00', '6000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(130, 'P2051', '2051', 'BUAVITA K 125ML', 2, 'PCS', '0.00', '4400.00', '5500.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(131, 'P3001', '3001', 'BABY DOL AMRO CLN PDK (Q)', 3, 'PCS', '0.00', '55200.00', '69000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(132, 'P3002', '3002', 'BABY DOL AMRO PANJANG SCP', 3, 'PCS', '0.00', '64000.00', '80000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(133, 'P3003', '3003', 'BABY DOL HERMIT', 3, 'PCS', '0.00', '47600.00', '59500.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(134, 'P3004', '3004', 'BAJU BAYI LGN PDK GAMBAR MONICA', 3, 'PCS', '0.00', '5600.00', '7000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(135, 'P3005', '3005', 'BAJU BAYI LGN PDK POLOS WALING', 3, 'PCS', '0.00', '6000.00', '7500.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(136, 'P3006', '3006', 'CD CORINA 3L', 3, 'PCS', '0.00', '8000.00', '10000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(137, 'P3007', '3007', 'CD CORINA XL', 3, 'PCS', '0.00', '7200.00', '9000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(138, 'P3008', '3008', 'CD MIS L', 3, 'PCS', '0.00', '7600.00', '9500.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(139, 'P3009', '3009', 'CD NANIE M', 3, 'PCS', '0.00', '7200.00', '9000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(140, 'P3010', '3010', 'CD TULIP 3L', 3, 'PCS', '0.00', '8400.00', '10500.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(141, 'P3011', '3011', 'CD TULIP L', 3, 'PCS', '0.00', '7600.00', '9500.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(142, 'P3012', '3012', 'CD TULIP M/ MIIS M', 3, 'PCS', '0.00', '7200.00', '9000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(143, 'P3013', '3013', 'CD TULIP XL', 3, 'PCS', '0.00', '8000.00', '10000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(144, 'P3014', '3014', 'BABY DOOL SOFIE /LORITA JUMBO CP', 3, 'PCS', '0.00', '71200.00', '89000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(145, 'P3015', '3015', 'CELANA WESTEN LOGO XXL', 3, 'PCS', '0.00', '33600.00', '42000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(146, 'P3016', '3016', 'CELANA WESTEN ANAK XL', 3, 'PCS', '0.00', '27200.00', '34000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(147, 'P3017', '3017', 'DASTER BTK MULIA', 3, 'PCS', '0.00', '50400.00', '63000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(148, 'P3018', '3018', 'CD MIIS XL', 3, 'PCS', '0.00', '8000.00', '10000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(149, 'P3019', '3019', 'DASTER IBU', 3, 'PCS', '0.00', '50400.00', '63000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(150, 'P3020', '3020', 'GURITA POLOS', 3, 'PCS', '0.00', '3600.00', '4500.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(151, 'P3021', '3021', 'GURITA PRINT', 3, 'PCS', '0.00', '5200.00', '6500.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(152, 'P3022', '3022', 'GURITA XL,L', 3, 'PCS', '0.00', '26400.00', '33000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(153, 'P3023', '3023', 'HANDUK DOLBY', 3, 'PCS', '0.00', '16000.00', '20000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(154, 'P3024', '3024', 'HANDUK HAYASI', 3, 'PCS', '-1.00', '30400.00', '38000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(155, 'P3025', '3025', 'HANDUK IVORY', 3, 'PCS', '0.00', '16000.00', '20000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(156, 'P3026', '3026', 'HANDUK MONETER', 3, 'PCS', '0.00', '22400.00', '28000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(157, 'P3027', '3027', 'HANDUK MUTIA K', 3, 'PCS', '0.00', '19200.00', '24000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(158, 'P3028', '3028', 'JARIT HMS', 3, 'PCS', '0.00', '38400.00', '48000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(159, 'P3029', '3029', 'K.KRAH ANDRIANU L', 3, 'PCS', '0.00', '40000.00', '50000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(160, 'P3030', '3030', 'K.KRAH ANDRIANU XL', 3, 'PCS', '0.00', '42400.00', '53000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(161, 'P3031', '3031', 'K.OBL ANDRIANU L', 3, 'PCS', '0.00', '37600.00', '47000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(162, 'P3032', '3032', 'K.OBL ANDRIANU XL', 3, 'PCS', '0.00', '39200.00', '49000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(163, 'P3033', '3033', 'KAOS DALAM HOSANA 18/YUSA 18', 3, 'PCS', '0.00', '8000.00', '10000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(164, 'P3034', '3034', 'KAOS DALAM SWAN 34-36', 3, 'PCS', '0.00', '23200.00', '29000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(165, 'P3035', '3035', 'KAOS DALAM SWAN 38-42', 3, 'PCS', '0.00', '24000.00', '30000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(166, 'P3036', '3036', 'KAOS DALAM YUSA 20', 3, 'PCS', '0.00', '8800.00', '11000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(167, 'P3037', '3037', 'KAOS DALAM YUSA 24', 3, 'PCS', '0.00', '10400.00', '13000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(168, 'P3038', '3038', 'SAPU TANGAN HANDUK AMANDA', 3, 'PCS', '0.00', '8800.00', '11000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(169, 'P3039', '3039', 'SAPU TANGAN HANDUK GAMBAR', 3, 'PCS', '0.00', '7200.00', '9000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(170, 'P3040', '3040', 'BH DENA 34-38', 3, 'PCS', '0.00', '17600.00', '22000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(171, 'P3041', '3041', 'SARUNG AL-MAGUNG', 3, 'PCS', '0.00', '30400.00', '38000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(172, 'P3042', '3042', 'SARUNG GAJAH THAILAND', 3, 'PCS', '0.00', '27200.00', '34000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(173, 'P3043', '3043', 'WASLAP', 3, 'PCS', '0.00', '5400.00', '6750.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(174, 'P3044', '3044', 'BABY DOL INTIKASA', 3, 'PCS', '0.00', '48000.00', '60000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(175, 'P3045', '3045', 'DASTER SOFI', 3, 'PCS', '0.00', '52000.00', '65000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(176, 'P3046', '3046', 'HANDUK MUTIA BESAR', 3, 'PCS', '0.00', '38400.00', '48000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(177, 'P3047', '3047', 'HANDUK FANTASTIK', 3, 'PCS', '0.00', '28000.00', '35000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(178, 'P3048', '3048', 'SARUNG GAJAH SURYA', 3, 'PCS', '0.00', '30400.00', '38000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(179, 'P3049', '3049', 'SARUNG WADIMOR', 3, 'PCS', '0.00', '43600.00', '54500.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(180, 'P3050', '3050', 'DASTER RATU BUSANA', 3, 'PCS', '0.00', '60800.00', '76000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(181, 'P3051', '3051', 'DASTER AMPRO', 3, 'PCS', '0.00', '52400.00', '65500.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(182, 'P3052', '3052', 'DASTER BULAN MADU', 3, 'PCS', '0.00', '60800.00', '76000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(183, 'P3053', '3053', 'DASTER MANTILI', 3, 'PCS', '0.00', '56400.00', '70500.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(184, 'P3054', '3054', 'CELANA WESTEN ARMY XL', 3, 'PCS', '0.00', '32000.00', '40000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(185, 'P3055', '3055', 'CELANA WESTEN ARMY XXL', 3, 'PCS', '0.00', '32800.00', '41000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(186, 'P3056', '3056', 'BABY DOL GOGO SUPER', 3, 'PCS', '0.00', '49600.00', '62000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(187, 'P3057', '3057', 'BABY DOL BATIK BOROBUDUR', 3, 'PCS', '0.00', '54000.00', '67500.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(188, 'P3058', '3058', 'DASTER BUNGA SUTRA ', 3, 'PCS', '0.00', '50400.00', '63000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(189, 'P3059', '3059', 'BH DENA 40-42', 3, 'PCS', '0.00', '18400.00', '23000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(190, 'P3060', '3060', 'BH AGNES 34 s/d 36', 3, 'PCS', '0.00', '14400.00', '18000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(191, 'P3061', '3061', 'BH AGNES 38 s/d 40', 3, 'PCS', '0.00', '16000.00', '20000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(192, 'P3062', '3062', 'BABY DOL MATARAM', 3, 'PCS', '0.00', '64800.00', '81000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(193, 'P3063', '3063', 'HANDUK ALVIN DELVINA', 3, 'PCS', '0.00', '28000.00', '35000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(194, 'P3064', '3064', 'HANDUK TWIN', 3, 'PCS', '0.00', '29600.00', '37000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(195, 'P3065', '3065', 'CELANA WESTEN LOGO XL', 3, 'PCS', '0.00', '32800.00', '41000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(196, 'P3066', '3066', 'GURITA BESAR', 3, 'PCS', '0.00', '30400.00', '38000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(197, 'P3067', '3067', 'BABY DOL SOFIE 3/4', 3, 'PCS', '0.00', '64800.00', '81000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(198, 'P3068', '3068', 'BABY DOOL BATIK MULIA', 3, 'PCS', '0.00', '48000.00', '60000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(199, 'P3069', '3069', 'BABY DOOL HERMIT CELANA PANJANG', 3, 'PCS', '0.00', '54400.00', '68000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(200, 'P3070', '3070', 'CD MIS 3L', 3, 'PCS', '0.00', '8400.00', '10500.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(201, 'P3071', '3071', 'HANDUK BEVI', 3, 'PCS', '0.00', '22400.00', '28000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(202, 'P3072', '3072', 'HANDUK LUPEN', 3, 'PCS', '0.00', '30400.00', '38000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(203, 'P3073', '3073', 'CD NANIE XL', 3, 'PCS', '0.00', '8800.00', '11000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(204, 'P3074', '3074', 'CD NANIE 3L', 3, 'PCS', '0.00', '9600.00', '12000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(205, 'P3075', '3075', 'HANDUK B [ 50 X 100 ]', 3, 'PCS', '0.00', '32000.00', '40000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(206, 'P3076', '3076', 'HANDUK K [ 38 X 80 ]', 3, 'PCS', '0.00', '26400.00', '33000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(207, 'P3077', '3077', 'HANDUK MUTIA TG', 3, 'PCS', '0.00', '31200.00', '39000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(208, 'P3078', '3078', 'HANDUK MUTIA LEHER K', 3, 'PCS', '0.00', '20000.00', '25000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(209, 'P3079', '3079', 'HANDUK BAYWAT', 3, 'PCS', '0.00', '38400.00', '48000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(210, 'P3080', '3080', 'HANDUK MERAH PUTIH', 3, 'PCS', '0.00', '31200.00', '39000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(211, 'P3081', '3081', 'GREND CLAS / PREGOMULIA TG', 3, 'PCS', '0.00', '36000.00', '45000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(212, 'P3082', '3082', 'CD NANIE L', 3, 'PCS', '0.00', '8000.00', '10000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(213, 'P3083', '3083', 'JARIT ADINDA', 3, 'PCS', '0.00', '30400.00', '38000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(214, 'P3084', '3084', 'DASTER KENCANA UNGU', 3, 'PCS', '0.00', '66800.00', '83500.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(215, 'P3085', '3085', 'DASTER AMPRO LD JMB DTX', 3, 'PCS', '0.00', '48000.00', '60000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(216, 'P3086', '3086', 'BABY DOL AMRO SJJ', 3, 'PCS', '0.00', '73600.00', '92000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(217, 'P3087', '3087', 'BABY DOL HAP JUMBO TEJO', 3, 'PCS', '0.00', '70000.00', '87500.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(218, 'P3088', '3088', 'BABY DOL MILA SUPER X', 3, 'PCS', '0.00', '49600.00', '62000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(219, 'P3089', '3089', 'SARUNG GAJAH ALAS', 3, 'PCS', '0.00', '38400.00', '48000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(220, 'P3090', '3090', 'CELANA WESTEN ANAK DISTRO L', 3, 'PCS', '0.00', '26400.00', '33000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(221, 'P3091', '3091', 'KAOS OBLONG GAMBAR 30S', 3, 'PCS', '0.00', '46400.00', '58000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(222, 'P3092', '3092', 'KAOS KRAH DOMINO DWS L', 3, 'PCS', '0.00', '61600.00', '77000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(223, 'P3093', '3093', 'DASTER SERUNI 5L', 3, 'PCS', '0.00', '50400.00', '63000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(224, 'P3094', '3094', 'DASTER SERUNI BIASA', 3, 'PCS', '0.00', '40800.00', '51000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(225, 'P3095', '3095', 'DASTER MARISA IBU', 3, 'PCS', '0.00', '55200.00', '69000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(226, 'P3096', '3096', 'DASTER DINDA AQILAH', 3, 'PCS', '0.00', '38000.00', '47500.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(227, 'P3097', '3097', 'DASTER ANE CLAIRE', 3, 'PCS', '0.00', '66000.00', '82500.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(228, 'P3098', '3098', 'BABY DOOL SOFIE/LORITA CP ', 3, 'PCS', '-1.00', '62400.00', '78000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(229, 'P3099', '3099', 'BABY DOOL SERUNI', 3, 'PCS', '0.00', '50000.00', '62500.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(230, 'P3100', '3100', 'BABY DOOL MARISA GOGO', 3, 'PCS', '0.00', '60800.00', '76000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(231, 'P3101', '3101', 'CELANA HAWAIN 3/4', 3, 'PCS', '0.00', '34800.00', '43500.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(232, 'P3102', '3102', 'HANDUK CAP PANDA', 3, 'PCS', '0.00', '18400.00', '23000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(233, 'P3103', '3103', 'HANDUK SARANG LEBAH', 3, 'PCS', '0.00', '21600.00', '27000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(234, 'P3104', '3104', 'KAOS KRAH WESTEN M', 3, 'PCS', '0.00', '32000.00', '40000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(235, 'P3105', '3105', 'KAOS KRAH WESTEN L', 3, 'PCS', '0.00', '34400.00', '43000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(236, 'P3106', '3106', 'KAOS KRAH WESTEN XL', 3, 'PCS', '0.00', '36000.00', '45000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(237, 'P3107', '3107', 'BABY DOOL LORITA SOFIE 7/8', 3, 'PCS', '0.00', '68000.00', '85000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(238, 'P3108', '3108', 'KAOS OBLONG TOFFA', 3, 'PCS', '0.00', '47200.00', '59000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(239, 'P3109', '3109', 'BABY DOOL MAHKOTA JUMBO', 3, 'PCS', '0.00', '62400.00', '78000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(240, 'P3110', '3110', 'BABY DOOL MAHKOTA STD', 3, 'PCS', '0.00', '52000.00', '65000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(241, 'P3111', '3111', 'SAPU TANGAN MICRO', 3, 'PCS', '0.00', '6000.00', '7500.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(242, 'P4001', '4001', 'ATTACK EASY 45 MG', 4, 'PCS', '0.00', '1600.00', '2000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(243, 'P4002', '4002', 'BANDO BAYI MERAH MUDA', 4, 'PCS', '0.00', '2400.00', '3000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(244, 'P4003', '4003', 'BEDAK CUSSONS BABY 100 GR + 50 GR', 4, 'PCS', '0.00', '9600.00', '12000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(245, 'P4004', '4004', 'BEDAK HEROCYN 85 GR', 4, 'PCS', '0.00', '12000.00', '15000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(246, 'P4005', '4005', 'BEDAK JOHNSONS 100 GR', 4, 'PCS', '0.00', '8800.00', '11000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(247, 'P4006', '4006', 'CHARM EXTRA MAXI 10 BUAH', 4, 'PCS', '0.00', '8800.00', '11000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(248, 'P4007', '4007', 'CHARM MAXI WING 5 BUAH', 4, 'PCS', '0.00', '4400.00', '5500.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(249, 'P4008', '4008', 'HAND BODY CITRA NIGHT 120 ML', 4, 'PCS', '0.00', '12800.00', '16000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(250, 'P4009', '4009', 'HAND BODY MARINA 100 ML', 4, 'PCS', '0.00', '6400.00', '8000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(251, 'P4010', '4010', 'KAPAS 35 K GR', 4, 'PCS', '0.00', '6800.00', '8500.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(252, 'P4011', '4011', 'KAPAS 50 B GR', 4, 'PCS', '0.00', '8800.00', '11000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(253, 'P4012', '4012', 'LAURIER SUPER MAXI 8 BUAH', 4, 'PCS', '0.00', '5600.00', '7000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(254, 'P4013', '4013', 'LOTION AUTAN 7 ML', 4, 'PCS', '0.00', '1600.00', '2000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(255, 'P4014', '4014', 'MILK BATH CUSSONS 200 ML', 4, 'PCS', '0.00', '0.00', '0.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(256, 'P4015', '4015', 'MINYAK KAPAK 10 ML', 4, 'PCS', '0.00', '14400.00', '18000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(257, 'P4016', '4016', 'MINYAK KAPAK 14 ML', 4, 'PCS', '0.00', '20800.00', '26000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(258, 'P4017', '4017', 'MINYAK KAPAK 5 ML', 4, 'PCS', '0.00', '10400.00', '13000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(259, 'P4018', '4018', 'MINYAK KAYU PUTIH LANG 120 ML', 4, 'PCS', '0.00', '32000.00', '40000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(260, 'P4019', '4019', 'MINYAK KAYU PUTIH LANG 15 ML', 4, 'PCS', '0.00', '8800.00', '11000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(261, 'P4020', '4020', 'MINYAK KAYU PUTIH LANG 210 ML', 4, 'PCS', '0.00', '48000.00', '60000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(262, 'P4021', '4021', 'MINYAK KAYU PUTIH LANG 30 ML', 4, 'PCS', '0.00', '13600.00', '17000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(263, 'P4022', '4022', 'MINYAK KAYU PUTIH LANG 60 ML', 4, 'PCS', '0.00', '20000.00', '25000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(264, 'P4023', '4023', 'MINYAK TAWON CC 20 ML', 4, 'PCS', '0.00', '24000.00', '30000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(265, 'P4024', '4024', 'MINYAK TAWON DD 30 ML', 4, 'PCS', '0.00', '30400.00', '38000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(266, 'P4025', '4025', 'MINYAK TAWON EE 60 ML', 4, 'PCS', '0.00', '48000.00', '60000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(267, 'P4026', '4026', 'P.DEWASA L', 4, 'PCS', '0.00', '8800.00', '11000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(268, 'P4027', '4027', 'P.DEWASA M', 4, 'PCS', '0.00', '7600.00', '9500.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(269, 'P4028', '4028', 'P.DEWASA XL', 4, 'PCS', '0.00', '9600.00', '12000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(270, 'P4029', '4029', 'PASTA GIGI PEPSODENT 25 GR', 4, 'PCS', '0.00', '3200.00', '4000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(271, 'P4030', '4030', 'PASTA GIGI PEPSODENT 75 GR', 4, 'PCS', '0.00', '4800.00', '6000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(272, 'P4031', '4031', 'REXONA DEO LOTION 9 GR', 4, 'PCS', '0.00', '2800.00', '3500.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(273, 'P4032', '4032', 'ROLL ON TOLAK ANGIN CARE SIDOMUNCUL', 4, 'PCS', '0.00', '9600.00', '12000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(274, 'P4033', '4033', 'SABUN CITRA', 4, 'PCS', '0.00', '3200.00', '4000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(275, 'P4034', '4034', 'SABUN GIV', 4, 'PCS', '0.00', '2400.00', '3000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(276, 'P4035', '4035', 'SABUN LIFEBOY', 4, 'PCS', '0.00', '3600.00', '4500.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(277, 'P4036', '4036', 'SABUN LUX', 4, 'PCS', '0.00', '4000.00', '5000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(278, 'P4037', '4037', 'SAMPO DOVE SACHET 10 ML', 4, 'PCS', '-5.00', '2000.00', '2500.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(279, 'P4038', '4038', 'SAMPO SUNSILK SACHET', 4, 'PCS', '0.00', '800.00', '1000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(280, 'P4039', '4039', 'SANDAL SWALLO', 4, 'PCS', '1.00', '13600.00', '17000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(281, 'P4040', '4040', 'PEPSODENT B 120 gr', 4, 'PCS', '0.00', '6000.00', '7500.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(282, 'P4041', '4041', 'SEDOTAN', 4, 'PCS', '0.00', '160.00', '200.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(283, 'P4042', '4042', 'SHAMPO PANTENE', 4, 'PCS', '0.00', '1600.00', '2000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(284, 'P4043', '4043', 'SIKAT GIGI FORMULA SILVER PROTECTOR', 4, 'PCS', '0.00', '4400.00', '5500.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(285, 'P4044', '4044', 'SIKAT GIGI PEPSODENT FAMILI', 4, 'PCS', '0.00', '4400.00', '5500.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(286, 'P4045', '4045', 'BOLPOIN SNOWMAN', 4, 'PCS', '0.00', '2000.00', '2500.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(287, 'P4046', '4046', 'SISIR GAGANG', 4, 'PCS', '0.00', '2800.00', '3500.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(288, 'P4047', '4047', 'SISIR BIASA', 4, 'PCS', '0.00', '2400.00', '3000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(289, 'P4048', '4048', 'KRESEK', 4, 'PCS', '0.00', '800.00', '1000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(290, 'P4049', '4049', 'SUNLIGHT K 52/54 ML', 4, 'PCS', '0.00', '1200.00', '1500.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(291, 'P4050', '4050', 'SWEETY BRONZE PANTS L ISI 2', 4, 'PCS', '0.00', '6400.00', '8000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(292, 'P4051', '4051', 'SWEETY BRONZE PANTS M ISI 2', 4, 'PCS', '0.00', '5600.00', '7000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(293, 'P4052', '4052', 'SWEETY FIT PANTZ S ISI 1', 4, 'PCS', '0.00', '2800.00', '3500.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(294, 'P4053', '4053', 'SWEETY FIT PANTZ XL ISI 2', 4, 'PCS', '0.00', '7200.00', '9000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(295, 'P4054', '4054', 'SWEETY FIT PANTZ XXL ISI 2', 4, 'PCS', '0.00', '8000.00', '10000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(296, 'P4055', '4055', 'T.NICE 120 KOTAK', 4, 'PCS', '0.00', '10400.00', '13000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(297, 'P4056', '4056', 'T.NICE 200 PANJANG', 4, 'PCS', '0.00', '10400.00', '13000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(298, 'P4057', '4057', 'T.NICE 200 PLASTIK', 4, 'PCS', '0.00', '8800.00', '11000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(299, 'P4058', '4058', 'T.NICE 250 PANJANG', 4, 'PCS', '0.00', '12800.00', '16000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(300, 'P4059', '4059', 'T.NICE 60 KOTAK', 4, 'PCS', '0.00', '6000.00', '7500.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(301, 'P4060', '4060', 'T.NICE 60 PLASTIK', 4, 'PCS', '0.00', '5600.00', '7000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(302, 'P4061', '4061', 'T.PASEO ELEGAN 250', 4, 'PCS', '0.00', '16000.00', '20000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(303, 'P4062', '4062', 'T.PASEO ELEGAN 280', 4, 'PCS', '0.00', '17600.00', '22000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(304, 'P4063', '4063', 'T.PASEO KECIL 8 k', 4, 'PCS', '0.00', '1600.00', '2000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(305, 'P4064', '4064', 'T.PASEO SMART 250', 4, 'PCS', '0.00', '12000.00', '15000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(306, 'P4065', '4065', 'TB CUSSON B (ISI 50 )', 4, 'PCS', '0.00', '14400.00', '18000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(307, 'P4066', '4066', 'TB CUUSON K (ISI 10 )', 4, 'PCS', '0.00', '5600.00', '7000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(308, 'P4067', '4067', 'BOLPOIN TRENDEE', 4, 'PCS', '0.00', '2800.00', '3500.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(309, 'P4068', '4068', 'CUTTON BUD', 4, 'PCS', '0.00', '6400.00', '8000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(310, 'P4069', '4069', 'LAURIER SUPER MAXI 5 BUAH', 4, 'PCS', '0.00', '4000.00', '5000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(311, 'P4070', '4070', 'SUNLIGHT 105/90 ml', 4, 'PCS', '0.00', '2400.00', '3000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(312, 'P4071', '4071', 'SUNLIGHT 210/230 ml', 4, 'PCS', '0.00', '6000.00', '7500.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(313, 'P4072', '4072', 'CITRA HBL 60 ml', 4, 'PCS', '0.00', '8000.00', '10000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(314, 'P4073', '4073', 'SABUN LIFEBOY CAIR 100ml', 4, 'PCS', '0.00', '9600.00', '12000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(315, 'P4074', '4074', 'MUNYAK TAWON FF 90ml', 4, 'PCS', '0.00', '62400.00', '78000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(316, 'P4075', '4075', 'TB CUSSON B (ISI 20+20/ISI 45 ] ', 4, 'PCS', '0.00', '9600.00', '12000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(317, 'P4076', '4076', 'BEDAK CUSSONS BABY 50G + 25G', 4, 'PCS', '0.00', '5600.00', '7000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(318, 'P4077', '4077', 'T.PASEO SMART 12 K', 4, 'PCS', '0.00', '2000.00', '2500.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(319, 'P4078', '4078', 'T.PASEO LUXURIOUSLY SOFT 9 K', 4, 'PCS', '0.00', '2000.00', '2500.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(320, 'P4079', '4079', 'T.PASEO ULTRA SOFT ISI 100', 4, 'PCS', '0.00', '11200.00', '14000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(321, 'P4080', '4080', 'T.PASEO PURE SOFT ISI 130 ', 4, 'PCS', '0.00', '13600.00', '17000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(322, 'P4081', '4081', 'RINSO + MOLTO 42 ML', 4, 'PCS', '0.00', '2000.00', '2500.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(323, 'P4082', '4082', 'BEDAK JOHNSONS K 50 GR', 4, 'PCS', '0.00', '5200.00', '6500.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(324, 'P4083', '4083', 'T.TESSA B ISI 250', 4, 'PCS', '0.00', '10400.00', '13000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(325, 'P4084', '4084', 'RINSO BUBUK 44 gr', 4, 'PCS', '0.00', '1600.00', '2000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(326, 'P4085', '4085', 'P DEWASA LIFREE XL', 4, 'PCS', '0.00', '8000.00', '10000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(327, 'P4086', '4086', 'P DEWASA LIFREE L', 4, 'PCS', '0.00', '7200.00', '9000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(328, 'P4087', '4087', 'P DEWASA LIFREE M', 4, 'PCS', '0.00', '6400.00', '8000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(329, 'P4088', '4088', 'CHARM EXTRA MAXI 8 BUAH', 4, 'PCS', '0.00', '7200.00', '9000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(330, 'P4089', '4089', 'SWEETY BRONZE PANTS L ISI 1', 4, 'PCS', '0.00', '3600.00', '4500.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(331, 'P4090', '4090', 'SWEETY BRONZE PANTS S ISI 2', 4, 'PCS', '0.00', '4800.00', '6000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(332, 'P4091', '4091', 'T.NICE 180 PANJANG', 4, 'PCS', '0.00', '8000.00', '10000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(333, 'P4092', '4092', 'P DEWASA LIFREE CELANA XL', 4, 'PCS', '0.00', '15200.00', '19000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(334, 'P4093', '4093', 'P DEWASA CERTAINTY XL', 4, 'PCS', '0.00', '6160.00', '7700.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(335, 'P4094', '4094', 'T.PASEO SMART 50', 4, 'PCS', '0.00', '3200.00', '4000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(336, 'P4095', '4095', 'T.MONTIS 250', 4, 'PCS', '0.00', '9600.00', '12000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(337, 'P4096', '4096', 'P SENSI GOPANTS CELANA', 4, 'PCS', '0.00', '11200.00', '14000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(338, 'P4097', '4097', 'T MONTIS 200 KOTAK K', 4, 'PCS', '0.00', '4800.00', '6000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(339, 'P4098', '4098', 'TB MITU K ISI 10', 4, 'PCS', '0.00', '4000.00', '5000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(340, 'P4099', '4099', 'TB MITU B ISI 50', 4, 'PCS', '0.00', '12000.00', '15000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(341, 'P4100', '4100', 'T MONTIS 50 K', 4, 'PCS', '0.00', '2400.00', '3000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(342, 'P4101', '4101', 'BEDAK CALADIN 100 GR', 4, 'PCS', '0.00', '14400.00', '18000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(343, 'P4102', '4102', 'T MULTI 200', 4, 'PCS', '0.00', '4800.00', '6000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(344, 'P4103', '4103', 'KIPAS', 4, 'PCS', '0.00', '4000.00', '5000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(345, 'P4104', '4104', 'TB MITU ISI 24', 4, 'PCS', '0.00', '6000.00', '7500.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(346, 'P4105', '4105', 'T MONTIS 200 PANJANG', 4, 'PCS', '0.00', '7200.00', '9000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(347, 'P4106', '4106', 'CHARM MAXI ISI 7', 4, 'PCS', '0.00', '6000.00', '7500.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(348, 'P4107', '4107', 'KIPAS MOTIF', 4, 'PCS', '0.00', '8000.00', '10000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(349, 'P5001', '5001', 'BINGO (COKLAT STICK) 40 GR (AICE)', 5, 'PCS', '0.00', '2400.00', '3000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(350, 'P5002', '5002', 'MIKI-MIKI 30 GR (AICE)', 5, 'PCS', '0.00', '2000.00', '2500.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(351, 'P5003', '5003', 'CHOCOLATE TWO COLOURS 50 ML (AICE)', 5, 'PCS', '0.00', '2800.00', '3500.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(352, 'P5004', '5004', 'SWEET CORN (JAGUNG MANIS) 52 GR (AICE)', 5, 'PCS', '0.00', '3200.00', '4000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(353, 'P5005', '5005', 'COFEE CRISPY 45 GR (AICE)', 5, 'PCS', '0.00', '3600.00', '4500.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(354, 'P5006', '5006', 'CHOCOLATE WAFLE CONE 45 GR (AICE)', 5, 'PCS', '0.00', '3600.00', '4500.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(355, 'P5007', '5007', 'STROWBERY CRISPY (AICE)', 5, 'PCS', '0.00', '3600.00', '4500.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(356, 'P5008', '5008', 'OBOR VANILA 55 GR (AICE)', 5, 'PCS', '0.00', '3200.00', '4000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(357, 'P5009', '5009', 'CHOCOLATE CRISPY STICK 60 GR (AICE)', 5, 'PCS', '0.00', '4800.00', '6000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(358, 'P5010', '5010', 'SUNDAE CHOCOLATE CUP 100 ML (AICE)', 5, 'PCS', '0.00', '4800.00', '6000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(359, 'P5011', '5011', 'CHOCO CONDENSED MILK 100 ML (AICE)', 5, 'PCS', '0.00', '4800.00', '6000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(360, 'P5012', '5012', 'NANAS STICK 65 GR (AICE)', 5, 'PCS', '0.00', '2000.00', '2500.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(361, 'P5013', '5013', 'MOCHI VANILLA 30 GR (AICE)', 5, 'PCS', '0.00', '2800.00', '3500.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(362, 'P5014', '5014', 'SUNDAE STRAWBERRY CUP 100 ML (AICE)', 5, 'PCS', '0.00', '4800.00', '6000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(363, 'P5015', '5015', 'MOCHI STROWBERY 45 GR (AICE)', 5, 'PCS', '0.00', '2800.00', '3500.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(364, 'P5016', '5016', 'STROWBERY CONE 100 ML (AICE)', 5, 'PCS', '0.00', '4800.00', '6000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(365, 'P5017', '5017', 'OBOR STRAWBERRY 55 GR (AICE)', 5, 'PCS', '0.00', '4000.00', '5000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(366, 'P5018', '5018', 'SUNDAE AVOCADO CUP 100 ML (AICE)', 5, 'PCS', '0.00', '4800.00', '6000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(367, 'P5019', '5019', 'FAMILY PACK SUSU TELUR 65ml (AICE)', 5, 'PCS', '0.00', '4000.00', '5000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(368, 'P5020', '5020', 'FREEZY CHOCO 49 ML (AICE)', 5, 'PCS', '0.00', '2800.00', '3500.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(369, 'P5021', '5021', 'MANGO SLUSH 65GR (AICE)', 5, 'PCS', '0.00', '3600.00', '4500.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(370, 'P5022', '5022', 'MOCHI DURIAN 45ML (AICE)', 5, 'PCS', '0.00', '2800.00', '3500.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(371, 'P5023', '5023', 'MOCHI CHOCOLATE 45ML (AICE)', 5, 'PCS', '0.00', '2800.00', '3500.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(372, 'P5024', '5024', 'VANILLA CHOCOLATE CUP 90ML (AICE)', 5, 'PCS', '0.00', '4000.00', '5000.00', 'none', 1, '2012-07-24 17:00:00', NULL, NULL),
(379, 'P1002', '1002', 'BENG BENG MAXX 32 gr', 1, 'Pcs', '-2.00', '2800.00', '3500.00', 'none', 1, '2025-12-11 15:36:25', NULL, NULL),
(382, 'P007', '0007', 'Kopi Ndeso Hitam', 2, 'Gelas', '150.00', '2500.00', '3000.00', 'none', 1, '2025-12-15 07:15:24', NULL, NULL),
(383, 'P008', '0008', 'Pulsa Telepon', 6, 'Unit', '99.00', '0.00', '0.00', 'none', 1, '2025-12-15 08:31:24', NULL, NULL);

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

--
-- Table structure for table `purchase_orders`
--

CREATE TABLE `purchase_orders` (
  `id` int(11) NOT NULL,
  `supplier_id` int(11) DEFAULT NULL,
  `no_po` varchar(30) DEFAULT NULL,
  `tanggal_po` datetime DEFAULT NULL,
  `total_amount` decimal(15,2) DEFAULT NULL,
  `status` enum('pending','completed','cancelled') DEFAULT 'pending'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `purchase_orders`
--

INSERT INTO `purchase_orders` (`id`, `supplier_id`, `no_po`, `tanggal_po`, `total_amount`, `status`) VALUES
(17, 4, '55', '2025-12-09 00:00:00', NULL, 'completed'),
(18, 4, '22', '2025-12-15 00:00:00', NULL, 'completed'),
(19, 4, '10241', '2025-12-15 00:00:00', NULL, 'completed'),
(20, 5, '555', '2025-12-15 00:00:00', NULL, 'completed'),
(21, 5, '434234', '2025-12-15 00:00:00', NULL, 'completed'),
(22, 5, '34234234', '2025-12-13 00:00:00', NULL, 'completed');

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

--
-- Table structure for table `purchase_order_items`
--

CREATE TABLE `purchase_order_items` (
  `id` int(11) NOT NULL,
  `purchase_order_id` int(11) DEFAULT NULL,
  `product_id` int(11) DEFAULT NULL,
  `quantity` decimal(10,2) DEFAULT NULL,
  `unit_price` decimal(12,2) DEFAULT NULL,
  `subtotal` decimal(10,2) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `purchase_order_items`
--

INSERT INTO `purchase_order_items` (`id`, `purchase_order_id`, `product_id`, `quantity`, `unit_price`, `subtotal`) VALUES
(4, 17, 6, '10.00', '2000.00', '20000.00'),
(5, 17, 3, '5.00', '3000.00', '15000.00'),
(7, 18, 4, '5.00', '7000.00', '35000.00'),
(10, 19, 6, '10.00', '2500.00', '25000.00'),
(11, 19, 119, '100.00', '3200.00', '320000.00'),
(12, 20, 118, '100.00', '3200.00', '320000.00'),
(13, 21, 25, '100.00', '240.00', '24000.00'),
(14, 22, 382, '50.00', '2500.00', '125000.00');

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

--
-- Table structure for table `shifts`
--

CREATE TABLE `shifts` (
  `id` int(11) NOT NULL,
  `user_id` int(11) DEFAULT NULL,
  `waktu_buka` datetime DEFAULT NULL,
  `waktu_tutup` datetime DEFAULT NULL,
  `modal_awal` decimal(15,2) DEFAULT '0.00',
  `total_penjualan_system` decimal(15,2) DEFAULT '0.00',
  `uang_fisik_akhir` decimal(15,2) DEFAULT '0.00',
  `selisih` decimal(15,2) DEFAULT '0.00',
  `status` enum('open','closed') DEFAULT 'open'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `shifts`
--

INSERT INTO `shifts` (`id`, `user_id`, `waktu_buka`, `waktu_tutup`, `modal_awal`, `total_penjualan_system`, `uang_fisik_akhir`, `selisih`, `status`) VALUES
(1, 1, '2025-12-07 06:24:22', '2025-12-07 09:41:50', '500000.00', '23500.00', '523500.00', '0.00', 'closed'),
(2, 1, '2025-12-07 09:42:56', '2025-12-07 15:03:57', '500000.00', '151000.00', '0.00', '-651000.00', 'closed'),
(3, 1, '2025-12-10 16:12:48', '2025-12-14 14:58:24', '0.00', '238000.00', '238000.00', '0.00', 'closed'),
(4, 1, '2025-12-14 15:59:18', '2025-12-15 16:34:55', '100000.00', '48500.00', '134000.00', '0.00', 'closed'),
(5, 4, '2025-12-14 16:46:17', '2025-12-14 16:48:19', '10000.00', '12500.00', '22500.00', '0.00', 'closed'),
(6, 4, '2025-12-14 16:49:12', '2025-12-14 16:49:30', '5000.00', '0.00', '5000.00', '0.00', 'closed'),
(7, 4, '2025-12-14 16:49:39', '2025-12-14 16:55:10', '5000.00', '0.00', '5000.00', '0.00', 'closed'),
(8, 4, '2025-12-14 16:55:18', '2025-12-14 17:14:33', '10000.00', '0.00', '10000.00', '0.00', 'closed'),
(9, 4, '2025-12-14 17:14:40', '2025-12-15 11:21:38', '50000.00', '123000.00', '65000.00', '-24000.00', 'closed'),
(10, 4, '2025-12-15 11:22:19', '2025-12-15 16:35:30', '0.00', '64000.00', '53000.00', '0.00', 'closed'),
(11, 4, '2025-12-15 17:14:27', '2025-12-16 12:57:48', '200000.00', '184000.00', '384000.00', '0.00', 'closed'),
(12, 4, '2025-12-19 11:42:44', '2025-12-26 04:46:30', '100000.00', '26000.00', '126000.00', '0.00', 'closed'),
(13, 1, '2025-12-25 21:44:11', '2025-12-27 19:00:07', '0.00', '14000.00', '14000.00', '0.00', 'closed'),
(14, 4, '2025-12-26 04:47:47', NULL, '10000.00', '24000.00', '0.00', '0.00', 'open');

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

--
-- Table structure for table `suppliers`
--

CREATE TABLE `suppliers` (
  `id` int(11) NOT NULL,
  `nama_supplier` varchar(100) NOT NULL,
  `kontak_person` varchar(100) DEFAULT NULL,
  `telepon` varchar(20) DEFAULT NULL,
  `alamat` text,
  `is_active` tinyint(1) DEFAULT '1',
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `suppliers`
--

INSERT INTO `suppliers` (`id`, `nama_supplier`, `kontak_person`, `telepon`, `alamat`, `is_active`, `created_at`) VALUES
(4, 'Umum', 'joko b', '-', '-', 1, '2025-12-07 03:00:20'),
(5, 'Toko Mulia', '---', '-', '-', 1, '2025-12-07 04:14:09');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `cash_flows`
--
ALTER TABLE `cash_flows`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `categories`
--
ALTER TABLE `categories`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `kode_kategori` (`kode_kategori`);

--
-- Indexes for table `orders`
--
ALTER TABLE `orders`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `order_items`
--
ALTER TABLE `order_items`
  ADD PRIMARY KEY (`id`),
  ADD KEY `order_id` (`order_id`);

--
-- Indexes for table `products`
--
ALTER TABLE `products`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `barcode` (`barcode`),
  ADD UNIQUE KEY `plu` (`plu`),
  ADD KEY `fk_product_category` (`category_id`);

--
-- Indexes for table `purchase_orders`
--
ALTER TABLE `purchase_orders`
  ADD PRIMARY KEY (`id`),
  ADD KEY `supplier_id` (`supplier_id`);

--
-- Indexes for table `purchase_order_items`
--
ALTER TABLE `purchase_order_items`
  ADD PRIMARY KEY (`id`),
  ADD KEY `purchase_order_id` (`purchase_order_id`),
  ADD KEY `product_id` (`product_id`);

--
-- Indexes for table `shifts`
--
ALTER TABLE `shifts`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `suppliers`
--
ALTER TABLE `suppliers`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `cash_flows`
--
ALTER TABLE `cash_flows`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;

--
-- AUTO_INCREMENT for table `categories`
--
ALTER TABLE `categories`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `orders`
--
ALTER TABLE `orders`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=57;

--
-- AUTO_INCREMENT for table `order_items`
--
ALTER TABLE `order_items`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=73;

--
-- AUTO_INCREMENT for table `products`
--
ALTER TABLE `products`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=384;

--
-- AUTO_INCREMENT for table `purchase_orders`
--
ALTER TABLE `purchase_orders`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=23;

--
-- AUTO_INCREMENT for table `purchase_order_items`
--
ALTER TABLE `purchase_order_items`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15;

--
-- AUTO_INCREMENT for table `shifts`
--
ALTER TABLE `shifts`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15;

--
-- AUTO_INCREMENT for table `suppliers`
--
ALTER TABLE `suppliers`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `order_items`
--
ALTER TABLE `order_items`
  ADD CONSTRAINT `order_items_ibfk_1` FOREIGN KEY (`order_id`) REFERENCES `orders` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `products`
--
ALTER TABLE `products`
  ADD CONSTRAINT `fk_product_category` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`) ON DELETE SET NULL ON UPDATE CASCADE;

--
-- Constraints for table `purchase_orders`
--
ALTER TABLE `purchase_orders`
  ADD CONSTRAINT `purchase_orders_ibfk_1` FOREIGN KEY (`supplier_id`) REFERENCES `suppliers` (`id`);

--
-- Constraints for table `purchase_order_items`
--
ALTER TABLE `purchase_order_items`
  ADD CONSTRAINT `purchase_order_items_ibfk_1` FOREIGN KEY (`purchase_order_id`) REFERENCES `purchase_orders` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `purchase_order_items_ibfk_2` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`);
COMMIT;

