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,'lassi','1.0','25.00','25.00','Item',NULL,NULL,'no',NULL,NULL,'20241029-1-000011','09:12:45 am','2024 10 29','admin','1','  Dine-in','  Cash','90.00','90.00','4',NULL,NULL,NULL,NULL,'29 Oct 2024','2024102909:12:45','%','0','25.00','no','0.00',NULL,'202410290912','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Drinks','admin','madmin',NULL,NULL,'',NULL,'25.00','','','','',NULL,'25.00'),(2,'chicken nuggets','1.0','65.00','65.00','Item',NULL,NULL,'no',NULL,NULL,'20241029-1-000011','09:12:45 am','2024 10 29','admin','1','  Dine-in','  Cash','90.00','90.00','5',NULL,NULL,NULL,NULL,'29 Oct 2024','2024102909:12:45','%','0','65.00','no','0.00',NULL,'202410290912','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Snacks','admin','madmin',NULL,NULL,'',NULL,'65.00','','','','',NULL,'65.00'),(3,'vada','1.0','20.00','20.00','Item',NULL,NULL,'no',NULL,NULL,'20241029-1-000012','11:31:05 am','2024 10 29','admin','1','  Dine-in','  Cash','20.00','20.00','6',NULL,NULL,NULL,NULL,'29 Oct 2024','2024102911:31:05','%','0','20.00','no','0.00',NULL,'202410291131','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Snacks','admin','madmin',NULL,NULL,'',NULL,'20.00','','','','',NULL,'20.00'),(4,'vada','1.0','20.00','20.00','Item',NULL,NULL,'no',NULL,NULL,'20241029-1-000013','03:27:35 pm','2024 10 29','admin','1','  Dine-in','  Cash','20.00','20.00','4',NULL,NULL,NULL,NULL,'29 Oct 2024','2024102915:27:35','%','0','20.00','no','0.00',NULL,'202410291527','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Snacks','user1','jia',NULL,NULL,'',NULL,'20.00','','','','',NULL,'20.00'),(5,'masal dosa','1.0','40.00','40.00','Item',NULL,NULL,'no',NULL,NULL,'20241029-1-000014','05:24:41 pm','2024 10 29','admin','1','  Dine-in','  Cash','235.00','235.00','5',NULL,NULL,NULL,NULL,'29 Oct 2024','2024102917:24:41','%','0','40.00','no','0.00',NULL,'202410291724','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','user1','jia',NULL,NULL,'',NULL,'40.00','','','','',NULL,'40.00'),(6,'idly','1.0','25.00','25.00','Item',NULL,NULL,'no',NULL,NULL,'20241029-1-000014','05:24:41 pm','2024 10 29','admin','1','  Dine-in','  Cash','235.00','235.00','6',NULL,NULL,NULL,NULL,'29 Oct 2024','2024102917:24:41','%','0','25.00','no','0.00',NULL,'202410291724','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','user1','jia',NULL,NULL,'',NULL,'25.00','','','','',NULL,'25.00'),(7,'pongal','1.0','30.00','30.00','Item',NULL,NULL,'no',NULL,NULL,'20241029-1-000014','05:24:41 pm','2024 10 29','admin','1','  Dine-in','  Cash','235.00','235.00','7',NULL,NULL,NULL,NULL,'29 Oct 2024','2024102917:24:41','%','0','30.00','no','0.00',NULL,'202410291724','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','user1','jia',NULL,NULL,'',NULL,'30.00','','','','',NULL,'30.00'),(8,'upma','2.0','30.00','60.00','Item',NULL,NULL,'no',NULL,NULL,'20241029-1-000014','05:24:41 pm','2024 10 29','admin','1','  Dine-in','  Cash','235.00','235.00','8',NULL,NULL,NULL,NULL,'29 Oct 2024','2024102917:24:41','%','0','60.00','no','0.00',NULL,'202410291724','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','user1','jia',NULL,NULL,'',NULL,'60.00','','','','',NULL,'30.00'),(9,'vada','2.0','20.00','40.00','Item',NULL,NULL,'no',NULL,NULL,'20241029-1-000014','05:24:41 pm','2024 10 29','admin','1','  Dine-in','  Cash','235.00','235.00','9',NULL,NULL,NULL,NULL,'29 Oct 2024','2024102917:24:41','%','0','40.00','no','0.00',NULL,'202410291724','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Snacks','user1','jia',NULL,NULL,'',NULL,'40.00','','','','',NULL,'20.00'),(10,'masal vada','1.0','20.00','20.00','Item',NULL,NULL,'no',NULL,NULL,'20241029-1-000014','05:24:41 pm','2024 10 29','admin','1','  Dine-in','  Cash','235.00','235.00','10',NULL,NULL,NULL,NULL,'29 Oct 2024','2024102917:24:41','%','0','20.00','no','0.00',NULL,'202410291724','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Snacks','user1','jia',NULL,NULL,'',NULL,'20.00','','','','',NULL,'20.00'),(11,'samosa','1.0','20.00','20.00','Item',NULL,NULL,'no',NULL,NULL,'20241029-1-000014','05:24:41 pm','2024 10 29','admin','1','  Dine-in','  Cash','235.00','235.00','11',NULL,NULL,NULL,NULL,'29 Oct 2024','2024102917:24:41','%','0','20.00','no','0.00',NULL,'202410291724','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Snacks','user1','jia',NULL,NULL,'',NULL,'20.00','','','','',NULL,'20.00'),(12,'Jaggery Chai','2.0','20.00','40.00','Item',NULL,NULL,'no',NULL,NULL,'20241029-1-000015','06:20:37 pm','2024 10 29','admin','1','  Dine-in','  Cash','40.00','40.00','17',NULL,NULL,NULL,NULL,'29 Oct 2024','2024102918:20:37','%','0','40.00','no','0.00',NULL,'202410291820','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'CHAI','admin','madmin',NULL,NULL,'',NULL,'40.00','','','','',NULL,'20.00'),(13,'Special Chai','1.0','12.00','12.00','Item',NULL,NULL,'no',NULL,NULL,'20241030-1-000011','09:45:23 AM','2024 10 30','admin','1','  Dine-in','  Cash','12.00','12.00','26',NULL,NULL,NULL,NULL,'30 Oct 2024','2024103009:45:23','%','0','12.00','no','0.00',NULL,'202410300945','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'CHAI','user1','jia',NULL,NULL,'',NULL,'12.00','','','','',NULL,'12.00'),(14,'Ginger Chai','1.0','20.00','20.00','Item',NULL,NULL,'no',NULL,NULL,'20241030-1-000012','09:47:14 AM','2024 10 30','admin','1','  Dine-in','  Cash','40.00','40.00','28',NULL,NULL,NULL,NULL,'30 Oct 2024','2024103009:47:14','%','0','20.00','no','0.00',NULL,'202410300947','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'CHAI','user1','jia',NULL,NULL,'',NULL,'20.00','','','','',NULL,'20.00'),(15,'Classic Coffee','1.0','20.00','20.00','Item',NULL,NULL,'no',NULL,NULL,'20241030-1-000012','09:47:14 AM','2024 10 30','admin','1','  Dine-in','  Cash','40.00','40.00','29',NULL,NULL,NULL,NULL,'30 Oct 2024','2024103009:47:14','%','0','20.00','no','0.00',NULL,'202410300947','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'COFFEE','user1','jia',NULL,NULL,'',NULL,'20.00','','','','',NULL,'20.00'),(16,'Special Chai','2.0','12.00','24.00','Item',NULL,NULL,'no',NULL,NULL,'20241106-1-000011','09:21:56 am','2024 11 06','admin','1','  Dine-in','  Cash','24.00','24.00','30',NULL,NULL,NULL,NULL,'06 Nov 2024','2024110609:21:56','%','0','24.00','no','0.00',NULL,'202411060921','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'CHAI','admin','madmin',NULL,NULL,'',NULL,'20.00','','','','',NULL,'10.00'),(17,'Special Chai','1.0','10.00','10.00','Item',NULL,NULL,'no',NULL,NULL,'20241107-1-000011','01:02:13 pm','2024 11 07','admin','1','  Dine-in','  Cash','10.00','10.00','1',NULL,NULL,NULL,NULL,'07 Nov 2024','2024110713:02:13','%','0','10.00','no','0.00',NULL,'202411071302','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'CHAI','admin','madmin',NULL,NULL,'',NULL,'10.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`) VALUES (1,'20241029-1-000011','90.00','admin','2024 10 29','  Cash','  Dine-in','90.00','0.00','0.00','0.0','1','202410290912',NULL,NULL,NULL,NULL,NULL,NULL),(2,'20241029-1-000012','20.00','admin','2024 10 29','  Cash','  Dine-in','20.00','0.00','0.00','0.0','2','202410291131',NULL,NULL,NULL,NULL,NULL,NULL),(3,'20241029-1-000013','20.00','admin','2024 10 29','  Cash','  Dine-in','20.00','0.00','0.00','0.0','3','202410291527',NULL,NULL,NULL,NULL,NULL,NULL),(4,'20241029-1-000014','235.00','admin','2024 10 29','  Cash','  Dine-in','235.00','0.00','0.00','0.0','4','202410291724',NULL,NULL,NULL,NULL,NULL,NULL),(5,'20241029-1-000015','40.00','admin','2024 10 29','  Cash','  Dine-in','40.00','0.00','0.00','0.0','5','202410291820',NULL,NULL,NULL,NULL,NULL,NULL),(6,'20241030-1-000011','12.00','admin','2024 10 30','  Cash','  Dine-in','12.00','0.00','0.00','0.0','6','202410300945',NULL,NULL,NULL,NULL,NULL,NULL),(7,'20241030-1-000012','40.00','admin','2024 10 30','  Cash','  Dine-in','40.00','0.00','0.00','0.0','7','202410300947',NULL,NULL,NULL,NULL,NULL,NULL),(8,'20241106-1-000011','24.00','admin','2024 11 06','  Cash','  Dine-in','24.00','0.00','0.00','0.0','8','202411060921',NULL,NULL,NULL,NULL,NULL,NULL),(9,'20241107-1-000011','10.00','admin','2024 11 07','  Cash','  Dine-in','10.00','0.00','0.00','0.0','9','202411071302',NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO `clicked_cust_name` (`_id`, `name`) VALUES (1,'');
INSERT INTO `itemdata` (`_id`, `itemname`, `total`) VALUES (1,'chicken nuggets',65),(2,'lassi',25),(3,'vada',40),(4,'masal dosa',40),(5,'masal vada',20),(6,'pongal',30),(7,'samosa',20),(8,'upma',60),(9,'vada',80),(10,'vada',80);
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,'20','chicken nuggets',65,50,'1','Snacks',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(2,'20','lassi',25,19,'1','Drinks',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(3,'11','vada',40,31,'2','Snacks',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(4,'6','masal dosa',40,11,'1','Tiffin',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(5,'12','masal vada',20,6,'1','Snacks',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(6,'3','pongal',30,8,'1','Tiffin',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(7,'13','samosa',20,6,'1','Snacks',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(8,'4','upma',60,16,'2','Tiffin',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(9,'11','vada',80,22,'4','Snacks',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10,'45','vada',80,20,'4','Snacks',NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO `top_category` (`_id`, `category`, `value`) VALUES (1,'Drinks',25),(2,'Snacks',105),(3,'Drinks',25),(4,'Snacks',105),(9,'Drinks',25),(10,'Snacks',185),(11,'Tiffin',155),(12,'CHAI',40),(13,'Drinks',25),(14,'Snacks',185),(15,'Tiffin',155),(16,'CHAI',40),(17,'Drinks',25),(18,'Snacks',185),(19,'Tiffin',155);
INSERT INTO `userdata` (`_id`, `username`, `total`) VALUES (1,'admin',130);
INSERT INTO `userwiseorderlistitems` (`_id`, `username`, `sales`, `salespercentage`) VALUES (1,'madmin',130,100);
