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,'Handmade Popudams Basket  Chutney Tray','1.0','5.44','5.44','Item',NULL,NULL,'no','10','ServiceCharge(10%)','20241130-1-000011','02:59:44 pm','2024 11 30','admin','1','  Dine-in','  Cash','38.32','38.32','6',NULL,NULL,NULL,NULL,'30 Nov 2024','2024113014:59:44','%','0','5.44','no','0.00',NULL,'202411301459','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'APPETIZERS','admin','madmin',NULL,NULL,'',NULL,'4.95','','','','',NULL,'4.95'),(2,'Punjabi Vegetable Pakoras','1.0','6.54','6.54','Item',NULL,NULL,'no','10','ServiceCharge(10%)','20241130-1-000011','02:59:44 pm','2024 11 30','admin','1','  Dine-in','  Cash','38.32','38.32','7',NULL,NULL,NULL,NULL,'30 Nov 2024','2024113014:59:44','%','0','6.54','no','0.00',NULL,'202411301459','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'STARTERS','admin','madmin',NULL,NULL,'',NULL,'5.95','','','','',NULL,'5.95'),(3,'Punjabi Handmade Samosa platter chat','1.0','8.25','8.25','Item',NULL,NULL,'no','10','ServiceCharge(10%)','20241130-1-000011','02:59:44 pm','2024 11 30','admin','1','  Dine-in','  Cash','38.32','38.32','8',NULL,NULL,NULL,NULL,'30 Nov 2024','2024113014:59:44','%','0','8.25','no','0.00',NULL,'202411301459','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'STARTERS','admin','madmin',NULL,NULL,'',NULL,'7.50','','','','',NULL,'7.50'),(4,'Punjabi Spicy Momos','1.0','8.25','8.25','Item',NULL,NULL,'no','10','ServiceCharge(10%)','20241130-1-000011','02:59:44 pm','2024 11 30','admin','1','  Dine-in','  Cash','38.32','38.32','9',NULL,NULL,NULL,NULL,'30 Nov 2024','2024113014:59:44','%','0','8.25','no','0.00',NULL,'202411301459','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'STARTERS','admin','madmin',NULL,NULL,'',NULL,'7.50','','','','',NULL,'7.50'),(5,'Sesame Honey Chilli Chicken','1.0','9.84','9.84','Item',NULL,NULL,'no','10','ServiceCharge(10%)','20241130-1-000011','02:59:44 pm','2024 11 30','admin','1','  Dine-in','  Cash','38.32','38.32','10',NULL,NULL,NULL,NULL,'30 Nov 2024','2024113014:59:44','%','0','9.84','no','0.00',NULL,'202411301459','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'STARTERS','admin','madmin',NULL,NULL,'',NULL,'8.95','','','','',NULL,'8.95'),(6,'Punjabi Vegetable Pakoras','1.0','6.54','6.54','Item',NULL,NULL,'no','10','ServiceCharge(10%)','20241201-1-000011','12:54:29 PM','2024 12 01','admin','1','  Dine-in','  Cash','23.04','23.04','2',NULL,NULL,NULL,NULL,'01 Dec 2024','2024120112:54:29','%','0','6.54','no','0.00',NULL,'202412011254','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'STARTERS','admin','madmin',NULL,NULL,'',NULL,'5.95','','','','',NULL,'5.95'),(7,'Punjabi Spicy Momos','2.0','8.25','16.50','Item',NULL,NULL,'no','10','ServiceCharge(10%)','20241201-1-000011','12:54:29 PM','2024 12 01','admin','1','  Dine-in','  Cash','23.04','23.04','3',NULL,NULL,NULL,NULL,'01 Dec 2024','2024120112:54:29','%','0','16.50','no','0.00',NULL,'202412011254','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'STARTERS','admin','madmin',NULL,NULL,'',NULL,'15.00','','','','',NULL,'7.50');
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,'20241130-1-000011','38.32','admin','2024 11 30','  Cash','  Dine-in','38.32','3.49','0.00','0.0','1','202411301459',NULL,NULL,NULL,NULL,NULL,NULL),(2,'20241201-1-000011','23.04','admin','2024 12 01','  Cash','  Dine-in','23.04','2.10','0.00','0.0','2','202412011254',NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO `clicked_cust_name` (`_id`, `name`) VALUES (1,'');
