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','1','25.00','25.00','Item','null','null','no','null','None','20260128-1-000011','1:46:09 PM','2026 01 28','madmin','1','Dine-in','card','0','0','1','null','null','null','null','28Jan26','2026012801:46:009','%','0','','','',' ','2026012801:46:009','','null','null','null','null','null','null','null','null','Tiffin','madmin','madmin','null','','',' ','25.00',' ',' ',' ',' ',NULL,'25.00'),(2,'dosa','2','35.00','70.00','Item','null','null','no','null','None','20260128-1-000011','1:46:09 PM','2026 01 28','madmin','1','Dine-in','card','0','0','2','null','null','null','null','28Jan26','2026012801:46:009','%','0','','','',' ','2026012801:46:009','','null','null','null','null','null','null','null','null','Tiffin','madmin','madmin','null','','',' ','70',' ',' ',' ',' ',NULL,'35'),(3,'masal dosa','1','40.00','40.00','Item','null','null','no','null','None','20260128-1-000011','1:46:09 PM','2026 01 28','madmin','1','Dine-in','card','0','0','6','null','null','null','null','28Jan26','2026012801:46:009','%','0','','','',' ','2026012801:46:009','','null','null','null','null','null','null','null','null','Tiffin','madmin','madmin','null','','',' ','40.00',' ',' ',' ',' ',NULL,'40.00'),(4,'poori','1','35.00','35.00','Item','null','null','no','null','None','20260128-1-000011','1:46:09 PM','2026 01 28','madmin','1','Dine-in','card','0','0','5','null','null','null','null','28Jan26','2026012801:46:009','%','0','','','',' ','2026012801:46:009','','null','null','null','null','null','null','null','null','Tiffin','madmin','madmin','null','','',' ','35',' ',' ',' ',' ',NULL,'35'),(5,'idly','1','25.00','25.00','Item','null','null','no','null','None','20260128-1-000012','1:47:36 PM','2026 01 28','madmin','1','Home delivery','cash','0','0','1','null','null','null','null','28Jan26','2026012801:47:36','%','0','','','',' ','2026012801:47:36','','null','null','null','null','null','null','null','null','Tiffin','madmin','madmin','null','','',' ','25.00',' ',' ',' ',' ',NULL,'25.00'),(6,'poori','1','35.00','35.00','Item','null','null','no','null','None','20260128-1-000012','1:47:36 PM','2026 01 28','madmin','1','Home delivery','cash','0','0','5','null','null','null','null','28Jan26','2026012801:47:36','%','0','','','',' ','2026012801:47:36','','null','null','null','null','null','null','null','null','Tiffin','madmin','madmin','null','','',' ','35.00',' ',' ',' ',' ',NULL,'35.00'),(7,'masal dosa','1','40.00','40.00','Item','null','null','no','null','None','20260128-1-000012','1:47:36 PM','2026 01 28','madmin','1','Home delivery','cash','0','0','6','null','null','null','null','28Jan26','2026012801:47:36','%','0','','','',' ','2026012801:47:36','','null','null','null','null','null','null','null','null','Tiffin','madmin','madmin','null','','',' ','40.00',' ',' ',' ',' ',NULL,'40.00'),(8,'uthappam','1','30.00','30.00','Item','null','null','no','null','None','20260128-1-000012','1:47:36 PM','2026 01 28','madmin','1','Home delivery','cash','0','0','10','null','null','null','null','28Jan26','2026012801:47:36','%','0','','','',' ','2026012801:47:36','','null','null','null','null','null','null','null','null','Tiffin','madmin','madmin','null','','',' ','30.00',' ',' ',' ',' ',NULL,'30.00'),(9,'idly','1','25.00','25.00','Item','null','null','no','null','None','20260128-1-000013','1:55:15 PM','2026 01 28','madmin','1','Dine-in','cash','0','0','1','null','null','null','null','28Jan26','2026012801:55:15','%','0','','','',' ','2026012801:55:15','','null','null','null','null','null','null','null','null','Tiffin','madmin','madmin','null','','',' ','25.00',' ',' ',' ',' ',NULL,'25.00'),(10,'poori','1','35.00','35.00','Item','null','null','no','null','None','20260128-1-000013','1:55:15 PM','2026 01 28','madmin','1','Dine-in','cash','0','0','5','null','null','null','null','28Jan26','2026012801:55:15','%','0','','','',' ','2026012801:55:15','','null','null','null','null','null','null','null','null','Tiffin','madmin','madmin','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,'20260128-1-000011','170.00','madmin','2026 01 28','  card','  Dine-in','170.000000','0.000000','0.000000','0','','202601281346','','','','0','0',NULL,NULL,NULL,NULL,NULL),(2,'20260128-1-000012','130.00','madmin','2026 01 28','  cash','  Home delivery','130.000000','0.000000','0.000000','0','1','202601281347','','','','0','0',NULL,NULL,NULL,NULL,NULL),(3,'20260128-1-000013','60.00','madmin','2026 01 28','  cash','  Dine-in','60.000000','0.000000','0.000000','0','2','202601281355','','','','0','0',NULL,NULL,NULL,NULL,NULL);
INSERT INTO `clicked_cust_name` (`_id`, `name`) VALUES (1,'');
INSERT INTO `discountdetails` (`_id`, `date`, `time`, `billno`, `Discountcodeno`, `Discount_percent`, `Billamount_rupess`, `Discount_rupees`, `date1`, `original_amount`, `billcount`, `datetimee_new`, `paymentmethod`) VALUES (1,NULL,NULL,'20260128-1-000011',NULL,'0',NULL,'0',NULL,NULL,NULL,NULL,NULL),(2,NULL,NULL,'20260128-1-000012',NULL,'0',NULL,'0',NULL,NULL,NULL,NULL,NULL),(3,NULL,NULL,'20260128-1-000013',NULL,'0',NULL,'0',NULL,NULL,NULL,NULL,NULL);
