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,'poori','1','35.00','35.00','Item','null','null','no','null','None','20240924-1-000011','3:21:41 PM','2024 09 24','madmin','1','  Dine-in','  UpiQr','0','0','5','null','null','null','null','24Sep24','2024092403:21:41','%','0','','','','test','2024092403:21:41','','null','null','null','null','null','null','null','null','Tiffin','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(2,'idly','1','25.00','25.00','Item','null','null','no','null','None','20240924-1-000012','3:30:06 PM','2024 09 24','madmin','1','  Dine-in','  cash','0','0','1','null','null','null','null','24Sep24','2024092403:30:006','%','0','','','','test','2024092403:30:006','','null','null','null','null','null','null','null','null','Tiffin','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(3,'idly','1','25.00','25.00','Item','null','null','no','null','None','20240924-1-000013','3:33:24 PM','2024 09 24','madmin','1','  Dine-in','  cash','0','0','1','null','null','null','null','24Sep24','2024092403:33:24','%','0','','','','test','2024092403:33:24','','null','null','null','null','null','null','null','null','Tiffin','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(4,'dosa','1','35.00','35.00','Item','null','null','no','null','None','20240924-1-000013','3:33:24 PM','2024 09 24','madmin','1','  Dine-in','  cash','0','0','2','null','null','null','null','24Sep24','2024092403:33:24','%','0','','','','test','2024092403:33:24','','null','null','null','null','null','null','null','null','Tiffin','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(5,'pongal','1','30.00','30.00','Item','null','null','no','null','None','20240924-1-000013','3:33:24 PM','2024 09 24','madmin','1','  Dine-in','  cash','0','0','3','null','null','null','null','24Sep24','2024092403:33:24','%','0','','','','test','2024092403:33:24','','null','null','null','null','null','null','null','null','Tiffin','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(6,'idly','1','25.00','25.00','Item','null','null','no','null','None','20240924-1-000014','5:11:34 PM','2024 09 24','madmin','1','  Dine-in','  cash','0','0','1','null','null','null','null','24Sep24','2024092405:11:34','%','0','','','','test','2024092405:11:34','','null','null','null','null','null','null','null','null','Tiffin','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(7,'dosa','1','35.00','35.00','Item','null','null','no','null','None','20240924-1-000014','5:11:34 PM','2024 09 24','madmin','1','  Dine-in','  cash','0','0','2','null','null','null','null','24Sep24','2024092405:11:34','%','0','','','','test','2024092405:11:34','','null','null','null','null','null','null','null','null','Tiffin','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(8,'poori','1','35.00','35.00','Item','null','null','no','null','None','20240924-1-000015','5:12:36 PM','2024 09 24','madmin','1','  Dine-in','  cash','0','0','5','null','null','null','null','24Sep24','2024092405:12:36','%','0','','','','test','2024092405:12:36','','null','null','null','null','null','null','null','null','Tiffin','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(9,'idly','1','25.00','25.00','Item','null','null','no','null','None','20240924-1-000016','5:45:58 PM','2024 09 24','madmin','1','  Dine-in','  cash','0','0','1','null','null','null','null','24Sep24','2024092405:45:58','%','0','','','','test','2024092405:45:58','','null','null','null','null','null','null','null','null','Tiffin','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(10,'dosa','1','35.00','35.00','Item','null','null','no','null','None','20240924-1-000016','5:45:58 PM','2024 09 24','madmin','1','  Dine-in','  cash','0','0','2','null','null','null','null','24Sep24','2024092405:45:58','%','0','','','','test','2024092405:45:58','','null','null','null','null','null','null','null','null','Tiffin','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(11,'dosa','1','35.00','35.00','Item','null','null','no','null','None','20240924-1-000017','5:48:16 PM','2024 09 24','madmin','1','  Dine-in','  cash','0','0','2','null','null','null','null','24Sep24','2024092405:48:16','%','0','','','','test','2024092405:48:16','','null','null','null','null','null','null','null','null','Tiffin','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(12,'chicken kabab','1','60.00','60.00','Item','null','null','no','null','None','20240924-1-000017','5:48:16 PM','2024 09 24','madmin','1','  Dine-in','  cash','0','0','14','null','null','null','null','24Sep24','2024092405:48:16','%','0','','','','test','2024092405:48:16','','null','null','null','null','null','null','null','null','Snacks','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(13,'pav bhajji','1','60.00','60.00','Item','null','null','no','null','None','20240924-1-000017','5:48:16 PM','2024 09 24','madmin','1','  Dine-in','  cash','0','0','17','null','null','null','null','24Sep24','2024092405:48:16','%','0','','','','test','2024092405:48:16','','null','null','null','null','null','null','null','null','Snacks','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(14,'vada','1','20.00','20.00','Item','null','null','no','null','None','20240924-1-000017','5:48:16 PM','2024 09 24','madmin','1','  Dine-in','  cash','0','0','11','null','null','null','null','24Sep24','2024092405:48:16','%','0','','','','test','2024092405:48:16','','null','null','null','null','null','null','null','null','Snacks','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(15,'grape juice','1','25.00','25.00','Item','null','null','no','null','None','20240925-1-000011','5:08:50 PM','2024 09 25','madmin','1','  Dine-in','  cash','0','0','37','null','null','null','null','25Sep24','2024092505:008:50','%','0','','','','test','2024092505:008:50','','null','null','null','null','null','null','null','null','Drinks','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(16,'vanilla icecream','1','35.00','35.00','Item','null','null','no','null','None','20240925-1-000011','5:08:50 PM','2024 09 25','madmin','1','  Dine-in','  cash','0','0','38','null','null','null','null','25Sep24','2024092505:008:50','%','0','','','','test','2024092505:008:50','','null','null','null','null','null','null','null','null','Desserts','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(17,'masala chai','1','25.00','25.00','Item','null','null','no','null','None','20240925-1-000011','5:08:50 PM','2024 09 25','madmin','1','  Dine-in','  cash','0','0','33','null','null','null','null','25Sep24','2024092505:008:50','%','0','','','','test','2024092505:008:50','','null','null','null','null','null','null','null','null','Drinks','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(18,'soft drinks','1','10.00','10.00','Item','null','null','no','null','None','20240925-1-000011','5:08:50 PM','2024 09 25','madmin','1','  Dine-in','  cash','0','0','34','null','null','null','null','25Sep24','2024092505:008:50','%','0','','','','test','2024092505:008:50','','null','null','null','null','null','null','null','null','Drinks','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(19,'dosa','1','35.00','35.00','Item','null','null','no','null','None','20240925-1-000012','5:14:41 PM','2024 09 25','madmin','1','  Dine-in','  cash','0','0','2','null','null','null','null','25Sep24','2024092505:14:41','%','0','','','','test','2024092505:14:41','','null','null','null','null','null','null','null','null','Tiffin','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(20,'idly','1','25.00','25.00','Item','null','null','no','null','None','20240925-1-000012','5:14:41 PM','2024 09 25','madmin','1','  Dine-in','  cash','0','0','1','null','null','null','null','25Sep24','2024092505:14:41','%','0','','','','test','2024092505:14:41','','null','null','null','null','null','null','null','null','Tiffin','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(21,'vada','1','20.00','20.00','Item','null','null','no','null','None','20240925-1-000012','5:14:41 PM','2024 09 25','madmin','1','  Dine-in','  cash','0','0','11','null','null','null','null','25Sep24','2024092505:14:41','%','0','','','','test','2024092505:14:41','','null','null','null','null','null','null','null','null','Snacks','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(22,'chicken kabab','1','60.00','60.00','Item','null','null','no','null','None','20240925-1-000012','5:14:41 PM','2024 09 25','madmin','1','  Dine-in','  cash','0','0','14','null','null','null','null','25Sep24','2024092505:14:41','%','0','','','','test','2024092505:14:41','','null','null','null','null','null','null','null','null','Snacks','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(23,'chicken 65','1','150.00','150.00','Item','null','null','no','','','20240926-1-000011','12:03:34 PM','2024 09 26','madmin','1','  Dine-in','  cash','0','0','43','null','null','null','null','26Sep24','2024092612:003:34','%','0','','','','test','2024092612:003:34','','','','','','','','','','None','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(24,'chicken 65 biryani','1','165.00','165.00','Item','null','null','no','','','20240926-1-000011','12:03:34 PM','2024 09 26','madmin','1','  Dine-in','  cash','0','0','84','null','null','null','null','26Sep24','2024092612:003:34','%','0','','','','test','2024092612:003:34','','','','','','','','','','None','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(25,'veg Fired Rice Half','1','50.00','50.00','Item','null','null','no','','','20240926-1-000011','12:03:34 PM','2024 09 26','madmin','1','  Dine-in','  cash','0','0','2','null','null','null','null','26Sep24','2024092612:003:34','%','0','','','','test','2024092612:003:34','','','','','','','','','','None','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(26,'fish meals','1','120.00','120.00','Item','null','null','no','','','20240926-1-000012','1:50:08 PM','2024 09 26','madmin','1','  Dine-in','  cash','0','0','86','null','null','null','null','26Sep24','2024092601:50:008','%','0','','','','test','2024092601:50:008','','','','','','','','','','None','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(27,'veg Fired Rice Half','1','50.00','50.00','Item','null','null','no','','','20240926-1-000012','1:50:08 PM','2024 09 26','madmin','1','  Dine-in','  cash','0','0','2','null','null','null','null','26Sep24','2024092601:50:008','%','0','','','','test','2024092601:50:008','','','','','','','','','','None','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(28,'chicken 65','1','150.00','150.00','Item','null','null','no','','','20240926-1-000013','3:18:53 PM','2024 09 26','madmin','1','  Dine-in','  cash','0','0','43','null','null','null','null','26Sep24','2024092603:18:53','%','0','','','','test','2024092603:18:53','','','','','','','','','','None','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(29,'chicken dum biryani','1','165.00','165.00','Item','null','null','no','','','20240926-1-000014','3:52:25 PM','2024 09 26','madmin','1','  Dine-in','  cash','0','0','81','null','null','null','null','26Sep24','2024092603:52:25','%','0','','','','test','2024092603:52:25','','','','','','','','','','None','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(30,'fish meals','1','120.00','120.00','Item','null','null','no','','','20240926-1-000014','3:52:25 PM','2024 09 26','madmin','1','  Dine-in','  cash','0','0','86','null','null','null','null','26Sep24','2024092603:52:25','%','0','','','','test','2024092603:52:25','','','','','','','','','','None','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(31,'paneer 65','1','100.00','100.00','Item','null','null','no','','','20240926-1-000015','3:54:37 PM','2024 09 26','madmin','1','  Dine-in','  cash','0','0','37','null','null','null','null','26Sep24','2024092603:54:37','%','0','','','','test','2024092603:54:37','','','','','','','','','','None','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(32,'chicken dum biryani','1','165.00','165.00','Item','null','null','no','','','20240926-1-000016','7:48:20 PM','2024 09 26','madmin','1','  Dine-in','  cash','0','0','81','null','null','null','null','26Sep24','2024092607:48:20','%','0','','','','test','2024092607:48:20','','','','','','','','','','None','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(33,'chilly chicken half','1','80.00','80.00','Item','null','null','no','','','20240926-1-000016','7:48:20 PM','2024 09 26','madmin','1','  Dine-in','  cash','0','0','40','null','null','null','null','26Sep24','2024092607:48:20','%','0','','','','test','2024092607:48:20','','','','','','','','','','None','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(34,'chicken noodles full','2','130.00','260','Item','null','null','no','','','20240926-1-000017','7:49:37 PM','2024 09 26','madmin','1','  Dine-in','  cash','0','0','19','null','null','null','null','26Sep24','2024092607:49:37','%','0','','','','test','2024092607:49:37','','','','','','','','','','None','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(35,'chicken dum biryani full','1','165.00','165.00','Item','null','null','no','','','20240926-1-000018','9:05:49 PM','2024 09 26','madmin','1','  Dine-in','  cash','0','0','81','null','null','null','null','26Sep24','2024092609:005:49','%','0','','','','test','2024092609:005:49','','','','','','','','','','None','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(36,'chicken dum biryani half','1','85.00','85.00','Item','null','null','no','','','20240926-1-000019','9:28:53 PM','2024 09 26','madmin','1','  Dine-in','  UpiQr','0','0','87','null','null','null','null','26Sep24','2024092609:28:53','%','0','','','','test','2024092609:28:53','','','','','','','','','','None','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(37,'chicken dum biryani half','2','85.00','170','Item','null','null','no','','','20240926-1-0000110','10:39:02 PM','2024 09 26','madmin','1','  Dine-in','  cash','0','0','87','null','null','null','null','26Sep24','2024092610:39:002','%','0','','','','test','2024092610:39:002','','','','','','','','','','None','madmin','madmin','null','','','test','test','test','test','test','test',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`, `order_id`) VALUES (1,'20240924-1-000011','35.00','madmin','2024 09 24','  UpiQr','  Dine-in','35.000000','0.000000','0.000000','0','','202409241521','','','','0','0',NULL),(2,'20240924-1-000012','25.00','madmin','2024 09 24','  cash','  Dine-in','25.000000','0.000000','0.000000','0','1','202409241530','','','','0','0',NULL),(3,'20240924-1-000013','90.00','madmin','2024 09 24','  cash','  Dine-in','90.000000','0.000000','0.000000','0','2','202409241533','','','','0','0',NULL),(4,'20240924-1-000014','60.00','madmin','2024 09 24','  cash','  Dine-in','60.000000','0.000000','0.000000','0','3','202409241711','','','','0','0',NULL),(5,'20240924-1-000015','35.00','madmin','2024 09 24','  cash','  Dine-in','35.000000','0.000000','0.000000','0','4','202409241712','','','','0','0',NULL),(6,'20240924-1-000016','60.00','madmin','2024 09 24','  cash','  Dine-in','60.000000','0.000000','0.000000','0','5','202409241745','','','','0','0',NULL),(7,'20240924-1-000017','175.00','madmin','2024 09 24','  cash','  Dine-in','175.000000','0.000000','0.000000','0','6','202409241748','','','','0','0',NULL),(8,'20240925-1-000011','95.00','madmin','2024 09 25','  cash','  Dine-in','95.000000','0.000000','0.000000','0','7','20240925170008','','','','0','0',NULL),(9,'20240925-1-000012','140.00','madmin','2024 09 25','  cash','  Dine-in','140.000000','0.000000','0.000000','0','8','202409251714','','','','0','0',NULL),(10,'20240926-1-000011','365.00','madmin','2024 09 26','  cash','  Dine-in','365.000000','0.000000','0.000000','0','9','20240926120003','','','','0','0',NULL),(11,'20240926-1-000012','170.00','madmin','2024 09 26','  cash','  Dine-in','170.000000','0.000000','0.000000','0','10','202409261350','','','','0','0',NULL),(12,'20240926-1-000013','150.00','madmin','2024 09 26','  cash','  Dine-in','150.000000','0.000000','0.000000','0','11','202409261518','','','','0','0',NULL),(13,'20240926-1-000014','285.00','madmin','2024 09 26','  cash','  Dine-in','285.000000','0.000000','0.000000','0','12','202409261552','','','','0','0',NULL),(14,'20240926-1-000015','100.00','madmin','2024 09 26','  cash','  Dine-in','100.000000','0.000000','0.000000','0','13','202409261554','','','','0','0',NULL),(15,'20240926-1-000016','245.00','madmin','2024 09 26','  cash','  Dine-in','245.000000','0.000000','0.000000','0','14','202409261948','','','','0','0',NULL),(16,'20240926-1-000017','260.00','madmin','2024 09 26','  cash','  Dine-in','260.000000','0.000000','0.000000','0','15','202409261949','','','','0','0',NULL),(17,'20240926-1-000018','165.00','madmin','2024 09 26','  cash','  Dine-in','165.000000','0.000000','0.000000','0','16','20240926210005','','','','0','0',NULL),(18,'20240926-1-000019','85.00','madmin','2024 09 26','  UpiQr','  Dine-in','85.000000','0.000000','0.000000','0','17','202409262128','','','','0','0',NULL),(19,'20240926-1-0000110','170.00','madmin','2024 09 26','  cash','  Dine-in','170.000000','0.000000','0.000000','0','18','202409262239','','','','0','0',NULL);
INSERT INTO `clicked_cust_name` (`_id`, `name`) VALUES (1,'');
INSERT INTO `discountdetails` (`_id`, `date`, `time`, `billno`, `Discountcodeno`, `Discount_percent`, `Billamount_rupess`, `Discount_rupees`, `date1`, `original_amount`, `billcount`, `datetimee_new`, `paymentmethod`) VALUES (1,NULL,NULL,'20240924-1-000011',NULL,'0',NULL,'0',NULL,NULL,NULL,NULL,NULL),(2,NULL,NULL,'20240924-1-000012',NULL,'0',NULL,'0',NULL,NULL,NULL,NULL,NULL),(3,NULL,NULL,'20240924-1-000013',NULL,'0',NULL,'0',NULL,NULL,NULL,NULL,NULL),(4,NULL,NULL,'20240924-1-000014',NULL,'0',NULL,'0',NULL,NULL,NULL,NULL,NULL),(5,NULL,NULL,'20240924-1-000015',NULL,'0',NULL,'0',NULL,NULL,NULL,NULL,NULL),(6,NULL,NULL,'20240924-1-000016',NULL,'0',NULL,'0',NULL,NULL,NULL,NULL,NULL),(7,NULL,NULL,'20240924-1-000017',NULL,'0',NULL,'0',NULL,NULL,NULL,NULL,NULL),(8,NULL,NULL,'20240925-1-000011',NULL,'0',NULL,'0',NULL,NULL,NULL,NULL,NULL),(9,NULL,NULL,'20240925-1-000012',NULL,'0',NULL,'0',NULL,NULL,NULL,NULL,NULL),(10,NULL,NULL,'20240926-1-000011',NULL,'0',NULL,'0',NULL,NULL,NULL,NULL,NULL),(11,NULL,NULL,'20240926-1-000012',NULL,'0',NULL,'0',NULL,NULL,NULL,NULL,NULL),(12,NULL,NULL,'20240926-1-000013',NULL,'0',NULL,'0',NULL,NULL,NULL,NULL,NULL),(13,NULL,NULL,'20240926-1-000014',NULL,'0',NULL,'0',NULL,NULL,NULL,NULL,NULL),(14,NULL,NULL,'20240926-1-000015',NULL,'0',NULL,'0',NULL,NULL,NULL,NULL,NULL),(15,NULL,NULL,'20240926-1-000016',NULL,'0',NULL,'0',NULL,NULL,NULL,NULL,NULL),(16,NULL,NULL,'20240926-1-000017',NULL,'0',NULL,'0',NULL,NULL,NULL,NULL,NULL),(17,NULL,NULL,'20240926-1-000018',NULL,'0',NULL,'0',NULL,NULL,NULL,NULL,NULL),(18,NULL,NULL,'20240926-1-000019',NULL,'0',NULL,'0',NULL,NULL,NULL,NULL,NULL),(19,NULL,NULL,'20240926-1-0000110',NULL,'0',NULL,'0',NULL,NULL,NULL,NULL,NULL);
