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,'ESPRESSO ','1.0','10000.00','10000.00','Item',NULL,NULL,'no',NULL,NULL,'20250619-000011','02:25:15 PM','2025 06 19','admin','1','  Dine-in','  Cash','10000.00','10000.00','3','','','1.0','','19 Jun 2025','2025061914:25:15','%','0','10000.00','no','0.00',NULL,'202506191425','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'HOT COFFEE ','ladmin','ladmin',NULL,NULL,'03',NULL,'10000.00','','','','',NULL,'10000.00'),(2,'ENGLISH BREAK FAST TEA ','1.0','5000.00','5000.00','Item',NULL,NULL,'no',NULL,NULL,'20250619-000012','02:27:39 PM','2025 06 19','admin','1','  Dine-in','  Cash','5000.00','5000.00','4','','','1.0','','19 Jun 2025','2025061914:27:39','%','0','5000.00','no','0.00',NULL,'202506191427','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SPECIALTY TEA','ladmin','ladmin',NULL,NULL,'01',NULL,'5000.00','','','','',NULL,'5000.00'),(3,'ESPRESSO ','1.0','10000.00','10000.00','Item',NULL,NULL,'no',NULL,NULL,'20250619-000013','02:30:04 PM','2025 06 19','admin','1','  Dine-in','  Card','40000.00','40000.00','5','','','1.0','','19 Jun 2025','2025061914:30:04','%','0','10000.00','no','0.00',NULL,'202506191430','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'HOT COFFEE ','ladmin','ladmin','0',NULL,'03',NULL,'10000.00','','','','',NULL,'10000.00'),(4,'AMERICANO','1.0','10000.00','10000.00','Item',NULL,NULL,'no',NULL,NULL,'20250619-000013','02:30:04 PM','2025 06 19','admin','1','  Dine-in','  Card','40000.00','40000.00','6','','','1.0','','19 Jun 2025','2025061914:30:04','%','0','10000.00','no','0.00',NULL,'202506191430','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'HOT COFFEE ','ladmin','ladmin','0',NULL,'05',NULL,'10000.00','','','','',NULL,'10000.00'),(5,'CAPPUCCINO ','1.0','20000.00','20000.00','Item',NULL,NULL,'no',NULL,NULL,'20250619-000013','02:30:04 PM','2025 06 19','admin','1','  Dine-in','  Card','40000.00','40000.00','7','','','1.0','','19 Jun 2025','2025061914:30:04','%','0','20000.00','no','0.00',NULL,'202506191430','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'HOT COFFEE ','ladmin','ladmin','0',NULL,'06',NULL,'20000.00','','','','',NULL,'20000.00'),(6,'CAPPUCCINO ','1.0','20000.00','20000.00','Item',NULL,NULL,'no',NULL,NULL,'20250621-000011','08:11:34 AM','2025 06 21','admin','1','  Dine-in','  Cash','25000.00','25000.00','8','','','1.0','','21 Jun 2025','2025062108:11:34','%','0','20000.00','no','0.00',NULL,'202506210811','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'HOT COFFEE ','user6','User6',NULL,NULL,'06',NULL,'20000.00','','','','',NULL,'20000.00'),(7,'MOROCCAN NIGHTS ','1.0','5000.00','5000.00','Item',NULL,NULL,'no',NULL,NULL,'20250621-000011','08:11:34 AM','2025 06 21','admin','1','  Dine-in','  Cash','25000.00','25000.00','9','','','1.0','','21 Jun 2025','2025062108:11:34','%','0','5000.00','no','0.00',NULL,'202506210811','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SPECIALTY TEA','user6','User6',NULL,NULL,'02',NULL,'5000.00','','','','',NULL,'5000.00'),(8,'CAPPUCCINO ','1.0','20000.00','20000.00','Item',NULL,NULL,'no',NULL,NULL,'20250621-000012','08:11:42 AM','2025 06 21','admin','1','  Dine-in','  Cash','30000.00','30000.00','10','','','1.0','','21 Jun 2025','2025062108:11:42','%','0','20000.00','no','0.00',NULL,'202506210811','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'HOT COFFEE ','user6','User6',NULL,NULL,'06',NULL,'20000.00','','','','',NULL,'20000.00'),(9,'ESPRESSO ','1.0','10000.00','10000.00','Item',NULL,NULL,'no',NULL,NULL,'20250621-000012','08:11:42 AM','2025 06 21','admin','1','  Dine-in','  Cash','30000.00','30000.00','11','','','1.0','','21 Jun 2025','2025062108:11:42','%','0','10000.00','no','0.00',NULL,'202506210811','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'HOT COFFEE ','user6','User6',NULL,NULL,'03',NULL,'10000.00','','','','',NULL,'10000.00'),(15,'CAPPUCCINO ','1.0','20000.00','20000.00','Item',NULL,NULL,'no',NULL,NULL,'20250621-000014','08:11:59 AM','2025 06 21','admin','1','  Dine-in','  Cash','45000.00','45000.00','17','','','1.0','','21 Jun 2025','2025062108:11:59','%','0','20000.00','no','','','202506210811','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'HOT COFFEE ','user6','User6',NULL,NULL,'06',NULL,'20000.00','','','','',NULL,'20000.00'),(16,'AMERICANO','1.0','10000.00','10000.00','Item',NULL,NULL,'no',NULL,NULL,'20250621-000014','08:11:59 AM','2025 06 21','admin','1','  Dine-in','  Cash','45000.00','45000.00','18','','','1.0','','21 Jun 2025','2025062108:11:59','%','0','10000.00','no','','','202506210811','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'HOT COFFEE ','user6','User6',NULL,NULL,'05',NULL,'10000.00','','','','',NULL,'10000.00'),(17,'ENGLISH BREAK FAST TEA ','1.0','5000.00','5000.00','Item',NULL,NULL,'no',NULL,NULL,'20250621-000014','08:11:59 AM','2025 06 21','admin','1','  Dine-in','  Cash','45000.00','45000.00','19','','','1.0','','21 Jun 2025','2025062108:11:59','%','0','5000.00','no','','','202506210811','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SPECIALTY TEA','user6','User6',NULL,NULL,'01',NULL,'5000.00','','','','',NULL,'5000.00'),(18,'ESPRESSO ','1.0','10000.00','10000.00','Item',NULL,NULL,'no',NULL,NULL,'20250621-000014','08:11:59 AM','2025 06 21','admin','1','  Dine-in','  Cash','45000.00','45000.00','20','','','1.0','','21 Jun 2025','2025062108:11:59','%','0','10000.00','no','','','202506210811','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'HOT COFFEE ','user6','User6',NULL,NULL,'03',NULL,'10000.00','','','','',NULL,'10000.00'),(20,'CAPPUCCINO ','1.0','20000.00','20000.00','Item',NULL,NULL,'no',NULL,NULL,'20250621-000016','08:12:24 AM','2025 06 21','admin','1','  Dine-in','  Cash','35000.00','35000.00','22','','','1.0','','21 Jun 2025','2025062108:12:24','%','0','20000.00','no','0.00',NULL,'202506210812','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'HOT COFFEE ','user6','User6',NULL,NULL,'06',NULL,'20000.00','','','','',NULL,'20000.00'),(21,'MOROCCAN NIGHTS ','1.0','5000.00','5000.00','Item',NULL,NULL,'no',NULL,NULL,'20250621-000016','08:12:24 AM','2025 06 21','admin','1','  Dine-in','  Cash','35000.00','35000.00','23','','','1.0','','21 Jun 2025','2025062108:12:24','%','0','5000.00','no','0.00',NULL,'202506210812','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SPECIALTY TEA','user6','User6',NULL,NULL,'02',NULL,'5000.00','','','','',NULL,'5000.00'),(22,'ESPRESSO ','1.0','10000.00','10000.00','Item',NULL,NULL,'no',NULL,NULL,'20250621-000016','08:12:24 AM','2025 06 21','admin','1','  Dine-in','  Cash','35000.00','35000.00','24','','','1.0','','21 Jun 2025','2025062108:12:24','%','0','10000.00','no','0.00',NULL,'202506210812','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'HOT COFFEE ','user6','User6',NULL,NULL,'03',NULL,'10000.00','','','','',NULL,'10000.00'),(23,'MOROCCAN NIGHTS ','1.0','5000.00','5000.00','Item',NULL,NULL,'no',NULL,NULL,'20250621-000017','08:12:34 AM','2025 06 21','admin','1','  Dine-in','  Cash','20000.00','20000.00','25','','','1.0','','21 Jun 2025','2025062108:12:34','%','0','5000.00','no','0.00',NULL,'202506210812','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SPECIALTY TEA','user6','User6',NULL,NULL,'02',NULL,'5000.00','','','','',NULL,'5000.00'),(24,'ENGLISH BREAK FAST TEA ','1.0','5000.00','5000.00','Item',NULL,NULL,'no',NULL,NULL,'20250621-000017','08:12:34 AM','2025 06 21','admin','1','  Dine-in','  Cash','20000.00','20000.00','26','','','1.0','','21 Jun 2025','2025062108:12:34','%','0','5000.00','no','0.00',NULL,'202506210812','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SPECIALTY TEA','user6','User6',NULL,NULL,'01',NULL,'5000.00','','','','',NULL,'5000.00'),(25,'ESPRESSO ','1.0','10000.00','10000.00','Item',NULL,NULL,'no',NULL,NULL,'20250621-000017','08:12:34 AM','2025 06 21','admin','1','  Dine-in','  Cash','20000.00','20000.00','27','','','1.0','','21 Jun 2025','2025062108:12:34','%','0','10000.00','no','0.00',NULL,'202506210812','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'HOT COFFEE ','user6','User6',NULL,NULL,'03',NULL,'10000.00','','','','',NULL,'10000.00'),(26,'ESPRESSO ','2.0','10000.00','20000.00','Item',NULL,NULL,'no',NULL,NULL,'20250622-000011','01:53:14 PM','2025 06 22','admin','1','  Dine-in','  Cash','65000.00','65000.00','28',NULL,NULL,NULL,NULL,'22 Jun 2025','2025062213:53:14','%','0','20000.00','no','0.00',NULL,'202506221353','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'HOT COFFEE ','ladmin','AMON',NULL,NULL,'03',NULL,'20000.00','','','','',NULL,'10000.00'),(27,'MOROCCAN NIGHTS ','2.0','5000.00','10000.00','Item',NULL,NULL,'no',NULL,NULL,'20250622-000011','01:53:14 PM','2025 06 22','admin','1','  Dine-in','  Cash','65000.00','65000.00','29',NULL,NULL,NULL,NULL,'22 Jun 2025','2025062213:53:14','%','0','10000.00','no','0.00',NULL,'202506221353','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SPECIALTY TEA','ladmin','AMON',NULL,NULL,'02',NULL,'10000.00','','','','',NULL,'5000.00'),(28,'CAPPUCCINO ','1.0','20000.00','20000.00','Item',NULL,NULL,'no',NULL,NULL,'20250622-000011','01:53:14 PM','2025 06 22','admin','1','  Dine-in','  Cash','65000.00','65000.00','30',NULL,NULL,NULL,NULL,'22 Jun 2025','2025062213:53:14','%','0','20000.00','no','0.00',NULL,'202506221353','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'HOT COFFEE ','ladmin','AMON',NULL,NULL,'06',NULL,'20000.00','','','','',NULL,'20000.00'),(29,'AMERICANO','1.0','10000.00','10000.00','Item',NULL,NULL,'no',NULL,NULL,'20250622-000011','01:53:14 PM','2025 06 22','admin','1','  Dine-in','  Cash','65000.00','65000.00','31',NULL,NULL,NULL,NULL,'22 Jun 2025','2025062213:53:14','%','0','10000.00','no','0.00',NULL,'202506221353','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'HOT COFFEE ','ladmin','AMON',NULL,NULL,'05',NULL,'10000.00','','','','',NULL,'10000.00'),(30,'ENGLISH BREAK FAST TEA ','1.0','5000.00','5000.00','Item',NULL,NULL,'no',NULL,NULL,'20250622-000011','01:53:14 PM','2025 06 22','admin','1','  Dine-in','  Cash','65000.00','65000.00','32',NULL,NULL,NULL,NULL,'22 Jun 2025','2025062213:53:14','%','0','5000.00','no','0.00',NULL,'202506221353','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SPECIALTY TEA','ladmin','AMON',NULL,NULL,'01',NULL,'5000.00','','','','',NULL,'5000.00'),(31,'CAPPUCCINO ','1.0','20000.00','20000.00','Item',NULL,NULL,'no',NULL,NULL,'20250622-000012','01:53:23 PM','2025 06 22','admin','1','  Dine-in','  Card','20000.00','20000.00','33',NULL,NULL,NULL,NULL,'22 Jun 2025','2025062213:53:23','%','0','20000.00','no','0.00',NULL,'202506221353','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'HOT COFFEE ','ladmin','AMON','0',NULL,'06',NULL,'20000.00','','','','',NULL,'20000.00'),(32,'CAPPUCCINO ','1.0','20000.00','20000.00','Item',NULL,NULL,'no',NULL,NULL,'20250622-000013','01:53:47 PM','2025 06 22','admin','1','  Dine-in','  Card','20000.00','20000.00','34',NULL,NULL,NULL,NULL,'22 Jun 2025','2025062213:53:47','%','0','20000.00','no','0.00',NULL,'202506221353','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'HOT COFFEE ','ladmin','AMON','0',NULL,'06',NULL,'20000.00','','','','',NULL,'20000.00'),(33,'CAPPUCCINO ','1.0','20000.00','20000.00','Item',NULL,NULL,'no',NULL,NULL,'20250623-000011','03:33:58 PM','2025 06 23','admin','1','  Takeaway','  Cash','20000.00','20000.00','35',NULL,NULL,NULL,NULL,'23 Jun 2025','2025062315:33:58','%','0','20000.00','no','0.00',NULL,'202506231533','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'HOT COFFEE ','ladmin','AMON',NULL,NULL,'06',NULL,'20000.00','','','','',NULL,'20000.00');
INSERT INTO `all_sales_cancelled` (`_id`, `itemname`, `quantity`, `price`, `total`, `type`, `parent`, `parentid`, `mod_assigned`, `tax`, `taxname`, `bill_no`, `time`, `date`, `user`, `billtype`, `paymentmethod`, `billamount_disapply`, `billamount_disnotapply`, `_idd`, `reason`, `billamount_cancelled`, `date1`, `billamount_cancelled_user`, `disc_type`, `disc_value`, `newtotal`, `disc_thereornot`, `disc_indiv_total`, `datetimee_new`, `taxname2`, `tax2`, `taxname3`, `tax3`, `taxname4`, `tax4`, `taxname5`, `tax5`, `hsn_code`, `old_total`, `old_total_indiv`) VALUES (1,'AMERICANO','2.0','10000.00','20000.00','Item',NULL,NULL,'no',NULL,NULL,'20250621-000015','08:17:38 AM','2025 06 21','user6','  Dine-in','  Card','20000.00','20000.0','21','Changed mind','20000.00','21 Jun 2025','20000.00','%','0','20000.00','no','','202506210817',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','20000.00','10000.00'),(2,'CAPPUCCINO ','1.0','20000.00','20000.00','Item',NULL,NULL,'no',NULL,NULL,'20250621-000013','08:27:08 AM','2025 06 21','user6','  Dine-in','  Cash','50000.00','50000.0','12','','50000.00','21 Jun 2025','50000.00','%','0','20000.00','no','0.00','202506210827',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','20000.00','20000.00'),(3,'AMERICANO','1.0','10000.00','10000.00','Item',NULL,NULL,'no',NULL,NULL,'20250621-000013','08:27:08 AM','2025 06 21','user6','  Dine-in','  Cash','50000.00','50000.0','13','','50000.00','21 Jun 2025','50000.00','%','0','10000.00','no','0.00','202506210827',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','10000.00','10000.00'),(4,'MOROCCAN NIGHTS ','1.0','5000.00','5000.00','Item',NULL,NULL,'no',NULL,NULL,'20250621-000013','08:27:08 AM','2025 06 21','user6','  Dine-in','  Cash','50000.00','50000.0','14','','50000.00','21 Jun 2025','50000.00','%','0','5000.00','no','0.00','202506210827',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','5000.00','5000.00'),(5,'ENGLISH BREAK FAST TEA ','1.0','5000.00','5000.00','Item',NULL,NULL,'no',NULL,NULL,'20250621-000013','08:27:08 AM','2025 06 21','user6','  Dine-in','  Cash','50000.00','50000.0','15','','50000.00','21 Jun 2025','50000.00','%','0','5000.00','no','0.00','202506210827',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','5000.00','5000.00'),(6,'ESPRESSO ','1.0','10000.00','10000.00','Item',NULL,NULL,'no',NULL,NULL,'20250621-000013','08:27:08 AM','2025 06 21','user6','  Dine-in','  Cash','50000.00','50000.0','16','','50000.00','21 Jun 2025','50000.00','%','0','10000.00','no','0.00','202506210827',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','10000.00','10000.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,'20250619-000011','10000.00','admin','2025 06 19','  Cash','  Dine-in','10000.00','0.00','0.00','0.0','1','202506191425',NULL,NULL,NULL,NULL,NULL,NULL),(2,'20250619-000012','5000.00','admin','2025 06 19','  Cash','  Dine-in','5000.00','0.00','0.00','0.0','2','202506191427','Mr frank',NULL,NULL,NULL,NULL,NULL),(3,'20250619-000013','40000.00','admin','2025 06 19','  Card','  Dine-in','40000.00','0.00','0.00','0.0','3','202506191430',NULL,NULL,NULL,NULL,NULL,NULL),(4,'20250621-000011','25000.00','admin','2025 06 21','  Cash','  Dine-in','25000.00','0.00','0.00','0.0','4','202506210811',NULL,NULL,NULL,NULL,NULL,NULL),(5,'20250621-000012','30000.00','admin','2025 06 21','  Cash','  Dine-in','30000.00','0.00','0.00','0.0','5','202506210811',NULL,NULL,NULL,NULL,NULL,NULL),(6,'20250621-000013','0','admin','2025 06 21','  Cash','  Dine-in','0.0','0.0','0.0','0.0','6','202506210811',NULL,NULL,NULL,NULL,NULL,NULL),(7,'20250621-000014','30000.00','admin','2025 06 21','  Cash','  Dine-in','30000.0','0.00','0.0','0.0','7','202506210811',NULL,NULL,NULL,NULL,NULL,NULL),(8,'20250621-000015','0','admin','2025 06 21','  Card','  Dine-in','0.0','0.0','0.0','0.0','8','202506210812',NULL,NULL,NULL,NULL,NULL,NULL),(9,'20250621-000016','35000.00','admin','2025 06 21','  Cash','  Dine-in','35000.00','0.00','0.00','0.0','9','202506210812',NULL,NULL,NULL,NULL,NULL,NULL),(10,'20250621-000017','20000.00','admin','2025 06 21','  Cash','  Dine-in','20000.00','0.00','0.00','0.0','10','202506210812',NULL,NULL,NULL,NULL,NULL,NULL),(11,'20250622-000011','65000.00','admin','2025 06 22','  Cash','  Dine-in','65000.00','0.00','0.00','0.0','11','202506221353',NULL,NULL,NULL,NULL,NULL,NULL),(12,'20250622-000012','20000.00','admin','2025 06 22','  Card','  Dine-in','20000.00','0.00','0.00','0.0','12','202506221353',NULL,NULL,NULL,NULL,NULL,NULL),(13,'20250622-000013','20000.00','admin','2025 06 22','  Card','  Dine-in','20000.00','0.00','0.00','0.0','13','202506221353',NULL,NULL,NULL,NULL,NULL,NULL),(14,'20250623-000011','20000.00','admin','2025 06 23','  Cash','  Takeaway','20000.00','0.00','0.00','0.0','14','202506231533','No sugar',NULL,NULL,NULL,NULL,NULL);
INSERT INTO `clicked_cust_name` (`_id`, `name`) VALUES (1,'');
INSERT INTO `expenses_sales` (`_id`, `expensename`, `price`, `category`, `counterperson_username`, `counterperson_name`, `date`, `time`, `datetimee_new`) VALUES (1,'milk','58000.00','Utilities','User1','User1','15 Jun 2025','11:09 PM','202506152309'),(2,'Beer','85000','Utilities','Amon','Amon','19 Jun 2025','02:26 PM','202506191426');
INSERT INTO `itemdata` (`_id`, `itemname`, `total`) VALUES (1,'AMERICANO',10000),(2,'CAPPUCCINO ',60000),(3,'ENGLISH BREAK FAST TEA ',5000),(4,'ESPRESSO ',20000),(5,'MOROCCAN NIGHTS ',10000);
INSERT INTO `itemwiseorderlistcategory` (`_id`, `itemno`, `categoryname`, `sales`, `salespercentage`, `itemtotalquan`) VALUES (1,NULL,'HOT COFFEE ',180000,92,'13'),(2,NULL,'SPECIALTY TEA',30000,15,'6');
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,'44','AMERICANO',10000,10,'1','HOT COFFEE ',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(2,'45','CAPPUCCINO ',60000,57,'3','HOT COFFEE ',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(3,'41','ENGLISH BREAK FAST TEA ',5000,5,'1','SPECIALTY TEA',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(4,'43','ESPRESSO ',20000,19,'2','HOT COFFEE ',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(5,'42','MOROCCAN NIGHTS ',10000,10,'2','SPECIALTY TEA',NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO `top_category` (`_id`, `category`, `value`) VALUES (34,'HOT COFFEE ',90000),(35,'SPECIALTY TEA',15000);
INSERT INTO `userdata` (`_id`, `username`, `total`) VALUES (1,'admin',105000);
INSERT INTO `userwiseorderlistitems` (`_id`, `username`, `sales`, `salespercentage`) VALUES (1,'madmin',105000,100);
