INSERT INTO `cardnumber` (`_id`, `cardnumber`, `billnumber`, `datetimee_new`) VALUES (1,'000000','20230518-000031','202305181120');
INSERT INTO `clicked_cust_name` (`_id`, `name`) VALUES (1,'');
INSERT INTO `cusotmer_activity_temp_top3` (`_id`, `name`, `phone_no`, `email`, `addr`, `total_amount`, `balance`, `discount_value`, `discount_type`, `approval_rate`) VALUES (1,'arfu','1234567890','','',15000,'0.0',NULL,NULL,NULL),(3,'dathu','0000000000','','',1640,'820.0',NULL,NULL,NULL),(4,'    fffffg','0000000000','','',0,'820.0',NULL,NULL,NULL);
INSERT INTO `customerdetails` (`_id`, `name`, `phoneno`, `emailid`, `address`, `rupees`, `billnumber`, `date1`, `time1`, `date`, `total`, `deposit`, `cashout`, `credit`, `charges`, `authentication_pin`, `otp`, `dob`, `refunds`, `total_amount`, `cashout_type`, `credit_default`, `commission_charges`, `commission_charges_type`, `commission_charges_status`, `authentication_pin_status`, `dob_alaram`, `default_discount_status`, `default_discount_amount`, `default_discount_value`, `default_discount_type`, `notes`, `cust_account_no`, `cust_ifsc_code`, `cust_account_holder_name`, `cust_bank_name`, `datetimee_new`, `user_id`, `tax1`, `tax2`, `tax3`, `tax4`, `tax5`, `tax6`, `tax7`, `tax8`, `tax9`, `tax10`, `tax11`, `tax12`, `tax13`, `tax14`, `tax15`, `tax_selection`, `tax1_value`, `tax2_value`, `tax3_value`, `tax4_value`, `tax5_value`, `tax6_value`, `tax7_value`, `tax8_value`, `tax9_value`, `tax10_value`, `tax11_value`, `tax12_value`, `tax13_value`, `tax14_value`, `tax15_value`, `proceedings`, `SaleType`, `Cheque_num`, `CreditAmount`, `SaleTime`, `SaleDate`, `Transaction_ID`, `Card_Type`, `Card_Num`, `RRN`, `pincode`, `limit_status`, `limit_value`, `limit_present_value`, `write_off`, `loyal_points`) VALUES (1,'arfu','1234567890','','','15000.00','20230506-0000113','06 May 2023','06:59:31 PM','2023 05 06',NULL,NULL,NULL,'0',NULL,NULL,NULL,NULL,NULL,'15000.00',NULL,'off',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'202305061859','w',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'All',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'off','  Cheque','123456','off','off','06 May 2023','off','off','off','off','','no limit','','',NULL,'0'),(2,'dathu','0000000000','','','820.00','20230508-000015','08 May 2023','06:39:48 PM','2023 05 08',NULL,NULL,NULL,'820',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'off',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'202305081839','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'All',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'off','  Pay Later','0','off','off','08 May 2023','off','off','off','off','','no limit','','',NULL,'0'),(3,'dathu','0000000000','','','820.00','20230508-000015','08 May 2023','06:39:48 PM','2023 05 08',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'off',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'202305081839','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'All',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'off','off','off','off','off','off','off','off','off','off','','no limit','','',NULL,'0'),(4,'    fffffg','0000000000','','','0.00','20230531-000018','31 May 2023','09:04:22 PM','2023 05 31',NULL,NULL,NULL,'0000',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'off',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'202305312104','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'All',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'off','  Pay Later','0','off','off','31 May 2023','off','off','off','off','','no limit','','',NULL,'0');
INSERT INTO `discountdetails` (`_id`, `date`, `time`, `billno`, `Discountcodeno`, `Discount_percent`, `Billamount_rupess`, `Discount_rupees`, `date1`, `original_amount`, `billcount`, `datetimee_new`, `paymentmethod`) VALUES (1,'2023 04 03','12:45:39 pm','20230403-000015','g','5.64','7200.00','430','03 Apr 2023','7630.00','18','202304031245',NULL),(2,'2023 04 03','12:53:20 pm','20230403-0000110','a','4.35','2200.00','100','03 Apr 2023','2300.00','23','202304031253',NULL),(3,'2023 04 03','01:46:53 pm','20230403-0000123','a','7.69','1800.00','150','03 Apr 2023','1950.00','36','202304031346',NULL),(4,'2023 04 03','01:51:10 pm','20230403-0000124','a','2.44','4000.00','100','03 Apr 2023','4100.00','37','202304031351',NULL),(5,'2023 04 03','01:51:46 pm','20230403-0000125','@','14.29','300.00','50','03 Apr 2023','350.00','38','202304031351',NULL),(6,'2023 04 03','05:19:11 pm','20230403-0000126','a','7.87','9950.00','850','03 Apr 2023','10800.00','39','202304031719',NULL),(7,'2023 04 03','05:48:18 pm','20230403-0000135','f','6.90','2700.00','200','03 Apr 2023','2900.00','48','202304031748',NULL),(8,'2023 04 03','05:49:16 pm','20230403-0000136','h','5.00','950.00','50','03 Apr 2023','1000.00','49','202304031749',NULL),(9,'2023 04 03','06:08:19 pm','20230403-0000149','y','30.69','700.00','310','03 Apr 2023','1010.00','62','202304031808',NULL),(10,'2023 04 04','04:14:13 pm','20230404-0000122','h','6.25','4500.00','300','04 Apr 2023','4800.00','84','202304041614',NULL),(11,'2023 04 04','05:22:14 pm','20230404-0000126','h','12.73','9600.00','1400','04 Apr 2023','11000.00','88','202304041722',NULL),(12,'2023 04 04','05:30:15 pm','20230404-0000128','b','3.70','6500.00','250','04 Apr 2023','6750.00','90','202304041730',NULL),(13,'2023 04 04','05:40:50 pm','20230404-0000135','thirupathi','3.16','920.00','30','04 Apr 2023','950.00','97','202304041740',NULL),(14,'2023 04 04','05:43:50 pm','20230404-0000137','thiru','2.78','1400.00','40','04 Apr 2023','1440.00','99','202304041743',NULL),(15,'2023 04 04','05:52:55 pm','20230404-0000141','thiru','0.62','8000.00','50','04 Apr 2023','8050.00','103','202304041752',NULL),(16,'2023 04 04','06:07:11 pm','20230404-0000145','g','11.49','9400.00','1220','04 Apr 2023','10620.00','107','202304041807',NULL),(17,'2023 04 14','03:35:39 PM','20230414-000018','gh','7.08','1050.00','80','14 Apr 2023','1130.00','116','202304141535',NULL),(18,'2023 04 14','04:35:14 PM','20230414-0000131','gg','7.56','5500.00','450','14 Apr 2023','5950.00','139','202304141635',NULL),(19,'2023 04 14','04:38:21 PM','20230414-0000135','ff','16.67','300.00','60','14 Apr 2023','360.00','143','202304141638',NULL),(20,'2023 04 28','05:15:51 PM','20230428-000012','1','23.08','500.00','150','28 Apr 2023','650.00','145','202304281715',NULL),(21,'2023 04 28','05:17:59 PM','20230428-000013','w','33.33','500.00','250','28 Apr 2023','750.00','146','202304281717',NULL),(22,'2023 04 29','09:48:45 PM','20230429-0000124','a','13.17','6000.00','910','29 Apr 2023','6910.00','178','202304292148',NULL),(23,'2023 05 01','09:47:06 PM','20230501-000014','a','4.76','1200.00','60','01 May 2023','1260.00','185','202305012147',NULL),(24,'2023 05 02','05:19:06 PM','20230502-000011','a','5.66','2500.00','150','02 May 2023','2650.00','186','202305021719',NULL),(25,'2023 05 03','10:29:37 AM','20230503-000011','a','9.64','7500.00','800','03 May 2023','8300.00','187','202305031029',NULL),(26,'2023 05 03','02:26:24 PM','20230503-000013','q','2.13','2300.00','50','03 May 2023','2350.00',NULL,'202305031426',NULL),(27,'2023 05 04','06:49:37 PM','20230504-000012','a','3.57','2700.00','100','04 May 2023','2800.00',NULL,'202305041849',NULL),(28,'2023 05 05','09:22:48 AM','20230505-000011','a','3.85','5000.00','200','05 May 2023','5200.00',NULL,'202305050922',NULL),(29,'2023 05 05','04:50:08 PM','20230505-000012','a','2.03','2900.00','60','05 May 2023','2960.00','199','202305051650',NULL),(30,'2023 05 06','10:02:03 AM','20230506-000011','a','10.00','900.00','100','06 May 2023','1000.00',NULL,'202305061002',NULL),(31,'2023 05 06','10:04:40 AM','20230506-000013','q','7.69','1800.00','150','06 May 2023','1950.00',NULL,'202305061004',NULL),(32,'2023 05 06','10:18:10 AM','20230506-000016','q','2.04','2400.00','50','06 May 2023','2450.00',NULL,'202305061018',NULL),(33,'2023 05 06','04:28:49 PM','20230506-000018','w','2.78','2100.00','60','06 May 2023','2160.00',NULL,'202305061628',NULL),(34,'2023 05 06','04:46:13 PM','20230506-0000110','a','11.67','19000.00','2510','06 May 2023','21510.00',NULL,'202305061646',NULL),(35,'2023 05 06','04:47:29 PM','20230506-0000111','a','32.43','500.00','240','06 May 2023','740.00',NULL,'202305061647',NULL),(36,'2023 05 06','07:42:06 PM','20230506-0000114','a','10.89','3200.00','391','06 May 2023','3591.00',NULL,'202305061942',NULL),(37,'2023 05 07','09:40:19 AM','20230507-000011','a','26.67','5500.00','2000','07 May 2023','7500.00',NULL,'202305070940',NULL),(38,'2023 05 07','10:18:55 AM','20230507-000012','a','6.38','2200.00','150','07 May 2023','2350.00',NULL,'202305071018',NULL),(39,'2023 05 07','11:28:52 AM','20230507-000013','w','8.16','4500.00','400','07 May 2023','4900.00',NULL,'202305071128',NULL),(40,'2023 05 07','02:31:11 PM','20230507-000014','a','16.28','9000.00','1750','07 May 2023','10750.00',NULL,'202305071431',NULL),(41,'2023 05 07','06:33:15 PM','20230507-0000111','a','18.18','1800.00','400','07 May 2023','2200.00',NULL,'202305071833',NULL),(42,'2023 05 07','08:25:08 PM','20230507-0000117','f','3.63','9300.00','350','07 May 2023','9650.00',NULL,'202305072025',NULL),(43,'2023 05 08','06:04:48 PM','20230508-000014','t','9.09','6500.00','650','08 May 2023','7150.00',NULL,'202305081804',NULL),(44,'2023 05 08','06:39:48 PM','20230508-000015','f','4.65','820.00','40','08 May 2023','860.00',NULL,'202305081839',NULL),(45,'2023 05 09','09:46:18 PM','20230509-000018','a','7.09','1900.00','145','09 May 2023','2045.00',NULL,'202305092146',NULL),(46,'2023 05 10','11:22:08 AM','20230510-000013','f','4.11','3500.00','150','10 May 2023','3650.00',NULL,'202305101122',NULL),(47,'2023 05 10','12:00:34 PM','20230510-000014','d','7.14','1300.00','100','10 May 2023','1400.00',NULL,'202305101200',NULL),(48,'2023 05 10','12:41:09 PM','20230510-000016','f','7.41','2500.00','200','10 May 2023','2700.00',NULL,'202305101241',NULL),(49,'2023 05 10','02:04:45 PM','20230510-000017','f','8.33','550.00','50','10 May 2023','600.00',NULL,'202305101404',NULL),(50,'2023 05 10','09:31:58 PM','20230510-0000111','f','16.67','1000.00','200','10 May 2023','1200.00',NULL,'202305102131',NULL),(51,'2023 05 11','03:51:50 PM','20230511-000011','f','52.61','5000.00','5550','11 May 2023','10550.00',NULL,'202305111551',NULL),(52,'2023 05 11','04:14:38 PM','20230511-000013','f','9.09','500.00','50','11 May 2023','550.00',NULL,'202305111614',NULL),(53,'2023 05 11','06:00:42 PM','20230511-000014','f','6.08','1700.00','110','11 May 2023','1810.00',NULL,'202305111800',NULL),(54,'2023 05 11','06:21:03 PM','20230511-000015','f','21.80','5200.00','1450','11 May 2023','6650.00',NULL,'202305111821',NULL),(55,'2023 05 11','10:01:59 PM','20230511-000018','f','6.65','8400.00','598','11 May 2023','8998.00',NULL,'202305112201',NULL),(56,'2023 05 12','01:07:47 PM','20230512-000021','f','33.05','8000.00','3950','12 May 2023','11950.00',NULL,'202305121307',NULL),(57,'2023 05 12','02:45:11 PM','20230512-000022','f','5.56','1700.00','100','12 May 2023','1800.00',NULL,'202305121445',NULL),(58,'2023 05 12','04:21:19 PM','20230512-000024','f','8.33','1100.00','100','12 May 2023','1200.00',NULL,'202305121621',NULL),(59,'2023 05 12','06:24:29 PM','20230512-000032','f','8.33','2200.00','200','12 May 2023','2400.00',NULL,'202305121824',NULL),(60,'2023 05 12','06:52:31 PM','20230512-000033','f','2.50','1950.00','50','12 May 2023','2000.00',NULL,'202305121852',NULL),(61,'2023 05 12','06:57:15 PM','20230512-000011','f','14.46','14200.00','2400','12 May 2023','16600.00',NULL,'202305121857',NULL),(62,'2023 05 12','07:19:30 PM','20230512-000012','f','2.44','4000.00','100','12 May 2023','4100.00',NULL,'202305121919',NULL),(63,'2023 05 12','08:54:18 PM','20230512-000025','f','11.08','6500.00','810','12 May 2023','7310.00',NULL,'202305122054',NULL),(64,'2023 05 12','09:25:03 PM','20230512-000027','f','0.31','650.00','2','12 May 2023','652.00',NULL,'202305122125',NULL),(65,'2023 05 13','02:03:28 PM','20230513-000022','f','31.43','6000.00','2750','13 May 2023','8750.00',NULL,'202305131403',NULL),(66,'2023 05 13','02:08:29 PM','20230513-000023','f','21.79','2800.00','780','13 May 2023','3580.00',NULL,'202305131408',NULL),(67,'2023 05 13','02:09:37 PM','20230513-000024','f','4.76','7000.00','350','13 May 2023','7350.00',NULL,'202305131409',NULL),(68,'2023 05 13','02:10:11 PM','20230513-000025','f','4.76','1000.00','50','13 May 2023','1050.00',NULL,'202305131410',NULL),(69,'2023 05 13','07:16:26 PM','20230513-000027','f','17','14400.50','2949.50','13 May 2023','17350.00',NULL,'202305131916',NULL),(70,'2023 05 13','07:20:55 PM','20230513-000014','f','9.91','5000.00','550','13 May 2023','5550.00',NULL,'202305131920',NULL),(71,'2023 05 13','08:38:27 PM','20230513-000016','g','5.00','3800.00','200','13 May 2023','4000.00',NULL,'202305132038',NULL),(72,'2023 05 14','06:57:47 PM','20230514-000014','g','3.13','3100.00','100','14 May 2023','3200.00',NULL,'202305141857',NULL),(73,'2023 05 14','07:32:52 PM','20230514-000018','f','10.00','4500.00','500','14 May 2023','5000.00',NULL,'202305141932',NULL),(74,'2023 05 15','06:47:51 PM','20230515-000013','f','4.76','1000.00','50','15 May 2023','1050.00',NULL,'202305151847',NULL),(75,'2023 05 15','07:11:23 PM','20230515-000014','g','12.28','3000.00','420','15 May 2023','3420.00',NULL,'202305151911',NULL),(76,'2023 05 15','08:01:42 PM','20230515-000016','g','8.16','4500.00','400','15 May 2023','4900.00',NULL,'202305152001',NULL),(77,'2023 05 15','08:32:12 PM','20230515-000017','f','9.09','1500.00','150','15 May 2023','1650.00',NULL,'202305152032',NULL),(78,'2023 05 16','06:42:04 PM','20230516-000014','h','3.23','600.00','20','16 May 2023','620.00',NULL,'202305161842',NULL),(79,'2023 05 18','11:20:48 AM','20230518-000031','g','7.49','10500.00','850','18 May 2023','11350.00',NULL,'202305181120',NULL),(80,'2023 05 19','05:51:55 PM','20230519-000011','f','4.76','5000.00','250','19 May 2023','5250.00',NULL,'202305191751',NULL),(81,'2023 05 19','08:03:33 PM','20230519-000013','f','3.08','630.00','20','19 May 2023','650.00',NULL,'202305192003',NULL),(82,'2023 05 20','02:46:50 PM','20230520-000011','f','6.25','1500.00','100','20 May 2023','1600.00',NULL,'202305201446',NULL),(83,'2023 05 20','07:57:20 PM','20230520-000017','f','8.33','1100.00','100','20 May 2023','1200.00',NULL,'202305201957',NULL),(84,'2023 05 21','10:06:42 AM','20230521-000011','f','2.78','2100.00','60','21 May 2023','2160.00',NULL,'202305211006',NULL),(85,'2023 05 21','12:14:16 PM','20230521-000012','f','14.29','1800.00','300','21 May 2023','2100.00',NULL,'202305211214',NULL),(86,'2023 05 21','01:44:40 PM','20230521-000014','f','7.89','1400.00','120','21 May 2023','1520.00',NULL,'202305211344',NULL),(87,'2023 05 22','12:19:35 AM','20230522-000011','g','1.64','3000.00','50','22 May 2023','3050.00',NULL,'202305220019',NULL),(88,'2023 05 22','06:06:20 PM','20230522-000014','f','8.40','6000.00','550','22 May 2023','6550.00',NULL,'202305221806',NULL),(89,'2023 05 22','06:23:01 PM','20230522-000015','f','1.37','3600.00','50','22 May 2023','3650.00',NULL,'202305221823',NULL),(90,'2023 05 22','07:54:03 PM','20230522-000017','f','5.06','1500.00','80','22 May 2023','1580.00',NULL,'202305221954',NULL),(91,'2023 05 23','11:34:34 AM','20230523-000011','f','21.69','64100.00','17750','23 May 2023','81850.00',NULL,'202305231134',NULL),(92,'2023 05 23','04:44:42 PM','20230523-000015','f','12.50','2800.00','400','23 May 2023','3200.00',NULL,'202305231644',NULL),(93,'2023 05 23','09:07:32 PM','20230523-000016','g','4.76','600.00','30','23 May 2023','630.00',NULL,'202305232107',NULL),(94,'2023 05 24','07:29:49 PM','20230524-000011','f','17.73','5800.00','1250','24 May 2023','7050.00',NULL,'202305241929',NULL),(95,'2023 05 24','07:41:24 PM','20230524-000013','f','8.47','2700.00','250','24 May 2023','2950.00',NULL,'202305241941',NULL),(96,'2023 05 24','09:04:29 PM','20230524-000015','f','10.34','5200.00','600','24 May 2023','5800.00',NULL,'202305242104',NULL),(97,'2023 05 25','05:59:18 PM','20230525-000013','f','2.04','2400.00','50','25 May 2023','2450.00',NULL,'202305251759',NULL),(98,'2023 05 25','06:14:49 PM','20230525-000015','f','2.78','3500.00','100','25 May 2023','3600.00',NULL,'202305251814',NULL),(99,'2023 05 27','04:34:57 PM','20230527-000011','g','11.76','1500.00','200','27 May 2023','1700.00',NULL,'202305271634',NULL),(100,'2023 05 28','12:49:46 PM','20230528-000011','f','3.70','1300.00','50','28 May 2023','1350.00',NULL,'202305281249',NULL),(101,'2023 05 29','10:10:45 AM','20230529-000011','f','10.71','3000.00','360','29 May 2023','3360.00',NULL,'202305291010',NULL),(102,'2023 05 29','08:59:23 PM','20230529-000016','f','5.56','850.00','50','29 May 2023','900.00',NULL,'202305292059',NULL),(103,'2023 05 31','05:01:35 PM','20230531-000012','f','0.51','3900.00','20','31 May 2023','3920.00',NULL,'202305311701',NULL),(104,'2023 05 31','06:09:26 PM','20230531-000014','f','5.97','6300.00','400','31 May 2023','6700.00',NULL,'202305311809',NULL),(105,'2023 05 31','10:05:56 PM','20230531-0000111','f','14.09','5000.00','820','31 May 2023','5820.00',NULL,'202305312205',NULL),(106,'2023 06 02','06:33:55 PM','20230602-000012','f','12.73','2400.00','350','02 Jun 2023','2750.00',NULL,'202306021833',NULL),(107,'2023 06 03','05:32:17 PM','20230603-000016','f','15.66','3500.00','650','03 Jun 2023','4150.00','434','202306031732',NULL),(108,'2023 06 03','06:30:13 PM','20230603-000018','f','4.00','1200.00','50','03 Jun 2023','1250.00','436','202306031830',NULL),(109,'2023 06 03','08:25:40 PM','20230603-0000110','f','2.86','680.00','20','03 Jun 2023','700.00','438','202306032025',NULL),(110,'2023 06 03','09:00:29 PM','20230603-0000111','f','7.69','600.00','50','03 Jun 2023','650.00','439','202306032100',NULL),(111,'2023 06 03','09:15:36 PM','20230603-0000112','f','12.41','6000.00','850','03 Jun 2023','6850.00','440','202306032115',NULL),(112,'2023 06 04','11:15:11 AM','20230604-000011','f','19.46','6000.00','1450','04 Jun 2023','7450.00','441','202306041115',NULL),(113,'2023 06 04','04:37:21 PM','20230604-000013','Return goods 100 shots1 120 shots 1','63.92','1750.00','3100','04 Jun 2023','4850.00','443','202306041637',NULL),(114,'2023 06 05','07:21:12 PM','20230605-000012','f','10.11','4000.00','450','05 Jun 2023','4450.00',NULL,'202306051921',NULL),(115,'2023 06 05','07:21:46 PM','20230605-000013','j','7.14','650.00','50','05 Jun 2023','700.00',NULL,'202306051921',NULL),(116,'2023 06 05','08:22:28 PM','20230605-000015','f','20.00','1600.00','400','05 Jun 2023','2000.00',NULL,'202306052022',NULL),(117,'2023 06 05','09:27:04 PM','20230605-000018','k','4.00','1200.00','50','05 Jun 2023','1250.00',NULL,'202306052127',NULL),(118,'2024 09 11','02:38:34 pm','20240911-000016','r','7.69','3000.00','250','11 Sept 2024','3250.00',NULL,'202409111438',NULL);
INSERT INTO `generalorderlistascdesc1` (`_id`, `date`, `time`, `user`, `billno`, `billdetails`, `sales`, `discountamount`, `paymentmethod`, `billtype`, `itemname`, `quan`, `tableid`, `individualprice`, `date1`, `datetimee`, `cardnumber`, `individualtotal`, `billcount`, `hsn_code`, `itemtax_name`, `itemtax_per`, `itemtax_rs`, `globaltax_rs`, `itemtax_name2`, `itemtax_rs2`, `itemtax_name3`, `itemtax_rs3`, `itemtax_name4`, `itemtax_rs4`, `itemtax_name5`, `itemtax_rs5`) VALUES (1,'28 Apr 2023','05:14:57 PM','madmin','20230428-000011',NULL,1050,'0','  Cash','  General','1000 WALA','3.0','1','350.00',NULL,'20230428171457','','1050.00','144','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(2,'28 Apr 2023','05:24:25 PM','madmin','20230428-0000110',NULL,1050,'0','  Upiqr','  General','1000 WALA','3.0','1','350.00',NULL,'20230428172425','','1050.00','153','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(3,'28 Apr 2023','05:15:51 PM','madmin','20230428-000012',NULL,500,'150','  Cash','  General','30 SHOTS','1.0','1','650.00',NULL,'20230428171551','','650.00','145','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(4,'28 Apr 2023','05:17:59 PM','madmin','20230428-000013',NULL,500,'250','  Cash','  General','SOLDIER BOMB','5.0','1','150.00',NULL,'20230428171759','','750.00','146','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(5,'28 Apr 2023','05:19:10 PM','madmin','20230428-000014',NULL,1850,'0','  Upiqr','  General','5000 WALA','1.0','1','1850.00',NULL,'20230428171910','','1850.00','147','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(6,'28 Apr 2023','05:19:50 PM','madmin','20230428-000015',NULL,180,'0','  Upiqr','  General','COLD FIRE C       180','1.0','1','180.00',NULL,'20230428171950','','180.00','148','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(7,'28 Apr 2023','05:20:41 PM','madmin','20230428-000016',NULL,180,'0','  Upiqr','  General','COLD FIRE C       180','1.0','1','180.00',NULL,'20230428172041','','180.00','149','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(8,'28 Apr 2023','05:22:45 PM','madmin','20230428-000017',NULL,7850,'0','  Cash','  General','COLD FIRE C       180','20.0','1','180.00',NULL,'20230428172245','','3600.00','150','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(9,'28 Apr 2023','05:22:45 PM','madmin','20230428-000017',NULL,7850,'0','  Cash','  General','12 SHOTS MIX','5.0','1','300.00',NULL,'20230428172245','','1500.00','150','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(10,'28 Apr 2023','05:22:45 PM','madmin','20230428-000017',NULL,7850,'0','  Cash','  General','MINES','5.00','1','550',NULL,'20230428172245','','2750.00','150','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(11,'28 Apr 2023','05:23:22 PM','madmin','20230428-000018',NULL,150,'0','  Upiqr','  General','COLD FIRE C       180','1.0','1','150',NULL,'20230428172322','','150.00','151','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(12,'28 Apr 2023','05:24:00 PM','madmin','20230428-000019',NULL,350,'0','  Upiqr','  General','VIP','1.0','1','350',NULL,'20230428172400','','350.00','152','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(13,'03 May 2023','10:29:37 AM','madmin','20230503-000011',NULL,7500,'800','  Upiqr','  General','15 SHOTS','2.0','1','350.00',NULL,'20230503102937','','700.00','187','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(14,'03 May 2023','10:29:37 AM','madmin','20230503-000011',NULL,7500,'800','  Upiqr','  General','PAPER ITEM 2 PICE','4.0','1','250.00',NULL,'20230503102937','','1000.00','187','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(15,'03 May 2023','10:29:37 AM','madmin','20230503-000011',NULL,7500,'800','  Upiqr','  General','4 PAPER SHOTS','2.0','1','300',NULL,'20230503102937','','600.00','187','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(16,'03 May 2023','10:29:37 AM','madmin','20230503-000011',NULL,7500,'800','  Upiqr','  General','15 PAPER SHOTS','2.0','1','950',NULL,'20230503102937','','1900.00','187','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(17,'03 May 2023','12:21:06 PM','madmin','20230503-000012',NULL,9500,'0','  Upiqr','  General','RSR 40 SHOT','1.00','1','6500',NULL,'20230503122106','','6500.00','188','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(18,'03 May 2023','12:21:06 PM','madmin','20230503-000012',NULL,9500,'0','  Upiqr','  General','200 SHOTS','1.0','1','3000',NULL,'20230503122106','','3000.00','188','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(19,'03 May 2023','02:26:24 PM','ladmin','20230503-000013',NULL,2300,'50','  Upiqr','  General','COLD FIRE A       320','2.0','1','350',NULL,'20230503142624','','700.00','189','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(20,'03 May 2023','02:26:24 PM','ladmin','20230503-000013',NULL,2300,'50','  Upiqr','  General','30 SHOTS','2.0','1','650.00',NULL,'20230503142624','','1300.00','189','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(21,'03 May 2023','02:26:24 PM','ladmin','20230503-000013',NULL,2300,'50','  Upiqr','  General','SPARKELER GUN','1.0','1','350.00',NULL,'20230503142624','','350.00','189','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(22,'03 May 2023','03:39:52 PM','ladmin','20230503-000014',NULL,5190,'0','  Upiqr','  General','1000 WALA','2.0','1','200.00',NULL,'20230503153952','','400.00','190','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(23,'03 May 2023','03:39:52 PM','ladmin','20230503-000014',NULL,5190,'0','  Upiqr','  General','30 SHOTS','3.0','1','500',NULL,'20230503153952','','1500.00','190','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(24,'03 May 2023','03:39:52 PM','ladmin','20230503-000014',NULL,5190,'0','  Upiqr','  General','25 SHOTS CRAKKLING','2.0','1','250',NULL,'20230503153952','','500.00','190','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(25,'03 May 2023','03:39:52 PM','ladmin','20230503-000014',NULL,5190,'0','  Upiqr','  General','2000 WALA','2.0','1','400',NULL,'20230503153952','','800.00','190','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(26,'03 May 2023','03:39:52 PM','ladmin','20230503-000014',NULL,5190,'0','  Upiqr','  General','WIZZILING ROCKET SMALL','2.0','1','220',NULL,'20230503153952','','440.00','190','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(27,'03 May 2023','03:39:52 PM','ladmin','20230503-000014',NULL,5190,'0','  Upiqr','  General','SUPER DLX LAXMI','1.0','1','850',NULL,'20230503153952','','850.00','190','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(28,'03 May 2023','03:39:52 PM','ladmin','20230503-000014',NULL,5190,'0','  Upiqr','  General','ANDI THOOFAN','2.0','1','350',NULL,'20230503153952','','700.00','190','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(29,'03 May 2023','03:40:57 PM','ladmin','20230503-000015',NULL,4020,'0','  Upiqr','  General','1000 WALA','5.0','1','320',NULL,'20230503154057','','1600.00','191','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(30,'03 May 2023','03:40:57 PM','ladmin','20230503-000015',NULL,4020,'0','  Upiqr','  General','15 SHOTS','6.0','1','320',NULL,'20230503154057','','1920.00','191','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(31,'03 May 2023','03:40:57 PM','ladmin','20230503-000015',NULL,4020,'0','  Upiqr','  General','SOLDIER BOMB','5.0','1','100',NULL,'20230503154057','','500.00','191','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(32,'04 May 2023','06:47:34 PM','ladmin','20230504-000011',NULL,5000,'0','  Upiqr','  General','SMOKE 5 PICE STD','10.0','1','500',NULL,'20230504184734','','5000.00','192','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(33,'04 May 2023','06:49:37 PM','ladmin','20230504-000012',NULL,2700,'100','  Upiqr','  General','36 SHOT ABHI','1.0','1','650',NULL,'20230504184937','','650.00','193','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(34,'04 May 2023','06:49:37 PM','ladmin','20230504-000012',NULL,2700,'100','  Upiqr','  General','1000 WALA','2.0','1','350.00',NULL,'20230504184937','','700.00','193','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(35,'04 May 2023','06:49:37 PM','ladmin','20230504-000012',NULL,2700,'100','  Upiqr','  General','2000 WALA','1.0','1','650.00',NULL,'20230504184937','','650.00','193','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(36,'04 May 2023','06:49:37 PM','ladmin','20230504-000012',NULL,2700,'100','  Upiqr','  General','15 SHOTS','2.0','1','400',NULL,'20230504184937','','800.00','193','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(37,'04 May 2023','06:50:05 PM','ladmin','20230504-000013',NULL,1900,'0','  Upiqr','  General','120 SHOTS','1.0','1','1900',NULL,'20230504185005','','1900.00','194','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(38,'04 May 2023','07:25:40 PM','ladmin','20230504-000014',NULL,5430,'0','  Upiqr','  General','2000 WALA','1.0','1','750',NULL,'20230504192540','','750.00','195','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(39,'04 May 2023','07:25:40 PM','ladmin','20230504-000014',NULL,5430,'0','  Upiqr','  General','200 SHOTS','1.0','1','3200',NULL,'20230504192540','','3200.00','195','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(40,'04 May 2023','07:25:40 PM','ladmin','20230504-000014',NULL,5430,'0','  Upiqr','  General','COLD FIRE C       180','3.0','1','160',NULL,'20230504192540','','480.00','195','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(41,'04 May 2023','07:25:40 PM','ladmin','20230504-000014',NULL,5430,'0','  Upiqr','  General','SPARKELER GUN','2.0','1','500',NULL,'20230504192540','','1000.00','195','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(42,'04 May 2023','08:15:08 PM','ladmin','20230504-000015',NULL,600,'0','  Upiqr','  General','36 SHOT ABHI','1.0','1','600',NULL,'20230504201508','','600.00','196','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(43,'04 May 2023','08:18:58 PM','ladmin','20230504-000016',NULL,1900,'0','  Upiqr','  General','100 SHOTS','1.0','1','1900',NULL,'20230504201858','','1900.00','197','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(44,'05 May 2023','09:22:48 AM','ladmin','20230505-000011',NULL,5000,'200','  Cash','  General','36 SHOT ABHI','4.0','1','600',NULL,'20230505092248','','2400.00','198','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(45,'05 May 2023','09:22:48 AM','ladmin','20230505-000011',NULL,5000,'200','  Cash','  General','ANDI THOOFAN','2.0','1','350',NULL,'20230505092248','','700.00','198','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(46,'05 May 2023','09:22:48 AM','ladmin','20230505-000011',NULL,5000,'200','  Cash','  General','1000 WALA','6.0','1','350.00',NULL,'20230505092248','','2100.00','198','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(47,'05 May 2023','04:50:08 PM','ladmin','20230505-000012',NULL,2900,'60','  Upiqr','  General','1000 WALA','4.0','1','350.00',NULL,'20230505165008','','1400.00','199','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(48,'05 May 2023','04:50:08 PM','ladmin','20230505-000012',NULL,2900,'60','  Upiqr','  General','ANDI THOOFAN','2.0','1','350',NULL,'20230505165008','','700.00','199','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(49,'05 May 2023','04:50:08 PM','ladmin','20230505-000012',NULL,2900,'60','  Upiqr','  General',' PAPER BOMB','1.0','1','220',NULL,'20230505165008','','220.00','199','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(50,'05 May 2023','04:50:08 PM','ladmin','20230505-000012',NULL,2900,'60','  Upiqr','  General','PAPER BOMB 5 PICE','2.0','1','320',NULL,'20230505165008','','640.00','199','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(51,'05 May 2023','04:51:16 PM','ladmin','20230505-000013',NULL,1750,'0','  Upiqr','  General','15 SHOTS','5.0','1','350.00',NULL,'20230505165116','','1750.00','200','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(52,'05 May 2023','04:52:02 PM','ladmin','20230505-000014',NULL,600,'0','  Upiqr','  General','COLD FIRE C       180','4.0','1','150',NULL,'20230505165202','','600.00','201','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(53,'05 May 2023','08:03:42 PM','ladmin','20230505-000015',NULL,650,'0','  Upiqr','  General','15 SHOTS','1.0','1','350.00',NULL,'20230505200342','','350.00','202','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(54,'05 May 2023','08:03:42 PM','ladmin','20230505-000015',NULL,650,'0','  Upiqr','  General','SELFI STICKE','1.0','1','300',NULL,'20230505200342','','300.00','202','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(55,'05 May 2023','08:41:13 PM','ladmin','20230505-000016',NULL,3200,'0','  Upiqr','  General','200 SHOTS','1.0','1','3200',NULL,'20230505204113','','3200.00','203','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(56,'05 May 2023','09:50:41 PM','ladmin','20230505-000017',NULL,300,'0','  Cash','  General','COLD FIRE C       180','2.0','1','150',NULL,'20230505215041','','300.00','204','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(57,'06 May 2023','10:02:03 AM','ladmin','20230506-000011',NULL,900,'100','  Cash','  General','36 SHOT ABHI','1.0','1','650',NULL,'20230506100203','','650.00','205','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(58,'06 May 2023','10:02:03 AM','ladmin','20230506-000011',NULL,900,'100','  Cash','  General','1000 WALA','1.0','1','350.00',NULL,'20230506100203','','350.00','205','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(59,'06 May 2023','04:46:13 PM','ladmin','20230506-0000110',NULL,19000,'2510','  Cash','  General','SMOKE 5 PICE STD','2.0','1','650',NULL,'20230506164613','','1300.00','214','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(60,'06 May 2023','04:46:13 PM','ladmin','20230506-0000110',NULL,19000,'2510','  Cash','  General','ALL IS WHELL','1.0','1','280',NULL,'20230506164613','','280.00','214','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(61,'06 May 2023','04:46:13 PM','ladmin','20230506-0000110',NULL,19000,'2510','  Cash','  General','TUIRLER','1.0','1','280',NULL,'20230506164613','','280.00','214','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(62,'06 May 2023','04:46:13 PM','ladmin','20230506-0000110',NULL,19000,'2510','  Cash','  General','DEXTER','1.0','1','250',NULL,'20230506164613','','250.00','214','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(63,'06 May 2023','04:46:13 PM','ladmin','20230506-0000110',NULL,19000,'2510','  Cash','  General','5000 WALA','1.0','1','2150',NULL,'20230506164613','','2150.00','214','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(64,'06 May 2023','04:46:13 PM','ladmin','20230506-0000110',NULL,19000,'2510','  Cash','  General','120 SHOTS','3.0','1','2650',NULL,'20230506164613','','7950.00','214','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(65,'06 May 2023','04:46:13 PM','ladmin','20230506-0000110',NULL,19000,'2510','  Cash','  General','100 SHOTS','3.0','1','1450',NULL,'20230506164613','','4350.00','214','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(66,'06 May 2023','04:46:13 PM','ladmin','20230506-0000110',NULL,19000,'2510','  Cash','  General','36 SHOT ABHI','1.0','1','750.00',NULL,'20230506164613','','750.00','214','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(67,'06 May 2023','04:46:13 PM','ladmin','20230506-0000110',NULL,19000,'2510','  Cash','  General','200 SHOTS','1.0','1','3600',NULL,'20230506164613','','3600.00','214','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(68,'06 May 2023','04:46:13 PM','ladmin','20230506-0000110',NULL,19000,'2510','  Cash','  General','12 SHOTS MIX','2.0','1','300.00',NULL,'20230506164613','','600.00','214','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(69,'06 May 2023','04:47:29 PM','ladmin','20230506-0000111',NULL,500,'240','  Cash','  General','3 COMMET','1.0','1','450',NULL,'20230506164729','','450.00','215','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(70,'06 May 2023','04:47:29 PM','ladmin','20230506-0000111',NULL,500,'240','  Cash','  General','60 C.M ELE/COL','1.0','1','290',NULL,'20230506164729','','290.00','215','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(71,'06 May 2023','06:03:31 PM','ladmin','20230506-0000112',NULL,4000,'0','  Upiqr','  General','120 SHOTS','1.0','1','2000',NULL,'20230506180331','','2000.00','216','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(72,'06 May 2023','06:03:31 PM','ladmin','20230506-0000112',NULL,4000,'0','  Upiqr','  General','5000 WALA','1.0','1','2000',NULL,'20230506180331','','2000.00','216','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(73,'06 May 2023','06:59:31 PM','madmin','20230506-0000113',NULL,15000,'0','  Cheque','  General','RSR 40 SHOT','1.0','1','7000.00',NULL,'20230506185931','','7000.00','217','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(74,'06 May 2023','06:59:31 PM','madmin','20230506-0000113',NULL,15000,'0','  Cheque','  General','3 COMMET','20.0','1','400.00',NULL,'20230506185931','','8000.00','217','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(75,'06 May 2023','07:42:06 PM','madmin','20230506-0000114',NULL,3200,'391','  Cash','  General','15 SHOTS','3.0','1','417',NULL,'20230506194206','','1251.00','218','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(76,'06 May 2023','07:42:06 PM','madmin','20230506-0000114',NULL,3200,'391','  Cash','  General','PAPER BOMB 5 PICE','4.0','1','260',NULL,'20230506194206','','1040.00','218','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(77,'06 May 2023','07:42:06 PM','madmin','20230506-0000114',NULL,3200,'391','  Cash','  General','SMOKE 5 PICE STD','2.0','1','650',NULL,'20230506194206','','1300.00','218','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(78,'06 May 2023','09:37:47 PM','madmin','20230506-0000115',NULL,240,'0','  Cash','  General','SOLDIER BOMB','2.0','1','120',NULL,'20230506213747','','240.00','219','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(79,'06 May 2023','10:03:56 AM','ladmin','20230506-000012',NULL,700,'0','  Upiqr','  General','4 PAPER SHOTS','1.0','1','350',NULL,'20230506100356','','350.00','206','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(80,'06 May 2023','10:03:56 AM','ladmin','20230506-000012',NULL,700,'0','  Upiqr','  General','COLD FIRE C       180','2.0','1','150',NULL,'20230506100356','','300.00','206','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(81,'06 May 2023','10:03:56 AM','ladmin','20230506-000012',NULL,700,'0','  Upiqr','  General','BATTERY','2.0','1','25.00',NULL,'20230506100356','','50.00','206','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(82,'06 May 2023','10:04:40 AM','ladmin','20230506-000013',NULL,1800,'150','  Upiqr','  General','SMOKE 5 PICE STD','3.0','1','650',NULL,'20230506100440','','1950.00','207','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(83,'06 May 2023','10:10:12 AM','ladmin','20230506-000014',NULL,1000,'0','  Upiqr','  General','SMOKE FUSE','5.0','1','200',NULL,'20230506101012','','1000.00','208','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(84,'06 May 2023','10:11:07 AM','ladmin','20230506-000015',NULL,2400,'0','  Cash','  General','COLD FIRE C       180','16.0','1','150',NULL,'20230506101107','','2400.00','209','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(85,'06 May 2023','10:18:10 AM','ladmin','20230506-000016',NULL,2400,'50','  Upiqr','  General','1000 WALA','5.0','1','350.00',NULL,'20230506101810','','1750.00','210','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(86,'06 May 2023','10:18:10 AM','ladmin','20230506-000016',NULL,2400,'50','  Upiqr','  General','ANDI THOOFAN','2.0','1','350',NULL,'20230506101810','','700.00','210','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(87,'06 May 2023','04:16:50 PM','ladmin','20230506-000017',NULL,3800,'0','  Cash','  General','120 SHOTS','2.0','1','1900',NULL,'20230506161650','','3800.00','211','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(88,'06 May 2023','04:28:49 PM','ladmin','20230506-000018',NULL,2100,'60','  Upiqr','  General','COLD FIRE C       180','12.0','1','180.00',NULL,'20230506162849','','2160.00','212','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(89,'06 May 2023','04:41:24 PM','ladmin','20230506-000019',NULL,350,'0','  Cash','  General','1000 WALA','1.0','1','350.00',NULL,'20230506164124','','350.00','213','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(90,'07 May 2023','09:40:19 AM','madmin','20230507-000011',NULL,5500,'2000','  Cash','  General','10000 WALA','1.0','1','4200',NULL,'20230507094019','','4200.00','220','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(91,'07 May 2023','09:40:19 AM','madmin','20230507-000011',NULL,5500,'2000','  Cash','  General','21 PAPERSHOT','1.0','1','1850',NULL,'20230507094019','','1850.00','220','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(92,'07 May 2023','09:40:19 AM','madmin','20230507-000011',NULL,5500,'2000','  Cash','  General','60 SHOTS','1.0','1','1450',NULL,'20230507094019','','1450.00','220','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(93,'07 May 2023','06:30:04 PM','madmin','20230507-0000110',NULL,300,'0','  Upiqr','  General','25 SHOTS CRAKKLING','1.0','1','300',NULL,'20230507183004','','300.00','229','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(94,'07 May 2023','06:33:15 PM','madmin','20230507-0000111',NULL,1800,'400','  Cash','  General','60 SHOTS','1.0','1','1450',NULL,'20230507183315','','1450.00','230','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(95,'07 May 2023','06:33:15 PM','madmin','20230507-0000111',NULL,1800,'400','  Cash','  General','2000 WALA','1.0','1','750',NULL,'20230507183315','','750.00','230','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(96,'07 May 2023','06:33:40 PM','madmin','20230507-0000112',NULL,1600,'0','  Upiqr','  General','100 SHOTS','1.0','1','1600',NULL,'20230507183340','','1600.00','231','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(97,'07 May 2023','06:55:52 PM','madmin','20230507-0000113',NULL,0,'0','  Cash','  General','COLD FIRE C       180','12.0','1','0000',NULL,'20230507185552','','0.00','232','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(98,'07 May 2023','07:28:56 PM','madmin','20230507-0000114',NULL,300,'0','  Cash','  General','COLD FIRE C       180','2.0','1','150',NULL,'20230507192856','','300.00','233','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(99,'07 May 2023','08:08:43 PM','madmin','20230507-0000115',NULL,2700,'0','  Cash','  General','COLD FIRE C       180','18.0','1','150',NULL,'20230507200843','','2700.00','234','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(100,'07 May 2023','08:09:54 PM','madmin','20230507-0000116',NULL,3900,'0','  Cash','  General','30 SHOTS','3.0','1','600',NULL,'20230507200954','','1800.00','235','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(101,'07 May 2023','08:09:54 PM','madmin','20230507-0000116',NULL,3900,'0','  Cash','  General','60 SHOTS','1.0','1','900',NULL,'20230507200954','','900.00','235','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(102,'07 May 2023','08:09:54 PM','madmin','20230507-0000116',NULL,3900,'0','  Cash','  General','2000 WALA','3.0','1','400',NULL,'20230507200954','','1200.00','235','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(103,'07 May 2023','08:25:08 PM','madmin','20230507-0000117',NULL,9300,'350','  Upiqr','  General','30 SHOTS','4.0','1','500',NULL,'20230507202508','','2000.00','236','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(104,'07 May 2023','08:25:08 PM','madmin','20230507-0000117',NULL,9300,'350','  Upiqr','  General','60 SHOTS','3.0','1','900',NULL,'20230507202508','','2700.00','236','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(105,'07 May 2023','08:25:08 PM','madmin','20230507-0000117',NULL,9300,'350','  Upiqr','  General','100 SHOTS','3.0','1','1650',NULL,'20230507202508','','4950.00','236','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(106,'07 May 2023','08:33:43 PM','madmin','20230507-0000118',NULL,480,'0','  Cash','  General','30 SHOTS','1.0','1','480',NULL,'20230507203343','','480.00','237','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(107,'07 May 2023','10:18:55 AM','madmin','20230507-000012',NULL,2200,'150','  Upiqr','  General','1000 WALA','3.0','1','350.00',NULL,'20230507101855','','1050.00','221','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(108,'07 May 2023','10:18:55 AM','madmin','20230507-000012',NULL,2200,'150','  Upiqr','  General','2000 WALA','2.0','1','650.00',NULL,'20230507101855','','1300.00','221','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(109,'07 May 2023','11:28:52 AM','madmin','20230507-000013',NULL,4500,'400','  Cash','  General','120 SHOTS','2.0','1','2450',NULL,'20230507112852','','4900.00','222','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(110,'07 May 2023','02:31:11 PM','madmin','20230507-000014',NULL,9000,'1750','  Cash','  General','2000 WALA','4.0','1','650.00',NULL,'20230507143111','','2600.00','223','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(111,'07 May 2023','02:31:11 PM','madmin','20230507-000014',NULL,9000,'1750','  Cash','  General','5000 WALA','1.0','1','2450',NULL,'20230507143111','','2450.00','223','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(112,'07 May 2023','02:31:11 PM','madmin','20230507-000014',NULL,9000,'1750','  Cash','  General','25 SHOTS CRAKKLING','1.0','1','350.00',NULL,'20230507143111','','350.00','223','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(113,'07 May 2023','02:31:11 PM','madmin','20230507-000014',NULL,9000,'1750','  Cash','  General','60 SHOTS','1.0','1','1450',NULL,'20230507143111','','1450.00','223','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(114,'07 May 2023','02:31:11 PM','madmin','20230507-000014',NULL,9000,'1750','  Cash','  General','COLOUR KOTI/GAINT','2.0','1','400',NULL,'20230507143111','','800.00','223','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(115,'07 May 2023','02:31:11 PM','madmin','20230507-000014',NULL,9000,'1750','  Cash','  General','ANDI THOOFAN','2.0','1','350',NULL,'20230507143111','','700.00','223','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(116,'07 May 2023','02:31:11 PM','madmin','20230507-000014',NULL,9000,'1750','  Cash','  General','36 SHOT ABHI','4.0','1','600',NULL,'20230507143111','','2400.00','223','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(117,'07 May 2023','02:37:45 PM','madmin','20230507-000015',NULL,550,'0','  Cash','  General','SMOKE 5 PICE STD','1.0','1','550.00',NULL,'20230507143745','','550.00','224','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(118,'07 May 2023','02:42:18 PM','madmin','20230507-000016',NULL,1100,'0','  Cash','  General','2000 WALA','2.0','1','550',NULL,'20230507144218','','1100.00','225','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(119,'07 May 2023','04:46:32 PM','madmin','20230507-000017',NULL,350,'0','  Cash','  General','COLOUR KOTI/GAINT','1.0','1','350',NULL,'20230507164632','','350.00','226','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(120,'07 May 2023','06:28:51 PM','madmin','20230507-000018',NULL,600,'0','  Cash','  General','COLD FIRE C       180','4.0','1','150',NULL,'20230507182851','','600.00','227','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(121,'07 May 2023','06:29:21 PM','madmin','20230507-000019',NULL,600,'0','  Upiqr','  General','COLD FIRE C       180','4.0','1','150',NULL,'20230507182921','','600.00','228','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(122,'08 May 2023','08:51:42 AM','madmin','20230508-000011',NULL,1800,'0','  Upiqr','  General','60 SHOTS','2.0','1','900',NULL,'20230508085142','','1800.00','238','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(123,'08 May 2023','11:43:30 AM','madmin','20230508-000012',NULL,2600,'0','  Cash','  General','COLD FIRE C       180','12.0','1','150',NULL,'20230508114330','','1800.00','239','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(124,'08 May 2023','11:43:30 AM','madmin','20230508-000012',NULL,2600,'0','  Cash','  General','PAPER BLAST FUSE','5.0','1','160',NULL,'20230508114330','','800.00','239','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(125,'08 May 2023','02:13:45 PM','madmin','20230508-000013',NULL,0,'0','  Cash','  General','SPARKELER GUN','8.0','1','000',NULL,'20230508141345','','0.00','240','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(126,'08 May 2023','06:04:48 PM','madmin','20230508-000014',NULL,6500,'650','  Cash','  General','2000 WALA','2.0','1','750',NULL,'20230508180448','','1500.00','241','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(127,'08 May 2023','06:04:48 PM','madmin','20230508-000014',NULL,6500,'650','  Cash','  General','30 SHOTS','4.0','1','600',NULL,'20230508180448','','2400.00','241','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(128,'08 May 2023','06:04:48 PM','madmin','20230508-000014',NULL,6500,'650','  Cash','  General','60 SHOTS','1.0','1','1450',NULL,'20230508180448','','1450.00','241','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(129,'08 May 2023','06:04:48 PM','madmin','20230508-000014',NULL,6500,'650','  Cash','  General','15 SHOTS','2.0','1','450',NULL,'20230508180448','','900.00','241','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(130,'08 May 2023','06:04:48 PM','madmin','20230508-000014',NULL,6500,'650','  Cash','  General','12 SHOTS MIX','3.0','1','300.00',NULL,'20230508180448','','900.00','241','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(131,'08 May 2023','06:39:48 PM','madmin','20230508-000015',NULL,820,'40','  Pay Later','  General','POP POP','50.0','1','6',NULL,'20230508183948','','300.00','242','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(132,'08 May 2023','06:39:48 PM','madmin','20230508-000015',NULL,820,'40','  Pay Later','  General','PULLING THREAD','80','1','7',NULL,'20230508183948','','560.00','242','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(133,'08 May 2023','06:50:08 PM','madmin','20230508-000016',NULL,1200,'0','  Upiqr','  General','30 SHOTS','2.0','1','600',NULL,'20230508185008','','1200.00','243','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(134,'08 May 2023','10:07:38 PM','ladmin','20230508-000017',NULL,600,'0','  Upiqr','  General','30 SHOTS','1.0','1','600',NULL,'20230508220738','','600.00','244','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(135,'09 May 2023','11:35:36 AM','madmin','20230509-000011',NULL,6000,'0','  Upiqr','  General','2000 WALA','8.0','1','750',NULL,'20230509113536','','6000.00','245','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(136,'09 May 2023','02:02:03 PM','madmin','20230509-000012',NULL,750,'0','  Upiqr','  General','2000 WALA','1.0','1','750',NULL,'20230509140203','','750.00','246','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(137,'09 May 2023','04:36:46 PM','madmin','20230509-000013',NULL,500,'0','  Upiqr','  General','30 SHOTS','1.0','1','500',NULL,'20230509163646','','500.00','247','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(138,'09 May 2023','06:22:33 PM','madmin','20230509-000014',NULL,1500,'0','  Upiqr','  General','2000 WALA','2.0','1','750',NULL,'20230509182233','','1500.00','248','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(139,'09 May 2023','06:59:49 PM','madmin','20230509-000015',NULL,2400,'0','  Upiqr','  General','COLD FIRE C       180','12.0','1','200',NULL,'20230509185949','','2400.00','249','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(140,'09 May 2023','07:44:16 PM','madmin','20230509-000016',NULL,9010,'0','  Cash','  General','PAPER BOMB 5 PICE','1.0','1','260',NULL,'20230509194416','','260.00','250','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(141,'09 May 2023','07:44:16 PM','madmin','20230509-000016',NULL,9010,'0','  Cash','  General','100 SHOTS','2.0','1','1600',NULL,'20230509194416','','3200.00','250','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(142,'09 May 2023','07:44:16 PM','madmin','20230509-000016',NULL,9010,'0','  Cash','  General','120 SHOTS','1.0','1','2150',NULL,'20230509194416','','2150.00','250','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(143,'09 May 2023','07:44:16 PM','madmin','20230509-000016',NULL,9010,'0','  Cash','  General','3 COMMET','9.0','1','300',NULL,'20230509194416','','2700.00','250','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(144,'09 May 2023','07:44:16 PM','madmin','20230509-000016',NULL,9010,'0','  Cash','  General','ANDI THOOFAN','2.0','1','350',NULL,'20230509194416','','700.00','250','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(145,'09 May 2023','07:44:16 PM','madmin','20230509-000016',NULL,9010,'0','  Cash','  General','12 SHOTS MIX','2.0','1','0000',NULL,'20230509194416','','0.00','250','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(146,'09 May 2023','07:49:41 PM','madmin','20230509-000017',NULL,900,'0','  Upiqr','  General','60 SHOTS','1.0','1','900',NULL,'20230509194941','','900.00','251','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(147,'09 May 2023','09:46:18 PM','madmin','20230509-000018',NULL,1900,'145','  Upiqr','  General','COLOUR KOTI/GAINT','2.0','1','300',NULL,'20230509214618','','600.00','252','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(148,'09 May 2023','09:46:18 PM','madmin','20230509-000018',NULL,1900,'145','  Upiqr','  General','30 CO.M ELE/COL','2.0','1','160',NULL,'20230509214618','','320.00','252','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(149,'09 May 2023','09:46:18 PM','madmin','20230509-000018',NULL,1900,'145','  Upiqr','  General','12 CM STD','1.0','1','475',NULL,'20230509214618','','475.00','252','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(150,'09 May 2023','09:46:18 PM','madmin','20230509-000018',NULL,1900,'145','  Upiqr','  General','DLX','1.0','1','650',NULL,'20230509214618','','650.00','252','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(151,'10 May 2023','10:04:34 AM','madmin','20230510-000011',NULL,0,'0','  Cash','  General','36 SHOT ABHI','30.0','1','0000',NULL,'20230510100434','','0.00','253','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(152,'10 May 2023','10:04:34 AM','madmin','20230510-000011',NULL,0,'0','  Cash','  General','SPARKELER GUN','5.0','1','0000',NULL,'20230510100434','','0.00','253','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(153,'10 May 2023','10:08:45 AM','madmin','20230510-000012',NULL,840,'0','  Cash','  General','COLD FIRE C       180','6.0','1','140',NULL,'20230510100845','','840.00','254','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0');
INSERT INTO `itemdata` (`_id`, `itemname`, `total`) VALUES (1,'1000 WALA',2800),(2,'15 PAPER SHOTS',1900),(3,'15 SHOTS',700),(4,'200 SHOTS',3000),(5,'4 PAPER SHOTS',600),(6,'ANDI THOOFAN',700),(7,'PAPER ITEM 2 PICE',1000),(8,'RSR 40 SHOT',6500),(9,'SOLDIER BOMB',600),(10,'RSR 40 SHOT',6500),(11,'SOLDIER BOMB',600),(12,'SPARKELER GUN',350),(13,'SOLDIER BOMB',1100),(14,'SPARKELER GUN',350),(15,'SUPER DLX LAXMI',850),(16,'WIZZILING ROCKET SMALL',440),(17,'PAPER ITEM 2 PICE',1000),(18,'POP POP',360),(19,'PULLING THREAD',30),(20,'RSR 40 SHOT',6500),(21,'SMOKE  5 PICES',250),(22,'SOLDIER BOMB',1100),(23,'SPARKELER GUN',350),(24,'SUPER DLX LAXMI',850),(25,'WIZZILING ROCKET SMALL',440),(26,'COLD FIRE A       320',700),(27,'COLD FIRE C       180',15480),(28,'COLOUR KOTI/GAINT',1750),(29,'DEXTER',250),(30,'DLX',650),(31,'PAPER BLAST FUSE',2300),(32,'PAPER BOMB 5 PICE',1940),(33,'PAPER ITEM 2 PICE',1000),(34,'POP POP',650),(35,'PULLING THREAD',590),(36,'RSR 40 SHOT',13500),(37,'SELFI STICKE',300),(38,'SMOKE  5 PICES',250),(39,'SMOKE 5 PICE STD',10100),(40,'SMOKE FUSE',1000),(41,'SOLDIER BOMB',1340),(42,'SPARKELER GUN',1350),(43,'SUPER DLX LAXMI',850),(44,'TUIRLER',280),(45,'WIZZILING ROCKET SMALL',440),(46,'CUTE F.P',525),(47,'DLX LAXMI',1250),(48,'FLOWER POTS  BIG',80),(49,'FLOWER POTS ASHOKA',800),(50,'GOLD SHOWER',140),(51,'GROUND CHAKKERS DLX STD',600),(52,'GUNS PLASTICK',1000),(53,'HALDHI THUFAN',1350),(54,'HOT WHEEL',240),(55,'LUNIK',640),(56,'MINES',2750),(57,'PAPER BLAST FUSE',460),(58,'PAPER BOMB SMALL',130),(59,'PAPER ITEM 2 PICE',2020),(60,'PARADIESE 250 SHOT',5000),(61,'POP POP',580),(62,'PULLING THREAD',200),(63,'RED BIJILI 100 PICES',140),(64,'RED BIJILI 50 PICES',40),(65,'RSR 40 SHOT',11300),(66,'SADDAM BOMB',1350),(67,'SELFI STICKE',250),(68,'SMOKE  5 PICES',1050),(69,'SMOKE 5 PICE STD',2800),(70,'SOLDIER BOMB',3250),(71,'SPARKELER GUN',650),(72,'STD HYDRO BOMB',400),(73,'VIP',4870),(74,'WIZZILING ROCKET SMALL',580);
INSERT INTO `itemwiseorderlistcategory` (`_id`, `itemno`, `categoryname`, `sales`, `salespercentage`, `itemtotalquan`) VALUES (1,NULL,'ATOM BOMBS',1100,7,'6'),(2,NULL,'COLD FIRE /GUNS/BATTERYS',4110,28,'23'),(3,NULL,'COMMETS',2750,19,'5'),(4,NULL,'LAR ITEMS',4010,27,'8'),(5,NULL,'SHOTS',3300,22,'7'),(6,NULL,'LAR ITEMS',16650,21,'34'),(7,NULL,'LAXMI ITEMS',800,1,'6'),(8,NULL,'PAPER ITEMS',3320,4,'12'),(9,NULL,'ROCKETS',1220,2,'6'),(10,NULL,'SHOTS',44450,55,'52'),(11,NULL,'SMOKE ITEMS',2000,3,'4');
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,'5','1000 WALA',2800,16,'8','LAR ITEMS',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(2,'28','15 PAPER SHOTS',1900,11,'2','PAPER ITEMS',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(3,'34','15 SHOTS',700,4,'2','SHOTS',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(4,'43','200 SHOTS',3000,17,'1','SHOTS',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(5,'24','4 PAPER SHOTS',600,3,'2','PAPER ITEMS',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(6,'268','ANDI THOOFAN',700,4,'2','ATOM BOMBS',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(7,'22','PAPER ITEM 2 PICE',1000,6,'4','PAPER ITEMS',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(8,'273','RSR 40 SHOT',6500,37,'1','None',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(9,'124','SOLDIER BOMB',600,3,'5','ATOM BOMBS',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10,'273','RSR 40 SHOT',6500,32,'1','None',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(11,'124','SOLDIER BOMB',600,3,'5','ATOM BOMBS',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(12,'81','SPARKELER GUN',350,2,'1','COLD FIRE /GUNS/BATTERYS',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(13,'124','SOLDIER BOMB',1100,4,'10','ATOM BOMBS',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(14,'81','SPARKELER GUN',350,1,'1','COLD FIRE /GUNS/BATTERYS',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(15,'137','SUPER DLX LAXMI',850,3,'1','LAXMI ITEMS',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(16,'150','WIZZILING ROCKET SMALL',440,2,'2','ROCKETS',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(17,'22','PAPER ITEM 2 PICE',1000,3,'4','PAPER ITEMS',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(18,'179','POP POP',360,1,'51','CHILDREN ITEMS',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(19,'180','PULLING THREAD',30,0,'3','CHILDREN ITEMS',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(20,'273','RSR 40 SHOT',6500,17,'1','None',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(21,'19','SMOKE  5 PICES',250,1,'1','SMOKE ITEMS',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(22,'124','SOLDIER BOMB',1100,3,'10','ATOM BOMBS',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(23,'81','SPARKELER GUN',350,1,'1','COLD FIRE /GUNS/BATTERYS',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(24,'137','SUPER DLX LAXMI',850,2,'1','LAXMI ITEMS',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(25,'150','WIZZILING ROCKET SMALL',440,1,'2','ROCKETS',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(26,'73','COLD FIRE A       320',700,0,'2','COLD FIRE /GUNS/BATTERYS',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(27,'75','COLD FIRE C       180',15480,7,'109','COLD FIRE /GUNS/BATTERYS',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(28,'95','COLOUR KOTI/GAINT',1750,1,'5','FLOWER POTS',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(29,'194','DEXTER',250,0,'1','FANCY ITEMS',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(30,'86','DLX',650,0,'1','COLD FIRE /GUNS/BATTERYS',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(31,'21','PAPER BLAST FUSE',2300,1,'15','PAPER ITEMS',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(32,'31','PAPER BOMB 5 PICE',1940,1,'7','PAPER ITEMS',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(33,'22','PAPER ITEM 2 PICE',1000,1,'4','PAPER ITEMS',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(34,'179','POP POP',650,0,'100','CHILDREN ITEMS',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(35,'180','PULLING THREAD',590,0,'83','CHILDREN ITEMS',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(36,'273','RSR 40 SHOT',13500,6,'2','None',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(37,'229','SELFI STICKE',300,0,'1','FANCY ITEMS',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(38,'19','SMOKE  5 PICES',250,0,'1','SMOKE ITEMS',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(39,'20','SMOKE 5 PICE STD',10100,5,'18','SMOKE ITEMS',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(40,'275','SMOKE FUSE',1000,1,'5','SMOKE ITEMS',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(41,'124','SOLDIER BOMB',1340,1,'12','ATOM BOMBS',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(42,'81','SPARKELER GUN',1350,1,'16','COLD FIRE /GUNS/BATTERYS',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(43,'137','SUPER DLX LAXMI',850,0,'1','LAXMI ITEMS',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(44,'192','TUIRLER',280,0,'1','FANCY ITEMS',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(45,'150','WIZZILING ROCKET SMALL',440,0,'2','ROCKETS',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(46,'193','CUTE F.P',525,0,'1','FANCY ITEMS',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(47,'136','DLX LAXMI',1250,0,'2','LAXMI ITEMS',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(48,'92','FLOWER POTS  BIG',80,0,'1','FLOWER POTS',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(49,'94','FLOWER POTS ASHOKA',800,0,'3','FLOWER POTS',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(50,'202','GOLD SHOWER',140,0,'1','FANCY ITEMS',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(51,'202','GROUND CHAKKERS DLX STD',600,0,'2','GROUND CHAKKARS',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(52,'76','GUNS PLASTICK',1000,0,'3','COLD FIRE /GUNS/BATTERYS',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(53,'76','HALDHI THUFAN',1350,0,'4','ATOM BOMBS',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(54,'116','HOT WHEEL',240,0,'1','GROUND CHAKKARS',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(55,'147','LUNIK',640,0,'4','ROCKETS',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(56,'56','MINES',2750,1,'5','COMMETS',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(57,'21','PAPER BLAST FUSE',460,0,'3','PAPER ITEMS',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(58,'30','PAPER BOMB SMALL',130,0,'2','PAPER ITEMS',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(59,'22','PAPER ITEM 2 PICE',2020,1,'10','PAPER ITEMS',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(60,'260','PARADIESE 250 SHOT',5000,1,'1','SHOTS',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(61,'179','POP POP',580,0,'24','CHILDREN ITEMS',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(62,'180','PULLING THREAD',200,0,'16','CHILDREN ITEMS',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(63,'178','RED BIJILI 100 PICES',140,0,'4','CHILDREN ITEMS',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(64,'177','RED BIJILI 50 PICES',40,0,'1','CHILDREN ITEMS',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(65,'273','RSR 40 SHOT',11300,3,'2','None',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(66,'131','SADDAM BOMB',1350,0,'14','ATOM BOMBS',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(67,'229','SELFI STICKE',250,0,'1','FANCY ITEMS',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(68,'19','SMOKE  5 PICES',1050,0,'4','SMOKE ITEMS',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(69,'20','SMOKE 5 PICE STD',2800,1,'5','SMOKE ITEMS',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(70,'124','SOLDIER BOMB',3250,1,'32','ATOM BOMBS',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(71,'81','SPARKELER GUN',650,0,'1','COLD FIRE /GUNS/BATTERYS',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(72,'132','STD HYDRO BOMB',400,0,'5','ATOM BOMBS',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(73,'267','VIP',4870,1,'18','ATOM BOMBS',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(74,'150','WIZZILING ROCKET SMALL',580,0,'2','ROCKETS',NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO `top_category` (`_id`, `category`, `value`) VALUES (81,'COLD FIRE /GUNS/BATTERYS',450),(82,'LAR ITEMS',6120),(83,'PAPER ITEMS',250),(84,'SMOKE ITEMS',750),(85,'COLD FIRE /GUNS/BATTERYS',930),(86,'LAR ITEMS',7700),(87,'PAPER ITEMS',250),(88,'SHOTS',1500),(89,'SMOKE ITEMS',750),(90,'COLD FIRE /GUNS/BATTERYS',930),(91,'LAR ITEMS',7800),(92,'PAPER ITEMS',250),(93,'SHOTS',1500),(94,'SMOKE ITEMS',750),(249,'ATOM BOMBS',1300),(250,'LAR ITEMS',2800),(251,'None',6500),(252,'PAPER ITEMS',3500),(253,'SHOTS',3700),(266,'ATOM BOMBS',1300),(267,'COLD FIRE /GUNS/BATTERYS',1050),(268,'LAR ITEMS',2800),(269,'None',6500),(270,'PAPER ITEMS',3500),(271,'SHOTS',5000),(272,'ATOM BOMBS',1300),(273,'COLD FIRE /GUNS/BATTERYS',1050),(274,'LAR ITEMS',2800),(275,'None',6500),(276,'PAPER ITEMS',3500),(277,'SHOTS',5000),(278,'ATOM BOMBS',2500),(279,'COLD FIRE /GUNS/BATTERYS',1050),(280,'LAR ITEMS',5600),(281,'LAXMI ITEMS',850),(282,'None',6500),(283,'PAPER ITEMS',3500),(284,'ROCKETS',440),(285,'SHOTS',8920),(301,'ATOM BOMBS',2500),(302,'CHILDREN ITEMS',390),(303,'COLD FIRE /GUNS/BATTERYS',1600),(304,'LAR ITEMS',6360),(305,'LAXMI ITEMS',850),(306,'None',6500),(307,'PAPER ITEMS',5000),(308,'ROCKETS',440),(309,'SHOTS',14570),(310,'SMOKE ITEMS',250),(311,'LAR ITEMS',1350),(312,'SHOTS',3350),(313,'SMOKE ITEMS',5000),(314,'COLD FIRE /GUNS/BATTERYS',1480),(315,'LAR ITEMS',2100),(316,'SHOTS',9050),(317,'SMOKE ITEMS',5000),(334,'COLD FIRE /GUNS/BATTERYS',1480),(335,'LAR ITEMS',2100),(336,'SHOTS',9050),(337,'SMOKE ITEMS',5000),(338,'ATOM BOMBS',700),(339,'LAR ITEMS',2100),(340,'SHOTS',2400),(369,'ATOM BOMBS',1400),(370,'COLD FIRE /GUNS/BATTERYS',600),(371,'LAR ITEMS',3500),(372,'PAPER ITEMS',860),(373,'SHOTS',4150),(380,'ATOM BOMBS',1400),(381,'COLD FIRE /GUNS/BATTERYS',600),(382,'FANCY ITEMS',300),(383,'LAR ITEMS',3500),(384,'PAPER ITEMS',860),(385,'SHOTS',7700),(386,'ATOM BOMBS',1400),(387,'COLD FIRE /GUNS/BATTERYS',900),(388,'FANCY ITEMS',300),(389,'LAR ITEMS',3500),(390,'PAPER ITEMS',860),(391,'SHOTS',7700),(392,'COLD FIRE /GUNS/BATTERYS',350),(393,'LAR ITEMS',350),(394,'PAPER ITEMS',350),(395,'SHOTS',650),(396,'SMOKE ITEMS',2950),(407,'ATOM BOMBS',700),(408,'COLD FIRE /GUNS/BATTERYS',4910),(409,'COMMETS',8450),(410,'FANCY ITEMS',810),(411,'LAR ITEMS',6600),(412,'None',7000),(413,'PAPER ITEMS',350),(414,'SHOTS',23700),(415,'SMOKE ITEMS',4250),(416,'SPARKLERS',290),(417,'LAR ITEMS',4200),(418,'SHOTS',3300),(419,'ATOM BOMBS',700),(420,'FLOWER POTS',800),(421,'LAR ITEMS',12700),(422,'SHOTS',12400),(423,'SMOKE ITEMS',550),(424,'ATOM BOMBS',700),(425,'FLOWER POTS',1150),(426,'LAR ITEMS',12700),(427,'SHOTS',12400),(428,'SMOKE ITEMS',550),(429,'ATOM BOMBS',700),(430,'COLD FIRE /GUNS/BATTERYS',1200),(431,'FLOWER POTS',1150),(432,'LAR ITEMS',13450),(433,'SHOTS',15750),(434,'SMOKE ITEMS',550),(435,'ATOM BOMBS',700),(436,'COLD FIRE /GUNS/BATTERYS',1200),(437,'FLOWER POTS',1150),(438,'LAR ITEMS',13450),(439,'SHOTS',15750),(440,'SMOKE ITEMS',550),(441,'ATOM BOMBS',700),(442,'COLD FIRE /GUNS/BATTERYS',1500),(443,'FLOWER POTS',1150),(444,'LAR ITEMS',13450),(445,'SHOTS',15750),(446,'SMOKE ITEMS',550),(447,'ATOM BOMBS',700),(448,'COLD FIRE /GUNS/BATTERYS',4200),(449,'FLOWER POTS',1150),(450,'LAR ITEMS',14650),(451,'SHOTS',18450),(452,'SMOKE ITEMS',550),(453,'ATOM BOMBS',700),(454,'COLD FIRE /GUNS/BATTERYS',4200),(455,'FLOWER POTS',1150),(456,'LAR ITEMS',14650),(457,'SHOTS',28580),(458,'SMOKE ITEMS',550),(459,'ATOM BOMBS',700),(460,'COLD FIRE /GUNS/BATTERYS',4200),(461,'FLOWER POTS',1150),(462,'LAR ITEMS',14650),(463,'SHOTS',28580),(464,'SMOKE ITEMS',550),(465,'ATOM BOMBS',700),(466,'COLD FIRE /GUNS/BATTERYS',4200),(467,'FLOWER POTS',1150),(468,'LAR ITEMS',14650),(469,'SHOTS',28580),(470,'SMOKE ITEMS',550),(472,'ATOM BOMBS',700),(473,'COLD FIRE /GUNS/BATTERYS',4200),(474,'FLOWER POTS',1150),(475,'LAR ITEMS',14650),(476,'SHOTS',30380),(477,'SMOKE ITEMS',550),(478,'COLD FIRE /GUNS/BATTERYS',1800),(479,'PAPER ITEMS',800),(480,'SHOTS',1800),(486,'CHILDREN ITEMS',860),(487,'COLD FIRE /GUNS/BATTERYS',1800),(488,'LAR ITEMS',1500),(489,'PAPER ITEMS',800),(490,'SHOTS',7450),(501,'ATOM BOMBS',2500),(502,'COLD FIRE /GUNS/BATTERYS',1050),(503,'LAR ITEMS',5600),(504,'LAXMI ITEMS',850),(505,'None',6500),(506,'PAPER ITEMS',3500),(507,'ROCKETS',440),(508,'SHOTS',8920),(514,'ATOM BOMBS',2500),(515,'COLD FIRE /GUNS/BATTERYS',1050),(516,'LAR ITEMS',5600),(517,'LAXMI ITEMS',850),(518,'None',6500),(519,'PAPER ITEMS',3500),(520,'ROCKETS',440),(521,'SHOTS',8920),(522,'LAR ITEMS',6750),(523,'SHOTS',500),(524,'ATOM BOMBS',700),(525,'COLD FIRE /GUNS/BATTERYS',2400),(526,'COMMETS',2700),(527,'LAR ITEMS',8250),(528,'PAPER ITEMS',260),(529,'SHOTS',5850),(530,'ATOM BOMBS',700),(531,'COLD FIRE /GUNS/BATTERYS',2400),(532,'COMMETS',2700),(533,'LAR ITEMS',8250),(534,'PAPER ITEMS',260),(535,'SHOTS',6750),(536,'ATOM BOMBS',700),(537,'COLD FIRE /GUNS/BATTERYS',2400),(538,'COMMETS',2700),(539,'LAR ITEMS',8250),(540,'PAPER ITEMS',260),(541,'SHOTS',6750),(542,'ATOM BOMBS',700),(543,'COLD FIRE /GUNS/BATTERYS',2400),(544,'COMMETS',2700),(545,'LAR ITEMS',8250),(546,'PAPER ITEMS',260),(547,'SHOTS',6750),(548,'ATOM BOMBS',700),(549,'COLD FIRE /GUNS/BATTERYS',3050),(550,'COMMETS',2700),(551,'FLOWER POTS',600),(552,'LAR ITEMS',8250),(553,'PAPER ITEMS',260),(554,'SHOTS',6750),(555,'SPARKLERS',795),(558,'ATOM BOMBS',6240),(559,'CHILDREN ITEMS',1240),(560,'COLD FIRE /GUNS/BATTERYS',18480),(561,'COMMETS',11150),(562,'FANCY ITEMS',1110),(563,'FLOWER POTS',1750),(564,'LAR ITEMS',42960),(565,'LAXMI ITEMS',850),(566,'None',13500),(567,'PAPER ITEMS',8310),(568,'ROCKETS',440),(569,'SHOTS',98351),(570,'SMOKE ITEMS',11350),(571,'SPARKLERS',1085),(572,'COLD FIRE /GUNS/BATTERYS',840),(573,'LAR ITEMS',3650),(574,'SHOTS',0),(575,'COLD FIRE /GUNS/BATTERYS',840),(576,'LAR ITEMS',9350),(577,'PAPER ITEMS',1200),(578,'SHOTS',2000),(579,'COLD FIRE /GUNS/BATTERYS',1000),(580,'LAR ITEMS',13100),(581,'PAPER ITEMS',1200),(582,'SHOTS',2200),(583,'COLD FIRE /GUNS/BATTERYS',1000),(584,'FLOWER POTS',150),(585,'LAR ITEMS',13450),(586,'PAPER ITEMS',1200),(587,'SHOTS',2900),(588,'LAR ITEMS',4300),(589,'SHOTS',6250),(590,'SMOKE ITEMS',1100),(591,'LAR ITEMS',4560),(592,'PAPER ITEMS',650),(593,'SHOTS',7150),(594,'SMOKE ITEMS',1100),(595,'ATOM BOMBS',1400),(596,'LAR ITEMS',9810),(597,'PAPER ITEMS',650),(598,'SHOTS',7850),(599,'SMOKE ITEMS',1100),(600,'ATOM BOMBS',1800),(601,'COLD FIRE /GUNS/BATTERYS',1500),(602,'COMMETS',1750),(603,'FLOWER POTS',400),(604,'LAR ITEMS',5150),(605,'PAPER ITEMS',750),(606,'SHOTS',10100),(607,'SMOKE ITEMS',400),(608,'ATOM BOMBS',1800),(609,'COLD FIRE /GUNS/BATTERYS',1500),(610,'COMMETS',1750),(611,'FLOWER POTS',400),(612,'LAR ITEMS',5850),(613,'PAPER ITEMS',750),(614,'SHOTS',11400),(615,'SMOKE ITEMS',400),(624,'ATOM BOMBS',2450),(625,'COLD FIRE /GUNS/BATTERYS',2200),(626,'COMMETS',5000),(627,'FLOWER POTS',400),(628,'LAR ITEMS',13350),(629,'PAPER ITEMS',750),(630,'SHOTS',22200),(631,'SMOKE ITEMS',2300),(632,'ATOM BOMBS',2450),(633,'COLD FIRE /GUNS/BATTERYS',3760),(634,'COMMETS',5000),(635,'FLOWER POTS',400),(636,'LAR ITEMS',13350),(637,'PAPER ITEMS',750),(638,'SHOTS',27950),(639,'SMOKE ITEMS',2300),(640,'ATOM BOMBS',2450),(641,'COLD FIRE /GUNS/BATTERYS',4060),(642,'COMMETS',5000),(643,'FLOWER POTS',400),(644,'LAR ITEMS',13350),(645,'PAPER ITEMS',750),(646,'SHOTS',27950),(647,'SMOKE ITEMS',2300),(648,'ATOM BOMBS',2450),(649,'COLD FIRE /GUNS/BATTERYS',4712),(650,'COMMETS',5000),(651,'FLOWER POTS',400),(652,'LAR ITEMS',13350),(653,'PAPER ITEMS',750),(654,'SHOTS',27950),(655,'SMOKE ITEMS',2300),(661,'ATOM BOMBS',180),(662,'COLD FIRE /GUNS/BATTERYS',1800),(663,'COMMETS',600),(664,'LAR ITEMS',9050),(665,'SHOTS',10900),(666,'ATOM BOMBS',180),(667,'COLD FIRE /GUNS/BATTERYS',1800),(668,'COMMETS',600),(669,'LAR ITEMS',10850),(670,'PAPER ITEMS',300),(671,'SHOTS',12000),(672,'ATOM BOMBS',180),(673,'COLD FIRE /GUNS/BATTERYS',1800),(674,'COMMETS',600),(675,'LAR ITEMS',13550),(676,'PAPER ITEMS',300),(677,'SHOTS',17000),(684,'ATOM BOMBS',180),(685,'COLD FIRE /GUNS/BATTERYS',1800),(686,'COMMETS',5350),(687,'LAR ITEMS',22850),(688,'PAPER ITEMS',300),(689,'SHOTS',33350),(719,'ATOM BOMBS',180),(720,'COLD FIRE /GUNS/BATTERYS',1800),(721,'COMMETS',5350),(722,'LAR ITEMS',22850),(723,'PAPER ITEMS',300),(724,'SHOTS',33350),(730,'ATOM BOMBS',1500),(731,'FLOWER POTS',500),(732,'LAR ITEMS',4850),(733,'LAXMI ITEMS',60),(734,'SHOTS',11650),(735,'ATOM BOMBS',1500),(736,'COMMETS',850),(737,'FLOWER POTS',500),(738,'LAR ITEMS',7800),(739,'LAXMI ITEMS',60),(740,'SHOTS',15750),(741,'ATOM BOMBS',1500),(742,'COMMETS',850),(743,'FANCY ITEMS',650),(744,'FLOWER POTS',500),(745,'LAR ITEMS',10750),(746,'LAXMI ITEMS',60),(747,'SHOTS',19350),(748,'SPARKLERS',300),(749,'ATOM BOMBS',1500),(750,'COMMETS',850),(751,'FANCY ITEMS',650),(752,'FLOWER POTS',500),(753,'LAR ITEMS',10750),(754,'LAXMI ITEMS',60),(755,'SHOTS',25350),(756,'SPARKLERS',300),(787,'ATOM BOMBS',1500),(788,'COMMETS',850),(789,'FANCY ITEMS',650),(790,'FLOWER POTS',500),(791,'LAR ITEMS',10750),(792,'LAXMI ITEMS',60),(793,'SHOTS',25350),(794,'SPARKLERS',300),(795,'ATOM BOMBS',1500),(796,'COMMETS',850),(797,'FANCY ITEMS',650),(798,'FLOWER POTS',500),(799,'LAR ITEMS',10750),(800,'LAXMI ITEMS',60),(801,'SHOTS',25350),(802,'SPARKLERS',300),(803,'ATOM BOMBS',1500),(804,'COMMETS',850),(805,'FANCY ITEMS',650),(806,'FLOWER POTS',500),(807,'LAR ITEMS',11450),(808,'LAXMI ITEMS',60),(809,'SHOTS',26850),(810,'SPARKLERS',300),(811,'COLD FIRE /GUNS/BATTERYS',1350),(812,'SHOTS',600),(813,'COLD FIRE /GUNS/BATTERYS',3270),(814,'COMMETS',500),(815,'SHOTS',3100),(816,'COLD FIRE /GUNS/BATTERYS',3270),(817,'COMMETS',500),(818,'LAR ITEMS',2250),(819,'SHOTS',5750),(820,'COLD FIRE /GUNS/BATTERYS',3720),(821,'COMMETS',500),(822,'LAR ITEMS',2250),(823,'SHOTS',6950),(824,'COLD FIRE /GUNS/BATTERYS',3870),(825,'COMMETS',500),(826,'LAR ITEMS',2250),(827,'SHOTS',6950),(828,'COLD FIRE /GUNS/BATTERYS',3870),(829,'COMMETS',500),(830,'LAR ITEMS',2250),(831,'SHOTS',7450),(832,'CHILDREN ITEMS',50),(833,'COLD FIRE /GUNS/BATTERYS',300),(834,'LAR ITEMS',1350),(835,'SHOTS',1500),(836,'SMOKE ITEMS',200),(837,'CHILDREN ITEMS',70),(838,'COLD FIRE /GUNS/BATTERYS',600),(839,'FANCY ITEMS',30),(840,'FLOWER POTS',180),(841,'GROUND CHAKKARS',240),(842,'LAR ITEMS',1350),(843,'SHOTS',1500),(844,'SMOKE ITEMS',200),(845,'SPARKLERS',150),(855,'CHILDREN ITEMS',70),(856,'COLD FIRE /GUNS/BATTERYS',600),(857,'FANCY ITEMS',200),(858,'FLOWER POTS',180),(859,'GROUND CHAKKARS',240),(860,'LAR ITEMS',1350),(861,'SHOTS',1500),(862,'SMOKE ITEMS',200),(863,'SPARKLERS',150),(864,'CHILDREN ITEMS',70),(865,'COLD FIRE /GUNS/BATTERYS',600),(866,'FANCY ITEMS',200),(867,'FLOWER POTS',180),(868,'GROUND CHAKKARS',240),(869,'LAR ITEMS',1350),(870,'LAXMI ITEMS',100),(871,'SHOTS',2100),(872,'SMOKE ITEMS',200),(873,'SPARKLERS',150),(874,'CHILDREN ITEMS',70),(875,'COLD FIRE /GUNS/BATTERYS',600),(876,'FANCY ITEMS',200),(877,'FLOWER POTS',180),(878,'GROUND CHAKKARS',240),(879,'LAR ITEMS',1350),(880,'LAXMI ITEMS',100),(881,'SHOTS',2100),(882,'SMOKE ITEMS',200),(883,'SPARKLERS',150),(885,'ATOM BOMBS',1500),(886,'CHILDREN ITEMS',70),(887,'COLD FIRE /GUNS/BATTERYS',4470),(888,'COMMETS',1350),(889,'FANCY ITEMS',850),(890,'FLOWER POTS',680),(891,'GROUND CHAKKARS',240),(892,'LAR ITEMS',15050),(893,'LAXMI ITEMS',160),(894,'PAPER ITEMS',650),(895,'SHOTS',36400),(896,'SMOKE ITEMS',200),(897,'SPARKLERS',450),(898,'ATOM BOMBS',1500),(899,'CHILDREN ITEMS',70),(900,'COLD FIRE /GUNS/BATTERYS',4470),(901,'COMMETS',1350),(902,'FANCY ITEMS',850),(903,'FLOWER POTS',680),(904,'GROUND CHAKKARS',240),(905,'LAR ITEMS',15050),(906,'LAXMI ITEMS',160),(907,'PAPER ITEMS',650),(908,'SHOTS',36400),(909,'SMOKE ITEMS',200),(910,'SPARKLERS',450),(911,'ATOM BOMBS',600),(912,'COMMETS',900),(913,'LAR ITEMS',9850),(914,'COLD FIRE /GUNS/BATTERYS',1900),(915,'SHOTS',4500),(916,'ATOM BOMBS',300),(917,'COLD FIRE /GUNS/BATTERYS',300),(918,'LAR ITEMS',1200),(919,'PAPER ITEMS',400),(920,'SHOTS',1100),(921,'ATOM BOMBS',300),(922,'CHILDREN ITEMS',40),(923,'COLD FIRE /GUNS/BATTERYS',300),(924,'FLOWER POTS',200),(925,'LAR ITEMS',1200),(926,'PAPER ITEMS',400),(927,'SHOTS',2900),(928,'ATOM BOMBS',300),(929,'CHILDREN ITEMS',40),(930,'COLD FIRE /GUNS/BATTERYS',1500),(931,'FLOWER POTS',400),(932,'LAR ITEMS',1200),(933,'PAPER ITEMS',400),(934,'SHOTS',2900),(935,'SPARKLERS',150),(936,'ATOM BOMBS',300),(937,'CHILDREN ITEMS',40),(938,'COLD FIRE /GUNS/BATTERYS',1500),(939,'FLOWER POTS',400),(940,'LAR ITEMS',1200),(941,'PAPER ITEMS',400),(942,'SHOTS',2900),(943,'SPARKLERS',150),(944,'COLD FIRE /GUNS/BATTERYS',2160),(945,'SHOTS',2100),(946,'COLD FIRE /GUNS/BATTERYS',3680),(947,'LAR ITEMS',700),(948,'SHOTS',4800),(949,'COLD FIRE /GUNS/BATTERYS',3680),(950,'LAR ITEMS',2000),(951,'SHOTS',4800),(952,'COLD FIRE /GUNS/BATTERYS',3980),(953,'LAR ITEMS',2350),(954,'SHOTS',5300),(955,'COLD FIRE /GUNS/BATTERYS',4280),(956,'LAR ITEMS',2350),(957,'SHOTS',5800),(958,'COLD FIRE /GUNS/BATTERYS',6800),(959,'LAR ITEMS',750),(960,'SHOTS',7600),(961,'ATOM BOMBS',200),(962,'COLD FIRE /GUNS/BATTERYS',6800),(963,'LAR ITEMS',750),(964,'LAXMI ITEMS',175),(965,'SHOTS',7600),(966,'ATOM BOMBS',550),(967,'CHILDREN ITEMS',30),(968,'COLD FIRE /GUNS/BATTERYS',7450),(969,'LAR ITEMS',750),(970,'LAXMI ITEMS',175),(971,'SHOTS',8800),(972,'CHILDREN ITEMS',100),(973,'COLD FIRE /GUNS/BATTERYS',2850),(974,'COMMETS',11250),(975,'LAR ITEMS',14600),(976,'PAPER ITEMS',1300),(977,'SHOTS',55750),(978,'SMOKE ITEMS',550),(979,'COLD FIRE /GUNS/BATTERYS',300),(980,'LAR ITEMS',2150),(981,'SHOTS',5200),(982,'SMOKE ITEMS',200),(983,'COLD FIRE /GUNS/BATTERYS',300),(984,'LAR ITEMS',2150),(985,'SHOTS',5200),(986,'SMOKE ITEMS',200),(987,'COLD FIRE /GUNS/BATTERYS',300),(988,'LAR ITEMS',2150),(989,'SHOTS',6350),(990,'SMOKE ITEMS',200),(991,'LAR ITEMS',350),(992,'SHOTS',400),(993,'LAR ITEMS',350),(994,'SHOTS',400),(999,'COLD FIRE /GUNS/BATTERYS',300),(1000,'LAR ITEMS',2750),(1001,'SHOTS',8700),(1002,'SMOKE ITEMS',200),(1003,'LAR ITEMS',350),(1004,'SHOTS',3500),(1008,'COLD FIRE /GUNS/BATTERYS',1400),(1009,'COMMETS',200),(1010,'SHOTS',1000),(1011,'COLD FIRE /GUNS/BATTERYS',1400),(1012,'COMMETS',200),(1013,'PAPER ITEMS',200),(1014,'SHOTS',1650),(1015,'SMOKE ITEMS',200),(1021,'COLD FIRE /GUNS/BATTERYS',1400),(1022,'COMMETS',200),(1023,'PAPER ITEMS',200),(1024,'SHOTS',1650),(1025,'SMOKE ITEMS',200),(1026,'ATOM BOMBS',800),(1027,'COLD FIRE /GUNS/BATTERYS',2060),(1028,'COMMETS',400),(1029,'LAR ITEMS',6300),(1030,'SHOTS',3600),(1037,'ATOM BOMBS',800),(1038,'COLD FIRE /GUNS/BATTERYS',2060),(1039,'COMMETS',400),(1040,'LAR ITEMS',6300),(1041,'SHOTS',4200),(1042,'SMOKE ITEMS',300),(1047,'SHOTS',87500),(1048,'SMOKE ITEMS',2500),(1049,'COLD FIRE /GUNS/BATTERYS',3150),(1050,'FLOWER POTS',240),(1051,'LAR ITEMS',2180),(1052,'PAPER ITEMS',650),(1053,'SHOTS',7300),(1054,'SMOKE ITEMS',500),(1071,'COLD FIRE /GUNS/BATTERYS',3450),(1072,'FLOWER POTS',240),(1073,'LAR ITEMS',3980),(1074,'PAPER ITEMS',650),(1075,'SHOTS',7300),(1076,'SMOKE ITEMS',1250),(1077,'SHOTS',2700),(1078,'COLD FIRE /GUNS/BATTERYS',0),(1079,'SHOTS',2700),(1080,'COLD FIRE /GUNS/BATTERYS',350),(1081,'SHOTS',2700),(1084,'COLD FIRE /GUNS/BATTERYS',350),(1085,'SHOTS',3300),(1086,'COLD FIRE /GUNS/BATTERYS',350),(1087,'SHOTS',3300),(1089,'ATOM BOMBS',1750),(1090,'COLD FIRE /GUNS/BATTERYS',11010),(1091,'COMMETS',2750),(1092,'FLOWER POTS',650),(1093,'LAR ITEMS',8310),(1094,'SHOTS',9600),(1095,'SMOKE ITEMS',17550),(1096,'SPARKLERS',150),(1097,'COLD FIRE /GUNS/BATTERYS',2000),(1098,'LAR ITEMS',350),(1099,'PAPER ITEMS',650),(1100,'SHOTS',1150),(1101,'COLD FIRE /GUNS/BATTERYS',2000),(1102,'LAR ITEMS',350),(1103,'PAPER ITEMS',650),(1104,'SHOTS',1150),(1105,'COLD FIRE /GUNS/BATTERYS',3800),(1106,'LAR ITEMS',350),(1107,'PAPER ITEMS',650),(1108,'SHOTS',1150),(1178,'PAPER ITEMS',650),(1196,'COLD FIRE /GUNS/BATTERYS',7900),(1197,'FANCY ITEMS',320),(1198,'FLOWER POTS',1540),(1199,'LAR ITEMS',5580),(1200,'PAPER ITEMS',1300),(1201,'SHOTS',103850),(1202,'SMOKE ITEMS',3750),(1259,'COLD FIRE /GUNS/BATTERYS',1800),(1260,'COMMETS',2850),(1261,'LAR ITEMS',1450),(1262,'SHOTS',8000),(1263,'COLD FIRE /GUNS/BATTERYS',1800),(1264,'COMMETS',2850),(1265,'LAR ITEMS',1450),(1266,'SHOTS',8000),(1267,'COLD FIRE /GUNS/BATTERYS',1800),(1268,'COMMETS',2850),(1269,'LAR ITEMS',1450),(1270,'SHOTS',8000),(1271,'ATOM BOMBS',350),(1272,'COLD FIRE /GUNS/BATTERYS',700),(1273,'LAR ITEMS',2600),(1274,'LAXMI ITEMS',350),(1275,'PAPER ITEMS',1350),(1276,'SHOTS',1700),(1277,'SMOKE ITEMS',300),(1278,'LAR ITEMS',7700),(1295,'COLD FIRE /GUNS/BATTERYS',200),(1296,'COMMETS',150),(1297,'FLOWER POTS',150),(1298,'LAR ITEMS',5400),(1299,'OTHER ITEMS',60),(1300,'PAPER ITEMS',1100),(1301,'SHOTS',12100),(1302,'SMOKE ITEMS',900);
INSERT INTO `userdata` (`_id`, `username`, `total`) VALUES (1,'admin',17000),(2,'ladmin',2300);
INSERT INTO `userwiseorderlistitems` (`_id`, `username`, `sales`, `salespercentage`) VALUES (1,'madmin',17000,100),(2,'ladmin',2300,12);
