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,'sona masoori raw rice 1kg','2.0','56.00','112.00','Item',NULL,NULL,'no',NULL,NULL,'20240810-000011','01:42:58 PM','2024 08 10','admin','1','  General','  Cash','267.00','267.00','1',NULL,NULL,NULL,NULL,'10 Aug 2024','2024081013:42:58','%','0','112.00','no','0.00',NULL,'202408101342','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'rice whole grains','admin','madmin',NULL,NULL,'',NULL,'112.00','','','','',NULL,'56.00'),(2,'carrots kg','1.0','70.00','70.00','Item',NULL,NULL,'no',NULL,NULL,'20240810-000011','01:42:58 PM','2024 08 10','admin','1','  General','  Cash','267.00','267.00','2',NULL,NULL,NULL,NULL,'10 Aug 2024','2024081013:42:58','%','0','70.00','no','0.00',NULL,'202408101342','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','admin','madmin',NULL,NULL,'',NULL,'70.00','','','','',NULL,'70.00'),(3,'cauliflower kg','1.0','45.00','45.00','Item',NULL,NULL,'no',NULL,NULL,'20240810-000011','01:42:58 PM','2024 08 10','admin','1','  General','  Cash','267.00','267.00','3',NULL,NULL,NULL,NULL,'10 Aug 2024','2024081013:42:58','%','0','45.00','no','0.00',NULL,'202408101342','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','admin','madmin',NULL,NULL,'',NULL,'45.00','','','','',NULL,'45.00'),(4,'beans kg','1.0','40.00','40.00','Item',NULL,NULL,'no',NULL,NULL,'20240810-000011','01:42:58 PM','2024 08 10','admin','1','  General','  Cash','267.00','267.00','4',NULL,NULL,NULL,NULL,'10 Aug 2024','2024081013:42:58','%','0','40.00','no','0.00',NULL,'202408101342','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','admin','madmin',NULL,NULL,'',NULL,'40.00','','','','',NULL,'40.00'),(5,'sweet corn piece','2.0','15.00','30.00','Item',NULL,NULL,'no',NULL,NULL,'20240810-000012','02:05:06 PM','2024 08 10','admin','1','  General','  Upiqr','30.00','30.00','8',NULL,NULL,NULL,NULL,'10 Aug 2024','2024081014:05:06','%','0','30.00','no','0.00',NULL,'202408101405','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','admin','madmin','0',NULL,'',NULL,'30.00','','','','',NULL,'15.00'),(6,'Agrawals dhokla mix 500gm','1.0','59.00','59.00','Item',NULL,NULL,'no',NULL,NULL,'20240812-000011','10:05:18 PM','2024 08 12','admin','1','  General','  Cash','59.00','59.00','11',NULL,NULL,NULL,NULL,'12 Aug 2024','2024081222:05:18','%','0','59.00','no','0.00',NULL,'202408122205','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','Jayaprakash',NULL,NULL,'',NULL,'59.00','','','','',NULL,'59.00'),(7,'Agrawals dhokla mix 500gm','1.0','59.00','59.00','Item',NULL,NULL,'no',NULL,NULL,'20240812-000012','10:05:33 PM','2024 08 12','admin','1','  General','  Cash','59.00','59.00','11',NULL,NULL,NULL,NULL,'12 Aug 2024','2024081222:05:33','%','0','59.00','no','0.00',NULL,'202408122205','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','Jayaprakash',NULL,NULL,'',NULL,'59.00','','','','',NULL,'59.00'),(8,'Agrawals dhokla mix 500gm','1.0','59.00','59.00','Item',NULL,NULL,'no',NULL,NULL,'20240812-000013','10:06:53 PM','2024 08 12','admin','1','  General','  Cash','59.00','59.00','11',NULL,NULL,NULL,NULL,'12 Aug 2024','2024081222:06:53','%','0','59.00','no','0.00',NULL,'202408122206','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','Jayaprakash',NULL,NULL,'',NULL,'59.00','','','','',NULL,'59.00'),(9,'kurkure puffcorn 5Rs','1.0','5.00','5.00','Item',NULL,NULL,'no',NULL,NULL,'20240829-000011','11:52:57 PM','2024 08 29','admin','1','  General','  Upiqr','5.00','5.00','2',NULL,NULL,NULL,NULL,'29 Aug 2024','2024082923:52:57','%','0','5.00','no','0.00',NULL,'202408292352','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'beverages','admin','JP','0',NULL,'8901491365666',NULL,'5.00','','','','',NULL,'5.00'),(10,'Kurkure naughty Tomato 5Rs','1.0','5.00','5.00','Item',NULL,NULL,'no',NULL,NULL,'20240830-000011','11:33:39 PM','2024 08 30','admin','1','  General','  Cash','5.00','5.00','4',NULL,NULL,NULL,NULL,'30 Aug 2024','2024083023:33:39','%','0','5.00','no','0.00',NULL,'202408302333','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'household','admin','JP',NULL,NULL,'8901491104470',NULL,'5.00','','','','',NULL,'5.00'),(11,'Kurkure naughty Tomato 5Rs','2.0','5.00','10.00','Item',NULL,NULL,'no',NULL,NULL,'20240901-000011','12:21:28 AM','2024 09 01','admin','1','  General','  Cash','10.00','10.00','8',NULL,NULL,NULL,NULL,'01 Sep 2024','2024090100:21:28','%','0','10.00','no','0.00',NULL,'202409010021','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'household','admin','JP',NULL,NULL,'8901491104470',NULL,'10.00','','','','',NULL,'5.00'),(12,'Brit Jimjam Naughty Jam 10Rs','1.0','10.00','10.00','Item',NULL,NULL,'no',NULL,NULL,'20240902-000011','01:21:17 AM','2024 09 02','admin','1','  General','  Cash','10.00','10.00','1',NULL,NULL,NULL,NULL,'02 Sep 2024','2024090201:21:17','%','0','10.00','no','0.00',NULL,'202409020121','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'bread bakery and eggs','admin','JP',NULL,NULL,'8901063029255',NULL,'10.00','','','','',NULL,'10.00'),(13,'GTS Bullet Rice 10kg','1.0','960.00','960.00','Item',NULL,NULL,'no',NULL,NULL,'20240904-000011','12:37:03 AM','2024 09 04','admin','1','  General','  Cash','960.00','960.00','2',NULL,NULL,NULL,NULL,'04 Sep 2024','2024090400:37:03','%','0','960.00','no','0.00',NULL,'202409040037','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'household','admin','JP',NULL,NULL,'8908008249044',NULL,'960.00','','','','',NULL,'960.00'),(14,'Kurkure Puffcorn 10Rs','1.0','10.00','10.00','Item',NULL,NULL,'no',NULL,NULL,'20240905-000011','02:16:30 AM','2024 09 05','admin','1','  General','  Cash','10.00','10.00','3',NULL,NULL,NULL,NULL,'05 Sep 2024','2024090502:16:30','%','0','10.00','no','0.00',NULL,'202409050216','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'household','admin','JP',NULL,NULL,'8901491365703',NULL,'10.00','','','','',NULL,'10.00'),(15,'Sunpure Oil 1Ltr ','1.0','120.00','120.00','Item',NULL,NULL,'no',NULL,NULL,'20240905-000012','10:35:09 AM','2024 09 05','admin','1','  General','  Cash','120.00','120.00','1',NULL,NULL,NULL,NULL,'05 Sep 2024','2024090510:35:09','%','0','120.00','no','0.00',NULL,'202409051035','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'edible oils and ghee','admin','JP',NULL,NULL,'8908000502017',NULL,'120.00','','','','',NULL,'120.00'),(16,'Shanthala Forest Sandal','2.0','15.00','30.00','Item',NULL,NULL,'no',NULL,NULL,'20240905-000013','09:20:22 PM','2024 09 05','admin','1','  General','  Cash','30.00','30.00','5',NULL,NULL,NULL,NULL,'05 Sep 2024','2024090521:20:22','%','0','30.00','no','0.00',NULL,'202409052120','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'household','admin','JP',NULL,NULL,'8904012806846',NULL,'30.00','','','','',NULL,'15.00'),(17,'Nandini Milk Green 500ml','1.0','26.00','26.00','Item',NULL,NULL,'no',NULL,NULL,'20240906-000011','09:35:19 AM','2024 09 06','admin','1','  General','  Cash','36.00','36.00','2',NULL,NULL,NULL,NULL,'06 Sep 2024','2024090609:35:19','%','0','26.00','no','0.00',NULL,'202409060935','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','JP',NULL,NULL,'',NULL,'26.00','','','','',NULL,'26.00'),(18,'Cadbury dairy milk 10Rs','1.0','10.00','10.00','Item',NULL,NULL,'no',NULL,NULL,'20240906-000011','09:35:19 AM','2024 09 06','admin','1','  General','  Cash','36.00','36.00','3',NULL,NULL,NULL,NULL,'06 Sep 2024','2024090609:35:19','%','0','10.00','no','0.00',NULL,'202409060935','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','JP',NULL,NULL,'762220223793',NULL,'10.00','','','','',NULL,'10.00'),(19,'Kurkure Masala munch 10Rs','1.0','10.00','10.00','Item',NULL,NULL,'no',NULL,NULL,'20240906-000012','02:15:24 PM','2024 09 06','admin','1','  General','  Cash','10.00','10.00','40',NULL,NULL,NULL,NULL,'06 Sep 2024','2024090614:15:24','%','0','10.00','no','0.00',NULL,'202409061415','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'household','admin','JP',NULL,NULL,'8901491361026',NULL,'10.00','','','','',NULL,'10.00'),(20,'Nandini Ghee 500ml','1.0','315.00','315.00','Item',NULL,NULL,'no',NULL,NULL,'20240907-000011','08:28:54 AM','2024 09 07','admin','1','  General','  Cash','510.00','510.00','1',NULL,NULL,NULL,NULL,'07 Sep 2024','2024090708:28:54','%','0','315.00','no','0.00',NULL,'202409070828','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'edible oils and ghee','admin','JP',NULL,NULL,'8906036670878',NULL,'10.00','','','','',NULL,'315.00'),(21,'GRB Ghee 100ml ','1.0','103.00','103.00','Item',NULL,NULL,'no',NULL,NULL,'20240907-000011','08:28:54 AM','2024 09 07','admin','1','  General','  Cash','510.00','510.00','2',NULL,NULL,NULL,NULL,'07 Sep 2024','2024090708:28:54','%','0','103.00','no','0.00',NULL,'202409070828','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'edible oils and ghee','admin','JP',NULL,NULL,'8906010360382',NULL,'10.00','','','','',NULL,'103.00'),(22,'MTR Puliogare powder 27g','1.0','12.00','12.00','Item',NULL,NULL,'no',NULL,NULL,'20240907-000011','08:28:54 AM','2024 09 07','admin','1','  General','  Cash','510.00','510.00','4',NULL,NULL,NULL,NULL,'07 Sep 2024','2024090708:28:54','%','0','12.00','no','0.00',NULL,'202409070828','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'masalas and spices','admin','JP',NULL,NULL,'8901042970493',NULL,'10.00','','','','',NULL,'12.00'),(23,'Cashew Nuts pack 10Rs','2.0','10.00','20.00','Item',NULL,NULL,'no',NULL,NULL,'20240907-000011','08:28:54 AM','2024 09 07','admin','1','  General','  Cash','510.00','510.00','6',NULL,NULL,NULL,NULL,'07 Sep 2024','2024090708:28:54','%','0','10.00','no','0.00',NULL,'202409070828','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'dry fruits','admin','JP',NULL,NULL,'',NULL,'20.00','','','','',NULL,'10.00'),(24,'RMF Deep Plain Puffed Rice','1.0','60.00','60.00','Item',NULL,NULL,'no',NULL,NULL,'20240907-000011','08:28:54 AM','2024 09 07','admin','1','  General','  Cash','510.00','510.00','7',NULL,NULL,NULL,NULL,'07 Sep 2024','2024090708:28:54','%','0','60.00','no','0.00',NULL,'202409070828','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','JP',NULL,NULL,'',NULL,'60.00','','','','',NULL,'60.00'),(25,'Goldwinner Oil 1Ltr','1.0','114.00','114.00','Item',NULL,NULL,'no',NULL,NULL,'20240907-000012','08:43:20 AM','2024 09 07','admin','1','  General','  Cash','162.00','162.00','54',NULL,NULL,NULL,NULL,'07 Sep 2024','2024090708:43:20','%','0','114.00','no','0.00',NULL,'202409070843','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'edible oils and ghee','admin','JP',NULL,NULL,'8906010261078',NULL,'114.00','','','','',NULL,'114.00'),(26,'Sugar 50Rs per kg','1.00','48.00','48.00','Item',NULL,NULL,'no',NULL,NULL,'20240907-000012','08:43:20 AM','2024 09 07','admin','1','  General','  Cash','162.00','162.00','55',NULL,NULL,NULL,NULL,'07 Sep 2024','2024090708:43:20','%','0','48.00','no','0.00',NULL,'202409070843','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','JP',NULL,NULL,'',NULL,'48.00','','','','',NULL,'48.00'),(27,'GTS Bullet Rice 85Rs per Kg','60','85.00','5100.00','Item',NULL,NULL,'no',NULL,NULL,'20240908-000011','08:06:45 AM','2024 09 08','admin','1','  General','  Cash','5100.00','5100.00','86',NULL,NULL,NULL,NULL,'08 Sep 2024','2024090808:06:45','%','0','2550.00','no','0.00',NULL,'202409080806','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','JP',NULL,NULL,'',NULL,'5100.00','','','','',NULL,'85.00'),(28,'Kurkure Masala munch 10Rs','1.0','10.00','10.00','Item',NULL,NULL,'no',NULL,NULL,'20240908-000012','09:11:38 AM','2024 09 08','admin','1','  General','  Cash','10.00','10.00','87',NULL,NULL,NULL,NULL,'08 Sep 2024','2024090809:11:38','%','0','10.00','no','0.00',NULL,'202409080911','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'household','admin','JP',NULL,NULL,'8901491361026',NULL,'10.00','','','','',NULL,'10.00'),(29,'Nandini Milk Spl 500ml','1.0','27.00','27.00','Item',NULL,NULL,'no',NULL,NULL,'20240908-000013','09:33:33 AM','2024 09 08','admin','1','  General','  Cash','47.00','47.00','88',NULL,NULL,NULL,NULL,'08 Sep 2024','2024090809:33:33','%','0','27.00','no','0.00',NULL,'202409080933','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','JP',NULL,NULL,'',NULL,'27.00','','','','',NULL,'27.00'),(30,'Sunfeast Marie Light 71.1g','2.0','10.00','20.00','Item',NULL,NULL,'no',NULL,NULL,'20240908-000013','09:33:33 AM','2024 09 08','admin','1','  General','  Cash','47.00','47.00','89',NULL,NULL,NULL,NULL,'08 Sep 2024','2024090809:33:33','%','0','20.00','no','0.00',NULL,'202409080933','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','JP',NULL,NULL,'8901725012946',NULL,'20.00','','','','',NULL,'10.00'),(31,'ID idly dosa batter','2.0','90.00','180.00','Item',NULL,NULL,'no',NULL,NULL,'20240908-000014','10:28:00 AM','2024 09 08','admin','1','  General','  Cash','180.00','180.00','94',NULL,NULL,NULL,NULL,'08 Sep 2024','2024090810:28:00','%','0','90.00','no','0.00',NULL,'202409081028','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'household','admin','JP',NULL,NULL,'8906020580015',NULL,'180.00','','','','',NULL,'90.00'),(32,'sprite 2ltr','1.0','76.00','76.00','Item',NULL,NULL,'no',NULL,NULL,'20240908-000015','11:03:49 AM','2024 09 08','admin','1','  General','  Cash','76.00','76.00','95',NULL,NULL,NULL,NULL,'08 Sep 2024','2024090811:03:49','%','0','76.00','no','0.00',NULL,'202409081103','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'beverages','admin','JP',NULL,NULL,'',NULL,'76.00','','','','',NULL,'76.00'),(33,'Surf Excel Front Load Liq 10Rs','5.0','10.00','50.00','Item',NULL,NULL,'no',NULL,NULL,'20240908-000016','11:35:10 AM','2024 09 08','admin','1','  General','  Cash','50.00','50.00','96',NULL,NULL,NULL,NULL,'08 Sep 2024','2024090811:35:10','%','0','10.00','no','0.00',NULL,'202409081135','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'household','admin','JP',NULL,NULL,'8901030695483',NULL,'50.00','','','','',NULL,'10.00'),(34,'Kurkure Masala munch 10Rs','1.0','10.00','10.00','Item',NULL,NULL,'no',NULL,NULL,'20240908-000017','03:56:24 PM','2024 09 08','admin','1','  General','  Cash','30.00','30.00','99',NULL,NULL,NULL,NULL,'08 Sep 2024','2024090815:56:24','%','0','10.00','no','0.00',NULL,'202409081556','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'household','admin','JP',NULL,NULL,'8901491361026',NULL,'10.00','','','','',NULL,'10.00'),(35,'Kurkure Puffcorn 10Rs','1.0','10.00','10.00','Item',NULL,NULL,'no',NULL,NULL,'20240908-000017','03:56:24 PM','2024 09 08','admin','1','  General','  Cash','30.00','30.00','100',NULL,NULL,NULL,NULL,'08 Sep 2024','2024090815:56:24','%','0','10.00','no','0.00',NULL,'202409081556','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'household','admin','JP',NULL,NULL,'8901491365703',NULL,'10.00','','','','',NULL,'10.00'),(36,'Bingo Salt 10Rs','1.0','10.00','10.00','Item',NULL,NULL,'no',NULL,NULL,'20240908-000017','03:56:24 PM','2024 09 08','admin','1','  General','  Cash','30.00','30.00','101',NULL,NULL,NULL,NULL,'08 Sep 2024','2024090815:56:24','%','0','10.00','no','0.00',NULL,'202409081556','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'household','admin','JP',NULL,NULL,'8901725007096',NULL,'10.00','','','','',NULL,'10.00'),(37,'Kelloggs 20Rs','1.0','20.00','20.00','Item',NULL,NULL,'no',NULL,NULL,'20240908-000018','10:03:09 PM','2024 09 08','admin','1','  General','  Cash','225.00','225.00','108',NULL,NULL,NULL,NULL,'08 Sep 2024','2024090822:03:09','%','0','20.00','no','0.00',NULL,'202409082203','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'bread bakery and eggs','admin','JP',NULL,NULL,'8901499009661',NULL,'5.00','','','','',NULL,'20.00'),(38,'Himalaya neem n turmeric ','1.0','64.00','64.00','Item',NULL,NULL,'no',NULL,NULL,'20240908-000018','10:03:09 PM','2024 09 08','admin','1','  General','  Cash','225.00','225.00','109',NULL,NULL,NULL,NULL,'08 Sep 2024','2024090822:03:09','%','0','64.00','no','0.00',NULL,'202409082203','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','JP',NULL,NULL,'8901138714550',NULL,'5.00','','','','',NULL,'64.00'),(39,'Kelloggs Corn Flakes Strawberry 10rs','1.0','10.00','10.00','Item',NULL,NULL,'no',NULL,NULL,'20240908-000018','10:03:09 PM','2024 09 08','admin','1','  General','  Cash','225.00','225.00','110',NULL,NULL,NULL,NULL,'08 Sep 2024','2024090822:03:09','%','0','10.00','no','0.00',NULL,'202409082203','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'bread bakery and eggs','admin','JP',NULL,NULL,'8901499011039',NULL,'5.00','','','','',NULL,'10.00'),(40,'Horlicks 5Rs Sachet','2.0','5.00','10.00','Item',NULL,NULL,'no',NULL,NULL,'20240908-000018','10:03:09 PM','2024 09 08','admin','1','  General','  Cash','225.00','225.00','111',NULL,NULL,NULL,NULL,'08 Sep 2024','2024090822:03:09','%','0','5.00','no','0.00',NULL,'202409082203','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'household','admin','JP',NULL,NULL,'8901030979903',NULL,'10.00','','','','',NULL,'5.00'),(41,'Pears soft and fresh 100g','1.0','62.00','62.00','Item',NULL,NULL,'no',NULL,NULL,'20240908-000018','10:03:09 PM','2024 09 08','admin','1','  General','  Cash','225.00','225.00','112',NULL,NULL,NULL,NULL,'08 Sep 2024','2024090822:03:09','%','0','62.00','no','0.00',NULL,'202409082203','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'household','admin','JP',NULL,NULL,'8901030871016',NULL,'62.00','','','','',NULL,'62.00'),(42,'Odonil Lavender 50g','1.0','59.00','59.00','Item',NULL,NULL,'no',NULL,NULL,'20240908-000018','10:03:09 PM','2024 09 08','admin','1','  General','  Cash','225.00','225.00','113',NULL,NULL,NULL,NULL,'08 Sep 2024','2024090822:03:09','%','0','59.00','no','0.00',NULL,'202409082203','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'household','admin','JP',NULL,NULL,'8901207029899',NULL,'59.00','','','','',NULL,'59.00'),(43,'Kesar Chiroti Rava 1Kg','1.0','70.00','70.00','Item',NULL,NULL,'no',NULL,NULL,'20240909-000011','07:25:07 AM','2024 09 09','admin','1','  General','  Cash','124.00','124.00','2',NULL,NULL,NULL,NULL,'09 Sep 2024','2024090907:25:07','%','0','70.00','no','0.00',NULL,'202409090725','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'flours and sooji','admin','JP',NULL,NULL,'8908015377365',NULL,'27.00','','','','',NULL,'70.00'),(44,'Nandini Milk Spl 500ml','2.0','27.00','54.00','Item',NULL,NULL,'no',NULL,NULL,'20240909-000011','07:25:07 AM','2024 09 09','admin','1','  General','  Cash','124.00','124.00','3',NULL,NULL,NULL,NULL,'09 Sep 2024','2024090907:25:07','%','0','27.00','no','0.00',NULL,'202409090725','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','JP',NULL,NULL,'',NULL,'54.00','','','','',NULL,'27.00'),(45,'Kit Kat 10Rs','1.0','10.00','10.00','Item',NULL,NULL,'no',NULL,NULL,'20240909-000012','08:55:43 PM','2024 09 09','admin','1','  General','  Cash','54.00','54.00','5',NULL,NULL,NULL,NULL,'09 Sep 2024','2024090920:55:43','%','0','10.00','no','0.00',NULL,'202409092055','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'bread bakery and eggs','admin','JP',NULL,NULL,'8901058005233',NULL,'2.00','','','','',NULL,'10.00'),(46,'Dark fantasy 75g','1.0','40.00','40.00','Item',NULL,NULL,'no',NULL,NULL,'20240909-000012','08:55:43 PM','2024 09 09','admin','1','  General','  Cash','54.00','54.00','6',NULL,NULL,NULL,NULL,'09 Sep 2024','2024090920:55:43','%','0','40.00','no','0.00',NULL,'202409092055','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','JP',NULL,NULL,'8901725015275',NULL,'2.00','','','','',NULL,'40.00'),(47,'Vicks 2rs','2.0','2.00','4.00','Item',NULL,NULL,'no',NULL,NULL,'20240909-000012','08:55:43 PM','2024 09 09','admin','1','  General','  Cash','54.00','54.00','7',NULL,NULL,NULL,NULL,'09 Sep 2024','2024090920:55:43','%','0','2.00','no','0.00',NULL,'202409092055','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'bread bakery and eggs','admin','JP',NULL,NULL,'4987176248596',NULL,'4.00','','','','',NULL,'2.00'),(48,'Pampers L Size 2pcs','1.0','30.00','30.00','Item',NULL,NULL,'no',NULL,NULL,'20240909-000013','09:04:53 PM','2024 09 09','admin','1','  General','  Cash','30.00','30.00','8',NULL,NULL,NULL,NULL,'09 Sep 2024','2024090921:04:53','%','0','30.00','no','0.00',NULL,'202409092104','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'personal care','admin','JP',NULL,NULL,'4987176071347',NULL,'30.00','','','','',NULL,'30.00'),(49,'Yippee Noodles 420g','1.0','84.00','84.00','Item',NULL,NULL,'no',NULL,NULL,'20240909-000014','09:07:48 PM','2024 09 09','admin','1','  General','  Cash','84.00','84.00','9',NULL,NULL,NULL,NULL,'09 Sep 2024','2024090921:07:48','%','0','84.00','no','0.00',NULL,'202409092107','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'household','admin','JP',NULL,NULL,'8901725018986',NULL,'84.00','','','','',NULL,'84.00'),(50,'Goldwinner Oil 1Ltr','1.0','120.00','120.00','Item',NULL,NULL,'no',NULL,NULL,'20240909-000015','10:38:57 PM','2024 09 09','admin','1','  General','  Cash','647.75','647.75','10',NULL,NULL,NULL,NULL,'09 Sep 2024','2024090922:38:57','%','0','120.00','no','0.00',NULL,'202409092238','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'edible oils and ghee','admin','JP',NULL,NULL,'8906010261078',NULL,'85.00','','','','',NULL,'120.00'),(51,'Sofy Pad XL 6pc ','1.0','40.00','40.00','Item',NULL,NULL,'no',NULL,NULL,'20240909-000015','10:38:57 PM','2024 09 09','admin','1','  General','  Cash','647.75','647.75','11',NULL,NULL,NULL,NULL,'09 Sep 2024','2024090922:38:57','%','0','40.00','no','0.00',NULL,'202409092238','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'personal care','admin','JP',NULL,NULL,'8903622003218',NULL,'85.00','','','','',NULL,'40.00'),(52,'Boti Colour Fryums 75Rs','0.25','75.00','18.75','Item',NULL,NULL,'no',NULL,NULL,'20240909-000015','10:38:57 PM','2024 09 09','admin','1','  General','  Cash','647.75','647.75','12',NULL,NULL,NULL,NULL,'09 Sep 2024','2024090922:38:57','%','0','18.75','no','0.00',NULL,'202409092238','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','JP',NULL,NULL,'',NULL,'21.25','','','','',NULL,'75.00'),(53,'MTR Puliogare powder 27g','2.0','10.00','20.00','Item',NULL,NULL,'no',NULL,NULL,'20240909-000015','10:38:57 PM','2024 09 09','admin','1','  General','  Cash','647.75','647.75','13',NULL,NULL,NULL,NULL,'09 Sep 2024','2024090922:38:57','%','0','10.00','no','0.00',NULL,'202409092238','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'masalas and spices','admin','JP',NULL,NULL,'8901042970493',NULL,'170.00','','','','',NULL,'10.00'),(54,'Germi Bleaching Powder 200g','1.0','24.00','24.00','Item',NULL,NULL,'no',NULL,NULL,'20240909-000015','10:38:57 PM','2024 09 09','admin','1','  General','  Cash','647.75','647.75','14',NULL,NULL,NULL,NULL,'09 Sep 2024','2024090922:38:57','%','0','24.00','no','0.00',NULL,'202409092238','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'household','admin','JP',NULL,NULL,'8906017242988',NULL,'85.00','','','','',NULL,'24.00'),(55,'GTS Bullet Rice 85Rs per Kg','5.0','85.00','425.00','Item',NULL,NULL,'no',NULL,NULL,'20240909-000015','10:38:57 PM','2024 09 09','admin','1','  General','  Cash','647.75','647.75','15',NULL,NULL,NULL,NULL,'09 Sep 2024','2024090922:38:57','%','0','425.00','no','0.00',NULL,'202409092238','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','JP',NULL,NULL,'',NULL,'425.00','','','','',NULL,'85.00'),(56,'Diamond ABCD 5Rs ','2.0','5.00','10.00','Item',NULL,NULL,'no',NULL,NULL,'20240909-000016','10:40:41 PM','2024 09 09','admin','1','  General','  Upiqr','75.00','75.00','16',NULL,NULL,NULL,NULL,'09 Sep 2024','2024090922:40:41','%','0','10.00','no','0.00',NULL,'202409092240','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','JP','0',NULL,'725765454997',NULL,'30.00','','','','',NULL,'5.00'),(57,'Kurkure naughty Tomato 5Rs','1.0','5.00','5.00','Item',NULL,NULL,'no',NULL,NULL,'20240909-000016','10:40:41 PM','2024 09 09','admin','1','  General','  Upiqr','75.00','75.00','17',NULL,NULL,NULL,NULL,'09 Sep 2024','2024090922:40:41','%','0','5.00','no','0.00',NULL,'202409092240','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'household','admin','JP','0',NULL,'8901491104470',NULL,'15.00','','','','',NULL,'5.00'),(58,'Haldirams Bhel','1.0','10.00','10.00','Item',NULL,NULL,'no',NULL,NULL,'20240909-000016','10:40:41 PM','2024 09 09','admin','1','  General','  Upiqr','75.00','75.00','18',NULL,NULL,NULL,NULL,'09 Sep 2024','2024090922:40:41','%','0','10.00','no','0.00',NULL,'202409092240','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'household','admin','JP','0',NULL,'8904004409222',NULL,'15.00','','','','',NULL,'10.00'),(59,'Yippee Noodles 70g','2.0','15.00','30.00','Item',NULL,NULL,'no',NULL,NULL,'20240909-000016','10:40:41 PM','2024 09 09','admin','1','  General','  Upiqr','75.00','75.00','19',NULL,NULL,NULL,NULL,'09 Sep 2024','2024090922:40:41','%','0','15.00','no','0.00',NULL,'202409092240','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'household','admin','JP','0',NULL,'8901725005993',NULL,'30.00','','','','',NULL,'15.00'),(60,'Tide Jasmine n rose 10Rs','2.0','10.00','20.00','Item',NULL,NULL,'no',NULL,NULL,'20240909-000016','10:40:41 PM','2024 09 09','admin','1','  General','  Upiqr','75.00','75.00','20',NULL,NULL,NULL,NULL,'09 Sep 2024','2024090922:40:41','%','0','20.00','no','0.00',NULL,'202409092240','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','JP','0',NULL,'4987176167064',NULL,'20.00','','','','',NULL,'10.00'),(61,'ID Chapathi 400g','1.0','79.00','79.00','Item',NULL,NULL,'no',NULL,NULL,'20240909-000017','10:54:29 PM','2024 09 09','admin','1','  General','  Cash','79.00','79.00','21',NULL,NULL,NULL,NULL,'09 Sep 2024','2024090922:54:29','%','0','79.00','no','0.00',NULL,'202409092254','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'household','admin','JP',NULL,NULL,'8906020580138',NULL,'79.00','','','','',NULL,'79.00'),(62,'Kelloggs Corn Flakes Strawberry 10rs','2.0','10.00','20.00','Item',NULL,NULL,'no',NULL,NULL,'20240910-000011','08:09:17 AM','2024 09 10','admin','1','  General','  Cash','331.50','331.50','22',NULL,NULL,NULL,NULL,'10 Sep 2024','2024091008:09:17','%','0','20.00','no','0.00',NULL,'202409100809','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'bread bakery and eggs','admin','JP',NULL,NULL,'8901499011039',NULL,'4.00','','','','',NULL,'10.00'),(63,'Chocos 10Rs pack','2.0','10.00','20.00','Item',NULL,NULL,'no',NULL,NULL,'20240910-000011','08:09:17 AM','2024 09 10','admin','1','  General','  Cash','331.50','331.50','23',NULL,NULL,NULL,NULL,'10 Sep 2024','2024091008:09:17','%','0','20.00','no','0.00',NULL,'202409100809','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','JP',NULL,NULL,'8901499008169',NULL,'4.00','','','','',NULL,'10.00'),(64,'EGG per pc 6.50 Rs','31','6.50','201.50','Item',NULL,NULL,'no',NULL,NULL,'20240910-000011','08:09:17 AM','2024 09 10','admin','1','  General','  Cash','331.50','331.50','24',NULL,NULL,NULL,NULL,'10 Sep 2024','2024091008:09:17','%','0','6.50','no','0.00',NULL,'202409100809','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','JP',NULL,NULL,'',NULL,'62.00','','','','',NULL,'6.50'),(65,'Dove Shampoo','5','2.00','10.00','Item',NULL,NULL,'no',NULL,NULL,'20240910-000011','08:09:17 AM','2024 09 10','admin','1','  General','  Cash','331.50','331.50','25',NULL,NULL,NULL,NULL,'10 Sep 2024','2024091008:09:17','%','0','2.00','no','0.00',NULL,'202409100809','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'personal care','admin','JP',NULL,NULL,'8901030899768',NULL,'10.00','','','','',NULL,'2.00'),(66,'Britannia Good day cashew 10Rs','2.0','10.00','20.00','Item',NULL,NULL,'no',NULL,NULL,'20240910-000011','08:09:17 AM','2024 09 10','admin','1','  General','  Cash','331.50','331.50','26',NULL,NULL,NULL,NULL,'10 Sep 2024','2024091008:09:17','%','0','10.00','no','0.00',NULL,'202409100809','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','JP',NULL,NULL,'8901063093522',NULL,'4.00','','','','',NULL,'10.00'),(67,'Sunrise 2Rs','24','2.00','48.00','Item',NULL,NULL,'no',NULL,NULL,'20240910-000011','08:09:17 AM','2024 09 10','admin','1','  General','  Cash','331.50','331.50','27',NULL,NULL,NULL,NULL,'10 Sep 2024','2024091008:09:17','%','0','2.00','no','0.00',NULL,'202409100809','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','JP',NULL,NULL,'89080221',NULL,'48.00','','','','',NULL,'2.00'),(68,'Curd 250 ml','1.0','12.00','12.00','Item',NULL,NULL,'no',NULL,NULL,'20240910-000011','08:09:17 AM','2024 09 10','admin','1','  General','  Cash','331.50','331.50','28',NULL,NULL,NULL,NULL,'10 Sep 2024','2024091008:09:17','%','0','12.00','no','0.00',NULL,'202409100809','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','JP',NULL,NULL,'',NULL,'12.00','','','','',NULL,'12.00'),(69,'Lotte lollies blueberry','1.0','5.00','5.00','Item',NULL,NULL,'no',NULL,NULL,'20240910-000012','01:28:26 PM','2024 09 10','admin','1','  General','  Cash','15.00','15.00','29',NULL,NULL,NULL,NULL,'10 Sep 2024','2024091013:28:26','%','0','5.00','no','0.00',NULL,'202409101328','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'bread bakery and eggs','admin','JP',NULL,NULL,'8901123001528',NULL,'5.00','','','','',NULL,'5.00'),(70,'Lotte Jellies ','1.0','10.00','10.00','Item',NULL,NULL,'no',NULL,NULL,'20240910-000012','01:28:26 PM','2024 09 10','admin','1','  General','  Cash','15.00','15.00','30',NULL,NULL,NULL,NULL,'10 Sep 2024','2024091013:28:26','%','0','10.00','no','0.00',NULL,'202409101328','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'bread bakery and eggs','admin','JP',NULL,NULL,'8901123000439',NULL,'10.00','','','','',NULL,'10.00'),(71,'Bhagyalakshmi Ragi Flour 1kg','1.0','76.00','76.00','Item',NULL,NULL,'no',NULL,NULL,'20240911-000011','07:18:14 PM','2024 09 11','admin','1','  General','  Cash','146.00','146.00','3',NULL,NULL,NULL,NULL,'11 Sep 2024','2024091119:18:14','%','0','76.00','no','0.00',NULL,'202409111918','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'flours and sooji','admin','JP',NULL,NULL,'8906121341065',NULL,'76.00','','','','',NULL,'76.00'),(72,'Aashirvaad atta 1kg','1.0','70.00','70.00','Item',NULL,NULL,'no',NULL,NULL,'20240911-000011','07:18:14 PM','2024 09 11','admin','1','  General','  Cash','146.00','146.00','4',NULL,NULL,NULL,NULL,'11 Sep 2024','2024091119:18:14','%','0','70.00','no','0.00',NULL,'202409111918','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'household','admin','JP',NULL,NULL,'8901725121747',NULL,'70.00','','','','',NULL,'70.00'),(73,'Yippee Noodles 70g','1.0','15.00','15.00','Item',NULL,NULL,'no',NULL,NULL,'20240912-000011','08:05:05 PM','2024 09 12','admin','1','  General','  Cash','43.00','43.00','5',NULL,NULL,NULL,NULL,'12 Sep 2024','2024091220:05:05','%','0','15.00','no','0.00',NULL,'202409122005','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'household','admin','JP',NULL,NULL,'8901725005993',NULL,'15.00','','','','',NULL,'15.00'),(74,'maggi 70gm','2.0','14.00','28.00','Item',NULL,NULL,'no',NULL,NULL,'20240912-000011','08:05:05 PM','2024 09 12','admin','1','  General','  Cash','43.00','43.00','6',NULL,NULL,NULL,NULL,'12 Sep 2024','2024091220:05:05','%','0','28.00','no','0.00',NULL,'202409122005','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','JP',NULL,NULL,'8901058000290',NULL,'28.00','','','','',NULL,'14.00'),(75,'bhagyalakshmi chakki atta 1kg','2.0','60.00','120.00','Item',NULL,NULL,'no',NULL,NULL,'20240914-000011','09:31:01 AM','2024 09 14','admin','1','  General','  Cash','275.00','275.00','2',NULL,NULL,NULL,NULL,'14 Sep 2024','2024091409:31:01','%','0','60.00','no','0.00',NULL,'202409140931','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'household','admin','JP',NULL,NULL,'8908013841172',NULL,'13.00','','','','',NULL,'60.00'),(76,'Bhagyalaksmi Bansi Suji 500g','2.0','35.00','70.00','Item',NULL,NULL,'no',NULL,NULL,'20240914-000011','09:31:01 AM','2024 09 14','admin','1','  General','  Cash','275.00','275.00','3',NULL,NULL,NULL,NULL,'14 Sep 2024','2024091409:31:01','%','0','35.00','no','0.00',NULL,'202409140931','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'flours and sooji','admin','JP',NULL,NULL,'8901869197240',NULL,'13.00','','','','',NULL,'35.00'),(77,'Kurkure Masala munch 10Rs','1.0','10.00','10.00','Item',NULL,NULL,'no',NULL,NULL,'20240914-000011','09:31:01 AM','2024 09 14','admin','1','  General','  Cash','275.00','275.00','4',NULL,NULL,NULL,NULL,'14 Sep 2024','2024091409:31:01','%','0','10.00','no','0.00',NULL,'202409140931','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'household','admin','JP',NULL,NULL,'8901491361026',NULL,'6.50','','','','',NULL,'10.00'),(78,'TATA SOULFULL RAGI BITES CHOCO','1.0','10.00','10.00','Item',NULL,NULL,'no',NULL,NULL,'20240914-000011','09:31:01 AM','2024 09 14','admin','1','  General','  Cash','275.00','275.00','5',NULL,NULL,NULL,NULL,'14 Sep 2024','2024091409:31:01','%','0','10.00','no','0.00',NULL,'202409140931','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'bread bakery and eggs','admin','JP',NULL,NULL,'8906113490719',NULL,'6.50','','','','',NULL,'10.00'),(79,'EGG per pc 6.50 Rs','10','6.50','65.00','Item',NULL,NULL,'no',NULL,NULL,'20240914-000011','09:31:01 AM','2024 09 14','admin','1','  General','  Cash','275.00','275.00','6',NULL,NULL,NULL,NULL,'14 Sep 2024','2024091409:31:01','%','0','6.50','no','0.00',NULL,'202409140931','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','JP',NULL,NULL,'',NULL,'65.00','','','','',NULL,'6.50');
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,'20240810-000011','267.00','admin','2024 08 10','  Cash','  General','267.00','0.00','0.00','0.0','1','202408101342',NULL,NULL,NULL,NULL,NULL,NULL),(2,'20240810-000012','30.00','admin','2024 08 10','  Upiqr','  General','30.00','0.00','0.00','0.0','2','202408101405',NULL,NULL,NULL,NULL,NULL,NULL),(3,'20240812-000011','59.00','admin','2024 08 12','  Cash','  General','59.00','0.00','0.00','0.0','3','202408122205',NULL,NULL,NULL,NULL,NULL,NULL),(4,'20240812-000012','59.00','admin','2024 08 12','  Cash','  General','59.00','0.00','0.00','0.0','4','202408122205',NULL,NULL,NULL,NULL,NULL,NULL),(5,'20240812-000013','59.00','admin','2024 08 12','  Cash','  General','59.00','0.00','0.00','0.0','5','202408122206',NULL,NULL,NULL,NULL,NULL,NULL),(6,'20240829-000011','5.00','admin','2024 08 29','  Upiqr','  General','5.00','0.00','0.00','0.0','6','202408292352',NULL,NULL,NULL,NULL,NULL,NULL),(7,'20240830-000011','5.00','admin','2024 08 30','  Cash','  General','5.00','0.00','0.00','0.0','7','202408302333',NULL,NULL,NULL,NULL,NULL,NULL),(8,'20240901-000011','10.00','admin','2024 09 01','  Cash','  General','10.00','0.00','0.00','0.0','8','202409010021',NULL,NULL,NULL,NULL,NULL,NULL),(9,'20240902-000011','10.00','admin','2024 09 02','  Cash','  General','10.00','0.00','0.00','0.0','9','202409020121',NULL,NULL,NULL,NULL,NULL,NULL),(10,'20240904-000011','960.00','admin','2024 09 04','  Cash','  General','960.00','0.00','0.00','0.0','10','202409040037',NULL,NULL,NULL,NULL,NULL,NULL),(11,'20240905-000011','10.00','admin','2024 09 05','  Cash','  General','10.00','0.00','0.00','0.0','11','202409050216',NULL,NULL,NULL,NULL,NULL,NULL),(12,'20240905-000012','120.00','admin','2024 09 05','  Cash','  General','120.00','0.00','0.00','0.0','12','202409051035',NULL,NULL,NULL,NULL,NULL,NULL),(13,'20240905-000013','30.00','admin','2024 09 05','  Cash','  General','30.00','0.00','0.00','0.0','13','202409052120',NULL,NULL,NULL,NULL,NULL,NULL),(14,'20240906-000011','36.00','admin','2024 09 06','  Cash','  General','36.00','0.00','0.00','0.0','14','202409060935',NULL,NULL,NULL,NULL,NULL,NULL),(15,'20240906-000012','10.00','admin','2024 09 06','  Cash','  General','10.00','0.00','0.00','0.0','15','202409061415',NULL,NULL,NULL,NULL,NULL,NULL),(16,'20240907-000011','510.00','admin','2024 09 07','  Cash','  General','510.00','0.00','0.00','0.0','16','202409070828',NULL,NULL,NULL,NULL,NULL,NULL),(17,'20240907-000012','162.00','admin','2024 09 07','  Cash','  General','162.00','0.00','0.00','0.0','17','202409070843',NULL,NULL,NULL,NULL,NULL,NULL),(18,'20240908-000011','5100.00','admin','2024 09 08','  Cash','  General','5100.00','0.00','0.00','0.0','18','202409080806',NULL,NULL,NULL,NULL,NULL,NULL),(19,'20240908-000012','10.00','admin','2024 09 08','  Cash','  General','10.00','0.00','0.00','0.0','19','202409080911',NULL,NULL,NULL,NULL,NULL,NULL),(20,'20240908-000013','47.00','admin','2024 09 08','  Cash','  General','47.00','0.00','0.00','0.0','20','202409080933',NULL,NULL,NULL,NULL,NULL,NULL),(21,'20240908-000014','180.00','admin','2024 09 08','  Cash','  General','180.00','0.00','0.00','0.0','21','202409081028',NULL,NULL,NULL,NULL,NULL,NULL),(22,'20240908-000015','76.00','admin','2024 09 08','  Cash','  General','76.00','0.00','0.00','0.0','22','202409081103',NULL,NULL,NULL,NULL,NULL,NULL),(23,'20240908-000016','50.00','admin','2024 09 08','  Cash','  General','50.00','0.00','0.00','0.0','23','202409081135',NULL,NULL,NULL,NULL,NULL,NULL),(24,'20240908-000017','30.00','admin','2024 09 08','  Cash','  General','30.00','0.00','0.00','0.0','24','202409081556',NULL,NULL,NULL,NULL,NULL,NULL),(25,'20240908-000018','225.00','admin','2024 09 08','  Cash','  General','225.00','0.00','0.00','0.0','25','202409082203',NULL,NULL,NULL,NULL,NULL,NULL),(26,'20240909-000011','124.00','admin','2024 09 09','  Cash','  General','124.00','0.00','0.00','0.0','26','202409090725',NULL,NULL,NULL,NULL,NULL,NULL),(27,'20240909-000012','54.00','admin','2024 09 09','  Cash','  General','54.00','0.00','0.00','0.0','27','202409092055',NULL,NULL,NULL,NULL,NULL,NULL),(28,'20240909-000013','30.00','admin','2024 09 09','  Cash','  General','30.00','0.00','0.00','0.0','28','202409092104',NULL,NULL,NULL,NULL,NULL,NULL),(29,'20240909-000014','84.00','admin','2024 09 09','  Cash','  General','84.00','0.00','0.00','0.0','29','202409092107',NULL,NULL,NULL,NULL,NULL,NULL),(30,'20240909-000015','647.75','admin','2024 09 09','  Cash','  General','647.75','0.00','0.00','0.0','30','202409092238',NULL,NULL,NULL,NULL,NULL,NULL),(31,'20240909-000016','75.00','admin','2024 09 09','  Upiqr','  General','75.00','0.00','0.00','0.0','31','202409092240',NULL,NULL,NULL,NULL,NULL,NULL),(32,'20240909-000017','79.00','admin','2024 09 09','  Cash','  General','79.00','0.00','0.00','0.0','32','202409092254',NULL,NULL,NULL,NULL,NULL,NULL),(33,'20240910-000011','331.50','admin','2024 09 10','  Cash','  General','331.50','0.00','0.00','0.0','33','202409100809',NULL,NULL,NULL,NULL,NULL,NULL),(34,'20240910-000012','15.00','admin','2024 09 10','  Cash','  General','15.00','0.00','0.00','0.0','34','202409101328',NULL,NULL,NULL,NULL,NULL,NULL),(35,'20240911-000011','146.00','admin','2024 09 11','  Cash','  General','146.00','0.00','0.00','0.0','35','202409111918',NULL,NULL,NULL,NULL,NULL,NULL),(36,'20240912-000011','43.00','admin','2024 09 12','  Cash','  General','43.00','0.00','0.00','0.0','36','202409122005',NULL,NULL,NULL,NULL,NULL,NULL),(37,'20240914-000011','275.00','admin','2024 09 14','  Cash','  General','275.00','0.00','0.00','0.0','37','202409140931',NULL,NULL,NULL,NULL,NULL,NULL);
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 (5,'Homee','9008407892','','',10,'0.0',NULL,NULL,NULL);
INSERT INTO `expenses_sales` (`_id`, `expensename`, `price`, `category`, `counterperson_username`, `counterperson_name`, `date`, `time`, `datetimee_new`) VALUES (1,'Transportation charges for purchasing goods from RMC','1000','Transportation','madmin','madmin','31 August 2024','05:08 PM','202408310508'),(2,'Transportation charges for purchasing goods from RMC','1000','Transportation','madmin','madmin','31 August 2024','05:08 PM','202408310508'),(3,'Transportation charges for purchasing items from RMC, Yeshwanthpur','1000','Transportation','madmin','madmin','31 August 2024','05:08 PM','202408310508'),(4,'Transportation charges for purchasing items from RMC, Yeshwanthpur','1000','Transportation','madmin','madmin','31 August 2024','05:08 PM','202408310508');
INSERT INTO `itemdata` (`_id`, `itemname`, `total`) VALUES (1,'Brit Jimjam Naughty Jam 10Rs',10),(2,'Sunpure Oil 1Ltr ',120);
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,'1961','Brit Jimjam Naughty Jam 10Rs',10,100,'1','bread bakery and eggs',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(2,'2024','Sunpure Oil 1Ltr ',120,92,'1','edible oils and ghee',NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO `top_category` (`_id`, `category`, `value`) VALUES (1,'bread bakery and eggs',10),(2,'bread bakery and eggs',10),(3,'edible oils and ghee',120),(4,'household',10);
INSERT INTO `userdata` (`_id`, `username`, `total`) VALUES (1,'admin',10);
INSERT INTO `userwiseorderlistitems` (`_id`, `username`, `sales`, `salespercentage`) VALUES (1,'JP',10,100);
