INSERT INTO `all_sales_cancelled` (`_id`, `itemname`, `quantity`, `price`, `total`, `type`, `parent`, `parentid`, `mod_assigned`, `tax`, `taxname`, `bill_no`, `time`, `date`, `user`, `billtype`, `paymentmethod`, `billamount_disapply`, `billamount_disnotapply`, `_idd`, `reason`, `billamount_cancelled`, `date1`, `billamount_cancelled_user`, `disc_type`, `disc_value`, `newtotal`, `disc_thereornot`, `disc_indiv_total`, `datetimee_new`, `taxname2`, `tax2`, `taxname3`, `tax3`, `taxname4`, `tax4`, `taxname5`, `tax5`, `hsn_code`, `old_total`, `old_total_indiv`) VALUES (1,'idly','1.0','29.25','29.25','Item',NULL,NULL,'no','17.00','Demo(17%)','20240703-1-000011','10:59:18 am','2024 07 03','admin','  Dine-in','  Cash','99.62','109.81999','23','Delayed','99.62','03 Jul 2024','99.62','%','2','28.67','yes','0.58','202407031059',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','25.00','25.00'),(2,'dosa','1.0','40.95','40.95','Item',NULL,NULL,'no','17.00','Demo(17%)','20240703-1-000011','10:59:18 am','2024 07 03','admin','  Dine-in','  Cash','99.62','109.81999','24','Delayed','99.62','03 Jul 2024','99.62','%','0','40.95','no','','202407031059',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','35.00','35.00'),(3,'pongal','1.0','30.00','30.00','Item',NULL,NULL,'no',NULL,NULL,'20240703-1-000011','10:59:18 am','2024 07 03','admin','  Dine-in','  Cash','99.62','109.81999','25','Delayed','99.62','03 Jul 2024','99.62','%','0','30.00','no','','202407031059',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','30.00','30.00'),(4,'idly','1.0','29.25','29.25','Item',NULL,NULL,'no','17.00','Demo(17%)','20240703-1-000012','11:01:43 am','2024 07 03','admin','  Dine-in','  Cash','99.62','109.81999','26','Damaged/Spoiled','28.67','03 Jul 2024','28.67','%','2','28.67','yes','0.58','202407031101',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','25.00','25.00'),(5,'poori','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20240701-1-000012','09:16:39 am','2024 07 05','admin','  Dine-in','  Card','488.67','492.92','5','Changed mind','488.67','05 Jul 2024','488.67','%','0','35.00','no','0.00','202407050916',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','35.00','35.00'),(6,'pongal','1.0','30.00','30.00','Item',NULL,NULL,'no',NULL,NULL,'20240701-1-000012','09:16:39 am','2024 07 05','admin','  Dine-in','  Card','488.67','492.92','6','Changed mind','488.67','05 Jul 2024','488.67','%','0','30.00','no','0.00','202407050916',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','30.00','30.00'),(7,'chicken biriyani','1.0','100.00','100.00','Item',NULL,NULL,'no',NULL,NULL,'20240701-1-000012','09:16:39 am','2024 07 05','admin','  Dine-in','  Card','488.67','492.92','7','Changed mind','488.67','05 Jul 2024','488.67','%','0','100.00','no','0.00','202407050916',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','100.00','100.00'),(8,'rice','1.0','30.00','30.00','Item',NULL,NULL,'no',NULL,NULL,'20240701-1-000012','09:16:39 am','2024 07 05','admin','  Dine-in','  Card','488.67','492.92','8','Changed mind','488.67','05 Jul 2024','488.67','%','0','30.00','no','0.00','202407050916',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','30.00','30.00'),(9,'veg biriyani','1.0','70.00','70.00','Item',NULL,NULL,'no',NULL,NULL,'20240701-1-000012','09:16:39 am','2024 07 05','admin','  Dine-in','  Card','488.67','492.92','9','Changed mind','488.67','05 Jul 2024','488.67','%','0','70.00','no','0.00','202407050916',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','70.00','70.00'),(10,'poori','3.0','35.00','105.0','Item',NULL,NULL,'no',NULL,NULL,'20240723-1-000011','05:02:48 pm','2024 07 23','admin','  Dine-in','  Cash','474.20','478.40002','2','Damaged/Spoiled','105.00','23 Jul 2024','105.00','%','0','105.00','no','','202407231702',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','105.00','35.00'),(11,'idly','6.0','28.00','168.0','Item',NULL,NULL,'no','12.00','Demo(12%)','20240723-1-000012','05:03:41 pm','2024 07 23','admin','  Dine-in','  Cash','164.64','182.64','9','Damaged/Spoiled','164.64','23 Jul 2024','164.64','%','2','164.64','yes','3.36','202407231703',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','150.00','25.00'),(12,'vada','1.0','20.00','20.0','Item',NULL,NULL,'no',NULL,NULL,'20240725-1-000011','07:08:46 am','2024 07 25','admin','  Dine-in','  Cash','315.00','315.0','2','Damaged/Spoiled','20.00','25 Jul 2024','20.00','%','0','20.00','no','','202407250708',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','20.00','20.00'),(13,'masal dosa','3.0','40.00','120.00','Item',NULL,NULL,'no',NULL,NULL,'20240725-1-000011','07:09:40 am','2024 07 25','admin','  Dine-in','  Cash','295.00','295.0','1','Accidental charge','315.0','25 Jul 2024','295.00','%','0','120.00','no','','202407250709',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','120.00','40.00'),(14,'pani puri','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20240725-1-000011','07:09:40 am','2024 07 25','admin','  Dine-in','  Cash','295.00','295.0','3','Accidental charge','315.0','25 Jul 2024','295.00','%','0','35.00','no','','202407250709',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','35.00','35.00'),(15,'pav bhajji','1.0','60.00','60.00','Item',NULL,NULL,'no',NULL,NULL,'20240725-1-000011','07:09:40 am','2024 07 25','admin','  Dine-in','  Cash','295.00','295.0','4','Accidental charge','315.0','25 Jul 2024','295.00','%','0','60.00','no','','202407250709',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','60.00','60.00'),(16,'non veg thali','1.0','80.00','80.00','Item',NULL,NULL,'no',NULL,NULL,'20240725-1-000011','07:09:40 am','2024 07 25','admin','  Dine-in','  Cash','295.00','295.0','5','Accidental charge','315.0','25 Jul 2024','295.00','%','0','80.00','no','','202407250709',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','80.00','80.00'),(17,'veg biriyani','1.0','70.00','70.0','Item',NULL,NULL,'no',NULL,NULL,'20240725-1-000012','07:14:46 am','2024 07 25','admin','  Dine-in','  Cash','200.00','200.0','9','Damaged/Spoiled','70.00','25 Jul 2024','70.00','%','0','70.00','no','','202407250714',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','70.00','70.00'),(18,'pani puri','1.0','35.00','35.0','Item',NULL,NULL,'no',NULL,NULL,'20240725-1-000012','07:15:48 am','2024 07 25','admin','  Dine-in','  Cash','130.00','130.0','8','Accidental charge','120.0','25 Jul 2024','50.00','%','0','35.00','no','','202407250715',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','35.00','35.00'),(19,'roti','1.0','15.00','15.0','Item',NULL,NULL,'no',NULL,NULL,'20240725-1-000012','07:15:48 am','2024 07 25','admin','  Dine-in','  Cash','130.00','130.0','10','Accidental charge','120.0','25 Jul 2024','50.00','%','0','15.00','no','','202407250715',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','15.00','15.00'),(20,'masal dosa','1.0','40.00','40.00','Item',NULL,NULL,'no',NULL,NULL,'20240725-1-000012','07:16:55 am','2024 07 25','admin','  Dine-in','  Cash','80.00','80.0','6','Accidental charge','200.0','25 Jul 2024','80.00','%','0','40.00','no','','202407250716',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','40.00','40.00'),(21,'vada','2.0','20.00','40.00','Item',NULL,NULL,'no',NULL,NULL,'20240725-1-000012','07:16:55 am','2024 07 25','admin','  Dine-in','  Cash','80.00','80.0','7','Accidental charge','200.0','25 Jul 2024','80.00','%','0','40.00','no','','202407250716',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','40.00','20.00');
INSERT INTO `billcount` (`_id`, `value`) VALUES (1,'0');
INSERT INTO `billnumber` (`_id`, `billnumber`, `total`, `user`, `date`, `paymentmethod`, `billtype`, `subtotal`, `taxtotal`, `roundoff`, `globaltaxtotal`, `billcount`, `datetimee_new`, `comments_sales`, `delivery_fee`, `packing_charges`, `loyalty_points`, `loyalty_amount`, `order_id`) VALUES (1148,'20240604-1-000021','721.82','admin','2024 06 04','  Pay Later','  Dine-in','656.20','66.82','0.00','10.0','1145','202406041706',NULL,NULL,NULL,NULL,NULL,NULL),(1149,'20240604-1-000022','566.50','admin','2024 06 04','  Card','  Takeaway','515.00','51.50','0.00','10.0','1146','202406041708',NULL,NULL,NULL,NULL,NULL,NULL),(1150,'20240604-1-000023','672.54','admin','2024 06 04','  Cash','  Home delivery','611.40','62.54','0.00','10.0','1147','202406041709',NULL,NULL,NULL,NULL,NULL,NULL),(1151,'20240604-1-000024','556.05','admin','2024 06 04','  Upiqr','  Home delivery','505.50','51.05','0.00','10.0','1148','202406041728',NULL,NULL,NULL,NULL,NULL,NULL),(1152,'20240604-1-000025','665.50','admin','2024 06 04','  Card','  Takeaway','605.00','60.50','0.00','10.0','1149','202406041730',NULL,NULL,NULL,NULL,NULL,NULL),(1153,'20240604-1-000011','649.00','admin','2024 06 04','  Upiqr','  Home delivery','590.00','59.00','0.00','10.0','1150','202406041731',NULL,NULL,NULL,NULL,NULL,NULL),(1154,'20240604-1-000031','627.55','admin','2024 06 04','  Card','  Dine-in','570.50','57.55','0.00','10.0','1151','202406041732',NULL,NULL,NULL,NULL,NULL,NULL),(1155,'20240604-1-000032','628.32','admin','2024 06 04','  Cheque','  Takeaway','571.20','58.32','0.00','10.0','1152','202406041733',NULL,NULL,NULL,NULL,NULL,NULL),(1156,'20240604-1-000026','770.77','admin','2024 06 04','  Sodexo','  Takeaway','700.70','70.77','0.00','10.0','1153','202406041735',NULL,NULL,NULL,NULL,NULL,NULL),(1157,'20240604-1-000027','667.59','admin','2024 06 04','  Cash','  Takeaway','606.90','62.59','0.00','10.0','1154','202406041746',NULL,NULL,NULL,NULL,NULL,NULL),(1158,'20240604-1-000033','572.55','admin','2024 06 04','  Card','  Home delivery','520.50','52.55','0.00','10.0','1155','202406041747',NULL,NULL,NULL,NULL,NULL,NULL),(1159,'20240604-1-000028','634.59','admin','2024 06 04','  Cash','  Home delivery','576.90','59.59','0.00','10.0','1156','202406041748',NULL,NULL,NULL,NULL,NULL,NULL),(1160,'20240604-1-000034','677.60','admin','2024 06 04','  Ticket','  Dine-in','616.00','62.60','0.00','10.0','1157','202406041750',NULL,NULL,NULL,NULL,NULL,NULL),(1161,'20240604-1-000012','783.09','admin','2024 06 04','  Upiqr','  Home delivery','711.90','73.09','0.00','10.0','1158','202406041751',NULL,NULL,NULL,NULL,NULL,NULL),(1162,'20240604-1-000029','776.82','admin','2024 06 04','  Cash','  Home delivery','706.20','71.82','0.00','10.0','1159','202406041802',NULL,NULL,NULL,NULL,NULL,NULL),(1163,'20240604-1-000035','660.77','admin','2024 06 04','  Cash','  Dine-in','600.70','60.77','0.00','10.0','1160','202406041811',NULL,NULL,NULL,NULL,NULL,NULL),(1164,'20240604-1-000013','649.00','admin','2024 06 04','  Upiqr','  Home delivery','590.00','59.00','0.00','10.0','1161','202406041812',NULL,NULL,NULL,NULL,NULL,NULL),(1165,'20240604-1-0000210','727.32','admin','2024 06 04','  Upiqr','  Dine-in','661.20','67.32','0.00','10.0','1162','202406041813',NULL,NULL,NULL,NULL,NULL,NULL),(1166,'20240606-1-000031','600.27','admin','2024 06 06','  Ticket','  Takeaway','545.70','55.27','0.00','10.0','1163','202406061709',NULL,NULL,NULL,NULL,NULL,NULL),(1167,'20240606-1-000021','689.04','admin','2024 06 06','  Pay Later','  Dine-in','626.40','64.04','0.00','10.0','1164','202406061710',NULL,NULL,NULL,NULL,NULL,NULL),(1168,'20240606-1-000011','666.82','admin','2024 06 06','  Upiqr','  Home delivery','606.20','61.82','0.00','10.0','1165','202406061711',NULL,NULL,NULL,NULL,NULL,NULL),(1169,'20240606-1-000032','864.27','admin','2024 06 06','  Ticket','  Home delivery','785.70','79.27','0.00','10.0','1166','202406061712',NULL,NULL,NULL,NULL,NULL,NULL),(1170,'20240606-1-000012','650.54','admin','2024 06 06','  Ticket','  Takeaway','591.40','60.54','0.00','10.0','1167','202406061713',NULL,NULL,NULL,NULL,NULL,NULL),(1171,'20240606-1-000013','688.27','admin','2024 06 06','  Pay Later','  Takeaway','625.70','63.27','0.00','10.0','1168','202406061715',NULL,NULL,NULL,NULL,NULL,NULL),(1172,'20240606-1-000014','518.32','admin','2024 06 06','  Cheque','  Dine-in','471.20','48.32','0.00','10.0','1169','202406061719',NULL,NULL,NULL,NULL,NULL,NULL),(1173,'20240606-1-000033','638.77','admin','2024 06 06','  Cash','  Dine-in','580.70','58.77','0.00','10.0','1170','202406061720',NULL,NULL,NULL,NULL,NULL,NULL),(1174,'20240606-1-000022','513.59','admin','2024 06 06','  Cheque','  Takeaway','466.90','48.59','0.00','10.0','1171','202406061721',NULL,NULL,NULL,NULL,NULL,NULL),(1175,'20240606-1-000023','704.00','admin','2024 06 06','  Sodexo','  Dine-in','640.00','64.00','0.00','10.0','1172','202406061722',NULL,NULL,NULL,NULL,NULL,NULL),(1176,'20240606-1-000034','765.82','admin','2024 06 06','  Cheque','  Home delivery','696.20','70.82','0.00','10.0','1173','202406061724',NULL,NULL,NULL,NULL,NULL,NULL),(1177,'20240606-1-000024','550.55','admin','2024 06 06','  Sodexo','  Dine-in','500.50','50.55','0.00','10.0','1174','202406061725',NULL,NULL,NULL,NULL,NULL,NULL),(1178,'20240606-1-000015','810.04','admin','2024 06 06','  Sodexo','  Dine-in','736.40','75.04','0.00','10.0','1175','202406061744',NULL,NULL,NULL,NULL,NULL,NULL),(1179,'20240606-1-000035','700.59','admin','2024 06 06','  Cheque','  Home delivery','636.90','65.59','0.00','10.0','1176','202406061746',NULL,NULL,NULL,NULL,NULL,NULL),(1180,'20240606-1-000016','667.04','admin','2024 06 06','  Sodexo','  Home delivery','606.40','62.04','0.00','10.0','1177','202406061747',NULL,NULL,NULL,NULL,NULL,NULL),(1181,'20240606-1-000036','638.00','admin','2024 06 06','  Upiqr','  Home delivery','580.00','58.00','0.00','10.0','1178','202406061748',NULL,NULL,NULL,NULL,NULL,NULL),(1182,'20240606-1-000017','617.10','admin','2024 06 06','  Card','  Takeaway','561.00','57.10','0.00','10.0','1179','202406061749',NULL,NULL,NULL,NULL,NULL,NULL),(1183,'20240610-1-000031','562.87','admin','2024 06 10','  Zeta','  Home delivery','511.70','52.87','0.00','10.0','1180','202406101551',NULL,NULL,NULL,NULL,NULL,NULL),(1184,'20240610-1-000021','737.00','admin','2024 06 10','  Pay Later','  Takeaway','670.00','67.00','0.00','10.0','1181','202406101605',NULL,NULL,NULL,NULL,NULL,NULL),(1185,'20240610-1-000022','699.82','admin','2024 06 10','  Cash','  Home delivery','636.20','64.82','0.00','10.0','1182','202406101606',NULL,NULL,NULL,NULL,NULL,NULL),(1186,'20240610-1-000032','726.00','admin','2024 06 10','  Cash','  Takeaway','660.00','66.00','0.00','10.0','1183','202406101607',NULL,NULL,NULL,NULL,NULL,NULL),(1187,'20240610-1-000023','540.32','admin','2024 06 10','  Cheque','  Dine-in','491.20','50.32','0.00','10.0','1184','202406101608',NULL,NULL,NULL,NULL,NULL,NULL),(1188,'20240627-1-000021','240.00','madmin','2024 06 27','  card','  Takeaway','240.000000','0.000000','0.000000','0','1185','20240627130006','','','','0','0',NULL),(1189,'20240627-1-000022','30.00','madmin','2024 06 27','  Pay Later','  Dine-in','30.000000','0.000000','0.000000','0','1186','20240627130007','','','','0','0',NULL),(1190,'20240627-1-000022','30.00','madmin','2024 06 27','  Pay Later','  Dine-in','30.000000','0.000000','0.000000','0','1186','20240627130007','','','','0','0',NULL),(1191,'20240627-1-000022','30.00','madmin','2024 06 27','  Pay Later','  Dine-in','30.000000','0.000000','0.000000','0','1186','20240627130007','','','','0','0',NULL),(1192,'20240627-1-000022','30.00','madmin','2024 06 27','  Pay Later','  Dine-in','30.000000','0.000000','0.000000','0','1186','20240627130007','','','','0','0',NULL),(1193,'20240701-1-000011','58','madmin','2024 07 01','  cash','  Dine-in','49.000000','8.500000','0.000000','0','1187','202407010952','','','','0','0',NULL),(1194,'20240701-1-000012','0','admin','2024 07 01','  Card','  Dine-in','0.0','0.0','0.0','0.0','1188','202407011630',NULL,NULL,NULL,NULL,NULL,NULL),(1195,'20240701-1-000013','188.67','admin','2024 07 01','  Pay Later','  Home delivery','188.67','4.25','0.00','0.0','1189','202407011637',NULL,NULL,NULL,NULL,NULL,NULL),(1196,'20240701-1-000021','198.28','admin','2024 07 01','  Card','  Dine-in','198.28','14.45','0.00','0.0','1190','202407011638',NULL,NULL,NULL,NULL,NULL,NULL),(1197,'20240703-1-000011','0','admin','2024 07 03','  Cash','  Dine-in','0.0','0.0','0.0','0.0','1191','202407031052',NULL,NULL,NULL,NULL,NULL,NULL),(1198,'20240703-1-000012','70.95','admin','2024 07 03','  Cash','  Dine-in','70.95','5.95','0.0','0.0','1192','202407031100',NULL,NULL,NULL,NULL,NULL,NULL),(1199,'20240703-1-000013','70.95','admin','2024 07 03','  Card','  Dine-in','70.95','5.95','0.00','0.0','1193','202407031549',NULL,NULL,NULL,NULL,NULL,NULL),(1200,'20240705-1-000011','139.62','admin','2024 07 05','  Cash','  Dine-in','139.62','10.20','0.00','0.0','1194','202407051233',NULL,NULL,NULL,NULL,NULL,NULL),(1201,'20240705-1-000012','194.62','admin','2024 07 05','  Card','  Home delivery','194.62','10.20','0.00','0.0','1195','202407051235',NULL,NULL,NULL,NULL,NULL,NULL),(1202,'20240705-1-000031','200.95','admin','2024 07 05','  Pay Later','  Dine-in','200.95','5.95','0.00','0.0','1196','202407051236',NULL,NULL,NULL,NULL,NULL,NULL),(1203,'20240705-1-000021','206.90','admin','2024 07 05','  Pay Later','  Takeaway','206.90','11.90','0.00','0.0','1197','202407051237',NULL,NULL,NULL,NULL,NULL,NULL),(1204,'20240705-1-000022','180.00','admin','2024 07 05','  Sodexo','  Dine-in','180.00','0.00','0.00','0.0','1198','202407051237',NULL,NULL,NULL,NULL,NULL,NULL),(1205,'20240705-1-000032','204.62','admin','2024 07 05','  Sodexo','  Home delivery','204.62','10.20','0.00','0.0','1199','202407051238',NULL,NULL,NULL,NULL,NULL,NULL),(1206,'20240705-1-000033','170.95','admin','2024 07 05','  Ticket','  Dine-in','170.95','5.95','0.00','0.0','1200','202407051238',NULL,NULL,NULL,NULL,NULL,NULL),(1207,'20240705-1-000023','205.95','admin','2024 07 05','  Cash','  Takeaway','205.95','5.95','0.00','0.0','1201','202407051239',NULL,NULL,NULL,NULL,NULL,NULL),(1208,'20240705-1-000013','215.95','admin','2024 07 05','  Pay Later','  Home delivery','215.95','5.95','0.00','0.0','1202','202407051240',NULL,NULL,NULL,NULL,NULL,NULL),(1209,'20240705-1-000014','190.00','admin','2024 07 05','  Upiqr','  Home delivery','190.00','0.00','0.00','0.0','1203','202407051240',NULL,NULL,NULL,NULL,NULL,NULL),(1210,'20240705-1-000024','207.85','admin','2024 07 05','  Cash','  Home delivery','207.85','17.85','0.00','0.0','1204','202407051241',NULL,NULL,NULL,NULL,NULL,NULL),(1211,'20240705-1-000034','190.95','admin','2024 07 05','  Card','  Takeaway','190.95','5.95','0.00','0.0','1205','202407051241',NULL,NULL,NULL,NULL,NULL,NULL),(1212,'20240705-1-000025','163.67','admin','2024 07 05','  Cash','  Home delivery','163.67','4.25','0.00','0.0','1206','202407051242',NULL,NULL,NULL,NULL,NULL,NULL),(1213,'20240705-1-000035','215.57','admin','2024 07 05','  Card','  Dine-in','215.57','16.15','0.00','0.0','1207','202407051242',NULL,NULL,NULL,NULL,NULL,NULL),(1214,'20240705-1-000015','190.00','admin','2024 07 05','  Upiqr','  Home delivery','190.00','0.00','0.00','0.0','1208','202407051243',NULL,NULL,NULL,NULL,NULL,NULL),(1215,'20240705-1-000016','179.62','admin','2024 07 05','  Cash','  Home delivery','179.62','10.20','0.00','0.0','1209','202407051243',NULL,NULL,NULL,NULL,NULL,NULL),(1216,'20240705-1-000026','203.67','admin','2024 07 05','  Pay Later','  Takeaway','203.67','4.25','0.00','0.0','1210','202407051244',NULL,NULL,NULL,NULL,NULL,NULL),(1217,'20240705-1-000027','173.67','admin','2024 07 05','  Cash','  Home delivery','173.67','4.25','0.00','0.0','1211','202407051245',NULL,NULL,NULL,NULL,NULL,NULL),(1218,'20240705-1-000028','193.28','admin','2024 07 05','  Zeta','  Home delivery','193.28','14.45','0.00','0.0','1212','202407051245',NULL,NULL,NULL,NULL,NULL,NULL),(1219,'20240705-1-000036','189.62','admin','2024 07 05','  Card','  Dine-in','189.62','10.20','0.00','0.0','1213','202407051246',NULL,NULL,NULL,NULL,NULL,NULL),(1220,'20240705-1-000029','201.90','admin','2024 07 05','  Upiqr','  Dine-in','201.90','11.90','0.00','0.0','1214','202407051246',NULL,NULL,NULL,NULL,NULL,NULL),(1221,'20240705-1-000037','199.62','admin','2024 07 05','  Card','  Dine-in','199.62','10.20','0.00','0.0','1215','202407051247',NULL,NULL,NULL,NULL,NULL,NULL),(1222,'20240705-1-000017','180.00','admin','2024 07 05','  Card','  Home delivery','180.00','0.00','0.00','0.0','1216','202407051247',NULL,NULL,NULL,NULL,NULL,NULL),(1223,'20240705-1-0000210','200.00','admin','2024 07 05','  Ticket','  Home delivery','200.00','0.00','0.00','0.0','1217','202407051248',NULL,NULL,NULL,NULL,NULL,NULL),(1224,'20240705-1-000018','185.95','admin','2024 07 05','  Cheque','  Home delivery','185.95','5.95','0.00','0.0','1218','202407051249',NULL,NULL,NULL,NULL,NULL,NULL),(1225,'20240705-1-000019','193.67','admin','2024 07 05','  Cheque','  Takeaway','193.67','4.25','0.00','0.0','1219','202407051249',NULL,NULL,NULL,NULL,NULL,NULL),(1226,'20240705-1-000038','195.00','admin','2024 07 05','  Cheque','  Dine-in','195.00','0.00','0.00','0.0','1220','202407051250',NULL,NULL,NULL,NULL,NULL,NULL),(1227,'20240705-1-000039','185.00','admin','2024 07 05','  Card','  Dine-in','185.00','0.00','0.00','0.0','1221','202407051250',NULL,NULL,NULL,NULL,NULL,NULL),(1228,'20240705-1-0000110','183.67','admin','2024 07 05','  Sodexo','  Takeaway','183.67','4.25','0.00','0.0','1222','202407051251',NULL,NULL,NULL,NULL,NULL,NULL),(1229,'20240705-1-0000310','205.00','admin','2024 07 05','  Cash','  Home delivery','205.00','0.00','0.00','0.0','1223','202407051251',NULL,NULL,NULL,NULL,NULL,NULL),(1230,'20240705-1-0000311','170.95','admin','2024 07 05','  Card','  Takeaway','170.95','5.95','0.00','0.0','1224','202407051252',NULL,NULL,NULL,NULL,NULL,NULL),(1231,'20240705-1-0000211','199.62','admin','2024 07 05','  Card','  Takeaway','199.62','10.20','0.00','0.0','1225','202407051253',NULL,NULL,NULL,NULL,NULL,NULL),(1232,'20240705-1-0000212','195.95','admin','2024 07 05','  Cash','  Home delivery','195.95','5.95','0.00','0.0','1226','202407051253',NULL,NULL,NULL,NULL,NULL,NULL),(1233,'20240705-1-0000111','195.00','admin','2024 07 05','  Card','  Home delivery','195.00','0.00','0.00','0.0','1227','202407051254',NULL,NULL,NULL,NULL,NULL,NULL),(1234,'20240705-1-0000213','190.95','admin','2024 07 05','  Cash','  Dine-in','190.95','5.95','0.00','0.0','1228','202407051254',NULL,NULL,NULL,NULL,NULL,NULL),(1235,'20240705-1-0000112','183.67','admin','2024 07 05','  Pay Later','  Takeaway','183.67','4.25','0.00','0.0','1229','202407051255',NULL,NULL,NULL,NULL,NULL,NULL),(1236,'20240705-1-0000214','180.00','admin','2024 07 05','  Upiqr','  Takeaway','180.00','0.00','0.00','0.0','1230','202407051255',NULL,NULL,NULL,NULL,NULL,NULL),(1237,'20240705-1-0000215','221.90','admin','2024 07 05','  Cheque','  Home delivery','221.90','11.90','0.00','0.0','1231','202407051256',NULL,NULL,NULL,NULL,NULL,NULL),(1238,'20240705-1-0000216','211.90','admin','2024 07 05','  Pay Later','  Home delivery','211.90','11.90','0.00','0.0','1232','202407051257',NULL,NULL,NULL,NULL,NULL,NULL),(1239,'20240705-1-0000113','210.57','admin','2024 07 05','  Card','  Home delivery','210.57','16.15','0.00','0.0','1233','202407051257',NULL,NULL,NULL,NULL,NULL,NULL),(1240,'20240705-1-0000217','178.67','admin','2024 07 05','  Cash','  Home delivery','178.67','4.25','0.00','0.0','1234','202407051258',NULL,NULL,NULL,NULL,NULL,NULL),(1241,'20240705-1-0000114','188.67','admin','2024 07 05','  Upiqr','  Home delivery','188.67','4.25','0.00','0.0','1235','202407051258',NULL,NULL,NULL,NULL,NULL,NULL),(1242,'20240705-1-0000115','180.00','admin','2024 07 05','  Cheque','  Takeaway','180.00','0.00','0.00','0.0','1236','202407051259',NULL,NULL,NULL,NULL,NULL,NULL),(1243,'20240705-1-0000218','210.95','admin','2024 07 05','  Card','  Dine-in','210.95','5.95','0.00','0.0','1237','202407051259',NULL,NULL,NULL,NULL,NULL,NULL),(1244,'20240705-1-0000312','190.00','admin','2024 07 05','  Zeta','  Dine-in','190.00','0.00','0.00','0.0','1238','202407051300',NULL,NULL,NULL,NULL,NULL,NULL),(1245,'20240705-1-0000313','211.90','admin','2024 07 05','  Sodexo','  Takeaway','211.90','11.90','0.00','0.0','1239','202407051300',NULL,NULL,NULL,NULL,NULL,NULL),(1246,'20240705-1-0000116','188.67','admin','2024 07 05','  Upiqr','  Takeaway','188.67','4.25','0.00','0.0','1240','202407051301',NULL,NULL,NULL,NULL,NULL,NULL),(1247,'20240705-1-0000117','188.67','admin','2024 07 05','  Cheque','  Takeaway','188.67','4.25','0.00','0.0','1241','202407051301',NULL,NULL,NULL,NULL,NULL,NULL),(1248,'20240705-1-0000219','190.00','admin','2024 07 05','  Cash','  Takeaway','190.00','0.00','0.00','0.0','1242','202407051302',NULL,NULL,NULL,NULL,NULL,NULL),(1249,'20240705-1-0000314','215.57','admin','2024 07 05','  Pay Later','  Takeaway','215.57','16.15','0.00','0.0','1243','202407051303',NULL,NULL,NULL,NULL,NULL,NULL),(1250,'20240705-1-0000315','203.28','admin','2024 07 05','  Pay Later','  Home delivery','203.28','14.45','0.00','0.0','1244','202407051303',NULL,NULL,NULL,NULL,NULL,NULL),(1251,'20240705-1-0000316','192.33','admin','2024 07 05','  Cash','  Dine-in','192.33','8.50','0.00','0.0','1245','202407051304',NULL,NULL,NULL,NULL,NULL,NULL),(1252,'20240705-1-0000118','190.95','admin','2024 07 05','  Pay Later','  Home delivery','190.95','5.95','0.00','0.0','1246','202407051304',NULL,NULL,NULL,NULL,NULL,NULL),(1253,'20240705-1-0000119','204.62','admin','2024 07 05','  Card','  Home delivery','204.62','10.20','0.00','0.0','1247','202407051305',NULL,NULL,NULL,NULL,NULL,NULL),(1254,'20240705-1-0000120','195.95','admin','2024 07 05','  Card','  Dine-in','195.95','5.95','0.00','0.0','1248','202407051305',NULL,NULL,NULL,NULL,NULL,NULL),(1255,'20240705-1-0000317','200.00','admin','2024 07 05','  Pay Later','  Dine-in','200.00','0.00','0.00','0.0','1249','202407051306',NULL,NULL,NULL,NULL,NULL,NULL),(1256,'20240705-1-0000121','185.00','admin','2024 07 05','  Upiqr','  Home delivery','185.00','0.00','0.00','0.0','1250','202407051306',NULL,NULL,NULL,NULL,NULL,NULL),(1257,'20240705-1-0000220','200.95','admin','2024 07 05','  Pay Later','  Home delivery','200.95','5.95','0.00','0.0','1251','202407051307',NULL,NULL,NULL,NULL,NULL,NULL),(1258,'20240705-1-0000318','177.33','admin','2024 07 05','  Upiqr','  Dine-in','177.33','8.50','0.00','0.0','1252','202407051307',NULL,NULL,NULL,NULL,NULL,NULL),(1259,'20240705-1-0000221','176.00','admin','2024 07 05','  Upiqr','  Takeaway','176.00','12.75','0.00','0.0','1253','202407051308',NULL,NULL,NULL,NULL,NULL,NULL),(1260,'20240705-1-0000319','232.85','admin','2024 07 05','  Card','  Home delivery','232.85','17.85','0.00','0.0','1254','202407051308',NULL,NULL,NULL,NULL,NULL,NULL),(1261,'20240705-1-0000222','194.62','admin','2024 07 05','  Cash','  Takeaway','194.62','10.20','0.00','0.0','1255','202407051309',NULL,NULL,NULL,NULL,NULL,NULL),(1262,'20240705-1-0000122','178.67','admin','2024 07 05','  Pay Later','  Home delivery','178.67','4.25','0.00','0.0','1256','202407051310',NULL,NULL,NULL,NULL,NULL,NULL),(1263,'20240705-1-0000223','204.62','admin','2024 07 05','  Upiqr','  Dine-in','204.62','10.20','0.00','0.0','1257','202407051310',NULL,NULL,NULL,NULL,NULL,NULL),(1264,'20240705-1-0000123','199.62','admin','2024 07 05','  Upiqr','  Dine-in','199.62','10.20','0.00','0.0','1258','202407051310',NULL,NULL,NULL,NULL,NULL,NULL),(1265,'20240705-1-0000224','185.00','admin','2024 07 05','  Cheque','  Home delivery','185.00','0.00','0.00','0.0','1259','202407051311',NULL,NULL,NULL,NULL,NULL,NULL),(1266,'20240705-1-0000124','211.52','admin','2024 07 05','  Card','  Takeaway','211.52','22.10','0.00','0.0','1260','202407051312',NULL,NULL,NULL,NULL,NULL,NULL),(1267,'20240705-1-0000320','180.57','admin','2024 07 05','  Card','  Home delivery','180.57','16.15','0.00','0.0','1261','202407051312',NULL,NULL,NULL,NULL,NULL,NULL),(1268,'20240705-1-0000321','227.85','admin','2024 07 05','  Pay Later','  Dine-in','227.85','17.85','0.00','0.0','1262','202407051313',NULL,NULL,NULL,NULL,NULL,NULL),(1269,'20240705-1-0000225','175.00','admin','2024 07 05','  Cash','  Dine-in','175.00','0.00','0.00','0.0','1263','202407051313',NULL,NULL,NULL,NULL,NULL,NULL),(1270,'20240705-1-0000125','195.95','admin','2024 07 05','  Upiqr','  Dine-in','195.95','5.95','0.00','0.0','1264','202407051314',NULL,NULL,NULL,NULL,NULL,NULL),(1271,'20240705-1-0000322','181.90','admin','2024 07 05','  Ticket','  Takeaway','181.90','11.90','0.00','0.0','1265','202407051314',NULL,NULL,NULL,NULL,NULL,NULL),(1272,'20240705-1-0000126','170.00','admin','2024 07 05','  Upiqr','  Takeaway','170.00','0.00','0.00','0.0','1266','202407051315',NULL,NULL,NULL,NULL,NULL,NULL),(1273,'20240705-1-0000226','190.95','admin','2024 07 05','  Ticket','  Home delivery','190.95','5.95','0.00','0.0','1267','202407051315',NULL,NULL,NULL,NULL,NULL,NULL),(1274,'20240705-1-0000127','193.67','admin','2024 07 05','  Pay Later','  Dine-in','193.67','4.25','0.00','0.0','1268','202407051316',NULL,NULL,NULL,NULL,NULL,NULL),(1275,'20240705-1-0000227','205.00','admin','2024 07 05','  Upiqr','  Home delivery','205.00','0.00','0.00','0.0','1269','202407051316',NULL,NULL,NULL,NULL,NULL,NULL),(1276,'20240705-1-0000323','205.95','admin','2024 07 05','  Cheque','  Takeaway','205.95','5.95','0.00','0.0','1270','202407051317',NULL,NULL,NULL,NULL,NULL,NULL),(1277,'20240705-1-0000128','205.95','admin','2024 07 05','  Upiqr','  Home delivery','205.95','5.95','0.00','0.0','1271','202407051317',NULL,NULL,NULL,NULL,NULL,NULL),(1278,'20240705-1-0000228','169.62','admin','2024 07 05','  Upiqr','  Dine-in','169.62','10.20','0.00','0.0','1272','202407051318',NULL,NULL,NULL,NULL,NULL,NULL),(1279,'20240705-1-0000229','205.95','admin','2024 07 05','  Card','  Home delivery','205.95','5.95','0.00','0.0','1273','202407051318',NULL,NULL,NULL,NULL,NULL,NULL),(1280,'20240705-1-0000230','209.62','admin','2024 07 05','  Zeta','  Home delivery','209.62','10.20','0.00','0.0','1274','202407051319',NULL,NULL,NULL,NULL,NULL,NULL),(1281,'20240705-1-0000129','200.00','admin','2024 07 05','  Card','  Dine-in','200.00','0.00','0.00','0.0','1275','202407051320',NULL,NULL,NULL,NULL,NULL,NULL),(1282,'20240705-1-0000231','168.67','admin','2024 07 05','  Pay Later','  Home delivery','168.67','4.25','0.00','0.0','1276','202407051320',NULL,NULL,NULL,NULL,NULL,NULL),(1283,'20240705-1-0000232','203.67','admin','2024 07 05','  Cheque','  Dine-in','203.67','4.25','0.00','0.0','1277','202407051321',NULL,NULL,NULL,NULL,NULL,NULL),(1284,'20240705-1-0000324','198.67','admin','2024 07 05','  Cheque','  Takeaway','198.67','4.25','0.00','0.0','1278','202407051321',NULL,NULL,NULL,NULL,NULL,NULL),(1285,'20240705-1-0000233','205.00','admin','2024 07 05','  Cheque','  Takeaway','205.00','0.00','0.00','0.0','1279','202407051322',NULL,NULL,NULL,NULL,NULL,NULL),(1286,'20240705-1-0000325','200.95','admin','2024 07 05','  Zeta','  Dine-in','200.95','5.95','0.00','0.0','1280','202407051322',NULL,NULL,NULL,NULL,NULL,NULL),(1287,'20240705-1-0000130','188.67','admin','2024 07 05','  Pay Later','  Home delivery','188.67','4.25','0.00','0.0','1281','202407051323',NULL,NULL,NULL,NULL,NULL,NULL),(1288,'20240705-1-0000326','175.95','admin','2024 07 05','  Card','  Takeaway','175.95','5.95','0.00','0.0','1282','202407051324',NULL,NULL,NULL,NULL,NULL,NULL),(1289,'20240705-1-0000327','200.57','admin','2024 07 05','  Cheque','  Home delivery','200.57','16.15','0.00','0.0','1283','202407051324',NULL,NULL,NULL,NULL,NULL,NULL),(1290,'20240705-1-0000328','198.67','admin','2024 07 05','  Card','  Takeaway','198.67','4.25','0.00','0.0','1284','202407051325',NULL,NULL,NULL,NULL,NULL,NULL),(1291,'20240705-1-0000234','182.33','admin','2024 07 05','  Pay Later','  Takeaway','182.33','8.50','0.00','0.0','1285','202407051325',NULL,NULL,NULL,NULL,NULL,NULL),(1292,'20240705-1-0000131','201.52','admin','2024 07 05','  Cheque','  Home delivery','201.52','22.10','0.00','0.0','1286','202407051326',NULL,NULL,NULL,NULL,NULL,NULL),(1293,'20240705-1-0000235','190.95','admin','2024 07 05','  Pay Later','  Home delivery','190.95','5.95','0.00','0.0','1287','202407051327',NULL,NULL,NULL,NULL,NULL,NULL),(1294,'20240705-1-0000236','204.62','admin','2024 07 05','  Card','  Home delivery','204.62','10.20','0.00','0.0','1288','202407051327',NULL,NULL,NULL,NULL,NULL,NULL),(1295,'20240705-1-0000237','209.62','admin','2024 07 05','  Ticket','  Dine-in','209.62','10.20','0.00','0.0','1289','202407051328',NULL,NULL,NULL,NULL,NULL,NULL),(1296,'20240705-1-0000329','200.00','admin','2024 07 05','  Sodexo','  Home delivery','200.00','0.00','0.00','0.0','1290','202407051328',NULL,NULL,NULL,NULL,NULL,NULL),(1297,'20240705-1-0000238','192.33','admin','2024 07 05','  Upiqr','  Dine-in','192.33','8.50','0.00','0.0','1291','202407051329',NULL,NULL,NULL,NULL,NULL,NULL),(1298,'20240705-1-0000239','190.95','admin','2024 07 05','  Upiqr','  Takeaway','190.95','5.95','0.00','0.0','1292','202407051329',NULL,NULL,NULL,NULL,NULL,NULL),(1299,'20240705-1-0000132','195.57','admin','2024 07 05','  Cheque','  Dine-in','195.57','16.15','0.00','0.0','1293','202407051330',NULL,NULL,NULL,NULL,NULL,NULL),(1300,'20240705-1-0000240','205.57','admin','2024 07 05','  Pay Later','  Takeaway','205.57','16.15','0.00','0.0','1294','202407051330',NULL,NULL,NULL,NULL,NULL,NULL),(1301,'20240705-1-0000241','205.00','admin','2024 07 05','  Upiqr','  Dine-in','205.00','0.00','0.00','0.0','1295','202407051331',NULL,NULL,NULL,NULL,NULL,NULL),(1302,'20240705-1-0000133','200.00','admin','2024 07 05','  Cash','  Home delivery','200.00','0.00','0.00','0.0','1296','202407051331',NULL,NULL,NULL,NULL,NULL,NULL),(1303,'20240705-1-0000242','168.67','admin','2024 07 05','  Cheque','  Dine-in','168.67','4.25','0.00','0.0','1297','202407051332',NULL,NULL,NULL,NULL,NULL,NULL),(1304,'20240705-1-0000243','195.00','admin','2024 07 05','  Upiqr','  Dine-in','195.00','0.00','0.00','0.0','1298','202407051333',NULL,NULL,NULL,NULL,NULL,NULL),(1305,'20240705-1-0000330','220.57','admin','2024 07 05','  Pay Later','  Home delivery','220.57','16.15','0.00','0.0','1299','202407051333',NULL,NULL,NULL,NULL,NULL,NULL),(1306,'20240705-1-0000134','185.00','admin','2024 07 05','  Sodexo','  Home delivery','185.00','0.00','0.00','0.0','1300','202407051334',NULL,NULL,NULL,NULL,NULL,NULL),(1307,'20240705-1-0000244','216.90','admin','2024 07 05','  Sodexo','  Home delivery','216.90','11.90','0.00','0.0','1301','202407051334',NULL,NULL,NULL,NULL,NULL,NULL),(1308,'20240705-1-0000331','192.33','admin','2024 07 05','  Card','  Dine-in','192.33','8.50','0.00','0.0','1302','202407051335',NULL,NULL,NULL,NULL,NULL,NULL),(1309,'20240705-1-0000332','200.00','admin','2024 07 05','  Card','  Home delivery','200.00','0.00','0.00','0.0','1303','202407051335',NULL,NULL,NULL,NULL,NULL,NULL),(1310,'20240705-1-0000245','200.00','admin','2024 07 05','  Cash','  Takeaway','200.00','0.00','0.00','0.0','1304','202407051336',NULL,NULL,NULL,NULL,NULL,NULL),(1311,'20240705-1-0000333','200.95','admin','2024 07 05','  Card','  Dine-in','200.95','5.95','0.00','0.0','1305','202407051337',NULL,NULL,NULL,NULL,NULL,NULL),(1312,'20240705-1-0000246','166.00','admin','2024 07 05','  Upiqr','  Dine-in','166.00','12.75','0.00','0.0','1306','202407051337',NULL,NULL,NULL,NULL,NULL,NULL),(1313,'20240705-1-0000334','200.95','admin','2024 07 05','  Card','  Dine-in','200.95','5.95','0.00','0.0','1307','202407051338',NULL,NULL,NULL,NULL,NULL,NULL),(1314,'20240705-1-0000335','205.00','admin','2024 07 05','  Upiqr','  Takeaway','205.00','0.00','0.00','0.0','1308','202407051338',NULL,NULL,NULL,NULL,NULL,NULL),(1315,'20240705-1-0000247','197.33','admin','2024 07 05','  Pay Later','  Dine-in','197.33','8.50','0.00','0.0','1309','202407051339',NULL,NULL,NULL,NULL,NULL,NULL),(1316,'20240705-1-0000248','186.95','admin','2024 07 05','  Cheque','  Takeaway','186.95','18.70','0.00','0.0','1310','202407051339',NULL,NULL,NULL,NULL,NULL,NULL),(1317,'20240705-1-0000249','193.67','admin','2024 07 05','  Upiqr','  Home delivery','193.67','4.25','0.00','0.0','1311','202407051340',NULL,NULL,NULL,NULL,NULL,NULL),(1318,'20240705-1-0000336','205.95','admin','2024 07 05','  Upiqr','  Home delivery','205.95','5.95','0.00','0.0','1312','202407051340',NULL,NULL,NULL,NULL,NULL,NULL),(1319,'20240705-1-0000337','209.62','admin','2024 07 05','  Upiqr','  Home delivery','209.62','10.20','0.00','0.0','1313','202407051341',NULL,NULL,NULL,NULL,NULL,NULL),(1320,'20240705-1-0000338','193.28','admin','2024 07 05','  Card','  Takeaway','193.28','14.45','0.00','0.0','1314','202407051341',NULL,NULL,NULL,NULL,NULL,NULL),(1321,'20240705-1-0000250','185.00','admin','2024 07 05','  Cash','  Takeaway','185.00','0.00','0.00','0.0','1315','202407051342',NULL,NULL,NULL,NULL,NULL,NULL),(1322,'20240705-1-0000251','210.95','admin','2024 07 05','  Card','  Home delivery','210.95','5.95','0.00','0.0','1316','202407051342',NULL,NULL,NULL,NULL,NULL,NULL),(1323,'20240705-1-0000135','243.80','admin','2024 07 05','  Upiqr','  Takeaway','243.80','23.80','0.00','0.0','1317','202407051343',NULL,NULL,NULL,NULL,NULL,NULL),(1324,'20240705-1-0000252','177.33','admin','2024 07 05','  Upiqr','  Home delivery','177.33','8.50','0.00','0.0','1318','202407051343',NULL,NULL,NULL,NULL,NULL,NULL),(1325,'20240705-1-0000136','195.00','admin','2024 07 05','  Cheque','  Takeaway','195.00','0.00','0.00','0.0','1319','202407051344',NULL,NULL,NULL,NULL,NULL,NULL),(1326,'20240705-1-0000137','195.57','admin','2024 07 05','  Card','  Takeaway','195.57','16.15','0.00','0.0','1320','202407051345',NULL,NULL,NULL,NULL,NULL,NULL),(1327,'20240705-1-0000339','214.62','admin','2024 07 05','  Card','  Takeaway','214.62','10.20','0.00','0.0','1321','202407051345',NULL,NULL,NULL,NULL,NULL,NULL),(1328,'20240705-1-0000253','178.67','admin','2024 07 05','  Cheque','  Home delivery','178.67','4.25','0.00','0.0','1322','202407051346',NULL,NULL,NULL,NULL,NULL,NULL),(1329,'20240705-1-0000138','209.62','admin','2024 07 05','  Upiqr','  Dine-in','209.62','10.20','0.00','0.0','1323','202407051346',NULL,NULL,NULL,NULL,NULL,NULL),(1330,'20240705-1-0000340','200.00','admin','2024 07 05','  Sodexo','  Home delivery','200.00','0.00','0.00','0.0','1324','202407051347',NULL,NULL,NULL,NULL,NULL,NULL),(1331,'20240705-1-0000139','180.00','admin','2024 07 05','  Cash','  Home delivery','180.00','0.00','0.00','0.0','1325','202407051347',NULL,NULL,NULL,NULL,NULL,NULL),(1332,'20240705-1-0000341','189.62','admin','2024 07 05','  Cheque','  Home delivery','189.62','10.20','0.00','0.0','1326','202407051348',NULL,NULL,NULL,NULL,NULL,NULL),(1333,'20240705-1-0000342','170.00','admin','2024 07 05','  Card','  Dine-in','170.00','0.00','0.00','0.0','1327','202407051349',NULL,NULL,NULL,NULL,NULL,NULL),(1334,'20240705-1-0000254','190.00','admin','2024 07 05','  Cash','  Home delivery','190.00','0.00','0.00','0.0','1328','202407051349',NULL,NULL,NULL,NULL,NULL,NULL),(1335,'20240705-1-0000255','205.95','admin','2024 07 05','  Cheque','  Home delivery','205.95','5.95','0.00','0.0','1329','202407051350',NULL,NULL,NULL,NULL,NULL,NULL),(1336,'20240705-1-0000256','175.95','admin','2024 07 05','  Cheque','  Dine-in','175.95','5.95','0.00','0.0','1330','202407051350',NULL,NULL,NULL,NULL,NULL,NULL),(1337,'20240705-1-0000343','195.95','admin','2024 07 05','  Cash','  Home delivery','195.95','5.95','0.00','0.0','1331','202407051351',NULL,NULL,NULL,NULL,NULL,NULL),(1338,'20240705-1-0000257','188.67','admin','2024 07 05','  Upiqr','  Dine-in','188.67','4.25','0.00','0.0','1332','202407051351',NULL,NULL,NULL,NULL,NULL,NULL),(1339,'20240705-1-0000140','199.23','admin','2024 07 05','  Upiqr','  Dine-in','199.23','20.40','0.00','0.0','1333','202407051352',NULL,NULL,NULL,NULL,NULL,NULL),(1340,'20240705-1-0000344','202.33','admin','2024 07 05','  Cash','  Dine-in','202.33','8.50','0.00','0.0','1334','202407051352',NULL,NULL,NULL,NULL,NULL,NULL),(1341,'20240705-1-0000345','187.33','admin','2024 07 05','  Zeta','  Home delivery','187.33','8.50','0.00','0.0','1335','202407051353',NULL,NULL,NULL,NULL,NULL,NULL),(1342,'20240705-1-0000258','208.28','admin','2024 07 05','  Card','  Dine-in','208.28','14.45','0.00','0.0','1336','202407051353',NULL,NULL,NULL,NULL,NULL,NULL),(1343,'20240705-1-0000141','173.28','admin','2024 07 05','  Upiqr','  Dine-in','173.28','14.45','0.00','0.0','1337','202407051354',NULL,NULL,NULL,NULL,NULL,NULL),(1344,'20240705-1-0000142','187.33','admin','2024 07 05','  Sodexo','  Home delivery','187.33','8.50','0.00','0.0','1338','202407051354',NULL,NULL,NULL,NULL,NULL,NULL),(1345,'20240705-1-0000346','211.90','admin','2024 07 05','  Cheque','  Home delivery','211.90','11.90','0.00','0.0','1339','202407051355',NULL,NULL,NULL,NULL,NULL,NULL),(1346,'20240705-1-0000143','183.67','admin','2024 07 05','  Card','  Takeaway','183.67','4.25','0.00','0.0','1340','202407051355',NULL,NULL,NULL,NULL,NULL,NULL),(1347,'20240705-1-0000259','194.62','admin','2024 07 05','  Upiqr','  Home delivery','194.62','10.20','0.00','0.0','1341','202407051356',NULL,NULL,NULL,NULL,NULL,NULL),(1348,'20240705-1-0000144','195.00','admin','2024 07 05','  Pay Later','  Takeaway','195.00','0.00','0.00','0.0','1342','202407051356',NULL,NULL,NULL,NULL,NULL,NULL),(1349,'20240705-1-0000145','179.62','admin','2024 07 05','  Pay Later','  Home delivery','179.62','10.20','0.00','0.0','1343','202407051357',NULL,NULL,NULL,NULL,NULL,NULL),(1350,'20240705-1-0000260','185.95','admin','2024 07 05','  Ticket','  Takeaway','185.95','5.95','0.00','0.0','1344','202407051358',NULL,NULL,NULL,NULL,NULL,NULL),(1351,'20240705-1-0000146','205.95','admin','2024 07 05','  Cash','  Dine-in','205.95','5.95','0.00','0.0','1345','202407051358',NULL,NULL,NULL,NULL,NULL,NULL),(1352,'20240705-1-0000347','205.95','admin','2024 07 05','  Upiqr','  Home delivery','205.95','5.95','0.00','0.0','1346','202407051359',NULL,NULL,NULL,NULL,NULL,NULL),(1353,'20240705-1-0000261','197.33','admin','2024 07 05','  Pay Later','  Dine-in','197.33','8.50','0.00','0.0','1347','202407051359',NULL,NULL,NULL,NULL,NULL,NULL),(1354,'20240705-1-0000348','167.33','admin','2024 07 05','  Card','  Takeaway','167.33','8.50','0.00','0.0','1348','202407051400',NULL,NULL,NULL,NULL,NULL,NULL),(1355,'20240705-1-0000349','190.95','admin','2024 07 05','  Pay Later','  Home delivery','190.95','5.95','0.00','0.0','1349','202407051400',NULL,NULL,NULL,NULL,NULL,NULL),(1356,'20240705-1-0000350','192.33','admin','2024 07 05','  Ticket','  Takeaway','192.33','8.50','0.00','0.0','1350','202407051401',NULL,NULL,NULL,NULL,NULL,NULL),(1357,'20240705-1-0000262','216.90','admin','2024 07 05','  Cash','  Home delivery','216.90','11.90','0.00','0.0','1351','202407051401',NULL,NULL,NULL,NULL,NULL,NULL),(1358,'20240705-1-0000263','177.33','admin','2024 07 05','  Cheque','  Home delivery','177.33','8.50','0.00','0.0','1352','202407051402',NULL,NULL,NULL,NULL,NULL,NULL),(1359,'20240705-1-0000264','190.00','admin','2024 07 05','  Sodexo','  Home delivery','190.00','0.00','0.00','0.0','1353','202407051402',NULL,NULL,NULL,NULL,NULL,NULL),(1360,'20240705-1-0000265','199.62','admin','2024 07 05','  Card','  Dine-in','199.62','10.20','0.00','0.0','1354','202407051403',NULL,NULL,NULL,NULL,NULL,NULL),(1361,'20240705-1-0000266','173.67','admin','2024 07 05','  Zeta','  Home delivery','173.67','4.25','0.00','0.0','1355','202407051404',NULL,NULL,NULL,NULL,NULL,NULL),(1362,'20240705-1-0000267','198.67','admin','2024 07 05','  Ticket','  Home delivery','198.67','4.25','0.00','0.0','1356','202407051404',NULL,NULL,NULL,NULL,NULL,NULL),(1363,'20240705-1-0000268','190.00','admin','2024 07 05','  Pay Later','  Dine-in','190.00','0.00','0.00','0.0','1357','202407051405',NULL,NULL,NULL,NULL,NULL,NULL),(1364,'20240705-1-0000351','183.67','admin','2024 07 05','  Cheque','  Takeaway','183.67','4.25','0.00','0.0','1358','202407051405',NULL,NULL,NULL,NULL,NULL,NULL),(1365,'20240705-1-0000352','210.00','admin','2024 07 05','  Card','  Takeaway','210.00','0.00','0.00','0.0','1359','202407051406',NULL,NULL,NULL,NULL,NULL,NULL),(1366,'20240705-1-0000147','205.00','admin','2024 07 05','  Zeta','  Takeaway','205.00','0.00','0.00','0.0','1360','202407051406',NULL,NULL,NULL,NULL,NULL,NULL),(1367,'20240705-1-0000269','209.62','admin','2024 07 05','  Card','  Dine-in','209.62','10.20','0.00','0.0','1361','202407051407',NULL,NULL,NULL,NULL,NULL,NULL),(1368,'20240705-1-0000353','207.90','admin','2024 07 05','  Pay Later','  Takeaway','207.90','24.65','0.00','0.0','1362','202407051408',NULL,NULL,NULL,NULL,NULL,NULL),(1369,'20240705-1-0000148','187.33','admin','2024 07 05','  Ticket','  Home delivery','187.33','8.50','0.00','0.0','1363','202407051408',NULL,NULL,NULL,NULL,NULL,NULL),(1370,'20240705-1-0000354','230.95','admin','2024 07 05','  Cash','  Dine-in','230.95','5.95','0.00','0.0','1364','202407051409',NULL,NULL,NULL,NULL,NULL,NULL),(1371,'20240705-1-0000149','194.62','admin','2024 07 05','  Pay Later','  Home delivery','194.62','10.20','0.00','0.0','1365','202407051409',NULL,NULL,NULL,NULL,NULL,NULL),(1372,'20240705-1-0000355','201.52','admin','2024 07 05','  Card','  Takeaway','201.52','22.10','0.00','0.0','1366','202407051410',NULL,NULL,NULL,NULL,NULL,NULL),(1373,'20240705-1-0000150','163.67','admin','2024 07 05','  Cash','  Dine-in','163.67','4.25','0.00','0.0','1367','202407051410',NULL,NULL,NULL,NULL,NULL,NULL),(1374,'20240705-1-0000270','204.62','admin','2024 07 05','  Zeta','  Takeaway','204.62','10.20','0.00','0.0','1368','202407051411',NULL,NULL,NULL,NULL,NULL,NULL),(1375,'20240705-1-0000151','184.62','admin','2024 07 05','  Card','  Home delivery','184.62','10.20','0.00','0.0','1369','202407051412',NULL,NULL,NULL,NULL,NULL,NULL),(1376,'20240705-1-0000152','190.57','admin','2024 07 05','  Upiqr','  Dine-in','190.57','16.15','0.00','0.0','1370','202407051412',NULL,NULL,NULL,NULL,NULL,NULL),(1377,'20240705-1-0000153','225.57','admin','2024 07 05','  Card','  Home delivery','225.57','16.15','0.00','0.0','1371','202407051413',NULL,NULL,NULL,NULL,NULL,NULL),(1378,'20240705-1-0000271','190.95','admin','2024 07 05','  Cheque','  Dine-in','190.95','5.95','0.00','0.0','1372','202407051413',NULL,NULL,NULL,NULL,NULL,NULL),(1379,'20240705-1-0000272','183.67','admin','2024 07 05','  Cheque','  Home delivery','183.67','4.25','0.00','0.0','1373','202407051414',NULL,NULL,NULL,NULL,NULL,NULL),(1380,'20240705-1-0000273','224.62','admin','2024 07 05','  Pay Later','  Home delivery','224.62','10.20','0.00','0.0','1374','202407051414',NULL,NULL,NULL,NULL,NULL,NULL),(1381,'20240705-1-0000154','175.00','admin','2024 07 05','  Cheque','  Dine-in','175.00','0.00','0.00','0.0','1375','202407051415',NULL,NULL,NULL,NULL,NULL,NULL),(1382,'20240705-1-0000274','195.00','admin','2024 07 05','  Cash','  Dine-in','195.00','0.00','0.00','0.0','1376','202407051415',NULL,NULL,NULL,NULL,NULL,NULL),(1383,'20240705-1-0000155','194.62','admin','2024 07 05','  Card','  Home delivery','194.62','10.20','0.00','0.0','1377','202407051416',NULL,NULL,NULL,NULL,NULL,NULL),(1384,'20240705-1-0000156','205.95','admin','2024 07 05','  Card','  Home delivery','205.95','5.95','0.00','0.0','1378','202407051416',NULL,NULL,NULL,NULL,NULL,NULL),(1385,'20240705-1-0000157','189.23','admin','2024 07 05','  Sodexo','  Takeaway','189.23','20.40','0.00','0.0','1379','202407051417',NULL,NULL,NULL,NULL,NULL,NULL),(1386,'20240705-1-0000275','194.62','admin','2024 07 05','  Pay Later','  Dine-in','194.62','10.20','0.00','0.0','1380','202407051418',NULL,NULL,NULL,NULL,NULL,NULL),(1387,'20240705-1-0000356','183.67','admin','2024 07 05','  Card','  Home delivery','183.67','4.25','0.00','0.0','1381','202407051418',NULL,NULL,NULL,NULL,NULL,NULL),(1388,'20240705-1-0000357','208.67','admin','2024 07 05','  Sodexo','  Dine-in','208.67','4.25','0.00','0.0','1382','202407051419',NULL,NULL,NULL,NULL,NULL,NULL),(1389,'20240705-1-0000358','170.00','admin','2024 07 05','  Card','  Dine-in','170.00','0.00','0.00','0.0','1383','202407051419',NULL,NULL,NULL,NULL,NULL,NULL),(1390,'20240705-1-0000359','220.57','admin','2024 07 05','  Pay Later','  Takeaway','220.57','16.15','0.00','0.0','1384','202407051420',NULL,NULL,NULL,NULL,NULL,NULL),(1391,'20240705-1-0000276','208.28','admin','2024 07 05','  Card','  Home delivery','208.28','14.45','0.00','0.0','1385','202407051420',NULL,NULL,NULL,NULL,NULL,NULL),(1392,'20240705-1-0000158','209.62','admin','2024 07 05','  Sodexo','  Takeaway','209.62','10.20','0.00','0.0','1386','202407051421',NULL,NULL,NULL,NULL,NULL,NULL),(1393,'20240705-1-0000360','198.67','admin','2024 07 05','  Ticket','  Dine-in','198.67','4.25','0.00','0.0','1387','202407051422',NULL,NULL,NULL,NULL,NULL,NULL),(1394,'20240705-1-0000361','170.00','admin','2024 07 05','  Card','  Dine-in','170.00','0.00','0.00','0.0','1388','202407051422',NULL,NULL,NULL,NULL,NULL,NULL),(1395,'20240705-1-0000159','173.67','admin','2024 07 05','  Ticket','  Takeaway','173.67','4.25','0.00','0.0','1389','202407051423',NULL,NULL,NULL,NULL,NULL,NULL),(1396,'20240705-1-0000277','200.95','admin','2024 07 05','  Upiqr','  Dine-in','200.95','5.95','0.00','0.0','1390','202407051423',NULL,NULL,NULL,NULL,NULL,NULL),(1397,'20240705-1-0000278','188.67','admin','2024 07 05','  Cheque','  Dine-in','188.67','4.25','0.00','0.0','1391','202407051424',NULL,NULL,NULL,NULL,NULL,NULL),(1398,'20240705-1-0000279','198.67','admin','2024 07 05','  Card','  Dine-in','198.67','4.25','0.00','0.0','1392','202407051424',NULL,NULL,NULL,NULL,NULL,NULL),(1399,'20240705-1-0000362','183.67','admin','2024 07 05','  Cash','  Home delivery','183.67','4.25','0.00','0.0','1393','202407051425',NULL,NULL,NULL,NULL,NULL,NULL),(1400,'20240705-1-0000160','183.67','admin','2024 07 05','  Cash','  Home delivery','183.67','4.25','0.00','0.0','1394','202407051425',NULL,NULL,NULL,NULL,NULL,NULL),(1401,'20240705-1-0000363','199.62','admin','2024 07 05','  Cheque','  Home delivery','199.62','10.20','0.00','0.0','1395','202407051426',NULL,NULL,NULL,NULL,NULL,NULL),(1402,'20240705-1-0000161','220.95','admin','2024 07 05','  Upiqr','  Dine-in','220.95','5.95','0.00','0.0','1396','202407051426',NULL,NULL,NULL,NULL,NULL,NULL),(1403,'20240705-1-0000280','185.95','admin','2024 07 05','  Upiqr','  Takeaway','185.95','5.95','0.00','0.0','1397','202407051427',NULL,NULL,NULL,NULL,NULL,NULL),(1404,'20240705-1-0000162','195.00','admin','2024 07 05','  Upiqr','  Dine-in','195.00','0.00','0.00','0.0','1398','202407051427',NULL,NULL,NULL,NULL,NULL,NULL),(1405,'20240705-1-0000163','210.95','admin','2024 07 05','  Pay Later','  Dine-in','210.95','5.95','0.00','0.0','1399','202407051428',NULL,NULL,NULL,NULL,NULL,NULL),(1406,'20240705-1-0000364','215.95','admin','2024 07 05','  Upiqr','  Home delivery','215.95','5.95','0.00','0.0','1400','202407051428',NULL,NULL,NULL,NULL,NULL,NULL),(1407,'20240705-1-0000281','190.57','admin','2024 07 05','  Ticket','  Takeaway','190.57','16.15','0.00','0.0','1401','202407051429',NULL,NULL,NULL,NULL,NULL,NULL),(1408,'20240705-1-0000164','200.57','admin','2024 07 05','  Cheque','  Home delivery','200.57','16.15','0.00','0.0','1402','202407051429',NULL,NULL,NULL,NULL,NULL,NULL),(1409,'20240705-1-0000282','182.33','admin','2024 07 05','  Upiqr','  Takeaway','182.33','8.50','0.00','0.0','1403','202407051430',NULL,NULL,NULL,NULL,NULL,NULL),(1410,'20240705-1-0000283','205.57','admin','2024 07 05','  Card','  Dine-in','205.57','16.15','0.00','0.0','1404','202407051430',NULL,NULL,NULL,NULL,NULL,NULL),(1411,'20240705-1-0000284','158.67','admin','2024 07 05','  Card','  Takeaway','158.67','4.25','0.00','0.0','1405','202407051431',NULL,NULL,NULL,NULL,NULL,NULL),(1412,'20240705-1-0000165','173.67','admin','2024 07 05','  Cheque','  Takeaway','173.67','4.25','0.00','0.0','1406','202407051431',NULL,NULL,NULL,NULL,NULL,NULL),(1413,'20240705-1-0000285','190.95','admin','2024 07 05','  Cash','  Home delivery','190.95','5.95','0.00','0.0','1407','202407051432',NULL,NULL,NULL,NULL,NULL,NULL),(1414,'20240705-1-0000365','178.67','admin','2024 07 05','  Cash','  Dine-in','178.67','4.25','0.00','0.0','1408','202407051433',NULL,NULL,NULL,NULL,NULL,NULL),(1415,'20240705-1-0000166','188.67','admin','2024 07 05','  Upiqr','  Home delivery','188.67','4.25','0.00','0.0','1409','202407051433',NULL,NULL,NULL,NULL,NULL,NULL),(1416,'20240705-1-0000366','214.62','admin','2024 07 05','  Cash','  Dine-in','214.62','10.20','0.00','0.0','1410','202407051434',NULL,NULL,NULL,NULL,NULL,NULL),(1417,'20240705-1-0000167','193.28','admin','2024 07 05','  Cash','  Takeaway','193.28','14.45','0.00','0.0','1411','202407051434',NULL,NULL,NULL,NULL,NULL,NULL),(1418,'20240705-1-0000367','204.62','admin','2024 07 05','  Card','  Home delivery','204.62','10.20','0.00','0.0','1412','202407051435',NULL,NULL,NULL,NULL,NULL,NULL),(1419,'20240705-1-0000286','190.57','admin','2024 07 05','  Pay Later','  Takeaway','190.57','16.15','0.00','0.0','1413','202407051435',NULL,NULL,NULL,NULL,NULL,NULL),(1420,'20240705-1-0000168','190.95','admin','2024 07 05','  Cash','  Dine-in','190.95','5.95','0.00','0.0','1414','202407051436',NULL,NULL,NULL,NULL,NULL,NULL),(1421,'20240705-1-0000287','205.57','admin','2024 07 05','  Upiqr','  Dine-in','205.57','16.15','0.00','0.0','1415','202407051436',NULL,NULL,NULL,NULL,NULL,NULL),(1422,'20240705-1-0000288','168.67','admin','2024 07 05','  Cheque','  Dine-in','168.67','4.25','0.00','0.0','1416','202407051437',NULL,NULL,NULL,NULL,NULL,NULL),(1423,'20240705-1-0000289','178.67','admin','2024 07 05','  Pay Later','  Home delivery','178.67','4.25','0.00','0.0','1417','202407051437',NULL,NULL,NULL,NULL,NULL,NULL),(1424,'20240705-1-0000290','201.90','admin','2024 07 05','  Upiqr','  Dine-in','201.90','11.90','0.00','0.0','1418','202407051438',NULL,NULL,NULL,NULL,NULL,NULL),(1425,'20240705-1-0000169','198.67','admin','2024 07 05','  Card','  Dine-in','198.67','4.25','0.00','0.0','1419','202407051438',NULL,NULL,NULL,NULL,NULL,NULL),(1426,'20240705-1-0000368','200.00','admin','2024 07 05','  Cheque','  Home delivery','200.00','0.00','0.00','0.0','1420','202407051439',NULL,NULL,NULL,NULL,NULL,NULL),(1427,'20240705-1-0000170','185.95','admin','2024 07 05','  Upiqr','  Home delivery','185.95','5.95','0.00','0.0','1421','202407051439',NULL,NULL,NULL,NULL,NULL,NULL),(1428,'20240705-1-0000369','187.33','admin','2024 07 05','  Card','  Dine-in','187.33','8.50','0.00','0.0','1422','202407051440',NULL,NULL,NULL,NULL,NULL,NULL),(1429,'20240705-1-0000291','205.00','admin','2024 07 05','  Zeta','  Home delivery','205.00','0.00','0.00','0.0','1423','202407051441',NULL,NULL,NULL,NULL,NULL,NULL),(1430,'20240705-1-0000370','211.90','admin','2024 07 05','  Pay Later','  Takeaway','211.90','11.90','0.00','0.0','1424','202407051441',NULL,NULL,NULL,NULL,NULL,NULL),(1431,'20240705-1-0000292','199.62','admin','2024 07 05','  Card','  Dine-in','199.62','10.20','0.00','0.0','1425','202407051442',NULL,NULL,NULL,NULL,NULL,NULL),(1432,'20240705-1-0000293','166.00','admin','2024 07 05','  Card','  Home delivery','166.00','12.75','0.00','0.0','1426','202407051442',NULL,NULL,NULL,NULL,NULL,NULL),(1433,'20240705-1-0000171','209.62','admin','2024 07 05','  Zeta','  Takeaway','209.62','10.20','0.00','0.0','1427','202407051443',NULL,NULL,NULL,NULL,NULL,NULL),(1434,'20240705-1-0000371','183.67','admin','2024 07 05','  Ticket','  Takeaway','183.67','4.25','0.00','0.0','1428','202407051443',NULL,NULL,NULL,NULL,NULL,NULL),(1435,'20240705-1-0000294','195.00','admin','2024 07 05','  Cheque','  Takeaway','195.00','0.00','0.00','0.0','1429','202407051444',NULL,NULL,NULL,NULL,NULL,NULL),(1436,'20240705-1-0000172','187.33','admin','2024 07 05','  Upiqr','  Dine-in','187.33','8.50','0.00','0.0','1430','202407051444',NULL,NULL,NULL,NULL,NULL,NULL),(1437,'20240705-1-0000295','168.67','admin','2024 07 05','  Card','  Takeaway','168.67','4.25','0.00','0.0','1431','202407051445',NULL,NULL,NULL,NULL,NULL,NULL),(1438,'20240705-1-0000173','178.28','admin','2024 07 05','  Card','  Takeaway','178.28','14.45','0.00','0.0','1432','202407051446',NULL,NULL,NULL,NULL,NULL,NULL),(1439,'20240705-1-0000174','183.67','admin','2024 07 05','  Card','  Takeaway','183.67','4.25','0.00','0.0','1433','202407051446',NULL,NULL,NULL,NULL,NULL,NULL),(1440,'20240705-1-0000296','175.95','admin','2024 07 05','  Card','  Takeaway','175.95','5.95','0.00','0.0','1434','202407051447',NULL,NULL,NULL,NULL,NULL,NULL),(1441,'20240705-1-0000372','182.33','admin','2024 07 05','  Cash','  Home delivery','182.33','8.50','0.00','0.0','1435','202407051447',NULL,NULL,NULL,NULL,NULL,NULL),(1442,'20240705-1-0000297','195.57','admin','2024 07 05','  Cheque','  Dine-in','195.57','16.15','0.00','0.0','1436','202407051448',NULL,NULL,NULL,NULL,NULL,NULL),(1443,'20240705-1-0000175','211.90','admin','2024 07 05','  Cheque','  Takeaway','211.90','11.90','0.00','0.0','1437','202407051448',NULL,NULL,NULL,NULL,NULL,NULL),(1444,'20240705-1-0000176','211.90','admin','2024 07 05','  Card','  Dine-in','211.90','11.90','0.00','0.0','1438','202407051449',NULL,NULL,NULL,NULL,NULL,NULL),(1445,'20240705-1-0000177','189.62','admin','2024 07 05','  Cash','  Home delivery','189.62','10.20','0.00','0.0','1439','202407051450',NULL,NULL,NULL,NULL,NULL,NULL),(1446,'20240705-1-0000298','195.00','admin','2024 07 05','  Upiqr','  Home delivery','195.00','0.00','0.00','0.0','1440','202407051450',NULL,NULL,NULL,NULL,NULL,NULL),(1447,'20240705-1-0000373','195.95','admin','2024 07 05','  Pay Later','  Takeaway','195.95','5.95','0.00','0.0','1441','202407051451',NULL,NULL,NULL,NULL,NULL,NULL),(1448,'20240705-1-0000178','178.67','admin','2024 07 05','  Pay Later','  Home delivery','178.67','4.25','0.00','0.0','1442','202407051451',NULL,NULL,NULL,NULL,NULL,NULL),(1449,'20240705-1-0000179','160.00','admin','2024 07 05','  Pay Later','  Dine-in','160.00','0.00','0.00','0.0','1443','202407051452',NULL,NULL,NULL,NULL,NULL,NULL),(1450,'20240705-1-0000180','189.62','admin','2024 07 05','  Zeta','  Dine-in','189.62','10.20','0.00','0.0','1444','202407051452',NULL,NULL,NULL,NULL,NULL,NULL),(1451,'20240705-1-0000299','216.90','admin','2024 07 05','  Pay Later','  Takeaway','216.90','11.90','0.00','0.0','1445','202407051453',NULL,NULL,NULL,NULL,NULL,NULL),(1452,'20240705-1-00002100','205.95','admin','2024 07 05','  Cash','  Dine-in','205.95','5.95','0.00','0.0','1446','202407051454',NULL,NULL,NULL,NULL,NULL,NULL),(1453,'20240705-1-0000374','187.33','admin','2024 07 05','  Card','  Takeaway','187.33','8.50','0.00','0.0','1447','202407051454',NULL,NULL,NULL,NULL,NULL,NULL),(1454,'20240705-1-00002101','188.67','admin','2024 07 05','  Cheque','  Home delivery','188.67','4.25','0.00','0.0','1448','202407051455',NULL,NULL,NULL,NULL,NULL,NULL),(1455,'20240705-1-0000375','199.62','admin','2024 07 05','  Upiqr','  Home delivery','199.62','10.20','0.00','0.0','1449','202407051455',NULL,NULL,NULL,NULL,NULL,NULL),(1456,'20240705-1-0000181','210.95','admin','2024 07 05','  Cheque','  Home delivery','210.95','5.95','0.00','0.0','1450','202407051456',NULL,NULL,NULL,NULL,NULL,NULL),(1457,'20240705-1-0000182','201.52','admin','2024 07 05','  Card','  Home delivery','201.52','22.10','0.00','0.0','1451','202407051457',NULL,NULL,NULL,NULL,NULL,NULL),(1458,'20240705-1-00002102','178.67','admin','2024 07 05','  Cash','  Home delivery','178.67','4.25','0.00','0.0','1452','202407051457',NULL,NULL,NULL,NULL,NULL,NULL),(1459,'20240705-1-00002103','179.62','admin','2024 07 05','  Card','  Dine-in','179.62','10.20','0.00','0.0','1453','202407051458',NULL,NULL,NULL,NULL,NULL,NULL),(1460,'20240705-1-0000376','182.33','admin','2024 07 05','  Upiqr','  Dine-in','182.33','8.50','0.00','0.0','1454','202407051458',NULL,NULL,NULL,NULL,NULL,NULL),(1461,'20240705-1-0000377','222.85','admin','2024 07 05','  Pay Later','  Takeaway','222.85','17.85','0.00','0.0','1455','202407051459',NULL,NULL,NULL,NULL,NULL,NULL),(1462,'20240705-1-0000378','215.57','admin','2024 07 05','  Upiqr','  Home delivery','215.57','16.15','0.00','0.0','1456','202407051459',NULL,NULL,NULL,NULL,NULL,NULL),(1463,'20240705-1-0000183','182.33','admin','2024 07 05','  Upiqr','  Takeaway','182.33','8.50','0.00','0.0','1457','202407051500',NULL,NULL,NULL,NULL,NULL,NULL),(1464,'20240705-1-0000379','180.00','admin','2024 07 05','  Cheque','  Home delivery','180.00','0.00','0.00','0.0','1458','202407051500',NULL,NULL,NULL,NULL,NULL,NULL),(1465,'20240705-1-0000380','215.95','admin','2024 07 05','  Sodexo','  Home delivery','215.95','5.95','0.00','0.0','1459','202407051501',NULL,NULL,NULL,NULL,NULL,NULL),(1466,'20240705-1-0000184','177.33','admin','2024 07 05','  Card','  Takeaway','177.33','8.50','0.00','0.0','1460','202407051502',NULL,NULL,NULL,NULL,NULL,NULL),(1467,'20240705-1-0000381','210.00','admin','2024 07 05','  Cheque','  Takeaway','210.00','0.00','0.00','0.0','1461','202407051502',NULL,NULL,NULL,NULL,NULL,NULL),(1468,'20240705-1-00002104','187.33','admin','2024 07 05','  Cheque','  Dine-in','187.33','8.50','0.00','0.0','1462','202407051503',NULL,NULL,NULL,NULL,NULL,NULL),(1469,'20240705-1-0000185','214.62','admin','2024 07 05','  Pay Later','  Dine-in','214.62','10.20','0.00','0.0','1463','202407051503',NULL,NULL,NULL,NULL,NULL,NULL),(1470,'20240705-1-00002105','202.33','admin','2024 07 05','  Cash','  Takeaway','202.33','8.50','0.00','0.0','1464','202407051504',NULL,NULL,NULL,NULL,NULL,NULL),(1471,'20240705-1-00002106','177.33','admin','2024 07 05','  Card','  Home delivery','177.33','8.50','0.00','0.0','1465','202407051504',NULL,NULL,NULL,NULL,NULL,NULL),(1472,'20240705-1-00002107','188.67','admin','2024 07 05','  Card','  Dine-in','188.67','4.25','0.00','0.0','1466','202407051505',NULL,NULL,NULL,NULL,NULL,NULL),(1473,'20240705-1-0000382','188.28','admin','2024 07 05','  Pay Later','  Dine-in','188.28','14.45','0.00','0.0','1467','202407051506',NULL,NULL,NULL,NULL,NULL,NULL),(1474,'20240705-1-0000186','179.62','admin','2024 07 05','  Cheque','  Takeaway','179.62','10.20','0.00','0.0','1468','202407051506',NULL,NULL,NULL,NULL,NULL,NULL),(1475,'20240705-1-0000383','194.62','admin','2024 07 05','  Cash','  Dine-in','194.62','10.20','0.00','0.0','1469','202407051507',NULL,NULL,NULL,NULL,NULL,NULL),(1476,'20240705-1-0000187','204.23','admin','2024 07 05','  Ticket','  Takeaway','204.23','20.40','0.00','0.0','1470','202407051507',NULL,NULL,NULL,NULL,NULL,NULL),(1477,'20240705-1-0000188','200.95','admin','2024 07 05','  Cheque','  Takeaway','200.95','5.95','0.00','0.0','1471','202407051508',NULL,NULL,NULL,NULL,NULL,NULL),(1478,'20240705-1-00002108','174.62','admin','2024 07 05','  Upiqr','  Home delivery','174.62','10.20','0.00','0.0','1472','202407051508',NULL,NULL,NULL,NULL,NULL,NULL),(1479,'20240705-1-00002109','194.62','admin','2024 07 05','  Upiqr','  Home delivery','194.62','10.20','0.00','0.0','1473','202407051509',NULL,NULL,NULL,NULL,NULL,NULL),(1480,'20240705-1-00002110','188.28','admin','2024 07 05','  Cheque','  Takeaway','188.28','14.45','0.00','0.0','1474','202407051509',NULL,NULL,NULL,NULL,NULL,NULL),(1481,'20240705-1-0000189','211.90','admin','2024 07 05','  Sodexo','  Takeaway','211.90','11.90','0.00','0.0','1475','202407051510',NULL,NULL,NULL,NULL,NULL,NULL),(1482,'20240705-1-0000190','220.95','admin','2024 07 05','  Cash','  Takeaway','220.95','5.95','0.00','0.0','1476','202407051511',NULL,NULL,NULL,NULL,NULL,NULL),(1483,'20240705-1-00002111','184.62','admin','2024 07 05','  Pay Later','  Dine-in','184.62','10.20','0.00','0.0','1477','202407051511',NULL,NULL,NULL,NULL,NULL,NULL),(1484,'20240705-1-00002112','211.52','admin','2024 07 05','  Cheque','  Home delivery','211.52','22.10','0.00','0.0','1478','202407051512',NULL,NULL,NULL,NULL,NULL,NULL),(1485,'20240705-1-00002113','181.00','admin','2024 07 05','  Cheque','  Takeaway','181.00','12.75','0.00','0.0','1479','202407051512',NULL,NULL,NULL,NULL,NULL,NULL),(1486,'20240705-1-0000191','177.33','admin','2024 07 05','  Pay Later','  Takeaway','177.33','8.50','0.00','0.0','1480','202407051513',NULL,NULL,NULL,NULL,NULL,NULL),(1487,'20240705-1-0000192','168.67','admin','2024 07 05','  Cheque','  Home delivery','168.67','4.25','0.00','0.0','1481','202407051514',NULL,NULL,NULL,NULL,NULL,NULL),(1488,'20240705-1-00002114','188.28','admin','2024 07 05','  Cash','  Takeaway','188.28','14.45','0.00','0.0','1482','202407051514',NULL,NULL,NULL,NULL,NULL,NULL),(1489,'20240705-1-0000193','210.00','admin','2024 07 05','  Pay Later','  Takeaway','210.00','0.00','0.00','0.0','1483','202407051515',NULL,NULL,NULL,NULL,NULL,NULL),(1490,'20240705-1-00002115','178.28','admin','2024 07 05','  Ticket','  Takeaway','178.28','14.45','0.00','0.0','1484','202407051515',NULL,NULL,NULL,NULL,NULL,NULL),(1491,'20240705-1-00002116','177.33','admin','2024 07 05','  Cheque','  Takeaway','177.33','8.50','0.00','0.0','1485','202407051516',NULL,NULL,NULL,NULL,NULL,NULL),(1492,'20240705-1-0000384','205.00','admin','2024 07 05','  Upiqr','  Home delivery','205.00','0.00','0.00','0.0','1486','202407051516',NULL,NULL,NULL,NULL,NULL,NULL),(1493,'20240705-1-0000385','199.62','admin','2024 07 05','  Zeta','  Takeaway','199.62','10.20','0.00','0.0','1487','202407051517',NULL,NULL,NULL,NULL,NULL,NULL),(1494,'20240705-1-0000194','165.00','admin','2024 07 05','  Card','  Dine-in','165.00','0.00','0.00','0.0','1488','202407051517',NULL,NULL,NULL,NULL,NULL,NULL),(1495,'20240705-1-0000386','211.90','admin','2024 07 05','  Cash','  Dine-in','211.90','11.90','0.00','0.0','1489','202407051518',NULL,NULL,NULL,NULL,NULL,NULL),(1496,'20240705-1-00002117','180.00','admin','2024 07 05','  Zeta','  Takeaway','180.00','0.00','0.00','0.0','1490','202407051519',NULL,NULL,NULL,NULL,NULL,NULL),(1497,'20240705-1-0000195','195.95','admin','2024 07 05','  Pay Later','  Takeaway','195.95','5.95','0.00','0.0','1491','202407051519',NULL,NULL,NULL,NULL,NULL,NULL),(1498,'20240705-1-0000387','178.67','admin','2024 07 05','  Pay Later','  Home delivery','178.67','4.25','0.00','0.0','1492','202407051520',NULL,NULL,NULL,NULL,NULL,NULL),(1499,'20240705-1-0000196','201.90','admin','2024 07 05','  Cash','  Home delivery','201.90','11.90','0.00','0.0','1493','202407051520',NULL,NULL,NULL,NULL,NULL,NULL),(1500,'20240705-1-00002118','195.00','admin','2024 07 05','  Cash','  Home delivery','195.00','0.00','0.00','0.0','1494','202407051521',NULL,NULL,NULL,NULL,NULL,NULL),(1501,'20240709-1-000011','105.00','madmin','2024 07 09','  cash','  Dine-in','105.000000','0.000000','0.000000','0','1495','202407091033','','','','0','0',NULL),(1502,'20240709-1-000011','105.00','madmin','2024 07 09','  cash','  Dine-in','105.000000','0.000000','0.000000','0','1495','202407091034','','','','0','0',NULL),(1503,'20240709-1-000013','63.75','madmin','2024 07 09','  card','  Dine-in','59.500000','4.250000','0.000000','0','1496','202407091036','','','','0','0',NULL),(1504,'20240709-1-000014','63.75','madmin','2024 07 09','  Pay Later','  Dine-in','59.500000','4.250000','0.000000','0','1497','202407091110','','','','0','0',NULL),(1505,'20240709-1-000014','63.75','madmin','2024 07 09','  Pay Later','  Dine-in','59.500000','4.250000','0.000000','0','1497','202407091110','','','','0','0',NULL),(1506,'20240709-1-000014','63.75','madmin','2024 07 09','  Pay Later','  Dine-in','59.500000','4.250000','0.000000','0','1497','202407091110','','','','0','0',NULL),(1507,'20240709-1-000014','63.75','madmin','2024 07 09','  Pay Later','  Dine-in','59.500000','4.250000','0.000000','0','1497','202407091110','','','','0','0',NULL),(1508,'20240709-1-000014','63.75','madmin','2024 07 09','  Pay Later','  Dine-in','59.500000','4.250000','0.000000','0','1497','202407091110','','','','0','0',NULL),(1509,'20240709-1-000019','144.70','madmin','2024 07 09','  card','  Dine-in','134.500000','10.200000','0.000000','0','1498','202407091138','','','','0','0',NULL),(1510,'20240709-1-000031','160.00','madmin','2024 07 09','  Pay Later','  Takeaway','160.000000','0.000000','0.000000','0','1499','20240709120000','','','','0','0',NULL),(1511,'20240709-1-000021','191.90','madmin','2024 07 09','  card','  Home delivery','180.000000','11.900000','0.000000','0','1500','202407091219','','','','0','0',NULL),(1512,'20240709-1-000032','155.00','madmin','2024 07 09','  card','  Home delivery','155.000000','0.000000','0.000000','0','1501','202407091230','','','','0','0',NULL),(1513,'20240709-1-0000110','133.75','madmin','2024 07 09','  cash','  Dine-in','129.500000','4.250000','0.000000','0','1502','202407091231','','','','0','0',NULL),(1514,'20240709-1-000033','165.00','madmin','2024 07 09','  Pay Later','  Home delivery','165.000000','0.000000','0.000000','0','1503','202407091238','','','','0','0',NULL),(1515,'20240709-1-0000111','35.00','madmin','2024 07 09','  cash','  Dine-in','35.000000','0.000000','0.000000','0','1504','202407091238','','','','0','0',NULL),(1516,'20240709-1-0000112','70.00','madmin','2024 07 09','  Pay Later','  Dine-in','70.000000','0.000000','0.000000','0','1505','202407091238','','','','0','0',NULL),(1517,'20240709-1-000034','181.90','madmin','2024 07 09','  Pay Later','  Takeaway','170.000000','11.900000','0.000000','0','1506','202407091240','','','','0','0',NULL),(1518,'20240709-1-0000113','162.50','madmin','2024 07 09','  cash','  Dine-in','154.000000','8.500000','0.000000','0','1507','202407091310','','','','0','0',NULL),(1519,'20240709-1-0000114','165.00','madmin','2024 07 09','  UpiQr','  Home delivery','165.000000','0.000000','0.000000','0','1508','202407091312','','','','0','0',NULL),(1520,'20240709-1-0000115','98.75','madmin','2024 07 09','  cash','  Dine-in','94.500000','4.250000','0.000000','0','1509','202407091313','','','','0','0',NULL),(1521,'20240709-1-0000116','150.00','madmin','2024 07 09','  Pay Later','  Home delivery','150.000000','0.000000','0.000000','0','1510','202407091317','','','','0','0',NULL),(1522,'20240709-1-0000117','170.95','madmin','2024 07 09','  Pay Later','  Home delivery','165.000000','5.950000','0.000000','0','1511','202407091318','','','','0','0',NULL),(1523,'20240709-1-000022','160.95','madmin','2024 07 09','  Pay Later','  Home delivery','155.000000','5.950000','0.000000','0','1512','202407091335','','','','0','0',NULL),(1524,'20240709-1-0000118','160.00','madmin','2024 07 09','  Pay Later','  Home delivery','160.000000','0.000000','0.000000','0','1513','202407091338','','','','0','0',NULL),(1525,'20240709-1-000035','175.00','madmin','2024 07 09','  Pay Later','  Dine-in','175.000000','0.000000','0.000000','0','1514','202407091342','','','','0','0',NULL),(1526,'20240709-1-0000119','70.00','madmin','2024 07 09','  cash','  Dine-in','70.000000','0.000000','0.000000','0','1515','202407091347','','','','0','0',NULL),(1527,'20240709-1-000036','186.90','madmin','2024 07 09','  card','  Dine-in','175.000000','11.900000','0.000000','0','1516','202407091349','','','','0','0',NULL),(1528,'20240709-1-000037','180.95','madmin','2024 07 09','  cash','  Dine-in','175.000000','5.950000','0.000000','0','1517','20240709140009','','','','0','0',NULL),(1529,'20240712-1-000011','41.30','admin','2024 07 12','  Cash','  Dine-in','35.00','6.30','0.00','18.0','1518','202407121610',NULL,NULL,NULL,NULL,NULL,NULL),(1530,'20240712-1-000012','234.43','admin','2024 07 12','  Pay Later','  Dine-in','198.67','40.01','0.00','18.0','1519','202407121641',NULL,NULL,NULL,NULL,NULL,NULL),(1531,'20240712-1-000013','212.40','admin','2024 07 12','  Sodexo','  Dine-in','180.00','32.40','0.00','18.0','1520','202407121642',NULL,NULL,NULL,NULL,NULL,NULL),(1532,'20240712-1-000014','222.63','admin','2024 07 12','  Pay Later','  Takeaway','188.67','38.21','0.00','18.0','1521','202407121642',NULL,NULL,NULL,NULL,NULL,NULL),(1533,'20240712-1-000015','236.00','admin','2024 07 12','  Cheque','  Takeaway','200.00','36.00','0.00','18.0','1522','202407121643',NULL,NULL,NULL,NULL,NULL,NULL),(1534,'20240723-1-000011','369.20','admin','2024 07 23','  Cash','  Dine-in','369.2','4.20','0.0','0.0','1523','202407231658',NULL,NULL,NULL,NULL,NULL,NULL),(1535,'20240723-1-000012','0','admin','2024 07 23','  Cash','  Dine-in','0.0','0.0','0.0','0.0','1524','202407231703',NULL,NULL,NULL,NULL,NULL,NULL),(1536,'20240724-1-000021','893.40','madmin','2024 07 24','  card','  Dine-in','885.000000','8.400000','0.000000','0','1525','202407241537','','','','0','0',NULL),(1537,'20240724-1-000022','835.00','madmin','2024 07 24','  UpiQr','  Takeaway','835.000000','0.000000','0.000000','0','1526','202407241553','','','','0','0',NULL),(1538,'20240724-1-000023','909.20','madmin','2024 07 24','  card','  Home delivery','905.000000','4.200000','0.000000','0','1527','20240724160008','','','','0','0',NULL),(1539,'20240724-1-000011','862.68','madmin','2024 07 24','  Pay Later','  Home delivery','841.800000','20.880000','0.000000','0','1528','202407241624','','','','0','0',NULL),(1540,'20240724-1-000012','773.20','madmin','2024 07 24','  Pay Later','  Takeaway','767.200000','6.000000','0.000000','0','1529','202407241630','','','','0','0',NULL),(1541,'20240724-1-000031','690.00','madmin','2024 07 24','  Pay Later','  Dine-in','690.000000','0.000000','0.000000','0','1530','202407241816','','','','0','0',NULL),(1542,'20240801-1-000011','385.00','admin','2024 08 01','  Cash','  Takeaway','385.00','0.00','0.00','0.0','1531','202408011207',NULL,NULL,NULL,NULL,NULL,NULL),(1543,'20240801-1-000031','264.00','admin','2024 08 01','  Cash','  Home delivery','264.00','0.00','0.00','0.0','1532','202408011209',NULL,NULL,NULL,NULL,NULL,NULL),(1544,'20240801-1-000032','337.79','admin','2024 08 01','  Pay Later','  Home delivery','337.79','7.20','0.00','0.0','1533','202408011211',NULL,NULL,NULL,NULL,NULL,NULL),(1545,'20240801-1-000012','361.30','admin','2024 08 01','  Zeta','  Dine-in','361.30','0.00','0.00','0.0','1534','202408011214',NULL,NULL,NULL,NULL,NULL,NULL),(1546,'20240801-1-000013','372.40','admin','2024 08 01','  Ticket','  Home delivery','372.40','4.20','0.00','0.0','1535','202408011217',NULL,NULL,NULL,NULL,NULL,NULL),(1547,'20240802-1-000021','100.00','madmin','2024 08 02','  cash','  Dine-in','100.000000','0.000000','0.000000','0','1536','202408021515','','','','0','0',NULL),(1548,'20240806-1-000021','309.20','admin','2024 08 06','  Pay Later','  Home delivery','309.20','4.20','0.00','0.0','1537','202408061341',NULL,NULL,NULL,NULL,NULL,NULL),(1549,'20240806-1-000031','444.00','admin','2024 08 06','  Cash','  Takeaway','444.00','0.00','0.00','0.0','1538','202408061345',NULL,NULL,NULL,NULL,NULL,NULL),(1550,'20240806-1-000011','307.40','admin','2024 08 06','  Pay Later','  Takeaway','307.40','4.20','0.00','0.0','1539','202408061541',NULL,NULL,NULL,NULL,NULL,NULL),(1551,'20240806-1-000022','878.40','madmin','2024 08 06','  Pay Later','  Home delivery','870.000000','8.400000','0.000000','0','1540','20240806160003','','','','0','0',NULL),(1552,'20240807-1-000011','221.64','admin','2024 08 07','  Cash','  Dine-in','221.64','7.20','0.00','0.0','1541','202408071308',NULL,NULL,NULL,NULL,NULL,NULL),(1553,'20240808-1-000011','406.64','admin','2024 08 08','  Cash','  Dine-in','406.64','7.20','0.00','0.0','1542','202408081449',NULL,NULL,NULL,NULL,NULL,NULL),(1554,'20240808-1-000012','813.12','admin','2024 08 08','  Cheque','  Home delivery','813.12','21.60','0.00','0.0','1543','202408081501',NULL,NULL,NULL,NULL,NULL,NULL),(1555,'20240808-1-000013','531.64','admin','2024 08 08','  Upiqr','  Home delivery','531.64','7.20','0.00','0.0','1544','202408081502',NULL,NULL,NULL,NULL,NULL,NULL),(1556,'20240808-1-000014','402.44','admin','2024 08 08','  Card','  Home delivery','402.44','3.00','0.00','0.0','1545','202408081631',NULL,NULL,NULL,NULL,NULL,NULL),(1557,'20240808-1-000021','423.40','admin','2024 08 08','  Zeta','  Dine-in','423.40','8.40','0.00','0.0','1546','202408081641',NULL,NULL,NULL,NULL,NULL,NULL),(1558,'20240808-1-000015','435.64','admin','2024 08 08','  Pay Later','  Home delivery','435.64','3.00','0.00','0.0','1547','202408081643',NULL,NULL,NULL,NULL,NULL,NULL),(1559,'20240810-1-000031','180.00','admin','2024 08 10','  Cash','  Home delivery','180.00','0.00','0.00','0.0','1548','202408101752',NULL,NULL,NULL,NULL,NULL,NULL),(1560,'20240810-1-000021','196.64','admin','2024 08 10','  Upiqr','  Takeaway','196.64','7.20','0.00','0.0','1549','202408101754',NULL,NULL,NULL,NULL,NULL,NULL),(1561,'20240810-1-000022','177.44','admin','2024 08 10','  Ticket','  Dine-in','177.44','3.00','0.00','0.0','1550','202408101830',NULL,NULL,NULL,NULL,NULL,NULL),(1562,'20240810-1-000023','292.44','admin','2024 08 10','  Cheque','  Dine-in','292.44','3.00','0.00','0.0','1551','202408101833',NULL,NULL,NULL,NULL,NULL,NULL),(1563,'20240812-1-000011','110.00','admin','2024 08 12','  Cash','  Dine-in','110.00','0.00','0.00','0.0','1552','202408121428',NULL,NULL,NULL,NULL,NULL,NULL),(1564,'20240812-1-000012','100.00','admin','2024 08 12','  Cash','  Dine-in','100.00','0.00','0.00','0.0','1553','202408121429',NULL,NULL,NULL,NULL,NULL,NULL),(1565,'20240812-1-000013','130.00','admin','2024 08 12','  Cash','  Dine-in','130.00','0.00','0.00','0.0','1554','202408121430',NULL,NULL,NULL,NULL,NULL,NULL),(1566,'20240812-1-000014','70.00','admin','2024 08 12','  Cash','  Dine-in','70.00','0.00','0.00','0.0','1555','202408121431',NULL,NULL,NULL,NULL,NULL,NULL),(1567,'20240812-1-000015','180.00','admin','2024 08 12','  Cash','  Dine-in','180.00','0.00','0.00','0.0','1556','202408121431',NULL,NULL,NULL,NULL,NULL,NULL),(1568,'20240812-1-000016','115.00','admin','2024 08 12','  Cash','  Dine-in','115.00','0.00','0.00','0.0','1557','202408121433',NULL,NULL,NULL,NULL,NULL,NULL),(1569,'20240812-1-000017','40.00','admin','2024 08 12','  Cash','  Dine-in','40.00','0.00','0.00','0.0','1558','202408121433',NULL,NULL,NULL,NULL,NULL,NULL),(1570,'20240812-1-000018','40.00','admin','2024 08 12','  Cash','  Dine-in','40.00','0.00','0.00','0.0','1559','202408121434',NULL,NULL,NULL,NULL,NULL,NULL),(1571,'20240812-1-000019','60.00','admin','2024 08 12','  Cash','  Dine-in','60.00','0.00','0.00','0.0','1560','202408121435',NULL,NULL,NULL,NULL,NULL,NULL),(1572,'20240812-1-0000110','96.64','admin','2024 08 12','  Cash','  Dine-in','96.64','7.20','0.00','0.0','1561','202408121437',NULL,NULL,NULL,NULL,NULL,NULL),(1573,'20240812-1-0000111','69.20','admin','2024 08 12','  Cash','  Dine-in','69.20','4.20','0.00','0.0','1562','202408121446',NULL,NULL,NULL,NULL,NULL,NULL),(1574,'20240812-1-0000112','110.48','admin','2024 08 12','  Cash','  Dine-in','110.48','1.67','0.00','0.0','1563','202408121502',NULL,NULL,NULL,NULL,NULL,NULL),(1575,'20240912-1-000021','271.52','admin','2024 09 12','  Card','  Dine-in','271.52','13.20','0.00','0.0','1564','202409121905',NULL,NULL,NULL,NULL,NULL,NULL),(1576,'20240920-1-000021','80.00','admin','2024 09 20','  Upiqr','  Home delivery','80.00','0.00','0.00','0.0','1565','202409201229',NULL,NULL,NULL,NULL,NULL,NULL),(1577,'20240920-1-000022','94.88','admin','2024 09 20','  Cash','  Takeaway','94.88','6.00','0.00','0.0','1566','202409201231',NULL,NULL,NULL,NULL,NULL,NULL),(1578,'20240924-1-000021','102.44','admin','2024 09 24','  Upiqr','  Takeaway','102.44','3.00','0.00','0.0','1567','202409241418',NULL,NULL,NULL,NULL,NULL,NULL),(1579,'20240924-1-000022','65.00','admin','2024 09 24','  Upiqr','  Takeaway','65.00','0.00','0.00','0.0','1568','202409241419',NULL,NULL,NULL,NULL,NULL,NULL),(1580,'20241003-1-000031','74.20','admin','2024 10 03','  Card','  Home delivery','74.20','4.20','0.00','0.0','1569','202410031333',NULL,NULL,NULL,NULL,NULL,NULL),(1581,'20241003-1-000011','124.20','admin','2024 10 03','  Cash','  Home delivery','124.20','4.20','0.00','0.0','1570','202410031337',NULL,NULL,NULL,NULL,NULL,NULL),(1582,'20241003-1-000021','65.00','admin','2024 10 03','  Upiqr','  Home delivery','65.00','0.00','0.00','0.0','1571','202410031342',NULL,NULL,NULL,NULL,NULL,NULL),(1583,'20241010-1-000011','69.20','admin','2024 10 10','  Cash','  Dine-in','69.20','4.20','0.00','0.0','1572','202410101437',NULL,NULL,NULL,NULL,NULL,NULL),(1584,'20241010-1-000012','143.40','admin','2024 10 10','  Cash','  Dine-in','143.40','8.40','0.00','0.0','1573','202410101438',NULL,NULL,NULL,NULL,NULL,NULL),(1585,'20241017-1-000012','210.00','admin','2024 10 17','  Cash','  Dine-in','210.00','0.00','0.00','0.0','1574','202410171159',NULL,NULL,NULL,NULL,NULL,NULL),(1586,'20241017-1-000021','129.20','admin','2024 10 17','  Ticket','  Dine-in','129.20','4.20','0.00','0.0','1575','202410171220',NULL,NULL,NULL,NULL,NULL,NULL),(1587,'20241017-1-000031','130.00','admin','2024 10 17','  Pay Later','  Dine-in','130.00','0.00','0.00','0.0','1576','202410171221',NULL,NULL,NULL,NULL,NULL,NULL),(1588,'20241112-1-000031','142.03','admin','2024 11 12','  Pay Later','  Dine-in','122.44','31.84','0.00','16.0','1577','202411121514',NULL,NULL,NULL,NULL,NULL,NULL),(1589,'20241112-1-000032','58.00','admin','2024 11 12','  Cheque','  Dine-in','50.00','8.00','0.00','16.0','1578','202411121519',NULL,NULL,NULL,NULL,NULL,NULL),(1590,'20241112-1-000033','129.54','admin','2024 11 12','  Upiqr','  Takeaway','111.67','23.47','0.00','16.0','1579','202411121520',NULL,NULL,NULL,NULL,NULL,NULL),(1591,'20241113-1-000031','134.48','admin','2024 11 13','  Card','  Dine-in','115.93','33.75','0.00','16.0','1580','202411131448',NULL,NULL,NULL,NULL,NULL,NULL),(1592,'20241113-1-000011','209.23','admin','2024 11 13','  Pay Later','  Dine-in','180.37','44.51','0.00','16.0','1581','202411131454',NULL,NULL,NULL,NULL,NULL,NULL),(1593,'20241113-1-000021','282.42','admin','2024 11 13','  Cheque','  Dine-in','222.38','78.24','0.00','27.0','1582','202411131654',NULL,NULL,NULL,NULL,NULL,NULL),(1594,'20241113-1-000032','143.18','admin','2024 11 13','  Card','  Takeaway','112.74','45.04','0.00','27.0','1583','202411131656',NULL,NULL,NULL,NULL,NULL,NULL),(1595,'20241114-1-000031','199.99','madmin','2024 11 14','  cash','  Dine-in','144.720000','55.270000','0.000000','39.074994000000004','1584','202411140933','','','','0','0',NULL),(1596,'20241115-1-000121','299.31','madmin','2024 11 15','  card','  Dine-in','228.210000','71.100000','0.000000','61.616699999999994','1585','202411151218','','','','0','0',NULL);
INSERT INTO `cancelwiseorderlistitems` (`_id`, `date`, `time`, `user`, `billno`, `sale`, `refund`, `reason`, `billcount`) VALUES (1,'23 Jul 2024','05:02:48 pm','admin','20240723-1-000011','474.20','105.00','Damaged/Spoiled','1523'),(2,'23 Jul 2024','05:03:41 pm','admin','20240723-1-000012','164.64','164.64','Damaged/Spoiled','1524'),(3,'25 Jul 2024','07:08:46 am','admin','20240725-1-000011','315.00','20.00','Damaged/Spoiled','1524'),(4,'25 Jul 2024','07:09:40 am','admin','20240725-1-000011','295.00','295.00','Accidental charge','1524'),(5,'25 Jul 2024','07:14:46 am','admin','20240725-1-000012','200.00','70.00','Damaged/Spoiled','1524'),(6,'25 Jul 2024','07:15:48 am','admin','20240725-1-000012','130.00','50.00','Accidental charge','1524'),(7,'25 Jul 2024','07:16:55 am','admin','20240725-1-000012','80.00','80.00','Accidental charge','1524'),(8,'05 Jul 2024','09:16:39 am','admin','20240701-1-000012','488.67','488.67','Changed mind','1188'),(9,'03 Jul 2024','10:59:18 am','admin','20240703-1-000011','99.62','99.62','Delayed','1191'),(10,'03 Jul 2024','11:01:43 am','admin','20240703-1-000012','99.62','28.67','Damaged/Spoiled','1192');
INSERT INTO `clicked_cust_name` (`_id`, `name`) VALUES (1,'9998706525');
INSERT INTO `cusotmer_activity_temp_top3` (`_id`, `name`, `phone_no`, `email`, `addr`, `total_amount`, `balance`, `discount_value`, `discount_type`, `approval_rate`) VALUES (712,'John','8854234139','dinesh8914@example.com','Chennai',661,'660.8',NULL,NULL,NULL),(713,'Bala','8843122051','vijay8487@example.com','Tanjore',810,'0.0',NULL,NULL,NULL),(714,'Bala','9788693129','bala9748@example.com','Trichy',668,'0.0',NULL,NULL,NULL),(715,'Babu','9945411069','akshay2585@example.com','Kumbakonam',726,'0.0',NULL,NULL,NULL),(716,'Bala','9823526685','babu6889@example.com','Coimbatore',705,'0.0',NULL,NULL,NULL),(717,'Vasanth','9930621681','karthick3940@example.com','Kumbakonam',624,'624.1',NULL,NULL,NULL),(718,'Dinesh','9692372522','john1300@example.com','Coimbatore',578,'0.0',NULL,NULL,NULL),(719,'David','9760288579','babu7045@example.com','Coimbatore',551,'550.5',NULL,NULL,NULL),(720,'John','9960134019','bala8924@example.com','Coimbatore',831,'0.0',NULL,NULL,NULL),(721,'David','9929281318','karthick8319@example.com','Trichy',804,'0.0',NULL,NULL,NULL),(722,'Babu','9703164292','david8640@example.com','Kumbakonam',573,'0.0',NULL,NULL,NULL),(723,'Bala','8431288973','bala4582@example.com','Trichy',694,'0.0',NULL,NULL,NULL),(724,'Vijay','9719040768','dinesh7827@example.com','Tanjore',651,'0.0',NULL,NULL,NULL),(725,'Babu','9697341210','akshay4089@example.com','Bangalore',849,'0.0',NULL,NULL,NULL),(726,'Vijay','9484159509','vijay9828@example.com','Tanjore',787,'786.5',NULL,NULL,NULL),(727,'Karthick','9979736762','vasanth3337@example.com','Coimbatore',704,'704.0',NULL,NULL,NULL),(728,'Akshay','9866278200','karthick2703@example.com','Salem',732,'0.0',NULL,NULL,NULL),(729,'Akshay','8415764114','akshay3820@example.com','Coimbatore',754,'0.0',NULL,NULL,NULL),(730,'Bala','9800970479','john3888@example.com','Tanjore',578,'0.0',NULL,NULL,NULL),(731,'Babu','8485193257','bala7155@example.com','Chennai',540,'539.5',NULL,NULL,NULL),(732,'John','9837575377','vijay6069@example.com','Chennai',682,'682.0',NULL,NULL,NULL),(733,'Vijay','9886190334','vasanth595@example.com','Kumbakonam',556,'0.0',NULL,NULL,NULL),(734,'Karthick','8309256230','babu4507@example.com','Chennai',628,'0.0',NULL,NULL,NULL),(735,'Dinesh','9938344162','dinesh694@example.com','Trichy',732,'0.0',NULL,NULL,NULL),(736,'David','9733604549','bala3769@example.com','Trichy',700,'699.8',NULL,NULL,NULL),(737,'Bala','9920251841','david2955@example.com','Coimbatore',766,'0.0',NULL,NULL,NULL),(738,'Vasanth','8499170210','dinesh5935@example.com','Coimbatore',756,'0.0',NULL,NULL,NULL),(739,'Vijay','8426965493','karthick5438@example.com','Tanjore',683,'0.0',NULL,NULL,NULL),(740,'Dinesh','8304355031','akshay9110@example.com','Coimbatore',628,'627.8',NULL,NULL,NULL),(741,'Babu','9848336158','babu1235@example.com','Trichy',743,'743.3',NULL,NULL,NULL),(742,'Vasanth','9670969665','john2727@example.com','Bangalore',634,'0.0',NULL,NULL,NULL),(743,'Bala','8441159447','vijay8198@example.com','Tanjore',666,'0.0',NULL,NULL,NULL),(744,'Vijay','8891754956','karthick7854@example.com','Chennai',553,'0.0',NULL,NULL,NULL),(745,'Akshay','9764687735','john9518@example.com','Bangalore',660,'0.0',NULL,NULL,NULL),(746,'Vasanth','9704672322','david1253@example.com','Trichy',567,'567.3',NULL,NULL,NULL),(747,'John','9409914206','john5671@example.com','Bangalore',612,'0.0',NULL,NULL,NULL),(748,'Babu','9784875845','bala5235@example.com','Salem',584,'584.1',NULL,NULL,NULL),(749,'Dinesh','9866376234','john4905@example.com','Chennai',558,'0.0',NULL,NULL,NULL),(750,'Babu','9624724485','babu9839@example.com','Coimbatore',613,'0.0',NULL,NULL,NULL),(751,'Bala','9844563878','vasanth8918@example.com','Coimbatore',842,'842.3',NULL,NULL,NULL),(752,'Dinesh','9451594565','akshay5351@example.com','Trichy',705,'0.0',NULL,NULL,NULL),(753,'Bala','9968568878','karthick8783@example.com','Tanjore',782,'0.0',NULL,NULL,NULL),(754,'Karthick','9838745461','vasanth6045@example.com','Chennai',561,'0.0',NULL,NULL,NULL),(755,'Karthick','9429690699','vijay1065@example.com','Salem',677,'0.0',NULL,NULL,NULL),(756,'Karthick','9819485522','karthick6656@example.com','Salem',583,'0.0',NULL,NULL,NULL),(757,'John','8370813412','bala4933@example.com','Chennai',612,'0.0',NULL,NULL,NULL),(758,'Akshay','8497811986','akshay9023@example.com','Trichy',672,'671.5',NULL,NULL,NULL),(759,'Akshay','8365954214','bala3794@example.com','Chennai',622,'0.0',NULL,NULL,NULL),(760,'David','9406401087','david958@example.com','Trichy',656,'0.0',NULL,NULL,NULL),(761,'Bala','9827149132','vasanth6905@example.com','Trichy',656,'0.0',NULL,NULL,NULL),(762,'David','8470098816','john658@example.com','Coimbatore',705,'0.0',NULL,NULL,NULL),(763,'Vijay','9632000969','karthick2119@example.com','Kumbakonam',732,'0.0',NULL,NULL,NULL),(764,'Babu','9446326032','karthick4574@example.com','Kumbakonam',704,'0.0',NULL,NULL,NULL),(765,'Akshay','9979941186','akshay7321@example.com','Kumbakonam',523,'0.0',NULL,NULL,NULL),(766,'Vasanth','9631687285','david6309@example.com','Tanjore',595,'594.5',NULL,NULL,NULL),(767,'Vasanth','9788784038','karthick6582@example.com','Tanjore',595,'0.0',NULL,NULL,NULL),(768,'Bala','8360211410','karthick3375@example.com','Tanjore',622,'0.0',NULL,NULL,NULL),(769,'Dinesh','9642847293','vasanth1701@example.com','Trichy',661,'0.0',NULL,NULL,NULL),(770,'John','8437533283','david805@example.com','Kumbakonam',649,'0.0',NULL,NULL,NULL),(771,'Akshay','9426982896','karthick6661@example.com','Chennai',728,'0.0',NULL,NULL,NULL),(772,'David','9995530006','vijay3713@example.com','Chennai',485,'0.0',NULL,NULL,NULL),(773,'Vijay','9851155193','karthick4239@example.com','Coimbatore',749,'0.0',NULL,NULL,NULL),(774,'Vijay','8459553152','vijay3099@example.com','Trichy',596,'0.0',NULL,NULL,NULL),(775,'Bala','8358988005','david2830@example.com','Kumbakonam',893,'892.5',NULL,NULL,NULL),(776,'David','9760450120','babu3360@example.com','Coimbatore',649,'649.0',NULL,NULL,NULL),(777,'Vasanth','9881550353','bala2124@example.com','Tanjore',589,'0.0',NULL,NULL,NULL),(778,'David','8803353049','karthick7330@example.com','Kumbakonam',634,'0.0',NULL,NULL,NULL),(779,'John','8478579948','david9872@example.com','Tanjore',765,'764.5',NULL,NULL,NULL),(780,'Bala','9976072968','vasanth1490@example.com','Tanjore',695,'0.0',NULL,NULL,NULL),(781,'Akshay','8488449247','dinesh6260@example.com','Salem',633,'0.0',NULL,NULL,NULL),(782,'Babu','8398581843','karthick702@example.com','Tanjore',605,'0.0',NULL,NULL,NULL),(783,'Dinesh','8303135715','akshay3699@example.com','Chennai',562,'0.0',NULL,NULL,NULL),(784,'David','9929190216','vijay8057@example.com','Salem',551,'0.0',NULL,NULL,NULL),(785,'John','9679700873','babu7619@example.com','Trichy',695,'0.0',NULL,NULL,NULL),(786,'David','8479869741','john817@example.com','Salem',479,'0.0',NULL,NULL,NULL),(787,'Akshay','8440317618','david5096@example.com','Trichy',682,'0.0',NULL,NULL,NULL),(788,'Vasanth','8804724086','akshay7033@example.com','Coimbatore',484,'0.0',NULL,NULL,NULL),(789,'Akshay','9755627252','vasanth4793@example.com','Trichy',666,'665.5',NULL,NULL,NULL),(790,'Karthick','8391088083','akshay5138@example.com','Kumbakonam',765,'0.0',NULL,NULL,NULL),(791,'Vijay','8361534651','babu9406@example.com','Chennai',738,'0.0',NULL,NULL,NULL),(792,'John','8310006779','dinesh5233@example.com','Kumbakonam',644,'0.0',NULL,NULL,NULL),(793,'John','9413278007','babu5110@example.com','Chennai',572,'0.0',NULL,NULL,NULL),(794,'Dinesh','9682177701','vijay3568@example.com','Trichy',689,'0.0',NULL,NULL,NULL),(795,'Vijay','8878184075','akshay5469@example.com','Bangalore',574,'0.0',NULL,NULL,NULL),(796,'David','9932992572','dinesh1037@example.com','Chennai',600,'0.0',NULL,NULL,NULL),(797,'Karthick','9651061733','dinesh9082@example.com','Kumbakonam',677,'0.0',NULL,NULL,NULL),(798,'Vijay','9760090406','karthick533@example.com','Trichy',600,'599.5',NULL,NULL,NULL),(799,'Vijay','8416320291','bala7030@example.com','Kumbakonam',770,'0.0',NULL,NULL,NULL),(800,'Dinesh','9605365020','vasanth2095@example.com','Bangalore',694,'0.0',NULL,NULL,NULL),(801,'Karthick','9459830121','john2814@example.com','Salem',705,'0.0',NULL,NULL,NULL),(802,'Akshay','9869854324','karthick9758@example.com','Kumbakonam',644,'0.0',NULL,NULL,NULL),(803,'Vijay','8416064659','babu2501@example.com','Salem',573,'0.0',NULL,NULL,NULL),(804,'Dinesh','9493313995','karthick7255@example.com','Coimbatore',711,'0.0',NULL,NULL,NULL),(805,'Vasanth','9428949370','akshay4543@example.com','Coimbatore',695,'0.0',NULL,NULL,NULL),(806,'Bala','9413073998','dinesh3891@example.com','Tanjore',677,'676.5',NULL,NULL,NULL),(807,'Vasanth','8318937450','bala5126@example.com','Kumbakonam',783,'0.0',NULL,NULL,NULL),(808,'Vasanth','8872217077','david9991@example.com','Tanjore',524,'523.8',NULL,NULL,NULL),(809,'David','8454843539','john7028@example.com','Chennai',751,'0.0',NULL,NULL,NULL),(810,'Vasanth','9729848337','dinesh8579@example.com','Kumbakonam',485,'0.0',NULL,NULL,NULL),(811,'Bala','9970429438','vasanth7442@example.com','Tanjore',596,'0.0',NULL,NULL,NULL),(812,'Babu','9742570184','bala3593@example.com','Bangalore',710,'0.0',NULL,NULL,NULL),(813,'Karthick','8883660160','dinesh9888@example.com','Chennai',595,'595.3',NULL,NULL,NULL),(814,'Vasanth','8325512331','akshay243@example.com','Bangalore',640,'0.0',NULL,NULL,NULL),(815,'Vijay','8344172464','david1724@example.com','Bangalore',706,'0.0',NULL,NULL,NULL),(816,'Akshay','9783552662','babu9743@example.com','Salem',579,'0.0',NULL,NULL,NULL),(817,'Dinesh','9758037300','vasanth1303@example.com','Tanjore',712,'0.0',NULL,NULL,NULL),(818,'Karthick','9789429093','bala8329@example.com','Bangalore',490,'0.0',NULL,NULL,NULL),(819,'Akshay','9874783015','david9980@example.com','Bangalore',699,'699.3',NULL,NULL,NULL),(820,'Akshay','9699231447','dinesh7763@example.com','Kumbakonam',666,'666.3',NULL,NULL,NULL),(821,'Vijay','9724984914','dinesh561@example.com','Tanjore',628,'0.0',NULL,NULL,NULL),(822,'Babu','8332319304','vasanth7452@example.com','Kumbakonam',799,'0.0',NULL,NULL,NULL),(823,'Akshay','9893629373','akshay3103@example.com','Chennai',564,'0.0',NULL,NULL,NULL),(824,'Babu','9942715019','vasanth6108@example.com','Chennai',644,'0.0',NULL,NULL,NULL),(825,'Babu','8499736713','david1764@example.com','Coimbatore',716,'0.0',NULL,NULL,NULL),(826,'Vasanth','9417046359','karthick9067@example.com','Chennai',767,'0.0',NULL,NULL,NULL),(827,'Akshay','8358049778','john3116@example.com','Kumbakonam',623,'622.6',NULL,NULL,NULL),(828,'Akshay','8374400098','bala4757@example.com','Trichy',464,'0.0',NULL,NULL,NULL),(829,'Akshay','8497412775','akshay1811@example.com','Kumbakonam',618,'0.0',NULL,NULL,NULL),(830,'Babu','9602339217','akshay5925@example.com','Kumbakonam',605,'0.0',NULL,NULL,NULL),(831,'Akshay','8396126143','bala779@example.com','Bangalore',649,'0.0',NULL,NULL,NULL),(832,'Babu','8418500759','akshay2448@example.com','Bangalore',668,'667.6',NULL,NULL,NULL),(833,'Vijay','9627309892','karthick9904@example.com','Tanjore',644,'0.0',NULL,NULL,NULL),(834,'Dinesh','8857260484','bala4649@example.com','Coimbatore',628,'0.0',NULL,NULL,NULL),(835,'Bala','8371987609','karthick5416@example.com','Chennai',683,'0.0',NULL,NULL,NULL),(836,'Dinesh','9787329263','vijay7892@example.com','Kumbakonam',754,'0.0',NULL,NULL,NULL),(837,'Akshay','8305903570','vasanth3287@example.com','Bangalore',699,'0.0',NULL,NULL,NULL),(838,'Karthick','9917172285','bala6641@example.com','Chennai',754,'0.0',NULL,NULL,NULL),(839,'Akshay','9741335440','bala2210@example.com','Kumbakonam',688,'687.5',NULL,NULL,NULL),(840,'Vijay','9846782051','babu7685@example.com','Trichy',606,'0.0',NULL,NULL,NULL),(841,'Vijay','9905087450','karthick176@example.com','Bangalore',738,'0.0',NULL,NULL,NULL),(842,'Bala','8885983631','david8142@example.com','Coimbatore',513,'0.0',NULL,NULL,NULL),(843,'Akshay','9959976575','bala2031@example.com','Kumbakonam',645,'0.0',NULL,NULL,NULL),(844,'Babu','9761722244','bala8105@example.com','Salem',776,'0.0',NULL,NULL,NULL),(845,'Karthick','9976289941','david634@example.com','Tanjore',821,'0.0',NULL,NULL,NULL),(847,'Bala','9740219918','vasanth225@example.com','Tanjore',732,'0.0',NULL,NULL,NULL),(848,'Vasanth','8483898839','vijay8575@example.com','Trichy',671,'671.0',NULL,NULL,NULL),(849,'Vasanth','9462824713','vijay6111@example.com','Bangalore',623,'0.0',NULL,NULL,NULL),(850,'Babu','9448276216','bala5689@example.com','Tanjore',617,'0.0',NULL,NULL,NULL),(851,'David','9733858918','babu7205@example.com','Kumbakonam',574,'0.0',NULL,NULL,NULL),(852,'Akshay','8337124201','john9581@example.com','Chennai',595,'0.0',NULL,NULL,NULL),(853,'Dinesh','8478900213','babu6721@example.com','Bangalore',767,'0.0',NULL,NULL,NULL),(854,'Bala','8333613209','dinesh3798@example.com','Kumbakonam',678,'0.0',NULL,NULL,NULL),(855,'Vijay','9957525694','babu2338@example.com','Kumbakonam',589,'0.0',NULL,NULL,NULL),(856,'Vasanth','9973982379','babu3696@example.com','Trichy',661,'0.0',NULL,NULL,NULL),(857,'David','8859128866','bala9406@example.com','Coimbatore',669,'0.0',NULL,NULL,NULL),(858,'Babu','9858235111','vijay2241@example.com','Kumbakonam',673,'0.0',NULL,NULL,NULL),(859,'Vijay','8417265045','john4766@example.com','Trichy',595,'0.0',NULL,NULL,NULL),(860,'Babu','9467738162','vijay2605@example.com','Salem',749,'0.0',NULL,NULL,NULL),(861,'John','9616335583','karthick7098@example.com','Tanjore',771,'0.0',NULL,NULL,NULL),(862,'Dinesh','9642984934','david9119@example.com','Bangalore',512,'0.0',NULL,NULL,NULL),(863,'John','8359696200','babu1768@example.com','Salem',630,'630.1',NULL,NULL,NULL),(864,'Dinesh','8483056676','karthick2424@example.com','Tanjore',524,'0.0',NULL,NULL,NULL),(865,'Dinesh','9701019837','babu8951@example.com','Tanjore',629,'0.0',NULL,NULL,NULL),(866,'Karthick','8325091457','bala3897@example.com','Chennai',729,'0.0',NULL,NULL,NULL),(867,'David','9818807490','bala9244@example.com','Kumbakonam',772,'0.0',NULL,NULL,NULL),(868,'Vasanth','9943865095','david825@example.com','Chennai',624,'0.0',NULL,NULL,NULL),(869,'Babu','9709663014','vijay6933@example.com','Chennai',573,'0.0',NULL,NULL,NULL),(870,'Dinesh','8353253546','vijay5329@example.com','Tanjore',573,'0.0',NULL,NULL,NULL),(871,'Karthick','9724410332','karthick536@example.com','Tanjore',618,'0.0',NULL,NULL,NULL),(872,'Vijay','8354444315','john2770@example.com','Chennai',584,'0.0',NULL,NULL,NULL),(873,'Vasanth','9905141531','akshay4143@example.com','Tanjore',442,'0.0',NULL,NULL,NULL),(874,'Vijay','9477973547','david610@example.com','Bangalore',595,'595.3',NULL,NULL,NULL),(875,'Vasanth','8332714491','david8065@example.com','Coimbatore',683,'0.0',NULL,NULL,NULL),(876,'Akshay','8389207155','vijay4498@example.com','Coimbatore',843,'0.0',NULL,NULL,NULL),(877,'Vijay','8347582210','david8914@example.com','Trichy',650,'649.5',NULL,NULL,NULL),(878,'Karthick','9779615920','akshay2578@example.com','Salem',826,'0.0',NULL,NULL,NULL),(879,'Akshay','9414398129','vijay4880@example.com','Chennai',633,'0.0',NULL,NULL,NULL),(880,'Dinesh','9689108136','vijay8026@example.com','Kumbakonam',661,'661.1',NULL,NULL,NULL),(882,'Babu','8343047315','john8082@example.com','Salem',628,'627.5',NULL,NULL,NULL),(883,'Babu','9443251661','john1801@example.com','Salem',645,'0.0',NULL,NULL,NULL),(884,'Akshay','9925121202','vasanth4934@example.com','Chennai',684,'0.0',NULL,NULL,NULL),(885,'David','9994325840','dinesh838@example.com','Kumbakonam',662,'0.0',NULL,NULL,NULL),(886,'John','8363366528','akshay6381@example.com','Bangalore',754,'754.0',NULL,NULL,NULL),(887,'Babu','9684556374','bala2597@example.com','Bangalore',553,'0.0',NULL,NULL,NULL),(888,'Karthick','8467035364','akshay6732@example.com','Salem',728,'0.0',NULL,NULL,NULL),(889,'Vijay','8385680672','babu906@example.com','Salem',721,'720.5',NULL,NULL,NULL),(890,'Babu','9417899060','akshay8431@example.com','Salem',833,'0.0',NULL,NULL,NULL),(891,'Vasanth','9852190585','babu7588@example.com','Salem',677,'0.0',NULL,NULL,NULL),(892,'Vijay','9478611025','karthick30@example.com','Bangalore',529,'0.0',NULL,NULL,NULL),(893,'Babu','8430895295','vasanth7165@example.com','Salem',804,'0.0',NULL,NULL,NULL),(894,'Vasanth','9865391407','karthick6163@example.com','Coimbatore',739,'0.0',NULL,NULL,NULL),(895,'Babu','8840689460','vijay3001@example.com','Tanjore',661,'0.0',NULL,NULL,NULL),(896,'Babu','9721957697','dinesh6957@example.com','Kumbakonam',655,'655.3',NULL,NULL,NULL),(897,'David','9993424344','akshay1029@example.com','Tanjore',606,'0.0',NULL,NULL,NULL),(898,'Akshay','9709748715','vasanth2846@example.com','Bangalore',799,'0.0',NULL,NULL,NULL),(899,'Vasanth','9986301130','bala4133@example.com','Tanjore',738,'0.0',NULL,NULL,NULL),(900,'Vijay','8825237440','david4435@example.com','Kumbakonam',683,'0.0',NULL,NULL,NULL),(901,'Babu','9496790860','dinesh4667@example.com','Trichy',608,'0.0',NULL,NULL,NULL),(902,'Akshay','8346564734','bala2818@example.com','Kumbakonam',705,'0.0',NULL,NULL,NULL),(903,'David','9699514625','babu4454@example.com','Chennai',700,'0.0',NULL,NULL,NULL),(904,'Bala','9756854173','david1063@example.com','Chennai',718,'718.2',NULL,NULL,NULL),(905,'Babu','9478260256','akshay944@example.com','Coimbatore',487,'0.0',NULL,NULL,NULL),(906,'David','9464165164','dinesh1302@example.com','Chennai',793,'793.3',NULL,NULL,NULL),(907,'John','8829599336','akshay7376@example.com','Salem',822,'0.0',NULL,NULL,NULL),(908,'Dinesh','8418267160','dinesh1422@example.com','Bangalore',760,'0.0',NULL,NULL,NULL),(909,'Babu','8418330803','david6705@example.com','Tanjore',761,'0.0',NULL,NULL,NULL),(910,'John','9630111603','karthick67@example.com','Salem',662,'0.0',NULL,NULL,NULL),(911,'John','9885172356','vasanth8201@example.com','Trichy',644,'0.0',NULL,NULL,NULL),(912,'Vasanth','9881738279','akshay579@example.com','Salem',777,'0.0',NULL,NULL,NULL),(913,'Akshay','8442609372','akshay9337@example.com','Bangalore',721,'0.0',NULL,NULL,NULL),(914,'David','9426443960','vijay602@example.com','Tanjore',480,'0.0',NULL,NULL,NULL),(915,'Bala','9708039880','david107@example.com','Bangalore',765,'0.0',NULL,NULL,NULL),(916,'Dinesh','9704128941','dinesh9240@example.com','Bangalore',656,'0.0',NULL,NULL,NULL),(917,'John','8473114684','vasanth7486@example.com','Salem',629,'0.0',NULL,NULL,NULL),(918,'Vasanth','8420312191','bala5527@example.com','Kumbakonam',728,'0.0',NULL,NULL,NULL),(919,'Vasanth','9968786091','bala7000@example.com','Chennai',584,'0.0',NULL,NULL,NULL),(920,'Babu','9697984075','john9473@example.com','Salem',650,'650.1',NULL,NULL,NULL),(921,'Karthick','8398257976','vasanth1367@example.com','Coimbatore',535,'0.0',NULL,NULL,NULL),(922,'John','8461086557','john8158@example.com','Coimbatore',562,'0.0',NULL,NULL,NULL),(923,'Bala','9871613939','vijay8630@example.com','Bangalore',572,'0.0',NULL,NULL,NULL),(924,'Karthick','9887913456','vijay4211@example.com','Kumbakonam',727,'0.0',NULL,NULL,NULL),(925,'Vasanth','8863423526','dinesh5272@example.com','Salem',481,'0.0',NULL,NULL,NULL),(926,'John','9474293729','akshay4726@example.com','Tanjore',743,'0.0',NULL,NULL,NULL),(927,'Dinesh','8313574905','karthick5448@example.com','Salem',672,'0.0',NULL,NULL,NULL),(928,'David','8455103233','david1987@example.com','Bangalore',805,'0.0',NULL,NULL,NULL),(929,'Vasanth','8395796029','karthick3950@example.com','Tanjore',458,'457.6',NULL,NULL,NULL),(930,'David','8459867405','karthick7351@example.com','Kumbakonam',776,'0.0',NULL,NULL,NULL),(931,'Dinesh','9452913998','babu6660@example.com','Bangalore',645,'0.0',NULL,NULL,NULL),(932,'Bala','8476713097','akshay3179@example.com','Tanjore',656,'0.0',NULL,NULL,NULL),(933,'Babu','9426994778','karthick6601@example.com','Salem',771,'0.0',NULL,NULL,NULL),(934,'Akshay','9720776984','karthick7519@example.com','Salem',568,'567.6',NULL,NULL,NULL),(935,'David','9802782646','bala2835@example.com','Bangalore',667,'0.0',NULL,NULL,NULL),(936,'Dinesh','9657699888','vasanth9688@example.com','Bangalore',629,'0.0',NULL,NULL,NULL),(937,'David','8411824744','vasanth90@example.com','Salem',711,'0.0',NULL,NULL,NULL),(938,'David','8371739152','david4133@example.com','Tanjore',699,'0.0',NULL,NULL,NULL),(939,'Babu','9482308299','dinesh9374@example.com','Chennai',559,'558.5',NULL,NULL,NULL),(940,'Babu','9779641630','bala504@example.com','Bangalore',683,'0.0',NULL,NULL,NULL),(941,'Babu','9997036357','bala2259@example.com','Coimbatore',690,'0.0',NULL,NULL,NULL),(942,'Vasanth','8805639045','babu8700@example.com','Chennai',540,'0.0',NULL,NULL,NULL),(943,'Karthick','9981119569','bala2292@example.com','Chennai',749,'0.0',NULL,NULL,NULL),(944,'Dinesh','8829515660','karthick4249@example.com','Coimbatore',799,'0.0',NULL,NULL,NULL),(945,'Vijay','9888837982','john7894@example.com','Salem',735,'0.0',NULL,NULL,NULL),(946,'John','9810322558','dinesh5254@example.com','Trichy',596,'595.5',NULL,NULL,NULL),(947,'Vijay','8372162672','vijay5129@example.com','Coimbatore',667,'0.0',NULL,NULL,NULL),(948,'Akshay','9436273740','john3924@example.com','Tanjore',607,'0.0',NULL,NULL,NULL),(949,'Dinesh','8827922973','vijay8088@example.com','Salem',743,'0.0',NULL,NULL,NULL),(950,'Babu','8412336723','vijay9916@example.com','Bangalore',634,'0.0',NULL,NULL,NULL),(951,'Vijay','9737247266','akshay307@example.com','Kumbakonam',695,'0.0',NULL,NULL,NULL),(952,'John','9729863581','akshay2402@example.com','Salem',821,'0.0',NULL,NULL,NULL),(953,'Bala','9738464307','vijay361@example.com','Bangalore',668,'0.0',NULL,NULL,NULL),(954,'Bala','8864449799','akshay1647@example.com','Coimbatore',679,'0.0',NULL,NULL,NULL),(955,'Karthick','9750023177','babu6139@example.com','Salem',767,'766.6',NULL,NULL,NULL),(956,'Karthick','9827004666','babu3232@example.com','Salem',534,'0.0',NULL,NULL,NULL),(957,'Bala','9938978114','john1892@example.com','Salem',594,'0.0',NULL,NULL,NULL),(958,'Akshay','9493994583','babu9812@example.com','Tanjore',633,'0.0',NULL,NULL,NULL),(959,'David','8463519237','david3146@example.com','Chennai',710,'0.0',NULL,NULL,NULL),(960,'John','8471238834','vijay3507@example.com','Tanjore',606,'0.0',NULL,NULL,NULL),(961,'Babu','9651540431','bala48@example.com','Chennai',634,'0.0',NULL,NULL,NULL),(962,'Karthick','8337556057','vasanth4674@example.com','Salem',578,'0.0',NULL,NULL,NULL),(963,'Vasanth','9842925195','dinesh4794@example.com','Coimbatore',590,'0.0',NULL,NULL,NULL),(964,'Akshay','8401624167','david8051@example.com','Kumbakonam',634,'633.6',NULL,NULL,NULL),(965,'Akshay','9801955942','bala6564@example.com','Bangalore',644,'0.0',NULL,NULL,NULL),(966,'David','9969661337','karthick356@example.com','Salem',694,'0.0',NULL,NULL,NULL),(967,'David','9616768314','vasanth2202@example.com','Tanjore',567,'566.5',NULL,NULL,NULL),(968,'Akshay','8855744843','akshay2478@example.com','Coimbatore',640,'0.0',NULL,NULL,NULL),(969,'Dinesh','8450527577','akshay5895@example.com','Tanjore',678,'677.6',NULL,NULL,NULL),(970,'Karthick','9444452184','vasanth8496@example.com','Salem',644,'0.0',NULL,NULL,NULL),(971,'Babu','8853621291','david442@example.com','Kumbakonam',641,'0.0',NULL,NULL,NULL),(972,'Babu','9699794401','david5847@example.com','Tanjore',656,'0.0',NULL,NULL,NULL),(973,'John','9426546316','vijay6189@example.com','Chennai',694,'0.0',NULL,NULL,NULL),(974,'David','8483651907','akshay3654@example.com','Kumbakonam',693,'0.0',NULL,NULL,NULL),(975,'David','9790169405','vijay8455@example.com','Tanjore',639,'639.3',NULL,NULL,NULL),(976,'David','9840296215','david7867@example.com','Tanjore',684,'683.5',NULL,NULL,NULL),(977,'David','9816338515','bala3776@example.com','Chennai',629,'628.5',NULL,NULL,NULL),(978,'Karthick','8467961613','akshay3072@example.com','Salem',717,'0.0',NULL,NULL,NULL),(979,'Vijay','8473670617','akshay1925@example.com','Trichy',633,'0.0',NULL,NULL,NULL),(980,'Bala','9889819610','david2249@example.com','Coimbatore',718,'0.0',NULL,NULL,NULL),(981,'Bala','9745025973','vijay5412@example.com','Chennai',721,'0.0',NULL,NULL,NULL),(982,'Dinesh','9864657820','dinesh211@example.com','Chennai',678,'0.0',NULL,NULL,NULL),(983,'Karthick','8867002117','babu8504@example.com','Bangalore',722,'721.8',NULL,NULL,NULL),(984,'Vijay','9628950989','karthick6453@example.com','Trichy',567,'0.0',NULL,NULL,NULL),(985,'Babu','9413448308','bala8371@example.com','Coimbatore',673,'0.0',NULL,NULL,NULL),(986,'Vijay','9935247546','babu3683@example.com','Coimbatore',666,'0.0',NULL,NULL,NULL),(987,'Vijay','9828865643','dinesh8004@example.com','Kumbakonam',628,'0.0',NULL,NULL,NULL),(988,'Karthick','8351962439','vasanth7812@example.com','Trichy',628,'0.0',NULL,NULL,NULL),(989,'Vasanth','9889494881','dinesh2638@example.com','Tanjore',771,'0.0',NULL,NULL,NULL),(990,'Karthick','9818615286','akshay1234@example.com','Bangalore',668,'0.0',NULL,NULL,NULL),(991,'Babu','9883332160','akshay2851@example.com','Chennai',573,'0.0',NULL,NULL,NULL),(992,'David','9954339515','dinesh1504@example.com','Salem',635,'0.0',NULL,NULL,NULL),(993,'Dinesh','8890825297','vasanth9979@example.com','Trichy',678,'0.0',NULL,NULL,NULL),(994,'Dinesh','9723335190','babu1276@example.com','Kumbakonam',777,'0.0',NULL,NULL,NULL),(995,'David','9631630020','babu9314@example.com','Coimbatore',661,'0.0',NULL,NULL,NULL),(996,'Akshay','8363864999','bala4851@example.com','Tanjore',600,'0.0',NULL,NULL,NULL),(997,'John','8304404839','akshay3924@example.com','Coimbatore',689,'689.0',NULL,NULL,NULL),(998,'Dinesh','8325980855','vasanth447@example.com','Chennai',864,'0.0',NULL,NULL,NULL),(999,'Karthick','9754114249','akshay5988@example.com','Coimbatore',651,'0.0',NULL,NULL,NULL),(1000,'Bala','8382151651','vijay8734@example.com','Bangalore',688,'688.3',NULL,NULL,NULL),(1001,'Dinesh','8889263687','vijay6585@example.com','Salem',518,'0.0',NULL,NULL,NULL),(1002,'Karthick','9969818077','vijay9405@example.com','Salem',639,'0.0',NULL,NULL,NULL),(1003,'Vasanth','9919307695','dinesh6714@example.com','Tanjore',514,'0.0',NULL,NULL,NULL),(1004,'Babu','9643675303','john3008@example.com','Salem',704,'0.0',NULL,NULL,NULL),(1005,'Vasanth','8820298258','dinesh7991@example.com','Bangalore',766,'0.0',NULL,NULL,NULL),(1006,'David','8490631477','karthick46@example.com','Tanjore',551,'0.0',NULL,NULL,NULL),(1007,'David','8334675628','bala425@example.com','Trichy',810,'0.0',NULL,NULL,NULL),(1008,'John','8886568528','bala2158@example.com','Tanjore',701,'0.0',NULL,NULL,NULL),(1009,'Dinesh','9416066009','john6303@example.com','Coimbatore',667,'0.0',NULL,NULL,NULL),(1010,'Dinesh','9422941379','bala8540@example.com','Kumbakonam',617,'0.0',NULL,NULL,NULL),(1011,'Bala','9990043650','dinesh2780@example.com','Chennai',563,'0.0',NULL,NULL,NULL),(1012,'Arun','8466555267','bala5191@example.com','Kumbakonam',737,'737.0',NULL,NULL,NULL),(1013,'Suriya','8404137596','karthick5955@example.com','Bangalore',700,'0.0',NULL,NULL,NULL),(1014,'Kavin','9913192739','john1895@example.com','Trichy',726,'0.0',NULL,NULL,NULL),(1015,'Babu','8832975351','dinesh307@example.com','Salem',540,'0.0',NULL,NULL,NULL),(1016,'David','9922917436','vijay6862@example.com','Salem',489,'0.0',NULL,NULL,NULL),(1017,'Bala','8854438220','dinesh873@example.com','Salem',189,'188.7',NULL,NULL,NULL),(1018,'Prakash','8432760946','vasanth2790@example.com','Bangalore',198,'0.0',NULL,NULL,NULL),(1019,'Shyam','9685747485','shyam@gmail.com','delhi',140,'0.0',NULL,NULL,NULL),(1020,'Akshay','9463645215','david1774@example.com','Coimbatore',195,'0.0',NULL,NULL,NULL),(1021,'John','9479639136','dinesh1954@example.com','Bangalore',201,'200.9',NULL,NULL,NULL),(1023,'Mani','8397648270','akshay502@example.com','Tanjore',180,'0.0',NULL,NULL,NULL),(1024,'Mohan','8382583766','vasanth8820@example.com','Bangalore',205,'0.0',NULL,NULL,NULL),(1025,'Arun','9495204980','john6664@example.com','Bangalore',171,'0.0',NULL,NULL,NULL),(1026,'Akshay','9744755586','vijay4613@example.com','Salem',206,'0.0',NULL,NULL,NULL),(1027,'Mohan','9855279775','bala8876@example.com','Salem',216,'215.9',NULL,NULL,NULL),(1028,'Saravanan','9712207448','bala4237@example.com','Coimbatore',208,'0.0',NULL,NULL,NULL),(1029,'Arun','9404201868','vijay4346@example.com','Kumbakonam',191,'0.0',NULL,NULL,NULL),(1030,'Kumar','9904584962','dinesh6976@example.com','Tanjore',164,'0.0',NULL,NULL,NULL),(1031,'David','9699383797','john2745@example.com','Coimbatore',216,'0.0',NULL,NULL,NULL),(1032,'Mohan','9434445670','dinesh9892@example.com','Tanjore',180,'0.0',NULL,NULL,NULL),(1033,'Vignesh','9725474740','dinesh6581@example.com','Trichy',204,'203.7',NULL,NULL,NULL),(1034,'Vasanth','9763995762','vijay8368@example.com','Trichy',174,'0.0',NULL,NULL,NULL),(1035,'Vijay','8830894362','karthick7920@example.com','Trichy',193,'0.0',NULL,NULL,NULL),(1036,'Dinesh','8479531136','vasanth8107@example.com','Bangalore',190,'0.0',NULL,NULL,NULL),(1037,'Vignesh','8358995381','karthick8586@example.com','Bangalore',200,'0.0',NULL,NULL,NULL),(1038,'Vijay','8896748684','david3890@example.com','Trichy',180,'0.0',NULL,NULL,NULL),(1039,'Saravanan','9996068167','karthick24@example.com','Tanjore',200,'0.0',NULL,NULL,NULL),(1041,'Arjun','9985504011','babu6510@example.com','Chennai',194,'0.0',NULL,NULL,NULL),(1042,'Vignesh','8300796082','babu9235@example.com','Bangalore',195,'0.0',NULL,NULL,NULL),(1043,'Gopal','9972823647','bala5038@example.com','Coimbatore',185,'0.0',NULL,NULL,NULL),(1044,'Suriya','8867412124','vasanth6287@example.com','Tanjore',184,'0.0',NULL,NULL,NULL),(1045,'Arjun','9690242818','vijay2186@example.com','Salem',205,'0.0',NULL,NULL,NULL),(1046,'Bala','9859923087','bala4429@example.com','Salem',171,'0.0',NULL,NULL,NULL),(1047,'Vijay','9795485127','akshay7657@example.com','Bangalore',200,'0.0',NULL,NULL,NULL),(1048,'Kumar','9803063292','vasanth4908@example.com','Tanjore',196,'0.0',NULL,NULL,NULL),(1049,'Kumar','9467525797','babu5908@example.com','Kumbakonam',195,'0.0',NULL,NULL,NULL),(1050,'Bala','8483267503','babu1875@example.com','Tanjore',191,'0.0',NULL,NULL,NULL),(1051,'Karthick','9957611877','john4927@example.com','Bangalore',184,'183.7',NULL,NULL,NULL),(1052,'Arun','9842491262','karthick1925@example.com','Kumbakonam',222,'0.0',NULL,NULL,NULL),(1053,'Saravanan','8317020538','vijay4715@example.com','Chennai',212,'211.9',NULL,NULL,NULL),(1054,'Bala','9614320062','babu3434@example.com','Trichy',211,'0.0',NULL,NULL,NULL),(1055,'Dinesh','9489271771','david7875@example.com','Bangalore',179,'0.0',NULL,NULL,NULL),(1056,'Vijay','8865556351','babu856@example.com','Coimbatore',180,'0.0',NULL,NULL,NULL),(1057,'Bala','9468721136','karthick2461@example.com','Coimbatore',211,'0.0',NULL,NULL,NULL),(1058,'Kumar','8342837784','karthick9505@example.com','Chennai',190,'0.0',NULL,NULL,NULL),(1059,'Suriya','9796521008','karthick4806@example.com','Chennai',212,'0.0',NULL,NULL,NULL),(1060,'Akshay','9921914435','vijay9922@example.com','Kumbakonam',189,'0.0',NULL,NULL,NULL),(1061,'Prakash','9403967710','vasanth7000@example.com','Bangalore',190,'0.0',NULL,NULL,NULL),(1062,'Babu','9953633193','john5176@example.com','Salem',216,'215.6',NULL,NULL,NULL),(1063,'Vasanth','9753511571','vijay1781@example.com','Trichy',203,'203.3',NULL,NULL,NULL),(1065,'Mohan','9975915722','john4855@example.com','Kumbakonam',191,'190.9',NULL,NULL,NULL),(1066,'Dinesh','9966381137','akshay7168@example.com','Tanjore',205,'0.0',NULL,NULL,NULL),(1067,'Suriya','9729128395','karthick4008@example.com','Kumbakonam',196,'0.0',NULL,NULL,NULL),(1068,'Saravanan','9409225281','bala6646@example.com','Salem',200,'200.0',NULL,NULL,NULL),(1069,'John','9705084392','dinesh2866@example.com','Salem',201,'200.9',NULL,NULL,NULL),(1070,'Kavin','9635308084','karthick9059@example.com','Coimbatore',233,'0.0',NULL,NULL,NULL),(1071,'Kavin','9763011669','vijay6259@example.com','Tanjore',195,'0.0',NULL,NULL,NULL),(1072,'Kavin','9491504215','dinesh9446@example.com','Chennai',179,'178.7',NULL,NULL,NULL),(1073,'Vasanth','9452301874','vasanth8558@example.com','Coimbatore',185,'0.0',NULL,NULL,NULL),(1074,'Saravanan','8477326583','bala455@example.com','Salem',212,'0.0',NULL,NULL,NULL),(1075,'Mani','9414259796','babu389@example.com','Salem',181,'0.0',NULL,NULL,NULL),(1076,'Suriya','9951512125','dinesh4966@example.com','Bangalore',228,'227.9',NULL,NULL,NULL),(1077,'Vijay','8858204609','vasanth1526@example.com','Kumbakonam',175,'0.0',NULL,NULL,NULL),(1078,'Gopal','8463657685','vasanth1105@example.com','Coimbatore',182,'0.0',NULL,NULL,NULL),(1079,'Arun','9866513375','babu4848@example.com','Bangalore',191,'0.0',NULL,NULL,NULL),(1080,'Mohan','9933423229','babu5240@example.com','Coimbatore',194,'193.7',NULL,NULL,NULL),(1081,'Mani','9713241906','dinesh6415@example.com','Trichy',206,'0.0',NULL,NULL,NULL),(1082,'Arun','8488130550','david3631@example.com','Coimbatore',206,'0.0',NULL,NULL,NULL),(1083,'Saravanan','9808771519','dinesh4462@example.com','Tanjore',210,'0.0',NULL,NULL,NULL),(1084,'David','9940533488','john3933@example.com','Trichy',200,'0.0',NULL,NULL,NULL),(1085,'Saravanan','8411680564','karthick4284@example.com','Salem',169,'168.7',NULL,NULL,NULL),(1086,'Kumar','9989472975','bala5609@example.com','Bangalore',204,'0.0',NULL,NULL,NULL),(1087,'Mani','8854915271','akshay6109@example.com','Bangalore',199,'0.0',NULL,NULL,NULL),(1088,'Suriya','8856769163','bala6894@example.com','Chennai',205,'0.0',NULL,NULL,NULL),(1089,'Arjun','9883389155','akshay2519@example.com','Kumbakonam',201,'0.0',NULL,NULL,NULL),(1090,'David','8389860010','vasanth7823@example.com','Tanjore',189,'188.7',NULL,NULL,NULL),(1092,'Mohan','9402462620','david8021@example.com','Kumbakonam',201,'0.0',NULL,NULL,NULL),(1093,'Kumar','9429085291','vasanth1529@example.com','Bangalore',199,'0.0',NULL,NULL,NULL),(1094,'Prakash','8306059045','john190@example.com','Trichy',182,'182.3',NULL,NULL,NULL),(1095,'Prakash','9893595160','david8435@example.com','Chennai',202,'0.0',NULL,NULL,NULL),(1096,'Arjun','9995517130','vasanth3682@example.com','Trichy',191,'190.9',NULL,NULL,NULL),(1097,'Akshay','9479199070','akshay4218@example.com','Salem',205,'0.0',NULL,NULL,NULL),(1098,'Babu','9773650509','david6858@example.com','Salem',210,'0.0',NULL,NULL,NULL),(1099,'Saravanan','8889872094','john3009@example.com','Tanjore',200,'0.0',NULL,NULL,NULL),(1100,'Karthick','9784911259','john1201@example.com','Trichy',196,'0.0',NULL,NULL,NULL),(1101,'Vasanth','9614007760','john6688@example.com','Chennai',206,'205.6',NULL,NULL,NULL),(1102,'Arjun','9787513593','babu9261@example.com','Coimbatore',200,'0.0',NULL,NULL,NULL),(1103,'Dinesh','8484735743','karthick7170@example.com','Bangalore',169,'0.0',NULL,NULL,NULL),(1104,'Akshay','8823217978','akshay3893@example.com','Tanjore',221,'220.6',NULL,NULL,NULL),(1106,'Prakash','9913028113','john4532@example.com','Bangalore',217,'0.0',NULL,NULL,NULL),(1107,'Vignesh','8496448188','dinesh384@example.com','Kumbakonam',192,'0.0',NULL,NULL,NULL),(1108,'John','8407367563','babu4022@example.com','Trichy',200,'0.0',NULL,NULL,NULL),(1109,'Mani','9497681751','karthick6700@example.com','Trichy',200,'0.0',NULL,NULL,NULL),(1110,'Babu','9420815180','dinesh8849@example.com','Chennai',201,'0.0',NULL,NULL,NULL),(1111,'Saravanan','9678480011','babu3897@example.com','Bangalore',201,'0.0',NULL,NULL,NULL),(1112,'Dinesh','9797797210','karthick448@example.com','Trichy',197,'197.3',NULL,NULL,NULL),(1113,'John','9498681272','david1949@example.com','Trichy',187,'0.0',NULL,NULL,NULL),(1114,'Vijay','9997731041','babu6068@example.com','Bangalore',193,'0.0',NULL,NULL,NULL),(1115,'Vijay','8322289531','bala9804@example.com','Trichy',185,'0.0',NULL,NULL,NULL),(1116,'Arjun','9730211296','john4106@example.com','Bangalore',211,'0.0',NULL,NULL,NULL),(1117,'John','9606754264','dinesh621@example.com','Coimbatore',195,'0.0',NULL,NULL,NULL),(1118,'Bala','9682027560','dinesh2903@example.com','Tanjore',196,'0.0',NULL,NULL,NULL),(1119,'Suriya','9789052559','vasanth2559@example.com','Trichy',215,'0.0',NULL,NULL,NULL),(1120,'Kavin','9405477887','karthick6929@example.com','Salem',179,'0.0',NULL,NULL,NULL),(1121,'Babu','9787355005','john214@example.com','Salem',200,'0.0',NULL,NULL,NULL),(1122,'Karthick','8871278673','dinesh7807@example.com','Salem',180,'0.0',NULL,NULL,NULL),(1123,'Babu','8866483182','dinesh7939@example.com','Coimbatore',190,'0.0',NULL,NULL,NULL),(1124,'Dinesh','9604007287','karthick1238@example.com','Bangalore',170,'0.0',NULL,NULL,NULL),(1125,'David','9618325509','david9165@example.com','Trichy',190,'0.0',NULL,NULL,NULL),(1126,'Saravanan','9660730241','vijay6890@example.com','Trichy',206,'0.0',NULL,NULL,NULL),(1127,'Mani','9756272879','babu7154@example.com','Coimbatore',176,'0.0',NULL,NULL,NULL),(1128,'Vijay','9873369307','dinesh4397@example.com','Salem',196,'0.0',NULL,NULL,NULL),(1129,'Suriya','9733211185','karthick2972@example.com','Chennai',202,'0.0',NULL,NULL,NULL),(1130,'Vasanth','9479226620','john2345@example.com','Tanjore',187,'0.0',NULL,NULL,NULL),(1131,'Suriya','9427115783','karthick5944@example.com','Bangalore',208,'0.0',NULL,NULL,NULL),(1132,'David','9497678741','john6147@example.com','Coimbatore',187,'0.0',NULL,NULL,NULL),(1133,'Saravanan','9479148143','vijay3737@example.com','Chennai',212,'0.0',NULL,NULL,NULL),(1134,'Bala','9488969700','david7400@example.com','Tanjore',184,'0.0',NULL,NULL,NULL),(1135,'John','9455080188','karthick3214@example.com','Trichy',195,'195.0',NULL,NULL,NULL),(1136,'Dinesh','9790070688','david866@example.com','Coimbatore',180,'179.6',NULL,NULL,NULL),(1137,'Prakash','9939794024','bala9625@example.com','Tanjore',186,'0.0',NULL,NULL,NULL),(1138,'Arun','8413796323','akshay7373@example.com','Salem',206,'0.0',NULL,NULL,NULL),(1139,'John','9841446013','john1172@example.com','Bangalore',197,'197.3',NULL,NULL,NULL),(1141,'Saravanan','8494480454','john8988@example.com','Trichy',191,'190.9',NULL,NULL,NULL),(1142,'Vasanth','8353230780','john7377@example.com','Coimbatore',192,'0.0',NULL,NULL,NULL),(1143,'Vasanth','8300381142','david7593@example.com','Tanjore',217,'0.0',NULL,NULL,NULL),(1144,'Kavin','9749258321','david9268@example.com','Coimbatore',177,'0.0',NULL,NULL,NULL),(1145,'Vasanth','9488072420','vasanth8111@example.com','Kumbakonam',190,'0.0',NULL,NULL,NULL),(1146,'Kumar','8419049505','babu4697@example.com','Trichy',200,'0.0',NULL,NULL,NULL),(1147,'Arun','8800036016','karthick6398@example.com','Bangalore',174,'0.0',NULL,NULL,NULL),(1148,'Prakash','9485216325','babu1749@example.com','Salem',199,'0.0',NULL,NULL,NULL),(1149,'Mani','8840741110','vijay1120@example.com','Chennai',190,'190.0',NULL,NULL,NULL),(1150,'Karthick','9453338898','john2728@example.com','Bangalore',184,'0.0',NULL,NULL,NULL),(1151,'Gopal','9867730856','dinesh2938@example.com','Tanjore',210,'0.0',NULL,NULL,NULL),(1152,'Kavin','9480822936','david5382@example.com','Salem',205,'0.0',NULL,NULL,NULL),(1153,'Kavin','9466724104','vijay1055@example.com','Salem',210,'0.0',NULL,NULL,NULL),(1154,'Vignesh','9854695610','akshay4491@example.com','Coimbatore',208,'207.9',NULL,NULL,NULL),(1155,'Karthick','9739256293','dinesh6739@example.com','Salem',187,'0.0',NULL,NULL,NULL),(1156,'John','9493869196','karthick3579@example.com','Chennai',231,'0.0',NULL,NULL,NULL),(1157,'Akshay','8344628825','karthick5488@example.com','Chennai',195,'194.6',NULL,NULL,NULL),(1158,'Arun','9473908644','david8523@example.com','Tanjore',202,'0.0',NULL,NULL,NULL),(1159,'Bala','9773308888','dinesh7015@example.com','Kumbakonam',164,'0.0',NULL,NULL,NULL),(1160,'Saravanan','9900595879','dinesh5174@example.com','Trichy',205,'0.0',NULL,NULL,NULL),(1161,'Bala','9988355776','dinesh8936@example.com','Tanjore',185,'0.0',NULL,NULL,NULL),(1163,'Arjun','8385844362','john3916@example.com','Kumbakonam',191,'0.0',NULL,NULL,NULL),(1164,'Kumar','9707366890','babu1356@example.com','Kumbakonam',184,'0.0',NULL,NULL,NULL),(1165,'Karthick','9965403145','bala2639@example.com','Kumbakonam',225,'224.6',NULL,NULL,NULL),(1166,'Vignesh','9859373446','john5473@example.com','Chennai',175,'0.0',NULL,NULL,NULL),(1167,'Akshay','8836792386','vasanth1872@example.com','Chennai',195,'0.0',NULL,NULL,NULL),(1168,'Prakash','9618778064','babu294@example.com','Bangalore',195,'0.0',NULL,NULL,NULL),(1169,'Dinesh','9691469659','david1750@example.com','Tanjore',206,'0.0',NULL,NULL,NULL),(1170,'Karthick','9620992925','karthick1280@example.com','Chennai',189,'0.0',NULL,NULL,NULL),(1171,'Mani','9699508955','dinesh5196@example.com','Trichy',195,'194.6',NULL,NULL,NULL),(1172,'Gopal','9681554376','vijay5988@example.com','Kumbakonam',184,'0.0',NULL,NULL,NULL),(1173,'Prakash','8897517333','karthick649@example.com','Coimbatore',209,'0.0',NULL,NULL,NULL),(1174,'Prakash','9406732647','karthick5880@example.com','Chennai',170,'0.0',NULL,NULL,NULL),(1175,'Karthick','9819971753','bala5899@example.com','Tanjore',221,'220.6',NULL,NULL,NULL),(1176,'Saravanan','8453599945','babu4343@example.com','Tanjore',208,'0.0',NULL,NULL,NULL),(1177,'Vijay','8428848505','akshay9510@example.com','Tanjore',210,'0.0',NULL,NULL,NULL),(1178,'Dinesh','9469850810','vijay8048@example.com','Kumbakonam',199,'0.0',NULL,NULL,NULL),(1179,'Vasanth','9485160650','dinesh7702@example.com','Tanjore',170,'0.0',NULL,NULL,NULL),(1180,'Bala','9801082357','akshay9779@example.com','Chennai',174,'0.0',NULL,NULL,NULL),(1181,'Mohan','9994750555','babu5429@example.com','Coimbatore',189,'0.0',NULL,NULL,NULL),(1182,'Akshay','8820871789','dinesh9832@example.com','Trichy',199,'0.0',NULL,NULL,NULL),(1183,'Suriya','9405845429','david4080@example.com','Kumbakonam',184,'0.0',NULL,NULL,NULL),(1184,'John','9952183549','dinesh126@example.com','Trichy',184,'0.0',NULL,NULL,NULL),(1185,'Kavin','8451101231','akshay438@example.com','Chennai',200,'0.0',NULL,NULL,NULL),(1186,'Arun','9833086539','bala3151@example.com','Bangalore',211,'210.9',NULL,NULL,NULL),(1187,'Gopal','8833763748','john5545@example.com','Salem',191,'0.0',NULL,NULL,NULL),(1188,'Prakash','9899310436','david152@example.com','Chennai',201,'0.0',NULL,NULL,NULL),(1189,'Karthick','9848973445','akshay2445@example.com','Chennai',206,'0.0',NULL,NULL,NULL),(1190,'Prakash','9836519077','karthick8063@example.com','Tanjore',159,'0.0',NULL,NULL,NULL),(1191,'Suriya','9711717493','karthick8740@example.com','Bangalore',174,'0.0',NULL,NULL,NULL),(1192,'Babu','8452400934','david2262@example.com','Salem',191,'0.0',NULL,NULL,NULL),(1193,'Dinesh','8884344649','karthick7606@example.com','Chennai',179,'0.0',NULL,NULL,NULL),(1194,'David','9914114460','vijay8281@example.com','Salem',215,'0.0',NULL,NULL,NULL),(1195,'Prakash','8387860259','vijay1317@example.com','Tanjore',193,'0.0',NULL,NULL,NULL),(1197,'Dinesh','8433098216','vijay5413@example.com','Chennai',191,'190.6',NULL,NULL,NULL),(1198,'Kavin','8872386611','babu5063@example.com','Tanjore',191,'0.0',NULL,NULL,NULL),(1200,'Vignesh','9813716075','vijay7714@example.com','Bangalore',179,'178.7',NULL,NULL,NULL),(1201,'Mohan','8801531769','babu1468@example.com','Kumbakonam',199,'0.0',NULL,NULL,NULL),(1202,'Vasanth','8397483272','bala2259@example.com','Trichy',200,'0.0',NULL,NULL,NULL),(1203,'Babu','9602554041','bala3352@example.com','Tanjore',187,'0.0',NULL,NULL,NULL),(1204,'Karthick','8827036785','dinesh288@example.com','Bangalore',205,'0.0',NULL,NULL,NULL),(1205,'Arun','8841226419','vijay4371@example.com','Bangalore',212,'211.9',NULL,NULL,NULL),(1206,'Suriya','8446178411','dinesh6141@example.com','Trichy',200,'0.0',NULL,NULL,NULL),(1207,'John','9663813944','akshay4783@example.com','Chennai',166,'0.0',NULL,NULL,NULL),(1209,'John','9785365826','dinesh3548@example.com','Coimbatore',184,'0.0',NULL,NULL,NULL),(1210,'Arjun','8435796103','babu9855@example.com','Chennai',195,'0.0',NULL,NULL,NULL),(1211,'Vignesh','9605556846','john4551@example.com','Trichy',169,'0.0',NULL,NULL,NULL),(1212,'Saravanan','9964405073','dinesh6965@example.com','Kumbakonam',178,'0.0',NULL,NULL,NULL),(1213,'Akshay','9617317387','bala2873@example.com','Tanjore',184,'0.0',NULL,NULL,NULL),(1214,'Arun','9987803837','david6482@example.com','Kumbakonam',176,'0.0',NULL,NULL,NULL),(1215,'Mohan','8384039941','john9292@example.com','Trichy',182,'0.0',NULL,NULL,NULL),(1217,'Saravanan','8308603255','vasanth9003@example.com','Trichy',212,'0.0',NULL,NULL,NULL),(1218,'Mani','8424928167','david1971@example.com','Coimbatore',212,'0.0',NULL,NULL,NULL),(1219,'Vignesh','9905061731','john8955@example.com','Kumbakonam',190,'0.0',NULL,NULL,NULL),(1220,'Karthick','9912646647','karthick9205@example.com','Kumbakonam',196,'195.9',NULL,NULL,NULL),(1221,'Gopal','9649181999','dinesh6570@example.com','Tanjore',179,'178.7',NULL,NULL,NULL),(1223,'Bala','8396750913','vasanth2223@example.com','Kumbakonam',190,'0.0',NULL,NULL,NULL),(1224,'Mohan','9629943374','akshay287@example.com','Chennai',217,'216.9',NULL,NULL,NULL),(1225,'Prakash','8403136425','bala5235@example.com','Salem',206,'0.0',NULL,NULL,NULL),(1226,'Vignesh','9627601102','akshay7814@example.com','Bangalore',187,'0.0',NULL,NULL,NULL),(1227,'Vijay','8303917343','dinesh1862@example.com','Trichy',189,'0.0',NULL,NULL,NULL),(1228,'Kavin','8319973292','babu2877@example.com','Bangalore',211,'0.0',NULL,NULL,NULL),(1229,'Mani','9895243961','dinesh9191@example.com','Trichy',202,'0.0',NULL,NULL,NULL),(1230,'Prakash','8800241841','akshay4353@example.com','Tanjore',179,'0.0',NULL,NULL,NULL),(1231,'Bala','8360968446','bala3620@example.com','Bangalore',180,'0.0',NULL,NULL,NULL),(1232,'Akshay','8314946896','babu5867@example.com','Bangalore',223,'222.9',NULL,NULL,NULL),(1233,'Mohan','9865379208','karthick829@example.com','Trichy',180,'0.0',NULL,NULL,NULL),(1234,'Saravanan','9924317582','vasanth8420@example.com','Bangalore',216,'0.0',NULL,NULL,NULL),(1235,'Kumar','8833932906','bala882@example.com','Trichy',177,'0.0',NULL,NULL,NULL),(1236,'Akshay','8331640487','bala95@example.com','Coimbatore',210,'0.0',NULL,NULL,NULL),(1237,'John','8831492651','john489@example.com','Coimbatore',187,'0.0',NULL,NULL,NULL),(1238,'Kumar','9986635386','vasanth2913@example.com','Salem',215,'214.6',NULL,NULL,NULL),(1239,'Gopal','9896973890','karthick7143@example.com','Trichy',202,'0.0',NULL,NULL,NULL),(1240,'Mani','9804267095','babu1966@example.com','Tanjore',177,'0.0',NULL,NULL,NULL),(1241,'Arun','9856079346','david2773@example.com','Trichy',189,'0.0',NULL,NULL,NULL),(1242,'Kumar','9925809916','akshay1890@example.com','Trichy',188,'188.3',NULL,NULL,NULL),(1243,'Suriya','8443468779','vijay1587@example.com','Salem',180,'0.0',NULL,NULL,NULL),(1244,'Suriya','8845269099','dinesh4787@example.com','Kumbakonam',195,'0.0',NULL,NULL,NULL),(1245,'Akshay','9616869389','karthick8098@example.com','Salem',204,'0.0',NULL,NULL,NULL),(1246,'Vignesh','9797919770','babu5411@example.com','Coimbatore',201,'0.0',NULL,NULL,NULL),(1247,'John','8830490302','akshay6675@example.com','Salem',188,'0.0',NULL,NULL,NULL),(1248,'Saravanan','8308685934','babu3571@example.com','Chennai',212,'0.0',NULL,NULL,NULL),(1250,'Arjun','9919710574','vasanth5749@example.com','Coimbatore',185,'184.6',NULL,NULL,NULL),(1251,'Bala','8853281830','david1462@example.com','Salem',212,'0.0',NULL,NULL,NULL),(1252,'John','9830902809','vasanth9294@example.com','Bangalore',181,'0.0',NULL,NULL,NULL),(1253,'Arun','9441663247','karthick9220@example.com','Coimbatore',177,'177.3',NULL,NULL,NULL),(1254,'John','8462196847','dinesh8222@example.com','Bangalore',169,'0.0',NULL,NULL,NULL),(1255,'Arun','8428095952','karthick7807@example.com','Trichy',188,'0.0',NULL,NULL,NULL),(1256,'Suriya','9491860890','david9074@example.com','Bangalore',210,'210.0',NULL,NULL,NULL),(1257,'Akshay','9442644859','vijay7330@example.com','Bangalore',178,'0.0',NULL,NULL,NULL),(1258,'Kavin','9918749962','dinesh8401@example.com','Chennai',177,'0.0',NULL,NULL,NULL),(1259,'Arjun','9789963189','akshay9154@example.com','Coimbatore',200,'0.0',NULL,NULL,NULL),(1260,'Kumar','9909833204','akshay7019@example.com','Salem',165,'0.0',NULL,NULL,NULL),(1261,'Akshay','9489682795','vasanth4613@example.com','Tanjore',212,'0.0',NULL,NULL,NULL),(1262,'Akshay','8383918926','david5529@example.com','Tanjore',180,'0.0',NULL,NULL,NULL),(1263,'Vasanth','9842687124','dinesh5094@example.com','Coimbatore',196,'195.9',NULL,NULL,NULL),(1264,'Akshay','9422620089','david6331@example.com','Chennai',179,'178.7',NULL,NULL,NULL),(1265,'Akshay','9718512780','dinesh360@example.com','Trichy',202,'0.0',NULL,NULL,NULL),(1266,'Saravanan','9466034803','john9021@example.com','Coimbatore',195,'0.0',NULL,NULL,NULL),(1268,'Babu','9821641310','akshay7767@example.com','Kumbakonam',192,'0.0',NULL,NULL,NULL),(1269,'Vignesh','9764825923','vijay6596@example.com','Coimbatore',155,'0.0',NULL,NULL,NULL),(1272,'Vignesh','8874497374','babu499@example.com','Salem',163,'0.0',NULL,NULL,NULL),(1273,'Arun','9892089636','akshay8186@example.com','Salem',165,'0.0',NULL,NULL,NULL),(1279,'Mani','9440976662','bala3753@example.com','Bangalore',187,'0.0',NULL,NULL,NULL),(1280,'Karthick','8812451410','vijay7452@example.com','Chennai',181,'0.0',NULL,NULL,NULL),(1281,'Suriya','9788079652','david9032@example.com','Salem',234,'234.4',NULL,NULL,NULL),(1282,'John','8368887812','dinesh1762@example.com','Trichy',212,'0.0',NULL,NULL,NULL),(1283,'Mani','9941882452','vasanth7989@example.com','Salem',223,'222.6',NULL,NULL,NULL),(1284,'Vignesh','9678883599','akshay8076@example.com','Coimbatore',236,'0.0',NULL,NULL,NULL),(1285,'Mohan','8863242299','john3418@example.com','Bangalore',893,'0.0',NULL,NULL,NULL),(1286,'David','9914832197','dinesh5180@example.com','Kodaikanal',835,'0.0',NULL,NULL,NULL),(1287,'Vijay','8883979906','karthick5145@example.com','Bangalore',909,'0.0',NULL,NULL,NULL),(1295,'Arjun','9795531885','karthick9986@example.com','Coimbatore',385,'0.0',NULL,NULL,NULL),(1296,'Arun','9978555406','john8876@example.com','Bangalore',264,'0.0',NULL,NULL,NULL),(1297,'Arjun','9728543831','david9566@example.com','Tanjore',338,'337.8',NULL,NULL,NULL),(1298,'Arjun','8311310113','akshay6007@example.com','Coimbatore',361,'0.0',NULL,NULL,NULL),(1299,'Kavin','9896354125','akshay3889@example.com','Trichy',372,'0.0',NULL,NULL,NULL),(1300,'Kavin','9820538917','bala7321@example.com','Tanjore',309,'309.2',NULL,NULL,NULL),(1301,'John','9952884997','babu8947@example.com','Tanjore',444,'0.0',NULL,NULL,NULL),(1302,'Dinesh','9642095852','dinesh3532@example.com','Tanjore',307,'307.4',NULL,NULL,NULL),(1304,'Kavin','9877859353','dinesh780@example.com','Tanjore',407,'0.0',NULL,NULL,NULL),(1305,'Vignesh','8398854774','vijay9731@example.com','Bangalore',813,'0.0',NULL,NULL,NULL),(1306,'Babu','9729489462','bala6563@example.com','Salem',423,'0.0',NULL,NULL,NULL),(1307,'Mani','8404058078','akshay7158@example.com','Salem',436,'435.6',NULL,NULL,NULL),(1308,'John','8485831524','dinesh7404@example.com','Trichy',180,'0.0',NULL,NULL,NULL),(1309,'Saravanan','9603519373','vasanth7507@example.com','Trichy',177,'0.0',NULL,NULL,NULL),(1310,'Kumar','8319747524','bala8953@example.com','Chennai',292,'0.0',NULL,NULL,NULL),(1312,'Vignesh','9872028713','karthick3402@example.com','Kumbakonam',272,'0.0',NULL,NULL,NULL),(1313,'Vignesh','9612905712','david8650@example.com','Bangalore',95,'0.0',NULL,NULL,NULL),(1314,'Arjun','9646473105','babu190@example.com','Bangalore',74,'0.0',NULL,NULL,NULL),(1315,'Karthick','9629360253','dinesh4319@example.com','Tanjore',124,'0.0',NULL,NULL,NULL),(1316,'Babu','9704628660','akshay1094@example.com','Kumbakonam',99,'0.0',NULL,NULL,NULL),(1317,'Babu','9714642839','akshay2276@example.com','Tanjore',210,'0.0',NULL,NULL,NULL),(1318,'Kavin','8400191261','akshay5677@example.com','Coimbatore',129,'0.0',NULL,NULL,NULL),(1319,'Saravanan','8305395316','vijay1630@example.com','Chennai',130,'130.0',NULL,NULL,NULL),(1326,'Mani','9441618026','karthick3757@example.com','Tanjore',142,'142.0',NULL,NULL,NULL),(1327,'Kumar','9680020097','bala4366@example.com','Trichy',58,'0.0',NULL,NULL,NULL),(1329,'Akshay','9983741271','bala5614@example.com','Tanjore',135,'0.0',NULL,NULL,NULL),(1330,'Babu','9777422190','akshay8524@example.com','Coimbatore',209,'209.2',NULL,NULL,NULL);
INSERT INTO `customer_loyalty_points` (`_id`, `phoneno`, `points`) VALUES (2,'9466741837','2147483647'),(3,'9821641310','2147483647'),(4,'9764825923','2147483647'),(5,'8826684819','2147483647'),(6,'8330946524','2147483647'),(7,'8874497374','2147483647'),(8,'9892089636','2147483647'),(9,'8889503529','2147483647'),(10,'8849955969','2147483647'),(11,'8320102726','2147483647'),(12,'9476797123','2147483647'),(13,'9420656392','2147483647'),(14,'9440976662','2147483647'),(15,'8812451410','2147483647'),(16,'8863242299','8'),(17,'9914832197','8'),(18,'8883979906','9'),(19,'8361051363','8'),(20,'9646021289','7'),(21,'9928017854','6'),(22,'9795531885','3.85'),(23,'9978555406','2.64'),(24,'9728543831','3.38'),(25,'8311310113','3.61'),(26,'9896354125','3.72'),(27,'9820538917','3.09'),(28,'9952884997','4.44'),(29,'9642095852','3.07'),(30,'9820955004','8'),(31,'9877859353','4.07'),(32,'8398854774','8.13'),(33,'9729489462','4.23'),(34,'8404058078','4.36'),(35,'8485831524','1.80'),(36,'9603519373','1.77'),(37,'8319747524','2.92'),(38,'9872028713','2.72'),(39,'9612905712','0.95'),(40,'9646473105','0.74'),(41,'9629360253','1.24'),(42,'9704628660','0.99'),(43,'9714642839','2.10'),(44,'8400191261','1.29'),(45,'8305395316','1.30'),(46,'9441618026','1.42'),(47,'9680020097','0.58'),(48,'9983741271','1.34'),(49,'9777422190','2.09'),(50,'8852178075','2.82'),(51,'9791611233','1.43');
INSERT INTO `discountdetails` (`_id`, `date`, `time`, `billno`, `Discountcodeno`, `Discount_percent`, `Billamount_rupess`, `Discount_rupees`, `date1`, `original_amount`, `billcount`, `datetimee_new`, `paymentmethod`) VALUES (1,NULL,NULL,'20241114-1-000031',NULL,'0',NULL,'0',NULL,NULL,NULL,NULL,NULL),(2,NULL,NULL,'20241115-1-000121',NULL,'0',NULL,'0',NULL,NULL,NULL,NULL,NULL);
INSERT INTO `expenses_sales` (`_id`, `expensename`, `price`, `category`, `counterperson_username`, `counterperson_name`, `date`, `time`, `datetimee_new`) VALUES (1,'Maintainance ','1000','Maintenance','madmin','madmin','24 Jul 2024','12:07 PM','202407241207'),(2,'medical ','5000','Medical','madmin','madmin','24 Jul 2024','12:08 PM','202407241208'),(3,'test','1000','Medical','madmin','madmin','25 Jul 2024','08:28 AM','202407250828');
INSERT INTO `itemdata` (`_id`, `itemname`, `total`) VALUES (1,'Biryani Item',20),(2,'Kari Dosa',120),(3,'Peking Duck(Pesto Veggie)',124),(4,'bread omlette',16590),(5,'butterscotch cake',140),(6,'butterscotch icecream',80),(7,'channa',125),(8,'chicken biriyani',15800),(9,'chicken kabab',7500),(10,'chicken nuggets',65),(11,'chicken sukka',320),(12,'coffee',20),(13,'dhal fry',180),(14,'dosa',19776),(15,'grape juice',100),(16,'idly',15509),(17,'lassi',125),(18,'lime juice',45),(19,'masal dosa',21480),(20,'masal puri',350),(21,'masal vada',7400),(22,'masala chai',200),(23,'mutton biriyani',16440),(24,'non veg thali',11760),(25,'onion dosa',9625),(26,'paneer butter masala',60),(27,'pani puri',5180),(28,'pav bhajji',7440),(29,'pongal',15810),(30,'poori',19985),(31,'rava dosa',9240),(32,'rice',4680),(33,'roti',2295),(34,'samosa',2480),(35,'sheekh kabab',10480),(36,'sheekh kabab',1440),(37,'soft drinks',30),(38,'tea',120),(39,'upma',7440),(40,'uthappam',2970),(41,'vada',2240),(42,'veg biriyani',1540),(43,'veg cutlet',680),(44,'veg thali',800);
INSERT INTO `itemwiseorderlistcategory` (`_id`, `itemno`, `categoryname`, `sales`, `salespercentage`, `itemtotalquan`) VALUES (1,NULL,'Snacks',80,9,'4'),(2,NULL,'Tiffin',835,91,'26');
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,'47','Biryani Item',20,0,'1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(2,'47','Kari Dosa',120,0,'4',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(3,'47','Peking Duck(Pesto Veggie)',124,0,'2',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(4,'7','bread omlette',16590,6,'549',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(5,'40','butterscotch cake',140,0,'4',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(6,'39','butterscotch icecream',80,0,'2',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(7,'41','channa',125,0,'5',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(8,'22','chicken biriyani',15800,6,'157',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(9,'14','chicken kabab',7500,3,'125',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10,'20','chicken nuggets',65,0,'1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(11,'29','chicken sukka',320,0,'4',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(12,'31','coffee',20,0,'1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(13,'30','dhal fry',180,0,'6',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(14,'2','dosa',19776,7,'521',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(15,'37','grape juice',100,0,'4',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(16,'1','idly',15509,6,'567',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(17,'36','lassi',125,0,'5',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(18,'35','lime juice',45,0,'3',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(19,'6','masal dosa',21480,8,'536',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(20,'19','masal puri',350,0,'10',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(21,'12','masal vada',7400,3,'370',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(22,'33','masala chai',200,0,'8',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(23,'25','mutton biriyani',16440,6,'137',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(24,'24','non veg thali',11760,4,'147',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(25,'8','onion dosa',9625,3,'274',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(26,'28','paneer butter masala',60,0,'1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(27,'16','pani puri',5180,2,'148',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(28,'17','pav bhajji',7440,3,'124',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(29,'3','pongal',15810,6,'526',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(30,'5','poori',19985,7,'567',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(31,'9','rava dosa',9240,3,'264',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(32,'27','rice',4680,2,'155',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(33,'26','roti',2295,1,'153',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(34,'13','samosa',2480,1,'124',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(35,'15','sheekh kabab',10480,4,'131',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(36,'34','soft drinks',30,0,'3',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(37,'32','tea',120,0,'6',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(38,'4','upma',16200,6,'540',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(39,'10','uthappam',7740,3,'258',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(40,'11','vada',8080,3,'404',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(41,'21','veg biriyani',10360,4,'147',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(42,'18','veg cutlet',5360,2,'134',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(43,'23','veg thali',8150,3,'163',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(44,'23','veg thali',800,1,'16','Main course',NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO `top_category` (`_id`, `category`, `value`) VALUES (547,'Desserts',220),(548,'Drinks',640),(549,'Main course',70065),(550,'Snacks',54584),(551,'Tiffin',151955),(552,'southindian',120),(553,'Main course',751),(554,'Snacks',20),(555,'Tiffin',954),(556,'Main course',751),(557,'Snacks',20),(558,'Tiffin',954),(577,'Desserts',220),(578,'Drinks',640),(579,'Main course',10096),(580,'Snacks',10209),(581,'Tiffin',73563),(582,'southindian',120),(601,'Desserts',220),(602,'Drinks',640),(603,'Main course',10096),(604,'Snacks',10209),(605,'Tiffin',73563),(606,'southindian',120),(611,'Desserts',260),(612,'Drinks',740),(613,'Main course',4321),(614,'Snacks',5129),(615,'Tiffin',65360),(616,'southindian',120),(618,'Desserts',260),(619,'Drinks',740),(620,'Main course',3341),(621,'Snacks',4504),(622,'Tiffin',64158),(623,'southindian',120),(634,'Desserts',260),(635,'Drinks',740),(636,'Main course',5311),(637,'Snacks',5229),(638,'Tiffin',67290),(639,'southindian',120),(664,'Desserts',260),(665,'Drinks',740),(666,'Main course',5311),(667,'Snacks',5229),(668,'Tiffin',67290),(669,'southindian',120),(671,'Kashmiri',150),(672,'Snacks',320),(673,'Tiffin',1745),(678,'Snacks',140),(679,'Tiffin',1414),(688,'Oriya',67),(689,'Snacks',140),(690,'Tiffin',1725);
INSERT INTO `top_reason` (`_id`, `reason`, `value`) VALUES (68,'Accidental charge',3),(69,'Changed mind',1),(70,'Damaged/Spoiled',5),(71,'Delayed',1),(76,'Accidental charge',3),(77,'Changed mind',1),(78,'Damaged/Spoiled',5),(79,'Delayed',1),(84,'Accidental charge',3),(85,'Changed mind',1),(86,'Damaged/Spoiled',5),(87,'Delayed',1),(88,'Accidental charge',3),(89,'Changed mind',1),(90,'Damaged/Spoiled',5),(91,'Delayed',1),(92,'Accidental charge',3),(93,'Changed mind',1),(94,'Damaged/Spoiled',5),(95,'Delayed',1),(104,'Accidental charge',3),(105,'Changed mind',1),(106,'Damaged/Spoiled',5),(107,'Delayed',1),(112,'Accidental charge',3),(113,'Changed mind',1),(114,'Damaged/Spoiled',5),(115,'Delayed',1);
INSERT INTO `usercancelleddata` (`_id`, `username`, `total`) VALUES (1,'admin',1402);
INSERT INTO `userdata` (`_id`, `username`, `total`) VALUES (1,'admin',289631),(2,'madmin',8892);
INSERT INTO `userwiseorderlistitems` (`_id`, `username`, `sales`, `salespercentage`) VALUES (1,'madmin',289631,97),(2,'madmin',8892,3);
