INSERT INTO `all_sales` (`_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`) VALUES (1,'idly','1.0','25.00','25.00','Item',NULL,NULL,'no',NULL,NULL,'20220912-1-000011','02:50:44 PM','2022 09 12','admin','1','  Dine-in','  Cash','65.00','65.00','1',NULL,NULL,NULL,NULL,'12 Sep 2022','2022091214:50:44','%','0','25.00','no','0.00',NULL,'202209121450','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(2,'masal dosa','1.0','40.00','40.00','Item',NULL,NULL,'no',NULL,NULL,'20220912-1-000011','02:50:44 PM','2022 09 12','admin','1','  Dine-in','  Cash','65.00','65.00','2',NULL,NULL,NULL,NULL,'12 Sep 2022','2022091214:50:44','%','0','40.00','no','0.00',NULL,'202209121450','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(3,'idly','1.0','25.00','25.00','Item',NULL,NULL,'no',NULL,NULL,'20220913-1-000011','02:17:49 PM','2022 09 13','admin','1','  Dine-in','  Cash','130.00','130.00','1',NULL,NULL,NULL,NULL,'13 Sep 2022','2022091314:17:49','%','0','25.00','no','0.00',NULL,'202209131417','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(4,'masal dosa','1.0','40.00','40.00','Item',NULL,NULL,'no',NULL,NULL,'20220913-1-000011','02:17:49 PM','2022 09 13','admin','1','  Dine-in','  Cash','130.00','130.00','2',NULL,NULL,NULL,NULL,'13 Sep 2022','2022091314:17:49','%','0','40.00','no','0.00',NULL,'202209131417','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(5,'bread omlette','1.0','30.00','30.00','Item',NULL,NULL,'no',NULL,NULL,'20220913-1-000011','02:17:49 PM','2022 09 13','admin','1','  Dine-in','  Cash','130.00','130.00','3',NULL,NULL,NULL,NULL,'13 Sep 2022','2022091314:17:49','%','0','30.00','no','0.00',NULL,'202209131417','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(6,'dosa','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20220913-1-000011','02:17:49 PM','2022 09 13','admin','1','  Dine-in','  Cash','130.00','130.00','4',NULL,NULL,NULL,NULL,'13 Sep 2022','2022091314:17:49','%','0','35.00','no','0.00',NULL,'202209131417','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(7,'idly','1.0','25.00','25.00','Item',NULL,NULL,'no',NULL,NULL,'20220914-1-000011','02:49:25 PM','2022 09 14','admin','1','  Dine-in','  Cash','85.00','85.00','1',NULL,NULL,NULL,NULL,'14 Sep 2022','2022091414:49:25','%','0','25.00','no','0.00',NULL,'202209141449','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(8,'masal dosa','1.0','40.00','40.00','Item',NULL,NULL,'no',NULL,NULL,'20220914-1-000011','02:49:25 PM','2022 09 14','admin','1','  Dine-in','  Cash','85.00','85.00','2',NULL,NULL,NULL,NULL,'14 Sep 2022','2022091414:49:25','%','0','40.00','no','0.00',NULL,'202209141449','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(9,'vada','1.0','20.00','20.00','Item',NULL,NULL,'no',NULL,NULL,'20220914-1-000011','02:49:25 PM','2022 09 14','admin','1','  Dine-in','  Cash','85.00','85.00','3',NULL,NULL,NULL,NULL,'14 Sep 2022','2022091414:49:25','%','0','20.00','no','0.00',NULL,'202209141449','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Snacks','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(10,'idly','1.0','25.00','25.00','Item',NULL,NULL,'no',NULL,NULL,'20220914-1-000012','03:03:47 PM','2022 09 14','admin','1','  Dine-in','  Cash','100.00','100.00','4',NULL,NULL,NULL,NULL,'14 Sep 2022','2022091415:03:47','%','0','25.00','no','0.00',NULL,'202209141503','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(11,'masal dosa','1.0','40.00','40.00','Item',NULL,NULL,'no',NULL,NULL,'20220914-1-000012','03:03:47 PM','2022 09 14','admin','1','  Dine-in','  Cash','100.00','100.00','5',NULL,NULL,NULL,NULL,'14 Sep 2022','2022091415:03:47','%','0','40.00','no','0.00',NULL,'202209141503','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(12,'dosa','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20220914-1-000012','03:03:47 PM','2022 09 14','admin','1','  Dine-in','  Cash','100.00','100.00','6',NULL,NULL,NULL,NULL,'14 Sep 2022','2022091415:03:47','%','0','35.00','no','0.00',NULL,'202209141503','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(13,'onion dosa','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20220914-1-000013','03:03:56 PM','2022 09 14','admin','1','  Dine-in','  Cash','105.00','105.00','7',NULL,NULL,NULL,NULL,'14 Sep 2022','2022091415:03:56','%','0','35.00','no','0.00',NULL,'202209141503','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(14,'pongal','1.0','30.00','30.00','Item',NULL,NULL,'no',NULL,NULL,'20220914-1-000013','03:03:56 PM','2022 09 14','admin','1','  Dine-in','  Cash','105.00','105.00','8',NULL,NULL,NULL,NULL,'14 Sep 2022','2022091415:03:56','%','0','30.00','no','0.00',NULL,'202209141503','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(15,'masal dosa','1.0','40.00','40.00','Item',NULL,NULL,'no',NULL,NULL,'20220914-1-000013','03:03:56 PM','2022 09 14','admin','1','  Dine-in','  Cash','105.00','105.00','9',NULL,NULL,NULL,NULL,'14 Sep 2022','2022091415:03:56','%','0','40.00','no','0.00',NULL,'202209141503','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(16,'idly','1.0','25.00','25.00','Item',NULL,NULL,'no',NULL,NULL,'20221210-1-000011','01:24:19 PM','2022 12 10','admin','1','  Dine-in','  Cash','25.00','25.00','2',NULL,NULL,NULL,NULL,'10 Dec 2022','2022121013:24:19','%','0','25.00','no','0.00',NULL,'202212101324','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(17,'idly','1.0','25.00','25.00','Item',NULL,NULL,'no',NULL,NULL,'20221210-1-000012','01:24:32 PM','2022 12 10','admin','1','  Dine-in','  Cash','25.00','25.00','3',NULL,NULL,NULL,NULL,'10 Dec 2022','2022121013:24:32','%','0','25.00','no','0.00',NULL,'202212101324','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(18,'bread omlette','1.0','30.00','30.00','Item',NULL,NULL,'no',NULL,NULL,'20221210-1-000013','01:25:09 PM','2022 12 10','admin','1','  Dine-in','  Cash','55.00','55.00','4',NULL,NULL,NULL,NULL,'10 Dec 2022','2022121013:25:09','%','0','30.00','no','0.00',NULL,'202212101325','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(19,'idly','1.0','25.00','25.00','Item',NULL,NULL,'no',NULL,NULL,'20221210-1-000013','01:25:09 PM','2022 12 10','admin','1','  Dine-in','  Cash','55.00','55.00','5',NULL,NULL,NULL,NULL,'10 Dec 2022','2022121013:25:09','%','0','25.00','no','0.00',NULL,'202212101325','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(20,'idly','1.0','25.00','25.00','Item',NULL,NULL,'no',NULL,NULL,'20221210-1-000014','01:25:36 PM','2022 12 10','admin','1','  Dine-in','  Cash','25.00','25.00','6',NULL,NULL,NULL,NULL,'10 Dec 2022','2022121013:25:36','%','0','25.00','no','0.00',NULL,'202212101325','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(21,'idly','1.0','25.00','25.00','Item',NULL,NULL,'no',NULL,NULL,'20221210-1-000015','01:26:03 PM','2022 12 10','admin','1','  Dine-in','  Cash','25.00','25.00','7',NULL,NULL,NULL,NULL,'10 Dec 2022','2022121013:26:03','%','0','25.00','no','0.00',NULL,'202212101326','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(22,'idly','1.0','25.00','25.00','Item',NULL,NULL,'no',NULL,NULL,'20221210-1-000016','02:26:54 PM','2022 12 10','admin','1','  Dine-in','  Cash','25.00','25.00','9',NULL,NULL,NULL,NULL,'10 Dec 2022','2022121014:26:54','%','0','25.00','no','0.00',NULL,'202212101426','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(23,'idly','1.0','1.00','1.00','Item',NULL,NULL,'no',NULL,NULL,'20221210-1-000017','02:43:32 PM','2022 12 10','admin','1','  Dine-in','  Cash','1.00','1.00','10',NULL,NULL,NULL,NULL,'10 Dec 2022','2022121014:43:32','%','0','1.00','no','0.00',NULL,'202212101443','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(24,'idly','1.0','1.00','1.00','Item',NULL,NULL,'no',NULL,NULL,'20221210-1-000018','02:59:21 PM','2022 12 10','admin','1','  Dine-in','  Cash','1.00','1.00','11',NULL,NULL,NULL,NULL,'10 Dec 2022','2022121014:59:21','%','0','1.00','no','0.00',NULL,'202212101459','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(25,'idly','1.0','1.00','1.00','Item',NULL,NULL,'no',NULL,NULL,'20221210-1-000019','03:11:41 PM','2022 12 10','admin','1','  Dine-in','  Card','1.00','1.00','12',NULL,NULL,NULL,NULL,'10 Dec 2022','2022121015:11:41','%','0','1.00','no','0.00',NULL,'202212101511','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin','0',NULL,'',NULL,NULL,'','','',''),(26,'idly','1.0','1.00','1.00','Item',NULL,NULL,'no',NULL,NULL,'20221210-1-0000110','03:12:06 PM','2022 12 10','admin','1','  Dine-in','  Card','1.00','1.00','13',NULL,NULL,NULL,NULL,'10 Dec 2022','2022121015:12:06','%','0','1.00','no','0.00',NULL,'202212101512','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin','0',NULL,'',NULL,NULL,'','','',''),(27,'idly','2.0','1.00','2.00','Item',NULL,NULL,'no',NULL,NULL,'20221210-1-0000111','03:26:44 PM','2022 12 10','admin','1','  Dine-in','  Cash','2.00','2.00','14',NULL,NULL,NULL,NULL,'10 Dec 2022','2022121015:26:44','%','0','2.00','no','0.00',NULL,'202212101526','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(28,'idly','1.0','1.00','1.00','Item',NULL,NULL,'no',NULL,NULL,'20221210-1-0000112','03:36:31 PM','2022 12 10','admin','1','  Dine-in','  Card','1.00','1.00','15',NULL,NULL,NULL,NULL,'10 Dec 2022','2022121015:36:31','%','0','1.00','no','0.00',NULL,'202212101536','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin','0',NULL,'',NULL,NULL,'','','',''),(29,'idly','1.0','1.00','1.00','Item',NULL,NULL,'no',NULL,NULL,'20221210-1-0000113','03:45:29 PM','2022 12 10','admin','1','  Dine-in','  Card','1.00','1.00','16',NULL,NULL,NULL,NULL,'10 Dec 2022','2022121015:45:29','%','0','1.00','no','0.00',NULL,'202212101545','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin','0',NULL,'',NULL,NULL,'','','',''),(30,'idly','1.0','1.00','1.00','Item',NULL,NULL,'no',NULL,NULL,'20221213-1-000011','10:07:25 AM','2022 12 13','admin','1','  Dine-in','  Cash','1.00','1.00','17',NULL,NULL,NULL,NULL,'13 Dec 2022','2022121310:07:25','%','0','1.00','no','0.00',NULL,'202212131007','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(31,'idly','1.0','1.00','1.00','Item',NULL,NULL,'no',NULL,NULL,'20221213-1-000012','10:08:16 AM','2022 12 13','admin','1','  Dine-in','  Card','1.00','1.00','18',NULL,NULL,NULL,NULL,'13 Dec 2022','2022121310:08:16','%','0','1.00','no','0.00',NULL,'202212131008','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin','0',NULL,'',NULL,NULL,'','','',''),(32,'idly','1.0','1.00','1.00','Item',NULL,NULL,'no',NULL,NULL,'20221213-1-000013','10:09:30 AM','2022 12 13','admin','1','  Dine-in','  Card','1.00','1.00','19',NULL,NULL,NULL,NULL,'13 Dec 2022','2022121310:09:30','%','0','1.00','no','0.00',NULL,'202212131009','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin','0',NULL,'',NULL,NULL,'','','',''),(33,'idly','1.0','1.00','1.00','Item',NULL,NULL,'no',NULL,NULL,'20221213-1-000014','12:07:09 PM','2022 12 13','admin','1','  Dine-in','  Card','1.00','1.00','20',NULL,NULL,NULL,NULL,'13 Dec 2022','2022121312:07:09','%','0','1.00','no','0.00',NULL,'202212131207','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin','0',NULL,'',NULL,NULL,'','','',''),(34,'idly','1.0','1.00','1.00','Item',NULL,NULL,'no',NULL,NULL,'20221213-1-000015','12:19:12 PM','2022 12 13','admin','1','  Dine-in','  Card','1.00','1.00','21',NULL,NULL,NULL,NULL,'13 Dec 2022','2022121312:19:12','%','0','1.00','no','0.00',NULL,'202212131219','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin','0',NULL,'',NULL,NULL,'','','',''),(35,'idly','1.0','1.00','1.00','Item',NULL,NULL,'no',NULL,NULL,'20221215-1-000011','10:58:18 am','2022 12 15','admin','1','  Dine-in','  Cash','36.00','36.00','1',NULL,NULL,NULL,NULL,'15 Dec 2022','2022121510:58:18','%','0','1.00','no','0.00',NULL,'202212151058','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(36,'dosa','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20221215-1-000011','10:58:18 am','2022 12 15','admin','1','  Dine-in','  Cash','36.00','36.00','2',NULL,NULL,NULL,NULL,'15 Dec 2022','2022121510:58:18','%','0','35.00','no','0.00',NULL,'202212151058','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(37,'idly','1.0','1.00','1.00','Item',NULL,NULL,'no',NULL,NULL,'20221215-1-000012','05:58:44 pm','2022 12 15','admin','1','  Dine-in','  Cash','1.00','1.00','1',NULL,NULL,NULL,NULL,'15 Dec 2022','2022121517:58:44','%','0','1.00','no','0.00',NULL,'202212151758','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(38,'idly','1.0','1.00','1.00','Item',NULL,NULL,'no',NULL,NULL,'20230104-1-000011','04:10:12 PM','2023 01 04','admin','1','  Dine-in','  Cash','131.00','131.00','1',NULL,NULL,NULL,NULL,'04 Jan 2023','2023010416:10:12','%','0','1.00','no','0.00',NULL,'202301041610','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(39,'dosa','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20230104-1-000011','04:10:12 PM','2023 01 04','admin','1','  Dine-in','  Cash','131.00','131.00','2',NULL,NULL,NULL,NULL,'04 Jan 2023','2023010416:10:12','%','0','35.00','no','0.00',NULL,'202301041610','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(40,'pongal','1.0','30.00','30.00','Item',NULL,NULL,'no',NULL,NULL,'20230104-1-000011','04:10:12 PM','2023 01 04','admin','1','  Dine-in','  Cash','131.00','131.00','3',NULL,NULL,NULL,NULL,'04 Jan 2023','2023010416:10:12','%','0','30.00','no','0.00',NULL,'202301041610','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(41,'upma','1.0','30.00','30.00','Item',NULL,NULL,'no',NULL,NULL,'20230104-1-000011','04:10:12 PM','2023 01 04','admin','1','  Dine-in','  Cash','131.00','131.00','4',NULL,NULL,NULL,NULL,'04 Jan 2023','2023010416:10:12','%','0','30.00','no','0.00',NULL,'202301041610','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(42,'poori','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20230104-1-000011','04:10:12 PM','2023 01 04','admin','1','  Dine-in','  Cash','131.00','131.00','5',NULL,NULL,NULL,NULL,'04 Jan 2023','2023010416:10:12','%','0','35.00','no','0.00',NULL,'202301041610','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(43,'idly','1.0','1.00','1.00','Item',NULL,NULL,'no',NULL,NULL,'20230104-1-000012','04:10:34 PM','2023 01 04','admin','1','  Dine-in','  Cash','36.00','36.00','6',NULL,NULL,NULL,NULL,'04 Jan 2023','2023010416:10:34','%','0','1.00','no','0.00',NULL,'202301041610','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(44,'dosa','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20230104-1-000012','04:10:34 PM','2023 01 04','admin','1','  Dine-in','  Cash','36.00','36.00','7',NULL,NULL,NULL,NULL,'04 Jan 2023','2023010416:10:34','%','0','35.00','no','0.00',NULL,'202301041610','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(45,'idly','1.0','1.00','1.00','Item',NULL,NULL,'no',NULL,NULL,'20230104-1-000013','04:12:25 PM','2023 01 04','admin','1','  Dine-in','  Cash','76.00','76.00','8',NULL,NULL,NULL,NULL,'04 Jan 2023','2023010416:12:25','%','0','1.00','no','0.00',NULL,'202301041612','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(46,'dosa','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20230104-1-000013','04:12:25 PM','2023 01 04','admin','1','  Dine-in','  Cash','76.00','76.00','9',NULL,NULL,NULL,NULL,'04 Jan 2023','2023010416:12:25','%','0','35.00','no','0.00',NULL,'202301041612','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(47,'masal dosa','1.0','40.00','40.00','Item',NULL,NULL,'no',NULL,NULL,'20230104-1-000013','04:12:25 PM','2023 01 04','admin','1','  Dine-in','  Cash','76.00','76.00','10',NULL,NULL,NULL,NULL,'04 Jan 2023','2023010416:12:25','%','0','40.00','no','0.00',NULL,'202301041612','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(48,'idly','1.0','1.00','1.00','Item',NULL,NULL,'no',NULL,NULL,'20230104-1-000014','04:14:49 PM','2023 01 04','admin','1','  Dine-in','  Cash','106.00','106.00','11',NULL,NULL,NULL,NULL,'04 Jan 2023','2023010416:14:49','%','0','1.00','no','0.00',NULL,'202301041614','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(49,'masal dosa','1.0','40.00','40.00','Item',NULL,NULL,'no',NULL,NULL,'20230104-1-000014','04:14:49 PM','2023 01 04','admin','1','  Dine-in','  Cash','106.00','106.00','12',NULL,NULL,NULL,NULL,'04 Jan 2023','2023010416:14:49','%','0','40.00','no','0.00',NULL,'202301041614','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(50,'dosa','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20230104-1-000014','04:14:49 PM','2023 01 04','admin','1','  Dine-in','  Cash','106.00','106.00','13',NULL,NULL,NULL,NULL,'04 Jan 2023','2023010416:14:49','%','0','35.00','no','0.00',NULL,'202301041614','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(51,'bread omlette','1.0','30.00','30.00','Item',NULL,NULL,'no',NULL,NULL,'20230104-1-000014','04:14:49 PM','2023 01 04','admin','1','  Dine-in','  Cash','106.00','106.00','14',NULL,NULL,NULL,NULL,'04 Jan 2023','2023010416:14:49','%','0','30.00','no','0.00',NULL,'202301041614','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'12345',NULL,NULL,'','','',''),(52,'idly','1.0','1.00','1.00','Item',NULL,NULL,'no',NULL,NULL,'20230105-1-000011','11:07:18 AM','2023 01 05','admin','1','  Dine-in','  Cash','41.00','41.00','1',NULL,NULL,NULL,NULL,'05 Jan 2023','2023010511:07:18','%','0','1.00','no','0.00',NULL,'202301051107','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'1.00','','','',''),(53,'masal dosa','1.0','40.00','40.00','Item',NULL,NULL,'no',NULL,NULL,'20230105-1-000011','11:07:18 AM','2023 01 05','admin','1','  Dine-in','  Cash','41.00','41.00','2',NULL,NULL,NULL,NULL,'05 Jan 2023','2023010511:07:18','%','0','40.00','no','0.00',NULL,'202301051107','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'40.00','','','',''),(54,'masal vada','1.0','20.00','20.00','Item',NULL,NULL,'no',NULL,NULL,'20230105-1-000012','11:13:55 AM','2023 01 05','admin','1','  Dine-in','  Cash','50.00','50.00','3',NULL,NULL,NULL,NULL,'05 Jan 2023','2023010511:13:55','%','0','20.00','no','0.00',NULL,'202301051113','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Snacks','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(55,'bread omlette','1.0','30.00','30.00','Item',NULL,NULL,'no',NULL,NULL,'20230105-1-000012','11:13:55 AM','2023 01 05','admin','1','  Dine-in','  Cash','50.00','50.00','4',NULL,NULL,NULL,NULL,'05 Jan 2023','2023010511:13:55','%','0','30.00','no','0.00',NULL,'202301051113','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'12345',NULL,NULL,'','','',''),(56,'idly','1.0','1.00','1.00','Item',NULL,NULL,'no','5','vat(5%)','20230810-1-000011','02:17:04 PM','2023 08 10','admin','1','  Dine-in','  Cash','36.05','36.05','1',NULL,NULL,NULL,NULL,'10 Aug 2023','2023081014:17:04','%','0','1.00','no','0.00',NULL,'202308101417','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(57,'dosa','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20230810-1-000011','02:17:04 PM','2023 08 10','admin','1','  Dine-in','  Cash','36.05','36.05','2',NULL,NULL,NULL,NULL,'10 Aug 2023','2023081014:17:04','%','0','35.00','no','0.00',NULL,'202308101417','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','');
INSERT INTO `billcount` (`_id`, `value`) VALUES (1,'0');
INSERT INTO `billnumber` (`_id`, `billnumber`, `total`, `user`, `date`, `paymentmethod`, `billtype`, `subtotal`, `taxtotal`, `roundoff`, `globaltaxtotal`, `billcount`, `datetimee_new`, `comments_sales`, `delivery_fee`, `packing_charges`, `loyalty_points`, `loyalty_amount`) VALUES (1,'20220912-1-000011','65.00','admin','2022 09 12','  Cash','  Dine-in','65.00','0.00','0.00','0.0','1','202209121450',NULL,NULL,NULL,NULL,NULL),(2,'20220913-1-000011','130.00','admin','2022 09 13','  Cash','  Dine-in','130.00','0.00','0.00','0.0','2','202209131417',NULL,NULL,NULL,NULL,NULL),(3,'20220914-1-000011','85.00','admin','2022 09 14','  Cash','  Dine-in','85.00','0.00','0.00','0.0','3','202209141449',NULL,NULL,NULL,NULL,NULL),(4,'20220914-1-000012','100.00','admin','2022 09 14','  Cash','  Dine-in','100.00','0.00','0.00','0.0','4','202209141503',NULL,NULL,NULL,NULL,NULL),(5,'20220914-1-000013','105.00','admin','2022 09 14','  Cash','  Dine-in','105.00','0.00','0.00','0.0','5','202209141503',NULL,NULL,NULL,NULL,NULL),(6,'20221210-1-000011','25.00','admin','2022 12 10','  Cash','  Dine-in','25.00','0.00','0.00','0.0','1','202212101324',NULL,NULL,NULL,NULL,NULL),(7,'20221210-1-000012','25.00','admin','2022 12 10','  Cash','  Dine-in','25.00','0.00','0.00','0.0','2','202212101324',NULL,NULL,NULL,NULL,NULL),(8,'20221210-1-000013','55.00','admin','2022 12 10','  Cash','  Dine-in','55.00','0.00','0.00','0.0','3','202212101325',NULL,NULL,NULL,NULL,NULL),(9,'20221210-1-000014','25.00','admin','2022 12 10','  Cash','  Dine-in','25.00','0.00','0.00','0.0','4','202212101325',NULL,NULL,NULL,NULL,NULL),(10,'20221210-1-000015','25.00','admin','2022 12 10','  Cash','  Dine-in','25.00','0.00','0.00','0.0','5','202212101326',NULL,NULL,NULL,NULL,NULL),(11,'20221210-1-000016','25.00','admin','2022 12 10','  Cash','  Dine-in','25.00','0.00','0.00','0.0','6','202212101426',NULL,NULL,NULL,NULL,NULL),(12,'20221210-1-000017','1.00','admin','2022 12 10','  Cash','  Dine-in','1.00','0.00','0.00','0.0','7','202212101443',NULL,NULL,NULL,NULL,NULL),(13,'20221210-1-000018','1.00','admin','2022 12 10','  Cash','  Dine-in','1.00','0.00','0.00','0.0','8','202212101459',NULL,NULL,NULL,NULL,NULL),(14,'20221210-1-000019','1.00','admin','2022 12 10','  Card','  Dine-in','1.00','0.00','0.00','0.0','9','202212101511',NULL,NULL,NULL,NULL,NULL),(15,'20221210-1-0000110','1.00','admin','2022 12 10','  Card','  Dine-in','1.00','0.00','0.00','0.0','10','202212101512',NULL,NULL,NULL,NULL,NULL),(16,'20221210-1-0000111','2.00','admin','2022 12 10','  Cash','  Dine-in','2.00','0.00','0.00','0.0','11','202212101526',NULL,NULL,NULL,NULL,NULL),(17,'20221210-1-0000112','1.00','admin','2022 12 10','  Card','  Dine-in','1.00','0.00','0.00','0.0','12','202212101536',NULL,NULL,NULL,NULL,NULL),(18,'20221210-1-0000113','1.00','admin','2022 12 10','  Card','  Dine-in','1.00','0.00','0.00','0.0','13','202212101545',NULL,NULL,NULL,NULL,NULL),(19,'20221213-1-000011','1.00','admin','2022 12 13','  Cash','  Dine-in','1.00','0.00','0.00','0.0','14','202212131007',NULL,NULL,NULL,NULL,NULL),(20,'20221213-1-000012','1.00','admin','2022 12 13','  Card','  Dine-in','1.00','0.00','0.00','0.0','15','202212131008',NULL,NULL,NULL,NULL,NULL),(21,'20221213-1-000013','1.00','admin','2022 12 13','  Card','  Dine-in','1.00','0.00','0.00','0.0','16','202212131009',NULL,NULL,NULL,NULL,NULL),(22,'20221213-1-000014','1.00','admin','2022 12 13','  Card','  Dine-in','1.00','0.00','0.00','0.0','17','202212131207',NULL,NULL,NULL,NULL,NULL),(23,'20221213-1-000015','1.00','admin','2022 12 13','  Card','  Dine-in','1.00','0.00','0.00','0.0','18','202212131219',NULL,NULL,NULL,NULL,NULL),(24,'20221215-1-000011','36.00','admin','2022 12 15','  Cash','  Dine-in','36.00','0.00','0.00','0.0','19','202212151058',NULL,NULL,NULL,NULL,NULL),(25,'20221215-1-000012','1.00','admin','2022 12 15','  Cash','  Dine-in','1.00','0.00','0.00','0.0','20','202212151758',NULL,NULL,NULL,NULL,NULL),(26,'20230104-1-000011','131.00','admin','2023 01 04','  Cash','  Dine-in','131.00','0.00','0.00','0.0','21','202301041610',NULL,NULL,NULL,NULL,NULL),(27,'20230104-1-000012','36.00','admin','2023 01 04','  Cash','  Dine-in','36.00','0.00','0.00','0.0','22','202301041610',NULL,NULL,NULL,NULL,NULL),(28,'20230104-1-000013','76.00','admin','2023 01 04','  Cash','  Dine-in','76.00','0.00','0.00','0.0','23','202301041612',NULL,NULL,NULL,NULL,NULL),(29,'20230104-1-000014','106.00','admin','2023 01 04','  Cash','  Dine-in','106.00','0.00','0.00','0.0','24','202301041614',NULL,NULL,NULL,NULL,NULL),(30,'20230105-1-000011','41.00','admin','2023 01 05','  Cash','  Dine-in','41.00','0.00','0.00','0.0','25','202301051107',NULL,NULL,NULL,NULL,NULL),(31,'20230105-1-000012','50.00','admin','2023 01 05','  Cash','  Dine-in','50.00','0.00','0.00','0.0','26','202301051113',NULL,NULL,NULL,NULL,NULL),(32,'20230810-1-000011','36.05','admin','2023 08 10','  Cash','  Dine-in','36.00','0.05','0.00','0.0','1','202308101417',NULL,NULL,NULL,NULL,NULL);
INSERT INTO `clicked_cust_name` (`_id`, `name`) VALUES (1,'');
INSERT INTO `cusotmer_activity_temp_top3` (`_id`, `name`, `phone_no`, `email`, `addr`, `total_amount`, `balance`, `discount_value`, `discount_type`, `approval_rate`) VALUES (1,'rohith','9581497872','krrohith934@gmail.com','bangalore',36,'0.0',NULL,NULL,NULL);
INSERT INTO `customer_loyalty_points` (`_id`, `phoneno`, `points`) VALUES (1,'9581497872','76.00'),(2,'1234567890','106.00');
INSERT INTO `expenses_sales` (`_id`, `expensename`, `price`, `category`, `counterperson_username`, `counterperson_name`, `date`, `time`, `datetimee_new`) VALUES (1,'test','50','Rent','madmin','madmin','12 Dec 2022','10:26 AM','202212121026');
INSERT INTO `itemdata` (`_id`, `itemname`, `total`) VALUES (1,'bread omlette',30),(2,'dosa',35),(3,'idly',165),(4,'poori',35),(5,'upma',30);
INSERT INTO `itemwiseorderlistcategory` (`_id`, `itemno`, `categoryname`, `sales`, `salespercentage`, `itemtotalquan`) VALUES (1,NULL,'Tiffin',167,100,'7');
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,'7','bread omlette',30,13,'1','Tiffin',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(2,'2','dosa',35,15,'1','Tiffin',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(3,'1','idly',165,72,'21','Tiffin',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(4,'5','poori',35,21,'1','Tiffin',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(5,'4','upma',30,18,'1','Tiffin',NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO `top_category` (`_id`, `category`, `value`) VALUES (1,'Tiffin',37),(2,'Tiffin',230),(6,'Tiffin',167),(7,'Tiffin',36);
INSERT INTO `userdata` (`_id`, `username`, `total`) VALUES (1,'admin',230);
INSERT INTO `userwiseorderlistitems` (`_id`, `username`, `sales`, `salespercentage`) VALUES (1,'madmin',230,100);
