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`, `item_online`, `old_total_indiv`) VALUES (1,'veg cutlet','1.0','40.00','40.00','Item',NULL,NULL,'no',NULL,NULL,'20260307-000011','04:56:21 PM','2026 03 07','admin','1','  Dine-in','  Cash','220.00','220.00','1',NULL,NULL,NULL,NULL,'07 Mar 2026','2026030716:56:21','%','0','40.00','no','0.00',NULL,'202603071656','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Snacks','admin','madmin',NULL,NULL,'',NULL,'40.00','','','','',NULL,'40.00'),(2,'chicken kabab','2.0','60.00','120.00','Item',NULL,NULL,'no',NULL,NULL,'20260307-000011','04:56:21 PM','2026 03 07','admin','1','  Dine-in','  Cash','220.00','220.00','2',NULL,NULL,NULL,NULL,'07 Mar 2026','2026030716:56:21','%','0','120.00','no','0.00',NULL,'202603071656','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Snacks','admin','madmin',NULL,NULL,'',NULL,'120.00','','','','',NULL,'60.00'),(3,'pav bhajji','1.0','60.00','60.00','Item',NULL,NULL,'no',NULL,NULL,'20260307-000011','04:56:21 PM','2026 03 07','admin','1','  Dine-in','  Cash','220.00','220.00','3',NULL,NULL,NULL,NULL,'07 Mar 2026','2026030716:56:21','%','0','60.00','no','0.00',NULL,'202603071656','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Snacks','admin','madmin',NULL,NULL,'',NULL,'60.00','','','','',NULL,'60.00'),(4,'samosa','1.0','20.00','20.00','Item',NULL,NULL,'no',NULL,NULL,'20260307-000012','04:57:51 pm','2026 03 07','admin','1','  Dine-in','  Cash','20.00','20.00','4',NULL,NULL,NULL,NULL,'07 Mar 2026','2026030716:57:51','%','0','20.00','no','0.00',NULL,'202603071657','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Snacks','user2','User2',NULL,NULL,'',NULL,'20.00','','','','',NULL,'20.00'),(5,'poori','4.0','35.00','140.00','Item',NULL,NULL,'no',NULL,NULL,'20260308-000011','11:58:47 AM','2026 03 08','admin','1','  Dine-in','  Cash','330.00','330.00','1',NULL,NULL,NULL,NULL,'08 Mar 2026','2026030811:58:47','%','0','140.00','no','0.00',NULL,'202603081158','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','user1','User1',NULL,NULL,'',NULL,'140.00','','','','',NULL,'35.00'),(6,'masal dosa','3.0','40.00','120.00','Item',NULL,NULL,'no',NULL,NULL,'20260308-000011','11:58:47 AM','2026 03 08','admin','1','  Dine-in','  Cash','330.00','330.00','2',NULL,NULL,NULL,NULL,'08 Mar 2026','2026030811:58:47','%','0','120.00','no','0.00',NULL,'202603081158','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','user1','User1',NULL,NULL,'',NULL,'120.00','','','','',NULL,'40.00'),(7,'rava dosa','2.0','35.00','70.00','Item',NULL,NULL,'no',NULL,NULL,'20260308-000011','11:58:47 AM','2026 03 08','admin','1','  Dine-in','  Cash','330.00','330.00','3',NULL,NULL,NULL,NULL,'08 Mar 2026','2026030811:58:47','%','0','70.00','no','0.00',NULL,'202603081158','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','user1','User1',NULL,NULL,'',NULL,'70.00','','','','',NULL,'35.00'),(8,'dosa','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20260308-000012','12:09:32 PM','2026 03 08','admin','1','  Dine-in','  Card','35.00','35.00','1',NULL,NULL,NULL,NULL,'08 Mar 2026','2026030812:09:32','%','0','35.00','no','0.00',NULL,'202603081209','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','user1','User1','0',NULL,'',NULL,'35.00','','','','',NULL,'35.00'),(9,'butterscotch cake','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20260308-000013','12:09:46 PM','2026 03 08','admin','1','  Dine-in','  Cash','35.00','35.00','2',NULL,NULL,NULL,NULL,'08 Mar 2026','2026030812:09:46','%','0','35.00','no','0.00',NULL,'202603081209','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Desserts','user1','User1',NULL,NULL,'',NULL,'35.00','','','','',NULL,'35.00'),(10,'masal vada','1.0','20.00','20.00','Item',NULL,NULL,'no',NULL,NULL,'20260308-000014','12:17:31 pm','2026 03 08','admin','1','  Dine-in','  Cash','20.00','20.00','3',NULL,NULL,NULL,NULL,'08 Mar 2026','2026030812:17:31','%','0','20.00','no','0.00',NULL,'202603081217','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Snacks','admin','madmin',NULL,NULL,'',NULL,'20.00','','','','',NULL,'20.00'),(11,'idly','1.0','25.00','25.00','Item',NULL,NULL,'no',NULL,NULL,'20260308-000015','12:29:07 pm','2026 03 08','admin','1','  Dine-in','  Cash','170.00','170.00','4',NULL,NULL,NULL,NULL,'08 Mar 2026','2026030812:29:07','%','0','25.00','no','0.00',NULL,'202603081229','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'25.00','','','','',NULL,'25.00'),(12,'dosa','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20260308-000015','12:29:07 pm','2026 03 08','admin','1','  Dine-in','  Cash','170.00','170.00','5',NULL,NULL,NULL,NULL,'08 Mar 2026','2026030812:29:07','%','0','35.00','no','0.00',NULL,'202603081229','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'35.00','','','','',NULL,'35.00'),(13,'samosa','1.0','20.00','20.00','Item',NULL,NULL,'no',NULL,NULL,'20260308-000015','12:29:07 pm','2026 03 08','admin','1','  Dine-in','  Cash','170.00','170.00','6',NULL,NULL,NULL,NULL,'08 Mar 2026','2026030812:29:07','%','0','20.00','no','0.00',NULL,'202603081229','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Snacks','admin','madmin',NULL,NULL,'',NULL,'20.00','','','','',NULL,'20.00'),(14,'chicken kabab','1.0','60.00','60.00','Item',NULL,NULL,'no',NULL,NULL,'20260308-000015','12:29:07 pm','2026 03 08','admin','1','  Dine-in','  Cash','170.00','170.00','7',NULL,NULL,NULL,NULL,'08 Mar 2026','2026030812:29:07','%','0','60.00','no','0.00',NULL,'202603081229','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Snacks','admin','madmin',NULL,NULL,'',NULL,'60.00','','','','',NULL,'60.00'),(15,'pongal','1.0','30.00','30.00','Item',NULL,NULL,'no',NULL,NULL,'20260308-000015','12:29:07 pm','2026 03 08','admin','1','  Dine-in','  Cash','170.00','170.00','8',NULL,NULL,NULL,NULL,'08 Mar 2026','2026030812:29:07','%','0','30.00','no','0.00',NULL,'202603081229','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'30.00','','','','',NULL,'30.00'),(16,'veg cutlet','1.0','40.00','40.00','Item',NULL,NULL,'no',NULL,NULL,'20260308-000016','12:42:09 pm','2026 03 08','admin','1','  Dine-in','  Cash','285.00','285.00','9',NULL,NULL,NULL,NULL,'08 Mar 2026','2026030812:42:09','%','0','40.00','no','0.00',NULL,'202603081242','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Snacks','user5','User5',NULL,NULL,'',NULL,'40.00','','','','',NULL,'40.00'),(17,'veg biriyani','1.0','70.00','70.00','Item',NULL,NULL,'no',NULL,NULL,'20260308-000016','12:42:09 pm','2026 03 08','admin','1','  Dine-in','  Cash','285.00','285.00','10',NULL,NULL,NULL,NULL,'08 Mar 2026','2026030812:42:09','%','0','70.00','no','0.00',NULL,'202603081242','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Main course','user5','User5',NULL,NULL,'',NULL,'70.00','','','','',NULL,'70.00'),(18,'pani puri','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20260308-000016','12:42:09 pm','2026 03 08','admin','1','  Dine-in','  Cash','285.00','285.00','11',NULL,NULL,NULL,NULL,'08 Mar 2026','2026030812:42:09','%','0','35.00','no','0.00',NULL,'202603081242','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Snacks','user5','User5',NULL,NULL,'',NULL,'35.00','','','','',NULL,'35.00'),(19,'samosa','1.0','20.00','20.00','Item',NULL,NULL,'no',NULL,NULL,'20260308-000016','12:42:09 pm','2026 03 08','admin','1','  Dine-in','  Cash','285.00','285.00','12',NULL,NULL,NULL,NULL,'08 Mar 2026','2026030812:42:09','%','0','20.00','no','0.00',NULL,'202603081242','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Snacks','user5','User5',NULL,NULL,'',NULL,'20.00','','','','',NULL,'20.00'),(20,'chicken kabab','2.0','60.00','120.00','Item',NULL,NULL,'no',NULL,NULL,'20260308-000016','12:42:09 pm','2026 03 08','admin','1','  Dine-in','  Cash','285.00','285.00','13',NULL,NULL,NULL,NULL,'08 Mar 2026','2026030812:42:09','%','0','120.00','no','0.00',NULL,'202603081242','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Snacks','user5','User5',NULL,NULL,'',NULL,'120.00','','','','',NULL,'60.00'),(21,'veg cutlet','1.0','40.00','40.00','Item',NULL,NULL,'no',NULL,NULL,'20260308-000017','12:59:02 pm','2026 03 08','admin','1','  Dine-in','  Cash','485.00','485.00','14',NULL,NULL,NULL,NULL,'08 Mar 2026','2026030812:59:02','%','0','40.00','no','0.00',NULL,'202603081259','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Snacks','user5','User5',NULL,NULL,'',NULL,'40.00','','','','',NULL,'40.00'),(22,'idly','1.0','25.00','25.00','Item',NULL,NULL,'no',NULL,NULL,'20260308-000017','12:59:02 pm','2026 03 08','admin','1','  Dine-in','  Cash','485.00','485.00','15',NULL,NULL,NULL,NULL,'08 Mar 2026','2026030812:59:02','%','0','25.00','no','0.00',NULL,'202603081259','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','user5','User5',NULL,NULL,'',NULL,'25.00','','','','',NULL,'25.00'),(23,'dosa','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20260308-000017','12:59:02 pm','2026 03 08','admin','1','  Dine-in','  Cash','485.00','485.00','16',NULL,NULL,NULL,NULL,'08 Mar 2026','2026030812:59:02','%','0','35.00','no','0.00',NULL,'202603081259','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','user5','User5',NULL,NULL,'',NULL,'35.00','','','','',NULL,'35.00'),(24,'uthappam','1.0','30.00','30.00','Item',NULL,NULL,'no',NULL,NULL,'20260308-000017','12:59:02 pm','2026 03 08','admin','1','  Dine-in','  Cash','485.00','485.00','17',NULL,NULL,NULL,NULL,'08 Mar 2026','2026030812:59:02','%','0','30.00','no','0.00',NULL,'202603081259','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','user5','User5',NULL,NULL,'',NULL,'30.00','','','','',NULL,'30.00'),(25,'bread omlette','1.0','30.00','30.00','Item',NULL,NULL,'no',NULL,NULL,'20260308-000017','12:59:02 pm','2026 03 08','admin','1','  Dine-in','  Cash','485.00','485.00','18',NULL,NULL,NULL,NULL,'08 Mar 2026','2026030812:59:02','%','0','30.00','no','0.00',NULL,'202603081259','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','user5','User5',NULL,NULL,'',NULL,'30.00','','','','',NULL,'30.00'),(26,'pani puri','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20260308-000017','12:59:02 pm','2026 03 08','admin','1','  Dine-in','  Cash','485.00','485.00','19',NULL,NULL,NULL,NULL,'08 Mar 2026','2026030812:59:02','%','0','35.00','no','0.00',NULL,'202603081259','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Snacks','user5','User5',NULL,NULL,'',NULL,'35.00','','','','',NULL,'35.00'),(27,'masal vada','3.0','20.00','60.00','Item',NULL,NULL,'no',NULL,NULL,'20260308-000017','12:59:02 pm','2026 03 08','admin','1','  Dine-in','  Cash','485.00','485.00','20',NULL,NULL,NULL,NULL,'08 Mar 2026','2026030812:59:02','%','0','60.00','no','0.00',NULL,'202603081259','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Snacks','user5','User5',NULL,NULL,'',NULL,'60.00','','','','',NULL,'20.00'),(28,'grape juice','1.0','25.00','25.00','Item',NULL,NULL,'no',NULL,NULL,'20260308-000017','12:59:02 pm','2026 03 08','admin','1','  Dine-in','  Cash','485.00','485.00','21',NULL,NULL,NULL,NULL,'08 Mar 2026','2026030812:59:02','%','0','25.00','no','0.00',NULL,'202603081259','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Drinks','user5','User5',NULL,NULL,'',NULL,'25.00','','','','',NULL,'25.00'),(29,'masala chai','1.0','25.00','25.00','Item',NULL,NULL,'no',NULL,NULL,'20260308-000017','12:59:02 pm','2026 03 08','admin','1','  Dine-in','  Cash','485.00','485.00','22',NULL,NULL,NULL,NULL,'08 Mar 2026','2026030812:59:02','%','0','25.00','no','0.00',NULL,'202603081259','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Drinks','user5','User5',NULL,NULL,'',NULL,'25.00','','','','',NULL,'25.00'),(30,'dhal fry','1.0','30.00','30.00','Item',NULL,NULL,'no',NULL,NULL,'20260308-000017','12:59:02 pm','2026 03 08','admin','1','  Dine-in','  Cash','485.00','485.00','23',NULL,NULL,NULL,NULL,'08 Mar 2026','2026030812:59:02','%','0','30.00','no','0.00',NULL,'202603081259','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Main course','user5','User5',NULL,NULL,'',NULL,'30.00','','','','',NULL,'30.00'),(31,'butterscotch cake','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20260308-000017','12:59:02 pm','2026 03 08','admin','1','  Dine-in','  Cash','485.00','485.00','24',NULL,NULL,NULL,NULL,'08 Mar 2026','2026030812:59:02','%','0','35.00','no','0.00',NULL,'202603081259','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Desserts','user5','User5',NULL,NULL,'',NULL,'35.00','','','','',NULL,'35.00'),(32,'vanilla icecream','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20260308-000017','12:59:02 pm','2026 03 08','admin','1','  Dine-in','  Cash','485.00','485.00','25',NULL,NULL,NULL,NULL,'08 Mar 2026','2026030812:59:02','%','0','35.00','no','0.00',NULL,'202603081259','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Desserts','user5','User5',NULL,NULL,'',NULL,'35.00','','','','',NULL,'35.00'),(33,'butterscotch icecream','2.0','40.00','80.00','Item',NULL,NULL,'no',NULL,NULL,'20260308-000017','12:59:02 pm','2026 03 08','admin','1','  Dine-in','  Cash','485.00','485.00','26',NULL,NULL,NULL,NULL,'08 Mar 2026','2026030812:59:02','%','0','80.00','no','0.00',NULL,'202603081259','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Desserts','user5','User5',NULL,NULL,'',NULL,'80.00','','','','',NULL,'40.00'),(34,'grape juice','1.0','25.00','25.00','Item',NULL,NULL,'no',NULL,NULL,'20260308-000018','01:01:17 pm','2026 03 08','admin','1','  Dine-in','  Cash','135.00','135.00','38',NULL,NULL,NULL,NULL,'08 Mar 2026','2026030813:01:17','%','0','25.00','no','0.00',NULL,'202603081301','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Drinks','user5','User5',NULL,NULL,'',NULL,'25.00','','','','',NULL,'25.00'),(35,'vanilla icecream','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20260308-000018','01:01:17 pm','2026 03 08','admin','1','  Dine-in','  Cash','135.00','135.00','39',NULL,NULL,NULL,NULL,'08 Mar 2026','2026030813:01:17','%','0','35.00','no','0.00',NULL,'202603081301','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Desserts','user5','User5',NULL,NULL,'',NULL,'35.00','','','','',NULL,'35.00'),(36,'butterscotch icecream','1.0','40.00','40.00','Item',NULL,NULL,'no',NULL,NULL,'20260308-000018','01:01:17 pm','2026 03 08','admin','1','  Dine-in','  Cash','135.00','135.00','40',NULL,NULL,NULL,NULL,'08 Mar 2026','2026030813:01:17','%','0','40.00','no','0.00',NULL,'202603081301','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Desserts','user5','User5',NULL,NULL,'',NULL,'40.00','','','','',NULL,'40.00'),(37,'butterscotch cake','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20260308-000018','01:01:17 pm','2026 03 08','admin','1','  Dine-in','  Cash','135.00','135.00','41',NULL,NULL,NULL,NULL,'08 Mar 2026','2026030813:01:17','%','0','35.00','no','0.00',NULL,'202603081301','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Desserts','user5','User5',NULL,NULL,'',NULL,'35.00','','','','',NULL,'35.00'),(38,'bread omlette','1.0','30.00','30.00','Item',NULL,NULL,'no',NULL,NULL,'20260308-000019','03:51:49 pm','2026 03 08','admin','1','  Dine-in','  Cash','60.00','60.00','43',NULL,NULL,NULL,NULL,'08 Mar 2026','2026030815:51:49','%','0','30.00','no','0.00',NULL,'202603081551','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'30.00','','','','',NULL,'30.00'),(39,'uthappam','1.0','30.00','30.00','Item',NULL,NULL,'no',NULL,NULL,'20260308-000019','03:51:49 pm','2026 03 08','admin','1','  Dine-in','  Cash','60.00','60.00','44',NULL,NULL,NULL,NULL,'08 Mar 2026','2026030815:51:49','%','0','30.00','no','0.00',NULL,'202603081551','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'30.00','','','','',NULL,'30.00'),(40,'upma','1.0','30.00','30.00','Item',NULL,NULL,'no',NULL,NULL,'20260308-0000110','03:52:03 pm','2026 03 08','admin','1','  Dine-in','  Cash','30.00','30.00','45',NULL,NULL,NULL,NULL,'08 Mar 2026','2026030815:52:03','%','0','30.00','no','0.00',NULL,'202603081552','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'30.00','','','','',NULL,'30.00'),(41,'idly','1.0','25.00','25.00','Item',NULL,NULL,'no',NULL,NULL,'20260310-1-000011','02:47:26 PM','2026 03 10','admin','1','  Dine-in','  Cash','25.00','25.00','1',NULL,NULL,NULL,NULL,'10 Mar 2026','2026031014:47:26','%','0','25.00','no','0.00',NULL,'202603101447','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'25.00','','','','',NULL,'25.00'),(42,'pani puri','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20260310-1-000012','03:11:15 pm','2026 03 10','admin','1','  Dine-in','  Cash','295.00','295.00','3',NULL,NULL,NULL,NULL,'10 Mar 2026','2026031015:11:15','%','0','35.00','no','0.00',NULL,'202603101511','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Snacks','admin','madmin',NULL,NULL,'',NULL,'35.00','','','','',NULL,'35.00'),(43,'veg biriyani','1.0','70.00','70.00','Item',NULL,NULL,'no',NULL,NULL,'20260310-1-000012','03:11:15 pm','2026 03 10','admin','1','  Dine-in','  Cash','295.00','295.00','4',NULL,NULL,NULL,NULL,'10 Mar 2026','2026031015:11:15','%','0','70.00','no','0.00',NULL,'202603101511','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Main course','admin','madmin',NULL,NULL,'',NULL,'70.00','','','','',NULL,'70.00'),(44,'masal vada','1.0','20.00','20.00','Item',NULL,NULL,'no',NULL,NULL,'20260310-1-000012','03:11:15 pm','2026 03 10','admin','1','  Dine-in','  Cash','295.00','295.00','5',NULL,NULL,NULL,NULL,'10 Mar 2026','2026031015:11:15','%','0','20.00','no','0.00',NULL,'202603101511','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Snacks','admin','madmin',NULL,NULL,'',NULL,'20.00','','','','',NULL,'20.00'),(45,'butterscotch cake','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20260310-1-000012','03:11:15 pm','2026 03 10','admin','1','  Dine-in','  Cash','295.00','295.00','6',NULL,NULL,NULL,NULL,'10 Mar 2026','2026031015:11:15','%','0','35.00','no','0.00',NULL,'202603101511','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Desserts','admin','madmin',NULL,NULL,'',NULL,'35.00','','','','',NULL,'35.00'),(46,'vanilla icecream','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20260310-1-000012','03:11:15 pm','2026 03 10','admin','1','  Dine-in','  Cash','295.00','295.00','7',NULL,NULL,NULL,NULL,'10 Mar 2026','2026031015:11:15','%','0','35.00','no','0.00',NULL,'202603101511','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Desserts','admin','madmin',NULL,NULL,'',NULL,'35.00','','','','',NULL,'35.00'),(47,'butterscotch icecream','1.0','40.00','40.00','Item',NULL,NULL,'no',NULL,NULL,'20260310-1-000012','03:11:15 pm','2026 03 10','admin','1','  Dine-in','  Cash','295.00','295.00','8',NULL,NULL,NULL,NULL,'10 Mar 2026','2026031015:11:15','%','0','40.00','no','0.00',NULL,'202603101511','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Desserts','admin','madmin',NULL,NULL,'',NULL,'40.00','','','','',NULL,'40.00'),(48,'soft drinks','1.0','10.00','10.00','Item',NULL,NULL,'no',NULL,NULL,'20260310-1-000012','03:11:15 pm','2026 03 10','admin','1','  Dine-in','  Cash','295.00','295.00','9',NULL,NULL,NULL,NULL,'10 Mar 2026','2026031015:11:15','%','0','10.00','no','0.00',NULL,'202603101511','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Drinks','admin','madmin',NULL,NULL,'',NULL,'10.00','','','','',NULL,'10.00'),(49,'coffee','1.0','20.00','20.00','Item',NULL,NULL,'no',NULL,NULL,'20260310-1-000012','03:11:15 pm','2026 03 10','admin','1','  Dine-in','  Cash','295.00','295.00','10',NULL,NULL,NULL,NULL,'10 Mar 2026','2026031015:11:15','%','0','20.00','no','0.00',NULL,'202603101511','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Drinks','admin','madmin',NULL,NULL,'',NULL,'20.00','','','','',NULL,'20.00'),(50,'dhal fry','1.0','30.00','30.00','Item',NULL,NULL,'no',NULL,NULL,'20260310-1-000012','03:11:15 pm','2026 03 10','admin','1','  Dine-in','  Cash','295.00','295.00','11',NULL,NULL,NULL,NULL,'10 Mar 2026','2026031015:11:15','%','0','30.00','no','0.00',NULL,'202603101511','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Main course','admin','madmin',NULL,NULL,'',NULL,'30.00','','','','',NULL,'30.00'),(51,'Manchurian ','2.0','130.00','260.00','Item',NULL,NULL,'no',NULL,NULL,'20260310-1-000013','03:35:49 pm','2026 03 10','admin','1','  Dine-in','  Cash','845.00','845.00','18',NULL,NULL,NULL,NULL,'10 Mar 2026','2026031015:35:49','%','0','260.00','no','0.00',NULL,'202603101535','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'Manchurian ',NULL,'260.00','','','','',NULL,'130.00'),(52,'French Frice ','1.0','50.00','50.00','Item',NULL,NULL,'no',NULL,NULL,'20260310-1-000013','03:35:49 pm','2026 03 10','admin','1','  Dine-in','  Cash','845.00','845.00','19',NULL,NULL,NULL,NULL,'10 Mar 2026','2026031015:35:49','%','0','50.00','no','0.00',NULL,'202603101535','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'French Fries',NULL,'50.00','','','','',NULL,'50.00'),(53,'Pizza','1.0','200.00','200.00','Item',NULL,NULL,'no',NULL,NULL,'20260310-1-000013','03:35:49 pm','2026 03 10','admin','1','  Dine-in','  Cash','845.00','845.00','20',NULL,NULL,NULL,NULL,'10 Mar 2026','2026031015:35:49','%','0','200.00','no','0.00',NULL,'202603101535','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'Pizza',NULL,'200.00','','','','',NULL,'200.00'),(54,'soft drinks','1.0','10.00','10.00','Item',NULL,NULL,'no',NULL,NULL,'20260310-1-000013','03:35:49 pm','2026 03 10','admin','1','  Dine-in','  Cash','845.00','845.00','21',NULL,NULL,NULL,NULL,'10 Mar 2026','2026031015:35:49','%','0','20.00','no','0.00',NULL,'202603101535','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Drinks','admin','madmin',NULL,NULL,'',NULL,'10.00','','','','',NULL,'10.00'),(55,'vanilla icecream','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20260310-1-000013','03:35:49 pm','2026 03 10','admin','1','  Dine-in','  Cash','845.00','845.00','22',NULL,NULL,NULL,NULL,'10 Mar 2026','2026031015:35:49','%','0','70.00','no','0.00',NULL,'202603101535','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Desserts','admin','madmin',NULL,NULL,'',NULL,'35.00','','','','',NULL,'35.00'),(56,'Donut ','1.0','120.00','120.00','Item',NULL,NULL,'no',NULL,NULL,'20260310-1-000013','03:35:49 pm','2026 03 10','admin','1','  Dine-in','  Cash','845.00','845.00','23',NULL,NULL,NULL,NULL,'10 Mar 2026','2026031015:35:49','%','0','120.00','no','0.00',NULL,'202603101535','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'Donut 🥯🍩',NULL,'120.00','','','','',NULL,'120.00'),(57,'Mayonnaise cup ','1.0','80.00','80.00','Item',NULL,NULL,'no',NULL,NULL,'20260310-1-000013','03:35:49 pm','2026 03 10','admin','1','  Dine-in','  Cash','845.00','845.00','24',NULL,NULL,NULL,NULL,'10 Mar 2026','2026031015:35:49','%','0','80.00','no','0.00',NULL,'202603101535','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'Mayonnaise cup',NULL,'80.00','','','','',NULL,'80.00'),(58,'Schezwan sauce cup','1.0','90.00','90.00','Item',NULL,NULL,'no',NULL,NULL,'20260310-1-000013','03:35:49 pm','2026 03 10','admin','1','  Dine-in','  Cash','845.00','845.00','25',NULL,NULL,NULL,NULL,'10 Mar 2026','2026031015:35:49','%','0','90.00','no','0.00',NULL,'202603101535','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'Schezwan Sauce cup',NULL,'90.00','','','','',NULL,'90.00'),(59,'Manchurian ','1.0','130.00','130.00','Item',NULL,NULL,'no',NULL,NULL,'20260310-1-000014','03:49:05 pm','2026 03 10','admin','1','  Dine-in','  Cash','870.00','870.00','26',NULL,NULL,NULL,NULL,'10 Mar 2026','2026031015:49:05','%','0','130.00','no','0.00',NULL,'202603101549','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'Manchurian ',NULL,'130.00','','','','',NULL,'130.00'),(60,'French Frice ','1.0','50.00','50.00','Item',NULL,NULL,'no',NULL,NULL,'20260310-1-000014','03:49:05 pm','2026 03 10','admin','1','  Dine-in','  Cash','870.00','870.00','27',NULL,NULL,NULL,NULL,'10 Mar 2026','2026031015:49:05','%','0','50.00','no','0.00',NULL,'202603101549','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'French Fries',NULL,'50.00','','','','',NULL,'50.00'),(61,'Mayonnaise cup ','2.0','80.00','160.00','Item',NULL,NULL,'no',NULL,NULL,'20260310-1-000014','03:49:05 pm','2026 03 10','admin','1','  Dine-in','  Cash','870.00','870.00','28',NULL,NULL,NULL,NULL,'10 Mar 2026','2026031015:49:05','%','0','160.00','no','0.00',NULL,'202603101549','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'Mayonnaise cup',NULL,'160.00','','','','',NULL,'80.00'),(62,'butterscotch cake','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20260310-1-000014','03:49:05 pm','2026 03 10','admin','1','  Dine-in','  Cash','870.00','870.00','29',NULL,NULL,NULL,NULL,'10 Mar 2026','2026031015:49:05','%','0','35.00','no','0.00',NULL,'202603101549','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Desserts','admin','madmin',NULL,NULL,'',NULL,'35.00','','','','',NULL,'35.00'),(63,'Chocolate Brownie cake ','1.0','250.00','250.00','Item',NULL,NULL,'no',NULL,NULL,'20260310-1-000014','03:49:05 pm','2026 03 10','admin','1','  Dine-in','  Cash','870.00','870.00','30',NULL,NULL,NULL,NULL,'10 Mar 2026','2026031015:49:05','%','10','225.00','yes','25.00',NULL,'202603101549','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'Chocolate cake ',NULL,'250.00','','','','',NULL,'250.00'),(64,'veg thali','1.0','50.00','50.00','Item',NULL,NULL,'no',NULL,NULL,'20260310-1-000014','03:49:05 pm','2026 03 10','admin','1','  Dine-in','  Cash','870.00','870.00','31',NULL,NULL,NULL,NULL,'10 Mar 2026','2026031015:49:05','%','0','50.00','no','0.00',NULL,'202603101549','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Main course','admin','madmin',NULL,NULL,'',NULL,'50.00','','','','',NULL,'50.00'),(65,'Pizza','1.0','200.00','200.00','Item',NULL,NULL,'no',NULL,NULL,'20260310-1-000014','03:49:05 pm','2026 03 10','admin','1','  Dine-in','  Cash','870.00','870.00','32',NULL,NULL,NULL,NULL,'10 Mar 2026','2026031015:49:05','%','0','200.00','no','0.00',NULL,'202603101549','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'Pizza',NULL,'200.00','','','','',NULL,'200.00'),(66,'soft drinks','2.0','10.00','20.00','Item',NULL,NULL,'no',NULL,NULL,'20260310-1-000014','03:49:05 pm','2026 03 10','admin','1','  Dine-in','  Cash','870.00','870.00','33',NULL,NULL,NULL,NULL,'10 Mar 2026','2026031015:49:05','%','0','20.00','no','0.00',NULL,'202603101549','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Drinks','admin','madmin',NULL,NULL,'',NULL,'20.00','','','','',NULL,'10.00');
INSERT INTO `billcount` (`_id`, `value`) VALUES (1,'0');
INSERT INTO `billnumber` (`_id`, `billnumber`, `total`, `user`, `date`, `paymentmethod`, `billtype`, `subtotal`, `taxtotal`, `roundoff`, `globaltaxtotal`, `billcount`, `datetimee_new`, `comments_sales`, `delivery_fee`, `packing_charges`, `loyalty_points`, `loyalty_amount`, `order_id`, `transaction_id`, `transaction_id_org`, `source`, `source1`) VALUES (1,'20260307-000011','220.00','admin','2026 03 07','  Cash','  Dine-in','220.00','0.00','0.00','0.0','1','202603071656',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(2,'20260307-000012','20.00','admin','2026 03 07','  Cash','  Dine-in','20.00','0.00','0.00','0.0','2','202603071657',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(3,'20260308-000011','330.00','admin','2026 03 08','  Cash','  Dine-in','330.00','0.00','0.00','0.0','3','202603081158',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(4,'20260308-000012','35.00','admin','2026 03 08','  Card','  Dine-in','35.00','0.00','0.00','0.0','4','202603081209',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(5,'20260308-000013','35.00','admin','2026 03 08','  Cash','  Dine-in','35.00','0.00','0.00','0.0','5','202603081209',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(6,'20260308-000014','20.00','admin','2026 03 08','  Cash','  Dine-in','20.00','0.00','0.00','0.0','6','202603081217',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(7,'20260308-000015','170.00','admin','2026 03 08','  Cash','  Dine-in','170.00','0.00','0.00','0.0','7','202603081229',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(8,'20260308-000016','285.00','admin','2026 03 08','  Cash','  Dine-in','285.00','0.00','0.00','0.0','8','202603081242',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(9,'20260308-000017','485.00','admin','2026 03 08','  Cash','  Dine-in','485.00','0.00','0.00','0.0','9','202603081259',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(10,'20260308-000018','135.00','admin','2026 03 08','  Cash','  Dine-in','135.00','0.00','0.00','0.0','10','202603081301',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(11,'20260308-000019','60.00','admin','2026 03 08','  Cash','  Dine-in','60.00','0.00','0.00','0.0','11','202603081551',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(12,'20260308-0000110','30.00','admin','2026 03 08','  Cash','  Dine-in','30.00','0.00','0.00','0.0','12','202603081552',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(13,'20260310-1-000011','25.00','admin','2026 03 10','  Cash','  Dine-in','25.00','0.00','0.00','0.0','13','202603101447',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(14,'20260310-1-000012','295.00','admin','2026 03 10','  Cash','  Dine-in','295.00','0.00','0.00','0.0','14','202603101511',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(15,'20260310-1-000013','845.00','admin','2026 03 10','  Cash','  Dine-in','845.00','0.00','0.00','0.0','15','202603101535',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(16,'20260310-1-000014','870.00','admin','2026 03 10','  Cash','  Dine-in','870.00','0.00','0.00','0.0','16','202603101549',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,'');
INSERT INTO `clicked_cust_name` (`_id`, `name`) VALUES (1,'');
