INSERT INTO `clicked_cust_name` (`_id`, `name`) VALUES (1,'');
INSERT INTO `discountdetails` (`_id`, `date`, `time`, `billno`, `Discountcodeno`, `Discount_percent`, `Billamount_rupess`, `Discount_rupees`, `date1`, `original_amount`, `billcount`, `datetimee_new`, `paymentmethod`) VALUES (1,'2023 02 08','07:13:28 AM','20230208-1-000012','2','16.67','150.00','30','08 Feb 2023','180.00',NULL,'202302080713',NULL),(2,'2023 02 08','08:52:47 PM','20230208-1-000019','2','16.67','150.00','30','08 Feb 2023','180.00',NULL,'202302082052',NULL),(3,'2023 02 08','08:54:54 PM','20230208-1-0000110','2','16.67','150.00','30','08 Feb 2023','180.00',NULL,'202302082054',NULL),(4,'2023 02 23','01:15:34 PM','20230223-1-000012','2','16.67','300.00','60','23 Feb 2023','360.00',NULL,'202302231315',NULL),(5,'2023 02 23','01:20:39 PM','20230223-1-000013','1','16.67','150.00','30','23 Feb 2023','180.00',NULL,'202302231320',NULL),(6,'2023 03 12','02:54:31 PM','20230312-1-000013','3','16.67','450.00','90','12 Mar 2023','540.00',NULL,'202303121454',NULL),(7,'2023 03 15','08:56:33 PM','20230315-1-000014','1','16.67','150.00','30','15 Mar 2023','180.00',NULL,'202303152056',NULL),(8,'2023 03 16','05:29:06 PM','20230316-1-000011','1','16.67','150.00','30','16 Mar 2023','180.00',NULL,'202303161729',NULL),(9,'2023 03 19','09:10:54 PM','20230319-1-000013','1','16.67','150.00','30','19 Mar 2023','180.00',NULL,'202303192110',NULL),(10,'2023 03 19','09:11:23 PM','20230319-1-000014','1','16.67','150.00','30','19 Mar 2023','180.00',NULL,'202303192111',NULL),(11,'2023 03 20','02:59:34 PM','20230320-1-0000120','4','15.28','610.01','110','20 Mar 2023','720.01',NULL,'202303201459',NULL),(12,'2023 03 20','03:05:35 PM','20230320-1-0000121','2','16.67','300.00','60','20 Mar 2023','360.00',NULL,'202303201505',NULL),(13,'2023 03 24','09:10:22 PM','20230324-1-000013','3','16.67','450.00','90','24 Mar 2023','540.00',NULL,'202303242110',NULL),(14,'2023 03 24','09:11:09 PM','20230324-1-000014','2','16.67','300.00','60','24 Mar 2023','360.00',NULL,'202303242111',NULL),(15,'2023 03 25','09:42:02 PM','20230325-1-000011','2','16.67','300.00','60','25 Mar 2023','360.00',NULL,'202303252142',NULL),(16,'2023 03 25','09:45:49 PM','20230325-1-000012','1','16.67','150.00','30','25 Mar 2023','180.00',NULL,'202303252145',NULL),(17,'2023 03 30','02:02:49 PM','20230330-1-000011','1','16.67','150.00','30','30 Mar 2023','180.00',NULL,'202303301402',NULL),(18,'2023 04 05','12:58:59 PM','20230405-1-000011','2','16.67','300.00','60','05 Apr 2023','360.00',NULL,'202304051258',NULL),(19,'2023 04 05','01:00:55 PM','20230405-1-000013','1','8.33','330.00','30','05 Apr 2023','360.00',NULL,'202304051300',NULL),(20,'2023 04 05','08:31:37 PM','20230405-1-000017','1','16.67','150.00','30','05 Apr 2023','180.00',NULL,'202304052031',NULL),(21,'2023 04 29','10:17:11 AM','20230429-1-000011','2','13.19','395.02','60','29 Apr 2023','455.02',NULL,'202304291017',NULL),(22,'2023 04 29','11:19:35 AM','20230429-1-000012','1','16.67','150.00','30','29 Apr 2023','180.00',NULL,'202304291119',NULL),(23,'2023 04 29','12:28:14 PM','20230429-1-000013','1','16.67','150.00','30','29 Apr 2023','180.00',NULL,'202304291228',NULL),(24,'2023 04 29','01:18:17 PM','20230429-1-000014','1','16.67','150.00','30','29 Apr 2023','180.00',NULL,'202304291318',NULL),(25,'2023 04 29','01:18:51 PM','20230429-1-000015','1','16.67','150.00','30','29 Apr 2023','180.00',NULL,'202304291318',NULL),(26,'2023 04 29','01:19:25 PM','20230429-1-000016','1','16.67','150.00','30','29 Apr 2023','180.00',NULL,'202304291319',NULL),(27,'2023 04 29','05:06:17 PM','20230429-1-000017','2','11.11','320.00','40','29 Apr 2023','360.00',NULL,'202304291706',NULL),(28,'2023 04 29','05:28:45 PM','20230429-1-000018','1','16.67','150.00','30','29 Apr 2023','180.00',NULL,'202304291728',NULL),(29,'2023 04 29','09:03:57 PM','20230429-1-000019','1','16.67','150.00','30','29 Apr 2023','180.00',NULL,'202304292103',NULL),(30,'2023 05 02','08:15:48 PM','20230502-1-000011','1','16.67','150.00','30','02 May 2023','180.00',NULL,'202305022015',NULL),(31,'2023 05 02','08:16:31 PM','20230502-1-000012','2','16.67','300.00','60','02 May 2023','360.00',NULL,'202305022016',NULL),(32,'2023 05 02','08:17:12 PM','20230502-1-000013','1','16.67','150.00','30','02 May 2023','180.00',NULL,'202305022017',NULL),(33,'2023 05 02','08:17:51 PM','20230502-1-000014','1','16.67','150.00','30','02 May 2023','180.00',NULL,'202305022017',NULL),(34,'2023 05 02','08:18:26 PM','20230502-1-000015','1','16.67','150.00','30','02 May 2023','180.00',NULL,'202305022018',NULL),(35,'2023 05 05','12:44:27 PM','20230505-1-000011','1','16.67','150.00','30','05 May 2023','180.00',NULL,'202305051244',NULL),(36,'2023 05 06','10:03:24 PM','20230506-1-000011','3','16.67','450.00','90','06 May 2023','540.00',NULL,'202305062203',NULL),(37,'2023 05 07','02:04:24 PM','20230507-1-000011','3','16.67','450.00','90','07 May 2023','540.00',NULL,'202305071404',NULL),(38,'2023 09 11','08:52:08 PM','20230911-1-000011','1','16.67','150.00','30','11 Sep 2023','180.00',NULL,'202309112052',NULL),(39,'2023 09 11','09:02:28 PM','20230911-1-000013','2','12.24','430.01','60','11 Sep 2023','490.01',NULL,'202309112102',NULL),(40,'2023 09 11','09:45:48 PM','20230911-1-000014','20','16.67','3000.03','600','11 Sep 2023','3600.03',NULL,'202309112145',NULL),(41,'2023 09 11','09:47:06 PM','20230911-1-000015','8','16.67','1200.01','240','11 Sep 2023','1440.01',NULL,'202309112147',NULL),(42,'2023 09 12','06:17:13 AM','20230912-1-000011','10','16.67','1500.02','300','12 Sep 2023','1800.02',NULL,'202309120617',NULL),(43,'2023 09 15','02:54:04 PM','20230915-1-000011','1','16.67','150.00','30','15 Sep 2023','180.00',NULL,'202309151454',NULL),(44,'2023 09 15','04:42:04 PM','20230915-1-000012','01','60.00','20.00','30','15 Sep 2023','50.00',NULL,'202309151642',NULL),(45,'2023 09 15','08:06:43 PM','20230915-1-000013','1','16.67','150.00','30','15 Sep 2023','180.00',NULL,'202309152006',NULL),(46,'2023 09 15','08:07:38 PM','20230915-1-000014','1','16.67','150.00','30','15 Sep 2023','180.00',NULL,'202309152007',NULL),(47,'2023 09 15','08:08:23 PM','20230915-1-000015','1','16.67','150.00','30','15 Sep 2023','180.00',NULL,'202309152008',NULL),(48,'2023 09 17','08:13:41 PM','20230917-1-000015','2','16.67','300.00','60','17 Sep 2023','360.00',NULL,'202309172013',NULL),(49,'2023 09 18','08:18:19 PM','20230918-1-000011','600','11.77','44998.50','6000','18 Sep 2023','50998.50',NULL,'202309182018',NULL),(50,'2023 09 19','12:13:20 PM','20230919-1-000011','2','16.67','300.00','60','19 Sep 2023','360.00',NULL,'202309191213',NULL),(51,'2023 09 19','09:03:42 PM','20230919-1-000012','1','16.67','150.00','30','19 Sep 2023','180.00',NULL,'202309192103',NULL),(52,'2023 09 20','07:42:28 AM','20230920-1-000012','1','16.67','150.00','30','20 Sep 2023','180.00',NULL,'202309200742',NULL),(53,'2023 09 20','01:16:13 PM','20230920-1-000013','1','16.67','150.00','30','20 Sep 2023','180.00',NULL,'202309201316',NULL),(54,'2023 09 21','08:46:55 PM','20230921-1-000011','1','16.67','150.00','30','21 Sep 2023','180.00',NULL,'202309212046',NULL),(55,'2023 09 22','03:00:36 PM','20230922-1-000016','1','16.67','150.00','30','22 Sep 2023','180.00',NULL,'202309221500',NULL),(56,'2023 10 16','08:22:36 PM','20231016-1-000011','1','37.50','50.00','30','16 Oct 2023','80.00',NULL,'202310162022',NULL);
INSERT INTO `itemdata` (`_id`, `itemname`, `total`) VALUES (1,'Cappuccino',50),(2,'Fish mil',640),(3,'egg meal',840);
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,'46','Cappuccino',50,3,'2','None',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(2,'101','Fish mil',640,42,'4','None',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(3,'98','egg meal',840,55,'6','None',NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO `top_category` (`_id`, `category`, `value`) VALUES (1,'None',1530),(2,'None',780),(3,'None',100),(4,'None',100);
INSERT INTO `userdata` (`_id`, `username`, `total`) VALUES (1,'ladmin',1530);
INSERT INTO `userwiseorderlistitems` (`_id`, `username`, `sales`, `salespercentage`) VALUES (1,'ladmin',1530,100);
