INSERT INTO `bill_records` (`id`, `bill_number`, `bill_date`, `bill_time`, `customer_phone`, `customer_id`, `total_amount`, `paid_amount`, `change_amount`, `is_credit`, `paymenttype`, `bill_content`, `items_json`, `created_at`) VALUES
(201, 52, '2025-11-20', NULL, NULL, NULL, 830.00, 5000.00, 4170.00, 0, 'cash', '<div class=\"bill-header\" style=\"padding-top: 0; margin-top: 0;\"><div style=\"text-align: center; margin-bottom: 8px; margin-top: 0; padding-top: 0;\"><img src=\"logo.png\" alt=\"Store Logo\" style=\"max-width: 100%; width: 95%; height: auto; max-height: 300px; margin-top: 0; margin-bottom: 6px; display: block; margin-left: auto; margin-right: auto; object-fit: contain; padding-top: 0;\"><h2 style=\"margin: 4px 0 0 0; font-size: 22px; font-weight: bold;\"></h2></div><p style=\"margin: 3px 0; font-size: 14px; text-align: center;\">පාසල අසල දොරපනේ</p><p style=\"margin: 3px 0; font-size: 14px; text-align: center;\">Tel: 071-3552017</p><p style=\"margin: 3px 0; font-size: 14px; text-align: center; font-weight: bold;\">බිල් අංකය: 52</p><p style=\"margin: 3px 0; font-size: 14px; text-align: center;\">Date: 20/11/2025 Time: 14:12:29</p><div style=\"margin: 4px 0; border-bottom: 1px dashed black; width: 100%;\"></div></div><div class=\"bill-items\" style=\"margin-bottom: 8px;\"><div class=\"bill-item\" style=\"margin-bottom: 1px;\"><div style=\"display: flex; justify-content: space-between; align-items: center; margin-bottom: 1px;\"><span style=\"font-size: 16px; font-weight: bold; flex: 1; line-height: 1.0;\">මැගී ෆැමිලි පැක්</span><span style=\"font-size: 16px; font-weight: bold; text-align: right;\">Rs.350.00</span></div><div style=\"display: flex; justify-content: space-between; font-size: 14px; font-weight: bold; color: #000000ff; margin-bottom: 5px; line-height: 1.1;\"><div style=\"line-height: 1.4;\"><div>සාමාන්‍ය මිල: Rs.350</div><div>අපේ මිල: Rs.350</div></div><div style=\"text-align: right; align-self: center; font-size: 12px;\">1.00 × Rs.350.00</div></div><div style=\"border-bottom: 1px dotted #000000ff; margin: 2px 0 2px 0; width: 100%;\"></div></div><div class=\"bill-item\" style=\"margin-bottom: 1px;\"><div style=\"display: flex; justify-content: space-between; align-items: center; margin-bottom: 1px;\"><span style=\"font-size: 16px; font-weight: bold; flex: 1; line-height: 1.0;\">පපඩම්</span><span style=\"font-size: 16px; font-weight: bold; text-align: right;\">Rs.200.00</span></div><div style=\"display: flex; justify-content: space-between; font-size: 14px; font-weight: bold; color: #000000ff; margin-bottom: 5px; line-height: 1.1;\"><div style=\"line-height: 1.4;\"><div>සාමාන්‍ය මිල: Rs.200</div><div>අපේ මිල: Rs.200</div></div><div style=\"text-align: right; align-self: center; font-size: 12px;\">2.00 × Rs.100.00</div></div><div style=\"border-bottom: 1px dotted #000000ff; margin: 2px 0 2px 0; width: 100%;\"></div></div><div class=\"bill-item\" style=\"margin-bottom: 1px;\"><div style=\"display: flex; justify-content: space-between; align-items: center; margin-bottom: 1px;\"><span style=\"font-size: 16px; font-weight: bold; flex: 1; line-height: 1.0;\">කජු</span><span style=\"font-size: 16px; font-weight: bold; text-align: right;\">Rs.280.00</span></div><div style=\"display: flex; justify-content: space-between; font-size: 14px; font-weight: bold; color: #000000ff; margin-bottom: 5px; line-height: 1.1;\"><div style=\"line-height: 1.4;\"><div>සාමාන්‍ය මිල: Rs.300</div><div>අපේ මිල: Rs.280</div></div><div style=\"text-align: right; align-self: center; font-size: 12px;\">0.20 × Rs.1400.00</div></div></div></div><div class=\"bill-summary\" style=\"text-align: right; font-size: 15px; margin-bottom: 4px;\"><div style=\"margin: 6px 0; font-weight: bold; font-size: 28px;\">මුළු මුදල: Rs. 830.00</div><div style=\"margin: 4px 0; font-weight: bold;\">ගෙවූ මුදල: Rs. 5000.00</div><div style=\"margin: 4px 0; font-size: 14px; font-weight: bold;\">ඉතිරි මුදල: Rs. 4170.00</div><div style=\"border: 1px solid black; padding: 20px; margin-top: 8px; width: 100%; background-color: #ffffffff;\"><div style=\"text-align: center; font-size: 10px; font-weight: bold; line-height: 1.7;\">අපෙන් භාණ්ඩ ලබා ගැනීමෙන් ඔබ ලැබූ ලාභය<br><span style=\"font-size: 12px; color: #000000ff;\">Rs.20.00</span></div></div><div class=\"bill-footer\" style=\"text-align: center; font-size: 13px;\"><p style=\"margin: 4px 0; font-size: 15px;\">ස්තූතියි! නැවත එන්න</p><p style=\"margin: 6px 0; font-size: 12px;\">=== Gadget Technologies 071-1071666 ===</p></div>', '[{\"id\":286,\"item_name_sinhala\":\"මැගී ෆැමිලි පැක්\",\"item_name_english\":\"maggi\",\"barcode\":\"4792024019262\",\"unit_of_measurement\":\"pcs\",\"regular_price\":350,\"our_price\":350,\"stock_quantity\":50,\"quantity\":1},{\"id\":252,\"item_name_sinhala\":\"පපඩම්\",\"item_name_english\":\"papadam\",\"barcode\":\"135165947\",\"unit_of_measurement\":\"pcs\",\"regular_price\":100,\"our_price\":100,\"stock_quantity\":46,\"quantity\":2},{\"id\":314,\"item_name_sinhala\":\"කජු\",\"item_name_english\":\"kaju\",\"barcode\":\"234090712\",\"unit_of_measurement\":\"pcs\",\"regular_price\":1500,\"our_price\":1400,\"stock_quantity\":970,\"quantity\":0.2}]', '2025-11-20 08:42:29'),
(202, 50, '2025-11-21', NULL, NULL, NULL, 25980.00, 26000.00, 20.00, 0, 'cash', '<div class=\"bill-header\" style=\"padding-top: 0; margin-top: 0;\"><div style=\"text-align: center; margin-bottom: 8px; margin-top: 0; padding-top: 0;\"><img src=\"logo.png\" alt=\"Store Logo\" style=\"max-width: 100%; width: 95%; height: auto; max-height: 300px; margin-top: 0; margin-bottom: 6px; display: block; margin-left: auto; margin-right: auto; object-fit: contain; padding-top: 0;\"><h2 style=\"margin: 4px 0 0 0; font-size: 22px; font-weight: bold;\"></h2></div><p style=\"margin: 3px 0; font-size: 14px; text-align: center;\">පාසල අසල දොරපනේ</p><p style=\"margin: 3px 0; font-size: 14px; text-align: center;\">Tel: 071-3552017</p><p style=\"margin: 3px 0; font-size: 14px; text-align: center; font-weight: bold;\">බිල් අංකය: 50</p><p style=\"margin: 3px 0; font-size: 14px; text-align: center;\">Date: 21/11/2025 Time: 11:14:25</p><div style=\"margin: 4px 0; border-bottom: 1px dashed black; width: 100%;\"></div></div><div class=\"bill-items\" style=\"margin-bottom: 8px;\"><div class=\"bill-item\" style=\"margin-bottom: 1px;\"><div style=\"display: flex; justify-content: space-between; align-items: center; margin-bottom: 1px;\"><span style=\"font-size: 16px; font-weight: bold; flex: 1; line-height: 1.0;\">අල</span><span style=\"font-size: 16px; font-weight: bold; text-align: right;\">Rs.200.00</span></div><div style=\"display: flex; justify-content: space-between; font-size: 14px; font-weight: bold; color: #000000ff; margin-bottom: 5px; line-height: 1.1;\"><div style=\"line-height: 1.4;\"><div>සාමාන්‍ය මිල: Rs.210</div><div>අපේ මිල: Rs.200</div></div><div style=\"text-align: right; align-self: center; font-size: 12px;\">1.00 × Rs.200.00</div></div><div style=\"border-bottom: 1px dotted #000000ff; margin: 2px 0 2px 0; width: 100%;\"></div></div><div class=\"bill-item\" style=\"margin-bottom: 1px;\"><div style=\"display: flex; justify-content: space-between; align-items: center; margin-bottom: 1px;\"><span style=\"font-size: 16px; font-weight: bold; flex: 1; line-height: 1.0;\">බී ළුෑණු</span><span style=\"font-size: 16px; font-weight: bold; text-align: right;\">Rs.190.00</span></div><div style=\"display: flex; justify-content: space-between; font-size: 14px; font-weight: bold; color: #000000ff; margin-bottom: 5px; line-height: 1.1;\"><div style=\"line-height: 1.4;\"><div>සාමාන්‍ය මිල: Rs.200</div><div>අපේ මිල: Rs.190</div></div><div style=\"text-align: right; align-self: center; font-size: 12px;\">1.00 × Rs.190.00</div></div><div style=\"border-bottom: 1px dotted #000000ff; margin: 2px 0 2px 0; width: 100%;\"></div></div><div class=\"bill-item\" style=\"margin-bottom: 1px;\"><div style=\"display: flex; justify-content: space-between; align-items: center; margin-bottom: 1px;\"><span style=\"font-size: 16px; font-weight: bold; flex: 1; line-height: 1.0;\">රතු ළුණු</span><span style=\"font-size: 16px; font-weight: bold; text-align: right;\">Rs.200.00</span></div><div style=\"display: flex; justify-content: space-between; font-size: 14px; font-weight: bold; color: #000000ff; margin-bottom: 5px; line-height: 1.1;\"><div style=\"line-height: 1.4;\"><div>සාමාන්‍ය මිල: Rs.225</div><div>අපේ මිල: Rs.200</div></div><div style=\"text-align: right; align-self: center; font-size: 12px;\">0.50 × Rs.400.00</div></div><div style=\"border-bottom: 1px dotted #000000ff; margin: 2px 0 2px 0; width: 100%;\"></div></div><div class=\"bill-item\" style=\"margin-bottom: 1px;\"><div style=\"display: flex; justify-content: space-between; align-items: center; margin-bottom: 1px;\"><span style=\"font-size: 16px; font-weight: bold; flex: 1; line-height: 1.0;\">කරවල</span><span style=\"font-size: 16px; font-weight: bold; text-align: right;\">Rs.700.00</span></div><div style=\"display: flex; justify-content: space-between; font-size: 14px; font-weight: bold; color: #000000ff; margin-bottom: 5px; line-height: 1.1;\"><div style=\"line-height: 1.4;\"><div>සාමාන්‍ය මිල: Rs.700</div><div>අපේ මිල: Rs.700</div></div><div style=\"text-align: right; align-self: center; font-size: 12px;\">700.00 × Rs.1.00</div></div><div style=\"border-bottom: 1px dotted #000000ff; margin: 2px 0 2px 0; width: 100%;\"></div></div><div class=\"bill-item\" style=\"margin-bottom: 1px;\"><div style=\"display: flex; justify-content: space-between; align-items: center; margin-bottom: 1px;\"><span style=\"font-size: 16px; font-weight: bold; flex: 1; line-height: 1.0;\">පරිප්පු නො.1</span><span style=\"font-size: 16px; font-weight: bold; text-align: right;\">Rs.190.00</span></div><div style=\"display: flex; justify-content: space-between; font-size: 14px; font-weight: bold; color: #000000ff; margin-bottom: 5px; line-height: 1.1;\"><div style=\"line-height: 1.4;\"><div>සාමාන්‍ය මිල: Rs.200</div><div>අපේ මිල: Rs.190</div></div><div style=\"text-align: right; align-self: center; font-size: 12px;\">0.50 × Rs.380.00</div></div><div style=\"border-bottom: 1px dotted #000000ff; margin: 2px 0 2px 0; width: 100%;\"></div></div><div class=\"bill-item\" style=\"margin-bottom: 1px;\"><div style=\"display: flex; justify-content: space-between; align-items: center; margin-bottom: 1px;\"><span style=\"font-size: 16px; font-weight: bold; flex: 1; line-height: 1.0;\">කෑලි මිරිස්</span><span style=\"font-size: 16px; font-weight: bold; text-align: right;\">Rs.120.00</span></div><div style=\"display: flex; justify-content: space-between; font-size: 14px; font-weight: bold; color: #000000ff; margin-bottom: 5px; line-height: 1.1;\"><div style=\"line-height: 1.4;\"><div>සාමාන්‍ය මිල: Rs.120</div><div>අපේ මිල: Rs.120</div></div><div style=\"text-align: right; align-self: center; font-size: 12px;\">1.00 × Rs.120.00</div></div><div style=\"border-bottom: 1px dotted #000000ff; margin: 2px 0 2px 0; width: 100%;\"></div></div><div class=\"bill-item\" style=\"margin-bottom: 1px;\"><div style=\"display: flex; justify-content: space-between; align-items: center; margin-bottom: 1px;\"><span style=\"font-size: 16px; font-weight: bold; flex: 1; line-height: 1.0;\">ලුණු කැට</span><span style=\"font-size: 16px; font-weight: bold; text-align: right;\">Rs.150.00</span></div><div style=\"display: flex; justify-content: space-between; font-size: 14px; font-weight: bold; color: #000000ff; margin-bottom: 5px; line-height: 1.1;\"><div style=\"line-height: 1.4;\"><div>සාමාන්‍ය මිල: Rs.150</div><div>අපේ මිල: Rs.150</div></div><div style=\"text-align: right; align-self: center; font-size: 12px;\">1.00 × Rs.150.00</div></div><div style=\"border-bottom: 1px dotted #000000ff; margin: 2px 0 2px 0; width: 100%;\"></div></div><div class=\"bill-item\" style=\"margin-bottom: 1px;\"><div style=\"display: flex; justify-content: space-between; align-items: center; margin-bottom: 1px;\"><span style=\"font-size: 16px; font-weight: bold; flex: 1; line-height: 1.0;\">ලුණු කුඩු</span><span style=\"font-size: 16px; font-weight: bold; text-align: right;\">Rs.120.00</span></div><div style=\"display: flex; justify-content: space-between; font-size: 14px; font-weight: bold; color: #000000ff; margin-bottom: 5px; line-height: 1.1;\"><div style=\"line-height: 1.4;\"><div>සාමාන්‍ය මිල: Rs.120</div><div>අපේ මිල: Rs.120</div></div><div style=\"text-align: right; align-self: center; font-size: 12px;\">1.00 × Rs.120.00</div></div><div style=\"border-bottom: 1px dotted #000000ff; margin: 2px 0 2px 0; width: 100%;\"></div></div><div class=\"bill-item\" style=\"margin-bottom: 1px;\"><div style=\"display: flex; justify-content: space-between; align-items: center; margin-bottom: 1px;\"><span style=\"font-size: 16px; font-weight: bold; flex: 1; line-height: 1.0;\">උම්බලකඩ පවුඩර්</span><span style=\"font-size: 16px; font-weight: bold; text-align: right;\">Rs.130.00</span></div><div style=\"display: flex; justify-content: space-between; font-size: 14px; font-weight: bold; color: #000000ff; margin-bottom: 5px; line-height: 1.1;\"><div style=\"line-height: 1.4;\"><div>සාමාන්‍ය මිල: Rs.130</div><div>අපේ මිල: Rs.130</div></div><div style=\"text-align: right; align-self: center; font-size: 12px;\">2.00 × Rs.65.00</div></div><div style=\"border-bottom: 1px dotted #000000ff; margin: 2px 0 2px 0; width: 100%;\"></div></div><div class=\"bill-item\" style=\"margin-bottom: 1px;\"><div style=\"display: flex; justify-content: space-between; align-items: center; margin-bottom: 1px;\"><span style=\"font-size: 16px; font-weight: bold; flex: 1; line-height: 1.0;\">වෙනත්</span><span style=\"font-size: 16px; font-weight: bold; text-align: right;\">Rs.230.00</span></div><div style=\"display: flex; justify-content: space-between; font-size: 14px; font-weight: bold; color: #000000ff; margin-bottom: 5px; line-height: 1.1;\"><div style=\"line-height: 1.4;\"><div>සාමාන්‍ය මිල: Rs.230</div><div>අපේ මිල: Rs.230</div></div><div style=\"text-align: right; align-self: center; font-size: 12px;\">230.00 × Rs.1.00</div></div><div style=\"border-bottom: 1px dotted #000000ff; margin: 2px 0 2px 0; width: 100%;\"></div></div><div class=\"bill-item\" style=\"margin-bottom: 1px;\"><div style=\"display: flex; justify-content: space-between; align-items: center; margin-bottom: 1px;\"><span style=\"font-size: 16px; font-weight: bold; flex: 1; line-height: 1.0;\">හාල්</span><span style=\"font-size: 16px; font-weight: bold; text-align: right;\">Rs.23750.00</span></div><div style=\"display: flex; justify-content: space-between; font-size: 14px; font-weight: bold; color: #000000ff; margin-bottom: 5px; line-height: 1.1;\"><div style=\"line-height: 1.4;\"><div>සාමාන්‍ය මිල: Rs.23750</div><div>අපේ මිල: Rs.23750</div></div><div style=\"text-align: right; align-self: center; font-size: 12px;\">23750.00 × Rs.1.00</div></div></div></div><div class=\"bill-summary\" style=\"text-align: right; font-size: 15px; margin-bottom: 4px;\"><div style=\"margin: 6px 0; font-weight: bold; font-size: 28px;\">මුළු මුදල: Rs. 25980.00</div><div style=\"margin: 4px 0; font-weight: bold;\">ගෙවූ මුදල: Rs. 26000.00</div><div style=\"margin: 4px 0; font-size: 14px; font-weight: bold;\">ඉතිරි මුදල: Rs. 20.00</div><div style=\"border: 1px solid black; padding: 20px; margin-top: 8px; width: 100%; background-color: #ffffffff;\"><div style=\"text-align: center; font-size: 10px; font-weight: bold; line-height: 1.7;\">අපෙන් භාණ්ඩ ලබා ගැනීමෙන් ඔබ ලැබූ ලාභය<br><span style=\"font-size: 12px; color: #000000ff;\">Rs.55.00</span></div></div><div class=\"bill-footer\" style=\"text-align: center; font-size: 13px;\"><p style=\"margin: 4px 0; font-size: 15px;\">ස්තූතියි! නැවත එන්න</p><p style=\"margin: 6px 0; font-size: 12px;\">=== Gadget Technologies 071-1071666 ===</p></div>', '[{\"id\":104,\"item_name_sinhala\":\"අල\",\"item_name_english\":\"ala\",\"barcode\":\"004786426\",\"unit_of_measurement\":\"pcs\",\"regular_price\":210,\"our_price\":200,\"stock_quantity\":3994,\"quantity\":1},{\"id\":105,\"item_name_sinhala\":\"බී ළුෑණු\",\"item_name_english\":\"beeluunu\",\"barcode\":\"113943378\",\"unit_of_measurement\":\"kg\",\"regular_price\":200,\"our_price\":190,\"stock_quantity\":52,\"quantity\":1},{\"id\":106,\"item_name_sinhala\":\"රතු ළුණු\",\"item_name_english\":\"rathu\",\"barcode\":\"838150515\",\"unit_of_measurement\":\"kg\",\"regular_price\":450,\"our_price\":400,\"stock_quantity\":9,\"quantity\":0.5},{\"id\":112,\"item_name_sinhala\":\"කරවල\",\"item_name_english\":\"karawala\",\"barcode\":\"076194472\",\"unit_of_measurement\":\"pcs\",\"regular_price\":1,\"our_price\":1,\"stock_quantity\":2555,\"quantity\":700},{\"id\":108,\"item_name_sinhala\":\"පරිප්පු නො.1\",\"item_name_english\":\"parippu\",\"barcode\":\"965372777\",\"unit_of_measurement\":\"pcs\",\"regular_price\":400,\"our_price\":380,\"stock_quantity\":46,\"quantity\":0.5},{\"id\":223,\"item_name_sinhala\":\"කෑලි මිරිස්\",\"item_name_english\":\"miris\",\"barcode\":\"105072681\",\"unit_of_measurement\":\"pcs\",\"regular_price\":120,\"our_price\":120,\"stock_quantity\":4900,\"quantity\":1},{\"id\":135,\"item_name_sinhala\":\"ලුණු කැට\",\"item_name_english\":\"lunu\",\"barcode\":\"157117825\",\"unit_of_measurement\":\"pcs\",\"regular_price\":150,\"our_price\":150,\"stock_quantity\":4999,\"quantity\":1},{\"id\":136,\"item_name_sinhala\":\"ලුණු කුඩු\",\"item_name_english\":\"lunu\",\"barcode\":\"200705798\",\"unit_of_measurement\":\"pcs\",\"regular_price\":120,\"our_price\":120,\"stock_quantity\":5000,\"quantity\":1},{\"id\":151,\"item_name_sinhala\":\"උම්බලකඩ පවුඩර්\",\"item_name_english\":\"umbalakada\",\"barcode\":\"4796005673986\",\"unit_of_measurement\":\"pcs\",\"regular_price\":65,\"our_price\":65,\"stock_quantity\":200,\"quantity\":2},{\"id\":88,\"item_name_sinhala\":\"වෙනත්\",\"item_name_english\":\"we\",\"barcode\":\"045504190\",\"unit_of_measurement\":\"pcs\",\"regular_price\":1,\"our_price\":1,\"stock_quantity\":9.223372036854776e+18,\"quantity\":230},{\"id\":381,\"item_name_sinhala\":\"හාල්\",\"item_name_english\":\"hal\",\"barcode\":\"413138163\",\"unit_of_measurement\":\"pcs\",\"regular_price\":1,\"our_price\":1,\"stock_quantity\":50000,\"quantity\":23750}]', '2025-11-21 05:44:26'),
(203, 51, '2025-11-21', NULL, NULL, NULL, 23750.00, 2500.00, 0.00, 0, 'cash', '<div class=\"bill-header\" style=\"padding-top: 0; margin-top: 0;\"><div style=\"text-align: center; margin-bottom: 8px; margin-top: 0; padding-top: 0;\"><img src=\"logo.png\" alt=\"Store Logo\" style=\"max-width: 100%; width: 95%; height: auto; max-height: 300px; margin-top: 0; margin-bottom: 6px; display: block; margin-left: auto; margin-right: auto; object-fit: contain; padding-top: 0;\"><h2 style=\"margin: 4px 0 0 0; font-size: 22px; font-weight: bold;\"></h2></div><p style=\"margin: 3px 0; font-size: 14px; text-align: center;\">පාසල අසල දොරපනේ</p><p style=\"margin: 3px 0; font-size: 14px; text-align: center;\">Tel: 071-3552017</p><p style=\"margin: 3px 0; font-size: 14px; text-align: center; font-weight: bold;\">බිල් අංකය: 51</p><p style=\"margin: 3px 0; font-size: 14px; text-align: center;\">Date: 21/11/2025 Time: 11:25:30</p><div style=\"margin: 4px 0; border-bottom: 1px dashed black; width: 100%;\"></div></div><div class=\"bill-items\" style=\"margin-bottom: 8px;\"><div class=\"bill-item\" style=\"margin-bottom: 1px;\"><div style=\"display: flex; justify-content: space-between; align-items: center; margin-bottom: 1px;\"><span style=\"font-size: 16px; font-weight: bold; flex: 1; line-height: 1.0;\">හාල්</span><span style=\"font-size: 16px; font-weight: bold; text-align: right;\">Rs.23750.00</span></div><div style=\"display: flex; justify-content: space-between; font-size: 14px; font-weight: bold; color: #000000ff; margin-bottom: 5px; line-height: 1.1;\"><div style=\"line-height: 1.4;\"><div>සාමාන්‍ය මිල: Rs.24375</div><div>අපේ මිල: Rs.23750</div></div><div style=\"text-align: right; align-self: center; font-size: 12px;\">125.00 × Rs.190.00</div></div></div></div><div class=\"bill-summary\" style=\"text-align: right; font-size: 15px; margin-bottom: 4px;\"><div style=\"margin: 6px 0; font-weight: bold; font-size: 28px;\">මුළු මුදල: Rs. 23750.00</div><div style=\"margin: 4px 0; font-weight: bold;\">ගෙවූ මුදල: Rs. 2500.00</div><div style=\"margin: 4px 0; font-size: 14px; font-weight: bold;\">ඉතිරි මුදල: Rs. 0.00</div><div style=\"border: 1px solid black; padding: 20px; margin-top: 8px; width: 100%; background-color: #ffffffff;\"><div style=\"text-align: center; font-size: 10px; font-weight: bold; line-height: 1.7;\">අපෙන් භාණ්ඩ ලබා ගැනීමෙන් ඔබ ලැබූ ලාභය<br><span style=\"font-size: 12px; color: #000000ff;\">Rs.625.00</span></div></div><div class=\"bill-footer\" style=\"text-align: center; font-size: 13px;\"><p style=\"margin: 4px 0; font-size: 15px;\">ස්තූතියි! නැවත එන්න</p><p style=\"margin: 6px 0; font-size: 12px;\">=== Gadget Technologies 071-1071666 ===</p></div>', '[{\"id\":381,\"item_name_sinhala\":\"හාල්\",\"item_name_english\":\"hal\",\"barcode\":\"413138163\",\"unit_of_measurement\":\"pcs\",\"regular_price\":195,\"our_price\":190,\"stock_quantity\":2625045785,\"quantity\":125}]', '2025-11-21 05:55:30'),
(204, 52, '2025-11-21', NULL, NULL, NULL, 4500.00, 4500.00, 0.00, 0, 'cash', '<p style=\"margin: 3px 0; font-size: 14px; text-align: center; font-weight: bold;\">බිල් අංකය: 52</p><p style=\"margin: 3px 0; font-size: 14px; text-align: center;\">Date: 21/11/2025 Time: 11:52:05</p><div style=\"margin: 4px 0; border-bottom: 1px dashed black; width: 100%;\"></div></div><div class=\"bill-items\" style=\"margin-bottom: 8px;\"><div class=\"bill-item\" style=\"margin-bottom: 1px;\"><div style=\"display: flex; justify-content: space-between; align-items: center; margin-bottom: 1px;\"><span style=\"font-size: 16px; font-weight: bold; flex: 1; line-height: 1.0;\">සබන්</span><span style=\"font-size: 16px; font-weight: bold; text-align: right;\">Rs.580.00</span></div><div style=\"display: flex; justify-content: space-between; font-size: 14px; font-weight: bold; color: #000000ff; margin-bottom: 5px; line-height: 1.1;\"><div style=\"line-height: 1.4;\"><div>සාමාන්‍ය මිල: Rs.580</div><div>අපේ මිල: Rs.580</div></div><div style=\"text-align: right; align-self: center; font-size: 12px;\">580.00 × Rs.1.00</div></div><div style=\"border-bottom: 1px dotted #000000ff; margin: 2px 0 2px 0; width: 100%;\"></div></div><div class=\"bill-item\" style=\"margin-bottom: 1px;\"><div style=\"display: flex; justify-content: space-between; align-items: center; margin-bottom: 1px;\"><span style=\"font-size: 16px; font-weight: bold; flex: 1; line-height: 1.0;\">සිග්නල් දත් බුරුසු</span><span style=\"font-size: 16px; font-weight: bold; text-align: right;\">Rs.130.00</span></div><div style=\"display: flex; justify-content: space-between; font-size: 14px; font-weight: bold; color: #000000ff; margin-bottom: 5px; line-height: 1.1;\"><div style=\"line-height: 1.4;\"><div>සාමාන්‍ය මිල: Rs.130</div><div>අපේ මිල: Rs.130</div></div><div style=\"text-align: right; align-self: center; font-size: 12px;\">1.00 × Rs.130.00</div></div><div style=\"border-bottom: 1px dotted #000000ff; margin: 2px 0 2px 0; width: 100%;\"></div></div><div class=\"bill-item\" style=\"margin-bottom: 1px;\"><div style=\"display: flex; justify-content: space-between; align-items: center; margin-bottom: 1px;\"><span style=\"font-size: 16px; font-weight: bold; flex: 1; line-height: 1.0;\">රතු හාල්</span><span style=\"font-size: 16px; font-weight: bold; text-align: right;\">Rs.975.00</span></div><div style=\"display: flex; justify-content: space-between; font-size: 14px; font-weight: bold; color: #000000ff; margin-bottom: 5px; line-height: 1.1;\"><div style=\"line-height: 1.4;\"><div>සාමාන්‍ය මිල: Rs.1000</div><div>අපේ මිල: Rs.975</div></div><div style=\"text-align: right; align-self: center; font-size: 12px;\">5.00 × Rs.195.00</div></div><div style=\"border-bottom: 1px dotted #000000ff; margin: 2px 0 2px 0; width: 100%;\"></div></div><div class=\"bill-item\" style=\"margin-bottom: 1px;\"><div style=\"display: flex; justify-content: space-between; align-items: center; margin-bottom: 1px;\"><span style=\"font-size: 16px; font-weight: bold; flex: 1; line-height: 1.0;\">බේබි කොලොන්</span><span style=\"font-size: 16px; font-weight: bold; text-align: right;\">Rs.360.00</span></div><div style=\"display: flex; justify-content: space-between; font-size: 14px; font-weight: bold; color: #000000ff; margin-bottom: 5px; line-height: 1.1;\"><div style=\"line-height: 1.4;\"><div>සාමාන්‍ය මිල: Rs.360</div><div>අපේ මිල: Rs.360</div></div><div style=\"text-align: right; align-self: center; font-size: 12px;\">1.00 × Rs.360.00</div></div><div style=\"border-bottom: 1px dotted #000000ff; margin: 2px 0 2px 0; width: 100%;\"></div></div><div class=\"bill-item\" style=\"margin-bottom: 1px;\"><div style=\"display: flex; justify-content: space-between; align-items: center; margin-bottom: 1px;\"><span style=\"font-size: 16px; font-weight: bold; flex: 1; line-height: 1.0;\">තල</span><span style=\"font-size: 16px; font-weight: bold; text-align: right;\">Rs.200.00</span></div><div style=\"display: flex; justify-content: space-between; font-size: 14px; font-weight: bold; color: #000000ff; margin-bottom: 5px; line-height: 1.1;\"><div style=\"line-height: 1.4;\"><div>සාමාන්‍ය මිල: Rs.200</div><div>අපේ මිල: Rs.200</div></div><div style=\"text-align: right; align-self: center; font-size: 12px;\">1.00 × Rs.200.00</div></div><div style=\"border-bottom: 1px dotted #000000ff; margin: 2px 0 2px 0; width: 100%;\"></div></div><div class=\"bill-item\" style=\"margin-bottom: 1px;\"><div style=\"display: flex; justify-content: space-between; align-items: center; margin-bottom: 1px;\"><span style=\"font-size: 16px; font-weight: bold; flex: 1; line-height: 1.0;\">ප්‍රීමා නූඩ්ල්ස් ෆැමිලි පැක්</span><span style=\"font-size: 16px; font-weight: bold; text-align: right;\">Rs.370.00</span></div><div style=\"display: flex; justify-content: space-between; font-size: 14px; font-weight: bold; color: #000000ff; margin-bottom: 5px; line-height: 1.1;\"><div style=\"line-height: 1.4;\"><div>සාමාන්‍ය මිල: Rs.370</div><div>අපේ මිල: Rs.370</div></div><div style=\"text-align: right; align-self: center; font-size: 12px;\">1.00 × Rs.370.00</div></div><div style=\"border-bottom: 1px dotted #000000ff; margin: 2px 0 2px 0; width: 100%;\"></div></div><div class=\"bill-item\" style=\"margin-bottom: 1px;\"><div style=\"display: flex; justify-content: space-between; align-items: center; margin-bottom: 1px;\"><span style=\"font-size: 16px; font-weight: bold; flex: 1; line-height: 1.0;\">බේබි ෂැම්පු</span><span style=\"font-size: 16px; font-weight: bold; text-align: right;\">Rs.290.00</span></div><div style=\"display: flex; justify-content: space-between; font-size: 14px; font-weight: bold; color: #000000ff; margin-bottom: 5px; line-height: 1.1;\"><div style=\"line-height: 1.4;\"><div>සාමාන්‍ය මිල: Rs.290</div><div>අපේ මිල: Rs.290</div></div><div style=\"text-align: right; align-self: center; font-size: 12px;\">1.00 × Rs.290.00</div></div><div style=\"border-bottom: 1px dotted #000000ff; margin: 2px 0 2px 0; width: 100%;\"></div></div><div class=\"bill-item\" style=\"margin-bottom: 1px;\"><div style=\"display: flex; justify-content: space-between; align-items: center; margin-bottom: 1px;\"><span style=\"font-size: 16px; font-weight: bold; flex: 1; line-height: 1.0;\">කඩල</span><span style=\"font-size: 16px; font-weight: bold; text-align: right;\">Rs.480.00</span></div><div style=\"display: flex; justify-content: space-between; font-size: 14px; font-weight: bold; color: #000000ff; margin-bottom: 5px; line-height: 1.1;\"><div style=\"line-height: 1.4;\"><div>සාමාන්‍ය මිල: Rs.520</div><div>අපේ මිල: Rs.480</div></div><div style=\"text-align: right; align-self: center; font-size: 12px;\">1.00 × Rs.480.00</div></div><div style=\"border-bottom: 1px dotted #000000ff; margin: 2px 0 2px 0; width: 100%;\"></div></div><div class=\"bill-item\" style=\"margin-bottom: 1px;\"><div style=\"display: flex; justify-content: space-between; align-items: center; margin-bottom: 1px;\"><span style=\"font-size: 16px; font-weight: bold; flex: 1; line-height: 1.0;\">මන්චි චොකලට් ක්‍රීම් බිස්කට් 365g</span><span style=\"font-size: 16px; font-weight: bold; text-align: right;\">Rs.410.00</span></div><div style=\"display: flex; justify-content: space-between; font-size: 14px; font-weight: bold; color: #000000ff; margin-bottom: 5px; line-height: 1.1;\"><div style=\"line-height: 1.4;\"><div>සාමාන්‍ය මිල: Rs.410</div><div>අපේ මිල: Rs.410</div></div><div style=\"text-align: right; align-self: center; font-size: 12px;\">1.00 × Rs.410.00</div></div><div style=\"border-bottom: 1px dotted #000000ff; margin: 2px 0 2px 0; width: 100%;\"></div></div><div class=\"bill-item\" style=\"margin-bottom: 1px;\"><div style=\"display: flex; justify-content: space-between; align-items: center; margin-bottom: 1px;\"><span style=\"font-size: 16px; font-weight: bold; flex: 1; line-height: 1.0;\">බිත්තර</span><span style=\"font-size: 16px; font-weight: bold; text-align: right;\">Rs.350.00</span></div><div style=\"display: flex; justify-content: space-between; font-size: 14px; font-weight: bold; color: #000000ff; margin-bottom: 5px; line-height: 1.1;\"><div style=\"line-height: 1.4;\"><div>සාමාන්‍ය මිල: Rs.350</div><div>අපේ මිල: Rs.350</div></div><div style=\"text-align: right; align-self: center; font-size: 12px;\">10.00 × Rs.35.00</div></div><div style=\"border-bottom: 1px dotted #000000ff; margin: 2px 0 2px 0; width: 100%;\"></div></div><div class=\"bill-item\" style=\"margin-bottom: 1px;\"><div style=\"display: flex; justify-content: space-between; align-items: center; margin-bottom: 1px;\"><span style=\"font-size: 16px; font-weight: bold; flex: 1; line-height: 1.0;\">සෝයා</span><span style=\"font-size: 16px; font-weight: bold; text-align: right;\">Rs.340.00</span></div><div style=\"display: flex; justify-content: space-between; font-size: 14px; font-weight: bold; color: #000000ff; margin-bottom: 5px; line-height: 1.1;\"><div style=\"line-height: 1.4;\"><div>සාමාන්‍ය මිල: Rs.340</div><div>අපේ මිල: Rs.340</div></div><div style=\"text-align: right; align-self: center; font-size: 12px;\">340.00 × Rs.1.00</div></div><div style=\"border-bottom: 1px dotted #000000ff; margin: 2px 0 2px 0; width: 100%;\"></div></div><div class=\"bill-item\" style=\"margin-bottom: 1px;\"><div style=\"display: flex; justify-content: space-between; align-items: center; margin-bottom: 1px;\"><span style=\"font-size: 16px; font-weight: bold; flex: 1; line-height: 1.0;\">වෙනත්</span><span style=\"font-size: 16px; font-weight: bold; text-align: right;\">Rs.15.00</span></div><div style=\"display: flex; justify-content: space-between; font-size: 14px; font-weight: bold; color: #000000ff; margin-bottom: 5px; line-height: 1.1;\"><div style=\"line-height: 1.4;\"><div>සාමාන්‍ය මිල: Rs.15</div><div>අපේ මිල: Rs.15</div></div><div style=\"text-align: right; align-self: center; font-size: 12px;\">15.00 × Rs.1.00</div></div></div></div><div class=\"bill-summary\" style=\"text-align: right; font-size: 15px; margin-bottom: 4px;\"><div style=\"margin: 6px 0; font-weight: bold; font-size: 28px;\">මුළු මුදල: Rs. 4500.00</div><div style=\"margin: 4px 0; font-weight: bold;\">ගෙවූ මුදල: Rs. 4500.00</div><div style=\"margin: 4px 0; font-size: 14px; font-weight: bold;\">ඉතිරි මුදල: Rs. 0.00</div><div style=\"border: 1px solid black; padding: 20px; margin-top: 8px; width: 100%; background-color: #ffffffff;\"><div style=\"text-align: center; font-size: 10px; font-weight: bold; line-height: 1.7;\">අපෙන් භාණ්ඩ ලබා ගැනීමෙන් ඔබ ලැබූ ලාභය<br><span style=\"font-size: 12px; color: #000000ff;\">Rs.65.00</span></div></div><div class=\"bill-footer\" style=\"text-align: center; font-size: 13px;\"><p style=\"margin: 4px 0; font-size: 15px;\">ස්තූතියි! නැවත එන්න</p></div>', '[{\"id\":380,\"item_name_sinhala\":\"සබන්\",\"item_name_english\":\"saban\",\"barcode\":\"622911681\",\"unit_of_measurement\":\"pcs\",\"regular_price\":1,\"our_price\":1,\"stock_quantity\":3380,\"quantity\":580},{\"id\":149,\"item_name_sinhala\":\"සිග්නල් දත් බුරුසු\",\"item_name_english\":\"signal\",\"barcode\":\"4792081021116\",\"unit_of_measurement\":\"pcs\",\"regular_price\":130,\"our_price\":130,\"stock_quantity\":20,\"quantity\":1},{\"id\":121,\"item_name_sinhala\":\"රතු හාල්\",\"item_name_english\":\"rathu\",\"barcode\":\"7638698\",\"unit_of_measurement\":\"kg\",\"regular_price\":200,\"our_price\":195,\"stock_quantity\":49808,\"quantity\":5},{\"id\":396,\"item_name_sinhala\":\"බේබි කොලොන්\",\"item_name_english\":\"baby\",\"barcode\":\"742805092\",\"unit_of_measurement\":\"pcs\",\"regular_price\":360,\"our_price\":360,\"stock_quantity\":480,\"quantity\":1},{\"id\":188,\"item_name_sinhala\":\"තල\",\"item_name_english\":\"thala\",\"barcode\":\"473159882\",\"unit_of_measurement\":\"pcs\",\"regular_price\":200,\"our_price\":200,\"stock_quantity\":49,\"quantity\":1},{\"id\":285,\"item_name_sinhala\":\"ප්‍රීමා නූඩ්ල්ස් ෆැමිලි පැක්\",\"item_name_english\":\"prima\",\"barcode\":\"4792018233681\",\"unit_of_measurement\":\"pcs\",\"regular_price\":370,\"our_price\":370,\"stock_quantity\":49,\"quantity\":1},{\"id\":99,\"item_name_sinhala\":\"බේබි ෂැම්පු\",\"item_name_english\":\"baby\",\"barcode\":\"4791111100524\",\"unit_of_measurement\":\"pcs\",\"regular_price\":290,\"our_price\":290,\"stock_quantity\":50,\"quantity\":1},{\"id\":116,\"item_name_sinhala\":\"කඩල\",\"item_name_english\":\"kadala\",\"barcode\":\"349521076\",\"unit_of_measurement\":\"pcs\",\"regular_price\":520,\"our_price\":480,\"stock_quantity\":16,\"quantity\":1},{\"id\":27,\"item_name_sinhala\":\"මන්චි චොකලට් ක්‍රීම් බිස්කට් 365g\",\"item_name_english\":\"mcho\",\"barcode\":\"4792192851701\",\"unit_of_measurement\":\"pcs\",\"regular_price\":410,\"our_price\":410,\"stock_quantity\":50,\"quantity\":1},{\"id\":110,\"item_name_sinhala\":\"බිත්තර\",\"item_name_english\":\"biththara\",\"barcode\":\"015366342\",\"unit_of_measurement\":\"pcs\",\"regular_price\":35,\"our_price\":35,\"stock_quantity\":415,\"quantity\":10},{\"id\":417,\"item_name_sinhala\":\"සෝයා\",\"item_name_english\":\"soya\",\"barcode\":\"026582833\",\"unit_of_measurement\":\"pcs\",\"regular_price\":1,\"our_price\":1,\"stock_quantity\":478596652636,\"quantity\":340},{\"id\":88,\"item_name_sinhala\":\"වෙනත්\",\"item_name_english\":\"we\",\"barcode\":\"045504190\",\"unit_of_measurement\":\"pcs\",\"regular_price\":1,\"our_price\":1,\"stock_quantity\":9.223372036854776e+18,\"quantity\":15}]', '2025-11-21 06:22:05'),
(205, 50, '2025-11-23', NULL, NULL, NULL, 4930.00, 4500.00, 0.00, 0, 'cash', '<p style=\"margin: 3px 0; font-size: 14px; text-align: center; font-weight: bold;\">බිල් අංකය: 50</p><p style=\"margin: 3px 0; font-size: 14px; text-align: center;\">Date: 23/11/2025 Time: 09:20:56</p><div style=\"margin: 4px 0; border-bottom: 1px dashed black; width: 100%;\"></div></div><div class=\"bill-items\" style=\"margin-bottom: 8px;\"><div class=\"bill-item\" style=\"margin-bottom: 1px;\"><div style=\"display: flex; justify-content: space-between; align-items: center; margin-bottom: 1px;\"><span style=\"font-size: 16px; font-weight: bold; flex: 1; line-height: 1.0;\">පරිප්පු නො.2</span><span style=\"font-size: 16px; font-weight: bold; text-align: right;\">Rs.260.00</span></div><div style=\"display: flex; justify-content: space-between; font-size: 14px; font-weight: bold; color: #000000ff; margin-bottom: 5px; line-height: 1.1;\"><div style=\"line-height: 1.4;\"><div>සාමාන්‍ය මිල: Rs.280</div><div>අපේ මිල: Rs.260</div></div><div style=\"text-align: right; align-self: center; font-size: 12px;\">1.00 × Rs.260.00</div></div><div style=\"border-bottom: 1px dotted #000000ff; margin: 2px 0 2px 0; width: 100%;\"></div></div><div class=\"bill-item\" style=\"margin-bottom: 1px;\"><div style=\"display: flex; justify-content: space-between; align-items: center; margin-bottom: 1px;\"><span style=\"font-size: 16px; font-weight: bold; flex: 1; line-height: 1.0;\">සුදු සීනි පැකට්</span><span style=\"font-size: 16px; font-weight: bold; text-align: right;\">Rs.460.00</span></div><div style=\"display: flex; justify-content: space-between; font-size: 14px; font-weight: bold; color: #000000ff; margin-bottom: 5px; line-height: 1.1;\"><div style=\"line-height: 1.4;\"><div>සාමාන්‍ය මිල: Rs.500</div><div>අපේ මිල: Rs.460</div></div><div style=\"text-align: right; align-self: center; font-size: 12px;\">2.00 × Rs.230.00</div></div><div style=\"border-bottom: 1px dotted #000000ff; margin: 2px 0 2px 0; width: 100%;\"></div></div><div class=\"bill-item\" style=\"margin-bottom: 1px;\"><div style=\"display: flex; justify-content: space-between; align-items: center; margin-bottom: 1px;\"><span style=\"font-size: 16px; font-weight: bold; flex: 1; line-height: 1.0;\">බිස්කට්</span><span style=\"font-size: 16px; font-weight: bold; text-align: right;\">Rs.190.00</span></div><div style=\"display: flex; justify-content: space-between; font-size: 14px; font-weight: bold; color: #000000ff; margin-bottom: 5px; line-height: 1.1;\"><div style=\"line-height: 1.4;\"><div>සාමාන්‍ය මිල: Rs.190</div><div>අපේ මිල: Rs.190</div></div><div style=\"text-align: right; align-self: center; font-size: 12px;\">190.00 × Rs.1.00</div></div><div style=\"border-bottom: 1px dotted #000000ff; margin: 2px 0 2px 0; width: 100%;\"></div></div><div class=\"bill-item\" style=\"margin-bottom: 1px;\"><div style=\"display: flex; justify-content: space-between; align-items: center; margin-bottom: 1px;\"><span style=\"font-size: 16px; font-weight: bold; flex: 1; line-height: 1.0;\">කිරි පිටි</span><span style=\"font-size: 16px; font-weight: bold; text-align: right;\">Rs.800.00</span></div><div style=\"display: flex; justify-content: space-between; font-size: 14px; font-weight: bold; color: #000000ff; margin-bottom: 5px; line-height: 1.1;\"><div style=\"line-height: 1.4;\"><div>සාමාන්‍ය මිල: Rs.800</div><div>අපේ මිල: Rs.800</div></div><div style=\"text-align: right; align-self: center; font-size: 12px;\">800.00 × Rs.1.00</div></div><div style=\"border-bottom: 1px dotted #000000ff; margin: 2px 0 2px 0; width: 100%;\"></div></div><div class=\"bill-item\" style=\"margin-bottom: 1px;\"><div style=\"display: flex; justify-content: space-between; align-items: center; margin-bottom: 1px;\"><span style=\"font-size: 16px; font-weight: bold; flex: 1; line-height: 1.0;\">සබන් කුඩු</span><span style=\"font-size: 16px; font-weight: bold; text-align: right;\">Rs.190.00</span></div><div style=\"display: flex; justify-content: space-between; font-size: 14px; font-weight: bold; color: #000000ff; margin-bottom: 5px; line-height: 1.1;\"><div style=\"line-height: 1.4;\"><div>සාමාන්‍ය මිල: Rs.190</div><div>අපේ මිල: Rs.190</div></div><div style=\"text-align: right; align-self: center; font-size: 12px;\">1.00 × Rs.190.00</div></div><div style=\"border-bottom: 1px dotted #000000ff; margin: 2px 0 2px 0; width: 100%;\"></div></div><div class=\"bill-item\" style=\"margin-bottom: 1px;\"><div style=\"display: flex; justify-content: space-between; align-items: center; margin-bottom: 1px;\"><span style=\"font-size: 16px; font-weight: bold; flex: 1; line-height: 1.0;\">ප්‍රීමා නූඩ්ල්ස් ෆැමිලි පැක්</span><span style=\"font-size: 16px; font-weight: bold; text-align: right;\">Rs.370.00</span></div><div style=\"display: flex; justify-content: space-between; font-size: 14px; font-weight: bold; color: #000000ff; margin-bottom: 5px; line-height: 1.1;\"><div style=\"line-height: 1.4;\"><div>සාමාන්‍ය මිල: Rs.370</div><div>අපේ මිල: Rs.370</div></div><div style=\"text-align: right; align-self: center; font-size: 12px;\">1.00 × Rs.370.00</div></div><div style=\"border-bottom: 1px dotted #000000ff; margin: 2px 0 2px 0; width: 100%;\"></div></div><div class=\"bill-item\" style=\"margin-bottom: 1px;\"><div style=\"display: flex; justify-content: space-between; align-items: center; margin-bottom: 1px;\"><span style=\"font-size: 16px; font-weight: bold; flex: 1; line-height: 1.0;\">සබන්</span><span style=\"font-size: 16px; font-weight: bold; text-align: right;\">Rs.250.00</span></div><div style=\"display: flex; justify-content: space-between; font-size: 14px; font-weight: bold; color: #000000ff; margin-bottom: 5px; line-height: 1.1;\"><div style=\"line-height: 1.4;\"><div>සාමාන්‍ය මිල: Rs.250</div><div>අපේ මිල: Rs.250</div></div><div style=\"text-align: right; align-self: center; font-size: 12px;\">250.00 × Rs.1.00</div></div><div style=\"border-bottom: 1px dotted #000000ff; margin: 2px 0 2px 0; width: 100%;\"></div></div><div class=\"bill-item\" style=\"margin-bottom: 1px;\"><div style=\"display: flex; justify-content: space-between; align-items: center; margin-bottom: 1px;\"><span style=\"font-size: 16px; font-weight: bold; flex: 1; line-height: 1.0;\">මිරිස් කුඩු</span><span style=\"font-size: 16px; font-weight: bold; text-align: right;\">Rs.500.00</span></div><div style=\"display: flex; justify-content: space-between; font-size: 14px; font-weight: bold; color: #000000ff; margin-bottom: 5px; line-height: 1.1;\"><div style=\"line-height: 1.4;\"><div>සාමාන්‍ය මිල: Rs.500</div><div>අපේ මිල: Rs.500</div></div><div style=\"text-align: right; align-self: center; font-size: 12px;\">500.00 × Rs.1.00</div></div><div style=\"border-bottom: 1px dotted #000000ff; margin: 2px 0 2px 0; width: 100%;\"></div></div><div class=\"bill-item\" style=\"margin-bottom: 1px;\"><div style=\"display: flex; justify-content: space-between; align-items: center; margin-bottom: 1px;\"><span style=\"font-size: 16px; font-weight: bold; flex: 1; line-height: 1.0;\">වෙනත්</span><span style=\"font-size: 16px; font-weight: bold; text-align: right;\">Rs.150.00</span></div><div style=\"display: flex; justify-content: space-between; font-size: 14px; font-weight: bold; color: #000000ff; margin-bottom: 5px; line-height: 1.1;\"><div style=\"line-height: 1.4;\"><div>සාමාන්‍ය මිල: Rs.150</div><div>අපේ මිල: Rs.150</div></div><div style=\"text-align: right; align-self: center; font-size: 12px;\">150.00 × Rs.1.00</div></div><div style=\"border-bottom: 1px dotted #000000ff; margin: 2px 0 2px 0; width: 100%;\"></div></div><div class=\"bill-item\" style=\"margin-bottom: 1px;\"><div style=\"display: flex; justify-content: space-between; align-items: center; margin-bottom: 1px;\"><span style=\"font-size: 16px; font-weight: bold; flex: 1; line-height: 1.0;\">කුකුල් මස්</span><span style=\"font-size: 16px; font-weight: bold; text-align: right;\">Rs.1750.00</span></div><div style=\"display: flex; justify-content: space-between; font-size: 14px; font-weight: bold; color: #000000ff; margin-bottom: 5px; line-height: 1.1;\"><div style=\"line-height: 1.4;\"><div>සාමාන්‍ය මිල: Rs.1987.5</div><div>අපේ මිල: Rs.1749</div></div><div style=\"text-align: right; align-self: center; font-size: 12px;\">1.59 × Rs.1100.00</div></div><div style=\"border-bottom: 1px dotted #000000ff; margin: 2px 0 2px 0; width: 100%;\"></div></div><div class=\"bill-item\" style=\"margin-bottom: 1px;\"><div style=\"display: flex; justify-content: space-between; align-items: center; margin-bottom: 1px;\"><span style=\"font-size: 16px; font-weight: bold; flex: 1; line-height: 1.0;\">ෂොපින් බෑග්</span><span style=\"font-size: 16px; font-weight: bold; text-align: right;\">Rs.10.00</span></div><div style=\"display: flex; justify-content: space-between; font-size: 14px; font-weight: bold; color: #000000ff; margin-bottom: 5px; line-height: 1.1;\"><div style=\"line-height: 1.4;\"><div>සාමාන්‍ය මිල: Rs.10</div><div>අපේ මිල: Rs.10</div></div><div style=\"text-align: right; align-self: center; font-size: 12px;\">10.00 × Rs.1.00</div></div></div></div><div class=\"bill-summary\" style=\"text-align: right; font-size: 15px; margin-bottom: 4px;\"><div style=\"margin: 6px 0; font-weight: bold; font-size: 28px;\">මුළු මුදල: Rs. 4930.00</div><div style=\"margin: 4px 0; font-weight: bold;\">ගෙවූ මුදල: Rs. 4500.00</div><div style=\"margin: 4px 0; font-size: 14px; font-weight: bold;\">ඉතිරි මුදල: Rs. 0.00</div><div style=\"border: 1px solid black; padding: 20px; margin-top: 8px; width: 100%; background-color: #ffffffff;\"><div style=\"text-align: center; font-size: 10px; font-weight: bold; line-height: 1.7;\">අපෙන් භාණ්ඩ ලබා ගැනීමෙන් ඔබ ලැබූ ලාභය<br><span style=\"font-size: 12px; color: #000000ff;\">Rs.298.64</span></div></div><div class=\"bill-footer\" style=\"text-align: center; font-size: 13px;\"><p style=\"margin: 4px 0; font-size: 15px;\">ස්තූතියි! නැවත එන්න</p></div>', '[{\"id\":109,\"item_name_sinhala\":\"පරිප්පු නො.2\",\"item_name_english\":\"parippu\",\"barcode\":\"991179274\",\"unit_of_measurement\":\"kg\",\"regular_price\":280,\"our_price\":260,\"stock_quantity\":153,\"quantity\":1},{\"id\":362,\"item_name_sinhala\":\"සුදු සීනි පැකට්\",\"item_name_english\":\"sini\",\"barcode\":\"872168955\",\"unit_of_measurement\":\"pcs\",\"regular_price\":250,\"our_price\":230,\"stock_quantity\":98,\"quantity\":2},{\"id\":398,\"item_name_sinhala\":\"බිස්කට්\",\"item_name_english\":\"biskat\",\"barcode\":\"011777449\",\"unit_of_measurement\":\"pcs\",\"regular_price\":1,\"our_price\":1,\"stock_quantity\":880,\"quantity\":190},{\"id\":411,\"item_name_sinhala\":\"කිරි පිටි\",\"item_name_english\":\"kiripiti\",\"barcode\":\"490593542\",\"unit_of_measurement\":\"pcs\",\"regular_price\":1,\"our_price\":1,\"stock_quantity\":9.223372036854776e+18,\"quantity\":800},{\"id\":249,\"item_name_sinhala\":\"සබන් කුඩු\",\"item_name_english\":\"saban kudu\",\"barcode\":\"032715300\",\"unit_of_measurement\":\"pcs\",\"regular_price\":190,\"our_price\":190,\"stock_quantity\":50,\"quantity\":1},{\"id\":285,\"item_name_sinhala\":\"ප්‍රීමා නූඩ්ල්ස් ෆැමිලි පැක්\",\"item_name_english\":\"prima\",\"barcode\":\"4792018233681\",\"unit_of_measurement\":\"pcs\",\"regular_price\":370,\"our_price\":370,\"stock_quantity\":48,\"quantity\":1},{\"id\":380,\"item_name_sinhala\":\"සබන්\",\"item_name_english\":\"saban\",\"barcode\":\"622911681\",\"unit_of_measurement\":\"pcs\",\"regular_price\":1,\"our_price\":1,\"stock_quantity\":2800,\"quantity\":250},{\"id\":425,\"item_name_sinhala\":\"මිරිස් කුඩු\",\"item_name_english\":\"miriskudu\",\"barcode\":\"246496688\",\"unit_of_measurement\":\"pcs\",\"regular_price\":1,\"our_price\":1,\"stock_quantity\":1452256,\"quantity\":500},{\"id\":88,\"item_name_sinhala\":\"වෙනත්\",\"item_name_english\":\"we\",\"barcode\":\"045504190\",\"unit_of_measurement\":\"pcs\",\"regular_price\":1,\"our_price\":1,\"stock_quantity\":9.223372036854776e+18,\"quantity\":150},{\"id\":222,\"item_name_sinhala\":\"කුකුල් මස්\",\"item_name_english\":\"kukul\",\"barcode\":\"997661572\",\"unit_of_measurement\":\"pcs\",\"regular_price\":1250,\"our_price\":1100,\"stock_quantity\":9598,\"quantity\":1.5909090909090908},{\"id\":319,\"item_name_sinhala\":\"ෂොපින් බෑග්\",\"item_name_english\":\"shopin\",\"barcode\":\"347384926\",\"unit_of_measurement\":\"pcs\",\"regular_price\":1,\"our_price\":1,\"stock_quantity\":4900,\"quantity\":10}]', '2025-11-23 03:50:56');
INSERT INTO `bill_records` (`id`, `bill_number`, `bill_date`, `bill_time`, `customer_phone`, `customer_id`, `total_amount`, `paid_amount`, `change_amount`, `is_credit`, `paymenttype`, `bill_content`, `items_json`, `created_at`) VALUES
(206, 50, '2025-11-24', NULL, NULL, NULL, 3810.00, 4000.00, 190.00, 0, 'cash', '<div class=\"bill-header\" style=\"padding-top: 0; margin-top: 0;\"><div style=\"text-align: center; margin-bottom: 8px; margin-top: 0; padding-top: 0;\"><img src=\"logo.png\" alt=\"Store Logo\" style=\"max-width: 100%; width: 95%; height: auto; max-height: 300px; margin-top: 0; margin-bottom: 6px; display: block; margin-left: auto; margin-right: auto; object-fit: contain; padding-top: 0;\"><h2 style=\"margin: 4px 0 0 0; font-size: 22px; font-weight: bold;\"></h2></div><p style=\"margin: 3px 0; font-size: 14px; text-align: center;\">පාසල අසල දොරපනේ</p><p style=\"margin: 3px 0; font-size: 14px; text-align: center;\">Tel: 071-3552017</p><p style=\"margin: 3px 0; font-size: 14px; text-align: center; font-weight: bold;\">බිල් අංකය: 50</p><p style=\"margin: 3px 0; font-size: 14px; text-align: center;\">Date: 24/11/2025 Time: 12:15:01</p><div style=\"margin: 4px 0; border-bottom: 1px dashed black; width: 100%;\"></div></div><div class=\"bill-items\" style=\"margin-bottom: 8px;\"><div class=\"bill-item\" style=\"margin-bottom: 1px;\"><div style=\"display: flex; justify-content: space-between; align-items: center; margin-bottom: 1px;\"><span style=\"font-size: 16px; font-weight: bold; flex: 1; line-height: 1.0;\">පැනඩෝල්</span><span style=\"font-size: 16px; font-weight: bold; text-align: right;\">Rs.60.00</span></div><div style=\"display: flex; justify-content: space-between; font-size: 14px; font-weight: bold; color: #000000ff; margin-bottom: 5px; line-height: 1.1;\"><div style=\"line-height: 1.4;\"><div>සාමාන්‍ය මිල: Rs.60</div><div>අපේ මිල: Rs.60</div></div><div style=\"text-align: right; align-self: center; font-size: 12px;\">1.00 × Rs.60.00</div></div><div style=\"border-bottom: 1px dotted #000000ff; margin: 2px 0 2px 0; width: 100%;\"></div></div><div class=\"bill-item\" style=\"margin-bottom: 1px;\"><div style=\"display: flex; justify-content: space-between; align-items: center; margin-bottom: 1px;\"><span style=\"font-size: 16px; font-weight: bold; flex: 1; line-height: 1.0;\">බී ළුෑණු</span><span style=\"font-size: 16px; font-weight: bold; text-align: right;\">Rs.190.00</span></div><div style=\"display: flex; justify-content: space-between; font-size: 14px; font-weight: bold; color: #000000ff; margin-bottom: 5px; line-height: 1.1;\"><div style=\"line-height: 1.4;\"><div>සාමාන්‍ය මිල: Rs.200</div><div>අපේ මිල: Rs.190</div></div><div style=\"text-align: right; align-self: center; font-size: 12px;\">1.00 × Rs.190.00</div></div><div style=\"border-bottom: 1px dotted #000000ff; margin: 2px 0 2px 0; width: 100%;\"></div></div><div class=\"bill-item\" style=\"margin-bottom: 1px;\"><div style=\"display: flex; justify-content: space-between; align-items: center; margin-bottom: 1px;\"><span style=\"font-size: 16px; font-weight: bold; flex: 1; line-height: 1.0;\">රතු ළුණු</span><span style=\"font-size: 16px; font-weight: bold; text-align: right;\">Rs.200.00</span></div><div style=\"display: flex; justify-content: space-between; font-size: 14px; font-weight: bold; color: #000000ff; margin-bottom: 5px; line-height: 1.1;\"><div style=\"line-height: 1.4;\"><div>සාමාන්‍ය මිල: Rs.225</div><div>අපේ මිල: Rs.200</div></div><div style=\"text-align: right; align-self: center; font-size: 12px;\">0.50 × Rs.400.00</div></div><div style=\"border-bottom: 1px dotted #000000ff; margin: 2px 0 2px 0; width: 100%;\"></div></div><div class=\"bill-item\" style=\"margin-bottom: 1px;\"><div style=\"display: flex; justify-content: space-between; align-items: center; margin-bottom: 1px;\"><span style=\"font-size: 16px; font-weight: bold; flex: 1; line-height: 1.0;\">පරිප්පු නො.2</span><span style=\"font-size: 16px; font-weight: bold; text-align: right;\">Rs.130.00</span></div><div style=\"display: flex; justify-content: space-between; font-size: 14px; font-weight: bold; color: #000000ff; margin-bottom: 5px; line-height: 1.1;\"><div style=\"line-height: 1.4;\"><div>සාමාන්‍ය මිල: Rs.140</div><div>අපේ මිල: Rs.130</div></div><div style=\"text-align: right; align-self: center; font-size: 12px;\">0.50 × Rs.260.00</div></div><div style=\"border-bottom: 1px dotted #000000ff; margin: 2px 0 2px 0; width: 100%;\"></div></div><div class=\"bill-item\" style=\"margin-bottom: 1px;\"><div style=\"display: flex; justify-content: space-between; align-items: center; margin-bottom: 1px;\"><span style=\"font-size: 16px; font-weight: bold; flex: 1; line-height: 1.0;\">හාල්මැස්සන්</span><span style=\"font-size: 16px; font-weight: bold; text-align: right;\">Rs.240.00</span></div><div style=\"display: flex; justify-content: space-between; font-size: 14px; font-weight: bold; color: #000000ff; margin-bottom: 5px; line-height: 1.1;\"><div style=\"line-height: 1.4;\"><div>සාමාන්‍ය මිල: Rs.260</div><div>අපේ මිල: Rs.240</div></div><div style=\"text-align: right; align-self: center; font-size: 12px;\">0.20 × Rs.1200.00</div></div><div style=\"border-bottom: 1px dotted #000000ff; margin: 2px 0 2px 0; width: 100%;\"></div></div><div class=\"bill-item\" style=\"margin-bottom: 1px;\"><div style=\"display: flex; justify-content: space-between; align-items: center; margin-bottom: 1px;\"><span style=\"font-size: 16px; font-weight: bold; flex: 1; line-height: 1.0;\">ප්‍රීමා නූඩ්ල්ස් ෆැමිලි පැක්</span><span style=\"font-size: 16px; font-weight: bold; text-align: right;\">Rs.370.00</span></div><div style=\"display: flex; justify-content: space-between; font-size: 14px; font-weight: bold; color: #000000ff; margin-bottom: 5px; line-height: 1.1;\"><div style=\"line-height: 1.4;\"><div>සාමාන්‍ය මිල: Rs.370</div><div>අපේ මිල: Rs.370</div></div><div style=\"text-align: right; align-self: center; font-size: 12px;\">1.00 × Rs.370.00</div></div><div style=\"border-bottom: 1px dotted #000000ff; margin: 2px 0 2px 0; width: 100%;\"></div></div><div class=\"bill-item\" style=\"margin-bottom: 1px;\"><div style=\"display: flex; justify-content: space-between; align-items: center; margin-bottom: 1px;\"><span style=\"font-size: 16px; font-weight: bold; flex: 1; line-height: 1.0;\">බට්ටො</span><span style=\"font-size: 16px; font-weight: bold; text-align: right;\">Rs.200.00</span></div><div style=\"display: flex; justify-content: space-between; font-size: 14px; font-weight: bold; color: #000000ff; margin-bottom: 5px; line-height: 1.1;\"><div style=\"line-height: 1.4;\"><div>සාමාන්‍ය මිල: Rs.200</div><div>අපේ මිල: Rs.200</div></div><div style=\"text-align: right; align-self: center; font-size: 12px;\">2.00 × Rs.100.00</div></div><div style=\"border-bottom: 1px dotted #000000ff; margin: 2px 0 2px 0; width: 100%;\"></div></div><div class=\"bill-item\" style=\"margin-bottom: 1px;\"><div style=\"display: flex; justify-content: space-between; align-items: center; margin-bottom: 1px;\"><span style=\"font-size: 16px; font-weight: bold; flex: 1; line-height: 1.0;\">කහ</span><span style=\"font-size: 16px; font-weight: bold; text-align: right;\">Rs.200.00</span></div><div style=\"display: flex; justify-content: space-between; font-size: 14px; font-weight: bold; color: #000000ff; margin-bottom: 5px; line-height: 1.1;\"><div style=\"line-height: 1.4;\"><div>සාමාන්‍ය මිල: Rs.200</div><div>අපේ මිල: Rs.200</div></div><div style=\"text-align: right; align-self: center; font-size: 12px;\">1.00 × Rs.200.00</div></div><div style=\"border-bottom: 1px dotted #000000ff; margin: 2px 0 2px 0; width: 100%;\"></div></div><div class=\"bill-item\" style=\"margin-bottom: 1px;\"><div style=\"display: flex; justify-content: space-between; align-items: center; margin-bottom: 1px;\"><span style=\"font-size: 16px; font-weight: bold; flex: 1; line-height: 1.0;\">වෙනත්</span><span style=\"font-size: 16px; font-weight: bold; text-align: right;\">Rs.240.00</span></div><div style=\"display: flex; justify-content: space-between; font-size: 14px; font-weight: bold; color: #000000ff; margin-bottom: 5px; line-height: 1.1;\"><div style=\"line-height: 1.4;\"><div>සාමාන්‍ය මිල: Rs.240</div><div>අපේ මිල: Rs.240</div></div><div style=\"text-align: right; align-self: center; font-size: 12px;\">240.00 × Rs.1.00</div></div><div style=\"border-bottom: 1px dotted #000000ff; margin: 2px 0 2px 0; width: 100%;\"></div></div><div class=\"bill-item\" style=\"margin-bottom: 1px;\"><div style=\"display: flex; justify-content: space-between; align-items: center; margin-bottom: 1px;\"><span style=\"font-size: 16px; font-weight: bold; flex: 1; line-height: 1.0;\">වෙනත්</span><span style=\"font-size: 16px; font-weight: bold; text-align: right;\">Rs.70.00</span></div><div style=\"display: flex; justify-content: space-between; font-size: 14px; font-weight: bold; color: #000000ff; margin-bottom: 5px; line-height: 1.1;\"><div style=\"line-height: 1.4;\"><div>සාමාන්‍ය මිල: Rs.70</div><div>අපේ මිල: Rs.70</div></div><div style=\"text-align: right; align-self: center; font-size: 12px;\">70.00 × Rs.1.00</div></div><div style=\"border-bottom: 1px dotted #000000ff; margin: 2px 0 2px 0; width: 100%;\"></div></div><div class=\"bill-item\" style=\"margin-bottom: 1px;\"><div style=\"display: flex; justify-content: space-between; align-items: center; margin-bottom: 1px;\"><span style=\"font-size: 16px; font-weight: bold; flex: 1; line-height: 1.0;\">මිරිස් කරල්</span><span style=\"font-size: 16px; font-weight: bold; text-align: right;\">Rs.100.00</span></div><div style=\"display: flex; justify-content: space-between; font-size: 14px; font-weight: bold; color: #000000ff; margin-bottom: 5px; line-height: 1.1;\"><div style=\"line-height: 1.4;\"><div>සාමාන්‍ය මිල: Rs.120</div><div>අපේ මිල: Rs.100</div></div><div style=\"text-align: right; align-self: center; font-size: 12px;\">0.10 × Rs.1000.00</div></div><div style=\"border-bottom: 1px dotted #000000ff; margin: 2px 0 2px 0; width: 100%;\"></div></div><div class=\"bill-item\" style=\"margin-bottom: 1px;\"><div style=\"display: flex; justify-content: space-between; align-items: center; margin-bottom: 1px;\"><span style=\"font-size: 16px; font-weight: bold; flex: 1; line-height: 1.0;\">සබන් කුඩු</span><span style=\"font-size: 16px; font-weight: bold; text-align: right;\">Rs.320.00</span></div><div style=\"display: flex; justify-content: space-between; font-size: 14px; font-weight: bold; color: #000000ff; margin-bottom: 5px; line-height: 1.1;\"><div style=\"line-height: 1.4;\"><div>සාමාන්‍ය මිල: Rs.320</div><div>අපේ මිල: Rs.320</div></div><div style=\"text-align: right; align-self: center; font-size: 12px;\">1.00 × Rs.320.00</div></div><div style=\"border-bottom: 1px dotted #000000ff; margin: 2px 0 2px 0; width: 100%;\"></div></div><div class=\"bill-item\" style=\"margin-bottom: 1px;\"><div style=\"display: flex; justify-content: space-between; align-items: center; margin-bottom: 1px;\"><span style=\"font-size: 16px; font-weight: bold; flex: 1; line-height: 1.0;\">සබන්</span><span style=\"font-size: 16px; font-weight: bold; text-align: right;\">Rs.270.00</span></div><div style=\"display: flex; justify-content: space-between; font-size: 14px; font-weight: bold; color: #000000ff; margin-bottom: 5px; line-height: 1.1;\"><div style=\"line-height: 1.4;\"><div>සාමාන්‍ය මිල: Rs.270</div><div>අපේ මිල: Rs.270</div></div><div style=\"text-align: right; align-self: center; font-size: 12px;\">270.00 × Rs.1.00</div></div><div style=\"border-bottom: 1px dotted #000000ff; margin: 2px 0 2px 0; width: 100%;\"></div></div><div class=\"bill-item\" style=\"margin-bottom: 1px;\"><div style=\"display: flex; justify-content: space-between; align-items: center; margin-bottom: 1px;\"><span style=\"font-size: 16px; font-weight: bold; flex: 1; line-height: 1.0;\">විම්</span><span style=\"font-size: 16px; font-weight: bold; text-align: right;\">Rs.100.00</span></div><div style=\"display: flex; justify-content: space-between; font-size: 14px; font-weight: bold; color: #000000ff; margin-bottom: 5px; line-height: 1.1;\"><div style=\"line-height: 1.4;\"><div>සාමාන්‍ය මිල: Rs.100</div><div>අපේ මිල: Rs.100</div></div><div style=\"text-align: right; align-self: center; font-size: 12px;\">2.00 × Rs.50.00</div></div><div style=\"border-bottom: 1px dotted #000000ff; margin: 2px 0 2px 0; width: 100%;\"></div></div><div class=\"bill-item\" style=\"margin-bottom: 1px;\"><div style=\"display: flex; justify-content: space-between; align-items: center; margin-bottom: 1px;\"><span style=\"font-size: 16px; font-weight: bold; flex: 1; line-height: 1.0;\">කරවල</span><span style=\"font-size: 16px; font-weight: bold; text-align: right;\">Rs.215.00</span></div><div style=\"display: flex; justify-content: space-between; font-size: 14px; font-weight: bold; color: #000000ff; margin-bottom: 5px; line-height: 1.1;\"><div style=\"line-height: 1.4;\"><div>සාමාන්‍ය මිල: Rs.215</div><div>අපේ මිල: Rs.215</div></div><div style=\"text-align: right; align-self: center; font-size: 12px;\">215.00 × Rs.1.00</div></div><div style=\"border-bottom: 1px dotted #000000ff; margin: 2px 0 2px 0; width: 100%;\"></div></div><div class=\"bill-item\" style=\"margin-bottom: 1px;\"><div style=\"display: flex; justify-content: space-between; align-items: center; margin-bottom: 1px;\"><span style=\"font-size: 16px; font-weight: bold; flex: 1; line-height: 1.0;\">වෙනත්</span><span style=\"font-size: 16px; font-weight: bold; text-align: right;\">Rs.305.00</span></div><div style=\"display: flex; justify-content: space-between; font-size: 14px; font-weight: bold; color: #000000ff; margin-bottom: 5px; line-height: 1.1;\"><div style=\"line-height: 1.4;\"><div>සාමාන්‍ය මිල: Rs.305</div><div>අපේ මිල: Rs.305</div></div><div style=\"text-align: right; align-self: center; font-size: 12px;\">305.00 × Rs.1.00</div></div><div style=\"border-bottom: 1px dotted #000000ff; margin: 2px 0 2px 0; width: 100%;\"></div></div><div class=\"bill-item\" style=\"margin-bottom: 1px;\"><div style=\"display: flex; justify-content: space-between; align-items: center; margin-bottom: 1px;\"><span style=\"font-size: 16px; font-weight: bold; flex: 1; line-height: 1.0;\">තේ කොළ</span><span style=\"font-size: 16px; font-weight: bold; text-align: right;\">Rs.600.00</span></div><div style=\"display: flex; justify-content: space-between; font-size: 14px; font-weight: bold; color: #000000ff; margin-bottom: 5px; line-height: 1.1;\"><div style=\"line-height: 1.4;\"><div>සාමාන්‍ය මිල: Rs.600</div><div>අපේ මිල: Rs.600</div></div><div style=\"text-align: right; align-self: center; font-size: 12px;\">600.00 × Rs.1.00</div></div></div></div><div class=\"bill-summary\" style=\"text-align: right; font-size: 15px; margin-bottom: 4px;\"><div style=\"margin: 6px 0; font-weight: bold; font-size: 28px;\">මුළු මුදල: Rs. 3810.00</div><div style=\"margin: 4px 0; font-weight: bold;\">ගෙවූ මුදල: Rs. 4000.00</div><div style=\"margin: 4px 0; font-size: 14px; font-weight: bold;\">ඉතිරි මුදල: Rs. 190.00</div><div style=\"border: 1px solid black; padding: 20px; margin-top: 8px; width: 100%; background-color: #ffffffff;\"><div style=\"text-align: center; font-size: 10px; font-weight: bold; line-height: 1.7;\">අපෙන් භාණ්ඩ ලබා ගැනීමෙන් ඔබ ලැබූ ලාභය<br><span style=\"font-size: 12px; color: #000000ff;\">Rs.85.00</span></div></div><div class=\"bill-footer\" style=\"text-align: center; font-size: 13px;\"><p style=\"margin: 4px 0; font-size: 15px;\">ස්තූතියි! නැවත එන්න</p><p style=\"margin: 6px 0; font-size: 12px;\">=== Gadget Technologies 071-1071666 ===</p></div>', '[{\"id\":177,\"item_name_sinhala\":\"පැනඩෝල්\",\"item_name_english\":\"panadol\",\"barcode\":\"4792099010010\",\"unit_of_measurement\":\"pcs\",\"regular_price\":60,\"our_price\":60,\"stock_quantity\":999,\"quantity\":1},{\"id\":105,\"item_name_sinhala\":\"බී ළුෑණු\",\"item_name_english\":\"beeluunu\",\"barcode\":\"113943378\",\"unit_of_measurement\":\"kg\",\"regular_price\":200,\"our_price\":190,\"stock_quantity\":51,\"quantity\":1},{\"id\":106,\"item_name_sinhala\":\"රතු ළුණු\",\"item_name_english\":\"rathu\",\"barcode\":\"838150515\",\"unit_of_measurement\":\"kg\",\"regular_price\":450,\"our_price\":400,\"stock_quantity\":9,\"quantity\":0.5},{\"id\":109,\"item_name_sinhala\":\"පරිප්පු නො.2\",\"item_name_english\":\"parippu\",\"barcode\":\"991179274\",\"unit_of_measurement\":\"kg\",\"regular_price\":280,\"our_price\":260,\"stock_quantity\":152,\"quantity\":0.5},{\"id\":111,\"item_name_sinhala\":\"හාල්මැස්සන්\",\"item_name_english\":\"halmasso\",\"barcode\":\"040630134-\",\"unit_of_measurement\":\"pcs\",\"regular_price\":1300,\"our_price\":1200,\"stock_quantity\":20,\"quantity\":0.2},{\"id\":285,\"item_name_sinhala\":\"ප්‍රීමා නූඩ්ල්ස් ෆැමිලි පැක්\",\"item_name_english\":\"prima\",\"barcode\":\"4792018233681\",\"unit_of_measurement\":\"pcs\",\"regular_price\":370,\"our_price\":370,\"stock_quantity\":47,\"quantity\":1},{\"id\":394,\"item_name_sinhala\":\"බට්ටො\",\"item_name_english\":\"batto\",\"barcode\":\"065136862\",\"unit_of_measurement\":\"pcs\",\"regular_price\":100,\"our_price\":100,\"stock_quantity\":800,\"quantity\":2},{\"id\":228,\"item_name_sinhala\":\"කහ\",\"item_name_english\":\"kaha\",\"barcode\":\"323719216\",\"unit_of_measurement\":\"pcs\",\"regular_price\":200,\"our_price\":200,\"stock_quantity\":489,\"quantity\":1},{\"id\":88,\"item_name_sinhala\":\"වෙනත්\",\"item_name_english\":\"we\",\"barcode\":\"045504190\",\"unit_of_measurement\":\"pcs\",\"regular_price\":1,\"our_price\":1,\"stock_quantity\":9.223372036854776e+18,\"quantity\":240},{\"id\":186,\"item_name_sinhala\":\"වෙනත්\",\"item_name_english\":\"we2\",\"barcode\":\"400735117\",\"unit_of_measurement\":\"pcs\",\"regular_price\":1,\"our_price\":1,\"stock_quantity\":499999993790,\"quantity\":70},{\"id\":308,\"item_name_sinhala\":\"මිරිස් කරල්\",\"item_name_english\":\"miriskaral\",\"barcode\":\"915834944\",\"unit_of_measurement\":\"pcs\",\"regular_price\":1200,\"our_price\":1000,\"stock_quantity\":18,\"quantity\":0.1},{\"id\":246,\"item_name_sinhala\":\"සබන් කුඩු\",\"item_name_english\":\"saban kudu\",\"barcode\":\"974068643\",\"unit_of_measurement\":\"pcs\",\"regular_price\":320,\"our_price\":320,\"stock_quantity\":500,\"quantity\":1},{\"id\":380,\"item_name_sinhala\":\"සබන්\",\"item_name_english\":\"saban\",\"barcode\":\"622911681\",\"unit_of_measurement\":\"pcs\",\"regular_price\":1,\"our_price\":1,\"stock_quantity\":2550,\"quantity\":270},{\"id\":405,\"item_name_sinhala\":\"විම්\",\"item_name_english\":\"vim\",\"barcode\":\"511543996\",\"unit_of_measurement\":\"pcs\",\"regular_price\":50,\"our_price\":50,\"stock_quantity\":200,\"quantity\":2},{\"id\":112,\"item_name_sinhala\":\"කරවල\",\"item_name_english\":\"karawala\",\"barcode\":\"076194472\",\"unit_of_measurement\":\"pcs\",\"regular_price\":1,\"our_price\":1,\"stock_quantity\":1855,\"quantity\":215},{\"id\":187,\"item_name_sinhala\":\"වෙනත්\",\"item_name_english\":\"we3\",\"barcode\":\"419964757\",\"unit_of_measurement\":\"pcs\",\"regular_price\":1,\"our_price\":1,\"stock_quantity\":5000000000000,\"quantity\":305},{\"id\":413,\"item_name_sinhala\":\"තේ කොළ\",\"item_name_english\":\"thekola\",\"barcode\":\"727011522\",\"unit_of_measurement\":\"pcs\",\"regular_price\":1,\"our_price\":1,\"stock_quantity\":451259633,\"quantity\":600}]', '2025-11-24 06:45:01'),
(207, 50, '2025-11-25', NULL, NULL, NULL, 4620.00, 4500.00, 0.00, 0, 'cash', '<p style=\"margin: 3px 0; font-size: 14px; text-align: center; font-weight: bold;\">බිල් අංකය: 50</p><p style=\"margin: 3px 0; font-size: 14px; text-align: center;\">Date: 25/11/2025 Time: 17:30:17</p><div style=\"margin: 4px 0; border-bottom: 1px dashed black; width: 100%;\"></div></div><div class=\"bill-items\" style=\"margin-bottom: 8px;\"><div class=\"bill-item\" style=\"margin-bottom: 1px;\"><div style=\"display: flex; justify-content: space-between; align-items: center; margin-bottom: 1px;\"><span style=\"font-size: 16px; font-weight: bold; flex: 1; line-height: 1.0;\">පරිප්පු නො.1</span><span style=\"font-size: 16px; font-weight: bold; text-align: right;\">Rs.380.00</span></div><div style=\"display: flex; justify-content: space-between; font-size: 14px; font-weight: bold; color: #000000ff; margin-bottom: 5px; line-height: 1.1;\"><div style=\"line-height: 1.4;\"><div>සාමාන්‍ය මිල: Rs.400</div><div>අපේ මිල: Rs.380</div></div><div style=\"text-align: right; align-self: center; font-size: 12px;\">1.00 × Rs.380.00</div></div><div style=\"border-bottom: 1px dotted #000000ff; margin: 2px 0 2px 0; width: 100%;\"></div></div><div class=\"bill-item\" style=\"margin-bottom: 1px;\"><div style=\"display: flex; justify-content: space-between; align-items: center; margin-bottom: 1px;\"><span style=\"font-size: 16px; font-weight: bold; flex: 1; line-height: 1.0;\">බිත්තර</span><span style=\"font-size: 16px; font-weight: bold; text-align: right;\">Rs.525.00</span></div><div style=\"display: flex; justify-content: space-between; font-size: 14px; font-weight: bold; color: #000000ff; margin-bottom: 5px; line-height: 1.1;\"><div style=\"line-height: 1.4;\"><div>සාමාන්‍ය මිල: Rs.525</div><div>අපේ මිල: Rs.525</div></div><div style=\"text-align: right; align-self: center; font-size: 12px;\">15.00 × Rs.35.00</div></div><div style=\"border-bottom: 1px dotted #000000ff; margin: 2px 0 2px 0; width: 100%;\"></div></div><div class=\"bill-item\" style=\"margin-bottom: 1px;\"><div style=\"display: flex; justify-content: space-between; align-items: center; margin-bottom: 1px;\"><span style=\"font-size: 16px; font-weight: bold; flex: 1; line-height: 1.0;\">සමපෝෂ 700g</span><span style=\"font-size: 16px; font-weight: bold; text-align: right;\">Rs.580.00</span></div><div style=\"display: flex; justify-content: space-between; font-size: 14px; font-weight: bold; color: #000000ff; margin-bottom: 5px; line-height: 1.1;\"><div style=\"line-height: 1.4;\"><div>සාමාන්‍ය මිල: Rs.580</div><div>අපේ මිල: Rs.580</div></div><div style=\"text-align: right; align-self: center; font-size: 12px;\">1.00 × Rs.580.00</div></div><div style=\"border-bottom: 1px dotted #000000ff; margin: 2px 0 2px 0; width: 100%;\"></div></div><div class=\"bill-item\" style=\"margin-bottom: 1px;\"><div style=\"display: flex; justify-content: space-between; align-items: center; margin-bottom: 1px;\"><span style=\"font-size: 16px; font-weight: bold; flex: 1; line-height: 1.0;\">පැල්වත්ත කිරිපිටි 400g</span><span style=\"font-size: 16px; font-weight: bold; text-align: right;\">Rs.1125.00</span></div><div style=\"display: flex; justify-content: space-between; font-size: 14px; font-weight: bold; color: #000000ff; margin-bottom: 5px; line-height: 1.1;\"><div style=\"line-height: 1.4;\"><div>සාමාන්‍ය මිල: Rs.1125</div><div>අපේ මිල: Rs.1125</div></div><div style=\"text-align: right; align-self: center; font-size: 12px;\">1.00 × Rs.1125.00</div></div><div style=\"border-bottom: 1px dotted #000000ff; margin: 2px 0 2px 0; width: 100%;\"></div></div><div class=\"bill-item\" style=\"margin-bottom: 1px;\"><div style=\"display: flex; justify-content: space-between; align-items: center; margin-bottom: 1px;\"><span style=\"font-size: 16px; font-weight: bold; flex: 1; line-height: 1.0;\">කඩල</span><span style=\"font-size: 16px; font-weight: bold; text-align: right;\">Rs.240.00</span></div><div style=\"display: flex; justify-content: space-between; font-size: 14px; font-weight: bold; color: #000000ff; margin-bottom: 5px; line-height: 1.1;\"><div style=\"line-height: 1.4;\"><div>සාමාන්‍ය මිල: Rs.260</div><div>අපේ මිල: Rs.240</div></div><div style=\"text-align: right; align-self: center; font-size: 12px;\">0.50 × Rs.480.00</div></div><div style=\"border-bottom: 1px dotted #000000ff; margin: 2px 0 2px 0; width: 100%;\"></div></div><div class=\"bill-item\" style=\"margin-bottom: 1px;\"><div style=\"display: flex; justify-content: space-between; align-items: center; margin-bottom: 1px;\"><span style=\"font-size: 16px; font-weight: bold; flex: 1; line-height: 1.0;\">මන්චි නයිස් 400g</span><span style=\"font-size: 16px; font-weight: bold; text-align: right;\">Rs.430.00</span></div><div style=\"display: flex; justify-content: space-between; font-size: 14px; font-weight: bold; color: #000000ff; margin-bottom: 5px; line-height: 1.1;\"><div style=\"line-height: 1.4;\"><div>සාමාන්‍ය මිල: Rs.430</div><div>අපේ මිල: Rs.430</div></div><div style=\"text-align: right; align-self: center; font-size: 12px;\">1.00 × Rs.430.00</div></div><div style=\"border-bottom: 1px dotted #000000ff; margin: 2px 0 2px 0; width: 100%;\"></div></div><div class=\"bill-item\" style=\"margin-bottom: 1px;\"><div style=\"display: flex; justify-content: space-between; align-items: center; margin-bottom: 1px;\"><span style=\"font-size: 16px; font-weight: bold; flex: 1; line-height: 1.0;\">වෙනත්</span><span style=\"font-size: 16px; font-weight: bold; text-align: right;\">Rs.300.00</span></div><div style=\"display: flex; justify-content: space-between; font-size: 14px; font-weight: bold; color: #000000ff; margin-bottom: 5px; line-height: 1.1;\"><div style=\"line-height: 1.4;\"><div>සාමාන්‍ය මිල: Rs.300</div><div>අපේ මිල: Rs.300</div></div><div style=\"text-align: right; align-self: center; font-size: 12px;\">300.00 × Rs.1.00</div></div><div style=\"border-bottom: 1px dotted #000000ff; margin: 2px 0 2px 0; width: 100%;\"></div></div><div class=\"bill-item\" style=\"margin-bottom: 1px;\"><div style=\"display: flex; justify-content: space-between; align-items: center; margin-bottom: 1px;\"><span style=\"font-size: 16px; font-weight: bold; flex: 1; line-height: 1.0;\">සීනි පැකට් දුඹුරු</span><span style=\"font-size: 16px; font-weight: bold; text-align: right;\">Rs.270.00</span></div><div style=\"display: flex; justify-content: space-between; font-size: 14px; font-weight: bold; color: #000000ff; margin-bottom: 5px; line-height: 1.1;\"><div style=\"line-height: 1.4;\"><div>සාමාන්‍ය මිල: Rs.280</div><div>අපේ මිල: Rs.270</div></div><div style=\"text-align: right; align-self: center; font-size: 12px;\">1.00 × Rs.270.00</div></div><div style=\"border-bottom: 1px dotted #000000ff; margin: 2px 0 2px 0; width: 100%;\"></div></div><div class=\"bill-item\" style=\"margin-bottom: 1px;\"><div style=\"display: flex; justify-content: space-between; align-items: center; margin-bottom: 1px;\"><span style=\"font-size: 16px; font-weight: bold; flex: 1; line-height: 1.0;\">අල</span><span style=\"font-size: 16px; font-weight: bold; text-align: right;\">Rs.200.00</span></div><div style=\"display: flex; justify-content: space-between; font-size: 14px; font-weight: bold; color: #000000ff; margin-bottom: 5px; line-height: 1.1;\"><div style=\"line-height: 1.4;\"><div>සාමාන්‍ය මිල: Rs.210</div><div>අපේ මිල: Rs.200</div></div><div style=\"text-align: right; align-self: center; font-size: 12px;\">1.00 × Rs.200.00</div></div><div style=\"border-bottom: 1px dotted #000000ff; margin: 2px 0 2px 0; width: 100%;\"></div></div><div class=\"bill-item\" style=\"margin-bottom: 1px;\"><div style=\"display: flex; justify-content: space-between; align-items: center; margin-bottom: 1px;\"><span style=\"font-size: 16px; font-weight: bold; flex: 1; line-height: 1.0;\">හාල්මැස්සන්</span><span style=\"font-size: 16px; font-weight: bold; text-align: right;\">Rs.240.00</span></div><div style=\"display: flex; justify-content: space-between; font-size: 14px; font-weight: bold; color: #000000ff; margin-bottom: 5px; line-height: 1.1;\"><div style=\"line-height: 1.4;\"><div>සාමාන්‍ය මිල: Rs.260</div><div>අපේ මිල: Rs.240</div></div><div style=\"text-align: right; align-self: center; font-size: 12px;\">0.20 × Rs.1200.00</div></div><div style=\"border-bottom: 1px dotted #000000ff; margin: 2px 0 2px 0; width: 100%;\"></div></div><div class=\"bill-item\" style=\"margin-bottom: 1px;\"><div style=\"display: flex; justify-content: space-between; align-items: center; margin-bottom: 1px;\"><span style=\"font-size: 16px; font-weight: bold; flex: 1; line-height: 1.0;\">කරවල</span><span style=\"font-size: 16px; font-weight: bold; text-align: right;\">Rs.330.00</span></div><div style=\"display: flex; justify-content: space-between; font-size: 14px; font-weight: bold; color: #000000ff; margin-bottom: 5px; line-height: 1.1;\"><div style=\"line-height: 1.4;\"><div>සාමාන්‍ය මිල: Rs.330</div><div>අපේ මිල: Rs.330</div></div><div style=\"text-align: right; align-self: center; font-size: 12px;\">330.00 × Rs.1.00</div></div></div></div><div class=\"bill-summary\" style=\"text-align: right; font-size: 15px; margin-bottom: 4px;\"><div style=\"margin: 6px 0; font-weight: bold; font-size: 28px;\">මුළු මුදල: Rs. 4620.00</div><div style=\"margin: 4px 0; font-weight: bold;\">ගෙවූ මුදල: Rs. 4500.00</div><div style=\"margin: 4px 0; font-size: 14px; font-weight: bold;\">ඉතිරි මුදල: Rs. 0.00</div><div style=\"border: 1px solid black; padding: 20px; margin-top: 8px; width: 100%; background-color: #ffffffff;\"><div style=\"text-align: center; font-size: 10px; font-weight: bold; line-height: 1.7;\">අපෙන් භාණ්ඩ ලබා ගැනීමෙන් ඔබ ලැබූ ලාභය<br><span style=\"font-size: 12px; color: #000000ff;\">Rs.80.00</span></div></div><div class=\"bill-footer\" style=\"text-align: center; font-size: 13px;\"><p style=\"margin: 4px 0; font-size: 15px;\">ස්තූතියි! නැවත එන්න</p></div>', '[{\"id\":108,\"item_name_sinhala\":\"පරිප්පු නො.1\",\"item_name_english\":\"parippu\",\"barcode\":\"965372777\",\"unit_of_measurement\":\"pcs\",\"regular_price\":400,\"our_price\":380,\"stock_quantity\":46,\"quantity\":1},{\"id\":110,\"item_name_sinhala\":\"බිත්තර\",\"item_name_english\":\"biththara\",\"barcode\":\"015366342\",\"unit_of_measurement\":\"pcs\",\"regular_price\":35,\"our_price\":35,\"stock_quantity\":405,\"quantity\":15},{\"id\":131,\"item_name_sinhala\":\"සමපෝෂ 700g\",\"item_name_english\":\"samapo\",\"barcode\":\"4792109000864\",\"unit_of_measurement\":\"pcs\",\"regular_price\":580,\"our_price\":580,\"stock_quantity\":19,\"quantity\":1},{\"id\":147,\"item_name_sinhala\":\"පැල්වත්ත කිරිපිටි 400g\",\"item_name_english\":\"pelwatte\",\"barcode\":\"4796004080440\",\"unit_of_measurement\":\"pcs\",\"regular_price\":1125,\"our_price\":1125,\"stock_quantity\":18,\"quantity\":1},{\"id\":116,\"item_name_sinhala\":\"කඩල\",\"item_name_english\":\"kadala\",\"barcode\":\"349521076\",\"unit_of_measurement\":\"pcs\",\"regular_price\":520,\"our_price\":480,\"stock_quantity\":15,\"quantity\":0.5},{\"id\":24,\"item_name_sinhala\":\"මන්චි නයිස් 400g\",\"item_name_english\":\"mnice\",\"barcode\":\"8888101020101\",\"unit_of_measurement\":\"pcs\",\"regular_price\":430,\"our_price\":430,\"stock_quantity\":50,\"quantity\":1},{\"id\":88,\"item_name_sinhala\":\"වෙනත්\",\"item_name_english\":\"we\",\"barcode\":\"045504190\",\"unit_of_measurement\":\"pcs\",\"regular_price\":1,\"our_price\":1,\"stock_quantity\":9.223372036854776e+18,\"quantity\":300},{\"id\":4,\"item_name_sinhala\":\"සීනි පැකට් දුඹුරු\",\"item_name_english\":\"sini\",\"barcode\":\"1004\",\"unit_of_measurement\":\"kg\",\"regular_price\":280,\"our_price\":270,\"stock_quantity\":86,\"quantity\":1},{\"id\":104,\"item_name_sinhala\":\"අල\",\"item_name_english\":\"ala\",\"barcode\":\"004786426\",\"unit_of_measurement\":\"pcs\",\"regular_price\":210,\"our_price\":200,\"stock_quantity\":3993,\"quantity\":1},{\"id\":111,\"item_name_sinhala\":\"හාල්මැස්සන්\",\"item_name_english\":\"halmasso\",\"barcode\":\"040630134-\",\"unit_of_measurement\":\"pcs\",\"regular_price\":1300,\"our_price\":1200,\"stock_quantity\":20,\"quantity\":0.2},{\"id\":112,\"item_name_sinhala\":\"කරවල\",\"item_name_english\":\"karawala\",\"barcode\":\"076194472\",\"unit_of_measurement\":\"pcs\",\"regular_price\":1,\"our_price\":1,\"stock_quantity\":1640,\"quantity\":330}]', '2025-11-25 12:00:17'),
(208, 50, '2025-12-05', NULL, NULL, NULL, 1.00, 0.00, 0.00, 0, 'cash', '<div class=\"bill-header\" style=\"padding-top: 0; margin-top: 0;\"><div style=\"text-align: center; margin-bottom: 8px; margin-top: 0; padding-top: 0;\"><img src=\"logo.png\" alt=\"Store Logo\" style=\"max-width: 100%; width: 95%; height: auto; max-height: 300px; margin-top: 0; margin-bottom: 6px; display: block; margin-left: auto; margin-right: auto; object-fit: contain; padding-top: 0;\"><h2 style=\"margin: 4px 0 0 0; font-size: 22px; font-weight: bold;\"></h2></div><p style=\"margin: 3px 0; font-size: 14px; text-align: center;\">පාසල අසල දොරපනේ</p><p style=\"margin: 3px 0; font-size: 14px; text-align: center;\">Tel: 071-3552017</p><p style=\"margin: 3px 0; font-size: 14px; text-align: center; font-weight: bold;\">බිල් අංකය: 50</p><p style=\"margin: 3px 0; font-size: 14px; text-align: center;\">Date: 05/12/2025 Time: 16:31:58</p><div style=\"margin: 4px 0; border-bottom: 1px dashed black; width: 100%;\"></div></div><div class=\"bill-items\" style=\"margin-bottom: 8px;\"><div class=\"bill-item\" style=\"margin-bottom: 1px;\"><div style=\"display: flex; justify-content: space-between; align-items: center; margin-bottom: 1px;\"><span style=\"font-size: 16px; font-weight: bold; flex: 1; line-height: 1.0;\">සබන්</span><span style=\"font-size: 16px; font-weight: bold; text-align: right;\">Rs.1.00</span></div><div style=\"display: flex; justify-content: space-between; font-size: 14px; font-weight: bold; color: #000000ff; margin-bottom: 5px; line-height: 1.1;\"><div style=\"line-height: 1.4;\"><div>සාමාන්‍ය මිල: Rs.1</div><div>අපේ මිල: Rs.1</div></div><div style=\"text-align: right; align-self: center; font-size: 12px;\">1.00 × Rs.1.00</div></div></div></div><div class=\"bill-summary\" style=\"text-align: right; font-size: 15px; margin-bottom: 4px;\"><div style=\"margin: 6px 0; font-weight: bold; font-size: 28px;\">මුළු මුදල: Rs. 1.00</div><div style=\"margin: 4px 0; font-weight: bold;\">ගෙවූ මුදල: Rs. 0.00</div><div style=\"margin: 4px 0; font-size: 14px; font-weight: bold;\">ඉතිරි මුදල: Rs. 0.00</div><div style=\"border: 1px solid black; padding: 20px; margin-top: 8px; width: 100%; background-color: #ffffffff;\"><div style=\"text-align: center; font-size: 10px; font-weight: bold; line-height: 1.7;\">අපෙන් භාණ්ඩ ලබා ගැනීමෙන් ඔබ ලැබූ ලාභය<br><span style=\"font-size: 12px; color: #000000ff;\">Rs.0.00</span></div></div><div class=\"bill-footer\" style=\"text-align: center; font-size: 13px;\"><p style=\"margin: 4px 0; font-size: 15px;\">ස්තූතියි! නැවත එන්න</p><p style=\"margin: 6px 0; font-size: 12px;\">=== Gadget Technologies 071-1071666 ===</p></div>', '[{\"id\":380,\"item_name_sinhala\":\"සබන්\",\"item_name_english\":\"saban\",\"barcode\":\"622911681\",\"unit_of_measurement\":\"pcs\",\"regular_price\":1,\"our_price\":1,\"stock_quantity\":2280,\"quantity\":1}]', '2025-12-05 11:01:58'),
(209, 51, '2025-12-05', NULL, NULL, NULL, 1.00, 0.00, 0.00, 0, 'cash', '<div class=\"bill-header\" style=\"padding-top: 0; margin-top: 0;\"><div style=\"text-align: center; margin-bottom: 8px; margin-top: 0; padding-top: 0;\"><img src=\"logo.png\" alt=\"Store Logo\" style=\"max-width: 100%; width: 95%; height: auto; max-height: 300px; margin-top: 0; margin-bottom: 6px; display: block; margin-left: auto; margin-right: auto; object-fit: contain; padding-top: 0;\"><h2 style=\"margin: 4px 0 0 0; font-size: 22px; font-weight: bold;\"></h2></div><p style=\"margin: 3px 0; font-size: 14px; text-align: center;\">පාසල අසල දොරපනේ</p><p style=\"margin: 3px 0; font-size: 14px; text-align: center;\">Tel: 071-3552017</p><p style=\"margin: 3px 0; font-size: 14px; text-align: center; font-weight: bold;\">බිල් අංකය: 51</p><p style=\"margin: 3px 0; font-size: 14px; text-align: center;\">Date: 05/12/2025 Time: 22:29:03</p><div style=\"margin: 4px 0; border-bottom: 1px dashed black; width: 100%;\"></div></div><div class=\"bill-items\" style=\"margin-bottom: 8px;\"><div class=\"bill-item\" style=\"margin-bottom: 1px;\"><div style=\"display: flex; justify-content: space-between; align-items: center; margin-bottom: 1px;\"><span style=\"font-size: 16px; font-weight: bold; flex: 1; line-height: 1.0;\">සබන්</span><span style=\"font-size: 16px; font-weight: bold; text-align: right;\">Rs.1.00</span></div><div style=\"display: flex; justify-content: space-between; font-size: 14px; font-weight: bold; color: #000000ff; margin-bottom: 5px; line-height: 1.1;\"><div style=\"line-height: 1.4;\"><div>සාමාන්‍ය මිල: Rs.1</div><div>අපේ මිල: Rs.1</div></div><div style=\"text-align: right; align-self: center; font-size: 12px;\">1.00 × Rs.1.00</div></div></div></div><div class=\"bill-summary\" style=\"text-align: right; font-size: 15px; margin-bottom: 4px;\"><div style=\"margin: 6px 0; font-weight: bold; font-size: 28px;\">මුළු මුදල: Rs. 1.00</div><div style=\"margin: 4px 0; font-weight: bold;\">ගෙවූ මුදල: Rs. 0.00</div><div style=\"margin: 4px 0; font-size: 14px; font-weight: bold;\">ඉතිරි මුදල: Rs. 0.00</div><div style=\"border: 1px solid black; padding: 20px; margin-top: 8px; width: 100%; background-color: #ffffffff;\"><div style=\"text-align: center; font-size: 10px; font-weight: bold; line-height: 1.7;\">අපෙන් භාණ්ඩ ලබා ගැනීමෙන් ඔබ ලැබූ ලාභය<br><span style=\"font-size: 12px; color: #000000ff;\">Rs.0.00</span></div></div><div class=\"bill-footer\" style=\"text-align: center; font-size: 13px;\"><p style=\"margin: 4px 0; font-size: 15px;\">ස්තූතියි! නැවත එන්න</p><p style=\"margin: 6px 0; font-size: 12px;\">=== Gadget Technologies 071-1071666 ===</p></div>', '[{\"id\":380,\"item_name_sinhala\":\"සබන්\",\"item_name_english\":\"saban\",\"barcode\":\"622911681\",\"unit_of_measurement\":\"pcs\",\"regular_price\":1,\"our_price\":1,\"stock_quantity\":2279,\"quantity\":1}]', '2025-12-05 16:59:03');

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

