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,'dosa','2.0','35.00','70.00','Item',NULL,NULL,'no',NULL,NULL,'20260705-000011','11:36:05 AM','2026 07 05','admin','1','  Dine-in','  Cash','70.00','70.00','1',NULL,NULL,NULL,NULL,'05 Jul 2026','2026070511:36:05','%','0','70.00','no','0.00',NULL,'202607051136','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','ladmin','ladmin',NULL,NULL,'',NULL,'70.00','','','','',NULL,'35.00'),(2,'pani puri','2.0','35.00','70.00','Item',NULL,NULL,'no',NULL,NULL,'20260705-000012','11:39:16 am','2026 07 05','admin','1','  Dine-in','  Cash','70.00','70.00','2',NULL,NULL,NULL,NULL,'05 Jul 2026','2026070511:39:16','%','0','70.00','no','0.00',NULL,'202607051139','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Snacks','ladmin','ladmin',NULL,NULL,'',NULL,'70.00','','','','',NULL,'35.00'),(3,'butterscotch icecream','1.0','40.00','40.00','Item',NULL,NULL,'no',NULL,NULL,'20260705-000013','03:16:59 pm','2026 07 05','admin','1','  Dine-in','  Cash','110.00','110.00','3',NULL,NULL,NULL,NULL,'05 Jul 2026','2026070515:16:59','%','0','40.00','no','0.00',NULL,'202607051516','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Desserts','ladmin','ladmin',NULL,NULL,'',NULL,'40.00','','','','',NULL,'40.00'),(4,'dosa','2.0','35.00','70.00','Item',NULL,NULL,'no',NULL,NULL,'20260705-000013','03:16:59 pm','2026 07 05','admin','1','  Dine-in','  Cash','110.00','110.00','4',NULL,NULL,NULL,NULL,'05 Jul 2026','2026070515:16:59','%','0','70.00','no','0.00',NULL,'202607051516','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','ladmin','ladmin',NULL,NULL,'',NULL,'70.00','','','','',NULL,'35.00'),(5,'dosa','19.0','35.00','665.00','Item',NULL,NULL,'no',NULL,NULL,'20260706-000011','08:04:24 am','2026 07 06','admin','1','  Dine-in','  Cash','775.00','775.00','6',NULL,NULL,NULL,NULL,'06 Jul 2026','2026070608:04:24','%','0','665.00','no','0.00',NULL,'202607060804','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','ladmin','ladmin',NULL,NULL,'',NULL,'665.00','','','','',NULL,'35.00'),(6,'soft drinks','11.0','10.00','110.00','Item',NULL,NULL,'no',NULL,NULL,'20260706-000011','08:04:24 am','2026 07 06','admin','1','  Dine-in','  Cash','775.00','775.00','7',NULL,NULL,NULL,NULL,'06 Jul 2026','2026070608:04:24','%','0','110.00','no','0.00',NULL,'202607060804','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Drinks','ladmin','ladmin',NULL,NULL,'',NULL,'110.00','','','','',NULL,'10.00'),(7,'idly','2.0','25.00','50.00','Item',NULL,NULL,'no',NULL,NULL,'20260709-000011','06:46:43 pm','2026 07 09','admin','1','  Dine-in','  Cash','50.00','50.00','8',NULL,NULL,NULL,NULL,'09 Jul 2026','2026070918:46:43','%','0','50.00','no','0.00',NULL,'202607091846','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','ladmin','ladmin',NULL,NULL,'',NULL,'50.00','','','','',NULL,'25.00'),(8,'pongal','1.0','30.00','30.00','Item',NULL,NULL,'no',NULL,NULL,'20260714-000011','05:34:57 pm','2026 07 14','admin','1','  Dine-in','  Cash','30.00','30.00','9',NULL,NULL,NULL,NULL,'14 Jul 2026','2026071417:34:57','%','0','30.00','no','0.00',NULL,'202607141734','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','ladmin','ladmin',NULL,NULL,'',NULL,'30.00','','','','',NULL,'30.00'),(9,'upma','3.0','30.00','90.00','Item',NULL,NULL,'no',NULL,NULL,'20260714-000012','05:35:26 PM','2026 07 14','admin','1','  Dine-in','  Cash','90.00','90.00','10',NULL,NULL,NULL,NULL,'14 Jul 2026','2026071417:35:26','%','0','90.00','no','0.00',NULL,'202607141735','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','ladmin','ladmin',NULL,NULL,'',NULL,'90.00','','','','',NULL,'30.00'),(10,'soft drinks','1.0','10.00','10.00','Item',NULL,NULL,'no',NULL,NULL,'20260717-000011','08:40:29 pm','2026 07 17','admin','1','  Dine-in','  Cash','10.00','10.00','11',NULL,NULL,NULL,NULL,'17 Jul 2026','2026071720:40:29','%','0','10.00','no','0.00',NULL,'202607172040','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Drinks','ladmin','ladmin',NULL,NULL,'',NULL,'10.00','','','','',NULL,'10.00'),(11,'dosa','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20260718-000011','12:33:37 pm','2026 07 18','admin','1','  Dine-in','  Cash','35.00','35.00','12',NULL,NULL,NULL,NULL,'18 Jul 2026','2026071812:33:37','%','0','35.00','no','0.00',NULL,'202607181233','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','ladmin','ladmin',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`, `transaction_id`, `transaction_id_org`, `source`, `source1`) VALUES (1,'20260705-000011','70.00','admin','2026 07 05','  Cash','  Dine-in','70.00','0.00','0.00','0.0','1','202607051136',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(2,'20260705-000012','70.00','admin','2026 07 05','  Cash','  Dine-in','70.00','0.00','0.00','0.0','2','202607051139',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(3,'20260705-000013','110.00','admin','2026 07 05','  Cash','  Dine-in','110.00','0.00','0.00','0.0','3','202607051516',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(4,'20260706-000011','775.00','admin','2026 07 06','  Cash','  Dine-in','775.00','0.00','0.00','0.0','4','202607060804',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(5,'20260709-000011','50.00','admin','2026 07 09','  Cash','  Dine-in','50.00','0.00','0.00','0.0','5','202607091846',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(6,'20260714-000011','30.00','admin','2026 07 14','  Cash','  Dine-in','30.00','0.00','0.00','0.0','6','202607141734',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(7,'20260714-000012','90.00','admin','2026 07 14','  Cash','  Dine-in','90.00','0.00','0.00','0.0','7','202607141735',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(8,'20260717-000011','10.00','admin','2026 07 17','  Cash','  Dine-in','10.00','0.00','0.00','0.0','8','202607172040',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(9,'20260718-000011','35.00','admin','2026 07 18','  Cash','  Dine-in','35.00','0.00','0.00','0.0','9','202607181233',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,'dosa',70),(2,'pani puri',70),(3,'pani puri',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,'2','dosa',70,100,'2','Tiffin',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(2,'16','pani puri',70,50,'2','Snacks',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(3,'16','pani puri',70,28,'2','Snacks',NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO `top_category` (`_id`, `category`, `value`) VALUES (1,'Tiffin',70),(4,'Snacks',70),(5,'Tiffin',70),(6,'Desserts',40),(7,'Snacks',70),(8,'Tiffin',140),(15,'Drinks',110),(16,'Tiffin',665),(17,'Tiffin',50);
INSERT INTO `userdata` (`_id`, `username`, `total`) VALUES (1,'admin',70);
INSERT INTO `userwiseorderlistitems` (`_id`, `username`, `sales`, `salespercentage`) VALUES (1,'madmin',70,100);
