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,'idly','1.0','25.00','25.00','Item',NULL,NULL,'no',NULL,NULL,'20260326-1-000011','11:46:56 AM','2026 03 26','admin','1','  Dine-in','  Cash','60.00','60.00','1',NULL,NULL,NULL,NULL,'26 Mar 2026','2026032611:46:56','%','0','25.00','no','0.00',NULL,'202603261146','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'25.00','','','','',NULL,'25.00'),(2,'dosa','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20260326-1-000011','11:46:56 AM','2026 03 26','admin','1','  Dine-in','  Cash','60.00','60.00','2',NULL,NULL,NULL,NULL,'26 Mar 2026','2026032611:46:56','%','0','35.00','no','0.00',NULL,'202603261146','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'35.00','','','','',NULL,'35.00'),(3,'TEA','2.0','10.00','20.00','Item',NULL,NULL,'no',NULL,NULL,'20260326-1-000012','11:58:50 AM','2026 03 26','admin','1','  Dine-in','  Cash','20.00','20.00','3',NULL,NULL,NULL,NULL,'26 Mar 2026','2026032611:58:50','%','0','20.00','no','0.00',NULL,'202603261158','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TEA','admin','madmin',NULL,NULL,'',NULL,'20.00','','','','',NULL,'10.00'),(4,'Tea','6.0','10.00','60.00','Item',NULL,NULL,'no',NULL,NULL,'20260326-1-000013','12:16:43 PM','2026 03 26','admin','1','  Dine-in','  Upiqr','60.00','60.00','6',NULL,NULL,NULL,NULL,'26 Mar 2026','2026032612:16:43','%','0','60.00','no','0.00',NULL,'202603261216','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TEA','admin','madmin','0',NULL,'',NULL,'60.00','','','','',NULL,'10.00'),(5,'Tea','1.0','10.00','10.00','Item',NULL,NULL,'no',NULL,NULL,'20260326-1-000014','12:17:11 PM','2026 03 26','admin','1','  Dine-in','  Upiqr','10.00','10.00','7',NULL,NULL,NULL,NULL,'26 Mar 2026','2026032612:17:11','%','0','10.00','no','0.00',NULL,'202603261217','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TEA','admin','madmin','0',NULL,'',NULL,'10.00','','','','',NULL,'10.00'),(6,'Tea','1.0','10.00','10.00','Item',NULL,NULL,'no',NULL,NULL,'20260326-1-000015','12:18:31 PM','2026 03 26','admin','1','  Dine-in','  Cash','10.00','10.00','8',NULL,NULL,NULL,NULL,'26 Mar 2026','2026032612:18:31','%','0','10.00','no','0.00',NULL,'202603261218','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TEA','admin','madmin',NULL,NULL,'',NULL,'10.00','','','','',NULL,'10.00'),(7,'TEA','1.0','10.00','10.00','Item',NULL,NULL,'no',NULL,NULL,'20260326-1-000016','07:44:17 PM','2026 03 26','admin','1','  Dine-in','  Cash','90.00','90.00','15',NULL,NULL,NULL,NULL,'26 Mar 2026','2026032619:44:17','%','0','10.00','no','0.00',NULL,'202603261944','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tea','admin','madmin',NULL,NULL,'',NULL,'10.00','','','','',NULL,'10.00'),(8,'Honey Cake','1.0','20.00','20.00','Item',NULL,NULL,'no',NULL,NULL,'20260326-1-000016','07:44:17 PM','2026 03 26','admin','1','  Dine-in','  Cash','90.00','90.00','16',NULL,NULL,NULL,NULL,'26 Mar 2026','2026032619:44:17','%','0','20.00','no','0.00',NULL,'202603261944','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'CAKE','admin','madmin',NULL,NULL,'',NULL,'20.00','','','','',NULL,'20.00'),(9,'Popcorn','2.0','10.00','20.00','Item',NULL,NULL,'no',NULL,NULL,'20260326-1-000016','07:44:17 PM','2026 03 26','admin','1','  Dine-in','  Cash','90.00','90.00','17',NULL,NULL,NULL,NULL,'26 Mar 2026','2026032619:44:17','%','0','20.00','no','0.00',NULL,'202603261944','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Snacks','admin','madmin',NULL,NULL,'',NULL,'20.00','','','','',NULL,'10.00'),(10,'Murukku 40','1.0','40.00','40.00','Item',NULL,NULL,'no',NULL,NULL,'20260326-1-000016','07:44:17 PM','2026 03 26','admin','1','  Dine-in','  Cash','90.00','90.00','18',NULL,NULL,NULL,NULL,'26 Mar 2026','2026032619:44:17','%','0','40.00','no','0.00',NULL,'202603261944','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Snacks','admin','madmin',NULL,NULL,'',NULL,'40.00','','','','',NULL,'40.00'),(11,'TEA','1.0','10.00','10.00','Item',NULL,NULL,'no',NULL,NULL,'20260326-1-000017','07:45:27 PM','2026 03 26','admin','1','  Dine-in','  Cash','10.00','10.00','19',NULL,NULL,NULL,NULL,'26 Mar 2026','2026032619:45:27','%','0','10.00','no','0.00',NULL,'202603261945','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tea','admin','madmin',NULL,NULL,'',NULL,'10.00','','','','',NULL,'10.00'),(12,'TEA','1.0','10.00','10.00','Item',NULL,NULL,'no',NULL,NULL,'20260326-1-000018','07:49:06 PM','2026 03 26','admin','1','  Dine-in','  Cash','10.00','10.00','20',NULL,NULL,NULL,NULL,'26 Mar 2026','2026032619:49:06','%','0','10.00','no','0.00',NULL,'202603261949','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tea','admin','madmin',NULL,NULL,'',NULL,'10.00','','','','',NULL,'10.00'),(13,'TEA','1.0','10.00','10.00','Item',NULL,NULL,'no',NULL,NULL,'20260326-1-000019','07:49:39 PM','2026 03 26','admin','1','  Dine-in','  Cash','10.00','10.00','21',NULL,NULL,NULL,NULL,'26 Mar 2026','2026032619:49:39','%','0','10.00','no','0.00',NULL,'202603261949','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tea','admin','madmin',NULL,NULL,'',NULL,'10.00','','','','',NULL,'10.00'),(14,'TEA','1.0','10.00','10.00','Item',NULL,NULL,'no',NULL,NULL,'20260326-1-0000110','07:49:53 PM','2026 03 26','admin','1','  Dine-in','  Cash','10.00','10.00','22',NULL,NULL,NULL,NULL,'26 Mar 2026','2026032619:49:53','%','0','10.00','no','0.00',NULL,'202603261949','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tea','admin','madmin',NULL,NULL,'',NULL,'10.00','','','','',NULL,'10.00'),(15,'TEA','1.0','10.00','10.00','Item',NULL,NULL,'no',NULL,NULL,'20260327-1-000011','05:26:29 PM','2026 03 27','admin','1','  Takeaway','  Cash','10.00','10.00','28',NULL,NULL,NULL,NULL,'27 Mar 2026','2026032717:26:29','%','0','10.00','no','0.00',NULL,'202603271726','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tea','admin','madmin',NULL,NULL,'',NULL,'10.00','','','','',NULL,'10.00'),(16,'TEA','1.0','10.00','10.00','Item',NULL,NULL,'no',NULL,NULL,'20260327-1-000012','08:43:38 PM','2026 03 27','admin','1','  Takeaway','  Cash','10.00','10.00','30',NULL,NULL,NULL,NULL,'27 Mar 2026','2026032720:43:38','%','0','10.00','no','0.00',NULL,'202603272043','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tea','admin','madmin',NULL,NULL,'',NULL,'10.00','','','','',NULL,'10.00'),(17,'TEA','1.0','10.00','10.00','Item',NULL,NULL,'no',NULL,NULL,'20260327-1-000013','08:46:51 PM','2026 03 27','admin','1','  Takeaway','  Cash','10.00','10.00','31',NULL,NULL,NULL,NULL,'27 Mar 2026','2026032720:46:51','%','0','10.00','no','0.00',NULL,'202603272046','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tea','admin','madmin',NULL,NULL,'',NULL,'10.00','','','','',NULL,'10.00'),(18,'TEA','1.0','10.00','10.00','Item',NULL,NULL,'no',NULL,NULL,'20260327-1-000014','08:51:03 PM','2026 03 27','admin','1','  Takeaway','  Cash','10.00','10.00','32',NULL,NULL,NULL,NULL,'27 Mar 2026','2026032720:51:03','%','0','10.00','no','0.00',NULL,'202603272051','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tea','admin','madmin',NULL,NULL,'',NULL,'10.00','','','','',NULL,'10.00'),(19,'Parcel Tea','1.0','20.00','20.00','Item',NULL,NULL,'no',NULL,NULL,'20260327-1-000015','08:53:28 PM','2026 03 27','admin','1','  Takeaway','  Cash','35.00','35.00','33',NULL,NULL,NULL,NULL,'27 Mar 2026','2026032720:53:28','%','0','20.00','no','0.00',NULL,'202603272053','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tea','admin','madmin',NULL,NULL,'',NULL,'20.00','','','','',NULL,'20.00'),(20,'Milk Only','1.0','15.00','15.00','Item',NULL,NULL,'no',NULL,NULL,'20260327-1-000015','08:53:28 PM','2026 03 27','admin','1','  Takeaway','  Cash','35.00','35.00','34',NULL,NULL,NULL,NULL,'27 Mar 2026','2026032720:53:28','%','0','15.00','no','0.00',NULL,'202603272053','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tea','admin','madmin',NULL,NULL,'',NULL,'15.00','','','','',NULL,'15.00'),(21,'TEA','2.0','10.00','20.00','Item',NULL,NULL,'no',NULL,NULL,'20260328-1-000011','08:48:52 AM','2026 03 28','admin','1','  Takeaway','  Cash','52.00','52.00','37',NULL,NULL,NULL,NULL,'28 Mar 2026','2026032808:48:52','%','0','20.00','no','0.00',NULL,'202603280848','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tea','admin','madmin',NULL,NULL,'',NULL,'20.00','','','','',NULL,'10.00'),(22,'Samosa','2.0','6.00','12.00','Item',NULL,NULL,'no',NULL,NULL,'20260328-1-000011','08:48:52 AM','2026 03 28','admin','1','  Takeaway','  Cash','52.00','52.00','38',NULL,NULL,NULL,NULL,'28 Mar 2026','2026032808:48:52','%','0','12.00','no','0.00',NULL,'202603280848','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Vadai','admin','madmin',NULL,NULL,'',NULL,'12.00','','','','',NULL,'6.00'),(23,'Boost','1.0','20.00','20.00','Item',NULL,NULL,'no',NULL,NULL,'20260328-1-000011','08:48:52 AM','2026 03 28','admin','1','  Takeaway','  Cash','52.00','52.00','39',NULL,NULL,NULL,NULL,'28 Mar 2026','2026032808:48:52','%','0','20.00','no','0.00',NULL,'202603280848','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tea','admin','madmin',NULL,NULL,'',NULL,'20.00','','','','',NULL,'20.00'),(24,'Parcel Tea','1.0','20.00','20.00','Item',NULL,NULL,'no',NULL,NULL,'20260328-1-000012','08:49:56 AM','2026 03 28','admin','1','  Takeaway','  Cash','50.00','50.00','40',NULL,NULL,NULL,NULL,'28 Mar 2026','2026032808:49:56','%','0','20.00','no','0.00',NULL,'202603280849','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tea','admin','madmin',NULL,NULL,'',NULL,'20.00','','','','',NULL,'20.00'),(25,'Vadai ','5.0','6.00','30.00','Item',NULL,NULL,'no',NULL,NULL,'20260328-1-000012','08:49:56 AM','2026 03 28','admin','1','  Takeaway','  Cash','50.00','50.00','41',NULL,NULL,NULL,NULL,'28 Mar 2026','2026032808:49:56','%','0','30.00','no','0.00',NULL,'202603280849','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Vadai','admin','madmin',NULL,NULL,'',NULL,'30.00','','','','',NULL,'6.00'),(26,'vadai','3.0','6.00','18.00','Item',NULL,NULL,'no',NULL,NULL,'20260328-1-000013','09:03:41 AM','2026 03 28','admin','1','  Takeaway','  Cash','18.00','18.00','47',NULL,NULL,NULL,NULL,'28 Mar 2026','2026032809:03:41','%','0','18.00','no','0.00',NULL,'202603280903','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tea','admin','madmin',NULL,NULL,'',NULL,'18.00','','','','',NULL,'6.00'),(27,'TEA','1.0','10.00','10.00','Item',NULL,NULL,'no',NULL,NULL,'20260328-1-000014','09:06:03 AM','2026 03 28','admin','1','  Takeaway','  Cash','40.00','40.00','48',NULL,NULL,NULL,NULL,'28 Mar 2026','2026032809:06:03','%','0','10.00','no','0.00',NULL,'202603280906','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tea','admin','madmin',NULL,NULL,'',NULL,'10.00','','','','',NULL,'10.00'),(28,'vadai','5.0','6.00','30.00','Item',NULL,NULL,'no',NULL,NULL,'20260328-1-000014','09:06:03 AM','2026 03 28','admin','1','  Takeaway','  Cash','40.00','40.00','49',NULL,NULL,NULL,NULL,'28 Mar 2026','2026032809:06:03','%','0','30.00','no','0.00',NULL,'202603280906','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tea','admin','madmin',NULL,NULL,'',NULL,'30.00','','','','',NULL,'6.00'),(29,'Coffee','1.0','15.00','15.00','Item',NULL,NULL,'no',NULL,NULL,'20260328-1-000015','09:06:32 AM','2026 03 28','admin','1','  Takeaway','  Cash','15.00','15.00','50',NULL,NULL,NULL,NULL,'28 Mar 2026','2026032809:06:32','%','0','15.00','no','0.00',NULL,'202603280906','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tea','admin','madmin',NULL,NULL,'',NULL,'15.00','','','','',NULL,'15.00'),(30,'TEA','2.0','10.00','20.00','Item',NULL,NULL,'no',NULL,NULL,'20260328-1-000016','09:11:55 AM','2026 03 28','admin','1','  Takeaway','  Cash','26.00','26.00','51',NULL,NULL,NULL,NULL,'28 Mar 2026','2026032809:11:55','%','0','20.00','no','0.00',NULL,'202603280911','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tea','admin','madmin',NULL,NULL,'',NULL,'20.00','','','','',NULL,'10.00'),(31,'vadai','1.0','6.00','6.00','Item',NULL,NULL,'no',NULL,NULL,'20260328-1-000016','09:11:55 AM','2026 03 28','admin','1','  Takeaway','  Cash','26.00','26.00','52',NULL,NULL,NULL,NULL,'28 Mar 2026','2026032809:11:55','%','0','6.00','no','0.00',NULL,'202603280911','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tea','admin','madmin',NULL,NULL,'',NULL,'6.00','','','','',NULL,'6.00'),(32,'vadai','2.0','6.00','12.00','Item',NULL,NULL,'no',NULL,NULL,'20260328-1-000017','09:12:33 AM','2026 03 28','admin','1','  Takeaway','  Cash','12.00','12.00','53',NULL,NULL,NULL,NULL,'28 Mar 2026','2026032809:12:33','%','0','12.00','no','0.00',NULL,'202603280912','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tea','admin','madmin',NULL,NULL,'',NULL,'12.00','','','','',NULL,'6.00'),(33,'TEA','2.0','10.00','20.00','Item',NULL,NULL,'no',NULL,NULL,'20260328-1-000018','09:13:22 AM','2026 03 28','admin','1','  Takeaway','  Cash','26.00','26.00','54',NULL,NULL,NULL,NULL,'28 Mar 2026','2026032809:13:22','%','0','20.00','no','0.00',NULL,'202603280913','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tea','admin','madmin',NULL,NULL,'',NULL,'20.00','','','','',NULL,'10.00'),(34,'vadai','1.0','6.00','6.00','Item',NULL,NULL,'no',NULL,NULL,'20260328-1-000018','09:13:22 AM','2026 03 28','admin','1','  Takeaway','  Cash','26.00','26.00','55',NULL,NULL,NULL,NULL,'28 Mar 2026','2026032809:13:22','%','0','6.00','no','0.00',NULL,'202603280913','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tea','admin','madmin',NULL,NULL,'',NULL,'6.00','','','','',NULL,'6.00'),(35,'TEA','2.0','10.00','20.00','Item',NULL,NULL,'no',NULL,NULL,'20260328-1-000019','09:14:01 AM','2026 03 28','admin','1','  Takeaway','  Cash','20.00','20.00','56',NULL,NULL,NULL,NULL,'28 Mar 2026','2026032809:14:01','%','0','20.00','no','0.00',NULL,'202603280914','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tea','admin','madmin',NULL,NULL,'',NULL,'20.00','','','','',NULL,'10.00'),(36,'TEA','2.0','10.00','20.00','Item',NULL,NULL,'no',NULL,NULL,'20260328-1-0000110','09:14:30 AM','2026 03 28','admin','1','  Takeaway','  Cash','38.00','38.00','57',NULL,NULL,NULL,NULL,'28 Mar 2026','2026032809:14:30','%','0','20.00','no','0.00',NULL,'202603280914','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tea','admin','madmin',NULL,NULL,'',NULL,'20.00','','','','',NULL,'10.00'),(37,'vadai','3.0','6.00','18.00','Item',NULL,NULL,'no',NULL,NULL,'20260328-1-0000110','09:14:30 AM','2026 03 28','admin','1','  Takeaway','  Cash','38.00','38.00','58',NULL,NULL,NULL,NULL,'28 Mar 2026','2026032809:14:30','%','0','18.00','no','0.00',NULL,'202603280914','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tea','admin','madmin',NULL,NULL,'',NULL,'18.00','','','','',NULL,'6.00'),(38,'vadai','18.0','6.00','108.00','Item',NULL,NULL,'no',NULL,NULL,'20260328-1-0000111','09:18:53 AM','2026 03 28','admin','1','  Takeaway','  Cash','108.00','108.00','59',NULL,NULL,NULL,NULL,'28 Mar 2026','2026032809:18:53','%','0','108.00','no','0.00',NULL,'202603280918','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tea','admin','madmin',NULL,NULL,'',NULL,'108.00','','','','',NULL,'6.00'),(39,'TEA','3.0','10.00','30.00','Item',NULL,NULL,'no',NULL,NULL,'20260328-1-0000112','10:53:51 AM','2026 03 28','admin','1','  Takeaway','  Cash','66.00','66.00','60',NULL,NULL,NULL,NULL,'28 Mar 2026','2026032810:53:51','%','0','40.00','no','0.00',NULL,'202603281053','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tea','admin','madmin',NULL,NULL,'',NULL,'30.00','','','','',NULL,'10.00'),(40,'Vadai ','6.0','6.00','36.00','Item',NULL,NULL,'no',NULL,NULL,'20260328-1-0000112','10:53:51 AM','2026 03 28','admin','1','  Takeaway','  Cash','66.00','66.00','61',NULL,NULL,NULL,NULL,'28 Mar 2026','2026032810:53:51','%','0','36.00','no','0.00',NULL,'202603281053','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Vadai','admin','madmin',NULL,NULL,'',NULL,'36.00','','','','',NULL,'6.00'),(41,'TEA','1.0','10.00','10.00','Item',NULL,NULL,'no',NULL,NULL,'20260328-1-0000113','11:54:52 AM','2026 03 28','admin','1','  Takeaway','  Cash','10.00','10.00','66',NULL,NULL,NULL,NULL,'28 Mar 2026','2026032811:54:52','%','0','10.00','no','0.00',NULL,'202603281154','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tea','admin','madmin',NULL,NULL,'',NULL,'10.00','','','','',NULL,'10.00'),(42,'Parcel ','1.0','30.00','30.00','Item',NULL,NULL,'no',NULL,NULL,'20260328-1-0000114','12:05:46 PM','2026 03 28','admin','1','  Takeaway','  Cash','30.00','30.00','77',NULL,NULL,NULL,NULL,'28 Mar 2026','2026032812:05:46','%','0','30.00','no','0.00',NULL,'202603281205','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tea','admin','madmin',NULL,NULL,'',NULL,'30.00','','','','',NULL,'30.00'),(43,'Parcel Tea','1.0','20.00','20.00','Item',NULL,NULL,'no',NULL,NULL,'20260328-1-0000115','12:15:05 PM','2026 03 28','admin','1','  Takeaway','  Cash','20.00','20.00','78',NULL,NULL,NULL,NULL,'28 Mar 2026','2026032812:15:05','%','0','20.00','no','0.00',NULL,'202603281215','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tea','admin','madmin',NULL,NULL,'',NULL,'20.00','','','','',NULL,'20.00'),(44,'Chocolate 5','1.0','5.00','5.00','Item',NULL,NULL,'no',NULL,NULL,'20260328-1-0000116','12:16:11 PM','2026 03 28','admin','1','  Takeaway','  Cash','5.00','5.00','79',NULL,NULL,NULL,NULL,'28 Mar 2026','2026032812:16:11','%','0','5.00','no','0.00',NULL,'202603281216','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Chocolate','admin','madmin',NULL,NULL,'',NULL,'5.00','','','','',NULL,'5.00'),(45,'Parcel ','1.0','30.00','30.00','Item',NULL,NULL,'no',NULL,NULL,'20260328-1-0000117','12:30:08 PM','2026 03 28','admin','1','  Takeaway','  Cash','30.00','30.00','80',NULL,NULL,NULL,NULL,'28 Mar 2026','2026032812:30:08','%','0','30.00','no','0.00',NULL,'202603281230','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tea','admin','madmin',NULL,NULL,'',NULL,'30.00','','','','',NULL,'30.00'),(46,'Egg Buffs','1.0','25.00','25.00','Item',NULL,NULL,'no',NULL,NULL,'20260328-1-0000118','02:02:36 PM','2026 03 28','admin','1','  Takeaway','  Cash','55.00','55.00','82',NULL,NULL,NULL,NULL,'28 Mar 2026','2026032814:02:36','%','0','25.00','no','0.00',NULL,'202603281402','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'BAKERY','admin','madmin',NULL,NULL,'',NULL,'25.00','','','','',NULL,'25.00'),(47,'Chicken Roll','1.0','30.00','30.00','Item',NULL,NULL,'no',NULL,NULL,'20260328-1-0000118','02:02:36 PM','2026 03 28','admin','1','  Takeaway','  Cash','55.00','55.00','83',NULL,NULL,NULL,NULL,'28 Mar 2026','2026032814:02:36','%','0','30.00','no','0.00',NULL,'202603281402','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'BAKERY','admin','madmin',NULL,NULL,'',NULL,'30.00','','','','',NULL,'30.00'),(48,'Ice Cream 50','1.0','50.00','50.00','Item',NULL,NULL,'no',NULL,NULL,'20260329-1-000011','09:44:23 AM','2026 03 29','admin','1','  Takeaway','  Cash','160.00','160.00','91',NULL,NULL,NULL,NULL,'29 Mar 2026','2026032909:44:23','%','0','50.00','no','0.00',NULL,'202603290944','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Ice cream','admin','madmin',NULL,NULL,'',NULL,'50.00','','','','',NULL,'50.00'),(49,'Ice Cream 30','1.0','30.00','30.00','Item',NULL,NULL,'no',NULL,NULL,'20260329-1-000011','09:44:23 AM','2026 03 29','admin','1','  Takeaway','  Cash','160.00','160.00','92',NULL,NULL,NULL,NULL,'29 Mar 2026','2026032909:44:23','%','0','30.00','no','0.00',NULL,'202603290944','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Ice cream','admin','madmin',NULL,NULL,'',NULL,'30.00','','','','',NULL,'30.00'),(50,'Parcel Tea','1.0','20.00','20.00','Item',NULL,NULL,'no',NULL,NULL,'20260329-1-000011','09:44:23 AM','2026 03 29','admin','1','  Takeaway','  Cash','160.00','160.00','93',NULL,NULL,NULL,NULL,'29 Mar 2026','2026032909:44:23','%','0','20.00','no','0.00',NULL,'202603290944','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tea','admin','madmin',NULL,NULL,'',NULL,'20.00','','','','',NULL,'20.00'),(51,'Chocolate 20','2.0','20.00','40.00','Item',NULL,NULL,'no',NULL,NULL,'20260329-1-000011','09:44:23 AM','2026 03 29','admin','1','  Takeaway','  Cash','160.00','160.00','94',NULL,NULL,NULL,NULL,'29 Mar 2026','2026032909:44:23','%','0','40.00','no','0.00',NULL,'202603290944','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Chocolate','admin','madmin',NULL,NULL,'',NULL,'40.00','','','','',NULL,'20.00'),(52,'Biscuit 10','2.0','10.00','20.00','Item',NULL,NULL,'no',NULL,NULL,'20260329-1-000011','09:44:23 AM','2026 03 29','admin','1','  Takeaway','  Cash','160.00','160.00','95',NULL,NULL,NULL,NULL,'29 Mar 2026','2026032909:44:23','%','0','20.00','no','0.00',NULL,'202603290944','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'BISCUITS','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,'20260326-1-000011','60.00','admin','2026 03 26','  Cash','  Dine-in','60.00','0.00','0.00','0.0','1','202603261146',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(2,'20260326-1-000012','20.00','admin','2026 03 26','  Cash','  Dine-in','20.00','0.00','0.00','0.0','2','202603261158',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(3,'20260326-1-000013','60.00','admin','2026 03 26','  Upiqr','  Dine-in','60.00','0.00','0.00','0.0','3','202603261216',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(4,'20260326-1-000014','10.00','admin','2026 03 26','  Upiqr','  Dine-in','10.00','0.00','0.00','0.0','4','202603261217',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(5,'20260326-1-000015','10.00','admin','2026 03 26','  Cash','  Dine-in','10.00','0.00','0.00','0.0','5','202603261218',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(6,'20260326-1-000016','90.00','admin','2026 03 26','  Cash','  Dine-in','90.00','0.00','0.00','0.0','6','202603261944',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(7,'20260326-1-000017','10.00','admin','2026 03 26','  Cash','  Dine-in','10.00','0.00','0.00','0.0','7','202603261945',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(8,'20260326-1-000018','10.00','admin','2026 03 26','  Cash','  Dine-in','10.00','0.00','0.00','0.0','8','202603261949',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(9,'20260326-1-000019','10.00','admin','2026 03 26','  Cash','  Dine-in','10.00','0.00','0.00','0.0','9','202603261949',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(10,'20260326-1-0000110','10.00','admin','2026 03 26','  Cash','  Dine-in','10.00','0.00','0.00','0.0','10','202603261949',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(11,'20260327-1-000011','10.00','admin','2026 03 27','  Cash','  Takeaway','10.00','0.00','0.00','0.0','11','202603271726',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(12,'20260327-1-000012','10.00','admin','2026 03 27','  Cash','  Takeaway','10.00','0.00','0.00','0.0','12','202603272043',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(13,'20260327-1-000013','10.00','admin','2026 03 27','  Cash','  Takeaway','10.00','0.00','0.00','0.0','13','202603272046',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(14,'20260327-1-000014','10.00','admin','2026 03 27','  Cash','  Takeaway','10.00','0.00','0.00','0.0','14','202603272051',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(15,'20260327-1-000015','35.00','admin','2026 03 27','  Cash','  Takeaway','35.00','0.00','0.00','0.0','15','202603272053',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(16,'20260328-1-000011','52.00','admin','2026 03 28','  Cash','  Takeaway','52.00','0.00','0.00','0.0','16','202603280848',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(17,'20260328-1-000012','50.00','admin','2026 03 28','  Cash','  Takeaway','50.00','0.00','0.00','0.0','17','202603280849',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(18,'20260328-1-000013','18.00','admin','2026 03 28','  Cash','  Takeaway','18.00','0.00','0.00','0.0','18','202603280903',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(19,'20260328-1-000014','40.00','admin','2026 03 28','  Cash','  Takeaway','40.00','0.00','0.00','0.0','19','202603280906',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(20,'20260328-1-000015','15.00','admin','2026 03 28','  Cash','  Takeaway','15.00','0.00','0.00','0.0','20','202603280906',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(21,'20260328-1-000016','26.00','admin','2026 03 28','  Cash','  Takeaway','26.00','0.00','0.00','0.0','21','202603280911',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(22,'20260328-1-000017','12.00','admin','2026 03 28','  Cash','  Takeaway','12.00','0.00','0.00','0.0','22','202603280912',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(23,'20260328-1-000018','26.00','admin','2026 03 28','  Cash','  Takeaway','26.00','0.00','0.00','0.0','23','202603280913',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(24,'20260328-1-000019','20.00','admin','2026 03 28','  Cash','  Takeaway','20.00','0.00','0.00','0.0','24','202603280914',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(25,'20260328-1-0000110','38.00','admin','2026 03 28','  Cash','  Takeaway','38.00','0.00','0.00','0.0','25','202603280914',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(26,'20260328-1-0000111','108.00','admin','2026 03 28','  Cash','  Takeaway','108.00','0.00','0.00','0.0','26','202603280918',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(27,'20260328-1-0000112','66.00','admin','2026 03 28','  Cash','  Takeaway','66.00','0.00','0.00','0.0','27','202603281053',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(28,'20260328-1-0000113','10.00','admin','2026 03 28','  Cash','  Takeaway','10.00','0.00','0.00','0.0','28','202603281154',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(29,'20260328-1-0000114','30.00','admin','2026 03 28','  Cash','  Takeaway','30.00','0.00','0.00','0.0','29','202603281205',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(30,'20260328-1-0000115','20.00','admin','2026 03 28','  Cash','  Takeaway','20.00','0.00','0.00','0.0','30','202603281215',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(31,'20260328-1-0000116','5.00','admin','2026 03 28','  Cash','  Takeaway','5.00','0.00','0.00','0.0','31','202603281216',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(32,'20260328-1-0000117','30.00','admin','2026 03 28','  Cash','  Takeaway','30.00','0.00','0.00','0.0','32','202603281230',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(33,'20260328-1-0000118','55.00','admin','2026 03 28','  Cash','  Takeaway','55.00','0.00','0.00','0.0','33','202603281402',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(34,'20260329-1-000011','160.00','admin','2026 03 29','  Cash','  Takeaway','160.00','0.00','0.00','0.0','34','202603290944',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,'');
INSERT INTO `clicked_cust_name` (`_id`, `name`) VALUES (1,'');
INSERT INTO `itemdata` (`_id`, `itemname`, `total`) VALUES (1,'TEA',20),(2,'Tea',80),(3,'dosa',35),(4,'idly',25);
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,NULL,'TEA',20,13,'2','TEA',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(2,'1','Tea',80,50,'8','TEA',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(3,'1','dosa',35,22,'1','Tiffin',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(4,'1','idly',25,16,'1','Tiffin',NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO `top_category` (`_id`, `category`, `value`) VALUES (3,'TEA',100),(4,'Tiffin',60);
INSERT INTO `userdata` (`_id`, `username`, `total`) VALUES (1,'admin',160);
INSERT INTO `userwiseorderlistitems` (`_id`, `username`, `sales`, `salespercentage`) VALUES (1,'madmin',160,100);