--
-- Table structure for table `customers`
--

CREATE TABLE `customers` (
  `id` int NOT NULL,
  `customer_code` varchar(20) NOT NULL,
  `customer_name` varchar(100) NOT NULL,
  `phone` varchar(15) NOT NULL,
  `email` varchar(100) DEFAULT NULL,
  `address` text,
  `total_credit` decimal(10,2) DEFAULT '0.00',
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `customers`
--

INSERT INTO `customers` (`id`, `customer_code`, `customer_name`, `phone`, `email`, `address`, `total_credit`, `created_at`, `updated_at`) VALUES
(1, 'CUST0779', 'Isuru Lakshitha Ariyawansha', '0711071666', 'lakshithaariyawanshaofficial7@gmail.com', '', 2.00, '2025-12-05 17:07:32', '2025-12-05 17:14:04');

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

--
-- Table structure for table `customer_credits`
--

CREATE TABLE `customer_credits` (
  `id` int NOT NULL,
  `customer_id` int NOT NULL,
  `bill_id` int DEFAULT NULL,
  `transaction_type` enum('debit','credit','payment') NOT NULL,
  `amount` decimal(10,2) NOT NULL,
  `balance_after` decimal(10,2) NOT NULL,
  `description` text,
  `payment_method` varchar(20) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `customer_credits`
--

INSERT INTO `customer_credits` (`id`, `customer_id`, `bill_id`, `transaction_type`, `amount`, `balance_after`, `description`, `payment_method`, `created_at`) VALUES
(1, 1, 209, 'debit', 1.00, 1.00, 'Credit from Bill #209', NULL, '2025-12-05 17:13:51'),
(2, 1, 208, 'debit', 1.00, 2.00, 'Credit from Bill #208', NULL, '2025-12-05 17:14:04');

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

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

CREATE TABLE `sales` (
  `id` int NOT NULL,
  `item_name_sinhala` varchar(255) NOT NULL COMMENT 'අයිතම නම සිංහල',
  `barcode` varchar(50) NOT NULL COMMENT 'බාර්කෝඩ්',
  `item_name_english` varchar(255) NOT NULL COMMENT 'අයිතම නම ඉංග්‍රීසි',
  `unit_of_measurement` varchar(50) NOT NULL COMMENT 'ප්‍රමාණය මනින ඒකකය',
  `regular_price` decimal(10,2) NOT NULL COMMENT 'සාමාන්‍ය මිල',
  `our_price` decimal(10,2) NOT NULL COMMENT 'අපේ මිල',
  `price_per_item` decimal(10,2) DEFAULT '0.00',
  `stock_quantity` decimal(65,30) NOT NULL DEFAULT '0.000000000000000000000000000000',
  `stock_alert_quantity` int NOT NULL DEFAULT '10' COMMENT 'තොග අවසන් වීමට දන්විය යුතු ප්‍රමාණය',
  `created_date` datetime DEFAULT CURRENT_TIMESTAMP COMMENT 'එකතු කළ දිනය',
  `updated_date` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'අලුත් කළ දිනය',
  `status` enum('active','inactive') DEFAULT 'active' COMMENT 'තත්වය'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

INSERT INTO `sales` (`id`, `item_name_sinhala`, `barcode`, `item_name_english`, `unit_of_measurement`, `regular_price`, `our_price`, `price_per_item`, `stock_quantity`, `stock_alert_quantity`, `created_date`, `updated_date`, `status`) VALUES
(1, 'සහල් 1kg', '1001', 'Rice 1kg', 'kg', 160.00, 150.00, 0.00, 38.000000000000000000000000000000, 10, '2025-09-02 18:36:25', '2025-09-03 03:11:02', 'inactive'),
(2, 'පාන්', '1002', 'Bread', 'pcs', 90.00, 80.00, 0.00, 10.000000000000000000000000000000, 5, '2025-09-02 18:36:25', '2025-09-03 03:10:52', 'inactive'),
(3, 'කිරි 1L', '1003', 'Milk 1L', 'L', 220.00, 200.00, 0.00, 29.000000000000000000000000000000, 8, '2025-09-02 18:36:25', '2025-09-03 03:10:41', 'inactive'),
(4, 'සීනි පැකට් දුඹුරු', '1004', 'sini', 'kg', 280.00, 270.00, 238.00, 85.000000000000000000000000000000, 12, '2025-09-02 18:36:25', '2025-11-25 17:30:17', 'active'),
(5, 'තේ පැකට්', '1005', 'Tea Packets', 'pcs', 270.00, 250.00, 0.00, 36.000000000000000000000000000000, 15, '2025-09-02 18:36:25', '2025-09-03 03:10:47', 'inactive'),
(6, 'බිස්කට්', '1006', 'Biscuits', 'pcs', 50.00, 45.00, 0.00, 77.000000000000000000000000000000, 20, '2025-09-02 18:36:25', '2025-09-03 03:10:57', 'inactive'),
(7, 'සබන්', '1007', 'Soap', 'pcs', 95.00, 85.00, 0.00, 33.000000000000000000000000000000, 10, '2025-09-02 18:36:25', '2025-09-03 03:11:00', 'inactive'),
(8, 'ෂැම්පූ', '1008', 'Shampoo', 'ml', 340.00, 320.00, 0.00, 18.000000000000000000000000000000, 5, '2025-09-02 18:36:25', '2025-09-03 03:10:59', 'inactive'),
(9, 'බිත්තර 10', '1009', 'Eggs 10pcs', 'pcs', 320.00, 300.00, 0.00, 20.000000000000000000000000000000, 5, '2025-09-02 18:36:25', '2025-09-03 03:10:55', 'inactive'),
(10, 'පොල් තෙල් 500ml', '1010', 'Coconut Oil 500ml', 'ml', 300.00, 280.00, 0.00, 5000.000000000000000000000000000000, 8, '2025-09-02 18:36:25', '2025-09-03 03:10:53', 'inactive'),
(11, 'ඇට 250g', '1011', 'Lentils 250g', 'g', 180.00, 160.00, 0.00, 15.000000000000000000000000000000, 8, '2025-09-02 18:36:25', '2025-09-03 03:10:36', 'inactive'),
(12, 'ගම්මිරිස් 100g', '1012', 'Pepper 100g', 'g', 120.00, 110.00, 0.00, 40.000000000000000000000000000000, 5, '2025-09-02 18:36:25', '2025-09-03 03:10:43', 'inactive'),
(13, 'ගෑස්', '067156039', 'gas', 'pcs', 4250.00, 4250.00, 4200.00, 6.000000000000000000000000000000, 2, '2025-09-03 03:08:37', '2025-09-03 03:10:45', 'inactive'),
(14, 'ගෑස්', 'RP20406480', 'gas', 'pcs', 4200.00, 4000.00, 3000.00, 10.000000000000000000000000000000, 2, '2025-09-03 03:20:07', '2025-10-11 18:02:53', 'inactive'),
(15, 'මන්චි ක්‍රීම් ක්‍රැකර් 490g', '8888101430115', 'mcra', 'pcs', 420.00, 420.00, 320.00, 50.000000000000000000000000000000, 10, '2025-10-11 17:54:22', '2025-10-13 13:56:16', 'active'),
(16, 'මැලිබන් ක්‍රීම් ක්‍රැකර් 490g', '4791034042215', 'macra', 'pcs', 420.00, 400.00, 400.00, 50.000000000000000000000000000000, 10, '2025-10-11 17:59:03', '2025-10-13 13:56:36', 'active'),
(17, 'චෙරිස් ක්‍රීම් ක්‍රැකර් 500g', '4792102007198', 'ccra', 'pcs', 400.00, 350.00, 320.00, 50.000000000000000000000000000000, 10, '2025-10-11 18:00:30', '2025-10-13 13:55:24', 'active'),
(18, 'මන්චි ක්‍රීම් ක්‍රැකර් 190g', '8888101430337', 'mcra', 'pcs', 200.00, 200.00, 180.00, 49.000000000000000000000000000000, 10, '2025-10-11 18:01:34', '2025-11-16 17:35:16', 'active'),
(19, 'මන්චි ක්‍රීම් ක්‍රැකර් 230g', '8888101430399', 'mcra', 'pcs', 230.00, 230.00, 200.00, 50.000000000000000000000000000000, 10, '2025-10-11 18:02:04', '2025-10-13 13:56:24', 'active'),
(20, 'මන්චි ක්‍රීම් ක්‍රැකර් 125g', '8888101430153', 'mcra', 'pcs', 140.00, 140.00, 100.00, 49.000000000000000000000000000000, 10, '2025-10-11 18:02:37', '2025-11-10 18:01:25', 'active'),
(21, 'චෙරිස් නයිස්', '4792102003008', 'cnice', 'pcs', 430.00, 380.00, 330.00, 50.000000000000000000000000000000, 10, '2025-10-11 18:04:04', '2025-10-11 18:04:21', 'active'),
(22, 'මන්චි නයිස් 100g', '8888101020200', 'mnice', 'pcs', 110.00, 110.00, 100.00, 50.000000000000000000000000000000, 10, '2025-10-11 18:05:33', '2025-10-11 18:06:21', 'active'),
(23, 'මන්චි නයිස් 200g', '442681010', 'mnice', 'pcs', 220.00, 220.00, 200.00, 50.000000000000000000000000000000, 10, '2025-10-13 13:47:41', '2025-10-13 13:47:41', 'active'),
(24, 'මන්චි නයිස් 400g', '8888101020101', 'mnice', 'pcs', 430.00, 430.00, 400.00, 49.000000000000000000000000000000, 10, '2025-10-13 13:48:14', '2025-11-25 17:30:17', 'active'),
(25, 'මන්චි චොකලට් ක්‍රීම් බිස්කට් 100g', '8888101270018', 'mcho', 'pcs', 130.00, 130.00, 100.00, 49.000000000000000000000000000000, 10, '2025-10-13 13:49:31', '2025-11-10 18:01:25', 'active'),
(26, 'මන්චි චොකලට් ක්‍රීම් බිස්කට් 210g', '4792192845366', 'mcho', 'pcs', 240.00, 240.00, 200.00, 49.000000000000000000000000000000, 10, '2025-10-13 13:50:48', '2025-10-27 18:16:33', 'active'),
(27, 'මන්චි චොකලට් ක්‍රීම් බිස්කට් 365g', '4792192851701', 'mcho', 'pcs', 410.00, 410.00, 400.00, 49.000000000000000000000000000000, 10, '2025-10-13 13:51:23', '2025-11-21 11:52:05', 'active'),
(28, 'මැලිබන් චොකලට් ක්‍රීම් බිස්කට් 400g', '4791034070546', 'macho', 'pcs', 450.00, 450.00, 400.00, 49.000000000000000000000000000000, 10, '2025-10-13 13:53:14', '2025-11-18 15:35:53', 'active'),
(29, 'චෙරිස් චොකලට් ක්‍රීම් බිස්කට් 365g', '4792102016152', 'ccho', 'pcs', 400.00, 360.00, 380.00, 4988888888888888.000000000000000000000000000000, 10, '2025-10-13 13:54:20', '2025-11-19 18:53:12', 'active'),
(30, 'සීනි 500g', '169505237', 'sini', 'pcs', 140.00, 130.00, 119.00, 200.000000000000000000000000000000, 10, '2025-10-13 14:02:46', '2025-10-26 11:56:18', 'inactive'),
(31, 'මන්චි හවායන් කුකීස් බිස්කට් 200g', '8888101080402', 'mha', 'pcs', 240.00, 240.00, 200.00, 49.000000000000000000000000000000, 10, '2025-10-13 14:17:22', '2025-10-27 18:07:07', 'active'),
(32, 'මන්චි හවායන් කුකීස් බිස්කට් 100g', '8888101080204', 'mha', 'pcs', 130.00, 130.00, 100.00, 50.000000000000000000000000000000, 10, '2025-10-13 14:18:05', '2025-10-13 14:18:05', 'active'),
(33, 'මන්චි ඔරේන්ජ් ක්‍රීම් බිස්කට් 210g', '4792192848718', 'mo', 'pcs', 220.00, 220.00, 200.00, 50.000000000000000000000000000000, 10, '2025-10-13 14:19:06', '2025-10-13 14:19:06', 'active'),
(34, 'ලිට්ල් ලයන් බැට කැරෝල් බිස්කට් 90g', '4792232001011', 'lba', 'pcs', 125.00, 125.00, 100.00, 50.000000000000000000000000000000, 10, '2025-10-13 14:20:18', '2025-10-13 14:21:40', 'active'),
(35, 'මන්චි ටිකිරි මාරි 145g', '8888101280550', 'mti', 'pcs', 150.00, 150.00, 130.00, 50.000000000000000000000000000000, 10, '2025-10-13 14:21:09', '2025-10-13 14:21:09', 'active'),
(36, 'මන්චි චොක්ලට් මාරි 200g', '4792192845823', 'mcm', 'pcs', 220.00, 220.00, 200.00, 50.000000000000000000000000000000, 10, '2025-10-13 14:23:49', '2025-10-13 14:23:49', 'active'),
(37, 'මන්චි ටිෆින් බිස්කට් 125g', '8888101931193', 'tifin', 'pcs', 190.00, 190.00, 170.00, 50.000000000000000000000000000000, 10, '2025-10-13 14:25:02', '2025-11-06 12:52:21', 'active'),
(38, 'මන්චි ටිෆින් බිස්කට් 125g', '8888101932190', 'mt', 'pcs', 190.00, 190.00, 170.00, 50.000000000000000000000000000000, 10, '2025-10-13 14:25:40', '2025-10-13 14:25:54', 'inactive'),
(44, 'මන්චි මිල්ක් ක්‍රීම් බිස්කට් 220g', '4792192848350', 'mm', 'pcs', 220.00, 220.00, 200.00, 48.000000000000000000000000000000, 10, '2025-10-13 14:29:59', '2025-11-10 20:15:22', 'active'),
(45, 'මන්චි ලෙමන් පෆ් 200g', '8888101090401', 'ml', 'pcs', 250.00, 250.00, 230.00, 50.000000000000000000000000000000, 10, '2025-10-13 14:30:50', '2025-10-13 14:30:50', 'active'),
(46, 'මන්චි චොක්ලට් පෆ් 200g', '8888101271404', 'mch', 'pcs', 250.00, 250.00, 230.00, 50.000000000000000000000000000000, 10, '2025-10-13 14:32:18', '2025-10-13 14:32:18', 'active'),
(47, 'මන්චි චීස් ක්‍රැකර්', '8888101131401', 'mchee', 'pcs', 270.00, 270.00, 250.00, 50.000000000000000000000000000000, 10, '2025-10-13 14:38:03', '2025-10-13 14:38:03', 'active'),
(48, 'චෙරිස් බ්ලැක් ඇන්ඩ් වයිට් 330g', '4792102007662', 'cbla', 'pcs', 400.00, 400.00, 380.00, 50.000000000000000000000000000000, 10, '2025-10-13 14:38:54', '2025-10-13 14:38:54', 'active'),
(49, 'මන්චි ඉගුරු බිස්කට් 200g', '8888101570408', 'mg', 'pcs', 220.00, 220.00, 200.00, 50.000000000000000000000000000000, 10, '2025-10-13 14:40:20', '2025-10-13 14:40:20', 'active'),
(50, 'මැලිබන් මිල්ක් ශෝර්ට් කේක් බිස්කට් 200g', '4791034070874', 'mamilk', 'pcs', 230.00, 230.00, 210.00, 50.000000000000000000000000000000, 10, '2025-10-13 14:41:18', '2025-10-13 14:41:18', 'active'),
(51, 'මන්චි ටිකිරි මාරි 80g', '8888101280208', 'mti', 'pcs', 90.00, 90.00, 80.00, 50.000000000000000000000000000000, 10, '2025-10-13 14:42:03', '2025-10-13 14:42:03', 'active'),
(52, 'මන්චි ඉගුරු බිස්කට් 85g', '8888101570286', 'mg', 'pcs', 120.00, 120.00, 110.00, 50.000000000000000000000000000000, 10, '2025-10-13 14:42:44', '2025-10-13 14:42:44', 'active'),
(53, 'චෙරිස් මිල්ක් මාරි 75g', '4792102007150', 'cm', 'pcs', 80.00, 80.00, 70.00, 50.000000000000000000000000000000, 10, '2025-10-13 14:43:47', '2025-10-13 14:43:47', 'active'),
(54, 'මන්චි චොක්ලට් මාරි 400g', '8888101281106', 'mcho', 'pcs', 400.00, 400.00, 380.00, 50.000000000000000000000000000000, 10, '2025-10-13 14:44:34', '2025-10-13 14:44:34', 'active'),
(55, 'ලිට්ල් ලයන් මිල්කි කුකීස් 200g', '4792232002070', 'lmi', 'pcs', 280.00, 280.00, 270.00, 50.000000000000000000000000000000, 10, '2025-10-13 14:45:38', '2025-10-13 14:45:38', 'active'),
(56, 'මන්චි චොක්ලට් මාරි 90g', '8888101281205', 'mcho', 'pcs', 100.00, 100.00, 90.00, 50.000000000000000000000000000000, 10, '2025-10-13 14:46:34', '2025-10-13 14:46:34', 'active'),
(57, 'මැලිබන් ඔරේන්ජ් ක්‍රීම් 410g', '4791034070614', 'maor', 'pcs', 420.00, 420.00, 400.00, 50.000000000000000000000000000000, 10, '2025-10-13 15:02:44', '2025-10-13 15:02:44', 'active'),
(58, 'මැලිබන් කස්ටර්ඩ් ක්‍රීම් 410g', '4791034070607', 'macus', 'pcs', 420.00, 420.00, 400.00, 50.000000000000000000000000000000, 10, '2025-10-13 15:05:14', '2025-10-13 15:05:14', 'active'),
(59, 'මැලිබන් ඉගුරු බිස්කට් 370g', '4791034070218', 'magin', 'pcs', 420.00, 420.00, 400.00, 50.000000000000000000000000000000, 10, '2025-10-13 15:06:32', '2025-10-13 15:06:32', 'active'),
(60, 'ලිට්ල් ලයන් බැට කැරෝල් 250g', '4792232001158', 'lba', 'pcs', 330.00, 330.00, 310.00, 50.000000000000000000000000000000, 10, '2025-10-13 15:07:47', '2025-10-13 15:07:47', 'active'),
(61, 'ලිට්ල් ලයන් බැට කැරෝල් 335g', '4792232001103', 'lba', 'pcs', 400.00, 400.00, 380.00, 50.000000000000000000000000000000, 10, '2025-10-13 15:08:31', '2025-10-13 15:08:31', 'active'),
(62, 'මන්චි ටිකිරි මාරි 360g', '8888101280109', 'mti', 'pcs', 330.00, 330.00, 310.00, 50.000000000000000000000000000000, 10, '2025-10-13 15:09:12', '2025-10-13 15:09:12', 'active'),
(63, 'මැලිබන් යෝයෝ බිස්කට් 50g', '4791034070485', 'mayoyo', 'pcs', 50.00, 50.00, 45.00, 50.000000000000000000000000000000, 10, '2025-10-13 15:11:53', '2025-10-13 15:11:53', 'active'),
(64, 'මැලිබන් යෝයෝ බිස්කට් 50g', '4791034070508', 'mayoyo', 'pcs', 50.00, 50.00, 45.00, 50.000000000000000000000000000000, 10, '2025-10-13 15:13:02', '2025-10-13 15:13:02', 'active'),
(65, 'මන්චි ලයිට් මාරි බිස්කට් 50g', '8888101287238', 'mli', 'pcs', 50.00, 50.00, 45.00, 50.000000000000000000000000000000, 10, '2025-10-13 15:14:05', '2025-10-13 15:14:05', 'active'),
(66, 'ඩෙල්මාලයිට්', '4796000520018', 'del', 'pcs', 170.00, 170.00, 160.00, 98.823529411764700000000000000000, 10, '2025-10-13 15:19:33', '2025-11-10 20:15:22', 'active'),
(67, 'සන්ලයිට්', '4792081039869', 'sun', 'pcs', 440.00, 440.00, 420.00, 49.000000000000000000000000000000, 10, '2025-10-13 15:20:28', '2025-11-16 16:54:49', 'active'),
(68, 'වොන්ඩර්ලයිට්', '4792081038657', 'won', 'pcs', 200.00, 200.00, 190.00, 1000.000000000000000000000000000000, 10, '2025-10-13 15:21:10', '2025-11-11 08:13:47', 'active'),
(69, 'ඩෙල්මා ඩිශ් වොශ් බාර්', '4796000523903', 'dish', 'pcs', 50.00, 50.00, 45.00, 50.000000000000000000000000000000, 10, '2025-10-13 15:22:09', '2025-10-13 15:22:09', 'active'),
(70, 'බේබි සබන්', '4791111100302', 'baby', 'pcs', 145.00, 130.00, 105.00, 50.000000000000000000000000000000, 10, '2025-10-13 15:22:58', '2025-10-20 14:47:48', 'active'),
(71, 'වෙල්වට්', '4791111153230', 'vel', 'pcs', 125.00, 125.00, 115.00, 100.000000000000000000000000000000, 10, '2025-10-13 15:23:36', '2025-11-11 08:11:33', 'active'),
(72, 'බේබි සබන්', '4796010932351', 'baby', 'pcs', 140.00, 140.00, 130.00, 50.000000000000000000000000000000, 10, '2025-10-13 15:25:01', '2025-10-13 15:25:01', 'active'),
(73, 'ලක්ස්', '4792081040940', 'lux', 'pcs', 125.00, 125.00, 115.00, 50.000000000000000000000000000000, 10, '2025-10-13 15:25:32', '2025-10-13 15:25:32', 'active'),
(74, '‍රාණි සබන්', '4792068112233', 'rani', 'pcs', 125.00, 125.00, 115.00, 50.000000000000000000000000000000, 10, '2025-10-13 15:26:14', '2025-10-13 15:26:14', 'active'),
(75, 'කැලීන් සබන්', '4796000523385', 'calin', 'pcs', 150.00, 150.00, 140.00, 50.000000000000000000000000000000, 10, '2025-10-13 15:26:53', '2025-11-11 08:08:18', 'inactive'),
(76, 'සුදන්ත', '4792022090324', 'sudantha', 'pcs', 320.00, 320.00, 300.00, 48.281250000000000000000000000000, 10, '2025-10-13 15:27:32', '2025-11-07 03:53:35', 'active'),
(77, 'ඩිවෝන් සබන්', '4796000520933', 'divon', 'pcs', 125.00, 125.00, 115.00, 50.000000000000000000000000000000, 10, '2025-10-13 15:28:02', '2025-10-13 15:28:02', 'active'),
(78, 'සුපිරිවිකී', '4792172002031', 'supiri', 'pcs', 200.00, 200.00, 180.00, 50.000000000000000000000000000000, 10, '2025-10-13 15:28:40', '2025-10-13 15:28:40', 'active'),
(79, 'සිග්නල් ටූත් පේස්ට්', '4792081029440', 'signal', 'pcs', 200.00, 200.00, 180.00, 50.000000000000000000000000000000, 10, '2025-10-13 15:29:29', '2025-10-13 15:29:29', 'active'),
(80, 'සිග්නල් ටූත් පේස්ට් 40g', '4792081029433', 'signal', 'pcs', 125.00, 125.00, 115.00, 49.000000000000000000000000000000, 10, '2025-10-13 15:30:33', '2025-11-18 15:48:30', 'active'),
(81, 'සිග්නල් ටූත් පේස්ට් 120g', '4792081029457', 'signal', 'pcs', 240.00, 240.00, 220.00, 48.000000000000000000000000000000, 10, '2025-10-13 15:31:21', '2025-11-19 15:21:47', 'active'),
(82, 'ක්ලෝගාඩ් ටූත් පේස්ට් 120g', '4791111102030', 'clogard', 'pcs', 240.00, 240.00, 220.00, 50.000000000000000000000000000000, 10, '2025-10-13 15:32:14', '2025-10-13 15:32:14', 'active'),
(83, 'කැකුලු ටූත් පේස්ට් 40g', '4792172002123', 'kekulu', 'pcs', 180.00, 180.00, 170.00, 50.000000000000000000000000000000, 10, '2025-10-13 15:32:58', '2025-10-13 15:32:58', 'active'),
(84, 'අයිඩෙක්ස් බාම් 9g', '4792099011130', 'iodex', 'pcs', 190.00, 190.00, 170.00, 50.000000000000000000000000000000, 10, '2025-10-13 15:33:56', '2025-10-13 15:33:56', 'active'),
(85, 'අයිඩෙක්ස් හෙඩ්ෆාස්ට්', '4792099010898', 'iodex', 'pcs', 200.00, 200.00, 190.00, 50.000000000000000000000000000000, 10, '2025-10-13 15:34:36', '2025-10-13 15:34:36', 'active'),
(86, 'සිඬාලේප', '4792172000037', 'siddha', 'pcs', 200.00, 200.00, 190.00, 50.000000000000000000000000000000, 10, '2025-10-13 15:35:34', '2025-10-13 15:35:34', 'active'),
(87, 'වින්ටර් බාම්', '4796005730535', 'winter', 'pcs', 330.00, 330.00, 310.00, 50.000000000000000000000000000000, 10, '2025-10-13 15:36:28', '2025-10-13 15:36:28', 'active'),
(88, 'වෙනත්', '045504190', 'we', 'pcs', 1.00, 1.00, 1.00, 99999999999999990795.000000000000000000000000000000, 10, '2025-10-13 15:38:12', '2025-11-25 17:30:17', 'active'),
(89, 'වූඩූ පවුඩර්', '4792019032542', 'voodoo', 'pcs', 175.00, 175.00, 165.00, 50.000000000000000000000000000000, 10, '2025-10-13 15:40:47', '2025-10-13 15:40:47', 'active'),
(90, 'බේබි ක්‍රීම්', '4791111100005', 'baby', 'pcs', 185.00, 185.00, 175.00, 50.000000000000000000000000000000, 10, '2025-10-13 15:41:27', '2025-10-13 15:41:27', 'active'),
(91, 'බේබි ක්‍රීම්', '4791111100043', 'baby', 'pcs', 370.00, 370.00, 360.00, 50.000000000000000000000000000000, 10, '2025-10-13 15:41:51', '2025-10-13 15:41:51', 'active'),
(92, 'ගෝයා බොඩි ලෝශන්', '4791111155135', 'goya', 'pcs', 350.00, 350.00, 340.00, 50.000000000000000000000000000000, 10, '2025-10-13 15:42:44', '2025-10-13 15:42:44', 'active'),
(93, 'බේබි ක්‍රීම්', '4796010932498', 'baby', 'pcs', 180.00, 180.00, 170.00, 50.000000000000000000000000000000, 10, '2025-10-13 15:43:16', '2025-10-13 15:43:16', 'active'),
(94, 'කුමාරිකා නරිෂින් හෙයා ඔයිල්', '4791111106205', 'kumarika', 'pcs', 315.00, 315.00, 305.00, 490.000000000000000000000000000000, 10, '2025-10-13 15:45:15', '2025-11-11 08:19:30', 'active'),
(95, 'බේබි ක්‍රීම්', '4791111100104', 'baby', 'pcs', 360.00, 360.00, 350.00, 50.000000000000000000000000000000, 10, '2025-10-13 15:45:50', '2025-10-13 15:45:50', 'active'),
(96, 'ඩැන්ඩේක්ස් ෂැම්පු', '4791111107028', 'dandex', 'pcs', 340.00, 340.00, 330.00, 50.000000000000000000000000000000, 10, '2025-10-13 15:47:05', '2025-10-13 15:47:05', 'active'),
(97, 'කොර්න් බඩ්ස්', '4791111143491', 'cotton', 'pcs', 200.00, 200.00, 190.00, 49.000000000000000000000000000000, 10, '2025-10-13 15:47:38', '2025-11-10 20:15:22', 'active'),
(98, 'බ්ලැක් නයිට් පවුඩර්', '4792019009544', 'black', 'pcs', 180.00, 180.00, 170.00, 50.000000000000000000000000000000, 10, '2025-10-13 15:48:16', '2025-10-13 15:48:16', 'active'),
(99, 'බේබි ෂැම්පු', '4791111100524', 'baby', 'pcs', 290.00, 290.00, 280.00, 49.000000000000000000000000000000, 10, '2025-10-13 15:48:53', '2025-11-21 11:52:05', 'active'),
(100, 'බේබි ඔයිල්', '4791111100432', 'baby', 'pcs', 260.00, 260.00, 250.00, 49.000000000000000000000000000000, 10, '2025-10-13 15:49:37', '2025-11-11 00:16:49', 'active'),
(101, 'ගොටුකොල ෂැම්පු', '4796010930401', 'gotukola', 'pcs', 360.00, 360.00, 350.00, 50.000000000000000000000000000000, 10, '2025-10-13 15:50:13', '2025-10-13 15:50:13', 'active'),
(102, 'පැරිස් සුදුහඳුන් පවුඩර්', '4791111110011', 'paris', 'pcs', 200.00, 200.00, 190.00, 50.000000000000000000000000000000, 10, '2025-10-13 15:51:20', '2025-10-13 15:51:20', 'active'),
(103, 'ඩැන්ඩේක්ස් ෂැම්පු', '4791111144078', 'dandex', 'pcs', 150.00, 150.00, 140.00, 50.000000000000000000000000000000, 10, '2025-10-13 15:52:26', '2025-10-13 15:52:26', 'active'),
(104, 'අල', '004786426', 'ala', 'pcs', 210.00, 200.00, 180.00, 3992.000000000000000000000000000000, 10, '2025-10-13 15:54:00', '2025-11-25 17:30:17', 'active'),
(105, 'බී ළුෑණු', '113943378', 'beeluunu', 'kg', 200.00, 190.00, 135.00, 50.000000000000000000000000000000, 10, '2025-10-13 16:02:04', '2025-11-24 12:15:01', 'active'),
(106, 'රතු ළුණු', '838150515', 'rathu', 'kg', 450.00, 400.00, 310.00, 8.750000000000000000000000000000, 2, '2025-10-14 15:11:27', '2025-11-24 12:15:01', 'active'),
(107, 'සුදු ළුණු', '910168663', 'sudu', 'pcs', 520.00, 500.00, 480.00, 4998.210000000000000000000000000000, 10, '2025-10-14 15:12:10', '2025-11-16 17:56:43', 'active'),
(108, 'පරිප්පු නො.1', '965372777', 'parippu', 'pcs', 400.00, 380.00, 350.00, 45.000000000000000000000000000000, 10, '2025-10-14 15:12:59', '2025-11-25 17:30:17', 'active'),
(109, 'පරිප්පු නො.2', '991179274', 'parippu', 'kg', 280.00, 260.00, 228.00, 151.500000000000000000000000000000, 10, '2025-10-14 15:13:20', '2025-11-24 12:15:01', 'active'),
(110, 'බිත්තර', '015366342', 'biththara', 'pcs', 35.00, 35.00, 30.00, 390.000000000000000000000000000000, 10, '2025-10-14 15:13:45', '2025-11-25 17:30:17', 'active'),
(111, 'හාල්මැස්සන්', '040630134-', 'halmasso', 'pcs', 1300.00, 1200.00, 1100.00, 20.200000000000000000000000000000, 10, '2025-10-14 15:14:16', '2025-11-25 17:30:17', 'active'),
(112, 'කරවල', '076194472', 'karawala', 'pcs', 1.00, 1.00, 1.00, 1310.000000000000000000000000000000, 10, '2025-10-14 15:14:47', '2025-11-25 17:30:17', 'active'),
(113, 'උම්බලකඩ', '141137213', 'umbala', 'pcs', 2900.00, 2800.00, 2600.00, 3000.000000000000000000000000000000, 10, '2025-10-14 15:15:59', '2025-11-11 08:16:15', 'active'),
(114, 'කූනිස්සෝ', '180851342', 'kuunisso', 'kg', 1700.00, 1600.00, 1600.00, 70.000000000000000000000000000000, 1, '2025-10-14 15:16:35', '2025-11-11 08:19:42', 'active'),
(115, 'පිටි', '261148332', 'piti', 'pcs', 190.00, 180.00, 160.00, 93.000000000000000000000000000000, 10, '2025-10-14 15:18:54', '2025-11-19 15:21:47', 'active'),
(116, 'කඩල', '349521076', 'kadala', 'pcs', 520.00, 480.00, 460.00, 15.000000000000000000000000000000, 2, '2025-10-14 15:19:24', '2025-11-25 17:30:17', 'active'),
(117, 'පොල් තෙල්', '385217979', 'polthel', 'ml', 700.00, 650.00, 620.00, 44.500000000000000000000000000000, 10, '2025-10-14 15:20:14', '2025-11-18 15:35:53', 'active'),
(118, 'සෙරෙප්පු', '434451719', 'sereppu', 'pcs', 1.00, 1.00, 1.00, 4300.000000000000000000000000000000, 10, '2025-10-14 15:20:56', '2025-11-18 15:30:23', 'active'),
(119, 'පොත්', '474348573', 'poth', 'pcs', 1.00, 1.00, 1.00, 500.000000000000000000000000000000, 10, '2025-10-14 15:21:19', '2025-10-14 15:21:19', 'active'),
(120, 'තේ කොළ', '491917680', 'thekola', 'kg', 1500.00, 1400.00, 1200.00, 19.800000000000000000000000000000, 10, '2025-10-14 15:22:04', '2025-11-01 15:33:21', 'active'),
(121, 'රතු හාල්', '7638698', 'rathu', 'kg', 200.00, 195.00, 188.00, 49803.000000000000000000000000000000, 10, '2025-10-14 15:23:00', '2025-11-21 11:52:05', 'active'),
(122, 'සුදු හාල්', '596352311', 'suduhal', 'pcs', 230.00, 220.00, 210.00, 98.000000000000000000000000000000, 10, '2025-10-14 15:23:30', '2025-11-10 17:58:52', 'active'),
(123, 'සම්බා', '628995813', 'samba', 'pcs', 360.00, 340.00, 320.00, 496.529411764705900000000000000000, 10, '2025-10-14 15:24:03', '2025-11-10 20:15:22', 'active'),
(124, 'ප්ලාස්ටික් අයිටම්', '703068951', 'plastic', 'pcs', 1.00, 1.00, 1.00, 500.000000000000000000000000000000, 10, '2025-10-14 15:25:20', '2025-10-14 15:25:20', 'active'),
(125, 'හඳුන්කූරු', '765896846', 'hadunkuru', 'pcs', 80.00, 80.00, 70.00, 200.000000000000000000000000000000, 10, '2025-10-14 15:27:15', '2025-10-14 15:27:15', 'active'),
(126, 'හඳුන්කූරු', '841229870', 'hadun', 'pcs', 100.00, 100.00, 90.00, 200.000000000000000000000000000000, 10, '2025-10-14 15:27:30', '2025-10-14 15:27:30', 'active'),
(127, 'හඳුන්කූරු', '857075186', 'hadun', 'pcs', 150.00, 150.00, 130.00, 200.000000000000000000000000000000, 10, '2025-10-14 15:27:43', '2025-10-14 15:27:43', 'active'),
(128, 'සැමන් ලොකු', '887865365', 'saman', 'pcs', 550.00, 500.00, 460.00, 199.000000000000000000000000000000, 10, '2025-10-14 15:28:36', '2025-11-10 20:15:22', 'active'),
(129, 'සැමන් පොඩි', '930153948', 'saman', 'pcs', 260.00, 250.00, 230.00, 200.000000000000000000000000000000, 10, '2025-10-14 15:29:02', '2025-10-14 15:29:02', 'active'),
(130, 'සමපෝෂ 500g', '4792109000482', 'samapo', 'pcs', 420.00, 420.00, 400.00, 19.000000000000000000000000000000, 10, '2025-10-14 15:30:06', '2025-11-10 20:15:22', 'active'),
(131, 'සමපෝෂ 700g', '4792109000864', 'samapo', 'pcs', 580.00, 580.00, 560.00, 18.000000000000000000000000000000, 10, '2025-10-14 15:30:32', '2025-11-25 17:30:17', 'active'),
(132, 'සමපෝෂ 200g', '4792109000024', 'samapo', 'pcs', 185.00, 185.00, 165.00, 20.000000000000000000000000000000, 10, '2025-10-14 15:31:05', '2025-10-14 15:31:05', 'active'),
(133, 'සමපෝෂ චොක්සි', '4792109000772', 'samapo', 'pcs', 250.00, 250.00, 230.00, 20.000000000000000000000000000000, 10, '2025-10-14 15:31:42', '2025-10-14 15:31:42', 'active'),
(134, 'කොත්තු මී', '4792018233131', 'koththu', 'pcs', 130.00, 130.00, 120.00, 200.000000000000000000000000000000, 10, '2025-10-14 15:32:17', '2025-11-11 08:19:58', 'active'),
(135, 'ලුණු කැට', '157117825', 'lunu', 'pcs', 150.00, 150.00, 130.00, 4998.000000000000000000000000000000, 10, '2025-10-14 15:33:06', '2025-11-21 11:14:25', 'active'),
(136, 'ලුණු කුඩු', '200705798', 'lunu', 'pcs', 120.00, 120.00, 100.00, 4999.000000000000000000000000000000, 10, '2025-10-14 15:33:28', '2025-11-21 11:14:25', 'active'),
(137, 'ෆ්‍රීලන් ක්ලැසික් නූඩ්ල්ස් 500g', '4796000302096', 'classic', 'pcs', 270.00, 270.00, 260.00, 50.000000000000000000000000000000, 10, '2025-10-14 15:34:30', '2025-10-14 15:35:10', 'active'),
(138, 'CBL නූඩ්ල්ස්', '4792109000659', 'noodles', 'pcs', 250.00, 250.00, 230.00, 25.000000000000000000000000000000, 10, '2025-10-14 15:35:37', '2025-11-11 08:06:27', 'active'),
(139, 'NKO නූඩ්ල්ස් 450g', '360928958', 'nko', 'pcs', 200.00, 200.00, 180.00, 10000.000000000000000000000000000000, 10, '2025-10-14 15:36:44', '2025-11-11 08:14:26', 'active'),
(140, 'චැලේන්ජ් ඉඳිආප්ප පිටි 1kg', '4796003990054', 'idiappa', 'pcs', 350.00, 350.00, 320.00, 18.000000000000000000000000000000, 10, '2025-10-14 15:37:47', '2025-11-11 08:19:17', 'inactive'),
(141, 'ෆ්‍රීලන් තෝසේ මිශ්‍රනය 400g', '4796000306964', 'those', 'pcs', 435.00, 435.00, 415.00, 20.000000000000000000000000000000, 10, '2025-10-14 15:38:40', '2025-10-14 15:38:40', 'active'),
(142, 'සබන්', '548707115', 'saban', 'pcs', 1.00, 1.00, 1.00, 4564.000000000000000000000000000000, 10, '2025-10-14 15:39:16', '2025-11-11 08:02:47', 'inactive'),
(143, 'කෝපි 20g', '4796000302423', 'kopi', 'pcs', 80.00, 80.00, 70.00, 200.000000000000000000000000000000, 10, '2025-10-18 17:34:52', '2025-11-11 08:20:31', 'active'),
(144, 'කෝපි 50g', '4796000302430', 'kopi', 'pcs', 200.00, 200.00, 180.00, 20.000000000000000000000000000000, 10, '2025-10-18 17:35:47', '2025-10-18 17:35:47', 'active'),
(145, 'නෙස්ටොමෝල්ට් 28g', '4792024021654', 'nestomalt', 'pcs', 60.00, 60.00, 50.00, 15.000000000000000000000000000000, 10, '2025-10-18 17:37:28', '2025-11-10 20:43:52', 'active'),
(146, 'ෆ්‍රීලන් මස්කරි 50g', '4796000301853', 'maskari', 'pcs', 130.00, 130.00, 110.00, 20.000000000000000000000000000000, 10, '2025-10-18 17:38:31', '2025-10-18 17:38:31', 'active'),
(147, 'පැල්වත්ත කිරිපිටි 400g', '4796004080440', 'pelwatte', 'pcs', 1125.00, 1125.00, 1075.00, 17.000000000000000000000000000000, 10, '2025-10-18 17:39:54', '2025-11-25 17:30:17', 'active'),
(148, 'ඩෙන්ටා දත් බුරුසු', '4791010000260', 'denta', 'pcs', 130.00, 130.00, 120.00, 20.000000000000000000000000000000, 10, '2025-10-18 17:40:40', '2025-10-18 17:40:40', 'active'),
(149, 'සිග්නල් දත් බුරුසු', '4792081021116', 'signal', 'pcs', 130.00, 130.00, 120.00, 19.000000000000000000000000000000, 10, '2025-10-18 17:41:09', '2025-11-21 11:52:05', 'active'),
(150, 'ඩෙන්ටා දත් බුරුසු', '4791010000284', 'denta', 'pcs', 110.00, 110.00, 100.00, 20.000000000000000000000000000000, 10, '2025-10-18 17:41:45', '2025-10-18 17:41:45', 'active'),
(151, 'උම්බලකඩ පවුඩර්', '4796005673986', 'umbalakada', 'pcs', 65.00, 65.00, 55.00, 198.000000000000000000000000000000, 10, '2025-10-18 17:42:27', '2025-11-21 11:14:25', 'active'),
(152, 'ඉරිගු පිටි 100g', '4796006731852', 'corn', 'pcs', 150.00, 150.00, 140.00, 20.000000000000000000000000000000, 10, '2025-10-18 17:43:19', '2025-10-18 17:43:19', 'active'),
(153, 'මිශ්‍ර පලතුරු ජෑම්', '4792018521061', 'jam', 'pcs', 475.00, 475.00, 460.00, 20.000000000000000000000000000000, 10, '2025-10-18 17:44:03', '2025-10-18 17:44:03', 'active'),
(154, 'අබ ක්‍රීම්', '4792212006395', 'aba', 'pcs', 380.00, 380.00, 360.00, 20.000000000000000000000000000000, 10, '2025-10-18 17:44:40', '2025-10-18 17:44:40', 'active'),
(155, 'අන්නාසි ජෑම්', '4792098003044', 'annasi', 'pcs', 440.00, 440.00, 430.00, 10.000000000000000000000000000000, 2, '2025-10-18 17:45:20', '2025-10-18 17:47:38', 'active'),
(156, 'මිශ්‍ර පලතුරු ජෑම්', '4792018521085', 'jam', 'pcs', 270.00, 270.00, 260.00, 9.000000000000000000000000000000, 2, '2025-10-18 17:46:13', '2025-11-01 15:33:21', 'active'),
(157, 'ක්ලෝගාඩ් දත් බුරුසු', '4791111102603', 'clogard', 'pcs', 100.00, 100.00, 90.00, 20.000000000000000000000000000000, 2, '2025-10-18 17:46:59', '2025-10-18 17:46:59', 'active'),
(158, 'කිස්ට් තක්කාලි සෝස්', '4792143049065', 'kist', 'pcs', 360.00, 360.00, 350.00, 20.000000000000000000000000000000, 10, '2025-10-18 17:48:18', '2025-10-18 17:48:18', 'active'),
(159, 'කොකෝ පවුඩර් 25g', '4796006731951', 'cocoa', 'pcs', 280.00, 280.00, 270.00, 10.000000000000000000000000000000, 2, '2025-10-18 17:49:07', '2025-10-18 17:49:07', 'active'),
(160, 'බේකින් පවුඩර් 50g', '4796006731944', 'baking', 'pcs', 150.00, 150.00, 140.00, 10.000000000000000000000000000000, 2, '2025-10-18 17:49:48', '2025-10-18 17:49:58', 'active'),
(161, 'ඇපල් කොළ වර්ණය', '4796005730702', 'apple', 'pcs', 175.00, 175.00, 160.00, 10.000000000000000000000000000000, 2, '2025-10-18 17:51:41', '2025-10-18 17:51:41', 'active'),
(162, 'වැනිලා රසකාරකය', '4796005730528', 'vanilla', 'pcs', 220.00, 220.00, 210.00, 10.000000000000000000000000000000, 2, '2025-10-18 17:52:35', '2025-10-18 17:52:35', 'active'),
(163, 'මිල්ක් මේඩ් 390g', '4792024011792', 'milk', 'pcs', 790.00, 790.00, 760.00, 10.000000000000000000000000000000, 2, '2025-10-18 17:53:36', '2025-10-18 17:53:36', 'active'),
(164, 'ෆ්‍රීලන් ගොරකා ක්‍රීම්', '4796000301259', 'goraka', 'pcs', 80.00, 80.00, 70.00, 10.000000000000000000000000000000, 2, '2025-10-18 17:54:27', '2025-10-18 17:54:27', 'active'),
(165, 'සීසනින් පවුඩර්', '4792024000383', 'seasoning', 'pcs', 1250.00, 1250.00, 1200.00, 10.000000000000000000000000000000, 2, '2025-10-18 17:55:07', '2025-10-18 17:55:17', 'active'),
(166, 'ස්ටෙලා තක්කාලි සෝස් 400g', '4792018551112', 'tomato', 'pcs', 540.00, 540.00, 520.00, 10.000000000000000000000000000000, 2, '2025-10-18 17:56:12', '2025-10-18 17:56:12', 'active'),
(167, 'විනාකිරි', '4796000301846', 'vinakiri', 'pcs', 310.00, 310.00, 300.00, 10.000000000000000000000000000000, 2, '2025-10-18 17:56:57', '2025-10-18 17:56:57', 'active'),
(168, 'සෝයා සෝස්', '4792018551235', 'soya', 'pcs', 243.00, 243.00, 230.00, 9.000000000000000000000000000000, 2, '2025-10-18 17:57:26', '2025-11-16 17:56:43', 'active'),
(169, 'මිරිස් සෝස්', '4792143048211', 'miris', 'pcs', 290.00, 290.00, 270.00, 10.000000000000000000000000000000, 2, '2025-10-18 17:57:56', '2025-10-18 17:57:56', 'active'),
(170, 'ස්ටෙලා තක්කාලි සෝස්', '4792018551150', 'tomato', 'pcs', 285.00, 285.00, 270.00, 10.000000000000000000000000000000, 2, '2025-10-18 17:58:31', '2025-10-18 17:58:31', 'active'),
(171, 'ළමා පැනඩෝල්', '4792099010201', '400', 'pcs', 400.00, 400.00, 380.00, 10.000000000000000000000000000000, 2, '2025-10-18 17:59:48', '2025-10-18 17:59:48', 'active'),
(172, '‍රත්ති කිරිපිටි 400g', '4791085081072', 'raththi', 'pcs', 1200.00, 1200.00, 1150.00, 20.000000000000000000000000000000, 5, '2025-10-18 18:01:28', '2025-11-06 12:46:08', 'active'),
(173, 'බික් තල 1', '3086125705614', 'bic', 'pcs', 120.00, 120.00, 110.00, 20.000000000000000000000000000000, 5, '2025-10-18 18:02:38', '2025-10-18 18:02:38', 'active'),
(174, 'බික් තල 2', '3086127501122', 'bic', 'pcs', 140.00, 140.00, 130.00, 9.000000000000000000000000000000, 2, '2025-10-18 18:03:03', '2025-11-08 18:56:49', 'active'),
(175, 'මයිලෝ', '4792024011754', 'milo', 'pcs', 130.00, 130.00, 120.00, 8.000000000000000000000000000000, 2, '2025-10-18 18:04:52', '2025-11-06 12:27:27', 'active'),
(176, 'ලොකු සුප් කැට', '4796005673245', 'lojku sup', 'pcs', 60.00, 60.00, 55.00, 96.000000000000000000000000000000, 10, '2025-10-18 18:05:51', '2025-10-31 17:09:24', 'active'),
(177, 'පැනඩෝල්', '4792099010010', 'panadol', 'pcs', 60.00, 60.00, 55.00, 998.000000000000000000000000000000, 10, '2025-10-18 18:06:30', '2025-11-24 12:15:01', 'active'),
(178, 'පොඩි සුප් කැට', '4792024016803', 'podi sup', 'pcs', 30.00, 30.00, 25.00, 40.000000000000000000000000000000, 10, '2025-10-18 18:07:09', '2025-10-18 18:07:09', 'active'),
(179, 'පොඩි සුප් කැට', '4792024016827', 'podi sup', 'pcs', 30.00, 30.00, 25.00, 40.000000000000000000000000000000, 10, '2025-10-18 18:07:28', '2025-10-18 18:07:28', 'active'),
(180, 'ලයිෆ්බෝයි හෑන්ඩ් වොශ්', '4792081018024', 'hand', 'pcs', 330.00, 330.00, 20.00, 10.000000000000000000000000000000, 2, '2025-10-18 18:08:14', '2025-10-18 18:08:14', 'active'),
(181, 'ලයිෆ්බෝයි හෑන්ඩ් වොශ්', '4796005672835', 'hand', 'pcs', 550.00, 550.00, 520.00, 20.000000000000000000000000000000, 2, '2025-10-18 18:08:43', '2025-10-18 18:08:43', 'active'),
(182, 'ක්ම්ෆර්ට්', '8909106022010', 'comfort', 'pcs', 300.00, 300.00, 280.00, 200.000000000000000000000000000000, 10, '2025-10-18 18:09:25', '2025-11-11 08:20:41', 'active'),
(183, 'ලයිසෝල්', '4792037109844', 'lysol', 'pcs', 250.00, 250.00, 240.00, 20.000000000000000000000000000000, 10, '2025-10-18 18:10:02', '2025-10-18 18:10:02', 'active'),
(184, 'ඩෙටෝල් ලොකු', '4792037579784', 'detol', 'pcs', 595.00, 595.00, 580.00, 20.000000000000000000000000000000, 10, '2025-10-18 18:10:40', '2025-10-18 18:10:40', 'active'),
(185, 'ඩෙටෝල් පොඩි', '4792037579791', 'detol', 'pcs', 340.00, 340.00, 330.00, 20.000000000000000000000000000000, 10, '2025-10-18 18:11:12', '2025-10-18 18:11:12', 'active'),
(186, 'වෙනත්', '400735117', 'we2', 'pcs', 1.00, 1.00, 1.00, 499999993720.000000000000000000000000000000, 10, '2025-10-18 18:13:37', '2025-11-24 12:15:01', 'active'),
(187, 'වෙනත්', '419964757', 'we3', 'pcs', 1.00, 1.00, 1.00, 4999999999695.000000000000000000000000000000, 10, '2025-10-18 18:13:45', '2025-11-24 12:15:01', 'active'),
(188, 'තල', '473159882', 'thala', 'pcs', 200.00, 200.00, 180.00, 48.000000000000000000000000000000, 10, '2025-10-18 18:14:41', '2025-11-21 11:52:05', 'active'),
(189, 'වෙනත්', '557670523', 'we4', 'pcs', 1.00, 1.00, 1.00, 10000.000000000000000000000000000000, 10, '2025-10-18 18:16:06', '2025-11-11 08:00:50', 'active'),
(190, 'වෙනත්', '575416877', 'we5', 'pcs', 1.00, 1.00, 1.00, 100000000000000000000000000.000000000000000000000000000000, 10, '2025-10-18 18:16:19', '2025-11-13 13:07:42', 'active'),
(191, 'රටඉඳි කේක් ', '4792232010105', 'cake', 'pcs', 690.00, 690.00, 680.00, 10.000000000000000000000000000000, 2, '2025-10-18 18:18:56', '2025-10-18 18:19:13', 'active'),
(192, 'ස්පොන්ජ් ලේකර් කේක්', '4792192010238', 'sponge', 'pcs', 850.00, 850.00, 830.00, 20.000000000000000000000000000000, 10, '2025-10-18 18:20:01', '2025-10-18 18:20:01', 'active'),
(193, 'ස්ටික්ස්', '4792192839228', 'stix', 'pcs', 120.00, 120.00, 110.00, 20.000000000000000000000000000000, 10, '2025-10-18 18:21:30', '2025-10-18 18:21:30', 'active'),
(194, 'ග්ලූකෝස්', '4796005730931', 'glucose', 'pcs', 160.00, 160.00, 150.00, 20.000000000000000000000000000000, 10, '2025-10-18 18:22:03', '2025-10-18 18:22:03', 'active'),
(195, 'චොක්ලට්', '4792192423007', 'choc', 'pcs', 250.00, 250.00, 240.00, 20.000000000000000000000000000000, 10, '2025-10-18 18:23:00', '2025-10-18 18:23:00', 'active'),
(196, 'චොක්ලට්', '4792192845946', 'choc', 'pcs', 480.00, 480.00, 460.00, 20.000000000000000000000000000000, 10, '2025-10-18 18:23:26', '2025-10-18 18:23:26', 'active'),
(197, 'චොක්ලට්', '4792192845021', 'choc', 'pcs', 270.00, 270.00, 260.00, 20.000000000000000000000000000000, 10, '2025-10-18 18:23:51', '2025-10-18 18:23:51', 'active'),
(198, 'චොක්ලට්', '4792192845076', 'choc', 'pcs', 130.00, 130.00, 120.00, 20.000000000000000000000000000000, 10, '2025-10-18 18:24:17', '2025-10-18 18:24:17', 'active'),
(199, 'චොක්ලට් ෆින්ගර්ස්', '4792192474207', 'fingers', 'pcs', 250.00, 250.00, 240.00, 20.000000000000000000000000000000, 10, '2025-10-18 18:24:51', '2025-10-18 18:24:51', 'active'),
(200, 'පෙබ්ල්ස්', '4792192845724', 'pebbles', 'pcs', 380.00, 380.00, 360.00, 20.000000000000000000000000000000, 10, '2025-10-18 18:25:33', '2025-10-18 18:25:33', 'active'),
(201, 'මැකරෝනි', '4793001803089', 'macaroni', 'pcs', 150.00, 150.00, 130.00, 20.000000000000000000000000000000, 10, '2025-10-18 18:26:53', '2025-10-18 18:26:53', 'active'),
(202, 'සීනි බිස්කට්', '4793001803195', 'sini', 'pcs', 250.00, 250.00, 230.00, 20.000000000000000000000000000000, 10, '2025-10-18 18:27:36', '2025-10-18 18:27:36', 'active'),
(203, 'කුමාරිකා තෙල්', '4791111150239', 'kumarika', 'pcs', 315.00, 315.00, 300.00, 200.000000000000000000000000000000, 10, '2025-10-18 18:28:35', '2025-11-11 08:19:18', 'active'),
(204, 'ලයිෆ්බෝයි ෂැම්පු', '4792081011513', 'shampoo', 'pcs', 300.00, 300.00, 280.00, 20.000000000000000000000000000000, 10, '2025-10-18 18:29:27', '2025-10-18 18:29:47', 'active'),
(205, 'ෆේස් වොශ්', '4796010930210', 'face', 'pcs', 365.00, 365.00, 350.00, 20.000000000000000000000000000000, 10, '2025-10-18 18:30:31', '2025-10-18 18:30:31', 'active'),
(206, 'චන්දනාලේප හර්බල් ක්‍රීම්', '4796010930043', 'chandana', 'pcs', 250.00, 250.00, 240.00, 20.000000000000000000000000000000, 10, '2025-10-18 18:31:20', '2025-10-18 18:31:20', 'active'),
(207, 'වැස්ලින්', '4792081031832', 'vaseline', 'pcs', 300.00, 300.00, 280.00, 20.000000000000000000000000000000, 10, '2025-10-18 18:31:56', '2025-10-18 18:31:56', 'active'),
(208, 'ලංකා සො‍යි සෝයා', '4796002070177', 'lanka', 'pcs', 145.00, 145.00, 130.00, 20.000000000000000000000000000000, 10, '2025-10-18 18:34:22', '2025-10-18 18:34:22', 'active'),
(209, 'ලංකා සො‍යි සෝයා', '4796002070153', 'lanka', 'pcs', 130.00, 130.00, 120.00, 19.000000000000000000000000000000, 10, '2025-10-18 18:34:43', '2025-10-31 18:48:41', 'active'),
(210, 'ලංකා සො‍යි සෝයා', '4796002070221', 'lanka', 'pcs', 145.00, 145.00, 130.00, 20.000000000000000000000000000000, 10, '2025-10-18 18:35:03', '2025-10-18 18:35:03', 'active'),
(211, 'ලංකා සො‍යි සෝයා', '4796002004004', 'lanka', 'pcs', 135.00, 135.00, 120.00, 20.000000000000000000000000000000, 10, '2025-10-18 18:35:24', '2025-10-18 18:35:24', 'active'),
(212, 'ලංකා සො‍යි සෝයා', '4796002019008', 'lanka', 'pcs', 120.00, 120.00, 110.00, 20.000000000000000000000000000000, 10, '2025-10-18 18:35:42', '2025-10-18 18:35:42', 'active'),
(213, 'ලංකා සො‍යි සෝයා', '4796002001003', 'lanka', 'pcs', 60.00, 60.00, 55.00, 20.000000000000000000000000000000, 10, '2025-10-18 18:36:05', '2025-10-18 18:36:05', 'active'),
(214, 'ලංකා සො‍යි සෝයා', '4796002070238', 'lanka', 'pcs', 140.00, 140.00, 130.00, 20.000000000000000000000000000000, 10, '2025-10-18 18:36:21', '2025-10-18 18:36:21', 'active'),
(215, 'ලංකා සො‍යි සෝයා', '4796002070160', 'lanka', 'pcs', 140.00, 140.00, 130.00, 20.000000000000000000000000000000, 10, '2025-10-18 18:36:37', '2025-10-18 18:36:37', 'active'),
(216, 'සෝස් පැකට්', '4792018551075', 'sause', 'pcs', 20.00, 20.00, 15.00, 150.000000000000000000000000000000, 10, '2025-10-18 18:38:04', '2025-10-18 18:38:14', 'active'),
(217, 'අයිස්', '924704617', 'ice', 'pcs', 1.00, 1.00, 1.00, 500.000000000000000000000000000000, 10, '2025-10-18 18:38:51', '2025-10-18 18:38:51', 'active'),
(218, 'අමු කජු', '978204198', 'amu', 'pcs', 1400.00, 1400.00, 1100.00, 8000.000000000000000000000000000000, 10, '2025-10-18 18:40:13', '2025-11-11 08:14:41', 'active'),
(219, 'ස්ටික්ස්', '4792192838221', 'stick', 'pcs', 120.00, 120.00, 110.00, 50.000000000000000000000000000000, 10, '2025-10-20 13:07:31', '2025-10-20 13:07:31', 'active'),
(220, 'ස්ටික්ස්', '4792192840224', 'stick', 'pcs', 120.00, 120.00, 110.00, 50.000000000000000000000000000000, 10, '2025-10-20 13:08:13', '2025-10-20 13:08:13', 'active'),
(221, 'ස්ටික්ස්', '4792192839006', 'stick', 'pcs', 40.00, 40.00, 35.00, 50.000000000000000000000000000000, 10, '2025-10-20 13:10:30', '2025-10-20 13:10:30', 'active'),
(222, 'කුකුල් මස්', '997661572', 'kukul', 'pcs', 1250.00, 1100.00, 1000.00, 9596.627272727272700000000000000000, 10, '2025-10-20 14:17:56', '2025-11-23 09:20:56', 'active'),
(223, 'කෑලි මිරිස්', '105072681', 'miris', 'pcs', 120.00, 120.00, 100.00, 4899.000000000000000000000000000000, 10, '2025-10-20 14:18:38', '2025-11-21 11:14:25', 'active'),
(224, 'මිරිස් කුඩු', '110', 'miris', 'pcs', 120.00, 120.00, 100.00, 500.000000000000000000000000000000, 10, '2025-10-20 14:19:08', '2025-11-11 08:10:51', 'active'),
(225, 'අමු තුනපහ', '168138125', 'amuthuna', 'pcs', 140.00, 140.00, 120.00, 960.000000000000000000000000000000, 10, '2025-10-20 14:19:36', '2025-11-11 08:14:53', 'active'),
(226, 'බැදපු තුනපහ', '196075905', 'badapu', 'pcs', 160.00, 160.00, 150.00, 98.000000000000000000000000000000, 10, '2025-10-20 14:20:02', '2025-11-01 15:33:21', 'active'),
(227, 'කහ', '215252335', 'kaha', 'pcs', 400.00, 400.00, 350.00, 49.000000000000000000000000000000, 10, '2025-10-20 14:21:58', '2025-11-20 17:08:11', 'active'),
(228, 'කහ', '323719216', 'kaha', 'pcs', 200.00, 200.00, 170.00, 488.000000000000000000000000000000, 10, '2025-10-20 14:22:09', '2025-11-24 12:15:01', 'active'),
(229, 'මස්කරි', '340415144', 'mas', 'pcs', 130.00, 130.00, 120.00, 98.000000000000000000000000000000, 10, '2025-10-20 14:22:38', '2025-11-01 03:26:39', 'active'),
(230, 'මස්කරි', '366888788', 'mas', 'pcs', 50.00, 50.00, 40.00, 100.000000000000000000000000000000, 10, '2025-10-20 14:22:52', '2025-10-20 14:22:52', 'active'),
(231, 'දුරු ඇට', '394330563', 'duruata', 'pcs', 150.00, 150.00, 140.00, 50.000000000000000000000000000000, 10, '2025-10-20 14:23:25', '2025-10-20 14:23:25', 'active'),
(232, 'මා දුරු', '434427951', 'maduru', 'pcs', 100.00, 100.00, 90.00, 100.000000000000000000000000000000, 10, '2025-10-20 14:24:05', '2025-10-20 14:24:05', 'active'),
(233, 'කොත්තමල්ලි', '469035308', 'koththamalli', 'pcs', 50.00, 50.00, 40.00, 100.000000000000000000000000000000, 10, '2025-10-20 14:24:36', '2025-10-20 14:24:36', 'active'),
(234, 'කිරි පැකට්', '4792090120008', 'kiripakat', 'pcs', 100.00, 100.00, 90.00, 50.000000000000000000000000000000, 10, '2025-10-20 14:39:38', '2025-10-20 14:39:38', 'active'),
(235, 'කිරි පැකට්', '4792090120015', 'kiripakat', 'pcs', 100.00, 100.00, 90.00, 50.000000000000000000000000000000, 10, '2025-10-20 14:40:24', '2025-10-20 14:40:24', 'active'),
(236, 'පෙබ්ල්ස්', '8888101360238', 'pebbles', 'pcs', 80.00, 80.00, 70.00, 50.000000000000000000000000000000, 10, '2025-10-20 14:41:06', '2025-10-20 14:41:06', 'active'),
(237, 'බීම', '485283848', 'biima', 'pcs', 300.00, 300.00, 280.00, 50.000000000000000000000000000000, 10, '2025-10-20 14:41:32', '2025-10-20 14:41:32', 'active'),
(238, 'බීම', '520708520', 'biima', 'pcs', 150.00, 150.00, 140.00, 50.000000000000000000000000000000, 10, '2025-10-20 14:42:13', '2025-10-20 14:42:13', 'active'),
(239, 'බීම', '547901824', 'biima', 'pcs', 100.00, 100.00, 90.00, 50.000000000000000000000000000000, 10, '2025-10-20 14:42:35', '2025-10-20 14:42:35', 'active'),
(240, 'චීස්', '4792090000577', 'cheese', 'pcs', 560.00, 560.00, 530.00, 13.000000000000000000000000000000, 10, '2025-10-20 14:43:25', '2025-11-13 13:23:34', 'active'),
(241, 'චීස්', '612782086', 'cheese', 'pcs', 80.00, 80.00, 70.00, 50.000000000000000000000000000000, 10, '2025-10-20 14:44:39', '2025-10-20 14:44:39', 'active'),
(242, 'ඇස්ට්‍රා 250g', '4796025380031', 'astra', 'pcs', 525.00, 525.00, 520.00, 50.000000000000000000000000000000, 10, '2025-10-20 14:45:31', '2025-10-20 14:45:31', 'active'),
(243, 'ඇස්ට්‍රා 40g', '4796025380017', 'astra', 'pcs', 85.00, 85.00, 80.00, 49.000000000000000000000000000000, 10, '2025-10-20 14:46:00', '2025-11-16 18:04:46', 'active'),
(244, 'සොසේජස්', '787413585', 'sose', 'pcs', 575.00, 550.00, 530.00, 50.000000000000000000000000000000, 10, '2025-10-20 14:46:47', '2025-10-20 14:46:47', 'active'),
(245, 'සොසේජස්', '814005990', 'sose', 'pcs', 160.00, 150.00, 140.00, 50.000000000000000000000000000000, 10, '2025-10-20 14:47:00', '2025-10-20 14:47:00', 'active'),
(246, 'සබන් කුඩු', '974068643', 'saban kudu', 'pcs', 320.00, 320.00, 300.00, 499.000000000000000000000000000000, 10, '2025-10-20 14:49:44', '2025-11-24 12:15:01', 'active'),
(247, 'සබන් කුඩු', '992442600', 'saban kudu', 'pcs', 170.00, 170.00, 160.00, 50.000000000000000000000000000000, 10, '2025-10-20 14:50:07', '2025-10-20 14:50:07', 'active'),
(248, 'සබන් කුඩු', '017940474', 'saban kudu', 'pcs', 180.00, 180.00, 170.00, 500.000000000000000000000000000000, 10, '2025-10-20 14:50:24', '2025-11-11 08:13:58', 'active'),
(249, 'සබන් කුඩු', '032715300', 'saban kudu', 'pcs', 190.00, 190.00, 180.00, 49.000000000000000000000000000000, 10, '2025-10-20 14:50:38', '2025-11-23 09:20:56', 'active'),
(250, 'සබන් කුඩු', '046988048', 'saban kudu', 'pcs', 90.00, 90.00, 85.00, 50.000000000000000000000000000000, 10, '2025-10-20 14:50:51', '2025-10-20 14:50:51', 'active'),
(251, 'සබන් කුඩු', '061173996', 'saban kudu', 'pcs', 25.00, 25.00, 20.00, 50.000000000000000000000000000000, 10, '2025-10-20 14:51:08', '2025-10-20 14:51:08', 'active'),
(252, 'පපඩම්', '135165947', 'papadam', 'pcs', 100.00, 100.00, 90.00, 44.500000000000000000000000000000, 10, '2025-10-20 14:52:35', '2025-11-20 14:12:29', 'active'),
(253, 'ලන්ච් ශීට්', '293052293', 'lanch', 'pcs', 80.00, 80.00, 70.00, 50.000000000000000000000000000000, 10, '2025-10-20 14:55:05', '2025-10-20 14:55:05', 'active'),
(254, 'සර්වියට්', '327812388', 'sarviyat', 'pcs', 250.00, 200.00, 180.00, 49.000000000000000000000000000000, 10, '2025-10-20 14:55:34', '2025-11-06 22:01:09', 'active'),
(255, 'අයිස් ක්‍රීම් 4L', '1800', 'ice', 'pcs', 1870.00, 1800.00, 1600.00, 43.000000000000000000000000000000, 10, '2025-10-20 14:56:39', '2025-11-13 13:23:34', 'active'),
(256, 'චොක්ලට්', '502164004', 'choc', 'pcs', 10.00, 10.00, 8.00, 100.000000000000000000000000000000, 10, '2025-10-20 14:58:34', '2025-10-20 14:58:34', 'active'),
(259, 'වැනිලා අයිස් 1L', '4792085000155', 'ice', 'pcs', 520.00, 520.00, 500.00, 39.000000000000000000000000000000, 10, '2025-10-20 14:59:35', '2025-10-31 16:05:37', 'active'),
(260, 'චොක්ලට් අයිස් 1L', '4792085000179', 'ice', 'pcs', 570.00, 570.00, 500.00, 50.000000000000000000000000000000, 10, '2025-10-20 15:00:05', '2025-10-20 15:16:49', 'active'),
(261, 'ෆ්රුට් ඇන්ඩ් නට් අයිස්', '4792085000216', 'ice', 'pcs', 820.00, 820.00, 800.00, 50.000000000000000000000000000000, 10, '2025-10-20 15:03:22', '2025-10-20 15:17:23', 'active'),
(262, 'ෆ්රුට් ඇන්ඩ් නට් අයිස් 2L', '4792085000339', 'ice', 'pcs', 1620.00, 1620.00, 1500.00, 50.000000000000000000000000000000, 10, '2025-10-20 15:04:05', '2025-10-20 15:18:37', 'active'),
(263, 'ෆ්රුට් ඇන්ඩ් නට් අයිස් 500ml', '4792085000759', 'ice', 'pcs', 460.00, 460.00, 400.00, 50.000000000000000000000000000000, 10, '2025-10-20 15:04:23', '2025-10-20 15:15:51', 'active'),
(264, 'ඩබල් අයිස් 2L', '4792090120107', 'ice', 'pcs', 1210.00, 1210.00, 1100.00, 50.000000000000000000000000000000, 10, '2025-10-20 15:05:01', '2025-10-20 15:19:18', 'active'),
(265, 'ඩබල් අයිස් 1L', '4792085000292', 'ice', 'pcs', 620.00, 620.00, 580.00, 50.000000000000000000000000000000, 10, '2025-10-20 15:05:49', '2025-10-20 15:20:38', 'active'),
(266, 'වැනිලා අයිස් 2L', '1030', 'ice', 'pcs', 1030.00, 1030.00, 980.00, 50.000000000000000000000000000000, 10, '2025-10-20 15:06:28', '2025-10-20 15:06:28', 'active'),
(267, 'චොක්ලට් අයිස් 500ml', '4792085000650', 'ice', 'pcs', 350.00, 350.00, 300.00, 50.000000000000000000000000000000, 10, '2025-10-20 15:07:45', '2025-10-20 15:15:15', 'active'),
(268, 'වොන්ඩර් කෝන්', '4792085000735', '160', 'pcs', 160.00, 160.00, 140.00, 50.000000000000000000000000000000, 10, '2025-10-20 15:09:42', '2025-10-20 15:24:11', 'active'),
(269, 'වොන්ඩර් කෝන්', '4792085000018', '150', 'pcs', 150.00, 150.00, 130.00, 50.000000000000000000000000000000, 10, '2025-10-20 15:10:16', '2025-10-20 15:24:29', 'active'),
(270, 'අයිස් චොක්', '4792085001589', '100', 'pcs', 100.00, 100.00, 90.00, 500.000000000000000000000000000000, 10, '2025-10-20 15:11:09', '2025-11-11 08:15:29', 'active'),
(271, 'පොප්සිකල් අයිස්', '4792085000384', 'pop', 'pcs', 50.00, 50.00, 40.00, 50.000000000000000000000000000000, 10, '2025-10-20 15:11:41', '2025-10-31 16:43:50', 'active'),
(272, 'පොප්සිකල් අයිස්', '4792085018051', 'pop', 'pcs', 40.00, 40.00, 30.00, 50.000000000000000000000000000000, 10, '2025-10-20 15:12:25', '2025-10-31 17:15:32', 'active'),
(273, 'අයිස් චොක්', '4792085000063', '100', 'pcs', 100.00, 100.00, 90.00, 500.000000000000000000000000000000, 10, '2025-10-20 15:23:38', '2025-11-11 08:15:15', 'active'),
(274, 'පොප්සිකල් අයිස්', '4792085002593', '50', 'pcs', 50.00, 50.00, 40.00, 50.000000000000000000000000000000, 10, '2025-10-20 15:25:39', '2025-10-20 15:25:39', 'active'),
(275, 'යෝගට්', '70', 'yogat', 'pcs', 70.00, 70.00, 60.00, 491.000000000000000000000000000000, 10, '2025-10-20 15:30:48', '2025-10-31 16:25:13', 'active'),
(276, 'ගිනි පෙට්ටි', '933819278', 'gini', 'pcs', 20.00, 20.00, 18.00, 4992.000000000000000000000000000000, 10, '2025-10-27 18:12:21', '2025-11-18 15:30:23', 'active'),
(277, 'මැගී නූඩ්ල්ස්', '4792024020190', 'magii', 'pcs', 115.00, 115.00, 100.00, 96.000000000000000000000000000000, 10, '2025-10-27 18:13:35', '2025-10-27 18:16:33', 'active'),
(278, 'ලාඕජී', '5063305007506', 'laao', 'pcs', 150.00, 150.00, 140.00, 99.000000000000000000000000000000, 10, '2025-10-27 18:15:12', '2025-10-27 18:16:33', 'active'),
(279, 'ජම්බො පීනට්', '6921049900585', 'jumbo', 'pcs', 150.00, 150.00, 140.00, 100.000000000000000000000000000000, 10, '2025-10-27 18:21:03', '2025-10-27 18:21:03', 'active'),
(280, 'ඩයපර් පෑන්ට්ස්', '4791111143156', 'diaper', 'pcs', 550.00, 550.00, 530.00, 100.000000000000000000000000000000, 10, '2025-10-27 18:22:41', '2025-10-27 18:22:41', 'active'),
(281, 'ඩයපර් පෑන්ට්ස්', '4791111143149', 'diaper', 'pcs', 510.00, 510.00, 490.00, 100.000000000000000000000000000000, 10, '2025-10-27 18:23:09', '2025-10-27 18:23:09', 'active'),
(282, 'කර්ත කොලොම්බන්', '4791066001723', 'kartha', 'pcs', 790.00, 790.00, 750.00, 20.000000000000000000000000000000, 10, '2025-10-27 18:24:38', '2025-10-27 18:24:38', 'active'),
(283, 'ටිපි ටිප්', '4792135020386', 'tipi', 'pcs', 80.00, 80.00, 70.00, 50.000000000000000000000000000000, 10, '2025-10-27 18:28:42', '2025-10-27 18:28:42', 'active'),
(284, 'ටිපි ටිප්', '4792135020485', 'tipi', 'pcs', 80.00, 80.00, 70.00, 50.000000000000000000000000000000, 10, '2025-10-27 18:29:25', '2025-10-27 18:29:25', 'active'),
(285, 'ප්‍රීමා නූඩ්ල්ස් ෆැමිලි පැක්', '4792018233681', 'prima', 'pcs', 370.00, 370.00, 350.00, 46.000000000000000000000000000000, 10, '2025-10-27 18:30:33', '2025-11-24 12:15:01', 'active'),
(286, 'මැගී ෆැමිලි පැක්', '4792024019262', 'maggi', 'pcs', 350.00, 350.00, 310.00, 49.000000000000000000000000000000, 10, '2025-10-27 18:31:15', '2025-11-20 14:12:29', 'active'),
(287, 'ක්‍රීම් සෝඩා 1.5L', '4793001379317', 'cream', 'pcs', 300.00, 300.00, 280.00, 100.000000000000000000000000000000, 10, '2025-10-27 18:32:05', '2025-10-27 18:32:05', 'active'),
(288, 'ඔරේන්ජ් බීම 1.5L', '4793001379287', 'orange', 'pcs', 300.00, 300.00, 280.00, 50.000000000000000000000000000000, 10, '2025-10-27 18:32:44', '2025-10-27 18:32:44', 'active'),
(289, 'ඔරේන්ජ් බීම', '4793001379201', 'orange', 'pcs', 100.00, 100.00, 80.00, 100.000000000000000000000000000000, 10, '2025-10-27 18:33:18', '2025-10-27 18:33:18', 'active'),
(290, 'ක්‍රීම් සෝඩා', '4793001379140', 'cream', 'pcs', 100.00, 100.00, 80.00, 100.000000000000000000000000000000, 10, '2025-10-27 18:33:44', '2025-10-27 18:33:44', 'active'),
(291, 'ඔරේන්ජ් බීම', '4793001379218', 'orange', 'pcs', 150.00, 150.00, 130.00, 1000.000000000000000000000000000000, 10, '2025-10-27 18:35:14', '2025-11-11 08:16:59', 'active'),
(292, 'ක්‍රීම් සෝඩා', '4793001379263', 'cream', 'pcs', 150.00, 150.00, 130.00, 100.000000000000000000000000000000, 10, '2025-10-27 18:35:38', '2025-10-27 18:35:38', 'active'),
(293, 'හාපික්', '4792037107703', 'harpic', 'pcs', 265.00, 265.00, 250.00, 100.000000000000000000000000000000, 10, '2025-10-27 18:37:53', '2025-10-27 18:37:53', 'active'),
(295, 'ලයිෆ්බෝයි හෑන්ඩ් වොශ්', '4792081018055', 'hand', 'pcs', 330.00, 330.00, 310.00, 100.000000000000000000000000000000, 10, '2025-10-27 18:38:58', '2025-10-27 18:38:58', 'active');
INSERT INTO `sales` (`id`, `item_name_sinhala`, `barcode`, `item_name_english`, `unit_of_measurement`, `regular_price`, `our_price`, `price_per_item`, `stock_quantity`, `stock_alert_quantity`, `created_date`, `updated_date`, `status`) VALUES
(296, 'ලයිසෝල්', '4792037109837', 'lysol', 'pcs', 250.00, 250.00, 220.00, 100.000000000000000000000000000000, 10, '2025-10-27 18:39:52', '2025-10-27 18:39:52', 'active'),
(300, 'පොත්', '695138545', 'poth', 'pcs', 1.00, 1.00, 1.00, 50000.000000000000000000000000000000, 10, '2025-10-27 18:41:43', '2025-10-27 18:41:43', 'active'),
(301, 'පැන්සල්', '723703557', 'pansal', 'pcs', 40.00, 40.00, 30.00, 100.000000000000000000000000000000, 10, '2025-10-27 18:42:10', '2025-10-27 18:42:10', 'active'),
(302, 'පෑන්', '747340845', 'pan', 'pcs', 25.00, 25.00, 20.00, 100.000000000000000000000000000000, 10, '2025-10-27 18:42:32', '2025-10-27 18:42:32', 'active'),
(303, 'සපත්තු පොලිශ්', '778882942', 'polis', 'pcs', 200.00, 200.00, 180.00, 50.000000000000000000000000000000, 10, '2025-10-27 18:43:51', '2025-10-27 18:43:51', 'active'),
(304, 'ගම් බෝතල්', '857333177', 'gam', 'pcs', 100.00, 100.00, 80.00, 99.000000000000000000000000000000, 10, '2025-10-27 18:44:32', '2025-11-18 16:53:41', 'active'),
(305, 'අඩි රූල්', '943480733', 'adi', 'pcs', 50.00, 50.00, 40.00, 100.000000000000000000000000000000, 10, '2025-10-27 18:45:50', '2025-10-27 18:45:50', 'active'),
(306, 'දුම්කොළ', '965336065', 'dumkola', 'pcs', 1.00, 1.00, 1.00, 49220.000000000000000000000000000000, 10, '2025-10-27 18:46:24', '2025-11-19 17:33:42', 'active'),
(307, 'හුනු', '061259181', 'hunu', 'pcs', 20.00, 20.00, 15.00, 98.000000000000000000000000000000, 10, '2025-10-27 18:47:59', '2025-11-11 01:53:22', 'active'),
(308, 'මිරිස් කරල්', '915834944', 'miriskaral', 'pcs', 1200.00, 1000.00, 800.00, 18.750000000000000000000000000000, 10, '2025-10-31 15:49:00', '2025-11-24 12:15:01', 'active'),
(309, 'ටොෆි', '394441771', 'toffi', 'pcs', 1.00, 1.00, 1.00, 4985.000000000000000000000000000000, 10, '2025-10-31 15:56:45', '2025-11-06 12:27:27', 'active'),
(310, 'කවර', '364686533', 'kawara', 'pcs', 5.00, 5.00, 5.00, 10000.000000000000000000000000000000, 10, '2025-10-31 16:29:46', '2025-10-31 16:29:46', 'active'),
(311, 'කවර', '396256669', 'kawara', 'pcs', 10.00, 10.00, 10.00, 10000.000000000000000000000000000000, 10, '2025-10-31 16:30:05', '2025-10-31 16:30:05', 'active'),
(312, 'කවර', '419236055', 'kawara', 'pcs', 20.00, 20.00, 20.00, 9998.000000000000000000000000000000, 10, '2025-10-31 16:30:33', '2025-11-08 18:33:18', 'active'),
(313, 'කවර', '440304389', 'kawara', 'pcs', 30.00, 30.00, 30.00, 10000.000000000000000000000000000000, 10, '2025-10-31 16:30:46', '2025-10-31 16:30:46', 'active'),
(314, 'කජු', '234090712', 'kaju', 'pcs', 1500.00, 1400.00, 100.00, 969.800000000000000000000000000000, 10, '2025-10-31 17:05:32', '2025-11-20 14:12:29', 'active'),
(315, 'කොහොඹ', '4792068111137', 'kohoba', 'pcs', 125.00, 125.00, 115.00, 200.000000000000000000000000000000, 10, '2025-10-31 17:12:31', '2025-11-11 08:20:14', 'active'),
(316, 'ලයිෆ්බෝයි සබන්', '4792081041145', 'life', 'pcs', 260.00, 260.00, 240.00, 48.000000000000000000000000000000, 10, '2025-10-31 17:14:13', '2025-11-01 15:33:21', 'active'),
(317, 'වටානා', '965182781', 'watana', 'pcs', 210.00, 200.00, 190.00, 48.000000000000000000000000000000, 10, '2025-11-01 15:26:21', '2025-11-11 08:01:23', 'inactive'),
(318, 'රට ඉදි', '296086536', 'rata', 'pcs', 900.00, 900.00, 800.00, 42.555555555555560000000000000000, 10, '2025-11-01 15:31:50', '2025-11-08 18:45:00', 'active'),
(319, 'ෂොපින් බෑග්', '347384926', 'shopin', 'pcs', 1.00, 1.00, 1.00, 4890.000000000000000000000000000000, 10, '2025-11-01 15:32:34', '2025-11-23 09:20:56', 'active'),
(320, 'බයිට්', '112327771', 'bait', 'pcs', 100.00, 80.00, 56.00, 10.000000000000000000000000000000, 1, '2025-11-06 12:09:05', '2025-11-06 12:09:05', 'active'),
(321, 'වියලි මිදි', '177545007', 'wiyali', 'pcs', 200.00, 180.00, 145.00, 50.000000000000000000000000000000, 10, '2025-11-06 12:10:10', '2025-11-06 12:10:10', 'active'),
(322, 'බටර් විස්කෝතු', '238472525', 'batar', 'pcs', 200.00, 200.00, 160.00, 49.000000000000000000000000000000, 10, '2025-11-06 12:10:55', '2025-11-10 21:05:20', 'active'),
(323, 'එනසාල්', '274642365', 'enasal', 'pcs', 60.00, 60.00, 50.00, 500.000000000000000000000000000000, 10, '2025-11-06 12:11:19', '2025-11-11 08:16:44', 'active'),
(324, 'එනසාල්', '287411972', 'enasal', 'pcs', 100.00, 100.00, 80.00, 480.000000000000000000000000000000, 10, '2025-11-06 12:11:41', '2025-11-11 08:16:35', 'active'),
(325, 'බටර් විස්කෝතු', '320932727', 'batar', 'pcs', 130.00, 130.00, 100.00, 50.000000000000000000000000000000, 10, '2025-11-06 12:12:14', '2025-11-06 12:12:14', 'active'),
(326, 'ටෝච්', '354357855', 'torch', 'pcs', 1.00, 1.00, 1.00, 5000.000000000000000000000000000000, 10, '2025-11-06 12:12:42', '2025-11-06 12:12:42', 'active'),
(327, 'බල්බ්', '377399763', 'balb', 'pcs', 220.00, 200.00, 180.00, 50.000000000000000000000000000000, 10, '2025-11-06 12:13:23', '2025-11-06 12:13:23', 'active'),
(328, 'බල්බ්', '409375561', 'balb', 'pcs', 280.00, 250.00, 230.00, 50.000000000000000000000000000000, 10, '2025-11-06 12:13:46', '2025-11-06 12:13:46', 'active'),
(329, 'බල්බ්', '432008340', 'balb', 'pcs', 330.00, 300.00, 280.00, 50.000000000000000000000000000000, 10, '2025-11-06 12:14:03', '2025-11-06 12:14:03', 'active'),
(330, 'බල්බ්', '450944917', 'balb', 'pcs', 420.00, 400.00, 350.00, 50.000000000000000000000000000000, 10, '2025-11-06 12:14:25', '2025-11-06 12:14:25', 'active'),
(331, 'ටිෆින්', '888101932190', 'tipin', 'pcs', 190.00, 190.00, 180.00, 48.000000000000000000000000000000, 10, '2025-11-06 12:22:36', '2025-11-06 12:48:16', 'inactive'),
(332, 'කලින් හිඟ මුදල', '925445829', 'naya', 'pcs', 1.00, 1.00, 1.00, 10775.000000000000000000000000000000, 10, '2025-11-06 12:38:52', '2025-11-16 17:48:49', 'active'),
(333, 'සෝයා', '027428110', 'soya', 'pcs', 60.00, 60.00, 50.00, 100.000000000000000000000000000000, 10, '2025-11-06 12:40:44', '2025-11-06 12:40:44', 'active'),
(334, 'සෝයා', '052600751', 'soya', 'pcs', 50.00, 50.00, 40.00, 100.000000000000000000000000000000, 10, '2025-11-06 12:40:58', '2025-11-06 12:40:58', 'active'),
(335, 'ආප්ප සෝඩා', '083185855', 'appa', 'pcs', 20.00, 20.00, 15.00, 100.000000000000000000000000000000, 10, '2025-11-06 12:41:31', '2025-11-06 12:41:31', 'active'),
(336, 'හිස් බෝතල්', '110498747', 'bothal', 'pcs', 20.00, 20.00, 15.00, 100.000000000000000000000000000000, 10, '2025-11-06 12:42:01', '2025-11-06 12:42:01', 'active'),
(337, 'කුඩ', '136838580', 'kuda', 'pcs', 1.00, 1.00, 1.00, 50000.000000000000000000000000000000, 10, '2025-11-06 12:42:25', '2025-11-06 12:42:25', 'active'),
(338, 'ලණු', '156511946', 'lanu', 'pcs', 250.00, 250.00, 230.00, 50.000000000000000000000000000000, 10, '2025-11-06 12:42:43', '2025-11-06 12:42:43', 'active'),
(339, 'ලණු', '171018285', 'lanu', 'pcs', 300.00, 300.00, 280.00, 50.000000000000000000000000000000, 10, '2025-11-06 12:42:58', '2025-11-06 12:42:58', 'active'),
(340, 'ඊස්ට්', '210740544', 'est', 'pcs', 1450.00, 1300.00, 1100.00, 50.000000000000000000000000000000, 10, '2025-11-06 12:43:56', '2025-11-06 12:43:56', 'active'),
(341, 'ඊස්ට්', '244713270', 'est', 'pcs', 110.00, 110.00, 90.00, 99.000000000000000000000000000000, 10, '2025-11-06 12:44:23', '2025-11-19 15:21:47', 'active'),
(353, 'උළුහාල්', '952642348', 'uluhal', 'pcs', 60.00, 50.00, 40.00, 28.000000000000000000000000000000, 10, '2025-11-07 18:57:18', '2025-11-18 15:48:30', 'active'),
(354, 'බැට්රි', '373327405', 'batri', 'pcs', 120.00, 110.00, 80.00, 19.000000000000000000000000000000, 10, '2025-11-07 19:03:37', '2025-11-11 08:03:39', 'active'),
(355, 'පෙට්‍රල්', '684792952', 'petral', 'pcs', 350.00, 340.00, 330.00, 40.000000000000000000000000000000, 10, '2025-11-07 19:08:51', '2025-11-07 19:08:51', 'active'),
(356, 'ලාම්පු තෙල්', '252370831', 'lampu thel', 'pcs', 200.00, 200.00, 180.00, 15.000000000000000000000000000000, 10, '2025-11-07 19:18:32', '2025-11-07 19:18:32', 'active'),
(357, 'පොඩි බිස්කට්', '428993493', 'podi biskat', 'pcs', 50.00, 50.00, 40.00, 140.000000000000000000000000000000, 10, '2025-11-07 19:21:15', '2025-11-07 19:21:15', 'active'),
(358, 'කොහු', '564179772', 'kohu', 'pcs', 430.00, 400.00, 280.00, 15.000000000000000000000000000000, 10, '2025-11-07 19:24:17', '2025-11-07 19:24:17', 'active'),
(359, 'මොබ්', '822828003', 'mob', 'pcs', 400.00, 400.00, 280.00, 15.000000000000000000000000000000, 10, '2025-11-07 19:27:37', '2025-11-07 19:27:37', 'active'),
(360, 'වයිපර්', '941140019', 'waipar', 'pcs', 400.00, 400.00, 280.00, 15.000000000000000000000000000000, 10, '2025-11-07 19:29:22', '2025-11-07 19:29:22', 'active'),
(361, 'ඉදල්', '060692297', 'idal', 'pcs', 260.00, 250.00, 220.00, 15.000000000000000000000000000000, 10, '2025-11-07 19:31:31', '2025-11-11 08:00:23', 'inactive'),
(362, 'සුදු සීනි පැකට්', '872168955', 'sini', 'pcs', 250.00, 230.00, 200.00, 96.000000000000000000000000000000, 10, '2025-11-08 11:51:23', '2025-11-23 09:20:56', 'active'),
(363, 'රට ඉදි', '016070917', 'rata idi', 'pcs', 900.00, 800.00, 700.00, 15.000000000000000000000000000000, 10, '2025-11-10 09:11:03', '2025-11-10 09:14:04', 'inactive'),
(364, 'සිනි ', '266315656', 'sini', 'pcs', 250.00, 220.00, 238.00, 100.000000000000000000000000000000, 10, '2025-11-10 12:10:40', '2025-11-10 12:31:46', 'active'),
(365, 'සීනි', '597603757', 'sini', 'pcs', 270.00, 260.00, 240.00, 489.000000000000000000000000000000, 10, '2025-11-10 17:56:46', '2025-11-16 18:04:46', 'active'),
(366, 'නෙස්ටොමෝල්ට්', '4792024021616', 'nestomalt', 'pcs', 780.00, 780.00, 740.00, 25.000000000000000000000000000000, 10, '2025-11-10 20:41:15', '2025-11-10 20:52:49', 'active'),
(367, 'සිග්නල්', '007130998', 'SIGNAL', 'pcs', 0.00, 0.00, 0.00, 25.000000000000000000000000000000, 10, '2025-11-10 22:47:14', '2025-11-11 08:01:07', 'inactive'),
(368, 'නුඩ්ලස්', '170636146', 'NUDLAS', 'pcs', 0.00, 0.00, 0.00, 30.000000000000000000000000000000, 10, '2025-11-10 22:49:43', '2025-11-11 08:02:09', 'inactive'),
(369, 'බිස්කට්', '305203902', 'BISKAT', 'pcs', 0.00, 0.00, 0.00, 25.000000000000000000000000000000, 10, '2025-11-10 22:52:05', '2025-11-19 18:54:10', 'inactive'),
(370, 'පාන්', '579259492', 'PAN', 'pcs', 0.00, 0.00, 0.00, 25.000000000000000000000000000000, 10, '2025-11-10 22:56:59', '2025-11-18 15:32:58', 'inactive'),
(371, 'කෑම', '991737016', 'KAMA', 'pcs', 0.00, 0.00, 0.00, 50.000000000000000000000000000000, 10, '2025-11-10 23:03:25', '2025-11-11 08:03:24', 'inactive'),
(372, 'දත් බූරූසු', '591252797', 'DATH BURUSU', 'pcs', 0.00, 0.00, 0.00, 50.000000000000000000000000000000, 10, '2025-11-10 23:14:02', '2025-11-10 23:14:02', 'active'),
(373, 'දෙවනි බැත', '4792149097107', 'DEWANI BATHA', 'pcs', 330.00, 330.00, 300.00, 30.000000000000000000000000000000, 10, '2025-11-10 23:19:06', '2025-11-11 08:00:38', 'inactive'),
(376, '‍‍‍රෙක්ෂෝනා', '488555522', 'REKSHONA', 'pcs', 200.00, 200.00, 180.00, 25.000000000000000000000000000000, 10, '2025-11-10 23:28:19', '2025-11-10 23:28:19', 'active'),
(377, 'බට්ටෝ', '849340127', 'BATTO', 'pcs', 100.00, 100.00, 90.00, 50.000000000000000000000000000000, 10, '2025-11-10 23:34:31', '2025-11-11 08:01:03', 'inactive'),
(378, 'සව්බොරව', '081978277', 'SAWBORAWA', 'pcs', 180.00, 180.00, 160.00, 24.000000000000000000000000000000, 10, '2025-11-10 23:42:11', '2025-11-11 08:26:11', 'active'),
(379, 'බේබ් කොලොන්', '971816244', 'COLON', 'pcs', 360.00, 360.00, 340.00, 24.000000000000000000000000000000, 10, '2025-11-10 23:53:20', '2025-11-11 00:16:49', 'active'),
(380, 'සබන්', '622911681', 'saban', 'pcs', 1.00, 1.00, 1.00, 2278.000000000000000000000000000000, 10, '2025-11-13 09:50:47', '2025-12-05 22:29:03', 'active'),
(381, 'හාල්', '413138163', 'hal', 'pcs', 195.00, 190.00, 185.00, 2625045660.000000000000000000000000000000, 10, '2025-11-13 10:53:54', '2025-11-21 11:25:30', 'active'),
(382, 'ඩෙල්මාලයිට්', '548033226', 'delmalait', 'pcs', 100.00, 100.00, 80.00, 2000.000000000000000000000000000000, 10, '2025-11-13 10:56:56', '2025-11-13 10:56:56', 'active'),
(383, 'සිග්නල්', '696693342', 'signal', 'pcs', 340.00, 340.00, 320.00, 600.000000000000000000000000000000, 10, '2025-11-13 10:59:09', '2025-11-13 11:01:07', 'inactive'),
(384, 'සිග්නල් ටූත් පේස්ට්', '863674639', 'signal', 'pcs', 340.00, 340.00, 320.00, 600.000000000000000000000000000000, 10, '2025-11-13 11:01:35', '2025-11-13 11:01:35', 'active'),
(385, 'සිග්නල්', '967279935', 'signal', 'pcs', 1.00, 1.00, 1.00, 800.000000000000000000000000000000, 10, '2025-11-13 11:03:04', '2025-11-13 11:04:07', 'active'),
(386, 'වීවා', '173914807', 'viva', 'pcs', 780.00, 780.00, 700.00, 900.000000000000000000000000000000, 10, '2025-11-13 11:06:33', '2025-11-13 11:06:33', 'active'),
(387, 'වටානා පරිප්පු', '290345372', 'watana', 'pcs', 250.00, 200.00, 180.00, 1199.000000000000000000000000000000, 10, '2025-11-13 11:08:39', '2025-11-19 17:33:42', 'active'),
(388, 'දත් බුරුසු', '744172341', 'dath burusu', 'pcs', 1.00, 1.00, 1.00, 1110.000000000000000000000000000000, 10, '2025-11-13 11:16:11', '2025-11-16 17:27:02', 'active'),
(389, 'ඉදි ආප්ප පිටි', '852118104', 'idi appa piti', 'pcs', 350.00, 350.00, 330.00, 1091.000000000000000000000000000000, 10, '2025-11-13 11:17:51', '2025-11-13 13:25:23', 'active'),
(390, 'නූඩ්ලස්', '007823075', 'nudlas', 'pcs', 1.00, 1.00, 1.00, 1500.000000000000000000000000000000, 10, '2025-11-13 11:20:23', '2025-11-13 11:20:23', 'active'),
(391, 'මාමයිට්', '110731557', 'mamait', 'pcs', 395.00, 395.00, 370.00, 500.000000000000000000000000000000, 10, '2025-11-13 11:22:18', '2025-11-13 11:22:18', 'active'),
(392, 'කෑම', '505946465', 'kama', 'pcs', 1.00, 1.00, 1.00, 1400.000000000000000000000000000000, 10, '2025-11-13 11:45:55', '2025-11-13 11:45:55', 'active'),
(393, 'කැලින් සබන්', '832017355', 'calin', 'pcs', 150.00, 150.00, 125.00, 993.000000000000000000000000000000, 10, '2025-11-13 11:50:52', '2025-11-13 13:23:34', 'active'),
(394, 'බට්ටො', '065136862', 'batto', 'pcs', 100.00, 100.00, 90.00, 798.000000000000000000000000000000, 10, '2025-11-13 11:54:42', '2025-11-24 12:15:01', 'active'),
(395, 'පාන්', '603416309', 'pan', 'pcs', 1.00, 1.00, 1.00, 10000000000000000.000000000000000000000000000000, 10, '2025-11-13 12:03:39', '2025-11-18 15:33:19', 'active'),
(396, 'බේබි කොලොන්', '742805092', 'baby', 'pcs', 360.00, 360.00, 340.00, 479.000000000000000000000000000000, 10, '2025-11-13 12:06:05', '2025-11-21 11:52:05', 'active'),
(397, 'සන්සිල්ක් ෂැම්පු', '834168249', 'shampo', 'pcs', 1.00, 1.00, 1.00, 400.000000000000000000000000000000, 10, '2025-11-13 12:25:24', '2025-11-13 12:25:24', 'active'),
(398, 'බිස්කට්', '011777449', 'biskat', 'pcs', 1.00, 1.00, 1.00, 690.000000000000000000000000000000, 10, '2025-11-13 12:27:09', '2025-11-23 09:20:56', 'active'),
(399, 'චෙරිෂ් වේෆර්ස් ', '358273419', 'cwefars', 'pcs', 490.00, 440.00, 320.00, 980.000000000000000000000000000000, 10, '2025-11-13 12:33:09', '2025-11-19 18:57:38', 'active'),
(400, 'කොත්තු පැකට්', '508821600', 'kotthu', 'pcs', 350.00, 350.00, 330.00, 1000.000000000000000000000000000000, 10, '2025-11-13 12:35:53', '2025-11-13 12:35:53', 'active'),
(401, 'සීනි', '665852714', 'sini', 'pcs', 1.00, 1.00, 1.00, 990.000000000000000000000000000000, 10, '2025-11-13 12:38:02', '2025-11-13 12:38:02', 'active'),
(402, 'අයිස් ක්‍රීම්', '906220798', 'ice cream', 'pcs', 1.00, 1.00, 1.00, 940.000000000000000000000000000000, 10, '2025-11-13 12:42:02', '2025-11-13 12:42:02', 'active'),
(403, 'හාල් මැස්සො', '007544757', 'hal masso', 'pcs', 1200.00, 1150.00, 900.00, 800.000000000000000000000000000000, 10, '2025-11-13 12:45:02', '2025-11-13 12:45:02', 'active'),
(404, 'දෙවැනි බැත', '836523598', 'dewani batha', 'pcs', 330.00, 330.00, 300.00, 5000.000000000000000000000000000000, 10, '2025-11-13 13:30:51', '2025-11-13 13:30:51', 'active'),
(405, 'විම්', '511543996', 'vim', 'pcs', 50.00, 50.00, 40.00, 198.000000000000000000000000000000, 10, '2025-11-16 17:00:58', '2025-11-24 12:15:01', 'active'),
(406, 'නයි මිරිස්', '121684852', 'naimiris', 'pcs', 1200.00, 1200.00, 1000.00, 4.900000000000000000000000000000, 1, '2025-11-16 17:09:15', '2025-11-16 17:56:43', 'active'),
(407, 'සම්බා', '580098863', 'samba', 'pcs', 290.00, 280.00, 260.00, 199.000000000000000000000000000000, 10, '2025-11-16 17:33:14', '2025-11-16 18:04:46', 'active'),
(408, 'සම්බා', '601003136', 'samba', 'pcs', 260.00, 250.00, 240.00, 200.000000000000000000000000000000, 10, '2025-11-16 17:33:35', '2025-11-16 17:33:35', 'active'),
(409, 'කෑම', '988675434', 'kama', 'pcs', 1.00, 1.00, 1.00, 1000000000000000000000.000000000000000000000000000000, 10, '2025-11-18 15:29:57', '2025-11-18 15:29:57', 'active'),
(410, 'කෑම', '120698790', 'kaama', 'pcs', 1.00, 1.00, 1.00, 9999999999999999820.000000000000000000000000000000, 10, '2025-11-18 15:32:08', '2025-11-19 17:33:42', 'active'),
(411, 'කිරි පිටි', '490593542', 'kiripiti', 'pcs', 1.00, 1.00, 1.00, 9999999999999999999999999999999200.000000000000000000000000000000, 10, '2025-11-18 15:38:22', '2025-11-23 09:20:56', 'active'),
(412, 'සමහන්', '114729758', 'samahan', 'pcs', 60.00, 60.00, 50.00, 100.000000000000000000000000000000, 10, '2025-11-18 16:55:20', '2025-11-18 16:55:20', 'active'),
(413, 'තේ කොළ', '727011522', 'thekola', 'pcs', 1.00, 1.00, 1.00, 451259033.000000000000000000000000000000, 10, '2025-11-19 18:56:27', '2025-11-24 12:15:01', 'active'),
(414, 'චිකන් ඕෆ්කට්', '389904386', 'offcut', 'pcs', 800.00, 750.00, 630.00, 20.000000000000000000000000000000, 10, '2025-11-20 12:38:18', '2025-11-20 12:38:18', 'active'),
(415, 'පීකුදු', '515564533', 'peekudu', 'pcs', 1000.00, 900.00, 700.00, 20.000000000000000000000000000000, 10, '2025-11-20 12:39:06', '2025-11-20 12:39:06', 'active'),
(416, 'බ්ලේඩ් තල', '912542550', 'bledthala', 'pcs', 50.00, 50.00, 40.00, 475858662223.000000000000000000000000000000, 10, '2025-11-20 17:12:13', '2025-11-20 17:12:13', 'active'),
(417, 'සෝයා', '026582833', 'soya', 'pcs', 1.00, 1.00, 1.00, 478596652296.000000000000000000000000000000, 10, '2025-11-20 17:14:09', '2025-11-21 11:52:05', 'active'),
(418, 'අයිස් කෝන් පැකට්', '175831084', 'icekon', 'pcs', 200.00, 200.00, 180.00, 47588969633.000000000000000000000000000000, 10, '2025-11-20 17:16:32', '2025-11-20 17:16:32', 'active'),
(419, 'නෙස්ප්‍රේ කිරිපිටි', '515193475', 'nespray', 'pcs', 800.00, 800.00, 785.00, 475589996963.000000000000000000000000000000, 10, '2025-11-20 17:22:27', '2025-11-20 17:22:27', 'active'),
(420, 'ස්ටොක් පව්ඩර්', '653820162', 'stokpawder', 'pcs', 1.00, 1.00, 1.00, 35875221589.000000000000000000000000000000, 10, '2025-11-20 17:24:50', '2025-11-20 17:24:50', 'active'),
(421, 'බිස්කට් ටින්', '758738492', 'biskattin', 'pcs', 700.00, 700.00, 455.00, 5786339.000000000000000000000000000000, 10, '2025-11-20 17:26:53', '2025-11-20 17:26:53', 'active'),
(422, 'ප්‍රින්ට් අවුට්', '738321302', 'pritout', 'pcs', 20.00, 10.00, 10.00, 4521789633322.000000000000000000000000000000, 10, '2025-11-21 11:30:33', '2025-11-21 11:33:51', 'active'),
(423, 'පොටෝ කොපි', '961783576', 'potocopy', 'pcs', 15.00, 10.00, 10.00, 415278963332445.000000000000000000000000000000, 10, '2025-11-21 11:33:31', '2025-11-21 11:33:31', 'active'),
(424, 'මිරිස් කෑලි', '175817001', 'miriskali', 'pcs', 1.00, 1.00, 1.00, 11425789966356966.000000000000000000000000000000, 10, '2025-11-21 11:36:37', '2025-11-21 11:36:37', 'active'),
(425, 'මිරිස් කුඩු', '246496688', 'miriskudu', 'pcs', 1.00, 1.00, 1.00, 1451756.000000000000000000000000000000, 10, '2025-11-21 11:37:39', '2025-11-23 09:20:56', 'active'),
(426, 'මස්කරි', '324235311', 'maskari', 'pcs', 1.00, 1.00, 1.00, 142578996633356.000000000000000000000000000000, 10, '2025-11-21 11:38:57', '2025-11-21 11:38:57', 'active'),
(427, 'බෑග්', '119015075', 'bag', 'pcs', 1.00, 1.00, 1.00, 41578569966.000000000000000000000000000000, 10, '2025-11-24 12:22:16', '2025-11-24 12:22:16', 'active');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `bill_records`
--
ALTER TABLE `bill_records`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `unique_bill_per_day` (`bill_date`,`bill_number`),
  ADD KEY `idx_customer_id` (`customer_id`);

--
-- Indexes for table `customers`
--
ALTER TABLE `customers`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `customer_code` (`customer_code`),
  ADD KEY `idx_phone` (`phone`),
  ADD KEY `idx_code` (`customer_code`);

--
-- Indexes for table `customer_credits`
--
ALTER TABLE `customer_credits`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `unique_credit_entry` (`customer_id`,`bill_id`,`created_at`,`transaction_type`),
  ADD UNIQUE KEY `unique_customer_bill_credit` (`customer_id`,`bill_id`,`transaction_type`),
  ADD KEY `bill_id` (`bill_id`),
  ADD KEY `idx_customer` (`customer_id`),
  ADD KEY `idx_date` (`created_at`);

--
-- Indexes for table `sales`
--
ALTER TABLE `sales`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `barcode` (`barcode`),
  ADD KEY `idx_barcode` (`barcode`),
  ADD KEY `idx_item_name_sinhala` (`item_name_sinhala`),
  ADD KEY `idx_item_name_english` (`item_name_english`),
  ADD KEY `idx_our_price` (`our_price`),
  ADD KEY `idx_stock_quantity` (`stock_quantity`),
  ADD KEY `idx_unit_of_measurement` (`unit_of_measurement`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `bill_records`
--
ALTER TABLE `bill_records`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=210;

--
-- AUTO_INCREMENT for table `customers`
--
ALTER TABLE `customers`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `customer_credits`
--
ALTER TABLE `customer_credits`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `sales`
--
ALTER TABLE `sales`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=428;
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 */;
