INSERT INTO `all_sales_cancelled` (`_id`, `itemname`, `quantity`, `price`, `total`, `type`, `parent`, `parentid`, `mod_assigned`, `tax`, `taxname`, `bill_no`, `time`, `date`, `user`, `billtype`, `paymentmethod`, `billamount_disapply`, `billamount_disnotapply`, `_idd`, `reason`, `billamount_cancelled`, `date1`, `billamount_cancelled_user`, `disc_type`, `disc_value`, `newtotal`, `disc_thereornot`, `disc_indiv_total`, `datetimee_new`, `taxname2`, `tax2`, `taxname3`, `tax3`, `taxname4`, `tax4`, `taxname5`, `tax5`, `hsn_code`, `old_total`, `old_total_indiv`) VALUES (1,'dosa','1.0','35.00','35.0','Item',NULL,NULL,'no',NULL,NULL,'20250304-1-0000111','10:39:07 PM','2025 03 04','admin','  Dine-in','  Cash','135.00','135.0','15','Damaged/Spoiled','35.00','04 Mar 2025','35.00','%','0','105.00','no','','202503042239',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL),(2,'dosa','1.0','35.00','35.0','Item',NULL,NULL,'no',NULL,NULL,'20250304-1-0000112','10:50:48 PM','2025 03 04','admin','  Dine-in','  Cash','105.00','105.0','16','Delayed','35.00','04 Mar 2025','35.00','%','0','105.00','no','','202503042250',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL),(3,'dosa','1.0','35.00','35.0','Item',NULL,NULL,'no',NULL,NULL,'20250304-1-0000112','11:02:38 PM','2025 03 04','admin','  Dine-in','  Cash','70.00','70.0','16','Delayed','70.0','04 Mar 2025','35.00','%','0','105.00','no','','202503042302',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL),(4,'dosa','1.0','35.00','35.0','Item',NULL,NULL,'no',NULL,NULL,'20250304-1-0000113','11:22:07 PM','2025 03 04','admin','  Dine-in','  Cash','140.00','140.0','17','Delayed','35.00','04 Mar 2025','35.00','%','0','140.00','no','','202503042322',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL),(5,'pongal','1.0','30.00','30.0','Item',NULL,NULL,'no',NULL,NULL,'20250305-1-000011','12:24:57 PM','2025 03 05','admin','  Dine-in','  Cash','120.00','120.0','18','Damaged/Spoiled','30.00','05 Mar 2025','30.00','%','0','120.00','no','','202503051224',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL),(6,'dosa','2.0','35.70','71.40','Item',NULL,NULL,'no','2','None','430-20250327-1-000012','01:25:14 PM','2025 03 27','admin','  Dine-in','  Cash','71.40','71.4','3','Delayed','71.40','27 Mar 2025','71.40','%','0','71.40','no','','202503271325',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','70.00','35.00'),(7,'idly','1.0','2.00','2.0','Item',NULL,NULL,'no',NULL,NULL,'430-20250512-1-000011','12:48:30 PM','2025 05 12','admin','  Dine-in','  Cash','10.00','83.4','1','Damaged/Spoiled','-71.40','12 May 2025','-71.40','%','0','10.00','no','','202505121248',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'20aa3','10.00','2.00'),(8,'idly','1.0','2.00','2.0','Item',NULL,NULL,'no',NULL,NULL,'430-20250512-1-000012','12:49:11 PM','2025 05 12','admin','  Dine-in','  Cash','10.00','10.0','2','Delayed','2.00','12 May 2025','2.00','%','0','10.00','no','','202505121249',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'20aa3','10.00','2.00'),(9,'idly','1.0','26.25','26.25','Item',NULL,NULL,'no','5','sgst(5%)','430-20250526-1-000011','06:08:47 PM','2025 05 29','admin','  Dine-in','  Cash','265.13','278.37','1','Delayed','60.39','29 May 2025','60.39','%','10','118.13','yes','2.63','202505291808',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'20aa3','125.00','25.00'),(10,'dosa','1.0','36.75','36.75','Item',NULL,NULL,'no','5','sgst(5%)','430-20250526-1-000011','06:08:47 PM','2025 05 29','admin','  Dine-in','  Cash','265.13','278.37','2','Delayed','60.39','29 May 2025','60.39','%','0','147.00','no','','202505291808',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','140.00','35.00');
INSERT INTO `billcount` (`_id`, `value`) VALUES (1,'0');
INSERT INTO `billnumber` (`_id`, `billnumber`, `total`, `user`, `date`, `paymentmethod`, `billtype`, `subtotal`, `taxtotal`, `roundoff`, `globaltaxtotal`, `billcount`, `datetimee_new`, `comments_sales`, `delivery_fee`, `packing_charges`, `loyalty_points`, `loyalty_amount`, `order_id`, `transaction_id`, `transaction_id_org`, `source`, `source1`) VALUES (1,'20240823-1-000011','25.00','admin','2024 08 23','  Cash','  Dine-in','25.00','0.00','0.00','0.0','1','202408231307',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(2,'20240823-1-000012','25.00','admin','2024 08 23','  Cash','  Dine-in','25.00','0.00','0.00','0.0','2','202408231307',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(3,'20240823-1-000013','35.00','admin','2024 08 23','  Cash','  Dine-in','35.00','0.00','0.00','0.0','3','202408231308',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(4,'20240823-1-000014','30.00','admin','2024 08 23','  Cash','  Dine-in','30.00','0.00','0.00','0.0','4','202408231309',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(5,'20240825-1-000011','2.00','admin','2024 08 25','  Cash','  Dine-in','2.00','0.00','0.00','0.0','5','202408251239',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(6,'20240826-1-000011','2.00','admin','2024 08 26','  Cash','  Dine-in','2.00','0.00','0.00','0.0','6','202408261915',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(7,'20240826-1-000012','1.00','admin','2024 08 26','  Card','  Dine-in','1.00','0.00','0.00','0.0','7','202408261915',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(8,'20240826-1-000013','2.00','admin','2024 08 26','  Card','  Dine-in','2.00','0.00','0.00','0.0','8','202408261917',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(9,'20240827-1-000011','1.00','admin','2024 08 27','  Card','  Dine-in','1.00','0.00','0.00','0.0','9','202408271122',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10,'20240827-1-000012','1.00','admin','2024 08 27','  Card','  Dine-in','1.00','0.00','0.00','0.0','10','202408271339',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(11,'20240902-1-000011','1.00','admin','2024 09 02','  Card','  Dine-in','1.00','0.00','0.00','0.0','11','202409021938',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(12,'20240903-1-000011','1.00','admin','2024 09 03','  Card','  Dine-in','1.00','0.00','0.00','0.0','12','202409031945',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(13,'20240903-1-000012','1.00','admin','2024 09 03','  Card','  Dine-in','1.00','0.00','0.00','0.0','13','202409032018',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(14,'20240903-1-000013','1.00','admin','2024 09 03','  Upiqr','  Dine-in','1.00','0.00','0.00','0.0','14','202409032021',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(15,'20240904-1-000011','1.00','admin','2024 09 04','  Upiqr','  Dine-in','1.00','0.00','0.00','0.0','15','202409040925',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(16,'20240904-1-000012','1.00','admin','2024 09 04','  Upiqr','  Dine-in','1.00','0.00','0.00','0.0','16','202409041426',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(17,'20240909-1-000011','1.00','admin','2024 09 09','  Upiqr','  Dine-in','1.00','0.00','0.00','0.0','17','202409091556',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(18,'20240910-1-000011','1.00','admin','2024 09 10','  Upiqr','  Dine-in','1.00','0.00','0.00','0.0','18','202409101432',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(19,'20240910-1-000012','35.00','admin','2024 09 10','  Cash','  Dine-in','35.00','0.00','0.00','0.0','19','202409101611',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(20,'20240910-1-000013','35.00','admin','2024 09 10','  Cash','  Dine-in','35.00','0.00','0.00','0.0','20','202409101622',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(21,'20240910-1-000014','1.00','admin','2024 09 10','  Upiqr','  Dine-in','1.00','0.00','0.00','0.0','21','202409101634',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(22,'20240910-1-000015','1.00','admin','2024 09 10','  Upiqr','  Dine-in','1.00','0.00','0.00','0.0','22','202409101750',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(23,'20240910-1-000016','1.00','admin','2024 09 10','  Upiqr','  Dine-in','1.00','0.00','0.00','0.0','23','202409101837',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(24,'20240910-1-000017','1.00','admin','2024 09 10','  Card','  Dine-in','1.00','0.00','0.00','0.0','24','202409101839',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(474,'20240903-1-000011','70.00','admin','2024 09 03','  Cash','  Dine-in','70.00','0.00','0.00','0.0','352','202409031101',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(475,'20240904-1-000012','25.00','admin','2024 09 04','  Cash','  Dine-in','25.00','0.00','0.00','0.0','353','202409041030',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(476,'20240904-1-000013','35.00','admin','2024 09 04','  Cash','  Dine-in','35.00','0.00','0.00','0.0','354','202409041032',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(477,'20240904-1-000014','1.00','admin','2024 09 04','  Card','  Dine-in','1.00','0.00','0.00','0.0','355','202409041518',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(478,'20240904-1-000015','1.00','admin','2024 09 04','  Upiqr','  Dine-in','1.00','0.00','0.00','0.0','356','202409041542',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(479,'20240905-1-000011','1.00','admin','2024 09 05','  Cash','  Dine-in','1.00','0.00','0.00','0.0','357','202409050942',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(480,'20240905-1-000012','70.00','admin','2024 09 05','  Cash','  Dine-in','70.00','0.00','0.00','0.0','358','202409050943',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(481,'20240905-1-000013','145.00','admin','2024 09 05','  Cash','  Dine-in','145.00','0.00','0.00','0.0','359','202409050944',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(482,'20240905-1-000014','65.00','admin','2024 09 05','  Cash','  Dine-in','65.00','0.00','0.00','0.0','360','202409050944',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(483,'20240905-1-000015','70.00','admin','2024 09 05','  Cash','  Dine-in','70.00','0.00','0.00','0.0','361','202409050944',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(484,'20240905-1-000016','70.00','admin','2024 09 05','  Cash','  Dine-in','70.00','0.00','0.00','0.0','362','202409050945',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(485,'20240905-1-000017','70.00','admin','2024 09 05','  Cash','  Dine-in','70.00','0.00','0.00','0.0','363','202409050947',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(486,'20240905-1-000018','70.00','admin','2024 09 05','  Cash','  Dine-in','70.00','0.00','0.00','0.0','364','202409051017',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(487,'20240905-1-000019','70.00','admin','2024 09 05','  Cash','  Dine-in','70.00','0.00','0.00','0.0','365','202409051023',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(488,'20240905-1-0000110','1.00','admin','2024 09 05','  Card','  Dine-in','1.00','0.00','0.00','0.0','366','202409051046',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(489,'20240905-1-0000111','1.00','admin','2024 09 05','  Card','  Dine-in','1.00','0.00','0.00','0.0','367','202409051253',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(490,'20240905-1-0000112','35.00','admin','2024 09 05','  Cash','  Dine-in','35.00','0.00','0.00','0.0','368','202409051539',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(491,'20240912-000011','1.00','admin','2024 09 12','  Upiqr','  Dine-in','1.00','0.00','0.00','0.0','369','202409121523',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(492,'20240912-000012','1.00','admin','2024 09 12','  Card','  Dine-in','1.00','0.00','0.00','0.0','370','202409121523',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(493,'20240916-1-000013','172.04','admin','2024 09 16','  Cash','  Dine-in','156.40','36.04','0.00','10.0','371','202409161029',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(494,'20240916-1-000014','65.00','admin','2024 09 16','  Cash','  Dine-in','65.00','0.00','0.00','0.0','372','202409161031',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(495,'20240917-1-000011','35.00','admin','2024 09 17','  Cash','  Dine-in','35.00','0.00','0.00','0.0','373','202409171155',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(496,'20240918-1-000012','35.00','user1','2024 09 18','  Cash','  Dine-in','35.00','0.00','0.00','0.0','374','202409181509',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(497,'20240919-1-000011','60.00','admin','2024 09 19','  Cash','  Dine-in','60.00','0.00','0.00','0.0','375','202409190929',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(498,'20240924-1-000011','36.00','admin','2024 09 24','  Cash','  Dine-in','36.00','0.00','0.00','0.0','376','202409241759',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(499,'20240924-1-000012','110.00','admin','2024 09 24','  Cash','  Dine-in','110.00','0.00','0.00','0.0','377','202409241759',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(500,'20240924-1-000013','66.00','admin','2024 09 24','  Cash','  Dine-in','66.00','0.00','0.00','0.0','378','202409241759',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(501,'20241003-1-000011','1.02','admin','2024 10 03','  Upiqr','  Dine-in','1.02','0.02','0.00','0.0','379','202410031729',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(502,'20241003-1-000012','1.02','admin','2024 10 03','  Cash','  Dine-in','1.02','0.02','0.00','0.0','380','202410031729',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(503,'20241004-1-000011','1.02','admin','2024 10 04','  Cash','  Dine-in','1.02','0.02','0.00','0.0','381','202410041027',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(504,'20241004-1-000012','1.02','admin','2024 10 04','  Cash','  Dine-in','1.02','0.02','0.00','0.0','382','202410041045',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(505,'20241004-1-000013','1.02','admin','2024 10 04','  Cash','  Dine-in','1.02','0.02','0.00','0.0','383','202410041047',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(506,'20241004-1-000014','1.02','admin','2024 10 04','  Cash','  Dine-in','1.02','0.02','0.00','0.0','384','202410041054',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(507,'20241004-1-000015','30.60','admin','2024 10 04','  Cash','  Dine-in','30.60','0.60','0.00','0.0','385','202410041055',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(508,'20241004-1-000016','1.02','admin','2024 10 04','  Cash','  Dine-in','1.02','0.02','0.00','0.0','386','202410041056',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(509,'20241004-1-000017','1.02','admin','2024 10 04','  Cash','  Dine-in','1.02','0.02','0.00','0.0','387','202410041125',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(510,'20241004-1-000018','1.02','admin','2024 10 04','  Cash','  Dine-in','1.02','0.02','0.00','0.0','388','202410041126',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(511,'20241004-1-000019','1.02','admin','2024 10 04','  Upiqr','  Dine-in','1.02','0.02','0.00','0.0','389','202410041133',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(512,'20241004-1-0000110','1.02','admin','2024 10 04','  Card','  Dine-in','1.02','0.02','0.00','0.0','390','202410041312',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(513,'20241004-1-0000111','1.02','admin','2024 10 04','  Card','  Dine-in','1.02','0.02','0.00','0.0','391','202410041910',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(514,'20241007-1-000011','2.04','admin','2024 10 07','  Cash','  Dine-in','2.04','0.04','0.00','0.0','392','202410071216',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(515,'20241007-1-000012','2.04','admin','2024 10 07','  Cash','  Dine-in','2.04','0.04','0.00','0.0','393','202410071233',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(516,'20241007-1-000013','2.04','admin','2024 10 07','  Cash','  Dine-in','2.04','0.04','0.00','0.0','394','202410071258',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(517,'20241007-1-000014','1.02','admin','2024 10 07','  Upiqr','  Dine-in','1.02','0.02','0.00','0.0','395','202410071448',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(518,'20241015-1-000011','25.00','admin','2024 10 15','  Cash','  Dine-in','25.00','0.00','0.00','0.0','396','202410151223',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(519,'20241015-1-000012','200.00','admin','2024 10 15','  Cash','  Dine-in','200.00','0.00','0.00','0.0','397','202410151451',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(520,'20241105-1-000011','1.00','admin','2024 11 05','  Cash','  Dine-in','1.00','0.00','0.00','0.0','398','202411051702',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(521,'20241105-1-000012','1.00','admin','2024 11 05','  Card','  Dine-in','1.00','0.00','0.00','0.0','399','202411051705',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(648,'20241021-1-000011','61.20','madmin','2024 10 21','  card','  Dine-in','60.000000','1.200000','0.000000','0','398','202410211222','','','','0','0',NULL,NULL,NULL,NULL,NULL),(649,'20241021-1-000012','12.50','admin','2024 10 21','  Cash','  Dine-in','25.00','0.00','+ 0.00','0.0','399','202410211302',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(650,'20241021-1-000013','25.00','admin','2024 10 21','  Cash','  Dine-in','25.00','0.00','0.00','0.0','400','202410211302',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(651,'20241022-1-000011','25.50','admin','2024 10 22','  Cash','  Dine-in','25.50','0.00','0.00','0.0','401','202410221543',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(652,'20241119-1-000011','140.00','admin','2024 11 19','  Cash','  Dine-in','140.00','0.00','0.00','0.0','402','202411191245',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(653,'20241127-1-000011','61.20','madmin','2024 11 27','  Pay Later','  Dine-in','60.000000','1.200000','0.000000','0','403','202411271131','','','','0','0',NULL,NULL,NULL,NULL,NULL),(654,'20241127-1-000012','178.50','madmin','2024 11 27','  cash','  Dine-in','175.000000','3.500000','0.000000','0','404','202411271135','','','','0','0',NULL,NULL,NULL,NULL,NULL),(655,'20241127-1-000013','71.40','madmin','2024 11 27','  cash','  Dine-in','70.000000','1.400000','0.000000','0','405','202411271135','','','','0','0',NULL,NULL,NULL,NULL,NULL),(656,'20241127-1-000014','270.00','admin','2024 11 27','  Cash','  Dine-in','275.00','0.00','0.00','0.0','406','202411271438',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(657,'20241204-1-000011','90.00','admin','2024 12 04','  Cash','  Dine-in','90.00','0.00','0.00','0.0','407','202412041334',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(658,'20241204-1-000012','90.00','admin','2024 12 04','  Cash','  Dine-in','90.00','0.00','0.00','0.0','408','202412041335',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(659,'20241204-1-000013','115.00','admin','2024 12 04','  Cash','  Dine-in','115.00','0.00','0.00','0.0','409','202412041338',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(660,'20241204-1-000014','115.00','admin','2024 12 04','  Cash','  Dine-in','115.00','0.00','0.00','0.0','410','202412041339',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(661,'20241204-1-000015','130.00','admin','2024 12 04','  Cash','  Dine-in','130.00','0.00','0.00','0.0','411','202412041340',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(662,'20241210-1-000011','60.00','admin','2024 12 10','  Cash','  Dine-in','60.00','0.00','0.00','0.0','412','202412101028',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(663,'20241210-1-000012','60.00','admin','2024 12 10','  Cash','  Dine-in','60.00','0.00','0.00','0.0','413','202412101029',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(664,'20241210-1-000013','70.00','admin','2024 12 10','  Cash','  Dine-in','70.00','0.00','0.00','0.0','414','202412101029',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(665,'20241210-1-000014','70.00','admin','2024 12 10','  Cash','  Dine-in','70.00','0.00','0.00','0.0','415','202412101029',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(666,'20241210-1-000015','65.00','admin','2024 12 10','  Cash','  Dine-in','65.00','0.00','0.00','0.0','416','202412101029',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(667,'20241210-1-000016','50.00','admin','2024 12 10','  Cash','  Dine-in','50.00','0.00','0.00','0.0','417','202412101029',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(668,'20241210-1-000017','75.00','admin','2024 12 10','  Cash','  Dine-in','75.00','0.00','0.00','0.0','418','202412101029',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(669,'20241210-1-000018','100.00','admin','2024 12 10','  Cash','  Dine-in','100.00','0.00','0.00','0.0','419','202412101030',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(670,'20241210-1-000019','120.00','admin','2024 12 10','  Cash','  Dine-in','120.00','0.00','0.00','0.0','420','202412101030',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(671,'20241210-1-0000110','50.00','admin','2024 12 10','  Cash','  Dine-in','50.00','0.00','0.00','0.0','421','202412101030',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(672,'20241210-1-0000111','105.00','admin','2024 12 10','  Cash','  Dine-in','105.00','0.00','0.00','0.0','422','202412101038',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(673,'20241210-1-0000112','60.00','admin','2024 12 10','  Cash','  Dine-in','60.00','0.00','0.00','0.0','423','202412101103',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(674,'20241210-1-0000113','95.00','admin','2024 12 10','  Cash','  Dine-in','95.00','0.00','0.00','0.0','424','202412101105',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(675,'20241210-1-000031','60.00','admin','2024 12 10','  Cash','  Takeaway','60.00','0.00','0.00','0.0','425','202412101533',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(676,'20241210-1-0000114','125.00','admin','2024 12 10','  Cash','  Dine-in','125.00','0.00','0.00','0.0','426','202412101545',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(677,'20250128-1-000011','1.00','ladmin','2025 01 28','  Card','  Dine-in','1.00','0.00','0.00','0.0','427','202501281244',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(678,'20250128-1-000012','1.00','ladmin','2025 01 28','  Card','  Dine-in','1.00','0.00','0.00','0.0','428','202501281245',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(679,'20250128-1-000013','1.00','admin','2025 01 28','  Card','  Dine-in','1.00','0.00','0.00','0.0','429','202501281500',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(680,'20250128-1-000014','2.00','ladmin','2025 01 28','  Cash','  Dine-in','2.00','0.00','0.00','0.0','430','202501281539',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(681,'20250128-1-000015','1.00','ladmin','2025 01 28','  Cash','  Dine-in','1.00','0.00','0.00','0.0','431','202501281539',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(682,'20250128-1-000016','2.00','ladmin','2025 01 28','  Cash','  Dine-in','2.00','0.00','0.00','0.0','432','202501281548',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(683,'20250128-1-000017','3.00','ladmin','2025 01 28','  Card','  Dine-in','3.00','0.00','0.00','0.0','433','202501281633',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(684,'20250128-1-000018','1.00','ladmin','2025 01 28','  Card','  Dine-in','1.00','0.00','0.00','0.0','434','202501281634',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(685,'20250206-1-000011','85.00','admin','2025 02 06','  Cash','  Dine-in','85.00','0.00','0.00','0.0','435','202502061608',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(686,'20250206-1-000012','1.00','admin','2025 02 06','  Card','  Dine-in','1.00','0.00','0.00','0.0','436','202502061940',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(687,'20250206-1-000013','1.00','admin','2025 02 06','  Upiqr','  Dine-in','1.00','0.00','0.00','0.0','437','202502061941',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(688,'20250206-1-000014','1.00','admin','2025 02 06','  Card','  Dine-in','1.00','0.00','0.00','0.0','438','202502062103',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(689,'20250207-1-000011','1.00','admin','2025 02 07','  Cash','  Dine-in','1.00','0.00','0.00','0.0','439','202502071137',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(690,'20250207-1-000012','36.00','admin','2025 02 07','  Cash','  Dine-in','36.00','0.00','0.00','0.0','440','202502071238',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(691,'20250207-1-000013','35.00','admin','2025 02 07','  Cash','  Dine-in','35.00','0.00','0.00','0.0','441','202502071239',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(692,'20250207-1-000014','31.00','admin','2025 02 07','  Cash','  Dine-in','31.00','0.00','0.00','0.0','442','202502071239',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(693,'20250207-1-000015','1.00','admin','2025 02 07','  Card','  Dine-in','1.00','0.00','0.00','0.0','443','202502071357',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(694,'20250207-1-000016','1.00','admin','2025 02 07','  Upiqr','  Dine-in','1.00','0.00','0.00','0.0','444','202502071401',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(695,'20250207-1-000017','1.00','admin','2025 02 07','  Upiqr','  Dine-in','1.00','0.00','0.00','0.0','445','202502071401',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(696,'20250207-1-000018','1.00','admin','2025 02 07','  Card','  Dine-in','1.00','0.00','0.00','0.0','446','202502071452',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(697,'20250207-1-000019','1.00','admin','2025 02 07','  Card','  Dine-in','1.00','0.00','0.00','0.0','447','202502071500',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(698,'20250207-1-0000110','1.00','admin','2025 02 07','  Upiqr','  Dine-in','1.00','0.00','0.00','0.0','448','202502071502',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(699,'20250207-1-0000111','1.00','admin','2025 02 07','  Cash','  Dine-in','1.00','0.00','0.00','0.0','449','202502071524',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(700,'20250207-1-0000112','2.00','admin','2025 02 07','  Cash','  Dine-in','2.00','0.00','0.00','0.0','450','202502071524',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(701,'20250210-1-000011','1.00','admin','2025 02 10','  Cash','  Dine-in','1.00','0.00','0.00','0.0','451','202502101211',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(702,'20250226-1-000011','66.00','admin','2025 02 26','  Cash','  Dine-in','66.00','0.00','0.00','0.0','452','202502261647',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(703,'20250304-1-000011','25.00','admin','2025 03 04','  Cash','  Dine-in','25.00','0.00','0.00','0.0','453','202503041135',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(704,'20250304-1-000012','35.00','admin','2025 03 04','  Cash','  Dine-in','35.00','0.00','0.00','0.0','454','202503041155',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(705,'20250304-1-000013','25.00','admin','2025 03 04','  Cash','  Dine-in','25.00','0.00','0.00','0.0','455','202503041200',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(706,'20250304-1-000014','60.00','admin','2025 03 04','  Cash','  Takeaway','60.00','0.00','0.00','0.0','456','202503041427',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(707,'20250304-1-000015','60.00','admin','2025 03 04','  Cash','  Dine-in','60.00','0.00','0.00','0.0','457','202503041447',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(708,'20250304-1-000016','60.00','admin','2025 03 04','  Cash','  Dine-in','60.00','0.00','0.00','0.0','458','202503041533',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(709,'20250304-1-000017','35.00','admin','2025 03 04','  Cash','  Dine-in','35.00','0.00','0.00','0.0','459','202503041537',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(710,'20250304-1-000018','35.00','admin','2025 03 04','  Cash','  Dine-in','35.00','0.00','0.00','0.0','460','202503041547',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(711,'20250304-1-000019','35.00','admin','2025 03 04','  Cash','  Dine-in','35.00','0.00','0.00','0.0','461','202503041605',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(712,'20250304-1-0000110','70.00','admin','2025 03 04','  Cash','  Dine-in','70.00','0.00','0.00','0.0','462','202503041623',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(713,'20250304-1-0000111','100.00','admin','2025 03 04','  Cash','  Dine-in','100.0','0.00','0.0','0.0','463','202503042238',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(714,'20250304-1-0000112','35.00','admin','2025 03 04','  Cash','  Dine-in','35.0','0.00','0.0','0.0','464','202503042250',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(715,'20250304-1-0000113','105.00','admin','2025 03 04','  Cash','  Dine-in','105.0','0.00','0.0','0.0','465','202503042321',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(716,'20250305-1-000011','90.00','admin','2025 03 05','  Cash','  Dine-in','90.0','0.00','0.0','0.0','466','202503051224',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(717,'20250305-1-000012','25.50','admin','2025 03 05','  Cash','  Dine-in','25.50','0.50','0.00','0.0','467','202503051226',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(718,'20250305-1-000013','25.50','admin','2025 03 05','  Cash','  Dine-in','25.50','0.50','0.00','0.0','468','202503051228',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(719,'20250306-1-000011','37.70','admin','2025 03 06','  Cash','  Dine-in','37.70','0.00','0.00','0.0','469','202503061108',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(720,'20250306-1-000012','66.30','admin','2025 03 06','  Cash','  Dine-in','66.30','0.00','0.00','0.0','470','202503061108',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(721,'20250306-1-000013','76.50','admin','2025 03 06','  Cash','  Dine-in','76.50','0.00','0.00','0.0','471','202503061108',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(722,'20250306-1-000014','71.40','admin','2025 03 06','  Cash','  Dine-in','71.40','0.00','0.00','0.0','472','202503061108',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(723,'20250306-1-000015','66.30','admin','2025 03 06','  Cash','  Dine-in','66.30','0.60','0.00','0.0','473','202503061108',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(724,'20250306-1-000016','175.40','admin','2025 03 06','  Cash','  Dine-in','175.40','0.00','0.00','0.0','474','202503061109',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(725,'20250306-1-000017','209.10','admin','2025 03 06','  Cash','  Dine-in','209.10','1.30','0.00','0.0','475','202503061109',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(726,'20250306-1-000018','214.20','admin','2025 03 06','  Cash','  Dine-in','214.20','0.70','0.00','0.0','476','202503061109',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(727,'20250306-1-000019','170.30','admin','2025 03 06','  Cash','  Dine-in','170.30','0.60','0.00','0.0','477','202503061109',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(728,'20250306-1-0000110','270.30','admin','2025 03 06','  Cash','  Dine-in','270.30','4.10','0.00','0.0','478','202503061109',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(729,'20250306-1-0000111','188.70','admin','2025 03 06','  Cash','  Dine-in','188.70','2.50','0.00','0.0','479','202503061109',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(730,'20250306-1-0000112','382.50','admin','2025 03 06','  Cash','  Dine-in','382.50','7.50','0.00','0.0','480','202503061110',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(731,'20250306-1-0000113','642.60','admin','2025 03 06','  Cash','  Dine-in','642.60','10.20','0.00','0.0','481','202503061110',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(732,'20250306-1-0000114','816.00','admin','2025 03 06','  Cash','  Dine-in','816.00','11.40','0.00','0.0','482','202503061110',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(733,'20250306-1-0000115','515.10','admin','2025 03 06','  Cash','  Dine-in','515.10','9.20','0.00','0.0','483','202503061110',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(734,'20250306-1-0000116','153.00','admin','2025 03 06','  Cash','  Dine-in','153.00','3.00','0.00','0.0','484','202503061110',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(735,'20250306-1-0000117','153.00','admin','2025 03 06','  Cash','  Dine-in','153.00','2.30','0.00','0.0','485','202503061110',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(736,'20250306-1-0000118','165.04','admin','2025 03 06','  Cash','  Dine-in','165.04','1.60','0.00','0.0','486','202503061111',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(737,'20250306-1-000021','154.84','admin','2025 03 06','  Cash','  Dine-in','154.84','1.40','0.00','0.0','487','202503061111',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(738,'20250306-1-000041','314.16','admin','2025 03 06','  Cash','  Dine-in','314.16','3.30','0.00','0.0','488','202503061112',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(739,'20250306-1-000042','179.52','admin','2025 03 06','  Cash','  Dine-in','179.52','2.10','0.00','0.0','489','202503061112',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(740,'20250306-1-000043','292.34','admin','2025 03 06','  Cash','  Dine-in','292.34','2.50','0.00','0.0','490','202503061112',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(741,'20250306-1-000044','250.72','admin','2025 03 06','  Cash','  Dine-in','250.72','3.30','0.00','0.0','491','202503061113',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(742,'20250306-1-000045','344.72','admin','2025 03 06','  Cash','  Dine-in','344.72','2.30','0.00','0.0','492','202503061113',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(743,'20250306-1-000046','199.72','admin','2025 03 06','  Cash','  Dine-in','199.72','2.30','0.00','0.0','493','202503061115',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(744,'20250306-1-000047','199.72','admin','2025 03 06','  Cash','  Dine-in','199.72','2.30','0.00','0.0','494','202503061115',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(745,'20250310-1-000011','70.00','admin','2025 03 10','  Cash','  Dine-in','70.00','0.00','0.00','0.0','495','202503101026',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(746,'20250310-1-000012','60.00','admin','2025 03 10','  Cash','  Dine-in','60.00','0.00','0.00','0.0','496','202503101042',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(747,'20250310-1-000013','60.00','admin','2025 03 10','  Cash','  Dine-in','60.00','0.00','0.00','0.0','497','202503101112',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(748,'20250310-1-000041','357.00','admin','2025 03 10','  Cash','  Dine-in','357.00','4.60','0.00','0.0','498','202503101120',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(749,'20250310-1-000051','504.90','admin','2025 03 10','  Cash','  Dine-in','504.90','7.60','0.00','0.0','499','202503101120',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(750,'20250310-1-000032','198.90','admin','2025 03 10','  Cash','  Dine-in','198.90','3.00','0.00','0.0','500','202503101121',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(751,'20250310-1-000042','292.72','admin','2025 03 10','  Cash','  Dine-in','292.72','1.00','0.00','0.0','501','202503101121',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(752,'20250310-1-000043','270.30','admin','2025 03 10','  Cash','  Takeaway','270.30','3.00','0.00','0.0','502','202503101123',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(753,'20250310-1-000044','321.30','admin','2025 03 10','  Cash','  Dine-in','321.30','4.70','0.00','0.0','503','202503101123',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(754,'20250310-1-000045','321.30','admin','2025 03 10','  Cash','  Dine-in','321.30','5.40','0.00','0.0','504','202503101127',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(755,'20250310-1-000046','139.70','admin','2025 03 10','  Cash','  Dine-in','139.70','0.00','0.00','0.0','505','202503101127',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(756,'20250310-1-000047','277.40','admin','2025 03 10','  Cash','  Dine-in','277.40','1.30','0.00','0.0','506','202503101127',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(757,'20250310-1-000061','239.70','admin','2025 03 10','  Cash','  Dine-in','239.70','1.30','0.00','0.0','507','202503101127',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(758,'20250310-1-000071','372.30','admin','2025 03 10','  Cash','  Dine-in','372.30','6.10','0.00','0.0','508','202503101127',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(759,'20250310-1-000014','25.00','admin','2025 03 10','  Cash','  Dine-in','25.00','0.00','0.00','0.0','509','202503101133',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(760,'20250310-1-000015','25.00','admin','2025 03 10','  Cash','  Dine-in','25.00','0.00','0.00','0.0','510','202503101155',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(761,'20250310-1-000016','25.00','admin','2025 03 10','  Cash','  Dine-in','25.00','0.00','0.00','0.0','511','202503101155',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(762,'20250310-1-000017','35.00','admin','2025 03 10','  Cash','  Dine-in','35.00','0.00','0.00','0.0','512','202503101155',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(763,'20250310-1-000018','25.00','admin','2025 03 10','  Cash','  Dine-in','25.00','0.00','0.00','0.0','513','202503101221',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(764,'20250310-1-000019','35.00','admin','2025 03 10','  Cash','  Dine-in','35.00','0.00','0.00','0.0','514','202503101222',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(765,'20250310-1-0000110','35.00','admin','2025 03 10','  Cash','  Dine-in','35.00','0.00','0.00','0.0','515','202503101223',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(766,'20250310-1-0000111','35.00','admin','2025 03 10','  Cash','  Dine-in','35.00','0.00','0.00','0.0','516','202503101223',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(767,'20250310-1-0000112','35.00','admin','2025 03 10','  Cash','  Dine-in','35.00','0.00','0.00','0.0','517','202503101229',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(768,'20250310-1-0000113','35.00','admin','2025 03 10','  Cash','  Dine-in','35.00','0.00','0.00','0.0','518','202503101233',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(769,'20250310-1-0000114','35.00','admin','2025 03 10','  Cash','  Dine-in','35.00','0.00','0.00','0.0','519','202503101237',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(770,'20250310-1-0000115','35.00','admin','2025 03 10','  Cash','  Dine-in','35.00','0.00','0.00','0.0','520','202503101238',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(771,'20250326-1-000011','236.60','admin','2025 03 26','  Cash','  Dine-in','236.60','0.60','0.00','0.0','521','202503261035',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(772,'20250326-1-000021','241.70','admin','2025 03 26','  Cash','  Dine-in','241.70','0.60','0.00','0.0','522','202503261035',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(773,'20250326-1-000031','104.00','admin','2025 03 26','  Cash','  Dine-in','104.00','0.00','0.00','0.0','523','202503261035',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(774,'20250326-1-000032','295.80','admin','2025 03 26','  Cash','  Dine-in','295.80','3.90','0.00','0.0','524','202503261036',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(775,'20250326-1-000033','807.60','admin','2025 03 26','  Cash','  Dine-in','807.60','0.00','0.00','0.0','525','202503261036',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(776,'20250326-1-000041','912.90','admin','2025 03 26','  Cash','  Dine-in','912.90','14.40','0.00','0.0','526','202503261037',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(777,'20250326-1-000042','659.70','admin','2025 03 26','  Cash','  Dine-in','659.70','0.00','0.00','0.0','527','202503261038',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(778,'20250326-1-000051','1059.50','admin','2025 03 26','  Cash','  Dine-in','1059.50','7.80','0.00','0.0','528','202503261038',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(779,'20250326-1-000052','931.20','admin','2025 03 26','  Cash','  Dine-in','931.20','1.20','0.00','0.0','529','202503261039',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(780,'20250326-1-000053','985.32','admin','2025 03 26','  Cash','  Dine-in','985.32','10.80','0.00','0.0','530','202503261040',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(781,'20250326-1-000022','1254.60','admin','2025 03 26','  Cash','  Dine-in','1254.60','10.80','0.00','0.0','531','202503261040',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(782,'20250326-1-000034','611.80','admin','2025 03 26','  Cash','  Dine-in','611.80','8.30','0.00','0.0','532','202503261040',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(783,'20250401-1-000011','37.00','admin','2025 04 01','  Cash','  Dine-in','37.00','0.00','0.00','0.0','533','202504011755',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(784,'20250401-1-000012','41.00','admin','2025 04 01','  Cash','  Dine-in','41.00','0.00','0.00','0.0','534','202504011848',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(785,'20250408-1-000021','2.04','admin','2025 04 08','  Cheque','  Dine-in','2.04','0.00','0.00','0.0','535','202504081132',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(786,'20250408-1-000011','2.04','admin','2025 04 08','  Cheque','  Home delivery','2.04','0.00','0.00','0.0','536','202504081136',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(787,'20250408-1-000041','2.04','admin','2025 04 08','  Cash','  Takeaway','2.04','0.00','0.00','0.0','537','202504081138',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(788,'20250408-1-000031','2.04','admin','2025 04 08','  Cash','  Takeaway','2.04','0.00','0.00','0.0','538','202504081153',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(789,'20250408-1-000042','61.20','admin','2025 04 08','  Cash','  Dine-in','61.20','0.00','0.00','0.0','539','202504081700',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(790,'20250408-1-000012','76.50','admin','2025 04 08','  Cash','  Dine-in','76.50','0.00','0.00','0.0','540','202504081735',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(791,'20250409-1-000011','2.00','admin','2025 04 09','  Cash','  Dine-in','2.00','0.00','0.00','0.0','541','202504091255',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(792,'20250409-1-000012','2.00','admin','2025 04 09','  Cash','  Dine-in','2.00','0.00','0.00','0.0','542','202504091255',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(793,'20250409-1-000013','2.00','admin','2025 04 09','  Cash','  Dine-in','2.00','0.00','0.00','0.0','543','202504091256',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(794,'20250409-1-000014','37.70','admin','2025 04 09','  Cash','  Dine-in','37.70','0.00','0.00','0.0','544','202504091301',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(795,'20250409-1-000015','2.00','admin','2025 04 09','  Cash','  Dine-in','2.00','0.00','0.00','0.0','545','202504091301',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(796,'20250425-1-000011','35.70','admin','2025 04 25','  Cash','  Dine-in','35.70','0.00','0.00','0.0','546','202504252001',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(797,'20250425-1-000012','35.70','admin','2025 04 25','  Cash','  Dine-in','35.70','0.00','0.00','0.0','547','202504252001',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(798,'20250425-1-000013','35.70','admin','2025 04 25','  Cash','  Dine-in','35.70','0.00','0.00','0.0','548','202504252003',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(799,'20250426-1-000011','60.00','admin','2025 04 26','  Cash','  Dine-in','60.00','0.00','0.00','0.0','549','202504261336',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(800,'20250426-1-000012','60.00','admin','2025 04 26','  Cash','  Dine-in','60.00','0.00','0.00','0.0','550','202504261434',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(801,'20250426-1-000013','290.00','admin','2025 04 26','  Cash','  Dine-in','290.00','0.00','0.00','0.0','551','202504261451',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(802,'20250506-1-000011','25.00','admin','2025 05 06','  Cash','  Dine-in','25.00','0.00','0.00','0.0','552','202505061832',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(803,'20250514-1-000011','70.00','admin','2025 05 14','  Cash','  Dine-in','70.00','0.00','0.00','0.0','553','202505141857',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(804,'20250515-1-000011','25.00','admin','2025 05 15','  Cash','  Dine-in','25.00','0.00','0.00','0.0','554','202505151518',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(805,'20250515-1-000012','25.00','admin','2025 05 15','  Cash','  Dine-in','25.00','0.00','0.00','0.0','555','202505151543',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(806,'20250515-1-000013','25.00','admin','2025 05 15','  Cash','  Dine-in','25.00','0.00','0.00','0.0','556','202505151556',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(807,'20250515-1-000014','35.00','admin','2025 05 15','  Cash','  Dine-in','35.00','0.00','0.00','0.0','557','202505151620',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(808,'20250515-1-000015','25.00','admin','2025 05 15','  Cash','  Dine-in','25.00','0.00','0.00','0.0','558','202505151621',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(809,'20250515-1-000016','35.00','admin','2025 05 15','  Cash','  Dine-in','35.00','0.00','0.00','0.0','559','202505151655',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(810,'20250515-1-000017','61.20','admin','2025 05 15','  Cash','  Dine-in','61.20','1.20','0.00','0.0','560','202505151705',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(811,'20250515-1-000018','61.20','admin','2025 05 15','  Cash','  Dine-in','61.20','1.20','0.00','0.0','561','202505151759',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(812,'20250515-1-000019','61.20','admin','2025 05 15','  Cash','  Dine-in','61.20','1.20','0.00','0.0','562','202505151825',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(813,'20250515-1-0000110','35.70','admin','2025 05 15','  Cash','  Dine-in','35.70','0.70','0.00','0.0','563','202505151827',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(814,'20250516-1-000011','35.70','admin','2025 05 16','  Cash','  Dine-in','35.70','0.70','0.00','0.0','564','202505161145',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(815,'20250516-1-000012','35.70','admin','2025 05 16','  Cash','  Dine-in','35.70','0.70','0.00','0.0','565','202505161147',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(816,'20250516-1-000013','72.00','admin','2025 05 16','  Cash','  Dine-in','72.00','12.00','0.00','0.0','566','202505161230',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(817,'20250516-1-000014','42.00','admin','2025 05 16','  Cash','  Dine-in','42.00','7.00','0.00','0.0','567','202505161233',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(818,'20250516-1-000015','72.00','admin','2025 05 16','  Cash','  Dine-in','72.00','12.00','0.00','0.0','568','202505161720',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(819,'20250519-1-000011','66.00','admin','2025 05 19','  Cash','  Dine-in','66.00','6.00','0.00','0.0','569','202505191257',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(820,'20250526-1-000011','138.60','admin','2025 05 26','  Cash','  Dine-in','132.00','12.60','0.00','5.0','570','202505261124',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(821,'20250526-1-000012','69.30','admin','2025 05 26','  Cash','  Dine-in','66.00','6.30','0.00','5.0','571','202505261124',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(822,'20250526-1-000013','109.72','admin','2025 05 26','  Cash','  Dine-in','104.50','9.98','0.00','5.0','572','202505261125',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(823,'20250526-1-000014','98.18','admin','2025 05 26','  Cash','  Dine-in','93.50','8.93','0.00','5.0','573','202505261125',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(824,'20250526-1-000015','132.00','admin','2025 05 26','  Cash','  Dine-in','132.00','6.00','0.00','0.0','574','202505261126',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(825,'20250526-1-000016','93.50','admin','2025 05 26','  Cash','  Dine-in','93.50','4.25','0.00','0.0','575','202505261126',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(826,'20250526-1-000017','104.50','admin','2025 05 26','  Cash','  Dine-in','104.50','4.75','0.00','0.0','576','202505261127',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(827,'20250526-1-000018','66.00','admin','2025 05 26','  Cash','  Dine-in','66.00','3.00','0.00','0.0','577','202505261127',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(828,'20250526-1-000019','110.00','admin','2025 05 26','  Cash','  Dine-in','110.00','5.00','0.00','0.0','578','202505261128',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(829,'20250526-1-0000110','126.00','admin','2025 05 26','  Cash','  Dine-in','126.00','6.00','0.00','0.0','579','202505261143',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(830,'20250526-1-0000111','89.25','admin','2025 05 26','  Cash','  Dine-in','89.25','4.25','0.00','0.0','580','202505261143',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(831,'20250526-1-0000112','99.75','admin','2025 05 26','  Cash','  Dine-in','99.75','4.75','0.00','0.0','581','202505261144',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(832,'20250526-1-0000113','63.00','admin','2025 05 26','  Cash','  Dine-in','63.00','3.00','0.00','0.0','582','202505261144',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(833,'20250526-1-0000114','241.50','admin','2025 05 26','  Cash','  Dine-in','241.50','12.00','0.00','0.0','583','202505261259',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(834,'20250529-1-000011','265.13','admin','2025 05 29','  Cash','  Dine-in','265.13','13.25','0.00','0.0','584','202505291843',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(835,'20250529-1-000012','265.13','admin','2025 05 29','  Cash','  Dine-in','265.13','13.25','0.00','0.0','585','202505291845',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(836,'20250602-1-000011','56.71','admin','2025 06 02','  Cash','  Dine-in','56.71','2.50','0.00','0.0','586','202506021028',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(837,'20250602-1-000012','45.37','admin','2025 06 02','  Cash','  Dine-in','56.71','2.50','+ 0.00','0.0','587','202506021029',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(838,'20250602-1-000013','170.89','admin','2025 06 02','  Cash','  Dine-in','170.89','8.75','0.00','0.0','588','202506021612',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(839,'20250602-1-000014','62.99','admin','2025 06 02','  Cash','  Dine-in','67.99','3.50','0.00','0.0','589','202506021612',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(840,'20250602-1-000015','135.97','admin','2025 06 02','  Cash','  Dine-in','135.97','7.00','0.00','0.0','590','202506021612',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(841,'20250602-1-000016','90.25','admin','2025 06 02','  Cash','  Dine-in','90.25','5.25','0.00','0.0','591','202506021613',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(842,'20250602-1-000017','53.50','admin','2025 06 02','  Cash','  Dine-in','58.50','3.50','0.00','0.0','592','202506021615',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(843,'20250602-1-000018','58.50','admin','2025 06 02','  Cash','  Dine-in','58.50','3.50','0.00','0.0','593','202506021615',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(844,'20250602-1-000019','60.75','admin','2025 06 02','  Cash','  Dine-in','65.75','5.25','0.00','0.0','594','202506021618',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(845,'20250602-1-0000110','69.50','admin','2025 06 02','  Cash','  Dine-in','69.50','3.50','0.00','0.0','595','202506021619',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(846,'20250602-1-0000111','59.60','admin','2025 06 02','  Cash','  Dine-in','59.60','3.00','0.00','0.0','596','202506021620',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(847,'20250603-1-000011','126.60','admin','2025 06 03','  Cash','  Dine-in','126.60','6.00','0.00','0.0','597','202506031050',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(848,'20250603-1-000012','47.88','admin','2025 06 03','  Cash','  Dine-in','59.85','2.50','+ 0.00','0.0','598','202506031100',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(849,'20250603-1-000013','59.85','admin','2025 06 03','  Cash','  Dine-in','59.85','2.50','0.00','0.0','599','202506031100',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(850,'20250603-1-000014','59.85','admin','2025 06 03','  Cash','  Dine-in','59.85','3.50','0.00','0.0','600','202506031541',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(851,'20250603-1-000015','26.25','admin','2025 06 03','  Cash','  Dine-in','26.25','1.25','0.00','0.0','601','202506031542',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(852,'20250603-1-000016','24.94','admin','2025 06 03','  Cash','  Dine-in','24.94','1.25','0.00','0.0','602','202506031542',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(853,'20250603-1-000017','34.91','admin','2025 06 03','  Cash','  Dine-in','34.91','1.75','0.00','0.0','603','202506031543',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(854,'20250603-1-000018','24.94','admin','2025 06 03','  Cash','  Dine-in','24.94','1.25','0.00','0.0','604','202506031544',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(855,'20250603-1-000019','19.95','admin','2025 06 03','  Cash','  Dine-in','24.94','1.25','+ 0.00','0.0','605','202506031544',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(856,'20250603-1-0000110','27.93','admin','2025 06 03','  Cash','  Dine-in','34.91','1.75','+ 0.00','0.0','606','202506031544',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(857,'20250603-1-0000111','34.91','admin','2025 06 03','  Cash','  Dine-in','34.91','1.75','0.00','0.0','607','202506031808',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(858,'20250603-1-0000112','47.88','admin','2025 06 03','  Cash','  Dine-in','59.85','2.50','+ 0.00','0.0','608','202506031811',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(859,'20250603-1-0000113','69.75','admin','2025 06 03','  Cash','  Dine-in','69.75','4.75','0.00','0.0','609','202506031815',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(860,'20250603-1-0000114','66.26','admin','2025 06 03','  Cash','  Dine-in','66.26','4.50','0.00','0.0','610','202506031817',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(861,'20250606-1-000011','125.00','admin','2025 06 06','  Cash','  Dine-in','125.00','0.00','0.00','0.0','611','202506061130',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(862,'20250610-1-000011','284.80','admin','2025 06 10','  Cash','  Dine-in','289.80','37.80','0.00','0.0','612','202506101334',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(863,'20250610-1-000012','158.26','admin','2025 06 10','  Cash','  Dine-in','161.00','21.00','+ 0.00','0.0','613','202506101506',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(864,'20250610-1-000013','286.56','admin','2025 06 10','  Cash','  Dine-in','301.64','37.80','+ 0.00','0.0','614','202506101511',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(865,'20250610-1-000014','159.20','admin','2025 06 10','  Cash','  Dine-in','167.58','21.00','+ 0.00','0.0','615','202506101512',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(866,'20250611-1-000011','25.00','admin','2025 06 11','  Cash','  Dine-in','25.00','0.00','0.00','0.0','616','202506111428',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(867,'20250612-1-000011','25.00','admin','2025 06 12','  Cash','  Dine-in','25.00','0.00','0.00','0.0','617','202506121622',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(868,'20250612-1-000012','27.50','admin','2025 06 12','  Cash','  Dine-in','27.50','2.50','0.00','0.0','618','202506121750',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(869,'20250612-1-000013','35.00','admin','2025 06 12','  Cash','  Dine-in','35.00','0.00','0.00','0.0','619','202506121754',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(870,'20250612-1-000014','27.50','admin','2025 06 12','  Cash','  Dine-in','27.50','2.50','0.00','0.0','620','202506121754',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(871,'20250613-1-000011','27.50','admin','2025 06 13','  Cash','  Dine-in','27.50','2.50','0.00','0.0','621','202506131126',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(872,'20250613-1-000012','27.50','admin','2025 06 13','  Cash','  Dine-in','27.50','2.50','0.00','0.0','622','202506131917',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(873,'20250617-1-000011','67.50','admin','2025 06 17','  Cash','  Dine-in','67.50','2.50','0.00','0.0','623','202506171347',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(874,'20250617-1-000012','27.50','admin','2025 06 17','  Cash','  Dine-in','27.50','2.50','0.00','0.0','624','202506171347',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(875,'20250617-1-000013','27.50','admin','2025 06 17','  Cash','  Dine-in','27.50','2.50','0.00','0.0','625','202506171757',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(876,'20250618-1-000011','25.00','admin','2025 06 18','  Cash','  Dine-in','25.00','0.00','0.00','0.0','626','202506181830',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(877,'20250618-1-000012','50.00','admin','2025 06 18','  Cash','  Dine-in','50.00','0.00','0.00','0.0','627','202506181832',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(878,'20250618-1-000013','27.50','admin','2025 06 18','  Cash','  Dine-in','27.50','2.50','0.00','0.0','628','202506181833',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(879,'20250618-1-000014','55.00','admin','2025 06 18','  Cash','  Dine-in','55.00','5.00','0.00','0.0','629','202506181834',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(880,'20250618-1-000015','55.00','admin','2025 06 18','  Cash','  Dine-in','55.00','5.00','0.00','0.0','630','202506181837',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(881,'20250618-1-000016','55.00','admin','2025 06 18','  Cash','  Dine-in','55.00','5.00','0.00','0.0','631','202506181838',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(882,'20250618-1-000017','27.50','admin','2025 06 18','  Cash','  Dine-in','27.50','2.50','0.00','0.0','632','202506181839',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(883,'20250618-1-000018','55.00','admin','2025 06 18','  Cash','  Dine-in','55.00','5.00','0.00','0.0','633','202506181843',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(884,'20250618-1-000019','26.25','admin','2025 06 18','  Cash','  Dine-in','25.00','1.25','0.00','5.0','634','202506181849',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(885,'20250618-1-0000110','52.50','admin','2025 06 18','  Cash','  Dine-in','50.00','2.50','0.00','5.0','635','202506181849',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(886,'20250618-1-0000111','63.00','admin','2025 06 18','  Cash','  Dine-in','60.00','3.00','0.00','5.0','636','202506181849',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(887,'20250618-1-0000112','73.50','admin','2025 06 18','  Cash','  Dine-in','70.00','3.50','0.00','5.0','637','202506181849',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(888,'20250618-1-0000113','89.25','admin','2025 06 18','  Cash','  Dine-in','85.00','4.25','0.00','5.0','638','202506181856',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(889,'20250704-1-000011','60.64','admin','2025 07 04','  Cash','  Dine-in','57.75','5.64','0.00','5.0','639','202507041233',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(890,'20250704-1-000012','60.64','admin','2025 07 04','  Cash','  Dine-in','57.75','5.64','0.00','5.0','640','202507041243',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(891,'20250704-1-000013','104.74','user1','2025 07 04','  Cash','  Dine-in','99.75','9.74','0.00','5.0','641','202507041247',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(892,'20250704-1-000014','137.81','admin','2025 07 04','  Cash','  Dine-in','131.25','12.81','0.00','5.0','642','202507041252',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(893,'20250704-1-000015','131.25','admin','2025 07 04','  Cash','  Dine-in','131.25','6.25','0.00','0.0','643','202507041254',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(894,'20250704-1-000016','225.75','admin','2025 07 04','  Cash','  Dine-in','225.75','10.75','0.00','0.0','644','202507041403',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(895,'20250704-1-000017','28.88','admin','2025 07 04','  Cash','  Dine-in','57.75','2.75','+ 0.00','0.0','645','202507041403',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(896,'20250704-1-000018','68.25','admin','2025 07 04','  Cash','  Dine-in','68.25','3.25','0.00','0.0','646','202507041404',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(897,'20250704-1-000019','26.25','admin','2025 07 04','  Cash','  Dine-in','26.25','1.25','0.00','0.0','647','202507041429',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(898,'20250704-1-0000110','68.25','admin','2025 07 04','  Cash','  Dine-in','68.25','3.25','0.00','0.0','648','202507041600',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(899,'20250704-1-0000111','68.25','admin','2025 07 04','  Cash','  Dine-in','68.25','3.25','0.00','0.0','649','202507041600',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(900,'20250709-1-000011','68.25','admin','2025 07 09','  Cash','  Dine-in','68.25','3.25','0.00','0.0','650','202507091056',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(901,'20250709-1-000012','60.00','admin','2025 07 09','  Cash','  Dine-in','60.00','0.00','0.00','0.0','651','202507091746',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(902,'20250709-1-000013','25.00','admin','2025 07 09','  Cash','  Dine-in','25.00','0.00','0.00','0.0','652','202507091756',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(903,'20250710-1-000011','60.00','admin','2025 07 10','  Cash','  Dine-in','60.00','0.00','0.00','0.0','653','202507101002',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(904,'20250710-1-000012','25.00','admin','2025 07 10','  Cash','  Dine-in','25.00','0.00','0.00','0.0','654','202507101002',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(905,'20250710-1-000013','65.00','admin','2025 07 10','  Cash','  Dine-in','65.00','0.00','0.00','0.0','655','202507101003',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(906,'20250710-1-000014','65.00','admin','2025 07 10','  Cash','  Dine-in','65.00','0.00','0.00','0.0','656','202507101025',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(907,'20250710-1-000015','25.00','admin','2025 07 10','  Cash','  Dine-in','25.00','0.00','0.00','0.0','657','202507101032',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(908,'20250710-1-000021','35.00','admin','2025 07 10','  Cash','  Dine-in','35.00','0.00','0.00','0.0','658','202507101032',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(909,'20250710-1-000016','25.00','admin','2025 07 10','  Cash','  Dine-in','25.00','0.00','0.00','0.0','659','202507101034',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(910,'20250710-1-000017','60.00','admin','2025 07 10','  Cash','  Dine-in','60.00','0.00','0.00','0.0','660','202507101036',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(911,'20250710-1-000018','60.00','admin','2025 07 10','  Cash','  Dine-in','60.00','0.00','0.00','0.0','661','202507101037',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(912,'20250710-1-000019','70.00','admin','2025 07 10','  Cash','  Dine-in','70.00','0.00','0.00','0.0','662','202507101038',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(913,'20250710-1-0000110','130.00','admin','2025 07 10','  Cash','  Dine-in','130.00','0.00','0.00','0.0','663','202507101047',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(914,'20250710-1-0000111','65.00','admin','2025 07 10','  Cash','  Dine-in','65.00','0.00','0.00','0.0','664','202507101047',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(915,'20250711-1-000011','26.25','admin','2025 07 11','  Cash','  Dine-in','25.00','1.25','0.00','5.0','665','202507111750',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(916,'20250711-1-000012','162.75','admin','2025 07 11','  Cash','  Dine-in','155.00','7.75','0.00','5.0','666','202507111752',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(917,'20250711-1-000013','27.56','admin','2025 07 11','  Cash','  Dine-in','26.25','2.56','0.00','5.0','667','202507111754',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(918,'20250716-1-000011','63.00','admin','2025 07 16','  Cash','  Dine-in','60.00','3.00','0.00','5.0','668','202507161750',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(919,'20250730-1-000011','60.00','admin','2025 07 30','  Cash','  Dine-in','60.00','0.00','0.00','0.0','669','202507301322',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(920,'20250730-1-000012','60.00','admin','2025 07 30','  Cash','  Dine-in','60.00','0.00','0.00','0.0','670','202507301947',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(921,'20250807-1-000011','100.00','admin','2025 08 07','  Upiqr','  Dine-in','100.00','0.00','0.00','0.0','671','202508071807',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(922,'20250811-1-000011','25.00','admin','2025 08 11','  Upiqr','  Dine-in','25.00','0.00','0.00','0.0','672','202508111108',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(923,'20250811-1-000012','65.00','admin','2025 08 11','  Upiqr','  Dine-in','65.00','0.00','0.00','0.0','673','202508111108',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(924,'20250812-1-000011','1.00','admin','2025 08 12','  Cash','  Dine-in','1.00','0.00','0.00','0.0','674','202508121814',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(925,'20250902-1-000011','75.00','admin','2025 09 02','  Cash','  Dine-in','75.00','0.00','0.00','0.0','675','202509021428',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(926,'20250915-1-000011','25.00','admin','2025 09 15','  Cash','  Dine-in','25.00','0.00','0.00','0.0','676','202509151614',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(927,'20250915-1-000012','60.00','admin','2025 09 15','  Cash','  Home delivery','60.00','0.00','0.00','0.0','677','202509151621',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(930,'20251023-1-000013','60.00','admin','2025 10 23','  Cash','  Dine-in','60.00','0.00','0.00','0.0','680','202510231059',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(931,'20251023-1-000012','65.00','admin','2025 10 23','  Cash','  Dine-in','65.00','0.00','0.00','0.0','681','202510231443',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(932,'20251029-1-000011','60.00','admin','2025 10 29','  Cash','  Dine-in','60.00','0.00','0.00','0.0','682','202510291809',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(933,'20251029-1-000012','25.00','admin','2025 10 29','  Cash','  Dine-in','25.00','0.00','0.00','0.0','683','202510291809',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(934,'20251029-1-000013','25.00','admin','2025 10 29','  Cash','  Dine-in','25.00','0.00','0.00','0.0','684','202510291821',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(935,'20251104-000011','105.00','ladmin','2025 11 04','  Pay Later','  Home delivery','105.00','0.00','0.00','0.0','685','202511041256',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(936,'20251105-1-000011','190.00','ladmin','2025 11 05','  Upiqr','  Dine-in','190.00','0.00','0.00','0.0','686','202511051418',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(937,'20251105-1-000012','350.00','ladmin','2025 11 05','  Cash','  Dine-in','350.00','0.00','0.00','0.0','687','202511051419',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(938,'20251105-1-000013','350.00','ladmin','2025 11 05','  Card','  Dine-in','350.00','0.00','0.00','0.0','688','202511051421',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(939,'20251106-1-000011','25.00','User1','2025 11 06','  cash','  Dine-in','25.000000','0.000000','0.000000','0','689','20251106180008','','','','0','0',NULL,NULL,NULL,NULL,NULL),(940,'20251113-1-000011','60.00','admin','2025 11 13','  Cash','  Dine-in','60.00','0.00','0.00','0.0','690','202511130905',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(941,'20251117-1-000011','60.00','admin','2025 11 17','  Cash','  Dine-in','60.00','0.00','0.00','0.0','691','202511171606',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(942,'20251117-1-000012','60.00','admin','2025 11 17','  Cash','  Dine-in','60.00','0.00','0.00','0.0','692','202511171705',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(943,'20251126-1-000011','130.00','admin','2025 11 26','  Cash','  Dine-in','130.00','0.00','0.00','0.0','693','202511261412',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(944,'20251127-1-000011','25.00','admin','2025 11 27','  Cash','  Dine-in','25.00','0.00','0.00','0.0','694','202511271516',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(945,'20251212-1-000011','60.00','admin','2025 12 12','  Cash','  Dine-in','60.00','0.00','0.00','0.0','695','202512121245',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(946,'20251216-1-000022','115.00','admin','2025 12 16','  Cash','  Dine-in','115.00','0.00','0.00','0.0','696','202512161151',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(947,'20251216-1-000031','145.00','admin','2025 12 16','  Cash','  Dine-in','145.00','0.00','0.00','0.0','697','202512161227',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(948,'20251216-1-000011','78.75','admin','2025 12 16','  Cash','  Dine-in','75.00','3.75','0.00','5.0','698','202512161510',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(949,'20251216-1-000012','125.21','admin','2025 12 16','  Cash','  Dine-in','119.25','10.21','0.00','5.0','699','202512161511',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(950,'20251223-1-000011','66.15','admin','2025 12 23','  Cash','  Dine-in','63.00','6.15','0.00','5.0','700','202512231132',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(951,'20260105-1-000011','108.15','admin','2026 01 05','  Cash','  Dine-in','103.00','8.15','0.00','5.0','701','202601051805',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(952,'20260105-1-000012','69.56','admin','2026 01 05','  Cash','  Dine-in','66.25','4.56','0.00','5.0','702','202601051807',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(953,'20260105-1-000013','139.65','admin','2026 01 05','  Cash','  Dine-in','133.00','9.65','0.00','5.0','703','202601051810',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,'');
INSERT INTO `cancelwiseorderlistitems` (`_id`, `date`, `time`, `user`, `billno`, `sale`, `refund`, `reason`, `billcount`) VALUES (1,'04 Mar 2025','10:39:07 PM','admin','20250304-1-0000111','135.00','35.00','Damaged/Spoiled','463'),(2,'04 Mar 2025','10:50:48 PM','admin','20250304-1-0000112','105.00','35.00','Delayed','464'),(3,'04 Mar 2025','11:02:38 PM','admin','20250304-1-0000112','70.00','35.00','Delayed','464'),(4,'04 Mar 2025','11:22:07 PM','admin','20250304-1-0000113','140.00','35.00','Delayed','465'),(5,'04 Mar 2025','11:22:07 PM','admin','20250304-1-0000113','140.00','35.00','Delayed',NULL),(6,'05 Mar 2025','12:24:57 PM','admin','20250305-1-000011','120.00','30.00','Damaged/Spoiled',NULL),(7,'12 May 2025','12:48:30 PM','admin','430-20250512-1-000011','10.00','-71.40','Damaged/Spoiled',NULL),(8,'12 May 2025','12:49:11 PM','admin','430-20250512-1-000012','10.00','2.00','Delayed',NULL),(9,'12 May 2025','12:49:11 PM','admin','430-20250512-1-000012','10.00','2.00','Delayed',NULL);
INSERT INTO `clicked_cust_name` (`_id`, `name`) VALUES (1,'');
INSERT INTO `cusotmer_activity_temp_top3` (`_id`, `name`, `phone_no`, `email`, `addr`, `total_amount`, `balance`, `discount_value`, `discount_type`, `approval_rate`) VALUES (2,'priynaka','7348842227','angadipriyanka97@gmail.com','bangalore',35,'0.0',NULL,NULL,NULL),(3,'Arun','9712512324','akshay3715@example.com','Bangalore',2,'0.0',NULL,NULL,NULL),(4,'Mohan','9752607894','david3850@example.com','Kumbakonam',2,'0.0',NULL,NULL,NULL),(5,'Vasanth','9733124265','dinesh1749@example.com','Bangalore',61,'0.0',NULL,NULL,NULL),(6,'Vignesh','9491901658','david2986@example.com','Salem',77,'0.0',NULL,NULL,NULL),(7,'Saravanan','9806456789','john4530@example.com','Trichy',2,'0.0',NULL,NULL,NULL),(8,'Mohan','9795319827','vasanth7232@example.com','Trichy',2,'0.0',NULL,NULL,NULL),(9,'Mani','8841412120','vasanth4397@example.com','Bangalore',68,'0.0',NULL,NULL,NULL),(10,'Karthick','9983655406','babu1845@example.com','Coimbatore',31,'0.0',NULL,NULL,NULL),(11,'rohith','9581497872','krrohith934@gmil.com','bangalore',28,'0.0',NULL,NULL,NULL);
INSERT INTO `customer_loyalty_points` (`_id`, `phoneno`, `points`) VALUES (2,'2345678906','2147483647');
INSERT INTO `discountdetails` (`_id`, `date`, `time`, `billno`, `Discountcodeno`, `Discount_percent`, `Billamount_rupess`, `Discount_rupees`, `date1`, `original_amount`, `billcount`, `datetimee_new`, `paymentmethod`) VALUES (1,NULL,NULL,'20241021-1-000011',NULL,'0',NULL,'0',NULL,NULL,NULL,NULL,NULL),(2,'2024 10 21','01:02:01 PM','20241021-1-000012','pushpanjali','50','12.50','12.50','21 Oct 2024','25.00',NULL,'202410211302',NULL),(3,'2024 11 04','03:21:28 PM','20241104-1-000016','pushpanjali','50','17.85','17.85','04 Nov 2024','35.70',NULL,'202411041521',NULL),(4,'2024 11 04','05:46:30 PM','20241104-1-000017','pushpanjali','50','17.85','17.85','04 Nov 2024','35.70',NULL,'202411041746',NULL),(5,NULL,NULL,'20241127-1-000011',NULL,'0',NULL,'0',NULL,NULL,NULL,NULL,NULL),(6,NULL,NULL,'20241127-1-000012',NULL,'0',NULL,'0',NULL,NULL,NULL,NULL,NULL),(7,NULL,NULL,'20241127-1-000013',NULL,'0',NULL,'0',NULL,NULL,NULL,NULL,NULL),(8,'2024 11 27','02:38:03 PM','20241127-1-000014','rty','1.82','270.00','5','27 Nov 2024','275.00',NULL,'202411271438',NULL),(9,'2025 03 20','11:58:23 am','20250320-1-000011','fgh','13.76','31.34','5','20 Mar 2025','36.34',NULL,'202503201158',NULL),(10,'2025 06 02','10:29:11 AM','20250602-1-000012','test','20','45.37','11.34','02 Jun 2025','56.71',NULL,'202506021029',NULL),(11,'2025 06 02','04:12:40 PM','20250602-1-000014','gu','7.35','62.99','5','02 Jun 2025','67.99',NULL,'202506021612',NULL),(12,'2025 06 02','04:15:00 PM','20250602-1-000017','abc','8.55','53.50','5','02 Jun 2025','58.50',NULL,'202506021615',NULL),(13,'2025 06 02','04:18:26 PM','20250602-1-000019','abd','7.60','60.75','5','02 Jun 2025','65.75',NULL,'202506021618',NULL),(14,'2025 06 03','11:00:38 AM','20250603-1-000012','hgy','20','47.88','11.97','03 Jun 2025','59.85','598','202506031100',NULL),(15,'2025 06 03','03:44:41 PM','20250603-1-000019','gg','20','19.95','4.99','03 Jun 2025','24.94',NULL,'202506031544',NULL),(16,'2025 06 03','03:44:58 PM','20250603-1-0000110','fgg','20','27.93','6.98','03 Jun 2025','34.91',NULL,'202506031544',NULL),(17,'2025 06 03','06:11:55 PM','20250603-1-0000112','vf','20','47.88','11.97','03 Jun 2025','59.85',NULL,'202506031811',NULL),(18,'2025 06 05','01:02:23 PM','430-20250605-1-000011','jcj','20','191.52','47.88','05 Jun 2025','239.40',NULL,'202506051302',NULL),(19,'2025 06 09','11:48:59 AM','430-20250609-1-000013','abd','8.62','52.98','5','09 Jun 2025','57.98',NULL,'202506091148',NULL),(20,'2025 06 09','12:08:04 PM','430-20250609-1-000015','abd','19.56','226.25','55','09 Jun 2025','281.25',NULL,'202506091208',NULL),(21,'2025 06 10','01:34:01 PM','20250610-1-000011','tt','1.73','284.80','5','10 Jun 2025','289.80',NULL,'202506101334',NULL),(22,'2025 06 10','03:06:32 PM','20250610-1-000012','yt','1.7','158.26','2.74','10 Jun 2025','161.00',NULL,'202506101506',NULL),(23,'2025 06 10','03:11:51 PM','20250610-1-000013','fg','5','286.56','15.08','10 Jun 2025','301.64',NULL,'202506101511',NULL),(24,'2025 06 10','03:12:25 PM','20250610-1-000014','fgc','5','159.20','8.38','10 Jun 2025','167.58',NULL,'202506101512',NULL),(25,'2025 07 04','02:03:55 PM','20250704-1-000017','pushpanjali','50','28.88','28.88','04 Jul 2025','57.75',NULL,'202507041403',NULL),(26,NULL,NULL,'20251106-1-000011',NULL,'0',NULL,'0',NULL,NULL,NULL,NULL,NULL);
INSERT INTO `expenses_sales` (`_id`, `expensename`, `price`, `category`, `counterperson_username`, `counterperson_name`, `date`, `time`, `datetimee_new`) VALUES (1,'auto','200','Transportation','madmin','madmin','17 Sep 2024','11:53 AM','202409171153'),(2,'test','50','Rent','madmin','madmin','24 Jan 2025','01:01 PM','202501241301'),(3,'test1','100','Transportation','madmin','madmin','25 January 2025','04:21 PM','202501251621'),(4,'test2','100','Rent','madmin','madmin','25 January 2025','04:36 PM','202501251636'),(5,'test3','100','Rent','madmin','madmin','25 January 2025','04:37 PM','202501251637'),(6,'test4','100','Rent','madmin','madmin','25 January 2025','05:35 PM','202501251735'),(7,'test','50','Utilities','User1','User1','04 Feb 2025','08:30 PM','202502042030'),(8,'<script>alert(\'XSS\')</script>','<script>alert(\'XSS\')</script>','Rent','madmin','madmin','11 June 2025','07:32 PM','202506111932');
INSERT INTO `foodready_items` (`kotno`, `type`) VALUES (3,'Takeaway');
INSERT INTO `itemdata` (`_id`, `itemname`, `total`) VALUES (1,'idly',3),(2,'dosa',145),(3,'idly',1),(4,'masal dosa',46),(5,'masal vada',20),(6,'onion dosa',35),(7,'pongal',94),(8,'upma',34),(9,'poori',70),(10,'rava dosa',35),(11,'samosa',20),(12,'sheekh kabab',80),(13,'uthappam',60),(14,'vada',20),(15,'grape juice',204),(16,'idly',6),(17,'lassi',76),(18,'lays chips',71),(19,'lime juice',61),(20,'masal dosa',163),(21,'masal puri',71),(22,'masal vada',40),(23,'masala chai',25),(24,'mutton biriyani',122),(25,'non veg thali',163),(26,'onion dosa',214),(27,'paneer butter masala',122),(28,'pani puri',142),(29,'pav bhajji',244),(30,'pongal',61),(31,'poori',214),(32,'rava dosa',71),(33,'rice',30),(34,'roti',15),(35,'samosa',81),(36,'senior ctz',25),(37,'sheekh kabab',326),(38,'soft drinks',30),(39,'tea',40),(40,'test11',224),(41,'test12',183),(42,'upma',122),(43,'uthappam',61),(44,'vada',40),(45,'vanilla icecream',392),(46,'veg biriyani',214),(47,'veg cutlet',163),(48,'veg thali',102),(49,'water',14);
INSERT INTO `itemwiseorderlistcategory` (`_id`, `itemno`, `categoryname`, `sales`, `salespercentage`, `itemtotalquan`) VALUES (1,NULL,'Tiffin',136,100,'5');
INSERT INTO `itemwiseorderlistitems` (`_id`, `itemno`, `itemname`, `sales`, `salespercentage`, `itemtotalquan`, `category`, `i_buying_price`, `mi_buying_price`, `i_cost_value`, `i_cost_percent`, `mi_cost_value`, `mi_cost_percent`, `barcode_value`) VALUES (1,'1','idly',3,100,'3',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(2,'2','dosa',145,33,'4','Tiffin',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(3,'1','idly',1,0,'1','Tiffin',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(4,'6','masal dosa',46,11,'1','Tiffin',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(5,'12','masal vada',20,5,'1','Snacks',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(6,'8','onion dosa',35,8,'1','Tiffin',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(7,'3','pongal',94,22,'3','Tiffin',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(8,'4','upma',34,8,'1','Tiffin',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(9,'5','poori',70,10,'2','Tiffin',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10,'9','rava dosa',35,5,'1','Tiffin',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(11,'13','samosa',20,3,'1','Snacks',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(12,'15','sheekh kabab',80,11,'1','Snacks',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(13,'10','uthappam',60,8,'2','Tiffin',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(14,'11','vada',20,3,'1','Snacks',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(15,'37','grape juice',204,3,'8','Drinks',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(16,'1','idly',6,0,'3','Tiffin',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(17,'36','lassi',76,1,'3','Drinks',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(18,'44','lays chips',71,1,'7','None',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(19,'35','lime juice',61,1,'4','Drinks',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(20,'6','masal dosa',163,3,'4','Tiffin',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(21,'19','masal puri',71,1,'2','Snacks',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(22,'12','masal vada',40,1,'2','Snacks',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(23,'33','masala chai',25,0,'1','Drinks',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(24,'25','mutton biriyani',122,2,'1','Main course',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(25,'24','non veg thali',163,3,'2','Main course',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(26,'8','onion dosa',214,3,'6','Tiffin',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(27,'28','paneer butter masala',122,2,'2','Main course',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(28,'16','pani puri',142,2,'4','Snacks',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(29,'17','pav bhajji',244,4,'4','Snacks',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(30,'3','pongal',61,1,'2','Tiffin',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(31,'5','poori',214,3,'6','Tiffin',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(32,'9','rava dosa',71,1,'2','Tiffin',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(33,'27','rice',30,1,'1','Main course',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(34,'26','roti',15,0,'1','Main course',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(35,'13','samosa',81,1,'4','Snacks',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(36,'49','senior ctz',25,0,'1','None',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(37,'15','sheekh kabab',326,5,'4','Snacks',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(38,'34','soft drinks',30,1,'3','Drinks',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(39,'32','tea',40,1,'2','Drinks',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(40,'42','test11',224,4,'11','Desserts',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(41,'43','test12',183,3,'9','Drinks',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(42,'4','upma',122,2,'4','Tiffin',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(43,'10','uthappam',61,1,'2','Tiffin',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(44,'11','vada',40,1,'2','Snacks',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(45,'38','vanilla icecream',392,6,'11','Desserts',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(46,'21','veg biriyani',214,3,'3','Main course',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(47,'18','veg cutlet',163,3,'4','Snacks',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(48,'23','veg thali',102,2,'2','Main course',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(49,'41','water',14,0,'14','None',NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO `notification` (`_id`, `query1`, `description`, `type1`, `table_no`, `kotno`, `itemname`, `qty_red`) VALUES (1,'Select * From items','test','test',NULL,NULL,NULL,NULL),(2,'DELETE FROM Table_items WHERE kotno = 2','delete','kot delete','1','2',NULL,NULL),(3,NULL,'quantity reduced','quantity reduced','1','1','idlt','1');
INSERT INTO `splitdata` (`_id`, `billnum`, `total`, `splittype`, `split1`, `split2`, `split3`) VALUES (1,'430-20250618-1-000011','26.25','Split bill by 2','13','13.25','');
INSERT INTO `top_category` (`_id`, `category`, `value`) VALUES (1,'Tiffin',3),(2,'Snacks',20),(3,'Tiffin',415),(4,'Tiffin',136),(5,'Tiffin',1),(6,'Tiffin',1),(7,'Tiffin',35),(8,'Tiffin',37),(9,'Tiffin',36),(10,'Tiffin',2),(11,'Tiffin',72),(12,'Tiffin',72),(13,'Tiffin',275),(14,'Snacks',260),(15,'Tiffin',460),(16,'None',220),(17,'Tiffin',87),(18,'None',115),(19,'Tiffin',108),(20,'Tiffin',85),(21,'Tiffin',73),(22,'None',90),(23,'Tiffin',681),(24,'Tiffin',1),(25,'Tiffin',1),(27,'Tiffin',440),(28,'Tiffin',440),(29,'Tiffin',440),(31,'Tiffin',680),(32,'Tiffin',90),(33,'Tiffin',115),(34,'Desserts',1452),(35,'Drinks',639),(36,'Main course',1196),(37,'None',310),(38,'Snacks',1549),(39,'Tiffin',1145),(40,'Tiffin',37),(43,'Tiffin',0),(46,'Tiffin',110),(48,'Tiffin',38),(49,'Tiffin',37),(53,'Tiffin',78),(54,'Tiffin',78),(55,'None',2),(63,'None',6),(69,'None',8),(70,'Tiffin',120),(81,'Desserts',40),(82,'Main course',844),(83,'None',14),(84,'Snacks',500),(85,'Tiffin',12517),(86,'Tiffin',133),(90,'Desserts',713),(91,'Drinks',306),(92,'Main course',844),(93,'None',945),(94,'Snacks',1174),(95,'Tiffin',7605),(118,'Desserts',713),(119,'Drinks',306),(120,'Main course',844),(121,'None',945),(122,'Snacks',1174),(123,'Tiffin',7775),(124,'Tiffin',230),(126,'Desserts',40),(127,'Main course',644),(128,'Snacks',439),(129,'Tiffin',1854),(131,'Desserts',40),(132,'Main course',644),(133,'Snacks',439),(134,'Tiffin',1854),(135,'Tiffin',1279),(136,'Tiffin',125),(137,'Tiffin',125),(139,'Tiffin',632),(144,'Desserts',40),(145,'Main course',644),(146,'Snacks',439),(147,'Tiffin',4247),(149,'Tiffin',640),(150,'Tiffin',786),(151,'Tiffin',856),(152,'Tiffin',930),(155,'Tiffin',251),(156,'Tiffin',251),(157,'Tiffin',662),(158,'Tiffin',1601),(159,'Tiffin',278),(160,'Tiffin',2416),(162,'Tiffin',55),(164,'Tiffin',55),(165,'Tiffin',95),(169,'Tiffin',122),(171,'Tiffin',122),(172,'Tiffin',122),(173,'Tiffin',78),(174,'Tiffin',262),(175,'Tiffin',400),(176,'Tiffin',730),(177,'Tiffin',991),(178,'Tiffin',68),(180,'Tiffin',150),(181,'Tiffin',275),(182,'Tiffin',685),(183,'Tiffin',10809),(184,'Tiffin',25),(185,'Tiffin',180),(186,'Tiffin',206),(187,'Tiffin',60),(188,'Tiffin',120),(190,'Tiffin',100),(192,'Tiffin',90),(193,'Tiffin',305),(194,'Tiffin',75),(195,'Tiffin',110),(196,'Tiffin',60),(198,'Tiffin',120),(199,'Tiffin',50),(201,'Tiffin',25),(202,'Tiffin',25),(203,'Tiffin',680),(211,'Tiffin',375);
INSERT INTO `top_reason` (`_id`, `reason`, `value`) VALUES (7,'Damaged/Spoiled',1),(8,'Delayed',3),(10,'Damaged/Spoiled',1),(11,'Damaged/Spoiled',1),(12,'Delayed',1),(15,'Damaged/Spoiled',1),(16,'Delayed',1),(23,'Damaged/Spoiled',3),(24,'Delayed',5),(35,'Damaged/Spoiled',3),(36,'Delayed',5),(37,'Damaged/Spoiled',1),(38,'Delayed',1),(39,'Damaged/Spoiled',1),(40,'Delayed',1),(44,'Damaged/Spoiled',1),(45,'Delayed',2),(48,'Damaged/Spoiled',3),(49,'Delayed',6);
INSERT INTO `usercancelleddata` (`_id`, `username`, `total`) VALUES (1,'admin',140);
INSERT INTO `userdata` (`_id`, `username`, `total`) VALUES (1,'admin',3),(2,'madmin',311),(3,'ladmin',995);
INSERT INTO `userwiseorderlistitems` (`_id`, `username`, `sales`, `salespercentage`) VALUES (1,'madmin',3,100),(2,'User1',104,11);
