-- phpMyAdmin SQL Dump
-- version 5.2.2
-- https://www.phpmyadmin.net/
--
-- Host: localhost:3306
-- Generation Time: Nov 12, 2025 at 12:37 AM
-- Server version: 8.0.43-cll-lve
-- PHP Version: 8.4.14

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

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

--
-- Table structure for table `kategori`
--

CREATE TABLE `kategori` (
  `id` int NOT NULL,
  `name` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `kode` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `kategori`
--

INSERT INTO `kategori` (`id`, `name`, `kode`) VALUES
(1, 'Oleh oleh Sukabumi', '001'),
(2, 'Roti', '002'),
(3, 'Pastri', '003'),
(4, 'Dessert', '004'),
(5, 'Cake', '005'),
(6, 'Minuman', '006'),
(7, 'Bandeng Suyudono', '007'),
(8, 'Packaging', '008'),
(9, 'Pasta / Baked Rice', '009'),
(10, 'Nasi / Rice Bowl', '010'),
(11, 'Lain-Lain Snacks Dll', '011');

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

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

CREATE TABLE `products` (
  `id` int NOT NULL,
  `kode_produk` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `name` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `price` decimal(10,2) NOT NULL,
  `stock` int NOT NULL DEFAULT '0',
  `reseller_price` decimal(10,2) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `supplier_id` int DEFAULT NULL,
  `kategori_id` int DEFAULT NULL,
  `catatan` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

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

INSERT INTO `products` (`id`, `kode_produk`, `name`, `price`, `stock`, `reseller_price`, `created_at`, `supplier_id`, `kategori_id`, `catatan`) VALUES
(1, 'OLE-0525-001', 'Mochi Kacang', 35000.00, -6, 30000.00, '2025-05-10 16:32:08', 2, 1, ''),
(2, 'OLE-0525-002', 'Mochi Polos', 35000.00, -1, 30000.00, '2025-05-10 16:32:26', 2, 1, ''),
(3, 'OLE-0525-003', 'Mochi Pandan', 35000.00, 0, 30000.00, '2025-05-10 16:32:42', 2, 1, ''),
(4, 'OLE-0525-004', 'Mochi Wijen Jumbo', 70000.00, -20, 60000.00, '2025-05-10 16:33:02', 2, 1, ''),
(5, 'ROT-0525-005', 'Roti Ham Mozarella', 10000.00, -11, 9500.00, '2025-05-10 16:35:36', 1, 2, ''),
(6, 'ROT-0525-006', 'Roti Kismis Nanas', 10000.00, -4, 9500.00, '2025-05-17 15:02:04', 1, 2, ''),
(7, 'ROT-0525-007', 'Roti Kacang Merah', 9000.00, -4, 8500.00, '2025-05-17 15:03:03', 1, 2, ''),
(8, 'ROT-0525-008', 'Roti Coklat', 7000.00, -43, 6500.00, '2025-05-17 15:03:43', 1, 2, ''),
(9, 'ROT-0525-009', 'Roti Keju', 7000.00, -30, 6500.00, '2025-05-17 15:19:57', 1, 2, ''),
(10, 'ROT-0525-010', 'Roti Coklat Keju', 8000.00, -9, 7500.00, '2025-05-17 15:22:30', 1, 2, ''),
(11, 'ROT-0525-011', 'Roti Ham', 8000.00, 0, 7500.00, '2025-05-17 15:22:48', 1, 2, ''),
(12, 'ROT-0525-012', 'Roti Sosis', 10000.00, -4, 9500.00, '2025-05-17 15:23:02', 1, 2, ''),
(13, 'ROT-0525-013', 'Roti Sosis Keju', 10000.00, -5, 9500.00, '2025-05-17 15:24:48', 1, 2, ''),
(14, 'ROT-0525-014', 'Roti Sosis Mayo', 10000.00, -3, 9000.00, '2025-05-17 15:25:02', 1, 2, ''),
(15, 'PAC-0525-015', 'Roti Mozarella Garlic', 10000.00, -2, 9500.00, '2025-05-17 15:25:23', 1, 8, ''),
(16, 'ROT-0525-016', 'Roti Coffee Bun', 10000.00, -13, 9500.00, '2025-05-17 15:25:58', 1, 2, ''),
(17, 'ROT-0525-017', 'Roti Pizza Roll', 20000.00, 0, 19000.00, '2025-05-17 15:26:15', 1, 2, ''),
(18, 'ROT-0525-018', 'Roti Coklat Almond', 10000.00, -1, 9500.00, '2025-05-17 15:26:32', 1, 2, ''),
(19, 'ROT-0525-019', 'Roti Kepang', 8000.00, -2, 7500.00, '2025-05-17 15:26:51', 1, 2, ''),
(20, 'PAS-0525-020', 'Portuguese Egg Tartlet Original', 13000.00, -7, 11700.00, '2025-05-17 15:27:20', 1, 3, ''),
(21, 'PAS-0525-021', 'Portuguese Egg Tartlet Coklat', 13000.00, -8, 11700.00, '2025-05-17 15:27:42', 1, 3, ''),
(22, 'PAS-0525-022', 'Japanese Cheese Tartlet', 13000.00, -14, 11700.00, '2025-05-17 15:28:23', 1, 3, ''),
(23, 'PAS-0525-023', 'Blueberry Cheese Tartlets', 13000.00, -14, 11700.00, '2025-05-17 15:28:36', 1, 3, ''),
(24, 'PAS-0525-024', 'Brownies Tartlet', 13000.00, 0, 11700.00, '2025-05-17 15:28:49', 1, 3, ''),
(25, 'PAS-0525-025', 'Baked Macaroni Small', 12000.00, -2, 11000.00, '2025-05-17 15:29:48', 1, 9, ''),
(26, 'PAS-0525-026', 'Baked Macaroni Medium', 20000.00, -8, 19000.00, '2025-05-17 15:30:05', 1, 9, ''),
(27, 'PAS-0525-027', 'Baked Macaroni Large', 140000.00, -4, 135000.00, '2025-05-17 15:30:43', 1, 9, ''),
(28, 'PAS-0525-028', 'Pastry Durian', 7000.00, 0, 6500.00, '2025-05-17 15:31:23', 1, 3, ''),
(29, 'PAS-0525-029', 'Pastry Kacang Merah', 7000.00, 0, 6500.00, '2025-05-17 15:31:42', 1, 3, ''),
(30, 'PAS-0525-030', 'Pastry Kacang Hijau', 7000.00, 0, 6500.00, '2025-05-17 15:31:55', 1, 3, 'Supplier kosong'),
(31, 'PAS-0525-031', 'Pastry Tuna Cheese', 16000.00, 0, 14400.00, '2025-05-17 15:32:19', 1, 3, ''),
(32, 'PAS-0525-032', 'Pastry Ham & Cheese', 16000.00, -2, 14400.00, '2025-05-17 15:32:43', 1, 3, ''),
(33, 'PAS-0525-033', 'Pastry Chicken / Ayam', 16000.00, 0, 14400.00, '2025-05-17 15:32:59', 1, 3, ''),
(34, 'PAS-0525-034', 'Pastry Beef', 16000.00, 0, 14400.00, '2025-05-17 15:33:14', 1, 3, ''),
(35, 'PAS-0525-035', 'Pastry Chicken Cordon Bleu', 16000.00, 0, 14400.00, '2025-05-17 15:33:32', 1, 3, ''),
(36, 'PAS-0525-036', 'Pastry Cheese Keju', 16000.00, 0, 14400.00, '2025-05-17 15:33:57', 1, 3, ''),
(37, 'PAS-0525-037', 'Picnic Roll Beef Standard', 98000.00, 0, 88200.00, '2025-05-17 15:34:29', 1, 3, ''),
(38, 'PAS-0525-038', 'Picnic Roll Beef Premium', 110000.00, -1, 99000.00, '2025-05-17 15:35:03', 1, 3, ''),
(39, 'PAS-0525-039', 'Picnic Roll Ham & Cheese', 98000.00, 0, 88200.00, '2025-05-17 15:35:24', 1, 3, ''),
(40, 'PAS-0525-040', 'Picnic Roll Chicken Standard', 88000.00, 0, 79200.00, '2025-05-17 15:35:48', 1, 3, ''),
(41, 'PAS-0525-041', 'Picnic Roll Chicken Premium', 100000.00, 0, 90000.00, '2025-05-17 15:36:26', 1, 3, ''),
(42, 'PAS-0525-042', 'Picnic Roll Chicken Cordon Bleu', 125000.00, 0, 112500.00, '2025-05-17 15:36:59', 1, 3, ''),
(43, 'PAS-0525-043', 'Picnic Roll Ham Roulade', 125000.00, 0, 112500.00, '2025-05-17 15:37:21', 1, 3, ''),
(44, 'PAS-0525-044', 'Picnic Roll Chocomelt Banana', 125000.00, 0, 112500.00, '2025-05-17 15:37:41', 1, 3, ''),
(45, 'MIN-0525-045', 'Yoghurt Strawberry', 20000.00, -1, 18000.00, '2025-05-17 15:38:51', 1, 6, ''),
(46, 'MIN-0525-046', 'Yoghurt Mangga', 20000.00, 0, 18000.00, '2025-05-17 15:39:06', 1, 6, ''),
(47, 'MIN-0525-047', 'Yoghurt Mixed Berries', 27500.00, 0, 24500.00, '2025-05-17 15:39:34', 1, 6, ''),
(48, 'MIN-0525-048', 'Liang Teh', 8000.00, 0, 7000.00, '2025-05-17 15:39:49', 5, 6, ''),
(49, 'OLE-0525-049', 'Kripik Lantak Pisang Asin', 32000.00, -1, 30000.00, '2025-05-17 15:40:09', 2, 1, ''),
(50, 'OLE-0525-050', 'Kripik Rangginang Original', 32000.00, -3, 30000.00, '2025-05-17 15:40:30', 2, 1, ''),
(51, 'OLE-0525-051', 'Kripik Rangginang Terasi', 24000.00, -1, 22000.00, '2025-05-17 15:41:01', 2, 1, ''),
(52, 'OLE-0525-052', 'Pala Keprek', 24000.00, -1, 22000.00, '2025-05-17 15:41:13', 2, 1, ''),
(53, 'BAN-0525-053', 'Bandeng Presto Duri Lunak', 45000.00, -4, 45000.00, '2025-05-17 15:41:35', 4, 7, ''),
(54, 'BAN-0525-054', 'Pepes Bandeng Presto Duri Lunak', 50000.00, -10, 50000.00, '2025-05-17 15:41:58', 4, 7, ''),
(55, 'BAN-0525-055', 'Otak otak Bandeng Presto Duri Lunak', 55000.00, 0, 55000.00, '2025-05-17 15:42:16', 4, 7, ''),
(58, 'ROT-0525-015', 'Roti Custom35', 7000.00, 0, 7000.00, '2025-05-24 12:14:04', 1, 2, ''),
(59, 'ROT-0525-016', 'Roti Custom45', 8000.00, -20, 0.00, '2025-05-24 12:14:23', 1, 2, ''),
(60, 'ROT-0525-017', 'Roti Custom55', 9000.00, 0, 9000.00, '2025-05-24 12:14:46', 1, 2, ''),
(61, 'BAN-0525-004', 'Pepes Bandeng Presto Duri Lunak	 + Masak', 55000.00, 0, 55000.00, '2025-05-24 12:20:58', 4, 7, ''),
(62, 'BAN-0525-005', 'Otak otak Bandeng Presto Duri Lunak + Masak', 60000.00, 0, 60000.00, '2025-05-24 12:21:28', 4, 7, ''),
(63, 'BAN-0525-006', 'Bandeng Presto Duri Lunak + Masak', 50000.00, 0, 50000.00, '2025-05-24 12:21:55', 4, 7, ''),
(64, 'ROT-0525-018', 'Roti Butter Manis', 8000.00, 0, 7500.00, '2025-05-26 23:44:49', 1, 2, ''),
(65, 'ROT-0525-019', 'Roti Pandan Manis', 9000.00, 0, 8500.00, '2025-05-26 23:45:30', 1, 2, ''),
(66, 'ROT-0525-020', 'Roti Pandan Lilit Coklat', 10000.00, 0, 9500.00, '2025-05-26 23:46:10', 1, 2, ''),
(67, 'ROT-0525-021', 'Roti Pandan Coklat', 9000.00, 0, 8500.00, '2025-05-26 23:48:17', 1, 2, ''),
(68, 'ROT-0525-022', 'Roti Roll Coklat Keju', 9000.00, 0, 8500.00, '2025-05-26 23:49:10', 1, 2, ''),
(69, 'ROT-0525-023', 'Roti Blueberry Almond', 10000.00, 0, 9500.00, '2025-05-26 23:49:50', 1, 2, ''),
(70, 'ROT-0525-024', 'Roti Melt Cheese', 10000.00, 0, 9500.00, '2025-05-26 23:59:51', 1, 2, ''),
(71, 'PAS-0525-023', 'Pastry Set Tuna Cheese ', 92000.00, 0, 82800.00, '2025-05-28 10:32:00', 1, 3, ''),
(72, 'PAS-0525-024', 'Pastry Set Beef / Sapi', 92000.00, 0, 82800.00, '2025-05-28 10:32:26', 1, 3, ''),
(73, 'PAS-0525-025', 'Pastry Set Ham & Cheese', 92000.00, 0, 82800.00, '2025-05-28 10:32:57', 1, 3, ''),
(74, 'PAS-0525-026', 'Pastry Set Chicken / Ayam', 90000.00, 0, 81000.00, '2025-05-28 10:34:14', 1, 3, ''),
(75, 'PAS-0525-027', 'Chocolate Cheese Tartlets', 13000.00, 0, 11700.00, '2025-05-30 00:03:48', 1, 3, ''),
(76, 'ROT-0525-025', 'Roti Sobek Polos', 20000.00, 0, 19000.00, '2025-05-31 13:55:37', 1, 2, ''),
(77, 'ROT-0525-026', 'Roti Sobek Ham Keju', 30000.00, 0, 29000.00, '2025-05-31 13:56:32', 1, 2, ''),
(78, 'ROT-0625-001', 'Roti Manis Polos', 6000.00, 0, 5500.00, '2025-06-04 02:52:18', 1, 2, ''),
(80, 'ROT-0625-002', 'Roti Sobek Mix Coklat Keju', 25000.00, 0, 24000.00, '2025-06-04 02:56:11', 1, 2, ''),
(81, 'ROT-0625-003', 'Roti Srikaya', 10000.00, 0, 9500.00, '2025-06-06 23:58:42', 1, 2, ''),
(82, 'ROT-0625-004', 'Roti Abon', 12000.00, 0, 11500.00, '2025-06-06 23:59:04', 1, 2, ''),
(83, 'OLE-0625-001', 'Abon Sapi Spesial', 43000.00, 0, 41000.00, '2025-06-07 00:55:43', 2, 1, ''),
(84, 'OLE-0625-002', 'Kripik Singkong Asin', 27000.00, 0, 25000.00, '2025-06-07 00:56:15', 2, 1, ''),
(85, 'OLE-0625-003', 'Tengteng Kacang', 22000.00, 0, 20000.00, '2025-06-07 00:57:11', 2, 1, ''),
(86, 'PAS-0625-001', 'Picnic Roll Beef Cordon Bleu', 125000.00, 0, 112500.00, '2025-06-07 12:03:06', 1, 3, ''),
(89, 'ROT-0625-005', 'Roti Sosis Saus Keju', 12000.00, 0, 11500.00, '2025-06-17 00:26:00', 1, 2, ''),
(90, 'ROT-0725-001', 'Roti Manis Polos 2pc', 10000.00, 0, 9500.00, '2025-07-01 00:02:22', 1, 2, ''),
(92, 'ROT-0725-002', 'Roti Mini Coklat', 5500.00, 0, 5500.00, '2025-07-01 03:07:15', 1, 2, ''),
(93, 'ROT-0725-003', 'Roti Mini Keju', 5500.00, 0, 5500.00, '2025-07-01 03:07:42', 1, 2, ''),
(94, 'PAC-0725-001', 'Snack box kecil', 500.00, 0, 500.00, '2025-07-01 03:09:40', 1, 8, ''),
(95, 'ROT-0725-004', 'Bread tower isi 23 roti', 300000.00, 0, 275000.00, '2025-07-09 18:32:04', 1, 2, ''),
(97, 'ROT-0725-005', 'Roti Blueberry ', 10000.00, 0, 9500.00, '2025-07-18 01:48:54', 1, 2, ''),
(98, 'ROT-0725-006', 'Roti Cranberry Cream Cheese ', 15000.00, 0, 14000.00, '2025-07-18 01:49:34', 1, 2, ''),
(99, 'OLE-0725-001', 'Kripik Kentang Ebi', 43000.00, 0, 41000.00, '2025-07-19 15:52:31', 2, 1, ''),
(100, 'OLE-0725-002', 'Permen Jahe', 25000.00, 0, 25000.00, '2025-07-19 15:53:32', 2, 1, ''),
(101, 'OLE-0725-003', 'Kripik Singkong Balado', 31000.00, 0, 29000.00, '2025-07-19 15:58:10', 2, 1, ''),
(102, 'OLE-0725-004', 'Lempok Sirsak', 36000.00, 0, 34000.00, '2025-07-19 16:05:31', 2, 1, ''),
(103, 'OLE-0725-005', 'Balado Teri', 36000.00, 0, 34000.00, '2025-07-19 16:08:36', 2, 1, ''),
(104, 'OLE-0725-006', 'Gula Kawung', 43000.00, 0, 41000.00, '2025-07-19 16:11:26', 2, 1, ''),
(105, 'OLE-0725-007', 'Permen Jahe Wijen', 26000.00, 0, 26000.00, '2025-07-19 16:12:04', 2, 1, ''),
(106, 'OLE-0725-008', 'Bandrek', 24000.00, 0, 22000.00, '2025-07-19 16:14:42', 2, 1, ''),
(107, 'OLE-0725-009', 'Naga Kacang Widuri', 22000.00, 0, 20000.00, '2025-07-19 16:18:48', 2, 1, ''),
(108, 'OLE-0725-010', 'Sale Pisang Tipis', 30000.00, 0, 28000.00, '2025-07-19 16:20:08', 2, 1, ''),
(109, 'OLE-0725-011', 'Jipang', 23000.00, 0, 20000.00, '2025-07-19 16:20:45', 2, 1, ''),
(110, 'OLE-0725-012', 'Ketapang Cela Manis', 25000.00, 0, 23000.00, '2025-07-19 16:23:02', 2, 1, ''),
(111, 'OLE-0725-013', 'Ketapang Cela Asin', 25000.00, 0, 23000.00, '2025-07-19 16:24:03', 2, 1, ''),
(112, 'OLE-0725-014', 'Tengteng wijen', 22000.00, 0, 20000.00, '2025-07-19 16:28:00', 2, 1, ''),
(113, 'OLE-0725-015', 'Sale Pisang Jari', 32000.00, 0, 30000.00, '2025-07-19 16:29:11', 2, 1, ''),
(114, 'ROT-0725-007', 'Baked Macaroni Mini', 9000.00, 0, 9000.00, '2025-07-23 04:19:23', 1, 2, 'Minimal pembelian 10 pc'),
(115, 'ROT-0725-008', 'Roti Roll Cranraisins', 15000.00, 0, 14500.00, '2025-07-30 00:24:17', 1, 2, ''),
(116, 'ROT-0725-009', 'Roti Roll Brown Sugar', 9000.00, 0, 8500.00, '2025-07-30 00:24:59', 1, 2, ''),
(117, 'PAS-0825-001', 'Nasi Rice Bowl 015', 15000.00, 100, 15000.00, '2025-08-22 02:07:25', 1, 10, ''),
(118, 'PAS-0825-002', 'Baked Rice Mozarella', 20000.00, 100, 20000.00, '2025-08-22 02:08:01', 1, 9, ''),
(119, 'PAS-0925-001', 'Nasi Rice Bowl 018', 18000.00, 100, 18000.00, '2025-09-14 10:51:36', 1, 10, ''),
(120, 'PAS-0925-002', 'Nasi Rice Bowl 020', 20000.00, 100, 20000.00, '2025-09-14 10:51:58', 1, 10, ''),
(121, 'ROT-0925-001', 'Paket Snack Box 015', 15000.00, 100, 15000.00, '2025-09-14 10:56:28', 1, 2, ''),
(122, 'MIN-0925-001', 'Yoghurt Peach', 27500.00, 10, 27500.00, '2025-09-21 13:15:31', 1, 6, ''),
(123, 'PAS-0925-003', 'Nasi Rice Bowl 022', 22000.00, 10, 22000.00, '2025-09-23 04:09:47', 1, 10, 'Rice Bowl 22rb'),
(124, 'ROT-1025-001', 'Roti Pandan Serikaya', 9000.00, 100, 9000.00, '2025-10-18 05:40:19', 1, 2, ''),
(125, 'ROT-1025-002', 'Roti Tuna Wijen', 15000.00, 10, 15000.00, '2025-10-25 02:11:29', 1, 2, ''),
(126, 'ROT-1125-001', 'Roti Coklat Selai Kacang', 10000.00, 100, 10000.00, '2025-11-11 01:24:13', 1, 2, '');

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

--
-- Table structure for table `resellers`
--

CREATE TABLE `resellers` (
  `id` int NOT NULL,
  `NAME` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `phone` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `email` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

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

--
-- Table structure for table `sales`
--

CREATE TABLE `sales` (
  `id` int NOT NULL,
  `sales_date` datetime DEFAULT CURRENT_TIMESTAMP,
  `customer_name` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `is_reseller` tinyint(1) DEFAULT '0',
  `subtotal` int DEFAULT NULL,
  `total_amount` int DEFAULT NULL,
  `discount` int DEFAULT '0',
  `shipping` int DEFAULT '0',
  `note` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci,
  `payment_type` enum('cash','transfer','pending') CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT 'cash',
  `payment_method` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `sales`
--

INSERT INTO `sales` (`id`, `sales_date`, `customer_name`, `is_reseller`, `subtotal`, `total_amount`, `discount`, `shipping`, `note`, `payment_type`, `payment_method`) VALUES
(29, '2025-05-18 17:39:00', 'Ibu Liana', 0, 680000, 680000, 0, 0, 'Diambil sabtu', 'transfer', 'Transfer'),
(34, '2025-05-20 00:53:00', 'Bpk Rusmin', 0, 120000, 120000, 0, 0, '', 'cash', 'Cash'),
(35, '2025-05-20 01:06:00', 'Ibu Amalia Hariawan', 0, 420000, 483000, 0, 63000, '', 'transfer', 'Transfer'),
(36, '2025-05-20 03:03:00', 'Lisa', 0, 66000, 66000, 0, 0, '', 'cash', 'Transfer'),
(45, '2025-05-21 00:43:00', 'Bpk Rusmin', 0, 151000, 150000, 1000, 0, '', 'cash', 'Cash'),
(47, '2025-05-21 00:54:00', 'Mama Rita', 0, 30000, 30000, 0, 0, '', 'cash', 'transfer'),
(49, '2025-05-21 01:28:00', 'cust.', 0, 124000, 124000, 0, 0, '', 'cash', 'Cash'),
(50, '2025-05-21 01:28:00', 'cust.', 0, 20000, 20000, 0, 0, '', 'cash', 'Cash'),
(53, '2025-05-23 07:16:00', 'Ko Liang - Ci Lan Semarang', 0, 140000, 140000, 0, 0, 'Dikirim ke : \r\nBpk Djoko W\r\n0817100247\r\nPelepah Indah 2 LB 21/7\r\nKelapa gading permai, Jakarta utara', 'cash', 'Transfer'),
(54, '2025-05-24 00:56:00', 'Tante Liana', 0, 79000, 79000, 0, 0, '', 'cash', 'Cash'),
(56, '2025-05-24 01:01:00', 'Tante Liana', 0, 805000, 690000, 115000, 0, '', 'cash', 'Transfer'),
(57, '2025-05-24 12:15:00', 'Bpk Rusmin', 0, 160000, 160000, 0, 0, '', 'cash', 'Transfer'),
(58, '2025-05-24 12:15:00', 'Mama', 0, 174000, 174000, 0, 0, '', 'cash', 'Pending'),
(59, '0000-00-00 00:00:00', 'trst', 1, 11700, 11700, 0, 0, '', 'transfer', ''),
(81, '2025-05-25 16:04:15', 'ibu Mimi', 1, 175800, 175800, 0, 0, '', 'pending', ''),
(82, '2025-05-25 16:06:25', 'Mama Rita', 0, 80000, 80000, 0, 0, '', 'pending', ''),
(83, '2025-05-25 16:13:46', 'cust.', 0, 212000, 212000, 0, 0, '', 'cash', ''),
(84, '2025-05-27 01:16:56', 'rusmin ', 0, 117000, 120000, 0, 3000, '', 'cash', ''),
(87, '2025-05-27 04:59:59', 'Lisa', 0, 87000, 87000, 0, 0, '', 'transfer', ''),
(88, '2025-05-27 05:00:33', 'Ibu Tisa', 0, 98000, 98000, 0, 0, '', 'cash', ''),
(89, '2025-05-28 00:06:09', 'Ibu Indra', 0, 63000, 63000, 0, 0, '', 'transfer', ''),
(90, '2025-05-28 00:54:08', 'Cust. Walk in', 0, 18000, 18000, 0, 0, '', 'cash', ''),
(91, '2025-05-28 03:19:18', 'Cust. Walk in', 0, 16000, 16000, 0, 0, '', 'cash', ''),
(92, '2025-05-28 03:37:08', 'Silvi', 0, 108000, 108000, 0, 0, '', 'cash', ''),
(93, '2025-05-28 10:27:43', 'Amalia H', 0, 348000, 411000, 0, 63000, '', 'transfer', ''),
(94, '2025-05-28 10:35:16', 'Ibu Mei Ing', 0, 92000, 92000, 0, 0, '', 'transfer', ''),
(95, '2025-05-30 00:03:09', 'Ibu Mei Ing', 0, 181000, 181000, 0, 0, '', 'transfer', 'Transfer'),
(96, '2025-05-30 00:10:25', 'Bpk rusmin', 0, 122000, 120000, 2000, 0, '', 'cash', ''),
(97, '2025-05-30 01:45:09', 'Cust. ', 0, 145000, 145000, 0, 0, '', 'transfer', ''),
(103, '2025-05-31 00:30:19', 'Mama Rita', 0, 72000, 72000, 0, 0, '', 'pending', 'Transfer'),
(104, '2025-05-31 01:47:19', 'janur indah', 0, 161000, 161000, 0, 0, '', 'cash', ''),
(105, '2025-05-31 14:03:31', 'Silvi', 0, 82000, 81000, 1000, 0, '', 'cash', ''),
(106, '2025-05-31 14:06:12', 'Ibu Hana', 0, 560000, 560000, 0, 0, 'PO untuk hari Senin jam 5 sore.', 'pending', ''),
(107, '2025-06-03 00:24:57', 'Miss Christin - Aurelia', 0, 45000, 45000, 0, 0, '', 'transfer', ''),
(108, '2025-06-03 01:10:49', 'Ibu Mei Ing', 0, 235000, 235000, 0, 0, '', 'transfer', ''),
(109, '2025-06-03 05:25:17', 'lisa', 0, 89000, 89000, 0, 0, '', 'cash', ''),
(110, '2025-06-03 05:26:18', 'dr natalia n friska', 0, 160000, 160000, 0, 0, '', 'cash', 'Cash'),
(111, '2025-06-03 06:07:15', 'Yulia', 0, 256000, 281000, 0, 25000, 'Pengiriman Selasa 10 Juni 2025, sampai di lokasi jam 11 siang.  PT. Asianagro Agungjaya Jl. Ende blok C.1-A.47.B, Kecamatan : Cilincing , Kelurahan : Cilincing, Kode pos : 14150. CP : Yulia +62 813-8587-9659..', 'transfer', ''),
(112, '2025-06-03 13:46:41', 'Natalia', 0, 182000, 182000, 0, 0, '', 'transfer', 'Transfer'),
(113, '2025-06-04 02:38:09', 'bpk a', 0, 17000, 17000, 0, 0, '', 'cash', ''),
(114, '2025-06-04 02:39:29', 'bu lieke', 0, 61000, 61000, 0, 0, '', 'cash', ''),
(115, '2025-06-04 02:51:24', 'Shearly', 0, 31000, 31000, 0, 0, '', 'transfer', ''),
(116, '2025-06-04 03:02:15', 'Cust. Walk in', 0, 14000, 14000, 0, 0, '', 'cash', ''),
(117, '2025-06-04 03:02:45', 'Ibu Mimi', 1, 55000, 55000, 0, 0, '', 'pending', ''),
(118, '2025-06-06 00:02:20', 'Eko', 0, 80000, 80000, 0, 0, '', 'transfer', ''),
(119, '2025-06-06 00:10:00', 'Ibu Elly', 0, 62000, 62000, 0, 0, '', 'transfer', ''),
(120, '2025-06-06 00:23:03', 'Bpk Rusmin', 0, 96000, 96000, 0, 0, '', 'cash', 'Cash'),
(122, '2025-06-06 00:43:12', 'Cust. Walk in', 0, 71000, 71000, 0, 0, '', 'cash', 'Transfer'),
(123, '2025-06-06 00:52:13', 'Bpk rusmin', 0, 35000, 35000, 0, 0, '', 'cash', ''),
(124, '2025-06-06 00:52:36', 'Cust. Walk in', 0, 36000, 36000, 0, 0, '', 'cash', ''),
(125, '2025-06-06 00:53:10', 'Cust. Walk in', 0, 29000, 29000, 0, 0, '', 'cash', ''),
(126, '2025-06-06 00:55:21', 'Cust. Walk in', 0, 25000, 25000, 0, 0, '', 'cash', ''),
(127, '2025-06-06 23:59:48', 'Mama Rita', 0, 9000, 9000, 0, 0, '', 'pending', ''),
(128, '2025-06-07 00:08:07', 'Cust. Walk in', 0, 39000, 39000, 0, 0, '', 'cash', ''),
(129, '2025-06-07 00:26:57', 'Cust. Walk in', 0, 59000, 59000, 0, 0, '', 'cash', ''),
(130, '2025-06-07 00:28:08', 'Cust. Walk in', 0, 23000, 23000, 0, 0, '', 'cash', ''),
(131, '2025-06-07 00:28:56', 'Cust. Walk in', 0, 20000, 20000, 0, 0, '', 'cash', ''),
(132, '2025-06-07 00:59:49', 'Elfrida ', 1, 218000, 218000, 0, 0, '', 'pending', ''),
(133, '2025-06-07 02:29:41', 'pak rusmin ', 0, 175000, 175000, 0, 0, '', 'cash', ''),
(134, '2025-06-07 02:46:49', 'lisa', 0, 118000, 118000, 0, 0, '', 'cash', ''),
(135, '2025-06-07 11:25:32', 'Elfrida ', 1, 34000, 34000, 0, 0, '', 'pending', ''),
(136, '2025-06-07 11:50:37', 'Bpk rusmin', 0, 96000, 96000, 0, 0, '', 'transfer', ''),
(137, '2025-06-07 12:04:00', 'Drg. Mariana', 0, 125000, 125000, 0, 0, 'PO Picnic Roll Beef Cordon Bleu untuk Selasa', 'transfer', ''),
(138, '2025-06-10 00:38:07', 'bu indra', 0, 102000, 102000, 0, 0, '', 'cash', 'Cash'),
(139, '2025-06-10 03:32:40', 'Lisa', 0, 132000, 132000, 0, 0, '', 'transfer', ''),
(140, '2025-06-10 04:25:39', 'sis helen walk in', 0, 83000, 83000, 0, 0, '', 'cash', ''),
(141, '2025-06-11 00:30:57', 'Cust. Walk in', 0, 20000, 20000, 0, 0, '', 'cash', ''),
(142, '2025-06-11 00:31:13', 'Cust. Walk in', 0, 10000, 10000, 0, 0, '', 'cash', ''),
(143, '2025-06-11 01:59:10', 'walk in', 0, 41000, 41000, 0, 0, '', 'cash', ''),
(144, '2025-06-11 02:11:48', 'Rita (mama) rabu', 0, 49000, 49000, 0, 0, 'rabu 3 item. selasa 1 kismis', 'cash', ''),
(145, '2025-06-11 02:48:48', 'Bu Indra ', 0, 85000, 85000, 0, 0, '', 'cash', ''),
(146, '2025-06-11 03:05:22', 'Cust. Walk in', 0, 10000, 10000, 0, 0, '', 'cash', ''),
(147, '2025-06-11 03:06:14', 'Cust. Walk in', 0, 21000, 21000, 0, 0, '', 'cash', ''),
(148, '2025-06-11 03:07:28', 'Cust. Walk in', 0, 33000, 33000, 0, 0, '', 'cash', ''),
(149, '2025-06-11 03:07:49', 'Cust. Walk in', 0, 20000, 20000, 0, 0, '', 'cash', ''),
(151, '2025-06-11 18:10:13', 'Pak Rusmin', 0, 96000, 96000, 0, 0, 'roti daing PO 12pieces', 'cash', ''),
(152, '2025-06-11 18:12:32', 'Teman Pak Rusmin (utk rabu pagi delivery ke tim jogging pak rusmin)', 0, 144000, 144000, 0, 0, 'mix mentega / non mentega', 'cash', 'Cash'),
(153, '2025-06-12 11:51:50', 'Ibu Mimi', 1, 154500, 154500, 0, 0, '', 'pending', ''),
(154, '2025-06-12 11:53:29', 'Silvi', 0, 299000, 299000, 0, 0, '', 'cash', ''),
(155, '2025-06-13 07:43:24', 'Ibu mely', 0, 9000, 9000, 0, 0, '', 'cash', ''),
(156, '2025-06-13 07:44:09', 'Ibu mely', 0, 43000, 43000, 0, 0, '', 'cash', 'Cash'),
(157, '2025-06-13 08:07:41', 'Ibu Lieke', 0, 58000, 58000, 0, 0, '', 'cash', 'Transfer'),
(158, '2025-06-13 10:23:41', 'Cust. Walk in', 0, 43000, 43000, 0, 0, '', 'cash', ''),
(159, '2025-06-13 12:05:57', 'ibu janur indah', 0, 0, 0, 0, 0, '', 'cash', ''),
(160, '2025-06-13 12:07:14', 'ibu oma janur indah', 0, 52000, 52000, 0, 0, '', 'cash', ''),
(161, '2025-06-13 12:18:22', 'Mama Rita', 0, 30000, 30000, 0, 0, '', 'cash', ''),
(162, '2025-06-13 12:28:18', 'Lisa', 0, 67000, 67000, 0, 0, '', 'cash', ''),
(163, '2025-06-13 12:48:57', 'michael', 0, 21500, 21500, 0, 0, '', 'transfer', ''),
(164, '2025-06-13 15:32:48', 'Mama', 0, 85000, 85000, 0, 0, '', 'transfer', ''),
(165, '2025-06-14 07:06:04', 'Ibu Leny', 0, 36000, 36000, 0, 0, '', 'transfer', ''),
(166, '2025-06-14 07:11:11', 'maliana ', 0, 86000, 86000, 0, 0, 'blm transfwr', 'transfer', ''),
(167, '2025-06-14 12:43:45', 'bu yunita - moi', 0, 110000, 110000, 0, 0, '', 'cash', 'Transfer'),
(168, '2025-06-14 18:36:19', 'Mama', 0, 226000, 226000, 0, 0, '', 'transfer', ''),
(169, '2025-06-14 18:44:28', 'Ibu Leny', 0, 82500, 82500, 0, 0, '', 'transfer', ''),
(170, '2025-06-15 14:47:19', 'elly kayumas po jumat 20juni ', 0, 175000, 175000, 0, 0, 'elly kayumas po jumat 20juni', 'cash', ''),
(171, '2025-06-17 07:57:09', 'Bpk Rusmin', 0, 100000, 100000, 0, 0, '', 'cash', ''),
(172, '2025-06-17 09:35:29', 'Rita (mama) ', 0, 19000, 19000, 0, 0, '', 'cash', ''),
(173, '2025-06-17 15:53:07', 'Silvi', 0, 148000, 148000, 0, 0, '', 'cash', 'Cash'),
(174, '2025-06-17 15:58:11', 'Mama', 0, 320000, 320000, 0, 0, '', 'transfer', ''),
(176, '2025-06-18 07:07:19', 'Bpk Rusmin', 0, 121000, 120000, 1000, 0, '', 'cash', 'Cash'),
(178, '2025-06-18 07:30:53', 'Cust. Walk in Pak Johanes JI', 0, 60000, 60000, 0, 0, '', 'cash', 'Cash'),
(179, '2025-06-18 08:54:30', 'bu teesa JI', 0, 46000, 46000, 0, 0, '', 'cash', ''),
(180, '2025-06-18 09:15:06', 'lieke', 0, 42000, 42000, 0, 0, '', 'cash', 'Cash'),
(181, '2025-06-18 11:03:14', 'bu lanny', 0, 53000, 53000, 0, 0, '', 'cash', ''),
(182, '2025-06-18 11:05:46', 'eko', 0, 26000, 26000, 0, 0, '', 'cash', ''),
(183, '2025-06-18 18:07:51', 'helen PO jumat 11 siang ', 0, 186000, 186000, 0, 0, '', 'cash', ''),
(184, '2025-06-19 17:45:50', 'mei ing PO jumat', 0, 158000, 158000, 0, 0, 'PO utk jumat dikirim jumat sore bareng mochi kacang', 'cash', ''),
(185, '2025-06-20 06:54:54', 'maliana JI', 0, 30000, 30000, 0, 0, '', 'cash', ''),
(186, '2025-06-20 06:57:24', 'Lanny JI4', 0, 41000, 41000, 0, 0, '', 'cash', ''),
(187, '2025-06-20 08:40:03', 'rusmin ibu', 0, 104000, 104000, 0, 0, '', 'cash', ''),
(188, '2025-06-20 09:27:16', 'rita mama', 0, 269000, 269000, 0, 0, '', 'cash', 'Transfer'),
(189, '2025-06-20 09:28:24', 'lisa', 0, 76000, 76000, 0, 0, '', 'cash', ''),
(190, '2025-06-20 12:57:55', 'bu indra', 0, 111000, 100000, 11000, 0, '', 'cash', ''),
(191, '2025-06-20 17:02:08', 'Ibu Mimi', 1, 157000, 157000, 0, 0, '', 'transfer', ''),
(194, '2025-06-20 20:15:56', 'Ibu Beby', 0, 450000, 465000, 0, 15000, '', 'transfer', ''),
(195, '2025-06-21 09:35:20', 'tante liana', 0, 49000, 49000, 0, 0, '', 'cash', ''),
(196, '2025-06-21 10:03:30', 'Teesa', 0, 72000, 72000, 0, 0, '', 'cash', ''),
(197, '2025-06-21 10:04:54', 'Lisa', 0, 77000, 77000, 0, 0, '', 'cash', ''),
(198, '2025-06-21 11:01:12', 'bu dewi lb5no6', 0, 67000, 67000, 0, 0, 'ibu dewi mau pesan PO 2kismis hari selasa (belum bayar cash COD)', 'cash', ''),
(199, '2025-06-21 11:14:29', 'elfrida', 0, 46000, 46000, 0, 0, 'bayar via kath', 'cash', ''),
(200, '2025-06-21 21:33:20', 'Elfrida ', 1, 80000, 80000, 0, 0, '', 'transfer', ''),
(201, '2025-06-21 21:38:14', 'Tante Liana', 1, 510000, 510000, 0, 0, '', 'transfer', ''),
(202, '2025-06-24 07:57:59', 'Ibu Lieke', 0, 49000, 49000, 0, 0, '', 'transfer', ''),
(203, '2025-06-24 09:27:32', 'bu dewi lb5no6', 0, 20000, 20000, 0, 0, '', 'cash', ''),
(204, '2025-06-24 11:54:29', 'walk in bpk', 0, 62000, 62000, 0, 0, '', 'cash', ''),
(205, '2025-06-24 12:02:25', 'bpk bam JI RW', 0, 79000, 79000, 0, 0, '', 'cash', ''),
(206, '2025-06-24 12:21:58', 'lisa', 0, 94000, 94000, 0, 0, '', 'cash', ''),
(207, '2025-06-24 14:14:16', 'Natalia', 0, 105000, 105000, 0, 0, '', 'transfer', ''),
(208, '2025-06-24 14:16:48', 'Natalia', 0, 94000, 94000, 0, 0, '', 'transfer', ''),
(209, '2025-06-25 07:59:52', 'bu rusmin', 0, 124000, 124000, 0, 0, '', 'cash', ''),
(210, '2025-06-25 08:30:23', 'Bpk Rusmin', 0, 120000, 120000, 0, 0, '', 'cash', 'Cash'),
(211, '2025-06-25 08:35:31', 'Ibu Lieke', 0, 29000, 29000, 0, 0, '', 'transfer', ''),
(212, '2025-06-25 17:34:27', 'bu mei ing walk in', 0, 39000, 39000, 0, 0, '', 'cash', ''),
(213, '2025-06-26 01:00:30', 'Lisa', 0, 95000, 95000, 0, 0, 'rabu', 'cash', 'Cash'),
(214, '2025-06-27 07:21:13', 'Ibu Indra', 0, 83000, 83000, 0, 0, '', 'cash', ''),
(215, '2025-06-27 07:44:01', 'Ibu Mariana', 0, 103000, 103000, 0, 0, '', 'cash', 'Cash'),
(216, '2025-06-27 08:09:57', 'Cust. Walk in', 0, 61000, 61000, 0, 0, '', 'cash', ''),
(217, '2025-06-27 10:04:53', 'papa', 0, 92000, 92000, 0, 0, '', 'transfer', ''),
(218, '2025-06-27 12:37:37', 'lisa', 0, 103000, 103000, 0, 0, '', 'cash', ''),
(219, '2025-06-27 12:39:40', 'dina', 0, 38000, 38000, 0, 0, '', 'cash', ''),
(220, '2025-06-28 08:16:59', 'lieke', 0, 46000, 46000, 0, 0, '', 'cash', ''),
(221, '2025-06-28 08:17:52', 'walk in', 0, 50000, 50000, 0, 0, '', 'cash', ''),
(222, '2025-06-28 11:06:00', 'silvi ', 0, 65000, 65000, 0, 0, '', 'cash', ''),
(223, '2025-06-28 12:59:07', 'lisa', 0, 95000, 95000, 0, 0, '', 'cash', ''),
(224, '2025-07-01 08:21:00', 'Ibu Lely', 0, 43000, 43000, 0, 0, '', 'cash', ''),
(225, '2025-07-01 10:08:38', 'Cust.. Gereja ', 0, 290000, 290000, 0, 0, 'Untuk Rabu tgl 9 Juli 2025 pagi.', 'transfer', 'Transfer'),
(226, '2025-07-01 10:39:51', 'Janur Indah', 0, 59000, 59000, 0, 0, '', 'cash', 'Cash'),
(227, '2025-07-01 11:08:50', 'Bpk Rusmin', 0, 144000, 144000, 0, 0, 'Sisa pembayaran lalu Rp.6.000,-  . Total pembayaran 144.000-6.000=138.000', 'cash', ''),
(228, '2025-07-01 12:37:49', 'mei ing', 0, 102000, 102000, 0, 0, '', 'cash', ''),
(229, '2025-07-01 12:56:51', 'bu mei ing extra', 0, 53000, 53000, 0, 0, '', 'cash', ''),
(230, '2025-07-02 09:27:38', 'Ibu Leny', 0, 32000, 32000, 0, 0, '', 'cash', ''),
(231, '2025-07-02 09:27:53', 'Cust. Walk in', 0, 94000, 94000, 0, 0, '', 'cash', 'Cash'),
(232, '2025-07-02 10:36:43', 'Cust. Walk in', 0, 8000, 8000, 0, 0, '', 'cash', ''),
(233, '2025-07-02 10:40:23', 'Cust. Walk in', 0, 12000, 12000, 0, 0, '', 'cash', ''),
(235, '2025-07-02 11:32:07', 'ibu - kodamar', 0, 20000, 20000, 0, 0, '', 'cash', ''),
(236, '2025-07-02 14:29:21', 'Papa kath', 0, 1035000, 1035000, 0, 0, '', 'transfer', 'Transfer'),
(237, '2025-07-08 07:54:33', 'bu indra JI', 0, 89000, 89000, 0, 0, '', 'cash', ''),
(238, '2025-07-08 08:13:39', 'indra JI rebuy', 0, 60000, 60000, 0, 0, '', 'cash', ''),
(240, '2025-07-08 08:53:23', 'bu Lieke', 0, 33000, 33000, 0, 0, '', 'cash', ''),
(241, '2025-07-08 10:33:40', 'Mama rita', 0, 20000, 20000, 0, 0, '', 'cash', ''),
(242, '2025-07-08 20:44:17', 'walk in', 0, 60000, 60000, 0, 0, '', 'cash', ''),
(243, '2025-07-08 21:00:07', 'bu rusmin', 0, 60000, 60000, 0, 0, '', 'cash', ''),
(244, '2025-07-08 21:02:21', 'lisa', 0, 45000, 45000, 0, 0, '', 'cash', ''),
(245, '2025-07-09 12:13:53', 'Lisa ', 0, 90000, 90000, 0, 0, '', 'cash', ''),
(247, '2025-07-15 11:26:11', 'rita mama', 0, 42000, 42000, 0, 0, '', 'cash', ''),
(249, '2025-07-15 11:26:54', 'walk in', 0, 52000, 52000, 0, 0, '', 'cash', ''),
(250, '2025-07-15 11:28:37', 'lisa', 0, 147000, 147000, 0, 0, '', 'cash', ''),
(251, '2025-07-15 11:30:27', 'dr natalia', 0, 113000, 113000, 0, 0, '', 'cash', ''),
(252, '2025-07-15 13:44:31', 'po online ', 0, 120000, 120000, 0, 0, '', 'cash', 'Cash'),
(253, '2025-07-16 10:23:16', 'Pak Intony JI', 0, 30000, 30000, 0, 0, '', 'cash', 'Cash'),
(254, '2025-07-16 10:24:09', 'staff puskes', 0, 40000, 40000, 0, 0, '', 'cash', ''),
(255, '2025-07-16 10:25:33', 'dr mariana JI', 0, 60000, 60000, 0, 0, '', 'cash', ''),
(256, '2025-07-16 10:58:42', 'lisa', 0, 100000, 100000, 0, 0, '', 'cash', 'Cash'),
(257, '2025-07-18 09:26:28', 'Ibu Lieke', 0, 56000, 56000, 0, 0, '', 'transfer', ''),
(258, '2025-07-18 10:24:06', 'lisa', 0, 188500, 188500, 0, 0, '', 'cash', ''),
(259, '2025-07-18 11:21:16', 'walk in', 0, 34000, 34000, 0, 0, '', 'cash', ''),
(260, '2025-07-18 22:27:13', 'bu inge MOI roti', 0, 10000, 10000, 0, 0, '', 'cash', ''),
(261, '2025-07-19 01:34:49', 'pak. dicky po sabtu', 0, 156000, 156000, 0, 0, '', 'cash', ''),
(262, '2025-07-19 08:53:48', 'bu lieke', 0, 32000, 32000, 0, 0, '', 'cash', ''),
(263, '2025-07-19 09:03:55', 'tante liana', 0, 59000, 59000, 0, 0, 'sudah lunas tunai (tadi ambil 10.5mochi wijen +5mochi kacang)', 'cash', 'Cash'),
(264, '2025-07-19 09:05:54', 'rita mama', 0, 59000, 59000, 0, 0, 'tante siane 1mochi dan tante Christin 1mochi,bkm payment(nitip mama) ', 'cash', 'Pending'),
(265, '2025-07-19 09:53:10', 'bu rusmin ', 0, 116000, 116000, 0, 0, '', 'cash', ''),
(267, '2025-07-19 14:16:57', 'Lisa ', 0, 96000, 96000, 0, 0, '', 'cash', ''),
(268, '2025-07-19 23:48:59', 'Elfrida ', 1, 560000, 560000, 0, 0, 'Oleh oleh Sukabumi', 'transfer', ''),
(269, '2025-07-19 23:51:16', 'Elfrida ', 0, 40000, 40000, 0, 0, '', 'transfer', ''),
(270, '2025-07-20 00:03:33', 'Ibu Mimi', 1, 253300, 253300, 0, 0, '', 'transfer', ''),
(271, '2025-07-20 15:40:48', 'Ibu Mimi', 0, 90000, 90000, 0, 0, 'Mochi', 'cash', ''),
(272, '2025-07-22 07:23:19', 'walkin', 0, 43000, 43000, 0, 0, '', 'cash', ''),
(273, '2025-07-22 07:24:40', 'rita mama ', 0, 25000, 25000, 0, 0, '', 'cash', ''),
(274, '2025-07-22 08:36:18', 'bu lieke ', 0, 52000, 52000, 0, 0, '', 'cash', ''),
(275, '2025-07-22 09:14:35', 'ibu mei ing ', 0, 100000, 100000, 0, 0, '', 'pending', ''),
(277, '2025-07-22 10:27:02', 'cust. walk in', 0, 10000, 10000, 0, 0, '', 'cash', ''),
(278, '2025-07-22 10:48:17', 'walk in JI', 0, 17000, 17000, 0, 0, '', 'cash', 'Cash'),
(279, '2025-07-22 14:46:15', 'pak bernadus st aurelia ', 0, 8000, 8000, 0, 0, '', 'cash', ''),
(280, '2025-07-22 14:47:47', 'tante siane', 0, 7000, 7000, 0, 0, '', 'cash', ''),
(281, '2025-07-23 07:54:12', 'Ibu tissa', 0, 214000, 214000, 0, 0, '', 'transfer', ''),
(282, '2025-07-23 11:26:47', ' Owen Winston', 0, 207000, 222000, 0, 15000, 'Pesanan jumat 25 Juli 2025\r\n\r\na/n Owen Winston kelas Sec.2\r\nNo. Hp yang bisa dihubungi = 0817 9889747 \r\nPengiriman : ke sekolah lilin bangsa atau janur elok jam 10.00 .\r\n', 'transfer', ''),
(283, '2025-07-23 11:30:27', 'walk in puskesmas', 0, 7000, 7000, 0, 0, '', 'cash', ''),
(285, '2025-07-23 12:51:11', 'test', 0, 216000, 216000, 0, 0, '', 'transfer', 'Transfer'),
(286, '2025-07-25 08:13:11', 'bu lieke ', 0, 36000, 36000, 0, 0, '', 'cash', ''),
(287, '2025-07-25 09:34:34', 'lisa', 0, 66000, 66000, 0, 0, '', 'cash', ''),
(288, '2025-07-26 07:14:20', 'bu shinta ', 0, 157000, 157000, 0, 0, '', 'cash', 'Cash'),
(289, '2025-07-26 09:04:26', 'pak rusmin', 0, 122000, 120000, 2000, 0, '', 'cash', ''),
(292, '2025-07-26 22:50:10', 'ibu mimi - ibu tjien tjien BCA', 1, 82500, 82500, 0, 0, '', 'transfer', ''),
(293, '2025-07-26 22:51:43', 'ibu mimi - ibu fifi', 1, 52000, 52000, 0, 0, '', 'transfer', ''),
(294, '2025-07-26 22:53:25', 'ibu mimi', 1, 30500, 30500, 0, 0, 'transaksi pagi', 'transfer', ''),
(296, '2025-07-26 22:58:26', 'ibu mimi ', 1, 33000, 33000, 0, 0, 'transaksi jumat malam / sabtu pagi, melt cheese mozarella', 'transfer', ''),
(297, '2025-07-26 22:59:32', 'ibu mimi', 1, 625000, 625000, 0, 0, 'pesanan sabtu', 'cash', ''),
(298, '2025-07-26 23:02:26', 'ibu Mimi - ibu Netty', 1, 62000, 62000, 0, 0, '', 'transfer', ''),
(299, '2025-07-29 07:24:36', 'walkin puskesmas', 0, 99000, 99000, 0, 0, '', 'cash', ''),
(300, '2025-07-29 12:02:53', 'bu lieke', 0, 49000, 49000, 0, 0, '', 'cash', ''),
(301, '2025-07-29 12:04:12', 'lisa', 0, 91000, 91000, 0, 0, '', 'cash', ''),
(302, '2025-07-29 12:09:52', 'bu lely', 0, 49000, 49000, 0, 0, '', 'cash', ''),
(303, '2025-07-30 07:27:51', 'Bpk Rusmin', 0, 97000, 97000, 0, 0, 'Byr cash 100.000, belum diambil kembalian 3.000', 'cash', ''),
(304, '2025-07-30 08:13:43', 'bu rusmin', 0, 110000, 110000, 0, 0, '', 'cash', ''),
(305, '2025-07-30 11:05:43', 'bu nancy JI walk in', 0, 10000, 10000, 0, 0, '', 'cash', ''),
(306, '2025-07-30 11:06:29', 'lisa', 0, 78000, 78000, 0, 0, '', 'cash', ''),
(307, '2025-08-01 22:10:24', 'Pak Daniel - Paladian F1808', 0, 282000, 292000, 0, 10000, 'ojol delivery, sudah payment ongkir 10rb', 'cash', ''),
(309, '2025-08-01 22:11:36', 'Dr mariana - JI - PO Jumat', 0, 192000, 192000, 0, 0, 'special order - maling / USA spam bawa sendiri 6 med + 6 small', 'cash', 'Cash'),
(310, '2025-08-01 22:20:32', 'walk in ', 0, 52500, 52500, 0, 0, '', 'cash', 'Cash'),
(311, '2025-08-01 22:21:30', 'walk in B', 0, 35000, 35000, 0, 0, '', 'cash', ''),
(312, '2025-08-02 08:41:08', 'rusmin ', 0, 92000, 92000, 0, 0, '', 'cash', ''),
(313, '2025-08-02 08:49:13', 'walkin klp gdg', 0, 67000, 67000, 0, 0, '', 'cash', ''),
(314, '2025-08-02 09:37:00', 'lisa', 0, 40000, 40000, 0, 0, '', 'cash', ''),
(315, '2025-08-02 09:49:40', 'bu shinta pak anton paladian ', 0, 165000, 165000, 0, 0, 'ojol terpisah', 'cash', ''),
(317, '2025-08-04 16:44:53', '', 1, 43000, 43000, 0, 0, '', 'transfer', ''),
(318, '2025-08-04 16:44:55', 'Ibu mimi - minggu pagi', 1, 167500, 167500, 0, 0, '', 'transfer', ''),
(319, '2025-08-05 09:00:52', 'walkin JI', 0, 27000, 27000, 0, 0, '', 'cash', ''),
(320, '2025-08-05 09:02:14', 'eko', 0, 33000, 33000, 0, 0, '', 'cash', ''),
(321, '2025-08-05 09:03:05', 'bernadus - aurelia', 0, 8000, 8000, 0, 0, '', 'cash', ''),
(322, '2025-08-05 09:26:19', 'walkin pskms pasien', 0, 12000, 12000, 0, 0, '', 'cash', ''),
(323, '2025-08-05 12:53:39', 'walkin', 0, 25000, 25000, 0, 0, '', 'cash', ''),
(324, '2025-08-05 14:36:01', 'mama rita', 0, 35000, 35000, 0, 0, '', 'cash', 'Transfer'),
(325, '2025-08-06 07:21:21', 'ibu meli', 0, 70000, 70000, 0, 0, '', 'cash', ''),
(326, '2025-08-06 07:22:02', 'walkin puskesmas', 0, 17000, 17000, 0, 0, '', 'cash', ''),
(327, '2025-08-06 10:32:40', 'Mama Rita', 0, 64000, 64000, 0, 0, '', 'transfer', 'Transfer'),
(328, '2025-08-06 17:36:33', 'Lisa', 0, 88000, 88000, 0, 0, '', 'cash', ''),
(329, '2025-08-06 17:45:15', 'bu dian - puskesmas', 0, 48000, 48000, 0, 0, '', 'cash', ''),
(330, '2025-08-07 06:29:38', 'rita mama', 0, 32000, 32000, 0, 0, '', 'cash', ''),
(331, '2025-08-08 09:31:46', 'bu linda JI', 0, 47000, 47000, 0, 0, '', 'cash', ''),
(332, '2025-08-08 10:33:57', 'Cust. Walk in', 0, 16000, 16000, 0, 0, '', 'cash', ''),
(333, '2025-08-08 11:01:24', 'walkin', 0, 138000, 138000, 0, 0, '', 'cash', ''),
(334, '2025-08-09 08:42:51', 'Elfrida ', 0, 20000, 20000, 0, 0, '', 'cash', ''),
(335, '2025-08-09 08:44:57', 'pak rusmin ', 0, 52000, 52000, 0, 0, '', 'cash', ''),
(336, '2025-08-09 08:45:07', 'lisa ', 0, 56000, 56000, 0, 0, '', 'cash', ''),
(337, '2025-08-09 09:37:17', 'eko JI', 0, 110000, 110000, 0, 0, '', 'cash', ''),
(338, '2025-08-12 07:21:43', 'bu lieke ', 0, 46000, 46000, 0, 0, '', 'cash', ''),
(339, '2025-08-12 09:30:35', 'rita mama', 0, 129000, 129000, 0, 0, '', 'cash', ''),
(340, '2025-08-12 11:44:40', 'dr mariana JI', 0, 116000, 116000, 0, 0, '', 'cash', 'Cash'),
(341, '2025-08-12 11:59:46', 'dr mariana JI', 0, 14000, 14000, 0, 0, '', 'cash', ''),
(344, '2025-08-12 15:02:58', 'puskesmas walkin ', 0, 14000, 14000, 0, 0, '', 'cash', ''),
(345, '2025-08-12 15:04:16', 'pak bernardus aurelia', 0, 8000, 8000, 0, 0, '', 'cash', ''),
(346, '2025-08-12 15:06:16', 'bu yuni aurelia', 0, 67500, 67500, 0, 0, '', 'cash', ''),
(347, '2025-08-13 08:17:44', 'walkin JI', 0, 88000, 88000, 0, 0, '', 'cash', ''),
(348, '2025-08-13 08:50:35', 'rita mama', 0, 10000, 10000, 0, 0, '', 'cash', ''),
(349, '2025-08-13 11:25:42', 'walkin', 0, 112000, 112000, 0, 0, '', 'cash', ''),
(350, '2025-08-13 18:01:17', 'PO rabu ', 0, 490000, 490000, 0, 0, '', 'cash', ''),
(351, '2025-08-15 07:26:05', 'bu meli', 0, 90000, 90000, 0, 0, '', 'cash', ''),
(352, '2025-08-15 08:56:39', 'pak rusmin', 0, 266000, 266000, 0, 0, '', 'cash', ''),
(353, '2025-08-15 09:17:39', 'bu shinta - paladian', 0, 285000, 285000, 0, 0, '', 'cash', ''),
(354, '2025-08-15 12:51:16', 'walkin', 0, 96500, 96500, 0, 0, '', 'cash', ''),
(355, '2025-08-15 12:51:52', 'lisa', 0, 30000, 30000, 0, 0, '', 'cash', ''),
(356, '2025-08-16 08:54:31', 'RW 09', 0, 1120000, 1120000, 0, 0, '', 'transfer', ''),
(358, '2025-08-16 09:11:34', 'RW 09 (pesanan 2)', 0, 700000, 700000, 0, 0, '', 'transfer', ''),
(359, '2025-08-16 09:12:41', 'GBI', 0, 175000, 175000, 0, 0, '', 'transfer', ''),
(360, '2025-08-22 09:13:12', 'bu meli', 0, 83000, 83000, 0, 0, '', 'cash', 'Cash'),
(361, '2025-08-22 09:14:48', 'rita mama', 0, 443000, 443000, 0, 0, '', 'cash', ''),
(362, '2025-08-22 09:17:45', 'walkin JI jogging', 0, 20000, 20000, 0, 0, '', 'cash', ''),
(363, '2025-08-22 09:41:21', 'ibu dini', 0, 238000, 238000, 0, 0, '', 'cash', ''),
(364, '2025-08-22 17:14:27', 'ibu Meli (RABU copas ulang) ', 0, 83000, 83000, 0, 0, '', 'cash', 'Cash'),
(365, '2025-08-22 17:16:59', 'lisa', 0, 102000, 102000, 0, 0, '', 'cash', ''),
(366, '2025-08-22 17:19:09', 'lisa (RABU copas ulang) ', 0, 90000, 90000, 0, 0, '', 'cash', 'Cash'),
(367, '2025-08-23 00:15:24', 'dr mariana  jumat', 0, 86000, 86000, 0, 0, '', 'cash', 'Cash'),
(369, '2025-08-23 07:49:56', 'eko', 0, 61000, 61000, 0, 0, '', 'cash', ''),
(370, '2025-08-23 09:49:47', 'Lisa sabtu', 0, 146000, 146000, 0, 0, '', 'cash', ''),
(371, '2025-08-23 09:51:32', 'mama rita', 0, 52000, 52000, 0, 0, '', 'cash', ''),
(372, '2025-08-23 17:01:54', 'walk in', 0, 64000, 64000, 0, 0, '', 'cash', ''),
(373, '2025-08-26 07:23:19', 'mama kath', 0, 152000, 152000, 0, 0, '', 'cash', ''),
(374, '2025-08-26 07:24:08', 'Dina Kath ', 0, 80000, 80000, 0, 0, '', 'cash', 'Cash'),
(375, '2025-08-26 07:57:28', 'Lisa', 0, 122000, 122000, 0, 0, '', 'cash', ''),
(376, '2025-08-26 08:00:23', 'Bu Priska Pal', 0, 81000, 81000, 0, 0, '', 'cash', ''),
(377, '2025-08-26 08:13:50', 'mariana', 0, 41000, 41000, 0, 0, '', 'cash', 'Cash'),
(378, '2025-08-26 09:30:36', 'walkin', 0, 14000, 14000, 0, 0, '', 'cash', ''),
(382, '2025-08-26 09:33:56', 'bu dini', 0, 308000, 308000, 0, 0, '', 'cash', ''),
(383, '2025-08-26 11:56:16', 'lisa 1', 0, 39000, 39000, 0, 0, '', 'cash', ''),
(384, '2025-08-27 15:50:11', 'lisa', 0, 135500, 135500, 0, 0, '', 'cash', ''),
(385, '2025-08-27 19:59:22', 'rita mama', 0, 66000, 66000, 0, 0, '', 'cash', ''),
(386, '2025-08-29 06:57:31', 'Bpk rusmin', 0, 105000, 100000, 5000, 0, '', 'cash', 'Cash'),
(387, '2025-08-29 06:58:53', 'Dr Camelia', 0, 72000, 72000, 0, 0, '', 'transfer', ''),
(388, '2025-08-29 08:51:34', 'bu meli', 0, 86000, 86000, 0, 0, '', 'cash', ''),
(389, '2025-08-29 17:36:03', 'lisa ', 0, 77500, 77500, 0, 0, '', 'cash', ''),
(390, '2025-08-29 17:41:25', 'bu yuni aurelia (jumat n sabtu) ', 0, 213900, 213900, 0, 0, '', 'cash', ''),
(391, '2025-08-30 13:13:10', 'bu mei ing', 0, 96000, 96000, 0, 0, '', 'cash', ''),
(392, '2025-08-30 13:39:03', 'lisa', 0, 96000, 96000, 0, 0, '', 'cash', ''),
(393, '2025-08-30 13:40:49', 'a', 0, 70000, 70000, 0, 0, '', 'cash', 'Cash'),
(395, '2025-09-02 20:54:58', 'Lisa', 0, 76000, 76000, 0, 0, '', 'cash', ''),
(396, '2025-09-02 20:56:23', 'po', 0, 72000, 72000, 0, 0, '', 'cash', ''),
(397, '2025-09-03 16:20:59', 'po', 0, 157000, 157000, 0, 0, '', 'cash', ''),
(398, '2025-09-03 16:22:36', 'lisa', 0, 151000, 151000, 0, 0, '', 'cash', ''),
(399, '2025-09-05 07:34:09', 'bu mariana', 0, 73000, 73000, 0, 0, '', 'cash', ''),
(400, '2025-09-05 09:30:21', 'pak rusmin ', 0, 124000, 124000, 0, 0, '', 'cash', ''),
(401, '2025-09-05 09:57:00', 'pak rusmin 2', 0, 35000, 35000, 0, 0, '', 'cash', ''),
(402, '2025-09-05 16:59:36', 'lisa', 0, 138000, 138000, 0, 0, '', 'cash', ''),
(403, '2025-09-06 10:20:38', 'rusmin', 0, 330000, 330000, 0, 0, '', 'cash', ''),
(404, '2025-09-06 10:23:09', 'lisa', 0, 123500, 123500, 0, 0, '', 'cash', ''),
(405, '2025-09-06 10:25:03', 'klien', 0, 145000, 145000, 0, 0, '', 'cash', ''),
(406, '2025-09-06 10:26:02', 'dr camelia', 0, 110000, 110000, 0, 0, '', 'cash', ''),
(407, '2025-09-06 10:28:10', 'tante hana gbi', 0, 71000, 71000, 0, 0, '', 'cash', ''),
(408, '2025-09-06 11:57:51', 'bu mei ing utk rekan', 0, 96000, 96000, 0, 0, '', 'cash', ''),
(409, '2025-09-06 11:58:32', 'bu youke apt kmkg', 0, 130000, 130000, 0, 0, '', 'cash', ''),
(410, '2025-09-07 10:51:15', 'tante mimi', 0, 240000, 240000, 0, 0, '', 'cash', ''),
(411, '2025-09-09 07:17:42', 'Ibu Meli JI', 0, 67000, 67000, 0, 0, '', 'cash', ''),
(412, '2025-09-09 10:00:28', 'bu tessa JI', 0, 93000, 93000, 0, 0, '', 'cash', ''),
(413, '2025-09-09 19:01:04', 'Lisa', 0, 123500, 123500, 0, 0, '', 'cash', ''),
(414, '2025-09-10 20:36:26', 'bu tessa', 0, 103500, 103500, 0, 0, '', 'cash', ''),
(415, '2025-09-10 21:07:06', 'bu lieke JI', 0, 78000, 78000, 0, 0, '', 'cash', ''),
(416, '2025-09-10 21:08:00', 'Lisa', 0, 46000, 46000, 0, 0, '', 'cash', ''),
(417, '2025-09-12 08:41:18', 'dr natalia ', 0, 176000, 176000, 0, 0, '', 'cash', ''),
(418, '2025-09-12 08:42:34', 'Lisa', 0, 141500, 141500, 0, 0, '', 'cash', ''),
(419, '2025-09-12 12:02:42', 'walk in', 0, 48000, 48000, 0, 0, '', 'cash', ''),
(420, '2025-09-12 12:03:49', 'klien po', 0, 32000, 32000, 0, 0, '', 'cash', ''),
(421, '2025-09-13 09:15:30', 'bu lieke JI', 0, 106000, 106000, 0, 0, '', 'cash', ''),
(422, '2025-09-11 09:17:41', 'PO GBI mimi 100roti', 0, 650000, 650000, 0, 0, '', 'cash', 'Cash'),
(423, '2025-09-13 09:20:20', 'test1', 0, 0, 0, 0, 0, '', 'cash', 'Cash'),
(424, '2025-09-13 12:02:41', 'eko', 0, 25000, 25000, 0, 0, '', 'cash', ''),
(425, '2025-09-14 09:37:48', 'rita ', 0, 100000, 100000, 0, 0, '', 'cash', ''),
(426, '2025-09-14 09:39:45', 'PO', 0, 350000, 350000, 0, 0, '', 'cash', ''),
(427, '2025-09-14 12:23:01', 'Ibu Yuni', 0, 146000, 146000, 0, 0, '', 'transfer', ''),
(429, '2025-09-14 17:54:51', 'Elfrifa', 1, 82000, 82000, 0, 0, '', 'transfer', ''),
(430, '2025-09-14 17:57:00', 'KMKI KAJ', 0, 375000, 375000, 0, 0, '', 'transfer', ''),
(431, '2025-09-14 18:20:03', 'Shearly', 0, 746000, 838000, 0, 92000, 'ongkos kirim 4x14.000, 3x12000 = 92000', 'transfer', 'Transfer'),
(432, '2025-09-14 18:25:23', 'Ibu Mimi', 1, 234500, 234500, 0, 0, '', 'transfer', ''),
(433, '2025-09-14 18:26:51', 'dr. Camelia', 0, 110000, 110000, 0, 0, '', 'transfer', ''),
(434, '2025-09-16 07:43:41', 'walkin pm rusmin ', 0, 43000, 43000, 0, 0, '', 'cash', 'Cash'),
(435, '2025-09-16 08:17:25', 'lisa', 0, 60000, 60000, 0, 0, '', 'cash', ''),
(436, '2025-09-16 10:04:14', 'dr mariana', 0, 99000, 99000, 0, 0, '', 'cash', ''),
(437, '2025-09-17 09:58:33', 'Silvia n shearly', 0, 84000, 84000, 0, 0, '', 'cash', ''),
(438, '2025-09-17 10:36:12', 'walk in', 0, 24000, 24000, 0, 0, '', 'cash', ''),
(439, '2025-09-17 14:41:02', 'lisa', 0, 83500, 83500, 0, 0, '', 'cash', ''),
(440, '2025-09-20 07:19:31', 'walkin kids', 0, 10000, 10000, 0, 0, '', 'cash', ''),
(441, '2025-09-20 07:43:49', 'walkin ', 0, 36000, 36000, 0, 0, '', 'cash', ''),
(442, '2025-09-20 07:44:42', 'walk in', 0, 36000, 36000, 0, 0, '', 'cash', ''),
(443, '2025-09-20 07:45:47', 'walkin pastri gopay', 0, 108000, 108000, 0, 0, 'qris', 'cash', 'Transfer'),
(444, '2025-09-20 08:28:30', 'walk in ', 0, 49500, 49500, 0, 0, 'QRIS', 'cash', 'Transfer'),
(445, '2025-09-20 08:31:12', 'walkin', 0, 32000, 32000, 0, 0, '', 'cash', ''),
(446, '2025-09-20 08:34:46', 'walkin', 0, 26000, 26000, 0, 0, 'QRIS', 'cash', 'Transfer'),
(447, '2025-09-20 08:35:38', '', 0, 56500, 56500, 0, 0, '', 'cash', ''),
(448, '2025-09-20 08:38:46', 'walkin ', 0, 34000, 34000, 0, 0, 'qris', 'cash', 'Transfer'),
(449, '2025-09-20 09:16:07', 'Dr camelia', 0, 52000, 52000, 0, 0, 'QRIS', 'transfer', 'Transfer'),
(450, '2025-09-20 09:42:26', 'Cust. Walk in', 0, 20000, 20000, 0, 0, 'Qris', 'transfer', 'Transfer'),
(451, '2025-09-20 10:00:23', 'walkin ', 0, 56000, 56000, 0, 0, '', 'cash', ''),
(452, '2025-09-20 10:12:29', 'felix', 0, 100000, 100000, 0, 0, 'QRIS', 'cash', 'Transfer'),
(453, '2025-09-20 10:13:45', 'pka. carol', 0, 49500, 49500, 0, 0, 'qris. peach n mango', 'cash', 'Transfer'),
(454, '2025-09-20 10:43:05', 'walkin cengkir', 0, 27500, 27500, 0, 0, 'QRIS peach ', 'cash', 'Transfer'),
(455, '2025-09-20 10:48:30', 'walkin repeat fam', 0, 61000, 61000, 0, 0, 'qris ', 'cash', 'Transfer'),
(456, '2025-09-20 11:04:58', 'pak carol repeat', 0, 38000, 38000, 0, 0, 'qris', 'cash', 'Transfer'),
(457, '2025-09-20 11:05:18', 'walkin gading elok', 0, 65500, 65500, 0, 0, 'qris', 'cash', 'Transfer'),
(458, '2025-09-20 11:14:11', 'pak carol istri ', 0, 38000, 38000, 0, 0, 'QRIS', 'cash', 'Transfer'),
(459, '2025-09-20 11:24:21', 'Tmn mama', 0, 20000, 20000, 0, 0, 'QRIS', 'cash', 'Transfer'),
(460, '2025-09-20 11:25:13', 'walkin merah', 0, 45000, 45000, 0, 0, 'QRIS', 'cash', 'Transfer'),
(461, '2025-09-20 11:25:56', 'Drg tin', 0, 100000, 100000, 0, 0, '', 'cash', 'Cash'),
(462, '2025-09-20 11:32:36', 'walkin kulintang', 0, 15000, 15000, 0, 0, '', 'cash', ''),
(463, '2025-09-20 11:33:28', 'Tmn mama', 0, 45000, 45000, 0, 0, 'QRIS', 'transfer', 'Transfer'),
(464, '2025-09-20 11:34:05', 'walkin kulintang', 0, 72000, 72000, 0, 0, '', 'cash', ''),
(465, '2025-09-20 12:34:30', 'Cust. Walk in', 0, 59000, 59000, 0, 0, 'QRIS', 'cash', 'Transfer'),
(466, '2025-09-20 13:00:14', 'Cust. Walk in', 0, 62000, 62000, 0, 0, 'QRIS', 'cash', 'Transfer'),
(467, '2025-09-20 14:49:51', 'walkin', 0, 15000, 15000, 0, 0, 'qris', 'cash', ''),
(468, '2025-09-20 15:10:14', 'shierly JI kath', 0, 56000, 56000, 0, 0, 'transfer KATH', 'cash', 'Transfer'),
(469, '2025-09-20 15:19:04', 'Mama', 0, 679000, 679000, 0, 0, 'transfer KATH', 'cash', 'Transfer'),
(470, '2025-09-20 15:36:20', 'Cust. Walk in', 0, 10000, 10000, 0, 0, 'QRIS , 13:55 pVSAID', 'transfer', 'Transfer'),
(471, '2025-09-20 15:36:38', 'Cust. Walk in', 0, 10000, 10000, 0, 0, 'QRIS,13:55 5PxsID', 'transfer', 'Transfer'),
(472, '2025-09-20 15:39:11', 'Cust. Walk in', 0, 23000, 23000, 0, 0, 'QRIS - 14:48 KMnSID 23rb', 'transfer', 'Transfer'),
(473, '2025-09-20 16:22:21', 'Shearly Elisa', 0, 73000, 73000, 0, 0, 'transfer KATH', 'transfer', 'Transfer'),
(474, '2025-09-20 16:47:44', 'Andre 1', 0, 97000, 97000, 0, 0, 'transfer MA ', 'cash', 'Transfer'),
(475, '2025-09-20 16:49:06', 'Andre 2', 0, 97000, 97000, 0, 0, 'transfer MA ', 'cash', 'Transfer'),
(476, '2025-09-20 16:54:10', 'Andre 3', 0, 97000, 97000, 0, 0, 'transfer MA ', 'cash', 'Transfer'),
(477, '2025-09-20 17:04:04', 'Bu Silvi - Lumpia - Cust. Walk in', 0, 68000, 68000, 0, 0, 'QRIS', 'transfer', 'Transfer'),
(478, '2025-09-20 17:06:34', 'walkin temen bu silvi', 0, 90000, 90000, 0, 0, '', 'cash', 'Cash'),
(479, '2025-09-22 19:06:30', 'ibu mimi', 1, 227500, 227500, 0, 0, '', 'transfer', ''),
(480, '2025-09-23 08:42:06', 'dr mariana JI', 0, 84000, 84000, 0, 0, '', 'cash', ''),
(481, '2025-09-23 11:08:10', 'lisa', 0, 103500, 103500, 0, 0, '', 'cash', ''),
(482, '2025-09-23 11:21:06', 'walkin - ibu2', 0, 37500, 37500, 0, 0, '', 'cash', ''),
(483, '2025-09-23 11:22:26', 'PO', 0, 101000, 101000, 0, 0, '', 'cash', ''),
(484, '2025-09-24 07:56:20', 'pak yohanes JI', 0, 29000, 29000, 0, 0, '', 'cash', ''),
(485, '2025-09-24 08:57:31', 'Lisa', 0, 138000, 138000, 0, 0, '', 'cash', ''),
(486, '2025-09-24 13:38:34', 'walkin', 0, 18000, 18000, 0, 0, '', 'cash', ''),
(487, '2025-09-25 23:59:45', 'Bu Meli JI', 0, 40000, 40000, 0, 0, '', 'cash', 'Cash'),
(488, '2025-09-25 23:59:54', 'Lisa', 0, 36000, 36000, 0, 0, '', 'cash', 'Cash'),
(490, '2025-09-25 23:59:55', 'Bu Felicia PO', 0, 206000, 206000, 0, 0, '', 'cash', 'Transfer'),
(491, '2025-09-25 23:59:56', '1234', 0, 0, 0, 0, 0, '', 'cash', 'Cash'),
(492, '2025-09-26 10:24:18', 'Cust. Walk in', 0, 15000, 15000, 0, 0, '', 'cash', ''),
(493, '2025-09-26 10:24:56', 'Cust. Walk in', 0, 55000, 55000, 0, 0, '', 'cash', ''),
(494, '2025-09-26 10:30:11', 'Cust. Walk in', 0, 42500, 42500, 0, 0, '', 'cash', ''),
(495, '2025-09-26 10:30:55', 'Bu Mely', 0, 70000, 70000, 0, 0, '', 'cash', 'Cash'),
(496, '2025-09-26 10:32:52', 'Cust. Walk in', 0, 27000, 27000, 0, 0, '', 'cash', ''),
(497, '2025-09-26 19:38:48', 'lisa', 0, 64000, 64000, 0, 0, '', 'cash', ''),
(498, '2025-09-26 19:54:19', 'Andre 1', 0, 81000, 81000, 0, 0, '', 'cash', ''),
(499, '2025-09-26 22:24:20', 'bu yuni aurelia ', 0, 300000, 300000, 0, 0, '', 'cash', ''),
(500, '2025-09-26 23:06:30', 'bu dr  mariana JI', 0, 220000, 220000, 0, 0, '', 'cash', ''),
(501, '2025-09-27 09:18:44', 'walkin ', 0, 14000, 14000, 0, 0, '', 'cash', ''),
(502, '2025-09-27 13:00:15', 'Shearly JI Katj', 0, 311000, 311000, 0, 0, '', 'pending', 'Pending'),
(503, '2025-09-27 15:41:52', 'Lisa', 0, 91500, 91500, 0, 0, '', 'cash', 'Cash'),
(504, '2025-09-30 09:50:49', 'Lisa', 0, 147000, 147000, 0, 0, '', 'cash', ''),
(505, '2025-09-30 09:53:44', 'bu meli JI', 0, 98000, 98000, 0, 0, '', 'cash', ''),
(506, '2025-09-30 09:56:41', 'wlakin puskesmas ', 0, 61000, 61000, 0, 0, 'QRIS ', 'cash', 'Transfer'),
(507, '2025-09-30 21:09:11', 'po', 0, 100000, 100000, 0, 0, '', 'cash', ''),
(508, '2025-10-01 01:10:31', 'PKBM St. Aurelia', 0, 84000, 84000, 0, 0, '', 'cash', ''),
(509, '2025-10-01 08:53:59', 'pak rusmin ', 0, 93000, 93000, 0, 0, '', 'cash', ''),
(510, '2025-10-01 08:59:22', 'bu lieke JI', 0, 97000, 97000, 0, 0, '', 'cash', ''),
(511, '2025-10-01 09:02:04', 'pak. dicky - Klp gdg ', 0, 39000, 39000, 0, 0, '', 'cash', ''),
(512, '2025-10-01 09:05:51', 'Lisa ', 0, 130000, 130000, 0, 0, '', 'cash', 'Cash'),
(513, '2025-10-01 13:29:04', 'rita mama ', 0, 76000, 76000, 0, 0, '', 'cash', ''),
(515, '2025-10-01 19:24:20', 'ibu mimi', 1, 156500, 156500, 0, 0, '', 'transfer', ''),
(516, '2025-10-03 09:37:17', 'bu lieke JI', 0, 52000, 52000, 0, 0, '', 'cash', ''),
(517, '2025-10-03 18:49:20', 'Lisa', 0, 76000, 76000, 0, 0, '', 'cash', ''),
(518, '2025-10-03 18:50:40', 'By Mona', 0, 44000, 44000, 0, 0, '', 'cash', ''),
(519, '2025-10-03 18:51:40', 'Bu Youke', 0, 67000, 67000, 0, 0, '', 'cash', ''),
(520, '2025-10-04 09:33:34', ' Janur Elok', 0, 121000, 121000, 0, 0, '', 'cash', 'Pending'),
(521, '2025-10-04 10:19:47', 'PO', 0, 48000, 48000, 0, 0, '', 'cash', ''),
(522, '2025-10-04 10:28:50', 'bu Mona JI1', 0, 40000, 40000, 0, 0, '', 'cash', ''),
(523, '2025-10-04 10:31:03', 'Lisa Lala', 0, 152000, 152000, 0, 0, '', 'cash', ''),
(524, '2025-10-04 10:54:14', 'Bu Youke ', 0, 40000, 40000, 0, 0, '', 'cash', ''),
(525, '2025-10-04 11:50:08', 'bu Nancy JI', 0, 50000, 50000, 0, 0, '', 'cash', ''),
(527, '2025-10-07 08:16:07', 'Dr Camelia', 0, 115000, 115000, 0, 0, 'tranf kath', 'transfer', 'Transfer'),
(528, '2025-10-07 09:54:01', 'walkin MOi', 0, 49500, 49500, 0, 0, 'QRIS Kath', 'cash', 'Transfer'),
(529, '2025-10-07 09:54:48', 'walkin bpk Triputra JI', 0, 7000, 7000, 0, 0, '', 'cash', ''),
(530, '2025-10-07 15:35:25', 'Ci Elisa', 0, 68000, 68000, 0, 0, 'Note : rice bowl chicken donburi porsian tanpa nasi . trasnf kath', 'transfer', 'Transfer'),
(531, '2025-10-07 15:43:07', 'lisa', 0, 103500, 103500, 0, 0, '', 'cash', ''),
(533, '2025-10-08 11:04:52', 'walkin bu Martina wgp', 0, 62000, 62000, 0, 0, '', 'cash', ''),
(534, '2025-10-08 11:06:55', 'Lisa ', 0, 80000, 80000, 0, 0, '', 'cash', ''),
(535, '2025-10-08 11:34:57', 'PO macaroni', 0, 180000, 180000, 0, 0, '', 'cash', ''),
(536, '2025-10-08 15:06:31', 'Ci elisa', 0, 72000, 72000, 0, 0, 'Rice bowl Lemongrass Chicken porsian (tanpa nasi)', 'transfer', 'Pending'),
(537, '2025-10-08 19:34:48', 'bu mariana', 0, 81000, 81000, 0, 0, '', 'cash', ''),
(538, '2025-10-08 19:37:12', 'bu lieke JI', 0, 32000, 32000, 0, 0, '', 'cash', ''),
(539, '2025-10-10 23:26:42', 'walkin', 0, 20000, 20000, 0, 0, '', 'cash', 'qris '),
(540, '2025-10-10 23:36:56', 'lisa', 0, 80000, 80000, 0, 0, '', 'cash', ''),
(541, '2025-10-11 11:11:06', 'walkin JI', 0, 25000, 25000, 0, 0, '', 'cash', 'Cash'),
(542, '2025-10-11 11:41:02', 'lisa', 0, 152000, 152000, 0, 0, '', 'cash', ''),
(543, '2025-10-11 11:42:08', 'walkin JI', 0, 44000, 44000, 0, 0, '', 'cash', ''),
(544, '2025-10-12 07:54:33', 'mariana ', 0, 180000, 180000, 0, 0, '', 'cash', ''),
(545, '2025-10-14 08:00:48', 'bu meli JI', 0, 40000, 40000, 0, 0, '', 'cash', 'Cash'),
(547, '2025-10-14 08:01:52', 'bu po JI', 0, 72000, 72000, 0, 0, '', 'cash', 'Cash'),
(548, '2025-10-14 08:56:29', 'bu walkin', 0, 162500, 162500, 0, 0, 'QRIS', 'cash', 'Transfer'),
(551, '2025-10-17 09:20:36', 'walk in qris', 0, 40000, 40000, 0, 0, '', 'pending', 'QRIS'),
(552, '2025-10-17 09:22:38', 'bu meli JI', 0, 57000, 57000, 0, 0, '', 'cash', ''),
(553, '2025-10-17 09:28:49', 'walkin puskemas', 0, 38000, 38000, 0, 0, '', 'cash', ''),
(554, '2025-10-17 09:31:30', 'lisa', 0, 122000, 122000, 0, 0, '', 'cash', ''),
(555, '2025-10-18 08:11:36', 'walkin JI', 0, 20000, 20000, 0, 0, '', 'cash', ''),
(557, '2025-10-18 10:16:11', 'Bu Youke', 0, 113500, 113500, 0, 0, '', 'cash', ''),
(558, '2025-10-18 10:21:39', 'lisa', 0, 88000, 88000, 0, 0, '', 'cash', ''),
(559, '2025-10-18 12:38:51', 'bu mariana', 0, 76000, 76000, 0, 0, '', 'cash', ''),
(560, '2025-10-18 12:42:57', 'pak rusmin', 0, 142000, 142000, 0, 0, '', 'cash', ''),
(561, '2025-10-22 08:14:26', 'Selasa 21 Transaksi Walk In', 0, 63000, 63000, 0, 0, '', 'cash', ''),
(562, '2025-10-22 08:15:03', 'bu Meli JI PO', 0, 84000, 84000, 0, 0, '', 'cash', ''),
(563, '2025-10-22 11:39:34', 'Bu Meli ', 0, 17000, 17000, 0, 0, '', 'cash', ''),
(564, '2025-10-22 14:56:08', 'ibu mimi ', 1, 1413500, 1413500, 0, 0, '', 'transfer', ''),
(565, '2025-10-24 08:02:06', 'Gracia (Mama Klay)', 0, 63000, 63000, 0, 0, '', 'transfer', ''),
(566, '2025-10-24 09:22:24', 'Bu meli ji', 0, 33000, 33000, 0, 0, '', 'cash', ''),
(567, '2025-10-24 09:24:10', 'PO', 0, 54000, 54000, 0, 0, '', 'cash', ''),
(568, '2025-10-24 13:50:02', 'Lisa', 0, 82000, 82000, 0, 0, '', 'cash', ''),
(570, '2025-10-25 09:12:47', 'eko JI', 0, 91000, 91000, 0, 0, '', 'cash', 'Cash'),
(571, '2025-10-25 09:14:01', 'bu Nanci JI ', 0, 20000, 20000, 0, 0, '', 'cash', ''),
(572, '2025-10-25 09:54:39', 'pak. rusmin', 0, 63000, 63000, 0, 0, '', 'cash', ''),
(573, '2025-10-31 09:36:04', 'meli JI', 0, 40000, 40000, 0, 0, '', 'cash', ''),
(574, '2025-10-31 09:37:59', 'Lieke JI', 0, 80000, 80000, 0, 0, '', 'cash', ''),
(575, '2025-10-31 12:41:23', 'bu youke KMKG', 0, 39000, 39000, 0, 0, '', 'cash', ''),
(576, '2025-10-31 12:45:11', 'tante siane', 0, 14000, 14000, 0, 0, '', 'cash', ''),
(577, '2025-10-31 12:48:19', 'bu mariana ', 0, 22000, 22000, 0, 0, '', 'cash', ''),
(578, '2025-11-01 09:33:34', 'tante liana walkin', 0, 64000, 64000, 0, 0, '', 'cash', ''),
(579, '2025-11-01 09:34:15', 'bu diani gdg rsdnce', 0, 40000, 40000, 0, 0, '', 'cash', ''),
(580, '2025-11-01 09:35:41', 'Lisa', 0, 57000, 57000, 0, 0, '', 'cash', 'Cash'),
(581, '2025-11-01 10:56:05', 'Lisa 2', 0, 60000, 60000, 0, 0, '', 'cash', ''),
(582, '2025-11-01 18:07:43', 'bu tessa', 0, 37500, 37500, 0, 0, '', 'cash', ''),
(583, '2025-11-04 09:53:35', 'bu lieke', 0, 52000, 52000, 0, 0, '', 'cash', ''),
(584, '2025-11-04 09:54:39', 'dr mariana JI', 0, 55000, 55000, 0, 0, '', 'cash', ''),
(585, '2025-11-04 09:55:04', 'walkin', 0, 52000, 52000, 0, 0, '', 'cash', ''),
(586, '2025-11-04 18:59:41', 'lisa', 0, 45000, 45000, 0, 0, '', 'cash', ''),
(587, '2025-11-05 09:09:37', 'bu meli', 0, 57000, 57000, 0, 0, '', 'cash', ''),
(588, '2025-11-05 09:10:07', 'walkin pskms pasien', 0, 17000, 17000, 0, 0, '', 'cash', ''),
(589, '2025-11-05 12:06:18', 'walkin', 0, 20000, 20000, 0, 0, '', 'cash', ''),
(590, '2025-11-07 09:48:27', 'walkin pskms', 0, 12000, 12000, 0, 0, '', 'cash', ''),
(591, '2025-11-07 09:49:23', 'bu sitta JI', 0, 51000, 51000, 0, 0, '', 'cash', ''),
(592, '2025-11-07 10:37:54', 'Lisa', 0, 72000, 72000, 0, 0, '', 'cash', ''),
(593, '2025-11-08 08:57:09', 'Walkin', 0, 92000, 92000, 0, 0, '', 'cash', 'Cash'),
(594, '2025-11-08 09:17:47', 'Lisa', 0, 89500, 89500, 0, 0, '', 'cash', ''),
(595, '2025-11-08 09:45:58', 'bu mariana ', 0, 30000, 30000, 0, 0, '', 'cash', ''),
(596, '2025-11-08 12:21:20', 'Ci Elisa', 0, 82000, 96000, 0, 14000, '', 'transfer', ''),
(597, '2025-11-11 07:26:19', 'Bpk rusmin', 0, 198000, 197000, 1000, 0, '', 'cash', ''),
(598, '2025-11-11 07:27:41', 'Walking jumat pagi ketinggalan', 0, 20000, 20000, 0, 0, '', 'cash', ''),
(600, '2025-11-11 10:56:10', 'bu youke ', 0, 62000, 62000, 0, 0, '', 'cash', ''),
(601, '2025-11-11 13:56:46', 'Michael ', 0, 79000, 79000, 0, 0, '', 'cash', '');

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

--
-- Table structure for table `sales_items`
--

CREATE TABLE `sales_items` (
  `id` int NOT NULL,
  `sales_id` int NOT NULL,
  `product_id` int NOT NULL,
  `quantity` int NOT NULL,
  `price_each` decimal(10,2) NOT NULL,
  `discount` int DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `sales_items`
--

INSERT INTO `sales_items` (`id`, `sales_id`, `product_id`, `quantity`, `price_each`, `discount`) VALUES
(17, 29, 54, 10, 50000.00, 0),
(18, 29, 53, 4, 45000.00, 0),
(23, 34, 26, 1, 20000.00, 0),
(24, 34, 21, 1, 13000.00, 0),
(25, 34, 23, 1, 13000.00, 0),
(26, 34, 14, 1, 10000.00, 0),
(27, 34, 20, 1, 13000.00, 0),
(28, 34, 5, 1, 9000.00, 0),
(29, 34, 7, 1, 9000.00, 0),
(30, 34, 6, 1, 10000.00, 0),
(31, 34, 15, 1, 10000.00, 0),
(32, 34, 22, 1, 13000.00, 0),
(35, 36, 26, 1, 20000.00, 0),
(36, 36, 25, 1, 12000.00, 0),
(37, 36, 5, 2, 9000.00, 0),
(38, 36, 10, 2, 8000.00, 0),
(71, 45, 20, 2, 13000.00, 0),
(72, 45, 22, 1, 13000.00, 0),
(73, 45, 5, 1, 9000.00, 0),
(74, 45, 15, 1, 10000.00, 0),
(75, 45, 18, 1, 10000.00, 0),
(76, 45, 26, 1, 20000.00, 0),
(77, 45, 32, 1, 16000.00, 0),
(78, 45, 14, 1, 10000.00, 0),
(79, 45, 8, 1, 7000.00, 0),
(80, 45, 10, 1, 8000.00, 0),
(81, 45, 12, 1, 9000.00, 0),
(82, 45, 21, 1, 13000.00, 0),
(221, 50, 45, 1, 20000.00, 0),
(224, 35, 8, 36, 7000.00, 0),
(225, 35, 9, 24, 7000.00, 0),
(250, 47, 6, 1, 10000.00, 0),
(251, 47, 26, 1, 20000.00, 0),
(461, 49, 20, 1, 13000.00, 0),
(462, 49, 26, 1, 20000.00, 0),
(463, 49, 32, 1, 16000.00, 0),
(464, 49, 5, 1, 9000.00, 0),
(465, 49, 16, 1, 10000.00, 0),
(466, 49, 8, 1, 7000.00, 0),
(467, 49, 12, 1, 9000.00, 0),
(468, 49, 9, 1, 7000.00, 0),
(469, 49, 10, 2, 8000.00, 0),
(470, 49, 19, 1, 8000.00, 0),
(471, 49, 7, 1, 9000.00, 0),
(481, 56, 1, 3, 35000.00, 0),
(482, 56, 4, 10, 70000.00, 0),
(483, 54, 5, 4, 9000.00, 0),
(484, 54, 6, 2, 10000.00, 0),
(485, 54, 10, 2, 8000.00, 0),
(486, 54, 9, 1, 7000.00, 0),
(487, 53, 27, 1, 140000.00, 0),
(489, 57, 59, 20, 8000.00, 0),
(514, 59, 23, 1, 11700.00, 0),
(550, 81, 23, 2, 11700.00, 1000),
(551, 81, 22, 2, 11700.00, 1000),
(552, 81, 63, 1, 50000.00, 5000),
(553, 81, 61, 1, 55000.00, 5000),
(554, 81, 5, 1, 8500.00, 0),
(555, 81, 7, 1, 8500.00, 0),
(556, 81, 6, 1, 9500.00, 0),
(557, 81, 15, 1, 9500.00, 0),
(558, 82, 22, 1, 13000.00, 0),
(559, 82, 8, 3, 7000.00, 0),
(560, 82, 10, 1, 8000.00, 0),
(561, 82, 7, 1, 9000.00, 0),
(562, 82, 12, 1, 9000.00, 0),
(563, 82, 16, 1, 10000.00, 0),
(564, 82, 13, 1, 10000.00, 0),
(565, 83, 26, 4, 20000.00, 0),
(566, 83, 20, 2, 13000.00, 0),
(567, 83, 21, 1, 13000.00, 0),
(568, 83, 23, 2, 13000.00, 0),
(569, 83, 22, 1, 13000.00, 0),
(570, 83, 15, 1, 10000.00, 0),
(571, 83, 6, 1, 10000.00, 0),
(572, 83, 8, 2, 7000.00, 0),
(573, 83, 16, 1, 10000.00, 0),
(574, 83, 18, 1, 10000.00, 0),
(575, 84, 26, 1, 20000.00, 0),
(577, 84, 21, 1, 13000.00, 0),
(579, 84, 21, 1, 13000.00, 0),
(581, 84, 22, 1, 13000.00, 0),
(582, 84, 23, 1, 13000.00, 0),
(584, 84, 5, 1, 9000.00, 0),
(586, 84, 9, 1, 7000.00, 0),
(587, 84, 14, 1, 10000.00, 0),
(590, 84, 66, 1, 10000.00, 0),
(591, 84, 65, 1, 9000.00, 0),
(656, 58, 22, 2, 13000.00, 0),
(657, 58, 23, 1, 13000.00, 0),
(658, 58, 16, 2, 10000.00, 0),
(659, 58, 19, 1, 8000.00, 0),
(660, 58, 5, 2, 9000.00, 0),
(661, 58, 26, 1, 20000.00, 0),
(662, 58, 12, 1, 9000.00, 0),
(663, 58, 14, 1, 10000.00, 0),
(664, 58, 9, 1, 7000.00, 0),
(665, 58, 13, 1, 10000.00, 0),
(666, 58, 10, 3, 8000.00, 0),
(667, 58, 7, 1, 9000.00, 0),
(668, 87, 26, 2, 20000.00, 0),
(669, 87, 15, 1, 10000.00, 0),
(670, 87, 5, 1, 9000.00, 0),
(671, 87, 10, 1, 8000.00, 0),
(672, 87, 18, 1, 10000.00, 0),
(673, 87, 70, 1, 10000.00, 0),
(674, 88, 39, 1, 98000.00, 0),
(675, 89, 5, 7, 9000.00, 0),
(676, 90, 5, 2, 9000.00, 0),
(677, 91, 32, 1, 16000.00, 0),
(678, 92, 13, 1, 10000.00, 0),
(679, 92, 10, 1, 8000.00, 0),
(680, 92, 26, 1, 20000.00, 0),
(681, 92, 12, 2, 9000.00, 0),
(682, 92, 22, 2, 13000.00, 0),
(683, 92, 23, 2, 13000.00, 0),
(684, 93, 8, 42, 7000.00, 0),
(685, 93, 5, 6, 9000.00, 0),
(686, 94, 71, 1, 92000.00, 0),
(704, 96, 6, 1, 10000.00, 0),
(705, 96, 7, 1, 9000.00, 0),
(706, 96, 14, 1, 10000.00, 0),
(707, 96, 12, 1, 9000.00, 0),
(708, 96, 18, 1, 10000.00, 0),
(709, 96, 15, 1, 10000.00, 0),
(710, 96, 5, 1, 9000.00, 0),
(711, 96, 10, 1, 8000.00, 0),
(712, 96, 8, 1, 7000.00, 0),
(713, 96, 9, 2, 7000.00, 0),
(714, 96, 22, 1, 13000.00, 0),
(715, 96, 23, 1, 13000.00, 0),
(743, 97, 26, 4, 20000.00, 0),
(744, 97, 22, 5, 13000.00, 0),
(754, 95, 8, 1, 7000.00, 0),
(755, 95, 6, 1, 10000.00, 0),
(756, 95, 9, 1, 7000.00, 0),
(757, 95, 22, 1, 13000.00, 0),
(758, 95, 23, 1, 13000.00, 0),
(759, 95, 20, 1, 13000.00, 0),
(760, 95, 21, 1, 13000.00, 0),
(761, 95, 71, 1, 92000.00, 0),
(762, 95, 75, 1, 13000.00, 0),
(811, 104, 26, 3, 20000.00, 0),
(812, 104, 58, 1, 30000.00, 0),
(813, 104, 6, 1, 10000.00, 0),
(814, 104, 12, 1, 9000.00, 0),
(815, 104, 22, 2, 13000.00, 0),
(816, 104, 23, 2, 13000.00, 0),
(817, 105, 76, 1, 15000.00, 0),
(818, 105, 8, 2, 7000.00, 0),
(819, 105, 13, 1, 10000.00, 0),
(820, 105, 14, 1, 10000.00, 0),
(821, 105, 20, 1, 13000.00, 0),
(822, 105, 16, 1, 10000.00, 0),
(823, 105, 70, 1, 10000.00, 0),
(824, 106, 8, 60, 7000.00, 0),
(825, 106, 9, 20, 7000.00, 0),
(826, 107, 13, 1, 10000.00, 0),
(827, 107, 5, 1, 9000.00, 0),
(828, 107, 15, 1, 10000.00, 0),
(829, 107, 11, 1, 7000.00, 0),
(830, 107, 12, 1, 9000.00, 0),
(831, 108, 8, 2, 7000.00, 0),
(832, 108, 6, 2, 10000.00, 0),
(833, 108, 10, 2, 8000.00, 0),
(834, 108, 15, 1, 10000.00, 0),
(835, 108, 31, 1, 16000.00, 0),
(836, 108, 15, 2, 10000.00, 0),
(837, 108, 6, 2, 10000.00, 0),
(838, 108, 8, 2, 7000.00, 0),
(839, 108, 10, 2, 8000.00, 0),
(840, 108, 22, 1, 13000.00, 0),
(841, 108, 23, 1, 13000.00, 0),
(842, 108, 8, 1, 7000.00, 0),
(843, 108, 6, 1, 10000.00, 0),
(844, 108, 9, 1, 7000.00, 0),
(845, 108, 23, 1, 13000.00, 0),
(846, 108, 75, 2, 13000.00, 0),
(847, 109, 26, 2, 20000.00, 0),
(848, 109, 31, 1, 16000.00, 0),
(849, 109, 32, 1, 16000.00, 0),
(850, 109, 10, 1, 8000.00, 0),
(851, 109, 5, 1, 9000.00, 0),
(862, 110, 46, 2, 20000.00, 0),
(863, 110, 20, 1, 13000.00, 0),
(864, 110, 22, 2, 13000.00, 0),
(865, 110, 23, 1, 13000.00, 0),
(866, 110, 75, 1, 13000.00, 0),
(867, 110, 10, 1, 8000.00, 0),
(868, 110, 5, 1, 9000.00, 0),
(869, 110, 11, 1, 7000.00, 0),
(870, 110, 9, 1, 7000.00, 0),
(871, 110, 8, 2, 7000.00, 0),
(872, 110, 16, 1, 10000.00, 0),
(873, 111, 39, 1, 98000.00, 0),
(874, 111, 27, 1, 140000.00, 0),
(875, 111, 5, 1, 9000.00, 0),
(876, 111, 12, 1, 9000.00, 0),
(883, 113, 5, 1, 9000.00, 0),
(884, 113, 10, 1, 8000.00, 0),
(885, 114, 26, 1, 20000.00, 0),
(886, 114, 20, 1, 13000.00, 0),
(887, 114, 15, 1, 10000.00, 0),
(888, 114, 6, 1, 10000.00, 0),
(889, 114, 10, 1, 8000.00, 0),
(890, 115, 11, 3, 7000.00, 0),
(891, 115, 16, 1, 10000.00, 0),
(892, 116, 8, 1, 7000.00, 0),
(893, 116, 9, 1, 7000.00, 0),
(894, 117, 78, 10, 5500.00, 0),
(895, 103, 9, 1, 7000.00, 0),
(896, 103, 15, 1, 10000.00, 0),
(897, 103, 10, 1, 8000.00, 0),
(898, 103, 7, 1, 9000.00, 0),
(899, 103, 12, 1, 9000.00, 0),
(900, 103, 16, 1, 10000.00, 0),
(901, 103, 18, 1, 10000.00, 0),
(902, 103, 5, 1, 9000.00, 0),
(903, 112, 11, 4, 7000.00, 0),
(904, 112, 5, 4, 9000.00, 0),
(905, 112, 8, 4, 7000.00, 0),
(906, 112, 10, 4, 8000.00, 0),
(907, 112, 16, 4, 10000.00, 0),
(908, 112, 12, 2, 9000.00, 0),
(909, 118, 1, 1, 35000.00, 0),
(910, 118, 5, 1, 9000.00, 0),
(911, 118, 13, 1, 10000.00, 0),
(912, 118, 22, 1, 13000.00, 0),
(913, 118, 23, 1, 13000.00, 0),
(914, 119, 8, 2, 7000.00, 0),
(915, 119, 9, 2, 7000.00, 0),
(916, 119, 11, 2, 7000.00, 0),
(917, 119, 6, 2, 10000.00, 0),
(947, 123, 1, 1, 35000.00, 0),
(948, 124, 26, 1, 20000.00, 0),
(949, 124, 10, 2, 8000.00, 0),
(950, 125, 26, 1, 20000.00, 0),
(951, 125, 12, 1, 9000.00, 0),
(952, 126, 32, 1, 16000.00, 0),
(953, 126, 12, 1, 9000.00, 0),
(954, 120, 15, 1, 10000.00, 0),
(955, 120, 70, 1, 10000.00, 0),
(956, 120, 9, 1, 7000.00, 0),
(957, 120, 8, 1, 7000.00, 0),
(958, 120, 10, 1, 8000.00, 0),
(959, 120, 16, 1, 10000.00, 0),
(960, 120, 6, 1, 10000.00, 0),
(961, 120, 5, 1, 9000.00, 0),
(962, 120, 11, 1, 7000.00, 0),
(963, 120, 7, 1, 9000.00, 0),
(964, 120, 12, 1, 9000.00, 0),
(965, 122, 26, 1, 20000.00, 0),
(966, 122, 8, 2, 7000.00, 0),
(967, 122, 9, 1, 7000.00, 0),
(968, 122, 16, 1, 10000.00, 0),
(969, 122, 14, 1, 10000.00, 0),
(970, 122, 18, 1, 10000.00, 0),
(971, 127, 82, 1, 9000.00, 0),
(972, 128, 5, 1, 9000.00, 0),
(973, 128, 81, 1, 10000.00, 0),
(974, 128, 16, 1, 10000.00, 0),
(975, 128, 6, 1, 10000.00, 0),
(976, 129, 26, 1, 20000.00, 0),
(977, 129, 28, 1, 7000.00, 0),
(978, 129, 49, 1, 32000.00, 0),
(979, 130, 28, 1, 7000.00, 0),
(980, 130, 32, 1, 16000.00, 0),
(981, 131, 45, 1, 20000.00, 0),
(982, 132, 49, 2, 30000.00, 0),
(983, 132, 83, 1, 41000.00, 0),
(984, 132, 84, 3, 25000.00, 0),
(985, 132, 85, 1, 20000.00, 0),
(986, 132, 51, 1, 22000.00, 0),
(987, 133, 26, 2, 20000.00, 0),
(988, 133, 21, 1, 13000.00, 0),
(989, 133, 20, 1, 13000.00, 0),
(990, 133, 23, 3, 13000.00, 0),
(991, 133, 22, 1, 13000.00, 0),
(992, 133, 16, 1, 10000.00, 0),
(993, 133, 5, 1, 9000.00, 0),
(994, 133, 14, 1, 10000.00, 0),
(995, 133, 6, 1, 10000.00, 0),
(996, 133, 7, 1, 9000.00, 0),
(997, 133, 12, 1, 9000.00, 0),
(998, 134, 26, 2, 20000.00, 0),
(999, 134, 15, 2, 10000.00, 0),
(1000, 134, 10, 2, 8000.00, 0),
(1001, 134, 18, 1, 10000.00, 0),
(1002, 134, 31, 1, 16000.00, 0),
(1003, 134, 32, 1, 16000.00, 0),
(1004, 135, 5, 2, 8500.00, 0),
(1005, 135, 10, 1, 7500.00, 0),
(1006, 135, 16, 1, 9500.00, 0),
(1007, 136, 59, 12, 8000.00, 0),
(1008, 137, 86, 1, 125000.00, 0),
(1014, 138, 18, 1, 10000.00, 0),
(1015, 138, 16, 2, 10000.00, 0),
(1016, 138, 11, 1, 7000.00, 0),
(1017, 138, 8, 4, 7000.00, 0),
(1018, 138, 7, 1, 9000.00, 0),
(1019, 138, 81, 1, 10000.00, 0),
(1020, 138, 15, 1, 10000.00, 0),
(1021, 138, 19, 1, 8000.00, 0),
(1022, 139, 32, 2, 16000.00, 0),
(1023, 139, 35, 2, 16000.00, 0),
(1024, 139, 31, 2, 16000.00, 0),
(1025, 139, 10, 2, 8000.00, 0),
(1026, 139, 26, 1, 20000.00, 0),
(1027, 140, 45, 1, 20000.00, 0),
(1028, 140, 46, 1, 20000.00, 0),
(1029, 140, 82, 1, 9000.00, 0),
(1030, 140, 5, 2, 9000.00, 0),
(1031, 140, 32, 1, 16000.00, 0),
(1032, 141, 70, 1, 10000.00, 0),
(1033, 141, 18, 1, 10000.00, 0),
(1034, 142, 13, 1, 10000.00, 0),
(1035, 143, 8, 2, 7000.00, 0),
(1036, 143, 10, 1, 8000.00, 0),
(1037, 143, 15, 1, 10000.00, 0),
(1038, 143, 5, 1, 9000.00, 0),
(1039, 144, 26, 1, 20000.00, 0),
(1040, 144, 6, 2, 10000.00, 0),
(1041, 144, 5, 1, 9000.00, 0),
(1042, 145, 12, 2, 9000.00, 0),
(1043, 145, 16, 2, 10000.00, 0),
(1044, 145, 8, 2, 7000.00, 0),
(1045, 145, 10, 1, 8000.00, 0),
(1046, 145, 11, 1, 7000.00, 0),
(1047, 145, 5, 1, 9000.00, 0),
(1048, 145, 7, 1, 9000.00, 0),
(1049, 146, 81, 1, 10000.00, 0),
(1050, 147, 23, 1, 13000.00, 0),
(1051, 147, 10, 1, 8000.00, 0),
(1052, 148, 45, 1, 20000.00, 0),
(1053, 148, 23, 1, 13000.00, 0),
(1054, 149, 46, 1, 20000.00, 0),
(1056, 151, 58, 12, 8000.00, 0),
(1059, 152, 7, 6, 9000.00, 0),
(1060, 152, 58, 9, 10000.00, 0),
(1061, 153, 5, 7, 8500.00, 0),
(1062, 153, 6, 8, 9500.00, 0),
(1063, 153, 15, 2, 9500.00, 0),
(1064, 154, 8, 18, 7000.00, 0),
(1065, 154, 9, 18, 7000.00, 0),
(1066, 154, 5, 2, 9000.00, 0),
(1067, 154, 16, 2, 10000.00, 0),
(1068, 154, 12, 1, 9000.00, 0),
(1069, 155, 5, 1, 9000.00, 0),
(1073, 156, 11, 1, 7000.00, 0),
(1074, 156, 8, 1, 7000.00, 0),
(1075, 156, 5, 1, 9000.00, 0),
(1076, 156, 82, 2, 10000.00, 0),
(1082, 157, 26, 1, 20000.00, 0),
(1083, 157, 5, 1, 9000.00, 0),
(1084, 157, 15, 1, 10000.00, 0),
(1085, 157, 16, 1, 10000.00, 0),
(1086, 157, 12, 1, 9000.00, 0),
(1087, 158, 26, 1, 20000.00, 0),
(1088, 158, 23, 1, 13000.00, 0),
(1089, 158, 16, 1, 10000.00, 0),
(1090, 160, 18, 1, 10000.00, 0),
(1091, 160, 6, 1, 10000.00, 0),
(1092, 160, 50, 1, 32000.00, 0),
(1093, 161, 18, 1, 10000.00, 0),
(1094, 161, 15, 1, 10000.00, 0),
(1095, 161, 81, 1, 10000.00, 0),
(1096, 162, 13, 1, 10000.00, 0),
(1097, 162, 5, 1, 9000.00, 0),
(1098, 162, 10, 2, 8000.00, 0),
(1099, 162, 31, 1, 16000.00, 0),
(1100, 162, 35, 1, 16000.00, 0),
(1101, 163, 16, 1, 10000.00, 3000),
(1102, 163, 14, 1, 10000.00, 4500),
(1103, 163, 8, 1, 7000.00, 3000),
(1104, 163, 7, 1, 9000.00, 4000),
(1105, 164, 8, 1, 7000.00, 0),
(1106, 164, 10, 2, 8000.00, 0),
(1107, 164, 7, 1, 9000.00, 0),
(1108, 164, 12, 1, 9000.00, 0),
(1109, 164, 6, 1, 10000.00, 0),
(1110, 164, 9, 2, 7000.00, 0),
(1111, 164, 70, 1, 10000.00, 0),
(1112, 164, 16, 1, 10000.00, 0),
(1113, 165, 13, 1, 10000.00, 0),
(1114, 165, 5, 1, 9000.00, 0),
(1115, 165, 8, 1, 7000.00, 0),
(1116, 165, 13, 1, 10000.00, 0),
(1117, 166, 26, 1, 20000.00, 0),
(1118, 166, 46, 1, 20000.00, 0),
(1119, 166, 11, 1, 7000.00, 0),
(1120, 166, 5, 1, 9000.00, 0),
(1121, 166, 18, 1, 10000.00, 0),
(1122, 166, 6, 1, 10000.00, 0),
(1123, 166, 70, 1, 10000.00, 0),
(1132, 167, 20, 2, 13000.00, 0),
(1133, 167, 23, 2, 13000.00, 0),
(1134, 167, 26, 2, 20000.00, 0),
(1135, 167, 5, 2, 9000.00, 0),
(1136, 168, 40, 1, 88000.00, 0),
(1137, 168, 26, 2, 20000.00, 0),
(1138, 168, 25, 1, 12000.00, 0),
(1139, 168, 28, 2, 7000.00, 0),
(1140, 168, 20, 1, 13000.00, 0),
(1141, 168, 6, 1, 10000.00, 0),
(1142, 168, 12, 1, 9000.00, 0),
(1143, 168, 82, 2, 10000.00, 0),
(1144, 168, 16, 1, 10000.00, 0),
(1145, 168, 81, 1, 10000.00, 0),
(1146, 169, 47, 3, 27500.00, 0),
(1147, 170, 11, 15, 7000.00, 0),
(1148, 170, 9, 10, 7000.00, 0),
(1149, 171, 5, 1, 9000.00, 0),
(1150, 171, 81, 1, 10000.00, 0),
(1151, 171, 15, 1, 10000.00, 0),
(1152, 171, 82, 1, 10000.00, 0),
(1153, 171, 16, 1, 10000.00, 0),
(1154, 171, 7, 1, 9000.00, 0),
(1155, 171, 26, 1, 20000.00, 0),
(1156, 171, 23, 1, 13000.00, 0),
(1157, 171, 12, 1, 9000.00, 0),
(1158, 172, 6, 1, 10000.00, 0),
(1159, 172, 5, 1, 9000.00, 0),
(1171, 174, 33, 20, 16000.00, 0),
(1185, 179, 26, 1, 20000.00, 0),
(1186, 179, 23, 2, 13000.00, 0),
(1188, 178, 11, 1, 7000.00, 0),
(1189, 178, 8, 1, 7000.00, 0),
(1190, 178, 12, 1, 10000.00, 0),
(1191, 178, 6, 1, 10000.00, 0),
(1192, 178, 22, 2, 13000.00, 0),
(1196, 180, 5, 1, 9000.00, 0),
(1197, 180, 16, 1, 10000.00, 0),
(1198, 180, 8, 1, 7000.00, 0),
(1199, 180, 48, 2, 8000.00, 0),
(1200, 181, 16, 1, 10000.00, 0),
(1201, 181, 8, 1, 7000.00, 0),
(1202, 181, 9, 1, 7000.00, 0),
(1203, 181, 5, 1, 9000.00, 0),
(1204, 181, 15, 1, 10000.00, 0),
(1206, 182, 82, 1, 10000.00, 0),
(1207, 182, 5, 1, 9000.00, 0),
(1208, 182, 8, 1, 7000.00, 0),
(1209, 173, 9, 2, 7000.00, 0),
(1210, 173, 10, 2, 8000.00, 0),
(1211, 173, 11, 1, 7000.00, 0),
(1212, 173, 13, 1, 10000.00, 0),
(1213, 173, 26, 2, 20000.00, 0),
(1214, 173, 5, 1, 9000.00, 0),
(1215, 173, 10, 1, 8000.00, 0),
(1216, 173, 8, 2, 7000.00, 0),
(1217, 173, 18, 1, 10000.00, 0),
(1218, 173, 16, 1, 10000.00, 0),
(1219, 173, 70, 1, 10000.00, 0),
(1220, 176, 20, 5, 13000.00, 0),
(1221, 176, 7, 1, 9000.00, 0),
(1222, 176, 8, 1, 7000.00, 0),
(1223, 176, 26, 2, 20000.00, 0),
(1224, 183, 37, 1, 98000.00, 0),
(1225, 183, 40, 1, 88000.00, 0),
(1226, 184, 1, 1, 35000.00, 0),
(1227, 184, 8, 2, 7000.00, 0),
(1228, 184, 9, 1, 7000.00, 0),
(1229, 184, 6, 1, 10000.00, 0),
(1230, 184, 71, 1, 92000.00, 0),
(1231, 185, 15, 1, 10000.00, 0),
(1234, 186, 8, 1, 7000.00, 0),
(1235, 186, 11, 1, 7000.00, 0),
(1236, 186, 5, 3, 9000.00, 0),
(1237, 187, 22, 4, 13000.00, 0),
(1238, 187, 23, 4, 13000.00, 0),
(1241, 189, 46, 1, 20000.00, 0),
(1242, 189, 10, 2, 8000.00, 0),
(1243, 189, 26, 2, 20000.00, 0),
(1244, 190, 20, 4, 13000.00, 0),
(1245, 190, 9, 2, 7000.00, 0),
(1246, 190, 7, 1, 9000.00, 0),
(1247, 190, 81, 1, 10000.00, 0),
(1248, 190, 18, 1, 10000.00, 0),
(1249, 190, 10, 2, 8000.00, 0),
(1250, 191, 6, 8, 9500.00, 0),
(1251, 191, 15, 1, 9500.00, 0),
(1252, 191, 7, 1, 8500.00, 0),
(1253, 191, 5, 3, 8500.00, 0),
(1254, 191, 10, 5, 7500.00, 0),
(1272, 194, 34, 4, 16000.00, 0),
(1273, 194, 33, 4, 16000.00, 0),
(1274, 194, 32, 4, 16000.00, 0),
(1275, 194, 35, 4, 16000.00, 0),
(1276, 194, 31, 4, 16000.00, 0),
(1277, 194, 20, 5, 13000.00, 0),
(1278, 194, 75, 2, 13000.00, 0),
(1279, 194, 21, 3, 13000.00, 0),
(1280, 195, 6, 1, 10000.00, 0),
(1281, 195, 5, 1, 9000.00, 0),
(1282, 195, 89, 1, 12000.00, 0),
(1283, 195, 16, 1, 10000.00, 0),
(1284, 195, 10, 1, 8000.00, 0),
(1285, 196, 10, 1, 8000.00, 0),
(1286, 196, 5, 2, 9000.00, 0),
(1287, 196, 16, 1, 10000.00, 0),
(1288, 196, 18, 1, 10000.00, 0),
(1289, 196, 22, 1, 13000.00, 0),
(1290, 196, 23, 1, 13000.00, 0),
(1291, 197, 26, 2, 20000.00, 0),
(1292, 197, 15, 1, 10000.00, 0),
(1293, 197, 10, 1, 8000.00, 0),
(1294, 197, 18, 1, 10000.00, 0),
(1295, 197, 7, 1, 9000.00, 0),
(1296, 198, 50, 1, 32000.00, 0),
(1297, 198, 1, 1, 35000.00, 0),
(1298, 199, 5, 2, 9000.00, 0),
(1299, 199, 16, 1, 10000.00, 0),
(1300, 199, 10, 1, 8000.00, 0),
(1301, 199, 12, 1, 10000.00, 0),
(1302, 200, 84, 2, 25000.00, 0),
(1303, 200, 49, 1, 30000.00, 0),
(1304, 201, 1, 3, 30000.00, 0),
(1305, 201, 4, 7, 60000.00, 0),
(1306, 202, 26, 1, 20000.00, 0),
(1307, 202, 20, 1, 13000.00, 0),
(1308, 202, 35, 1, 16000.00, 0),
(1309, 203, 6, 2, 10000.00, 0),
(1310, 204, 18, 1, 10000.00, 0),
(1311, 204, 82, 1, 10000.00, 0),
(1312, 204, 5, 1, 9000.00, 0),
(1313, 204, 15, 1, 10000.00, 0),
(1314, 204, 20, 1, 13000.00, 0),
(1315, 204, 16, 1, 10000.00, 0),
(1316, 205, 45, 1, 20000.00, 0),
(1317, 205, 46, 1, 20000.00, 0),
(1318, 205, 11, 1, 7000.00, 0),
(1319, 205, 21, 1, 13000.00, 0),
(1320, 205, 6, 1, 10000.00, 0),
(1321, 205, 7, 1, 9000.00, 0),
(1322, 206, 26, 2, 20000.00, 0),
(1323, 206, 15, 1, 10000.00, 0),
(1324, 206, 89, 1, 12000.00, 0),
(1325, 206, 10, 2, 8000.00, 0),
(1326, 206, 35, 1, 16000.00, 0),
(1327, 207, 5, 2, 9000.00, 0),
(1328, 207, 8, 4, 7000.00, 0),
(1329, 207, 9, 3, 7000.00, 0),
(1330, 207, 10, 1, 8000.00, 0),
(1331, 207, 81, 1, 10000.00, 0),
(1332, 207, 16, 1, 10000.00, 0),
(1333, 207, 12, 1, 10000.00, 0),
(1334, 208, 9, 2, 7000.00, 0),
(1335, 208, 10, 1, 8000.00, 0),
(1336, 208, 11, 2, 7000.00, 0),
(1337, 208, 5, 2, 9000.00, 0),
(1338, 208, 15, 2, 10000.00, 0),
(1339, 208, 26, 1, 20000.00, 0),
(1340, 209, 26, 2, 20000.00, 0),
(1341, 209, 7, 2, 9000.00, 0),
(1342, 209, 8, 2, 7000.00, 0),
(1343, 209, 20, 4, 13000.00, 0),
(1357, 210, 15, 1, 10000.00, 0),
(1358, 210, 70, 1, 10000.00, 0),
(1359, 210, 5, 1, 9000.00, 0),
(1360, 210, 81, 1, 10000.00, 0),
(1361, 210, 82, 1, 10000.00, 0),
(1362, 210, 6, 1, 10000.00, 0),
(1363, 210, 7, 1, 9000.00, 0),
(1364, 210, 16, 1, 10000.00, 0),
(1365, 210, 8, 1, 7000.00, 0),
(1366, 210, 9, 1, 7000.00, 0),
(1367, 210, 10, 1, 8000.00, 0),
(1368, 210, 18, 1, 10000.00, 0),
(1369, 210, 12, 1, 10000.00, 0),
(1370, 211, 35, 1, 16000.00, 0),
(1371, 211, 20, 1, 13000.00, 0),
(1372, 212, 22, 1, 13000.00, 0),
(1373, 212, 23, 2, 13000.00, 0),
(1379, 213, 26, 2, 20000.00, 0),
(1380, 213, 22, 2, 13000.00, 0),
(1381, 213, 89, 1, 12000.00, 0),
(1382, 213, 5, 1, 9000.00, 0),
(1383, 213, 10, 1, 8000.00, 0),
(1384, 214, 8, 4, 7000.00, 0),
(1385, 214, 5, 3, 9000.00, 0),
(1386, 214, 18, 1, 10000.00, 0),
(1387, 214, 7, 2, 9000.00, 0),
(1392, 216, 5, 1, 9000.00, 0),
(1393, 216, 10, 2, 8000.00, 0),
(1394, 216, 8, 1, 7000.00, 0),
(1395, 216, 7, 1, 9000.00, 0),
(1396, 216, 70, 1, 10000.00, 0),
(1397, 216, 82, 1, 10000.00, 0),
(1398, 217, 16, 1, 10000.00, 0),
(1399, 217, 12, 1, 10000.00, 0),
(1400, 217, 18, 1, 10000.00, 0),
(1401, 217, 81, 1, 10000.00, 0),
(1402, 217, 5, 1, 9000.00, 0),
(1403, 217, 6, 1, 10000.00, 0),
(1404, 217, 26, 1, 20000.00, 0),
(1405, 217, 20, 1, 13000.00, 0),
(1406, 218, 26, 2, 20000.00, 0),
(1407, 218, 46, 1, 20000.00, 0),
(1408, 218, 10, 1, 8000.00, 0),
(1409, 218, 22, 1, 13000.00, 0),
(1410, 218, 20, 1, 13000.00, 0),
(1411, 218, 5, 1, 9000.00, 0),
(1412, 219, 8, 2, 7000.00, 0),
(1413, 219, 9, 2, 7000.00, 0),
(1414, 219, 16, 1, 10000.00, 0),
(1415, 220, 26, 1, 20000.00, 0),
(1416, 220, 20, 2, 13000.00, 0),
(1417, 221, 16, 2, 10000.00, 0),
(1418, 221, 82, 1, 10000.00, 0),
(1419, 221, 81, 1, 10000.00, 0),
(1420, 221, 18, 1, 10000.00, 0),
(1421, 222, 5, 1, 9000.00, 0),
(1422, 222, 9, 1, 7000.00, 0),
(1423, 222, 18, 1, 10000.00, 0),
(1424, 222, 10, 2, 8000.00, 0),
(1425, 222, 22, 1, 13000.00, 0),
(1426, 222, 58, 1, 10000.00, 0),
(1427, 223, 26, 2, 20000.00, 0),
(1428, 223, 5, 1, 9000.00, 0),
(1429, 223, 89, 1, 12000.00, 0),
(1430, 223, 10, 1, 8000.00, 0),
(1431, 223, 20, 1, 13000.00, 0),
(1432, 223, 22, 1, 13000.00, 0),
(1433, 215, 5, 4, 9000.00, 0),
(1434, 215, 15, 1, 10000.00, 0),
(1435, 215, 11, 1, 7000.00, 0),
(1436, 215, 89, 1, 12000.00, 0),
(1437, 215, 5, 2, 9000.00, 0),
(1438, 215, 12, 2, 10000.00, 0),
(1439, 224, 26, 1, 20000.00, 0),
(1440, 224, 20, 1, 13000.00, 0),
(1441, 224, 6, 1, 10000.00, 0),
(1450, 225, 8, 20, 7000.00, 0),
(1451, 225, 9, 20, 7000.00, 0),
(1452, 225, 94, 20, 500.00, 0),
(1456, 227, 59, 18, 8000.00, 0),
(1457, 226, 26, 2, 20000.00, 0),
(1458, 226, 7, 1, 9000.00, 0),
(1459, 226, 90, 1, 10000.00, 0),
(1460, 228, 5, 2, 10000.00, 0),
(1461, 228, 11, 1, 8000.00, 0),
(1462, 228, 16, 2, 10000.00, 0),
(1463, 228, 82, 2, 12000.00, 0),
(1464, 228, 10, 1, 8000.00, 0),
(1465, 228, 18, 1, 10000.00, 0),
(1466, 228, 89, 1, 12000.00, 0),
(1467, 229, 20, 1, 13000.00, 0),
(1468, 229, 23, 2, 13000.00, 0),
(1469, 229, 28, 1, 7000.00, 0),
(1470, 229, 8, 1, 7000.00, 0),
(1471, 230, 49, 1, 32000.00, 0),
(1477, 232, 10, 1, 8000.00, 0),
(1478, 231, 26, 3, 20000.00, 0),
(1479, 231, 15, 1, 10000.00, 0),
(1480, 231, 5, 1, 10000.00, 0),
(1481, 231, 9, 2, 7000.00, 0),
(1482, 233, 89, 1, 12000.00, 0),
(1491, 188, 6, 1, 10000.00, 0),
(1492, 188, 16, 1, 10000.00, 0),
(1493, 188, 28, 20, 7000.00, 0),
(1494, 188, 81, 1, 10000.00, 0),
(1495, 188, 89, 3, 12000.00, 0),
(1496, 188, 5, 3, 9000.00, 0),
(1497, 188, 6, 3, 12000.00, 0),
(1498, 235, 11, 1, 8000.00, 0),
(1499, 235, 82, 1, 12000.00, 0),
(1503, 236, 16, 45, 10000.00, 0),
(1504, 236, 23, 45, 13000.00, 0),
(1505, 237, 8, 4, 7000.00, 0),
(1506, 237, 5, 2, 10000.00, 0),
(1507, 237, 15, 1, 10000.00, 0),
(1508, 237, 70, 1, 10000.00, 0),
(1509, 237, 7, 1, 9000.00, 0),
(1510, 237, 89, 1, 12000.00, 0),
(1511, 238, 18, 1, 10000.00, 0),
(1512, 238, 10, 1, 8000.00, 0),
(1513, 238, 82, 1, 12000.00, 0),
(1514, 238, 5, 1, 10000.00, 0),
(1515, 238, 12, 1, 10000.00, 0),
(1516, 238, 16, 1, 10000.00, 0),
(1523, 240, 26, 1, 20000.00, 0),
(1524, 240, 20, 1, 13000.00, 0),
(1525, 241, 6, 1, 10000.00, 0),
(1526, 241, 16, 1, 10000.00, 0),
(1527, 242, 26, 3, 20000.00, 0),
(1528, 243, 22, 2, 13000.00, 0),
(1529, 243, 23, 2, 13000.00, 0),
(1530, 243, 10, 1, 8000.00, 0),
(1531, 244, 82, 1, 12000.00, 0),
(1532, 244, 10, 1, 8000.00, 0),
(1533, 244, 9, 1, 7000.00, 0),
(1534, 244, 6, 1, 10000.00, 0),
(1535, 244, 11, 1, 8000.00, 0),
(1536, 245, 26, 2, 20000.00, 0),
(1537, 245, 82, 1, 12000.00, 0),
(1538, 245, 5, 1, 10000.00, 0),
(1539, 245, 10, 2, 8000.00, 0),
(1540, 245, 89, 1, 12000.00, 0),
(1546, 247, 26, 1, 20000.00, 0),
(1547, 247, 15, 1, 10000.00, 0),
(1548, 247, 89, 1, 12000.00, 0),
(1549, 249, 35, 2, 16000.00, 0),
(1550, 249, 46, 1, 20000.00, 0),
(1551, 250, 20, 3, 13000.00, 0),
(1552, 250, 26, 2, 20000.00, 0),
(1553, 250, 33, 1, 16000.00, 0),
(1554, 250, 35, 1, 16000.00, 0),
(1555, 250, 10, 2, 8000.00, 0),
(1556, 250, 5, 1, 10000.00, 0),
(1557, 250, 13, 1, 10000.00, 0),
(1558, 251, 22, 3, 13000.00, 0),
(1559, 251, 23, 2, 13000.00, 0),
(1560, 251, 35, 3, 16000.00, 0),
(1565, 252, 16, 2, 10000.00, 0),
(1566, 252, 7, 2, 9000.00, 0),
(1567, 252, 15, 1, 10000.00, 0),
(1568, 252, 82, 3, 12000.00, 0),
(1569, 252, 11, 2, 8000.00, 0),
(1570, 252, 18, 2, 10000.00, 0),
(1573, 254, 26, 1, 20000.00, 0),
(1574, 254, 46, 1, 20000.00, 0),
(1575, 255, 45, 3, 20000.00, 0),
(1576, 253, 26, 1, 20000.00, 0),
(1577, 253, 5, 1, 10000.00, 0),
(1584, 256, 10, 2, 8000.00, 0),
(1585, 256, 5, 1, 10000.00, 0),
(1586, 256, 18, 1, 10000.00, 0),
(1587, 256, 89, 1, 12000.00, 0),
(1588, 256, 35, 1, 16000.00, 0),
(1589, 256, 31, 1, 16000.00, 0),
(1590, 256, 46, 1, 20000.00, 0),
(1591, 257, 26, 1, 20000.00, 0),
(1592, 257, 5, 1, 10000.00, 0),
(1593, 257, 12, 1, 10000.00, 0),
(1594, 257, 32, 1, 16000.00, 0),
(1595, 258, 26, 2, 20000.00, 0),
(1596, 258, 5, 2, 10000.00, 0),
(1597, 258, 20, 2, 13000.00, 0),
(1598, 258, 82, 1, 12000.00, 0),
(1599, 258, 10, 2, 8000.00, 0),
(1600, 258, 98, 1, 15000.00, 0),
(1601, 258, 89, 1, 12000.00, 0),
(1602, 258, 46, 1, 20000.00, 0),
(1603, 258, 47, 1, 27500.00, 0),
(1604, 259, 8, 1, 7000.00, 0),
(1605, 259, 9, 1, 7000.00, 0),
(1606, 259, 70, 1, 10000.00, 0),
(1607, 259, 15, 1, 10000.00, 0),
(1608, 260, 18, 1, 10000.00, 0),
(1609, 261, 20, 12, 13000.00, 0),
(1610, 262, 31, 1, 16000.00, 0),
(1611, 262, 32, 1, 16000.00, 0),
(1623, 263, 15, 1, 10000.00, 0),
(1624, 263, 70, 1, 10000.00, 0),
(1625, 263, 97, 1, 10000.00, 0),
(1626, 263, 7, 1, 9000.00, 0),
(1627, 263, 6, 1, 10000.00, 0),
(1628, 263, 12, 1, 10000.00, 0),
(1629, 265, 26, 2, 20000.00, 0),
(1630, 265, 20, 2, 13000.00, 0),
(1631, 265, 23, 2, 13000.00, 0),
(1632, 265, 8, 2, 7000.00, 0),
(1633, 265, 6, 1, 10000.00, 0),
(1660, 264, 15, 1, 10000.00, 0),
(1661, 264, 7, 1, 9000.00, 0),
(1662, 264, 98, 1, 15000.00, 0),
(1663, 264, 8, 1, 7000.00, 0),
(1664, 264, 11, 1, 8000.00, 0),
(1665, 264, 16, 1, 10000.00, 0),
(1666, 267, 10, 3, 8000.00, 0),
(1667, 267, 5, 3, 10000.00, 0),
(1668, 267, 70, 2, 10000.00, 0),
(1669, 267, 16, 1, 10000.00, 0),
(1670, 267, 82, 1, 12000.00, 0),
(1671, 268, 49, 3, 30000.00, 0),
(1672, 268, 2, 2, 30000.00, 0),
(1673, 268, 1, 2, 30000.00, 0),
(1674, 268, 84, 2, 25000.00, 0),
(1675, 268, 99, 2, 41000.00, 0),
(1676, 268, 85, 1, 20000.00, 0),
(1677, 268, 100, 1, 25000.00, 0),
(1678, 268, 83, 1, 41000.00, 0),
(1679, 268, 103, 2, 34000.00, 0),
(1680, 268, 109, 1, 20000.00, 0),
(1681, 268, 51, 2, 22000.00, 0),
(1682, 269, 15, 2, 10000.00, 0),
(1683, 269, 5, 1, 10000.00, 0),
(1684, 269, 18, 1, 10000.00, 0),
(1685, 270, 5, 5, 9500.00, 0),
(1686, 270, 18, 3, 9500.00, 0),
(1687, 270, 70, 5, 9500.00, 0),
(1688, 270, 6, 1, 9500.00, 0),
(1689, 270, 11, 2, 7500.00, 0),
(1690, 270, 89, 5, 11500.00, 0),
(1691, 270, 15, 2, 9500.00, 0),
(1692, 270, 31, 1, 14400.00, 0),
(1693, 270, 32, 1, 14400.00, 0),
(1694, 271, 1, 1, 35000.00, 5000),
(1695, 271, 4, 1, 70000.00, 10000),
(1696, 272, 26, 1, 20000.00, 0),
(1697, 272, 23, 1, 13000.00, 0),
(1698, 272, 18, 1, 10000.00, 0),
(1699, 273, 70, 1, 10000.00, 0),
(1700, 273, 98, 1, 15000.00, 0),
(1701, 274, 26, 1, 20000.00, 0),
(1702, 274, 35, 1, 16000.00, 0),
(1703, 274, 32, 1, 16000.00, 0),
(1704, 275, 16, 1, 10000.00, 0),
(1705, 275, 81, 1, 10000.00, 0),
(1706, 275, 5, 1, 10000.00, 0),
(1707, 275, 89, 1, 12000.00, 0),
(1708, 275, 7, 1, 9000.00, 0),
(1709, 275, 31, 1, 16000.00, 0),
(1710, 275, 20, 1, 13000.00, 0),
(1711, 275, 22, 1, 13000.00, 0),
(1712, 275, 8, 1, 7000.00, 0),
(1722, 277, 97, 1, 10000.00, 0),
(1725, 278, 8, 1, 7000.00, 0),
(1726, 278, 5, 1, 10000.00, 0),
(1727, 279, 10, 1, 8000.00, 0),
(1728, 280, 8, 1, 7000.00, 0),
(1729, 281, 26, 2, 20000.00, 0),
(1730, 281, 8, 1, 7000.00, 0),
(1731, 281, 9, 1, 7000.00, 0),
(1732, 281, 6, 1, 10000.00, 0),
(1733, 281, 97, 1, 10000.00, 0),
(1734, 281, 10, 2, 8000.00, 0),
(1735, 281, 16, 1, 10000.00, 0),
(1736, 281, 70, 1, 10000.00, 0),
(1737, 281, 15, 1, 10000.00, 0),
(1738, 281, 20, 1, 13000.00, 0),
(1739, 281, 22, 1, 13000.00, 0),
(1740, 281, 23, 1, 13000.00, 0),
(1741, 281, 18, 1, 10000.00, 0),
(1742, 281, 98, 1, 15000.00, 0),
(1743, 281, 60, 3, 10000.00, 0),
(1744, 282, 114, 23, 9000.00, 0),
(1745, 283, 8, 1, 7000.00, 0),
(1768, 286, 26, 1, 20000.00, 0),
(1769, 286, 31, 1, 16000.00, 0),
(1770, 287, 97, 1, 10000.00, 0),
(1771, 287, 10, 2, 8000.00, 0),
(1772, 287, 18, 1, 10000.00, 0),
(1773, 287, 82, 1, 12000.00, 0),
(1774, 287, 12, 1, 10000.00, 0),
(1775, 287, 11, 1, 8000.00, 0),
(1781, 288, 89, 2, 12000.00, 0),
(1782, 288, 16, 1, 10000.00, 0),
(1783, 288, 5, 2, 10000.00, 0),
(1784, 288, 70, 2, 10000.00, 0),
(1785, 288, 26, 3, 20000.00, 0),
(1786, 288, 22, 1, 13000.00, 0),
(1787, 288, 15, 1, 10000.00, 0),
(1788, 289, 8, 2, 7000.00, 0),
(1789, 289, 10, 3, 8000.00, 0),
(1790, 289, 23, 2, 13000.00, 0),
(1791, 289, 20, 2, 13000.00, 0),
(1792, 289, 22, 1, 13000.00, 0),
(1793, 289, 7, 1, 9000.00, 0),
(1794, 289, 6, 1, 10000.00, 0),
(1815, 292, 8, 1, 6500.00, 0),
(1816, 292, 15, 1, 9500.00, 0),
(1817, 292, 5, 2, 9500.00, 0),
(1818, 292, 6, 1, 9500.00, 0),
(1819, 292, 70, 1, 9500.00, 0),
(1820, 292, 89, 1, 11500.00, 0),
(1821, 292, 11, 1, 7500.00, 0),
(1822, 292, 18, 1, 9500.00, 0),
(1823, 293, 11, 1, 7500.00, 0),
(1824, 293, 5, 1, 9500.00, 0),
(1825, 293, 9, 1, 6500.00, 0),
(1826, 293, 15, 1, 9500.00, 0),
(1827, 293, 70, 1, 9500.00, 0),
(1828, 293, 18, 1, 9500.00, 0),
(1829, 294, 5, 1, 9500.00, 0),
(1830, 294, 98, 1, 14500.00, 0),
(1831, 294, 8, 1, 6500.00, 0),
(1835, 296, 89, 1, 11500.00, 0),
(1836, 296, 6, 1, 9500.00, 0),
(1837, 296, 70, 1, 12000.00, 0),
(1838, 297, 8, 40, 6250.00, 0),
(1839, 297, 9, 60, 6250.00, 0),
(1840, 298, 16, 1, 9500.00, 0),
(1841, 298, 5, 1, 9500.00, 0),
(1842, 298, 18, 1, 9500.00, 0),
(1843, 298, 82, 1, 11500.00, 0),
(1844, 298, 10, 1, 7500.00, 0),
(1845, 298, 98, 1, 14500.00, 0),
(1846, 299, 5, 2, 10000.00, 0),
(1847, 299, 16, 1, 10000.00, 0),
(1848, 299, 18, 1, 10000.00, 0),
(1849, 299, 8, 4, 7000.00, 0),
(1850, 299, 9, 1, 7000.00, 0),
(1851, 299, 10, 3, 8000.00, 0),
(1852, 300, 26, 1, 20000.00, 0),
(1853, 300, 32, 1, 16000.00, 0),
(1854, 300, 20, 1, 13000.00, 0),
(1855, 301, 47, 2, 27500.00, 0),
(1856, 301, 31, 1, 16000.00, 0),
(1857, 301, 26, 1, 20000.00, 0),
(1858, 302, 26, 1, 20000.00, 0),
(1859, 302, 20, 1, 13000.00, 0),
(1860, 302, 32, 1, 16000.00, 0),
(1861, 303, 7, 1, 9000.00, 0),
(1862, 303, 5, 1, 10000.00, 0),
(1863, 303, 18, 1, 10000.00, 0),
(1864, 303, 11, 1, 8000.00, 0),
(1865, 303, 9, 1, 7000.00, 0),
(1866, 303, 16, 1, 10000.00, 0),
(1867, 303, 98, 1, 15000.00, 0),
(1868, 303, 8, 1, 7000.00, 0),
(1869, 303, 82, 1, 12000.00, 0),
(1870, 303, 116, 1, 9000.00, 0),
(1871, 304, 8, 1, 7000.00, 0),
(1872, 304, 6, 1, 10000.00, 0),
(1873, 304, 26, 2, 20000.00, 0),
(1874, 304, 5, 1, 10000.00, 0),
(1875, 304, 70, 1, 10000.00, 0),
(1876, 304, 8, 1, 7000.00, 0),
(1877, 304, 20, 2, 13000.00, 0),
(1878, 305, 5, 1, 10000.00, 0),
(1879, 306, 26, 1, 20000.00, 0),
(1880, 306, 32, 1, 16000.00, 0),
(1881, 306, 31, 1, 16000.00, 0),
(1882, 306, 22, 2, 13000.00, 0),
(1883, 307, 37, 1, 98000.00, 0),
(1884, 307, 72, 1, 92000.00, 0),
(1885, 307, 73, 1, 92000.00, 0),
(1888, 309, 26, 6, 20000.00, 0),
(1889, 309, 25, 6, 12000.00, 0),
(1893, 311, 82, 1, 12000.00, 0),
(1894, 311, 5, 1, 10000.00, 0),
(1895, 311, 20, 1, 13000.00, 0),
(1896, 310, 98, 1, 15000.00, 0),
(1897, 310, 6, 1, 10000.00, 0),
(1898, 310, 47, 1, 27500.00, 0),
(1899, 312, 9, 1, 7000.00, 0),
(1900, 312, 10, 2, 8000.00, 0),
(1901, 312, 8, 2, 7000.00, 0),
(1902, 312, 11, 1, 8000.00, 0),
(1903, 312, 16, 1, 10000.00, 0),
(1904, 312, 82, 1, 12000.00, 0),
(1905, 312, 18, 1, 10000.00, 0),
(1906, 312, 58, 1, 15000.00, 0),
(1907, 313, 26, 1, 20000.00, 0),
(1908, 313, 46, 1, 20000.00, 0),
(1909, 313, 70, 1, 10000.00, 0),
(1910, 313, 5, 1, 10000.00, 0),
(1911, 313, 8, 1, 7000.00, 0),
(1912, 314, 26, 2, 20000.00, 0),
(1913, 315, 26, 3, 20000.00, 0),
(1914, 315, 15, 1, 10000.00, 0),
(1915, 315, 12, 1, 10000.00, 0),
(1916, 315, 20, 2, 13000.00, 0),
(1917, 315, 22, 2, 13000.00, 0),
(1918, 315, 23, 1, 13000.00, 0),
(1919, 315, 21, 1, 13000.00, 0),
(1920, 315, 9, 1, 7000.00, 0),
(1922, 317, 18, 1, 9500.00, 0),
(1923, 317, 15, 1, 9500.00, 0),
(1924, 317, 98, 1, 14500.00, 0),
(1925, 317, 5, 1, 9500.00, 0),
(1926, 318, 6, 5, 9500.00, 0),
(1927, 318, 98, 3, 14500.00, 0),
(1928, 318, 89, 5, 11500.00, 0),
(1929, 318, 5, 2, 9500.00, 0),
(1930, 319, 8, 1, 7000.00, 0),
(1931, 319, 16, 1, 10000.00, 0),
(1932, 319, 6, 1, 10000.00, 0),
(1933, 320, 26, 1, 20000.00, 0),
(1934, 320, 22, 1, 13000.00, 0),
(1935, 321, 10, 1, 8000.00, 0),
(1936, 322, 82, 1, 12000.00, 0),
(1937, 323, 10, 1, 8000.00, 0),
(1938, 323, 8, 1, 7000.00, 0),
(1939, 323, 18, 1, 10000.00, 0),
(1943, 325, 26, 3, 20000.00, 0),
(1944, 325, 5, 1, 10000.00, 0),
(1945, 326, 8, 1, 7000.00, 0),
(1946, 326, 16, 1, 10000.00, 0),
(1955, 327, 82, 1, 12000.00, 0),
(1956, 327, 6, 1, 10000.00, 0),
(1957, 327, 5, 1, 10000.00, 0),
(1958, 327, 89, 1, 12000.00, 0),
(1959, 327, 16, 1, 10000.00, 0),
(1960, 327, 15, 1, 10000.00, 0),
(1961, 285, 8, 3, 7000.00, 0),
(1962, 285, 11, 1, 8000.00, 0),
(1963, 285, 5, 2, 10000.00, 0),
(1964, 285, 81, 1, 10000.00, 0),
(1965, 285, 12, 1, 10000.00, 0),
(1966, 285, 89, 1, 12000.00, 0),
(1967, 285, 82, 1, 12000.00, 0),
(1968, 285, 7, 1, 9000.00, 0),
(1969, 285, 26, 1, 20000.00, 0),
(1970, 285, 20, 1, 13000.00, 0),
(1971, 285, 23, 1, 13000.00, 0),
(1972, 285, 31, 1, 16000.00, 0),
(1973, 285, 32, 1, 16000.00, 0),
(1974, 285, 35, 1, 16000.00, 0),
(1975, 285, 5, 1, 10000.00, 0),
(1976, 285, 16, 1, 10000.00, 0),
(1977, 328, 26, 2, 20000.00, 0),
(1978, 328, 10, 2, 8000.00, 0),
(1979, 328, 35, 1, 16000.00, 0),
(1980, 328, 32, 1, 16000.00, 0),
(1981, 329, 98, 1, 15000.00, 0),
(1982, 329, 26, 1, 20000.00, 0),
(1983, 329, 23, 1, 13000.00, 0),
(1984, 324, 98, 1, 15000.00, 0),
(1985, 324, 16, 1, 10000.00, 0),
(1986, 324, 15, 1, 10000.00, 0),
(1987, 330, 50, 1, 32000.00, 0),
(1988, 331, 32, 1, 16000.00, 0),
(1989, 331, 35, 1, 16000.00, 0),
(1990, 331, 9, 1, 7000.00, 0),
(1991, 331, 11, 1, 8000.00, 0),
(1992, 332, 10, 2, 8000.00, 0),
(1993, 333, 26, 3, 20000.00, 0),
(1994, 333, 20, 2, 13000.00, 0),
(1995, 333, 22, 2, 13000.00, 0),
(1996, 333, 23, 2, 13000.00, 0),
(1997, 334, 12, 1, 10000.00, 0),
(1998, 334, 5, 1, 10000.00, 0),
(1999, 335, 20, 1, 13000.00, 0),
(2000, 335, 21, 1, 13000.00, 0),
(2001, 335, 23, 1, 13000.00, 0),
(2002, 335, 22, 1, 13000.00, 0),
(2003, 336, 26, 2, 20000.00, 0),
(2004, 336, 35, 1, 16000.00, 0),
(2005, 337, 22, 1, 13000.00, 0),
(2006, 337, 23, 1, 13000.00, 0),
(2007, 337, 5, 2, 10000.00, 0),
(2008, 337, 8, 1, 7000.00, 0),
(2009, 337, 10, 1, 8000.00, 0),
(2010, 337, 9, 1, 7000.00, 0),
(2011, 337, 18, 1, 10000.00, 0),
(2012, 337, 82, 1, 12000.00, 0),
(2013, 337, 16, 2, 10000.00, 0),
(2014, 338, 26, 1, 20000.00, 0),
(2015, 338, 11, 1, 8000.00, 0),
(2016, 338, 10, 1, 8000.00, 0),
(2017, 338, 70, 1, 10000.00, 0),
(2018, 339, 16, 1, 10000.00, 0),
(2019, 339, 26, 1, 20000.00, 0),
(2020, 339, 1, 1, 35000.00, 0),
(2021, 339, 49, 2, 32000.00, 0),
(2027, 340, 45, 2, 20000.00, 0),
(2028, 340, 5, 2, 10000.00, 0),
(2029, 340, 89, 1, 12000.00, 0),
(2030, 340, 18, 1, 10000.00, 0),
(2031, 340, 22, 2, 13000.00, 0),
(2032, 340, 10, 1, 8000.00, 0),
(2033, 341, 8, 2, 7000.00, 0),
(2044, 344, 8, 2, 7000.00, 0),
(2045, 345, 10, 1, 8000.00, 0),
(2046, 346, 45, 2, 20000.00, 0),
(2047, 346, 47, 1, 27500.00, 0),
(2048, 347, 10, 1, 8000.00, 0),
(2049, 347, 8, 3, 7000.00, 0),
(2050, 347, 82, 1, 12000.00, 0),
(2051, 347, 12, 1, 10000.00, 0),
(2052, 347, 89, 1, 12000.00, 0),
(2053, 347, 11, 1, 8000.00, 0),
(2054, 347, 5, 1, 10000.00, 0),
(2055, 347, 9, 1, 7000.00, 0),
(2056, 348, 70, 1, 10000.00, 0),
(2057, 349, 20, 2, 13000.00, 0),
(2058, 349, 22, 2, 13000.00, 0),
(2059, 349, 26, 3, 20000.00, 0),
(2060, 350, 11, 2, 8000.00, 0),
(2061, 350, 6, 2, 10000.00, 0),
(2062, 350, 89, 2, 12000.00, 0),
(2063, 350, 18, 43, 10000.00, 0),
(2064, 351, 26, 4, 20000.00, 0),
(2065, 351, 5, 1, 10000.00, 0),
(2066, 352, 26, 2, 20000.00, 0),
(2067, 352, 20, 6, 13000.00, 0),
(2068, 352, 8, 5, 7000.00, 0),
(2069, 352, 9, 5, 7000.00, 0),
(2070, 352, 11, 5, 8000.00, 0),
(2071, 352, 7, 2, 9000.00, 0),
(2072, 352, 6, 2, 10000.00, 0),
(2073, 353, 18, 12, 10000.00, 0),
(2074, 353, 26, 6, 20000.00, 0),
(2075, 353, 58, 3, 15000.00, 0),
(2076, 354, 5, 2, 10000.00, 0),
(2077, 354, 45, 1, 20000.00, 0),
(2078, 354, 47, 1, 27500.00, 0),
(2079, 354, 7, 1, 9000.00, 0),
(2080, 354, 82, 1, 12000.00, 0),
(2081, 354, 10, 1, 8000.00, 0),
(2082, 355, 60, 2, 15000.00, 0),
(2083, 356, 8, 160, 7000.00, 0),
(2086, 358, 8, 75, 7000.00, 0),
(2087, 358, 9, 25, 7000.00, 0),
(2088, 359, 8, 10, 7000.00, 0),
(2089, 359, 9, 15, 7000.00, 0),
(2093, 361, 115, 10, 15000.00, 0),
(2094, 361, 5, 12, 10000.00, 0),
(2095, 361, 18, 12, 10000.00, 0),
(2096, 361, 8, 1, 7000.00, 0),
(2097, 361, 9, 1, 7000.00, 0),
(2098, 361, 7, 1, 9000.00, 0),
(2099, 361, 115, 2, 15000.00, 0),
(2100, 362, 26, 1, 20000.00, 0),
(2101, 363, 27, 1, 140000.00, 0),
(2102, 363, 39, 1, 98000.00, 0),
(2107, 365, 118, 3, 20000.00, 0),
(2108, 365, 26, 1, 20000.00, 0),
(2109, 365, 18, 1, 10000.00, 0),
(2110, 365, 89, 1, 12000.00, 0),
(2116, 366, 117, 2, 15000.00, 0),
(2117, 366, 26, 1, 20000.00, 0),
(2118, 366, 10, 1, 8000.00, 0),
(2119, 366, 32, 1, 16000.00, 0),
(2120, 366, 35, 1, 16000.00, 0),
(2121, 364, 26, 2, 20000.00, 0),
(2122, 364, 5, 2, 10000.00, 0),
(2123, 364, 11, 1, 8000.00, 0),
(2124, 364, 117, 1, 15000.00, 0),
(2125, 360, 118, 2, 20000.00, 0),
(2126, 360, 10, 2, 8000.00, 0),
(2127, 360, 15, 1, 10000.00, 0),
(2128, 360, 8, 1, 7000.00, 0),
(2129, 360, 5, 1, 10000.00, 0),
(2130, 369, 1, 1, 35000.00, 0),
(2131, 369, 22, 2, 13000.00, 0),
(2132, 370, 26, 2, 20000.00, 0),
(2133, 370, 117, 2, 15000.00, 0),
(2134, 370, 31, 1, 16000.00, 0),
(2135, 370, 32, 3, 16000.00, 0),
(2136, 370, 89, 1, 12000.00, 0),
(2137, 371, 18, 1, 10000.00, 0),
(2138, 371, 16, 1, 10000.00, 0),
(2139, 371, 10, 1, 8000.00, 0),
(2140, 371, 8, 2, 7000.00, 0),
(2141, 371, 5, 1, 10000.00, 0),
(2142, 372, 32, 3, 16000.00, 0),
(2143, 372, 31, 1, 16000.00, 0),
(2149, 367, 5, 1, 10000.00, 0),
(2150, 367, 118, 1, 20000.00, 0),
(2151, 367, 10, 2, 8000.00, 0),
(2152, 367, 18, 2, 10000.00, 0),
(2153, 367, 12, 2, 10000.00, 0),
(2154, 373, 82, 3, 12000.00, 0),
(2155, 373, 7, 3, 9000.00, 0),
(2156, 373, 8, 1, 7000.00, 0),
(2157, 373, 9, 1, 7000.00, 0),
(2158, 373, 10, 1, 8000.00, 0),
(2159, 373, 6, 1, 10000.00, 0),
(2160, 373, 7, 1, 9000.00, 0),
(2161, 373, 11, 1, 8000.00, 0),
(2162, 373, 5, 1, 10000.00, 0),
(2163, 373, 15, 1, 10000.00, 0),
(2164, 373, 16, 2, 10000.00, 0),
(2167, 374, 50, 1, 32000.00, 0),
(2168, 374, 51, 2, 24000.00, 0),
(2169, 375, 117, 3, 18000.00, 0),
(2170, 375, 13, 2, 10000.00, 0),
(2171, 375, 32, 3, 16000.00, 0),
(2172, 376, 26, 2, 20000.00, 0),
(2173, 376, 6, 1, 10000.00, 0),
(2174, 376, 22, 1, 13000.00, 0),
(2175, 376, 117, 1, 18000.00, 0),
(2178, 378, 8, 2, 7000.00, 0),
(2182, 377, 8, 2, 7000.00, 0),
(2183, 377, 9, 1, 7000.00, 0),
(2184, 377, 5, 2, 10000.00, 0),
(2185, 382, 27, 2, 140000.00, 0),
(2186, 382, 5, 1, 10000.00, 0),
(2187, 382, 18, 1, 10000.00, 0),
(2188, 382, 10, 1, 8000.00, 0),
(2189, 383, 7, 1, 9000.00, 0),
(2190, 383, 26, 1, 20000.00, 0),
(2191, 383, 18, 1, 10000.00, 0),
(2192, 384, 26, 2, 20000.00, 0),
(2193, 384, 10, 1, 8000.00, 0),
(2194, 384, 18, 1, 10000.00, 0),
(2195, 384, 70, 1, 10000.00, 0),
(2196, 384, 45, 1, 20000.00, 0),
(2197, 384, 46, 1, 20000.00, 0),
(2198, 384, 47, 1, 27500.00, 0),
(2199, 385, 115, 1, 15000.00, 0),
(2200, 385, 7, 1, 9000.00, 0),
(2201, 385, 18, 1, 10000.00, 0),
(2202, 385, 5, 1, 10000.00, 0),
(2203, 385, 6, 1, 10000.00, 0),
(2204, 385, 89, 1, 12000.00, 0),
(2213, 387, 11, 1, 8000.00, 0),
(2214, 387, 5, 3, 10000.00, 0),
(2215, 387, 8, 2, 7000.00, 0),
(2216, 387, 18, 1, 10000.00, 0),
(2217, 387, 6, 1, 10000.00, 0),
(2218, 386, 10, 3, 8000.00, 0),
(2219, 386, 12, 1, 10000.00, 0),
(2220, 386, 7, 1, 9000.00, 0),
(2221, 386, 115, 1, 15000.00, 0),
(2222, 386, 98, 1, 15000.00, 0),
(2223, 386, 70, 1, 10000.00, 0),
(2224, 386, 15, 1, 10000.00, 0),
(2225, 386, 89, 1, 12000.00, 0),
(2226, 388, 26, 3, 20000.00, 0),
(2227, 388, 8, 1, 7000.00, 0),
(2228, 388, 9, 1, 7000.00, 0),
(2229, 388, 82, 1, 12000.00, 0),
(2230, 389, 117, 2, 15000.00, 0),
(2231, 389, 45, 1, 20000.00, 0),
(2232, 389, 47, 1, 27500.00, 0),
(2233, 390, 45, 1, 20000.00, 0),
(2234, 390, 47, 1, 27500.00, 0),
(2235, 390, 58, 16, 10400.00, 0),
(2236, 391, 26, 3, 20000.00, 0),
(2237, 391, 6, 1, 10000.00, 0),
(2238, 391, 10, 1, 8000.00, 0),
(2239, 391, 117, 1, 18000.00, 0),
(2240, 392, 117, 2, 18000.00, 0),
(2241, 392, 45, 1, 20000.00, 0),
(2242, 392, 47, 1, 20000.00, 0),
(2243, 392, 46, 1, 20000.00, 0),
(2248, 393, 20, 2, 13000.00, 0),
(2249, 393, 22, 2, 13000.00, 0),
(2250, 393, 117, 1, 18000.00, 0),
(2251, 395, 26, 2, 20000.00, 0),
(2252, 395, 117, 2, 18000.00, 0),
(2253, 396, 117, 4, 18000.00, 0),
(2254, 397, 22, 5, 13000.00, 0),
(2255, 397, 32, 1, 16000.00, 0),
(2256, 397, 33, 1, 16000.00, 0),
(2257, 397, 26, 3, 20000.00, 0),
(2258, 398, 26, 2, 20000.00, 0),
(2259, 398, 117, 2, 18000.00, 0),
(2260, 398, 47, 2, 27500.00, 0),
(2261, 398, 46, 1, 20000.00, 0),
(2262, 399, 8, 2, 7000.00, 0),
(2263, 399, 9, 1, 7000.00, 0),
(2264, 399, 18, 1, 10000.00, 0),
(2265, 399, 89, 1, 12000.00, 0),
(2266, 399, 5, 2, 10000.00, 0),
(2267, 399, 12, 1, 10000.00, 0),
(2268, 400, 26, 1, 20000.00, 0),
(2269, 400, 20, 1, 13000.00, 0),
(2270, 400, 22, 1, 13000.00, 0),
(2271, 400, 23, 1, 13000.00, 0),
(2272, 400, 33, 1, 16000.00, 0),
(2273, 400, 7, 1, 9000.00, 0),
(2274, 400, 6, 1, 10000.00, 0),
(2275, 400, 18, 1, 10000.00, 0),
(2276, 400, 15, 1, 10000.00, 0),
(2277, 400, 16, 1, 10000.00, 0),
(2278, 401, 8, 1, 7000.00, 0),
(2279, 401, 10, 1, 8000.00, 0),
(2280, 401, 11, 1, 8000.00, 0),
(2281, 401, 82, 1, 12000.00, 0),
(2282, 402, 26, 2, 20000.00, 0),
(2283, 402, 117, 2, 18000.00, 0),
(2284, 402, 15, 2, 10000.00, 0),
(2285, 402, 18, 1, 10000.00, 0),
(2286, 402, 89, 1, 12000.00, 0),
(2287, 402, 46, 1, 20000.00, 0),
(2288, 403, 58, 33, 10000.00, 0),
(2289, 404, 117, 2, 18000.00, 0),
(2290, 404, 26, 1, 20000.00, 0),
(2291, 404, 11, 1, 8000.00, 0),
(2292, 404, 89, 1, 12000.00, 0),
(2293, 404, 46, 1, 20000.00, 0),
(2294, 404, 47, 1, 27500.00, 0),
(2295, 405, 26, 4, 20000.00, 0),
(2296, 405, 20, 5, 13000.00, 0),
(2297, 406, 8, 10, 7000.00, 0),
(2298, 406, 11, 5, 8000.00, 0),
(2299, 407, 32, 2, 16000.00, 0),
(2300, 407, 15, 1, 10000.00, 0),
(2301, 407, 11, 2, 8000.00, 0),
(2302, 407, 22, 1, 13000.00, 0),
(2303, 408, 33, 1, 16000.00, 0),
(2304, 408, 22, 2, 13000.00, 0),
(2305, 408, 20, 1, 13000.00, 0),
(2306, 408, 23, 1, 13000.00, 0),
(2307, 408, 5, 1, 10000.00, 0),
(2308, 408, 10, 1, 8000.00, 0),
(2309, 408, 18, 1, 10000.00, 0),
(2310, 409, 20, 10, 13000.00, 0),
(2311, 410, 58, 30, 8000.00, 0),
(2312, 411, 26, 3, 20000.00, 0),
(2313, 411, 8, 1, 7000.00, 0),
(2314, 412, 18, 1, 10000.00, 0),
(2315, 412, 5, 1, 10000.00, 0),
(2316, 412, 8, 2, 7000.00, 0),
(2317, 412, 10, 2, 8000.00, 0),
(2318, 412, 6, 1, 10000.00, 0),
(2319, 412, 16, 1, 10000.00, 0),
(2320, 412, 20, 1, 13000.00, 0),
(2321, 412, 70, 1, 10000.00, 0),
(2322, 413, 117, 2, 18000.00, 0),
(2323, 413, 47, 1, 27500.00, 0),
(2324, 413, 70, 1, 10000.00, 0),
(2325, 413, 5, 1, 10000.00, 0),
(2326, 413, 26, 2, 20000.00, 0),
(2327, 414, 26, 2, 20000.00, 0),
(2328, 414, 47, 1, 27500.00, 0),
(2329, 414, 15, 1, 10000.00, 0),
(2330, 414, 70, 1, 10000.00, 0),
(2331, 414, 10, 2, 8000.00, 0),
(2332, 415, 26, 1, 20000.00, 0),
(2333, 415, 32, 1, 16000.00, 0),
(2334, 415, 33, 1, 16000.00, 0),
(2335, 415, 11, 1, 8000.00, 0),
(2336, 415, 18, 1, 10000.00, 0),
(2337, 415, 10, 1, 8000.00, 0),
(2338, 416, 89, 1, 12000.00, 0),
(2339, 416, 8, 1, 7000.00, 0),
(2340, 416, 9, 1, 7000.00, 0),
(2341, 416, 5, 2, 10000.00, 0),
(2342, 417, 22, 3, 13000.00, 0),
(2343, 417, 23, 3, 13000.00, 0),
(2344, 417, 37, 1, 98000.00, 0),
(2345, 418, 117, 2, 18000.00, 0),
(2346, 418, 26, 2, 20000.00, 0),
(2347, 418, 89, 1, 12000.00, 0),
(2348, 418, 5, 1, 10000.00, 0),
(2349, 418, 10, 2, 8000.00, 0),
(2350, 418, 47, 1, 27500.00, 0),
(2351, 419, 26, 1, 20000.00, 0),
(2352, 419, 10, 1, 8000.00, 0),
(2353, 419, 89, 1, 12000.00, 0),
(2354, 419, 11, 1, 8000.00, 0),
(2355, 420, 31, 1, 16000.00, 0),
(2356, 420, 33, 1, 16000.00, 0),
(2357, 421, 26, 2, 20000.00, 0),
(2358, 421, 10, 1, 8000.00, 0),
(2359, 421, 16, 1, 10000.00, 0),
(2360, 421, 32, 3, 16000.00, 0),
(2361, 422, 8, 50, 6500.00, 0),
(2362, 422, 11, 50, 6500.00, 0),
(2363, 424, 6, 1, 10000.00, 0),
(2364, 424, 9, 1, 7000.00, 0),
(2365, 424, 10, 1, 8000.00, 0),
(2366, 425, 58, 10, 10000.00, 0),
(2367, 426, 8, 25, 7000.00, 0),
(2368, 426, 9, 25, 7000.00, 0),
(2369, 427, 8, 2, 7000.00, 0),
(2370, 427, 9, 2, 7000.00, 0),
(2371, 427, 10, 2, 8000.00, 0),
(2372, 427, 5, 2, 10000.00, 0),
(2373, 427, 82, 2, 12000.00, 0),
(2374, 427, 15, 2, 10000.00, 0),
(2375, 427, 7, 2, 9000.00, 0),
(2376, 427, 16, 2, 10000.00, 0),
(2378, 429, 2, 1, 30000.00, 0),
(2379, 429, 49, 1, 30000.00, 0),
(2380, 429, 51, 1, 22000.00, 0),
(2381, 430, 121, 25, 15000.00, 0),
(2390, 432, 18, 3, 9500.00, 0),
(2391, 432, 10, 8, 7500.00, 0),
(2392, 432, 6, 4, 9500.00, 0),
(2393, 432, 15, 5, 9500.00, 0),
(2394, 432, 12, 2, 9500.00, 0),
(2395, 432, 89, 1, 11500.00, 0),
(2396, 432, 11, 4, 7500.00, 0),
(2397, 433, 8, 10, 7000.00, 0),
(2398, 433, 11, 5, 8000.00, 0),
(2399, 431, 119, 27, 18000.00, 0),
(2400, 431, 12, 1, 10000.00, 0),
(2401, 431, 8, 5, 7000.00, 0),
(2402, 431, 26, 2, 20000.00, 0),
(2403, 431, 33, 1, 16000.00, 0),
(2404, 431, 15, 2, 10000.00, 0),
(2405, 431, 82, 2, 12000.00, 0),
(2406, 431, 16, 3, 10000.00, 0),
(2407, 431, 22, 3, 13000.00, 0),
(2408, 431, 6, 1, 10000.00, 0),
(2409, 431, 12, 1, 10000.00, 0),
(2410, 431, 5, 1, 10000.00, 0),
(2411, 431, 32, 1, 16000.00, 0),
(2416, 435, 26, 2, 20000.00, 0),
(2417, 435, 18, 1, 10000.00, 0),
(2418, 435, 5, 1, 10000.00, 0),
(2419, 434, 22, 1, 13000.00, 0),
(2420, 434, 15, 1, 10000.00, 0),
(2421, 434, 16, 1, 10000.00, 0),
(2422, 434, 6, 1, 10000.00, 0),
(2423, 436, 89, 1, 12000.00, 0),
(2424, 436, 16, 1, 10000.00, 0),
(2425, 436, 5, 1, 10000.00, 0),
(2426, 436, 10, 2, 8000.00, 0),
(2427, 436, 70, 1, 10000.00, 0),
(2428, 436, 11, 1, 8000.00, 0),
(2429, 436, 9, 1, 7000.00, 0),
(2430, 436, 16, 1, 10000.00, 0),
(2431, 436, 32, 1, 16000.00, 0),
(2432, 437, 8, 2, 7000.00, 0),
(2433, 437, 5, 1, 10000.00, 0),
(2434, 437, 16, 2, 10000.00, 0),
(2435, 437, 26, 2, 20000.00, 0),
(2436, 438, 8, 1, 7000.00, 0),
(2437, 438, 18, 1, 10000.00, 0),
(2438, 438, 9, 1, 7000.00, 0),
(2439, 439, 22, 2, 13000.00, 0),
(2440, 439, 15, 1, 10000.00, 0),
(2441, 439, 47, 1, 27500.00, 0),
(2442, 439, 46, 1, 20000.00, 0),
(2443, 440, 5, 1, 10000.00, 0),
(2444, 441, 46, 1, 20000.00, 0),
(2445, 441, 11, 2, 8000.00, 0),
(2446, 442, 11, 2, 8000.00, 0),
(2447, 442, 70, 1, 10000.00, 0),
(2448, 442, 16, 1, 10000.00, 0),
(2454, 445, 32, 2, 16000.00, 0),
(2457, 447, 32, 1, 16000.00, 0),
(2458, 447, 20, 1, 13000.00, 0),
(2459, 447, 47, 1, 27500.00, 0),
(2472, 448, 18, 1, 10000.00, 0),
(2473, 448, 8, 1, 7000.00, 0),
(2474, 448, 9, 1, 7000.00, 0),
(2475, 448, 16, 1, 10000.00, 0),
(2476, 451, 89, 3, 12000.00, 0),
(2477, 451, 70, 1, 10000.00, 0),
(2478, 451, 5, 1, 10000.00, 0),
(2495, 456, 1, 1, 38000.00, 0),
(2504, 462, 115, 1, 15000.00, 0),
(2508, 464, 115, 1, 15000.00, 0),
(2509, 464, 5, 1, 10000.00, 0),
(2510, 464, 7, 1, 9000.00, 0),
(2511, 464, 26, 1, 20000.00, 0),
(2512, 464, 18, 1, 10000.00, 0),
(2513, 464, 11, 1, 8000.00, 0),
(2525, 467, 8, 1, 7000.00, 0),
(2526, 467, 10, 1, 8000.00, 0),
(2585, 476, 5, 1, 10000.00, 0),
(2586, 476, 15, 1, 10000.00, 0),
(2587, 476, 11, 1, 8000.00, 0),
(2588, 476, 18, 1, 10000.00, 0),
(2589, 476, 8, 1, 7000.00, 0),
(2590, 476, 10, 1, 8000.00, 0),
(2591, 476, 115, 1, 15000.00, 0),
(2592, 476, 70, 1, 10000.00, 0),
(2593, 476, 7, 1, 9000.00, 0),
(2594, 476, 6, 1, 10000.00, 0),
(2595, 475, 5, 1, 10000.00, 0),
(2596, 475, 15, 1, 10000.00, 0),
(2597, 475, 11, 1, 8000.00, 0),
(2598, 475, 18, 1, 10000.00, 0),
(2599, 475, 8, 1, 7000.00, 0),
(2600, 475, 10, 1, 8000.00, 0),
(2601, 475, 115, 1, 15000.00, 0),
(2602, 475, 70, 1, 10000.00, 0),
(2603, 475, 7, 1, 9000.00, 0),
(2604, 475, 6, 1, 10000.00, 0),
(2605, 474, 5, 1, 10000.00, 0),
(2606, 474, 15, 1, 10000.00, 0),
(2607, 474, 11, 1, 8000.00, 0),
(2608, 474, 18, 1, 10000.00, 0),
(2609, 474, 8, 1, 7000.00, 0),
(2610, 474, 10, 1, 8000.00, 0),
(2611, 474, 115, 1, 15000.00, 0),
(2612, 474, 70, 1, 10000.00, 0),
(2613, 474, 7, 1, 9000.00, 0),
(2614, 474, 6, 1, 10000.00, 0),
(2619, 468, 5, 1, 10000.00, 0),
(2620, 468, 15, 2, 10000.00, 0),
(2621, 468, 32, 1, 16000.00, 0),
(2622, 468, 12, 1, 10000.00, 0),
(2626, 473, 70, 1, 10000.00, 0),
(2627, 473, 11, 1, 8000.00, 0),
(2628, 473, 5, 1, 10000.00, 0),
(2629, 473, 18, 1, 10000.00, 0),
(2630, 473, 15, 1, 10000.00, 0),
(2631, 473, 6, 1, 10000.00, 0),
(2632, 473, 8, 1, 7000.00, 0),
(2633, 473, 10, 1, 8000.00, 0),
(2634, 443, 5, 7, 10000.00, 0),
(2635, 443, 2, 1, 38000.00, 0),
(2636, 477, 8, 2, 7000.00, 0),
(2637, 477, 11, 2, 8000.00, 0),
(2638, 477, 1, 1, 38000.00, 0),
(2644, 446, 32, 1, 16000.00, 0),
(2645, 446, 16, 1, 10000.00, 0),
(2646, 444, 122, 1, 27500.00, 0),
(2647, 444, 46, 1, 22000.00, 0),
(2648, 449, 20, 4, 13000.00, 0),
(2649, 452, 26, 4, 20000.00, 0),
(2650, 452, 5, 2, 10000.00, 0),
(2651, 453, 122, 1, 27500.00, 0),
(2652, 453, 46, 1, 22000.00, 0),
(2653, 454, 47, 1, 27500.00, 0),
(2654, 450, 26, 1, 20000.00, 0),
(2655, 455, 26, 1, 20000.00, 0),
(2656, 455, 89, 2, 12000.00, 0),
(2657, 455, 8, 1, 7000.00, 0),
(2658, 455, 18, 1, 10000.00, 0),
(2659, 457, 1, 1, 38000.00, 0),
(2660, 457, 47, 1, 27500.00, 0),
(2661, 458, 1, 1, 38000.00, 0),
(2662, 465, 70, 1, 10000.00, 0),
(2663, 465, 32, 1, 16000.00, 0),
(2664, 465, 15, 1, 10000.00, 0),
(2665, 465, 115, 1, 15000.00, 0),
(2666, 465, 11, 1, 8000.00, 0),
(2667, 466, 89, 1, 12000.00, 0),
(2668, 466, 5, 1, 10000.00, 0),
(2669, 466, 8, 1, 7000.00, 0),
(2670, 466, 10, 1, 8000.00, 0),
(2671, 466, 115, 1, 15000.00, 0),
(2672, 466, 18, 1, 10000.00, 0),
(2673, 472, 8, 1, 7000.00, 0),
(2674, 472, 10, 1, 8000.00, 0),
(2675, 472, 11, 1, 8000.00, 0),
(2676, 471, 15, 1, 10000.00, 0),
(2678, 470, 15, 1, 10000.00, 0),
(2679, 463, 98, 1, 15000.00, 0),
(2680, 463, 26, 1, 20000.00, 0),
(2681, 463, 18, 1, 10000.00, 0),
(2682, 460, 26, 1, 20000.00, 0),
(2683, 460, 18, 1, 10000.00, 0),
(2684, 460, 98, 1, 15000.00, 0),
(2685, 459, 5, 2, 10000.00, 0),
(2686, 478, 58, 10, 9000.00, 0),
(2687, 461, 26, 4, 20000.00, 0),
(2688, 461, 18, 1, 10000.00, 0),
(2689, 461, 70, 1, 10000.00, 0),
(2690, 479, 18, 4, 9500.00, 0),
(2691, 479, 8, 2, 6500.00, 0),
(2692, 479, 9, 3, 6500.00, 0),
(2693, 479, 10, 2, 7500.00, 0),
(2694, 479, 6, 2, 9500.00, 0),
(2695, 479, 15, 5, 9500.00, 0),
(2696, 479, 89, 1, 11500.00, 0),
(2697, 479, 11, 2, 7500.00, 0),
(2698, 479, 5, 2, 9500.00, 0),
(2699, 479, 1, 1, 30000.00, 0),
(2700, 480, 8, 1, 7000.00, 0),
(2701, 480, 10, 1, 8000.00, 0),
(2702, 480, 9, 1, 7000.00, 0),
(2703, 480, 5, 1, 10000.00, 0),
(2704, 480, 12, 1, 10000.00, 0),
(2705, 480, 89, 1, 12000.00, 0),
(2706, 480, 70, 1, 10000.00, 0),
(2707, 480, 15, 1, 10000.00, 0),
(2708, 480, 18, 1, 10000.00, 0),
(2709, 481, 26, 2, 20000.00, 0),
(2710, 481, 119, 2, 18000.00, 0),
(2711, 481, 122, 1, 27500.00, 0),
(2712, 482, 47, 1, 27500.00, 0),
(2713, 482, 5, 1, 10000.00, 0),
(2714, 483, 119, 2, 18000.00, 0),
(2715, 483, 22, 5, 13000.00, 0),
(2716, 484, 6, 1, 10000.00, 0),
(2717, 484, 7, 1, 9000.00, 0),
(2718, 484, 12, 1, 10000.00, 0),
(2719, 485, 26, 3, 20000.00, 0),
(2720, 485, 119, 2, 18000.00, 0),
(2721, 485, 89, 1, 12000.00, 0),
(2722, 485, 18, 1, 10000.00, 0),
(2723, 485, 5, 1, 10000.00, 0),
(2724, 485, 15, 1, 10000.00, 0),
(2725, 486, 5, 1, 10000.00, 0),
(2726, 486, 11, 1, 8000.00, 0),
(2729, 487, 26, 2, 20000.00, 0),
(2730, 488, 119, 2, 18000.00, 0),
(2732, 490, 10, 21, 8000.00, 0),
(2733, 490, 6, 2, 10000.00, 0),
(2734, 490, 11, 1, 8000.00, 0),
(2735, 490, 16, 1, 10000.00, 0),
(2736, 492, 8, 1, 7000.00, 0),
(2737, 492, 10, 1, 8000.00, 0),
(2738, 493, 47, 2, 27500.00, 0),
(2739, 494, 47, 1, 27500.00, 0),
(2740, 494, 115, 1, 15000.00, 0),
(2743, 496, 5, 1, 10000.00, 0),
(2744, 496, 18, 1, 10000.00, 0),
(2745, 496, 9, 1, 7000.00, 0),
(2746, 495, 26, 3, 20000.00, 0),
(2747, 495, 5, 1, 10000.00, 0),
(2748, 497, 123, 2, 22000.00, 0),
(2749, 497, 46, 1, 20000.00, 0),
(2750, 498, 20, 2, 13000.00, 0),
(2751, 498, 7, 1, 9000.00, 0),
(2752, 498, 89, 1, 12000.00, 0),
(2753, 498, 15, 1, 10000.00, 0),
(2754, 498, 9, 1, 7000.00, 0),
(2755, 498, 8, 1, 7000.00, 0),
(2756, 498, 12, 1, 10000.00, 0),
(2757, 499, 8, 20, 7000.00, 0),
(2758, 499, 11, 20, 8000.00, 0),
(2759, 500, 26, 11, 20000.00, 0),
(2760, 501, 8, 1, 7000.00, 0),
(2761, 501, 9, 1, 7000.00, 0),
(2780, 502, 26, 4, 20000.00, 0),
(2781, 502, 6, 1, 10000.00, 0),
(2782, 502, 15, 1, 10000.00, 0),
(2783, 502, 5, 1, 10000.00, 0),
(2784, 502, 12, 1, 10000.00, 0),
(2785, 502, 82, 1, 12000.00, 0),
(2786, 502, 47, 2, 27500.00, 0),
(2787, 502, 119, 4, 18000.00, 0),
(2788, 502, 23, 2, 13000.00, 0),
(2789, 502, 22, 2, 13000.00, 0),
(2795, 503, 122, 1, 27500.00, 0),
(2796, 503, 119, 2, 18000.00, 0),
(2797, 503, 10, 1, 8000.00, 0),
(2798, 503, 18, 1, 10000.00, 0),
(2799, 503, 5, 1, 10000.00, 0),
(2800, 504, 26, 3, 20000.00, 0),
(2801, 504, 5, 2, 10000.00, 0),
(2802, 504, 89, 2, 12000.00, 0),
(2803, 504, 45, 1, 20000.00, 0),
(2804, 504, 10, 1, 8000.00, 0),
(2805, 504, 98, 1, 15000.00, 0),
(2806, 505, 26, 3, 20000.00, 0),
(2807, 505, 5, 3, 10000.00, 0),
(2808, 505, 10, 1, 8000.00, 0),
(2813, 506, 26, 1, 20000.00, 0),
(2814, 506, 8, 3, 7000.00, 0),
(2815, 506, 16, 1, 10000.00, 0),
(2816, 506, 18, 1, 10000.00, 0),
(2817, 507, 26, 5, 20000.00, 0),
(2818, 508, 8, 6, 7000.00, 0),
(2819, 508, 9, 6, 7000.00, 0),
(2820, 509, 8, 2, 7000.00, 0),
(2821, 509, 22, 2, 13000.00, 0),
(2822, 509, 23, 1, 13000.00, 0),
(2823, 509, 26, 2, 20000.00, 0),
(2824, 510, 26, 1, 20000.00, 0),
(2825, 510, 16, 1, 10000.00, 0),
(2826, 510, 8, 1, 7000.00, 0),
(2827, 510, 11, 1, 8000.00, 0),
(2828, 510, 32, 2, 16000.00, 0),
(2829, 510, 45, 1, 20000.00, 0),
(2830, 511, 20, 2, 13000.00, 0),
(2831, 511, 23, 1, 13000.00, 0),
(2835, 513, 115, 1, 15000.00, 0),
(2836, 513, 18, 1, 10000.00, 0),
(2837, 513, 6, 1, 10000.00, 0),
(2838, 513, 70, 1, 10000.00, 0),
(2843, 513, 89, 1, 12000.00, 0),
(2845, 513, 7, 1, 9000.00, 0),
(2847, 513, 15, 1, 10000.00, 0),
(2849, 512, 26, 3, 20000.00, 0),
(2850, 512, 5, 2, 10000.00, 0),
(2851, 512, 119, 1, 18000.00, 0),
(2852, 512, 32, 2, 16000.00, 0),
(2853, 515, 18, 4, 9500.00, 0),
(2854, 515, 8, 3, 6500.00, 0),
(2855, 515, 9, 3, 6500.00, 0),
(2856, 515, 10, 2, 7500.00, 0),
(2857, 515, 6, 2, 9500.00, 0),
(2858, 515, 89, 1, 11500.00, 0),
(2859, 515, 11, 2, 7500.00, 0),
(2860, 515, 5, 2, 9500.00, 0),
(2866, 469, 16, 1, 10000.00, 0),
(2867, 469, 8, 14, 7000.00, 0);
INSERT INTO `sales_items` (`id`, `sales_id`, `product_id`, `quantity`, `price_each`, `discount`) VALUES
(2868, 469, 4, 3, 70000.00, 0),
(2869, 469, 1, 2, 35000.00, 0),
(2870, 469, 8, 30, 7000.00, 0),
(2871, 469, 11, 2, 8000.00, 0),
(2872, 469, 10, 2, 8000.00, 0),
(2873, 469, 18, 4, 10000.00, 0),
(2874, 469, 7, 1, 9000.00, 0),
(2875, 516, 32, 2, 16000.00, 0),
(2876, 516, 26, 1, 20000.00, 0),
(2877, 517, 119, 2, 18000.00, 0),
(2878, 517, 26, 2, 20000.00, 0),
(2879, 518, 20, 2, 13000.00, 0),
(2880, 518, 10, 1, 8000.00, 0),
(2881, 518, 18, 1, 10000.00, 0),
(2882, 519, 9, 1, 7000.00, 0),
(2883, 519, 10, 1, 8000.00, 0),
(2884, 519, 20, 2, 13000.00, 0),
(2885, 519, 22, 1, 13000.00, 0),
(2886, 519, 23, 1, 13000.00, 0),
(2894, 521, 32, 2, 16000.00, 0),
(2895, 521, 31, 1, 16000.00, 0),
(2896, 522, 120, 2, 20000.00, 0),
(2897, 520, 5, 1, 10000.00, 0),
(2898, 520, 10, 1, 8000.00, 0),
(2899, 520, 8, 1, 7000.00, 0),
(2900, 520, 12, 1, 10000.00, 0),
(2901, 520, 16, 1, 10000.00, 0),
(2902, 520, 32, 1, 16000.00, 0),
(2903, 520, 120, 3, 20000.00, 0),
(2904, 523, 120, 3, 20000.00, 0),
(2905, 523, 20, 2, 13000.00, 0),
(2906, 523, 22, 2, 13000.00, 0),
(2907, 523, 45, 1, 20000.00, 0),
(2908, 523, 46, 1, 20000.00, 0),
(2909, 524, 26, 2, 20000.00, 0),
(2910, 525, 26, 1, 20000.00, 0),
(2911, 525, 5, 2, 10000.00, 0),
(2912, 525, 6, 1, 10000.00, 0),
(2931, 529, 8, 1, 7000.00, 0),
(2937, 531, 119, 2, 18000.00, 0),
(2938, 531, 26, 2, 20000.00, 0),
(2939, 531, 122, 1, 27500.00, 0),
(2944, 527, 8, 6, 7000.00, 0),
(2945, 527, 18, 3, 10000.00, 0),
(2946, 527, 15, 3, 10000.00, 0),
(2947, 527, 20, 1, 13000.00, 0),
(2948, 530, 18, 1, 10000.00, 0),
(2949, 530, 70, 1, 10000.00, 0),
(2950, 530, 15, 1, 10000.00, 0),
(2951, 530, 11, 1, 8000.00, 0),
(2952, 530, 117, 2, 15000.00, 0),
(2953, 528, 47, 1, 27500.00, 0),
(2954, 528, 82, 1, 12000.00, 0),
(2955, 528, 5, 1, 10000.00, 0),
(2959, 533, 16, 1, 10000.00, 0),
(2960, 533, 45, 1, 20000.00, 0),
(2961, 533, 26, 1, 20000.00, 0),
(2962, 533, 82, 1, 12000.00, 0),
(2963, 534, 120, 2, 20000.00, 0),
(2964, 534, 26, 2, 20000.00, 0),
(2965, 535, 26, 10, 18000.00, 0),
(2970, 537, 8, 3, 7000.00, 0),
(2971, 537, 15, 1, 10000.00, 0),
(2972, 537, 13, 1, 10000.00, 0),
(2973, 537, 5, 1, 10000.00, 0),
(2974, 537, 18, 1, 10000.00, 0),
(2975, 537, 6, 1, 10000.00, 0),
(2976, 537, 12, 1, 10000.00, 0),
(2977, 536, 117, 3, 15000.00, 0),
(2978, 536, 9, 1, 7000.00, 0),
(2979, 536, 16, 1, 10000.00, 0),
(2980, 536, 70, 1, 10000.00, 0),
(2981, 538, 32, 2, 16000.00, 0),
(2982, 539, 58, 1, 20000.00, 0),
(2983, 540, 26, 2, 20000.00, 0),
(2984, 540, 46, 1, 20000.00, 0),
(2985, 540, 45, 1, 20000.00, 0),
(2990, 542, 26, 3, 20000.00, 0),
(2991, 542, 120, 2, 20000.00, 0),
(2992, 542, 20, 1, 13000.00, 0),
(2993, 542, 22, 1, 13000.00, 0),
(2994, 542, 23, 2, 13000.00, 0),
(2995, 543, 5, 1, 10000.00, 0),
(2996, 543, 12, 1, 10000.00, 0),
(2997, 543, 82, 1, 12000.00, 0),
(2998, 543, 89, 1, 12000.00, 0),
(2999, 541, 115, 1, 15000.00, 0),
(3000, 541, 16, 1, 10000.00, 0),
(3001, 544, 58, 10, 18000.00, 0),
(3026, 545, 26, 2, 20000.00, 0),
(3027, 547, 32, 2, 16000.00, 0),
(3028, 547, 5, 2, 10000.00, 0),
(3029, 547, 6, 2, 10000.00, 0),
(3039, 548, 23, 2, 13000.00, 0),
(3040, 548, 26, 1, 20000.00, 0),
(3041, 548, 8, 1, 7000.00, 0),
(3042, 548, 10, 1, 8000.00, 0),
(3043, 548, 47, 1, 27500.00, 0),
(3044, 548, 45, 1, 22000.00, 0),
(3045, 548, 32, 2, 16000.00, 0),
(3046, 548, 5, 2, 10000.00, 0),
(3061, 551, 15, 4, 10000.00, 0),
(3062, 552, 26, 1, 20000.00, 0),
(3063, 552, 5, 2, 10000.00, 0),
(3064, 552, 15, 1, 10000.00, 0),
(3065, 552, 8, 1, 7000.00, 0),
(3066, 553, 6, 1, 10000.00, 0),
(3067, 553, 115, 1, 15000.00, 0),
(3068, 553, 22, 1, 13000.00, 0),
(3069, 554, 26, 2, 20000.00, 0),
(3070, 554, 32, 2, 16000.00, 0),
(3071, 554, 18, 1, 10000.00, 0),
(3072, 554, 46, 1, 20000.00, 0),
(3073, 554, 45, 1, 20000.00, 0),
(3074, 555, 15, 1, 10000.00, 0),
(3075, 555, 5, 1, 10000.00, 0),
(3080, 557, 26, 2, 20000.00, 0),
(3081, 557, 45, 1, 20000.00, 0),
(3082, 557, 47, 1, 27500.00, 0),
(3083, 557, 22, 2, 13000.00, 0),
(3084, 558, 26, 2, 20000.00, 0),
(3085, 558, 31, 2, 16000.00, 0),
(3086, 558, 32, 1, 16000.00, 0),
(3087, 559, 12, 1, 10000.00, 0),
(3088, 559, 89, 1, 12000.00, 0),
(3089, 559, 5, 1, 10000.00, 0),
(3090, 559, 11, 1, 8000.00, 0),
(3091, 559, 8, 1, 7000.00, 0),
(3092, 559, 9, 1, 7000.00, 0),
(3093, 559, 18, 1, 10000.00, 0),
(3094, 559, 82, 1, 12000.00, 0),
(3095, 560, 124, 1, 9000.00, 0),
(3096, 560, 16, 2, 10000.00, 0),
(3097, 560, 8, 3, 7000.00, 0),
(3098, 560, 10, 3, 8000.00, 0),
(3099, 560, 7, 1, 9000.00, 0),
(3100, 560, 26, 1, 20000.00, 0),
(3101, 560, 20, 2, 13000.00, 0),
(3102, 560, 21, 1, 13000.00, 0),
(3103, 561, 16, 1, 10000.00, 0),
(3104, 561, 26, 2, 20000.00, 0),
(3105, 561, 20, 1, 13000.00, 0),
(3106, 562, 26, 3, 20000.00, 0),
(3107, 562, 8, 2, 7000.00, 0),
(3108, 562, 5, 1, 10000.00, 0),
(3109, 563, 8, 1, 7000.00, 0),
(3110, 563, 5, 1, 10000.00, 0),
(3111, 564, 10, 160, 7500.00, 0),
(3112, 564, 11, 4, 7500.00, 0),
(3113, 564, 10, 4, 7500.00, 0),
(3114, 564, 18, 6, 9500.00, 0),
(3115, 564, 89, 2, 11500.00, 0),
(3116, 564, 11, 3, 7500.00, 0),
(3117, 564, 12, 2, 9500.00, 0),
(3118, 564, 10, 3, 7500.00, 0),
(3119, 564, 18, 1, 9500.00, 0),
(3120, 565, 5, 1, 10000.00, 0),
(3121, 565, 15, 1, 10000.00, 0),
(3122, 565, 18, 1, 10000.00, 0),
(3123, 565, 7, 1, 9000.00, 0),
(3124, 565, 25, 2, 12000.00, 0),
(3125, 566, 5, 1, 10000.00, 0),
(3126, 566, 8, 1, 7000.00, 0),
(3127, 566, 10, 2, 8000.00, 0),
(3128, 567, 8, 3, 7000.00, 0),
(3129, 567, 9, 1, 7000.00, 0),
(3130, 567, 18, 1, 10000.00, 0),
(3131, 567, 33, 1, 16000.00, 0),
(3132, 568, 26, 2, 20000.00, 0),
(3133, 568, 32, 1, 16000.00, 0),
(3134, 568, 33, 1, 16000.00, 0),
(3135, 568, 58, 1, 10000.00, 0),
(3147, 570, 26, 1, 20000.00, 0),
(3148, 570, 5, 1, 10000.00, 0),
(3149, 570, 16, 1, 10000.00, 0),
(3150, 570, 22, 1, 13000.00, 0),
(3151, 570, 23, 1, 13000.00, 0),
(3152, 570, 15, 1, 10000.00, 0),
(3153, 570, 125, 1, 15000.00, 0),
(3154, 571, 26, 1, 20000.00, 0),
(3155, 572, 26, 1, 20000.00, 0),
(3156, 572, 18, 1, 10000.00, 0),
(3157, 572, 8, 1, 7000.00, 0),
(3158, 572, 20, 2, 13000.00, 0),
(3159, 573, 26, 2, 20000.00, 0),
(3160, 574, 26, 1, 20000.00, 0),
(3161, 574, 32, 1, 16000.00, 0),
(3162, 574, 33, 1, 16000.00, 0),
(3163, 574, 10, 1, 8000.00, 0),
(3164, 574, 70, 1, 10000.00, 0),
(3165, 574, 16, 1, 10000.00, 0),
(3166, 575, 20, 2, 13000.00, 0),
(3167, 575, 22, 1, 13000.00, 0),
(3168, 576, 8, 2, 7000.00, 0),
(3169, 577, 8, 1, 7000.00, 0),
(3170, 577, 9, 1, 7000.00, 0),
(3171, 577, 10, 1, 8000.00, 0),
(3172, 578, 5, 2, 10000.00, 0),
(3173, 578, 11, 1, 8000.00, 0),
(3174, 578, 70, 1, 10000.00, 0),
(3175, 578, 9, 1, 7000.00, 0),
(3176, 578, 12, 1, 10000.00, 0),
(3177, 578, 7, 1, 9000.00, 0),
(3178, 579, 26, 2, 20000.00, 0),
(3183, 580, 26, 1, 20000.00, 0),
(3184, 580, 89, 1, 12000.00, 0),
(3185, 580, 5, 1, 10000.00, 0),
(3186, 580, 125, 1, 15000.00, 0),
(3187, 581, 10, 1, 8000.00, 0),
(3188, 581, 18, 1, 10000.00, 0),
(3189, 581, 15, 1, 10000.00, 0),
(3190, 581, 32, 1, 16000.00, 0),
(3191, 581, 33, 1, 16000.00, 0),
(3192, 582, 18, 1, 10000.00, 0),
(3193, 582, 47, 1, 27500.00, 0),
(3194, 583, 26, 1, 20000.00, 0),
(3195, 583, 32, 2, 16000.00, 0),
(3196, 584, 5, 2, 10000.00, 0),
(3197, 584, 82, 1, 12000.00, 0),
(3198, 584, 8, 1, 7000.00, 0),
(3199, 584, 10, 2, 8000.00, 0),
(3200, 585, 22, 2, 13000.00, 0),
(3201, 585, 23, 2, 13000.00, 0),
(3202, 586, 26, 1, 20000.00, 0),
(3203, 586, 115, 1, 15000.00, 0),
(3204, 586, 18, 1, 10000.00, 0),
(3205, 587, 26, 2, 20000.00, 0),
(3206, 587, 8, 1, 7000.00, 0),
(3207, 587, 5, 1, 10000.00, 0),
(3208, 588, 8, 1, 7000.00, 0),
(3209, 588, 18, 1, 10000.00, 0),
(3210, 589, 5, 1, 10000.00, 0),
(3211, 589, 70, 1, 10000.00, 0),
(3212, 590, 82, 1, 12000.00, 0),
(3213, 591, 7, 1, 9000.00, 0),
(3214, 591, 8, 1, 7000.00, 0),
(3215, 591, 115, 1, 15000.00, 0),
(3216, 591, 15, 1, 10000.00, 0),
(3217, 591, 6, 1, 10000.00, 0),
(3218, 592, 26, 2, 20000.00, 0),
(3219, 592, 32, 2, 16000.00, 0),
(3224, 593, 6, 1, 10000.00, 0),
(3225, 593, 9, 1, 7000.00, 0),
(3226, 593, 7, 1, 9000.00, 0),
(3227, 593, 20, 2, 13000.00, 0),
(3228, 593, 26, 2, 20000.00, 0),
(3229, 594, 45, 1, 20000.00, 0),
(3230, 594, 122, 1, 27500.00, 0),
(3231, 594, 115, 2, 15000.00, 0),
(3232, 594, 89, 1, 12000.00, 0),
(3233, 595, 8, 2, 7000.00, 0),
(3234, 595, 10, 1, 8000.00, 0),
(3235, 595, 11, 1, 8000.00, 0),
(3236, 596, 5, 1, 10000.00, 0),
(3237, 596, 15, 1, 10000.00, 0),
(3238, 596, 16, 1, 10000.00, 0),
(3239, 596, 12, 1, 10000.00, 0),
(3240, 596, 22, 2, 13000.00, 0),
(3241, 596, 32, 1, 16000.00, 0),
(3242, 597, 8, 3, 7000.00, 0),
(3243, 597, 9, 1, 7000.00, 0),
(3244, 597, 10, 3, 8000.00, 0),
(3245, 597, 11, 1, 8000.00, 0),
(3246, 597, 5, 2, 10000.00, 0),
(3247, 597, 18, 2, 10000.00, 0),
(3248, 597, 16, 1, 10000.00, 0),
(3249, 597, 115, 1, 15000.00, 0),
(3250, 597, 82, 1, 12000.00, 0),
(3251, 597, 12, 1, 10000.00, 0),
(3252, 597, 89, 1, 12000.00, 0),
(3253, 597, 7, 1, 9000.00, 0),
(3254, 597, 6, 1, 10000.00, 0),
(3255, 597, 70, 1, 10000.00, 0),
(3256, 597, 15, 1, 10000.00, 0),
(3257, 598, 18, 2, 10000.00, 0),
(3289, 600, 26, 1, 20000.00, 0),
(3290, 600, 32, 1, 16000.00, 0),
(3291, 600, 20, 2, 13000.00, 0),
(3292, 601, 26, 2, 20000.00, 0),
(3293, 601, 23, 2, 13000.00, 0),
(3294, 601, 22, 1, 13000.00, 0);

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

--
-- Table structure for table `sale_items`
--

CREATE TABLE `sale_items` (
  `id` int NOT NULL,
  `sales_id` int DEFAULT NULL,
  `product_id` int DEFAULT NULL,
  `quantity` int DEFAULT NULL,
  `price_each` int DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

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

--
-- Table structure for table `stock_in`
--

CREATE TABLE `stock_in` (
  `id` int NOT NULL,
  `product_id` int NOT NULL,
  `quantity` int NOT NULL,
  `date` date NOT NULL,
  `note` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

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

--
-- Table structure for table `stock_movements`
--

CREATE TABLE `stock_movements` (
  `id` int NOT NULL,
  `product_id` int NOT NULL,
  `movement_type` enum('masuk','keluar') CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `quantity` int NOT NULL,
  `description` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

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

--
-- Table structure for table `stock_out`
--

CREATE TABLE `stock_out` (
  `id` int NOT NULL,
  `product_id` int NOT NULL,
  `quantity` int NOT NULL,
  `date` date NOT NULL,
  `note` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

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

--
-- Table structure for table `supplier`
--

CREATE TABLE `supplier` (
  `id` int NOT NULL,
  `name` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `supplier`
--

INSERT INTO `supplier` (`id`, `name`) VALUES
(1, 'Louvel Kitchen'),
(2, 'Mochi A Yani'),
(4, 'Bandeng Suyudono'),
(5, 'Symphony Teabar');

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

--
-- Table structure for table `transactions`
--

CREATE TABLE `transactions` (
  `id` int NOT NULL,
  `reseller_id` int DEFAULT NULL,
  `total` decimal(10,2) NOT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

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

--
-- Table structure for table `transaction_items`
--

CREATE TABLE `transaction_items` (
  `id` int NOT NULL,
  `transaction_id` int NOT NULL,
  `product_id` int NOT NULL,
  `quantity` int NOT NULL,
  `price` decimal(10,2) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

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

--
-- Table structure for table `users`
--

CREATE TABLE `users` (
  `id` int NOT NULL,
  `username` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `password` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `role` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `users`
--

INSERT INTO `users` (`id`, `username`, `password`, `role`, `created_at`) VALUES
(12, 'admin', '$2y$10$XgP8oOBd0Xp5L9CWdAPKtuUGG1TBcGFrY.2fzwh8RDfn84Z9fvfa6', 'Admin', '2025-08-23 09:27:27');

--
-- Indexes for dumped tables
--

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

--
-- Indexes for table `products`
--
ALTER TABLE `products`
  ADD PRIMARY KEY (`id`),
  ADD KEY `fk_supplier` (`supplier_id`),
  ADD KEY `fk_kategori` (`kategori_id`);

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

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

--
-- Indexes for table `sales_items`
--
ALTER TABLE `sales_items`
  ADD PRIMARY KEY (`id`),
  ADD KEY `sale_id` (`sales_id`),
  ADD KEY `product_id` (`product_id`);

--
-- Indexes for table `sale_items`
--
ALTER TABLE `sale_items`
  ADD PRIMARY KEY (`id`),
  ADD KEY `sale_id` (`sales_id`),
  ADD KEY `product_id` (`product_id`);

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

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

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

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

--
-- Indexes for table `transactions`
--
ALTER TABLE `transactions`
  ADD PRIMARY KEY (`id`),
  ADD KEY `reseller_id` (`reseller_id`);

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

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

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `kategori`
--
ALTER TABLE `kategori`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;

--
-- AUTO_INCREMENT for table `products`
--
ALTER TABLE `products`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=127;

--
-- AUTO_INCREMENT for table `resellers`
--
ALTER TABLE `resellers`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `sales`
--
ALTER TABLE `sales`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=602;

--
-- AUTO_INCREMENT for table `sales_items`
--
ALTER TABLE `sales_items`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3295;

--
-- AUTO_INCREMENT for table `sale_items`
--
ALTER TABLE `sale_items`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;

--
-- AUTO_INCREMENT for table `stock_in`
--
ALTER TABLE `stock_in`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `stock_movements`
--
ALTER TABLE `stock_movements`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `stock_out`
--
ALTER TABLE `stock_out`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `supplier`
--
ALTER TABLE `supplier`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `transactions`
--
ALTER TABLE `transactions`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `transaction_items`
--
ALTER TABLE `transaction_items`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `users`
--
ALTER TABLE `users`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `products`
--
ALTER TABLE `products`
  ADD CONSTRAINT `fk_kategori` FOREIGN KEY (`kategori_id`) REFERENCES `kategori` (`id`),
  ADD CONSTRAINT `fk_supplier` FOREIGN KEY (`supplier_id`) REFERENCES `supplier` (`id`);

--
-- Constraints for table `sales_items`
--
ALTER TABLE `sales_items`
  ADD CONSTRAINT `sales_items_ibfk_1` FOREIGN KEY (`sales_id`) REFERENCES `sales` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `sales_items_ibfk_2` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `sale_items`
--
ALTER TABLE `sale_items`
  ADD CONSTRAINT `sale_items_ibfk_1` FOREIGN KEY (`sales_id`) REFERENCES `sales` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `sale_items_ibfk_2` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`);

--
-- Constraints for table `stock_in`
--
ALTER TABLE `stock_in`
  ADD CONSTRAINT `stock_in_ibfk_1` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`);

--
-- Constraints for table `stock_movements`
--
ALTER TABLE `stock_movements`
  ADD CONSTRAINT `stock_movements_ibfk_1` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `stock_out`
--
ALTER TABLE `stock_out`
  ADD CONSTRAINT `stock_out_ibfk_1` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`);

--
-- Constraints for table `transactions`
--
ALTER TABLE `transactions`
  ADD CONSTRAINT `transactions_ibfk_1` FOREIGN KEY (`reseller_id`) REFERENCES `resellers` (`id`);

--
-- Constraints for table `transaction_items`
--
ALTER TABLE `transaction_items`
  ADD CONSTRAINT `transaction_items_ibfk_1` FOREIGN KEY (`transaction_id`) REFERENCES `transactions` (`id`),
  ADD CONSTRAINT `transaction_items_ibfk_2` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`);
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 */;
