INSERT INTO `all_sales` (`_id`, `itemname`, `quantity`, `price`, `total`, `type`, `parent`, `parentid`, `mod_assigned`, `tax`, `taxname`, `bill_no`, `time`, `date`, `user`, `table_id`, `billtype`, `paymentmethod`, `billamount_disapply`, `billamount_disnotapply`, `_idd`, `deleted_not`, `modifiedquantity`, `quantitycopy`, `modifiedtotal`, `date1`, `datetimee`, `disc_type`, `disc_value`, `newtotal`, `disc_thereornot`, `disc_indiv_total`, `new_modified_total`, `datetimee_new`, `hsn_code`, `taxname2`, `tax2`, `taxname3`, `tax3`, `taxname4`, `tax4`, `taxname5`, `tax5`, `category`, `counterperson_username`, `counterperson_name`, `credit`, `Phone_num`, `barcode_get`, `order_id`, `old_total`, `hsn_code2`, `hsn_code3`, `hsn_code4`, `hsn_code5`, `item_online`, `old_total_indiv`) VALUES (1,'Jeans','4.0','499.00','1996.00','Item',NULL,NULL,'no',NULL,NULL,'20240912-000011','04:50:31 PM','2024 09 12','admin','1','  General','  Cash','2696.00','2696.00','1',NULL,NULL,NULL,NULL,'12 Sep 2024','2024091216:50:31','%','0','1996.00','no','0.00',NULL,'202409121650','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Adults','admin','madmin',NULL,NULL,NULL,NULL,'1996.00','','','','',NULL,'499.00'),(2,'T shits','1.0','400.00','400.00','Item',NULL,NULL,'no',NULL,NULL,'20240912-000011','04:50:31 PM','2024 09 12','admin','1','  General','  Cash','2696.00','2696.00','2',NULL,NULL,NULL,NULL,'12 Sep 2024','2024091216:50:31','%','0','400.00','no','0.00',NULL,'202409121650','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Adults','admin','madmin',NULL,NULL,NULL,NULL,'400.00','','','','',NULL,'400.00'),(3,'Leggings','1.0','300.00','300.00','Item',NULL,NULL,'no',NULL,NULL,'20240912-000011','04:50:31 PM','2024 09 12','admin','1','  General','  Cash','2696.00','2696.00','3',NULL,NULL,NULL,NULL,'12 Sep 2024','2024091216:50:31','%','0','300.00','no','0.00',NULL,'202409121650','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Adults','admin','madmin',NULL,NULL,NULL,NULL,'300.00','','','','',NULL,'300.00'),(4,'Jeans','1.0','499.00','499.00','Item',NULL,NULL,'no',NULL,NULL,'20240912-000012','04:51:37 PM','2024 09 12','admin','1','  General','  Cash','2099.00','2099.00','4',NULL,NULL,NULL,NULL,'12 Sep 2024','2024091216:51:37','%','0','499.00','no','0.00',NULL,'202409121651','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Adults','admin','madmin',NULL,NULL,NULL,NULL,'499.00','','','','',NULL,'499.00'),(5,'T shits','1.0','400.00','400.00','Item',NULL,NULL,'no',NULL,NULL,'20240912-000012','04:51:37 PM','2024 09 12','admin','1','  General','  Cash','2099.00','2099.00','5',NULL,NULL,NULL,NULL,'12 Sep 2024','2024091216:51:37','%','0','400.00','no','0.00',NULL,'202409121651','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Adults','admin','madmin',NULL,NULL,NULL,NULL,'400.00','','','','',NULL,'400.00'),(6,'Shirts','1.0','900.00','900.00','Item',NULL,NULL,'no',NULL,NULL,'20240912-000012','04:51:37 PM','2024 09 12','admin','1','  General','  Cash','2099.00','2099.00','6',NULL,NULL,NULL,NULL,'12 Sep 2024','2024091216:51:37','%','0','900.00','no','0.00',NULL,'202409121651','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Adults','admin','madmin',NULL,NULL,NULL,NULL,'900.00','','','','',NULL,'900.00'),(7,'Leggings','1.0','300.00','300.00','Item',NULL,NULL,'no',NULL,NULL,'20240912-000012','04:51:37 PM','2024 09 12','admin','1','  General','  Cash','2099.00','2099.00','7',NULL,NULL,NULL,NULL,'12 Sep 2024','2024091216:51:37','%','0','300.00','no','0.00',NULL,'202409121651','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Adults','admin','madmin',NULL,NULL,NULL,NULL,'300.00','','','','',NULL,'300.00'),(8,'Jeans','2.0','499.00','998.00','Item',NULL,NULL,'no',NULL,NULL,'20240912-000013','04:52:56 PM','2024 09 12','admin','1','  General','  Cash','3598.00','3598.00','8',NULL,NULL,NULL,NULL,'12 Sep 2024','2024091216:52:56','%','0','998.00','no','0.00',NULL,'202409121652','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Adults','admin','madmin',NULL,NULL,NULL,NULL,'998.00','','','','',NULL,'499.00'),(9,'T shits','2.0','400.00','800.00','Item',NULL,NULL,'no',NULL,NULL,'20240912-000013','04:52:56 PM','2024 09 12','admin','1','  General','  Cash','3598.00','3598.00','9',NULL,NULL,NULL,NULL,'12 Sep 2024','2024091216:52:56','%','0','800.00','no','0.00',NULL,'202409121652','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Adults','admin','madmin',NULL,NULL,NULL,NULL,'800.00','','','','',NULL,'400.00'),(10,'Shirts','2.0','900.00','1800.00','Item',NULL,NULL,'no',NULL,NULL,'20240912-000013','04:52:56 PM','2024 09 12','admin','1','  General','  Cash','3598.00','3598.00','10',NULL,NULL,NULL,NULL,'12 Sep 2024','2024091216:52:56','%','0','1800.00','no','0.00',NULL,'202409121652','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Adults','admin','madmin',NULL,NULL,NULL,NULL,'1800.00','','','','',NULL,'900.00'),(11,'Jeans','3.0','499.00','1497.00','Item',NULL,NULL,'no',NULL,NULL,'20240912-000014','04:54:27 PM','2024 09 12','admin','1','  General','  Cash','2697.00','2697.00','12',NULL,NULL,NULL,NULL,'12 Sep 2024','2024091216:54:27','%','0','1497.00','no','0.00',NULL,'202409121654','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Adults','admin','madmin',NULL,NULL,NULL,NULL,'1497.00','','','','',NULL,'499.00'),(12,'T shits','3.0','400.00','1200.00','Item',NULL,NULL,'no',NULL,NULL,'20240912-000014','04:54:27 PM','2024 09 12','admin','1','  General','  Cash','2697.00','2697.00','13',NULL,NULL,NULL,NULL,'12 Sep 2024','2024091216:54:27','%','0','1200.00','no','0.00',NULL,'202409121654','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Adults','admin','madmin',NULL,NULL,NULL,NULL,'1200.00','','','','',NULL,'400.00'),(13,'Shirts','2.0','900.00','1800.00','Item',NULL,NULL,'no',NULL,NULL,'20240912-000015','04:57:06 PM','2024 09 12','admin','1','  General','  Cash','4647.00','4647.00','14',NULL,NULL,NULL,NULL,'12 Sep 2024','2024091216:57:06','₹','50','1700.00','yes','100.00',NULL,'202409121657','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Adults','admin','madmin',NULL,NULL,NULL,NULL,'800.00','','','','',NULL,'900.00'),(14,'Leggings','1.0','300.00','300.00','Item',NULL,NULL,'no',NULL,NULL,'20240912-000015','04:57:06 PM','2024 09 12','admin','1','  General','  Cash','4647.00','4647.00','15',NULL,NULL,NULL,NULL,'12 Sep 2024','2024091216:57:06','₹','50','250.00','yes','50.00',NULL,'202409121657','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Adults','admin','madmin',NULL,NULL,NULL,NULL,'400.00','','','','',NULL,'300.00'),(15,'T shits','4.0','400.00','1600.00','Item',NULL,NULL,'no',NULL,NULL,'20240912-000015','04:57:06 PM','2024 09 12','admin','1','  General','  Cash','4647.00','4647.00','16',NULL,NULL,NULL,NULL,'12 Sep 2024','2024091216:57:06','₹','100','1200.00','yes','400.00',NULL,'202409121657','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Adults','admin','madmin',NULL,NULL,NULL,NULL,'1600.00','','','','',NULL,'400.00'),(16,'Jeans','3.0','499.00','1497.00','Item',NULL,NULL,'no',NULL,NULL,'20240912-000015','04:57:06 PM','2024 09 12','admin','1','  General','  Cash','4647.00','4647.00','17',NULL,NULL,NULL,NULL,'12 Sep 2024','2024091216:57:06','%','0','1497.00','no','0.00',NULL,'202409121657','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Adults','admin','madmin',NULL,NULL,NULL,NULL,'1200.00','','','','',NULL,'499.00'),(17,'T shits','1.0','400.00','400.00','Item',NULL,NULL,'no',NULL,NULL,'20240917-000011','09:02:41 PM','2024 09 17','ladmin','1','  General','  Cash','2099.00','2099.00','1',NULL,NULL,NULL,NULL,'17 Sep 2024','2024091721:02:41','%','0','400.00','no','0.00',NULL,'202409172102','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Adults','admin','madmin',NULL,NULL,NULL,NULL,'400.00','','','','',NULL,'400.00'),(18,'Jeans','1.0','499.00','499.00','Item',NULL,NULL,'no',NULL,NULL,'20240917-000011','09:02:41 PM','2024 09 17','ladmin','1','  General','  Cash','2099.00','2099.00','2',NULL,NULL,NULL,NULL,'17 Sep 2024','2024091721:02:41','%','0','499.00','no','0.00',NULL,'202409172102','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Adults','admin','madmin',NULL,NULL,NULL,NULL,'499.00','','','','',NULL,'499.00'),(19,'Shirts','1.0','900.00','900.00','Item',NULL,NULL,'no',NULL,NULL,'20240917-000011','09:02:41 PM','2024 09 17','ladmin','1','  General','  Cash','2099.00','2099.00','3',NULL,NULL,NULL,NULL,'17 Sep 2024','2024091721:02:41','%','0','900.00','no','0.00',NULL,'202409172102','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Adults','admin','madmin',NULL,NULL,NULL,NULL,'900.00','','','','',NULL,'900.00'),(20,'Leggings','1.0','300.00','300.00','Item',NULL,NULL,'no',NULL,NULL,'20240917-000011','09:02:41 PM','2024 09 17','ladmin','1','  General','  Cash','2099.00','2099.00','4',NULL,NULL,NULL,NULL,'17 Sep 2024','2024091721:02:41','%','0','300.00','no','0.00',NULL,'202409172102','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Adults','admin','madmin',NULL,NULL,NULL,NULL,'300.00','','','','',NULL,'300.00'),(21,'Jeans','1.0','499.00','499.00','Item',NULL,NULL,'no',NULL,NULL,'20240917-000012','09:03:35 PM','2024 09 17','admin','1','  General','  Cash','499.00','499.00','5',NULL,NULL,NULL,NULL,'17 Sep 2024','2024091721:03:35','%','0','499.00','no','0.00',NULL,'202409172103','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Adults','admin','madmin',NULL,NULL,NULL,NULL,'499.00','','','','',NULL,'499.00'),(22,'T shits','1.0','400.00','400.00','Item',NULL,NULL,'no',NULL,NULL,'20240917-000013','09:15:00 PM','2024 09 17','admin','1','  General','  Cash','1398.00','1398.00','8',NULL,NULL,NULL,NULL,'17 Sep 2024','2024091721:15:00','%','0','400.00','no','0.00',NULL,'202409172115','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Adults','admin','madmin',NULL,NULL,NULL,NULL,'400.00','','','','',NULL,'400.00'),(23,'Jeans','2.0','499.00','998.00','Item',NULL,NULL,'no',NULL,NULL,'20240917-000013','09:15:00 PM','2024 09 17','admin','1','  General','  Cash','1398.00','1398.00','9',NULL,NULL,NULL,NULL,'17 Sep 2024','2024091721:15:00','%','0','998.00','no','0.00',NULL,'202409172115','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Adults','admin','madmin',NULL,NULL,NULL,NULL,'998.00','','','','',NULL,'499.00'),(24,'combo formal','2.0','649.00','1298.00','Item',NULL,NULL,'no',NULL,NULL,'20240918-000011','11:46:43 AM','2024 09 18','admin','1','  General','  Cash','1797.00','1797.00','17',NULL,NULL,NULL,NULL,'18 Sep 2024','2024091811:46:43','%','0','1298.00','no','0.00',NULL,'202409181146','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'',NULL,'1298.00','','','','',NULL,'649.00'),(25,'Jeans','1.0','499.00','499.00','Item',NULL,NULL,'no',NULL,NULL,'20240918-000011','11:46:43 AM','2024 09 18','admin','1','  General','  Cash','1797.00','1797.00','18',NULL,NULL,NULL,NULL,'18 Sep 2024','2024091811:46:43','%','0','499.00','no','0.00',NULL,'202409181146','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Adults','admin','madmin',NULL,NULL,NULL,NULL,'499.00','','','','',NULL,'499.00'),(26,'Jeans','1.0','499.00','499.00','Item',NULL,NULL,'no',NULL,NULL,'20240918-000012','11:50:41 AM','2024 09 18','admin','1','  General','  Cash','899.00','899.00','19',NULL,NULL,NULL,NULL,'18 Sep 2024','2024091811:50:41','%','0','499.00','no','0.00',NULL,'202409181150','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Adults','admin','madmin',NULL,NULL,NULL,NULL,'499.00','','','','',NULL,'499.00'),(27,'T shits','1.0','400.00','400.00','Item',NULL,NULL,'no',NULL,NULL,'20240918-000012','11:50:41 AM','2024 09 18','admin','1','  General','  Cash','899.00','899.00','20',NULL,NULL,NULL,NULL,'18 Sep 2024','2024091811:50:41','%','0','400.00','no','0.00',NULL,'202409181150','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Adults','admin','madmin',NULL,NULL,NULL,NULL,'400.00','','','','',NULL,'400.00'),(28,'Jeans','1.0','499.00','499.00','Item',NULL,NULL,'no',NULL,NULL,'20240918-000013','12:00:23 PM','2024 09 18','admin','1','  General','  Cash','499.00','499.00','21',NULL,NULL,NULL,NULL,'18 Sep 2024','2024091812:00:23','%','0','499.00','no','0.00',NULL,'202409181200','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Adults','admin','madmin',NULL,NULL,NULL,NULL,'499.00','','','','',NULL,'499.00'),(29,'Jeans','2.0','499.00','998.00','Item',NULL,NULL,'no',NULL,NULL,'20240918-000014','12:00:57 PM','2024 09 18','admin','1','  General','  Cash','1548.00','1548.00','22',NULL,NULL,NULL,NULL,'18 Sep 2024','2024091812:00:57','%','0','998.00','no','0.00',NULL,'202409181200','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Adults','admin','madmin',NULL,NULL,NULL,NULL,'998.00','','','','',NULL,'499.00'),(30,'jockets ','1.0','550.00','550.00','Item',NULL,NULL,'no',NULL,NULL,'20240918-000014','12:00:57 PM','2024 09 18','admin','1','  General','  Cash','1548.00','1548.00','23',NULL,NULL,NULL,NULL,'18 Sep 2024','2024091812:00:57','%','0','550.00','no','0.00',NULL,'202409181200','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'',NULL,'550.00','','','','',NULL,'550.00'),(31,'combo formal','1.0','649.00','649.00','Item',NULL,NULL,'no',NULL,NULL,'20240918-000015','12:01:16 PM','2024 09 18','admin','1','  General','  Cash','998.00','998.00','24',NULL,NULL,NULL,NULL,'18 Sep 2024','2024091812:01:16','%','0','649.00','no','0.00',NULL,'202409181201','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'',NULL,'649.00','','','','',NULL,'649.00'),(32,'FORMAL SHIRT','1.0','349.00','349.00','Item',NULL,NULL,'no',NULL,NULL,'20240918-000015','12:01:16 PM','2024 09 18','admin','1','  General','  Cash','998.00','998.00','25',NULL,NULL,NULL,NULL,'18 Sep 2024','2024091812:01:16','%','0','349.00','no','0.00',NULL,'202409181201','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'',NULL,'349.00','','','','',NULL,'349.00'),(33,'combo formal','1.0','649.00','649.00','Item',NULL,NULL,'no',NULL,NULL,'20240918-000016','12:01:43 PM','2024 09 18','admin','1','  General','  Cash','998.00','998.00','26',NULL,NULL,NULL,NULL,'18 Sep 2024','2024091812:01:43','%','0','649.00','no','0.00',NULL,'202409181201','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'',NULL,'649.00','','','','',NULL,'649.00'),(34,'FORMAL SHIRT','1.0','349.00','349.00','Item',NULL,NULL,'no',NULL,NULL,'20240918-000016','12:01:43 PM','2024 09 18','admin','1','  General','  Cash','998.00','998.00','27',NULL,NULL,NULL,NULL,'18 Sep 2024','2024091812:01:43','%','0','349.00','no','0.00',NULL,'202409181201','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'',NULL,'349.00','','','','',NULL,'349.00'),(35,'jockets ','1.0','550.00','550.00','Item',NULL,NULL,'no',NULL,NULL,'20240918-000017','12:03:53 PM','2024 09 18','admin','1','  General','  Cash','1749.00','1749.00','28',NULL,NULL,NULL,NULL,'18 Sep 2024','2024091812:03:53','%','0','550.00','no','0.00',NULL,'202409181203','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'',NULL,'550.00','','','','',NULL,'550.00'),(36,'jockets brand','1.0','1199.00','1199.00','Item',NULL,NULL,'no',NULL,NULL,'20240918-000017','12:03:53 PM','2024 09 18','admin','1','  General','  Cash','1749.00','1749.00','29',NULL,NULL,NULL,NULL,'18 Sep 2024','2024091812:03:53','%','0','1199.00','no','0.00',NULL,'202409181203','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'',NULL,'1199.00','','','','',NULL,'1199.00'),(37,'crocs bayband','1.0','1499.00','1499.00','Item',NULL,NULL,'no',NULL,NULL,'20240918-000018','12:07:09 PM','2024 09 18','admin','1','  General','  Cash','2148.00','2148.00','30',NULL,NULL,NULL,NULL,'18 Sep 2024','2024091812:07:09','%','0','1499.00','no','0.00',NULL,'202409181207','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'',NULL,'1499.00','','','','',NULL,'1499.00'),(38,'combo formal','1.0','649.00','649.00','Item',NULL,NULL,'no',NULL,NULL,'20240918-000018','12:07:09 PM','2024 09 18','admin','1','  General','  Cash','2148.00','2148.00','31',NULL,NULL,NULL,NULL,'18 Sep 2024','2024091812:07:09','%','0','649.00','no','0.00',NULL,'202409181207','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'',NULL,'649.00','','','','',NULL,'649.00'),(39,'jockets ','1.0','550.00','550.00','Item',NULL,NULL,'no',NULL,NULL,'20240918-000019','12:07:29 PM','2024 09 18','admin','1','  General','  Cash','550.00','550.00','32',NULL,NULL,NULL,NULL,'18 Sep 2024','2024091812:07:29','%','0','550.00','no','0.00',NULL,'202409181207','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'',NULL,'550.00','','','','',NULL,'550.00'),(40,'FORMAL SHIRT','1.0','349.00','349.00','Item',NULL,NULL,'no',NULL,NULL,'20240918-0000110','12:07:54 PM','2024 09 18','admin','1','  General','  Cash','349.00','349.00','33',NULL,NULL,NULL,NULL,'18 Sep 2024','2024091812:07:54','%','0','349.00','no','0.00',NULL,'202409181207','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'',NULL,'349.00','','','','',NULL,'349.00'),(41,'T shits','1.0','400.00','400.00','Item',NULL,NULL,'no',NULL,NULL,'20240918-0000111','12:37:01 PM','2024 09 18','admin','1','  General','  Upiqr','400.00','400.00','34',NULL,NULL,NULL,NULL,'18 Sep 2024','2024091812:37:01','%','0','400.00','no','0.00',NULL,'202409181237','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Adults','admin','madmin','0',NULL,NULL,NULL,'400.00','','','','',NULL,'400.00'),(42,'Jeans','1.0','499.00','499.00','Item',NULL,NULL,'no',NULL,NULL,'20240918-0000112','12:51:59 PM','2024 09 18','admin','1','  General','  Cash','499.00','499.00','35',NULL,NULL,NULL,NULL,'18 Sep 2024','2024091812:51:59','%','0','499.00','no','0.00',NULL,'202409181251','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Adults','admin','madmin',NULL,NULL,NULL,NULL,'499.00','','','','',NULL,'499.00'),(43,'Jeans','1.0','499.00','499.00','Item',NULL,NULL,'no',NULL,NULL,'20240918-0000113','12:54:06 PM','2024 09 18','admin','1','  General','  Cash','449.00','449.00','36',NULL,NULL,NULL,NULL,'18 Sep 2024','2024091812:54:06','₹','50','449.00','yes','50.00',NULL,'202409181254','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Adults','admin','madmin',NULL,NULL,NULL,NULL,'499.00','','','','',NULL,'499.00'),(44,'Jeans','1.0','499.00','499.00','Item',NULL,NULL,'no',NULL,NULL,'20240918-0000114','12:56:41 PM','2024 09 18','admin','1','  General','  Cash','499.00','499.00','37',NULL,NULL,NULL,NULL,'18 Sep 2024','2024091812:56:41','%','0','499.00','no','0.00',NULL,'202409181256','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Adults','admin','madmin',NULL,NULL,NULL,NULL,'499.00','','','','',NULL,'499.00'),(45,'Jeans','1.0','499.00','499.00','Item',NULL,NULL,'no',NULL,NULL,'20240918-0000115','01:02:13 PM','2024 09 18','admin','1','  General','  Cash','499.00','499.00','38',NULL,NULL,NULL,NULL,'18 Sep 2024','2024091813:02:13','%','0','499.00','no','0.00',NULL,'202409181302','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Adults','admin','madmin',NULL,NULL,NULL,NULL,'499.00','','','','',NULL,'499.00'),(46,'night pant techno sports ','1.0','449.00','449.00','Item',NULL,NULL,'no',NULL,NULL,'20240918-0000116','02:15:59 PM','2024 09 18','admin','1','  General','  Upiqr','449.00','449.00','44',NULL,NULL,NULL,NULL,'18 Sep 2024','2024091814:15:59','%','0','449.00','no','0.00',NULL,'202409181415','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin','0',NULL,'',NULL,'449.00','','','','',NULL,'449.00'),(47,'Jeans','2.0','499.00','998.00','Item',NULL,NULL,'no',NULL,NULL,'20240918-0000117','04:10:40 PM','2024 09 18','admin','1','  General','  Upiqr','998.00','998.00','47',NULL,NULL,NULL,NULL,'18 Sep 2024','2024091816:10:40','%','0','998.00','no','0.00',NULL,'202409181610','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Adults','admin','madmin','0',NULL,NULL,NULL,'998.00','','','','',NULL,'499.00'),(48,'adda','1.0','1.00','1.00','Item',NULL,NULL,'no',NULL,NULL,'20240919-000011','11:17:36 AM','2024 09 19','admin','1','  General','  Cash','1.00','1.00','69',NULL,NULL,NULL,NULL,'19 Sep 2024','2024091911:17:36','%','0','1.00','no','0.00',NULL,'202409191117','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'',NULL,'1.00','','','','',NULL,'1.00'),(49,'adda','1.0','1.00','1.00','Item',NULL,NULL,'no',NULL,NULL,'20240919-000012','11:36:52 AM','2024 09 19','admin','1','  General','  Cash','1.00','1.00','71',NULL,NULL,NULL,NULL,'19 Sep 2024','2024091911:36:52','%','0','1.00','no','0.00',NULL,'202409191136','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'',NULL,'1.00','','','','',NULL,'1.00'),(50,'adda','1.0','1.00','1.00','Item',NULL,NULL,'no',NULL,NULL,'20240919-000013','11:37:34 AM','2024 09 19','admin','1','  General','  Cash','1.00','1.00','72',NULL,NULL,NULL,NULL,'19 Sep 2024','2024091911:37:34','%','0','1.00','no','0.00',NULL,'202409191137','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'',NULL,'1.00','','','','',NULL,'1.00'),(51,'cotton shirts','2.0','399.00','798.00','Item',NULL,NULL,'no',NULL,NULL,'20240919-000014','12:02:11 PM','2024 09 19','admin','1','  General','  Cash','798.00','798.00','84',NULL,NULL,NULL,NULL,'19 Sep 2024','2024091912:02:11','%','0','798.00','no','0.00',NULL,'202409191202','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'',NULL,'798.00','','','','',NULL,'399.00'),(52,'arun adda ','1.0','2.00','2.00','Item',NULL,NULL,'no',NULL,NULL,'20240919-000015','12:08:48 PM','2024 09 19','admin','1','  General','  Cash','1.00','1.00','87',NULL,NULL,NULL,NULL,'19 Sep 2024','2024091912:08:48','₹','1','1.00','yes','1.00',NULL,'202409191208','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'',NULL,'2.00','','','','',NULL,'2.00'),(53,'charlly','3.0','349.00','1047.00','Item',NULL,NULL,'no',NULL,NULL,'20240919-000016','01:28:03 PM','2024 09 19','admin','1','  General','  Cash','2846.00','2846.00','92',NULL,NULL,NULL,NULL,'19 Sep 2024','2024091913:28:03','%','0','1047.00','no','0.00',NULL,'202409191328','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'',NULL,'1047.00','','','','',NULL,'349.00'),(54,'3formal pants','1.0','999.00','999.00','Item',NULL,NULL,'no',NULL,NULL,'20240919-000016','01:28:03 PM','2024 09 19','admin','1','  General','  Cash','2846.00','2846.00','93',NULL,NULL,NULL,NULL,'19 Sep 2024','2024091913:28:03','%','0','999.00','no','0.00',NULL,'202409191328','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'',NULL,'999.00','','','','',NULL,'999.00'),(55,'shirts','4.0','200.00','800.00','Item',NULL,NULL,'no',NULL,NULL,'20240919-000016','01:28:03 PM','2024 09 19','admin','1','  General','  Cash','2846.00','2846.00','94',NULL,NULL,NULL,NULL,'19 Sep 2024','2024091913:28:03','%','0','800.00','no','0.00',NULL,'202409191328','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'',NULL,'800.00','','','','',NULL,'200.00'),(56,'Jeans','1.0','499.00','499.00','Item',NULL,NULL,'no',NULL,NULL,'20240919-000017','01:38:07 PM','2024 09 19','admin','1','  General','  Cash','499.00','499.00','95',NULL,NULL,NULL,NULL,'19 Sep 2024','2024091913:38:07','%','0','499.00','no','0.00',NULL,'202409191338','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Adults','admin','madmin',NULL,NULL,NULL,NULL,'499.00','','','','',NULL,'499.00'),(57,'jeans combo','1.0','950.00','950.00','Item',NULL,NULL,'no',NULL,NULL,'20240919-000018','05:10:28 PM','2024 09 19','admin','1','  General','  Cash','950.00','950.00','98',NULL,NULL,NULL,NULL,'19 Sep 2024','2024091917:10:28','%','0','950.00','no','0.00',NULL,'202409191710','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'',NULL,'950.00','','','','',NULL,'950.00'),(58,'3formal pants','2.0','999.00','1998.00','Item',NULL,NULL,'no',NULL,NULL,'20240919-000019','06:17:17 PM','2024 09 19','admin','1','  General','  Cash','2348.00','2348.00','99',NULL,NULL,NULL,NULL,'19 Sep 2024','2024091918:17:17','%','0','1998.00','no','0.00',NULL,'202409191817','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'',NULL,'1998.00','','','','',NULL,'999.00'),(59,'belt','1.0','350.00','350.00','Item',NULL,NULL,'no',NULL,NULL,'20240919-000019','06:17:17 PM','2024 09 19','admin','1','  General','  Cash','2348.00','2348.00','100',NULL,NULL,NULL,NULL,'19 Sep 2024','2024091918:17:17','%','0','350.00','no','0.00',NULL,'202409191817','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'hi',NULL,'350.00','','','','',NULL,'350.00'),(60,'jeans combo','1.0','950.00','950.00','Item',NULL,NULL,'no',NULL,NULL,'20240919-0000110','06:47:19 PM','2024 09 19','admin','1','  General','  Cash','2149.00','2149.00','101',NULL,NULL,NULL,NULL,'19 Sep 2024','2024091918:47:19','%','0','950.00','no','0.00',NULL,'202409191847','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'',NULL,'950.00','','','','',NULL,'950.00'),(61,'formal combo','1.0','850.00','850.00','Item',NULL,NULL,'no',NULL,NULL,'20240919-0000110','06:47:19 PM','2024 09 19','admin','1','  General','  Cash','2149.00','2149.00','102',NULL,NULL,NULL,NULL,'19 Sep 2024','2024091918:47:19','%','0','850.00','no','0.00',NULL,'202409191847','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'34',NULL,'850.00','','','','',NULL,'850.00'),(62,'charlly','1.0','349.00','349.00','Item',NULL,NULL,'no',NULL,NULL,'20240919-0000110','06:47:19 PM','2024 09 19','admin','1','  General','  Cash','2149.00','2149.00','103',NULL,NULL,NULL,NULL,'19 Sep 2024','2024091918:47:19','%','0','349.00','no','0.00',NULL,'202409191847','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'',NULL,'349.00','','','','',NULL,'349.00'),(63,'FORMAL SHIRT','1.0','349.00','349.00','Item',NULL,NULL,'no',NULL,NULL,'20240919-0000111','06:50:27 PM','2024 09 19','admin','1','  General','  Cash','349.00','349.00','104',NULL,NULL,NULL,NULL,'19 Sep 2024','2024091918:50:27','%','0','349.00','no','0.00',NULL,'202409191850','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'',NULL,'349.00','','','','',NULL,'349.00'),(64,'crocs','1.0','1299.00','1299.00','Item',NULL,NULL,'no',NULL,NULL,'20240919-0000112','07:30:04 PM','2024 09 19','admin','1','  General','  Cash','1099.00','1099.00','110',NULL,NULL,NULL,NULL,'19 Sep 2024','2024091919:30:04','₹','200','1099.00','yes','200.00',NULL,'202409191930','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'',NULL,'1299.00','','','','',NULL,'1299.00'),(65,'jeans combo','1.0','950.00','950.00','Item',NULL,NULL,'no',NULL,NULL,'20240919-0000113','08:33:10 PM','2024 09 19','admin','1','  General','  Cash','900.00','900.00','112',NULL,NULL,NULL,NULL,'19 Sep 2024','2024091920:33:10','₹','50','900.00','yes','50.00',NULL,'202409192033','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'',NULL,'950.00','','','','',NULL,'950.00'),(66,'brand hoodies','1.0','1199.00','1199.00','Item',NULL,NULL,'no',NULL,NULL,'20240920-000011','10:15:19 AM','2024 09 20','admin','1','  General','  Cash','1598.00','1598.00','113',NULL,NULL,NULL,NULL,'20 Sep 2024','2024092010:15:19','%','0','1199.00','no','0.00',NULL,'202409201015','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'',NULL,'1199.00','','','','',NULL,'1199.00'),(67,'cotton shirts','1.0','399.00','399.00','Item',NULL,NULL,'no',NULL,NULL,'20240920-000011','10:15:19 AM','2024 09 20','admin','1','  General','  Cash','1598.00','1598.00','114',NULL,NULL,NULL,NULL,'20 Sep 2024','2024092010:15:19','%','0','399.00','no','0.00',NULL,'202409201015','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'',NULL,'399.00','','','','',NULL,'399.00'),(68,'adda','1.0','1.00','1.00','Item',NULL,NULL,'no',NULL,NULL,'20240920-000012','10:49:33 AM','2024 09 20','admin','1','  General','  Cash','1.00','1.00','115',NULL,NULL,NULL,NULL,'20 Sep 2024','2024092010:49:33','%','0','1.00','no','0.00',NULL,'202409201049','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'',NULL,'1.00','','','','',NULL,'1.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 (1,'20240912-000011','2696.00','admin','2024 09 12','  Cash','  General','2696.00','0.00','0.00','0.0','1','202409121650',NULL,NULL,NULL,NULL,NULL,NULL),(2,'20240912-000012','2099.00','admin','2024 09 12','  Cash','  General','2099.00','0.00','0.00','0.0','2','202409121651',NULL,NULL,NULL,NULL,NULL,NULL),(3,'20240912-000013','3598.00','admin','2024 09 12','  Cash','  General','3598.00','0.00','0.00','0.0','3','202409121652',NULL,NULL,NULL,NULL,NULL,NULL),(4,'20240912-000014','2697.00','admin','2024 09 12','  Cash','  General','2697.00','0.00','0.00','0.0','4','202409121654',NULL,NULL,NULL,NULL,NULL,NULL),(5,'20240912-000015','4647.00','admin','2024 09 12','  Cash','  General','4647.00','0.00','0.00','0.0','5','202409121657',NULL,NULL,NULL,NULL,NULL,NULL),(6,'20240917-000011','2099.00','ladmin','2024 09 17','  Cash','  General','2099.00','0.00','0.00','0.0','6','202409172102',NULL,NULL,NULL,NULL,NULL,NULL),(7,'20240917-000012','499.00','admin','2024 09 17','  Cash','  General','499.00','0.00','0.00','0.0','7','202409172103',NULL,NULL,NULL,NULL,NULL,NULL),(8,'20240917-000013','1398.00','admin','2024 09 17','  Cash','  General','1398.00','0.00','0.00','0.0','8','202409172115',NULL,NULL,NULL,NULL,NULL,NULL),(9,'20240918-000011','1797.00','admin','2024 09 18','  Cash','  General','1797.00','0.00','0.00','0.0','9','202409181146',NULL,NULL,NULL,NULL,NULL,NULL),(10,'20240918-000012','899.00','admin','2024 09 18','  Cash','  General','899.00','0.00','0.00','0.0','10','202409181150',NULL,NULL,NULL,NULL,NULL,NULL),(11,'20240918-000013','499.00','admin','2024 09 18','  Cash','  General','499.00','0.00','0.00','0.0','11','202409181200',NULL,NULL,NULL,NULL,NULL,NULL),(12,'20240918-000014','1548.00','admin','2024 09 18','  Cash','  General','1548.00','0.00','0.00','0.0','12','202409181200',NULL,NULL,NULL,NULL,NULL,NULL),(13,'20240918-000015','998.00','admin','2024 09 18','  Cash','  General','998.00','0.00','0.00','0.0','13','202409181201',NULL,NULL,NULL,NULL,NULL,NULL),(14,'20240918-000016','998.00','admin','2024 09 18','  Cash','  General','998.00','0.00','0.00','0.0','14','202409181201',NULL,NULL,NULL,NULL,NULL,NULL),(15,'20240918-000017','1749.00','admin','2024 09 18','  Cash','  General','1749.00','0.00','0.00','0.0','15','202409181203',NULL,NULL,NULL,NULL,NULL,NULL),(16,'20240918-000018','2148.00','admin','2024 09 18','  Cash','  General','2148.00','0.00','0.00','0.0','16','202409181207',NULL,NULL,NULL,NULL,NULL,NULL),(17,'20240918-000019','550.00','admin','2024 09 18','  Cash','  General','550.00','0.00','0.00','0.0','17','202409181207',NULL,NULL,NULL,NULL,NULL,NULL),(18,'20240918-0000110','349.00','admin','2024 09 18','  Cash','  General','349.00','0.00','0.00','0.0','18','202409181207',NULL,NULL,NULL,NULL,NULL,NULL),(19,'20240918-0000111','400.00','admin','2024 09 18','  Upiqr','  General','400.00','0.00','0.00','0.0','19','202409181237',NULL,NULL,NULL,NULL,NULL,NULL),(20,'20240918-0000112','499.00','admin','2024 09 18','  Cash','  General','499.00','0.00','0.00','0.0','20','202409181251',NULL,NULL,NULL,NULL,NULL,NULL),(21,'20240918-0000113','449.00','admin','2024 09 18','  Cash','  General','449.00','0.00','0.00','0.0','21','202409181254',NULL,NULL,NULL,NULL,NULL,NULL),(22,'20240918-0000114','499.00','admin','2024 09 18','  Cash','  General','499.00','0.00','0.00','0.0','22','202409181256',NULL,NULL,NULL,NULL,NULL,NULL),(23,'20240918-0000115','499.00','admin','2024 09 18','  Cash','  General','499.00','0.00','0.00','0.0','23','202409181302',NULL,NULL,NULL,NULL,NULL,NULL),(24,'20240918-0000116','449.00','admin','2024 09 18','  Upiqr','  General','449.00','0.00','0.00','0.0','24','202409181415',NULL,NULL,NULL,NULL,NULL,NULL),(25,'20240918-0000117','998.00','admin','2024 09 18','  Upiqr','  General','998.00','0.00','0.00','0.0','25','202409181610',NULL,NULL,NULL,NULL,NULL,NULL),(26,'20240919-000011','1.00','admin','2024 09 19','  Cash','  General','1.00','0.00','0.00','0.0','26','202409191117',NULL,NULL,NULL,NULL,NULL,NULL),(27,'20240919-000012','1.00','admin','2024 09 19','  Cash','  General','1.00','0.00','0.00','0.0','27','202409191136',NULL,NULL,NULL,NULL,NULL,NULL),(28,'20240919-000013','1.00','admin','2024 09 19','  Cash','  General','1.00','0.00','0.00','0.0','28','202409191137',NULL,NULL,NULL,NULL,NULL,NULL),(29,'20240919-000014','798.00','admin','2024 09 19','  Cash','  General','798.00','0.00','0.00','0.0','29','202409191202',NULL,NULL,NULL,NULL,NULL,NULL),(30,'20240919-000015','1.00','admin','2024 09 19','  Cash','  General','1.00','0.00','0.00','0.0','30','202409191208',NULL,NULL,NULL,NULL,NULL,NULL),(31,'20240919-000016','2846.00','admin','2024 09 19','  Cash','  General','2846.00','0.00','0.00','0.0','31','202409191328',NULL,NULL,NULL,NULL,NULL,NULL),(32,'20240919-000017','499.00','admin','2024 09 19','  Cash','  General','499.00','0.00','0.00','0.0','32','202409191338',NULL,NULL,NULL,NULL,NULL,NULL),(33,'20240919-000018','950.00','admin','2024 09 19','  Cash','  General','950.00','0.00','0.00','0.0','33','202409191710',NULL,NULL,NULL,NULL,NULL,NULL),(34,'20240919-000019','2348.00','admin','2024 09 19','  Cash','  General','2348.00','0.00','0.00','0.0','34','202409191817',NULL,NULL,NULL,NULL,NULL,NULL),(35,'20240919-0000110','2149.00','admin','2024 09 19','  Cash','  General','2149.00','0.00','0.00','0.0','35','202409191847',NULL,NULL,NULL,NULL,NULL,NULL),(36,'20240919-0000111','349.00','admin','2024 09 19','  Cash','  General','349.00','0.00','0.00','0.0','36','202409191850',NULL,NULL,NULL,NULL,NULL,NULL),(37,'20240919-0000112','1099.00','admin','2024 09 19','  Cash','  General','1099.00','0.00','0.00','0.0','37','202409191930',NULL,NULL,NULL,NULL,NULL,NULL),(38,'20240919-0000113','900.00','admin','2024 09 19','  Cash','  General','900.00','0.00','0.00','0.0','38','202409192033',NULL,NULL,NULL,NULL,NULL,NULL),(39,'20240920-000011','1598.00','admin','2024 09 20','  Cash','  General','1598.00','0.00','0.00','0.0','39','202409201015',NULL,NULL,NULL,NULL,NULL,NULL),(40,'20240920-000012','1.00','admin','2024 09 20','  Cash','  General','1.00','0.00','0.00','0.0','40','202409201049',NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO `clicked_cust_name` (`_id`, `name`) VALUES (1,'');
INSERT INTO `itemdata` (`_id`, `itemname`, `total`) VALUES (1,'Jeans',6487),(2,'Leggings',900),(3,'Shirts',4500),(4,'T shits',4400),(5,'crocs bayband',1499),(6,'jockets ',1650),(7,'jockets brand',1199),(8,'night pant techno sports ',449),(9,'jockets brand',1199),(10,'night pant techno sports ',449);
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,'1','Jeans',6487,41,'13','Adults',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(2,'6','Leggings',900,6,'3','Adults',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(3,'3','Shirts',4500,29,'5','Adults',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(4,'2','T shits',4400,28,'11','Adults',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(5,'21','crocs bayband',1499,13,'1','None',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(6,'13','jockets ',1650,14,'3','None',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(7,'14','jockets brand',1199,10,'1','None',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(8,'23','night pant techno sports ',449,3,'1','None',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(9,'13','jockets brand',1199,6,'1','None',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10,'23','night pant techno sports ',449,2,'1','None',NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO `top_category` (`_id`, `category`, `value`) VALUES (1,'Adults',16287),(2,'None',8640),(5,'Adults',3295),(6,'None',8640),(7,'Adults',6289),(8,'None',9089),(9,'Adults',10285),(10,'None',9089),(11,'Adults',499),(12,'None',6947);
INSERT INTO `userdata` (`_id`, `username`, `total`) VALUES (1,'admin',15737),(2,'ladmin',2099);
INSERT INTO `userwiseorderlistitems` (`_id`, `username`, `sales`, `salespercentage`) VALUES (1,'madmin',15737,100),(2,'ladmin',2099,11);
