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','6.0','25.00','150.00','Item',NULL,NULL,'no',NULL,NULL,'20240625-1-000011','12:08:10 pm','2024 06 25','admin','1','  Dine-in','  Cash','242.25','255.00','1',NULL,NULL,NULL,NULL,'25 Jun 2024','2024062512:08:10','%','0','150.00','no','0.00',NULL,'202406251208','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(2,'dosa','3.0','35.00','105.00','Item',NULL,NULL,'no',NULL,NULL,'20240625-1-000011','12:08:10 pm','2024 06 25','admin','1','  Dine-in','  Cash','242.25','255.00','2',NULL,NULL,NULL,NULL,'25 Jun 2024','2024062512:08:10','%','0','105.00','no','0.00',NULL,'202406251208','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(3,'idly','5','25.00','125.00','Item','null','null','no','9.0','test(9%)','20240626-1-000011','4:17:52 PM','2024 06 26','madmin','1','  Dine-in','  cash','0','0','1','null','null','null','null','26Jun24','2024062604:17:52','%','0','','','','test','2024062604:17:52','','','','','','','','','','Tiffin','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(4,'bread omlette','1.0','30.00','30.00','Item',NULL,NULL,'no',NULL,NULL,'20240627-1-000011','02:58:29 pm','2024 06 27','admin','1','  Dine-in','  Cash','323.30','323.30','4',NULL,NULL,NULL,NULL,'27 Jun 2024','2024062714:58:29','%','0','30.00','no','0.00',NULL,'202406271458','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(5,'idly','6.0','25.00','150.00','Item',NULL,NULL,'no',NULL,NULL,'20240628-1-000011','09:36:28 am','2024 06 28','ladmin','1','  Dine-in','  Cash','238.92','243.80','5',NULL,NULL,NULL,NULL,'28 Jun 2024','2024062809:36:28','%','0','150.00','no','0.00',NULL,'202406280936','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(6,'samosa','4.0','20.00','80.00','Item',NULL,NULL,'no',NULL,NULL,'20240628-1-000011','09:36:28 am','2024 06 28','ladmin','1','  Dine-in','  Cash','238.92','243.80','6',NULL,NULL,NULL,NULL,'28 Jun 2024','2024062809:36:28','%','0','80.00','no','0.00',NULL,'202406280936','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Snacks','ladmin','ladmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(7,'idly','4','25.00','100.00','Item','null','null','no','9.0','None','20240821-1-0001831','11:48:49 AM','2024 08 21','madmin','183','  Dine-in','  Pay Later','0','0','1','null','null','null','null','21Aug24','2024082111:48:49','%','0','','','','test','2024082111:48:49','','','','','','','','','','Tiffin','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(8,'dosa','3','35.00','105.00','Item','null','null','no','9.0','test(9%)','20240821-1-0001831','11:48:49 AM','2024 08 21','madmin','183','  Dine-in','  Pay Later','0','0','2','null','null','null','null','21Aug24','2024082111:48:49','%','0','','','','test','2024082111:48:49','','','','','','','','','','Tiffin','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(9,'dosa','3','35.00','105.00','Item','null','null','no','9.0','test(9%)','20240821-1-0001832','11:49:31 AM','2024 08 21','madmin','183','  Dine-in','  Pay Later','0','0','2','null','null','null','null','21Aug24','2024082111:49:31','%','0','','','','test','2024082111:49:31','','','','','','','','','','Tiffin','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(10,'idly','1','40.00','40.00','Item','null','null','no','','','20240830-1-0001831','11:06:55 AM','2024 08 30','madmin','183','  Dine-in','  cash','0','0','43','null','null','null','null','30Aug24','2024083011:006:55','%','0','','','','test','2024083011:006:55','','','','','','','','','','TIFFIN','madmin','madmin','null','','43','test','test','test','test','test','test',NULL,NULL),(11,'idly','1','40.00','40.00','Item','null','null','no','3.00','demo(3%)','20240903-1-0001831','2:40:09 PM','2024 09 03','madmin','183','  Dine-in','  cash','0','0','43','null','null','null','null','03Sep24','2024090302:40:009','%','0','','','','test','2024090302:40:009','','','','','','','','','','TIFFIN','madmin','madmin','null','','43','test','test','test','test','test','test',NULL,NULL),(12,'dosa','1','30.00','30.00','Item','null','null','no','3.00','demo(3%)','20240903-1-0001831','2:40:09 PM','2024 09 03','madmin','183','  Dine-in','  cash','0','0','45','null','null','null','null','03Sep24','2024090302:40:009','%','0','','','','test','2024090302:40:009','','','','','','','','','','TIFFIN','madmin','madmin','null','','44','test','test','test','test','test','test',NULL,NULL),(13,'demo','4','40.00','160.00','Item','null','null','no','','','20240903-1-0001832','2:47:00 PM','2024 09 03','madmin','183','  Dine-in','  cash','0','0','46','null','null','null','null','03Sep24','2024090302:47:000','%','0','','','','test','2024090302:47:000','','','','','','','','','','None','madmin','madmin','null','','46','test','test','test','test','test','test',NULL,NULL),(14,'dosa','3','30.00','90.00','Item','null','null','no','3.00','demo(3%)','20240903-1-0001832','2:47:00 PM','2024 09 03','madmin','183','  Dine-in','  cash','0','0','45','null','null','null','null','03Sep24','2024090302:47:000','%','0','','','','test','2024090302:47:000','','','','','','','','','','TIFFIN','madmin','madmin','null','','44','test','test','test','test','test','test',NULL,NULL),(15,'idly','3','40.00','120.00','Item','null','null','no','3.00','demo(3%)','20240903-1-0001832','2:47:00 PM','2024 09 03','madmin','183','  Dine-in','  cash','0','0','43','null','null','null','null','03Sep24','2024090302:47:000','%','0','','','','test','2024090302:47:000','','','','','','','','','','TIFFIN','madmin','madmin','null','','43','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,'20240625-1-000011','242.25','admin','2024 06 25','  Cash','  Dine-in','255.00','0.00','+ 0.00','0.0','1','202406251208',NULL,NULL,NULL,NULL,NULL,NULL),(2,'20240626-1-000011','136.56','madmin','2024 06 26','  cash','  Dine-in','125.000000','18.750000','0.000000','7.5','2','202406261617','','','','','',NULL),(3,'20240821-1-0001831','235.75','madmin','2024 08 21','  Pay Later','  Dine-in','205.000000','30.750000','0.000000','12.299999999999999','3','202408211148','','','','0','0',NULL),(4,'20240821-1-0001832','120.75','madmin','2024 08 21','  Pay Later','  Dine-in','105.000000','15.750000','0.000000','6.3','4','202408211149','','','','0','0',NULL),(5,'20240830-1-0001831','40.00','madmin','2024 08 30','  cash','  Dine-in','40.000000','0.000000','0.000000','0','5','20240830110006','','','','0','0',NULL),(6,'20240903-1-0001831','72.10','madmin','2024 09 03','  cash','  Dine-in','70.000000','2.100000','0.000000','0','6','202409031440','','','','0','0',NULL),(7,'20240903-1-0001832','376.30','madmin','2024 09 03','  cash','  Dine-in','370.000000','6.300000','0.000000','0','7','202409031447','','','','0','0',NULL);
INSERT INTO `clicked_cust_name` (`_id`, `name`) VALUES (1,'');
INSERT INTO `customer_loyalty_points` (`_id`, `phoneno`, `points`) VALUES (1,'8247488369','4294967294');
INSERT INTO `discountdetails` (`_id`, `date`, `time`, `billno`, `Discountcodeno`, `Discount_percent`, `Billamount_rupess`, `Discount_rupees`, `date1`, `original_amount`, `billcount`, `datetimee_new`, `paymentmethod`) VALUES (1,'2024 06 25','12:08:10 pm','20240625-1-000011','demo','5','242.25','12.75','25 Jun 2024','255.00',NULL,'202406251208',NULL),(2,'2024 06 26','03:20:36 pm','20240626-1-000011','promo123','9','204.07','20.18','26 Jun 2024','224.25',NULL,'202406261520',NULL),(3,'2024 06 28','09:36:28 am','20240628-1-000011','demo','2','238.92','4.88','28 Jun 2024','243.80',NULL,'202406280936',NULL),(4,NULL,NULL,'20240903-1-0001831',NULL,'0',NULL,'0',NULL,NULL,NULL,NULL,NULL),(5,NULL,NULL,'20240903-1-0001832',NULL,'0',NULL,'0',NULL,NULL,NULL,NULL,NULL);
INSERT INTO `itemdata` (`_id`, `itemname`, `total`) VALUES (1,'dosa',70),(2,'idly',125),(3,'pongal',90),(4,'upma',60);
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,'2','dosa',70,36,'2','Tiffin',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(2,'1','idly',125,64,'5','Tiffin',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(3,'3','pongal',90,30,'3','Tiffin',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(4,'4','upma',60,20,'2','Tiffin',NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO `top_category` (`_id`, `category`, `value`) VALUES (2,'Tiffin',195),(3,'Tiffin',305);
INSERT INTO `userdata` (`_id`, `username`, `total`) VALUES (1,'admin',204);
INSERT INTO `userwiseorderlistitems` (`_id`, `username`, `sales`, `salespercentage`) VALUES (1,'madmin',204,100);
