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,'20240124-1-000011','10:44:19 AM','2024 01 24','admin','1','  Dine-in','  Cash','25.00','25.00','2',NULL,NULL,NULL,NULL,'24 Jan 2024','2024012410:44:19','%','0','25.00','no','0.00',NULL,'202401241044','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(2,'pani puri','2.0','35.00','70.00','Item',NULL,NULL,'no',NULL,NULL,'20240124-1-000012','10:44:50 AM','2024 01 24','admin','1','  Dine-in','  Cash','270.00','270.00','3',NULL,NULL,NULL,NULL,'24 Jan 2024','2024012410:44:50','%','0','70.00','no','0.00',NULL,'202401241044','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Snacks','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(3,'pav bhajji','2.0','60.00','120.00','Item',NULL,NULL,'no',NULL,NULL,'20240124-1-000012','10:44:50 AM','2024 01 24','admin','1','  Dine-in','  Cash','270.00','270.00','4',NULL,NULL,NULL,NULL,'24 Jan 2024','2024012410:44:50','%','0','120.00','no','0.00',NULL,'202401241044','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Snacks','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(4,'veg cutlet','2.0','40.00','80.00','Item',NULL,NULL,'no',NULL,NULL,'20240124-1-000012','10:44:50 AM','2024 01 24','admin','1','  Dine-in','  Cash','270.00','270.00','5',NULL,NULL,NULL,NULL,'24 Jan 2024','2024012410:44:50','%','0','80.00','no','0.00',NULL,'202401241044','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Snacks','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(5,'onion dosa','2.0','35.00','70.00','Item',NULL,NULL,'no',NULL,NULL,'20240124-1-000013','10:46:06 AM','2024 01 24','admin','1','  Dine-in','  Cash','220.00','220.00','6',NULL,NULL,NULL,NULL,'24 Jan 2024','2024012410:46:06','%','0','70.00','no','0.00',NULL,'202401241046','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(6,'bread omlette','3.0','30.00','90.00','Item',NULL,NULL,'no',NULL,NULL,'20240124-1-000013','10:46:06 AM','2024 01 24','admin','1','  Dine-in','  Cash','220.00','220.00','7',NULL,NULL,NULL,NULL,'24 Jan 2024','2024012410:46:06','%','0','90.00','no','0.00',NULL,'202401241046','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(7,'vada','3.0','20.00','60.00','Item',NULL,NULL,'no',NULL,NULL,'20240124-1-000013','10:46:06 AM','2024 01 24','admin','1','  Dine-in','  Cash','220.00','220.00','8',NULL,NULL,NULL,NULL,'24 Jan 2024','2024012410:46:06','%','0','60.00','no','0.00',NULL,'202401241046','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Snacks','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(8,'chicken biriyani','2.0','100.00','200.00','Item',NULL,NULL,'no',NULL,NULL,'20240124-1-000014','10:52:14 AM','2024 01 24','admin','1','  Dine-in','  Cash','210.00','210.00','9',NULL,NULL,NULL,NULL,'24 Jan 2024','2024012410:52:14','%','0','200.00','no','0.00',NULL,'202401241052','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Main course','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(9,'soft drinks','1.0','10.00','10.00','Item',NULL,NULL,'no',NULL,NULL,'20240124-1-000014','10:52:14 AM','2024 01 24','admin','1','  Dine-in','  Cash','210.00','210.00','10',NULL,NULL,NULL,NULL,'24 Jan 2024','2024012410:52:14','%','0','10.00','no','0.00',NULL,'202401241052','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Drinks','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(10,'chicken biriyani','1.0','100.00','100.00','Item',NULL,NULL,'no',NULL,NULL,'20240124-1-000015','10:54:26 AM','2024 01 24','admin','1','  Dine-in','  Cash','145.00','145.00','11',NULL,NULL,NULL,NULL,'24 Jan 2024','2024012410:54:26','%','0','100.00','no','0.00',NULL,'202401241054','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Main course','admin','IMPACT',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(11,'soft drinks','1.0','10.00','10.00','Item',NULL,NULL,'no',NULL,NULL,'20240124-1-000015','10:54:26 AM','2024 01 24','admin','1','  Dine-in','  Cash','145.00','145.00','12',NULL,NULL,NULL,NULL,'24 Jan 2024','2024012410:54:26','%','0','10.00','no','0.00',NULL,'202401241054','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Drinks','admin','IMPACT',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(12,'vanilla icecream','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20240124-1-000015','10:54:26 AM','2024 01 24','admin','1','  Dine-in','  Cash','145.00','145.00','13',NULL,NULL,NULL,NULL,'24 Jan 2024','2024012410:54:26','%','0','35.00','no','0.00',NULL,'202401241054','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Desserts','admin','IMPACT',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(13,'veg cutlet','2.0','40.00','80.00','Item',NULL,NULL,'no',NULL,NULL,'20240124-1-000016','10:55:52 AM','2024 01 24','admin','1','  Dine-in','  Cash','80.00','80.00','14',NULL,NULL,NULL,NULL,'24 Jan 2024','2024012410:55:52','%','0','80.00','no','0.00',NULL,'202401241055','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Snacks','admin','IMPACT',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(14,'idly','2.0','25.00','50.00','Item',NULL,NULL,'no',NULL,NULL,'20240124-1-000017','11:08:28 AM','2024 01 24','admin','1','  Dine-in','  Cash','50.00','50.00','21',NULL,NULL,NULL,NULL,'24 Jan 2024','2024012411:08:28','%','0','50.00','no','0.00',NULL,'202401241108','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','IMPACT',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(15,'idly','4.0','25.00','100.00','Item',NULL,NULL,'no',NULL,NULL,'20240124-1-000018','11:09:51 AM','2024 01 24','admin','1','  Dine-in','  Cash','100.00','100.00','22',NULL,NULL,NULL,NULL,'24 Jan 2024','2024012411:09:51','%','0','100.00','no','0.00',NULL,'202401241109','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','IMPACT',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(16,'masal vada','1.0','20.00','20.00','Item',NULL,NULL,'no',NULL,NULL,'20240124-1-000019','11:11:43 AM','2024 01 24','admin','1','  Dine-in','  Cash','190.00','190.00','23',NULL,NULL,NULL,NULL,'24 Jan 2024','2024012411:11:43','%','0','20.00','no','0.00',NULL,'202401241111','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Snacks','admin','IMPACT',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(17,'samosa','1.0','20.00','20.00','Item',NULL,NULL,'no',NULL,NULL,'20240124-1-000019','11:11:43 AM','2024 01 24','admin','1','  Dine-in','  Cash','190.00','190.00','24',NULL,NULL,NULL,NULL,'24 Jan 2024','2024012411:11:43','%','0','20.00','no','0.00',NULL,'202401241111','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Snacks','admin','IMPACT',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(18,'bread omlette','1.0','30.00','30.00','Item',NULL,NULL,'no',NULL,NULL,'20240124-1-000019','11:11:43 AM','2024 01 24','admin','1','  Dine-in','  Cash','190.00','190.00','26',NULL,NULL,NULL,NULL,'24 Jan 2024','2024012411:11:43','%','0','30.00','no','0.00',NULL,'202401241111','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','IMPACT',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(19,'pav bhajji','2.0','60.00','120.00','Item',NULL,NULL,'no',NULL,NULL,'20240124-1-000019','11:11:43 AM','2024 01 24','admin','1','  Dine-in','  Cash','190.00','190.00','27',NULL,NULL,NULL,NULL,'24 Jan 2024','2024012411:11:43','%','0','120.00','no','0.00',NULL,'202401241111','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Snacks','admin','IMPACT',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(20,'idly','1.0','25.00','25.00','Item',NULL,NULL,'no',NULL,NULL,'20240129-1-000011','08:26:46 AM','2024 01 29','admin','1','  Dine-in','  Cash','25.00','25.00','28',NULL,NULL,NULL,NULL,'29 Jan 2024','2024012908:26:46','%','0','25.00','no','0.00',NULL,'202401290826','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','IMPACT',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(21,'pani puri','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20240129-1-000012','08:33:03 AM','2024 01 29','ladmin','1','  Dine-in','  Cash','35.00','35.00','29',NULL,NULL,NULL,NULL,'29 Jan 2024','2024012908:33:03','%','0','35.00','no','0.00',NULL,'202401290833','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Snacks','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(22,'vada','2.0','20.00','40.00','Item',NULL,NULL,'no',NULL,NULL,'20240129-1-000013','08:35:51 AM','2024 01 29','ladmin','1','  Dine-in','  Cash','90.00','90.00','30',NULL,NULL,NULL,NULL,'29 Jan 2024','2024012908:35:51','%','0','40.00','no','0.00',NULL,'202401290835','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Snacks','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(23,'idly','2.0','25.00','50.00','Item',NULL,NULL,'no',NULL,NULL,'20240129-1-000013','08:35:51 AM','2024 01 29','ladmin','1','  Dine-in','  Cash','90.00','90.00','31',NULL,NULL,NULL,NULL,'29 Jan 2024','2024012908:35:51','%','0','50.00','no','0.00',NULL,'202401290835','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(24,'idly','1.0','25.00','25.00','Item',NULL,NULL,'no',NULL,NULL,'20240129-1-000014','08:46:07 AM','2024 01 29','ladmin','1','  Dine-in','  Cash','65.00','65.00','32',NULL,NULL,NULL,NULL,'29 Jan 2024','2024012908:46:07','%','0','25.00','no','0.00',NULL,'202401290846','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(25,'masal dosa','1.0','40.00','40.00','Item',NULL,NULL,'no',NULL,NULL,'20240129-1-000014','08:46:07 AM','2024 01 29','ladmin','1','  Dine-in','  Cash','65.00','65.00','33',NULL,NULL,NULL,NULL,'29 Jan 2024','2024012908:46:07','%','0','40.00','no','0.00',NULL,'202401290846','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(26,'idly','1','25.00','25.00','Item','null','null','no','','None','20260422-1-000021','2:27:01 PM','2026 04 22','ladmin','2','Dine-in','cash','0','0','1','null','null','null','null','22Apr26','2026042202:27:001','%','0','','','',' ','2026042202:27:001','','','','','','','','','','Tiffin','ladmin','ladmin','null','','',' ','25.00',' ',' ',' ',' ',NULL,'25.00'),(27,'poori','1','35.00','35.00','Item','null','null','no','','None','20260422-1-000021','2:27:01 PM','2026 04 22','ladmin','2','Dine-in','cash','0','0','5','null','null','null','null','22Apr26','2026042202:27:001','%','0','','','',' ','2026042202:27:001','','','','','','','','','','Tiffin','ladmin','ladmin','null','','',' ','35.00',' ',' ',' ',' ',NULL,'35.00'),(28,'masal dosa','1','40.00','40.00','Item','null','null','no','','None','20260422-1-000021','2:27:01 PM','2026 04 22','ladmin','2','Dine-in','cash','0','0','6','null','null','null','null','22Apr26','2026042202:27:001','%','0','','','',' ','2026042202:27:001','','','','','','','','','','Tiffin','ladmin','ladmin','null','','',' ','40.00',' ',' ',' ',' ',NULL,'40.00'),(29,'idly','1.0','25.00','25.00','Item',NULL,NULL,'no',NULL,NULL,'20260423-1-000011','01:20:28 pm','2026 04 23','admin','1','  Dine-in','  Cash','4815.00','4815.00','1',NULL,NULL,NULL,NULL,'23 Apr 2026','2026042313:20:28','%','0','25.00','no','0.00',NULL,'202604231320','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','ladmin','ladmin',NULL,NULL,'',NULL,'25.00','','','','',NULL,'25.00'),(30,'sheekh kabab','1.0','599.00','599.00','Item',NULL,NULL,'no',NULL,NULL,'20260423-1-000011','01:20:28 pm','2026 04 23','admin','1','  Dine-in','  Cash','4815.00','4815.00','2',NULL,NULL,NULL,NULL,'23 Apr 2026','2026042313:20:28','%','0','599.00','no','0.00',NULL,'202604231320','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Snacks','ladmin','ladmin',NULL,NULL,'',NULL,'599.00','','','','',NULL,'599.00'),(31,'chicken kabab','2.0','899.00','1798.00','Item',NULL,NULL,'no',NULL,NULL,'20260423-1-000011','01:20:28 pm','2026 04 23','admin','1','  Dine-in','  Cash','4815.00','4815.00','3',NULL,NULL,NULL,NULL,'23 Apr 2026','2026042313:20:28','%','0','1798.00','no','0.00',NULL,'202604231320','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Snacks','ladmin','ladmin',NULL,NULL,'',NULL,'1798.00','','','','',NULL,'899.00'),(32,'mutton biriyani','2.0','999.00','1998.00','Item',NULL,NULL,'no',NULL,NULL,'20260423-1-000011','01:20:28 pm','2026 04 23','admin','1','  Dine-in','  Cash','4815.00','4815.00','4',NULL,NULL,NULL,NULL,'23 Apr 2026','2026042313:20:28','%','0','1998.00','no','0.00',NULL,'202604231320','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Main course','ladmin','ladmin',NULL,NULL,'',NULL,'1998.00','','','','',NULL,'999.00'),(33,'soft drinks','5.0','79.00','395.00','Item',NULL,NULL,'no',NULL,NULL,'20260423-1-000011','01:20:28 pm','2026 04 23','admin','1','  Dine-in','  Cash','4815.00','4815.00','5',NULL,NULL,NULL,NULL,'23 Apr 2026','2026042313:20:28','%','0','395.00','no','0.00',NULL,'202604231320','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Drinks','ladmin','ladmin',NULL,NULL,'',NULL,'395.00','','','','',NULL,'79.00'),(34,'soft drinks','4.0','79.00','316.00','Item',NULL,NULL,'no',NULL,NULL,'20260423-1-000012','01:21:04 pm','2026 04 23','admin','1','  Dine-in','  Cash','4911.00','4911.00','6',NULL,NULL,NULL,NULL,'23 Apr 2026','2026042313:21:04','%','0','316.00','no','0.00',NULL,'202604231321','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Drinks','ladmin','ladmin',NULL,NULL,'',NULL,'316.00','','','','',NULL,'79.00'),(35,'chicken biriyani','1.0','100.00','100.00','Item',NULL,NULL,'no',NULL,NULL,'20260423-1-000012','01:21:04 pm','2026 04 23','admin','1','  Dine-in','  Cash','4911.00','4911.00','7',NULL,NULL,NULL,NULL,'23 Apr 2026','2026042313:21:04','%','0','100.00','no','0.00',NULL,'202604231321','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Main course','ladmin','ladmin',NULL,NULL,'',NULL,'100.00','','','','',NULL,'100.00'),(36,'mutton biriyani','3.0','999.00','2997.00','Item',NULL,NULL,'no',NULL,NULL,'20260423-1-000012','01:21:04 pm','2026 04 23','admin','1','  Dine-in','  Cash','4911.00','4911.00','8',NULL,NULL,NULL,NULL,'23 Apr 2026','2026042313:21:04','%','0','2997.00','no','0.00',NULL,'202604231321','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Main course','ladmin','ladmin',NULL,NULL,'',NULL,'2997.00','','','','',NULL,'999.00'),(37,'sheekh kabab','1.0','599.00','599.00','Item',NULL,NULL,'no',NULL,NULL,'20260423-1-000012','01:21:04 pm','2026 04 23','admin','1','  Dine-in','  Cash','4911.00','4911.00','9',NULL,NULL,NULL,NULL,'23 Apr 2026','2026042313:21:04','%','0','599.00','no','0.00',NULL,'202604231321','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Snacks','ladmin','ladmin',NULL,NULL,'',NULL,'599.00','','','','',NULL,'599.00'),(38,'chicken kabab','1.0','899.00','899.00','Item',NULL,NULL,'no',NULL,NULL,'20260423-1-000012','01:21:04 pm','2026 04 23','admin','1','  Dine-in','  Cash','4911.00','4911.00','10',NULL,NULL,NULL,NULL,'23 Apr 2026','2026042313:21:04','%','0','899.00','no','0.00',NULL,'202604231321','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Snacks','ladmin','ladmin',NULL,NULL,'',NULL,'899.00','','','','',NULL,'899.00'),(39,'idly','2.0','25.00','50.00','Item',NULL,NULL,'no',NULL,NULL,'20260423-1-000013','01:24:14 PM','2026 04 23','admin','1','  Dine-in','  Cash','50.00','50.00','11',NULL,NULL,NULL,NULL,'23 Apr 2026','2026042313:24:14','%','0','50.00','no','0.00',NULL,'202604231324','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','ladmin','ladmin',NULL,NULL,'',NULL,'50.00','','','','',NULL,'25.00'),(40,'idly','1.0','25.00','25.00','Item',NULL,NULL,'no',NULL,NULL,'20260423-1-000014','01:25:35 pm','2026 04 23','admin','1','  Dine-in','  Cash','65.00','65.00','12',NULL,NULL,NULL,NULL,'23 Apr 2026','2026042313:25:35','%','0','25.00','no','0.00',NULL,'202604231325','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','ladmin','ladmin',NULL,NULL,'',NULL,'25.00','','','','',NULL,'25.00'),(41,'masal vada','2.0','20.00','40.00','Item',NULL,NULL,'no',NULL,NULL,'20260423-1-000014','01:25:35 pm','2026 04 23','admin','1','  Dine-in','  Cash','65.00','65.00','13',NULL,NULL,NULL,NULL,'23 Apr 2026','2026042313:25:35','%','0','40.00','no','0.00',NULL,'202604231325','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Snacks','ladmin','ladmin',NULL,NULL,'',NULL,'40.00','','','','',NULL,'20.00'),(42,'masal vada','1.0','20.00','20.00','Item',NULL,NULL,'no',NULL,NULL,'20260424-1-000011','11:24:36 am','2026 04 24','admin','1','  Dine-in','  Cash','70.00','70.00','14',NULL,NULL,NULL,NULL,'24 Apr 2026','2026042411:24:36','%','0','20.00','no','0.00',NULL,'202604241124','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Snacks','ladmin','ladmin',NULL,NULL,'',NULL,'20.00','','','','',NULL,'20.00'),(43,'idly','2.0','25.00','50.00','Item',NULL,NULL,'no',NULL,NULL,'20260424-1-000011','11:24:36 am','2026 04 24','admin','1','  Dine-in','  Cash','70.00','70.00','15',NULL,NULL,NULL,NULL,'24 Apr 2026','2026042411:24:36','%','0','50.00','no','0.00',NULL,'202604241124','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','ladmin','ladmin',NULL,NULL,'',NULL,'50.00','','','','',NULL,'25.00'),(44,'idly','1.0','25.00','25.00','Item',NULL,NULL,'no',NULL,NULL,'20260424-1-000031','11:25:45 am','2026 04 24','admin','3','  Dine-in','  Cash','90.00','90.00','1',NULL,NULL,NULL,NULL,'24 Apr 2026','2026042411:25:45','%','0','25.00','no','0.00',NULL,'202604241125','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','ladmin','ladmin',NULL,NULL,'',NULL,'25.00','','','','',NULL,'25.00'),(45,'dosa','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20260424-1-000031','11:25:45 am','2026 04 24','admin','3','  Dine-in','  Cash','90.00','90.00','2',NULL,NULL,NULL,NULL,'24 Apr 2026','2026042411:25:45','%','0','35.00','no','0.00',NULL,'202604241125','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','ladmin','ladmin',NULL,NULL,'',NULL,'35.00','','','','',NULL,'35.00'),(46,'pongal','1.0','30.00','30.00','Item',NULL,NULL,'no',NULL,NULL,'20260424-1-000031','11:25:45 am','2026 04 24','admin','3','  Dine-in','  Cash','90.00','90.00','3',NULL,NULL,NULL,NULL,'24 Apr 2026','2026042411:25:45','%','0','30.00','no','0.00',NULL,'202604241125','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','ladmin','ladmin',NULL,NULL,'',NULL,'30.00','','','','',NULL,'30.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,'20240124-1-000011','25.00','admin','2024 01 24','  Cash','  Dine-in','25.00','0.00','0.00','0.0','1','202401241044',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(2,'20240124-1-000012','270.00','admin','2024 01 24','  Cash','  Dine-in','270.00','0.00','0.00','0.0','2','202401241044',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(3,'20240124-1-000013','220.00','admin','2024 01 24','  Cash','  Dine-in','220.00','0.00','0.00','0.0','3','202401241046',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(4,'20240124-1-000014','210.00','admin','2024 01 24','  Cash','  Dine-in','210.00','0.00','0.00','0.0','4','202401241052',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(5,'20240124-1-000015','145.00','admin','2024 01 24','  Cash','  Dine-in','145.00','0.00','0.00','0.0','5','202401241054',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(6,'20240124-1-000016','80.00','admin','2024 01 24','  Cash','  Dine-in','80.00','0.00','0.00','0.0','6','202401241055',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(7,'20240124-1-000017','50.00','admin','2024 01 24','  Cash','  Dine-in','50.00','0.00','0.00','0.0','7','202401241108',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(8,'20240124-1-000018','100.00','admin','2024 01 24','  Cash','  Dine-in','100.00','0.00','0.00','0.0','8','202401241109',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(9,'20240124-1-000019','190.00','admin','2024 01 24','  Cash','  Dine-in','190.00','0.00','0.00','0.0','9','202401241111',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10,'20240129-1-000011','25.00','admin','2024 01 29','  Cash','  Dine-in','25.00','0.00','0.00','0.0','10','202401290826',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(11,'20240129-1-000012','35.00','ladmin','2024 01 29','  Cash','  Dine-in','35.00','0.00','0.00','0.0','11','202401290833',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(12,'20240129-1-000013','90.00','ladmin','2024 01 29','  Cash','  Dine-in','90.00','0.00','0.00','0.0','12','202401290835',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(13,'20240129-1-000014','65.00','ladmin','2024 01 29','  Cash','  Dine-in','65.00','0.00','0.00','0.0','13','202401290846',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(14,'20260422-1-000021','100.00','ladmin','2026 04 22','  cash','  Dine-in','100.000000','0.000000','0.000000','0','14','202604221427','','','','0','0',NULL,NULL,NULL,NULL,NULL),(15,'20260423-1-000011','4815.00','admin','2026 04 23','  Cash','  Dine-in','4815.00','0.00','0.00','0.0','15','202604231320',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(16,'20260423-1-000012','4911.00','admin','2026 04 23','  Cash','  Dine-in','4911.00','0.00','0.00','0.0','16','202604231321',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(17,'20260423-1-000013','50.00','admin','2026 04 23','  Cash','  Dine-in','50.00','0.00','0.00','0.0','17','202604231324',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(18,'20260423-1-000014','65.00','admin','2026 04 23','  Cash','  Dine-in','65.00','0.00','0.00','0.0','18','202604231325',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(19,'20260424-1-000011','70.00','admin','2026 04 24','  Cash','  Dine-in','70.00','0.00','0.00','0.0','19','202604241124',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(20,'20260424-1-000031','90.00','admin','2026 04 24','  Cash','  Dine-in','90.00','0.00','0.00','0.0','20','202604241125',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,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,'20260422-1-000021',NULL,'0',NULL,'0',NULL,NULL,NULL,NULL,NULL);
