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`, `mfrs`, `batch_no`, `expiry`, `sch`, `purchase_price`, `purchase_price_total`, `profit`, `vendor_name`, `vendor_id`, `status`, `transation_id`, `vendor_payment_status`, `profit_payment_status`) VALUES (1,'idly','1.0','25.00','25.00','Item',NULL,NULL,'no',NULL,NULL,'20260130-1-000011','02:58:09 PM','2026 01 30','ladmin','1','  Dine-in','  Cash','160.00','160.00','2',NULL,NULL,NULL,NULL,'30 Jan 2026','2026013014:58:09','%','0','25.00','no','0.00',NULL,'202601301458','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','ladmin','ladmin',NULL,NULL,'',NULL,'25.00','','','','',NULL,'25.00',NULL,NULL,NULL,NULL,'0','0.00','0',NULL,NULL,NULL,NULL,NULL,NULL),(2,'dosa','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20260130-1-000011','02:58:09 PM','2026 01 30','ladmin','1','  Dine-in','  Cash','160.00','160.00','3',NULL,NULL,NULL,NULL,'30 Jan 2026','2026013014:58:09','%','0','35.00','no','0.00',NULL,'202601301458','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','ladmin','ladmin',NULL,NULL,'',NULL,'35.00','','','','',NULL,'35.00',NULL,NULL,NULL,NULL,'0','0.00','0',NULL,NULL,NULL,NULL,NULL,NULL),(3,'pongal','1.0','30.00','30.00','Item',NULL,NULL,'no',NULL,NULL,'20260130-1-000011','02:58:09 PM','2026 01 30','ladmin','1','  Dine-in','  Cash','160.00','160.00','4',NULL,NULL,NULL,NULL,'30 Jan 2026','2026013014:58:09','%','0','30.00','no','0.00',NULL,'202601301458','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','ladmin','ladmin',NULL,NULL,'',NULL,'30.00','','','','',NULL,'30.00',NULL,NULL,NULL,NULL,'0','0.00','0',NULL,NULL,NULL,NULL,NULL,NULL),(4,'upma','1.0','30.00','30.00','Item',NULL,NULL,'no',NULL,NULL,'20260130-1-000011','02:58:09 PM','2026 01 30','ladmin','1','  Dine-in','  Cash','160.00','160.00','5',NULL,NULL,NULL,NULL,'30 Jan 2026','2026013014:58:09','%','0','30.00','no','0.00',NULL,'202601301458','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','ladmin','ladmin',NULL,NULL,'',NULL,'30.00','','','','',NULL,'30.00',NULL,NULL,NULL,NULL,'0','0.00','0',NULL,NULL,NULL,NULL,NULL,NULL),(5,'masal dosa','1.0','40.00','40.00','Item',NULL,NULL,'no',NULL,NULL,'20260130-1-000011','02:58:09 PM','2026 01 30','ladmin','1','  Dine-in','  Cash','160.00','160.00','6',NULL,NULL,NULL,NULL,'30 Jan 2026','2026013014:58:09','%','0','40.00','no','0.00',NULL,'202601301458','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','ladmin','ladmin',NULL,NULL,'',NULL,'40.00','','','','',NULL,'40.00',NULL,NULL,NULL,NULL,'0','0.00','0',NULL,NULL,NULL,NULL,NULL,NULL),(6,'Popcorn Reguler','1.0','50.00','50.00','Item',NULL,NULL,'no',NULL,NULL,'20260131-1-000011','01:00:04 PM','2026 01 31','admin','1','  Takeaway','  Cash','50.00','50.00','1',NULL,NULL,NULL,NULL,'31 Jan 2026','2026013113:00:04','%','0','50.00','no','0.00',NULL,'202601311300','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Snacks','admin','madmin','0',NULL,'',NULL,'50.00','','','','',NULL,'50.00',NULL,NULL,NULL,NULL,'0','0.00','0',NULL,NULL,NULL,NULL,NULL,NULL),(7,'Popcorn Reguler','1.0','50.00','50.00','Item',NULL,NULL,'no',NULL,NULL,'20260131-1-000012','01:01:01 PM','2026 01 31','admin','1','  Takeaway','  Cash','50.00','50.00','1',NULL,NULL,NULL,NULL,'31 Jan 2026','2026013113:01:01','%','0','50.00','no','0.00',NULL,'202601311301','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Snacks','admin','madmin','0',NULL,'',NULL,'50.00','','','','',NULL,'50.00',NULL,NULL,NULL,NULL,'0','0.00','0',NULL,NULL,NULL,NULL,NULL,NULL),(8,'Popcorn Reguler','1.0','50.00','50.00','Item',NULL,NULL,'no',NULL,NULL,'20260131-1-000013','01:02:02 PM','2026 01 31','admin','1','  Takeaway','  Cash','180.00','180.00','1',NULL,NULL,NULL,NULL,'31 Jan 2026','2026013113:02:02','%','0','50.00','no','0.00',NULL,'202601311302','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Snacks','admin','madmin','0',NULL,'',NULL,'50.00','','','','',NULL,'50.00',NULL,NULL,NULL,NULL,'0','0.00','0',NULL,NULL,NULL,NULL,NULL,NULL),(9,'POPCORN LARGE','1.0','100.00','100.00','Item',NULL,NULL,'no',NULL,NULL,'20260131-1-000013','01:02:02 PM','2026 01 31','admin','1','  Takeaway','  Cash','180.00','180.00','2',NULL,NULL,NULL,NULL,'31 Jan 2026','2026013113:02:02','%','0','100.00','no','0.00',NULL,'202601311302','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin','0',NULL,'',NULL,'100.00','','','','',NULL,'100.00',NULL,NULL,NULL,NULL,'0','0.00','0',NULL,NULL,NULL,NULL,NULL,NULL),(10,'Egg Puff','1.0','30.00','30.00','Item',NULL,NULL,'no',NULL,NULL,'20260131-1-000013','01:02:02 PM','2026 01 31','admin','1','  Takeaway','  Cash','180.00','180.00','3',NULL,NULL,NULL,NULL,'31 Jan 2026','2026013113:02:02','%','0','30.00','no','0.00',NULL,'202601311302','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Bekary','admin','madmin','0',NULL,'',NULL,'30.00','','','','',NULL,'30.00',NULL,NULL,NULL,NULL,'0','0.00','0',NULL,NULL,NULL,NULL,NULL,NULL),(11,'Popcorn Reguler','1.0','50.00','50.00','Item',NULL,NULL,'no',NULL,NULL,'20260131-1-000014','02:45:18 PM','2026 01 31','admin','1','  Takeaway','  Cash','180.00','180.00','1',NULL,NULL,NULL,NULL,'31 Jan 2026','2026013114:45:18','%','0','50.00','no','0.00',NULL,'202601311445','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Snacks','admin','madmin','0',NULL,'',NULL,'50.00','','','','',NULL,'50.00',NULL,NULL,NULL,NULL,'0','0.00','0',NULL,NULL,NULL,NULL,NULL,NULL),(12,'POPCORN LARGE','1.0','100.00','100.00','Item',NULL,NULL,'no',NULL,NULL,'20260131-1-000014','02:45:18 PM','2026 01 31','admin','1','  Takeaway','  Cash','180.00','180.00','2',NULL,NULL,NULL,NULL,'31 Jan 2026','2026013114:45:18','%','0','100.00','no','0.00',NULL,'202601311445','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin','0',NULL,'',NULL,'100.00','','','','',NULL,'100.00',NULL,NULL,NULL,NULL,'0','0.00','0',NULL,NULL,NULL,NULL,NULL,NULL),(13,'Egg Puff','1.0','30.00','30.00','Item',NULL,NULL,'no',NULL,NULL,'20260131-1-000014','02:45:18 PM','2026 01 31','admin','1','  Takeaway','  Cash','180.00','180.00','3',NULL,NULL,NULL,NULL,'31 Jan 2026','2026013114:45:18','%','0','30.00','no','0.00',NULL,'202601311445','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Bekary','admin','madmin','0',NULL,'',NULL,'30.00','','','','',NULL,'30.00',NULL,NULL,NULL,NULL,'0','0.00','0',NULL,NULL,NULL,NULL,NULL,NULL),(14,'Popcorn Reguler','1.0','50.00','50.00','Item',NULL,NULL,'no',NULL,NULL,'20260131-1-000015','02:57:49 PM','2026 01 31','user1','1','  Takeaway','  Cash','50.00','50.00','6',NULL,NULL,NULL,NULL,'31 Jan 2026','2026013114:57:49','%','0','50.00','no','0.00',NULL,'202601311457','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Snacks','user1','User1','0',NULL,'',NULL,'50.00','','','','',NULL,'50.00',NULL,NULL,NULL,NULL,'0','0.00','0',NULL,NULL,NULL,NULL,NULL,NULL),(15,'Popcorn Reguler','2.0','50.00','100.00','Item',NULL,NULL,'no',NULL,NULL,'20260131-1-000016','03:44:07 PM','2026 01 31','admin','1','  Takeaway','  Cash','135.00','135.00','6',NULL,NULL,NULL,NULL,'31 Jan 2026','2026013115:44:07','%','0','100.00','no','0.00',NULL,'202601311544','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Snacks','admin','madmin','0',NULL,'',NULL,'100.00','','','','',NULL,'50.00',NULL,NULL,NULL,NULL,'0','0.00','0',NULL,NULL,NULL,NULL,NULL,NULL),(16,'poori','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20260131-1-000016','03:44:07 PM','2026 01 31','admin','1','  Takeaway','  Cash','135.00','135.00','7',NULL,NULL,NULL,NULL,'31 Jan 2026','2026013115:44:07','%','0','35.00','no','0.00',NULL,'202601311544','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin','0',NULL,'',NULL,'35.00','','','','',NULL,'35.00',NULL,NULL,NULL,NULL,'0','0.00','0',NULL,NULL,NULL,NULL,NULL,NULL),(17,'Popcorn Reguler','2.0','50.00','100.00','Item',NULL,NULL,'no',NULL,NULL,'20260131-1-000017','04:25:13 PM','2026 01 31','admin','1','  Takeaway','  Cash','135.00','135.00','6',NULL,NULL,NULL,NULL,'31 Jan 2026','2026013116:25:13','%','0','100.00','no','0.00',NULL,'202601311625','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Snacks','admin','madmin','0',NULL,'',NULL,'100.00','','','','',NULL,'50.00',NULL,NULL,NULL,NULL,'0','0.00','0',NULL,NULL,NULL,NULL,NULL,NULL),(18,'poori','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20260131-1-000017','04:25:13 PM','2026 01 31','admin','1','  Takeaway','  Cash','135.00','135.00','7',NULL,NULL,NULL,NULL,'31 Jan 2026','2026013116:25:13','%','0','35.00','no','0.00',NULL,'202601311625','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin','0',NULL,'',NULL,'35.00','','','','',NULL,'35.00',NULL,NULL,NULL,NULL,'0','0.00','0',NULL,NULL,NULL,NULL,NULL,NULL),(19,'Popcorn Reguler','1.0','50.00','50.00','Item',NULL,NULL,'no',NULL,NULL,'20260131-1-000018','04:35:41 PM','2026 01 31','user1','1','  Takeaway','  Upiqr','50.00','50.00','8',NULL,NULL,NULL,NULL,'31 Jan 2026','2026013116:35:41','%','0','50.00','no','0.00',NULL,'202601311635','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Snacks','user1','User1','0',NULL,'',NULL,'50.00','','','','',NULL,'50.00',NULL,NULL,NULL,NULL,'0','0.00','0',NULL,NULL,NULL,NULL,NULL,NULL),(20,'Popcorn Reguler','1.0','50.00','50.00','Item',NULL,NULL,'no',NULL,NULL,'20260131-1-000019','04:36:51 PM','2026 01 31','user1','1','  Takeaway','  Cash','120.00','120.00','9',NULL,NULL,NULL,NULL,'31 Jan 2026','2026013116:36:51','%','0','50.00','no','0.00',NULL,'202601311636','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Snacks','user1','User1','0',NULL,'',NULL,'50.00','','','','',NULL,'50.00',NULL,NULL,NULL,NULL,'0','0.00','0',NULL,NULL,NULL,NULL,NULL,NULL),(21,'Egg Puff','1.0','30.00','30.00','Item',NULL,NULL,'no',NULL,NULL,'20260131-1-000019','04:36:51 PM','2026 01 31','user1','1','  Takeaway','  Cash','120.00','120.00','10',NULL,NULL,NULL,NULL,'31 Jan 2026','2026013116:36:51','%','0','30.00','no','0.00',NULL,'202601311636','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Bekary','user1','User1','0',NULL,'',NULL,'30.00','','','','',NULL,'30.00',NULL,NULL,NULL,NULL,'0','0.00','0',NULL,NULL,NULL,NULL,NULL,NULL),(22,'SWEET CORN','1.0','40.00','40.00','Item',NULL,NULL,'no',NULL,NULL,'20260131-1-000019','04:36:51 PM','2026 01 31','user1','1','  Takeaway','  Cash','120.00','120.00','11',NULL,NULL,NULL,NULL,'31 Jan 2026','2026013116:36:51','%','0','40.00','no','0.00',NULL,'202601311636','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Snacks','user1','User1','0',NULL,'',NULL,'40.00','','','','',NULL,'40.00',NULL,NULL,NULL,NULL,'0','0.00','0',NULL,NULL,NULL,NULL,NULL,NULL),(23,'Popcorn Normal','1.0','50.00','50.00','Item',NULL,NULL,'no',NULL,NULL,'20260131-1-0000110','04:58:39 PM','2026 01 31','admin','1','  Takeaway','  Cash','50.00','50.00','12',NULL,NULL,NULL,NULL,'31 Jan 2026','2026013116:58:39','%','0','50.00','no','0.00',NULL,'202601311658','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Snaks','admin','MADMIN','0',NULL,'',NULL,'50.00','','','','',NULL,'50.00',NULL,NULL,NULL,NULL,'0','0.00','0',NULL,NULL,NULL,NULL,NULL,NULL),(24,'Popcorn Normal','1.0','50.00','50.00','Item',NULL,NULL,'no',NULL,NULL,'20260131-1-0000111','05:00:52 PM','2026 01 31','admin','1','  Takeaway','  Cash','50.00','50.00','13',NULL,NULL,NULL,NULL,'31 Jan 2026','2026013117:00:52','%','0','50.00','no','0.00',NULL,'202601311700','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Snaks','admin','MADMIN','0',NULL,'',NULL,'50.00','','','','',NULL,'50.00',NULL,NULL,NULL,NULL,'0','0.00','0',NULL,NULL,NULL,NULL,NULL,NULL),(25,'Popcorn Normal','3.0','50.00','150.00','Item',NULL,NULL,'no',NULL,NULL,'20260131-1-0000112','05:11:43 PM','2026 01 31','admin','1','  Takeaway','  Upiqr','150.00','150.00','14',NULL,NULL,NULL,NULL,'31 Jan 2026','2026013117:11:43','%','0','150.00','no','0.00',NULL,'202601311711','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Snaks','admin','MADMIN','0',NULL,'',NULL,'150.00','','','','',NULL,'50.00',NULL,NULL,NULL,NULL,'0','0.00','0',NULL,NULL,NULL,NULL,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`, `transaction_id`, `transaction_id_org`, `source`, `source1`, `cash_sett_staus`) VALUES (1,'20260130-1-000011','160.00','ladmin','2026 01 30','  Cash','  Dine-in','160.00','0.00','0.00','0.0','1','202601301458',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(2,'20260131-1-000011','50.00','admin','2026 01 31','  Cash','  Takeaway','50.00','0.00','0.00','0.0','2','202601311300',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(3,'20260131-1-000012','50.00','admin','2026 01 31','  Cash','  Takeaway','50.00','0.00','0.00','0.0','3','202601311301',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(4,'20260131-1-000013','180.00','admin','2026 01 31','  Cash','  Takeaway','180.00','0.00','0.00','0.0','4','202601311302',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(5,'20260131-1-000014','180.00','admin','2026 01 31','  Cash','  Takeaway','180.00','0.00','0.00','0.0','5','202601311445',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(6,'20260131-1-000015','50.00','user1','2026 01 31','  Cash','  Takeaway','50.00','0.00','0.00','0.0','6','202601311457',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(7,'20260131-1-000016','135.00','admin','2026 01 31','  Cash','  Takeaway','135.00','0.00','0.00','0.0','7','202601311544',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(8,'20260131-1-000017','135.00','admin','2026 01 31','  Cash','  Takeaway','135.00','0.00','0.00','0.0','8','202601311625',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(9,'20260131-1-000018','50.00','user1','2026 01 31','  Upiqr','  Takeaway','50.00','0.00','0.00','0.0','9','202601311635',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10,'20260131-1-000019','120.00','user1','2026 01 31','  Cash','  Takeaway','120.00','0.00','0.00','0.0','10','202601311636',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(11,'20260131-1-0000110','50.00','admin','2026 01 31','  Cash','  Takeaway','50.00','0.00','0.00','0.0','11','202601311658',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(12,'20260131-1-0000111','50.00','admin','2026 01 31','  Cash','  Takeaway','50.00','0.00','0.00','0.0','12','202601311700',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(13,'20260131-1-0000112','150.00','admin','2026 01 31','  Upiqr','  Takeaway','150.00','0.00','0.00','0.0','13','202601311711',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO `clicked_cust_name` (`_id`, `name`) VALUES (1,'');
INSERT INTO `itemdata` (`_id`, `itemname`, `total`) VALUES (1,'Egg Puff',90),(2,'POPCORN LARGE',200),(3,'Popcorn Normal',250),(4,'Popcorn Reguler',550),(5,'SWEET CORN',40),(6,'poori',70);
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,NULL,'Egg Puff',90,8,'3','Bekary',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(2,NULL,'POPCORN LARGE',200,17,'2','Tiffin',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(3,'41','Popcorn Normal',250,21,'5','Snaks',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(4,'41','Popcorn Reguler',550,46,'11','Snacks',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(5,'41','SWEET CORN',40,3,'1','Snacks',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(6,'41','poori',70,6,'2','Tiffin',NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO `top_category` (`_id`, `category`, `value`) VALUES (9,'Bekary',90),(10,'Snacks',590),(11,'Snaks',250),(12,'Tiffin',270);
INSERT INTO `userdata` (`_id`, `username`, `total`) VALUES (1,'admin',980),(2,'user1',220);
INSERT INTO `userwiseorderlistitems` (`_id`, `username`, `sales`, `salespercentage`) VALUES (1,'madmin',980,82),(2,'Asha',220,18);
