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,'bread omlette','1.0','30.00','30.0','Item',NULL,NULL,'no',NULL,NULL,'20240209-1-000012','03:28:50 PM','2024 02 09','admin','  Dine-in','  Cash','102.50','102.5','10','Changed mind','30.75','09 Feb 2024','30.75','%','0','30.00','no','','202402091528',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL),(2,'Vanilla','1.0','100.00','100.00','Item',NULL,NULL,'no',NULL,NULL,'20250908-1-0000124','05:19:20 pm','2025 09 09','admin','  Dine-in','  Cash','300.00','300.0','58','Changed mind','300.00','09 Sep 2025','300.00','%','0','100.00','no','','202509091719',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','100.00','100.00'),(3,'Strawberry','1.0','100.00','100.00','Item',NULL,NULL,'no',NULL,NULL,'20250908-1-0000124','05:19:20 pm','2025 09 09','admin','  Dine-in','  Cash','300.00','300.0','59','Changed mind','300.00','09 Sep 2025','300.00','%','0','100.00','no','','202509091719',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','100.00','100.00'),(4,'Chocolate','1.0','100.00','100.00','Item',NULL,NULL,'no',NULL,NULL,'20250908-1-0000124','05:19:20 pm','2025 09 09','admin','  Dine-in','  Cash','300.00','300.0','60','Changed mind','300.00','09 Sep 2025','300.00','%','0','100.00','no','','202509091719',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','100.00','100.00'),(5,'Chocolate','1.0','100.00','100.00','Item',NULL,NULL,'no',NULL,NULL,'20250908-1-0000123','05:21:31 pm','2025 09 09','admin','  Dine-in','  Cash','100.00','100.0','57','Changed mind','100.00','09 Sep 2025','100.00','%','0','100.00','no','','202509091721',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','100.00','100.00'),(6,'Chocolate','2.0','100.00','200.0','Item',NULL,NULL,'no',NULL,NULL,'20250908-1-0000125','05:22:33 pm','2025 09 09','admin','  Dine-in','  Cash','100.00','500.0','61','Accidental charge','-200.00','09 Sep 2025','-200.00','%','0','200.00','no','','202509091722',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','200.00','100.00');
INSERT INTO `billcount` (`_id`, `value`) VALUES (1,'1');
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,'20230306-1-000021','70.00','admin','2023 03 06','  Cash','  Dine-in','70.00','0.00','0.00','0.0','1','202303061625',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(2,'20230309-1-000011','85.00','admin','2023 03 09','  Cash','  Dine-in','85.00','0.00','0.00','0.0','2','202303091113',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(3,'20230309-1-000012','55.00','admin','2023 03 09','  Upiqr','  Dine-in','55.00','0.00','0.00','0.0','3','202303091613',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(4,'20230309-1-000021','195.00','admin','2023 03 09','  Cash','  Dine-in','195.00','0.00','0.00','0.0','4','202303091619',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(5,'20230309-1-000013','90.00','admin','2023 03 09','  Cash','  Dine-in','90.00','0.00','0.00','0.0','5','202303091623',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(6,'20230310-1-000011','85.00','admin','2023 03 10','  Cash','  Dine-in','85.00','0.00','0.00','0.0','6','202303100947',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(7,'20230310-1-000012','85.00','admin','2023 03 10','  Cash','  Dine-in','85.00','0.00','0.00','0.0','7','202303101032',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(8,'20230310-1-000013','100.00','admin','2023 03 10','  Cash','  Dine-in','100.00','0.00','0.00','0.0','8','202303101219',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(9,'20230310-1-000014','60.00','admin','2023 03 10','  Card','  Dine-in','60.00','0.00','0.00','0.0','9','202303101358',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10,'20230310-1-000015','60.00','admin','2023 03 10','  Cash','  Dine-in','60.00','0.00','0.00','0.0','10','202303101405',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(11,'20230310-1-000021','95.00','admin','2023 03 10','  Cash','  Dine-in','95.00','0.00','0.00','0.0','11','202303101543',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(12,'20230310-1-000022','90.00','admin','2023 03 10','  Card','  Dine-in','90.00','0.00','0.00','0.0','12','202303101546',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(13,'20230311-1-000011','92.25','admin','2023 03 11','  Cash','  Dine-in','90.00','2.25','0.00','2.5','13','202303110014',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(14,'20230311-1-000021','112.75','admin','2023 03 11','  Cash','  Dine-in','110.00','2.75','0.00','2.5','14','202303111347',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(15,'20230313-1-000011','87.13','admin','2023 03 13','  Cash','  Dine-in','85.00','2.13','0.00','2.5','15','202303131128',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(16,'20230316-1-000011','107.50','admin','2023 03 16','  Pay Later','  Dine-in','100.00','7.50','0.00','7.5','16','202303161232',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(17,'20230316-1-000012','220.38','admin','2023 03 16','  Cash','  Dine-in','205.00','15.38','0.00','7.5','17','202303161354',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(18,'20230316-1-000021','263.38','admin','2023 03 16','  Cash','  Dine-in','245.00','18.38','0.00','7.5','18','202303161355',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(19,'20230316-1-000013','43.00','admin','2023 03 16','  Cash','  Dine-in','40.00','3.00','0.00','7.5','19','202303161403',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(20,'20230316-1-000014','107.50','admin','2023 03 16','  Cash','  Dine-in','100.00','7.50','0.00','7.5','20','202303161451',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(21,'20230316-1-000015','69.88','admin','2023 03 16','  Cash','  Dine-in','65.00','4.88','0.00','7.5','21','202303161453',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(22,'20230316-1-000016','123.63','admin','2023 03 16','  Cash','  Dine-in','115.00','8.63','0.00','7.5','22','202303161517',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(23,'20230316-1-000017','96.75','admin','2023 03 16','  Cash','  Dine-in','90.00','6.75','0.00','7.5','23','202303161524',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(24,'20230316-1-000018','451.50','admin','2023 03 16','  Cash','  Dine-in','420.00','31.50','0.00','7.5','24','202303161525',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(25,'20230316-1-000019','69.88','admin','2023 03 16','  Cash','  Dine-in','65.00','4.88','0.00','7.5','25','202303161600',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(26,'20230317-1-000011','64.50','admin','2023 03 17','  Cash','  Dine-in','60.00','4.50','0.00','7.5','26','202303171457',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(27,'20230317-1-000021','483.75','admin','2023 03 17','  Cash','  Dine-in','450.00','33.75','0.00','7.5','27','202303171503',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(28,'20230317-1-000022','118.25','admin','2023 03 17','  Pay Later','  Dine-in','110.00','8.25','0.00','7.5','28','202303171507',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(29,'20230320-1-000011','64.50','admin','2023 03 20','  Cash','  Dine-in','60.00','4.50','0.00','7.5','29','202303201148',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(30,'20230320-1-000012','94.60','admin','2023 03 20','  Cash','  Dine-in','88.00','6.60','0.00','7.5','30','202303202345',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(31,'20230327-1-000011','66.63','admin','2023 03 27','  Cash','  Dine-in','65.00','1.63','0.00','2.5','31','202303271935',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(32,'20230329-1-000011','256.92','admin','2023 03 29','  Cash','  Dine-in','215.00','41.92','0.00','19.5','32','202303291333',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(33,'20230329-1-000031','501.90','admin','2023 03 29','  Card','  Dine-in','420.00','81.90','0.00','19.5','33','202303291335',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(34,'20230401-1-000011','35.00','admin','2023 04 01','  Cash','  Dine-in','35.00','0.00','0.00','0.0','34','202304011649',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(35,'20230401-1-000012','50.00','admin','2023 04 01','  Cash','  Dine-in','50.00','0.00','0.00','0.0','35','202304011650',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(36,'20230401-1-000013','45.00','admin','2023 04 01','  Cash','  Dine-in','45.00','0.00','0.00','0.0','36','202304011651',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(37,'20230401-1-000014','50.00','admin','2023 04 01','  Cash','  Dine-in','50.00','0.00','0.00','0.0','37','202304011653',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(38,'20230403-1-000011','45.00','admin','2023 04 03','  Cash','  Dine-in','45.00','0.00','0.00','0.0','38','202304031222',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(39,'20230403-1-000012','35.00','admin','2023 04 03','  Cash','  Dine-in','35.00','0.00','0.00','0.0','39','202304031224',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(40,'20230403-1-000013','45.00','admin','2023 04 03','  Cash','  Dine-in','45.00','0.00','0.00','0.0','40','202304031530',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(41,'20230403-1-000014','35.00','admin','2023 04 03','  Cash','  Dine-in','35.00','0.00','0.00','0.0','41','202304031545',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(42,'20230403-1-000015','60.00','admin','2023 04 03','  Cash','  Dine-in','60.00','0.00','0.00','0.0','42','202304031552',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(43,'20230405-1-000011','50.00','admin','2023 04 05','  Cash','  Dine-in','50.00','0.00','0.00','0.0','43','202304051530',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(44,'20230405-1-000012','35.00','admin','2023 04 05','  Cash','  Dine-in','35.00','0.00','0.00','0.0','44','202304051533',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(45,'20230405-1-000013','50.00','admin','2023 04 05','  Cash','  Dine-in','50.00','0.00','0.00','0.0','45','202304051556',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(46,'20230405-1-000014','100.00','admin','2023 04 05','  Cash','  Dine-in','100.00','0.00','0.00','0.0','46','202304051558',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(47,'20230405-1-000015','185.00','admin','2023 04 05','  Cash','  Dine-in','185.00','0.00','0.00','0.0','47','202304051602',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(48,'20230405-1-000016','65.00','admin','2023 04 05','  Cash','  Dine-in','65.00','0.00','0.00','0.0','48','202304051614',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(49,'20230405-1-000017','145.00','admin','2023 04 05','  Cash','  Dine-in','145.00','0.00','0.00','0.0','49','202304051616',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(50,'20230405-1-000018','105.00','admin','2023 04 05','  Cash','  Dine-in','105.00','0.00','0.00','0.0','50','202304051617',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(51,'20230405-1-000019','100.00','admin','2023 04 05','  Card','  Dine-in','100.00','0.00','0.00','0.0','51','202304051619',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(52,'20230406-1-000011','10.00','ladmin','2023 04 06','  Cash','  Dine-in','10.00','0.00','0.00','0.0','52','202304061737',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(53,'20230415-1-000011','120.00','admin','2023 04 15','  Cash','  Dine-in','120.00','0.00','0.00','0.0','53','202304151534',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(54,'20230415-1-000012','280.00','admin','2023 04 15','  Cash','  Dine-in','280.00','0.00','0.00','0.0','54','202304151727',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(55,'20230415-1-000013','175.00','admin','2023 04 15','  Cash','  Dine-in','175.00','0.00','0.00','0.0','55','202304151729',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(56,'20230417-1-000021','140.00','admin','2023 04 17','  Cash','  Dine-in','140.00','0.00','0.00','0.0','56','202304171433',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(57,'20230417-1-000011','180.00','admin','2023 04 17','  Cash','  Dine-in','180.00','0.00','0.00','0.0','57','202304171433',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(58,'20230417-1-000012','90.00','admin','2023 04 17','  Cash','  Dine-in','90.00','0.00','0.00','0.0','58','202304171437',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(59,'20230418-1-000011','50.00','admin','2023 04 18','  Cash','  Dine-in','50.00','0.00','0.00','0.0','59','202304181430',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(60,'20230419-1-000011','49.50','admin','2023 04 19','  Cash','  Dine-in','55.00','0.00','+ 0.00','0.0','60','202304191631',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(61,'20230423-1-000011','56.22','admin','2023 04 23','  Cash','  Dine-in','65.00','0.00','+ 0.00','0.0','61','202304231331',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(62,'20230516-1-000021','500.00','admin','2023 05 16','  Cash','  Dine-in','500.00','0.00','0.00','0.0','62','202305161500',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(63,'20230516-1-000022','205.00','admin','2023 05 16','  Cash','  Dine-in','205.00','0.00','0.00','0.0','63','202305161502',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(64,'20230516-1-000023','134.50','admin','2023 05 16','  Cash','  Dine-in','205.00','0.00','0.00','0.0','64','202305161503',NULL,NULL,NULL,'7.05','70.50',NULL,NULL,NULL,NULL,NULL),(65,'20230516-1-000024','169.13','admin','2023 05 16','  Pay Later','  Dine-in','165.00','4.13','0.00','2.5','65','202305161508',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(66,'20230517-1-000011','625.25','admin','2023 05 17','  Cash','  Dine-in','610.00','15.25','0.00','2.5','66','202305171532',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(67,'20230517-1-000021','240.88','admin','2023 05 17','  Cash','  Dine-in','235.00','5.88','0.00','2.5','67','202305171543',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(68,'20230517-1-000022','107.63','admin','2023 05 17','  Cash','  Dine-in','105.00','2.63','0.00','2.5','68','202305171605',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(69,'20230517-1-000023','143.50','admin','2023 05 17','  Pay Later','  Dine-in','140.00','3.50','0.00','2.5','69','202305171619',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(70,'20230519-1-000011','61.50','admin','2023 05 19','  Pay Later','  Dine-in','60.00','1.50','0.00','2.5','70','202305191148',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(71,'20230519-1-000012','92.25','admin','2023 05 19','  Pay Later','  Dine-in','90.00','2.25','0.00','2.5','71','202305191155',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(72,'20230519-1-000013','143.50','admin','2023 05 19','  Cheque','  Dine-in','140.00','3.50','0.00','2.5','72','202305191203',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(73,'20230519-1-000014','174.25','admin','2023 05 19','  Cash','  Dine-in','170.00','4.25','0.00','2.5','73','202305191206',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(74,'20230602-1-000011','307.50','admin','2023 06 02','  Cash','  Dine-in','300.00','7.50','0.00','2.5','74','202306021619',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(75,'20230602-1-000012','302.38','admin','2023 06 02','  Cash','  Dine-in','295.00','7.38','0.00','2.5','75','202306021620',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(76,'20230602-1-000013','215.25','admin','2023 06 02','  Cash','  Dine-in','210.00','5.25','0.00','2.5','76','202306021626',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(77,'20230602-1-000014','148.63','admin','2023 06 02','  Cash','  Dine-in','145.00','3.63','0.00','2.5','77','202306021631',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(78,'20230602-1-000015','77.95','admin','2023 06 02','  Cash','  Dine-in','90.00','2.25','0.00','2.5','78','202306021634',NULL,NULL,NULL,'1.43','14.30',NULL,NULL,NULL,NULL,NULL),(79,'20230602-1-000016','92.25','admin','2023 06 02','  Cash','  Dine-in','90.00','2.25','0.00','2.5','79','202306021635',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(80,'20230603-1-000011','46.13','admin','2023 06 03','  Cash','  Dine-in','45.00','1.13','0.00','2.5','80','202306031134',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(81,'20230619-1-000011','61.50','admin','2023 06 19','  Pay Later','  Dine-in','60.00','1.50','0.00','2.5','81','202306191255',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(82,'20230619-1-000012','78.42','admin','2023 06 19','  Pay Later','  Dine-in','85.00','2.13','+ 0.00','2.5','82','202306191300',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(83,'20230624-1-000011','68.68','admin','2023 06 24','  Cash','  Dine-in','67.00','1.67','0.00','2.5','83','202306241110',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(84,'20230705-1-000011','97.38','admin','2023 07 05','  Cash','  Dine-in','95.00','2.38','0.00','2.5','84','202307051115',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(85,'20230705-1-000012','76.88','admin','2023 07 05','  Cash','  Dine-in','75.00','1.88','0.00','2.5','85','202307051122',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(86,'20230707-1-000011','158.88','admin','2023 07 07','  Cash','  Dine-in','155.00','3.88','0.00','2.5','86','202307071215',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(87,'20230707-1-000012','158.88','admin','2023 07 07','  Cash','  Dine-in','155.00','3.88','0.00','2.5','87','202307071216',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(88,'20230707-1-000013','92.25','admin','2023 07 07','  Cash','  Dine-in','90.00','2.25','0.00','2.5','88','202307071217',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(89,'20230710-1-000011','92.25','admin','2023 07 10','  Cash','  Dine-in','90.00','2.25','0.00','2.5','89','202307101436',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(90,'20230808-1-000011','158.88','admin','2023 08 08','  Pay Later','  Dine-in','155.00','3.88','0.00','2.5','90','202308081105',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(91,'20230808-1-000012','225.50','admin','2023 08 08','  Pay Later','  Dine-in','220.00','5.50','0.00','2.5','91','202308081115',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(92,'20230904-1-000011','194.75','admin','2023 09 04','  Cash','  Dine-in','190.00','4.75','0.00','2.5','92','202309041148',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(93,'20230904-1-000012','276.75','admin','2023 09 04','  Cash','  Dine-in','270.00','6.75','0.00','2.5','93','202309041642',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(94,'20230908-1-000011','61.50','admin','2023 09 08','  Cash','  Dine-in','60.00','1.50','0.00','2.5','94','202309081738',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(95,'20231026-1-000011','128.13','admin','2023 10 26','  Cash','  Dine-in','125.00','3.13','0.00','2.5','95','202310261535',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(96,'20231102-1-000011','153.75','admin','2023 11 02','  Pay Later','  Takeaway','150.00','3.75','0.00','2.5','96','202311021544',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(97,'20231130-1-000021','199.88','admin','2023 11 30','  Cash','  Dine-in','195.00','4.88','0.00','2.5','97','202311301559',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(98,'20231130-1-000022','235.75','admin','2023 11 30','  Cash','  Dine-in','230.00','5.75','0.00','2.5','98','202311301600',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(99,'20231130-1-000023','112.75','admin','2023 11 30','  Cash','  Dine-in','110.00','2.75','0.00','2.5','99','202311301601',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(100,'20231201-1-000021','307.50','admin','2023 12 01','  Cash','  Dine-in','300.00','7.50','0.00','2.5','100','202312011343',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(101,'20231201-1-000031','235.75','admin','2023 12 01','  Cash','  Dine-in','230.00','5.75','0.00','2.5','101','202312011501',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(102,'20231218-1-000021','358.75','admin','2023 12 18','  Upiqr','  Dine-in','350.00','8.75','0.00','2.5','102','202312181036',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(103,'20231218-1-000011','92.25','admin','2023 12 18','  Pay Later','  Dine-in','90.00','2.25','0.00','2.5','103','202312181041',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(104,'20231218-1-000012','138.38','admin','2023 12 18','  Pay Later','  Dine-in','135.00','3.38','0.00','2.5','104','202312181044',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(105,'20231218-1-000022','527.88','admin','2023 12 18','  Upiqr','  Dine-in','515.00','12.88','0.00','2.5','105','202312181136',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(106,'20231218-1-000023','92.25','admin','2023 12 18','  Pay Later','  Dine-in','90.00','2.25','0.00','2.5','106','202312181138',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(107,'20231218-1-000013','92.25','Abc','2023 12 18','  Pay Later','  Dine-in','90.00','2.25','0.00','2.5','107','202312181228',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(108,'20231227-1-000011','92.25','admin','2023 12 27','  Cash','  Dine-in','90.00','2.25','0.00','2.5','108','202312271226',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(109,'20240104-1-000011','138.38','admin','2024 01 04','  Cash','  Dine-in','135.00','3.38','0.00','2.5','109','202401041230',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(110,'20240104-1-000012','92.25','admin','2024 01 04','  Cash','  Dine-in','90.00','2.25','0.00','2.5','110','202401041234',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(111,'20240104-1-000013','322.88','admin','2024 01 04','  Cash','  Dine-in','315.00','7.88','0.00','2.5','111','202401041356',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(112,'20240104-1-000014','169.13','admin','2024 01 04','  Cash','  Dine-in','165.00','4.13','0.00','2.5','112','202401041640',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(113,'20240108-1-000011','107.63','admin','2024 01 08','  Cash','  Dine-in','105.00','2.63','0.00','2.5','113','202401081245',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(114,'20240112-1-000011','169.13','admin','2024 01 12','  Cash','  Dine-in','165.00','4.13','0.00','2.5','114','202401121809',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(115,'20240122-1-000012','61.50','admin','2024 01 22','  Cash','  Dine-in','60.00','1.50','0.00','2.5','115','202401221237',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(116,'20240122-1-000021','630.38','admin','2024 01 22','  Cash','  Dine-in','615.00','15.38','0.00','2.5','116','202401221245',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(117,'20240131-1-000011','30.75','admin','2024 01 31','  Cash','  Dine-in','30.00','0.75','0.00','2.5','117','202401311225',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(118,'20240201-1-000011','133.25','admin','2024 02 01','  Cash','  Dine-in','130.00','3.25','0.00','2.5','118','202402011452',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(119,'20240201-1-000012','164.00','admin','2024 02 01','  Cash','  Dine-in','160.00','4.00','0.00','2.5','119','202402011453',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(120,'20240201-1-000013','138.38','admin','2024 02 01','  Cash','  Home delivery','135.00','3.38','0.00','2.5','120','202402011455',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(121,'20240207-1-000011','107.63','admin','2024 02 07','  Cash','  Dine-in','105.00','2.63','0.00','2.5','121','202402071641',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(122,'20240207-1-000012','133.25','admin','2024 02 07','  Cash','  Dine-in','130.00','3.25','0.00','2.5','122','202402071642',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(123,'20240209-1-000011','66.63','admin','2024 02 09','  Cash','  Dine-in','65.00','1.63','0.00','2.5','123','202402091519',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(124,'20240209-1-000012','71.75','admin','2024 02 09','  Cash','  Dine-in','70.0','1.75','0.0','2.5','124','202402091522',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(125,'20240209-1-000013','180.00','admin','2024 02 09','  Cash','  Dine-in','180.00','0.00','0.00','0.0','125','202402091544',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(126,'20240216-1-000011','60.00','admin','2024 02 16','  Cash','  Dine-in','60.00','0.00','0.00','0.0','126','202402161105',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(127,'20240216-1-000012','175.00','admin','2024 02 16','  Cash','  Dine-in','175.00','0.00','0.00','0.0','127','202402161106',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(128,'20240216-1-000013','1500.00','admin','2024 02 16','  Cash','  Dine-in','1500.00','0.00','0.00','0.0','128','202402161108',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(129,'20240220-1-000011','130.00','admin','2024 02 20','  Cash','  Dine-in','130.00','0.00','0.00','0.0','129','202402201359',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(130,'20240221-1-000011','135.00','admin','2024 02 21','  Cash','  Dine-in','135.00','0.00','0.00','0.0','130','202402211258',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(131,'20240221-1-000031','85.00','admin','2024 02 21','  Cash','  Dine-in','85.00','0.00','0.00','0.0','131','202402211309',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(132,'20240226-1-000011','175.50','admin','2024 02 26','  Cash','  Dine-in','195.00','0.00','+ 0.00','0.0','132','202402261240',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(133,'20240226-1-000012','126.00','admin','2024 02 26','  Cash','  Dine-in','140.00','0.00','+ 0.00','0.0','133','202402261240',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(134,'20240229-1-000011','65.00','admin','2024 02 29','  Cash','  Dine-in','65.00','0.00','0.00','0.0','134','202402291500',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(135,'20240305-1-000141','100.00','admin','2024 03 05','  Cash','  Dine-in','100.00','0.00','0.00','0.0','135','202403051716',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(136,'20240305-1-000011','115.00','admin','2024 03 05','  Cash','  Dine-in','115.00','0.00','0.00','0.0','136','202403051717',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(137,'20240307-1-000011','1885.00','admin','2024 03 07','  Cash','  Dine-in','1885.00','0.00','0.00','0.0','137','202403071205',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(138,'20240312-1-000011','330.00','admin','2024 03 12','  Cash','  Dine-in','330.00','0.00','0.00','0.0','138','202403121625',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(139,'20240313-1-000011','50.00','admin','2024 03 13','  Cash','  Dine-in','50.00','0.00','0.00','0.0','139','202403131322',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(140,'20240415-1-000011','2210.00','admin','2024 04 15','  Cash','  Dine-in','2000.00','210.00','0.00','0.0','140','202404151407',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(141,'20240419-1-000011','50.00','admin','2024 04 19','  Cash','  Dine-in','50.00','0.00','0.00','0.0','141','202404191201',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(142,'20240423-1-000011','50.00','admin','2024 04 23','  Cash','  Dine-in','50.00','0.00','0.00','0.0','142','202404231539',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(143,'20240514-1-000011','90.00','admin','2024 05 14','  Cash','  Dine-in','90.00','0.00','0.00','0.0','143','202405141116',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(144,'20240514-1-000012','140.00','admin','2024 05 14','  Cash','  Dine-in','140.00','0.00','0.00','0.0','144','202405141117',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(145,'20240514-1-000013','70.00','admin','2024 05 14','  Cash','  Dine-in','70.00','0.00','0.00','0.0','145','202405141118',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(146,'20240514-1-000014','135.00','admin','2024 05 14','  Cash','  Dine-in','135.00','0.00','0.00','0.0','146','202405141119',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(147,'20240514-1-000015','850.00','admin','2024 05 14','  Pay Later','  Dine-in','850.00','0.00','0.00','0.0','147','202405141139',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(148,'20240514-1-000016','320.00','admin','2024 05 14','  Cash','  Dine-in','320.00','0.00','0.00','0.0','148','202405141217',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(149,'20240725-000011','195.00','admin','2024 07 25','  Cheque','  Dine-in','195.00','0.00','0.00','0.0','2','202407251109',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(150,'20240725-000012','205.00','admin','2024 07 25','  Pay Later','  Dine-in','205.00','0.00','0.00','0.0','3','202407251112',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(151,'20240926-000011','315.00','admin','2024 09 26','  Cash','  Dine-in','315.00','0.00','0.00','0.0','2','202409261210',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(152,'20241123-1-000011','240.00','admin','2024 11 23','  Cash','  Dine-in','240.00','0.00','0.00','0.0','3','202411231513',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(153,'20241128-1-000011','90.00','admin','2024 11 28','  Cash','  Dine-in','90.00','0.00','0.00','0.0','4','202411281209',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(154,'20241128-1-000012','110.00','admin','2024 11 28','  Cash','  Dine-in','110.00','0.00','0.00','0.0','5','202411281210',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(155,'20241128-1-000013','80.00','admin','2024 11 28','  Cash','  Dine-in','80.00','0.00','0.00','0.0','6','202411281211',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(156,'20241203-1-000011','60.00','madmin','2024 12 03','  cash','  Dine-in','60.000000','0.000000','0.000000','0','7','202412031414','','','','0','0',NULL,NULL,NULL,NULL,NULL),(157,'20241203-1-000031','105.00','madmin','2024 12 03','  card','  Dine-in','105.000000','0.000000','0.000000','0','8','202412031415','','','','0','0',NULL,NULL,NULL,NULL,NULL),(158,'20241204-1-000013','35.00','admin','2024 12 04','  Cash','  Dine-in','35.00','0.00','0.00','0.0','9','202412041815',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(159,'20241204-1-000014','65.00','admin','2024 12 04','  Cash','  Dine-in','65.00','0.00','0.00','0.0','10','202412041817',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(160,'20241204-1-000015','100.00','admin','2024 12 04','  Cash','  Dine-in','100.00','0.00','0.00','0.0','11','202412041819',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(161,'20241204-1-000016','110.00','admin','2024 12 04','  Cash','  Dine-in','110.00','0.00','0.00','0.0','12','202412041822',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(162,'20241204-1-000017','175.00','admin','2024 12 04','  Cash','  Dine-in','175.00','0.00','0.00','0.0','13','202412041828',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(163,'20241204-1-000018','105.00','admin','2024 12 04','  Cash','  Dine-in','105.00','0.00','0.00','0.0','14','202412041831',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(164,'20241204-1-000019','140.00','admin','2024 12 04','  Cash','  Dine-in','140.00','0.00','0.00','0.0','15','202412041832',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(165,'20241206-1-000011','243.20','admin','2024 12 06','  Cash','  Dine-in','212.40','63.20','0.00','14.5','16','202412061622',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(166,'20241206-1-000012','359.92','admin','2024 12 06','  Cash','  Dine-in','314.34','56.92','0.00','14.5','17','202412061622',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(167,'20241206-1-000013','162.13','admin','2024 12 06','  Cash','  Dine-in','141.60','42.13','0.00','14.5','18','202412061638',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(168,'20250123-1-000011','74.43','admin','2025 01 23','  Cash','  Dine-in','65.00','9.43','0.00','14.5','19','202501231204',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(169,'20250123-1-000012','148.85','admin','2025 01 23','  Cash','  Dine-in','130.00','18.85','0.00','14.5','20','202501231204',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(170,'20250123-1-000013','68.70','admin','2025 01 23','  Cash','  Dine-in','60.00','8.70','0.00','14.5','21','202501231217',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(171,'20250418-1-000011','95.00','admin','2025 04 18','  Cash','  Dine-in','95.00','0.00','0.00','0.0','Swadpurna _2','202504181253',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(172,'20250422-1-000011','25.00','admin','2025 04 22','  Cash','  Dine-in','25.00','0.00','0.00','0.0','Swadpurna _3','202504221231',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(173,'20250422-1-000012','130.00','admin','2025 04 22','  Cash','  Dine-in','130.00','0.00','0.00','0.0','Swadpurna _4','202504221232',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(174,'20250422-1-000013','190.00','admin','2025 04 22','  Cash','  Dine-in','190.00','0.00','0.00','0.0','Swadpurna _5','202504221234',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(175,'20250423-1-000011','30.00','admin','2025 04 23','  Cash','  Dine-in','30.00','0.00','0.00','0.0','Swadpurna _6','202504231111',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(176,'20250428-1-000011','105.00','admin','2025 04 28','  Cash','  Dine-in','105.00','0.00','0.00','0.0','Swadpurna _7','202504281511',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(177,'20250428-1-000012','75.00','admin','2025 04 28','  Cash','  Dine-in','75.00','0.00','0.00','0.0','Swadpurna _8','202504281515',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(178,'20250428-1-000013','75.00','admin','2025 04 28','  Cash','  Dine-in','75.00','0.00','0.00','0.0','Swadpurna _9','202504281524',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(179,'20250428-1-000014','65.00','admin','2025 04 28','  Cash','  Dine-in','65.00','0.00','0.00','0.0','Swadpurna _10','202504281525',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(180,'20250428-1-000015','75.00','admin','2025 04 28','  Cash','  Dine-in','75.00','0.00','0.00','0.0','Swadpurna _11','202504281526',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(181,'20250428-1-000016','40.00','admin','2025 04 28','  Cash','  Dine-in','40.00','0.00','0.00','0.0','Swadpurna _12','202504281528',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(182,'20250428-1-000017','35.00','admin','2025 04 28','  Cash','  Dine-in','35.00','0.00','0.00','0.0','Swadpurna _13','202504281625',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(183,'20250428-1-000018','35.00','admin','2025 04 28','  Cash','  Dine-in','35.00','0.00','0.00','0.0','Swadpurna _14','202504281626',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(184,'20250428-1-000019','30.00','admin','2025 04 28','  Cash','  Dine-in','30.00','0.00','0.00','0.0','Swadpurna _15','202504281629',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(185,'20250428-1-0000110','35.00','admin','2025 04 28','  Cash','  Dine-in','35.00','0.00','0.00','0.0','Swadpurna _16','202504281629',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(186,'20250428-1-0000111','20.00','admin','2025 04 28','  Cash','  Dine-in','20.00','0.00','0.00','0.0','Swadpurna _17','202504281643',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(187,'20250502-1-000011','65.00','admin','2025 05 02','  Cash','  Dine-in','65.00','0.00','0.00','0.0','Swadpurna _18','202505021106',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(188,'20250502-1-000012','60.00','admin','2025 05 02','  Cash','  Takeaway','60.00','0.00','0.00','0.0','Swadpurna _19','202505021106',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(189,'20250502-1-000013','65.00','admin','2025 05 02','  Cash','  Home delivery','65.00','0.00','0.00','0.0','Swadpurna _20','202505021108',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(190,'20250502-1-000014','35.00','admin','2025 05 02','  Cash','  Dine-in','35.00','0.00','0.00','0.0','Swadpurna _21','202505021152',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(191,'20250502-1-000015','30.00','admin','2025 05 02','  Cash','  Dine-in','30.00','0.00','0.00','0.0','Swadpurna _22','202505021152',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(192,'20250502-1-000016','40.00','admin','2025 05 02','  Cash','  Dine-in','40.00','0.00','0.00','0.0','Swadpurna _23','202505021159',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(193,'20250505-1-000011','65.00','admin','2025 05 05','  Cash','  Dine-in','65.00','0.00','0.00','0.0','Swadpurna _24','202505051044',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(194,'20250505-1-000012','110.00','admin','2025 05 05','  Cash','  Dine-in','110.00','0.00','0.00','0.0','Swadpurna _25','202505051045',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(195,'20250505-1-000013','75.00','admin','2025 05 05','  Upiqr','  Dine-in','75.00','0.00','0.00','0.0','Swadpurna _26','202505051054',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(196,'20250509-1-000011','3600.00','admin','2025 05 09','  Cash','  Dine-in','3600.00','0.00','0.00','0.0','Swadpurna _27','202505091111',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(197,'20250509-1-000012','1200.00','admin','2025 05 09','  Cash','  Dine-in','1200.00','0.00','0.00','0.0','Swadpurna _28','202505091113',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(198,'20250509-1-000013','2400.00','admin','2025 05 09','  Cash','  Dine-in','2400.00','0.00','0.00','0.0','Swadpurna _29','202505091116',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(199,'20250509-1-000014','2800.00','admin','2025 05 09','  Cash','  Dine-in','2800.00','0.00','0.00','0.0','Swadpurna _30','202505091119',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(200,'20250509-1-000015','3600.00','admin','2025 05 09','  Cash','  Dine-in','3600.00','0.00','0.00','0.0','Swadpurna _31','202505091123',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(201,'20250509-1-000016','800.00','admin','2025 05 09','  Cash','  Dine-in','800.00','0.00','0.00','0.0','Swadpurna _32','202505091124',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(202,'20250510-1-000011','120.00','admin','2025 05 10','  Cash','  Dine-in','120.00','0.00','0.00','0.0','Swadpurna _33','202505101129',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(203,'20250514-1-000011','60.00','admin','2025 05 14','  Cash','  Dine-in','60.00','0.00','0.00','0.0','Swadpurna _34','202505141604',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(204,'20250514-1-000012','105.00','admin','2025 05 14','  Cash','  Dine-in','105.00','0.00','0.00','0.0','Swadpurna _35','202505141606',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(205,'20250514-1-000013','65.00','admin','2025 05 14','  Cash','  Dine-in','65.00','0.00','0.00','0.0','Swadpurna _36','202505141607',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(206,'20250514-1-000014','150.00','admin','2025 05 14','  Cash','  Dine-in','150.00','0.00','0.00','0.0','Swadpurna _37','202505141608',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(207,'20250514-1-000015','20.00','admin','2025 05 14','  Cash','  Dine-in','20.00','0.00','0.00','0.0','Swadpurna _38','202505141619',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(208,'20250514-1-000016','305.00','admin','2025 05 14','  Cash','  Dine-in','305.00','0.00','0.00','0.0','Swadpurna _39','202505141825',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(209,'20250514-1-000017','60.00','admin','2025 05 14','  Cash','  Dine-in','60.00','0.00','0.00','0.0','Swadpurna _40','202505141830',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(210,'20250515-1-000011','62.00','admin','2025 05 15','  Cash','  Dine-in','62.00','0.00','0.00','0.0','Swadpurna _41','202505151055',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(211,'20250515-1-000012','1200.00','admin','2025 05 15','  Cash','  Dine-in','1200.00','0.00','0.00','0.0','Swadpurna _42','202505151212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(212,'20250515-1-000013','20.00','admin','2025 05 15','  Cash','  Dine-in','20.00','0.00','0.00','0.0','Swadpurna _43','202505151214',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(213,'20250519-1-000011','55.00','admin','2025 05 19','  Cash','  Dine-in','55.00','0.00','0.00','0.0','Swadpurna _44','202505191131',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(214,'20250519-1-000012','60.00','admin','2025 05 19','  Cash','  Dine-in','60.00','0.00','0.00','0.0','Swadpurna _45','202505191135',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(215,'20250519-1-000013','27.00','user1','2025 05 19','  Cash','  Dine-in','27.00','0.00','0.00','0.0','Swadpurna _46','202505191137',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(216,'20250519-1-000014','45.00','admin','2025 05 19','  Cash','  Dine-in','45.00','0.00','0.00','0.0','Swadpurna _47','202505191137',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(217,'20250519-1-000015','75.00','user1','2025 05 19','  Cash','  Dine-in','75.00','0.00','0.00','0.0','Swadpurna _48','202505191152',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(218,'20250519-1-000016','65.00','admin','2025 05 19','  Cash','  Dine-in','65.00','0.00','0.00','0.0','Swadpurna _49','202505191153',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(219,'20250519-1-000017','65.00','user1','2025 05 19','  Cash','  Dine-in','65.00','0.00','0.00','0.0','Swadpurna _50','202505191202',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(220,'20250519-1-000018','75.00','user2','2025 05 19','  Cash','  Dine-in','75.00','0.00','0.00','0.0','Swadpurna _51','202505191204',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(221,'20250519-1-000019','65.00','user2','2025 05 19','  Cash','  Dine-in','65.00','0.00','0.00','0.0','Swadpurna _52','202505191219',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(222,'20250519-1-0000110','30.00','user1','2025 05 19','  Cash','  Dine-in','30.00','0.00','0.00','0.0','Swadpurna _53','202505191219',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(223,'20250519-1-0000111','40.00','admin','2025 05 19','  Cash','  Dine-in','40.00','0.00','0.00','0.0','Swadpurna _54','202505191221',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(224,'20250519-1-0000112','30.00','admin','2025 05 19','  Cash','  Dine-in','30.00','0.00','0.00','0.0','Swadpurna _55','202505191221',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(225,'20250519-1-0000113','40.00','user2','2025 05 19','  Cash','  Dine-in','40.00','0.00','0.00','0.0','Swadpurna _56','202505191222',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(226,'20250519-1-0000114','80.00','user2','2025 05 19','  Cash','  Dine-in','80.00','0.00','0.00','0.0','Swadpurna _57','202505191223',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(227,'20250519-1-0000115','100.00','user2','2025 05 19','  Cash','  Dine-in','100.00','0.00','0.00','0.0','Swadpurna _58','202505191225',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(228,'20250519-1-0000116','15.00','user2','2025 05 19','  Cash','  Dine-in','15.00','0.00','0.00','0.0','Swadpurna _59','202505191227',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(229,'20250521-1-000011','25.00','admin','2025 05 21','  Cash','  Dine-in','25.00','0.00','0.00','0.0','Swadpurna _60','202505211410',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(230,'20250521-1-000012','30.00','admin','2025 05 21','  Cash','  Dine-in','30.00','0.00','0.00','0.0','Swadpurna _61','202505211411',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(231,'20250521-1-000013','30.00','admin','2025 05 21','  Cash','  Dine-in','30.00','0.00','0.00','0.0','Swadpurna _62','202505211422',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(232,'20250521-1-000014','20.00','admin','2025 05 21','  Cash','  Dine-in','20.00','0.00','0.00','0.0','Swadpurna _63','202505211426',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(233,'20250521-1-000015','30.00','admin','2025 05 21','  Cash','  Dine-in','30.00','0.00','0.00','0.0','Swadpurna _64','202505211431',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(234,'20250521-1-000016','30.00','admin','2025 05 21','  Cash','  Dine-in','30.00','0.00','0.00','0.0','Swadpurna _65','202505211448',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(235,'20250521-1-000017','15.00','admin','2025 05 21','  Cash','  Dine-in','15.00','0.00','0.00','0.0','Swadpurna _66','202505211449',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(236,'20250522-1-000011','180.00','admin','2025 05 22','  Cash','  Dine-in','180.00','8.57','0.00','0.0','Swadpurna _67','202505221312',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(237,'20250522-1-000012','360.00','admin','2025 05 22','  Cash','  Dine-in','360.00','17.14','0.00','0.0','Swadpurna _68','202505221316',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(238,'20250522-1-000013','20.00','admin','2025 05 22','  Cash','  Dine-in','20.00','0.95','0.00','0.0','Swadpurna _69','202505221319',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(239,'20250522-1-000014','560.00','admin','2025 05 22','  Cash','  Dine-in','560.00','26.67','0.00','0.0','Swadpurna _70','202505221319',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(240,'20250526-1-000011','65.00','admin','2025 05 26','  Cash','  Dine-in','65.00','0.00','0.00','0.0','Swadpurna _71','202505261410',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(241,'20250526-1-000012','500.00','admin','2025 05 26','  Cash','  Dine-in','500.00','0.00','0.00','0.0','Swadpurna _72','202505261443',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(242,'20250526-1-000013','200.00','admin','2025 05 26','  Cash','  Dine-in','200.00','0.00','0.00','0.0','Swadpurna _73','202505261448',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(243,'20250526-1-000014','300.00','admin','2025 05 26','  Cash','  Dine-in','300.00','0.00','0.00','0.0','Swadpurna _74','202505261448',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(244,'20250526-1-000015','30.00','admin','2025 05 26','  Cash','  Dine-in','30.00','0.00','0.00','0.0','Swadpurna _75','202505261449',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(245,'20250528-1-000011','35.00','admin','2025 05 28','  Cash','  Dine-in','35.00','0.00','0.00','0.0','Swadpurna _76','202505280949',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(246,'20250528-1-000012','41.30','admin','2025 05 28','  Cash','  Dine-in','41.30','6.30','0.00','0.0','Swadpurna _77','202505281521',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(247,'20250529-1-000011','41.30','admin','2025 05 29','  Cash','  Dine-in','41.30','6.30','0.00','0.0','Swadpurna _78','202505291120',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(248,'20250529-1-000012','29.50','admin','2025 05 29','  Cash','  Dine-in','29.50','4.50','0.00','0.0','Swadpurna _79','202505291600',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(249,'20250529-1-000013','44.10','admin','2025 05 29','  Cash','  Dine-in','44.10','9.10','0.00','0.0','Swadpurna _80','202505291600',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(250,'20250530-1-000011','44.10','user1','2025 05 30','  Cash','  Dine-in','44.10','9.10','0.00','0.0','Swadpurna _81','202505301052',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(251,'20250530-1-000012','30.00','admin','2025 05 30','  Upiqr','  Dine-in','30.00','0.00','0.00','0.0','Swadpurna _82','202505301055',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(252,'20250530-1-000013','35.00','admin','2025 05 30','  Card','  Dine-in','35.00','0.00','0.00','0.0','Swadpurna _83','202505301057',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(253,'20250609-1-000011','110.00','admin','2025 06 09','  Cash','  Dine-in','110.00','0.00','0.00','0.0','Swadpurna _84','202506091136',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(254,'20250609-1-000012','100.00','admin','2025 06 09','  Cash','  Dine-in','100.00','0.00','0.00','0.0','Swadpurna _85','202506091419',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(255,'20250610-1-000011','164.10','admin','2025 06 10','  Cash','  Dine-in','164.10','9.10','0.00','0.0','Swadpurna _86','202506101059',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(256,'20250610-1-000012','70.00','admin','2025 06 10','  Pay Later','  Dine-in','70.00','0.00','0.00','0.0','Swadpurna _87','202506101456',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(257,'20250611-1-000011','100.00','admin','2025 06 11','  Cash','  Dine-in','100.00','0.00','0.00','0.0','Swadpurna _88','202506111117',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(258,'20250611-1-000012','150.00','admin','2025 06 11','  Cash','  Dine-in','150.00','0.00','0.00','0.0','Swadpurna _89','202506111119',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(259,'20250613-1-000011','75.00','admin','2025 06 13','  Cash','  Dine-in','75.00','0.00','0.00','0.0','Swadpurna _90','202506131535',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(260,'20250613-1-000012','75.00','admin','2025 06 13','  Cash','  Dine-in','75.00','0.00','0.00','0.0','Swadpurna _91','202506131536',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(261,'20250613-1-000013','1078.18','admin','2025 06 13','  Cash','  Dine-in','1197.98','57.05','+ 0.00','0.0','Swadpurna _92','202506131630',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(262,'20250613-1-000014','1078.18','admin','2025 06 13','  Cash','  Dine-in','1197.98','57.05','+ 0.00','0.0','Swadpurna _93','202506131637',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(263,'20250617-1-000011','65.00','admin','2025 06 17','  Cash','  Dine-in','65.00','0.00','0.00','0.0','Swadpurna _94','202506171156',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(264,'20250617-1-000012','35.00','admin','2025 06 17','  Cash','  Dine-in','35.00','0.00','0.00','0.0','Swadpurna _95','202506171207',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(265,'20250617-1-000013','140.00','user1','2025 06 17','  Cash','  Dine-in','140.00','0.00','0.00','0.0','Swadpurna _96','202506171242',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(266,'20250619-1-000011','65.00','madmin','2025 06 19','  upi','  Dine-in','65.000000','0.000000','0.000000','0','Swadpurna _97','20250619190001','','','','0','0',NULL,NULL,NULL,NULL,NULL),(267,'20250619-1-000012','150.00','madmin','2025 06 19','  upi','  Dine-in','150.000000','0.000000','0.000000','0','Swadpurna _98','20250619190004','','','','0','0',NULL,NULL,NULL,NULL,NULL),(268,'20250619-1-000013','100.00','madmin','2025 06 19','  Pay Later','  Dine-in','100.000000','0.000000','0.000000','0','Swadpurna _99','20250619190005','','','','0','0',NULL,NULL,NULL,NULL,NULL),(269,'20250628-1-000011','117.00','admin','2025 06 28','  Cash','  Dine-in','130.00','0.00','+ 0.00','0.0','Swadpurna _100','202506281004',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(270,'20250629-1-000011','94.50','admin','2025 06 29','  Cash','  Dine-in','105.00','0.00','+ 0.00','0.0','Swadpurna _101','202506291626',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(271,'20250701-1-000011','65.00','madmin','2025 07 01','  cash','  Dine-in','65.000000','0.000000','0.000000','0','Swadpurna _102','202507010953','','','','0','0',NULL,NULL,NULL,NULL,NULL),(272,'20250701-1-000111','90.00','madmin','2025 07 01','  cash','  Dine-in','90.000000','0.000000','0.000000','0','Swadpurna _103','202507011438','','','','0','0',NULL,NULL,NULL,NULL,NULL),(273,'20250701-1-000121','480.00','madmin','2025 07 01','  cash','  Dine-in','480.000000','0.000000','0.000000','0','Swadpurna _104','202507011523','','','','0','0',NULL,NULL,NULL,NULL,NULL),(274,'20250701-1-000012','35.00','admin','2025 07 01','  Cash','  Dine-in','35.00','0.00','0.00','0.0','Swadpurna _105','202507011800',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(275,'20250702-1-000011','120.00','admin','2025 07 02','  Cash','  Dine-in','120.00','0.00','0.00','0.0','Swadpurna _106','202507021448',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(276,'20250702-1-000012','140.00','admin','2025 07 02','  Cash','  Dine-in','140.00','0.00','0.00','0.0','Swadpurna _107','202507021450',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(277,'20250702-1-000013','65.00','admin','2025 07 02','  Cash','  Dine-in','65.00','0.00','0.00','0.0','Swadpurna _108','202507021455',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(278,'20250702-1-000014','25.00','admin','2025 07 02','  Cash','  Dine-in','25.00','0.00','0.00','0.0','Swadpurna _109','202507021456',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(279,'20250702-1-000015','35.00','admin','2025 07 02','  Cash','  Dine-in','35.00','0.00','0.00','0.0','Swadpurna _110','202507021456',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(280,'20250703-1-000011','60.00','admin','2025 07 03','  Card','  Dine-in','60.00','0.00','0.00','0.0','Swadpurna _111','202507031025',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(281,'20250703-1-000012','60.00','admin','2025 07 03','  Cash','  Dine-in','60.00','0.00','0.00','0.0','Swadpurna _112','202507031657',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(282,'20250703-1-000013','65.00','admin','2025 07 03','  Pay Later','  Dine-in','65.00','0.00','0.00','0.0','Swadpurna _113','202507031704',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(283,'20250704-1-000011','60.00','admin','2025 07 04','  Cash','  Dine-in','60.00','0.00','0.00','0.0','Swadpurna _114','202507041623',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(284,'20250704-1-000012','60.00','admin','2025 07 04','  Cash','  Dine-in','60.00','0.00','0.00','0.0','Swadpurna _115','202507041625',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(285,'20250704-1-000013','70.00','admin','2025 07 04','  Cash','  Dine-in','70.00','0.00','0.00','0.0','Swadpurna _116','202507041626',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(286,'20250704-1-000014','35.00','admin','2025 07 04','  Cash','  Dine-in','35.00','0.00','0.00','0.0','Swadpurna _117','202507041627',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(287,'20250704-1-000015','25.00','admin','2025 07 04','  Cash','  Dine-in','25.00','0.00','0.00','0.0','Swadpurna _118','202507041642',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(288,'20250704-1-000016','35.00','admin','2025 07 04','  Cash','  Dine-in','35.00','0.00','0.00','0.0','Swadpurna _119','202507041643',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(289,'20250705-1-000011','35.00','admin','2025 07 05','  Cash','  Dine-in','35.00','0.00','0.00','0.0','Swadpurna _120','202507051115',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(290,'20250705-1-000012','110.00','admin','2025 07 05','  Cash','  Dine-in','110.00','0.00','0.00','0.0','Swadpurna _121','202507051123',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(291,'20250705-1-000013','207.00','admin','2025 07 05','  Cash','  Dine-in','230.00','0.00','+ 0.00','0.0','Swadpurna _122','202507051429',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(292,'20250705-1-000111','105.00','madmin','2025 07 05','  cash','  Dine-in','105.000000','0.000000','0.000000','0','Swadpurna _123','202507051440','','','','0','0',NULL,NULL,NULL,NULL,NULL),(293,'20250707-1-000011','90.00','admin','2025 07 07','  Cash','  Dine-in','90.00','0.00','0.00','0.0','Swadpurna _124','202507071221',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(294,'20250707-1-000012','100.00','admin','2025 07 07','  Cash','  Dine-in','100.00','0.00','0.00','0.0','Swadpurna _125','202507071222',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(295,'20250707-1-000013','150.00','admin','2025 07 07','  Cash','  Dine-in','150.00','0.00','0.00','0.0','Swadpurna _126','202507071228',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(296,'20250707-1-000014','75.00','admin','2025 07 07','  Cash','  Dine-in','75.00','0.00','0.00','0.0','Swadpurna _127','202507071228',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(297,'20250707-1-000015','60.00','admin','2025 07 07','  Cash','  Dine-in','60.00','0.00','0.00','0.0','Swadpurna _128','202507071658',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(298,'20250707-1-000016','70.00','admin','2025 07 07','  Cash','  Dine-in','70.00','0.00','0.00','0.0','Swadpurna _129','202507071659',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(299,'20250707-1-000017','65.00','admin','2025 07 07','  Cash','  Dine-in','65.00','0.00','0.00','0.0','Swadpurna _130','202507071659',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(300,'20250709-1-000111','95.00','madmin','2025 07 09','  cash','  Dine-in','95.000000','0.000000','0.000000','0','Swadpurna _131','202507091115','','','','0','0',NULL,NULL,NULL,NULL,NULL),(301,'20250709-1-000112','85.00','madmin','2025 07 09','  cash','  Dine-in','85.000000','0.000000','0.000000','0','Swadpurna _132','202507091128','','','','0','0',NULL,NULL,NULL,NULL,NULL),(302,'20250709-1-000011','150.00','admin','2025 07 09','  Cash','  Dine-in','150.00','0.00','0.00','0.0','Swadpurna _133','202507091718',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(303,'20250710-1-000111','90.00','madmin','2025 07 10','  cash','  Takeaway','90.000000','0.000000','0.000000','0','Swadpurna _134','202507101528','','','','0','0',NULL,NULL,NULL,NULL,NULL),(304,'20250714-1-000011','150.00','admin','2025 07 14','  Cash','  Dine-in','150.00','0.00','0.00','0.0','Swadpurna _135','202507141545',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(305,'20250719-1-000011','51.00','admin','2025 07 19','  Cash','  Dine-in','51.00','0.00','0.00','0.0','Swadpurna _136','202507191140',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(306,'20250719-1-000012','325.00','admin','2025 07 19','  Cash','  Dine-in','325.00','0.00','0.00','0.0','Swadpurna _137','202507191354',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(307,'20250721-1-000011','90.00','admin','2025 07 21','  Cash','  Dine-in','90.00','0.00','0.00','0.0','Swadpurna _138','202507211229',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(308,'20250721-1-000012','120.00','admin','2025 07 21','  Cash','  Dine-in','120.00','0.00','0.00','0.0','Swadpurna _139','202507211234',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(309,'20250721-1-000013','115.00','admin','2025 07 21','  Cash','  Dine-in','115.00','0.00','0.00','0.0','Swadpurna _140','202507211236',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(310,'20250721-1-000014','70.00','admin','2025 07 21','  Cash','  Dine-in','70.00','0.00','0.00','0.0','Swadpurna _141','202507211418',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(311,'20250721-1-000015','40.00','admin','2025 07 21','  Cash','  Dine-in','40.00','0.00','0.00','0.0','Swadpurna _142','202507211420',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(312,'20250721-1-000016','65.00','admin','2025 07 21','  Cash','  Dine-in','65.00','0.00','0.00','0.0','Swadpurna _143','202507211446',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(313,'20250721-1-000017','65.00','admin','2025 07 21','  Cash','  Dine-in','65.00','0.00','0.00','0.0','Swadpurna _144','202507211449',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(314,'20250721-1-000018','60.00','admin','2025 07 21','  Cash','  Dine-in','60.00','0.00','0.00','0.0','Swadpurna _145','202507211449',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(315,'20250721-1-000019','70.00','admin','2025 07 21','  Upiqr','  Dine-in','70.00','0.00','0.00','0.0','Swadpurna _146','202507211454',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(316,'20250721-1-0000110','70.00','admin','2025 07 21','  Cash','  Dine-in','70.00','0.00','0.00','0.0','Swadpurna _147','202507211455',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(317,'20250721-1-0000111','40.00','admin','2025 07 21','  Cash','  Dine-in','40.00','0.00','0.00','0.0','Swadpurna _148','202507211504',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(318,'20250721-1-0000112','120.00','admin','2025 07 21','  Cash','  Dine-in','120.00','0.00','0.00','0.0','Swadpurna _149','202507211514',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(319,'20250722-1-000011','85.00','admin','2025 07 22','  Cash','  Dine-in','85.00','0.00','0.00','0.0','Swadpurna _150','202507221104',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(320,'20250722-1-000012','170.00','admin','2025 07 22','  Cash','  Dine-in','170.00','0.00','0.00','0.0','Swadpurna _151','202507221105',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(321,'20250722-1-000013','850.00','admin','2025 07 22','  Cash','  Dine-in','850.00','0.00','0.00','0.0','Swadpurna _152','202507221132',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(322,'20250724-1-000011','120.00','admin','2025 07 24','  Cash','  Dine-in','120.00','0.00','0.00','0.0','Swadpurna _153','202507241621',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(323,'20250724-1-000012','240.00','admin','2025 07 24','  Cash','  Dine-in','240.00','0.00','0.00','0.0','Swadpurna _154','202507241622',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(324,'20250724-1-000013','120.00','admin','2025 07 24','  Cash','  Dine-in','120.00','0.00','0.00','0.0','Swadpurna _155','202507241636',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(325,'20250724-1-000014','75.00','admin','2025 07 24','  Cash','  Dine-in','75.00','0.00','0.00','0.0','Swadpurna _156','202507241637',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(326,'20250725-1-000011','80.00','admin','2025 07 25','  Cash','  Dine-in','80.00','0.00','0.00','0.0','Swadpurna _157','202507251616',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(327,'20250725-1-000012','100.00','admin','2025 07 25','  Cash','  Dine-in','100.00','0.00','0.00','0.0','Swadpurna _158','202507251622',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(328,'20250729-1-000111','194.70','madmin','2025 07 29','  cash','  Takeaway','165.000000','29.700000','0.000000','29.7','Swadpurna _159','202507291111','','','','0','0',NULL,NULL,NULL,NULL,NULL),(329,'20250729-1-000011','35.00','Reshma ','2025 07 29','  Cash','  Dine-in','35.00','0.00','0.00','0.0','Swadpurna _160','202507291800',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(330,'20250729-1-000012','60.00','Reshma ','2025 07 29','  Cash','  Dine-in','60.00','0.00','0.00','0.0','Swadpurna _161','202507291804',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(331,'20250801-1-000011','1000.00','Reshma ','2025 08 01','  Cash','  Dine-in','1000.00','47.62','0.00','0.0','Swadpurna _162','202508011059',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(332,'20250802-1-000011','90.00','admin','2025 08 02','  Cash','  Dine-in','90.00','0.00','0.00','0.0','Swadpurna _163','202508021658',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(333,'20250802-1-000012','90.00','admin','2025 08 02','  Cash','  Takeaway','90.00','0.00','0.00','0.0','Swadpurna _164','202508021658',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(334,'20250802-1-000013','130.00','admin','2025 08 02','  Cash','  Takeaway','130.00','0.00','0.00','0.0','Swadpurna _165','202508021659',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(335,'20250802-1-000014','20.00','admin','2025 08 02','  Cash','  Takeaway','20.00','0.00','0.00','0.0','Swadpurna _166','202508021701',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(336,'20250802-1-000015','30.00','admin','2025 08 02','  Cash','  Takeaway','30.00','0.00','0.00','0.0','Swadpurna _167','202508021701',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(337,'20250802-1-000016','26.25','admin','2025 08 02','  Cash','  Takeaway','26.25','1.25','0.00','0.0','Swadpurna _168','202508021848',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(338,'20250804-1-000011','94.50','admin','2025 08 04','  Cash','  Takeaway','94.50','4.50','0.00','0.0','Swadpurna _169','202508041252',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(339,'20250804-1-000012','78.75','admin','2025 08 04','  Cash','  Takeaway','78.75','3.75','0.00','0.0','Swadpurna _170','202508041326',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(340,'20250804-1-000013','440.98','admin','2025 08 04','  Cash','  Takeaway','440.98','21.00','0.00','0.0','Swadpurna _171','202508041529',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(341,'20250805-1-000011','75.00','admin','2025 08 05','  Cash','  Takeaway','75.00','6.19','0.00','0.0','Swadpurna _172','202508051107',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(342,'20250805-1-000012','170.01','admin','2025 08 05','  Cash','  Takeaway','170.01','14.04','0.00','0.0','Swadpurna _173','202508051108',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(343,'20250820-1-000011','1300.00','admin','2025 08 20','  Cash','  Dine-in','1300.00','0.00','0.00','0.0','Swadpurna _174','202508201122',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(344,'20250820-1-000012','1000.00','admin','2025 08 20','  Cash','  Dine-in','1000.00','0.00','0.00','0.0','Swadpurna _175','202508201241',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(345,'20250820-1-000013','400.00','admin','2025 08 20','  Cash','  Dine-in','400.00','0.00','0.00','0.0','Swadpurna _176','202508201242',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(346,'20250820-1-000014','450.00','admin','2025 08 20','  Cash','  Dine-in','450.00','0.00','0.00','0.0','Swadpurna _177','202508201254',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(347,'20250820-1-000015','650.00','admin','2025 08 20','  Cash','  Dine-in','650.00','0.00','0.00','0.0','Swadpurna _178','202508201301',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(348,'20250828-1-000011','16.00','admin','2025 08 28','  Cash','  Dine-in','16.00','0.76','0.00','0.0','Swadpurna _179','202508281224',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(349,'20250829-1-000011','62.99','admin','2025 08 29','  Cash','  Dine-in','62.99','2.71','0.00','0.0','Swadpurna _180','202508291609',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(350,'20250829-1-000012','45.00','admin','2025 08 29','  Cash','  Dine-in','45.00','2.14','0.00','0.0','Swadpurna _181','202508291609',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(351,'20250829-1-000013','94.98','admin','2025 08 29','  Cash','  Dine-in','94.98','4.52','0.00','0.0','Swadpurna _182','202508291610',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(352,'20250829-1-000014','100.99','admin','2025 08 29','  Cash','  Dine-in','100.99','4.81','0.00','0.0','Swadpurna _183','202508291610',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(353,'20250829-1-000015','19.00','admin','2025 08 29','  Cash','  Dine-in','19.00','0.90','0.00','0.0','Swadpurna _184','202508291615',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(354,'20250904-1-000011','900.00','admin','2025 09 04','  Cash','  Dine-in','900.00','0.00','0.00','0.0','Swadpurna _185','202509041448',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(355,'20250904-1-000012','119.00','admin','2025 09 04','  Cash','  Dine-in','119.00','0.00','0.00','0.0','Swadpurna _186','202509041451',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(356,'20250904-1-000013','675.00','admin','2025 09 04','  Cash','  Dine-in','675.00','0.00','0.00','0.0','Swadpurna _187','202509041655',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(357,'20250906-1-000011','260.00','admin','2025 09 06','  Cash','  Dine-in','260.00','0.00','0.00','0.0','Swadpurna _188','202509061123',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(358,'20250906-1-000012','210.00','admin','2025 09 06','  Card','  Dine-in','210.00','0.00','0.00','0.0','Swadpurna _189','202509061123',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(359,'20250906-1-000013','150.00','admin','2025 09 06','  Upiqr','  Dine-in','150.00','0.00','0.00','0.0','Swadpurna _190','202509061123',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(360,'20250908-1-000011','115.00','admin','2025 09 08','  Cash','  Dine-in','115.00','0.00','0.00','0.0','Swadpurna _191','202509081018',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(361,'20250908-1-000012','3.50','admin','2025 09 08','  Cash','  Dine-in','140.00','0.00','0.00','0.0','Swadpurna _192','202509081019',NULL,NULL,NULL,'13.65','136.50',NULL,NULL,NULL,NULL,NULL),(362,'20250908-1-000013','300.00','admin','2025 09 08','  Cash','  Dine-in','300.00','0.00','0.00','0.0','Swadpurna _193','202509081019',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(363,'20250908-1-000014','1768.00','admin','2025 09 08','  Cash','  Dine-in','1768.00','408.00','0.00','0.0','Swadpurna _194','202509081020',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(364,'20250908-1-000015','500.00','admin','2025 09 08','  Cash','  Dine-in','500.00','0.00','0.00','0.0','Swadpurna _195','202509081026',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(365,'20250908-1-000016','300.00','admin','2025 09 08','  Cash','  Dine-in','300.00','0.00','0.00','0.0','Swadpurna _196','202509081026',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(366,'20250908-1-000017','100.00','admin','2025 09 08','  Cash','  Dine-in','100.00','0.00','0.00','0.0','Swadpurna _197','202509081029',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(367,'20250908-1-000018','1000.00','admin','2025 09 08','  Cash','  Dine-in','1000.00','0.00','0.00','0.0','Swadpurna _198','202509081051',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(368,'20250908-1-000019','500.00','admin','2025 09 08','  Cash','  Dine-in','500.00','0.00','0.00','0.0','Swadpurna _199','202509081052',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(369,'20250908-1-0000110','90.00','admin','2025 09 08','  Cash','  Dine-in','90.00','0.00','0.00','0.0','Swadpurna _200','202509081053',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(370,'20250908-1-0000111','100.00','admin','2025 09 08','  Cash','  Dine-in','100.00','0.00','0.00','0.0','Swadpurna _201','202509081127',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(371,'20250908-1-0000112','200.00','admin','2025 09 08','  Cash','  Dine-in','200.00','0.00','0.00','0.0','Swadpurna _202','202509081128',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(372,'20250908-1-0000113','500.00','admin','2025 09 08','  Cash','  Dine-in','500.00','0.00','0.00','0.0','Swadpurna _203','202509081129',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(373,'20250908-1-0000114','500.00','admin','2025 09 08','  Cash','  Dine-in','500.00','0.00','0.00','0.0','Swadpurna _204','202509081132',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(374,'20250908-1-0000115','35.00','admin','2025 09 08','  Cash','  Dine-in','200.00','0.00','0.00','0.0','Swadpurna _205','202509081203',NULL,NULL,NULL,'16.5','165.00',NULL,NULL,NULL,NULL,NULL),(375,'20250908-1-0000116','100.00','admin','2025 09 08','  Cash','  Dine-in','100.00','0.00','0.00','0.0','Swadpurna _206','202509081207',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(376,'20250908-1-0000117','100.00','admin','2025 09 08','  Cash','  Dine-in','100.00','0.00','0.00','0.0','Swadpurna _207','202509081214',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(377,'20250908-1-0000118','300.00','admin','2025 09 08','  Cash','  Dine-in','300.00','0.00','0.00','0.0','Swadpurna _208','202509081215',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(378,'20250908-1-0000119','604.50','admin','2025 09 08','  Cash','  Dine-in','1004.50','0.00','0.00','0.0','Swadpurna _209','202509081218',NULL,NULL,NULL,'4','400.00',NULL,NULL,NULL,NULL,NULL),(379,'20250908-1-0000120','100.00','admin','2025 09 08','  Cash','  Dine-in','100.00','0.00','0.00','0.0','Swadpurna _210','202509081225',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(380,'20250908-1-0000121','400.00','admin','2025 09 08','  Cash','  Dine-in','400.00','0.00','0.00','0.0','Swadpurna _211','202509081225',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(381,'20250908-1-0000122','1000.00','admin','2025 09 08','  Cash','  Dine-in','1000.00','0.00','0.00','0.0','Swadpurna _212','202509081226',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(382,'20250908-1-0000123','0','admin','2025 09 08','  Cash','  Dine-in','0.0','0.0','0.0','0.0','Swadpurna _213','202509081248',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(383,'20250908-1-0000124','0','admin','2025 09 08','  Cash','  Dine-in','0.0','0.0','0.0','0.0','Swadpurna _214','202509081248',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(384,'20250908-1-0000125','300.00','admin','2025 09 08','  Cash','  Dine-in','300.0','0.00','0.0','0.0','Swadpurna _215','202509081249',NULL,NULL,NULL,'4','400.00',NULL,NULL,NULL,NULL,NULL),(385,'20250911-1-000011','435.00','admin','2025 09 11','  Cash','  Dine-in','435.00','0.00','0.00','0.0','Swadpurna _216','202509111453',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(386,'20250911-1-000012','560.00','admin','2025 09 11','  Cash','  Dine-in','560.00','0.00','0.00','0.0','Swadpurna _217','202509111455',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(387,'20250911-1-000013','650.00','admin','2025 09 11','  Cash','  Dine-in','650.00','0.00','0.00','0.0','Swadpurna _218','202509111459',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(388,'20250911-1-000014','1133.00','admin','2025 09 11','  Cash','  Dine-in','1133.00','0.00','0.00','0.0','Swadpurna _219','202509111501',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(389,'20250911-1-000015','440.00','admin','2025 09 11','  Cash','  Dine-in','440.00','0.00','0.00','0.0','Swadpurna _220','202509111509',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(390,'20250911-1-000021','60.00','admin','2025 09 11','  Cash','  Dine-in','60.00','0.00','0.00','0.0','Swadpurna _221','202509111658',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(391,'20250912-1-000011','25.00','admin','2025 09 12','  Upiqr','  Dine-in','25.00','0.00','0.00','0.0','Swadpurna _222','202509121632',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(392,'20250917-1-000011','25.00','user2','2025 09 17','  Cash','  Dine-in','25.00','0.00','0.00','0.0','Swadpurna _223','202509171136',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(393,'20250917-1-000012','80.00','admin','2025 09 17','  Cash','  Dine-in','80.00','0.00','0.00','0.0','Swadpurna _224','202509171156',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(394,'20250917-1-000013','60.00','admin','2025 09 17','  Cash','  Dine-in','60.00','0.00','0.00','0.0','Swadpurna _225','202509171156',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(395,'20250917-1-000014','120.00','admin','2025 09 17','  Cash','  Dine-in','120.00','0.00','0.00','0.0','Swadpurna _226','202509171200',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(396,'20250917-1-000015','180.00','admin','2025 09 17','  Cash','  Dine-in','180.00','0.00','0.00','0.0','Swadpurna _227','202509171202',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(397,'20250917-1-000016','30.00','admin','2025 09 17','  Cash','  Dine-in','30.00','0.00','0.00','0.0','Swadpurna _228','202509171205',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(398,'20250923-1-000111','108.00','madmin','2025 09 23','  cash','  Dine-in','120.000000','0.000000','0.000000','0','Swadpurna _229','20250923120006','','','','0','0',NULL,NULL,NULL,NULL,NULL),(399,'20251004-1-000111','80.00','madmin','2025 10 04','  Pay Later','  Dine-in','80.000000','0.000000','0.000000','0','Swadpurna _230','202510041148','','','','0','0',NULL,NULL,NULL,NULL,NULL),(400,'20251004-1-000011','120.00','admin','2025 10 04','  Pay Later','  Dine-in','120.00','0.00','0.00','0.0','Swadpurna _231','202510041156',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(401,'20251004-1-000012','80.00','admin','2025 10 04','  Pay Later','  Dine-in','80.00','0.00','0.00','0.0','Swadpurna _232','202510041201',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(402,'20251004-1-000013','100.00','admin','2025 10 04','  Cash','  Dine-in','100.00','0.00','0.00','0.0','Swadpurna _233','202510041206',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(403,'20251004-1-000112','230.00','madmin','2025 10 04','  cash','  Dine-in','230.000000','0.000000','0.000000','0','Swadpurna _234','202510041211','','','','0','0',NULL,NULL,NULL,NULL,NULL),(404,'20251006-1-000012','150.00','admin','2025 10 06','  Cash','  Dine-in','150.00','0.00','0.00','0.0','Swadpurna _235','202510061622',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(405,'20251006-1-000013','330.00','admin','2025 10 06','  Cash','  Dine-in','330.00','0.00','0.00','0.0','Swadpurna _236','202510061626',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(406,'20251006-1-000014','54.00','admin','2025 10 06','  Cash','  Dine-in','54.00','0.00','0.00','0.0','Swadpurna _237','202510061627',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(407,'20251006-1-000015','140.00','admin','2025 10 06','  Cash','  Dine-in','140.00','0.00','0.00','0.0','Swadpurna _238','202510061657',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(408,'20251006-1-000016','165.00','admin','2025 10 06','  Cash','  Dine-in','165.00','0.00','0.00','0.0','Swadpurna _239','202510061700',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(409,'20251027-1-000011','340.00','admin','2025 10 27','  Cash','  Dine-in','340.00','0.00','0.00','0.0','Swadpurna _240','202510271144',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(410,'20251031-1-000011','270.00','admin','2025 10 31','  Cash','  Dine-in','270.00','0.00','0.00','0.0','Swadpurna _241','202510311125',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(411,'20251031-1-000012','240.00','admin','2025 10 31','  Cash','  Dine-in','240.00','0.00','0.00','0.0','Swadpurna _242','202510311126',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(412,'20251119-1-000011','80.00','user1','2025 11 19','  Cash','  Dine-in','80.00','0.00','0.00','0.0','Swadpurna _243','202511191432',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(413,'20251119-1-000012','70.00','admin','2025 11 19','  Upiqr','  Dine-in','70.00','0.00','0.00','0.0','Swadpurna _244','202511191433',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(414,'20251119-1-000012','70.00','admin','2025 11 19','  Upiqr','  Dine-in','70.00','0','0.00','0.0','Swadpurna _245','202511191433',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(415,'20251119-1-000012','70.00','admin','2025 11 19','  Upiqr','  Dine-in','70.00','0','0.00','0.0','Swadpurna _246','202511191433',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(416,'20251119-1-000012','70.00','admin','2025 11 19','  Upiqr','  Dine-in','70.00','0','0.00','0.0','Swadpurna _247','202511191434',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(417,'20251119-1-000016','234.00','admin','2025 11 19','  Cash','  Dine-in','260.00','0.00','+ 0.00','0.0','Swadpurna _248','202511191657',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(418,'20251120-1-000011','100.00','admin','2025 11 20','  Pay Later','  Dine-in','100.00','0.00','0.00','0.0','Swadpurna _249','202511201227',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(419,'20251121-1-000011','157.50','admin','2025 11 21','  Cash','  Dine-in','157.50','7.50','0.00','0.0','Swadpurna _250','202511211216',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(420,'20251121-1-000012','105.00','admin','2025 11 21','  Cash','  Dine-in','105.00','5.00','0.00','0.0','Swadpurna _251','202511211219',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(421,'20251121-1-000013','124.95','admin','2025 11 21','  Cash','  Dine-in','124.95','5.95','0.00','0.0','Swadpurna _252','202511211226',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(422,'20251121-1-000014','119.00','admin','2025 11 21','  Upiqr','  Dine-in','119.00','5.67','0.00','0.0','Swadpurna _253','202511211227',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(423,'20251122-1-000011','90.00','admin','2025 11 22','  Cash','  Dine-in','100.00','4.76','+ 0.00','0.0','Swadpurna _254','202511221316',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(424,'20251122-1-000012','100.00','admin','2025 11 22','  Cash','  Dine-in','100.00','4.76','0.00','0.0','Swadpurna _255','202511221317',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(425,'20251122-1-000013','500.00','admin','2025 11 22','  Cash','  Dine-in','500.00','23.81','0.00','0.0','Swadpurna _256','202511221341',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(426,'20251125-1-000011','105.84','user1','2025 11 25','  Cash','  Dine-in','117.60','6.00','+ 0.00','0.0','Swadpurna _257','202511251550',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(427,'20251125-1-000012','189.00','user2','2025 11 25','  Cash','  Dine-in','189.00','9.00','0.00','0.0','Swadpurna _258','202511251556',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(428,'20251125-1-000013','472.50','admin','2025 11 25','  Cash','  Dine-in','472.50','22.50','0.00','0.0','Swadpurna _259','202511251608',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(429,'20251126-1-000011','100.00','admin','2025 11 26','  Cash','  Dine-in','100.00','4.76','0.00','0.0','Swadpurna _260','202511261208',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(430,'20251126-1-000012','42.00','admin','2025 11 26','  Cash','  Dine-in','42.00','2.00','0.00','0.0','Swadpurna _261','202511261532',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(431,'20251126-1-000013','42.00','admin','2025 11 26','  Cash','  Dine-in','42.00','2.00','0.00','0.0','Swadpurna _262','202511261533',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(432,'20251201-1-000011','200.00','admin','2025 12 01','  Cash','  Dine-in','200.00','9.52','0.00','0.0','Swadpurna _263','202512011529',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(433,'20251201-1-000012','160.00','admin','2025 12 01','  Cash','  Dine-in','160.00','7.62','0.00','0.0','Swadpurna _264','202512011529',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(434,'20251202-1-000011','149.99','admin','2025 12 02','  Cash','  Dine-in','149.99','7.14','0.00','0.0','Swadpurna _265','202512021122',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(435,'20251202-1-000012','140.00','admin','2025 12 02','  Cash','  Dine-in','140.00','6.67','0.00','0.0','Swadpurna _266','202512021124',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(436,'20251202-1-000013','270.00','admin','2025 12 02','  Cash','  Dine-in','270.00','12.86','0.00','0.0','Swadpurna _267','202512021130',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(437,'20251208-1-000011','278.00','admin','2025 12 08','  Cash','  Dine-in','278.00','0.00','0.00','0.0','Swadpurna _268','202512081052',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(438,'20251209-1-000011','589.99','admin','2025 12 09','  Cash','  Dine-in','589.99','28.09','0.00','0.0','Swadpurna _269','202512091026',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(439,'20251212-1-000011','92.26','admin','2025 12 12','  Cash','  Dine-in','92.26','2.25','0.00','0.0','Swadpurna _270','202512121232',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(440,'20251212-1-000111','87.14','madmin','2025 12 12','  cash','  Dine-in','87.140000','2.130000','0.000000','0','Swadpurna _271','20251212130006','','','','0','0',NULL,NULL,NULL,NULL,NULL),(441,'20251217-1-000021','90.00','admin','2025 12 17','  Cash','  Dine-in','90.00','0.00','0.00','0.0','Swadpurna _272','202512171211',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(442,'20260106-1-000011','150.00','admin','2026 01 06','  Cash','  Dine-in','150.00','0.00','0.00','0.0','Swadpurna _273','202601061240',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(443,'20260106-1-000012','150.00','admin','2026 01 06','  Cash','  Dine-in','150.00','0.00','0.00','0.0','Swadpurna _274','202601061243',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(444,'20260106-1-000013','400.00','admin','2026 01 06','  Cash','  Dine-in','400.00','0.00','0.00','0.0','Swadpurna _275','202601061300',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(445,'20260106-1-000014','720.00','admin','2026 01 06','  Cash','  Dine-in','720.00','0.00','0.00','0.0','Swadpurna _276','202601061301',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(446,'20260106-1-000015','560.00','admin','2026 01 06','  Cash','  Dine-in','560.00','0.00','0.00','0.0','Swadpurna _277','202601061303',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(447,'20260106-1-000016','1000.00','admin','2026 01 06','  Cash','  Dine-in','1000.00','0.00','0.00','0.0','Swadpurna _278','202601061306',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(448,'20260106-1-000017','10.00','admin','2026 01 06','  Cash','  Dine-in','10.00','0.00','0.00','0.0','Swadpurna _279','202601061307',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(449,'20260107-1-000011','439.00','admin','2026 01 07','  Cash','  Dine-in','439.00','0.00','0.00','0.0','Swadpurna _280','202601071616',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(450,'20260107-1-000012','439.00','admin','2026 01 07','  Cash','  Dine-in','439.00','0.00','0.00','0.0','Swadpurna _281','202601071653',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(451,'20260122-1-000011','60.00','madmin','2026 01 22','  cash','  Dine-in','60.000000','0.000000','0.000000','0','Swadpurna _282','202601221040','','','','0','0',NULL,NULL,NULL,NULL,NULL),(452,'20260122-1-000012','40.00','admin','2026 01 22','  Cash','  Dine-in','40.00','0.00','0.00','0.0','Swadpurna _283','202601221431',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(453,'20260122-1-000013','150.00','admin','2026 01 22','  Cash','  Dine-in','150.00','0.00','0.00','0.0','Swadpurna _284','202601221807',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(454,'20260123-1-000011','110.00','admin','2026 01 23','  Cash','  Dine-in','110.00','0.00','0.00','0.0','Swadpurna _285','202601231935',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,'');
INSERT INTO `cancelwiseorderlistitems` (`_id`, `date`, `time`, `user`, `billno`, `sale`, `refund`, `reason`, `billcount`) VALUES (1,'09 Feb 2024','03:28:50 PM','admin','20240209-1-000012','102.50','30.75','Changed mind','124'),(2,'09 Sep 2025','05:21:31 pm','admin','20250908-1-0000123','100.00','100.00','Changed mind','Swadpurna _213'),(3,'09 Sep 2025','05:22:33 pm','admin','20250908-1-0000125','100.00','-200.00','Accidental charge','Swadpurna _215');
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,'Qwerasd','+449182173','asdd','Bangalore ',250,'0.0',NULL,NULL,'65.0'),(4,'Bbbbb','+449182173','assasss','Xyz',108,'107.0',NULL,NULL,'65.0'),(5,'Ccccv','9535123568','','',263,'0.0',NULL,NULL,NULL),(9,'Aaaaa','+449182173','assasss','Xyz',65,'222.0',NULL,NULL,'65.0'),(15,'Phani','9739981733','','',1009,'50.0',NULL,NULL,NULL),(16,'Ccccv','9535123568','','',144,'100.0',NULL,NULL,NULL),(35,'Reshma S','9535897598','','',415,'351.5',NULL,NULL,'46.7'),(39,'Abc','1234567890','','Halsuru',138,'53.0',NULL,NULL,NULL),(41,'Reshma S HASTHA Nakshatra','9535897598','','',50,'351.5',NULL,NULL,'46.7'),(42,'Aaaa','9953589759','','',850,'50.0',NULL,NULL,NULL),(46,'Hometest','+919535897598','','Bangalore ',65,'0.0',NULL,NULL,NULL),(47,'Reshma S','9535897598','','',275,'401.5',NULL,NULL,'46.7'),(49,'test','12345678','','',60,'0.0',NULL,NULL,NULL),(50,'Qqww','+919535897','','',65,'50.0',NULL,NULL,NULL),(51,'Aaaa','9953589759','','',110,'50.0',NULL,NULL,NULL),(52,'Sonu','9535759999','','',207,'20.0',NULL,NULL,'20.0'),(54,'Ccccv','9535123568','','',120,'100.0',NULL,NULL,NULL),(55,'Hometest','+919535897598','','Bangalore ',1300,'0.0',NULL,NULL,NULL),(56,'Reshma S','9535897598','','',415,'401.5',NULL,NULL,'46.7'),(57,'Hometest','+919535897598','','Bangalore ',1772,'0.0',NULL,NULL,NULL),(62,'Abcd','9164000275','','',100,'0.0',NULL,NULL,NULL),(63,'test','12345678','','',1590,'0.0',NULL,NULL,NULL),(66,'Abc','1234567890','','',1300,'53.0',NULL,NULL,NULL),(72,'Aks','9845684143','','Home.',1005,'0.0',NULL,NULL,NULL),(75,'Sham','6382055274','','TN',1500,'0.0',NULL,NULL,NULL),(79,'ABCD ','9535518252','','Bangalore ',500,'0.0',NULL,NULL,NULL),(87,'Abcd','9164000275','','',100,'50.0',NULL,NULL,NULL),(88,'Abcd','9164000275','','',90,'50.0',NULL,NULL,NULL),(89,'Reshma S','9535897598','','',100,'401.5',NULL,NULL,'46.7'),(92,'Sonu','9535759999','','',400,'20.0',NULL,NULL,'20.0'),(93,'Sonu','9535123456','','',1280,'0.0',NULL,NULL,'40.0'),(95,'Reshma S','9535897598','','',1000,'401.5',NULL,NULL,'46.7');
INSERT INTO `cust_feedback` (`_id`, `cust_name`, `date`, `time`, `ambience_rating`, `pro_qual_rating`, `service_rating`, `overall_exp_rating`, `comments`, `percentage`, `cust_phoneno`) VALUES (1,'Aaaaa','2023 03 09','04:14:34 pm','4.0','1.0','1.0','1.0','','35.0','+449182173'),(2,'Qwerasd','2023 03 09','04:21:07 pm','5.0','4.0','5.0','5.0','','95.0','+449182173'),(3,'Sonu','2023 03 17','03:04:20 pm','1.0','1.0','1.0','5.0','','40.0','9535123456'),(4,'','2023 03 20','11:46:05 pm','1.0','1.0','4.0','1.0','','35.0','+449182173'),(5,'Aarav','2023 04 23','01:32:32 pm','1.0','1.0','1.0','1.0','','20.0','9876543210'),(6,'Sonu','2023 05 19','12:04:03 pm','1.0','1.0','1.0','1.0','','20.0','9535759999'),(7,'Reshma S Cafe divine  1472--Cafe divine  GSTIN 10AYZPA2009A1Z7','2023 05 19','12:06:37 pm','5.0','5.0','5.0','5.0','','100.0','919535897598'),(8,'Reshma S Cafe divine  1472--Cafe divine  GSTIN 10AYZPA2009A1Z7','2023 06 02','04:20:13 pm','1.0','1.0','1.0','1.0','','20.0','919535897598'),(9,'Reshma S Cafe divine  1472--Cafe divine  GSTIN 10AYZPA2009A1Z7','2023 06 03','11:34:44 am','1.0','1.0','1.0','1.0','','20.0','919535897598');
INSERT INTO `customer_loyalty_points` (`_id`, `phoneno`, `points`) VALUES (1,'+449182173','18.88'),(2,'9739981733','3.04'),(3,'9535123568','1.98'),(4,'9953589759','11.55'),(5,'+919535897598','20.72'),(6,'9535897598','24.17'),(7,'12345678','1.35'),(8,'+919535897','0.65'),(9,'9535759999','6.07'),(10,'9164000275','2.90'),(11,'1234567890','13.00'),(12,'9845684143','6.05'),(13,'6382055274','15.00'),(14,'9535518252','1.00'),(15,'9876543200','3.00'),(16,'9535123456','12.80');
INSERT INTO `discountdetails` (`_id`, `date`, `time`, `billno`, `Discountcodeno`, `Discount_percent`, `Billamount_rupess`, `Discount_rupees`, `date1`, `original_amount`, `billcount`, `datetimee_new`, `paymentmethod`) VALUES (1,'2023 04 19','04:31:24 pm','20230419-1-000011','Disc10','10','49.50','5.50','19 Apr 2023','55.00',NULL,'202304191631',NULL),(2,'2023 04 23','01:31:42 pm','20230423-1-000011','Trial','13.5','56.22','8.77','23 Apr 2023','65.00',NULL,'202304231331',NULL),(3,'2023 06 19','01:00:56 pm','20230619-1-000012','Disc10','10','78.42','8.71','19 Jun 2023','87.13',NULL,'202306191300',NULL),(4,'2024 02 26','12:40:09 pm','20240226-1-000011','Disc10','10','175.50','19.50','26 Feb 2024','195.00',NULL,'202402261240',NULL),(5,'2024 02 26','12:40:22 pm','20240226-1-000012','Divali','10','126.00','14.00','26 Feb 2024','140.00',NULL,'202402261240',NULL),(6,NULL,NULL,'20241203-1-000011',NULL,'0',NULL,'0',NULL,NULL,NULL,'2024120302:14:49',NULL),(7,NULL,NULL,'20241203-1-000031',NULL,'0',NULL,'0',NULL,NULL,NULL,'2024120302:15:25',NULL),(8,'2025 06 13','04:30:54 pm','20250613-1-000013','Disc10','10','1078.18','119.80','13 Jun 2025','1197.98',NULL,'202506131630',NULL),(9,'2025 06 13','04:37:53 PM','20250613-1-000014','Disc10','10','1078.18','119.80','13 Jun 2025','1197.98',NULL,'202506131637',NULL),(10,NULL,NULL,'20250619-1-000011',NULL,'0',NULL,'0',NULL,NULL,NULL,'2025061907:001:34',NULL),(11,NULL,NULL,'20250619-1-000012',NULL,'0',NULL,'0',NULL,NULL,NULL,'2025061907:004:12',NULL),(12,NULL,NULL,'20250619-1-000013',NULL,'0',NULL,'0',NULL,NULL,NULL,'2025061907:005:003',NULL),(13,'2025 06 28','10:04:50 am','20250628-1-000011','Disc10','10','117.00','13.00','28 Jun 2025','130.00','Swadpurna _100','202506281004',NULL),(14,'2025 06 29','04:26:33 pm','20250629-1-000011','Disc10','10','94.50','10.50','29 Jun 2025','105.00','Swadpurna _101','202506291626',NULL),(15,NULL,NULL,'20250701-1-000011',NULL,'0',NULL,'0',NULL,NULL,NULL,'2025070109:53:28',NULL),(16,NULL,NULL,'20250701-1-000111',NULL,'0',NULL,'0',NULL,NULL,NULL,'2025070102:38:004',NULL),(17,NULL,NULL,'20250701-1-000121',NULL,'0',NULL,'0',NULL,NULL,NULL,'2025070103:23:31',NULL),(18,'2025 07 05','02:29:19 pm','20250705-1-000013','Disc10','10','207.00','23.00','05 Jul 2025','230.00',NULL,'202507051429',NULL),(19,NULL,NULL,'20250705-1-000111',NULL,'0',NULL,'0',NULL,NULL,NULL,'2025070502:40:50',NULL),(20,NULL,NULL,'20250709-1-000111',NULL,'0',NULL,'0',NULL,NULL,NULL,'2025070911:15:20',NULL),(21,NULL,NULL,'20250709-1-000112',NULL,'0',NULL,'0',NULL,NULL,NULL,'2025070911:28:35',NULL),(22,NULL,NULL,'20250710-1-000111',NULL,'0',NULL,'0',NULL,NULL,NULL,'2025071003:28:48',NULL),(23,NULL,NULL,'20250729-1-000111',NULL,'0',NULL,'0',NULL,NULL,NULL,'2025072911:11:006',NULL),(24,NULL,NULL,'20250923-1-000111',NULL,'10',NULL,'12',NULL,NULL,NULL,'2025092312:006:007',NULL),(25,NULL,NULL,'20251004-1-000111',NULL,'0',NULL,'0',NULL,NULL,NULL,'2025100411:48:002',NULL),(26,NULL,NULL,'20251004-1-000112',NULL,'0',NULL,'0',NULL,NULL,NULL,'2025100412:11:11',NULL),(27,'2025 11 19','04:57:25 pm','20251119-1-000016','Disc10','10','234.00','26.00','19 Nov 2025','260.00',NULL,'202511191657',NULL),(28,'2025 11 22','01:16:42 pm','20251122-1-000011','Disc10','10','90.00','10.00','22 Nov 2025','100.00',NULL,'202511221316',NULL),(29,'2025 11 25','03:50:16 pm','20251125-1-000011','Disc10','10','105.84','11.76','25 Nov 2025','117.60',NULL,'202511251550',NULL),(30,NULL,NULL,'20251212-1-000111',NULL,'0',NULL,'0',NULL,NULL,NULL,'2025121201:006:30',NULL),(31,NULL,NULL,'20260122-1-000011',NULL,'0',NULL,'0',NULL,NULL,NULL,'2026012210:40:12',NULL);
INSERT INTO `expenses_sales` (`_id`, `expensename`, `price`, `category`, `counterperson_username`, `counterperson_name`, `date`, `time`, `datetimee_new`) VALUES (1,'Power bill','20000','Maintenance','madmin','madmin','05 Jul 2025','11:19 AM','202507051119'),(2,'','','Rent','madmin','madmin','07 May 2025','03:18 PM','202505071518');
INSERT INTO `itemdata` (`_id`, `itemname`, `total`) VALUES (1,'dosa',35),(2,'poori',35),(3,'upma',30),(4,'masal dosa',40),(5,'onion dosa',35),(6,'pongal',90),(7,'poori',35),(8,'upma',60),(9,'rava dosa',35),(10,'upma',90),(11,'rava dosa',35),(12,'rice',30),(13,'samosa',40),(14,'sheekh kabab',80),(15,'upma',180),(16,'veg biriyani',70),(17,'veg thali',50),(18,'uthappam',30),(19,'vada',40),(20,'veg biriyani',140),(21,'veg thali',50),(22,'dhal fry',30),(23,'dosa',844),(24,'idly',179),(25,'lime juice',15),(26,'masal dosa',440),(27,'masal puri',35),(28,'masal vada',80),(29,'onion dosa',105),(30,'plain Tea Regular',24),(31,'plain Tea large',30),(32,'pongal',570),(33,'poori',280),(34,'rava dosa',70),(35,'roti',15),(36,'samosa',60),(37,'tea',40),(38,'uthappam',30),(39,'vada',40),(40,'vanilla icecream',70),(41,'veg cutlet',40),(42,'veg biriyani',70),(43,'veg cutlet',80),(44,'veg thali',50);
INSERT INTO `itemwiseorderlistcategory` (`_id`, `itemno`, `categoryname`, `sales`, `salespercentage`, `itemtotalquan`) VALUES (1,NULL,'Desserts',110,17,'3'),(2,NULL,'Drinks',60,9,'3'),(3,NULL,'Main course',170,26,'2'),(4,NULL,'Tiffin',280,42,'8'),(5,NULL,'Tiffin',1330,61,'39'),(6,NULL,'Tiffin',270,36,'8'),(7,NULL,'Tiffin',120,5,'4');
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,'850','idly',26,3,'1','Tiffin','11.875','0.0','11.9','45.2','0.0','0.0',''),(2,'851','dosa',74,9,'2','Tiffin','51.95652','2325.0','103.9','141.4','4650.0','6326.5',''),(3,'852','pongal',32,4,'1','Tiffin','51.42857','2325.0','51.4','163.3','4650.0','6326.5',''),(4,'853','dosa',74,9,'2','Tiffin','51.95652','4650.0','103.9','141.4','9300.0','12653.1',''),(5,'854','masal dosa',122,14,'2','Tiffin','NaN','6975.0','103.9','141.4','13950.0','11434.4',''),(6,'855','onion dosa',340,40,'2','Tiffin','NaN','9300.0','103.9','141.4','18600.0','5470.9',''),(7,'856','masal vada',21,2,'1','Snacks','NaN','9390.0','103.9','141.4','9390.0','44714.3',''),(8,'857','masal dosa',122,14,'2','Tiffin','NaN','11715.0','103.9','141.4','23430.0','19204.9',''),(9,'858','bread omlette',245,29,'2','Tiffin','25.0','14040.0','50.0','20.4','28080.0','11460.8',''),(10,'859','bread omlette',245,29,'2','Tiffin','25.0','16365.0','50.0','20.4','32730.0','13358.6',''),(11,'4','Hot Americano Regular',34,1,'2','HOT BASICS',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(12,'5','Hot Americano Upsize',56,1,'3','HOT BASICS',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(13,'5','Nuts Butterscotch Gold',500,8,'1','Party Pack 4ltr Gold',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(14,'1','Single Espresso',28,0,'2','HOT BASICS',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(15,'1','Strawberry Gold',900,14,'2','Party Pack 4ltr Gold',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(16,'1','Tax test ',1000,16,'1','Tiffin',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(17,'1','Vanila Gold',800,13,'2','Party Pack 4ltr Gold',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(18,'1','bread omlette',245,4,'2','Tiffin',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(19,'1','dosa',143,2,'4','Tiffin',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(20,'1','idly',102,2,'4','Tiffin',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(21,'1','masal dosa',162,3,'3','Tiffin',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(22,'1','masal vada',21,0,'1','Snacks',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(23,'1','onion dosa',374,6,'3','Tiffin',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(24,'1','pongal',121,2,'4','Tiffin',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(25,'1','poori',35,1,'1','Tiffin',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(26,'86','spanish cortado',20,0,'1','HOT CRAFT LATTES',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(27,'86','vada',40,1,'2','Snacks',NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO `kot_items_temp` (`_id`, `itemname`, `quantity`, `price`, `total`, `type`, `parent`, `parentid`, `mod_assigned`, `tax`, `taxname`, `bill_no`, `time`, `date`, `user`, `table_id`, `billtype`, `paymentmethod`, `billamount_disapply`, `billamount_disnotapply`, `_idd`, `deleted_not`, `modifiedquantity`, `quantitycopy`, `modifiedtotal`, `date1`, `datetimee`, `disc_type`, `disc_value`, `newtotal`, `disc_thereornot`, `disc_indiv_total`, `new_modified_total`, `datetimee_new`, `hsn_code`, `taxname2`, `tax2`, `taxname3`, `tax3`, `taxname4`, `tax4`, `taxname5`, `tax5`, `category`, `counterperson_username`, `counterperson_name`, `credit`, `Phone_num`, `barcode_get`, `order_id`, `old_total`, `hsn_code2`, `hsn_code3`, `hsn_code4`, `hsn_code5`, `item_online`, `old_total_indiv`) VALUES (1,'Roti Sabji','1','40.00','40','Item','null','null','no','0','','6351','12:13:47 PM','2025 10 30','','1','  Dine-in','  ','0','0','1','null','null','null','null','30Oct25','2025103012:13:47','%','0','','','','test','2025103012:13:47','','','0','','0','','0','','0','BREAKFAST','','','null','','','test','test','test','test','test','test',NULL,NULL),(2,'Puri Sabji','1','40.00','40','Item','null','null','no','0','','6351','12:13:47 PM','2025 10 30','','1','  Dine-in','  ','0','0','2','null','null','null','null','30Oct25','2025103012:13:47','%','0','','','','test','2025103012:13:47','','','0','','0','','0','','0','BREAKFAST','','','null','','','test','test','test','test','test','test',NULL,NULL),(3,'Bread Omlet','1','40.00','40','Item','null','null','no','0','','6351','12:13:47 PM','2025 10 30','','1','  Dine-in','  ','0','0','3','null','null','null','null','30Oct25','2025103012:13:47','%','0','','','','test','2025103012:13:47','','','0','','0','','0','','0','BREAKFAST','','','null','','','test','test','test','test','test','test',NULL,NULL),(4,'Muri- Sabji','1','30.00','30','Item','null','null','no','0','','6351','12:13:47 PM','2025 10 30','','1','  Dine-in','  ','0','0','5','null','null','null','null','30Oct25','2025103012:13:47','%','0','','','','test','2025103012:13:47','','','0','','0','','0','','0','BREAKFAST','','','null','','','test','test','test','test','test','test',NULL,NULL);
INSERT INTO `kot_temp` (`_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`, `printed`, `table_id`, `mobile_no`, `customer_name`, `status`) VALUES (1,'6351','150.00','','2025 10 30','  ','  Dine-in','150.000000','0.000000','0.000000','null','Swadpurna _241','202510301213','','','','0','0',NULL,'No',1,'7094869231','Raja','Pending');
INSERT INTO `kotcancelled` (`_id`, `itemname`, `qty`, `tableid`, `reason`, `date`, `date1`, `time`, `datetimee_new`, `category`, `user`, `kot_no`, `itemtype`, `price`, `total`) VALUES (1,'veg biriyani','1','12','','2025 07 01','01 Jul 2025','02:51:57 PM','202507010251','Main course','madmin','1','','70.00','70'),(2,'chicken biriyani','0','12','','2025 07 01','01 Jul 2025','02:52:42 PM','202507010252','Main course','madmin','1','','100.00','100'),(3,'poori','1.00','1','changed mind','2025 07 02','02 Jul 2025','02:49:39 pm','202507021449','','madmin','2','','35.00','35.00'),(4,'Rose Milk','1.00','1','Not interested ','2025 07 21','21 Jul 2025','12:33:50 pm','202507211233','','madmin','3','','30.00','30.00'),(5,'lassi','1.00','1','changed the mind','2025 07 21','21 Jul 2025','12:36:01 pm','202507211236','','madmin','4','','25.00','25.00'),(6,'dosa','1.00','1','Too oily','2025 07 21','21 Jul 2025','02:18:10 pm','202507211418','','madmin','5','','35.00','35.00'),(7,'masala chai','1.00','1','not interested ','2025 07 21','21 Jul 2025','02:20:29 pm','202507211420','','madmin','6','','25.00','25.00'),(8,'pongal','1.00','1','not interested ','2025 07 21','21 Jul 2025','02:49:31 pm','202507211449','','madmin','7','','30.00','30.00'),(9,'masal puri','1.00','1','changed mind ','2025 07 21','21 Jul 2025','03:03:19 pm','202507211503','','madmin','8','','35.00','35.00'),(10,'Rose Milk','1.00','1','not interested ','2025 07 21','21 Jul 2025','03:14:03 pm','202507211514','','madmin','9','','30.00','30.00');
INSERT INTO `top_category` (`_id`, `category`, `value`) VALUES (1,'Tiffin',70),(2,'Tiffin',85),(5,'Tiffin',85),(7,'Tiffin',85),(10,'Tiffin',425),(11,'Tiffin',425),(12,'Tiffin',170),(13,'Tiffin',390),(14,'Tiffin',390),(17,'Tiffin',90),(18,'Main course',50),(19,'Tiffin',150),(26,'Drinks',15),(27,'Tiffin',575),(30,'Drinks',15),(31,'Tiffin',740),(34,'Drinks',30),(35,'Main course',420),(36,'Tiffin',930),(52,'Drinks',30),(53,'Main course',420),(54,'Tiffin',930),(55,'Drinks',30),(56,'Main course',420),(57,'Tiffin',995),(66,'Drinks',60),(68,'Tiffin',1075),(73,'Abdulla Tea stall',10),(74,'Tiffin',940),(75,'Abdulla Tea stall',10),(76,'Main course',80),(77,'Tiffin',1000),(78,'Tiffin',60),(80,'Tiffin',60),(81,'Tiffin',495),(82,'Tiffin',105),(83,'Snacks',20),(84,'Tiffin',145),(85,'Main course',620),(86,'Snacks',560),(87,'Tiffin',2815),(90,'Abdulla Tea stall',65),(91,'Main course',620),(92,'Snacks',200),(93,'Tiffin',2955),(96,'Abdulla Tea stall',65),(97,'Tiffin',70),(98,'Snacks',140),(99,'Tiffin',95),(100,'baby frock',1500),(101,'Snacks',140),(102,'Tiffin',95),(103,'baby frock',1500),(104,'Snacks',140),(105,'Tiffin',295),(112,'Main course',850),(113,'None',2000),(114,'Snacks',140),(115,'Tiffin',295),(116,'sweets',100),(117,'Tiffin',315),(118,'Tiffin',775),(119,'Honey Bee',141),(120,'Mcdowell',70),(127,'Brandy ',314),(128,'Honey Bee',141),(129,'Mcdowell',70),(135,'Brandy ',314),(136,'Honey Bee',211),(137,'Mcdowell',141),(138,'Snacks',120),(139,'Tiffin',1330),(140,'Tiffin',255),(141,'Tiffin',255),(142,'Tiffin',255),(143,'Tiffin',155),(144,'Tiffin',30),(146,'Tiffin',175),(147,'Main course',14400),(148,'LIMRA JUICES',150),(149,'Main course',180),(150,'Snacks',205),(151,'Tiffin',230),(152,'Drinks',20),(153,'Main course',1200),(154,'Milk Tea',42),(155,'Snacks',20),(156,'Tiffin',35),(157,'Snacks',80),(158,'Tiffin',35),(159,'Milk Tea',27),(160,'Mixture',45),(161,'Snacks',80),(162,'Tiffin',35),(163,'Desserts',75),(164,'Milk Tea',27),(165,'Mixture',45),(166,'Snacks',80),(167,'Tiffin',100),(168,'Desserts',75),(169,'Milk Tea',27),(170,'Mixture',45),(171,'Snacks',80),(172,'Tiffin',165),(173,'Desserts',75),(174,'Milk Tea',27),(175,'Mixture',120),(176,'Snacks',80),(177,'Tiffin',165),(178,'Desserts',115),(179,'LIMRA JUICES',110),(180,'Milk Tea',27),(181,'Mixture',150),(182,'Snacks',80),(183,'Tiffin',270),(191,'Desserts',115),(192,'LIMRA JUICES',110),(193,'Main course',100),(194,'Milk Tea',27),(195,'Mixture',150),(196,'Snacks',80),(197,'Tiffin',270),(198,'Desserts',115),(199,'LIMRA JUICES',110),(200,'Main course',115),(201,'Milk Tea',27),(202,'Mixture',150),(203,'Snacks',80),(204,'Tiffin',270),(206,'Tiffin',44),(207,'Tiffin',74),(209,'Main course',110),(225,'Desserts',150),(226,'Drinks',155),(227,'LIMRA JUICES',290),(228,'Main course',16005),(229,'Milk Tea',69),(230,'Mixture',180),(231,'Snacks',560),(232,'Tiffin',2578),(233,'Wines',1000),(234,'mandi ',1120),(236,'LIMRA JUICES',150),(237,'Tiffin',100),(238,'Snacks',40),(239,'Tiffin',110),(243,'Snacks',40),(244,'Tiffin',110),(245,'mandi ',1197),(246,'Tiffin',65),(247,'Tiffin',130),(248,'Tiffin',105),(249,'Main course',480),(250,'Tiffin',155),(251,'Tiffin',260),(262,'Tiffin',60),(263,'Tiffin',60),(264,'Tiffin',35),(265,'Tiffin',190),(266,'Whole sale',51),(267,'ICED ESPRESSO',325),(268,'Whole sale',51),(269,'Desserts',75),(270,'Drinks',80),(271,'LIMRA JUICES',120),(272,'Tiffin',160),(273,'Desserts',75),(274,'Drinks',80),(275,'LIMRA JUICES',120),(276,'Tiffin',160),(282,'Tiffin',100),(283,'Tiffin',300),(285,'Tiffin',300),(286,'Whole sale',1000),(287,'Tiffin',300),(288,'Whole sale',1000),(289,'Desserts',110),(290,'Drinks',245),(291,'ICED ESPRESSO',325),(292,'LIMRA JUICES',830),(293,'Main course',740),(294,'Snacks',180),(295,'Tiffin',4333),(296,'Whole sale',1051),(297,'Wines',1000),(298,'mandi ',2395),(299,'Canteen ',360),(307,'Canteen ',360),(308,'Desserts',75),(309,'Drinks',145),(310,'ICED ESPRESSO',325),(311,'LIMRA JUICES',530),(312,'Main course',630),(313,'Snacks',40),(314,'Tiffin',2990),(315,'Whole sale',1051),(324,'Main course',70),(325,'Tiffin',130),(326,'Snacks',20),(327,'Tiffin',290),(328,'Snacks',40),(329,'Tiffin',320),(330,'Snacks',40),(331,'Tiffin',346),(332,'Tiffin',172),(333,'Bakery ',16),(338,'Bakery ',16),(339,'HOT BASICS',276),(340,'HOT CRAFT LATTES',20),(341,'Party Pack 4ltr Gold',3800),(342,'SIGNATURES',24),(343,'Snacks',61),(344,'Tiffin',2182),(359,'LOAF CAKE',900),(361,'HOT BEVERAGES',119),(362,'LOAF CAKE',900),(363,'COLD BEVERAGES',290),(364,'HOT BEVERAGES',230),(365,'MILKSHAKES',100),(366,'CAKES',1768),(367,'FRAPPE',300),(368,'HOT BEVERAGES',255),(369,'CAKES',1768),(370,'FRAPPE',300),(371,'HOT BEVERAGES',255),(372,'MILKSHAKES',800),(373,'CAKES',1768),(374,'FRAPPE',1000),(375,'HOT BEVERAGES',385),(376,'MILKSHAKES',2400),(377,'MOJITOS & COOLERS',60),(378,'PUFF & SANDWICH',500),(379,'CAKES',1768),(380,'FRAPPE',1000),(381,'HOT BEVERAGES',385),(382,'MILKSHAKES',2600),(383,'MOJITOS & COOLERS',60),(384,'PUFF & SANDWICH',600),(385,'CAKES',1768),(386,'COOKIES',1004),(387,'FRAPPE',1000),(388,'HOT BEVERAGES',385),(389,'MILKSHAKES',4400),(390,'MOJITOS & COOLERS',60),(391,'PUFF & SANDWICH',700),(392,'CAKES',1768),(393,'COOKIES',1004),(394,'FRAPPE',1000),(395,'HOT BEVERAGES',385),(396,'MILKSHAKES',5300),(397,'MOJITOS & COOLERS',60),(398,'PUFF & SANDWICH',700),(399,'CAKES',1768),(400,'COOKIES',1004),(401,'FRAPPE',1000),(402,'HOT BEVERAGES',385),(403,'MILKSHAKES',5300),(404,'MOJITOS & COOLERS',60),(405,'PUFF & SANDWICH',700),(406,'CAKES',1768),(407,'COOKIES',1004),(408,'FRAPPE',1000),(409,'HOT BEVERAGES',385),(410,'MILKSHAKES',5000),(411,'MOJITOS & COOLERS',60),(412,'PUFF & SANDWICH',700),(413,'CAKES',1768),(414,'COOKIES',1004),(415,'FRAPPE',1000),(416,'HOT BEVERAGES',385),(417,'MILKSHAKES',4700),(418,'MOJITOS & COOLERS',60),(419,'PUFF & SANDWICH',700),(420,'BROWNIES',148),(421,'CAKES',650),(422,'CHEESECAKE',125),(423,'CUPCAKES',50),(424,'FRAPPE',190),(425,'MOJITOS & COOLERS',180),(426,'PASTRIES',250),(427,'PUFF & SANDWICH',1520),(428,'SCS SPL CAKES',105),(429,'BROWNIES',148),(430,'CAKES',650),(431,'CHEESECAKE',125),(432,'CUPCAKES',50),(433,'FRAPPE',190),(434,'HOT BEVERAGES',60),(435,'MOJITOS & COOLERS',180),(436,'PASTRIES',250),(437,'PUFF & SANDWICH',1520),(438,'SCS SPL CAKES',105),(447,'Lunch',50),(448,'None',40),(449,'SPI Rice Item',100),(450,'Lunch',380),(451,'None',40),(452,'SPI Rice Item',100),(460,'BREAKFAST',80),(463,'BREAKFAST',80),(464,'Dinner',70),(465,'SPI Rice Item',100),(467,'BREAKFAST',84),(468,'Lunch',73),(469,'BREAKFAST',84),(470,'Lunch',73),(471,'SPI Rice Item',105),(472,'BREAKFAST',84),(473,'Dinner',243),(474,'Lunch',73),(475,'SPI Rice Item',105),(477,'Software Drinks',200),(478,'BREAKFAST',126),(479,'BREAKFAST',241),(480,'Lunch',73),(507,'BREAKFAST',489),(508,'Desserts ',100),(509,'Dinner',313),(510,'Lunch',147),(511,'Non Veg Curry',260),(512,'SPI Rice Item',677),(513,'Software Drinks',700),(514,'New Category ',105),(515,'VEG STARTERS',150),(516,'VEG STARTERS',300),(517,'CHICKEN SANDWICH',90),(518,'COOL DRINKS',50),(519,'FRIES',1000),(520,'NONVEG PIZZA',740),(521,'NONVEG WRAPS',380),(522,'VEG PIZZA',340),(523,'VEG SANDWICH',90),(524,'VEG STARTERS',300),(541,'NON VEG PIZZA',530),(542,'Snacks',20),(543,'Test',440),(544,'Tiffin',451),(545,'VEG BURGER',140),(546,'VEG PIZZA',839),(547,'VEGGIE SURPRISE ',278),(551,'VEG STARTERS',878);
INSERT INTO `top_reason` (`_id`, `reason`, `value`) VALUES (3,'Changed mind',1),(5,'Changed mind',1),(6,'Changed mind',1),(9,'Accidental charge',1),(10,'Changed mind',2);
INSERT INTO `usercancelleddata` (`_id`, `username`, `total`) VALUES (1,'admin',31);
INSERT INTO `userdata` (`_id`, `username`, `total`) VALUES (1,'admin',70),(2,'admin',2798),(3,'user2',75);
INSERT INTO `userwiseorderlistitems` (`_id`, `username`, `sales`, `salespercentage`) VALUES (1,'madmin',70,100),(2,'madmin',3977,98),(3,'Ram',75,16);
INSERT INTO `write_off` (`_id`, `date`, `time`, `name`, `phoneno`, `write_off`) VALUES (1,'19 May 2023','12:06:33 pm','Reshma S','9535897598','81.5'),(2,'23 Apr 2023','01:32:26 pm','Aarav','9876543210','20.0');
