INSERT INTO `billcount` (`_id`, `value`) VALUES (1,'1');
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 (2,'20240822-1-000011','270.00','admin','2024 08 22','  Cash','  Dine-in','270.00','0.00','0.00','0.0','2','202408221420',NULL,NULL,NULL,NULL,NULL,NULL),(3,'20240913-1-000011','205.00','admin','2024 09 13','  Card','  Dine-in','205.00','0.00','0.00','0.0','3','202409131148',NULL,NULL,NULL,NULL,NULL,NULL),(4,'20240913-1-000101','300.00','admin','2024 09 13','  Card','  Takeaway','300.00','0.00','0.00','0.0','4','202409131235',NULL,NULL,NULL,NULL,NULL,NULL),(5,'20240913-1-000012','150.00','admin','2024 09 13','  Cash','  Dine-in','150.00','0.00','0.00','0.0','5','202409131251',NULL,NULL,NULL,NULL,NULL,NULL),(6,'20240913-1-000013','400.00','admin','2024 09 13','  Cash','  Dine-in','400.00','0.00','0.00','0.0','6','202409131257',NULL,NULL,NULL,NULL,NULL,NULL),(7,'20240913-1-000014','300.00','admin','2024 09 13','  Card','  Dine-in','300.00','0.00','0.00','0.0','7','202409131309',NULL,NULL,NULL,NULL,NULL,NULL),(8,'20240913-1-000015','160.00','admin','2024 09 13','  Cash','  Dine-in','160.00','0.00','0.00','0.0','8','202409131323',NULL,NULL,NULL,NULL,NULL,NULL),(9,'20240913-1-000016','220.00','admin','2024 09 13','  Cash','  Dine-in','220.00','0.00','0.00','0.0','9','202409131324',NULL,NULL,NULL,NULL,NULL,NULL),(10,'20240913-1-000017','250.00','admin','2024 09 13','  Cash','  Dine-in','250.00','0.00','0.00','0.0','10','202409131349',NULL,NULL,NULL,NULL,NULL,NULL),(11,'20240913-1-000018','150.00','admin','2024 09 13','  Cash','  Dine-in','150.00','0.00','0.00','0.0','11','202409131351',NULL,NULL,NULL,NULL,NULL,NULL),(12,'20240913-1-000021','450.00','admin','2024 09 13','  Cash','  Dine-in','450.00','0.00','0.00','0.0','12','202409131412',NULL,NULL,NULL,NULL,NULL,NULL),(13,'20240913-1-000102','450.00','admin','2024 09 13','  Cash','  Dine-in','450.00','0.00','0.00','0.0','13','202409131421',NULL,NULL,NULL,NULL,NULL,NULL),(14,'20240913-1-000019','280.00','admin','2024 09 13','  Cash','  Dine-in','280.00','0.00','0.00','0.0','14','202409131430',NULL,NULL,NULL,NULL,NULL,NULL),(15,'20240913-1-000103','160.00','admin','2024 09 13','  Card','  Takeaway','160.00','0.00','0.00','0.0','15','202409131434',NULL,NULL,NULL,NULL,NULL,NULL),(16,'20240913-1-000022','180.00','admin','2024 09 13','  Card','  Dine-in','180.00','0.00','0.00','0.0','16','202409131439',NULL,NULL,NULL,NULL,NULL,NULL),(17,'20240913-1-0000110','690.00','admin','2024 09 13','  Cash','  Dine-in','690.00','0.00','0.00','0.0','17','202409131454',NULL,NULL,NULL,NULL,NULL,NULL),(18,'20240913-1-000051','80.00','admin','2024 09 13','  Cash','  Dine-in','80.00','0.00','0.00','0.0','18','202409131501',NULL,NULL,NULL,NULL,NULL,NULL),(19,'20240913-1-000031','755.00','admin','2024 09 13','  Cash','  Dine-in','755.00','0.00','0.00','0.0','19','202409131508',NULL,NULL,NULL,NULL,NULL,NULL),(20,'20240913-1-000032','175.00','admin','2024 09 13','  Cash','  Dine-in','175.00','0.00','0.00','0.0','20','202409131521',NULL,NULL,NULL,NULL,NULL,NULL),(21,'20240913-1-000023','470.00','admin','2024 09 13','  Cash','  Dine-in','470.00','0.00','0.00','0.0','21','202409131521',NULL,NULL,NULL,NULL,NULL,NULL),(22,'20240913-1-000024','350.00','admin','2024 09 13','  Cash','  Dine-in','350.00','0.00','0.00','0.0','22','202409131522',NULL,NULL,NULL,NULL,NULL,NULL),(23,'20240913-1-0000111','300.00','admin','2024 09 13','  Cash','  Dine-in','300.00','0.00','0.00','0.0','23','202409131648',NULL,NULL,NULL,NULL,NULL,NULL),(24,'20240913-1-0000112','410.00','admin','2024 09 13','  Cash','  Takeaway','410.00','0.00','0.00','0.0','24','202409131653',NULL,NULL,NULL,NULL,NULL,NULL),(25,'20240913-1-0000113','140.00','admin','2024 09 13','  Card','  Takeaway','140.00','0.00','0.00','0.0','25','202409131708',NULL,NULL,NULL,NULL,NULL,NULL),(26,'20240913-1-0000114','340.00','admin','2024 09 13','  Card','  Takeaway','340.00','0.00','0.00','0.0','26','202409131904',NULL,NULL,NULL,NULL,NULL,NULL),(27,'20240913-1-0000115','215.00','admin','2024 09 13','  Card','  Dine-in','215.00','0.00','0.00','0.0','27','202409131914',NULL,NULL,NULL,NULL,NULL,NULL),(28,'20240913-1-000033','190.00','admin','2024 09 13','  Cash','  Dine-in','190.00','0.00','0.00','0.0','28','202409131945',NULL,NULL,NULL,NULL,NULL,NULL),(29,'20240913-1-000104','200.00','admin','2024 09 13','  Cash','  Dine-in','200.00','0.00','0.00','0.0','29','202409132019',NULL,NULL,NULL,NULL,NULL,NULL),(30,'20240913-1-0000116','380.00','admin','2024 09 13','  Cash','  Dine-in','380.00','0.00','0.00','0.0','30','202409132022',NULL,NULL,NULL,NULL,NULL,NULL),(31,'20240913-1-000105','300.00','admin','2024 09 13','  Cash','  Dine-in','300.00','0.00','0.00','0.0','31','202409132032',NULL,NULL,NULL,NULL,NULL,NULL),(32,'20240913-1-000091','630.00','admin','2024 09 13','  Cash','  Dine-in','630.00','0.00','0.00','0.0','32','202409132110',NULL,NULL,NULL,NULL,NULL,NULL),(33,'20240913-1-000106','290.00','admin','2024 09 13','  Cash','  Dine-in','290.00','0.00','0.00','0.0','33','202409132112',NULL,NULL,NULL,NULL,NULL,NULL),(34,'20240913-1-000081','90.00','admin','2024 09 13','  Cash','  Dine-in','90.00','0.00','0.00','0.0','34','202409132113',NULL,NULL,NULL,NULL,NULL,NULL),(35,'20240913-1-000071','300.00','admin','2024 09 13','  Card','  Takeaway','300.00','0.00','0.00','0.0','35','202409132114',NULL,NULL,NULL,NULL,NULL,NULL),(36,'20240913-1-000052','280.00','admin','2024 09 13','  Cash','  Dine-in','280.00','0.00','0.00','0.0','36','202409132129',NULL,NULL,NULL,NULL,NULL,NULL),(37,'20240913-1-000107','300.00','admin','2024 09 13','  Card','  Dine-in','300.00','0.00','0.00','0.0','37','202409132133',NULL,NULL,NULL,NULL,NULL,NULL),(38,'20240913-1-0000117','160.00','admin','2024 09 13','  Card','  Takeaway','160.00','0.00','0.00','0.0','38','202409132141',NULL,NULL,NULL,NULL,NULL,NULL),(39,'20240913-1-0000118','760.00','admin','2024 09 13','  Cash','  Dine-in','760.00','0.00','0.00','0.0','39','202409132227',NULL,NULL,NULL,NULL,NULL,NULL),(40,'20240913-1-0000119','50.00','admin','2024 09 13','  Cash','  Dine-in','50.00','0.00','0.00','0.0','40','202409132228',NULL,NULL,NULL,NULL,NULL,NULL),(41,'20240913-1-0000120','130.00','admin','2024 09 13','  Cash','  Dine-in','130.00','0.00','0.00','0.0','41','202409132254',NULL,NULL,NULL,NULL,NULL,NULL),(42,'20240914-1-000011','90.00','admin','2024 09 14','  Cash','  Dine-in','90.00','0.00','0.00','0.0','42','202409141951',NULL,NULL,NULL,NULL,NULL,NULL),(43,'20240914-1-000012','430.00','admin','2024 09 14','  Cash','  Dine-in','430.00','0.00','0.00','0.0','43','202409141953',NULL,NULL,NULL,NULL,NULL,NULL),(44,'20240914-1-000013','90.00','admin','2024 09 14','  Cash','  Dine-in','90.00','0.00','0.00','0.0','44','202409141954',NULL,NULL,NULL,NULL,NULL,NULL),(45,'20240914-1-000014','150.00','admin','2024 09 14','  Cash','  Dine-in','150.00','0.00','0.00','0.0','45','202409141955',NULL,NULL,NULL,NULL,NULL,NULL),(46,'20240914-1-000015','200.00','admin','2024 09 14','  Cash','  Dine-in','200.00','0.00','0.00','0.0','46','202409141956',NULL,NULL,NULL,NULL,NULL,NULL),(47,'20240914-1-000016','740.00','admin','2024 09 14','  Cash','  Dine-in','740.00','0.00','0.00','0.0','47','202409142000',NULL,NULL,NULL,NULL,NULL,NULL),(48,'20240914-1-000017','180.00','admin','2024 09 14','  Cash','  Dine-in','180.00','0.00','0.00','0.0','48','202409142002',NULL,NULL,NULL,NULL,NULL,NULL),(49,'20240914-1-000018','80.00','admin','2024 09 14','  Cash','  Dine-in','80.00','0.00','0.00','0.0','49','202409142003',NULL,NULL,NULL,NULL,NULL,NULL),(50,'20240914-1-000019','130.00','admin','2024 09 14','  Cash','  Dine-in','130.00','0.00','0.00','0.0','50','202409142003',NULL,NULL,NULL,NULL,NULL,NULL),(51,'20240914-1-0000110','100.00','admin','2024 09 14','  Cash','  Dine-in','100.00','0.00','0.00','0.0','51','202409142004',NULL,NULL,NULL,NULL,NULL,NULL),(52,'20240914-1-0000111','390.00','admin','2024 09 14','  Cash','  Dine-in','390.00','0.00','0.00','0.0','52','202409142005',NULL,NULL,NULL,NULL,NULL,NULL),(53,'20240914-1-0000112','80.00','admin','2024 09 14','  Cash','  Dine-in','80.00','0.00','0.00','0.0','53','202409142005',NULL,NULL,NULL,NULL,NULL,NULL),(54,'20240914-1-0000113','170.00','admin','2024 09 14','  Cash','  Dine-in','170.00','0.00','0.00','0.0','54','202409142006',NULL,NULL,NULL,NULL,NULL,NULL),(55,'20240914-1-0000114','50.00','admin','2024 09 14','  Cash','  Dine-in','50.00','0.00','0.00','0.0','55','202409142007',NULL,NULL,NULL,NULL,NULL,NULL),(56,'20240914-1-0000115','780.00','admin','2024 09 14','  Cash','  Dine-in','780.00','0.00','0.00','0.0','56','202409142010',NULL,NULL,NULL,NULL,NULL,NULL),(57,'20240914-1-0000116','170.00','admin','2024 09 14','  Cash','  Dine-in','170.00','0.00','0.00','0.0','57','202409142011',NULL,NULL,NULL,NULL,NULL,NULL),(58,'20240914-1-0000117','160.00','admin','2024 09 14','  Cash','  Dine-in','160.00','0.00','0.00','0.0','58','202409142012',NULL,NULL,NULL,NULL,NULL,NULL),(59,'20240914-1-0000118','160.00','admin','2024 09 14','  Cash','  Dine-in','160.00','0.00','0.00','0.0','59','202409142012',NULL,NULL,NULL,NULL,NULL,NULL),(60,'20240914-1-0000119','50.00','admin','2024 09 14','  Cash','  Dine-in','50.00','0.00','0.00','0.0','60','202409142014',NULL,NULL,NULL,NULL,NULL,NULL),(61,'20240914-1-0000120','260.00','admin','2024 09 14','  Cash','  Dine-in','260.00','0.00','0.00','0.0','61','202409142017',NULL,NULL,NULL,NULL,NULL,NULL),(62,'20240914-1-0000121','80.00','admin','2024 09 14','  Cash','  Dine-in','80.00','0.00','0.00','0.0','62','202409142018',NULL,NULL,NULL,NULL,NULL,NULL),(63,'20240914-1-0000122','100.00','admin','2024 09 14','  Cash','  Dine-in','100.00','0.00','0.00','0.0','63','202409142020',NULL,NULL,NULL,NULL,NULL,NULL),(64,'20240914-1-0000123','480.00','admin','2024 09 14','  Cash','  Dine-in','480.00','0.00','0.00','0.0','64','202409142022',NULL,NULL,NULL,NULL,NULL,NULL),(65,'20240914-1-0000124','150.00','admin','2024 09 14','  Cash','  Dine-in','150.00','0.00','0.00','0.0','65','202409142022',NULL,NULL,NULL,NULL,NULL,NULL),(66,'20240914-1-0000125','320.00','admin','2024 09 14','  Cash','  Dine-in','320.00','0.00','0.00','0.0','66','202409142022',NULL,NULL,NULL,NULL,NULL,NULL),(67,'20240914-1-0000126','320.00','admin','2024 09 14','  Cash','  Dine-in','320.00','0.00','0.00','0.0','67','202409142023',NULL,NULL,NULL,NULL,NULL,NULL),(68,'20240914-1-0000127','150.00','admin','2024 09 14','  Cash','  Dine-in','150.00','0.00','0.00','0.0','68','202409142024',NULL,NULL,NULL,NULL,NULL,NULL),(69,'20240914-1-0000128','735.00','admin','2024 09 14','  Cash','  Dine-in','735.00','0.00','0.00','0.0','69','202409142026',NULL,NULL,NULL,NULL,NULL,NULL),(70,'20240914-1-0000129','100.00','admin','2024 09 14','  Cash','  Dine-in','100.00','0.00','0.00','0.0','70','202409142027',NULL,NULL,NULL,NULL,NULL,NULL),(71,'20240914-1-0000130','150.00','admin','2024 09 14','  Cash','  Dine-in','150.00','0.00','0.00','0.0','71','202409142027',NULL,NULL,NULL,NULL,NULL,NULL),(72,'20240914-1-0000131','150.00','admin','2024 09 14','  Cash','  Dine-in','150.00','0.00','0.00','0.0','72','202409142029',NULL,NULL,NULL,NULL,NULL,NULL),(73,'20240914-1-0000132','330.00','admin','2024 09 14','  Cash','  Dine-in','330.00','0.00','0.00','0.0','73','202409142030',NULL,NULL,NULL,NULL,NULL,NULL),(74,'20240914-1-0000133','300.00','admin','2024 09 14','  Cash','  Dine-in','300.00','0.00','0.00','0.0','74','202409142032',NULL,NULL,NULL,NULL,NULL,NULL),(75,'20240914-1-0000134','190.00','admin','2024 09 14','  Cash','  Dine-in','190.00','0.00','0.00','0.0','75','202409142033',NULL,NULL,NULL,NULL,NULL,NULL),(76,'20240914-1-0000135','80.00','admin','2024 09 14','  Cash','  Dine-in','80.00','0.00','0.00','0.0','76','202409142033',NULL,NULL,NULL,NULL,NULL,NULL),(77,'20240914-1-0000136','150.00','admin','2024 09 14','  Cash','  Takeaway','150.00','0.00','0.00','0.0','77','202409142033',NULL,NULL,NULL,NULL,NULL,NULL),(78,'20240914-1-0000137','100.00','admin','2024 09 14','  Cash','  Dine-in','100.00','0.00','0.00','0.0','78','202409142056',NULL,NULL,NULL,NULL,NULL,NULL),(79,'20240914-1-0000138','1485.00','admin','2024 09 14','  Cash','  Dine-in','1485.00','0.00','0.00','0.0','79','202409142216',NULL,NULL,NULL,NULL,NULL,NULL),(80,'20240914-1-0000139','260.00','admin','2024 09 14','  Cash','  Dine-in','260.00','0.00','0.00','0.0','80','202409142221',NULL,NULL,NULL,NULL,NULL,NULL),(81,'20240914-1-0000140','130.00','admin','2024 09 14','  Cash','  Dine-in','130.00','0.00','0.00','0.0','81','202409142223',NULL,NULL,NULL,NULL,NULL,NULL),(82,'20240914-1-0000141','250.00','admin','2024 09 14','  Cash','  Dine-in','250.00','0.00','0.00','0.0','82','202409142230',NULL,NULL,NULL,NULL,NULL,NULL),(83,'20240914-1-0000142','600.00','admin','2024 09 14','  Cash','  Dine-in','600.00','0.00','0.00','0.0','83','202409142235',NULL,NULL,NULL,NULL,NULL,NULL),(84,'20240915-1-000101','150.00','admin','2024 09 15','  Cash','  Dine-in','150.00','0.00','0.00','0.0','84','202409151201',NULL,NULL,NULL,NULL,NULL,NULL),(85,'20240915-1-000102','120.00','admin','2024 09 15','  Card','  Takeaway','120.00','0.00','0.00','0.0','85','202409151237',NULL,NULL,NULL,NULL,NULL,NULL),(86,'20240915-1-000103','470.00','admin','2024 09 15','  Card','  Dine-in','470.00','0.00','0.00','0.0','86','202409151246',NULL,NULL,NULL,NULL,NULL,NULL),(87,'20240915-1-000081','440.00','admin','2024 09 15','  Cash','  Dine-in','440.00','0.00','0.00','0.0','87','202409151252',NULL,NULL,NULL,NULL,NULL,NULL),(88,'20240915-1-000104','90.00','admin','2024 09 15','  Cash','  Takeaway','90.00','0.00','0.00','0.0','88','202409151315',NULL,NULL,NULL,NULL,NULL,NULL),(89,'20240915-1-000082','240.00','admin','2024 09 15','  Cash','  Dine-in','240.00','0.00','0.00','0.0','89','202409151323',NULL,NULL,NULL,NULL,NULL,NULL),(90,'20240915-1-000105','525.00','admin','2024 09 15','  Cash','  Dine-in','525.00','0.00','0.00','0.0','90','202409151324',NULL,NULL,NULL,NULL,NULL,NULL),(91,'20240915-1-000091','200.00','admin','2024 09 15','  Cash','  Dine-in','200.00','0.00','0.00','0.0','91','202409151326',NULL,NULL,NULL,NULL,NULL,NULL),(92,'20240915-1-000106','150.00','admin','2024 09 15','  Cash','  Takeaway','150.00','0.00','0.00','0.0','92','202409151328',NULL,NULL,NULL,NULL,NULL,NULL),(93,'20240915-1-000071','90.00','admin','2024 09 15','  Cash','  Dine-in','90.00','0.00','0.00','0.0','93','202409151342',NULL,NULL,NULL,NULL,NULL,NULL),(94,'20240915-1-000021','325.00','admin','2024 09 15','  Cash','  Dine-in','325.00','0.00','0.00','0.0','94','202409151342',NULL,NULL,NULL,NULL,NULL,NULL),(95,'20240915-1-000083','120.00','admin','2024 09 15','  Cash','  Dine-in','120.00','0.00','0.00','0.0','95','202409151354',NULL,NULL,NULL,NULL,NULL,NULL),(96,'20240915-1-000107','300.00','admin','2024 09 15','  Pay Later','  Takeaway','300.00','0.00','0.00','0.0','96','202409151400',NULL,NULL,NULL,NULL,NULL,NULL),(97,'20240915-1-000011','300.00','admin','2024 09 15','  Cash','  Dine-in','300.00','0.00','0.00','0.0','97','202409151409',NULL,NULL,NULL,NULL,NULL,NULL),(98,'20240915-1-000012','20.00','admin','2024 09 15','  Cash','  Dine-in','20.00','0.00','0.00','0.0','98','202409151417',NULL,NULL,NULL,NULL,NULL,NULL),(99,'20240915-1-000031','280.00','admin','2024 09 15','  Cash','  Dine-in','280.00','0.00','0.00','0.0','99','202409151421',NULL,NULL,NULL,NULL,NULL,NULL),(100,'20240915-1-000013','80.00','admin','2024 09 15','  Cash','  Dine-in','80.00','0.00','0.00','0.0','100','202409151525',NULL,NULL,NULL,NULL,NULL,NULL),(101,'20240915-1-000014','280.00','admin','2024 09 15','  Card','  Dine-in','280.00','0.00','0.00','0.0','101','202409151526',NULL,NULL,NULL,NULL,NULL,NULL),(102,'20240915-1-000015','520.00','admin','2024 09 15','  Cash','  Dine-in','520.00','0.00','0.00','0.0','102','202409151527',NULL,NULL,NULL,NULL,NULL,NULL),(103,'20240915-1-000016','90.00','admin','2024 09 15','  Cash','  Dine-in','90.00','0.00','0.00','0.0','103','202409151527',NULL,NULL,NULL,NULL,NULL,NULL),(104,'20240915-1-000017','180.00','admin','2024 09 15','  Card','  Dine-in','180.00','0.00','0.00','0.0','104','202409151529',NULL,NULL,NULL,NULL,NULL,NULL),(105,'20240915-1-000018','280.00','admin','2024 09 15','  Cash','  Dine-in','280.00','0.00','0.00','0.0','105','202409151529',NULL,NULL,NULL,NULL,NULL,NULL),(106,'20240915-1-000019','260.00','admin','2024 09 15','  Cash','  Dine-in','260.00','0.00','0.00','0.0','106','202409151531',NULL,NULL,NULL,NULL,NULL,NULL),(107,'20240915-1-0000110','150.00','admin','2024 09 15','  Card','  Dine-in','150.00','0.00','0.00','0.0','107','202409151531',NULL,NULL,NULL,NULL,NULL,NULL),(108,'20240915-1-0000111','170.00','admin','2024 09 15','  Cash','  Dine-in','170.00','0.00','0.00','0.0','108','202409151532',NULL,NULL,NULL,NULL,NULL,NULL),(109,'20240915-1-0000112','570.00','admin','2024 09 15','  Cash','  Dine-in','570.00','0.00','0.00','0.0','109','202409151542',NULL,NULL,NULL,NULL,NULL,NULL),(110,'20240915-1-0000113','430.00','admin','2024 09 15','  Cash','  Dine-in','430.00','0.00','0.00','0.0','110','202409151612',NULL,NULL,NULL,NULL,NULL,NULL),(111,'20240915-1-0000114','130.00','admin','2024 09 15','  Cash','  Dine-in','130.00','0.00','0.00','0.0','111','202409151612',NULL,NULL,NULL,NULL,NULL,NULL),(112,'20240915-1-0000115','70.00','admin','2024 09 15','  Cash','  Dine-in','70.00','0.00','0.00','0.0','112','202409151615',NULL,NULL,NULL,NULL,NULL,NULL),(113,'20240915-1-0000116','150.00','admin','2024 09 15','  Cash','  Dine-in','150.00','0.00','0.00','0.0','113','202409151815',NULL,NULL,NULL,NULL,NULL,NULL),(114,'20240915-1-0000117','330.00','admin','2024 09 15','  Cash','  Dine-in','330.00','0.00','0.00','0.0','114','202409151816',NULL,NULL,NULL,NULL,NULL,NULL),(115,'20240915-1-0000118','130.00','admin','2024 09 15','  Cash','  Dine-in','130.00','0.00','0.00','0.0','115','202409151816',NULL,NULL,NULL,NULL,NULL,NULL),(116,'20240915-1-0000119','380.00','admin','2024 09 15','  Card','  Dine-in','380.00','0.00','0.00','0.0','116','202409151834',NULL,NULL,NULL,NULL,NULL,NULL),(117,'20240915-1-0000120','750.00','admin','2024 09 15','  Card','  Dine-in','750.00','0.00','0.00','0.0','117','202409151850',NULL,NULL,NULL,NULL,NULL,NULL),(118,'20240915-1-0000121','250.00','admin','2024 09 15','  Cash','  Dine-in','250.00','0.00','0.00','0.0','118','202409151939',NULL,NULL,NULL,NULL,NULL,NULL),(119,'20240915-1-0000122','450.00','admin','2024 09 15','  Cash','  Takeaway','450.00','0.00','0.00','0.0','119','202409151941',NULL,NULL,NULL,NULL,NULL,NULL),(120,'20240915-1-0000123','260.00','admin','2024 09 15','  Cash','  Takeaway','260.00','0.00','0.00','0.0','120','202409151942',NULL,NULL,NULL,NULL,NULL,NULL),(121,'20240915-1-000108','450.00','admin','2024 09 15','  Card','  Takeaway','450.00','0.00','0.00','0.0','121','202409151949',NULL,NULL,NULL,NULL,NULL,NULL),(122,'20240915-1-000072','250.00','admin','2024 09 15','  Cash','  Takeaway','250.00','0.00','0.00','0.0','122','202409151950',NULL,NULL,NULL,NULL,NULL,NULL),(123,'20240915-1-000073','160.00','admin','2024 09 15','  Cash','  Dine-in','160.00','0.00','0.00','0.0','123','202409151951',NULL,NULL,NULL,NULL,NULL,NULL),(124,'20240915-1-000074','160.00','admin','2024 09 15','  Card','  Dine-in','160.00','0.00','0.00','0.0','124','202409152034',NULL,NULL,NULL,NULL,NULL,NULL),(125,'20240915-1-000075','140.00','admin','2024 09 15','  Card','  Dine-in','140.00','0.00','0.00','0.0','125','202409152041',NULL,NULL,NULL,NULL,NULL,NULL),(126,'20240915-1-000092','320.00','admin','2024 09 15','  Cash','  Dine-in','320.00','0.00','0.00','0.0','126','202409152041',NULL,NULL,NULL,NULL,NULL,NULL),(127,'20240915-1-000093','100.00','admin','2024 09 15','  Cash','  Dine-in','100.00','0.00','0.00','0.0','127','202409152043',NULL,NULL,NULL,NULL,NULL,NULL),(128,'20240915-1-000094','90.00','admin','2024 09 15','  Cash','  Dine-in','90.00','0.00','0.00','0.0','128','202409152043',NULL,NULL,NULL,NULL,NULL,NULL),(129,'20240915-1-000022','220.00','admin','2024 09 15','  Cash','  Dine-in','220.00','0.00','0.00','0.0','129','202409152055',NULL,NULL,NULL,NULL,NULL,NULL),(130,'20240915-1-000095','385.00','admin','2024 09 15','  Cash','  Takeaway','385.00','0.00','0.00','0.0','130','202409152057',NULL,NULL,NULL,NULL,NULL,NULL),(131,'20240915-1-000109','180.00','admin','2024 09 15','  Card','  Dine-in','180.00','0.00','0.00','0.0','131','202409152126',NULL,NULL,NULL,NULL,NULL,NULL),(132,'20240915-1-000096','130.00','admin','2024 09 15','  Card','  Dine-in','130.00','0.00','0.00','0.0','132','202409152127',NULL,NULL,NULL,NULL,NULL,NULL),(133,'20240915-1-000023','150.00','admin','2024 09 15','  Cash','  Dine-in','150.00','0.00','0.00','0.0','133','202409152131',NULL,NULL,NULL,NULL,NULL,NULL),(134,'20240915-1-000051','580.00','admin','2024 09 15','  Cash','  Dine-in','580.00','0.00','0.00','0.0','134','202409152140',NULL,NULL,NULL,NULL,NULL,NULL),(135,'20240915-1-000032','300.00','admin','2024 09 15','  Cash','  Dine-in','300.00','0.00','0.00','0.0','135','202409152146',NULL,NULL,NULL,NULL,NULL,NULL),(136,'20240915-1-000084','580.00','admin','2024 09 15','  Cash','  Dine-in','580.00','0.00','0.00','0.0','136','202409152147',NULL,NULL,NULL,NULL,NULL,NULL),(137,'20240916-1-000091','300.00','admin','2024 09 16','  Card','  Dine-in','300.00','0.00','0.00','0.0','137','202409161215',NULL,NULL,NULL,NULL,NULL,NULL),(138,'20240916-1-000101','300.00','admin','2024 09 16','  Cash','  Dine-in','300.00','0.00','0.00','0.0','138','202409161215',NULL,NULL,NULL,NULL,NULL,NULL),(139,'20240916-1-000092','240.00','admin','2024 09 16','  Cash','  Dine-in','240.00','0.00','0.00','0.0','139','202409161226',NULL,NULL,NULL,NULL,NULL,NULL),(140,'20240916-1-000102','450.00','admin','2024 09 16','  Cash','  Takeaway','450.00','0.00','0.00','0.0','140','202409161227',NULL,NULL,NULL,NULL,NULL,NULL),(141,'20240916-1-000071','330.00','admin','2024 09 16','  Cash','  Dine-in','330.00','0.00','0.00','0.0','141','202409161253',NULL,NULL,NULL,NULL,NULL,NULL),(142,'20240916-1-000103','300.00','admin','2024 09 16','  Card','  Dine-in','300.00','0.00','0.00','0.0','142','202409161259',NULL,NULL,NULL,NULL,NULL,NULL),(143,'20240916-1-000104','280.00','admin','2024 09 16','  Cash','  Dine-in','280.00','0.00','0.00','0.0','143','202409161309',NULL,NULL,NULL,NULL,NULL,NULL),(144,'20240916-1-000081','100.00','admin','2024 09 16','  Cash','  Dine-in','100.00','0.00','0.00','0.0','144','202409161346',NULL,NULL,NULL,NULL,NULL,NULL),(145,'20240916-1-000072','100.00','admin','2024 09 16','  Cash','  Dine-in','100.00','0.00','0.00','0.0','145','202409161347',NULL,NULL,NULL,NULL,NULL,NULL),(146,'20240916-1-000061','280.00','admin','2024 09 16','  Card','  Dine-in','280.00','0.00','0.00','0.0','146','202409161409',NULL,NULL,NULL,NULL,NULL,NULL),(147,'20240916-1-000082','180.00','admin','2024 09 16','  Cash','  Dine-in','180.00','0.00','0.00','0.0','147','202409161410',NULL,NULL,NULL,NULL,NULL,NULL),(148,'20240916-1-000041','300.00','admin','2024 09 16','  Cash','  Dine-in','300.00','0.00','0.00','0.0','148','202409161417',NULL,NULL,NULL,NULL,NULL,NULL),(149,'20240916-1-000105','150.00','admin','2024 09 16','  Cash','  Dine-in','150.00','0.00','0.00','0.0','149','202409161422',NULL,NULL,NULL,NULL,NULL,NULL),(150,'20240916-1-000106','80.00','admin','2024 09 16','  Cash','  Dine-in','80.00','0.00','0.00','0.0','150','202409161424',NULL,NULL,NULL,NULL,NULL,NULL),(151,'20240916-1-000021','150.00','admin','2024 09 16','  Card','  Dine-in','150.00','0.00','0.00','0.0','151','202409161506',NULL,NULL,NULL,NULL,NULL,NULL),(152,'20240916-1-000093','509.00','admin','2024 09 16','  Cash','  Dine-in','509.00','0.00','0.00','0.0','152','202409161544',NULL,NULL,NULL,NULL,NULL,NULL),(153,'20240916-1-000031','430.00','admin','2024 09 16','  Cash','  Dine-in','430.00','0.00','0.00','0.0','153','202409161614',NULL,NULL,NULL,NULL,NULL,NULL),(154,'20240916-1-000083','250.00','admin','2024 09 16','  Card','  Dine-in','250.00','0.00','0.00','0.0','154','202409161633',NULL,NULL,NULL,NULL,NULL,NULL),(155,'20240916-1-000084','250.00','admin','2024 09 16','  Cash','  Dine-in','250.00','0.00','0.00','0.0','155','202409161634',NULL,NULL,NULL,NULL,NULL,NULL),(156,'20240916-1-000085','270.00','admin','2024 09 16','  Cash','  Dine-in','270.00','0.00','0.00','0.0','156','202409161635',NULL,NULL,NULL,NULL,NULL,NULL),(157,'20240916-1-000011','319.00','admin','2024 09 16','  Card','  Dine-in','319.00','0.00','0.00','0.0','157','202409161655',NULL,NULL,NULL,NULL,NULL,NULL),(158,'20240916-1-000032','370.00','admin','2024 09 16','  Cash','  Dine-in','370.00','0.00','0.00','0.0','158','202409161732',NULL,NULL,NULL,NULL,NULL,NULL),(159,'20240916-1-000073','250.00','admin','2024 09 16','  Cash','  Dine-in','250.00','0.00','0.00','0.0','159','202409161733',NULL,NULL,NULL,NULL,NULL,NULL),(160,'20240916-1-000094','490.00','admin','2024 09 16','  Card','  Dine-in','490.00','0.00','0.00','0.0','160','202409161737',NULL,NULL,NULL,NULL,NULL,NULL),(161,'20240916-1-000086','170.00','admin','2024 09 16','  Cash','  Dine-in','170.00','0.00','0.00','0.0','161','202409161743',NULL,NULL,NULL,NULL,NULL,NULL),(162,'20240916-1-000033','460.00','admin','2024 09 16','  Cash','  Dine-in','460.00','0.00','0.00','0.0','162','202409161800',NULL,NULL,NULL,NULL,NULL,NULL),(163,'20240916-1-000012','90.00','admin','2024 09 16','  Card','  Dine-in','90.00','0.00','0.00','0.0','163','202409161831',NULL,NULL,NULL,NULL,NULL,NULL),(164,'20240916-1-000013','150.00','admin','2024 09 16','  Cash','  Dine-in','150.00','0.00','0.00','0.0','164','202409161920',NULL,NULL,NULL,NULL,NULL,NULL),(165,'20240916-1-000014','110.00','admin','2024 09 16','  Card','  Dine-in','110.00','0.00','0.00','0.0','165','202409161930',NULL,NULL,NULL,NULL,NULL,NULL),(166,'20240916-1-000107','250.00','admin','2024 09 16','  Cash','  Dine-in','250.00','0.00','0.00','0.0','166','202409162022',NULL,NULL,NULL,NULL,NULL,NULL),(167,'20240916-1-000108','300.00','admin','2024 09 16','  Cash','  Dine-in','300.00','0.00','0.00','0.0','167','202409162031',NULL,NULL,NULL,NULL,NULL,NULL),(168,'20240916-1-000074','240.00','admin','2024 09 16','  Card','  Dine-in','240.00','0.00','0.00','0.0','168','202409162037',NULL,NULL,NULL,NULL,NULL,NULL),(169,'20240916-1-000042','190.00','admin','2024 09 16','  Card','  Dine-in','190.00','0.00','0.00','0.0','169','202409162051',NULL,NULL,NULL,NULL,NULL,NULL),(170,'20240916-1-000087','160.00','admin','2024 09 16','  Cash','  Dine-in','160.00','0.00','0.00','0.0','170','202409162052',NULL,NULL,NULL,NULL,NULL,NULL),(171,'20240916-1-000062','150.00','admin','2024 09 16','  Cash','  Dine-in','150.00','0.00','0.00','0.0','171','202409162054',NULL,NULL,NULL,NULL,NULL,NULL),(172,'20240916-1-000109','60.00','admin','2024 09 16','  Cash','  Takeaway','60.00','0.00','0.00','0.0','172','202409162102',NULL,NULL,NULL,NULL,NULL,NULL),(173,'20240916-1-0001010','80.00','admin','2024 09 16','  Card','  Dine-in','80.00','0.00','0.00','0.0','173','202409162109',NULL,NULL,NULL,NULL,NULL,NULL),(174,'20240916-1-000015','300.00','admin','2024 09 16','  Cash','  Dine-in','300.00','0.00','0.00','0.0','174','202409162244',NULL,NULL,NULL,NULL,NULL,NULL),(175,'20240916-1-000016','150.00','admin','2024 09 16','  Cash','  Dine-in','150.00','0.00','0.00','0.0','175','202409162245',NULL,NULL,NULL,NULL,NULL,NULL),(176,'20240916-1-000017','100.00','admin','2024 09 16','  Cash','  Dine-in','100.00','0.00','0.00','0.0','176','202409162246',NULL,NULL,NULL,NULL,NULL,NULL),(177,'20240916-1-000018','100.00','admin','2024 09 16','  Cash','  Dine-in','100.00','0.00','0.00','0.0','177','202409162246',NULL,NULL,NULL,NULL,NULL,NULL),(178,'20240917-1-000011','300.00','admin','2024 09 17','  Cash','  Dine-in','300.00','0.00','0.00','0.0','178','202409171205',NULL,NULL,NULL,NULL,NULL,NULL),(179,'20240917-1-000012','200.00','admin','2024 09 17','  Cash','  Dine-in','200.00','0.00','0.00','0.0','179','202409171221',NULL,NULL,NULL,NULL,NULL,NULL),(180,'20240917-1-000101','150.00','admin','2024 09 17','  Cash','  Dine-in','150.00','0.00','0.00','0.0','180','202409171318',NULL,NULL,NULL,NULL,NULL,NULL),(181,'20240917-1-000081','140.00','admin','2024 09 17','  Cash','  Dine-in','140.00','0.00','0.00','0.0','181','202409171319',NULL,NULL,NULL,NULL,NULL,NULL),(182,'20240917-1-000091','150.00','admin','2024 09 17','  Cash','  Dine-in','150.00','0.00','0.00','0.0','182','202409171323',NULL,NULL,NULL,NULL,NULL,NULL),(183,'20240917-1-000071','200.00','admin','2024 09 17','  Cash','  Dine-in','200.00','0.00','0.00','0.0','183','202409171334',NULL,NULL,NULL,NULL,NULL,NULL),(184,'20240917-1-000102','80.00','admin','2024 09 17','  Cash','  Dine-in','80.00','0.00','0.00','0.0','184','202409171346',NULL,NULL,NULL,NULL,NULL,NULL),(185,'20240917-1-000051','450.00','admin','2024 09 17','  Cash','  Dine-in','450.00','0.00','0.00','0.0','185','202409171347',NULL,NULL,NULL,NULL,NULL,NULL),(186,'20240917-1-000031','920.00','admin','2024 09 17','  Cash','  Dine-in','920.00','0.00','0.00','0.0','186','202409171405',NULL,NULL,NULL,NULL,NULL,NULL),(187,'20240917-1-000082','200.00','admin','2024 09 17','  Cash','  Dine-in','200.00','0.00','0.00','0.0','187','202409171413',NULL,NULL,NULL,NULL,NULL,NULL),(188,'20240917-1-000103','110.00','admin','2024 09 17','  Cash','  Dine-in','110.00','0.00','0.00','0.0','188','202409171416',NULL,NULL,NULL,NULL,NULL,NULL),(189,'20240917-1-000092','160.00','admin','2024 09 17','  Cash','  Dine-in','160.00','0.00','0.00','0.0','189','202409171418',NULL,NULL,NULL,NULL,NULL,NULL),(190,'20240917-1-000013','220.00','admin','2024 09 17','  Cash','  Dine-in','220.00','0.00','0.00','0.0','190','202409171419',NULL,NULL,NULL,NULL,NULL,NULL),(191,'20240917-1-000032','330.00','admin','2024 09 17','  Cash','  Dine-in','330.00','0.00','0.00','0.0','191','202409171444',NULL,NULL,NULL,NULL,NULL,NULL),(192,'20240917-1-000072','749.00','admin','2024 09 17','  Cash','  Dine-in','749.00','0.00','0.00','0.0','192','202409171503',NULL,NULL,NULL,NULL,NULL,NULL),(193,'20240917-1-000021','450.00','admin','2024 09 17','  Cash','  Dine-in','450.00','0.00','0.00','0.0','193','202409171510',NULL,NULL,NULL,NULL,NULL,NULL),(194,'20240917-1-000014','400.00','admin','2024 09 17','  Cash','  Dine-in','400.00','0.00','0.00','0.0','194','202409171516',NULL,NULL,NULL,NULL,NULL,NULL),(195,'20240917-1-000015','320.00','admin','2024 09 17','  Cash','  Dine-in','320.00','0.00','0.00','0.0','195','202409171526',NULL,NULL,NULL,NULL,NULL,NULL),(196,'20240917-1-000093','260.00','admin','2024 09 17','  Cash','  Dine-in','260.00','0.00','0.00','0.0','196','202409171540',NULL,NULL,NULL,NULL,NULL,NULL),(197,'20240917-1-000033','90.00','admin','2024 09 17','  Cash','  Dine-in','90.00','0.00','0.00','0.0','197','202409171612',NULL,NULL,NULL,NULL,NULL,NULL),(198,'20240917-1-000083','390.00','admin','2024 09 17','  Cash','  Dine-in','390.00','0.00','0.00','0.0','198','202409171626',NULL,NULL,NULL,NULL,NULL,NULL),(199,'20240917-1-000073','150.00','admin','2024 09 17','  Cash','  Dine-in','150.00','0.00','0.00','0.0','199','202409171634',NULL,NULL,NULL,NULL,NULL,NULL),(200,'20240917-1-000094','150.00','admin','2024 09 17','  Card','  Dine-in','150.00','0.00','0.00','0.0','200','202409171635',NULL,NULL,NULL,NULL,NULL,NULL),(201,'20240917-1-000016','180.00','admin','2024 09 17','  Cash','  Dine-in','180.00','0.00','0.00','0.0','201','202409171639',NULL,NULL,NULL,NULL,NULL,NULL),(202,'20240917-1-000017','140.00','admin','2024 09 17','  Cash','  Dine-in','140.00','0.00','0.00','0.0','202','202409171741',NULL,NULL,NULL,NULL,NULL,NULL),(203,'20240917-1-000018','150.00','admin','2024 09 17','  Cash','  Dine-in','150.00','0.00','0.00','0.0','203','202409171742',NULL,NULL,NULL,NULL,NULL,NULL),(204,'20240917-1-000019','330.00','admin','2024 09 17','  Card','  Dine-in','330.00','0.00','0.00','0.0','204','202409171744',NULL,NULL,NULL,NULL,NULL,NULL),(205,'20240917-1-000095','150.00','admin','2024 09 17','  Cash','  Dine-in','150.00','0.00','0.00','0.0','205','202409171901',NULL,NULL,NULL,NULL,NULL,NULL),(206,'20240917-1-000104','120.00','admin','2024 09 17','  Card','  Dine-in','120.00','0.00','0.00','0.0','206','202409171901',NULL,NULL,NULL,NULL,NULL,NULL),(207,'20240917-1-0000110','130.00','admin','2024 09 17','  Cash','  Dine-in','130.00','0.00','0.00','0.0','207','202409171903',NULL,NULL,NULL,NULL,NULL,NULL),(208,'20240917-1-000096','220.00','admin','2024 09 17','  Cash','  Takeaway','220.00','0.00','0.00','0.0','208','202409171926',NULL,NULL,NULL,NULL,NULL,NULL),(209,'20240917-1-000097','150.00','admin','2024 09 17','  Card','  Dine-in','150.00','0.00','0.00','0.0','209','202409171927',NULL,NULL,NULL,NULL,NULL,NULL),(210,'20240917-1-000105','250.00','admin','2024 09 17','  Cash','  Dine-in','250.00','0.00','0.00','0.0','210','202409171933',NULL,NULL,NULL,NULL,NULL,NULL),(211,'20240917-1-000084','110.00','admin','2024 09 17','  Cash','  Takeaway','110.00','0.00','0.00','0.0','211','202409171943',NULL,NULL,NULL,NULL,NULL,NULL),(212,'20240917-1-000106','360.00','admin','2024 09 17','  Cash','  Dine-in','360.00','0.00','0.00','0.0','212','202409172006',NULL,NULL,NULL,NULL,NULL,NULL),(213,'20240917-1-0000111','340.00','admin','2024 09 17','  Card','  Dine-in','340.00','0.00','0.00','0.0','213','202409172011',NULL,NULL,NULL,NULL,NULL,NULL),(214,'20240917-1-000107','250.00','admin','2024 09 17','  Card','  Dine-in','250.00','0.00','0.00','0.0','214','202409172110',NULL,NULL,NULL,NULL,NULL,NULL),(215,'20240917-1-000022','250.00','admin','2024 09 17','  Card','  Takeaway','250.00','0.00','0.00','0.0','215','202409172111',NULL,NULL,NULL,NULL,NULL,NULL),(216,'20240917-1-0000112','150.00','admin','2024 09 17','  Cash','  Dine-in','150.00','0.00','0.00','0.0','216','202409172115',NULL,NULL,NULL,NULL,NULL,NULL),(217,'20240918-1-000091','690.00','admin','2024 09 18','  Card','  Takeaway','690.00','0.00','0.00','0.0','217','202409181235',NULL,NULL,NULL,NULL,NULL,NULL),(218,'20240918-1-000011','150.00','admin','2024 09 18','  Cash','  Dine-in','150.00','0.00','0.00','0.0','218','202409181256',NULL,NULL,NULL,NULL,NULL,NULL),(219,'20240918-1-000101','240.00','admin','2024 09 18','  Cash','  Dine-in','240.00','0.00','0.00','0.0','219','202409181315',NULL,NULL,NULL,NULL,NULL,NULL),(220,'20240918-1-000021','150.00','admin','2024 09 18','  Card','  Dine-in','150.00','0.00','0.00','0.0','220','202409181322',NULL,NULL,NULL,NULL,NULL,NULL),(221,'20240918-1-000081','390.00','admin','2024 09 18','  Cash','  Dine-in','390.00','0.00','0.00','0.0','221','202409181325',NULL,NULL,NULL,NULL,NULL,NULL),(222,'20240918-1-000031','110.00','admin','2024 09 18','  Cash','  Dine-in','110.00','0.00','0.00','0.0','222','202409181342',NULL,NULL,NULL,NULL,NULL,NULL),(223,'20240918-1-000092','150.00','admin','2024 09 18','  Cash','  Dine-in','150.00','0.00','0.00','0.0','223','202409181348',NULL,NULL,NULL,NULL,NULL,NULL),(224,'20240918-1-000012','120.00','admin','2024 09 18','  Cash','  Dine-in','120.00','0.00','0.00','0.0','224','202409181350',NULL,NULL,NULL,NULL,NULL,NULL),(225,'20240918-1-000082','320.00','admin','2024 09 18','  Card','  Dine-in','320.00','0.00','0.00','0.0','225','202409181358',NULL,NULL,NULL,NULL,NULL,NULL),(226,'20240918-1-000071','150.00','admin','2024 09 18','  Cash','  Dine-in','150.00','0.00','0.00','0.0','226','202409181358',NULL,NULL,NULL,NULL,NULL,NULL),(227,'20240918-1-000022','90.00','admin','2024 09 18','  Cash','  Dine-in','90.00','0.00','0.00','0.0','227','202409181359',NULL,NULL,NULL,NULL,NULL,NULL),(228,'20240918-1-000051','160.00','admin','2024 09 18','  Card','  Dine-in','160.00','0.00','0.00','0.0','228','202409181411',NULL,NULL,NULL,NULL,NULL,NULL),(229,'20240918-1-000032','190.00','admin','2024 09 18','  Cash','  Dine-in','190.00','0.00','0.00','0.0','229','202409181422',NULL,NULL,NULL,NULL,NULL,NULL),(230,'20240918-1-000093','80.00','admin','2024 09 18','  Cash','  Dine-in','80.00','0.00','0.00','0.0','230','202409181433',NULL,NULL,NULL,NULL,NULL,NULL),(231,'20240918-1-000023','370.00','admin','2024 09 18','  Cash','  Dine-in','370.00','0.00','0.00','0.0','231','202409181440',NULL,NULL,NULL,NULL,NULL,NULL),(232,'20240918-1-000094','120.00','admin','2024 09 18','  Cash','  Dine-in','120.00','0.00','0.00','0.0','232','202409181451',NULL,NULL,NULL,NULL,NULL,NULL),(233,'20240918-1-000072','100.00','admin','2024 09 18','  Cash','  Dine-in','100.00','0.00','0.00','0.0','233','202409181451',NULL,NULL,NULL,NULL,NULL,NULL),(234,'20240918-1-000095','300.00','admin','2024 09 18','  Cash','  Dine-in','300.00','0.00','0.00','0.0','234','202409181456',NULL,NULL,NULL,NULL,NULL,NULL),(235,'20240918-1-000096','60.00','admin','2024 09 18','  Cash','  Dine-in','60.00','0.00','0.00','0.0','235','202409181501',NULL,NULL,NULL,NULL,NULL,NULL),(236,'20240918-1-000097','160.00','admin','2024 09 18','  Cash','  Dine-in','160.00','0.00','0.00','0.0','236','202409181503',NULL,NULL,NULL,NULL,NULL,NULL),(237,'20240918-1-000098','150.00','admin','2024 09 18','  Cash','  Dine-in','150.00','0.00','0.00','0.0','237','202409181530',NULL,NULL,NULL,NULL,NULL,NULL),(238,'20240918-1-000033','370.00','admin','2024 09 18','  Cash','  Dine-in','370.00','0.00','0.00','0.0','238','202409181537',NULL,NULL,NULL,NULL,NULL,NULL),(239,'20240918-1-000013','1330.00','admin','2024 09 18','  Cash','  Dine-in','1330.00','0.00','0.00','0.0','239','202409181544',NULL,NULL,NULL,NULL,NULL,NULL),(240,'20240918-1-000024','150.00','admin','2024 09 18','  Cash','  Dine-in','150.00','0.00','0.00','0.0','240','202409181604',NULL,NULL,NULL,NULL,NULL,NULL),(241,'20240918-1-000014','210.00','admin','2024 09 18','  Cash','  Dine-in','210.00','0.00','0.00','0.0','241','202409181617',NULL,NULL,NULL,NULL,NULL,NULL),(242,'20240918-1-000099','259.00','admin','2024 09 18','  Cash','  Dine-in','259.00','0.00','0.00','0.0','242','202409181627',NULL,NULL,NULL,NULL,NULL,NULL),(243,'20240918-1-000102','150.00','admin','2024 09 18','  Card','  Dine-in','150.00','0.00','0.00','0.0','243','202409181650',NULL,NULL,NULL,NULL,NULL,NULL),(244,'20240918-1-000103','150.00','admin','2024 09 18','  Cash','  Takeaway','150.00','0.00','0.00','0.0','244','202409181653',NULL,NULL,NULL,NULL,NULL,NULL),(245,'20240918-1-000083','320.00','admin','2024 09 18','  Cash','  Dine-in','320.00','0.00','0.00','0.0','245','202409181659',NULL,NULL,NULL,NULL,NULL,NULL),(246,'20240918-1-000025','150.00','admin','2024 09 18','  Cash','  Dine-in','150.00','0.00','0.00','0.0','246','202409181714',NULL,NULL,NULL,NULL,NULL,NULL),(247,'20240918-1-000015','219.00','admin','2024 09 18','  Cash','  Dine-in','219.00','0.00','0.00','0.0','247','202409181739',NULL,NULL,NULL,NULL,NULL,NULL),(248,'20240918-1-000016','200.00','admin','2024 09 18','  Cash','  Dine-in','200.00','0.00','0.00','0.0','248','202409181828',NULL,NULL,NULL,NULL,NULL,NULL),(249,'20240918-1-000017','90.00','admin','2024 09 18','  Cash','  Dine-in','90.00','0.00','0.00','0.0','249','202409181842',NULL,NULL,NULL,NULL,NULL,NULL),(250,'20240918-1-000018','180.00','admin','2024 09 18','  Cash','  Dine-in','180.00','0.00','0.00','0.0','250','202409181927',NULL,NULL,NULL,NULL,NULL,NULL),(251,'20240918-1-000019','150.00','admin','2024 09 18','  Cash','  Dine-in','150.00','0.00','0.00','0.0','251','202409181927',NULL,NULL,NULL,NULL,NULL,NULL),(252,'20240918-1-0000110','420.00','admin','2024 09 18','  Cash','  Dine-in','420.00','0.00','0.00','0.0','252','202409181928',NULL,NULL,NULL,NULL,NULL,NULL),(253,'20240918-1-000041','180.00','admin','2024 09 18','  Card','  Dine-in','180.00','0.00','0.00','0.0','253','202409181936',NULL,NULL,NULL,NULL,NULL,NULL),(254,'20240918-1-0000111','90.00','admin','2024 09 18','  Card','  Dine-in','90.00','0.00','0.00','0.0','254','202409181949',NULL,NULL,NULL,NULL,NULL,NULL),(255,'20240918-1-0000112','250.00','admin','2024 09 18','  Card','  Dine-in','250.00','0.00','0.00','0.0','255','202409181951',NULL,NULL,NULL,NULL,NULL,NULL),(256,'20240918-1-0000113','390.00','admin','2024 09 18','  Cash','  Dine-in','390.00','0.00','0.00','0.0','256','202409182016',NULL,NULL,NULL,NULL,NULL,NULL),(257,'20240918-1-0000114','170.00','admin','2024 09 18','  Cash','  Dine-in','170.00','0.00','0.00','0.0','257','202409182031',NULL,NULL,NULL,NULL,NULL,NULL),(258,'20240918-1-0000115','110.00','admin','2024 09 18','  Cash','  Dine-in','110.00','0.00','0.00','0.0','258','202409182113',NULL,NULL,NULL,NULL,NULL,NULL),(259,'20240918-1-000026','120.00','admin','2024 09 18','  Cash','  Dine-in','120.00','0.00','0.00','0.0','259','202409182114',NULL,NULL,NULL,NULL,NULL,NULL),(260,'20240918-1-000104','170.00','admin','2024 09 18','  Cash','  Dine-in','170.00','0.00','0.00','0.0','260','202409182129',NULL,NULL,NULL,NULL,NULL,NULL),(261,'20240918-1-000105','40.00','admin','2024 09 18','  Cash','  Takeaway','40.00','0.00','0.00','0.0','261','202409182140',NULL,NULL,NULL,NULL,NULL,NULL),(262,'20240918-1-0000910','100.00','admin','2024 09 18','  Card','  Takeaway','100.00','0.00','0.00','0.0','262','202409182141',NULL,NULL,NULL,NULL,NULL,NULL),(263,'20240918-1-0000116','150.00','admin','2024 09 18','  Cash','  Dine-in','150.00','0.00','0.00','0.0','263','202409182153',NULL,NULL,NULL,NULL,NULL,NULL),(264,'20240918-1-0000117','150.00','admin','2024 09 18','  Cash','  Dine-in','150.00','0.00','0.00','0.0','264','202409182253',NULL,NULL,NULL,NULL,NULL,NULL),(265,'20240919-1-000011','150.00','admin','2024 09 19','  Cash','  Dine-in','150.00','0.00','0.00','0.0','265','202409191252',NULL,NULL,NULL,NULL,NULL,NULL),(266,'20240919-1-000081','220.00','admin','2024 09 19','  Cash','  Dine-in','220.00','0.00','0.00','0.0','266','202409191318',NULL,NULL,NULL,NULL,NULL,NULL),(267,'20240919-1-000101','150.00','admin','2024 09 19','  Card','  Dine-in','150.00','0.00','0.00','0.0','267','202409191336',NULL,NULL,NULL,NULL,NULL,NULL),(268,'20240919-1-000031','300.00','admin','2024 09 19','  Cash','  Dine-in','300.00','0.00','0.00','0.0','268','202409191339',NULL,NULL,NULL,NULL,NULL,NULL),(269,'20240919-1-000091','600.00','admin','2024 09 19','  Cash','  Dine-in','600.00','0.00','0.00','0.0','269','202409191339',NULL,NULL,NULL,NULL,NULL,NULL),(270,'20240919-1-000032','90.00','admin','2024 09 19','  Cash','  Dine-in','90.00','0.00','0.00','0.0','270','202409191349',NULL,NULL,NULL,NULL,NULL,NULL),(271,'20240919-1-000033','260.00','admin','2024 09 19','  Card','  Dine-in','260.00','0.00','0.00','0.0','271','202409191400',NULL,NULL,NULL,NULL,NULL,NULL),(272,'20240919-1-000082','179.00','admin','2024 09 19','  Cash','  Dine-in','179.00','0.00','0.00','0.0','272','202409191407',NULL,NULL,NULL,NULL,NULL,NULL),(273,'20240919-1-000071','300.00','admin','2024 09 19','  Cash','  Dine-in','300.00','0.00','0.00','0.0','273','202409191423',NULL,NULL,NULL,NULL,NULL,NULL),(274,'20240919-1-000092','90.00','admin','2024 09 19','  Cash','  Dine-in','90.00','0.00','0.00','0.0','274','202409191435',NULL,NULL,NULL,NULL,NULL,NULL),(275,'20240919-1-000012','180.00','admin','2024 09 19','  Cash','  Dine-in','180.00','0.00','0.00','0.0','275','202409191438',NULL,NULL,NULL,NULL,NULL,NULL),(276,'20240919-1-000021','220.00','admin','2024 09 19','  Cash','  Dine-in','220.00','0.00','0.00','0.0','276','202409191439',NULL,NULL,NULL,NULL,NULL,NULL),(277,'20240919-1-000034','400.00','admin','2024 09 19','  Cash','  Dine-in','400.00','0.00','0.00','0.0','277','202409191451',NULL,NULL,NULL,NULL,NULL,NULL),(278,'20240919-1-000051','715.00','admin','2024 09 19','  Cash','  Dine-in','715.00','0.00','0.00','0.0','278','202409191455',NULL,NULL,NULL,NULL,NULL,NULL),(279,'20240919-1-000083','260.00','admin','2024 09 19','  Card','  Dine-in','260.00','0.00','0.00','0.0','279','202409191508',NULL,NULL,NULL,NULL,NULL,NULL),(280,'20240919-1-000093','280.00','admin','2024 09 19','  Cash','  Dine-in','280.00','0.00','0.00','0.0','280','202409191534',NULL,NULL,NULL,NULL,NULL,NULL),(281,'20240919-1-000035','600.00','admin','2024 09 19','  Cash','  Dine-in','600.00','0.00','0.00','0.0','281','202409191534',NULL,NULL,NULL,NULL,NULL,NULL),(282,'20240919-1-000036','250.00','admin','2024 09 19','  Cash','  Dine-in','250.00','0.00','0.00','0.0','282','202409191535',NULL,NULL,NULL,NULL,NULL,NULL),(283,'20240919-1-000094','150.00','admin','2024 09 19','  Cash','  Dine-in','150.00','0.00','0.00','0.0','283','202409191546',NULL,NULL,NULL,NULL,NULL,NULL),(284,'20240919-1-000037','80.00','admin','2024 09 19','  Cash','  Dine-in','80.00','0.00','0.00','0.0','284','202409191601',NULL,NULL,NULL,NULL,NULL,NULL),(285,'20240919-1-000102','170.00','admin','2024 09 19','  Cash','  Dine-in','170.00','0.00','0.00','0.0','285','202409191905',NULL,NULL,NULL,NULL,NULL,NULL),(286,'20240919-1-000013','300.00','admin','2024 09 19','  Cash','  Dine-in','300.00','0.00','0.00','0.0','286','202409192002',NULL,NULL,NULL,NULL,NULL,NULL),(287,'20240919-1-000014','180.00','admin','2024 09 19','  Cash','  Dine-in','180.00','0.00','0.00','0.0','287','202409192003',NULL,NULL,NULL,NULL,NULL,NULL),(288,'20240919-1-000015','90.00','admin','2024 09 19','  Cash','  Dine-in','90.00','0.00','0.00','0.0','288','202409192003',NULL,NULL,NULL,NULL,NULL,NULL),(289,'20240919-1-000016','170.00','admin','2024 09 19','  Cash','  Dine-in','170.00','0.00','0.00','0.0','289','202409192004',NULL,NULL,NULL,NULL,NULL,NULL),(290,'20240919-1-000017','90.00','admin','2024 09 19','  Cash','  Dine-in','90.00','0.00','0.00','0.0','290','202409192005',NULL,NULL,NULL,NULL,NULL,NULL),(291,'20240919-1-000018','510.00','admin','2024 09 19','  Card','  Dine-in','510.00','0.00','0.00','0.0','291','202409192005',NULL,NULL,NULL,NULL,NULL,NULL),(292,'20240919-1-000019','150.00','admin','2024 09 19','  Cash','  Dine-in','150.00','0.00','0.00','0.0','292','202409192006',NULL,NULL,NULL,NULL,NULL,NULL),(293,'20240919-1-0000110','100.00','admin','2024 09 19','  Cash','  Dine-in','100.00','0.00','0.00','0.0','293','202409192006',NULL,NULL,NULL,NULL,NULL,NULL),(294,'20240919-1-0000111','130.00','admin','2024 09 19','  Cash','  Dine-in','130.00','0.00','0.00','0.0','294','202409192007',NULL,NULL,NULL,NULL,NULL,NULL),(295,'20240919-1-0000112','160.00','admin','2024 09 19','  Card','  Dine-in','160.00','0.00','0.00','0.0','295','202409192007',NULL,NULL,NULL,NULL,NULL,NULL),(296,'20240919-1-000103','150.00','admin','2024 09 19','  Cash','  Dine-in','150.00','0.00','0.00','0.0','296','202409192030',NULL,NULL,NULL,NULL,NULL,NULL),(297,'20240919-1-000095','180.00','admin','2024 09 19','  Card','  Dine-in','180.00','0.00','0.00','0.0','297','202409192036',NULL,NULL,NULL,NULL,NULL,NULL),(298,'20240919-1-000038','430.00','admin','2024 09 19','  Cash','  Dine-in','430.00','0.00','0.00','0.0','298','202409192047',NULL,NULL,NULL,NULL,NULL,NULL),(299,'20240919-1-000096','150.00','admin','2024 09 19','  Card','  Dine-in','150.00','0.00','0.00','0.0','299','202409192052',NULL,NULL,NULL,NULL,NULL,NULL),(300,'20240919-1-000072','220.00','admin','2024 09 19','  Card','  Dine-in','220.00','0.00','0.00','0.0','300','202409192110',NULL,NULL,NULL,NULL,NULL,NULL),(301,'20240919-1-000084','560.00','admin','2024 09 19','  Cash','  Dine-in','560.00','0.00','0.00','0.0','301','202409192111',NULL,NULL,NULL,NULL,NULL,NULL),(302,'20240919-1-000061','210.00','admin','2024 09 19','  Card','  Dine-in','210.00','0.00','0.00','0.0','302','202409192120',NULL,NULL,NULL,NULL,NULL,NULL),(303,'20240919-1-000062','220.00','admin','2024 09 19','  Card','  Dine-in','220.00','0.00','0.00','0.0','303','202409192129',NULL,NULL,NULL,NULL,NULL,NULL),(304,'20240919-1-0000113','180.00','admin','2024 09 19','  Cash','  Dine-in','180.00','0.00','0.00','0.0','304','202409192158',NULL,NULL,NULL,NULL,NULL,NULL),(305,'20240919-1-0000114','250.00','admin','2024 09 19','  Card','  Dine-in','250.00','0.00','0.00','0.0','305','202409192208',NULL,NULL,NULL,NULL,NULL,NULL),(306,'20240920-1-000071','240.00','admin','2024 09 20','  Cash','  Dine-in','240.00','0.00','0.00','0.0','306','202409201235',NULL,NULL,NULL,NULL,NULL,NULL),(307,'20240920-1-000081','700.00','admin','2024 09 20','  Cash','  Dine-in','700.00','0.00','0.00','0.0','307','202409201246',NULL,NULL,NULL,NULL,NULL,NULL),(308,'20240920-1-000091','150.00','admin','2024 09 20','  Cash','  Dine-in','150.00','0.00','0.00','0.0','308','202409201249',NULL,NULL,NULL,NULL,NULL,NULL),(309,'20240920-1-000011','150.00','admin','2024 09 20','  Cash','  Dine-in','150.00','0.00','0.00','0.0','309','202409201314',NULL,NULL,NULL,NULL,NULL,NULL),(310,'20240920-1-000072','180.00','admin','2024 09 20','  Card','  Dine-in','180.00','0.00','0.00','0.0','310','202409201331',NULL,NULL,NULL,NULL,NULL,NULL),(311,'20240920-1-000092','180.00','admin','2024 09 20','  Cash','  Dine-in','180.00','0.00','0.00','0.0','311','202409201355',NULL,NULL,NULL,NULL,NULL,NULL),(312,'20240920-1-000031','1000.00','admin','2024 09 20','  Cash','  Dine-in','1000.00','0.00','0.00','0.0','312','202409201357',NULL,NULL,NULL,NULL,NULL,NULL),(313,'20240920-1-000012','300.00','admin','2024 09 20','  Cash','  Dine-in','300.00','0.00','0.00','0.0','313','202409201359',NULL,NULL,NULL,NULL,NULL,NULL),(314,'20240920-1-000101','230.00','admin','2024 09 20','  Cash','  Dine-in','230.00','0.00','0.00','0.0','314','202409201401',NULL,NULL,NULL,NULL,NULL,NULL),(315,'20240920-1-000093','180.00','admin','2024 09 20','  Cash','  Dine-in','180.00','0.00','0.00','0.0','315','202409201402',NULL,NULL,NULL,NULL,NULL,NULL),(316,'20240920-1-000021','320.00','admin','2024 09 20','  Cash','  Dine-in','320.00','0.00','0.00','0.0','316','202409201408',NULL,NULL,NULL,NULL,NULL,NULL),(317,'20240920-1-000102','455.00','admin','2024 09 20','  Card','  Dine-in','455.00','0.00','0.00','0.0','317','202409201419',NULL,NULL,NULL,NULL,NULL,NULL),(318,'20240920-1-000082','130.00','admin','2024 09 20','  Card','  Dine-in','130.00','0.00','0.00','0.0','318','202409201421',NULL,NULL,NULL,NULL,NULL,NULL),(319,'20240920-1-000061','150.00','admin','2024 09 20','  Cash','  Dine-in','150.00','0.00','0.00','0.0','319','202409201430',NULL,NULL,NULL,NULL,NULL,NULL),(320,'20240920-1-000051','320.00','admin','2024 09 20','  Card','  Dine-in','320.00','0.00','0.00','0.0','320','202409201430',NULL,NULL,NULL,NULL,NULL,NULL),(321,'20240920-1-000073','130.00','admin','2024 09 20','  Card','  Dine-in','130.00','0.00','0.00','0.0','321','202409201434',NULL,NULL,NULL,NULL,NULL,NULL),(322,'20240920-1-000041','220.00','admin','2024 09 20','  Cash','  Dine-in','220.00','0.00','0.00','0.0','322','202409201439',NULL,NULL,NULL,NULL,NULL,NULL),(323,'20240920-1-000032','640.00','admin','2024 09 20','  Cash','  Dine-in','640.00','0.00','0.00','0.0','323','202409201441',NULL,NULL,NULL,NULL,NULL,NULL),(324,'20240920-1-000083','270.00','admin','2024 09 20','  Cash','  Dine-in','270.00','0.00','0.00','0.0','324','202409201453',NULL,NULL,NULL,NULL,NULL,NULL),(325,'20240920-1-000094','190.00','admin','2024 09 20','  Cash','  Dine-in','190.00','0.00','0.00','0.0','325','202409201500',NULL,NULL,NULL,NULL,NULL,NULL),(326,'20240920-1-000013','450.00','admin','2024 09 20','  Cash','  Dine-in','450.00','0.00','0.00','0.0','326','202409201501',NULL,NULL,NULL,NULL,NULL,NULL),(327,'20240920-1-000033','180.00','admin','2024 09 20','  Cash','  Dine-in','180.00','0.00','0.00','0.0','327','202409201504',NULL,NULL,NULL,NULL,NULL,NULL),(328,'20240920-1-000062','370.00','admin','2024 09 20','  Cash','  Dine-in','370.00','0.00','0.00','0.0','328','202409201510',NULL,NULL,NULL,NULL,NULL,NULL),(329,'20240920-1-000074','130.00','admin','2024 09 20','  Cash','  Dine-in','130.00','0.00','0.00','0.0','329','202409201511',NULL,NULL,NULL,NULL,NULL,NULL),(330,'20240920-1-000052','110.00','admin','2024 09 20','  Cash','  Dine-in','110.00','0.00','0.00','0.0','330','202409201542',NULL,NULL,NULL,NULL,NULL,NULL),(331,'20240920-1-000063','90.00','admin','2024 09 20','  Cash','  Dine-in','90.00','0.00','0.00','0.0','331','202409201542',NULL,NULL,NULL,NULL,NULL,NULL),(332,'20240920-1-000014','160.00','admin','2024 09 20','  Card','  Dine-in','160.00','0.00','0.00','0.0','332','202409201544',NULL,NULL,NULL,NULL,NULL,NULL),(333,'20240920-1-000015','560.00','admin','2024 09 20','  Cash','  Dine-in','560.00','0.00','0.00','0.0','333','202409201545',NULL,NULL,NULL,NULL,NULL,NULL),(334,'20240920-1-000016','130.00','admin','2024 09 20','  Cash','  Dine-in','130.00','0.00','0.00','0.0','334','202409201547',NULL,NULL,NULL,NULL,NULL,NULL),(335,'20240920-1-000034','600.00','admin','2024 09 20','  Cash','  Dine-in','600.00','0.00','0.00','0.0','335','202409201625',NULL,NULL,NULL,NULL,NULL,NULL),(336,'20240920-1-000075','220.00','admin','2024 09 20','  Cash','  Dine-in','220.00','0.00','0.00','0.0','336','202409201626',NULL,NULL,NULL,NULL,NULL,NULL),(337,'20240920-1-000017','300.00','admin','2024 09 20','  Card','  Dine-in','300.00','0.00','0.00','0.0','337','202409201630',NULL,NULL,NULL,NULL,NULL,NULL),(338,'20240920-1-000022','578.00','admin','2024 09 20','  Card','  Dine-in','578.00','0.00','0.00','0.0','338','202409201721',NULL,NULL,NULL,NULL,NULL,NULL),(339,'20240920-1-000103','120.00','admin','2024 09 20','  Cash','  Dine-in','120.00','0.00','0.00','0.0','339','202409201921',NULL,NULL,NULL,NULL,NULL,NULL),(340,'20240920-1-000018','70.00','admin','2024 09 20','  Cash','  Dine-in','70.00','0.00','0.00','0.0','340','202409201934',NULL,NULL,NULL,NULL,NULL,NULL),(341,'20240920-1-000019','120.00','admin','2024 09 20','  Cash','  Dine-in','120.00','0.00','0.00','0.0','341','202409201935',NULL,NULL,NULL,NULL,NULL,NULL),(342,'20240920-1-000035','300.00','admin','2024 09 20','  Cash','  Dine-in','300.00','0.00','0.00','0.0','342','202409201949',NULL,NULL,NULL,NULL,NULL,NULL),(343,'20240920-1-000023','350.00','admin','2024 09 20','  Cash','  Dine-in','350.00','0.00','0.00','0.0','343','202409201954',NULL,NULL,NULL,NULL,NULL,NULL),(344,'20240920-1-000095','660.00','admin','2024 09 20','  Cash','  Dine-in','660.00','0.00','0.00','0.0','344','202409202004',NULL,NULL,NULL,NULL,NULL,NULL),(345,'20240920-1-000076','180.00','admin','2024 09 20','  Cash','  Dine-in','180.00','0.00','0.00','0.0','345','202409202058',NULL,NULL,NULL,NULL,NULL,NULL),(346,'20240920-1-000096','230.00','admin','2024 09 20','  Cash','  Dine-in','230.00','0.00','0.00','0.0','346','202409202058',NULL,NULL,NULL,NULL,NULL,NULL),(347,'20240920-1-0000110','350.00','admin','2024 09 20','  Cash','  Dine-in','350.00','0.00','0.00','0.0','347','202409202113',NULL,NULL,NULL,NULL,NULL,NULL),(348,'20240920-1-000084','160.00','admin','2024 09 20','  Card','  Dine-in','160.00','0.00','0.00','0.0','348','202409202116',NULL,NULL,NULL,NULL,NULL,NULL),(349,'20240920-1-000036','820.00','admin','2024 09 20','  Cash','  Dine-in','820.00','0.00','0.00','0.0','349','202409202128',NULL,NULL,NULL,NULL,NULL,NULL),(350,'20240920-1-000077','90.00','admin','2024 09 20','  Cash','  Dine-in','90.00','0.00','0.00','0.0','350','202409202138',NULL,NULL,NULL,NULL,NULL,NULL),(351,'20240920-1-000024','290.00','admin','2024 09 20','  Cash','  Dine-in','290.00','0.00','0.00','0.0','351','202409202139',NULL,NULL,NULL,NULL,NULL,NULL),(352,'20240920-1-000064','90.00','admin','2024 09 20','  Cash','  Dine-in','90.00','0.00','0.00','0.0','352','202409202149',NULL,NULL,NULL,NULL,NULL,NULL),(353,'20240920-1-000042','1155.00','admin','2024 09 20','  Card','  Dine-in','1155.00','0.00','0.00','0.0','353','202409202235',NULL,NULL,NULL,NULL,NULL,NULL),(354,'20240920-1-0000111','150.00','admin','2024 09 20','  Cash','  Dine-in','150.00','0.00','0.00','0.0','354','202409202236',NULL,NULL,NULL,NULL,NULL,NULL),(355,'20240920-1-000104','240.00','admin','2024 09 20','  Cash','  Dine-in','240.00','0.00','0.00','0.0','355','202409202241',NULL,NULL,NULL,NULL,NULL,NULL),(356,'20240920-1-000105','60.00','admin','2024 09 20','  Cash','  Dine-in','60.00','0.00','0.00','0.0','356','202409202241',NULL,NULL,NULL,NULL,NULL,NULL),(357,'20240920-1-0000112','150.00','admin','2024 09 20','  Cash','  Dine-in','150.00','0.00','0.00','0.0','357','202409202243',NULL,NULL,NULL,NULL,NULL,NULL),(358,'20240921-1-000011','150.00','admin','2024 09 21','  Cash','  Dine-in','150.00','0.00','0.00','0.0','358','202409211228',NULL,NULL,NULL,NULL,NULL,NULL),(359,'20240921-1-000012','20.00','admin','2024 09 21','  Card','  Dine-in','20.00','0.00','0.00','0.0','359','202409211237',NULL,NULL,NULL,NULL,NULL,NULL),(360,'20240921-1-000031','360.00','admin','2024 09 21','  Cash','  Dine-in','360.00','0.00','0.00','0.0','360','202409211312',NULL,NULL,NULL,NULL,NULL,NULL),(361,'20240921-1-000101','220.00','admin','2024 09 21','  Cash','  Dine-in','220.00','0.00','0.00','0.0','361','202409211318',NULL,NULL,NULL,NULL,NULL,NULL),(362,'20240921-1-000071','320.00','admin','2024 09 21','  Card','  Dine-in','320.00','0.00','0.00','0.0','362','202409211331',NULL,NULL,NULL,NULL,NULL,NULL),(363,'20240921-1-000013','300.00','admin','2024 09 21','  Cash','  Dine-in','300.00','0.00','0.00','0.0','363','202409211338',NULL,NULL,NULL,NULL,NULL,NULL),(364,'20240921-1-000081','389.00','admin','2024 09 21','  Card','  Dine-in','389.00','0.00','0.00','0.0','364','202409211404',NULL,NULL,NULL,NULL,NULL,NULL),(365,'20240921-1-000032','409.00','admin','2024 09 21','  Card','  Dine-in','409.00','0.00','0.00','0.0','365','202409211406',NULL,NULL,NULL,NULL,NULL,NULL),(366,'20240921-1-000091','560.00','admin','2024 09 21','  Cash','  Dine-in','560.00','0.00','0.00','0.0','366','202409211415',NULL,NULL,NULL,NULL,NULL,NULL),(367,'20240921-1-000051','230.00','admin','2024 09 21','  Cash','  Dine-in','230.00','0.00','0.00','0.0','367','202409211430',NULL,NULL,NULL,NULL,NULL,NULL),(368,'20240921-1-000072','410.00','admin','2024 09 21','  Cash','  Dine-in','410.00','0.00','0.00','0.0','368','202409211457',NULL,NULL,NULL,NULL,NULL,NULL),(369,'20240921-1-000073','150.00','admin','2024 09 21','  Cash','  Dine-in','150.00','0.00','0.00','0.0','369','202409211501',NULL,NULL,NULL,NULL,NULL,NULL),(370,'20240921-1-000014','150.00','admin','2024 09 21','  Cash','  Dine-in','150.00','0.00','0.00','0.0','370','202409211518',NULL,NULL,NULL,NULL,NULL,NULL),(371,'20240921-1-000102','40.00','admin','2024 09 21','  Cash','  Dine-in','40.00','0.00','0.00','0.0','371','202409211531',NULL,NULL,NULL,NULL,NULL,NULL),(372,'20240921-1-000052','200.00','admin','2024 09 21','  Cash','  Dine-in','200.00','0.00','0.00','0.0','372','202409211546',NULL,NULL,NULL,NULL,NULL,NULL),(373,'20240921-1-000033','415.00','admin','2024 09 21','  Cash','  Dine-in','415.00','0.00','0.00','0.0','373','202409211548',NULL,NULL,NULL,NULL,NULL,NULL),(374,'20240921-1-000015','185.00','admin','2024 09 21','  Cash','  Dine-in','185.00','0.00','0.00','0.0','374','202409211628',NULL,NULL,NULL,NULL,NULL,NULL),(375,'20240921-1-000016','150.00','admin','2024 09 21','  Card','  Takeaway','150.00','0.00','0.00','0.0','375','202409211801',NULL,NULL,NULL,NULL,NULL,NULL),(376,'20240921-1-000017','180.00','admin','2024 09 21','  Cash','  Dine-in','180.00','0.00','0.00','0.0','376','202409211841',NULL,NULL,NULL,NULL,NULL,NULL),(377,'20240921-1-000018','150.00','admin','2024 09 21','  Cash','  Dine-in','150.00','0.00','0.00','0.0','377','202409211842',NULL,NULL,NULL,NULL,NULL,NULL),(378,'20240921-1-000019','100.00','admin','2024 09 21','  Cash','  Dine-in','100.00','0.00','0.00','0.0','378','202409211843',NULL,NULL,NULL,NULL,NULL,NULL),(379,'20240921-1-0000110','240.00','admin','2024 09 21','  Cash','  Dine-in','240.00','0.00','0.00','0.0','379','202409211844',NULL,NULL,NULL,NULL,NULL,NULL),(380,'20240921-1-000021','120.00','admin','2024 09 21','  Card','  Dine-in','120.00','0.00','0.00','0.0','380','202409212026',NULL,NULL,NULL,NULL,NULL,NULL),(381,'20240921-1-0000111','150.00','admin','2024 09 21','  Cash','  Dine-in','150.00','0.00','0.00','0.0','381','202409212026',NULL,NULL,NULL,NULL,NULL,NULL),(382,'20240921-1-000034','548.00','admin','2024 09 21','  Card','  Takeaway','548.00','0.00','0.00','0.0','382','202409212107',NULL,NULL,NULL,NULL,NULL,NULL),(383,'20240921-1-000035','150.00','admin','2024 09 21','  Card','  Dine-in','150.00','0.00','0.00','0.0','383','202409212112',NULL,NULL,NULL,NULL,NULL,NULL),(384,'20240921-1-000036','50.00','admin','2024 09 21','  Card','  Dine-in','50.00','0.00','0.00','0.0','384','202409212121',NULL,NULL,NULL,NULL,NULL,NULL),(385,'20240921-1-000103','162.00','admin','2024 09 21','  Card','  Takeaway','180.00','0.00','0.00','0.0','385','202409212127',NULL,NULL,NULL,NULL,NULL,NULL),(386,'20240921-1-0000112','80.00','admin','2024 09 21','  Cash','  Dine-in','80.00','0.00','0.00','0.0','386','202409212134',NULL,NULL,NULL,NULL,NULL,NULL),(387,'20240922-1-000091','450.00','admin','2024 09 22','  Cash','  Dine-in','450.00','0.00','0.00','0.0','387','202409221205',NULL,NULL,NULL,NULL,NULL,NULL),(388,'20240922-1-000011','300.00','admin','2024 09 22','  Cash','  Dine-in','300.00','0.00','0.00','0.0','388','202409221212',NULL,NULL,NULL,NULL,NULL,NULL),(389,'20240922-1-000101','520.00','admin','2024 09 22','  Cash','  Dine-in','520.00','0.00','0.00','0.0','389','202409221222',NULL,NULL,NULL,NULL,NULL,NULL),(390,'20240922-1-000102','450.00','admin','2024 09 22','  Cash','  Dine-in','450.00','0.00','0.00','0.0','390','202409221256',NULL,NULL,NULL,NULL,NULL,NULL),(391,'20240922-1-000103','60.00','admin','2024 09 22','  Cash','  Dine-in','60.00','0.00','0.00','0.0','391','202409221300',NULL,NULL,NULL,NULL,NULL,NULL),(392,'20240922-1-000092','300.00','admin','2024 09 22','  Cash','  Dine-in','300.00','0.00','0.00','0.0','392','202409221338',NULL,NULL,NULL,NULL,NULL,NULL),(393,'20240922-1-000031','290.00','admin','2024 09 22','  Cash','  Dine-in','290.00','0.00','0.00','0.0','393','202409221353',NULL,NULL,NULL,NULL,NULL,NULL),(394,'20240922-1-000093','80.00','admin','2024 09 22','  Card','  Dine-in','80.00','0.00','0.00','0.0','394','202409221358',NULL,NULL,NULL,NULL,NULL,NULL),(395,'20240922-1-000051','150.00','admin','2024 09 22','  Cash','  Dine-in','150.00','0.00','0.00','0.0','395','202409221359',NULL,NULL,NULL,NULL,NULL,NULL),(396,'20240922-1-000012','250.00','admin','2024 09 22','  Cash','  Dine-in','250.00','0.00','0.00','0.0','396','202409221359',NULL,NULL,NULL,NULL,NULL,NULL),(397,'20240922-1-000021','150.00','admin','2024 09 22','  Cash','  Dine-in','150.00','0.00','0.00','0.0','397','202409221422',NULL,NULL,NULL,NULL,NULL,NULL),(398,'20240922-1-000061','150.00','admin','2024 09 22','  Cash','  Dine-in','150.00','0.00','0.00','0.0','398','202409221424',NULL,NULL,NULL,NULL,NULL,NULL),(399,'20240922-1-000032','485.00','admin','2024 09 22','  Cash','  Dine-in','485.00','0.00','0.00','0.0','399','202409221426',NULL,NULL,NULL,NULL,NULL,NULL),(400,'20240922-1-000062','120.00','admin','2024 09 22','  Cash','  Dine-in','120.00','0.00','0.00','0.0','400','202409221431',NULL,NULL,NULL,NULL,NULL,NULL),(401,'20240922-1-000013','130.00','admin','2024 09 22','  Cash','  Dine-in','130.00','0.00','0.00','0.0','401','202409221433',NULL,NULL,NULL,NULL,NULL,NULL),(402,'20240922-1-000104','80.00','admin','2024 09 22','  Cash','  Dine-in','80.00','0.00','0.00','0.0','402','202409221435',NULL,NULL,NULL,NULL,NULL,NULL),(403,'20240922-1-000033','80.00','admin','2024 09 22','  Card','  Dine-in','80.00','0.00','0.00','0.0','403','202409221436',NULL,NULL,NULL,NULL,NULL,NULL),(404,'20240922-1-000105','220.00','admin','2024 09 22','  Cash','  Dine-in','220.00','0.00','0.00','0.0','404','202409221442',NULL,NULL,NULL,NULL,NULL,NULL),(405,'20240922-1-000106','150.00','admin','2024 09 22','  Cash','  Dine-in','150.00','0.00','0.00','0.0','405','202409221456',NULL,NULL,NULL,NULL,NULL,NULL),(406,'20240922-1-000022','150.00','admin','2024 09 22','  Cash','  Dine-in','150.00','0.00','0.00','0.0','406','202409221458',NULL,NULL,NULL,NULL,NULL,NULL),(407,'20240922-1-000094','440.00','admin','2024 09 22','  Cash','  Dine-in','440.00','0.00','0.00','0.0','407','202409221458',NULL,NULL,NULL,NULL,NULL,NULL),(408,'20240922-1-000014','450.00','admin','2024 09 22','  Cash','  Dine-in','450.00','0.00','0.00','0.0','408','202409221520',NULL,NULL,NULL,NULL,NULL,NULL),(409,'20240922-1-000095','90.00','admin','2024 09 22','  Cash','  Dine-in','90.00','0.00','0.00','0.0','409','202409221524',NULL,NULL,NULL,NULL,NULL,NULL),(410,'20240922-1-000107','150.00','admin','2024 09 22','  Cash','  Dine-in','150.00','0.00','0.00','0.0','410','202409221530',NULL,NULL,NULL,NULL,NULL,NULL),(411,'20240922-1-000034','330.00','admin','2024 09 22','  Cash','  Dine-in','330.00','0.00','0.00','0.0','411','202409221536',NULL,NULL,NULL,NULL,NULL,NULL),(412,'20240922-1-000108','300.00','admin','2024 09 22','  Card','  Dine-in','300.00','0.00','0.00','0.0','412','202409221606',NULL,NULL,NULL,NULL,NULL,NULL),(413,'20240922-1-000109','70.00','admin','2024 09 22','  Card','  Dine-in','70.00','0.00','0.00','0.0','413','202409221607',NULL,NULL,NULL,NULL,NULL,NULL),(414,'20240922-1-0001010','300.00','admin','2024 09 22','  Cash','  Dine-in','300.00','0.00','0.00','0.0','414','202409221624',NULL,NULL,NULL,NULL,NULL,NULL),(415,'20240922-1-0001011','50.00','admin','2024 09 22','  Cash','  Dine-in','50.00','0.00','0.00','0.0','415','202409221632',NULL,NULL,NULL,NULL,NULL,NULL),(416,'20240922-1-0001012','150.00','admin','2024 09 22','  Cash','  Dine-in','150.00','0.00','0.00','0.0','416','202409221638',NULL,NULL,NULL,NULL,NULL,NULL),(417,'20240922-1-000096','380.00','admin','2024 09 22','  Cash','  Dine-in','380.00','0.00','0.00','0.0','417','202409221711',NULL,NULL,NULL,NULL,NULL,NULL),(418,'20240922-1-000015','170.00','admin','2024 09 22','  Cash','  Dine-in','170.00','0.00','0.00','0.0','418','202409221856',NULL,NULL,NULL,NULL,NULL,NULL),(419,'20240922-1-000016','150.00','admin','2024 09 22','  Cash','  Dine-in','150.00','0.00','0.00','0.0','419','202409221857',NULL,NULL,NULL,NULL,NULL,NULL),(420,'20240922-1-0001013','150.00','admin','2024 09 22','  Cash','  Takeaway','150.00','0.00','0.00','0.0','420','202409221857',NULL,NULL,NULL,NULL,NULL,NULL),(421,'20240922-1-0001014','150.00','admin','2024 09 22','  Cash','  Dine-in','150.00','0.00','0.00','0.0','421','202409221903',NULL,NULL,NULL,NULL,NULL,NULL),(422,'20240922-1-0001015','150.00','admin','2024 09 22','  Cash','  Dine-in','150.00','0.00','0.00','0.0','422','202409221906',NULL,NULL,NULL,NULL,NULL,NULL),(423,'20240922-1-0001016','150.00','admin','2024 09 22','  Card','  Dine-in','150.00','0.00','0.00','0.0','423','202409221907',NULL,NULL,NULL,NULL,NULL,NULL),(424,'20240922-1-0001017','300.00','admin','2024 09 22','  Cash','  Dine-in','300.00','0.00','0.00','0.0','424','202409221908',NULL,NULL,NULL,NULL,NULL,NULL),(425,'20240922-1-0001018','300.00','admin','2024 09 22','  Cash','  Dine-in','300.00','0.00','0.00','0.0','425','202409221912',NULL,NULL,NULL,NULL,NULL,NULL),(426,'20240922-1-000017','390.00','admin','2024 09 22','  Cash','  Dine-in','390.00','0.00','0.00','0.0','426','202409221922',NULL,NULL,NULL,NULL,NULL,NULL),(427,'20240922-1-000023','300.00','admin','2024 09 22','  Card','  Dine-in','300.00','0.00','0.00','0.0','427','202409221930',NULL,NULL,NULL,NULL,NULL,NULL),(428,'20240922-1-000018','70.00','admin','2024 09 22','  Cash','  Dine-in','70.00','0.00','0.00','0.0','428','202409221930',NULL,NULL,NULL,NULL,NULL,NULL),(429,'20240922-1-000019','460.00','admin','2024 09 22','  Cash','  Dine-in','460.00','0.00','0.00','0.0','429','202409221936',NULL,NULL,NULL,NULL,NULL,NULL),(430,'20240922-1-0000110','80.00','admin','2024 09 22','  Cash','  Dine-in','80.00','0.00','0.00','0.0','430','202409222032',NULL,NULL,NULL,NULL,NULL,NULL),(431,'20240922-1-0000111','340.00','admin','2024 09 22','  Cash','  Dine-in','340.00','0.00','0.00','0.0','431','202409222043',NULL,NULL,NULL,NULL,NULL,NULL),(432,'20240922-1-0001019','100.00','admin','2024 09 22','  Card','  Dine-in','100.00','0.00','0.00','0.0','432','202409222051',NULL,NULL,NULL,NULL,NULL,NULL),(433,'20240922-1-0000112','40.00','admin','2024 09 22','  Cash','  Dine-in','40.00','0.00','0.00','0.0','433','202409222057',NULL,NULL,NULL,NULL,NULL,NULL),(434,'20240922-1-0000113','100.00','admin','2024 09 22','  Cash','  Dine-in','100.00','0.00','0.00','0.0','434','202409222218',NULL,NULL,NULL,NULL,NULL,NULL),(435,'20240922-1-000024','320.00','admin','2024 09 22','  Cash','  Dine-in','320.00','0.00','0.00','0.0','435','202409222221',NULL,NULL,NULL,NULL,NULL,NULL),(436,'20240923-1-000031','70.00','admin','2024 09 23','  Cash','  Dine-in','70.00','0.00','0.00','0.0','436','202409231230',NULL,NULL,NULL,NULL,NULL,NULL),(437,'20240923-1-000071','360.00','admin','2024 09 23','  Cash','  Dine-in','360.00','0.00','0.00','0.0','437','202409231234',NULL,NULL,NULL,NULL,NULL,NULL),(438,'20240923-1-000072','150.00','admin','2024 09 23','  Cash','  Dine-in','150.00','0.00','0.00','0.0','438','202409231236',NULL,NULL,NULL,NULL,NULL,NULL),(439,'20240923-1-000081','230.00','admin','2024 09 23','  Cash','  Dine-in','230.00','0.00','0.00','0.0','439','202409231247',NULL,NULL,NULL,NULL,NULL,NULL),(440,'20240923-1-000051','150.00','admin','2024 09 23','  Cash','  Dine-in','150.00','0.00','0.00','0.0','440','202409231250',NULL,NULL,NULL,NULL,NULL,NULL),(441,'20240923-1-000011','150.00','admin','2024 09 23','  Cash','  Dine-in','150.00','0.00','0.00','0.0','441','202409231316',NULL,NULL,NULL,NULL,NULL,NULL),(442,'20240923-1-000073','80.00','admin','2024 09 23','  Cash','  Dine-in','80.00','0.00','0.00','0.0','442','202409231320',NULL,NULL,NULL,NULL,NULL,NULL),(443,'20240923-1-000021','330.00','admin','2024 09 23','  Cash','  Dine-in','330.00','0.00','0.00','0.0','443','202409231330',NULL,NULL,NULL,NULL,NULL,NULL),(444,'20240923-1-000082','90.00','admin','2024 09 23','  Cash','  Dine-in','90.00','0.00','0.00','0.0','444','202409231334',NULL,NULL,NULL,NULL,NULL,NULL),(445,'20240923-1-000012','230.00','admin','2024 09 23','  Cash','  Dine-in','230.00','0.00','0.00','0.0','445','202409231349',NULL,NULL,NULL,NULL,NULL,NULL),(446,'20240923-1-000091','300.00','admin','2024 09 23','  Cash','  Dine-in','300.00','0.00','0.00','0.0','446','202409231352',NULL,NULL,NULL,NULL,NULL,NULL),(447,'20240923-1-000052','175.00','admin','2024 09 23','  Cash','  Dine-in','175.00','0.00','0.00','0.0','447','202409231408',NULL,NULL,NULL,NULL,NULL,NULL),(448,'20240923-1-000083','210.00','admin','2024 09 23','  Card','  Dine-in','210.00','0.00','0.00','0.0','448','202409231414',NULL,NULL,NULL,NULL,NULL,NULL),(449,'20240923-1-000013','150.00','admin','2024 09 23','  Card','  Dine-in','150.00','0.00','0.00','0.0','449','202409231453',NULL,NULL,NULL,NULL,NULL,NULL),(450,'20240923-1-000092','330.00','admin','2024 09 23','  Cash','  Dine-in','330.00','0.00','0.00','0.0','450','202409231455',NULL,NULL,NULL,NULL,NULL,NULL),(451,'20240923-1-000101','80.00','admin','2024 09 23','  Cash','  Dine-in','80.00','0.00','0.00','0.0','451','202409231458',NULL,NULL,NULL,NULL,NULL,NULL),(452,'20240923-1-000102','80.00','admin','2024 09 23','  Cash','  Dine-in','80.00','0.00','0.00','0.0','452','202409231459',NULL,NULL,NULL,NULL,NULL,NULL),(453,'20240923-1-000103','439.00','admin','2024 09 23','  Card','  Dine-in','439.00','0.00','0.00','0.0','453','202409231504',NULL,NULL,NULL,NULL,NULL,NULL),(454,'20240923-1-000104','20.00','admin','2024 09 23','  Cash','  Dine-in','20.00','0.00','0.00','0.0','454','202409231505',NULL,NULL,NULL,NULL,NULL,NULL),(455,'20240923-1-000032','755.00','admin','2024 09 23','  Cash','  Dine-in','755.00','0.00','0.00','0.0','455','202409231510',NULL,NULL,NULL,NULL,NULL,NULL),(456,'20240923-1-000014','190.00','admin','2024 09 23','  Card','  Dine-in','190.00','0.00','0.00','0.0','456','202409231538',NULL,NULL,NULL,NULL,NULL,NULL),(457,'20240923-1-000093','420.00','admin','2024 09 23','  Cash','  Dine-in','420.00','0.00','0.00','0.0','457','202409231601',NULL,NULL,NULL,NULL,NULL,NULL),(458,'20240923-1-000094','150.00','admin','2024 09 23','  Cash','  Dine-in','150.00','0.00','0.00','0.0','458','202409231621',NULL,NULL,NULL,NULL,NULL,NULL),(459,'20240923-1-000095','150.00','admin','2024 09 23','  Cash','  Dine-in','150.00','0.00','0.00','0.0','459','202409231622',NULL,NULL,NULL,NULL,NULL,NULL),(460,'20240923-1-000084','160.00','admin','2024 09 23','  Cash','  Dine-in','160.00','0.00','0.00','0.0','460','202409231640',NULL,NULL,NULL,NULL,NULL,NULL),(461,'20240923-1-000015','180.00','admin','2024 09 23','  Cash','  Dine-in','180.00','0.00','0.00','0.0','461','202409231744',NULL,NULL,NULL,NULL,NULL,NULL),(462,'20240923-1-000016','230.00','admin','2024 09 23','  Cash','  Dine-in','230.00','0.00','0.00','0.0','462','202409231901',NULL,NULL,NULL,NULL,NULL,NULL),(463,'20240923-1-000017','80.00','admin','2024 09 23','  Cash','  Dine-in','80.00','0.00','0.00','0.0','463','202409231903',NULL,NULL,NULL,NULL,NULL,NULL),(464,'20240923-1-000018','150.00','admin','2024 09 23','  Cash','  Dine-in','150.00','0.00','0.00','0.0','464','202409231905',NULL,NULL,NULL,NULL,NULL,NULL),(465,'20240923-1-000019','270.00','admin','2024 09 23','  Cash','  Takeaway','270.00','0.00','0.00','0.0','465','202409232020',NULL,NULL,NULL,NULL,NULL,NULL),(466,'20240923-1-000074','980.00','admin','2024 09 23','  Cash','  Dine-in','980.00','0.00','0.00','0.0','466','202409232024',NULL,NULL,NULL,NULL,NULL,NULL),(467,'20240923-1-000033','150.00','admin','2024 09 23','  Cash','  Dine-in','150.00','0.00','0.00','0.0','467','202409232026',NULL,NULL,NULL,NULL,NULL,NULL),(468,'20240923-1-000105','310.00','admin','2024 09 23','  Card','  Dine-in','310.00','0.00','0.00','0.0','468','202409232036',NULL,NULL,NULL,NULL,NULL,NULL),(469,'20240923-1-000096','50.00','admin','2024 09 23','  Cash','  Dine-in','50.00','0.00','0.00','0.0','469','202409232056',NULL,NULL,NULL,NULL,NULL,NULL),(470,'20240923-1-000106','580.00','admin','2024 09 23','  Cash','  Dine-in','580.00','0.00','0.00','0.0','470','202409232101',NULL,NULL,NULL,NULL,NULL,NULL),(471,'20240923-1-000107','150.00','admin','2024 09 23','  Card','  Dine-in','150.00','0.00','0.00','0.0','471','202409232140',NULL,NULL,NULL,NULL,NULL,NULL),(472,'20240923-1-000108','45.00','admin','2024 09 23','  Cash','  Dine-in','45.00','0.00','0.00','0.0','472','202409232141',NULL,NULL,NULL,NULL,NULL,NULL),(473,'20240923-1-0000110','80.00','admin','2024 09 23','  Card','  Dine-in','80.00','0.00','0.00','0.0','473','202409232237',NULL,NULL,NULL,NULL,NULL,NULL),(474,'20240924-1-000091','350.00','admin','2024 09 24','  Cash','  Dine-in','350.00','0.00','0.00','0.0','474','202409241219',NULL,NULL,NULL,NULL,NULL,NULL),(475,'20240924-1-000071','250.00','admin','2024 09 24','  Cash','  Dine-in','250.00','0.00','0.00','0.0','475','202409241333',NULL,NULL,NULL,NULL,NULL,NULL),(476,'20240924-1-000021','270.00','admin','2024 09 24','  Cash','  Dine-in','270.00','0.00','0.00','0.0','476','202409241350',NULL,NULL,NULL,NULL,NULL,NULL),(477,'20240924-1-000011','460.00','admin','2024 09 24','  Cash','  Dine-in','460.00','0.00','0.00','0.0','477','202409241351',NULL,NULL,NULL,NULL,NULL,NULL),(478,'20240924-1-000031','550.00','admin','2024 09 24','  Cash','  Dine-in','550.00','0.00','0.00','0.0','478','202409241414',NULL,NULL,NULL,NULL,NULL,NULL),(479,'20240924-1-000022','280.00','admin','2024 09 24','  Cash','  Dine-in','280.00','0.00','0.00','0.0','479','202409241443',NULL,NULL,NULL,NULL,NULL,NULL),(480,'20240924-1-000072','120.00','admin','2024 09 24','  Cash','  Dine-in','120.00','0.00','0.00','0.0','480','202409241448',NULL,NULL,NULL,NULL,NULL,NULL),(481,'20240924-1-000081','100.00','admin','2024 09 24','  Cash','  Dine-in','100.00','0.00','0.00','0.0','481','202409241452',NULL,NULL,NULL,NULL,NULL,NULL),(482,'20240924-1-000032','590.00','admin','2024 09 24','  Cash','  Dine-in','590.00','0.00','0.00','0.0','482','202409241509',NULL,NULL,NULL,NULL,NULL,NULL),(483,'20240924-1-000012','240.00','admin','2024 09 24','  Card','  Dine-in','240.00','0.00','0.00','0.0','483','202409241514',NULL,NULL,NULL,NULL,NULL,NULL),(484,'20240924-1-000013','100.00','admin','2024 09 24','  Card','  Dine-in','100.00','0.00','0.00','0.0','484','202409241515',NULL,NULL,NULL,NULL,NULL,NULL),(485,'20240924-1-000041','160.00','admin','2024 09 24','  Card','  Dine-in','160.00','0.00','0.00','0.0','485','202409241520',NULL,NULL,NULL,NULL,NULL,NULL),(486,'20240924-1-000092','560.00','admin','2024 09 24','  Card','  Dine-in','560.00','0.00','0.00','0.0','486','202409241521',NULL,NULL,NULL,NULL,NULL,NULL),(487,'20240924-1-000101','1500.00','admin','2024 09 24','  Card','  Dine-in','1500.00','0.00','0.00','0.0','487','202409241602',NULL,NULL,NULL,NULL,NULL,NULL),(488,'20240924-1-000051','390.00','admin','2024 09 24','  Cash','  Dine-in','390.00','0.00','0.00','0.0','488','202409241605',NULL,NULL,NULL,NULL,NULL,NULL),(489,'20240924-1-000014','700.00','admin','2024 09 24','  Cash','  Dine-in','700.00','0.00','0.00','0.0','489','202409241611',NULL,NULL,NULL,NULL,NULL,NULL),(490,'20240924-1-000082','440.00','admin','2024 09 24','  Cash','  Dine-in','440.00','0.00','0.00','0.0','490','202409241629',NULL,NULL,NULL,NULL,NULL,NULL),(491,'20240924-1-000033','420.00','admin','2024 09 24','  Cash','  Dine-in','420.00','0.00','0.00','0.0','491','202409241638',NULL,NULL,NULL,NULL,NULL,NULL),(492,'20240924-1-000093','180.00','admin','2024 09 24','  Card','  Dine-in','180.00','0.00','0.00','0.0','492','202409241643',NULL,NULL,NULL,NULL,NULL,NULL),(493,'20240924-1-000061','130.00','admin','2024 09 24','  Cash','  Dine-in','130.00','0.00','0.00','0.0','493','202409241646',NULL,NULL,NULL,NULL,NULL,NULL),(494,'20240924-1-000073','100.00','admin','2024 09 24','  Card','  Dine-in','100.00','0.00','0.00','0.0','494','202409241708',NULL,NULL,NULL,NULL,NULL,NULL),(495,'20240924-1-000083','280.00','admin','2024 09 24','  Card','  Dine-in','280.00','0.00','0.00','0.0','495','202409241816',NULL,NULL,NULL,NULL,NULL,NULL),(496,'20240924-1-000094','150.00','admin','2024 09 24','  Cash','  Dine-in','150.00','0.00','0.00','0.0','496','202409241938',NULL,NULL,NULL,NULL,NULL,NULL),(497,'20240924-1-000095','80.00','admin','2024 09 24','  Card','  Dine-in','80.00','0.00','0.00','0.0','497','202409242006',NULL,NULL,NULL,NULL,NULL,NULL),(498,'20240924-1-000096','150.00','admin','2024 09 24','  Cash','  Dine-in','150.00','0.00','0.00','0.0','498','202409242007',NULL,NULL,NULL,NULL,NULL,NULL),(499,'20240924-1-000097','110.00','admin','2024 09 24','  Cash','  Dine-in','110.00','0.00','0.00','0.0','499','202409242007',NULL,NULL,NULL,NULL,NULL,NULL),(500,'20240924-1-000098','150.00','admin','2024 09 24','  Card','  Takeaway','150.00','0.00','0.00','0.0','500','202409242008',NULL,NULL,NULL,NULL,NULL,NULL),(501,'20240924-1-000099','290.00','admin','2024 09 24','  Card','  Dine-in','290.00','0.00','0.00','0.0','501','202409242012',NULL,NULL,NULL,NULL,NULL,NULL),(502,'20240924-1-0000910','90.00','admin','2024 09 24','  Cash','  Dine-in','90.00','0.00','0.00','0.0','502','202409242041',NULL,NULL,NULL,NULL,NULL,NULL),(503,'20240924-1-0000911','80.00','admin','2024 09 24','  Cash','  Dine-in','80.00','0.00','0.00','0.0','503','202409242047',NULL,NULL,NULL,NULL,NULL,NULL),(504,'20240924-1-0000912','55.00','admin','2024 09 24','  Cash','  Dine-in','55.00','0.00','0.00','0.0','504','202409242048',NULL,NULL,NULL,NULL,NULL,NULL),(505,'20240924-1-0000913','150.00','admin','2024 09 24','  Card','  Dine-in','150.00','0.00','0.00','0.0','505','202409242104',NULL,NULL,NULL,NULL,NULL,NULL),(506,'20240924-1-0000914','150.00','admin','2024 09 24','  Card','  Dine-in','150.00','0.00','0.00','0.0','506','202409242107',NULL,NULL,NULL,NULL,NULL,NULL),(507,'20240924-1-000074','680.00','admin','2024 09 24','  Cash','  Dine-in','680.00','0.00','0.00','0.0','507','202409242143',NULL,NULL,NULL,NULL,NULL,NULL),(508,'20240924-1-000015','90.00','admin','2024 09 24','  Cash','  Dine-in','90.00','0.00','0.00','0.0','508','202409242149',NULL,NULL,NULL,NULL,NULL,NULL),(509,'20240924-1-000102','240.00','admin','2024 09 24','  Cash','  Dine-in','240.00','0.00','0.00','0.0','509','202409242204',NULL,NULL,NULL,NULL,NULL,NULL),(510,'20240924-1-000016','80.00','admin','2024 09 24','  Card','  Dine-in','80.00','0.00','0.00','0.0','510','202409242204',NULL,NULL,NULL,NULL,NULL,NULL),(511,'20240924-1-000017','150.00','admin','2024 09 24','  Card','  Dine-in','150.00','0.00','0.00','0.0','511','202409242225',NULL,NULL,NULL,NULL,NULL,NULL),(512,'20240924-1-000018','130.00','admin','2024 09 24','  Cash','  Dine-in','130.00','0.00','0.00','0.0','512','202409242227',NULL,NULL,NULL,NULL,NULL,NULL),(513,'20240925-1-000071','160.00','admin','2024 09 25','  Card','  Dine-in','160.00','0.00','0.00','0.0','513','202409251240',NULL,NULL,NULL,NULL,NULL,NULL),(514,'20240925-1-000091','510.00','admin','2024 09 25','  Cash','  Dine-in','510.00','0.00','0.00','0.0','514','202409251242',NULL,NULL,NULL,NULL,NULL,NULL),(515,'20240925-1-000101','540.00','admin','2024 09 25','  Cash','  Dine-in','540.00','0.00','0.00','0.0','515','202409251339',NULL,NULL,NULL,NULL,NULL,NULL),(516,'20240925-1-000072','120.00','admin','2024 09 25','  Cash','  Dine-in','120.00','0.00','0.00','0.0','516','202409251353',NULL,NULL,NULL,NULL,NULL,NULL),(517,'20240925-1-000011','80.00','admin','2024 09 25','  Cash','  Takeaway','80.00','0.00','0.00','0.0','517','202409251441',NULL,NULL,NULL,NULL,NULL,NULL),(518,'20240925-1-000081','150.00','admin','2024 09 25','  Cash','  Dine-in','150.00','0.00','0.00','0.0','518','202409251537',NULL,NULL,NULL,NULL,NULL,NULL),(519,'20240925-1-000073','150.00','admin','2024 09 25','  Card','  Dine-in','150.00','0.00','0.00','0.0','519','202409251610',NULL,NULL,NULL,NULL,NULL,NULL),(520,'20240925-1-000092','160.00','admin','2024 09 25','  Cash','  Dine-in','160.00','0.00','0.00','0.0','520','202409251624',NULL,NULL,NULL,NULL,NULL,NULL),(521,'20240925-1-000093','110.00','admin','2024 09 25','  Cash','  Dine-in','110.00','0.00','0.00','0.0','521','202409251632',NULL,NULL,NULL,NULL,NULL,NULL),(522,'20240925-1-000012','150.00','admin','2024 09 25','  Cash','  Dine-in','150.00','0.00','0.00','0.0','522','202409251801',NULL,NULL,NULL,NULL,NULL,NULL),(523,'20240925-1-000061','360.00','admin','2024 09 25','  Cash','  Dine-in','360.00','0.00','0.00','0.0','523','202409251805',NULL,NULL,NULL,NULL,NULL,NULL),(524,'20240925-1-000013','150.00','admin','2024 09 25','  Card','  Dine-in','150.00','0.00','0.00','0.0','524','202409251830',NULL,NULL,NULL,NULL,NULL,NULL),(525,'20240925-1-000014','300.00','admin','2024 09 25','  Card','  Dine-in','300.00','0.00','0.00','0.0','525','202409251845',NULL,NULL,NULL,NULL,NULL,NULL),(526,'20240925-1-000015','160.00','admin','2024 09 25','  Cash','  Dine-in','160.00','0.00','0.00','0.0','526','202409251854',NULL,NULL,NULL,NULL,NULL,NULL),(527,'20240925-1-000016','600.00','admin','2024 09 25','  Cash','  Dine-in','600.00','0.00','0.00','0.0','527','202409251855',NULL,NULL,NULL,NULL,NULL,NULL),(528,'20240925-1-000021','300.00','admin','2024 09 25','  Cash','  Dine-in','300.00','0.00','0.00','0.0','528','202409251919',NULL,NULL,NULL,NULL,NULL,NULL),(529,'20240925-1-000094','189.00','admin','2024 09 25','  Card','  Dine-in','189.00','0.00','0.00','0.0','529','202409251921',NULL,NULL,NULL,NULL,NULL,NULL),(530,'20240925-1-000062','300.00','admin','2024 09 25','  Cash','  Dine-in','300.00','0.00','0.00','0.0','530','202409251934',NULL,NULL,NULL,NULL,NULL,NULL),(531,'20240925-1-000031','110.00','admin','2024 09 25','  Cash','  Dine-in','110.00','0.00','0.00','0.0','531','202409251935',NULL,NULL,NULL,NULL,NULL,NULL),(532,'20240925-1-000017','120.00','admin','2024 09 25','  Card','  Dine-in','120.00','0.00','0.00','0.0','532','202409251935',NULL,NULL,NULL,NULL,NULL,NULL),(533,'20240925-1-000018','300.00','admin','2024 09 25','  Cash','  Dine-in','300.00','0.00','0.00','0.0','533','202409252026',NULL,NULL,NULL,NULL,NULL,NULL),(534,'20240925-1-000019','870.00','admin','2024 09 25','  Cash','  Dine-in','870.00','0.00','0.00','0.0','534','202409252031',NULL,NULL,NULL,NULL,NULL,NULL),(535,'20240925-1-0000110','280.00','admin','2024 09 25','  Cash','  Dine-in','280.00','0.00','0.00','0.0','535','202409252032',NULL,NULL,NULL,NULL,NULL,NULL),(536,'20240925-1-0000111','40.00','admin','2024 09 25','  Cash','  Dine-in','40.00','0.00','0.00','0.0','536','202409252034',NULL,NULL,NULL,NULL,NULL,NULL),(537,'20240925-1-000074','225.00','admin','2024 09 25','  Cash','  Dine-in','225.00','0.00','0.00','0.0','537','202409252034',NULL,NULL,NULL,NULL,NULL,NULL),(538,'20240925-1-0000112','130.00','admin','2024 09 25','  Card','  Dine-in','130.00','0.00','0.00','0.0','538','202409252102',NULL,NULL,NULL,NULL,NULL,NULL),(539,'20240925-1-0000113','150.00','admin','2024 09 25','  Card','  Dine-in','150.00','0.00','0.00','0.0','539','202409252125',NULL,NULL,NULL,NULL,NULL,NULL),(540,'20240925-1-0000114','50.00','admin','2024 09 25','  Cash','  Dine-in','50.00','0.00','0.00','0.0','540','202409252127',NULL,NULL,NULL,NULL,NULL,NULL),(541,'20240925-1-000082','420.00','admin','2024 09 25','  Cash','  Dine-in','420.00','0.00','0.00','0.0','541','202409252138',NULL,NULL,NULL,NULL,NULL,NULL),(542,'20240925-1-000063','710.00','admin','2024 09 25','  Card','  Dine-in','710.00','0.00','0.00','0.0','542','202409252147',NULL,NULL,NULL,NULL,NULL,NULL),(543,'20240925-1-000064','339.00','admin','2024 09 25','  Cash','  Dine-in','339.00','0.00','0.00','0.0','543','202409252200',NULL,NULL,NULL,NULL,NULL,NULL),(544,'20240925-1-000075','430.00','admin','2024 09 25','  Cash','  Dine-in','430.00','0.00','0.00','0.0','544','202409252205',NULL,NULL,NULL,NULL,NULL,NULL),(545,'20240925-1-0000115','160.00','admin','2024 09 25','  Cash','  Dine-in','160.00','0.00','0.00','0.0','545','202409252227',NULL,NULL,NULL,NULL,NULL,NULL),(546,'20240925-1-000083','180.00','admin','2024 09 25','  Cash','  Dine-in','180.00','0.00','0.00','0.0','546','202409252239',NULL,NULL,NULL,NULL,NULL,NULL),(547,'20240925-1-000095','180.00','admin','2024 09 25','  Cash','  Dine-in','180.00','0.00','0.00','0.0','547','202409252240',NULL,NULL,NULL,NULL,NULL,NULL),(548,'20240925-1-000102','250.00','admin','2024 09 25','  Cash','  Dine-in','250.00','0.00','0.00','0.0','548','202409252240',NULL,NULL,NULL,NULL,NULL,NULL),(549,'20240925-1-0000116','180.00','admin','2024 09 25','  Cash','  Dine-in','180.00','0.00','0.00','0.0','549','202409252242',NULL,NULL,NULL,NULL,NULL,NULL),(550,'20240926-1-000091','80.00','admin','2024 09 26','  Cash','  Dine-in','80.00','0.00','0.00','0.0','550','202409261256',NULL,NULL,NULL,NULL,NULL,NULL),(551,'20240926-1-000092','550.00','admin','2024 09 26','  Cash','  Dine-in','550.00','0.00','0.00','0.0','551','202409261258',NULL,NULL,NULL,NULL,NULL,NULL),(552,'20240926-1-000101','150.00','admin','2024 09 26','  Cash','  Dine-in','150.00','0.00','0.00','0.0','552','202409261300',NULL,NULL,NULL,NULL,NULL,NULL),(553,'20240926-1-000093','150.00','admin','2024 09 26','  Cash','  Dine-in','150.00','0.00','0.00','0.0','553','202409261301',NULL,NULL,NULL,NULL,NULL,NULL),(554,'20240926-1-000094','80.00','admin','2024 09 26','  Cash','  Dine-in','80.00','0.00','0.00','0.0','554','202409261304',NULL,NULL,NULL,NULL,NULL,NULL),(555,'20240926-1-000021','100.00','admin','2024 09 26','  Cash','  Dine-in','100.00','0.00','0.00','0.0','555','202409261310',NULL,NULL,NULL,NULL,NULL,NULL),(556,'20240926-1-000031','250.00','admin','2024 09 26','  Cash','  Dine-in','250.00','0.00','0.00','0.0','556','202409261324',NULL,NULL,NULL,NULL,NULL,NULL),(557,'20240926-1-000071','170.00','admin','2024 09 26','  Cash','  Dine-in','170.00','0.00','0.00','0.0','557','202409261401',NULL,NULL,NULL,NULL,NULL,NULL),(558,'20240926-1-000102','330.00','admin','2024 09 26','  Cash','  Dine-in','330.00','0.00','0.00','0.0','558','202409261401',NULL,NULL,NULL,NULL,NULL,NULL),(559,'20240926-1-000081','170.00','admin','2024 09 26','  Cash','  Dine-in','170.00','0.00','0.00','0.0','559','202409261423',NULL,NULL,NULL,NULL,NULL,NULL),(560,'20240926-1-000061','90.00','admin','2024 09 26','  Cash','  Dine-in','90.00','0.00','0.00','0.0','560','202409261428',NULL,NULL,NULL,NULL,NULL,NULL),(561,'20240926-1-000051','130.00','admin','2024 09 26','  Cash','  Dine-in','130.00','0.00','0.00','0.0','561','202409261448',NULL,NULL,NULL,NULL,NULL,NULL),(562,'20240926-1-000072','80.00','admin','2024 09 26','  Cash','  Dine-in','80.00','0.00','0.00','0.0','562','202409261451',NULL,NULL,NULL,NULL,NULL,NULL),(563,'20240926-1-000022','199.00','admin','2024 09 26','  Cash','  Dine-in','199.00','0.00','0.00','0.0','563','202409261457',NULL,NULL,NULL,NULL,NULL,NULL),(564,'20240926-1-000032','290.00','admin','2024 09 26','  Cash','  Dine-in','290.00','0.00','0.00','0.0','564','202409261457',NULL,NULL,NULL,NULL,NULL,NULL),(565,'20240926-1-000011','400.00','admin','2024 09 26','  Cash','  Dine-in','400.00','0.00','0.00','0.0','565','202409261512',NULL,NULL,NULL,NULL,NULL,NULL),(566,'20240926-1-000095','160.00','admin','2024 09 26','  Cash','  Dine-in','160.00','0.00','0.00','0.0','566','202409261535',NULL,NULL,NULL,NULL,NULL,NULL),(567,'20240926-1-000082','250.00','admin','2024 09 26','  Card','  Takeaway','250.00','0.00','0.00','0.0','567','202409261617',NULL,NULL,NULL,NULL,NULL,NULL),(568,'20240926-1-000052','470.00','admin','2024 09 26','  Card','  Dine-in','470.00','0.00','0.00','0.0','568','202409261618',NULL,NULL,NULL,NULL,NULL,NULL),(569,'20240926-1-000073','90.00','admin','2024 09 26','  Card','  Dine-in','90.00','0.00','0.00','0.0','569','202409261624',NULL,NULL,NULL,NULL,NULL,NULL),(570,'20240926-1-000083','180.00','admin','2024 09 26','  Card','  Dine-in','180.00','0.00','0.00','0.0','570','202409261646',NULL,NULL,NULL,NULL,NULL,NULL),(571,'20240926-1-000023','150.00','admin','2024 09 26','  Cash','  Dine-in','150.00','0.00','0.00','0.0','571','202409261652',NULL,NULL,NULL,NULL,NULL,NULL),(572,'20240926-1-000012','250.00','admin','2024 09 26','  Cash','  Dine-in','250.00','0.00','0.00','0.0','572','202409261912',NULL,NULL,NULL,NULL,NULL,NULL),(573,'20240926-1-000013','300.00','admin','2024 09 26','  Cash','  Dine-in','300.00','0.00','0.00','0.0','573','202409261925',NULL,NULL,NULL,NULL,NULL,NULL),(574,'20240926-1-000014','220.00','admin','2024 09 26','  Cash','  Dine-in','220.00','0.00','0.00','0.0','574','202409261927',NULL,NULL,NULL,NULL,NULL,NULL),(575,'20240926-1-000015','330.00','admin','2024 09 26','  Cash','  Dine-in','330.00','0.00','0.00','0.0','575','202409261949',NULL,NULL,NULL,NULL,NULL,NULL),(576,'20240926-1-000016','350.00','admin','2024 09 26','  Card','  Dine-in','350.00','0.00','0.00','0.0','576','202409261951',NULL,NULL,NULL,NULL,NULL,NULL),(577,'20240926-1-000024','30.00','admin','2024 09 26','  Cash','  Dine-in','30.00','0.00','0.00','0.0','577','202409262019',NULL,NULL,NULL,NULL,NULL,NULL),(578,'20240926-1-000017','270.00','admin','2024 09 26','  Cash','  Dine-in','270.00','0.00','0.00','0.0','578','202409262026',NULL,NULL,NULL,NULL,NULL,NULL),(579,'20240926-1-000018','160.00','admin','2024 09 26','  Cash','  Dine-in','160.00','0.00','0.00','0.0','579','202409262027',NULL,NULL,NULL,NULL,NULL,NULL),(580,'20240926-1-000019','200.00','admin','2024 09 26','  Cash','  Takeaway','200.00','0.00','0.00','0.0','580','202409262049',NULL,NULL,NULL,NULL,NULL,NULL),(581,'20240926-1-000096','200.00','admin','2024 09 26','  Cash','  Dine-in','200.00','0.00','0.00','0.0','581','202409262100',NULL,NULL,NULL,NULL,NULL,NULL),(582,'20240926-1-000033','500.00','admin','2024 09 26','  Cash','  Dine-in','500.00','0.00','0.00','0.0','582','202409262101',NULL,NULL,NULL,NULL,NULL,NULL),(583,'20240926-1-000103','280.00','admin','2024 09 26','  Card','  Dine-in','280.00','0.00','0.00','0.0','583','202409262101',NULL,NULL,NULL,NULL,NULL,NULL),(584,'20240926-1-0000110','110.00','admin','2024 09 26','  Cash','  Dine-in','110.00','0.00','0.00','0.0','584','202409262209',NULL,NULL,NULL,NULL,NULL,NULL),(585,'20240926-1-0000111','660.00','admin','2024 09 26','  Card','  Dine-in','660.00','0.00','0.00','0.0','585','202409262218',NULL,NULL,NULL,NULL,NULL,NULL),(586,'20240926-1-000104','120.00','admin','2024 09 26','  Cash','  Takeaway','120.00','0.00','0.00','0.0','586','202409262236',NULL,NULL,NULL,NULL,NULL,NULL),(587,'20240927-1-000011','130.00','admin','2024 09 27','  Card','  Takeaway','130.00','0.00','0.00','0.0','587','202409271238',NULL,NULL,NULL,NULL,NULL,NULL),(588,'20240927-1-000091','300.00','admin','2024 09 27','  Cash','  Dine-in','300.00','0.00','0.00','0.0','588','202409271247',NULL,NULL,NULL,NULL,NULL,NULL),(589,'20240927-1-000012','1630.00','admin','2024 09 27','  Card','  Dine-in','1630.00','0.00','0.00','0.0','589','202409271300',NULL,NULL,NULL,NULL,NULL,NULL),(590,'20240927-1-000021','340.00','admin','2024 09 27','  Card','  Dine-in','340.00','0.00','0.00','0.0','590','202409271306',NULL,NULL,NULL,NULL,NULL,NULL),(591,'20240927-1-000081','140.00','admin','2024 09 27','  Cash','  Dine-in','140.00','0.00','0.00','0.0','591','202409271308',NULL,NULL,NULL,NULL,NULL,NULL),(592,'20240927-1-000031','450.00','admin','2024 09 27','  Cash','  Dine-in','450.00','0.00','0.00','0.0','592','202409271322',NULL,NULL,NULL,NULL,NULL,NULL),(593,'20240927-1-000051','140.00','admin','2024 09 27','  Cash','  Dine-in','140.00','0.00','0.00','0.0','593','202409271332',NULL,NULL,NULL,NULL,NULL,NULL),(594,'20240927-1-000071','200.00','admin','2024 09 27','  Card','  Dine-in','200.00','0.00','0.00','0.0','594','202409271339',NULL,NULL,NULL,NULL,NULL,NULL),(595,'20240927-1-000092','90.00','admin','2024 09 27','  Cash','  Dine-in','90.00','0.00','0.00','0.0','595','202409271348',NULL,NULL,NULL,NULL,NULL,NULL),(596,'20240927-1-000082','550.00','admin','2024 09 27','  Cash','  Dine-in','550.00','0.00','0.00','0.0','596','202409271348',NULL,NULL,NULL,NULL,NULL,NULL),(597,'20240927-1-000013','80.00','admin','2024 09 27','  Cash','  Dine-in','80.00','0.00','0.00','0.0','597','202409271406',NULL,NULL,NULL,NULL,NULL,NULL),(598,'20240927-1-000014','450.00','admin','2024 09 27','  Cash','  Dine-in','450.00','0.00','0.00','0.0','598','202409271407',NULL,NULL,NULL,NULL,NULL,NULL),(599,'20240927-1-000015','100.00','admin','2024 09 27','  Card','  Dine-in','100.00','0.00','0.00','0.0','599','202409271409',NULL,NULL,NULL,NULL,NULL,NULL),(600,'20240927-1-000016','120.00','admin','2024 09 27','  Cash','  Dine-in','120.00','0.00','0.00','0.0','600','202409271431',NULL,NULL,NULL,NULL,NULL,NULL),(601,'20240927-1-000022','140.00','admin','2024 09 27','  Cash','  Dine-in','140.00','0.00','0.00','0.0','601','202409271431',NULL,NULL,NULL,NULL,NULL,NULL),(602,'20240927-1-000032','230.00','admin','2024 09 27','  Cash','  Dine-in','230.00','0.00','0.00','0.0','602','202409271436',NULL,NULL,NULL,NULL,NULL,NULL),(603,'20240927-1-000017','180.00','admin','2024 09 27','  Card','  Dine-in','180.00','0.00','0.00','0.0','603','202409271450',NULL,NULL,NULL,NULL,NULL,NULL),(604,'20240927-1-000052','180.00','admin','2024 09 27','  Cash','  Dine-in','180.00','0.00','0.00','0.0','604','202409271502',NULL,NULL,NULL,NULL,NULL,NULL),(605,'20240927-1-000018','180.00','admin','2024 09 27','  Cash','  Dine-in','180.00','0.00','0.00','0.0','605','202409271503',NULL,NULL,NULL,NULL,NULL,NULL),(606,'20240927-1-000019','80.00','admin','2024 09 27','  Card','  Dine-in','80.00','0.00','0.00','0.0','606','202409271503',NULL,NULL,NULL,NULL,NULL,NULL),(607,'20240927-1-0000110','160.00','admin','2024 09 27','  Cash','  Dine-in','160.00','0.00','0.00','0.0','607','202409271509',NULL,NULL,NULL,NULL,NULL,NULL),(608,'20240927-1-000072','230.00','admin','2024 09 27','  Cash','  Dine-in','230.00','0.00','0.00','0.0','608','202409271509',NULL,NULL,NULL,NULL,NULL,NULL),(609,'20240927-1-0000111','130.00','admin','2024 09 27','  Cash','  Dine-in','130.00','0.00','0.00','0.0','609','202409271514',NULL,NULL,NULL,NULL,NULL,NULL),(610,'20240927-1-0000112','230.00','admin','2024 09 27','  Cash','  Dine-in','230.00','0.00','0.00','0.0','610','202409271527',NULL,NULL,NULL,NULL,NULL,NULL),(611,'20240927-1-000061','390.00','admin','2024 09 27','  Cash','  Dine-in','390.00','0.00','0.00','0.0','611','202409271528',NULL,NULL,NULL,NULL,NULL,NULL),(612,'20240927-1-000033','310.00','admin','2024 09 27','  Cash','  Dine-in','310.00','0.00','0.00','0.0','612','202409271528',NULL,NULL,NULL,NULL,NULL,NULL),(613,'20240927-1-000093','355.00','admin','2024 09 27','  Cash','  Dine-in','355.00','0.00','0.00','0.0','613','202409271553',NULL,NULL,NULL,NULL,NULL,NULL),(614,'20240927-1-000053','460.00','admin','2024 09 27','  Cash','  Dine-in','460.00','0.00','0.00','0.0','614','202409271558',NULL,NULL,NULL,NULL,NULL,NULL),(615,'20240927-1-000083','390.00','admin','2024 09 27','  Cash','  Dine-in','390.00','0.00','0.00','0.0','615','202409271558',NULL,NULL,NULL,NULL,NULL,NULL),(616,'20240927-1-000073','280.00','admin','2024 09 27','  Cash','  Dine-in','280.00','0.00','0.00','0.0','616','202409271604',NULL,NULL,NULL,NULL,NULL,NULL),(617,'20240927-1-0000113','420.00','admin','2024 09 27','  Cash','  Dine-in','420.00','0.00','0.00','0.0','617','202409271616',NULL,NULL,NULL,NULL,NULL,NULL),(618,'20240927-1-000034','160.00','admin','2024 09 27','  Cash','  Dine-in','160.00','0.00','0.00','0.0','618','202409271622',NULL,NULL,NULL,NULL,NULL,NULL),(619,'20240927-1-000084','170.00','admin','2024 09 27','  Card','  Dine-in','170.00','0.00','0.00','0.0','619','202409271623',NULL,NULL,NULL,NULL,NULL,NULL),(620,'20240927-1-000101','300.00','admin','2024 09 27','  Cash','  Dine-in','300.00','0.00','0.00','0.0','620','202409271630',NULL,NULL,NULL,NULL,NULL,NULL),(621,'20240927-1-000094','340.00','admin','2024 09 27','  Cash','  Dine-in','340.00','0.00','0.00','0.0','621','202409271655',NULL,NULL,NULL,NULL,NULL,NULL),(622,'20240927-1-000035','370.00','admin','2024 09 27','  Cash','  Dine-in','370.00','0.00','0.00','0.0','622','202409271712',NULL,NULL,NULL,NULL,NULL,NULL),(623,'20240927-1-0000114','190.00','admin','2024 09 27','  Cash','  Dine-in','190.00','0.00','0.00','0.0','623','202409271829',NULL,NULL,NULL,NULL,NULL,NULL),(624,'20240927-1-0000115','250.00','admin','2024 09 27','  Cash','  Dine-in','250.00','0.00','0.00','0.0','624','202409271830',NULL,NULL,NULL,NULL,NULL,NULL),(625,'20240927-1-0000116','250.00','admin','2024 09 27','  Cash','  Dine-in','250.00','0.00','0.00','0.0','625','202409271917',NULL,NULL,NULL,NULL,NULL,NULL),(626,'20240927-1-0000117','450.00','admin','2024 09 27','  Cash','  Dine-in','450.00','0.00','0.00','0.0','626','202409271927',NULL,NULL,NULL,NULL,NULL,NULL),(627,'20240927-1-0000118','445.00','admin','2024 09 27','  Card','  Dine-in','445.00','0.00','0.00','0.0','627','202409272010',NULL,NULL,NULL,NULL,NULL,NULL),(628,'20240927-1-000102','450.00','admin','2024 09 27','  Cash','  Dine-in','450.00','0.00','0.00','0.0','628','202409272021',NULL,NULL,NULL,NULL,NULL,NULL),(629,'20240927-1-000023','250.00','admin','2024 09 27','  Card','  Dine-in','250.00','0.00','0.00','0.0','629','202409272044',NULL,NULL,NULL,NULL,NULL,NULL),(630,'20240927-1-000024','100.00','admin','2024 09 27','  Cash','  Dine-in','100.00','0.00','0.00','0.0','630','202409272044',NULL,NULL,NULL,NULL,NULL,NULL),(631,'20240927-1-000103','440.00','admin','2024 09 27','  Cash','  Dine-in','440.00','0.00','0.00','0.0','631','202409272051',NULL,NULL,NULL,NULL,NULL,NULL),(632,'20240927-1-000036','460.00','admin','2024 09 27','  Cash','  Dine-in','460.00','0.00','0.00','0.0','632','202409272059',NULL,NULL,NULL,NULL,NULL,NULL),(633,'20240927-1-000025','300.00','admin','2024 09 27','  Cash','  Dine-in','300.00','0.00','0.00','0.0','633','202409272106',NULL,NULL,NULL,NULL,NULL,NULL),(634,'20240927-1-0000119','260.00','admin','2024 09 27','  Cash','  Dine-in','260.00','0.00','0.00','0.0','634','202409272106',NULL,NULL,NULL,NULL,NULL,NULL),(635,'20240927-1-000074','100.00','admin','2024 09 27','  Cash','  Dine-in','100.00','0.00','0.00','0.0','635','202409272119',NULL,NULL,NULL,NULL,NULL,NULL),(636,'20240927-1-000104','750.00','admin','2024 09 27','  Cash','  Dine-in','750.00','0.00','0.00','0.0','636','202409272120',NULL,NULL,NULL,NULL,NULL,NULL),(637,'20240927-1-000105','150.00','admin','2024 09 27','  Cash','  Dine-in','150.00','0.00','0.00','0.0','637','202409272222',NULL,NULL,NULL,NULL,NULL,NULL),(638,'20240927-1-000106','1050.00','admin','2024 09 27','  Cash','  Dine-in','1050.00','0.00','0.00','0.0','638','202409272324',NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO `clicked_cust_name` (`_id`, `name`) VALUES (1,'');
INSERT INTO `cusotmer_activity_temp_top3` (`_id`, `name`, `phone_no`, `email`, `addr`, `total_amount`, `balance`, `discount_value`, `discount_type`, `approval_rate`) VALUES (2,'Taste food online delivery ','6305707872','','',300,'300.0',NULL,NULL,NULL);
INSERT INTO `expenses_sales` (`_id`, `expensename`, `price`, `category`, `counterperson_username`, `counterperson_name`, `date`, `time`, `datetimee_new`) VALUES (1,'Building Rent','666','Rent','madmin','madmin','16 Sep 2024','02:16 PM','202409161416'),(2,'Cheff salaries','2350','Maintenance','madmin','madmin','16 Sep 2024','02:17 PM','202409161417'),(3,'Captain ','500','Maintenance','madmin','madmin','16 Sep 2024','02:17 PM','202409161417'),(4,'Salaries','4603','Maintenance','madmin','madmin','16 Sep 2024','02:19 PM','202409161419'),(5,'vegitable','220','Utilities','madmin','madmin','16 Sep 2024','06:43 PM','202409161843'),(6,'kirana','200','Utilities','madmin','madmin','16 Sep 2024','06:44 PM','202409161844'),(7,'eggs','150','Rent','madmin','madmin','16 Sep 2024','06:44 PM','202409161844'),(8,'kothimera ','80','Utilities','madmin','madmin','16 Sep 2024','06:44 PM','202409161844');
INSERT INTO `itemdata` (`_id`, `itemname`, `total`) VALUES (1,'Chicken Dum Biryani ',600),(2,'Cool drink',25),(3,'Panner Biryani ',180),(4,'Tangdi kabab biryani ',250),(5,'Guntur Pulao with Chicken Curry',150),(6,'Half Rice',20),(7,'Panner Biryani ',180),(8,'Pulka',20),(9,'Tangdi kabab biryani ',250),(10,'chapathi 2 with panner curry',100),(11,'curd',20),(12,'Half Rice',20),(13,'Omlet',60),(14,'Panner Biryani ',180),(15,'Pulka',80),(16,'Tangdi kabab biryani ',250),(17,'Veg Biryani ',150),(18,'Water bottle ',100),(19,'chapathi',120),(20,'chapathi 2 with panner curry',100),(21,'chicken lollypop ',210),(22,'curd',20),(23,'egg bhurji ',120),(24,'curd',20),(25,'egg bhurji ',120),(26,'chapathi 2 with panner curry',200),(27,'chicken lollypop ',210),(28,'curd',20),(29,'egg bhurji ',120),(30,'chapathi 2 with panner curry',200),(31,'chicken lollypop ',210),(32,'chilli gobi',120),(33,'curd',20),(34,'egg bhurji ',120),(35,'kaju curry',180),(36,'mushroom biryani ',300),(37,'Water bottle ',180),(38,'Water bottle Half ',50),(39,'chapathi',200),(40,'panner Curry with Chapathi 2 ',100),(41,'water bottle ',100),(42,'water bottle half',60),(43,'water bottle ',120),(44,'water bottle half',60),(45,'chapathi',200),(46,'panner Curry with Chapathi 2 ',100),(47,'water bottle ',120),(48,'water bottle half',60),(49,'Mushroom Biryani',900),(50,'Mushroom Curry',320),(51,'Mushroom Curry ',160),(52,'Mushroom Curry with Chapathi 2',180),(53,'Mutton Biryani ',500),(54,'Mutton Fride rice',200),(55,'Mutton Manchurian ',250),(56,'Muttoon Biryani',2000),(57,'Non veg thali',300),(58,'Palak Panner',180),(59,'Panner Biryani ',180),(60,'Panner Butter Masala',540),(61,'Panner Curry with Pulka 3',540),(62,'Prawns Biryani',320),(63,'Pulka',330),(64,'Punjabi Chicken',200),(65,'Roti',600),(66,'Tandoori Chicken Full',400),(67,'Tandoori Chicken Single',250),(68,'Tandoori Roti',80),(69,'Tangdi Kabab Single',320),(70,'Tomato Fride rice',100),(71,'VEG BIRYANI',150),(72,'Veg Manchurian',169),(73,'Veg Thali',1520),(74,'Veg fried rice ',500),(75,'Veg thali',560),(76,'Water bottle ',180),(77,'Water bottle Half ',50),(78,'chapathi',200),(79,'chicken fry bone',180),(80,'chicken pakoda',500),(81,'chicken pakoda half',50),(82,'chicken tikka masala curry ',200),(83,'cool drink',100),(84,'curd',60),(85,'curd rice ',450),(86,'egg',10),(87,'fish pakoda',250),(88,'lassi',80),(89,'mushroom manchurian',150),(90,'mushroom soup',100),(91,'mutton biriyani ',250),(92,'panner Curry with Chapathi 2 ',100),(93,'tangidi kabab biryani',250),(94,'water bottle ',420),(95,'water bottle half',330),(96,'white rice ',60),(97,'white rice half',60),(98,'wings biryani ',250);
INSERT INTO `itemwiseorderlistcategory` (`_id`, `itemno`, `categoryname`, `sales`, `salespercentage`, `itemtotalquan`) VALUES (1,NULL,'Currys',540,4,'3'),(2,NULL,'None',7620,61,'96'),(3,NULL,'Tandoori',395,3,'8'),(4,NULL,'main course',3450,28,'20'),(5,NULL,'staters',360,3,'2');
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,'41','Chicken Dum Biryani ',600,57,'4','None',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(2,'62','Cool drink',25,2,'1','None',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(3,'57','Panner Biryani ',180,17,'1','None',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(4,'63','Tangdi kabab biryani ',250,24,'1','None',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(5,'68','Guntur Pulao with Chicken Curry',150,7,'1','None',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(6,'66','Half Rice',20,1,'1','None',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(7,'57','Panner Biryani ',180,8,'1','None',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(8,'65','Pulka',20,1,'2','None',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(9,'63','Tangdi kabab biryani ',250,12,'1','None',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10,'69','chapathi 2 with panner curry',100,5,'1','None',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(11,'67','curd',20,1,'1','None',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(12,'66','Half Rice',20,0,'1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(13,'71','Omlet',60,1,'2',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(14,'57','Panner Biryani ',180,3,'1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(15,'65','Pulka',80,1,'8',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(16,'63','Tangdi kabab biryani ',250,4,'1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(17,'55','Veg Biryani ',150,2,'1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(18,'72','Water bottle ',100,2,'5',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(19,'75','chapathi',120,2,'6',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(20,'69','chapathi 2 with panner curry',100,2,'1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(21,'74','chicken lollypop ',210,3,'1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(22,'67','curd',20,0,'1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(23,'76','egg bhurji ',120,2,'1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(24,'67','curd',20,0,'1','None',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(25,'76','egg bhurji ',120,2,'1','None',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(26,'69','chapathi 2 with panner curry',200,3,'2','None',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(27,'74','chicken lollypop ',210,3,'1','Snacks',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(28,'67','curd',20,0,'1','None',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(29,'76','egg bhurji ',120,2,'1','None',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(30,'69','chapathi 2 with panner curry',200,2,'2','None',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(31,'74','chicken lollypop ',210,2,'1','Snacks',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(32,'90','chilli gobi',120,1,'1','None',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(33,'67','curd',20,0,'1','None',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(34,'76','egg bhurji ',120,1,'1','None',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(35,'89','kaju curry',180,2,'1','None',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(36,'92','mushroom biryani ',300,3,'2','None',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(37,'120','Water bottle ',180,2,'9','None',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(38,'120','Water bottle Half ',50,0,'5','None',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(39,'120','chapathi',200,2,'10','None',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(40,'191','panner Curry with Chapathi 2 ',100,1,'1','None',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(41,'176','water bottle ',100,1,'5','None',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(42,'177','water bottle half',60,1,'6','None',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(43,'176','water bottle ',120,1,'6','None',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(44,'177','water bottle half',60,1,'6','None',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(45,'122','chapathi',200,1,'10','None',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(46,'191','panner Curry with Chapathi 2 ',100,1,'1','None',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(47,'176','water bottle ',120,1,'6','None',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(48,'177','water bottle half',60,0,'6','None',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(49,'88','Mushroom Biryani',900,2,'6','main course',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(50,'168','Mushroom Curry',320,1,'2','Currys',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(51,'168','Mushroom Curry ',160,0,'1','None',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(52,'168','Mushroom Curry with Chapathi 2',180,0,'2','None',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(53,'168','Mutton Biryani ',500,1,'2','None',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(54,'72','Mutton Fride rice',200,1,'1','main course',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(55,'72','Mutton Manchurian ',250,1,'1','None',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(56,'60','Muttoon Biryani',2000,5,'8','main course',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(57,'187','Non veg thali',300,1,'3','None',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(58,'160','Palak Panner',180,0,'1','Currys',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(59,'160','Panner Biryani ',180,0,'1','None',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(60,'150','Panner Butter Masala',540,1,'3','Currys',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(61,'181','Panner Curry with Pulka 3',540,1,'6','None',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(62,'69','Prawns Biryani',320,1,'1','main course',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(63,'148','Pulka',330,1,'33','Tandoori',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(64,'119','Punjabi Chicken',200,1,'1','Currys',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(65,'144','Roti',600,1,'30','Tandoori',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(66,'121','Tandoori Chicken Full',400,1,'1','Tandoori',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(67,'120','Tandoori Chicken Single',250,1,'1','Tandoori',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(68,'120','Tandoori Roti',80,0,'4','Tandoori',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(69,'122','Tangdi Kabab Single',320,1,'2','Tandoori',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(70,'92','Tomato Fride rice',100,0,'1','main course',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(71,'82','VEG BIRYANI',150,0,'1','main course',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(72,'49','Veg Manchurian',169,0,'1','staters',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(73,'186','Veg Thali',1520,4,'19','None',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(74,'206','Veg fried rice ',500,1,'5','None',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(75,'206','Veg thali',560,1,'7','None',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(76,'206','Water bottle ',180,0,'9','None',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(77,'206','Water bottle Half ',50,0,'5','None',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(78,'206','chapathi',200,1,'10','None',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(79,'215','chicken fry bone',180,0,'1','None',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(80,'208','chicken pakoda',500,1,'5','None',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(81,'217','chicken pakoda half',50,0,'1','None',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(82,'213','chicken tikka masala curry ',200,1,'1','None',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(83,'216','cool drink',100,0,'4','None',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(84,'204','curd',60,0,'3','None',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(85,'199','curd rice ',450,1,'6','None',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(86,'203','egg',10,0,'1','None',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(87,'207','fish pakoda',250,1,'1','None',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(88,'205','lassi',80,0,'2','None',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(89,'201','mushroom manchurian',150,0,'1','None',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(90,'202','mushroom soup',100,0,'1','None',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(91,'209','mutton biriyani ',250,1,'1','None',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(92,'191','panner Curry with Chapathi 2 ',100,0,'1','None',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(93,'210','tangidi kabab biryani',250,1,'1','None',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(94,'176','water bottle ',420,1,'21','None',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(95,'177','water bottle half',330,1,'37','None',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(96,'196','white rice ',60,0,'2','None',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(97,'212','white rice half',60,0,'3','None',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(98,'214','wings biryani ',250,1,'1','None',NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO `top_category` (`_id`, `category`, `value`) VALUES (1,'None',1055),(2,'None',2135),(3,'None',5965),(4,'Snacks',210),(5,'None',6815),(6,'Snacks',210),(7,'None',7560),(8,'Snacks',210),(9,'None',11300),(10,'Snacks',210),(11,'None',11300),(12,'Snacks',210),(13,'None',11430),(14,'Snacks',210),(15,'None',2090),(16,'None',6060),(17,'None',8245),(18,'None',8345),(21,'None',8345),(23,'None',9995),(24,'None',10255),(27,'None',10635),(29,'None',11235),(30,'None',1180),(31,'None',3220),(34,'None',3520),(36,'None',3540),(37,'None',3820),(38,'None',6960),(39,'None',7030),(40,'None',7080),(41,'main course',560),(42,'None',7100),(43,'Tandoori',250),(44,'main course',1060),(45,'staters',360),(46,'None',7100),(47,'Tandoori',250),(48,'main course',1060),(49,'staters',360),(50,'Currys',180),(51,'None',7100),(52,'Tandoori',330),(53,'main course',1760),(54,'staters',360),(55,'Currys',180),(56,'None',7100),(57,'Tandoori',330),(58,'main course',2210),(59,'staters',360),(60,'Currys',540),(61,'None',7470),(62,'Tandoori',395),(63,'main course',3320),(64,'staters',360),(70,'Currys',540),(71,'None',7940),(72,'Tandoori',395),(73,'main course',3710),(74,'staters',360),(75,'Currys',820),(76,'None',7970),(77,'Tandoori',785),(78,'main course',3890),(79,'staters',360),(80,'Currys',820),(81,'None',7970),(82,'Tandoori',785),(83,'main course',3890),(84,'staters',360),(85,'Currys',820),(86,'None',7970),(87,'Tandoori',785),(88,'main course',3890),(89,'staters',360),(90,'Currys',820),(91,'None',7970),(92,'Tandoori',785),(93,'main course',3890),(94,'staters',360),(95,'Currys',360),(96,'None',910),(97,'Tandoori',90),(98,'main course',1500),(99,'Currys',360),(100,'None',1210),(101,'Tandoori',90),(102,'main course',1500),(103,'Currys',360),(104,'None',1210),(105,'Tandoori',90),(106,'main course',1500),(107,'Currys',360),(108,'None',1360),(109,'Tandoori',90),(110,'main course',1500),(111,'Currys',360),(112,'None',1440),(113,'Tandoori',90),(114,'main course',1500),(115,'Currys',709),(116,'None',1720),(117,'Tandoori',210),(118,'main course',1640),(119,'staters',180),(120,'Currys',709),(121,'None',1970),(122,'Tandoori',210),(123,'main course',1640),(124,'staters',180),(130,'Currys',889),(131,'None',3290),(132,'Tandoori',210),(133,'main course',2090),(134,'staters',349),(140,'Currys',1069),(141,'None',3430),(142,'Tandoori',260),(143,'main course',2090),(144,'staters',529),(155,'Currys',1229),(156,'None',3720),(157,'Tandoori',410),(158,'main course',3040),(159,'staters',529),(160,'Currys',1229),(161,'None',3860),(162,'Tandoori',410),(163,'main course',3040),(164,'staters',529),(165,'Currys',1229),(166,'None',3860),(167,'Tandoori',410),(168,'main course',3040),(169,'staters',529),(170,'Currys',1229),(171,'None',4060),(172,'Tandoori',410),(173,'main course',3490),(174,'staters',529),(175,'Currys',240),(176,'None',1280),(177,'Tandoori',40),(178,'main course',1030),(179,'Currys',339),(180,'None',2920),(181,'Tandoori',480),(182,'main course',1470),(183,'Currys',499),(184,'None',3620),(185,'Tandoori',540),(186,'main course',2090),(187,'Currys',499),(188,'None',3940),(189,'Tandoori',580),(190,'main course',3380),(191,'staters',460),(192,'Currys',499),(193,'None',4140),(194,'Tandoori',720),(195,'main course',3380),(196,'staters',460),(197,'None',920),(198,'main course',1660),(199,'staters',180),(200,'Currys',200),(201,'None',1870),(202,'Tandoori',320),(203,'main course',2770),(204,'staters',640),(205,'Currys',200),(206,'None',1900),(207,'Soups',189),(208,'Tandoori',360),(209,'main course',3070),(210,'staters',850),(211,'Currys',299),(212,'None',2390),(213,'Soups',189),(214,'Tandoori',420),(215,'main course',3550),(216,'staters',850),(217,'Currys',299),(218,'None',2480),(219,'Soups',189),(220,'Tandoori',480),(221,'main course',4670),(222,'staters',1240),(229,'Currys',299),(230,'None',2610),(231,'Soups',189),(232,'Tandoori',700),(233,'main course',5180),(234,'staters',1240),(235,'Currys',299),(236,'None',2610),(237,'Soups',189),(238,'Tandoori',700),(239,'main course',5330),(240,'staters',1240),(247,'Currys',299),(248,'None',2610),(249,'Soups',189),(250,'Tandoori',700),(251,'main course',5330),(252,'staters',1240),(260,'Currys',2847),(261,'None',18510),(262,'Soups',189),(263,'Tandoori',3135),(264,'main course',16490),(265,'staters',2589),(266,'main course',150),(270,'Currys',140),(271,'Tandoori',80),(272,'main course',150),(273,'Currys',419),(274,'None',130),(275,'Tandoori',240),(276,'main course',1290),(277,'staters',260),(278,'Currys',599),(279,'None',1625),(280,'Tandoori',320),(281,'main course',2190),(282,'staters',260),(283,'Currys',599),(284,'None',1725),(285,'Tandoori',570),(286,'main course',2490),(287,'staters',260),(288,'Currys',599),(289,'None',2255),(290,'Soups',320),(291,'Tandoori',660),(292,'main course',4210),(293,'staters',390),(294,'Currys',599),(295,'None',2505),(296,'Soups',320),(297,'Tandoori',780),(298,'main course',4810),(299,'staters',630),(300,'Currys',599),(301,'None',2505),(302,'Soups',320),(303,'Tandoori',1030),(304,'main course',4990),(305,'staters',630),(306,'Currys',599),(307,'None',2505),(308,'Soups',320),(309,'Tandoori',1030),(310,'main course',4990),(311,'staters',630),(312,'Currys',240),(313,'None',1430),(314,'Tandoori',60),(315,'main course',870),(316,'Currys',240),(317,'None',2185),(318,'Tandoori',60),(319,'main course',2330),(320,'Currys',240),(321,'None',2385),(322,'Tandoori',80),(323,'main course',2330),(324,'Currys',660),(325,'None',3965),(326,'Tandoori',350),(327,'main course',3080),(328,'staters',260),(329,'Currys',660),(330,'None',4175),(331,'Tandoori',390),(332,'main course',3470),(333,'staters',440),(334,'Currys',660),(335,'None',4175),(336,'Tandoori',390),(337,'main course',3470),(338,'staters',440),(354,'Currys',660),(355,'None',4175),(356,'Tandoori',390),(357,'main course',4070),(358,'staters',718),(364,'Currys',660),(365,'None',4175),(366,'Tandoori',390),(367,'main course',4070),(368,'staters',718),(380,'Currys',1030),(381,'None',6310),(382,'Tandoori',1800),(383,'main course',5740),(384,'staters',718),(385,'None',1010),(386,'Tandoori',40),(387,'main course',840),(388,'staters',278),(389,'None',1380),(390,'Tandoori',80),(391,'main course',990),(392,'staters',278),(393,'None',1570),(394,'Tandoori',80),(395,'main course',1440),(396,'staters',278),(401,'None',2330),(402,'Tandoori',180),(403,'main course',1720),(404,'staters',278),(405,'None',2330),(406,'Tandoori',180),(407,'main course',1870),(408,'staters',278),(409,'None',2500),(410,'Tandoori',200),(411,'main course',2170),(412,'staters',458),(417,'Currys',1030),(418,'None',6310),(419,'Tandoori',1800),(420,'main course',5740),(421,'staters',718),(422,'Currys',348),(423,'None',2620),(424,'Tandoori',400),(425,'main course',2320),(426,'staters',458),(427,'Currys',348),(428,'None',2620),(429,'Tandoori',400),(430,'main course',2470),(431,'staters',458),(432,'Currys',528),(433,'None',2630),(434,'Tandoori',440),(435,'main course',2470),(436,'staters',458),(442,'None',1745),(443,'Tandoori',30),(444,'main course',3680),(445,'None',1835),(446,'Tandoori',30),(447,'main course',3680),(448,'Currys',250),(449,'None',1855),(450,'Tandoori',90),(451,'main course',3830),(452,'Currys',430),(453,'None',1925),(454,'Tandoori',90),(455,'main course',3830),(456,'staters',120),(462,'Currys',430),(463,'None',1965),(464,'Tandoori',140),(465,'main course',5240),(466,'staters',120),(467,'Currys',920),(468,'None',2845),(469,'Tandoori',420),(470,'main course',6690),(471,'staters',120),(472,'Currys',920),(473,'None',2845),(474,'Tandoori',420),(475,'main course',6690),(476,'staters',120),(477,'Currys',920),(478,'None',2845),(479,'Tandoori',420),(480,'main course',6690),(481,'staters',120),(482,'None',1295),(483,'Tandoori',50),(484,'main course',960),(485,'staters',210),(486,'None',1635),(487,'Tandoori',70),(488,'main course',1550),(489,'staters',359),(490,'None',1930),(491,'Tandoori',110),(492,'main course',1970),(493,'staters',359),(494,'None',1940),(495,'Tandoori',110),(496,'main course',2150),(497,'staters',359),(498,'None',2460),(499,'Tandoori',150),(500,'main course',2960),(501,'staters',359),(502,'Currys',180),(503,'None',2460),(504,'Tandoori',240),(505,'main course',2960),(506,'staters',359),(507,'Currys',360),(508,'None',2660),(509,'Tandoori',280),(510,'main course',3700),(511,'staters',639),(512,'Currys',540),(513,'None',2860),(514,'Tandoori',530),(515,'main course',3700),(516,'staters',639),(517,'Currys',540),(518,'None',2885),(519,'Tandoori',630),(520,'main course',3850),(521,'staters',639),(522,'Currys',540),(523,'None',2885),(524,'Tandoori',630),(525,'main course',3850),(526,'staters',639),(529,'Tandoori',200),(530,'main course',150),(531,'Currys',580),(532,'None',150),(533,'Tandoori',360),(534,'main course',300),(535,'staters',490),(536,'Currys',580),(537,'None',560),(538,'Tandoori',360),(539,'main course',980),(540,'staters',490),(541,'Currys',580),(542,'None',760),(543,'Tandoori',380),(544,'main course',1100),(545,'staters',490),(546,'Currys',580),(547,'None',950),(548,'Tandoori',400),(549,'main course',1400),(550,'staters',700),(551,'Currys',760),(552,'None',1120),(553,'Tandoori',440),(554,'main course',4250),(555,'staters',910),(566,'Currys',760),(567,'None',1300),(568,'Tandoori',440),(569,'main course',4430),(570,'staters',960),(571,'Currys',760),(572,'None',1300),(573,'Tandoori',440),(574,'main course',4430),(575,'staters',960),(576,'Currys',760),(577,'None',1300),(578,'Tandoori',440),(579,'main course',4430),(580,'staters',960),(581,'Currys',910),(582,'None',1985),(583,'Tandoori',670),(584,'main course',5770),(585,'staters',1510),(586,'Currys',910),(587,'None',1985),(588,'Tandoori',670),(589,'main course',5770),(590,'staters',1510),(596,'Currys',1160),(597,'None',1405),(598,'Tandoori',450),(599,'main course',4500),(600,'staters',379),(601,'Currys',1300),(602,'None',1405),(603,'Tandoori',500),(604,'main course',4500),(605,'staters',528),(611,'Currys',1600),(612,'None',1655),(613,'Tandoori',850),(614,'main course',4860),(615,'staters',648),(616,'Currys',529),(617,'None',1020),(618,'Tandoori',760),(619,'main course',1790),(620,'Currys',529),(621,'None',1530),(622,'Tandoori',780),(623,'main course',1790),(624,'staters',140),(625,'Currys',1009),(626,'None',2300),(627,'Tandoori',930),(628,'main course',3730),(629,'staters',530),(630,'staters',130),(631,'staters',130),(632,'None',280),(633,'main course',1650),(634,'staters',130),(635,'None',880),(636,'Tandoori',50),(637,'main course',3150),(638,'staters',520),(639,'None',2170),(640,'Tandoori',70),(641,'main course',4270),(642,'staters',650),(643,'None',2765),(644,'Soups',90),(645,'Tandoori',130),(646,'main course',6060),(647,'staters',650),(648,'Currys',770),(649,'None',3685),(650,'Soups',90),(651,'Tandoori',515),(652,'main course',9390),(653,'staters',650),(654,'Currys',770),(655,'None',3685),(656,'Soups',90),(657,'Tandoori',515),(658,'main course',9540),(659,'staters',650),(666,'Currys',910),(667,'None',1985),(668,'Tandoori',670),(669,'main course',5770),(670,'staters',1510),(671,'Currys',770),(672,'None',3685),(673,'Soups',90),(674,'Tandoori',515),(675,'main course',9540),(676,'staters',650),(677,'Currys',770),(678,'None',3685),(679,'Soups',90),(680,'Tandoori',515),(681,'main course',9540),(682,'staters',650),(689,'Currys',770),(690,'None',3685),(691,'Soups',90),(692,'Tandoori',515),(693,'main course',10590),(694,'staters',650);
INSERT INTO `userdata` (`_id`, `username`, `total`) VALUES (1,'admin',1055);
INSERT INTO `userwiseorderlistitems` (`_id`, `username`, `sales`, `salespercentage`) VALUES (1,'madmin',1055,100);
