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,'bajaj oil 200ml','1','113.00','113.00','Item','null','null','no','null','None','20240831-000011','4:20:22 PM','2024 08 31','madmin','1','  General','  cash','0','0','197','null','null','null','null','31Aug24','2024083104:20:22','%','0','','','','test','2024083104:20:22','','null','null','null','null','null','null','null','null','personal care','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(2,'ladies finger kg','1','28.00','28.00','Item','null','null','no','null','None','20240831-000012','5:10:47 PM','2024 08 31','madmin','1','  General','  cash','0','0','5','null','null','null','null','31Aug24','2024083105:10:47','%','0','','','','test','2024083105:10:47','','null','null','null','null','null','null','null','null','fruits and vegetables','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(3,'capsicum green kg','1','80.00','80.00','Item','null','null','no','null','None','20240831-000012','5:10:47 PM','2024 08 31','madmin','1','  General','  cash','0','0','6','null','null','null','null','31Aug24','2024083105:10:47','%','0','','','','test','2024083105:10:47','','null','null','null','null','null','null','null','null','fruits and vegetables','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(4,'pears soap 125gms','1','55.00','55.00','Item','null','null','no','null','None','20240831-000012','5:10:47 PM','2024 08 31','madmin','1','  General','  cash','0','0','250','null','null','null','null','31Aug24','2024083105:10:47','%','0','','','','test','2024083105:10:47','','null','null','null','null','null','null','null','null','personal care','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(5,'capsicum green kg','1','80.00','80.00','Item','null','null','no','null','None','20240831-000013','5:21:08 PM','2024 08 31','madmin','1','  General','  cash','0','0','6','null','null','null','null','31Aug24','2024083105:21:008','%','0','','','','test','2024083105:21:008','','null','null','null','null','null','null','null','null','fruits and vegetables','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(6,'ladies finger kg','1','28.00','28.00','Item','null','null','no','null','None','20240831-000013','5:21:08 PM','2024 08 31','madmin','1','  General','  cash','0','0','5','null','null','null','null','31Aug24','2024083105:21:008','%','0','','','','test','2024083105:21:008','','null','null','null','null','null','null','null','null','fruits and vegetables','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(7,'sona masoori raw rice 1kg','1','56.00','56.00','Item','null','null','no','null','None','20240831-000014','5:28:35 PM','2024 08 31','madmin','1','  General','  cash','0','0','1','null','null','null','null','31Aug24','2024083105:28:35','%','0','','','','test','2024083105:28:35','','null','null','null','null','null','null','null','null','rice whole grains','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(8,'ladies finger kg','1','28.00','28.00','Item','null','null','no','null','None','20240831-000014','5:28:35 PM','2024 08 31','madmin','1','  General','  cash','0','0','5','null','null','null','null','31Aug24','2024083105:28:35','%','0','','','','test','2024083105:28:35','','null','null','null','null','null','null','null','null','fruits and vegetables','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(9,'sona masoori raw rice 1kg','2','56.00','112.00','Item','null','null','no','null','None','20240831-000015','5:31:00 PM','2024 08 31','madmin','1','  General','  cash','0','0','1','null','null','null','null','31Aug24','2024083105:31:000','%','0','','','','test','2024083105:31:000','','null','null','null','null','null','null','null','null','rice whole grains','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(10,'tata urad dal whole white 1kg','1','250.00','250.00','Item','null','null','no','null','None','20240831-000015','5:31:00 PM','2024 08 31','madmin','1','  General','  cash','0','0','2','null','null','null','null','31Aug24','2024083105:31:000','%','0','','','','test','2024083105:31:000','','null','null','null','null','null','null','null','null','dals pulses','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(11,'capsicum green kg','1','80.00','80.00','Item','null','null','no','null','None','20240831-000015','5:31:00 PM','2024 08 31','madmin','1','  General','  cash','0','0','6','null','null','null','null','31Aug24','2024083105:31:000','%','0','','','','test','2024083105:31:000','','null','null','null','null','null','null','null','null','fruits and vegetables','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(12,'sona masoori raw rice 1kg','1','56.00','56.00','Item','null','null','no','null','None','20240831-000016','5:32:23 PM','2024 08 31','madmin','1','  General','  cash','0','0','1','null','null','null','null','31Aug24','2024083105:32:23','%','0','','','','test','2024083105:32:23','','null','null','null','null','null','null','null','null','rice whole grains','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(13,'ladies finger kg','1','28.00','28.00','Item','null','null','no','null','None','20240831-000016','5:32:23 PM','2024 08 31','madmin','1','  General','  cash','0','0','5','null','null','null','null','31Aug24','2024083105:32:23','%','0','','','','test','2024083105:32:23','','null','null','null','null','null','null','null','null','fruits and vegetables','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(14,'ladies finger kg','1','28.00','28.00','Item','null','null','no','null','None','20240902-000011','1:13:37 PM','2024 09 02','madmin','1','  General','  cash','0','0','5','null','null','null','null','02Sep24','2024090201:13:37','%','0','','','','test','2024090201:13:37','','null','null','null','null','null','null','null','null','fruits and vegetables','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(15,'sona masoori raw rice 1kg','1','56.00','56.00','Item','null','null','no','null','None','20240902-000011','1:13:37 PM','2024 09 02','madmin','1','  General','  cash','0','0','1','null','null','null','null','02Sep24','2024090201:13:37','%','0','','','','test','2024090201:13:37','','null','null','null','null','null','null','null','null','rice whole grains','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(16,'ladies finger kg','','28.00','0','Item','null','null','no','null','None','20240902-000012','1:18:09 PM','2024 09 02','madmin','1','  General','  cash','0','0','5','null','null','null','null','02Sep24','2024090201:18:009','%','0','','','','test','2024090201:18:009','','null','null','null','null','null','null','null','null','fruits and vegetables','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(17,'beans kg','1.1','40.00','44.00','Item','null','null','no','null','None','20240902-000012','1:18:09 PM','2024 09 02','madmin','1','  General','  cash','0','0','9','null','null','null','null','02Sep24','2024090201:18:009','%','0','','','','test','2024090201:18:009','','null','null','null','null','null','null','null','null','fruits and vegetables','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(18,'tata urad dal whole white 1kg','1','250.00','250.00','Item','null','null','no','null','None','20240902-000012','1:18:09 PM','2024 09 02','madmin','1','  General','  cash','0','0','2','null','null','null','null','02Sep24','2024090201:18:009','%','0','','','','test','2024090201:18:009','','null','null','null','null','null','null','null','null','dals pulses','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(19,'beet root kg','1','32.00','32.00','Item','null','null','no','null','None','20240902-000012','1:18:09 PM','2024 09 02','madmin','1','  General','  cash','0','0','13','null','null','null','null','02Sep24','2024090201:18:009','%','0','','','','test','2024090201:18:009','','null','null','null','null','null','null','null','null','fruits and vegetables','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(20,'onions big kg','1','20.00','20.00','Item','null','null','no','null','None','20240902-000012','1:18:09 PM','2024 09 02','madmin','1','  General','  cash','0','0','14','null','null','null','null','02Sep24','2024090201:18:009','%','0','','','','test','2024090201:18:009','','null','null','null','null','null','null','null','null','fruits and vegetables','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(21,'ladies finger kg','1','28.00','28.00','Item','null','null','no','null','None','20240902-000013','1:53:32 PM','2024 09 02','madmin','1','  General','  cash','0','0','5','null','null','null','null','02Sep24','2024090201:53:32','%','0','','','','test','2024090201:53:32','','null','null','null','null','null','null','null','null','fruits and vegetables','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(22,'ladies finger kg','1','28.00','28.00','Item','null','null','no','null','None','20240902-000014','2:16:53 PM','2024 09 02','madmin','1','  General','  cash','0','0','5','null','null','null','null','02Sep24','2024090202:16:53','%','0','','','','test','2024090202:16:53','','null','null','null','null','null','null','null','null','fruits and vegetables','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(23,'ladies finger kg','1','28.00','28.00','Item','null','null','no','null','None','20240902-000015','2:17:19 PM','2024 09 02','madmin','1','  General','  cash','0','0','5','null','null','null','null','02Sep24','2024090202:17:19','%','0','','','','test','2024090202:17:19','','null','null','null','null','null','null','null','null','fruits and vegetables','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(24,'ladies finger kg','2','28.00','56','Item','null','null','no','null','None','20240902-000016','2:27:49 PM','2024 09 02','madmin','1','  General','  cash','0','0','5','null','null','null','null','02Sep24','2024090202:27:49','%','0','','','','test','2024090202:27:49','','null','null','null','null','null','null','null','null','fruits and vegetables','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(25,'sona masoori raw rice 1kg','1','56.00','56.00','Item','null','null','no','null','None','20240902-000017','2:35:16 PM','2024 09 02','madmin','1','  General','  cash','0','0','1','null','null','null','null','02Sep24','2024090202:35:16','%','0','','','','test','2024090202:35:16','','null','null','null','null','null','null','null','null','rice whole grains','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(26,'capsicum green kg','.5','80.00','40','Item','null','null','no','null','None','20240902-000017','2:35:16 PM','2024 09 02','madmin','1','  General','  cash','0','0','6','null','null','null','null','02Sep24','2024090202:35:16','%','0','','','','test','2024090202:35:16','','null','null','null','null','null','null','null','null','fruits and vegetables','madmin','madmin','null','','','test','test','test','test','test','test',NULL,NULL),(27,'sona masoori raw rice 1kg','1.0','56.00','56.00','Item',NULL,NULL,'no',NULL,NULL,'20240927-000011','03:44:05 PM','2024 09 27','admin','1','  General','  Cash','56.00','56.00','1',NULL,NULL,NULL,NULL,'27 Sep 2024','2024092715:44:05','%','0','56.00','no','0.00',NULL,'202409271544','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'rice whole grains','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(28,'loreal color 90gms','1.0','76.00','76.00','Item',NULL,NULL,'no',NULL,NULL,'20240927-000012','03:51:09 PM','2024 09 27','admin','1','  General','  Cash','76.00','76.00','2',NULL,NULL,NULL,NULL,'27 Sep 2024','2024092715:51:09','%','0','76.00','no','0.00',NULL,'202409271551','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'personal care','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(29,'carrots kg','1.0','70.00','70.00','Item',NULL,NULL,'no',NULL,NULL,'20240927-000013','03:54:33 PM','2024 09 27','admin','1','  General','  Cash','90.00','90.00','3',NULL,NULL,NULL,NULL,'27 Sep 2024','2024092715:54:33','%','0','70.00','no','0.00',NULL,'202409271554','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(30,'cucumbers kg','1.0','20.00','20.00','Item',NULL,NULL,'no',NULL,NULL,'20240927-000013','03:54:33 PM','2024 09 27','admin','1','  General','  Cash','90.00','90.00','4',NULL,NULL,NULL,NULL,'27 Sep 2024','2024092715:54:33','%','0','20.00','no','0.00',NULL,'202409271554','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(31,'carrots kg','1.0','70.00','70.00','Item',NULL,NULL,'no',NULL,NULL,'20240927-000014','03:54:54 PM','2024 09 27','admin','1','  General','  Cash','150.00','150.00','5',NULL,NULL,NULL,NULL,'27 Sep 2024','2024092715:54:54','%','0','70.00','no','0.00',NULL,'202409271554','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(32,'capsicum green kg','1.0','80.00','80.00','Item',NULL,NULL,'no',NULL,NULL,'20240927-000014','03:54:54 PM','2024 09 27','admin','1','  General','  Cash','150.00','150.00','6',NULL,NULL,NULL,NULL,'27 Sep 2024','2024092715:54:54','%','0','80.00','no','0.00',NULL,'202409271554','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(33,'capsicum green kg','1.0','80.00','80.00','Item',NULL,NULL,'no',NULL,NULL,'20240927-000015','03:57:51 PM','2024 09 27','admin','1','  General','  Cash','150.00','150.00','7',NULL,NULL,NULL,NULL,'27 Sep 2024','2024092715:57:51','%','0','80.00','no','0.00',NULL,'202409271557','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(34,'carrots kg','1.0','70.00','70.00','Item',NULL,NULL,'no',NULL,NULL,'20240927-000015','03:57:51 PM','2024 09 27','admin','1','  General','  Cash','150.00','150.00','8',NULL,NULL,NULL,NULL,'27 Sep 2024','2024092715:57:51','%','0','70.00','no','0.00',NULL,'202409271557','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(35,'capsicum green kg','1.0','80.00','80.00','Item',NULL,NULL,'no',NULL,NULL,'20240927-000016','04:03:07 PM','2024 09 27','admin','1','  General','  Cash','150.00','150.00','10',NULL,NULL,NULL,NULL,'27 Sep 2024','2024092716:03:07','%','0','80.00','no','0.00',NULL,'202409271603','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(36,'carrots kg','1.0','70.00','70.00','Item',NULL,NULL,'no',NULL,NULL,'20240927-000016','04:03:07 PM','2024 09 27','admin','1','  General','  Cash','150.00','150.00','11',NULL,NULL,NULL,NULL,'27 Sep 2024','2024092716:03:07','%','0','70.00','no','0.00',NULL,'202409271603','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(37,'cucumbers kg','1.0','20.00','20.00','Item',NULL,NULL,'no',NULL,NULL,'20240927-000017','04:06:50 PM','2024 09 27','admin','1','  General','  Cash','20.00','20.00','12',NULL,NULL,NULL,NULL,'27 Sep 2024','2024092716:06:50','%','0','20.00','no','0.00',NULL,'202409271606','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(38,'sona masoori raw rice 1kg','1.0','56.00','56.00','Item',NULL,NULL,'no',NULL,NULL,'20240927-000018','04:09:41 PM','2024 09 27','admin','1','  General','  Cash','56.00','56.00','13',NULL,NULL,NULL,NULL,'27 Sep 2024','2024092716:09:41','%','0','56.00','no','0.00',NULL,'202409271609','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'rice whole grains','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(39,'sona masoori raw rice 1kg','1.0','56.00','56.00','Item',NULL,NULL,'no',NULL,NULL,'20240927-000019','04:13:18 PM','2024 09 27','admin','1','  General','  Cash','56.00','56.00','13',NULL,NULL,NULL,NULL,'27 Sep 2024','2024092716:13:18','%','0','56.00','no','0.00',NULL,'202409271613','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'rice whole grains','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(40,'sona masoori raw rice 1kg','1.0','56.00','56.00','Item',NULL,NULL,'no',NULL,NULL,'20240927-0000110','04:20:57 PM','2024 09 27','admin','1','  General','  Cash','56.00','56.00','13',NULL,NULL,NULL,NULL,'27 Sep 2024','2024092716:20:57','%','0','56.00','no','0.00',NULL,'202409271620','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'rice whole grains','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(41,'loreal color 90gms','1.0','76.00','76.00','Item',NULL,NULL,'no',NULL,NULL,'20240928-000011','11:49:07 AM','2024 09 28','admin','1','  General','  Cash','96.00','96.00','14',NULL,NULL,NULL,NULL,'28 Sep 2024','2024092811:49:07','%','0','76.00','no','0.00',NULL,'202409281149','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'personal care','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(42,'cucumbers kg','1.0','20.00','20.00','Item',NULL,NULL,'no',NULL,NULL,'20240928-000011','11:49:07 AM','2024 09 28','admin','1','  General','  Cash','96.00','96.00','15',NULL,NULL,NULL,NULL,'28 Sep 2024','2024092811:49:07','%','0','20.00','no','0.00',NULL,'202409281149','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(43,'capsicum green kg','1.0','80.00','80.00','Item',NULL,NULL,'no',NULL,NULL,'20240928-000012','12:01:02 PM','2024 09 28','admin','1','  General','  Cash','150.00','150.00','16',NULL,NULL,NULL,NULL,'28 Sep 2024','2024092812:01:02','%','0','80.00','no','0.00',NULL,'202409281201','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(44,'carrots kg','1.0','70.00','70.00','Item',NULL,NULL,'no',NULL,NULL,'20240928-000012','12:01:02 PM','2024 09 28','admin','1','  General','  Cash','150.00','150.00','17',NULL,NULL,NULL,NULL,'28 Sep 2024','2024092812:01:02','%','0','70.00','no','0.00',NULL,'202409281201','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(45,'sona masoori raw rice 1kg','1.0','56.00','56.00','Item',NULL,NULL,'no',NULL,NULL,'20240928-000013','12:03:38 PM','2024 09 28','admin','1','  General','  Cash','56.00','56.00','18',NULL,NULL,NULL,NULL,'28 Sep 2024','2024092812:03:38','%','0','56.00','no','0.00',NULL,'202409281203','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'rice whole grains','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(46,'sona masoori raw rice 1kg','1.0','56.00','56.00','Item',NULL,NULL,'no',NULL,NULL,'20240928-000014','12:12:07 PM','2024 09 28','admin','1','  General','  Cash','56.00','56.00','19',NULL,NULL,NULL,NULL,'28 Sep 2024','2024092812:12:07','%','0','56.00','no','0.00',NULL,'202409281212','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'rice whole grains','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(47,'sona masoori raw rice 1kg','1.0','56.00','56.00','Item',NULL,NULL,'no',NULL,NULL,'20240928-000015','12:14:09 PM','2024 09 28','admin','1','  General','  Cash','56.00','56.00','20',NULL,NULL,NULL,NULL,'28 Sep 2024','2024092812:14:09','%','0','56.00','no','0.00',NULL,'202409281214','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'rice whole grains','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(48,'beet root kg','1.0','32.00','32.00','Item',NULL,NULL,'no',NULL,NULL,'20240928-000016','12:18:45 PM','2024 09 28','admin','1','  General','  Cash','32.00','32.00','21',NULL,NULL,NULL,NULL,'28 Sep 2024','2024092812:18:45','%','0','32.00','no','0.00',NULL,'202409281218','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(49,'tata urad dal whole white 1kg','1.0','250.00','250.00','Item',NULL,NULL,'no',NULL,NULL,'20240928-000017','12:20:09 PM','2024 09 28','admin','1','  General','  Cash','282.00','282.00','22',NULL,NULL,NULL,NULL,'28 Sep 2024','2024092812:20:09','%','0','250.00','no','0.00',NULL,'202409281220','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'dals pulses','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(50,'potatoes kg','1.0','32.00','32.00','Item',NULL,NULL,'no',NULL,NULL,'20240928-000017','12:20:09 PM','2024 09 28','admin','1','  General','  Cash','282.00','282.00','23',NULL,NULL,NULL,NULL,'28 Sep 2024','2024092812:20:09','%','0','32.00','no','0.00',NULL,'202409281220','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(51,'sona masoori raw rice 1kg','1.0','56.00','56.00','Item',NULL,NULL,'no',NULL,NULL,'20240928-000018','12:41:09 PM','2024 09 28','admin','1','  General','  Cash','306.00','306.00','1',NULL,NULL,NULL,NULL,'28 Sep 2024','2024092812:41:09','%','0','56.00','no','0.00',NULL,'202409281241','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'rice whole grains','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(52,'tata urad dal whole white 1kg','1.0','250.00','250.00','Item',NULL,NULL,'no',NULL,NULL,'20240928-000018','12:41:09 PM','2024 09 28','admin','1','  General','  Cash','306.00','306.00','2',NULL,NULL,NULL,NULL,'28 Sep 2024','2024092812:41:09','%','0','250.00','no','0.00',NULL,'202409281241','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'dals pulses','admin','madmin',NULL,NULL,'',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,'20240831-000011','113.00','madmin','2024 08 31','  cash','  General','113.000000','0.000000','0.000000','0','1','202408311620','','','','0','0',NULL),(2,'20240831-000012','163.00','madmin','2024 08 31','  cash','  General','163.000000','0.000000','0.000000','0','2','202408311710','','','','0','0',NULL),(3,'20240831-000013','108.00','madmin','2024 08 31','  cash','  General','108.000000','0.000000','0.000000','0','3','202408311721','','','','0','0',NULL),(4,'20240831-000014','84.00','madmin','2024 08 31','  cash','  General','84.000000','0.000000','0.000000','0','4','202408311728','','','','0','0',NULL),(5,'20240831-000015','442.00','madmin','2024 08 31','  cash','  General','442.000000','0.000000','0.000000','0','5','202408311731','','','','0','0',NULL),(6,'20240831-000016','84.00','madmin','2024 08 31','  cash','  General','84.000000','0.000000','0.000000','0','6','202408311732','','','','0','0',NULL),(7,'20240902-000011','84.00','madmin','2024 09 02','  cash','  General','84.000000','0.000000','0.000000','0','7','202409021313','','','','0','0',NULL),(8,'20240902-000012','346.00','madmin','2024 09 02','  cash','  General','346.000000','0.000000','0.000000','0','8','202409021318','','','','0','0',NULL),(9,'20240902-000013','28.00','madmin','2024 09 02','  cash','  General','28.000000','0.000000','0.000000','0','9','202409021353','','','','0','0',NULL),(10,'20240902-000014','28.00','madmin','2024 09 02','  cash','  General','28.000000','0.000000','0.000000','0','10','202409021416','','','','0','0',NULL),(11,'20240902-000015','28.00','madmin','2024 09 02','  cash','  General','28.000000','0.000000','0.000000','0','11','202409021417','','','','0','0',NULL),(12,'20240902-000016','56.00','madmin','2024 09 02','  cash','  General','56.000000','0.000000','0.000000','0','12','202409021427','','','','0','0',NULL),(13,'20240902-000017','96.00','madmin','2024 09 02','  cash','  General','96.000000','0.000000','0.000000','0','13','202409021435','','','','0','0',NULL),(14,'20240927-000011','56.00','admin','2024 09 27','  Cash','  General','56.00','0.00','0.00','0.0','14','202409271544',NULL,NULL,NULL,NULL,NULL,NULL),(15,'20240927-000012','76.00','admin','2024 09 27','  Cash','  General','76.00','0.00','0.00','0.0','15','202409271551',NULL,NULL,NULL,NULL,NULL,NULL),(16,'20240927-000013','90.00','admin','2024 09 27','  Cash','  General','90.00','0.00','0.00','0.0','16','202409271554',NULL,NULL,NULL,NULL,NULL,NULL),(17,'20240927-000014','150.00','admin','2024 09 27','  Cash','  General','150.00','0.00','0.00','0.0','17','202409271554',NULL,NULL,NULL,NULL,NULL,NULL),(18,'20240927-000015','150.00','admin','2024 09 27','  Cash','  General','150.00','0.00','0.00','0.0','18','202409271557',NULL,NULL,NULL,NULL,NULL,NULL),(19,'20240927-000016','150.00','admin','2024 09 27','  Cash','  General','150.00','0.00','0.00','0.0','19','202409271603',NULL,NULL,NULL,NULL,NULL,NULL),(20,'20240927-000017','20.00','admin','2024 09 27','  Cash','  General','20.00','0.00','0.00','0.0','20','202409271606',NULL,NULL,NULL,NULL,NULL,NULL),(21,'20240927-000018','56.00','admin','2024 09 27','  Cash','  General','56.00','0.00','0.00','0.0','21','202409271609',NULL,NULL,NULL,NULL,NULL,NULL),(22,'20240927-000019','56.00','admin','2024 09 27','  Cash','  General','56.00','0.00','0.00','0.0','22','202409271613',NULL,NULL,NULL,NULL,NULL,NULL),(23,'20240927-0000110','56.00','admin','2024 09 27','  Cash','  General','56.00','0.00','0.00','0.0','23','202409271620',NULL,NULL,NULL,NULL,NULL,NULL),(24,'20240928-000011','96.00','admin','2024 09 28','  Cash','  General','96.00','0.00','0.00','0.0','24','202409281149',NULL,NULL,NULL,NULL,NULL,NULL),(25,'20240928-000012','150.00','admin','2024 09 28','  Cash','  General','150.00','0.00','0.00','0.0','25','202409281201',NULL,NULL,NULL,NULL,NULL,NULL),(26,'20240928-000013','56.00','admin','2024 09 28','  Cash','  General','56.00','0.00','0.00','0.0','26','202409281203',NULL,NULL,NULL,NULL,NULL,NULL),(27,'20240928-000014','56.00','admin','2024 09 28','  Cash','  General','56.00','0.00','0.00','0.0','27','202409281212',NULL,NULL,NULL,NULL,NULL,NULL),(28,'20240928-000015','56.00','admin','2024 09 28','  Cash','  General','56.00','0.00','0.00','0.0','28','202409281214',NULL,NULL,NULL,NULL,NULL,NULL),(29,'20240928-000016','32.00','admin','2024 09 28','  Cash','  General','32.00','0.00','0.00','0.0','29','202409281218',NULL,NULL,NULL,NULL,NULL,NULL),(30,'20240928-000017','282.00','admin','2024 09 28','  Cash','  General','282.00','0.00','0.00','0.0','30','202409281220',NULL,NULL,NULL,NULL,NULL,NULL),(31,'20240928-000018','306.00','admin','2024 09 28','  Cash','  General','306.00','0.00','0.00','0.0','31','202409281241',NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO `clicked_cust_name` (`_id`, `name`) VALUES (1,'');
