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','2.0','25.00','50.00','Item',NULL,NULL,'no',NULL,NULL,'20240405-1-000011','03:27:46 PM','2024 04 05','admin','1','  Dine-in','  Card','50.00','50.00','1',NULL,NULL,NULL,NULL,'05 Apr 2024','2024040515:27:46','%','0','50.00','no','0.00',NULL,'202404051527','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin','0',NULL,'',NULL,'50.00','','','','',NULL,'25.00'),(2,'dosa','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20240405-1-000012','03:28:12 PM','2024 04 05','admin','1','  Dine-in','  Upiqr','60.00','60.00','2',NULL,NULL,NULL,NULL,'05 Apr 2024','2024040515:28:12','%','0','35.00','no','0.00',NULL,'202404051528','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin','0',NULL,'',NULL,'35.00','','','','',NULL,'35.00'),(3,'idly','1.0','25.00','25.00','Item',NULL,NULL,'no',NULL,NULL,'20240405-1-000012','03:28:12 PM','2024 04 05','admin','1','  Dine-in','  Upiqr','60.00','60.00','3',NULL,NULL,NULL,NULL,'05 Apr 2024','2024040515:28:12','%','0','25.00','no','0.00',NULL,'202404051528','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin','0',NULL,'',NULL,'25.00','','','','',NULL,'25.00'),(4,'idly','2.0','25.00','50.00','Item',NULL,NULL,'no',NULL,NULL,'20240405-1-000021','03:41:18 PM','2024 04 05','admin','2','  Dine-in','  Card','50.00','50.00','1',NULL,NULL,NULL,NULL,'05 Apr 2024','2024040515:41:18','%','0','50.00','no','0.00',NULL,'202404051541','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin','0',NULL,'',NULL,'50.00','','','','',NULL,'25.00'),(5,'idly','1.0','25.00','25.00','Item',NULL,NULL,'no',NULL,NULL,'20240405-1-000022','03:45:13 PM','2024 04 05','admin','2','  Dine-in','  Card','25.00','25.00','2',NULL,NULL,NULL,NULL,'05 Apr 2024','2024040515:45:13','%','0','25.00','no','0.00',NULL,'202404051545','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin','0',NULL,'',NULL,'25.00','','','','',NULL,'25.00'),(6,'roti','1.0','15.00','15.00','Item',NULL,NULL,'no',NULL,NULL,'20240405-1-000013','03:47:16 PM','2024 04 05','admin','1','  Dine-in','  Card','15.00','15.00','4',NULL,NULL,NULL,NULL,'05 Apr 2024','2024040515:47:16','%','0','15.00','no','0.00',NULL,'202404051547','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Main course','admin','madmin','0',NULL,'',NULL,'15.00','','','','',NULL,'15.00'),(7,'idly','1.0','25.00','25.00','Item',NULL,NULL,'no',NULL,NULL,'20240405-1-000014','04:05:43 PM','2024 04 05','admin','1','  Dine-in','  Card','25.00','25.00','5',NULL,NULL,NULL,NULL,'05 Apr 2024','2024040516:05:43','%','0','25.00','no','0.00',NULL,'202404051605','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin','0',NULL,'',NULL,'25.00','','','','',NULL,'25.00'),(8,'idly','1.0','25.00','25.00','Item',NULL,NULL,'no',NULL,NULL,'20240405-1-000015','04:06:35 PM','2024 04 05','admin','1','  Dine-in','  Card','25.00','25.00','6',NULL,NULL,NULL,NULL,'05 Apr 2024','2024040516:06:35','%','0','25.00','no','0.00',NULL,'202404051606','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin','0',NULL,'',NULL,'25.00','','','','',NULL,'25.00'),(9,'dosa','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20240405-1-000016','04:15:52 PM','2024 04 05','admin','1','  Takeaway','  Card','60.00','60.00','7',NULL,NULL,NULL,NULL,'05 Apr 2024','2024040516:15:52','%','0','35.00','no','0.00',NULL,'202404051615','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin','0',NULL,'',NULL,'35.00','','','','',NULL,'35.00'),(10,'idly','1.0','25.00','25.00','Item',NULL,NULL,'no',NULL,NULL,'20240405-1-000016','04:15:52 PM','2024 04 05','admin','1','  Takeaway','  Card','60.00','60.00','8',NULL,NULL,NULL,NULL,'05 Apr 2024','2024040516:15:52','%','0','25.00','no','0.00',NULL,'202404051615','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin','0',NULL,'',NULL,'25.00','','','','',NULL,'25.00'),(11,'idly','1.0','25.00','25.00','Item',NULL,NULL,'no',NULL,NULL,'20240405-1-000017','04:19:45 PM','2024 04 05','admin','1','  Dine-in','  Cash','25.00','25.00','9',NULL,NULL,NULL,NULL,'05 Apr 2024','2024040516:19:45','%','0','25.00','no','0.00',NULL,'202404051619','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'25.00','','','','',NULL,'25.00'),(12,'idly','1.0','25.00','25.00','Item',NULL,NULL,'no',NULL,NULL,'20240405-1-000018','04:20:53 PM','2024 04 05','admin','1','  Dine-in','  Card','60.00','60.00','10',NULL,NULL,NULL,NULL,'05 Apr 2024','2024040516:20:53','%','0','25.00','no','0.00',NULL,'202404051620','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin','0',NULL,'',NULL,'25.00','','','','',NULL,'25.00'),(13,'poori','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20240405-1-000018','04:20:53 PM','2024 04 05','admin','1','  Dine-in','  Card','60.00','60.00','11',NULL,NULL,NULL,NULL,'05 Apr 2024','2024040516:20:53','%','0','35.00','no','0.00',NULL,'202404051620','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin','0',NULL,'',NULL,'35.00','','','','',NULL,'35.00'),(14,'masal vada','1.0','20.00','20.00','Item',NULL,NULL,'no',NULL,NULL,'20240405-1-000019','04:24:03 PM','2024 04 05','admin','1','  Dine-in','  Card','20.00','20.00','12',NULL,NULL,NULL,NULL,'05 Apr 2024','2024040516:24:03','%','0','20.00','no','0.00',NULL,'202404051624','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Snacks','admin','madmin','0',NULL,'',NULL,'20.00','','','','',NULL,'20.00'),(15,'masal vada','1.0','20.00','20.00','Item',NULL,NULL,'no',NULL,NULL,'20240405-1-0000110','04:24:44 PM','2024 04 05','admin','1','  Dine-in','  Card','20.00','20.00','13',NULL,NULL,NULL,NULL,'05 Apr 2024','2024040516:24:44','%','0','20.00','no','0.00',NULL,'202404051624','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Snacks','admin','madmin','0',NULL,'',NULL,'20.00','','','','',NULL,'20.00'),(16,'water','1.0','1.00','1.00','Item',NULL,NULL,'no',NULL,NULL,'20240405-1-0000111','04:29:04 PM','2024 04 05','admin','1','  Dine-in','  Card','1.00','1.00','18',NULL,NULL,NULL,NULL,'05 Apr 2024','2024040516:29:04','%','0','1.00','no','0.00',NULL,'202404051629','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin','0',NULL,'',NULL,'1.00','','','','',NULL,'1.00'),(17,'water','1.0','1.00','1.00','Item',NULL,NULL,'no',NULL,NULL,'20240405-1-0000112','05:23:29 PM','2024 04 05','admin','1','  Dine-in','  Card','1.00','1.00','19',NULL,NULL,NULL,NULL,'05 Apr 2024','2024040517:23:29','%','0','1.00','no','0.00',NULL,'202404051723','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin','0',NULL,'',NULL,'1.00','','','','',NULL,'1.00'),(18,'water','1.0','1.00','1.00','Item',NULL,NULL,'no',NULL,NULL,'20240422-1-000011','04:19:24 PM','2024 04 22','admin','1','  Dine-in','  Card','1.00','1.00','23',NULL,NULL,NULL,NULL,'22 Apr 2024','2024042216:19:24','%','0','1.00','no','0.00',NULL,'202404221619','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin','0',NULL,'',NULL,'1.00','','','','',NULL,'1.00'),(19,'water','1.0','1.00','1.00','Item',NULL,NULL,'no',NULL,NULL,'20240422-1-000012','04:20:24 PM','2024 04 22','admin','1','  Dine-in','  Card','1.00','1.00','24',NULL,NULL,NULL,NULL,'22 Apr 2024','2024042216:20:24','%','0','1.00','no','0.00',NULL,'202404221620','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin','0',NULL,'',NULL,'1.00','','','','',NULL,'1.00'),(20,'water','1.0','1.00','1.00','Item',NULL,NULL,'no',NULL,NULL,'20240422-1-000013','07:07:49 PM','2024 04 22','admin','1','  Dine-in','  Card','1.00','1.00','1',NULL,NULL,NULL,NULL,'22 Apr 2024','2024042219:07:49','%','0','1.00','no','0.00',NULL,'202404221907','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin','0',NULL,'',NULL,'1.00','','','','',NULL,'1.00'),(21,'water','1.0','1.00','1.00','Item',NULL,NULL,'no',NULL,NULL,'20240422-1-000014','07:08:17 PM','2024 04 22','admin','1','  Dine-in','  Card','1.00','1.00','2',NULL,NULL,NULL,NULL,'22 Apr 2024','2024042219:08:17','%','0','1.00','no','0.00',NULL,'202404221908','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin','0',NULL,'',NULL,'1.00','','','','',NULL,'1.00'),(22,'water','1.0','1.00','1.00','Item',NULL,NULL,'no',NULL,NULL,'20240422-1-000015','07:09:19 PM','2024 04 22','admin','1','  Dine-in','  Card','1.00','1.00','3',NULL,NULL,NULL,NULL,'22 Apr 2024','2024042219:09:19','%','0','1.00','no','0.00',NULL,'202404221909','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin','0',NULL,'',NULL,'1.00','','','','',NULL,'1.00'),(23,'water','1.0','1.00','1.00','Item',NULL,NULL,'no',NULL,NULL,'20240422-1-000016','07:29:03 PM','2024 04 22','admin','1','  Dine-in','  Card','1.00','1.00','5',NULL,NULL,NULL,NULL,'22 Apr 2024','2024042219:29:03','%','0','1.00','no','0.00',NULL,'202404221929','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin','0',NULL,'',NULL,'1.00','','','','',NULL,'1.00'),(24,'water','2.0','1.00','2.00','Item',NULL,NULL,'no',NULL,NULL,'20240423-1-000011','09:48:04 AM','2024 04 23','admin','1','  Dine-in','  Cash','2.00','2.00','8',NULL,NULL,NULL,NULL,'23 Apr 2024','2024042309:48:04','%','0','2.00','no','0.00',NULL,'202404230948','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin','0',NULL,'',NULL,'2.00','','','','',NULL,'1.00'),(25,'water','1.0','1.00','1.00','Item',NULL,NULL,'no',NULL,NULL,'20240423-1-000012','09:49:54 AM','2024 04 23','admin','1','  Dine-in','  Cash','1.00','1.00','10',NULL,NULL,NULL,NULL,'23 Apr 2024','2024042309:49:54','%','0','1.00','no','0.00',NULL,'202404230949','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin','0',NULL,'',NULL,'1.00','','','','',NULL,'1.00'),(26,'water','1.0','1.00','1.00','Item',NULL,NULL,'no',NULL,NULL,'20240423-1-000013','09:53:33 AM','2024 04 23','admin','1','  Dine-in','  Card','1.00','1.00','13',NULL,NULL,NULL,NULL,'23 Apr 2024','2024042309:53:33','%','0','1.00','no','0.00',NULL,'202404230953','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin','0',NULL,'',NULL,'1.00','','','','',NULL,'1.00'),(27,'water','1.0','1.00','1.00','Item',NULL,NULL,'no',NULL,NULL,'20240423-1-000014','09:54:15 AM','2024 04 23','admin','1','  Dine-in','  Card','1.00','1.00','14',NULL,NULL,NULL,NULL,'23 Apr 2024','2024042309:54:15','%','0','1.00','no','0.00',NULL,'202404230954','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin','0',NULL,'',NULL,'1.00','','','','',NULL,'1.00'),(28,'water','1.0','1.00','1.00','Item',NULL,NULL,'no',NULL,NULL,'20240423-1-000015','09:55:08 AM','2024 04 23','admin','1','  Dine-in','  Card','1.00','1.00','15',NULL,NULL,NULL,NULL,'23 Apr 2024','2024042309:55:08','%','0','1.00','no','0.00',NULL,'202404230955','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin','0',NULL,'',NULL,'1.00','','','','',NULL,'1.00'),(29,'poori','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20240423-1-000016','11:28:07 AM','2024 04 23','admin','1','  Dine-in','  Card','36.00','36.00','16',NULL,NULL,NULL,NULL,'23 Apr 2024','2024042311:28:07','%','0','35.00','no','0.00',NULL,'202404231128','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin','0',NULL,'',NULL,'35.00','','','','',NULL,'35.00'),(30,'water','1.0','1.00','1.00','Item',NULL,NULL,'no',NULL,NULL,'20240423-1-000016','11:28:07 AM','2024 04 23','admin','1','  Dine-in','  Card','36.00','36.00','17',NULL,NULL,NULL,NULL,'23 Apr 2024','2024042311:28:07','%','0','1.00','no','0.00',NULL,'202404231128','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin','0',NULL,'',NULL,'1.00','','','','',NULL,'1.00'),(31,'idly','1.0','25.00','25.00','Item',NULL,NULL,'no',NULL,NULL,'20241015-1-000011','09:23:12 AM','2024 10 15','admin','1','  Dine-in','  Cash','60.00','60.00','2',NULL,NULL,NULL,NULL,'15 Oct 2024','2024101509:23:12','%','0','25.00','no','0.00',NULL,'202410150923','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'25.00','','','','',NULL,'25.00'),(32,'dosa','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20241015-1-000011','09:23:12 AM','2024 10 15','admin','1','  Dine-in','  Cash','60.00','60.00','3',NULL,NULL,NULL,NULL,'15 Oct 2024','2024101509:23:12','%','0','35.00','no','0.00',NULL,'202410150923','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'35.00','','','','',NULL,'35.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,'20240405-1-000011','50.00','admin','2024 04 05','  Card','  Dine-in','50.00','0.00','0.00','0.0','1','202404051527',NULL,NULL,NULL,NULL,NULL,NULL),(2,'20240405-1-000012','60.00','admin','2024 04 05','  Upiqr','  Dine-in','60.00','0.00','0.00','0.0','2','202404051528',NULL,NULL,NULL,NULL,NULL,NULL),(3,'20240405-1-000021','50.00','admin','2024 04 05','  Card','  Dine-in','50.00','0.00','0.00','0.0','3','202404051541',NULL,NULL,NULL,NULL,NULL,NULL),(4,'20240405-1-000022','25.00','admin','2024 04 05','  Card','  Dine-in','25.00','0.00','0.00','0.0','4','202404051545',NULL,NULL,NULL,NULL,NULL,NULL),(5,'20240405-1-000013','15.00','admin','2024 04 05','  Card','  Dine-in','15.00','0.00','0.00','0.0','5','202404051547',NULL,NULL,NULL,NULL,NULL,NULL),(6,'20240405-1-000014','25.00','admin','2024 04 05','  Card','  Dine-in','25.00','0.00','0.00','0.0','6','202404051605',NULL,NULL,NULL,NULL,NULL,NULL),(7,'20240405-1-000015','25.00','admin','2024 04 05','  Card','  Dine-in','25.00','0.00','0.00','0.0','7','202404051606',NULL,NULL,NULL,NULL,NULL,NULL),(8,'20240405-1-000016','60.00','admin','2024 04 05','  Card','  Takeaway','60.00','0.00','0.00','0.0','8','202404051615',NULL,NULL,NULL,NULL,NULL,NULL),(9,'20240405-1-000017','25.00','admin','2024 04 05','  Cash','  Dine-in','25.00','0.00','0.00','0.0','9','202404051619',NULL,NULL,NULL,NULL,NULL,NULL),(10,'20240405-1-000018','60.00','admin','2024 04 05','  Card','  Dine-in','60.00','0.00','0.00','0.0','10','202404051620',NULL,NULL,NULL,NULL,NULL,NULL),(11,'20240405-1-000019','20.00','admin','2024 04 05','  Card','  Dine-in','20.00','0.00','0.00','0.0','11','202404051624',NULL,NULL,NULL,NULL,NULL,NULL),(12,'20240405-1-0000110','20.00','admin','2024 04 05','  Card','  Dine-in','20.00','0.00','0.00','0.0','12','202404051624',NULL,NULL,NULL,NULL,NULL,NULL),(13,'20240405-1-0000111','1.00','admin','2024 04 05','  Card','  Dine-in','1.00','0.00','0.00','0.0','13','202404051629',NULL,NULL,NULL,NULL,NULL,NULL),(14,'20240405-1-0000112','1.00','admin','2024 04 05','  Card','  Dine-in','1.00','0.00','0.00','0.0','14','202404051723',NULL,NULL,NULL,NULL,NULL,NULL),(15,'20240422-1-000011','1.00','admin','2024 04 22','  Card','  Dine-in','1.00','0.00','0.00','0.0','15','202404221619',NULL,NULL,NULL,NULL,NULL,NULL),(16,'20240422-1-000012','1.00','admin','2024 04 22','  Card','  Dine-in','1.00','0.00','0.00','0.0','16','202404221620',NULL,NULL,NULL,NULL,NULL,NULL),(17,'20240422-1-000013','1.00','admin','2024 04 22','  Card','  Dine-in','1.00','0.00','0.00','0.0','17','202404221907',NULL,NULL,NULL,NULL,NULL,NULL),(18,'20240422-1-000014','1.00','admin','2024 04 22','  Card','  Dine-in','1.00','0.00','0.00','0.0','18','202404221908',NULL,NULL,NULL,NULL,NULL,NULL),(19,'20240422-1-000015','1.00','admin','2024 04 22','  Card','  Dine-in','1.00','0.00','0.00','0.0','19','202404221909',NULL,NULL,NULL,NULL,NULL,NULL),(20,'20240422-1-000016','1.00','admin','2024 04 22','  Card','  Dine-in','1.00','0.00','0.00','0.0','20','202404221929',NULL,NULL,NULL,NULL,NULL,NULL),(21,'20240423-1-000011','2.00','admin','2024 04 23','  Cash','  Dine-in','2.00','0.00','0.00','0.0','21','202404230948',NULL,NULL,NULL,NULL,NULL,NULL),(22,'20240423-1-000012','1.00','admin','2024 04 23','  Cash','  Dine-in','1.00','0.00','0.00','0.0','22','202404230949',NULL,NULL,NULL,NULL,NULL,NULL),(23,'20240423-1-000013','1.00','admin','2024 04 23','  Card','  Dine-in','1.00','0.00','0.00','0.0','23','202404230953',NULL,NULL,NULL,NULL,NULL,NULL),(24,'20240423-1-000014','1.00','admin','2024 04 23','  Card','  Dine-in','1.00','0.00','0.00','0.0','24','202404230954',NULL,NULL,NULL,NULL,NULL,NULL),(25,'20240423-1-000015','1.00','admin','2024 04 23','  Card','  Dine-in','1.00','0.00','0.00','0.0','25','202404230955',NULL,NULL,NULL,NULL,NULL,NULL),(26,'20240423-1-000016','36.00','admin','2024 04 23','  Card','  Dine-in','36.00','0.00','0.00','0.0','26','202404231128',NULL,NULL,NULL,NULL,NULL,NULL),(27,'20241015-1-000011','60.00','admin','2024 10 15','  Cash','  Dine-in','60.00','0.00','0.00','0.0','1','202410150923',NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO `clicked_cust_name` (`_id`, `name`) VALUES (1,'');
INSERT INTO `itemdata` (`_id`, `itemname`, `total`) VALUES (1,'dosa',35),(2,'idly',200),(3,'roti',15),(4,'poori',35),(5,'roti',15),(6,'water',1);
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',35,14,'1','Tiffin',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(2,'1','idly',200,80,'8','Tiffin',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(3,'26','roti',15,6,'1','Main course',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(4,'5','poori',35,8,'1','Tiffin',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(5,'26','roti',15,3,'1','Main course',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(6,'41','water',1,0,'1','None',NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO `top_category` (`_id`, `category`, `value`) VALUES (1,'Main course',15),(2,'Tiffin',235),(3,'Main course',15),(4,'None',1),(5,'Snacks',40),(6,'Tiffin',380);
INSERT INTO `userdata` (`_id`, `username`, `total`) VALUES (1,'admin',250);
INSERT INTO `userwiseorderlistitems` (`_id`, `username`, `sales`, `salespercentage`) VALUES (1,'madmin',250,100);
