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,'MALABAR CHICKEN BIRIYANI','1.0','180.00','180.00','Item',NULL,NULL,'no',NULL,NULL,'20260204-1-000011','11:40:56 AM','2026 02 04','admin','1','  Dine-in','  Cash','180.00','180.00','1',NULL,NULL,NULL,NULL,'04 Feb 2026','2026020411:40:56','%','0','180.00','no','0.00',NULL,'202602041140','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'LUNCH ITEMS','admin','madmin',NULL,NULL,'',NULL,'180.00','','','','',NULL,'180.00'),(2,'GHEE RICE','1.0','100.00','100.00','Item',NULL,NULL,'no',NULL,NULL,'20260204-1-000012','11:45:00 AM','2026 02 04','admin','1','  Dine-in','  Cash','550.00','550.00','2',NULL,NULL,NULL,NULL,'04 Feb 2026','2026020411:45:00','%','0','100.00','no','0.00',NULL,'202602041145','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'LUNCH ITEMS','admin','madmin',NULL,NULL,'',NULL,'100.00','','','','',NULL,'100.00'),(3,'BIRIYANI RICE','1.0','100.00','100.00','Item',NULL,NULL,'no',NULL,NULL,'20260204-1-000012','11:45:00 AM','2026 02 04','admin','1','  Dine-in','  Cash','550.00','550.00','3',NULL,NULL,NULL,NULL,'04 Feb 2026','2026020411:45:00','%','0','100.00','no','0.00',NULL,'202602041145','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'LUNCH ITEMS','admin','madmin',NULL,NULL,'',NULL,'100.00','','','','',NULL,'100.00'),(4,'MALABAR BEEF BIRIYANI','1.0','200.00','200.00','Item',NULL,NULL,'no',NULL,NULL,'20260204-1-000012','11:45:00 AM','2026 02 04','admin','1','  Dine-in','  Cash','550.00','550.00','4',NULL,NULL,NULL,NULL,'04 Feb 2026','2026020411:45:00','%','0','200.00','no','0.00',NULL,'202602041145','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'LUNCH ITEMS','admin','madmin',NULL,NULL,'',NULL,'200.00','','','','',NULL,'200.00'),(5,'CHICKEN BIRIYANI','1.0','150.00','150.00','Item',NULL,NULL,'no',NULL,NULL,'20260204-1-000012','11:45:00 AM','2026 02 04','admin','1','  Dine-in','  Cash','550.00','550.00','5',NULL,NULL,NULL,NULL,'04 Feb 2026','2026020411:45:00','%','0','150.00','no','0.00',NULL,'202602041145','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'LUNCH ITEMS','admin','madmin',NULL,NULL,'',NULL,'150.00','','','','',NULL,'150.00'),(6,'EGG FRIED RICE','1.0','120.00','120.00','Item',NULL,NULL,'no',NULL,NULL,'20260204-1-000013','11:53:15 AM','2026 02 04','admin','1','  Dine-in','  Cash','440.00','440.00','6',NULL,NULL,NULL,NULL,'04 Feb 2026','2026020411:53:15','%','0','120.00','no','0.00',NULL,'202602041153','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'FRIED RICE ITEMS','admin','madmin',NULL,NULL,'',NULL,'120.00','','','','',NULL,'120.00'),(7,'BEEF FRIED RICE','1.0','180.00','180.00','Item',NULL,NULL,'no',NULL,NULL,'20260204-1-000013','11:53:15 AM','2026 02 04','admin','1','  Dine-in','  Cash','440.00','440.00','7',NULL,NULL,NULL,NULL,'04 Feb 2026','2026020411:53:15','%','0','180.00','no','0.00',NULL,'202602041153','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'FRIED RICE ITEMS','admin','madmin',NULL,NULL,'',NULL,'180.00','','','','',NULL,'180.00'),(8,'SCHEZWAN EGG FRIED RICE','1.0','140.00','140.00','Item',NULL,NULL,'no',NULL,NULL,'20260204-1-000013','11:53:15 AM','2026 02 04','admin','1','  Dine-in','  Cash','440.00','440.00','8',NULL,NULL,NULL,NULL,'04 Feb 2026','2026020411:53:15','%','0','140.00','no','0.00',NULL,'202602041153','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'FRIED RICE ITEMS','admin','madmin',NULL,NULL,'',NULL,'140.00','','','','',NULL,'140.00'),(9,'DOUBLE OMLETE','1.0','40.00','40.00','Item',NULL,NULL,'no',NULL,NULL,'20260208-1-000011','02:24:57 PM','2026 02 08','admin','1','  Dine-in','  Cash','40.00','40.00','13',NULL,NULL,NULL,NULL,'08 Feb 2026','2026020814:24:57','%','0','40.00','no','0.00',NULL,'202602081424','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'EGG ITEMS','admin','madmin',NULL,NULL,'',NULL,'40.00','','','','',NULL,'40.00'),(10,'BIRIYANI RICE','1.0','100.00','100.00','Item',NULL,NULL,'no',NULL,NULL,'20260208-1-000012','02:26:08 PM','2026 02 08','admin','1','  Dine-in','  Cash','100.00','100.00','14',NULL,NULL,NULL,NULL,'08 Feb 2026','2026020814:26:08','%','0','100.00','no','0.00',NULL,'202602081426','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'LUNCH ITEMS','admin','madmin',NULL,NULL,'',NULL,'100.00','','','','',NULL,'100.00'),(11,'MALABAR CHICKEN BIRIYANI','4.0','180.00','720.00','Item',NULL,NULL,'no',NULL,NULL,'20260208-1-000013','02:29:37 PM','2026 02 08','admin','1','  Dine-in','  Cash','720.00','720.00','15',NULL,NULL,NULL,NULL,'08 Feb 2026','2026020814:29:37','%','0','720.00','no','0.00',NULL,'202602081429','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'LUNCH ITEMS','admin','madmin',NULL,NULL,'',NULL,'720.00','','','','',NULL,'180.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,'20260204-1-000011','180.00','admin','2026 02 04','  Cash','  Dine-in','180.00','0.00','0.00','0.0','1','202602041140',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(2,'20260204-1-000012','550.00','admin','2026 02 04','  Cash','  Dine-in','550.00','0.00','0.00','0.0','2','202602041145',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(3,'20260204-1-000013','440.00','admin','2026 02 04','  Cash','  Dine-in','440.00','0.00','0.00','0.0','3','202602041153',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(4,'20260208-1-000011','40.00','admin','2026 02 08','  Cash','  Dine-in','40.00','0.00','0.00','0.0','4','202602081424',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(5,'20260208-1-000012','100.00','admin','2026 02 08','  Cash','  Dine-in','100.00','0.00','0.00','0.0','5','202602081426',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(6,'20260208-1-000013','720.00','admin','2026 02 08','  Cash','  Dine-in','720.00','0.00','0.00','0.0','6','202602081429',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,'');
INSERT INTO `clicked_cust_name` (`_id`, `name`) VALUES (1,'');
