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','1.0','56.00','56.00','Item',NULL,NULL,'no',NULL,NULL,'20240711-000011','12:14:48 pm','2024 07 11','admin','1','  General','  Cash','754.00','754.00','1',NULL,NULL,NULL,NULL,'11 Jul 2024','2024071112:14:48','%','0','56.00','no','0.00',NULL,'202407111214','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'rice whole grains','admin','madmin',NULL,NULL,'',NULL,'56.00','','','','',NULL,'56.00'),(2,'tata urad dal whole white 1kg','1.0','250.00','250.00','Item',NULL,NULL,'no',NULL,NULL,'20240711-000011','12:14:48 pm','2024 07 11','admin','1','  General','  Cash','754.00','754.00','2',NULL,NULL,NULL,NULL,'11 Jul 2024','2024071112:14:48','%','0','250.00','no','0.00',NULL,'202407111214','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'dals pulses','admin','madmin',NULL,NULL,'',NULL,'250.00','','','','',NULL,'250.00'),(3,'nutella','1.0','170.00','170.00','Item',NULL,NULL,'no',NULL,NULL,'20240711-000011','12:14:48 pm','2024 07 11','admin','1','  General','  Cash','754.00','754.00','3',NULL,NULL,NULL,NULL,'11 Jul 2024','2024071112:14:48','%','0','170.00','no','0.00',NULL,'202407111214','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'branded foods','admin','madmin',NULL,NULL,'',NULL,'170.00','','','','',NULL,'170.00'),(4,'fig fruit kg','1.0','250.00','250.00','Item',NULL,NULL,'no',NULL,NULL,'20240711-000011','12:14:48 pm','2024 07 11','admin','1','  General','  Cash','754.00','754.00','4',NULL,NULL,NULL,NULL,'11 Jul 2024','2024071112:14:48','%','0','250.00','no','0.00',NULL,'202407111214','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','admin','madmin',NULL,NULL,'',NULL,'250.00','','','','',NULL,'250.00'),(5,'ladies finger kg','1.0','28.00','28.00','Item',NULL,NULL,'no',NULL,NULL,'20240711-000011','12:14:48 pm','2024 07 11','admin','1','  General','  Cash','754.00','754.00','5',NULL,NULL,NULL,NULL,'11 Jul 2024','2024071112:14:48','%','0','28.00','no','0.00',NULL,'202407111214','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','admin','madmin',NULL,NULL,'',NULL,'28.00','','','','',NULL,'28.00'),(6,'kurties set ','2.0','1500.00','3000.00','Item',NULL,NULL,'no',NULL,NULL,'20240711-000012','12:23:29 pm','2024 07 11','admin','1','  General','  Cash','3000.00','3000.00','6',NULL,NULL,NULL,NULL,'11 Jul 2024','2024071112:23:29','%','0','3000.00','no','0.00',NULL,'202407111223','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Adults','admin','madmin',NULL,NULL,'',NULL,'3000.00','','','','',NULL,'1500.00'),(7,'urad black whole 500g','1.0','108.00','108.00','Item',NULL,NULL,'no',NULL,NULL,'20240711-000013','12:56:04 pm','2024 07 11','admin','1','  General','  Cash','612.00','612.00','7',NULL,NULL,NULL,NULL,'11 Jul 2024','2024071112:56:04','%','0','108.00','no','0.00',NULL,'202407111256','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'dals and pulses','admin','madmin',NULL,NULL,'',NULL,'108.00','','','','',NULL,'108.00'),(8,'urad dal split 2kg','1.0','394.00','394.00','Item',NULL,NULL,'no',NULL,NULL,'20240711-000013','12:56:04 pm','2024 07 11','admin','1','  General','  Cash','612.00','612.00','8',NULL,NULL,NULL,NULL,'11 Jul 2024','2024071112:56:04','%','0','394.00','no','0.00',NULL,'202407111256','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'dals and pulses','admin','madmin',NULL,NULL,'',NULL,'394.00','','','','',NULL,'394.00'),(9,'urad black split 500g','1.0','110.00','110.00','Item',NULL,NULL,'no',NULL,NULL,'20240711-000013','12:56:04 pm','2024 07 11','admin','1','  General','  Cash','612.00','612.00','9',NULL,NULL,NULL,NULL,'11 Jul 2024','2024071112:56:04','%','0','110.00','no','0.00',NULL,'202407111256','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'dals and pulses','admin','madmin',NULL,NULL,'',NULL,'110.00','','','','',NULL,'110.00'),(10,'sona masoori raw rice 1kg','1.0','56.00','56.00','Item',NULL,NULL,'no',NULL,NULL,'20240712-000011','11:53:48 am','2024 07 12','admin','1','  General','  Cash','799.00','799.00','10',NULL,NULL,NULL,NULL,'12 Jul 2024','2024071211:53:48','%','0','56.00','no','0.00',NULL,'202407121153','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'rice whole grains','admin','madmin',NULL,NULL,'',NULL,'56.00','','','','',NULL,'56.00'),(11,'tata urad dal whole white 1kg','1.0','250.00','250.00','Item',NULL,NULL,'no',NULL,NULL,'20240712-000011','11:53:48 am','2024 07 12','admin','1','  General','  Cash','799.00','799.00','11',NULL,NULL,NULL,NULL,'12 Jul 2024','2024071211:53:48','%','0','250.00','no','0.00',NULL,'202407121153','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'dals pulses','admin','madmin',NULL,NULL,'',NULL,'250.00','','','','',NULL,'250.00'),(12,'urad gota whole 500g','1.0','99.00','99.00','Item',NULL,NULL,'no',NULL,NULL,'20240712-000011','11:53:48 am','2024 07 12','admin','1','  General','  Cash','799.00','799.00','12',NULL,NULL,NULL,NULL,'12 Jul 2024','2024071211:53:48','%','0','99.00','no','0.00',NULL,'202407121153','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'dals and pulses','admin','madmin',NULL,NULL,'',NULL,'99.00','','','','',NULL,'99.00'),(13,'urad dal split 2kg','1.0','394.00','394.00','Item',NULL,NULL,'no',NULL,NULL,'20240712-000011','11:53:48 am','2024 07 12','admin','1','  General','  Cash','799.00','799.00','13',NULL,NULL,NULL,NULL,'12 Jul 2024','2024071211:53:48','%','0','394.00','no','0.00',NULL,'202407121153','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'dals and pulses','admin','madmin',NULL,NULL,'',NULL,'394.00','','','','',NULL,'394.00'),(14,'sona masoori raw rice 1kg','1.0','56.00','56.00','Item',NULL,NULL,'no',NULL,NULL,'20240712-000012','11:54:18 am','2024 07 12','admin','1','  General','  Cash','799.00','799.00','14',NULL,NULL,NULL,NULL,'12 Jul 2024','2024071211:54:18','%','0','56.00','no','0.00',NULL,'202407121154','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'rice whole grains','admin','madmin',NULL,NULL,'',NULL,'56.00','','','','',NULL,'56.00'),(15,'tata urad dal whole white 1kg','1.0','250.00','250.00','Item',NULL,NULL,'no',NULL,NULL,'20240712-000012','11:54:18 am','2024 07 12','admin','1','  General','  Cash','799.00','799.00','15',NULL,NULL,NULL,NULL,'12 Jul 2024','2024071211:54:18','%','0','250.00','no','0.00',NULL,'202407121154','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'dals pulses','admin','madmin',NULL,NULL,'',NULL,'250.00','','','','',NULL,'250.00'),(16,'urad gota whole 500g','1.0','99.00','99.00','Item',NULL,NULL,'no',NULL,NULL,'20240712-000012','11:54:18 am','2024 07 12','admin','1','  General','  Cash','799.00','799.00','16',NULL,NULL,NULL,NULL,'12 Jul 2024','2024071211:54:18','%','0','99.00','no','0.00',NULL,'202407121154','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'dals and pulses','admin','madmin',NULL,NULL,'',NULL,'99.00','','','','',NULL,'99.00'),(17,'urad dal split 2kg','1.0','394.00','394.00','Item',NULL,NULL,'no',NULL,NULL,'20240712-000012','11:54:18 am','2024 07 12','admin','1','  General','  Cash','799.00','799.00','17',NULL,NULL,NULL,NULL,'12 Jul 2024','2024071211:54:18','%','0','394.00','no','0.00',NULL,'202407121154','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'dals and pulses','admin','madmin',NULL,NULL,'',NULL,'394.00','','','','',NULL,'394.00'),(18,'Test scan ','1.0','200.00','200.00','Item',NULL,NULL,'no',NULL,NULL,'20240715-000011','12:11:23 pm','2024 07 15','admin','1','  General','  Card','200.00','200.00','18',NULL,NULL,NULL,NULL,'15 Jul 2024','2024071512:11:23','%','0','200.00','no','0.00',NULL,'202407151211','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'kids','admin','madmin','0',NULL,'1603',NULL,'200.00','','','','',NULL,'200.00'),(19,'Afresh Energy Drink Mix Peach 50g','2.0','1442','2884.00','Item',NULL,NULL,'no','5','Cgst(5%)','20240719-000011','03:15:36 pm','2024 07 19','admin','1','  General','  Cash','2884.00','2884.00','3',NULL,NULL,NULL,NULL,'19 Jul 2024','2024071915:15:36','%','0','3173.50','no','0.00',NULL,'202407191515','','Sgst(5%)','5',NULL,NULL,NULL,NULL,NULL,NULL,'Herbalife ','admin','madmin',NULL,NULL,'',NULL,'5770.00','','','','',NULL,'2885.00'),(20,'Afresh Energy Drink Mix Peach 50g','2.0','3173.50','6347.00','Item',NULL,NULL,'no','5','Cgst(5%)','20240719-000012','03:20:23 pm','2024 07 19','admin','1','  General','  Cash','7690.30','7690.30','4',NULL,NULL,NULL,NULL,'19 Jul 2024','2024071915:20:23','₹','743.40','4860.20','yes','1486.80',NULL,'202407191520','','Sgst(5%)','5',NULL,NULL,NULL,NULL,NULL,NULL,'Herbalife ','admin','madmin',NULL,NULL,'',NULL,'5770.00','','','','',NULL,'2885.00'),(21,'Afresh Energy Drink Mix Tulasi','1.0','3173.50','3173.50','Item',NULL,NULL,'no','5','Cgst(5%)','20240719-000012','03:20:23 pm','2024 07 19','admin','1','  General','  Cash','7690.30','7690.30','5',NULL,NULL,NULL,NULL,'19 Jul 2024','2024071915:20:23','₹','343.40','2830.10','yes','343.40',NULL,'202407191520','','Sgst(5%)','5',NULL,NULL,NULL,NULL,NULL,NULL,'Herbalife ','admin','madmin',NULL,NULL,'',NULL,'2885.00','','','','',NULL,'2885.00'),(22,'Afresh Energy Drink Mix Peach 50g','2.0','1442','2884.00','Item',NULL,NULL,'no','5','Cgst(5%)','20240719-000013','03:26:42 pm','2024 07 19','admin','1','  General','  Cash','3938.80','3938.80','8',NULL,NULL,NULL,NULL,'19 Jul 2024','2024071915:26:42','₹','743.40','1397.20','yes','1486.80',NULL,'202407191526','','Sgst(5%)','5',NULL,NULL,NULL,NULL,NULL,NULL,'Herbalife ','admin','madmin',NULL,NULL,'',NULL,'5770.00','','','','',NULL,'2885.00'),(23,'Afresh Energy Drink Mix Tulasi','1.0','2885','2885.00','Item',NULL,NULL,'no','5','Cgst(5%)','20240719-000013','03:26:42 pm','2024 07 19','admin','1','  General','  Cash','3938.80','3938.80','9',NULL,NULL,NULL,NULL,'19 Jul 2024','2024071915:26:42','₹','343.40','2541.60','yes','343.40',NULL,'202407191526','','Sgst(5%)','5',NULL,NULL,NULL,NULL,NULL,NULL,'Herbalife ','admin','madmin',NULL,NULL,'',NULL,'2885.00','','','','',NULL,'2885.00'),(24,'Afresh Energy Drink Mix Peach 50g','2.0','1442','2884.00','Item',NULL,NULL,'no','5','Cgst(5%)','20240719-000014','03:31:52 pm','2024 07 19','admin','1','  General','  Cash','3938.80','3938.80','10',NULL,NULL,NULL,NULL,'19 Jul 2024','2024071915:31:52','₹','743.40','1397.20','yes','1486.80',NULL,'202407191531','','Sgst(5%)','5',NULL,NULL,NULL,NULL,NULL,NULL,'Herbalife ','admin','madmin',NULL,NULL,'',NULL,'5770.00','','','','',NULL,'2885.00'),(25,'Afresh Energy Drink Mix Tulasi','1.0','2885','2885.00','Item',NULL,NULL,'no','5','Cgst(5%)','20240719-000014','03:31:52 pm','2024 07 19','admin','1','  General','  Cash','3938.80','3938.80','11',NULL,NULL,NULL,NULL,'19 Jul 2024','2024071915:31:52','₹','343.40','2541.60','yes','343.40',NULL,'202407191531','','Sgst(5%)','5',NULL,NULL,NULL,NULL,NULL,NULL,'Herbalife ','admin','madmin',NULL,NULL,'',NULL,'2885.00','','','','',NULL,'2885.00'),(26,'sona masoori raw rice 1kg','1.0','56.00','56.00','Item',NULL,NULL,'no',NULL,NULL,'20240720-000011','11:43:21 am','2024 07 20','admin','1','  General','  Cash','384.00','384.00','12',NULL,NULL,NULL,NULL,'20 Jul 2024','2024072011:43:21','₹','10','46.00','yes','10.00',NULL,'202407201143','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'rice whole grains','admin','madmin',NULL,NULL,'',NULL,'108.00','','','','',NULL,'56.00'),(27,'tata urad dal whole white 1kg','1.0','250.00','250.00','Item',NULL,NULL,'no',NULL,NULL,'20240720-000011','11:43:21 am','2024 07 20','admin','1','  General','  Cash','384.00','384.00','13',NULL,NULL,NULL,NULL,'20 Jul 2024','2024072011:43:21','₹','10','240.00','yes','10.00',NULL,'202407201143','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'dals pulses','admin','madmin',NULL,NULL,'',NULL,'108.00','','','','',NULL,'250.00'),(28,'urad black whole 500g','1.0','108.00','108.00','Item',NULL,NULL,'no',NULL,NULL,'20240720-000011','11:43:21 am','2024 07 20','admin','1','  General','  Cash','384.00','384.00','14',NULL,NULL,NULL,NULL,'20 Jul 2024','2024072011:43:21','₹','10','98.00','yes','10.00',NULL,'202407201143','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'dals and pulses','admin','madmin',NULL,NULL,'',NULL,'108.00','','','','',NULL,'108.00'),(29,'Afresh Lemon','2.0','3463.95','6927.90','Item',NULL,NULL,'no','5','Five(5%)','20240720-000012','12:15:05 pm','2024 07 20','admin','1','  General','  Cash','6927.90','6927.90','15',NULL,NULL,NULL,NULL,'20 Jul 2024','2024072012:15:05','%','0','6927.90','no','0.00',NULL,'202407201215','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Herbalife ','admin','madmin',NULL,NULL,'',NULL,'6598.00','','','','',NULL,'3299.00'),(30,'Afresh Lemon','1.0','3463.95','3463.95','Item',NULL,NULL,'no','5','Five(5%)','20240720-000013','12:16:21 pm','2024 07 20','admin','1','  General','  Cash','3463.95','3463.95','16',NULL,NULL,NULL,NULL,'20 Jul 2024','2024072012:16:21','%','0','3463.95','no','0.00',NULL,'202407201216','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Herbalife ','admin','madmin',NULL,NULL,'',NULL,'3299.00','','','','',NULL,'3299.00'),(31,'Afresh Lemon','1.0','3463.95','3463.95','Item',NULL,NULL,'no','5','Five(5%)','20240720-000014','12:17:50 pm','2024 07 20','admin','1','  General','  Cash','10299.45','10299.45','17',NULL,NULL,NULL,NULL,'20 Jul 2024','2024072012:17:50','%','0','3463.95','no','0.00',NULL,'202407201217','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Herbalife ','admin','madmin',NULL,NULL,'',NULL,'3299.00','','','','',NULL,'3299.00'),(32,'Afresh Energy Drink Mix Peach 50g','1.00','3029.25','3029.25','Item',NULL,NULL,'no','5','Five(5%)','20240720-000014','12:17:50 pm','2024 07 20','admin','1','  General','  Cash','10299.45','10299.45','18',NULL,NULL,NULL,NULL,'20 Jul 2024','2024072012:17:50','%','0','3029.25','no','0.00',NULL,'202407201217','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Herbalife ','admin','madmin',NULL,NULL,'',NULL,'2885.00','','','','',NULL,'2885.00'),(33,'Afresh Energy Drink Mix Tulasi','1.00','3029.25','3029.25','Item',NULL,NULL,'no','5','Five(5%)','20240720-000014','12:17:50 pm','2024 07 20','admin','1','  General','  Cash','10299.45','10299.45','19',NULL,NULL,NULL,NULL,'20 Jul 2024','2024072012:17:50','%','0','3029.25','no','0.00',NULL,'202407201217','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Herbalife ','admin','madmin',NULL,NULL,'',NULL,'2885.00','','','','',NULL,'2885.00'),(34,'Dino shake ','1.00','777.00','777.00','Item',NULL,NULL,'no','5','Five(5%)','20240720-000014','12:17:50 pm','2024 07 20','admin','1','  General','  Cash','10299.45','10299.45','20',NULL,NULL,NULL,NULL,'20 Jul 2024','2024072012:17:50','%','0','777.00','no','0.00',NULL,'202407201217','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Herbalife ','admin','madmin',NULL,NULL,'',NULL,'740.00','','','','',NULL,'740.00'),(35,'Afresh Lemon','1.0','3463.95','3463.95','Item',NULL,NULL,'no','5','Five(5%)','20240722-000011','11:26:18 am','2024 07 22','admin','1','  General','  Cash','7270.20','7270.20','21',NULL,NULL,NULL,NULL,'22 Jul 2024','2024072211:26:18','%','0','3463.95','no','0.00',NULL,'202407221126','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Herbalife ','admin','madmin',NULL,NULL,'',NULL,'3299.00','','','','',NULL,'3299.00'),(36,'Afresh Energy Drink Mix Peach 50g','1.00','3029.25','3029.25','Item',NULL,NULL,'no','5','Five(5%)','20240722-000011','11:26:18 am','2024 07 22','admin','1','  General','  Cash','7270.20','7270.20','22',NULL,NULL,NULL,NULL,'22 Jul 2024','2024072211:26:18','%','0','3029.25','no','0.00',NULL,'202407221126','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Herbalife ','admin','madmin',NULL,NULL,'',NULL,'2885.00','','','','',NULL,'2885.00'),(37,'Dino shake ','1.00','777.00','777.00','Item',NULL,NULL,'no','5','Five(5%)','20240722-000011','11:26:18 am','2024 07 22','admin','1','  General','  Cash','7270.20','7270.20','23',NULL,NULL,NULL,NULL,'22 Jul 2024','2024072211:26:18','%','0','777.00','no','0.00',NULL,'202407221126','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Herbalife ','admin','madmin',NULL,NULL,'',NULL,'740.00','','','','',NULL,'740.00'),(38,'Afresh Energy Drink Mix Peach 50g','2','885.00','1770','Item','null','null','no','','','20240722-000012','12:47:46 PM','2024 07 22','madmin','1','  General','  cash','0','0','1612','null','null','null','null','22Jul24','2024072212:47:46','currency','743.40','','','','test','2024072212:47:46','','','','','','','','','','Herbalife ','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(39,'Afresh Energy Drink  Mix Tulasi','1','885.00','885','Item','null','null','no','','','20240722-000012','12:47:46 PM','2024 07 22','madmin','1','  General','  cash','0','0','1609','null','null','null','null','22Jul24','2024072212:47:46','currency','343.40','','','','test','2024072212:47:46','','','','','','','','','','HERBALIFE','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(40,'Delivery Charges ','1.0','100.00','100.00','Item',NULL,NULL,'no',NULL,NULL,'20240722-000012','04:46:09 pm','2024 07 22','admin','1','  General','  Cash','1341.72','1490.80','26',NULL,NULL,NULL,NULL,'22 Jul 2024','2024072216:46:09','%','0','100.00','no','0.00',NULL,'202407221646','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Herbalife ','admin','madmin',NULL,NULL,'',NULL,'850.96','','','','',NULL,'100.00'),(41,'sona masoori raw rice 1kg','1.0','56.00','56.00','Item',NULL,NULL,'no',NULL,NULL,'20240722-000012','04:46:09 pm','2024 07 22','admin','1','  General','  Cash','1341.72','1490.80','27',NULL,NULL,NULL,NULL,'22 Jul 2024','2024072216:46:09','%','0','56.00','no','0.00',NULL,'202407221646','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'rice whole grains','admin','madmin',NULL,NULL,'',NULL,'56.00','','','','',NULL,'56.00'),(42,'tortillas','1.0','70.00','70.00','Item',NULL,NULL,'no',NULL,NULL,'20240722-000012','04:46:09 pm','2024 07 22','admin','1','  General','  Cash','1341.72','1490.80','28',NULL,NULL,NULL,NULL,'22 Jul 2024','2024072216:46:09','%','0','70.00','no','0.00',NULL,'202407221646','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'',NULL,'70.00','','','','',NULL,'70.00'),(43,'fish sticks','1.0','40.00','40.00','Item',NULL,NULL,'no',NULL,NULL,'20240722-000012','04:46:09 pm','2024 07 22','admin','1','  General','  Cash','1341.72','1490.80','29',NULL,NULL,NULL,NULL,'22 Jul 2024','2024072216:46:09','%','0','40.00','no','0.00',NULL,'202407221646','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'',NULL,'40.00','','','','',NULL,'40.00'),(44,'Afresh Peach ','1.0','885.00','885.00','Item',NULL,NULL,'no','4','FOUR PERCENT(4%)','20240724-000011','05:30:14 pm','2024 07 24','admin','1','  General','  Cash','1870.00','1870.00','30',NULL,NULL,NULL,NULL,'24 Jul 2024','2024072417:30:14','%','0','885.00','no','0.00',NULL,'202407241730','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Herbalife ','admin','madmin',NULL,NULL,'',NULL,'850.96','','','','',NULL,'850.96'),(45,'Delivery Charges ','1.0','100.00','100.00','Item',NULL,NULL,'no',NULL,NULL,'20240724-000011','05:30:14 pm','2024 07 24','admin','1','  General','  Cash','1870.00','1870.00','31',NULL,NULL,NULL,NULL,'24 Jul 2024','2024072417:30:14','%','0','100.00','no','0.00',NULL,'202407241730','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Herbalife ','admin','madmin',NULL,NULL,'',NULL,'100.00','','','','',NULL,'100.00'),(46,'Afresh Tulasi ','1.0','885.00','885.00','Item',NULL,NULL,'no','4','FOUR PERCENT(4%)','20240724-000011','05:30:14 pm','2024 07 24','admin','1','  General','  Cash','1870.00','1870.00','32',NULL,NULL,NULL,NULL,'24 Jul 2024','2024072417:30:14','%','0','885.00','no','0.00',NULL,'202407241730','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Herbalife ','admin','madmin',NULL,NULL,'',NULL,'850.96','','','','',NULL,'850.96'),(47,'Afresh Tulasi ','1.0','885.00','885.00','Item',NULL,NULL,'no','4','FOUR PERCENT(4%)','20240724-000012','05:30:51 pm','2024 07 24','admin','1','  General','  Cash','1870.00','1870.00','33',NULL,NULL,NULL,NULL,'24 Jul 2024','2024072417:30:51','%','0','885.00','no','0.00',NULL,'202407241730','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Herbalife ','admin','madmin',NULL,NULL,'',NULL,'850.96','','','','',NULL,'850.96'),(48,'Afresh Peach ','1.0','885.00','885.00','Item',NULL,NULL,'no','4','FOUR PERCENT(4%)','20240724-000012','05:30:51 pm','2024 07 24','admin','1','  General','  Cash','1870.00','1870.00','34',NULL,NULL,NULL,NULL,'24 Jul 2024','2024072417:30:51','%','0','885.00','no','0.00',NULL,'202407241730','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Herbalife ','admin','madmin',NULL,NULL,'',NULL,'850.96','','','','',NULL,'850.96'),(49,'Delivery Charges ','1.0','100.00','100.00','Item',NULL,NULL,'no',NULL,NULL,'20240724-000012','05:30:51 pm','2024 07 24','admin','1','  General','  Cash','1870.00','1870.00','35',NULL,NULL,NULL,NULL,'24 Jul 2024','2024072417:30:51','%','0','100.00','no','0.00',NULL,'202407241730','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Herbalife ','admin','madmin',NULL,NULL,'',NULL,'100.00','','','','',NULL,'100.00'),(50,'sona masoori raw rice 1kg','1.0','56.00','56.00','Item',NULL,NULL,'no',NULL,NULL,'20240816-000011','03:10:03 PM','2024 08 16','admin','1','  General','  Pay Later','376.00','376.00','1',NULL,NULL,NULL,NULL,'16 Aug 2024','2024081615:10:03','%','0','56.00','no','0.00',NULL,'202408161510','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'rice whole grains','admin','madmin','300',NULL,'',NULL,'56.00','','','','',NULL,'56.00'),(51,'tata urad dal whole white 1kg','1.0','250.00','250.00','Item',NULL,NULL,'no',NULL,NULL,'20240816-000011','03:10:03 PM','2024 08 16','admin','1','  General','  Pay Later','376.00','376.00','2',NULL,NULL,NULL,NULL,'16 Aug 2024','2024081615:10:03','%','0','250.00','no','0.00',NULL,'202408161510','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'dals pulses','admin','madmin','300',NULL,'',NULL,'250.00','','','','',NULL,'250.00'),(52,'tortillas','1.0','70.00','70.00','Item',NULL,NULL,'no',NULL,NULL,'20240816-000011','03:10:03 PM','2024 08 16','admin','1','  General','  Pay Later','376.00','376.00','3',NULL,NULL,NULL,NULL,'16 Aug 2024','2024081615:10:03','%','0','70.00','no','0.00',NULL,'202408161510','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin','300',NULL,'',NULL,'70.00','','','','',NULL,'70.00'),(53,'burritos','1.0','52.00','52.00','Item',NULL,NULL,'no',NULL,NULL,'20240816-000012','03:11:39 pm','2024 08 16','admin','1','  General','  Pay Later','886.00','886.00','4',NULL,NULL,NULL,NULL,'16 Aug 2024','2024081615:11:39','%','0','52.00','no','0.00',NULL,'202408161511','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin','86',NULL,'',NULL,'52.00','','','','',NULL,'52.00'),(54,'fish sticks','1.0','40.00','40.00','Item',NULL,NULL,'no',NULL,NULL,'20240816-000012','03:11:39 pm','2024 08 16','admin','1','  General','  Pay Later','886.00','886.00','5',NULL,NULL,NULL,NULL,'16 Aug 2024','2024081615:11:39','%','0','40.00','no','0.00',NULL,'202408161511','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin','86',NULL,'',NULL,'40.00','','','','',NULL,'40.00'),(55,'pizza/pizza rolls','1.0','199.00','199.00','Item',NULL,NULL,'no',NULL,NULL,'20240816-000012','03:11:39 pm','2024 08 16','admin','1','  General','  Pay Later','886.00','886.00','6',NULL,NULL,NULL,NULL,'16 Aug 2024','2024081615:11:39','%','0','199.00','no','0.00',NULL,'202408161511','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin','86',NULL,'',NULL,'199.00','','','','',NULL,'199.00'),(56,'popsicles','1.0','145.00','145.00','Item',NULL,NULL,'no',NULL,NULL,'20240816-000012','03:11:39 pm','2024 08 16','admin','1','  General','  Pay Later','886.00','886.00','7',NULL,NULL,NULL,NULL,'16 Aug 2024','2024081615:11:39','%','0','145.00','no','0.00',NULL,'202408161511','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin','86',NULL,'',NULL,'145.00','','','','',NULL,'145.00'),(57,'juice concentrate','1.0','450.00','450.00','Item',NULL,NULL,'no',NULL,NULL,'20240816-000012','03:11:39 pm','2024 08 16','admin','1','  General','  Pay Later','886.00','886.00','8',NULL,NULL,NULL,NULL,'16 Aug 2024','2024081615:11:39','%','0','450.00','no','0.00',NULL,'202408161511','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin','86',NULL,'',NULL,'450.00','','','','',NULL,'450.00'),(58,'breakfasts','1.0','76.00','76.00','Item',NULL,NULL,'no',NULL,NULL,'20240817-000011','11:34:45 am','2024 08 17','admin','1','  General','  Cash','952.00','962.00','9',NULL,NULL,NULL,NULL,'17 Aug 2024','2024081711:34:45','%','0','76.00','no','0.00',NULL,'202408171134','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'',NULL,'76.00','','','','',NULL,'76.00'),(59,'burritos','1.0','52.00','52.00','Item',NULL,NULL,'no',NULL,NULL,'20240817-000011','11:34:45 am','2024 08 17','admin','1','  General','  Cash','952.00','962.00','10',NULL,NULL,NULL,NULL,'17 Aug 2024','2024081711:34:45','%','0','52.00','no','0.00',NULL,'202408171134','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'',NULL,'52.00','','','','',NULL,'52.00'),(60,'fish sticks','1.0','40.00','40.00','Item',NULL,NULL,'no',NULL,NULL,'20240817-000011','11:34:45 am','2024 08 17','admin','1','  General','  Cash','952.00','962.00','11',NULL,NULL,NULL,NULL,'17 Aug 2024','2024081711:34:45','%','0','40.00','no','0.00',NULL,'202408171134','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'',NULL,'40.00','','','','',NULL,'40.00'),(61,'popsicles','1.0','145.00','145.00','Item',NULL,NULL,'no',NULL,NULL,'20240817-000011','11:34:45 am','2024 08 17','admin','1','  General','  Cash','952.00','962.00','12',NULL,NULL,NULL,NULL,'17 Aug 2024','2024081711:34:45','%','0','145.00','no','0.00',NULL,'202408171134','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'',NULL,'145.00','','','','',NULL,'145.00'),(62,'pizza/pizza rolls','1.0','199.00','199.00','Item',NULL,NULL,'no',NULL,NULL,'20240817-000011','11:34:45 am','2024 08 17','admin','1','  General','  Cash','952.00','962.00','13',NULL,NULL,NULL,NULL,'17 Aug 2024','2024081711:34:45','%','0','199.00','no','0.00',NULL,'202408171134','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'',NULL,'199.00','','','','',NULL,'199.00'),(63,'juice concentrate','1.0','450.00','450.00','Item',NULL,NULL,'no',NULL,NULL,'20240817-000011','11:34:45 am','2024 08 17','admin','1','  General','  Cash','952.00','962.00','14',NULL,NULL,NULL,NULL,'17 Aug 2024','2024081711:34:45','%','0','450.00','no','0.00',NULL,'202408171134','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'',NULL,'450.00','','','','',NULL,'450.00'),(64,'sona masoori raw rice 1kg','1.0','56.00','56.00','Item',NULL,NULL,'no',NULL,NULL,'20240817-000012','11:35:10 am','2024 08 17','admin','1','  General','  Cash','514.00','544.00','15',NULL,NULL,NULL,NULL,'17 Aug 2024','2024081711:35:10','%','0','56.00','no','0.00',NULL,'202408171135','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'rice whole grains','admin','madmin',NULL,NULL,'',NULL,'56.00','','','','',NULL,'56.00'),(65,'tata urad dal whole white 1kg','1.0','250.00','250.00','Item',NULL,NULL,'no',NULL,NULL,'20240817-000012','11:35:10 am','2024 08 17','admin','1','  General','  Cash','514.00','544.00','16',NULL,NULL,NULL,NULL,'17 Aug 2024','2024081711:35:10','%','0','250.00','no','0.00',NULL,'202408171135','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'dals pulses','admin','madmin',NULL,NULL,'',NULL,'250.00','','','','',NULL,'250.00'),(66,'tortillas','1.0','70.00','70.00','Item',NULL,NULL,'no',NULL,NULL,'20240817-000012','11:35:10 am','2024 08 17','admin','1','  General','  Cash','514.00','544.00','17',NULL,NULL,NULL,NULL,'17 Aug 2024','2024081711:35:10','%','0','70.00','no','0.00',NULL,'202408171135','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'',NULL,'70.00','','','','',NULL,'70.00'),(67,'fish sticks','1.0','40.00','40.00','Item',NULL,NULL,'no',NULL,NULL,'20240817-000012','11:35:10 am','2024 08 17','admin','1','  General','  Cash','514.00','544.00','18',NULL,NULL,NULL,NULL,'17 Aug 2024','2024081711:35:10','%','0','40.00','no','0.00',NULL,'202408171135','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'',NULL,'40.00','','','','',NULL,'40.00'),(68,'burritos','1.0','52.00','52.00','Item',NULL,NULL,'no',NULL,NULL,'20240817-000012','11:35:10 am','2024 08 17','admin','1','  General','  Cash','514.00','544.00','19',NULL,NULL,NULL,NULL,'17 Aug 2024','2024081711:35:10','%','0','52.00','no','0.00',NULL,'202408171135','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'',NULL,'52.00','','','','',NULL,'52.00'),(69,'breakfasts','1.0','76.00','76.00','Item',NULL,NULL,'no',NULL,NULL,'20240817-000012','11:35:10 am','2024 08 17','admin','1','  General','  Cash','514.00','544.00','20',NULL,NULL,NULL,NULL,'17 Aug 2024','2024081711:35:10','%','0','76.00','no','0.00',NULL,'202408171135','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'',NULL,'76.00','','','','',NULL,'76.00'),(70,'Jeans 1050','3','1000.00','3000.00','Item','null','null','no','5','GST(5%)','20241023-000011','11:33:43 AM','2024 10 23','madmin','1','  General','  cash','0','0','1','null','null','null','null','23Oct24','2024102311:33:43','%','0','','','','test','2024102311:33:43','','','','','','','','','','All','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(71,'Cotton pants 950','2','904.78','1809.56','Item','null','null','no','5','GST(5%)','20241023-000011','11:33:43 AM','2024 10 23','madmin','1','  General','  cash','0','0','2','null','null','null','null','23Oct24','2024102311:33:43','%','0','','','','test','2024102311:33:43','','','','','','','','','','All','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(72,'Jeans 1050','2','1000.00','2000.00','Item','null','null','no','5','GST(5%)','20241023-000012','11:34:25 AM','2024 10 23','madmin','1','  General','  cash','0','0','1','null','null','null','null','23Oct24','2024102311:34:25','%','0','','','','test','2024102311:34:25','','','','','','','','','','All','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(73,'Cotton pants 950','3','904.78','2714.34','Item','null','null','no','5','GST(5%)','20241023-000012','11:34:25 AM','2024 10 23','madmin','1','  General','  cash','0','0','2','null','null','null','null','23Oct24','2024102311:34:25','%','0','','','','test','2024102311:34:25','','','','','','','','','','All','madmin','madmin','null','','','test','test','test','test','test','test',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,'20240711-000011','754.00','admin','2024 07 11','  Cash','  General','754.00','0.00','0.00','0.0','1','202407111214',NULL,NULL,NULL,NULL,NULL,NULL),(2,'20240711-000012','3000.00','admin','2024 07 11','  Cash','  General','3000.00','0.00','0.00','0.0','2','202407111223',NULL,NULL,NULL,NULL,NULL,NULL),(3,'20240711-000013','612.00','admin','2024 07 11','  Cash','  General','612.00','0.00','0.00','0.0','3','202407111256',NULL,NULL,NULL,NULL,NULL,NULL),(4,'20240712-000011','799.00','admin','2024 07 12','  Cash','  General','799.00','0.00','0.00','0.0','4','202407121153',NULL,NULL,NULL,NULL,NULL,NULL),(5,'20240712-000012','799.00','admin','2024 07 12','  Cash','  General','799.00','0.00','0.00','0.0','5','202407121154',NULL,NULL,NULL,NULL,NULL,NULL),(6,'20240715-000011','200.00','admin','2024 07 15','  Card','  General','200.00','0.00','0.00','0.0','6','202407151211',NULL,NULL,NULL,NULL,NULL,NULL),(7,'20240719-000011','2884.00','admin','2024 07 19','  Cash','  General','2884.00','577.00','0.00','0.0','7','202407191515',NULL,NULL,NULL,NULL,NULL,NULL),(8,'20240719-000012','7690.30','admin','2024 07 19','  Cash','  General','7690.30','865.50','0.00','0.0','8','202407191520',NULL,NULL,NULL,NULL,NULL,NULL),(9,'20240719-000013','3938.80','admin','2024 07 19','  Cash','  General','3938.80','865.50','0.00','0.0','9','202407191526',NULL,NULL,NULL,NULL,NULL,NULL),(10,'20240719-000014','3938.80','admin','2024 07 19','  Cash','  General','3938.80','865.50','0.00','0.0','10','202407191531',NULL,NULL,NULL,NULL,NULL,NULL),(11,'20240720-000011','384.00','admin','2024 07 20','  Cash','  General','384.00','0.00','0.00','0.0','11','202407201143',NULL,NULL,NULL,NULL,NULL,NULL),(12,'20240720-000012','6927.90','admin','2024 07 20','  Cash','  General','6927.90','329.90','0.00','0.0','12','202407201215',NULL,NULL,NULL,NULL,NULL,NULL),(13,'20240720-000013','3463.95','admin','2024 07 20','  Cash','  General','3463.95','164.95','0.00','0.0','13','202407201216',NULL,NULL,NULL,NULL,NULL,NULL),(14,'20240720-000014','10299.45','admin','2024 07 20','  Cash','  General','10299.45','490.45','0.00','0.0','14','202407201217',NULL,NULL,NULL,NULL,NULL,NULL),(15,'20240722-000011','7270.20','admin','2024 07 22','  Cash','  General','7270.20','346.20','0.00','0.0','15','202407221126',NULL,NULL,NULL,NULL,NULL,NULL),(16,'20240722-000012','1630.93','madmin','2024 07 22','  cash','  General','1568.200000','62.730000','0.000000','62.727999999999994','16','202407221247','','','','0','0',NULL),(17,'20240724-000011','1870.00','admin','2024 07 24','  Cash','  General','1870.00','68.08','0.00','0.0','17','202407241730',NULL,NULL,NULL,NULL,NULL,NULL),(18,'20240724-000012','1870.00','admin','2024 07 24','  Cash','  General','1870.00','68.08','0.00','0.0','18','202407241730',NULL,NULL,NULL,NULL,NULL,NULL),(19,'20240816-000011','376.00','admin','2024 08 16','  Pay Later','  General','376.00','0.00','0.00','0.0','19','202408161510',NULL,NULL,NULL,NULL,NULL,NULL),(20,'20240816-000012','886.00','admin','2024 08 16','  Pay Later','  General','886.00','0.00','0.00','0.0','20','202408161511',NULL,NULL,NULL,NULL,NULL,NULL),(21,'20240817-000011','952.00','admin','2024 08 17','  Cash','  General','962.00','0.00','0.00','0.0','21','202408171134',NULL,NULL,NULL,NULL,NULL,NULL),(22,'20240817-000012','514.00','admin','2024 08 17','  Cash','  General','544.00','0.00','0.00','0.0','22','202408171135',NULL,NULL,NULL,NULL,NULL,NULL),(23,'20241023-000011','5050.04','madmin','2024 10 23','  cash','  General','4809.560000','240.480000','0.000000','0','23','202410231133','','','','0','0',NULL),(24,'20241023-000012','4950.06','madmin','2024 10 23','  cash','  General','4714.340000','235.720000','0.000000','0','24','202410231134','','','','0','0',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 (1,'ABCD','1234567890','','',376,'300.0',NULL,NULL,NULL);
INSERT INTO `discountdetails` (`_id`, `date`, `time`, `billno`, `Discountcodeno`, `Discount_percent`, `Billamount_rupess`, `Discount_rupees`, `date1`, `original_amount`, `billcount`, `datetimee_new`, `paymentmethod`) VALUES (1,'2024 07 22','04:46:09 pm','20240722-000012','Diwali offer','10','1341.72','149.08','22 Jul 2024','1490.80',NULL,'202407221646',NULL),(2,'2024 08 17','11:34:45 am','20240817-000011','Disc 10','1.04','952.00','10','17 Aug 2024','962.00','21','202408171134',NULL),(3,'2024 08 17','11:35:10 am','20240817-000012','Disc30','5.51','514.00','30','17 Aug 2024','544.00','22','202408171135',NULL),(4,NULL,NULL,'20241023-000011',NULL,'0',NULL,'0',NULL,NULL,NULL,NULL,NULL),(5,NULL,NULL,'20241023-000012',NULL,'0',NULL,'0',NULL,NULL,NULL,NULL,NULL);
INSERT INTO `itemdata` (`_id`, `itemname`, `total`) VALUES (1,'fig fruit kg',250),(2,'ladies finger kg',28),(3,'nutella',170),(4,'sona masoori raw rice 1kg',56),(5,'tata urad dal whole white 1kg',250),(6,'Delivery Charges ',100),(7,'Dino shake ',1554),(8,'Test scan ',200),(9,'fig fruit kg',250),(10,'fish sticks',40),(11,'kurties set ',3000),(12,'ladies finger kg',28),(13,'nutella',170),(14,'sona masoori raw rice 1kg',280),(15,'tata urad dal whole white 1kg',1000),(16,'tortillas',70),(17,'urad black split 500g',110),(18,'urad black whole 500g',216),(19,'urad dal split 2kg',1182),(20,'urad gota whole 500g',198);
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,'4','fig fruit kg',250,33,'1','fruits and vegetables',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(2,'5','ladies finger kg',28,4,'1','fruits and vegetables',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(3,'3','nutella',170,23,'1','branded foods',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(4,'1','sona masoori raw rice 1kg',56,7,'1','rice whole grains',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(5,'2','tata urad dal whole white 1kg',250,33,'1','dals pulses',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(6,'1617','Delivery Charges ',100,0,'1','Herbalife ',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(7,'1617','Dino shake ',1554,3,'2','Herbalife ',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(8,'1603','Test scan ',200,0,'1','kids',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(9,'1603','fig fruit kg',250,1,'1','fruits and vegetables',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10,'314','fish sticks',40,0,'1','None',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(11,'1599','kurties set ',3000,6,'2','Adults',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(12,'1599','ladies finger kg',28,0,'1','fruits and vegetables',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(13,'1599','nutella',170,0,'1','branded foods',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(14,'1','sona masoori raw rice 1kg',280,1,'5','rice whole grains',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(15,'2','tata urad dal whole white 1kg',1000,2,'4','dals pulses',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(16,'311','tortillas',70,0,'1','None',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(17,'311','urad black split 500g',110,0,'1','dals and pulses',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(18,'311','urad black whole 500g',216,0,'2','dals and pulses',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(19,'311','urad dal split 2kg',1182,2,'3','dals and pulses',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(20,'311','urad gota whole 500g',198,0,'2','dals and pulses',NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO `top_category` (`_id`, `category`, `value`) VALUES (1,'branded foods',170),(2,'dals pulses',250),(3,'fruits and vegetables',278),(4,'rice whole grains',56),(5,'dals and pulses',108),(6,'dals pulses',250),(7,'rice whole grains',56),(8,'Herbalife ',7269),(9,'Adults',3000),(10,'Herbalife ',54657),(11,'None',110),(12,'branded foods',170),(13,'dals and pulses',1706),(14,'dals pulses',1000),(15,'fruits and vegetables',278),(16,'kids',200),(17,'rice whole grains',280),(18,'None',70),(19,'dals pulses',250),(20,'rice whole grains',56),(21,'None',1200),(22,'dals pulses',250),(23,'rice whole grains',56);
INSERT INTO `userdata` (`_id`, `username`, `total`) VALUES (1,'admin',754);
INSERT INTO `userwiseorderlistitems` (`_id`, `username`, `sales`, `salespercentage`) VALUES (1,'madmin',754,100);
