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','2.0','25.00','50.00','Item',NULL,NULL,'no',NULL,NULL,'20260705-1-000011','05:52:12 PM','2026 07 05','admin','1','  Dine-in','  Cash','50.00','50.00','1',NULL,NULL,NULL,NULL,'05 Jul 2026','2026070517:52:12','%','0','25.00','no','0.00',NULL,'202607051752','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'50.00','','','','',NULL,'25.00'),(2,'idly','1.0','25.00','25.00','Item',NULL,NULL,'no',NULL,NULL,'20260705-1-000012','05:53:29 PM','2026 07 05','admin','1','  Dine-in','  Upiqr','25.00','25.00','2',NULL,NULL,NULL,NULL,'05 Jul 2026','2026070517:53:29','%','0','25.00','no','0.00',NULL,'202607051753','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin','0',NULL,'',NULL,'25.00','','','','',NULL,'25.00'),(3,'idly','1.0','10.00','10.00','Item',NULL,NULL,'no',NULL,NULL,'20260712-1-000011','10:23:40 AM','2026 07 12','admin','1','  Dine-in','  Cash','10.00','10.00','10',NULL,NULL,NULL,NULL,'12 Jul 2026','2026071210:23:40','%','0','10.00','no','0.00',NULL,'202607121023','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'10.00','','','','',NULL,'10.00'),(4,'idly','1.0','10.00','10.00','Item',NULL,NULL,'no',NULL,NULL,'20260712-1-000012','10:27:06 AM','2026 07 12','admin','1','  Dine-in','  Cash','10.00','10.00','11',NULL,NULL,NULL,NULL,'12 Jul 2026','2026071210:27:06','%','0','10.00','no','0.00',NULL,'202607121027','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'10.00','','','','',NULL,'10.00'),(5,'idly','1.0','10.00','10.00','Item',NULL,NULL,'no',NULL,NULL,'20260712-1-000013','03:55:36 PM','2026 07 12','admin','1','  Dine-in','  Cash','10.00','10.00','12',NULL,NULL,NULL,NULL,'12 Jul 2026','2026071215:55:36','%','0','10.00','no','0.00',NULL,'202607121555','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'10.00','','','','',NULL,'10.00'),(6,'dosa','1.0','20.00','20.00','Item',NULL,NULL,'no',NULL,NULL,'20260712-1-000014','05:14:19 PM','2026 07 12','admin','1','  Dine-in','  Cash','20.00','20.00','14',NULL,NULL,NULL,NULL,'12 Jul 2026','2026071217:14:19','%','0','20.00','no','0.00',NULL,'202607121714','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'20.00','','','','',NULL,'20.00'),(7,'Water','1.0','15.00','15.00','Item',NULL,NULL,'no',NULL,NULL,'20260712-1-000015','08:19:34 PM','2026 07 12','admin','1','  Dine-in','  Cash','25.00','25.00','15',NULL,NULL,NULL,NULL,'12 Jul 2026','2026071220:19:34','%','0','15.00','no','0.00',NULL,'202607122019','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'COOLDRINKS','admin','madmin',NULL,NULL,'',NULL,'15.00','','','','',NULL,'15.00'),(8,'idly','1.0','10.00','10.00','Item',NULL,NULL,'no',NULL,NULL,'20260712-1-000015','08:19:34 PM','2026 07 12','admin','1','  Dine-in','  Cash','25.00','25.00','16',NULL,NULL,NULL,NULL,'12 Jul 2026','2026071220:19:34','%','0','10.00','no','0.00',NULL,'202607122019','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'10.00','','','','',NULL,'10.00'),(9,'idly','1.0','10.00','10.00','Item',NULL,NULL,'no',NULL,NULL,'20260712-1-000016','10:00:21 PM','2026 07 12','admin','1','  Dine-in','  Cash','10.00','10.00','17',NULL,NULL,NULL,NULL,'12 Jul 2026','2026071222:00:21','%','0','10.00','no','0.00',NULL,'202607122200','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'10.00','','','','',NULL,'10.00'),(10,'idly','1.0','10.00','10.00','Item',NULL,NULL,'no',NULL,NULL,'20260713-1-000011','04:29:41 PM','2026 07 13','admin','1','  Dine-in','  Cash','10.00','10.00','19',NULL,NULL,NULL,NULL,'13 Jul 2026','2026071316:29:41','%','0','10.00','no','0.00',NULL,'202607131629','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'10.00','','','','',NULL,'10.00'),(11,'idly','1.0','10.00','10.00','Item',NULL,NULL,'no',NULL,NULL,'20260713-1-000012','04:29:51 PM','2026 07 13','admin','1','  Dine-in','  Cash','10.00','10.00','20',NULL,NULL,NULL,NULL,'13 Jul 2026','2026071316:29:51','%','0','10.00','no','0.00',NULL,'202607131629','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'10.00','','','','',NULL,'10.00'),(12,'idly','1.0','10.00','10.00','Item',NULL,NULL,'no',NULL,NULL,'20260713-1-000013','04:34:26 PM','2026 07 13','admin','1','  Dine-in','  Cash','10.00','10.00','21',NULL,NULL,NULL,NULL,'13 Jul 2026','2026071316:34:26','%','0','10.00','no','0.00',NULL,'202607131634','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'10.00','','','','',NULL,'10.00'),(13,'podi dosa','3','70.00','210.00','Item',NULL,NULL,'no',NULL,NULL,'20260713-1-000014','11:14:15 PM','2026 07 13','admin','1','  Dine-in','  Cash','290.00','290.00','23',NULL,NULL,NULL,NULL,'13 Jul 2026','2026071323:14:15','%','0','70.00','no','0.00',NULL,'202607132314','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'',NULL,'210.00','','','','',NULL,'70.00'),(14,'masal dosa','1.0','80.00','80.00','Item',NULL,NULL,'no',NULL,NULL,'20260713-1-000014','11:14:15 PM','2026 07 13','admin','1','  Dine-in','  Cash','290.00','290.00','24',NULL,NULL,NULL,NULL,'13 Jul 2026','2026071323:14:15','%','0','80.00','no','0.00',NULL,'202607132314','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'80.00','','','','',NULL,'80.00'),(15,'onion dosa','2','70.00','140.00','Item',NULL,NULL,'no',NULL,NULL,'20260714-1-000011','12:03:12 AM','2026 07 14','admin','1','  Dine-in','  Cash','240.00','240.00','28',NULL,NULL,NULL,NULL,'14 Jul 2026','2026071400:03:12','%','0','70.00','no','0.00',NULL,'202607140003','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'140.00','','','','',NULL,'70.00'),(16,'veg biriyani','1.0','100.00','100.00','Item',NULL,NULL,'no',NULL,NULL,'20260714-1-000011','12:03:12 AM','2026 07 14','admin','1','  Dine-in','  Cash','240.00','240.00','30',NULL,NULL,NULL,NULL,'14 Jul 2026','2026071400:03:12','%','0','100.00','no','0.00',NULL,'202607140003','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Main course','admin','madmin',NULL,NULL,'',NULL,'100.00','','','','',NULL,'100.00'),(17,'Water bisgold 1L','1.0','20.00','20.00','Item',NULL,NULL,'no',NULL,NULL,'20260714-1-000012','12:12:41 AM','2026 07 14','admin','1','  Dine-in','  Cash','20.00','20.00','31',NULL,NULL,NULL,NULL,'14 Jul 2026','2026071400:12:41','%','0','20.00','no','0.00',NULL,'202607140012','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'COOLDRINKS','admin','madmin',NULL,NULL,'',NULL,'20.00','','','','',NULL,'20.00'),(18,'Water bisgold 1L','1.0','20.00','20.00','Item',NULL,NULL,'no',NULL,NULL,'20260714-1-000013','12:13:43 AM','2026 07 14','admin','1','  Dine-in','  Cash','20.00','20.00','32',NULL,NULL,NULL,NULL,'14 Jul 2026','2026071400:13:43','%','0','20.00','no','0.00',NULL,'202607140013','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'COOLDRINKS','admin','madmin',NULL,NULL,'',NULL,'20.00','','','','',NULL,'20.00'),(19,'idly','1.0','10.00','10.00','Item',NULL,NULL,'no',NULL,NULL,'20260714-1-000014','02:56:40 AM','2026 07 14','admin','1','  Dine-in','  Cash','10.00','10.00','33',NULL,NULL,NULL,NULL,'14 Jul 2026','2026071402:56:40','%','0','10.00','no','0.00',NULL,'202607140256','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tiffin','admin','madmin',NULL,NULL,'',NULL,'10.00','','','','',NULL,'10.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-1-000011','50.00','admin','2026 07 05','  Cash','  Dine-in','50.00','0.00','0.00','0.0','1','202607051752',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(2,'20260705-1-000012','25.00','admin','2026 07 05','  Upiqr','  Dine-in','25.00','0.00','0.00','0.0','2','202607051753',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(3,'20260712-1-000011','10.00','admin','2026 07 12','  Cash','  Dine-in','10.00','0.00','0.00','0.0','3','202607121023',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(4,'20260712-1-000012','10.00','admin','2026 07 12','  Cash','  Dine-in','10.00','0.00','0.00','0.0','4','202607121027',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(5,'20260712-1-000013','10.00','admin','2026 07 12','  Cash','  Dine-in','10.00','0.00','0.00','0.0','5','202607121555',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(6,'20260712-1-000014','20.00','admin','2026 07 12','  Cash','  Dine-in','20.00','0.00','0.00','0.0','6','202607121714',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(7,'20260712-1-000015','25.00','admin','2026 07 12','  Cash','  Dine-in','25.00','0.00','0.00','0.0','7','202607122019',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(8,'20260712-1-000016','10.00','admin','2026 07 12','  Cash','  Dine-in','10.00','0.00','0.00','0.0','8','202607122200',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(9,'20260713-1-000011','10.00','admin','2026 07 13','  Cash','  Dine-in','10.00','0.00','0.00','0.0','9','202607131629',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(10,'20260713-1-000012','10.00','admin','2026 07 13','  Cash','  Dine-in','10.00','0.00','0.00','0.0','10','202607131629',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(11,'20260713-1-000013','10.00','admin','2026 07 13','  Cash','  Dine-in','10.00','0.00','0.00','0.0','11','202607131634',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(12,'20260713-1-000014','290.00','admin','2026 07 13','  Cash','  Dine-in','290.00','0.00','0.00','0.0','12','202607132314',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(13,'20260714-1-000011','240.00','admin','2026 07 14','  Cash','  Dine-in','240.00','0.00','0.00','0.0','13','202607140003',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(14,'20260714-1-000012','20.00','admin','2026 07 14','  Cash','  Dine-in','20.00','0.00','0.00','0.0','14','202607140012',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(15,'20260714-1-000013','20.00','admin','2026 07 14','  Cash','  Dine-in','20.00','0.00','0.00','0.0','15','202607140013',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(16,'20260714-1-000014','10.00','admin','2026 07 14','  Cash','  Dine-in','10.00','0.00','0.00','0.0','16','202607140256',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,'');
INSERT INTO `clicked_cust_name` (`_id`, `name`) VALUES (1,'');
