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,'tata tea premium 100gm','2.0','34.00','68.00','Item',NULL,NULL,'no',NULL,NULL,'20230813-000011','12:03:01 pm','2023 08 13','admin','1','  General','  Cash','1012.00','1012.00','1',NULL,NULL,NULL,NULL,'13 Aug 2023','2023081312:03:01','%','0','68.00','no','0.00',NULL,'202308131203','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'beverages','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(2,'tata tea bags 100dips','2.0','100.00','200.00','Item',NULL,NULL,'no',NULL,NULL,'20230813-000011','12:03:01 pm','2023 08 13','admin','1','  General','  Cash','1012.00','1012.00','2',NULL,NULL,NULL,NULL,'13 Aug 2023','2023081312:03:01','%','0','200.00','no','0.00',NULL,'202308131203','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'beverages','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(3,'cashew 200gm','1.0','219.00','219.00','Item',NULL,NULL,'no',NULL,NULL,'20230813-000011','12:03:01 pm','2023 08 13','admin','1','  General','  Cash','1012.00','1012.00','3',NULL,NULL,NULL,NULL,'13 Aug 2023','2023081312:03:01','%','0','219.00','no','0.00',NULL,'202308131203','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'dry fruits','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(4,'cashew 500gm','1.0','525.00','525.00','Item',NULL,NULL,'no',NULL,NULL,'20230813-000011','12:03:01 pm','2023 08 13','admin','1','  General','  Cash','1012.00','1012.00','4',NULL,NULL,NULL,NULL,'13 Aug 2023','2023081312:03:01','%','0','525.00','no','0.00',NULL,'202308131203','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'dry fruits','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(5,'air freshener','5.0','28.00','140.00','Item',NULL,NULL,'no',NULL,NULL,'20230813-000012','12:26:41 pm','2023 08 13','admin','1','  General','  Cash','3168.00','3168.00','5',NULL,NULL,NULL,NULL,'13 Aug 2023','2023081312:26:41','%','0','140.00','no','0.00',NULL,'202308131226','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'491',NULL,NULL,'','','','',NULL,NULL),(6,'napkins','2.0','86.00','172.00','Item',NULL,NULL,'no',NULL,NULL,'20230813-000012','12:26:41 pm','2023 08 13','admin','1','  General','  Cash','3168.00','3168.00','6',NULL,NULL,NULL,NULL,'13 Aug 2023','2023081312:26:41','%','0','172.00','no','0.00',NULL,'202308131226','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'496',NULL,NULL,'','','','',NULL,NULL),(7,'glass cleaner','2.0','66.00','132.00','Item',NULL,NULL,'no',NULL,NULL,'20230813-000012','12:26:41 pm','2023 08 13','admin','1','  General','  Cash','3168.00','3168.00','7',NULL,NULL,NULL,NULL,'13 Aug 2023','2023081312:26:41','%','0','132.00','no','0.00',NULL,'202308131226','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'503',NULL,NULL,'','','','',NULL,NULL),(8,'sponges/scrubbers','5.0','52.00','260.00','Item',NULL,NULL,'no',NULL,NULL,'20230813-000012','12:26:41 pm','2023 08 13','admin','1','  General','  Cash','3168.00','3168.00','8',NULL,NULL,NULL,NULL,'13 Aug 2023','2023081312:26:41','%','0','260.00','no','0.00',NULL,'202308131226','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'505',NULL,NULL,'','','','',NULL,NULL),(9,'dettol cool handwash 250ml','3.0','75.00','225.00','Item',NULL,NULL,'no',NULL,NULL,'20230813-000012','12:26:41 pm','2023 08 13','admin','1','  General','  Cash','3168.00','3168.00','9',NULL,NULL,NULL,NULL,'13 Aug 2023','2023081312:26:41','%','0','225.00','no','0.00',NULL,'202308131226','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'772',NULL,NULL,'','','','',NULL,NULL),(10,'lifebuoy handwash refill pack 900ml','2.0','153.00','306.00','Item',NULL,NULL,'no',NULL,NULL,'20230813-000012','12:26:41 pm','2023 08 13','admin','1','  General','  Cash','3168.00','3168.00','10',NULL,NULL,NULL,NULL,'13 Aug 2023','2023081312:26:41','%','0','306.00','no','0.00',NULL,'202308131226','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'773',NULL,NULL,'','','','',NULL,NULL),(11,'scrubbing pad','3.0','10.00','30.00','Item',NULL,NULL,'no',NULL,NULL,'20230813-000012','12:26:41 pm','2023 08 13','admin','1','  General','  Cash','3168.00','3168.00','11',NULL,NULL,NULL,NULL,'13 Aug 2023','2023081312:26:41','%','0','30.00','no','0.00',NULL,'202308131226','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'1031',NULL,NULL,'','','','',NULL,NULL),(12,'vim bar 500gm','3.0','43.00','129.00','Item',NULL,NULL,'no',NULL,NULL,'20230813-000012','12:26:41 pm','2023 08 13','admin','1','  General','  Cash','3168.00','3168.00','12',NULL,NULL,NULL,NULL,'13 Aug 2023','2023081312:26:41','%','0','129.00','no','0.00',NULL,'202308131226','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'1037',NULL,NULL,'','','','',NULL,NULL),(13,'mop with twist ','2.0','160.00','320.00','Item',NULL,NULL,'no',NULL,NULL,'20230813-000012','12:26:41 pm','2023 08 13','admin','1','  General','  Cash','3168.00','3168.00','13',NULL,NULL,NULL,NULL,'13 Aug 2023','2023081312:26:41','%','0','320.00','no','0.00',NULL,'202308131226','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'1080',NULL,NULL,'','','','',NULL,NULL),(14,'wiper full size','1.0','95.00','95.00','Item',NULL,NULL,'no',NULL,NULL,'20230813-000012','12:26:41 pm','2023 08 13','admin','1','  General','  Cash','3168.00','3168.00','14',NULL,NULL,NULL,NULL,'13 Aug 2023','2023081312:26:41','%','0','95.00','no','0.00',NULL,'202308131226','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'1081',NULL,NULL,'','','','',NULL,NULL),(15,'grass broom','2.0','80.00','160.00','Item',NULL,NULL,'no',NULL,NULL,'20230813-000012','12:26:41 pm','2023 08 13','admin','1','  General','  Cash','3168.00','3168.00','15',NULL,NULL,NULL,NULL,'13 Aug 2023','2023081312:26:41','%','0','160.00','no','0.00',NULL,'202308131226','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'1083',NULL,NULL,'','','','',NULL,NULL),(16,'lizol disinfectant 500ml','2.0','66.00','132.00','Item',NULL,NULL,'no',NULL,NULL,'20230813-000012','12:26:41 pm','2023 08 13','admin','1','  General','  Cash','3168.00','3168.00','16',NULL,NULL,NULL,NULL,'13 Aug 2023','2023081312:26:41','%','0','132.00','no','0.00',NULL,'202308131226','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'1084',NULL,NULL,'','','','',NULL,NULL),(17,'good knight advance refill','2.0','62.00','124.00','Item',NULL,NULL,'no',NULL,NULL,'20230813-000012','12:26:41 pm','2023 08 13','admin','1','  General','  Cash','3168.00','3168.00','17',NULL,NULL,NULL,NULL,'13 Aug 2023','2023081312:26:41','%','0','124.00','no','0.00',NULL,'202308131226','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'1088',NULL,NULL,'','','','',NULL,NULL),(18,'hit anti roach gel','1.0','123.00','123.00','Item',NULL,NULL,'no',NULL,NULL,'20230813-000012','12:26:41 pm','2023 08 13','admin','1','  General','  Cash','3168.00','3168.00','18',NULL,NULL,NULL,NULL,'13 Aug 2023','2023081312:26:41','%','0','123.00','no','0.00',NULL,'202308131226','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'1091',NULL,NULL,'','','','',NULL,NULL),(19,'ambipure set  and  refresh','2.0','218.00','436.00','Item',NULL,NULL,'no',NULL,NULL,'20230813-000012','12:26:41 pm','2023 08 13','admin','1','  General','  Cash','3168.00','3168.00','19',NULL,NULL,NULL,NULL,'13 Aug 2023','2023081312:26:41','%','0','436.00','no','0.00',NULL,'202308131226','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'1097',NULL,NULL,'','','','',NULL,NULL),(20,'godrej room spray','1.0','112.00','112.00','Item',NULL,NULL,'no',NULL,NULL,'20230813-000012','12:26:41 pm','2023 08 13','admin','1','  General','  Cash','3168.00','3168.00','20',NULL,NULL,NULL,NULL,'13 Aug 2023','2023081312:26:41','%','0','112.00','no','0.00',NULL,'202308131226','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'1100',NULL,NULL,'','','','',NULL,NULL),(21,'colin glass cleaner 500ml','2.0','72.00','144.00','Item',NULL,NULL,'no',NULL,NULL,'20230813-000012','12:26:41 pm','2023 08 13','admin','1','  General','  Cash','3168.00','3168.00','21',NULL,NULL,NULL,NULL,'13 Aug 2023','2023081312:26:41','%','0','144.00','no','0.00',NULL,'202308131226','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'1106',NULL,NULL,'','','','',NULL,NULL),(22,'lizol floor cleaner 975ml','1.0','128.00','128.00','Item',NULL,NULL,'no',NULL,NULL,'20230813-000012','12:26:41 pm','2023 08 13','admin','1','  General','  Cash','3168.00','3168.00','22',NULL,NULL,NULL,NULL,'13 Aug 2023','2023081312:26:41','%','0','128.00','no','0.00',NULL,'202308131226','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'1165',NULL,NULL,'','','','',NULL,NULL),(23,'PHINEOL(Clening Itam)','1.0','180.00','180.00','Item',NULL,NULL,'no',NULL,NULL,'20230813-000013','12:38:20 pm','2023 08 13','admin','1','  General','  Cash','171.00','171.00','23',NULL,NULL,NULL,NULL,'13 Aug 2023','2023081312:38:20','%','5','171.00','yes','9.00',NULL,'202308131238','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'household','admin','madmin',NULL,NULL,'89000075',NULL,NULL,'','','','',NULL,NULL),(24,'rin 500gm','1.0','37.00','37.00','Item',NULL,NULL,'no',NULL,NULL,'20231117-000011','10:54:24 pm','2023 11 17','admin','1','  General','  Cash','163.00','163.00','25',NULL,NULL,NULL,NULL,'17 Nov 2023','2023111722:54:24','%','0','37.00','no','0.00',NULL,'202311172254','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'household','admin','madmin',NULL,NULL,'66',NULL,NULL,'','','','',NULL,NULL),(25,'surfexcel blue 70gm','1.0','76.00','76.00','Item',NULL,NULL,'no',NULL,NULL,'20231117-000011','10:54:24 pm','2023 11 17','admin','1','  General','  Cash','163.00','163.00','26',NULL,NULL,NULL,NULL,'17 Nov 2023','2023111722:54:24','%','0','76.00','no','0.00',NULL,'202311172254','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'household','admin','madmin',NULL,NULL,'67',NULL,NULL,'','','','',NULL,NULL),(26,'tata tea fusion assan tea  and  kenyan tea 100gm','1.0','50.00','50.00','Item',NULL,NULL,'no',NULL,NULL,'20231117-000011','10:54:24 pm','2023 11 17','admin','1','  General','  Cash','163.00','163.00','27',NULL,NULL,NULL,NULL,'17 Nov 2023','2023111722:54:24','%','0','50.00','no','0.00',NULL,'202311172254','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'beverages','admin','madmin',NULL,NULL,'64',NULL,NULL,'','','','',NULL,NULL),(27,'nutella','1.0','170.00','170.00','Item',NULL,NULL,'no',NULL,NULL,'20231117-000012','10:55:24 pm','2023 11 17','admin','1','  General','  Cash','170.00','170.00','28',NULL,NULL,NULL,NULL,'17 Nov 2023','2023111722:55:24','%','0','170.00','no','0.00',NULL,'202311172255','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'branded foods','admin','madmin',NULL,NULL,'3',NULL,NULL,'','','','',NULL,NULL),(40,'PHINEOL(Clening Itam)','2.0','180.00','360.00','Item',NULL,NULL,'no',NULL,NULL,'20240311-000011','12:05:51 am','2024 03 11','admin','1','  General','  Cash','342.00','342.00','48',NULL,NULL,NULL,NULL,'11 Mar 2024','2024031100:05:51','%','5','342.00','yes','18.00',NULL,'202403110005','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'809856',NULL,NULL,'','','','',NULL,NULL),(41,'PHINEOL(Regular)','1.0','180.00','180.00','Item',NULL,NULL,'no',NULL,NULL,'20240311-000021','12:08:18 am','2024 03 11','admin','2','  General','  Sodexo','2820.00','2820.00','1',NULL,NULL,NULL,NULL,'11 Mar 2024','2024031100:08:18','%','5','171.00','yes','9.00',NULL,'202403110008','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'household','admin','madmin','0',NULL,'88070006',NULL,NULL,'','','','',NULL,NULL),(42,'surfexcel blue 70gm','1.0','76.00','76.00','Item',NULL,NULL,'no',NULL,NULL,'20240311-000021','12:08:18 am','2024 03 11','admin','2','  General','  Sodexo','2820.00','2820.00','2',NULL,NULL,NULL,NULL,'11 Mar 2024','2024031100:08:18','%','0','76.00','no','0.00',NULL,'202403110008','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'household','admin','madmin','0',NULL,'67',NULL,NULL,'','','','',NULL,NULL),(43,'DABAR GOLI','3.0','99.00','297.00','Item',NULL,NULL,'no',NULL,NULL,'20240311-000021','12:08:18 am','2024 03 11','admin','2','  General','  Sodexo','2820.00','2820.00','3',NULL,NULL,NULL,NULL,'11 Mar 2024','2024031100:08:18','%','0','297.00','no','0.00',NULL,'202403110008','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'household','admin','madmin','0',NULL,'4',NULL,NULL,'','','','',NULL,NULL),(44,'sponges/scrubbers','3.0','52.00','156.00','Item',NULL,NULL,'no',NULL,NULL,'20240311-000021','12:08:18 am','2024 03 11','admin','2','  General','  Sodexo','2820.00','2820.00','4',NULL,NULL,NULL,NULL,'11 Mar 2024','2024031100:08:18','%','0','156.00','no','0.00',NULL,'202403110008','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin','0',NULL,'505',NULL,NULL,'','','','',NULL,NULL),(45,'air freshener','1.0','28.00','28.00','Item',NULL,NULL,'no',NULL,NULL,'20240311-000021','12:08:18 am','2024 03 11','admin','2','  General','  Sodexo','2820.00','2820.00','5',NULL,NULL,NULL,NULL,'11 Mar 2024','2024031100:08:18','%','0','28.00','no','0.00',NULL,'202403110008','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin','0',NULL,'491',NULL,NULL,'','','','',NULL,NULL),(46,'vim bar 500gm','3.0','43.00','129.00','Item',NULL,NULL,'no',NULL,NULL,'20240311-000021','12:08:18 am','2024 03 11','admin','2','  General','  Sodexo','2820.00','2820.00','6',NULL,NULL,NULL,NULL,'11 Mar 2024','2024031100:08:18','%','0','129.00','no','0.00',NULL,'202403110008','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin','0',NULL,'1037',NULL,NULL,'','','','',NULL,NULL),(47,'napkins','1.0','86.00','86.00','Item',NULL,NULL,'no',NULL,NULL,'20240311-000021','12:08:18 am','2024 03 11','admin','2','  General','  Sodexo','2820.00','2820.00','7',NULL,NULL,NULL,NULL,'11 Mar 2024','2024031100:08:18','%','0','86.00','no','0.00',NULL,'202403110008','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin','0',NULL,'496',NULL,NULL,'','','','',NULL,NULL),(48,'glass cleaner','3.0','66.00','198.00','Item',NULL,NULL,'no',NULL,NULL,'20240311-000021','12:08:18 am','2024 03 11','admin','2','  General','  Sodexo','2820.00','2820.00','8',NULL,NULL,NULL,NULL,'11 Mar 2024','2024031100:08:18','%','0','198.00','no','0.00',NULL,'202403110008','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin','0',NULL,'503',NULL,NULL,'','','','',NULL,NULL),(49,'grass broom','2.0','80.00','160.00','Item',NULL,NULL,'no',NULL,NULL,'20240311-000021','12:08:18 am','2024 03 11','admin','2','  General','  Sodexo','2820.00','2820.00','9',NULL,NULL,NULL,NULL,'11 Mar 2024','2024031100:08:18','%','0','160.00','no','0.00',NULL,'202403110008','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin','0',NULL,'1083',NULL,NULL,'','','','',NULL,NULL),(50,'mop with twist ','2.0','160.00','320.00','Item',NULL,NULL,'no',NULL,NULL,'20240311-000021','12:08:18 am','2024 03 11','admin','2','  General','  Sodexo','2820.00','2820.00','10',NULL,NULL,NULL,NULL,'11 Mar 2024','2024031100:08:18','%','0','320.00','no','0.00',NULL,'202403110008','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin','0',NULL,'1080',NULL,NULL,'','','','',NULL,NULL),(51,'lifebuoy handwash refill pack 900ml','2.0','153.00','306.00','Item',NULL,NULL,'no',NULL,NULL,'20240311-000021','12:08:18 am','2024 03 11','admin','2','  General','  Sodexo','2820.00','2820.00','11',NULL,NULL,NULL,NULL,'11 Mar 2024','2024031100:08:18','%','0','306.00','no','0.00',NULL,'202403110008','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin','0',NULL,'773',NULL,NULL,'','','','',NULL,NULL),(52,'wiper full size','1.0','95.00','95.00','Item',NULL,NULL,'no',NULL,NULL,'20240311-000021','12:08:18 am','2024 03 11','admin','2','  General','  Sodexo','2820.00','2820.00','12',NULL,NULL,NULL,NULL,'11 Mar 2024','2024031100:08:18','%','0','95.00','no','0.00',NULL,'202403110008','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin','0',NULL,'1081',NULL,NULL,'','','','',NULL,NULL),(53,'colin glass cleaner 500ml','2.0','95.00','190.00','Item',NULL,NULL,'no',NULL,NULL,'20240311-000021','12:08:18 am','2024 03 11','admin','2','  General','  Sodexo','2820.00','2820.00','13',NULL,NULL,NULL,NULL,'11 Mar 2024','2024031100:08:18','%','0','190.00','no','0.00',NULL,'202403110008','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin','0',NULL,'1106',NULL,NULL,'','','','',NULL,NULL),(54,'godrej room spray','2.0','112.00','224.00','Item',NULL,NULL,'no',NULL,NULL,'20240311-000021','12:08:18 am','2024 03 11','admin','2','  General','  Sodexo','2820.00','2820.00','14',NULL,NULL,NULL,NULL,'11 Mar 2024','2024031100:08:18','%','0','224.00','no','0.00',NULL,'202403110008','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin','0',NULL,'1100',NULL,NULL,'','','','',NULL,NULL),(55,'lizol floor cleaner 975ml','3.0','128.00','384.00','Item',NULL,NULL,'no',NULL,NULL,'20240311-000021','12:08:18 am','2024 03 11','admin','2','  General','  Sodexo','2820.00','2820.00','15',NULL,NULL,NULL,NULL,'11 Mar 2024','2024031100:08:18','%','0','384.00','no','0.00',NULL,'202403110008','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin','0',NULL,'1165',NULL,NULL,'','','','',NULL,NULL);
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,'20230813-000011','1012.00','admin','2023 08 13','  Cash','  General','1012.00','0.00','0.00','0.0','1','202308131203',NULL,NULL,NULL,NULL,NULL,NULL),(2,'20230813-000012','3168.00','admin','2023 08 13','  Cash','  General','3168.00','0.00','0.00','0.0','2','202308131226',NULL,NULL,NULL,NULL,NULL,NULL),(3,'20230813-000013','171.00','admin','2023 08 13','  Cash','  General','171.00','0.00','0.00','0.0','3','202308131238',NULL,NULL,NULL,NULL,NULL,NULL),(4,'20231117-000011','163.00','admin','2023 11 17','  Cash','  General','163.00','0.00','0.00','0.0','1','202311172254',NULL,NULL,NULL,NULL,NULL,NULL),(5,'20231117-000012','170.00','admin','2023 11 17','  Cash','  General','170.00','0.00','0.00','0.0','2','202311172255',NULL,NULL,NULL,NULL,NULL,NULL),(7,'20240311-000011','342.00','admin','2024 03 11','  Cash','  General','342.00','0.00','0.00','0.0','1','202403110005',NULL,NULL,NULL,NULL,NULL,NULL),(8,'20240311-000021','2820.00','admin','2024 03 11','  Sodexo','  General','2820.00','0.00','0.00','0.0','2','202403110008',NULL,NULL,NULL,NULL,NULL,NULL),(9,'20240827-000011','1137.00','admin','2024 08 27','  Cash','  General','1137.00','0.00','0.00','0.0','1','202408272209',NULL,NULL,NULL,NULL,NULL,NULL),(10,'20240827-000012','475.00','user1','2024 08 27','  Cash','  General','475.00','0.00','0.00','0.0','2','202408272211',NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO `clicked_cust_name` (`_id`, `name`) VALUES (1,'');
INSERT INTO `itemdata` (`_id`, `itemname`, `total`) VALUES (1,'PHINEOL(Clening Itam)',180),(2,'air freshener',140),(3,'ambipure set  and  refresh',436),(4,'cashew 200gm',219),(5,'cashew 500gm',525),(6,'colin glass cleaner 500ml',144),(7,'dettol cool handwash 250ml',225),(8,'glass cleaner',132),(9,'godrej room spray',112),(10,'good knight advance refill',124),(11,'grass broom',160),(12,'hit anti roach gel',123),(13,'lifebuoy handwash refill pack 900ml',306),(14,'lizol disinfectant 500ml',132),(15,'lizol floor cleaner 975ml',128),(16,'mop with twist ',320),(17,'napkins',172),(18,'scrubbing pad',30),(19,'sponges/scrubbers',260),(20,'tata tea bags 100dips',200),(21,'tata tea premium 100gm',68),(22,'vim bar 500gm',129),(23,'wiper full size',95);
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,'1356','cashew 200gm',219,22,'1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(2,'1357','cashew 500gm',525,52,'1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(3,'46','tata tea bags 100dips',200,20,'2',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(4,'63','tata tea premium 100gm',68,7,'2',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(5,'1357','cashew 500gm',525,12,'1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(6,'1106','colin glass cleaner 500ml',144,3,'2',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(7,'772','dettol cool handwash 250ml',225,5,'3',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(8,'503','glass cleaner',132,3,'2',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(9,'1100','godrej room spray',112,3,'1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10,'1088','good knight advance refill',124,3,'2',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(11,'1083','grass broom',160,4,'2',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(12,'1091','hit anti roach gel',123,3,'1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(13,'773','lifebuoy handwash refill pack 900ml',306,7,'2',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(14,'1084','lizol disinfectant 500ml',132,3,'2',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(15,'1165','lizol floor cleaner 975ml',128,3,'1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(16,'1080','mop with twist ',320,7,'2',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(17,'496','napkins',172,4,'2',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(18,'1031','scrubbing pad',30,1,'3',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(19,'505','sponges/scrubbers',260,6,'5',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(20,'46','tata tea bags 100dips',200,5,'2',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(21,'63','tata tea premium 100gm',68,2,'2',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(22,'1037','vim bar 500gm',129,3,'3',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(23,'1081','wiper full size',95,2,'1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO `top_category` (`_id`, `category`, `value`) VALUES (6,'None',3168),(7,'beverages',268),(8,'dry fruits',744),(9,'household',180);
INSERT INTO `userdata` (`_id`, `username`, `total`) VALUES (1,'admin',4351);
INSERT INTO `userwiseorderlistitems` (`_id`, `username`, `sales`, `salespercentage`) VALUES (1,'madmin',1012,100);
